Time value implementation and processing in RapidMiner

Tahminator

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.

IngoRM

Hello,

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