Filter a Pandas DataFrame Using a List

Python
Data Preprocessing

To use a list to filter a Pandas DataFrame we can make use of the isin function and pass a list of values to keep.

In the example below we pass a list called "values" containing the two values from the Embarked column in our DataFrame that we want to filter for.

 1|  values = ['Q', 'C']
 2|  
 3|  # df will contain only rows that have either a 'Q' or 'C' in
 4|  # the Embarked column
 5|  df = df[df['Embarked'].isin(values)]
DETRO
1 Upvote
Tags: Filter | Isin
Did you find this snippet useful?

Sign up to bookmark this in your snippet library

Normalize Windowed Time Series
Python
Data Preprocessing

Scaler | Normalize | Scale | Min-max

4
Convert All Non-numeric Columns to Category Data Types
Python
Data Preprocessing

Pandas

4
Creating a Running Total Column in Pandas
Python
Data Preprocessing

Pandas

3
Pivoting Pandas Dataframes
Python
Data Preprocessing

Pandas

3
Renaming Columns in a Pandas Dataframe Using Dictionaries & Lists
Python
Data Preprocessing

Rename

2
How to Remove Punctuation From Text with Python
Python
Data Preprocessing

Nlp | String | Punctuation

2
How To Set First Row of a Pandas Dataframe as Column Headers
Python
Data Preprocessing

Headers

2
How to Create Different Aggregations Using GroupBy, Agg & Dictionaries
Python
Data Preprocessing

Groupby | Agg

2
Using Pandas GroupBy Transform Function
Python
Data Preprocessing

Transform | Groupby

2
Extract Date & Time Features From a Pandas Date Column
Python
Data Preprocessing

Dt | Dates

2