[R] Using factors to analyze table by quantiles
Alexander Predeus
predeus at gmail.com
Sun Nov 16 08:53:28 CET 2014
Hello all,
I've been trying to do the following analysis. I have a table (T1) that
defines sizes of my datasets (~80k rows):
size
X1 1000
X2 8323
X3 58
And then I have a table (T2) of ~ 5 million significant overlaps between
datasets:
X234 X443
X323 X1
X998 X12
What I want to do, is split table T1 into 10 quantiles by "size", which I
seem to successfully achieve using these commands:
qq <- factor(cut(T1$size,quantile(T1$size,
probs=seq(0.0,1.0,by=0.1)),include.lowest = TRUE),labels = LETTERS[1:10])
table(qq)
A B C D E F G H I J
8204 7643 7941 7878 7867 7773 7913 7856 7894 7869
Now I need to count how many of all 100 possible combinations
(AA,AB,AC,etc) are present in table T2 using these factors.
How can I do that? Thank you in advance,
-- Alex
[[alternative HTML version deleted]]
More information about the R-help
mailing list