Practical Data Cleaning
Minimum price
Suggested price

Practical Data Cleaning

19 Essential Tips to Scrub Your Dirty Data

About the Book


Now With 4 Free Bonuses!

You can now get the following FREE bonuses with this book:

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!

Practical Data Cleaning Cheatsheet

  • 19 Tips to Make Your Data Cleaning Easy!


You can download the content in a zip file by going to your Leanpub library here, selecting the book, and then clicking on the "Download Extras" download link.


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.

Worse still, your boss won’t understand why your analysis report isn’t on his desk yet, a mere 48 hours after he’s asked for it. Bless him, he doesn’t understand – he thinks that cleaning data is just about clicking a few buttons in Excel and – ta da! – it’s all done. Even a monkey can do that, right?

And – for good reason – you won’t get any help from statistics books either. Data is messy and cleaning it can be difficult, time-consuming and costly. Not to mention it’s the least sexy thing you can do with a dataset.


Yet you’ve still got to do it, because, well, someone has to…

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.

Not to mention fun!

Well, not fun exactly, just not quite as coma-inducing.

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!


Discover how to clean your data quickly and effectively. Get this book, TODAY!

  • Share this book

  • Categories

    • Data Science
    • Sciences
    • Non-Fiction
    • Textbooks
  • Feedback

    Email the Author(s)
  • License

About the Author

Lee Baker
Lee Baker

Lee Baker is an award-winning software creator with a passion for turning data into a story.

A proud Yorkshireman, he now lives by the sparkling shores of the East Coast of Scotland.

Physicist, statistician and programmer, child of the flower-power psychedelic ‘60s, it’s amazing he turned out so normal!

Turning his back on a promising academic career to do something more satisfying, as the CEO and co-founder of Chi-Squared Innovations he now works double the hours for half the pay and 10 times the stress - but 100 times the fun!

Bundles that include this book

Bought separately
Bundle Price
Bought separately
Bundle Price

Reader Testimonials

Deepankar Chakrabarti
Deepankar Chakrabarti

Presented in a very simple way for beginners to understand. The essential elements of data pre-processing presented as a capsule

Ronald Michael Pengelly
Ronald Michael Pengelly

The simple rules for the data cleaning processes that you have devised enable someone new to data cleaning to easily learn how to do data cleaning and to become fast, and effective at doing it.

David Napoli
David Napoli

Start your week off right by drinking from the firehose of #stats knowledge

Heather Krausse
Heather Krausse

Great material at a reduced price for the #nptech crowd

Table of Contents

Introduction: Don’t Panic !!!

  • Data Collection
  • Data Cleaning
  • Data Codification & Classification
  • Data Integrity
  • Bonus Chapter:   Work Smarter, Not Harder

The Leanpub 60 Day 100% Happiness Guarantee

Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.

Now, this is technically risky for us, since you'll have the book or course files either way. But we're so confident in our products and services, and in our authors and readers, that we're happy to offer a full money back guarantee for everything we sell.

You can only find out how good something is by trying it, and because of our 100% money back guarantee there's literally no risk to do so!

So, there's no reason not to click the Add to Cart button, is there?

See full terms...

80% Royalties. Earn $16 on a $20 book.

We pay 80% royalties. That's not a typo: you earn $16 on a $20 sale. If we sell 5000 non-refunded copies of your book or course for $20, you'll earn $80,000.

(Yes, some authors have already earned much more than that on Leanpub.)

In fact, authors have earnedover $13 millionwriting, publishing and selling on Leanpub.

Learn more about writing on Leanpub

Free Updates. DRM Free.

If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).

Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.

Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.

Learn more about Leanpub's ebook formats and where to read them

Write and Publish on Leanpub

You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!

Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.

Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.

Learn more about writing on Leanpub