Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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