/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 vote274 views1 answer
How to initialise key of a dictionary a list
Python
1 vote307 views1 answer
How to extract data from website using beautifulsoup
Python
10 votes357 views2 answers
Python copy dir
Python
3 votes345 views1 answer
Finding 2 decimal places python
Python
0 vote371 views1 answer
Show all urls django extensions
Python
5 votes409 views2 answers
Get_object_or_404 django
Python Django
0 vote392 views1 answer
To create a SparkSession
Python
0 vote337 views1 answer
Reveal a defined function in python
Python
0 vote344 views1 answer
How do i select a range of columns by index
Python
1 vote327 views1 answer
How to remove seconds from datetime in python
Python

Share