Hi, Steven i just solved it.
the problem was with RMYSQL, not with the subset. > dbWriteTable(..., row.names=FALSE) solved my problem... thanks, sorry for the inconvenience. 2011/7/6 Steven Kennedy <stevenkennedy2...@gmail.com> > What function are you using to export your data.frame to MySQL? > > > > On Wed, Jul 6, 2011 at 10:41 PM, Thiago Clark <clark.thi...@gmail.com> > wrote: > > Dear R-helpers, > > > > I have a huge dataset and I create a filter selecting only the cases I > want > > using: > >>data <- subset(data, data$var=='x' | data$var=='y' | data$var=='z' | ... > ) > > > > The problem is, when i check my new data it doen't show a row_names > column > > but when the data is exported to MYSQL (using RMYSQL) it creates a column > > row_names. > > > > I've already tried > >>row.names(data)<- NULL > > tried > >>write.table > > then > >>read.table > > > > tried > >>as.matrix(data) > > > > but the row_names column does not appear in R, but appears everytime I > > export to MYSQL > > > > I've done a similar work with another dataset but the difference was that > in > > the filter I used > >>data <- subset(data, substr(as.numeric(data$var),1,2==0 | > > substr(as.numeric(data$var),1,2==1 | ... ) > > > > I don't know how to get rid of that column. > > > > thanks > > > > [[alternative HTML version deleted]] > > > > ______________________________________________ > > R-help@r-project.org mailing list > > https://stat.ethz.ch/mailman/listinfo/r-help > > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > > and provide commented, minimal, self-contained, reproducible code. > > > [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
