In this tutorial we will learn how to rename the column of dataframe in pandas. We will learn
- how to rename all the column of the dataframe at once
- how to rename the specific column of our choice by column name.
- how to rename the specific column of our choice by column index.
Let’s try with an example:
Create a dataframe:
import pandas as pd
import numpy as np
# data frame 1
d1 = {'Customer_id':pd.Series([1,2,3,4,5,6]),
'Product':pd.Series(['Oven','Oven','Oven','Television','Television','Television']),
'State':pd.Series(['California','Texas','Georgia','Florida','Albama','virginia'])}
df1 = pd.DataFrame(d1)
print df1
so the resultant dataframe will be
Rename all the column names in python:
Below code will rename all the column names in sequential order
# rename all the columns in python df1.columns = ['Customer_unique_id', 'Product_type', 'Province']
- first column is renamed as ‘Customer_unique_id’.
- second column is renamed as ‘Product_type’.
- third column is renamed as ‘Province’.
so the resultant dataframe will be
Rename the specific column in python:
Below code will rename the specific column.
# rename province to state
df1.rename(columns={'Province': 'State'}, inplace=True)
the column named Province is renamed to State with the help of rename() Function so the resultant dataframe will be
Rename the specific column value by index in python:
Below code will rename the specific column.
# rename the first column df1.columns.values[0] = "customer_id"
the first column is renamed to customer_id so the resultant dataframe will be
