Why MultiIndex enables hierarchical data in Pandas - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a MultiIndex from two lists.

Pandas

import pandas as pd
index = pd.MultiIndex.from_tuples([1])
print(index)

Drag options to blanks, or click blank then click option'

A[('A', 1), ('B', 2), ('C', 3)]

B['A', 'B', 'C']

C[1, 2, 3]

D['A1', 'B2', 'C3']

Attempts:

3 left

💡 Hint

Common Mistakes

Using a list of strings instead of tuples.

Passing a single list without tuples.

The from_tuples method requires a list of tuples to create a MultiIndex, representing hierarchical levels.

2fill in blank

medium

Complete the code to create a DataFrame with a MultiIndex.

Pandas

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

Drag options to blanks, or click blank then click option'

Adata

Bpd.Index(['A', 'B'])

Cindex

D['A', 'B']

Attempts:

3 left

💡 Hint

Common Mistakes

Passing a list instead of the MultiIndex object.

Using the data dictionary as index.

The DataFrame index must be set to the MultiIndex object named index to enable hierarchical indexing.

3fill in blank

hard

Fix the error in accessing data using MultiIndex levels.

Pandas

import pandas as pd
index = pd.MultiIndex.from_tuples([('A', 1), ('B', 2)])
data = {'value': [10, 20]}
df = pd.DataFrame(data, index=index)
result = df.loc[[1]]
print(result)

Drag options to blanks, or click blank then click option'

A'A'

B'value'

C1

D('A', 1)

Attempts:

3 left

💡 Hint

Common Mistakes

Using only one level of the index.

Using column names instead of index keys.

To access a row in a MultiIndex DataFrame, you must specify the full tuple key representing all levels.

4fill in blank

hard

Fill both blanks to create a MultiIndex DataFrame and select data from a specific level.

Pandas

import pandas as pd
index = pd.MultiIndex.from_tuples([('X', 10), ('Y', 20), ('X', 30)])
data = {'score': [100, 200, 300]}
df = pd.DataFrame(data, index=[1])
selected = df.xs([2], level=0)
print(selected)

Drag options to blanks, or click blank then click option'

Aindex

B'X'

C'Y'

Ddata

Attempts:

3 left

💡 Hint

Common Mistakes

Using the data dictionary as index.

Selecting a key not present in level 0.

The DataFrame index must be the MultiIndex object index. The xs method selects data at level 0 with key 'X'.

5fill in blank

hard

Fill both blanks to create a hierarchical dictionary from a DataFrame with MultiIndex.

Pandas

