Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 $500. 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.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2015 Porto Portugal September 7 11 2015 Proceedings Part 1 Lnai 9284

Authors: Annalisa Appice ,Pedro Pereira Rodrigues ,Vitor Santos Costa ,Carlos Soares ,Joao Gama ,Alipio Jorge

1st Edition

3319235273, 978-3319235271

More Books

Students also viewed these Databases questions