[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