[R] RMySQL question

Don MacQueen macq at llnl.gov
Mon Apr 4 16:08:23 CEST 2005


Use the rownames() function to set the rownames equal to your first 
column, and then drop the first column.

I don't know if there is a way to do it during retrieval from MySQL.

-Don

At 11:10 PM +0200 4/2/05, simone gabbriellini wrote:
>Dear List,
>I have this little problem:
>
>I work with adiacency matrix like:
>
>data	me you
>me	0	1
>you	1	0
>
>I store those matrix in a mysql database
>
>actually I use RMySQL with:
>
>res<-dbSendQuery(connection, "SELECT * FROM table")
>myDataFrame<-fetch(res)
>
>to retrive the table, and I have
>
>    data me  you
>1  io     0     1
>2  tu     1     0
>
>I would like the first column to be seen not as data, but as label, like:
>
>data me  you
>io      0     1
>tu      1     0
>
>should I change something in the table structure in mysql, or should 
>I tell R something particular like "the first column is not data"? 
>If so, how?
>
>hope I have expressed well my intent
>thanx in advance
>
>simone
>
>______________________________________________
>R-help at stat.math.ethz.ch mailing list
>https://stat.ethz.ch/mailman/listinfo/r-help
>PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html


-- 
--------------------------------------
Don MacQueen
Environmental Protection Department
Lawrence Livermore National Laboratory
Livermore, CA, USA




More information about the R-help mailing list