Rename Columns

It is quite common to have datasets where the columns provided are not the most intuitively named - pandas provides us with multiple ways to rename them.

Import Libraries

import pandas as pd
import seaborn as sns

Load Data

tips = sns.load_dataset('tips')
tips.head()

We can access the columns using the columns variable.

print(tips.columns)

Index(['total_bill', 'tip', 'sex', 'smoker', 'day', 'time', 'size'], dtype='object')

We can replace the existing columns by assigning a list of the same length as the existing column to the DataFrame’s columns variable.

new_columns = ['a', 'b', 'c', 'd', 'e', 'f', 'g']
tips.columns = new_columns
tips.head()

If you are looking for a more targeted operation, you are covered by the rename method.

tips = tips.rename(columns={'a': 'total_bill_amount'})
tips.head(5)

We can also pass a function to rename and specify the axis for it to be applied.

tips = tips.rename(str.upper, axis=1)
tips.head(2)