How to apply a "grid" (Discretize) to a continuous attribute?
I hope that someone can help me with a problem, which came up to me. The situation is the following:
I have an example set which contains time and values, ID. Now the problem is, that the difference between the different moments in time is not the same. But to compare different ID's it somehow must be possible do discretize the values to a specific period (e.g. every 15 minutes), so that I can create a stepchart. To make it more cleary here an example:
ID Time Values
1 15:12 5
1 15:30 7
1 15:35 8
2 15:15 1
2 15:35 4
What I want to achieve is that the values correspond with specific moments in time. For example every 15 Minutes.
Time Value 1 Value 2
15:15 5 1
15:30 7 1
15:45 8 4
If there is no change in a value compared to the moment before, rapidminer should take the last known value.
I really don't know how to realize that and I hope you understand which problem I have.
Thank you for your help :-)