Why reshaping data matters in Pandas - See It in Action

Why reshaping data matters

📖 Scenario: Imagine you work in a small bakery. You have sales data for different types of bread sold each day. The data is messy and hard to analyze because it is not organized well. You want to reshape the data to make it easier to understand and find trends.

🎯 Goal: You will reshape the bakery sales data from a wide format to a long format using pandas. This will help you see daily sales for each bread type clearly.

📋 What You'll Learn

Create a pandas DataFrame with daily sales data for three bread types.

Create a variable to hold the list of bread types.

Use pandas melt function to reshape the data from wide to long format.

Print the reshaped DataFrame.

💡 Why This Matters

🌍 Real World

Reshaping data is important in real life because data often comes in formats that are hard to analyze. Changing the shape helps us see patterns and make better decisions.

💼 Career

Data scientists and analysts frequently reshape data to prepare it for analysis, reporting, and visualization. Knowing how to reshape data with pandas is a key skill in many data jobs.

1

Create the bakery sales DataFrame

Create a pandas DataFrame called sales_data with these exact columns and values:
'Day' with values ['Monday', 'Tuesday', 'Wednesday'],
'Sourdough' with values [10, 12, 9],
'Baguette' with values [5, 7, 6],
and 'Rye' with values [3, 4, 2].

Pandas

import pandas as pd
# Create the sales_data DataFrame with the exact columns and values
# Your code here

Hint

Use pd.DataFrame with a dictionary where keys are column names and values are lists of data.

2

Create a list of bread types

Create a list called bread_types that contains the strings 'Sourdough', 'Baguette', and 'Rye'.

Pandas

import pandas as pd
sales_data = pd.DataFrame({
    'Day': ['Monday', 'Tuesday', 'Wednesday'],
    'Sourdough': [10, 12, 9],
    'Baguette': [5, 7, 6],
    'Rye': [3, 4, 2]
})
# Create the bread_types list with the exact strings
# Your code here

Hint

Use square brackets to create a list with the exact bread names as strings.

3

Reshape the data using pandas melt

Use the pandas melt function on sales_data to reshape it from wide to long format. Store the result in a variable called reshaped_data. Use id_vars='Day' and value_vars=bread_types. Set var_name='Bread' and value_name='Sales'.

Pandas

import pandas as pd
sales_data = pd.DataFrame({
    'Day': ['Monday', 'Tuesday', 'Wednesday'],
    'Sourdough': [10, 12, 9],
    'Baguette': [5, 7, 6],
    'Rye': [3, 4, 2]
})
bread_types = ['Sourdough', 'Baguette', 'Rye']
# Use pd.melt to reshape sales_data into reshaped_data
# Your code here

Hint

Use pd.melt() with the correct parameters to reshape the DataFrame.

4

Print the reshaped DataFrame

Print the variable reshaped_data to display the reshaped bakery sales data.

Pandas

import pandas as pd
sales_data = pd.DataFrame({
    'Day': ['Monday', 'Tuesday', 'Wednesday'],
    'Sourdough': [10, 12, 9],
    'Baguette': [5, 7, 6],
    'Rye': [3, 4, 2]
})
bread_types = ['Sourdough', 'Baguette', 'Rye']
reshaped_data = pd.melt(sales_data, id_vars='Day', value_vars=bread_types, var_name='Bread', value_name='Sales')
# Print the reshaped_data DataFrame
# Your code here

Hint

Use print(reshaped_data) to show the reshaped data.

Practice

1. Why is reshaping data important in pandas?

easy

A. It organizes data to make analysis and visualization easier.

B. It deletes unnecessary rows automatically.

C. It changes data types of columns.

D. It encrypts data for security.

Solution

1. Step 1: Understand the purpose of reshaping

   Reshaping changes the layout of data to make it easier to work with.

2. Step 2: Identify the benefit for analysis and visualization

   Organized data helps tools and people understand patterns and trends better.

3. Final Answer:

   It organizes data to make analysis and visualization easier. -> Option A

4. Quick Check:

   Reshaping = Organizing data [OK]

