The sqldf R package can do that using SQL syntax. See:
http://sqldf.googlecode.com
The R merge command can do a join but not using SQL syntax.
See ?merge
On Mon, Jul 14, 2008 at 5:29 PM, Willa Wei <[EMAIL PROTECTED]> wrote:
>
> Greetings,
>
> I am new to R and have some background knowledge about SQL. I'd like to
> know whether there is a way to manipulate the R datasets (or data
> frames) using SQL statements. For example, I have two data frames and
> both of them have a column called "id", then I want to join this two
> data frames into one. In SQL, we can just simply use the join comment.
> What should we do in R? Is there any package that allows us to run SQL
> statements with R data?
>
> Thank you in advance for your help,
> Willa
>
> This message contains confidential information and is in...{{dropped:8}}
>
> ______________________________________________
> R-help@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.
>
______________________________________________
R-help@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.
