The Record Reconciler

A medium Python interview practice problem on DataDriven. Write and execute real python code with instant grading.

Domain

Python

Difficulty

medium

Seniority

L4

Problem

Two nightly imports of the same ledger should hold identical records keyed by `id_field`, but the upstream systems drift and rows diverge. Reconcile the two lists into four id-ordered buckets: ids only in `source_a`, ids only in `source_b`, ids in both with identical records, and ids in both whose records differ, reporting for that last bucket which non-id fields differ and each source's value.

Summary

Two versions of the same truth.

Practice This Problem

Solve this Python problem with real code execution. DataDriven runs your Python code in a real environment and grades it automatically.