compare function

Comparing two databases assumed to be identical

Compares two data frames assumed to be identical, prints the differences in the console and also returns the results in a data frame

compare(d1, d2, id, file.export = NULL)

Arguments

• d1: first data frame
• d2: second data frame
• id: character string, primary key of the two data bases
• file.export: character string, name of the XLS file exported

Returns

A data frame containing the differences between the two data bases

Examples

N=100
data1=data.frame(id=1:N,a=rnorm(N),
                        b=factor(sample(LETTERS[1:5],N,TRUE)),
                        c=as.character(sample(LETTERS[1:5],N,TRUE)),
                        d=as.Date(32768:(32768+N-1),origin="1900-01-01"))
data1$c=as.character(data1$c)
data2=data1
data2$id[3]=4654
data2$a[30]=NA
data2$a[31]=45
data2$b=as.character(data2$b)
data2$d=as.character(data2$d)
data2$e=rnorm(N)
compare(data1,data2,"id")

Author(s)

Hugo Varet