Replacing Miscoded Values/terms

jlajla MemberPosts:11Learner I
inHelp
Hi! My data set should only include these entries:Positive andNegative. However, there are miscoded entries such as Neg, NEG, and Pos. I tried the "Replace" operator for a couple of times now but some correct entries change too. For instance, I want to change Neg to Negative, the entries with the correct word Negative become Negativeative. How can I correct this?


Best Answer

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified ExpertPosts:949Unicorn
    Solution Accepted
    Hi!

    ^neg.* would be a good expression, especially if you switch on case-insensitive matching.

    ^ means "beginning of the string". This makes sure that your text starts with "neg". The .* after it is "any sequence of characters". This will match neg, negative, negativeative etc.

    Replace is good for replacing text that you can express as a regular expression. If you have a list of values, Map can be easier to use without regular expressions.

    Regards,
    Balázs
    jla

Answers

  • jlajla MemberPosts:11Learner I
    I think I just figured it out right now, but I still don't know if it's right. I used the "multiple arbitrary characters" and it worked for me though I'm not sure if it really is the correct way to do it.
  • jlajla MemberPosts:11Learner I
    我使用第二个过程is just the regular expression "negativeative" and it also worked somehow. I viewed their differences in the results and they don't have any so far. Which method do you think is more appropriate to use?
  • jlajla MemberPosts:11Learner I
    Just tried it on my previous processes and it worked! Thank you so much@BalazsBarany!笑脸:
Sign InorRegisterto comment.