Join Or Die
How to join datasets correctly is well understood. But we continue to do it badly. Here are notes on how to do fuzzy joins and long to wide transformations starting with some general preprocessing advice.
Preprocessing Keys and Tables
1. Remove stuff irrelevant to matching, e.g., font style, spaces,