[R] not common records

Ashta sewashm at gmail.com
Fri Jun 3 04:04:47 CEST 2016


I have 2 data sets.  File1 and File2. Some records are common to both
data sets. For those common records I want get the difference between
d_x1z1= z1-x1   and d_x2z2= z2-x2.

File1<- data.frame(var = c(561,752,800,900),  x1= c(23,35,40,15), x2=
c(125,284,280,347))
File2<- data.frame(var = c(561,752,800,1001), z1= c(43,45,40,65), z2=
c(185,299,280,310))

Record  900      15    347   appears only in File1
Record   1001    65    310  appears only in File2

File3 should look like as follows

File3
var      x1     x2     z1    z2    d_x1z1   d_x2z2
561      23    125  43    165     20         40
752      35    284  45    299      8          15
800      40    280  40    280      0           0
900      15    347  NA   NA      NA       NA
1001     NA  NA   65    310     NA      NA

How do I get those record not common in both data sets ?
merge( File1,File2) gave me only for common "var"



More information about the R-help mailing list