join: Join operations

In acidgenomics/r-acidplyr: Acid Genomics Rectangular Data Plyr

Join operations

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 'DFrame,DFrame,character'
antiJoin(x, y, by)

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

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

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

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

## S4 method for signature 'DFrame,DFrame,character'
semiJoin(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 DFrame always preserve row names.

Note

Updated 2024-01-04.

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 = "base").

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

Examples

data(join, package = "AcidTest")

## DFrame ====
x <- as(join[["members"]], "DFrame")
print(x)
y <- as(join[["instruments"]], "DFrame")
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)

acidgenomics/r-acidplyr documentation built on July 4, 2025, 5:55 a.m.