How to partially flatten or rotate examples?

caryknoopcaryknoop Member Posts: 4 Contributor I
edited November 2018 in Help

This is probably easy but I just can't find a way on how to do this in RapidMiner.

 

Here is an example of what I am trying to do, let's say we have the following data:

 

City        Type         Count

----------------------------------------

City 1     People     10000

City 1     Cars              500

City 2     People       8000

City 3     Dogs               20  

I would want to flatten that into:

 

City        People         Cars    Dogs

-----------------------------------------------

City 1      10000         500            ?

City 2          800              ?            ?

City 3               ?              ?           20

 

 

Tagged:

Answers

  • mschmitzmschmitz Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 2,111  RM Data Scientist

    Dear Caryknoop,

     

    Pivot is what you search for. Take city as ID and Type as Index attribute.

     

    ~Martin

    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
    caryknoop
Sign In or Register to comment.