ScratchPad.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Import all of the libraries we need to use...\n",
    "import pandas as pd\n",
    "import azureml.dataprep as dprep\n",
    "import os as os\n",
    "import re as re\n",
    "import collections\n",
    "import seaborn as sns\n",
    "from azureml.dataprep import value\n",
    "from azureml.dataprep import col\n",
    "from azureml.dataprep import Dataflow\n",
    "from commonCode import savePackage, openPackage, createFullPackagePath\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "dataFlow = Dataflow.open('./packages/PEOPLE_3_A_package.dprep')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = dataFlow.to_pandas_dataframe()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "dataProfile = dataFlow.get_profile()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 170,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Type</th>\n",
       "      <th>Min</th>\n",
       "      <th>Max</th>\n",
       "      <th>Count</th>\n",
       "      <th>Missing Count</th>\n",
       "      <th>Not Missing Count</th>\n",
       "      <th>Percent missing</th>\n",
       "      <th>Error Count</th>\n",
       "      <th>Empty count</th>\n",
       "      <th>0.1% Quantile</th>\n",
       "      <th>1% Quantile</th>\n",
       "      <th>5% Quantile</th>\n",
       "      <th>25% Quantile</th>\n",
       "      <th>50% Quantile</th>\n",
       "      <th>75% Quantile</th>\n",
       "      <th>95% Quantile</th>\n",
       "      <th>99% Quantile</th>\n",
       "      <th>99.9% Quantile</th>\n",
       "      <th>Mean</th>\n",
       "      <th>Standard Deviation</th>\n",
       "      <th>Variance</th>\n",
       "      <th>Skewness</th>\n",
       "      <th>Kurtosis</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ADDRESS</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>'highfields\\0d0aNordham\\0d0aNorth Cave\\0d0aNor...</td>\n",
       "      <td>wind Farm Cottage \\0d0a62 Hollow Garden \\0d0aM...</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>19118.0</td>\n",
       "      <td>0.001515</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AGECERT</th>\n",
       "      <td>FieldType.BOOLEAN</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>19146.0</td>\n",
       "      <td>0.000052</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ARI</th>\n",
       "      <td>FieldType.INTEGER</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>305.0</td>\n",
       "      <td>18842.0</td>\n",
       "      <td>0.015929</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000106146</td>\n",
       "      <td>0.0103024</td>\n",
       "      <td>0.00010614</td>\n",
       "      <td>97.0387</td>\n",
       "      <td>9415</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DATEDIED</th>\n",
       "      <td>FieldType.DATE</td>\n",
       "      <td>1979-06-05 00:00:00+00:00</td>\n",
       "      <td>2007-06-12 00:00:00+00:00</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>18377.0</td>\n",
       "      <td>770.0</td>\n",
       "      <td>0.959785</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DOB</th>\n",
       "      <td>FieldType.DATE</td>\n",
       "      <td>1900-01-01 00:00:00+00:00</td>\n",
       "      <td>2008-10-25 00:00:00+00:00</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>19146.0</td>\n",
       "      <td>0.000052</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FORENAME</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>A</td>\n",
       "      <td>trefor</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>8373.0</td>\n",
       "      <td>10774.0</td>\n",
       "      <td>0.437301</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GENEMAIL</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GENPHONE</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GENPOSTAL</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GENSMS</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GMPDATE</th>\n",
       "      <td>FieldType.DATE</td>\n",
       "      <td>1955-12-04 00:00:00+00:00</td>\n",
       "      <td>2071-07-03 00:00:00+00:00</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>183.0</td>\n",
       "      <td>18964.0</td>\n",
       "      <td>0.009558</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ID</th>\n",
       "      <td>FieldType.INTEGER</td>\n",
       "      <td>17936</td>\n",
       "      <td>36765</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>19146.0</td>\n",
       "      <td>0.000052</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17957.5</td>\n",
       "      <td>19834.1</td>\n",
       "      <td>19741</td>\n",
       "      <td>22621.6</td>\n",
       "      <td>27301.9</td>\n",
       "      <td>31965.1</td>\n",
       "      <td>35744</td>\n",
       "      <td>36546.7</td>\n",
       "      <td>36743.4</td>\n",
       "      <td>27298.8</td>\n",
       "      <td>5400.8</td>\n",
       "      <td>2.91686e+07</td>\n",
       "      <td>0.0072681</td>\n",
       "      <td>-1.19487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INITIALS</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>A</td>\n",
       "      <td>ZR</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>19115.0</td>\n",
       "      <td>0.001671</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MARRCERT</th>\n",
       "      <td>FieldType.BOOLEAN</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>108.0</td>\n",
       "      <td>19039.0</td>\n",
       "      <td>0.005641</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MARRDATE</th>\n",
       "      <td>FieldType.DATE</td>\n",
       "      <td>1937-08-19 00:00:00+00:00</td>\n",
       "      <td>2006-08-25 00:00:00+00:00</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>18944.0</td>\n",
       "      <td>203.0</td>\n",
       "      <td>0.989398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MEMNO</th>\n",
       "      <td>FieldType.INTEGER</td>\n",
       "      <td>-1</td>\n",
       "      <td>75557</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>19054.0</td>\n",
       "      <td>0.004857</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>24914.6</td>\n",
       "      <td>35739.7</td>\n",
       "      <td>75115.5</td>\n",
       "      <td>75470.7</td>\n",
       "      <td>12435.8</td>\n",
       "      <td>16403.1</td>\n",
       "      <td>2.69061e+08</td>\n",
       "      <td>1.37762</td>\n",
       "      <td>2.42782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MINRETIREMENTDATE</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>02/03/2020</td>\n",
       "      <td>27/01/2011</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>19141.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.999687</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MSTA</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>0</td>\n",
       "      <td>Widowed</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>19146.0</td>\n",
       "      <td>0.000052</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NINO</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>19473</td>\n",
       "      <td>ZZ019055Y</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>19142.0</td>\n",
       "      <td>0.000261</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OTHERNO</th>\n",
       "      <td>FieldType.BOOLEAN</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>519.0</td>\n",
       "      <td>18628.0</td>\n",
       "      <td>0.027106</td>\n",
       "      <td>173.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OVERSEAS</th>\n",
       "      <td>FieldType.BOOLEAN</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>11052.0</td>\n",
       "      <td>8095.0</td>\n",
       "      <td>0.577218</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PENSERYEARS</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>POSTCODE</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>A10 1BI</td>\n",
       "      <td>ZZ96 6LP</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>19146.0</td>\n",
       "      <td>0.000052</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PROTECTIONAMT</th>\n",
       "      <td>FieldType.INTEGER</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>11130.0</td>\n",
       "      <td>8017.0</td>\n",
       "      <td>0.581292</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PROTECTIONTYPE</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PROTECTPCENT</th>\n",
       "      <td>FieldType.INTEGER</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>11130.0</td>\n",
       "      <td>8017.0</td>\n",
       "      <td>0.581292</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PSFLAG</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PSPART</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>QUOEMAIL</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>19145.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.999896</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>QUOPHONE</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>QUOPOSTAL</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>QUOSMS</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>REGCHECKED</th>\n",
       "      <td>FieldType.BOOLEAN</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>11130.0</td>\n",
       "      <td>8017.0</td>\n",
       "      <td>0.581292</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>REGISTRATION</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>100th NRA 60</td>\n",
       "      <td>phillipa</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>12151.0</td>\n",
       "      <td>6996.0</td>\n",
       "      <td>0.634616</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SEX</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>F</td>\n",
       "      <td>M</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>19146.0</td>\n",
       "      <td>0.000052</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SPAD</th>\n",
       "      <td>FieldType.DATE</td>\n",
       "      <td>1955-12-04 00:00:00+00:00</td>\n",
       "      <td>2066-07-24 00:00:00+00:00</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>310.0</td>\n",
       "      <td>18837.0</td>\n",
       "      <td>0.016191</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SURNAME</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>SurnameA</td>\n",
       "      <td>SurnameZ</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>19146.0</td>\n",
       "      <td>0.000052</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TITLE</th>\n",
       "      <td>FieldType.STRING</td>\n",
       "      <td>Doct</td>\n",
       "      <td>mrs</td>\n",
       "      <td>19147.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>19144.0</td>\n",
       "      <td>0.000157</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>"
      ],
      "text/plain": [
       "ColumnProfile:\n",
       "    column_name: ADDRESS\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: 'highfields\\0d0aNordham\\0d0aNorth Cave\\0d0aNorth Humberside\n",
       "    max: wind Farm Cottage \\0d0a62 Hollow Garden \\0d0aMosborough \\0d0aSheffield\n",
       "    count: 19147.0\n",
       "    missing_count: 29.0\n",
       "    not_missing_count: 19118.0\n",
       "    percent_missing: 0.0015145975870893612\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: AGECERT\n",
       "    type: FieldType.BOOLEAN\n",
       "\n",
       "    min: False\n",
       "    max: True\n",
       "    count: 19147.0\n",
       "    missing_count: 1.0\n",
       "    not_missing_count: 19146.0\n",
       "    percent_missing: 5.222750300308142e-05\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: ARI\n",
       "    type: FieldType.INTEGER\n",
       "\n",
       "    min: 0.0\n",
       "    max: 1.0\n",
       "    count: 19147.0\n",
       "    missing_count: 305.0\n",
       "    not_missing_count: 18842.0\n",
       "    percent_missing: 0.015929388415939834\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "    Quantiles:\n",
       "         0.1%: 0.0\n",
       "           1%: 0.0\n",
       "           5%: 0.0\n",
       "          25%: 0.0\n",
       "          50%: 0.0\n",
       "          75%: 0.0\n",
       "          95%: 0.0\n",
       "          99%: 0.0\n",
       "        99.9%: 0.0\n",
       "\n",
       "    mean: 0.00010614584439019137\n",
       "    std: 0.010302437120460906\n",
       "    variance: 0.00010614021062105082\n",
       "    skewness: 97.03865551098278\n",
       "    kurtosis: 9415.000344968419\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: DATEDIED\n",
       "    type: FieldType.DATE\n",
       "\n",
       "    min: 1979-06-05 00:00:00+00:00\n",
       "    max: 2007-06-12 00:00:00+00:00\n",
       "    count: 19147.0\n",
       "    missing_count: 18377.0\n",
       "    not_missing_count: 770.0\n",
       "    percent_missing: 0.9597848226876273\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: DOB\n",
       "    type: FieldType.DATE\n",
       "\n",
       "    min: 1900-01-01 00:00:00+00:00\n",
       "    max: 2008-10-25 00:00:00+00:00\n",
       "    count: 19147.0\n",
       "    missing_count: 1.0\n",
       "    not_missing_count: 19146.0\n",
       "    percent_missing: 5.222750300308142e-05\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: FORENAME\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: A\n",
       "    max: trefor\n",
       "    count: 19147.0\n",
       "    missing_count: 8373.0\n",
       "    not_missing_count: 10774.0\n",
       "    percent_missing: 0.43730088264480077\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: GENEMAIL\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: None\n",
       "    max: None\n",
       "    count: 19147.0\n",
       "    missing_count: 19147.0\n",
       "    not_missing_count: 0.0\n",
       "    percent_missing: 1.0\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: GENPHONE\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: None\n",
       "    max: None\n",
       "    count: 19147.0\n",
       "    missing_count: 19147.0\n",
       "    not_missing_count: 0.0\n",
       "    percent_missing: 1.0\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: GENPOSTAL\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: None\n",
       "    max: None\n",
       "    count: 19147.0\n",
       "    missing_count: 19147.0\n",
       "    not_missing_count: 0.0\n",
       "    percent_missing: 1.0\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: GENSMS\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: None\n",
       "    max: None\n",
       "    count: 19147.0\n",
       "    missing_count: 19147.0\n",
       "    not_missing_count: 0.0\n",
       "    percent_missing: 1.0\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: GMPDATE\n",
       "    type: FieldType.DATE\n",
       "\n",
       "    min: 1955-12-04 00:00:00+00:00\n",
       "    max: 2071-07-03 00:00:00+00:00\n",
       "    count: 19147.0\n",
       "    missing_count: 183.0\n",
       "    not_missing_count: 18964.0\n",
       "    percent_missing: 0.009557633049563901\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: ID\n",
       "    type: FieldType.INTEGER\n",
       "\n",
       "    min: 17936.0\n",
       "    max: 36765.0\n",
       "    count: 19147.0\n",
       "    missing_count: 1.0\n",
       "    not_missing_count: 19146.0\n",
       "    percent_missing: 5.222750300308142e-05\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "    Quantiles:\n",
       "         0.1%: 17957.505076923077\n",
       "           1%: 19834.11288011696\n",
       "           5%: 19741.04861111111\n",
       "          25%: 22621.57794636583\n",
       "          50%: 27301.880255872522\n",
       "          75%: 31965.093154567367\n",
       "          95%: 35743.97104916763\n",
       "          99%: 36546.678301158296\n",
       "        99.9%: 36743.43258133971\n",
       "\n",
       "    mean: 27298.755562519484\n",
       "    std: 5400.796882343092\n",
       "    variance: 29168606.964326866\n",
       "    skewness: 0.007268103979632813\n",
       "    kurtosis: -1.194865681433907\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: INITIALS\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: A\n",
       "    max: ZR\n",
       "    count: 19147.0\n",
       "    missing_count: 32.0\n",
       "    not_missing_count: 19115.0\n",
       "    percent_missing: 0.0016712800960986054\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: MARRCERT\n",
       "    type: FieldType.BOOLEAN\n",
       "\n",
       "    min: False\n",
       "    max: True\n",
       "    count: 19147.0\n",
       "    missing_count: 108.0\n",
       "    not_missing_count: 19039.0\n",
       "    percent_missing: 0.005640570324332793\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: MARRDATE\n",
       "    type: FieldType.DATE\n",
       "\n",
       "    min: 1937-08-19 00:00:00+00:00\n",
       "    max: 2006-08-25 00:00:00+00:00\n",
       "    count: 19147.0\n",
       "    missing_count: 18944.0\n",
       "    not_missing_count: 203.0\n",
       "    percent_missing: 0.9893978168903744\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: MEMNO\n",
       "    type: FieldType.INTEGER\n",
       "\n",
       "    min: -1.0\n",
       "    max: 75557.0\n",
       "    count: 19147.0\n",
       "    missing_count: 93.0\n",
       "    not_missing_count: 19054.0\n",
       "    percent_missing: 0.004857157779286573\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "    Quantiles:\n",
       "         0.1%: -1.0\n",
       "           1%: -1.0\n",
       "           5%: -1.0\n",
       "          25%: -1.0\n",
       "          50%: -1.0\n",
       "          75%: 24914.625957164757\n",
       "          95%: 35739.70200524326\n",
       "          99%: 75115.53391774754\n",
       "        99.9%: 75470.72077033493\n",
       "\n",
       "    mean: 12435.812637766383\n",
       "    std: 16403.078870793048\n",
       "    variance: 269060996.4414573\n",
       "    skewness: 1.3776211280811366\n",
       "    kurtosis: 2.4278152117282525\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: MINRETIREMENTDATE\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: 02/03/2020\n",
       "    max: 27/01/2011\n",
       "    count: 19147.0\n",
       "    missing_count: 19141.0\n",
       "    not_missing_count: 6.0\n",
       "    percent_missing: 0.9996866349819815\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: MSTA\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: 0\n",
       "    max: Widowed\n",
       "    count: 19147.0\n",
       "    missing_count: 1.0\n",
       "    not_missing_count: 19146.0\n",
       "    percent_missing: 5.222750300308142e-05\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: NINO\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: 19473\n",
       "    max: ZZ019055Y\n",
       "    count: 19147.0\n",
       "    missing_count: 5.0\n",
       "    not_missing_count: 19142.0\n",
       "    percent_missing: 0.0002611375150154071\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: OTHERNO\n",
       "    type: FieldType.BOOLEAN\n",
       "\n",
       "    min: False\n",
       "    max: True\n",
       "    count: 19147.0\n",
       "    missing_count: 519.0\n",
       "    not_missing_count: 18628.0\n",
       "    percent_missing: 0.027106074058599258\n",
       "    error_count: 173.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: OVERSEAS\n",
       "    type: FieldType.BOOLEAN\n",
       "\n",
       "    min: False\n",
       "    max: True\n",
       "    count: 19147.0\n",
       "    missing_count: 11052.0\n",
       "    not_missing_count: 8095.0\n",
       "    percent_missing: 0.5772183631900559\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: PENSERYEARS\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: None\n",
       "    max: None\n",
       "    count: 19147.0\n",
       "    missing_count: 19147.0\n",
       "    not_missing_count: 0.0\n",
       "    percent_missing: 1.0\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: POSTCODE\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: A10 1BI\n",
       "    max: ZZ96 6LP\n",
       "    count: 19147.0\n",
       "    missing_count: 1.0\n",
       "    not_missing_count: 19146.0\n",
       "    percent_missing: 5.222750300308142e-05\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: PROTECTIONAMT\n",
       "    type: FieldType.INTEGER\n",
       "\n",
       "    min: 0.0\n",
       "    max: 0.0\n",
       "    count: 19147.0\n",
       "    missing_count: 11130.0\n",
       "    not_missing_count: 8017.0\n",
       "    percent_missing: 0.5812921084242962\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "    Quantiles:\n",
       "         0.1%: 0.0\n",
       "           1%: 0.0\n",
       "           5%: 0.0\n",
       "          25%: 0.0\n",
       "          50%: 0.0\n",
       "          75%: 0.0\n",
       "          95%: 0.0\n",
       "          99%: 0.0\n",
       "        99.9%: 0.0\n",
       "\n",
       "    mean: 0.0\n",
       "    std: 0.0\n",
       "    variance: 0.0\n",
       "    skewness: nan\n",
       "    kurtosis: nan\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: PROTECTIONTYPE\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: None\n",
       "    max: None\n",
       "    count: 19147.0\n",
       "    missing_count: 19147.0\n",
       "    not_missing_count: 0.0\n",
       "    percent_missing: 1.0\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: PROTECTPCENT\n",
       "    type: FieldType.INTEGER\n",
       "\n",
       "    min: 0.0\n",
       "    max: 0.0\n",
       "    count: 19147.0\n",
       "    missing_count: 11130.0\n",
       "    not_missing_count: 8017.0\n",
       "    percent_missing: 0.5812921084242962\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "    Quantiles:\n",
       "         0.1%: 0.0\n",
       "           1%: 0.0\n",
       "           5%: 0.0\n",
       "          25%: 0.0\n",
       "          50%: 0.0\n",
       "          75%: 0.0\n",
       "          95%: 0.0\n",
       "          99%: 0.0\n",
       "        99.9%: 0.0\n",
       "\n",
       "    mean: 0.0\n",
       "    std: 0.0\n",
       "    variance: 0.0\n",
       "    skewness: nan\n",
       "    kurtosis: nan\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: PSFLAG\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: None\n",
       "    max: None\n",
       "    count: 19147.0\n",
       "    missing_count: 19147.0\n",
       "    not_missing_count: 0.0\n",
       "    percent_missing: 1.0\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: PSPART\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: None\n",
       "    max: None\n",
       "    count: 19147.0\n",
       "    missing_count: 19147.0\n",
       "    not_missing_count: 0.0\n",
       "    percent_missing: 1.0\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: QUOEMAIL\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: Y\n",
       "    max: Y\n",
       "    count: 19147.0\n",
       "    missing_count: 19145.0\n",
       "    not_missing_count: 2.0\n",
       "    percent_missing: 0.9998955449939938\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: QUOPHONE\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: None\n",
       "    max: None\n",
       "    count: 19147.0\n",
       "    missing_count: 19147.0\n",
       "    not_missing_count: 0.0\n",
       "    percent_missing: 1.0\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: QUOPOSTAL\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: None\n",
       "    max: None\n",
       "    count: 19147.0\n",
       "    missing_count: 19147.0\n",
       "    not_missing_count: 0.0\n",
       "    percent_missing: 1.0\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: QUOSMS\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: None\n",
       "    max: None\n",
       "    count: 19147.0\n",
       "    missing_count: 19147.0\n",
       "    not_missing_count: 0.0\n",
       "    percent_missing: 1.0\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: REGCHECKED\n",
       "    type: FieldType.BOOLEAN\n",
       "\n",
       "    min: False\n",
       "    max: False\n",
       "    count: 19147.0\n",
       "    missing_count: 11130.0\n",
       "    not_missing_count: 8017.0\n",
       "    percent_missing: 0.5812921084242962\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: REGISTRATION\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: 100th NRA 60\n",
       "    max: phillipa\n",
       "    count: 19147.0\n",
       "    missing_count: 12151.0\n",
       "    not_missing_count: 6996.0\n",
       "    percent_missing: 0.6346163889904424\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: SEX\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: F\n",
       "    max: M\n",
       "    count: 19147.0\n",
       "    missing_count: 1.0\n",
       "    not_missing_count: 19146.0\n",
       "    percent_missing: 5.222750300308142e-05\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: SPAD\n",
       "    type: FieldType.DATE\n",
       "\n",
       "    min: 1955-12-04 00:00:00+00:00\n",
       "    max: 2066-07-24 00:00:00+00:00\n",
       "    count: 19147.0\n",
       "    missing_count: 310.0\n",
       "    not_missing_count: 18837.0\n",
       "    percent_missing: 0.01619052593095524\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: SURNAME\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: SurnameA\n",
       "    max: SurnameZ\n",
       "    count: 19147.0\n",
       "    missing_count: 1.0\n",
       "    not_missing_count: 19146.0\n",
       "    percent_missing: 5.222750300308142e-05\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n",
       "\n",
       "\n",
       "ColumnProfile:\n",
       "    column_name: TITLE\n",
       "    type: FieldType.STRING\n",
       "\n",
       "    min: Doct\n",
       "    max: mrs\n",
       "    count: 19147.0\n",
       "    missing_count: 3.0\n",
       "    not_missing_count: 19144.0\n",
       "    percent_missing: 0.00015668250900924426\n",
       "    error_count: 0.0\n",
       "    empty_count: 0.0\n"
      ]
     },
     "execution_count": 170,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataProfile\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "dateOfBirth = df[['ID','DOB']]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'pp' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-6-6525ab5b4de1>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mprofileReport\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mpp\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mProfileReport\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mdateOfBirth\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mcheck_correlation\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;32mTrue\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m      2\u001b[0m \u001b[0mprofileReport\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mto_file\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'./profileReport.html'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mNameError\u001b[0m: name 'pp' is not defined"
     ]
    }
   ],
   "source": [
    "profileReport = pp.ProfileReport(dateOfBirth, check_correlation = True)\n",
    "profileReport.to_file('./profileReport.html')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\bsmart\\AppData\\Local\\Programs\\Python\\Python37\\lib\\site-packages\\ipykernel_launcher.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "dateOfBirth['DOB'] = pd.to_datetime(dateOfBirth['DOB'])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\bsmart\\AppData\\Local\\Programs\\Python\\Python37\\lib\\site-packages\\ipykernel_launcher.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n",
      "C:\\Users\\bsmart\\AppData\\Local\\Programs\\Python\\Python37\\lib\\site-packages\\ipykernel_launcher.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \n",
      "C:\\Users\\bsmart\\AppData\\Local\\Programs\\Python\\Python37\\lib\\site-packages\\ipykernel_launcher.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  This is separate from the ipykernel package so we can avoid doing imports until\n",
      "C:\\Users\\bsmart\\AppData\\Local\\Programs\\Python\\Python37\\lib\\site-packages\\ipykernel_launcher.py:4: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  after removing the cwd from sys.path.\n"
     ]
    }
   ],
   "source": [
    "dateOfBirth['Year'] = dateOfBirth['DOB'].dt.year\n",
    "dateOfBirth['Month'] = dateOfBirth['DOB'].dt.month\n",
    "dateOfBirth['Day'] = dateOfBirth['DOB'].dt.day\n",
    "dateOfBirth['WeekDay'] = dateOfBirth['DOB'].dt.dayofweek"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>DOB</th>\n",
       "      <th>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th>Day</th>\n",
       "      <th>WeekDay</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>18373.0</td>\n",
       "      <td>1913-04-03</td>\n",
       "      <td>1913.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>18375.0</td>\n",
       "      <td>1924-12-17</td>\n",
       "      <td>1924.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>18376.0</td>\n",
       "      <td>1925-08-04</td>\n",
       "      <td>1925.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>18377.0</td>\n",
       "      <td>1925-05-11</td>\n",
       "      <td>1925.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>18378.0</td>\n",
       "      <td>1922-10-19</td>\n",
       "      <td>1922.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>18379.0</td>\n",
       "      <td>1924-12-17</td>\n",
       "      <td>1924.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>18380.0</td>\n",
       "      <td>1924-04-02</td>\n",
       "      <td>1924.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>18381.0</td>\n",
       "      <td>1925-10-20</td>\n",
       "      <td>1925.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>18382.0</td>\n",
       "      <td>1925-07-01</td>\n",
       "      <td>1925.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>18383.0</td>\n",
       "      <td>1925-10-09</td>\n",
       "      <td>1925.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>18384.0</td>\n",
       "      <td>1924-03-20</td>\n",
       "      <td>1924.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>18385.0</td>\n",
       "      <td>1913-12-09</td>\n",
       "      <td>1913.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>18385.0</td>\n",
       "      <td>1913-12-09</td>\n",
       "      <td>1913.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>18386.0</td>\n",
       "      <td>1921-04-26</td>\n",
       "      <td>1921.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>18387.0</td>\n",
       "      <td>1926-02-26</td>\n",
       "      <td>1926.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>18389.0</td>\n",
       "      <td>1926-09-01</td>\n",
       "      <td>1926.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>18390.0</td>\n",
       "      <td>1926-09-20</td>\n",
       "      <td>1926.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18391.0</td>\n",
       "      <td>1926-09-10</td>\n",
       "      <td>1926.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18392.0</td>\n",
       "      <td>1926-08-05</td>\n",
       "      <td>1926.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>18393.0</td>\n",
       "      <td>1926-07-21</td>\n",
       "      <td>1926.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>18394.0</td>\n",
       "      <td>1926-06-10</td>\n",
       "      <td>1926.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>18394.0</td>\n",
       "      <td>1926-06-10</td>\n",
       "      <td>1926.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>18394.0</td>\n",
       "      <td>1926-06-10</td>\n",
       "      <td>1926.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>18395.0</td>\n",
       "      <td>1927-01-16</td>\n",
       "      <td>1927.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>18396.0</td>\n",
       "      <td>1916-11-16</td>\n",
       "      <td>1916.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>18397.0</td>\n",
       "      <td>1963-05-13</td>\n",
       "      <td>1963.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>18398.0</td>\n",
       "      <td>1929-07-17</td>\n",
       "      <td>1929.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>18399.0</td>\n",
       "      <td>1914-06-01</td>\n",
       "      <td>1914.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>18400.0</td>\n",
       "      <td>1926-05-31</td>\n",
       "      <td>1926.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>18401.0</td>\n",
       "      <td>1927-10-10</td>\n",
       "      <td>1927.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19117</th>\n",
       "      <td>36731.0</td>\n",
       "      <td>1961-07-14</td>\n",
       "      <td>1961.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19118</th>\n",
       "      <td>36732.0</td>\n",
       "      <td>1929-11-20</td>\n",
       "      <td>1929.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19119</th>\n",
       "      <td>36733.0</td>\n",
       "      <td>2002-02-10</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19120</th>\n",
       "      <td>36734.0</td>\n",
       "      <td>2008-10-25</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19121</th>\n",
       "      <td>36735.0</td>\n",
       "      <td>1946-11-09</td>\n",
       "      <td>1946.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19122</th>\n",
       "      <td>36736.0</td>\n",
       "      <td>1966-04-12</td>\n",
       "      <td>1966.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19123</th>\n",
       "      <td>36737.0</td>\n",
       "      <td>2002-02-10</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19124</th>\n",
       "      <td>36740.0</td>\n",
       "      <td>1936-06-14</td>\n",
       "      <td>1936.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19125</th>\n",
       "      <td>36741.0</td>\n",
       "      <td>1952-02-26</td>\n",
       "      <td>1952.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19126</th>\n",
       "      <td>36742.0</td>\n",
       "      <td>1944-02-17</td>\n",
       "      <td>1944.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19127</th>\n",
       "      <td>36743.0</td>\n",
       "      <td>1971-08-22</td>\n",
       "      <td>1971.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19128</th>\n",
       "      <td>36744.0</td>\n",
       "      <td>2004-08-04</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19129</th>\n",
       "      <td>36745.0</td>\n",
       "      <td>2004-08-04</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19130</th>\n",
       "      <td>36746.0</td>\n",
       "      <td>2005-12-05</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19131</th>\n",
       "      <td>36748.0</td>\n",
       "      <td>1966-12-14</td>\n",
       "      <td>1966.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19132</th>\n",
       "      <td>36750.0</td>\n",
       "      <td>1949-09-14</td>\n",
       "      <td>1949.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19133</th>\n",
       "      <td>36751.0</td>\n",
       "      <td>1958-02-25</td>\n",
       "      <td>1958.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19134</th>\n",
       "      <td>36752.0</td>\n",
       "      <td>1945-10-17</td>\n",
       "      <td>1945.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19135</th>\n",
       "      <td>36753.0</td>\n",
       "      <td>1944-12-20</td>\n",
       "      <td>1944.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19136</th>\n",
       "      <td>36754.0</td>\n",
       "      <td>1943-11-21</td>\n",
       "      <td>1943.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19137</th>\n",
       "      <td>36755.0</td>\n",
       "      <td>2000-04-26</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19138</th>\n",
       "      <td>36756.0</td>\n",
       "      <td>1943-01-24</td>\n",
       "      <td>1943.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19139</th>\n",
       "      <td>36757.0</td>\n",
       "      <td>1943-03-27</td>\n",
       "      <td>1943.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19140</th>\n",
       "      <td>36759.0</td>\n",
       "      <td>1960-08-10</td>\n",
       "      <td>1960.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19141</th>\n",
       "      <td>36760.0</td>\n",
       "      <td>1932-08-27</td>\n",
       "      <td>1932.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19142</th>\n",
       "      <td>36761.0</td>\n",
       "      <td>1971-04-29</td>\n",
       "      <td>1971.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19143</th>\n",
       "      <td>36762.0</td>\n",
       "      <td>2001-01-20</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19144</th>\n",
       "      <td>36763.0</td>\n",
       "      <td>1927-11-10</td>\n",
       "      <td>1927.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19145</th>\n",
       "      <td>36764.0</td>\n",
       "      <td>1960-05-07</td>\n",
       "      <td>1960.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19146</th>\n",
       "      <td>36765.0</td>\n",
       "      <td>1933-05-22</td>\n",
       "      <td>1933.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>19147 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            ID        DOB    Year  Month   Day  WeekDay\n",
       "0      18373.0 1913-04-03  1913.0    4.0   3.0      3.0\n",
       "1      18375.0 1924-12-17  1924.0   12.0  17.0      2.0\n",
       "2      18376.0 1925-08-04  1925.0    8.0   4.0      1.0\n",
       "3      18377.0 1925-05-11  1925.0    5.0  11.0      0.0\n",
       "4      18378.0 1922-10-19  1922.0   10.0  19.0      3.0\n",
       "5      18379.0 1924-12-17  1924.0   12.0  17.0      2.0\n",
       "6      18380.0 1924-04-02  1924.0    4.0   2.0      2.0\n",
       "7      18381.0 1925-10-20  1925.0   10.0  20.0      1.0\n",
       "8      18382.0 1925-07-01  1925.0    7.0   1.0      2.0\n",
       "9      18383.0 1925-10-09  1925.0   10.0   9.0      4.0\n",
       "10     18384.0 1924-03-20  1924.0    3.0  20.0      3.0\n",
       "11     18385.0 1913-12-09  1913.0   12.0   9.0      1.0\n",
       "12     18385.0 1913-12-09  1913.0   12.0   9.0      1.0\n",
       "13     18386.0 1921-04-26  1921.0    4.0  26.0      1.0\n",
       "14     18387.0 1926-02-26  1926.0    2.0  26.0      4.0\n",
       "15     18389.0 1926-09-01  1926.0    9.0   1.0      2.0\n",
       "16     18390.0 1926-09-20  1926.0    9.0  20.0      0.0\n",
       "17     18391.0 1926-09-10  1926.0    9.0  10.0      4.0\n",
       "18     18392.0 1926-08-05  1926.0    8.0   5.0      3.0\n",
       "19     18393.0 1926-07-21  1926.0    7.0  21.0      2.0\n",
       "20     18394.0 1926-06-10  1926.0    6.0  10.0      3.0\n",
       "21     18394.0 1926-06-10  1926.0    6.0  10.0      3.0\n",
       "22     18394.0 1926-06-10  1926.0    6.0  10.0      3.0\n",
       "23     18395.0 1927-01-16  1927.0    1.0  16.0      6.0\n",
       "24     18396.0 1916-11-16  1916.0   11.0  16.0      3.0\n",
       "25     18397.0 1963-05-13  1963.0    5.0  13.0      0.0\n",
       "26     18398.0 1929-07-17  1929.0    7.0  17.0      2.0\n",
       "27     18399.0 1914-06-01  1914.0    6.0   1.0      0.0\n",
       "28     18400.0 1926-05-31  1926.0    5.0  31.0      0.0\n",
       "29     18401.0 1927-10-10  1927.0   10.0  10.0      0.0\n",
       "...        ...        ...     ...    ...   ...      ...\n",
       "19117  36731.0 1961-07-14  1961.0    7.0  14.0      4.0\n",
       "19118  36732.0 1929-11-20  1929.0   11.0  20.0      2.0\n",
       "19119  36733.0 2002-02-10  2002.0    2.0  10.0      6.0\n",
       "19120  36734.0 2008-10-25  2008.0   10.0  25.0      5.0\n",
       "19121  36735.0 1946-11-09  1946.0   11.0   9.0      5.0\n",
       "19122  36736.0 1966-04-12  1966.0    4.0  12.0      1.0\n",
       "19123  36737.0 2002-02-10  2002.0    2.0  10.0      6.0\n",
       "19124  36740.0 1936-06-14  1936.0    6.0  14.0      6.0\n",
       "19125  36741.0 1952-02-26  1952.0    2.0  26.0      1.0\n",
       "19126  36742.0 1944-02-17  1944.0    2.0  17.0      3.0\n",
       "19127  36743.0 1971-08-22  1971.0    8.0  22.0      6.0\n",
       "19128  36744.0 2004-08-04  2004.0    8.0   4.0      2.0\n",
       "19129  36745.0 2004-08-04  2004.0    8.0   4.0      2.0\n",
       "19130  36746.0 2005-12-05  2005.0   12.0   5.0      0.0\n",
       "19131  36748.0 1966-12-14  1966.0   12.0  14.0      2.0\n",
       "19132  36750.0 1949-09-14  1949.0    9.0  14.0      2.0\n",
       "19133  36751.0 1958-02-25  1958.0    2.0  25.0      1.0\n",
       "19134  36752.0 1945-10-17  1945.0   10.0  17.0      2.0\n",
       "19135  36753.0 1944-12-20  1944.0   12.0  20.0      2.0\n",
       "19136  36754.0 1943-11-21  1943.0   11.0  21.0      6.0\n",
       "19137  36755.0 2000-04-26  2000.0    4.0  26.0      2.0\n",
       "19138  36756.0 1943-01-24  1943.0    1.0  24.0      6.0\n",
       "19139  36757.0 1943-03-27  1943.0    3.0  27.0      5.0\n",
       "19140  36759.0 1960-08-10  1960.0    8.0  10.0      2.0\n",
       "19141  36760.0 1932-08-27  1932.0    8.0  27.0      5.0\n",
       "19142  36761.0 1971-04-29  1971.0    4.0  29.0      3.0\n",
       "19143  36762.0 2001-01-20  2001.0    1.0  20.0      5.0\n",
       "19144  36763.0 1927-11-10  1927.0   11.0  10.0      3.0\n",
       "19145  36764.0 1960-05-07  1960.0    5.0   7.0      5.0\n",
       "19146  36765.0 1933-05-22  1933.0    5.0  22.0      0.0\n",
       "\n",
       "[19147 rows x 6 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dateOfBirth"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ID                float64\n",
       "DOB        datetime64[ns]\n",
       "Year              float64\n",
       "Month             float64\n",
       "Day               float64\n",
       "WeekDay           float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dateOfBirth.dtypes\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZQAAAEKCAYAAAA1qaOTAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvnQurowAAIABJREFUeJzt3XmcHVWd9/HPL2HREREwHYJZjDNmRn10EIzK6DzzOOLDkgQCgSAOYMBIBMEXihvoM6Po6OgowyIYnihLUEBIdzYFFQwwriCJIEsiJCKQzh4SSMje6d/8cc7pOh26k05S1bdv9/f9evWrT517qup3a/tVnbq3rrk7IiIie6tfrQMQEZHeQQlFRERKoYQiIiKlUEIREZFSKKGIiEgplFBERKQUSigiIlIKJRQRESmFEoqIiJRin1oHsDcGDBjgw4cPr3UYIiJ1Zd68eavdvaHs6dZ1Qhk+fDhz586tdRgiInXFzJ6tYrrq8hIRkVIooYiISCmUUEREpBRKKCIiUgolFBERKYUSioiIlEIJRURESqGEIiIipVBCERGRUtT1N+VF+pKxjXe1lWedOqqGkYh0TFcoIiJSCiUUEREphRKKiIiUQglFRERKoYQiIiKl0Ke8ROrcSY2/aCvPPPUDNYxE+jpdoYj0MCc0zuSExpm1DkNktymhiIhIKZRQRESkFEooIiJSCiUUEREphRKKiIiUotKEYmYHmVmjmf3JzBaY2T+Y2SFmdo+ZLYz/D45tzcyuNrNFZvaomR1ZZWwiIlKuqq9QrgJ+5u5vAg4HFgCXAHPcfQQwJw4DHA+MiH+TgMkVxyYiIiWqLKGY2YHAPwHXA7j7Vnd/ARgLTI3NpgInxfJY4GYPHgAOMrPDqopPRETKVeU35f8aWAXcaGaHA/OAi4BD3X0ZgLsvM7OBsf1gYHE2fnOsW5ZP1MwmEa5gGDZsWIXhi/RcYxt/3lY2+tcwEpFClV1e+wBHApPd/QhgA0X3Vkesgzp/WYX7FHcf6e4jGxoayolURET2WpUJpRlodvcH43AjIcGsSF1Z8f/KrP3QbPwhwNIK4xPplU5uuo+Tm+6rdRjSB1WWUNx9ObDYzP4uVh0NzAdmAxNi3QRgVizPBj4cP+11FPBi6hoTkT1zctOvOLnpV7UOQ/qIqp82/AngFjPbD3gaOIeQxO4ws4nAc8D42PYuYBSwCNgY24r0CSc0Tgfgx6eOq3EkInuu0oTi7o8AIzt46egO2jpwQZXxiIhIdfRNeRERKYUSioiIlEIJRURESqGEIiIipVBCERGRUlT9sWER2QsnNv64raxHrEhPpysUEREphRKKSI2MaZzGmMZptQ5DpDRKKCIiUgrdQxHpJmMab28r/+TUD9YwEpFq6ApFRERKoYQiIiKlUJeXSIXGNN6aDeljv9K76QpFRERKoYQi0keMa/od45p+V+swpBdTQhERkVIooYiISCmUUEREpBRKKCIiUgolFBERKYUSioiIlEIJRURESlFpQjGzZ8zsMTN7xMzmxrpDzOweM1sY/x8c683MrjazRWb2qJkdWWVsIiJSru64Qvlnd3+7u4+Mw5cAc9x9BDAnDgMcD4yIf5OAyd0Qm4iIlKQWXV5jgamxPBU4Kau/2YMHgIPM7LAaxCciInug6oTiwN1mNs/MJsW6Q919GUD8PzDWDwYWZ+M2xzoREakDVT9t+L3uvtTMBgL3mNmfdtLWOqjzlzUKiWkSwLBhw8qJUkRE9lqlVyjuvjT+XwnMAN4FrEhdWfH/yti8GRiajT4EWNrBNKe4+0h3H9nQ0FBl+CIishsqSyhm9ioze3UqA8cAjwOzgQmx2QRgVizPBj4cP+11FPBi6hoTEZGer8our0OBGWaW5nOru//MzB4C7jCzicBzwPjY/i5gFLAI2AicU2FsIiJSssoSirs/DRzeQf3zwNEd1DtwQVXxiIhItfQTwCIlG9P4w2yo5z+M4tSmh9vKjaccUcNIpN71/K1dRETqghKKiIiUQglFRERKoYQiIiKlUEIR6YNOafo9pzT9vtZhSC+jhCIiIqVQQhERkVLoeygiJRjTdHM2pPM06Zu05YuISCmUUEREpBRKKCIiUgolFBERKYVuyosAo6df01a+c9yFNYxEpH7pCkWkA6OnT2b09Mm1DkOkriihiIhIKZRQRESkFEooIiJSCiUUEREphRKKiIiUQglFRERKoe+hiEib8U2Pt5WnnfLWGkYi9UhXKCIiUorKr1DMrD8wF1ji7mPM7A3Aj4BDgD8AZ7n7VjPbH7gZeAfwPPBBd3+m6vik7xo9/apsqH/n7ZqmAHDnKZMqjkikvnXHFcpFwIJs+JvAFe4+AlgLTIz1E4G17v5G4IrYTqTHGtN0I2Oabqx1GCI9RqUJxcyGAKOB78dhA94PNMYmU4GTYnlsHCa+fnRsLyIidaDqK5Qrgc8BrXH4tcAL7t4Sh5uBwbE8GFgMEF9/MbYXEZE6UFlCMbMxwEp3n5dXd9DUu/BaPt1JZjbXzOauWrWqhEhFRKQMVV6hvBc40cyeIdyEfz/hiuUgM0sfBhgCLI3lZmAoQHz9NcCaHSfq7lPcfaS7j2xoaKgwfBER2R2VJRR3v9Tdh7j7cOB04F53PwO4Dzg1NpsAzIrl2XGY+Pq97v6yKxSRWhrddD2jm66vdRjd7vTpf2n7E+lMLb6H8nngYjNbRLhHkvbO64HXxvqLgUtqEJuIiOyhbvmmvLvfD9wfy08D7+qgzWZgfHfEIyIi5dM35UVEpBRdSihmNqcrdSIi0nfttMvLzF4B/BUwwMwOpvho74HA6yqOTURE6siu7qF8DPgkIXnMo0go64BrK4xLRETqzE4TirtfBVxlZp9w9+90U0wiIlKHuvQpL3f/jpm9Bxiej+PuN1cUl4iI1JkuJRQz+wHwN8AjwPZY7YTHzYuIiHT5eygjgbfom+siItKZrn4P5XFgUJWBiEj9OG/GYs6bsbjWYUgP09UrlAHAfDP7PbAlVbr7iZVEJSIidaerCeXLVQYhIiL1r6uf8vrvqgMREZH61tVPea2n+LGr/YB9gQ3ufmBVgYmISH3p6hXKq/NhMzuJDp4YLCIifdcePW3Y3WcSfoFRREQE6HqX17hssB/heyn6TopIL3Za05Nt5X62Xw0jkXrR1U95nZCVW4BngLGlRyMiInWrq/dQzqk6EBERqW9d/YGtIWY2w8xWmtkKM2sysyFVByciIvWjqzflbwRmE34XZTDw41gnIiICdD2hNLj7je7eEv9uAhoqjEtEROpMVxPKajM708z6x78zgeerDExEROpLVxPKR4DTgOXAMuBUQDfqRUSkTVcTyleBCe7e4O4DCQnmyzsbwcxeYWa/N7M/mtkTZnZZrH+DmT1oZgvN7Haz8AF3M9s/Di+Krw/f43clIiLdrqsJ5e/dfW0acPc1wBG7GGcL8H53Pxx4O3CcmR0FfBO4wt1HAGuBibH9RGCtu78RuCK2ExGROtHVhNLPzA5OA2Z2CLv4DosHL8XBfeOfEx7Z0hjrpwInxfLYOEx8/Wgzsy7GJyIiNdbVb8pfDvzWzBoJSeE04Gu7GsnM+gPzgDcC1wJ/Bl5w95bYpJnwMWTi/8UA7t5iZi8CrwVWdzFGEamBz89YAsA3Tx68i5bS23X1m/I3m9lcwtWFAePcfX4XxtsOvN3MDgJmAG/uqFn839HVyMueF2Zmk4BJAMOGDetK+CJtRk+/PBvq6vmUiHRFl/eomEB2mUQ6GfcFM7sfOAo4yMz2iVcpQ4ClsVkzMBRoNrN9gNcAazqY1hRgCsDIkSP1gEoRkR5ijx5f3xVm1hCvTDCzVwIfABYA9xE+dgwwAZgVy7PjMPH1e91dCUNEpE5Uec1/GDA13kfpB9zh7j8xs/nAj8zs34GHgetj++uBH5jZIsKVyekVxiYiIiWrLKG4+6N08NFid3+aDn7t0d03A+OrikdERKpVWZeXiIj0LfqYi/R6o2YU35E1bfIildEVioiIlEIJRURK89UZS/nqjKW7bii9khKK9EqjZnyNUTN2+TAHESmREoqIiJRCCUVEREqhhCIiIqVQQhERkVIooYiISCmUUEREpBRKKCIiUgolFBERKYUSiohU4vIZy7l8xvJahyHdSAlFRERKoYQiIiKlUEIREZFSKKGIiEgplFBERKQUSigiIlIK/R6qiHSrG6avbCt/ZNzAGkYiZVNCEZHKfXfGirbyK7AaRiJVUpeXiIiUorKEYmZDzew+M1tgZk+Y2UWx/hAzu8fMFsb/B8d6M7OrzWyRmT1qZkdWFZuIiJSvyiuUFuDT7v5m4CjgAjN7C3AJMMfdRwBz4jDA8cCI+DcJmFxhbCIiUrLKEoq7L3P3P8TyemABMBgYC0yNzaYCJ8XyWOBmDx4ADjKzw6qKT0REytUtN+XNbDhwBPAgcKi7L4OQdMwsfcxjMLA4G6051i3bYVqTCFcwDBs2rNK4RaRatzStaiufcUpDDSORMlR+U97MDgCagE+6+7qdNe2gzl9W4T7F3Ue6+8iGBm2AUhg140uMmvGlWoch0mdVmlDMbF9CMrnF3afH6hWpKyv+Tx9KbwaGZqMPAZZWGZ+I9Fyzpq1m1rTVtQ5DdkOVn/Iy4Hpggbv/V/bSbGBCLE8AZmX1H46f9joKeDF1jYmISM9X5T2U9wJnAY+Z2SOx7gvAN4A7zGwi8BwwPr52FzAKWARsBM6pMDYR6WEam4qrkVNPGVDDSGRPVZZQ3P3XdHxfBODoDto7cEFV8YhI/brr9pBsRn1QiaYn0zflRUSkFEooIiJSCj0cUnq842ed31b+6Vg9QEGkp9IVitS1UTMvZdTMS2sdhoighCIiIiVRQhERkVIooUjdGTXzYkbNvLjWYYjIDnRTXnqk42edmQ29umZxiEjX6QpFRERKoYQiIiKlUEIREZFSKKGIiEgplFBERKQU+pSX9BjHzT6urWzoqbIi9UYJRWrqzJlFEtH1skh90y4sIiKlUEIREZFSKKFItzt/+nGcP/24XTcUkbqihCIideWe21Zzz22rd91Qup0SioiIlEIJRURESqGEIt3i003H8ekm3TcR6c0qSyhmdoOZrTSzx7O6Q8zsHjNbGP8fHOvNzK42s0Vm9qiZHVlVXCLSe9x3yyruu2VVrcOQqMorlJuAHU9JLwHmuPsIYE4cBjgeGBH/JgGTK4xLREQqUFlCcfdfAmt2qB4LTI3lqcBJWf3NHjwAHGRmh1UVm4iIlK+776Ec6u7LAOL/gbF+MLA4a9cc66SOfWHacXxhmu6biPQVPeWmvHVQ5x02NJtkZnPNbO6qVeo77Wkuu+NYLrvj2FqHISI10N0JZUXqyor/V8b6ZmBo1m4IsLSjCbj7FHcf6e4jGxoaKg1WRES6rrsTymxgQixPAGZl9R+On/Y6CngxdY2JiEh9qOzx9WZ2G/A+YICZNQNfAr4B3GFmE4HngPGx+V3AKGARsBE4p6q4RKR3+vUPii7wfzxLvRe1UFlCcfcPdfLS0R20deCCqmIREZHq6Qe2ZLd967bipvtnP/TzGkYiIj1JT/mUl4iI1Dldoche+fqPiquVL5yuqxWRvkxXKCIiUgolFBERKYW6vKRT19xSdGddeIa6s0Rk55RQhO/dHBLHuR/uPGlceWv2OJWOHpQjIn2eEkqdmn3D8QCc+JGftqu/48biYYynnfOzbo1JRPo2JZQ6cuf1IYmMnvjTXbQMbr2puKrYntWfdXbnVyLX/SCMc95Z6uISkd2jm/IiIlIKXaH0AtNv1G+OiEjtKaH0UTdOPQaAcybcXeNIRMr3wE3FgyKPOlsPiuwu6vISEZFSKKGIiEgp1OVVsXnXndBWbrHiV43f/bGf1CIckT5n7g0r28ojPzKwhpH0fkooPcD93xvdVn7fuXcy5/th+OiP3lmrkEREdpu6vEREpBS6QqmRX08ZUwzoUSYi0gsooVTgj5NPBODw82fv9bR+fv0oAI6deNdeT0ukr/vj94r7KYefq/spZVOX115YdM1YFl0zttZhiIj0CEoou+nZq8fx7NXjXlY//9oTmX/tiTWISESkZ1BCEZE+64nrVvDEdStqHUavoXsou9B8zblt5SEXfq+GkYiI9Gw9KqGY2XHAVUB/4Pvu/o1axLH02k/XYrYiInWtxyQUM+sPXAv8X6AZeMjMZrv7/NpGJiISLPvPJW3lwz43uIaR9Ew9JqEA7wIWufvTAGb2I2AssEcJZdV1oXuq4bxz29WvvO4KAAae96l29cu/+297MhsR6SWeujbcS/nbCw7tUvvl33qmrTzos8M7b3fFY6HNp97GiiseBuDQTx2xZ0H2cD0poQwGFmfDzcC7dzZCy6o1rJr8QwAazj+TVZNviuWz27Vbdd21of68C9rVr5j8H3sTr4j0Un+5ajkAb7hoEM3fDuUhnxnUafvl317YVh70mREs/68FoXzxmzsdZ8WVDwFw6CffyYqrfle8YC1Zq+K3Vi2rH/iJD7DymvCrqgMvPJaV19wZy6NZee2sUL5gLCuvnR7L41j53R91GktZzN133aobmNl44Fh3/2gcPgt4l7t/Yod2k4BJcfDvgCeBAcDqWFdWucxp9cZ51HPsvWUe9Rx7b5lHvcb+encv/4di3L1H/AH/APw8G74UuLSL484tu1zVdHvLPOo59t4yj3qOvbfMo95jL/uvJ30P5SFghJm9wcz2A04H9v7ZJSIi0i16zD0Ud28xswuBnxM+NnyDuz9R47BERKSLekxCAXD3u4A9eQrilArKVU23t8yjqulqHrWfruZR++l2V+yl6jE35UVEpL71pHsoIiJSx2re5WVmNwBjgJXA72N5HbCK8LHgA4AWYDPwKuAl4DWE+ywthJ+n6g9sI7yf9HNVHsse/zpKni2UtwzS/LpaX6Y9mUc9x5uXtxPW/87q89daCdvK/h2M00r1J1llLd+dTaeW67Y7lLm97+64XZ3OFoptLLfjdtkVnY3T2ba7GVgBvD4ObwP2jW0WAG+I9ftmry+L5eeBs4CvAu8AXgA2AYOAZ4DT3H1tZ4H2hCuUm4Djdii/DrgEOImQWLbE8veAQ4DPAh8nJIN7Cd+o3xfYAPxjnJYDTxMWIsB7svK/xPI+wAzCAgX4A/CDWN4U55HK58TythgHhBWdP29sapxvKzAra385YSUDLAfmZuOnL3M60EiRAP8j/t8OfD2bx7HZ+7gllg24hrDyARYRkiXAVuD/ZfM7PZvf3dl00/Ix4IZsHicSEjxxOrfG8nrglFhuJayfNI9nsvE/kM3j3dk8miiW+0nAHVns6XcANgFnxvI24MEs9vtiuT/wu1gH8FjW5peEbQfCZ+8XELb5fQjrIbX7RRb7vbG8NStD++3na1n58xTfPptHsf7WAN+J9VsIJ0ppfjsu9xT7O+N0nbAzp+leE6dHHPc7hGW4HnhvFvsmiuV7djaPMykOPldl8/tyNo87Kb6rMJ9wQIGw3D+WxZ7WR2uMPdmUTesoiuVzUVbfSLE+min68/PtchvwoWx+x2bzGJe9j/OyeVyRlc+gWG+PA1/J4r07K78jm+4YimWSlz+Wze9ywvHFgIUU28wmiu14C8X2vh/ws2wei2M8/QnHgvuzcS7L3u8p2Thvj9PvD5xLsX5WZ7E8TzgO9AOeBd5PSGRDgdviNPvH138LvJmwvz0Vp30IcA9wGPBRwrK8DVjr7m8ElgIHuvsIYA7huNypmicUd/8lcWfJyvsDv4zDrwFeGcspS18JDI/lEVn9NqB42E44cPQjHFwHxbITrnzSe38TRZb/LeFAAvAi8NZY3h94dTbNV2bzSO2NsELTVdGQrH3akAD+AjyXjZMeLdNKuAKzOM0DsmkdmM1v/yzeDVl5CMUZx4sUG/k6ih0pJSji+78+m+7QbFr3Z+VHs/d7L/DHWH4YyL8YlX+NuN8OMSbDKJb767PyXyg+Iv5pIJ0B7U9Yv8T3tj6Wjfbr+c/Z/NJy3odwxZvqn6RISP2A32TTas7ql2bz25TNY2MW74qsPCQrr4rTszh+SnqbCQeYNI98uQ+iWM9DKZZd/+y9TCXsBxCW+/Ox/Bzwt9m0jGIbT9uVEw5aaTn8H9qvmzSPyym28Wuy8dcDJ8RyK8XBPsWe5pFiTidUKY43ZfM4Iis/SHEGvwAYn72H07Ly67L5HZjFvpliuQ/Nyo8S1jvArylOrPoTTmLSdA/Oprstm+6yrLwgK6/N4l1C2Mfy9w5hHT+bzSN/FMcSinX4NMXxyymOM9sJB/bkTRTbzaBs/C1ZmyeBg2L5AML7T9vg3Vl5EMW2+jhh390/zvNgwv6ygpD030bY5iAcK4eYmcW6dOLYsSq/5NLVv7hwH8/KG4GxcXgx0BrLD8UVMDa+uda4cM+P9dvi+K3xb0lcYNuzNk44gKTyZXF+TjggbIrllwgbTdpBZmbjpPbbCWeLqf7KrP7P2bgXxuk54cx4WyyvI2T9NP76bJzV2bR+l9VvyNr/K8UZ7dxsnD9l83iOcNaRxtmcTWtiVr84K/8iKx+TTWt7Nr+X4rLvaLpbs3JzNu7WrP0zWXlLNt10ppte25aVX8zKZ2Tl8Vn5vqz8+myZPkM4uKTp/KST6f45K/84K+cx/WWHcVPs+brZSjg4pXFbstf+tEO7fDl0FEc+7nyKbWkLIQGm11qz8iOdjJ9Pd3NWXrlDfOuy2Ldn5bXZvM7Pyvn6PyGb1sKs/Nlsfa7O4sr3ie3ZvHd8T+uzct4mX4Zrs+F8ne24fPPX8uWzJivn6/Mr2fwfJZxcpe01n38e49gd5pGvt3ScaY3TS+1WZOV/zsr5vr6F4hi0mvbHh43ZOGdn9fPjOtoO/CrG00Lo1dgObM6Ox1uAt8XyC4RtZkAcXrvTY3mtk0knCeUpQnadR+gGa43lRyguXVfHjbCFcFbQGhfMY9kK3hoXYivtD5ipvROSzrMUO1Xa4TbHhdnRRrckK+cHwxUUySzfeJ/LNrTVhLOKFN862h+kPWuX6rdR7ABLsvo8po0UO1mKKW1gadm0xnHy9542uGXZtNZkbdZn5UVxfaR55+8xj2tr9tqWLPbnspifpH0CvDtr81Qny31+Vt6UlRdl884PNI9SbAsLKQ4WW2h/AFy3w7TyeafYn6Q46G3L5vcCRULaQPttLy3TdbQ/UCzN5p2f3CzO5pcf+J+lOOBvp/2BaXnWLq3ztD2k8qqsvDRbpquy+W0gnJSkbf/5bB75OsznsSwrt2Z/zVld3mY5xT61JpvH5jiPlg7mka/bfF9bkq2P/OTmaYqktzC+x3z5drQP58eDfLnn8/NsHq07tPOs3YYd2qf3tC0rb6D99rA1a3NAVv94Vv5sNo8/USSOKRTbw0bgi9k4Z1Psi2dk459Bcdz5OOFKrAX4p3gM3gq8dYeE8tquJJSad3l1Yqu7H+Pu7yBciWyO5YeA7e5+DKHbwAkHn0/G8VYTzo7SAXgZYWFvja+ls+RPUvS5vprwfBsIG196SttWQt+kx+F0kGslnPGnA/M3smldR3FGl/ryWwlnx+ln4e4krHgIl5npgwRO6PMnTvtW2p9Rp3ILYWNIG+j6bJwvxnLaSLcDryCcTaWup59QyB+rmpIghIP1xjjNV1B0/fxvikvhVYR+73SQuzArL8viaqQ4M7qaogtiEGHngbBzXxfLDxOuitIyfSqLMe/625qVGyi6HfIboXl3y6EUXQP7Ze1Sl0DyV1k5v9F5C8XB4r8J2xWEK9e0bh+hWE9G6EJNB5Ybs+nmN1jTs+qccH8jracbKLa9SRTb02KKew+rKe7npPWXujpnU5xM3UnR1XlA9p7SSQGEg8ZdWX2ajhH2tXRCNJ1iPc+lONNN93C2UySgzbFNmtYhFB+C2S9OK733aRT7RTpApi62NP7VFNvFrRQHyD9k9Rsp7kveS3GvDMK2nOY3MStfl41/T1a+mOL+4UzCvVeAnxLuN6T5pXtXrbS/3/k8xbI+hmKb+TzF9ps+WEScVxPFek8nAtB+P3iEonv7fRTHrPXAW7J23yYs730JyyIt33vj/DcC/4uwjF4CjjKztH5S9+cKwn6zxswOI5zYdKqnJpT+AGbWj9CnviaWXx/r9weeICyoqwhnJEbYiF9FseFsIfT/70c4W22N4yygWFHnEFYchA3xr7M4Hsymm/rj04Eyfcos9XW3Evoi08bxSPy/lXCQelWczhGEA2M6y01n5q0UZ1YWY0kHnj/EshE2/n3j328odtAbgFNjuTmLywndegfE+X+OYkf8GsXG+y2KjXRanG5/wgaVNsT+FP3C+9D+QL6Bot98M0Uf9dVxuv0I92bSNvdxinslpxMu6SEk93fGdtsp7nusIyS0dDAbFeudcCM1nUGnHX078F2Kq4RbKa4M11J0YW6iSJKbCTe50/r4YrasphG2JSNcLaeE9AChbzqdIe4b27RQnKjsF9uluD6TlVOXkBF29HS/6m8ottHnKfrPH6e4odyfsF2m5Z62bwj7Rb/49xDFerqUIol8Pat/lnDQS9NN2/m+hINcur+XbgADjKTYRtONXyM8OTztGyNpf7WcDoz7EfZnJ+yv36fYb+/K5rGOYht/OKt/KpvfbVkcj8ZYISSwObG8ieKEq5XiPiaEfTW/55P2iSWEfdcJXalp228A/p3iqiIt5/UU9+O2ErbdtP2cS7FuL6K4BwPFzfYDKK6cIGwb6UTgTIoP9hxKsW0spLjftYGiB2Eb8G8UV7YpznRSupKwblP3Zn/CcfFUwsnLhDjNp4AlHi5PJlB82KhDNf9io5ndRsiyAwhveishO6bumX6EjS+dde9H7/joo4j0PenkYUf51fDeaiF0KQ6gODFLJ71LgYEUvSJGOO6mbuBmwsnFwYTbD+sIyXggIQmPd/c1dKLmCUVERHqHntrlJSIidUYJRURESqGEIiIipVBCERGRUiihiIhIKZRQRLrIgl+b2fFZ3Wlm9rOdjSfSV+hjwyK7wczeSviSY3rQ4SPAce7+572Y5j7u3rLrliI9mxKKyG4ys/8kfCv5VcB6d/+qmU0ALiB88fa3wIXu3mpmU4AjCd+Svt3dvxKn0Qz8f8LPNVzp7tNq8FZESlXzH9gSqUOXER6HsxXjmkbSAAABA0lEQVQYGa9aTgbe4+4tMYmcTnjcyyXuviY+I+k+M2t097ZHZbj7ezuagUg9UkIR2U3uvsHMbgdecvctZvYBwvPH5oafjeCVFA8o/JCZTSTsa68jPLwvJZTbuzdykWopoYjsmfTAQ4i/cunu/5o3MLMRhAcBvsvdXzCzH1I8ABHa//iYSN3Tp7xE9t4vgNPMbACAmb3WzIYRniq9HlgXH/197E6mIVL3dIUispfc/TEzuwz4RfyZhW2E3zyfS+jeepzww0+/6XwqIvVPn/ISEZFSqMtLRERKoYQiIiKlUEIREZFSKKGIiEgplFBERKQUSigiIlIKJRQRESmFEoqIiJTifwAuoOzCKAlxrwAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "plot = sns.countplot(x=\"Year\", data=dateOfBirth)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'plot' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-14-3f836e597baf>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mplot\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m: name 'plot' is not defined"
     ]
    }
   ],
   "source": [
    "plot"
   ]
  }
 ],
 "metadata": {
  "file_extension": ".py",
  "kernelspec": {
   "display_name": "'Python Interactive'",
   "language": "python",
   "name": "d509a9d6-8733-4748-97c1-5021defd0f1d"
  },
  "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.7.3"
  },
  "mimetype": "text/x-python",
  "name": "python",
  "npconvert_exporter": "python",
  "pygments_lexer": "ipython3",
  "version": 3
 },
 "nbformat": 4,
 "nbformat_minor": 2
}