RapidMiner 9.7 is Now Available

Lots of amazing new improvements including true version control! Learn more about what's new here.

CLICK HERE TO DOWNLOAD

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,509  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.