{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": true }, "outputs": [], "source": [ "# imports\n", "# sqlalchemy imports\n", "from sqlalchemy import create_engine, Column, String, Integer, Numeric, MetaData, Table, type_coerce, ForeignKey, case\n", "from sqlalchemy.orm import create_session \n", "from sqlalchemy.ext.declarative import declarative_base\n", "from sqlalchemy.ext.automap import automap_base\n", "from sqlalchemy.sql import select, and_, or_, not_, func\n", "\n", "# other imports\n", "import matplotlib.pyplot as plt\n", "import numpy as np\n", "import datetime as dt\n", "import pandas as pd\n", "\n", "%matplotlib inline" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": true }, "outputs": [], "source": [ "# definitions\n", "dbpath='/ocean/eolson/MEOPAR/obs/WODSelect_46_52_m130_m122_nitrate/WOD2.sqlite'" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": true }, "outputs": [], "source": [ "Base = automap_base()\n", "engine = create_engine('sqlite:///' + dbpath, echo = False)\n", "# reflect the tables in salish.sqlite:\n", "Base.prepare(engine, reflect=True)\n", "# mapped classes have been created" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "collapsed": false }, "outputs": [], "source": [ "Sta=Base.classes.stationTBL\n", "Prof=Base.classes.profileTBL" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": true }, "outputs": [], "source": [ "session = create_session(bind = engine, autocommit = False, autoflush = True)" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "collapsed": false }, "outputs": [], "source": [ "qry=session.query(Sta.Year, Sta.Month, Sta.Day, Sta.Latitude, Sta.Longitude, \n", " Prof.Depth, Prof.Temperatur, Prof.Salinity,Prof.Nitrate, Prof.Chlorophyl, \n", " Prof.Phosphate).select_from(Prof).join(Sta,Sta.CastID==Prof.CastID).\\\n", " filter(and_(\n", " Prof.Depth != None,\n", " Prof.Chlorophyl != None,\n", " Prof.Nitrate != None\n", " ))" ] }, { "cell_type": "code", "execution_count": 7, "metadata": { "collapsed": false }, "outputs": [], "source": [ "#for row in data.all():\n", "# print(row)\n", "qrydf=pd.DataFrame(qry.all())" ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "collapsed": false }, "outputs": [], "source": [ "session.close()\n", "engine.dispose()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "qrydf" ] }, { "cell_type": "raw", "metadata": {}, "source": [ "qrydf.to_csv('/ocean/eolson/MEOPAR/obs/WODSelect_46_52_m130_m122_nitrate/WOD2.csv')" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [ "# alternative: load csv" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [ "qrydf=pd.read_csv('/ocean/eolson/MEOPAR/obs/WODSelect_46_52_m130_m122_nitrate/WOD2.csv', index_col=0, parse_dates=True)" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [ "qrydf" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [ "# Using Pandas:" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "qrydf.dtypes" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "qrydf.head()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "qrydf.tail()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "qrydf.index" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "qrydf.columns" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "qrydf.values" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "qrydf.describe()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "np.nanmean(qrydf['Salinity'])" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "qrydf.sort_values(by='Month').head(10)" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "# both endpoints are included\n", "qrydf.loc[2:5,['Year','Month']]" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "# endpoint not included\n", "qrydf.iloc[2:5,0:2]" ] }, { "cell_type": "raw", "metadata": {}, "source": [ "# FILTERING" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "qrydf[qrydf.Day == 1]" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "qrydf[qrydf.Chlorophyl > 35.0]" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "qrydf[qrydf['Month'].isin([1,4])]" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [ "binD=np.round(qrydf['Depth']/5.0)*5.0\n", "qrydf['binDepth']=binD" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "qrydf.loc[10:15,['Depth','binDepth']]" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "qrydf[pd.isnull(qrydf['Salinity'])].head()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "qrydf.mean()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "qrydf.apply(lambda x: x.mean())" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "qrydf.apply(lambda x: x.max() - x.min())" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [ "# merge:\n", "mondf = pd.DataFrame({'Month': [1,2,3,4,5,6,7,8,9,10,11,12], \n", " 'strMon': ['Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec']})" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "qrydf2=pd.merge(qrydf, mondf, on='Month')\n", "qrydf2.head(30)" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "# grouping\n", "qrydf.groupby(['Year','Month','binDepth']).mean()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "# grouping\n", "qrydf.groupby(['Year','Month']).count()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [ "# plots" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [ "qrydf.hist(figsize=(10,10))" ] }, { "cell_type": "code", "execution_count": 9, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYwAAAEACAYAAACgS0HpAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAE+lJREFUeJzt3X+w5XV93/HnCxAFIlu0w94pKyyECqtTUSrkh+PkRvBX\nHIF2pgRjHJCW6Qx0sDHDyKItyx9GbbSEpGUmNoRZrYQBrO6akIA7m2NHOxYNIoRdtztjWWAtlyZS\nLDSz/Hr3j/O97vFy7+5n773nnnP3PB8z35nv93PO+X7f58Pd8+Lz/ZmqQpKkgzli1AVIklYHA0OS\n1MTAkCQ1MTAkSU0MDElSEwNDktRkqIGR5JYkM0kenOe1307yUpLXDLRtTLI7yc4k7xpmbZKkQzPs\nEcatwLvnNiZZB7wT2DPQtgG4GNgAvBe4OUmGXJ8kqdFQA6Oqvgk8Nc9LNwLXzGm7ELi9ql6oqkeA\n3cC5w6xPktRuxY9hJLkAeKyqHprz0knAYwPLe7s2SdIYOGolN5bkGOA6+rujJEmryIoGBvDzwHrg\n+93xiXXA/UnOpT+iOHngveu6tpdJ4g2wJGkRqmrRx4ZXYpdUuomq+uuqmqqq06rqVOBx4C1V9SSw\nFfj1JEcnORU4HbhvoZVWlVMV119//chrGJfJvrAv7IsDT0s17NNqbwP+G/D6JI8m+fCctxT7w2QH\ncAewA7gbuLKW4xtKkpbFUHdJVdVvHOT10+Ysfwr41DBrkiQtjld6r3LT09OjLmFs2Bf72Rf72RfL\nJ6txr08S91ZJ0iFKQo35QW9J0mHAwJAkNTEwJElNDAxJUhMDQ5LUxMCQJDUxMCRJTQwMSVITA0OS\n1MTAkCQ1MTAkSU0MDElSEwNDktTEwJAkNTEwJElNDAxJUhMDYwmmptaTZN5pamr9qMuTpGXlE/eW\nVgewUB1hHGqUpFk+cU+StCIMDElSEwNDktRkqIGR5JYkM0keHGj7d0l2JnkgyZeTHD/w2sYku7vX\n3zXM2lod6MC2JE2SYY8wbgXePaftXuCNVfVmYDewESDJG4CLgQ3Ae4GbMwa/yjMze+gf2J5vkqTJ\nMdTAqKpvAk/NadtWVS91i98G1nXzFwC3V9ULVfUI/TA5d5j1SZLajfoYxuXA3d38ScBjA6/t7dpW\nqVd6fYakw8pRo9pwko8Dz1fVnyzm85s2bfrp/PT0NNPT08tT2LLZx3y7rWZmRr6XTdKE6PV69Hq9\nZVvf0C/cS3IK8LWqetNA22XAFcA7qmpf13YtUFX1mW75L4Drq+q/z7POFbtw72AX5x36a17QJ2k0\nVsOFe+mm/kLyHuAa4ILZsOhsBS5JcnSSU4HTgftWoD5JUoOh7pJKchswDbw2yaPA9cB1wNHA17uT\noL5dVVdW1Y4kdwA7gOeBK8fi/h+SJMB7SbVsC3dJSTocrIZdUpKkw8DIzpJaqosu+tC87R//+NWc\nc845K1yNJB3+Vm1gbNky351DtnDmmV81MCRpCFZtYMB8I4xHgf+30oVI0kTwGIYkqYmBIUlqYmBI\nkpoYGJKkJgaGJKmJgSFJamJgSJKaGBiSpCYGhiSpiYEhSWpiYEiSmhgYkqQmBoYkqYmBIUlqYmBI\nkpoYGJKkJgaGJKmJgSFJamJgSJKaDDUwktySZCbJgwNtJyS5N8muJPckWTPw2sYku5PsTPKuYdYm\nSTo0wx5h3Aq8e07btcC2qjoD2A5sBEjyBuBiYAPwXuDmJBlyfZKkRkMNjKr6JvDUnOYLgc3d/Gbg\nom7+AuD2qnqhqh4BdgPnDrM+SVK7URzDOLGqZgCq6gngxK79JOCxgfft7dokSWPgqFEXANTiPrZp\nYH66myRJs3q9Hr1eb9nWN4rAmEmytqpmkkwBT3bte4HXDbxvXde2gE3Dqk+SDgvT09NMT0//dPmG\nG25Y0vpWYpdUumnWVuCybv5SYMtA+yVJjk5yKnA6cN8K1CdJajDUEUaS2+jvK3ptkkeB64FPA3cm\nuRzYQ//MKKpqR5I7gB3A88CVVbXI3VWSpOU21MCoqt9Y4KXzF3j/p4BPDa8iSdJieaW3JKmJgSFJ\namJgSJKaGBiSpCYGhiSpiYEhSWpiYEiSmhgYkqQmBoYkqYmBIUlqYmBIkpoYGMDU1HqSzDtJkvrG\n4QFKIzczs4eFn+NkaEgSOMKQJDUyMCRJTQwMSVITA0OS1MTAkCQ1MTAkSU2aAiPJPxp2IZKk8dY6\nwrg5yX1JrkyyZqgVSZLGUlNgVNXbgQ8CrwP+KsltSd451MokSWOl+RhGVe0GPgF8DPgV4PeT/CDJ\nPx1WcZKk8dF6DONNSW4EdgLvAN5fVRu6+RsXs+EkG5M8nOTBJF9KcnSSE5Lcm2RXknvc/SVJ46N1\nhPEHwP3AWVV1VVXdD1BVP6I/6jgkSU4BrgDeUlVvon9Pqw8A1wLbquoMYDuw8VDXLUkajtbAeB9w\nW1X9HUCSI5IcC1BVX1zEdn8CPAccl+Qo4BhgL3AhsLl7z2bgokWsW5I0BK2BsY3+j/qsY7u2Ramq\np4DPAY/SD4qnq2obsLaqZrr3PAGcuNhtSJKWV+vtzV9VVc/MLlTVM7MjjMVIchrwW8ApwNPAnUk+\nyMvvMb7QPceBTQPz090kSZrV6/Xo9XrLtr7WwHg2ydmzxy6S/GPg75aw3bcC36qqH3fr+wrwy8BM\nkrVVNZNkCnhy4VVsWsLmJenwNz09zfT09E+Xb7jhhiWtrzUw/jX9UcCP6D9RaAr49SVsdxfwb5K8\nCtgHnAd8B3gGuAz4DHApsGUJ25AkLaOmwKiq7yQ5Ezija9pVVc8vdqNV9f0kXwD+CngR+B7weeDV\nwB1JLgf2ABcvdhuSpOV1KI9oPQdY333m7CRU1RcWu+Gq+l3gd+c0/xg4f7HrlCQNT1NgJPki8PPA\nA/RHBNA/IL3owJAkrS6tI4y3Am+oqgOctSRJOpy1Xofx1/QPdEuSJlTrCOPvAzuS3Ef/rCYAquqC\noVQlSRo7rYGxaZhFSJLGX+tptd/obhj4D6tqW3eV95HDLU2SNE5ab29+BXAX8Idd00nAV4dVlCRp\n/LQe9L4KeBv9u8zOPkzJGwNK0gRpDYx9VfXc7EJ3S3JPsZWkCdIaGN9Ich1wTPcs7zuBrw2vLEnS\nuGkNjGuB/w08BPxL4G4W8aQ9SdLq1XqW1EvAf+omSdIEar2X1P9knmMWVXXaslckSRpLh3IvqVmv\nAv4Z8JrlL0eSNK6ajmFU1d8OTHur6veA9w25NknSGGndJXX2wOIR9Ecch/IsDUnSKtf6o/+5gfkX\ngEdYhU/Dm5paz8zMnlGXIUmrUutZUr867EJWQj8s5rveMCtdiiStOq27pD56oNer6t8vTzmSpHF1\nKGdJnQNs7ZbfD9wH7B5GUZKk8dMaGOuAs6vq/wIk2QT8WVX95rAKkySNl9Zbg6wFnhtYfq5rkyRN\niNYRxheA+5J8pVu+CNg8nJIkSeOo9cK9TwIfBp7qpg9X1e8sZcNJ1iS5M8nOJA8n+YUkJyS5N8mu\nJPckWbOUbUiSlk/rLimAY4GfVNVNwONJTl3itm8C7q6qDcBZwA/o3xV3W1WdAWwHNi5xG5KkZdL6\niNbrgY+x/wf8FcB/XuxGkxwPvL2qbgWoqheq6mngQvbv6tpMf9eXJGkMtI4w/glwAfAsQFX9CHj1\nErZ7KvA3SW5Ncn+Szyc5FlhbVTPdNp7Ax8BK0thoPej9XFVVkgJIctwybPds4Kqq+m6SG+nvjpp7\nGfYBHgO7aWB+upskSbN6vR69Xm/Z1tcaGHck+UPg7yW5AricpT1M6XHgsar6brf8ZfqBMZNkbVXN\nJJkCnlx4FZuWsHlJOvxNT08zPT390+UbbrhhSetrPUvqs8Bd9H/YzwD+bVX9wWI32u12eizJ67um\n84CH6V9JflnXdimwZbHbkCQtr4OOMJIcSf/MpV8Fvr6M274a+FKSVwA/pH/a7pH0RzOXA3tYhXfE\nlaTD1UEDo6peTPJSkjXdmUzLoqq+T//+VHOdv1zbkCQtn9ZjGM8ADyX5Ot2ZUgBVdfVQqpIkjZ3W\nwPgv3SRJmlAHDIwkJ1fVo1XlfaMkacId7Cypr87OJPnykGuRJI2xgwXG4LNLTxtmIZKk8XawwKgF\n5iVJE+ZgB73PSvIT+iONY7p5uuWqquOHWp0kaWwcMDCq6siVKkSSNN4O5XkYkqQJZmBIkpoYGJKk\nJgaGJKmJgSFJamJgSJKaGBiSpCYGhiSpiYEhSWpiYEiSmhgYkqQmBoYkqYmBIUlqYmBIkpqkavU9\nFylJzf88p09y3HE38uyzf3uAT8/3uSzQPozXwmrsc0mrXxKqKgd/5/xGOsJIckSS+5Ns7ZZPSHJv\nkl1J7kmy5lDX2Q+LWmCSJC3WqHdJfQTYMbB8LbCtqs4AtgMbR1KVJOllRhYYSdYBvwb80UDzhcDm\nbn4zcNFK1yVJmt8oRxg3Atfws/uK1lbVDEBVPQGcOIrCJEkvd8Bneg9LkvcBM1X1QJLpA7z1AAce\nNg3MT3eTJGlWr9ej1+st2/pGcpZUkt8BfhN4ATgGeDXwFeCtwHRVzSSZAv6yqjbM8/kFz5KCT7CY\nM5c8S0rS4W5VniVVVddV1clVdRpwCbC9qj4EfA24rHvbpcCWUdQnSXq5UZ8lNdengXcm2QWc1y1L\nksbASI5hDKqqbwDf6OZ/DJw/2ookSfMZtxGGJGlMGRiSpCYGhiSpiYEhSWpiYEiSmhgYkqQmBoYk\nqYmBIUlqYmBIkpoYGJKkJgaGJKmJgSFJamJgSJKaGBiSpCYGhiSpiYEhSWpiYEiSmhgYkqQmBoYk\nqYmBIUlqYmBIkpoYGJKkJgaGJKnJSAIjybok25M8nOShJFd37SckuTfJriT3JFkzivokSS83qhHG\nC8BHq+qNwC8BVyU5E7gW2FZVZwDbgY0jqk+SNMdIAqOqnqiqB7r5Z4CdwDrgQmBz97bNwEWjqE+S\n9HIjP4aRZD3wZuDbwNqqmoF+qAAnjq4ySdKgo0a58SQ/B9wFfKSqnklSc94yd3nApoH56W6SJM3q\n9Xr0er1lW1+qDvCbPERJjgL+FPjzqrqpa9sJTFfVTJIp4C+rasM8n635s+STwCdYOGeywGsLtQ/j\ntTCqPpc02ZJQVVns50e5S+qPgR2zYdHZClzWzV8KbFnpoiRJ8xvJLqkkbwM+CDyU5Hv0/1f8OuAz\nwB1JLgf2ABePoj5J0suNJDCq6lvAkQu8fP5K1iJJajPys6QkSauDgSFJamJgSJKaGBgr7pUkmXea\nmlo/6uIkaUEjvXBvMu1joWs3ZmYWfXq0JA2dIwxJUhMDQ5LUxMCQJDUxMCRJTQwMSVITA0OS1MTA\nkCQ1MTAkSU0MDElSEwNDktTEwJAkNTEwJElNDAxJUhMDQ5LUxMCQJDUxMCRJTQwMSVKTsQyMJO9J\n8oMk/yPJx0ZdjyRpDAMjyRHAfwDeDbwR+ECSM0db1fjq9XqjLmFs2Bf72Rf72RfLZ+wCAzgX2F1V\ne6rqeeB24MIR1zS2/Mewn32xn32xn32xfMYxME4CHhtYfrxrmwCvJMm805FHHjdv+2c/+3ujLhqA\nqan189Y3NbV+1KVJE2Whf4tJlrzuo5ahvpE4/vj3v6xt377d7Ns3gmKWzT6g5n3lpZcy72vPPrv0\nP4LlMDOzh/nqm5kZj/qkSbHQv8W+pf17TNVCKx6NJL8IbKqq93TL1wJVVZ8ZeM94FS1Jq0RVLTo1\nxjEwjgR2AecB/wu4D/hAVe0caWGSNOHGbpdUVb2Y5F8B99I/xnKLYSFJozd2IwxJ0ngax7OkDmiS\nL+pLsi7J9iQPJ3koydVd+wlJ7k2yK8k9SdaMutaVkOSIJPcn2dotT2Q/ACRZk+TOJDu7v49fmMT+\nSLKx+/4PJvlSkqMnqR+S3JJkJsmDA20Lfv+uv3Z3fzfvOtj6V1VgeFEfLwAfrao3Ar8EXNV9/2uB\nbVV1BrAd2DjCGlfSR4AdA8uT2g8ANwF3V9UG4CzgB0xYfyQ5BbgCeEtVvYn+LvcPMFn9cCv938dB\n837/JG8ALgY2AO8Fbs5Bzr1dVYHBhF/UV1VPVNUD3fwzwE5gHf0+2Ny9bTNw0WgqXDlJ1gG/BvzR\nQPPE9QNAkuOBt1fVrQBV9UJVPc3k9cdPgOeA45IcBRwD7GWC+qGqvgk8Nad5oe9/AXB79/fyCLCb\n/m/sglZbYEzwRX0/K8l64M3At4G1VTUD/VABThxdZSvmRuAafvaE80nsB4BTgb9Jcmu3i+7zSY5l\nwvqjqp4CPgc8Sj8onq6qbUxYP8zjxAW+/9zf070c5Pd0tQWGgCQ/B9wFfKQbacw9c+GwPpMhyfuA\nmW60daAh9GHdDwOOAs4G/mNVnQ08S383xKT9XZwG/BZwCvAP6I80PsiE9UODRX//1RYYe4GTB5bX\ndW0Toxtq3wV8saq2dM0zSdZ2r08BT46qvhXyNuCCJD8E/gR4R5IvAk9MWD/Mehx4rKq+2y1/mX6A\nTNrfxVuBb1XVj6vqReArwC8zef0w10Lffy/wuoH3HfT3dLUFxneA05OckuRo4BJg64hrWml/DOyo\nqpsG2rYCl3XzlwJb5n7ocFJV11XVyVV1Gv2/ge1V9SHga0xQP8zqdjc8luT1XdN5wMNM2N8F/Qt+\nfzHJq7qDt+fRPyli0voh/OzIe6HvvxW4pDuT7FTgdPoXSi+84tV2HUaS99A/I2T2or5Pj7ikFZPk\nbcB/BR6iP6ws4Dr6/5HvoP9/C3uAi6vq/4yqzpWU5FeA366qC5K8hsnth7PonwDwCuCHwIeBI5mw\n/khyDf0fxxeB7wH/Ang1E9IPSW4DpoHXAjPA9cBXgTuZ5/sn2Qj8c+B5+ru47z3g+ldbYEiSRmO1\n7ZKSJI2IgSFJamJgSJKaGBiSpCYGhiSpiYEhSWpiYEiSmhgYkqQm/x+skLpTwEg21wAAAABJRU5E\nrkJggg==\n", "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "NtoP=qrydf['Nitrate'][qrydf['Phosphate']>0]/qrydf['Phosphate'][qrydf['Phosphate']>0]\n", "NtoP.plot(kind='hist',bins=50)" ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYMAAAEACAYAAABRQBpkAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAEo9JREFUeJzt3XusZWV9xvHvM4DAOEBQC8eKMmK8lUgRqLUS7VaLklqB\nklSrTRUhxLRFbWtbLk07J8ZYNYqhWpJakAxU2ogXLlrLiLgl2CgWGB0uUhoFoTqHaFGu4Ta//rHX\njKfDOTP7XNZee5/5fpKT7LX2Wev9rbnsZ6/3XetdqSokSbu2VV0XIEnqnmEgSTIMJEmGgSQJw0CS\nhGEgSaLlMEiyZ5JvJbkxyc1JPtCsX5fk7iQ3ND/HtlmHJGnH0vZ9BklWV9VDSXYDvgG8F/gt4P6q\nOrvVxiVJQ2m9m6iqHmpe7tm0d2+znLbbliQNp/UwSLIqyY3AZqBfVbc0b52WZGOS85Ls13YdkqT5\ntd5NtK2hZF9gA3A6cAvwk6qqJO8HnllVp4ykEEnSk+w+qoaq6r4kXwKOqqqvz3rrn4Ar5tomiRMn\nSdIiVNWCuuLbvproGVu7gJLsDRwDbEwyNevXTgRumm8fVbVif9atW9d5DR6fx+bxrbyfxWj7zOCZ\nwPokYRA8F1XVV5NcmORwYAtwB/DOluuQJO1Aq2FQVZuAI+ZY/7Y225UkLYx3IHeo1+t1XUKrVvLx\nreRjA49vVzSyq4kWI0mNc32SNI6SUOM0gCxJmgyGgSTJMJAkGQaSJAwDSRKGgSQJw0DSMpuaWkuS\nkf5MTa3t+rAnnvcZSFpWg9lnRv3/Nouek2cl8j4DSdKiGAaSJMNAkmQYSJIwDCRJGAaSJAwDSRKG\ngSQJw0CShGEgScIwkCRhGEiSMAwkSbQcBkn2TPKtJDcmuTnJB5r1+yfZkOS2JFcm2a/NOiRJO9b6\nFNZJVlfVQ0l2A74BvBc4DvhpVX04yenA/lV1xhzbOoW1NGGcwrp7YzmFdVU91Lzcs2nvXuB4YH2z\nfj1wQtt1SJLm13oYJFmV5EZgM9CvqluAA6tqBqCqNgMHtF2HJGl+u7fdQFVtAV6aZF/gyiQ9nnwO\nOe/53fT09LbXvV6PXq+3/EVK0gTr9/v0+/0l7WOkj71M8jfAw8ApQK+qZpJMAV+rqhfP8fuOGUgT\nxjGD7o3dmEGSZ2y9UijJ3sAxwI3A5cBJza+9HbiszTokSTvWdjfRM4H1GXxVWAVcVFVfbcYQPpPk\nZOBO4E0t1yFJ2oGRdhMtlN1E0uSxm6h7Y9dNJEmaDIaBJMkwkCQZBpIkDANJEoaBJAnDQJKEYSBJ\nwjCQJGEYSJIwDCRJGAaSJAwDSRKGgSQJw0CShGEgScIwkCRhGEiSMAwkSRgGkiQMA0kShoEkCcNA\nkkTLYZDkoCRXJ7k5yaYk72rWr0tyd5Ibmp9j26xDkrRjqar2dp5MAVNVtTHJGuB64HjgzcD9VXX2\nTravNuuTtPySAKP+fxv8rPiFJFRVFrLN7m0VA1BVm4HNzesHktwKPKt5e0GFSpLaM7IxgyRrgcOB\nbzWrTkuyMcl5SfYbVR2SpCdr9cxgq6aL6LPAe5ozhHOB91VVJXk/cDZwylzbTk9Pb3vd6/Xo9Xrt\nFyxJE6Tf79Pv95e0j1bHDACS7A58EfhyVZ0zx/sHA1dU1WFzvOeYgTRhHDPo3mLGDEbRTfQp4JbZ\nQdAMLG91InDTCOqQJM2j7auJjgauATYx+KpQwFnAWxmMH2wB7gDeWVUzc2zvmYE0YTwz6N5izgxa\n7yZaCsNAmjyGQffGtZtIkjTmDANJkmEgSTIMJEkYBpIkDANJEoaBJAnDQJLEiCaqk6R27dnc7DY6\nBx54MJs33zHSNtvkHciSllVXdyB71/MveAeyJGlRDANJkmEgSTIMJEkYBpIkDANJEoaBJAnDQJKE\nYSBJYsgwSPKStguRJHVn2DODc5Ncl+SPk+zXakWSpJEbKgyq6pXAHwDPBq5PcnGSY1qtTJI0Mgua\nqC7JbsAJwN8D9zGYHeqsqvp8K8U5UZ00cZyornutTVSX5LAkHwNuBV4DvLGqXty8/tgOtjsoydVJ\nbk6yKcm7m/X7J9mQ5LYkV9r1JEndGurMIMnXgfOAz1bVw9u994dVddE8200BU1W1Mcka4HrgeOAd\nwE+r6sNJTgf2r6oz5tjeMwNpwnhm0L3FnBkMGwZrgIer6olmeRWwV1U9tMACLwU+0fz8ZlXNNIHR\nr6oXzfH7hoE0YQyD7rX5PIOrgL1nLa9u1g0tyVrgcOCbwIFVNQNQVZuBAxayL0nS8hr2sZd7VdUD\nWxeq6oEkq4dtpDmz+Czwnmbb7eN03nidnp7e9rrX69Hr9YZtVpJ2Cf1+n36/v6R9DNtN9A3gXVV1\nQ7N8JPCJqvqNIbbdHfgi8OWqOqdZdyvQm9VN9LVmQHr7be0mkiaM3UTdW0w30bBnBn8KXJLkRwz+\n1KeANw+57aeAW7YGQeNy4CTgQ8DbgcuG3JckqQVD32eQZA/ghc3ibVX12BDbHA1cA2xiENsFnAVc\nB3yGwU1sdwJvqqqfzbG9ZwbShPHMoHutXU3U7PwVwFpmnU1U1YULaWyhDANp8hgG3WutmyjJRcDz\ngI3AE83qAloNA0nSaAw7ZnAU8Ct+TZeklWnY+wxuYjBoLElagYY9M3gGcEuS64BHtq6squNaqUqS\nNFLDhsF0m0VIkrq1kKuJDgaeX1VXNXcf71ZV97danFcTSRPHq4m61+YU1qcymE7iH5tVzwIuXVh5\nkqRxNewA8p8ARzN4oA1VdTtOLidJK8awYfBIVT26daGZb2g8z48kSQs2bBh8PclZwN7Ns48vAa5o\nryxJ0igNO2vpKuAU4HUMRmquBM5re3TXAWRp8jiA3L1W5ybqgmEgTR7DoHttzk30A+b4k66qQxbS\nmCRpPC1kbqKt9gJ+D3ja8pcjSerCoruJklxfVUcucz3bt2E3kTRh7CbqXpvdREfMWlzF4Exh2LMK\nSdKYG/YD/aOzXj8O3AG8admrkSR1wquJJC0ru4m612Y30Z/v6P2qOnshjUqSxstCrib6NeDyZvmN\nDB5qf3sbRUmSRmvYO5CvAd6wdcrqJPsAX6qqV7VanN1E0sSxm6h7rU1hDRwIPDpr+dFmnSRpBRi2\nm+hC4LokX2iWTwDWt1OSJGnUFvKksyOAVzaL11TVjUNscz7wO8BMVR3WrFsHnArc0/zaWVX17/Ns\nbzeRNGHsJupem91EAKuB+6rqHODuJM8dYpsLgNfPsf7sqjqi+ZkzCCRJozPsYy/XAacDZzar9gD+\neWfbVdW1wL1z7XLYAiVJ7Rv2zOB3geOABwGq6kfAPkto97QkG5Ocl2S/JexHkrQMhh1AfrSqKkkB\nJHnqEto8F3hfs7/3A2czeHDOnKanp7e97vV69Hq9JTQtSStPv9+n3+8vaR/D3mfwF8DzgWOAvwNO\nBi6uqo8Pse3BwBVbB5CHfa953wFkacI4gNy91qajqKqPNM8+vg94IfC3VfWVYeti1hhBkqmq2tws\nngjctIB6JUkt2OmZQZLdgKuq6tUL3nlyMdADng7MAOuAVwOHA1sYzH76zqqamWd7zwykCeOZQfda\newZykq8CJ1bVzxdb3GIYBtLkMQy611o3EfAAsCnJV2iuKAKoqncvpDFJ0ngaNgw+3/xIklagHXYT\nJXlOVf1whPVs377dRNKEsZuoe21MR3HprJ1/blFVSZLG3s7CYHayHNJmIZKk7uwsDGqe15KkFWRn\nYwZPMLh6KMDewENb3wKqqvZttTjHDKSJ45hB95b90tKq2m1pJUmSJsFCnmcgSVqhDANJkmEgSTIM\nJEkYBpIkDANJEsNPVCdpQk1NrWVm5s6uy9CYG+p5Bl3xpjNp6UZ/E5g3nXWtjYnqJEm7AMNAkmQY\nSJIMA0kShoEkCcNAkoRhIEmi5TBIcn6SmSTfnbVu/yQbktyW5Mok+7VZgyRp59o+M7gAeP12684A\nrqqqFwJXA2e2XIMkaSdaDYOquha4d7vVxwPrm9frgRParEGStHNdjBkcUFUzAFW1GTiggxokSbOM\nw0R1O5zcY3p6etvrXq9Hr9druRxJmiz9fp9+v7+kfbQ+UV2Sg4ErquqwZvlWoFdVM0mmgK9V1Yvn\n2daJ6qQlcqK69toc18+ncZ2oLs3PVpcDJzWv3w5cNoIaJEk70OqZQZKLgR7wdGAGWAdcClwCPBu4\nE3hTVf1snu09M5CWyDOD9toc18+nxZwZ+DwDaYUzDNprc1w/n8a1m0iSNObG4WoiaZfhIyg1ruwm\nkkZo9F02MPoulF3hGAdtjuvnk91EkqRFMQwkSYaBJMkwkCRhGEiSMAwkSRgGkiQMA0kShoEkCcNA\nkoRhIEnCMJAkYRhIkjAMJEkYBpIkDANJEoaBJAnDQJKEz0DWGBn184FXrVrNli0Pjaw9aZz5DGSN\njdE/H3jXeVavf67ttDmun0+LeQZyZ2cGSe4Afg5sAR6rqpd1VYsk7eq67CbaAvSq6t4Oa5Ak0e0A\ncjpuX5LU6PLDuICvJPl2klM7rEOSdnlddhMdXVU/TvJLDELh1qq6dvtfmp6e3va61+vR6/VGV6Ek\nTYB+v0+/31/SPsbiaqIk64D7q+rs7dZ7NdEuxKuJVkqbu8IxDtoc18+nxVxN1Ek3UZLVSdY0r58K\nvA64qYtaJEnddRMdCHwhSTU1fLqqNnRUiyTt8saim2g+dhPtWuwmWilt7grHOGhzXD+fJqabSJI0\nXgwDSZJhIEkyDCRJGAaSJAwDSRKGgSQJw0CShGEgScIwkCRhGEiSMAwkSRgGkiQMA0kS3T72UmNs\namotMzN3dl2GpBHxeQaa0+ifLQDOu79S2twVjnHQ5rh+Pvk8A0nSohgGkiTDQJI04QPIDz/8MA8+\n+OBI21yzZg177bXXSNuUpLZNdBgceeSr+P73/5tkt5G0t2XL4xx66GHccMM1I2lPkkZlosPgnnvu\n4ZFHNgIHj6jF7zEzc8KI2pKk0elszCDJsUm+l+S/kpzeVR2SpI7CIMkq4BPA64FDgbckeVEXtXSp\n3+93XULL+l0X0KJ+1wW0rN91AS3rd13A2OnqzOBlwO1VdWdVPQb8K3B8R7V0xjCYZP2uC2hZv+sC\nWtbvuoCx01UYPAu4a9by3c06SVIHJnoAeY899mCffU4mWT2S9rZsuZ+nPGWPkbQlSaPUydxESV4O\nTFfVsc3yGUBV1Ye2+73xnPhDksbcQucm6ioMdgNuA14L/Bi4DnhLVd068mIkSd10E1XVE0lOAzYw\nGLc43yCQpO6M9RTWkqTRGNuJ6pKsSnJDksu7rmW5JdkvySVJbk1yc5Jf77qm5ZTkzOa4vpvk00me\n0nVNS5Hk/CQzSb47a93+STYkuS3JlUn267LGpZjn+D7c/PvcmORzSfbtssalmOv4Zr333iRbkjyt\ni9qWar5jS/Ku5u9vU5IPDrOvsQ0D4D3ALV0X0ZJzgH+rqhcDvwqsmC6yJAcDpwIvrarDGHRF/n63\nVS3ZBQxukJztDOCqqnohcDVw5sirWj5zHd8G4NCqOhy4nZV3fCQ5CDgGmORH+j3p2JL0gDcCL6mq\nlwAfGWZHYxkGzV/SbwPndV3Lcmu+Yb2yqi4AqKrHq+q+jstaTvcBjwJPTbI7sBr4UbclLU1VXQvc\nu93q44H1zev1wMROWjXX8VXVVVW1pVn8JnDQyAtbJvP8/QF8DPjLEZezrOY5tj8CPlhVjze/85Nh\n9jWWYcAv/pJW4oDGc4GfJLmg6Qb7ZJK9uy5quVTVvcBHgR8C/wP8rKqu6raqVhxQVTMAVbUZOKDj\netp0MvDlrotYTkmOA+6qqk1d19KCFwCvSvLNJF9LctQwG41dGCR5AzBTVRsZPNh0QdfKToDdgSOA\nf6iqI4CHGHQ5rAhJDgH+jMFUsr8MrEny1m6rGomV+MWFJH8NPFZVF3ddy3JpvnydBaybvbqjctqw\nO7B/Vb0c+CvgM8NsNHZhABwNHJfk+8C/AK9OcmHHNS2nuxl8I/nPZvmzDMJhpTgK+EZV/W9VPQF8\nHnhFxzW1YSbJgQBJpoB7Oq5n2SU5iUF37UoL8+cBa4HvJPkBgy6w65OslLO7uxj8v6Oqvg1sSfL0\nnW00dmFQVWdV1XOq6hAGA49XV9Xbuq5ruTRdC3cleUGz6rWsrIHy24CXJ9krSRgc30oYIN/+LPVy\n4KTm9duBy0Zd0DL7f8eX5FgGXbXHVdUjnVW1fLYdX1XdVFVTVXVIVT2XwRe0l1bVpAb69v82LwVe\nA9B8zuxRVT/d2U7GLgx2Ee8GPp1kI4OriT7QcT3Lpqq+A1wIXA98h8E/0k92WtQSJbkY+A/gBUl+\nmOQdwAeBY5JsvZN+qMv3xtE8x/dxYA3wlWZs69xOi1yCeY5vtmJCu4nmObZPAYck2QRcDAz1Zdqb\nziRJnhlIkgwDSRKGgSQJw0CShGEgScIwkCRhGEiSMAwkScD/AWJKbIFQmtB9AAAAAElFTkSuQmCC\n", "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "NtoP[(qrydf['Phosphate']>0) & (qrydf['Depth']>80)].plot(kind='hist', bins=10)" ] }, { "cell_type": "code", "execution_count": 11, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAY0AAAEPCAYAAAC+35gCAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJztvXt8XOV54P99pbkdzWgkmQhDAEtGxhewjeX8SEnSLXIT\nsmmbbbIhlJJmkxSXmmS9pm3S4JBwCa67uC5pQ7dg7LpxmmJb2aY0SZtUJK3cXf0aKrdASDJAQhM5\nN0BKyQ0w+MKzf7zvmTlz5sxoNBppZqTn+/mcz1x0Lu8czPOc525EBEVRFEWphrZGL0BRFEVpHVRp\nKIqiKFWjSkNRFEWpGlUaiqIoStWo0lAURVGqRpWGoiiKUjWxRi/AGDMB/Bh4CTgpIq80xvQAw0Af\nMAH8ioj8uGGLVBRFUYDmsDReAoZEZFBEXum+2w58UURWAf8IfKBhq1MURVHyNIPSMJSu403Ax937\njwNvntcVKYqiKJE0g9IQ4AvGmKPGmN9w3y0VkacBROQp4MyGrU5RFEXJ0/CYBvAaEXnSGNML3G+M\neRyrSIJorxNFUZQmoOFKQ0SedK9Txpi/AV4JPG2MWSoiTxtjzgImo441xqgyURRFqQERMbUc11D3\nlDGmwxiTce/TwOuBrwCfAd7ldnsn8Oly5xCRpt9uueWWhq9B16nrbOV1tsIaW2mds6HRlsZS4D5n\nMcSAe0XkfmPMvwKfNMZcAxwDfqWRi1QURVEsDVUaIvItYEPE988Ar5v/FSmKoiiVaIbsqQXP0NBQ\no5dQFbrO+qLrrB+tsEZonXXOBjNb/1YjMcZIK69fURSlERhjkFYMhCuKoiithSoNRVEUpWpUaSiK\noihVo0pDURRFqRpVGoqiKErVqNJQFEVRqkaVhqIoilI1qjQURWl5pqamOHr0KFNTU41eyoJHlYai\nKC3NoUPD9PWt5vLLr6OvbzWHDg03ekkLGq0IVxSlZZmamqKvbzXHj48C64FH8LxNHDv2GL29vY1e\nXtOiFeGKoixKJiYmSCT6sQoDYD3xeB8TExONW9QCR5WGoigtS39/PydOTACPuG8e4eTJY/T39zdu\nUQscVRqKorQsvb297N9/F563iWx2I563if3771LX1ByiMQ1FUVqeqakpJiYm6O/vV4VRBbOJaajS\nUBRFWWRoIFxRFEWZF1RpKIqiKFWjSkNRFEWpGlUaiqIoStWo0lAURVGqRpWGoiiKUjWqNBRFUZSq\nUaWhKIqiVI0qDUVRFKVqVGkoiqIoVaNKQ1EURamaplAaxpg2Y8yDxpjPuM89xpj7jTGPG2NGjDFd\njV6joiiK0iRKA7geyAU+bwe+KCKrgH8EPtCQVSmKoihFNFxpGGPOBX4R+LPA128CPu7efxx483yv\nS1EURSml4UoD+CPgd4Fgj/OlIvI0gIg8BZzZiIUpiqIoxTRUaRhjfgl4WkQeBir1dtehGYqiKE1A\nrMHXfw3wy8aYXwQ8oNMY8wngKWPMUhF52hhzFjBZ7gS33npr/v3Q0BBDQ0Nzu2JFUZQW48iRIxw5\ncqQu52qayX3GmMuA94rILxtj/gD4DxHZZYy5AegRke0Rx+jkPkVRmoZWGTu7ECf33Q5cbox5HHit\n+6woitKUTE1NsX37jZx33kpe+9ot9PWt5tCh4UYva05oGkujFtTSUBSl0Rw6NMw73rGZU6deAh4A\n1gOP4HmbOHbssaa0OGZjaTQ6pqEoitJSBF1QANdccx2nTrUBK7AKA2A9sdgyJiYmmlJpzIZmdU8p\niqI0HYcODdPXt5rLL7+Ovr7V3HPPPtrblwL9wHeAR9yej3DiREGxLCTUPaUoilIFU1NT9PWt5vjx\nUXwXVCp1GQAvvGCwjSx2AecC32DPno+yZcu1DVtvJRZiIFxRFKWpmJiYIJHoJ+iCSiSW88EP/i7x\n+Engw0CWWOzfm1phzBa1NBRFUaogytLwg90ADz30EACDg4NNH8eYjaWhSkNRFKVKDh0aZvPm9xCP\n93Hy5DH277+Lq6++qtHLmjGqNBRFUeaJVingq4QqDUVRFKVqNBCuKMqCZGpqiqNHjzI1NdXopSgO\nVRqKojQl4ZqIhdqWo9VQ95SiKE1HpUylVo0jNBPqnlIUZUERVRMRj/cxMTHRuEUpgCoNRVGakP7+\nfo4f/3eCbTleeOGbC7ItR6uhDQsVRWlKRE4DQ9i+ThPus9Jo1NJQFKXpmJiYoKNjJfA4cA/wOJ53\ngbqnmgBVGoqiNB39/f2cODEBPAlcAjzJyZPH1D3VBKh7SlGUhuNXWWcyGZ599ln6+/vZv/8uNm/e\nVNSyQzOnGo8qDUVRGorfzwnO4fjxJ/C8s4Afs3//XRw79ljLt+xYaGidhqIoc0I1PZqi6jFgE/Ap\nPO+KfAfZsBXif1fu3AuhP9RconUaiqI0FdVWc0fVY0AfkCYe7+Oee/bR17eayy7bzIUXvoLLLruK\nc8+9gHPOOb/subWSfG5RS0NRlLoyk2ru8pbGfhKJ/0ZbW5wXXjgS+NtlwMeAa7CZVU8Wnbtwvk8B\naeC5vMWiFkcBtTQURWkaZlLN3dvby/79d+F5m/C8dcClxGIx4G0Ys5QXXjiDYiukF3gn0AU8BLxI\ne/vL8+d+6KGHOHUqA1wBXAdcgUhWU3XriCoNRVHqSiFdtlDNXSld9uqrr+LYscf4p3/6c8bGvkB7\n+wngAV588UvAfxSdx37+NPA0cCVwLc8+++88+ODDHDo0zBve8GZOnpwCRoF/A0Z54YWn+da3vqWd\ncuuFiLTsZpevKEqzcfDgYfG8JZLNDornLZGDBw8X/X1yclLGx8dlcnKy6PsdO3YKrBAQtx0W6HDf\nLXGfRWBA4G6BcYH7JB7PSDyeFugUuChwvN03nV4VuY5aKbf+VsHJztrkbq0HNsOmSkNRmoewIC0n\nWH2F0tk5KMlkt+zZsze/fyrVLdAj8GUn8L8s4AkkBEYD3yWdEjnf/X2Fe13mvg8e3yMwKfBl8bwl\nsxb0/vq7ujbWVRHNJ6o0FEWZd4JKoVpBmsvlJJnsLlEKe/bslfHxcensHHTWxBJnTfS4z7sEPOns\n3OAUi+eUSFhBeAI3ue9XO+WyN291ZLOD+TXXYilMTk6K5xVfsx6KaL5RpaEoyrwSVBKpVLckEl3T\nCtKDBw9LMpkVWBlyH62XZDIr73vf+53Q/7LAiMAFzkKw+2Uya+XAgQOyffuNzrIYF9hY4oqyiuJM\nd66g4rHr2rNnb82Wwvj4uHR1FV/TV0SthCoNRVHmjdKn7XtDcYhSQVo4ZjTCOlgi7e3LBeIBK+HC\ngAIpKKJcLhdwYUWdy5PbbrtN4vFs6PsOSaW6ZffuO5ylM+qUzuiMLAW1NESzpxRFmRnFKbVTwMuA\n71MpW6pwzBBwF7YWYyW27uINnD79FLYF+p8CtwMHSCReRjJ5GdnsRjxvE/v338Wzzz5LMnk+cDc2\nrTYLXApcAFzK1q3X8oY3vIGOjhUEU3XT6RX81m+9hw996MO8+GIHtabkBlOEg+taVDUgtWqbemxA\nEvgXbML114Dfd9/3APdjq3dGgK4yx9dX/SqKMi2Fp+2bBLJis5USzjJYLpCUq69+e0lQvPCEPik2\n8ykhHR1+ALvY8oD7JBZLy9jYmIyPj0sul8u/Fp/nXonHM7Jz507J5XIR1ypYA9ZCuS/iel7+2Jnc\nA82eapzi6HCv7cADwGuAXcD73fc3ALeXObae91FRlACVBOM11/ymE74XOyG/SyAt0J13LSWT/UUx\ngz179kp7e1r8FNp4PCvvfOe7JJUKxi4mBc4Q8CSVukg8b4ls3bpNPG+JpNMX5z+nUt2STJ4vkJJk\ncpkkk9l8FpZIacrvjh07XSxiXGBdkSvN89a2XExitrS00sgvBDqAceBC4DFgqfv+LOCxMsfU8TYq\niuIrikrB4snJyYgMqG6nDMIWw2g++GyD4MF9dkkhXbZHYJtAV8R5/Ewp+7mtrcPFLFaIrcvIOOXl\nFSmOoNKrFFNpxZjEbGlppYGtSn8I+AnwB+67H4b2eabMsfW7i4qyyCnUT6wTSIkNcJfWN4yMjEhH\nx/qip3UrwFeEvhsUGJdM5mJpa0s64e5nTk2WCG+rHO6W0owoP1PKPy6sVAp1GMlkd1kF4P++VKpf\nwBPPW9uydRazZTZKo+HzNETkJWDQGJMFRowxQ4CEdyt3/K233pp/PzQ0xNDQUP0XqSgLnKmpKTZv\nfo9rHPi3wO8BtwH/HdhDe/vL+dznPscLL5zgt37r/bzwwgls4NtvJPhdwIS+OwY8x7PPfh37bPhZ\nbAD6EeAp4AzgbLeC9cA5wPnAROg83wOec/t9AXg5xf2o+t0xl5BI9DMxMREZmL766qt43et+vqTN\n+mIIYh85coQjR47U5VxN1eXWGHMTcBzYDAyJyNPGmLOAURFZE7G/NNP6FaVVOXr0KJdffh0//vHf\nAwPY+WzLgW9h/5c0eN4Kjh9/ArgV27783cASbAbVLwOfdMedDXyfZHIpL774NPZ/53/G9oIaBq4F\nTrv9nsFmQq3BZkF9DttXyp47kfgBp069yEsvecB5wDeABPB/KCiVIaI63irladkut8aYlxljutx7\nD7gc66r6DPAut9s7sR3KFEWZIwpNBj+FFehHsEL+CNaC+BzHjz+CzVXZBfw8VlC/gE25/RSwA/vE\nfxvJZJzdu3+Hzs4VwM0UrIefx+a8fAl4wp3/GuBngBTWEtkFCO3tP+Wzn/0kf/mXB0ilBM97Fut0\n+CWsglkJXIoxz9PZ+fo5T3+dmpri6NGj2viwVr9WPTZgHfAgVlF8GXif+34J8EXsv8r7ge4yx9fH\nwacoi4yozKiDBw9LIpERW0VdLqYgAuvd5+J4go1R2CyobHZQRkZGAqmvh92+50TEPgYEXhYIeJcW\n3eVyOTlw4IDccsuHI/cbGRmZ02D2Qug3FYRWDoTPZlOloSgzJywAd+zYmRe4Y2Nj0t7eWTF7yX5e\n7QLShyVKmfgC379WJrNW2tpSAm1lAtndYus+PIELJJnszgvm4HqTyazE42uKlM5cp8wulCrwIKo0\nFEWpiigBCJ4kEhm55prfFM9bIvH4MinuHNvuBPuge00L/IHYDKvi82QypRlJNt22Wzo7ByWV6pEN\nGzY6xTEohXbnG5zCuVDi8XSFQr1RqUdxXvB+TFekt1D6TQVRpaEoSlWUCkB/XsWagDD2K7YzUqig\nTjnXUkogKfF4Jl905xfQ+Z1qgwI4SkklEll3zkJKb6E7bXGtRZTAhrOdZWKVTirVLyMjI2WF/3Qt\n2qdzOamloUpDURYNUTMuittw+LMrxsUWyPltyX1rYKdzO404IZ+VYLxhuif1KKHf2blB2ttTTlGs\nl0JFuSe7d99Rsv4oy8gqMxvTaG9PlxX+vmLwq8n9v0W1aK+kCKYbKtVqqNJQFKWEck/SBw8ellQq\nHJSedE/v4QFI3W7z23xYN5If6A5WXEcpj2hLo8spjX4n+CfzyiTK5bN16zbxYx2l7rKuEndVUKGF\nW7YnEl2B6vTiFu3TuZxavd9UEFUaiqIUMZ1LZWRkRNraukMCd6uUZk4NuO99JWJbcSQSXZJKdUtX\n10aJxzslkegqmcTnE35Kj8XSzv3VU3Z9pb9jNG9ZWAso5z77czdKhf/IyIhEZWrZDLFRWcztRFRp\nKIpSRLngrW8djI2NOYWxywnP9WLjFaVBZttkcMD9banE41mJxzNS6uIqHBNWHP5T+rZt14sdkrRO\nbMykS8LZUtP9DruWe6VcYNwX/lZphGMnHdLR4StG3xVX/voLFVUaiqIUURq7uFdisbQkEhnp7Fwn\nyWRWEgk/dXVSYFzi8QvEmKR7krdK4rLLXiuFPlQ5gXslkci6/lTinvYHQ0K9OAPKZ8+evVLaGbdL\nEolM0b7RjQaDSqnLbQPuPNsCnzskHs/IwYOHA9db4X5TWuLxjGuRXsjGSiazNWdftSqqNBRFKeHg\nwcMSj3cWKQE4zwna97on/tEiC8F+tkommexyrpyLi5RCJnOxiwn4CikYN/A719qnd78GJJfLlcQX\n7Dr6ZceOnUVrTqW6JZ1eJamUffoPxzRisV5JJrOuCeJ9gTUULIpUqjsygL59+435Dr4LJahdC7NR\nGk3Ve2qmaO8pRSnP1NQUfX2rXRNCv0/TpcD7gD/ETh14ilRqKSI/oq2th+PHv5k/Pp2+GJHneP75\nHwKFcySTl/F7v3cTv/u7H8JOzPt34CUKvao+B6SxTQZ/iVjMtjg6deocbJMHn4tJJif4zneeoLe3\nl6mpKc45Z4CTJwt9r2KxE8TjSY4f/xRwAvgm7e3vJR5PYsy5HD/+BIlENydOpLF9qfy1rwI8nnvu\n4cD1VpBOx3jppSn+6I9uZ+PGDdM2LJyammJiYmLBNTacTe+phlsLs9lQS0NRyjI+Pi6dnWHX0Xqx\nabMXil+9nUx2y9jYWIklEI9nnSsnGPfw8vUY1kXlZz/tFTvj+2wppOx2C5wpdubFqES1Qg/GPoaH\nh6W0WrxDOjoukkL8YZ2EYxjJZHfI5VTO0ii0PKkm6L3QWocEQd1TiqKEiR6WtMQpjKyE+0TZ4Hah\n8jsez+RdOen0WonHM/k6iuhU2kxAoPu9pgak0G6kEHj2U199Dh487FxexZlQMCDxeDqgePx6ksI+\nnZ0bZMuWd0sq1S2ZzNr8FL9CjcZ6Cbc8qSa9dqEV9AVRpaEoi4yomoGo7wrB4OIiOlt9XRCGIyMj\nLktpMm89+IJ1z569kkhkpKNjIB9nEIkeqep568QGzMPKyn/KLw08V5qqF4t1SiyWccpkibNoSi2W\nzs51Eo9npb09LZ2dhViFn0UVtkSmUwALsXVIEFUairKI8IvTOjvX5YWj398pk9lQUivh759OX+QU\nxhUSdjeVe7LO5XIumN4lsEqgS+LxTFGFeTDTye7bKeHCORiQdHplpJunWEAXWyOF1F5fQSyRQmND\nP7i/a1oX1EwrutXSUKWhKAuCqLRVOy+7tHlgeF72gQMHAqmy1qLIZAodYqMsBxtnSDphvNG9JmVk\nZKRkbYUK7NESa6BS+/KopoTJZFaGh4cjajQuEOta2yup1DIX7wj+fVD8Nu5hy2CmFd0LrXVIEFUa\nirIIKB+j6JfSWICtxQi2+MjlctM+PU9OTsqOHTvz1d42TlEanB4eHi5ZXzmLoZrCuSgBXb5GIyf1\nCnZXc88XSuuQIKo0FGURUD4bKimlMYSsZDJrXZzBZgClUt1y5ZVXSSrVXfbpeXJy0vn//ZqHzRLV\nWmR6S2Nc4D6JxUqL/MoRFtC2zsRXWgMSi3VKPJ4pWntQ2RRiGhuKfttCFfyzQZWGoiwCijuzTjrB\nnhJjUmJnXASL+DokmcxGTM5bIalUT9HgpSA7dux059noLIW0hNuExOPZyGNzuZyrKE+JjWl40taW\nqmmqXlRFeyrVLblcLjIBwLeO/Gp33zW3kNNmZ4MqDUVZ4PjCz/OWO8uiQ2CFxONZaWvzpFiRdAr0\ny5Yt73aWyWRkjKGajrT2On7G0qBAR1EFd3B9VqENOCVzOH98R8fAjAX2TLKXrDLNSrC63Q/iL+Rg\n9myYc6WBneD+D8BX3ef1wIdqvWi9NlUaykImOhbhtzAPC/ZJCbqsksms7N59hxQa9k0vgEdGRiSd\nLq6BKDQHLDztV6ds/HnhA2I70RYEeTWuomqzlwrKaqUUpgDa33fgwIEFnTY7G+ZDafwT8ErgocB3\nX631ovXaVGkoC5XiudjdzsIQFyuI6voabF9uhxnZ2MRWsdlGHRUFsN/zKbyfXxVeaTpfdCfaQads\nuvIKLZVaLslkd9WuokIfqpVF9SE+5ZXVqFoa0zAfSuOoew0qjYdrvWi9NlUaSqtTrkgvelrdqES3\nIu8RSEkqtVricWthlMYmXi3Bpn9bt24rc71CJXcwi8kv8ouKD5R3a6WkUEMxKuVamJcjaupe8H5F\nK6sLJJnMli1AnIuYRisG2udDaXweGAAedJ/fCny+1ovWa1OlobQaQQFTLkhrBX7x8CDPWyuJRKd4\n3lppb+9wQnkw4JIZENvnyZNYLO1qN8JKpzAiNSiwS4XvpKTTK4sypKZzFx08eFhisU4ptA1JCLxS\nCkWESUml1lbtKio38c9PBfatnvA+yWR3SbbWXAr1Vg20z4fSOB/4IvA88D1gDOir9aL12lRpKK1E\nUMCkUt0lDQI9b4ns27fP9Voqjlu0t2fEBsCXCSTdYKTgcKGewPvOEqVjP49HCuzSNNtSK2C6wHQu\nl5PC3A1/HZ7AmMC4pNOrq57JXShEDKcXB4cvfblIcTSiAK+Vq8bnQ2ksd69poDP4XSM3VRpKM1Hp\nibZUwNzrBHmh15MViucGXDtd4mcs2Sf3oOWQkFSqJ7IZH6yV0oI8T+yI1cK8CT8V9uDBw06B2WFF\n/hCjyusvPseBAwektHXIBQIHZiTgfcVqK9fDUwSLA/6+0mqUe6iV+1PNh9J4MOK7f6v1ovXaVGko\nzcJ0boooF1Bpe450yHLICtztZmqXCuQ777wzshkfeGJMMi+gE4ku59LyJ9jFBTzxvHVlLZ4oARwM\nTNspgF3531vI1CpeRzq9uiiAXil7qlQx2eaKfrFeuA9Vo5/q1dKIFsqrgSuwU1beEtjeBXyt1ovW\na1OloTQD1QiPqP5KBSEbrK/wn6QHBc4Lpc4WC2Tfdx/VyTaR6JJcLhehVEZD5/ItnoJCKvcE7ytG\n2++pNKh9zTXXSmG8qlVcO3bsLBtADxP15J7JrJUDBw4UxYCaqRdUM66pGuZSabwJ+BjwH+7V3+4E\nXl3rReu1qdJQmoFq3RRBAWOrtddJoUfTRmcF7AxYGqn8/IrwyNNg9lPpQKTC9UvXNh6yWiYlKh13\n+/YbiwR9cdC5dKaFP5PDFtndJpX6Q1WKZVSjfJstU6kZ1zQd8+GeelWtF5jLTZWG0gzMxE0RLNiz\nFkA4fdaPZyQFNhcV0+VyOTlw4EBkdlC561e2cPxrpiXYKr293StRJMlkd6hDbnQX27DyTKdXlhQM\nVvL7t+qTe6sxH0ojBfx34C7gz/2t1osGznsu8I/A14CvANvc9z3A/diBwiNAV5nj5+J+KsqMqUXY\nRaXWwhopzIroEEhGtu2YyfX9WRuFvlS9oWsclkJAvl/gBqdACuvq7NzgrIjoeEO5rrQzsTR8anly\nb8Wn/UYyH0rjfwM7XGzjnU6gf7TWiwbOexawwb3POCWxGtgFvN99fwNwe5nj5+B2KkptzFRwVS7i\n8z/3RLbuqPb6hTiEn5mVc8ohJ3aed3CM6qizcNIl1khU9lNUdXiU8ppr66FVayUayXwojYfc6yPu\nNQ48UOtFK1znb4DXAY8BS6WgWB4rs39976SizDM2I6nHPfV3CfSFLI9B6ehYWVMaZ2mn2ChX2G86\nBbHSvcbdfrskPN3PP+d0irFclftcWAKtnMHUSGajNNqojpPu9UfGmLVAF3BmlcdWhTGmH9gAPIBV\nGE87rfBUva+lKM3C1Vdfxbe//Tivfe1y4AVgCnjE/fURYILnn/82Dz74MABTU1McPXqUqampac89\nMTFBItGP7S/aC9wNvIp0+mI8bxOxmME6ER7AGvkPYJ8HzwXej312+zNSqT6WL+/j6NGj/OAHP5j2\nur29vVxyySX09vZW/K4eFP9GgPXE431MTEzU9TpKgViV++01xvQAHwI+g3Ul3VSvRRhjMsBfAdeL\nyLPGGAntEv6c59Zbb82/HxoaYmhoqF7LUpR5obe3l0OHDnLeeSt48cX/DPwnrJB/EjgFvJXf/u3t\n/PSnP+VDH/owiUQfp059j/377+J1r/t5JiYm6O/vLxHI/f39nDgxgVU+64E1pFIJ/vqvdzM4OMg9\n9+zjpps+RlDgwtlA8JgnOX36+7zpTVdhzBKOH38Sz1sB2OtfffVVc35/KlH6Gx/h5Mlj9Pf3N3Rd\nzcaRI0c4cuRIfU42nSkCtAG/UqspU8X5Y8DfYxWG/92jFLunHi1zbP3sNUWZByq5bgpprf0urnCj\n+PO2E4lznPtonRRmg3dO68sPp/lu2fLuiPqOgmunrS3tXFR2oFNbW9oV1Y1KNTM5GoFmXM0c5iGm\n8a+1XqCKc/8F8JHQd7uAG9x7DYQrCwI/fuF5ayWV6ikKEvuCf9u26yWZXOYC1X5c48IS4W6rxf2g\neWkTwiCTk5Ny5ZW/WhS7uOaaa52CKo5dGJNwwfE+gQ5pa0u5HlClLdmbqWWGZk/NjNkoDWOPr4wx\n5nbgB8Aw8FzASnlmNlaOMeY1wP/BptuK224ExoFPAucBx7CWzo8ijpdq1q8ojWZqaoqXv3yAU6fG\n8N0o7e2vJh6P88ILfwpcjnVHXYo1rn+EjUGsAS4BlgHfCJxxOfAM1hFwPjBBKpXl05++h56eniJ3\n1aOPPsqFF74CG7Ow14ZLSacHeO65r2DjKBPY5g8/CO33KhKJGCdOfNr9fTT/N8/bxLFjj9U9TlEv\npqamyrruFjvGGETE1HRwNZoF+FbE9s1aNVW9NtTSUJqMck+8w8PDLkNKAtsZUjzz4rB74h/PZzcl\nElnZtu16KS622yWFOovgaFVPkslsURX3+Pi43HnnnRLVuyrcy8m6xM6V4imAA7Jt2/XieUskleoX\n27Nqbck8jeBvboanfk3DrQzzUdxXzXfzvanSUJqJSoLKCu6g4B+NcDn1iG2JboV2Or0+30XWCvge\nsR1sw8f5o1X7BbaI38LDFt+tc5Xnpb2rbrnlw27IkZ13Yd1Sfurv3rzi8tcQ1XAw/Ju3bt2W71Kb\nTGbzqbrziabhTs98KI2oLrcl3833pkpDaQTVTtvzvCUyPDwsIyMj8tnPflYgJoV2576AlqKn+uDY\n1vCQo1SqW1KpZVJaRT7ojgvWW1zr9rPzuW2X20IzwXh8Wd4asVZQqVLx26SXE7blixNvcorsYgnW\neMwXrdyyfL6YM6WBda6+ApvNNAhsdNsQZQru5nNTpaHMN+WsiejRo34VdlJsT6dVTqieIZB0k+7K\nz+OOmmkxMjISIaj9flVh4b1cfLdXNjvoBjz5mVAFxWQ74a4Nrd1aH5UEfvRvXi7hAVLJZHUV7fVC\nLY3pmUsY6zCcAAAgAElEQVSl8U5s5Oun7tXfPgO8pdaL1mtTpaHMJzNrDOi7m3ISrsROJLpkbGws\nMlW0mvhA+Li3vOUKKY1ZBGMjPfmBSVFP4LY7bXgmxxJJp9dWHMcaPcsjKVF9q+b7KV/TcCszH+6p\nK2q9wFxuqjSU+WQ6t4cvqIqn6VVOVa0UNA5bNcFeT8Hj7KjVsHupW6xryk4E3LFjZ0WlFzWTo9Iw\nJn9diUSXxOOZvHDevPk3StYyk6f8egbRmyEg36zMpaXxdvf6XuB3wlutF63XpkpDmU+qnfdQ/ARe\n2vMplerJB5erv5bfVbb4ydkXjAVhvcI97WfFnwgYi6VLAtflu+FmJZNZW/bpvNw9CP4ev6tusANu\ncK3lfrdmPM0fc6k0trjXW6K2Wi9ar02VhjLfVCsQDx48LPF4VmxcI+kEus18am/vKBH+YYqtmuj5\nFX4FeWfnoCST3XLLLR+Wd7zjXSVP+olEV9XNA6cT7NUGmctN/SunEOoZh1ALY3rm3D3VrJsqDWU+\n8QVfOJ20nEAcGxsTSAjc7WIbmyUcsK5uil3ppLxMZm1EHMKT7dtvdBXclYV6rdQi3Ks5ppIymokS\nUGulOubS0ri5wnZTrRet16ZKQ5kvygm+XC5XViCOj4+L5/kZTGudxVEs/CsFiX0BmMmU1mbEYmnJ\nZDYUnQvWSyKRmfPMoWqCzEFBX411Uu7+VjtfvNI51OIoZS6VxnsjtpuxrT2erfWi9dpUaSj1xo9J\nhGMO5VJqt2x5d8UnZCvERgUOiO0hVSzUpktH9ddTKO4bzMcpojKeMpm1smPHzjnPHJppAL8aYR5W\nRtUe56P1GdUzL+4poBPbGv1b2IaCZ9Z60XptqjSUemLjEJ1iM59WSDzemc86KpdSm0xmKwq2Umsh\nerhRJQrC0B/JOinZ7KBs3/4BKZfx1Ci//nQWw3SKbKYWSjXXVkujlDlVGsAS4PecsrgV6Kn1YvXe\nVGko9WJyctJlPPmZTofd+xV5IWdnene4p/0lAnslnV4p27d/oKJADLc+t/GI6ltsTJcqO13G01wR\npZjqFZvwzz9TJaD1GdUxl+6p3di54DcAmVovMlebKg2lXoyPj0s6vUpsmmp0tlIul5NkMitwm8Ad\neaWSSnXLtm3Xy5133im5XG5W2UnlqCQMG2FVlAs41/tpvxYlUK5PllJgLpXGS8BxVxH+k8D2U+An\ntV60XpsqDWUmTCfMC5bGvRIuyEun18t/+S9vlkJ3WU9sv6e9YmsiBgQ6pL3d9msKCtNyvapmKtCa\nJZV0OsVQ76f9Wn63ZlFVRlNuFWUaqhEiBw8elrY2T2xabIcUxy/K9XeK6lTb5awVWyORSnUXXbfV\nBVq12VCNUnAa25geVRrKomY6ATVdz6hga45CttNOsa04BtzrToGLigQlnB/x3aDYPlDj4mdYWcvF\nXjeV6m55gdbsQlmzqKZnNkqjDUVpYQ4dGqavbzWXX34dfX2rOXRouGSfiYkJEol+7MQ5gPXE433c\nc8++omPvuWef228IO0Dy68AJ7MDK/wp8EzvNDvf6feB7oe8mgKeBfvf5SexUPnvd9vYzaWs7r2Qt\nExMTs74XQaampjh69ChTU1N1PS9Ab28v+/ffhedtIpvdiOdtYv/+uxo+Hc//zZlMhhMnJgj+dzl5\n8hj9/f2NW9xColZt0wwbamksaqp94o3ar9wTv025DbugRp3l0OcC5H72VL8U5lgUxzR8f37xdLxR\nSSQykkr1VFzzbF078+X+apYYi0j5YVDVxFWa6XfMF6h7SlmMzMQNEQ7O7tixs+TYjo510t7uSbCI\nrr29Q1Kp7kCdha9ARsUOKeqUPXv2FhUEBrN3duzY6YYnLRc7KnWdxOMZSSS6IgWaP2wpnV4lqVT3\njAX+XLqOGtmBdrokhnLV+tNdo9XjS7WiSkNZlMxUQEbHL8LB7uUSLKLzvLUyMjIi4+Pjsnv3HVIo\npusRuFKSyey0VdGpVI9TRvfmA+T+fIuwhWEtnR7xO9RWmpwXxVz58+spXGd6run2r/U3N3tsZi5R\npaEsWmaT3ukfa11LPWLTZ4tdR+DJ2NiYiIgr7lsuhSD5RoEO2bFjZ9F5oxWSJ7BOgpP0wkJtZGRE\norK2RkZGqv5NcyEIZ6Oc63Gu6fav9Tcv5oC5Kg1lUVOumKuc8Ap+b6fWDTgLQMRWgneI7RPlCZwt\nyWS37Nmz19VxdJUolrArJLpPVXCSXlekhWKVRnj+98CMlIZI/eskanED1ssqqHb/WosA1dJQpaEs\nQKrxf5cLhPqzJsq1Mb/llg+L7T47Gni6Twp0Fn1nZ2isc1bG8rz7CkRSqeWSTHZXbNBnLQxfMa2Q\nWCwd2W4kkegqOi48C6Oe92wm56o14WC2VsFM9p9NEeBiazuiSkNZsFTj/y4VLKNO8N9X5B7avfuO\n0H67nDVxgXvtd8J9iftO8ltn5wbXQuQmt+/Fbj//c7kBSRuk0KgwqEBGI4VfcGTsfAixagVtNcJ1\nrqyCuRbsmj2lSkNZIFT7lFksrA4HhH63+ywC6yUeTwcGFJX2l7L7H5BEIiOJRLbkuoVAePCYpKRS\nayMFpS+Mdu++w6Xe+rM1Dld0y8yXEJtpQHq6nk5zaRUsRsE+l6jSUBYkMxktWqjkjnILjQp0S0fH\nCjeCNXoang2Ix8Tz1kki0VVUb3Hw4GEZHx8vmYqXTpdO0Ivqw2QHJnnOMqksUOeDWv350ymaxeru\naTVUaSgLkukEW/Dp8+DBw859tDKkCC5wrqo+AU/a2lJiA9ml0/DCfaM8b0lRWmzUehKJLonF0mKD\n5wOSSHRV7PgKXkPamIepJXNoJrENtQqam9koDW0jojSM6Vpd9Pb2snnz24FLgZXApWze/HZ6e3tL\n2ocA/MM/fI5E4mmK23p8FziMbe/xAC+91AZ8Fngf8JvAq4CNwCbgbuB8t69t79HT05NvjxG1ntOn\nT3Lq1D+7Y26jrc3wutf9PBDdvqSzcxX/63+9j2PHHuPqq6+a7S2smf7+/hm32ijXjiXcAqW3t5dL\nLrmk4W1FlDmiVm1Trw3Yj23W80jgux7gfuBxYAToKnNsPZWvMo/MLMA9Kn4Vtp/eGvXEb1uD+JXX\n1m2USJwnwUwnOMtZExtdDCMuwaI7a21MRj5Fl67nbgmnyAaf1huV0lnP4Hb4vIs1RXWhQSu7p4Cf\nBTaElMYu4P3u/Q3A7WWOreNtVOaLaoXPyMiIG4zkC/xJSadXyp133lkSWyjuJjsqyWTWpdMGi+pK\nM53a2tICCbGZUx3u/UDZGgObdusroUkJF+OFf8d8+fh9ReFnbc00uF2t4NeYxcKgpZWGXT99IaXx\nGLDUvT8LeKzMcfW7i8q8UY0/vVCtvcI9/V8v/qS8WKzTWQjhFiCT+fNlMmsDQW9/H09SqTWB6/qF\nfAPO+tgrfrru8PBwybr37Nkrxem2uyQez0wrROfax+/fK6vQStN/631djVm0PgtRaTwT+vszZY6r\n1z1U5pFqAtyldRfhoLUnkBZbae1Je3vxE38ikSlxHcGAtLen3X6TUtoyxC/AK63CLhfU3rNnr+Ry\nOTlw4ICMjY3NuzAtXldpRthiaYuhzIzZKI1Y/aMkc4KU+8Ott96afz80NMTQ0NA8LEeZDf48hs2b\nNxGP93Hy5LGieQx+wPX4cT/gmgbOJRiAhQuwwefdwHWcPv1d4FI8bwD4Ptdfv43bb/9jbKB3Pf5s\ni9OnT2CD3z3AGaFz9gFfIB6fYnBwsGjNpWtaTyazkqmpKV7xip8FzuH48SfwvLOAH7N//13zEugu\nXtcU8B2Cv1nnSCgAR44c4ciRI/U5Wa3app4bpZbGoxS7px4tc1z9VK8yI+rhoog6h98PqvD0PCk2\n4BwetdotdnLeHziL4z6BLkkkMpLL5ZwrKSHBNuf2830CI+64sPXSIeCVNCD01xVlaZTO3yhf7T0X\n97Z0XbbKvbNzg8YclLKwANxT/cBXAp93ATe49xoIbzJm0ya7kkAMnjcezzhXUofACmlvzzihv15s\nX6isi0V4AkvFH4qUTq8MKJ1dTrmscEqn0+230b2+zB2/xr2eKZDK96kKU4hprHfHb41wgQ0KjNfs\nFqrl3oaD0+H5HooSpqWVBnAQOzfzReDbwK9jfQdfxKbc3g90lzm2vndSmZbZpF1WEoiTk5Oui6yf\n/jpaYgnE41kXuwi3D1+S3z+ZzMrIyEioXci42KK/qLjIcrHFfxeJH9wu93uqyZ6ajaVR6731rTNf\nSSzWwUJK9bS00pjNpkpj/plJJXHQqphOINpZFR0BK2CnhKu7PW+txGJe2ad7GJDt22903WKzUlx/\nkZVwE8JCmm2x0M9k1pb9PeHf4GdPeZ6tME+l+msW1LVUaYcVRFSHXa2lUMKo0lDmjWqfhsPCLGq8\narCxX2m8IFvGMrhPyveXsqNZt2693qXbDjilkJGoGg3rrgrXe6wvO40v+LuCKbbTNfKr972ttH8y\nmS2pYdEMKiWMKg1lXpmuwKuc8LPup0IabTKZlVwu54r4SpsH/szPvDp/nWTSr/YWKe5k6wksc69+\nnUVpgDuV6pYrr7wq33bcKpO9EQrIk82bf6Pi7/dTbHO53Lzf2yBRlkkmU7mBoqKIqNJQGkC5zKfx\n8XEZHh6WZPKiEtfSjh07nfJYLpCSZHJAYrG0y0AKu4l6pL09Lfv27ZPh4WEZHh6OyKhKiHVVJQVu\ndMeOS6kbquC2GhkZkTvuuEMK2ViHxWZW+QV+N1UUsvMRL6g2e6qccvZdVFq1rZRDlYbScHxh6nnr\nnEAudS3lcjnJ5XIuKyorNmU2Snj7MycGBM4V20tqucTjGWlr8wPhK9w5trpzjOYtmOJrjwokpa3N\nywt72+nWz7gaFJthdbbYVNzKMZpwsN63lhpFOctEq7aVSqjSUOpKLQNySmMSGSeMrRKIx8+T8fFx\n2bdvn7MMesRWL3dIYVDSpFMGI3lroxDI7hZbWxGu1/Ckra3HjWPdIPF4Vozxp+8tl+LJfLvc+bLu\n3KPiN0K0549uVOhTHKzvcr9xpSST3Q19mlcFocwUVRpK3ajF/RLlW7dP8CNiM6DuFvDkLW+5UqBN\nolxRBeXgp8EGlYnfI2pt6HsRWCeJREa2bbvepeP6iuJ3nCIIB8xvdIrJj4sMCnSIMcmKI1ajFWP5\njriK0syo0lDqwmzqBEoFaqF2AtJiTKd7f46zPoIKZkDa25c5hXCHe4LvkvI9ooqVTCzm95nqccrg\ny2KtmXBsY507d0/g3PdKLJaRZDIrHR0DkkhkIov7yivGcdEMJaXVmI3S0CFMSp5qh+yE8XtJed4m\nYAV2SFEaeKPb40xETgEPAA8Bz1A8KOn7iDwFCPA64M+AU9geUYOU9oha4r5/FXCaU6duAr4BHAHe\nA5yN7U313dB1ngDOxA5b2gT8Z+BaRE7z4osf5Pnnf8iJEwNcd9313HPPvqLfGDW0yPa+6ifc42m6\n4VKK0tLUqm2aYWOBWxrz7aueqaUR7u76P/7H9e4Jf617ovcD0uNiW2/4T+i+u8mmvl50kd/S2491\nbBAbu9gsMBzhZvLEurx8a2OJQE6sO+x897duicXS4nlLpKNjnbvehwPnslZGIpGVdHqNhFNvk8nu\nsrUn2exg5Azx4D5aja00M6h7auHRKOHjX9fm+2fL9mHauvV6J7zPF0hKe/uSgJKYFLgy4Ia6wymE\n0YDg7xa4W+LxzkD9xk53jpVimxB2ORdTwn2/wr2eHXITXeiUgj8bwxNjEnLw4GHZs2evmx2+3Cmk\nbeJnafnpqfbvxXUinZ0bqqpyDyp1nWyntAqqNBYY8yF8KlkxVpB2S2dn4Sk6WNCWy+Wc8L5JbCbS\nRU4pXCiFAPPywD6e28cTP4XWb+Hxjne8KzCdb9Ipk2D/qaTYgUtdAqtCFoyvgDwpxEAkbymMjY25\nQrdRKWRJdUgymZUdO3bmf3uhEeHs7nctbUAUpRGo0lhgzLXwCVoxqVR3kQCNUlhtbV7AAvDkta+9\nXGydQ3CK3U1iXUrBoHWwdcekUwZZZzHcIO3tnnvKDwaxbWtvW7XtCbxNSrOt4iHLw+9cW7hfyeSF\nEo+nBV4uwc62icSykgFLIkFFWXtLcbU0lFZBlcYCYy6FT/G5/YK6FXlBWaqwfKsiKLSjivf8VuMD\nUugsOyLWveRbHxudAmh3xw9IccaTbfexefNvOIF/vjtHsEGh31l21F3jvghl5VsfByLW6ZUtxqtH\nDElnaCutgCqNBchcCZ+CUpiUcPDX85ZILpcLtevYIqWpq+dJe/uq0HfrxcYe/GC2XwBXTqCPhhTO\npKTT62Xfvn3O+vAbE45KsevpXintctvvru3HNLJuHSNi02wL+3pedAfbeqLFdkqzo0pjgTIXwqdg\nadwrYZeO7wI7ePBwoB/UMikNYqcklSpVBL/2a2+PeLKPSWldxgXi1zcU6h3ulXi808UgVjqFsc29\nni12VsaFkkp1uzYkwbbnXWIHKY24bdJd8+5IxajCXFnsqNJoIZrhKfTgwcMuY6kjUqAWFMsuJ3T9\nILYV3lu3bstbQp2dGySZ7Jbdu++Q9773vRFWwHJpbw+PRA1bGjY4nUh0SanL6z5JJDKyb98+2bdv\nn7zjHe+SWKxTCm3P/UB58W9JJLokleqWVKpfbO+qteouUhSHKo0WoZly+CcnJ/NdZ8OzIQ4cOBBZ\nuxCLdcrY2Fj+eH9a3O7dd0gymZV43M+YKlYQt9zyYdfd1lc+/pjVCwU82b79AzIyMhJRcX2BtLd3\nuJqIZWJdXeGgeIckEpl82/O5mHOhKAuN2SgNY49vTYwx0irrn5qaoq9vNcePj2Krmh/B8zZx7Nhj\n9Pb2zus6JiYm6O/vp7e3N/85k8nwqU/dx+///h3EYn389Kc5bHX3V/PHet6F7Nr1bhKJFL/929tJ\nJPp57rnHOXXqJWAlcAyIA6eBPuAYbW0eDzxwH5lMhvHxcb71rWPcfvsdxGIv59Sp7/PRj/4hW7Zc\nG3l/4vH/RFsbvPjip4ErgD8B7gD+Lb+mdPpi/vqvd/P617++5LcpihKNMQYRMTUdXKu2aYaNFrI0\nmiGHv+BSskON/MK9aHfVaMhq2CXFaa5+x9iwS8mfrjeeP8fu3XeUjCSNevIvtFe3o1MTiT63pp1i\n4y/RwXu1IBRlZqDuqeanETn8083oBk+2bbu+bGDc1mJ0is1OSklx8HmJ2KDzYOiYC12cYYPbZ6m0\nt1cunAuuM5fLueyp0cA6uwLKojB3I5Xq0RiFotSAKo0WYa5z+IPC9+DBw5JMZiWVWpavgA7PjrZp\nsnFnPZQ+xdun/GGBXinMkfAHJK13SiMqnfZt7m+jUki7nSyxsCYnJ2X79hvdXOt1ZWeJ26D3WQFL\nJyVXXnmVWhiKUiOqNFqI2WRPVTo2XOVdqJq2VdzGJF3WUVDAdwmsDriYip/i4/GMczWFg9s9ThEM\nOKuiU2xleNZd189sSkhhNsbWIktjz569EoulpbiqfFfELPGCVdPRsVpuvvnmhk7KU5SFgCqNRUCl\nzKti19Nesc3+Squ4bTuQHudS6nH7dbtjOiSdXl/UVsS3VqzgHw9YCwMCZ7hr9LrXlNi+UMFrFqbh\ngScdHedLKmVjKVYxlKbYplKr81ld4YrxxRC/aIaUbGXho0qjiZlOCFT6ezBlNCoeMjY2JgcOHJDh\n4WHn0rnDCfDbnIUhge1cSaXWSqHFh18At1Pgy5JKdcvw8LCMjIwUrWX3bv+cBWvACvtgbGPUWRvh\nIr7CkCJrvVyQd0HZJoUbQvuvF0hKLpfLpwSnUt2LpiVHM6VkKwsbVRpNynRCoNLfd+++Q+LxtKTT\naySZzIrnrQsJWN81tNIJ9bj7fLHAmERVcdtq63D8wXabbWvzJJHoyq9lx46dkcrKWhQpZ50EFYM/\nijXsxposee95S5wFU5p5lUyeV5RRVqkV+UJCmx0q84kqjSZkOiFQ6e/XXPObEoxHwFskuh34aOjz\ngHvi7xHbVsMTP4D8+tf/goshJAX6JR7Pus/3im1K6Ae0J8W230hIPJ52BXm+ovKHJ/lDk24KWBo9\nUmhhfqEUhir58Y3CXO/Ozg2yY8fOQExjnVhX1k1lBeVCfwpvhpRsZfGgSqMJmU4IlPv78PBwpIIw\nJhtQJJ1SOojIr5/ISDA1tr09Ix/5yEdcLyk/ntEl7e2edHauc/sdcIL7sBP6K6TQoiPY2jwqU8pm\nVrW3pyUeX+qE/yqBbonHz5SdO3dGBLY92bNnb1H2VCZTvs3HYngKXwy/UWkeVGk0IbVaGnfeeaeU\nxiMukEI7cf+pPBEhwFdJaWrsgLS19UhU+w1bP+ErkpRTRmH3Uod7PUdK+0qtFzhDkslzJJnsilzT\n8PBwIC6yXoJZUsF7UcnttFiewrWtujJfLFilAbwBeAz4OnBDxN/rdQ/nhHJCIJfLyZYt75b29sKI\n0njc1lKMjY1FWBpR8yv8jKULpFAbEa7G7nGWgz+M6Gax8Y5JgbNdt9hgy/GoQPZKsTUXN0aswT9/\ncMpeLnD8gKTTq1y9yBoJZmDNROgvpqfwhRy3UZqH2SiNpu09ZYxpwyqL1wLfB44CvyoijwX2kWZd\nv8+jjz7KF7/4RU6dOkUsFuOBB45y8OBfAecC38X2WTLAUVKpPuAZfu7nXsX9948CLwN+AGSALuCJ\nwJlXAD8B3g28HniN2/84kAUmgXbgFcA4kHTX/DYQA84CngT+HLgKmAL6gS/h936CIeAl4Btu30vc\nOV/uPp8GPu7W8x7gDHfde4A1wGXY/4RfA34ReIBa+24dOjTM5s3vIR7v4+TJY+zffxdXX31VVccq\nilLMguw9BVwKfD7weTsha4MWsDSsywaBNufiiernNCCFsaUZ98SelEIl9q9WsDQuEltU53eYTbhX\n3wJpd9/5vaKyofNkpZDhlHBWSaE4z5iU2AyrTrEZU6MCCfnIRz7iYhWjEl1J7olN57VWRyrVL8nk\n7NJn9SlcUeoDC9E9hW1rujfw+e3AnaF96nUP687k5KQU4hC+AG+TwhS8cm07smIHF3nOpeTPsYia\nTOfPu/AzpaJcSJ4UiviGpTQuMeAUjl+DkRLr6so4heQHwwfFj5P40+8KxX/hGMxat95RCbqTtEW5\nojQHs1EabbMxcZTy3HjjjUAC65L5unuNY11SjwATwHlYdw3udRXwIbff54AX3OuLWO/cBHAbIMBS\nYBcwCvwxcA7wf7EuqOA5z8G6t14GPI319D3i/v4I1s3029jQ0fvdmv4W+P/duTvc2h90n9+NyHfp\n7+/n6quv4qGHHiCZnAyd89/ZvPkdeN4VZLMb8bxN7N9/F2vWrOGSSy7RtuWK0sLEGr2ACnwPWBb4\nfK77rohbb701/35oaIihoaG5XldVjI6OUirAl2GVxqXYmMJTWCHrxxCOASl3XBobY/Bf/fO8DbgZ\nG5u40H3/FFYZ/ArwR6Fzfg9oA34M/CFwChur6McqoVPAOqDX7f9d4Hx3/FFgeeg3LOGDH7wmL/jX\nrFnDxz62h82bNxGLLePEiQk++tGPsmXLtfzP//n7Ot9CUZqAI0eOcOTIkfqcrFYTZa43bMT1Cew0\nnwTwMLAmtE/97LU6c9NNN5VxFSWd+ykmthiuW4p7LPkNAkelUDgXdmN1B1xffg1F2p3Dd235dRt+\nTGOJe590Lqhz3Gss7/Zqb8/I29729tB5i2szymUtabxBUVoHFmL2FIAx5g3AR7GPyvtF5PbQ36WZ\n159MdnDiBFgX0feAk9hspJh7fQmrDzuA54GX094+SSrVxnPPncRmTP0Ymw31E+BsrFVxCjhFJtPJ\ns8+ewGYzfRebhbUE64Y6zeDgRrZvv4FzzjmHBx98EM/zWLZsGeeddx7f+c53AEin0zz44IMsXbqU\nTZs20dvbyz337OP6699PItHPCy88gTHtpFLna9aSoiwQZpM91dRKYzqaXWkA3HzzzXziE59g1apV\nvPWtbwXgq1/9Kl//+td5/vnnSaVS/PCHP2TVqlW88Y1vzAvuu+++m0OHDjE0NMTAwABnnHEGX/rS\nl3jooYdoa2vjuuuu441vfCOPPvoo9913HwCXXXYZzz33HACDg4OzcgkFR6cC6mZSlAWEKg1FURSl\namajNDR7SlEURakaVRqKoihK1ajSUBRFUapGlYaiKIpSNao0FEVRlKpRpaEoiqJUjSoNRVEUpWpU\naSiKoihVo0pDURRFqRpVGoqiKErVqNJQFEVRqkaVhqIoilI1qjQURVGUqlGloSiKolSNKg1FURSl\nalRpKIqiKFWjSkNRFEWpGlUaiqIoStWo0lAURVGqRpWGoiiKUjWqNBRFUZSqUaWhKIqiVI0qDUVR\nFKVqVGkoiqIoVaNKQ1EURakaVRqKoihK1ajSUBRFUaqmYUrDGPNWY8xXjTGnjTEbQ3/7gDHmG8aY\nR40xr2/UGhVFUZRiGmlpfAX4r8A/Bb80xqwBfgVYA/wCcJcxxsz/8urHkSNHGr2EqtB11hddZ/1o\nhTVC66xzNjRMaYjI4yLyDSCsEN4EHBaRUyIyAXwDeOV8r6+etMo/JF1nfdF11o9WWCO0zjpnQzPG\nNM4BvhP4/D33naIoitJgYnN5cmPMF4Clwa8AAT4oIp+dy2sriqIo9ceISGMXYMwo8F4RedB93g6I\niOxyn/8euEVE/iXi2MYuXlEUpUURkZpixXNqacyA4OI/A9xrjPkjrFtqBTAedVCtP1pRFEWpjUam\n3L7ZGPMd4FLgb40xnwcQkRzwSSAHfA54jzTaHFIURVGAJnBPKYqiKK1DM2ZPlcUY02OMud8Y87gx\nZsQY01VmvwljzJeNMQ8ZYyJdW3O0vjcYYx4zxnzdGHNDmX3udIWLDxtjNszX2kJrqLhOY8xlxpgf\nGWMedNuHGrDG/caYp40xj1TYpxnuZcV1Nsm9PNcY84/GmK8ZY75ijNlWZr+G3s9q1tkk9zNpjPkX\nJw8ZCOcAAAZZSURBVF++Zoz5/TL7Nfp+TrvOmu6niLTMBuwC3u/e3wDcXma/bwI987y2NuAJoA+I\nAw8Dq0P7/ALwd+79zwAPNOAeVrPOy4DPNPi/9c8CG4BHyvy94feyynU2w708C9jg3meAx5v032Y1\n62z4/XTr6HCv7cADwGua7X5Wuc4Z38+WsjSwhX8fd+8/Dry5zH6G+beiXgl8Q0SOichJ4DB2vUHe\nBPwFgNhssC5jzFLml2rWCaVFl/OKiIwBP6ywSzPcy2rWCY2/l0+JyMPu/bPAo5TWPjX8fla5Tmjw\n/QQQkefd2yRW1oT/DTT8frprT7dOmOH9bDWlcaaIPA32HxhwZpn9BPiCMeaoMebaeVpbuCjxu5T+\ng2+GwsVq1gnwKmdW/50x5sL5WdqMaIZ7WS1Ncy+NMf1Yyyicwt5U97PCOqEJ7qcxps0Y8xDwFHBE\nbAJPkKa4n1WsE2Z4P5sl5TZPhYLAKF9buSj+a0TkSWNML1Z5POqeCJXq+DdgmYg8b4z5BeBvgJUN\nXlOr0jT30hiTAf4KuN49yTcl06yzKe6niLwEDBpjssD9xpjLROSfpjtuvqlinTO+n01naYjI5SKy\nPrCtc6+fAZ72TTxjzFnAZJlzPOlep4D7mJ/eVd8DlgU+n+u+C+9z3jT7zDXTrlNEnvXNWhH5PBA3\nxiyZvyVWRTPcy2lplntpjIlhBfEnROTTEbs0xf2cbp3Ncj8D6/kJ8HfA/xf6U1PcT59y66zlfjad\n0piGzwDvcu/fCZT8ozLGdLgnFYwxaeD1wFfnYW1HgRXGmD5jTAL4VbfeIJ8B3uHWdinwI9/dNo9M\nu86g79UY80psavYz87tMe3nK+1ub4V76lF1nE93LPwdyIvLRMn9vlvtZcZ3NcD+NMS8zLnPTGOMB\nl2MTSoI0/H5Ws85a7mfTuaemYRfwSWPMNcAxbAt1jDFnA/tE5I1Y19Z9xrYYiQH3isj9c70wETlt\njNkK3I9VxvtF5FFjzBb7Z9krIp8zxvyiMeYJ4Dng1+d6XbWsE3irMebdwEngOHDVfK/TGHMQGALO\nMMZ8G7gFSNBE97KaddIc9/I1wK8BX3H+bQFuxGbQNc39rGadNMH9BM4GPm6M8RNuPiEi/9Bs/69X\ns05quJ9a3KcoiqJUTau5pxRFUZQGokpDURRFqRpVGoqiKErVqNJQFEVRqkaVhqIoilI1qjQURVGU\nqlGloSxKjDGnXSvorxhjho0xKVfw+JU5vOZlxpjPzvCYd7ruB4rSFKjSUBYrz4nIRhFZhy1sus59\nP9eFSzM9/7to3kaMyiJElYaiwP/FzqIHiBlj9hpjvmqM+XtjTBLAGHOxMeZLrhvopwLtGbYZO+Dm\nYVcdjjHmFmPMXxhj/tnYgWG/EbhWpzHmfxtjHjXGfML/0hhzk7EDcx4xxuxx312B7RX0l84qShpj\nNhpjjhjbwfnzpgHttpXFjSoNZbFiIN8g7xcA3y11AfAnIrIW+DFwhfv+L4DfFZEN2F5mt7jvb8AO\nDtpAwVoBWIdtL/Jq4OaAi2kDsA24EBgwxrzaff8nIvIzIrIe6DDG/JKIfAr4V+BtIrIROA38CXCF\niFwCfAyInBqnKHOFKg1lseIZYx4ExrF9zPa7778pIr4C+Teg37WV7gq01/848HPu/ZeBg8aYX8MK\ndZ9Pi8gJEfkP4B8pdFoeF5EnxfbveRjod9+/1hjzgLFjYzcBFwXO5TdDXAWsxbb7fwj4IPDy2m+B\nosycVmtYqCj14nn39J7H9nXjxcBXp4GU/+cy5/klrAL5ZeCDxpi17vtg7MIEPofPH3MusD8FNorI\n940xtwSuW7RE4Ksi8ppKP0xR5hK1NJTFSjklUPK9m0XwjOvCCvDfAH+QzTI31GY7kMXOtgZ4kzEm\nYYw5AzuH+WiFtaSwSuU/XFv/twb+9lN3XrAzs3tdq22MMTHTnFMVlQWMWhrKYqVcFlO5798F7HFz\nCb4J/LqLh/ylc18Z4KMi8hNnsTwCHAHOAG4TkaeMMauiriUiPzbG/BnwNeBJrMvM54C77vPAq4Ar\ngTtdIL4d+GMgaoSnoswJ2hpdUeqMcy/9VEQ+0ui1KEq9UfeUoiiKUjVqaSiKoihVo5aGoiiKUjWq\nNBRFUZSqUaWhKIqiVI0qDUVRFKVqVGkoiqIoVaNKQ1EURama/weoNCpUQ7mqvwAAAABJRU5ErkJg\ngg==\n", "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "qrydf.plot(kind='scatter',x='Phosphate',y='Nitrate')" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] } ], "metadata": { "anaconda-cloud": {}, "kernelspec": { "display_name": "Python [default]", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.5.2" } }, "nbformat": 4, "nbformat_minor": 1 }