[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