Cheat Sheet FREE ACCESS Beginner

The 10-Minute Data Quality Audit

by LucidPlexus
0.00 · 0 reviews
Ten checks to run on any new table before you trust a number from it, a minute each. A printable two-page A4 sheet. Each check has the SQL (DuckDB) and a pandas one-liner, what a bad result looks like, and a worked…
2 Pages
0 Views
0 Downloads

Overview

Everything useful before you download or buy.

Ten checks to run on any new table before you trust a number from it, a minute each.

A printable two-page A4 sheet. Each check has the SQL (DuckDB) and a pandas one-liner, what a bad result looks like, and a worked run on the agricultural exports and prices from Can I Trust This Data?, with the real counts: rows against what was promised, column types, exact and key duplicates, missing values, spellings, ranges, values far from their group's median, gaps and freshness, and the master list.

On the book's data the checks find, among other things, 3 exact and 33 key duplicates, seven spellings of four countries, a tonnage of −4,500, two prices about ten times too high and 63 export rows with no price in their year.

It ends with a tick-box summary to fill in for your own table and a five-line template for the note you write afterwards. PDF, two A4 pages.

#cheat-sheet #data-cleaning #data-quality #pandas #sql
Type Cheat Sheet
Pages 2
Access Free download

Read Online

Read the complete resource here once you are signed in, or download it below.

Log in to read online

Free resources are readable and downloadable once you're signed in.

Log in

Ratings & Reviews

One review per person. Submitting again updates your existing review.

0 total

Write a review

Share what helped, what stood out, or who this resource is best for.

No reviews yet

Be the first to review this resource.

Login to Download Preview