我有一个矩阵
df<-matrix(data=c(3,7,5,0,1,0,0,0,0,8,0,9), ncol=2)
rownames(df)<-c("a","b","c","d","e","f")
[,1] [,2]
a 3 0
b 7 0
c 5 0
d 0 8
e 1 0
f 0 9我想按降序排列矩阵,首先按列1排序,然后按列2排序,从而得到矩阵
df.ordered<-matrix(data=c(7,5,3,1,0,0,0,0,0,0,9,8),ncol=2)
rownames(df.ordered)<-c("b","c","a","e","f","d")
[,1] [,2]
b 7 0
c 5 0
a 3 0
e 1 0
f 0 9
d 0 8对如何实现这一点有什么建议吗?谢谢。
发布于 2012-08-23 00:28:26
order函数应该可以做到这一点。
df[order(df[,1],df[,2],decreasing=TRUE),]发布于 2013-07-12 13:26:07
为了完成主要答案,这里有一种方法可以通过编程来完成,而不必手动指定列:
set.seed(2013) # preparing my example
mat <- matrix(sample.int(10,size = 30, replace = T), ncol = 3)
mat
[,1] [,2] [,3]
[1,] 5 1 6
[2,] 10 3 1
[3,] 8 8 1
[4,] 8 9 9
[5,] 3 7 3
[6,] 8 8 5
[7,] 10 10 2
[8,] 8 10 7
[9,] 10 1 9
[10,] 9 4 5举个简单的例子,假设我想使用所有列的出现顺序来对矩阵的行进行排序:(可以很容易地为矩阵提供索引的向量)
mat[do.call(order, as.data.frame(mat)),] #could be ..as.data.frame(mat[,index_vec])..
[,1] [,2] [,3]
[1,] 3 7 3
[2,] 5 1 6
[3,] 8 8 1
[4,] 8 8 5
[5,] 8 9 9
[6,] 8 10 7
[7,] 9 4 5
[8,] 10 1 9
[9,] 10 3 1
[10,] 10 10 2发布于 2012-08-23 00:33:19
order函数会帮你解决这个问题,试试这个:
df[order(-df[,1],-df[,2]),]
[,1] [,2]
b 7 0
c 5 0
a 3 0
e 1 0
f 0 9
d 0 8df前面的减号表示顺序在降低。您将获得与设置decreasing=TRUE相同的结果。
df[order(df[,1],df[,2],decreasing=TRUE),]https://stackoverflow.com/questions/12077413
复制相似问题