/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

1 vote144 views1 answer
Le module SIP n'a pas pu être chargé. Le support Python va être désactivé. ubbuntu 20.04
Python
0 vote137 views1 answer
Rest api error
Python
17 votes150 views5 answers
Append element to list py
Python
2 votes142 views2 answers
ValueError: Shapes (None, 1) and (None, 11) are incompatible keras
Python
5 votes210 views6 answers
Python 3 cheat sheet
Python
0 vote150 views1 answer
Extract nonzero array elements python
Python
1 vote145 views1 answer
Tf.contrib.layers.xavier_initializer() tf2
Python
-1 vote156 views1 answer
How to make a bitcoin miner in pythonn
Python
2 votes146 views4 answers
Difference between 2 dataframes
Python
0 vote139 views1 answer
Python for loop 0 to n
Python