Pandas Transpose part of dataframe

user_19535129 0
Viewed 30

I try to transpose a part of dataframe but I don't if I can have the result needed.

My df is like (excel extract):

code A code B June July August
324325 3243. 0,3. 0,5. 0,4.
884543 7954. 0,1. 0,5. 0,43.

And I try to have:

code A code B Month Value
324325 3243. June 0,3.
324325 3243. July 0,5.
324325 3243. August 0,4.
884543 7954. June 0,1.
884543 7954. July 0,5.
884543 7954. August 0,43.

Is it possible to have it by easy way in pandas of I have to do some code ?

transpose dataframe
1 Answers

Your transpose is a dataframe melt here:

pd.melt(df, id_vars=['code A', 'code B'], value_vars=['June', 'July', 'August'], var_name='Month')
user_32754640
Related