[R] Merge function - Return NON matches

RHelpPlease rrumple at trghcsolutions.com
Thu Apr 26 21:33:08 CEST 2012


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.



More information about the R-help mailing list