API: Gather and other inspiration from tidyr
http://connor-johnson.com/2014/08/28/tidyr-and-pandas-gather-and-melt/ 

In the spirit of the excellent assign method, wondering if there is support for some tidyr style transformations?
