Setting Condition
Swipe to show menu
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.
Everything was clear?
Thanks for your feedback!
SectionΒ 2. ChapterΒ 1
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 3.03SectionΒ 2. ChapterΒ 1