[R] not common records

Jeff Newmiller jdnewmil at dcn.davis.ca.us
Fri Jun 3 07:47:12 CEST 2016


?merge

Pay attention to the all-whatever parameters. 
-- 
Sent from my phone. Please excuse my brevity.

On June 2, 2016 7:04:47 PM PDT, Ashta <sewashm at gmail.com> wrote:
>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"
>
>______________________________________________
>R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
>https://stat.ethz.ch/mailman/listinfo/r-help
>PLEASE do read the posting guide
>http://www.R-project.org/posting-guide.html
>and provide commented, minimal, self-contained, reproducible code.

	[[alternative HTML version deleted]]



More information about the R-help mailing list