The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

Time value implementation and processing in RapidMiner

TahminatorTahminator Member Posts: 2 Contributor I
edited November 2018 in Help
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.

Answers

  • IngoRMIngoRM Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University Professor Posts: 1,751 RM Founder
    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
  • TahminatorTahminator Member Posts: 2 Contributor I
    Hello Ingo,

    your comments helped a lot and I managed to implement it, thank you very much..  ;)

    erdal.
Sign In or Register to comment.