Exercises/Ex.2 - Data Science with Jupyter.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<img src = http://i1377.photobucket.com/albums/ah57/drmingle1/Jupyter%20-%20Healthcare%20Data%20Science/BosDataFestival2015_zpsqpbcvzw8.png alt=\"Matrix\" style=\"width: 600px;\"/>\n",
    "\n",
    "\n",
    "# Finding Type II Diabetes In A Patient Population\n",
    "Given a year of EHR data for patients without Diabetes, we predict which patients will be diagnosed with Diabetes in the next year."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "***************************\n",
    "#Excercise 2\n",
    "\n",
    "Choose between A and B.\n",
    "***************************"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Data Scientist A\n",
    "\n",
    "#PHASE II: Data Understanding\n",
    "\n",
    "######Collect Initial Data\n",
    "\n",
    "1. Initial data collection report\n",
    "\n",
    "**Allergy**\n",
    "This table contains a list of allergies recorded for a patient.\n",
    "\n",
    "Key|Column Name|Data Type | Description\n",
    "-|-|-|-\n",
    "    PK|AllergyGuid|UNIQUEIDENTIFIER NOT NULL| Unique identifier for the patient allergy record.\n",
    "    FK|PatientGuid|UNIQUEIDENTIFIER|Identifier for the patient.\n",
    "     |AllergyType|NVARCHAR(100) NOT NULL| Substance to twhich the patient has shown allergy. Values: Animal Dander(Contact); Baker's Yeast; Dairy; Dust(Inhaled); Dust Mites (Contact); Egg; Insect Stings (Contact); Latex(Contact); Medication; Melons, Bananas, Cucumbers (Ragweed Pollen); Mold (inhaled); Nickel (Contact); Other nuts; Peanut; Pollen (inhalled); Seafood; Shellfish; Soy: Wheat\n",
    "      |Startyear|SMALLINT NOT NULL| Year of onset for the allergy.\n",
    "      |ReactionName|NVARCHAR(100) NULL|Allergic reaction reported by the patient. Values: Bloating/gas; Bradycardia; Chest Pain;Conjunctivitis; Cough; Diarrhea; Difficulty speaking or swallowing; Dizziness/Lightheadedness; Facial swelling; Hives; Irregular Heartbeat; Itchiness; Loss of consciousness; Nausea; Pain/cramping; Patchy swellingskin; Rash - generalized; Rash - localized; Respiratory Distress; Runny nose; Shortness of breath; Tachycardia; Tongue swelling; Vomiting; Wheezing\n",
    "      |Severityname|NVARCHAR(100) NULL| Severity of the patient allergy. Values: Very Mild; Mild; Modest; Severe.\n",
    "      |MedicationNdcCode|NVARCHAR(50) NULL|National Drug Code (NDC) identifier for medication taken by the patient for the allergy.\n",
    "      |UserGuid|UNIQUEIDENTIFIER NOT NULL| Identifier for the provider who recorded the allergy.\n",
    "\n",
    "\n",
    "**Condition**\n",
    "Reference table containing valid patient conditions.\n",
    "\n",
    "Key|Column Name|Data Type | Description\n",
    "-|-|-|-\n",
    "    PK|ConditionGuid|UNIQUEIDENTIFIER NOT NULL|Unique identifier for a condition.\n",
    "    |Code|NVARCHAR(50)NOT NULL| Code for the condition.\n",
    "    |Name|NVARCHAR(100) NOT NULL| Description of the condition.\n",
    "\n",
    "**Diagnosis**\n",
    "This table contains a list of diagnoses for a patient. \n",
    "\n",
    "Key|Column Name|Data Type | Description\n",
    "-|-|-|-\n",
    "    PK|DiagnosisGuid|UNIQUEIDENTIFIER NOT NULL|Unique identifier for a patient diagnosis.\n",
    "    FK|PatientGuid|UNIQUEIDENTIFIER NOT NULL|Identifier for the patient.\n",
    "    |ICD9Code|NVARCHAR(50) NOT NULL|ICD9 code for the diagnosis. (See http://en.wikipedia.org/wiki/List_of_ICD-9_codes)\n",
    "    |DiagnosisDescription|NVARCHAR(256) NOT NULL|Description of ICD9 code.\n",
    "    |StartYear|SMALLINT NULL|Year for the onset of the diagnosis.\n",
    "    |StopYear|SMALLINT NULL|Year for the end of the diagnosis.\n",
    "    |Acute|BIT NULL|Is the diagnosis an acute condition? If not acute, then the condition is considered chronic. Values: 1 = Acute; 0 = Chronic.\n",
    "|UserGuid|UNIQUEIDENTIFIER NOT NULL|Unique identifier for the provider who recorded the diagnosis.\n",
    "\n",
    "**Immunization**\n",
    "This table contains a list of immunizations for a patient. \n",
    "\n",
    "Key|Column Name|Data Type | Description\n",
    "-|-|-|-\n",
    "PK|ImmunizationGuid|UNIQUEIDENTIFIER NOT NULL|Unique identifier for the patient immunization record.\n",
    "FK|PatientGuid|UNIQUEIDENTIFIER NOT NULL|Identifier for the patient.\n",
    "|VaccineName|NVARCHAR(256) NULL|Name of the vaccine administered to the patient.\n",
    "|AdministeredYear|SMALLINT NULL|Year the vaccine was administered.\n",
    "|CvxCode|NVARCHAR(100) NULL|CVX code for the administered vaccine (CDC).\n",
    "|UserGuid|UNIQUEIDENTIFIER NOT NULL|Identifier for the provider who recorded the immunization.\n",
    "\n",
    "**LabObservation**\n",
    "This table contains lab test observations for a lab panel.\n",
    "\n",
    "Key|Column Name|Data Type | Description\n",
    "-|-|-|-\n",
    "    PK|LabObservationGuid|UNIQUEIDENTIFIER NOT NULL|Unique identifier for the lab test observation.\n",
    "    FK|LabPanelGuid|UNIQUEIDENTIFIER NULL|Identifier for the lab test panel.\n",
    "    |HL7Identifier|NVARCHAR(255) NOT NULL|Code for the lab test observation, as provided by the lab facility.\n",
    "    |HL7Text|NVARCHAR(255) NOT NULL|Name of the lab test observation, as provided by the lab facility.\n",
    "    |HL7CodingSystem|NVARCHAR(255) NOT NULL|Observation coding system used for the lab testobservation code in column HL7Identifier.Values: LN = LOINC.\n",
    "    |IsLoinc|BIT NOT NULL|[Not used]\n",
    "    |ObservationValue|NVARCHAR(255) NOT NULL|Value for the lab test observation.\n",
    "    |IsValidValue|BIT NOT NULL|[Not used]\n",
    "    |Units|NVARCHAR(255) NULL|Units of measure for the lab test observation value.\n",
    "    |ReferenceRange|NVARCHAR(255) NULL|Range for normal lab test observation value.\n",
    "    |AbnormalFlags|NVARCHAR(255) NULL|Flags for abnormal lab test observation value. Values: Abnormal Result; Abnormal; Above Normal High; Alert High; Alert Low; Below Normal Low; Panic High; Panic Low; UKNOWN.\n",
    "    |ResultStatus|NVARCHAR(255) NULL|Status of the lab test observation.     Values: Corrected; Final; Incomplete; Not Performed; Preliminary; UKNOWN; UNKNOWN.\n",
    "    |ObservationYear|SMALLINT NULL|Year the lab test observation was performed.\n",
    "    |ObservationMethod|NVARCHAR(255) NULL|[Not used]\n",
    "    |UserGuid|UNIQUEIDENTIFIER NULL|Identifier for the provider for the lab test result.\n",
    "    |IsAbnormalValue|BIT NULL|Indicator whether the lab test observation is abnormal.\n",
    "    |Sequence|INT NULL|Sequence of the lab test observation for the lab test     panel.\n",
    "\n",
    "\n",
    "\n",
    "**LabPanel**\n",
    "This table contains lab test panels reported in a patient lab test result.\n",
    "\n",
    "Key|Column Name|Data Type | Description\n",
    "-|-|-|-\n",
    "    PK|LabPanelGuid|UNIQUEIDENTIFIER NOT NULL|Unique identifier for the lab test panel performed.\n",
    "    FK|LabResultGuid|UNIQUEIDENTIFIER NOT NULL|Identifier for the lab test result. \n",
    "    |PanelName|NVARCHAR(255) NULL|Name of the lab test panel.\n",
    "    |ObservationYear|SMALLINT NULL|Year the lab test panel was performed.\n",
    "    |DangerCode|NVARCHAR(255) NULL|[Not used]\n",
    "    |Status|NVARCHAR(255) NULL|Status of the lab test panel. Values: Cancelled; Corrected; Final; Incomplete; Not Performed; Preliminary; UKNOWN; UNKNOWN.\n",
    "    |Sequence|INT NULL|Sequence of the lab test panel within the lab test result.\n",
    "\n",
    "**LabResult**\n",
    "This table contains patient lab test results received from a lab facility.\n",
    "\n",
    "Key|Column Name|Data Type | Description\n",
    "-|-|-|-\n",
    "    PK|LabResultGuid|UNIQUEIDENTIFIER NOT NULL|Unique identifier for the lab test result.\n",
    "    |UserGuid|UNIQUEIDENTIFIER NULL|Identifier for the provider who ordered the lab test.\n",
    "    FK|PatientGuid|UNIQUEIDENTIFIER NULL|Identifier for the patient.\n",
    "    FK|TranscriptGuid|UNIQUEIDENTIFIER NULL|Patient visit transcript for the lab test order.\n",
    "    |PracticeGuid|UNIQUEIDENTIFIER NULL|Identifier for the provider's medical practice.\n",
    "    |FacilityGuid|UNIQUEIDENTIFIER NULL|Identifier for the facility performing the lab test.\n",
    "    |ReportYear|SMALLINT NULL| Year the lab result was created.\n",
    "    FK|AncestorLabResultGuid|UNIQUEIDENTIFIER NULL|Prior lab test result to which this result is related.\n",
    "\n",
    "**Medication**\n",
    "This table contains the medication history for a patient.\n",
    "\n",
    "Key|Column Name|Data Type | Description\n",
    "-|-|-|-\n",
    "    PK|MedicationGuid|UNIQUEIDENTIFIER NOT NULL|Unique identifier for a patient medication.\n",
    "    FK|PatientGuid|UNIQUEIDENTIFIER NOT NULL|Identifier for the patient taking the medication.\n",
    "    |NdcCode|NVARCHAR(50) NULL|NDC code for the medication. (See http://www.fda.gov/drugs/informationondrugs/ucm142438.htm)\n",
    "    |MedicationName|NVARCHAR(256) NULL|Name of the medication.\n",
    "    |MedicationStrength|NVARCHAR(50) NULL|Strength of the medication.\n",
    "    |Schedule|NVARCHAR(50) NULL|Controlled substance schedule. (See http://www.deadiversion.usdoj.gov/schedules/index.html)\n",
    "    FK|DiagnosisGuid|UNIQUEIDENTIFIER NULL|Identifier for the diagnosis that the provider linked to the medication.\n",
    "    |UserGuid|UNIQUEIDENTIFIER NOT NULL|Identifier of the provider who added the medication.\n",
    "\n",
    "**Patient**\n",
    "This table contains a header record for each patient.\n",
    "\n",
    "Key|Column Name|Data Type | Description\n",
    "-|-|-|-\n",
    "    PK|PatientGuid|UNIQUEIDENTIFIER NOT NULL|Unique identifier for a patient record.\n",
    "    |Gender|NVARCHAR(1) NOT NULL|Patient gender. Values: M = Male; F = Female.\n",
    "    |YearOfBirth| SMALLINT NOT NULL|Patient's year of birth.\n",
    "    |State| NVARCHAR(2) NOT NULL| State abbreviation for the state in which the patient lives.\n",
    "    |PracticeGuid |UNIQUEIDENTIFIER NOT NULL| Identifier for the practice whose providers are seeing the patient. \n",
    "\n",
    "**PatientCondition**\n",
    "This table lists conditions for a patient. \n",
    "\n",
    "Key|Column Name|Data Type | Description\n",
    "-|-|-|-\n",
    "    PK|PatientConditionGuid|UNIQUEIDENTIFIER NOT NULL|Unique identifier for a patient condition record.\n",
    "    FK|PatientGuid|UNIQUEIDENTIFIER NULL|Identifier for the patient with the condition.\n",
    "    FK|ConditionGuid|UNIQUEIDENTIFIER NULL|Identifier of the condition.\n",
    "    |CreatedYear|SMALLINT NOT NULL|Year the provider added the condition to the electronic health record.\n",
    "\n",
    "**PatientSmokingStatus**\n",
    "This table contains changes in smoking status for each patient,by year. \n",
    "\n",
    "Key|Column Name|Data Type | Description\n",
    "-|-|-|-\n",
    "PK| PatientSmokingStatusGuid| UNIQUEIDENTIFIER NOT NULL| Unique identifier for the patient smoking status record.\n",
    "FK| PatientGuid| UNIQUEIDENTIFIER NULL| Identifier for the patient.\n",
    "FK| SmokingStatusGuid| UNIQUEIDENTIFIER NULL| Identifier for the smoking status.\n",
    "|EffectiveYear| SMALLINT NULL| Starting year for the smoking status change.\n",
    "\n",
    "**Prescription**\n",
    "This table contains prescription records for a patient. A prescription is a written direction from the provider for administering medication.\n",
    "\n",
    "Key|Column Name|Data Type | Description\n",
    "-|-|-|-\n",
    "    PK| PrescriptionGuid| UNIQUEIDENTIFIER NOT NULL| Unique identifier for a prescription.\n",
    "    FK| PatientGuid| UNIQUEIDENTIFIER NOT NULL| Identifier for the patient.\n",
    "    FK| MedicationGuid| UNIQUEIDENTIFIER NULL| Identifier for the medication that the doctor prescribed.\n",
    "    |PrescriptionYear| SMALLINT NULL| Year in which the prescription was made.\n",
    "    |Quantity| NVARCHAR(50) NOT NULL| Number of units of the medication prescribed.\n",
    "    |NumberOfRefills| NVARCHAR(50) NULL| Number of refills included in the prescription.\n",
    "    |RefillAsNeeded| BIT NULL| Can the patient refills as needed? Values: 1 = Yes, 0 = No.\n",
    "    |GenericAllowed| BIT NULL |Can a generic drug be substituted? Values: 1 = Yes, 0 = No.\n",
    "    |UserGuid| UNIQUEIDENTIFIER NOT NULL| Identifier of the provider who created the prescription.\n",
    "\n",
    "**SmokingStatus**\n",
    "Reference table containing valid values for patient smoking status.\n",
    "\n",
    "Key|Column Name|Data Type | Description\n",
    "-|-|-|-\n",
    "    PK|SmokingStatusGuid|UNIQUEIDENTIFIER NOT NULL|Unique identifier for the smoking status record.\n",
    "    |Description|NVARCHAR(255) NULL|Description of the smoking status.\n",
    "    |NISTcode|INT NULL|Corresponding NIST code value for smoking status, as specified in HHS HIT 45 CFR ยง170.302(g).\n",
    "    \n",
    "**Transcript**\n",
    "This table contains visit transcript records for a patient. Each patient visit is documented by a visit transcript record. \n",
    "\n",
    "Key|Column Name|Data Type | Description\n",
    "-|-|-|-\n",
    "    PK|TranscriptGuid| UNIQUEIDENTIFIER NOT NULL| Unique identifier for a visit transcript.\n",
    "    FK| PatientGuid| UNIQUEIDENTIFIER NOT NULL| Identifier for the patient.\n",
    "    |VisitYear| SMALLINT NOT NULL| Year of the visit for which the transcript was created.\n",
    "    |Height| FLOAT NULL| Patient height (inches).\n",
    "    |Weight| FLOAT NULL| Patient weight (lbs).\n",
    "    |BMI| FLOAT NULL| Body mass index.\n",
    "    |SystolicBP| SMALLINT NULL| Systolic blood pressure.\n",
    "    |DiastolicBP| SMALLINT NULL| Diastolic blood pressure.\n",
    "    |RespiratoryRate| SMALLINT NULL| Respiratory rate (breaths per minute).\n",
    "    |HeartRate| SMALLINT NULL| Heart rate (beats per minute).\n",
    "    |Temperature| FLOAT NULL| Temperature as entered by the provider (Expected as degrees Fahrenheit; a very small subset in Centigrade).\n",
    "    |PhysicianSpecialty| NVARCHAR(256) NOT NULL| Specialty of the provider seeing the patient.\n",
    "    |UserGuid| UNIQUEIDENTIFIER NOT NULL| Identifier of the provider recording the visit transcript.\n",
    "\n",
    "**TranscriptAllergy**\n",
    "This table contains a list of allergies recorded per visit transcript.\n",
    "\n",
    "Key|Column Name|Data Type | Description\n",
    "-|-|-|-\n",
    "    PK|TranscriptAllergyGuid| UNIQUEIDENTIFIER NOT NULL| Unique identifier for the visit transcript allergy record.\n",
    "    FK| TranscriptGuid| UNIQUEIDENTIFIER NOT NULL| Identifier for the visit transcript.\n",
    "    FK| AllergyGuid| UNIQUEIDENTIFIER NOT NULL| Identifier for the allergy assigned to the visit transcript.\n",
    "    |DisplayOrder| INT NOT NULL| Sequence that the allergy appears in the visit transcript.\n",
    "\n",
    "**TranscriptDiagnosis**\n",
    "This table contains a list of diagnoses per visit transcript.\n",
    "\n",
    "Key|Column Name|Data Type | Description\n",
    "-|-|-|-\n",
    "    PK| TranscriptDiagnosisGuid| UNIQUEIDENTIFIER NOT NULL| Unique identifier for a visit transcript diagnosis record.\n",
    "    FK| TranscriptGuid| UNIQUEIDENTIFIER NULL| Identifier for the visit transcript.\n",
    "    FK| DiagnosisGuid| UNIQUEIDENTIFIER NOT NULL| Identifier for the diagnosis assigned to the visit transcript.\n",
    "    |OrderBy| INT NOT NULL| Sequence that the diagnosis appears in the visit transcript. Sometimes indicates the severity or importance of the diagnosis in relation to other diagnoses in the same visit transcript.\n",
    "\n",
    "\n",
    "\n",
    "######Describe Data\n",
    "Examine the surface properties of the acquired data.\n",
    "\n",
    "1. Data description analysis\n",
    "    * Summary statistics on data\n",
    "    * Format of the data\n",
    "    * Quantity of the data (number of records and fields)\n",
    "    * Identities of the fields\n",
    "    * Evaluate whether data acquired satisified the relevant requirements\n",
    "\n",
    "######Explore Data\n",
    "1. Data exploration report\n",
    "    * First findings or initial hypothesis\n",
    "    * Impact on the remainder of the project\n",
    "    * What graphs and plots to indicate data charactersitcs that suggest futher examination of interesting data subsets\n",
    "\n",
    "######Verify Data Quality\n",
    "1. Data quality report\n",
    "    * Address questions: \n",
    "        * Is the data complete?\n",
    "        * Is it correct, or does it contain errors, if so how common are they?\n",
    "        * Are there missing values in the data? If so, how are they represented, where do they occur, and how common are they?"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "**===================================================================================================**"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Data Scientist B\n",
    "\n",
    "#PHASE II: Data Understanding\n",
    "\n",
    "######Collect Initial Data\n",
    "\n",
    "1. Initial data collection report\n",
    "\n",
    "Table|Description\n",
    "-|-\n",
    "    **Allergy**|This table contains a list of allergies recorded for a patient.\n",
    "    **Condition**| Reference table containing valid patient conditions.\n",
    "    **Diagnosis** | This table contains a list of diagnoses for a patient. \n",
    "    **Immunization **| This table contains a list of immunizations for a patient. \n",
    "    **LabObservation**|This table contains lab test observations for a lab panel.\n",
    "    **LabPanel**| This table contains lab test panels reported in a patient lab test result.\n",
    "    **LabResult**|This table contains patient lab test results received from a lab facility.\n",
    "    **Medication**| This table contains the medication history for a patient.\n",
    "    **Patient**|This table contains a header record for each patient.\n",
    "    **PatientCondition**|This table lists conditions for a patient. \n",
    "    **PatientSmokingStatus**|This table contains changes in smoking status for each patient,by year. \n",
    "    **Prescription**|This table contains prescription records for a patient. A prescription is a written direction from the provider for administering medication.\n",
    "    **SmokingStatus**| Reference table containing valid values for patient smoking status.\n",
    "    **Transcript**|This table contains visit transcript records for a patient. Each patient visit is documented by a visit transcript record. \n",
    "    **TranscriptAllergy**| This table contains a list of allergies recorded per visit transcript.\n",
    "    **TranscriptDiagnosis**| This table contains a list of diagnoses per visit transcript.\n",
    "\n",
    "######Describe Data\n",
    "Examine the surface properties of the acquired data.\n",
    "\n",
    "1. Data description analysis\n",
    "    * Below are summary statistics on the patient data:\n",
    "\n",
    "**Data Quality Output**\n",
    "\n",
    "(a) Continuous Features\n",
    "\n",
    "Feature|Count|% Miss. |Card.|Min.|1st Qrt.|Mean|Median|3rd. Qrt.|Max|Std. Dev.\n",
    "-|-|-|-|\n",
    "    RangeSystolicBP|14,926|0%|171|0.00|4.00|12.46|11.00|20.00|94.00|10.6657\n",
    "    RangeDiastolicBP|14,926|0%|493|0.00|2.00|8.25|8.00|12.00|52.00|6.903738\n",
    "    HighLowBP|14,926|0%|78|0.00|41.00|49.08|48.00|55.00|125.00|10.99835\n",
    "    RespiratoryRateMaxT|14,926|2.0%|36|0.00|0.00|12.27|16.00|18.00|80.00|8.244918\n",
    "    RespiratoryRateMedian|14,926|0.0%|28|0.00|0.00|11.81|16.00|18.00|79.00|7.909366\n",
    "    RangeBMI|14,926|0.0%|40|0.00|0.00|0.9779|0.6359|1.3643|14.4170|1.219054\n",
    "\n",
    "\n",
    "(b) Categorical Features\n",
    "\n",
    "Feature|Count|% Miss. |Card.|Mode|Mode Freq.|Mode %|2nd Mode|2nd Mode Freq.|2nd Mode %\n",
    "-|-|-|-|-|-|-|-|-|-   \n",
    "    Gender|14,926|0%|2|F|8,554|57.3%|M|6,372|42.7%\n",
    "    PracticeGuid|14,926|0%|28|4D27688B-C925-4513-9CF9-8D281ACC6712|867|5.8%|5639C194-706D-49FE-AF69-D4F36752893C|740|5.0%\n",
    "    \n",
    "\n",
    "\n",
    "######Explore Data\n",
    "1. Data exploration report\n",
    "   Initial findings suggests that we should eliminate a few Patient records, as they will have an impact on the remainder of the project. \n",
    "\n",
    "*Underweight Valid Patients(valid weight <85)*\n",
    "\n",
    "Category: Underweight | PatientGuid\n",
    "-|-\n",
    "    |'3C8D1326-7D79-4350-89D8-1271A34C62E3'\n",
    "    |'3066A99F-3B26-44A3-95C3-349FCCEB303B'\n",
    "    |'3E917FBC-C42E-4948-A834-EA999131D1A0'\n",
    "    |'812E6BE3-BDBB-4FD2-AA86-7E4FCEA33431'\n",
    "    |'8B6688AB-E183-4C32-8FE6-29B9D8865687'\n",
    "    |'A71E42F0-385F-4102-BE27-FB55ED06D3AE'\n",
    "    |'D70EDC3E-24D7-44E7-993A-501D620E999A'\n",
    "    |'D70EDC3E-24D7-44E7-993A-501D620E999A'\n",
    "    |'BB0CC274-240A-4C02-A764-5070CC514A87'\n",
    "    |'D0703010-9CF8-426C-BD1B-61E8C53D0338'\n",
    "    |'096AA3A2-3306-4F9A-9082-6B479C2BB5AA'\n",
    "    |'148B6713-1D0D-4DE4-8EE5-E6D7988088ED'\n",
    "    \n",
    "*Overweight valid patients (valid weight >320)*    \n",
    "\n",
    "Category: Overweight | PatientGuid\n",
    " -|-\n",
    "    |'04477471-FAFE-45AE-9EF8-6EC94B94789C'\n",
    "    |'0D3EF269-0675-444A-9F45-6FBCF2046CCD'\n",
    "    |'100ECEEB-8759-4D59-AC23-A86697DD4113'\n",
    "    |'10AA6386-B0A5-4F6B-B495-DBC588042E4D'\n",
    "    |'17DCFE68-7A86-473C-A589-11B0FC256BA2'\n",
    "    |'1B0556CF-72DF-480E-8429-DF61C252F16F'\n",
    "    |'25B9E447-F7E3-479C-8B72-E6D76CA3182D'\n",
    "    |'2A767E8A-1E47-4555-B11A-8A507B48DD64'\n",
    "    |'2C2F654C-FC57-4E06-9E41-9AEE559A7D6E'\n",
    "    |'2CC737E9-98B8-48FE-A744-F75770C59218'\n",
    "    |'2EDC74B4-360A-4114-AB6C-BF0689AF2C70'\n",
    "    |'3F8A2228-0DF3-4FAF-8C26-F04A9DD14C36'\n",
    "    |'50BABFE9-D522-425D-86A0-170300961A46'\n",
    "    |'53C120E7-11B2-40F2-AC09-DA209DFA2CBE'\n",
    "    |'5883AF5C-513F-4F2A-B204-762AAF6963E6'\n",
    "    |'61B927CE-1EB3-4464-B843-4BA4943BA027'\n",
    "    |'71047BE4-1639-4F34-8BE9-5AA89281F9C7'\n",
    "    |'763112F7-6F43-43D7-B745-75C0506E4197'\n",
    "    |'7CA6C507-CCA6-4CF2-880E-F11EBECAD928'\n",
    "    |'7E3B9F76-C55F-46B9-897D-E5C4DB645CF0'\n",
    "    |'83190041-69EC-4D8C-8486-DF5C99CB1844'\n",
    "    |'87F932AE-370E-49B8-8B77-EE866EB04267'\n",
    "    |'91A9EECB-093F-4DA7-9F18-4C803E5F94B4'\n",
    "    |'92626713-16CE-4473-8523-ADCDB86A7DC8'\n",
    "    |'A1E6ED8A-68AC-45F1-B622-28833D2ECC37'\n",
    "    |'A42807AE-854E-409B-83E0-6B2389E4DE44'\n",
    "    |'A53C6FBB-730C-4F4C-A128-6B5F3120BCE1'\n",
    "\n",
    "   \n",
    "The below graph indicates data characteristics that suggest further examination of interesting data subsets: \n",
    "\n",
    "<img src=\"http://i1377.photobucket.com/albums/ah57/drmingle1/Jupyter%20-%20Healthcare%20Data%20Science/PatientFeatures_zpslfdqqjtw.png\" alt=\"Matrix\" style=\"width: 600px;\"/>\n",
    "\n",
    "\n",
    "######Data Quality\n",
    "The data is complete. It does contain an insignificant amount of errors and there are some missing values as well, however they do not occur that often. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.4.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}