Skip to content
Back to formatted view

Raw Message

Message-ID: <4DF75B46.4040903@gmail.com>
Date: 2011-06-14T12:59:50Z
From: Saravanan
Subject: Obtaining OLAP cubes using R

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