Displaying 1 result from an estimated 1 matches for "vitalanalysis".
Did you mean:
valanalysis
2003 Jul 15
1
dbApply (R newbee)
...MySQL. Present goal is that R should
calculate the 85% quantile of AvgSpeed for each LinieID. Looking through
documentation of the RMySQL Package, I guessed that dbApply would do the
trick due to this example
## compute quanitiles for each network agent
con <- dbConnect(MySQL(), group="vitalAnalysis")
res <- dbSendQuery(con,
"select Agent, ip_addr, DATA from pseudo_data order by Agent")
out <- dbApply(res, INDEX = "Agent",
FUN = function(x, grp) quantile(x$DATA, names=FALSE))
But when I try I get this:
> con = dbConnect(MySQL(),gr...