[947] Batch rename columns in a Pandas DataFrame
To batch rename columns in a Pandas DataFrame, we can use the rename
method.
Here is an example:
import pandas as pd
# Sample DataFrame
data = {"ID": [1, 2, 3], "Name": ["Alice", "Bob", "Charlie"], "Age": [25, 30, 33]}
df = pd.DataFrame(data)
# Define a dictionary for column renaming
column_mapping = {"ID": "EmployeeID", "Name": "EmployeeName", "Age": "EmployeeAge"}
# Use the rename method to batch rename columns
df.rename(columns=column_mapping, inplace=True)
df
In this exmaple, the column_mapping
dictionary is used to specify the old column names as keys and the new column names as values. The rename
method is then applied to the DataFrame, and the columns
parameter is set to the column_mapping
dictionary.
Make sure to set inplace=True
if you want to modify the original DataFrame in place. If you prefer to create a new DataFrame with the uploaded column names, omit inplace=True
.
Adjust the column_mapping
dictionary based on the specific columns you want to rename. If you want to rename only a subset of columns, you can create a smaller dictionary with the desired changes.