join: Fast SQL joins
In fastplyr: Fast Alternatives to 'tidyverse' Functions

f_left_join

R Documentation

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, ...)

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()`.