[R] Obtaining OLAP cubes using R

Saravanan saravanan.thirumuruganathan at gmail.com
Tue Jun 14 14:59:50 CEST 2011


Hello All,

I have a dataset and I wish to obtain all possible data cuboids from it 
using R . For eg if my data frame is :

A    B    C
1    1    1
1    2    1
2    2    1

The output intended is :
A=1
A=2
B=1
B=2
C=1
A=1,B=1
A=1,B=2
A=2,B=2
A=1,C=1
A=2,C=1
B=1,C=1
B=2,C=1
A=1,B=1,C=1
A=1,B=2,C=1
A=2,B=2,C=1

Are there any function(s) to do this in R ? I tried a combination of 
expand.grid and combn but the resulting code was very ugly and needed 
lot of hacks to make it work. I also tried to check the code for arules 
(which constructs similar "itemsets") but unfortunately its code is in C 
and I am not very familiar in writing R extensions. Any pointers to 
functions will be much appreciated.

Regards,
Saravanan



More information about the R-help mailing list