How to filter a DataFrame using multiple conditional statements
• 0 minWe 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')
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])
Or the oneliner :
# We apply the mask
print(df[(df["sepal_length"] > .4) & (df["sepal_width"] > 3.1)])
Here you are!
Now you might be interested in learning what kind of filter you can do.