/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 vote242 views1 answer
Gevent with flask
Python Flask
2 votes204 views2 answers
Numpy moving average
Python
1 vote229 views1 answer
How to iterate pyspark dataframe
Python
19 votes198 views1 answer
Python ignore runtimewarning
Python
5 votes201 views1 answer
Trimming spaces in string python
Python
10 votes237 views3 answers
Create a virtualenv python3
Python
18 votes254 views3 answers
Django-admin startproject
Python Django
1 vote195 views2 answers
Subtract from dataframe column
Python
0 vote206 views1 answer
Remove bg from pic using pthon
Python
0 vote204 views1 answer
Square all elements in list python
Python

Share