[R] Sorting data in R according to the header of another table
R. Michael Weylandt <michael.weylandt@gmail.com>
michael.weylandt at gmail.com
Mon Oct 3 17:06:54 CEST 2011
Try this:
X = 1:5; names(X) = letters[sample(5)]
Y = matrix(1:25, 5); colnames(Y) = letters[1:5]
Y[ , names(X)]
Hope this helps,
Michael Weylandt
On Oct 3, 2011, at 6:20 AM, "Samir Benzerfa" <benzerfa at gmx.ch> wrote:
> Hi everyone,
>
>
>
> My (simplified) problem is the following one: I have two tables. The first
> table contains 5 columns with 5 values and the second table contains a
> single value for each vector name of the first table (see tables below):
>
>
>
> Table 1:
>
>
>
> A B C D E
>
> 1 2 3 4 5
>
> 2 3 4 5 6
>
> 3 4 5 6 7
>
> 4 5 6 7 8
>
> 5 6 7 8 9
>
>
>
>
>
> Table 2:
>
>
>
> A B C D E
>
> 3 5 2 1 4
>
>
>
> My goal is to first sort the values of Table 2 and then use the new header
> of it to sort the columns of Table 1 according to that. I already sorted
> Table 2 by using the sort(Table2) function getting the following result:
>
>
>
> D C A E B
>
> 1 2 3 4 5
>
>
>
> How can I now sort the columns in Table 1 according to the header of the new
> sorted Table 2. That is, have column D in the first position of Table 1,
> column C in the second, and forth.
>
>
>
> Many thanks for your assistance!
>
> S.B.
>
>
>
>
> [[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.
More information about the R-help
mailing list