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:

Thank you very much!

Mohammadreza Riahi · Accepted Answer · 2021-12-01 13:12:59Z

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

answered Dec 1, 2021 at 13:04

6422 gold badges9 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thank you very much! Easier than I thought..