multiple conditions

[snippsat]

Are you using Pandas?
Then that info should be provided in you first post,as the answer may be quite different.
Example how a check look in Pandas,eg using name and salary.

import pandas as pd

df = pd.read_clipboard()
status_check = df[df['name'].str.contains('spiderman|antman') & (df['salary'].between(1000, 2000))]
print(status_check)

Output:
         name  age  salary      city
10  spiderman   30    1000  auckland
11  spiderman   31    1800   beijing
15     antman   34    1200     dubai
16     antman   35    1800  malaysia