</>
pythonbeginner

Pandas .query() for Readable Filters

Use DataFrame.query() with expressions for cleaner, SQL-like row filtering syntax.

python
import pandas as pd

df = pd.DataFrame({'name':['Alice','Bob','Carol','Dave'],'age':[28,35,22,41],'dept':['eng','hr','eng','finance'],'salary':[90000,60000,75000,110000]})

result = df.query("age > 25 and dept == 'eng'")
print(result)

min_salary = 80_000
print(df.query('salary >= @min_salary'))

Use Cases

  • data filtering
  • exploratory analysis
  • readable pipelines

Tags

#pandas#query#filtering#readable

Related Snippets

Similar patterns you can reuse in the same workflow.

pythonbeginner

Pandas DataFrame Filtering Techniques

Filter DataFrames using boolean masks, query syntax, isin, between, and string matching methods.

Best for: Extracting subsets of data for reporting

#pandas#filtering
pythonbeginner

Pandas Named Aggregations

Use named aggregations in groupby().agg() to produce readable, self-documenting summary tables.

Best for: HR reporting

#pandas#groupby
pythonbeginner

Pandas DataFrame Transformations

Common pandas DataFrame transformations including column operations, type casting, and string methods.

Best for: Cleaning raw data files for analysis

#pandas#dataframe
pythonintermediate

Pandas GroupBy Aggregation Examples

GroupBy operations with multiple aggregations, named aggregations, and transform for DataFrame analysis.

Best for: Sales reporting by region and time period

#pandas#groupby