My Data contains many missing values(blank space) or symbols like"?".How do we remove that??

ed1305
ed1305 New Altair Community Member
edited November 5 in Community Q&A


How to fill these blank spaces and remove "?"And also for numeric variable how do i set the blank spaces to mean or median value
Tagged:

Best Answer

  • kypexin
    kypexin New Altair Community Member
    Answer ✓
    Hi @ed1305
    Note that the ? might not be a real character, but simply the way Rapidminer indicates a missing value.
    In the latter case you might also want to use REPLACE MISSING VALUES operator to handle those missing values as well. 

Answers

  • kayman
    kayman New Altair Community Member
    You can use the 'declare missing value' operator to change the ? to a missing (null) value. In order to make an empty field missing/null you can use the trim operator.

    Note that the ? might not be a real character, but simply the way Rapidminer indicates a missing value.
  • kypexin
    kypexin New Altair Community Member
    Answer ✓
    Hi @ed1305
    Note that the ? might not be a real character, but simply the way Rapidminer indicates a missing value.
    In the latter case you might also want to use REPLACE MISSING VALUES operator to handle those missing values as well. 

Categories