Sorting in Pandas

Program 1

Pandas Dataset

# Sorting 
import pandas as pd
myfile="D://mypandas/employee.xlsx"
df=pd.read_excel(myfile)
#print(df)
#print(df.sort_index(ascending=True))
#print(df.sort_values(['empname'],ascending=False))
#print(df.columns)
#print(df.sort_values('totalsalary'))

Program 2

# Duplicate 
import pandas as pd
myfile="D://mypandas/employee.xlsx"
df=pd.read_excel(myfile)
print("Before Remove: ")
print(df.duplicated())
print(df.size)
print("------------------------------------------------")
df.drop_duplicates(inplace=True)
print("After Remove: ")
print(df.duplicated())
df.to_excel("D://mypandas/employeenewdata.xlsx")
print("..................Success...........")
# df1=df.drop_duplicates()
# print("After Remove: ")
# print(df1.duplicated())
# print(df1.size)
#print(df)