Message-ID: <CAP01uR=QJ=N1cMsKzRrz6X5Rj+6430jBwh7PjGGJ8pKAQKpSFA@mail.gmail.com>
Date: 2013-01-14T15:21:36Z
From: Gabor Grothendieck
Subject: sqldf package: using variables in where condition
In-Reply-To: <COL401-EAS380ACECC0C150CC89335548AE2E0@phx.gbl>
On Mon, Jan 14, 2013 at 8:36 AM, Ravi Sreedhar <ravishree51 at hotmail.com> wrote:
>
>
> Sent from my iPhone
>
> On Jan 13, 2013, at 9:47 PM, ravsre <ravishree51 at hotmail.com> wrote:
>
>> I am trying to use the sqldf package to create independent data frames from a
>> master dataframe.
>> I want to use sqldf package and perform a simple select statement. However,
>> what I want to do is to create a loop and repeatedly send a variable to the
>> where clause condition such as a: select * from mydfrm where Symbol =
>> list[i]
>> The 'list' is another data frame with a single column with 15 values. All I
>> what to do is to create loop for i in 1:15 and pass on into the select
>> statement as list[1], list[2 }..tile list[15]
>>
>> Can someone help since, I am unable to reference the element location as
>> variable in the sqldf function?
>>
See Example 5 on the sqldf home page.
http://code.google.com/p/sqldf/#Example_5._Insert_Variables
--
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com