RapidMiner 9.7 is Now Available

Lots of amazing new improvements including true version control! Learn more about what's new here.

CLICK HERE TO DOWNLOAD

Why does a correctly formatted Excel date import as a long row of nominal numbers?

SkyTraderSkyTrader Member Posts: 35 Contributor I
edited July 27 in Help
Hi there,
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)?
Cheers,

Best Answers

Answers

  • SkyTraderSkyTrader Member Posts: 35 Contributor I
    Thanks Telecontar120, I'll take another look when I've finished the current project I'm working on.
  • SkyTraderSkyTrader Member Posts: 35 Contributor I
    edited July 29
    Oddly I can now import xlsx files today using the repository/import data and the dates show as Jan 3, 2000 now. I don't know why as I haven't changed the Excel file (I just used the original extension I always use which is xlsx)?

    What are the reasons/advantages/disadvantages to either importing an xlsx file or a csv into RM?
    Cheers,
Sign In or Register to comment.