How to Rename Column(s) in Pandas DataFrame? - 2 Python Examples
Rename Columns Pandas DataFrame
You can rename a single column or multiple columns of a pandas DataFrame using pandas.DataFrame.rename() method.
In the following set of examples, we will learn how to rename a single column, and how to rename multiple columns of Pandas DataFrame.
Examples
1. Rename single column
To rename a single column, you can use DataFrame.rename()
function as shown below.
Python Program
import pandas as pd
# Initialize a DataFrame
df = pd.DataFrame(
[[41, 72, 67, 91],
[21, 78, 69, 87],
[95, 74, 56, 88],
[54, 54, 76, 78]],
columns=['a', 'b', 'c', 'd'])
# Rename single column
df.rename(columns={'b': 'k'}, inplace=True)
# Print the column names
print(df)
Output
a k c d
0 41 72 67 91
1 21 78 69 87
2 95 74 56 88
3 54 54 76 78
The column name b
has been renamed to k
for the Pandas DataFrame.
2. Rename multiple columns
To rename multiple columns, you can use DataFrame.rename()
method with multiple old column names and new column names as key:value pairs as shown below.
Python Program
import pandas as pd
# Initialize a DataFrame
df = pd.DataFrame(
[[41, 72, 67, 91],
[21, 78, 69, 87],
[95, 74, 56, 88],
[54, 54, 76, 78]],
columns=['a', 'b', 'c', 'd'])
# Rename single column
df.rename(columns={'b': 'k', 'c': 'm'}, inplace=True)
# Print the column names
print(df)
Output
a k m d
0 41 72 67 91
1 21 78 69 87
2 95 74 56 88
3 54 54 76 78
The column named b
has been renamed to k
and column c
has been renamed to m
.
Summary
In this Pandas Tutorial, we renamed one or more columns in-place, using pandas.DataFrame.rename() method, with the help of well detailed Python example programs.