Fill empty cells with the same column distribution

roeebicher
Level 1
Fill empty cells with the same column distribution

Hi,

I want to fill a column with missing values so it won't change the distribution of the columns.

for example, if the column have 60 non-empty records and 18 empty records, for exampel:

10 records of A (17% of non-empty)

20 records of value B (33% of non-empty)

30 records of value C (50% of non-empty)

and 18 empty records

then I would like to fill the values A in 3 records (17% of empty), B in 6 records (33%) and C in 9 records (50%).

 

Any suggestions how can it be done?


Operating system used: Windows

0 Kudos
0 Replies

Labels

?
Labels (1)
A banner prompting to get Dataiku