In Edinburgh, where is the best balance of old and young, and what happened to the gender balance…

In Edinburgh, where is the best balance of old and young, and what happened to the gender balance in Corstorphine?

As you may know, I love to analyse data, and in looking at correlating things. So I found this dataset on the open data Edinburgh site:

The dataset has so many problems in using it, and the on-line version had problems in analysing the data, so I converted it through my little Python script, and out popped an analysis.

So let’s look at the balance of male and female in each of the regions of Edinburgh [here][Web page]:

So why are there so many women in Corstorphine than in Leith (relative to men)? Well, perhaps it’s to do with women living a little longer than men. So let’s analyse the balance of babies and those over 65+ [Link][Web page]:

and now we see that Corstorphine Murrayfield has a high percentage of those between 65 and 84, but also a healthy number of those between 0 and 4, which means that perhaps those in the top right-hand region have a nice balance of young and old?

So if you’re at school in Edinburgh (12–15 years old), do you live in the areas that the 16–24-year-old people live? No. You can see that the top-right hand corner is empty. Those between 12 and 15 tend to be in the outer suburbs of Colinton, Faremilehead, and Almond, but head for the city areas of the Meadows, Morningside, Southside and Newington [here][Web page]:

But, if we remove the 45–64 year olds, we see that there is a strong correlation between the 0–15-year-old age range and 45–64 years old [here][Web page]:

Conclusion

There you go … but analysing open data you can tell a whole lot about your city.