Resetting MultiIndex to columns in Pandas - Mini Project: Build & Apply

Resetting MultiIndex to Columns

📖 Scenario: Imagine you have sales data for different stores and products. The data is organized with a MultiIndex on rows, showing store and product names. You want to convert this MultiIndex back into regular columns to make the data easier to read and analyze.

🎯 Goal: You will create a pandas DataFrame with a MultiIndex, then reset the MultiIndex to turn it into normal columns.

📋 What You'll Learn

Create a pandas DataFrame with a MultiIndex from given data

Create a variable to hold the DataFrame

Use the reset_index() method to convert the MultiIndex into columns

Print the resulting DataFrame

💡 Why This Matters

🌍 Real World

Data often comes with hierarchical indexes that are useful for grouping but hard to read. Resetting MultiIndex to columns helps make data easier to analyze and visualize.

💼 Career

Data scientists and analysts frequently manipulate MultiIndex DataFrames to prepare data for reports, visualizations, or machine learning models.

1

Create a pandas DataFrame with MultiIndex

Import pandas as pd. Create a DataFrame called sales with the following MultiIndex and data:

- MultiIndex levels: Store with values 'Store A', 'Store B'
- MultiIndex levels: Product with values 'Apples', 'Bananas'
- Data column Sales with values 100, 150, 200, 250 corresponding to each Store-Product pair.

Use pd.MultiIndex.from_tuples() to create the MultiIndex from tuples [('Store A', 'Apples'), ('Store A', 'Bananas'), ('Store B', 'Apples'), ('Store B', 'Bananas')].

Pandas

# Import pandas as pd
# Create the MultiIndex from tuples
# Create the DataFrame sales with MultiIndex and Sales data
# Your code here

Need a hint?

Use pd.MultiIndex.from_tuples() with the list of tuples and set names=['Store', 'Product']. Then create the DataFrame with sales = pd.DataFrame({'Sales': [...]}, index=index).

2

Create a variable for the reset DataFrame

Create a new variable called sales_reset that will hold the DataFrame after resetting the MultiIndex.

Pandas

import pandas as pd

index = pd.MultiIndex.from_tuples([
    ('Store A', 'Apples'),
    ('Store A', 'Bananas'),
    ('Store B', 'Apples'),
    ('Store B', 'Bananas')
], names=['Store', 'Product'])

sales = pd.DataFrame({'Sales': [100, 150, 200, 250]}, index=index)

# Create a variable sales_reset to hold the reset DataFrame
# Your code here

Need a hint?

Just create the variable sales_reset and assign None for now. You will update it in the next step.

3

Reset the MultiIndex to columns

Use the reset_index() method on the sales DataFrame and assign the result to the variable sales_reset.

Pandas

import pandas as pd

index = pd.MultiIndex.from_tuples([
    ('Store A', 'Apples'),
    ('Store A', 'Bananas'),
    ('Store B', 'Apples'),
    ('Store B', 'Bananas')
], names=['Store', 'Product'])

sales = pd.DataFrame({'Sales': [100, 150, 200, 250]}, index=index)

# Reset the MultiIndex of sales and assign to sales_reset
# Your code here

Need a hint?

Call sales.reset_index() and assign it to sales_reset.

4

Print the DataFrame with reset columns

Print the sales_reset DataFrame to see the MultiIndex converted into columns.

Pandas

import pandas as pd

index = pd.MultiIndex.from_tuples([
    ('Store A', 'Apples'),
    ('Store A', 'Bananas'),
    ('Store B', 'Apples'),
    ('Store B', 'Bananas')
], names=['Store', 'Product'])

sales = pd.DataFrame({'Sales': [100, 150, 200, 250]}, index=index)

sales_reset = sales.reset_index()

# Print the sales_reset DataFrame
# Your code here

Need a hint?

Use print(sales_reset) to display the DataFrame.