# [R] Odp: Letters(V1, V2..) as row col indices instead of numbers

Phil Spector spector at stat.berkeley.edu
Fri Jan 28 18:08:14 CET 2011

```Suppose your correlation matrix is called cc.  One way
to do what you want is

result = cbind(as.vector(row(cc)),as.vector(col(cc)),as.vector(cc))
result = result[result[,1] != result[,2],]

- Phil Spector
Statistical Computing Facility
Department of Statistics
UC Berkeley
spector at stat.berkeley.edu

On Fri, 28 Jan 2011, KumaraGuru wrote:

> While listing it like that is it possible to remove the rows that has same row and col numbers?
>
> Like..
> 1 1 x
> 2 2 x2
> ....
>
> Regards,
> Kumaraguru
>
>
> On Jan 28, 2011, at 9:23 AM, Petr PIKAL <petr.pikal at precheza.cz> wrote:
>
>> Hi
>>
>> KumaraGuru <kumaragurutp at gmail.com> napsal dne 28.01.2011 17:03:50:
>>
>>> I want to melt the cor matrix and form a 3 col matrix with row# col# and
>> cor.
>>
>> Well, in that case it will be probably better to transform it to data
>> frame and use melt. Or you can drop dimensions of this matrix and generate
>> proper sequences of row and column numbers. Try it with smaller matrix.
>>
>> Row names does not matter
>>
>>> x<-matrix(1:12, 4,4)
>>> row.names(x)<-letters[1:4]
>>> colnames(x)<-letters[1:4]
>>> x
>>  a b  c d
>> a 1 5  9 1
>> b 2 6 10 2
>> c 3 7 11 3
>> d 4 8 12 4
>>> dim(x)<-NULL
>>> x
>> [1]  1  2  3  4  5  6  7  8  9 10 11 12  1  2  3  4
>>> cbind(rep(1:4, 4), rep(1:4, each=4), x)
>>           x
>> [1,] 1 1  1
>> [2,] 2 1  2
>> [3,] 3 1  3
>> [4,] 4 1  4
>> [5,] 1 2  5
>> [6,] 2 2  6
>> [7,] 3 2  7
>> [8,] 4 2  8
>> [9,] 1 3  9
>> [10,] 2 3 10
>> [11,] 3 3 11
>> [12,] 4 3 12
>> [13,] 1 4  1
>> [14,] 2 4  2
>> [15,] 3 4  3
>> [16,] 4 4  4
>>>
>>
>>
>>
>> Regards
>> Petr
>>
>>
>>>
>>> This I m using to draw a graph.
>>>
>>> Regards,
>>> Kumaraguru
>>>
>>>
>>> On Jan 28, 2011, at 6:47 AM, Petr PIKAL <petr.pikal at precheza.cz> wrote:
>>>
>>>> Hi
>>>>
>>>> r-help-bounces at r-project.org napsal dne 28.01.2011 09:52:05:
>>>>
>>>>>
>>>>> What makes matrix to print V1, V2 as the row and col indices instead
>> of
>>>>> numbers??
>>>>>
>>>>> c1 = cor(cdata)
>>>>>
>>>>> I am printing c1 below. I need only numbers. I dont need V1,
>> V2...what
>>>>> should I do in this case??
>>>>> http://r.789695.n4.nabble.com/file/n3243980/ramesh.txt ramesh.txt
>>>>>
>>>>>          V1        V2        V3        V4        V5        V6 V7
>>>>> V1  1.0000000 0.9471591 0.9191233 0.9403129 0.9689690 0.9621362
>>>> 0.9529811
>>>>> V2  0.9471591 1.0000000 0.8888108 0.9108174 0.9703906 0.9425248
>>>> 0.9294308
>>>>> V3  0.9191233 0.8888108 1.0000000 0.8788107 0.9077245 0.9078971
>>>> 0.8965331
>>>>> V4  0.9403129 0.9108174 0.8788107 1.0000000 0.9477058 0.9017977
>>>> 0.8646251
>>>>> V5  0.9689690 0.9703906 0.9077245 0.9477058 1.0000000 0.9531459
>>>> 0.9162016
>>>>> V6  0.9621362 0.9425248 0.9078971 0.9017977 0.9531459 1.0000000
>>>> 0.9447130
>>>>> V7  0.9529811 0.9294308 0.8965331 0.8646251 0.9162016 0.9447130
>>>> 1.0000000
>>>>> V8  0.9167526 0.9395067 0.8491496 0.8942693 0.9460702 0.9304229
>>>> 0.8505287
>>>>> V9  0.9512951 0.9598302 0.8666839 0.9465725 0.9645178 0.9486105
>>>> 0.8979753
>>>>> V10 0.9551633 0.9040160 0.9180022 0.9429816 0.9448644 0.9220875
>>>> 0.9075537
>>>>
>>>> Vn are names of columns which R gave to your matrix when you read it
>> as a
>>>> data frame. And cor just makes a matrix of pairwise corelation
>>>> coefficients from this data frame conveniently named from this data
>> frame.
>>>> If you do not want those names just unname it.
>>>>
>>>> c1 = unname(cor(cdata))
>>>>
>>>> But I wonder why you dislike those names which are,  well, just names.
>>>>
>>>> Regards
>>>> Petr
>>>>
>>>>
>>>>>
>>>>> --
>>>>> View this message in context:
>>>> http://r.789695.n4.nabble.com/Letters-V1-V2-as-
>>>>> Sent from the R help mailing list archive at Nabble.com.
>>>>>
>>>>> ______________________________________________
>>>>> R-help at r-project.org mailing list
>>>>> https://stat.ethz.ch/mailman/listinfo/r-help
>>>> http://www.R-project.org/posting-guide.html
>>>>> and provide commented, minimal, self-contained, reproducible code.
>>>>
>>
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help