In [96]: df Out[96]: A B C D a 1 4 9 1 b 4 5 0 2 c 5 5 1 0 d 1 3 9 6 In [99]: df[(df.A == 1) & (df.D == 6)] Out[99]: A B C D d 1 3 9 6
# filter rows in a dataframe by a condition on a column df_filtered = df.loc[df['column'] == value]
filter = df['column']!= 0 df = df[filter]
# filter rows for year 2002 using the boolean expression >gapminder_2002 = gapminder[gapminder.year.eq(2002)] >print(gapminder_2002.shape) (142, 6)
>continents = ['Asia','Africa', 'Americas', 'Europe'] >gapminder_Ocean = gapminder[~gapminder.continent.isin(continents)] >gapminder_Ocean.shape (24,6)