[R] RMySQL question

simone gabbriellini ogabbrie at tin.it
Sat Apr 2 23:10:52 CEST 2005


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




More information about the R-help mailing list