On Thu, Jul 26, 2012 at 3:59 AM, guruappa <gurua...@gmail.com> 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 | 38 > Rahul D | 31 > Rahul D | 53 > Ricky P | 7 > Ricky P | 45 > Ricky P | 27 > Ricky P | 17 > Ricky P | 86 > Ricky P | 48 > Jacques K | 23 > Jacques K | 86 > Jacques K | 32 > > I want the summary data as below: > > Name | Avg Score > Jacques K|47.00 > Rahul D|40.67 > Ricky P|38.33 > Sachin T|42.25 > > Currently, I am trying to pass the name of the person as an argument in a > sql query by breaking the query into parts, and then concatenating the query > string. Of course, the scheme is not working. > > I want a query as below: > SELECT NAME, SCORE FROM PLAYER_SCORE_TBL where NAME = ? > > Then I can pass the parameters like we do in PERL. > > If there is an alternative to the whole scheme, that would be wonderful. a > way that would just take the whole table, and provide pivot table like > solution.
Many, but I'll give one: with(DataFrameName, tapply(Score, Name, mean)) also aggregate(), ave(), and many others. Off topic: you might look at the sqldf package to do sql-form queries on R objects. Best, Michael > > Thanks in advance, > Guruppa Padsali. > > > > > -- > View this message in context: > http://r.789695.n4.nabble.com/Passing-arguments-to-SQL-Query-in-R-tp4637899.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
