Join two data frames on key columns. Equivalent to R's merge(). For data frames: every pair of rows of x and y
with equal keys (missing keys match each other; key columns of different types are compared in their common type,
as R's match: text, or numbers with TRUE as 1), and with allX / allY the rows without a match. Columns: the
keys (named as in x; in the common type when rows only in y are kept), x's other columns, y's other columns; a
non-key name present in both gets the suffixes. Rows are
ordered by the key unless sort is false (several keys: as text joined with "\r" unless allX or allY, as R
does); without key columns, the cross join (x varying fastest).
Join two data frames on key columns. Equivalent to R's
merge(). For data frames: every pair of rows of x and y with equal keys (missing keys match each other; key columns of different types are compared in their common type, as R's match: text, or numbers with TRUE as 1), and withallX/allYthe rows without a match. Columns: the keys (named as in x; in the common type when rows only in y are kept), x's other columns, y's other columns; a non-key name present in both gets the suffixes. Rows are ordered by the key unlesssortis false (several keys: as text joined with "\r" unlessallXorallY, as R does); without key columns, the cross join (x varying fastest).