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@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.

Reply via email to