# Learn More About Indexation

Let's move further and continue extracting columns and rows by indices. So, you need to be familiar with a function similar to `loc[]`

.

Our following function is `iloc[]`

; it is like **index-location**, and you may have guessed that it allows us to work with both columns' and rows' indices.

Firstly, we need to recall indices. The **first** row has the index `0`

, the next one `1`

, the next `2`

, and so on. But also, we can count from the end (indeed, this is not convenient in datasets, but it may be helpful somehow), so the **last** one has the index `-1`

, the **second-to-last** is `-2`

, and so on...

Look at the table:

However, we will start with the simplest implementation of the function `iloc[]`

, working with the following data set (below are its first five rows):

Look to the code example and output:

`data.iloc[0]`

- extracts the**very first**row of the dataset;`data.iloc[1]`

- extracts the**second**row of the dataset;`data.iloc[-1]`

- extracts the**very last**row of the dataset;`data.iloc[-2]`

- extracts the**second-to-last**row of the dataset.

As you may have recognized, at the end of the output, the variable `Name`

shows the row number too, like `Name: 998`

.

## Question

**Replace the placeholders** `___`

**in a code window with your code to answer the question below it**.

Note that the index of a first person is **0**.

Everything was clear?

Course Content

Advanced Techniques in pandas

## Advanced Techniques in pandas

1. Get Familiar With Indexing and Selecting Data

# Learn More About Indexation

Let's move further and continue extracting columns and rows by indices. So, you need to be familiar with a function similar to `loc[]`

.

Our following function is `iloc[]`

; it is like **index-location**, and you may have guessed that it allows us to work with both columns' and rows' indices.

Firstly, we need to recall indices. The **first** row has the index `0`

, the next one `1`

, the next `2`

, and so on. But also, we can count from the end (indeed, this is not convenient in datasets, but it may be helpful somehow), so the **last** one has the index `-1`

, the **second-to-last** is `-2`

, and so on...

Look at the table:

However, we will start with the simplest implementation of the function `iloc[]`

, working with the following data set (below are its first five rows):

Look to the code example and output:

`data.iloc[0]`

- extracts the**very first**row of the dataset;`data.iloc[1]`

- extracts the**second**row of the dataset;`data.iloc[-1]`

- extracts the**very last**row of the dataset;`data.iloc[-2]`

- extracts the**second-to-last**row of the dataset.

As you may have recognized, at the end of the output, the variable `Name`

shows the row number too, like `Name: 998`

.

## Question

**Replace the placeholders** `___`

**in a code window with your code to answer the question below it**.

Note that the index of a first person is **0**.

Everything was clear?