Why I love Excel

It feels a bit weird to write a post about MS Excel, but I feel compelled to and I think it’s because I am a feeling a bit defensive of it lately. People love to hate Excel. From software developers to data analysts and many other professionals, there’s usually a …

How data gets cleaned – an example

Image courtesy of flickr https://www.flickr.com/photos/compacflt/34496068126/ Anyone interested in data analysis or the broader field of data science may have heard that about 80% of the work entails cleaning data. About a year ago I did some basic analysis on South African Schools data, and I happened to document the cleaning …