Re: [R] SQL like function?

2007-09-08 Thread Takatsugu Kobayashi
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

Re: [R] SQL like function?

2007-09-08 Thread 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,

Re: [R] SQL like function?

2007-09-07 Thread Gabor Grothendieck
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 -

Re: [R] SQL like function?

2007-09-07 Thread Moshe Olshansky
observation %in% ID --- Takatsugu Kobayashi [EMAIL PROTECTED] 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

Re: [R] SQL like function?

2007-09-06 Thread Benilton Carvalho
observation %in% ID b On Sep 7, 2007, at 1:40 AM, Takatsugu Kobayashi 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

Re: [R] SQL like function?

2007-09-06 Thread Takatsugu Kobayashi
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