import values in scientific notation as numerical values?

alexxalexx Member Posts: 12 Contributor II
edited November 2018 in Help
Dear community,

I want to import values in scientific notation (2.2908785e+000) from a file as numerical values in RM5.

In the import window I can only choose them to be nominal.

Screenshot: http://img109.imageshack.us/img109/5108/import.png

When I import the _same_ file into RM4.6, I can specify them to be numerical. Is there a way to do the same in RM5?

Thanks in advance.


  • Options
    alexxalexx Member Posts: 12 Contributor II
    Instead of importing the data in the wizard, I tried the "Read CSV" operator. It reads most of the columns as "nominal", but some as  "real". (Screenshot: http://img59.imageshack.us/img59/609/importe.png).

    I don't understand it because the format of the numbers is the same for all numbers in the file. If anyone wants to try it out, here is the csv-file: http://jump.fm/PQBHQ.

    Can anyone help me with this one?
  • Options
    landland RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 2,531 Unicorn
    sorry but I'm to stupid to hit the correct link on the page you linked. I only get advertisments popping up.
    Anyway you could import the data and use the parse numbers operator to change the value types. If you then again store it in the repository you have a complete way around. Sorry for this inconvenience, we will change the behavior of the import wizards with one of the next updates.

  • Options
    alexxalexx Member Posts: 12 Contributor II

    sorry for the bad upload hoster. Here is the same file again: http://www.megaupload.com/?d=U1TABG60

    I just posted my problem with the import of those values in my other related thread "Different results for X-Validation (libSVM) in version 4.6 & 5 using same input?".

    To put it in short words: RM5 correctly imports values like 2.6855298e-001 (with exp != 000) as real but incorrectly imports values like 2.6855298e-000 (with exp==0) as nominal. Any way I can declare the latter as real/numerical?
Sign In or Register to comment.