Skip to content

Conditional Counting with Table

2 messages · Gundala Viswanath, Gustavo Carvalho

#
Dear all,

I have the following data frame:

V1     V2
aaa    chr1
aaa    chr2
aaa    NM
aaa    QC
aaa    chr10
att      NM
att      chr7

What I want to do is to count the string (V1).
But the condition of counting is: if the V2 of the string
is "NM" or "QC"  then the count is not increased.

Hence the contigency table will look like this:

#tag       count
aaa  3
att    1

Is there a compact way to achieve that in R?
I am thinking of using "table" but can't see
how to impose such condition into it.


- Gundala Viswanath
Jakarta - Indonesia
#
Hello,

Something like this should work:

table(test$V1[!test$V2 %in% c("NM","QC")])

Cheers,

Gustavo.
On Wed, Dec 24, 2008 at 3:06 AM, Gundala Viswanath <gundalav at gmail.com> wrote: