On May 3, 2014, at 9:10 PM, Satish Anupindi Rao wrote: > > " By making the effort to learn R?"? very constructive and not condescending > at all. We, lesser beings, are indebted to you, sir.
For Pete's sake. The OP didn't even express his original request in natural language or offer a working example. Those of us who are not regular SQL users would have needed to parse out the SQL code in order to figure out what was intended. (My guess is that it would have been quite easy to solve if those were what were offered.) But making the effort to divine the intent didn't seem justified by the level of courtesy offered by the questioner. -- David. > > -----Original Message----- > From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On > Behalf Of Bert Gunter > Sent: Saturday, May 03, 2014 1:12 AM > To: Dr Eberhard Lisse > Cc: r > Subject: Re: [R] SQL vs R > > By making the effort to learn R? > > See e.g. the "Introduction to R" tutorial that ships with R. > > -- Bert > > Bert Gunter > Genentech Nonclinical Biostatistics > (650) 467-7374 > > "Data is not information. Information is not knowledge. And knowledge is > certainly not wisdom." > H. Gilbert Welch > > > > > On Fri, May 2, 2014 at 2:23 PM, Dr Eberhard Lisse <nos...@lisse.na> wrote: >> Hi, >> >> How do I do something like this without using sqldf? >> >> a <- sqldf("SELECT COUNT(*) FROM b WHERE c = 'd'") >> >> or >> >> e <- sqldf("SELECT f, COUNT(*) FROM b GROUP BY f ORDER BY f") >> >> greetings, el >> >> ______________________________________________ >> 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. > > ______________________________________________ > 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. David Winsemius Alameda, CA, USA ______________________________________________ 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.
