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.
