Re: Unparseable date error

> I´ve been looking everywhere on the net but I do not find the error...
>
> I have some weather station data in CSV that I try to use in weka but when I try to load the file in the explorer I get that "unparsable date" error but it is not on line 1 but in 213267 (02:00 hrs) but its format is not different for the previous lines! -which do not cause error-
>
> 2016-04-03 01:50,17,17.1,16.9,43,4.3,0,---,0,0,--
> 2016-04-03 02:00,16.8,16.9,16.8,44,4.5,0,---,0,0,--
> 2016-04-03 02:10,16.7,16.8,16.7,45,4.7,0,---,0,0,--
> 2016-04-03 02:20,16.6,16.7,16.6,46,4.9,0,---,0,0,---
>
>
> I opened the file with invoke options dialog, in dateFormat used:
>
> yyyy-MM-dd HH:mm
>
> In dateAttributes I just put 1 since is the first one

Does this also happen for other times between 02:00 and 03:00 on that
day? If yes, is that maybe due to a daylight savings problem, as in
the clock moved forward from 2 to 3, so these times are not actually
valid?

With my NZ locale, I can load the attached dataset.

Cheers, Peter
-- 
Peter Reutemann
Dept. of Computer Science
University of Waikato, NZ
+64 (7) 858-5174 (office)
+64 (7) 577-5304 (home office)
http://www.cms.waikato.ac.nz/~fracpete/
http://www.data-mining.co.nz/

_______________________________________________
Wekalist mailing list -- [email protected]
Send posts to [email protected]
To unsubscribe send an email to [email protected]
To subscribe, unsubscribe, etc., visit https://list.waikato.ac.nz/postorius/lists/wekalist.list.waikato.ac.nz
List etiquette: http://www.cs.waikato.ac.nz/~ml/weka/mailinglist_etiquette.html

timestamp,2,3,4,5,6,7,8,9,10,11
2016-04-03 01:50,17,17.1,16.9,43,4.3,0,---,0,0,--
2016-04-03 02:00,16.8,16.9,16.8,44,4.5,0,---,0,0,--
2016-04-03 02:10,16.7,16.8,16.7,45,4.7,0,---,0,0,--
2016-04-03 02:20,16.6,16.7,16.6,46,4.9,0,---,0,0,---