Options

Date values conversion

RyanRezelRyanRezel Member Posts: 7 Newbie
Hi,
I am fairly new to RM and my first task has a column with inconsistent date values, it is entered as for example 0055 for the year whereas it should be 1955, I have tried a few options but have failed can anyone provide me with some assistance, please.

Thanks 
Ryan

Best Answer

Answers

  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,524 RM Data Scientist
    Hi,
    that's nasty, who came up with this notation?  What would be 0019? 1919 or 2019?
    In any case, i suspect you need to read it in as a Polynominal value and then parse the string. For example with Generate attributes.
    Best,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Options
    RyanRezelRyanRezel Member Posts: 7 Newbie
    Hi mschmitz 
    I assumed it was 1919 for example since in the statistics tab it shows that the latest date is May 7, 1992.
    Is hope such an assumption alright.
    Can you elaborate on how I can parse it, please?
    thank you 
    Ryan
  • Options
    RyanRezelRyanRezel Member Posts: 7 Newbie
    Thank you very much Martin.
Sign In or Register to comment.