Sorting MultiIndex in Pandas

Introduction

Sorting a MultiIndex helps organize complex data with multiple levels, making it easier to read and analyze.

You have a table with rows grouped by categories and subcategories and want to order them.

You want to prepare data for reports where hierarchical sorting is needed.

You need to quickly find data by sorting multiple index levels.

You want to visualize data with a clear order on multiple grouping levels.

Syntax

Pandas

DataFrame.sort_index(level=None, ascending=True, inplace=False, sort_remaining=True)

level specifies which index levels to sort. Use names or numbers.

ascending can be a bool or list of bools to control order per level.

Examples

Sorts the DataFrame by all index levels in ascending order.

Pandas

df.sort_index()

Sorts only the first index level in descending order.

Pandas

df.sort_index(level=0, ascending=False)

Sorts first level ascending and second level descending.

Pandas

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

Sample Program

This code creates a DataFrame with a MultiIndex of letters and numbers. It shows the original order, then sorts by both index levels ascending, and finally sorts with the first level ascending and second level descending.

Pandas

import pandas as pd

# Create a MultiIndex DataFrame
index = pd.MultiIndex.from_tuples(
    [('A', 2), ('A', 1), ('B', 2), ('B', 1)],
    names=['letter', 'number']
)
data = {'value': [10, 20, 30, 40]}
df = pd.DataFrame(data, index=index)

print('Original DataFrame:')
print(df)

# Sort by both levels ascending
sorted_df = df.sort_index()
print('\nSorted DataFrame by both levels ascending:')
print(sorted_df)

# Sort by first level ascending, second level descending
sorted_df2 = df.sort_index(level=['letter', 'number'], ascending=[True, False])
print('\nSorted DataFrame by first level ascending, second level descending:')
print(sorted_df2)

Important Notes

If you do not specify level, all index levels are sorted.

Use inplace=True to modify the DataFrame directly without creating a new one.

Sorting MultiIndex helps when you want to group and order data clearly for analysis or visualization.

Summary

Sorting MultiIndex organizes data by multiple index levels.

You can sort all levels or select specific ones.

Control ascending or descending order per level.

Practice

1. What does sorting a MultiIndex in pandas do?

easy

A. It removes duplicate rows from the DataFrame.

B. It merges multiple DataFrames into one.

C. It changes the data types of the index levels.

D. It arranges the data based on one or more index levels in order.

Solution

1. Step 1: Understand MultiIndex structure

   A MultiIndex has multiple levels that can be sorted independently or together.

2. Step 2: Define sorting effect

   Sorting organizes rows by the values in these index levels, making data easier to analyze.

3. Final Answer:

   It arranges the data based on one or more index levels in order. -> Option D

4. Quick Check:

   Sorting MultiIndex = Arrange by index levels [OK]

Hint: Sorting MultiIndex orders data by index levels [OK]

Common Mistakes:

• Confusing sorting with removing duplicates
• Thinking sorting changes data types
• Mixing sorting with merging DataFrames

2. Which of the following is the correct syntax to sort a pandas DataFrame df by its MultiIndex?

easy

A. df.sort(level=[0,1], ascending=[True, False])

B. df.sort_values(by=['level_0', 'level_1'])

C. df.sort_index(level=[0,1], ascending=[True, False])

D. df.sort_index(by=['level_0', 'level_1'])

Solution

1. Step 1: Recall sorting MultiIndex method

   Use sort_index() to sort by index levels, specifying levels and order.

2. Step 2: Check syntax correctness

   df.sort_index(level=[0,1], ascending=[True, False]) correctly uses sort_index(level=[0,1], ascending=[True, False]). Others use wrong methods or parameters.

3. Final Answer:

   df.sort_index(level=[0,1], ascending=[True, False]) -> Option C

4. Quick Check:

   sort_index with level and ascending = correct syntax [OK]

Hint: Use sort_index(level=..., ascending=...) for MultiIndex [OK]

