arsenal (version 3.5.0)

comparedf: Compare two data.frames and report differences

Description

Compare two data.frames and report any differences between them, much like SAS's PROC COMPARE procedure.

Usage

comparedf(x, y, by = NULL, by.x = by, by.y = by, control = NULL, ...)
# S3 method for comparedf
print(x, ...)

Arguments

x, y

A data.frame to compare

by, by.x, by.y

Which variables are IDs to merge the two data.frames? If set to "row.names", merging will occur over the row.names. If set to NULL (default), merging will occur row-by-row.

control

A list of control parameters from comparedf.control.

...

Other arguments, passed to comparedf.control when appropriate.

See Also

summary.comparedf, comparedf.control, diffs, n.diffs, n.diff.obs

Examples

# NOT RUN {
df1 <- data.frame(id = paste0("person", 1:3), a = c("a", "b", "c"),
                  b = c(1, 3, 4), c = c("f", "e", "d"),
                  row.names = paste0("rn", 1:3), stringsAsFactors = FALSE)
df2 <- data.frame(id = paste0("person", 3:1), a = c("c", "b", "a"),
                  b = c(1, 3, 4), d = paste0("rn", 1:3),
                  row.names = paste0("rn", c(1,3,2)), stringsAsFactors = FALSE)
summary(comparedf(df1, df2))
summary(comparedf(df1, df2, by = "id"))
summary(comparedf(df1, df2, by = "row.names"))
# }

Run the code above in your browser using DataCamp Workspace