/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

5 votes157 views3 answers
Urllib3 python
Python
0 vote167 views1 answer
How to make a relationship in python
Python
5 votes173 views3 answers
Python transpose list
Python
0 vote185 views1 answer
Work day prior to date python
Python
2 votes175 views1 answer
Tensorflow math python
Python
0 vote156 views1 answer
Django MESSAGE_TAGS
Python
0 vote150 views1 answer
Python toupls
Python
17 votes176 views3 answers
Python ModuleNotFoundError: No module named '_tkinter'
Python
11 votes176 views1 answer
Python requests wait for page to load
Python
0 vote243 views1 answer
Python delete header row
Python

Share