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.
Agri Infinity Program to boost start ups is launched by ______?
Securities and Exchange Board of India (SEBI) was given statutory powers on which of the following year?
Which of the following is the largest public sector bank in India by total assets?
Scheduled Banks in India refer to those banks which have been included in the ______ Schedule of Reserve Bank of India Act, 1934.
Which bank has introduced a 175-day tenor fixed deposit at an interest of 7.50 per cent per annum for deposits of ₹2 crore & above to less than Rs.50 ...
Which of the following is the defining characteristic of a pure public good that leads to the classic free-rider problem and market failure?
Andhra Bank and Corporation Bank were amalgamated into Union Bank of India in which of the following year?
SBI cards Pvt Ltd joined hands with ______ for Card Tokenization to Protect Cardholders’ Data.
Which bank became the first bank to join the India International Bullion Exchange (IIBX)?
Government of India has undertaken Switch Operation of Rs .________ Crore with RBI?