Hi there, I wish to merge a common variable between a list and a data.frame & return rows via the data.frame where there is NO match. Here are some details: The list, where the variable/col.name = CLAIM_NO CLAIM_NO 20 83 1440 4439 7002 ...> dim(hrc78_clm_no)[1] 6678 1 The data.frame, where there exists a variable with the same name, CLAIM_NO.> dim(bestPartAreadmin)[1] 13068 93 I wish to merge the two together & only return a data.frame where there is NO match in the CLAIM_NO between both files. I've read & tried code via the "merge" function. If "merge" can do this, I'm missing something with the available options. I'm figuring something like: clm_no_nomatch <- merge(hrc78_clm_no, bestPartAreadmin, by = "CLAIM_NO", .. .. ..) Your help is most appreciated! -- View this message in context: http://r.789695.n4.nabble.com/Merge-function-Return-NON-matches-tp4590755p4590755.html Sent from the R help mailing list archive at Nabble.com.
Hi, To increase the chances of you getting help on this one, please give example data (a small data.frame, a small list) that you are trying to do this on, and also show the desired output. Whip these variables up in your R workspace and paste the output of `dput` for each into your follow up email. It's hard (for me, anyways) to get what you're after ... I'm guessing something that ends up looking like this will end up being one solution: subset(your.df, !CLAIM_NO %in% `something`) but it's hard for me to tell from where I'm setting. -steve On Thu, Apr 26, 2012 at 3:33 PM, RHelpPlease <rrumple at trghcsolutions.com> wrote:> Hi there, > I wish to merge a common variable between a list and a data.frame & return > rows via the data.frame where there is NO match. ?Here are some details: > > The list, where the variable/col.name = CLAIM_NO > CLAIM_NO > 20 > 83 > 1440 > 4439 > 7002 > ... > >> dim(hrc78_clm_no) > [1] 6678 ? ?1 > > The data.frame, where there exists a variable with the same name, CLAIM_NO. >> dim(bestPartAreadmin) > [1] 13068 ? ?93 > > I wish to merge the two together & only return a data.frame where there is > NO match in the CLAIM_NO between both files. > > I've read & tried code via the "merge" function. ?If "merge" can do this, > I'm missing something with the available options. > > I'm figuring something like: > > clm_no_nomatch <- merge(hrc78_clm_no, bestPartAreadmin, by = "CLAIM_NO", ?.. > .. ..) > > Your help is most appreciated! > > > > -- > View this message in context: http://r.789695.n4.nabble.com/Merge-function-Return-NON-matches-tp4590755p4590755.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > 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.-- Steve Lianoglou Graduate Student: Computational Systems Biology ?| Memorial Sloan-Kettering Cancer Center ?| Weill Medical College of Cornell University Contact Info: http://cbio.mskcc.org/~lianos/contact
Assuming everything else is good, the "all" or "all.x" or "all.y" arguments to merge() should do what I think you're asking for. You did read the help page for merge, right? -Don -- Don MacQueen Lawrence Livermore National Laboratory 7000 East Ave., L-627 Livermore, CA 94550 925-423-1062 On 4/26/12 12:33 PM, "RHelpPlease" <rrumple at trghcsolutions.com> wrote:>Hi there, >I wish to merge a common variable between a list and a data.frame & return >rows via the data.frame where there is NO match. Here are some details: > >The list, where the variable/col.name = CLAIM_NO >CLAIM_NO >20 >83 >1440 >4439 >7002 >... > >> dim(hrc78_clm_no) >[1] 6678 1 > >The data.frame, where there exists a variable with the same name, >CLAIM_NO. >> dim(bestPartAreadmin) >[1] 13068 93 > >I wish to merge the two together & only return a data.frame where there is >NO match in the CLAIM_NO between both files. > >I've read & tried code via the "merge" function. If "merge" can do this, >I'm missing something with the available options. > >I'm figuring something like: > >clm_no_nomatch <- merge(hrc78_clm_no, bestPartAreadmin, by = "CLAIM_NO", >.. >.. ..) > >Your help is most appreciated! > > > >-- >View this message in context: >http://r.789695.n4.nabble.com/Merge-function-Return-NON-matches-tp4590755p >4590755.html >Sent from the R help mailing list archive at Nabble.com. > >______________________________________________ >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.