How to create dynamic filter queries using column names and expressions?

[hkhare42]

Is there a way to create string filter expressions and utilize them in .filter queries? (Similar to pandas df.query()) If not, what's the best way to go about this? Is 'eval' the recommended approach?

For eg.

filters = [("var1","==","10"), ("var2",">=","15")]
filter_expression = " & ".join([f"(_.{var} {operator} {value})" for var, operator, value in filters])

df = df.filter(eval(filter_expression))