pandas filter values code example
Example 1: only keep rows of a dataframe based on a column value
df.loc[df['column_name'] == some_value]
Example 2: pandas filter rows by value in list
df.loc[df['col name'].isin(ls_conditions)]
Example 3: how to apply filters in pandas
>gapminder_2002 = gapminder[gapminder.year.eq(2002)]
>print(gapminder_2002.shape)
(142, 6)
Example 4: pandas filter rows by value
>is_2002 = gapminder['year']==2002
>print(is_2002.head())
0 False
1 False
2 False
3 False
4 False
>gapminder_2002 = gapminder[is_2002]
>print(gapminder_2002.shape)
(142, 6)
Example 5: pandas filter
>continents = ['Asia','Africa', 'Americas', 'Europe']
>gapminder_Ocean = gapminder[~gapminder.continent.isin(continents)]
>gapminder_Ocean.shape
(24,6)
Example 6: pandas filter
years = [1952, 2007]
gapminder.year.isin(years)