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)])