Skip to content
Related Articles

Related Articles

Improve Article
Add column names to dataframe in Pandas
  • Difficulty Level : Medium
  • Last Updated : 01 Aug, 2020

Let us how to add names to DataFrame columns in Pandas.

Creating the DataFrame :

# 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

Output :

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.

# adding column name to the respective columns
team.columns =['Name', 'Code', 'Age', 'Weight']
# displaying the DataFrame

Output :

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.

# reanming the DataFrame columns
team.rename(columns = {'Code':'Code-Name'
                       'Weight':'Weight in kgs'}, 
            inplace = True)
# displaying the DataFrame

Output :

We can see the names of the columns have been changed.

 Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.  

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning – Basic Level Course

My Personal Notes arrow_drop_up
Recommended Articles
Page :