Filtering and sorting

A comparison on a column produces a boolean Series. Passing it back into the frame keeps the rows where it is True.

Combine conditions with & and | — each condition needs its own brackets. .isin() matches a list of values and ~ negates a mask.

Use .loc for label-based selection of rows and columns at once, and sort_values to order the result.