Q3.ipynb

{
 "cells": [
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Q3: How do well logs vary with depth?\n",
    "    a. divide the well log data into different depth intervals\n",
    "    b. calculate the mean and standard deviation of each depth interval\n",
    "    c. plot the mean and standard deviation of each depth interval\n",
    "\n",
    "**Purpose of the question**: find out if depth is a affecting the other columns (is depth a feature)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import lasio\n",
    "import pandas as pd\n",
    "import missingno as msno\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt\n",
    "import numpy as np\n",
    "import plotly.express as px\n",
    "from utils import *\n",
    "import warnings\n",
    "\n",
    "warnings.filterwarnings(\"ignore\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = lasio.read(\"./Data/25_11-24.las\").df()\n",
    "df.reset_index(inplace=True)\n",
    "rename_columns(df)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>Measured Depth</th>\n",
       "      <th>Caliper</th>\n",
       "      <th>Borehole Size</th>\n",
       "      <th>Rate of Penetration</th>\n",
       "      <th>Neutron Porosity</th>\n",
       "      <th>Bulk Density</th>\n",
       "      <th>Photo Electric Factor</th>\n",
       "      <th>Gamma Ray</th>\n",
       "      <th>Compressional waves sonic</th>\n",
       "      <th>Deep Resistivity</th>\n",
       "      <th>Medium Deep Resistivity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>4042.000000</td>\n",
       "      <td>4042.000000</td>\n",
       "      <td>4042.000000</td>\n",
       "      <td>4042.000000</td>\n",
       "      <td>4042.000000</td>\n",
       "      <td>4042.00000</td>\n",
       "      <td>4042.000000</td>\n",
       "      <td>4042.000000</td>\n",
       "      <td>4042.000000</td>\n",
       "      <td>4042.000000</td>\n",
       "      <td>4042.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>1777.465109</td>\n",
       "      <td>9.717041</td>\n",
       "      <td>9.588261</td>\n",
       "      <td>66.658535</td>\n",
       "      <td>0.431642</td>\n",
       "      <td>2.21524</td>\n",
       "      <td>3.830918</td>\n",
       "      <td>153.433808</td>\n",
       "      <td>123.936692</td>\n",
       "      <td>1.347869</td>\n",
       "      <td>1.326556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>184.220933</td>\n",
       "      <td>1.874042</td>\n",
       "      <td>1.702171</td>\n",
       "      <td>40.962838</td>\n",
       "      <td>0.147389</td>\n",
       "      <td>0.15357</td>\n",
       "      <td>1.192266</td>\n",
       "      <td>45.941593</td>\n",
       "      <td>22.566178</td>\n",
       "      <td>2.078600</td>\n",
       "      <td>2.112787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1456.992798</td>\n",
       "      <td>8.153500</td>\n",
       "      <td>8.500000</td>\n",
       "      <td>7.185368</td>\n",
       "      <td>0.036401</td>\n",
       "      <td>1.40940</td>\n",
       "      <td>1.745000</td>\n",
       "      <td>49.108601</td>\n",
       "      <td>57.211849</td>\n",
       "      <td>0.246213</td>\n",
       "      <td>0.237000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>1610.954864</td>\n",
       "      <td>8.494600</td>\n",
       "      <td>8.500000</td>\n",
       "      <td>39.845470</td>\n",
       "      <td>0.326204</td>\n",
       "      <td>2.10480</td>\n",
       "      <td>2.770325</td>\n",
       "      <td>117.948736</td>\n",
       "      <td>108.363602</td>\n",
       "      <td>0.630248</td>\n",
       "      <td>0.618952</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>1782.595398</td>\n",
       "      <td>8.580300</td>\n",
       "      <td>8.500000</td>\n",
       "      <td>57.514475</td>\n",
       "      <td>0.471200</td>\n",
       "      <td>2.16830</td>\n",
       "      <td>3.662900</td>\n",
       "      <td>155.046700</td>\n",
       "      <td>130.737747</td>\n",
       "      <td>0.810511</td>\n",
       "      <td>0.790850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>1936.557495</td>\n",
       "      <td>11.953675</td>\n",
       "      <td>12.250001</td>\n",
       "      <td>84.531580</td>\n",
       "      <td>0.527875</td>\n",
       "      <td>2.27825</td>\n",
       "      <td>4.749525</td>\n",
       "      <td>179.340252</td>\n",
       "      <td>143.513077</td>\n",
       "      <td>1.024475</td>\n",
       "      <td>1.007450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2090.519531</td>\n",
       "      <td>15.147700</td>\n",
       "      <td>12.250001</td>\n",
       "      <td>416.813293</td>\n",
       "      <td>1.015100</td>\n",
       "      <td>3.15310</td>\n",
       "      <td>7.950000</td>\n",
       "      <td>507.152588</td>\n",
       "      <td>153.874649</td>\n",
       "      <td>26.908966</td>\n",
       "      <td>28.270100</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Measured Depth      Caliper  Borehole Size  Rate of Penetration  \\\n",
       "count     4042.000000  4042.000000    4042.000000          4042.000000   \n",
       "mean      1777.465109     9.717041       9.588261            66.658535   \n",
       "std        184.220933     1.874042       1.702171            40.962838   \n",
       "min       1456.992798     8.153500       8.500000             7.185368   \n",
       "25%       1610.954864     8.494600       8.500000            39.845470   \n",
       "50%       1782.595398     8.580300       8.500000            57.514475   \n",
       "75%       1936.557495    11.953675      12.250001            84.531580   \n",
       "max       2090.519531    15.147700      12.250001           416.813293   \n",
       "\n",
       "       Neutron Porosity  Bulk Density  Photo Electric Factor    Gamma Ray  \\\n",
       "count       4042.000000    4042.00000            4042.000000  4042.000000   \n",
       "mean           0.431642       2.21524               3.830918   153.433808   \n",
       "std            0.147389       0.15357               1.192266    45.941593   \n",
       "min            0.036401       1.40940               1.745000    49.108601   \n",
       "25%            0.326204       2.10480               2.770325   117.948736   \n",
       "50%            0.471200       2.16830               3.662900   155.046700   \n",
       "75%            0.527875       2.27825               4.749525   179.340252   \n",
       "max            1.015100       3.15310               7.950000   507.152588   \n",
       "\n",
       "       Compressional waves sonic  Deep Resistivity  Medium Deep Resistivity  \n",
       "count                4042.000000       4042.000000              4042.000000  \n",
       "mean                  123.936692          1.347869                 1.326556  \n",
       "std                    22.566178          2.078600                 2.112787  \n",
       "min                    57.211849          0.246213                 0.237000  \n",
       "25%                   108.363602          0.630248                 0.618952  \n",
       "50%                   130.737747          0.810511                 0.790850  \n",
       "75%                   143.513077          1.024475                 1.007450  \n",
       "max                   153.874649         26.908966                28.270100  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Columns_to_drop = [\n",
    "    My_Columns.FORMATION,\n",
    "    My_Columns.LITHOLOGY,\n",
    "    My_Columns.GROUP,\n",
    "    My_Columns.WELL,\n",
    "    My_Columns.X_LOC,\n",
    "    My_Columns.Y_LOC,\n",
    "    My_Columns.Z_LOC,\n",
    "    My_Columns.WELL,\n",
    "    My_Columns.CONFIDENCE,\n",
    "    My_Columns.SPECTRA_GAMMA_RAY,\n",
    "    My_Columns.AVERAGE_RATE_OF_PENETRATION,\n",
    "    My_Columns.MICRO_RESISTIVITY,\n",
    "    My_Columns.WEIGHT_OF_DRILLING_MUD,\n",
    "    My_Columns.FLUSHED_ZONE_RESISTIVITY,\n",
    "    My_Columns.SHEAR_WAVE_SONIC,\n",
    "    My_Columns.DIFFERENTIAL_CALIPER,\n",
    "    My_Columns.DENSITY_CORRECTION,\n",
    "]\n",
    "\n",
    "for column in Columns_to_drop:\n",
    "    if column in df.columns:\n",
    "        df.drop(column, axis=1, inplace=True)\n",
    "\n",
    "df = df.dropna()\n",
    "df.describe()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "for column in df.columns:\n",
    "    if column != My_Columns.DEPTH:\n",
    "        df[column] = np.log10(df[column])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>Measured Depth</th>\n",
       "      <th>Caliper</th>\n",
       "      <th>Borehole Size</th>\n",
       "      <th>Rate of Penetration</th>\n",
       "      <th>Neutron Porosity</th>\n",
       "      <th>Bulk Density</th>\n",
       "      <th>Photo Electric Factor</th>\n",
       "      <th>Gamma Ray</th>\n",
       "      <th>Compressional waves sonic</th>\n",
       "      <th>Deep Resistivity</th>\n",
       "      <th>Medium Deep Resistivity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1464.536569</td>\n",
       "      <td>1.083553</td>\n",
       "      <td>1.088136</td>\n",
       "      <td>1.930287</td>\n",
       "      <td>-0.339916</td>\n",
       "      <td>0.350323</td>\n",
       "      <td>0.703822</td>\n",
       "      <td>2.181490</td>\n",
       "      <td>2.150670</td>\n",
       "      <td>0.038147</td>\n",
       "      <td>0.022112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1479.776598</td>\n",
       "      <td>1.076553</td>\n",
       "      <td>1.088136</td>\n",
       "      <td>1.877439</td>\n",
       "      <td>-0.314823</td>\n",
       "      <td>0.348611</td>\n",
       "      <td>0.735052</td>\n",
       "      <td>2.175401</td>\n",
       "      <td>2.141604</td>\n",
       "      <td>0.035172</td>\n",
       "      <td>0.017848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1495.016630</td>\n",
       "      <td>1.082319</td>\n",
       "      <td>1.088136</td>\n",
       "      <td>2.000816</td>\n",
       "      <td>-0.284638</td>\n",
       "      <td>0.329416</td>\n",
       "      <td>0.714338</td>\n",
       "      <td>2.171120</td>\n",
       "      <td>2.166950</td>\n",
       "      <td>-0.076372</td>\n",
       "      <td>-0.100242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1510.256659</td>\n",
       "      <td>1.080330</td>\n",
       "      <td>1.088136</td>\n",
       "      <td>2.060809</td>\n",
       "      <td>-0.296453</td>\n",
       "      <td>0.328103</td>\n",
       "      <td>0.691741</td>\n",
       "      <td>2.224489</td>\n",
       "      <td>2.168049</td>\n",
       "      <td>-0.104694</td>\n",
       "      <td>-0.122322</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1525.496563</td>\n",
       "      <td>1.087745</td>\n",
       "      <td>1.088136</td>\n",
       "      <td>1.904790</td>\n",
       "      <td>-0.320127</td>\n",
       "      <td>0.332996</td>\n",
       "      <td>0.659078</td>\n",
       "      <td>2.245148</td>\n",
       "      <td>2.139089</td>\n",
       "      <td>-0.108299</td>\n",
       "      <td>-0.139098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1540.736571</td>\n",
       "      <td>1.093394</td>\n",
       "      <td>1.088136</td>\n",
       "      <td>2.016939</td>\n",
       "      <td>-0.332678</td>\n",
       "      <td>0.333427</td>\n",
       "      <td>0.724724</td>\n",
       "      <td>2.234611</td>\n",
       "      <td>2.142985</td>\n",
       "      <td>0.017889</td>\n",
       "      <td>-0.020161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1555.976602</td>\n",
       "      <td>1.097132</td>\n",
       "      <td>1.088136</td>\n",
       "      <td>1.926995</td>\n",
       "      <td>-0.302811</td>\n",
       "      <td>0.334049</td>\n",
       "      <td>0.734980</td>\n",
       "      <td>2.197052</td>\n",
       "      <td>2.152321</td>\n",
       "      <td>-0.053530</td>\n",
       "      <td>-0.069733</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1571.216633</td>\n",
       "      <td>1.096660</td>\n",
       "      <td>1.088136</td>\n",
       "      <td>1.826422</td>\n",
       "      <td>-0.294591</td>\n",
       "      <td>0.331823</td>\n",
       "      <td>0.735606</td>\n",
       "      <td>2.174686</td>\n",
       "      <td>2.165681</td>\n",
       "      <td>-0.088345</td>\n",
       "      <td>-0.105272</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1586.456664</td>\n",
       "      <td>1.123591</td>\n",
       "      <td>1.088136</td>\n",
       "      <td>1.970631</td>\n",
       "      <td>-0.284060</td>\n",
       "      <td>0.320222</td>\n",
       "      <td>0.678687</td>\n",
       "      <td>2.179079</td>\n",
       "      <td>2.172576</td>\n",
       "      <td>-0.139464</td>\n",
       "      <td>-0.159128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1601.696588</td>\n",
       "      <td>1.125329</td>\n",
       "      <td>1.088136</td>\n",
       "      <td>1.967697</td>\n",
       "      <td>-0.278524</td>\n",
       "      <td>0.330490</td>\n",
       "      <td>0.758256</td>\n",
       "      <td>2.192091</td>\n",
       "      <td>2.152816</td>\n",
       "      <td>-0.067189</td>\n",
       "      <td>-0.085031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1616.936575</td>\n",
       "      <td>1.131390</td>\n",
       "      <td>1.088136</td>\n",
       "      <td>1.925653</td>\n",
       "      <td>-0.281492</td>\n",
       "      <td>0.324928</td>\n",
       "      <td>0.706744</td>\n",
       "      <td>2.182950</td>\n",
       "      <td>2.158606</td>\n",
       "      <td>-0.081381</td>\n",
       "      <td>-0.105721</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1636.949783</td>\n",
       "      <td>1.077200</td>\n",
       "      <td>1.045282</td>\n",
       "      <td>1.979951</td>\n",
       "      <td>-0.258471</td>\n",
       "      <td>0.325300</td>\n",
       "      <td>0.693818</td>\n",
       "      <td>2.200747</td>\n",
       "      <td>2.160527</td>\n",
       "      <td>-0.230852</td>\n",
       "      <td>-0.243429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1665.095071</td>\n",
       "      <td>0.939136</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.656937</td>\n",
       "      <td>-0.183226</td>\n",
       "      <td>0.324253</td>\n",
       "      <td>0.582557</td>\n",
       "      <td>2.254224</td>\n",
       "      <td>2.166123</td>\n",
       "      <td>-0.156293</td>\n",
       "      <td>-0.160301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1680.334994</td>\n",
       "      <td>0.938182</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.674381</td>\n",
       "      <td>-0.197757</td>\n",
       "      <td>0.338125</td>\n",
       "      <td>0.578826</td>\n",
       "      <td>2.268159</td>\n",
       "      <td>2.163943</td>\n",
       "      <td>-0.145114</td>\n",
       "      <td>-0.141488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1695.574983</td>\n",
       "      <td>0.944799</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.736249</td>\n",
       "      <td>-0.190095</td>\n",
       "      <td>0.331873</td>\n",
       "      <td>0.585773</td>\n",
       "      <td>2.252962</td>\n",
       "      <td>2.167057</td>\n",
       "      <td>-0.171137</td>\n",
       "      <td>-0.166074</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1710.815016</td>\n",
       "      <td>0.937185</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.661202</td>\n",
       "      <td>-0.203472</td>\n",
       "      <td>0.329477</td>\n",
       "      <td>0.571124</td>\n",
       "      <td>2.259924</td>\n",
       "      <td>2.168679</td>\n",
       "      <td>-0.173381</td>\n",
       "      <td>-0.171981</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1726.055044</td>\n",
       "      <td>0.934035</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.616072</td>\n",
       "      <td>-0.289488</td>\n",
       "      <td>0.341488</td>\n",
       "      <td>0.576433</td>\n",
       "      <td>2.205445</td>\n",
       "      <td>2.132667</td>\n",
       "      <td>-0.047548</td>\n",
       "      <td>-0.045042</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1741.295074</td>\n",
       "      <td>0.933274</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.673714</td>\n",
       "      <td>-0.309929</td>\n",
       "      <td>0.345858</td>\n",
       "      <td>0.544963</td>\n",
       "      <td>2.238448</td>\n",
       "      <td>2.112873</td>\n",
       "      <td>-0.013249</td>\n",
       "      <td>-0.007868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1756.535023</td>\n",
       "      <td>0.930159</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.682708</td>\n",
       "      <td>-0.309177</td>\n",
       "      <td>0.346541</td>\n",
       "      <td>0.471119</td>\n",
       "      <td>2.278799</td>\n",
       "      <td>2.130649</td>\n",
       "      <td>-0.085425</td>\n",
       "      <td>-0.081123</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1771.774988</td>\n",
       "      <td>0.930946</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.549623</td>\n",
       "      <td>-0.375432</td>\n",
       "      <td>0.352883</td>\n",
       "      <td>0.461138</td>\n",
       "      <td>2.235865</td>\n",
       "      <td>2.114297</td>\n",
       "      <td>-0.039938</td>\n",
       "      <td>-0.036419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1787.015018</td>\n",
       "      <td>0.930056</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.645698</td>\n",
       "      <td>-0.410002</td>\n",
       "      <td>0.332651</td>\n",
       "      <td>0.409429</td>\n",
       "      <td>2.157118</td>\n",
       "      <td>2.088501</td>\n",
       "      <td>-0.115274</td>\n",
       "      <td>-0.138052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1802.255048</td>\n",
       "      <td>0.935909</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.570082</td>\n",
       "      <td>-0.479889</td>\n",
       "      <td>0.317677</td>\n",
       "      <td>0.363016</td>\n",
       "      <td>2.044705</td>\n",
       "      <td>2.038980</td>\n",
       "      <td>-0.443163</td>\n",
       "      <td>-0.482671</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1817.495079</td>\n",
       "      <td>0.933841</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.802187</td>\n",
       "      <td>-0.480602</td>\n",
       "      <td>0.317139</td>\n",
       "      <td>0.349033</td>\n",
       "      <td>2.048882</td>\n",
       "      <td>2.040632</td>\n",
       "      <td>-0.455782</td>\n",
       "      <td>-0.493637</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1832.735048</td>\n",
       "      <td>0.931648</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.779519</td>\n",
       "      <td>-0.486816</td>\n",
       "      <td>0.319412</td>\n",
       "      <td>0.347696</td>\n",
       "      <td>2.049049</td>\n",
       "      <td>2.037106</td>\n",
       "      <td>-0.474532</td>\n",
       "      <td>-0.510216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1847.974991</td>\n",
       "      <td>0.929530</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.807708</td>\n",
       "      <td>-0.492977</td>\n",
       "      <td>0.319540</td>\n",
       "      <td>0.359106</td>\n",
       "      <td>2.051920</td>\n",
       "      <td>2.033763</td>\n",
       "      <td>-0.484178</td>\n",
       "      <td>-0.520159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1863.215021</td>\n",
       "      <td>0.928949</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.819145</td>\n",
       "      <td>-0.507295</td>\n",
       "      <td>0.326841</td>\n",
       "      <td>0.378698</td>\n",
       "      <td>2.072229</td>\n",
       "      <td>2.029943</td>\n",
       "      <td>-0.447990</td>\n",
       "      <td>-0.480679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1878.455052</td>\n",
       "      <td>0.926414</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.788986</td>\n",
       "      <td>-0.512134</td>\n",
       "      <td>0.325695</td>\n",
       "      <td>0.353038</td>\n",
       "      <td>2.057885</td>\n",
       "      <td>2.027732</td>\n",
       "      <td>-0.454909</td>\n",
       "      <td>-0.494178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1893.695082</td>\n",
       "      <td>0.927920</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.803531</td>\n",
       "      <td>-0.367608</td>\n",
       "      <td>0.355023</td>\n",
       "      <td>0.509932</td>\n",
       "      <td>2.224557</td>\n",
       "      <td>2.095728</td>\n",
       "      <td>-0.083342</td>\n",
       "      <td>-0.074077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1908.935076</td>\n",
       "      <td>0.925959</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>2.048284</td>\n",
       "      <td>-0.486657</td>\n",
       "      <td>0.331207</td>\n",
       "      <td>0.432270</td>\n",
       "      <td>2.077284</td>\n",
       "      <td>2.053412</td>\n",
       "      <td>-0.264039</td>\n",
       "      <td>-0.298488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1924.174994</td>\n",
       "      <td>0.926136</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.922318</td>\n",
       "      <td>-0.427384</td>\n",
       "      <td>0.340686</td>\n",
       "      <td>0.477875</td>\n",
       "      <td>2.094998</td>\n",
       "      <td>2.061332</td>\n",
       "      <td>-0.142494</td>\n",
       "      <td>-0.163240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>1939.415026</td>\n",
       "      <td>0.927904</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.688773</td>\n",
       "      <td>-0.310671</td>\n",
       "      <td>0.358495</td>\n",
       "      <td>0.593020</td>\n",
       "      <td>2.206826</td>\n",
       "      <td>2.104960</td>\n",
       "      <td>-0.034412</td>\n",
       "      <td>-0.031051</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>1954.655055</td>\n",
       "      <td>0.930860</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.700571</td>\n",
       "      <td>-0.376341</td>\n",
       "      <td>0.363867</td>\n",
       "      <td>0.582961</td>\n",
       "      <td>2.174250</td>\n",
       "      <td>2.086379</td>\n",
       "      <td>0.039840</td>\n",
       "      <td>0.034966</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1969.895087</td>\n",
       "      <td>0.931963</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>0.958304</td>\n",
       "      <td>-1.147381</td>\n",
       "      <td>0.413717</td>\n",
       "      <td>0.669320</td>\n",
       "      <td>1.742932</td>\n",
       "      <td>1.805378</td>\n",
       "      <td>0.924092</td>\n",
       "      <td>0.935360</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>1985.135103</td>\n",
       "      <td>0.928792</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.017658</td>\n",
       "      <td>-1.074798</td>\n",
       "      <td>0.408611</td>\n",
       "      <td>0.661190</td>\n",
       "      <td>1.765048</td>\n",
       "      <td>1.822278</td>\n",
       "      <td>0.809834</td>\n",
       "      <td>0.805749</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2000.374999</td>\n",
       "      <td>0.932309</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.369355</td>\n",
       "      <td>-0.651248</td>\n",
       "      <td>0.388061</td>\n",
       "      <td>0.536994</td>\n",
       "      <td>2.159316</td>\n",
       "      <td>1.996787</td>\n",
       "      <td>0.318074</td>\n",
       "      <td>0.303771</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2015.615027</td>\n",
       "      <td>0.931321</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.331966</td>\n",
       "      <td>-0.605529</td>\n",
       "      <td>0.393843</td>\n",
       "      <td>0.587560</td>\n",
       "      <td>2.199250</td>\n",
       "      <td>1.996632</td>\n",
       "      <td>0.295855</td>\n",
       "      <td>0.296417</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2030.855060</td>\n",
       "      <td>0.926171</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.687938</td>\n",
       "      <td>-0.471783</td>\n",
       "      <td>0.353891</td>\n",
       "      <td>0.476922</td>\n",
       "      <td>2.350084</td>\n",
       "      <td>2.054539</td>\n",
       "      <td>0.274969</td>\n",
       "      <td>0.261871</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2046.095088</td>\n",
       "      <td>0.926488</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.737005</td>\n",
       "      <td>-0.504388</td>\n",
       "      <td>0.376913</td>\n",
       "      <td>0.546405</td>\n",
       "      <td>2.305737</td>\n",
       "      <td>1.995487</td>\n",
       "      <td>0.049694</td>\n",
       "      <td>0.021429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2061.335120</td>\n",
       "      <td>0.926663</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.687723</td>\n",
       "      <td>-0.404184</td>\n",
       "      <td>0.364744</td>\n",
       "      <td>0.516124</td>\n",
       "      <td>2.286320</td>\n",
       "      <td>2.013651</td>\n",
       "      <td>0.009629</td>\n",
       "      <td>-0.012521</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>2076.575012</td>\n",
       "      <td>0.928886</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.687037</td>\n",
       "      <td>-0.380902</td>\n",
       "      <td>0.361880</td>\n",
       "      <td>0.460242</td>\n",
       "      <td>2.197062</td>\n",
       "      <td>2.006172</td>\n",
       "      <td>0.149895</td>\n",
       "      <td>0.133650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>2087.395421</td>\n",
       "      <td>0.931962</td>\n",
       "      <td>0.929419</td>\n",
       "      <td>1.581224</td>\n",
       "      <td>-0.292206</td>\n",
       "      <td>0.360965</td>\n",
       "      <td>0.441706</td>\n",
       "      <td>2.136966</td>\n",
       "      <td>2.006568</td>\n",
       "      <td>0.294270</td>\n",
       "      <td>0.295373</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Measured Depth   Caliper  Borehole Size  Rate of Penetration  \\\n",
       "0      1464.536569  1.083553       1.088136             1.930287   \n",
       "1      1479.776598  1.076553       1.088136             1.877439   \n",
       "2      1495.016630  1.082319       1.088136             2.000816   \n",
       "3      1510.256659  1.080330       1.088136             2.060809   \n",
       "4      1525.496563  1.087745       1.088136             1.904790   \n",
       "5      1540.736571  1.093394       1.088136             2.016939   \n",
       "6      1555.976602  1.097132       1.088136             1.926995   \n",
       "7      1571.216633  1.096660       1.088136             1.826422   \n",
       "8      1586.456664  1.123591       1.088136             1.970631   \n",
       "9      1601.696588  1.125329       1.088136             1.967697   \n",
       "10     1616.936575  1.131390       1.088136             1.925653   \n",
       "11     1636.949783  1.077200       1.045282             1.979951   \n",
       "12     1665.095071  0.939136       0.929419             1.656937   \n",
       "13     1680.334994  0.938182       0.929419             1.674381   \n",
       "14     1695.574983  0.944799       0.929419             1.736249   \n",
       "15     1710.815016  0.937185       0.929419             1.661202   \n",
       "16     1726.055044  0.934035       0.929419             1.616072   \n",
       "17     1741.295074  0.933274       0.929419             1.673714   \n",
       "18     1756.535023  0.930159       0.929419             1.682708   \n",
       "19     1771.774988  0.930946       0.929419             1.549623   \n",
       "20     1787.015018  0.930056       0.929419             1.645698   \n",
       "21     1802.255048  0.935909       0.929419             1.570082   \n",
       "22     1817.495079  0.933841       0.929419             1.802187   \n",
       "23     1832.735048  0.931648       0.929419             1.779519   \n",
       "24     1847.974991  0.929530       0.929419             1.807708   \n",
       "25     1863.215021  0.928949       0.929419             1.819145   \n",
       "26     1878.455052  0.926414       0.929419             1.788986   \n",
       "27     1893.695082  0.927920       0.929419             1.803531   \n",
       "28     1908.935076  0.925959       0.929419             2.048284   \n",
       "29     1924.174994  0.926136       0.929419             1.922318   \n",
       "30     1939.415026  0.927904       0.929419             1.688773   \n",
       "31     1954.655055  0.930860       0.929419             1.700571   \n",
       "32     1969.895087  0.931963       0.929419             0.958304   \n",
       "33     1985.135103  0.928792       0.929419             1.017658   \n",
       "34     2000.374999  0.932309       0.929419             1.369355   \n",
       "35     2015.615027  0.931321       0.929419             1.331966   \n",
       "36     2030.855060  0.926171       0.929419             1.687938   \n",
       "37     2046.095088  0.926488       0.929419             1.737005   \n",
       "38     2061.335120  0.926663       0.929419             1.687723   \n",
       "39     2076.575012  0.928886       0.929419             1.687037   \n",
       "40     2087.395421  0.931962       0.929419             1.581224   \n",
       "\n",
       "    Neutron Porosity  Bulk Density  Photo Electric Factor  Gamma Ray  \\\n",
       "0          -0.339916      0.350323               0.703822   2.181490   \n",
       "1          -0.314823      0.348611               0.735052   2.175401   \n",
       "2          -0.284638      0.329416               0.714338   2.171120   \n",
       "3          -0.296453      0.328103               0.691741   2.224489   \n",
       "4          -0.320127      0.332996               0.659078   2.245148   \n",
       "5          -0.332678      0.333427               0.724724   2.234611   \n",
       "6          -0.302811      0.334049               0.734980   2.197052   \n",
       "7          -0.294591      0.331823               0.735606   2.174686   \n",
       "8          -0.284060      0.320222               0.678687   2.179079   \n",
       "9          -0.278524      0.330490               0.758256   2.192091   \n",
       "10         -0.281492      0.324928               0.706744   2.182950   \n",
       "11         -0.258471      0.325300               0.693818   2.200747   \n",
       "12         -0.183226      0.324253               0.582557   2.254224   \n",
       "13         -0.197757      0.338125               0.578826   2.268159   \n",
       "14         -0.190095      0.331873               0.585773   2.252962   \n",
       "15         -0.203472      0.329477               0.571124   2.259924   \n",
       "16         -0.289488      0.341488               0.576433   2.205445   \n",
       "17         -0.309929      0.345858               0.544963   2.238448   \n",
       "18         -0.309177      0.346541               0.471119   2.278799   \n",
       "19         -0.375432      0.352883               0.461138   2.235865   \n",
       "20         -0.410002      0.332651               0.409429   2.157118   \n",
       "21         -0.479889      0.317677               0.363016   2.044705   \n",
       "22         -0.480602      0.317139               0.349033   2.048882   \n",
       "23         -0.486816      0.319412               0.347696   2.049049   \n",
       "24         -0.492977      0.319540               0.359106   2.051920   \n",
       "25         -0.507295      0.326841               0.378698   2.072229   \n",
       "26         -0.512134      0.325695               0.353038   2.057885   \n",
       "27         -0.367608      0.355023               0.509932   2.224557   \n",
       "28         -0.486657      0.331207               0.432270   2.077284   \n",
       "29         -0.427384      0.340686               0.477875   2.094998   \n",
       "30         -0.310671      0.358495               0.593020   2.206826   \n",
       "31         -0.376341      0.363867               0.582961   2.174250   \n",
       "32         -1.147381      0.413717               0.669320   1.742932   \n",
       "33         -1.074798      0.408611               0.661190   1.765048   \n",
       "34         -0.651248      0.388061               0.536994   2.159316   \n",
       "35         -0.605529      0.393843               0.587560   2.199250   \n",
       "36         -0.471783      0.353891               0.476922   2.350084   \n",
       "37         -0.504388      0.376913               0.546405   2.305737   \n",
       "38         -0.404184      0.364744               0.516124   2.286320   \n",
       "39         -0.380902      0.361880               0.460242   2.197062   \n",
       "40         -0.292206      0.360965               0.441706   2.136966   \n",
       "\n",
       "    Compressional waves sonic  Deep Resistivity  Medium Deep Resistivity  \n",
       "0                    2.150670          0.038147                 0.022112  \n",
       "1                    2.141604          0.035172                 0.017848  \n",
       "2                    2.166950         -0.076372                -0.100242  \n",
       "3                    2.168049         -0.104694                -0.122322  \n",
       "4                    2.139089         -0.108299                -0.139098  \n",
       "5                    2.142985          0.017889                -0.020161  \n",
       "6                    2.152321         -0.053530                -0.069733  \n",
       "7                    2.165681         -0.088345                -0.105272  \n",
       "8                    2.172576         -0.139464                -0.159128  \n",
       "9                    2.152816         -0.067189                -0.085031  \n",
       "10                   2.158606         -0.081381                -0.105721  \n",
       "11                   2.160527         -0.230852                -0.243429  \n",
       "12                   2.166123         -0.156293                -0.160301  \n",
       "13                   2.163943         -0.145114                -0.141488  \n",
       "14                   2.167057         -0.171137                -0.166074  \n",
       "15                   2.168679         -0.173381                -0.171981  \n",
       "16                   2.132667         -0.047548                -0.045042  \n",
       "17                   2.112873         -0.013249                -0.007868  \n",
       "18                   2.130649         -0.085425                -0.081123  \n",
       "19                   2.114297         -0.039938                -0.036419  \n",
       "20                   2.088501         -0.115274                -0.138052  \n",
       "21                   2.038980         -0.443163                -0.482671  \n",
       "22                   2.040632         -0.455782                -0.493637  \n",
       "23                   2.037106         -0.474532                -0.510216  \n",
       "24                   2.033763         -0.484178                -0.520159  \n",
       "25                   2.029943         -0.447990                -0.480679  \n",
       "26                   2.027732         -0.454909                -0.494178  \n",
       "27                   2.095728         -0.083342                -0.074077  \n",
       "28                   2.053412         -0.264039                -0.298488  \n",
       "29                   2.061332         -0.142494                -0.163240  \n",
       "30                   2.104960         -0.034412                -0.031051  \n",
       "31                   2.086379          0.039840                 0.034966  \n",
       "32                   1.805378          0.924092                 0.935360  \n",
       "33                   1.822278          0.809834                 0.805749  \n",
       "34                   1.996787          0.318074                 0.303771  \n",
       "35                   1.996632          0.295855                 0.296417  \n",
       "36                   2.054539          0.274969                 0.261871  \n",
       "37                   1.995487          0.049694                 0.021429  \n",
       "38                   2.013651          0.009629                -0.012521  \n",
       "39                   2.006172          0.149895                 0.133650  \n",
       "40                   2.006568          0.294270                 0.295373  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df.groupby(np.arange(len(df)) // 100).mean()\n",
    "pd.set_option(\"display.max_columns\", None)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.plotly.v1+json": {
       "config": {
        "plotlyServerURL": "https://plot.ly"
       },
       "data": [
        {
         "hovertemplate": "variable=Caliper<br>value=%{x}<br>Measured Depth=%{y}<extra></extra>",
         "legendgroup": "Caliper",
         "line": {
          "color": "#636efa",
          "dash": "solid"
         },
         "marker": {
          "symbol": "circle"
         },
         "mode": "lines",
         "name": "Caliper",
         "orientation": "v",
         "showlegend": true,
         "type": "scatter",
         "x": [
          1.0835533119471785,
          1.0765530153756895,
          1.0823186625648764,
          1.0803295213566393,
          1.0877452655727569,
          1.0933939034834517,
          1.0971316960046575,
          1.0966598508583834,
          1.1235905329667555,
          1.1253286002886456,
          1.1313898105232152,
          1.0771995942597155,
          0.9391358491203546,
          0.9381824304235284,
          0.9447986403303186,
          0.9371854084892661,
          0.9340348939877444,
          0.9332742054637231,
          0.9301594292511827,
          0.9309464082861078,
          0.9300561952547645,
          0.9359086397415506,
          0.9338410566790809,
          0.9316484748129693,
          0.9295304688684296,
          0.9289490117026392,
          0.9264143018161529,
          0.9279199429766497,
          0.9259589757995745,
          0.9261360469361989,
          0.9279038233289887,
          0.930860427536715,
          0.9319627849569619,
          0.9287918681659939,
          0.9323088283287193,
          0.9313213765963685,
          0.9261709763165952,
          0.9264877540110495,
          0.926662882328134,
          0.928886106722374,
          0.9319617129917371
         ],
         "xaxis": "x",
         "y": [
          1464.536568605,
          1479.776597902,
          1495.0166296399998,
          1510.2566589360001,
          1525.496562503,
          1540.736571044,
          1555.976601564,
          1571.216633301,
          1586.45666382,
          1601.696588135,
          1616.936574707,
          1636.949782717,
          1665.095070802,
          1680.334993896,
          1695.574982911,
          1710.815015868,
          1726.0550439469998,
          1741.295074462,
          1756.535023194,
          1771.774987795,
          1787.015018311,
          1802.2550476089998,
          1817.495079345,
          1832.7350476109998,
          1847.9749914550002,
          1863.2150207519999,
          1878.455052492,
          1893.695081788,
          1908.9350756850001,
          1924.1749938970001,
          1939.415025635,
          1954.655054932,
          1969.895086671,
          1985.135102538,
          2000.374998781,
          2015.615026858,
          2030.855059815,
          2046.095087891,
          2061.335119631,
          2076.5750122070003,
          2087.3954206214285
         ],
         "yaxis": "y"
        },
        {
         "hovertemplate": "variable=Borehole Size<br>value=%{x}<br>Measured Depth=%{y}<extra></extra>",
         "legendgroup": "Borehole Size",
         "line": {
          "color": "#EF553B",
          "dash": "solid"
         },
         "marker": {
          "symbol": "circle"
         },
         "mode": "lines",
         "name": "Borehole Size",
         "orientation": "v",
         "showlegend": true,
         "type": "scatter",
         "x": [
          1.0881361225223407,
          1.0881361225223407,
          1.0881361225223407,
          1.0881361225223407,
          1.0881361225223407,
          1.0881361225223407,
          1.0881361225223407,
          1.0881361225223407,
          1.0881361225223407,
          1.0881361225223407,
          1.0881361225223407,
          1.0452824793841677,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927,
          0.9294189257142927
         ],
         "xaxis": "x",
         "y": [
          1464.536568605,
          1479.776597902,
          1495.0166296399998,
          1510.2566589360001,
          1525.496562503,
          1540.736571044,
          1555.976601564,
          1571.216633301,
          1586.45666382,
          1601.696588135,
          1616.936574707,
          1636.949782717,
          1665.095070802,
          1680.334993896,
          1695.574982911,
          1710.815015868,
          1726.0550439469998,
          1741.295074462,
          1756.535023194,
          1771.774987795,
          1787.015018311,
          1802.2550476089998,
          1817.495079345,
          1832.7350476109998,
          1847.9749914550002,
          1863.2150207519999,
          1878.455052492,
          1893.695081788,
          1908.9350756850001,
          1924.1749938970001,
          1939.415025635,
          1954.655054932,
          1969.895086671,
          1985.135102538,
          2000.374998781,
          2015.615026858,
          2030.855059815,
          2046.095087891,
          2061.335119631,
          2076.5750122070003,
          2087.3954206214285
         ],
         "yaxis": "y"
        },
        {
         "hovertemplate": "variable=Rate of Penetration<br>value=%{x}<br>Measured Depth=%{y}<extra></extra>",
         "legendgroup": "Rate of Penetration",
         "line": {
          "color": "#00cc96",
          "dash": "solid"
         },
         "marker": {
          "symbol": "circle"
         },
         "mode": "lines",
         "name": "Rate of Penetration",
         "orientation": "v",
         "showlegend": true,
         "type": "scatter",
         "x": [
          1.930286795884663,
          1.8774389232177513,
          2.0008157296769506,
          2.060809438590902,
          1.9047899537190554,
          2.0169386209084905,
          1.9269954569300938,
          1.826421549118457,
          1.9706312896392597,
          1.9676974707069212,
          1.92565292875382,
          1.9799514689528603,
          1.6569369813015982,
          1.674381456549203,
          1.736248598012718,
          1.6612018905565755,
          1.6160715123122658,
          1.673713789239297,
          1.682708200550667,
          1.5496225520278415,
          1.645697891290026,
          1.570082379608692,
          1.8021869963352242,
          1.7795188626162908,
          1.8077082419355395,
          1.819145354214953,
          1.788986206814255,
          1.803530769991059,
          2.048284336687067,
          1.922317586114882,
          1.6887729184937685,
          1.700571056228509,
          0.9583042304179292,
          1.017658477744353,
          1.3693548664898287,
          1.3319661378348082,
          1.6879375477436462,
          1.7370049384579835,
          1.6877228265844453,
          1.6870366434357427,
          1.5812241051701874
         ],
         "xaxis": "x",
         "y": [
          1464.536568605,
          1479.776597902,
          1495.0166296399998,
          1510.2566589360001,
          1525.496562503,
          1540.736571044,
          1555.976601564,
          1571.216633301,
          1586.45666382,
          1601.696588135,
          1616.936574707,
          1636.949782717,
          1665.095070802,
          1680.334993896,
          1695.574982911,
          1710.815015868,
          1726.0550439469998,
          1741.295074462,
          1756.535023194,
          1771.774987795,
          1787.015018311,
          1802.2550476089998,
          1817.495079345,
          1832.7350476109998,
          1847.9749914550002,
          1863.2150207519999,
          1878.455052492,
          1893.695081788,
          1908.9350756850001,
          1924.1749938970001,
          1939.415025635,
          1954.655054932,
          1969.895086671,
          1985.135102538,
          2000.374998781,
          2015.615026858,
          2030.855059815,
          2046.095087891,
          2061.335119631,
          2076.5750122070003,
          2087.3954206214285
         ],
         "yaxis": "y"
        },
        {
         "hovertemplate": "variable=Neutron Porosity<br>value=%{x}<br>Measured Depth=%{y}<extra></extra>",
         "legendgroup": "Neutron Porosity",
         "line": {
          "color": "#ab63fa",
          "dash": "solid"
         },
         "marker": {
          "symbol": "circle"
         },
         "mode": "lines",
         "name": "Neutron Porosity",
         "orientation": "v",
         "showlegend": true,
         "type": "scatter",
         "x": [
          -0.3399157945579342,
          -0.3148234756694121,
          -0.2846383684851058,
          -0.2964525550537298,
          -0.3201270554087207,
          -0.3326782839215598,
          -0.3028105260215813,
          -0.29459113413884364,
          -0.2840602576697418,
          -0.27852417310923183,
          -0.28149177813323295,
          -0.25847138825729005,
          -0.1832256671218189,
          -0.19775667346204462,
          -0.19009518575784612,
          -0.20347151699287924,
          -0.2894879106458282,
          -0.3099291281084666,
          -0.3091769043406077,
          -0.37543187387036864,
          -0.41000161922207,
          -0.4798894360207131,
          -0.4806022262672347,
          -0.48681641474323284,
          -0.4929773699294142,
          -0.5072945897317784,
          -0.5121337085445797,
          -0.36760824405574505,
          -0.48665659626445923,
          -0.427384374963522,
          -0.310671045568234,
          -0.3763405393272315,
          -1.147381378773494,
          -1.0747980295914663,
          -0.6512484202927695,
          -0.6055291768935911,
          -0.47178263685847066,
          -0.5043881865327912,
          -0.40418373196655366,
          -0.3809016173364772,
          -0.2922055714029891
         ],
         "xaxis": "x",
         "y": [
          1464.536568605,
          1479.776597902,
          1495.0166296399998,
          1510.2566589360001,
          1525.496562503,
          1540.736571044,
          1555.976601564,
          1571.216633301,
          1586.45666382,
          1601.696588135,
          1616.936574707,
          1636.949782717,
          1665.095070802,
          1680.334993896,
          1695.574982911,
          1710.815015868,
          1726.0550439469998,
          1741.295074462,
          1756.535023194,
          1771.774987795,
          1787.015018311,
          1802.2550476089998,
          1817.495079345,
          1832.7350476109998,
          1847.9749914550002,
          1863.2150207519999,
          1878.455052492,
          1893.695081788,
          1908.9350756850001,
          1924.1749938970001,
          1939.415025635,
          1954.655054932,
          1969.895086671,
          1985.135102538,
          2000.374998781,
          2015.615026858,
          2030.855059815,
          2046.095087891,
          2061.335119631,
          2076.5750122070003,
          2087.3954206214285
         ],
         "yaxis": "y"
        },
        {
         "hovertemplate": "variable=Bulk Density<br>value=%{x}<br>Measured Depth=%{y}<extra></extra>",
         "legendgroup": "Bulk Density",
         "line": {
          "color": "#FFA15A",
          "dash": "solid"
         },
         "marker": {
          "symbol": "circle"
         },
         "mode": "lines",
         "name": "Bulk Density",
         "orientation": "v",
         "showlegend": true,
         "type": "scatter",
         "x": [
          0.3503230407106709,
          0.3486112252824526,
          0.32941575591056377,
          0.3281030849745018,
          0.33299643482057584,
          0.3334266417455601,
          0.334049175994634,
          0.33182289623035643,
          0.32022193448474967,
          0.33049001247783366,
          0.3249279140429769,
          0.3252998552448554,
          0.32425312909476844,
          0.33812508561066323,
          0.33187268892512983,
          0.32947668900941274,
          0.3414876018238367,
          0.34585822891849555,
          0.3465407442766019,
          0.35288321714933224,
          0.33265091102011046,
          0.3176770145954309,
          0.3171394569391816,
          0.31941181579704075,
          0.31954020013570134,
          0.3268412602317898,
          0.32569477781041273,
          0.355023230960836,
          0.3312065405645604,
          0.3406859283876396,
          0.3584951281337369,
          0.36386679484015866,
          0.4137170092688717,
          0.40861086698681376,
          0.3880612614293392,
          0.3938429569896658,
          0.3538906751672817,
          0.3769126127847261,
          0.36474356114176787,
          0.3618797288903688,
          0.36096492830856375
         ],
         "xaxis": "x",
         "y": [
          1464.536568605,
          1479.776597902,
          1495.0166296399998,
          1510.2566589360001,
          1525.496562503,
          1540.736571044,
          1555.976601564,
          1571.216633301,
          1586.45666382,
          1601.696588135,
          1616.936574707,
          1636.949782717,
          1665.095070802,
          1680.334993896,
          1695.574982911,
          1710.815015868,
          1726.0550439469998,
          1741.295074462,
          1756.535023194,
          1771.774987795,
          1787.015018311,
          1802.2550476089998,
          1817.495079345,
          1832.7350476109998,
          1847.9749914550002,
          1863.2150207519999,
          1878.455052492,
          1893.695081788,
          1908.9350756850001,
          1924.1749938970001,
          1939.415025635,
          1954.655054932,
          1969.895086671,
          1985.135102538,
          2000.374998781,
          2015.615026858,
          2030.855059815,
          2046.095087891,
          2061.335119631,
          2076.5750122070003,
          2087.3954206214285
         ],
         "yaxis": "y"
        },
        {
         "hovertemplate": "variable=Photo Electric Factor<br>value=%{x}<br>Measured Depth=%{y}<extra></extra>",
         "legendgroup": "Photo Electric Factor",
         "line": {
          "color": "#19d3f3",
          "dash": "solid"
         },
         "marker": {
          "symbol": "circle"
         },
         "mode": "lines",
         "name": "Photo Electric Factor",
         "orientation": "v",
         "showlegend": true,
         "type": "scatter",
         "x": [
          0.7038222609025907,
          0.7350516976100954,
          0.7143375065074671,
          0.691740931837919,
          0.6590778629534149,
          0.7247243373917854,
          0.7349797945015859,
          0.7356061706963475,
          0.6786873863363687,
          0.7582559102370279,
          0.7067435011555466,
          0.6938175859490898,
          0.5825573142470766,
          0.5788263905911457,
          0.5857731515942352,
          0.5711235252365128,
          0.5764327660890388,
          0.5449630826394533,
          0.47111915529670745,
          0.4611376067103926,
          0.4094287451910437,
          0.36301605298407635,
          0.34903280421641447,
          0.34769616909866924,
          0.3591063587234001,
          0.3786983504399605,
          0.35303756543653614,
          0.509931848451683,
          0.43226981923485197,
          0.4778745223146815,
          0.5930201840359355,
          0.5829614233982835,
          0.6693203050909818,
          0.6611903845359108,
          0.5369943070800738,
          0.5875599747952241,
          0.47692180872714685,
          0.5464047421661266,
          0.5161237872530154,
          0.4602422188687757,
          0.44170635959146454
         ],
         "xaxis": "x",
         "y": [
          1464.536568605,
          1479.776597902,
          1495.0166296399998,
          1510.2566589360001,
          1525.496562503,
          1540.736571044,
          1555.976601564,
          1571.216633301,
          1586.45666382,
          1601.696588135,
          1616.936574707,
          1636.949782717,
          1665.095070802,
          1680.334993896,
          1695.574982911,
          1710.815015868,
          1726.0550439469998,
          1741.295074462,
          1756.535023194,
          1771.774987795,
          1787.015018311,
          1802.2550476089998,
          1817.495079345,
          1832.7350476109998,
          1847.9749914550002,
          1863.2150207519999,
          1878.455052492,
          1893.695081788,
          1908.9350756850001,
          1924.1749938970001,
          1939.415025635,
          1954.655054932,
          1969.895086671,
          1985.135102538,
          2000.374998781,
          2015.615026858,
          2030.855059815,
          2046.095087891,
          2061.335119631,
          2076.5750122070003,
          2087.3954206214285
         ],
         "yaxis": "y"
        },
        {
         "hovertemplate": "variable=Gamma Ray<br>value=%{x}<br>Measured Depth=%{y}<extra></extra>",
         "legendgroup": "Gamma Ray",
         "line": {
          "color": "#FF6692",
          "dash": "solid"
         },
         "marker": {
          "symbol": "circle"
         },
         "mode": "lines",
         "name": "Gamma Ray",
         "orientation": "v",
         "showlegend": true,
         "type": "scatter",
         "x": [
          2.1814898071947844,
          2.1754005257707045,
          2.1711201018880577,
          2.2244889464825675,
          2.245148379056161,
          2.2346107446660124,
          2.197052030532457,
          2.1746863828171836,
          2.1790791123129534,
          2.192090747979513,
          2.1829502435633383,
          2.2007472126631034,
          2.2542243059571536,
          2.2681587603490327,
          2.252961769236316,
          2.259923875095266,
          2.205445065527052,
          2.2384477185826515,
          2.278798851070964,
          2.235864835192946,
          2.157118474285295,
          2.044705308321733,
          2.048881657531291,
          2.049049286473735,
          2.051920045601544,
          2.0722291677566522,
          2.0578854061941927,
          2.224557404205766,
          2.077283893898799,
          2.0949977755215032,
          2.2068256490697022,
          2.17425004714642,
          1.742931505084976,
          1.7650482484349042,
          2.1593161165972647,
          2.199249595494209,
          2.350084383236815,
          2.3057367001128752,
          2.286320247138376,
          2.1970619262066187,
          2.1369663997727306
         ],
         "xaxis": "x",
         "y": [
          1464.536568605,
          1479.776597902,
          1495.0166296399998,
          1510.2566589360001,
          1525.496562503,
          1540.736571044,
          1555.976601564,
          1571.216633301,
          1586.45666382,
          1601.696588135,
          1616.936574707,
          1636.949782717,
          1665.095070802,
          1680.334993896,
          1695.574982911,
          1710.815015868,
          1726.0550439469998,
          1741.295074462,
          1756.535023194,
          1771.774987795,
          1787.015018311,
          1802.2550476089998,
          1817.495079345,
          1832.7350476109998,
          1847.9749914550002,
          1863.2150207519999,
          1878.455052492,
          1893.695081788,
          1908.9350756850001,
          1924.1749938970001,
          1939.415025635,
          1954.655054932,
          1969.895086671,
          1985.135102538,
          2000.374998781,
          2015.615026858,
          2030.855059815,
          2046.095087891,
          2061.335119631,
          2076.5750122070003,
          2087.3954206214285
         ],
         "yaxis": "y"
        },
        {
         "hovertemplate": "variable=Compressional waves sonic<br>value=%{x}<br>Measured Depth=%{y}<extra></extra>",
         "legendgroup": "Compressional waves sonic",
         "line": {
          "color": "#B6E880",
          "dash": "solid"
         },
         "marker": {
          "symbol": "circle"
         },
         "mode": "lines",
         "name": "Compressional waves sonic",
         "orientation": "v",
         "showlegend": true,
         "type": "scatter",
         "x": [
          2.1506701039730296,
          2.141604240357138,
          2.166950136413172,
          2.1680491737807173,
          2.139089296406319,
          2.1429848336482875,
          2.1523211535496003,
          2.165680609050534,
          2.172576294066736,
          2.1528161615650885,
          2.1586056695067386,
          2.1605269039420687,
          2.1661226265814912,
          2.163943399051801,
          2.1670566500269435,
          2.168679443385299,
          2.132666605745057,
          2.1128726545212526,
          2.1306487732236232,
          2.114296636915899,
          2.0885008017721804,
          2.0389796490263747,
          2.040631586780488,
          2.037106390787158,
          2.033763058294467,
          2.0299428433222673,
          2.0277316418497198,
          2.0957280222432986,
          2.053411927747014,
          2.0613324181118915,
          2.1049596935306085,
          2.0863791003332492,
          1.8053784082374122,
          1.8222783975087484,
          1.9967872565894031,
          1.9966315478792138,
          2.054539446517251,
          1.9954865514285507,
          2.0136507540213815,
          2.0061716659585738,
          2.0065684253258462
         ],
         "xaxis": "x",
         "y": [
          1464.536568605,
          1479.776597902,
          1495.0166296399998,
          1510.2566589360001,
          1525.496562503,
          1540.736571044,
          1555.976601564,
          1571.216633301,
          1586.45666382,
          1601.696588135,
          1616.936574707,
          1636.949782717,
          1665.095070802,
          1680.334993896,
          1695.574982911,
          1710.815015868,
          1726.0550439469998,
          1741.295074462,
          1756.535023194,
          1771.774987795,
          1787.015018311,
          1802.2550476089998,
          1817.495079345,
          1832.7350476109998,
          1847.9749914550002,
          1863.2150207519999,
          1878.455052492,
          1893.695081788,
          1908.9350756850001,
          1924.1749938970001,
          1939.415025635,
          1954.655054932,
          1969.895086671,
          1985.135102538,
          2000.374998781,
          2015.615026858,
          2030.855059815,
          2046.095087891,
          2061.335119631,
          2076.5750122070003,
          2087.3954206214285
         ],
         "yaxis": "y"
        },
        {
         "hovertemplate": "variable=Deep Resistivity<br>value=%{x}<br>Measured Depth=%{y}<extra></extra>",
         "legendgroup": "Deep Resistivity",
         "line": {
          "color": "#FF97FF",
          "dash": "solid"
         },
         "marker": {
          "symbol": "circle"
         },
         "mode": "lines",
         "name": "Deep Resistivity",
         "orientation": "v",
         "showlegend": true,
         "type": "scatter",
         "x": [
          0.038146640886640173,
          0.03517189939214452,
          -0.07637237931909452,
          -0.10469409699001883,
          -0.10829938520579561,
          0.01788892153819302,
          -0.05353041835497856,
          -0.08834485567353013,
          -0.13946428970883593,
          -0.06718869774788759,
          -0.08138108041261635,
          -0.2308517348149456,
          -0.15629280373772164,
          -0.14511389935619817,
          -0.17113731647141323,
          -0.1733811472402175,
          -0.04754820885349084,
          -0.013248662334364794,
          -0.08542482732564398,
          -0.03993784989247998,
          -0.11527433371256456,
          -0.44316273096521136,
          -0.45578203925355526,
          -0.4745320005725305,
          -0.4841775038046137,
          -0.447989594895715,
          -0.4549093131934978,
          -0.08334187183188056,
          -0.2640394859185203,
          -0.14249376405538844,
          -0.03441232337786851,
          0.039840446633507026,
          0.9240915172501719,
          0.8098340204358688,
          0.31807375124481874,
          0.29585465461259813,
          0.2749688612763261,
          0.04969388814024038,
          0.00962854069043415,
          0.14989526563778077,
          0.29426975526937776
         ],
         "xaxis": "x",
         "y": [
          1464.536568605,
          1479.776597902,
          1495.0166296399998,
          1510.2566589360001,
          1525.496562503,
          1540.736571044,
          1555.976601564,
          1571.216633301,
          1586.45666382,
          1601.696588135,
          1616.936574707,
          1636.949782717,
          1665.095070802,
          1680.334993896,
          1695.574982911,
          1710.815015868,
          1726.0550439469998,
          1741.295074462,
          1756.535023194,
          1771.774987795,
          1787.015018311,
          1802.2550476089998,
          1817.495079345,
          1832.7350476109998,
          1847.9749914550002,
          1863.2150207519999,
          1878.455052492,
          1893.695081788,
          1908.9350756850001,
          1924.1749938970001,
          1939.415025635,
          1954.655054932,
          1969.895086671,
          1985.135102538,
          2000.374998781,
          2015.615026858,
          2030.855059815,
          2046.095087891,
          2061.335119631,
          2076.5750122070003,
          2087.3954206214285
         ],
         "yaxis": "y"
        },
        {
         "hovertemplate": "variable=Medium Deep Resistivity<br>value=%{x}<br>Measured Depth=%{y}<extra></extra>",
         "legendgroup": "Medium Deep Resistivity",
         "line": {
          "color": "#FECB52",
          "dash": "solid"
         },
         "marker": {
          "symbol": "circle"
         },
         "mode": "lines",
         "name": "Medium Deep Resistivity",
         "orientation": "v",
         "showlegend": true,
         "type": "scatter",
         "x": [
          0.02211154535758711,
          0.01784840338972453,
          -0.10024167442937468,
          -0.12232156054010054,
          -0.13909758339548892,
          -0.0201613566598314,
          -0.06973253451996557,
          -0.10527201575374379,
          -0.15912779750735193,
          -0.08503110482191593,
          -0.10572051207073771,
          -0.24342878053513917,
          -0.16030055908930518,
          -0.14148784650020743,
          -0.16607417915550113,
          -0.17198090923780518,
          -0.04504208196138893,
          -0.007867865623688266,
          -0.08112309513538424,
          -0.03641900978190094,
          -0.13805226903101148,
          -0.4826712320465801,
          -0.4936366774740554,
          -0.5102161408143698,
          -0.5201588526451945,
          -0.4806787344365434,
          -0.49417793674773086,
          -0.07407675219550228,
          -0.29848815601565637,
          -0.16323974326889196,
          -0.0310505950843688,
          0.03496600408877128,
          0.9353595659626975,
          0.8057488237697175,
          0.30377139491742966,
          0.29641704848838324,
          0.2618705937830279,
          0.02142880724849769,
          -0.012521203271334946,
          0.1336503461946713,
          0.295372766166452
         ],
         "xaxis": "x",
         "y": [
          1464.536568605,
          1479.776597902,
          1495.0166296399998,
          1510.2566589360001,
          1525.496562503,
          1540.736571044,
          1555.976601564,
          1571.216633301,
          1586.45666382,
          1601.696588135,
          1616.936574707,
          1636.949782717,
          1665.095070802,
          1680.334993896,
          1695.574982911,
          1710.815015868,
          1726.0550439469998,
          1741.295074462,
          1756.535023194,
          1771.774987795,
          1787.015018311,
          1802.2550476089998,
          1817.495079345,
          1832.7350476109998,
          1847.9749914550002,
          1863.2150207519999,
          1878.455052492,
          1893.695081788,
          1908.9350756850001,
          1924.1749938970001,
          1939.415025635,
          1954.655054932,
          1969.895086671,
          1985.135102538,
          2000.374998781,
          2015.615026858,
          2030.855059815,
          2046.095087891,
          2061.335119631,
          2076.5750122070003,
          2087.3954206214285
         ],
         "yaxis": "y"
        }
       ],
       "layout": {
        "height": 1000,
        "legend": {
         "title": {
          "text": "variable"
         },
         "tracegroupgap": 0
        },
        "margin": {
         "t": 60
        },
        "template": {
         "data": {
          "bar": [
           {
            "error_x": {
             "color": "#2a3f5f"
            },
            "error_y": {
             "color": "#2a3f5f"
            },
            "marker": {
             "line": {
              "color": "#E5ECF6",
              "width": 0.5
             },
             "pattern": {
              "fillmode": "overlay",
              "size": 10,
              "solidity": 0.2
             }
            },
            "type": "bar"
           }
          ],
          "barpolar": [
           {
            "marker": {
             "line": {
              "color": "#E5ECF6",
              "width": 0.5
             },
             "pattern": {
              "fillmode": "overlay",
              "size": 10,
              "solidity": 0.2
             }
            },
            "type": "barpolar"
           }
          ],
          "carpet": [
           {
            "aaxis": {
             "endlinecolor": "#2a3f5f",
             "gridcolor": "white",
             "linecolor": "white",
             "minorgridcolor": "white",
             "startlinecolor": "#2a3f5f"
            },
            "baxis": {
             "endlinecolor": "#2a3f5f",
             "gridcolor": "white",
             "linecolor": "white",
             "minorgridcolor": "white",
             "startlinecolor": "#2a3f5f"
            },
            "type": "carpet"
           }
          ],
          "choropleth": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "type": "choropleth"
           }
          ],
          "contour": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "contour"
           }
          ],
          "contourcarpet": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "type": "contourcarpet"
           }
          ],
          "heatmap": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "heatmap"
           }
          ],
          "heatmapgl": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "heatmapgl"
           }
          ],
          "histogram": [
           {
            "marker": {
             "pattern": {
              "fillmode": "overlay",
              "size": 10,
              "solidity": 0.2
             }
            },
            "type": "histogram"
           }
          ],
          "histogram2d": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "histogram2d"
           }
          ],
          "histogram2dcontour": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "histogram2dcontour"
           }
          ],
          "mesh3d": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "type": "mesh3d"
           }
          ],
          "parcoords": [
           {
            "line": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "parcoords"
           }
          ],
          "pie": [
           {
            "automargin": true,
            "type": "pie"
           }
          ],
          "scatter": [
           {
            "fillpattern": {
             "fillmode": "overlay",
             "size": 10,
             "solidity": 0.2
            },
            "type": "scatter"
           }
          ],
          "scatter3d": [
           {
            "line": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scatter3d"
           }
          ],
          "scattercarpet": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scattercarpet"
           }
          ],
          "scattergeo": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scattergeo"
           }
          ],
          "scattergl": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scattergl"
           }
          ],
          "scattermapbox": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scattermapbox"
           }
          ],
          "scatterpolar": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scatterpolar"
           }
          ],
          "scatterpolargl": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scatterpolargl"
           }
          ],
          "scatterternary": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scatterternary"
           }
          ],
          "surface": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "surface"
           }
          ],
          "table": [
           {
            "cells": {
             "fill": {
              "color": "#EBF0F8"
             },
             "line": {
              "color": "white"
             }
            },
            "header": {
             "fill": {
              "color": "#C8D4E3"
             },
             "line": {
              "color": "white"
             }
            },
            "type": "table"
           }
          ]
         },
         "layout": {
          "annotationdefaults": {
           "arrowcolor": "#2a3f5f",
           "arrowhead": 0,
           "arrowwidth": 1
          },
          "autotypenumbers": "strict",
          "coloraxis": {
           "colorbar": {
            "outlinewidth": 0,
            "ticks": ""
           }
          },
          "colorscale": {
           "diverging": [
            [
             0,
             "#8e0152"
            ],
            [
             0.1,
             "#c51b7d"
            ],
            [
             0.2,
             "#de77ae"
            ],
            [
             0.3,
             "#f1b6da"
            ],
            [
             0.4,
             "#fde0ef"
            ],
            [
             0.5,
             "#f7f7f7"
            ],
            [
             0.6,
             "#e6f5d0"
            ],
            [
             0.7,
             "#b8e186"
            ],
            [
             0.8,
             "#7fbc41"
            ],
            [
             0.9,
             "#4d9221"
            ],
            [
             1,
             "#276419"
            ]
           ],
           "sequential": [
            [
             0,
             "#0d0887"
            ],
            [
             0.1111111111111111,
             "#46039f"
            ],
            [
             0.2222222222222222,
             "#7201a8"
            ],
            [
             0.3333333333333333,
             "#9c179e"
            ],
            [
             0.4444444444444444,
             "#bd3786"
            ],
            [
             0.5555555555555556,
             "#d8576b"
            ],
            [
             0.6666666666666666,
             "#ed7953"
            ],
            [
             0.7777777777777778,
             "#fb9f3a"
            ],
            [
             0.8888888888888888,
             "#fdca26"
            ],
            [
             1,
             "#f0f921"
            ]
           ],
           "sequentialminus": [
            [
             0,
             "#0d0887"
            ],
            [
             0.1111111111111111,
             "#46039f"
            ],
            [
             0.2222222222222222,
             "#7201a8"
            ],
            [
             0.3333333333333333,
             "#9c179e"
            ],
            [
             0.4444444444444444,
             "#bd3786"
            ],
            [
             0.5555555555555556,
             "#d8576b"
            ],
            [
             0.6666666666666666,
             "#ed7953"
            ],
            [
             0.7777777777777778,
             "#fb9f3a"
            ],
            [
             0.8888888888888888,
             "#fdca26"
            ],
            [
             1,
             "#f0f921"
            ]
           ]
          },
          "colorway": [
           "#636efa",
           "#EF553B",
           "#00cc96",
           "#ab63fa",
           "#FFA15A",
           "#19d3f3",
           "#FF6692",
           "#B6E880",
           "#FF97FF",
           "#FECB52"
          ],
          "font": {
           "color": "#2a3f5f"
          },
          "geo": {
           "bgcolor": "white",
           "lakecolor": "white",
           "landcolor": "#E5ECF6",
           "showlakes": true,
           "showland": true,
           "subunitcolor": "white"
          },
          "hoverlabel": {
           "align": "left"
          },
          "hovermode": "closest",
          "mapbox": {
           "style": "light"
          },
          "paper_bgcolor": "white",
          "plot_bgcolor": "#E5ECF6",
          "polar": {
           "angularaxis": {
            "gridcolor": "white",
            "linecolor": "white",
            "ticks": ""
           },
           "bgcolor": "#E5ECF6",
           "radialaxis": {
            "gridcolor": "white",
            "linecolor": "white",
            "ticks": ""
           }
          },
          "scene": {
           "xaxis": {
            "backgroundcolor": "#E5ECF6",
            "gridcolor": "white",
            "gridwidth": 2,
            "linecolor": "white",
            "showbackground": true,
            "ticks": "",
            "zerolinecolor": "white"
           },
           "yaxis": {
            "backgroundcolor": "#E5ECF6",
            "gridcolor": "white",
            "gridwidth": 2,
            "linecolor": "white",
            "showbackground": true,
            "ticks": "",
            "zerolinecolor": "white"
           },
           "zaxis": {
            "backgroundcolor": "#E5ECF6",
            "gridcolor": "white",
            "gridwidth": 2,
            "linecolor": "white",
            "showbackground": true,
            "ticks": "",
            "zerolinecolor": "white"
           }
          },
          "shapedefaults": {
           "line": {
            "color": "#2a3f5f"
           }
          },
          "ternary": {
           "aaxis": {
            "gridcolor": "white",
            "linecolor": "white",
            "ticks": ""
           },
           "baxis": {
            "gridcolor": "white",
            "linecolor": "white",
            "ticks": ""
           },
           "bgcolor": "#E5ECF6",
           "caxis": {
            "gridcolor": "white",
            "linecolor": "white",
            "ticks": ""
           }
          },
          "title": {
           "x": 0.05
          },
          "xaxis": {
           "automargin": true,
           "gridcolor": "white",
           "linecolor": "white",
           "ticks": "",
           "title": {
            "standoff": 15
           },
           "zerolinecolor": "white",
           "zerolinewidth": 2
          },
          "yaxis": {
           "automargin": true,
           "gridcolor": "white",
           "linecolor": "white",
           "ticks": "",
           "title": {
            "standoff": 15
           },
           "zerolinecolor": "white",
           "zerolinewidth": 2
          }
         }
        },
        "width": 1000,
        "xaxis": {
         "anchor": "y",
         "domain": [
          0,
          1
         ],
         "title": {
          "text": "value"
         }
        },
        "yaxis": {
         "anchor": "x",
         "autorange": "reversed",
         "domain": [
          0,
          1
         ],
         "title": {
          "text": "Measured Depth"
         }
        }
       }
      }
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "fig = px.line(df, x=df.columns, y=My_Columns.DEPTH)\n",
    "fig.update_yaxes(autorange=\"reversed\")\n",
    "fig.update_layout(height=1000, width=1000)\n",
    "fig.show()"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "- Neutron Porosity tends to decrease with depth\n",
    "- Gamma tends to decrease with depth\n",
    "- Resistivity rends to increase with depth but generally it fluctuates\n",
    "- Other readings keep their mean value which means they are important only when they have anomalies"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "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.10.9"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}