[R] Data Manipulations and SQL

Gabor Grothendieck ggrothendieck at gmail.com
Tue Jul 15 00:31:41 CEST 2008


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 <wwei at dataquick.com> 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 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.
>



More information about the R-help mailing list