Re: [R] Merging multiple data sets

2012-05-16 Thread Uwe Ligges
On 16.05.2012 15:51, Bharat Warule wrote: Hello R user, I have four data sets in dir "D:/Bharat Warule/Rdata_file" which are output_data_prod_1.rda, output_data_prod_2.rda, output_data_prod_3.rda, output_data_prod_4.rda. Each data set is huge size like number of rows 343297 and columns are nea

[R] Merging multiple data sets

2012-05-16 Thread Bharat Warule
Hello R user, I have four data sets in dir "D:/Bharat Warule/Rdata_file" which are output_data_prod_1.rda, output_data_prod_2.rda, output_data_prod_3.rda, output_data_prod_4.rda. Each data set is huge size like number of rows 343297 and columns are near to 50. For example: x1 <- data.frame(x11=

[R] Merging multiple data sets

2011-06-23 Thread cddesjar
Hi, I am trying to merge data similar to the example data below > dat0 idvar1var2var3 2 1 0 1 3 1 0 1 4 0 1 1 5 0 1 1 > dat1 idvar4var5var6 2 1 0 1 3 1

Re: [R] Merging multiple data sets

2011-06-23 Thread Dennis Murphy
Hi: Try this: merge(merge(dat0, dat1, by = 'id', all.x = TRUE, all.y = TRUE), dat2, by = 'id', all.x = TRUE, all.y = TRUE) Dennis On Thu, Jun 23, 2011 at 9:53 AM, cddesjar wrote: > Hi, > I am trying to merge data similar to the example data below > >> dat0 > > id    var1    var2    var3 > 2  

Re: [R] Merging multiple data sets

2011-06-23 Thread Sarah Goslee
Hi, > How can I best do this in R? I've looked into merge but it excludes ids that > aren't in all 3 data sets. You need to look a bit harder at merge(), specifically the all.x and all.y options. Sarah On Thu, Jun 23, 2011 at 12:53 PM, cddesjar wrote: > Hi, > I am trying to merge data similar t