Practical Data Cleaning: 19 Essential Tips to Scrub Your Dirty Data

by Lee Baker

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!

46 pages, Kindle Edition

Published January 29, 2019

Reviews

[Johnny · Rating 5 out of 5]

Do you work with data? If this is the case, you should read these 19 simple but important tips to scrub data. It starts with the preparation of your worksheets; explains how you should collect data and goes up to the important cross-checks to ensure that the data you work with makes sense. Simple checks on the age of your participants may save you from some embarrassing errors. Tips like these will make your data collection a lot less risky and reduces your error rate without much additional effort.

[Robert Petkovic · Rating 5 out of 5]

For all the Data Virgins

It’s not the first book I read from Lee Baker and I know he is able to explain the most complex statistical concepts in a meaningful and understandable way. Although this is the last one in the series, I would recommend anyone to read this first, because it contains a handful of useful tips every Data junior must know and use.
Of course, I’ve visited the famous Resource Page, a place where this book continues its online life. It’s my permanent bookmark/favourite.