i want to replace a df1 data, with df2, which df2 is a data like df1 example df1 <- data.frame( name = c( "A. MAHJUM-61365", "A. MAHJUM-61365. MAHJUM-61365", "A. RIZAL. AD-11002795", "A. RIZAL. AD-11002795. RIZAL. AD-11002795", "ABD. KADIR-60447", "ABD. KADIR-60447ABD. KADIR-60447", "ABD. KAHAR-62551", "ABD. RASYID DS-11002082", "ABDREAS APUNG @SANY", "ABDUL AZIS @HYUNDAY", "ABDUL AZIZ @HYUNDAI",… Read More how to replace a dataframe with another dataframe in R

The following data has the surprising result that it does not match. I was expecting the distance to be 5, but even at 7 I get no match library(fuzzyjoin) one <- as.data.frame("Other field crops (non-organic)") names(one) <- "A" two <- as.data.frame("other_field_crops_non_organic") names(two) <- "A" stringdist_left_join(one, two, by = "A", method = "lcs", max_dist = 7,… Read More Stringdist distance unexpectedly large

I have a huge dataset and that look like this. To save some memory I want to calculate the pairwise distance but leave the upper diagonal of the matrix to NULL. library(tidyverse) library(stringdist) #> #> Attaching package: ‘stringdist’ #> The following object is masked from ‘package:tidyr’: #> #> extract df3 <- tibble(fruits=c("apple","banana","ananas","apple","ananas","apple","ananas"), position=c("135","135","135","136","137","138","138"), counts =… Read More Convert to matrix but keep one diagonal to NULL in R

I am using the stringdist package in R. For several options: grab(x, pattern, maxDist = Inf, value = FALSE, …) grabl(x, pattern, maxDist = Inf, …) extract(x, pattern, maxDist = Inf, …) it uses maxDist. This option however counts the distance between A and a as one. Just as the distance between A and b.… Read More Ignoring the case for maxDist in stringdist::extract