Deduplicate and clean up millions of location records

How record linkage and geocoding combined improve data quality

Paul Kinsvater
Towards Data Science
8 min readSep 6, 2022

--

Cable spaghetti as a synonym for poor data quality from multiple sources.
Photo by Ralph (Ravi) Kayden on Unsplash

Big companies store data in several systems for different purposes (ERPs, CRMs, local files). Each potentially holds customer data, and not all of them, if any, are in sync. In addition, links across sources either do not exist or are not appropriately maintained. The…

--

--

I am a statistician (Ph.D.). And I write about data minus the hype. Anything that adds tangible value to the real world.