/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

7 votes229 views1 answer
Pandas insert column in the beginning
Python
0 vote240 views1 answer
Regrid ntdcf file usig xarray
Python
0 vote239 views1 answer
Mysql pyzo
Python
1 vote187 views1 answer
Get urls from any website use python
Python
8 votes299 views2 answers
Flask.pocoo.org quickstart
Python Flask
0 vote297 views1 answer
Django admin.py all fields
Python Django
4 votes256 views4 answers
Filter django or
Python
0 vote250 views1 answer
Django fixtures. To dump data
Python
0 vote228 views1 answer
How to python program
Python
5 votes237 views5 answers
Convert dictionary keys to list python
Python

Share