/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 vote361 views1 answer
How to add array and array in python
Python
0 vote332 views1 answer
Make the program title a name python
Python
57 votes247 views3 answers
Python interpreter clear screen
Python
60 votes268 views6 answers
Python current date
Python
1 vote251 views1 answer
Upload_file boto3 headers
Python
11 votes287 views3 answers
Twitter bot python
Python
3 votes296 views1 answer
Flask upload
Python Flask
0 vote252 views1 answer
Matplotlib transparent line
Python
6 votes273 views3 answers
Download image from url python 3
Python
0 vote277 views2 answers
Create column with values mapped from another column python
Python

Share