Difference Between loc() and iloc() in Pandas

DataFlair Team

1 year ago

Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!!

Program 1

# loc and iloc methods
import pandas as pd
myfile="D://mypandas/employee1.xlsx"
df=pd.read_excel(myfile)
print(df.loc[5,'empname'])





# m=int(input("Enter starting index value: "))
# n=int(input("Enter ending index value: "))
#print(df.iloc[m:n,[1,4]])
#print(df.iloc[m:n,[1,2,3]])

# m=int(input("Enter index value: "))
# print(df.iloc[m,[1,4]])
# m=int(input("Enter starting index value: "))
# n=int(input("Enter ending index value: "))
# #print(df.loc[1:5])
# print(df.loc[m:n,'empname'])
# n=int(input("Enter index value: "))
# #print(df.loc[n,['empname','totalsalary']])