By setting .columns property explicitly we can rename the column names.
For example, let’s consider below data set.
Name Age City Gender Rating 0 Krishna 34 Bangalore Male 81 1 Sailu 35 Hyderabad Female 76 2 Joel 29 Hyderabad Male 67 3 Chamu 35 Chennai Female 100
I would like to rename the column
a. Name to User_Name
b. Rating to User_Rating
Following snippet do the work for us.
df.columns = ['User_Name', 'Age', 'City', 'Gender', 'User_Rating']
Find the below working application.
change_column_names.py
import pandas as pd
# Create a sample DataFrame
data = {'Name': ['Krishna', 'Sailu', 'Joel', 'Chamu'],
'Age': [34, 35, 29, 35],
'City': ['Bangalore', 'Hyderabad', 'Hyderabad', 'Chennai'],
'Gender': ['Male', 'Female', 'Male', 'Female'],
'Rating': [81, 76, 67, 100]}
df = pd.DataFrame(data)
print('Original DataFrame')
print(df)
df.columns = ['User_Name', 'Age', 'City', 'Gender', 'User_Rating']
print('\nDataFrame after renaming the columns')
print(df)
Output
Original DataFrame Name Age City Gender Rating 0 Krishna 34 Bangalore Male 81 1 Sailu 35 Hyderabad Female 76 2 Joel 29 Hyderabad Male 67 3 Chamu 35 Chennai Female 100 DataFrame after renaming the columns User_Name Age City Gender User_Rating 0 Krishna 34 Bangalore Male 81 1 Sailu 35 Hyderabad Female 76 2 Joel 29 Hyderabad Male 67 3 Chamu 35 Chennai Female 100
No comments:
Post a Comment