How to pivot a Pandas Dataframe - separate row for columns

Question

I have csv file that I am reading into Pandas Data Frame in the following format:

Number|Name |v1|v2|v3|v4
100000|Name1|value1|value2|value3|value4
200000|Name2|value1|value2|value3|value4
300000|Name3|value1|value2|value3|value4

I would like to pivot it, so I have a separate row for each value with Number and Name:

Number| Name | values |
100000| Name1| value1 |
100000| Name1| value2 |
100000| Name1| value3 |
100000| Name1| value4 |
200000| Name2| value1 |
200000| Name2| value2 |
200000| Name2| value3 |
200000| Name2| value4 |
....

https://pandas.pydata.org/docs/reference/api/pandas.melt.html — CJR, Dec 01 '21 at 15:29
This is more *unpivot*, aka, `melt` or `unstack` as previously commented. — Quang Hoang, Dec 01 '21 at 15:30

score 0 · Answer 1 · answered Dec 01 '21 at 15:29

0

Try:

pd.melt(df,id_vars=['Number','Name'], value_vars=['v1','v2','v3','v4'])

answered Dec 01 '21 at 15:29

Learning is a mess

7,479
7
35
71

How to pivot a Pandas Dataframe - separate row for columns

1 Answers1