Skip to content

Instantly share code, notes, and snippets.

View mikeshewring's full-sized avatar

mikeshewring

View GitHub Profile
NAME_2 net
1 Anglesey -23.3568022728296
2 Blaenau Gwent 18.7456058787865
3 Bridgend 458.700569604013
4 Caerphilly 201.727496349332
5 Cardiff 6.81089095827589
6 Carmarthenshire 1727.71018151123
7 Denbighshire 1557.24021521561
8 Flintshire 90.0099099414542
9 Powys 7326.06409260615
NAME_2 TYPE_2 sumgain
Anglesey Unitary Authority 1588488.76
Blaenau Gwent Unitary Authority 1594541.61
Bridgend Unitary Authority 2849181.79
Caerphilly Unitary Authority 2020087.90
Cardiff Unitary Authority 74016.04
Carmarthenshire Unitary Authority 26481828.17
Denbighshire Unitary Authority 11425173.81
Flintshire Unitary Authority 1112308.29
Powys Unitary Authority 79875014.34
We can make this file beautiful and searchable if this error is corrected: It looks like row 10 should actually have 10 columns, instead of 9. in line 9.
ENGTYPE_2,GID_0,GID_1,GID_2,HASC_2,NAME_0,NAME_1,NAME_2,TYPE_2,sumloss
Unitary Authority,GBR,GBR.4_1,GBR.4.1_1,GB.AY,United Kingdom,Wales,Anglesey,Unitary Authority,1354920.733
Unitary Authority,GBR,GBR.4_1,GBR.4.2_1,GB.BG,United Kingdom,Wales,Blaenau Gwent,Unitary Authority,1781997.673
Unitary Authority,GBR,GBR.4_1,GBR.4.3_1,GB.BJ,United Kingdom,Wales,Bridgend,Unitary Authority,7436187.485
Unitary Authority,GBR,GBR.4_1,GBR.4.4_1,GB.CP,United Kingdom,Wales,Caerphilly,Unitary Authority,4037362.859
Unitary Authority,GBR,GBR.4_1,GBR.4.5_1,GB.CA,United Kingdom,Wales,Cardiff,Unitary Authority,142124.9505
Unitary Authority,GBR,GBR.4_1,GBR.4.6_1,GB.CI,United Kingdom,Wales,Carmarthenshire,Unitary Authority,4.38E+07
Unitary Authority,GBR,GBR.4_1,GBR.4.9_1,GB.DI,United Kingdom,Wales,Denbighshire,Unitary Authority,2.70E+07
Unitary Authority,GBR,GBR.4_1,GBR.4.10_1,GB.FL,United Kingdom,Wales,Flintshire,Unitary Authority,2012407.391
Unitary Authority,GBR,GBR.4_1,GBR.4.17_1,GB.PO,United Kingdom,Wales,Powys,Unitary Authority