Question
Which of the following methods is most commonly used
during data wrangling to handle missing values in a dataset?Solution
Replacing missing values with the mean or median is one of the most common methods used during data wrangling. This method is preferred when the missing values are not randomly distributed, and there is a need to fill gaps without introducing significant bias. The mean is often used for normally distributed data, while the median is preferred for skewed data, as it is less sensitive to outliers. This technique allows analysts to retain all the available data and proceed with analysis without losing important information, which could otherwise distort statistical analyses or machine learning models. Option A (Remove rows with missing data) is incorrect because it can lead to a significant loss of data, especially if the missing values are scattered across the dataset. Option B (Replace missing values with zeros) is not ideal because replacing with zeros can distort the analysis, especially if zeros don't make sense in the context of the data. Option D (Ignore the missing values) is not recommended as it might lead to biased results or inaccuracies in analysis. Option E (Use machine learning to predict missing values) is correct in advanced scenarios but typically used after more straightforward methods (like mean/median imputation) have been applied.
12 man can make a wall in 6 days. How many men required to complete the same work in 3 days ?
A and B together, B and C together and A and C together can complete a piece of work in 44 days, 33 days and 36 days respectively. Find the ratio of the...
A can do a work in 10 days and B in 15 days. If they work on it together for 4 days then in how many days the remaining work will be completed by B?
A can complete a task in 10 days, and B can complete it in 15 days. After 3 days of working together, B leaves. How many more days will A take to finis...
Mike and Jenny alone can complete a task in 24 days and 40 days respectively. They aim to finish the work in 'd' days. What percentage increase in Jenny...
P can do a piece of work in 15 days, Q can complete double the work in 60 days and R can do the work in 40 days. If all of them together earn Rs. 3000, ...
3 men, 4 women and 5 boys can do a piece of work in 15 days, 20 days and 25 days respectively. For first 3 days 3 men and 2 women work together and for ...
βAβ and βBβ can do a piece of work in 15 days and 20 days, respectively. They started working together but βAβ left after 3 days. Find the t...
A and B together can complete a work in 10 days. B and C together can do it in 12 days, and A and C together can do it in 15 days. In how many days will...