Renaming columns in Data Analysis Python - Mini Project: Build & Apply

Renaming columns

📖 Scenario: You have a small table of sales data with unclear column names. You want to rename the columns to more meaningful names so it is easier to understand and analyze.

🎯 Goal: Rename the columns of a pandas DataFrame to new names that clearly describe the data.

📋 What You'll Learn

Create a pandas DataFrame with given columns and data

Create a dictionary mapping old column names to new column names

Use the rename method with the dictionary to rename columns

Print the DataFrame after renaming columns

💡 Why This Matters

🌍 Real World

Renaming columns is common when working with data from different sources that use unclear or inconsistent column names. Clear names help you and others understand the data quickly.

💼 Career

Data analysts and scientists often rename columns to prepare data for analysis, reporting, or visualization. This skill is essential for cleaning and organizing data.

1

Create the initial DataFrame

Create a pandas DataFrame called df with these columns and data: 'A' with values [10, 20, 30], 'B' with values [100, 200, 300], and 'C' with values [1000, 2000, 3000].

Data Analysis Python

import pandas as pd
# Create the DataFrame df with columns 'A', 'B', 'C' and the specified values
# Your code here

Hint

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

2

Create the renaming dictionary

Create a dictionary called new_names that maps the old column names 'A', 'B', and 'C' to the new names 'Product_ID', 'Quantity', and 'Price' respectively.

Data Analysis Python

import pandas as pd

df = pd.DataFrame({
    'A': [10, 20, 30],
    'B': [100, 200, 300],
    'C': [1000, 2000, 3000]
})

# Create the dictionary new_names mapping old to new column names
# Your code here

Hint

Use a dictionary with old column names as keys and new column names as values.

3

Rename the columns using the dictionary

Use the rename method on df with the columns=new_names argument and inplace=True to rename the columns.

Data Analysis Python

import pandas as pd

df = pd.DataFrame({
    'A': [10, 20, 30],
    'B': [100, 200, 300],
    'C': [1000, 2000, 3000]
})

new_names = {'A': 'Product_ID', 'B': 'Quantity', 'C': 'Price'}

# Rename the columns of df using new_names with inplace=True
# Your code here

Hint

Use df.rename(columns=new_names, inplace=True) to rename columns directly in the DataFrame.

4

Print the DataFrame with renamed columns

Write a print statement to display the DataFrame df after renaming the columns.

Data Analysis Python

import pandas as pd

df = pd.DataFrame({
    'A': [10, 20, 30],
    'B': [100, 200, 300],
    'C': [1000, 2000, 3000]
})

new_names = {'A': 'Product_ID', 'B': 'Quantity', 'C': 'Price'}

df.rename(columns=new_names, inplace=True)

# Print the DataFrame df
# Your code here

Hint

Use print(df) to show the DataFrame with new column names.

Practice

1. What does the df.rename(columns={'old': 'new'}) function do in pandas?

easy

A. It sorts the DataFrame by the column 'old'.

B. It deletes the column named 'old' from the DataFrame.

C. It adds a new column named 'new' with values from 'old'.

D. It changes the column name from 'old' to 'new' in the DataFrame.

Solution

1. Step 1: Understand the rename function

   The rename method changes column names based on a dictionary mapping old names to new names.

2. Step 2: Identify the effect of the dictionary

   The dictionary {'old': 'new'} means the column named 'old' will be renamed to 'new'.

3. Final Answer:

   It changes the column name from 'old' to 'new' in the DataFrame. -> Option D

4. Quick Check:

   Rename columns = change names [OK]

Hint: Rename columns using a dictionary with old:new pairs [OK]

Common Mistakes:

• Thinking rename deletes columns
• Confusing rename with adding columns
• Assuming rename sorts data

2. Which of the following is the correct syntax to rename column 'A' to 'Alpha' in a pandas DataFrame df?

easy

A. df.rename('A' to 'Alpha')

B. df.rename(columns={'A': 'Alpha'}, inplace=True)

C. df.rename_columns('A', 'Alpha')

D. df.columns.rename('A', 'Alpha')

Solution

1. Step 1: Recall pandas rename syntax

   The correct syntax uses df.rename(columns={old_name: new_name}, inplace=True) to rename columns.

2. Step 2: Match the syntax to options

   df.rename(columns={'A': 'Alpha'}, inplace=True) matches the correct syntax exactly, including inplace=True to change the original DataFrame.

3. Final Answer:

   df.rename(columns={'A': 'Alpha'}, inplace=True) -> Option B

4. Quick Check:

   Use rename with columns dict and inplace [OK]

Hint: Use rename(columns={old:new}, inplace=True) to rename columns [OK]

Common Mistakes:

• Using wrong method names like rename_columns
• Missing columns= keyword
• Forgetting inplace=True to apply changes

3. Given the DataFrame df below:

import pandas as pd
df = pd.DataFrame({'X': [1,2], 'Y': [3,4]})
df.rename(columns={'X': 'A', 'Y': 'B'}, inplace=True)
print(df.columns.tolist())

What is the output?

medium

A. ['A', 'B']

B. ['X', 'Y']

C. ['X', 'B']

D. ['A', 'Y']

Solution

1. Step 1: Understand the rename operation

   The rename changes 'X' to 'A' and 'Y' to 'B' in the DataFrame columns.

2. Step 2: Check inplace=True effect

   Since inplace=True, the original DataFrame columns are updated.

3. Final Answer:

   ['A', 'B'] -> Option A

4. Quick Check:

   Renamed columns list = ['A', 'B'] [OK]

Hint: inplace=True updates columns immediately [OK]

Common Mistakes:

• Ignoring inplace=True and expecting old names
• Partial renaming confusion
• Printing DataFrame instead of columns

4. What is wrong with this code snippet?

df.rename({'old_name': 'new_name'}, inplace=True)

medium

A. The dictionary keys and values are reversed.

B. inplace=True is not a valid argument for rename.

C. The dictionary should be passed to the columns parameter.

D. The rename method cannot rename columns.

Solution

1. Step 1: Check rename method parameters

   The rename method requires the dictionary to be passed with the keyword columns= to rename columns.

2. Step 2: Identify the error in the code

   The code passes the dictionary as a positional argument without specifying columns=, so it will not rename columns.

3. Final Answer:

   The dictionary should be passed to the columns parameter. -> Option C

4. Quick Check:

   Use columns= to rename columns [OK]

Hint: Always use columns= when renaming columns [OK]

Common Mistakes:

• Passing dictionary without columns= keyword
• Confusing inplace argument
• Thinking rename can't change columns

5. You have a DataFrame df with columns ['temp', 'humidity', 'pressure']. You want to rename only 'temp' to 'temperature' without changing other columns. Which code correctly does this and keeps the change in df?

hard

A. df.rename(columns={'temp': 'temperature'}, inplace=True)

B. df.columns = ['temperature', 'humidity', 'pressure', 'wind']

C. df.rename({'temp': 'temperature'})

D. df.rename(columns={'temp': 'temperature'})

Solution

1. Step 1: Identify correct rename syntax with inplace

   To rename a single column and keep changes in the original DataFrame, use rename(columns={...}, inplace=True).

2. Step 2: Check other options

   df.columns = ['temperature', 'humidity', 'pressure', 'wind'] replaces all columns, which is risky. Options C and D do not use inplace=True, so changes won't persist in df.

3. Final Answer:

   df.rename(columns={'temp': 'temperature'}, inplace=True) -> Option A

4. Quick Check:

   Use inplace=True to keep rename changes [OK]

Hint: Use inplace=True to save rename changes in original DataFrame [OK]

Common Mistakes:

• Replacing all columns instead of renaming one
• Forgetting inplace=True to save changes
• Using rename without columns= keyword