Question
Which data cleaning technique is most appropriate for
handling missing data when missing values are randomly distributed across a dataset?Solution
When missing data points are randomly distributed, imputing values using the mean (for continuous data) or median (for skewed distributions) can be an effective technique. This approach maintains the dataset’s overall structure and helps reduce potential bias introduced by missing values. By substituting missing values with central tendencies, analysts can preserve statistical relationships without significantly distorting the data, ensuring a more accurate analysis. Option A is incorrect as removing rows may lead to a significant data loss, especially if many rows contain missing values. Option C is incorrect because dropping columns with missing values reduces feature dimensions, potentially discarding useful information. Option D is incorrect as placeholder values can introduce bias or mislead analysis, especially if the placeholder value skews the distribution. Option E is incorrect because ignoring missing values leaves gaps, making it difficult to perform accurate analysis.
Who among the following person gets into the lift on floor number two?
Who was born in March?
Which of the following statement is not true?Â
Seven boxes S, T, U, V, W, X and Y are kept one above another such that bottommost box is numbered as 1 while the topmost as 7. Box V is prime numbered ...
E lives on which of the following floor?
How many persons live below D (in the same type of flat)?
What is the weight of the Corn box?
Which one of the following is a student of St. Xavier’s High School?
How many persons live between V and Y?
What is the difference between the age of the one who works in YES and the one who works in Indian?