fjoin builds on data.table to provide fast, flexible joins on any data frames. It slots into tidyverse pipelines and general workflows in a single line, and provides NA-safe matching by default, on-the-fly column selection, flexible row-order preservation, multiple-match handling on both sides, and an indicator column for row origin.
Vignette
View the Get started
guide on the package website
or access locally in R with vignette("fjoin").
API
| fjoin_* functions | dtjoin_* functions |
x/y style | Extended DT[i] style |
fjoin_inner(), fjoin_left(), fjoin_right(), fjoin_full() | dtjoin() |
fjoin_left_semi() (alias fjoin_semi()), fjoin_right_semi() | dtjoin_semi() |
fjoin_left_anti() (alias fjoin_anti()), fjoin_right_anti() | dtjoin_anti() |
fjoin_cross() | dtjoin_cross() |
Author
Maintainer: Toby Robertson trobx@proton.me