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:

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.

 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.

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.