Skip to content

Instantly share code, notes, and snippets.

@phobson

phobson/pandas_for_stormwater.ipynb

Created April 4, 2013 02:03
Show Gist options
  • Save phobson/5307130 to your computer and use it in GitHub Desktop.
Save phobson/5307130 to your computer and use it in GitHub Desktop.
Download ZIP
pandas for stormwater
Display the source blob
Display the rendered blob
Raw
pandas_for_stormwater.ipynb
{
"metadata": {
"name": "newdatascratch"
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# The basics of `pandas` using data from the [International Stormwater BMP Database](http://www.bmpdatabase.org/)\n",
"### Set up the environment"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# third-party libraries\n",
"import numpy as np\n",
"import matplotlib.pyplot as plt\n",
"import pandas\n",
"import pandas.io.sql as sql\n",
"\n",
"# libraries I wrote\n",
"import bmp \n",
"import utils"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stderr",
"text": [
"c:\\Python27\\lib\\site-packages\\pytz\\__init__.py:35: UserWarning: Module IPython was already imported from c:\\users\\phobson\\work\\ipython\\IPython\\__init__.pyc, but c:\\python27\\lib\\site-packages\\ipython-0.13.1.dev-py2.7.egg is being added to sys.path\n",
" from pkg_resources import resource_stream\n"
]
}
],
"prompt_number": 1
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Get the metals data from the database"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"cnn, cur = bmp.dataAccess.connectToDB()\n",
"cmd = \"select * from metals\"\n",
"data = sql.read_frame(cmd, cnn)\n",
"cur.close()\n",
"cnn.close()"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 2
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Standarize the non-detect vs detect qualifiers"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"ND_flags = ['U', ' U', 'U ', 'UJ', ' UJ', 'UJ ']\n",
"\n",
"# if the data are non-detect, set the qual to ND\n",
"data.wq_qual[data.wq_qual.isin(ND_flags)] = 'ND'\n",
"\n",
"# otherwise, set the qual to and equals sign\n",
"data.wq_qual[data.wq_qual != 'ND'] = '='"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 3
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Note that where the data are null (represented by NaN due to the pivot/cross-tab operation), the commands in the previous cell have no effect. In this case, this is a feature (not a bug) since it would be meaningless to have an \"=\" qualifier with an NaN result.\n",
"\n",
"### Show the data shape and its original form (w/ modified qualifiers)"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"print(data.shape)\n",
"data.head(10) # show only 10 rows"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"(54079, 15)\n"
]
},
{
"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>bmp_category</th>\n",
" <th>site_id</th>\n",
" <th>site_name</th>\n",
" <th>bmp_id</th>\n",
" <th>bmp_name</th>\n",
" <th>ms_id</th>\n",
" <th>storm</th>\n",
" <th>datetime</th>\n",
" <th>station_type</th>\n",
" <th>parameter</th>\n",
" <th>wq_value</th>\n",
" <th>wq_unit</th>\n",
" <th>wq_qual</th>\n",
" <th>parameter_order</th>\n",
" <th>tex_parameter</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td> GS</td>\n",
" <td> 1313612811</td>\n",
" <td> Altadena (strip)</td>\n",
" <td> 403648495</td>\n",
" <td> Altadena Strip</td>\n",
" <td> 1887184644</td>\n",
" <td> 1</td>\n",
" <td> 2000-01-25 00:00:00</td>\n",
" <td> Inflow</td>\n",
" <td> Copper, Dissolved</td>\n",
" <td> 1.0</td>\n",
" <td> ug/L</td>\n",
" <td> =</td>\n",
" <td> 7</td>\n",
" <td> Dissolved Copper</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td> GS</td>\n",
" <td> 1313612811</td>\n",
" <td> Altadena (strip)</td>\n",
" <td> 403648495</td>\n",
" <td> Altadena Strip</td>\n",
" <td> -35621963</td>\n",
" <td> 1</td>\n",
" <td> 2000-01-25 00:00:00</td>\n",
" <td> Outflow</td>\n",
" <td> Copper, Dissolved</td>\n",
" <td> 1.0</td>\n",
" <td> ug/L</td>\n",
" <td> =</td>\n",
" <td> 7</td>\n",
" <td> Dissolved Copper</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td> GS</td>\n",
" <td> 1313612811</td>\n",
" <td> Altadena (strip)</td>\n",
" <td> 403648495</td>\n",
" <td> Altadena Strip</td>\n",
" <td> 1887184644</td>\n",
" <td> 1</td>\n",
" <td> 2000-01-25 00:00:00</td>\n",
" <td> Inflow</td>\n",
" <td> Copper, Total</td>\n",
" <td> 1.3</td>\n",
" <td> ug/L</td>\n",
" <td> =</td>\n",
" <td> 8</td>\n",
" <td> Total Copper</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td> GS</td>\n",
" <td> 1313612811</td>\n",
" <td> Altadena (strip)</td>\n",
" <td> 403648495</td>\n",
" <td> Altadena Strip</td>\n",
" <td> -35621963</td>\n",
" <td> 1</td>\n",
" <td> 2000-01-25 00:00:00</td>\n",
" <td> Outflow</td>\n",
" <td> Copper, Total</td>\n",
" <td> 1.0</td>\n",
" <td> ug/L</td>\n",
" <td> =</td>\n",
" <td> 8</td>\n",
" <td> Total Copper</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td> GS</td>\n",
" <td> 1313612811</td>\n",
" <td> Altadena (strip)</td>\n",
" <td> 403648495</td>\n",
" <td> Altadena Strip</td>\n",
" <td> 1887184644</td>\n",
" <td> 1</td>\n",
" <td> 2000-01-25 00:00:00</td>\n",
" <td> Inflow</td>\n",
" <td> Lead, Dissolved</td>\n",
" <td> 1.0</td>\n",
" <td> ug/L</td>\n",
" <td> =</td>\n",
" <td> 11</td>\n",
" <td> Dissolved Lead</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td> GS</td>\n",
" <td> 1313612811</td>\n",
" <td> Altadena (strip)</td>\n",
" <td> 403648495</td>\n",
" <td> Altadena Strip</td>\n",
" <td> -35621963</td>\n",
" <td> 1</td>\n",
" <td> 2000-01-25 00:00:00</td>\n",
" <td> Outflow</td>\n",
" <td> Lead, Dissolved</td>\n",
" <td> 1.0</td>\n",
" <td> ug/L</td>\n",
" <td> =</td>\n",
" <td> 11</td>\n",
" <td> Dissolved Lead</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td> GS</td>\n",
" <td> 1313612811</td>\n",
" <td> Altadena (strip)</td>\n",
" <td> 403648495</td>\n",
" <td> Altadena Strip</td>\n",
" <td> 1887184644</td>\n",
" <td> 1</td>\n",
" <td> 2000-01-25 00:00:00</td>\n",
" <td> Inflow</td>\n",
" <td> Lead, Total</td>\n",
" <td> 2.0</td>\n",
" <td> ug/L</td>\n",
" <td> =</td>\n",
" <td> 12</td>\n",
" <td> Total Lead</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td> GS</td>\n",
" <td> 1313612811</td>\n",
" <td> Altadena (strip)</td>\n",
" <td> 403648495</td>\n",
" <td> Altadena Strip</td>\n",
" <td> -35621963</td>\n",
" <td> 1</td>\n",
" <td> 2000-01-25 00:00:00</td>\n",
" <td> Outflow</td>\n",
" <td> Lead, Total</td>\n",
" <td> 1.0</td>\n",
" <td> ug/L</td>\n",
" <td> =</td>\n",
" <td> 12</td>\n",
" <td> Total Lead</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td> GS</td>\n",
" <td> 1313612811</td>\n",
" <td> Altadena (strip)</td>\n",
" <td> 403648495</td>\n",
" <td> Altadena Strip</td>\n",
" <td> 1887184644</td>\n",
" <td> 1</td>\n",
" <td> 2000-01-25 00:00:00</td>\n",
" <td> Inflow</td>\n",
" <td> Zinc, Dissolved</td>\n",
" <td> 5.1</td>\n",
" <td> ug/L</td>\n",
" <td> =</td>\n",
" <td> 17</td>\n",
" <td> Dissolved Zinc</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td> GS</td>\n",
" <td> 1313612811</td>\n",
" <td> Altadena (strip)</td>\n",
" <td> 403648495</td>\n",
" <td> Altadena Strip</td>\n",
" <td> -35621963</td>\n",
" <td> 1</td>\n",
" <td> 2000-01-25 00:00:00</td>\n",
" <td> Outflow</td>\n",
" <td> Zinc, Dissolved</td>\n",
" <td> 3.2</td>\n",
" <td> ug/L</td>\n",
" <td> =</td>\n",
" <td> 17</td>\n",
" <td> Dissolved Zinc</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"output_type": "pyout",
"prompt_number": 4,
"text": [
" bmp_category site_id site_name bmp_id bmp_name ms_id \\\n",
"0 GS 1313612811 Altadena (strip) 403648495 Altadena Strip 1887184644 \n",
"1 GS 1313612811 Altadena (strip) 403648495 Altadena Strip -35621963 \n",
"2 GS 1313612811 Altadena (strip) 403648495 Altadena Strip 1887184644 \n",
"3 GS 1313612811 Altadena (strip) 403648495 Altadena Strip -35621963 \n",
"4 GS 1313612811 Altadena (strip) 403648495 Altadena Strip 1887184644 \n",
"5 GS 1313612811 Altadena (strip) 403648495 Altadena Strip -35621963 \n",
"6 GS 1313612811 Altadena (strip) 403648495 Altadena Strip 1887184644 \n",
"7 GS 1313612811 Altadena (strip) 403648495 Altadena Strip -35621963 \n",
"8 GS 1313612811 Altadena (strip) 403648495 Altadena Strip 1887184644 \n",
"9 GS 1313612811 Altadena (strip) 403648495 Altadena Strip -35621963 \n",
"\n",
" storm datetime station_type parameter wq_value wq_unit \\\n",
"0 1 2000-01-25 00:00:00 Inflow Copper, Dissolved 1.0 ug/L \n",
"1 1 2000-01-25 00:00:00 Outflow Copper, Dissolved 1.0 ug/L \n",
"2 1 2000-01-25 00:00:00 Inflow Copper, Total 1.3 ug/L \n",
"3 1 2000-01-25 00:00:00 Outflow Copper, Total 1.0 ug/L \n",
"4 1 2000-01-25 00:00:00 Inflow Lead, Dissolved 1.0 ug/L \n",
"5 1 2000-01-25 00:00:00 Outflow Lead, Dissolved 1.0 ug/L \n",
"6 1 2000-01-25 00:00:00 Inflow Lead, Total 2.0 ug/L \n",
"7 1 2000-01-25 00:00:00 Outflow Lead, Total 1.0 ug/L \n",
"8 1 2000-01-25 00:00:00 Inflow Zinc, Dissolved 5.1 ug/L \n",
"9 1 2000-01-25 00:00:00 Outflow Zinc, Dissolved 3.2 ug/L \n",
"\n",
" wq_qual parameter_order tex_parameter \n",
"0 = 7 Dissolved Copper \n",
"1 = 7 Dissolved Copper \n",
"2 = 8 Total Copper \n",
"3 = 8 Total Copper \n",
"4 = 11 Dissolved Lead \n",
"5 = 11 Dissolved Lead \n",
"6 = 12 Total Lead \n",
"7 = 12 Total Lead \n",
"8 = 17 Dissolved Zinc \n",
"9 = 17 Dissolved Zinc "
]
}
],
"prompt_number": 4
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Index the data and pivot based on monitoring location. \n",
"There are duplicate indices in this dataset and the client wants us to \n",
"just take the max of the results values (and the min of the qualifiers)"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# columns to be the index\n",
"row_headers = ('bmp_category', 'site_id', 'bmp_id', 'station_type', \n",
" 'storm', 'datetime', 'parameter', 'wq_unit')\n",
"\n",
"# group the data based on the index\n",
"groups = data.groupby(by=row_headers)\n",
"\n",
"# aggregate data from the groups\n",
"pivot = groups.aggregate({'wq_value':'max', 'wq_qual':'min'})\n",
"\n",
"# rename the columns (for convenience only)\n",
"pivot.rename(columns={'wq_qual':'qual', 'wq_value':'res'}, inplace=True)\n",
"table = pivot.unstack(level=-5)\n"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stderr",
"text": [
"c:\\Python27\\lib\\site-packages\\pandas\\core\\frame.py:3576: FutureWarning: rename with inplace=True will return None from pandas 0.11 onward\n",
" \" from pandas 0.11 onward\", FutureWarning)\n"
]
}
],
"prompt_number": 5
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Show our progress thus far\n",
"Notice the column labels above `wq_unit`"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# Rename the columns levels (you'll see what I mean)\n",
"table.columns.names = ['Quantity', 'Station']\n",
"table.head(10) # show only 10 rows "
],
"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>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th>Quantity</th>\n",
" <th colspan=\"4\" halign=\"left\">qual</th>\n",
" <th colspan=\"4\" halign=\"left\">res</th>\n",
" </tr>\n",
" <tr>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th>Station</th>\n",
" <th>Inflow</th>\n",
" <th>Outflow</th>\n",
" <th>Reference Outflow</th>\n",
" <th>Subsurface</th>\n",
" <th>Inflow</th>\n",
" <th>Outflow</th>\n",
" <th>Reference Outflow</th>\n",
" <th>Subsurface</th>\n",
" </tr>\n",
" <tr>\n",
" <th>bmp_category</th>\n",
" <th>site_id</th>\n",
" <th>bmp_id</th>\n",
" <th>storm</th>\n",
" <th>datetime</th>\n",
" <th>parameter</th>\n",
" <th>wq_unit</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></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=\"10\" valign=\"top\">BR</th>\n",
" <th rowspan=\"10\" valign=\"top\">-2095595724</th>\n",
" <th rowspan=\"10\" valign=\"top\">2021385642</th>\n",
" <th>1 </th>\n",
" <th>2004-05-30</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> =</td>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 25</td>\n",
" <td> 560</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <th>2004-06-15</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 530</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <th>2004-06-25</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> =</td>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 250</td>\n",
" <td> 500</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <th>2004-07-18</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> =</td>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 650</td>\n",
" <td> 1720</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <th>2004-08-12</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> =</td>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 590</td>\n",
" <td> 260</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <th>2004-08-21</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> NaN</td>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 260</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <th>2004-08-30</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> =</td>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 250</td>\n",
" <td> 200</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <th>2004-09-06</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> =</td>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 680</td>\n",
" <td> 110</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <th>2004-09-27</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> =</td>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 570</td>\n",
" <td> 500</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <th>2004-10-13</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> =</td>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 1440</td>\n",
" <td> 630</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"output_type": "pyout",
"prompt_number": 6,
"text": [
"Quantity qual \\\n",
"Station Inflow \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L = \n",
" 4 2004-06-15 Iron, Total ug/L = \n",
" 7 2004-06-25 Iron, Total ug/L = \n",
" 11 2004-07-18 Iron, Total ug/L = \n",
" 16 2004-08-12 Iron, Total ug/L = \n",
" 17 2004-08-21 Iron, Total ug/L NaN \n",
" 19 2004-08-30 Iron, Total ug/L = \n",
" 20 2004-09-06 Iron, Total ug/L = \n",
" 23 2004-09-27 Iron, Total ug/L = \n",
" 24 2004-10-13 Iron, Total ug/L = \n",
"\n",
"Quantity \\\n",
"Station Outflow \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L = \n",
" 4 2004-06-15 Iron, Total ug/L NaN \n",
" 7 2004-06-25 Iron, Total ug/L = \n",
" 11 2004-07-18 Iron, Total ug/L = \n",
" 16 2004-08-12 Iron, Total ug/L = \n",
" 17 2004-08-21 Iron, Total ug/L = \n",
" 19 2004-08-30 Iron, Total ug/L = \n",
" 20 2004-09-06 Iron, Total ug/L = \n",
" 23 2004-09-27 Iron, Total ug/L = \n",
" 24 2004-10-13 Iron, Total ug/L = \n",
"\n",
"Quantity \\\n",
"Station Reference Outflow \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L NaN \n",
" 4 2004-06-15 Iron, Total ug/L NaN \n",
" 7 2004-06-25 Iron, Total ug/L NaN \n",
" 11 2004-07-18 Iron, Total ug/L NaN \n",
" 16 2004-08-12 Iron, Total ug/L NaN \n",
" 17 2004-08-21 Iron, Total ug/L NaN \n",
" 19 2004-08-30 Iron, Total ug/L NaN \n",
" 20 2004-09-06 Iron, Total ug/L NaN \n",
" 23 2004-09-27 Iron, Total ug/L NaN \n",
" 24 2004-10-13 Iron, Total ug/L NaN \n",
"\n",
"Quantity \\\n",
"Station Subsurface \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L NaN \n",
" 4 2004-06-15 Iron, Total ug/L NaN \n",
" 7 2004-06-25 Iron, Total ug/L NaN \n",
" 11 2004-07-18 Iron, Total ug/L NaN \n",
" 16 2004-08-12 Iron, Total ug/L NaN \n",
" 17 2004-08-21 Iron, Total ug/L NaN \n",
" 19 2004-08-30 Iron, Total ug/L NaN \n",
" 20 2004-09-06 Iron, Total ug/L NaN \n",
" 23 2004-09-27 Iron, Total ug/L NaN \n",
" 24 2004-10-13 Iron, Total ug/L NaN \n",
"\n",
"Quantity res \\\n",
"Station Inflow \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L 25 \n",
" 4 2004-06-15 Iron, Total ug/L 530 \n",
" 7 2004-06-25 Iron, Total ug/L 250 \n",
" 11 2004-07-18 Iron, Total ug/L 650 \n",
" 16 2004-08-12 Iron, Total ug/L 590 \n",
" 17 2004-08-21 Iron, Total ug/L NaN \n",
" 19 2004-08-30 Iron, Total ug/L 250 \n",
" 20 2004-09-06 Iron, Total ug/L 680 \n",
" 23 2004-09-27 Iron, Total ug/L 570 \n",
" 24 2004-10-13 Iron, Total ug/L 1440 \n",
"\n",
"Quantity \\\n",
"Station Outflow \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L 560 \n",
" 4 2004-06-15 Iron, Total ug/L NaN \n",
" 7 2004-06-25 Iron, Total ug/L 500 \n",
" 11 2004-07-18 Iron, Total ug/L 1720 \n",
" 16 2004-08-12 Iron, Total ug/L 260 \n",
" 17 2004-08-21 Iron, Total ug/L 260 \n",
" 19 2004-08-30 Iron, Total ug/L 200 \n",
" 20 2004-09-06 Iron, Total ug/L 110 \n",
" 23 2004-09-27 Iron, Total ug/L 500 \n",
" 24 2004-10-13 Iron, Total ug/L 630 \n",
"\n",
"Quantity \\\n",
"Station Reference Outflow \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L NaN \n",
" 4 2004-06-15 Iron, Total ug/L NaN \n",
" 7 2004-06-25 Iron, Total ug/L NaN \n",
" 11 2004-07-18 Iron, Total ug/L NaN \n",
" 16 2004-08-12 Iron, Total ug/L NaN \n",
" 17 2004-08-21 Iron, Total ug/L NaN \n",
" 19 2004-08-30 Iron, Total ug/L NaN \n",
" 20 2004-09-06 Iron, Total ug/L NaN \n",
" 23 2004-09-27 Iron, Total ug/L NaN \n",
" 24 2004-10-13 Iron, Total ug/L NaN \n",
"\n",
"Quantity \n",
"Station Subsurface \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L NaN \n",
" 4 2004-06-15 Iron, Total ug/L NaN \n",
" 7 2004-06-25 Iron, Total ug/L NaN \n",
" 11 2004-07-18 Iron, Total ug/L NaN \n",
" 16 2004-08-12 Iron, Total ug/L NaN \n",
" 17 2004-08-21 Iron, Total ug/L NaN \n",
" 19 2004-08-30 Iron, Total ug/L NaN \n",
" 20 2004-09-06 Iron, Total ug/L NaN \n",
" 23 2004-09-27 Iron, Total ug/L NaN \n",
" 24 2004-10-13 Iron, Total ug/L NaN "
]
}
],
"prompt_number": 6
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Move the monitoring locations to the top-level columns"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"table.columns = table.columns.swaplevel('Quantity', 'Station')\n",
"table.head(10)"
],
"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>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th>Station</th>\n",
" <th>Inflow</th>\n",
" <th>Outflow</th>\n",
" <th>Reference Outflow</th>\n",
" <th>Subsurface</th>\n",
" <th>Inflow</th>\n",
" <th>Outflow</th>\n",
" <th>Reference Outflow</th>\n",
" <th>Subsurface</th>\n",
" </tr>\n",
" <tr>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th>Quantity</th>\n",
" <th>qual</th>\n",
" <th>qual</th>\n",
" <th>qual</th>\n",
" <th>qual</th>\n",
" <th>res</th>\n",
" <th>res</th>\n",
" <th>res</th>\n",
" <th>res</th>\n",
" </tr>\n",
" <tr>\n",
" <th>bmp_category</th>\n",
" <th>site_id</th>\n",
" <th>bmp_id</th>\n",
" <th>storm</th>\n",
" <th>datetime</th>\n",
" <th>parameter</th>\n",
" <th>wq_unit</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></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=\"10\" valign=\"top\">BR</th>\n",
" <th rowspan=\"10\" valign=\"top\">-2095595724</th>\n",
" <th rowspan=\"10\" valign=\"top\">2021385642</th>\n",
" <th>1 </th>\n",
" <th>2004-05-30</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> =</td>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 25</td>\n",
" <td> 560</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <th>2004-06-15</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 530</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <th>2004-06-25</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> =</td>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 250</td>\n",
" <td> 500</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <th>2004-07-18</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> =</td>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 650</td>\n",
" <td> 1720</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <th>2004-08-12</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> =</td>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 590</td>\n",
" <td> 260</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <th>2004-08-21</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> NaN</td>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 260</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <th>2004-08-30</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> =</td>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 250</td>\n",
" <td> 200</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <th>2004-09-06</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> =</td>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 680</td>\n",
" <td> 110</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <th>2004-09-27</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> =</td>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 570</td>\n",
" <td> 500</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <th>2004-10-13</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> =</td>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 1440</td>\n",
" <td> 630</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"output_type": "pyout",
"prompt_number": 7,
"text": [
"Station Inflow \\\n",
"Quantity qual \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L = \n",
" 4 2004-06-15 Iron, Total ug/L = \n",
" 7 2004-06-25 Iron, Total ug/L = \n",
" 11 2004-07-18 Iron, Total ug/L = \n",
" 16 2004-08-12 Iron, Total ug/L = \n",
" 17 2004-08-21 Iron, Total ug/L NaN \n",
" 19 2004-08-30 Iron, Total ug/L = \n",
" 20 2004-09-06 Iron, Total ug/L = \n",
" 23 2004-09-27 Iron, Total ug/L = \n",
" 24 2004-10-13 Iron, Total ug/L = \n",
"\n",
"Station Outflow \\\n",
"Quantity qual \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L = \n",
" 4 2004-06-15 Iron, Total ug/L NaN \n",
" 7 2004-06-25 Iron, Total ug/L = \n",
" 11 2004-07-18 Iron, Total ug/L = \n",
" 16 2004-08-12 Iron, Total ug/L = \n",
" 17 2004-08-21 Iron, Total ug/L = \n",
" 19 2004-08-30 Iron, Total ug/L = \n",
" 20 2004-09-06 Iron, Total ug/L = \n",
" 23 2004-09-27 Iron, Total ug/L = \n",
" 24 2004-10-13 Iron, Total ug/L = \n",
"\n",
"Station Reference Outflow \\\n",
"Quantity qual \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L NaN \n",
" 4 2004-06-15 Iron, Total ug/L NaN \n",
" 7 2004-06-25 Iron, Total ug/L NaN \n",
" 11 2004-07-18 Iron, Total ug/L NaN \n",
" 16 2004-08-12 Iron, Total ug/L NaN \n",
" 17 2004-08-21 Iron, Total ug/L NaN \n",
" 19 2004-08-30 Iron, Total ug/L NaN \n",
" 20 2004-09-06 Iron, Total ug/L NaN \n",
" 23 2004-09-27 Iron, Total ug/L NaN \n",
" 24 2004-10-13 Iron, Total ug/L NaN \n",
"\n",
"Station Subsurface \\\n",
"Quantity qual \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L NaN \n",
" 4 2004-06-15 Iron, Total ug/L NaN \n",
" 7 2004-06-25 Iron, Total ug/L NaN \n",
" 11 2004-07-18 Iron, Total ug/L NaN \n",
" 16 2004-08-12 Iron, Total ug/L NaN \n",
" 17 2004-08-21 Iron, Total ug/L NaN \n",
" 19 2004-08-30 Iron, Total ug/L NaN \n",
" 20 2004-09-06 Iron, Total ug/L NaN \n",
" 23 2004-09-27 Iron, Total ug/L NaN \n",
" 24 2004-10-13 Iron, Total ug/L NaN \n",
"\n",
"Station Inflow \\\n",
"Quantity res \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L 25 \n",
" 4 2004-06-15 Iron, Total ug/L 530 \n",
" 7 2004-06-25 Iron, Total ug/L 250 \n",
" 11 2004-07-18 Iron, Total ug/L 650 \n",
" 16 2004-08-12 Iron, Total ug/L 590 \n",
" 17 2004-08-21 Iron, Total ug/L NaN \n",
" 19 2004-08-30 Iron, Total ug/L 250 \n",
" 20 2004-09-06 Iron, Total ug/L 680 \n",
" 23 2004-09-27 Iron, Total ug/L 570 \n",
" 24 2004-10-13 Iron, Total ug/L 1440 \n",
"\n",
"Station Outflow \\\n",
"Quantity res \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L 560 \n",
" 4 2004-06-15 Iron, Total ug/L NaN \n",
" 7 2004-06-25 Iron, Total ug/L 500 \n",
" 11 2004-07-18 Iron, Total ug/L 1720 \n",
" 16 2004-08-12 Iron, Total ug/L 260 \n",
" 17 2004-08-21 Iron, Total ug/L 260 \n",
" 19 2004-08-30 Iron, Total ug/L 200 \n",
" 20 2004-09-06 Iron, Total ug/L 110 \n",
" 23 2004-09-27 Iron, Total ug/L 500 \n",
" 24 2004-10-13 Iron, Total ug/L 630 \n",
"\n",
"Station Reference Outflow \\\n",
"Quantity res \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L NaN \n",
" 4 2004-06-15 Iron, Total ug/L NaN \n",
" 7 2004-06-25 Iron, Total ug/L NaN \n",
" 11 2004-07-18 Iron, Total ug/L NaN \n",
" 16 2004-08-12 Iron, Total ug/L NaN \n",
" 17 2004-08-21 Iron, Total ug/L NaN \n",
" 19 2004-08-30 Iron, Total ug/L NaN \n",
" 20 2004-09-06 Iron, Total ug/L NaN \n",
" 23 2004-09-27 Iron, Total ug/L NaN \n",
" 24 2004-10-13 Iron, Total ug/L NaN \n",
"\n",
"Station Subsurface \n",
"Quantity res \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L NaN \n",
" 4 2004-06-15 Iron, Total ug/L NaN \n",
" 7 2004-06-25 Iron, Total ug/L NaN \n",
" 11 2004-07-18 Iron, Total ug/L NaN \n",
" 16 2004-08-12 Iron, Total ug/L NaN \n",
" 17 2004-08-21 Iron, Total ug/L NaN \n",
" 19 2004-08-30 Iron, Total ug/L NaN \n",
" 20 2004-09-06 Iron, Total ug/L NaN \n",
" 23 2004-09-27 Iron, Total ug/L NaN \n",
" 24 2004-10-13 Iron, Total ug/L NaN "
]
}
],
"prompt_number": 7
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Reorder the columns so things are more logical (to me)"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"the_columns_i_want = [\n",
" ('Inflow', 'res'), ('Inflow', 'qual'),\n",
" ('Outflow','res'), ('Outflow', 'qual'), \n",
" ('Subsurface', 'res'), ('Subsurface', 'qual'),\n",
" ('Reference Outflow', 'res'),('Reference Outflow', 'qual')\n",
"]\n",
"table = table[the_columns_i_want]\n",
"table.head(10) # show only 10 rows"
],
"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>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th>Station</th>\n",
" <th colspan=\"2\" halign=\"left\">Inflow</th>\n",
" <th colspan=\"2\" halign=\"left\">Outflow</th>\n",
" <th colspan=\"2\" halign=\"left\">Subsurface</th>\n",
" <th colspan=\"2\" halign=\"left\">Reference Outflow</th>\n",
" </tr>\n",
" <tr>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th>Quantity</th>\n",
" <th>res</th>\n",
" <th>qual</th>\n",
" <th>res</th>\n",
" <th>qual</th>\n",
" <th>res</th>\n",
" <th>qual</th>\n",
" <th>res</th>\n",
" <th>qual</th>\n",
" </tr>\n",
" <tr>\n",
" <th>bmp_category</th>\n",
" <th>site_id</th>\n",
" <th>bmp_id</th>\n",
" <th>storm</th>\n",
" <th>datetime</th>\n",
" <th>parameter</th>\n",
" <th>wq_unit</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></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=\"10\" valign=\"top\">BR</th>\n",
" <th rowspan=\"10\" valign=\"top\">-2095595724</th>\n",
" <th rowspan=\"10\" valign=\"top\">2021385642</th>\n",
" <th>1 </th>\n",
" <th>2004-05-30</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> 25</td>\n",
" <td> =</td>\n",
" <td> 560</td>\n",
" <td> =</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <th>2004-06-15</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> 530</td>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <th>2004-06-25</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> 250</td>\n",
" <td> =</td>\n",
" <td> 500</td>\n",
" <td> =</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <th>2004-07-18</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> 650</td>\n",
" <td> =</td>\n",
" <td> 1720</td>\n",
" <td> =</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <th>2004-08-12</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> 590</td>\n",
" <td> =</td>\n",
" <td> 260</td>\n",
" <td> =</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <th>2004-08-21</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 260</td>\n",
" <td> =</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <th>2004-08-30</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> 250</td>\n",
" <td> =</td>\n",
" <td> 200</td>\n",
" <td> =</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <th>2004-09-06</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> 680</td>\n",
" <td> =</td>\n",
" <td> 110</td>\n",
" <td> =</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <th>2004-09-27</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> 570</td>\n",
" <td> =</td>\n",
" <td> 500</td>\n",
" <td> =</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <th>2004-10-13</th>\n",
" <th>Iron, Total</th>\n",
" <th>ug/L</th>\n",
" <td> 1440</td>\n",
" <td> =</td>\n",
" <td> 630</td>\n",
" <td> =</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"output_type": "pyout",
"prompt_number": 8,
"text": [
"Station Inflow \\\n",
"Quantity res \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L 25 \n",
" 4 2004-06-15 Iron, Total ug/L 530 \n",
" 7 2004-06-25 Iron, Total ug/L 250 \n",
" 11 2004-07-18 Iron, Total ug/L 650 \n",
" 16 2004-08-12 Iron, Total ug/L 590 \n",
" 17 2004-08-21 Iron, Total ug/L NaN \n",
" 19 2004-08-30 Iron, Total ug/L 250 \n",
" 20 2004-09-06 Iron, Total ug/L 680 \n",
" 23 2004-09-27 Iron, Total ug/L 570 \n",
" 24 2004-10-13 Iron, Total ug/L 1440 \n",
"\n",
"Station Inflow \\\n",
"Quantity qual \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L = \n",
" 4 2004-06-15 Iron, Total ug/L = \n",
" 7 2004-06-25 Iron, Total ug/L = \n",
" 11 2004-07-18 Iron, Total ug/L = \n",
" 16 2004-08-12 Iron, Total ug/L = \n",
" 17 2004-08-21 Iron, Total ug/L NaN \n",
" 19 2004-08-30 Iron, Total ug/L = \n",
" 20 2004-09-06 Iron, Total ug/L = \n",
" 23 2004-09-27 Iron, Total ug/L = \n",
" 24 2004-10-13 Iron, Total ug/L = \n",
"\n",
"Station Outflow \\\n",
"Quantity res \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L 560 \n",
" 4 2004-06-15 Iron, Total ug/L NaN \n",
" 7 2004-06-25 Iron, Total ug/L 500 \n",
" 11 2004-07-18 Iron, Total ug/L 1720 \n",
" 16 2004-08-12 Iron, Total ug/L 260 \n",
" 17 2004-08-21 Iron, Total ug/L 260 \n",
" 19 2004-08-30 Iron, Total ug/L 200 \n",
" 20 2004-09-06 Iron, Total ug/L 110 \n",
" 23 2004-09-27 Iron, Total ug/L 500 \n",
" 24 2004-10-13 Iron, Total ug/L 630 \n",
"\n",
"Station Outflow \\\n",
"Quantity qual \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L = \n",
" 4 2004-06-15 Iron, Total ug/L NaN \n",
" 7 2004-06-25 Iron, Total ug/L = \n",
" 11 2004-07-18 Iron, Total ug/L = \n",
" 16 2004-08-12 Iron, Total ug/L = \n",
" 17 2004-08-21 Iron, Total ug/L = \n",
" 19 2004-08-30 Iron, Total ug/L = \n",
" 20 2004-09-06 Iron, Total ug/L = \n",
" 23 2004-09-27 Iron, Total ug/L = \n",
" 24 2004-10-13 Iron, Total ug/L = \n",
"\n",
"Station Subsurface \\\n",
"Quantity res \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L NaN \n",
" 4 2004-06-15 Iron, Total ug/L NaN \n",
" 7 2004-06-25 Iron, Total ug/L NaN \n",
" 11 2004-07-18 Iron, Total ug/L NaN \n",
" 16 2004-08-12 Iron, Total ug/L NaN \n",
" 17 2004-08-21 Iron, Total ug/L NaN \n",
" 19 2004-08-30 Iron, Total ug/L NaN \n",
" 20 2004-09-06 Iron, Total ug/L NaN \n",
" 23 2004-09-27 Iron, Total ug/L NaN \n",
" 24 2004-10-13 Iron, Total ug/L NaN \n",
"\n",
"Station Subsurface \\\n",
"Quantity qual \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L NaN \n",
" 4 2004-06-15 Iron, Total ug/L NaN \n",
" 7 2004-06-25 Iron, Total ug/L NaN \n",
" 11 2004-07-18 Iron, Total ug/L NaN \n",
" 16 2004-08-12 Iron, Total ug/L NaN \n",
" 17 2004-08-21 Iron, Total ug/L NaN \n",
" 19 2004-08-30 Iron, Total ug/L NaN \n",
" 20 2004-09-06 Iron, Total ug/L NaN \n",
" 23 2004-09-27 Iron, Total ug/L NaN \n",
" 24 2004-10-13 Iron, Total ug/L NaN \n",
"\n",
"Station Reference Outflow \\\n",
"Quantity res \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L NaN \n",
" 4 2004-06-15 Iron, Total ug/L NaN \n",
" 7 2004-06-25 Iron, Total ug/L NaN \n",
" 11 2004-07-18 Iron, Total ug/L NaN \n",
" 16 2004-08-12 Iron, Total ug/L NaN \n",
" 17 2004-08-21 Iron, Total ug/L NaN \n",
" 19 2004-08-30 Iron, Total ug/L NaN \n",
" 20 2004-09-06 Iron, Total ug/L NaN \n",
" 23 2004-09-27 Iron, Total ug/L NaN \n",
" 24 2004-10-13 Iron, Total ug/L NaN \n",
"\n",
"Station Reference Outflow \n",
"Quantity qual \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -2095595724 2021385642 1 2004-05-30 Iron, Total ug/L NaN \n",
" 4 2004-06-15 Iron, Total ug/L NaN \n",
" 7 2004-06-25 Iron, Total ug/L NaN \n",
" 11 2004-07-18 Iron, Total ug/L NaN \n",
" 16 2004-08-12 Iron, Total ug/L NaN \n",
" 17 2004-08-21 Iron, Total ug/L NaN \n",
" 19 2004-08-30 Iron, Total ug/L NaN \n",
" 20 2004-09-06 Iron, Total ug/L NaN \n",
" 23 2004-09-27 Iron, Total ug/L NaN \n",
" 24 2004-10-13 Iron, Total ug/L NaN "
]
}
],
"prompt_number": 8
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Select data where the outflow is ND\n",
"This cell uses so-called fancy indexing. In other words `table.Outflow.qual == 'ND'` returns a `DataFrame` of `True`/`False` values. So using that `DataFrame` to index another `DataFrame` returns results only where the fancy index is `True`"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"outflow_non_detects = table[table.Outflow.qual == 'ND']\n",
"print(outflow_non_detects.shape)\n",
"outflow_non_detects.head(10)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"(7359, 8)\n"
]
},
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th>Station</th>\n",
" <th colspan=\"2\" halign=\"left\">Inflow</th>\n",
" <th colspan=\"2\" halign=\"left\">Outflow</th>\n",
" <th colspan=\"2\" halign=\"left\">Subsurface</th>\n",
" <th colspan=\"2\" halign=\"left\">Reference Outflow</th>\n",
" </tr>\n",
" <tr>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th>Quantity</th>\n",
" <th>res</th>\n",
" <th>qual</th>\n",
" <th>res</th>\n",
" <th>qual</th>\n",
" <th>res</th>\n",
" <th>qual</th>\n",
" <th>res</th>\n",
" <th>qual</th>\n",
" </tr>\n",
" <tr>\n",
" <th>bmp_category</th>\n",
" <th>site_id</th>\n",
" <th>bmp_id</th>\n",
" <th>storm</th>\n",
" <th>datetime</th>\n",
" <th>parameter</th>\n",
" <th>wq_unit</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></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=\"10\" valign=\"top\">BR</th>\n",
" <th rowspan=\"5\" valign=\"top\">-1212964512</th>\n",
" <th rowspan=\"5\" valign=\"top\"> 955001040 </th>\n",
" <th>7 </th>\n",
" <th>2005-03-08</th>\n",
" <th>Zinc, Total</th>\n",
" <th>ug/L</th>\n",
" <td> 105.000</td>\n",
" <td> =</td>\n",
" <td> 10.00</td>\n",
" <td> ND</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11 </th>\n",
" <th>2005-05-21</th>\n",
" <th>Zinc, Total</th>\n",
" <th>ug/L</th>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 10.00</td>\n",
" <td> ND</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12 </th>\n",
" <th>2005-06-22</th>\n",
" <th>Zinc, Total</th>\n",
" <th>ug/L</th>\n",
" <td> 9.000</td>\n",
" <td> =</td>\n",
" <td> 10.00</td>\n",
" <td> ND</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21 </th>\n",
" <th>2006-03-13</th>\n",
" <th>Zinc, Total</th>\n",
" <th>ug/L</th>\n",
" <td> 51.000</td>\n",
" <td> =</td>\n",
" <td> 10.00</td>\n",
" <td> ND</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22 </th>\n",
" <th>2006-05-02</th>\n",
" <th>Zinc, Total</th>\n",
" <th>ug/L</th>\n",
" <td> 81.000</td>\n",
" <td> =</td>\n",
" <td> 10.00</td>\n",
" <td> ND</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"5\" valign=\"top\">-986553804 </th>\n",
" <th rowspan=\"5\" valign=\"top\">-1204806465</th>\n",
" <th>91 </th>\n",
" <th>2004-09-27</th>\n",
" <th>Lead, Dissolved</th>\n",
" <th>ug/L</th>\n",
" <td> 4.110</td>\n",
" <td> ND</td>\n",
" <td> 3.56</td>\n",
" <td> ND</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96 </th>\n",
" <th>2004-11-12</th>\n",
" <th>Lead, Dissolved</th>\n",
" <th>ug/L</th>\n",
" <td> 1.350</td>\n",
" <td> ND</td>\n",
" <td> 0.90</td>\n",
" <td> ND</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"2\" valign=\"top\">99 </th>\n",
" <th rowspan=\"2\" valign=\"top\">2004-11-30</th>\n",
" <th>Chromium, Dissolved</th>\n",
" <th>ug/L</th>\n",
" <td> 1.065</td>\n",
" <td> ND</td>\n",
" <td> 2.02</td>\n",
" <td> ND</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Lead, Dissolved</th>\n",
" <th>ug/L</th>\n",
" <td> 2.400</td>\n",
" <td> ND</td>\n",
" <td> 2.40</td>\n",
" <td> ND</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>100</th>\n",
" <th>2004-12-07</th>\n",
" <th>Chromium, Dissolved</th>\n",
" <th>ug/L</th>\n",
" <td> 2.130</td>\n",
" <td> ND</td>\n",
" <td> 1.10</td>\n",
" <td> ND</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"output_type": "pyout",
"prompt_number": 9,
"text": [
"Station Inflow \\\n",
"Quantity res \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -1212964512 955001040 7 2005-03-08 Zinc, Total ug/L 105.000 \n",
" 11 2005-05-21 Zinc, Total ug/L NaN \n",
" 12 2005-06-22 Zinc, Total ug/L 9.000 \n",
" 21 2006-03-13 Zinc, Total ug/L 51.000 \n",
" 22 2006-05-02 Zinc, Total ug/L 81.000 \n",
" -986553804 -1204806465 91 2004-09-27 Lead, Dissolved ug/L 4.110 \n",
" 96 2004-11-12 Lead, Dissolved ug/L 1.350 \n",
" 99 2004-11-30 Chromium, Dissolved ug/L 1.065 \n",
" Lead, Dissolved ug/L 2.400 \n",
" 100 2004-12-07 Chromium, Dissolved ug/L 2.130 \n",
"\n",
"Station Inflow \\\n",
"Quantity qual \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -1212964512 955001040 7 2005-03-08 Zinc, Total ug/L = \n",
" 11 2005-05-21 Zinc, Total ug/L NaN \n",
" 12 2005-06-22 Zinc, Total ug/L = \n",
" 21 2006-03-13 Zinc, Total ug/L = \n",
" 22 2006-05-02 Zinc, Total ug/L = \n",
" -986553804 -1204806465 91 2004-09-27 Lead, Dissolved ug/L ND \n",
" 96 2004-11-12 Lead, Dissolved ug/L ND \n",
" 99 2004-11-30 Chromium, Dissolved ug/L ND \n",
" Lead, Dissolved ug/L ND \n",
" 100 2004-12-07 Chromium, Dissolved ug/L ND \n",
"\n",
"Station Outflow \\\n",
"Quantity res \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -1212964512 955001040 7 2005-03-08 Zinc, Total ug/L 10.00 \n",
" 11 2005-05-21 Zinc, Total ug/L 10.00 \n",
" 12 2005-06-22 Zinc, Total ug/L 10.00 \n",
" 21 2006-03-13 Zinc, Total ug/L 10.00 \n",
" 22 2006-05-02 Zinc, Total ug/L 10.00 \n",
" -986553804 -1204806465 91 2004-09-27 Lead, Dissolved ug/L 3.56 \n",
" 96 2004-11-12 Lead, Dissolved ug/L 0.90 \n",
" 99 2004-11-30 Chromium, Dissolved ug/L 2.02 \n",
" Lead, Dissolved ug/L 2.40 \n",
" 100 2004-12-07 Chromium, Dissolved ug/L 1.10 \n",
"\n",
"Station Outflow \\\n",
"Quantity qual \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -1212964512 955001040 7 2005-03-08 Zinc, Total ug/L ND \n",
" 11 2005-05-21 Zinc, Total ug/L ND \n",
" 12 2005-06-22 Zinc, Total ug/L ND \n",
" 21 2006-03-13 Zinc, Total ug/L ND \n",
" 22 2006-05-02 Zinc, Total ug/L ND \n",
" -986553804 -1204806465 91 2004-09-27 Lead, Dissolved ug/L ND \n",
" 96 2004-11-12 Lead, Dissolved ug/L ND \n",
" 99 2004-11-30 Chromium, Dissolved ug/L ND \n",
" Lead, Dissolved ug/L ND \n",
" 100 2004-12-07 Chromium, Dissolved ug/L ND \n",
"\n",
"Station Subsurface \\\n",
"Quantity res \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -1212964512 955001040 7 2005-03-08 Zinc, Total ug/L NaN \n",
" 11 2005-05-21 Zinc, Total ug/L NaN \n",
" 12 2005-06-22 Zinc, Total ug/L NaN \n",
" 21 2006-03-13 Zinc, Total ug/L NaN \n",
" 22 2006-05-02 Zinc, Total ug/L NaN \n",
" -986553804 -1204806465 91 2004-09-27 Lead, Dissolved ug/L NaN \n",
" 96 2004-11-12 Lead, Dissolved ug/L NaN \n",
" 99 2004-11-30 Chromium, Dissolved ug/L NaN \n",
" Lead, Dissolved ug/L NaN \n",
" 100 2004-12-07 Chromium, Dissolved ug/L NaN \n",
"\n",
"Station Subsurface \\\n",
"Quantity qual \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -1212964512 955001040 7 2005-03-08 Zinc, Total ug/L NaN \n",
" 11 2005-05-21 Zinc, Total ug/L NaN \n",
" 12 2005-06-22 Zinc, Total ug/L NaN \n",
" 21 2006-03-13 Zinc, Total ug/L NaN \n",
" 22 2006-05-02 Zinc, Total ug/L NaN \n",
" -986553804 -1204806465 91 2004-09-27 Lead, Dissolved ug/L NaN \n",
" 96 2004-11-12 Lead, Dissolved ug/L NaN \n",
" 99 2004-11-30 Chromium, Dissolved ug/L NaN \n",
" Lead, Dissolved ug/L NaN \n",
" 100 2004-12-07 Chromium, Dissolved ug/L NaN \n",
"\n",
"Station Reference Outflow \\\n",
"Quantity res \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -1212964512 955001040 7 2005-03-08 Zinc, Total ug/L NaN \n",
" 11 2005-05-21 Zinc, Total ug/L NaN \n",
" 12 2005-06-22 Zinc, Total ug/L NaN \n",
" 21 2006-03-13 Zinc, Total ug/L NaN \n",
" 22 2006-05-02 Zinc, Total ug/L NaN \n",
" -986553804 -1204806465 91 2004-09-27 Lead, Dissolved ug/L NaN \n",
" 96 2004-11-12 Lead, Dissolved ug/L NaN \n",
" 99 2004-11-30 Chromium, Dissolved ug/L NaN \n",
" Lead, Dissolved ug/L NaN \n",
" 100 2004-12-07 Chromium, Dissolved ug/L NaN \n",
"\n",
"Station Reference Outflow \n",
"Quantity qual \n",
"bmp_category site_id bmp_id storm datetime parameter wq_unit \n",
"BR -1212964512 955001040 7 2005-03-08 Zinc, Total ug/L NaN \n",
" 11 2005-05-21 Zinc, Total ug/L NaN \n",
" 12 2005-06-22 Zinc, Total ug/L NaN \n",
" 21 2006-03-13 Zinc, Total ug/L NaN \n",
" 22 2006-05-02 Zinc, Total ug/L NaN \n",
" -986553804 -1204806465 91 2004-09-27 Lead, Dissolved ug/L NaN \n",
" 96 2004-11-12 Lead, Dissolved ug/L NaN \n",
" 99 2004-11-30 Chromium, Dissolved ug/L NaN \n",
" Lead, Dissolved ug/L NaN \n",
" 100 2004-12-07 Chromium, Dissolved ug/L NaN "
]
}
],
"prompt_number": 9
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Select all of the lead data from the first storm at each site.\n",
"This uses the `xs` (cross-section) method of the `DataFrame` to query the data based on the index"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"first_lead_data = table.xs([1, 'Lead, Dissolved'], level=['storm', 'parameter'])\n",
"print(first_lead_data.shape)\n",
"first_lead_data.head(10) # show only 10 rows"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"(117, 8)\n"
]
},
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th>Station</th>\n",
" <th colspan=\"2\" halign=\"left\">Inflow</th>\n",
" <th colspan=\"2\" halign=\"left\">Outflow</th>\n",
" <th colspan=\"2\" halign=\"left\">Subsurface</th>\n",
" <th colspan=\"2\" halign=\"left\">Reference Outflow</th>\n",
" </tr>\n",
" <tr>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th>Quantity</th>\n",
" <th>res</th>\n",
" <th>qual</th>\n",
" <th>res</th>\n",
" <th>qual</th>\n",
" <th>res</th>\n",
" <th>qual</th>\n",
" <th>res</th>\n",
" <th>qual</th>\n",
" </tr>\n",
" <tr>\n",
" <th>bmp_category</th>\n",
" <th>site_id</th>\n",
" <th>bmp_id</th>\n",
" <th>datetime</th>\n",
" <th>wq_unit</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></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=\"4\" valign=\"top\">BR</th>\n",
" <th rowspan=\"2\" valign=\"top\"> 829589938 </th>\n",
" <th rowspan=\"2\" valign=\"top\"> 824104735 </th>\n",
" <th>2005-04-02 01:40:00</th>\n",
" <th>ug/L</th>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 24.00</td>\n",
" <td> ND</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2005-04-02 12:30:00</th>\n",
" <th>ug/L</th>\n",
" <td> 24.00</td>\n",
" <td> ND</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"2\" valign=\"top\"> 1708200120</th>\n",
" <th rowspan=\"2\" valign=\"top\"> 1789503719</th>\n",
" <th>2011-05-11 09:54:00</th>\n",
" <th>ug/L</th>\n",
" <td> 1.00</td>\n",
" <td> ND</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2011-05-11 12:54:00</th>\n",
" <th>ug/L</th>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 1.00</td>\n",
" <td> ND</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"6\" valign=\"top\">CO</th>\n",
" <th rowspan=\"2\" valign=\"top\">-1921008256</th>\n",
" <th rowspan=\"2\" valign=\"top\"> 180459865 </th>\n",
" <th>2005-01-13 01:00:00</th>\n",
" <th>ug/L</th>\n",
" <td> 2.00</td>\n",
" <td> ND</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2005-01-13 11:45:00</th>\n",
" <th>ug/L</th>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 2.00</td>\n",
" <td> ND</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>-1197630208</th>\n",
" <th> 417626268 </th>\n",
" <th>1984-11-19 00:00:00</th>\n",
" <th>ug/L</th>\n",
" <td> 0.05</td>\n",
" <td> ND</td>\n",
" <td> 0.05</td>\n",
" <td> ND</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th> 906130135 </th>\n",
" <th> 1748436895</th>\n",
" <th>1982-08-20 00:00:00</th>\n",
" <th>ug/L</th>\n",
" <td> 62.50</td>\n",
" <td> =</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th> 906470166 </th>\n",
" <th> 1274374939</th>\n",
" <th>1988-04-26 00:00:00</th>\n",
" <th>ug/L</th>\n",
" <td> 1.04</td>\n",
" <td> =</td>\n",
" <td> 1.00</td>\n",
" <td> =</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th> 993058830 </th>\n",
" <th>-622733610 </th>\n",
" <th>1995-04-10 00:00:00</th>\n",
" <th>ug/L</th>\n",
" <td> 50.00</td>\n",
" <td> ND</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"output_type": "pyout",
"prompt_number": 10,
"text": [
"Station Inflow Inflow \\\n",
"Quantity res qual \n",
"bmp_category site_id bmp_id datetime wq_unit \n",
"BR 829589938 824104735 2005-04-02 01:40:00 ug/L NaN NaN \n",
" 2005-04-02 12:30:00 ug/L 24.00 ND \n",
" 1708200120 1789503719 2011-05-11 09:54:00 ug/L 1.00 ND \n",
" 2011-05-11 12:54:00 ug/L NaN NaN \n",
"CO -1921008256 180459865 2005-01-13 01:00:00 ug/L 2.00 ND \n",
" 2005-01-13 11:45:00 ug/L NaN NaN \n",
" -1197630208 417626268 1984-11-19 00:00:00 ug/L 0.05 ND \n",
" 906130135 1748436895 1982-08-20 00:00:00 ug/L 62.50 = \n",
" 906470166 1274374939 1988-04-26 00:00:00 ug/L 1.04 = \n",
" 993058830 -622733610 1995-04-10 00:00:00 ug/L 50.00 ND \n",
"\n",
"Station Outflow \\\n",
"Quantity res \n",
"bmp_category site_id bmp_id datetime wq_unit \n",
"BR 829589938 824104735 2005-04-02 01:40:00 ug/L 24.00 \n",
" 2005-04-02 12:30:00 ug/L NaN \n",
" 1708200120 1789503719 2011-05-11 09:54:00 ug/L NaN \n",
" 2011-05-11 12:54:00 ug/L 1.00 \n",
"CO -1921008256 180459865 2005-01-13 01:00:00 ug/L NaN \n",
" 2005-01-13 11:45:00 ug/L 2.00 \n",
" -1197630208 417626268 1984-11-19 00:00:00 ug/L 0.05 \n",
" 906130135 1748436895 1982-08-20 00:00:00 ug/L NaN \n",
" 906470166 1274374939 1988-04-26 00:00:00 ug/L 1.00 \n",
" 993058830 -622733610 1995-04-10 00:00:00 ug/L NaN \n",
"\n",
"Station Outflow \\\n",
"Quantity qual \n",
"bmp_category site_id bmp_id datetime wq_unit \n",
"BR 829589938 824104735 2005-04-02 01:40:00 ug/L ND \n",
" 2005-04-02 12:30:00 ug/L NaN \n",
" 1708200120 1789503719 2011-05-11 09:54:00 ug/L NaN \n",
" 2011-05-11 12:54:00 ug/L ND \n",
"CO -1921008256 180459865 2005-01-13 01:00:00 ug/L NaN \n",
" 2005-01-13 11:45:00 ug/L ND \n",
" -1197630208 417626268 1984-11-19 00:00:00 ug/L ND \n",
" 906130135 1748436895 1982-08-20 00:00:00 ug/L NaN \n",
" 906470166 1274374939 1988-04-26 00:00:00 ug/L = \n",
" 993058830 -622733610 1995-04-10 00:00:00 ug/L NaN \n",
"\n",
"Station Subsurface \\\n",
"Quantity res \n",
"bmp_category site_id bmp_id datetime wq_unit \n",
"BR 829589938 824104735 2005-04-02 01:40:00 ug/L NaN \n",
" 2005-04-02 12:30:00 ug/L NaN \n",
" 1708200120 1789503719 2011-05-11 09:54:00 ug/L NaN \n",
" 2011-05-11 12:54:00 ug/L NaN \n",
"CO -1921008256 180459865 2005-01-13 01:00:00 ug/L NaN \n",
" 2005-01-13 11:45:00 ug/L NaN \n",
" -1197630208 417626268 1984-11-19 00:00:00 ug/L NaN \n",
" 906130135 1748436895 1982-08-20 00:00:00 ug/L NaN \n",
" 906470166 1274374939 1988-04-26 00:00:00 ug/L NaN \n",
" 993058830 -622733610 1995-04-10 00:00:00 ug/L NaN \n",
"\n",
"Station Subsurface \\\n",
"Quantity qual \n",
"bmp_category site_id bmp_id datetime wq_unit \n",
"BR 829589938 824104735 2005-04-02 01:40:00 ug/L NaN \n",
" 2005-04-02 12:30:00 ug/L NaN \n",
" 1708200120 1789503719 2011-05-11 09:54:00 ug/L NaN \n",
" 2011-05-11 12:54:00 ug/L NaN \n",
"CO -1921008256 180459865 2005-01-13 01:00:00 ug/L NaN \n",
" 2005-01-13 11:45:00 ug/L NaN \n",
" -1197630208 417626268 1984-11-19 00:00:00 ug/L NaN \n",
" 906130135 1748436895 1982-08-20 00:00:00 ug/L NaN \n",
" 906470166 1274374939 1988-04-26 00:00:00 ug/L NaN \n",
" 993058830 -622733610 1995-04-10 00:00:00 ug/L NaN \n",
"\n",
"Station Reference Outflow \\\n",
"Quantity res \n",
"bmp_category site_id bmp_id datetime wq_unit \n",
"BR 829589938 824104735 2005-04-02 01:40:00 ug/L NaN \n",
" 2005-04-02 12:30:00 ug/L NaN \n",
" 1708200120 1789503719 2011-05-11 09:54:00 ug/L NaN \n",
" 2011-05-11 12:54:00 ug/L NaN \n",
"CO -1921008256 180459865 2005-01-13 01:00:00 ug/L NaN \n",
" 2005-01-13 11:45:00 ug/L NaN \n",
" -1197630208 417626268 1984-11-19 00:00:00 ug/L NaN \n",
" 906130135 1748436895 1982-08-20 00:00:00 ug/L NaN \n",
" 906470166 1274374939 1988-04-26 00:00:00 ug/L NaN \n",
" 993058830 -622733610 1995-04-10 00:00:00 ug/L NaN \n",
"\n",
"Station Reference Outflow \n",
"Quantity qual \n",
"bmp_category site_id bmp_id datetime wq_unit \n",
"BR 829589938 824104735 2005-04-02 01:40:00 ug/L NaN \n",
" 2005-04-02 12:30:00 ug/L NaN \n",
" 1708200120 1789503719 2011-05-11 09:54:00 ug/L NaN \n",
" 2011-05-11 12:54:00 ug/L NaN \n",
"CO -1921008256 180459865 2005-01-13 01:00:00 ug/L NaN \n",
" 2005-01-13 11:45:00 ug/L NaN \n",
" -1197630208 417626268 1984-11-19 00:00:00 ug/L NaN \n",
" 906130135 1748436895 1982-08-20 00:00:00 ug/L NaN \n",
" 906470166 1274374939 1988-04-26 00:00:00 ug/L NaN \n",
" 993058830 -622733610 1995-04-10 00:00:00 ug/L NaN "
]
}
],
"prompt_number": 10
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Make boxplot of Total Zinc at Biorention cells \n",
"To acheive this, we need axis only the results data (assume ND = detection limit for simplicity). Note that there is not data for this \"cross-section\" at the subsurface and reference outflow monitoring locations, so no boxplots are expected at those locations on the x-axis."
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# set up the figure\n",
"fig, ax1 = plt.subplots()\n",
"\n",
"# sometime I like to preten I'm writing javascript and see how long of a command I can make\n",
"# the first call to \"xs\" queries the rows\n",
"# the second call to \"xs\" queries the columns\n",
"boxplot = table.xs(['BR', 'Zinc, Total'], level=['bmp_category', 'parameter'], axis=0).xs('res', level='Quantity', axis=1).boxplot(ax=ax1)\n",
"\n",
"# customize the figure\n",
"ax1.set_yscale('log')\n",
"ax1.set_ylabel(r'Zinc ($\\othermu$g/L) at bioretention BMPs')\n",
"ax1.yaxis.grid(True, which='major', linewidth=0.5, linestyle='-', alpha=0.35)\n",
"ax1.yaxis.grid(True, which='minor', linewidth=0.5, linestyle='-', alpha=0.17)\n",
"ax1.xaxis.grid(False)\n",
"utils.figutils.formatBoxplot(boxplot)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "display_data",
"svg": [
"<?xml version=\"1.0\" encoding=\"utf-8\" standalone=\"no\"?>\n",
"<!DOCTYPE svg PUBLIC \"-//W3C//DTD SVG 1.1//EN\"\n",
" \"http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd\">\n",
"<!-- Created with matplotlib (http://matplotlib.org/) -->\n",
"<svg height=\"249pt\" version=\"1.1\" viewBox=\"0 0 400 249\" width=\"400pt\" xmlns=\"http://www.w3.org/2000/svg\" xmlns:xlink=\"http://www.w3.org/1999/xlink\">\n",
" <defs>\n",
" <style type=\"text/css\">\n",
"*{stroke-linecap:square;stroke-linejoin:round;}\n",
" </style>\n",
" </defs>\n",
" <g id=\"figure_1\">\n",
" <g id=\"patch_1\">\n",
" <path d=\"\n",
"M0 249.611\n",
"L400.406 249.611\n",
"L400.406 0\n",
"L0 0\n",
"z\n",
"\" style=\"fill:#ffffff;\"/>\n",
" </g>\n",
" <g id=\"axes_1\">\n",
" <g id=\"patch_2\">\n",
" <path d=\"\n",
"M47.6055 227.445\n",
"L393.206 227.445\n",
"L393.206 11.4454\n",
"L47.6055 11.4454\n",
"z\n",
"\" style=\"fill:#ffffff;\"/>\n",
" </g>\n",
" <g id=\"matplotlib.axis_1\">\n",
" <g id=\"xtick_1\">\n",
" <g id=\"line2d_1\">\n",
" <defs>\n",
" <path d=\"\n",
"M0 0\n",
"L0 4\" id=\"mdad270ee8e\" style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\"/>\n",
" </defs>\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"90.8055148418\" xlink:href=\"#mdad270ee8e\" y=\"227.445439769\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_2\">\n",
" <defs>\n",
" <path d=\"\n",
"M0 0\n",
"L0 -4\" id=\"mcb557df647\" style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\"/>\n",
" </defs>\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"90.8055148418\" xlink:href=\"#mcb557df647\" y=\"11.4454397693\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"text_1\">\n",
" <!-- Inflow -->\n",
" <defs>\n",
" <path d=\"\n",
"M10.7031 45\n",
"L10.7031 8.4375\n",
"C10.7031 3.28125 10.4062 3.09375 3.20312 3.09375\n",
"L3.20312 0\n",
"L29.5938 0\n",
"L29.5938 3.09375\n",
"C20.5 3.09375 20.0938 3.29688 20.0938 8.42188\n",
"L20.0938 45\n",
"L32.2969 45\n",
"L32.2969 48.9844\n",
"L20.0938 48.9844\n",
"L20.0938 52.2656\n",
"C20.0938 67.7344 26 70.5 32 70.5\n",
"C36.5938 70.5 41.0938 68.0156 42.5938 62.8594\n",
"L42.5938 8.40625\n",
"C42.5938 3.28125 42.2969 3.09375 35.0938 3.09375\n",
"L35.0938 0\n",
"L59.5 0\n",
"L59.5 3.09375\n",
"C52.4062 3.09375 52 3.28125 52 8.40625\n",
"L52 73.4062\n",
"L51.2969 74\n",
"L45 71.2031\n",
"C42.2031 72.7969 37.9062 74 32.5 74\n",
"C25.4062 74 19.7969 71.7188 16.0938 67.8281\n",
"C12.5938 64.2656 10.7031 58.8125 10.7031 51.0625\n",
"L10.7031 48.9844\n",
"L3 48.9844\n",
"L3 45\n",
"z\n",
"\" id=\"Utopia_Regular-3\"/>\n",
" <path d=\"\n",
"M52.9062 34.0625\n",
"C52.9062 44.1875 47.4062 50 38.2031 50\n",
"C30.7969 50 26.2031 46.4062 20 42.4375\n",
"L18.5938 50\n",
"L3.70312 47.5156\n",
"L3.70312 45.0156\n",
"L7.5 44.5156\n",
"C10.0938 44.125 10.7031 43.6094 10.7031 40\n",
"L10.7031 8.40625\n",
"C10.7031 3.28125 10.4062 3.09375 3.20312 3.09375\n",
"L3.20312 0\n",
"L27.5938 0\n",
"L27.5938 3.09375\n",
"C20.5 3.09375 20.0938 3.28125 20.0938 8.40625\n",
"L20.0938 31.875\n",
"C20.0938 34.375 20.2969 35.7969 21.0938 37.4062\n",
"C23.2031 41.2969 27.7031 44.625 33 44.625\n",
"C39.7969 44.625 43.5 40.7969 43.5 32.0781\n",
"L43.5 8.40625\n",
"C43.5 3.28125 43.2031 3.09375 36 3.09375\n",
"L36 0\n",
"L60.4062 0\n",
"L60.4062 3.09375\n",
"C53.2969 3.09375 52.9062 3.28125 52.9062 8.40625\n",
"z\n",
"\" id=\"Utopia_Regular-110\"/>\n",
" <path d=\"\n",
"M28.7969 50\n",
"C12.7969 50 4.90625 40.5625 4.90625 24.5\n",
"C4.90625 8.42188 12.7969 -1 28.7969 -1\n",
"C45 -1 52.7969 8.42188 52.7969 24.5\n",
"C52.7969 40.5625 45 50 28.7969 50\n",
"M15.2969 24.5\n",
"C15.2969 38.1719 19.7031 46.5156 28.7969 46.5156\n",
"C38.0938 46.5156 42.4062 38.1719 42.4062 24.5\n",
"C42.4062 10.8125 38.0938 2.48438 28.7969 2.48438\n",
"C19.7031 2.48438 15.2969 10.8125 15.2969 24.5\" id=\"Utopia_Regular-111\"/>\n",
" <path d=\"\n",
"M-0.203125 48.9844\n",
"L-0.203125 46\n",
"C3.90625 46 5.20312 45.7031 6.40625 41.875\n",
"C10.5938 28.6562 15 15.125 19.2031 0\n",
"L26.7969 0\n",
"L38.5938 38\n",
"L38.9062 38\n",
"C43.0938 25.3281 47.2031 12.6719 51.2031 0\n",
"L58.7969 0\n",
"C63 14.7656 68.9062 32.6562 71.4062 40.4844\n",
"C73.0938 45.6094 74.2031 46 79.2031 46\n",
"L79.2031 48.9844\n",
"L59.5 48.9844\n",
"L59.5 46.0938\n",
"L65.2031 45.6094\n",
"C66.9062 45.4062 67 44.0938 66.5938 42.2969\n",
"C65.2969 36.3906 60.7031 20.1875 57.5938 8.875\n",
"L57.4062 8.875\n",
"C53.0938 21.8438 49 34.6875 44.9062 47.6562\n",
"L37.2969 47.6562\n",
"L25.7031 8.875\n",
"L25.5 8.875\n",
"C21.9062 20.375 18.7969 32 15.5938 42.7969\n",
"C15 44.7031 15.5938 45.6094 17.4062 45.7969\n",
"L20.9062 46.0938\n",
"L20.9062 48.9844\n",
"z\n",
"\" id=\"Utopia_Regular-119\"/>\n",
" <path d=\"\n",
"M22.4062 59.9688\n",
"C22.4062 65.6094 22.7031 65.8125 31.4062 65.8125\n",
"L31.4062 69\n",
"L3.5 69\n",
"L3.5 65.8125\n",
"C12.2969 65.8125 12.5 65.6094 12.5 59.9688\n",
"L12.5 9.03125\n",
"C12.5 3.39062 12.2969 3.1875 3.5 3.1875\n",
"L3.5 0\n",
"L31.4062 0\n",
"L31.4062 3.1875\n",
"C22.7031 3.1875 22.4062 3.39062 22.4062 9.03125\n",
"z\n",
"\" id=\"Utopia_Regular-73\"/>\n",
" </defs>\n",
" <g transform=\"translate(77.6371228742 242.411291702)scale(0.1 -0.1)\">\n",
" <use transform=\"translate(0.0 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-73\"/>\n",
" <use transform=\"translate(30.2864046204 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-110\"/>\n",
" <use transform=\"translate(86.9738511101 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-3\"/>\n",
" <use transform=\"translate(142.864237746 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-111\"/>\n",
" <use transform=\"translate(192.976335689 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-119\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"xtick_2\">\n",
" <g id=\"line2d_3\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"177.205514842\" xlink:href=\"#mdad270ee8e\" y=\"227.445439769\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_4\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"177.205514842\" xlink:href=\"#mcb557df647\" y=\"11.4454397693\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"text_2\">\n",
" <!-- Outflow -->\n",
" <defs>\n",
" <path d=\"\n",
"M32.5938 45\n",
"L32.5938 48.9844\n",
"L19.7031 48.9844\n",
"L19.7031 61.5\n",
"L16.7969 61.5\n",
"L10.7031 48.9844\n",
"L3.09375 48.9844\n",
"L3.09375 45\n",
"L10.2969 45\n",
"L10.2969 10.3438\n",
"C10.2969 0.1875 17.9062 -1 21.4062 -1\n",
"C26.5 -1 31.2969 1.57812 34.2031 3.375\n",
"L33.4062 5.46875\n",
"C31 4.46875 28.7969 4.17188 26.2969 4.17188\n",
"C22.9062 4.17188 19.7031 6.5625 19.7031 14.125\n",
"L19.7031 45\n",
"z\n",
"\" id=\"Utopia_Regular-116\"/>\n",
" <path d=\"\n",
"M59.0938 0.1875\n",
"L59.0938 3.07812\n",
"C52.2031 3.57812 51.5938 3.76562 51.5938 8.85938\n",
"L51.5938 49.5938\n",
"L50.9062 50.1875\n",
"L35.2031 47.6875\n",
"L35.2031 45.2031\n",
"L39 44.7031\n",
"C41.5938 44.3125 42.2031 43.8125 42.2031 40.2188\n",
"L42.2031 17.8125\n",
"C42.2031 15.0312 41.9062 12.8438 41.4062 11.8438\n",
"C39.0938 7.26562 34.2969 4.375 29.0938 4.375\n",
"C23.2969 4.375 19 7.95312 19 15.7188\n",
"L19 49.5938\n",
"L18.2969 50.1875\n",
"L2.59375 47.6875\n",
"L2.59375 45.2031\n",
"L6.40625 44.7031\n",
"C9 44.3125 9.59375 43.8125 9.59375 40.2188\n",
"L9.59375 13.9375\n",
"C9.59375 2.48438 16.4062 -1 23.7969 -1\n",
"C32.2969 -1 39.2031 4.76562 42.0938 6.15625\n",
"L43.0938 0.1875\n",
"z\n",
"\" id=\"Utopia_Regular-117\"/>\n",
" <path d=\"\n",
"M38.0938 67.5156\n",
"C55.9062 67.5156 60 49.6562 60.2031 35\n",
"C60 20.3438 55.9062 2.48438 38.0938 2.48438\n",
"C20.2969 2.48438 16.2031 20.3438 16 35\n",
"C16.2031 49.6562 20.2969 67.5156 38.0938 67.5156\n",
"M38.0938 71\n",
"C27.0938 71 18.9062 67.625 13.2969 61.3281\n",
"C7.90625 55.3594 4.79688 46.2812 4.79688 35\n",
"C4.79688 23.8438 7.90625 14.6562 13.2969 8.6875\n",
"C18.9062 2.39062 27.0938 -1 38.0938 -1\n",
"C49.2031 -1 57.2969 2.39062 62.9062 8.6875\n",
"C68.4062 14.6562 71.4062 23.8438 71.4062 35\n",
"C71.4062 46.2812 68.4062 55.3594 62.9062 61.3281\n",
"C57.2969 67.625 49.2031 71 38.0938 71\" id=\"Utopia_Regular-79\"/>\n",
" </defs>\n",
" <g transform=\"translate(160.570128376 242.411291702)scale(0.1 -0.1)\">\n",
" <use transform=\"translate(0.0 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-79\"/>\n",
" <use transform=\"translate(69.2404094995 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-117\"/>\n",
" <use transform=\"translate(124.83189869 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-116\"/>\n",
" <use transform=\"translate(156.313832284 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-3\"/>\n",
" <use transform=\"translate(212.20421892 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-111\"/>\n",
" <use transform=\"translate(262.316316864 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-119\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"xtick_3\">\n",
" <g id=\"line2d_5\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"263.605514842\" xlink:href=\"#mdad270ee8e\" y=\"227.445439769\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_6\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"263.605514842\" xlink:href=\"#mcb557df647\" y=\"11.4454397693\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"text_3\">\n",
" <!-- Subsurface -->\n",
" <defs>\n",
" <path d=\"\n",
"M6 4.98438\n",
"C10.4062 0.890625 18.7031 -1 25.7031 -1\n",
"C43.4062 -1 50.4062 9.07812 50.4062 19.25\n",
"C50.4062 31.0156 42.4062 36.5938 30.7031 40.9062\n",
"L27.5 42.0938\n",
"C20.7969 44.5781 15.2031 48.8594 15.2031 54.8594\n",
"C15.2031 62.1406 19.5938 67.5156 28 67.5156\n",
"C36.5938 67.5156 41.4062 62.6406 43 52.5625\n",
"L46.0938 52.5625\n",
"L46.0938 66.625\n",
"C42.7031 69.3125 35.9062 71 29.0938 71\n",
"C16.9062 71 6.09375 64.9219 6.09375 51.75\n",
"C6.09375 41.2812 14.5 35.7969 25 32.125\n",
"L26.7969 31.4219\n",
"C31.2031 29.7188 40.7031 25.125 40.7031 16.25\n",
"C40.7031 7.67188 35.2031 2.48438 26.2969 2.48438\n",
"C16.9062 2.48438 10.7031 9.78125 8.20312 20.9531\n",
"L5 20.9531\n",
"z\n",
"\" id=\"Utopia_Regular-83\"/>\n",
" <path d=\"\n",
"M34.2969 14.3125\n",
"C34.2969 6.26562 28.0938 4.17188 24.2031 4.17188\n",
"C18 4.17188 15 8.54688 15 14.4219\n",
"C15 19.0781 17.2031 21.4688 22.7969 23.5625\n",
"C26.7969 25.0469 32.0938 26.9375 34.2969 28.3281\n",
"z\n",
"\n",
"M43.2969 36.7656\n",
"C43.2969 42.5469 42 50 26.9062 50\n",
"C15.5938 50 6.70312 44.1406 6.70312 38.6562\n",
"C6.70312 35.4844 10.4062 34 12.2969 34\n",
"C14.4062 34 15 35.0938 15.5 36.7812\n",
"C17.7031 44.125 21.7969 46.5156 25.7969 46.5156\n",
"C29.7031 46.5156 34.2969 44.5156 34.2969 36.5625\n",
"L34.2969 32.4062\n",
"C31.7969 29.8281 22.0938 27.3594 14.2031 24.8594\n",
"C7 22.6875 4.90625 17.7188 4.90625 13.0781\n",
"C4.90625 5.64062 9.90625 -1 19.2969 -1\n",
"C25.5 -1 31 2.75 34.2031 4.875\n",
"C35.5938 1.25 37.2031 -1 40.7031 -1\n",
"C44.4062 -1 48.7031 0.0625 52.5 1.89062\n",
"L51.9062 4.26562\n",
"C50.5 3.96875 48.2969 3.76562 46.7969 4.15625\n",
"C45 4.5625 43.2969 6.45312 43.2969 12.7188\n",
"z\n",
"\" id=\"Utopia_Regular-97\"/>\n",
" <path d=\"\n",
"M18.9062 50\n",
"L3.70312 47.5156\n",
"L3.70312 45.0156\n",
"L7.5 44.5156\n",
"C10.0938 44.125 10.7031 43.625 10.7031 40.0312\n",
"L10.7031 8.67188\n",
"C10.7031 3.57812 10.2031 3.39062 3.20312 2.89062\n",
"L3.20312 0\n",
"L29.5938 0\n",
"L29.5938 3.09375\n",
"C20.7031 3.09375 20.0938 3.28125 20.0938 8.42188\n",
"L20.0938 31.8906\n",
"C20.0938 39.625 23.5 42.2344 25.7969 42.2344\n",
"C27.4062 42.2344 29.0938 41.625 32 40.0312\n",
"C32.7031 39.6406 33.5 39.5469 34 39.5469\n",
"C36.4062 39.5469 38.5938 42.0312 38.5938 45.1094\n",
"C38.5938 47.3125 37.2031 50 33.2969 50\n",
"C29.7031 50 26.7031 47.8125 20.0938 42.0312\n",
"z\n",
"\" id=\"Utopia_Regular-114\"/>\n",
" <path d=\"\n",
"M36.7031 35\n",
"L36.7031 46.6094\n",
"C33.4062 49 28.2969 50 23.7969 50\n",
"C13 50 5.70312 44.9375 5.59375 35.5156\n",
"C5.70312 27.2812 12.4062 23.6094 20.7031 21.125\n",
"C25.2031 19.75 31.5 17.4531 31.5 10.7188\n",
"C31.5 5.65625 27.5 2.48438 22.2031 2.48438\n",
"C14.0938 2.48438 9.59375 8.32812 7.59375 16.75\n",
"L4.70312 16.75\n",
"L5.70312 3.75\n",
"C9.29688 0.578125 15.4062 -1 21.2969 -1\n",
"C33.2031 -1 40 5.23438 40 13.6719\n",
"C40 22.4062 34.5938 26.375 24.2969 29.5469\n",
"C20.2031 30.8438 13.5938 32.9062 13.5938 38.4688\n",
"C13.7031 43.6406 17.5938 46.5156 22.5938 46.5156\n",
"C29.7031 46.5156 33.0938 41.0469 33.7969 35\n",
"z\n",
"\" id=\"Utopia_Regular-115\"/>\n",
" <path d=\"\n",
"M10.7969 -1\n",
"L14.7969 2.875\n",
"C18.2969 0.890625 22.5 -1 30 -1\n",
"C43.2969 -1 54.9062 5.34375 54.9062 25.5938\n",
"C54.9062 31.7344 53.5938 50 35.5938 50\n",
"C28 50 22.0938 45.125 18.4062 42.9375\n",
"L18.4062 73.2969\n",
"L17.7031 73.9062\n",
"L2 71.4062\n",
"L2 68.9219\n",
"L5.79688 68.5156\n",
"C8.40625 68.2188 9 67.7188 9 63.9531\n",
"L9 -0.203125\n",
"z\n",
"\n",
"M18.4062 32.0312\n",
"C18.4062 34.5 18.5938 36.0781 19.4062 37.6719\n",
"C21.7969 42.4375 26 44.625 31.5938 44.625\n",
"C35.7031 44.625 44.5 42.25 44.5 25\n",
"C44.5 10.4219 40 2.48438 30.0938 2.48438\n",
"C24.7969 2.48438 20.9062 5.15625 19.0938 10.1094\n",
"C18.5 11.8906 18.4062 13.9844 18.4062 16.3594\n",
"z\n",
"\" id=\"Utopia_Regular-98\"/>\n",
" <path d=\"\n",
"M30 4.17188\n",
"C18.0938 4.17188 15.2969 16.4688 15.2969 25.7969\n",
"C15.2969 40.5625 21.2031 46.5156 28.0938 46.5156\n",
"C32.7031 46.5156 35.5938 43.2344 37.5938 37.875\n",
"C38.2031 36.2969 38.7969 35.2969 40.7031 35.2969\n",
"C42.7031 35.2969 46.5938 36.5938 46.5938 40.375\n",
"C46.5938 44.9375 40 50 29.2031 50\n",
"C11 50 4.90625 37.2031 4.90625 24\n",
"C4.90625 7.42188 13.0938 -1 28.0938 -1\n",
"C35.0938 -1 44.5 2.65625 47.2969 13.2969\n",
"L44.4062 14.6719\n",
"C41.2969 7.73438 37.2969 4.17188 30 4.17188\" id=\"Utopia_Regular-99\"/>\n",
" <path d=\"\n",
"M20.0938 45\n",
"L32.2969 45\n",
"L32.2969 48.9844\n",
"L20.0938 48.9844\n",
"L19.7031 60.0938\n",
"C19.4062 69.5156 22.9062 70.5 24.5 70.5\n",
"C26.5938 70.5 28.7969 69.5156 31.2969 63.7656\n",
"C31.7969 62.7656 32.5 62.0781 34 62.0781\n",
"C36 62.0781 38.9062 63.7656 38.9062 66.7344\n",
"C38.9062 70.0312 34.7031 74 26.7031 74\n",
"C21.2031 74 16.5 71.5156 14 67.75\n",
"C11.7031 64.2656 10.7031 59.0156 10.7031 52.4531\n",
"L10.7031 48.9844\n",
"L3 48.9844\n",
"L3 45\n",
"L10.7031 45\n",
"L10.7031 8.4375\n",
"C10.7031 3.28125 10.4062 3.09375 3.20312 3.09375\n",
"L3.20312 0\n",
"L29.5938 0\n",
"L29.5938 3.09375\n",
"C20.5 3.09375 20.0938 3.29688 20.0938 8.42188\n",
"z\n",
"\" id=\"Utopia_Regular-102\"/>\n",
" <path d=\"\n",
"M44.0938 26.2031\n",
"C46.2031 26.2031 48.0938 26.7188 48.0938 30.0781\n",
"C48.0938 36.0625 46.2031 50.4844 27.9062 50.4844\n",
"C12.2969 50.4844 4.90625 39.4062 4.90625 24.4375\n",
"C4.90625 8.67188 11.7031 -1 28 -1\n",
"C39.0938 -1 44.7969 5.125 47.5 13.0312\n",
"L44.5 14.6094\n",
"C41.7031 8.90625 37.9062 4.1875 30 4.1875\n",
"C17.5938 4.1875 15.0938 15.9688 15.2969 26.2031\n",
"z\n",
"\n",
"M15.4062 30\n",
"C15.4062 34.1875 16.9062 47 27.2969 47\n",
"C36.5938 47 37.7031 37.2656 37.7031 33.2812\n",
"C37.7031 31.3125 37.0938 30 34.2969 30\n",
"z\n",
"\" id=\"Utopia_Regular-101\"/>\n",
" </defs>\n",
" <g transform=\"translate(240.637293864 242.411291702)scale(0.1 -0.1)\">\n",
" <use transform=\"translate(0.0 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-83\"/>\n",
" <use transform=\"translate(47.4221273496 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-117\"/>\n",
" <use transform=\"translate(103.013616541 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-98\"/>\n",
" <use transform=\"translate(157.80815229 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-115\"/>\n",
" <use transform=\"translate(197.758329969 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-117\"/>\n",
" <use transform=\"translate(253.34981916 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-114\"/>\n",
" <use transform=\"translate(289.71342512 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-102\"/>\n",
" <use transform=\"translate(318.903978854 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-97\"/>\n",
" <use transform=\"translate(366.824268612 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-99\"/>\n",
" <use transform=\"translate(412.253928749 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-101\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"xtick_4\">\n",
" <g id=\"line2d_7\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"350.005514842\" xlink:href=\"#mdad270ee8e\" y=\"227.445439769\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_8\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"350.005514842\" xlink:href=\"#mcb557df647\" y=\"11.4454397693\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"text_4\">\n",
" <!-- Reference Outflow -->\n",
" <defs>\n",
" <path d=\"\n",
"M29.2969 32.5156\n",
"C35.2969 32.5156 39.9062 30.625 41.5938 23.8281\n",
"C42.2969 21.0469 43.4062 13.1562 44.5 8.57812\n",
"C46 2.1875 49.7969 0 55.7031 0\n",
"L63.7969 0\n",
"L63.7969 2.89062\n",
"C56 3.6875 54.4062 9.28125 53.5 16.0469\n",
"C52.2969 24.9375 50.5 31.625 39.9062 34.2031\n",
"L39.9062 34.4062\n",
"C49.2969 36.2031 56.2031 42.4688 56.2031 51.9531\n",
"C56.2031 61.5312 50.2031 69 32.7031 69\n",
"L3.5 69\n",
"L3.5 65.8125\n",
"C12.2969 65.8125 12.5 65.6094 12.5 59.9688\n",
"L12.5 9.03125\n",
"C12.5 3.39062 12.2969 3.1875 3.5 3.1875\n",
"L3.5 0\n",
"L31.4062 0\n",
"L31.4062 3.1875\n",
"C22.7031 3.1875 22.4062 3.39062 22.4062 9.03125\n",
"L22.4062 32.5156\n",
"z\n",
"\n",
"M22.4062 36\n",
"L22.4062 60.5312\n",
"C22.4062 64.7188 23.0938 65.5156 29.7031 65.5156\n",
"C37.0938 65.5156 45.5 62.8281 45.5 51.0625\n",
"C45.5 40.5781 40 36 30.2969 36\n",
"z\n",
"\" id=\"Utopia_Regular-82\"/>\n",
" </defs>\n",
" <g transform=\"translate(311.79606286 242.411291702)scale(0.1 -0.1)\">\n",
" <use transform=\"translate(0.0 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-82\"/>\n",
" <use transform=\"translate(57.1855784947 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-101\"/>\n",
" <use transform=\"translate(104.308823601 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-102\"/>\n",
" <use transform=\"translate(133.499377335 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-101\"/>\n",
" <use transform=\"translate(180.622622441 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-114\"/>\n",
" <use transform=\"translate(214.49559878 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-101\"/>\n",
" <use transform=\"translate(261.618843886 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-110\"/>\n",
" <use transform=\"translate(318.306290376 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-99\"/>\n",
" <use transform=\"translate(363.735950513 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-101\"/>\n",
" <use transform=\"translate(431.481827181 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-79\"/>\n",
" <use transform=\"translate(500.722236681 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-117\"/>\n",
" <use transform=\"translate(556.313725872 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-116\"/>\n",
" <use transform=\"translate(587.795659465 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-3\"/>\n",
" <use transform=\"translate(643.686046102 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-111\"/>\n",
" <use transform=\"translate(693.798144045 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-119\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"matplotlib.axis_2\">\n",
" <g id=\"ytick_1\">\n",
" <g id=\"line2d_9\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 227.445\n",
"L393.206 227.445\" style=\"fill:none;opacity:0.35;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_10\">\n",
" <defs>\n",
" <path d=\"\n",
"M0 0\n",
"L-4 0\" id=\"m0d5b0a6425\" style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\"/>\n",
" </defs>\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m0d5b0a6425\" y=\"227.445439769\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_11\">\n",
" <defs>\n",
" <path d=\"\n",
"M0 0\n",
"L4 0\" id=\"mc8fcea1516\" style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\"/>\n",
" </defs>\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#mc8fcea1516\" y=\"227.445439769\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"text_5\">\n",
" <!-- $10^{-1}$ -->\n",
" <defs>\n",
" <path d=\"\n",
"M43.7031 0\n",
"L43.7031 2.89062\n",
"L35.2969 3.57812\n",
"C33.2031 3.78125 32 4.57812 32 8.46875\n",
"L32 67.125\n",
"L31.5 67.7188\n",
"L10.9062 64.2344\n",
"L10.9062 61.75\n",
"L20.2031 60.6562\n",
"C21.9062 60.4531 22.5938 59.6562 22.5938 56.7656\n",
"L22.5938 8.46875\n",
"C22.5938 6.57812 22.2969 5.375 21.7031 4.6875\n",
"C21.2031 3.98438 20.4062 3.6875 19.2969 3.57812\n",
"L10.9062 2.89062\n",
"L10.9062 0\n",
"z\n",
"\" id=\"Utopia_Regular-49\"/>\n",
" <path d=\"\n",
"M26.5 64.5156\n",
"C36 64.5156 38.7031 49.7656 38.7031 33.5\n",
"C38.7031 17.2344 36 2.48438 26.5 2.48438\n",
"C17 2.48438 14.2969 17.2344 14.2969 33.5\n",
"C14.2969 49.7656 17 64.5156 26.5 64.5156\n",
"M26.5 68\n",
"C10 68 4.09375 53.4531 4.09375 33.5\n",
"C4.09375 13.5469 10 -1 26.5 -1\n",
"C43 -1 48.9062 13.5469 48.9062 33.5\n",
"C48.9062 53.4531 43 68 26.5 68\" id=\"Utopia_Regular-48\"/>\n",
" <path d=\"\n",
"M63.5 25.25\n",
"L63.5 31.0469\n",
"L8.5 31.0469\n",
"L8.5 25.25\n",
"z\n",
"\" id=\"Fourier-Math-Symbols-161\"/>\n",
" </defs>\n",
" <g transform=\"translate(21.1777014175 231.690879539)scale(0.1 -0.1)\">\n",
" <use transform=\"translate(0.0 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-49\"/>\n",
" <use transform=\"translate(48.6176715248 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-48\"/>\n",
" <use transform=\"translate(97.2353430495 38.2724329662)scale(0.696582760936)\" xlink:href=\"#Fourier-Math-Symbols-161\"/>\n",
" <use transform=\"translate(147.358979146 38.2724329662)scale(0.696582760936)\" xlink:href=\"#Utopia_Regular-49\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_2\">\n",
" <g id=\"line2d_12\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 184.245\n",
"L393.206 184.245\" style=\"fill:none;opacity:0.35;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_13\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m0d5b0a6425\" y=\"184.245439769\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_14\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#mc8fcea1516\" y=\"184.245439769\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"text_6\">\n",
" <!-- $10^{0}$ -->\n",
" <g transform=\"translate(26.1900939105 188.490879539)scale(0.1 -0.1)\">\n",
" <use transform=\"translate(0.0 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-49\"/>\n",
" <use transform=\"translate(48.6176715248 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-48\"/>\n",
" <use transform=\"translate(97.2353430495 38.2724329662)scale(0.696582760936)\" xlink:href=\"#Utopia_Regular-48\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_3\">\n",
" <g id=\"line2d_15\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 141.045\n",
"L393.206 141.045\" style=\"fill:none;opacity:0.35;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_16\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m0d5b0a6425\" y=\"141.045439769\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_17\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#mc8fcea1516\" y=\"141.045439769\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"text_7\">\n",
" <!-- $10^{1}$ -->\n",
" <g transform=\"translate(26.1900939105 145.290879539)scale(0.1 -0.1)\">\n",
" <use transform=\"translate(0.0 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-49\"/>\n",
" <use transform=\"translate(48.6176715248 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-48\"/>\n",
" <use transform=\"translate(97.2353430495 38.2724329662)scale(0.696582760936)\" xlink:href=\"#Utopia_Regular-49\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_4\">\n",
" <g id=\"line2d_18\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 97.8454\n",
"L393.206 97.8454\" style=\"fill:none;opacity:0.35;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_19\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m0d5b0a6425\" y=\"97.8454397693\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_20\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#mc8fcea1516\" y=\"97.8454397693\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"text_8\">\n",
" <!-- $10^{2}$ -->\n",
" <defs>\n",
" <path d=\"\n",
"M48.5 13.125\n",
"L45.7031 13.6094\n",
"C43.5938 8.26562 41.5938 7.5625 37.5938 7.5625\n",
"L12 7.5625\n",
"C13.5938 12.7344 19.5 19.7656 28.7969 26.4219\n",
"C38.4062 33.375 45.7969 37.8281 45.7969 48.9375\n",
"C45.7969 62.7188 36.5938 67.4844 26.0938 67.4844\n",
"C12.4062 67.4844 5.29688 59.25 5.29688 54.0938\n",
"C5.29688 50.7188 9.09375 49.125 10.7969 49.125\n",
"C12.5938 49.125 13.2969 50.125 13.7031 51.7969\n",
"C15.2969 58.5469 19.2031 64 25.4062 64\n",
"C33.0938 64 35.2969 57.5625 35.2969 50.3125\n",
"C35.2969 39.7031 29.9062 33.7344 21.2031 26.0938\n",
"C8.90625 15.4844 4.59375 8.73438 2.70312 1\n",
"L3.70312 0\n",
"L45.0938 0\n",
"z\n",
"\" id=\"Utopia_Regular-50\"/>\n",
" </defs>\n",
" <g transform=\"translate(26.1900939105 102.090879539)scale(0.1 -0.1)\">\n",
" <use transform=\"translate(0.0 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-49\"/>\n",
" <use transform=\"translate(48.6176715248 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-48\"/>\n",
" <use transform=\"translate(97.2353430495 38.2724329662)scale(0.696582760936)\" xlink:href=\"#Utopia_Regular-50\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_5\">\n",
" <g id=\"line2d_21\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 54.6454\n",
"L393.206 54.6454\" style=\"fill:none;opacity:0.35;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_22\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m0d5b0a6425\" y=\"54.6454397693\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_23\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#mc8fcea1516\" y=\"54.6454397693\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"text_9\">\n",
" <!-- $10^{3}$ -->\n",
" <defs>\n",
" <path d=\"\n",
"M13 36.7969\n",
"C13 35.1094 13.5 34 14.7969 34\n",
"C16 34 18.7031 35 23.5 35\n",
"C32 35 36.7969 27.2969 36.7969 18.5938\n",
"C36.7969 6.67188 30.9062 2.48438 23.7969 2.48438\n",
"C17.2031 2.48438 12.9062 7.46875 11 13.0781\n",
"C10.4062 14.9844 9.40625 15.8906 8 15.8906\n",
"C6.20312 15.8906 2.70312 14 2.70312 10.3906\n",
"C2.70312 6.09375 9.59375 -1 23.7031 -1\n",
"C38.2031 -1 47.2969 6.29688 47.2969 19.0938\n",
"C47.2969 32.5 35.7969 36.5 30.2969 37\n",
"L30.2969 37.3906\n",
"C35.7031 38.2969 44.4062 42.25 44.4062 52.1094\n",
"C44.4062 63.1406 35.7031 68 25 68\n",
"C11.7969 68 5.29688 60.4531 5.29688 56.1719\n",
"C5.29688 53.0938 8.79688 51.4062 10.2031 51.4062\n",
"C11.5 51.4062 12.2969 52.1094 12.7031 53.3906\n",
"C14.9062 60.1562 18.7031 64.5156 24.2969 64.5156\n",
"C32.2031 64.5156 34.0938 57.5625 34.0938 52\n",
"C34.0938 46.0469 32 38.5938 23.5 38.5938\n",
"C18.7031 38.5938 16 39.5781 14.7969 39.5781\n",
"C13.5 39.5781 13 38.5938 13 36.7969\" id=\"Utopia_Regular-51\"/>\n",
" </defs>\n",
" <g transform=\"translate(26.1900939105 58.8908795386)scale(0.1 -0.1)\">\n",
" <use transform=\"translate(0.0 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-49\"/>\n",
" <use transform=\"translate(48.6176715248 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-48\"/>\n",
" <use transform=\"translate(97.2353430495 38.2724329662)scale(0.696582760936)\" xlink:href=\"#Utopia_Regular-51\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_6\">\n",
" <g id=\"line2d_24\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 11.4454\n",
"L393.206 11.4454\" style=\"fill:none;opacity:0.35;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_25\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m0d5b0a6425\" y=\"11.4454397693\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_26\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#mc8fcea1516\" y=\"11.4454397693\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"text_10\">\n",
" <!-- $10^{4}$ -->\n",
" <defs>\n",
" <path d=\"\n",
"M30 18\n",
"L30 7.75\n",
"C30 4.32812 28.9062 3.71875 26.5 3.51562\n",
"L20.0938 2.92188\n",
"L20.0938 0\n",
"L46.5 0\n",
"L46.5 2.92188\n",
"L42 3.42188\n",
"C39.7031 3.71875 39 4.32812 39 7.75\n",
"L39 18\n",
"L49.2969 18\n",
"L49.2969 22.6875\n",
"L39 22.6875\n",
"L39 66.5\n",
"L31.7031 66.5\n",
"C22.2969 52.8125 11.0938 35.5625 1.90625 20.0938\n",
"L2.79688 18\n",
"z\n",
"\n",
"M9.09375 22.6875\n",
"C15.0938 33.5156 22.0938 44.9531 29.7969 57\n",
"L30 57\n",
"L30 22.6875\n",
"z\n",
"\" id=\"Utopia_Regular-52\"/>\n",
" </defs>\n",
" <g transform=\"translate(26.1900939105 15.6908795386)scale(0.1 -0.1)\">\n",
" <use transform=\"translate(0.0 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-49\"/>\n",
" <use transform=\"translate(48.6176715248 2.108061566)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-48\"/>\n",
" <use transform=\"translate(97.2353430495 38.2724329662)scale(0.696582760936)\" xlink:href=\"#Utopia_Regular-52\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_7\">\n",
" <g id=\"line2d_27\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 214.441\n",
"L393.206 214.441\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_28\">\n",
" <defs>\n",
" <path d=\"\n",
"M0 0\n",
"L-2 0\" id=\"m46a939d668\" style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\"/>\n",
" </defs>\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"214.440943957\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_29\">\n",
" <defs>\n",
" <path d=\"\n",
"M0 0\n",
"L2 0\" id=\"m57a2c8792a\" style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\"/>\n",
" </defs>\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"214.440943957\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_8\">\n",
" <g id=\"line2d_30\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 206.834\n",
"L393.206 206.834\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_31\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"206.833801565\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_32\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"206.833801565\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_9\">\n",
" <g id=\"line2d_33\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 201.436\n",
"L393.206 201.436\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_34\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"201.436448144\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_35\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"201.436448144\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_10\">\n",
" <g id=\"line2d_36\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 197.25\n",
"L393.206 197.25\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_37\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"197.249935582\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_38\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"197.249935582\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_11\">\n",
" <g id=\"line2d_39\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 193.829\n",
"L393.206 193.829\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_40\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"193.829305753\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_41\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"193.829305753\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_12\">\n",
" <g id=\"line2d_42\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 190.937\n",
"L393.206 190.937\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_43\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"190.937204441\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_44\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"190.937204441\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_13\">\n",
" <g id=\"line2d_45\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 188.432\n",
"L393.206 188.432\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_46\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"188.431952331\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_47\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"188.431952331\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_14\">\n",
" <g id=\"line2d_48\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 186.222\n",
"L393.206 186.222\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_49\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"186.222163362\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_50\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"186.222163362\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_15\">\n",
" <g id=\"line2d_51\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 171.241\n",
"L393.206 171.241\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_52\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"171.240943957\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_53\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"171.240943957\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_16\">\n",
" <g id=\"line2d_54\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 163.634\n",
"L393.206 163.634\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_55\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"163.633801565\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_56\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"163.633801565\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_17\">\n",
" <g id=\"line2d_57\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 158.236\n",
"L393.206 158.236\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_58\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"158.236448144\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_59\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"158.236448144\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_18\">\n",
" <g id=\"line2d_60\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 154.05\n",
"L393.206 154.05\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_61\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"154.049935582\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_62\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"154.049935582\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_19\">\n",
" <g id=\"line2d_63\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 150.629\n",
"L393.206 150.629\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_64\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"150.629305753\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_65\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"150.629305753\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_20\">\n",
" <g id=\"line2d_66\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 147.737\n",
"L393.206 147.737\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_67\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"147.737204441\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_68\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"147.737204441\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_21\">\n",
" <g id=\"line2d_69\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 145.232\n",
"L393.206 145.232\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_70\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"145.231952331\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_71\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"145.231952331\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_22\">\n",
" <g id=\"line2d_72\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 143.022\n",
"L393.206 143.022\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_73\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"143.022163362\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_74\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"143.022163362\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_23\">\n",
" <g id=\"line2d_75\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 128.041\n",
"L393.206 128.041\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_76\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"128.040943957\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_77\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"128.040943957\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_24\">\n",
" <g id=\"line2d_78\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 120.434\n",
"L393.206 120.434\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_79\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"120.433801565\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_80\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"120.433801565\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_25\">\n",
" <g id=\"line2d_81\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 115.036\n",
"L393.206 115.036\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_82\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"115.036448144\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_83\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"115.036448144\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_26\">\n",
" <g id=\"line2d_84\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 110.85\n",
"L393.206 110.85\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_85\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"110.849935582\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_86\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"110.849935582\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_27\">\n",
" <g id=\"line2d_87\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 107.429\n",
"L393.206 107.429\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_88\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"107.429305753\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_89\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"107.429305753\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_28\">\n",
" <g id=\"line2d_90\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 104.537\n",
"L393.206 104.537\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_91\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"104.537204441\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_92\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"104.537204441\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_29\">\n",
" <g id=\"line2d_93\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 102.032\n",
"L393.206 102.032\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_94\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"102.031952331\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_95\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"102.031952331\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_30\">\n",
" <g id=\"line2d_96\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 99.8222\n",
"L393.206 99.8222\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_97\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"99.8221633615\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_98\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"99.8221633615\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_31\">\n",
" <g id=\"line2d_99\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 84.8409\n",
"L393.206 84.8409\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_100\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"84.8409439566\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_101\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"84.8409439566\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_32\">\n",
" <g id=\"line2d_102\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 77.2338\n",
"L393.206 77.2338\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_103\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"77.2338015654\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_104\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"77.2338015654\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_33\">\n",
" <g id=\"line2d_105\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 71.8364\n",
"L393.206 71.8364\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_106\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"71.836448144\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_107\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"71.836448144\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_34\">\n",
" <g id=\"line2d_108\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 67.6499\n",
"L393.206 67.6499\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_109\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"67.649935582\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_110\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"67.649935582\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_35\">\n",
" <g id=\"line2d_111\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 64.2293\n",
"L393.206 64.2293\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_112\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"64.2293057527\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_113\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"64.2293057527\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_36\">\n",
" <g id=\"line2d_114\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 61.3372\n",
"L393.206 61.3372\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_115\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"61.3372044407\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_116\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"61.3372044407\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_37\">\n",
" <g id=\"line2d_117\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 58.832\n",
"L393.206 58.832\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_118\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"58.8319523313\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_119\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"58.8319523313\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_38\">\n",
" <g id=\"line2d_120\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 56.6222\n",
"L393.206 56.6222\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_121\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"56.6221633615\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_122\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"56.6221633615\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_39\">\n",
" <g id=\"line2d_123\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 41.6409\n",
"L393.206 41.6409\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_124\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"41.6409439566\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_125\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"41.6409439566\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_40\">\n",
" <g id=\"line2d_126\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 34.0338\n",
"L393.206 34.0338\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_127\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"34.0338015654\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_128\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"34.0338015654\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_41\">\n",
" <g id=\"line2d_129\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 28.6364\n",
"L393.206 28.6364\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_130\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"28.636448144\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_131\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"28.636448144\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_42\">\n",
" <g id=\"line2d_132\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 24.4499\n",
"L393.206 24.4499\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_133\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"24.449935582\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_134\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"24.449935582\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_43\">\n",
" <g id=\"line2d_135\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 21.0293\n",
"L393.206 21.0293\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_136\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"21.0293057527\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_137\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"21.0293057527\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_44\">\n",
" <g id=\"line2d_138\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 18.1372\n",
"L393.206 18.1372\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_139\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"18.1372044407\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_140\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"18.1372044407\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_45\">\n",
" <g id=\"line2d_141\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 15.632\n",
"L393.206 15.632\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_142\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"15.6319523313\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_143\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"15.6319523313\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"ytick_46\">\n",
" <g id=\"line2d_144\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M47.6055 13.4222\n",
"L393.206 13.4222\" style=\"fill:none;opacity:0.17;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_145\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"47.6055148418\" xlink:href=\"#m46a939d668\" y=\"13.4221633615\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_146\">\n",
" <g>\n",
" <use style=\"stroke:#000000;stroke-linecap:butt;stroke-width:0.5;\" x=\"393.205514842\" xlink:href=\"#m57a2c8792a\" y=\"13.4221633615\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"text_11\">\n",
" <!-- Zinc ($\\othermu$g/L) at bioretention BMPs -->\n",
" <defs>\n",
" <path d=\"\n",
"M11.2969 49.2031\n",
"L11.2969 -22.5938\n",
"L20.7031 -24\n",
"L19.7969 3.5\n",
"C21.9062 1.10938 24.9062 -1 30.7969 -1\n",
"C36 -1 40.0938 2.79688 44.2031 7.20312\n",
"C45 1.79688 47.4062 -1 52.9062 -1\n",
"C57.4062 -1 61.2969 1.70312 62.2969 2.90625\n",
"L61 5.10938\n",
"C60.2031 4.60938 59.2031 4.40625 57.9062 4.40625\n",
"C53.9062 4.40625 53.2969 8.5 53.2969 18.7969\n",
"L53.2969 50.4062\n",
"L43.9062 49.2031\n",
"L43.9062 16.7031\n",
"C43.9062 8.20312 37.0938 4.79688 32.7969 4.79688\n",
"C26.7031 4.79688 20.7031 10.5 20.7031 22.4062\n",
"L20.7031 50.4062\n",
"z\n",
"\" id=\"Fourier-Math-Letters-185\"/>\n",
" <path d=\"\n",
"M17.5 28.5312\n",
"C17.5 57 26.2031 65.5781 32.5 66.875\n",
"L32.5 68.9688\n",
"C15 68.9688 10.5 47.1719 10.5 28.4688\n",
"C10.5 9.79688 15 -12 32.5 -12\n",
"L32.5 -9.8125\n",
"C26.7031 -8.60938 17.5 -0.140625 17.5 28.5312\" id=\"Utopia_Regular-40\"/>\n",
" <path d=\"\n",
"M15.9062 -1\n",
"L36.9062 71\n",
"L30.2031 71\n",
"L9.20312 -1\n",
"z\n",
"\" id=\"Utopia_Regular-47\"/>\n",
" <path d=\"\n",
"M22.4062 28.5156\n",
"L28.0938 28.5156\n",
"C32.7031 28.5156 37.2031 28.9219 40.9062 29.8125\n",
"C48.5938 31.7969 57.4062 37.1562 57.4062 49.5625\n",
"C57.4062 57.0938 54.0938 62.25 49.5938 65.0312\n",
"C44.7969 68 38.4062 69 31.4062 69\n",
"L3.5 69\n",
"L3.5 65.8125\n",
"C12.2969 65.8125 12.5 65.6094 12.5 59.9688\n",
"L12.5 9.03125\n",
"C12.5 3.39062 12.2969 3.1875 3.5 3.1875\n",
"L3.5 0\n",
"L33 0\n",
"L33 3.1875\n",
"C22.7031 3.1875 22.4062 3.39062 22.4062 9.09375\n",
"z\n",
"\n",
"M22.4062 61.8438\n",
"C22.4062 64.6094 23.5 65.5156 30 65.5156\n",
"C40.2969 65.5156 46.5938 59.6719 46.5938 48.8594\n",
"C46.5938 36.4688 38.4062 32 29.7969 32\n",
"C23.9062 32 22.4062 32.2031 22.4062 35.875\n",
"z\n",
"\" id=\"Utopia_Regular-80\"/>\n",
" <path d=\"\n",
"M7.09375 69\n",
"L7.09375 51.8594\n",
"L10.2969 51.8594\n",
"C11.5 63.3281 14 65.5156 27.7031 65.5156\n",
"L45.5938 65.5156\n",
"C31 44.1719 16 22.7344 0.90625 1.29688\n",
"L1.40625 0\n",
"L58.4062 0\n",
"L59.4062 17.75\n",
"L56.2031 17.75\n",
"C54.4062 5.28125 49.7031 3.48438 34.2969 3.48438\n",
"L14.0938 3.48438\n",
"C28.7031 24.9375 43.7031 46.2656 58.7969 67.7031\n",
"L58.2031 69\n",
"z\n",
"\" id=\"Utopia_Regular-90\"/>\n",
" <path d=\"\n",
"M17.5 28.5312\n",
"C17.5 -0.140625 8.29688 -8.60938 2.5 -9.8125\n",
"L2.5 -12\n",
"C20 -12 24.5 9.79688 24.5 28.4688\n",
"C24.5 47.1719 20 68.9688 2.5 68.9688\n",
"L2.5 66.875\n",
"C8.79688 65.5781 17.5 57 17.5 28.5312\" id=\"Utopia_Regular-41\"/>\n",
" <path d=\"\n",
"M34.5 0\n",
"C49.7031 0 59.5 5.5 59.5 19.4062\n",
"C59.5 31.2031 51.0938 36.4062 41.4062 37.7031\n",
"L41.4062 37.9062\n",
"C50.7969 39.7812 56.2969 45.5312 56.2969 53.1562\n",
"C56.2969 58.6094 54.0938 62.6562 50.0938 65.3281\n",
"C46.2031 67.9062 40.2031 69 32.4062 69\n",
"L3.5 69\n",
"L3.5 65.8125\n",
"C12.2969 65.8125 12.5 65.6094 12.5 59.9688\n",
"L12.5 9.03125\n",
"C12.5 3.39062 12.2969 3.1875 3.5 3.1875\n",
"L3.5 0\n",
"z\n",
"\n",
"M22.4062 35.5156\n",
"L29.5938 35.5156\n",
"C42 35.5156 48.7969 29.3125 48.7969 18.7031\n",
"C48.7969 6.6875 40.5938 3.48438 32 3.48438\n",
"C24 3.48438 22.4062 4.98438 22.4062 11.1875\n",
"z\n",
"\n",
"M22.4062 60.6406\n",
"C22.4062 64.9219 22.7031 65.5156 30.5 65.5156\n",
"C37.7031 65.5156 45.7969 62.75 45.7969 52.5469\n",
"C45.7969 42.8438 39.5 39 29.0938 39\n",
"L22.4062 39\n",
"z\n",
"\" id=\"Utopia_Regular-66\"/>\n",
" <path d=\"\n",
"M3.70312 47.4531\n",
"L3.70312 44.9688\n",
"L7.5 44.4688\n",
"C10.0938 44.0781 10.7031 43.5625 10.7031 39.9531\n",
"L10.7031 8.40625\n",
"C10.7031 3.28125 10.4062 3.09375 3.20312 3.09375\n",
"L3.20312 0\n",
"L27.5938 0\n",
"L27.5938 3.09375\n",
"C20.5 3.09375 20.0938 3.28125 20.0938 8.40625\n",
"L20.0938 49.3438\n",
"L19.4062 49.9531\n",
"z\n",
"\n",
"M15.2969 71.1406\n",
"C11.7031 71.1406 9.20312 68.5625 9.20312 64.9688\n",
"C9.20312 61.4844 11.7031 59 15.2969 59\n",
"C19 59 21.2969 61.4844 21.4062 64.9688\n",
"C21.4062 68.5625 19 71.1406 15.2969 71.1406\" id=\"Utopia_Regular-105\"/>\n",
" <path d=\"\n",
"M27.0938 0\n",
"L27.0938 2.89062\n",
"C20.5938 3.39062 18.2031 3.6875 17.5938 7.875\n",
"C17.0938 11.1719 16.9062 14.9531 16.9062 20.25\n",
"L16.9062 59.8281\n",
"L17.0938 59.8281\n",
"L42.9062 1.1875\n",
"L45.5938 1.1875\n",
"L71.7031 59.8281\n",
"L72 59.8281\n",
"L72 9\n",
"C72 3.39062 71.7969 3.1875 63 3.1875\n",
"L63 0\n",
"L90.9062 0\n",
"L90.9062 3.1875\n",
"C82.2031 3.1875 81.9062 3.39062 81.9062 9.03125\n",
"L81.9062 59.9688\n",
"C81.9062 65.6094 82.2031 65.8125 90.9062 65.8125\n",
"L90.9062 69\n",
"L70.7969 69\n",
"C67.4062 60.125 63.2969 51.3594 59.2969 42.5781\n",
"L47.2969 15.8438\n",
"L47.0938 15.8438\n",
"L35.2969 42.4688\n",
"C31.4062 51.3594 27.2031 60.125 23.5938 69\n",
"L3.29688 69\n",
"L3.29688 65.8125\n",
"C12.0938 65.8125 12.2969 65.6094 12.2969 60\n",
"L12.2969 20.3281\n",
"C12.2969 15.0156 12.0938 11.2031 11.5938 7.90625\n",
"C11 3.6875 8.59375 3.28125 3.40625 2.89062\n",
"L3.40625 0\n",
"z\n",
"\" id=\"Utopia_Regular-77\"/>\n",
" <path d=\"\n",
"M26 46.5156\n",
"C30.9062 46.5156 36 42.9219 36 33.25\n",
"C36 24.875 31.5938 20.4844 25.7969 20.4844\n",
"C20.2031 20.4844 15.5 24.875 15.5 33.25\n",
"C15.5 43.125 20.7031 46.5156 26 46.5156\n",
"M28.0938 -20.5\n",
"C19.5938 -20.5 13.7031 -16.0938 13.7031 -8.84375\n",
"C13.7031 -5.4375 14.7031 -2.92188 16.7969 -1.3125\n",
"C19 0.390625 22.2969 1 27.0938 1\n",
"C35.9062 1 42.4062 -1.10938 42.4062 -8.64062\n",
"C42.4062 -16.6875 35.2031 -20.5 28.0938 -20.5\n",
"M38.9062 46.9062\n",
"C36.0938 48.7969 30.5938 50 26 50\n",
"C10.7031 50 5.29688 40.625 5.29688 33.25\n",
"C5.29688 23.875 11.5 19.5938 16.0938 18.3906\n",
"L16.0938 18.1875\n",
"C10.7031 16.1562 6.90625 13.3125 6.90625 9.5\n",
"C6.90625 6.09375 10.9062 2.375 15.7031 1.89062\n",
"L15.7031 1.70312\n",
"C11.4062 0.296875 4.20312 -2.10938 4.20312 -9.34375\n",
"C4.20312 -19.4844 14.2031 -24 25.7969 -24\n",
"C31.7969 -24 38.0938 -22.7969 42.9062 -19.875\n",
"C47.5 -17.0781 50.7969 -12.375 50.7969 -6.15625\n",
"C50.7969 4.65625 42.2031 8.46875 31.5 8.46875\n",
"L23.5 8.46875\n",
"C16.2969 8.46875 15.2031 10.7812 15.2031 12.5938\n",
"C15.2031 15.3906 19 16.9219 20.2969 17.2969\n",
"C22.2031 17 24.2969 17 25.4062 17\n",
"C34.9062 17 45.5938 21.1875 45.5938 33.25\n",
"C45.5938 37.4531 44.2969 40.9375 42.5938 42.625\n",
"L50.5 43.8281\n",
"L52.5 50.0938\n",
"L51.7031 51\n",
"z\n",
"\" id=\"Utopia_Regular-103\"/>\n",
" <path d=\"\n",
"M22.4062 59.9844\n",
"C22.4062 65.6094 22.7031 65.8125 32 65.8125\n",
"L32 69\n",
"L3.5 69\n",
"L3.5 65.8125\n",
"C12.2969 65.8125 12.5 65.6094 12.5 59.9688\n",
"L12.5 9.03125\n",
"C12.5 3.39062 12.2969 3.1875 3.5 3.1875\n",
"L3.5 0\n",
"L55.4062 0\n",
"L56.5938 17.8438\n",
"L53.5938 17.8438\n",
"C51.5938 4.875 46.0938 3.57812 35.5938 3.57812\n",
"C30.5938 3.57812 27 3.57812 24.9062 4.375\n",
"C22.7969 5.28125 22.4062 7 22.4062 11.9062\n",
"z\n",
"\" id=\"Utopia_Regular-76\"/>\n",
" </defs>\n",
" <g transform=\"translate(16.1777014175 187.884266885)rotate(-90.0)scale(0.1 -0.1)\">\n",
" <use transform=\"translate(0.0 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-90\"/>\n",
" <use transform=\"translate(54.7945205479 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-105\"/>\n",
" <use transform=\"translate(81.49435345 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-110\"/>\n",
" <use transform=\"translate(138.18179994 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-99\"/>\n",
" <use transform=\"translate(204.234091639 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-40\"/>\n",
" <use transform=\"translate(236.313744114 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Fourier-Math-Letters-185\"/>\n",
" <use transform=\"translate(296.687333997 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-103\"/>\n",
" <use transform=\"translate(344.308711108 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-47\"/>\n",
" <use transform=\"translate(386.450712173 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-76\"/>\n",
" <use transform=\"translate(438.555292531 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-41\"/>\n",
" <use transform=\"translate(491.257576568 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-97\"/>\n",
" <use transform=\"translate(539.177866326 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-116\"/>\n",
" <use transform=\"translate(591.282431483 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-98\"/>\n",
" <use transform=\"translate(646.076967232 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-105\"/>\n",
" <use transform=\"translate(672.776800134 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-111\"/>\n",
" <use transform=\"translate(725.678425144 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-114\"/>\n",
" <use transform=\"translate(759.551401483 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-101\"/>\n",
" <use transform=\"translate(806.674646589 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-116\"/>\n",
" <use transform=\"translate(838.156580183 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-101\"/>\n",
" <use transform=\"translate(885.279825289 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-110\"/>\n",
" <use transform=\"translate(941.967271779 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-116\"/>\n",
" <use transform=\"translate(973.449205372 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-105\"/>\n",
" <use transform=\"translate(1000.14903827 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-111\"/>\n",
" <use transform=\"translate(1053.05066328 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-110\"/>\n",
" <use transform=\"translate(1130.36074134 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-66\"/>\n",
" <use transform=\"translate(1189.53880225 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-77\"/>\n",
" <use transform=\"translate(1276.01452135 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-80\"/>\n",
" <use transform=\"translate(1328.81646827 22.2265868229)scale(0.916562889166)\" xlink:href=\"#Utopia_Regular-115\"/>\n",
" </g>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_147\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M71.3655 103.343\n",
"L110.246 103.343\" style=\"fill:none;stroke:#0000ff;\"/>\n",
" </g>\n",
" <g id=\"line2d_148\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M157.766 125.419\n",
"L196.646 125.419\" style=\"fill:none;stroke:#0000ff;\"/>\n",
" </g>\n",
" <g id=\"patch_3\">\n",
" <path d=\"\n",
"M47.6055 11.4454\n",
"L393.206 11.4454\" style=\"fill:none;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"patch_4\">\n",
" <path d=\"\n",
"M393.206 227.445\n",
"L393.206 11.4454\" style=\"fill:none;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"patch_5\">\n",
" <path d=\"\n",
"M47.6055 227.445\n",
"L393.206 227.445\" style=\"fill:none;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"patch_6\">\n",
" <path d=\"\n",
"M47.6055 227.445\n",
"L47.6055 11.4454\" style=\"fill:none;stroke:#000000;stroke-width:0.5;\"/>\n",
" </g>\n",
" <g id=\"line2d_149\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M90.8055 111.802\n",
"L90.8055 158.236\" style=\"fill:none;stroke:#000000;stroke-width:0.75;\"/>\n",
" </g>\n",
" <g id=\"line2d_150\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M90.8055 89.959\n",
"L90.8055 77.2338\" style=\"fill:none;stroke:#000000;stroke-width:0.75;\"/>\n",
" </g>\n",
" <g id=\"line2d_151\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M81.0855 77.2338\n",
"L100.526 77.2338\" style=\"fill:none;stroke:#000000;stroke-width:0.75;\"/>\n",
" </g>\n",
" <g id=\"line2d_152\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M81.0855 158.236\n",
"L100.526 158.236\" style=\"fill:none;stroke:#000000;stroke-width:0.75;\"/>\n",
" </g>\n",
" <g id=\"line2d_153\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M71.3655 111.802\n",
"L110.246 111.802\n",
"L110.246 89.959\n",
"L71.3655 89.959\n",
"L71.3655 111.802\" style=\"fill:none;stroke:#000000;stroke-width:0.75;\"/>\n",
" </g>\n",
" <g id=\"line2d_154\">\n",
" <defs>\n",
" <path d=\"\n",
"M0 2\n",
"C0.530406 2 1.03916 1.78927 1.41421 1.41421\n",
"C1.78927 1.03916 2 0.530406 2 0\n",
"C2 -0.530406 1.78927 -1.03916 1.41421 -1.41421\n",
"C1.03916 -1.78927 0.530406 -2 0 -2\n",
"C-0.530406 -2 -1.03916 -1.78927 -1.41421 -1.41421\n",
"C-1.78927 -1.03916 -2 -0.530406 -2 0\n",
"C-2 0.530406 -1.78927 1.03916 -1.41421 1.41421\n",
"C-1.03916 1.78927 -0.530406 2 0 2\n",
"z\n",
"\" id=\"ma82ee71791\" style=\"stroke:#0000ff;stroke-linecap:butt;stroke-width:0.5;\"/>\n",
" </defs>\n",
" <g clip-path=\"url(#pbbae269c40)\">\n",
" <use style=\"fill:none;stroke:#0000ff;stroke-linecap:butt;stroke-width:0.5;\" x=\"90.8055148418\" xlink:href=\"#ma82ee71791\" y=\"44.70992257\"/>\n",
" <use style=\"fill:none;stroke:#0000ff;stroke-linecap:butt;stroke-width:0.5;\" x=\"90.8055148418\" xlink:href=\"#ma82ee71791\" y=\"64.6402737954\"/>\n",
" <use style=\"fill:none;stroke:#0000ff;stroke-linecap:butt;stroke-width:0.5;\" x=\"90.8055148418\" xlink:href=\"#ma82ee71791\" y=\"66.9140953243\"/>\n",
" <use style=\"fill:none;stroke:#0000ff;stroke-linecap:butt;stroke-width:0.5;\" x=\"90.8055148418\" xlink:href=\"#ma82ee71791\" y=\"70.0482841451\"/>\n",
" <use style=\"fill:none;stroke:#0000ff;stroke-linecap:butt;stroke-width:0.5;\" x=\"90.8055148418\" xlink:href=\"#ma82ee71791\" y=\"67.649935582\"/>\n",
" <use style=\"fill:none;stroke:#0000ff;stroke-linecap:butt;stroke-width:0.5;\" x=\"90.8055148418\" xlink:href=\"#ma82ee71791\" y=\"63.614118783\"/>\n",
" <use style=\"fill:none;stroke:#0000ff;stroke-linecap:butt;stroke-width:0.5;\" x=\"90.8055148418\" xlink:href=\"#ma82ee71791\" y=\"68.4158183147\"/>\n",
" <use style=\"fill:none;stroke:#0000ff;stroke-linecap:butt;stroke-width:0.5;\" x=\"90.8055148418\" xlink:href=\"#ma82ee71791\" y=\"69.2143014407\"/>\n",
" <use style=\"fill:none;stroke:#0000ff;stroke-linecap:butt;stroke-width:0.5;\" x=\"90.8055148418\" xlink:href=\"#ma82ee71791\" y=\"65.5237170027\"/>\n",
" <use style=\"fill:none;stroke:#0000ff;stroke-linecap:butt;stroke-width:0.5;\" x=\"90.8055148418\" xlink:href=\"#ma82ee71791\" y=\"63.3139280329\"/>\n",
" <use style=\"fill:none;stroke:#0000ff;stroke-linecap:butt;stroke-width:0.5;\" x=\"90.8055148418\" xlink:href=\"#ma82ee71791\" y=\"70.0482841451\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_155\"/>\n",
" <g id=\"line2d_156\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M177.206 141.045\n",
"L177.206 220.679\" style=\"fill:none;stroke:#000000;stroke-width:0.75;\"/>\n",
" </g>\n",
" <g id=\"line2d_157\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M177.206 112.563\n",
"L177.206 98.2245\" style=\"fill:none;stroke:#000000;stroke-width:0.75;\"/>\n",
" </g>\n",
" <g id=\"line2d_158\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M167.486 98.2245\n",
"L186.926 98.2245\" style=\"fill:none;stroke:#000000;stroke-width:0.75;\"/>\n",
" </g>\n",
" <g id=\"line2d_159\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M167.486 220.679\n",
"L186.926 220.679\" style=\"fill:none;stroke:#000000;stroke-width:0.75;\"/>\n",
" </g>\n",
" <g id=\"line2d_160\">\n",
" <path clip-path=\"url(#pbbae269c40)\" d=\"\n",
"M157.766 141.045\n",
"L196.646 141.045\n",
"L196.646 112.563\n",
"L157.766 112.563\n",
"L157.766 141.045\" style=\"fill:none;stroke:#000000;stroke-width:0.75;\"/>\n",
" </g>\n",
" <g id=\"line2d_161\">\n",
" <g clip-path=\"url(#pbbae269c40)\">\n",
" <use style=\"fill:none;stroke:#0000ff;stroke-linecap:butt;stroke-width:0.5;\" x=\"177.205514842\" xlink:href=\"#ma82ee71791\" y=\"80.7748914773\"/>\n",
" <use style=\"fill:none;stroke:#0000ff;stroke-linecap:butt;stroke-width:0.5;\" x=\"177.205514842\" xlink:href=\"#ma82ee71791\" y=\"86.8176675489\"/>\n",
" <use style=\"fill:none;stroke:#0000ff;stroke-linecap:butt;stroke-width:0.5;\" x=\"177.205514842\" xlink:href=\"#ma82ee71791\" y=\"87.3461960661\"/>\n",
" <use style=\"fill:none;stroke:#0000ff;stroke-linecap:butt;stroke-width:0.5;\" x=\"177.205514842\" xlink:href=\"#ma82ee71791\" y=\"97.4739123492\"/>\n",
" <use style=\"fill:none;stroke:#0000ff;stroke-linecap:butt;stroke-width:0.5;\" x=\"177.205514842\" xlink:href=\"#ma82ee71791\" y=\"92.9230869497\"/>\n",
" <use style=\"fill:none;stroke:#0000ff;stroke-linecap:butt;stroke-width:0.5;\" x=\"177.205514842\" xlink:href=\"#ma82ee71791\" y=\"94.4248099401\"/>\n",
" </g>\n",
" </g>\n",
" <g id=\"line2d_162\"/>\n",
" </g>\n",
" </g>\n",
" <defs>\n",
" <clipPath id=\"pbbae269c40\">\n",
" <rect height=\"216.0\" width=\"345.6\" x=\"47.6055148418\" y=\"11.4454397693\"/>\n",
" </clipPath>\n",
" </defs>\n",
"</svg>\n"
]
}
],
"prompt_number": 11
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Look at the inflow data and summarize by `parameter`\n"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"inflow = table['Inflow']\n",
"inflow.unstack(level='parameter').describe()"
],
"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>\n",
" <th>Quantity</th>\n",
" <th colspan=\"18\" halign=\"left\">res</th>\n",
" </tr>\n",
" <tr>\n",
" <th>parameter</th>\n",
" <th>Arsenic, Dissolved</th>\n",
" <th>Arsenic, Total</th>\n",
" <th>Cadmium, Dissolved</th>\n",
" <th>Cadmium, Total</th>\n",
" <th>Chromium, Dissolved</th>\n",
" <th>Chromium, Total</th>\n",
" <th>Copper, Dissolved</th>\n",
" <th>Copper, Total</th>\n",
" <th>Iron, Dissolved</th>\n",
" <th>Iron, Total</th>\n",
" <th>Lead, Dissolved</th>\n",
" <th>Lead, Total</th>\n",
" <th>Manganese, Dissolved</th>\n",
" <th>Manganese, Total</th>\n",
" <th>Nickel, Dissolved</th>\n",
" <th>Nickel, Total</th>\n",
" <th>Zinc, Dissolved</th>\n",
" <th>Zinc, Total</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>count</th>\n",
" <td> 485.000000</td>\n",
" <td> 562.000000</td>\n",
" <td> 965.000000</td>\n",
" <td> 1881.000000</td>\n",
" <td> 821.000000</td>\n",
" <td> 929.000000</td>\n",
" <td> 1679.000000</td>\n",
" <td> 2810.000000</td>\n",
" <td> 385.000000</td>\n",
" <td> 805.000000</td>\n",
" <td> 1391.000000</td>\n",
" <td> 2657.000000</td>\n",
" <td> 219.000000</td>\n",
" <td> 329.000000</td>\n",
" <td> 694.000000</td>\n",
" <td> 837.000000</td>\n",
" <td> 1604.000000</td>\n",
" <td> 3215.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>mean</th>\n",
" <td> 2.884907</td>\n",
" <td> 4.428763</td>\n",
" <td> 1.054831</td>\n",
" <td> 1.711507</td>\n",
" <td> 4.647796</td>\n",
" <td> 6.975304</td>\n",
" <td> 11.260105</td>\n",
" <td> 25.106459</td>\n",
" <td> 135.584208</td>\n",
" <td> 2030.031864</td>\n",
" <td> 8.461040</td>\n",
" <td> 30.984136</td>\n",
" <td> 41.688402</td>\n",
" <td> 60.898012</td>\n",
" <td> 5.816988</td>\n",
" <td> 8.297003</td>\n",
" <td> 82.791748</td>\n",
" <td> 135.299474</td>\n",
" </tr>\n",
" <tr>\n",
" <th>std</th>\n",
" <td> 8.212874</td>\n",
" <td> 11.129765</td>\n",
" <td> 10.278792</td>\n",
" <td> 6.283824</td>\n",
" <td> 6.021969</td>\n",
" <td> 12.484929</td>\n",
" <td> 16.652182</td>\n",
" <td> 183.643774</td>\n",
" <td> 337.918235</td>\n",
" <td> 4422.191375</td>\n",
" <td> 26.372744</td>\n",
" <td> 88.701698</td>\n",
" <td> 70.635668</td>\n",
" <td> 79.126568</td>\n",
" <td> 6.388808</td>\n",
" <td> 9.069498</td>\n",
" <td> 656.506531</td>\n",
" <td> 524.866727</td>\n",
" </tr>\n",
" <tr>\n",
" <th>min</th>\n",
" <td> 0.060000</td>\n",
" <td> 0.060000</td>\n",
" <td> 0.000000</td>\n",
" <td> 0.000000</td>\n",
" <td> 0.090000</td>\n",
" <td> 0.200000</td>\n",
" <td> 0.001000</td>\n",
" <td> 0.000000</td>\n",
" <td> 0.050000</td>\n",
" <td> 0.500000</td>\n",
" <td> 0.000000</td>\n",
" <td> 0.000000</td>\n",
" <td> 0.370000</td>\n",
" <td> 0.300000</td>\n",
" <td> 0.002000</td>\n",
" <td> 0.003000</td>\n",
" <td> 0.000000</td>\n",
" <td> 0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25%</th>\n",
" <td> 0.500000</td>\n",
" <td> 0.830000</td>\n",
" <td> 0.200000</td>\n",
" <td> 0.360000</td>\n",
" <td> 1.000000</td>\n",
" <td> 2.800000</td>\n",
" <td> 3.505000</td>\n",
" <td> 5.400000</td>\n",
" <td> 20.000000</td>\n",
" <td> 250.000000</td>\n",
" <td> 1.000000</td>\n",
" <td> 3.700000</td>\n",
" <td> 10.000000</td>\n",
" <td> 16.000000</td>\n",
" <td> 2.000000</td>\n",
" <td> 3.000000</td>\n",
" <td> 12.000000</td>\n",
" <td> 32.996607</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50%</th>\n",
" <td> 0.830000</td>\n",
" <td> 1.500000</td>\n",
" <td> 0.250000</td>\n",
" <td> 0.500000</td>\n",
" <td> 2.100000</td>\n",
" <td> 5.000000</td>\n",
" <td> 7.500000</td>\n",
" <td> 11.000000</td>\n",
" <td> 49.000000</td>\n",
" <td> 625.000000</td>\n",
" <td> 2.000000</td>\n",
" <td> 10.999870</td>\n",
" <td> 10.000000</td>\n",
" <td> 32.000000</td>\n",
" <td> 2.800000</td>\n",
" <td> 5.000000</td>\n",
" <td> 30.000000</td>\n",
" <td> 65.099998</td>\n",
" </tr>\n",
" <tr>\n",
" <th>75%</th>\n",
" <td> 1.300000</td>\n",
" <td> 3.300000</td>\n",
" <td> 1.000000</td>\n",
" <td> 1.242303</td>\n",
" <td> 5.000000</td>\n",
" <td> 8.000000</td>\n",
" <td> 12.796153</td>\n",
" <td> 24.767499</td>\n",
" <td> 100.000000</td>\n",
" <td> 1844.000000</td>\n",
" <td> 5.000000</td>\n",
" <td> 26.000000</td>\n",
" <td> 37.400000</td>\n",
" <td> 75.000000</td>\n",
" <td> 6.675000</td>\n",
" <td> 11.000000</td>\n",
" <td> 72.000000</td>\n",
" <td> 140.935120</td>\n",
" </tr>\n",
" <tr>\n",
" <th>max</th>\n",
" <td> 67.000000</td>\n",
" <td> 91.000000</td>\n",
" <td> 318.471344</td>\n",
" <td> 200.000000</td>\n",
" <td> 41.000000</td>\n",
" <td> 295.000000</td>\n",
" <td> 440.100006</td>\n",
" <td> 9500.000000</td>\n",
" <td> 3300.000000</td>\n",
" <td> 57000.000000</td>\n",
" <td> 414.000000</td>\n",
" <td> 2300.000000</td>\n",
" <td> 420.000000</td>\n",
" <td> 520.000000</td>\n",
" <td> 29.000000</td>\n",
" <td> 116.000000</td>\n",
" <td> 25800.000000</td>\n",
" <td> 27500.000000</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"output_type": "pyout",
"prompt_number": 12,
"text": [
"Quantity res \\\n",
"parameter Arsenic, Dissolved Arsenic, Total Cadmium, Dissolved Cadmium, Total \n",
"count 485.000000 562.000000 965.000000 1881.000000 \n",
"mean 2.884907 4.428763 1.054831 1.711507 \n",
"std 8.212874 11.129765 10.278792 6.283824 \n",
"min 0.060000 0.060000 0.000000 0.000000 \n",
"25% 0.500000 0.830000 0.200000 0.360000 \n",
"50% 0.830000 1.500000 0.250000 0.500000 \n",
"75% 1.300000 3.300000 1.000000 1.242303 \n",
"max 67.000000 91.000000 318.471344 200.000000 \n",
"\n",
"Quantity \\\n",
"parameter Chromium, Dissolved Chromium, Total Copper, Dissolved Copper, Total \n",
"count 821.000000 929.000000 1679.000000 2810.000000 \n",
"mean 4.647796 6.975304 11.260105 25.106459 \n",
"std 6.021969 12.484929 16.652182 183.643774 \n",
"min 0.090000 0.200000 0.001000 0.000000 \n",
"25% 1.000000 2.800000 3.505000 5.400000 \n",
"50% 2.100000 5.000000 7.500000 11.000000 \n",
"75% 5.000000 8.000000 12.796153 24.767499 \n",
"max 41.000000 295.000000 440.100006 9500.000000 \n",
"\n",
"Quantity \\\n",
"parameter Iron, Dissolved Iron, Total Lead, Dissolved Lead, Total \n",
"count 385.000000 805.000000 1391.000000 2657.000000 \n",
"mean 135.584208 2030.031864 8.461040 30.984136 \n",
"std 337.918235 4422.191375 26.372744 88.701698 \n",
"min 0.050000 0.500000 0.000000 0.000000 \n",
"25% 20.000000 250.000000 1.000000 3.700000 \n",
"50% 49.000000 625.000000 2.000000 10.999870 \n",
"75% 100.000000 1844.000000 5.000000 26.000000 \n",
"max 3300.000000 57000.000000 414.000000 2300.000000 \n",
"\n",
"Quantity \\\n",
"parameter Manganese, Dissolved Manganese, Total Nickel, Dissolved \n",
"count 219.000000 329.000000 694.000000 \n",
"mean 41.688402 60.898012 5.816988 \n",
"std 70.635668 79.126568 6.388808 \n",
"min 0.370000 0.300000 0.002000 \n",
"25% 10.000000 16.000000 2.000000 \n",
"50% 10.000000 32.000000 2.800000 \n",
"75% 37.400000 75.000000 6.675000 \n",
"max 420.000000 520.000000 29.000000 \n",
"\n",
"Quantity \n",
"parameter Nickel, Total Zinc, Dissolved Zinc, Total \n",
"count 837.000000 1604.000000 3215.000000 \n",
"mean 8.297003 82.791748 135.299474 \n",
"std 9.069498 656.506531 524.866727 \n",
"min 0.003000 0.000000 0.000000 \n",
"25% 3.000000 12.000000 32.996607 \n",
"50% 5.000000 30.000000 65.099998 \n",
"75% 11.000000 72.000000 140.935120 \n",
"max 116.000000 25800.000000 27500.000000 "
]
}
],
"prompt_number": 12
}
],
"metadata": {}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment