How to convert column values to multiple rows for a csv in python

user_13024743 0
Viewed 87
check_NUMBER,2021-12-01,2022-01-01,2022-02-01
1000M,24,17,22
1000M,24,83,55

This is my example data. I want to convert it into:

check_NUMBER,dates,values
1000M,2021-12-01,24
1000M,2021-12-01,17
1000M,2021-12-01,22
1000M,2022-02-01,24
1000M,2022-02-01,83
1000M,2022-02-01,55

I am unable to achieve this. Can someone explain how we can do that.

pandas dataframe python-3.x numpy python
1 Answers

Use df.melt

Code

df.melt(id_vars='check_NUMBER', var_name='dates', value_name='values')

Output

check_NUMBER    dates   values
0   1000M   2021-12-01  24
1   1000M   2021-12-01  24
2   1000M   2022-01-01  17
3   1000M   2022-01-01  83
4   1000M   2022-02-01  22
5   1000M   2022-02-01  55
user_21069340
Related