Oppiskele Is Data in ...? | Extracting Data

In this section, we will continue extracting data using specific conditions. Here, you will become familiar with the helpful method called .isin(). But firstly, you need to examine the dataset. Look at the first five rows:


              123
            
import pandas as pd
data = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/4bf24830-59ba-4418-969b-aaf8117d522e/cars.csv', index_col = 0)
print(data.head())

Now, take a look at the example and the explanation below:


              12345
            
import pandas as pd
data = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/4bf24830-59ba-4418-969b-aaf8117d522e/cars.csv', index_col = 0)
models = ['HONDA', 'FORD', 'MERCEDES-BENZ', 'HYUNDAI']
data_extracted = data.loc[data['Manufacturer'].isin(models)]
print(data_extracted.head())

Explanation:

If you remember, we always put the conditions inside the .loc[] attribute. Here, we do the same. The .isin(list) method checks if the values from the column are in the array. In our case, we check if values from the column 'Manufacturer' are in the list models.

Tehtävä

Swipe to start coding

Your task here is to extract data about cars where values from the column 'Color' are equal to 'Grey', 'White', 'Black'. Follow the algorithm to easily manage with the task:

Create the colors list with the elements 'Grey', 'White', 'Black' (in this order).
Extract values from the column 'Color' that the list color consists of. Use the .loc[] attribute.
Output the last five rows of the dataset data_extracted.

Ratkaisu

Oliko kaikki selvää?

Kiitos palautteestasi!

Osio 3. Luku 1

single

Kysy tekoälyä

Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme

Suggested prompts:

Can you explain how the `.isin()` method works in more detail?

What other conditions can I use with `.loc[]` besides `.isin()`?

Can you show more examples of filtering data using different columns?

Pyyhkäise näyttääksesi valikon


              123
            
import pandas as pd
data = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/4bf24830-59ba-4418-969b-aaf8117d522e/cars.csv', index_col = 0)
print(data.head())

Now, take a look at the example and the explanation below:


              12345
            
import pandas as pd
data = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/4bf24830-59ba-4418-969b-aaf8117d522e/cars.csv', index_col = 0)
models = ['HONDA', 'FORD', 'MERCEDES-BENZ', 'HYUNDAI']
data_extracted = data.loc[data['Manufacturer'].isin(models)]
print(data_extracted.head())

Explanation:

Tehtävä

Swipe to start coding

Your task here is to extract data about cars where values from the column 'Color' are equal to 'Grey', 'White', 'Black'. Follow the algorithm to easily manage with the task:

Create the colors list with the elements 'Grey', 'White', 'Black' (in this order).
Extract values from the column 'Color' that the list color consists of. Use the .loc[] attribute.
Output the last five rows of the dataset data_extracted.

Ratkaisu

Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoista

Oliko kaikki selvää?

Kiitos palautteestasi!

Osio 3. Luku 1

single

Is Data in ...?

Ratkaisu

Awesome!

Is Data in ...?

Ratkaisu

Awesome!