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.
βmβ painters can paint a house in 60 days. If the crew increased by 25 painters, they could finish in 40 days. What is the value of βmβ?
...Aβ and βBβ together can complete a work in 25 days while βAβ takes 30 days to complete the same work alone. If βCβ is 20% more efficient t...
A and B together can do a work in 12 days. If A can alone do the same work in 18 days, then in how many days B alone will do the same work?
A2 type ‘P’ pipes can fill a tank in 450 hours, while B2 type ‘Q’ pipes can fill the same tank in 6...
Anu can finish 25% of an assignment in 10 days, whereas Tanya can do 30% in 12 days. Anu works on it for 16 days and leaves. How long will Tanya take to...
Ananya and Riya can complete a task in 20 hours and 40 hours respectively. Ananya works alone for 10 hours and then Riya finishes the remaining task. Ho...
A and B together can complete a job in 2 days. A alone takes x + 6 days to complete the job, while B alone takes x + 24 days to complete the same job. <...
An elephant can do a work as fast as two horses βAβ and βBβ can do it by working together. If horse βAβ alone can complete the work in 9 hou...
Numan does 4/ 5 half the work as Gagan in time. If together they take 16 days to complete a piece of work, then how long will Gagan take to complete the...
Aman is twice as efficient as Suman. Both of them began working together, but Aman stopped after 12 days. Suman then finished the remaining work in 4 da...