How to Import Data with Date Column YYYY-MM-DD (ISO 8601)

thomas_wiedmann

I try to Import some CSV Data into RapidMiner including some date column. I get ISO 8601 Date format YYYY-MM-DD.

https://en.wikipedia.org/wiki/ISO_8601

 

Now I will change imported data type from polynominal to date. I just get errors like.

 

1. Import RAW Data - polynominal

 

 

2. Change type to date looks like this "red error monster"

 

Data

EINGANG
2010-06-07
2011-03-02
2013-03-08
2015-03-02
2017-03-10
2011-01-03
2013-01-02
2015-02-02
2016-12-22
2011-08-09
2013-07-31
2015-07-27

How can I change this ISO_8601 Date standard format to rapidminer date?

 

Thanks!

Thomas

 

David_A

It seems that the import wizard can only handle date that match exactly the predefined formats in the drop-down menu.

In your case you only habe yyyy-MM-dd and not yyyy-MM-dd HH:mm:ss .

 

In this case, just use the Nominal to Date Operator and specify yyyy-MM-dd as date format.

 

Best,
David