PYTHON PANDAS loc[] & iloc[]

.loc[]

.loc[]/ is used to select/access a subset from a DataFrame using row/column names.

Syntax:

<DataFrameObject>.loc[<start row>:

<end row>,<start column>:<end column>]

• To access a row:

<DF object>.loc[<row label>,:]

• To access multiple rows:

<DF object>.loc[<start row>:<end row>,:]

• To access selective columns:

<DF object>.loc[:,<start column>:<end column>]

• To access range of columns and rows:

<DF object>.loc[<start row>:<end row>,<start column><end column>]

iloc[]

.iloc[] is used to obtain subset from DataFrame using row/column numeric index

Syntax:

<DF Object>iloc[<start row idx>:<end row idx>,<start column idx>:<end column idx>]

*idx=index

• To access a row:

<DF Object>.loc[<row index>,:]

• To access multiple rows:

<DF Object>.loc[<start row>:<end row>,:]

• To access selective columns:

<DF Object>.loc[:,<start column>:<end column>]

• To access the range of columns and rows:

<DF Object>.iloc[<start row>:<end row>,<start col>:<end col>]

*use row/column numeric index instead of table