[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_28":-5,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54},"routes/_store+/_readers+/email_author.$slug/route",{"_9":10,"_11":-5},"book",{"_12":13,"_14":15,"_16":17,"_18":19,"_20":21,"_22":23},"currentUser","id","Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6Qm9va1Byb2R1Y3QvMTg5MjI","title","Practical Data Cleaning","state","published","contactAuthorMethod","email","aboutText","

-------------------------------------------------

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 5^th 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!

","authors",[24],{"_12":25,"_26":27,"_28":29},"Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6UHJvZHVjdEF1dGhvci8xOTYzNg","name","Lee Baker","user",{"_30":31},"avatar",{"_32":33,"_34":35,"_36":37},"url","https://d39qdlcrvnra4b.cloudfront.net/avatars/484126/medium/Lee_Baker_-_888x805.jpg?1431094335","styleName","medium","exists",true,"shoppingCartId","shoppingCart",{"_12":67,"_68":69,"_70":37,"_71":72,"_73":74,"_75":76,"_77":37},"locale","en","readerTheme","light","constants",{"_65":66},"publishers",{"_61":62,"_63":64},"learnerOrganizations",[],"needsLocaleCookieSync",false,"announcements",{"_55":56,"_57":-5},"announcement_store",{"_58":37,"_59":60},"announcement_authors","flag","text","

Kick off your book project in 3 hours! Live workshop on Zoom. You’ll leave with a real book project, progress on your first chapter, and a clear plan to keep going. Saturday, May 16, 2026. Learn more…

\n","companies",[],"universities",[],"paypalClientId","AX53Cwz8jR6rVVzzZiZNWWXl0dGagi-GZrjG-S3Ua14E5nrKMn7DxDQ730O4R8LusLPp49ALn6aRVaEy","no-cart","count",0,"free","updatedAt","","paymentGateway","STRIPE","cartItems",[],"loading"]

Email the Author