April 2018
Beginner to intermediate
500 pages
11h 26m
English
The next step will allow us to replace the incorrect value indicators. If we take a look at the data again, we will see that in the age column, the value -19 is displayed. That's obviously an incorrect value since for that variable, permissible values are greater than zero (this is an age):
24 -19 32 15 18 21 28 30 26 100 22 NA
We can replace this value with the missing value indicator, NA. To do this, we will write the following formula in the set suggestions:
IF($col<0, 'NA',$col)
A new step will be added to the Recipe panel immediately after the one created in the previous section. At the same time, we can see a preview of the changes made on the dataset. The incorrect value is no longer present; in its place, ...
Read now
Unlock full access