/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

0 vote237 views2 answers
Django domain name
Python Django
0 vote177 views1 answer
Sqlalchemy date beween
Python
7 votes190 views5 answers
Python csv to list
Python
12 votes223 views6 answers
Flask
Python Flask
17 votes168 views2 answers
Make selenium headless python
Python
0 vote176 views1 answer
Access value of posted object python
Python
0 vote184 views1 answer
Delete all small Latin letters a from the given string.
Python
0 vote208 views2 answers
Print specific key in dictionary python
Python
11 votes177 views3 answers
Get yesterday date python
Python
1 vote174 views1 answer
Animations text terminal python
Python

Share