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

From: affy snp <affysnp_at_gmail.com>
Date: Sun, 23 Dec 2007 16:28:40 -0500


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. Received on Sun 23 Dec 2007 - 21:35:01 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Mon 24 Dec 2007 - 09:30:20 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.