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" <benze...@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@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. ______________________________________________ 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.
