How to RENAME Column Header in a Pandas DataFrame in Python

Renaming the column headers in a Pandas DataFrame in Python can be done by using the rename() function. This function allows you to change the names of one or more columns in a DataFrame.

First, you need to import the Pandas library and create a DataFrame. For example, you can create a DataFrame with some sample data.

import pandas as pd

data = {'product': ['Apple', 'Banana', 'Cherry', 'Date', 'Eggplant'],

              'price': [1.2, 2.3, 2.5, 1.7, 2.0]}

df = pd.DataFrame(data)

Next, you can use the rename() function to change the name of the ‘product’ column to ‘Item’.

For example, you can use the following code:

df = df.rename(columns={'product': 'Item'})

Alternatively, you can also use the rename() function inplace to change the name of column in the same dataframe

df.rename(columns={'product': 'Item'},inplace=True)

You can also rename multiple columns in one go by passing a dictionary of current and new column names

df.rename(columns={'product': 'Item','price':'cost'},inplace=True)

By using the rename() function, you can easily change the names of one or more columns in a Pandas DataFrame in Python. This can be useful for data analysis, as it allows you to better understand the data and make it easier to work with. It can also be useful when working with other people’s data and you want to make the column names more meaningful to you.

In this Learn through Codes example, you will learn: How to RENAME Column Header in a Pandas DataFrame in Python.

Find more … …

Python Example – How to rename column header of a Pandas DataFrame

Pandas Example – Write a Pandas program to rename columns of a given DataFrame

Learn Java by Example: Java Program to Rename File

Pandas Example – Write a Pandas program to rename all columns with the same pattern of a given DataFrame

Essential Gigs