join: Join operations

In steinbaugh/transformer: Coercion methods for biological data

Description

Join operations

Usage

innerJoin(x, y, by, ...)

leftJoin(x, y, by, ...)

rightJoin(x, y, by, ...)

fullJoin(x, y, by, ...)

semiJoin(x, y, by, ...)

antiJoin(x, y, by, ...)

## S4 method for signature 'DataFrame,DataFrame,character'
innerJoin(x, y, by)

## S4 method for signature 'DataFrame,DataFrame,character'
leftJoin(x, y, by)

## S4 method for signature 'DataFrame,DataFrame,character'
rightJoin(x, y, by)

## S4 method for signature 'DataFrame,DataFrame,character'
fullJoin(x, y, by)

## S4 method for signature 'DataFrame,DataFrame,character'
semiJoin(x, y, by)

## S4 method for signature 'DataFrame,DataFrame,character'
antiJoin(x, y, by)

Arguments

x	Object.
y	Object.
by	character. Column names to use for join operation.
...	Additional arguments.

Value

New object containing a merge of x and y objects.

Ordering

The join functions never rearrange rows. To accomplish this, we're currently setting an internal .idx column that we can use to reorder the rows after merge() operation.

Row names

Unlike the S3 methods defined in dplyr, the join methods defined here for DataFrame always preserve row names.

Note

Updated 2019-09-03.

See Also

These functions are inspired by dplyr. However, they are designed to only work on Bioconductor S4 class objects, and use base R code internally.

• help(topic = "join", package = "dplyr").

• help(topic = "merge", package = "S4Vectors").

• https://support.bioconductor.org/p/120277/

Examples

data(band_members, band_instruments)

## DataFrame ====
x <- band_members
print(x)
y <- band_instruments
print(y)
by <- "name"
innerJoin(x = x, y = y, by = by)
leftJoin(x = x, y = y, by = by)
rightJoin(x = x, y = y, by = by)
fullJoin(x = x, y = y, by = by)
semiJoin(x = x, y = y, by = by)
antiJoin(x = x, y = y, by = by)

steinbaugh/transformer documentation built on Jan. 9, 2020, 12:53 p.m.