Pandas DataFrame: Rename columns of a given DataFrame

Last update on April 03 2025 13:07:42 (UTC/GMT +8 hours)

23. Renaming DataFrame Columns

Write a Pandas program to rename columns of a given DataFrame.

Sample data:
Original DataFrame
col1 col2 col3
0 1 4 7
1 2 5 8
2 3 6 9
New DataFrame after renaming columns:
Column1 Column2 Column3
0 1 4 7
1 2 5 8
2 3 6 9

Sample Solution :

Python Code :

import pandas as pd
d = {'col1': [1, 2, 3], 'col2': [4, 5, 6], 'col3': [7, 8, 9]}
df = pd.DataFrame(data=d)
print("Original DataFrame")
print(df)
df.columns = ['Column1', 'Column2', 'Column3']
df = df.rename(columns={'col1': 'Column1', 'col2': 'Column2', 'col3': 'Column3'})
print("New DataFrame after renaming columns:")
print(df)

Sample Output:

Original DataFrame
   col1  col2  col3
0     1     4     7
1     2     5     8
2     3     6     9
New DataFrame after renaming columns:
   Column1  Column2  Column3
0        1        4        7
1        2        5        8
2        3        6        9                  

Explanation:

The above code first creates a Pandas DataFrame 'df' from a dictionary 'd' with 3 columns 'col1', 'col2', and 'col3'.

df = df.rename(columns={'col1': 'Column1', 'col2': 'Column2', 'col3': 'Column3'}): This line changes the column names of the DataFrame using two different methods. First, it sets the column names using the .columns attribute, and then it renames the columns using the .rename() method with a dictionary mapping the old column names to the new column names.

Finally, it prints the DataFrame with the new column names using print() function.

For more Practice: Solve these Related Problems:

• Write a Pandas program to rename DataFrame columns using a dictionary mapping and then verify the updated column names.
• Write a Pandas program to rename columns by applying a function that converts them to title case.
• Write a Pandas program to rename DataFrame columns by appending a prefix and then output the new header list.
• Write a Pandas program to rename selected columns and then reorder the DataFrame columns based on the new names.

Python-Pandas Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Pandas program to get list from DataFrame column headers.
Next: Write a Pandas program to select rows from a given DataFrame based on values in some columns.