acidplyr.inner_join

acidplyr.inner_join(x: DataFrame, y: DataFrame, by: str | list[str]) → DataFrame

Inner join: return rows present in both x and y.

Parameters:

• x (pd.DataFrame) – Left DataFrame.

• y (pd.DataFrame) – Right DataFrame.

• by (str or list of str) – Column name(s) to join on. Must exist in both x and y with matching dtypes.

Returns:

Rows from x and y whose by values match, in x order.

Return type:

pd.DataFrame

Examples

>>> import pandas as pd
>>> x = pd.DataFrame({"name": ["Mick", "John", "Paul"]})
>>> y = pd.DataFrame(
...     {"name": ["John", "Paul"], "plays": ["guitar", "bass"]}
... )
>>> inner_join(x, y, by="name")["name"].tolist()
['John', 'Paul']