{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'ATF_FILE': 'CTX_Athabasca_Middle_step0.atf',\n",
       " 'GP_FILE': 'CTX_Athabasca_Middle.gpf',\n",
       " 'IMAGE_IPF': ['P19_008344_1894_XN_09N203W.ipf',\n",
       "  'P20_008845_1894_XN_09N203W.ipf',\n",
       "  'P03_002371_1888_XI_08N204W.ipf',\n",
       "  'P01_001540_1889_XI_08N204W.ipf',\n",
       "  'P01_001606_1897_XI_09N203W.ipf',\n",
       "  'P03_002226_1895_XI_09N203W.ipf'],\n",
       " 'IMAGE_SUP': ['P19_008344_1894_XN_09N203W.sup',\n",
       "  'P20_008845_1894_XN_09N203W.sup',\n",
       "  'P03_002371_1888_XI_08N204W.sup',\n",
       "  'P01_001540_1889_XI_08N204W.sup',\n",
       "  'P01_001606_1897_XI_09N203W.sup',\n",
       "  'P03_002226_1895_XI_09N203W.sup'],\n",
       " 'PATH': '/home/tthatcher/Desktop/Projects/Plio/plio/plio/examples/SocetSet',\n",
       " 'PROJECT': 'D:\\\\data\\\\CTX_Athabasca_Middle.prj'}"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import os\n",
    "import numpy as np\n",
    "from plio.examples import get_path\n",
    "\n",
    "# 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(get_path(atf_file)) as f:\n",
    "        \n",
    "        atf_file = get_path(atf_file);\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",
    "read_atf('CTX_Athabasca_Middle_step0.atf')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import sys\n",
    "import math\n",
    "\n",
    "sys.path.insert(0, os.path.abspath('/home/tthatcher/Desktop/Projects/Plio/plio'))\n",
    "\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "from plio.examples import get_path\n",
    "from plio.io.io_bae import read_gpf\n",
    "from plio.io.io_gdal import GeoDataset\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "def read_ipf(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",
    "    # TODO: Add unicode conversion\n",
    "\n",
    "    d = [line.split() for line in open(input_data, 'r')]\n",
    "    d = np.hstack(np.array(d[3:]))\n",
    "    d = d.reshape(-1, 12)\n",
    "\n",
    "    assert int(cnt) == len(d), 'Dataframe length {} does not match point length {}.'.format(int(cnt), len(df))\n",
    "\n",
    "    return d\n",
    "\n",
    "def read_ipfs(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",
    "\n",
    "    columns = np.genfromtxt(input_data_list[0], skip_header=2, dtype='unicode',\n",
    "                                    max_rows = 1, delimiter = ',')\n",
    "\n",
    "    d_total = []\n",
    "\n",
    "    for input_file in input_data_list:\n",
    "        d = read_ipf(input_file)\n",
    "        for point in d:\n",
    "            d_total.append(point)\n",
    "\n",
    "    df = pd.DataFrame(d_total, columns=columns)\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"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['/home/tthatcher/Desktop/Projects/Plio/plio/plio/examples/SocetSet/P20_008845_1894_XN_09N203W.ipf', '/home/tthatcher/Desktop/Projects/Plio/plio/plio/examples/SocetSet/P03_002371_1888_XI_08N204W.ipf', '/home/tthatcher/Desktop/Projects/Plio/plio/plio/examples/SocetSet/P01_001540_1889_XI_08N204W.ipf', '/home/tthatcher/Desktop/Projects/Plio/plio/plio/examples/SocetSet/P01_001606_1897_XI_09N203W.ipf', '/home/tthatcher/Desktop/Projects/Plio/plio/plio/examples/SocetSet/P03_002226_1895_XI_09N203W.ipf']\n"
     ]
    }
   ],
   "source": [
    "gpf_file = get_path('CTX_Athabasca_Middle.gpf');\n",
    "\n",
    "ipf_list = [get_path('P20_008845_1894_XN_09N203W.ipf'),\n",
    "            get_path('P03_002371_1888_XI_08N204W.ipf'),\n",
    "            get_path('P01_001540_1889_XI_08N204W.ipf'),\n",
    "            get_path('P01_001606_1897_XI_09N203W.ipf'),\n",
    "            get_path('P03_002226_1895_XI_09N203W.ipf'),]\n",
    "\n",
    "# ipf_list = [get_path('P20_008845_1894_XN_09N203W.ipf')]\n",
    "\n",
    "print(ipf_list)\n",
    "gpf_df = read_gpf(gpf_file).set_index('point_id')\n",
    "ipf_df = read_ipfs(ipf_list).set_index('pt_id')\n",
    "# ipf_df.to_csv(\"/Users/adampaquette/repos/plio/plio/examples/SocetSet/P20_008845_1894_XN_09N203W.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "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>sigma0</th>\n",
       "      <th>sigma1</th>\n",
       "      <th>sigma2</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>-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>-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>-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>-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>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>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>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>-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>18_8344_8845_2r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-1773.864990</td>\n",
       "      <td>354.084259</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.002223</td>\n",
       "      <td>-0.000684</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.163515</td>\n",
       "      <td>2.725299</td>\n",
       "      <td>-2608.227033</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-22.636068</td>\n",
       "      <td>54.092590</td>\n",
       "      <td>524.603661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19_8344_8845_2r_mt_z</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-92.482826</td>\n",
       "      <td>723.305237</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.214498</td>\n",
       "      <td>0.145192</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0.166403</td>\n",
       "      <td>2.724323</td>\n",
       "      <td>-2597.460000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>-42.271359</td>\n",
       "      <td>76.834077</td>\n",
       "      <td>-0.138177</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-4058.982422</td>\n",
       "      <td>-2318.010742</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.062556</td>\n",
       "      <td>-0.214713</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.160037</td>\n",
       "      <td>2.730339</td>\n",
       "      <td>-2539.150747</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>49.937532</td>\n",
       "      <td>-24.131687</td>\n",
       "      <td>639.699743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-6144.898438</td>\n",
       "      <td>677.674805</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.069161</td>\n",
       "      <td>0.311984</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.160037</td>\n",
       "      <td>2.730339</td>\n",
       "      <td>-2539.150747</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>49.937532</td>\n",
       "      <td>-24.131687</td>\n",
       "      <td>639.699743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_8344_8845_4r</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-5284.357910</td>\n",
       "      <td>504.304413</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002209</td>\n",
       "      <td>0.194239</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.160037</td>\n",
       "      <td>2.730339</td>\n",
       "      <td>-2539.150747</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>49.937532</td>\n",
       "      <td>-24.131687</td>\n",
       "      <td>639.699743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20_8344_8845_2r_mt_z</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1434.079712</td>\n",
       "      <td>742.064026</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.058132</td>\n",
       "      <td>-0.171782</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0.169088</td>\n",
       "      <td>2.723969</td>\n",
       "      <td>-2522.470000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>-56.910236</td>\n",
       "      <td>91.282891</td>\n",
       "      <td>0.161681</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_8344_8845_4r_xyz</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-838.991028</td>\n",
       "      <td>-614.524109</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.131313</td>\n",
       "      <td>0.997120</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>0.165360</td>\n",
       "      <td>2.726740</td>\n",
       "      <td>-2209.490000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.780598</td>\n",
       "      <td>-3.284978</td>\n",
       "      <td>-0.443885</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_8344_8845_4r_xyz</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-2919.093018</td>\n",
       "      <td>2467.773926</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.469767</td>\n",
       "      <td>-0.745137</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>0.165360</td>\n",
       "      <td>2.726740</td>\n",
       "      <td>-2209.490000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.780598</td>\n",
       "      <td>-3.284978</td>\n",
       "      <td>-0.443885</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_16</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2865.000000</td>\n",
       "      <td>2024.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.053859</td>\n",
       "      <td>0.035981</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.171351</td>\n",
       "      <td>2.721519</td>\n",
       "      <td>-2499.843797</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-43.211361</td>\n",
       "      <td>193.404135</td>\n",
       "      <td>-393.931834</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_16</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8611.724609</td>\n",
       "      <td>-1352.647949</td>\n",
       "      <td>0.015722</td>\n",
       "      <td>0.015722</td>\n",
       "      <td>-0.153906</td>\n",
       "      <td>-0.039881</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.171351</td>\n",
       "      <td>2.721519</td>\n",
       "      <td>-2499.843797</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-43.211361</td>\n",
       "      <td>193.404135</td>\n",
       "      <td>-393.931834</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_16</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8914.713867</td>\n",
       "      <td>-1261.989868</td>\n",
       "      <td>0.023530</td>\n",
       "      <td>0.023530</td>\n",
       "      <td>0.691574</td>\n",
       "      <td>-0.075730</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.171351</td>\n",
       "      <td>2.721519</td>\n",
       "      <td>-2499.843797</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-43.211361</td>\n",
       "      <td>193.404135</td>\n",
       "      <td>-393.931834</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_17</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3175.000000</td>\n",
       "      <td>1974.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.064058</td>\n",
       "      <td>0.044374</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.171907</td>\n",
       "      <td>2.721537</td>\n",
       "      <td>-2504.618390</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-44.880108</td>\n",
       "      <td>199.649337</td>\n",
       "      <td>-441.559606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_17</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8921.941406</td>\n",
       "      <td>-1402.745361</td>\n",
       "      <td>0.017650</td>\n",
       "      <td>0.017650</td>\n",
       "      <td>-0.016220</td>\n",
       "      <td>-0.049595</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.171907</td>\n",
       "      <td>2.721537</td>\n",
       "      <td>-2504.618390</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-44.880108</td>\n",
       "      <td>199.649337</td>\n",
       "      <td>-441.559606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_17</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>9224.031250</td>\n",
       "      <td>-1309.074219</td>\n",
       "      <td>0.030802</td>\n",
       "      <td>0.030802</td>\n",
       "      <td>0.567955</td>\n",
       "      <td>-0.078411</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.171907</td>\n",
       "      <td>2.721537</td>\n",
       "      <td>-2504.618390</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-44.880108</td>\n",
       "      <td>199.649337</td>\n",
       "      <td>-441.559606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P20_008845_1894_XN_09N203W_18</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2872.000000</td>\n",
       "      <td>1565.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.256228</td>\n",
       "      <td>0.218860</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_18</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8617.777344</td>\n",
       "      <td>-1818.614380</td>\n",
       "      <td>0.114295</td>\n",
       "      <td>0.114295</td>\n",
       "      <td>-0.500861</td>\n",
       "      <td>-0.252638</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_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>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>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>-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>-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>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>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>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>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>809 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                               val  fid_val  no_obs           l.           s.  \\\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  -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  -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 -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  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  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   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 -3138.269531   442.515503   \n",
       "18_8344_8845_2r                  1        0       0 -1773.864990   354.084259   \n",
       "19_8344_8845_2r_mt_z             1        0       0   -92.482826   723.305237   \n",
       "1_8344_8845_4r                   1        0       0 -4058.982422 -2318.010742   \n",
       "1_8344_8845_4r                   1        0       0 -6144.898438   677.674805   \n",
       "1_8344_8845_4r                   1        0       0 -5284.357910   504.304413   \n",
       "20_8344_8845_2r_mt_z             1        0       0  1434.079712   742.064026   \n",
       "21_8344_8845_4r_xyz              1        0       0  -838.991028  -614.524109   \n",
       "21_8344_8845_4r_xyz              1        0       0 -2919.093018  2467.773926   \n",
       "...                            ...      ...     ...          ...          ...   \n",
       "P20_008845_1894_XN_09N203W_16    1        0       2  2865.000000  2024.000000   \n",
       "P20_008845_1894_XN_09N203W_16    1        0       1  8611.724609 -1352.647949   \n",
       "P20_008845_1894_XN_09N203W_16    1        0       1  8914.713867 -1261.989868   \n",
       "P20_008845_1894_XN_09N203W_17    1        0       2  3175.000000  1974.000000   \n",
       "P20_008845_1894_XN_09N203W_17    1        0       1  8921.941406 -1402.745361   \n",
       "P20_008845_1894_XN_09N203W_17    1        0       1  9224.031250 -1309.074219   \n",
       "P20_008845_1894_XN_09N203W_18    1        0       2  2872.000000  1565.000000   \n",
       "P20_008845_1894_XN_09N203W_18    1        0       1  8617.777344 -1818.614380   \n",
       "P20_008845_1894_XN_09N203W_18    1        0       1  8918.806641 -1701.755249   \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       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 -3226.000000   167.000000   \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       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       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       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       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.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.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.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.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.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.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.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.023370 -0.248643    0.0   \n",
       "18_8344_8845_2r                0.000000  0.000000 -0.002223 -0.000684    0.0   \n",
       "19_8344_8845_2r_mt_z           0.000000  0.000000 -0.214498  0.145192    0.0   \n",
       "1_8344_8845_4r                 0.000000  0.000000 -0.062556 -0.214713    0.0   \n",
       "1_8344_8845_4r                 0.000000  0.000000 -0.069161  0.311984    0.0   \n",
       "1_8344_8845_4r                 0.000000  0.000000  0.002209  0.194239    0.0   \n",
       "20_8344_8845_2r_mt_z           0.000000  0.000000 -0.058132 -0.171782    0.0   \n",
       "21_8344_8845_4r_xyz            0.000000  0.000000 -0.131313  0.997120    0.0   \n",
       "21_8344_8845_4r_xyz            0.000000  0.000000 -0.469767 -0.745137    0.0   \n",
       "...                                 ...       ...       ...       ...    ...   \n",
       "P20_008845_1894_XN_09N203W_16  0.000000  0.000000 -0.053859  0.035981    0.0   \n",
       "P20_008845_1894_XN_09N203W_16  0.015722  0.015722 -0.153906 -0.039881    0.0   \n",
       "P20_008845_1894_XN_09N203W_16  0.023530  0.023530  0.691574 -0.075730    0.0   \n",
       "P20_008845_1894_XN_09N203W_17  0.000000  0.000000 -0.064058  0.044374    0.0   \n",
       "P20_008845_1894_XN_09N203W_17  0.017650  0.017650 -0.016220 -0.049595    0.0   \n",
       "P20_008845_1894_XN_09N203W_17  0.030802  0.030802  0.567955 -0.078411    0.0   \n",
       "P20_008845_1894_XN_09N203W_18  0.000000  0.000000  0.256228  0.218860    0.0   \n",
       "P20_008845_1894_XN_09N203W_18  0.114295  0.114295 -0.500861 -0.252638    0.0   \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.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.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.000000  0.000000 -0.195774 -0.000066    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.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.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.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.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",
       "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",
       "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",
       "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",
       "17_8344_8845_2r_mt_z              ...          1     0.161092     2.725426   \n",
       "18_8344_8845_2r                   ...          0     0.163515     2.725299   \n",
       "19_8344_8845_2r_mt_z              ...          1     0.166403     2.724323   \n",
       "1_8344_8845_4r                    ...          0     0.160037     2.730339   \n",
       "1_8344_8845_4r                    ...          0     0.160037     2.730339   \n",
       "1_8344_8845_4r                    ...          0     0.160037     2.730339   \n",
       "20_8344_8845_2r_mt_z              ...          1     0.169088     2.723969   \n",
       "21_8344_8845_4r_xyz               ...          3     0.165360     2.726740   \n",
       "21_8344_8845_4r_xyz               ...          3     0.165360     2.726740   \n",
       "...                               ...        ...          ...          ...   \n",
       "P20_008845_1894_XN_09N203W_16     ...          0     0.171351     2.721519   \n",
       "P20_008845_1894_XN_09N203W_16     ...          0     0.171351     2.721519   \n",
       "P20_008845_1894_XN_09N203W_16     ...          0     0.171351     2.721519   \n",
       "P20_008845_1894_XN_09N203W_17     ...          0     0.171907     2.721537   \n",
       "P20_008845_1894_XN_09N203W_17     ...          0     0.171907     2.721537   \n",
       "P20_008845_1894_XN_09N203W_17     ...          0     0.171907     2.721537   \n",
       "P20_008845_1894_XN_09N203W_18     ...          0     0.171455     2.722281   \n",
       "P20_008845_1894_XN_09N203W_18     ...          0     0.171455     2.722281   \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_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_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_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_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  sigma0  sigma1      sigma2  \\\n",
       "10_8344_8845_4r               -2523.828227     0.0     0.0   25.000000   \n",
       "10_8344_8845_4r               -2523.828227     0.0     0.0   25.000000   \n",
       "10_8344_8845_4r               -2523.828227     0.0     0.0   25.000000   \n",
       "11_8344_8845_4r               -2445.237027     0.0     0.0   30.000000   \n",
       "11_8344_8845_4r               -2445.237027     0.0     0.0   30.000000   \n",
       "11_8344_8845_4r               -2445.237027     0.0     0.0   30.000000   \n",
       "12_8344_8845_4r               -2606.935163     0.0     0.0  100.000000   \n",
       "12_8344_8845_4r               -2606.935163     0.0     0.0  100.000000   \n",
       "12_8344_8845_4r               -2606.935163     0.0     0.0  100.000000   \n",
       "13_8344_8845_4r               -2551.901554     0.0     0.0    4.536068   \n",
       "13_8344_8845_4r               -2551.901554     0.0     0.0    4.536068   \n",
       "13_8344_8845_4r               -2551.901554     0.0     0.0    4.536068   \n",
       "14_8344_8845_4r               -2505.953426     0.0     0.0    5.000000   \n",
       "14_8344_8845_4r               -2505.953426     0.0     0.0    5.000000   \n",
       "14_8344_8845_4r               -2505.953426     0.0     0.0    5.000000   \n",
       "15_8344_8845_4r_mt_z          -2502.470000     0.0     0.0    5.000000   \n",
       "15_8344_8845_4r_mt_z          -2502.470000     0.0     0.0    5.000000   \n",
       "15_8344_8845_4r_mt_z          -2502.470000     0.0     0.0    5.000000   \n",
       "16_8344_8845_4r               -2558.312931     0.0     0.0    1.707214   \n",
       "16_8344_8845_4r               -2558.312931     0.0     0.0    1.707214   \n",
       "16_8344_8845_4r               -2558.312931     0.0     0.0    1.707214   \n",
       "17_8344_8845_2r_mt_z          -2590.130000     0.0     0.0    2.000000   \n",
       "18_8344_8845_2r               -2608.227033     0.0     0.0    1.000000   \n",
       "19_8344_8845_2r_mt_z          -2597.460000     0.0     0.0    2.000000   \n",
       "1_8344_8845_4r                -2539.150747     0.0     0.0    4.000000   \n",
       "1_8344_8845_4r                -2539.150747     0.0     0.0    4.000000   \n",
       "1_8344_8845_4r                -2539.150747     0.0     0.0    4.000000   \n",
       "20_8344_8845_2r_mt_z          -2522.470000     0.0     0.0    2.000000   \n",
       "21_8344_8845_4r_xyz           -2209.490000     2.0     2.0    1.000000   \n",
       "21_8344_8845_4r_xyz           -2209.490000     2.0     2.0    1.000000   \n",
       "...                                    ...     ...     ...         ...   \n",
       "P20_008845_1894_XN_09N203W_16 -2499.843797     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_16 -2499.843797     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_16 -2499.843797     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_17 -2504.618390     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_17 -2504.618390     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_17 -2504.618390     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_18 -2514.431453     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_18 -2514.431453     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_18 -2514.431453     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_2  -2535.712262     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_2  -2535.712262     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_2  -2535.712262     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_3  -2525.215515     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_3  -2525.215515     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_3  -2525.215515     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_4  -2562.446851     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_5  -2560.812028     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_5  -2560.812028     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_6  -2605.266130     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_6  -2605.266130     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_6  -2605.266130     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_7  -2619.498291     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_7  -2619.498291     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_7  -2619.498291     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_8  -2608.028730     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_8  -2608.028730     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_8  -2608.028730     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_9  -2586.686862     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_9  -2586.686862     0.0     0.0    0.000000   \n",
       "P20_008845_1894_XN_09N203W_9  -2586.686862     0.0     0.0    0.000000   \n",
       "\n",
       "                                    res0        res1        res2  \n",
       "10_8344_8845_4r                18.301328   44.206259  416.201741  \n",
       "10_8344_8845_4r                18.301328   44.206259  416.201741  \n",
       "10_8344_8845_4r                18.301328   44.206259  416.201741  \n",
       "11_8344_8845_4r               -22.046575  103.403228  173.210013  \n",
       "11_8344_8845_4r               -22.046575  103.403228  173.210013  \n",
       "11_8344_8845_4r               -22.046575  103.403228  173.210013  \n",
       "12_8344_8845_4r                -7.549561   93.170584  180.058858  \n",
       "12_8344_8845_4r                -7.549561   93.170584  180.058858  \n",
       "12_8344_8845_4r                -7.549561   93.170584  180.058858  \n",
       "13_8344_8845_4r                -1.643694   74.244153  319.554535  \n",
       "13_8344_8845_4r                -1.643694   74.244153  319.554535  \n",
       "13_8344_8845_4r                -1.643694   74.244153  319.554535  \n",
       "14_8344_8845_4r               -50.069808  144.316524 -164.540707  \n",
       "14_8344_8845_4r               -50.069808  144.316524 -164.540707  \n",
       "14_8344_8845_4r               -50.069808  144.316524 -164.540707  \n",
       "15_8344_8845_4r_mt_z          -34.817656  145.864550    0.214023  \n",
       "15_8344_8845_4r_mt_z          -34.817656  145.864550    0.214023  \n",
       "15_8344_8845_4r_mt_z          -34.817656  145.864550    0.214023  \n",
       "16_8344_8845_4r               -29.465246  121.908506   19.874949  \n",
       "16_8344_8845_4r               -29.465246  121.908506   19.874949  \n",
       "16_8344_8845_4r               -29.465246  121.908506   19.874949  \n",
       "17_8344_8845_2r_mt_z          -10.779830   38.761214    0.236077  \n",
       "18_8344_8845_2r               -22.636068   54.092590  524.603661  \n",
       "19_8344_8845_2r_mt_z          -42.271359   76.834077   -0.138177  \n",
       "1_8344_8845_4r                 49.937532  -24.131687  639.699743  \n",
       "1_8344_8845_4r                 49.937532  -24.131687  639.699743  \n",
       "1_8344_8845_4r                 49.937532  -24.131687  639.699743  \n",
       "20_8344_8845_2r_mt_z          -56.910236   91.282891    0.161681  \n",
       "21_8344_8845_4r_xyz            -0.780598   -3.284978   -0.443885  \n",
       "21_8344_8845_4r_xyz            -0.780598   -3.284978   -0.443885  \n",
       "...                                  ...         ...         ...  \n",
       "P20_008845_1894_XN_09N203W_16 -43.211361  193.404135 -393.931834  \n",
       "P20_008845_1894_XN_09N203W_16 -43.211361  193.404135 -393.931834  \n",
       "P20_008845_1894_XN_09N203W_16 -43.211361  193.404135 -393.931834  \n",
       "P20_008845_1894_XN_09N203W_17 -44.880108  199.649337 -441.559606  \n",
       "P20_008845_1894_XN_09N203W_17 -44.880108  199.649337 -441.559606  \n",
       "P20_008845_1894_XN_09N203W_17 -44.880108  199.649337 -441.559606  \n",
       "P20_008845_1894_XN_09N203W_18 -38.388316  195.050373 -391.289238  \n",
       "P20_008845_1894_XN_09N203W_18 -38.388316  195.050373 -391.289238  \n",
       "P20_008845_1894_XN_09N203W_18 -38.388316  195.050373 -391.289238  \n",
       "P20_008845_1894_XN_09N203W_2   42.067289  -12.658160  627.742625  \n",
       "P20_008845_1894_XN_09N203W_2   42.067289  -12.658160  627.742625  \n",
       "P20_008845_1894_XN_09N203W_2   42.067289  -12.658160  627.742625  \n",
       "P20_008845_1894_XN_09N203W_3   36.033823   -4.170818  616.480181  \n",
       "P20_008845_1894_XN_09N203W_3   36.033823   -4.170818  616.480181  \n",
       "P20_008845_1894_XN_09N203W_3   36.033823   -4.170818  616.480181  \n",
       "P20_008845_1894_XN_09N203W_4   -7.233876   33.324946  574.887719  \n",
       "P20_008845_1894_XN_09N203W_5    7.498790   33.109007  581.149470  \n",
       "P20_008845_1894_XN_09N203W_5    7.498790   33.109007  581.149470  \n",
       "P20_008845_1894_XN_09N203W_6    7.687475   59.859663  375.680663  \n",
       "P20_008845_1894_XN_09N203W_6    7.687475   59.859663  375.680663  \n",
       "P20_008845_1894_XN_09N203W_6    7.687475   59.859663  375.680663  \n",
       "P20_008845_1894_XN_09N203W_7    6.358447   61.278242  375.840988  \n",
       "P20_008845_1894_XN_09N203W_7    6.358447   61.278242  375.840988  \n",
       "P20_008845_1894_XN_09N203W_7    6.358447   61.278242  375.840988  \n",
       "P20_008845_1894_XN_09N203W_8   -0.219662   71.414267  336.409684  \n",
       "P20_008845_1894_XN_09N203W_8   -0.219662   71.414267  336.409684  \n",
       "P20_008845_1894_XN_09N203W_8   -0.219662   71.414267  336.409684  \n",
       "P20_008845_1894_XN_09N203W_9   15.191825   22.094037  544.874936  \n",
       "P20_008845_1894_XN_09N203W_9   15.191825   22.094037  544.874936  \n",
       "P20_008845_1894_XN_09N203W_9   15.191825   22.094037  544.874936  \n",
       "\n",
       "[809 rows x 22 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df = ipf_df.merge(gpf_df, left_index=True, right_index=True)\n",
    "# print(new_df.columns)\n",
    "new_df.index('')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "P20_008845_1894_XN_09N203W_7\n"
     ]
    },
    {
     "ename": "IndexError",
     "evalue": "only integers, slices (`:`), ellipsis (`...`), numpy.newaxis (`None`) and integer or boolean arrays are valid indices",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mIndexError\u001b[0m                                Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-52-9c95896b4ea2>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      4\u001b[0m \u001b[0msup_dict\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m{\u001b[0m\u001b[0;34m}\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      5\u001b[0m \u001b[0;32mfor\u001b[0m \u001b[0mfiles\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mfiles_dict\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 6\u001b[0;31m     \u001b[0mprint\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mnew_df\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mfiles\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msplit\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'.sup'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      7\u001b[0m     \u001b[0msup_dict\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mfiles\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msplit\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'.sup'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mnew_df\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mfiles\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msplit\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'.sup'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      8\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/envs/autocnet/lib/python3.6/site-packages/pandas/core/indexes/base.py\u001b[0m in \u001b[0;36m__getitem__\u001b[0;34m(self, key)\u001b[0m\n\u001b[1;32m   1741\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1742\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mis_scalar\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1743\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mgetitem\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1744\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1745\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mslice\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mIndexError\u001b[0m: only integers, slices (`:`), ellipsis (`...`), numpy.newaxis (`None`) and integer or boolean arrays are valid indices"
     ]
    }
   ],
   "source": [
    "files_dict = read_atf('CTX_Athabasca_Middle_step0.atf')['IMAGE_SUP']\n",
    "\n",
    "lines_samples_dict = {}\n",
    "for key in files_dict:\n",
    "    with open(key) as f:\n",
    "        if f[0:5] == 'LINES':\n",
    "            lines_samples_dict[]\n",
    "        if f[0:7] == 'SAMPLES':\n",
    "            lines_samples_dict\n",
    "print(new_df.index[800])\n",
    "sup_dict = {}\n",
    "for index in new_df['l.']:\n",
    "    if index in files_dict:\n",
    "            new_df['l.'] = \n",
    "\n",
    "print(sup_dict)\n",
    "        \n",
    "        atf_file = get_path(atf_file);\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)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "diff = ipf_df.index.difference(pd.unique(gpf_df.index))\n",
    "\n",
    "total_similar = 0\n",
    "for i in gpf_df.index:\n",
    "    for j in pd.unique(ipf_df.index):\n",
    "        if i == j:\n",
    "            total_similar += 1\n",
    "diff"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "GEOGCS[\"unnamed ellipse\",\n",
      "    DATUM[\"unknown\",\n",
      "        SPHEROID[\"Unknown\",1737400,0]],\n",
      "    PRIMEM[\"Greenwich\",0],\n",
      "    UNIT[\"Degree\",0.017453292519943295]]\n",
      "GEOGCS[\"unnamed ellipse\",\n",
      "    DATUM[\"unknown\",\n",
      "        SPHEROID[\"Unknown\",1737400,0]],\n",
      "    PRIMEM[\"Greenwich\",0],\n",
      "    UNIT[\"Degree\",0.017453292519943295]]\n"
     ]
    }
   ],
   "source": [
    "\n",
    "# double ToPlanetocentric3(const double lattitude, double eRadius, double pRadius)\n",
    "# {\n",
    "\n",
    "#    double mylat = (lattitude-90.0)*DegToRad;\n",
    "#    if(fabs(mylat)<90.0)\n",
    "#    {\n",
    "#       mylat = atan((tan(mylat) * (pRadius/eRadius) * (pRadius/eRadius)) );\n",
    "#    }\n",
    "#    return (mylat*RadToDeg)+90.0;\n",
    "# }\n",
    "\n",
    "\n",
    "\n",
    "# double ToPlanetocentric4(const double lattitude, double eRadius, double pRadius)\n",
    "# {\n",
    "\n",
    "#    double mylat = (lattitude-90.0)*DegToRad;\n",
    "#    if(fabs(mylat)<90.0)\n",
    "#    {\n",
    "#       double oe = acos(pRadius/eRadius);\n",
    "#       double csqrd = cos(oe)*cos(oe);\n",
    "#       mylat = atan(csqrd*tan(mylat));\n",
    "#    }\n",
    "#    return (mylat*RadToDeg)+90.0;\n",
    "# }\n",
    "\n",
    "\n",
    "test = GeoDataset('/home/tthatcher/Desktop/Projects/Plio/plio/plio/examples/Apollo15/AS15-M-0295_SML_geo.tif')\n",
    "\n",
    "print(test.spatial_reference)\n",
    "print(test.geospatial_coordinate_system)\n",
    "def ToPlanetocentric3(lat, eRadius, pRadius):\n",
    "    mylat = math.radians(lat - 90.0)\n",
    "    \n",
    "    if(math.fabs(mylat) < 90.0):\n",
    "        mylat = math.atan(math.tan(mylat) * (pRadius/eRadius) * (pRadius/eRadius))\n",
    "    \n",
    "    return math.degrees(mylat) + 90.0\n",
    "\n",
    "def ToPlanetocentric4(lat, eRadius, pRadius):\n",
    "    mylat = math.radians(lat - 90.0)\n",
    "    \n",
    "    if(math.fabs(mylat) < 90.0):\n",
    "        oe = math.acos(pRadius/eRadius)\n",
    "        cos_squared = math.cos(oe)**2\n",
    "        mylat = math.atan(cos_squared*(math.tan(mylat)))\n",
    "    \n",
    "    return math.degrees(mylat) + 90.0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}