nest_join {tidytable}

Nest join

Description

Join the data from y as a list column onto x.

Usage

nest_join(x, y, by = NULL, keep = FALSE, name = NULL, ...)

Arguments

x

A data.frame or data.table

y

A data.frame or data.table

by

A character vector of variables to join by. If NULL, the default, the join will do a natural join, using all variables with common names across the two tables.

keep

Should the join keys from both x and y be preserved in the output?

name

The name of the list-column created by the join. If NULL the name of y is used.

...

Other parameters passed on to methods

Examples

df1 <- tidytable(x = 1:3)
df2 <- tidytable(x = c(2, 3, 3), y = c("a", "b", "c"))

out <- nest_join(df1, df2)
out
out$df2