How to Drop Duplicate Values From Pandas DataFrame
Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!!
Program 1
import pandas as pd
df=pd.read_excel("E://mypandas/mydata.xlsx",sheet_name='employee')
print(df.duplicated())
df.drop_duplicates(inplace=True)
print("-------------------After Drop------------------")
print(df.duplicated())
df.to_excel("E://mypandas/newdata.xlsx")
#print(df)
print("Success")
Did you know we work 24x7 to provide you best tutorials
Please encourage us - write a review on Google
