How can I transfer columns of a table to rows in python?-CodePudding

One ID can have multiple dates and results and I want each date and result column stacked sideways to be stacked into 1 date and 1 result row. How can I transfer columns of a table to rows?

[Table which needs to be transposed] enter image description here

[I want to change like this] enter image description here

CodePudding user response：

This seems to work, not sure if it's the best solution:

    df2 = pd.concat([df.loc[:,['ID','Date','Result']],
             df.loc[:,['ID','Date1','Result1']].rename(columns={'Date1':'Date','Result1':'Result'}),
             df.loc[:,['ID','Date2','Result2']].rename(columns={'Date2':'Date','Result2':'Result'})
            ]).dropna().sort_values(by = 'ID')

It's just separating the dataframes, concatenating them together inline, removing the NAs and then sorting.

CodePudding user response：

If you are looking to transpose data from pandas you could use pandas.DataFrame.pivot There are more examples there on the syntax.