In this article, we are going to see how to add column names to a dataframe. Let us how to add names to DataFrame columns in Pandas.
Creating the DataFrame
Let’s first create an example DataFrame for demonstration reasons before moving on to adding column names. There are several ways in Pandas to add column names to your DataFrame:
python3
# importing the pandas libraryimport pandas as pd# creating listsl1 =["Amar", "Barsha", "Carlos", "Tanmay", "Misbah"]l2 =["Alpha", "Bravo", "Charlie", "Tango", "Mike"]l3 =[23, 25, 22, 27, 29]l4 =[69, 54, 73, 70, 74]# creating the DataFrameteam = pd.DataFrame(list(zip(l1, l2, l3, l4)))# displaying the DataFrameprint(team) |
Output:
0 1 2 3
0 Amar Alpha 23 69
1 Barsha Bravo 25 54
2 Carlos Charlie 22 73
3 Tanmay Tango 27 70
4 Misbah Mike 29 74
Here we can see that the columns in the DataFrame are unnamed.
Adding column name to the DataFrame
We can add columns to an existing DataFrame using its columns attribute.
python3
# adding column name to the respective columnsteam.columns =['Name', 'Code', 'Age', 'Weight']# displaying the DataFrameprint(team) |
Output:
Name Code Age Weight
0 Amar Alpha 23 69
1 Barsha Bravo 25 54
2 Carlos Charlie 22 73
3 Tanmay Tango 27 70
4 Misbah Mike 29 74
Now the DataFrame has column names.
Renaming column name of a DataFrame
We can rename the columns of a DataFrame by using the rename() function.
python3
# reanming the DataFrame columnsteam.rename(columns = {'Code':'Code-Name', 'Weight':'Weight in kgs'}, inplace = True)# displaying the DataFrameprint(team) |
Output:
Name Code-Name Age Weight in kgs
0 Amar Alpha 23 69
1 Barsha Bravo 25 54
2 Carlos Charlie 22 73
3 Tanmay Tango 27 70
4 Misbah Mike 29 74
We can see the names of the columns have been changed.
