Pandas pivot any columns to rows

Asked Aug 31 '21 at 00:44

Active Aug 31 '21 at 00:47

Viewed 15 times

Does anyone have any idea how to do this in Pandas?

I have this data frame:

Uf  IBGE    CNES    2020    2021
ES  320120  2547678 2747    2916
ES  320120  2485656 1817    2071
ES  320120  3125416 2965    3156

And I need it to look like this:

Uf  IBGE    CNES    value   year
ES  320120  2547678 2747    2020
ES  320120  2485656 1817    2020
ES  320120  3125416 2965    2020
ES  320120  2547678 2916    2021
ES  320120  2485656 2071    2021
ES  320120  3125416 3156    2021

Tks!

edited Aug 31 '21 at 00:47

U13-Forward

69,221
14
89
114

asked Aug 31 '21 at 00:44

TiagoAssun

Check the solutions of problem 1 and problem 2 in the dupe link – U13-Forward Aug 31 '21 at 00:47
`df.melt(id_vars=['Uf', 'IBGE', 'CNES'], var_name='year')` – Henry Ecker Aug 31 '21 at 00:51

Pandas pivot any columns to rows

0 Answers0