Common Mistakes:

• Using sort_values instead of sort_index for MultiIndex
• Passing 'by' parameter to sort_index
• Using deprecated sort() method

3. Given the following code, what will be the order of the MultiIndex after sorting?

import pandas as pd
index = pd.MultiIndex.from_tuples([('b', 2), ('a', 3), ('b', 1), ('a', 2)])
df = pd.DataFrame({'value': [10, 20, 30, 40]}, index=index)
sorted_df = df.sort_index(level=[0,1], ascending=[True, False])
print(sorted_df.index.tolist())

medium

A. [('a', 3), ('a', 2), ('b', 2), ('b', 1)]

B. [('a', 2), ('a', 3), ('b', 1), ('b', 2)]

C. [('b', 1), ('b', 2), ('a', 2), ('a', 3)]

D. [('b', 2), ('b', 1), ('a', 3), ('a', 2)]

Solution

1. Step 1: Understand sorting parameters

   Level 0 sorted ascending (a before b), level 1 descending (higher number first).

2. Step 2: Apply sorting to tuples

   For 'a': (3,2) sorted descending gives (3), then (2). For 'b': (2,1) sorted descending gives (2), then (1).

3. Final Answer:

   [('a', 3), ('a', 2), ('b', 2), ('b', 1)] -> Option A

4. Quick Check:

   Level 0 asc, Level 1 desc = [('a',3),('a',2),('b',2),('b',1)] [OK]

Hint: Sort level 0 ascending, level 1 descending to get correct order [OK]

Common Mistakes:

• Sorting both levels ascending by default
• Confusing ascending order for level 1
• Not matching index tuples correctly

4. You run this code but get an error:

df.sort_index(level=[0,1], ascending=True, inplace=True)

What is the likely cause?

medium

A. The 'ascending' parameter must be a list when sorting multiple levels.

B. The 'inplace' parameter is not supported in sort_index.

C. The 'level' parameter cannot accept a list.

D. The DataFrame does not have a MultiIndex.

Solution

1. Step 1: Check parameter types for multiple levels

   When sorting multiple levels, 'ascending' must be a list matching levels count.

2. Step 2: Identify error cause

   Passing a single boolean True instead of a list causes a ValueError.

3. Final Answer:

   The 'ascending' parameter must be a list when sorting multiple levels. -> Option A

4. Quick Check:

   ascending list needed for multiple levels [OK]

Hint: Use list for ascending when sorting multiple levels [OK]

Common Mistakes:

• Passing single bool to ascending with multiple levels
• Assuming inplace is unsupported
• Misunderstanding level parameter type

5. You have a MultiIndex DataFrame with levels 'Country' and 'Year'. You want to sort it so that 'Country' is ascending but 'Year' is descending, and then reset the index to get a flat DataFrame sorted accordingly. Which code snippet achieves this?

hard

A. df.sort_values(by=['Country', 'Year'], ascending=[True, False]).reset_index(drop=True)

B. df.sort_index(level=['Country', 'Year'], ascending=[True, False]).reset_index()

C. df.sort_index(level=['Country', 'Year'], ascending=[False, True]).reset_index()

D. df.sort_values(by=['Year', 'Country'], ascending=[False, True]).reset_index()

Solution

1. Step 1: Choose correct sorting method for MultiIndex

   Use sort_index() with levels and ascending list to sort MultiIndex properly.

2. Step 2: Reset index to flatten DataFrame

   Calling reset_index() converts MultiIndex to columns, preserving sorted order.

3. Final Answer:

   df.sort_index(level=['Country', 'Year'], ascending=[True, False]).reset_index() -> Option B

4. Quick Check:

   sort_index with levels + reset_index = correct approach [OK]

Hint: Use sort_index with ascending list, then reset_index [OK]

Common Mistakes:

• Using sort_values instead of sort_index for MultiIndex
• Wrong ascending order for levels
• Forgetting to reset index after sorting