Re: [R] Does SQL group by have a heavy duty equivalent in R

From: BBands <bbands_at_gmail.com>
Date: Mon 01 Jan 2007 - 18:41:02 GMT

On 12/30/06, Farrel Buchinsky <fjbuch@gmail.com> wrote:
> Instead I used RODBC
>
> sqlSave(channel,RawSeq)
> to push the table into a Microsoft Access database
> Then a sql query, courtesy of the Microsoft Access Query Wizard a la design
> mode.

If SQL does prove to be part of your approach you might want to have a look at SQLite. Dirk introduced it to me back when we worked on Crusher. We use it for development and some production work. Main attributes: simple, fast and light weight.

Everything you for R need here:
http://cran.r-project.org/src/contrib/Descriptions/RSQLite.html

SQLite's home page:
http://www.sqlite.org/

And a Python connector:
http://initd.org/tracker/pysqlite

    jab

-- 
John Bollinger, CFA, CMT
www.BollingerBands.com

If you advance far enough, you arrive at the beginning.

______________________________________________
R-help@stat.math.ethz.ch 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.
Received on Tue Jan 02 05:46:50 2007

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Tue 02 Jan 2007 - 02:30:28 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.