atoti.Column.isin()

Column.isin(*elements: ConstantT_co) → RelationalCondition[ColumnIdentifier, Literal['EQ'], +ConstantT_co]

Column.isin(*elements: ConstantT_co | None) → RelationalCondition[TypeAliasForwardRef, Literal['EQ'], Union[+ConstantT_co, 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.

Example

>>> 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