Comparison.value_diffs

Comparison.value_diffs(column: str) → DuckDBPyRelation

Return rows where a single column differs between the tables.

Parameters:

columnstr

Column name to compare.

Returns:

duckdb.DuckDBPyRelation

Relation with the differing values plus the by columns.

Examples

>>> from versus import compare, examples
>>> comparison = compare(
...     examples.example_cars_a(),
...     examples.example_cars_b(),
...     by=["car"],
... )
>>> comparison.value_diffs("disp")
┌────────┬────────┬────────────────┐
│ disp_a │ disp_b │      car       │
│ int32  │ int32  │    varchar     │
├────────┼────────┼────────────────┤
│    109 │    108 │ Datsun 710     │
│    259 │    258 │ Hornet 4 Drive │
└────────┴────────┴────────────────┘