importing multiple date or time attributes with different formats

GreySpikeGreySpike Member Posts: 2 Contributor I
edited November 2018 in Help

Hi,

 

I'm just starting with RapidMiner and really struggling with importing a csv file with multiple date and time columns.

 

RM does not seem to identify any of the columns correctly, and the wizard is stalling because I have a UTF-16 input file (is that a bug?).

 

I have externally converted to UTF-8 so at least the wizard is showing something other than Chinese script, but I can't find a way to set the date format differently on each attribute.

 

Stripped down example

RUNTIME,START DATE,START TIME,START TIMESTAMP
00:01:59,20160301,210042,20160301210042.1

 

HH:mm:ss,yyyyMMdd,HHmmss,yyyyMMddHHmmss.SSS

time, date, time, date-time

 

I'm aware that I don't need both the timestamp and the start date and start time, but at the moment I'm trying to learn how to make RM work.

 

Thanks for any suggestions.

Answers

  • mschmitzmschmitz Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 2,127  RM Data Scientist

    Hi,

     

    you can read this all in as polynominal and then use various Nominal to Date operators to parse your dates individually.

     

    ~Martin

    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.