Thanks, but I kind of new this way already and it doesn't seem an optimal thing to do.
What I was looking for is to pass some argument in 'merge' itself which doesn't change the ordering of 'x'. Or, more than that, I am interested in knowing that why is it changing the order or what order is it taking when I specified sort=F. Regards Utkarsh -------- Original Message -------- Subject: Re: [R] help in merging From: milton ruser <milton.ru...@gmail.com> Date: Fri, December 25, 2009 1:38 am To: utkarsh.sing...@global-analytics.com Cc: r-help@r-project.org Hi there, You can add a order column on x or y and after use this field to order z. Like z<-z[order(z$orderfield),] To generate a order on x or y you can do something like x$xorder<-1:nrow(x) cheers milton On Thu, Dec 24, 2009 at 2:26 PM, <[1]utkarsh.sing...@global-analytics.com> wrote: Hi All, I want to "merge" two datasets by column "ID" and I don't want the result to be sorted by "ID". I am doing the following: > z = merge(x, y, by = "ID", sort=F) The result is not sorted by "ID". But (as oppose to what I expected) it is not even in the original order of either "x" or "y". Can somebody tell what to do if I wanted it to be in the original order of x. P.S.: As my dataset is very huge and I couldn't find the right subset of the data which explains the above problem, so I can't attach it at the moment. If anybody knows the answer, please reply; or else I will try to get the right subset. Thanks in advance Utkarsh ______________________________________________ [2]r-h...@r-project.org mailing list [3]https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide [4]http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. References 1. mailto:utkarsh.sing...@global-analytics.com 2. mailto:R-help@r-project.org 3. https://stat.ethz.ch/mailman/listinfo/r-help 4. http://www.r-project.org/posting-guide.html ______________________________________________ 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.