thr3ads.net - R help - [R] Letters(V1,V2..) as row col indices instead of numbers [Jan 2011]

If this information is useful, please help other people find it:
Share via:

kparamas

2011-Jan-28 08:52 UTC

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

What makes matrix to print V1, V2 as the row and col indices instead of
numbers??

cdata = read.table("ramesh.txt") #cdata is read from a file.
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

-- 
View this message in context:
http://r.789695.n4.nabble.com/Letters-V1-V2-as-row-col-indices-instead-of-numbers-tp3243980p3243980.html
Sent from the R help mailing list archive at Nabble.com.

Petr PIKAL

2011-Jan-28 13:47 UTC

head link

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

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??
> 
> cdata = read.table("ramesh.txt") #cdata is read from a file.
> 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-> row-col-indices-instead-of-numbers-tp3243980p3243980.html
> 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
> PLEASE do read the posting guide 
http://www.R-project.org/posting-guide.html> and provide commented, minimal, self-contained, reproducible code.

KumaraGuru

2011-Jan-28 16:03 UTC

head link

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

I want to melt the cor matrix and form a 3 col matrix with row# col# and cor. 

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??
>> 
>> cdata = read.table("ramesh.txt") #cdata is read from a file.
>> 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-
>> row-col-indices-instead-of-numbers-tp3243980p3243980.html
>> 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
>> PLEASE do read the posting guide 
> http://www.R-project.org/posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
>

Petr PIKAL

2011-Jan-28 16:23 UTC

head link

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

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??
> >> 
> >> cdata = read.table("ramesh.txt") #cdata is read from a
file.
> >> 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-
> >> row-col-indices-instead-of-numbers-tp3243980p3243980.html
> >> 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
> >> PLEASE do read the posting guide 
> > http://www.R-project.org/posting-guide.html
> >> and provide commented, minimal, self-contained, reproducible code.
> >

KumaraGuru

2011-Jan-28 16:44 UTC

head link

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

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??
>>>> 
>>>> cdata = read.table("ramesh.txt") #cdata is read from
a file.
>>>> 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-
>>>> row-col-indices-instead-of-numbers-tp3243980p3243980.html
>>>> 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
>>>> PLEASE do read the posting guide 
>>> http://www.R-project.org/posting-guide.html
>>>> and provide commented, minimal, self-contained, reproducible
code.
>>> 
>

Phil Spector

2011-Jan-28 17:08 UTC

head link

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

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??
>>>>>
>>>>> cdata = read.table("ramesh.txt") #cdata is read
from a file.
>>>>> 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-
>>>>> row-col-indices-instead-of-numbers-tp3243980p3243980.html
>>>>> 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
>>>>> PLEASE do read the posting guide
>>>> 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
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>

R help - Jan 2011 - Letters(V1,V2..) as row col indices instead of numbers

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

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

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

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

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

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