From Dev.to
Check that a research CSV join preserves one row per participant
A row count can stay the same even when a merge drops one participant and duplicates another. If your analysis expects one row per participant, compare the identifier counts before and after the join....