Due to new reporting requirements, a data analyst must add new classification codes to historical data. Which of the following is the best technique for this task?
This question falls under the Data Acquisition and Preparation domain, focusing on modifying historical data. The task is to add new classification codes to existing data, which involves adding new rows or columns.
Append (Option A): Appending adds new rows to a dataset, which is suitable if the classification codes are new records (e.g., a new table of codes to combine with historical data). If the codes are a new column, a join or update might be used, but append fits the context of adding new data.
Binning (Option B): Binning groups data into categories, not suitable for adding classification codes.
Parsing (Option C): Parsing breaks down data (e.g., splitting strings), not relevant for adding codes.
Union (Option D): Union stacks tables with identical structures, but the task involves adding new data (codes) to historical data, not combining identical tables.
The DA0-002 Data Acquisition and Preparation domain includes "executing data manipulation," and appending is a common technique for adding new data to historical datasets.
[Reference: CompTIA Data+ DA0-002 Draft Exam Objectives, Domain 2.0 Data Acquisition and Preparation., ==============]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit