Tutorials References Exercises Videos Menu
Free Website Get Certified Upgrade

Pandas DataFrame isin() Method

❮ DataFrame Reference


Example

Check which cells in the DataFrame that contains either the value 50 or the value 40:

import pandas as pd

data = {
  "name": ["Sally", "Mary", "John"],
  "age": [50, 40, 30]
}

df = pd.DataFrame(data)

print(df.isin([50, 40]))
Try it Yourself »

Definition and Usage

The isin() method checks if the Dataframe contains the specified value(s).

It returns a DataFrame similar to the original DataFrame, but the original values have been replaced with True if the value was one of the specified values, otherwise False.


Syntax

dataframe.isin(values)

Parameters

Parameter Description
values  Required. The values to check if is in the DataFrame.

It can be a list:

df.isin([50, 30])

It can be a Dictionary:

df.isin({'age': [50, 30]})

It can be a Series:

values = pd.Series({"age": 50, "age": 40})
df.isin(values)

It can be a DataFrame:

values = pd.DataFrame({'age': [50], 'name': ['Sally']})
df.isin(values)


Return Value

A DataFrame with the selected result, or a Series if the result only contains one row.


❮ DataFrame Reference