Pandas Select Rows By Multiple Conditions Code Example

Snippet 1
  # 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] 
Snippet 2
  >>> 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
 
Snippet 3
  df.loc[idx]
 
Snippet 4
  # 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')]
 
Snippet 5
  df.loc[(df['Salary_in_1000']>=100) & (df['Age']< 60) & (df['FT_Team'].str.startswith('S')),['Name','FT_Team']]
 

Similar Snippets


Pandas Count Rows With Value Code Example - pandas

Pandas Show Top 10 Rows Code Example - pandas

Pandas Select All Columns Except One Code Example - pandas

Pandas Iterrows Code Example - pandas

Slicing In Pandas Code Example - pandas

Add An Index Column Pandas Code Example - pandas

Pandas Ttable With Sum Totals Code Example - pandas

Remove 1st Column Pandas Code Example - pandas

Pandas Dataframe Froms String Code Example - pandas

Combine Two Dataframe In Pandas Code Example - pandas

Str_Count On Pandas Series Code Example - pandas

Convert Pandas Data Frame To Latex File Code Example - pandas

Append New Data On Pandas Dataframe Code Example - pandas

Getting Dummies And Input Them To Pandas Dataframe Code Example - pandas

How To Drop Columns In Pandas Code Example - pandas

How To Change Column Name In Pandas Code Example - pandas

Index Max Pandas Code Example - pandas

Rename Row Pandas Code Example - pandas

Dictionary To A Dataframe Pandas Arrays Must All Be Same Length Code Example - pandas

Pandas Cumulative Sum Column Code Example - pandas

Creating A Pandas Df Code Example - pandas

Pandas Read From Website Code Example - pandas

How To Merge Two Column Pandas Code Example - pandas

How To Set Pandas Dataframe As Global Code Example - pandas

Pandas Merge Two Columns From Different Dataframes Code Example - pandas

Pandas Read Excel With Two Headers Code Example - pandas

Pandas Frame Convert String Code Example - pandas

Onehot Encode List Of Columns Pandas Code Example - pandas

Reshape Wide To Long In Pandas Code Example - pandas