🎉 🎉 RAPIDMINER 9.10 IS OUT!!! 🎉🎉
Download the latest version helping analytics teams accelerate time-to-value for streaming and IIOT use cases.
"Data import from Excel - date time conversion hell"
Example: In Excel I have 14.07.2007 23:59 (formatted as dd.mm.yyyy h:mm), when I load it into RM it turns into Sun Jul 15 02:59:59 EEST 2007. WTF? Time zone conversion? I'm lost. Please help.
P.S. I've got 3 date/time variables within one Excel example set...after loading into RM 2 got +3 hours, 1 got +2 hours...again WTF?
I've tried another spreadsheet with the same variables and got different time shifts for the same variables.