DOC: enhance pivot / reshape docs
nice questions and answers here: https://stackoverflow.com/questions/47152691/how-to-pivot-a-dataframe by piRsquared.

Would be nice to update our offical docs with some of these examples / tip & tricks. Maybe even use the Q & A format.