Filter rows in Pandas DataFrame

Filter rows in Pandas DataFrame based on condition. You can select a column and apply condition on it. Please be aware that there are different conditions for numeric and categorical columns.

rowspandasfilter

Interactive recipe

You can use below interactive recipe to generate code. This recipe is available in MLJAR Studio.

In the below recipe, we assume that you have following variables available in your notebook:

df_1 (type DataFrame)
df_2 (type DataFrame)

Python code

# Python code will be here

Code explanation

Select a column and apply a filtering condition to its values. Only rows that fulfill the condition will be present in the DataFrame.
Display new DataFrame shape.

If you would like to filter based on more columns, please just apply Filter rows in the next cell on the next column.

Data wrangling cookbook

Code recipes from Data wrangling cookbook.

DataFrame info
DataFrame describe
Display DataFrame
Select X,y
Select Columns
Filter rows
Split to train/test
Check missing values
Fill missing values
Use imputer on new data
Categorical to integer
Use encoder on new data

Previous: Select Columns
Next: Split to train/test