RapidMiner 9.7 is Now Available
Lots of amazing new improvements including true version control! Learn more about what's new here.
Why does a correctly formatted Excel date import as a long row of nominal numbers?
Wondering why my correctly formatted (short date) in Excel (dd/mm/yyyy) imports as a long row of nominal numbers when using xlsx?
I've seen a huge amount of coverage on this but nothing that addresses the reason why a string of (meaningless to me!) nominal numbers would somehow be easier to interpret? Particularly if your reason for using RM is to predict the future price of assets, i.e. so when looking within Data you'd want to see dates not a string of number. I did try the operator to converts nomiunal to date but it did nothing and I still was left with nominal numbers?
I've only been able to get dates to appear if I first convert my xlsx into a csv file first. What are the reasons/advantages/disadvantages to either importing an xlsx file or a csv into RM (apart from, in the case of a csv, to be able to see actual dates)?