[R] Problem merging data frames and duplicates

[John Kane]

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: burbrink666 at gmail.com
> Sent: Tue, 26 May 2015 20:12:55 -0400
> To: r-help at 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.Burbrink at csi.cuny.edu
> <E-Mail%3AFrank.Burbrink at 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 at 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!