dplyr: inner_join with a partial string match

by

The fuzzyjoin library has two functions regex_inner_join and fuzzy_inner_join that allow you to match partial strings:

x <- data.frame(idX=1:3, string=c("Motorcycle", "TractorTrailer", "Sailboat"))
y <- data.frame(idY=letters[1:3], seed=c("ractor", "otorcy", "irplan"))
x$string = as.character(x$string)
y$seed = as.character(y$seed)


library(fuzzyjoin)
x %>% regex_inner_join(y, by = c(string = "seed"))

  idX         string idY   seed
1   1     Motorcycle   b otorcy
2   2 TractorTrailer   a ractor


library(stringr)
x %>% fuzzy_inner_join(y, by = c("string" = "seed"), match_fun = str_detect)


  idX         string idY   seed
1   1     Motorcycle   b otorcy
2   2 TractorTrailer   a ractor

More Related Contents:

  1. Use dynamic name for new column/variable in `dplyr`
  2. data.table vs dplyr: can one do something well the other can’t or does poorly?
  3. Extract a dplyr tbl column as a vector
  4. Pass arguments to dplyr functions
  5. dplyr::select function clashes with MASS::select
  6. Sum across multiple columns with dplyr
  7. Why does X[Y] join of data.tables not allow a full outer join, or a left join?
  8. dplyr: nonstandard column names (white space, punctuation, starts with numbers)
  9. dplyr filter: Get rows with minimum of variable, but only the first if multiple minima
  10. dplyr mutate/replace several columns on a subset of rows
  11. What does the dplyr period character “.” reference?
  12. Count non-NA values by group [duplicate]
  13. case_when in mutate pipe
  14. Summarize all group values and a conditional subset in the same call
  15. dplyr mutate with conditional values
  16. How to add a cumulative column to an R dataframe using dplyr?
  17. Concatenate unique strings after groupby in R
  18. Get last row of each group in R [duplicate]
  19. dplyr on data.table, am I really using data.table?
  20. Set certain values to NA with dplyr
  21. Use filter in dplyr conditional on an if statement in R
  22. combine two data frames with all posible combinations
  23. dplyr / R cumulative sum with reset
  24. finding close match from data frame 1 in data fame 2
  25. Add a column with count of NAs and Mean
  26. select columns based on multiple strings with dplyr contains()
  27. Error with select function from dplyr
  28. dplyr: put count occurrences into new variable [duplicate]
  29. Add row in each group using dplyr and add_row()
  30. How to replace certain values in a specific rows and columns with NA in R?

Leave a Comment