Setting Condition
In this section, we will learn how to extract data using specific conditions, but first I want you to examine the data set we will use. It includes data on asteroids:
id
- Unique identifier for each asteroid;name
- Name given by NASA;est_diameter_min
- Minimum estimated diameter in kilometers;est_diameter_max
- Maximum estimated diameter in kilometers;absolute_magnitude
- Describes how light the object is;hazardous
- Boolean feature that shows whether asteroid is harmful or not.
You are already familiar with the .loc[]
attribute, but here we will expand its possibilities.
One of the most useful tools is to set conditions on a column to extract specific values. So, you just put the condition of the column inside the .loc[]
attribute. Look at the several conditions and outputs.
data.loc[data['est_diameter_max'] < 0.005].head()
- extracts the first five rows where the column values'est_diameter_max'
are less then0.005
;data.loc[data['absolute_magnitude'] >= 30].head()
- extracts the first five rows where the column values'absolute_magnitude'
are greater than or equal to30
.
Tak for dine kommentarer!
Spørg AI
Spørg AI
Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat
Awesome!
Completion rate improved to 3.03
Setting Condition
Stryg for at vise menuen
In this section, we will learn how to extract data using specific conditions, but first I want you to examine the data set we will use. It includes data on asteroids:
id
- Unique identifier for each asteroid;name
- Name given by NASA;est_diameter_min
- Minimum estimated diameter in kilometers;est_diameter_max
- Maximum estimated diameter in kilometers;absolute_magnitude
- Describes how light the object is;hazardous
- Boolean feature that shows whether asteroid is harmful or not.
You are already familiar with the .loc[]
attribute, but here we will expand its possibilities.
One of the most useful tools is to set conditions on a column to extract specific values. So, you just put the condition of the column inside the .loc[]
attribute. Look at the several conditions and outputs.
data.loc[data['est_diameter_max'] < 0.005].head()
- extracts the first five rows where the column values'est_diameter_max'
are less then0.005
;data.loc[data['absolute_magnitude'] >= 30].head()
- extracts the first five rows where the column values'absolute_magnitude'
are greater than or equal to30
.
Tak for dine kommentarer!