Skip to content

Instantly share code, notes, and snippets.

@mbstacy

mbstacy/OWS_Water_Usage_Oil_Gas.ipynb

Created November 3, 2014 17:39
Show Gist options
  • Save mbstacy/f91b89083f257d4acdb2 to your computer and use it in GitHub Desktop.
Save mbstacy/f91b89083f257d4acdb2 to your computer and use it in GitHub Desktop.
Download ZIP
OWS - Oil and Gas water usage grouped by year and fluid type
Display the source blob
Display the rendered blob
Raw
OWS_Water_Usage_Oil_Gas.ipynb
{
"metadata": {
"name": "",
"signature": "sha256:70f0d3d88900e9f89302df0121e10fbaf7946ab8440244cba9f7ab7ebcb87218"
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### OWS: Water usage by Oil Gas"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"from pandas import read_excel, concat, merge, options,unique\n",
"#Display options set for pandas \n",
"options.display.max_columns = 50\n",
"options.display.max_rows = 250\n",
"H_list=[]\n",
"tt_list=[]\n",
"template= '/Users/mstacy/Desktop/ows-data/Export - Excel Well Workbook_%d.xlsx'\n",
"for num in [1,2,3]:\n",
" Header = read_excel(template % (num),sheetname='Header')\n",
" H_list.append(Header)\n",
" test_treat = read_excel(template % (num),sheetname='Test Treatment')\n",
" tt_list.append(test_treat)\n",
"\n",
"Header=concat(H_list)\n",
"test_treat= concat(tt_list)\n",
"\n",
"#loaded from all excel speadsheets the Header Tab and the Test Treatment Tabs"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 2
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"#merge and display want columns\n",
"df = merge(Header,test_treat,on='UWI')\n",
"result=df[['UWI','Date Completion','Fluid Amount (gals)','Type','Fluid Amount','Fluid Units','Fluid Type']]\n",
"#result DataFrame\n",
"#show unique Fluid Types\n",
"unique(result['Fluid Type'])"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 3,
"text": [
"array([u'W', u'A', u'F', nan, u'UNKNOWN', u'FLUD', u'X-LINKGEL', u'U',\n",
" u'FRAC', u'GEL', u'O', u'SLKW', u'G', u'KCL', u'SDFR', u'BDA',\n",
" u'TRET', u'WTR', u'NTGN', u'CO2', u'DOIL', u'SFAC', u'OIL', u'BKDN',\n",
" u'WFR', u'SW', u'SWNF', u'LSECR', u'BXGF', u'KERO', u'MA', u'FFR',\n",
" u'ACID', u'AGFR', u'NAF', u'HEAT'], dtype=object)"
]
}
],
"prompt_number": 3
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"from pandas import notnull\n",
"#Exclude Fluid Types that are not Water(~ is the NOT operator)\n",
"result_a = result[~result['Fluid Type'].isin(['NTGN','A','ACID','O','FFR','F','DOIL','OIL','CO2','G','MA','NAF','HEAT','KERO','BDA'])]\n",
"#remove NA values from Fluid Amount\n",
"result_a = result_a[notnull(result_a['Fluid Amount (gals)'])]\n",
"grouped = result_a.groupby([result_a['Date Completion'].map(lambda x: x.year)])\n",
"gby_DC_results=grouped['Fluid Amount (gals)'].agg(['sum','min','mean','max','size'])\n",
"#export to csv\n",
"#gby_DC_results.to_csv('/Users/mstacy/Desktop/ows-data/result_water_usage_groupbyYear.csv')\n",
"\n",
"#display gby_DC_results\n",
"gby_DC_results"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>sum</th>\n",
" <th>min</th>\n",
" <th>mean</th>\n",
" <th>max</th>\n",
" <th>size</th>\n",
" </tr>\n",
" <tr>\n",
" <th>Date Completion</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>1995</th>\n",
" <td> 1.270753e+08</td>\n",
" <td> 150.0</td>\n",
" <td> 104588.753909</td>\n",
" <td> 3276000</td>\n",
" <td> 1215</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1996</th>\n",
" <td> 1.523904e+08</td>\n",
" <td> 160.0</td>\n",
" <td> 104879.807295</td>\n",
" <td> 1403640</td>\n",
" <td> 1453</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1997</th>\n",
" <td> 2.193133e+08</td>\n",
" <td> 55.0</td>\n",
" <td> 116780.257721</td>\n",
" <td> 12805590</td>\n",
" <td> 1878</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1998</th>\n",
" <td> 1.419544e+08</td>\n",
" <td> 30.0</td>\n",
" <td> 87249.180701</td>\n",
" <td> 1680000</td>\n",
" <td> 1627</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1999</th>\n",
" <td> 8.224232e+07</td>\n",
" <td> 40.0</td>\n",
" <td> 67191.434641</td>\n",
" <td> 3024000</td>\n",
" <td> 1224</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000</th>\n",
" <td> 1.185931e+08</td>\n",
" <td> 24.0</td>\n",
" <td> 71141.660348</td>\n",
" <td> 8820000</td>\n",
" <td> 1667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2001</th>\n",
" <td> 2.035299e+08</td>\n",
" <td> 84.0</td>\n",
" <td> 86793.126397</td>\n",
" <td> 6105204</td>\n",
" <td> 2345</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2002</th>\n",
" <td> 1.911518e+08</td>\n",
" <td> 84.0</td>\n",
" <td> 99454.641207</td>\n",
" <td> 27009360</td>\n",
" <td> 1922</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2003</th>\n",
" <td> 1.560937e+08</td>\n",
" <td> 151.0</td>\n",
" <td> 68432.147830</td>\n",
" <td> 10102890</td>\n",
" <td> 2281</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2004</th>\n",
" <td> 2.760850e+08</td>\n",
" <td> 30.0</td>\n",
" <td> 99418.450629</td>\n",
" <td> 5628000</td>\n",
" <td> 2777</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2005</th>\n",
" <td> 7.318773e+08</td>\n",
" <td> 20.0</td>\n",
" <td> 218732.001195</td>\n",
" <td> 331061632</td>\n",
" <td> 3346</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2006</th>\n",
" <td> 7.401208e+08</td>\n",
" <td> 40.0</td>\n",
" <td> 191641.834697</td>\n",
" <td> 33734736</td>\n",
" <td> 3862</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2007</th>\n",
" <td> 1.231681e+09</td>\n",
" <td> 1.5</td>\n",
" <td> 296433.492106</td>\n",
" <td> 25228854</td>\n",
" <td> 4155</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2008</th>\n",
" <td> 2.568564e+09</td>\n",
" <td> 1.0</td>\n",
" <td> 459000.033525</td>\n",
" <td> 355529984</td>\n",
" <td> 5596</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2009</th>\n",
" <td> 1.825202e+09</td>\n",
" <td> 75.0</td>\n",
" <td> 556973.417390</td>\n",
" <td> 19571580</td>\n",
" <td> 3277</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2010</th>\n",
" <td> 2.881151e+09</td>\n",
" <td> 20.0</td>\n",
" <td> 839740.970446</td>\n",
" <td> 48271356</td>\n",
" <td> 3431</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2011</th>\n",
" <td> 4.445530e+09</td>\n",
" <td> 42.0</td>\n",
" <td> 1384037.846085</td>\n",
" <td> 33774512</td>\n",
" <td> 3212</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2012</th>\n",
" <td> 5.781322e+09</td>\n",
" <td> 42.0</td>\n",
" <td> 1616248.923399</td>\n",
" <td> 33039972</td>\n",
" <td> 3577</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2013</th>\n",
" <td> 7.181052e+09</td>\n",
" <td> 55.0</td>\n",
" <td> 2037177.996596</td>\n",
" <td> 37504112</td>\n",
" <td> 3525</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014</th>\n",
" <td> 5.222809e+09</td>\n",
" <td> 27.0</td>\n",
" <td> 2557692.820274</td>\n",
" <td> 22620108</td>\n",
" <td> 2042</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 4,
"text": [
" sum min mean max size\n",
"Date Completion \n",
"1995 1.270753e+08 150.0 104588.753909 3276000 1215\n",
"1996 1.523904e+08 160.0 104879.807295 1403640 1453\n",
"1997 2.193133e+08 55.0 116780.257721 12805590 1878\n",
"1998 1.419544e+08 30.0 87249.180701 1680000 1627\n",
"1999 8.224232e+07 40.0 67191.434641 3024000 1224\n",
"2000 1.185931e+08 24.0 71141.660348 8820000 1667\n",
"2001 2.035299e+08 84.0 86793.126397 6105204 2345\n",
"2002 1.911518e+08 84.0 99454.641207 27009360 1922\n",
"2003 1.560937e+08 151.0 68432.147830 10102890 2281\n",
"2004 2.760850e+08 30.0 99418.450629 5628000 2777\n",
"2005 7.318773e+08 20.0 218732.001195 331061632 3346\n",
"2006 7.401208e+08 40.0 191641.834697 33734736 3862\n",
"2007 1.231681e+09 1.5 296433.492106 25228854 4155\n",
"2008 2.568564e+09 1.0 459000.033525 355529984 5596\n",
"2009 1.825202e+09 75.0 556973.417390 19571580 3277\n",
"2010 2.881151e+09 20.0 839740.970446 48271356 3431\n",
"2011 4.445530e+09 42.0 1384037.846085 33774512 3212\n",
"2012 5.781322e+09 42.0 1616248.923399 33039972 3577\n",
"2013 7.181052e+09 55.0 2037177.996596 37504112 3525\n",
"2014 5.222809e+09 27.0 2557692.820274 22620108 2042"
]
}
],
"prompt_number": 4
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"#Group by Date Completion and Fluid Type\n",
"grouped = result_a.groupby([result_a['Date Completion'].map(lambda x: x.year),result_a['Fluid Type']])\n",
"gby_DC_FT_results=grouped['Fluid Amount (gals)'].agg(['sum','min','mean','max','size'])\n",
"#Export to CSV\n",
"#gby_DC_FT_results.to_csv('/Users/mstacy/Desktop/ows-data/result_water_usage_groupbyYearFluidType.csv')\n",
"\n",
"#Display gby_DC-FT_results\n",
"gby_DC_FT_results"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th></th>\n",
" <th>sum</th>\n",
" <th>min</th>\n",
" <th>mean</th>\n",
" <th>max</th>\n",
" <th>size</th>\n",
" </tr>\n",
" <tr>\n",
" <th>Date Completion</th>\n",
" <th>Fluid Type</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th rowspan=\"7\" valign=\"top\">1995</th>\n",
" <th>FLUD</th>\n",
" <td> 3.487490e+05</td>\n",
" <td> 1500.0</td>\n",
" <td> 58124.833333</td>\n",
" <td> 183456</td>\n",
" <td> 6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRAC</th>\n",
" <td> 3.503730e+05</td>\n",
" <td> 5000.0</td>\n",
" <td> 38930.333333</td>\n",
" <td> 92273</td>\n",
" <td> 9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEL</th>\n",
" <td> 4.993640e+05</td>\n",
" <td> 15000.0</td>\n",
" <td> 49936.400000</td>\n",
" <td> 106210</td>\n",
" <td> 10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SLKW</th>\n",
" <td> 2.100000e+04</td>\n",
" <td> 21000.0</td>\n",
" <td> 21000.000000</td>\n",
" <td> 21000</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>U</th>\n",
" <td> 2.738260e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 16107.411765</td>\n",
" <td> 40000</td>\n",
" <td> 17</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNKNOWN</th>\n",
" <td> 5.302078e+07</td>\n",
" <td> 200.0</td>\n",
" <td> 116273.644737</td>\n",
" <td> 877498</td>\n",
" <td> 456</td>\n",
" </tr>\n",
" <tr>\n",
" <th>W</th>\n",
" <td> 7.256124e+07</td>\n",
" <td> 150.0</td>\n",
" <td> 101342.516760</td>\n",
" <td> 3276000</td>\n",
" <td> 716</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"6\" valign=\"top\">1996</th>\n",
" <th>FLUD</th>\n",
" <td> 4.355400e+04</td>\n",
" <td> 43554.0</td>\n",
" <td> 43554.000000</td>\n",
" <td> 43554</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRAC</th>\n",
" <td> 4.833340e+05</td>\n",
" <td> 5000.0</td>\n",
" <td> 34523.857143</td>\n",
" <td> 84000</td>\n",
" <td> 14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEL</th>\n",
" <td> 4.520410e+05</td>\n",
" <td> 307.0</td>\n",
" <td> 37670.083333</td>\n",
" <td> 129948</td>\n",
" <td> 12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>U</th>\n",
" <td> 6.946300e+05</td>\n",
" <td> 1008.0</td>\n",
" <td> 46308.666667</td>\n",
" <td> 136000</td>\n",
" <td> 15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNKNOWN</th>\n",
" <td> 6.998315e+07</td>\n",
" <td> 200.0</td>\n",
" <td> 119834.154110</td>\n",
" <td> 1403640</td>\n",
" <td> 584</td>\n",
" </tr>\n",
" <tr>\n",
" <th>W</th>\n",
" <td> 8.073366e+07</td>\n",
" <td> 160.0</td>\n",
" <td> 97622.315599</td>\n",
" <td> 924000</td>\n",
" <td> 827</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"7\" valign=\"top\">1997</th>\n",
" <th>FLUD</th>\n",
" <td> 1.009280e+05</td>\n",
" <td> 5208.0</td>\n",
" <td> 16821.333333</td>\n",
" <td> 25000</td>\n",
" <td> 6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRAC</th>\n",
" <td> 1.068038e+06</td>\n",
" <td> 500.0</td>\n",
" <td> 34452.838710</td>\n",
" <td> 126000</td>\n",
" <td> 31</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEL</th>\n",
" <td> 3.769580e+05</td>\n",
" <td> 6000.0</td>\n",
" <td> 75391.600000</td>\n",
" <td> 219600</td>\n",
" <td> 5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>U</th>\n",
" <td> 5.981720e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 22154.518519</td>\n",
" <td> 142800</td>\n",
" <td> 27</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNKNOWN</th>\n",
" <td> 9.600185e+07</td>\n",
" <td> 55.0</td>\n",
" <td> 122139.759542</td>\n",
" <td> 12805590</td>\n",
" <td> 786</td>\n",
" </tr>\n",
" <tr>\n",
" <th>W</th>\n",
" <td> 1.211178e+08</td>\n",
" <td> 200.0</td>\n",
" <td> 118626.682664</td>\n",
" <td> 5040000</td>\n",
" <td> 1021</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WTR</th>\n",
" <td> 4.953400e+04</td>\n",
" <td> 15100.0</td>\n",
" <td> 24767.000000</td>\n",
" <td> 34434</td>\n",
" <td> 2</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"6\" valign=\"top\">1998</th>\n",
" <th>FLUD</th>\n",
" <td> 2.122800e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 30325.714286</td>\n",
" <td> 121380</td>\n",
" <td> 7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRAC</th>\n",
" <td> 6.703640e+05</td>\n",
" <td> 30.0</td>\n",
" <td> 18117.945946</td>\n",
" <td> 129150</td>\n",
" <td> 37</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEL</th>\n",
" <td> 1.359360e+05</td>\n",
" <td> 4800.0</td>\n",
" <td> 33984.000000</td>\n",
" <td> 67140</td>\n",
" <td> 4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>U</th>\n",
" <td> 6.093590e+05</td>\n",
" <td> 966.0</td>\n",
" <td> 19042.468750</td>\n",
" <td> 81947</td>\n",
" <td> 32</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNKNOWN</th>\n",
" <td> 3.294443e+07</td>\n",
" <td> 110.0</td>\n",
" <td> 50683.741538</td>\n",
" <td> 1680000</td>\n",
" <td> 650</td>\n",
" </tr>\n",
" <tr>\n",
" <th>W</th>\n",
" <td> 1.073820e+08</td>\n",
" <td> 150.0</td>\n",
" <td> 119712.425864</td>\n",
" <td> 874608</td>\n",
" <td> 897</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"9\" valign=\"top\">1999</th>\n",
" <th>FLUD</th>\n",
" <td> 3.678700e+05</td>\n",
" <td> 6510.0</td>\n",
" <td> 33442.727273</td>\n",
" <td> 90000</td>\n",
" <td> 11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRAC</th>\n",
" <td> 9.490083e+06</td>\n",
" <td> 100.0</td>\n",
" <td> 79748.596639</td>\n",
" <td> 3024000</td>\n",
" <td> 119</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEL</th>\n",
" <td> 1.998031e+06</td>\n",
" <td> 40.0</td>\n",
" <td> 37000.574074</td>\n",
" <td> 101430</td>\n",
" <td> 54</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TRET</th>\n",
" <td> 2.218400e+04</td>\n",
" <td> 1000.0</td>\n",
" <td> 2464.888889</td>\n",
" <td> 5500</td>\n",
" <td> 9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>U</th>\n",
" <td> 4.160132e+06</td>\n",
" <td> 756.0</td>\n",
" <td> 77039.481481</td>\n",
" <td> 422898</td>\n",
" <td> 54</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNKNOWN</th>\n",
" <td> 1.939058e+07</td>\n",
" <td> 420.0</td>\n",
" <td> 55243.826211</td>\n",
" <td> 760200</td>\n",
" <td> 351</td>\n",
" </tr>\n",
" <tr>\n",
" <th>W</th>\n",
" <td> 4.674627e+07</td>\n",
" <td> 210.0</td>\n",
" <td> 74913.891026</td>\n",
" <td> 1932000</td>\n",
" <td> 624</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WTR</th>\n",
" <td> 1.155000e+04</td>\n",
" <td> 11550.0</td>\n",
" <td> 11550.000000</td>\n",
" <td> 11550</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>X-LINKGEL</th>\n",
" <td> 5.561500e+04</td>\n",
" <td> 55615.0</td>\n",
" <td> 55615.000000</td>\n",
" <td> 55615</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"9\" valign=\"top\">2000</th>\n",
" <th>FLUD</th>\n",
" <td> 1.145014e+06</td>\n",
" <td> 6000.0</td>\n",
" <td> 63611.888889</td>\n",
" <td> 331800</td>\n",
" <td> 18</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRAC</th>\n",
" <td> 3.881451e+07</td>\n",
" <td> 24.0</td>\n",
" <td> 67503.501217</td>\n",
" <td> 1037400</td>\n",
" <td> 575</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEL</th>\n",
" <td> 9.794301e+06</td>\n",
" <td> 350.0</td>\n",
" <td> 35105.020072</td>\n",
" <td> 240324</td>\n",
" <td> 279</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KCL</th>\n",
" <td> 1.680000e+03</td>\n",
" <td> 1680.0</td>\n",
" <td> 1680.000000</td>\n",
" <td> 1680</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TRET</th>\n",
" <td> 3.349700e+04</td>\n",
" <td> 84.0</td>\n",
" <td> 1860.944444</td>\n",
" <td> 5040</td>\n",
" <td> 18</td>\n",
" </tr>\n",
" <tr>\n",
" <th>U</th>\n",
" <td> 5.315247e+06</td>\n",
" <td> 125.0</td>\n",
" <td> 34072.096154</td>\n",
" <td> 280500</td>\n",
" <td> 156</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UNKNOWN</th>\n",
" <td> 1.120000e+04</td>\n",
" <td> 2000.0</td>\n",
" <td> 3733.333333</td>\n",
" <td> 7200</td>\n",
" <td> 3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>W</th>\n",
" <td> 6.306781e+07</td>\n",
" <td> 36.0</td>\n",
" <td> 104763.808970</td>\n",
" <td> 8820000</td>\n",
" <td> 602</td>\n",
" </tr>\n",
" <tr>\n",
" <th>X-LINKGEL</th>\n",
" <td> 4.098830e+05</td>\n",
" <td> 2500.0</td>\n",
" <td> 27325.533333</td>\n",
" <td> 171653</td>\n",
" <td> 15</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"8\" valign=\"top\">2001</th>\n",
" <th>FLUD</th>\n",
" <td> 3.151343e+06</td>\n",
" <td> 504.0</td>\n",
" <td> 87537.305556</td>\n",
" <td> 1281000</td>\n",
" <td> 36</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRAC</th>\n",
" <td> 2.886896e+07</td>\n",
" <td> 400.0</td>\n",
" <td> 100588.707317</td>\n",
" <td> 5040000</td>\n",
" <td> 287</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEL</th>\n",
" <td> 2.422216e+07</td>\n",
" <td> 84.0</td>\n",
" <td> 61477.560914</td>\n",
" <td> 6105204</td>\n",
" <td> 394</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TRET</th>\n",
" <td> 2.031100e+05</td>\n",
" <td> 1008.0</td>\n",
" <td> 22567.777778</td>\n",
" <td> 100000</td>\n",
" <td> 9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>U</th>\n",
" <td> 4.228615e+07</td>\n",
" <td> 127.0</td>\n",
" <td> 67549.761022</td>\n",
" <td> 2280600</td>\n",
" <td> 626</td>\n",
" </tr>\n",
" <tr>\n",
" <th>W</th>\n",
" <td> 1.026910e+08</td>\n",
" <td> 160.0</td>\n",
" <td> 106195.406412</td>\n",
" <td> 3150000</td>\n",
" <td> 967</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WTR</th>\n",
" <td> 1.050000e+04</td>\n",
" <td> 10500.0</td>\n",
" <td> 10500.000000</td>\n",
" <td> 10500</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>X-LINKGEL</th>\n",
" <td> 2.058020e+06</td>\n",
" <td> 10500.0</td>\n",
" <td> 85750.833333</td>\n",
" <td> 864360</td>\n",
" <td> 24</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"9\" valign=\"top\">2002</th>\n",
" <th>FLUD</th>\n",
" <td> 1.630835e+06</td>\n",
" <td> 500.0</td>\n",
" <td> 49419.242424</td>\n",
" <td> 315000</td>\n",
" <td> 33</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRAC</th>\n",
" <td> 3.742290e+05</td>\n",
" <td> 1008.0</td>\n",
" <td> 46778.625000</td>\n",
" <td> 112000</td>\n",
" <td> 8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEL</th>\n",
" <td> 2.348814e+07</td>\n",
" <td> 84.0</td>\n",
" <td> 46882.518962</td>\n",
" <td> 676956</td>\n",
" <td> 501</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KCL</th>\n",
" <td> 2.940000e+03</td>\n",
" <td> 2940.0</td>\n",
" <td> 2940.000000</td>\n",
" <td> 2940</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TRET</th>\n",
" <td> 1.610840e+05</td>\n",
" <td> 630.0</td>\n",
" <td> 11506.000000</td>\n",
" <td> 108150</td>\n",
" <td> 14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>U</th>\n",
" <td> 3.023900e+07</td>\n",
" <td> 100.0</td>\n",
" <td> 67048.791574</td>\n",
" <td> 7602000</td>\n",
" <td> 451</td>\n",
" </tr>\n",
" <tr>\n",
" <th>W</th>\n",
" <td> 1.332589e+08</td>\n",
" <td> 126.0</td>\n",
" <td> 150916.069536</td>\n",
" <td> 27009360</td>\n",
" <td> 883</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WTR</th>\n",
" <td> 4.956000e+04</td>\n",
" <td> 19320.0</td>\n",
" <td> 24780.000000</td>\n",
" <td> 30240</td>\n",
" <td> 2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>X-LINKGEL</th>\n",
" <td> 1.947136e+06</td>\n",
" <td> 8274.0</td>\n",
" <td> 67142.620690</td>\n",
" <td> 211000</td>\n",
" <td> 29</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"10\" valign=\"top\">2003</th>\n",
" <th>BKDN</th>\n",
" <td> 7.546000e+03</td>\n",
" <td> 7546.0</td>\n",
" <td> 7546.000000</td>\n",
" <td> 7546</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FLUD</th>\n",
" <td> 4.620671e+06</td>\n",
" <td> 1092.0</td>\n",
" <td> 47149.704082</td>\n",
" <td> 294000</td>\n",
" <td> 98</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRAC</th>\n",
" <td> 4.241420e+05</td>\n",
" <td> 3150.0</td>\n",
" <td> 38558.363636</td>\n",
" <td> 112560</td>\n",
" <td> 11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEL</th>\n",
" <td> 2.947672e+07</td>\n",
" <td> 445.0</td>\n",
" <td> 51622.968476</td>\n",
" <td> 924000</td>\n",
" <td> 571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TRET</th>\n",
" <td> 8.436080e+05</td>\n",
" <td> 600.0</td>\n",
" <td> 30128.857143</td>\n",
" <td> 129100</td>\n",
" <td> 28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>U</th>\n",
" <td> 3.849341e+07</td>\n",
" <td> 405.0</td>\n",
" <td> 65913.368151</td>\n",
" <td> 638400</td>\n",
" <td> 584</td>\n",
" </tr>\n",
" <tr>\n",
" <th>W</th>\n",
" <td> 6.906103e+07</td>\n",
" <td> 151.0</td>\n",
" <td> 83913.771810</td>\n",
" <td> 10102890</td>\n",
" <td> 823</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WFR</th>\n",
" <td> 4.830000e+04</td>\n",
" <td> 48300.0</td>\n",
" <td> 48300.000000</td>\n",
" <td> 48300</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WTR</th>\n",
" <td> 1.118884e+07</td>\n",
" <td> 1000.0</td>\n",
" <td> 86735.201550</td>\n",
" <td> 500000</td>\n",
" <td> 129</td>\n",
" </tr>\n",
" <tr>\n",
" <th>X-LINKGEL</th>\n",
" <td> 1.929465e+06</td>\n",
" <td> 16300.0</td>\n",
" <td> 55127.571429</td>\n",
" <td> 221000</td>\n",
" <td> 35</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"10\" valign=\"top\">2004</th>\n",
" <th>BKDN</th>\n",
" <td> 1.932000e+03</td>\n",
" <td> 1932.0</td>\n",
" <td> 1932.000000</td>\n",
" <td> 1932</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FLUD</th>\n",
" <td> 7.343999e+07</td>\n",
" <td> 30.0</td>\n",
" <td> 90554.860666</td>\n",
" <td> 2733108</td>\n",
" <td> 811</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRAC</th>\n",
" <td> 2.213820e+05</td>\n",
" <td> 10206.0</td>\n",
" <td> 110691.000000</td>\n",
" <td> 211176</td>\n",
" <td> 2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEL</th>\n",
" <td> 3.658643e+07</td>\n",
" <td> 150.0</td>\n",
" <td> 55100.041563</td>\n",
" <td> 369955</td>\n",
" <td> 664</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SLKW</th>\n",
" <td> 4.110120e+05</td>\n",
" <td> 411012.0</td>\n",
" <td> 411012.000000</td>\n",
" <td> 411012</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TRET</th>\n",
" <td> 1.000000e+03</td>\n",
" <td> 1000.0</td>\n",
" <td> 1000.000000</td>\n",
" <td> 1000</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>U</th>\n",
" <td> 6.706982e+06</td>\n",
" <td> 798.0</td>\n",
" <td> 89426.426667</td>\n",
" <td> 793212</td>\n",
" <td> 75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>W</th>\n",
" <td> 1.474309e+08</td>\n",
" <td> 84.0</td>\n",
" <td> 136510.082778</td>\n",
" <td> 5628000</td>\n",
" <td> 1080</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WTR</th>\n",
" <td> 4.433477e+06</td>\n",
" <td> 1260.0</td>\n",
" <td> 143015.387097</td>\n",
" <td> 463806</td>\n",
" <td> 31</td>\n",
" </tr>\n",
" <tr>\n",
" <th>X-LINKGEL</th>\n",
" <td> 6.851943e+06</td>\n",
" <td> 994.0</td>\n",
" <td> 61729.219806</td>\n",
" <td> 224000</td>\n",
" <td> 111</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"8\" valign=\"top\">2005</th>\n",
" <th>FLUD</th>\n",
" <td> 1.492963e+08</td>\n",
" <td> 20.0</td>\n",
" <td> 115643.939582</td>\n",
" <td> 7591500</td>\n",
" <td> 1291</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRAC</th>\n",
" <td> 4.900000e+03</td>\n",
" <td> 4900.0</td>\n",
" <td> 4900.000000</td>\n",
" <td> 4900</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEL</th>\n",
" <td> 3.026943e+07</td>\n",
" <td> 196.0</td>\n",
" <td> 61648.527495</td>\n",
" <td> 757400</td>\n",
" <td> 491</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KCL</th>\n",
" <td> 8.400000e+05</td>\n",
" <td> 840000.0</td>\n",
" <td> 840000.000000</td>\n",
" <td> 840000</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SLKW</th>\n",
" <td> 4.719650e+05</td>\n",
" <td> 119280.0</td>\n",
" <td> 157321.666667</td>\n",
" <td> 181685</td>\n",
" <td> 3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>U</th>\n",
" <td> 1.755600e+05</td>\n",
" <td> 175560.0</td>\n",
" <td> 175560.000000</td>\n",
" <td> 175560</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>W</th>\n",
" <td> 5.333362e+08</td>\n",
" <td> 80.0</td>\n",
" <td> 399203.723802</td>\n",
" <td> 331061632</td>\n",
" <td> 1336</td>\n",
" </tr>\n",
" <tr>\n",
" <th>X-LINKGEL</th>\n",
" <td> 1.748292e+07</td>\n",
" <td> 1500.0</td>\n",
" <td> 78751.905405</td>\n",
" <td> 840000</td>\n",
" <td> 222</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"10\" valign=\"top\">2006</th>\n",
" <th>BKDN</th>\n",
" <td> 5.195400e+04</td>\n",
" <td> 51954.0</td>\n",
" <td> 51954.000000</td>\n",
" <td> 51954</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FLUD</th>\n",
" <td> 2.000219e+08</td>\n",
" <td> 40.0</td>\n",
" <td> 147508.750738</td>\n",
" <td> 5925276</td>\n",
" <td> 1356</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRAC</th>\n",
" <td> 1.134038e+06</td>\n",
" <td> 19110.0</td>\n",
" <td> 126004.222222</td>\n",
" <td> 420000</td>\n",
" <td> 9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEL</th>\n",
" <td> 3.263430e+07</td>\n",
" <td> 130.0</td>\n",
" <td> 66464.977597</td>\n",
" <td> 3000018</td>\n",
" <td> 491</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KCL</th>\n",
" <td> 4.231000e+04</td>\n",
" <td> 2310.0</td>\n",
" <td> 21155.000000</td>\n",
" <td> 40000</td>\n",
" <td> 2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SLKW</th>\n",
" <td> 7.986840e+05</td>\n",
" <td> 109800.0</td>\n",
" <td> 199671.000000</td>\n",
" <td> 336000</td>\n",
" <td> 4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TRET</th>\n",
" <td> 8.694000e+03</td>\n",
" <td> 8694.0</td>\n",
" <td> 8694.000000</td>\n",
" <td> 8694</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>W</th>\n",
" <td> 4.862144e+08</td>\n",
" <td> 230.0</td>\n",
" <td> 273307.715683</td>\n",
" <td> 33734736</td>\n",
" <td> 1779</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WTR</th>\n",
" <td> 5.791800e+04</td>\n",
" <td> 57918.0</td>\n",
" <td> 57918.000000</td>\n",
" <td> 57918</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>X-LINKGEL</th>\n",
" <td> 1.915657e+07</td>\n",
" <td> 504.0</td>\n",
" <td> 87874.180736</td>\n",
" <td> 3242232</td>\n",
" <td> 218</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"9\" valign=\"top\">2007</th>\n",
" <th>BKDN</th>\n",
" <td> 1.995000e+04</td>\n",
" <td> 19950.0</td>\n",
" <td> 19950.000000</td>\n",
" <td> 19950</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FLUD</th>\n",
" <td> 5.566146e+08</td>\n",
" <td> 1.5</td>\n",
" <td> 358181.851416</td>\n",
" <td> 25228854</td>\n",
" <td> 1554</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRAC</th>\n",
" <td> 5.053440e+05</td>\n",
" <td> 44100.0</td>\n",
" <td> 126336.000000</td>\n",
" <td> 209244</td>\n",
" <td> 4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEL</th>\n",
" <td> 2.238966e+07</td>\n",
" <td> 560.0</td>\n",
" <td> 60025.907240</td>\n",
" <td> 838950</td>\n",
" <td> 373</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KCL</th>\n",
" <td> 1.060697e+06</td>\n",
" <td> 5.0</td>\n",
" <td> 58927.611111</td>\n",
" <td> 401520</td>\n",
" <td> 18</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SLKW</th>\n",
" <td> 2.429842e+06</td>\n",
" <td> 4116.0</td>\n",
" <td> 173560.142857</td>\n",
" <td> 399000</td>\n",
" <td> 14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>W</th>\n",
" <td> 6.229383e+08</td>\n",
" <td> 84.0</td>\n",
" <td> 308232.722811</td>\n",
" <td> 18427164</td>\n",
" <td> 2021</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WTR</th>\n",
" <td> 1.800000e+03</td>\n",
" <td> 1800.0</td>\n",
" <td> 1800.000000</td>\n",
" <td> 1800</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>X-LINKGEL</th>\n",
" <td> 2.572093e+07</td>\n",
" <td> 2000.0</td>\n",
" <td> 152194.872189</td>\n",
" <td> 12565392</td>\n",
" <td> 169</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"12\" valign=\"top\">2008</th>\n",
" <th>AGFR</th>\n",
" <td> 2.200000e+04</td>\n",
" <td> 22000.0</td>\n",
" <td> 22000.000000</td>\n",
" <td> 22000</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BXGF</th>\n",
" <td> 1.050000e+04</td>\n",
" <td> 10500.0</td>\n",
" <td> 10500.000000</td>\n",
" <td> 10500</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FLUD</th>\n",
" <td> 9.660173e+08</td>\n",
" <td> 1.0</td>\n",
" <td> 436716.684539</td>\n",
" <td> 35112000</td>\n",
" <td> 2212</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRAC</th>\n",
" <td> 1.532940e+05</td>\n",
" <td> 420.0</td>\n",
" <td> 13935.818182</td>\n",
" <td> 52458</td>\n",
" <td> 11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEL</th>\n",
" <td> 2.874640e+07</td>\n",
" <td> 275.0</td>\n",
" <td> 69942.583457</td>\n",
" <td> 3158820</td>\n",
" <td> 411</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KCL</th>\n",
" <td> 1.440808e+06</td>\n",
" <td> 336.0</td>\n",
" <td> 24841.517241</td>\n",
" <td> 538398</td>\n",
" <td> 58</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SFAC</th>\n",
" <td> 3.318000e+03</td>\n",
" <td> 1554.0</td>\n",
" <td> 1659.000000</td>\n",
" <td> 1764</td>\n",
" <td> 2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SLKW</th>\n",
" <td> 4.233778e+06</td>\n",
" <td> 630.0</td>\n",
" <td> 176407.416667</td>\n",
" <td> 663894</td>\n",
" <td> 24</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SW</th>\n",
" <td> 2.976120e+05</td>\n",
" <td> 25452.0</td>\n",
" <td> 148806.000000</td>\n",
" <td> 272160</td>\n",
" <td> 2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TRET</th>\n",
" <td> 1.393200e+04</td>\n",
" <td> 1500.0</td>\n",
" <td> 6966.000000</td>\n",
" <td> 12432</td>\n",
" <td> 2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>W</th>\n",
" <td> 1.550409e+09</td>\n",
" <td> 153.0</td>\n",
" <td> 583738.464082</td>\n",
" <td> 355529984</td>\n",
" <td> 2656</td>\n",
" </tr>\n",
" <tr>\n",
" <th>X-LINKGEL</th>\n",
" <td> 1.721588e+07</td>\n",
" <td> 37.0</td>\n",
" <td> 79703.134259</td>\n",
" <td> 402000</td>\n",
" <td> 216</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"8\" valign=\"top\">2009</th>\n",
" <th>FLUD</th>\n",
" <td> 8.038420e+08</td>\n",
" <td> 75.0</td>\n",
" <td> 543871.462653</td>\n",
" <td> 11442396</td>\n",
" <td> 1478</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRAC</th>\n",
" <td> 7.589174e+06</td>\n",
" <td> 5880.0</td>\n",
" <td> 361389.238095</td>\n",
" <td> 521030</td>\n",
" <td> 21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEL</th>\n",
" <td> 1.441026e+07</td>\n",
" <td> 200.0</td>\n",
" <td> 80956.516854</td>\n",
" <td> 3056844</td>\n",
" <td> 178</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KCL</th>\n",
" <td> 6.010200e+05</td>\n",
" <td> 378.0</td>\n",
" <td> 27319.090909</td>\n",
" <td> 295050</td>\n",
" <td> 22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SFAC</th>\n",
" <td> 5.100000e+05</td>\n",
" <td> 6000.0</td>\n",
" <td> 255000.000000</td>\n",
" <td> 504000</td>\n",
" <td> 2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SLKW</th>\n",
" <td> 2.028963e+08</td>\n",
" <td> 3045.0</td>\n",
" <td> 1029930.650698</td>\n",
" <td> 19399380</td>\n",
" <td> 197</td>\n",
" </tr>\n",
" <tr>\n",
" <th>W</th>\n",
" <td> 7.852558e+08</td>\n",
" <td> 189.0</td>\n",
" <td> 622231.214580</td>\n",
" <td> 19571580</td>\n",
" <td> 1262</td>\n",
" </tr>\n",
" <tr>\n",
" <th>X-LINKGEL</th>\n",
" <td> 1.009728e+07</td>\n",
" <td> 710.0</td>\n",
" <td> 86301.555556</td>\n",
" <td> 1017072</td>\n",
" <td> 117</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"8\" valign=\"top\">2010</th>\n",
" <th>FLUD</th>\n",
" <td> 1.489263e+09</td>\n",
" <td> 20.0</td>\n",
" <td> 920434.291718</td>\n",
" <td> 48271356</td>\n",
" <td> 1618</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRAC</th>\n",
" <td> 1.387995e+07</td>\n",
" <td> 1000.0</td>\n",
" <td> 867497.125000</td>\n",
" <td> 6685140</td>\n",
" <td> 16</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEL</th>\n",
" <td> 1.300193e+07</td>\n",
" <td> 310.0</td>\n",
" <td> 86679.560000</td>\n",
" <td> 1846026</td>\n",
" <td> 150</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KCL</th>\n",
" <td> 1.883300e+04</td>\n",
" <td> 25.0</td>\n",
" <td> 3766.600000</td>\n",
" <td> 12600</td>\n",
" <td> 5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SLKW</th>\n",
" <td> 9.669248e+08</td>\n",
" <td> 842.0</td>\n",
" <td> 1210168.705882</td>\n",
" <td> 12705000</td>\n",
" <td> 799</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SWNF</th>\n",
" <td> 4.910220e+05</td>\n",
" <td> 491022.0</td>\n",
" <td> 491022.000000</td>\n",
" <td> 491022</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>W</th>\n",
" <td> 3.893127e+08</td>\n",
" <td> 168.0</td>\n",
" <td> 513605.117944</td>\n",
" <td> 10147200</td>\n",
" <td> 758</td>\n",
" </tr>\n",
" <tr>\n",
" <th>X-LINKGEL</th>\n",
" <td> 8.259367e+06</td>\n",
" <td> 257.0</td>\n",
" <td> 98325.800002</td>\n",
" <td> 1545600</td>\n",
" <td> 84</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"9\" valign=\"top\">2011</th>\n",
" <th>FLUD</th>\n",
" <td> 1.389501e+09</td>\n",
" <td> 42.0</td>\n",
" <td> 1413530.619151</td>\n",
" <td> 13427148</td>\n",
" <td> 983</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRAC</th>\n",
" <td> 1.373936e+07</td>\n",
" <td> 55000.0</td>\n",
" <td> 915957.066667</td>\n",
" <td> 7613970</td>\n",
" <td> 15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEL</th>\n",
" <td> 1.288587e+08</td>\n",
" <td> 126.0</td>\n",
" <td> 560255.295652</td>\n",
" <td> 8332800</td>\n",
" <td> 230</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KCL</th>\n",
" <td> 9.143820e+05</td>\n",
" <td> 756.0</td>\n",
" <td> 76198.500000</td>\n",
" <td> 487368</td>\n",
" <td> 12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SFAC</th>\n",
" <td> 5.619306e+06</td>\n",
" <td> 276528.0</td>\n",
" <td> 2809653.000000</td>\n",
" <td> 5342778</td>\n",
" <td> 2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SLKW</th>\n",
" <td> 1.910694e+09</td>\n",
" <td> 1554.0</td>\n",
" <td> 2367650.296159</td>\n",
" <td> 33774512</td>\n",
" <td> 807</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SW</th>\n",
" <td> 1.575840e+05</td>\n",
" <td> 157584.0</td>\n",
" <td> 157584.000000</td>\n",
" <td> 157584</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>W</th>\n",
" <td> 9.045016e+08</td>\n",
" <td> 168.0</td>\n",
" <td> 899106.926441</td>\n",
" <td> 20547618</td>\n",
" <td> 1006</td>\n",
" </tr>\n",
" <tr>\n",
" <th>X-LINKGEL</th>\n",
" <td> 9.154426e+07</td>\n",
" <td> 4350.0</td>\n",
" <td> 586822.179487</td>\n",
" <td> 4346202</td>\n",
" <td> 156</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"9\" valign=\"top\">2012</th>\n",
" <th>FLUD</th>\n",
" <td> 1.669113e+09</td>\n",
" <td> 84.0</td>\n",
" <td> 1753269.808824</td>\n",
" <td> 33039972</td>\n",
" <td> 952</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRAC</th>\n",
" <td> 1.223948e+06</td>\n",
" <td> 21630.0</td>\n",
" <td> 305987.000000</td>\n",
" <td> 986000</td>\n",
" <td> 4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEL</th>\n",
" <td> 8.399959e+08</td>\n",
" <td> 200.0</td>\n",
" <td> 2288817.092643</td>\n",
" <td> 15152886</td>\n",
" <td> 367</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KCL</th>\n",
" <td> 2.320330e+06</td>\n",
" <td> 546.0</td>\n",
" <td> 77344.333333</td>\n",
" <td> 1471008</td>\n",
" <td> 30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SLKW</th>\n",
" <td> 1.995234e+09</td>\n",
" <td> 670.0</td>\n",
" <td> 2131659.881410</td>\n",
" <td> 31526712</td>\n",
" <td> 936</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SW</th>\n",
" <td> 2.043905e+07</td>\n",
" <td> 2520.0</td>\n",
" <td> 2919864.000000</td>\n",
" <td> 7460502</td>\n",
" <td> 7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>W</th>\n",
" <td> 8.898180e+08</td>\n",
" <td> 42.0</td>\n",
" <td> 913570.854209</td>\n",
" <td> 16104144</td>\n",
" <td> 974</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WTR</th>\n",
" <td> 2.570820e+05</td>\n",
" <td> 10584.0</td>\n",
" <td> 85694.000000</td>\n",
" <td> 228816</td>\n",
" <td> 3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>X-LINKGEL</th>\n",
" <td> 3.629216e+08</td>\n",
" <td> 462.0</td>\n",
" <td> 1193821.049342</td>\n",
" <td> 27391854</td>\n",
" <td> 304</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"11\" valign=\"top\">2013</th>\n",
" <th>FLUD</th>\n",
" <td> 2.334093e+09</td>\n",
" <td> 250.0</td>\n",
" <td> 2208223.750237</td>\n",
" <td> 36871296</td>\n",
" <td> 1057</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRAC</th>\n",
" <td> 4.872000e+03</td>\n",
" <td> 4872.0</td>\n",
" <td> 4872.000000</td>\n",
" <td> 4872</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEL</th>\n",
" <td> 8.868148e+08</td>\n",
" <td> 55.0</td>\n",
" <td> 2147251.230024</td>\n",
" <td> 9131682</td>\n",
" <td> 413</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KCL</th>\n",
" <td> 1.049064e+06</td>\n",
" <td> 84.0</td>\n",
" <td> 23842.363636</td>\n",
" <td> 222060</td>\n",
" <td> 44</td>\n",
" </tr>\n",
" <tr>\n",
" <th>LSECR</th>\n",
" <td> 1.050000e+04</td>\n",
" <td> 10500.0</td>\n",
" <td> 10500.000000</td>\n",
" <td> 10500</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SLKW</th>\n",
" <td> 1.910579e+09</td>\n",
" <td> 1176.0</td>\n",
" <td> 2881718.177979</td>\n",
" <td> 37504112</td>\n",
" <td> 663</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SW</th>\n",
" <td> 1.302840e+05</td>\n",
" <td> 3360.0</td>\n",
" <td> 16285.500000</td>\n",
" <td> 33936</td>\n",
" <td> 8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TRET</th>\n",
" <td> 3.526000e+04</td>\n",
" <td> 1260.0</td>\n",
" <td> 17630.000000</td>\n",
" <td> 34000</td>\n",
" <td> 2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>W</th>\n",
" <td> 1.377589e+09</td>\n",
" <td> 126.0</td>\n",
" <td> 1638036.422117</td>\n",
" <td> 12844146</td>\n",
" <td> 841</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WTR</th>\n",
" <td> 2.738400e+04</td>\n",
" <td> 27384.0</td>\n",
" <td> 27384.000000</td>\n",
" <td> 27384</td>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>X-LINKGEL</th>\n",
" <td> 6.707200e+08</td>\n",
" <td> 2000.0</td>\n",
" <td> 1357732.852227</td>\n",
" <td> 18271428</td>\n",
" <td> 494</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"8\" valign=\"top\">2014</th>\n",
" <th>FLUD</th>\n",
" <td> 1.026885e+09</td>\n",
" <td> 27.0</td>\n",
" <td> 2066167.734406</td>\n",
" <td> 9999108</td>\n",
" <td> 497</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FRAC</th>\n",
" <td> 3.638250e+06</td>\n",
" <td> 38724.0</td>\n",
" <td> 1819125.000000</td>\n",
" <td> 3599526</td>\n",
" <td> 2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEL</th>\n",
" <td> 8.755910e+08</td>\n",
" <td> 60.0</td>\n",
" <td> 2473420.790960</td>\n",
" <td> 17423406</td>\n",
" <td> 354</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KCL</th>\n",
" <td> 4.519600e+05</td>\n",
" <td> 714.0</td>\n",
" <td> 18078.400000</td>\n",
" <td> 140238</td>\n",
" <td> 25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SLKW</th>\n",
" <td> 2.015093e+09</td>\n",
" <td> 3360.0</td>\n",
" <td> 3860330.720307</td>\n",
" <td> 22620108</td>\n",
" <td> 522</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SW</th>\n",
" <td> 7.736400e+05</td>\n",
" <td> 8400.0</td>\n",
" <td> 193410.000000</td>\n",
" <td> 569604</td>\n",
" <td> 4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>W</th>\n",
" <td> 1.010212e+09</td>\n",
" <td> 294.0</td>\n",
" <td> 2617129.202073</td>\n",
" <td> 18581052</td>\n",
" <td> 386</td>\n",
" </tr>\n",
" <tr>\n",
" <th>X-LINKGEL</th>\n",
" <td> 2.901641e+08</td>\n",
" <td> 4000.0</td>\n",
" <td> 1151444.670635</td>\n",
" <td> 14860818</td>\n",
" <td> 252</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 5,
"text": [
" sum min mean max \\\n",
"Date Completion Fluid Type \n",
"1995 FLUD 3.487490e+05 1500.0 58124.833333 183456 \n",
" FRAC 3.503730e+05 5000.0 38930.333333 92273 \n",
" GEL 4.993640e+05 15000.0 49936.400000 106210 \n",
" SLKW 2.100000e+04 21000.0 21000.000000 21000 \n",
" U 2.738260e+05 500.0 16107.411765 40000 \n",
" UNKNOWN 5.302078e+07 200.0 116273.644737 877498 \n",
" W 7.256124e+07 150.0 101342.516760 3276000 \n",
"1996 FLUD 4.355400e+04 43554.0 43554.000000 43554 \n",
" FRAC 4.833340e+05 5000.0 34523.857143 84000 \n",
" GEL 4.520410e+05 307.0 37670.083333 129948 \n",
" U 6.946300e+05 1008.0 46308.666667 136000 \n",
" UNKNOWN 6.998315e+07 200.0 119834.154110 1403640 \n",
" W 8.073366e+07 160.0 97622.315599 924000 \n",
"1997 FLUD 1.009280e+05 5208.0 16821.333333 25000 \n",
" FRAC 1.068038e+06 500.0 34452.838710 126000 \n",
" GEL 3.769580e+05 6000.0 75391.600000 219600 \n",
" U 5.981720e+05 500.0 22154.518519 142800 \n",
" UNKNOWN 9.600185e+07 55.0 122139.759542 12805590 \n",
" W 1.211178e+08 200.0 118626.682664 5040000 \n",
" WTR 4.953400e+04 15100.0 24767.000000 34434 \n",
"1998 FLUD 2.122800e+05 500.0 30325.714286 121380 \n",
" FRAC 6.703640e+05 30.0 18117.945946 129150 \n",
" GEL 1.359360e+05 4800.0 33984.000000 67140 \n",
" U 6.093590e+05 966.0 19042.468750 81947 \n",
" UNKNOWN 3.294443e+07 110.0 50683.741538 1680000 \n",
" W 1.073820e+08 150.0 119712.425864 874608 \n",
"1999 FLUD 3.678700e+05 6510.0 33442.727273 90000 \n",
" FRAC 9.490083e+06 100.0 79748.596639 3024000 \n",
" GEL 1.998031e+06 40.0 37000.574074 101430 \n",
" TRET 2.218400e+04 1000.0 2464.888889 5500 \n",
" U 4.160132e+06 756.0 77039.481481 422898 \n",
" UNKNOWN 1.939058e+07 420.0 55243.826211 760200 \n",
" W 4.674627e+07 210.0 74913.891026 1932000 \n",
" WTR 1.155000e+04 11550.0 11550.000000 11550 \n",
" X-LINKGEL 5.561500e+04 55615.0 55615.000000 55615 \n",
"2000 FLUD 1.145014e+06 6000.0 63611.888889 331800 \n",
" FRAC 3.881451e+07 24.0 67503.501217 1037400 \n",
" GEL 9.794301e+06 350.0 35105.020072 240324 \n",
" KCL 1.680000e+03 1680.0 1680.000000 1680 \n",
" TRET 3.349700e+04 84.0 1860.944444 5040 \n",
" U 5.315247e+06 125.0 34072.096154 280500 \n",
" UNKNOWN 1.120000e+04 2000.0 3733.333333 7200 \n",
" W 6.306781e+07 36.0 104763.808970 8820000 \n",
" X-LINKGEL 4.098830e+05 2500.0 27325.533333 171653 \n",
"2001 FLUD 3.151343e+06 504.0 87537.305556 1281000 \n",
" FRAC 2.886896e+07 400.0 100588.707317 5040000 \n",
" GEL 2.422216e+07 84.0 61477.560914 6105204 \n",
" TRET 2.031100e+05 1008.0 22567.777778 100000 \n",
" U 4.228615e+07 127.0 67549.761022 2280600 \n",
" W 1.026910e+08 160.0 106195.406412 3150000 \n",
" WTR 1.050000e+04 10500.0 10500.000000 10500 \n",
" X-LINKGEL 2.058020e+06 10500.0 85750.833333 864360 \n",
"2002 FLUD 1.630835e+06 500.0 49419.242424 315000 \n",
" FRAC 3.742290e+05 1008.0 46778.625000 112000 \n",
" GEL 2.348814e+07 84.0 46882.518962 676956 \n",
" KCL 2.940000e+03 2940.0 2940.000000 2940 \n",
" TRET 1.610840e+05 630.0 11506.000000 108150 \n",
" U 3.023900e+07 100.0 67048.791574 7602000 \n",
" W 1.332589e+08 126.0 150916.069536 27009360 \n",
" WTR 4.956000e+04 19320.0 24780.000000 30240 \n",
" X-LINKGEL 1.947136e+06 8274.0 67142.620690 211000 \n",
"2003 BKDN 7.546000e+03 7546.0 7546.000000 7546 \n",
" FLUD 4.620671e+06 1092.0 47149.704082 294000 \n",
" FRAC 4.241420e+05 3150.0 38558.363636 112560 \n",
" GEL 2.947672e+07 445.0 51622.968476 924000 \n",
" TRET 8.436080e+05 600.0 30128.857143 129100 \n",
" U 3.849341e+07 405.0 65913.368151 638400 \n",
" W 6.906103e+07 151.0 83913.771810 10102890 \n",
" WFR 4.830000e+04 48300.0 48300.000000 48300 \n",
" WTR 1.118884e+07 1000.0 86735.201550 500000 \n",
" X-LINKGEL 1.929465e+06 16300.0 55127.571429 221000 \n",
"2004 BKDN 1.932000e+03 1932.0 1932.000000 1932 \n",
" FLUD 7.343999e+07 30.0 90554.860666 2733108 \n",
" FRAC 2.213820e+05 10206.0 110691.000000 211176 \n",
" GEL 3.658643e+07 150.0 55100.041563 369955 \n",
" SLKW 4.110120e+05 411012.0 411012.000000 411012 \n",
" TRET 1.000000e+03 1000.0 1000.000000 1000 \n",
" U 6.706982e+06 798.0 89426.426667 793212 \n",
" W 1.474309e+08 84.0 136510.082778 5628000 \n",
" WTR 4.433477e+06 1260.0 143015.387097 463806 \n",
" X-LINKGEL 6.851943e+06 994.0 61729.219806 224000 \n",
"2005 FLUD 1.492963e+08 20.0 115643.939582 7591500 \n",
" FRAC 4.900000e+03 4900.0 4900.000000 4900 \n",
" GEL 3.026943e+07 196.0 61648.527495 757400 \n",
" KCL 8.400000e+05 840000.0 840000.000000 840000 \n",
" SLKW 4.719650e+05 119280.0 157321.666667 181685 \n",
" U 1.755600e+05 175560.0 175560.000000 175560 \n",
" W 5.333362e+08 80.0 399203.723802 331061632 \n",
" X-LINKGEL 1.748292e+07 1500.0 78751.905405 840000 \n",
"2006 BKDN 5.195400e+04 51954.0 51954.000000 51954 \n",
" FLUD 2.000219e+08 40.0 147508.750738 5925276 \n",
" FRAC 1.134038e+06 19110.0 126004.222222 420000 \n",
" GEL 3.263430e+07 130.0 66464.977597 3000018 \n",
" KCL 4.231000e+04 2310.0 21155.000000 40000 \n",
" SLKW 7.986840e+05 109800.0 199671.000000 336000 \n",
" TRET 8.694000e+03 8694.0 8694.000000 8694 \n",
" W 4.862144e+08 230.0 273307.715683 33734736 \n",
" WTR 5.791800e+04 57918.0 57918.000000 57918 \n",
" X-LINKGEL 1.915657e+07 504.0 87874.180736 3242232 \n",
"2007 BKDN 1.995000e+04 19950.0 19950.000000 19950 \n",
" FLUD 5.566146e+08 1.5 358181.851416 25228854 \n",
" FRAC 5.053440e+05 44100.0 126336.000000 209244 \n",
" GEL 2.238966e+07 560.0 60025.907240 838950 \n",
" KCL 1.060697e+06 5.0 58927.611111 401520 \n",
" SLKW 2.429842e+06 4116.0 173560.142857 399000 \n",
" W 6.229383e+08 84.0 308232.722811 18427164 \n",
" WTR 1.800000e+03 1800.0 1800.000000 1800 \n",
" X-LINKGEL 2.572093e+07 2000.0 152194.872189 12565392 \n",
"2008 AGFR 2.200000e+04 22000.0 22000.000000 22000 \n",
" BXGF 1.050000e+04 10500.0 10500.000000 10500 \n",
" FLUD 9.660173e+08 1.0 436716.684539 35112000 \n",
" FRAC 1.532940e+05 420.0 13935.818182 52458 \n",
" GEL 2.874640e+07 275.0 69942.583457 3158820 \n",
" KCL 1.440808e+06 336.0 24841.517241 538398 \n",
" SFAC 3.318000e+03 1554.0 1659.000000 1764 \n",
" SLKW 4.233778e+06 630.0 176407.416667 663894 \n",
" SW 2.976120e+05 25452.0 148806.000000 272160 \n",
" TRET 1.393200e+04 1500.0 6966.000000 12432 \n",
" W 1.550409e+09 153.0 583738.464082 355529984 \n",
" X-LINKGEL 1.721588e+07 37.0 79703.134259 402000 \n",
"2009 FLUD 8.038420e+08 75.0 543871.462653 11442396 \n",
" FRAC 7.589174e+06 5880.0 361389.238095 521030 \n",
" GEL 1.441026e+07 200.0 80956.516854 3056844 \n",
" KCL 6.010200e+05 378.0 27319.090909 295050 \n",
" SFAC 5.100000e+05 6000.0 255000.000000 504000 \n",
" SLKW 2.028963e+08 3045.0 1029930.650698 19399380 \n",
" W 7.852558e+08 189.0 622231.214580 19571580 \n",
" X-LINKGEL 1.009728e+07 710.0 86301.555556 1017072 \n",
"2010 FLUD 1.489263e+09 20.0 920434.291718 48271356 \n",
" FRAC 1.387995e+07 1000.0 867497.125000 6685140 \n",
" GEL 1.300193e+07 310.0 86679.560000 1846026 \n",
" KCL 1.883300e+04 25.0 3766.600000 12600 \n",
" SLKW 9.669248e+08 842.0 1210168.705882 12705000 \n",
" SWNF 4.910220e+05 491022.0 491022.000000 491022 \n",
" W 3.893127e+08 168.0 513605.117944 10147200 \n",
" X-LINKGEL 8.259367e+06 257.0 98325.800002 1545600 \n",
"2011 FLUD 1.389501e+09 42.0 1413530.619151 13427148 \n",
" FRAC 1.373936e+07 55000.0 915957.066667 7613970 \n",
" GEL 1.288587e+08 126.0 560255.295652 8332800 \n",
" KCL 9.143820e+05 756.0 76198.500000 487368 \n",
" SFAC 5.619306e+06 276528.0 2809653.000000 5342778 \n",
" SLKW 1.910694e+09 1554.0 2367650.296159 33774512 \n",
" SW 1.575840e+05 157584.0 157584.000000 157584 \n",
" W 9.045016e+08 168.0 899106.926441 20547618 \n",
" X-LINKGEL 9.154426e+07 4350.0 586822.179487 4346202 \n",
"2012 FLUD 1.669113e+09 84.0 1753269.808824 33039972 \n",
" FRAC 1.223948e+06 21630.0 305987.000000 986000 \n",
" GEL 8.399959e+08 200.0 2288817.092643 15152886 \n",
" KCL 2.320330e+06 546.0 77344.333333 1471008 \n",
" SLKW 1.995234e+09 670.0 2131659.881410 31526712 \n",
" SW 2.043905e+07 2520.0 2919864.000000 7460502 \n",
" W 8.898180e+08 42.0 913570.854209 16104144 \n",
" WTR 2.570820e+05 10584.0 85694.000000 228816 \n",
" X-LINKGEL 3.629216e+08 462.0 1193821.049342 27391854 \n",
"2013 FLUD 2.334093e+09 250.0 2208223.750237 36871296 \n",
" FRAC 4.872000e+03 4872.0 4872.000000 4872 \n",
" GEL 8.868148e+08 55.0 2147251.230024 9131682 \n",
" KCL 1.049064e+06 84.0 23842.363636 222060 \n",
" LSECR 1.050000e+04 10500.0 10500.000000 10500 \n",
" SLKW 1.910579e+09 1176.0 2881718.177979 37504112 \n",
" SW 1.302840e+05 3360.0 16285.500000 33936 \n",
" TRET 3.526000e+04 1260.0 17630.000000 34000 \n",
" W 1.377589e+09 126.0 1638036.422117 12844146 \n",
" WTR 2.738400e+04 27384.0 27384.000000 27384 \n",
" X-LINKGEL 6.707200e+08 2000.0 1357732.852227 18271428 \n",
"2014 FLUD 1.026885e+09 27.0 2066167.734406 9999108 \n",
" FRAC 3.638250e+06 38724.0 1819125.000000 3599526 \n",
" GEL 8.755910e+08 60.0 2473420.790960 17423406 \n",
" KCL 4.519600e+05 714.0 18078.400000 140238 \n",
" SLKW 2.015093e+09 3360.0 3860330.720307 22620108 \n",
" SW 7.736400e+05 8400.0 193410.000000 569604 \n",
" W 1.010212e+09 294.0 2617129.202073 18581052 \n",
" X-LINKGEL 2.901641e+08 4000.0 1151444.670635 14860818 \n",
"\n",
" size \n",
"Date Completion Fluid Type \n",
"1995 FLUD 6 \n",
" FRAC 9 \n",
" GEL 10 \n",
" SLKW 1 \n",
" U 17 \n",
" UNKNOWN 456 \n",
" W 716 \n",
"1996 FLUD 1 \n",
" FRAC 14 \n",
" GEL 12 \n",
" U 15 \n",
" UNKNOWN 584 \n",
" W 827 \n",
"1997 FLUD 6 \n",
" FRAC 31 \n",
" GEL 5 \n",
" U 27 \n",
" UNKNOWN 786 \n",
" W 1021 \n",
" WTR 2 \n",
"1998 FLUD 7 \n",
" FRAC 37 \n",
" GEL 4 \n",
" U 32 \n",
" UNKNOWN 650 \n",
" W 897 \n",
"1999 FLUD 11 \n",
" FRAC 119 \n",
" GEL 54 \n",
" TRET 9 \n",
" U 54 \n",
" UNKNOWN 351 \n",
" W 624 \n",
" WTR 1 \n",
" X-LINKGEL 1 \n",
"2000 FLUD 18 \n",
" FRAC 575 \n",
" GEL 279 \n",
" KCL 1 \n",
" TRET 18 \n",
" U 156 \n",
" UNKNOWN 3 \n",
" W 602 \n",
" X-LINKGEL 15 \n",
"2001 FLUD 36 \n",
" FRAC 287 \n",
" GEL 394 \n",
" TRET 9 \n",
" U 626 \n",
" W 967 \n",
" WTR 1 \n",
" X-LINKGEL 24 \n",
"2002 FLUD 33 \n",
" FRAC 8 \n",
" GEL 501 \n",
" KCL 1 \n",
" TRET 14 \n",
" U 451 \n",
" W 883 \n",
" WTR 2 \n",
" X-LINKGEL 29 \n",
"2003 BKDN 1 \n",
" FLUD 98 \n",
" FRAC 11 \n",
" GEL 571 \n",
" TRET 28 \n",
" U 584 \n",
" W 823 \n",
" WFR 1 \n",
" WTR 129 \n",
" X-LINKGEL 35 \n",
"2004 BKDN 1 \n",
" FLUD 811 \n",
" FRAC 2 \n",
" GEL 664 \n",
" SLKW 1 \n",
" TRET 1 \n",
" U 75 \n",
" W 1080 \n",
" WTR 31 \n",
" X-LINKGEL 111 \n",
"2005 FLUD 1291 \n",
" FRAC 1 \n",
" GEL 491 \n",
" KCL 1 \n",
" SLKW 3 \n",
" U 1 \n",
" W 1336 \n",
" X-LINKGEL 222 \n",
"2006 BKDN 1 \n",
" FLUD 1356 \n",
" FRAC 9 \n",
" GEL 491 \n",
" KCL 2 \n",
" SLKW 4 \n",
" TRET 1 \n",
" W 1779 \n",
" WTR 1 \n",
" X-LINKGEL 218 \n",
"2007 BKDN 1 \n",
" FLUD 1554 \n",
" FRAC 4 \n",
" GEL 373 \n",
" KCL 18 \n",
" SLKW 14 \n",
" W 2021 \n",
" WTR 1 \n",
" X-LINKGEL 169 \n",
"2008 AGFR 1 \n",
" BXGF 1 \n",
" FLUD 2212 \n",
" FRAC 11 \n",
" GEL 411 \n",
" KCL 58 \n",
" SFAC 2 \n",
" SLKW 24 \n",
" SW 2 \n",
" TRET 2 \n",
" W 2656 \n",
" X-LINKGEL 216 \n",
"2009 FLUD 1478 \n",
" FRAC 21 \n",
" GEL 178 \n",
" KCL 22 \n",
" SFAC 2 \n",
" SLKW 197 \n",
" W 1262 \n",
" X-LINKGEL 117 \n",
"2010 FLUD 1618 \n",
" FRAC 16 \n",
" GEL 150 \n",
" KCL 5 \n",
" SLKW 799 \n",
" SWNF 1 \n",
" W 758 \n",
" X-LINKGEL 84 \n",
"2011 FLUD 983 \n",
" FRAC 15 \n",
" GEL 230 \n",
" KCL 12 \n",
" SFAC 2 \n",
" SLKW 807 \n",
" SW 1 \n",
" W 1006 \n",
" X-LINKGEL 156 \n",
"2012 FLUD 952 \n",
" FRAC 4 \n",
" GEL 367 \n",
" KCL 30 \n",
" SLKW 936 \n",
" SW 7 \n",
" W 974 \n",
" WTR 3 \n",
" X-LINKGEL 304 \n",
"2013 FLUD 1057 \n",
" FRAC 1 \n",
" GEL 413 \n",
" KCL 44 \n",
" LSECR 1 \n",
" SLKW 663 \n",
" SW 8 \n",
" TRET 2 \n",
" W 841 \n",
" WTR 1 \n",
" X-LINKGEL 494 \n",
"2014 FLUD 497 \n",
" FRAC 2 \n",
" GEL 354 \n",
" KCL 25 \n",
" SLKW 522 \n",
" SW 4 \n",
" W 386 \n",
" X-LINKGEL 252 "
]
}
],
"prompt_number": 5
},
{
"cell_type": "code",
"collapsed": false,
"input": [],
"language": "python",
"metadata": {},
"outputs": []
}
],
"metadata": {}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment