Comparing two databases assumed to be identical

Share:

Description

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

Usage

1
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

Value

A data frame containing the differences between the two data bases

Author(s)

Hugo Varet

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
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")