Dynamic String Filtering with DataFrame.query() in Pandas

Question

Use `df.query()` to filter rows where `status == 'Active'`, `age > 25`, and `salary` exceeds a dynamic Python variable `min_salary = 75000`.

Accepted Answer

Optimal Solution:
import pandas as pd

min_salary = 75000

# Using @ to reference local Python variables inside the query expression
filtered = df.query("status == 'Active' and age > 25 and salary > @min_salary")[['name', 'salary']]

Technical Explanation:
`.query()` evaluates boolean expressions using numexpr. Prepending `@` to a variable name references the local Python environment variable cleanly.

name	status	age	salary
Sachin	Active	27	85000
Rahul	Active	23	80000
Pooja	Inactive	30	95000