/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

21 votes190 views4 answers
Send dm discord py
Python
0 vote169 views1 answer
Tuple with only one element in Python
Python
12 votes185 views2 answers
Is python object oriented language
Python
0 vote162 views3 answers
Write a Python program to count total number of notes in given amount.
Python
0 vote170 views2 answers
How to update sklearn
Python
5 votes172 views1 answer
Install pygaame using pip
Python
16 votes165 views5 answers
Set window size tkinter
Python
7 votes168 views1 answer
How to find the location of a character in a string in python
Python
0 vote207 views1 answer
How to get a mock image in django?
Python Django
0 vote149 views6 answers
Schedule a function python inside tkinter loop
Python

Share