Filter DataFrame Rows Using In and Not In Equivilant

Python

 1|  sex = ['male']
 2|  
 3|  # filter dataframe to include only male values in the sex column
 4|  males = df[df['Sex'].isin(sex)]
 5|  
 6|  # filter dataframe to include only values that are not male in 
 7|  # the sex column
 8|  females = df[~df['Sex'].isin(sex)]
detro
Pandas | Isin
Did you find this snippet useful?

Sign up for free to to add this to your code library

Remove Stop Words from Text in DataFrame Column
Python

Pandas | Nltk | Nlp

142
LightGBM Custom Loss Function
Python

LightGBM | Loss function

127
Tuning XGBoost Hyperparameters with Grid Search
Python

XGBoost | Tuning

122
How to Convert DataFrame Values Into Percentages
Python

Lambda | Percentages | Pipe

115
How to Scale Data Using Standard Scaler But Keep Column Names
Python

Scaler | Standard

86
LightGBM Hyperparameter Tuning with GridSearch
Python

Python | LightGBM | Hyperparameter tuning | Gridsearch

85
Calculating Root Mean Squared Error (RMSE) with Sklearn and Python
Python

Rmse

82
Dynamically Create Columns in Pandas Dataframe
Python

Pandas | Columns

65
How to Train a Catboost Classifier with GridSearch Hyperparameter Tuning
Python

Catboost | Hyperparameter tuning

65
Overwriting a Python Logging File Instead of Appending
Python

Logging

61