Skip to content

Instantly share code, notes, and snippets.

@mbstacy

mbstacy/Pandas_groupby_mesonet

Created August 6, 2014 18:42
Show Gist options
  • Save mbstacy/98cb361b0bfc4983004b to your computer and use it in GitHub Desktop.
Save mbstacy/98cb361b0bfc4983004b to your computer and use it in GitHub Desktop.
Download ZIP
Pandas IO and Group By Weather Data Statisitcs
Raw
Pandas_groupby_mesonet
{
"metadata": {
"name": ""
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Pandas IO and Groupby example\n",
"\n",
"The data used in this example is from the Oklahoma Mesonet. Please review [Term of Use](https://www.mesonet.org/index.php/site/about/terms_of_use) from Oklahoma Mesonet.\n",
"\n",
"### Mesonet Get DataFrame\n",
"\n",
"This function returns a pandas dataframe of weather station data. Example [Oklahoma Mesonet Data url](http://www.mesonet.org/index.php/dataMdfMts/dataController/getFile/20140801nrmn/mts/TEXT/)"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"from pandas import read_fwf, concat, options\n",
"from datetime import datetime, timedelta\n",
"import numpy as np\n",
"\n",
"def get_mesonet_dataframe(start_date,end_date,site):\n",
" url_template = \"http://www.mesonet.org/index.php/dataMdfMts/dataController/getFile/%s%s/mts/TEXT/\"\n",
" day_count = (end_date - start_date).days + 1\n",
" df_pieces=[]\n",
" for single_date in (start_date + timedelta(n) for n in range(day_count)):\n",
" url = url_template % (single_date.strftime('%Y%m%d'),site)\n",
" df = read_fwf(url,header=2,widths=[5,6,6,7,7,7,7,6,7,7,7,8,9,6,7,7,7,7,7,7,7,8,8,8],\n",
" na_values=['-999','-998','-997','-996','-995'],skipfooter=1)\n",
" df[\"DATE\"]=single_date.date()\n",
" df_pieces.append(df)\n",
" return concat(df_pieces)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 17
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Retrieve Data"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"site=\"nrmn\" #Norman Mesonet site\n",
"start_date = datetime(2014,1,1)\n",
"end_date = datetime(2014,8,5)\n",
"df = get_mesonet_dataframe(start_date,end_date,site)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 11
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Pandas Groupby "
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# Groupby Site ID and Date and find the daily min, max, mean air temperature ('TAIR')\n",
"grouped =df.groupby(['STID','DATE'])\n",
"grouped['TAIR'].agg([np.min,np.mean,np.max,np.size])"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<pre>\n",
"&lt;class 'pandas.core.frame.DataFrame'&gt;\n",
"MultiIndex: 217 entries, (NRMN, 2014-01-01) to (NRMN, 2014-08-05)\n",
"Data columns (total 4 columns):\n",
"amin 217 non-null values\n",
"mean 217 non-null values\n",
"amax 217 non-null values\n",
"size 217 non-null values\n",
"dtypes: float64(4)\n",
"</pre>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 19,
"text": [
"<class 'pandas.core.frame.DataFrame'>\n",
"MultiIndex: 217 entries, (NRMN, 2014-01-01) to (NRMN, 2014-08-05)\n",
"Data columns (total 4 columns):\n",
"amin 217 non-null values\n",
"mean 217 non-null values\n",
"amax 217 non-null values\n",
"size 217 non-null values\n",
"dtypes: float64(4)"
]
}
],
"prompt_number": 19
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Adjust the Pandas Display Options\n",
"The display shows some useful information, but not able to see table dataset. Let's fix that with setting the max display columns and display rows. "
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# Set Pandas Display max column and rows \n",
"# options was imported from the pandas library - See Code line 1\n",
"# Max Columns is not needed for our example(Our grouped dataframe has 4 columns), but want to show how to set. \n",
"options.display.max_columns = 50\n",
"options.display.max_rows = 250\n",
"# Groupby Site ID and Date\n",
"grouped['TAIR'].agg([np.min,np.mean,np.max,np.size])"
],
"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>amin</th>\n",
" <th>mean</th>\n",
" <th>amax</th>\n",
" <th>size</th>\n",
" </tr>\n",
" <tr>\n",
" <th>STID</th>\n",
" <th>DATE</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th rowspan=\"217\" valign=\"top\">NRMN</th>\n",
" <th>2014-01-01</th>\n",
" <td> 0.3</td>\n",
" <td> 5.084375</td>\n",
" <td> 12.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-02</th>\n",
" <td> -9.5</td>\n",
" <td> -3.983333</td>\n",
" <td> 3.2</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-03</th>\n",
" <td> -4.9</td>\n",
" <td> 0.177083</td>\n",
" <td> 9.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-04</th>\n",
" <td> 3.3</td>\n",
" <td> 7.082986</td>\n",
" <td> 14.7</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-05</th>\n",
" <td> -8.7</td>\n",
" <td> -4.563194</td>\n",
" <td> 7.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-06</th>\n",
" <td>-15.4</td>\n",
" <td>-10.585764</td>\n",
" <td> -3.8</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-07</th>\n",
" <td> -6.5</td>\n",
" <td> -1.635764</td>\n",
" <td> 8.9</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-08</th>\n",
" <td> -0.8</td>\n",
" <td> 2.057639</td>\n",
" <td> 6.1</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-09</th>\n",
" <td> -0.3</td>\n",
" <td> 0.707639</td>\n",
" <td> 2.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-10</th>\n",
" <td> 2.3</td>\n",
" <td> 6.945833</td>\n",
" <td> 15.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-11</th>\n",
" <td> -0.8</td>\n",
" <td> 6.732292</td>\n",
" <td> 16.8</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-12</th>\n",
" <td> 3.7</td>\n",
" <td> 11.734375</td>\n",
" <td> 23.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-13</th>\n",
" <td> 4.6</td>\n",
" <td> 10.933571</td>\n",
" <td> 20.1</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-14</th>\n",
" <td> -0.1</td>\n",
" <td> 6.969444</td>\n",
" <td> 12.8</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-15</th>\n",
" <td> -4.8</td>\n",
" <td> 2.799653</td>\n",
" <td> 13.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-16</th>\n",
" <td> 1.9</td>\n",
" <td> 8.340625</td>\n",
" <td> 15.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-17</th>\n",
" <td> -3.9</td>\n",
" <td> 5.276736</td>\n",
" <td> 11.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-18</th>\n",
" <td> 3.2</td>\n",
" <td> 8.221181</td>\n",
" <td> 17.1</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-19</th>\n",
" <td> -3.8</td>\n",
" <td> 6.614236</td>\n",
" <td> 18.2</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-20</th>\n",
" <td> -1.2</td>\n",
" <td> 10.357986</td>\n",
" <td> 18.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-21</th>\n",
" <td> -6.0</td>\n",
" <td> 1.453472</td>\n",
" <td> 12.8</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-22</th>\n",
" <td> -5.8</td>\n",
" <td> 1.168056</td>\n",
" <td> 10.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-23</th>\n",
" <td> -9.1</td>\n",
" <td> -3.058681</td>\n",
" <td> 6.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-24</th>\n",
" <td>-13.7</td>\n",
" <td> -6.481250</td>\n",
" <td> 5.8</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-25</th>\n",
" <td> 0.5</td>\n",
" <td> 7.569792</td>\n",
" <td> 18.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-26</th>\n",
" <td> -0.5</td>\n",
" <td> 8.754861</td>\n",
" <td> 19.7</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-27</th>\n",
" <td> -6.7</td>\n",
" <td> -0.334375</td>\n",
" <td> 13.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-28</th>\n",
" <td>-10.4</td>\n",
" <td> -6.894444</td>\n",
" <td> -1.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-29</th>\n",
" <td> -9.5</td>\n",
" <td> -2.891197</td>\n",
" <td> 8.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-30</th>\n",
" <td> -0.5</td>\n",
" <td> 3.749306</td>\n",
" <td> 12.7</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-01-31</th>\n",
" <td> 0.9</td>\n",
" <td> 6.262153</td>\n",
" <td> 10.2</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-01</th>\n",
" <td> -2.6</td>\n",
" <td> -0.248611</td>\n",
" <td> 3.8</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-02</th>\n",
" <td> -6.0</td>\n",
" <td> -2.608333</td>\n",
" <td> 0.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-03</th>\n",
" <td>-10.4</td>\n",
" <td> -5.452778</td>\n",
" <td> 0.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-04</th>\n",
" <td> -1.0</td>\n",
" <td> -0.288889</td>\n",
" <td> 0.5</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-05</th>\n",
" <td>-12.3</td>\n",
" <td> -7.422917</td>\n",
" <td> 0.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-06</th>\n",
" <td>-13.4</td>\n",
" <td>-11.601389</td>\n",
" <td> -8.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-07</th>\n",
" <td> -9.8</td>\n",
" <td> -7.628472</td>\n",
" <td> -2.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-08</th>\n",
" <td> -3.7</td>\n",
" <td> -2.231944</td>\n",
" <td> 0.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-09</th>\n",
" <td> -0.9</td>\n",
" <td> -0.283681</td>\n",
" <td> 0.2</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-10</th>\n",
" <td> -7.5</td>\n",
" <td> -4.562153</td>\n",
" <td> -0.9</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-11</th>\n",
" <td> -8.2</td>\n",
" <td> -4.356597</td>\n",
" <td> 2.7</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-12</th>\n",
" <td> -6.6</td>\n",
" <td> 0.783333</td>\n",
" <td> 9.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-13</th>\n",
" <td> -6.1</td>\n",
" <td> 2.843056</td>\n",
" <td> 17.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-14</th>\n",
" <td> 2.3</td>\n",
" <td> 9.954861</td>\n",
" <td> 16.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-15</th>\n",
" <td> -2.0</td>\n",
" <td> 7.098264</td>\n",
" <td> 18.9</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-16</th>\n",
" <td> 1.9</td>\n",
" <td> 10.336806</td>\n",
" <td> 21.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-17</th>\n",
" <td> 11.4</td>\n",
" <td> 14.505556</td>\n",
" <td> 18.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-18</th>\n",
" <td> 2.7</td>\n",
" <td> 11.207986</td>\n",
" <td> 23.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-19</th>\n",
" <td> 8.0</td>\n",
" <td> 12.674275</td>\n",
" <td> 21.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-20</th>\n",
" <td> 9.0</td>\n",
" <td> 14.487153</td>\n",
" <td> 17.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-21</th>\n",
" <td> -3.7</td>\n",
" <td> 6.804167</td>\n",
" <td> 18.2</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-22</th>\n",
" <td> 5.9</td>\n",
" <td> 12.677083</td>\n",
" <td> 21.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-23</th>\n",
" <td> 2.5</td>\n",
" <td> 8.846875</td>\n",
" <td> 17.9</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-24</th>\n",
" <td> -2.0</td>\n",
" <td> 3.412847</td>\n",
" <td> 10.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-25</th>\n",
" <td> -0.1</td>\n",
" <td> 4.601042</td>\n",
" <td> 8.2</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-26</th>\n",
" <td> -8.6</td>\n",
" <td> -2.029167</td>\n",
" <td> 5.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-27</th>\n",
" <td> -6.0</td>\n",
" <td> 1.443750</td>\n",
" <td> 12.9</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-02-28</th>\n",
" <td> 4.7</td>\n",
" <td> 9.170833</td>\n",
" <td> 18.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-01</th>\n",
" <td> 4.0</td>\n",
" <td> 7.018403</td>\n",
" <td> 16.2</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-02</th>\n",
" <td>-11.6</td>\n",
" <td> -7.497569</td>\n",
" <td> 3.9</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-03</th>\n",
" <td>-15.0</td>\n",
" <td>-11.430208</td>\n",
" <td> -4.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-04</th>\n",
" <td> -8.9</td>\n",
" <td> -3.288889</td>\n",
" <td> 8.7</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-05</th>\n",
" <td> -0.9</td>\n",
" <td> 3.518056</td>\n",
" <td> 9.5</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-06</th>\n",
" <td> 0.5</td>\n",
" <td> 3.514931</td>\n",
" <td> 11.2</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-07</th>\n",
" <td> 2.9</td>\n",
" <td> 8.326042</td>\n",
" <td> 18.9</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-08</th>\n",
" <td> -0.2</td>\n",
" <td> 5.595139</td>\n",
" <td> 16.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-09</th>\n",
" <td> -1.5</td>\n",
" <td> 5.475347</td>\n",
" <td> 16.1</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-10</th>\n",
" <td> 2.0</td>\n",
" <td> 12.392708</td>\n",
" <td> 24.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-11</th>\n",
" <td> 11.9</td>\n",
" <td> 18.263194</td>\n",
" <td> 26.8</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-12</th>\n",
" <td> 2.4</td>\n",
" <td> 8.651736</td>\n",
" <td> 16.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-13</th>\n",
" <td> 0.9</td>\n",
" <td> 9.167014</td>\n",
" <td> 19.9</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-14</th>\n",
" <td> 9.6</td>\n",
" <td> 14.189583</td>\n",
" <td> 21.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-15</th>\n",
" <td> 10.1</td>\n",
" <td> 13.548958</td>\n",
" <td> 19.5</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-16</th>\n",
" <td> 1.9</td>\n",
" <td> 6.413542</td>\n",
" <td> 12.1</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-17</th>\n",
" <td> -4.1</td>\n",
" <td> 4.296875</td>\n",
" <td> 15.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-18</th>\n",
" <td> 7.7</td>\n",
" <td> 13.346528</td>\n",
" <td> 22.5</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-19</th>\n",
" <td> 2.1</td>\n",
" <td> 9.220139</td>\n",
" <td> 19.9</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-20</th>\n",
" <td> 0.6</td>\n",
" <td> 10.419792</td>\n",
" <td> 21.9</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-21</th>\n",
" <td> 11.1</td>\n",
" <td> 16.451736</td>\n",
" <td> 24.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-22</th>\n",
" <td> 5.7</td>\n",
" <td> 11.100694</td>\n",
" <td> 20.2</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-23</th>\n",
" <td> -0.3</td>\n",
" <td> 5.599306</td>\n",
" <td> 9.7</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-24</th>\n",
" <td> -2.0</td>\n",
" <td> 7.554861</td>\n",
" <td> 18.1</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-25</th>\n",
" <td> -1.8</td>\n",
" <td> 6.298611</td>\n",
" <td> 15.8</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-26</th>\n",
" <td> 4.4</td>\n",
" <td> 6.578472</td>\n",
" <td> 12.5</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-27</th>\n",
" <td> 8.4</td>\n",
" <td> 16.871875</td>\n",
" <td> 27.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-28</th>\n",
" <td> 6.3</td>\n",
" <td> 12.439931</td>\n",
" <td> 24.2</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-29</th>\n",
" <td> 0.2</td>\n",
" <td> 10.304861</td>\n",
" <td> 21.2</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-30</th>\n",
" <td> 9.2</td>\n",
" <td> 15.994444</td>\n",
" <td> 25.1</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-31</th>\n",
" <td> 13.0</td>\n",
" <td> 19.356250</td>\n",
" <td> 28.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-01</th>\n",
" <td> 10.4</td>\n",
" <td> 15.247222</td>\n",
" <td> 25.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-02</th>\n",
" <td> 14.1</td>\n",
" <td> 20.873264</td>\n",
" <td> 28.1</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-03</th>\n",
" <td> 19.9</td>\n",
" <td> 22.498958</td>\n",
" <td> 26.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-04</th>\n",
" <td> 3.3</td>\n",
" <td> 10.081250</td>\n",
" <td> 22.7</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-05</th>\n",
" <td> 4.9</td>\n",
" <td> 11.456944</td>\n",
" <td> 19.1</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-06</th>\n",
" <td> 6.9</td>\n",
" <td> 9.007986</td>\n",
" <td> 15.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-07</th>\n",
" <td> 6.3</td>\n",
" <td> 11.077778</td>\n",
" <td> 18.7</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-08</th>\n",
" <td> 6.4</td>\n",
" <td> 12.438542</td>\n",
" <td> 19.5</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-09</th>\n",
" <td> 3.5</td>\n",
" <td> 13.127984</td>\n",
" <td> 26.5</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-10</th>\n",
" <td> 15.6</td>\n",
" <td> 21.900694</td>\n",
" <td> 29.8</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-11</th>\n",
" <td> 11.5</td>\n",
" <td> 19.538889</td>\n",
" <td> 26.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-12</th>\n",
" <td> 17.0</td>\n",
" <td> 21.297569</td>\n",
" <td> 27.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-13</th>\n",
" <td> 15.9</td>\n",
" <td> 22.539931</td>\n",
" <td> 29.1</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-14</th>\n",
" <td> 1.6</td>\n",
" <td> 6.280208</td>\n",
" <td> 15.7</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-15</th>\n",
" <td> -1.6</td>\n",
" <td> 6.993056</td>\n",
" <td> 17.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-16</th>\n",
" <td> 7.1</td>\n",
" <td> 12.491289</td>\n",
" <td> 19.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-17</th>\n",
" <td> 7.3</td>\n",
" <td> 12.350000</td>\n",
" <td> 17.5</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-18</th>\n",
" <td> 4.0</td>\n",
" <td> 13.002083</td>\n",
" <td> 22.9</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-19</th>\n",
" <td> 10.9</td>\n",
" <td> 17.904861</td>\n",
" <td> 25.1</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-20</th>\n",
" <td> 14.1</td>\n",
" <td> 18.039583</td>\n",
" <td> 22.9</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-21</th>\n",
" <td> 14.8</td>\n",
" <td> 17.857292</td>\n",
" <td> 24.7</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-22</th>\n",
" <td> 10.5</td>\n",
" <td> 17.803915</td>\n",
" <td> 26.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-23</th>\n",
" <td> 13.6</td>\n",
" <td> 20.517708</td>\n",
" <td> 28.9</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-24</th>\n",
" <td> 15.8</td>\n",
" <td> 21.089583</td>\n",
" <td> 26.2</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-25</th>\n",
" <td> 8.9</td>\n",
" <td> 17.470833</td>\n",
" <td> 26.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-26</th>\n",
" <td> 16.5</td>\n",
" <td> 22.373958</td>\n",
" <td> 30.9</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-27</th>\n",
" <td> 19.5</td>\n",
" <td> 23.574653</td>\n",
" <td> 28.1</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-28</th>\n",
" <td> 10.9</td>\n",
" <td> 18.047222</td>\n",
" <td> 26.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-29</th>\n",
" <td> 10.4</td>\n",
" <td> 13.075694</td>\n",
" <td> 15.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-04-30</th>\n",
" <td> 7.1</td>\n",
" <td> 11.648905</td>\n",
" <td> 16.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-01</th>\n",
" <td> 2.4</td>\n",
" <td> 11.792014</td>\n",
" <td> 21.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-02</th>\n",
" <td> 5.1</td>\n",
" <td> 14.142708</td>\n",
" <td> 23.1</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-03</th>\n",
" <td> 9.0</td>\n",
" <td> 18.688542</td>\n",
" <td> 30.5</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-04</th>\n",
" <td> 15.4</td>\n",
" <td> 24.808333</td>\n",
" <td> 35.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-05</th>\n",
" <td> 17.7</td>\n",
" <td> 26.407986</td>\n",
" <td> 34.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-06</th>\n",
" <td> 19.1</td>\n",
" <td> 25.608333</td>\n",
" <td> 32.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-07</th>\n",
" <td> 19.3</td>\n",
" <td> 24.530903</td>\n",
" <td> 30.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-08</th>\n",
" <td> 17.4</td>\n",
" <td> 21.810069</td>\n",
" <td> 26.9</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-09</th>\n",
" <td> 12.8</td>\n",
" <td> 20.278853</td>\n",
" <td> 26.8</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-10</th>\n",
" <td> 15.6</td>\n",
" <td> 22.259722</td>\n",
" <td> 31.2</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-11</th>\n",
" <td> 21.5</td>\n",
" <td> 24.913194</td>\n",
" <td> 29.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-12</th>\n",
" <td> 14.0</td>\n",
" <td> 20.593056</td>\n",
" <td> 27.9</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-13</th>\n",
" <td> 8.4</td>\n",
" <td> 13.495833</td>\n",
" <td> 19.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-14</th>\n",
" <td> 7.4</td>\n",
" <td> 14.801042</td>\n",
" <td> 21.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-15</th>\n",
" <td> 6.1</td>\n",
" <td> 14.645833</td>\n",
" <td> 22.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-16</th>\n",
" <td> 5.6</td>\n",
" <td> 15.997222</td>\n",
" <td> 25.5</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-17</th>\n",
" <td> 10.5</td>\n",
" <td> 16.839931</td>\n",
" <td> 23.2</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-18</th>\n",
" <td> 11.8</td>\n",
" <td> 17.163194</td>\n",
" <td> 26.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-19</th>\n",
" <td> 17.9</td>\n",
" <td> 23.043056</td>\n",
" <td> 29.9</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-20</th>\n",
" <td> 19.4</td>\n",
" <td> 25.233101</td>\n",
" <td> 32.5</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-21</th>\n",
" <td> 20.4</td>\n",
" <td> 25.975000</td>\n",
" <td> 31.9</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-22</th>\n",
" <td> 19.3</td>\n",
" <td> 25.427431</td>\n",
" <td> 32.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-23</th>\n",
" <td> 19.8</td>\n",
" <td> 23.970383</td>\n",
" <td> 29.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-24</th>\n",
" <td> 17.9</td>\n",
" <td> 21.275000</td>\n",
" <td> 27.9</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-25</th>\n",
" <td> 19.1</td>\n",
" <td> 22.554167</td>\n",
" <td> 28.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-26</th>\n",
" <td> 19.2</td>\n",
" <td> 22.575000</td>\n",
" <td> 27.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-27</th>\n",
" <td> 18.0</td>\n",
" <td> 19.733681</td>\n",
" <td> 23.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-28</th>\n",
" <td> 16.7</td>\n",
" <td> 21.272917</td>\n",
" <td> 28.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-29</th>\n",
" <td> 16.1</td>\n",
" <td> 24.035069</td>\n",
" <td> 31.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-30</th>\n",
" <td> 18.7</td>\n",
" <td> 23.379514</td>\n",
" <td> 29.7</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-05-31</th>\n",
" <td> 19.1</td>\n",
" <td> 22.927778</td>\n",
" <td> 29.5</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-01</th>\n",
" <td> 20.2</td>\n",
" <td> 24.706597</td>\n",
" <td> 31.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-02</th>\n",
" <td> 18.8</td>\n",
" <td> 26.048611</td>\n",
" <td> 32.8</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-03</th>\n",
" <td> 22.1</td>\n",
" <td> 27.574306</td>\n",
" <td> 33.8</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-04</th>\n",
" <td> 22.5</td>\n",
" <td> 28.584028</td>\n",
" <td> 36.2</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-05</th>\n",
" <td> 23.0</td>\n",
" <td> 28.317708</td>\n",
" <td> 35.2</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-06</th>\n",
" <td> 19.0</td>\n",
" <td> 25.737500</td>\n",
" <td> 32.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-07</th>\n",
" <td> 18.3</td>\n",
" <td> 23.794792</td>\n",
" <td> 29.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-08</th>\n",
" <td> 19.1</td>\n",
" <td> 21.564583</td>\n",
" <td> 28.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-09</th>\n",
" <td> 16.4</td>\n",
" <td> 20.628472</td>\n",
" <td> 25.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-10</th>\n",
" <td> 16.7</td>\n",
" <td> 20.752083</td>\n",
" <td> 27.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-11</th>\n",
" <td> 14.7</td>\n",
" <td> 22.897880</td>\n",
" <td> 31.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-12</th>\n",
" <td> 18.3</td>\n",
" <td> 23.904514</td>\n",
" <td> 30.7</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-13</th>\n",
" <td> 16.0</td>\n",
" <td> 22.328070</td>\n",
" <td> 28.2</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-14</th>\n",
" <td> 21.5</td>\n",
" <td> 25.246181</td>\n",
" <td> 31.8</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-15</th>\n",
" <td> 23.9</td>\n",
" <td> 27.081944</td>\n",
" <td> 31.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-16</th>\n",
" <td> 23.2</td>\n",
" <td> 27.225177</td>\n",
" <td> 32.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-17</th>\n",
" <td> 23.7</td>\n",
" <td> 28.008681</td>\n",
" <td> 32.7</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-18</th>\n",
" <td> 24.1</td>\n",
" <td> 27.834722</td>\n",
" <td> 32.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-19</th>\n",
" <td> 19.6</td>\n",
" <td> 24.392361</td>\n",
" <td> 29.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-20</th>\n",
" <td> 20.1</td>\n",
" <td> 25.649630</td>\n",
" <td> 31.8</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-21</th>\n",
" <td> 22.5</td>\n",
" <td> 26.780208</td>\n",
" <td> 31.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-22</th>\n",
" <td> 21.6</td>\n",
" <td> 25.604514</td>\n",
" <td> 29.8</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-23</th>\n",
" <td> 18.5</td>\n",
" <td> 23.518315</td>\n",
" <td> 28.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-24</th>\n",
" <td> 18.3</td>\n",
" <td> 24.610417</td>\n",
" <td> 30.2</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-25</th>\n",
" <td> 19.2</td>\n",
" <td> 24.654861</td>\n",
" <td> 31.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-26</th>\n",
" <td> 21.9</td>\n",
" <td> 24.530556</td>\n",
" <td> 29.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-27</th>\n",
" <td> 21.8</td>\n",
" <td> 25.596875</td>\n",
" <td> 30.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-28</th>\n",
" <td> 21.5</td>\n",
" <td> 26.752431</td>\n",
" <td> 30.1</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-29</th>\n",
" <td> 24.2</td>\n",
" <td> 27.728125</td>\n",
" <td> 32.7</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-30</th>\n",
" <td> 24.5</td>\n",
" <td> 28.827431</td>\n",
" <td> 33.5</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-01</th>\n",
" <td> 21.6</td>\n",
" <td> 27.496181</td>\n",
" <td> 32.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-02</th>\n",
" <td> 20.8</td>\n",
" <td> 25.203929</td>\n",
" <td> 29.2</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-03</th>\n",
" <td> 17.0</td>\n",
" <td> 23.001736</td>\n",
" <td> 29.2</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-04</th>\n",
" <td> 18.0</td>\n",
" <td> 24.887847</td>\n",
" <td> 31.8</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-05</th>\n",
" <td> 21.9</td>\n",
" <td> 27.210417</td>\n",
" <td> 33.5</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-06</th>\n",
" <td> 22.9</td>\n",
" <td> 28.547917</td>\n",
" <td> 35.2</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-07</th>\n",
" <td> 23.4</td>\n",
" <td> 29.736111</td>\n",
" <td> 36.8</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-08</th>\n",
" <td> 24.1</td>\n",
" <td> 30.111111</td>\n",
" <td> 36.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-09</th>\n",
" <td> 19.4</td>\n",
" <td> 24.903136</td>\n",
" <td> 32.5</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-10</th>\n",
" <td> 23.1</td>\n",
" <td> 26.890278</td>\n",
" <td> 34.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-11</th>\n",
" <td> 23.0</td>\n",
" <td> 27.721875</td>\n",
" <td> 34.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-12</th>\n",
" <td> 22.1</td>\n",
" <td> 29.044792</td>\n",
" <td> 36.1</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-13</th>\n",
" <td> 21.6</td>\n",
" <td> 29.680903</td>\n",
" <td> 38.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-14</th>\n",
" <td> 23.2</td>\n",
" <td> 27.519444</td>\n",
" <td> 36.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-15</th>\n",
" <td> 19.1</td>\n",
" <td> 24.049653</td>\n",
" <td> 30.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-16</th>\n",
" <td> 16.5</td>\n",
" <td> 19.421875</td>\n",
" <td> 24.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-17</th>\n",
" <td> 16.0</td>\n",
" <td> 17.634375</td>\n",
" <td> 20.1</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-18</th>\n",
" <td> 16.7</td>\n",
" <td> 17.979514</td>\n",
" <td> 21.1</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-19</th>\n",
" <td> 17.7</td>\n",
" <td> 21.205556</td>\n",
" <td> 26.9</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-20</th>\n",
" <td> 17.6</td>\n",
" <td> 23.413889</td>\n",
" <td> 31.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-21</th>\n",
" <td> 21.3</td>\n",
" <td> 27.207986</td>\n",
" <td> 34.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-22</th>\n",
" <td> 23.6</td>\n",
" <td> 28.776042</td>\n",
" <td> 34.8</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-23</th>\n",
" <td> 23.2</td>\n",
" <td> 29.210839</td>\n",
" <td> 35.4</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-24</th>\n",
" <td> 21.3</td>\n",
" <td> 27.225000</td>\n",
" <td> 33.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-25</th>\n",
" <td> 22.0</td>\n",
" <td> 29.072569</td>\n",
" <td> 37.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-26</th>\n",
" <td> 23.8</td>\n",
" <td> 31.176389</td>\n",
" <td> 38.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-27</th>\n",
" <td> 23.9</td>\n",
" <td> 30.219444</td>\n",
" <td> 36.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-28</th>\n",
" <td> 20.1</td>\n",
" <td> 25.790278</td>\n",
" <td> 31.7</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-29</th>\n",
" <td> 21.2</td>\n",
" <td> 26.113542</td>\n",
" <td> 32.8</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-30</th>\n",
" <td> 19.5</td>\n",
" <td> 22.138194</td>\n",
" <td> 25.9</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-31</th>\n",
" <td> 18.9</td>\n",
" <td> 20.723693</td>\n",
" <td> 24.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-08-01</th>\n",
" <td> 17.3</td>\n",
" <td> 22.420139</td>\n",
" <td> 28.6</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-08-02</th>\n",
" <td> 18.0</td>\n",
" <td> 23.985069</td>\n",
" <td> 29.8</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-08-03</th>\n",
" <td> 18.0</td>\n",
" <td> 24.616667</td>\n",
" <td> 31.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-08-04</th>\n",
" <td> 18.5</td>\n",
" <td> 25.845833</td>\n",
" <td> 32.0</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-08-05</th>\n",
" <td> 19.4</td>\n",
" <td> 26.266434</td>\n",
" <td> 32.3</td>\n",
" <td> 288</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 21,
"text": [
" amin mean amax size\n",
"STID DATE \n",
"NRMN 2014-01-01 0.3 5.084375 12.4 288\n",
" 2014-01-02 -9.5 -3.983333 3.2 288\n",
" 2014-01-03 -4.9 0.177083 9.3 288\n",
" 2014-01-04 3.3 7.082986 14.7 288\n",
" 2014-01-05 -8.7 -4.563194 7.6 288\n",
" 2014-01-06 -15.4 -10.585764 -3.8 288\n",
" 2014-01-07 -6.5 -1.635764 8.9 288\n",
" 2014-01-08 -0.8 2.057639 6.1 288\n",
" 2014-01-09 -0.3 0.707639 2.4 288\n",
" 2014-01-10 2.3 6.945833 15.4 288\n",
" 2014-01-11 -0.8 6.732292 16.8 288\n",
" 2014-01-12 3.7 11.734375 23.0 288\n",
" 2014-01-13 4.6 10.933571 20.1 288\n",
" 2014-01-14 -0.1 6.969444 12.8 288\n",
" 2014-01-15 -4.8 2.799653 13.0 288\n",
" 2014-01-16 1.9 8.340625 15.3 288\n",
" 2014-01-17 -3.9 5.276736 11.3 288\n",
" 2014-01-18 3.2 8.221181 17.1 288\n",
" 2014-01-19 -3.8 6.614236 18.2 288\n",
" 2014-01-20 -1.2 10.357986 18.0 288\n",
" 2014-01-21 -6.0 1.453472 12.8 288\n",
" 2014-01-22 -5.8 1.168056 10.3 288\n",
" 2014-01-23 -9.1 -3.058681 6.3 288\n",
" 2014-01-24 -13.7 -6.481250 5.8 288\n",
" 2014-01-25 0.5 7.569792 18.4 288\n",
" 2014-01-26 -0.5 8.754861 19.7 288\n",
" 2014-01-27 -6.7 -0.334375 13.6 288\n",
" 2014-01-28 -10.4 -6.894444 -1.3 288\n",
" 2014-01-29 -9.5 -2.891197 8.6 288\n",
" 2014-01-30 -0.5 3.749306 12.7 288\n",
" 2014-01-31 0.9 6.262153 10.2 288\n",
" 2014-02-01 -2.6 -0.248611 3.8 288\n",
" 2014-02-02 -6.0 -2.608333 0.4 288\n",
" 2014-02-03 -10.4 -5.452778 0.0 288\n",
" 2014-02-04 -1.0 -0.288889 0.5 288\n",
" 2014-02-05 -12.3 -7.422917 0.4 288\n",
" 2014-02-06 -13.4 -11.601389 -8.4 288\n",
" 2014-02-07 -9.8 -7.628472 -2.4 288\n",
" 2014-02-08 -3.7 -2.231944 0.4 288\n",
" 2014-02-09 -0.9 -0.283681 0.2 288\n",
" 2014-02-10 -7.5 -4.562153 -0.9 288\n",
" 2014-02-11 -8.2 -4.356597 2.7 288\n",
" 2014-02-12 -6.6 0.783333 9.4 288\n",
" 2014-02-13 -6.1 2.843056 17.4 288\n",
" 2014-02-14 2.3 9.954861 16.0 288\n",
" 2014-02-15 -2.0 7.098264 18.9 288\n",
" 2014-02-16 1.9 10.336806 21.3 288\n",
" 2014-02-17 11.4 14.505556 18.0 288\n",
" 2014-02-18 2.7 11.207986 23.6 288\n",
" 2014-02-19 8.0 12.674275 21.3 288\n",
" 2014-02-20 9.0 14.487153 17.4 288\n",
" 2014-02-21 -3.7 6.804167 18.2 288\n",
" 2014-02-22 5.9 12.677083 21.6 288\n",
" 2014-02-23 2.5 8.846875 17.9 288\n",
" 2014-02-24 -2.0 3.412847 10.3 288\n",
" 2014-02-25 -0.1 4.601042 8.2 288\n",
" 2014-02-26 -8.6 -2.029167 5.3 288\n",
" 2014-02-27 -6.0 1.443750 12.9 288\n",
" 2014-02-28 4.7 9.170833 18.3 288\n",
" 2014-03-01 4.0 7.018403 16.2 288\n",
" 2014-03-02 -11.6 -7.497569 3.9 288\n",
" 2014-03-03 -15.0 -11.430208 -4.4 288\n",
" 2014-03-04 -8.9 -3.288889 8.7 288\n",
" 2014-03-05 -0.9 3.518056 9.5 288\n",
" 2014-03-06 0.5 3.514931 11.2 288\n",
" 2014-03-07 2.9 8.326042 18.9 288\n",
" 2014-03-08 -0.2 5.595139 16.3 288\n",
" 2014-03-09 -1.5 5.475347 16.1 288\n",
" 2014-03-10 2.0 12.392708 24.3 288\n",
" 2014-03-11 11.9 18.263194 26.8 288\n",
" 2014-03-12 2.4 8.651736 16.4 288\n",
" 2014-03-13 0.9 9.167014 19.9 288\n",
" 2014-03-14 9.6 14.189583 21.3 288\n",
" 2014-03-15 10.1 13.548958 19.5 288\n",
" 2014-03-16 1.9 6.413542 12.1 288\n",
" 2014-03-17 -4.1 4.296875 15.6 288\n",
" 2014-03-18 7.7 13.346528 22.5 288\n",
" 2014-03-19 2.1 9.220139 19.9 288\n",
" 2014-03-20 0.6 10.419792 21.9 288\n",
" 2014-03-21 11.1 16.451736 24.0 288\n",
" 2014-03-22 5.7 11.100694 20.2 288\n",
" 2014-03-23 -0.3 5.599306 9.7 288\n",
" 2014-03-24 -2.0 7.554861 18.1 288\n",
" 2014-03-25 -1.8 6.298611 15.8 288\n",
" 2014-03-26 4.4 6.578472 12.5 288\n",
" 2014-03-27 8.4 16.871875 27.0 288\n",
" 2014-03-28 6.3 12.439931 24.2 288\n",
" 2014-03-29 0.2 10.304861 21.2 288\n",
" 2014-03-30 9.2 15.994444 25.1 288\n",
" 2014-03-31 13.0 19.356250 28.4 288\n",
" 2014-04-01 10.4 15.247222 25.4 288\n",
" 2014-04-02 14.1 20.873264 28.1 288\n",
" 2014-04-03 19.9 22.498958 26.3 288\n",
" 2014-04-04 3.3 10.081250 22.7 288\n",
" 2014-04-05 4.9 11.456944 19.1 288\n",
" 2014-04-06 6.9 9.007986 15.4 288\n",
" 2014-04-07 6.3 11.077778 18.7 288\n",
" 2014-04-08 6.4 12.438542 19.5 288\n",
" 2014-04-09 3.5 13.127984 26.5 288\n",
" 2014-04-10 15.6 21.900694 29.8 288\n",
" 2014-04-11 11.5 19.538889 26.0 288\n",
" 2014-04-12 17.0 21.297569 27.0 288\n",
" 2014-04-13 15.9 22.539931 29.1 288\n",
" 2014-04-14 1.6 6.280208 15.7 288\n",
" 2014-04-15 -1.6 6.993056 17.3 288\n",
" 2014-04-16 7.1 12.491289 19.3 288\n",
" 2014-04-17 7.3 12.350000 17.5 288\n",
" 2014-04-18 4.0 13.002083 22.9 288\n",
" 2014-04-19 10.9 17.904861 25.1 288\n",
" 2014-04-20 14.1 18.039583 22.9 288\n",
" 2014-04-21 14.8 17.857292 24.7 288\n",
" 2014-04-22 10.5 17.803915 26.6 288\n",
" 2014-04-23 13.6 20.517708 28.9 288\n",
" 2014-04-24 15.8 21.089583 26.2 288\n",
" 2014-04-25 8.9 17.470833 26.6 288\n",
" 2014-04-26 16.5 22.373958 30.9 288\n",
" 2014-04-27 19.5 23.574653 28.1 288\n",
" 2014-04-28 10.9 18.047222 26.3 288\n",
" 2014-04-29 10.4 13.075694 15.6 288\n",
" 2014-04-30 7.1 11.648905 16.6 288\n",
" 2014-05-01 2.4 11.792014 21.0 288\n",
" 2014-05-02 5.1 14.142708 23.1 288\n",
" 2014-05-03 9.0 18.688542 30.5 288\n",
" 2014-05-04 15.4 24.808333 35.0 288\n",
" 2014-05-05 17.7 26.407986 34.6 288\n",
" 2014-05-06 19.1 25.608333 32.0 288\n",
" 2014-05-07 19.3 24.530903 30.0 288\n",
" 2014-05-08 17.4 21.810069 26.9 288\n",
" 2014-05-09 12.8 20.278853 26.8 288\n",
" 2014-05-10 15.6 22.259722 31.2 288\n",
" 2014-05-11 21.5 24.913194 29.4 288\n",
" 2014-05-12 14.0 20.593056 27.9 288\n",
" 2014-05-13 8.4 13.495833 19.3 288\n",
" 2014-05-14 7.4 14.801042 21.4 288\n",
" 2014-05-15 6.1 14.645833 22.3 288\n",
" 2014-05-16 5.6 15.997222 25.5 288\n",
" 2014-05-17 10.5 16.839931 23.2 288\n",
" 2014-05-18 11.8 17.163194 26.6 288\n",
" 2014-05-19 17.9 23.043056 29.9 288\n",
" 2014-05-20 19.4 25.233101 32.5 288\n",
" 2014-05-21 20.4 25.975000 31.9 288\n",
" 2014-05-22 19.3 25.427431 32.0 288\n",
" 2014-05-23 19.8 23.970383 29.0 288\n",
" 2014-05-24 17.9 21.275000 27.9 288\n",
" 2014-05-25 19.1 22.554167 28.0 288\n",
" 2014-05-26 19.2 22.575000 27.0 288\n",
" 2014-05-27 18.0 19.733681 23.0 288\n",
" 2014-05-28 16.7 21.272917 28.3 288\n",
" 2014-05-29 16.1 24.035069 31.3 288\n",
" 2014-05-30 18.7 23.379514 29.7 288\n",
" 2014-05-31 19.1 22.927778 29.5 288\n",
" 2014-06-01 20.2 24.706597 31.6 288\n",
" 2014-06-02 18.8 26.048611 32.8 288\n",
" 2014-06-03 22.1 27.574306 33.8 288\n",
" 2014-06-04 22.5 28.584028 36.2 288\n",
" 2014-06-05 23.0 28.317708 35.2 288\n",
" 2014-06-06 19.0 25.737500 32.3 288\n",
" 2014-06-07 18.3 23.794792 29.6 288\n",
" 2014-06-08 19.1 21.564583 28.0 288\n",
" 2014-06-09 16.4 20.628472 25.6 288\n",
" 2014-06-10 16.7 20.752083 27.0 288\n",
" 2014-06-11 14.7 22.897880 31.6 288\n",
" 2014-06-12 18.3 23.904514 30.7 288\n",
" 2014-06-13 16.0 22.328070 28.2 288\n",
" 2014-06-14 21.5 25.246181 31.8 288\n",
" 2014-06-15 23.9 27.081944 31.0 288\n",
" 2014-06-16 23.2 27.225177 32.0 288\n",
" 2014-06-17 23.7 28.008681 32.7 288\n",
" 2014-06-18 24.1 27.834722 32.6 288\n",
" 2014-06-19 19.6 24.392361 29.6 288\n",
" 2014-06-20 20.1 25.649630 31.8 288\n",
" 2014-06-21 22.5 26.780208 31.4 288\n",
" 2014-06-22 21.6 25.604514 29.8 288\n",
" 2014-06-23 18.5 23.518315 28.3 288\n",
" 2014-06-24 18.3 24.610417 30.2 288\n",
" 2014-06-25 19.2 24.654861 31.3 288\n",
" 2014-06-26 21.9 24.530556 29.4 288\n",
" 2014-06-27 21.8 25.596875 30.4 288\n",
" 2014-06-28 21.5 26.752431 30.1 288\n",
" 2014-06-29 24.2 27.728125 32.7 288\n",
" 2014-06-30 24.5 28.827431 33.5 288\n",
" 2014-07-01 21.6 27.496181 32.6 288\n",
" 2014-07-02 20.8 25.203929 29.2 288\n",
" 2014-07-03 17.0 23.001736 29.2 288\n",
" 2014-07-04 18.0 24.887847 31.8 288\n",
" 2014-07-05 21.9 27.210417 33.5 288\n",
" 2014-07-06 22.9 28.547917 35.2 288\n",
" 2014-07-07 23.4 29.736111 36.8 288\n",
" 2014-07-08 24.1 30.111111 36.0 288\n",
" 2014-07-09 19.4 24.903136 32.5 288\n",
" 2014-07-10 23.1 26.890278 34.0 288\n",
" 2014-07-11 23.0 27.721875 34.0 288\n",
" 2014-07-12 22.1 29.044792 36.1 288\n",
" 2014-07-13 21.6 29.680903 38.3 288\n",
" 2014-07-14 23.2 27.519444 36.0 288\n",
" 2014-07-15 19.1 24.049653 30.4 288\n",
" 2014-07-16 16.5 19.421875 24.3 288\n",
" 2014-07-17 16.0 17.634375 20.1 288\n",
" 2014-07-18 16.7 17.979514 21.1 288\n",
" 2014-07-19 17.7 21.205556 26.9 288\n",
" 2014-07-20 17.6 23.413889 31.4 288\n",
" 2014-07-21 21.3 27.207986 34.3 288\n",
" 2014-07-22 23.6 28.776042 34.8 288\n",
" 2014-07-23 23.2 29.210839 35.4 288\n",
" 2014-07-24 21.3 27.225000 33.6 288\n",
" 2014-07-25 22.0 29.072569 37.6 288\n",
" 2014-07-26 23.8 31.176389 38.3 288\n",
" 2014-07-27 23.9 30.219444 36.0 288\n",
" 2014-07-28 20.1 25.790278 31.7 288\n",
" 2014-07-29 21.2 26.113542 32.8 288\n",
" 2014-07-30 19.5 22.138194 25.9 288\n",
" 2014-07-31 18.9 20.723693 24.0 288\n",
" 2014-08-01 17.3 22.420139 28.6 288\n",
" 2014-08-02 18.0 23.985069 29.8 288\n",
" 2014-08-03 18.0 24.616667 31.0 288\n",
" 2014-08-04 18.5 25.845833 32.0 288\n",
" 2014-08-05 19.4 26.266434 32.3 288"
]
}
],
"prompt_number": 21
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Group By Date.Year and Date.Month"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"grouped = df.groupby(['STID',df['DATE'].map(lambda x: x.year) ,df['DATE'].map(lambda x: x.month),])\n",
"grouped['TAIR'].agg([np.min,np.mean,np.max,np.size])"
],
"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></th>\n",
" <th>amin</th>\n",
" <th>mean</th>\n",
" <th>amax</th>\n",
" <th>size</th>\n",
" </tr>\n",
" <tr>\n",
" <th>STID</th>\n",
" <th>DATE</th>\n",
" <th>DATE</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th rowspan=\"8\" valign=\"top\">NRMN</th>\n",
" <th rowspan=\"8\" valign=\"top\">2014</th>\n",
" <th>1</th>\n",
" <td>-15.4</td>\n",
" <td> 2.852277</td>\n",
" <td> 23.0</td>\n",
" <td> 8928</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>-13.4</td>\n",
" <td> 2.918803</td>\n",
" <td> 23.6</td>\n",
" <td> 8064</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>-15.0</td>\n",
" <td> 8.377173</td>\n",
" <td> 28.4</td>\n",
" <td> 8928</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td> -1.6</td>\n",
" <td> 16.075131</td>\n",
" <td> 30.9</td>\n",
" <td> 8640</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td> 2.4</td>\n",
" <td> 20.973399</td>\n",
" <td> 35.0</td>\n",
" <td> 8928</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td> 14.7</td>\n",
" <td> 25.366531</td>\n",
" <td> 36.2</td>\n",
" <td> 8640</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td> 16.0</td>\n",
" <td> 25.913964</td>\n",
" <td> 38.3</td>\n",
" <td> 8928</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td> 17.3</td>\n",
" <td> 24.624548</td>\n",
" <td> 32.3</td>\n",
" <td> 1440</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 27,
"text": [
" amin mean amax size\n",
"STID DATE DATE \n",
"NRMN 2014 1 -15.4 2.852277 23.0 8928\n",
" 2 -13.4 2.918803 23.6 8064\n",
" 3 -15.0 8.377173 28.4 8928\n",
" 4 -1.6 16.075131 30.9 8640\n",
" 5 2.4 20.973399 35.0 8928\n",
" 6 14.7 25.366531 36.2 8640\n",
" 7 16.0 25.913964 38.3 8928\n",
" 8 17.3 24.624548 32.3 1440"
]
}
],
"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