how to add two data.frame with the same column but different row numbers

Hi:

Here's one approach:

df1 <- data.frame(x = letters[1:3], y = 1:3)
df2 <- data.frame(x = c('a', 'c'), z = c(6, 1))
dfm <- merge(df1, df2, all.x = TRUE)
dfm

x y  z
1 a 1  6
2 b 2 NA
3 c 3  1
sumdf <- data.frame(x = dfm$x, y = rowSums(dfm[, -1], na.rm = TRUE))
  x y
1 a 7
2 b 2
3 c 4

HTH,
Dennis

Hi all,

Suppose I have 2 data.frame , a and b, how can I add them together to get c?
Thanks

a

?A
a 1
b 2
c 3

b

?A
a 6
c 1

c

? A
a 7
b 2
c 4

--
Best,
Zhenjiang

? ? ? ?[[alternative HTML version deleted]]

______________________________________________
R-help at r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20110415/1d599d1f/attachment.pl>

Thanks, Dennis! I'll go with it. It's surprising there is no ready way to do
that. I imagine it should be a common data manipulation to add two
data.frame from two different sources. It could happen that one data.frame
is missing some rows while the other have some more.

If you represent them as zoo series then you can do it using +
(although the definition of + is different than in your post).   Here
"a", "b" and "c" are the "times":

library(zoo)
a <- zoo(1:3, letters[1:3])
b <- zoo(c(6, 1), c("a", "c"))
a+b

The last line gives:

a+b

a c
7 4

To use the definition in your post one could do this (which has the
effect of modifying b so that a+b works as in your post):

merge(a, b, fill = 0, retclass = NULL)
a+b

The last line gives:

a+b

a b c
7 2 4

Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com

An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20110415/9b6a1ae3/attachment.pl>