[Solved] How can I convert the polynomial data type to real?
blatoo
New Altair Community Member
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!
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:
0
Answers
-
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,
David0 -
Thanks David! I found them! ;D0