/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

0 vote178 views1 answer
Pyqt graph
Python
0 vote153 views1 answer
Python csv row index is empty
Python
0 vote147 views1 answer
Python Script to check how many images are broken
Python
73 votes157 views6 answers
Reverse the string in python
Python
23 votes179 views1 answer
How to extract month from date in python
Python
0 vote150 views1 answer
Sxrf argument missing from post
Python
0 vote146 views1 answer
Tkinter set text
Python
1 vote161 views1 answer
Import open3d Illegal instruction (core dumped)
Python
155 votes243 views6 answers
Python os if file exists
Python
1 vote148 views1 answer
Sorting by second element
Python