Skip to content

Symmetric difference

Source: R/symdiff-rd.R, R/symdiff.R
symdiff.duckplyr_df.Rd

This is a method for the dplyr::symdiff() generic. See "Fallbacks" section for differences in implementation. symdiff(x, y) computes the symmetric difference, i.e. all rows in x that aren't in y and all rows in y that aren't in x.

Usage

# S3 method for class 'duckplyr_df'
symdiff(x, y, ...)

Arguments

x, y

Pair of compatible data frames. A pair of data frames is compatible if they have the same column names (possibly in different orders) and compatible types.

...

These dots are for future extensions and must be empty.

Fallbacks

There is no DuckDB translation in symdiff.duckplyr_df()

  • if column names are duplicated in one of the tables,

  • if column names are different in both tables.

These features fall back to dplyr::symdiff(), see vignette("fallback") for details.

See also

dplyr::symdiff()

Examples

df1 <- duckdb_tibble(x = 1:3)
df2 <- duckdb_tibble(x = 3:5)
symdiff(df1, df2)
#> # A duckplyr data frame: 1 variable
#>       x
#>   <int>
#> 1     2
#> 2     5
#> 3     1
#> 4     4