R is not for Relational, but could be... I was musing on data.frames when I decided what I needed was a SQL like 'select' statement. Before I get involved in writing something like that, has anyone else written anything that allows a relational like algebra on data.frames? Thanks, John Carter EMail: ece at dwaf-hri.pwv.gov.za Telephone : 27-12-808-0374x194 Fax:- 27-12-808-0338 <http://www.geocities.com/SoHo/Cafe/5947> or <http://iwqs.pwv.gov.za> When I grow up, I'm going to be a range of mountains! -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
John Carter <john at dwaf-hri.pwv.gov.za> writes:> R is not for Relational, but could be... > > I was musing on data.frames when I decided what I needed was a SQL > like 'select' statement. > > Before I get involved in writing something like that, has anyone else > written anything that allows a relational like algebra on data.frames?Check if subset() does something in the right direction. What would the select statement do, precisely? (I don't speak SQL) -- O__ ---- Peter Dalgaard Blegdamsvej 3 c/ /'_ --- Dept. of Biostatistics 2200 Cph. N (*) \(*) -- University of Copenhagen Denmark Ph: (+45) 35327918 ~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk) FAX: (+45) 35327907 -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
On Tue, 3 Aug 1999, John Carter wrote:> R is not for Relational, but could be... > > I was musing on data.frames when I decided what I needed was a SQL > like 'select' statement. > > Before I get involved in writing something like that, has anyone else > written anything that allows a relational like algebra on data.frames? > > Thanks, >I contributed Rmsql (which is available at CRAN -> packages). It implements a (very) basic interface between R and the msql database. Torsten> John Carter EMail: ece at dwaf-hri.pwv.gov.za > Telephone : 27-12-808-0374x194 Fax:- 27-12-808-0338 > <http://www.geocities.com/SoHo/Cafe/5947> or <http://iwqs.pwv.gov.za> > > When I grow up, I'm going to be a range of mountains! > > -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- > r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html > Send "info", "help", or "[un]subscribe" > (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch > _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._ >-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._