Answers for "df.query multiple conditions"

6

select rows with multiple conditions pandas query

df.loc[(df['Salary_in_1000']>=100) & (df['Age']< 60) & (df['FT_Team'].str.startswith('S')),['Name','FT_Team']]
Posted by: Guest on June-20-2020
6

or condition in pandas

df1 = df[(df.a != -1) & (df.b != -1)]
Posted by: Guest on June-03-2020
4

or condition in pandas

df2 = df[(df.a != -1) | (df.b != -1)]
Posted by: Guest on June-03-2020
2

select rows with multiple conditions pandas query

df.query('Salary_in_1000 >= 100 & Age < 60 & FT_Team.str.startswith("S").values')
Posted by: Guest on June-20-2020

Code answers related to "df.query multiple conditions"

Python Answers by Framework

Browse Popular Code Answers by Language