Fill empty cells with the same column distribution
roeebicher
Registered Posts: 1 ✭
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
Tagged: