Comparison.value_diffs_stacked

Comparison.value_diffs_stacked(

columns: Sequence[str] | None = None,

) → DuckDBPyRelation

Return a stacked view of value differences for multiple columns.

Parameters:

columnssequence of str, optional

Columns to compare. Defaults to all comparable columns.

Returns:

duckdb.DuckDBPyRelation

Relation with column, val_<table_id>, and by columns.

Examples

>>> from versus import compare, examples
>>> comparison = compare(
...     examples.example_cars_a(),
...     examples.example_cars_b(),
...     by=["car"],
... )
>>> comparison.value_diffs_stacked(["mpg", "disp"])
┌─────────┬───────────────┬───────────────┬────────────────┐
│ column  │     val_a     │     val_b     │      car       │
│ varchar │ decimal(11,1) │ decimal(11,1) │    varchar     │
├─────────┼───────────────┼───────────────┼────────────────┤
│ mpg     │          24.4 │          26.4 │ Merc 240D      │
│ mpg     │          14.3 │          16.3 │ Duster 360     │
│ disp    │         109.0 │         108.0 │ Datsun 710     │
│ disp    │         259.0 │         258.0 │ Hornet 4 Drive │
└─────────┴───────────────┴───────────────┴────────────────┘