data cleaning

Recent Post

Data Integrity – Don’t Let Chinese Whispers Kill Your Data

Data Integrity – Don’t Let Chinese Whispers Kill Your Data

​I’m sure you’ve all heard about the party game Chinese Whispers, where a message is given to a person at one end of a line and is then whispered to the next, then the next, and so on until it reaches its eventual destination at the other end. Typically, small changes in the message occur…

How to Clean Your Data Quickly in 5 Steps

How to Clean Your Data Quickly in 5 Steps

Did you know that Data Scientists spend 80% of their time cleaning data and the other 20% complaining about it? Yeah, you’re right – it’s not funny. But then there isn’t anything funny about data cleaning. It’s not just the Data Scientists that complain about it though, it’s pretty much everybody that works with data. It doesn’t have…

How to Clean Numerical Data in Excel Using COUNT and COUNTIF

How to Clean Numerical Data in Excel Using COUNT and COUNTIF

Cleaning numerical data can take a ridiculous amount of time – if you’re cleaning it manually, that is. Learning to use a few simple formulae in Excel can save you time, hassle and having to explain to your boss why that analysis report isn’t on his desk yet, a mere 2 weeks after he gave you…

How to Clean Text Data Without Manual Data Manipulation

How to Clean Text Data Without Manual Data Manipulation

There is plenty of information in Excel’s help files about the way Microsoft suggests that you use them. You can learn a lot from them but did you know that there are actually alternative uses of these functions and formulae? It’s actually these alternative uses that turn out to be the most valuable because they can help…

5 Productivity Tips for Efficient Data Cleansing

5 Productivity Tips for Efficient Data Cleansing

The previous blog post in this series 11 Essential Tips for Effective Data Collection dealt with practical data collection methods. This blog post is the second in the series and deals with data cleaning (aka data cleansing or data scrubbing). Data cleaning may not be everyone’s favourite part of working with data, but it’s definitely one of the…