Hi,
I have below dataframe, I want to melt all columns to one column. I use below code, but some thing I am missing
I have below dataframe, I want to melt all columns to one column. I use below code, but some thing I am missing
import pandas as pd df = pd.DataFrame({'ID':['A1','A2','A1'],\ 'Estart':[1,2,3],\ 'Eend':[4,4,5],\ 'Rstart':[1,2,1],\ 'Rend':[1,6,5]}) pd.melt(df, id_vars=['ID'], value_vars=['Estart','Eend','Rstart','Rend'])Igot the below outputL
ID variable value 0 A1 Estart 1 1 A2 Estart 4 2 A1 Estart 3 3 A1 Eend 4 4 A2 Eend 4 5 A1 Eend 5 6 A1 Rstart 1 7 A2 Rstart 2 8 A1 Rstart 1 9 A1 Rend 1 10 A2 Rend 6 11 A1 Rend 5I want as below: Some help how to arrange ad below:
ID variable value A1 Estart 1 A1 Eend 4 A1 Rstart 1 A1 Rend 1 A2 Estart 2 A2 Eend 4 A2 Rstart 2 A2 Rend 6 A1 Estart 3 A1 Eend 5 A1 Rstart 1 A1 Rend 5