[Solved] How can I convert the polynomial data type to real?

blatoo
blatoo New Altair Community Member
edited November 5 in Community Q&A
Hi all,

I try to read a csv file which has an numberic attribute written in German format, for example: price : "100,52".  So rapidminer don't understand the comma, so it consider the attribte as "Polynomial".

Is there any operator, which convert the polynomial data type to real? For exsample: The polynomial value "100,52" to numeric value 100.52 ??? I tried the operator "Nomial to Numerical", but it does not do the job what I want.


Thanks in advance!

Tagged:

Answers

  • David_A
    David_A New Altair Community Member
    When reading a csv file with the "Read CSV" Operator you can specify the decimal separator with the parameter "decimal character".
    For an existing example set there is also the "Parse Numbers" Operator, which tries to parse nominal values as number.
    Hope this will help you.


    Regards,
    David
  • blatoo
    blatoo New Altair Community Member
    Thanks David! I found them!  ;D