fjoin

Data Frame Joins Leveraging 'data.table'

v0.1.1 · Mar 18, 2026 · MIT + file LICENSE

Description

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.

Downloads

CRAN

452

Last 30 days

8705th

1.5K

Last 90 days

2.5K

Last year

Trend: -10% (30d vs prior 30d)

r2u CRAN

Last 30 days

Last 90 days

Last year

Trend: -53.3% (30d vs prior 30d)

CRAN Check Status

13 OK

Show all 13 flavors

Flavor	Status	Time
r-devel-linux-x86_64-debian-clang	OK	91.5s
r-devel-linux-x86_64-debian-gcc	OK	61.2s
r-devel-linux-x86_64-fedora-clang	OK	131.6s
r-devel-linux-x86_64-fedora-gcc	OK	138.2s
r-devel-windows-x86_64	OK	106s
r-oldrel-macos-arm64	OK	23s
r-oldrel-macos-x86_64	OK	124s
r-oldrel-windows-x86_64	OK	126s
r-patched-linux-x86_64	OK	78.4s
r-release-linux-x86_64	OK
r-release-macos-arm64	OK	20s
r-release-macos-x86_64	OK	70s
r-release-windows-x86_64	OK	102s

Check History

OK 14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 26, 2026

ERROR 5 OK · 0 NOTE · 0 WARNING · 9 ERROR · 0 FAILURE Mar 10, 2026

ERROR r-devel-linux-x86_64-debian-clang

tests

Running ‘testthat.R’ [15s/17s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > # This file is part of the standard setup for testthat.
  > # It is recommended that you do not modify it.
  > #
  > # Where should you do additional 
...[truncated]...
" | "NA      " [4]
  [5] "constant" - "NA      " [5]
  [6] "constant" - "NA      " [6]
                 - "constant" [7]
                 - "constant" [8]
  
  
  [ FAIL 10 | WARN 0 | SKIP 0 | PASS 472 ]
  Error:
  ! Test failures.
  Execution halted

ERROR r-devel-linux-x86_64-debian-gcc

tests

Running ‘testthat.R’ [9s/11s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > # This file is part of the standard setup for testthat.
  > # It is recommended that you do not modify it.
  > #
  > # Where should you do additional t
...[truncated]...
" | "NA      " [4]
  [5] "constant" - "NA      " [5]
  [6] "constant" - "NA      " [6]
                 - "constant" [7]
                 - "constant" [8]
  
  
  [ FAIL 10 | WARN 0 | SKIP 0 | PASS 472 ]
  Error:
  ! Test failures.
  Execution halted

ERROR r-devel-linux-x86_64-fedora-clang

tests

Running ‘testthat.R’ [22s/32s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > # This file is part of the standard setup for testthat.
  > # It is recommended that you do not modify it.
  > #
  > # Where should you do additional 
...[truncated]...
" | "NA      " [4]
  [5] "constant" - "NA      " [5]
  [6] "constant" - "NA      " [6]
                 - "constant" [7]
                 - "constant" [8]
  
  
  [ FAIL 10 | WARN 0 | SKIP 0 | PASS 472 ]
  Error:
  ! Test failures.
  Execution halted

ERROR r-devel-linux-x86_64-fedora-gcc

tests

Running ‘testthat.R’ [21s/25s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > # This file is part of the standard setup for testthat.
  > # It is recommended that you do not modify it.
  > #
  > # Where should you do additional 
...[truncated]...
" | "NA      " [4]
  [5] "constant" - "NA      " [5]
  [6] "constant" - "NA      " [6]
                 - "constant" [7]
                 - "constant" [8]
  
  
  [ FAIL 10 | WARN 0 | SKIP 0 | PASS 472 ]
  Error:
  ! Test failures.
  Execution halted

ERROR r-devel-windows-x86_64

tests

Running 'testthat.R' [13s]
Running the tests in 'tests/testthat.R' failed.
Complete output:
  > # This file is part of the standard setup for testthat.
  > # It is recommended that you do not modify it.
  > #
  > # Where should you do additional test
...[truncated]...
" | "NA      " [4]
  [5] "constant" - "NA      " [5]
  [6] "constant" - "NA      " [6]
                 - "constant" [7]
                 - "constant" [8]
  
  
  [ FAIL 10 | WARN 0 | SKIP 0 | PASS 472 ]
  Error:
  ! Test failures.
  Execution halted

ERROR r-patched-linux-x86_64

tests

Running ‘testthat.R’ [13s/18s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > # This file is part of the standard setup for testthat.
  > # It is recommended that you do not modify it.
  > #
  > # Where should you do additional 
...[truncated]...
" | "NA      " [4]
  [5] "constant" - "NA      " [5]
  [6] "constant" - "NA      " [6]
                 - "constant" [7]
                 - "constant" [8]
  
  
  [ FAIL 10 | WARN 0 | SKIP 0 | PASS 472 ]
  Error:
  ! Test failures.
  Execution halted

ERROR r-release-linux-x86_64

tests

Running ‘testthat.R’ [13s/15s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > # This file is part of the standard setup for testthat.
  > # It is recommended that you do not modify it.
  > #
  > # Where should you do additional 
...[truncated]...
" | "NA      " [4]
  [5] "constant" - "NA      " [5]
  [6] "constant" - "NA      " [6]
                 - "constant" [7]
                 - "constant" [8]
  
  
  [ FAIL 10 | WARN 0 | SKIP 0 | PASS 472 ]
  Error:
  ! Test failures.
  Execution halted

ERROR r-release-windows-x86_64

tests

Running 'testthat.R' [13s]
Running the tests in 'tests/testthat.R' failed.
Complete output:
  > # This file is part of the standard setup for testthat.
  > # It is recommended that you do not modify it.
  > #
  > # Where should you do additional test
...[truncated]...
" | "NA      " [4]
  [5] "constant" - "NA      " [5]
  [6] "constant" - "NA      " [6]
                 - "constant" [7]
                 - "constant" [8]
  
  
  [ FAIL 10 | WARN 0 | SKIP 0 | PASS 472 ]
  Error:
  ! Test failures.
  Execution halted

ERROR r-oldrel-windows-x86_64

tests

Running 'testthat.R' [18s]
Running the tests in 'tests/testthat.R' failed.
Complete output:
  > # This file is part of the standard setup for testthat.
  > # It is recommended that you do not modify it.
  > #
  > # Where should you do additional test
...[truncated]...
" | "NA      " [4]
  [5] "constant" - "NA      " [5]
  [6] "constant" - "NA      " [6]
                 - "constant" [7]
                 - "constant" [8]
  
  
  [ FAIL 10 | WARN 0 | SKIP 0 | PASS 472 ]
  Error:
  ! Test failures.
  Execution halted

Dependency Network

Version History

2 tracked

updated 0.1.1 ← 0.1.0 diff Mar 18, 2026

new 0.1.0 Mar 10, 2026

R Observatory began tracking this package on Mar 10, 2026; it first appeared on CRAN Dec 11, 2025. Releases before tracking aren’t shown.