Re: [R] Data Manipulations and SQL

On Thu, Aug 26, 2010 at 1:18 PM, stephenb wrote: > is it possible to open a channel to a data frame in the default environment? > there are cases when using a sql update statement is the simplest > alternative, so instead of dumping the df and then updating and then > reimporting it I would like t

Re: [R] Data Manipulations and SQL

Greetings Gabor, is it possible to open a channel to a data frame in the default environment? there are cases when using a sql update statement is the simplest alternative, so instead of dumping the df and then updating and then reimporting it I would like to update the df directly in R. Thank y

Re: [R] Data Manipulations and SQL

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 abou

[R] Data Manipulations and SQL

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 fr