
Ultimate access to all questions.
You are tasked with implementing a data cleansing process for a dataset that includes both numerical and categorical data. Describe the steps you would take to cleanse this data, including how you would handle outliers, normalize numerical data, and standardize categorical data.
A
Ignore outliers, normalize numerical data by scaling it to a range of 0-1, and standardize categorical data by converting it to numerical values.
B
Remove all outliers, normalize numerical data using z-score normalization, and standardize categorical data by encoding it.
C
Handle outliers by capping them at a certain threshold, normalize numerical data using min-max scaling, and standardize categorical data by one-hot encoding.
D
Delete the entire dataset if outliers are found, avoid normalizing numerical data, and leave categorical data as is.