Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
"While exporting to Excel i need to replace
yogesh_kumar
Member Posts: 1 
Learner I
Best Answer
-
MartinLiebig
Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,528 
RM Data Scientist
Hi @yogesh_kumar ,? are representing missing values in RapidMiner. This can either be, because there was no value filled in a field, or because you did an operator which produced no viable value, like 0/0.Different software packages have different conventions how to represent missing values. We use ?, programming languages often NaN and Excel uses blank cells. So it's actually an accurate output.BR,Martin- Sr. Director Data Solutions, Altair RapidMiner -
Dortmund, Germany6
Answers
To add my 5 cents to @mschmitz answer.
Yes, it's only a matter of data display convention in RapidMiner.
But m,ost likely you'll need to use REPLACE MISSING VALUES operator after reading the Excel file. How you handle these blank cells with missing data also depends on the type of the missing values. If they are strings or text (which means nominal variables in RM), you can replace them with empty value or space. However, if they are numbers (numeric variables in RM), you can't leave them blank as you'd have to replace them with certain number as well (like zero, max, min, average of the column).
Vladimir
http://whatthefraud.wtf