[R] combine dataset

[ben@zoo.ufl.edu]

  Something like this:

state1 <- c("CA","TX","FL","OR","GA","MN","NC")
count1 <- c(19,22,11,34,52,12,19)
percent1 <- c(0.34,0.35,0.24,0.42,0.62,0.17,0.34)

state2 <- c("FL","MN","CA","TX")
count2 <- c(22,22,11,52)
percent2 <- c(0.35,0.35,0.24,0.62)


data1 <- data.frame(state1,count1,percent1)
data2 <- data.frame(state2,count2,percent2)

datac <- data1
m <- match(data1$state1,data2$state2,0)
datac$count2 <- ifelse(m==0,0,data2$count2[m])
datac$percent2 <- ifelse(m==0,0,data2$percent2[m])

  If you didn't want to keep all the rows in both data sets (but just the
shared rows) you could use

 merge(data1,data2,by=1)

It might be possible to hack "merge.data.frame" to do this.



On Fri, 16 Mar 2001, Yu-Ling Wu wrote:

> Hi,
>
> I have two data sets look like below:
>
> ==========================
> state count1 percent1
> CA    19    0.34
> TX    22    0.35
> FL    11    0.24
> OR    34    0.42
> GA    52    0.62
> MN    12    0.17
> NC    19    0.34
>
> state count2 percent2
> FL    22    0.35
> MN    22    0.35
> CA    11    0.24
> TX    52    0.62
> ==========================
>
>
> How to combine these two data set and make it look
> like below? Thanks in advance!
>
> ======================================
> state count1 percent1 count2 percent2
> CA    19    0.34      11     0.24
> TX    22    0.35      52     0.62
> FL    11    0.24      22     0.35
> OR    34    0.42       0     0
> GA    52    0.62       0     0
> MN    12    0.17      22     0.35
> NC    19    0.34       0     0
> ======================================
>
>
> __________________________________________________
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
> -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
> r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
> Send "info", "help", or "[un]subscribe"
> (in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
> _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
>

-- 
318 Carr Hall                                bolker at zoo.ufl.edu
Zoology Department, University of Florida    http://www.zoo.ufl.edu/bolker
Box 118525                                   (ph)  352-392-5697
Gainesville, FL 32611-8525                   (fax) 352-392-3704

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._