I got a pandas dataframe which looks like the following picture:
Every year is a new column, but i want them in one column called year.
It should look similar like this dataframe:
Anybody got an idea, how i can achieve this? Thanks!
CodePudding user response:
you need to use the melt method, something like this
df2 = df.melt(id_vars=['country','continent'], var_name="year", value_vars=[str(x) for x in range(1850,2011)])