f_left_join: Fast SQL joins

Description

Mostly a wrapper around collapse::join() that behaves more like dplyr's joins. List columns, lubridate intervals and vctrs rcrds work here too.

Usage

f_left_join(
  x,
  y,
  by = NULL,
  suffix = c(".x", ".y"),
  multiple = TRUE,
  keep = FALSE,
  ...
)
f_right_join(
  x,
  y,
  by = NULL,
  suffix = c(".x", ".y"),
  multiple = TRUE,
  keep = FALSE,
  ...
)
f_inner_join(
  x,
  y,
  by = NULL,
  suffix = c(".x", ".y"),
  multiple = TRUE,
  keep = FALSE,
  ...
)
f_full_join(
  x,
  y,
  by = NULL,
  suffix = c(".x", ".y"),
  multiple = TRUE,
  keep = FALSE,
  ...
)
f_anti_join(
  x,
  y,
  by = NULL,
  suffix = c(".x", ".y"),
  multiple = TRUE,
  keep = FALSE,
  ...
)
f_semi_join(
  x,
  y,
  by = NULL,
  suffix = c(".x", ".y"),
  multiple = TRUE,
  keep = FALSE,
  ...
)
f_cross_join(x, y, suffix = c(".x", ".y"), ...)
f_union_all(x, y, ...)
f_union(x, y, ...)

Value

A joined data frame, joined on the columns specified with by, using an equality join.

f_cross_join() returns all possible combinations between the two data frames.

Arguments

x: Left data frame.
y: Right data frame.
by: character(1) - Columns to join on.
suffix: character(2) - Suffix to paste onto common cols between x and y in the joined output.
multiple: logical(1) - Should multiple matches be returned? If FALSE the first match in y is used. Default is TRUE.
keep: logical(1) - Should join columns from both data frames be kept? Default is FALSE.
...: Additional arguments passed to collapse::join().