Re: [R] Data Manipulations and SQL

From: Gabor Grothendieck <ggrothendieck_at_gmail.com>
Date: Mon, 14 Jul 2008 18:31:41 -0400

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.
>



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. Received on Mon 14 Jul 2008 - 22:35:28 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Mon 14 Jul 2008 - 23:31:41 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive