how to check for multiple conditions in multiple columns in pandas dataframe based on duplicates in the same dataframe code example

Example 1: select rows with multiple conditions pandas query

df.query('Salary_in_1000 >= 100 & Age < 60 & FT_Team.str.startswith("S").values')

Example 2: select rows with multiple conditions pandas query

df.loc[idx]