Swapping index levels in Pandas - Step-by-Step Execution

Concept Flow - Swapping index levels

Start with MultiIndex DataFrame

↓

Choose levels to swap

↓

Call swaplevel(level1, level2)

↓

New DataFrame with swapped index levels

↓

Use swapped DataFrame for further operations

Swapping index levels means exchanging positions of two levels in a MultiIndex DataFrame to change how data is grouped or accessed.

Execution Sample

Pandas

import pandas as pd
idx = pd.MultiIndex.from_tuples([('A', 1), ('A', 2), ('B', 1)])
df = pd.DataFrame({'val': [10, 20, 30]}, index=idx)
df_swapped = df.swaplevel(0, 1)

This code creates a DataFrame with a two-level index and swaps the two index levels.

Execution Table

Step	Action	Index Before	Index After	Resulting DataFrame Index
1	Create MultiIndex from tuples [('A',1), ('A',2), ('B',1)]	[('A',1), ('A',2), ('B',1)]	[('A',1), ('A',2), ('B',1)]	MultiIndex with level0: ['A','A','B'], level1: [1,2,1]
2	Create DataFrame with MultiIndex	[('A',1), ('A',2), ('B',1)]	[('A',1), ('A',2), ('B',1)]	DataFrame with index levels 0:'A','A','B' and 1:1,2,1
3	Call swaplevel(0,1) to swap index levels	[('A',1), ('A',2), ('B',1)]	[(1,'A'), (2,'A'), (1,'B')]	DataFrame index levels swapped: level0: [1,2,1], level1: ['A','A','B']
4	Use swapped DataFrame for further operations	[(1,'A'), (2,'A'), (1,'B')]	[(1,'A'), (2,'A'), (1,'B')]	DataFrame now grouped/indexed by swapped levels

💡 All steps complete; index levels successfully swapped

Variable Tracker

Variable	Start	After Step 1	After Step 3	Final
idx	None	[('A',1), ('A',2), ('B',1)]	[('A',1), ('A',2), ('B',1)]	[('A',1), ('A',2), ('B',1)]
df.index	None	None	[('A',1), ('A',2), ('B',1)]	[('A',1), ('A',2), ('B',1)]
df_swapped.index	None	None	[(1,'A'), (2,'A'), (1,'B')]	[(1,'A'), (2,'A'), (1,'B')]

Key Moments - 2 Insights

Why does the order of index levels matter after swapping?

The order of index levels affects how data is grouped and accessed. After swapping (see execution_table step 3), the first level becomes the previous second level, changing grouping and sorting behavior.

Does swaplevel change the data or just the index structure?

swaplevel only changes the order of index levels, not the data itself. The rows remain the same but are accessed differently (see execution_table step 3 and 4).

Visual Quiz - 3 Questions

Look at the execution_table at step 3, what is the new first index level after swaplevel(0,1)?

A A combination of both levels

B The original first level values ['A', 'A', 'B']

C The original second level values [1, 2, 1]

D An empty index

💡 Hint

Check the 'Index After' column at step 3 in execution_table

At which step does the DataFrame index actually change to swapped levels?

A Step 3

B Step 2

C Step 1

D Step 4

💡 Hint

Look at the 'Resulting DataFrame Index' column in execution_table

If you swap levels back again after step 3, what will the index look like?

A Swapped index [(1,'A'), (2,'A'), (1,'B')]

B Same as original index [('A',1), ('A',2), ('B',1)]

C Index with only one level

D Index with levels reversed but values changed

💡 Hint

Swapping twice returns index to original order (see variable_tracker for df_swapped.index)

Concept Snapshot

swaplevel(level1, level2) swaps two index levels in a MultiIndex DataFrame.
It changes the order of index levels but not the data.
Useful for changing grouping or sorting order.
Returns a new DataFrame with swapped index levels.
Example: df.swaplevel(0,1) swaps first and second index levels.

Full Transcript

This visual execution shows how to swap index levels in a pandas MultiIndex DataFrame. We start with a MultiIndex created from tuples [('A',1), ('A',2), ('B',1)]. The DataFrame uses this MultiIndex as its index. When we call swaplevel(0,1), the first and second index levels exchange places. The index changes from level0: ['A','A','B'] and level1: [1,2,1] to level0: [1,2,1] and level1: ['A','A','B']. This affects how the DataFrame is grouped and accessed but does not change the data itself. Swapping again would restore the original index order. This technique helps reorganize data views without altering the underlying data.

Practice

1. What does the swaplevel() function do in a pandas DataFrame with a multi-level index?

easy

A. It deletes one of the index levels permanently.

B. It switches the positions of two index levels without changing the data.

C. It sorts the DataFrame by the index levels.

D. It converts the multi-level index into columns.

Solution

