Data Management and Manipulation
joinby and Pair Generation
joinby creates every eligible pair sharing a key; it is not a substitute for an ordinary
merge.
Page 1 of 7 · Big Picture
The big picture: joinby and Pair Generation
When should every eligible pair of records be created?
Why a policy analyst should care
Some questions require constructing eligible pairs rather than matching unique records; distinguishing pair generation from merging prevents accidental Cartesian products.
Follow the idea from the opening question to a practical decision. These are the conceptual moves this module will develop:
1 Question When should every eligible pair be created?
2 Explore A provider-referral example
3 Formalize Pair generation changes the unit
4 Transfer Decide whether joinby is defensible
Use the left and right arrow keys to move between pages.