others/Industrial_Control_System_ICS_Cyber_Attack.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Industrial Control System (ICS) Cyber Attack\n",
    "\n",
    "\n",
    "* ref: https://sites.google.com/a/uah.edu/tommy-morris-uah/ics-data-sets"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 1. download dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "--2018-12-29 15:34:11--  http://www.ece.uah.edu/~thm0009/icsdatasets/binaryAllNaturalPlusNormalVsAttacks.7z\n",
      "Resolving www.ece.uah.edu (www.ece.uah.edu)... 146.229.162.145\n",
      "Connecting to www.ece.uah.edu (www.ece.uah.edu)|146.229.162.145|:80... connected.\n",
      "HTTP request sent, awaiting response... 200 OK\n",
      "Length: 19716777 (19M) [text/plain]\n",
      "Saving to: ‘binaryAllNaturalPlusNormalVsAttacks.7z’\n",
      "\n",
      "binaryAllNaturalPlu 100%[===================>]  18.80M  3.02MB/s    in 11s     \n",
      "\n",
      "2018-12-29 15:34:23 (1.79 MB/s) - ‘binaryAllNaturalPlusNormalVsAttacks.7z’ saved [19716777/19716777]\n",
      "\n"
     ]
    }
   ],
   "source": [
    "! wget http://www.ece.uah.edu/~thm0009/icsdatasets/binaryAllNaturalPlusNormalVsAttacks.7z"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 2. check data\n",
    "\n",
    "* data details: http://www.ece.uah.edu/~thm0009/icsdatasets/PowerSystem_Dataset_README.pdf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "df = pd.read_csv('dataset/data1.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "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>R1-PA1:VH</th>\n",
       "      <th>R1-PM1:V</th>\n",
       "      <th>R1-PA2:VH</th>\n",
       "      <th>R1-PM2:V</th>\n",
       "      <th>R1-PA3:VH</th>\n",
       "      <th>R1-PM3:V</th>\n",
       "      <th>R1-PA4:IH</th>\n",
       "      <th>R1-PM4:I</th>\n",
       "      <th>R1-PA5:IH</th>\n",
       "      <th>R1-PM5:I</th>\n",
       "      <th>...</th>\n",
       "      <th>control_panel_log4</th>\n",
       "      <th>relay1_log</th>\n",
       "      <th>relay2_log</th>\n",
       "      <th>relay3_log</th>\n",
       "      <th>relay4_log</th>\n",
       "      <th>snort_log1</th>\n",
       "      <th>snort_log2</th>\n",
       "      <th>snort_log3</th>\n",
       "      <th>snort_log4</th>\n",
       "      <th>marker</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4961</th>\n",
       "      <td>28.229631</td>\n",
       "      <td>130882.4694</td>\n",
       "      <td>-91.730543</td>\n",
       "      <td>130882.4694</td>\n",
       "      <td>148.264289</td>\n",
       "      <td>130957.6892</td>\n",
       "      <td>25.553918</td>\n",
       "      <td>459.42299</td>\n",
       "      <td>-95.683952</td>\n",
       "      <td>466.93050</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4962</th>\n",
       "      <td>28.195253</td>\n",
       "      <td>130957.6892</td>\n",
       "      <td>-91.770650</td>\n",
       "      <td>130932.6159</td>\n",
       "      <td>148.224182</td>\n",
       "      <td>131032.9090</td>\n",
       "      <td>25.267439</td>\n",
       "      <td>460.70476</td>\n",
       "      <td>-95.752707</td>\n",
       "      <td>467.66294</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4963</th>\n",
       "      <td>28.000447</td>\n",
       "      <td>131057.9823</td>\n",
       "      <td>-91.971185</td>\n",
       "      <td>131057.9823</td>\n",
       "      <td>148.035105</td>\n",
       "      <td>131133.2021</td>\n",
       "      <td>24.316329</td>\n",
       "      <td>464.36696</td>\n",
       "      <td>-96.251180</td>\n",
       "      <td>468.94471</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4964</th>\n",
       "      <td>27.971800</td>\n",
       "      <td>131083.0556</td>\n",
       "      <td>-91.994104</td>\n",
       "      <td>131057.9823</td>\n",
       "      <td>148.006458</td>\n",
       "      <td>131133.2021</td>\n",
       "      <td>24.259033</td>\n",
       "      <td>464.18385</td>\n",
       "      <td>-96.314205</td>\n",
       "      <td>469.12782</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4965</th>\n",
       "      <td>27.931693</td>\n",
       "      <td>131083.0556</td>\n",
       "      <td>-92.034211</td>\n",
       "      <td>131057.9823</td>\n",
       "      <td>147.966351</td>\n",
       "      <td>131133.2021</td>\n",
       "      <td>24.241844</td>\n",
       "      <td>464.00074</td>\n",
       "      <td>-96.342853</td>\n",
       "      <td>469.12782</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 129 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      R1-PA1:VH     R1-PM1:V  R1-PA2:VH     R1-PM2:V   R1-PA3:VH     R1-PM3:V  \\\n",
       "4961  28.229631  130882.4694 -91.730543  130882.4694  148.264289  130957.6892   \n",
       "4962  28.195253  130957.6892 -91.770650  130932.6159  148.224182  131032.9090   \n",
       "4963  28.000447  131057.9823 -91.971185  131057.9823  148.035105  131133.2021   \n",
       "4964  27.971800  131083.0556 -91.994104  131057.9823  148.006458  131133.2021   \n",
       "4965  27.931693  131083.0556 -92.034211  131057.9823  147.966351  131133.2021   \n",
       "\n",
       "      R1-PA4:IH   R1-PM4:I  R1-PA5:IH   R1-PM5:I   ...     control_panel_log4  \\\n",
       "4961  25.553918  459.42299 -95.683952  466.93050   ...                      0   \n",
       "4962  25.267439  460.70476 -95.752707  467.66294   ...                      0   \n",
       "4963  24.316329  464.36696 -96.251180  468.94471   ...                      0   \n",
       "4964  24.259033  464.18385 -96.314205  469.12782   ...                      0   \n",
       "4965  24.241844  464.00074 -96.342853  469.12782   ...                      0   \n",
       "\n",
       "      relay1_log  relay2_log  relay3_log  relay4_log  snort_log1  snort_log2  \\\n",
       "4961           0           0           0           0           0           0   \n",
       "4962           0           0           0           0           0           0   \n",
       "4963           0           0           0           0           0           0   \n",
       "4964           0           0           0           0           0           0   \n",
       "4965           0           0           0           0           0           0   \n",
       "\n",
       "      snort_log3  snort_log4   marker  \n",
       "4961           0           0  Natural  \n",
       "4962           0           0  Natural  \n",
       "4963           0           0  Natural  \n",
       "4964           0           0  Natural  \n",
       "4965           0           0  Natural  \n",
       "\n",
       "[5 rows x 129 columns]"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 3. preprocess"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "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>R1-PA1:VH</th>\n",
       "      <th>R1-PM1:V</th>\n",
       "      <th>R1-PA2:VH</th>\n",
       "      <th>R1-PM2:V</th>\n",
       "      <th>R1-PA3:VH</th>\n",
       "      <th>R1-PM3:V</th>\n",
       "      <th>R1-PA4:IH</th>\n",
       "      <th>R1-PM4:I</th>\n",
       "      <th>R1-PA5:IH</th>\n",
       "      <th>R1-PM5:I</th>\n",
       "      <th>...</th>\n",
       "      <th>control_panel_log4</th>\n",
       "      <th>relay1_log</th>\n",
       "      <th>relay2_log</th>\n",
       "      <th>relay3_log</th>\n",
       "      <th>relay4_log</th>\n",
       "      <th>snort_log1</th>\n",
       "      <th>snort_log2</th>\n",
       "      <th>snort_log3</th>\n",
       "      <th>snort_log4</th>\n",
       "      <th>marker</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>70.399324</td>\n",
       "      <td>127673.0908</td>\n",
       "      <td>-49.572308</td>\n",
       "      <td>127648.0176</td>\n",
       "      <td>-169.578319</td>\n",
       "      <td>127723.2374</td>\n",
       "      <td>65.689611</td>\n",
       "      <td>605.91099</td>\n",
       "      <td>-57.003571</td>\n",
       "      <td>626.78553</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>73.688102</td>\n",
       "      <td>130280.7109</td>\n",
       "      <td>-46.300719</td>\n",
       "      <td>130255.6377</td>\n",
       "      <td>-166.278082</td>\n",
       "      <td>130355.9307</td>\n",
       "      <td>71.831719</td>\n",
       "      <td>483.59351</td>\n",
       "      <td>-50.947407</td>\n",
       "      <td>500.98896</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>73.733939</td>\n",
       "      <td>130305.7842</td>\n",
       "      <td>-46.254883</td>\n",
       "      <td>130280.7109</td>\n",
       "      <td>-166.232245</td>\n",
       "      <td>130381.0040</td>\n",
       "      <td>71.808800</td>\n",
       "      <td>483.59351</td>\n",
       "      <td>-50.913030</td>\n",
       "      <td>500.98896</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>74.083443</td>\n",
       "      <td>130581.5902</td>\n",
       "      <td>-45.899649</td>\n",
       "      <td>130556.5169</td>\n",
       "      <td>-165.882741</td>\n",
       "      <td>130656.8100</td>\n",
       "      <td>72.152575</td>\n",
       "      <td>482.86107</td>\n",
       "      <td>-50.437475</td>\n",
       "      <td>499.15786</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>74.553268</td>\n",
       "      <td>131083.0556</td>\n",
       "      <td>-45.424094</td>\n",
       "      <td>131057.9823</td>\n",
       "      <td>-165.424375</td>\n",
       "      <td>131158.2754</td>\n",
       "      <td>72.118198</td>\n",
       "      <td>484.50906</td>\n",
       "      <td>-50.013486</td>\n",
       "      <td>497.69298</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>74.547539</td>\n",
       "      <td>131057.9823</td>\n",
       "      <td>-45.441283</td>\n",
       "      <td>131032.9090</td>\n",
       "      <td>-165.441563</td>\n",
       "      <td>131133.2021</td>\n",
       "      <td>71.780153</td>\n",
       "      <td>486.52327</td>\n",
       "      <td>-50.179644</td>\n",
       "      <td>498.05920</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>74.536080</td>\n",
       "      <td>131007.8358</td>\n",
       "      <td>-45.458471</td>\n",
       "      <td>131007.8358</td>\n",
       "      <td>-165.453023</td>\n",
       "      <td>131083.0556</td>\n",
       "      <td>71.671291</td>\n",
       "      <td>487.07260</td>\n",
       "      <td>-50.185373</td>\n",
       "      <td>497.87609</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>74.501702</td>\n",
       "      <td>130982.7625</td>\n",
       "      <td>-45.475660</td>\n",
       "      <td>130957.6892</td>\n",
       "      <td>-165.475941</td>\n",
       "      <td>131057.9823</td>\n",
       "      <td>71.528051</td>\n",
       "      <td>487.98815</td>\n",
       "      <td>-50.191103</td>\n",
       "      <td>498.05920</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>74.444406</td>\n",
       "      <td>130932.6159</td>\n",
       "      <td>-45.532956</td>\n",
       "      <td>130932.6159</td>\n",
       "      <td>-165.521777</td>\n",
       "      <td>131007.8358</td>\n",
       "      <td>71.224384</td>\n",
       "      <td>489.45303</td>\n",
       "      <td>-50.362990</td>\n",
       "      <td>498.79164</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>74.283978</td>\n",
       "      <td>130857.3961</td>\n",
       "      <td>-45.716302</td>\n",
       "      <td>130857.3961</td>\n",
       "      <td>-165.705124</td>\n",
       "      <td>130932.6159</td>\n",
       "      <td>70.605589</td>\n",
       "      <td>491.65035</td>\n",
       "      <td>-50.632280</td>\n",
       "      <td>499.34097</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>74.089172</td>\n",
       "      <td>130832.3229</td>\n",
       "      <td>-45.893919</td>\n",
       "      <td>130832.3229</td>\n",
       "      <td>-165.894200</td>\n",
       "      <td>130932.6159</td>\n",
       "      <td>70.009713</td>\n",
       "      <td>494.21389</td>\n",
       "      <td>-50.958866</td>\n",
       "      <td>499.52408</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>73.888637</td>\n",
       "      <td>130832.3229</td>\n",
       "      <td>-46.088725</td>\n",
       "      <td>130807.2496</td>\n",
       "      <td>-166.094735</td>\n",
       "      <td>130907.5427</td>\n",
       "      <td>69.562806</td>\n",
       "      <td>497.69298</td>\n",
       "      <td>-51.210968</td>\n",
       "      <td>501.35518</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>73.705291</td>\n",
       "      <td>130807.2496</td>\n",
       "      <td>-46.289260</td>\n",
       "      <td>130807.2496</td>\n",
       "      <td>-166.272352</td>\n",
       "      <td>130907.5427</td>\n",
       "      <td>69.121628</td>\n",
       "      <td>498.79164</td>\n",
       "      <td>-51.434421</td>\n",
       "      <td>501.17207</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>73.682372</td>\n",
       "      <td>130832.3229</td>\n",
       "      <td>-46.312179</td>\n",
       "      <td>130807.2496</td>\n",
       "      <td>-166.289541</td>\n",
       "      <td>130907.5427</td>\n",
       "      <td>69.092981</td>\n",
       "      <td>498.97475</td>\n",
       "      <td>-51.445880</td>\n",
       "      <td>501.35518</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>73.653725</td>\n",
       "      <td>130832.3229</td>\n",
       "      <td>-46.340826</td>\n",
       "      <td>130807.2496</td>\n",
       "      <td>-166.341107</td>\n",
       "      <td>130907.5427</td>\n",
       "      <td>69.052873</td>\n",
       "      <td>498.97475</td>\n",
       "      <td>-51.520365</td>\n",
       "      <td>501.35518</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>73.413082</td>\n",
       "      <td>130832.3229</td>\n",
       "      <td>-46.581469</td>\n",
       "      <td>130782.1763</td>\n",
       "      <td>-166.570290</td>\n",
       "      <td>130907.5427</td>\n",
       "      <td>68.668992</td>\n",
       "      <td>500.25652</td>\n",
       "      <td>-51.732359</td>\n",
       "      <td>500.80585</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>73.206817</td>\n",
       "      <td>130832.3229</td>\n",
       "      <td>-46.782004</td>\n",
       "      <td>130807.2496</td>\n",
       "      <td>-166.782285</td>\n",
       "      <td>130907.5427</td>\n",
       "      <td>68.365324</td>\n",
       "      <td>500.98896</td>\n",
       "      <td>-51.875599</td>\n",
       "      <td>500.80585</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>73.201088</td>\n",
       "      <td>130832.3229</td>\n",
       "      <td>-46.793463</td>\n",
       "      <td>130782.1763</td>\n",
       "      <td>-166.782285</td>\n",
       "      <td>130907.5427</td>\n",
       "      <td>68.388242</td>\n",
       "      <td>500.80585</td>\n",
       "      <td>-51.921435</td>\n",
       "      <td>500.62274</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>73.092226</td>\n",
       "      <td>130832.3229</td>\n",
       "      <td>-46.873677</td>\n",
       "      <td>130807.2496</td>\n",
       "      <td>-166.885417</td>\n",
       "      <td>130882.4694</td>\n",
       "      <td>68.239273</td>\n",
       "      <td>500.98896</td>\n",
       "      <td>-51.955813</td>\n",
       "      <td>500.80585</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>73.080767</td>\n",
       "      <td>130832.3229</td>\n",
       "      <td>-46.890866</td>\n",
       "      <td>130807.2496</td>\n",
       "      <td>-166.908335</td>\n",
       "      <td>130907.5427</td>\n",
       "      <td>68.210626</td>\n",
       "      <td>501.17207</td>\n",
       "      <td>-52.018838</td>\n",
       "      <td>500.80585</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>77.481083</td>\n",
       "      <td>133289.5033</td>\n",
       "      <td>-42.490550</td>\n",
       "      <td>133264.4301</td>\n",
       "      <td>-162.508019</td>\n",
       "      <td>133364.7231</td>\n",
       "      <td>78.225928</td>\n",
       "      <td>281.44007</td>\n",
       "      <td>-42.020725</td>\n",
       "      <td>280.15830</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>79.629674</td>\n",
       "      <td>132085.9864</td>\n",
       "      <td>-40.341958</td>\n",
       "      <td>132035.8398</td>\n",
       "      <td>-160.359428</td>\n",
       "      <td>132161.2062</td>\n",
       "      <td>80.076581</td>\n",
       "      <td>281.98940</td>\n",
       "      <td>-40.084127</td>\n",
       "      <td>280.89074</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>85.382171</td>\n",
       "      <td>132311.6458</td>\n",
       "      <td>-34.583733</td>\n",
       "      <td>132286.5725</td>\n",
       "      <td>-154.595472</td>\n",
       "      <td>132386.8656</td>\n",
       "      <td>85.703027</td>\n",
       "      <td>281.80629</td>\n",
       "      <td>-34.079530</td>\n",
       "      <td>280.70763</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>85.336334</td>\n",
       "      <td>132286.5725</td>\n",
       "      <td>-34.641028</td>\n",
       "      <td>132261.4993</td>\n",
       "      <td>-154.641309</td>\n",
       "      <td>132361.7923</td>\n",
       "      <td>85.628542</td>\n",
       "      <td>281.62318</td>\n",
       "      <td>-34.171203</td>\n",
       "      <td>281.07385</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>85.204554</td>\n",
       "      <td>132261.4993</td>\n",
       "      <td>-34.767079</td>\n",
       "      <td>132211.3527</td>\n",
       "      <td>-154.767360</td>\n",
       "      <td>132336.7191</td>\n",
       "      <td>85.450926</td>\n",
       "      <td>281.80629</td>\n",
       "      <td>-34.297254</td>\n",
       "      <td>281.44007</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>78.008204</td>\n",
       "      <td>131133.2021</td>\n",
       "      <td>-41.957699</td>\n",
       "      <td>131083.0556</td>\n",
       "      <td>-161.969439</td>\n",
       "      <td>131183.3486</td>\n",
       "      <td>75.023094</td>\n",
       "      <td>402.29267</td>\n",
       "      <td>-44.782381</td>\n",
       "      <td>402.47578</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>77.956638</td>\n",
       "      <td>131108.1288</td>\n",
       "      <td>-42.009266</td>\n",
       "      <td>131083.0556</td>\n",
       "      <td>-162.021005</td>\n",
       "      <td>131158.2754</td>\n",
       "      <td>74.988716</td>\n",
       "      <td>402.10956</td>\n",
       "      <td>-44.833947</td>\n",
       "      <td>402.65889</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>77.154497</td>\n",
       "      <td>131007.8358</td>\n",
       "      <td>-42.811406</td>\n",
       "      <td>130982.7625</td>\n",
       "      <td>-162.823146</td>\n",
       "      <td>131057.9823</td>\n",
       "      <td>74.152198</td>\n",
       "      <td>402.65889</td>\n",
       "      <td>-45.676195</td>\n",
       "      <td>403.20822</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>76.908125</td>\n",
       "      <td>131208.4219</td>\n",
       "      <td>-43.057778</td>\n",
       "      <td>131183.3486</td>\n",
       "      <td>-163.069518</td>\n",
       "      <td>131283.6417</td>\n",
       "      <td>73.963122</td>\n",
       "      <td>402.10956</td>\n",
       "      <td>-45.899649</td>\n",
       "      <td>402.84200</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>76.678942</td>\n",
       "      <td>131509.3012</td>\n",
       "      <td>-43.286961</td>\n",
       "      <td>131484.2279</td>\n",
       "      <td>-163.298701</td>\n",
       "      <td>131584.5210</td>\n",
       "      <td>73.751127</td>\n",
       "      <td>401.01090</td>\n",
       "      <td>-46.077266</td>\n",
       "      <td>401.92645</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</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>4936</th>\n",
       "      <td>-27.914504</td>\n",
       "      <td>131183.3486</td>\n",
       "      <td>-147.891866</td>\n",
       "      <td>131133.2021</td>\n",
       "      <td>92.108695</td>\n",
       "      <td>131258.5685</td>\n",
       "      <td>-28.092121</td>\n",
       "      <td>411.44817</td>\n",
       "      <td>-150.676441</td>\n",
       "      <td>422.80099</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4937</th>\n",
       "      <td>-27.948881</td>\n",
       "      <td>131233.4952</td>\n",
       "      <td>-147.903325</td>\n",
       "      <td>131208.4219</td>\n",
       "      <td>92.080047</td>\n",
       "      <td>131308.7150</td>\n",
       "      <td>-28.189524</td>\n",
       "      <td>411.81439</td>\n",
       "      <td>-150.750925</td>\n",
       "      <td>422.98410</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4938</th>\n",
       "      <td>-28.166605</td>\n",
       "      <td>131409.0081</td>\n",
       "      <td>-148.132508</td>\n",
       "      <td>131358.8615</td>\n",
       "      <td>91.850864</td>\n",
       "      <td>131459.1546</td>\n",
       "      <td>-29.822453</td>\n",
       "      <td>418.04013</td>\n",
       "      <td>-151.289506</td>\n",
       "      <td>423.89965</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4939</th>\n",
       "      <td>5.746767</td>\n",
       "      <td>133740.8222</td>\n",
       "      <td>-114.213407</td>\n",
       "      <td>133715.7489</td>\n",
       "      <td>125.781425</td>\n",
       "      <td>133790.9687</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4940</th>\n",
       "      <td>-24.259033</td>\n",
       "      <td>133540.2360</td>\n",
       "      <td>-144.236395</td>\n",
       "      <td>133515.1628</td>\n",
       "      <td>95.769895</td>\n",
       "      <td>133615.4558</td>\n",
       "      <td>-19.967579</td>\n",
       "      <td>405.58865</td>\n",
       "      <td>-140.351742</td>\n",
       "      <td>409.06774</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4941</th>\n",
       "      <td>-28.974476</td>\n",
       "      <td>130907.5427</td>\n",
       "      <td>-148.940379</td>\n",
       "      <td>130882.4694</td>\n",
       "      <td>91.048723</td>\n",
       "      <td>130957.6892</td>\n",
       "      <td>-29.157822</td>\n",
       "      <td>409.98329</td>\n",
       "      <td>-149.324261</td>\n",
       "      <td>411.81439</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4942</th>\n",
       "      <td>-28.997394</td>\n",
       "      <td>131007.8358</td>\n",
       "      <td>-148.969027</td>\n",
       "      <td>130982.7625</td>\n",
       "      <td>91.020075</td>\n",
       "      <td>131057.9823</td>\n",
       "      <td>-29.524515</td>\n",
       "      <td>411.81439</td>\n",
       "      <td>-149.771168</td>\n",
       "      <td>413.82860</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4943</th>\n",
       "      <td>-29.232307</td>\n",
       "      <td>131383.9348</td>\n",
       "      <td>-149.203939</td>\n",
       "      <td>131358.8615</td>\n",
       "      <td>90.790892</td>\n",
       "      <td>131434.0813</td>\n",
       "      <td>-31.461113</td>\n",
       "      <td>419.87123</td>\n",
       "      <td>-151.587444</td>\n",
       "      <td>421.33611</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4944</th>\n",
       "      <td>-29.467219</td>\n",
       "      <td>131409.0081</td>\n",
       "      <td>-149.433122</td>\n",
       "      <td>131383.9348</td>\n",
       "      <td>90.550250</td>\n",
       "      <td>131459.1546</td>\n",
       "      <td>-32.228876</td>\n",
       "      <td>421.51922</td>\n",
       "      <td>-152.114565</td>\n",
       "      <td>422.43477</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4945</th>\n",
       "      <td>37.981372</td>\n",
       "      <td>136849.9077</td>\n",
       "      <td>-81.984531</td>\n",
       "      <td>136824.8344</td>\n",
       "      <td>158.016030</td>\n",
       "      <td>136900.0542</td>\n",
       "      <td>41.161288</td>\n",
       "      <td>413.82860</td>\n",
       "      <td>-84.900886</td>\n",
       "      <td>445.50663</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4946</th>\n",
       "      <td>32.480977</td>\n",
       "      <td>131383.9348</td>\n",
       "      <td>-87.490655</td>\n",
       "      <td>131333.7883</td>\n",
       "      <td>152.509906</td>\n",
       "      <td>131434.0813</td>\n",
       "      <td>33.793051</td>\n",
       "      <td>436.53424</td>\n",
       "      <td>-91.673247</td>\n",
       "      <td>465.83184</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4947</th>\n",
       "      <td>30.200605</td>\n",
       "      <td>129979.8317</td>\n",
       "      <td>-89.782487</td>\n",
       "      <td>129929.6851</td>\n",
       "      <td>150.212345</td>\n",
       "      <td>130029.9782</td>\n",
       "      <td>30.355304</td>\n",
       "      <td>447.88706</td>\n",
       "      <td>-93.552549</td>\n",
       "      <td>469.12782</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4948</th>\n",
       "      <td>29.696403</td>\n",
       "      <td>130080.1248</td>\n",
       "      <td>-90.275230</td>\n",
       "      <td>130029.9782</td>\n",
       "      <td>149.713872</td>\n",
       "      <td>130130.2713</td>\n",
       "      <td>29.329710</td>\n",
       "      <td>451.54926</td>\n",
       "      <td>-94.073940</td>\n",
       "      <td>469.12782</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4949</th>\n",
       "      <td>29.398464</td>\n",
       "      <td>130907.5427</td>\n",
       "      <td>-90.555980</td>\n",
       "      <td>130882.4694</td>\n",
       "      <td>149.427393</td>\n",
       "      <td>130957.6892</td>\n",
       "      <td>27.628025</td>\n",
       "      <td>457.40878</td>\n",
       "      <td>-94.469281</td>\n",
       "      <td>467.29672</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4950</th>\n",
       "      <td>30.870966</td>\n",
       "      <td>116590.7055</td>\n",
       "      <td>-89.163692</td>\n",
       "      <td>130456.2238</td>\n",
       "      <td>148.178345</td>\n",
       "      <td>128676.0216</td>\n",
       "      <td>22.987067</td>\n",
       "      <td>485.05839</td>\n",
       "      <td>-90.097613</td>\n",
       "      <td>485.24150</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4951</th>\n",
       "      <td>55.519610</td>\n",
       "      <td>134292.4341</td>\n",
       "      <td>-64.463482</td>\n",
       "      <td>134267.3609</td>\n",
       "      <td>175.537080</td>\n",
       "      <td>134367.6539</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4952</th>\n",
       "      <td>56.470720</td>\n",
       "      <td>134593.3134</td>\n",
       "      <td>-63.500912</td>\n",
       "      <td>134543.1668</td>\n",
       "      <td>176.511108</td>\n",
       "      <td>134643.4599</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4953</th>\n",
       "      <td>59.742309</td>\n",
       "      <td>135144.9253</td>\n",
       "      <td>-60.240783</td>\n",
       "      <td>135119.8520</td>\n",
       "      <td>179.776967</td>\n",
       "      <td>135220.1451</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4954</th>\n",
       "      <td>64.921848</td>\n",
       "      <td>134016.6282</td>\n",
       "      <td>-55.044055</td>\n",
       "      <td>133991.5549</td>\n",
       "      <td>-175.055795</td>\n",
       "      <td>134091.8480</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4955</th>\n",
       "      <td>65.683882</td>\n",
       "      <td>135495.9511</td>\n",
       "      <td>-54.184619</td>\n",
       "      <td>135546.0976</td>\n",
       "      <td>-174.196359</td>\n",
       "      <td>135696.5372</td>\n",
       "      <td>155.374695</td>\n",
       "      <td>64.08850</td>\n",
       "      <td>34.555085</td>\n",
       "      <td>64.45472</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4956</th>\n",
       "      <td>40.828972</td>\n",
       "      <td>133515.1628</td>\n",
       "      <td>-79.136931</td>\n",
       "      <td>133490.0895</td>\n",
       "      <td>160.852171</td>\n",
       "      <td>133590.3826</td>\n",
       "      <td>52.620444</td>\n",
       "      <td>521.31417</td>\n",
       "      <td>-76.936773</td>\n",
       "      <td>610.67185</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4957</th>\n",
       "      <td>36.589085</td>\n",
       "      <td>134869.1193</td>\n",
       "      <td>-83.382548</td>\n",
       "      <td>134844.0461</td>\n",
       "      <td>156.629473</td>\n",
       "      <td>134944.3391</td>\n",
       "      <td>40.387795</td>\n",
       "      <td>482.49485</td>\n",
       "      <td>-82.775213</td>\n",
       "      <td>502.27073</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4958</th>\n",
       "      <td>28.418707</td>\n",
       "      <td>129929.6851</td>\n",
       "      <td>-91.552926</td>\n",
       "      <td>129904.6119</td>\n",
       "      <td>148.453365</td>\n",
       "      <td>129979.8317</td>\n",
       "      <td>28.647890</td>\n",
       "      <td>442.57687</td>\n",
       "      <td>-93.288988</td>\n",
       "      <td>454.29591</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4959</th>\n",
       "      <td>28.309845</td>\n",
       "      <td>130255.6377</td>\n",
       "      <td>-91.650329</td>\n",
       "      <td>130230.5644</td>\n",
       "      <td>148.338773</td>\n",
       "      <td>130330.8575</td>\n",
       "      <td>27.473326</td>\n",
       "      <td>449.71816</td>\n",
       "      <td>-94.389067</td>\n",
       "      <td>459.97232</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4960</th>\n",
       "      <td>28.246819</td>\n",
       "      <td>130807.2496</td>\n",
       "      <td>-91.713354</td>\n",
       "      <td>130782.1763</td>\n",
       "      <td>148.287207</td>\n",
       "      <td>130882.4694</td>\n",
       "      <td>25.760182</td>\n",
       "      <td>458.14122</td>\n",
       "      <td>-95.494876</td>\n",
       "      <td>466.01495</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4961</th>\n",
       "      <td>28.229631</td>\n",
       "      <td>130882.4694</td>\n",
       "      <td>-91.730543</td>\n",
       "      <td>130882.4694</td>\n",
       "      <td>148.264289</td>\n",
       "      <td>130957.6892</td>\n",
       "      <td>25.553918</td>\n",
       "      <td>459.42299</td>\n",
       "      <td>-95.683952</td>\n",
       "      <td>466.93050</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4962</th>\n",
       "      <td>28.195253</td>\n",
       "      <td>130957.6892</td>\n",
       "      <td>-91.770650</td>\n",
       "      <td>130932.6159</td>\n",
       "      <td>148.224182</td>\n",
       "      <td>131032.9090</td>\n",
       "      <td>25.267439</td>\n",
       "      <td>460.70476</td>\n",
       "      <td>-95.752707</td>\n",
       "      <td>467.66294</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4963</th>\n",
       "      <td>28.000447</td>\n",
       "      <td>131057.9823</td>\n",
       "      <td>-91.971185</td>\n",
       "      <td>131057.9823</td>\n",
       "      <td>148.035105</td>\n",
       "      <td>131133.2021</td>\n",
       "      <td>24.316329</td>\n",
       "      <td>464.36696</td>\n",
       "      <td>-96.251180</td>\n",
       "      <td>468.94471</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4964</th>\n",
       "      <td>27.971800</td>\n",
       "      <td>131083.0556</td>\n",
       "      <td>-91.994104</td>\n",
       "      <td>131057.9823</td>\n",
       "      <td>148.006458</td>\n",
       "      <td>131133.2021</td>\n",
       "      <td>24.259033</td>\n",
       "      <td>464.18385</td>\n",
       "      <td>-96.314205</td>\n",
       "      <td>469.12782</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4965</th>\n",
       "      <td>27.931693</td>\n",
       "      <td>131083.0556</td>\n",
       "      <td>-92.034211</td>\n",
       "      <td>131057.9823</td>\n",
       "      <td>147.966351</td>\n",
       "      <td>131133.2021</td>\n",
       "      <td>24.241844</td>\n",
       "      <td>464.00074</td>\n",
       "      <td>-96.342853</td>\n",
       "      <td>469.12782</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Natural</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4966 rows × 129 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      R1-PA1:VH     R1-PM1:V   R1-PA2:VH     R1-PM2:V   R1-PA3:VH  \\\n",
       "0     70.399324  127673.0908  -49.572308  127648.0176 -169.578319   \n",
       "1     73.688102  130280.7109  -46.300719  130255.6377 -166.278082   \n",
       "2     73.733939  130305.7842  -46.254883  130280.7109 -166.232245   \n",
       "3     74.083443  130581.5902  -45.899649  130556.5169 -165.882741   \n",
       "4     74.553268  131083.0556  -45.424094  131057.9823 -165.424375   \n",
       "5     74.547539  131057.9823  -45.441283  131032.9090 -165.441563   \n",
       "6     74.536080  131007.8358  -45.458471  131007.8358 -165.453023   \n",
       "7     74.501702  130982.7625  -45.475660  130957.6892 -165.475941   \n",
       "8     74.444406  130932.6159  -45.532956  130932.6159 -165.521777   \n",
       "9     74.283978  130857.3961  -45.716302  130857.3961 -165.705124   \n",
       "10    74.089172  130832.3229  -45.893919  130832.3229 -165.894200   \n",
       "11    73.888637  130832.3229  -46.088725  130807.2496 -166.094735   \n",
       "12    73.705291  130807.2496  -46.289260  130807.2496 -166.272352   \n",
       "13    73.682372  130832.3229  -46.312179  130807.2496 -166.289541   \n",
       "14    73.653725  130832.3229  -46.340826  130807.2496 -166.341107   \n",
       "15    73.413082  130832.3229  -46.581469  130782.1763 -166.570290   \n",
       "16    73.206817  130832.3229  -46.782004  130807.2496 -166.782285   \n",
       "17    73.201088  130832.3229  -46.793463  130782.1763 -166.782285   \n",
       "18    73.092226  130832.3229  -46.873677  130807.2496 -166.885417   \n",
       "19    73.080767  130832.3229  -46.890866  130807.2496 -166.908335   \n",
       "20    77.481083  133289.5033  -42.490550  133264.4301 -162.508019   \n",
       "21    79.629674  132085.9864  -40.341958  132035.8398 -160.359428   \n",
       "22    85.382171  132311.6458  -34.583733  132286.5725 -154.595472   \n",
       "23    85.336334  132286.5725  -34.641028  132261.4993 -154.641309   \n",
       "24    85.204554  132261.4993  -34.767079  132211.3527 -154.767360   \n",
       "25    78.008204  131133.2021  -41.957699  131083.0556 -161.969439   \n",
       "26    77.956638  131108.1288  -42.009266  131083.0556 -162.021005   \n",
       "27    77.154497  131007.8358  -42.811406  130982.7625 -162.823146   \n",
       "28    76.908125  131208.4219  -43.057778  131183.3486 -163.069518   \n",
       "29    76.678942  131509.3012  -43.286961  131484.2279 -163.298701   \n",
       "...         ...          ...         ...          ...         ...   \n",
       "4936 -27.914504  131183.3486 -147.891866  131133.2021   92.108695   \n",
       "4937 -27.948881  131233.4952 -147.903325  131208.4219   92.080047   \n",
       "4938 -28.166605  131409.0081 -148.132508  131358.8615   91.850864   \n",
       "4939   5.746767  133740.8222 -114.213407  133715.7489  125.781425   \n",
       "4940 -24.259033  133540.2360 -144.236395  133515.1628   95.769895   \n",
       "4941 -28.974476  130907.5427 -148.940379  130882.4694   91.048723   \n",
       "4942 -28.997394  131007.8358 -148.969027  130982.7625   91.020075   \n",
       "4943 -29.232307  131383.9348 -149.203939  131358.8615   90.790892   \n",
       "4944 -29.467219  131409.0081 -149.433122  131383.9348   90.550250   \n",
       "4945  37.981372  136849.9077  -81.984531  136824.8344  158.016030   \n",
       "4946  32.480977  131383.9348  -87.490655  131333.7883  152.509906   \n",
       "4947  30.200605  129979.8317  -89.782487  129929.6851  150.212345   \n",
       "4948  29.696403  130080.1248  -90.275230  130029.9782  149.713872   \n",
       "4949  29.398464  130907.5427  -90.555980  130882.4694  149.427393   \n",
       "4950  30.870966  116590.7055  -89.163692  130456.2238  148.178345   \n",
       "4951  55.519610  134292.4341  -64.463482  134267.3609  175.537080   \n",
       "4952  56.470720  134593.3134  -63.500912  134543.1668  176.511108   \n",
       "4953  59.742309  135144.9253  -60.240783  135119.8520  179.776967   \n",
       "4954  64.921848  134016.6282  -55.044055  133991.5549 -175.055795   \n",
       "4955  65.683882  135495.9511  -54.184619  135546.0976 -174.196359   \n",
       "4956  40.828972  133515.1628  -79.136931  133490.0895  160.852171   \n",
       "4957  36.589085  134869.1193  -83.382548  134844.0461  156.629473   \n",
       "4958  28.418707  129929.6851  -91.552926  129904.6119  148.453365   \n",
       "4959  28.309845  130255.6377  -91.650329  130230.5644  148.338773   \n",
       "4960  28.246819  130807.2496  -91.713354  130782.1763  148.287207   \n",
       "4961  28.229631  130882.4694  -91.730543  130882.4694  148.264289   \n",
       "4962  28.195253  130957.6892  -91.770650  130932.6159  148.224182   \n",
       "4963  28.000447  131057.9823  -91.971185  131057.9823  148.035105   \n",
       "4964  27.971800  131083.0556  -91.994104  131057.9823  148.006458   \n",
       "4965  27.931693  131083.0556  -92.034211  131057.9823  147.966351   \n",
       "\n",
       "         R1-PM3:V   R1-PA4:IH   R1-PM4:I   R1-PA5:IH   R1-PM5:I   ...     \\\n",
       "0     127723.2374   65.689611  605.91099  -57.003571  626.78553   ...      \n",
       "1     130355.9307   71.831719  483.59351  -50.947407  500.98896   ...      \n",
       "2     130381.0040   71.808800  483.59351  -50.913030  500.98896   ...      \n",
       "3     130656.8100   72.152575  482.86107  -50.437475  499.15786   ...      \n",
       "4     131158.2754   72.118198  484.50906  -50.013486  497.69298   ...      \n",
       "5     131133.2021   71.780153  486.52327  -50.179644  498.05920   ...      \n",
       "6     131083.0556   71.671291  487.07260  -50.185373  497.87609   ...      \n",
       "7     131057.9823   71.528051  487.98815  -50.191103  498.05920   ...      \n",
       "8     131007.8358   71.224384  489.45303  -50.362990  498.79164   ...      \n",
       "9     130932.6159   70.605589  491.65035  -50.632280  499.34097   ...      \n",
       "10    130932.6159   70.009713  494.21389  -50.958866  499.52408   ...      \n",
       "11    130907.5427   69.562806  497.69298  -51.210968  501.35518   ...      \n",
       "12    130907.5427   69.121628  498.79164  -51.434421  501.17207   ...      \n",
       "13    130907.5427   69.092981  498.97475  -51.445880  501.35518   ...      \n",
       "14    130907.5427   69.052873  498.97475  -51.520365  501.35518   ...      \n",
       "15    130907.5427   68.668992  500.25652  -51.732359  500.80585   ...      \n",
       "16    130907.5427   68.365324  500.98896  -51.875599  500.80585   ...      \n",
       "17    130907.5427   68.388242  500.80585  -51.921435  500.62274   ...      \n",
       "18    130882.4694   68.239273  500.98896  -51.955813  500.80585   ...      \n",
       "19    130907.5427   68.210626  501.17207  -52.018838  500.80585   ...      \n",
       "20    133364.7231   78.225928  281.44007  -42.020725  280.15830   ...      \n",
       "21    132161.2062   80.076581  281.98940  -40.084127  280.89074   ...      \n",
       "22    132386.8656   85.703027  281.80629  -34.079530  280.70763   ...      \n",
       "23    132361.7923   85.628542  281.62318  -34.171203  281.07385   ...      \n",
       "24    132336.7191   85.450926  281.80629  -34.297254  281.44007   ...      \n",
       "25    131183.3486   75.023094  402.29267  -44.782381  402.47578   ...      \n",
       "26    131158.2754   74.988716  402.10956  -44.833947  402.65889   ...      \n",
       "27    131057.9823   74.152198  402.65889  -45.676195  403.20822   ...      \n",
       "28    131283.6417   73.963122  402.10956  -45.899649  402.84200   ...      \n",
       "29    131584.5210   73.751127  401.01090  -46.077266  401.92645   ...      \n",
       "...           ...         ...        ...         ...        ...   ...      \n",
       "4936  131258.5685  -28.092121  411.44817 -150.676441  422.80099   ...      \n",
       "4937  131308.7150  -28.189524  411.81439 -150.750925  422.98410   ...      \n",
       "4938  131459.1546  -29.822453  418.04013 -151.289506  423.89965   ...      \n",
       "4939  133790.9687    0.000000    0.00000    0.000000    0.00000   ...      \n",
       "4940  133615.4558  -19.967579  405.58865 -140.351742  409.06774   ...      \n",
       "4941  130957.6892  -29.157822  409.98329 -149.324261  411.81439   ...      \n",
       "4942  131057.9823  -29.524515  411.81439 -149.771168  413.82860   ...      \n",
       "4943  131434.0813  -31.461113  419.87123 -151.587444  421.33611   ...      \n",
       "4944  131459.1546  -32.228876  421.51922 -152.114565  422.43477   ...      \n",
       "4945  136900.0542   41.161288  413.82860  -84.900886  445.50663   ...      \n",
       "4946  131434.0813   33.793051  436.53424  -91.673247  465.83184   ...      \n",
       "4947  130029.9782   30.355304  447.88706  -93.552549  469.12782   ...      \n",
       "4948  130130.2713   29.329710  451.54926  -94.073940  469.12782   ...      \n",
       "4949  130957.6892   27.628025  457.40878  -94.469281  467.29672   ...      \n",
       "4950  128676.0216   22.987067  485.05839  -90.097613  485.24150   ...      \n",
       "4951  134367.6539    0.000000    0.00000    0.000000    0.00000   ...      \n",
       "4952  134643.4599    0.000000    0.00000    0.000000    0.00000   ...      \n",
       "4953  135220.1451    0.000000    0.00000    0.000000    0.00000   ...      \n",
       "4954  134091.8480    0.000000    0.00000    0.000000    0.00000   ...      \n",
       "4955  135696.5372  155.374695   64.08850   34.555085   64.45472   ...      \n",
       "4956  133590.3826   52.620444  521.31417  -76.936773  610.67185   ...      \n",
       "4957  134944.3391   40.387795  482.49485  -82.775213  502.27073   ...      \n",
       "4958  129979.8317   28.647890  442.57687  -93.288988  454.29591   ...      \n",
       "4959  130330.8575   27.473326  449.71816  -94.389067  459.97232   ...      \n",
       "4960  130882.4694   25.760182  458.14122  -95.494876  466.01495   ...      \n",
       "4961  130957.6892   25.553918  459.42299  -95.683952  466.93050   ...      \n",
       "4962  131032.9090   25.267439  460.70476  -95.752707  467.66294   ...      \n",
       "4963  131133.2021   24.316329  464.36696  -96.251180  468.94471   ...      \n",
       "4964  131133.2021   24.259033  464.18385  -96.314205  469.12782   ...      \n",
       "4965  131133.2021   24.241844  464.00074  -96.342853  469.12782   ...      \n",
       "\n",
       "      control_panel_log4  relay1_log  relay2_log  relay3_log  relay4_log  \\\n",
       "0                      0           0           0           0           0   \n",
       "1                      0           0           0           0           0   \n",
       "2                      0           0           0           0           0   \n",
       "3                      0           0           0           0           0   \n",
       "4                      0           0           0           0           0   \n",
       "5                      0           0           0           0           0   \n",
       "6                      0           0           0           0           0   \n",
       "7                      0           0           0           0           0   \n",
       "8                      0           0           0           0           0   \n",
       "9                      0           0           0           0           0   \n",
       "10                     0           0           0           0           0   \n",
       "11                     0           0           0           0           0   \n",
       "12                     0           0           0           0           0   \n",
       "13                     0           0           0           0           0   \n",
       "14                     0           0           0           0           0   \n",
       "15                     0           0           0           0           0   \n",
       "16                     0           0           0           0           0   \n",
       "17                     0           0           0           0           0   \n",
       "18                     0           0           0           0           0   \n",
       "19                     0           0           0           0           0   \n",
       "20                     0           0           0           0           0   \n",
       "21                     0           0           0           0           0   \n",
       "22                     0           0           0           0           0   \n",
       "23                     0           0           0           0           0   \n",
       "24                     0           0           0           0           0   \n",
       "25                     0           0           0           0           0   \n",
       "26                     0           0           0           0           0   \n",
       "27                     0           0           0           0           0   \n",
       "28                     0           0           0           0           0   \n",
       "29                     0           0           0           0           0   \n",
       "...                  ...         ...         ...         ...         ...   \n",
       "4936                   0           0           0           0           0   \n",
       "4937                   0           0           0           0           0   \n",
       "4938                   0           0           0           0           0   \n",
       "4939                   0           0           1           0           0   \n",
       "4940                   0           0           0           0           0   \n",
       "4941                   0           0           0           0           0   \n",
       "4942                   0           0           0           0           0   \n",
       "4943                   0           0           0           0           0   \n",
       "4944                   0           0           0           0           0   \n",
       "4945                   0           0           0           0           0   \n",
       "4946                   0           0           0           0           0   \n",
       "4947                   0           0           0           0           0   \n",
       "4948                   0           0           0           0           0   \n",
       "4949                   0           0           0           0           0   \n",
       "4950                   0           0           0           0           0   \n",
       "4951                   0           1           1           0           0   \n",
       "4952                   0           1           1           0           0   \n",
       "4953                   0           1           1           0           0   \n",
       "4954                   0           1           1           0           0   \n",
       "4955                   0           0           1           0           0   \n",
       "4956                   0           0           0           0           0   \n",
       "4957                   0           0           0           0           0   \n",
       "4958                   0           0           0           0           0   \n",
       "4959                   0           0           0           0           0   \n",
       "4960                   0           0           0           0           0   \n",
       "4961                   0           0           0           0           0   \n",
       "4962                   0           0           0           0           0   \n",
       "4963                   0           0           0           0           0   \n",
       "4964                   0           0           0           0           0   \n",
       "4965                   0           0           0           0           0   \n",
       "\n",
       "      snort_log1  snort_log2  snort_log3  snort_log4   marker  \n",
       "0              0           0           0           0  Natural  \n",
       "1              0           0           0           0  Natural  \n",
       "2              0           0           0           0  Natural  \n",
       "3              0           0           0           0  Natural  \n",
       "4              0           0           0           0  Natural  \n",
       "5              0           0           0           0  Natural  \n",
       "6              0           0           0           0  Natural  \n",
       "7              0           0           0           0  Natural  \n",
       "8              0           0           0           0  Natural  \n",
       "9              0           0           0           0  Natural  \n",
       "10             0           0           0           0  Natural  \n",
       "11             0           0           0           0  Natural  \n",
       "12             0           0           0           0  Natural  \n",
       "13             0           0           0           0  Natural  \n",
       "14             0           0           0           0  Natural  \n",
       "15             0           0           0           0  Natural  \n",
       "16             0           0           0           0  Natural  \n",
       "17             0           0           0           0  Natural  \n",
       "18             0           0           0           0  Natural  \n",
       "19             0           0           0           0  Natural  \n",
       "20             0           0           0           0  Natural  \n",
       "21             0           0           0           0  Natural  \n",
       "22             0           0           0           0  Natural  \n",
       "23             0           0           0           0  Natural  \n",
       "24             0           0           0           0  Natural  \n",
       "25             0           0           0           0  Natural  \n",
       "26             0           0           0           0  Natural  \n",
       "27             0           0           0           0  Natural  \n",
       "28             0           0           0           0  Natural  \n",
       "29             0           0           0           0  Natural  \n",
       "...          ...         ...         ...         ...      ...  \n",
       "4936           0           0           0           0  Natural  \n",
       "4937           0           0           0           0  Natural  \n",
       "4938           0           0           0           0  Natural  \n",
       "4939           0           0           0           0  Natural  \n",
       "4940           0           0           0           0  Natural  \n",
       "4941           0           0           0           0  Natural  \n",
       "4942           0           0           0           0  Natural  \n",
       "4943           0           0           0           0  Natural  \n",
       "4944           0           0           0           0  Natural  \n",
       "4945           0           0           0           0  Natural  \n",
       "4946           0           0           0           0  Natural  \n",
       "4947           0           0           0           0  Natural  \n",
       "4948           0           0           0           0  Natural  \n",
       "4949           0           0           0           0  Natural  \n",
       "4950           0           0           0           0  Natural  \n",
       "4951           0           0           0           0  Natural  \n",
       "4952           0           0           0           0  Natural  \n",
       "4953           0           0           0           0  Natural  \n",
       "4954           0           0           0           0  Natural  \n",
       "4955           0           0           0           0  Natural  \n",
       "4956           0           0           0           0  Natural  \n",
       "4957           0           0           0           0  Natural  \n",
       "4958           0           0           0           0  Natural  \n",
       "4959           0           0           0           0  Natural  \n",
       "4960           0           0           0           0  Natural  \n",
       "4961           0           0           0           0  Natural  \n",
       "4962           0           0           0           0  Natural  \n",
       "4963           0           0           0           0  Natural  \n",
       "4964           0           0           0           0  Natural  \n",
       "4965           0           0           0           0  Natural  \n",
       "\n",
       "[4966 rows x 129 columns]"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import numpy as np\n",
    "\n",
    "df.fillna(0)# nan to zero"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 3. construct basic dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "x_data = df.iloc[:,0:10] \n",
    "y_data = df.iloc[:,128] "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(4966, 10)"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x_data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(4966,)"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y_data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.model_selection import train_test_split\n",
    "x_train, x_test, y_train, y_test = train_test_split(x_data, y_data, test_size=0.20, random_state=42)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 4. random forest test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.ensemble import RandomForestClassifier\n",
    "\n",
    "model = RandomForestClassifier(n_estimators=20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RandomForestClassifier(bootstrap=True, class_weight=None, criterion='gini',\n",
       "            max_depth=None, max_features='auto', max_leaf_nodes=None,\n",
       "            min_impurity_decrease=0.0, min_impurity_split=None,\n",
       "            min_samples_leaf=1, min_samples_split=2,\n",
       "            min_weight_fraction_leaf=0.0, n_estimators=20, n_jobs=1,\n",
       "            oob_score=False, random_state=None, verbose=0,\n",
       "            warm_start=False)"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "model.fit(x_train, y_train)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.9517102615694165"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "model.score(x_test, y_test)"
   ]
  },
  {
   "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.5.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}