Skip to main content

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

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

​
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