My Data Was Lying to Me: A Case Study in Fixing a Scrambled CSV Nightmare

Introduction This week, my data flat-out lied to me. I asked it for a monthly breakdown, and it gave me a country code. I asked for a commodity code, and it gave me a random number. This wasn't a simple "messy data" problem; this was a "forensic anal...