Comparison.weave_diffs_wide

Comparison.weave_diffs_wide(

columns: Sequence[str] | None = None,

suffix: Tuple[str, str] | None = None,

) → DuckDBPyRelation

Return a wide view of differing rows with split columns.

Parameters:

columnssequence of str, optional

Columns to compare. Defaults to all comparable columns.

suffixtuple[str, str], optional

Suffixes appended to differing columns from table A and B.

Returns:

duckdb.DuckDBPyRelation

Relation with key columns and common columns, where differing columns are split into <name><suffix>.

Examples

>>> from versus import compare, examples
>>> comparison = compare(
...     examples.example_cars_a(),
...     examples.example_cars_b(),
...     by=["car"],
... )
>>> comparison.weave_diffs_wide(["disp"])
┌────────────────┬──────────────┬───────┬────────┬────────┬───────┬──────────────┬──────────────┬───────┐
│      car       │     mpg      │  cyl  │ disp_a │ disp_b │  hp   │     drat     │      wt      │  vs   │
│    varchar     │ decimal(3,1) │ int32 │ int32  │ int32  │ int32 │ decimal(3,2) │ decimal(3,2) │ int32 │
├────────────────┼──────────────┼───────┼────────┼────────┼───────┼──────────────┼──────────────┼───────┤
│ Datsun 710     │         22.8 │  NULL │    109 │    108 │    93 │         3.85 │         2.32 │     1 │
│ Hornet 4 Drive │         21.4 │     6 │    259 │    258 │   110 │         3.08 │         3.22 │     1 │
└────────────────┴──────────────┴───────┴────────┴────────┴───────┴──────────────┴──────────────┴───────┘