Module 4. Manually Cleaning Data

Question 1

Verification

Answer 1

A process to confirm that a data-cleaning effort was well-executed and the resulting data is accurate and reliable.

Question 2

Changelog

Answer 2

A file containing a chronologically ordered list of modification made to a project

Question 3

Pivot table

Answer 3

A data summarisation tool that is used in data processing. Sort, Reorganise

Question 4

See the big picture when verifying data-cleaning

Answer 4

1. Consider the Business Problem
2. Consider the Goal.
3. Consider the Data.

Question 5

Documentation

Answer 5

The process of tracking changes, additions, deletions, and errors involved in your data-cleaning effort.