Survey banner
The Dataiku Community is moving to a new home! Some short term disruption starting next week: LEARN MORE

Creating Null Values or Replacing Specific Values with Mean

Solved!
bejvg
Level 1
Creating Null Values or Replacing Specific Values with Mean

Hello,

I have a rather large dataset in which missing values are filled in as -1.

I am trying to find a way to replace these -1 values with the median of the column, but because I can't see how to do it directly, I am first using a replace step to replace '-1' with '' (no value) and then imputing the no values with the median. However, the job fails after the replace step because it can't place no value in an integer column. 

Is there any way to replace -1 with the median directly or a way to fill in missing values to an integer column?


Operating system used: Windows

0 Kudos
1 Solution
bejvg
Level 1
Author

I managed to circumvent the issue by using filter to clear cells that are <= -0.5. A cell that is cleared and a cell that has no value are apparently treated differently, and the cleared cell will not throw a type error. Hope this will help someone else!

View solution in original post

0 Kudos
1 Reply
bejvg
Level 1
Author

I managed to circumvent the issue by using filter to clear cells that are <= -0.5. A cell that is cleared and a cell that has no value are apparently treated differently, and the cleared cell will not throw a type error. Hope this will help someone else!

0 Kudos