Re: [R] Merging multiple data sets

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

Re: [R] Merging multiple data sets

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

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