symdiff.duckplyr_df {duckplyr} | R Documentation |
Symmetric difference
Description
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
Examples
df1 <- duckdb_tibble(x = 1:3)
df2 <- duckdb_tibble(x = 3:5)
symdiff(df1, df2)
[Package duckplyr version 1.1.0 Index]