/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

15 votes203 views3 answers
Max int python
Python
28 votes203 views2 answers
Python print without new lines
Python
8 votes175 views4 answers
Reverse dictionary python
Python
0 vote211 views1 answer
Nibabel expand dimension
Python
6 votes239 views3 answers
Media url django
Python Django
11 votes244 views3 answers
Shuffle dataframe python
Python
-1 vote208 views1 answer
Django template filter
Python
0 vote218 views1 answer
Flask Upload file to local s3
Python
0 vote216 views1 answer
Python-Generating numbers according to a corellation matrix
Python
91 votes227 views6 answers
How to create a virtual environment in python
Python

Share