How to Do Fuzzy String Matching in Pandas Dataframes

Matching text where there’s no perfect match

Thuwarakesh Murallie
Towards Data Science
6 min readApr 17, 2023

--

Photo by Lucas Santos on Unsplash

The real world is not perfect.

People use different forms of the same piece of information. Even well-established systems use different standards. You’d have seen city names misspelled, like “Santana” instead of “Santa Ana” or “St. Louie” instead of “St. Louis.”

--

--

I write about data science and consult at Stax, where I help clients unlock insights from data to drive business growth. https://www.the-analytics.club