atoti.Column.isin()

@overload
Column.isin(
*elements: ConstantT_co,
) → MembershipCondition[ColumnIdentifier, ‘IN’, TypeVar] | RelationalCondition[ColumnIdentifier, ‘EQ’, TypeVar]

@overload
Column.isin(
*elements: ConstantT_co | None,
) → MembershipCondition[TypeAliasForwardRef, ‘IN’, TypeVar | NoneType] | RelationalCondition[TypeAliasForwardRef, ‘EQ’, TypeVar | NoneType]

Return a condition evaluating to True for elements of this column included in the given elements, and evaluating to False elsewhere.

Parameters

*elements

One or more values that the column elements will be compared against.

>>> df = pd.DataFrame(
...     columns=["City", "Price"],
...     data=[
...         ("Berlin", 150),
...         ("London", 270),
...         ("Madrid", 200),
...     ],
... )
>>> table = session.read_pandas(df, keys={"City"}, table_name="Example")
>>> condition = table["City"].isin("Berlin", "Madrid")
>>> condition
t['Example']['City'].isin('Berlin', 'Madrid')
>>> table.drop(condition)
>>> table.head().sort_index()
        Price
City
London    270

Column.default_value

Column.isnull()

⌘I

Releases and upgrades

Getting started

Guides

API reference

Column.isin()

Parameters

*elements

​Parameters

​*elements

Parameters

*elements