How to add new row in Pandas DataFrame

We can easily add a new row in the existing Data Frame. There are various methods to add a new row in Data Frame.

#1. Method:- 

  We can add a new row using the DataFrame.loc() function. This function will add the row at the end. We will use another function len(DataFrame.index) to get the position at which we want to add a new row.

import pandas as pd
dict= { ‘Name’ : [‘Raj’, “Ajay”, “Rahul”], ‘Percentage’ : [78,80,75] }
df= pd. DataFrame(dict)
print(df)
print(“After adding a new row”)
df.loc[ len(df.index) ] = [ “Vikas”, 70]
print(df)

Its output will be

#2. Method:- 

 We can add a new row using the DataFrame.append() function.This function will append the New Data Frame row at the end of the existing DataFrame.

import pandas as pd
import numpy as np
dict= { ‘Name’ : [‘Raj’, “Ajay”, “Rahul”], ‘Percentage’ : [78,80,75] }
df= pd. DataFrame(dict)
print(df)
print(“After adding a new row”)
df2= { “Name” : [“Vikas”], “Percentage” : 70}
df=df.append(df2, ignore_index= True)
print(df)