JIYIK CN >

DataFrame is a two-dimensional labeled data structure. It is a heterogeneous data structure with variable size.

A DataFrame contains labeled axes called rows and columns.

This tutorial will discuss different ways to rename multiple columns of a DataFrame using python.

Use Pandas's rename()function to rename multiple columns

The Pandas library provides rename()functions for renaming DataFrame columns.

rename()The function takes a mapperDataFrame, which is a dictionary-like data structure containing the renamed columns as keys and the names as values. It returns a DataFrame.

In-place modifications can also be inplace = Truedone via settings.

grammar:

pandas.rename(mapper)

Following are rename()the steps to rename multiple columns using method.

• Import the Pandas library.

• Pass the Mapper to rename()the method.

• rename()The method will return a data frame with the column renamed.

• Print the DataFrame.

The following code is the implementation of the above method.

# importing pandas library
import pandas as pd

# creating a dataframe
df = pd.DataFrame(
    {
        "course": ["C", "Python", "Java"],
        "Mentor": ["alex", "alice", "john"],
        "cost": [1000, 2000, 3000],
    }
)

# Dataframe before renaming
print("\n Before Renaming")
print(df)

# renaming the multiple columns by index
df = df.rename(columns={df.columns[0]: "subject", df.columns[2]: "price"})

# Dataframe after renaming
print("\n After Renaming")
print(df)

Output before renaming:

Output after renaming:

DataFrame.column.valuesRenaming multiple columns using Pandas

DataFrame.column.valuesAll column names will be returned, we can use the index to modify the column name. column.valuesAn array of indexes will be returned.

Here are the steps to rename multiple columns using this method:

1. Import the Pandas library.
2. Use DataFrame.column.valuesto retrieve an array of column names.
3. Change the name of a column by passing its index.
4. Print the data frame.

The following code is the implementation of the above method.

# importing pandas library
import pandas as pd

# creating a dataframe
df = pd.DataFrame(
    {
        "course": ["C", "Python", "Java"],
        "Mentor": ["alex", "alice", "john"],
        "cost": [1000, 2000, 3000],
    }
)

# Dataframe before renaming
print("\n Before Renaming")
print(df)

# renaming the multiple columns by index
df.columns.values[0:2] = ["Subject", "Teacher"]

# Dataframe after renaming
print("\n After Renaming")
print(df)

Output before renaming:

Output after renaming: