group, restructure, graph..

aberbotimue

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
ect..

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

N

MariusHelf

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,
Marius