DataFrame.query() and DataFrame.eval()

Import

queryDataFrame(df, expr)

Returns a new DataFrame containing only the rows where expr evaluates to truthy.

evalDataFrame(df, expr)

Evaluates an arithmetic or logical expression and returns a new Series.