Select a row of series or dataframe by given integer index

The Dataframe.iloc[] is used to select a row of Series/Dataframe by a given integer index in Python. 

Creating DataFrame to Select a Row by Index

Here, we are creating a Pandas Dataframe with ID, Product, Price, Color, and Discount with there some values in it.

Output:

 

Select the first row only

Here, we are selecting the first rows using iloc, Dataframe.iloc[] method is used when the index label of a data frame is something other than numeric series.

Output: 

 

Selecting  0, 1, 2  rows.

Here, we are selecting the first second, and third rows using iloc[0:3], starting with 0 indexes and ending with (3-1=2) index.

Output:

 

Select rows from 0 to 2 and columns from 0 to 1

Here, we are selecting the first second third rows, and the first and second columns using iloc[0:3].

Output: 

 

Select all rows and 2nd column

Selecting all the rows and only the second columns from the Dataframe.

Output:

 

Select all rows and columns from 0 to 3. 

Selecting all rows and columns.

Output: