Rule Filter - how to replace Unknown Value to Missing values

I am trying to use rule filter to replace “U” to MISSING values on my gender column so that I can replace them one shot with mode.

Please advise as i tried to set the command but failed.

Hi @Nimisha1986,

What about trying this: NOT $Gender$ = "U" => $Gender$

Kind regards,

2 Likes

Thanks Forest, I tried and it works.

1 Like

Hello @Nimisha1986,

You can also utilize the Missing Value node and configure it to set a fixed value.

Please refer to the attached image for guidance:

Output:

Screenshot 2024-01-31 144500

Thank you! I will used the missing value node to replace this thanks again

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.