[R] RMySQL question

From: simone gabbriellini <ogabbrie_at_tin.it>
Date: Sun 03 Apr 2005 - 07:10:52 EST


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@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 Received on Sun Apr 03 07:20:48 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:31:00 EST