1. Step 1: Understand the purpose of swaplevel()

   The swaplevel() function is designed to reorder the levels of a multi-level index by swapping two specified levels.

2. Step 2: Confirm it does not alter data values

   Swapping index levels changes only the order of the index labels, not the underlying data or its values.

3. Final Answer:

   It switches the positions of two index levels without changing the data. -> Option B

4. Quick Check:

   swaplevel() swaps index levels [OK]

Hint: Remember: swaplevel() only changes index order, not data [OK]

Common Mistakes:

• Thinking swaplevel() deletes index levels
• Confusing swaplevel() with sorting functions
• Assuming swaplevel() changes data values

2. Which of the following is the correct syntax to swap the first and second levels of a DataFrame's multi-level index named df?

easy

A. df.swaplevel()

B. df.swaplevel(1, 2)

C. df.swaplevel('level1', 'level3')

D. df.swaplevel(0, 1)

Solution

1. Step 1: Identify index levels by position

   Index levels are zero-based, so the first level is 0 and the second is 1.

2. Step 2: Use swaplevel() with correct positions

   Calling df.swaplevel(0, 1) swaps the first and second levels correctly.

3. Final Answer:

   df.swaplevel(0, 1) -> Option D

4. Quick Check:

   swaplevel(0, 1) swaps first two levels [OK]

Hint: Use zero-based positions to swap levels: 0 and 1 for first two [OK]

Common Mistakes:

• Using incorrect level numbers like 1 and 2 for first two levels
• Calling swaplevel() without arguments
• Using level names that don't exist

3. Given the following DataFrame df with a multi-level index:

import pandas as pd
index = pd.MultiIndex.from_tuples([('A', 1), ('A', 2), ('B', 1), ('B', 2)], names=['letter', 'number'])
df = pd.DataFrame({'value': [10, 20, 30, 40]}, index=index)
print(df.swaplevel('letter', 'number'))

What will be the first row's index after swapping?

medium

A. (1, 'A')

B. ('A', 1)

C. ('number', 'letter')

D. (10, 20)

Solution

1. Step 1: Understand original index order

   The original index is [('A',1), ('A',2), ('B',1), ('B',2)] with levels 'letter' then 'number'.

2. Step 2: Swap levels 'letter' and 'number'

   After swapping, the order becomes 'number' then 'letter'. So the first index becomes (1, 'A').

3. Final Answer:

   (1, 'A') -> Option A

4. Quick Check:

   Swapped index order changes ('A',1) to (1,'A') [OK]

Hint: Swapping levels flips their order in the index tuple [OK]

Common Mistakes:

• Assuming index values stay in same order
• Confusing index values with column values
• Mixing up level names and positions

4. You try to swap index levels in a DataFrame using df.swaplevel('first', 'second') but get a KeyError. What is the most likely cause?

medium

A. The level names 'first' and 'second' do not exist in the index.

B. swaplevel() requires integer positions, not names.

C. The DataFrame has no multi-level index.

D. You must reset the index before swapping levels.

Solution

1. Step 1: Check index level names

   swaplevel() accepts level names, but if the names given do not exist, a KeyError occurs.

2. Step 2: Confirm cause of KeyError

   The error means 'first' and 'second' are not valid level names in the DataFrame's index.

3. Final Answer:

   The level names 'first' and 'second' do not exist in the index. -> Option A

4. Quick Check:

   KeyError means invalid level names [OK]

Hint: Verify level names exist before swapping [OK]

Common Mistakes:

• Assuming swaplevel() only accepts integers
• Not checking if DataFrame has multi-level index
• Resetting index unnecessarily

5. You have a DataFrame df with a multi-level index named ['city', 'year', 'month']. You want to swap the 'city' and 'month' levels and then sort the DataFrame by the new index order. Which code snippet correctly does this?

hard

A. df_swapped = df.swaplevel('year', 'month').sort_index()

B. df_swapped = df.swaplevel(0, 1).sort_values()

C. df_swapped = df.swaplevel('city', 'month').sort_index()

D. df_swapped = df.swaplevel('city', 'month').reset_index()

Solution

1. Step 1: Identify correct levels to swap

   The levels to swap are 'city' and 'month', which are the first and third levels.

2. Step 2: Use swaplevel() with level names and sort_index()

   Calling swaplevel('city', 'month') swaps these levels. Then sort_index() sorts the DataFrame by the new index order.

3. Final Answer:

   df_swapped = df.swaplevel('city', 'month').sort_index() -> Option C

4. Quick Check:

   Swap specified levels then sort index [OK]

Hint: Swap by names, then sort_index() to reorder rows [OK]

Common Mistakes:

• Swapping wrong levels by position
• Using sort_values() instead of sort_index()
• Resetting index instead of sorting