[R] Nested select

[jim holtman]

try this:

> lines<-"lo ptcl5 ptcl99 variable
+  430        .             8787        a
+ 430       342        2343         m
+  430        .             89            mr
+ 431        456        4774        a
+ 431         299       2777        m
+  431        99            96          mr
+  432        333         3433       a
+  432         .            7377        m
+  432        .             676          mr
+  "
> DF <- read.table(textConnection(lines), header=TRUE)
>
> closeAllConnections()
> subset(DF, (ptcl5 == '.') & (variable %in% c('a', 'm')))
   lo ptcl5 ptcl99 variable
1 430     .   8787        a
8 432     .   7377        m
>
>


On Fri, Sep 25, 2009 at 4:42 AM, premmad <mtechprem at gmail.com> wrote:
>
> my data :
>
> library(doBy)
>
> lines<-"lo ptcl5 ptcl99 variable
>  430        .             8787        a
> 430       342        2343         m
>  430        .             89            mr
> 431        456        4774        a
> 431         299       2777        m
>  431        99            96          mr
>  432        333         3433       a
>  432         .            7377        m
>  432        .             676          mr
>  "
> DF <- read.table(con<- textConnection(Lines), skip = 1)
>
> close(con)
>
> what i want is select lo when ptcl5 is missing and variable is either a or m
> .
> I tried the following query
> sqldf("select lo from DF where lo=(select lo where ptcl5='.' and
> variable='m') or lo=(select lo where ptcl5='.' and variable='a')").
> But I'm getting entire data instead of limited by the condition.
> Is my query right please help me in this.
> --
> View this message in context: http://www.nabble.com/Nested-select-tp25608506p25608506.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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.
>



-- 
Jim Holtman
Cincinnati, OH
+1 513 646 9390

What is the problem that you are trying to solve?