Items match based on text descriptions in a dataset

[andresrcs]

@a.jain

Is there any algorithm for that in R? Is there any other way to do this kind of matching?

You could try fuzzy matches using tidystringdist see this related thread

Identifying Fuzzy Duplicates from a column

This would be one way to do it library(tidystringdist) library(tidyverse) # Sample data df <- data.frame(stringsAsFactors = FALSE, Name = as.factor(c(" CANON PVT. LTD ", " Antila,Thomas ", " Greg ", " St.Luke's Hospital ", " Z_SANDSTONE COOLING LTD ", " St.Luke's Hospital ", " CANON PVT. LTD. ", " SANDSTONE COOLING LTD ", " Greg ", " ANTILA,THOMAS ")), City = as.factor(c(" Georgia ", " Georgia ", " Georgia ", " Georgia ", " Georgia ", " Georgia ", " Georgia ", " Georgia ", " Georgia ", " Georgia ")) ) match <- df %>% tidy_comb_all(Name) %>% tidy_stringdist() %>% filter(so…