Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

cross selling

Hai,
This is Priyan,

My .xls data looks like this
c- customer id and t- item id...

c1 t1
c1 t2
c1 t3
c1 t4
c1 t5
c2 t1
c2 t2
c3 t1
c4 t4
c5 t5
c6 t6

and i need to make it as this, using rapid miner.. ! Is any poss to do this

transaction_id t1 t2
c1 1 1
c2 1 1
c3 1 0
c4 0 1

Is any one knows it..
thanks

Find more posts tagged with

AI Studio

Accepted answers

All comments

land

Hi Priyan,
you could binarize the column with the items, convert the nominal trues into numerical 1s and then aggregate over the customer ids. Since the items seem to be different the trues should be disjoint and hence can simply be added.

Greetings,
Sebastian

earmijo

I was after the answer to this question too. Thanks Sebastian. Here's my not-so-elegant translation of your answer. My variables are called "tid" and "item". Of course, for a large number of items listing each variable in the aggregation operator is very tedious.

[tt]<operator name="Root" class="Process" expanded="yes">
<operator name="CSVExampleSource" class="CSVExampleSource">
<parameter key="filename" value="c:\list.csv"/>
</operator>
<operator name="AttributeSubsetPreprocessing" class="AttributeSubsetPreprocessing" expanded="yes">
<parameter key="attribute_name_regex" value="item"/>
<parameter key="condition_class" value="attribute_name_filter"/>
<operator name="Nominal2Binominal" class="Nominal2Binominal">
</operator>
<operator name="Nominal2Numerical" class="Nominal2Numerical">
</operator>
</operator>
<operator name="Aggregation" class="Aggregation">
<list key="aggregation_attributes">
<parameter key="item = i1" value="sum"/>
<parameter key="item = i2" value="sum"/>
<parameter key="item = i3" value="sum"/>
<parameter key="item = i4" value="sum"/>
<parameter key="item = i5" value="sum"/>
<parameter key="item = i6" value="sum"/>
</list>
<parameter key="group_by_attributes" value="tid"/>
</operator>
</operator>
[/tt]

land

Hi,
thats pretty correct and I didn't thought of this...Ok: Here is another way to do it

<operator name="Root" class="Process" expanded="yes">
    <operator name="NominalExampleSetGenerator" class="NominalExampleSetGenerator">
        <parameter key="number_of_attributes"	value="1"/>
    </operator>
    <operator name="ChangeAttributeRole" class="ChangeAttributeRole">
        <parameter key="name"	value="label"/>
    </operator>
    <operator name="Aggregation" class="Aggregation">
        <list key="aggregation_attributes">
          <parameter key="att1"	value="count"/>
        </list>
        <parameter key="group_by_attributes"	value="label|att1"/>
    </operator>
    <operator name="Example2AttributePivoting" class="Example2AttributePivoting">
        <parameter key="group_attribute"	value="label"/>
        <parameter key="index_attribute"	value="att1"/>
    </operator>
</operator>

Greetings,
Sebastian

svpriyan

Hai
Thanks for you all,
I have some doubts here,
I had a mistake initially to write the specif clearly.
cid, item both are numeric stage, - in this case , is it worth to use Nom to Binomial.
It seems diff to use the first answer because i have 1000 customers and 500 items. do any possibilities to modify this !
thanks again
Priyan

earmijo

Thanks again Sebastian. Your code is indeed elegant.

Svpriyan: If the id variable and the item variable are numeric just add a filter to convert them to nominal.

Here's the data (stored in the file list.csv):

tid item
1 1
1 2
1 3
2 1
2 4
3 5
3 4
3 6
4 1

Here's the final code as I'm implementing it to solve my question:

<operator name="Root" class="Process" expanded="yes">
    <operator name="CSVExampleSource" class="CSVExampleSource">
        <parameter key="filename"	value="c:\list.csv"/>
    </operator>
    <operator name="Numerical2Polynominal" class="Numerical2Polynominal">
    </operator>
    <operator name="Aggregation" class="Aggregation">
        <list key="aggregation_attributes">
          <parameter key="item"	value="count"/>
        </list>
        <parameter key="group_by_attributes"	value="tid|item"/>
    </operator>
    <operator name="Example2AttributePivoting" class="Example2AttributePivoting">
        <parameter key="group_attribute"	value="tid"/>
        <parameter key="index_attribute"	value="item"/>
    </operator>
</operator>