Displaying 7 results from an estimated 7 matches for "irisquery".
2017 Oct 24
2
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?
...ct(drv, "jdbc:mysql://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])...
2017 Oct 25
2
How to create a table structure in Java code?
Hi all,
Using RConsole, it's easy to get data from the database that you can use in an R Command. Like this:
(Reference case)
irisQuery <- dbGetQuery(conn, "select * from iris")
boxM(irisQuery [,-5], irisQuery[,5])
----
(Actual case this posting is about)
Yet, if I'm getting that same (sample IRIS) data, say, in a web service possibly POSTED from a SQL command, that same data might look like this (portion of the...
2017 Oct 26
3
How to create a table structure in Java code?
...,3.6,1.4,0.2,setosa"
> ), header = FALSE)
>
> HTH,
> Jan
>
> On 25-10-17 12:50, Morkus via R-devel wrote:
>
>> Hi all,
>> Using RConsole, it's easy to get data from the database that you can use in an R Command. Like this:
>> (Reference case)
>> irisQuery <- dbGetQuery(conn, "select * from iris")
>> boxM(irisQuery [,-5], irisQuery[,5])
>> ---------------------------------------------------------------
>>
>> (Actual case this posting is about)
>> Yet, if I'm getting that same (sample IRIS) data, say, in...
2017 Oct 26
0
How to create a table structure in Java code?
...tosa
4.6,3.1,1.5,0.2,setosa
5,3.6,1.4,0.2,setosa"
), header = FALSE)
HTH,
Jan
On 25-10-17 12:50, Morkus via R-devel wrote:
> Hi all,
>
> Using RConsole, it's easy to get data from the database that you can use in an R Command. Like this:
>
> (Reference case)
>
> irisQuery <- dbGetQuery(conn, "select * from iris")
> boxM(irisQuery [,-5], irisQuery[,5])
>
> ----
>
> (Actual case this posting is about)
>
> Yet, if I'm getting that same (sample IRIS) data, say, in a web service possibly POSTED from a SQL command, that same data m...
2017 Oct 26
0
How to create a table structure in Java code?
...FALSE)
>>
>> HTH,
>> Jan
>>
>> On 25-10-17 12:50, Morkus via R-devel wrote:
>>
>>> Hi all,
>>> Using RConsole, it's easy to get data from the database that you can use in an R Command. Like this:
>>> (Reference case)
>>> irisQuery <- dbGetQuery(conn, "select * from iris")
>>> boxM(irisQuery [,-5], irisQuery[,5])
>>> ---------------------------------------------------------------
>>>
>>> (Actual case this posting is about)
>>> Yet, if I'm getting that same (sample...
2017 Oct 26
1
How to create a table structure in Java code?
...>> HTH,
>>> Jan
>>> On 25-10-17 12:50, Morkus via R-devel wrote:
>>>
>>>> Hi all,
>>>> Using RConsole, it's easy to get data from the database that you can use in an R Command. Like this:
>>>> (Reference case)
>>>> irisQuery <- dbGetQuery(conn, "select * from iris")
>>>> boxM(irisQuery [,-5], irisQuery[,5])
>>>>
>>>> (Actual case this posting is about)
>>>> Yet, if I'm getting that same (sample IRIS) data, say, in a web service possibly POSTED from a SQL...