Practical Data Cleaning
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 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!
Presented in a very simple way for beginners to understand. The essential elements of data pre-processing presented as a capsule
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.
Start your week off right by drinking from the firehose of #stats knowledge
Great material at a reduced price for the #nptech crowd
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.
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 $12 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.