The last one worked! The other one, not.
Thank you very much!

Another question about merge(): sometimes I'm merging two dataframes and the merged dataframe has much more rows than the two merged? I think this should not happen,does it?

Cecília


Em Fri, 20 Aug 2010 09:37:26 -0400
 Gabor Grothendieck <ggrothendi...@gmail.com> escreveu:
On Fri, Aug 20, 2010 at 9:33 AM, Gabor Grothendieck
<ggrothendi...@gmail.com> wrote:
On Fri, Aug 20, 2010 at 9:27 AM, Cecilia Carmo <cecilia.ca...@ua.pt> wrote:
It wasn't the merge command. It doesn't create the variable x3.

Cecília



How about:

x$k3 <- with(x, unlist(tapply(k1, k1, seq_along)))
y$k3 <- with(y, unlist(tapply(k1, k1, seq_along)))


And here is a second one in case that one overflows as well:

x$k3 <- with(x, seq_along(k1) - match(k1, k1) + 1)
y$k3 <- with(y, seq_along(k1) - match(k1, k1) + 1)

Note that this one assumes that the data frame is sorted by k1 which
in your example it is.

______________________________________________
R-help@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.

Reply via email to