Community & Support
Learn
Marketplace
Discussions
Categories
Discussions
- General
- Platform
- Academic
- Partner
- Regional
User Groups
Documentation
Events
Altair Exchange
- Share or Download Projects
Resources
Employee Resources
- This tab can be seen by employees only. Please do not share these resources externally.
Groups
- Join a User Group
Support

Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Home
Discussions
Community Q&A

Replace certain value with average?

I am currently working with a dataset for an assignment, that has a lot of values set to 0 in it (such as weight) and is therefore skewing the data..
I want to replace all 0 values with the average values of that column.

I have tried using replace missing values operator and setting the type to numeric value filter, with the numeric condition of "= 0".. But it is not working for some reason.

Is there any way to do this?

Find more posts tagged with

AI Studio

Accepted answers

All comments

[Deleted User]

Hi emkoirl,

Missing values are represented by a question mark (?) in RapidMiner.

Therefore you have to declare the 0 values as missing (using the Declare Missing Values Operator) before you can replace them with the Replace Missing Values Operator.

Best,
Edin

emkoirl

Thank you very much that worked.

Quick Links

All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups