boris.steipe at utoronto.ca
Sun Mar 26 07:04:24 CEST 2017
dat3 <- merge(dat1, dat2, all.x = TRUE, all.y = TRUE)
... and then you had asked for 0, not NA in your results.
I think that's not a good idea - since you can't distinguish
a legitimate value 0 from a missing value that way, but if you
dat3[is.na(dat3)] <- 0
(and don't post in HTML)
> On Mar 26, 2017, at 12:37 AM, Ashta <sewashm at gmail.com> wrote:
> Hi all,
> I have more than two files and merge by a single column and preserve the
> other columns.
> Here is an example of two files
> dat1 <- read.table(header=TRUE, text=' ID T1 T2
> ID1 125 245
> ID2 141 264
> ID3 133 281')
> dat2 <- read.table(header=TRUE, text=' ID G1 G2
> ID2 25 46
> ID4 41 64
> ID5 33 81')
> How do I get the following output?
> ID T1 T2 G1 G2
> ID1 125 245 0 0
> ID2 141 264 25 46
> ID3 133 281 0 0
> ID4 0 0 41 64
> ID5 0 0 33 81
> Thank you.
> [[alternative HTML version deleted]]
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
More information about the R-help