Fast and friendly data frame joins leveraging data.table
Please view this on the package website and head to the Get started guide next.
Extends data.table join functionality and
provides a familiar x/y-style interface that works directly on any
data frames. 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. Supports inner,
left, right, full, semi- and anti-joins with equality and inequality
conditions, plus cross joins. Specific support for data.table,
(grouped) tibble, and sf/sfc objects and their attributes; prudently
returns a plain data frame otherwise. Avoids data-copying of inputs and
outputs. Allows displaying the data.table
code instead of (or as well as) executing it. Experimental but heavily
tested; feedback and FRs welcome.
Latest version from R-universe:
install.packages("fjoin",
  repos = c("https://trobx.r-universe.dev", "https://cloud.r-project.org"))See Get started.
