Sorting data in R according to the header of another table
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.