Adding new column to existing DataFrame in Pandas

Let’s discuss how to add new columns to existing DataFrame in Pandas. There are multiple ways we can do this task.

Method #1: By declaring a new list as a column.

filter_none

edit
close

play_arrow

link
brightness_4
code

# Import pandas package 
import pandas as pd
  
# Define a dictionary containing Students data
data = {'Name': ['Jai', 'Princi', 'Gaurav', 'Anuj'],
        'Height': [5.1, 6.2, 5.1, 5.2],
        'Qualification': ['Msc', 'MA', 'Msc', 'Msc']}
  
# Convert the dictionary into DataFrame
df = pd.DataFrame(data)
  
# Declare a list that is to be converted into a column
address = ['Delhi', 'Bangalore', 'Chennai', 'Patna']
  
# Using 'Address' as the column name
# and equating it to the list
df['Address'] = address
  
# Observe the result
df

chevron_right






                        filter_none










Output:

Image


Note that the length of your list should match the length of the index column otherwise it will show an error.

 

Method #2: By using DataFrame.insert()


It gives the freedom to add a column at any position we like and not just at the end. It also provides different options for inserting the column values.















                                    filter_none




                                    edit

                                    close




                                    play_arrow




                                    link

                                    brightness_4

                                    code
                                




















# Import pandas package  


import pandas as pd 


  


# Define a dictionary containing Students data 


data = {'Name': ['Jai', 'Princi', 'Gaurav', 'Anuj'], 


        'Height': [5.1, 6.2, 5.1, 5.2], 


        'Qualification': ['Msc', 'MA', 'Msc', 'Msc']} 


  


# Convert the dictionary into DataFrame 


df = pd.DataFrame(data) 


  


# Using DataFrame.insert() to add a column 


df.insert(2, "Age", [21, 23, 24, 21], True) 


  


# Observe the result 


df 



















                        chevron_right







                        filter_none










Output:

Image

 


Method #3: Using Dataframe.assign() method


This method will create a new dataframe with new column added to the old dataframe.













                                    filter_none




                                    edit

                                    close




                                    play_arrow




                                    link

                                    brightness_4

                                    code
                                




















# Import pandas package  


import pandas as pd 


   


# Define a dictionary containing Students data 


data = {'Name': ['Jai', 'Princi', 'Gaurav', 'Anuj'], 


        'Height': [5.1, 6.2, 5.1, 5.2], 


        'Qualification': ['Msc', 'MA', 'Msc', 'Msc']} 


   


   


# Convert the dictionary into DataFrame 


df = pd.DataFrame(data) 


  


# Using 'Address' as the column name and equating it to the list 


df2 = df.assign(address = ['Delhi', 'Bangalore', 'Chennai', 'Patna']) 


   


# Observe the result 


df2 



















                        chevron_right







                        filter_none










Output:

Image

 

Method #4: By using a dictionary


We can use a Python dictionary to add a new column in pandas DataFrame. Use an existing column as the key values and their respective values will be the values for new column. 













                                    filter_none




                                    edit

                                    close




                                    play_arrow




                                    link

                                    brightness_4

                                    code
                                




















# Import pandas package  


import pandas as pd 


  


# Define a dictionary containing Students data 


data = {'Name': ['Jai', 'Princi', 'Gaurav', 'Anuj'], 


        'Height': [5.1, 6.2, 5.1, 5.2], 


        'Qualification': ['Msc', 'MA', 'Msc', 'Msc']} 


  


# Define a dictionary with key values of 


# an existing column and their respective 


# value pairs as the # values for our new column. 


address = {'Delhi': 'Jai', 'Bangalore': 'Princi', 


           'Patna': 'Gaurav', 'Chennai': 'Anuj'} 


  


# Convert the dictionary into DataFrame 


df = pd.DataFrame(data) 


  


# Provide 'Address' as the column name 


df['Address'] = address 


  


# Observe the output 


df 



















                        chevron_right







                        filter_none










Output:

Image


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.





    

        My Personal Notes
        arrow_drop_up
    

    

        
        

            
            
        

    


Recommended Posts:
Image
Chaitanya Tyagi
Check out this Author's contributed articles.
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on  the "Improve Article" button below.