Question: Data cleaning can involve adding, modifying, and deleting data. In which of the following examples would data modifying be required? You are preparing an analysis
Data cleaning can involve adding, modifying, and deleting data. In which of the following examples would data modifying be required?
You are preparing an analysis of how many purchase orders are greater than $ The file you are working with has a row at the beginning of each new month with the month name listed in the date column. There is no other data in the row with the month name.
A file of purchase orders is missing one month of purchase orders.
While examining the purchase orders data, you note that the vendor's name, street address, city and state are listed in separate columns. In some cases, the state column displays the state name, in other cases the state abbreviation is shown.
During your analysis of purchase orders, you note that some of the orders include the vendor phone number.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
