
        
        
            
                
                
                    index = [("B", "bob"), ("B", "cathy"),("A", "david"),("A","alice")]
multi_index = pd.MultiIndex.from_tuples(index)
df = pd.DataFrame({"age":[2,3,4,5],"height":[6,7,8,9]}, index=multi_index)
df
                
            
                       age   height
B   bob     2       6
    cathy   3       7
A   david   4       8
    alice   5       9

Sorting all levels

To sort all levels:


        
        
            
                
                
                    df.sort_index()
                
            
                        age   height
A   alice    5      9
    david    4      8
B   bob      2      6
    cathy    3      7

Notice how levels are sorted starting from the first level.

Specifying levels to sort

To sort just the outermost level:


        
        
            
                
                
                    df.sort_index(level=0)
                
            
                       age   height
A   alice   5      9
    david   4      8
B   bob     2      6
    cathy   3      7

Although not mentioned in the official documentation, values at higher levels get sorted as well, as can be seen from alice now appearing before david.

To sort level 1 instead:


        
        
            
                
                
                    df.sort_index(level=1)
                
            
                        age   height
A   alice   5       9
B   bob     2       6
    cathy   3       7
A   david   4       8

Published by Isshin Inada

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!