Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Combine Your Knowledge | Extract Data
Advanced Techniques in pandas

Combine Your Knowledge

If you remember, several chapters ago you were provided with information on how to write several conditions simultaneously. With the .isin() statement, you can use the same rules. For instance, an example from the previous chapter could look like this:

The output in these two cases will be the same.

question-icon
Your task here is to make the data satisfy three conditions: cars' categories are 'Sedan', 'Jeep', 'Coupe', AND the car has a leather interior (`'Leather_interior' == Yes`), AND the types of gear box are 'Variator' or 'Automatic'.

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

categories = ['Sedan', 'Jeep', 'Coupe']
gear_box = ['Variator', 'Automatic']

condition_1 = data['Category'].

(categories)
condition_2 = data['Leather_interior']
'Yes'
condition_3 = data['Gear_box_type'].


data_extracted = data.loc[condition_1
condition_2condition_3]

¿Todo estuvo claro?

Sección 3. Capítulo 2
course content

Contenido del Curso

Advanced Techniques in pandas

Combine Your Knowledge

If you remember, several chapters ago you were provided with information on how to write several conditions simultaneously. With the .isin() statement, you can use the same rules. For instance, an example from the previous chapter could look like this:

The output in these two cases will be the same.

question-icon
Your task here is to make the data satisfy three conditions: cars' categories are 'Sedan', 'Jeep', 'Coupe', AND the car has a leather interior (`'Leather_interior' == Yes`), AND the types of gear box are 'Variator' or 'Automatic'.

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

categories = ['Sedan', 'Jeep', 'Coupe']
gear_box = ['Variator', 'Automatic']

condition_1 = data['Category'].

(categories)
condition_2 = data['Leather_interior']
'Yes'
condition_3 = data['Gear_box_type'].


data_extracted = data.loc[condition_1
condition_2condition_3]

¿Todo estuvo claro?

Sección 3. Capítulo 2
some-alt