Introduction: Don’t Panic !!!
- Data Collection
- Data Cleaning
- Data Codification & Classification
- Data Integrity
- Bonus Chapter: Work Smarter, Not Harder
19 Essential Tips to Scrub Your Dirty Data
Data is messy and cleaning it can be time-consuming and costly – but it doesn’t have to be this way. If you're organised and follow a few simple rules your data cleaning processes can be simple, fast and effective.
Practical Data Cleaning explains the 19 most important tips about data cleaning to get your data analysis-ready in double quick time.
The author is letting you choose the price you pay for this book!
Data is messy and cleaning it can be time-consuming and costly – but it doesn’t have to be this way. If you're organised and follow a few simple rules your data cleaning processes can be simple, fast and effective.
Practical Data Cleaning explains the 19 most important tips about data cleaning to get your data analysis-ready in double quick time.
About the Book
-------------------------------------------------
You can now get the following FREE bonuses with this book:
Data Cleaning – The Big Picture
Practical Data Cleaning Template
Cheatsheet - Excel Data Cleaning Formulae
Practical Data Cleaning Cheatsheet
-------------------------------------------------
You can download the content in a zip file by going to your Leanpub library here https://leanpub.com/user_dashboard/library, 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!
Pick Your Price...
Minimum price
$7.99
$20.00
About the Author
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!

Episode 197
An Interview with Lee Baker
Table of Contents
Introduction: Don’t Panic !!!
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...
We pay 80% royalties on purchases of $7.99 or more, and 80% royalties minus a 50 cent flat fee on purchases between $0.99 and $7.98. You earn $8 on a $10 sale, and $16 on a $20 sale. So, if we sell 5000 non-refunded copies of your book for $20, you'll earn $80,000.
(Yes, some authors have already earned much more than that on Leanpub.)
In fact, authors have earned over $14 million writing, publishing and selling on Leanpub.
Learn more about writing on Leanpub
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
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.