Data_cleaning.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "e4eda7f4",
   "metadata": {},
   "source": [
    "# Data Cleaning\n",
    "\n",
    "Data files:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "abdf6728",
   "metadata": {},
   "outputs": [],
   "source": [
    "raw = './data/raw_collated.csv'"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "93120dc2",
   "metadata": {},
   "source": [
    "Imports:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "85c0765b",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "88728feb",
   "metadata": {},
   "source": [
    "## Cleaning data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "69501c8f",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/geodev/anaconda3/envs/geothack/lib/python3.8/site-packages/IPython/core/interactiveshell.py:3165: DtypeWarning: Columns (6,8) have mixed types.Specify dtype option on import or set low_memory=False.\n",
      "  has_raised = await self.run_ast_nodes(code_ast.body, cell_name,\n"
     ]
    }
   ],
   "source": [
    "df = pd.read_csv(raw, index_col=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "769b8932",
   "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>Type</th>\n",
       "      <th>Geothermal Province</th>\n",
       "      <th>State</th>\n",
       "      <th>Field</th>\n",
       "      <th>Well ID</th>\n",
       "      <th>Sample ID</th>\n",
       "      <th>Depth (ft)</th>\n",
       "      <th>AMU1</th>\n",
       "      <th>AMU2</th>\n",
       "      <th>AMU3</th>\n",
       "      <th>...</th>\n",
       "      <th>AMU176.UNKN</th>\n",
       "      <th>AMU177.UNKN</th>\n",
       "      <th>AMU178.UNKN</th>\n",
       "      <th>AMU179.UNKN</th>\n",
       "      <th>AMU180.UNKN</th>\n",
       "      <th>FIT Well</th>\n",
       "      <th>Unnamed: 188</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>Unnamed: 187</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>15A-17</td>\n",
       "      <td>2202</td>\n",
       "      <td>510</td>\n",
       "      <td>0</td>\n",
       "      <td>294200.0</td>\n",
       "      <td>53.30</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2434.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</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>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>15A-17</td>\n",
       "      <td>2203</td>\n",
       "      <td>530</td>\n",
       "      <td>0</td>\n",
       "      <td>320600.0</td>\n",
       "      <td>48.95</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>80.84</td>\n",
       "      <td>59.98</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.450</td>\n",
       "      <td>NaN</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>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>15A-17</td>\n",
       "      <td>2204</td>\n",
       "      <td>550</td>\n",
       "      <td>0</td>\n",
       "      <td>385400.0</td>\n",
       "      <td>159.40</td>\n",
       "      <td>...</td>\n",
       "      <td>592.6</td>\n",
       "      <td>0.00</td>\n",
       "      <td>580.30</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27.630</td>\n",
       "      <td>NaN</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>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>15A-17</td>\n",
       "      <td>2205</td>\n",
       "      <td>570</td>\n",
       "      <td>0</td>\n",
       "      <td>448600.0</td>\n",
       "      <td>122.90</td>\n",
       "      <td>...</td>\n",
       "      <td>376.7</td>\n",
       "      <td>0.00</td>\n",
       "      <td>577.80</td>\n",
       "      <td>6065.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</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>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>15A-17</td>\n",
       "      <td>2206</td>\n",
       "      <td>590</td>\n",
       "      <td>0</td>\n",
       "      <td>293800.0</td>\n",
       "      <td>47.05</td>\n",
       "      <td>...</td>\n",
       "      <td>241.1</td>\n",
       "      <td>33.28</td>\n",
       "      <td>378.30</td>\n",
       "      <td>5696.0</td>\n",
       "      <td>1.211</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 192 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Type Geothermal Province       State Field Well ID  \\\n",
       "0  Transform Extension       Sierra Nevada  California  COSO  15A-17   \n",
       "1  Transform Extension       Sierra Nevada  California  COSO  15A-17   \n",
       "2  Transform Extension       Sierra Nevada  California  COSO  15A-17   \n",
       "3  Transform Extension       Sierra Nevada  California  COSO  15A-17   \n",
       "4  Transform Extension       Sierra Nevada  California  COSO  15A-17   \n",
       "\n",
       "  Sample ID Depth (ft) AMU1      AMU2    AMU3  ...  AMU176.UNKN  AMU177.UNKN  \\\n",
       "0      2202        510    0  294200.0   53.30  ...          0.0         0.00   \n",
       "1      2203        530    0  320600.0   48.95  ...          0.0        80.84   \n",
       "2      2204        550    0  385400.0  159.40  ...        592.6         0.00   \n",
       "3      2205        570    0  448600.0  122.90  ...        376.7         0.00   \n",
       "4      2206        590    0  293800.0   47.05  ...        241.1        33.28   \n",
       "\n",
       "   AMU178.UNKN  AMU179.UNKN  AMU180.UNKN  FIT Well  Unnamed: 188  Unnamed: 8  \\\n",
       "0      2434.00          0.0        0.000       NaN           NaN         NaN   \n",
       "1        59.98          0.0       11.450       NaN           NaN         NaN   \n",
       "2       580.30          0.0       27.630       NaN           NaN         NaN   \n",
       "3       577.80       6065.0        0.000       NaN           NaN         NaN   \n",
       "4       378.30       5696.0        1.211       NaN           NaN         NaN   \n",
       "\n",
       "   Unnamed: 9  Unnamed: 187  \n",
       "0         NaN           NaN  \n",
       "1         NaN           NaN  \n",
       "2         NaN           NaN  \n",
       "3         NaN           NaN  \n",
       "4         NaN           NaN  \n",
       "\n",
       "[5 rows x 192 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "cd133ed2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(9712, 192)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "aac7ef16",
   "metadata": {},
   "outputs": [],
   "source": [
    "# yields ValueError: ValueError: could not convert string to float: 'STD'\n",
    "#df['Depth (ft)'].astype('float64')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "dc5a2688",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0      False\n",
       "1      False\n",
       "2      False\n",
       "3      False\n",
       "4      False\n",
       "       ...  \n",
       "391    False\n",
       "392    False\n",
       "393    False\n",
       "394    False\n",
       "395    False\n",
       "Name: Depth (ft), Length: 9712, dtype: bool"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Depth (ft)'].str.contains('STD', na=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "e3554fc9",
   "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>Type</th>\n",
       "      <th>Geothermal Province</th>\n",
       "      <th>State</th>\n",
       "      <th>Field</th>\n",
       "      <th>Well ID</th>\n",
       "      <th>Sample ID</th>\n",
       "      <th>Depth (ft)</th>\n",
       "      <th>AMU1</th>\n",
       "      <th>AMU2</th>\n",
       "      <th>AMU3</th>\n",
       "      <th>...</th>\n",
       "      <th>AMU176.UNKN</th>\n",
       "      <th>AMU177.UNKN</th>\n",
       "      <th>AMU178.UNKN</th>\n",
       "      <th>AMU179.UNKN</th>\n",
       "      <th>AMU180.UNKN</th>\n",
       "      <th>FIT Well</th>\n",
       "      <th>Unnamed: 188</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>Unnamed: 187</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>15A-17</td>\n",
       "      <td>2420</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>652700.0</td>\n",
       "      <td>73.74</td>\n",
       "      <td>...</td>\n",
       "      <td>0.088880</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3.666000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>23A-17</td>\n",
       "      <td>2640</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>1328000.0</td>\n",
       "      <td>240.00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>9.944000e-01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.098000e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>23A-17</td>\n",
       "      <td>2860</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>512300.0</td>\n",
       "      <td>41.40</td>\n",
       "      <td>...</td>\n",
       "      <td>4.100000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3.756000e+01</td>\n",
       "      <td>2.360000e+01</td>\n",
       "      <td>6.079000e+02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>354</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>23A-17</td>\n",
       "      <td>2895</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>424500.0</td>\n",
       "      <td>190.40</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.535000e-15</td>\n",
       "      <td>3.266000e-15</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>23A-17</td>\n",
       "      <td>2896</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>414300.0</td>\n",
       "      <td>192.80</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.085000e-02</td>\n",
       "      <td>1.861000e-01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>356</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>23A-17</td>\n",
       "      <td>2897</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>352700.0</td>\n",
       "      <td>190.40</td>\n",
       "      <td>...</td>\n",
       "      <td>0.008075</td>\n",
       "      <td>1.963000e-01</td>\n",
       "      <td>3.365000e-15</td>\n",
       "      <td>4.339000e-15</td>\n",
       "      <td>3.406000e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>23A-17</td>\n",
       "      <td>2898</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>533800.0</td>\n",
       "      <td>45.89</td>\n",
       "      <td>...</td>\n",
       "      <td>0.027780</td>\n",
       "      <td>8.909000e-02</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.932000e-01</td>\n",
       "      <td>3.758000e-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>23A-17</td>\n",
       "      <td>2899</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>1116000.0</td>\n",
       "      <td>287.00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.927000e-15</td>\n",
       "      <td>2.531000e-15</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>359</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>23A-17</td>\n",
       "      <td>2900</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>854200.0</td>\n",
       "      <td>121.70</td>\n",
       "      <td>...</td>\n",
       "      <td>0.090050</td>\n",
       "      <td>1.770000e-02</td>\n",
       "      <td>1.372000e-01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>5.942000e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>360</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>23A-17</td>\n",
       "      <td>2901</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>693300.0</td>\n",
       "      <td>126.40</td>\n",
       "      <td>...</td>\n",
       "      <td>0.077140</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3.634000e-01</td>\n",
       "      <td>6.932000e-01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>361</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>23A-17</td>\n",
       "      <td>2902</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>1163000.0</td>\n",
       "      <td>329.80</td>\n",
       "      <td>...</td>\n",
       "      <td>0.228600</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.585000e-01</td>\n",
       "      <td>7.869000e-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>23A-17</td>\n",
       "      <td>2903</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>467200.0</td>\n",
       "      <td>165.00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.281200</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3.071000e-02</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>363</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>23A-17</td>\n",
       "      <td>2904</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>1058000.0</td>\n",
       "      <td>252.60</td>\n",
       "      <td>...</td>\n",
       "      <td>0.020610</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.585000e-15</td>\n",
       "      <td>2.170000e-02</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>365</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>23A-17</td>\n",
       "      <td>2906</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>664800.0</td>\n",
       "      <td>107.90</td>\n",
       "      <td>...</td>\n",
       "      <td>0.111600</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>23A-19</td>\n",
       "      <td>3520</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>715100.0</td>\n",
       "      <td>156.40</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.637000e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>23A-19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>23A-19</td>\n",
       "      <td>3740</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>1531000.0</td>\n",
       "      <td>406.20</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>23A-19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>24A-8</td>\n",
       "      <td>880</td>\n",
       "      <td>STD</td>\n",
       "      <td>880.0 0.0000E+00</td>\n",
       "      <td>543500.0</td>\n",
       "      <td>190.30</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>24A-8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>264</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>24A-8</td>\n",
       "      <td>1100</td>\n",
       "      <td>STD</td>\n",
       "      <td>1102.0 0.0000E+00</td>\n",
       "      <td>619500.0</td>\n",
       "      <td>160.60</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.769000e+02</td>\n",
       "      <td>9.495000e+02</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>24A-8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>41B-8</td>\n",
       "      <td>1320</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>487500.0</td>\n",
       "      <td>119.30</td>\n",
       "      <td>...</td>\n",
       "      <td>8.057000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.877000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>54-7RD</td>\n",
       "      <td>-</td>\n",
       "      <td>STD</td>\n",
       "      <td>0.0</td>\n",
       "      <td>894600.0</td>\n",
       "      <td>262.70</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.504000e+01</td>\n",
       "      <td>54-7RD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>54-7RD</td>\n",
       "      <td>-</td>\n",
       "      <td>STD</td>\n",
       "      <td>0.0</td>\n",
       "      <td>752200.0</td>\n",
       "      <td>226.70</td>\n",
       "      <td>...</td>\n",
       "      <td>9.132000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>54-7RD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-</td>\n",
       "      <td>STD</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1557000.0</td>\n",
       "      <td>387.40</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>68-6</td>\n",
       "      <td>1</td>\n",
       "      <td>STD</td>\n",
       "      <td>0.0</td>\n",
       "      <td>762200.0</td>\n",
       "      <td>247.10</td>\n",
       "      <td>...</td>\n",
       "      <td>14.920000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>68-6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>68-6</td>\n",
       "      <td>220</td>\n",
       "      <td>STD</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1036000.0</td>\n",
       "      <td>419.40</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>68-6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>439</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>68-6</td>\n",
       "      <td>440</td>\n",
       "      <td>STD</td>\n",
       "      <td>0.0</td>\n",
       "      <td>480100.0</td>\n",
       "      <td>134.30</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>68-6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1760</td>\n",
       "      <td>STD</td>\n",
       "      <td>0.0</td>\n",
       "      <td>374300.0</td>\n",
       "      <td>126.70</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>9.786000e+00</td>\n",
       "      <td>5.588000e+00</td>\n",
       "      <td>2.104000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>515</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>83B-16</td>\n",
       "      <td>2200</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>513300.0</td>\n",
       "      <td>187.70</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>83B-16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>83B-16</td>\n",
       "      <td>2201</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>679700.0</td>\n",
       "      <td>158.60</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6.403000e-01</td>\n",
       "      <td>83B-16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3080</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>359700.0</td>\n",
       "      <td>29.91</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>9.928000e-02</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>7.834000e-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3300</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>799300.0</td>\n",
       "      <td>88.70</td>\n",
       "      <td>...</td>\n",
       "      <td>0.659400</td>\n",
       "      <td>9.011000e-14</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3960</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>791200.0</td>\n",
       "      <td>130.10</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.237000e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>317</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4180</td>\n",
       "      <td>STD</td>\n",
       "      <td>0</td>\n",
       "      <td>657800.0</td>\n",
       "      <td>219.70</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>32 rows × 192 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Type Geothermal Province       State Field Well ID  \\\n",
       "218  Transform Extension       Sierra Nevada  California  COSO  15A-17   \n",
       "99   Transform Extension       Sierra Nevada  California  COSO  23A-17   \n",
       "319  Transform Extension       Sierra Nevada  California  COSO  23A-17   \n",
       "354  Transform Extension       Sierra Nevada  California  COSO  23A-17   \n",
       "355  Transform Extension       Sierra Nevada  California  COSO  23A-17   \n",
       "356  Transform Extension       Sierra Nevada  California  COSO  23A-17   \n",
       "357  Transform Extension       Sierra Nevada  California  COSO  23A-17   \n",
       "358  Transform Extension       Sierra Nevada  California  COSO  23A-17   \n",
       "359  Transform Extension       Sierra Nevada  California  COSO  23A-17   \n",
       "360  Transform Extension       Sierra Nevada  California  COSO  23A-17   \n",
       "361  Transform Extension       Sierra Nevada  California  COSO  23A-17   \n",
       "362  Transform Extension       Sierra Nevada  California  COSO  23A-17   \n",
       "363  Transform Extension       Sierra Nevada  California  COSO  23A-17   \n",
       "365  Transform Extension       Sierra Nevada  California  COSO  23A-17   \n",
       "94   Transform Extension       Sierra Nevada  California  COSO  23A-19   \n",
       "314  Transform Extension       Sierra Nevada  California  COSO  23A-19   \n",
       "44   Transform Extension       Sierra Nevada  California  COSO   24A-8   \n",
       "264  Transform Extension       Sierra Nevada  California  COSO   24A-8   \n",
       "164  Transform Extension       Sierra Nevada  California  COSO   41B-8   \n",
       "76   Transform Extension       Sierra Nevada  California  COSO  54-7RD   \n",
       "77   Transform Extension       Sierra Nevada  California  COSO  54-7RD   \n",
       "182  Transform Extension       Sierra Nevada  California  COSO     NaN   \n",
       "0    Transform Extension       Sierra Nevada  California  COSO    68-6   \n",
       "219  Transform Extension       Sierra Nevada  California  COSO    68-6   \n",
       "439  Transform Extension       Sierra Nevada  California  COSO    68-6   \n",
       "75   Transform Extension       Sierra Nevada  California  COSO     NaN   \n",
       "515  Transform Extension       Sierra Nevada  California  COSO  83B-16   \n",
       "516  Transform Extension       Sierra Nevada  California  COSO  83B-16   \n",
       "151  Transform Extension       Sierra Nevada  California  COSO     NaN   \n",
       "371  Transform Extension       Sierra Nevada  California  COSO     NaN   \n",
       "97   Transform Extension       Sierra Nevada  California  COSO     NaN   \n",
       "317  Transform Extension       Sierra Nevada  California  COSO     NaN   \n",
       "\n",
       "    Sample ID Depth (ft)               AMU1       AMU2    AMU3  ...  \\\n",
       "218      2420        STD                  0   652700.0   73.74  ...   \n",
       "99       2640        STD                  0  1328000.0  240.00  ...   \n",
       "319      2860        STD                  0   512300.0   41.40  ...   \n",
       "354      2895        STD                  0   424500.0  190.40  ...   \n",
       "355      2896        STD                  0   414300.0  192.80  ...   \n",
       "356      2897        STD                  0   352700.0  190.40  ...   \n",
       "357      2898        STD                  0   533800.0   45.89  ...   \n",
       "358      2899        STD                  0  1116000.0  287.00  ...   \n",
       "359      2900        STD                  0   854200.0  121.70  ...   \n",
       "360      2901        STD                  0   693300.0  126.40  ...   \n",
       "361      2902        STD                  0  1163000.0  329.80  ...   \n",
       "362      2903        STD                  0   467200.0  165.00  ...   \n",
       "363      2904        STD                  0  1058000.0  252.60  ...   \n",
       "365      2906        STD                  0   664800.0  107.90  ...   \n",
       "94       3520        STD                  0   715100.0  156.40  ...   \n",
       "314      3740        STD                  0  1531000.0  406.20  ...   \n",
       "44        880        STD   880.0 0.0000E+00   543500.0  190.30  ...   \n",
       "264      1100        STD  1102.0 0.0000E+00   619500.0  160.60  ...   \n",
       "164      1320        STD                  0   487500.0  119.30  ...   \n",
       "76          -        STD                0.0   894600.0  262.70  ...   \n",
       "77          -        STD                0.0   752200.0  226.70  ...   \n",
       "182         -        STD                0.0  1557000.0  387.40  ...   \n",
       "0           1        STD                0.0   762200.0  247.10  ...   \n",
       "219       220        STD                0.0  1036000.0  419.40  ...   \n",
       "439       440        STD                0.0   480100.0  134.30  ...   \n",
       "75       1760        STD                0.0   374300.0  126.70  ...   \n",
       "515      2200        STD                  0   513300.0  187.70  ...   \n",
       "516      2201        STD                  0   679700.0  158.60  ...   \n",
       "151      3080        STD                  0   359700.0   29.91  ...   \n",
       "371      3300        STD                  0   799300.0   88.70  ...   \n",
       "97       3960        STD                  0   791200.0  130.10  ...   \n",
       "317      4180        STD                  0   657800.0  219.70  ...   \n",
       "\n",
       "     AMU176.UNKN   AMU177.UNKN   AMU178.UNKN   AMU179.UNKN   AMU180.UNKN  \\\n",
       "218     0.088880  0.000000e+00  0.000000e+00  3.666000e+00  0.000000e+00   \n",
       "99      0.000000  9.944000e-01  0.000000e+00  1.098000e+01  0.000000e+00   \n",
       "319     4.100000  0.000000e+00  3.756000e+01  2.360000e+01  6.079000e+02   \n",
       "354     0.000000  0.000000e+00  2.535000e-15  3.266000e-15  0.000000e+00   \n",
       "355     0.000000  0.000000e+00  2.085000e-02  1.861000e-01  0.000000e+00   \n",
       "356     0.008075  1.963000e-01  3.365000e-15  4.339000e-15  3.406000e-01   \n",
       "357     0.027780  8.909000e-02  0.000000e+00  2.932000e-01  3.758000e-15   \n",
       "358     0.000000  2.927000e-15  2.531000e-15  0.000000e+00  0.000000e+00   \n",
       "359     0.090050  1.770000e-02  1.372000e-01  0.000000e+00  5.942000e-01   \n",
       "360     0.077140  0.000000e+00  3.634000e-01  6.932000e-01  0.000000e+00   \n",
       "361     0.228600  0.000000e+00  0.000000e+00  1.585000e-01  7.869000e-02   \n",
       "362     0.281200  0.000000e+00  3.071000e-02  0.000000e+00  0.000000e+00   \n",
       "363     0.020610  0.000000e+00  2.585000e-15  2.170000e-02  0.000000e+00   \n",
       "365     0.111600  0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "94      0.000000  0.000000e+00  0.000000e+00  2.637000e+01  0.000000e+00   \n",
       "314     0.000000  0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "44      0.000000  0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "264     0.000000  0.000000e+00  1.769000e+02  9.495000e+02  0.000000e+00   \n",
       "164     8.057000  0.000000e+00  8.877000e+00  0.000000e+00  0.000000e+00   \n",
       "76      0.000000  0.000000e+00  0.000000e+00  0.000000e+00  2.504000e+01   \n",
       "77      9.132000  0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "182     0.000000  0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "0      14.920000  0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "219     0.000000  0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "439     0.000000  0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "75      0.000000  0.000000e+00  9.786000e+00  5.588000e+00  2.104000e+00   \n",
       "515     0.000000  0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "516     0.000000  0.000000e+00  0.000000e+00  0.000000e+00  6.403000e-01   \n",
       "151     0.000000  0.000000e+00  9.928000e-02  0.000000e+00  7.834000e-02   \n",
       "371     0.659400  9.011000e-14  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "97      0.000000  1.237000e+01  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "317     0.000000  0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "\n",
       "     FIT Well  Unnamed: 188  Unnamed: 8  Unnamed: 9  Unnamed: 187  \n",
       "218       NaN           NaN         NaN         NaN           NaN  \n",
       "99        NaN           NaN         NaN         NaN           NaN  \n",
       "319       NaN           NaN         NaN         NaN           NaN  \n",
       "354       NaN           NaN         NaN         NaN           NaN  \n",
       "355       NaN           NaN         NaN         NaN           NaN  \n",
       "356       NaN           NaN         NaN         NaN           NaN  \n",
       "357       NaN           NaN         NaN         NaN           NaN  \n",
       "358       NaN           NaN         NaN         NaN           NaN  \n",
       "359       NaN           NaN         NaN         NaN           NaN  \n",
       "360       NaN           NaN         NaN         NaN           NaN  \n",
       "361       NaN           NaN         NaN         NaN           NaN  \n",
       "362       NaN           NaN         NaN         NaN           NaN  \n",
       "363       NaN           NaN         NaN         NaN           NaN  \n",
       "365       NaN           NaN         NaN         NaN           NaN  \n",
       "94     23A-19           NaN         NaN         NaN           NaN  \n",
       "314    23A-19           NaN         NaN         NaN           NaN  \n",
       "44      24A-8           NaN         NaN         NaN           NaN  \n",
       "264     24A-8           NaN         NaN         NaN           NaN  \n",
       "164       NaN           NaN         NaN         NaN           NaN  \n",
       "76     54-7RD           NaN         NaN         NaN           NaN  \n",
       "77     54-7RD           NaN         NaN         NaN           NaN  \n",
       "182       NaN           NaN         NaN         NaN           NaN  \n",
       "0        68-6           NaN         NaN         NaN           NaN  \n",
       "219      68-6           NaN         NaN         NaN           NaN  \n",
       "439      68-6           NaN         NaN         NaN           NaN  \n",
       "75        NaN           NaN         NaN         NaN           NaN  \n",
       "515    83B-16           NaN         NaN         NaN           NaN  \n",
       "516    83B-16           NaN         NaN         NaN           NaN  \n",
       "151       NaN           NaN         NaN         NaN           NaN  \n",
       "371       NaN           NaN         NaN         NaN           NaN  \n",
       "97        NaN           NaN         NaN         NaN           NaN  \n",
       "317       NaN           NaN         NaN         NaN           NaN  \n",
       "\n",
       "[32 rows x 192 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Depth (ft)'].str.contains('STD', na=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "7390dbb7",
   "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>Type</th>\n",
       "      <th>Geothermal Province</th>\n",
       "      <th>State</th>\n",
       "      <th>Field</th>\n",
       "      <th>Well ID</th>\n",
       "      <th>Sample ID</th>\n",
       "      <th>Depth (ft)</th>\n",
       "      <th>AMU1</th>\n",
       "      <th>AMU2</th>\n",
       "      <th>AMU3</th>\n",
       "      <th>...</th>\n",
       "      <th>AMU176.UNKN</th>\n",
       "      <th>AMU177.UNKN</th>\n",
       "      <th>AMU178.UNKN</th>\n",
       "      <th>AMU179.UNKN</th>\n",
       "      <th>AMU180.UNKN</th>\n",
       "      <th>FIT Well</th>\n",
       "      <th>Unnamed: 188</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>Unnamed: 187</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>418</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>337</td>\n",
       "      <td>419</td>\n",
       "      <td>-</td>\n",
       "      <td>0</td>\n",
       "      <td>226300.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>35.37</td>\n",
       "      <td>8.6680</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>33-7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>337</td>\n",
       "      <td>420</td>\n",
       "      <td>-</td>\n",
       "      <td>0</td>\n",
       "      <td>276700.0</td>\n",
       "      <td>14.350</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>33-7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>420</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>337</td>\n",
       "      <td>421</td>\n",
       "      <td>-</td>\n",
       "      <td>0</td>\n",
       "      <td>265100.0</td>\n",
       "      <td>28.990</td>\n",
       "      <td>...</td>\n",
       "      <td>25.25</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>33-7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>337</td>\n",
       "      <td>422</td>\n",
       "      <td>-</td>\n",
       "      <td>0</td>\n",
       "      <td>204900.0</td>\n",
       "      <td>11.230</td>\n",
       "      <td>...</td>\n",
       "      <td>14.54</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>47.41</td>\n",
       "      <td>33-7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>337</td>\n",
       "      <td>423</td>\n",
       "      <td>-</td>\n",
       "      <td>0</td>\n",
       "      <td>184000.0</td>\n",
       "      <td>9.571</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>5.3740</td>\n",
       "      <td>0.00</td>\n",
       "      <td>170.40</td>\n",
       "      <td>0.00</td>\n",
       "      <td>33-7</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>337</td>\n",
       "      <td>500</td>\n",
       "      <td>-</td>\n",
       "      <td>0</td>\n",
       "      <td>919200.0</td>\n",
       "      <td>106.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.8952</td>\n",
       "      <td>70.24</td>\n",
       "      <td>12.49</td>\n",
       "      <td>59.66</td>\n",
       "      <td>33-7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>337</td>\n",
       "      <td>501</td>\n",
       "      <td>-</td>\n",
       "      <td>0</td>\n",
       "      <td>1070000.0</td>\n",
       "      <td>190.800</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6.7210</td>\n",
       "      <td>0.00</td>\n",
       "      <td>356.90</td>\n",
       "      <td>32.60</td>\n",
       "      <td>33-7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>337</td>\n",
       "      <td>502</td>\n",
       "      <td>-</td>\n",
       "      <td>0</td>\n",
       "      <td>605100.0</td>\n",
       "      <td>37.060</td>\n",
       "      <td>...</td>\n",
       "      <td>21.25</td>\n",
       "      <td>61.7300</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>33-7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>502</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>337</td>\n",
       "      <td>503</td>\n",
       "      <td>-</td>\n",
       "      <td>0</td>\n",
       "      <td>543700.0</td>\n",
       "      <td>40.650</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>75.8500</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>100.10</td>\n",
       "      <td>33-7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>503</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>337</td>\n",
       "      <td>504</td>\n",
       "      <td>-</td>\n",
       "      <td>0</td>\n",
       "      <td>733200.0</td>\n",
       "      <td>56.170</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>71.6000</td>\n",
       "      <td>17.93</td>\n",
       "      <td>0.00</td>\n",
       "      <td>233.80</td>\n",
       "      <td>33-7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>86 rows × 192 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Type Geothermal Province       State Field Well ID  \\\n",
       "418  Transform Extension       Sierra Nevada  California  COSO     337   \n",
       "419  Transform Extension       Sierra Nevada  California  COSO     337   \n",
       "420  Transform Extension       Sierra Nevada  California  COSO     337   \n",
       "421  Transform Extension       Sierra Nevada  California  COSO     337   \n",
       "422  Transform Extension       Sierra Nevada  California  COSO     337   \n",
       "..                   ...                 ...         ...   ...     ...   \n",
       "499  Transform Extension       Sierra Nevada  California  COSO     337   \n",
       "500  Transform Extension       Sierra Nevada  California  COSO     337   \n",
       "501  Transform Extension       Sierra Nevada  California  COSO     337   \n",
       "502  Transform Extension       Sierra Nevada  California  COSO     337   \n",
       "503  Transform Extension       Sierra Nevada  California  COSO     337   \n",
       "\n",
       "    Sample ID Depth (ft) AMU1       AMU2     AMU3  ...  AMU176.UNKN  \\\n",
       "418       419          -    0   226300.0    0.000  ...        35.37   \n",
       "419       420          -    0   276700.0   14.350  ...         0.00   \n",
       "420       421          -    0   265100.0   28.990  ...        25.25   \n",
       "421       422          -    0   204900.0   11.230  ...        14.54   \n",
       "422       423          -    0   184000.0    9.571  ...         0.00   \n",
       "..        ...        ...  ...        ...      ...  ...          ...   \n",
       "499       500          -    0   919200.0  106.000  ...         0.00   \n",
       "500       501          -    0  1070000.0  190.800  ...         0.00   \n",
       "501       502          -    0   605100.0   37.060  ...        21.25   \n",
       "502       503          -    0   543700.0   40.650  ...         0.00   \n",
       "503       504          -    0   733200.0   56.170  ...         0.00   \n",
       "\n",
       "     AMU177.UNKN  AMU178.UNKN  AMU179.UNKN  AMU180.UNKN  FIT Well  \\\n",
       "418       8.6680         0.00         0.00         0.00      33-7   \n",
       "419       0.0000         0.00         0.00         0.00      33-7   \n",
       "420       0.0000         0.00         0.00         0.00      33-7   \n",
       "421       0.0000         0.00         0.00        47.41      33-7   \n",
       "422       5.3740         0.00       170.40         0.00      33-7   \n",
       "..           ...          ...          ...          ...       ...   \n",
       "499       0.8952        70.24        12.49        59.66      33-7   \n",
       "500       6.7210         0.00       356.90        32.60      33-7   \n",
       "501      61.7300         0.00         0.00         0.00      33-7   \n",
       "502      75.8500         0.00         0.00       100.10      33-7   \n",
       "503      71.6000        17.93         0.00       233.80      33-7   \n",
       "\n",
       "     Unnamed: 188  Unnamed: 8  Unnamed: 9  Unnamed: 187  \n",
       "418           NaN         NaN         NaN           NaN  \n",
       "419           NaN         NaN         NaN           NaN  \n",
       "420           NaN         NaN         NaN           NaN  \n",
       "421           NaN         NaN         NaN           NaN  \n",
       "422           NaN         NaN         NaN           NaN  \n",
       "..            ...         ...         ...           ...  \n",
       "499           NaN         NaN         NaN           NaN  \n",
       "500           NaN         NaN         NaN           NaN  \n",
       "501           NaN         NaN         NaN           NaN  \n",
       "502           NaN         NaN         NaN           NaN  \n",
       "503           NaN         NaN         NaN           NaN  \n",
       "\n",
       "[86 rows x 192 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Depth (ft)'].str.contains('-', na=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "2d2738dd",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc[df['Depth (ft)'].str.contains('-', na=False), 'Depth (ft)'] = np.nan\n",
    "df.loc[df['Depth (ft)'].str.contains('STD', na=False), 'Depth (ft)'] = np.nan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "7afe39a0",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Depth (ft)'] = df['Depth (ft)'].astype('float64')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "9b9717e6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('float64')"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Depth (ft)'].dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "885fea88",
   "metadata": {},
   "outputs": [],
   "source": [
    "#df['Sample ID'].astype('float64')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "e68e004f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc[df['Sample ID'].str.contains('-', na=False), 'Sample ID'] = np.nan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "ad4efe10",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Sample ID'] = df['Sample ID'].astype('float64')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "d26432ed",
   "metadata": {},
   "outputs": [],
   "source": [
    "# yields ValueError: could not convert string to float: '836.0 0.0000E+00'\n",
    "#df.iloc[:, 7].astype('float64')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "0035e96d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'AMU1'"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns[7]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "9365bc17",
   "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>Type</th>\n",
       "      <th>Geothermal Province</th>\n",
       "      <th>State</th>\n",
       "      <th>Field</th>\n",
       "      <th>Well ID</th>\n",
       "      <th>Sample ID</th>\n",
       "      <th>Depth (ft)</th>\n",
       "      <th>AMU1</th>\n",
       "      <th>AMU2</th>\n",
       "      <th>AMU3</th>\n",
       "      <th>...</th>\n",
       "      <th>AMU176.UNKN</th>\n",
       "      <th>AMU177.UNKN</th>\n",
       "      <th>AMU178.UNKN</th>\n",
       "      <th>AMU179.UNKN</th>\n",
       "      <th>AMU180.UNKN</th>\n",
       "      <th>FIT Well</th>\n",
       "      <th>Unnamed: 188</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>Unnamed: 187</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>24A-8</td>\n",
       "      <td>836.0</td>\n",
       "      <td>480.0</td>\n",
       "      <td>836.0 0.0000E+00</td>\n",
       "      <td>341700.0</td>\n",
       "      <td>62.62</td>\n",
       "      <td>...</td>\n",
       "      <td>3.43700</td>\n",
       "      <td>0.00</td>\n",
       "      <td>10.9</td>\n",
       "      <td>6.177</td>\n",
       "      <td>0.00</td>\n",
       "      <td>24A-8</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>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>24A-8</td>\n",
       "      <td>837.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>837.0 0.0000E+00</td>\n",
       "      <td>327000.0</td>\n",
       "      <td>75.95</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>17.73</td>\n",
       "      <td>0.0</td>\n",
       "      <td>55.230</td>\n",
       "      <td>11.29</td>\n",
       "      <td>24A-8</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>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>24A-8</td>\n",
       "      <td>838.0</td>\n",
       "      <td>520.0</td>\n",
       "      <td>838.0 0.0000E+00</td>\n",
       "      <td>368700.0</td>\n",
       "      <td>112.30</td>\n",
       "      <td>...</td>\n",
       "      <td>3.09100</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>24A-8</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>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>24A-8</td>\n",
       "      <td>839.0</td>\n",
       "      <td>540.0</td>\n",
       "      <td>839.0 0.0000E+00</td>\n",
       "      <td>494800.0</td>\n",
       "      <td>166.60</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>24A-8</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>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>24A-8</td>\n",
       "      <td>840.0</td>\n",
       "      <td>560.0</td>\n",
       "      <td>840.0 0.0000E+00</td>\n",
       "      <td>381800.0</td>\n",
       "      <td>75.10</td>\n",
       "      <td>...</td>\n",
       "      <td>4.40900</td>\n",
       "      <td>23.02</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>24A-8</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>308</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>24A-8</td>\n",
       "      <td>1144.0</td>\n",
       "      <td>6480.0</td>\n",
       "      <td>1146.0 0.0000E+00</td>\n",
       "      <td>515900.0</td>\n",
       "      <td>172.50</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>131.2</td>\n",
       "      <td>646.900</td>\n",
       "      <td>16.13</td>\n",
       "      <td>24A-8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>309</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>24A-8</td>\n",
       "      <td>1145.0</td>\n",
       "      <td>6500.0</td>\n",
       "      <td>1147.0 0.0000E+00</td>\n",
       "      <td>620700.0</td>\n",
       "      <td>153.30</td>\n",
       "      <td>...</td>\n",
       "      <td>2.34900</td>\n",
       "      <td>0.00</td>\n",
       "      <td>276.3</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>24A-8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>24A-8</td>\n",
       "      <td>1146.0</td>\n",
       "      <td>6520.0</td>\n",
       "      <td>1148.0 0.0000E+00</td>\n",
       "      <td>638200.0</td>\n",
       "      <td>207.40</td>\n",
       "      <td>...</td>\n",
       "      <td>0.02781</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>24A-8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>311</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>24A-8</td>\n",
       "      <td>1147.0</td>\n",
       "      <td>6540.0</td>\n",
       "      <td>1149.0 0.0000E+00</td>\n",
       "      <td>554200.0</td>\n",
       "      <td>148.40</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>231.8</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>24A-8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>312</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>24A-8</td>\n",
       "      <td>1148.0</td>\n",
       "      <td>6560.0</td>\n",
       "      <td>1150.0 0.0000E+00</td>\n",
       "      <td>515900.0</td>\n",
       "      <td>108.80</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>24A-8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>313 rows × 192 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Type Geothermal Province       State Field Well ID  \\\n",
       "0    Transform Extension       Sierra Nevada  California  COSO   24A-8   \n",
       "1    Transform Extension       Sierra Nevada  California  COSO   24A-8   \n",
       "2    Transform Extension       Sierra Nevada  California  COSO   24A-8   \n",
       "3    Transform Extension       Sierra Nevada  California  COSO   24A-8   \n",
       "4    Transform Extension       Sierra Nevada  California  COSO   24A-8   \n",
       "..                   ...                 ...         ...   ...     ...   \n",
       "308  Transform Extension       Sierra Nevada  California  COSO   24A-8   \n",
       "309  Transform Extension       Sierra Nevada  California  COSO   24A-8   \n",
       "310  Transform Extension       Sierra Nevada  California  COSO   24A-8   \n",
       "311  Transform Extension       Sierra Nevada  California  COSO   24A-8   \n",
       "312  Transform Extension       Sierra Nevada  California  COSO   24A-8   \n",
       "\n",
       "     Sample ID  Depth (ft)               AMU1      AMU2    AMU3  ...  \\\n",
       "0        836.0       480.0   836.0 0.0000E+00  341700.0   62.62  ...   \n",
       "1        837.0       500.0   837.0 0.0000E+00  327000.0   75.95  ...   \n",
       "2        838.0       520.0   838.0 0.0000E+00  368700.0  112.30  ...   \n",
       "3        839.0       540.0   839.0 0.0000E+00  494800.0  166.60  ...   \n",
       "4        840.0       560.0   840.0 0.0000E+00  381800.0   75.10  ...   \n",
       "..         ...         ...                ...       ...     ...  ...   \n",
       "308     1144.0      6480.0  1146.0 0.0000E+00  515900.0  172.50  ...   \n",
       "309     1145.0      6500.0  1147.0 0.0000E+00  620700.0  153.30  ...   \n",
       "310     1146.0      6520.0  1148.0 0.0000E+00  638200.0  207.40  ...   \n",
       "311     1147.0      6540.0  1149.0 0.0000E+00  554200.0  148.40  ...   \n",
       "312     1148.0      6560.0  1150.0 0.0000E+00  515900.0  108.80  ...   \n",
       "\n",
       "     AMU176.UNKN  AMU177.UNKN  AMU178.UNKN  AMU179.UNKN  AMU180.UNKN  \\\n",
       "0        3.43700         0.00         10.9        6.177         0.00   \n",
       "1        0.00000        17.73          0.0       55.230        11.29   \n",
       "2        3.09100         0.00          0.0        0.000         0.00   \n",
       "3        0.00000         0.00          0.0        0.000         0.00   \n",
       "4        4.40900        23.02          0.0        0.000         0.00   \n",
       "..           ...          ...          ...          ...          ...   \n",
       "308      0.00000         0.00        131.2      646.900        16.13   \n",
       "309      2.34900         0.00        276.3        0.000         0.00   \n",
       "310      0.02781         0.00          0.0        0.000         0.00   \n",
       "311      0.00000         0.00        231.8        0.000         0.00   \n",
       "312      0.00000         0.00          0.0        0.000         0.00   \n",
       "\n",
       "     FIT Well  Unnamed: 188  Unnamed: 8  Unnamed: 9  Unnamed: 187  \n",
       "0       24A-8           NaN         NaN         NaN           NaN  \n",
       "1       24A-8           NaN         NaN         NaN           NaN  \n",
       "2       24A-8           NaN         NaN         NaN           NaN  \n",
       "3       24A-8           NaN         NaN         NaN           NaN  \n",
       "4       24A-8           NaN         NaN         NaN           NaN  \n",
       "..        ...           ...         ...         ...           ...  \n",
       "308     24A-8           NaN         NaN         NaN           NaN  \n",
       "309     24A-8           NaN         NaN         NaN           NaN  \n",
       "310     24A-8           NaN         NaN         NaN           NaN  \n",
       "311     24A-8           NaN         NaN         NaN           NaN  \n",
       "312     24A-8           NaN         NaN         NaN           NaN  \n",
       "\n",
       "[313 rows x 192 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[df['AMU1'].str.contains('E+', regex=False, na=False) == True]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "7ef3e87a",
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "#df[df['Well ID'] == '24A-8'][-50:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "fc1bfadd",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc[(df['AMU1'].str.contains('E+', regex=False, na=False) == True) &\n",
    "       (df['Well ID'] == '24A-8'), 'AMU1'] = np.nan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "f98f1abb",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc[df['Well ID'] == '24A-8', 'AMU1'] = np.nan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "a3404fa4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     NaN\n",
       "1     NaN\n",
       "2     NaN\n",
       "3     NaN\n",
       "4     NaN\n",
       "       ..\n",
       "315   NaN\n",
       "316   NaN\n",
       "317   NaN\n",
       "318   NaN\n",
       "319   NaN\n",
       "Name: AMU1, Length: 320, dtype: float64"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[df['Well ID'] == '24A-8', 'AMU1'].astype('float64')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "a7e2c4ce",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('./data/cleaned_types.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "0c11edfb",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('./data/cleaned_types.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "ae894e9e",
   "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>Type</th>\n",
       "      <th>Geothermal Province</th>\n",
       "      <th>State</th>\n",
       "      <th>Field</th>\n",
       "      <th>Well ID</th>\n",
       "      <th>Sample ID</th>\n",
       "      <th>Depth (ft)</th>\n",
       "      <th>AMU1</th>\n",
       "      <th>AMU2</th>\n",
       "      <th>AMU3</th>\n",
       "      <th>...</th>\n",
       "      <th>AMU176.UNKN</th>\n",
       "      <th>AMU177.UNKN</th>\n",
       "      <th>AMU178.UNKN</th>\n",
       "      <th>AMU179.UNKN</th>\n",
       "      <th>AMU180.UNKN</th>\n",
       "      <th>FIT Well</th>\n",
       "      <th>Unnamed: 188</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>Unnamed: 187</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>15A-17</td>\n",
       "      <td>2202.0</td>\n",
       "      <td>510.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>294200.0</td>\n",
       "      <td>53.30</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2434.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</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>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>15A-17</td>\n",
       "      <td>2203.0</td>\n",
       "      <td>530.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>320600.0</td>\n",
       "      <td>48.95</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>80.84</td>\n",
       "      <td>59.98</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.450</td>\n",
       "      <td>NaN</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>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>15A-17</td>\n",
       "      <td>2204.0</td>\n",
       "      <td>550.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>385400.0</td>\n",
       "      <td>159.40</td>\n",
       "      <td>...</td>\n",
       "      <td>592.6</td>\n",
       "      <td>0.00</td>\n",
       "      <td>580.30</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27.630</td>\n",
       "      <td>NaN</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>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>15A-17</td>\n",
       "      <td>2205.0</td>\n",
       "      <td>570.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>448600.0</td>\n",
       "      <td>122.90</td>\n",
       "      <td>...</td>\n",
       "      <td>376.7</td>\n",
       "      <td>0.00</td>\n",
       "      <td>577.80</td>\n",
       "      <td>6065.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</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>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>15A-17</td>\n",
       "      <td>2206.0</td>\n",
       "      <td>590.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>293800.0</td>\n",
       "      <td>47.05</td>\n",
       "      <td>...</td>\n",
       "      <td>241.1</td>\n",
       "      <td>33.28</td>\n",
       "      <td>378.30</td>\n",
       "      <td>5696.0</td>\n",
       "      <td>1.211</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 192 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Type Geothermal Province       State Field Well ID  \\\n",
       "0  Transform Extension       Sierra Nevada  California  COSO  15A-17   \n",
       "1  Transform Extension       Sierra Nevada  California  COSO  15A-17   \n",
       "2  Transform Extension       Sierra Nevada  California  COSO  15A-17   \n",
       "3  Transform Extension       Sierra Nevada  California  COSO  15A-17   \n",
       "4  Transform Extension       Sierra Nevada  California  COSO  15A-17   \n",
       "\n",
       "   Sample ID  Depth (ft)  AMU1      AMU2    AMU3  ...  AMU176.UNKN  \\\n",
       "0     2202.0       510.0   0.0  294200.0   53.30  ...          0.0   \n",
       "1     2203.0       530.0   0.0  320600.0   48.95  ...          0.0   \n",
       "2     2204.0       550.0   0.0  385400.0  159.40  ...        592.6   \n",
       "3     2205.0       570.0   0.0  448600.0  122.90  ...        376.7   \n",
       "4     2206.0       590.0   0.0  293800.0   47.05  ...        241.1   \n",
       "\n",
       "   AMU177.UNKN  AMU178.UNKN  AMU179.UNKN  AMU180.UNKN  FIT Well  Unnamed: 188  \\\n",
       "0         0.00      2434.00          0.0        0.000       NaN           NaN   \n",
       "1        80.84        59.98          0.0       11.450       NaN           NaN   \n",
       "2         0.00       580.30          0.0       27.630       NaN           NaN   \n",
       "3         0.00       577.80       6065.0        0.000       NaN           NaN   \n",
       "4        33.28       378.30       5696.0        1.211       NaN           NaN   \n",
       "\n",
       "   Unnamed: 8  Unnamed: 9  Unnamed: 187  \n",
       "0         NaN         NaN           NaN  \n",
       "1         NaN         NaN           NaN  \n",
       "2         NaN         NaN           NaN  \n",
       "3         NaN         NaN           NaN  \n",
       "4         NaN         NaN           NaN  \n",
       "\n",
       "[5 rows x 192 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "969e2834",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(9712, 192)"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "2adcf201",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 9712 entries, 0 to 9711\n",
      "Columns: 192 entries, Type to Unnamed: 187\n",
      "dtypes: float64(186), object(6)\n",
      "memory usage: 14.2+ MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "fca383e8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Type object\n",
      "Geothermal Province object\n",
      "State object\n",
      "Field object\n",
      "Well ID object\n",
      "FIT Well object\n"
     ]
    }
   ],
   "source": [
    "for col in df.columns:\n",
    "    if df[col].dtype != 'float64':\n",
    "        print(col, df[col].dtype)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "62d3f0d9",
   "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>Type</th>\n",
       "      <th>Geothermal Province</th>\n",
       "      <th>State</th>\n",
       "      <th>Field</th>\n",
       "      <th>Well ID</th>\n",
       "      <th>Sample ID</th>\n",
       "      <th>Depth (ft)</th>\n",
       "      <th>AMU1</th>\n",
       "      <th>AMU2</th>\n",
       "      <th>AMU3</th>\n",
       "      <th>...</th>\n",
       "      <th>AMU176.UNKN</th>\n",
       "      <th>AMU177.UNKN</th>\n",
       "      <th>AMU178.UNKN</th>\n",
       "      <th>AMU179.UNKN</th>\n",
       "      <th>AMU180.UNKN</th>\n",
       "      <th>FIT Well</th>\n",
       "      <th>Unnamed: 188</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>Unnamed: 187</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>15A-17</td>\n",
       "      <td>2202.0</td>\n",
       "      <td>510.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>294200.0</td>\n",
       "      <td>53.30</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2434.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</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>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>15A-17</td>\n",
       "      <td>2203.0</td>\n",
       "      <td>530.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>320600.0</td>\n",
       "      <td>48.95</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>80.84</td>\n",
       "      <td>59.98</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.450</td>\n",
       "      <td>NaN</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>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>15A-17</td>\n",
       "      <td>2204.0</td>\n",
       "      <td>550.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>385400.0</td>\n",
       "      <td>159.40</td>\n",
       "      <td>...</td>\n",
       "      <td>592.6</td>\n",
       "      <td>0.00</td>\n",
       "      <td>580.30</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27.630</td>\n",
       "      <td>NaN</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>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>15A-17</td>\n",
       "      <td>2205.0</td>\n",
       "      <td>570.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>448600.0</td>\n",
       "      <td>122.90</td>\n",
       "      <td>...</td>\n",
       "      <td>376.7</td>\n",
       "      <td>0.00</td>\n",
       "      <td>577.80</td>\n",
       "      <td>6065.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</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>Transform Extension</td>\n",
       "      <td>Sierra Nevada</td>\n",
       "      <td>California</td>\n",
       "      <td>COSO</td>\n",
       "      <td>15A-17</td>\n",
       "      <td>2206.0</td>\n",
       "      <td>590.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>293800.0</td>\n",
       "      <td>47.05</td>\n",
       "      <td>...</td>\n",
       "      <td>241.1</td>\n",
       "      <td>33.28</td>\n",
       "      <td>378.30</td>\n",
       "      <td>5696.0</td>\n",
       "      <td>1.211</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 192 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Type Geothermal Province       State Field Well ID  \\\n",
       "0  Transform Extension       Sierra Nevada  California  COSO  15A-17   \n",
       "1  Transform Extension       Sierra Nevada  California  COSO  15A-17   \n",
       "2  Transform Extension       Sierra Nevada  California  COSO  15A-17   \n",
       "3  Transform Extension       Sierra Nevada  California  COSO  15A-17   \n",
       "4  Transform Extension       Sierra Nevada  California  COSO  15A-17   \n",
       "\n",
       "   Sample ID  Depth (ft)  AMU1      AMU2    AMU3  ...  AMU176.UNKN  \\\n",
       "0     2202.0       510.0   0.0  294200.0   53.30  ...          0.0   \n",
       "1     2203.0       530.0   0.0  320600.0   48.95  ...          0.0   \n",
       "2     2204.0       550.0   0.0  385400.0  159.40  ...        592.6   \n",
       "3     2205.0       570.0   0.0  448600.0  122.90  ...        376.7   \n",
       "4     2206.0       590.0   0.0  293800.0   47.05  ...        241.1   \n",
       "\n",
       "   AMU177.UNKN  AMU178.UNKN  AMU179.UNKN  AMU180.UNKN  FIT Well  Unnamed: 188  \\\n",
       "0         0.00      2434.00          0.0        0.000       NaN           NaN   \n",
       "1        80.84        59.98          0.0       11.450       NaN           NaN   \n",
       "2         0.00       580.30          0.0       27.630       NaN           NaN   \n",
       "3         0.00       577.80       6065.0        0.000       NaN           NaN   \n",
       "4        33.28       378.30       5696.0        1.211       NaN           NaN   \n",
       "\n",
       "   Unnamed: 8  Unnamed: 9  Unnamed: 187  \n",
       "0         NaN         NaN           NaN  \n",
       "1         NaN         NaN           NaN  \n",
       "2         NaN         NaN           NaN  \n",
       "3         NaN         NaN           NaN  \n",
       "4         NaN         NaN           NaN  \n",
       "\n",
       "[5 rows x 192 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f25f8b60",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}