The Record Reconciler
A medium Python mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- Python
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
Given source_a and source_b (each a list of dicts) and an id_field name, reconcile the two by id and return a dict with four keys: 'only_a' (sorted list of ids in source_a but not source_b), 'only_b' (sorted list of ids in source_b but not source_a), 'matches' (sorted list of ids whose records are identical in both sources), and 'mismatches' (sorted list of {'id': id, 'differences': {field: {'a': a_val, 'b': b_val}}} dicts for ids whose records differ on at least one non-id field).
Summary
Two versions of the same truth.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your python solution with real code execution
- Get instant feedback and a hire/no-hire decision