The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
"RegularExpression-bug?"
choose_username
Member Posts: 33 
Contributor II
Hi there,
i have a Data set which got lines looking like the following:
41, Private, 109912, Bachelors, 13, Never-married, Other-service, Not-in-family, White, Female, 0, 0, 40, ?, <=50K
From time to time there is a '?' . I wanted to replace it but RapidMiner didnt recognize it as a charakter.
I used the Replace-Operator and wrote in "replace what" a 'any character'- character from the regular expressions suggestions window. All other charaters were replaced but not the '?'.
Now i wanted to know if that is because of a bug or did i smth wrong ?
Greetings
User
i have a Data set which got lines looking like the following:
41, Private, 109912, Bachelors, 13, Never-married, Other-service, Not-in-family, White, Female, 0, 0, 40, ?, <=50K
From time to time there is a '?' . I wanted to replace it but RapidMiner didnt recognize it as a charakter.
I used the Replace-Operator and wrote in "replace what" a 'any character'- character from the regular expressions suggestions window. All other charaters were replaced but not the '?'.
Now i wanted to know if that is because of a bug or did i smth wrong ?
Greetings
User
Tagged:
0
Answers
if i change the ending of the file to .arff then i cant filter the '?' out
if i change the ending of the file to .csv then the '?' gets filtered out.
Maybe this helps.
______________________
User.
RapidMiner uses '?' to denote a missing value. As there is no value given you cannot replace it (there is none). You can use either Replace Missing Values or Impute Missing Values, both from Data Transformation.Data Cleansing!
Best regards,
chero