Renaming columns in Pandas - Step-by-Step Execution

Concept Flow - Renaming columns

Start with DataFrame

↓

Choose rename method

↓

Map old names to new names

↓

Apply rename

↓

Get DataFrame with new column names

↓

End

We start with a DataFrame, decide how to rename columns, map old names to new, apply the rename, and get the updated DataFrame.

Execution Sample

Pandas

import pandas as pd

df = pd.DataFrame({
    'A': [1, 2], 'B': [3, 4]
})

# Rename columns
new_df = df.rename(columns={'A': 'Alpha', 'B': 'Beta'})

This code creates a DataFrame with columns 'A' and 'B', then renames them to 'Alpha' and 'Beta'.

Execution Table

Step	Action	DataFrame Columns Before	Rename Mapping	DataFrame Columns After
1	Create DataFrame	['A', 'B']	{}	['A', 'B']
2	Prepare rename mapping	['A', 'B']	{'A': 'Alpha', 'B': 'Beta'}	['A', 'B']
3	Apply rename	['A', 'B']	{'A': 'Alpha', 'B': 'Beta'}	['Alpha', 'Beta']
4	Result stored in new_df	['A', 'B']	{'A': 'Alpha', 'B': 'Beta'}	['Alpha', 'Beta']

💡 Rename applied, columns changed from ['A', 'B'] to ['Alpha', 'Beta']

Variable Tracker

Variable	Start	After Step 1	After Step 3	Final
df.columns	N/A	Index(['A', 'B'], dtype='object')	Index(['A', 'B'], dtype='object')	Index(['A', 'B'], dtype='object')
new_df.columns	N/A	N/A	Index(['Alpha', 'Beta'], dtype='object')	Index(['Alpha', 'Beta'], dtype='object')

Key Moments - 2 Insights

Why does df.columns not change after rename, but new_df.columns does?

Because rename returns a new DataFrame by default and does not modify df in place. See execution_table step 3 and 4 where new_df has renamed columns but df remains the same.

What happens if you rename a column not present in the DataFrame?

The rename mapping for missing columns is ignored, so only existing columns are renamed. This is why the mapping keys must match existing column names to have effect.

Visual Quiz - 3 Questions

Look at the execution table, what are the columns of new_df after step 3?

A ['A', 'B']

B ['Alpha', 'B']

C ['Alpha', 'Beta']

D ['A', 'Beta']

💡 Hint

Check the 'DataFrame Columns After' column in execution_table row with Step 3

At which step does the rename mapping get prepared?

A Step 2

B Step 3

C Step 1

D Step 4

💡 Hint

Look at the 'Action' column in execution_table to find when rename mapping is set

If you want to rename columns in the original df without creating a new DataFrame, what should you do?

A Assign new_df back to df

B All of the above

C Use df.columns = ['Alpha', 'Beta']

D Use df.rename(columns=..., inplace=True)

💡 Hint

All these methods change the original DataFrame columns; see variable_tracker for df.columns changes

Concept Snapshot

Renaming columns in pandas:
Use df.rename(columns={'old': 'new'}) to rename columns.
By default, rename returns a new DataFrame.
Use inplace=True to modify original df.
Only columns in mapping keys are renamed.
Unmapped columns stay the same.

Full Transcript

We start with a DataFrame with columns 'A' and 'B'. We prepare a rename mapping to change 'A' to 'Alpha' and 'B' to 'Beta'. Applying df.rename with this mapping returns a new DataFrame with renamed columns. The original DataFrame remains unchanged unless inplace=True is used. This process helps change column names clearly and safely.

Practice

1. What is the main purpose of renaming columns in a pandas DataFrame?

easy

A. To delete unwanted columns

B. To make the data easier to read and understand

C. To sort the data by column values

D. To change the data type of columns

Solution

1. Step 1: Understand the role of column names

   Column names help identify what data each column holds.

2. Step 2: Purpose of renaming

   Renaming columns improves clarity and makes the data easier to work with.

3. Final Answer:

   To make the data easier to read and understand -> Option B

4. Quick Check:

   Renaming columns = better readability [OK]

Hint: Renaming columns improves clarity and usability [OK]

Common Mistakes:

