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.