HomeLanguagesAdd column names to dataframe in Pandas

Add column names to dataframe in Pandas

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 library
import pandas as pd
 
# creating lists
l1 =["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 DataFrame
team = pd.DataFrame(list(zip(l1, l2, l3, l4)))
 
# displaying the DataFrame
print(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 columns
team.columns =['Name', 'Code', 'Age', 'Weight']
 
# displaying the DataFrame
print(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 columns
team.rename(columns = {'Code':'Code-Name',
                       'Weight':'Weight in kgs'},
            inplace = True)
 
# displaying the DataFrame
print(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.

RELATED ARTICLES

4 COMMENTS

Most Popular

Dominic
32688 POSTS0 COMMENTS
Milvus
131 POSTS0 COMMENTS
Nango Kala
7057 POSTS0 COMMENTS
Nicole Veronica
12198 POSTS0 COMMENTS
Nokonwaba Nkukhwana
12293 POSTS0 COMMENTS
Shaida Kate Naidoo
7182 POSTS0 COMMENTS
Ted Musemwa
7447 POSTS0 COMMENTS
Thapelo Manthata
7160 POSTS0 COMMENTS
Umr Jansen
7150 POSTS0 COMMENTS