R help - Apr 2022 - Sorted index of values in matrix

deaR useRs,

I have this following simple dataset
> dput(qq)
structure(1:6, .Dim = 3:2, .Dimnames = list(c("1", "2",
"3"),
    c("1", "2")))

I want to extract row and column index of the sorted values of this matrix

For example,

sort(qq) command will execute the sorted values of this matrix as (1 2 3 4 5 6).
Instead of values, I want the row and column names of these sorted values as
(1,1), (1,2), (1,3), (2,1), (2,2), (2,3)

I thankyou very much in advance for your help.

Eliza


	[[alternative HTML version deleted]]

? Fri, 15 Apr 2022 14:53:36 +0000
Eliza Botto <eliza_botto at outlook.com> ?????:
> sort(qq) command will execute the sorted values of this matrix as (1
> 2 3 4 5 6). Instead of values, I want the row and column names of
> these sorted values as (1,1), (1,2), (1,3), (2,1), (2,2), (2,3)
Combine order() to get the sorting permutation with arrayInd() to get
row and column indices from absolute indices with colnames() and
rownames() to get the names themselves.

-- 
Best regards,
Ivan

Please stop posting in HTML format.

I think your specified result coordinates are in (col,row) order, which is not
normal for R. The solution below yields (row,col) order.

qq <- structure(1:6, .Dim = 3:2, .Dimnames = list(c("1",
"2", "3"), c("1", "2")))
pos <- expand.grid( r = seq.int( nrow( qq ) )
                  , c = seq.int( ncol( qq ) ) )
qq #'confirm source layout is column major
pos[ order( qq ), ] # (row,col)
pos[ order( qq ), 2:1 ] # (col,row)


On April 15, 2022 7:53:36 AM PDT, Eliza Botto <eliza_botto at outlook.com>
wrote:
>deaR useRs,
>
>I have this following simple dataset
>
>> dput(qq)
>
>structure(1:6, .Dim = 3:2, .Dimnames = list(c("1", "2",
"3"),
>    c("1", "2")))
>
>I want to extract row and column index of the sorted values of this matrix
>
>For example,
>
>sort(qq) command will execute the sorted values of this matrix as (1 2 3 4 5
6). Instead of values, I want the row and column names of these sorted values as
(1,1), (1,2), (1,3), (2,1), (2,2), (2,3)
>
>I thankyou very much in advance for your help.
>
>Eliza
>
>
>	[[alternative HTML version deleted]]
>
>______________________________________________
>R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
>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.
-- 
Sent from my phone. Please excuse my brevity.