/Python/Pandas select rows by multiple conditions

Pandas select rows by multiple conditions

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']]

Source: kanoki.org

How to slicing dataframe using two conditions

# when you wrap conditions in parantheses, you give order
# you do those in brackets first before 'and'
# AND
movies[(movies.duration >= 200) & (movies.genre == 'Drama')]

Source: ritchieng.com

New dataframe based on certain row conditions

# Create variable with TRUE if nationality is USA
american = df['nationality'] == "USA"

# Create variable with TRUE if age is greater than 50
elderly = df['age'] > 50

# Select all cases where nationality is USA and age is greater than 50
df[american & elderly]

Source: chrisalbon.com

Select rows with multiple conditions pandas query

df.query('Salary_in_1000 >= 100 & Age < 60 & FT_Team.str.startswith("S").values')

Source: kanoki.org

Pandas select rows by multiple conditions

>>> df["A"][(df["B"] > 50) & (df["C"] == 900)]
2    5
3    8
Name: A, dtype: int64
    
>>> df.loc[(df["B"] > 50) & (df["C"] == 900), "A"]
2    5
3    8
Name: A, dtype: int64
>>> df.loc[(df["B"] > 50) & (df["C"] == 900), "A"].values
array([5, 8], dtype=int64)
>>> df.loc[(df["B"] > 50) & (df["C"] == 900), "A"] *= 1000
>>> df
      A   B    C
0     9  40  300
1     9  70  700
2  5000  70  900
3  8000  80  900
4     7  50  900

Source: stackoverflow.com

Similar codes

9 votes110 views1 answer
Ardent
Python
7 votes107 views1 answer
Get inverse dict python
Python
-1 vote132 views2 answers
This code is supposed to display "2 + 2 = 4" on the screen, but there is an error. Find the error in the code and fix it, so that the output is correct.
Python
0 vote96 views1 answer
Wie printe ich in python
Python
0 vote106 views1 answer
Hpw to create related model in django rest framework logic
Python
94 votes99 views6 answers
For in python
Python
21 votes96 views5 answers
Base64 encode python
Python
16 votes100 views2 answers
Python reload import
Python
28 votes134 views2 answers
Simple python for loop print 1 to 5
Python
0 vote119 views1 answer
Autoscrapper installation
Python