similar to: Applying an R script to data within MySQL? How to?

I have R 2.10.1 and 2.9.1 installed, and both have RMySQL packages installed. I script I'd developed using an older version (2.8.?, I think) used RMySQL too and an older version of MySQL (5.0.?), and worked fine at that time (about a year and a half ago +/- a month or two). But now, when I run it again, on new data, the script works fine until it is supposed to store its results in my DB.

I have a number of files containing anywhere from a few dozen to a few thousand integers, one per record. The statement "refdata18 = read.csv("K:\\MerchantData\\RiskModel\\Capture.Week.18.csv", header = TRUE,na.strings="")" works fine, and if I type refdata18, I get the integers displayed, one value per record (along with a record number). However, when I try "

Warranty on Accuracy, Precision, Legality, ... of R in Research (These questions may well have been raised.) What is the implied warranty of using R for research & publications, consulting, etc.? Alternately, how does one obtain such a warranty? Your answers will be much appreciated. Perhaps you can point me to some websites which discussed this subject in the past. Thanks & regards

Can anyone explain such different output: > stableFit(s,alpha = 1.75, beta = 0, gamma = 1, delta = 0, + type = c("q", "mle"), doplot = TRUE, trace = FALSE, title = NULL, + description = NULL) Title: Stable Parameter Estimation Call: .qStableFit(x = x, doplot = doplot, title = title, description = description) Model: Student-t Distribution Estimated

My last query related to this referred to a problem with not being able to store data. A suggestion was made to try to convert the data returned by fitdist into a data.frame before using rbind. That failed, but provided the key to solving the problem (which was to create a data.frame using the variables fitdist produces in the object it returns). I now have almost everything working as

I must have missed something simple, but still, i don't know what. I obtained my basic data as follows: x <- sprintf("SELECT m_id,sale_date,YEAR(sale_date) AS sale_year,WEEK(sale_date) AS sale_week,return_type,0.0001 + DATEDIFF(return_date,sale_date) AS elapsed_time FROM `merchants2`.`risk_input` WHERE DATEDIFF(return_date,sale_date) IS NOT NULL") moreinfo <- dbGetQuery(con,

I found it easy to use R when typing data manually into it. Now I need to read data from a file, and I get the following errors: > refdata = > read.table("K:\\MerchantData\\RiskModel\\refund_distribution.csv", header > = TRUE) Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, : line 1 did not have 42 elements > refdata = >

Here is my little scriptlet: optdata = read.csv("K:\\MerchantData\\RiskModel\\AutomatedRiskModel\\soptions.dat", header = FALSE, na.strings="") attach(optdata) library(MASS) setwd("K:\\MerchantData\\RiskModel\\AutomatedRiskModel") for (i in 1:length(V4) ) { x = read.csv(as.character(V4[[i]]), header = FALSE, na.strings=""); y = x[,1]; fp =

Here is what I tried: optdata = read.csv("K:\\MerchantData\\RiskModel\\AutomatedRiskModel\\soptions.dat", header = FALSE, na.strings="") optdata attach(optdata) for (i in 1:length(V4) ) { x = read.csv(V4[[i]], header = FALSE, na.strings="");x } And here is the outcome (just a few of the 60 records successfully read): > optdata = >

Quick Overview: I have an ''Employee'', some ''Merchants'' and some ''Products''. A ''Merchant'' has many ''Products''. An ''Employee'' has multiple ''Merchants'', depending on their relationship. For example, the Employee may be the enrollment contact for one merchant and the

Couple questions to those who have the winbindd service up and running... I *think* winbindd is working now... I can browse the samba server through windows explorer and open directories. There is a little delay when I first connect... I assume this is winbind passing the authentication request to my NT servers and awaiting a response. The problem now is that I can't seem to write to the

Warning: This is only for those interested in R language minutiae A recent post on this list asked if there was a simple way to change the R language object: ex1 <- expression(x < a) ## just the part to the right of the <- assignment to the object expression( x < a & y < b) ## or something like this Phil Spector showed how to do this by essentially deparsing and reparsing

I've noticed with certain datasets that when I try to do an anova and test for main effects and interaction for two explanatory variables, sometimes the main effect results are given but not the interaction results. For example, ex1 = aov(Score ~ var1*var2, data=myData) summary(ex1) gives me only the main effects for var1 and var2, but not the interaction. I also tried ex1 = aov(Score ~

This was in regards to a problem with ms applications hanging on trying to open a file. Turns out it was an nfs locking issue. Hope this helps, Don -----Original Message----- From: Partenheimer Nate [mailto:npartenh@butler.edu] Sent: Monday, March 26, 2001 1:23 PM To: "MCCALLDON "@envelope.hp.com; HP-USA@envelope.hp.com; ex1 " Subject: RE: RE: Explorer & MS Office hang

Greetings, I sent the message below to the developer of the contributed R package "sspir", but have yet to receive any response. I would be very grateful for any advice people have on the matter. Thanks, Mark -------- Original Message -------- Subject: possible bug in sspir? Date: Tue, 19 May 2009 16:08:41 -0700 From: Mark Scheuerell <mark.scheuerell at noaa.gov> To:

When investigating the legend(x,y, expression ( <math>, <math> ), ....) [as suggested by Jim Lindsey], I once again stumbled over the fact that expression objects behave somewhat ``wierdly'', IMHO. We can have expressions of length(.) > 1, and access elements of these like list elements. However, other natural things don't work with expressions; some example

Earl F. Glynn asks: > -----Original Message----- > From: r-help-bounces at stat.math.ethz.ch [mailto:r-help-bounces at stat.math.ethz.ch] On Behalf Of Earl F. Glynn > Sent: Tuesday, 15 August 2006 8:44 AM > To: r-help at stat.math.ethz.ch > Subject: [R] Help with workaround for: Function '`[`' is not in thederivatives table > > # This works fine: > > a <- 1

-----Original Message----- From: MCCALL,DON (HP-USA,ex1) Sent: Wednesday, October 31, 2001 9:00 AM To: 'Richard Barker'; MCCALL,DON (HP-USA,ex1) Subject: RE: HP3000 problem Hi Richard; Are you doing the operations on these files from the MPE prompt, or are you in the posix shell at the time of the edit/pipe, whatever? And what MPE filetype are you working on? Problem is that samba

OK, I have managed to use some of the basic processes of getting data from my DB, passing it as a whole to something like fitdistr, &c. I know I can implement most of what I need using a brute force algorithm based on a series of nested loops. I also know I can handle some of this logic in a brute force method using a blend of perl and R, with considerable file IO. But some of what I need

Hi all, Unfortunately I must use winXP at my job, so I'm trying install from source RMySQL. Here are some details about this problem: - R 1.7.1 - RMySQL 0.5-2 - mysql 4.1.0-alpha-max-nt I followed the instructions posted in http://www.biostat.jhsph.edu/~kbroman/Rintro/Rwinpack.html and the following messages appeared. BTW, thanks in advance for your help and comments. C:\Program