• Confusing renaming with deleting columns
• Thinking renaming changes data values
• Assuming renaming sorts data

2. Which of the following is the correct syntax to rename columns in a pandas DataFrame df using a dictionary mapping old names to new names?

easy

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

B. df.rename({'old_name': 'new_name'}, axis=0)

C. df.rename(columns=['old_name', 'new_name'])

D. df.rename(columns='old_name:new_name')

Solution

1. Step 1: Identify correct method parameters

   The rename method requires a dictionary for columns with keys as old names and values as new names.

2. Step 2: Check syntax correctness

   df.rename(columns={'old_name': 'new_name'}, inplace=True) uses columns= with a dictionary and inplace=True, which is correct syntax.

3. Final Answer:

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

4. Quick Check:

   Use rename(columns=dict) with inplace=True [OK]

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

Common Mistakes:

• Omitting 'columns=' keyword
• Passing list instead of dictionary
• Using axis=0 for column renaming

3. Given the DataFrame df below:

import pandas as pd
df = pd.DataFrame({
  'A': [1, 2],
  'B': [3, 4]
})
df_renamed = df.rename(columns={'A': 'Alpha', 'B': 'Beta'})
print(df_renamed.columns.tolist())

What will be the output?

medium

A. ['Alpha', 'Beta']

B. ['A', 'B']

C. ['Alpha', 'B']

D. Error: rename requires inplace=True

Solution

1. Step 1: Understand rename without inplace

   Calling rename without inplace=True returns a new DataFrame with renamed columns.

2. Step 2: Check the printed columns

   The new DataFrame df_renamed has columns renamed to 'Alpha' and 'Beta'.

3. Final Answer:

   ['Alpha', 'Beta'] -> Option A

4. Quick Check:

   rename() returns new DataFrame with renamed columns [OK]

Hint: rename() returns new DataFrame unless inplace=True [OK]

Common Mistakes:

• Assuming original df columns change without inplace=True
• Expecting error without inplace=True
• Confusing columns list output

4. What is wrong with this code snippet?

df.rename({'old': 'new'}, inplace=True)

medium

A. The 'inplace' parameter is not valid for rename

B. The rename method cannot rename columns

C. The dictionary keys and values should be lists, not strings

D. The dictionary should be passed to the 'columns' parameter

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

   Passing the dictionary without 'columns=' causes pandas to treat it as index renaming, not columns.

3. Final Answer:

   The dictionary should be passed to the 'columns' parameter -> Option D

4. Quick Check:

   Use rename(columns=dict) to rename columns [OK]

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

Common Mistakes:

• Passing dictionary without columns= keyword
• Confusing index renaming with column renaming
• Thinking inplace=False causes error

5. You have a DataFrame df with columns ['name', 'age', 'city']. You want to rename 'name' to 'full_name' and 'city' to 'location' without changing 'age'. Which code correctly renames only these columns and keeps the rest unchanged?

hard

A. df.rename(columns=['full_name', 'age', 'location'], inplace=True)

B. df.columns = ['full_name', 'age', 'location']

C. df.rename(columns={'name': 'full_name', 'city': 'location'}, inplace=True)

D. df.rename({'name': 'full_name', 'city': 'location'}, inplace=True)

Solution

1. Step 1: Understand selective renaming

   Using rename with a dictionary for columns changes only specified columns, leaving others unchanged.

2. Step 2: Check each option

   df.rename(columns={'name': 'full_name', 'city': 'location'}, inplace=True) uses columns= with a dictionary for selective renaming, leaving 'age' unchanged. In contrast, assigning to df.columns replaces all column names and requires the list to match the exact current order. Passing the dictionary directly without columns= attempts to rename the index instead of columns. Using a list instead of a dictionary for columns= will raise a TypeError.

3. Final Answer:

   df.rename(columns={'name': 'full_name', 'city': 'location'}, inplace=True) -> Option C

4. Quick Check:

   Use rename(columns=dict) for selective renaming [OK]

Hint: Use rename(columns=dict) to rename selected columns only [OK]

Common Mistakes:

• Replacing all columns instead of selective renaming
• Omitting columns= keyword
• Using list instead of dictionary for columns