group, restructure, graph..
aberbotimue
New Altair Community Member
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
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
Tagged:
0
Answers
-
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,
Marius0