#Lets make a dancing bubble map
I'm going to draw on Mike Bostocks excellent Let's make a map and Let's make a bubble map tutorials to make a bubble map of my own.
The case where the bubbles overlap each other.
I've downloaded Population data for UK cities from the centre for cities website a charitable research organisation based in the UK.
The resulting csv file is slightly irregular in that it contains an extra 10 lines containing source and credit information. You can remove these lines by hand or use this rather conveluted command on in the Mac terminal:
tail -r population_2013.csv | sed '1,10d' | tail -r > temp.csv && mv temp.csv population_2013.csv
N.B this is rather convoluted because we need to reverse the order of the file with tail -r before removing the top ten lines and then reversing it once again. I'm sure there's a better way to do this!
The resulting file should look like this:
City,"Population 2013"
Aberdeen,227100
Aldershot,181900
Barnsley,235800
Belfast,675600
Birkenhead,320300
Birmingham,2453700
Blackburn,147400