Package: fuzzyjoin 0.1.6

fuzzyjoin: Join Tables Together on Inexact Matching

Join tables together based not on whether columns match exactly, but whether they are similar by some comparison. Implementations include string distance and regular expression matching.

Authors:David Robinson [aut, cre], Jennifer Bryan [ctb], Joran Elias [ctb]

fuzzyjoin_0.1.6.tar.gz
fuzzyjoin_0.1.6.zip(r-4.5)fuzzyjoin_0.1.6.zip(r-4.4)fuzzyjoin_0.1.6.zip(r-4.3)
fuzzyjoin_0.1.6.tgz(r-4.4-any)fuzzyjoin_0.1.6.tgz(r-4.3-any)
fuzzyjoin_0.1.6.tar.gz(r-4.5-noble)fuzzyjoin_0.1.6.tar.gz(r-4.4-noble)
fuzzyjoin_0.1.6.tgz(r-4.4-emscripten)fuzzyjoin_0.1.6.tgz(r-4.3-emscripten)
fuzzyjoin.pdf |fuzzyjoin.html
fuzzyjoin/json (API)
NEWS

# Install 'fuzzyjoin' in R:
install.packages('fuzzyjoin', repos = c('https://dgrtwo.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

Bug tracker:https://github.com/dgrtwo/fuzzyjoin/issues

Datasets:
  • misspellings - A corpus of common misspellings, for examples and practice

On CRAN:

56 exports 662 stars 8.37 score 26 dependencies 20 dependents 4 mentions 1.3k scripts 34.3k downloads

Last updated 4 years agofrom:b688416b9d. Checks:OK: 3 NOTE: 4. Indexed: yes.

TargetResultDate
Doc / VignettesOKAug 23 2024
R-4.5-winNOTEAug 23 2024
R-4.5-linuxNOTEAug 23 2024
R-4.4-winNOTEAug 23 2024
R-4.4-macNOTEAug 23 2024
R-4.3-winOKAug 23 2024
R-4.3-macOKAug 23 2024

Exports:difference_anti_joindifference_full_joindifference_inner_joindifference_joindifference_left_joindifference_right_joindifference_semi_joindistance_anti_joindistance_full_joindistance_inner_joindistance_joindistance_left_joindistance_right_joindistance_semi_joinfuzzy_anti_joinfuzzy_full_joinfuzzy_inner_joinfuzzy_joinfuzzy_left_joinfuzzy_right_joinfuzzy_semi_joingenome_anti_joingenome_full_joingenome_inner_joingenome_joingenome_left_joingenome_right_joingenome_semi_joingeo_anti_joingeo_full_joingeo_inner_joingeo_joingeo_left_joingeo_right_joingeo_semi_joininterval_anti_joininterval_full_joininterval_inner_joininterval_joininterval_left_joininterval_right_joininterval_semi_joinregex_anti_joinregex_full_joinregex_inner_joinregex_joinregex_left_joinregex_right_joinregex_semi_joinstringdist_anti_joinstringdist_full_joinstringdist_inner_joinstringdist_joinstringdist_left_joinstringdist_right_joinstringdist_semi_join

Dependencies:clicpp11dplyrfansigenericsgeospheregluelatticelifecyclemagrittrpillarpkgconfigpurrrR6Rcpprlangspstringdiststringistringrtibbletidyrtidyselectutf8vctrswithr

Example of stringdist_inner_join: Correcting misspellings against a dictionary

Rendered fromstringdist_join.Rmdusingknitr::rmarkdownon Aug 23 2024.

Last update: 2019-08-05
Started: 2016-04-05

Readme and manuals

Help Manual

Help pageTopics
Join two tables based on absolute difference between their columnsdifference_anti_join difference_full_join difference_inner_join difference_join difference_left_join difference_right_join difference_semi_join
Join two tables based on a distance metric of one or more columnsdistance_anti_join distance_full_join distance_inner_join distance_join distance_left_join distance_right_join distance_semi_join
Join two tables based not on exact matches, but with a function describing whether two vectors are matched or notfuzzy_anti_join fuzzy_full_join fuzzy_inner_join fuzzy_join fuzzy_left_join fuzzy_right_join fuzzy_semi_join
Join two tables based on overlapping genomic intervals: both agenome_anti_join genome_full_join genome_inner_join genome_join genome_left_join genome_right_join genome_semi_join
Join two tables based on a geo distance of longitudes and latitudesgeo_anti_join geo_full_join geo_inner_join geo_join geo_left_join geo_right_join geo_semi_join
Join two tables based on overlapping (low, high) intervalsinterval_anti_join interval_full_join interval_inner_join interval_join interval_left_join interval_right_join interval_semi_join
A corpus of common misspellings, for examples and practicemisspellings
Join two tables based on a regular expression in one column matching the otherregex_anti_join regex_full_join regex_inner_join regex_join regex_left_join regex_right_join regex_semi_join
Join two tables based on fuzzy string matching of their columnsstringdist_anti_join stringdist_full_join stringdist_inner_join stringdist_join stringdist_left_join stringdist_right_join stringdist_semi_join