Here is a quick and efficient way to filter the column values that are contained in a list using the DataFrame.isin() method.

Imagine that we have a DataFrame containing GDP observations per country for 2021.

But now we only want to select a few countries by name.

E.g. filter for Germany and France

Here is the code

# To work with dataframes
import pandas as pd

# We create our sample dataframe
df = pd.DataFrame({"Country" : ["Germany", "USA", "France"],
                             "Temperatures" : [3332000000, 
                             			       20839000000,
                                               2603000000]})
                                               
# A list of values we are interested in
selected_countries = ["Germany","France"]

# We filter only for the countries that are in the provided list
mask = df["Country"].isin(selected_countries)

# We print the dataframe
print(df[mask])

How to only get the column values that are contained in a list

Here you are! You know now how to only get the column values that are in a list with Pandas using Python.

More on DataFrames

If you want to know more about DataFrame and Pandas. Check out the other articles I wrote on the topic, just here :

Pandas - The Python You Need

We gathered the only Python essentials that you will probably ever need.

The Python You Need

How to only get the column values that are in a list with Pandas using Python

Land Your First Data Science Job

Here is the code

More on DataFrames

Land Your First Data Science Job

Related Articles

Master Data Science in Days, Not Months 🚀

Related Articles

Getting Started
3 min read
How long does it take to learn Python for Data Science in 2023
Learn how long it takes to learn Python for Data Science in 2021. What does it take to be a Data Scientist in 2021?
4/18/2023Read More

DataFrame
1 min read
How to merge two time-series DataFrames with different time intervals
Learn how to merge time-series DataFrames with different frequencies in Pandas using the resample and merge/concat methods.
4/8/2023Read More

Finance
2 min read
How to do Financial Analysis with Pandas using Python
Learn how to use yfinance, a Python library to fetch financial market data such as stock prices, dividends, financial statements, options, and sustainability data for a company or index. With yfinance, you can easily retrieve and analyze financial data for informed decision-making.
4/6/2023Read More