search for: dbapply

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, DATA from pseudo_data order by Agent") out <- dbApply(res, INDEX = &quo...

Hallo again I now succeeded in using dbApply on my data and I can convert it into a data.frame. But as Peter Dalgaard pointed out I his answer to my earlier question (Re: [R] list to data frame, 17.07.2003) I get one row and 10000 columns instead of what I want two columns and 10000 rows when I convert the list that dbApply returns to a Data...

...olumnInfo" [1] "dbGetRowsAffected" [1] "dbGetRowCount" [1] "dbHasCompleted" [1] "dbGetException" [1] "summary" [1] "dbDataType" [1] "make.db.names" [1] "SQLKeywords" [1] "isSQLKeyword" [1] "dbApply" [1] "dbApply" ** help >>> Building/Updating help pages for package 'RMySQL' Formats: text html latex example MySQL text html latex example MySQLConnection-class text html latex example MySQLD...

...Affected" > [1] "dbGetRowCount" > [1] "dbHasCompleted" > [1] "dbGetException" > [1] "summary" > [1] "dbDataType" > [1] "make.db.names" > [1] "SQLKeywords" > [1] "isSQLKeyword" > [1] "dbApply" > [1] "dbApply" > > ** help > >>> Building/Updating help pages for package 'RMySQL' > Formats: text html latex example > MySQL text html latex example > MySQLConnection-class text htm...

In the example in the documentation, I see: rs <- dbSendQuery(con, "select Agent, ip_addr, DATA from pseudo_data order by Agent") out <- dbApply(rs, INDEX = "Agent", FUN = function(x, grp) quantile(x$DATA, names=FALSE)) Maybe I am a bit thick, but it took me a while, and a kind hint from Phil, to figure much of this out. It is clear that the SQL orders the data by "Agent", and the INDEX parameter tells dbApply...

..."dbColumnInfo" [1] "dbGetRowsAffected" [1] "dbGetRowCount" [1] "dbHasCompleted" [1] "dbGetException" [1] "summary" [1] "dbDataType" [1] "make.db.names" [1] "SQLKeywords" [1] "isSQLKeyword" [1] "dbApply" [1] "dbApply" ** help >>> Building/Updating help pages for package 'RMySQL' Formats: text html latex example MySQL text html latex example MySQLConnection-class text html latex example MySQLDr...

...avoid having the generic functions in the .GlobalEnv? 2. Defining a generic function in a "non-binary" package triggers a check warning $ R CMD check ... ... * checking for code/documentation mismatches ... WARNING Objects with usage in documentation object 'dbApply' but missing from code: [1] "dbApply" It seems that the generic function dbApply lives in the .GlobalEnv when the package is attached (w. library), but not in the package's environment. I presume that's why check triggers the warning. Is this the case? *If*...

...of spam!), so I presume that I cannot (or at least, shouldn't) read it all at once. Reading the documentation of the RMySQL package, I understand that the syntax I want is something like this: ----- rs <- dbSendQuery(con, "select unixtime from email order by unixtime") out <- dbApply(rs, INDEX = "unixtime", FUN = function(x, grp) hist(x$unixtime, ...)) ----- But I can't quite seem to make this work. When I try the above directly, I get errors like this: Error in mysqlDBApply(res, ...) : unimplemented type 'NULL' in 'length<-' More...

...l latex example MySQLObject-class text html latex example MySQLResult-class text html latex example RMySQL-package text html latex example S4R text html latex example dbApply-methods text html latex example dbApply text html latex example dbBuildTableDefinition text html latex dbCallProc-methods text html latex dbCommit-methods text html l...

Hello, I've uploaded version 0.5-11 of RMySQL into CRAN, and it should be available soon. >From the NEWS file: Version 0.5-11 * Fixed a bug that would crash R with a failed mysql_real_connect(). * dbApply() is now working again (but still experimentally). * Re-formatted the C code. [0.5-9 through 0.5-10 were maintanance releases that Seth Falcon kindly put out.] Regards, -- David _______________________________________________ R-packages mailing list R-packages at stat.math.ethz.ch https://stat...

...he year, and then I manually separate weeks in a CSV file outside the DB. Suppose I make a query like: SELECT ndays FROM xxxxxxx GROUP BY WEEK(tdate); There is no a priori of knowing just how many weeks of data there are. My reason for asking is I see information in the documentation about "dbApply(RMySQL)" which says: "Applies R functions to groups of remote DBMS rows without bringing an entire result set all at once. The result set is expected to be sorted by the grouping field." There is an example, but the example doesn't make much sense (the query used, for example, d...