filter dataframe based on condition code example
Example 1: new dataframe based on certain row conditions
# Create variable with TRUE if nationality is USA
american = df['nationality'] == "USA"
# Create variable with TRUE if age is greater than 50
elderly = df['age'] > 50
# Select all cases where nationality is USA and age is greater than 50
df[american & elderly]
Example 2: filter df by column value
# does year equals to 2002?
# is_2002 is a boolean variable with True or False in it
>is_2002 = gapminder['year']==2002
>print(is_2002.head())
0 False
1 False
2 False
3 False
4 False