Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

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

Image: https://us.v-cdn.net/6030995/uploads/editor/iu/6mespk7eat9w.png

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

Find more posts tagged with

AI Studio

Accepted answers

kypexin

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.

All comments

kayman

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

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.