🦉🦉   WOOT WOOT!   RAPIDMINER WISDOM 2020 EARLY BIRD REGISTRATION ENDS FRIDAY DEC 13!   REGISTER NOW!   🦉🦉

Excel String to Numerical in RM?

mortizmortiz Member Posts: 18 Contributor II
edited August 12 in Help
I have imported a bunch of numerical data from excel into RM, but some cells have text, so RM converts all the attributes to a polynominal. However, I want everything to be converted to the value indicated in the string. The only way I know to do this is go into the Data Editor and click on each attribute to make it into a real, however I have 200 attributes and this would be tedious to do everytime.

Lastly, how do I filter out all cells in each attribute that has text in it? I can't seem to get the filter expression syntax correct.

Any help would be great! thank you.


Best Answer

Answers

  • varunm1varunm1 Moderator, Member Posts: 965   Unicorn
    Hello @mortiz

    If you want to convert all the attributes to numerical and if every attribute is a nominal you can use (nominal to numerical operator). You can also change it using Turbo prep.

    Hope this helps. If you need more information please inform.
    lionelderkrikorTghadiallymortiz
  • mortizmortiz Member Posts: 18 Contributor II
    This is helpful. thank you!
    Tghadially
  • mortizmortiz Member Posts: 18 Contributor II
    Selecting the Operator Parse Numbers and setting the option Parameter "Unparsable value handling":  "replace with missing values" absolutely did the trick! thank you.
    varunm1
Sign In or Register to comment.