Hi how do I import an excel file with date and time information?
I have an excel table showing activities that were performed on various dates and time.. in the excel file do I import these as 2 separate columns and can the format be dd/MM/YYYY and time HH:MM.. or must it be in one column, i.e. dd/MM/YYYY@HH:MM.. I tried this single column but the import process re-set the time info to 12:00
Find more posts tagged with
Sort by:
1 - 4 of
41
New Altair Community Member
Accepted Answer
The spreadsheet is preserving the data in its original format when saved and the cell format is loaded separately after that.
New Altair Community Member
OPHi guys, this is very useful indeed. I used Scott's method and got it to work.. using the nomial to date converter
Acting on a hint from Roger's post, I actually spent some time to get an appropriate format, i.e. dd/MM/yyyy Hh:mm and I found that I did not even need to do any conversion, on importing the rapidminer software auto-detected it to be a date and time and it works fine
Thank u so much! Now I can finally get to analysing the stuff... cheers!
Acting on a hint from Roger's post, I actually spent some time to get an appropriate format, i.e. dd/MM/yyyy Hh:mm and I found that I did not even need to do any conversion, on importing the rapidminer software auto-detected it to be a date and time and it works fine
Thank u so much! Now I can finally get to analysing the stuff... cheers!
New Altair Community Member
OPLesson learnt : Easier to get the format sorted at the source, i.e. the excel file to avoid conversions.. cheers
Sort by:
1 - 2 of
21
Altair EmployeeAccepted Answer
hi @Loco if it were me, I'd import that date time column from Excel as a nominal attribute, and then convert it afterwards using "Nominal to Date".
Scott
Scott
New Altair Community Member
Accepted Answer
The spreadsheet is preserving the data in its original format when saved and the cell format is loaded separately after that.
Scott