[R] Finding unmatched data between two dataframe using severalfactors

[Peter Alspach]

Andrew

Have you tried:

dat2[!paste(dat2[,1], dat2[,2])%in%paste(dat1[,1], dat1[,2]),]  ?

HTH ....

Peter Alspach
 

> -----Original Message-----
> From: r-help-bounces at r-project.org 
> [mailto:r-help-bounces at r-project.org] On Behalf Of Andrew McFadden
> Sent: Monday, 12 May 2008 9:40 a.m.
> To: r-help at r-project.org
> Subject: [R] Finding unmatched data between two dataframe 
> using severalfactors
> 
> Hi R users
> 
> I am trying to find unmatched data from two dataframes. I 
> would like to find unmatched data based on several factors. 
> For the following data:
> 
> dat1 <- data.frame(x = paste("A", 1:6, sep=""), 
>                   y = c("andy","bob","ciaran","dan", "eion", 
>                            "fred"))
> dat1
> 
> 
> dat2 <- data.frame(x = paste("A", c(1,2,3,5,6), sep=""), 
>                   y = c("andy", "bob", "ciaran", 
>                            "dan", "zane"),z=c(10,20,30,40,50))  
> 
> dat2
> 
> 
> I would like to know data that from dat2 that doesn't appear in dat1
> based on both the x and y factors ie (A5, dan, 40) and (A6,zane, 50).
> 
> I have tried two approaches but have not been successful
> 
> ? nomatch <- subset(dat1, is.element(?) == FALSE)
> ? setdiff(dat1$x,dat2$y)
> 
> Any thoughts would be great
> 
> Regards
> 
> Andy
> 
> Andrew McFadden MVS BVSc
> Incursion Investigator
> Investigation & Diagnostic Centres - Wallaceville Biosecurity New 
> Zealand Ministry of Agriculture and Forestry
> 
> Phone 04 894 5600 Fax 04 894 4973 Mobile 029 894 5611 Postal address: 
> Investigation and Diagnostic Centre- Wallaceville Box 40742 Ward St 
> Upper Hutt
> 
> 
> ##############################################################
> ##########
> This email message and any attachment(s) is intended solely for the
> addressee(s) named above. The information it contains is confidential
> and may be legally privileged.  Unauthorised use of the 
> message, or the
> information it contains, may be unlawful. If you have received this
> message by mistake please call the sender immediately on 64 4 8940100
> or notify us by return email and erase the original message and
> attachments. Thank you.
> 
> The Ministry of Agriculture and Forestry accepts no responsibility for
> changes made to this email or to any attachments after 
> transmission from
> the office.
> ##############################################################
> ##########
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help at r-project.org mailing list
> 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.
> 

The contents of this e-mail are privileged and/or confidential to the named
 recipient and are not to be used by any other person and/or organisation.
 If you have received this e-mail in error, please notify the sender and delete
 all material pertaining to this e-mail.