How to unpivot a pandas dataframe based on some grouped column?

Question

I am trying to unpivot this below dataframe.

My dataframe:

Output

score 3 · Answer 1 · answered Feb 28 '19 at 08:52

3

You're looking for pd.melt:

df.melt(id_vars=['id', 'col1', 'col2'])

   id col1 col2 variable  value
0   1    a    e     val1      3
1   1    a    e     val2      7

answered Feb 28 '19 at 08:52

yatu

1 Answers1