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 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. > > > > ______________________________________________ > > [hidden email] 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. > > ______________________________________________ > [hidden email] 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. > > > If you reply to this email, your message will be added to the discussion > below: > http://r.789695.n4.nabble.com/Passing-arguments-to-SQL-Query-in-R-tp4637899p4637935.html > To unsubscribe from Passing arguments to SQL Query in R, click here. > NAML -- View this message in context: http://r.789695.n4.nabble.com/Passing-arguments-to-SQL-Query-in-R-tp4637899p4638056.html Sent from the R help mailing list archive at Nabble.com. [[alternative HTML version deleted]] ______________________________________________ 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.
