search for: dbappli

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,

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 frame. The list I want to convert looks like this

I'm having trouble getting RMySQL to load. I was able to build it and install it (RMySQL_0.5-11.tar.gz). I was also able to build and install mysql-5.0.37. I've read many postings about this but have not found a mention of my particular problem (some closely related). I get the "unable to load shared library, no such file" error, but all the files do exist, RMySQL.so and

I don't use MySQL but I have seen messages like this before. They often have replies which indicate that you need to follow the instructions more closely. I suggest you search the list for these previous posts as I'm sure there is help there, somewhere! Tom > -----Original Message----- > From: Adriano von Sydow [mailto:pdasilva at xtra.co.nz] > Sent: Thursday, 10 March 2005 5:13

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

Hello, I have trouble installing and loading the RMySQL package on OS X 2.8. The package seems to install from source fine (using R package manager from within the R environment). I have the following error when I try to load the package: loading package: RMySQL Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library

1. Is it always the case that when defining generic functions in a package, the package needs to be installed as a binary package to 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

Hi! I'm new to R, and I have a question about how R works with large data sets --- in particular, data sets that come from databases. I'm using R 2.2.0 with the DBI package (0.1-9) and the RMySQL package (0.5-5). My get-my-feet-wet-with-R project is to make a histogram from a data set stored in a MySQL database. In particular, I have a table that describes some observed spam emails.

Hi, I am having trouble getting RMySQL running on a solaris machine. [43] bedrock:/home/jayoung/source_codes/R/other_packages> uname -a SunOS bedrock 5.10 Generic_118833-36 sun4v sparc SUNW,Sun-Fire-T200 I thought I had finally managed to get it installed, albeit with some warnings that I didn't understand (it took me a while to find where our mysql libraries were), but when I tried

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

I am trying something I haven't attempted before and the available documentation doesn't quite answer my questions (at least in a way I can understand). My usual course of action would be to extract my data from my DB, do whatever manipulation is necessary, either manually or using a C++ program, and then import the data into R. Now I need to try to do it all within R+RMySQL+MySQL. I