Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Date Formatting ISO 8601 Question

  1. #1
    Join Date
    Oct 2013
    Posts
    5

    Default Date Formatting ISO 8601 Question

    Hello,

    I am converting a date and time attribute into one in excel. Here is an example of what it looks like in a single cell...

    2016-10-25T19:30:00

    After converting the excel file to CSV and then converting to ARFF, the attribute is still not recognized as a date, but rather a nominal attribute.

    What needs to be done in order for WEKA to recognize it as a date?

    Thank you.

  2. #2
    Join Date
    Oct 2013
    Posts
    5

    Default

    Update: From searching around online, I have seen that the information I've gained has been to download the version 3.8.1.

    As you are opening the arff file in the explorer, i believe you are to check Invoke options dialog.

    After that I am unsure of what to do in order for it to understand the "time attribute" laid out like this - 2016-10-25T19:30:00

    Any help to overcome this is greatly appreciated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.