30 - Creating A Combined Well Dataframe.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "aec957f7-a9ac-4361-8698-fa243983a8d4",
   "metadata": {},
   "outputs": [],
   "source": [
    "import lasio\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "4dbdd6bc-5cbb-4e2f-aef7-56c3364090f8",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_19SR = lasio.read('Data/15-9-19_SR_COMP.las').df()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "bab32693-210e-413a-bb58-7c93464af318",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_19SR.reset_index(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "11093ae9-3da8-442c-a011-a78887b4d6e8",
   "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>DEPT</th>\n",
       "      <th>AC</th>\n",
       "      <th>CALI</th>\n",
       "      <th>DEN</th>\n",
       "      <th>GR</th>\n",
       "      <th>NEU</th>\n",
       "      <th>RDEP</th>\n",
       "      <th>RMED</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>102.1568</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.3274</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>102.3092</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.8235</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>102.4616</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.5228</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>102.6140</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.2285</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>102.7664</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.5020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29749</th>\n",
       "      <td>4635.9044</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.7729</td>\n",
       "      <td>0.5978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29750</th>\n",
       "      <td>4636.0568</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.8369</td>\n",
       "      <td>0.6257</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29751</th>\n",
       "      <td>4636.2092</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.8741</td>\n",
       "      <td>0.6888</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29752</th>\n",
       "      <td>4636.3616</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.9002</td>\n",
       "      <td>0.8902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29753</th>\n",
       "      <td>4636.5140</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.9133</td>\n",
       "      <td>1.0363</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>29754 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            DEPT  AC  CALI  DEN      GR  NEU    RDEP    RMED\n",
       "0       102.1568 NaN   NaN  NaN  5.3274  NaN     NaN     NaN\n",
       "1       102.3092 NaN   NaN  NaN  5.8235  NaN     NaN     NaN\n",
       "2       102.4616 NaN   NaN  NaN  6.5228  NaN     NaN     NaN\n",
       "3       102.6140 NaN   NaN  NaN  7.2285  NaN     NaN     NaN\n",
       "4       102.7664 NaN   NaN  NaN  9.5020  NaN     NaN     NaN\n",
       "...          ...  ..   ...  ...     ...  ...     ...     ...\n",
       "29749  4635.9044 NaN   NaN  NaN     NaN  NaN  0.7729  0.5978\n",
       "29750  4636.0568 NaN   NaN  NaN     NaN  NaN  0.8369  0.6257\n",
       "29751  4636.2092 NaN   NaN  NaN     NaN  NaN  0.8741  0.6888\n",
       "29752  4636.3616 NaN   NaN  NaN     NaN  NaN  0.9002  0.8902\n",
       "29753  4636.5140 NaN   NaN  NaN     NaN  NaN  0.9133  1.0363\n",
       "\n",
       "[29754 rows x 8 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_19SR"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "91c1fcf8",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_19SR_formations = pd.read_csv('Data/Volve/15_9_19_SR_TOPS_NPD.csv', \n",
    "                                 header=None, names=['Formation', 'DEPT'])\n",
    "\n",
    "df_19SR_formations['DEPT'] = df_19SR_formations['DEPT'].astype(float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "ad1a14d2",
   "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>Formation</th>\n",
       "      <th>DEPT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>UTSIRA FM</td>\n",
       "      <td>846.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>UNDIFFERENTIATED</td>\n",
       "      <td>1080.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SKADE FM</td>\n",
       "      <td>1313.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NO FORMAL NAME</td>\n",
       "      <td>1451.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>GRID FM</td>\n",
       "      <td>3008.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NO FORMAL NAME</td>\n",
       "      <td>3240.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>BALDER FM</td>\n",
       "      <td>3302.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>SELE FM</td>\n",
       "      <td>3403.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>LISTA FM</td>\n",
       "      <td>3483.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>HEIMDAL FM</td>\n",
       "      <td>3623.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>EKOFISK FM</td>\n",
       "      <td>3827.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>TOR FM</td>\n",
       "      <td>3850.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>HOD FM</td>\n",
       "      <td>4047.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>TRYGGVASON FM</td>\n",
       "      <td>4110.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>BLODØKS FM</td>\n",
       "      <td>4150.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>SVARTE FM</td>\n",
       "      <td>4168.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>RØDBY FM</td>\n",
       "      <td>4176.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>SOLA FM</td>\n",
       "      <td>4188.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>ÅSGARD FM</td>\n",
       "      <td>4201.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>DRAUPNE FM</td>\n",
       "      <td>4304.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>HEATHER FM</td>\n",
       "      <td>4310.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>HUGIN FM</td>\n",
       "      <td>4317.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "      <td>4340.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Formation    DEPT\n",
       "0          UTSIRA FM   846.0\n",
       "1   UNDIFFERENTIATED  1080.0\n",
       "2           SKADE FM  1313.0\n",
       "3     NO FORMAL NAME  1451.0\n",
       "4            GRID FM  3008.0\n",
       "5     NO FORMAL NAME  3240.0\n",
       "6          BALDER FM  3302.0\n",
       "7            SELE FM  3403.0\n",
       "8           LISTA FM  3483.0\n",
       "9         HEIMDAL FM  3623.0\n",
       "10        EKOFISK FM  3827.0\n",
       "11            TOR FM  3850.0\n",
       "12            HOD FM  4047.0\n",
       "13     TRYGGVASON FM  4110.0\n",
       "14        BLODØKS FM  4150.0\n",
       "15         SVARTE FM  4168.0\n",
       "16          RØDBY FM  4176.0\n",
       "17           SOLA FM  4188.0\n",
       "18         ÅSGARD FM  4201.0\n",
       "19        DRAUPNE FM  4304.0\n",
       "20        HEATHER FM  4310.0\n",
       "21          HUGIN FM  4317.0\n",
       "22      SKAGERRAK FM  4340.0"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_19SR_formations"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "id": "ad4cc83a",
   "metadata": {},
   "source": [
    "## Method 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "2a9a2bd5",
   "metadata": {},
   "outputs": [],
   "source": [
    "combined = pd.merge_asof(df_19SR, df_19SR_formations, on='DEPT', tolerance=0.1, direction='nearest')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "88009ba5",
   "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>DEPT</th>\n",
       "      <th>AC</th>\n",
       "      <th>CALI</th>\n",
       "      <th>DEN</th>\n",
       "      <th>GR</th>\n",
       "      <th>NEU</th>\n",
       "      <th>RDEP</th>\n",
       "      <th>RMED</th>\n",
       "      <th>Formation</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>25879</th>\n",
       "      <td>4046.1164</td>\n",
       "      <td>62.1472</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5367</td>\n",
       "      <td>10.3488</td>\n",
       "      <td>9.2970</td>\n",
       "      <td>3.3317</td>\n",
       "      <td>3.3615</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25880</th>\n",
       "      <td>4046.2688</td>\n",
       "      <td>64.0851</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5344</td>\n",
       "      <td>9.7413</td>\n",
       "      <td>8.7762</td>\n",
       "      <td>3.3608</td>\n",
       "      <td>3.3710</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25881</th>\n",
       "      <td>4046.4212</td>\n",
       "      <td>64.7358</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5416</td>\n",
       "      <td>11.6453</td>\n",
       "      <td>9.9468</td>\n",
       "      <td>3.3665</td>\n",
       "      <td>3.3992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25882</th>\n",
       "      <td>4046.5736</td>\n",
       "      <td>67.9201</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5550</td>\n",
       "      <td>8.3504</td>\n",
       "      <td>11.0645</td>\n",
       "      <td>3.3356</td>\n",
       "      <td>3.3927</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25883</th>\n",
       "      <td>4046.7260</td>\n",
       "      <td>75.5817</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5544</td>\n",
       "      <td>11.2070</td>\n",
       "      <td>10.2557</td>\n",
       "      <td>3.2839</td>\n",
       "      <td>3.3378</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25884</th>\n",
       "      <td>4046.8784</td>\n",
       "      <td>73.2628</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5432</td>\n",
       "      <td>9.9543</td>\n",
       "      <td>10.2169</td>\n",
       "      <td>3.1962</td>\n",
       "      <td>3.2019</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25885</th>\n",
       "      <td>4047.0308</td>\n",
       "      <td>68.6563</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5416</td>\n",
       "      <td>11.1064</td>\n",
       "      <td>10.7107</td>\n",
       "      <td>3.0874</td>\n",
       "      <td>2.9957</td>\n",
       "      <td>HOD FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25886</th>\n",
       "      <td>4047.1832</td>\n",
       "      <td>62.5976</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5477</td>\n",
       "      <td>9.1687</td>\n",
       "      <td>13.0074</td>\n",
       "      <td>2.9623</td>\n",
       "      <td>2.8654</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25887</th>\n",
       "      <td>4047.3356</td>\n",
       "      <td>67.5825</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5427</td>\n",
       "      <td>10.4739</td>\n",
       "      <td>11.6744</td>\n",
       "      <td>2.8714</td>\n",
       "      <td>2.7878</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25888</th>\n",
       "      <td>4047.4880</td>\n",
       "      <td>67.3740</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5300</td>\n",
       "      <td>10.9061</td>\n",
       "      <td>10.6323</td>\n",
       "      <td>2.7959</td>\n",
       "      <td>2.6922</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            DEPT       AC    CALI     DEN       GR      NEU    RDEP    RMED  \\\n",
       "25879  4046.1164  62.1472  9.9048  2.5367  10.3488   9.2970  3.3317  3.3615   \n",
       "25880  4046.2688  64.0851  9.9048  2.5344   9.7413   8.7762  3.3608  3.3710   \n",
       "25881  4046.4212  64.7358  9.9048  2.5416  11.6453   9.9468  3.3665  3.3992   \n",
       "25882  4046.5736  67.9201  9.9048  2.5550   8.3504  11.0645  3.3356  3.3927   \n",
       "25883  4046.7260  75.5817  9.9048  2.5544  11.2070  10.2557  3.2839  3.3378   \n",
       "25884  4046.8784  73.2628  9.9048  2.5432   9.9543  10.2169  3.1962  3.2019   \n",
       "25885  4047.0308  68.6563  9.9048  2.5416  11.1064  10.7107  3.0874  2.9957   \n",
       "25886  4047.1832  62.5976  9.9048  2.5477   9.1687  13.0074  2.9623  2.8654   \n",
       "25887  4047.3356  67.5825  9.9048  2.5427  10.4739  11.6744  2.8714  2.7878   \n",
       "25888  4047.4880  67.3740  9.9048  2.5300  10.9061  10.6323  2.7959  2.6922   \n",
       "\n",
       "      Formation  \n",
       "25879       NaN  \n",
       "25880       NaN  \n",
       "25881       NaN  \n",
       "25882       NaN  \n",
       "25883       NaN  \n",
       "25884       NaN  \n",
       "25885    HOD FM  \n",
       "25886       NaN  \n",
       "25887       NaN  \n",
       "25888       NaN  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined.loc[(combined['DEPT'] >= 4046) & (combined['DEPT'] <= 4047.5)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "5050ed0e",
   "metadata": {},
   "outputs": [],
   "source": [
    "combined['Formation'] = combined['Formation'].fillna(method='ffill')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "a55b47cd",
   "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>DEPT</th>\n",
       "      <th>AC</th>\n",
       "      <th>CALI</th>\n",
       "      <th>DEN</th>\n",
       "      <th>GR</th>\n",
       "      <th>NEU</th>\n",
       "      <th>RDEP</th>\n",
       "      <th>RMED</th>\n",
       "      <th>Formation</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>102.1568</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.3274</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>102.3092</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.8235</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>102.4616</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.5228</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>102.6140</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.2285</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>102.7664</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.5020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29749</th>\n",
       "      <td>4635.9044</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.7729</td>\n",
       "      <td>0.5978</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29750</th>\n",
       "      <td>4636.0568</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.8369</td>\n",
       "      <td>0.6257</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29751</th>\n",
       "      <td>4636.2092</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.8741</td>\n",
       "      <td>0.6888</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29752</th>\n",
       "      <td>4636.3616</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.9002</td>\n",
       "      <td>0.8902</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29753</th>\n",
       "      <td>4636.5140</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.9133</td>\n",
       "      <td>1.0363</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>29754 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            DEPT  AC  CALI  DEN      GR  NEU    RDEP    RMED     Formation\n",
       "0       102.1568 NaN   NaN  NaN  5.3274  NaN     NaN     NaN           NaN\n",
       "1       102.3092 NaN   NaN  NaN  5.8235  NaN     NaN     NaN           NaN\n",
       "2       102.4616 NaN   NaN  NaN  6.5228  NaN     NaN     NaN           NaN\n",
       "3       102.6140 NaN   NaN  NaN  7.2285  NaN     NaN     NaN           NaN\n",
       "4       102.7664 NaN   NaN  NaN  9.5020  NaN     NaN     NaN           NaN\n",
       "...          ...  ..   ...  ...     ...  ...     ...     ...           ...\n",
       "29749  4635.9044 NaN   NaN  NaN     NaN  NaN  0.7729  0.5978  SKAGERRAK FM\n",
       "29750  4636.0568 NaN   NaN  NaN     NaN  NaN  0.8369  0.6257  SKAGERRAK FM\n",
       "29751  4636.2092 NaN   NaN  NaN     NaN  NaN  0.8741  0.6888  SKAGERRAK FM\n",
       "29752  4636.3616 NaN   NaN  NaN     NaN  NaN  0.9002  0.8902  SKAGERRAK FM\n",
       "29753  4636.5140 NaN   NaN  NaN     NaN  NaN  0.9133  1.0363  SKAGERRAK FM\n",
       "\n",
       "[29754 rows x 9 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "0eeaf4ff",
   "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>DEPT</th>\n",
       "      <th>AC</th>\n",
       "      <th>CALI</th>\n",
       "      <th>DEN</th>\n",
       "      <th>GR</th>\n",
       "      <th>NEU</th>\n",
       "      <th>RDEP</th>\n",
       "      <th>RMED</th>\n",
       "      <th>Formation</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>25879</th>\n",
       "      <td>4046.1164</td>\n",
       "      <td>62.1472</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5367</td>\n",
       "      <td>10.3488</td>\n",
       "      <td>9.2970</td>\n",
       "      <td>3.3317</td>\n",
       "      <td>3.3615</td>\n",
       "      <td>TOR FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25880</th>\n",
       "      <td>4046.2688</td>\n",
       "      <td>64.0851</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5344</td>\n",
       "      <td>9.7413</td>\n",
       "      <td>8.7762</td>\n",
       "      <td>3.3608</td>\n",
       "      <td>3.3710</td>\n",
       "      <td>TOR FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25881</th>\n",
       "      <td>4046.4212</td>\n",
       "      <td>64.7358</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5416</td>\n",
       "      <td>11.6453</td>\n",
       "      <td>9.9468</td>\n",
       "      <td>3.3665</td>\n",
       "      <td>3.3992</td>\n",
       "      <td>TOR FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25882</th>\n",
       "      <td>4046.5736</td>\n",
       "      <td>67.9201</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5550</td>\n",
       "      <td>8.3504</td>\n",
       "      <td>11.0645</td>\n",
       "      <td>3.3356</td>\n",
       "      <td>3.3927</td>\n",
       "      <td>TOR FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25883</th>\n",
       "      <td>4046.7260</td>\n",
       "      <td>75.5817</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5544</td>\n",
       "      <td>11.2070</td>\n",
       "      <td>10.2557</td>\n",
       "      <td>3.2839</td>\n",
       "      <td>3.3378</td>\n",
       "      <td>TOR FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25884</th>\n",
       "      <td>4046.8784</td>\n",
       "      <td>73.2628</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5432</td>\n",
       "      <td>9.9543</td>\n",
       "      <td>10.2169</td>\n",
       "      <td>3.1962</td>\n",
       "      <td>3.2019</td>\n",
       "      <td>TOR FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25885</th>\n",
       "      <td>4047.0308</td>\n",
       "      <td>68.6563</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5416</td>\n",
       "      <td>11.1064</td>\n",
       "      <td>10.7107</td>\n",
       "      <td>3.0874</td>\n",
       "      <td>2.9957</td>\n",
       "      <td>HOD FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25886</th>\n",
       "      <td>4047.1832</td>\n",
       "      <td>62.5976</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5477</td>\n",
       "      <td>9.1687</td>\n",
       "      <td>13.0074</td>\n",
       "      <td>2.9623</td>\n",
       "      <td>2.8654</td>\n",
       "      <td>HOD FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25887</th>\n",
       "      <td>4047.3356</td>\n",
       "      <td>67.5825</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5427</td>\n",
       "      <td>10.4739</td>\n",
       "      <td>11.6744</td>\n",
       "      <td>2.8714</td>\n",
       "      <td>2.7878</td>\n",
       "      <td>HOD FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25888</th>\n",
       "      <td>4047.4880</td>\n",
       "      <td>67.3740</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5300</td>\n",
       "      <td>10.9061</td>\n",
       "      <td>10.6323</td>\n",
       "      <td>2.7959</td>\n",
       "      <td>2.6922</td>\n",
       "      <td>HOD FM</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            DEPT       AC    CALI     DEN       GR      NEU    RDEP    RMED  \\\n",
       "25879  4046.1164  62.1472  9.9048  2.5367  10.3488   9.2970  3.3317  3.3615   \n",
       "25880  4046.2688  64.0851  9.9048  2.5344   9.7413   8.7762  3.3608  3.3710   \n",
       "25881  4046.4212  64.7358  9.9048  2.5416  11.6453   9.9468  3.3665  3.3992   \n",
       "25882  4046.5736  67.9201  9.9048  2.5550   8.3504  11.0645  3.3356  3.3927   \n",
       "25883  4046.7260  75.5817  9.9048  2.5544  11.2070  10.2557  3.2839  3.3378   \n",
       "25884  4046.8784  73.2628  9.9048  2.5432   9.9543  10.2169  3.1962  3.2019   \n",
       "25885  4047.0308  68.6563  9.9048  2.5416  11.1064  10.7107  3.0874  2.9957   \n",
       "25886  4047.1832  62.5976  9.9048  2.5477   9.1687  13.0074  2.9623  2.8654   \n",
       "25887  4047.3356  67.5825  9.9048  2.5427  10.4739  11.6744  2.8714  2.7878   \n",
       "25888  4047.4880  67.3740  9.9048  2.5300  10.9061  10.6323  2.7959  2.6922   \n",
       "\n",
       "      Formation  \n",
       "25879    TOR FM  \n",
       "25880    TOR FM  \n",
       "25881    TOR FM  \n",
       "25882    TOR FM  \n",
       "25883    TOR FM  \n",
       "25884    TOR FM  \n",
       "25885    HOD FM  \n",
       "25886    HOD FM  \n",
       "25887    HOD FM  \n",
       "25888    HOD FM  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined.loc[(combined['DEPT'] >= 4046) & (combined['DEPT'] <= 4047.5)] "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "80cf70f1",
   "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>DEPT</th>\n",
       "      <th>AC</th>\n",
       "      <th>CALI</th>\n",
       "      <th>DEN</th>\n",
       "      <th>GR</th>\n",
       "      <th>NEU</th>\n",
       "      <th>RDEP</th>\n",
       "      <th>RMED</th>\n",
       "      <th>Formation</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>27801</th>\n",
       "      <td>4339.0292</td>\n",
       "      <td>51.8796</td>\n",
       "      <td>9.1429</td>\n",
       "      <td>2.5323</td>\n",
       "      <td>31.7830</td>\n",
       "      <td>11.2418</td>\n",
       "      <td>17.3844</td>\n",
       "      <td>18.4879</td>\n",
       "      <td>HUGIN FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27802</th>\n",
       "      <td>4339.1816</td>\n",
       "      <td>53.1605</td>\n",
       "      <td>9.2381</td>\n",
       "      <td>2.5368</td>\n",
       "      <td>37.9993</td>\n",
       "      <td>14.7903</td>\n",
       "      <td>16.7278</td>\n",
       "      <td>17.8524</td>\n",
       "      <td>HUGIN FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27803</th>\n",
       "      <td>4339.3340</td>\n",
       "      <td>55.8638</td>\n",
       "      <td>9.2381</td>\n",
       "      <td>2.5353</td>\n",
       "      <td>43.4283</td>\n",
       "      <td>11.1817</td>\n",
       "      <td>16.4371</td>\n",
       "      <td>17.0776</td>\n",
       "      <td>HUGIN FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27804</th>\n",
       "      <td>4339.4864</td>\n",
       "      <td>60.1538</td>\n",
       "      <td>9.3333</td>\n",
       "      <td>2.5376</td>\n",
       "      <td>52.2349</td>\n",
       "      <td>14.0164</td>\n",
       "      <td>16.4886</td>\n",
       "      <td>16.4046</td>\n",
       "      <td>HUGIN FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27805</th>\n",
       "      <td>4339.6388</td>\n",
       "      <td>61.8456</td>\n",
       "      <td>9.3333</td>\n",
       "      <td>2.5515</td>\n",
       "      <td>65.2177</td>\n",
       "      <td>18.8162</td>\n",
       "      <td>17.1632</td>\n",
       "      <td>15.4532</td>\n",
       "      <td>HUGIN FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27806</th>\n",
       "      <td>4339.7912</td>\n",
       "      <td>63.3143</td>\n",
       "      <td>9.4286</td>\n",
       "      <td>2.5681</td>\n",
       "      <td>62.0304</td>\n",
       "      <td>24.5360</td>\n",
       "      <td>17.8220</td>\n",
       "      <td>14.8880</td>\n",
       "      <td>HUGIN FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27807</th>\n",
       "      <td>4339.9436</td>\n",
       "      <td>64.0107</td>\n",
       "      <td>9.4286</td>\n",
       "      <td>2.5651</td>\n",
       "      <td>67.7695</td>\n",
       "      <td>23.4092</td>\n",
       "      <td>17.6928</td>\n",
       "      <td>14.5194</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27808</th>\n",
       "      <td>4340.0960</td>\n",
       "      <td>62.9094</td>\n",
       "      <td>9.5663</td>\n",
       "      <td>2.5116</td>\n",
       "      <td>78.0308</td>\n",
       "      <td>24.8303</td>\n",
       "      <td>16.0257</td>\n",
       "      <td>13.0239</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27809</th>\n",
       "      <td>4340.2484</td>\n",
       "      <td>62.9921</td>\n",
       "      <td>9.7106</td>\n",
       "      <td>2.4601</td>\n",
       "      <td>79.6203</td>\n",
       "      <td>29.2376</td>\n",
       "      <td>13.4151</td>\n",
       "      <td>10.0252</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27810</th>\n",
       "      <td>4340.4008</td>\n",
       "      <td>61.4105</td>\n",
       "      <td>9.7596</td>\n",
       "      <td>2.4523</td>\n",
       "      <td>80.6640</td>\n",
       "      <td>26.4657</td>\n",
       "      <td>9.3640</td>\n",
       "      <td>7.0422</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27811</th>\n",
       "      <td>4340.5532</td>\n",
       "      <td>61.7707</td>\n",
       "      <td>9.8095</td>\n",
       "      <td>2.4675</td>\n",
       "      <td>80.6132</td>\n",
       "      <td>29.2239</td>\n",
       "      <td>5.7445</td>\n",
       "      <td>4.1357</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27812</th>\n",
       "      <td>4340.7056</td>\n",
       "      <td>68.5278</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5003</td>\n",
       "      <td>87.8102</td>\n",
       "      <td>22.5944</td>\n",
       "      <td>4.3082</td>\n",
       "      <td>3.0821</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27813</th>\n",
       "      <td>4340.8580</td>\n",
       "      <td>76.4663</td>\n",
       "      <td>10.0020</td>\n",
       "      <td>2.5241</td>\n",
       "      <td>86.8339</td>\n",
       "      <td>32.8458</td>\n",
       "      <td>3.5145</td>\n",
       "      <td>2.5156</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            DEPT       AC     CALI     DEN       GR      NEU     RDEP  \\\n",
       "27801  4339.0292  51.8796   9.1429  2.5323  31.7830  11.2418  17.3844   \n",
       "27802  4339.1816  53.1605   9.2381  2.5368  37.9993  14.7903  16.7278   \n",
       "27803  4339.3340  55.8638   9.2381  2.5353  43.4283  11.1817  16.4371   \n",
       "27804  4339.4864  60.1538   9.3333  2.5376  52.2349  14.0164  16.4886   \n",
       "27805  4339.6388  61.8456   9.3333  2.5515  65.2177  18.8162  17.1632   \n",
       "27806  4339.7912  63.3143   9.4286  2.5681  62.0304  24.5360  17.8220   \n",
       "27807  4339.9436  64.0107   9.4286  2.5651  67.7695  23.4092  17.6928   \n",
       "27808  4340.0960  62.9094   9.5663  2.5116  78.0308  24.8303  16.0257   \n",
       "27809  4340.2484  62.9921   9.7106  2.4601  79.6203  29.2376  13.4151   \n",
       "27810  4340.4008  61.4105   9.7596  2.4523  80.6640  26.4657   9.3640   \n",
       "27811  4340.5532  61.7707   9.8095  2.4675  80.6132  29.2239   5.7445   \n",
       "27812  4340.7056  68.5278   9.9048  2.5003  87.8102  22.5944   4.3082   \n",
       "27813  4340.8580  76.4663  10.0020  2.5241  86.8339  32.8458   3.5145   \n",
       "\n",
       "          RMED     Formation  \n",
       "27801  18.4879      HUGIN FM  \n",
       "27802  17.8524      HUGIN FM  \n",
       "27803  17.0776      HUGIN FM  \n",
       "27804  16.4046      HUGIN FM  \n",
       "27805  15.4532      HUGIN FM  \n",
       "27806  14.8880      HUGIN FM  \n",
       "27807  14.5194  SKAGERRAK FM  \n",
       "27808  13.0239  SKAGERRAK FM  \n",
       "27809  10.0252  SKAGERRAK FM  \n",
       "27810   7.0422  SKAGERRAK FM  \n",
       "27811   4.1357  SKAGERRAK FM  \n",
       "27812   3.0821  SKAGERRAK FM  \n",
       "27813   2.5156  SKAGERRAK FM  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined.loc[(combined['DEPT'] >= 4339) & (combined['DEPT'] <= 4341)]"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "id": "a8212b4b",
   "metadata": {},
   "source": [
    "## Method 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "eba56889",
   "metadata": {},
   "outputs": [],
   "source": [
    "def add_formations_to_df(depth_value:float) -> str:\n",
    "    formation_depths = df_19SR_formations['DEPT'].to_list()\n",
    "    formation_names = df_19SR_formations['Formation'].to_list()\n",
    "    \n",
    "    for i, depth in enumerate(formation_depths):\n",
    "        # Check if we are at last formation\n",
    "        if i == len(formation_depths)-1:\n",
    "            return formation_names[i]\n",
    "        \n",
    "        # Check if we are before first formation\n",
    "        elif depth_value <= formation_depths[i]:\n",
    "            return ''\n",
    "        \n",
    "        # Check if current depth between current and next formation\n",
    "        elif depth_value >= formation_depths[i] and depth_value <= formation_depths[i+1]:\n",
    "            return formation_names[i]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "41002522",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_19SR['FORMATION'] = df_19SR['DEPT'].apply(add_formations_to_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "cfed96ed",
   "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>DEPT</th>\n",
       "      <th>AC</th>\n",
       "      <th>CALI</th>\n",
       "      <th>DEN</th>\n",
       "      <th>GR</th>\n",
       "      <th>NEU</th>\n",
       "      <th>RDEP</th>\n",
       "      <th>RMED</th>\n",
       "      <th>FORMATION</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>102.1568</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.3274</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>102.3092</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.8235</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>102.4616</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.5228</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>102.6140</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.2285</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>102.7664</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.5020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29749</th>\n",
       "      <td>4635.9044</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.7729</td>\n",
       "      <td>0.5978</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29750</th>\n",
       "      <td>4636.0568</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.8369</td>\n",
       "      <td>0.6257</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29751</th>\n",
       "      <td>4636.2092</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.8741</td>\n",
       "      <td>0.6888</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29752</th>\n",
       "      <td>4636.3616</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.9002</td>\n",
       "      <td>0.8902</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29753</th>\n",
       "      <td>4636.5140</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.9133</td>\n",
       "      <td>1.0363</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>29754 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            DEPT  AC  CALI  DEN      GR  NEU    RDEP    RMED     FORMATION\n",
       "0       102.1568 NaN   NaN  NaN  5.3274  NaN     NaN     NaN              \n",
       "1       102.3092 NaN   NaN  NaN  5.8235  NaN     NaN     NaN              \n",
       "2       102.4616 NaN   NaN  NaN  6.5228  NaN     NaN     NaN              \n",
       "3       102.6140 NaN   NaN  NaN  7.2285  NaN     NaN     NaN              \n",
       "4       102.7664 NaN   NaN  NaN  9.5020  NaN     NaN     NaN              \n",
       "...          ...  ..   ...  ...     ...  ...     ...     ...           ...\n",
       "29749  4635.9044 NaN   NaN  NaN     NaN  NaN  0.7729  0.5978  SKAGERRAK FM\n",
       "29750  4636.0568 NaN   NaN  NaN     NaN  NaN  0.8369  0.6257  SKAGERRAK FM\n",
       "29751  4636.2092 NaN   NaN  NaN     NaN  NaN  0.8741  0.6888  SKAGERRAK FM\n",
       "29752  4636.3616 NaN   NaN  NaN     NaN  NaN  0.9002  0.8902  SKAGERRAK FM\n",
       "29753  4636.5140 NaN   NaN  NaN     NaN  NaN  0.9133  1.0363  SKAGERRAK FM\n",
       "\n",
       "[29754 rows x 9 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_19SR"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "d3136fa6",
   "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>DEPT</th>\n",
       "      <th>AC</th>\n",
       "      <th>CALI</th>\n",
       "      <th>DEN</th>\n",
       "      <th>GR</th>\n",
       "      <th>NEU</th>\n",
       "      <th>RDEP</th>\n",
       "      <th>RMED</th>\n",
       "      <th>FORMATION</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>27801</th>\n",
       "      <td>4339.0292</td>\n",
       "      <td>51.8796</td>\n",
       "      <td>9.1429</td>\n",
       "      <td>2.5323</td>\n",
       "      <td>31.7830</td>\n",
       "      <td>11.2418</td>\n",
       "      <td>17.3844</td>\n",
       "      <td>18.4879</td>\n",
       "      <td>HUGIN FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27802</th>\n",
       "      <td>4339.1816</td>\n",
       "      <td>53.1605</td>\n",
       "      <td>9.2381</td>\n",
       "      <td>2.5368</td>\n",
       "      <td>37.9993</td>\n",
       "      <td>14.7903</td>\n",
       "      <td>16.7278</td>\n",
       "      <td>17.8524</td>\n",
       "      <td>HUGIN FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27803</th>\n",
       "      <td>4339.3340</td>\n",
       "      <td>55.8638</td>\n",
       "      <td>9.2381</td>\n",
       "      <td>2.5353</td>\n",
       "      <td>43.4283</td>\n",
       "      <td>11.1817</td>\n",
       "      <td>16.4371</td>\n",
       "      <td>17.0776</td>\n",
       "      <td>HUGIN FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27804</th>\n",
       "      <td>4339.4864</td>\n",
       "      <td>60.1538</td>\n",
       "      <td>9.3333</td>\n",
       "      <td>2.5376</td>\n",
       "      <td>52.2349</td>\n",
       "      <td>14.0164</td>\n",
       "      <td>16.4886</td>\n",
       "      <td>16.4046</td>\n",
       "      <td>HUGIN FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27805</th>\n",
       "      <td>4339.6388</td>\n",
       "      <td>61.8456</td>\n",
       "      <td>9.3333</td>\n",
       "      <td>2.5515</td>\n",
       "      <td>65.2177</td>\n",
       "      <td>18.8162</td>\n",
       "      <td>17.1632</td>\n",
       "      <td>15.4532</td>\n",
       "      <td>HUGIN FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27806</th>\n",
       "      <td>4339.7912</td>\n",
       "      <td>63.3143</td>\n",
       "      <td>9.4286</td>\n",
       "      <td>2.5681</td>\n",
       "      <td>62.0304</td>\n",
       "      <td>24.5360</td>\n",
       "      <td>17.8220</td>\n",
       "      <td>14.8880</td>\n",
       "      <td>HUGIN FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27807</th>\n",
       "      <td>4339.9436</td>\n",
       "      <td>64.0107</td>\n",
       "      <td>9.4286</td>\n",
       "      <td>2.5651</td>\n",
       "      <td>67.7695</td>\n",
       "      <td>23.4092</td>\n",
       "      <td>17.6928</td>\n",
       "      <td>14.5194</td>\n",
       "      <td>HUGIN FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27808</th>\n",
       "      <td>4340.0960</td>\n",
       "      <td>62.9094</td>\n",
       "      <td>9.5663</td>\n",
       "      <td>2.5116</td>\n",
       "      <td>78.0308</td>\n",
       "      <td>24.8303</td>\n",
       "      <td>16.0257</td>\n",
       "      <td>13.0239</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27809</th>\n",
       "      <td>4340.2484</td>\n",
       "      <td>62.9921</td>\n",
       "      <td>9.7106</td>\n",
       "      <td>2.4601</td>\n",
       "      <td>79.6203</td>\n",
       "      <td>29.2376</td>\n",
       "      <td>13.4151</td>\n",
       "      <td>10.0252</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27810</th>\n",
       "      <td>4340.4008</td>\n",
       "      <td>61.4105</td>\n",
       "      <td>9.7596</td>\n",
       "      <td>2.4523</td>\n",
       "      <td>80.6640</td>\n",
       "      <td>26.4657</td>\n",
       "      <td>9.3640</td>\n",
       "      <td>7.0422</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27811</th>\n",
       "      <td>4340.5532</td>\n",
       "      <td>61.7707</td>\n",
       "      <td>9.8095</td>\n",
       "      <td>2.4675</td>\n",
       "      <td>80.6132</td>\n",
       "      <td>29.2239</td>\n",
       "      <td>5.7445</td>\n",
       "      <td>4.1357</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27812</th>\n",
       "      <td>4340.7056</td>\n",
       "      <td>68.5278</td>\n",
       "      <td>9.9048</td>\n",
       "      <td>2.5003</td>\n",
       "      <td>87.8102</td>\n",
       "      <td>22.5944</td>\n",
       "      <td>4.3082</td>\n",
       "      <td>3.0821</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27813</th>\n",
       "      <td>4340.8580</td>\n",
       "      <td>76.4663</td>\n",
       "      <td>10.0020</td>\n",
       "      <td>2.5241</td>\n",
       "      <td>86.8339</td>\n",
       "      <td>32.8458</td>\n",
       "      <td>3.5145</td>\n",
       "      <td>2.5156</td>\n",
       "      <td>SKAGERRAK FM</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            DEPT       AC     CALI     DEN       GR      NEU     RDEP  \\\n",
       "27801  4339.0292  51.8796   9.1429  2.5323  31.7830  11.2418  17.3844   \n",
       "27802  4339.1816  53.1605   9.2381  2.5368  37.9993  14.7903  16.7278   \n",
       "27803  4339.3340  55.8638   9.2381  2.5353  43.4283  11.1817  16.4371   \n",
       "27804  4339.4864  60.1538   9.3333  2.5376  52.2349  14.0164  16.4886   \n",
       "27805  4339.6388  61.8456   9.3333  2.5515  65.2177  18.8162  17.1632   \n",
       "27806  4339.7912  63.3143   9.4286  2.5681  62.0304  24.5360  17.8220   \n",
       "27807  4339.9436  64.0107   9.4286  2.5651  67.7695  23.4092  17.6928   \n",
       "27808  4340.0960  62.9094   9.5663  2.5116  78.0308  24.8303  16.0257   \n",
       "27809  4340.2484  62.9921   9.7106  2.4601  79.6203  29.2376  13.4151   \n",
       "27810  4340.4008  61.4105   9.7596  2.4523  80.6640  26.4657   9.3640   \n",
       "27811  4340.5532  61.7707   9.8095  2.4675  80.6132  29.2239   5.7445   \n",
       "27812  4340.7056  68.5278   9.9048  2.5003  87.8102  22.5944   4.3082   \n",
       "27813  4340.8580  76.4663  10.0020  2.5241  86.8339  32.8458   3.5145   \n",
       "\n",
       "          RMED     FORMATION  \n",
       "27801  18.4879      HUGIN FM  \n",
       "27802  17.8524      HUGIN FM  \n",
       "27803  17.0776      HUGIN FM  \n",
       "27804  16.4046      HUGIN FM  \n",
       "27805  15.4532      HUGIN FM  \n",
       "27806  14.8880      HUGIN FM  \n",
       "27807  14.5194      HUGIN FM  \n",
       "27808  13.0239  SKAGERRAK FM  \n",
       "27809  10.0252  SKAGERRAK FM  \n",
       "27810   7.0422  SKAGERRAK FM  \n",
       "27811   4.1357  SKAGERRAK FM  \n",
       "27812   3.0821  SKAGERRAK FM  \n",
       "27813   2.5156  SKAGERRAK FM  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_19SR.loc[(df_19SR['DEPT'] >= 4339) & (df_19SR['DEPT'] <= 4341)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "43f0f76b",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}