Why MultiIndex enables hierarchical data in Pandas - Challenge Your Understanding

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding MultiIndex structure

What is the main advantage of using a MultiIndex in pandas?

A It allows storing multiple levels of indexing, enabling hierarchical data representation.

B It automatically sorts data without any user input.

C It converts all data into a flat table with no hierarchy.

D It removes duplicate rows from the DataFrame.

💡 Hint

Think about how data can be organized in layers or groups.

MultiIndex lets you have multiple index levels, which helps represent data with nested or grouped categories.

❓ Predict Output

intermediate

Output of MultiIndex DataFrame

What is the output of this code?

Pandas

import pandas as pd

index = pd.MultiIndex.from_tuples([('A', 1), ('A', 2), ('B', 1)])
df = pd.DataFrame({'Value': [10, 20, 30]}, index=index)
print(df)

A Error: MultiIndex not supported in DataFrame

B

  Value
A 1 10
A 2 20
B 1 30

C

Value
A 10
A 20
B 30

D

       Value
A 1      10
  2      20
B 1      30

💡 Hint

Look at how the MultiIndex tuples are shown as row labels.

The MultiIndex creates two levels of row labels: first level 'A' or 'B', second level 1 or 2, shown hierarchically.

❓ data_output

advanced

Number of rows in MultiIndex DataFrame

Given this MultiIndex DataFrame, how many rows does it contain?

Pandas

import pandas as pd

index = pd.MultiIndex.from_product([['X', 'Y'], [1, 2, 3]])
df = pd.DataFrame({'Score': [5, 6, 7, 8, 9, 10]}, index=index)
print(len(df))

A 6

B 3

C 9

D 2

💡 Hint

Count all combinations of the two index levels.

There are 2 options in the first level and 3 in the second, so total rows = 2 * 3 = 6.

🔧 Debug

advanced

Identify the error in MultiIndex creation

What error does this code raise?

Pandas

import pandas as pd

index = pd.MultiIndex.from_tuples([('A', 1), ('B',)])
df = pd.DataFrame({'Value': [10, 20]}, index=index)
print(df)

A TypeError: cannot create MultiIndex from tuples

B IndexError: tuple index out of range

C ValueError: all tuples must be the same length

D No error, prints DataFrame correctly

💡 Hint

Check if all tuples have the same number of elements.

MultiIndex requires all tuples to have the same length. Here, one tuple has length 2, the other length 1, causing a ValueError.

🚀 Application

expert

Selecting data using MultiIndex

Given this MultiIndex DataFrame, which option correctly selects all rows where the first index level is 'B'?

Pandas

import pandas as pd

index = pd.MultiIndex.from_tuples([('A', 1), ('B', 1), ('B', 2), ('C', 1)])
df = pd.DataFrame({'Value': [10, 20, 30, 40]}, index=index)

A df.loc['B']

B df.loc['B', :]

C df.loc['B', 1]

D df.loc[:, 'B']

💡 Hint

Remember how to slice MultiIndex with .loc using tuples.

To select all rows where first level is 'B', use df.loc['B', :]. Option B works but is less explicit; option B is the correct explicit syntax.