[R] Order of columns(variables) in dataframe

jim holtman jholtman at gmail.com
Sun Jul 20 13:42:13 CEST 2008


Is this what you want:

> x <- read.table(textConnection("   v1 v2 v3 v4
+ 1  2  8  7  1
+ 2  3  5  8  4
+ 3  1 12  2  6
+ 4  9  4  6  3
+ 5  5 11  9  6"), header=TRUE)
> closeAllConnections()
> # order by the last row
> x[, order(unlist(x[5,]), decreasing=TRUE)]
  v2 v3 v4 v1
1  8  7  1  2
2  5  8  4  3
3 12  2  6  1
4  4  6  3  9
5 11  9  6  5


On Sun, Jul 20, 2008 at 7:32 AM, Daniel Wagner <danieljm1976 at yahoo.com> wrote:
> Dear R experts,
>
> I have a dataframe with 4 columns (variables). I want to redorder (or reposition) these columns on the basis of a value in its last row. e.g.
>
> df1<-data.frame( v1= c(2,3,1,9,5), v2=c(8,5,12,4,11), v3=c(7,8,2,6,9), v4=c(1,4,6,3,6))
>
>> df1
>    v1 v2 v3 v4
> 1  2  8  7  1
> 2  3  5  8  4
> 3  1 12  2  6
> 4  9  4  6  3
> 5  5 11  9  6
>
> I wanto to get the order of df1 on the basis of value in last row (descending order) like
>
>    v2 v3 v4 v1
> 1  8  7  1  2
> 2  5  8  4  3
> 3 12  2  6  1
> 4  4  6  3  9
> 5 11  9  6  5
>
> Could somebody help me?
>
> Daniel
> Amsterdam
>
>
>
>
>
>
> Send instant messages to your online friends http://uk.messenger.yahoo.com
>        [[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 you are trying to solve?



More information about the R-help mailing list