Filtering a Dataframe Using AND

Python

In this code snippet we use "&" to include two conditions when filtering a Pandas dataframe.

Here we filter the orders dataframe where PromoID is "30_OFF" and the ProductID is 228722.

 1|  orders[(orders['PromoID'] == '30_OFF') & (orders['ProductID'] == 228722)]
analyseup
Filter | AND
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

147
LightGBM Custom Loss Function
Python

LightGBM | Loss function

131
Tuning XGBoost Hyperparameters with Grid Search
Python

XGBoost | Tuning

125
How to Convert DataFrame Values Into Percentages
Python

Lambda | Percentages | Pipe

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

Scaler | Standard

89
LightGBM Hyperparameter Tuning with GridSearch
Python

Python | LightGBM | Hyperparameter tuning | Gridsearch

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

Rmse

85
Dynamically Create Columns in Pandas Dataframe
Python

Pandas | Columns

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

Catboost | Hyperparameter tuning

67
Overwriting a Python Logging File Instead of Appending
Python

Logging

63