/Python/Select rows with multiple conditions pandas query

Select rows with multiple conditions pandas query

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']]

9

Source: kanoki.org

Select rows with multiple conditions pandas query

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

2

Source: kanoki.org

Similar codes

2 votes257 views2 answers
Django template array index
Python Django
0 vote186 views2 answers
How to update sklearn
Python
48 votes198 views3 answers
Online python compiler with modules
Python
0 vote254 views1 answer
Foreignkey as users from a user group django
Python Django
0 vote183 views1 answer
Compute slice distance from image position
Python
0 vote187 views1 answer
Python. printing varibles
Python
11 votes191 views4 answers
Pd.merge left join
Python
0 vote272 views1 answer
Get all different element of both list python
Python
7 votes181 views2 answers
Python encode comment
Python
1 vote215 views2 answers
Pytorch l2 regularization
Python

Share