What is differences between loc and iloc ?

The main distinction between loc and iloc is that loc is label-based, meaning that you have to specify rows and columns based on their row and column labels. iloc is integer position-based, so you have to specify rows and columns by their integer position values (0-based integer position)

>>> s = pd.Series(list("abcdef"), index=[49, 48, 47, 0, 1, 2])

49 a

48 b

47 c

0 d

1 e

2 f

 

>>> s.loc[0] # value at index label 0

'd'

 

>>> s.iloc[0] # value at index location 0

'a'

 

>>> s.loc[0:1] # rows at index labels between 0 and 1 (inclusive)

0 d

1 e

 

>>> s.iloc[0:1] # rows at index location between 0 and 1 (exclusive)

49 a