[R] not common records
Ashta
sewashm at gmail.com
Sat Jun 4 00:12:23 CEST 2016
Thank you Jeff. Solved.
On Fri, Jun 3, 2016 at 12:47 AM, Jeff Newmiller
<jdnewmil at dcn.davis.ca.us> wrote:
> ?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.
More information about the R-help
mailing list