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

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

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

SQLite's home page:

And a Python connector:


John Bollinger, CFA, CMT

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

______________________________________________ mailing list
PLEASE do read the posting guide
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 Please read the posting guide before posting to the list.