Fast and friendly data frame joins leveraging data.table
Please view this on the package website and head to the Get started guide next.
Description
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.
Installation
Latest version from R-universe:
install.packages("fjoin",
repos = c("https://trobx.r-universe.dev", "https://cloud.r-project.org"))More information
See Get started.