Altair RISE
A program to recognize and reward our most engaged community members
Nominate Yourself Now!
Home
Discussions
Community Q&A
"While exporting to Excel i need to replace
yogesh_kumar
I need to have blanks data while exporting to Excel but it is exported with "?" symbols , Please help me to show only blanks instead of Question mark symbol..
Find more posts tagged with
AI Studio
Excel
Replace
Accepted answers
MartinLiebig
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
All comments
MartinLiebig
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
kypexin
Hi
@yogesh_kumar
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).
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups