1. Fluid inclusions data inspection.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "finite-excitement",
   "metadata": {},
   "source": [
    "## 29 wells from Coso Field. Storaged in S3 bucket "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "average-history",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "temporal-encounter",
   "metadata": {},
   "source": [
    "#### Here an example for well 15A-17"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "satellite-hollow",
   "metadata": {},
   "outputs": [],
   "source": [
    "well15A = pd.read_excel('s3://geotermaldata/S3FluidInclusionGasAnalysisData/COSO Field/15A-17-DOE-GDR.xls', skiprows =4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "organizational-surname",
   "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>AMU171.UNKN</th>\n",
       "      <th>AMU172.UNKN</th>\n",
       "      <th>AMU173.UNKN</th>\n",
       "      <th>AMU174.UNKN</th>\n",
       "      <th>AMU175.UNKN</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",
       "    </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</td>\n",
       "      <td>53.30</td>\n",
       "      <td>...</td>\n",
       "      <td>41.940</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2434.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</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</td>\n",
       "      <td>48.95</td>\n",
       "      <td>...</td>\n",
       "      <td>48.030</td>\n",
       "      <td>0</td>\n",
       "      <td>1.089</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>80.84</td>\n",
       "      <td>59.98</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.4500</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</td>\n",
       "      <td>159.40</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>8.628</td>\n",
       "      <td>0.00</td>\n",
       "      <td>216.50</td>\n",
       "      <td>592.60</td>\n",
       "      <td>0.00</td>\n",
       "      <td>580.30</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27.6300</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</td>\n",
       "      <td>122.90</td>\n",
       "      <td>...</td>\n",
       "      <td>25.720</td>\n",
       "      <td>0</td>\n",
       "      <td>9.448</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>376.70</td>\n",
       "      <td>0.00</td>\n",
       "      <td>577.80</td>\n",
       "      <td>6065.0</td>\n",
       "      <td>0.0000</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</td>\n",
       "      <td>47.05</td>\n",
       "      <td>...</td>\n",
       "      <td>9.996</td>\n",
       "      <td>0</td>\n",
       "      <td>26.820</td>\n",
       "      <td>37.63</td>\n",
       "      <td>99.01</td>\n",
       "      <td>241.10</td>\n",
       "      <td>33.28</td>\n",
       "      <td>378.30</td>\n",
       "      <td>5696.0</td>\n",
       "      <td>1.2110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</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>2207</td>\n",
       "      <td>610</td>\n",
       "      <td>0</td>\n",
       "      <td>330500</td>\n",
       "      <td>56.79</td>\n",
       "      <td>...</td>\n",
       "      <td>14.240</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>52.55</td>\n",
       "      <td>128.70</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.9166</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</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>2208</td>\n",
       "      <td>630</td>\n",
       "      <td>0</td>\n",
       "      <td>273800</td>\n",
       "      <td>37.99</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>255.10</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</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>2209</td>\n",
       "      <td>650</td>\n",
       "      <td>0</td>\n",
       "      <td>294000</td>\n",
       "      <td>32.61</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>104.10</td>\n",
       "      <td>19.59</td>\n",
       "      <td>7218.0</td>\n",
       "      <td>0.1796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</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>2210</td>\n",
       "      <td>670</td>\n",
       "      <td>0</td>\n",
       "      <td>342500</td>\n",
       "      <td>40.79</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>14.22</td>\n",
       "      <td>0.00</td>\n",
       "      <td>18.20</td>\n",
       "      <td>20.84</td>\n",
       "      <td>732.30</td>\n",
       "      <td>4204.0</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</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>2211</td>\n",
       "      <td>690</td>\n",
       "      <td>0</td>\n",
       "      <td>284100</td>\n",
       "      <td>82.84</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>38.610</td>\n",
       "      <td>0.00</td>\n",
       "      <td>132.40</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 187 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",
       "5  Transform Extension       Sierra Nevada  California  COSO  15A-17   \n",
       "6  Transform Extension       Sierra Nevada  California  COSO  15A-17   \n",
       "7  Transform Extension       Sierra Nevada  California  COSO  15A-17   \n",
       "8  Transform Extension       Sierra Nevada  California  COSO  15A-17   \n",
       "9  Transform Extension       Sierra Nevada  California  COSO  15A-17   \n",
       "\n",
       "   Sample ID Depth (ft)  AMU1    AMU2    AMU3  ...  AMU171.UNKN  AMU172.UNKN  \\\n",
       "0       2202        510     0  294200   53.30  ...       41.940            0   \n",
       "1       2203        530     0  320600   48.95  ...       48.030            0   \n",
       "2       2204        550     0  385400  159.40  ...        0.000            0   \n",
       "3       2205        570     0  448600  122.90  ...       25.720            0   \n",
       "4       2206        590     0  293800   47.05  ...        9.996            0   \n",
       "5       2207        610     0  330500   56.79  ...       14.240            0   \n",
       "6       2208        630     0  273800   37.99  ...        0.000            0   \n",
       "7       2209        650     0  294000   32.61  ...        0.000            0   \n",
       "8       2210        670     0  342500   40.79  ...        0.000            0   \n",
       "9       2211        690     0  284100   82.84  ...        0.000            0   \n",
       "\n",
       "   AMU173.UNKN  AMU174.UNKN  AMU175.UNKN  AMU176.UNKN  AMU177.UNKN  \\\n",
       "0        0.000         0.00         0.00         0.00         0.00   \n",
       "1        1.089         0.00         0.00         0.00        80.84   \n",
       "2        8.628         0.00       216.50       592.60         0.00   \n",
       "3        9.448         0.00         0.00       376.70         0.00   \n",
       "4       26.820        37.63        99.01       241.10        33.28   \n",
       "5        0.000         0.00         0.00        52.55       128.70   \n",
       "6        0.000         0.00         0.00       255.10         0.00   \n",
       "7        0.000         0.00         0.00         0.00       104.10   \n",
       "8        0.000        14.22         0.00        18.20        20.84   \n",
       "9       38.610         0.00       132.40         0.00         0.00   \n",
       "\n",
       "   AMU178.UNKN  AMU179.UNKN  AMU180.UNKN  \n",
       "0      2434.00          0.0       0.0000  \n",
       "1        59.98          0.0      11.4500  \n",
       "2       580.30          0.0      27.6300  \n",
       "3       577.80       6065.0       0.0000  \n",
       "4       378.30       5696.0       1.2110  \n",
       "5         0.00          0.0       0.9166  \n",
       "6         0.00          0.0       0.0000  \n",
       "7        19.59       7218.0       0.1796  \n",
       "8       732.30       4204.0       0.0000  \n",
       "9         0.00          0.0       0.0000  \n",
       "\n",
       "[10 rows x 187 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "well15A.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "first-tutorial",
   "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>Sample ID</th>\n",
       "      <th>AMU1</th>\n",
       "      <th>AMU2</th>\n",
       "      <th>AMU3</th>\n",
       "      <th>AMU4</th>\n",
       "      <th>AMU5</th>\n",
       "      <th>AMU6</th>\n",
       "      <th>AMU7</th>\n",
       "      <th>AMU8</th>\n",
       "      <th>AMU9</th>\n",
       "      <th>...</th>\n",
       "      <th>AMU171.UNKN</th>\n",
       "      <th>AMU172.UNKN</th>\n",
       "      <th>AMU173.UNKN</th>\n",
       "      <th>AMU174.UNKN</th>\n",
       "      <th>AMU175.UNKN</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>339.000000</td>\n",
       "      <td>339.0</td>\n",
       "      <td>3.390000e+02</td>\n",
       "      <td>339.000000</td>\n",
       "      <td>3.390000e+02</td>\n",
       "      <td>339.0</td>\n",
       "      <td>339.0</td>\n",
       "      <td>339.0</td>\n",
       "      <td>339.0</td>\n",
       "      <td>339.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3.390000e+02</td>\n",
       "      <td>339.0</td>\n",
       "      <td>339.000000</td>\n",
       "      <td>3.390000e+02</td>\n",
       "      <td>3.390000e+02</td>\n",
       "      <td>3.390000e+02</td>\n",
       "      <td>339.000000</td>\n",
       "      <td>339.000000</td>\n",
       "      <td>3.390000e+02</td>\n",
       "      <td>339.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2371.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.365389e+05</td>\n",
       "      <td>70.990071</td>\n",
       "      <td>5.743606e+01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3.586068e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.812354</td>\n",
       "      <td>1.891663e+00</td>\n",
       "      <td>2.269905e+01</td>\n",
       "      <td>4.601779e+01</td>\n",
       "      <td>23.815630</td>\n",
       "      <td>89.434750</td>\n",
       "      <td>3.075466e+03</td>\n",
       "      <td>2.334480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>98.005102</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.385959e+05</td>\n",
       "      <td>47.571286</td>\n",
       "      <td>7.916333e+01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.144333e+01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>155.200577</td>\n",
       "      <td>5.585360e+00</td>\n",
       "      <td>7.482621e+01</td>\n",
       "      <td>1.410200e+02</td>\n",
       "      <td>274.172397</td>\n",
       "      <td>362.608949</td>\n",
       "      <td>2.618240e+04</td>\n",
       "      <td>29.753493</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>2202.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.372000e+05</td>\n",
       "      <td>6.060000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</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.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2286.500000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.377000e+05</td>\n",
       "      <td>36.800000</td>\n",
       "      <td>5.371000e-12</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</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.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2371.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.974000e+05</td>\n",
       "      <td>55.760000</td>\n",
       "      <td>3.077000e+01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7.757000e-15</td>\n",
       "      <td>5.308000e-15</td>\n",
       "      <td>7.195000e-15</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>8.809000e-15</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>2455.500000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.065500e+05</td>\n",
       "      <td>94.210000</td>\n",
       "      <td>7.261000e+01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3.304000e-07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.074285</td>\n",
       "      <td>5.531500e-01</td>\n",
       "      <td>5.853000e-01</td>\n",
       "      <td>1.021500e+00</td>\n",
       "      <td>0.186150</td>\n",
       "      <td>0.345450</td>\n",
       "      <td>8.381500e-01</td>\n",
       "      <td>0.000122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2540.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.123000e+06</td>\n",
       "      <td>265.400000</td>\n",
       "      <td>3.851000e+02</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8.351000e+01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2069.000000</td>\n",
       "      <td>3.979000e+01</td>\n",
       "      <td>5.079000e+02</td>\n",
       "      <td>1.294000e+03</td>\n",
       "      <td>4983.000000</td>\n",
       "      <td>3483.000000</td>\n",
       "      <td>4.676000e+05</td>\n",
       "      <td>545.600000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 181 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         Sample ID   AMU1          AMU2        AMU3          AMU4   AMU5  \\\n",
       "count   339.000000  339.0  3.390000e+02  339.000000  3.390000e+02  339.0   \n",
       "mean   2371.000000    0.0  4.365389e+05   70.990071  5.743606e+01    0.0   \n",
       "std      98.005102    0.0  1.385959e+05   47.571286  7.916333e+01    0.0   \n",
       "min    2202.000000    0.0  2.372000e+05    6.060000  0.000000e+00    0.0   \n",
       "25%    2286.500000    0.0  3.377000e+05   36.800000  5.371000e-12    0.0   \n",
       "50%    2371.000000    0.0  3.974000e+05   55.760000  3.077000e+01    0.0   \n",
       "75%    2455.500000    0.0  5.065500e+05   94.210000  7.261000e+01    0.0   \n",
       "max    2540.000000    0.0  1.123000e+06  265.400000  3.851000e+02    0.0   \n",
       "\n",
       "        AMU6   AMU7   AMU8   AMU9  ...   AMU171.UNKN  AMU172.UNKN  \\\n",
       "count  339.0  339.0  339.0  339.0  ...  3.390000e+02        339.0   \n",
       "mean     0.0    0.0    0.0    0.0  ...  3.586068e+00          0.0   \n",
       "std      0.0    0.0    0.0    0.0  ...  1.144333e+01          0.0   \n",
       "min      0.0    0.0    0.0    0.0  ...  0.000000e+00          0.0   \n",
       "25%      0.0    0.0    0.0    0.0  ...  0.000000e+00          0.0   \n",
       "50%      0.0    0.0    0.0    0.0  ...  0.000000e+00          0.0   \n",
       "75%      0.0    0.0    0.0    0.0  ...  3.304000e-07          0.0   \n",
       "max      0.0    0.0    0.0    0.0  ...  8.351000e+01          0.0   \n",
       "\n",
       "       AMU173.UNKN   AMU174.UNKN   AMU175.UNKN   AMU176.UNKN  AMU177.UNKN  \\\n",
       "count   339.000000  3.390000e+02  3.390000e+02  3.390000e+02   339.000000   \n",
       "mean     14.812354  1.891663e+00  2.269905e+01  4.601779e+01    23.815630   \n",
       "std     155.200577  5.585360e+00  7.482621e+01  1.410200e+02   274.172397   \n",
       "min       0.000000  0.000000e+00  0.000000e+00  0.000000e+00     0.000000   \n",
       "25%       0.000000  0.000000e+00  0.000000e+00  0.000000e+00     0.000000   \n",
       "50%       0.000000  7.757000e-15  5.308000e-15  7.195000e-15     0.000000   \n",
       "75%       0.074285  5.531500e-01  5.853000e-01  1.021500e+00     0.186150   \n",
       "max    2069.000000  3.979000e+01  5.079000e+02  1.294000e+03  4983.000000   \n",
       "\n",
       "       AMU178.UNKN   AMU179.UNKN  AMU180.UNKN  \n",
       "count   339.000000  3.390000e+02   339.000000  \n",
       "mean     89.434750  3.075466e+03     2.334480  \n",
       "std     362.608949  2.618240e+04    29.753493  \n",
       "min       0.000000  0.000000e+00     0.000000  \n",
       "25%       0.000000  0.000000e+00     0.000000  \n",
       "50%       0.000000  8.809000e-15     0.000000  \n",
       "75%       0.345450  8.381500e-01     0.000122  \n",
       "max    3483.000000  4.676000e+05   545.600000  \n",
       "\n",
       "[8 rows x 181 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "well15A.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ranking-substance",
   "metadata": {},
   "source": [
    "#### Coso wells coordinates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "senior-bones",
   "metadata": {},
   "outputs": [],
   "source": [
    "all_coord=pd.read_csv('s3://geotermaldata/S3FluidInclusionGasAnalysisData/COSO Field/COSO_wells_coord_gen.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "functional-shower",
   "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>WellNumber</th>\n",
       "      <th>Lat83</th>\n",
       "      <th>Long83</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>54-7</td>\n",
       "      <td>36.036025</td>\n",
       "      <td>-117.805748</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>63-7</td>\n",
       "      <td>36.036998</td>\n",
       "      <td>-117.803267</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>75B-7</td>\n",
       "      <td>36.032537</td>\n",
       "      <td>-117.801279</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>25-34</td>\n",
       "      <td>36.063566</td>\n",
       "      <td>-117.759587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>23A-19</td>\n",
       "      <td>36.008583</td>\n",
       "      <td>-117.814925</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>74B-19</td>\n",
       "      <td>36.006806</td>\n",
       "      <td>-117.802405</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>24-8</td>\n",
       "      <td>36.035673</td>\n",
       "      <td>-117.796189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>14-16</td>\n",
       "      <td>36.020803</td>\n",
       "      <td>-117.779837</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>16A-8</td>\n",
       "      <td>36.032181</td>\n",
       "      <td>-117.798867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>78B-6</td>\n",
       "      <td>36.043066</td>\n",
       "      <td>-117.802761</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>176 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    WellNumber      Lat83      Long83\n",
       "0       54-7    36.036025 -117.805748\n",
       "1       63-7    36.036998 -117.803267\n",
       "2       75B-7   36.032537 -117.801279\n",
       "3       25-34   36.063566 -117.759587\n",
       "4       23A-19  36.008583 -117.814925\n",
       "..         ...        ...         ...\n",
       "171     74B-19  36.006806 -117.802405\n",
       "172     24-8    36.035673 -117.796189\n",
       "173     14-16   36.020803 -117.779837\n",
       "174     16A-8   36.032181 -117.798867\n",
       "175     78B-6   36.043066 -117.802761\n",
       "\n",
       "[176 rows x 3 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_coord[['WellNumber','Lat83', 'Long83']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "environmental-doctor",
   "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.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}