Data transformation help needed: mv long to effect coded mv wide

stereotaxonstereotaxon Member Posts: 10 Contributor II
edited November 2018 in Help
Hello,

I need help with a data transformation in RapidMiner or SQL, or something along these lines.
My data are in a DB, are categorical, and are in multivariate long format.  I need help converting them to
multivariate wide format and then effect coding the categories.

data::
sub1 q1.1  "subject1 responded 1 on q1, which has three choices"
sub1 q2.2  "subject1 responded 2 on q2, which has three choices"
sub2 q1.3  "subject2 responded 3 on q1, which has three choices"
.   "subject2 did not respond to q2"


Intermediary step (may not be necessary)
subject q1 q2
sub1 1 2
sub2 3      .


desired effect coded wide format data:
sub q1.1 q1.2 q1.3 q2.1 q2.2 q2.3
sub1 1 0 0 0 1 0
sub2 0 0 1 0 0 0

Thanks for your help!
-Mike

Answers

  • landland RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 2,531 Unicorn
    Hi,
    I don't know any quick solution doing this. But you could write your own operator to do this, that's the way I would do it.

    Greetings,
      Sebastian
  • TobiasMalbrechtTobiasMalbrecht Moderator, Employee, Member Posts: 294 RM Product Management
    Hi,

    well there is indeed an operator to convert a long to a wide data set. It is called [tt]Example2AttributePivoting[/tt]. Unfortunately I do not fully understand the description of your data and hence do not know if the operator alone is sufficient. But maybe you can try yourself ...

    Regards,
    Tobias
  • stereotaxonstereotaxon Member Posts: 10 Contributor II
    Hi,

    `Example2AttributePivoting` is just what I need...I hope this isn't too banal a question, but where do I find the operator?  I'm using the community edition v4.2 and I can't see it in the GUI; I tried searching in the New Operator [filter] box but nothing relevant was found.

    Thanks!
  • TobiasMalbrechtTobiasMalbrecht Moderator, Employee, Member Posts: 294 RM Product Management
    Hi,

    I forget to mention, that it was only added recently and therefore is yet only part of the developer version of RM. This version will be published soon. That means, you either have to wait a few weeks and just download the newly published RM 4.3 then or you can check out the current developer version via CVS (check out the branch Zaniah).

    Regards,
    Tobias
Sign In or Register to comment.