# Filter dataframe by multiple values in a column or multiple columns
# SQL equivalent: WHERE columnA IN ('val1', 'val2') AND columnB > 70
df[ (df.columnA.isin(['val1', 'val2'])) & (df['columnB'] > 70) ]
other = pd.DataFrame({'num_legs': [8, 3], 'num_wings': [0, 2]},
... index=['spider', 'falcon'])
>>> df.isin(other)
num_legs num_wings
falcon False True
dog False False