Filtering & Sorting

Use BOOLEAN MASKS to filter rows and `sort_values` to reorder.

Combine filters with `&` (and) and `|` (or), and wrap each condition in parentheses.

Example 1 (python)

import pandas as pd
df = pd.read_csv('sales.csv')
recent = df[(df['year'] == 2025) & (df['amount'] > 1000)]

Multi-condition filter.

Example 2 (python)

print(df.sort_values('amount', ascending=False).head())

Sort by amount descending.

Key points

💡 Note: Forgetting parentheses around each condition is one of the most common pandas errors.