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

BBands bbands at gmail.com
Mon Jan 1 19:41:02 CET 2007


On 12/30/06, Farrel Buchinsky <fjbuch at 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.



More information about the R-help mailing list