19 Essential Tips to Scrub Your Dirty Data

Data cleaning is a waste of time.

If the data had been collected properly in the first place there wouldn’t be any cleaning to do, and you wouldn’t now be faced with the prospect of weeks of cleaning to get your dataset analysis-ready.

But it doesn’t have to be so difficult. If you're organised and follow a few simple rules your data cleaning processes can be simple, fast and effective.

Practical Data Cleaning (now in its 5th Edition!) explains the 19 most important tips about data cleaning with a focus on understanding your data, how to work with it, choose the right ways to analyse it, select the correct tools and how to interpret the results to get your data clean in double quick time.

Best of all, there is no technical jargon – it is written in plain English and is perfect for beginners!

Learn How to Avoid the 5 Traps That Even Pros Fall Into

Correlation Is Not Causation.

You know it and I know it, and yet we are constantly having to be reminded of it because we can’t seem to help but get it wrong.

It’s not our fault though – we’re only human. We seek explanation for patterns and events that happen around us, and if something defies logic, we try to find a reason why it might make sense. If something doesn’t add up, we make it up.

Correlation Is Not Causation explains how to systematically test for the five most common correlation-causation pitfalls that even the pros fall into (occasionally). We’ll learn to create strategies to analyse the data and interpret the results in a way that is easy to understand.

Best of all, there is no technical or statistical jargon – it is written in plain English.

It is packed with visually intuitive examples and makes no assumptions about your previous experience with correlations – in short, it is perfect for beginners!

Did you know that pirates caused global warming, and that a statistical lie gave rise to one of the fastest growing religions on the planet?

They’re true, honest – and this book has got the stats to prove it.

In his trademark sardonic style, the author reveals the secrets of how the statistical hustlers manipulate and misrepresent data for political or commercial gain – and often get away with it.

Written as a layman’s guide to lying, cheating and deceiving with data and statistics, there’s not a dull page in sight!

Data Cleaning – The Big Picture

An Ultra-High-Definition flowchart (pdf) that will help you take the next steps in your Data Ninja journey!

Practical Data Cleaning Template

An Excel workbook designed to get your data cleaning processes off to the best possible start!

Cheatsheet - Excel Data Cleaning Formulae

22 essential data cleaning formulae in Excel to make sure all your data cleaning, data conversion and descriptive statistics processes go quickly and smoothly

Practical Data Cleaning Cheatsheet

19 Tips to Make Your Data Cleaning Easy!

The Future of Statistics

An anthology written with the contributions of some of the most prominent statisticians, data analysts and Data Scientists in the world to help you take the next steps in your Data Ninja journey!