Rearrange a dataFrame in python

Question

I am on a code in python and I would like to transform this dataFrame :

Before:

Into this DataFrame :

I tried to pivot the table with the command :

pd.pivot_table(mytable, index = [JAN, FEB, MAR])

But I am not satisfied by the result...

please show the code instead of pictures for input and desired output — FLab
– FLab, Commented Apr 12, 2017 at 15:46

zipa · Accepted Answer · 2017-04-12 16:07:50Z

2

This should work:

df = pd.melt(df, id_vars=['Word'], value_vars=['JAN', 'FEB', 'MAR']).dropna()
df = df.pivot(index='variable', columns='value', values='Word')

answered Apr 12, 2017 at 16:07

zipa

28k6 gold badges45 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1