Splitting time and date

Answers

• Options

  Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 Unicorn

  July 2019

  There are a lot of options here.  One easy one is to copy the combined date/time attribute with Generate Copy, and then change it to nominal with Date to Nominal, and then change it back using Nominal to Date---and you can use that to set one version "Date" and the other version "Time" and it will display only the relevant parts.

  Brian T.
  Lindon Ventures 
  Data Science Consulting from Certified RapidMiner Experts

  2
• Options

  Luxtor Member Posts: 1 Contributor I

  April 2023

  Mind to be a little bit more specific please? I'm new to Rapidminer and don't really get your explanation. If I do it like that, what I'm able to do is basically separate both Date and time and get only one of them.. What if I just want to strip the month as a new feature? What would be the process? (checking options in parallel while asking here to optimize time)
  Thanks!

  0
• Options

  nn_here Member Posts: 31 Contributor I

  April 13

  Hi, Luxtor  Even i have the same requirement, to segregate the date column in to 3 different new columns. Can you tell me if you were able to find a way out for the same..
  
  Thanks and regards!
  

  0
• Options

  ceaperez Member Posts: 522 Unicorn

  April 16

  Hi @nn_here, 
  please find attached a sample process to extract date and time from an attribute. 
  
  Best, 
  
  Cesar

  Date_Time extract.rmp 6.2K

  0
• Options

  nn_here Member Posts: 31 Contributor I

  April 17

  Thankyou  for the help provided. Though I could get the months using -date_get([Date], DATE_UNIT_MONTH,"Asia/Kolkata") +1,glad for sharing a new method for the same purpose.
  Thanks and regards,
  nn_here

  0