[R] Help with getting ?match to not sort

jim holtman jholtman at gmail.com
Mon Nov 8 22:39:10 CET 2010


Missing: a closer reading of the help page --

Value
A data frame. The rows are by default lexicographically sorted on the
common columns, but for sort = FALSE are in an unspecified order.

So sort = FALSE says unspecified.  If you want the original order,
then add a column to the dataframe with the order and then sort the
result.

On Mon, Nov 8, 2010 at 4:09 PM, Tal Galili <tal.galili at gmail.com> wrote:
> Hello all,
>
> I think I am missing something about the sorting parameter in the "match"
> command/
> Here is an example:
>
>
> a1 <- data.frame(name = c("D", "B", "C", "A", "A", "C"))
> a2 <- data.frame(name = c("A", "B", "C", "D"), num = 1:4)
> a1
> a2
> merge(a1, a2, sort = F, by.x = T)
>
>
>
> The result is:
>
>  name num
> 1    D   4
> 2    B   2
> 3    C   3
> 4    C   3
> 5    A   1
> 6    A   1
>
>
> While I wish my rows to be in the same order as in a1, they are having some
> other order.
>
> What am I missing here?
>
>
> Thanks.
>
>
> ----------------Contact
> Details:-------------------------------------------------------
> Contact me: Tal.Galili at gmail.com |  972-52-7275845
> Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) |
> www.r-statistics.com (English)
> ----------------------------------------------------------------------------------------------
>
>        [[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.
>



-- 
Jim Holtman
Cincinnati, OH
+1 513 646 9390

What is the problem that you are trying to solve?



More information about the R-help mailing list