Thursday, December 26, 2024
Google search engine
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

Most Popular

Recent Comments