Crime stats in Edinburgh 2008-2012

I had a quick look at some of the data provided by Edinburgh city council covering subjects from crime to rubbish collection. It's a good resource to have a look at how the city is functioning (although would be better to have data a bit more up to date!). Each source is in CSV format, so it's easy enough to ETL using the CSV library in python, along with some tidying up. For the crime stats, the data is broken down into different areas of the city. The graph here shows some of the reported crime statistics for 2011-12, where the size of the bubble represents the total number of reported crimes. I would expect the city centre to appear in the upper right corner, but Liberton&Gilmerton and South Central both look a bit anomalous compared to the others... More work to follow, with plots for each year and some further tidying. I'll also try to correlate with population numbers for each area and cross-link with some of the other data sources on the council website to see if any interesting patterns emerge.