Sorting Multi Index in Pandas differently for each level

Question

I have a dataframe with an index of 3 levels. I need to sort the index by each level but in different ways. What can achieve this?

Have a dataframe (df) as:

                     other columns
color shape    count              
red   circle   1                 x
      triangle 3                 x
               2                 x
blue  circle   4                 x
      triangle 2                 x

and I want a new df where color is sorted ascending, shape is descending, and count is ascending:

                     other columns
color shape       count              
blue  triangle    2                 x
      circle      4                 x
red   triangle    2                 x
                  3                 x
      circle      1                 x

Scott Boston · Accepted Answer · 2018-06-18 19:38:33Z

8

Use ascending parameter with a list of booleans:

df.sort_index(ascending=[True, False, True])

Output:

                     other columns
color shape    count              
blue  triangle 2                 x
      circle   4                 x
red   triangle 2                 x
               3                 x
      circle   1                 x

edited Jun 18, 2018 at 19:38

answered Jun 18, 2018 at 19:32

Scott Boston

154k15 gold badges160 silver badges207 bronze badges

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

Collectives™ on Stack Overflow

Sorting Multi Index in Pandas differently for each level

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