Breaking News: Grepper is joining You.com. Read the official announcement!

identify multiple spellings in R

Puzzled Porpoise answered on August 5, 2021 Popularity 1/10 Helpfulness 1/10

answer identify multiple spellings in R

related identify multiple spellings in R

identify multiple spellings in R

Comment

cities <- data.frame(city = c('bangalore','bengaluru','banglore',
  'bangalore', 'bangalore', 'bangalore', 'new york', 'newyork', 
  'nyork', 'new york', 'new york'))

Popularity 1/10 Helpfulness 1/10 Language r

Source: stackoverflow.com

Tags: identify r

Link to this answer
Share Copy Link

Contributed on Aug 05 2021

Puzzled Porpoise

0 Answers Avg Quality 2/10

Closely Related Answers

identify multiple spellings in R

Comment

library(dplyr)
library(stringdist)

Popularity 1/10 Helpfulness 1/10 Language r

Source: stackoverflow.com

Tags: identify r

Link to this answer
Share Copy Link

Contributed on Aug 05 2021

Puzzled Porpoise

0 Answers Avg Quality 2/10

identify multiple spellings in R

Comment

dta <- cities %>% group_by(city) %>% count() %>% 
  ungroup() %>% mutate(i = row_number())

Popularity 1/10 Helpfulness 1/10 Language r

Source: stackoverflow.com

Tags: identify r

Link to this answer
Share Copy Link

Contributed on Aug 05 2021

Puzzled Porpoise

0 Answers Avg Quality 2/10

identify multiple spellings in R

Comment

pairs <- expand.grid(x = seq_len(nrow(dta)), y = seq_len(nrow(dta))) %>% 
  # Only need to compare i to  all records j, with j > i 
  filter(y > x) %>%
  left_join(dta, by = c(x = 'i')) %>% rename(cityx = city, nx = n) %>%
  left_join(dta, by = c(y = 'i')) %>% rename(cityy = city, ny = n) %>%
  mutate(similarity = stringsim(cityx, cityy, method = "jw")) %>% 
  arrange(desc(similarity))

Popularity 1/10 Helpfulness 1/10 Language r

Source: stackoverflow.com

Tags: identify r

Link to this answer
Share Copy Link

Contributed on Aug 05 2021

Puzzled Porpoise

0 Answers Avg Quality 2/10

identify multiple spellings in R

Comment

> pairs
#    x y     cityx nx     cityy ny similarity
# 1  1 2 bangalore  4  banglore  1  0.9629630
# 2  4 5  new york  3   newyork  1  0.9583333
# 3  5 6   newyork  1     nyork  1  0.9047619
# 4  4 6  new york  3     nyork  1  0.8750000
# 5  2 3  banglore  1 bengaluru  1  0.7222222
# 6  1 3 bangalore  4 bengaluru  1  0.6944444
# 7  2 6  banglore  1     nyork  1  0.6583333
# 8  2 5  banglore  1   newyork  1  0.6011905
# 9  1 5 bangalore  4   newyork  1  0.5873016
# 10 2 4  banglore  1  new york  3  0.5833333
# 11 1 4 bangalore  4  new york  3  0.5694444
# 12 3 5 bengaluru  1   newyork  1  0.4761905
# 13 3 4 bengaluru  1  new york  3  0.4583333
# 14 1 6 bangalore  4     nyork  1  0.4370370
# 15 3 6 bengaluru  1     nyork  1  0.4370370

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: stackoverflow.com

Tags: r whatever identify

Link to this answer
Share Copy Link

Contributed on Aug 05 2021

Puzzled Porpoise

0 Answers Avg Quality 2/10

identify multiple spellings in R

Contents

More Related Answers

identify multiple spellings in R

Closely Related Answers

identify multiple spellings in R

identify multiple spellings in R

identify multiple spellings in R

identify multiple spellings in R

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.