Facies_NM_M_relationship.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "So I will admit this has been more of an exercise in learning code for me, so the following might be way off. But I was messing with some things trying to see if I could fit a classifier for the marine and non-marine facies and formations seperately. It looks like there are some discrepancies in the NM_M data not corresponding to the correct facies. Any thoughts? Note, this may also apply to the validation data. See below."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "from pandas import set_option\n",
    "set_option(\"display.max_rows\", None)\n",
    "\n",
    "training_data = pd.read_csv('facies_vectors.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "PE_mask = training_data['PE'].notnull().values\n",
    "training_data = training_data[PE_mask]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Facies</th>\n",
       "      <th>Depth</th>\n",
       "      <th>GR</th>\n",
       "      <th>ILD_log10</th>\n",
       "      <th>DeltaPHI</th>\n",
       "      <th>PHIND</th>\n",
       "      <th>PE</th>\n",
       "      <th>NM_M</th>\n",
       "      <th>RELPOS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>3232.000000</td>\n",
       "      <td>3232.000000</td>\n",
       "      <td>3232.000000</td>\n",
       "      <td>3232.000000</td>\n",
       "      <td>3232.000000</td>\n",
       "      <td>3232.000000</td>\n",
       "      <td>3232.000000</td>\n",
       "      <td>3232.000000</td>\n",
       "      <td>3232.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>4.422030</td>\n",
       "      <td>2875.824567</td>\n",
       "      <td>66.135769</td>\n",
       "      <td>0.642719</td>\n",
       "      <td>3.559642</td>\n",
       "      <td>13.483213</td>\n",
       "      <td>3.725014</td>\n",
       "      <td>1.498453</td>\n",
       "      <td>0.520287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>2.504243</td>\n",
       "      <td>131.006274</td>\n",
       "      <td>30.854826</td>\n",
       "      <td>0.241845</td>\n",
       "      <td>5.228948</td>\n",
       "      <td>7.698980</td>\n",
       "      <td>0.896152</td>\n",
       "      <td>0.500075</td>\n",
       "      <td>0.286792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>2573.500000</td>\n",
       "      <td>13.250000</td>\n",
       "      <td>-0.025949</td>\n",
       "      <td>-21.832000</td>\n",
       "      <td>0.550000</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.010000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>2791.000000</td>\n",
       "      <td>46.918750</td>\n",
       "      <td>0.492750</td>\n",
       "      <td>1.163750</td>\n",
       "      <td>8.346750</td>\n",
       "      <td>3.100000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.273000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>4.000000</td>\n",
       "      <td>2893.500000</td>\n",
       "      <td>65.721500</td>\n",
       "      <td>0.624437</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>12.150000</td>\n",
       "      <td>3.551500</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.526000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>6.000000</td>\n",
       "      <td>2980.000000</td>\n",
       "      <td>79.626250</td>\n",
       "      <td>0.812735</td>\n",
       "      <td>6.432500</td>\n",
       "      <td>16.453750</td>\n",
       "      <td>4.300000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.767250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>9.000000</td>\n",
       "      <td>3122.500000</td>\n",
       "      <td>361.150000</td>\n",
       "      <td>1.480000</td>\n",
       "      <td>18.600000</td>\n",
       "      <td>84.400000</td>\n",
       "      <td>8.094000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Facies        Depth           GR    ILD_log10     DeltaPHI  \\\n",
       "count  3232.000000  3232.000000  3232.000000  3232.000000  3232.000000   \n",
       "mean      4.422030  2875.824567    66.135769     0.642719     3.559642   \n",
       "std       2.504243   131.006274    30.854826     0.241845     5.228948   \n",
       "min       1.000000  2573.500000    13.250000    -0.025949   -21.832000   \n",
       "25%       2.000000  2791.000000    46.918750     0.492750     1.163750   \n",
       "50%       4.000000  2893.500000    65.721500     0.624437     3.500000   \n",
       "75%       6.000000  2980.000000    79.626250     0.812735     6.432500   \n",
       "max       9.000000  3122.500000   361.150000     1.480000    18.600000   \n",
       "\n",
       "             PHIND           PE         NM_M       RELPOS  \n",
       "count  3232.000000  3232.000000  3232.000000  3232.000000  \n",
       "mean     13.483213     3.725014     1.498453     0.520287  \n",
       "std       7.698980     0.896152     0.500075     0.286792  \n",
       "min       0.550000     0.200000     1.000000     0.010000  \n",
       "25%       8.346750     3.100000     1.000000     0.273000  \n",
       "50%      12.150000     3.551500     1.000000     0.526000  \n",
       "75%      16.453750     4.300000     2.000000     0.767250  \n",
       "max      84.400000     8.094000     2.000000     1.000000  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "training_data.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Here I am checking the non-marine facies 1,2,3 with the NM_M label. It looks like there are some discrepancies, where the Faceis label indicates its NM but the NM_M label indicates marine. Does it really matter because its a relatively small number? But what does this say about our data and ability to make predictions?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Facies</th>\n",
       "      <th>Formation</th>\n",
       "      <th>Well Name</th>\n",
       "      <th>Depth</th>\n",
       "      <th>GR</th>\n",
       "      <th>ILD_log10</th>\n",
       "      <th>DeltaPHI</th>\n",
       "      <th>PHIND</th>\n",
       "      <th>PE</th>\n",
       "      <th>NM_M</th>\n",
       "      <th>RELPOS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2527</th>\n",
       "      <td>3</td>\n",
       "      <td>B3 SH</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2696.5</td>\n",
       "      <td>103.582</td>\n",
       "      <td>0.682867</td>\n",
       "      <td>6.600</td>\n",
       "      <td>12.400</td>\n",
       "      <td>3.400</td>\n",
       "      <td>2</td>\n",
       "      <td>1.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2579</th>\n",
       "      <td>2</td>\n",
       "      <td>B4 SH</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2721.5</td>\n",
       "      <td>74.660</td>\n",
       "      <td>0.474653</td>\n",
       "      <td>9.000</td>\n",
       "      <td>17.700</td>\n",
       "      <td>3.515</td>\n",
       "      <td>2</td>\n",
       "      <td>1.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2645</th>\n",
       "      <td>3</td>\n",
       "      <td>B5 SH</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2754.5</td>\n",
       "      <td>64.146</td>\n",
       "      <td>0.621799</td>\n",
       "      <td>-18.700</td>\n",
       "      <td>23.450</td>\n",
       "      <td>2.502</td>\n",
       "      <td>2</td>\n",
       "      <td>0.100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2777</th>\n",
       "      <td>2</td>\n",
       "      <td>C LM</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2837.0</td>\n",
       "      <td>78.049</td>\n",
       "      <td>0.618884</td>\n",
       "      <td>-12.100</td>\n",
       "      <td>21.450</td>\n",
       "      <td>2.608</td>\n",
       "      <td>2</td>\n",
       "      <td>0.147</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2778</th>\n",
       "      <td>2</td>\n",
       "      <td>C LM</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2837.5</td>\n",
       "      <td>75.925</td>\n",
       "      <td>0.631545</td>\n",
       "      <td>-6.900</td>\n",
       "      <td>19.250</td>\n",
       "      <td>2.826</td>\n",
       "      <td>2</td>\n",
       "      <td>0.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2779</th>\n",
       "      <td>3</td>\n",
       "      <td>C LM</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2838.0</td>\n",
       "      <td>77.553</td>\n",
       "      <td>0.666424</td>\n",
       "      <td>-8.400</td>\n",
       "      <td>22.600</td>\n",
       "      <td>2.840</td>\n",
       "      <td>2</td>\n",
       "      <td>0.118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2780</th>\n",
       "      <td>2</td>\n",
       "      <td>C LM</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2838.5</td>\n",
       "      <td>71.921</td>\n",
       "      <td>0.710963</td>\n",
       "      <td>-6.100</td>\n",
       "      <td>23.350</td>\n",
       "      <td>2.899</td>\n",
       "      <td>2</td>\n",
       "      <td>0.103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2781</th>\n",
       "      <td>3</td>\n",
       "      <td>C LM</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2839.0</td>\n",
       "      <td>61.939</td>\n",
       "      <td>0.745231</td>\n",
       "      <td>-6.500</td>\n",
       "      <td>22.850</td>\n",
       "      <td>2.917</td>\n",
       "      <td>2</td>\n",
       "      <td>0.088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2782</th>\n",
       "      <td>3</td>\n",
       "      <td>C LM</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2839.5</td>\n",
       "      <td>51.987</td>\n",
       "      <td>0.765669</td>\n",
       "      <td>-3.800</td>\n",
       "      <td>18.700</td>\n",
       "      <td>3.022</td>\n",
       "      <td>2</td>\n",
       "      <td>0.074</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2783</th>\n",
       "      <td>3</td>\n",
       "      <td>C LM</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2840.0</td>\n",
       "      <td>41.019</td>\n",
       "      <td>0.772762</td>\n",
       "      <td>1.100</td>\n",
       "      <td>13.450</td>\n",
       "      <td>3.298</td>\n",
       "      <td>2</td>\n",
       "      <td>0.059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2944</th>\n",
       "      <td>2</td>\n",
       "      <td>B2 SH</td>\n",
       "      <td>NOLAN</td>\n",
       "      <td>2932.0</td>\n",
       "      <td>63.938</td>\n",
       "      <td>0.782000</td>\n",
       "      <td>1.615</td>\n",
       "      <td>6.930</td>\n",
       "      <td>3.393</td>\n",
       "      <td>2</td>\n",
       "      <td>0.050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2967</th>\n",
       "      <td>3</td>\n",
       "      <td>B2 SH</td>\n",
       "      <td>NOLAN</td>\n",
       "      <td>2943.5</td>\n",
       "      <td>60.250</td>\n",
       "      <td>0.651000</td>\n",
       "      <td>-5.054</td>\n",
       "      <td>17.847</td>\n",
       "      <td>4.438</td>\n",
       "      <td>2</td>\n",
       "      <td>1.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2989</th>\n",
       "      <td>3</td>\n",
       "      <td>B3 SH</td>\n",
       "      <td>NOLAN</td>\n",
       "      <td>2954.5</td>\n",
       "      <td>55.469</td>\n",
       "      <td>0.795000</td>\n",
       "      <td>1.023</td>\n",
       "      <td>4.397</td>\n",
       "      <td>4.762</td>\n",
       "      <td>2</td>\n",
       "      <td>0.083</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2990</th>\n",
       "      <td>3</td>\n",
       "      <td>B3 SH</td>\n",
       "      <td>NOLAN</td>\n",
       "      <td>2955.0</td>\n",
       "      <td>81.375</td>\n",
       "      <td>0.741000</td>\n",
       "      <td>2.505</td>\n",
       "      <td>6.675</td>\n",
       "      <td>4.004</td>\n",
       "      <td>2</td>\n",
       "      <td>0.042</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3776</th>\n",
       "      <td>3</td>\n",
       "      <td>A1 LM</td>\n",
       "      <td>CHURCHMAN BIBLE</td>\n",
       "      <td>2933.0</td>\n",
       "      <td>71.563</td>\n",
       "      <td>0.772000</td>\n",
       "      <td>3.478</td>\n",
       "      <td>22.157</td>\n",
       "      <td>2.416</td>\n",
       "      <td>2</td>\n",
       "      <td>0.870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3777</th>\n",
       "      <td>3</td>\n",
       "      <td>A1 LM</td>\n",
       "      <td>CHURCHMAN BIBLE</td>\n",
       "      <td>2933.5</td>\n",
       "      <td>75.375</td>\n",
       "      <td>0.746000</td>\n",
       "      <td>-0.136</td>\n",
       "      <td>20.595</td>\n",
       "      <td>2.496</td>\n",
       "      <td>2</td>\n",
       "      <td>0.859</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3779</th>\n",
       "      <td>3</td>\n",
       "      <td>A1 LM</td>\n",
       "      <td>CHURCHMAN BIBLE</td>\n",
       "      <td>2934.5</td>\n",
       "      <td>79.375</td>\n",
       "      <td>0.730000</td>\n",
       "      <td>2.966</td>\n",
       "      <td>20.960</td>\n",
       "      <td>2.967</td>\n",
       "      <td>2</td>\n",
       "      <td>0.837</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3780</th>\n",
       "      <td>3</td>\n",
       "      <td>A1 LM</td>\n",
       "      <td>CHURCHMAN BIBLE</td>\n",
       "      <td>2935.0</td>\n",
       "      <td>79.438</td>\n",
       "      <td>0.734000</td>\n",
       "      <td>1.488</td>\n",
       "      <td>19.020</td>\n",
       "      <td>3.406</td>\n",
       "      <td>2</td>\n",
       "      <td>0.826</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3911</th>\n",
       "      <td>3</td>\n",
       "      <td>B2 SH</td>\n",
       "      <td>CHURCHMAN BIBLE</td>\n",
       "      <td>3000.5</td>\n",
       "      <td>207.125</td>\n",
       "      <td>0.707000</td>\n",
       "      <td>-0.923</td>\n",
       "      <td>22.896</td>\n",
       "      <td>2.350</td>\n",
       "      <td>2</td>\n",
       "      <td>0.063</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3912</th>\n",
       "      <td>3</td>\n",
       "      <td>B2 SH</td>\n",
       "      <td>CHURCHMAN BIBLE</td>\n",
       "      <td>3001.0</td>\n",
       "      <td>221.125</td>\n",
       "      <td>0.664000</td>\n",
       "      <td>-9.690</td>\n",
       "      <td>39.427</td>\n",
       "      <td>2.043</td>\n",
       "      <td>2</td>\n",
       "      <td>0.031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3953</th>\n",
       "      <td>3</td>\n",
       "      <td>B3 SH</td>\n",
       "      <td>CHURCHMAN BIBLE</td>\n",
       "      <td>3021.5</td>\n",
       "      <td>87.875</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>3.797</td>\n",
       "      <td>9.680</td>\n",
       "      <td>3.201</td>\n",
       "      <td>2</td>\n",
       "      <td>0.033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3982</th>\n",
       "      <td>2</td>\n",
       "      <td>B4 SH</td>\n",
       "      <td>CHURCHMAN BIBLE</td>\n",
       "      <td>3036.0</td>\n",
       "      <td>69.500</td>\n",
       "      <td>0.837000</td>\n",
       "      <td>2.843</td>\n",
       "      <td>8.387</td>\n",
       "      <td>3.268</td>\n",
       "      <td>2</td>\n",
       "      <td>0.071</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Facies Formation        Well Name   Depth       GR  ILD_log10  DeltaPHI  \\\n",
       "2527       3     B3 SH   CROSS H CATTLE  2696.5  103.582   0.682867     6.600   \n",
       "2579       2     B4 SH   CROSS H CATTLE  2721.5   74.660   0.474653     9.000   \n",
       "2645       3     B5 SH   CROSS H CATTLE  2754.5   64.146   0.621799   -18.700   \n",
       "2777       2      C LM   CROSS H CATTLE  2837.0   78.049   0.618884   -12.100   \n",
       "2778       2      C LM   CROSS H CATTLE  2837.5   75.925   0.631545    -6.900   \n",
       "2779       3      C LM   CROSS H CATTLE  2838.0   77.553   0.666424    -8.400   \n",
       "2780       2      C LM   CROSS H CATTLE  2838.5   71.921   0.710963    -6.100   \n",
       "2781       3      C LM   CROSS H CATTLE  2839.0   61.939   0.745231    -6.500   \n",
       "2782       3      C LM   CROSS H CATTLE  2839.5   51.987   0.765669    -3.800   \n",
       "2783       3      C LM   CROSS H CATTLE  2840.0   41.019   0.772762     1.100   \n",
       "2944       2     B2 SH            NOLAN  2932.0   63.938   0.782000     1.615   \n",
       "2967       3     B2 SH            NOLAN  2943.5   60.250   0.651000    -5.054   \n",
       "2989       3     B3 SH            NOLAN  2954.5   55.469   0.795000     1.023   \n",
       "2990       3     B3 SH            NOLAN  2955.0   81.375   0.741000     2.505   \n",
       "3776       3     A1 LM  CHURCHMAN BIBLE  2933.0   71.563   0.772000     3.478   \n",
       "3777       3     A1 LM  CHURCHMAN BIBLE  2933.5   75.375   0.746000    -0.136   \n",
       "3779       3     A1 LM  CHURCHMAN BIBLE  2934.5   79.375   0.730000     2.966   \n",
       "3780       3     A1 LM  CHURCHMAN BIBLE  2935.0   79.438   0.734000     1.488   \n",
       "3911       3     B2 SH  CHURCHMAN BIBLE  3000.5  207.125   0.707000    -0.923   \n",
       "3912       3     B2 SH  CHURCHMAN BIBLE  3001.0  221.125   0.664000    -9.690   \n",
       "3953       3     B3 SH  CHURCHMAN BIBLE  3021.5   87.875   0.500000     3.797   \n",
       "3982       2     B4 SH  CHURCHMAN BIBLE  3036.0   69.500   0.837000     2.843   \n",
       "\n",
       "       PHIND     PE  NM_M  RELPOS  \n",
       "2527  12.400  3.400     2   1.000  \n",
       "2579  17.700  3.515     2   1.000  \n",
       "2645  23.450  2.502     2   0.100  \n",
       "2777  21.450  2.608     2   0.147  \n",
       "2778  19.250  2.826     2   0.132  \n",
       "2779  22.600  2.840     2   0.118  \n",
       "2780  23.350  2.899     2   0.103  \n",
       "2781  22.850  2.917     2   0.088  \n",
       "2782  18.700  3.022     2   0.074  \n",
       "2783  13.450  3.298     2   0.059  \n",
       "2944   6.930  3.393     2   0.050  \n",
       "2967  17.847  4.438     2   1.000  \n",
       "2989   4.397  4.762     2   0.083  \n",
       "2990   6.675  4.004     2   0.042  \n",
       "3776  22.157  2.416     2   0.870  \n",
       "3777  20.595  2.496     2   0.859  \n",
       "3779  20.960  2.967     2   0.837  \n",
       "3780  19.020  3.406     2   0.826  \n",
       "3911  22.896  2.350     2   0.063  \n",
       "3912  39.427  2.043     2   0.031  \n",
       "3953   9.680  3.201     2   0.033  \n",
       "3982   8.387  3.268     2   0.071  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "td_NM = training_data.loc[training_data['Facies'].isin([1,2,3])]\n",
    "td_NM.loc[td_NM['NM_M'].isin([2])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Facies</th>\n",
       "      <th>Formation</th>\n",
       "      <th>Well Name</th>\n",
       "      <th>Depth</th>\n",
       "      <th>GR</th>\n",
       "      <th>ILD_log10</th>\n",
       "      <th>DeltaPHI</th>\n",
       "      <th>PHIND</th>\n",
       "      <th>PE</th>\n",
       "      <th>NM_M</th>\n",
       "      <th>RELPOS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1227</th>\n",
       "      <td>6</td>\n",
       "      <td>B4 LM</td>\n",
       "      <td>SHANKLE</td>\n",
       "      <td>2924.0</td>\n",
       "      <td>26.060</td>\n",
       "      <td>0.725000</td>\n",
       "      <td>-12.900</td>\n",
       "      <td>16.170</td>\n",
       "      <td>4.400</td>\n",
       "      <td>1</td>\n",
       "      <td>0.857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2356</th>\n",
       "      <td>8</td>\n",
       "      <td>A1 SH</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2608.5</td>\n",
       "      <td>85.898</td>\n",
       "      <td>0.540455</td>\n",
       "      <td>5.100</td>\n",
       "      <td>16.050</td>\n",
       "      <td>3.099</td>\n",
       "      <td>1</td>\n",
       "      <td>0.013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2457</th>\n",
       "      <td>4</td>\n",
       "      <td>B1 SH</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2660.0</td>\n",
       "      <td>94.469</td>\n",
       "      <td>0.308351</td>\n",
       "      <td>-8.000</td>\n",
       "      <td>33.600</td>\n",
       "      <td>2.280</td>\n",
       "      <td>1</td>\n",
       "      <td>0.121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2465</th>\n",
       "      <td>4</td>\n",
       "      <td>B1 SH</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2664.0</td>\n",
       "      <td>104.128</td>\n",
       "      <td>0.501333</td>\n",
       "      <td>12.500</td>\n",
       "      <td>17.350</td>\n",
       "      <td>3.150</td>\n",
       "      <td>1</td>\n",
       "      <td>0.015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2476</th>\n",
       "      <td>8</td>\n",
       "      <td>B1 LM</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2669.5</td>\n",
       "      <td>95.638</td>\n",
       "      <td>0.856910</td>\n",
       "      <td>-6.100</td>\n",
       "      <td>11.950</td>\n",
       "      <td>3.230</td>\n",
       "      <td>1</td>\n",
       "      <td>1.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2511</th>\n",
       "      <td>5</td>\n",
       "      <td>B2 SH</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2688.5</td>\n",
       "      <td>59.734</td>\n",
       "      <td>0.578868</td>\n",
       "      <td>6.500</td>\n",
       "      <td>16.150</td>\n",
       "      <td>3.524</td>\n",
       "      <td>1</td>\n",
       "      <td>0.296</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2512</th>\n",
       "      <td>5</td>\n",
       "      <td>B2 SH</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2689.0</td>\n",
       "      <td>52.386</td>\n",
       "      <td>0.581495</td>\n",
       "      <td>9.900</td>\n",
       "      <td>13.850</td>\n",
       "      <td>3.578</td>\n",
       "      <td>1</td>\n",
       "      <td>0.278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2513</th>\n",
       "      <td>5</td>\n",
       "      <td>B2 SH</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2689.5</td>\n",
       "      <td>50.751</td>\n",
       "      <td>0.585574</td>\n",
       "      <td>11.400</td>\n",
       "      <td>11.700</td>\n",
       "      <td>3.553</td>\n",
       "      <td>1</td>\n",
       "      <td>0.259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2514</th>\n",
       "      <td>5</td>\n",
       "      <td>B2 SH</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2690.0</td>\n",
       "      <td>50.034</td>\n",
       "      <td>0.593175</td>\n",
       "      <td>10.800</td>\n",
       "      <td>10.500</td>\n",
       "      <td>3.491</td>\n",
       "      <td>1</td>\n",
       "      <td>0.241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2524</th>\n",
       "      <td>4</td>\n",
       "      <td>B2 SH</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2695.0</td>\n",
       "      <td>90.179</td>\n",
       "      <td>0.747334</td>\n",
       "      <td>7.000</td>\n",
       "      <td>10.900</td>\n",
       "      <td>3.414</td>\n",
       "      <td>1</td>\n",
       "      <td>0.056</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2525</th>\n",
       "      <td>4</td>\n",
       "      <td>B2 SH</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2695.5</td>\n",
       "      <td>94.523</td>\n",
       "      <td>0.737987</td>\n",
       "      <td>7.300</td>\n",
       "      <td>11.150</td>\n",
       "      <td>3.399</td>\n",
       "      <td>1</td>\n",
       "      <td>0.037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2663</th>\n",
       "      <td>5</td>\n",
       "      <td>B5 SH</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2765.5</td>\n",
       "      <td>75.264</td>\n",
       "      <td>0.326131</td>\n",
       "      <td>-10.600</td>\n",
       "      <td>27.600</td>\n",
       "      <td>2.605</td>\n",
       "      <td>1</td>\n",
       "      <td>0.115</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2664</th>\n",
       "      <td>5</td>\n",
       "      <td>B5 SH</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2766.0</td>\n",
       "      <td>72.400</td>\n",
       "      <td>0.289812</td>\n",
       "      <td>-14.800</td>\n",
       "      <td>32.300</td>\n",
       "      <td>2.436</td>\n",
       "      <td>1</td>\n",
       "      <td>0.077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2686</th>\n",
       "      <td>8</td>\n",
       "      <td>B5 LM</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2777.0</td>\n",
       "      <td>110.121</td>\n",
       "      <td>0.488833</td>\n",
       "      <td>4.000</td>\n",
       "      <td>16.600</td>\n",
       "      <td>3.331</td>\n",
       "      <td>1</td>\n",
       "      <td>1.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2687</th>\n",
       "      <td>8</td>\n",
       "      <td>B5 LM</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2777.5</td>\n",
       "      <td>111.355</td>\n",
       "      <td>0.488127</td>\n",
       "      <td>-11.500</td>\n",
       "      <td>27.450</td>\n",
       "      <td>2.720</td>\n",
       "      <td>1</td>\n",
       "      <td>0.984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2688</th>\n",
       "      <td>5</td>\n",
       "      <td>B5 LM</td>\n",
       "      <td>CROSS H CATTLE</td>\n",
       "      <td>2778.0</td>\n",
       "      <td>104.598</td>\n",
       "      <td>0.487421</td>\n",
       "      <td>-12.300</td>\n",
       "      <td>31.950</td>\n",
       "      <td>2.558</td>\n",
       "      <td>1</td>\n",
       "      <td>0.968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2827</th>\n",
       "      <td>5</td>\n",
       "      <td>A1 SH</td>\n",
       "      <td>NOLAN</td>\n",
       "      <td>2873.5</td>\n",
       "      <td>73.688</td>\n",
       "      <td>0.310000</td>\n",
       "      <td>6.614</td>\n",
       "      <td>17.409</td>\n",
       "      <td>2.922</td>\n",
       "      <td>1</td>\n",
       "      <td>0.091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2828</th>\n",
       "      <td>5</td>\n",
       "      <td>A1 SH</td>\n",
       "      <td>NOLAN</td>\n",
       "      <td>2874.0</td>\n",
       "      <td>76.250</td>\n",
       "      <td>0.295000</td>\n",
       "      <td>7.123</td>\n",
       "      <td>19.977</td>\n",
       "      <td>2.981</td>\n",
       "      <td>1</td>\n",
       "      <td>0.068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2891</th>\n",
       "      <td>8</td>\n",
       "      <td>A1 LM</td>\n",
       "      <td>NOLAN</td>\n",
       "      <td>2905.5</td>\n",
       "      <td>79.250</td>\n",
       "      <td>0.671000</td>\n",
       "      <td>1.088</td>\n",
       "      <td>17.369</td>\n",
       "      <td>3.490</td>\n",
       "      <td>1</td>\n",
       "      <td>1.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2924</th>\n",
       "      <td>8</td>\n",
       "      <td>B1 LM</td>\n",
       "      <td>NOLAN</td>\n",
       "      <td>2922.0</td>\n",
       "      <td>48.281</td>\n",
       "      <td>0.596000</td>\n",
       "      <td>3.010</td>\n",
       "      <td>19.402</td>\n",
       "      <td>2.906</td>\n",
       "      <td>1</td>\n",
       "      <td>0.029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3051</th>\n",
       "      <td>5</td>\n",
       "      <td>B4 LM</td>\n",
       "      <td>NOLAN</td>\n",
       "      <td>2985.5</td>\n",
       "      <td>66.813</td>\n",
       "      <td>0.567000</td>\n",
       "      <td>6.296</td>\n",
       "      <td>23.489</td>\n",
       "      <td>3.065</td>\n",
       "      <td>1</td>\n",
       "      <td>0.083</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3052</th>\n",
       "      <td>8</td>\n",
       "      <td>B4 LM</td>\n",
       "      <td>NOLAN</td>\n",
       "      <td>2986.0</td>\n",
       "      <td>38.781</td>\n",
       "      <td>0.588000</td>\n",
       "      <td>1.993</td>\n",
       "      <td>17.245</td>\n",
       "      <td>4.199</td>\n",
       "      <td>1</td>\n",
       "      <td>0.042</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3063</th>\n",
       "      <td>6</td>\n",
       "      <td>B4 LM</td>\n",
       "      <td>NOLAN</td>\n",
       "      <td>2991.5</td>\n",
       "      <td>54.031</td>\n",
       "      <td>0.385000</td>\n",
       "      <td>3.715</td>\n",
       "      <td>15.084</td>\n",
       "      <td>2.940</td>\n",
       "      <td>1</td>\n",
       "      <td>1.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3070</th>\n",
       "      <td>4</td>\n",
       "      <td>B5 LM</td>\n",
       "      <td>NOLAN</td>\n",
       "      <td>2995.0</td>\n",
       "      <td>48.031</td>\n",
       "      <td>-0.019000</td>\n",
       "      <td>5.381</td>\n",
       "      <td>20.059</td>\n",
       "      <td>3.592</td>\n",
       "      <td>1</td>\n",
       "      <td>0.125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3143</th>\n",
       "      <td>8</td>\n",
       "      <td>C LM</td>\n",
       "      <td>NOLAN</td>\n",
       "      <td>3031.5</td>\n",
       "      <td>81.125</td>\n",
       "      <td>0.597000</td>\n",
       "      <td>5.830</td>\n",
       "      <td>19.023</td>\n",
       "      <td>3.131</td>\n",
       "      <td>1</td>\n",
       "      <td>0.053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3144</th>\n",
       "      <td>8</td>\n",
       "      <td>C LM</td>\n",
       "      <td>NOLAN</td>\n",
       "      <td>3032.0</td>\n",
       "      <td>58.188</td>\n",
       "      <td>0.643000</td>\n",
       "      <td>6.517</td>\n",
       "      <td>15.260</td>\n",
       "      <td>3.334</td>\n",
       "      <td>1</td>\n",
       "      <td>0.026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3880</th>\n",
       "      <td>5</td>\n",
       "      <td>B1 LM</td>\n",
       "      <td>CHURCHMAN BIBLE</td>\n",
       "      <td>2985.0</td>\n",
       "      <td>60.219</td>\n",
       "      <td>0.545000</td>\n",
       "      <td>3.448</td>\n",
       "      <td>27.606</td>\n",
       "      <td>2.652</td>\n",
       "      <td>1</td>\n",
       "      <td>0.042</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3922</th>\n",
       "      <td>7</td>\n",
       "      <td>B2 SH</td>\n",
       "      <td>CHURCHMAN BIBLE</td>\n",
       "      <td>3006.0</td>\n",
       "      <td>67.500</td>\n",
       "      <td>0.696000</td>\n",
       "      <td>-1.373</td>\n",
       "      <td>37.750</td>\n",
       "      <td>2.102</td>\n",
       "      <td>1</td>\n",
       "      <td>0.167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3968</th>\n",
       "      <td>8</td>\n",
       "      <td>B3 LM</td>\n",
       "      <td>CHURCHMAN BIBLE</td>\n",
       "      <td>3029.0</td>\n",
       "      <td>47.000</td>\n",
       "      <td>0.757000</td>\n",
       "      <td>-4.656</td>\n",
       "      <td>18.133</td>\n",
       "      <td>3.836</td>\n",
       "      <td>1</td>\n",
       "      <td>0.071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3996</th>\n",
       "      <td>8</td>\n",
       "      <td>B4 LM</td>\n",
       "      <td>CHURCHMAN BIBLE</td>\n",
       "      <td>3044.0</td>\n",
       "      <td>49.438</td>\n",
       "      <td>0.752000</td>\n",
       "      <td>-8.496</td>\n",
       "      <td>19.434</td>\n",
       "      <td>4.785</td>\n",
       "      <td>1</td>\n",
       "      <td>0.063</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4011</th>\n",
       "      <td>8</td>\n",
       "      <td>B5 LM</td>\n",
       "      <td>CHURCHMAN BIBLE</td>\n",
       "      <td>3054.0</td>\n",
       "      <td>33.906</td>\n",
       "      <td>0.641000</td>\n",
       "      <td>1.365</td>\n",
       "      <td>4.739</td>\n",
       "      <td>4.879</td>\n",
       "      <td>1</td>\n",
       "      <td>0.167</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Facies Formation        Well Name   Depth       GR  ILD_log10  DeltaPHI  \\\n",
       "1227       6     B4 LM          SHANKLE  2924.0   26.060   0.725000   -12.900   \n",
       "2356       8     A1 SH   CROSS H CATTLE  2608.5   85.898   0.540455     5.100   \n",
       "2457       4     B1 SH   CROSS H CATTLE  2660.0   94.469   0.308351    -8.000   \n",
       "2465       4     B1 SH   CROSS H CATTLE  2664.0  104.128   0.501333    12.500   \n",
       "2476       8     B1 LM   CROSS H CATTLE  2669.5   95.638   0.856910    -6.100   \n",
       "2511       5     B2 SH   CROSS H CATTLE  2688.5   59.734   0.578868     6.500   \n",
       "2512       5     B2 SH   CROSS H CATTLE  2689.0   52.386   0.581495     9.900   \n",
       "2513       5     B2 SH   CROSS H CATTLE  2689.5   50.751   0.585574    11.400   \n",
       "2514       5     B2 SH   CROSS H CATTLE  2690.0   50.034   0.593175    10.800   \n",
       "2524       4     B2 SH   CROSS H CATTLE  2695.0   90.179   0.747334     7.000   \n",
       "2525       4     B2 SH   CROSS H CATTLE  2695.5   94.523   0.737987     7.300   \n",
       "2663       5     B5 SH   CROSS H CATTLE  2765.5   75.264   0.326131   -10.600   \n",
       "2664       5     B5 SH   CROSS H CATTLE  2766.0   72.400   0.289812   -14.800   \n",
       "2686       8     B5 LM   CROSS H CATTLE  2777.0  110.121   0.488833     4.000   \n",
       "2687       8     B5 LM   CROSS H CATTLE  2777.5  111.355   0.488127   -11.500   \n",
       "2688       5     B5 LM   CROSS H CATTLE  2778.0  104.598   0.487421   -12.300   \n",
       "2827       5     A1 SH            NOLAN  2873.5   73.688   0.310000     6.614   \n",
       "2828       5     A1 SH            NOLAN  2874.0   76.250   0.295000     7.123   \n",
       "2891       8     A1 LM            NOLAN  2905.5   79.250   0.671000     1.088   \n",
       "2924       8     B1 LM            NOLAN  2922.0   48.281   0.596000     3.010   \n",
       "3051       5     B4 LM            NOLAN  2985.5   66.813   0.567000     6.296   \n",
       "3052       8     B4 LM            NOLAN  2986.0   38.781   0.588000     1.993   \n",
       "3063       6     B4 LM            NOLAN  2991.5   54.031   0.385000     3.715   \n",
       "3070       4     B5 LM            NOLAN  2995.0   48.031  -0.019000     5.381   \n",
       "3143       8      C LM            NOLAN  3031.5   81.125   0.597000     5.830   \n",
       "3144       8      C LM            NOLAN  3032.0   58.188   0.643000     6.517   \n",
       "3880       5     B1 LM  CHURCHMAN BIBLE  2985.0   60.219   0.545000     3.448   \n",
       "3922       7     B2 SH  CHURCHMAN BIBLE  3006.0   67.500   0.696000    -1.373   \n",
       "3968       8     B3 LM  CHURCHMAN BIBLE  3029.0   47.000   0.757000    -4.656   \n",
       "3996       8     B4 LM  CHURCHMAN BIBLE  3044.0   49.438   0.752000    -8.496   \n",
       "4011       8     B5 LM  CHURCHMAN BIBLE  3054.0   33.906   0.641000     1.365   \n",
       "\n",
       "       PHIND     PE  NM_M  RELPOS  \n",
       "1227  16.170  4.400     1   0.857  \n",
       "2356  16.050  3.099     1   0.013  \n",
       "2457  33.600  2.280     1   0.121  \n",
       "2465  17.350  3.150     1   0.015  \n",
       "2476  11.950  3.230     1   1.000  \n",
       "2511  16.150  3.524     1   0.296  \n",
       "2512  13.850  3.578     1   0.278  \n",
       "2513  11.700  3.553     1   0.259  \n",
       "2514  10.500  3.491     1   0.241  \n",
       "2524  10.900  3.414     1   0.056  \n",
       "2525  11.150  3.399     1   0.037  \n",
       "2663  27.600  2.605     1   0.115  \n",
       "2664  32.300  2.436     1   0.077  \n",
       "2686  16.600  3.331     1   1.000  \n",
       "2687  27.450  2.720     1   0.984  \n",
       "2688  31.950  2.558     1   0.968  \n",
       "2827  17.409  2.922     1   0.091  \n",
       "2828  19.977  2.981     1   0.068  \n",
       "2891  17.369  3.490     1   1.000  \n",
       "2924  19.402  2.906     1   0.029  \n",
       "3051  23.489  3.065     1   0.083  \n",
       "3052  17.245  4.199     1   0.042  \n",
       "3063  15.084  2.940     1   1.000  \n",
       "3070  20.059  3.592     1   0.125  \n",
       "3143  19.023  3.131     1   0.053  \n",
       "3144  15.260  3.334     1   0.026  \n",
       "3880  27.606  2.652     1   0.042  \n",
       "3922  37.750  2.102     1   0.167  \n",
       "3968  18.133  3.836     1   0.071  \n",
       "3996  19.434  4.785     1   0.063  \n",
       "4011   4.739  4.879     1   0.167  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "td_M = training_data.loc[training_data['Facies'].isin([4,5,6,7,8,9])]\n",
    "td_M.loc[td_M['NM_M'].isin([1])]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This indicates that there may be a small amount of Facies data that does not fit with the classification NM_M. I only want to point out some potential outliers that may influence the results negatively, not say 'this is wrong!'. Although, I'm not sure what a good solution is. Do we remove these data?"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "So what does our validation data look like? Maybe these wells also contain some discrepancies?\n",
    "\n",
    "But since we don't have the Facies data, we can only describe the relationship between the non-marine and marine Formations."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "validation = pd.read_csv('validation_data_nofacies.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#I was enumerating the Formations, but for clarity, just left as original\n",
    "#for i, value in enumerate(validation['Formation'].unique()):\n",
    "#    validation.loc[validation['Formation'] == value, 'Formation'] = i"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Formation</th>\n",
       "      <th>Well Name</th>\n",
       "      <th>Depth</th>\n",
       "      <th>GR</th>\n",
       "      <th>ILD_log10</th>\n",
       "      <th>DeltaPHI</th>\n",
       "      <th>PHIND</th>\n",
       "      <th>PE</th>\n",
       "      <th>NM_M</th>\n",
       "      <th>RELPOS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>667</th>\n",
       "      <td>B3 SH</td>\n",
       "      <td>CRAWFORD</td>\n",
       "      <td>3078.0</td>\n",
       "      <td>110.210</td>\n",
       "      <td>0.792</td>\n",
       "      <td>0.27</td>\n",
       "      <td>14.14</td>\n",
       "      <td>2.678</td>\n",
       "      <td>2</td>\n",
       "      <td>0.036</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>702</th>\n",
       "      <td>B4 SH</td>\n",
       "      <td>CRAWFORD</td>\n",
       "      <td>3095.5</td>\n",
       "      <td>55.601</td>\n",
       "      <td>0.610</td>\n",
       "      <td>2.42</td>\n",
       "      <td>7.82</td>\n",
       "      <td>3.146</td>\n",
       "      <td>2</td>\n",
       "      <td>0.063</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>739</th>\n",
       "      <td>B5 SH</td>\n",
       "      <td>CRAWFORD</td>\n",
       "      <td>3114.0</td>\n",
       "      <td>55.757</td>\n",
       "      <td>0.900</td>\n",
       "      <td>2.86</td>\n",
       "      <td>7.09</td>\n",
       "      <td>3.514</td>\n",
       "      <td>2</td>\n",
       "      <td>0.056</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Formation Well Name   Depth       GR  ILD_log10  DeltaPHI  PHIND     PE  \\\n",
       "667     B3 SH  CRAWFORD  3078.0  110.210      0.792      0.27  14.14  2.678   \n",
       "702     B4 SH  CRAWFORD  3095.5   55.601      0.610      2.42   7.82  3.146   \n",
       "739     B5 SH  CRAWFORD  3114.0   55.757      0.900      2.86   7.09  3.514   \n",
       "\n",
       "     NM_M  RELPOS  \n",
       "667     2   0.036  \n",
       "702     2   0.063  \n",
       "739     2   0.056  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vd = validation.loc[validation['Formation'].isin(['A1 SH', 'B1 SH', 'B2 SH', 'B3 SH', 'B4 SH', 'B5 SH', 'C SH'])]\n",
    "vd.loc[vd['NM_M'].isin([2])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Formation</th>\n",
       "      <th>Well Name</th>\n",
       "      <th>Depth</th>\n",
       "      <th>GR</th>\n",
       "      <th>ILD_log10</th>\n",
       "      <th>DeltaPHI</th>\n",
       "      <th>PHIND</th>\n",
       "      <th>PE</th>\n",
       "      <th>NM_M</th>\n",
       "      <th>RELPOS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>636</th>\n",
       "      <td>B2 LM</td>\n",
       "      <td>CRAWFORD</td>\n",
       "      <td>3062.5</td>\n",
       "      <td>66.266</td>\n",
       "      <td>0.443</td>\n",
       "      <td>4.505</td>\n",
       "      <td>13.995</td>\n",
       "      <td>2.553</td>\n",
       "      <td>1</td>\n",
       "      <td>0.200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>637</th>\n",
       "      <td>B2 LM</td>\n",
       "      <td>CRAWFORD</td>\n",
       "      <td>3063.0</td>\n",
       "      <td>60.790</td>\n",
       "      <td>0.441</td>\n",
       "      <td>6.070</td>\n",
       "      <td>16.340</td>\n",
       "      <td>2.679</td>\n",
       "      <td>1</td>\n",
       "      <td>0.150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>638</th>\n",
       "      <td>B2 LM</td>\n",
       "      <td>CRAWFORD</td>\n",
       "      <td>3063.5</td>\n",
       "      <td>54.670</td>\n",
       "      <td>0.444</td>\n",
       "      <td>6.250</td>\n",
       "      <td>16.740</td>\n",
       "      <td>3.350</td>\n",
       "      <td>1</td>\n",
       "      <td>0.100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>639</th>\n",
       "      <td>B2 LM</td>\n",
       "      <td>CRAWFORD</td>\n",
       "      <td>3064.0</td>\n",
       "      <td>48.094</td>\n",
       "      <td>0.445</td>\n",
       "      <td>5.995</td>\n",
       "      <td>16.615</td>\n",
       "      <td>3.865</td>\n",
       "      <td>1</td>\n",
       "      <td>0.050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>722</th>\n",
       "      <td>B4 LM</td>\n",
       "      <td>CRAWFORD</td>\n",
       "      <td>3105.5</td>\n",
       "      <td>70.526</td>\n",
       "      <td>0.731</td>\n",
       "      <td>-3.475</td>\n",
       "      <td>31.335</td>\n",
       "      <td>2.301</td>\n",
       "      <td>1</td>\n",
       "      <td>0.050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>752</th>\n",
       "      <td>B5 LM</td>\n",
       "      <td>CRAWFORD</td>\n",
       "      <td>3122.0</td>\n",
       "      <td>69.179</td>\n",
       "      <td>0.692</td>\n",
       "      <td>6.110</td>\n",
       "      <td>19.220</td>\n",
       "      <td>3.114</td>\n",
       "      <td>1</td>\n",
       "      <td>0.063</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Formation Well Name   Depth      GR  ILD_log10  DeltaPHI   PHIND     PE  \\\n",
       "636     B2 LM  CRAWFORD  3062.5  66.266      0.443     4.505  13.995  2.553   \n",
       "637     B2 LM  CRAWFORD  3063.0  60.790      0.441     6.070  16.340  2.679   \n",
       "638     B2 LM  CRAWFORD  3063.5  54.670      0.444     6.250  16.740  3.350   \n",
       "639     B2 LM  CRAWFORD  3064.0  48.094      0.445     5.995  16.615  3.865   \n",
       "722     B4 LM  CRAWFORD  3105.5  70.526      0.731    -3.475  31.335  2.301   \n",
       "752     B5 LM  CRAWFORD  3122.0  69.179      0.692     6.110  19.220  3.114   \n",
       "\n",
       "     NM_M  RELPOS  \n",
       "636     1   0.200  \n",
       "637     1   0.150  \n",
       "638     1   0.100  \n",
       "639     1   0.050  \n",
       "722     1   0.050  \n",
       "752     1   0.063  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vd_o = validation.loc[validation['Formation'].isin(['A1 LM', 'B1 LM', 'B2 LM', 'B3 LM', 'B4 LM', 'B5 LM', 'C LM'])]\n",
    "vd_o.loc[vd_o['NM_M'].isin([1])]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Am I completely off base here? Just wondering if anyone else had a comment or has seen this."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [conda root]",
   "language": "python",
   "name": "conda-root-py"
  },
  "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.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}