Reformat multi-index columns in dataframe

Question

I have a multi-index columns df as below

  stock1        stock2        stock3       
   price volume  price volume  price volume
0      1      2      3      4      5      6
1      2      3      4      5      6      7

I want to reformat it in such a way that it looks like below

df

   price                      volume           
   stock1 stock2 stock3 stock1 stock2 stock3
0      1      3      5      2      4      6
1      2      4      6      3      5      7

How can I achieve it in pandas.

Thanks

jezrael · Accepted Answer · 2021-09-21 12:32:57Z

2

Use DataFrame.swaplevel with DataFrame.sort_index:

df = df.swaplevel(1, 0, axis=1).sort_index(axis=1)

answered Sep 21, 2021 at 12:32

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Reformat multi-index columns in dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related