Installation | Features | API | Examples | Example 1: Basic use and options | (1) Basic syntax | (2) Efficient selective joins in one line | (3) Indicator column for row origin | (4) Switch row order from left-then-right to right-then-left | (5) Display code instead of executing | Example 2: Reducing an inequality join from M:M to 1:1 with mult.x and mult.y | (1) For each event, all subsequent reactions (M:M) | (2) For each event, the next reaction (1:M) | (3) For each event, the next reaction, provided there was no intervening event (1:1) | Example 3: Chain of calls from fjoin_* to dtjoin_* to r pkg("data.table") | Performance | Notes for r pkg("tidyverse") users | Notes for r pkg("sf") users | Notes for r pkg("data.table") users | "Internals"
Package: fjoin 0.1.1.9000
fjoin: Data Frame Joins Leveraging 'data.table'
Extends 'data.table' join functionality, lets it work with any data frame class, and provides a familiar 'x'/'y'-style interface, enabling broad use across R. Offers NA-safe matching by default, on-the-fly column selection, multiple match-handling on both sides, 'x' or 'y' row order, and a row origin indicator. Performs 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; 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.
Authors:
fjoin_0.1.1.9000.tar.gz
fjoin_0.1.1.9000.zip(r-4.7-any)fjoin_0.1.1.9000.zip(r-4.6-any)fjoin_0.1.1.9000.zip(r-4.5-any)
fjoin_0.1.1.9000.tgz(r-4.6-any)fjoin_0.1.1.9000.tgz(r-4.5-any)
fjoin_0.1.1.9000.tar.gz(r-4.7-any)fjoin_0.1.1.9000.tar.gz(r-4.6-any)
fjoin_0.1.1.9000.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
fjoin/json (API)
| # Install 'fjoin' in R: |
| install.packages('fjoin', repos = c('https://trobx.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/trobx/fjoin/issues
Pkgdown/docs site:https://trobx.github.io
dataframedatatablejoinmergeperformancesftibblequarto
Last updated from:415cb8dd52. Checks:9 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel | OK | 114 | ||
| source / vignettes | OK | 171 | ||
| linux-release | OK | 128 | ||
| macos-release | OK | 233 | ||
| macos-oldrel | OK | 218 | ||
| windows-devel | OK | 133 | ||
| windows-release | OK | 124 | ||
| windows-oldrel | OK | 119 | ||
| wasm-release | OK | 103 |
Exports:dtjoindtjoin_antidtjoin_crossdtjoin_semifjoin_antifjoin_crossfjoin_fullfjoin_innerfjoin_leftfjoin_left_antifjoin_left_semifjoin_rightfjoin_right_antifjoin_right_semifjoin_semi
Dependencies:data.table
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Join data frame-like objects using an extended 'DT[i]'-style interface to data.table | dtjoin |
| Anti-join of 'DT' in a 'DT[i]'-style join of data frame-like objects | dtjoin_anti |
| Cross join of data frame-like objects 'DT' and 'i' using a 'DT[i]'-style interface to data.table | dtjoin_cross |
| Semi-join of 'DT' in a 'DT[i]'-style join of data frame-like objects | dtjoin_semi |
| Cross join | fjoin_cross |
| Full join | fjoin_full |
| Inner join | fjoin_inner |
| Left join | fjoin_left |
| Left anti-join | fjoin_anti fjoin_left_anti |
| Left semi-join | fjoin_left_semi fjoin_semi |
| Right join | fjoin_right |
| Right anti-join | fjoin_right_anti |
| Right semi-join | fjoin_right_semi |