How to Change Column Labels in Pandas DataFrame? Examples
Pandas DataFrame- Rename Column Labels
To change or rename the column labels of a DataFrame in pandas, just assign the new column labels (array) to the dataframe column names.
In this tutorial, we shall learn how to rename column labels of a Pandas DataFrame, with the help of well illustrated example programs.
Syntax
The syntax to assign new column names is given below.
dataframe.columns = new_columns
The new_columns
should be an array of length same as that of number of columns in the dataframe.
Examples
1. Rename column labels of DataFrame
In this example, we will create a dataframe with some initial column names and then change them by assigning columns attribute of the dataframe.
Python Program
import numpy as np
import pandas as pd
df_marks = pd.DataFrame(
[['Somu', 68, 84, 78, 96],
['Kiku', 74, 56, 88, 85],
['Amol', 77, 73, 82, 87],
['Lini', 78, 69, 87, 92]],
columns=['name', 'physics', 'chemistry', 'algebra', 'calculus'])
print('Original DataFrame\n------------------------')
print(df_marks)
#rename columns
df_marks.columns = ['name', 'physics', 'biology', 'geometry', 'calculus']
print('\n\nColumns Renamed\n------------------------')
print(df_marks)
Output
Original DataFrame
------------------------
name physics chemistry algebra calculus
0 Somu 68 84 78 96
1 Kiku 74 56 88 85
2 Amol 77 73 82 87
3 Lini 78 69 87 92
Columns Renamed
------------------------
name physics biology geometry calculus
0 Somu 68 84 78 96
1 Kiku 74 56 88 85
2 Amol 77 73 82 87
3 Lini 78 69 87 92
New column labels have been applied to the DataFrame.
Summary
In this Pandas Tutorial, we renamed column labels of DataFrame, with the help of well detailed Python example programs.