Fuzzy joins

Intermediate Regular Expressions in R

Angelo Zehr

Data Journalist

A regular join

regular join diagram

Intermediate Regular Expressions in R

A fuzzy join

a fuzzy join diagram

Intermediate Regular Expressions in R

The fuzzyjoin package

library(fuzzyjoin)
stringdist_join(
  user_input,
  database,
  by = c("user_input" = "name"),
  method = "lv",
  max_dist = 1,
  distance_col = "distance"
)
Intermediate Regular Expressions in R

stringdist_join: Result

fuzzyjoin result

Intermediate Regular Expressions in R

Let's practice!

Intermediate Regular Expressions in R

Preparing Video For Download...