Why does the Split operator not keep the values?

SylvainMSylvainM Member Posts: 18 Contributor II
Hello everyone,

As usual, I have quite a simple task to do but I haven't found an easy answer to it yet.


Let's say I have that Example Set:

Sale     

Clients      

Product

A

x

CCD

B

x ; y 

CCD

C

CS

D

CCD

E

x ; z 

DU

F

x ; y ; z

CS

G

y ; z

DU



And I want to split it to get that new Example Set: 

Sale    

Clients  

Product

A

x

CCD

B

CCD

B

y

CCD

C

CS

D

CCD

E

x

DU

E

z

DU

F

x

CS

F

y

CS

F

z

CS

G

y

DU

G

z

DU


What I thought first was: "Hey! You can do that! Let's do a Transpose, then a Split, and a Transpose again!" But this is what I get:

Sale     

Clients    

Product

?

y

?

?

z

?

?

y

?

?

z

?

?

z

?

A

x

CCD

B

x

CCD

C

y

CS

D

y

CCD

E

x

DU

F

x

CS

G

y

DU


Why did the Split operator not keep the values associated to the split examples? And what can I do to keep them?

I'm sorry if my question is obvious: I'm still exploring RapidMiner :smile:

Thanks a lot and best to all,
Sylvain

Best Answer

  • SylvainMSylvainM Posts: 18 Contributor II
    Solution Accepted
    Hello Ingo,

    Your solution works perfectly well! It is short and clear, as I like :wink:

    Thank you soooo much! I'm learning a lot with you help.

    Best,
    Sylvain

Answers

  • SylvainMSylvainM Member Posts: 18 Contributor II
    Update

    Hello everyone,

    After an hour of thought, I now understand why I got that result: Split gives an empty value if there is nothing to split; it doesn't copy the example.

    It does not solve my problem, however, which is to copy the example when there's nothing to split... Any advice on that point?

    Thanks a lot for your help :smile:
    Sylvain
    dbabrauskaite
  • IngoRMIngoRM Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University Professor Posts: 1,702  RM Founder
    Nice challenge :smiley: 
    The process below should do the trick.  I have used a combination of Split, De-Pivot, and Filter Examples.  The other two operators are simply used to make the result look nicer / exactly like your example above...
    Hope this helps,
    Ingo
    P.S.: If anybody finds a shorter solution pls let me know - I only spend 5 minutes on this but I somehow feel that there is something shorter out there...
    <?xml version="1.0" encoding="UTF-8"?><process version="9.3.000-BETA2">
    RapidMiner Wisdom 2020
    February 11th and 12th 2020 in Boston, MA, USA

    sgenzerdbabrauskaiteSylvainM
  • sgenzersgenzer 12Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,636  Community Manager
    @SylvainM pls mark as solution. Thank you! :smiley:
Sign In or Register to comment.