search for: linieid

I am trying to use R interfaced with 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, DA...

...8", "99987", "99989", "9999", "99993", "99995")) what I get when I use as.data.frame(fraktil) is as said X10000 X100003 X100004 123.85 59.7 61,5 I have tried this fraktil.df <- data.frame(LinieID=names(fraktil),"quantile_85"=unlist(fraktil)) but when I do this R shutsdown with no warning( R 1071, on a winXP system) the same happens when I try write.table or dbWriteTable(con, "fraktil", fraktil) What I would like to end up with is a table like this LinieID quantile_85 1...