How to filter a DataFrame using multiple conditional statements

0 min

We define a sample DataFrame

import pandas as pd

# We read a sample dataset from the web.
df = pd.read_csv('https://raw.githubusercontent.com/mwaskom/seaborn-data/master/iris.csv')
We read our sample dataset

N conditional statements

It is possible to add more than one conditional statement like so

# The mask
mask_1 = df["sepal_length"] > .4
mask_2 = df["sepal_width"] > 3.1

# We apply the mask
print(df[mask_1 & mask_2])
Defining two conditional statements as masks 

Or the oneliner :

# We apply the mask
print(df[(df["sepal_length"] > .4) & (df["sepal_width"] > 3.1)])
In one line of code

Here you are!

Now you might be interested in learning what kind of filter you can do.