Skip to content

Instantly share code, notes, and snippets.

@mbstacy

mbstacy/ows_oil_water_usage.ipynb

Created September 25, 2014 16:27
Show Gist options
  • Save mbstacy/9d048c79cd6bef91b5bd to your computer and use it in GitHub Desktop.
Save mbstacy/9d048c79cd6bef91b5bd to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
ows_oil_water_usage.ipynb
{
"metadata": {
"name": "",
"signature": "sha256:6fa4f8c0468e8c101f6225dd05214914755ae88dd074202b8537cfc7f3f0dfff"
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "code",
"collapsed": false,
"input": [
"from pandas import read_excel, merge, options \n",
"options.display.max_columns = 50\n",
"options.display.max_rows = 250\n",
"Header = read_excel('/Users/mstacy/Desktop/ows-data/Export - Excel Well Workbook_3.xlsx',sheetname='Header')\n",
"test_treat = read_excel('/Users/mstacy/Desktop/ows-data/Export - Excel Well Workbook_3.xlsx',sheetname='Test Treatment')"
],
"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)']]"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 19
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"#adjust display options\n",
"options.display.max_columns = 50\n",
"options.display.max_rows = 250\n",
"\n",
"#Group by Year and Month\n",
"grouped = result.groupby([result['Date Completion'].map(lambda x: x.year) ,result['Date Completion'].map(lambda x: x.month),])\n",
"grouped['Fluid Amount (gals)'].agg(['sum','min','mean','max','size'])\n"
],
"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>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 rowspan=\"12\" valign=\"top\">1995</th>\n",
" <th>1 </th>\n",
" <td> 3.741480e+05</td>\n",
" <td> 250.0</td>\n",
" <td> 24943.200000</td>\n",
" <td> 279888</td>\n",
" <td> 17</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 9.900000e+04</td>\n",
" <td> 1000.0</td>\n",
" <td> 8250.000000</td>\n",
" <td> 60000</td>\n",
" <td> 14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 3.974400e+04</td>\n",
" <td> 1000.0</td>\n",
" <td> 3613.090909</td>\n",
" <td> 20244</td>\n",
" <td> 12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 1.850100e+05</td>\n",
" <td> 1250.0</td>\n",
" <td> 23126.250000</td>\n",
" <td> 80000</td>\n",
" <td> 10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 4.950000e+04</td>\n",
" <td> 1250.0</td>\n",
" <td> 9900.000000</td>\n",
" <td> 40000</td>\n",
" <td> 6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 8.473500e+04</td>\n",
" <td> 125.0</td>\n",
" <td> 8473.500000</td>\n",
" <td> 38500</td>\n",
" <td> 10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 1.409300e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 10840.769231</td>\n",
" <td> 60480</td>\n",
" <td> 13</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 1.387000e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 13870.000000</td>\n",
" <td> 50400</td>\n",
" <td> 11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 6.214000e+04</td>\n",
" <td> 390.0</td>\n",
" <td> 4142.666667</td>\n",
" <td> 15000</td>\n",
" <td> 18</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 8.574800e+04</td>\n",
" <td> 500.0</td>\n",
" <td> 9527.555556</td>\n",
" <td> 55000</td>\n",
" <td> 9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 6.563180e+05</td>\n",
" <td> 1000.0</td>\n",
" <td> 46879.857143</td>\n",
" <td> 294000</td>\n",
" <td> 15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 6.436840e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 42912.266667</td>\n",
" <td> 493500</td>\n",
" <td> 16</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"12\" valign=\"top\">1996</th>\n",
" <th>1 </th>\n",
" <td> 6.160000e+04</td>\n",
" <td> 200.0</td>\n",
" <td> 8800.000000</td>\n",
" <td> 33000</td>\n",
" <td> 7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 9.020000e+04</td>\n",
" <td> 300.0</td>\n",
" <td> 6938.461538</td>\n",
" <td> 55000</td>\n",
" <td> 14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 1.253420e+05</td>\n",
" <td> 700.0</td>\n",
" <td> 12534.200000</td>\n",
" <td> 50442</td>\n",
" <td> 11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 1.329720e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 16621.500000</td>\n",
" <td> 55986</td>\n",
" <td> 8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 1.911160e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 8687.090909</td>\n",
" <td> 82500</td>\n",
" <td> 22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 7.400000e+04</td>\n",
" <td> 500.0</td>\n",
" <td> 10571.428571</td>\n",
" <td> 37500</td>\n",
" <td> 9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 1.133960e+05</td>\n",
" <td> 250.0</td>\n",
" <td> 10308.727273</td>\n",
" <td> 25780</td>\n",
" <td> 11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 1.389160e+06</td>\n",
" <td> 750.0</td>\n",
" <td> 99225.714286</td>\n",
" <td> 642600</td>\n",
" <td> 14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 2.037860e+05</td>\n",
" <td> 100.0</td>\n",
" <td> 11987.411765</td>\n",
" <td> 87000</td>\n",
" <td> 18</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 9.909160e+05</td>\n",
" <td> 1000.0</td>\n",
" <td> 43083.304348</td>\n",
" <td> 338352</td>\n",
" <td> 23</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 5.309100e+05</td>\n",
" <td> 750.0</td>\n",
" <td> 22121.250000</td>\n",
" <td> 200000</td>\n",
" <td> 24</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 2.250000e+04</td>\n",
" <td> 750.0</td>\n",
" <td> 4500.000000</td>\n",
" <td> 8000</td>\n",
" <td> 5</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"12\" valign=\"top\">1997</th>\n",
" <th>1 </th>\n",
" <td> 1.109234e+06</td>\n",
" <td> 300.0</td>\n",
" <td> 52820.666667</td>\n",
" <td> 588000</td>\n",
" <td> 21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 1.113189e+06</td>\n",
" <td> 350.0</td>\n",
" <td> 32740.852941</td>\n",
" <td> 317520</td>\n",
" <td> 34</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 5.329040e+05</td>\n",
" <td> 200.0</td>\n",
" <td> 26645.200000</td>\n",
" <td> 199500</td>\n",
" <td> 21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 3.164067e+06</td>\n",
" <td> 165.0</td>\n",
" <td> 98877.093750</td>\n",
" <td> 2646000</td>\n",
" <td> 32</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 1.159072e+06</td>\n",
" <td> 150.0</td>\n",
" <td> 28976.800000</td>\n",
" <td> 611100</td>\n",
" <td> 43</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 8.724000e+04</td>\n",
" <td> 250.0</td>\n",
" <td> 10905.000000</td>\n",
" <td> 37464</td>\n",
" <td> 8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 3.365410e+05</td>\n",
" <td> 455.0</td>\n",
" <td> 12019.321429</td>\n",
" <td> 71000</td>\n",
" <td> 28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 5.438300e+05</td>\n",
" <td> 1000.0</td>\n",
" <td> 19422.500000</td>\n",
" <td> 105000</td>\n",
" <td> 28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 3.332420e+05</td>\n",
" <td> 1000.0</td>\n",
" <td> 15868.666667</td>\n",
" <td> 55000</td>\n",
" <td> 21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 2.867980e+05</td>\n",
" <td> 300.0</td>\n",
" <td> 13036.272727</td>\n",
" <td> 66738</td>\n",
" <td> 22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 3.210940e+05</td>\n",
" <td> 210.0</td>\n",
" <td> 18887.882353</td>\n",
" <td> 63000</td>\n",
" <td> 21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 7.734600e+04</td>\n",
" <td> 750.0</td>\n",
" <td> 7031.454545</td>\n",
" <td> 19110</td>\n",
" <td> 12</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"12\" valign=\"top\">1998</th>\n",
" <th>1 </th>\n",
" <td> 8.270000e+04</td>\n",
" <td> 1000.0</td>\n",
" <td> 7518.181818</td>\n",
" <td> 30660</td>\n",
" <td> 12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 5.372250e+05</td>\n",
" <td> 125.0</td>\n",
" <td> 41325.000000</td>\n",
" <td> 205380</td>\n",
" <td> 13</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 3.337900e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 16689.500000</td>\n",
" <td> 120000</td>\n",
" <td> 20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 4.312280e+05</td>\n",
" <td> 250.0</td>\n",
" <td> 25366.352941</td>\n",
" <td> 136710</td>\n",
" <td> 17</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 2.778140e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 16342.000000</td>\n",
" <td> 103530</td>\n",
" <td> 22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 1.085080e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 18084.666667</td>\n",
" <td> 76000</td>\n",
" <td> 10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 8.501180e+05</td>\n",
" <td> 1000.0</td>\n",
" <td> 47228.777778</td>\n",
" <td> 357000</td>\n",
" <td> 19</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 5.296940e+05</td>\n",
" <td> 750.0</td>\n",
" <td> 37835.285714</td>\n",
" <td> 315000</td>\n",
" <td> 19</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 3.083070e+05</td>\n",
" <td> 200.0</td>\n",
" <td> 23715.923077</td>\n",
" <td> 126000</td>\n",
" <td> 15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 2.681720e+05</td>\n",
" <td> 300.0</td>\n",
" <td> 20628.615385</td>\n",
" <td> 132720</td>\n",
" <td> 20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 2.904000e+04</td>\n",
" <td> 500.0</td>\n",
" <td> 5808.000000</td>\n",
" <td> 17000</td>\n",
" <td> 8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 1.693826e+06</td>\n",
" <td> 250.0</td>\n",
" <td> 67753.040000</td>\n",
" <td> 874608</td>\n",
" <td> 29</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"12\" valign=\"top\">1999</th>\n",
" <th>1 </th>\n",
" <td> 4.460020e+05</td>\n",
" <td> 1500.0</td>\n",
" <td> 49555.777778</td>\n",
" <td> 134022</td>\n",
" <td> 9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 6.518080e+05</td>\n",
" <td> 2000.0</td>\n",
" <td> 59255.272727</td>\n",
" <td> 204204</td>\n",
" <td> 11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 1.058678e+06</td>\n",
" <td> 1000.0</td>\n",
" <td> 58815.444444</td>\n",
" <td> 273798</td>\n",
" <td> 19</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 9.688200e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 42122.608696</td>\n",
" <td> 280854</td>\n",
" <td> 25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 1.720934e+06</td>\n",
" <td> 300.0</td>\n",
" <td> 63738.296296</td>\n",
" <td> 222432</td>\n",
" <td> 28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 7.136660e+05</td>\n",
" <td> 2500.0</td>\n",
" <td> 71366.600000</td>\n",
" <td> 210462</td>\n",
" <td> 11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 1.049380e+05</td>\n",
" <td> 750.0</td>\n",
" <td> 8744.833333</td>\n",
" <td> 45000</td>\n",
" <td> 14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 3.588360e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 27602.769231</td>\n",
" <td> 112056</td>\n",
" <td> 15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 9.350820e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 42503.727273</td>\n",
" <td> 207900</td>\n",
" <td> 25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 1.454814e+06</td>\n",
" <td> 750.0</td>\n",
" <td> 46929.483871</td>\n",
" <td> 205800</td>\n",
" <td> 31</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 4.654620e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 33247.285714</td>\n",
" <td> 127008</td>\n",
" <td> 15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 6.654860e+05</td>\n",
" <td> 1500.0</td>\n",
" <td> 36971.444444</td>\n",
" <td> 169470</td>\n",
" <td> 18</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"12\" valign=\"top\">2000</th>\n",
" <th>1 </th>\n",
" <td> 6.939000e+05</td>\n",
" <td> 1000.0</td>\n",
" <td> 43368.750000</td>\n",
" <td> 237500</td>\n",
" <td> 17</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 9.309050e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 62060.333333</td>\n",
" <td> 304248</td>\n",
" <td> 17</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 1.287680e+06</td>\n",
" <td> 500.0</td>\n",
" <td> 55986.086957</td>\n",
" <td> 222474</td>\n",
" <td> 24</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 2.604500e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 43408.333333</td>\n",
" <td> 214200</td>\n",
" <td> 7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 7.353810e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 19875.162162</td>\n",
" <td> 174930</td>\n",
" <td> 38</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 8.343320e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 39730.095238</td>\n",
" <td> 255192</td>\n",
" <td> 23</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 5.598960e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 25449.818182</td>\n",
" <td> 117700</td>\n",
" <td> 25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 6.572230e+05</td>\n",
" <td> 125.0</td>\n",
" <td> 34590.684211</td>\n",
" <td> 231000</td>\n",
" <td> 23</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 9.984780e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 23220.418605</td>\n",
" <td> 210000</td>\n",
" <td> 46</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 8.372700e+05</td>\n",
" <td> 1500.0</td>\n",
" <td> 41863.500000</td>\n",
" <td> 180000</td>\n",
" <td> 20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 6.463580e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 25854.320000</td>\n",
" <td> 133308</td>\n",
" <td> 25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 1.404462e+06</td>\n",
" <td> 400.0</td>\n",
" <td> 82615.411765</td>\n",
" <td> 642000</td>\n",
" <td> 18</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"12\" valign=\"top\">2001</th>\n",
" <th>1 </th>\n",
" <td> 1.934980e+05</td>\n",
" <td> 1000.0</td>\n",
" <td> 14884.461538</td>\n",
" <td> 64368</td>\n",
" <td> 17</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 3.567860e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 12742.357143</td>\n",
" <td> 116844</td>\n",
" <td> 33</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 1.106452e+06</td>\n",
" <td> 10.0</td>\n",
" <td> 42555.846154</td>\n",
" <td> 382200</td>\n",
" <td> 28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 1.158148e+06</td>\n",
" <td> 750.0</td>\n",
" <td> 28247.512195</td>\n",
" <td> 185766</td>\n",
" <td> 42</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 8.629560e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 19176.800000</td>\n",
" <td> 103250</td>\n",
" <td> 47</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 5.240800e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 29115.555556</td>\n",
" <td> 105552</td>\n",
" <td> 18</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 1.565062e+06</td>\n",
" <td> 500.0</td>\n",
" <td> 31301.240000</td>\n",
" <td> 420000</td>\n",
" <td> 54</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 1.100780e+06</td>\n",
" <td> 500.0</td>\n",
" <td> 44031.200000</td>\n",
" <td> 315000</td>\n",
" <td> 27</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 1.199010e+06</td>\n",
" <td> 200.0</td>\n",
" <td> 29975.250000</td>\n",
" <td> 334320</td>\n",
" <td> 42</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 4.574500e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 28590.625000</td>\n",
" <td> 152502</td>\n",
" <td> 21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 6.584960e+05</td>\n",
" <td> 300.0</td>\n",
" <td> 26339.840000</td>\n",
" <td> 210000</td>\n",
" <td> 28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 8.726840e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 31167.285714</td>\n",
" <td> 210000</td>\n",
" <td> 29</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"12\" valign=\"top\">2002</th>\n",
" <th>1 </th>\n",
" <td> 3.735860e+05</td>\n",
" <td> 5.0</td>\n",
" <td> 15566.083333</td>\n",
" <td> 115000</td>\n",
" <td> 24</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 1.042553e+06</td>\n",
" <td> 500.0</td>\n",
" <td> 32579.781250</td>\n",
" <td> 219408</td>\n",
" <td> 35</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 7.065200e+05</td>\n",
" <td> 1000.0</td>\n",
" <td> 33643.809524</td>\n",
" <td> 302064</td>\n",
" <td> 23</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 7.950950e+05</td>\n",
" <td> 600.0</td>\n",
" <td> 23385.147059</td>\n",
" <td> 210000</td>\n",
" <td> 37</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 1.615380e+06</td>\n",
" <td> 300.0</td>\n",
" <td> 42510.000000</td>\n",
" <td> 315000</td>\n",
" <td> 40</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 1.421650e+06</td>\n",
" <td> 300.0</td>\n",
" <td> 50773.214286</td>\n",
" <td> 270480</td>\n",
" <td> 30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 1.672840e+05</td>\n",
" <td> 1000.0</td>\n",
" <td> 16728.400000</td>\n",
" <td> 45000</td>\n",
" <td> 14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 9.861600e+05</td>\n",
" <td> 1500.0</td>\n",
" <td> 39446.400000</td>\n",
" <td> 258174</td>\n",
" <td> 26</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 3.108150e+05</td>\n",
" <td> 1000.0</td>\n",
" <td> 17267.500000</td>\n",
" <td> 146580</td>\n",
" <td> 22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 2.594834e+06</td>\n",
" <td> 300.0</td>\n",
" <td> 64870.850000</td>\n",
" <td> 336000</td>\n",
" <td> 41</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 6.904480e+05</td>\n",
" <td> 1000.0</td>\n",
" <td> 32878.476190</td>\n",
" <td> 224448</td>\n",
" <td> 22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 1.100143e+06</td>\n",
" <td> 200.0</td>\n",
" <td> 32357.147059</td>\n",
" <td> 304038</td>\n",
" <td> 36</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"12\" valign=\"top\">2003</th>\n",
" <th>1 </th>\n",
" <td> 8.252480e+05</td>\n",
" <td> 1000.0</td>\n",
" <td> 35880.347826</td>\n",
" <td> 210000</td>\n",
" <td> 25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 4.597240e+05</td>\n",
" <td> 750.0</td>\n",
" <td> 16418.714286</td>\n",
" <td> 103500</td>\n",
" <td> 32</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 5.118400e+05</td>\n",
" <td> 250.0</td>\n",
" <td> 18957.037037</td>\n",
" <td> 211260</td>\n",
" <td> 28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 8.217640e+05</td>\n",
" <td> 252.0</td>\n",
" <td> 19110.790698</td>\n",
" <td> 168000</td>\n",
" <td> 44</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 1.997662e+06</td>\n",
" <td> 300.0</td>\n",
" <td> 40768.612245</td>\n",
" <td> 218568</td>\n",
" <td> 49</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 4.168880e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 17370.333333</td>\n",
" <td> 156996</td>\n",
" <td> 26</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 1.036856e+06</td>\n",
" <td> 500.0</td>\n",
" <td> 28023.135135</td>\n",
" <td> 210000</td>\n",
" <td> 41</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 2.480822e+06</td>\n",
" <td> 250.0</td>\n",
" <td> 49616.440000</td>\n",
" <td> 210000</td>\n",
" <td> 52</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 2.230037e+06</td>\n",
" <td> 420.0</td>\n",
" <td> 51861.325581</td>\n",
" <td> 278544</td>\n",
" <td> 46</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 2.553476e+06</td>\n",
" <td> 200.0</td>\n",
" <td> 65473.743590</td>\n",
" <td> 365400</td>\n",
" <td> 40</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 1.605516e+06</td>\n",
" <td> 1000.0</td>\n",
" <td> 61750.615385</td>\n",
" <td> 336000</td>\n",
" <td> 28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 1.681698e+06</td>\n",
" <td> 1092.0</td>\n",
" <td> 73117.304348</td>\n",
" <td> 408282</td>\n",
" <td> 23</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"12\" valign=\"top\">2004</th>\n",
" <th>1 </th>\n",
" <td> 3.739991e+06</td>\n",
" <td> 300.0</td>\n",
" <td> 81304.152174</td>\n",
" <td> 630000</td>\n",
" <td> 46</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 2.563420e+06</td>\n",
" <td> 1500.0</td>\n",
" <td> 59614.418605</td>\n",
" <td> 228060</td>\n",
" <td> 43</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 1.386604e+06</td>\n",
" <td> 400.0</td>\n",
" <td> 33819.609756</td>\n",
" <td> 252000</td>\n",
" <td> 43</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 2.768148e+06</td>\n",
" <td> 250.0</td>\n",
" <td> 47726.689655</td>\n",
" <td> 216720</td>\n",
" <td> 58</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 2.960010e+06</td>\n",
" <td> 1000.0</td>\n",
" <td> 47742.096774</td>\n",
" <td> 254520</td>\n",
" <td> 66</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 2.303244e+06</td>\n",
" <td> 1000.0</td>\n",
" <td> 71976.375000</td>\n",
" <td> 529032</td>\n",
" <td> 33</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 2.607676e+06</td>\n",
" <td> 1008.0</td>\n",
" <td> 54326.583333</td>\n",
" <td> 333564</td>\n",
" <td> 49</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 2.845382e+06</td>\n",
" <td> 1000.0</td>\n",
" <td> 61856.130435</td>\n",
" <td> 264432</td>\n",
" <td> 46</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 3.714675e+06</td>\n",
" <td> 504.0</td>\n",
" <td> 80753.804348</td>\n",
" <td> 613000</td>\n",
" <td> 48</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 3.831094e+06</td>\n",
" <td> 1500.0</td>\n",
" <td> 68412.392857</td>\n",
" <td> 285600</td>\n",
" <td> 60</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 2.665922e+06</td>\n",
" <td> 504.0</td>\n",
" <td> 59242.711111</td>\n",
" <td> 273000</td>\n",
" <td> 45</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 2.039320e+06</td>\n",
" <td> 1464.0</td>\n",
" <td> 49739.512195</td>\n",
" <td> 273000</td>\n",
" <td> 41</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"12\" valign=\"top\">2005</th>\n",
" <th>1 </th>\n",
" <td> 4.154132e+06</td>\n",
" <td> 1500.0</td>\n",
" <td> 79887.153846</td>\n",
" <td> 336000</td>\n",
" <td> 54</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 5.929679e+06</td>\n",
" <td> 250.0</td>\n",
" <td> 83516.605634</td>\n",
" <td> 394800</td>\n",
" <td> 72</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 5.801877e+06</td>\n",
" <td> 1000.0</td>\n",
" <td> 82883.957143</td>\n",
" <td> 529032</td>\n",
" <td> 72</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 9.336383e+06</td>\n",
" <td> 250.0</td>\n",
" <td> 148196.555556</td>\n",
" <td> 3684240</td>\n",
" <td> 64</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 6.401764e+06</td>\n",
" <td> 1000.0</td>\n",
" <td> 83139.792208</td>\n",
" <td> 420000</td>\n",
" <td> 77</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 3.364150e+08</td>\n",
" <td> 125.0</td>\n",
" <td> 5514999.344262</td>\n",
" <td> 331061632</td>\n",
" <td> 61</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 4.353896e+06</td>\n",
" <td> 500.0</td>\n",
" <td> 79161.745455</td>\n",
" <td> 420000</td>\n",
" <td> 56</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 7.763106e+06</td>\n",
" <td> 500.0</td>\n",
" <td> 87225.910112</td>\n",
" <td> 650076</td>\n",
" <td> 96</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 7.454514e+06</td>\n",
" <td> 250.0</td>\n",
" <td> 86680.395349</td>\n",
" <td> 1260000</td>\n",
" <td> 87</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 6.674524e+06</td>\n",
" <td> 500.0</td>\n",
" <td> 115078.000000</td>\n",
" <td> 431928</td>\n",
" <td> 58</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 6.908964e+06</td>\n",
" <td> 250.0</td>\n",
" <td> 86362.050000</td>\n",
" <td> 443856</td>\n",
" <td> 80</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 6.894696e+06</td>\n",
" <td> 250.0</td>\n",
" <td> 93171.567568</td>\n",
" <td> 558642</td>\n",
" <td> 75</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"12\" valign=\"top\">2006</th>\n",
" <th>1 </th>\n",
" <td> 8.439878e+06</td>\n",
" <td> 1000.0</td>\n",
" <td> 118871.521127</td>\n",
" <td> 614124</td>\n",
" <td> 75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 6.742874e+06</td>\n",
" <td> 10.0</td>\n",
" <td> 88722.026316</td>\n",
" <td> 435708</td>\n",
" <td> 77</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 7.083059e+06</td>\n",
" <td> 250.0</td>\n",
" <td> 89658.974684</td>\n",
" <td> 483000</td>\n",
" <td> 81</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 8.782921e+06</td>\n",
" <td> 500.0</td>\n",
" <td> 125470.300000</td>\n",
" <td> 3023454</td>\n",
" <td> 71</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 8.007030e+06</td>\n",
" <td> 500.0</td>\n",
" <td> 96470.240964</td>\n",
" <td> 599550</td>\n",
" <td> 84</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 6.472805e+06</td>\n",
" <td> 1000.0</td>\n",
" <td> 72728.146067</td>\n",
" <td> 456540</td>\n",
" <td> 90</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 5.468346e+06</td>\n",
" <td> 600.0</td>\n",
" <td> 84128.400000</td>\n",
" <td> 357000</td>\n",
" <td> 65</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 6.690797e+06</td>\n",
" <td> 7.0</td>\n",
" <td> 83634.962500</td>\n",
" <td> 428400</td>\n",
" <td> 81</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 1.200973e+07</td>\n",
" <td> 250.0</td>\n",
" <td> 99253.960330</td>\n",
" <td> 504000</td>\n",
" <td> 126</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 9.283954e+06</td>\n",
" <td> 500.0</td>\n",
" <td> 92839.540000</td>\n",
" <td> 420000</td>\n",
" <td> 101</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 6.813685e+06</td>\n",
" <td> 150.0</td>\n",
" <td> 77428.238636</td>\n",
" <td> 391860</td>\n",
" <td> 88</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 1.169962e+07</td>\n",
" <td> 500.0</td>\n",
" <td> 93596.960000</td>\n",
" <td> 429072</td>\n",
" <td> 126</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"12\" valign=\"top\">2007</th>\n",
" <th>1 </th>\n",
" <td> 8.852261e+06</td>\n",
" <td> 500.0</td>\n",
" <td> 79038.044643</td>\n",
" <td> 416304</td>\n",
" <td> 113</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 1.051927e+07</td>\n",
" <td> 150.0</td>\n",
" <td> 84832.846774</td>\n",
" <td> 2772588</td>\n",
" <td> 124</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 1.158887e+07</td>\n",
" <td> 200.0</td>\n",
" <td> 68981.352376</td>\n",
" <td> 426972</td>\n",
" <td> 168</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 8.274556e+06</td>\n",
" <td> 250.0</td>\n",
" <td> 81926.297030</td>\n",
" <td> 1017618</td>\n",
" <td> 102</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 1.219452e+07</td>\n",
" <td> 100.0</td>\n",
" <td> 78170.032051</td>\n",
" <td> 504000</td>\n",
" <td> 158</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 8.450540e+06</td>\n",
" <td> 500.0</td>\n",
" <td> 73482.956522</td>\n",
" <td> 681198</td>\n",
" <td> 119</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 1.069589e+08</td>\n",
" <td> 80.0</td>\n",
" <td> 1304376.292683</td>\n",
" <td> 99000000</td>\n",
" <td> 85</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 7.284071e+06</td>\n",
" <td> 500.0</td>\n",
" <td> 72840.710000</td>\n",
" <td> 336000</td>\n",
" <td> 106</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 7.021004e+06</td>\n",
" <td> 500.0</td>\n",
" <td> 66866.704762</td>\n",
" <td> 378000</td>\n",
" <td> 110</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 8.562518e+06</td>\n",
" <td> 200.0</td>\n",
" <td> 78555.211009</td>\n",
" <td> 378000</td>\n",
" <td> 112</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 5.945241e+06</td>\n",
" <td> 420.0</td>\n",
" <td> 100766.796610</td>\n",
" <td> 1522800</td>\n",
" <td> 60</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 3.089688e+06</td>\n",
" <td> 500.0</td>\n",
" <td> 83505.081081</td>\n",
" <td> 389172</td>\n",
" <td> 43</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"12\" valign=\"top\">2008</th>\n",
" <th>1 </th>\n",
" <td> 3.827363e+06</td>\n",
" <td> 300.0</td>\n",
" <td> 89008.441860</td>\n",
" <td> 399000</td>\n",
" <td> 48</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 1.069694e+07</td>\n",
" <td> 420.0</td>\n",
" <td> 93832.780702</td>\n",
" <td> 424284</td>\n",
" <td> 123</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 7.379142e+06</td>\n",
" <td> 420.0</td>\n",
" <td> 83853.886364</td>\n",
" <td> 356874</td>\n",
" <td> 91</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 6.478652e+06</td>\n",
" <td> 420.0</td>\n",
" <td> 73621.045455</td>\n",
" <td> 345450</td>\n",
" <td> 94</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 9.575646e+06</td>\n",
" <td> 420.0</td>\n",
" <td> 85496.839286</td>\n",
" <td> 427140</td>\n",
" <td> 113</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 6.145975e+06</td>\n",
" <td> 400.0</td>\n",
" <td> 100753.688525</td>\n",
" <td> 453936</td>\n",
" <td> 63</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 1.327278e+07</td>\n",
" <td> 153.0</td>\n",
" <td> 181818.945205</td>\n",
" <td> 3158820</td>\n",
" <td> 75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 3.879611e+08</td>\n",
" <td> 12.5</td>\n",
" <td> 3803540.573529</td>\n",
" <td> 355529984</td>\n",
" <td> 103</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 1.456046e+07</td>\n",
" <td> 420.0</td>\n",
" <td> 128853.663717</td>\n",
" <td> 2352000</td>\n",
" <td> 117</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 5.121421e+06</td>\n",
" <td> 420.0</td>\n",
" <td> 124912.707317</td>\n",
" <td> 499800</td>\n",
" <td> 41</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 7.872558e+06</td>\n",
" <td> 420.0</td>\n",
" <td> 129058.327869</td>\n",
" <td> 1575000</td>\n",
" <td> 63</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 4.072110e+06</td>\n",
" <td> 300.0</td>\n",
" <td> 88524.139128</td>\n",
" <td> 463134</td>\n",
" <td> 48</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"12\" valign=\"top\">2009</th>\n",
" <th>1 </th>\n",
" <td> 7.556069e+06</td>\n",
" <td> 126.0</td>\n",
" <td> 103507.794521</td>\n",
" <td> 567000</td>\n",
" <td> 74</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 5.507734e+06</td>\n",
" <td> 20.0</td>\n",
" <td> 94960.931034</td>\n",
" <td> 637560</td>\n",
" <td> 58</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 4.920064e+06</td>\n",
" <td> 420.0</td>\n",
" <td> 136668.444444</td>\n",
" <td> 347214</td>\n",
" <td> 37</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 7.716132e+06</td>\n",
" <td> 1008.0</td>\n",
" <td> 164173.021277</td>\n",
" <td> 527058</td>\n",
" <td> 50</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 6.243370e+06</td>\n",
" <td> 1000.0</td>\n",
" <td> 164299.210526</td>\n",
" <td> 1479702</td>\n",
" <td> 42</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 5.903134e+06</td>\n",
" <td> 2000.0</td>\n",
" <td> 227043.615385</td>\n",
" <td> 1447950</td>\n",
" <td> 27</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 3.406900e+06</td>\n",
" <td> 1000.0</td>\n",
" <td> 179310.526316</td>\n",
" <td> 1430688</td>\n",
" <td> 20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 4.990600e+06</td>\n",
" <td> 2000.0</td>\n",
" <td> 216982.608696</td>\n",
" <td> 1530480</td>\n",
" <td> 24</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 5.430216e+06</td>\n",
" <td> 1000.0</td>\n",
" <td> 217208.640000</td>\n",
" <td> 2267748</td>\n",
" <td> 25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 7.543756e+06</td>\n",
" <td> 1000.0</td>\n",
" <td> 301750.240000</td>\n",
" <td> 3579534</td>\n",
" <td> 26</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 7.659140e+05</td>\n",
" <td> 500.0</td>\n",
" <td> 38295.700000</td>\n",
" <td> 266532</td>\n",
" <td> 21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 5.122562e+06</td>\n",
" <td> 65.0</td>\n",
" <td> 256128.100000</td>\n",
" <td> 3573780</td>\n",
" <td> 22</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"12\" valign=\"top\">2010</th>\n",
" <th>1 </th>\n",
" <td> 5.021330e+06</td>\n",
" <td> 924.0</td>\n",
" <td> 251066.500000</td>\n",
" <td> 3429678</td>\n",
" <td> 20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 9.687450e+06</td>\n",
" <td> 1974.0</td>\n",
" <td> 293559.090909</td>\n",
" <td> 2968182</td>\n",
" <td> 33</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 8.459016e+06</td>\n",
" <td> 40.0</td>\n",
" <td> 352459.000000</td>\n",
" <td> 3659712</td>\n",
" <td> 24</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 5.072038e+06</td>\n",
" <td> 1000.0</td>\n",
" <td> 362288.428571</td>\n",
" <td> 3605532</td>\n",
" <td> 14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 8.589406e+06</td>\n",
" <td> 550.0</td>\n",
" <td> 373452.434783</td>\n",
" <td> 3382848</td>\n",
" <td> 23</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 4.429673e+06</td>\n",
" <td> 500.0</td>\n",
" <td> 246092.944444</td>\n",
" <td> 2193366</td>\n",
" <td> 18</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 7.370984e+06</td>\n",
" <td> 3000.0</td>\n",
" <td> 387946.526316</td>\n",
" <td> 3669036</td>\n",
" <td> 20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 2.478625e+07</td>\n",
" <td> 168.0</td>\n",
" <td> 1126647.681818</td>\n",
" <td> 10122000</td>\n",
" <td> 22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 4.549372e+06</td>\n",
" <td> 500.0</td>\n",
" <td> 227468.600000</td>\n",
" <td> 1743798</td>\n",
" <td> 21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 7.383862e+06</td>\n",
" <td> 2000.0</td>\n",
" <td> 351612.476190</td>\n",
" <td> 2268966</td>\n",
" <td> 22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 2.047009e+07</td>\n",
" <td> 1000.0</td>\n",
" <td> 682336.366667</td>\n",
" <td> 12890625</td>\n",
" <td> 30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 5.457010e+06</td>\n",
" <td> 1092.0</td>\n",
" <td> 454750.833333</td>\n",
" <td> 2442174</td>\n",
" <td> 12</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"12\" valign=\"top\">2011</th>\n",
" <th>1 </th>\n",
" <td> 6.750724e+06</td>\n",
" <td> 2100.0</td>\n",
" <td> 519286.461538</td>\n",
" <td> 2734074</td>\n",
" <td> 15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 1.469910e+07</td>\n",
" <td> 1092.0</td>\n",
" <td> 639091.391304</td>\n",
" <td> 3005184</td>\n",
" <td> 23</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 3.742266e+06</td>\n",
" <td> 34.0</td>\n",
" <td> 267304.714286</td>\n",
" <td> 2900772</td>\n",
" <td> 14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 8.312478e+06</td>\n",
" <td> 3276.0</td>\n",
" <td> 593748.428571</td>\n",
" <td> 2638608</td>\n",
" <td> 14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 1.131481e+07</td>\n",
" <td> 15250.0</td>\n",
" <td> 870369.692308</td>\n",
" <td> 2366364</td>\n",
" <td> 13</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 1.356727e+07</td>\n",
" <td> 3000.0</td>\n",
" <td> 646060.380952</td>\n",
" <td> 2747598</td>\n",
" <td> 21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 1.848910e+07</td>\n",
" <td> 750.0</td>\n",
" <td> 770379.333333</td>\n",
" <td> 2986746</td>\n",
" <td> 24</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 6.147310e+06</td>\n",
" <td> 1680.0</td>\n",
" <td> 472870.000000</td>\n",
" <td> 2398158</td>\n",
" <td> 13</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 5.067498e+06</td>\n",
" <td> 34650.0</td>\n",
" <td> 563055.333333</td>\n",
" <td> 1806000</td>\n",
" <td> 10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 4.856187e+06</td>\n",
" <td> 2500.0</td>\n",
" <td> 323745.800000</td>\n",
" <td> 1929438</td>\n",
" <td> 15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 6.971196e+06</td>\n",
" <td> 1500.0</td>\n",
" <td> 410070.352941</td>\n",
" <td> 2049642</td>\n",
" <td> 19</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 3.546365e+06</td>\n",
" <td> 1135.0</td>\n",
" <td> 354636.500000</td>\n",
" <td> 1341942</td>\n",
" <td> 10</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"12\" valign=\"top\">2012</th>\n",
" <th>1 </th>\n",
" <td> 3.917386e+06</td>\n",
" <td> 2000.0</td>\n",
" <td> 261159.066667</td>\n",
" <td> 2385264</td>\n",
" <td> 15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 1.379834e+07</td>\n",
" <td> 2500.0</td>\n",
" <td> 689917.000000</td>\n",
" <td> 2364978</td>\n",
" <td> 20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 1.691143e+07</td>\n",
" <td> 15000.0</td>\n",
" <td> 768701.181818</td>\n",
" <td> 1959804</td>\n",
" <td> 24</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 2.625144e+07</td>\n",
" <td> 515.0</td>\n",
" <td> 729206.638889</td>\n",
" <td> 2235282</td>\n",
" <td> 36</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 4.031427e+07</td>\n",
" <td> 2500.0</td>\n",
" <td> 876397.260870</td>\n",
" <td> 2609208</td>\n",
" <td> 46</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 5.365699e+07</td>\n",
" <td> 1500.0</td>\n",
" <td> 941350.666667</td>\n",
" <td> 3598560</td>\n",
" <td> 57</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 4.123087e+07</td>\n",
" <td> 1000.0</td>\n",
" <td> 615386.134328</td>\n",
" <td> 2938530</td>\n",
" <td> 67</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 3.863330e+07</td>\n",
" <td> 500.0</td>\n",
" <td> 878029.500000</td>\n",
" <td> 2640708</td>\n",
" <td> 44</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 3.528498e+07</td>\n",
" <td> 3000.0</td>\n",
" <td> 860609.390244</td>\n",
" <td> 2478126</td>\n",
" <td> 41</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 4.205264e+07</td>\n",
" <td> 1500.0</td>\n",
" <td> 1078272.820513</td>\n",
" <td> 2734158</td>\n",
" <td> 41</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 3.706462e+07</td>\n",
" <td> 5000.0</td>\n",
" <td> 772179.666667</td>\n",
" <td> 2583168</td>\n",
" <td> 48</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 3.180246e+07</td>\n",
" <td> 2734.0</td>\n",
" <td> 722783.159091</td>\n",
" <td> 2502276</td>\n",
" <td> 44</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"12\" valign=\"top\">2013</th>\n",
" <th>1 </th>\n",
" <td> 2.426841e+07</td>\n",
" <td> 2600.0</td>\n",
" <td> 970736.560000</td>\n",
" <td> 3432408</td>\n",
" <td> 25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 1.901739e+07</td>\n",
" <td> 4685.0</td>\n",
" <td> 950869.550000</td>\n",
" <td> 2921352</td>\n",
" <td> 20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 3.043870e+07</td>\n",
" <td> 2000.0</td>\n",
" <td> 869677.285714</td>\n",
" <td> 2816016</td>\n",
" <td> 35</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 6.011173e+07</td>\n",
" <td> 2000.0</td>\n",
" <td> 910783.727273</td>\n",
" <td> 3438666</td>\n",
" <td> 66</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 3.657947e+07</td>\n",
" <td> 3002.0</td>\n",
" <td> 914486.800000</td>\n",
" <td> 3102960</td>\n",
" <td> 40</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 4.927518e+07</td>\n",
" <td> 5000.0</td>\n",
" <td> 1071199.608696</td>\n",
" <td> 4127004</td>\n",
" <td> 46</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 3.064478e+07</td>\n",
" <td> 3000.0</td>\n",
" <td> 806441.631579</td>\n",
" <td> 3012366</td>\n",
" <td> 38</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 4.340076e+07</td>\n",
" <td> 2000.0</td>\n",
" <td> 818882.245283</td>\n",
" <td> 2844870</td>\n",
" <td> 53</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 2.181848e+07</td>\n",
" <td> 550.0</td>\n",
" <td> 727282.666667</td>\n",
" <td> 2410380</td>\n",
" <td> 30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 3.418002e+07</td>\n",
" <td> 78.0</td>\n",
" <td> 621454.945455</td>\n",
" <td> 2170644</td>\n",
" <td> 55</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 3.409738e+07</td>\n",
" <td> 2000.0</td>\n",
" <td> 710362.145833</td>\n",
" <td> 2092524</td>\n",
" <td> 48</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 2.286589e+07</td>\n",
" <td> 1500.0</td>\n",
" <td> 586304.871795</td>\n",
" <td> 2108946</td>\n",
" <td> 39</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"9\" valign=\"top\">2014</th>\n",
" <th>1 </th>\n",
" <td> 1.511416e+07</td>\n",
" <td> 2750.0</td>\n",
" <td> 604566.480000</td>\n",
" <td> 2096178</td>\n",
" <td> 26</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 1.999784e+07</td>\n",
" <td> 720.0</td>\n",
" <td> 689580.620690</td>\n",
" <td> 2987880</td>\n",
" <td> 29</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 4.834031e+07</td>\n",
" <td> 500.0</td>\n",
" <td> 966806.160000</td>\n",
" <td> 11137224</td>\n",
" <td> 50</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 7.098842e+07</td>\n",
" <td> 8862.0</td>\n",
" <td> 1774710.500000</td>\n",
" <td> 9429840</td>\n",
" <td> 41</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 6.663518e+07</td>\n",
" <td> 200.0</td>\n",
" <td> 666351.750000</td>\n",
" <td> 4461240</td>\n",
" <td> 103</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 4.614625e+07</td>\n",
" <td> 2750.0</td>\n",
" <td> 870684.000000</td>\n",
" <td> 5702130</td>\n",
" <td> 57</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 5.685632e+07</td>\n",
" <td> 5000.0</td>\n",
" <td> 1496218.842105</td>\n",
" <td> 16839186</td>\n",
" <td> 38</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 1.671034e+07</td>\n",
" <td> 4000.0</td>\n",
" <td> 1044396.000000</td>\n",
" <td> 4062576</td>\n",
" <td> 17</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 4.950000e+05</td>\n",
" <td> 5000.0</td>\n",
" <td> 247500.000000</td>\n",
" <td> 490000</td>\n",
" <td> 3</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 21,
"text": [
" sum min mean \\\n",
"Date Completion Date Completion \n",
"1995 1 3.741480e+05 250.0 24943.200000 \n",
" 2 9.900000e+04 1000.0 8250.000000 \n",
" 3 3.974400e+04 1000.0 3613.090909 \n",
" 4 1.850100e+05 1250.0 23126.250000 \n",
" 5 4.950000e+04 1250.0 9900.000000 \n",
" 6 8.473500e+04 125.0 8473.500000 \n",
" 7 1.409300e+05 500.0 10840.769231 \n",
" 8 1.387000e+05 500.0 13870.000000 \n",
" 9 6.214000e+04 390.0 4142.666667 \n",
" 10 8.574800e+04 500.0 9527.555556 \n",
" 11 6.563180e+05 1000.0 46879.857143 \n",
" 12 6.436840e+05 500.0 42912.266667 \n",
"1996 1 6.160000e+04 200.0 8800.000000 \n",
" 2 9.020000e+04 300.0 6938.461538 \n",
" 3 1.253420e+05 700.0 12534.200000 \n",
" 4 1.329720e+05 500.0 16621.500000 \n",
" 5 1.911160e+05 500.0 8687.090909 \n",
" 6 7.400000e+04 500.0 10571.428571 \n",
" 7 1.133960e+05 250.0 10308.727273 \n",
" 8 1.389160e+06 750.0 99225.714286 \n",
" 9 2.037860e+05 100.0 11987.411765 \n",
" 10 9.909160e+05 1000.0 43083.304348 \n",
" 11 5.309100e+05 750.0 22121.250000 \n",
" 12 2.250000e+04 750.0 4500.000000 \n",
"1997 1 1.109234e+06 300.0 52820.666667 \n",
" 2 1.113189e+06 350.0 32740.852941 \n",
" 3 5.329040e+05 200.0 26645.200000 \n",
" 4 3.164067e+06 165.0 98877.093750 \n",
" 5 1.159072e+06 150.0 28976.800000 \n",
" 6 8.724000e+04 250.0 10905.000000 \n",
" 7 3.365410e+05 455.0 12019.321429 \n",
" 8 5.438300e+05 1000.0 19422.500000 \n",
" 9 3.332420e+05 1000.0 15868.666667 \n",
" 10 2.867980e+05 300.0 13036.272727 \n",
" 11 3.210940e+05 210.0 18887.882353 \n",
" 12 7.734600e+04 750.0 7031.454545 \n",
"1998 1 8.270000e+04 1000.0 7518.181818 \n",
" 2 5.372250e+05 125.0 41325.000000 \n",
" 3 3.337900e+05 500.0 16689.500000 \n",
" 4 4.312280e+05 250.0 25366.352941 \n",
" 5 2.778140e+05 500.0 16342.000000 \n",
" 6 1.085080e+05 500.0 18084.666667 \n",
" 7 8.501180e+05 1000.0 47228.777778 \n",
" 8 5.296940e+05 750.0 37835.285714 \n",
" 9 3.083070e+05 200.0 23715.923077 \n",
" 10 2.681720e+05 300.0 20628.615385 \n",
" 11 2.904000e+04 500.0 5808.000000 \n",
" 12 1.693826e+06 250.0 67753.040000 \n",
"1999 1 4.460020e+05 1500.0 49555.777778 \n",
" 2 6.518080e+05 2000.0 59255.272727 \n",
" 3 1.058678e+06 1000.0 58815.444444 \n",
" 4 9.688200e+05 500.0 42122.608696 \n",
" 5 1.720934e+06 300.0 63738.296296 \n",
" 6 7.136660e+05 2500.0 71366.600000 \n",
" 7 1.049380e+05 750.0 8744.833333 \n",
" 8 3.588360e+05 500.0 27602.769231 \n",
" 9 9.350820e+05 500.0 42503.727273 \n",
" 10 1.454814e+06 750.0 46929.483871 \n",
" 11 4.654620e+05 500.0 33247.285714 \n",
" 12 6.654860e+05 1500.0 36971.444444 \n",
"2000 1 6.939000e+05 1000.0 43368.750000 \n",
" 2 9.309050e+05 500.0 62060.333333 \n",
" 3 1.287680e+06 500.0 55986.086957 \n",
" 4 2.604500e+05 500.0 43408.333333 \n",
" 5 7.353810e+05 500.0 19875.162162 \n",
" 6 8.343320e+05 500.0 39730.095238 \n",
" 7 5.598960e+05 500.0 25449.818182 \n",
" 8 6.572230e+05 125.0 34590.684211 \n",
" 9 9.984780e+05 500.0 23220.418605 \n",
" 10 8.372700e+05 1500.0 41863.500000 \n",
" 11 6.463580e+05 500.0 25854.320000 \n",
" 12 1.404462e+06 400.0 82615.411765 \n",
"2001 1 1.934980e+05 1000.0 14884.461538 \n",
" 2 3.567860e+05 500.0 12742.357143 \n",
" 3 1.106452e+06 10.0 42555.846154 \n",
" 4 1.158148e+06 750.0 28247.512195 \n",
" 5 8.629560e+05 500.0 19176.800000 \n",
" 6 5.240800e+05 500.0 29115.555556 \n",
" 7 1.565062e+06 500.0 31301.240000 \n",
" 8 1.100780e+06 500.0 44031.200000 \n",
" 9 1.199010e+06 200.0 29975.250000 \n",
" 10 4.574500e+05 500.0 28590.625000 \n",
" 11 6.584960e+05 300.0 26339.840000 \n",
" 12 8.726840e+05 500.0 31167.285714 \n",
"2002 1 3.735860e+05 5.0 15566.083333 \n",
" 2 1.042553e+06 500.0 32579.781250 \n",
" 3 7.065200e+05 1000.0 33643.809524 \n",
" 4 7.950950e+05 600.0 23385.147059 \n",
" 5 1.615380e+06 300.0 42510.000000 \n",
" 6 1.421650e+06 300.0 50773.214286 \n",
" 7 1.672840e+05 1000.0 16728.400000 \n",
" 8 9.861600e+05 1500.0 39446.400000 \n",
" 9 3.108150e+05 1000.0 17267.500000 \n",
" 10 2.594834e+06 300.0 64870.850000 \n",
" 11 6.904480e+05 1000.0 32878.476190 \n",
" 12 1.100143e+06 200.0 32357.147059 \n",
"2003 1 8.252480e+05 1000.0 35880.347826 \n",
" 2 4.597240e+05 750.0 16418.714286 \n",
" 3 5.118400e+05 250.0 18957.037037 \n",
" 4 8.217640e+05 252.0 19110.790698 \n",
" 5 1.997662e+06 300.0 40768.612245 \n",
" 6 4.168880e+05 500.0 17370.333333 \n",
" 7 1.036856e+06 500.0 28023.135135 \n",
" 8 2.480822e+06 250.0 49616.440000 \n",
" 9 2.230037e+06 420.0 51861.325581 \n",
" 10 2.553476e+06 200.0 65473.743590 \n",
" 11 1.605516e+06 1000.0 61750.615385 \n",
" 12 1.681698e+06 1092.0 73117.304348 \n",
"2004 1 3.739991e+06 300.0 81304.152174 \n",
" 2 2.563420e+06 1500.0 59614.418605 \n",
" 3 1.386604e+06 400.0 33819.609756 \n",
" 4 2.768148e+06 250.0 47726.689655 \n",
" 5 2.960010e+06 1000.0 47742.096774 \n",
" 6 2.303244e+06 1000.0 71976.375000 \n",
" 7 2.607676e+06 1008.0 54326.583333 \n",
" 8 2.845382e+06 1000.0 61856.130435 \n",
" 9 3.714675e+06 504.0 80753.804348 \n",
" 10 3.831094e+06 1500.0 68412.392857 \n",
" 11 2.665922e+06 504.0 59242.711111 \n",
" 12 2.039320e+06 1464.0 49739.512195 \n",
"2005 1 4.154132e+06 1500.0 79887.153846 \n",
" 2 5.929679e+06 250.0 83516.605634 \n",
" 3 5.801877e+06 1000.0 82883.957143 \n",
" 4 9.336383e+06 250.0 148196.555556 \n",
" 5 6.401764e+06 1000.0 83139.792208 \n",
" 6 3.364150e+08 125.0 5514999.344262 \n",
" 7 4.353896e+06 500.0 79161.745455 \n",
" 8 7.763106e+06 500.0 87225.910112 \n",
" 9 7.454514e+06 250.0 86680.395349 \n",
" 10 6.674524e+06 500.0 115078.000000 \n",
" 11 6.908964e+06 250.0 86362.050000 \n",
" 12 6.894696e+06 250.0 93171.567568 \n",
"2006 1 8.439878e+06 1000.0 118871.521127 \n",
" 2 6.742874e+06 10.0 88722.026316 \n",
" 3 7.083059e+06 250.0 89658.974684 \n",
" 4 8.782921e+06 500.0 125470.300000 \n",
" 5 8.007030e+06 500.0 96470.240964 \n",
" 6 6.472805e+06 1000.0 72728.146067 \n",
" 7 5.468346e+06 600.0 84128.400000 \n",
" 8 6.690797e+06 7.0 83634.962500 \n",
" 9 1.200973e+07 250.0 99253.960330 \n",
" 10 9.283954e+06 500.0 92839.540000 \n",
" 11 6.813685e+06 150.0 77428.238636 \n",
" 12 1.169962e+07 500.0 93596.960000 \n",
"2007 1 8.852261e+06 500.0 79038.044643 \n",
" 2 1.051927e+07 150.0 84832.846774 \n",
" 3 1.158887e+07 200.0 68981.352376 \n",
" 4 8.274556e+06 250.0 81926.297030 \n",
" 5 1.219452e+07 100.0 78170.032051 \n",
" 6 8.450540e+06 500.0 73482.956522 \n",
" 7 1.069589e+08 80.0 1304376.292683 \n",
" 8 7.284071e+06 500.0 72840.710000 \n",
" 9 7.021004e+06 500.0 66866.704762 \n",
" 10 8.562518e+06 200.0 78555.211009 \n",
" 11 5.945241e+06 420.0 100766.796610 \n",
" 12 3.089688e+06 500.0 83505.081081 \n",
"2008 1 3.827363e+06 300.0 89008.441860 \n",
" 2 1.069694e+07 420.0 93832.780702 \n",
" 3 7.379142e+06 420.0 83853.886364 \n",
" 4 6.478652e+06 420.0 73621.045455 \n",
" 5 9.575646e+06 420.0 85496.839286 \n",
" 6 6.145975e+06 400.0 100753.688525 \n",
" 7 1.327278e+07 153.0 181818.945205 \n",
" 8 3.879611e+08 12.5 3803540.573529 \n",
" 9 1.456046e+07 420.0 128853.663717 \n",
" 10 5.121421e+06 420.0 124912.707317 \n",
" 11 7.872558e+06 420.0 129058.327869 \n",
" 12 4.072110e+06 300.0 88524.139128 \n",
"2009 1 7.556069e+06 126.0 103507.794521 \n",
" 2 5.507734e+06 20.0 94960.931034 \n",
" 3 4.920064e+06 420.0 136668.444444 \n",
" 4 7.716132e+06 1008.0 164173.021277 \n",
" 5 6.243370e+06 1000.0 164299.210526 \n",
" 6 5.903134e+06 2000.0 227043.615385 \n",
" 7 3.406900e+06 1000.0 179310.526316 \n",
" 8 4.990600e+06 2000.0 216982.608696 \n",
" 9 5.430216e+06 1000.0 217208.640000 \n",
" 10 7.543756e+06 1000.0 301750.240000 \n",
" 11 7.659140e+05 500.0 38295.700000 \n",
" 12 5.122562e+06 65.0 256128.100000 \n",
"2010 1 5.021330e+06 924.0 251066.500000 \n",
" 2 9.687450e+06 1974.0 293559.090909 \n",
" 3 8.459016e+06 40.0 352459.000000 \n",
" 4 5.072038e+06 1000.0 362288.428571 \n",
" 5 8.589406e+06 550.0 373452.434783 \n",
" 6 4.429673e+06 500.0 246092.944444 \n",
" 7 7.370984e+06 3000.0 387946.526316 \n",
" 8 2.478625e+07 168.0 1126647.681818 \n",
" 9 4.549372e+06 500.0 227468.600000 \n",
" 10 7.383862e+06 2000.0 351612.476190 \n",
" 11 2.047009e+07 1000.0 682336.366667 \n",
" 12 5.457010e+06 1092.0 454750.833333 \n",
"2011 1 6.750724e+06 2100.0 519286.461538 \n",
" 2 1.469910e+07 1092.0 639091.391304 \n",
" 3 3.742266e+06 34.0 267304.714286 \n",
" 4 8.312478e+06 3276.0 593748.428571 \n",
" 5 1.131481e+07 15250.0 870369.692308 \n",
" 6 1.356727e+07 3000.0 646060.380952 \n",
" 7 1.848910e+07 750.0 770379.333333 \n",
" 8 6.147310e+06 1680.0 472870.000000 \n",
" 9 5.067498e+06 34650.0 563055.333333 \n",
" 10 4.856187e+06 2500.0 323745.800000 \n",
" 11 6.971196e+06 1500.0 410070.352941 \n",
" 12 3.546365e+06 1135.0 354636.500000 \n",
"2012 1 3.917386e+06 2000.0 261159.066667 \n",
" 2 1.379834e+07 2500.0 689917.000000 \n",
" 3 1.691143e+07 15000.0 768701.181818 \n",
" 4 2.625144e+07 515.0 729206.638889 \n",
" 5 4.031427e+07 2500.0 876397.260870 \n",
" 6 5.365699e+07 1500.0 941350.666667 \n",
" 7 4.123087e+07 1000.0 615386.134328 \n",
" 8 3.863330e+07 500.0 878029.500000 \n",
" 9 3.528498e+07 3000.0 860609.390244 \n",
" 10 4.205264e+07 1500.0 1078272.820513 \n",
" 11 3.706462e+07 5000.0 772179.666667 \n",
" 12 3.180246e+07 2734.0 722783.159091 \n",
"2013 1 2.426841e+07 2600.0 970736.560000 \n",
" 2 1.901739e+07 4685.0 950869.550000 \n",
" 3 3.043870e+07 2000.0 869677.285714 \n",
" 4 6.011173e+07 2000.0 910783.727273 \n",
" 5 3.657947e+07 3002.0 914486.800000 \n",
" 6 4.927518e+07 5000.0 1071199.608696 \n",
" 7 3.064478e+07 3000.0 806441.631579 \n",
" 8 4.340076e+07 2000.0 818882.245283 \n",
" 9 2.181848e+07 550.0 727282.666667 \n",
" 10 3.418002e+07 78.0 621454.945455 \n",
" 11 3.409738e+07 2000.0 710362.145833 \n",
" 12 2.286589e+07 1500.0 586304.871795 \n",
"2014 1 1.511416e+07 2750.0 604566.480000 \n",
" 2 1.999784e+07 720.0 689580.620690 \n",
" 3 4.834031e+07 500.0 966806.160000 \n",
" 4 7.098842e+07 8862.0 1774710.500000 \n",
" 5 6.663518e+07 200.0 666351.750000 \n",
" 6 4.614625e+07 2750.0 870684.000000 \n",
" 7 5.685632e+07 5000.0 1496218.842105 \n",
" 8 1.671034e+07 4000.0 1044396.000000 \n",
" 9 4.950000e+05 5000.0 247500.000000 \n",
"\n",
" max size \n",
"Date Completion Date Completion \n",
"1995 1 279888 17 \n",
" 2 60000 14 \n",
" 3 20244 12 \n",
" 4 80000 10 \n",
" 5 40000 6 \n",
" 6 38500 10 \n",
" 7 60480 13 \n",
" 8 50400 11 \n",
" 9 15000 18 \n",
" 10 55000 9 \n",
" 11 294000 15 \n",
" 12 493500 16 \n",
"1996 1 33000 7 \n",
" 2 55000 14 \n",
" 3 50442 11 \n",
" 4 55986 8 \n",
" 5 82500 22 \n",
" 6 37500 9 \n",
" 7 25780 11 \n",
" 8 642600 14 \n",
" 9 87000 18 \n",
" 10 338352 23 \n",
" 11 200000 24 \n",
" 12 8000 5 \n",
"1997 1 588000 21 \n",
" 2 317520 34 \n",
" 3 199500 21 \n",
" 4 2646000 32 \n",
" 5 611100 43 \n",
" 6 37464 8 \n",
" 7 71000 28 \n",
" 8 105000 28 \n",
" 9 55000 21 \n",
" 10 66738 22 \n",
" 11 63000 21 \n",
" 12 19110 12 \n",
"1998 1 30660 12 \n",
" 2 205380 13 \n",
" 3 120000 20 \n",
" 4 136710 17 \n",
" 5 103530 22 \n",
" 6 76000 10 \n",
" 7 357000 19 \n",
" 8 315000 19 \n",
" 9 126000 15 \n",
" 10 132720 20 \n",
" 11 17000 8 \n",
" 12 874608 29 \n",
"1999 1 134022 9 \n",
" 2 204204 11 \n",
" 3 273798 19 \n",
" 4 280854 25 \n",
" 5 222432 28 \n",
" 6 210462 11 \n",
" 7 45000 14 \n",
" 8 112056 15 \n",
" 9 207900 25 \n",
" 10 205800 31 \n",
" 11 127008 15 \n",
" 12 169470 18 \n",
"2000 1 237500 17 \n",
" 2 304248 17 \n",
" 3 222474 24 \n",
" 4 214200 7 \n",
" 5 174930 38 \n",
" 6 255192 23 \n",
" 7 117700 25 \n",
" 8 231000 23 \n",
" 9 210000 46 \n",
" 10 180000 20 \n",
" 11 133308 25 \n",
" 12 642000 18 \n",
"2001 1 64368 17 \n",
" 2 116844 33 \n",
" 3 382200 28 \n",
" 4 185766 42 \n",
" 5 103250 47 \n",
" 6 105552 18 \n",
" 7 420000 54 \n",
" 8 315000 27 \n",
" 9 334320 42 \n",
" 10 152502 21 \n",
" 11 210000 28 \n",
" 12 210000 29 \n",
"2002 1 115000 24 \n",
" 2 219408 35 \n",
" 3 302064 23 \n",
" 4 210000 37 \n",
" 5 315000 40 \n",
" 6 270480 30 \n",
" 7 45000 14 \n",
" 8 258174 26 \n",
" 9 146580 22 \n",
" 10 336000 41 \n",
" 11 224448 22 \n",
" 12 304038 36 \n",
"2003 1 210000 25 \n",
" 2 103500 32 \n",
" 3 211260 28 \n",
" 4 168000 44 \n",
" 5 218568 49 \n",
" 6 156996 26 \n",
" 7 210000 41 \n",
" 8 210000 52 \n",
" 9 278544 46 \n",
" 10 365400 40 \n",
" 11 336000 28 \n",
" 12 408282 23 \n",
"2004 1 630000 46 \n",
" 2 228060 43 \n",
" 3 252000 43 \n",
" 4 216720 58 \n",
" 5 254520 66 \n",
" 6 529032 33 \n",
" 7 333564 49 \n",
" 8 264432 46 \n",
" 9 613000 48 \n",
" 10 285600 60 \n",
" 11 273000 45 \n",
" 12 273000 41 \n",
"2005 1 336000 54 \n",
" 2 394800 72 \n",
" 3 529032 72 \n",
" 4 3684240 64 \n",
" 5 420000 77 \n",
" 6 331061632 61 \n",
" 7 420000 56 \n",
" 8 650076 96 \n",
" 9 1260000 87 \n",
" 10 431928 58 \n",
" 11 443856 80 \n",
" 12 558642 75 \n",
"2006 1 614124 75 \n",
" 2 435708 77 \n",
" 3 483000 81 \n",
" 4 3023454 71 \n",
" 5 599550 84 \n",
" 6 456540 90 \n",
" 7 357000 65 \n",
" 8 428400 81 \n",
" 9 504000 126 \n",
" 10 420000 101 \n",
" 11 391860 88 \n",
" 12 429072 126 \n",
"2007 1 416304 113 \n",
" 2 2772588 124 \n",
" 3 426972 168 \n",
" 4 1017618 102 \n",
" 5 504000 158 \n",
" 6 681198 119 \n",
" 7 99000000 85 \n",
" 8 336000 106 \n",
" 9 378000 110 \n",
" 10 378000 112 \n",
" 11 1522800 60 \n",
" 12 389172 43 \n",
"2008 1 399000 48 \n",
" 2 424284 123 \n",
" 3 356874 91 \n",
" 4 345450 94 \n",
" 5 427140 113 \n",
" 6 453936 63 \n",
" 7 3158820 75 \n",
" 8 355529984 103 \n",
" 9 2352000 117 \n",
" 10 499800 41 \n",
" 11 1575000 63 \n",
" 12 463134 48 \n",
"2009 1 567000 74 \n",
" 2 637560 58 \n",
" 3 347214 37 \n",
" 4 527058 50 \n",
" 5 1479702 42 \n",
" 6 1447950 27 \n",
" 7 1430688 20 \n",
" 8 1530480 24 \n",
" 9 2267748 25 \n",
" 10 3579534 26 \n",
" 11 266532 21 \n",
" 12 3573780 22 \n",
"2010 1 3429678 20 \n",
" 2 2968182 33 \n",
" 3 3659712 24 \n",
" 4 3605532 14 \n",
" 5 3382848 23 \n",
" 6 2193366 18 \n",
" 7 3669036 20 \n",
" 8 10122000 22 \n",
" 9 1743798 21 \n",
" 10 2268966 22 \n",
" 11 12890625 30 \n",
" 12 2442174 12 \n",
"2011 1 2734074 15 \n",
" 2 3005184 23 \n",
" 3 2900772 14 \n",
" 4 2638608 14 \n",
" 5 2366364 13 \n",
" 6 2747598 21 \n",
" 7 2986746 24 \n",
" 8 2398158 13 \n",
" 9 1806000 10 \n",
" 10 1929438 15 \n",
" 11 2049642 19 \n",
" 12 1341942 10 \n",
"2012 1 2385264 15 \n",
" 2 2364978 20 \n",
" 3 1959804 24 \n",
" 4 2235282 36 \n",
" 5 2609208 46 \n",
" 6 3598560 57 \n",
" 7 2938530 67 \n",
" 8 2640708 44 \n",
" 9 2478126 41 \n",
" 10 2734158 41 \n",
" 11 2583168 48 \n",
" 12 2502276 44 \n",
"2013 1 3432408 25 \n",
" 2 2921352 20 \n",
" 3 2816016 35 \n",
" 4 3438666 66 \n",
" 5 3102960 40 \n",
" 6 4127004 46 \n",
" 7 3012366 38 \n",
" 8 2844870 53 \n",
" 9 2410380 30 \n",
" 10 2170644 55 \n",
" 11 2092524 48 \n",
" 12 2108946 39 \n",
"2014 1 2096178 26 \n",
" 2 2987880 29 \n",
" 3 11137224 50 \n",
" 4 9429840 41 \n",
" 5 4461240 103 \n",
" 6 5702130 57 \n",
" 7 16839186 38 \n",
" 8 4062576 17 \n",
" 9 490000 3 "
]
}
],
"prompt_number": 21
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"result.to_csv('/Users/mstacy/Desktop/ows-data/result.csv')\n",
"g1= grouped['Fluid Amount (gals)'].agg(['sum','min','mean','max','size'])\n",
"g1.to_csv('/Users/mstacy/Desktop/ows-data/groupbyYearMonth.csv')"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 23
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"#Group by Year and Month\n",
"grouped = result.groupby([result['Date Completion'].map(lambda x: x.year)])\n",
"g2=grouped['Fluid Amount (gals)'].agg(['sum','min','mean','max','size'])\n",
"g2"
],
"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> 2.559657e+06</td>\n",
" <td> 125.0</td>\n",
" <td> 18683.627737</td>\n",
" <td> 493500</td>\n",
" <td> 151</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1996</th>\n",
" <td> 3.925898e+06</td>\n",
" <td> 100.0</td>\n",
" <td> 24384.459627</td>\n",
" <td> 642600</td>\n",
" <td> 166</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1997</th>\n",
" <td> 9.064557e+06</td>\n",
" <td> 150.0</td>\n",
" <td> 32143.819149</td>\n",
" <td> 2646000</td>\n",
" <td> 291</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1998</th>\n",
" <td> 5.450422e+06</td>\n",
" <td> 125.0</td>\n",
" <td> 31688.500000</td>\n",
" <td> 874608</td>\n",
" <td> 204</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1999</th>\n",
" <td> 9.544526e+06</td>\n",
" <td> 300.0</td>\n",
" <td> 45887.144231</td>\n",
" <td> 280854</td>\n",
" <td> 221</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000</th>\n",
" <td> 9.846335e+06</td>\n",
" <td> 125.0</td>\n",
" <td> 37296.723485</td>\n",
" <td> 642000</td>\n",
" <td> 283</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2001</th>\n",
" <td> 1.005540e+07</td>\n",
" <td> 10.0</td>\n",
" <td> 28325.076056</td>\n",
" <td> 420000</td>\n",
" <td> 386</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2002</th>\n",
" <td> 1.180447e+07</td>\n",
" <td> 5.0</td>\n",
" <td> 36321.440000</td>\n",
" <td> 336000</td>\n",
" <td> 350</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2003</th>\n",
" <td> 1.662153e+07</td>\n",
" <td> 200.0</td>\n",
" <td> 40343.521845</td>\n",
" <td> 408282</td>\n",
" <td> 434</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2004</th>\n",
" <td> 3.342549e+07</td>\n",
" <td> 250.0</td>\n",
" <td> 59265.046099</td>\n",
" <td> 630000</td>\n",
" <td> 578</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2005</th>\n",
" <td> 4.080885e+08</td>\n",
" <td> 125.0</td>\n",
" <td> 488144.132775</td>\n",
" <td> 331061632</td>\n",
" <td> 852</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2006</th>\n",
" <td> 9.749470e+07</td>\n",
" <td> 7.0</td>\n",
" <td> 93118.145368</td>\n",
" <td> 3023454</td>\n",
" <td> 1065</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2007</th>\n",
" <td> 1.987414e+08</td>\n",
" <td> 80.0</td>\n",
" <td> 156736.120031</td>\n",
" <td> 99000000</td>\n",
" <td> 1300</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2008</th>\n",
" <td> 4.769642e+08</td>\n",
" <td> 12.5</td>\n",
" <td> 506331.411783</td>\n",
" <td> 355529984</td>\n",
" <td> 979</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2009</th>\n",
" <td> 6.510645e+07</td>\n",
" <td> 20.0</td>\n",
" <td> 158796.221951</td>\n",
" <td> 3579534</td>\n",
" <td> 426</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2010</th>\n",
" <td> 1.112765e+08</td>\n",
" <td> 40.0</td>\n",
" <td> 434673.753906</td>\n",
" <td> 12890625</td>\n",
" <td> 259</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2011</th>\n",
" <td> 1.034643e+08</td>\n",
" <td> 34.0</td>\n",
" <td> 556259.698925</td>\n",
" <td> 3005184</td>\n",
" <td> 191</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2012</th>\n",
" <td> 3.809187e+08</td>\n",
" <td> 500.0</td>\n",
" <td> 795237.432150</td>\n",
" <td> 3598560</td>\n",
" <td> 483</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2013</th>\n",
" <td> 4.066982e+08</td>\n",
" <td> 78.0</td>\n",
" <td> 821612.537374</td>\n",
" <td> 4127004</td>\n",
" <td> 495</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014</th>\n",
" <td> 3.412838e+08</td>\n",
" <td> 200.0</td>\n",
" <td> 966809.651558</td>\n",
" <td> 16839186</td>\n",
" <td> 364</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 26,
"text": [
" sum min mean max size\n",
"Date Completion \n",
"1995 2.559657e+06 125.0 18683.627737 493500 151\n",
"1996 3.925898e+06 100.0 24384.459627 642600 166\n",
"1997 9.064557e+06 150.0 32143.819149 2646000 291\n",
"1998 5.450422e+06 125.0 31688.500000 874608 204\n",
"1999 9.544526e+06 300.0 45887.144231 280854 221\n",
"2000 9.846335e+06 125.0 37296.723485 642000 283\n",
"2001 1.005540e+07 10.0 28325.076056 420000 386\n",
"2002 1.180447e+07 5.0 36321.440000 336000 350\n",
"2003 1.662153e+07 200.0 40343.521845 408282 434\n",
"2004 3.342549e+07 250.0 59265.046099 630000 578\n",
"2005 4.080885e+08 125.0 488144.132775 331061632 852\n",
"2006 9.749470e+07 7.0 93118.145368 3023454 1065\n",
"2007 1.987414e+08 80.0 156736.120031 99000000 1300\n",
"2008 4.769642e+08 12.5 506331.411783 355529984 979\n",
"2009 6.510645e+07 20.0 158796.221951 3579534 426\n",
"2010 1.112765e+08 40.0 434673.753906 12890625 259\n",
"2011 1.034643e+08 34.0 556259.698925 3005184 191\n",
"2012 3.809187e+08 500.0 795237.432150 3598560 483\n",
"2013 4.066982e+08 78.0 821612.537374 4127004 495\n",
"2014 3.412838e+08 200.0 966809.651558 16839186 364"
]
}
],
"prompt_number": 26
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"g2.to_csv('/Users/mstacy/Desktop/ows-data/groupbyYear.csv')"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 27
},
{
"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