Skip to content
Prev 10184 / 398503 Next

combine dataset

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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._