Free Pandas course with real-time projects Start Now!!
Program 1
import pandas as pd
emp=pd.read_excel("E:\mypandas\employee.xlsx")
#print(emp)
#print(emp.nlargest(10,columns='salary'))
#select * from employee order by salary desc limit 4;
#print(emp.nlargest(8,columns='salary').tail(4))
#print(emp.nlargest(10,columns='HRA').head(5))
#print(emp.nlargest(10,columns='HRA').tail(5))