Options
Time value implementation and processing in RapidMiner
Tahminator
Member Posts: 2 
Contributor I
Hello to all,
I am wondering whether there is a way to do the following in RM or not, and if possible how also;;
Suppose you had a measured time value like 01:34:28 for an event, which means event lasts for 1 minute 34 seconds and 28 milliseconds. These vlues are stored in an excel file.
Then, how to tell RM that this is a time value and it lasts 1 minute 34 seconds and 28 milliseconds ? And use this "numerical" value as a label in a learner, say NeuralNet or EvoSVM ?
Any help will be highly appreciated,
erdal.
I am wondering whether there is a way to do the following in RM or not, and if possible how also;;
Suppose you had a measured time value like 01:34:28 for an event, which means event lasts for 1 minute 34 seconds and 28 milliseconds. These vlues are stored in an excel file.
Then, how to tell RM that this is a time value and it lasts 1 minute 34 seconds and 28 milliseconds ? And use this "numerical" value as a label in a learner, say NeuralNet or EvoSVM ?
Any help will be highly appreciated,
erdal.
0
Answers
first, you should read (or transform) the column containing the durations as a nominal column - which will be automatically the case for most time format. Then, you can use the operator "Nominal2Date" for transforming those nominal values into real date / time attributes (have a look into the documentation or tooltip for a description of the format strings). Afterwards, you can use the operator "Date2Numerical" for extraction time units like seconds etc. from those date values.
Cheers,
Ingo
your comments helped a lot and I managed to implement it, thank you very much..
erdal.