The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.

group, restructure, graph..

aberbotimueaberbotimue Member Posts: 5 Contributor II
edited November 2018 in Help
im sure this is easy to do, but i just cant figure it..

i have a data set, of each company, and for every day, their number of uses

abc, day1, 23
abc, day2, 20
abc, day3, 15
abc, day4, 10
zyx, day1, 20
zyx, day2 19
zyx, day3 20
zyx, day4 15
mno, day1, 27
mno, day2, 23

i am trying to get it to look somthing more like this, so i can graph it better..  unless i can get the plots to work on this data set..

            day1          day2            day3            day4
abc      23              20              15              10
mno      27              23                18              20
zyx      20              19                20              15

any thoughts or pointing me in gthe right direction would be great



  • Options
    MariusHelfMariusHelf RapidMiner Certified Expert, Member Posts: 1,869 Unicorn
    This operation is called pivot, and RapidMiner features an equally named operator.

    In its parameters, for each value of the group attribute one line will be created, for each value of the index attribute a column. So in your case the first column must be group, the second index attribute.

    Best regards,
Sign In or Register to comment.