R help - Dec 2010 - Querying a data frame or data.table

Hello Group,

Is there an easy way to query a data.frame or data.table (this is
fast!) for multiple conditions?
I don't want to use a SQL kind of statement.

I am looking for something like a subset with multiple conditions.

Any tips of the like the binary search methodology used for data.table
would also help.

Thanks in advance.
S

Sounds just like the subset function (?)

x <- as.data.frame(matrix(sample(5, 100, rep=TRUE), ncol=10))
subset(x, V1 > 3 & V2 < 5)

Michael

On 3 December 2010 19:05, Santosh Srinivas <santosh.srinivas at gmail.com>
wrote:
> Hello Group,
>
> Is there an easy way to query a data.frame or data.table (this is
> fast!) for multiple conditions?
> I don't want to use a SQL kind of statement.
>
> I am looking for something like a subset with multiple conditions.
>
> Any tips of the like the binary search methodology used for data.table
> would also help.
>
> Thanks in advance.
> S
>
> ______________________________________________
> 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.
>

mbedward wrote:
> 
> Sounds just like the subset function (?)
> ..
> 
> 
Or try sqldf if you feel at home in the SQL empire.

Dieter

-- 
View this message in context:
http://r.789695.n4.nabble.com/Querying-a-data-frame-or-data-table-tp3070750p3070926.html
Sent from the R help mailing list archive at Nabble.com.