How to transpose only 2 columns in python

Asked Apr 02 '20 at 07:35

Active Apr 02 '20 at 07:35

Viewed 16 times

I currently have the table like this

I want it changed to :

I tried using df.melt(['genre'], var_name='Date', value_name='Value') but it's not giving the correct answer.

asked Apr 02 '20 at 07:35

user9127741

1

`pd.crosstab(df.genre,df.year,df.pop_median,aggfunc=lambda x : x)` or pivot table, you can also look into unstack – Umar.H Apr 02 '20 at 07:39
2

I think here is necessary use `pivot` – jezrael Apr 02 '20 at 07:41

0 Answers0