Python Pandas outlines for data analysis for Broadband coverage. The data is [here][Pandas analysis].
Broadband coverage |
Source code
The following outlines the Python code used:
import numpy as np import pandas as pd import sys import matplotlib.pyplot as plt xval = 'Violent Crime'; yval = 'Murder'; file='1111' ver=pd.read_csv("city.csv") plt.xlabel(xval) plt.ylabel(yval) plt.scatter(ver[xval],ver[yval]) plt.show() f2= file+".svg" plt.savefig(f2,format='SVG') f2= file+".png" plt.savefig(f2,format='PNG')
Data
The data used is [here]
Local Authority,Average sync speed (Mbps),Average sync speed score,Percentage not receiving 2Mbps,Percentage not receiving 2Mbps score,Superfast broadband availability,Superfast broadband availability score,Take-up (including superfast broadband),Take-up score,Superfast takeup,Overall Total of Scores,Quality Score,Data Throughput Abertawe - Swansea,19.7,1,8.00,2,77.50,2,70.50,2,25.20,7,1,29.9 Ards,18.5,1,10.20,3,95.30,1,69.60,3,24.20,8,1,27.3 Ballymena,16.3,1,15.90,4,87.40,2,66.10,3,21.00,10,2,25 Ballymoney,17.5,1,16.20,4,87.80,2,66.90,3,23.70,10,2,24.1 Banbridge,17,1,15.50,4,91.70,1,68.10,3,20.00,9,1,27.2 Bath and North East Somerset,16.1,1,9.50,2,69.20,3,79.90,2,17.50,8,1,26.5 Bedford ,19.5,1,12.00,3,77.10,2,78.30,2,27.40,8,1,30.1 Belfast,25.4,1,4.90,1,97.70,1,65.90,3,38.40,6,1,39.9 Birmingham District ,20.7,1,6.00,2,91.80,1,70.40,2,28.60,6,1,36.2 Blackpool ,18.2,1,6.30,2,73.30,2,69.00,3,18.70,8,1,35.8 Bolton District ,19.2,1,7.30,2,93.60,1,72.20,2,25.20,6,1,31.4 Bournemouth ,21.3,1,4.90,1,94.70,1,75.10,2,27.10,5,1,31 Bracknell Forest ,19,1,12.50,3,96.20,1,80.50,1,25.80,6,1,30.6 Bradford District ,19.1,1,6.90,2,92.50,1,69.80,3,25.20,7,1,31.6 Bro Morgannwg - the Vale of Glamorgan,17.6,1,9.20,2,70.00,2,77.20,2,21.80,7,1,27.9 Buckinghamshire County,16.5,1,9.20,2,72.90,2,80.80,1,19.10,6,1,26.7 Bury District ,16.7,1,8.30,2,94.70,1,72.90,2,20.20,6,1,31 Caerdydd - Cardiff,21.3,1,9.10,2,91.10,1,76.20,2,32.20,6,1,36.7 Cambridgeshire County,17.9,1,9.90,2,66.10,3,78.80,2,21.00,8,1,26.7 Carrickfergus,18.5,1,13.50,3,96.90,1,71.00,2,25.70,7,1,33.2 Casnewydd - Newport,19.4,1,9.20,2,84.00,2,72.60,2,26.50,7,1,33.8 Castell-nedd Port Talbot - Neath Port Talbot,17,1,10.60,3,61.10,3,68.80,3,20.30,10,2,26.7 Castlereagh,23.8,1,8.80,2,97.50,1,74.80,2,36.60,6,1,33.8 Central Bedfordshire,19.4,1,8.60,2,76.80,2,81.70,1,23.40,6,1,26.5 City of Bristol ,24.5,1,3.40,1,93.60,1,78.70,2,35.40,5,1,35.9 City of Derby ,22.5,1,6.60,2,95.90,1,70.90,2,32.10,6,1,33.5 City of Edinburgh,23.1,1,4.00,1,86.90,2,75.90,2,29.90,6,1,33.8 City of Leicester ,21.6,1,5.60,2,91.40,1,70.60,2,32.40,6,1,43.1 City of Nottingham ,23.4,1,5.40,2,92.90,1,65.80,3,35.40,7,1,43 City of Peterborough ,20.3,1,11.20,3,86.00,2,76.90,2,30.60,8,1,35.3 City of Plymouth ,22.5,1,6.60,2,96.80,1,74.60,2,33.50,6,1,30.9 City of Portsmouth ,24.6,1,5.40,2,96.40,1,75.80,2,36.70,6,1,40.2 City of Southampton ,19.1,1,6.00,2,91.70,1,73.40,2,23.60,6,1,38.4 City of Stoke-on-Trent ,17.9,1,8.50,2,82.20,2,66.00,3,24.30,8,1,29.8 City of Wolverhampton District ,22.2,1,4.80,1,97.00,1,66.00,3,32.60,6,1,35.1 Coleraine,20.4,1,11.60,3,96.10,1,57.30,4,31.80,9,1,29.6 Cookstown,16.8,1,22.10,5,87.70,2,64.70,3,24.40,11,2,27 Coventry District ,18.1,1,6.90,2,86.90,2,71.90,2,21.70,7,1,35.2 Craigavon,16.9,1,14.60,3,96.40,1,68.30,3,22.70,8,1,35.5 Darlington ,20.7,1,9.90,2,86.50,2,69.90,3,30.00,8,1,29.3 Derry,21.7,1,10.30,3,99.10,1,67.00,3,33.10,8,1,37 Down,18.9,1,15.30,4,94.50,1,67.60,3,26.40,9,1,26.9 Dudley District ,20.7,1,5.50,2,95.60,1,69.70,3,29.10,7,1,27.1 Dundee City,23.9,1,5.00,2,95.10,1,69.00,3,33.40,7,1,35.4 Dungannon,16.6,1,22.70,5,97.90,1,65.40,3,24.20,10,2,29.1 East Dunbartonshire,21.2,1,5.60,2,79.50,2,82.00,1,25.50,6,1,27.5 East Renfrewshire,21.2,1,5.10,2,86.30,2,81.50,1,25.90,6,1,29.6 Essex County,16.4,1,10.40,3,73.90,2,77.30,2,18.90,8,1,26.2 Falkirk,21.8,1,6.00,2,85.00,2,74.10,2,29.60,7,1,28.5 Fermanagh,17.3,1,20.90,5,90.00,1,68.20,3,27.20,10,2,21.8 Gateshead District ,19.4,1,6.80,2,71.40,2,69.90,3,24.40,8,1,28.7 Glasgow City,17.2,1,8.00,2,66.50,3,64.80,3,18.30,9,1,35.9 Halton ,17.6,1,11.70,3,83.80,2,74.60,2,21.80,8,1,32.3 Hampshire County,18.2,1,8.90,2,78.30,2,80.30,1,22.30,6,1,26.3 Hartlepool ,23.2,1,12.00,3,93.30,1,64.50,3,36.20,8,1,34 Hertfordshire County,22.5,1,7.80,2,90.30,1,81.00,1,31.40,5,1,38 Inverclyde,21.6,1,5.90,2,73.50,2,67.20,3,28.20,8,1,31.6 Kirklees District ,16.2,1,10.80,3,79.80,2,70.50,2,20.20,8,1,27.5 Knowsley District ,18.4,1,11.20,3,86.00,2,70.70,2,24.70,8,1,33.4 Leeds District ,18.3,1,9.00,2,86.60,2,71.00,2,23.40,7,1,30.5 Leicestershire County,17.2,1,9.50,2,70.00,2,77.30,2,20.50,7,1,25.3 Limavady,18,1,20.60,5,96.20,1,65.20,3,24.60,10,2,28.6 Lisburn,19.9,1,17.10,4,96.60,1,71.20,2,31.20,8,1,31.7 Liverpool District ,19.3,1,6.40,2,86.00,2,63.80,3,22.60,8,1,35.9 London,20.4,1,5.40,2,89.10,2,82.90,1,24.90,6,1,39.7 Luton ,24.3,1,8.40,2,98.60,1,77.00,2,37.70,6,1,41.7 Magherafelt,17.7,1,15.10,4,94.20,1,67.70,3,25.10,9,1,26.5 Manchester District ,17.8,1,8.10,2,86.70,2,68.90,3,21.40,8,1,41.6 Medway ,22.7,1,7.70,2,90.90,1,78.60,2,32.30,6,1,32.4 Middlesbrough ,23.4,1,6.50,2,95.40,1,66.70,3,34.30,7,1,34.6 Moyle,18.3,1,16.70,4,88.80,2,54.50,4,28.50,11,2,21.3 Newcastle upon Tyne District ,18.8,1,6.80,2,74.90,2,69.50,3,22.80,8,1,34.5 Newry and Mourne,17.1,1,18.20,4,95.90,1,65.80,3,23.80,9,1,28.1 Newtownabbey,22,1,9.60,2,98.90,1,73.20,2,32.10,6,1,34.8 North Down,19.6,1,12.10,3,98.40,1,72.10,2,30.00,7,1,31.7 North East Lincolnshire ,24.9,1,5.00,2,92.20,1,70.50,2,36.30,6,1,35.4 North Lanarkshire,19.4,1,11.20,3,74.60,2,72.20,2,25.10,8,1,29.9 North Tyneside District ,18.5,1,8.20,2,79.60,2,73.70,2,23.10,7,1,29.2 Northamptonshire County,17.5,1,9.80,2,73.80,2,77.70,2,21.20,7,1,29.9 Nottinghamshire County,19.2,1,9.50,2,79.90,2,74.50,2,25.30,7,1,27 Oldham District ,19.3,1,10.90,3,97.40,1,68.80,3,27.90,8,1,31.5 Oxfordshire County,17.4,1,9.20,2,69.10,3,80.50,1,20.20,7,1,27.8 Poole ,19.8,1,7.10,2,89.00,2,77.50,2,25.50,7,1,23.3 Reading ,22,1,5.30,2,95.00,1,73.10,2,29.00,6,1,40 Redcar and Cleveland ,22.3,1,7.00,2,90.80,1,70.90,2,32.50,6,1,28.7 Renfrewshire,19.5,1,7.50,2,72.70,2,70.20,2,24.10,7,1,30.2 Rochdale District ,16.9,1,11.00,3,96.20,1,68.80,3,21.50,8,1,31.3 Salford District ,20.8,1,6.20,2,91.10,1,68.90,3,25.70,7,1,37.8 Sandwell District ,18.3,1,6.50,2,80.40,2,66.00,3,23.00,8,1,33 Sefton District ,17,1,6.70,2,90.70,1,66.60,3,17.70,7,1,29 Slough ,19.6,1,12.30,3,96.60,1,76.50,2,27.80,7,1,39.4 Solihull District ,22,1,6.10,2,91.00,1,76.80,2,31.00,6,1,28 South Gloucestershire,20.6,1,8.50,2,81.80,2,81.10,1,29.10,6,1,27 South Lanarkshire,17.2,1,11.10,3,66.90,3,73.20,2,21.00,9,1,26.7 South Tyneside District ,20.8,1,9.50,2,90.90,1,65.60,3,30.80,7,1,37.4 Southend-on-Sea ,22.5,1,4.10,1,96.40,1,74.90,2,28.90,5,1,35 St. Helens District ,19.8,1,9.50,2,86.90,2,71.90,2,27.40,7,1,31 Stockport District ,22.3,1,4.80,1,98.60,1,76.80,2,29.60,5,1,30.4 Stockton-on-Tees ,23.1,1,8.50,2,91.10,1,73.50,2,34.50,6,1,29.4 Strabane,16.6,1,18.40,4,93.80,1,59.00,4,24.00,10,2,25 Sunderland District ,18,1,10.80,3,91.20,1,67.90,3,23.40,8,1,33.4 Surrey County,20,1,7.60,2,85.00,2,81.90,1,25.60,6,1,29.7 Swindon ,20.9,1,6.50,2,77.80,2,79.10,2,27.60,7,1,33.2 Tameside District ,17,1,6.60,2,93.70,1,71.00,2,19.20,6,1,32.5 Telford and Wrekin ,20.8,1,6.50,2,88.20,2,74.20,2,28.30,7,1,31.8 The City of Brighton and Hove ,24.1,1,4.80,1,95.00,1,87.30,1,33.10,4,1,37.7 Thurrock ,21.4,1,8.90,2,92.40,1,78.30,2,28.20,6,1,34.3 Trafford District ,21.5,1,5.80,2,93.60,1,77.50,2,28.20,6,1,32 Walsall District ,19.3,1,6.80,2,91.70,1,67.00,3,26.00,7,1,31.1 Warrington ,18.4,1,11.00,3,79.70,2,77.70,2,23.10,8,1,28.1 Warwickshire County,17.1,1,11.20,3,72.10,2,76.50,2,21.10,8,1,26.2 West Berkshire,16,1,9.90,2,65.10,3,79.00,2,16.70,8,1,25.2 West Dunbartonshire,23.9,1,5.00,2,90.80,1,69.50,3,34.50,7,1,32.6 West Lothian,16.2,1,8.70,2,59.70,3,77.70,2,16.50,8,1,31.1 West Sussex County,16.4,1,8.70,2,78.10,2,78.50,2,17.90,7,1,25.2 Wigan District ,20.8,1,7.30,2,93.80,1,72.20,2,28.60,6,1,28.3 Windsor and Maidenhead ,18.5,1,10.70,3,89.70,2,80.00,1,24.90,7,1,29.7 Wirral District ,16.4,1,7.10,2,70.90,2,73.10,2,16.60,7,1,30.3 Wokingham ,19.9,1,9.60,2,92.50,1,78.20,2,26.70,6,1,28.8 Aberdeen City,12.6,2,8.40,2,62.80,3,80.40,1,7.20,8,1,30.6 Angus,12.6,2,9.70,2,44.80,4,73.00,2,7.50,10,2,20.4 Antrim,15.9,2,14.90,3,92.50,1,69.80,3,19.20,9,1,32.1 Armagh,15.3,2,20.50,5,94.30,1,65.00,3,19.30,11,2,25.5 Barnsley District ,15,2,12.10,3,70.30,2,66.90,3,17.30,10,2,27.6 Blackburn with Darwen ,14.8,2,9.20,2,68.10,3,70.10,2,16.80,9,1,31.7 Caerffili - Caerphilly,10.6,2,15.80,4,65.00,3,69.20,3,7.70,12,3,26.6 Calderdale District ,14,2,10.70,3,67.00,3,69.30,3,14.30,11,2,25.7 Cheshire East ,15.8,2,10.30,3,82.50,2,75.70,2,17.90,9,1,24.9 Cheshire West and Chester ,13.7,2,10.80,3,66.60,3,75.50,2,12.70,10,2,24.8 City of Kingston upon Hull ,10.4,2,3.10,1,12.10,5,49.30,5,2.70,13,3,30.4 Clackmannanshire,10,2,17.10,4,50.50,3,74.00,2,5.10,11,2,24.5 Cornwall,13.3,2,12.50,3,69.60,3,71.70,2,11.00,10,2,20.9 County Durham,11.8,2,13.70,3,62.50,3,67.50,3,9.00,11,2,26 Derbyshire County,12.4,2,12.30,3,54.70,3,71.20,2,10.40,10,2,22.6 Devon County,11,2,13.40,3,37.20,4,73.90,2,6.90,11,2,16.4 Doncaster District ,15.2,2,10.80,3,76.10,2,69.30,3,15.90,10,2,29.5 Dorset County,10.9,2,12.50,3,46.50,4,75.80,2,6.50,11,2,17.3 East Lothian,10.3,2,8.50,2,20.10,5,75.60,2,2.90,11,2,21.8 East Riding of Yorkshire,11.6,2,9.00,2,21.60,5,69.60,3,4.40,12,3,19.5 East Sussex County,12,2,10.10,3,67.10,3,76.70,2,8.30,10,2,22.9 Fife,15,2,9.40,2,51.80,3,73.60,2,14.60,9,1,25.5 Gloucestershire County,15.2,2,11.50,3,53.80,3,77.10,2,16.60,10,2,22.3 Isle of Wight,11.4,2,9.50,2,50.60,3,66.90,3,3.40,10,2,22.2 Kent County,15.3,2,10.60,3,68.60,3,76.70,2,16.00,10,2,26.5 Lancashire County,14.4,2,10.40,3,67.70,3,72.10,2,13.90,10,2,26.4 Larne,15.2,2,15.80,4,81.60,2,64.70,3,18.10,11,2,27.6 Lincolnshire County,13.8,2,12.30,3,49.10,4,73.80,2,13.50,11,2,22.2 Milton Keynes ,15.5,2,15.00,4,82.00,2,82.10,1,18.10,9,1,34.7 Norfolk County,12.4,2,12.10,3,42.40,4,73.30,2,10.40,11,2,20.5 North Lincolnshire ,15.5,2,16.60,4,54.30,3,70.90,2,18.30,11,2,25.7 North Somerset,13.2,2,9.00,2,64.00,3,80.60,1,11.60,8,1,23.2 North Yorkshire County,12.1,2,12.70,3,47.80,4,73.10,2,8.70,11,2,18.6 Northumberland,10.5,2,13.80,3,49.60,4,71.10,2,6.20,11,2,20.8 Omagh,14.4,2,24.30,5,92.10,1,61.40,3,19.00,11,2,22.2 Pen-y-bont ar Ogwr - Bridgend,11.8,2,13.80,3,67.10,3,71.90,2,9.80,10,2,26.3 Perth and Kinross,14.1,2,11.00,3,36.70,4,73.30,2,13.00,11,2,18.3 Rhondda Cynon Taf - Rhondda Cynon Taff,11.4,2,15.60,4,55.50,3,67.30,3,9.00,12,3,27.6 Rotherham District ,13.9,2,10.90,3,72.60,2,70.30,2,13.80,9,1,27.8 Scottish Borders,10.3,2,10.70,3,20.30,5,70.10,2,4.00,12,3,14.2 Sheffield District ,15.4,2,11.60,3,81.30,2,68.50,3,17.70,10,2,28.9 Shropshire,10,2,14.80,3,30.30,4,72.30,2,5.40,11,2,16.1 Sir Fynwy - Monmouthshire,10.8,2,13.10,3,45.00,4,73.90,2,6.60,11,2,19 Sir y Fflint - Flintshire,11.2,2,13.80,3,57.10,3,74.30,2,9.50,10,2,24.1 Somerset County,10.1,2,13.00,3,40.50,4,75.80,2,5.30,11,2,17.7 Staffordshire County,14.9,2,11.70,3,70.40,2,73.60,2,16.80,9,1,23.8 Stirling,11.4,2,12.00,3,59.50,3,73.10,2,8.80,10,2,23.1 Suffolk County,13.6,2,13.70,3,59.10,3,75.00,2,13.40,10,2,21.9 Torbay ,14.7,2,5.90,2,72.50,2,71.20,2,11.20,8,1,24.4 Tor-faen - Torfaen,11.8,2,14.10,3,55.00,3,72.00,2,11.00,10,2,27.1 Wakefield District ,14.3,2,12.50,3,84.70,2,69.10,3,15.40,10,2,28.8 Wiltshire,14.3,2,9.90,2,54.10,3,79.50,2,14.00,9,1,20.5 Worcestershire County,14.5,2,11.70,3,72.30,2,75.10,2,16.90,9,1,23.9 Wrecsam - Wrexham,10.3,2,12.90,3,56.70,3,71.60,2,6.70,10,2,23.3 York ,15.8,2,8.90,2,78.10,2,75.00,2,17.00,8,1,26.8 Aberdeenshire,8.4,3,12.30,3,3.60,5,78.60,2,0.30,13,3,16.8 Blaenau Gwent - Blaenau Gwent,9.8,3,10.80,3,6.90,5,63.20,3,0.20,14,4,26.2 Conwy - Conwy,8.5,3,13.20,3,3.30,5,69.80,3,0.10,14,4,19.2 County of Herefordshire,9.1,3,18.00,4,33.80,4,71.40,2,5.20,13,3,15.7 Cumbria County,8.4,3,16.30,4,26.00,5,69.00,3,1.90,15,4,16.8 Dumfries and Galloway,8,3,12.90,3,6.00,5,66.60,3,0.40,14,4,14 East Ayrshire,8.8,3,16.30,4,37.20,4,67.10,3,3.30,14,4,22.1 Gwynedd - Gwynedd,8,3,16.50,4,24.10,5,62.00,3,1.30,15,4,15.6 Midlothian,8.5,3,19.10,4,29.10,5,74.70,2,3.60,14,4,19.2 Moray,8.3,3,12.00,3,0.00,5,75.30,2,0.00,13,3,17.7 North Ayrshire,9.9,3,10.00,3,27.00,5,65.50,3,1.90,14,4,24.3 Rutland,8.2,3,17.60,4,7.20,5,75.90,2,1.20,14,4,13.6 Sir Ddinbych - Denbighshire,9.5,3,11.90,3,29.50,5,71.80,2,1.40,13,3,20.7 Sir Ynys Mon - Isle of Anglesey,8.4,3,15.30,4,10.30,5,66.80,3,0.80,15,4,14.7 South Ayrshire,8.3,3,11.30,3,8.80,5,68.00,3,0.40,14,4,19.1 Argyll and Bute,6.4,4,12.80,3,0.10,5,67.30,3,0.00,15,4,11.6 Highland,7.3,4,14.60,3,3.60,5,71.00,2,0.80,14,4,13.5 Merthyr Tudful - Merthyr Tydfil,6.8,4,15.80,4,0.00,5,64.50,3,0.00,16,5,24.9 Orkney Islands,7.8,4,15.20,4,0.00,5,69.90,3,0.00,16,5,10.4 Powys - Powys,7.2,4,17.80,4,0.00,5,66.20,3,0.00,16,5,11.5 Shetland Islands,6.9,4,14.40,3,0.00,5,76.10,2,0.00,14,4,11.8 Sir Benfro - Pembrokeshire,7.2,4,18.80,4,0.10,5,65.20,3,0.00,16,5,12.4 Sir Ceredigion - Ceredigion,6.3,4,21.70,5,0.00,5,66.40,3,0.00,17,5,11.8 Sir Gaerfyrddin - Carmarthenshire,7.1,4,19.60,4,22.10,5,67.20,3,0.60,16,5,16.3 Isles of Scilly,4.4,5,22.30,5,0.00,5,69.90,3,0.00,18,5,7.8 Na H-Eileanan an Iar,5.1,5,19.00,4,0.00,5,49.40,5,0.00,19,5,8.5