How to replace a certain column value by MISSING_NOMINAL ?
I have an Excel file that contains the word NULL in certain cells to indicate a missing value.
I want to replace that word by MISSING_NOMINAL, so RapidMiner can interprete it correctly as a missing value.
Find more posts tagged with
Sort by:
1 - 3 of
31
Altair EmployeeHi,
alternativly you can use Generate Attributes and use an equation like this:
if(Wind==false,MISSING_NOMINAL,Wind)BR,
Martin
Hi @alain
There's also an operator called DECLARE MISSING VALUE which will actually replace specified values with real missing values (will be displayed as ?) and they will be interpreted as such by RapidMiner.
I want to replace that word by MISSING_NOMINAL, so RapidMiner can interprete it correctly as a missing value
The solutions offered here are replacing one string with another, but is that what you really need? There's also an operator called DECLARE MISSING VALUE which will actually replace specified values with real missing values (will be displayed as ?) and they will be interpreted as such by RapidMiner.
Sort by:
1 - 1 of
11
Hi @alain
There's also an operator called DECLARE MISSING VALUE which will actually replace specified values with real missing values (will be displayed as ?) and they will be interpreted as such by RapidMiner.
I want to replace that word by MISSING_NOMINAL, so RapidMiner can interprete it correctly as a missing value
The solutions offered here are replacing one string with another, but is that what you really need? There's also an operator called DECLARE MISSING VALUE which will actually replace specified values with real missing values (will be displayed as ?) and they will be interpreted as such by RapidMiner.
If you are looking to replace the word NULL. You can use the Replace operator. Select the attribute filter type "single" and then select the relevant attribute (Column). If this NULL is present in all columns then you can select "all" in attribute filter type. After that, you can specify NULL in "replace what" and the value you want MISSING_NOMINAL in "replace by".
Hope this helps.