Create multiple rows from several column indexes

user_17562098 0
Viewed 77

Please can you help me? This is the structure of my origin dataset:

Country 2020 2021
Ecuador Value1 Value2
Canada Value1 Value2

And i would like to get this structure, so the year is a index itself and not multiple columns:

Country Year Index
Ecuador 2020 Value1
Ecuador 2021 Value2
Canada 2020 Value1
Canada 2021 Value2

Thank you very much!

pandas python-2.7 dataframe
1 Answers

Your question is similar to this question. You can use the melt method of pandas

df.melt(id_vars=['Country'], var_name='Year', value_name='Index')

the output is:

      Country  Year  Index
   0  Ecuador  2020  Value1
   1   Canada  2020  Value1
   2  Ecuador  2021  Value2
   3   Canada  2021  Value2
user_56419240
Related