Message-ID: <p06210201be76fa7a02d7@[128.115.153.6]>
Date: 2005-04-04T14:08:23Z
From: Don MacQueen
Subject: RMySQL question
In-Reply-To: <e65c720769e4cba81c0d32bad2defa9f@tin.it>
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