import pandas as pd
index = pd.MultiIndex.from_tuples([('A', 'x'), ('A', 'y'), ('B', 'x')])
data = {'val': [1, 2, 3]}
df = pd.DataFrame(data, index=[1])
hier_dict = {level0: {level1: row['val'] for level1, row in df.loc[level0].iterrows()} for level0 in df.index.[2]
print(hier_dict)

Drag options to blanks, or click blank then click option'

Aindex

Blevels

Cunique(level=0)

Dvalues

Attempts:

3 left

💡 Hint

Common Mistakes

Using levels instead of unique(level=0).

Using values which returns all index tuples.

The DataFrame index is the MultiIndex index. To get unique values at level 0, use unique(level=0). The dictionary comprehension iterates over these unique level 0 keys.

Practice

1. What is the main benefit of using a MultiIndex in pandas?

easy

A. It allows organizing data with multiple levels of labels for better structure.

B. It automatically cleans missing data in a DataFrame.

C. It speeds up calculations by using parallel processing.

D. It converts data into a simple list format.

Solution

1. Step 1: Understand what MultiIndex does

   MultiIndex creates multiple layers of labels on rows or columns, allowing hierarchical organization.

2. Step 2: Compare options to MultiIndex purpose

   Only It allows organizing data with multiple levels of labels for better structure. describes organizing data with multiple label levels, which is the key benefit.

3. Final Answer:

   It allows organizing data with multiple levels of labels for better structure. -> Option A

4. Quick Check:

   MultiIndex = hierarchical labels [OK]

Hint: MultiIndex means multiple label layers for clear data structure [OK]

Common Mistakes:

• Thinking MultiIndex cleans data automatically
• Confusing MultiIndex with speed optimization
• Believing MultiIndex flattens data into lists

2. Which of the following is the correct way to create a MultiIndex from two lists ['A', 'B'] and [1, 2] in pandas?

easy

A. pd.MultiIndex.create(['A', 'B'], [1, 2])

B. pd.MultiIndex(['A', 'B'], [1, 2])

C. pd.MultiIndex.from_tuples([('A', 1), ('B', 2)])

D. pd.MultiIndex.make(['A', 'B'], [1, 2])

Solution

1. Step 1: Recall MultiIndex creation methods

   The correct method to create MultiIndex from pairs is from_tuples with a list of tuples.

2. Step 2: Check each option's syntax

   Only pd.MultiIndex.from_tuples([('A', 1), ('B', 2)]) uses pd.MultiIndex.from_tuples with proper tuple list syntax; others are invalid methods.

3. Final Answer:

   pd.MultiIndex.from_tuples([('A', 1), ('B', 2)]) -> Option C

4. Quick Check:

   Use from_tuples with tuple list [OK]

Hint: Use from_tuples with list of tuples to create MultiIndex [OK]

Common Mistakes:

• Using non-existent methods like create or make
• Passing separate lists instead of tuples
• Confusing MultiIndex constructor syntax

3. Given the code:

import pandas as pd
index = pd.MultiIndex.from_tuples([('A', 1), ('A', 2), ('B', 1)])
data = pd.Series([10, 20, 30], index=index)
print(data['A'])

What is the output?

medium

A. KeyError because 'A' is not a full index

B. A scalar value 10

C. A DataFrame with all values

D. A Series with index 1 and 2 and values 10 and 20

Solution

1. Step 1: Understand MultiIndex slicing

   Accessing data['A'] selects all entries where first level is 'A', returning a Series with second level indices.

2. Step 2: Check data values for 'A'

   Entries ('A',1) and ('A',2) have values 10 and 20, so output is a Series indexed by 1 and 2 with those values.

3. Final Answer:

   A Series with index 1 and 2 and values 10 and 20 -> Option D

4. Quick Check:

   Partial MultiIndex slice returns sub-Series [OK]

Hint: Slicing MultiIndex by first level returns sub-Series [OK]

Common Mistakes:

• Expecting a scalar value instead of sub-Series
• Thinking KeyError occurs for partial index
• Confusing Series with DataFrame output

4. Consider this code snippet:

import pandas as pd
index = pd.MultiIndex.from_tuples([('X', 1), ('Y', 2)])
data = pd.Series([100, 200], index=index)
print(data['Z'])

What is the error and how to fix it?

medium

A. KeyError because 'Z' is not in the MultiIndex; fix by checking keys before access.

B. TypeError because 'Z' is wrong type; fix by converting to string.

C. IndexError because index is too short; fix by adding more tuples.

D. No error; output is NaN.

Solution

1. Step 1: Identify the error from accessing 'Z'

   'Z' is not a label in the first level of MultiIndex, so pandas raises a KeyError.

2. Step 2: Suggest fix by checking keys

   Before accessing, verify if 'Z' exists in index.levels[0] or use .get() methods to avoid error.

3. Final Answer:

   KeyError because 'Z' is not in the MultiIndex; fix by checking keys before access. -> Option A

4. Quick Check:

   Missing key in MultiIndex causes KeyError [OK]

Hint: Check if key exists in MultiIndex before accessing [OK]

Common Mistakes:

• Assuming missing key returns NaN instead of error
• Confusing KeyError with TypeError or IndexError
• Ignoring need to validate keys before access

5. You have sales data with columns Region, Store, and Sales. How does using a MultiIndex on Region and Store help analyze this data?

hard

A. It flattens the data into a single-level index for simplicity.

B. It groups sales by Region and Store, enabling easy summary and filtering.

C. It converts sales numbers into percentages.

D. It removes duplicate sales entries automatically.

Solution

1. Step 1: Understand MultiIndex role in hierarchical data

   MultiIndex on Region and Store creates layers that represent the hierarchy of data categories.

2. Step 2: Explain how this helps analysis

   This structure allows grouping sales by Region and Store, making it easy to summarize, filter, and compare sales at different levels.

3. Final Answer:

   It groups sales by Region and Store, enabling easy summary and filtering. -> Option B

4. Quick Check:

   MultiIndex enables hierarchical grouping [OK]

Hint: MultiIndex groups data by multiple categories for clear analysis [OK]

Common Mistakes:

• Thinking MultiIndex cleans or changes data values
• Believing MultiIndex flattens data instead of layering
• Confusing MultiIndex with data normalization