Querying RData Files, SQL style?
My understanding is that sqldf works in conjunction with the sqlite and H2 DBMSs. You should be able to verify that from the sqldf home page; if I'm wrong, Gabor will quickly correct me :) Dennis On Fri, Jul 15, 2011 at 11:51 AM, Bhushan, Vipul
<vipul.bhushan at geodecapital.com> wrote:
Thanks very much for your response. This sqldf package looks promising. I just need to figure out if a dbms needs to be running/installed in our environment (to hold the temporary SQLite DB it creates). The examples in the documentation are helpful too. -----Original Message----- From: Dennis Murphy [mailto:djmuser at gmail.com] Sent: Friday, July 15, 2011 2:10 PM To: Bhushan, Vipul Cc: r-help at r-project.org Subject: Re: [R] Querying RData Files, SQL style? Hi: If you load the data into R, there is a package called sqldf that allows one to apply SQL syntax to an R data frame. Is that what you had in mind? If so, Google 'sqldf R' and you should get a pointer to its home page. HTH, Dennis On Fri, Jul 15, 2011 at 7:29 AM, Bhushan, Vipul <vipul.bhushan at geodecapital.com> wrote:
Hello. Is there a package or functionality available somewhere which will allow for complex searches (such as what SQL can do) of collections of RData files? Search capability within a given RData file at a time (which could be put in a loop) would be good, but the capability to perform joins to data across multiple RData files would be great. These queries might be ad-hoc, so writing an R program to get(load(...)) each file and customize the search in home-grown R code isn't feasible. This shouldn't be dependent on environment details, but just in case: I'm running version 2.13.0 in a Unix environment (but could easily run in Windows too). Thanks very much. ? ? ? ?[[alternative HTML version deleted]]
______________________________________________ R-help at 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.