My mission: to programmatically analyse and map postcode-level fixed connectivity data for Harrogate district
I thought this would be quite a quick job.
- I knew that I had the postcode-level data from Ofcom
- I knew that I had a script for looking up latitude and longitude from a postcode, using Chris Bell's API
- I was pretty sure that a list of postcodes in the district would be downloadable from the ONS Open Geography Portal
The easiest thing to do would have been to work in Excel using manually downloaded data from websites. But I wanted to construct a script to retrieve, process and combine the data [programatically][] and [reproducibly][] and preferably [DRY][]-ly as well.