# 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']]
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
Add An Index Column Pandas Code Example - pandas
Pandas Ttable With Sum Totals Code Example - pandas
Remove 1st Column Pandas Code Example - pandas
Pandas Iterrows Code Example - pandas
Slicing In Pandas 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
Pandas Dataframe Froms String Code Example - pandas
Combine Two Dataframe In Pandas Code Example - pandas
Str_Count On Pandas Series Code Example - pandas
Rename Row Pandas Code Example - pandas
Dictionary To A Dataframe Pandas Arrays Must All Be Same Length Code Example - pandas
How To Drop Columns In Pandas Code Example - pandas
How To Change Column Name In Pandas Code Example - pandas
Creating A Pandas Df Code Example - pandas
Pandas Read From Website Code Example - pandas
Index Max Pandas Code Example - pandas
Pandas Cumulative Sum Column Code Example - pandas
Onehot Encode List Of Columns 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 Frame Convert String Code Example - pandas
How To Merge Two Column Pandas Code Example - pandas