y has unequal n's . There are 6 states and 7 loci.
It is safer to submit data in the dput() form. See ?dput for information.
John Kane
Kingston ON Canada
> -----Original Message-----
> From: burbrink...@gmail.com
> Sent: Tue, 26 May 2015 20:12:55 -0400
> To: r-help@r-project.org
> Subject: [R] Problem merging data frames and duplicates
>
> Hello All,
>
> I am attempting to merge two data frames that naturally contain duplicate
> entries, however when using either merge or dMerge I get even more
> duplicates.
>
> For example:
>
> data.frame(state=c("IL", "IL", "LA","LA", "MS","MS", "AR", "AR"),
> locus=c(1,1,2,2,3,4,5,6))->x
>
> data.frame(state=c("IL", "IL", "AR", "AR", "TN","TN"),
> locus=c(1,1,2,3,3,4,4))->y
>
> These yield:
>
> x
> state locus
> 1 IL 1
> 2 IL 1
> 3 LA 2
> 4 LA 2
> 5 MS 3
> 6 MS 4
> 7 AR 5
> 8 AR 6
>
> y
> state locus
> 1 IL 1
> 2 IL 1
> 3 AR 2
> 4 AR 3
> 5 TN 3
> 6 TN 4
>
> However, when merged by "state: they produce another second set of AR and
> IL:
> merge(x,y,by=1,all=T)->z
>
> state locus.x locus.y
> 1 AR 5 2
> 2 AR 5 3
> 3 AR 6 2
> 4 AR 6 3
> 5 IL 1 1
> 6 IL 1 1
> 7 IL 1 1
> 8 IL 1 1
> 9 LA 2 NA
> 10 LA 2 NA
> 11 MS 3 NA
> 12 MS 4 NA
> 13 TN NA 3
> 14 TN NA 4
>
> While, the NAs are desired when states are missing, I don't want the
> extra
> duplicated states and values but rather:
>
> state locus.x locus.y
> 1 AR 5 2
> 4 AR 6 3
> 7 IL 1 1
> 8 IL 1 1
> 9 LA 2 NA
> 10 LA 2 NA
> 11 MS 3 NA
> 12 MS 4 NA
> 13 TN NA 3
> 14 TN NA 4
>
> Any help would be much appreciated.
>
> Thanks!
>
> Frank
>
> --
>
> *************************************
> *Frank T. Burbrink, Ph.D.*
> *Professor*
> *Biology Department*
> *6S-143*
> *2800 Victory Blvd.*
> *College of Staten Island/CUNY*
> *Staten Island, New York 10314*
> *E-Mail:frank.burbr...@csi.cuny.edu
> <e-mail%3afrank.burbr...@csi.cuny.edu>*
> *Phone:718-982-3961*
> *Web Page: http://scholar.library.csi.cuny.edu/~fburbrink/
> <http://scholar.library.csi.cuny.edu/%7Efburbrink/>*
> *************************************
> *Chair *
> *Ecology, Evolutionary Biology, and Behavior*
> *Doctoral Subprogram*
> *Biology Program*
> *City University of New York *
> *Graduate Center*
> *365 Fifth Avenue*
> *New York, NY 10016-4309*
> ************************************
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help@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.
____________________________________________________________
FREE 3D EARTH SCREENSAVER - Watch the Earth right on your desktop!
______________________________________________
R-help@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.
