Transpose Columns In Python/pandas

I'm trying to rearrange a dataframe with 5 variables Data columns (total 7 columns): Nane 3966 non-null values Value1 3966 non-null values Value2 3966 non-null values

Solution 1:

You want to use the Period as an index. set_index will do this for you. Then you can transpose your resulting table:

df.set_index('Period').T
Out[13]: 
Period         2010         2011         2012
Name            foo          bar          nil
Value1  0,994369885   0,92930566  0,997754262
Value2  0,780942307  0,274566936  0,488064461
Value3  0,510782105  0,390724018  0,642086396
Value4  0,842522334  0,613705323  0,028703768
Value5  0,383279727  0,287280101  0,764773601