Re: [R] Passing arguments to SQL Query in R

2012-07-26 Thread guruappa
> > library(reshape2) > dcast(mydata, Name ~ . , mean) > > library(plyr) > ddply(mydata, .(Name), summarize, Mean = mean(Score)) > > library(data.table) > DT <- data.table(mydata) > DT[, mean(Score),by=Name] > > John Kane > Kingston ON Canada &

Re: [R] Passing arguments to SQL Query in R

2012-07-26 Thread guruappa
Thanks a ton, much appreciated... On 26-Jul-2012, at 7:56 PM, Michael Weylandt [via R] wrote: > On Thu, Jul 26, 2012 at 3:59 AM, guruappa <[hidden email]> wrote: > > > Hello all, > > > > I am a newbie at R, with some experience in PERL. > > > > I have a database table that contains the follo

Re: [R] Passing arguments to SQL Query in R

2012-07-26 Thread John Kane
ata) DT[, mean(Score),by=Name] John Kane Kingston ON Canada > -Original Message- > From: gurua...@gmail.com > Sent: Thu, 26 Jul 2012 01:59:37 -0700 (PDT) > To: r-help@r-project.org > Subject: [R] Passing arguments to SQL Query in R > > Hello all, > > I am a

Re: [R] Passing arguments to SQL Query in R

2012-07-26 Thread R. Michael Weylandt
On Thu, Jul 26, 2012 at 3:59 AM, guruappa wrote: > Hello all, > > I am a newbie at R, with some experience in PERL. > > I have a database table that contains the following data: > Name | Score > === | = > Sachin T | 25 > Sachin T | 53 > Sachin T | 57 > Sachin T | 34 > Rahul D |

[R] Passing arguments to SQL Query in R

2012-07-26 Thread guruappa
Hello all, I am a newbie at R, with some experience in PERL. I have a database table that contains the following data: Name | Score === | = Sachin T | 25 Sachin T | 53 Sachin T | 57 Sachin T | 34 Rahul D | 38 Rahul D | 31 Rahul D | 53 Ricky P | 7 Ricky P | 45 Ricky P