5 ms·
Ha, good one. I implemented levenshtein distance in Apps Script the other day to help some poor colleagues who were doing manual data cleaning tasks.
by stereobit 9y ago
Ha, good one. I implemented levenshtein distance in Apps Script the other day to help some poor colleagues who were doing manual data cleaning tasks.
- agumonkey 9y agoAmazing, I did avoid hell to collegues by implementing some form of counter in VBA. My most prized coding contribution. 8 lines that evaporated hell (filtering 1000 rows in Excel to find duplicates) into fun.
- stereobit 9y agoThis is how I started as well. But we had too many typos so I had to find something a little bit 'smarter'. Next thing on my list is to implement tf–idf to help with free text categorisation.
- yesbabyyes 9y agoSounds great! Feel free to adapt this to your usecase, if useful: https://github.com/yesbabyyes/tfidf https://github.com/yesbabyyes/tfidf
- agumonkey 9y agoI did levenstein a few time at that job, indeed, anything with operator input will have errors