Course Content

Advanced Techniques in pandas

1. Getting Familiar With Indexing and Selecting Data

Outputting Columns by Title Outputting Rows by Index Selecting Specific Rows and Columns Learning More About Indexation Getting Familiar With lambda Functions Expanding Functionality of the .iloc[] Attribute

2. Dealing With Conditions

Setting Condition Selecting Data Based on Condition Dealing With Several Conditions Making Your Code Beautiful Conditions Quiz

3. Extracting Data

Is Data in ...?Combining Your Knowledge Between Method Extracting Specific Data Finding the Smallest Values of a Column Finding the Largest Values of a Column Finding the Correlation

4. Aggregating Data

Getting Familiar With the .groupby() Method Grouping by Several Columns Complicated Grouping Advanced Grouping Dealing With Pivot Tables Creating a Pivot Table

5. Preprocessing Data

Checking for Missing Values Calculating the Number of Missing Values What Will We Do With the NaN Values?How to Delete Only NaN Values?Filling In the Missing Values Managing Categorical Variables Checking the Column Type Managing an Incorrect Column Renaming the Column

Learning More About Indexation

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

Our following attribute 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 attribute 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.


              12345
            
import pandas as pd
data = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/4bf24830-59ba-4418-969b-aaf8117d522e/people.csv')

print(data.___) # CHANGE CODE HERE (to answer the question below)
print(data.___) # CHANGE CODE HERE (to answer the question below)

Note that the index of a first person is 0.

Everything was clear?

Thanks for your feedback!

Section 1. Chapter 4

Ask AI

Ask anything or try one of the suggested questions to begin our chat