search for: irisquery

Displaying 2 results from an estimated 2 matches for "irisquery".

2017 Oct 24
1
Creating a data table (frame?) from a SQL Statement?
...st using that data. However, I'm now trying to load the same data via an SQL command, but I can't seem to get the data structure defined so R will like it -- using the included "iris" dataset. I've tried these ways of loading the SQL statement into a compatible R Structure: irisQuery <- data(dbGetQuery(conn, "select * from iris")) irisQuery <- data.frame(dbGetQuery(conn, "select * from iris")) irisQuery <- table(dbGetQuery(conn, "select * from iris")) . . . Followed by: boxM(irisQuery[,-5], irisQuery[,5]) Nothing works work. For exam...
2017 Oct 24
0
Creating a data table (frame?) from a SQL Statement?
...7;/localhost:3306/morkus","root", >"password") >dbListTables(conn) > // works! >count <- dbGetQuery(conn,"select count(*) from iris") // >works! >irisQuery <- read.table(dbGetQuery(conn, "select * from iris")) works! >irisQuery > // displays table from iris dataset I imported into MySQL >boxM(irisQuery[,-5], irisQuery[,5])...