🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Replace missing values based on another attributes

User: "1640607mortel"
New Altair Community Member
Updated by Jocelyn

Hey all,

I am new to Rapidminer and i have a question regarding data preparation. It looks a bit like this question, but i can't figure out how to apply this to my situation.

 

I have a dataset regarding accidents, and this datset contains the following attributes:

Total Fatal Injuries   Total Serious Injuries   Total Minor Injuries   Total Uninjured       
Missing                     Missing                             Missing                        1
Missing                     Missing                             2                                   Missing
2                                2                                         Missing                        Missing

1                                Missing                             Missing                        Missing
Missing                     Missing                             Missing                        Missing

I would like to fill in the missing values with ''0'' only if one of the four attributes contains a value.
I am not very experience with RapidMiner, and I'm learning through a book called ''Data Mining for the Masses''. Unfortunately, the book won't go into detail in these kind of problems. 

I already tried to use the Generate attributes operater with the following code, but I am not skilled enough to get it to work: 
if([ Total Uninjured ]>0, if(missing([ Total Fatal Injuries ])), then(replace(0)))

I tried to tell the program that if ''Total Uninjured'' is greater than ''0'' and ''Total Fatal Injuries'' is missing, replace ''Total Fatal Injuries'' with 0.

Any help would be greatly appreciated!

Find more posts tagged with