A walk-through of how we practically clean and use a public dataset that is changing people's lives. The [Medicine Price Registry](http://mpr.gov.za/) is a spreadsheet published one or more times per year, with the latest prices and active ingredients for medicines registered for sale in South Africa. Like most data, it's dirty and has limited usability in its original form. We take you through some of the practical steps we take to clean the data and make it easier to analyse and use. This allows us, for example, to analyse how price competition from generics lower medicine prices, or not!

Making man-made medicine price data more useful

South Africa32