{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Numbers of Patients Registered at a GP Practice\n", "21/2/17\n", "Number of patients registred with a particular GP who live in a particular LSOA (/via Carl Baker, HoC Library)\n", "\n", "Demo sketch of opening data into an interactive *Google Map*." ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [ "#Original data source\n", "#http:§§//www.content.digital.nhs.uk/catalogue/PUB23139" ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": false }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "--2017-02-21 14:02:29-- http://www.content.digital.nhs.uk/catalogue/PUB23139/gp-reg-patients-LSOA-alt-tall.csv\n", "Resolving www.content.digital.nhs.uk... 194.189.27.28\n", "Connecting to www.content.digital.nhs.uk|194.189.27.28|:80... connected.\n", "HTTP request sent, awaiting response... 200 OK\n", "Length: 38732373 (37M) [application/octet-stream]\n", "Saving to: 'data/gp-reg-patients-LSOA-alt-tall.csv'\n", "\n", "gp-reg-patients-LSO 100%[=====================>] 36.94M 1.45MB/s in 30s \n", "\n", "2017-02-21 14:03:02 (1.22 MB/s) - 'data/gp-reg-patients-LSOA-alt-tall.csv' saved [38732373/38732373]\n", "\n" ] } ], "source": [ "#Get the datafile\n", "!wget -P data http://www.content.digital.nhs.uk/catalogue/PUB23139/gp-reg-patients-LSOA-alt-tall.csv" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": true }, "outputs": [], "source": [ "#Import best ever data handling package\n", "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", " | PRACTICE_CODE | \n", "NAME | \n", "LSOA_CODE | \n", "MALE_PATIENTS | \n", "FEMALE_PATIENTS | \n", "ALL_PATIENTS | \n", "
---|---|---|---|---|---|---|
0 | \n", "A81001 | \n", "THE DENSHAM SURGERY | \n", "E01012187 | \n", "0 | \n", "4 | \n", "4 | \n", "
1 | \n", "A81001 | \n", "THE DENSHAM SURGERY | \n", "E01012188 | \n", "42 | \n", "45 | \n", "87 | \n", "
2 | \n", "A81001 | \n", "THE DENSHAM SURGERY | \n", "E01012189 | \n", "22 | \n", "28 | \n", "50 | \n", "
3 | \n", "A81001 | \n", "THE DENSHAM SURGERY | \n", "E01012190 | \n", "63 | \n", "86 | \n", "149 | \n", "
4 | \n", "A81001 | \n", "THE DENSHAM SURGERY | \n", "E01012191 | \n", "71 | \n", "83 | \n", "154 | \n", "
\n", " | Organisation Code | \n", "Name | \n", "National Grouping | \n", "High Level Health Geography | \n", "Address Line 1 | \n", "Address Line 2 | \n", "Address Line 3 | \n", "Address Line 4 | \n", "Address Line 5 | \n", "Postcode | \n", "... | \n", "Close Date | \n", "Status Code | \n", "Organisation Sub-Type code | \n", "Commissioner | \n", "Join Provider/Purchaser Date | \n", "Left Provider/Purchaser Date | \n", "Contact Telephone Number | \n", "Amended Record Indicator | \n", "Provider/Purchaser | \n", "Prescribing Setting | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "J84003 | \n", "VENTNOR MEDICAL CENTRE | \n", "Y57 | \n", "Q70 | \n", "VENTNOR MEDICAL CENTRE | \n", "3 ALBERT STREET | \n", "VENTNOR | \n", "ISLE OF WIGHT | \n", "None | \n", "PO38 1EZ | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 857288 | \n", "0 | \n", "10L | \n", "4 | \n", "
1 | \n", "J84004 | \n", "EAST COWES MEDICAL CENTRE | \n", "Y57 | \n", "Q70 | \n", "EAST COWES MEDICAL CENTRE | \n", "CHURCH PATH | \n", "EAST COWES | \n", "ISLE OF WIGHT | \n", "None | \n", "PO32 6RP | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 284333 | \n", "0 | \n", "10L | \n", "4 | \n", "
2 | \n", "J84005 | \n", "ESPLANADE SURGERY | \n", "Y57 | \n", "Q70 | \n", "THE ESPLANADE SURGERY | \n", "19 THE ESPLANADE | \n", "RYDE | \n", "ISLE OF WIGHT | \n", "None | \n", "PO33 2EH | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 618388 | \n", "0 | \n", "10L | \n", "4 | \n", "
3 | \n", "J84007 | \n", "ST.HELENS MEDICAL CENTRE | \n", "Y57 | \n", "Q70 | \n", "ST.HELENS MEDICAL CENTRE | \n", "UPPER GREEN ROAD | \n", "ST.HELENS | \n", "ISLE OF WIGHT | \n", "None | \n", "PO33 1UG | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 871828 | \n", "0 | \n", "10L | \n", "4 | \n", "
4 | \n", "J84008 | \n", "ARGYLL HOUSE | \n", "Y57 | \n", "Q70 | \n", "ARGYLL HOUSE | \n", "WEST STREET | \n", "RYDE | \n", "ISLE OF WIGHT | \n", "None | \n", "PO33 2QG | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 562955 | \n", "0 | \n", "10L | \n", "4 | \n", "
5 | \n", "J84010 | \n", "SHANKLIN MEDICAL CENTRE | \n", "Y57 | \n", "Q70 | \n", "SHANKLIN MEDICAL CENTRE | \n", "CARTER ROAD | \n", "SHANKLIN | \n", "ISLE OF WIGHT | \n", "None | \n", "PO37 7HR | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 862245 | \n", "0 | \n", "10L | \n", "4 | \n", "
6 | \n", "J84011 | \n", "CARISBROOKE HEALTH CENTRE | \n", "Y57 | \n", "Q70 | \n", "CARISBROOKE HEALTH CENTRE | \n", "22 CARISBROOKE HIGH ST. | \n", "CARISBROOKE, NEWPORT | \n", "ISLE OF WIGHT | \n", "None | \n", "PO30 1NR | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 522150 | \n", "0 | \n", "10L | \n", "4 | \n", "
7 | \n", "J84012 | \n", "TOWER HOUSE SURGERY | \n", "Y57 | \n", "Q70 | \n", "TOWER HOUSE SURGERY | \n", "RINK ROAD | \n", "RYDE | \n", "ISLE OF WIGHT | \n", "None | \n", "PO33 1LP | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 817200 | \n", "0 | \n", "10L | \n", "4 | \n", "
8 | \n", "J84013 | \n", "SANDOWN HEALTH CENTRE | \n", "Y57 | \n", "Q70 | \n", "SANDOWN HEALTH CENTRE | \n", "BROADWAY | \n", "SANDOWN | \n", "ISLE OF WIGHT | \n", "None | \n", "PO36 9GA | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01938 409292 | \n", "0 | \n", "10L | \n", "4 | \n", "
9 | \n", "J84014 | \n", "THE DOWER HOUSE | \n", "Y57 | \n", "Q70 | \n", "THE DOWER HOUSE | \n", "27 PYLE STREET | \n", "NEWPORT | \n", "ISLE OF WIGHT | \n", "None | \n", "PO30 1JW | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 523525 | \n", "0 | \n", "10L | \n", "4 | \n", "
10 | \n", "J84015 | \n", "COWES MEDICAL CENTRE | \n", "Y57 | \n", "Q70 | \n", "COWES MEDICAL CENTRE | \n", "200 NEWPORT ROAD | \n", "COWES | \n", "ISLE OF WIGHT | \n", "None | \n", "PO31 7ER | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 295251 | \n", "0 | \n", "10L | \n", "4 | \n", "
11 | \n", "J84016 | \n", "SOUTH WIGHT MEDICAL PRACTICE | \n", "Y57 | \n", "Q70 | \n", "THE SURGERY | \n", "BLACKGANG ROAD | \n", "NITON | \n", "ISLE OF WIGHT | \n", "None | \n", "PO38 2BN | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 740219 | \n", "0 | \n", "10L | \n", "4 | \n", "
12 | \n", "J84017 | \n", "MEDINA HEALTHCARE | \n", "Y57 | \n", "Q70 | \n", "MEDINA HEALTHCARE | \n", "16 WEST STREET | \n", "NEWPORT | \n", "ISLE OF WIGHT | \n", "None | \n", "PO30 1PR | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 522198 | \n", "0 | \n", "10L | \n", "4 | \n", "
13 | \n", "J84018 | \n", "GROVE HOUSE SURGERY | \n", "Y57 | \n", "Q70 | \n", "GROVE HOUSE SURGERY | \n", "102 ALBERT STREET | \n", "VENTNOR | \n", "ISLE OF WIGHT | \n", "None | \n", "PO38 1EU | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 852427 | \n", "0 | \n", "10L | \n", "4 | \n", "
14 | \n", "J84019 | \n", "WEST WIGHT MEDICAL PRACTICE | \n", "Y57 | \n", "Q70 | \n", "BROOKSIDE HEALTH CENTRE | \n", "QUEENS ROAD | \n", "FRESHWATER | \n", "ISLE OF WIGHT | \n", "None | \n", "PO40 9DT | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 758998 | \n", "0 | \n", "10L | \n", "4 | \n", "
15 | \n", "J84020 | \n", "BEECH GROVE SURGERY | \n", "Y57 | \n", "Q70 | \n", "BEECH GROVE SURGERY | \n", "THE MALL | \n", "BRADING | \n", "ISLE OF WIGHT | \n", "None | \n", "PO36 0DE | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 407558 | \n", "0 | \n", "10L | \n", "4 | \n", "
16 | \n", "J84602 | \n", "GARFIELD ROAD SURGERY | \n", "Y57 | \n", "Q70 | \n", "18 GARFIELD ROAD | \n", "RYDE | \n", "ISLE OF WIGHT | \n", "None | \n", "None | \n", "PO33 2PT | \n", "... | \n", "None | \n", "D | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 565103 | \n", "0 | \n", "10L | \n", "4 | \n", "
17 | \n", "J84606 | \n", "DR IRIS | \n", "Y57 | \n", "Q70 | \n", "102 CARISBROOKE ROAD | \n", "NEWPORT | \n", "ISLE OF WIGHT | \n", "None | \n", "None | \n", "PO30 1DB | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 526654 | \n", "0 | \n", "10L | \n", "8 | \n", "
18 | \n", "Y00355 | \n", "RYDE OUTPATIENTS DEPARTMENT | \n", "Y57 | \n", "Q70 | \n", "SWANMORE ROAD | \n", "RYDE | \n", "ISLE OF WIGHT | \n", "None | \n", "None | \n", "PO33 2TG | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 524081 | \n", "0 | \n", "10L | \n", "10 | \n", "
19 | \n", "Y00438 | \n", "INTERMEDIATE CARE SERVICES | \n", "Y57 | \n", "Q70 | \n", "OLD GATCOMBE WARD | \n", "ST MARY'S HOSPITAL | \n", "NEWPORT | \n", "ISLE OF WIGHT | \n", "None | \n", "PO30 5TG | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 535439 | \n", "0 | \n", "10L | \n", "0 | \n", "
20 | \n", "Y00588 | \n", "ISLAND HEALTH LINE | \n", "Y57 | \n", "Q70 | \n", "ST MARY'S HOSPITAL | \n", "PARKHURST ROAD | \n", "NEWPORT | \n", "ISLE OF WIGHT | \n", "None | \n", "PO30 5TG | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 534171 | \n", "0 | \n", "10L | \n", "0 | \n", "
21 | \n", "Y01856 | \n", "STOMA CARE (ST MARY'S HOSPITAL) | \n", "Y57 | \n", "Q70 | \n", "ST MARY'S HOSPITAL | \n", "None | \n", "NEWPORT | \n", "ISLE OF WIGHT | \n", "None | \n", "PO30 5TG | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 534009 | \n", "0 | \n", "10L | \n", "10 | \n", "
22 | \n", "Y01857 | \n", "PARKINSON'S DISEASE SPECIALIST CLINIC | \n", "Y57 | \n", "Q70 | \n", "ST MARY'S HOSPITAL | \n", "None | \n", "NEWPORT | \n", "ISLE OF WIGHT | \n", "None | \n", "PO30 5TG | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 524081 | \n", "0 | \n", "10L | \n", "0 | \n", "
23 | \n", "Y01858 | \n", "PRIMARY CARE PRESCRIBING TEAM | \n", "Y57 | \n", "Q70 | \n", "IOW NHS PCT,SOUTH BLOCK | \n", "ST MARY'S HOSPITAL | \n", "NEWPORT | \n", "ISLE OF WIGHT | \n", "None | \n", "PO30 5TG | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 552466 | \n", "0 | \n", "10L | \n", "0 | \n", "
24 | \n", "Y02694 | \n", "COMMUNITY DERMATOLOGY SERVICE | \n", "Y57 | \n", "Q70 | \n", "THE BEACON HEALTH CENTRE | \n", "PARKHURST ROAD | \n", "NEWPORT | \n", "ISLE OF WIGHT | \n", "None | \n", "PO30 5TG | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 532590 | \n", "0 | \n", "10L | \n", "9 | \n", "
25 | \n", "Y02758 | \n", "BEACON HEALTH | \n", "Y57 | \n", "Q70 | \n", "ST MARY'S HOSPITAL | \n", "None | \n", "NEWPORT | \n", "ISLE OF WIGHT | \n", "None | \n", "PO30 5TG | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 821170 | \n", "0 | \n", "10L | \n", "1 | \n", "
26 | \n", "Y03833 | \n", "ISLE OF WIGHT NHS TRUST NMP | \n", "Y57 | \n", "Q70 | \n", "ST MARY'S HOSPITAL | \n", "None | \n", "NEWPORT | \n", "ISLE OF WIGHT | \n", "None | \n", "PO30 5TG | \n", "... | \n", "None | \n", "A | \n", "B | \n", "10L | \n", "2013-04-01 00:00:00 | \n", "None | \n", "01983 524081 | \n", "0 | \n", "R1F | \n", "0 | \n", "
27 rows × 21 columns
\n", "