Re: [R] SQldf with sqlite and H2

2011-07-14 Thread Mandans
Thanks a lot Gabor. It helped a lot. Appreciate your time and effort. Thanks --- On Thu, 7/14/11, Gabor Grothendieck wrote: > From: Gabor Grothendieck > Subject: Re: [R] SQldf with sqlite and H2 > To: "Mandans" > Cc: r-help@r-project.org > Date: Thursday, July 14, 20

Re: [R] SQldf with sqlite and H2

2011-07-14 Thread Gabor Grothendieck
On Thu, Jul 14, 2011 at 10:33 AM, Mandans wrote: > SQldf with sqlite and H2 > > I have a large csv file (about 2GB) and wanted to import the file into R and > do some filtering and analysis. Came across sqldf ( a great idea and product) > and was trying to play around to see what would be the be

[R] SQldf with sqlite and H2

2011-07-14 Thread Mandans
SQldf with sqlite and H2 I have a large csv file (about 2GB) and wanted to import the file into R and do some filtering and analysis. Came across sqldf ( a great idea and product) and was trying to play around to see what would be the best method of doing this. csv file is comma delimited with