Hint: Think: reshaping makes data easier to read and use [OK]

Common Mistakes:

• Confusing reshaping with deleting data
• Thinking reshaping changes data types
• Believing reshaping encrypts data

2. Which pandas function would you use to make a DataFrame longer by turning columns into rows?

easy

A. groupby()

B. pivot()

C. melt()

D. concat()

Solution

1. Step 1: Recall the function to make data longer

   The melt() function converts columns into rows, making data longer.

2. Step 2: Differentiate from pivot()

   pivot() does the opposite by making data wider, so it is not correct here.

3. Final Answer:

   melt() -> Option C

4. Quick Check:

   Longer data = melt() [OK]

Hint: Remember: melt makes data longer, pivot makes it wider [OK]

Common Mistakes:

• Choosing pivot() instead of melt()
• Confusing groupby() with reshaping
• Using concat() which combines dataframes, not reshapes

3. What is the output of this code?

import pandas as pd
df = pd.DataFrame({
  'Name': ['Anna', 'Bob'],
  'Math': [90, 80],
  'Science': [85, 95]
})
melted = df.melt(id_vars='Name', var_name='Subject', value_name='Score')
print(melted)

medium

A. An error because melt() needs a list for id_vars.

B. A DataFrame with columns Name, Math, Science unchanged.

C. A DataFrame with columns Name, Subject, Score but only 2 rows.

D. A DataFrame with columns Name, Subject, Score and 4 rows showing each subject score per student.

Solution

1. Step 1: Understand melt() with id_vars

   The melt() keeps 'Name' fixed and turns 'Math' and 'Science' columns into rows.

2. Step 2: Count resulting rows and columns

   Each student has 2 subjects, so 2 students x 2 subjects = 4 rows with columns Name, Subject, Score.

3. Final Answer:

   A DataFrame with columns Name, Subject, Score and 4 rows showing each subject score per student. -> Option D

4. Quick Check:

   melt() expands columns to rows [OK]

Hint: melt with id_vars keeps those columns fixed [OK]

Common Mistakes:

• Thinking melt() keeps original shape
• Believing id_vars must be a list, not a string
• Expecting fewer rows than subjects x students

4. You try to reshape data using pivot() but get an error: "ValueError: Index contains duplicate entries, cannot reshape". What is the likely cause?

medium

A. pivot() requires numeric columns only.

B. The DataFrame has duplicate index values preventing pivot.

C. pivot() needs a list for columns parameter.

D. pivot() cannot be used on DataFrames with missing values.

Solution

1. Step 1: Understand pivot() requirements

   pivot() needs unique index/column pairs to reshape data without duplicates.

2. Step 2: Identify cause of duplicate entries error

   If duplicates exist in the index or columns used, pivot() cannot reshape and throws this error.

3. Final Answer:

   The DataFrame has duplicate index values preventing pivot. -> Option B

4. Quick Check:

   Duplicate entries block pivot() [OK]

Hint: Check for duplicates before pivoting [OK]

Common Mistakes:

• Assuming pivot() only works with numeric data
• Thinking pivot() needs list for columns always
• Believing missing values cause this error

5. You have sales data with columns: Store, Month, and Sales. You want a table showing each store as a row and each month as a column with sales values. Which steps correctly reshape the data?

hard

A. Use pivot(index='Store', columns='Month', values='Sales') to make data wider.

B. Use melt() to make data longer, then groupby() to sum sales.

C. Use concat() to join Store and Month columns.

D. Use drop_duplicates() to remove repeated sales before pivoting.

Solution

1. Step 1: Identify desired shape

   You want stores as rows and months as columns, which means making data wider.

2. Step 2: Choose correct function for widening

   pivot() reshapes data from long to wide format using specified index, columns, and values.

3. Final Answer:

   Use pivot(index='Store', columns='Month', values='Sales') to make data wider. -> Option A

4. Quick Check:

   Wide table = pivot() [OK]

Hint: pivot() makes wide tables from long data [OK]

Common Mistakes:

• Using melt() when wide format is needed
• Trying concat() to reshape data
• Dropping duplicates unnecessarily before pivot