รวมตัวกรองด้วย AND และ OR

Real questions stack conditions: adults in Paris, or orders that are late and large. You need to combine filters cleanly. 🧩

To require both conditions, join the two masks with the ampersand. It works element by element across the rows.

To accept either condition, join the masks with the pipe. A row passes if at least one side is True.

Always put parentheses around each condition. Without them, Python evaluates the operators in the wrong order and raises an error.

The plain words and and or work on single True/False values, not on whole Series. For row masks you must use the symbols.

The tilde flips a mask, turning True into False. It is the clean way to say not this condition.

You can blend operators, but parentheses decide the grouping. Make your intent explicit so the logic reads the way you mean it.

Stacking more masks works the same way. For readability, build them on separate lines, then combine the named masks.

Keep the mental model simple: AND shrinks the result toward fewer rows, while OR grows it toward more rows.

Your conditions can touch different columns at once, letting you express rich questions in a single expression.

When logic gets dense, give the combined mask a clear name. Future you will thank you for the readable variable.

Pick the expression that filters correctly.

Use the ampersand for AND, the pipe for OR, the tilde to invert, and always wrap each condition in parentheses. Complex questions, one clean line. ✅