Hi,
I am using aggregate to compute means for later plotting.
There are two factors involved and the problem is that the values of the
second factor ( Age ) in the means are not in the right order because
10 comes inbetween 1 and 2
What I really want is the numeric value of Age but as.numeric
I have now read the README file which I should have done before. :-[
Sorry.
To summarize:
- Install the odbc connector driver (3.51)
- Set up the dsn in the file .odbc.ini
- It works beautifully and RODBC is super!
Prof Brian Ripley wrote:
yOn Mon, 28 May 2007, Bill Szkotnicki wrote
Hello,
I have installed R2.5.0 from sources ( x86_64 )
and added the package RODBC
and now I am trying to connect to a mysql database
In windows R after installing the 3.51 driver
and creating the dsn by specifying server, user, and password
it is easy to connect with
channel - odbcConnect(dsn)
Hello,
I am trying to insert a lot of data into a table using windows R (2.3.1)
and a mysql database via RODBC.
First I read a file with read.csv and then form sql insert statements
for each row and execute the insert query one row at a time. See the
loop below.
This turns out to be very slow.
sure the time is stored correctly in
mysql
names(dat)=c(time,v1,v2,v3,v4,v5,v6,v7,v8,v9,v10)
sqlSave(channel,dat,logger,rownames=F,append=T) # very fast.
#
Jerome Asselin wrote:
On Fri, 2006-10-13 at 09:09 -0400, Bill Szkotnicki wrote:
Hello,
I am trying to insert a lot of data
I have a model with a few correlated explanatory variables.
i.e.
m1=lm(y~x1+x2+x3+x4,protdata)
and I have used predict as follows:
x=data.frame(x=1:36)
yp=predict(m1,x,se.fit=T)
tprot=sum(yp$fit) # add up the predictions
tprot
tprot is the sum of the 36 predicted values and I would
way?
Bill
-Original Message-
From: Prof Brian Ripley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 02, 2006 2:54 PM
To: Christos Hatzis
Cc: 'Bill Szkotnicki'; 'R-Help help'
Subject: Re: [R] predict.lm
On Tue, 2 May 2006, Christos Hatzis wrote:
I think you got it right.
The mean
Hello,
Recently I have been reading a lot of material about statistical modeling
using R. There seems to be conflicting opinions about what the best approach
is between the SAS community and the R community.
1) In R one might start with a model that has all possible effects of
interest in it and