How can you remove duplicates from an Excel dataset?
Instruction: Describe the steps to identify and remove duplicate records in a dataset.
Context: This question evaluates the candidate's ability to clean and prepare data by removing duplicates, a common task in data analysis.
Updated
Official answer available
Read the opening below, then unlock the full answer and practical guidance.
Define the duplicate key before deleting anything. Two identical amounts can be valid separate transactions; repeated delivery of the same transaction ID may be a duplicate. Decide how to handle conflicting rows with the same key and which record should survive.
Preserve a source copy...