The final step in data cleaning

Would you like to follow along with the instructor using the same spreadsheet? To use the spreadsheet template, click the link below and select "Use Template."

Link to template: Jeff's Party Planet - Data for Cleaning

OR

If you don't have a Google account, you can download the spreadsheet directly from the attachment below: Jeff's Party Planet - Data for Cleaning

The menu option has slightly changed. To insert a pivot table select Insert and Pivot Table.

Note: This section of the video does not use the Jeff's Party Planet dataset you downloaded earlier. The example that the instructor uses is not from a public dataset and is just intended to demonstrate how a CASE statement works.

Capturing cleaning changes

The instructor stated that the first two benefits of documentation --1) recalling the errors that were cleaned and 2) informing others of the changes -- assume that the data errors aren't fixable. She then added that when the data errors are fixable, the documentation needs to record how the data was fixed. Data-cleaning documentation is important in both cases.