How (best) to transform a huge DataFrame into wide-format

[rocco_sprmnt21]

@Dan

Combining stack, unstack and select can really do most of the pivoting wizardry from Excel and friends.

a similar approach (exactly reversed, in fact) for another problem