[R] SQL like function?

[Gabor Grothendieck]

Great.  Regarding the web, note that there are actually quite a few R
web projects as well:

http://www.lmbe.seu.edu.cn/CRAN/doc/FAQ/R-FAQ.html#R-Web-Interfaces

I have used rpad (www.rpad.org) which has an integrated web server right
in the R package making setup a non-issue.

On 9/8/07, Takatsugu Kobayashi <tkobayas at indiana.edu> wrote:
> Hi Gabor,
>
> Wow, this is awesome.... although I eventually should learn MySQL for
> integrating it on web-based DB management using PHP or Perl, this is a
> very helpful tool for me to start with!
>
> Thank you very much!!!!
>
> Gabor Grothendieck wrote:
> > Others have already pointed out %in% but regarding your comment about
> > SQL, you can use SQL to manipulate R data frames using the sqldf package
> > which provides an interface to lower level RSQLite (and RMySQL in the future)
> > routines.  The following examples use SQLite underneath:
> >
> > DF <- data.frame(observation = c(1,2,3,4,5))
> > ID <- data.frame(ID = c(1, 3, 4))
> >
> > library(sqldf)
> > sqldf("select observation, observation in (select * from ID) `ID?` from DF")
> >
> > # or
> >
> > sqldf("select observation, observation in (1, 3, 4) `ID?` from DF")
> >
> > See home page at:
> >
> > http://sqldf.googlecode.com
> >
> >
> > On 9/7/07, Takatsugu Kobayashi <tkobayas at indiana.edu> wrote:
> >
> >> Hi RUsers,
> >>
> >> I am wonder if I can search observations whose IDs matches any of the
> >> values in another vector, such as in MySQL. While I am learing MySQL for
> >> future database management, I appreciate if anyone could give me a hint.
> >>
> >> Suppose I have one 5*1 vector containing observation IDs and
> >> frequencies, and one 3*1 vector containing observation IDs.
> >>
> >> observation<-c(1,2,3,4,5)
> >> ID<-c(1,3,4)
> >>
> >> Then, I would like to program a code that returns a results showing
> >> matched observations like
> >>
> >> result: TRUE FALSE TRUE TRUE FALSE
> >>
> >> I am reading S programming, but I cannot find a way to do this.
> >>
> >> Thank you very much.
> >>
> >> Taka
> >>
> >> ______________________________________________
> >> R-help at stat.math.ethz.ch 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.
> >>
> >>
>
>