GN_Processed.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Generate a dataframe where the primary keys are geographic names. For each GN, a list of p numbers it appears, a list of neighbors for each p number, and a list of dates based on p number."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "files = ['filtered_'+str(n)+'_with_neighbors_normalized.csv' for n in range(1,10)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "geo_names = {}\n",
    "p_number = ''\n",
    "places = []\n",
    "geo_names_list = []\n",
    "\n",
    "for file in files:\n",
    "    f = pd.read_csv(file)\n",
    "    for index, row in f.iterrows():\n",
    "        if row['id_word'][:7] != p_number:\n",
    "            geo_names[p_number] = places\n",
    "            p_number = row['id_word'][:7]\n",
    "            places = []\n",
    "        w = row['lemma']\n",
    "        if w[-2:]=='GN':\n",
    "            places.append(w)\n",
    "            if w not in geo_names_list:\n",
    "                geo_names_list.append(w)\n",
    "geo_names[p_number] = [places]\n",
    "del geo_names['']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "geo_dict = {}\n",
    "geo_neighbors = {}\n",
    "\n",
    "for p in geo_names:\n",
    "    lst = geo_names[p]\n",
    "    for gn in lst:\n",
    "        if isinstance(gn, str):\n",
    "            if gn in geo_dict:\n",
    "                geo_dict[gn].append(p)\n",
    "            else:\n",
    "                geo_dict[gn] = [p]\n",
    "            if gn in geo_neighbors:\n",
    "                geo_neighbors[gn][p] = [i for i in lst if i != gn]\n",
    "            else:\n",
    "                geo_neighbors[gn] = {p: [i for i in lst if i != gn]}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>geo_name</th>\n",
       "      <th>p_nums</th>\n",
       "      <th>neighbors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>tum-ma-al{ki}[]GN</td>\n",
       "      <td>[P124149, P103274, P107843, P134976, P131918, ...</td>\n",
       "      <td>{'P124149': ['eridu{ki}[]GN'], 'P103274': ['ša...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>eridu{ki}[]GN</td>\n",
       "      <td>[P124149, P107420, P212153, P126352, P210370, ...</td>\n",
       "      <td>{'P124149': ['tum-ma-al{ki}[]GN'], 'P107420': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>unu{ki}[]GN</td>\n",
       "      <td>[P405489, P104590, P103800, P107843, P123981, ...</td>\n",
       "      <td>{'P405489': [], 'P104590': ['nibru{ki}-a[]GN',...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>zimbir{ki}[]GN</td>\n",
       "      <td>[P332036, P131582, P111934, P117626, P134703, ...</td>\n",
       "      <td>{'P332036': ['uri₅{ki}-ma[]GN', 'mu-ri-iq-ti-i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>uri₅{ki}-ma[]GN</td>\n",
       "      <td>[P332036, P124307, P103657, P106357, P104590, ...</td>\n",
       "      <td>{'P332036': ['zimbir{ki}[]GN', 'mu-ri-iq-ti-id...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            geo_name                                             p_nums  \\\n",
       "0  tum-ma-al{ki}[]GN  [P124149, P103274, P107843, P134976, P131918, ...   \n",
       "1      eridu{ki}[]GN  [P124149, P107420, P212153, P126352, P210370, ...   \n",
       "2        unu{ki}[]GN  [P405489, P104590, P103800, P107843, P123981, ...   \n",
       "3     zimbir{ki}[]GN  [P332036, P131582, P111934, P117626, P134703, ...   \n",
       "4    uri₅{ki}-ma[]GN  [P332036, P124307, P103657, P106357, P104590, ...   \n",
       "\n",
       "                                           neighbors  \n",
       "0  {'P124149': ['eridu{ki}[]GN'], 'P103274': ['ša...  \n",
       "1  {'P124149': ['tum-ma-al{ki}[]GN'], 'P107420': ...  \n",
       "2  {'P405489': [], 'P104590': ['nibru{ki}-a[]GN',...  \n",
       "3  {'P332036': ['uri₅{ki}-ma[]GN', 'mu-ri-iq-ti-i...  \n",
       "4  {'P332036': ['zimbir{ki}[]GN', 'mu-ri-iq-ti-id...  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d = {'geo_name':list(geo_dict.keys()),'p_nums': list(geo_dict.values())}\n",
    "geo_df = pd.DataFrame.from_dict(data = d)\n",
    "geo_df.loc[:, 'neighbors'] = geo_df['geo_name'].map(geo_neighbors)\n",
    "geo_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'P124149': ['eridu{ki}[]GN'],\n",
       " 'P103274': ['ša-aš-ru{ki}[]GN'],\n",
       " 'P107843': ['unu{ki}[]GN'],\n",
       " 'P134976': ['ki-maš{ki}[]GN'],\n",
       " 'P131918': [],\n",
       " 'P320910': [],\n",
       " 'P123770': [],\n",
       " 'P134033': [],\n",
       " 'P390787': ['ha-ar-ši{ki}[]GN'],\n",
       " 'P113794': ['ur-bi₂-lum{ki}[]GN', 'ša-aš-ru{ki}[]GN', 'ša-aš-ru{ki}[]GN'],\n",
       " 'P126465': ['ki-maš{ki}[]GN', 'hur-ti{ki}[]GN'],\n",
       " 'P407961': ['ur-bi₂-lum{ki}[]GN'],\n",
       " 'P109476': [],\n",
       " 'P113713': [],\n",
       " 'P128830': ['ki-maš{ki}[]GN', 'hur-ti{ki}[]GN'],\n",
       " 'P123521': ['ha-ar-ši{ki}[]GN', 'ki-maš{ki}[]GN'],\n",
       " 'P116837': [],\n",
       " 'P134267': ['ki-maš{ki}[]GN'],\n",
       " 'P133905': ['ša-aš-ru{ki}[]GN'],\n",
       " 'P107770': ['unu{ki}-ga-še₃[]GN', 'ur-bi₂-lum{ki}[]GN'],\n",
       " 'P110439': ['ki-maš{ki}[]GN', 'hur-ti{ki}[]GN'],\n",
       " 'P131929': ['umma{ki}[]GN'],\n",
       " 'P113737': [],\n",
       " 'P126389': [],\n",
       " 'P143976': [],\n",
       " 'P126414': ['ki-maš{ki}[]GN'],\n",
       " 'P103709': ['ki-maš{ki}[]GN'],\n",
       " 'P128852': ['ki-maš{ki}[]GN'],\n",
       " 'P127861': [],\n",
       " 'P126333': ['ki-maš{ki}[]GN'],\n",
       " 'P123616': ['unu{ki}-ga[]GN', 'ki-maš{ki}[]GN'],\n",
       " 'P122752': [],\n",
       " 'P123380': ['ha-ar-ši{ki}[]GN', 'ki-maš{ki}[]GN'],\n",
       " 'P103539': ['hu-uh₂-nu-ri{ki}[]GN'],\n",
       " 'P320609': [],\n",
       " 'P143961': ['ur-bi₂-lum{ki}[]GN', 'uri₅{ki}-ma[]GN'],\n",
       " 'P106341': ['ha-ma-zi₂{ki}[]GN',\n",
       "  'šuruppak{ki}-ta[]GN',\n",
       "  'adab{ki}[]GN',\n",
       "  'unu{ki}[]GN',\n",
       "  'adab{ki}-ta[]GN',\n",
       "  'nibru{ki}[]GN'],\n",
       " 'P124198': [],\n",
       " 'P128898': ['ur-bi₂-lum{ki}[]GN'],\n",
       " 'P107736': [],\n",
       " 'P118469': ['unu{ki}[]GN',\n",
       "  'i₃-si-in{ki}[]GN',\n",
       "  'ma-ri₂{ki}-me[]GN',\n",
       "  'a-hu-ti{ki}[]GN',\n",
       "  'ki-maš{ki}[]GN'],\n",
       " 'P320741': ['ki-maš{ki}[]GN'],\n",
       " 'P116830': ['ki-maš{ki}[]GN'],\n",
       " 'P320977': ['ki-maš{ki}[]GN'],\n",
       " 'P429724': [],\n",
       " 'P126484': ['ša-aš-ru{ki}[]GN'],\n",
       " 'P122773': [],\n",
       " 'P109535': ['ki-maš{ki}[]GN', 'hu-ur₅-ti{ki}[]GN'],\n",
       " 'P211696': ['šuruppak{ki}[]GN'],\n",
       " 'P107693': ['ki-maš{ki}[]GN'],\n",
       " 'P210507': ['ki-maš{ki}[]GN'],\n",
       " 'P123737': ['ur-bi₂-lum{ki}[]GN'],\n",
       " 'P109544': ['ki-maš{ki}[]GN'],\n",
       " 'P113470': ['si-mu-ru-um{ki}[]GN'],\n",
       " 'P135148': [],\n",
       " 'P109608': [],\n",
       " 'P103755': [],\n",
       " 'P103751': ['ki-maš{ki}[]GN'],\n",
       " 'P124151': ['eridu{ki}[]GN'],\n",
       " 'P291882': ['hu-uh₂-nu-ri{ki}[]GN'],\n",
       " 'P143924': ['urum₂{ki}[]GN',\n",
       "  'ba-lu-e{ki}[]GN',\n",
       "  'ku-lu-um{ki}[]GN',\n",
       "  'uri₅{ki}-še₃[]GN',\n",
       "  'uri₅{ki}-ma[]GN',\n",
       "  'ur-bi₂-lum{ki}[]GN'],\n",
       " 'P102508': ['ha-ar-ši{ki}[]GN', 'ki-maš{ki}[]GN'],\n",
       " 'P134020': ['si-ga-an{ki}[]GN'],\n",
       " 'P235609': [],\n",
       " 'P128833': ['ki-maš{ki}[]GN', 'hur-ti{ki}[]GN'],\n",
       " 'P134995': ['ša-aš-ru{ki}[]GN'],\n",
       " 'P320739': ['ki-maš{ki}[]GN'],\n",
       " 'P127307': [],\n",
       " 'P109540': ['ki-maš{ki}[]GN', 'hur-ti{ki}[]GN'],\n",
       " 'P101000': ['ki-maš{ki}[]GN'],\n",
       " 'P131985': ['si-mu-ru-um{ki}[]GN', 'lu-lu-bu{ki}[]GN'],\n",
       " 'P131952': ['ur-bi₂-lum{ki}[]GN'],\n",
       " 'P130514': ['unu{ki}-še₃[]GN', 'zi-da-ah-ri{ki}[]GN', 'hu-uh₂-nu-ri{ki}[]GN'],\n",
       " 'P131980': ['si-mu-ru-um{ki}[]GN', 'lu-lu-bu{ki}[]GN'],\n",
       " 'P109551': ['ki-maš{ki}[]GN'],\n",
       " 'P109552': ['ki-maš{ki}[]GN'],\n",
       " 'P144262': ['umma{ki}-ta[]GN', 'hu-uh₂-nu-ri{ki}[]GN'],\n",
       " 'P113619': ['ha-ar-ši{ki}[]GN'],\n",
       " 'P127534': [],\n",
       " 'P100996': [],\n",
       " 'P122566': ['ki-maš{ki}[]GN', 'hur-ti{ki}[]GN'],\n",
       " 'P117633': [],\n",
       " 'P103314': [],\n",
       " 'P101367': ['unu{ki}[]GN', 'si-mu-ru-um{ki}[]GN', 'lu-lu-bu{ki}[]GN'],\n",
       " 'P102196': [],\n",
       " 'P126522': ['eridu{ki}[]GN'],\n",
       " 'P125961': ['uri₅{ki}-ma[]GN', 'uri₅{ki}-ma-ke₄[]GN', 'za-ab-ša-li{ki}[]GN'],\n",
       " 'P320593': [],\n",
       " 'P143962': [],\n",
       " 'P123636': ['ša-aš-ru{ki}[]GN'],\n",
       " 'P118509': ['hu-uh₂-nu-ri{ki}[]GN'],\n",
       " 'P109560': [],\n",
       " 'P134237': ['ša-zi-bi{ki}-še₃[]GN', 'ha-ar-ši{ki}[]GN', 'ki-maš{ki}[]GN'],\n",
       " 'P109553': ['ki-maš{ki}[]GN'],\n",
       " 'P105822': ['ki-maš{ki}[]GN', 'hu-ur₅-ti{ki}[]GN'],\n",
       " 'P113634': ['ki-maš{ki}[]GN'],\n",
       " 'P126592': ['eridu{ki}[]GN'],\n",
       " 'P211709': ['umma{ki}[]GN'],\n",
       " 'P100984': ['eridu{ki}[]GN'],\n",
       " 'P143739': ['ki-maš{ki}[]GN'],\n",
       " 'P125632': [],\n",
       " 'P212008': ['ha-ar-ši{ki}[]GN',\n",
       "  'hi-bi₂-la-at{ki}[]GN',\n",
       "  'eb-la{ki}[]GN',\n",
       "  'ša-aš-ru{ki}[]GN'],\n",
       " 'P124197': [],\n",
       " 'P126625': [],\n",
       " 'P134270': ['ha-ar-ši{ki}[]GN', 'ki-maš{ki}[]GN', 'hu-ur-ti{ki}[]GN'],\n",
       " 'P135067': [],\n",
       " 'P135070': ['ur-bi₂-lum{ki}[]GN'],\n",
       " 'P126330': ['ša-aš-ru{ki}[]GN'],\n",
       " 'P106331': ['ur-bi₂-lum{ki}[]GN'],\n",
       " 'P128407': [],\n",
       " 'P320969': ['ki-maš{ki}[]GN'],\n",
       " 'P103082': ['ša-aš-ru{ki}[]GN'],\n",
       " 'P109536': ['ki-maš{ki}[]GN', 'hur-ti{ki}[]GN'],\n",
       " 'P116836': [],\n",
       " 'P131094': ['nibru{ki}[]GN', 'uri₅{ki}-ma[]GN', 'unu{ki}-ga[]GN'],\n",
       " 'P211883': ['uri₅{ki}-ma-ke₄[]GN'],\n",
       " 'P103827': ['unu{ki}-ga[]GN', 'nibru{ki}[]GN', 'ki-maš{ki}[]GN'],\n",
       " 'P320966': [],\n",
       " 'P118344': [],\n",
       " 'P135983': ['ki-maš{ki}[]GN'],\n",
       " 'P130348': [],\n",
       " 'P128587': ['ša-aš-ru{ki}[]GN'],\n",
       " 'P123320': ['ki-maš{ki}[]GN'],\n",
       " 'P211658': ['ha-ar-ši{ki}[]GN', 'ki-maš{ki}[]GN'],\n",
       " 'P122643': ['si-mu-ru-um{ki}[]GN', 'lu-lu-bu{ki}[]GN'],\n",
       " 'P109633': [],\n",
       " 'P103531': ['ša-aš-ru{ki}[]GN'],\n",
       " 'P129754': ['ur-bi₂-lum{ki}[]GN'],\n",
       " 'P103338': ['umma{ki}-ka[]GN'],\n",
       " 'P118330': ['umma{ki}[]GN'],\n",
       " 'P143115': ['si-mu-ru-um{ki}[]GN', 'lu-lu-bu{ki}[]GN'],\n",
       " 'P133988': []}"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "geo_df['neighbors'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "dates = pd.read_csv(\"bdtns_metadata/dates.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "scrolled": true
   },
   "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>Unnamed: 0</th>\n",
       "      <th>BDTNS No</th>\n",
       "      <th>CDLI No</th>\n",
       "      <th>Original date</th>\n",
       "      <th>Converted Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>38779</td>\n",
       "      <td>P142868</td>\n",
       "      <td>AS02 - 05 - 00</td>\n",
       "      <td>68.05</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 0  BDTNS No  CDLI No   Original date  Converted Date\n",
       "23          23     38779  P142868  AS02 - 05 - 00           68.05"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dates[dates['CDLI No'] == 'P142868']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/dominicliu/opt/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:2: UserWarning: DataFrame columns are not unique, some columns will be omitted.\n",
      "  \n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "{'P142785': ['IS01 - 07 - 00', 85.07],\n",
       " 'P142787': ['SS05 - 06 - 12', 80.0612],\n",
       " 'P142788': ['SH48 - 12 - 20', 66.122],\n",
       " 'P142789': ['SS04 - XX - 15', 79.0015],\n",
       " 'P142790': ['XXXX - 01 - 01', 0.0101],\n",
       " 'P142791': ['AS06 - 11 - 19', 72.1119],\n",
       " 'P142793': ['SS07 - 11 - 00', 82.11],\n",
       " 'P142794': ['SH44 - 12 - 28', 62.1228],\n",
       " 'P142799': ['SH45 - 11 - 00', 63.11],\n",
       " 'P142803': ['SS06 - 11d - 29', 81.1129],\n",
       " 'P142805': ['XXXX - XX - 23', 0.0023],\n",
       " 'P142807': ['SS07 - 02 - 00', 82.02],\n",
       " 'P142809': ['AS05 - 09 - 00?', 71.09],\n",
       " 'P142810': ['SS03 - 00 - 00', 78.0],\n",
       " 'P142811': ['SS01 - 05 - 03+', 76.0503],\n",
       " 'P142812': ['AS03 - 08 - 00', 69.08],\n",
       " 'P142813': ['AS03 - 11d - 28', 69.1128],\n",
       " 'P142849': ['SH47 - 02 - 00', 65.02],\n",
       " 'P142852': ['XXXX - XX - XX', 0.0],\n",
       " 'P142855': ['AS01 - 06 - 25', 67.0625],\n",
       " 'P142857': ['SH42 - 09 - 16', 60.09160000000001],\n",
       " 'P142858': ['SS07 - 11 - 03', 82.1103],\n",
       " 'P142859': ['SS04 - 07 - 00', 79.07],\n",
       " 'P142868': ['AS02 - 05 - 00', 68.05],\n",
       " 'P248580': ['AS01 - 00 - 00', 67.0],\n",
       " 'P248618': ['SH47 - 06 - 17', 65.0617],\n",
       " 'P248623': ['SS09 - 04 - 00', 84.04],\n",
       " 'P248626': ['SH47 - 09 - 23', 65.09230000000001],\n",
       " 'P248629': ['SH46 - 03 - 06', 64.0306],\n",
       " 'P248636': ['SH40 - 05 - 19', 58.0519],\n",
       " 'P248637': ['SH48 - 00 - 00', 66.0],\n",
       " 'P248651': ['SH44 - 09 - 00', 62.09],\n",
       " 'P248659': ['SH46 - 02 - 03', 64.02029999999999],\n",
       " 'P248672': ['AS05 - 06 - 00', 71.06],\n",
       " 'P248711': ['AS07 - 11 - 27', 73.1127],\n",
       " 'P248714': ['0000 - 00 - 00', 0.0],\n",
       " 'P248717': ['0000 - 08 - 00', 0.08],\n",
       " 'P248718': ['SH46 - 01 - 00', 64.01],\n",
       " 'P248675': ['SH46 - 12 - 03', 64.1203],\n",
       " 'P248713': ['0000 - 03 - 00', 0.03],\n",
       " 'P248676': ['SH47 - 09 - 06', 65.09060000000001],\n",
       " 'P248683': ['SS08 - 05 - 00', 83.05],\n",
       " 'P248730': ['SS07 - 10 - 07', 82.10069999999997],\n",
       " 'P248731': ['AS07 - 03 - 09', 73.0309],\n",
       " 'P248732': ['IS02 - 09 - 16', 86.0916],\n",
       " 'P248734': ['SH46 - 05 - 00', 64.05],\n",
       " 'P248735': ['AS07 - 06 - 10', 73.061],\n",
       " 'P248736': ['SH47 - 10 - 13', 65.1013],\n",
       " 'P248737': ['AS05 - 03 - 00', 71.03],\n",
       " 'P248738': ['SS03 - 10 - 18', 78.1018],\n",
       " 'P248739': ['AS01 - 05 - 07', 67.05069999999999],\n",
       " 'P248740': ['SH44 - 02 - 01', 62.020100000000006],\n",
       " 'P248741': ['AS04 - 09 - 17', 70.0917],\n",
       " 'P248742': ['AS04 - 12 - 23', 70.12230000000001],\n",
       " 'P248743': ['AS06 - 07 - 24', 72.07239999999999],\n",
       " 'P248744': ['AS06 - 11 - 00', 72.11],\n",
       " 'P248745': ['AS08 - 11 - 28', 74.1128],\n",
       " 'P248746': ['AS07 - 10 - 09', 73.1009],\n",
       " 'P248792': ['SH41 - 12 - 00', 59.12],\n",
       " 'P248798': ['AS04 - 08 - 00', 70.08],\n",
       " 'P248804': ['0000 - 00 - 00', 0.0],\n",
       " 'P248805': ['0000 - 07 - 00', 0.07],\n",
       " 'P248830': ['SS06 - 12 - 00', 81.12],\n",
       " 'P128014': ['SH44 - 03m - 00', 62.03],\n",
       " 'P248864': ['SH48 - 07 - 18', 66.0718],\n",
       " 'P248867': ['SS05 - 02 - 02', 80.0202],\n",
       " 'P248876': ['SH46 - 03 - 07', 64.0307],\n",
       " 'P248901': ['SH47 - 03 - 16', 65.0316],\n",
       " 'P248907': ['AS05 - 03 - 25', 71.0325],\n",
       " 'P248974': ['IS02 - 02 - 00', 86.02],\n",
       " 'P248989': ['SS03 - 06 - 00', 78.06],\n",
       " 'P249006': ['SH47 - 09 - 00', 65.09],\n",
       " 'P249013': ['SH42 - 01 - 23 // AS06 - 01 - 23', 60.0123],\n",
       " 'P249015': ['AS07 - 01 - 00', 73.01],\n",
       " 'P249018': ['SS01 - 12 - 00', 76.12],\n",
       " 'P249020': ['SS09 - 09 - XX', 84.09],\n",
       " 'P249019': ['IS01 - 11 - 00', 85.11],\n",
       " 'P249023': ['XXXX - XX - 25+', 0.0025],\n",
       " 'P249201': ['XXXX - XX - XX', 0.0],\n",
       " 'P330383': ['XXXX - XX - XX', 0.0],\n",
       " 'P330381': ['SS07 - 10 - 08', 82.10079999999998],\n",
       " 'P330390': ['SH45 - XX - 28', 63.0028],\n",
       " 'P330392': ['AS04 - 10 - 24', 70.10239999999999],\n",
       " 'P330393': ['SS05 - 04 - 17', 80.0417],\n",
       " 'P330397': ['XXXX - XX - XX', 0.0],\n",
       " 'P330441': ['AS05 - 11 - 10', 71.111],\n",
       " 'P330443': ['AS07 - 09 - 09', 73.0909],\n",
       " 'P330458': ['SH46 - 02 - 24', 64.02239999999999],\n",
       " 'P330459': ['SS09 - 12 - 28', 84.1228],\n",
       " 'P330462': ['SH46 - 06 - 00', 64.06],\n",
       " 'P330480': ['SH47 - 10 - 15', 65.10149999999999],\n",
       " 'P330482': ['SH48 - 09 - 20', 66.092],\n",
       " 'P330484': ['SH48 - 12 - 00', 66.12],\n",
       " 'P330487': ['AS01 - 12 - 29', 67.1229],\n",
       " 'P330489': ['SH48 - 07 - 23', 66.0723],\n",
       " 'P330493': ['SS09 - 07 - 00', 84.07],\n",
       " 'P330497': ['AS08 - 04 - 05', 74.04050000000002],\n",
       " 'P330498': ['SH41 - 03 - 00', 59.03],\n",
       " 'P330499': ['SH46 - 02 - 00', 64.02],\n",
       " 'P330542': ['AS05 - 06 - 09', 71.0609],\n",
       " 'P330548': ['SH47? - 12 - 08', 0.1208],\n",
       " 'P330550': ['SH46 - 02 - 00', 64.02],\n",
       " 'P330572': ['AS05 - 03 - 26', 71.0326],\n",
       " 'P330582': ['SH46 - 07 - 25', 64.07249999999999],\n",
       " 'P330594': ['SH44 - 10 - 29', 62.1029],\n",
       " 'P330616': ['SH45 - 12 - 06+', 63.1206],\n",
       " 'P330620': ['SH46 - 02 - 00', 64.02],\n",
       " 'P330622': ['XXXX - XX - XX', 0.0],\n",
       " 'P330628': ['SS04 - 05 - 12', 79.0512],\n",
       " 'P330630': ['SS06 - 08 - 30', 81.083],\n",
       " 'P330632': ['0000 - 00 - 11', 0.0011],\n",
       " 'P330633': ['SS08 - 08 - 10(+)', 83.081],\n",
       " 'P330635': ['SH47 - 07 - 25', 65.07249999999999],\n",
       " 'P330638': ['SH44 - 10 - 29', 62.1029],\n",
       " 'P330639': ['SS09 - 10 - 24', 84.10239999999997],\n",
       " 'P330642': ['SH46 - 05 - 03 // AS03 - 05 - 03', 64.0503],\n",
       " 'P330643': ['SH47 - 11 - 08', 65.1108],\n",
       " 'P330645': ['SH46 - XX - XX', 64.0],\n",
       " 'P330646': ['AS01 - 09 - 26', 67.0926],\n",
       " 'P330701': ['SS05 - 02 - 12', 80.0212],\n",
       " 'P330694': ['SH37 - 07 - 00 // SS04 - 07 - 00', 55.07],\n",
       " 'P330696': ['SH46 - 04 - 00', 64.04],\n",
       " 'P330697': ['AS09 - 01 - 13', 75.0113],\n",
       " 'P330698': ['0000 - 00 - 00', 0.0],\n",
       " 'P330657': ['XXXX - XX - XX', 0.0],\n",
       " 'P330658': ['SH42 - 09 - 03 // AS06 - 09 - 03', 60.090300000000006],\n",
       " 'P330659': ['SH46 - 04 - 00', 64.04],\n",
       " 'P330660': ['SH47 - 07 - 25', 65.07249999999999],\n",
       " 'P330661': ['SH47 - 07 - 15', 65.07149999999999],\n",
       " 'P330662': ['AS01 - 02 - 00', 67.02],\n",
       " 'P330663': ['AS01 - 09 - 21', 67.0921],\n",
       " 'P330664': ['AS01 - 10 - 27 // AS01 - 11 - 27', 67.1027],\n",
       " 'P330665': ['AS02 - 06 - 03', 68.0603],\n",
       " 'P330666': ['AS02 - 06 - 03', 68.0603],\n",
       " 'P330667': ['AS02 - 06 - 22', 68.0622],\n",
       " 'P330668': ['AS02 - 09 - 21', 68.0921],\n",
       " 'P330669': ['AS03 - 06 - 00', 69.06],\n",
       " 'P330670': ['AS03 - 11 - 06', 69.1106],\n",
       " 'P330671': ['AS03 - 11 - 07', 69.1107],\n",
       " 'P330672': ['AS04 - 11 - 04', 70.1104],\n",
       " 'P330673': ['AS06 - 02 - 04', 72.0204],\n",
       " 'P330674': ['AS07 - 02 - 11', 73.02109999999998],\n",
       " 'P330675': ['AS08 - 11 - 00', 74.11],\n",
       " 'P330676': ['AS02 - 04 - XX', 68.04],\n",
       " 'P330677': ['SS02 - 03 - 00', 77.03],\n",
       " 'P330678': ['SS05 - 08 - 00', 80.08],\n",
       " 'P330679': ['SS06 - XX - 09', 81.0009],\n",
       " 'P330680': ['SS08 - 05 - 12', 83.0512],\n",
       " 'P330682': ['XXXX - 02 - 00', 0.02],\n",
       " 'P330683': ['0000 - 05 - 00', 0.05],\n",
       " 'P330684': ['AS02 - 01 - 17', 68.0117],\n",
       " 'P330685': ['XXXX - XX - XX', 0.0],\n",
       " 'P330700': ['SH46 - 04 - 00 // AS03 - 04 - 00', 64.04],\n",
       " 'P100041': ['SSXX - 00 - 00', 0.0],\n",
       " 'P100189': ['SH46 - 08 - 05', 64.0805],\n",
       " 'P100190': ['SH47 - 07 - 29', 65.07289999999999],\n",
       " 'P100191': ['AS01 - 03 - 24', 67.0324],\n",
       " 'P100211': ['AS01 - 12 - 11', 67.1211],\n",
       " 'P132110': ['AS05 - 05 - 25', 71.0525],\n",
       " 'P132111': ['SH46 - 12 - 00', 64.12],\n",
       " 'P132112': ['SH43 - 10 - 00', 61.1],\n",
       " 'P132114': ['AS01 - 10 - 21', 67.1021],\n",
       " 'P132115': ['SH46 - 03 - 00', 64.03],\n",
       " 'P132116': ['AS04 - 01 - 11', 70.0111],\n",
       " 'P132119': ['SS03 - 09 - 00', 78.09],\n",
       " 'P132120': ['SH47 - 01 - 00', 65.01],\n",
       " 'P132121': ['AS02 - 04 - 10', 68.04100000000001],\n",
       " 'P132122': ['SH35 - 06 - 00', 53.06],\n",
       " 'P132123': ['AS01 - 05 - 16', 67.0516],\n",
       " 'P132125': ['AS06 - 00 - 20', 72.002],\n",
       " 'P132129': ['AS02 - 01 - 15', 68.0115],\n",
       " 'P132135': ['SH46 - 10 - 00', 64.1],\n",
       " 'P132137': ['SH36 - 04 - 00', 54.04],\n",
       " 'P132143': ['SH38 - 04 - 00', 56.04],\n",
       " 'P132148': ['SH47 - 12 - 00', 65.12],\n",
       " 'P132150': ['SH48 - 08 - 00', 66.08],\n",
       " 'P100214': ['SH43 - 09 - 11', 61.0911],\n",
       " 'P100215': ['AS09 - 11 - 19', 75.1119],\n",
       " 'P133836': ['SH43 - 09 - 24', 61.09240000000001],\n",
       " 'P100217': ['SH47 - 02 - 17', 65.0217],\n",
       " 'P100218': ['AS05 - 09 - 00', 71.09],\n",
       " 'P100219': ['SH48 - 06 - 30', 66.063],\n",
       " 'P100220': ['AS02 - 11 - 20', 68.112],\n",
       " 'P100221': ['SH43 - 08 - 00', 61.08],\n",
       " 'P100222': ['SS02 - 08 - 06', 77.0806],\n",
       " 'P100223': ['SH47 - 11 - 00', 65.11],\n",
       " 'P100224': ['SH47 - 01 - 00', 65.01],\n",
       " 'P124599': ['SH41 - 04 - 00', 59.04],\n",
       " 'P100226': ['SH39 - 06 - 00', 57.06],\n",
       " 'P100227': ['SS08 - 12 - 00', 83.12],\n",
       " 'P100228': ['SH43 - 05 - 11', 61.0511],\n",
       " 'P100229': ['SS02 - 09 - 20', 77.092],\n",
       " 'P100230': ['AS08 - 12 - 16', 74.1216],\n",
       " 'P100231': ['AS09 - 01 - 17', 75.0117],\n",
       " 'P100232': ['AS05 - 09 - 15', 71.0915],\n",
       " 'P100259': ['AS05 - 03 - 27', 71.0327],\n",
       " 'P100260': ['SH48 - 08 - 04', 66.0804],\n",
       " 'P100261': ['SH48 - 07 - 02', 66.0702],\n",
       " 'P100262': ['AS05 - 05 - 14', 71.0514],\n",
       " 'P100263': ['AS01 - 04 - 12', 67.0412],\n",
       " 'P100264': ['AS05 - 08 - 09', 71.0809],\n",
       " 'P100265': ['AS01 - 04 - 16', 67.0416],\n",
       " 'P100266': ['AS01 - 11 - 08', 67.1108],\n",
       " 'P100267': ['SH35 - 11 - 00', 53.11],\n",
       " 'P100268': ['AS03 - 03 - 27', 69.0327],\n",
       " 'P100269': ['AS05 - 05 - 06', 71.0506],\n",
       " 'P100270': ['SH46 - 10 - 00', 64.1],\n",
       " 'P100271': ['SH42 - 08 - 00', 60.08],\n",
       " 'P100272': ['AS05 - 10 - 10', 71.101],\n",
       " 'P100273': ['SH47 - 10 - 15', 65.10149999999999],\n",
       " 'P100281': ['AS09 - 00 - 00', 75.0],\n",
       " 'P114331': ['AS04 - 05 - 09', 70.0509],\n",
       " 'P100287': ['SS01 - 10 - 27', 76.1027],\n",
       " 'P100284': ['SH46 - 01 - 24', 64.0124],\n",
       " 'P100292': ['SS09 - 11 - 00', 84.11],\n",
       " 'P100296': ['SH40 - 11 - 06 and SH40 - 11 - 08', 58.1106],\n",
       " 'P100297': ['AS02 - 06 - 24', 68.0624],\n",
       " 'P100301': ['0000 - 00 - 00', 0.0],\n",
       " 'P432670': ['AS07 - 05 - 00', 73.05],\n",
       " 'P432671': ['AS08 - 06 - 10', 74.061],\n",
       " 'P432672': ['SS07 - 03 - 20', 82.03200000000001],\n",
       " 'P100317': ['SS02 - 12 - 00 // SS08 - 12 - 00', 77.12],\n",
       " 'P100318': ['SS07 - 12 - 00', 82.12],\n",
       " 'P100320': ['AS04 - 04 - 29', 70.0429],\n",
       " 'P100321': ['SH46 - XX - XX', 64.0],\n",
       " 'P100322': ['0000 - 00 - 00', 0.0],\n",
       " 'P145540': ['AS08 - 11 - 30', 74.113],\n",
       " 'P145528': ['SS01 - 07 - 00', 76.07],\n",
       " 'P145494': ['AS03 - 10 - 00', 69.1],\n",
       " 'P145495': ['AS03 - 10 - 00', 69.1],\n",
       " 'P145496': ['AS03 - 11 - 00', 69.11],\n",
       " 'P145497': ['AS04 - 01 - 00', 70.01],\n",
       " 'P145498': ['AS04 - 08 - 00', 70.08],\n",
       " 'P145499': ['AS08 - 11 - 00', 74.11],\n",
       " 'P145500': ['AS04 - 10 - 00', 70.1],\n",
       " 'P145501': ['AS07 - 10 - 00', 73.1],\n",
       " 'P145502': ['AS08 - 09 - 00', 74.09],\n",
       " 'P145503': ['AS09 - 06 - 00', 75.06],\n",
       " 'P145504': ['SH33 - 12 - 00', 51.12],\n",
       " 'P145505': ['SS03 - 08 - 00', 78.08],\n",
       " 'P145506': ['SH44 - 05m - 00', 62.05],\n",
       " 'P145507': ['SS02 - 11 - 00', 77.11],\n",
       " 'P145508': ['AS02 - 06 - 00', 68.06],\n",
       " 'P145509': ['AS08 - 09 - 00', 74.09],\n",
       " 'P145510': ['SH46 - 12 - 00', 64.12],\n",
       " 'P145511': ['SS04 - 08 - 00', 79.08],\n",
       " 'P145512': ['SS09 - 11 - 00', 84.11],\n",
       " 'P145513': ['SH42 - 10 - 00', 60.1],\n",
       " 'P145514': ['AS01 - 09? - 00', 67.09],\n",
       " 'P145515': ['AS02 - 10 - 00', 68.1],\n",
       " 'P145516': ['AS08 - 12 - 00', 74.12],\n",
       " 'P145517': ['AS08 - 09 - 00', 74.09],\n",
       " 'P145518': ['SS02 - 01 - 00', 77.01],\n",
       " 'P145519': ['SS01 - 12 - 00', 76.12],\n",
       " 'P145520': ['SS02 - 02 - 00', 77.02],\n",
       " 'P145521': ['SS04 - 09 - 00', 79.09],\n",
       " 'P145522': ['SH47 - 07 - 00', 65.07],\n",
       " 'P145523': ['0000 - 00 - 00', 0.0],\n",
       " 'P145524': ['AS08 - 03 - 00', 74.03],\n",
       " 'P145525': ['IS02 - 12 - 00', 86.12],\n",
       " 'P145526': ['AS02 - 05 - 00', 68.05],\n",
       " 'P145527': ['SS03 - 04 - 00', 78.04],\n",
       " 'P145529': ['0000 - 00 - 00', 0.0],\n",
       " 'P145534': ['AS04 - 10 - 00', 70.1],\n",
       " 'P145538': ['IS01 - 02 - 00', 85.02],\n",
       " 'P145539': ['SH44 - 12 - 00', 62.12],\n",
       " 'P100327': ['AS01 - 08 - 28', 67.08279999999999],\n",
       " 'P459080': ['AS05 - 03 - 28', 71.0328],\n",
       " 'P480066': ['0000 - 04 - 00', 0.04],\n",
       " 'P480067': ['AS02 - 08 - 21', 68.0821],\n",
       " 'P480068': ['0000 - 09? - 00', 0.09],\n",
       " 'P432665': ['SS09 - 06 - 13', 84.0613],\n",
       " 'P432663': ['AS05 - 11 - 22', 71.1122],\n",
       " 'P100328': ['SS04 - 04 - 05', 79.04050000000002],\n",
       " 'P100329': ['AS08 - 06 - 00', 74.06],\n",
       " 'P100330': ['AS04 - 01 - 00', 70.01],\n",
       " 'P100331': ['AS03 - 06 - 00', 69.06],\n",
       " 'P100332': ['SS08 - 05 - 13', 83.0513],\n",
       " 'P100333': ['SH35 - 00 - 00', 53.0],\n",
       " 'P100334': ['SH45 - 10 - 06', 63.1006],\n",
       " 'P100335': ['SH47 - 01 - 08', 65.0108],\n",
       " 'P100336': ['SH46 - 08 - 26', 64.0826],\n",
       " 'P100337': ['SH47 - 01 - 22', 65.0122],\n",
       " 'P100338': ['AS02 - 08 - 00', 68.08],\n",
       " 'P100339': ['AS03 - 02 - 05', 69.0205],\n",
       " 'P100967': ['AS07 - 01 - 04', 73.0104],\n",
       " 'P100968': ['SH43 - 06 - 25', 61.0625],\n",
       " 'P123489': ['SH46 - 08 - 22', 64.0822],\n",
       " 'P123276': ['SH45 - 07 - 03', 63.0703],\n",
       " 'P100971': ['SH45 - 12 - 06', 63.1206],\n",
       " 'P100972': ['SH46 - 01 - 02', 64.01020000000001],\n",
       " 'P100973': ['SH46 - 04 - 18', 64.04180000000001],\n",
       " 'P100974': ['SH46 - 10 - 17', 64.1017],\n",
       " 'P100975': ['SH47 - 04 - 20', 65.042],\n",
       " 'P100976': ['SH47 - 05 - 00', 65.05],\n",
       " 'P100977': ['SH48 - 07 - 19', 66.0719],\n",
       " 'P100978': ['SH47 - 08 - 11', 65.08109999999999],\n",
       " 'P123293': ['SH47 - 11 - 21', 65.1121],\n",
       " 'P100980': ['SH48 - 06 - 13', 66.0613],\n",
       " 'P100981': ['AS05 - 04 - 20', 71.042],\n",
       " 'P100982': ['AS05 - 07 - 06', 71.0706],\n",
       " 'P100983': ['AS05 - 12 - 29', 71.1229],\n",
       " 'P100984': ['AS08 - 08 - 29', 74.0829],\n",
       " 'P100985': ['SS04 - 09 - 02', 79.09020000000002],\n",
       " 'P100986': ['SS06 - 08 - 14', 81.0814],\n",
       " 'P100987': ['SS06 - 08 - 20', 81.082],\n",
       " 'P100988': ['SHXX - XX - 07', 0.0007],\n",
       " 'P100989': ['XXXX - 00 - 00', 0.0],\n",
       " 'P200508': ['SH47 - 04 - 00', 65.04],\n",
       " 'P100990': ['IS02 - 01 - 00', 86.01],\n",
       " 'P100992': ['SH38 - 06 - 00', 56.06],\n",
       " 'P100993': ['SH40 - 01 - 22', 58.0122],\n",
       " 'P100995': ['AS06 - 08 - 00', 72.08],\n",
       " 'P100996': ['SH43 - 03 - 14', 61.0314],\n",
       " 'P100997': ['SH44 - 04 - 00', 62.04],\n",
       " 'P100998': ['SH44 - 04 - 21', 62.0421],\n",
       " 'P100999': ['SH46 - 05 - 00', 64.05],\n",
       " 'P101000': ['SH47 - 02 - 01', 65.0201],\n",
       " 'P101001': ['AS01 - 03 - 00', 67.03],\n",
       " 'P101002': ['AS03 - 06 - 30', 69.063],\n",
       " 'P101003': ['AS04 - 08 - 00', 70.08],\n",
       " 'P101004': ['AS04 - 08 - 17', 70.0817],\n",
       " 'P101005': ['AS07 - 08 - 13', 73.0813],\n",
       " 'P101006': ['AS07 - 08 - 30', 73.083],\n",
       " 'P101007': ['AS07 - 12 - 00', 73.12],\n",
       " 'P101008': ['AS07 - 09 - 25', 73.0925],\n",
       " 'P101009': ['AS07 - 09 - 28', 73.0928],\n",
       " 'P101010': ['AS07 - 09 - 28', 73.0928],\n",
       " 'P101011': ['IS02 - 07 - 00', 86.07],\n",
       " 'P101012': ['AS08 - 09 - 00', 74.09],\n",
       " 'P101013': ['AS09 - 01 - 24', 75.0124],\n",
       " 'P101015': ['SH38 - 04 - 00', 56.04],\n",
       " 'P101016': ['SS06 - 12 - 07', 81.1207],\n",
       " 'P101017': ['SS07 - 12 - 00', 82.12],\n",
       " 'P101018': ['SS09 - 07 - 00', 84.07],\n",
       " 'P101019': ['IS01 - 05 - 00', 85.05],\n",
       " 'P101020': ['0000 - 05 - 00', 0.05],\n",
       " 'P101021': ['SS01?] - 00 - 29', 0.0029],\n",
       " 'P101296': ['SH30 - 06 - 00', 48.06],\n",
       " 'P101297': ['SH36 - 09 - 00', 54.09],\n",
       " 'P101298': ['SH39 - 05 - 00', 57.05],\n",
       " 'P101299': ['SH42 - 07 - 00', 60.07],\n",
       " 'P101300': ['IS02 - 10 - 00', 86.1],\n",
       " 'P101301': ['SH44 - 02 - 00', 62.02],\n",
       " 'P101302': ['SH44 - 02 - 15', 62.0215],\n",
       " 'P101303': ['SH44 - 06 - 10', 62.06100000000001],\n",
       " 'P101304': ['SH46 - 10 - 00', 64.1],\n",
       " 'P101305': ['SH46 - 10 - 13', 64.1013],\n",
       " 'P101306': ['SH46 - 12 - 00', 64.12],\n",
       " 'P101307': ['SH46 - 12 - 00', 64.12],\n",
       " 'P101308': ['SH46 - 12 - 11', 64.1211],\n",
       " 'P101309': ['SH47 - 05 - 00', 65.05],\n",
       " 'P101310': ['SH47 - 09 - 02', 65.09020000000001],\n",
       " 'P101311': ['SH47 - 01 - 00', 65.01],\n",
       " 'P101312': ['SH48 - 12 - 00', 66.12],\n",
       " 'P101313': ['AS01 - 00 - 00', 67.0],\n",
       " 'P101314': ['AS01 - 06 - 13', 67.0613],\n",
       " 'P101315': ['AS01 - 10 - 29', 67.10289999999999],\n",
       " 'P101316': ['AS03 - 08 - 17', 69.0817],\n",
       " 'P101317': ['AS03 - 07 - 00', 69.07],\n",
       " 'P101318': ['AS05 - 00 - 00', 71.0],\n",
       " 'P101319': ['AS05 - 04 - 08', 71.0408],\n",
       " 'P101320': ['AS08 - 02 - 07', 74.02069999999998],\n",
       " 'P101321': ['AS08 - 10 - 00', 74.1],\n",
       " 'P101322': ['SSXX - 07 - 20', 0.07200000000000001],\n",
       " 'P101323': ['SS02 - 03 - 08', 77.0308],\n",
       " 'P101324': ['AS03 - 04 - 12', 69.0412],\n",
       " 'P101325': ['SS02 - 05 - 00', 77.05],\n",
       " 'P101326': ['SS02 - 06 - 10', 77.061],\n",
       " 'P101327': ['SS02 - 09 - 26', 77.0926],\n",
       " 'P101328': ['SS02 - 11 - 00', 77.11],\n",
       " 'P101329': ['SS03 - 01 - 25', 78.0125],\n",
       " 'P101330': ['SS03 - 06 - 26', 78.0626],\n",
       " 'P101331': ['SS03 - 08 - 29', 78.0829],\n",
       " 'P101332': ['SS03 - 09 - 00', 78.09],\n",
       " 'P101333': ['SS04 - 02 - 15', 79.02149999999997],\n",
       " 'P101334': ['SS04 - 03 - 00', 79.03],\n",
       " 'P101335': ['SH38 - 11 - 00', 56.11],\n",
       " 'P101336': ['SS06 - 05 - 26', 81.0526],\n",
       " 'P101337': ['SH38 - 08 - 00', 56.08],\n",
       " 'P101338': ['SS07 - 10 - 00', 82.1],\n",
       " 'P101339': ['SS07 - 11 - 02', 82.1102],\n",
       " 'P101340': ['SS09 - 10 - 00', 84.1],\n",
       " 'P101341': ['SS09 - 10 - 00', 84.1],\n",
       " 'P101342': ['SS09 - 12 - 25', 84.1225],\n",
       " 'P101343': ['IS01 - 03 - 11', 85.0311],\n",
       " 'P101344': ['IS01 - 07 - 00', 85.07],\n",
       " 'P101345': ['XXXX - 00 - 00', 0.0],\n",
       " 'P101346': ['SS09 - 10 - 00', 84.1],\n",
       " 'P101347': ['SH32 - 00 - 00', 50.0],\n",
       " 'P101348': ['SH33 - 09 - 00', 51.09],\n",
       " 'P101349': ['SH35 - 00 - 00', 53.0],\n",
       " 'P101350': ['SH35 - 06 - 00', 53.06],\n",
       " 'P101351': ['SH35 - 10 - 00', 53.1],\n",
       " 'P101352': ['SH36 - 01 - 00', 54.01],\n",
       " 'P101353': ['SH36 - 01 - 00', 54.01],\n",
       " 'P101354': ['SH36 - 04 - 00', 54.04],\n",
       " 'P101355': ['SH36 - 09 - 02', 54.0902],\n",
       " 'P101356': ['SH37 - 05 - 00', 55.05],\n",
       " 'P101357': ['SH37 - 06 - 00', 55.06],\n",
       " 'P101358': ['SH40 - 03 - 01', 58.0301],\n",
       " 'P101359': ['SH41 - 09 - 10', 59.091],\n",
       " 'P101360': ['SH40 - 09 - 30', 58.093],\n",
       " 'P101361': ['SH40 - 10 - 28', 58.1028],\n",
       " 'P101362': ['SH41 - 02 - 00', 59.02],\n",
       " 'P101363': ['SH41 - 02 - 04', 59.0204],\n",
       " 'P101364': ['SH41 - 07 - 02', 59.0702],\n",
       " 'P101365': ['SH43 - 02 - 17', 61.0217],\n",
       " 'P101366': ['SH43 - 10 - 05', 61.1005],\n",
       " 'P101367': ['SH45 - 07 - 15', 63.0715],\n",
       " 'P101368': ['SH45 - 09 - 13', 63.0913],\n",
       " 'P101369': ['SH45 - 09 - 30', 63.093],\n",
       " 'P101370': ['SH46 - 08 - 27', 64.0827],\n",
       " 'P101371': ['SH46 - 11 - 09', 64.1109],\n",
       " 'P101372': ['SH46 - 11 - 15', 64.11149999999999],\n",
       " 'P101373': ['SH46 - 12 - 00', 64.12],\n",
       " 'P101374': ['SH46 - 12 - 09', 64.1209],\n",
       " 'P101375': ['SH46 - 12 - 14', 64.12140000000001],\n",
       " 'P101376': ['SH47 - 03 - 15', 65.0315],\n",
       " 'P101377': ['SH47 - 02 - 14', 65.0214],\n",
       " 'P101378': ['SH47 - 06 - 21', 65.0621],\n",
       " 'P101379': ['SH47 - 06 - 22', 65.0622],\n",
       " 'P101380': ['SH47 - 09 - 00', 65.09],\n",
       " 'P101381': ['SH47 - 11 - 07', 65.1107],\n",
       " 'P101382': ['SH47 - 11 - 07', 65.1107],\n",
       " 'P101383': ['SH43 - 01 - 22', 61.0122],\n",
       " 'P101384': ['SH37 - 08 - 00', 55.08],\n",
       " 'P101385': ['XXXX - 07 - 15', 0.07150000000000001],\n",
       " 'P101386': ['SH41 - 07 - 00', 59.07],\n",
       " 'P101387': ['SH34 - 06 - 00', 52.06],\n",
       " 'P101388': ['AS06 - 12 - 00', 72.12],\n",
       " 'P101389': ['SH48 - 06 - 11', 66.0611],\n",
       " 'P101390': ['SH48 - 09 - 29', 66.0929],\n",
       " 'P101391': ['AS02 - 04 - 01', 68.04010000000001],\n",
       " 'P101392': ['AS02 - 05 - 23', 68.0523],\n",
       " 'P101393': ['AS02 - 08 - 00', 68.08],\n",
       " 'P101394': ['AS04 - 05 - 06', 70.0506],\n",
       " 'P101395': ['SS07 - 00 - 00', 82.0],\n",
       " 'P101396': ['SS01 - 12 - 00', 76.12],\n",
       " 'P101397': ['SS02 - 05 - 08', 77.0508],\n",
       " 'P101398': ['SS02 - 07 - 00', 77.07],\n",
       " 'P101399': ['SS08 - 10 - 25', 83.10249999999998],\n",
       " 'P101400': ['SS09 - 03 - 00', 84.03],\n",
       " 'P101401': ['SS09 - 10 - 01', 84.1001],\n",
       " 'P101402': ['SS09 - 10 - 04', 84.1004],\n",
       " 'P101403': ['SS09 - 10 - 30', 84.103],\n",
       " 'P101404': ['SS09 - 11 - 14', 84.1114],\n",
       " 'P101405': ['XXXX - 00 - 18', 0.0018],\n",
       " 'P101406': ['XXXX - 00 - 00', 0.0],\n",
       " 'P101407': ['SS09 - 00 - 00', 84.0],\n",
       " 'P101408': ['AS04 - 11 - 09', 70.1109],\n",
       " 'P101409': ['SH35 - 08 - 00', 53.08],\n",
       " 'P101410': ['SH36 - 00 - 00', 54.0],\n",
       " 'P101411': ['SH36 - 06 - 00', 54.06],\n",
       " 'P101412': ['SH44 - 06 - 20', 62.06200000000001],\n",
       " 'P101413': ['SH44 - 10 - 07', 62.1007],\n",
       " 'P101414': ['SH47 - 00 - 00', 65.0],\n",
       " 'P101415': ['SH47 - 01 - 20', 65.012],\n",
       " 'P101416': ['SH47 - 01 - 01', 65.01010000000001],\n",
       " 'P101417': ['SH47 - 04 - 10', 65.04100000000001],\n",
       " 'P101418': ['SH47 - 07 - 11', 65.07109999999999],\n",
       " 'P101419': ['SH48 - 02 - 00', 66.02],\n",
       " 'P101421': ['AS02 - 03 - 06', 68.0306],\n",
       " 'P101422': ['AS06 - 12 - 00', 72.12],\n",
       " 'P101423': ['AS04 - 08 - 00', 70.08],\n",
       " 'P101424': ['AS05 - 00 - 00', 71.0],\n",
       " 'P101425': ['AS06 - 00 - 00', 72.0],\n",
       " 'P101426': ['AS06 - 11 - 10', 72.111],\n",
       " 'P101427': ['AS07 - 00 - 00', 73.0],\n",
       " 'P101428': ['AS07 - 01 - 22', 73.0122],\n",
       " 'P101429': ['AS07 - 05 - 10', 73.051],\n",
       " 'P101430': ['AS08 - 07 - 00', 74.07],\n",
       " 'P101431': ['AS08 - 07 - 26', 74.0726],\n",
       " 'P101432': ['AS08 - 11 - 12', 74.1112],\n",
       " 'P101433': ['SS02 - 09 - 15', 77.0915],\n",
       " 'P101434': ['AS02 - 11 - 00', 68.11],\n",
       " 'P101435': ['SS08 - 05 - 00', 83.05],\n",
       " 'P101436': ['IS01 - 11 - 00', 85.11],\n",
       " 'P101437': ['XXXX - 11 - 13', 0.1113],\n",
       " 'P101438': ['XXXX - 00 - 04', 0.0004],\n",
       " 'P101439': ['SH43 - 12 - 00', 61.12],\n",
       " 'P101440': ['SH47 - 11 - 00', 65.11],\n",
       " 'P101442': ['SH34 - 05 - 00', 52.05],\n",
       " 'P101443': ['SH44 - 08 - 17', 62.0817],\n",
       " 'P101444': ['SH44 - 08 - 28', 62.0828],\n",
       " 'P101445': ['SH47 - 06 - 20', 65.062],\n",
       " 'P101446': ['SH46 - 11 - 21', 64.1121],\n",
       " 'P101447': ['SH47 - 07 - 00', 65.07],\n",
       " 'P101448': ['SH38 - 10 - 00', 56.1],\n",
       " 'P101449': ['AS09 - 00 - 00', 75.0],\n",
       " 'P101450': ['AS02 - 10 - 00', 68.1],\n",
       " 'P101452': ['XXXX - 07 - 00', 0.07],\n",
       " 'P101453': ['SH44 - 10 - 00', 62.1],\n",
       " 'P101454': ['SS09 - 12 - 00', 84.12],\n",
       " 'P101455': ['SSXX - 10 - 00', 0.1],\n",
       " 'P101456': ['XXXX - 00 - 00', 0.0],\n",
       " 'P101457': ['AS06 - 10 - 18', 72.1018],\n",
       " 'P101458': ['XXXX - 00 - 00', 0.0],\n",
       " 'P101460': ['XXXX - 00 - 00', 0.0],\n",
       " 'P101461': ['SS02 - 04 - 00', 77.04],\n",
       " 'P101462': ['SH41 - 06 - 00', 59.06],\n",
       " 'P101641': ['AS04 - 04 - 00', 70.04],\n",
       " 'P101671': ['IS02 - 12 - 00', 86.12],\n",
       " 'P101694': ['SH33? - 00 - 00', 0.0],\n",
       " 'P200373': ['SS01 - 06 - 00', 76.06],\n",
       " 'P499890': ['SS03 - XX - XX', 78.0],\n",
       " 'P101721': ['SH33 - 11 - 00', 51.11],\n",
       " 'P101722': ['AS03 - 02 - 00', 69.02],\n",
       " 'P101723': ['AS08 - 04 - 09', 74.04090000000002],\n",
       " 'P101727': ['SH47] - 05] - 27', 0.0527],\n",
       " 'P332324': ['SS02 - 12 - 06', 77.12060000000002],\n",
       " 'P332325': ['SS05 - 08 - 15', 80.08149999999998],\n",
       " 'P429724': ['SS01 - 08 - 00', 76.08],\n",
       " 'P429725': ['AS08 - 01 - 18', 74.01180000000002],\n",
       " 'P429726': ['SH39 - 04 - 00', 57.04],\n",
       " 'P100838': ['SS02 - 12 - 00', 77.12],\n",
       " 'P122895': ['AS09 - 03 - 15', 75.0315],\n",
       " 'P122911': ['IS02 - 01 - 00', 86.01],\n",
       " 'P101757': ['AS04 - 09 - 00', 70.09],\n",
       " 'P101758': ['XXXX - 00 - 05', 0.0005],\n",
       " 'P101759': ['SS03 - 02 - 00', 78.02],\n",
       " 'P101760': ['XXXX - 00 - 00', 0.0],\n",
       " 'P101761': ['SS06 - 04 - 24', 81.0424],\n",
       " 'P101766': ['SH44 - 11 - 12', 62.1112],\n",
       " 'P101770': ['SH48 - 08 - 21', 66.0821],\n",
       " 'P101772': ['SH47 - 08 - 09', 65.0809],\n",
       " 'P101774': ['AS01 - 01 - 08', 67.0108],\n",
       " 'P101775': ['AS03 - 11 - 00', 69.11],\n",
       " 'P101777': ['AS04 - 10 - 08', 70.10079999999999],\n",
       " 'P101778': ['AS04 - 03 - 27', 70.0327],\n",
       " 'P101784': ['AS09 - 08 - 16', 75.0816],\n",
       " 'P101786': ['SS02 - 00 - 00', 77.0],\n",
       " 'P101787': ['SS03 - 02 - 29', 78.02289999999998],\n",
       " 'P101791': ['SS07 - 12 - 00', 82.12],\n",
       " 'P101794': ['IS01 - 12 - 00', 85.12],\n",
       " 'P101800': ['SS04 - 01 - 00', 79.01],\n",
       " 'P101801': ['IS01 - 03 - 00', 85.03],\n",
       " 'P101802': ['AS09 - 09 - 00', 75.09],\n",
       " 'P101803': ['AS04 - 01 - 00', 70.01],\n",
       " 'P101805': ['AS09 - 04 - 00', 75.04],\n",
       " 'P101810': ['AS04 - 12 - 15', 70.1215],\n",
       " 'P101831': ['AS07 - 12 - 29', 73.1229],\n",
       " 'P101843': ['SH47 - 12 - 00', 65.12],\n",
       " 'P101844': ['SH48 - 08 - 13', 66.0813],\n",
       " 'P101845': ['AS07 - 01 - 13', 73.0113],\n",
       " 'P101857': ['SS02 - 01 - 00', 77.01],\n",
       " 'P101858': ['SH41 - 03 - 00', 59.03],\n",
       " 'P101860': ['SH45 - 07 - 00', 63.07],\n",
       " 'P101863': ['AS05 - 09 - 23', 71.09230000000002],\n",
       " 'P101861': ['AS04 - 09 - 24', 70.0924],\n",
       " 'P101864': ['AS06 - 09 - 23', 72.09230000000002],\n",
       " 'P101865': ['AS09 - 05 - 21', 75.0521],\n",
       " 'P101866': ['AS07 - 05 - 23', 73.0523],\n",
       " 'P101867': ['IS01 - 07 - 15', 85.07149999999999],\n",
       " 'P101868': ['AS05 - 06 - 29', 71.0629],\n",
       " 'P101869': ['SH46 - 06 - 02', 64.06020000000001],\n",
       " 'P101870': ['AS07 - 01 - 09', 73.0109],\n",
       " 'P101871': ['SH44 - 03 - 09', 62.0309],\n",
       " 'P101872': ['AS07 - 10 - 17', 73.1017],\n",
       " 'P101873': ['AS07 - 02 - 24', 73.02239999999998],\n",
       " 'P101874': ['AS01 - 06 - 03', 67.0603],\n",
       " 'P101876': ['SH48 - 10 - 00', 66.1],\n",
       " 'P101877': ['SS09 - 09 - 10', 84.09100000000002],\n",
       " 'P101878': ['SH42 - 06 - 24', 60.0624],\n",
       " 'P101879': ['AS05 - 04 - 05', 71.04050000000002],\n",
       " 'P101880': ['AS07 - 03 - 29', 73.0329],\n",
       " 'P145452': ['SH41 - 00 - 00', 59.0],\n",
       " 'P145453': ['SS08 - 00 - 00', 83.0],\n",
       " 'P145454': ['AS04 - 00 - 00', 70.0],\n",
       " 'P332327': ['AS02 - 01 - 00', 68.01],\n",
       " 'P118615': ['AS05 - 09 - 24', 71.0924],\n",
       " 'P102014': ['SS09 - 11 - 15', 84.11149999999998],\n",
       " 'P102015': ['AS04 - 08 - 16', 70.0816],\n",
       " 'P102016': ['AS04 - 09 - 20', 70.092],\n",
       " 'P102017': ['XXXX - 07 - 00', 0.07],\n",
       " 'P102020': ['SS02 - 06 - 09', 77.0609],\n",
       " 'P102021': ['SS07 - 09 - 09', 82.0909],\n",
       " 'P102022': ['SS09 - 12 - 17', 84.1217],\n",
       " 'P102126': ['SH43 - 02 - 00', 61.02],\n",
       " 'P102127': ['SH48 - 11 - 14', 66.1114],\n",
       " 'P102132': ['SS05 - 12 - 00', 80.12],\n",
       " 'P102133': ['SH29 - 10 - 00', 47.1],\n",
       " 'P102134': ['SH40 - 10 - 00', 58.1],\n",
       " 'P102135': ['AS06 - 03 - 23', 72.0323],\n",
       " 'P102137': ['SH44 - 12 - 00', 62.12],\n",
       " 'P102139': ['AS01 - 08 - 00', 67.08],\n",
       " 'P102140': ['AS01 - 00 - 00', 67.0],\n",
       " 'P102141': ['AS03 - 12 - 18', 69.12180000000001],\n",
       " 'P102142': ['AS08? - 01 - 19', 0.0119],\n",
       " 'P102143': ['AS05 - 07 - 04', 71.07039999999998],\n",
       " 'P102145': ['AS07 - 08 - 14', 73.0814],\n",
       " 'P102146': ['SS07 - 08 - 15', 82.08149999999998],\n",
       " 'P102163': ['SH43 - 09 - 00', 61.09],\n",
       " 'P102164': ['XXXX - 00 - 13', 0.0013],\n",
       " 'P102165': ['SS08 - 05 - 19', 83.0519],\n",
       " 'P102166': ['SH45 - 07 - 00', 63.07],\n",
       " 'P102168': ['SS08 - 02 - 00', 83.02],\n",
       " 'P102169': ['IS03? - XX - XX', 0.0],\n",
       " 'P134804': ['0000 - 00 - 00', 0.0],\n",
       " 'P134808': ['AS08 - 08 - 28', 74.08279999999998],\n",
       " 'P134811': ['AS05 - 05 - 04', 71.0504],\n",
       " 'P134816': ['AS06 - 02 - 21', 72.0221],\n",
       " 'P134819': ['AS01 - 09 - 08', 67.0908],\n",
       " 'P134820': ['AS02 - 08 - 14', 68.0814],\n",
       " 'P134824': ['AS03 - 11 - 20', 69.112],\n",
       " 'P134825': ['AS04 - 04 - 25', 70.0425],\n",
       " 'P134826': ['AS05 - 05 - 07', 71.05069999999998],\n",
       " 'P134827': ['AS06 - 05 - 29', 72.0529],\n",
       " 'P134828': ['AS06 - 08 - 13', 72.0813],\n",
       " 'P134829': ['AS06 - 11 - 12', 72.1112],\n",
       " 'P134836': ['AS06 - 07 - 03', 72.07029999999997],\n",
       " 'P134837': ['AS06 - 04 - 16', 72.0416],\n",
       " 'P134838': ['AS06 - 09 - 21', 72.0921],\n",
       " 'P134839': ['AS06 - 11 - 12', 72.1112],\n",
       " 'P134846': ['AS08 - 12 - 07', 74.1207],\n",
       " 'P134847': ['AS08 - 05 - 12', 74.0512],\n",
       " 'P134850': ['AS07 - 04 - 03', 73.0403],\n",
       " 'P134856': ['AS02 - 08 - 16', 68.0816],\n",
       " 'P134858': ['AS01 - 12 - 08?', 67.1208],\n",
       " 'P134860': ['AS02 - 02 - 11', 68.02109999999999],\n",
       " 'P134861': ['AS02 - 03 - 16', 68.0316],\n",
       " 'P134863': ['AS02 - 04 - 17', 68.0417],\n",
       " 'P134865': ['AS03 - 12 - 05', 69.1205],\n",
       " 'P134866': ['AS04 - 03 - 30', 70.033],\n",
       " 'P134868': ['AS09 - 09 - 00', 75.09],\n",
       " 'P134870': ['SH46 - 02 - 00', 64.02],\n",
       " 'P134894': ['SS01 - 11 - 00', 76.11],\n",
       " 'P134897': ['SS02 - 03 - 19', 77.03190000000002],\n",
       " 'P134898': ['SS02 - 04 - 08', 77.0408],\n",
       " 'P134899': ['SS02 - 05 - 00', 77.05],\n",
       " 'P134900': ['SS02 - 06 - 00', 77.06],\n",
       " 'P134901': ['SS02 - 07 - 00', 77.07],\n",
       " 'P134902': ['SS02 - 09 - 19', 77.09190000000002],\n",
       " 'P134903': ['SS03 - 03 - 06', 78.0306],\n",
       " 'P134904': ['SS03 - 04 - 17', 78.0417],\n",
       " 'P134905': ['SS03 - 08 - XX', 78.08],\n",
       " 'P134909': ['SS01 - 10 - 00', 76.1],\n",
       " 'P134910': ['SS02 - 08 - 28', 77.08279999999998],\n",
       " 'P134912': ['AS03 - 12 - 16', 69.1216],\n",
       " 'P134914': ['ASXX - 01 - 07', 0.0107],\n",
       " 'P134916': ['AS06 - 07 - 30', 72.07300000000001],\n",
       " 'P134918': ['AS07 - 03 - 20', 73.032],\n",
       " 'P134922': ['SS01 - 10 - 00', 76.1],\n",
       " 'P134925': ['AS03 - 10 - 26', 69.1026],\n",
       " 'P134926': ['AS03 - 10 - 14', 69.1014],\n",
       " 'P134930': ['AS05 - 02 - 29', 71.02289999999998],\n",
       " 'P134931': ['AS06 - 04 - 24', 72.0424],\n",
       " 'P134932': ['AS06 - 04 - 21', 72.0421],\n",
       " 'P134933': ['AS06 - 04 - 08', 72.0408],\n",
       " 'P134934': ['AS06 - 09 - 21', 72.0921],\n",
       " 'P134935': ['AS07 - 01 - 13', 73.0113],\n",
       " 'P134936': ['AS07 - 02 - 01', 73.0201],\n",
       " 'P134948': ['SS07 - 00 - 00', 82.0],\n",
       " 'P134950': ['SS09 - 01 - 00', 84.01],\n",
       " 'P134953': ['SS09 - 07 - 00', 84.07],\n",
       " 'P134956': ['SS09 - 11 - 27', 84.1127],\n",
       " 'P134959': ['IS01 - 07 - 00', 85.07],\n",
       " 'P134966': ['SH44 - 01 - 00', 62.01],\n",
       " 'P134967': ['SH44 - 03 - 00', 62.03],\n",
       " 'P134971': ['SH46 - 08 - 25', 64.0825],\n",
       " 'P134972': ['SH46 - 09 - 21', 64.0921],\n",
       " 'P134977': ['SH47 - 11 - 07', 65.1107],\n",
       " 'P134979': ['AS01 - 04 - 09', 67.04090000000001],\n",
       " 'P134980': ['AS01 - 05 - 11', 67.05109999999999],\n",
       " 'P134981': ['AS01 - 08 - 16', 67.0816],\n",
       " 'P134982': ['AS01 - 09 - 05?', 67.0905],\n",
       " 'P134983': ['AS01 - 10 - 10', 67.101],\n",
       " 'P134984': ['AS02 - 12 - 04', 68.1204],\n",
       " 'P134988': ['AS03 - 09 - 25', 69.0925],\n",
       " 'P134989': ['AS04 - 07 - 17', 70.07169999999999],\n",
       " 'P134996': ['AS07 - 04 - 22', 73.04220000000002],\n",
       " 'P134997': ['AS07 - 07 - 02', 73.0702],\n",
       " 'P134998': ['AS07 - 11 - 01', 73.1101],\n",
       " 'P135000': ['AS08 - 01 - 25', 74.0125],\n",
       " 'P135003': ['AS08 - 04 - 21', 74.0421],\n",
       " 'P135007': ['AS04 - 11 - 20', 70.112],\n",
       " 'P135008': ['SS01 - 06 - 10+', 76.061],\n",
       " 'P135009': ['SS02 - 07 - 12', 77.07119999999998],\n",
       " 'P135010': ['SS02 - 09 - 24', 77.0924],\n",
       " 'P135011': ['SS04 - 00 - 00', 79.0],\n",
       " 'P135012': ['SS05 - 03 - 02', 80.03020000000002],\n",
       " 'P135013': ['SS04 - 01 - 17', 79.0117],\n",
       " 'P135014': ['SS04 - 04 - 10', 79.04100000000003],\n",
       " 'P135015': ['SS04 - 09 - 18', 79.0918],\n",
       " 'P135018': ['SS07 - 02 - 15', 82.02149999999997],\n",
       " 'P135055': ['SS09 - 10 - 07', 84.10069999999997],\n",
       " 'P135116': ['SS01 - 08 - 00', 76.08],\n",
       " 'P135117': ['SS02 - 03 - 00', 77.03],\n",
       " 'P135129': ['SS09 - 12 - 00', 84.12],\n",
       " 'P135155': ['0000 - 03 - 06', 0.0306],\n",
       " 'P135156': ['AS06 - 10 - 00', 72.1],\n",
       " 'P135157': ['SH46 - 06 - 26', 64.0626],\n",
       " 'P135158': ['AS09 - 04 - 20+', 75.042],\n",
       " 'P135159': ['AS07 - 09 - 03', 73.0903],\n",
       " 'P135160': ['AS07 - 03 - 29', 73.0329],\n",
       " 'P135161': ['AS06 - 00 - 16', 72.0016],\n",
       " 'P135162': ['0000 - 00 - 00', 0.0],\n",
       " 'P135163': ['0000 - 00 - 00', 0.0],\n",
       " 'P135164': ['XXXX - 00 - 00', 0.0],\n",
       " 'P135165': ['ASXX - 00 - 29', 0.0029],\n",
       " 'P135166': ['AS04 - 08 - 00', 70.08],\n",
       " 'P135167': ['XXXX - 00 - 11', 0.0011],\n",
       " 'P135168': ['SH47 - 00 - 26', 65.0026],\n",
       " 'P135169': ['SS09 - 01 - 00', 84.01],\n",
       " 'P135170': ['XXXX - 00 - 00', 0.0],\n",
       " 'P135171': ['ASXX - 04 - 18', 0.0418],\n",
       " 'P135172': ['XXXX - 00 - 00', 0.0],\n",
       " 'P218271': ['SH47 - 08 - 00', 65.08],\n",
       " 'P102261': ['AS05 - 02 - 01', 71.0201],\n",
       " 'P102308': ['XXXX - 10 - 04', 0.1004],\n",
       " 'P102309': ['SH46 - 11 - 00', 64.11],\n",
       " 'P102310': ['AS02 - 02 - 28', 68.02279999999999],\n",
       " 'P102311': ['AS03 - 01 - 07', 69.0107],\n",
       " 'P102312': ['AS03 - 01 - 13?', 69.0113],\n",
       " 'P102313': ['AS03 - 02 - 00', 69.02],\n",
       " 'P102314': ['AS03 - 11 - 00', 69.11],\n",
       " 'P102315': ['AS03 - 11 - 21', 69.1121],\n",
       " 'P102316': ['AS03 - 11 - 28', 69.1128],\n",
       " 'P102317': ['AS04? - 02 - 28', 0.0228],\n",
       " 'P102318': ['AS04 - 05 - 07', 70.05069999999999],\n",
       " 'P102319': ['AS04 - 08 - 06', 70.0806],\n",
       " 'P102320': ['AS04 - 10 - 10', 70.101],\n",
       " 'P102321': ['AS04? - 10 - 10', 0.10099999999999999],\n",
       " 'P102322': ['AS06 - 02 - 01', 72.0201],\n",
       " 'P102323': ['AS06 - 02 - 03', 72.02029999999998],\n",
       " 'P102324': ['AS06 - 02 - 16', 72.02159999999998],\n",
       " 'P102325': ['AS06 - 05 - 17', 72.0517],\n",
       " 'P102326': ['AS06 - 06 - 24', 72.0624],\n",
       " 'P102327': ['AS06 - 08 - 08', 72.0808],\n",
       " 'P102328': ['AS06 - 08 - 22', 72.0822],\n",
       " 'P102329': ['AS06 - 11 - 08', 72.1108],\n",
       " 'P102330': ['AS06 - 11 - 14', 72.1114],\n",
       " 'P102331': ['AS07 - 01 - 23', 73.01230000000002],\n",
       " 'P102332': ['AS07 - 08 - 08', 73.0808],\n",
       " 'P102333': ['AS07 - 11 - 02', 73.1102],\n",
       " 'P102334': ['AS07 - 12 - 07', 73.1207],\n",
       " 'P102335': ['AS09 - 02 - 21', 75.0221],\n",
       " 'P102336': ['AS09 - 03 - 20', 75.032],\n",
       " 'P102337': ['AS09 - 03 - 29', 75.0329],\n",
       " 'P102338': ['AS09 - 04 - 22', 75.04220000000002],\n",
       " 'P102339': ['SS01 - 09 - 00', 76.09],\n",
       " 'P102340': ['SS06 - 06 - 29', 81.0629],\n",
       " 'P102341': ['SS09 - 12 - 00', 84.12],\n",
       " 'P102342': ['ASXX - 00 - 13', 0.0013],\n",
       " 'P102343': ['SH44 - 06 - 07', 62.0607],\n",
       " 'P102344': ['AS02 - 02 - 29', 68.02289999999999],\n",
       " 'P102345': ['AS01 - 10 - 19', 67.1019],\n",
       " 'P102346': ['AS02 - 01 - 04', 68.0104],\n",
       " 'P102347': ['AS02 - 04 - 27', 68.04270000000001],\n",
       " 'P102348': ['AS02 - 12 - 05', 68.1205],\n",
       " 'P102349': ['AS04 - 11 - 23', 70.1123],\n",
       " 'P102350': ['AS09 - 10 - 00', 75.1],\n",
       " 'P102351': ['ASXX - 10 - 21', 0.1021],\n",
       " 'P102352': ['SS01 - 02 - 28', 76.02279999999998],\n",
       " 'P102353': ['SS01 - 08 - 09', 76.0809],\n",
       " 'P102354': ['SS07 - 08 - 26', 82.0826],\n",
       " 'P102355': ['SS08 - 04 - 17', 83.0417],\n",
       " 'P102356': ['AS07 - 05 - 04', 73.0504],\n",
       " 'P102357': ['AS07 - 08 - 19', 73.0819],\n",
       " 'P102358': ['XXXX - 02 - 12', 0.0212],\n",
       " 'P102360': ['AS02 - 03 - 00', 68.03],\n",
       " 'P102361': ['SS08 - 07 - 18', 83.0718],\n",
       " 'P102362': ['SH33 - 05 - 00', 51.05],\n",
       " 'P102363': ['AS03 - 12 - 15', 69.1215],\n",
       " 'P102365': ['XXXX - 00 - 00', 0.0],\n",
       " 'P102370': ['SH36 - 03 - 00', 54.03],\n",
       " 'P102371': ['SH42 - 00 - 00', 60.0],\n",
       " 'P102374': ['AS04 - 07 - 17', 70.07169999999999],\n",
       " 'P102375': ['SS04 - 10 - 29', 79.10289999999998],\n",
       " 'P102377': ['SH47 - 04 - 25', 65.0425],\n",
       " 'P102378': ['AS08 - 12 - 16', 74.1216],\n",
       " 'P102379': ['SH47 - 00 - 23', 65.0023],\n",
       " 'P102408': ['IS01 - 04 - 00', 85.04],\n",
       " 'P142399': ['SH41 - 08 - 23', 59.0823],\n",
       " 'P142429': ['SH44 - 12 - 30', 62.123000000000005],\n",
       " 'P102439': ['AS01 - 10 - 13', 67.1013],\n",
       " 'P102440': ['AS02 - 09 - 01', 68.0901],\n",
       " 'P102441': ['AS09 - 02 - 19', 75.0219],\n",
       " 'P102442': ['ASXX - 00 - 00', 0.0],\n",
       " 'P102443': ['SH44 - 04m - 03', 62.0403],\n",
       " 'P102446': ['AS01 - 05 - 04', 67.0504],\n",
       " 'P102447': ['AS01 - 07 - 05', 67.0705],\n",
       " 'P102448': ['AS03 - 09 - 11', 69.0911],\n",
       " 'P102449': ['AS08 - 05 - 09', 74.0509],\n",
       " 'P102450': ['AS08 - 06 - 15', 74.0615],\n",
       " 'P102451': ['AS08 - 08 - 19', 74.0819],\n",
       " 'P102452': ['AS09 - 09 - 21', 75.0921],\n",
       " 'P102453': ['SS04 - 09 - 01', 79.0901],\n",
       " 'P102454': ['XXXX - 04 - 27', 0.0427],\n",
       " 'P102455': ['SS08 - 08 - 00', 83.08],\n",
       " 'P102456': ['XXXX - 00 - 00', 0.0],\n",
       " 'P102457': ['SH40 - 12 - 00', 58.12],\n",
       " 'P102459': ['SH46 - 10 - 21', 64.1021],\n",
       " 'P102460': ['AS08 - 12 - 17', 74.1217],\n",
       " 'P102461': ['SS07 - 07 - 27', 82.0727],\n",
       " 'P102462': ['XXXX - 00 - 22', 0.0022],\n",
       " 'P102502': ['AS05 - 04 - 00', 71.04],\n",
       " 'P102503': ['AS03 - 06 - 00', 69.06],\n",
       " 'P102504': ['SH42 - 07 - 00', 60.07],\n",
       " 'P102505': ['SH47 - 12 - 00', 65.12],\n",
       " 'P102506': ['SS02 - 09 - 00', 77.09],\n",
       " 'P102507': ['AS08 - 07 - 00', 74.07],\n",
       " 'P102508': ['SH48 - 07 - 00', 66.07],\n",
       " 'P102509': ['SS01 - 09 - 00', 76.09],\n",
       " 'P102526': ['SH46 - 09 - 00', 64.09],\n",
       " 'P102552': ['XXXX - 00 - 16', 0.0016],\n",
       " 'P102553': ['AS04 - 07 - 13', 70.0713],\n",
       " 'P102554': ['AS08 - 04 - 06', 74.04060000000003],\n",
       " 'P102557': ['AS08 - 08 - 00', 74.08],\n",
       " 'P102566': ['SH45 - 07 - 09', 63.0709],\n",
       " 'P330237': ['SH43 - 03 - 02', 61.0302],\n",
       " 'P330238': ['SH43 - 10 - 21', 61.1021],\n",
       " 'P123351': ['SH45 - 10 - 28', 63.1028],\n",
       " 'P330240': ['SH47 - 12 - 18', 65.12180000000001],\n",
       " 'P330241': ['SH48 - 08 - 05', 66.0805],\n",
       " 'P330242': ['SH48 - 12 - 05', 66.1205],\n",
       " 'P102573': ['AS01 - 01 - 17', 67.0117],\n",
       " 'P102574': ['AS02 - 08 - 24', 68.08239999999999],\n",
       " 'P102580': ['SH44 - 03m - 25', 62.0325],\n",
       " 'P102581': ['AS04 - 02 - 00', 70.02],\n",
       " 'P102582': ['AS06 - 12 - 00', 72.12],\n",
       " 'P102583': ['AS09 - 12d - 00', 75.12],\n",
       " 'P102584': ['SS03 - 11 - 00', 78.11],\n",
       " 'P102585': ['SS04 - 03 - 12', 79.0312],\n",
       " 'P102586': ['SS09 - 09 - 03', 84.0903],\n",
       " 'P102625': ['SH46 - 09 - 00', 64.09],\n",
       " 'P102626': ['SH47 - 08 - 22', 65.0822],\n",
       " 'P102627': ['AS03 - 09 - 00', 69.09],\n",
       " 'P102628': ['AS09 - 06 - 02', 75.06020000000002],\n",
       " 'P102630': ['SH30 - 07 - 00', 48.07],\n",
       " 'P102631': ['SH46 - 05 - 19', 64.0519],\n",
       " 'P102632': ['SH47 - 06 - 23', 65.06230000000001],\n",
       " 'P102633': ['AS02 - 09 - 00', 68.09],\n",
       " 'P102634': ['AS03 - 07 - 00', 69.07],\n",
       " 'P102635': ['AS05 - 06 - 13', 71.0613],\n",
       " 'P218070': ['AS09 - 02 - 26', 75.0226],\n",
       " 'P102637': ['AS09 - 03 - 30', 75.033],\n",
       " 'P102638': ['SS06 - 00 - 00', 81.0],\n",
       " 'P102692': ['SH35 - 06 - 00', 53.06],\n",
       " 'P102693': ['SH38 - 00 - 00 & SH40 - 07 - 00', 56.0],\n",
       " 'P102694': ['SH41 - 07 - 00', 59.07],\n",
       " 'P102695': ['SH42 - 01 - 00', 60.01],\n",
       " 'P102696': ['SH42 - 02 - 05', 60.02050000000001],\n",
       " 'P102697': ['SH42 - 09 - 15', 60.0915],\n",
       " 'P102698': ['SH46 - 06 - 13', 64.0613],\n",
       " 'P102699': ['SH47 - 04 - 22', 65.04220000000001],\n",
       " 'P102700': ['SH47 - 09 - 00', 65.09],\n",
       " 'P102701': ['SH48 - 09 - 00', 66.09],\n",
       " 'P102702': ['SH48 - 12 - 10', 66.12100000000001],\n",
       " 'P102703': ['AS01 - 06 - 12', 67.0612],\n",
       " 'P102704': ['AS01 - 06 - 21', 67.0621],\n",
       " 'P102705': ['AS02 - 09 - 00', 68.09],\n",
       " 'P102706': ['AS03 - 06 - 06', 69.06060000000001],\n",
       " 'P102707': ['AS03 - 06 - 20', 69.062],\n",
       " 'P102708': ['AS04 - 01 - 27', 70.01270000000001],\n",
       " 'P102709': ['AS04 - 07 - 00', 70.07],\n",
       " 'P102710': ['AS06 - 04 - 16', 72.0416],\n",
       " 'P102711': ['AS07 - 09 - 18', 73.0918],\n",
       " 'P102712': ['AS08 - 03 - 14', 74.0314],\n",
       " 'P102713': ['AS09 - 07 - 00', 75.07],\n",
       " 'P102714': ['AS09 - 11 - 01', 75.1101],\n",
       " 'P102715': ['SS01 - 12 - 00', 76.12],\n",
       " 'P102716': ['SS02 - 02 - 29', 77.02289999999998],\n",
       " 'P102717': ['SS03 - 03 - 20', 78.032],\n",
       " 'P102718': ['SS04 - 09 - 10', 79.09100000000002],\n",
       " 'P102719': ['SS04 - 11 - 26', 79.1126],\n",
       " 'P102720': ['SS05 - 06 - 15', 80.0615],\n",
       " 'P102721': ['SS07 - 02 - 30', 82.023],\n",
       " 'P102722': ['SS09 - 09 - 00', 84.09],\n",
       " 'P102723': ['IS02 - 05 - 08', 86.0508],\n",
       " 'P102815': ['SH36 - 02 - 00', 54.02],\n",
       " 'P102816': ['SH45 - 10 - 13', 63.1013],\n",
       " 'P102817': ['SH46 - 02 - 23', 64.0223],\n",
       " 'P102818': ['SH47 - 04 - 15', 65.0415],\n",
       " 'P102819': ['AS01 - 08 - 20', 67.082],\n",
       " 'P102820': ['AS02 - 03 - 27', 68.0327],\n",
       " 'P102821': ['AS02 - 10 - 04', 68.1004],\n",
       " 'P102822': ['AS02 - 12 - 13', 68.1213],\n",
       " 'P102823': ['AS06 - 11 - 23', 72.1123],\n",
       " 'P102824': ['SS03 - 11 - 15', 78.11149999999998],\n",
       " 'P102825': ['SS05 - 05 - 24', 80.05239999999998],\n",
       " 'P102826': ['AS02 - 09? - 00', 68.09],\n",
       " 'P102827': ['SH39 - 00 - 00', 57.0],\n",
       " 'P102847': ['SH45 - 00 - 30 // SH46 - 00 - 30', 63.003],\n",
       " 'P102848': ['IS01 - 12 - 25', 85.1225],\n",
       " 'P102849': ['XXXX - 00 - 26', 0.0026],\n",
       " 'P102850': ['SH39 - 10 - 02', 57.1002],\n",
       " 'P102851': ['AS07 - 08 - 28', 73.08279999999998],\n",
       " 'P102852': ['AS08 - 02 - 05', 74.0205],\n",
       " 'P102853': ['SH45 - 04 - 17', 63.0417],\n",
       " 'P102854': ['AS07 - 09 - 23', 73.09230000000002],\n",
       " 'P102855': ['AS03 - 11 - 00', 69.11],\n",
       " 'P102856': ['AS08 - 08 - 24', 74.08239999999998],\n",
       " 'P102857': ['AS06 - 12 - 18', 72.12180000000002],\n",
       " 'P102858': ['AS03 - 10 - 03', 69.10029999999999],\n",
       " 'P102859': ['AS04 - 02 - 10', 70.021],\n",
       " 'P102860': ['AS01 - 10 - 01', 67.1001],\n",
       " 'P102861': ['AS02 - 09 - 02', 68.09020000000001],\n",
       " 'P102862': ['AS05 - 09 - 22', 71.0922],\n",
       " 'P102863': ['AS04 - 04 - 14', 70.04140000000001],\n",
       " 'P102864': ['AS03 - 01 - 25', 69.0125],\n",
       " 'P102865': ['AS06 - 08 - 03', 72.0803],\n",
       " 'P102866': ['AS08 - 11 - 11', 74.1111],\n",
       " 'P102867': ['AS04 - 02 - 29', 70.02289999999999],\n",
       " 'P102868': ['AS08 - 03 - 06', 74.0306],\n",
       " 'P102869': ['AS03 - 09 - 08', 69.0908],\n",
       " 'P102870': ['AS04 - 12 - 23', 70.12230000000001],\n",
       " 'P102871': ['AS01 - 10 - 30', 67.10300000000001],\n",
       " 'P102873': ['AS08 - 02 - 09', 74.0209],\n",
       " 'P102874': ['AS03 - 07 - 28', 69.07279999999999],\n",
       " 'P102875': ['AS07 - 09 - 21', 73.0921],\n",
       " 'P102876': ['AS04 - 11 - 27', 70.1127],\n",
       " 'P102877': ['AS07 - 09 - 20', 73.092],\n",
       " 'P102878': ['SS04 - 09 - 25', 79.0925],\n",
       " 'P102879': ['AS04 - 12 - 03', 70.1203],\n",
       " 'P102880': ['AS04 - 10 - 02', 70.1002],\n",
       " 'P102881': ['AS06 - 06 - 05', 72.0605],\n",
       " 'P102882': ['IS01 - 12 - 00', 85.12],\n",
       " 'P102884': ['AS04 - 03 - 10', 70.031],\n",
       " 'P102885': ['XXXX - 00 - 28', 0.0028],\n",
       " 'P102886': ['SS02 - 12 - 00', 77.12],\n",
       " 'P102887': ['AS07 - 07 - 00', 73.07],\n",
       " 'P102888': ['AS07 - 05 - 00', 73.05],\n",
       " 'P102890': ['SS03 - 09 - 08', 78.0908],\n",
       " 'P102891': ['SS03 - 06 - 04', 78.0604],\n",
       " 'P102893': ['SS03 - 09 - 07', 78.0907],\n",
       " 'P102894': ['AS07 - 10 - 00', 73.1],\n",
       " 'P102895': ['SS02 - 11 - 00', 77.11],\n",
       " 'P102896': ['SS02 - 10 - 00', 77.1],\n",
       " 'P102897': ['SS02 - 11 - 00', 77.11],\n",
       " 'P102898': ['AS07 - 05 - 29', 73.0529],\n",
       " 'P102899': ['IS01 - 02 - 07', 85.02069999999998],\n",
       " 'P102900': ['AS08 - 12 - 07', 74.1207],\n",
       " 'P102901': ['AS08 - 12 - 06', 74.12060000000002],\n",
       " 'P102902': ['IS01 - 00 - 00', 85.0],\n",
       " 'P102903': ['AS01 - 11 - 09', 67.1109],\n",
       " 'P102904': ['AS06 - 03 - 05', 72.0305],\n",
       " 'P102905': ['AS03 - 12 - 16', 69.1216],\n",
       " 'P102906': ['AS06 - 03 - 22', 72.0322],\n",
       " 'P102908': ['AS04 - 08 - 18', 70.0818],\n",
       " 'P102909': ['XXXX - 00 - 25', 0.0025],\n",
       " 'P102912': ['AS03 - 10 - 07', 69.10069999999999],\n",
       " 'P102913': ['AS06 - 02 - 17', 72.0217],\n",
       " 'P102914': ['AS06 - 06 - 02', 72.06020000000002],\n",
       " 'P102915': ['SS02 - 04 - 00', 77.04],\n",
       " 'P102916': ['AS02 - 06 - 12', 68.0612],\n",
       " 'P102917': ['AS08 - 06 - 13', 74.0613],\n",
       " 'P102918': ['AS01 - 06 - 20', 67.062],\n",
       " 'P102919': ['AS01 - 02 - 15', 67.02149999999999],\n",
       " 'P102920': ['XXXX - 09 - 02', 0.0902],\n",
       " 'P102921': ['AS07 - 11 - 12', 73.1112],\n",
       " 'P102924': ['AS04 - 12d - 00', 70.12],\n",
       " 'P102925': ['SS01 - 10 - 00', 76.1],\n",
       " 'P102926': ['SS01 - 12 - 00', 76.12],\n",
       " 'P102927': ['SS07 - 06 - 28', 82.0628],\n",
       " 'P102929': ['SH44 - 07 - 19', 62.0719],\n",
       " 'P102930': ['AS04 - 04 - 29', 70.0429],\n",
       " 'P102931': ['SH33 - 09 - 00', 51.09],\n",
       " 'P102932': ['AS03 - 05 - 26', 69.0526],\n",
       " 'P102933': ['SH47 - 02 - 01', 65.0201],\n",
       " 'P102934': ['AS04 - 04 - 01', 70.04010000000001],\n",
       " 'P102935': ['SH40 - 01 - 00', 58.01],\n",
       " 'P102936': ['AS08 - 04 - 04', 74.0404],\n",
       " 'P102937': ['AS08 - 08 - 00', 74.08],\n",
       " 'P102938': ['AS08 - 07 - 17', 74.07169999999998],\n",
       " 'P102939': ['AS05 - 04 - 10', 71.04100000000003],\n",
       " 'P102940': ['AS08 - 00 - 00', 74.0],\n",
       " 'P102941': ['AS08 - 03 - 15', 74.0315],\n",
       " 'P102942': ['AS04 - 10 - 01', 70.1001],\n",
       " 'P102943': ['AS08 - 12 - 30', 74.123],\n",
       " 'P102945': ['SS03 - 09 - 00', 78.09],\n",
       " 'P102946': ['AS08 - 05 - 14', 74.0514],\n",
       " 'P102947': ['AS01 - 07 - 30', 67.07300000000001],\n",
       " 'P102949': ['SH46 - 12 - 23', 64.12230000000001],\n",
       " 'P102950': ['XXXX - 10 - 00', 0.1],\n",
       " 'P102952': ['AS08 - 06 - 07', 74.0607],\n",
       " 'P102953': ['AS05 - 06 - 07', 71.0607],\n",
       " 'P102954': ['SS09 - 06 - 26', 84.0626],\n",
       " 'P102955': ['IS02 - 12 - 10', 86.12100000000002],\n",
       " 'P102956': ['AS01 - 11 - 02', 67.1102],\n",
       " 'P102957': ['AS04 - 02 - 13', 70.0213],\n",
       " 'P102958': ['IS01 - 09 - 21', 85.0921],\n",
       " 'P102959': ['AS02 - 04 - 02', 68.04020000000001],\n",
       " 'P102960': ['AS08 - 01 - 25', 74.0125],\n",
       " 'P102962': ['AS08 - 11 - 09', 74.1109],\n",
       " 'P102963': ['XXXX - 07 - 00', 0.07],\n",
       " 'P102964': ['AS08 - 11 - 29', 74.1129],\n",
       " 'P102966': ['SH44 - 06 - 18', 62.06180000000001],\n",
       " 'P102967': ['AS04 - 05 - 25', 70.0525],\n",
       " 'P102968': ['AS04 - 08 - 18', 70.0818],\n",
       " 'P102970': ['AS03 - 11 - 04', 69.1104],\n",
       " 'P102971': ['AS07 - 03 - 29', 73.0329],\n",
       " 'P102972': ['AS06 - 06 - 29', 72.0629],\n",
       " 'P102973': ['AS04 - 01 - 20', 70.012],\n",
       " 'P102974': ['AS05 - 01 - 17', 71.0117],\n",
       " 'P102975': ['AS08 - 10 - 26', 74.1026],\n",
       " 'P102976': ['AS08 - 04 - 06', 74.04060000000003],\n",
       " 'P102977': ['SS02 - 08 - 00', 77.08],\n",
       " 'P102978': ['AS04 - 03 - 24', 70.0324],\n",
       " 'P102979': ['AS06 - 11 - 27', 72.1127],\n",
       " ...}"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dates = dates[['CDLI No', 'Original date', 'Converted Date']]\n",
    "date_dict = dates.set_index('CDLI No').T.to_dict('list')\n",
    "date_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0      [74.08149999999998, 72.08, 71.08149999999998, ...\n",
       "1      [74.08149999999998, 74.0822, 74.10079999999998...\n",
       "2      [71.11, 76.1, 65.071, 71.08149999999998, 71.08...\n",
       "3      [80.1108, 77.03, 79.12, 73.05, 69.0917, 84.01,...\n",
       "4      [80.1108, 75.12100000000002, 68.1, 76.0128, 76...\n",
       "                             ...                        \n",
       "580                                              [0.003]\n",
       "581                                            [85.0625]\n",
       "582               [65.12270000000001, 65.12270000000001]\n",
       "583                                            [69.1228]\n",
       "584                                             [74.061]\n",
       "Name: p_nums, Length: 585, dtype: object"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def get_converted_dates(p_nums):\n",
    "    ''' \n",
    "    Input: a list containg p numbers.\n",
    "    Output: a list containing the converted date for the corresponding p number.\n",
    "    '''\n",
    "    return [date_dict[i][1] if i in date_dict else np.nan for i in p_nums]\n",
    "\n",
    "date_col = geo_df['p_nums'].apply(get_converted_dates)\n",
    "date_col"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>geo_name</th>\n",
       "      <th>p_nums</th>\n",
       "      <th>neighbors</th>\n",
       "      <th>converted_dates</th>\n",
       "      <th>max date</th>\n",
       "      <th>min date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>tum-ma-al{ki}[]GN</td>\n",
       "      <td>[P124149, P103274, P107843, P134976, P131918, ...</td>\n",
       "      <td>{'P124149': ['eridu{ki}[]GN'], 'P103274': ['ša...</td>\n",
       "      <td>[74.08149999999998, 72.08, 71.08149999999998, ...</td>\n",
       "      <td>84.0828</td>\n",
       "      <td>0.0019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>eridu{ki}[]GN</td>\n",
       "      <td>[P124149, P107420, P212153, P126352, P210370, ...</td>\n",
       "      <td>{'P124149': ['tum-ma-al{ki}[]GN'], 'P107420': ...</td>\n",
       "      <td>[74.08149999999998, 74.0822, 74.10079999999998...</td>\n",
       "      <td>86.0708</td>\n",
       "      <td>0.0026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>unu{ki}[]GN</td>\n",
       "      <td>[P405489, P104590, P103800, P107843, P123981, ...</td>\n",
       "      <td>{'P405489': [], 'P104590': ['nibru{ki}-a[]GN',...</td>\n",
       "      <td>[71.11, 76.1, 65.071, 71.08149999999998, 71.08...</td>\n",
       "      <td>86.1100</td>\n",
       "      <td>0.0729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>zimbir{ki}[]GN</td>\n",
       "      <td>[P332036, P131582, P111934, P117626, P134703, ...</td>\n",
       "      <td>{'P332036': ['uri₅{ki}-ma[]GN', 'mu-ri-iq-ti-i...</td>\n",
       "      <td>[80.1108, 77.03, 79.12, 73.05, 69.0917, 84.01,...</td>\n",
       "      <td>84.0100</td>\n",
       "      <td>0.0725</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>uri₅{ki}-ma[]GN</td>\n",
       "      <td>[P332036, P124307, P103657, P106357, P104590, ...</td>\n",
       "      <td>{'P332036': ['zimbir{ki}[]GN', 'mu-ri-iq-ti-id...</td>\n",
       "      <td>[80.1108, 75.12100000000002, 68.1, 76.0128, 76...</td>\n",
       "      <td>87.1200</td>\n",
       "      <td>0.0006</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            geo_name                                             p_nums  \\\n",
       "0  tum-ma-al{ki}[]GN  [P124149, P103274, P107843, P134976, P131918, ...   \n",
       "1      eridu{ki}[]GN  [P124149, P107420, P212153, P126352, P210370, ...   \n",
       "2        unu{ki}[]GN  [P405489, P104590, P103800, P107843, P123981, ...   \n",
       "3     zimbir{ki}[]GN  [P332036, P131582, P111934, P117626, P134703, ...   \n",
       "4    uri₅{ki}-ma[]GN  [P332036, P124307, P103657, P106357, P104590, ...   \n",
       "\n",
       "                                           neighbors  \\\n",
       "0  {'P124149': ['eridu{ki}[]GN'], 'P103274': ['ša...   \n",
       "1  {'P124149': ['tum-ma-al{ki}[]GN'], 'P107420': ...   \n",
       "2  {'P405489': [], 'P104590': ['nibru{ki}-a[]GN',...   \n",
       "3  {'P332036': ['uri₅{ki}-ma[]GN', 'mu-ri-iq-ti-i...   \n",
       "4  {'P332036': ['zimbir{ki}[]GN', 'mu-ri-iq-ti-id...   \n",
       "\n",
       "                                     converted_dates  max date  min date  \n",
       "0  [74.08149999999998, 72.08, 71.08149999999998, ...   84.0828    0.0019  \n",
       "1  [74.08149999999998, 74.0822, 74.10079999999998...   86.0708    0.0026  \n",
       "2  [71.11, 76.1, 65.071, 71.08149999999998, 71.08...   86.1100    0.0729  \n",
       "3  [80.1108, 77.03, 79.12, 73.05, 69.0917, 84.01,...   84.0100    0.0725  \n",
       "4  [80.1108, 75.12100000000002, 68.1, 76.0128, 76...   87.1200    0.0006  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def min_no_0(dates):\n",
    "    '''\n",
    "    Input: a list of converted dates.\n",
    "    Output: the minimum date excluding 0. \n",
    "            If every value in DATES is 0, return NaN.\n",
    "    '''\n",
    "    no_0 = [i for i in dates if i != 0]\n",
    "    if len(no_0) == 0:\n",
    "        return np.nan\n",
    "    else:\n",
    "        return min(no_0)\n",
    "\n",
    "geo_df['converted_dates'] = date_col\n",
    "geo_df['max date'] = geo_df['converted_dates'].apply(max)\n",
    "geo_df['min date'] = geo_df['converted_dates'].apply(min_no_0)\n",
    "geo_df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "However, some p number (CDLI No) corresponds to multiple dates."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}