/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

1 vote182 views3 answers
Isprime python
Python
1 vote166 views2 answers
Split dataframe into multiple parts
Python
0 vote175 views1 answer
Day 14 scope hackerrank solution in python
Python
7 votes149 views4 answers
Jupyter notebook plot larger
Python
0 vote140 views2 answers
Python script in excel
Python
0 vote176 views1 answer
Module 'networkx' has no attribute 'graphviz_layout'
Python
0 vote150 views3 answers
How to print a text in python
Python
1 vote152 views1 answer
How to select parts of a numpy array
Python
11 votes189 views2 answers
How to find the position in a list python
Python
0 vote238 views1 answer
Get end of string python
Python

Share