[R] How to remove some rows from a data.frame

[Moshe Olshansky]

To answer your firs question try

M[-which( M$s1 == 0 & M$s2 == 0),]

For the second question, you must start with the more
precise definition of the grouping criterion.

--- affy snp <affysnp at gmail.com> wrote:

> Hello list,
> 
> I have a data frame M like:
> 
> BAC                 chr    pos          s1   s2
> RP11-80G24    1    77465510    -1    0
> RP11-198H14    1    78696291    -1    0
> RP11-267M21    1    79681704    -1    0
> RP11-89A19      1    80950808    -1    0
> RP11-6B16        1    82255496    -1    0
> RP11-210E16    1    228801510    0    -1
> RP11-155C15    1    230957584    0    -1
> RP11-210F8      1    237932418    0    -1
> RP11-263L17     2    65724492    0    1
> RP11-340F16     2    65879898    0    1
> RP11-68A1        2    67718674    0    0
> RP11-474G23    2    68318411    0    0
> RP11-218N6      2    68454651    0    0
> CTD-2003M22    2    68567494    0    0
> .....
> 
> how to remove those rows which have 0 for both of
> columns s1,s2?
> sth like M[!M$21=0&!M$s2=0]?
> 
> Moreover, I want to get a list which could find a
> subset of rows which have
> the same pattern of data. For example, the first 8
> rows in M can be
> clustered
> into 2 groups (represented below in 2 rows) and
> shown as:
> 
> chr             Start       End             # of
> rows     Pattern
> 1             77465510   82255496       5           
>   (-1 0)
> 1            228801510  237932418     3             
> (0 -1)
> 
> Can anybody help me out of this? Thank you very much
> and happy holiday!
> 
> Best,
>     Allen
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> 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.
>