{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/tthatcher/anaconda3/envs/autocnet/lib/python3.6/site-packages/h5py/__init__.py:36: FutureWarning: Conversion of the second argument of issubdtype from `float` to `np.floating` is deprecated. In future, it will be treated as `np.float64 == np.dtype(float).type`.\n",
      "  from ._conv import register_converters as _register_converters\n"
     ]
    }
   ],
   "source": [
    "import os\n",
    "import sys\n",
    "from functools import singledispatch\n",
    "import warnings\n",
    "\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "sys.path.insert(0, \"/home/tthatcher/Desktop/Projects/Plio/plio\")\n",
    "\n",
    "from plio.examples import get_path\n",
    "from plio.io.io_bae import read_gpf, read_ipf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Reads a .atf file and outputs all of the \n",
    "# .ipf, .gpf, .sup, .prj, and path to locate the \n",
    "# .apf file (should be the same as all others) \n",
    "def read_atf(atf_file):\n",
    "    with open(atf_file) as f:\n",
    "\n",
    "        files = []\n",
    "        ipf = []\n",
    "        sup = []\n",
    "        files_dict = []\n",
    "        \n",
    "        # Grabs every PRJ, GPF, SUP, and IPF image from the ATF file\n",
    "        for line in f:\n",
    "            if line[-4:-1] == 'prj' or line[-4:-1] == 'gpf' or line[-4:-1] == 'sup' or line[-4:-1] == 'ipf' or line[-4:-1] == 'atf':\n",
    "                files.append(line)\n",
    "        \n",
    "        files = np.array(files)\n",
    "        \n",
    "        # Creates appropriate arrays for certain files in the right format\n",
    "        for file in files:\n",
    "            file = file.strip()\n",
    "            file = file.split(' ')\n",
    "\n",
    "            # Grabs all the IPF files\n",
    "            if file[1].endswith('.ipf'):\n",
    "                ipf.append(file[1])\n",
    "\n",
    "            # Grabs all the SUP files\n",
    "            if file[1].endswith('.sup'):\n",
    "                sup.append(file[1])\n",
    "\n",
    "            files_dict.append(file)\n",
    "\n",
    "        # Creates a dict out of file lists for GPF, PRJ, IPF, and ATF\n",
    "        files_dict = (dict(files_dict))\n",
    "        \n",
    "        # Sets the value of IMAGE_IPF to all IPF images\n",
    "        files_dict['IMAGE_IPF'] = ipf\n",
    "        \n",
    "        # Sets the value of IMAGE_SUP to all SUP images\n",
    "        files_dict['IMAGE_SUP'] = sup\n",
    "        \n",
    "        # Sets the value of PATH to the path of the ATF file\n",
    "        files_dict['PATH'] = os.path.dirname(os.path.abspath(atf_file))\n",
    "        \n",
    "        return files_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'PROJECT': 'D:\\\\data\\\\CTX_Athabasca_Middle.prj', 'ATF_FILE': 'CTX_Athabasca_Middle_step0.atf', 'GP_FILE': 'CTX_Athabasca_Middle.gpf', 'IMAGE_SUP': ['P19_008344_1894_XN_09N203W.sup', 'P20_008845_1894_XN_09N203W.sup', 'P03_002371_1888_XI_08N204W.sup', 'P01_001540_1889_XI_08N204W.sup', 'P01_001606_1897_XI_09N203W.sup', 'P03_002226_1895_XI_09N203W.sup'], 'IMAGE_IPF': ['P19_008344_1894_XN_09N203W.ipf', 'P20_008845_1894_XN_09N203W.ipf', 'P03_002371_1888_XI_08N204W.ipf', 'P01_001540_1889_XI_08N204W.ipf', 'P01_001606_1897_XI_09N203W.ipf', 'P03_002226_1895_XI_09N203W.ipf'], 'PATH': '/home/tthatcher/Desktop/Projects/Plio/plio/plio/examples/SocetSet'}\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/tthatcher/anaconda3/envs/autocnet/lib/python3.6/site-packages/ipykernel_launcher.py:13: UserWarning: The following points found in ipf files missing from gpf file: \n",
      "\n",
      "['P03_002226_1895_XI_09N203W_15', 'P03_002226_1895_XI_09N203W_16', 'P03_002226_1895_XI_09N203W_17', 'P03_002226_1895_XI_09N203W_18', 'P03_002226_1895_XI_09N203W_19', 'P03_002226_1895_XI_09N203W_20', 'P03_002226_1895_XI_09N203W_21', 'P03_002226_1895_XI_09N203W_22', 'P03_002226_1895_XI_09N203W_24', 'P03_002226_1895_XI_09N203W_26', 'P03_002226_1895_XI_09N203W_30', 'P03_002226_1895_XI_09N203W_31', 'P03_002226_1895_XI_09N203W_32', 'P03_002226_1895_XI_09N203W_34', 'P03_002226_1895_XI_09N203W_36', 'P03_002226_1895_XI_09N203W_37', 'P03_002226_1895_XI_09N203W_44', 'P03_002226_1895_XI_09N203W_48', 'P03_002226_1895_XI_09N203W_49', 'P03_002226_1895_XI_09N203W_56', 'P03_002226_1895_XI_09N203W_57', 'P03_002226_1895_XI_09N203W_61', 'P03_002226_1895_XI_09N203W_62', 'P03_002226_1895_XI_09N203W_63', 'P03_002226_1895_XI_09N203W_65', 'P19_008344_1894_XN_09N203W_4', 'P20_008845_1894_XN_09N203W_15'].                   \n",
      "\n",
      "Continuing, but these points will be missing from the control network\n",
      "  del sys.path[0]\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "['val',\n",
       " 'fid_val',\n",
       " 'no_obs',\n",
       " 'l.',\n",
       " 's.',\n",
       " 'sig_l',\n",
       " 'sig_s',\n",
       " 'res_l',\n",
       " 'res_s',\n",
       " 'fid_x',\n",
       " 'fid_y',\n",
       " 'ipf_file',\n",
       " 'stat',\n",
       " 'known',\n",
       " 'lat_Y_North',\n",
       " 'long_X_East',\n",
       " 'ht',\n",
       " 'sig0',\n",
       " 'sig1',\n",
       " 'sig2',\n",
       " 'res0',\n",
       " 'res1',\n",
       " 'res2']"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "atf_dict = read_atf(get_path('CTX_Athabasca_Middle_step0.atf'))\n",
    "print(atf_dict)\n",
    "\n",
    "gpf_file = os.path.join(atf_dict['PATH'], atf_dict['GP_FILE']);\n",
    "ipf_list = [os.path.join(atf_dict['PATH'], i) for i in atf_dict['IMAGE_IPF']]\n",
    "\n",
    "gpf_df = read_gpf(gpf_file).set_index('point_id')\n",
    "ipf_df = read_ipf(ipf_list).set_index('pt_id')\n",
    "\n",
    "point_diff = ipf_df.index.difference(gpf_df.index)\n",
    "\n",
    "if len(point_diff) != 0:\n",
    "    warnings.warn(\"The following points found in ipf files missing from gpf file: \\n\\n{}. \\\n",
    "                  \\n\\nContinuing, but these points will be missing from the control network\".format(list(point_diff)))\n",
    "\n",
    "new_df = ipf_df.merge(gpf_df, left_index=True, right_index=True)\n",
    "list(new_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>val</th>\n",
       "      <th>fid_val</th>\n",
       "      <th>no_obs</th>\n",
       "      <th>l.</th>\n",
       "      <th>s.</th>\n",
       "      <th>sig_l</th>\n",
       "      <th>sig_s</th>\n",
       "      <th>res_l</th>\n",
       "      <th>res_s</th>\n",
       "      <th>fid_x</th>\n",
       "      <th>...</th>\n",
       "      <th>known</th>\n",
       "      <th>lat_Y_North</th>\n",
       "      <th>long_X_East</th>\n",
       "      <th>ht</th>\n",
       "      <th>sig0</th>\n",
       "      <th>sig1</th>\n",
       "      <th>sig2</th>\n",
       "      <th>res0</th>\n",
       "      <th>res1</th>\n",
       "      <th>res2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-2919.380615</td>\n",
       "      <td>1052.729004</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.059914</td>\n",
       "      <td>0.930311</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.159378</td>\n",
       "      <td>2.724649</td>\n",
       "      <td>-2523.828227</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>18.301328</td>\n",
       "      <td>44.206259</td>\n",
       "      <td>416.201741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-4044.697510</td>\n",
       "      <td>1008.950928</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.063678</td>\n",
       "      <td>0.661294</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.159378</td>\n",
       "      <td>2.724649</td>\n",
       "      <td>-2523.828227</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>18.301328</td>\n",
       "      <td>44.206259</td>\n",
       "      <td>416.201741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1700.584473</td>\n",
       "      <td>-2390.001709</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.063695</td>\n",
       "      <td>-1.055619</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.159378</td>\n",
       "      <td>2.724649</td>\n",
       "      <td>-2523.828227</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>18.301328</td>\n",
       "      <td>44.206259</td>\n",
       "      <td>416.201741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2006.141113</td>\n",
       "      <td>-2234.915283</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.318779</td>\n",
       "      <td>-0.585138</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.159378</td>\n",
       "      <td>2.724649</td>\n",
       "      <td>-2523.828227</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>18.301328</td>\n",
       "      <td>44.206259</td>\n",
       "      <td>416.201741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>370.151917</td>\n",
       "      <td>2340.653076</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.239226</td>\n",
       "      <td>-1.113693</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.164905</td>\n",
       "      <td>2.721815</td>\n",
       "      <td>-2445.237027</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>-22.046575</td>\n",
       "      <td>103.403228</td>\n",
       "      <td>173.210013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-761.216064</td>\n",
       "      <td>2303.787109</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.247307</td>\n",
       "      <td>-0.587299</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.164905</td>\n",
       "      <td>2.721815</td>\n",
       "      <td>-2445.237027</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>-22.046575</td>\n",
       "      <td>103.403228</td>\n",
       "      <td>173.210013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4985.437988</td>\n",
       "      <td>-1070.364990</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.239207</td>\n",
       "      <td>1.080801</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.164905</td>\n",
       "      <td>2.721815</td>\n",
       "      <td>-2445.237027</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>-22.046575</td>\n",
       "      <td>103.403228</td>\n",
       "      <td>173.210013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5293.700195</td>\n",
       "      <td>-993.390625</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.672877</td>\n",
       "      <td>0.626316</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.164905</td>\n",
       "      <td>2.721815</td>\n",
       "      <td>-2445.237027</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>-22.046575</td>\n",
       "      <td>103.403228</td>\n",
       "      <td>173.210013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>236.395218</td>\n",
       "      <td>984.833252</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.073683</td>\n",
       "      <td>-0.237114</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.164949</td>\n",
       "      <td>2.724076</td>\n",
       "      <td>-2606.935163</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>-7.549561</td>\n",
       "      <td>93.170584</td>\n",
       "      <td>180.058858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-889.364441</td>\n",
       "      <td>966.533997</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.251753</td>\n",
       "      <td>0.008170</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.164949</td>\n",
       "      <td>2.724076</td>\n",
       "      <td>-2606.935163</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>-7.549561</td>\n",
       "      <td>93.170584</td>\n",
       "      <td>180.058858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4856.525391</td>\n",
       "      <td>-2439.154785</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.133406</td>\n",
       "      <td>0.068024</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.164949</td>\n",
       "      <td>2.724076</td>\n",
       "      <td>-2606.935163</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>-7.549561</td>\n",
       "      <td>93.170584</td>\n",
       "      <td>180.058858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5158.205566</td>\n",
       "      <td>-2295.737549</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.487209</td>\n",
       "      <td>0.036399</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.164949</td>\n",
       "      <td>2.724076</td>\n",
       "      <td>-2606.935163</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>-7.549561</td>\n",
       "      <td>93.170584</td>\n",
       "      <td>180.058858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-1431.023804</td>\n",
       "      <td>1817.888672</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.056901</td>\n",
       "      <td>-0.383259</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.161840</td>\n",
       "      <td>2.723059</td>\n",
       "      <td>-2551.901554</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.536068</td>\n",
       "      <td>-1.643694</td>\n",
       "      <td>74.244153</td>\n",
       "      <td>319.554535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-2559.871338</td>\n",
       "      <td>1777.522827</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.131265</td>\n",
       "      <td>-0.305102</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.161840</td>\n",
       "      <td>2.723059</td>\n",
       "      <td>-2551.901554</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.536068</td>\n",
       "      <td>-1.643694</td>\n",
       "      <td>74.244153</td>\n",
       "      <td>319.554535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3186.063232</td>\n",
       "      <td>-1598.743530</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.019201</td>\n",
       "      <td>0.485372</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.161840</td>\n",
       "      <td>2.723059</td>\n",
       "      <td>-2551.901554</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.536068</td>\n",
       "      <td>-1.643694</td>\n",
       "      <td>74.244153</td>\n",
       "      <td>319.554535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3493.876221</td>\n",
       "      <td>-1493.029175</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.568393</td>\n",
       "      <td>0.146750</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.161840</td>\n",
       "      <td>2.723059</td>\n",
       "      <td>-2551.901554</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.536068</td>\n",
       "      <td>-1.643694</td>\n",
       "      <td>74.244153</td>\n",
       "      <td>319.554535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3518.268066</td>\n",
       "      <td>2495.108643</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.268449</td>\n",
       "      <td>1.000455</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.170415</td>\n",
       "      <td>2.720880</td>\n",
       "      <td>-2505.953426</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>-50.069808</td>\n",
       "      <td>144.316524</td>\n",
       "      <td>-164.540707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2385.278320</td>\n",
       "      <td>2476.032227</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.389532</td>\n",
       "      <td>-0.299258</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.170415</td>\n",
       "      <td>2.720880</td>\n",
       "      <td>-2505.953426</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>-50.069808</td>\n",
       "      <td>144.316524</td>\n",
       "      <td>-164.540707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8131.361816</td>\n",
       "      <td>-902.645325</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.469784</td>\n",
       "      <td>0.023018</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.170415</td>\n",
       "      <td>2.720880</td>\n",
       "      <td>-2505.953426</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>-50.069808</td>\n",
       "      <td>144.316524</td>\n",
       "      <td>-164.540707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8437.115234</td>\n",
       "      <td>-842.309326</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.289877</td>\n",
       "      <td>-0.829150</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.170415</td>\n",
       "      <td>2.720880</td>\n",
       "      <td>-2505.953426</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>-50.069808</td>\n",
       "      <td>144.316524</td>\n",
       "      <td>-164.540707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15_8344_8845_4r_mt_z</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3522.998535</td>\n",
       "      <td>1049.406982</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.466921</td>\n",
       "      <td>1.168062</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0.170723</td>\n",
       "      <td>2.723266</td>\n",
       "      <td>-2502.470000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>-34.817656</td>\n",
       "      <td>145.864550</td>\n",
       "      <td>0.214023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15_8344_8845_4r_mt_z</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2395.869385</td>\n",
       "      <td>1038.165405</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.170850</td>\n",
       "      <td>0.372485</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0.170723</td>\n",
       "      <td>2.723266</td>\n",
       "      <td>-2502.470000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>-34.817656</td>\n",
       "      <td>145.864550</td>\n",
       "      <td>0.214023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15_8344_8845_4r_mt_z</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8142.054688</td>\n",
       "      <td>-2364.445557</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.072035</td>\n",
       "      <td>-0.832436</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0.170723</td>\n",
       "      <td>2.723266</td>\n",
       "      <td>-2502.470000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>-34.817656</td>\n",
       "      <td>145.864550</td>\n",
       "      <td>0.214023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15_8344_8845_4r_mt_z</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8440.085938</td>\n",
       "      <td>-2219.049805</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.274030</td>\n",
       "      <td>-0.850105</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0.170723</td>\n",
       "      <td>2.723266</td>\n",
       "      <td>-2502.470000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>-34.817656</td>\n",
       "      <td>145.864550</td>\n",
       "      <td>0.214023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1885.346313</td>\n",
       "      <td>1807.367065</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.028473</td>\n",
       "      <td>-0.238015</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.167682</td>\n",
       "      <td>2.722359</td>\n",
       "      <td>-2558.312931</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.707214</td>\n",
       "      <td>-29.465246</td>\n",
       "      <td>121.908506</td>\n",
       "      <td>19.874949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>756.099792</td>\n",
       "      <td>1785.494751</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.165338</td>\n",
       "      <td>-0.327408</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.167682</td>\n",
       "      <td>2.722359</td>\n",
       "      <td>-2558.312931</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.707214</td>\n",
       "      <td>-29.465246</td>\n",
       "      <td>121.908506</td>\n",
       "      <td>19.874949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6502.070313</td>\n",
       "      <td>-1593.964233</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.007916</td>\n",
       "      <td>0.463232</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.167682</td>\n",
       "      <td>2.722359</td>\n",
       "      <td>-2558.312931</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.707214</td>\n",
       "      <td>-29.465246</td>\n",
       "      <td>121.908506</td>\n",
       "      <td>19.874949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6805.896973</td>\n",
       "      <td>-1493.774048</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.328896</td>\n",
       "      <td>0.019526</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.167682</td>\n",
       "      <td>2.722359</td>\n",
       "      <td>-2558.312931</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.707214</td>\n",
       "      <td>-29.465246</td>\n",
       "      <td>121.908506</td>\n",
       "      <td>19.874949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17_8344_8845_2r_mt_z</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-2015.364380</td>\n",
       "      <td>465.268188</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.010045</td>\n",
       "      <td>0.244017</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0.161092</td>\n",
       "      <td>2.725426</td>\n",
       "      <td>-2590.130000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>-10.779830</td>\n",
       "      <td>38.761214</td>\n",
       "      <td>0.236077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17_8344_8845_2r_mt_z</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-3138.269531</td>\n",
       "      <td>442.515503</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.023370</td>\n",
       "      <td>-0.248643</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0.161092</td>\n",
       "      <td>2.725426</td>\n",
       "      <td>-2590.130000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>-10.779830</td>\n",
       "      <td>38.761214</td>\n",
       "      <td>0.236077</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",
       "      <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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_18</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8918.806641</td>\n",
       "      <td>-1701.755249</td>\n",
       "      <td>0.022017</td>\n",
       "      <td>0.022017</td>\n",
       "      <td>0.734173</td>\n",
       "      <td>-0.074947</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.171455</td>\n",
       "      <td>2.722281</td>\n",
       "      <td>-2514.431453</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-38.388316</td>\n",
       "      <td>195.050373</td>\n",
       "      <td>-391.289238</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_2</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-2277.691406</td>\n",
       "      <td>-2240.823486</td>\n",
       "      <td>0.144273</td>\n",
       "      <td>0.144273</td>\n",
       "      <td>-0.061422</td>\n",
       "      <td>-0.263554</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.161184</td>\n",
       "      <td>2.729925</td>\n",
       "      <td>-2535.712262</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>42.067289</td>\n",
       "      <td>-12.658160</td>\n",
       "      <td>627.742625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_2</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-3389.000000</td>\n",
       "      <td>-2155.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.073150</td>\n",
       "      <td>-0.271173</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.161184</td>\n",
       "      <td>2.729925</td>\n",
       "      <td>-2535.712262</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>42.067289</td>\n",
       "      <td>-12.658160</td>\n",
       "      <td>627.742625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_2</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-5474.326660</td>\n",
       "      <td>842.207031</td>\n",
       "      <td>0.275627</td>\n",
       "      <td>0.275627</td>\n",
       "      <td>0.164525</td>\n",
       "      <td>0.349547</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.161184</td>\n",
       "      <td>2.729925</td>\n",
       "      <td>-2535.712262</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>42.067289</td>\n",
       "      <td>-12.658160</td>\n",
       "      <td>627.742625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_2</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-4613.785645</td>\n",
       "      <td>643.217224</td>\n",
       "      <td>0.091086</td>\n",
       "      <td>0.091086</td>\n",
       "      <td>0.132736</td>\n",
       "      <td>0.239899</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.161184</td>\n",
       "      <td>2.729925</td>\n",
       "      <td>-2535.712262</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>42.067289</td>\n",
       "      <td>-12.658160</td>\n",
       "      <td>627.742625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_3</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-1801.096436</td>\n",
       "      <td>-2078.479004</td>\n",
       "      <td>0.062058</td>\n",
       "      <td>0.062058</td>\n",
       "      <td>-0.198696</td>\n",
       "      <td>-0.105860</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.161992</td>\n",
       "      <td>2.729563</td>\n",
       "      <td>-2525.215515</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>36.033823</td>\n",
       "      <td>-4.170818</td>\n",
       "      <td>616.480181</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_3</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-2913.000000</td>\n",
       "      <td>-2000.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.088180</td>\n",
       "      <td>-0.049593</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.161992</td>\n",
       "      <td>2.729563</td>\n",
       "      <td>-2525.215515</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>36.033823</td>\n",
       "      <td>-4.170818</td>\n",
       "      <td>616.480181</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_3</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-4997.791504</td>\n",
       "      <td>1000.375854</td>\n",
       "      <td>0.132941</td>\n",
       "      <td>0.132941</td>\n",
       "      <td>0.257260</td>\n",
       "      <td>0.117777</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.161992</td>\n",
       "      <td>2.729563</td>\n",
       "      <td>-2525.215515</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>36.033823</td>\n",
       "      <td>-4.170818</td>\n",
       "      <td>616.480181</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_3</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-4137.536133</td>\n",
       "      <td>774.480347</td>\n",
       "      <td>0.185544</td>\n",
       "      <td>0.185544</td>\n",
       "      <td>0.199301</td>\n",
       "      <td>0.065777</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.161992</td>\n",
       "      <td>2.729563</td>\n",
       "      <td>-2525.215515</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>36.033823</td>\n",
       "      <td>-4.170818</td>\n",
       "      <td>616.480181</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_4</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-2103.971680</td>\n",
       "      <td>184.334869</td>\n",
       "      <td>0.146920</td>\n",
       "      <td>0.146920</td>\n",
       "      <td>0.182557</td>\n",
       "      <td>-0.000683</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.160994</td>\n",
       "      <td>2.725912</td>\n",
       "      <td>-2562.446851</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-7.233876</td>\n",
       "      <td>33.324946</td>\n",
       "      <td>574.887719</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_4</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-3226.000000</td>\n",
       "      <td>167.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.195774</td>\n",
       "      <td>-0.000066</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.160994</td>\n",
       "      <td>2.725912</td>\n",
       "      <td>-2562.446851</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-7.233876</td>\n",
       "      <td>33.324946</td>\n",
       "      <td>574.887719</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_5</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-1813.285278</td>\n",
       "      <td>3.928788</td>\n",
       "      <td>0.019047</td>\n",
       "      <td>0.019047</td>\n",
       "      <td>-0.235171</td>\n",
       "      <td>-0.174079</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.161544</td>\n",
       "      <td>2.726149</td>\n",
       "      <td>-2560.812028</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7.498790</td>\n",
       "      <td>33.109007</td>\n",
       "      <td>581.149470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_5</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-2934.000000</td>\n",
       "      <td>-6.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.049005</td>\n",
       "      <td>0.437424</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.161544</td>\n",
       "      <td>2.726149</td>\n",
       "      <td>-2560.812028</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7.498790</td>\n",
       "      <td>33.109007</td>\n",
       "      <td>581.149470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_5</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-4165.228516</td>\n",
       "      <td>2507.076660</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.447100</td>\n",
       "      <td>-0.219764</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.161544</td>\n",
       "      <td>2.726149</td>\n",
       "      <td>-2560.812028</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7.498790</td>\n",
       "      <td>33.109007</td>\n",
       "      <td>581.149470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_6</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-2250.549072</td>\n",
       "      <td>1572.788086</td>\n",
       "      <td>0.025015</td>\n",
       "      <td>0.025015</td>\n",
       "      <td>-0.146990</td>\n",
       "      <td>0.192274</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.160447</td>\n",
       "      <td>2.723639</td>\n",
       "      <td>-2605.266130</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7.687475</td>\n",
       "      <td>59.859663</td>\n",
       "      <td>375.680663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_6</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>-3378.000000</td>\n",
       "      <td>1532.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.026541</td>\n",
       "      <td>0.063346</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.160447</td>\n",
       "      <td>2.723639</td>\n",
       "      <td>-2605.266130</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7.687475</td>\n",
       "      <td>59.859663</td>\n",
       "      <td>375.680663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_6</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2367.587646</td>\n",
       "      <td>-1849.272095</td>\n",
       "      <td>0.025110</td>\n",
       "      <td>0.025110</td>\n",
       "      <td>-0.040890</td>\n",
       "      <td>-0.136247</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.160447</td>\n",
       "      <td>2.723639</td>\n",
       "      <td>-2605.266130</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7.687475</td>\n",
       "      <td>59.859663</td>\n",
       "      <td>375.680663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_6</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2675.137207</td>\n",
       "      <td>-1730.558105</td>\n",
       "      <td>0.064276</td>\n",
       "      <td>0.064276</td>\n",
       "      <td>0.546035</td>\n",
       "      <td>-0.185103</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.160447</td>\n",
       "      <td>2.723639</td>\n",
       "      <td>-2605.266130</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7.687475</td>\n",
       "      <td>59.859663</td>\n",
       "      <td>375.680663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_7</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-2249.931396</td>\n",
       "      <td>1712.971436</td>\n",
       "      <td>0.010596</td>\n",
       "      <td>0.010596</td>\n",
       "      <td>-0.102909</td>\n",
       "      <td>0.079389</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.160419</td>\n",
       "      <td>2.723407</td>\n",
       "      <td>-2619.498291</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6.358447</td>\n",
       "      <td>61.278242</td>\n",
       "      <td>375.840988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_7</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>-3378.000000</td>\n",
       "      <td>1672.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.055623</td>\n",
       "      <td>0.013456</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.160419</td>\n",
       "      <td>2.723407</td>\n",
       "      <td>-2619.498291</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6.358447</td>\n",
       "      <td>61.278242</td>\n",
       "      <td>375.840988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_7</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2367.507813</td>\n",
       "      <td>-1706.241821</td>\n",
       "      <td>0.047435</td>\n",
       "      <td>0.047435</td>\n",
       "      <td>-0.157931</td>\n",
       "      <td>-0.042074</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.160419</td>\n",
       "      <td>2.723407</td>\n",
       "      <td>-2619.498291</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6.358447</td>\n",
       "      <td>61.278242</td>\n",
       "      <td>375.840988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_7</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2675.892578</td>\n",
       "      <td>-1596.527100</td>\n",
       "      <td>0.058218</td>\n",
       "      <td>0.058218</td>\n",
       "      <td>0.589561</td>\n",
       "      <td>-0.111421</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.160419</td>\n",
       "      <td>2.723407</td>\n",
       "      <td>-2619.498291</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6.358447</td>\n",
       "      <td>61.278242</td>\n",
       "      <td>375.840988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_8</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-1664.131104</td>\n",
       "      <td>1875.622437</td>\n",
       "      <td>0.017266</td>\n",
       "      <td>0.017266</td>\n",
       "      <td>-0.239689</td>\n",
       "      <td>-0.402891</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.161417</td>\n",
       "      <td>2.723012</td>\n",
       "      <td>-2608.028730</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.219662</td>\n",
       "      <td>71.414267</td>\n",
       "      <td>336.409684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_8</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>-2793.000000</td>\n",
       "      <td>1837.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.117483</td>\n",
       "      <td>-0.229337</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.161417</td>\n",
       "      <td>2.723012</td>\n",
       "      <td>-2608.028730</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.219662</td>\n",
       "      <td>71.414267</td>\n",
       "      <td>336.409684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_8</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2953.094727</td>\n",
       "      <td>-1538.956543</td>\n",
       "      <td>0.023364</td>\n",
       "      <td>0.023364</td>\n",
       "      <td>0.177406</td>\n",
       "      <td>0.403161</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.161417</td>\n",
       "      <td>2.723012</td>\n",
       "      <td>-2608.028730</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.219662</td>\n",
       "      <td>71.414267</td>\n",
       "      <td>336.409684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_8</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3261.290039</td>\n",
       "      <td>-1439.873169</td>\n",
       "      <td>0.023538</td>\n",
       "      <td>0.023538</td>\n",
       "      <td>0.575510</td>\n",
       "      <td>0.180705</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.161417</td>\n",
       "      <td>2.723012</td>\n",
       "      <td>-2608.028730</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.219662</td>\n",
       "      <td>71.414267</td>\n",
       "      <td>336.409684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_9</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>332.072113</td>\n",
       "      <td>-2045.152222</td>\n",
       "      <td>0.232865</td>\n",
       "      <td>0.232865</td>\n",
       "      <td>0.095817</td>\n",
       "      <td>-0.483899</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.165741</td>\n",
       "      <td>2.729053</td>\n",
       "      <td>-2586.686862</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>15.191825</td>\n",
       "      <td>22.094037</td>\n",
       "      <td>544.874936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_9</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-780.000000</td>\n",
       "      <td>-1953.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.298743</td>\n",
       "      <td>-0.045963</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.165741</td>\n",
       "      <td>2.729053</td>\n",
       "      <td>-2586.686862</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>15.191825</td>\n",
       "      <td>22.094037</td>\n",
       "      <td>544.874936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_9</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-2866.689453</td>\n",
       "      <td>1031.006104</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.038437</td>\n",
       "      <td>0.471309</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.165741</td>\n",
       "      <td>2.729053</td>\n",
       "      <td>-2586.686862</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>15.191825</td>\n",
       "      <td>22.094037</td>\n",
       "      <td>544.874936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_9</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-2002.366211</td>\n",
       "      <td>824.604126</td>\n",
       "      <td>0.397616</td>\n",
       "      <td>0.397616</td>\n",
       "      <td>-0.141172</td>\n",
       "      <td>0.105223</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.165741</td>\n",
       "      <td>2.729053</td>\n",
       "      <td>-2586.686862</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>15.191825</td>\n",
       "      <td>22.094037</td>\n",
       "      <td>544.874936</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>919 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                               val  fid_val  no_obs           l.           s.  \\\n",
       "10_8344_8845_4r                  1        0       0 -2919.380615  1052.729004   \n",
       "10_8344_8845_4r                  1        0       0 -4044.697510  1008.950928   \n",
       "10_8344_8845_4r                  1        0       0  1700.584473 -2390.001709   \n",
       "10_8344_8845_4r                  1        0       0  2006.141113 -2234.915283   \n",
       "11_8344_8845_4r                  1        0       0   370.151917  2340.653076   \n",
       "11_8344_8845_4r                  1        0       0  -761.216064  2303.787109   \n",
       "11_8344_8845_4r                  1        0       0  4985.437988 -1070.364990   \n",
       "11_8344_8845_4r                  1        0       0  5293.700195  -993.390625   \n",
       "12_8344_8845_4r                  1        0       0   236.395218   984.833252   \n",
       "12_8344_8845_4r                  1        0       0  -889.364441   966.533997   \n",
       "12_8344_8845_4r                  1        0       0  4856.525391 -2439.154785   \n",
       "12_8344_8845_4r                  1        0       0  5158.205566 -2295.737549   \n",
       "13_8344_8845_4r                  1        0       0 -1431.023804  1817.888672   \n",
       "13_8344_8845_4r                  1        0       0 -2559.871338  1777.522827   \n",
       "13_8344_8845_4r                  1        0       0  3186.063232 -1598.743530   \n",
       "13_8344_8845_4r                  1        0       0  3493.876221 -1493.029175   \n",
       "14_8344_8845_4r                  1        0       0  3518.268066  2495.108643   \n",
       "14_8344_8845_4r                  1        0       0  2385.278320  2476.032227   \n",
       "14_8344_8845_4r                  1        0       0  8131.361816  -902.645325   \n",
       "14_8344_8845_4r                  1        0       0  8437.115234  -842.309326   \n",
       "15_8344_8845_4r_mt_z             1        0       0  3522.998535  1049.406982   \n",
       "15_8344_8845_4r_mt_z             1        0       0  2395.869385  1038.165405   \n",
       "15_8344_8845_4r_mt_z             1        0       0  8142.054688 -2364.445557   \n",
       "15_8344_8845_4r_mt_z             1        0       0  8440.085938 -2219.049805   \n",
       "16_8344_8845_4r                  1        0       0  1885.346313  1807.367065   \n",
       "16_8344_8845_4r                  1        0       0   756.099792  1785.494751   \n",
       "16_8344_8845_4r                  1        0       0  6502.070313 -1593.964233   \n",
       "16_8344_8845_4r                  1        0       0  6805.896973 -1493.774048   \n",
       "17_8344_8845_2r_mt_z             1        0       0 -2015.364380   465.268188   \n",
       "17_8344_8845_2r_mt_z             1        0       0 -3138.269531   442.515503   \n",
       "...                            ...      ...     ...          ...          ...   \n",
       "P20_008845_1894_XN_09N203W_18    1        0       1  8918.806641 -1701.755249   \n",
       "P20_008845_1894_XN_09N203W_2     1        0       1 -2277.691406 -2240.823486   \n",
       "P20_008845_1894_XN_09N203W_2     1        0       0 -3389.000000 -2155.000000   \n",
       "P20_008845_1894_XN_09N203W_2     1        0       1 -5474.326660   842.207031   \n",
       "P20_008845_1894_XN_09N203W_2     1        0       0 -4613.785645   643.217224   \n",
       "P20_008845_1894_XN_09N203W_3     1        0       1 -1801.096436 -2078.479004   \n",
       "P20_008845_1894_XN_09N203W_3     1        0       0 -2913.000000 -2000.000000   \n",
       "P20_008845_1894_XN_09N203W_3     1        0       1 -4997.791504  1000.375854   \n",
       "P20_008845_1894_XN_09N203W_3     1        0       0 -4137.536133   774.480347   \n",
       "P20_008845_1894_XN_09N203W_4     1        0       1 -2103.971680   184.334869   \n",
       "P20_008845_1894_XN_09N203W_4     1        0       1 -3226.000000   167.000000   \n",
       "P20_008845_1894_XN_09N203W_5     1        0       1 -1813.285278     3.928788   \n",
       "P20_008845_1894_XN_09N203W_5     1        0       1 -2934.000000    -6.000000   \n",
       "P20_008845_1894_XN_09N203W_5     1        0       0 -4165.228516  2507.076660   \n",
       "P20_008845_1894_XN_09N203W_6     1        0       1 -2250.549072  1572.788086   \n",
       "P20_008845_1894_XN_09N203W_6     1        0       3 -3378.000000  1532.000000   \n",
       "P20_008845_1894_XN_09N203W_6     1        0       1  2367.587646 -1849.272095   \n",
       "P20_008845_1894_XN_09N203W_6     1        0       1  2675.137207 -1730.558105   \n",
       "P20_008845_1894_XN_09N203W_7     1        0       1 -2249.931396  1712.971436   \n",
       "P20_008845_1894_XN_09N203W_7     1        0       3 -3378.000000  1672.000000   \n",
       "P20_008845_1894_XN_09N203W_7     1        0       1  2367.507813 -1706.241821   \n",
       "P20_008845_1894_XN_09N203W_7     1        0       1  2675.892578 -1596.527100   \n",
       "P20_008845_1894_XN_09N203W_8     1        0       1 -1664.131104  1875.622437   \n",
       "P20_008845_1894_XN_09N203W_8     1        0       3 -2793.000000  1837.000000   \n",
       "P20_008845_1894_XN_09N203W_8     1        0       1  2953.094727 -1538.956543   \n",
       "P20_008845_1894_XN_09N203W_8     1        0       1  3261.290039 -1439.873169   \n",
       "P20_008845_1894_XN_09N203W_9     1        0       1   332.072113 -2045.152222   \n",
       "P20_008845_1894_XN_09N203W_9     1        0       0  -780.000000 -1953.000000   \n",
       "P20_008845_1894_XN_09N203W_9     1        0       0 -2866.689453  1031.006104   \n",
       "P20_008845_1894_XN_09N203W_9     1        0       0 -2002.366211   824.604126   \n",
       "\n",
       "                                  sig_l     sig_s     res_l     res_s  fid_x  \\\n",
       "10_8344_8845_4r                0.000000  0.000000  0.059914  0.930311    0.0   \n",
       "10_8344_8845_4r                0.000000  0.000000  0.063678  0.661294    0.0   \n",
       "10_8344_8845_4r                0.000000  0.000000 -0.063695 -1.055619    0.0   \n",
       "10_8344_8845_4r                0.000000  0.000000  0.318779 -0.585138    0.0   \n",
       "11_8344_8845_4r                0.000000  0.000000 -0.239226 -1.113693    0.0   \n",
       "11_8344_8845_4r                0.000000  0.000000 -0.247307 -0.587299    0.0   \n",
       "11_8344_8845_4r                0.000000  0.000000  0.239207  1.080801    0.0   \n",
       "11_8344_8845_4r                0.000000  0.000000  0.672877  0.626316    0.0   \n",
       "12_8344_8845_4r                0.000000  0.000000  0.073683 -0.237114    0.0   \n",
       "12_8344_8845_4r                0.000000  0.000000 -0.251753  0.008170    0.0   \n",
       "12_8344_8845_4r                0.000000  0.000000  0.133406  0.068024    0.0   \n",
       "12_8344_8845_4r                0.000000  0.000000  0.487209  0.036399    0.0   \n",
       "13_8344_8845_4r                0.000000  0.000000 -0.056901 -0.383259    0.0   \n",
       "13_8344_8845_4r                0.000000  0.000000 -0.131265 -0.305102    0.0   \n",
       "13_8344_8845_4r                0.000000  0.000000  0.019201  0.485372    0.0   \n",
       "13_8344_8845_4r                0.000000  0.000000  0.568393  0.146750    0.0   \n",
       "14_8344_8845_4r                0.000000  0.000000  0.268449  1.000455    0.0   \n",
       "14_8344_8845_4r                0.000000  0.000000  0.389532 -0.299258    0.0   \n",
       "14_8344_8845_4r                0.000000  0.000000 -0.469784  0.023018    0.0   \n",
       "14_8344_8845_4r                0.000000  0.000000  0.289877 -0.829150    0.0   \n",
       "15_8344_8845_4r_mt_z           0.000000  0.000000  0.466921  1.168062    0.0   \n",
       "15_8344_8845_4r_mt_z           0.000000  0.000000 -0.170850  0.372485    0.0   \n",
       "15_8344_8845_4r_mt_z           0.000000  0.000000 -0.072035 -0.832436    0.0   \n",
       "15_8344_8845_4r_mt_z           0.000000  0.000000  0.274030 -0.850105    0.0   \n",
       "16_8344_8845_4r                0.000000  0.000000 -0.028473 -0.238015    0.0   \n",
       "16_8344_8845_4r                0.000000  0.000000  0.165338 -0.327408    0.0   \n",
       "16_8344_8845_4r                0.000000  0.000000 -0.007916  0.463232    0.0   \n",
       "16_8344_8845_4r                0.000000  0.000000  0.328896  0.019526    0.0   \n",
       "17_8344_8845_2r_mt_z           0.000000  0.000000  0.010045  0.244017    0.0   \n",
       "17_8344_8845_2r_mt_z           0.000000  0.000000 -0.023370 -0.248643    0.0   \n",
       "...                                 ...       ...       ...       ...    ...   \n",
       "P20_008845_1894_XN_09N203W_18  0.022017  0.022017  0.734173 -0.074947    0.0   \n",
       "P20_008845_1894_XN_09N203W_2   0.144273  0.144273 -0.061422 -0.263554    0.0   \n",
       "P20_008845_1894_XN_09N203W_2   0.000000  0.000000 -0.073150 -0.271173    0.0   \n",
       "P20_008845_1894_XN_09N203W_2   0.275627  0.275627  0.164525  0.349547    0.0   \n",
       "P20_008845_1894_XN_09N203W_2   0.091086  0.091086  0.132736  0.239899    0.0   \n",
       "P20_008845_1894_XN_09N203W_3   0.062058  0.062058 -0.198696 -0.105860    0.0   \n",
       "P20_008845_1894_XN_09N203W_3   0.000000  0.000000 -0.088180 -0.049593    0.0   \n",
       "P20_008845_1894_XN_09N203W_3   0.132941  0.132941  0.257260  0.117777    0.0   \n",
       "P20_008845_1894_XN_09N203W_3   0.185544  0.185544  0.199301  0.065777    0.0   \n",
       "P20_008845_1894_XN_09N203W_4   0.146920  0.146920  0.182557 -0.000683    0.0   \n",
       "P20_008845_1894_XN_09N203W_4   0.000000  0.000000 -0.195774 -0.000066    0.0   \n",
       "P20_008845_1894_XN_09N203W_5   0.019047  0.019047 -0.235171 -0.174079    0.0   \n",
       "P20_008845_1894_XN_09N203W_5   0.000000  0.000000 -0.049005  0.437424    0.0   \n",
       "P20_008845_1894_XN_09N203W_5   0.000000  0.000000  0.447100 -0.219764    0.0   \n",
       "P20_008845_1894_XN_09N203W_6   0.025015  0.025015 -0.146990  0.192274    0.0   \n",
       "P20_008845_1894_XN_09N203W_6   0.000000  0.000000  0.026541  0.063346    0.0   \n",
       "P20_008845_1894_XN_09N203W_6   0.025110  0.025110 -0.040890 -0.136247    0.0   \n",
       "P20_008845_1894_XN_09N203W_6   0.064276  0.064276  0.546035 -0.185103    0.0   \n",
       "P20_008845_1894_XN_09N203W_7   0.010596  0.010596 -0.102909  0.079389    0.0   \n",
       "P20_008845_1894_XN_09N203W_7   0.000000  0.000000  0.055623  0.013456    0.0   \n",
       "P20_008845_1894_XN_09N203W_7   0.047435  0.047435 -0.157931 -0.042074    0.0   \n",
       "P20_008845_1894_XN_09N203W_7   0.058218  0.058218  0.589561 -0.111421    0.0   \n",
       "P20_008845_1894_XN_09N203W_8   0.017266  0.017266 -0.239689 -0.402891    0.0   \n",
       "P20_008845_1894_XN_09N203W_8   0.000000  0.000000 -0.117483 -0.229337    0.0   \n",
       "P20_008845_1894_XN_09N203W_8   0.023364  0.023364  0.177406  0.403161    0.0   \n",
       "P20_008845_1894_XN_09N203W_8   0.023538  0.023538  0.575510  0.180705    0.0   \n",
       "P20_008845_1894_XN_09N203W_9   0.232865  0.232865  0.095817 -0.483899    0.0   \n",
       "P20_008845_1894_XN_09N203W_9   0.000000  0.000000  0.298743 -0.045963    0.0   \n",
       "P20_008845_1894_XN_09N203W_9   0.000000  0.000000 -0.038437  0.471309    0.0   \n",
       "P20_008845_1894_XN_09N203W_9   0.397616  0.397616 -0.141172  0.105223    0.0   \n",
       "\n",
       "                                  ...      known lat_Y_North  long_X_East  \\\n",
       "10_8344_8845_4r                   ...          0    0.159378     2.724649   \n",
       "10_8344_8845_4r                   ...          0    0.159378     2.724649   \n",
       "10_8344_8845_4r                   ...          0    0.159378     2.724649   \n",
       "10_8344_8845_4r                   ...          0    0.159378     2.724649   \n",
       "11_8344_8845_4r                   ...          0    0.164905     2.721815   \n",
       "11_8344_8845_4r                   ...          0    0.164905     2.721815   \n",
       "11_8344_8845_4r                   ...          0    0.164905     2.721815   \n",
       "11_8344_8845_4r                   ...          0    0.164905     2.721815   \n",
       "12_8344_8845_4r                   ...          0    0.164949     2.724076   \n",
       "12_8344_8845_4r                   ...          0    0.164949     2.724076   \n",
       "12_8344_8845_4r                   ...          0    0.164949     2.724076   \n",
       "12_8344_8845_4r                   ...          0    0.164949     2.724076   \n",
       "13_8344_8845_4r                   ...          0    0.161840     2.723059   \n",
       "13_8344_8845_4r                   ...          0    0.161840     2.723059   \n",
       "13_8344_8845_4r                   ...          0    0.161840     2.723059   \n",
       "13_8344_8845_4r                   ...          0    0.161840     2.723059   \n",
       "14_8344_8845_4r                   ...          0    0.170415     2.720880   \n",
       "14_8344_8845_4r                   ...          0    0.170415     2.720880   \n",
       "14_8344_8845_4r                   ...          0    0.170415     2.720880   \n",
       "14_8344_8845_4r                   ...          0    0.170415     2.720880   \n",
       "15_8344_8845_4r_mt_z              ...          1    0.170723     2.723266   \n",
       "15_8344_8845_4r_mt_z              ...          1    0.170723     2.723266   \n",
       "15_8344_8845_4r_mt_z              ...          1    0.170723     2.723266   \n",
       "15_8344_8845_4r_mt_z              ...          1    0.170723     2.723266   \n",
       "16_8344_8845_4r                   ...          0    0.167682     2.722359   \n",
       "16_8344_8845_4r                   ...          0    0.167682     2.722359   \n",
       "16_8344_8845_4r                   ...          0    0.167682     2.722359   \n",
       "16_8344_8845_4r                   ...          0    0.167682     2.722359   \n",
       "17_8344_8845_2r_mt_z              ...          1    0.161092     2.725426   \n",
       "17_8344_8845_2r_mt_z              ...          1    0.161092     2.725426   \n",
       "...                               ...        ...         ...          ...   \n",
       "P20_008845_1894_XN_09N203W_18     ...          0    0.171455     2.722281   \n",
       "P20_008845_1894_XN_09N203W_2      ...          0    0.161184     2.729925   \n",
       "P20_008845_1894_XN_09N203W_2      ...          0    0.161184     2.729925   \n",
       "P20_008845_1894_XN_09N203W_2      ...          0    0.161184     2.729925   \n",
       "P20_008845_1894_XN_09N203W_2      ...          0    0.161184     2.729925   \n",
       "P20_008845_1894_XN_09N203W_3      ...          0    0.161992     2.729563   \n",
       "P20_008845_1894_XN_09N203W_3      ...          0    0.161992     2.729563   \n",
       "P20_008845_1894_XN_09N203W_3      ...          0    0.161992     2.729563   \n",
       "P20_008845_1894_XN_09N203W_3      ...          0    0.161992     2.729563   \n",
       "P20_008845_1894_XN_09N203W_4      ...          0    0.160994     2.725912   \n",
       "P20_008845_1894_XN_09N203W_4      ...          0    0.160994     2.725912   \n",
       "P20_008845_1894_XN_09N203W_5      ...          0    0.161544     2.726149   \n",
       "P20_008845_1894_XN_09N203W_5      ...          0    0.161544     2.726149   \n",
       "P20_008845_1894_XN_09N203W_5      ...          0    0.161544     2.726149   \n",
       "P20_008845_1894_XN_09N203W_6      ...          0    0.160447     2.723639   \n",
       "P20_008845_1894_XN_09N203W_6      ...          0    0.160447     2.723639   \n",
       "P20_008845_1894_XN_09N203W_6      ...          0    0.160447     2.723639   \n",
       "P20_008845_1894_XN_09N203W_6      ...          0    0.160447     2.723639   \n",
       "P20_008845_1894_XN_09N203W_7      ...          0    0.160419     2.723407   \n",
       "P20_008845_1894_XN_09N203W_7      ...          0    0.160419     2.723407   \n",
       "P20_008845_1894_XN_09N203W_7      ...          0    0.160419     2.723407   \n",
       "P20_008845_1894_XN_09N203W_7      ...          0    0.160419     2.723407   \n",
       "P20_008845_1894_XN_09N203W_8      ...          0    0.161417     2.723012   \n",
       "P20_008845_1894_XN_09N203W_8      ...          0    0.161417     2.723012   \n",
       "P20_008845_1894_XN_09N203W_8      ...          0    0.161417     2.723012   \n",
       "P20_008845_1894_XN_09N203W_8      ...          0    0.161417     2.723012   \n",
       "P20_008845_1894_XN_09N203W_9      ...          0    0.165741     2.729053   \n",
       "P20_008845_1894_XN_09N203W_9      ...          0    0.165741     2.729053   \n",
       "P20_008845_1894_XN_09N203W_9      ...          0    0.165741     2.729053   \n",
       "P20_008845_1894_XN_09N203W_9      ...          0    0.165741     2.729053   \n",
       "\n",
       "                                        ht  sig0  sig1        sig2       res0  \\\n",
       "10_8344_8845_4r               -2523.828227   0.0   0.0   25.000000  18.301328   \n",
       "10_8344_8845_4r               -2523.828227   0.0   0.0   25.000000  18.301328   \n",
       "10_8344_8845_4r               -2523.828227   0.0   0.0   25.000000  18.301328   \n",
       "10_8344_8845_4r               -2523.828227   0.0   0.0   25.000000  18.301328   \n",
       "11_8344_8845_4r               -2445.237027   0.0   0.0   30.000000 -22.046575   \n",
       "11_8344_8845_4r               -2445.237027   0.0   0.0   30.000000 -22.046575   \n",
       "11_8344_8845_4r               -2445.237027   0.0   0.0   30.000000 -22.046575   \n",
       "11_8344_8845_4r               -2445.237027   0.0   0.0   30.000000 -22.046575   \n",
       "12_8344_8845_4r               -2606.935163   0.0   0.0  100.000000  -7.549561   \n",
       "12_8344_8845_4r               -2606.935163   0.0   0.0  100.000000  -7.549561   \n",
       "12_8344_8845_4r               -2606.935163   0.0   0.0  100.000000  -7.549561   \n",
       "12_8344_8845_4r               -2606.935163   0.0   0.0  100.000000  -7.549561   \n",
       "13_8344_8845_4r               -2551.901554   0.0   0.0    4.536068  -1.643694   \n",
       "13_8344_8845_4r               -2551.901554   0.0   0.0    4.536068  -1.643694   \n",
       "13_8344_8845_4r               -2551.901554   0.0   0.0    4.536068  -1.643694   \n",
       "13_8344_8845_4r               -2551.901554   0.0   0.0    4.536068  -1.643694   \n",
       "14_8344_8845_4r               -2505.953426   0.0   0.0    5.000000 -50.069808   \n",
       "14_8344_8845_4r               -2505.953426   0.0   0.0    5.000000 -50.069808   \n",
       "14_8344_8845_4r               -2505.953426   0.0   0.0    5.000000 -50.069808   \n",
       "14_8344_8845_4r               -2505.953426   0.0   0.0    5.000000 -50.069808   \n",
       "15_8344_8845_4r_mt_z          -2502.470000   0.0   0.0    5.000000 -34.817656   \n",
       "15_8344_8845_4r_mt_z          -2502.470000   0.0   0.0    5.000000 -34.817656   \n",
       "15_8344_8845_4r_mt_z          -2502.470000   0.0   0.0    5.000000 -34.817656   \n",
       "15_8344_8845_4r_mt_z          -2502.470000   0.0   0.0    5.000000 -34.817656   \n",
       "16_8344_8845_4r               -2558.312931   0.0   0.0    1.707214 -29.465246   \n",
       "16_8344_8845_4r               -2558.312931   0.0   0.0    1.707214 -29.465246   \n",
       "16_8344_8845_4r               -2558.312931   0.0   0.0    1.707214 -29.465246   \n",
       "16_8344_8845_4r               -2558.312931   0.0   0.0    1.707214 -29.465246   \n",
       "17_8344_8845_2r_mt_z          -2590.130000   0.0   0.0    2.000000 -10.779830   \n",
       "17_8344_8845_2r_mt_z          -2590.130000   0.0   0.0    2.000000 -10.779830   \n",
       "...                                    ...   ...   ...         ...        ...   \n",
       "P20_008845_1894_XN_09N203W_18 -2514.431453   0.0   0.0    0.000000 -38.388316   \n",
       "P20_008845_1894_XN_09N203W_2  -2535.712262   0.0   0.0    0.000000  42.067289   \n",
       "P20_008845_1894_XN_09N203W_2  -2535.712262   0.0   0.0    0.000000  42.067289   \n",
       "P20_008845_1894_XN_09N203W_2  -2535.712262   0.0   0.0    0.000000  42.067289   \n",
       "P20_008845_1894_XN_09N203W_2  -2535.712262   0.0   0.0    0.000000  42.067289   \n",
       "P20_008845_1894_XN_09N203W_3  -2525.215515   0.0   0.0    0.000000  36.033823   \n",
       "P20_008845_1894_XN_09N203W_3  -2525.215515   0.0   0.0    0.000000  36.033823   \n",
       "P20_008845_1894_XN_09N203W_3  -2525.215515   0.0   0.0    0.000000  36.033823   \n",
       "P20_008845_1894_XN_09N203W_3  -2525.215515   0.0   0.0    0.000000  36.033823   \n",
       "P20_008845_1894_XN_09N203W_4  -2562.446851   0.0   0.0    0.000000  -7.233876   \n",
       "P20_008845_1894_XN_09N203W_4  -2562.446851   0.0   0.0    0.000000  -7.233876   \n",
       "P20_008845_1894_XN_09N203W_5  -2560.812028   0.0   0.0    0.000000   7.498790   \n",
       "P20_008845_1894_XN_09N203W_5  -2560.812028   0.0   0.0    0.000000   7.498790   \n",
       "P20_008845_1894_XN_09N203W_5  -2560.812028   0.0   0.0    0.000000   7.498790   \n",
       "P20_008845_1894_XN_09N203W_6  -2605.266130   0.0   0.0    0.000000   7.687475   \n",
       "P20_008845_1894_XN_09N203W_6  -2605.266130   0.0   0.0    0.000000   7.687475   \n",
       "P20_008845_1894_XN_09N203W_6  -2605.266130   0.0   0.0    0.000000   7.687475   \n",
       "P20_008845_1894_XN_09N203W_6  -2605.266130   0.0   0.0    0.000000   7.687475   \n",
       "P20_008845_1894_XN_09N203W_7  -2619.498291   0.0   0.0    0.000000   6.358447   \n",
       "P20_008845_1894_XN_09N203W_7  -2619.498291   0.0   0.0    0.000000   6.358447   \n",
       "P20_008845_1894_XN_09N203W_7  -2619.498291   0.0   0.0    0.000000   6.358447   \n",
       "P20_008845_1894_XN_09N203W_7  -2619.498291   0.0   0.0    0.000000   6.358447   \n",
       "P20_008845_1894_XN_09N203W_8  -2608.028730   0.0   0.0    0.000000  -0.219662   \n",
       "P20_008845_1894_XN_09N203W_8  -2608.028730   0.0   0.0    0.000000  -0.219662   \n",
       "P20_008845_1894_XN_09N203W_8  -2608.028730   0.0   0.0    0.000000  -0.219662   \n",
       "P20_008845_1894_XN_09N203W_8  -2608.028730   0.0   0.0    0.000000  -0.219662   \n",
       "P20_008845_1894_XN_09N203W_9  -2586.686862   0.0   0.0    0.000000  15.191825   \n",
       "P20_008845_1894_XN_09N203W_9  -2586.686862   0.0   0.0    0.000000  15.191825   \n",
       "P20_008845_1894_XN_09N203W_9  -2586.686862   0.0   0.0    0.000000  15.191825   \n",
       "P20_008845_1894_XN_09N203W_9  -2586.686862   0.0   0.0    0.000000  15.191825   \n",
       "\n",
       "                                     res1        res2  \n",
       "10_8344_8845_4r                 44.206259  416.201741  \n",
       "10_8344_8845_4r                 44.206259  416.201741  \n",
       "10_8344_8845_4r                 44.206259  416.201741  \n",
       "10_8344_8845_4r                 44.206259  416.201741  \n",
       "11_8344_8845_4r                103.403228  173.210013  \n",
       "11_8344_8845_4r                103.403228  173.210013  \n",
       "11_8344_8845_4r                103.403228  173.210013  \n",
       "11_8344_8845_4r                103.403228  173.210013  \n",
       "12_8344_8845_4r                 93.170584  180.058858  \n",
       "12_8344_8845_4r                 93.170584  180.058858  \n",
       "12_8344_8845_4r                 93.170584  180.058858  \n",
       "12_8344_8845_4r                 93.170584  180.058858  \n",
       "13_8344_8845_4r                 74.244153  319.554535  \n",
       "13_8344_8845_4r                 74.244153  319.554535  \n",
       "13_8344_8845_4r                 74.244153  319.554535  \n",
       "13_8344_8845_4r                 74.244153  319.554535  \n",
       "14_8344_8845_4r                144.316524 -164.540707  \n",
       "14_8344_8845_4r                144.316524 -164.540707  \n",
       "14_8344_8845_4r                144.316524 -164.540707  \n",
       "14_8344_8845_4r                144.316524 -164.540707  \n",
       "15_8344_8845_4r_mt_z           145.864550    0.214023  \n",
       "15_8344_8845_4r_mt_z           145.864550    0.214023  \n",
       "15_8344_8845_4r_mt_z           145.864550    0.214023  \n",
       "15_8344_8845_4r_mt_z           145.864550    0.214023  \n",
       "16_8344_8845_4r                121.908506   19.874949  \n",
       "16_8344_8845_4r                121.908506   19.874949  \n",
       "16_8344_8845_4r                121.908506   19.874949  \n",
       "16_8344_8845_4r                121.908506   19.874949  \n",
       "17_8344_8845_2r_mt_z            38.761214    0.236077  \n",
       "17_8344_8845_2r_mt_z            38.761214    0.236077  \n",
       "...                                   ...         ...  \n",
       "P20_008845_1894_XN_09N203W_18  195.050373 -391.289238  \n",
       "P20_008845_1894_XN_09N203W_2   -12.658160  627.742625  \n",
       "P20_008845_1894_XN_09N203W_2   -12.658160  627.742625  \n",
       "P20_008845_1894_XN_09N203W_2   -12.658160  627.742625  \n",
       "P20_008845_1894_XN_09N203W_2   -12.658160  627.742625  \n",
       "P20_008845_1894_XN_09N203W_3    -4.170818  616.480181  \n",
       "P20_008845_1894_XN_09N203W_3    -4.170818  616.480181  \n",
       "P20_008845_1894_XN_09N203W_3    -4.170818  616.480181  \n",
       "P20_008845_1894_XN_09N203W_3    -4.170818  616.480181  \n",
       "P20_008845_1894_XN_09N203W_4    33.324946  574.887719  \n",
       "P20_008845_1894_XN_09N203W_4    33.324946  574.887719  \n",
       "P20_008845_1894_XN_09N203W_5    33.109007  581.149470  \n",
       "P20_008845_1894_XN_09N203W_5    33.109007  581.149470  \n",
       "P20_008845_1894_XN_09N203W_5    33.109007  581.149470  \n",
       "P20_008845_1894_XN_09N203W_6    59.859663  375.680663  \n",
       "P20_008845_1894_XN_09N203W_6    59.859663  375.680663  \n",
       "P20_008845_1894_XN_09N203W_6    59.859663  375.680663  \n",
       "P20_008845_1894_XN_09N203W_6    59.859663  375.680663  \n",
       "P20_008845_1894_XN_09N203W_7    61.278242  375.840988  \n",
       "P20_008845_1894_XN_09N203W_7    61.278242  375.840988  \n",
       "P20_008845_1894_XN_09N203W_7    61.278242  375.840988  \n",
       "P20_008845_1894_XN_09N203W_7    61.278242  375.840988  \n",
       "P20_008845_1894_XN_09N203W_8    71.414267  336.409684  \n",
       "P20_008845_1894_XN_09N203W_8    71.414267  336.409684  \n",
       "P20_008845_1894_XN_09N203W_8    71.414267  336.409684  \n",
       "P20_008845_1894_XN_09N203W_8    71.414267  336.409684  \n",
       "P20_008845_1894_XN_09N203W_9    22.094037  544.874936  \n",
       "P20_008845_1894_XN_09N203W_9    22.094037  544.874936  \n",
       "P20_008845_1894_XN_09N203W_9    22.094037  544.874936  \n",
       "P20_008845_1894_XN_09N203W_9    22.094037  544.874936  \n",
       "\n",
       "[919 rows x 23 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "def sample_size(record):\n",
    "    \n",
    "    with open(atf_dict['PATH'] + '/' + record['ipf_file'] + '.sup') as f:\n",
    "        sample_num = 0\n",
    "        for i, line in enumerate(f):\n",
    "            if i == 4:\n",
    "                sample_num = line.split(' ')\n",
    "                sample_num = sample_num[-1].strip()\n",
    "                break\n",
    "        assert int(sample_num) > 0, \"Sample number {} from {} is a negative number: Invalid Data\".format(sample_num, record['ipf_file'])\n",
    "            \n",
    "        sample_num = int(sample_num)/2.0 + record['s.'] + 1\n",
    "        return sample_num\n",
    "\n",
    "def line_size(record):\n",
    "    \n",
    "    with open(atf_dict['PATH'] + '/' + record['ipf_file'] + '.sup') as f:\n",
    "        sample_num = 0\n",
    "        for i, line in enumerate(f):\n",
    "            if i == 3:\n",
    "                sample_num = line.split(' ')\n",
    "                sample_num = sample_num[-1].strip()\n",
    "                break\n",
    "        assert int(sample_num) > 0, \"Sample number {} from {} is a negative number: Invalid Data\".format(sample_num, record['ipf_file'])\n",
    "            \n",
    "        sample_num = int(sample_num)/2.0 + record['l.'] + 1\n",
    "        return sample_num\n",
    "\n",
    "def known(record):\n",
    "    if record['known'] == 0:\n",
    "        return 'Free'\n",
    "    \n",
    "    elif record['known'] == 1 or record['known'] == 2 or record['known'] == 3:\n",
    "        return 'Constrained'\n",
    "    \n",
    "# new_df['s.'] = new_df.apply(sample_size, axis=1)\n",
    "# new_df['l.'] = new_df.apply(line_size, axis=1)\n",
    "# new_df['known'] = new_df.apply(known, axis=1)\n",
    "display(new_df)\n",
    "# cmeas->SetCoordinate(img_samples/2.0+sample+1,img_lines/2.0+line+1);"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n",
      "Error in oc2og conversion\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n",
      "inf\n"
     ]
    },
    {
     "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>val</th>\n",
       "      <th>fid_val</th>\n",
       "      <th>no_obs</th>\n",
       "      <th>l.</th>\n",
       "      <th>s.</th>\n",
       "      <th>sig_l</th>\n",
       "      <th>sig_s</th>\n",
       "      <th>res_l</th>\n",
       "      <th>res_s</th>\n",
       "      <th>fid_x</th>\n",
       "      <th>...</th>\n",
       "      <th>known</th>\n",
       "      <th>lat_Y_North</th>\n",
       "      <th>long_X_East</th>\n",
       "      <th>ht</th>\n",
       "      <th>sig0</th>\n",
       "      <th>sig1</th>\n",
       "      <th>sig2</th>\n",
       "      <th>res0</th>\n",
       "      <th>res1</th>\n",
       "      <th>res2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-2919.380615</td>\n",
       "      <td>1052.729004</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.059914</td>\n",
       "      <td>0.930311</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2523.828227</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>18.301328</td>\n",
       "      <td>44.206259</td>\n",
       "      <td>416.201741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-4044.697510</td>\n",
       "      <td>1008.950928</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.063678</td>\n",
       "      <td>0.661294</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2523.828227</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>18.301328</td>\n",
       "      <td>44.206259</td>\n",
       "      <td>416.201741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1700.584473</td>\n",
       "      <td>-2390.001709</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.063695</td>\n",
       "      <td>-1.055619</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2523.828227</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>18.301328</td>\n",
       "      <td>44.206259</td>\n",
       "      <td>416.201741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2006.141113</td>\n",
       "      <td>-2234.915283</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.318779</td>\n",
       "      <td>-0.585138</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2523.828227</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>18.301328</td>\n",
       "      <td>44.206259</td>\n",
       "      <td>416.201741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>370.151917</td>\n",
       "      <td>2340.653076</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.239226</td>\n",
       "      <td>-1.113693</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2445.237027</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>-22.046575</td>\n",
       "      <td>103.403228</td>\n",
       "      <td>173.210013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-761.216064</td>\n",
       "      <td>2303.787109</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.247307</td>\n",
       "      <td>-0.587299</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2445.237027</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>-22.046575</td>\n",
       "      <td>103.403228</td>\n",
       "      <td>173.210013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4985.437988</td>\n",
       "      <td>-1070.364990</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.239207</td>\n",
       "      <td>1.080801</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2445.237027</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>-22.046575</td>\n",
       "      <td>103.403228</td>\n",
       "      <td>173.210013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5293.700195</td>\n",
       "      <td>-993.390625</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.672877</td>\n",
       "      <td>0.626316</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2445.237027</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>-22.046575</td>\n",
       "      <td>103.403228</td>\n",
       "      <td>173.210013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>236.395218</td>\n",
       "      <td>984.833252</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.073683</td>\n",
       "      <td>-0.237114</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2606.935163</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>-7.549561</td>\n",
       "      <td>93.170584</td>\n",
       "      <td>180.058858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-889.364441</td>\n",
       "      <td>966.533997</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.251753</td>\n",
       "      <td>0.008170</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2606.935163</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>-7.549561</td>\n",
       "      <td>93.170584</td>\n",
       "      <td>180.058858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4856.525391</td>\n",
       "      <td>-2439.154785</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.133406</td>\n",
       "      <td>0.068024</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2606.935163</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>-7.549561</td>\n",
       "      <td>93.170584</td>\n",
       "      <td>180.058858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5158.205566</td>\n",
       "      <td>-2295.737549</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.487209</td>\n",
       "      <td>0.036399</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2606.935163</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>-7.549561</td>\n",
       "      <td>93.170584</td>\n",
       "      <td>180.058858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-1431.023804</td>\n",
       "      <td>1817.888672</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.056901</td>\n",
       "      <td>-0.383259</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2551.901554</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.536068</td>\n",
       "      <td>-1.643694</td>\n",
       "      <td>74.244153</td>\n",
       "      <td>319.554535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-2559.871338</td>\n",
       "      <td>1777.522827</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.131265</td>\n",
       "      <td>-0.305102</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2551.901554</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.536068</td>\n",
       "      <td>-1.643694</td>\n",
       "      <td>74.244153</td>\n",
       "      <td>319.554535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3186.063232</td>\n",
       "      <td>-1598.743530</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.019201</td>\n",
       "      <td>0.485372</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2551.901554</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.536068</td>\n",
       "      <td>-1.643694</td>\n",
       "      <td>74.244153</td>\n",
       "      <td>319.554535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3493.876221</td>\n",
       "      <td>-1493.029175</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.568393</td>\n",
       "      <td>0.146750</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2551.901554</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.536068</td>\n",
       "      <td>-1.643694</td>\n",
       "      <td>74.244153</td>\n",
       "      <td>319.554535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3518.268066</td>\n",
       "      <td>2495.108643</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.268449</td>\n",
       "      <td>1.000455</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2505.953426</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>-50.069808</td>\n",
       "      <td>144.316524</td>\n",
       "      <td>-164.540707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2385.278320</td>\n",
       "      <td>2476.032227</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.389532</td>\n",
       "      <td>-0.299258</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2505.953426</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>-50.069808</td>\n",
       "      <td>144.316524</td>\n",
       "      <td>-164.540707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8131.361816</td>\n",
       "      <td>-902.645325</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.469784</td>\n",
       "      <td>0.023018</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2505.953426</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>-50.069808</td>\n",
       "      <td>144.316524</td>\n",
       "      <td>-164.540707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8437.115234</td>\n",
       "      <td>-842.309326</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.289877</td>\n",
       "      <td>-0.829150</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2505.953426</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>-50.069808</td>\n",
       "      <td>144.316524</td>\n",
       "      <td>-164.540707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15_8344_8845_4r_mt_z</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3522.998535</td>\n",
       "      <td>1049.406982</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.466921</td>\n",
       "      <td>1.168062</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2502.470000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>-34.817656</td>\n",
       "      <td>145.864550</td>\n",
       "      <td>0.214023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15_8344_8845_4r_mt_z</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2395.869385</td>\n",
       "      <td>1038.165405</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.170850</td>\n",
       "      <td>0.372485</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2502.470000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>-34.817656</td>\n",
       "      <td>145.864550</td>\n",
       "      <td>0.214023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15_8344_8845_4r_mt_z</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8142.054688</td>\n",
       "      <td>-2364.445557</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.072035</td>\n",
       "      <td>-0.832436</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2502.470000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>-34.817656</td>\n",
       "      <td>145.864550</td>\n",
       "      <td>0.214023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15_8344_8845_4r_mt_z</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8440.085938</td>\n",
       "      <td>-2219.049805</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.274030</td>\n",
       "      <td>-0.850105</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2502.470000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>-34.817656</td>\n",
       "      <td>145.864550</td>\n",
       "      <td>0.214023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1885.346313</td>\n",
       "      <td>1807.367065</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.028473</td>\n",
       "      <td>-0.238015</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2558.312931</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.707214</td>\n",
       "      <td>-29.465246</td>\n",
       "      <td>121.908506</td>\n",
       "      <td>19.874949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>756.099792</td>\n",
       "      <td>1785.494751</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.165338</td>\n",
       "      <td>-0.327408</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2558.312931</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.707214</td>\n",
       "      <td>-29.465246</td>\n",
       "      <td>121.908506</td>\n",
       "      <td>19.874949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6502.070313</td>\n",
       "      <td>-1593.964233</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.007916</td>\n",
       "      <td>0.463232</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2558.312931</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.707214</td>\n",
       "      <td>-29.465246</td>\n",
       "      <td>121.908506</td>\n",
       "      <td>19.874949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6805.896973</td>\n",
       "      <td>-1493.774048</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.328896</td>\n",
       "      <td>0.019526</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2558.312931</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.707214</td>\n",
       "      <td>-29.465246</td>\n",
       "      <td>121.908506</td>\n",
       "      <td>19.874949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17_8344_8845_2r_mt_z</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-2015.364380</td>\n",
       "      <td>465.268188</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.010045</td>\n",
       "      <td>0.244017</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2590.130000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>-10.779830</td>\n",
       "      <td>38.761214</td>\n",
       "      <td>0.236077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17_8344_8845_2r_mt_z</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-3138.269531</td>\n",
       "      <td>442.515503</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.023370</td>\n",
       "      <td>-0.248643</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2590.130000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>-10.779830</td>\n",
       "      <td>38.761214</td>\n",
       "      <td>0.236077</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",
       "      <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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_18</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8918.806641</td>\n",
       "      <td>-1701.755249</td>\n",
       "      <td>0.022017</td>\n",
       "      <td>0.022017</td>\n",
       "      <td>0.734173</td>\n",
       "      <td>-0.074947</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2514.431453</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-38.388316</td>\n",
       "      <td>195.050373</td>\n",
       "      <td>-391.289238</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_2</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-2277.691406</td>\n",
       "      <td>-2240.823486</td>\n",
       "      <td>0.144273</td>\n",
       "      <td>0.144273</td>\n",
       "      <td>-0.061422</td>\n",
       "      <td>-0.263554</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2535.712262</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>42.067289</td>\n",
       "      <td>-12.658160</td>\n",
       "      <td>627.742625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_2</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-3389.000000</td>\n",
       "      <td>-2155.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.073150</td>\n",
       "      <td>-0.271173</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2535.712262</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>42.067289</td>\n",
       "      <td>-12.658160</td>\n",
       "      <td>627.742625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_2</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-5474.326660</td>\n",
       "      <td>842.207031</td>\n",
       "      <td>0.275627</td>\n",
       "      <td>0.275627</td>\n",
       "      <td>0.164525</td>\n",
       "      <td>0.349547</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2535.712262</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>42.067289</td>\n",
       "      <td>-12.658160</td>\n",
       "      <td>627.742625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_2</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-4613.785645</td>\n",
       "      <td>643.217224</td>\n",
       "      <td>0.091086</td>\n",
       "      <td>0.091086</td>\n",
       "      <td>0.132736</td>\n",
       "      <td>0.239899</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2535.712262</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>42.067289</td>\n",
       "      <td>-12.658160</td>\n",
       "      <td>627.742625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_3</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-1801.096436</td>\n",
       "      <td>-2078.479004</td>\n",
       "      <td>0.062058</td>\n",
       "      <td>0.062058</td>\n",
       "      <td>-0.198696</td>\n",
       "      <td>-0.105860</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2525.215515</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>36.033823</td>\n",
       "      <td>-4.170818</td>\n",
       "      <td>616.480181</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_3</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-2913.000000</td>\n",
       "      <td>-2000.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.088180</td>\n",
       "      <td>-0.049593</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2525.215515</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>36.033823</td>\n",
       "      <td>-4.170818</td>\n",
       "      <td>616.480181</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_3</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-4997.791504</td>\n",
       "      <td>1000.375854</td>\n",
       "      <td>0.132941</td>\n",
       "      <td>0.132941</td>\n",
       "      <td>0.257260</td>\n",
       "      <td>0.117777</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2525.215515</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>36.033823</td>\n",
       "      <td>-4.170818</td>\n",
       "      <td>616.480181</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_3</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-4137.536133</td>\n",
       "      <td>774.480347</td>\n",
       "      <td>0.185544</td>\n",
       "      <td>0.185544</td>\n",
       "      <td>0.199301</td>\n",
       "      <td>0.065777</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2525.215515</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>36.033823</td>\n",
       "      <td>-4.170818</td>\n",
       "      <td>616.480181</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_4</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-2103.971680</td>\n",
       "      <td>184.334869</td>\n",
       "      <td>0.146920</td>\n",
       "      <td>0.146920</td>\n",
       "      <td>0.182557</td>\n",
       "      <td>-0.000683</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2562.446851</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-7.233876</td>\n",
       "      <td>33.324946</td>\n",
       "      <td>574.887719</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_4</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-3226.000000</td>\n",
       "      <td>167.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.195774</td>\n",
       "      <td>-0.000066</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2562.446851</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-7.233876</td>\n",
       "      <td>33.324946</td>\n",
       "      <td>574.887719</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_5</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-1813.285278</td>\n",
       "      <td>3.928788</td>\n",
       "      <td>0.019047</td>\n",
       "      <td>0.019047</td>\n",
       "      <td>-0.235171</td>\n",
       "      <td>-0.174079</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2560.812028</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7.498790</td>\n",
       "      <td>33.109007</td>\n",
       "      <td>581.149470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_5</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-2934.000000</td>\n",
       "      <td>-6.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.049005</td>\n",
       "      <td>0.437424</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2560.812028</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7.498790</td>\n",
       "      <td>33.109007</td>\n",
       "      <td>581.149470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_5</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-4165.228516</td>\n",
       "      <td>2507.076660</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.447100</td>\n",
       "      <td>-0.219764</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2560.812028</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7.498790</td>\n",
       "      <td>33.109007</td>\n",
       "      <td>581.149470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_6</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-2250.549072</td>\n",
       "      <td>1572.788086</td>\n",
       "      <td>0.025015</td>\n",
       "      <td>0.025015</td>\n",
       "      <td>-0.146990</td>\n",
       "      <td>0.192274</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2605.266130</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7.687475</td>\n",
       "      <td>59.859663</td>\n",
       "      <td>375.680663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_6</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>-3378.000000</td>\n",
       "      <td>1532.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.026541</td>\n",
       "      <td>0.063346</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2605.266130</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7.687475</td>\n",
       "      <td>59.859663</td>\n",
       "      <td>375.680663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_6</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2367.587646</td>\n",
       "      <td>-1849.272095</td>\n",
       "      <td>0.025110</td>\n",
       "      <td>0.025110</td>\n",
       "      <td>-0.040890</td>\n",
       "      <td>-0.136247</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2605.266130</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7.687475</td>\n",
       "      <td>59.859663</td>\n",
       "      <td>375.680663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_6</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2675.137207</td>\n",
       "      <td>-1730.558105</td>\n",
       "      <td>0.064276</td>\n",
       "      <td>0.064276</td>\n",
       "      <td>0.546035</td>\n",
       "      <td>-0.185103</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2605.266130</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7.687475</td>\n",
       "      <td>59.859663</td>\n",
       "      <td>375.680663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_7</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-2249.931396</td>\n",
       "      <td>1712.971436</td>\n",
       "      <td>0.010596</td>\n",
       "      <td>0.010596</td>\n",
       "      <td>-0.102909</td>\n",
       "      <td>0.079389</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2619.498291</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6.358447</td>\n",
       "      <td>61.278242</td>\n",
       "      <td>375.840988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_7</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>-3378.000000</td>\n",
       "      <td>1672.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.055623</td>\n",
       "      <td>0.013456</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2619.498291</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6.358447</td>\n",
       "      <td>61.278242</td>\n",
       "      <td>375.840988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_7</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2367.507813</td>\n",
       "      <td>-1706.241821</td>\n",
       "      <td>0.047435</td>\n",
       "      <td>0.047435</td>\n",
       "      <td>-0.157931</td>\n",
       "      <td>-0.042074</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2619.498291</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6.358447</td>\n",
       "      <td>61.278242</td>\n",
       "      <td>375.840988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_7</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2675.892578</td>\n",
       "      <td>-1596.527100</td>\n",
       "      <td>0.058218</td>\n",
       "      <td>0.058218</td>\n",
       "      <td>0.589561</td>\n",
       "      <td>-0.111421</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2619.498291</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6.358447</td>\n",
       "      <td>61.278242</td>\n",
       "      <td>375.840988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_8</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-1664.131104</td>\n",
       "      <td>1875.622437</td>\n",
       "      <td>0.017266</td>\n",
       "      <td>0.017266</td>\n",
       "      <td>-0.239689</td>\n",
       "      <td>-0.402891</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2608.028730</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.219662</td>\n",
       "      <td>71.414267</td>\n",
       "      <td>336.409684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_8</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>-2793.000000</td>\n",
       "      <td>1837.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.117483</td>\n",
       "      <td>-0.229337</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2608.028730</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.219662</td>\n",
       "      <td>71.414267</td>\n",
       "      <td>336.409684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_8</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2953.094727</td>\n",
       "      <td>-1538.956543</td>\n",
       "      <td>0.023364</td>\n",
       "      <td>0.023364</td>\n",
       "      <td>0.177406</td>\n",
       "      <td>0.403161</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2608.028730</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.219662</td>\n",
       "      <td>71.414267</td>\n",
       "      <td>336.409684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_8</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3261.290039</td>\n",
       "      <td>-1439.873169</td>\n",
       "      <td>0.023538</td>\n",
       "      <td>0.023538</td>\n",
       "      <td>0.575510</td>\n",
       "      <td>0.180705</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2608.028730</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.219662</td>\n",
       "      <td>71.414267</td>\n",
       "      <td>336.409684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_9</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>332.072113</td>\n",
       "      <td>-2045.152222</td>\n",
       "      <td>0.232865</td>\n",
       "      <td>0.232865</td>\n",
       "      <td>0.095817</td>\n",
       "      <td>-0.483899</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2586.686862</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>15.191825</td>\n",
       "      <td>22.094037</td>\n",
       "      <td>544.874936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_9</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-780.000000</td>\n",
       "      <td>-1953.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.298743</td>\n",
       "      <td>-0.045963</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2586.686862</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>15.191825</td>\n",
       "      <td>22.094037</td>\n",
       "      <td>544.874936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_9</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-2866.689453</td>\n",
       "      <td>1031.006104</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.038437</td>\n",
       "      <td>0.471309</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2586.686862</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>15.191825</td>\n",
       "      <td>22.094037</td>\n",
       "      <td>544.874936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_9</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-2002.366211</td>\n",
       "      <td>824.604126</td>\n",
       "      <td>0.397616</td>\n",
       "      <td>0.397616</td>\n",
       "      <td>-0.141172</td>\n",
       "      <td>0.105223</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>-2586.686862</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>15.191825</td>\n",
       "      <td>22.094037</td>\n",
       "      <td>544.874936</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>919 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                               val  fid_val  no_obs           l.           s.  \\\n",
       "10_8344_8845_4r                  1        0       0 -2919.380615  1052.729004   \n",
       "10_8344_8845_4r                  1        0       0 -4044.697510  1008.950928   \n",
       "10_8344_8845_4r                  1        0       0  1700.584473 -2390.001709   \n",
       "10_8344_8845_4r                  1        0       0  2006.141113 -2234.915283   \n",
       "11_8344_8845_4r                  1        0       0   370.151917  2340.653076   \n",
       "11_8344_8845_4r                  1        0       0  -761.216064  2303.787109   \n",
       "11_8344_8845_4r                  1        0       0  4985.437988 -1070.364990   \n",
       "11_8344_8845_4r                  1        0       0  5293.700195  -993.390625   \n",
       "12_8344_8845_4r                  1        0       0   236.395218   984.833252   \n",
       "12_8344_8845_4r                  1        0       0  -889.364441   966.533997   \n",
       "12_8344_8845_4r                  1        0       0  4856.525391 -2439.154785   \n",
       "12_8344_8845_4r                  1        0       0  5158.205566 -2295.737549   \n",
       "13_8344_8845_4r                  1        0       0 -1431.023804  1817.888672   \n",
       "13_8344_8845_4r                  1        0       0 -2559.871338  1777.522827   \n",
       "13_8344_8845_4r                  1        0       0  3186.063232 -1598.743530   \n",
       "13_8344_8845_4r                  1        0       0  3493.876221 -1493.029175   \n",
       "14_8344_8845_4r                  1        0       0  3518.268066  2495.108643   \n",
       "14_8344_8845_4r                  1        0       0  2385.278320  2476.032227   \n",
       "14_8344_8845_4r                  1        0       0  8131.361816  -902.645325   \n",
       "14_8344_8845_4r                  1        0       0  8437.115234  -842.309326   \n",
       "15_8344_8845_4r_mt_z             1        0       0  3522.998535  1049.406982   \n",
       "15_8344_8845_4r_mt_z             1        0       0  2395.869385  1038.165405   \n",
       "15_8344_8845_4r_mt_z             1        0       0  8142.054688 -2364.445557   \n",
       "15_8344_8845_4r_mt_z             1        0       0  8440.085938 -2219.049805   \n",
       "16_8344_8845_4r                  1        0       0  1885.346313  1807.367065   \n",
       "16_8344_8845_4r                  1        0       0   756.099792  1785.494751   \n",
       "16_8344_8845_4r                  1        0       0  6502.070313 -1593.964233   \n",
       "16_8344_8845_4r                  1        0       0  6805.896973 -1493.774048   \n",
       "17_8344_8845_2r_mt_z             1        0       0 -2015.364380   465.268188   \n",
       "17_8344_8845_2r_mt_z             1        0       0 -3138.269531   442.515503   \n",
       "...                            ...      ...     ...          ...          ...   \n",
       "P20_008845_1894_XN_09N203W_18    1        0       1  8918.806641 -1701.755249   \n",
       "P20_008845_1894_XN_09N203W_2     1        0       1 -2277.691406 -2240.823486   \n",
       "P20_008845_1894_XN_09N203W_2     1        0       0 -3389.000000 -2155.000000   \n",
       "P20_008845_1894_XN_09N203W_2     1        0       1 -5474.326660   842.207031   \n",
       "P20_008845_1894_XN_09N203W_2     1        0       0 -4613.785645   643.217224   \n",
       "P20_008845_1894_XN_09N203W_3     1        0       1 -1801.096436 -2078.479004   \n",
       "P20_008845_1894_XN_09N203W_3     1        0       0 -2913.000000 -2000.000000   \n",
       "P20_008845_1894_XN_09N203W_3     1        0       1 -4997.791504  1000.375854   \n",
       "P20_008845_1894_XN_09N203W_3     1        0       0 -4137.536133   774.480347   \n",
       "P20_008845_1894_XN_09N203W_4     1        0       1 -2103.971680   184.334869   \n",
       "P20_008845_1894_XN_09N203W_4     1        0       1 -3226.000000   167.000000   \n",
       "P20_008845_1894_XN_09N203W_5     1        0       1 -1813.285278     3.928788   \n",
       "P20_008845_1894_XN_09N203W_5     1        0       1 -2934.000000    -6.000000   \n",
       "P20_008845_1894_XN_09N203W_5     1        0       0 -4165.228516  2507.076660   \n",
       "P20_008845_1894_XN_09N203W_6     1        0       1 -2250.549072  1572.788086   \n",
       "P20_008845_1894_XN_09N203W_6     1        0       3 -3378.000000  1532.000000   \n",
       "P20_008845_1894_XN_09N203W_6     1        0       1  2367.587646 -1849.272095   \n",
       "P20_008845_1894_XN_09N203W_6     1        0       1  2675.137207 -1730.558105   \n",
       "P20_008845_1894_XN_09N203W_7     1        0       1 -2249.931396  1712.971436   \n",
       "P20_008845_1894_XN_09N203W_7     1        0       3 -3378.000000  1672.000000   \n",
       "P20_008845_1894_XN_09N203W_7     1        0       1  2367.507813 -1706.241821   \n",
       "P20_008845_1894_XN_09N203W_7     1        0       1  2675.892578 -1596.527100   \n",
       "P20_008845_1894_XN_09N203W_8     1        0       1 -1664.131104  1875.622437   \n",
       "P20_008845_1894_XN_09N203W_8     1        0       3 -2793.000000  1837.000000   \n",
       "P20_008845_1894_XN_09N203W_8     1        0       1  2953.094727 -1538.956543   \n",
       "P20_008845_1894_XN_09N203W_8     1        0       1  3261.290039 -1439.873169   \n",
       "P20_008845_1894_XN_09N203W_9     1        0       1   332.072113 -2045.152222   \n",
       "P20_008845_1894_XN_09N203W_9     1        0       0  -780.000000 -1953.000000   \n",
       "P20_008845_1894_XN_09N203W_9     1        0       0 -2866.689453  1031.006104   \n",
       "P20_008845_1894_XN_09N203W_9     1        0       0 -2002.366211   824.604126   \n",
       "\n",
       "                                  sig_l     sig_s     res_l     res_s  fid_x  \\\n",
       "10_8344_8845_4r                0.000000  0.000000  0.059914  0.930311    0.0   \n",
       "10_8344_8845_4r                0.000000  0.000000  0.063678  0.661294    0.0   \n",
       "10_8344_8845_4r                0.000000  0.000000 -0.063695 -1.055619    0.0   \n",
       "10_8344_8845_4r                0.000000  0.000000  0.318779 -0.585138    0.0   \n",
       "11_8344_8845_4r                0.000000  0.000000 -0.239226 -1.113693    0.0   \n",
       "11_8344_8845_4r                0.000000  0.000000 -0.247307 -0.587299    0.0   \n",
       "11_8344_8845_4r                0.000000  0.000000  0.239207  1.080801    0.0   \n",
       "11_8344_8845_4r                0.000000  0.000000  0.672877  0.626316    0.0   \n",
       "12_8344_8845_4r                0.000000  0.000000  0.073683 -0.237114    0.0   \n",
       "12_8344_8845_4r                0.000000  0.000000 -0.251753  0.008170    0.0   \n",
       "12_8344_8845_4r                0.000000  0.000000  0.133406  0.068024    0.0   \n",
       "12_8344_8845_4r                0.000000  0.000000  0.487209  0.036399    0.0   \n",
       "13_8344_8845_4r                0.000000  0.000000 -0.056901 -0.383259    0.0   \n",
       "13_8344_8845_4r                0.000000  0.000000 -0.131265 -0.305102    0.0   \n",
       "13_8344_8845_4r                0.000000  0.000000  0.019201  0.485372    0.0   \n",
       "13_8344_8845_4r                0.000000  0.000000  0.568393  0.146750    0.0   \n",
       "14_8344_8845_4r                0.000000  0.000000  0.268449  1.000455    0.0   \n",
       "14_8344_8845_4r                0.000000  0.000000  0.389532 -0.299258    0.0   \n",
       "14_8344_8845_4r                0.000000  0.000000 -0.469784  0.023018    0.0   \n",
       "14_8344_8845_4r                0.000000  0.000000  0.289877 -0.829150    0.0   \n",
       "15_8344_8845_4r_mt_z           0.000000  0.000000  0.466921  1.168062    0.0   \n",
       "15_8344_8845_4r_mt_z           0.000000  0.000000 -0.170850  0.372485    0.0   \n",
       "15_8344_8845_4r_mt_z           0.000000  0.000000 -0.072035 -0.832436    0.0   \n",
       "15_8344_8845_4r_mt_z           0.000000  0.000000  0.274030 -0.850105    0.0   \n",
       "16_8344_8845_4r                0.000000  0.000000 -0.028473 -0.238015    0.0   \n",
       "16_8344_8845_4r                0.000000  0.000000  0.165338 -0.327408    0.0   \n",
       "16_8344_8845_4r                0.000000  0.000000 -0.007916  0.463232    0.0   \n",
       "16_8344_8845_4r                0.000000  0.000000  0.328896  0.019526    0.0   \n",
       "17_8344_8845_2r_mt_z           0.000000  0.000000  0.010045  0.244017    0.0   \n",
       "17_8344_8845_2r_mt_z           0.000000  0.000000 -0.023370 -0.248643    0.0   \n",
       "...                                 ...       ...       ...       ...    ...   \n",
       "P20_008845_1894_XN_09N203W_18  0.022017  0.022017  0.734173 -0.074947    0.0   \n",
       "P20_008845_1894_XN_09N203W_2   0.144273  0.144273 -0.061422 -0.263554    0.0   \n",
       "P20_008845_1894_XN_09N203W_2   0.000000  0.000000 -0.073150 -0.271173    0.0   \n",
       "P20_008845_1894_XN_09N203W_2   0.275627  0.275627  0.164525  0.349547    0.0   \n",
       "P20_008845_1894_XN_09N203W_2   0.091086  0.091086  0.132736  0.239899    0.0   \n",
       "P20_008845_1894_XN_09N203W_3   0.062058  0.062058 -0.198696 -0.105860    0.0   \n",
       "P20_008845_1894_XN_09N203W_3   0.000000  0.000000 -0.088180 -0.049593    0.0   \n",
       "P20_008845_1894_XN_09N203W_3   0.132941  0.132941  0.257260  0.117777    0.0   \n",
       "P20_008845_1894_XN_09N203W_3   0.185544  0.185544  0.199301  0.065777    0.0   \n",
       "P20_008845_1894_XN_09N203W_4   0.146920  0.146920  0.182557 -0.000683    0.0   \n",
       "P20_008845_1894_XN_09N203W_4   0.000000  0.000000 -0.195774 -0.000066    0.0   \n",
       "P20_008845_1894_XN_09N203W_5   0.019047  0.019047 -0.235171 -0.174079    0.0   \n",
       "P20_008845_1894_XN_09N203W_5   0.000000  0.000000 -0.049005  0.437424    0.0   \n",
       "P20_008845_1894_XN_09N203W_5   0.000000  0.000000  0.447100 -0.219764    0.0   \n",
       "P20_008845_1894_XN_09N203W_6   0.025015  0.025015 -0.146990  0.192274    0.0   \n",
       "P20_008845_1894_XN_09N203W_6   0.000000  0.000000  0.026541  0.063346    0.0   \n",
       "P20_008845_1894_XN_09N203W_6   0.025110  0.025110 -0.040890 -0.136247    0.0   \n",
       "P20_008845_1894_XN_09N203W_6   0.064276  0.064276  0.546035 -0.185103    0.0   \n",
       "P20_008845_1894_XN_09N203W_7   0.010596  0.010596 -0.102909  0.079389    0.0   \n",
       "P20_008845_1894_XN_09N203W_7   0.000000  0.000000  0.055623  0.013456    0.0   \n",
       "P20_008845_1894_XN_09N203W_7   0.047435  0.047435 -0.157931 -0.042074    0.0   \n",
       "P20_008845_1894_XN_09N203W_7   0.058218  0.058218  0.589561 -0.111421    0.0   \n",
       "P20_008845_1894_XN_09N203W_8   0.017266  0.017266 -0.239689 -0.402891    0.0   \n",
       "P20_008845_1894_XN_09N203W_8   0.000000  0.000000 -0.117483 -0.229337    0.0   \n",
       "P20_008845_1894_XN_09N203W_8   0.023364  0.023364  0.177406  0.403161    0.0   \n",
       "P20_008845_1894_XN_09N203W_8   0.023538  0.023538  0.575510  0.180705    0.0   \n",
       "P20_008845_1894_XN_09N203W_9   0.232865  0.232865  0.095817 -0.483899    0.0   \n",
       "P20_008845_1894_XN_09N203W_9   0.000000  0.000000  0.298743 -0.045963    0.0   \n",
       "P20_008845_1894_XN_09N203W_9   0.000000  0.000000 -0.038437  0.471309    0.0   \n",
       "P20_008845_1894_XN_09N203W_9   0.397616  0.397616 -0.141172  0.105223    0.0   \n",
       "\n",
       "                                  ...      known lat_Y_North  long_X_East  \\\n",
       "10_8344_8845_4r                   ...          0         inf          inf   \n",
       "10_8344_8845_4r                   ...          0         inf          inf   \n",
       "10_8344_8845_4r                   ...          0         inf          inf   \n",
       "10_8344_8845_4r                   ...          0         inf          inf   \n",
       "11_8344_8845_4r                   ...          0         inf          inf   \n",
       "11_8344_8845_4r                   ...          0         inf          inf   \n",
       "11_8344_8845_4r                   ...          0         inf          inf   \n",
       "11_8344_8845_4r                   ...          0         inf          inf   \n",
       "12_8344_8845_4r                   ...          0         inf          inf   \n",
       "12_8344_8845_4r                   ...          0         inf          inf   \n",
       "12_8344_8845_4r                   ...          0         inf          inf   \n",
       "12_8344_8845_4r                   ...          0         inf          inf   \n",
       "13_8344_8845_4r                   ...          0         inf          inf   \n",
       "13_8344_8845_4r                   ...          0         inf          inf   \n",
       "13_8344_8845_4r                   ...          0         inf          inf   \n",
       "13_8344_8845_4r                   ...          0         inf          inf   \n",
       "14_8344_8845_4r                   ...          0         inf          inf   \n",
       "14_8344_8845_4r                   ...          0         inf          inf   \n",
       "14_8344_8845_4r                   ...          0         inf          inf   \n",
       "14_8344_8845_4r                   ...          0         inf          inf   \n",
       "15_8344_8845_4r_mt_z              ...          1         inf          inf   \n",
       "15_8344_8845_4r_mt_z              ...          1         inf          inf   \n",
       "15_8344_8845_4r_mt_z              ...          1         inf          inf   \n",
       "15_8344_8845_4r_mt_z              ...          1         inf          inf   \n",
       "16_8344_8845_4r                   ...          0         inf          inf   \n",
       "16_8344_8845_4r                   ...          0         inf          inf   \n",
       "16_8344_8845_4r                   ...          0         inf          inf   \n",
       "16_8344_8845_4r                   ...          0         inf          inf   \n",
       "17_8344_8845_2r_mt_z              ...          1         inf          inf   \n",
       "17_8344_8845_2r_mt_z              ...          1         inf          inf   \n",
       "...                               ...        ...         ...          ...   \n",
       "P20_008845_1894_XN_09N203W_18     ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_2      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_2      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_2      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_2      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_3      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_3      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_3      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_3      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_4      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_4      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_5      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_5      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_5      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_6      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_6      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_6      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_6      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_7      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_7      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_7      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_7      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_8      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_8      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_8      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_8      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_9      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_9      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_9      ...          0         inf          inf   \n",
       "P20_008845_1894_XN_09N203W_9      ...          0         inf          inf   \n",
       "\n",
       "                                        ht  sig0  sig1        sig2       res0  \\\n",
       "10_8344_8845_4r               -2523.828227   0.0   0.0   25.000000  18.301328   \n",
       "10_8344_8845_4r               -2523.828227   0.0   0.0   25.000000  18.301328   \n",
       "10_8344_8845_4r               -2523.828227   0.0   0.0   25.000000  18.301328   \n",
       "10_8344_8845_4r               -2523.828227   0.0   0.0   25.000000  18.301328   \n",
       "11_8344_8845_4r               -2445.237027   0.0   0.0   30.000000 -22.046575   \n",
       "11_8344_8845_4r               -2445.237027   0.0   0.0   30.000000 -22.046575   \n",
       "11_8344_8845_4r               -2445.237027   0.0   0.0   30.000000 -22.046575   \n",
       "11_8344_8845_4r               -2445.237027   0.0   0.0   30.000000 -22.046575   \n",
       "12_8344_8845_4r               -2606.935163   0.0   0.0  100.000000  -7.549561   \n",
       "12_8344_8845_4r               -2606.935163   0.0   0.0  100.000000  -7.549561   \n",
       "12_8344_8845_4r               -2606.935163   0.0   0.0  100.000000  -7.549561   \n",
       "12_8344_8845_4r               -2606.935163   0.0   0.0  100.000000  -7.549561   \n",
       "13_8344_8845_4r               -2551.901554   0.0   0.0    4.536068  -1.643694   \n",
       "13_8344_8845_4r               -2551.901554   0.0   0.0    4.536068  -1.643694   \n",
       "13_8344_8845_4r               -2551.901554   0.0   0.0    4.536068  -1.643694   \n",
       "13_8344_8845_4r               -2551.901554   0.0   0.0    4.536068  -1.643694   \n",
       "14_8344_8845_4r               -2505.953426   0.0   0.0    5.000000 -50.069808   \n",
       "14_8344_8845_4r               -2505.953426   0.0   0.0    5.000000 -50.069808   \n",
       "14_8344_8845_4r               -2505.953426   0.0   0.0    5.000000 -50.069808   \n",
       "14_8344_8845_4r               -2505.953426   0.0   0.0    5.000000 -50.069808   \n",
       "15_8344_8845_4r_mt_z          -2502.470000   0.0   0.0    5.000000 -34.817656   \n",
       "15_8344_8845_4r_mt_z          -2502.470000   0.0   0.0    5.000000 -34.817656   \n",
       "15_8344_8845_4r_mt_z          -2502.470000   0.0   0.0    5.000000 -34.817656   \n",
       "15_8344_8845_4r_mt_z          -2502.470000   0.0   0.0    5.000000 -34.817656   \n",
       "16_8344_8845_4r               -2558.312931   0.0   0.0    1.707214 -29.465246   \n",
       "16_8344_8845_4r               -2558.312931   0.0   0.0    1.707214 -29.465246   \n",
       "16_8344_8845_4r               -2558.312931   0.0   0.0    1.707214 -29.465246   \n",
       "16_8344_8845_4r               -2558.312931   0.0   0.0    1.707214 -29.465246   \n",
       "17_8344_8845_2r_mt_z          -2590.130000   0.0   0.0    2.000000 -10.779830   \n",
       "17_8344_8845_2r_mt_z          -2590.130000   0.0   0.0    2.000000 -10.779830   \n",
       "...                                    ...   ...   ...         ...        ...   \n",
       "P20_008845_1894_XN_09N203W_18 -2514.431453   0.0   0.0    0.000000 -38.388316   \n",
       "P20_008845_1894_XN_09N203W_2  -2535.712262   0.0   0.0    0.000000  42.067289   \n",
       "P20_008845_1894_XN_09N203W_2  -2535.712262   0.0   0.0    0.000000  42.067289   \n",
       "P20_008845_1894_XN_09N203W_2  -2535.712262   0.0   0.0    0.000000  42.067289   \n",
       "P20_008845_1894_XN_09N203W_2  -2535.712262   0.0   0.0    0.000000  42.067289   \n",
       "P20_008845_1894_XN_09N203W_3  -2525.215515   0.0   0.0    0.000000  36.033823   \n",
       "P20_008845_1894_XN_09N203W_3  -2525.215515   0.0   0.0    0.000000  36.033823   \n",
       "P20_008845_1894_XN_09N203W_3  -2525.215515   0.0   0.0    0.000000  36.033823   \n",
       "P20_008845_1894_XN_09N203W_3  -2525.215515   0.0   0.0    0.000000  36.033823   \n",
       "P20_008845_1894_XN_09N203W_4  -2562.446851   0.0   0.0    0.000000  -7.233876   \n",
       "P20_008845_1894_XN_09N203W_4  -2562.446851   0.0   0.0    0.000000  -7.233876   \n",
       "P20_008845_1894_XN_09N203W_5  -2560.812028   0.0   0.0    0.000000   7.498790   \n",
       "P20_008845_1894_XN_09N203W_5  -2560.812028   0.0   0.0    0.000000   7.498790   \n",
       "P20_008845_1894_XN_09N203W_5  -2560.812028   0.0   0.0    0.000000   7.498790   \n",
       "P20_008845_1894_XN_09N203W_6  -2605.266130   0.0   0.0    0.000000   7.687475   \n",
       "P20_008845_1894_XN_09N203W_6  -2605.266130   0.0   0.0    0.000000   7.687475   \n",
       "P20_008845_1894_XN_09N203W_6  -2605.266130   0.0   0.0    0.000000   7.687475   \n",
       "P20_008845_1894_XN_09N203W_6  -2605.266130   0.0   0.0    0.000000   7.687475   \n",
       "P20_008845_1894_XN_09N203W_7  -2619.498291   0.0   0.0    0.000000   6.358447   \n",
       "P20_008845_1894_XN_09N203W_7  -2619.498291   0.0   0.0    0.000000   6.358447   \n",
       "P20_008845_1894_XN_09N203W_7  -2619.498291   0.0   0.0    0.000000   6.358447   \n",
       "P20_008845_1894_XN_09N203W_7  -2619.498291   0.0   0.0    0.000000   6.358447   \n",
       "P20_008845_1894_XN_09N203W_8  -2608.028730   0.0   0.0    0.000000  -0.219662   \n",
       "P20_008845_1894_XN_09N203W_8  -2608.028730   0.0   0.0    0.000000  -0.219662   \n",
       "P20_008845_1894_XN_09N203W_8  -2608.028730   0.0   0.0    0.000000  -0.219662   \n",
       "P20_008845_1894_XN_09N203W_8  -2608.028730   0.0   0.0    0.000000  -0.219662   \n",
       "P20_008845_1894_XN_09N203W_9  -2586.686862   0.0   0.0    0.000000  15.191825   \n",
       "P20_008845_1894_XN_09N203W_9  -2586.686862   0.0   0.0    0.000000  15.191825   \n",
       "P20_008845_1894_XN_09N203W_9  -2586.686862   0.0   0.0    0.000000  15.191825   \n",
       "P20_008845_1894_XN_09N203W_9  -2586.686862   0.0   0.0    0.000000  15.191825   \n",
       "\n",
       "                                     res1        res2  \n",
       "10_8344_8845_4r                 44.206259  416.201741  \n",
       "10_8344_8845_4r                 44.206259  416.201741  \n",
       "10_8344_8845_4r                 44.206259  416.201741  \n",
       "10_8344_8845_4r                 44.206259  416.201741  \n",
       "11_8344_8845_4r                103.403228  173.210013  \n",
       "11_8344_8845_4r                103.403228  173.210013  \n",
       "11_8344_8845_4r                103.403228  173.210013  \n",
       "11_8344_8845_4r                103.403228  173.210013  \n",
       "12_8344_8845_4r                 93.170584  180.058858  \n",
       "12_8344_8845_4r                 93.170584  180.058858  \n",
       "12_8344_8845_4r                 93.170584  180.058858  \n",
       "12_8344_8845_4r                 93.170584  180.058858  \n",
       "13_8344_8845_4r                 74.244153  319.554535  \n",
       "13_8344_8845_4r                 74.244153  319.554535  \n",
       "13_8344_8845_4r                 74.244153  319.554535  \n",
       "13_8344_8845_4r                 74.244153  319.554535  \n",
       "14_8344_8845_4r                144.316524 -164.540707  \n",
       "14_8344_8845_4r                144.316524 -164.540707  \n",
       "14_8344_8845_4r                144.316524 -164.540707  \n",
       "14_8344_8845_4r                144.316524 -164.540707  \n",
       "15_8344_8845_4r_mt_z           145.864550    0.214023  \n",
       "15_8344_8845_4r_mt_z           145.864550    0.214023  \n",
       "15_8344_8845_4r_mt_z           145.864550    0.214023  \n",
       "15_8344_8845_4r_mt_z           145.864550    0.214023  \n",
       "16_8344_8845_4r                121.908506   19.874949  \n",
       "16_8344_8845_4r                121.908506   19.874949  \n",
       "16_8344_8845_4r                121.908506   19.874949  \n",
       "16_8344_8845_4r                121.908506   19.874949  \n",
       "17_8344_8845_2r_mt_z            38.761214    0.236077  \n",
       "17_8344_8845_2r_mt_z            38.761214    0.236077  \n",
       "...                                   ...         ...  \n",
       "P20_008845_1894_XN_09N203W_18  195.050373 -391.289238  \n",
       "P20_008845_1894_XN_09N203W_2   -12.658160  627.742625  \n",
       "P20_008845_1894_XN_09N203W_2   -12.658160  627.742625  \n",
       "P20_008845_1894_XN_09N203W_2   -12.658160  627.742625  \n",
       "P20_008845_1894_XN_09N203W_2   -12.658160  627.742625  \n",
       "P20_008845_1894_XN_09N203W_3    -4.170818  616.480181  \n",
       "P20_008845_1894_XN_09N203W_3    -4.170818  616.480181  \n",
       "P20_008845_1894_XN_09N203W_3    -4.170818  616.480181  \n",
       "P20_008845_1894_XN_09N203W_3    -4.170818  616.480181  \n",
       "P20_008845_1894_XN_09N203W_4    33.324946  574.887719  \n",
       "P20_008845_1894_XN_09N203W_4    33.324946  574.887719  \n",
       "P20_008845_1894_XN_09N203W_5    33.109007  581.149470  \n",
       "P20_008845_1894_XN_09N203W_5    33.109007  581.149470  \n",
       "P20_008845_1894_XN_09N203W_5    33.109007  581.149470  \n",
       "P20_008845_1894_XN_09N203W_6    59.859663  375.680663  \n",
       "P20_008845_1894_XN_09N203W_6    59.859663  375.680663  \n",
       "P20_008845_1894_XN_09N203W_6    59.859663  375.680663  \n",
       "P20_008845_1894_XN_09N203W_6    59.859663  375.680663  \n",
       "P20_008845_1894_XN_09N203W_7    61.278242  375.840988  \n",
       "P20_008845_1894_XN_09N203W_7    61.278242  375.840988  \n",
       "P20_008845_1894_XN_09N203W_7    61.278242  375.840988  \n",
       "P20_008845_1894_XN_09N203W_7    61.278242  375.840988  \n",
       "P20_008845_1894_XN_09N203W_8    71.414267  336.409684  \n",
       "P20_008845_1894_XN_09N203W_8    71.414267  336.409684  \n",
       "P20_008845_1894_XN_09N203W_8    71.414267  336.409684  \n",
       "P20_008845_1894_XN_09N203W_8    71.414267  336.409684  \n",
       "P20_008845_1894_XN_09N203W_9    22.094037  544.874936  \n",
       "P20_008845_1894_XN_09N203W_9    22.094037  544.874936  \n",
       "P20_008845_1894_XN_09N203W_9    22.094037  544.874936  \n",
       "P20_008845_1894_XN_09N203W_9    22.094037  544.874936  \n",
       "\n",
       "[919 rows x 23 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import math\n",
    "import pyproj\n",
    "\n",
    "# converts +/- 180 system to 0 - 360 system\n",
    "def to_360(num):\n",
    "    return num % 360\n",
    "\n",
    "# ocentric to ographic latitudes\n",
    "def oc2og(dlat, dMajorRadius, dMinorRadius):\n",
    "    try:    \n",
    "        dlat = math.radians(dlat)\n",
    "        dlat = math.atan(((dMajorRadius / dMinorRadius)**2) * (math.tan(dlat)))\n",
    "        dlat = math.degrees(dlat)\n",
    "    except:\n",
    "        print (\"Error in oc2og conversion\")\n",
    "    return dlat\n",
    "\n",
    "# ographic to ocentric latitudes\n",
    "def og2oc(dlat, dMajorRadius, dMinorRadius):\n",
    "    try:\n",
    "        dlat = math.radians(dlat)\n",
    "        dlat = math.atan((math.tan(dlat) / ((dMajorRadius / dMinorRadius)**2)))\n",
    "        dlat = math.degrees(dlat)\n",
    "    except:\n",
    "        print (\"Error in og2oc conversion\")\n",
    "    return dlat\n",
    "\n",
    "def get_axis():\n",
    "    with open(atf_dict['PATH'] + '/' + 'CTX_Athabasca_Middle.prj') as f:\n",
    "        from collections import defaultdict\n",
    "\n",
    "        files = defaultdict(list)\n",
    "        \n",
    "        for line in f:\n",
    "            \n",
    "            ext = line.strip().split(' ')\n",
    "            files[ext[0]].append(ext[-1])\n",
    "            \n",
    "        eRadius = float(files['A_EARTH'][0])\n",
    "        pRadius = eRadius * (1 - float(files['E_EARTH'][0]))\n",
    "        \n",
    "        return eRadius, pRadius\n",
    "    \n",
    "# function to convert lat_Y_North to ISIS_lat\n",
    "def lat_ISIS_coord(record):\n",
    "    with open(atf_dict['PATH'] + '/' + 'CTX_Athabasca_Middle.prj') as f:\n",
    "        from collections import defaultdict\n",
    "\n",
    "        files = defaultdict(list)\n",
    "        \n",
    "        for line in f:\n",
    "            \n",
    "            ext = line.strip().split(' ')\n",
    "            files[ext[0]].append(ext[-1])\n",
    "            \n",
    "        eRadius = float(files['A_EARTH'][0])\n",
    "        pRadius = eRadius * (1 - float(files['E_EARTH'][0]))\n",
    "        ocentric_coord = og2oc(record['lat_Y_North'], eRadius, pRadius)\n",
    "        coord_360 = to_360(ocentric_coord)\n",
    "        return coord_360\n",
    "\n",
    "# function to convert long_X_East to ISIS_lon\n",
    "def lon_ISIS_coord(record):\n",
    "    with open(atf_dict['PATH'] + '/' + 'CTX_Athabasca_Middle.prj') as f:\n",
    "        from collections import defaultdict\n",
    "\n",
    "        files = defaultdict(list)\n",
    "        \n",
    "        for line in f:\n",
    "            \n",
    "            ext = line.strip().split(' ')\n",
    "            files[ext[0]].append(ext[-1])\n",
    "            \n",
    "        eRadius = float(files['A_EARTH'][0])\n",
    "        pRadius = eRadius * (1 - float(files['E_EARTH'][0]))\n",
    "        ocentric_coord = og2oc(record['long_X_East'], eRadius, pRadius)\n",
    "        coord_360 = to_360(ocentric_coord)\n",
    "        return coord_360\n",
    "            \n",
    "def body_fixed_lat(record):\n",
    "    semi_major, semi_minor = get_axis() \n",
    "    ecef = pyproj.Proj(proj='geocent', a=semi_major, b=semi_minor)\n",
    "    lla = pyproj.Proj(proj='latlon', a=semi_major, b=semi_minor)\n",
    "    lon, lat, height = pyproj.transform(lla, ecef, record['long_X_East'], record['lat_Y_North'], record['ht'])\n",
    "    return lat\n",
    "\n",
    "def body_fixed_lon(record):\n",
    "    semi_major, semi_minor = get_axis() \n",
    "    ecef = pyproj.Proj(proj='geocent', a=semi_major, b=semi_minor)\n",
    "    lla = pyproj.Proj(proj='latlon', a=semi_major, b=semi_minor)\n",
    "    lon, lat, height = pyproj.transform(lla, ecef, record['long_X_East'], record['lat_Y_North'], record['ht'])\n",
    "    return lon\n",
    "\n",
    "def body_fixed_height(record):\n",
    "    semi_major, semi_minor = get_axis() \n",
    "    ecef = pyproj.Proj(proj='geocent', a=semi_major, b=semi_minor)\n",
    "    lla = pyproj.Proj(proj='latlon', a=semi_major, b=semi_minor)\n",
    "    lon, lat, height = pyproj.transform(lla, ecef, record['long_X_East'], record['lat_Y_North'], record['ht'])\n",
    "    return height\n",
    "\n",
    "\n",
    "new_df['lat_Y_North'] = new_df.apply(lat_ISIS_coord, axis=1)\n",
    "new_df['long_X_East'] = new_df.apply(lon_ISIS_coord, axis=1)\n",
    "\n",
    "new_df['lat_Y_North'] = new_df.apply(body_fixed_lat, axis=1)\n",
    "new_df['long_X_East'] = new_df.apply(body_fixed_lon, axis=1)\n",
    "\n",
    "new_df['ht'] = new_df.apply(body_fixed_height, axis=1)\n",
    "\n",
    "\n",
    "display(new_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Reads a .atf file and outputs all of the \n",
    "# .ipf, .gpf, .sup, .prj, and path to locate the \n",
    "# .apf file (should be the same as all others) \n",
    "def read_atf(atf_file):\n",
    "    with open(atf_file) as f:\n",
    "\n",
    "        files = []\n",
    "        ipf = []\n",
    "        sup = []\n",
    "        files_dict = []\n",
    "        \n",
    "        # Grabs every PRJ, GPF, SUP, and IPF image from the ATF file\n",
    "        for line in f:\n",
    "            if line[-4:-1] == 'prj' or line[-4:-1] == 'gpf' or line[-4:-1] == 'sup' or line[-4:-1] == 'ipf' or line[-4:-1] == 'atf':\n",
    "                files.append(line)\n",
    "        \n",
    "        files = np.array(files)\n",
    "        \n",
    "        # Creates appropriate arrays for certain files in the right format\n",
    "        for file in files:\n",
    "            file = file.strip()\n",
    "            file = file.split(' ')\n",
    "\n",
    "            # Grabs all the IPF files\n",
    "            if file[1].endswith('.ipf'):\n",
    "                ipf.append(file[1])\n",
    "\n",
    "            # Grabs all the SUP files\n",
    "            if file[1].endswith('.sup'):\n",
    "                sup.append(file[1])\n",
    "\n",
    "            files_dict.append(file)\n",
    "\n",
    "        # Creates a dict out of file lists for GPF, PRJ, IPF, and ATF\n",
    "        files_dict = (dict(files_dict))\n",
    "        \n",
    "        # Sets the value of IMAGE_IPF to all IPF images\n",
    "        files_dict['IMAGE_IPF'] = ipf\n",
    "        \n",
    "        # Sets the value of IMAGE_SUP to all SUP images\n",
    "        files_dict['IMAGE_SUP'] = sup\n",
    "        \n",
    "        # Sets the value of PATH to the path of the ATF file\n",
    "        files_dict['PATH'] = os.path.dirname(os.path.abspath(atf_file))\n",
    "        \n",
    "        return files_dict\n",
    "    \n",
    "@singledispatch\n",
    "def read_ipf(arg):\n",
    "    return str(arg)\n",
    "# new_df['known'] = new_df.apply(known, axis=1)\n",
    "\n",
    "@read_ipf.register(str)\n",
    "def read_ipf_str(input_data):\n",
    "    \"\"\"\n",
    "    Read a socet ipf file into a pandas data frame\n",
    "\n",
    "    Parameters\n",
    "    ----------\n",
    "    input_data : str\n",
    "                 path to the an input data file\n",
    "\n",
    "    Returns\n",
    "    -------\n",
    "    df : pd.DataFrame\n",
    "         containing the ipf data with appropriate column names and indices\n",
    "    \"\"\"\n",
    "\n",
    "    # Check that the number of rows is matching the expected number\n",
    "    with open(input_data, 'r') as f:\n",
    "        for i, l in enumerate(f):\n",
    "            if i == 1:\n",
    "                cnt = int(l)\n",
    "            elif i == 2:\n",
    "                col = l\n",
    "                break\n",
    "                \n",
    "    columns = np.genfromtxt(input_data, skip_header=2, dtype='unicode',\n",
    "                            max_rows = 1, delimiter = ',')\n",
    "\n",
    "    # TODO: Add unicode conversion\n",
    "    d = [line.split() for line in open(input_data, 'r')]\n",
    "    d = np.hstack(np.array(d[3:]))\n",
    "    \n",
    "    d = d.reshape(-1, 12)\n",
    "    \n",
    "    df = pd.DataFrame(d, columns=columns)\n",
    "    file = os.path.split(os.path.splitext(input_data)[0])[1]\n",
    "    df['ipf_file'] = pd.Series(np.full((len(df['pt_id'])), file), index = df.index)\n",
    "\n",
    "    assert int(cnt) == len(df), 'Dataframe length {} does not match point length {}.'.format(int(cnt), len(df))\n",
    "    \n",
    "    # Soft conversion of numeric types to numerics, allows str in first col for point_id\n",
    "    df = df.apply(pd.to_numeric, errors='ignore')\n",
    "\n",
    "    return df\n",
    "\n",
    "@read_ipf.register(list)\n",
    "def read_ipf_list(input_data_list):\n",
    "    \"\"\"\n",
    "    Read a socet ipf file into a pandas data frame\n",
    "\n",
    "    Parameters\n",
    "    ----------\n",
    "    input_data_list : list\n",
    "                      list of paths to the a set of input data files\n",
    "\n",
    "    Returns\n",
    "    -------\n",
    "    df : pd.DataFrame\n",
    "         containing the ipf data with appropriate column names and indices\n",
    "    \"\"\"\n",
    "    frames = []\n",
    "\n",
    "    for input_file in input_data_list:\n",
    "        frames.append(read_ipf(input_file))\n",
    "\n",
    "    df = pd.concat(frames)\n",
    "\n",
    "    return df"
   ]
  }
 ],
 "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.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}