0:00 Verify and Report Results * Verification: make sure data cleaning is well-executed and results are accurate and reliable. * Changelog: a chronological order list to track made on your project 3:43 Checking Outputs with Expectations: The big picture * Consider the business problem * Consider the goal * Consider the data 8:41 The Final Step: * Pivot table, Find and Replace, .etc. use in Spreadsheet or SQL to fix errors automatically 16:38 Using Change Logs: * Documentation: processing tracking of changes, addition, deletion, and errors 22:37 Why Documentation is Important * Spreadsheet: using a document to track * SQL: using a comment, and state to describe which changes 26:02 Data Cleaning Insights
@khalidsultani18964 ай бұрын
awesome series , always check your cleaned data with raw data sometimes many mistakes occurs in data cleaning , make sure that count on cleaned and uncleaned data make sense.