Why transformation reshapes data for analysis in Data Analysis Python - Challenge Your Understanding

Challenge - 5 Problems

🧠 Conceptual

intermediate

Why reshape data before analysis?

Why do data scientists often reshape data before analyzing it?

A To organize data into a format that makes analysis easier and more meaningful

B To convert numerical data into text format

C To encrypt data for security reasons

D To reduce the size of the dataset by removing rows

💡 Hint

Think about how changing the shape of data can help reveal patterns.

Reshaping data helps organize it so that analysis tools can work better and insights become clearer.

❓ data_output

intermediate

Output of pivot operation on sales data

Given this sales data, what is the output after pivoting by 'Month' with 'Product' as columns and 'Sales' as values?

import pandas as pd
data = pd.DataFrame({
    'Month': ['Jan', 'Jan', 'Feb', 'Feb'],
    'Product': ['A', 'B', 'A', 'B'],
    'Sales': [100, 150, 200, 250]
})
pivoted = data.pivot(index='Month', columns='Product', values='Sales')
print(pivoted)

A

Month  Product  Sales
Jan    A        100
Jan    B        150
Feb    A        200
Feb    B        250

B

Month  Product  Sales
0      Jan        A    100
1      Jan        B    150
2      Feb        A    200
3      Feb        B    250

C

      A    B
Month             
Jan    100  150
Feb    200  250

D

Product  Month  Sales
A        Jan    100
B        Jan    150
A        Feb    200
B        Feb    250

💡 Hint

Pivot changes rows into columns based on unique values.

The pivot method rearranges data so each product becomes a column with sales values for each month as rows.

🔧 Debug

advanced

Identify error in melting data

What error does this code produce when trying to reshape data using melt?

import pandas as pd
data = pd.DataFrame({
    'ID': [1, 2],
    'Math': [90, 80],
    'Science': [85, 95]
})
melted = pd.melt(data, id_vars=['ID'], value_vars=['Math', 'History'])
print(melted)

A TypeError: id_vars must be a list

B KeyError: 'History'

C ValueError: value_vars cannot be empty

D No error, prints melted DataFrame

💡 Hint

Check if all columns in value_vars exist in the DataFrame.

The column 'History' does not exist in the DataFrame, causing a KeyError.

❓ visualization

advanced

Visualizing reshaped data with a heatmap

Which option shows the correct heatmap code to visualize sales data after pivoting by 'Month' and 'Product'?

import pandas as pd
import seaborn as sns
import matplotlib.pyplot as plt
data = pd.DataFrame({
    'Month': ['Jan', 'Jan', 'Feb', 'Feb'],
    'Product': ['A', 'B', 'A', 'B'],
    'Sales': [100, 150, 200, 250]
})
pivoted = data.pivot(index='Month', columns='Product', values='Sales')

A

sns.heatmap(pivoted, annot=True)
plt.show()

B

plt.plot(pivoted)
plt.show()

C

sns.barplot(data=pivoted)
plt.show()

D

sns.heatmap(data, annot=True)
plt.show()

💡 Hint

Heatmaps require a 2D matrix-like input.

The pivoted DataFrame is a matrix suitable for heatmap visualization showing sales per product per month.

🚀 Application

expert

Choosing the right reshape method for time series analysis

You have a dataset with daily temperature readings for multiple cities in wide format (each city is a column). You want to analyze temperature trends over time for each city. Which reshaping method is best to prepare the data?

A Use groupby to aggregate temperatures by city without reshaping

B Use pivot to convert the data into a wider format with cities as rows

C Use concat to join city columns into a single column without changing the format

D Use melt to convert the wide format into long format with columns for date, city, and temperature

💡 Hint

Long format is better for time series analysis with multiple groups.

Melt reshapes wide data into long format, making it easier to analyze trends per city over time.