Multiple conditions with & and | in Pandas - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the & operator do in pandas when filtering data?

The & operator is used to combine multiple conditions with a logical AND, meaning both conditions must be true for the row to be selected.

beginner

How do you combine multiple conditions with OR in pandas?

Use the | operator to combine conditions with a logical OR, so if any condition is true, the row is selected.

intermediate

Why do you need to put each condition in parentheses when using & or | in pandas?

Parentheses ensure the correct order of operations because & and | have lower precedence than comparison operators like > or ==.

beginner

Example: What does df[(df['age'] > 20) & (df['score'] < 50)] do?

It selects rows where the 'age' is greater than 20 AND the 'score' is less than 50.

beginner

Can you use 'and' or 'or' instead of & and | for filtering pandas DataFrames?

No, 'and' and 'or' do not work element-wise on pandas Series. You must use & for AND and | for OR with parentheses.

Which operator is used for element-wise AND in pandas filtering?

A |

B and

C &

D &&

In pandas, & is used for element-wise AND. 'and' is not valid for Series.

What is the correct way to filter rows where 'age' > 30 OR 'score' < 70?

A df[(df['age'] > 30) | (df['score'] < 70)]

B df[df['age'] > 30 | df['score'] < 70]

C df[df['age'] > 30 or df['score'] < 70]

D df[(df['age'] > 30) and (df['score'] < 70)]

Parentheses are needed around each condition when using |. 'or' and 'and' do not work element-wise.

Why must each condition be in parentheses when using & or | in pandas?

A Because & and | have lower precedence than comparison operators

B To improve code readability only

C It is optional

D To avoid syntax errors unrelated to precedence

Parentheses ensure the comparisons happen before & or |, avoiding logic errors.

What happens if you use 'and' instead of '&' in pandas filtering?

A It works the same

B It raises an error

C It filters rows incorrectly

D It converts to '&' automatically

'and' cannot be used with pandas Series and raises a ValueError.

Which of these filters rows where 'status' is 'active' AND 'score' is above 80?

A df[df['status'] == 'active' and df['score'] > 80]

B df[df['status'] == 'active' & df['score'] > 80]

C df[(df['status'] == 'active') and (df['score'] > 80)]

D df[(df['status'] == 'active') & (df['score'] > 80)]

Each condition must be in parentheses and combined with & for AND.

Explain how to filter a pandas DataFrame using multiple conditions with & and | operators.

Think about how to combine true/false checks for each row.

Describe why parentheses are important when using multiple conditions in pandas filtering.

Consider how Python reads expressions step-by-step.