import values in scientific notation as numerical values?

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.
Alex

Find more posts tagged with

AI Studio

Accepted answers

All comments

alexx

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?

land

Hi,
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.

Greetings,
Sebastian

alexx

Sebastian,

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?