You have a dataset that is missing values in a column named Column3. Column3 is correlated to two columns named Column4 and Column5. You need to improve the accuracy of the dataset, while minimizing data loss. What should you do?
A. Replace the missing values in Column3 by using probabilistic Principal Component Analysis (PCA).
B. Remove all of the rows that have the missing values in Column4 and Column5.
C. Replace the missing values in Column3 with a mean value.
D. Remove the rows that have the missing values in Column3.
Answer:A
You have a dataset that is missing values in a column named Column3. Column3 is correlated to two columns named Column4 and Column5. You need to improve the accuracy of the dataset, while minimizing data loss. What should you do?
A. Replace the missing values in Column3 by using probabilistic Principal Component Analysis (PCA). B. Remove all of the rows that have the missing values in Column4 and Column5. C. Replace the missing values in Column3 with a mean value. D. Remove the rows that have the missing values in Column3.