Create multiple rows from several column indexes

Question

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!

Answer 1

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