How to Delete Row in Python Pandas DataFrame
We can delete row in Python pandas DataFrame by using the “drop” function
To delete any row in DataFrame we use the label or index. By using a label we can easily delete any row from DataFrame. In our example r1, r2, r3, r4, and r5 are labels.
import pandas as pd
data= {‘Name’ : [‘Rahul’, ‘Keshu’, ‘Amit’, ‘Lakhan’, ‘Raj’], ‘Age’ : [15,14,19,16,15] }
df=pd.DataFrame(data, index=[‘r1′,’r2′,’r3′,’r4′,’r5’])
data= {‘Name’ : [‘Rahul’, ‘Keshu’, ‘Amit’, ‘Lakhan’, ‘Raj’], ‘Age’ : [15,14,19,16,15] }
df=pd.DataFrame(data, index=[‘r1′,’r2′,’r3′,’r4′,’r5’])
print(“before deleting DataFrame is“)
print (df)
print(“after deleting the first row with label ‘r1’ using ‘drop’ function”)
df=df.drop(‘r1’)
print (df)
print(“after deleting the first row with label ‘r1’ using ‘drop’ function”)
df=df.drop(‘r1’)
print (df)
its output will be
before deleting DataFrame is
Name Age
r1 Rahul 15
r2 Keshu 14
r3 Amit 19
r4 Lakhan 16
after deleting the first row with label ‘r1’ using ‘drop’ function
Name Age
r2 Keshu 14
r3 Amit 19
r4 Lakhan 16