Let’s face it – cleaning data is a waste of time.
If only the data had been collected and entered carefully in the first place, you wouldn’t be faced with days of data cleaning to do. Worse still, your boss probably doesn’t understand why you can’t just do it in a few minutes. After all, you only need to click a few buttons in Excel, don’t you?
Well, we all hate data cleaning, but if we get organised and learn a few tricks there are ways to…Continue
Going somewhere nice for your summer holidays? Somewhere with a nice beach perhaps – Goa, Grand Cayman or Grimsby? Or a bustling city break? Wherever you’re going there’s sure to be long periods where you’ll sit for hours on end with little to do but read, so I thought I’d throw together a few free eBooks for your Kindle to while away the long hours in the airport, in a traffic jam or on the beach.
A mixture of books about data, analysis, statistics and R programming, they’re all very…Continue
Pretty much every data rookie starts with Excel. It is a wonderful program for storing, cleaning and analysing (yes, you read that correctly) your data.
Strictly speaking, Excel isn’t free, but really – who pays for it these days? If you buy a Windows PC or laptop it’ll usually come pre-installed, and if you get a new PC at work your employer will have it pre-installed for you. If you’re prepared to look the other way, there are guys who know guys who can get you a copy that fell off…Continue