LazyFrame.merge

merge

merge(
    right: Union[LazyFrame, DuckDBPyRelation],
    on: str | list[str],
    how: Literal[
        "inner", "right", "left", "outer"
    ] = "inner",
) -> LazyFrame

Merge two relations on one or more columns.

Parameters:

Name	Type	Description	Default
right	LazyFrame	The right relation to merge.	required
on	str | list[str]	The column(s) to merge on.	required
how	str	The type of merge to perform. Defaults to 'inner'.	'inner'

Returns:

Name	Type	Description
LazyFrame	LazyFrame	A new LazyFrame with the merged data.