See sqldf home page:
http://sqldf.googlecode.com
e.g.
library(sqldf)
set.seed(1)
pti <-rnorm(7,10)
fid <- rnorm(7,100)
finc <- rnorm(7,1000)
# set is a reserved word in SQL so use sset
sset <- data.frame(fid,pti,finc)
system.time(out <- sqldf("select fid, sum(pti) from sset group by
On Sat, Jul 12, 2008 at 7:44 AM, sj <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I am trying to do some fairly straightforward data summarization, i.e., the
> kind you would do with a pivot table in excel or by using SQL queires. I
> have a moderately sized data set of ~70,000 records and I am trying to
Hello,
Have you tried using the GUI Rattle from www.rattle.togaware.com . It
works pretty well for summarization.
Regards,
Ajay
www.decisionstats.com
On Sat, Jul 12, 2008 at 4:14 AM, sj <[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> I am trying to do some fairly straightforward data summarization, i
Hello,
I am trying to do some fairly straightforward data summarization, i.e., the
kind you would do with a pivot table in excel or by using SQL queires. I
have a moderately sized data set of ~70,000 records and I am trying to
compute some group averages and sum values within groups. the code exam
4 matches
Mail list logo
