{ "metadata": { "name": "EPA_to_DF" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "Converting EPA Airquality Data into Pandas DataFrames by County\n", "---------------------------------------------------------------" ] }, { "cell_type": "code", "collapsed": false, "input": [ "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "from pandas import DataFrame" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 1 }, { "cell_type": "code", "collapsed": false, "input": [ "#Airquality Data comes from https://ofmext.epa.gov/AQDMRS/aqdmrs.html\n", "#This query includes the ozone data for the year 2011 in the state of california\n", "a = open('AQDM_507410362.txt')" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 2 }, { "cell_type": "code", "collapsed": false, "input": [ "df = pd.read_csv(a)" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 3 }, { "cell_type": "code", "collapsed": false, "input": [ "df.head()" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "pyout", "prompt_number": 4, "text": [ "\n", "Int64Index: 5 entries, 0 to 4\n", "Data columns:\n", "Latitude 5 non-null values\n", "Longitude 5 non-null values\n", "Datum 5 non-null values\n", "Horizontal Accuracy 5 non-null values\n", "State Code 5 non-null values\n", "County Code 5 non-null values\n", "Site Num 5 non-null values\n", "Parameter Code 5 non-null values\n", "POC 5 non-null values\n", "AQS Parameter Desc 5 non-null values\n", "Date Local 5 non-null values\n", "24 Hour Local 5 non-null values\n", "Date GMT 5 non-null values\n", "24 Hour GMT 5 non-null values\n", "Year GMT 5 non-null values\n", "Day In Year GMT 5 non-null values\n", "Sample Measurement 5 non-null values\n", "Units of Measure 5 non-null values\n", "Sample Duration 5 non-null values\n", "Sample Frequency 0 non-null values\n", "Detection Limit 5 non-null values\n", "Measurement Uncertainty 0 non-null values\n", "Qualifier Description 0 non-null values\n", "Method Type 5 non-null values\n", "Method Description 5 non-null values\n", "dtypes: float64(13), object(12)" ] } ], "prompt_number": 4 }, { "cell_type": "code", "collapsed": false, "input": [ "len(df)" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "pyout", "prompt_number": 5, "text": [ "2995068" ] } ], "prompt_number": 5 }, { "cell_type": "markdown", "metadata": {}, "source": [ "Group all measurements by measurement site (identified by countycode and site number) and create a new DataFrame with data averaged over time per measurement site" ] }, { "cell_type": "code", "collapsed": false, "input": [ "\n", "county_df = df.groupby(['County Code','Site Num', 'Latitude', 'Longitude'])\n", "\n", "county_code = list()\n", "sitenum = list()\n", "lat = list()\n", "lon = list()\n", "mean_meas = list()\n", "max_meas = list()\n", "min_meas = list()\n", "median_meas = list()\n", "\n", "for grpname,grp in county_df:\n", " county_code.append(grpname[0])\n", " sitenum.append(grpname[1])\n", " lat.append(float(grpname[2]))\n", " lon.append(float(grpname[3]))\n", " mean_meas.append(grp['Sample Measurement'].mean())\n", " max_meas.append(grp['Sample Measurement'].max())\n", " min_meas.append(grp['Sample Measurement'].min())\n", " median_meas.append(grp['Sample Measurement'].median())" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 6 }, { "cell_type": "code", "collapsed": false, "input": [ "sites_dict = {'County Code': county_code, 'Site Num': sitenum, 'Mean Ozone': mean_meas, 'Max Ozone': max_meas, 'Min Ozone': min_meas, 'Median Ozone': median_meas, 'Latitude': lat, 'Longitude': lon}" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "\n" ] } ], "prompt_number": 10 }, { "cell_type": "code", "collapsed": false, "input": [ "sites_df = DataFrame(sites_dict)\n", "sites_df.head()" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
County CodeLatitudeLongitudeMax OzoneMean OzoneMedian OzoneMin OzoneSite Num
0 1 37.687526-121.784217 0.115 0.023289 0.023 0.000 7
1 1 37.687526-121.784217 0.063 0.033426 0.035 0.003 7
2 1 37.743065-122.169935 0.091 0.018510 0.018 0.000 9
3 1 37.743065-122.169935 0.051 0.027224 0.028 0.002 9
4 1 37.814781-122.282347 0.057 0.018001 0.018 0.000 11
\n", "
" ], "output_type": "pyout", "prompt_number": 11, "text": [ " County Code Latitude Longitude Max Ozone Mean Ozone Median Ozone Min Ozone \\\n", "0 1 37.687526 -121.784217 0.115 0.023289 0.023 0.000 \n", "1 1 37.687526 -121.784217 0.063 0.033426 0.035 0.003 \n", "2 1 37.743065 -122.169935 0.091 0.018510 0.018 0.000 \n", "3 1 37.743065 -122.169935 0.051 0.027224 0.028 0.002 \n", "4 1 37.814781 -122.282347 0.057 0.018001 0.018 0.000 \n", "\n", " Site Num \n", "0 7 \n", "1 7 \n", "2 9 \n", "3 9 \n", "4 11 " ] } ], "prompt_number": 11 }, { "cell_type": "markdown", "metadata": {}, "source": [ "Look at some overall stats for our new DataFrame" ] }, { "cell_type": "code", "collapsed": false, "input": [ "print 'Std ', sites_df['Mean Ozone'].std()\n", "print 'Mean ',sites_df['Mean Ozone'].mean()\n", "print 'Median',sites_df['Mean Ozone'].median()\n", "print 'Lat Max',sites_df['Latitude'].max()\n", "print 'Lat Min',sites_df['Latitude'].min()\n", "print 'Lon Max',sites_df['Longitude'].max()\n", "print 'Lon Min',sites_df['Longitude'].min()" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "Std 0.00994831782491\n", "Mean 0.035125235605\n", "Median 0.0332733333333\n", "Lat Max 41.726892\n", "Lat Min 32.552164\n", "Lon Max -114.602886\n", "Lon Min -124.20139\n" ] } ], "prompt_number": 12 }, { "cell_type": "markdown", "metadata": {}, "source": [ "Plot all measureing stations to see if they are evenly distributed" ] }, { "cell_type": "code", "collapsed": false, "input": [ "plt.scatter(sites_df['Longitude'],sites_df['Latitude'])" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "pyout", "prompt_number": 13, "text": [ "" ] }, { "output_type": "display_data", "png": "iVBORw0KGgoAAAANSUhEUgAAAXkAAAD9CAYAAABZVQdHAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzs3Xd4FOXawOHfbnovhDRCCYRekmDoxSBVEJByUFBABEQQ\nOILSBEUFEREUpNkOgiCfFTFBQIoJRaR31EORLmAoSSA9u8/3x0zi5oSWZJOQ5L2vK5dkduadZwZ8\nZvatBhERFEVRlFLJWNwBKIqiKIVHJXlFUZRSTCV5RVGUUkwleUVRlFJMJXlFUZRSTCV5RVGUUuy+\nkrzJZCI8PJyuXbvm2D5nzhyMRiPXr18vlOAURVGUgrmvJD9v3jzq1KmDwWDI3nb+/Hk2btxI5cqV\nCy04RVEUpWDumeQvXLjA2rVrGTJkCJbjpsaOHcusWbMKNThFURSlYGzvtcOYMWN49913SUxMzN72\nww8/EBQURIMGDe54nOVbv6IoinL/rDkRwV3f5NesWYOvry/h4eHZJ01OTmbGjBm88cYb9wxIRErt\nz9SpU4s9BnVt6vrU9ZW+H2u765v8jh07iIqKYu3ataSmppKYmMiAAQM4c+YMoaGhgFad89BDD7F7\n9258fX2tHqCiKIqSf3dN8jNmzGDGjBkAbNmyhdmzZ/Ptt9/m2Cc4OJh9+/bh7e1deFEqiqIo+ZKn\nfvK3q2cvq3XvkZGRxR1CoSnN1wbq+kq60n591maQwqgEQkv+hVS0oihKqWXt3KlGvCqKopRiKskr\niqKUYirJK4qilGIqySuKopRiKskriqKUYirJK4qilGIqySuKopRiKskriqKUYirJK4qilGIqySuK\nopRiKskriqKUYirJK4qilGIqySuKopRiKskriqKUYirJK4qilGIqySuKopRiKskriqKUYirJK4qi\nlGIqySuKopRiKskriqKUYirJK4qilGIqySuKopRiKskriqKUYirJK4qilGIqySuKopRiKskriqKU\nYirJK4qilGIqySuKopRi95XkTSYT4eHhdO3aFYBx48ZRu3ZtQkND6dmzJwkJCYUapKIoipI/95Xk\n582bR506dTAYDAB06NCBY8eOcejQIWrUqMHbb79dqEEqiqIo+XPPJH/hwgXWrl3LkCFDEBEA2rdv\nj9GoHdqkSRMuXLhQuFEqiqIo+WJ7rx3GjBnDu+++S2Ji4m0/X7JkCX379r3tZ6+//nr2nyMjI4mM\njMxXkIqiKKVVbGwssbGxhVa+QbJez29jzZo1rFu3joULFxIbG8ucOXOIjo7O/vytt95i//79fPfd\nd7kLNhi4S9GKoijKbVg7d971TX7Hjh1ERUWxdu1aUlNTSUxMZMCAAXz++ecsXbqUtWvXsnnzZqsF\noyiKoljXXd/kLW3ZsoXZs2cTHR3N+vXreemll9iyZQs+Pj63L1i9yRep5ORkWrXqxKFDv2FnZ8/b\nb4/nxRdfLO6wFEXJoyJ9k7ckItm9a0aNGkV6ejrt27cHoFmzZixatMhqQSl517hxG44dswN+wmT6\nkzFjBlGpUiV69uxZ3KEpilKM7vtNPs8Fqzf5ImUwuAJHgGB9y0s88sghNm/eVIxRKYqSV9bOnWrE\naylhMNgAcRZb/sbFxbm4wlEU5QGhknwpMWBAb+Ax4H1gBAbD92qQmqIoqrqmNJk2bRorVnyPt7cr\nH320gAYNGhR3SIqi5JG1c6dK8oqiKA8QVSevKIqi3DeV5BVFUUoxleQVRVFKMZXkFUVRSjGV5BVF\nUUoxleQVRVFKMZXkFUVRSjGV5BVFUUoxleQVRVFKMZXkFUVRSjGV5O8hMTGRtWvX8vvvvxd3KIqi\nKHmmkvxdREdH4+ERQJcug6hTpyEPP9ypuENSFEXJE5Xk78BsNtOtWz8gHbgGBLN16wHmzZtXzJHl\n3YULF+jWrRvNmrXkvffeK+5wFEUpQirJ30Hfvv2BysBF4DrgBziybdu2Yo0rry5fvkxwcH2io+3Z\nubM9L700g0GDhhZ3WIqiFBGV5O8gNnYvMAHwBdyB14BbhIaGFmtceTV+/HgyMxsD3wJTgY0sW/Z/\nxRyVoihFRSX5O/DxcQf2WmzZi9EIkydPLq6Q8iUhIQGoarGlEiIZViv/2LFj1KzZEC+vqjzyyKMk\nJydbrWxFUQpOJfk7+OqrzzAalwDtge7A66xduxKjsWTdsmeffRZYDvwInAKGAI4MGzaMzMzMApV9\n+fJlQkNbcPx4S+LjZxMTk0zNmhEFD1pRFKtRK0PdxdmzZ5k5cyYZGRm8+OKL1KtXr7hDyheDwRlw\nRmtEtgNuAU44Otpx8OB2atasma9yp0yZwltvbQJ26luSAE8uXTqPv7+/FSJXlLLH2rnT1mollUKV\nK1dm8eLFxR1GgTk4uJOWtgiIBg4AWwE3UlNH8/DD3bh8+b/5KtdsNpPzy6ARMOjbFUV5EJSsugcl\nX2bMGA8MADYAz6A1JBuAYcTFxeW73JEjR2I0HgXGo1UHdcXfvwqBgYEFjllRFOtQSb4MGDt2LKtW\nLad8+Uy0ZGzSP1mPq6sbAHPnzqVu3QgaN27Brl277qvcwMBA9uyJpXLldbi6jqBpUzMnTuwvlGtQ\nFCV/VJ18GZKYmEhQUG1u3rQHvIE/2LQpirVr1/Pee58Ck4GLGAyf8Ouvm2nSpEnxBqwoZZC1c6dK\n8mVMeno68+fP58033ycx8Qpas4wRWI3WkwhgJC1aHGH79i3FFqeilFXWzp2quqaMsbe356OPVpKY\nGA7EAQcBD+Bri70CSEpKK5b4FEWxrvtK8iaTifDwcLp27QrA9evXad++PTVq1KBDhw7Ex8cXapCK\ndZ06dRp4G/AEagIvoY2I3YPWA2cWw4c/W3wBKopiNfeV5OfNm0edOnUwGAwAzJw5k/bt23P8+HHa\ntm3LzJkzCzVIxbrs7e2BIxZbDuDuboOtbWccHIYydeoYnnvuueIKT1EUK7pnkr9w4QJr165lyJAh\n2fVEUVFRDBw4EICBAweyevXqwo1Ssaq5c99AG/k6COiAjc0aDh/eR0ZGHKmpl3n99deLN0BFUazm\nnoOhxowZw7vvvktiYmL2titXruDn5weAn58fV65cue2xlskiMjKSyMjIgkWrWMWwYcMICQnh448/\nxtW1ItOmLVV92xWlmMTGxhIbG1to5d+1d82aNWtYt24dCxcuJDY2ljlz5hAdHY2Xlxc3btzI3s/b\n25vr16/nLFj1rlEURcmzIp3WYMeOHURFRbF27VpSU1NJTEykf//++Pn5cfnyZfz9/bl06RK+vr5W\nC0h58CQmJrJhwwa8vb2JjIwscZO0KUpZdt/95Lds2cLs2bOJjo5m/PjxlCtXjgkTJjBz5kzi4+Nz\nNb6qN/nSYdeuXbRo0RGTyR1IJCgogNOnj2Bra8vff//NW2+9RXJyMsOHD6dhw4bFHa6ilHjF2k8+\nq3fNxIkT2bhxIzVq1ODnn39m4sSJVgtIebB06tQHk+lF4BzwFxcuuDB06FDOnj1LhQo1+eCD/Xz6\naRwPPdSKVatWFXe4iqL8DzXiVbkro9ETkd1ADX3LLBo0+BY3N2d++aUS8Lm+fTFubm+TmHiueAJV\nlFJCjXhVrCo9PT1Hz6n/5ebmjjZQCiAV+I7Q0Fr89dcNoKnFno1ISUkpvEAVRckXleTLKLPZTIsW\nbXFwcMHDw5vy5avy999/59rvxx9XYjS+A4QAQfj5XefTTz+lQ4fmwPvAZSAFmEa1apWL9BoURbk3\nVV1TRr3wwgssWvQTsB3wAp4iJOQUJ04cyLXv9evXWbNmDd7e3nTu3Bmj0YjZbKZly7b8+ut2QPD1\nrcKxYzvx8fEp4itRlNJFzUKpWEX16uGcPPksMErfcgAbm/ZkZl7NUzmZmZmkp6fj7Oxs9RgVpSxS\ndfKKVVSoUA74Bcj6x7QbJyenPJdja2tbKAm+oIuMZ5k3bx79+vVj/vz5VilPUUoaleTLqBUrlmJn\ntwFoBnQFxvLZZ+8Xc1Swd+9eXFwCsLOzx2h04ZVXXsl3WY0bR/Lii+/wf/9nx+jRM2jevK0VI1WU\nkkFV15RhV69e5Z133uHWrVsMGzaMsLCwIj3/119/zfLly/Hy8mL27Nn4+vri5ORHauoQYCqwD+hA\ndPT/8dhjj+Wp7O3bt9Oq1aPAGaAc2tz5wezeHUOjRo2sfCWKYj2qukaxGh8fH959910WL15MWFgY\nZrOZjh27YmPjhY2NFz16/AuA6OhoHB39MBgccXLy56effirwuV977TWeeGIwa9ZUYfnyKwQF1eLk\nyZOkpl4F3gTs0b5ldOa7777Lc/knTpwAAtESPEB5wI/jx48XOHZFKVGkkBRi0aWSyWSSzp0fFzs7\nX3Fw8JeJEycWeQx9+vQTCBE4ILBXoJI8/fQAMRhcBD4UiBOYJ0ajm9y4cUOWL18uAQG1pFy5EBkz\nZmyezmVj4yWwSUAEzAJdpGfPngIOAof17RkCtWXKlCl5vpbz58/rcX8jYBL4UgwGF7l06VKey1KU\nomTt3KmS/AOia9eeAtUFtgmsEfCUWbNmFWkMrq6VBKL0BCsCK8XZ2VeghsU2EagsY8eOFXAWmCuw\nQsBPBg8eet/n0o49r5d3RMBHwEbARcBe4BmB+uLlVUnS0tLydT1Lly4Vo9FdwCBGo4csX748X+Uo\nSlFSSb6Usrf3E4i1SKTzJDi4QfbnJpNJevZ8Qry8qkrlyvVky5YtVo/Bx6eawAKLGGaKj09FAU+B\nm/q2eAFXCQ6uKfCGxb6bxN7e777PVaFCLYHe+rcDX4GxArcEtgi4SMuWLWXcuHH5TvCWUlJSClyG\nohQVa+dOVSf/gLCxsQEs5+S/hpOTXfZvzZo9wqpVR7hx4x3Onu1FZOSjHD582KoxaCtGjQfGAWOA\nN1iyZCFVq1YCGgETgAhq166Fs7MrOWeqtslTY9HevTH4+x9Gqze/CrwDuACtga5UrVqVWbNm6UsV\nFoyjo2OBy1CUEsuqjwwLhVh0qfTmm28KuAm8K/CKgJOsW7cu+3NwFDhr8eb8hDzxxBNWj+PHH3+U\nli0fltat28jmzZtFRPsWMXbsWGnbtq2MHz9eTCaTrFixQq9a+VjgO4EK0q9f//s6x9tvvy3gIeCk\nX7ODXmUjApkC9WT8+PFWvzZFKQmsnTtVF8oHyIIFC1i4cAn29rbMmjWNjh07Zn9mMDgCp4AK+pan\n6NMnk6+++qo4QgXgo48+YvLkd0lPN/Hkkx35+OMP73nMmTNnCA6uD4wGXgA2oa036ww8CezB3f0K\nV66cVG/gSpmkpjUoo8LCmnPoUCpa98KjwDT27dtW4hbqmDx5MjNmzAcSAIO+tTmQCdzCxuYMt25d\nL5QEf+HCBfr2HcjFi3G0adOYTz75WK1ypTxwinT5P+XBsXfvVrp16822bSNxc3Pks89WlZgE//vv\nvzN//nwcHByoUqUKkIZWD18eyAAuAE8BUzGZXLLr4TMzM7G1tc4/0evXr1O1aigZGR2A3pw+PZ/9\n+1tx4MAvVilfUR5U6k1esbrU1FQ6derO7t3HsLMzkpj4N9AGSMZg2I/BkInZ7AY8B2wATgJ/A7EY\nDD157bWxvPnmbESScXQsT2xsFE2aNClQTK+88gpvv70R2I32DeIq4M/Nm/G4uroWqGxFsSY14rUM\nO3jwIDVrNqRcuer06PEvq03idb/MZjO9e/fFwcEfR8dAJkyYkCO2hg2bUaVKA4KCqrBlSzwpKZ+R\nmDgW7Z/Z68AERASzOQhIx2D4AIPhAFp9fBegO0OGPMkbb8xGZD2QRmrqCFq3ztuUBreTlJQEePNP\nFZE7YCA1NbXAZSvKg0y9yZcQp0+fJiSkAWbzc2jdGd+hXj17jhzZVWQxPPHEU3z99a/AEuAW0J8Z\nM8bTs2dPateOQOQZoA7wFmAD3ABMgAfQBNgBvIbW4HoLaMy//92BKlWqcP78eXr37s2yZcv46KO/\ngaz1YgWw58qVi/j6+uY79mPHjlG/fmNE3kZrA3gHb+89XLt2Jt9lKkphsHrutGpfHQuFWHSZ9Pzz\nzwt0sOhCGSdgY5XBQvfLzs5PYINFDAulUqV60qtXL4E+FtuP6CNa9wucEWgmEKh3A71isd8kadOm\nTY5zTJ8+XbSpFdL0fX4TsJeMjIwCxx8dHS0eHpXF1ra8hISEqSkOlAeStXOnqq4pIbSqGcuBQXZ3\n2rVQTJ8+nYyMdLS38yw3sLe31as8vC22ewJmtHgroy0TeAutnT8caAGcAFYRHh6e4zwTJkygfHmT\nvt8goBnPPjvQKg2wjz32GPHxZ8jI+JsTJw7g7+9f4DIV5UGnqmtKiN9//526dRshMgmtumY6wcHx\nHDy4nTZtuvDbb3/i4eHC119/SuvWra1+fltbb0ymHsA3aPXrN4F3WL36/4iLi2Po0NHAYqAG8DJw\nHK3/+9vAUrR+8d2APsBy4CeqV6/GH3/sy9WNMTMzk1dffZXTp0/z2GOP8fTTT1v9ehTlQaX6yZdh\nsbGx9O07jMTEZMLDa7Fhww+EhIRz6VIVtCkHdmAwzOS//z1A9erVC3Su1NRUfv75Z7y8vGjWrBkG\ngwta4v4B+AS4Rt26Hhw9eoSrV69SvrwfEIDWJbIWcB6tLr418CFad8lzaI2wJsCfH39cRufOnQsU\np6KUNqp3TRkWGRnJpUv/JSnpPNu3byQ9PZ1Ll04Bq4FHgCmINGPBggV3LCMzM5OPP/6Y6dOn63Ou\n53b48GHc3QPp0uVZmjfvSMWKdQgICEJ7Q+8H/Ae4xYgRwwFtXvpmzSLRqpBGApk4OMTTvn15Onb8\nLy+9NIp/erVk+d/fczKbzfTp0w87O1/s7f0YMuS5e94fRVFuw6o1/BYKsWhFd/PmTX163hsWjZkt\nZOzY28/tnpaWJj4+wQJBAk0FnGXlypW59itfvprAy6LN854kECE9e/YUX98QATsxGJxl6NBhuY6b\nOHGiVK0aoje6lhdwkP79B0lKSoo4OpYX6C/aVMb/EhcX/7s2pg4YMEigksBWgc0CfvLyy+Pyf7MU\npYSwdu5USb6Eq1mzoUBDgeUCz4uNjccde40MGTJE4CGLnitLxd6+vIiI7N69WypWrCMuLhX1ycOO\nWDw43pdatcLvGUtGRobFQh0icFzATaKiouTs2bNSt24jcXOrLA0aNL1nzxYXl0oCP+jlmARGirOz\nj5w8eTLvN0lRShBr505VXVPCHT26i8cfr0r58tOoV28fx47tumOvEa16phP/9NLpQHr6Lc6dO0fT\npm05f747SUkfo/WCWa3vkw58T506Ve8Zy6lTp/S6xN76lupACzZt2kSlSpU4enQ3iYlnOHTo13v2\nbLG3t0EblWoGQoEvSU4OIiSkAZ9//vk9Y1EURWfVR4aFQixayafJkycLVNb72G8WqC92di4yevRo\ngZYWb+6b9WmEawr4ibd3ZUlKSrpn+WlpaXpf+F/1cq4K+MjSpUvzHOuiRYv0GFqJtmLWLb3ML8XW\n1is/l68oJYK1c+ddS0tJSZHGjRtLaGio1K5dO3vd0V27dkmjRo0kLCxMIiIiZPfu3YUeqFJwJpNJ\nGjd+WK/HdxboJ9BSjEZHvY4+K8nfFDDKnDlz5Msvv8zTQKSpU6fqZTcV8JRGjR7Od7wrVqwQNzcP\ngZH/E5ttvstUlAddkSZ5Ecl+g8vIyJAmTZrItm3bJDIyUtavXy8iImvXrpXIyMhCD1TJO5PJJCaT\nKdd2O7vyFvXmZoGOAq56Mv1aoLlUqVL3rmXfuHFDIiM7SIUKdeTRR7vleNPfs2ePTJ8+XVavXl3g\na9AWGKkg8LdkLYvo4FD+tvFER0fLH3/8UeBzKkpxsnbuvGedvLOzMwDp6emYTCa8vLzw9/cnISEB\ngPj4eCpUqHC3IpQilpqaSs2aDbGxccDGxpGIiFacOHGC4OD6ODgEkJGRCoTpexuA1tSpU5WaNX/F\n3X08Vapc5d//HoLZbL5t+enp6VSsWJfYWDsuXhzLunUJBAfXz94/IiKCyZMn0717dwDmzZtH7doN\nadiwGbGxsXm6lokTJ9K8eS2gEuCP0fgq0dFf5Njnq6++wts7iK5dh1GrVhgdO3bP0zkUpVS711PA\nZDJJaGiouLq6yrhxWhe2M2fOSFBQkFSsWFEqVKgg586du+3TaOrUqdk/MTExVn06KXfWunVHfb6Y\nqwJ/CdQVg8FZ4Dm9S2KAwBN698gTAv7y5ptvyvz58/WqljYCFcXPL+S2VTXLly/Xu2Fm6m/XKQLu\nsm3btlz7Tpo0Se+tM1tgnIBzvv4t/PHHH7Jhw4bbtg0Yje4CX+ixXBTwkf/85z95PoeiFIeYmJgc\nufI+0nKe3Hdp8fHx0qRJE4mJiZG2bdvKqlWrRETk66+/lnbt2uUuWFXXFBsnpyCBnyzqsVcKeOtV\nMyJwQcBTr5t3kMcf7y0iIkajh0C0vk+qQL3b9rn/6KOPBGpYlG8SKJ9dhWfJ3t5P4EeLfV+Whg2b\nWu1aExISBIwW1yYCT8qAAQOsdg5FKUrWzp333YXSw8ODLl26sHfvXnbv3k2PHj0A6N27N7t37y6U\nbxlK/ri5OQEHLbYcBFKBNUAi4Ac4AsLkyS/z/fffAGA2JwGR+jEOQGtOnjyZq/w+ffpga3sFbSqF\nX4HhODoKbdq0ybWvVoVTzmKLL8nJ6QW5vBzc3d0xGJyA9fqWG8BWIiIirHYORSnJ7prkr169Snx8\nPAApKSls3LiRsLAwQkJC2LJlCwA///wzNWrUKPxIlfv2+efzgTfQ+qt3Az5Amy/mOSAQaIz2V7+V\nt956H0dHPwICamJv7wXMRZvD/TzwLe3atctVvqenJ3v2xOLvvxo7u8epVOkXjh7dmb1sn6XWrSOA\nZ4GdQDQwnRdeGGTV6/3gg5n6tYYBwYSHBzNq1Kh8l3fu3DlWrVrFvn37CA6uh9GotW2MHDnSWiEr\nStG522v+4cOHJTw8XEJDQ6V+/foya9YsEdF6T2R1rWzatKns37+/0L9yKHlz4MAB6d+/v7Rq1UrA\nS+CsXpXxf3r/8zj991YCfQXeFnAQGxtPvaeNnXTu/Hh2eZcuXZLQ0Gbi4REs4eEt5MqVK7c9748/\n/ij16jWSGjXCZeHChZKRkSFt23YWW9vy4uDgL1OmTCmU6z1+/LjMnTtX1q1bV6ByJk6cJOAk2pQK\nLgJuAt0EJgh4yFNPPW2liBXl9qydO9VgqFJOm8qgl0V9tVnAVuCSQLyAj15nL3rfdifRBjTZycSJ\nk0REG+Tk7OynN9auEuh927lnoqOj9YbbVwXeFXCTadOm3TW+ffv2iY9PVTEavcTLq4rs2LGj0O7F\nvZw8eVK//j2izQeEQBeLe/eLgFuxxaeUDSrJK3mijRz1F7gu/4xmdRToLOAn2lw2WT1knPU3fRHY\nLeAi27dvl2+++UbvkWPSP8sU8JWoqKgc56pRI1zgDYuk+LU4O1e4Y2xJSUlia+ulvyUfEXhDbGzc\n5dq1a4V9W3JISEiQzZs3y7x580RblSrrfiAw1uJ6Lgk4FmlsStlj7dyp5q4p5YYPH07DhiFAMPAQ\n0JVBg/oycmRVKlVyQ2uQ/QYYjjanzZP6kY2Ahvz0009646nlPxUDYMjVjz41NYOcjazemEy372sP\n8NNPP5GZ6YS2sEg94DVMJl9++OEHzGbzHfvpW9OSJUvw9Aygbdsn+fe/x6PNef87WsN0MNrc+THA\nBWA4AQGVCj0mRbEqqz4yLBRi0Uo+REdHy+zZs+Xo0aMioo0QDQkJ0+vf3cXNrZyAvWhrqor+5u8t\nX3755f9MFbxGoJ84OfnlWl/2nXfe0btmrhHYIlBNevToc8eYYmJiROtDn6yfM03AR3x9q+pVSvbS\nsmXb247atYaUlBR91szV+vl/1++HvUADAUfx8vIWcBdwloCAmndsi1AUa7F27lRJvoyqVi1UtOkM\nTgpsFHCT1q0j9STXUaC8hIe3yN7/7NmzUrt2hLi6VpK6dRvLxYsXb1vuuHHjxMEhQOzsfKV79153\nTdAmk0kCA2sKNBZ4X6Cl2Nh4iDYY67pojcUhMnjwUKtfv4jWHqAlcLH4aSsDBgyQDz74QPbs2VMo\n51WUu7F27lTL/5VRBoMrcAxtoW2AiURG7mbcuJfZuHEjDRo0YODAgcyePZtjx47Rvn37QllrNT09\nnWeeeYYDB/6gbt1qREdvIz39W6Clvsd/qFDhPS5cOGb1c9+6dQs3Nx9gOxABxAG1+OqrxfTp08fq\n51OU+2H13GnVR4aFQixasQKj0VO0KQ6y3mDbi719ebGx8RZv72DZsWOH/rZfSbQulp7Sp0+/Qo/L\n07OKwAKLuF6Q0NAmdz3myJEjsnnz5lzVR/dj/PiJ8s+smR7SokXu0duKUpSsnTvVm3wZNWbMWObO\nXQKMRmtoXA8MAwYAqzAY3kNrlz8HuAN/ArWIi/sLHx+fQotr1apV9OrVH20QVwJG43YOH/6VunXr\n5trXbDZTt24T/vjjGOCMnZ2ZnTs30bBhwzydc8+ePWzYsIHQ0FAee+wxq1yHouSXtXOnSvJl2OLF\ni1m+fCVpacns3/8X8Bf/LLBdHW3Ua3lgH+ALeLJ790YaNWpUqHHt2rWLDz74AEdHR6ZMmUJwcPBt\n9xs1ahQLFmxCG03rDkzG03MlN26cyfe5z549S9OmHbhy5RL29k4sWvQ2zz77bL7LU5S8Uklesbqt\nW7fy8MNdgcuAE9qSfxXRpkP4Gq374CCMxvGkpFy97fQFxSEiohn79nUFXtG3nMZgCMVsTsx3mR4e\nFUlMbA9MAXYBQ9i582eaNGlS8IAV5T5YO3eqfvIKLVu2JCDAH2iDltg7oCX7Xmj9509iazuJH35Y\nmSvBf/vttwwaNIiZM2cWSb92S7Vrh6BNupY14dlanJxc811efHw8iYmXgI+BqkBfoD1Lly4tYKSK\nUnxsizsApXgdO3aMlJQU/vzzEAMHPsPq1W+Snu6MVk9vC6wjKMiP8+d/y3Xs4MHPsWTJV2iLg3/E\n4sXLOX36CEZj0bw7fPLJJ6xbV4tr14IBXwyGk3zzzVf5Lk9bIMeA9o0mCG2itnN4eta2SryKUhxU\ndU0ZlZp7PsdvAAAgAElEQVSaSvXq4Vy4cBawxcXFhT/+2IPZbCY4uCZmsxNgxmDI5ODBHTRo0CDH\n8cnJybi4eAKHgVpAClCD1157ljfeeKPIriMzM5MvvviCa9eu0bt3bypVuvuIVLPZTHx8PN7e3rf9\nvGPHrmzYcADtG8x2HB33ERf3J66u+f+GoCh5oerkFavo1q0n0dGXgU1oc8cPolq1w4SG1mLVqm3A\nZOB3DIalHDu2m9q1c77Nnjhxgho1QoFki62dsLXdTkbGraK6jDwZOXI0Cxd+BJiwt/fk559/oEWL\nFrn2e+2111i3bhMVK/rz6aef3vGBoCiFQSV5xSoqVKjDX3+9jDbXO8AO7O17kpGRhMgOoL6+/Ql6\n9TLx7bff5jjebDZja+uJyDS0bpi7gHZACteuxeHt7Y3ZbCYzM/OBaKjVumY+gzbwqT7wNnZ275Ge\nfrV4A1OU/6EaXhWrCA72B9YCWY2l6/DyckfEBHhZ7OlNWlparuONRiNPPvkY8Cpgh9ZoOwQw4urq\nyogRL2Bj44KDgyOuroEcO2b9Eat5ERUVBXQBGqDVu08kI+MG7u4BGAwOGI1ujBo1mqNHj9K2bTsa\nN27Bxx9/XKwxK4pVWHVolYVCLFqxgitXroiTk69ANYFQMRrdZPfu3VKrVoRAC4FfBZYJON9xIY6k\npCRxdvYXbeGRKQKB8uij3fWFvj0EDgqkC7wobm5BRXyFOb3++usC1fVJ0ERgr2hTLpfX58nZJdoi\nIc4CgwVeF3CXyZMnF2vcStlj7dypqmvKsOTkZJYsWUJKSgr9+/fH39+f5ORkIiM7c/Dg79jb2zN3\n7lSGDBly2+P379/P6tWr2bp1K5mZZjp16sCUKVPo0aMHq1f7Ah9lnQlwRySzqC4tl8zMTOzsfAAf\ntGUCfwIeAY6gjeYFbR6fjmhdKAF+ws6uP+npfxd1uEoZZu3cqbpQlmHOzs651i11dnZm9+7Yex47\nYcIkZs36AKgL/Jc2bVoyZcoUAIKCgtAW+DYBNsABfbHtwpOamsrRo0epUaMG7u7uuT63tbWlffuW\nbNy4H62heREwB8jqjSPALYvfAYIwmTIKNW5FKXRW/V5goRCLVorZjRs3BBxEWyYva8UkD1m9erWI\naNU4bm6B+pzsTwu4Fmq1x/Lly/V54T0E7GX06Bdvu19aWprUq9dYwE7ATnx9K+vVMyP06Y2d9TI2\nChwTaC61aj0kIiIXL16UIUOGSN++fWXbtm2Fdi2KYu3cqZK8kmc7d+4UbXEQy3nYW+dYpDslJUXG\njRsnTz/9dK5lAq0pLS1NT/Bf6XEcEnCRmJiYOx5jMpmy57n/8ssvpVu3buLo6CpQQ+AR0RY+dxdw\nk2+++Ub+/PNPfZ77dgL9BJxl2bJlBYp7xYoV4uQUIEajpwQF1ZazZ88WqDyl9FBJXilW0dHR0rx5\nS9EWvP5RLFdU2rx58z2Pv3Tpkrz66qsyZcoUuXTpUoHjuf3CH21k0qRJeSpHW8TbRrQ1XjsLzBWD\nwVUSEhKkVas2AgMsyl8qzs6B+Y75iy++0M/VWmCTQH/x8KiY7/IeJCtWrBBPzyri4BAgbdo8mq/p\nn8s6leSVYrNs2TK9SuNlgYf1RO8r4CBDhgy75/FHjhwRGxt30VaCaiI2Nu5y5MiRAsWUkJCgVx0d\n1BPwNYFysnLlyjyXtWTJEv2N3Sh2duWyv4FUrx4mMNciye8XG5ty+Yo3Ojpav4c9RFuBy01gv4Bt\nkS9gbm0bNmzQr+1D0RaMbygNGzYv7rBKHJXklWLj7R0s8JFFsntF/Pwqy/nz5+/reG0Rkn9bHD9G\nqlYNLXBco0e/qHd/bCNQTiIiWheovP9dsnDs2LGiLZ7yp0CiQBepVSsiX2Vr9/A9i3swSiBcwFZS\nUlIKFHdx69Spk96+kXVtpwRcijusEsfauVMNhlLuW2pqBtoUxFlqIeKg96a5t7i4BLRBU1ki9W0F\nM2/e+8TErGHSpKasXDmfPXu2FKi8rAnWDh8+zMaNG3nrrbfo0KEB2hw9XlSocIpffvkJ0LqRdu/e\nnc6dO/Pzzz/fs+ykpFTAclGThsBZWrdug6OjY4HiLm7ayOYkiy3JGAwqxRQ7qz4yLBRi0Uox6d69\nt0BNvXFzt0CQjBgx8r6Pb9Wqnf62nSSQLPCING/ethAjzh+TySS1a0fo1VHlxdbWU3bu3Ckmk0ky\nMjKy99uyZYsYDM4CzwgMF3CWL7/88q5lN2rUWiBSIF7gL4FaUrt2vcK+pCJx4MAB/X5MFFgiUEm6\ndHm8uMMqcaydO1WSV+6byWSSNm06idHoIUajp/Tu/USejr9586YEBtYUrQujvXh7V5aEhIRCijbv\nRo0aLQEBtcXTs7z+MLshYBaYKu7uuRtGQ0LCRBvpm1U9sUC8vave9Rw3b96UKlXq6Q2vdtKoUetc\n1UMl2fbt26VWrXAJCKidpxcA5R/Wzp1qxKtSpH799VdatOiIiBuQTGCgH6dPHy72Scx69PgXq1fv\nBN4EpqLNw/Oa/uk5oC4iN3Mc4+dXk7//ngL017dsxMnpWZKTz9/zfJmZmRiNxiKbe18pOdQEZUqJ\n1rnzk4i8BFwE/uKvv9wYOnRocYfFDz9sQFtlahDQHogCsiZmW3PbFae6d2+D9kD4DW1qhPG0ahV2\nX+eztbVVCV4pEnf9V5aamkqTJk0ICwujTp06TJo0Kfuz+fPnU7t2berVq8eECRMKPVCldEhISEBb\nVg+0JQb7cOBA7lWnip4ZcNb/vBhtEfPKQCgGwwS+/vqTXEd8+OEiOnash8HQBGhARIQbP/74fZFF\nrCj3465z1zg6OhITE4OzszOZmZm0bNmS7du3k5GRQVRUFIcPH8bOzo64uLiiilcp4dzcPEhM/Bpt\noexU4FvCwop/eb2IiIbs2dMHbT6bP4FExo8fTWBgIL169bptDyKj0cj69VG3Le/333+nVasuXLv2\nN/b2znz44TsMGjSoUK9BUW7rfivvk5KSJCIiQo4ePSp9+vS55+jGPBStlCHbt2/XB0RVFfAWf//q\nD8SoyIyMDGnX7jFxdAwUD4/KsnTp0gKV5+Tkp/eBPyewUsBJ9u3bZ6VoldLM2rnznrNQms1mGjZs\nyKlTpxg+fDh169bl+PHjbN26lVdeeQVHR0dmz55NRERErmNff/317D9HRkYSGRlpvaeTUiK1aNGC\nq1fPsmbNGry9venUqdMDUTdta2vLxo3RVinr3LlzpKTcAOai1Yj2BZayYsUKGjZsePeDlTInNjaW\n2NjYQiv/vnvXJCQk0LFjR2bOnMmoUaN45JFHmDdvHnv27OGJJ57gzz//zLG/6l2jlFW3bt3Czc0L\nOAsEok25XI/p059m8uTJxRuc8sArtt41Hh4edOnShb179xIUFETPnj0BaNSoEUajkWvXrlktKEUp\nyVxdXWnTph3QBHgdeARX10Reeuml4g1MKZPumuSvXr1KfHw8ACkpKWzcuJHw8HAef/zx7CHcx48f\nJz09nXLlyhV+tIpSQvz88zqmTh1MixY/069fEJcu/bdETFuQmppKgwZNMRjcMBo9eOqpAcUdklJA\nd62uOXLkCAMHDsRsNmM2m+nfvz/jxo0jIyODZ599loMHD2Jvb8+cOXNy1ber6hpFKXmaNm3Drl2p\nwErgOtCFKVOGMm3atGKOrOywdu5UI16VB97evXuZOXMmBoOBSZMm3bPx0mw2M3z4C3z33SZcXBxY\nvHgWnTt3LqJoSzY7O18yM6PRqpoAFlC16qecOnWwOMMqU9SIV6VM+emnn2jU6GG++86Rb7+1JyKi\n1T1ne+zRow8ff7yWa9fe4Ny5p+jS5V9s3bq1iCIu2bTpJSw7URzHy8uluMJRrEC9ySsPtAoVavHX\nXwOBrNHW06hY8UvOnTt2x2NsbDwxm3/mnyl9RxEZ+RsxMZsLJUaz2cypU6eoXLlysc/BU1CLFi3i\nhRfGAcOAqxgMq9i7d6vq+lmE1Ju8UqbcvJkG+AC1AS9gIVevXr3rMdr/H3YWW+wxmwvnhePzzz/H\n1tadGjVCcXBwL/F11yNGjGD16pW0a3eUrl3jOXx4p0rwJZ1Vh1ZZKMSilTKkS5eeAh4CgwR+01em\ncpajR4/e8ZhHHnlUtEW5owUWCDjLunXrrB5bQkKCvoj4N/pUw78IOMuBAwdEROTixYtSsWJdMRjc\nxcHBVz788EOrx6CUPtbOnepNXnngzJ8/n+bNW9G9e3deeeUlIAX4BO1t/jmgKcuWLbvj8Rs3rqFX\nr4a4uLyAj8/7rFjxMZ06dSI1NZV58+bxxhtvcOrUqQLHuWfPHkRcgN76luZAXdavXw9A/fotOH++\nHiJ7SUubz/PPjyU2NpbTp0+zefNmbt26VeAYFOWerPrIsFCIRSul2NChwwS8BF4T6CVGo5uArcDf\n+tuySaCuTJs2LU/lJiQkiKtrgEA1gWZiMLhIdHR0gWI9f/68aIuIn9BjuyrgIVFRUXL48GEBo74C\nVtaiIn0lICBIP8ZXDAbX7MXCFSWLtXOnanhVHihGoxsiMUDWXEid8fI6zI0bTsDzQAyOjnuIizuF\nq2vuOd7vpEePnqxenQj8BNgAC3BxmcmtWxcKFO9TTz3DypXfAy2BPTRuXJddu2KoUaMhJ04cQ5tr\nvhogQCtgL3AKqAC8hdH4DhkZ8Q/E/D3Kg0E1vCqlmkgG2jzuWaphNqcAl9Am/NqKm5szzs7Otz3+\nTk6ePA90REvwAO1ISUm6yxH354svlhIVtYLRo0NYuvRddu2KAbIWLW+IltjfBnoCh4DuQDm0qqfp\nmM2ZlCtX5Z6NyYqSXyrJKw+UChWCgaHAaWA9sFRfaORPtIU84oiLS2fp0qV5KrdVq0bAf4AbaAuE\nLMDHp7xVYu7atSvz5s1j4MCB2dsaNqwJ2KOtNPU9sB1///LATqAHWo+ha0AC8fERtGnzmFViUZT/\npZK88kDZv38LlSufwmBogK3tUwwb9hTgBmQlZAegEpcuXcpTuQsWLKB+fU/AH/DAyekbtm61ztTC\ntxMd/S1BQXHAu8Ah/Pw8+P33/dSsWR7YDQxHW4nKDniBU6cKVm1U1m3cuJH69RtTo0Y48+fPL+5w\nHixWreG3UIhFK2VIWlqa2Np6CrwpEKcvwOEsv/32myxbtkxef/11OXTo0H2Xd/78eTl06JCYTKZ8\nxzRixEhxdw+WcuWqyaJFi+6678WLF+X8+fM5tgUH1xYYIGDWG2QnSIUKtfMVy/vvvy9BQXWkcuV6\nBV7opKRav369gJPAZIE5Ah4yZcqU4g4r36ydO1WSVx54O3bsEBeXQAEHsbMrJ5999pkEBzcQ8BNo\nIeAsc+fOLZJYBg0aLBCg943/RMAlz8n1zJkzYmfnLVBHoKEYje75WjVqxowZAu76WID3BFxkyZIl\neS6npKtXr5HAFIteTKvF0TGguMPKN5XklTLvzTff1JcPvKW/4QcKeMvQocMK/dwODv4CGywSyjtS\no0Z4nstJSEiQd955R6ZPny6XLl3KVyzu7lUEvrCIZV6+vxGUZCEhYfpDLus+bBV7e7/iDivfrJ07\nVZ28UuIcO3YMaA18BMwG3geW8cknUQwZ8lwRRGC2+HMm+en96O7uzvjx45k8eTL+/v75isJkMqPV\n62dxJjPTfKfdrW79+vX4+lbH2TmIFi3akZycXGTntjRy5DPAG0AUsB0YQvv2zYollgeSVR8ZFgqx\naKWM++ijjwTKCdQSWGjxBrdGnJyCCvXcw4YNF/AVWJE9ZcLKlSsL9Zx3MmLESL3KKlrgWwFPmT59\nepGc+8CBAwLOArMFNgm0lJCQsCI59+1MmTJFHB0DxM7OVzp3frxAbS7Fzdq5UyV5pUTq2rWXgJvA\nuxZJ/htxcalY6OceO/Zl8fYOET+/msVeBz58+Ahxdg4SF5eKMnny5CI774ABAwR6Wdz7awK2JTq5\nPiisnTvViFelxFqwYAGjRo0DKgHpwEUmTx7P9OnTizmy0m/w4MEsWXIZ+FHfcgmojMmUqkbvFpAa\n8aoouieffBIbGwe0KRDGAVVZv35LMUdVtK5evUr79p2oWjWU/v0HkJmZWSTnfeWVVzAatwJjgRVA\nWyIimqoE/wBSb/JKiXH58mViYmKoXr06ERERPP744/zwQwyQBLgDs4DnSUm5lWvR7OvXrzN58mRu\n3LjBoEGD6NixYzFcgXUlJyfj41OVlJTGaFM2fEpICJw4caBIzn/w4EH69h3MtWu3aNu2MV98sUwl\neSuweu60auWPhUIsWimDli1bJgaDs0CwgLM0adJGwEXgPwJJAkv1341y48aNHMdeuXJF7O29BVrq\ng5CcZc6cOTn2MZlMsnnzZomKipKUlJSivLR8mzNnjmjz5pv0evEEAQc5c+ZMcYemFIC1c6d67Col\nwqBBoxBZijaHzWl27ToGOALPonUjHAgE4uLijaenJ1evXqVy5boYDC74+QWRnt4M2AosA/6PCRNm\nZJednJyMv38Ibdv2olu3oXh4BPHf//63qC8xz5KSkgBP/ql1dQFs9bl+Cu6ll14iJCSMFi0iOXHi\nhFXKVIqeSvLKA+/WrVuYzbf4Z3EOX6AdkIA24RhAPHCZFSs+AeChhx7m3LkQ4L9oMz4+BBj0fRuQ\nmZnKnj17AHjsse7ExaWiTRy2kfT0vrRp053ExMT7jvGrr76iR48ePPfcc3k6riAGDhyIwfAbWjXV\nfuA5XFzcqFevXp7KyczMJD4+Pse2Tp268d5733Dq1GB27KhK7doRnDt3zmqxK0XIqt8LLBRi0UoZ\npC0e8r38sziHvwQGVhGoJDBCoLLUq9c0e3+tD/d5ff9ZAuVFWz4wSaCv/ruL7Nq1S6/meUSgq37c\nXNEWLrGVsLDm2d0C4+LipG3bjhIcXF/69XtaMjIyRETk5ZfH6d05nxdoLk5OvpKQkHDHa7l27Zo8\n/HB7CQioLR06dJabN2/m2mfTpk2ycOFCOXny5F3vy+bNm8XTs7LY2vpIxYp181xV88QTTwnYCdiI\ns7O/HD16VEwmk2gLmxwXeFzAU8BdKlQIVl0ki4C1c6dK8kqJ8Mknn+gJuKaAqzRuHCkiItOmTZNu\n3brJm2++mSMBGY2eAlss+nE7CzgK2OhTIiwU8JGAgGoCL1jsN0vAX6/rvipQSwYPHiJJSUni5OSn\nPwgWCYRLSEioiIgYDK6ire8qok061lKGDBly2+tIS0sTN7dAgS4CSwQekXLlquSIPSKitWhz0tQT\ncJb58+cXyj2dP3++PqjsuECmwL/Fw6OinuRtBZ7S20D2CewXqCpPPfVMocSi/EMleaXMOn/+vPzn\nP/+Rbdu23XNf7e3aXWCcQHf9TfsZgQz9p5uAh7i5VRRYZpHkYwS8BQ7ov8+XatVC5f33379tI6e2\n3SjwnUUZI6Rr1663jWvlypWizbWTqe+bKuAuo0aNkkWLFumNqX76A0YE1onB4FIob9CdOnUSeFFy\nDmiyFxGRihXr6N92vrH4/Dvx8Ai2ehxKTtbOnbbFWVWkKHkRFBTEs88+e1/7vvvuLOrUqc2KFV/g\n5eXJmDHraNnyUbSFSDIBMzY2Btq3b8aqVbOARwEnYDrayk1haEv2baFixfL6otse5GzktGPMmOnA\nI2gNv2vQGoP/jzVrICysOdu3b8ixTGFqaqq+T1Y5JwEz8+dvBNZiNF5FW0qwnP55R0RSuX79Oj4+\nPnm+Z3cTFBQE/AqY0FbM2oPRqM2Fc/jwL/j4hGAyWdbDn8XRUaWMEseqjwwLhVi0ouTLpUuXpFq1\n2uLkVF6qVw+XP//8U0wmk4SFNderJ2zEx6eKXq3TViBc7O3LyaVLl+Ts2bN6tczbAnv1OnxPizfu\n3/WqIFeBKIHDAq2lTp1G2ec/e/aseHhU1PcZI7BdtGmLR+nVPGaBp/XPL+rlfiVGo5uIiCQlJcmk\nSZNk8ODBEhMTU+D7kZSUJK6ugXq1UC8BZ5k1a1b258uWLRNtnvYx+o+TBARUKfB5lbuzdu5USV5R\nRKsrz+of/9tvv8mYMWNkypQpOfrcx8TEiKdnFbG19RF39/ICzS2qMkS0BszxFr+fFIPBNft4f/8a\nAv31h0SIaI275QR+sjjmK726yFEgSMBZgoKqyc2bN8XVNUCgQXZCnjNnjqSlpcmTT/aVWrXCpVev\n3tnXEBMTIzVqhIunZ4DY2ZUXe3s/adz4YUlKSsqOx2Qyyfnz52Xy5MkyePBg2bx5c457MnXqVIFq\noo0viNCrbmzlypUrhflXUeapJK8oD4CdO3eK1itnt56cv9Xr5vtbJOztYjR6Zh+jfRM4bfH5VHFy\n8hHorbcTpAp0EK2x86jAKoE9Ai4ycOBAPdlmtQnMErATd/dAgcYC7wu0knLlqsiOHTtEa2h+Sv/v\np/q3hgjx8vKVl19+WSZMmKC/pduIjY2HdO7cRQwGFwFb8fauIn/++adMnDhR/6Zhr3+7cBcwynvv\nvSdRUVFWayfYt2+f9O3bV55++mn57bffrFJmSVakST4lJUUaN24soaGhUrt2bZk4cWKOz2fPni0G\ng0GuXbtW6IEqyoNm4sRJonU1dBWDwUVmzJghRqOrwFCBmQLe8vzzw7P3t7Pz0RN3Vi+cR6Vz5856\nbxsPATd9xagnLB4Ee/TybUVrRBbRpvd11pO7u0Cyvj1NoLzUrFlL4DnRuj8O0T87IFrjc0uBMP34\nWD2OwXo5u0RrUB4kHh6V5L333tPjOq6XsVBP9lUFfKR8+aoFHh2sLd3nrF9zTzEYXGTHjh0F/asp\n0Yr8TT7r611GRoY0adIku2fDuXPnpGPHjlKlShWV5JUyKykpSQ4dOiRpaWkiInL06FFp3bqN1K8f\nIbNnz86xr9ZlMSuhNREHBx+Ji4sTk8kkO3bskN27d8uhQ4f0N+pRAh+I1sOlrUATvRrnpJ6Q1wus\nFq2nTtZasSJaNZCdnuCf0L8liGjVPGP1P78p0MzimM76+bJ+v66/vdsK9LHYbhbt28oN/VtHc3ni\niSdy3ROz2Sx///23pKam3vP++fnVEK2dI+scr0jVqg2s85dzFw9yf/9iq65JSkqSiIgIOXbsmIiI\n9O7dWw4dOqSSvKLkQUxMjAwYMEBefPHFXHPsZNm3b5/4+AQK+OhJ3lu0vvuuojXu2grcFPhST/gT\nBI4IvKH/Plp/a/fXHyrD9IdB1mCyL/WyE/Tfewu0tnhYbBOtKupfog02uyVZ1U9aFU9WldF7UqtW\nwxyxT5w4UWxsvARcxMbGURYsWHzX++HiUklgrUWS/0q8vatZ7X7/r8mTJ+sPUaO4uATIgQMHCu1c\n+VXkSd5kMkloaKi4urrKuHHjRERk9erV8uKLL4qI3DXJT506NfvHGr0BFKWsmDVrlp6oOwqk6wn4\nOalcub44OweI1iDqKVBXr1LxFKgisEZP9P8WbcWoDgLuYm/vJdqi5zf1pF1eoIKeyN31n5aijdp1\n1R8kJv3PAfq3CWeLh0GyQGPp169fdsxTpkzRy3lb3+eUODj4y86dO3Nc27Zt2+T555+XV199Vdq0\n6SRao+5lgQsCdaVXrycL5Z5GRUXpD69fBFIExomTk3+hnCsvYmJicuTKYnuTj4+PlyZNmsiPP/4o\nTZo0yR62XaVKFbl69WrugtWbvKLkm8lkEqOxnOQcqLVFHBwC5JVXXtETezm9WsVdtAFU1/W3+XCL\nY1IEHOTo0aNSuXJdPXnbSmBgTZk1a5b861//0r8dtBStLeFx0er+vUXrBWQnixcvlhEjRsjQoUPF\nxsZDtF4/nhIQUCO7mkpExMkpUC8rLfv8BsNAWbBgQfY+c+fO1R8W3QXqirOzv9Su/ZBoVUz2EhHR\nqtCqUvr37y/alBZZ9yZDwJijx9GDwNq5875HNnh4eNClSxf279/P6dOnCQ0NBeDChQs89NBD7N69\nG19fX6v131eUssxoNNK8eSjbt38N9EMbrPQNfn7e7Nu3D20lrC7ATeBntMnafNAmYaufq7zvv/+e\nM2eOcv36dQC8vb2zP1u4cDEjR04AbgHVgIVAIPAw48aNISMjg0WLlgJ+QCqNGtVh5szpREZG5pg/\n3mwWtMnjtgFtgVRgJxUr9sze56WX3gC+BLoCJpKTW9OsWS2OHt2dfd15de7cOZYvX467uztDhw7N\ntZZAlgoVKgDR/DP46zfA7o77lxp3ewLExcVl1xsmJydLq1atZNOmTTn2UXXyilI4rl27pve88ROo\nJHZ23vLHH3+Ii0sF0Rpls95I/y0QJK1atZa9e/fqVRIviNaTp62An7Rp88hdz3X27Fl55plnpH//\n/jJx4kSZOHGixMTE6At2O8g/ffnPCHjI6tWrc5XRt29/0RY59xKtMTdI6tdvkuPNXOv/f8Ui9nHS\nrl27XGWNHDlavL1DJDCwlnz11Vd3jHvTpk1619QIgari4uJ/x7aOtLQ08fSsKFrvoiEC7jJs2PDb\n7lucrJ0771ra4cOHJTw8XEJDQ6V+/fo5RsNlCQ4OVkleUQpJRkaGfPPNN7JixYrs2SodHAJE6/6Y\nlSiXCPhLt27dRET0JO+t/zgIeMhjjz2Wo8zvvvtOli5deseEuH37drGz89KrVuzkn146ItBBxo4d\nm+sYk8kk/foNFAcHX7G395ZBgwaJ2WzOsY+XV2XRGoZNAn8K+OZawOXppwfq7QArBOYIOEt0dPRt\n4/TwqCTamAERbT6gR6VTpy53vJ8pKSkyZswY6dWrl6xYseKO+xWnIk3yBSpYJXlFKRRNmkTqdehx\n+pu11m0yayBR06ZNRevLflmvd+4vgYG1RETrJaclWl+BamJj4yl79uzJdQ5txs1pojWgnhGtoXa+\naNMteMqkSZPk+eefl/fffz9Pdei//fabODv7620DdvL4431y7WNr6yOw1eKh8oqUKxcgDz8cKa++\n+mqOfW1svAUOWew7T0JCwvJyO63i5s2bUqdOIzEY3MRo9JSRI0fluyyV5BWljEtKSpKQkLDsxkpX\n12vx/PAAAA96SURBVPI5ugLWqxch8K5F4juWPfK2a9fuAm1E67GjJVAfn9xdFrUG1FsWZQwXraeN\ni1SsWEP/czeBilKlSr08N5bGxcXlaLS1pCX5XyzO/ZpezdNZoJI0a/ZP1VNgYE3RBn6ZROsSGir9\n+w/IUyzW0KBBU9F6Hp0UrQuqV65vKPdLJXlFUUREqx65XXJ99NHOos17n9Xv/VNxdg4QEZGqVUMF\nFlgk0P1iY1MuVxlGo7vAj/LPdMj1pF27drJlyxbRevQc1D9LEqgoc+fOtdp19ejRR6CyaP36P9Sr\njMbq/9XOf/HiRREROX78uDg5+YrW3dRBQkLCshdzKUpGo5doYxWy7usMCQtrnK+yrJ071fJ/ilJC\nGY3G2/ZG+fzzZTg6/go0RJtCeTSffTYXgLCwEGAlWs8XAVbg8//t3X10TOe+wPFvRqKRRBA9ddoZ\nL0EiIokQ6qSKlEa0qkhbLkurtQ61GqI9l1w9pyHr0lW5ejlYzW2pt2pKEYdaSmuR0bIOp1HipRGO\nl8iQ0nCTiIi8zHP/2DJXiJi3zETO77PWXswzs5/5/dZk/faeZ5797McD7utj0aL/BF5Du81iMO3a\nlbNz5046dux45xU97/zrA0Ry+vRpp+W1efN6hg/vCfwRWAgsA/4b6AXsAby5fPkyAEFBQZSWFvDT\nT3s5ffo4Z84cwdPT9cshN2vmBVy4q+UcrVr5PeDVruVx58jh/I49PGigroUQD1FSUsLChQspLi5m\n0qRJREZGAtp69p06hXPlSiHgg5fXLX7++Yc67wublZXFpk2bMBgMJCQkoNPpKCoqok2b9mgFuD3w\ne+BtNm9ewyuvvOK0+C9fvoxeH4hWOJ8EbqNN74zAy+sQZWVX3FLMH2T+/PkkJ6cC0wATOt1Wjh07\nSI8ePWzuy9m1U4q8EP9izGYzRqOR4uJi4uLi8PHxsXrf9PR0JkyYivYtIAg4DVSxYcMXjB071qlx\nPvfcCxiNx4AxaGfwF/D1bYnRuI0+ffo49b2c4csvv2TFipX4+fnw8ccf0717d7v6cXbtbDyHQiGE\nS+h0OgYPHmzXvtowiQJOAJ2AY8DTVFRUOC2+GpmZO1mwYAFGo5Hg4BgWLVrUqM7e7zVhwgQmTJjg\n7jDuI2PyQoha1q9fzx/+MIBBgwZz4MCBWs9pvwEEoRV4gAigLf7+/g0Sy+zZs9m1axdLly61u8DP\nmTOH2NhYEhMTqaqqcnKEjZ8M1wghLJYsWcK77/4FeA8oAlaRmbmDmJgYQBun79t3EHAQbfmEH4E4\nrly50CiXNenTZyCHD19EG/LZiV5fxcWLJ+1aPsFVZExeCNFg/Pzac/NmKtp6OQB/JjR0NydP/mR5\nTULCdNLSPgcCgOuMHTuSDRs2uCHa+uXm5hISEgmY0G6MfgvoxFdf/ZVx48a5N7h6OLt2Nt7DmRDC\n5SorqwD9XS0dKC0tr/UaP7/WeHv3BP4MfMU33/zInj17XBildX755RegJVqBB2gB6CkoKHBfUG4g\nRV4IYRET0wdtGmA2sB+Yw8SJo2u9ZsOGrZSXpwEJwGhu3XqPjIztLo+1PpMnTyU+fgza2fsCoBBY\ni4dHLqNHj65/5yZGirwQwmLHjr8xYMDv0eliaNZsJG++OYKcnNN06BDGgAFD+PXXX2nZsiWQb9mn\nWbOLjebCH4Bdu3bx+efpaAeqHcAiwICX17+zfv0qAgMD3RugizXe+UhCCJfz9PTkhx92Wx537RrJ\n2bOewAzy878nMDCc9etXMH78ZMrLs/D0/A1//x1Mn37IfUHf47vvvgOeBULvtFwFfDl+/ADdunVz\nX2BuImfyQog65eXlcfZsDpAJTAY2Ul7elokTJ1NVpWjVajlJSb/jxImfeOqpp2rtW1payqhRo+ne\nvTcTJ0506dTFiIgI4DDwv3dasoDqu5Zk+NciRV4IUafS0lK0L/st7rQo4AolJZFUVv4XRUW9WbDg\nE/z9/Rk16lUMhh48++xgTCYTBkMI27aVcOrUG3zxxXG6devtsrjfeustevUKRpvPPwgYhK+vH598\n8onLYmhMZAqlEKJOZrOZ1q3bc+PGc2g/xn4GfAMUAM2BKsBAQICO69fbA1OAnXh6fkdVVRvgHNpB\nohRox/Hjh+pcIwdgy5YtbN26lY4dOzJ37lynXNmakJBAWtpytG8hYcD7zJ37HikpKQ733ZBknrwQ\nwmVMJhMxMS9x8WIBZnMZ1dV+wGW0e8kqIBBtHnox4AuY0e4F+xTaD5/ced3j7Nv3NwYOHHjfe8yY\n8R5Ll65Eu+/rYR5/vJKCglyHC33nzhGcPz8BSLrTsolmzd4hLe1DpkyZ4lDfDUnmyQshXMZgMPDP\nfx6louIKrVv/Dm1K4jvAAeBd4BrgBdTcDFuHtjLlWSAVbY2bd2ne3INnnnnmvv7NZjNLl/4P8AOQ\nDhynsNCL+fPnOxx7ZWU1cPesH1+qq3W8/fZ/MHXqOw73/6iQIi+EsMq1a1fRhmt+BF4BMtAuNnoM\n+DfgI2AqOl0emzatoVWrNHS6gTzxxE5+/nlfnWfm2rh/JdoaOKAdMHpx4cIFh+NNTHwT7YKtzcC3\naMNJI4A9LF++1uH+HxUyXCOEsIqnZwDV1V8DsWhDMC+jncFHA8loyxxcIyIiguzsg1b36+39BLdv\nv3OnjyPAc2zd+iUjR450OOaUlBTmz0+juhpgJLACuAEEoFSlw/03BBmuEUK4RXLyDCAe7UrXoWhD\nNsuAeUAa2gVSFzh2LI9ly5ZZ3e++fdt57LE0tB9zB/CnP011SoEHrchv3Pgp2jDTOOAKkEDbtu2d\n0v+jQM7khRBW27x5MytWrMBo/JGKiiS0i46GAhX8/7WVbzFmTBlff/21TX2XlZXh7e3dICtEpqSk\nMG/eXzGbK2jXTs8//rGHDh06OP19nEFm1wgh3O7MmTPMmPEXTKYCTpzIRqk1aGf5RUA4qanTSUpK\nqr8TUScp8kKIRmX16tVMmjQN6AzkExbWnePH/+7usB5ZUuSFEI1OXl4eO3bsoEuXLsTFxbk7nEea\nFHkhhGjCZHaNEEIIq0mRt5PRaHR3CA2mKecGkt+jrqnn52z1Fvny8nL69etHZGQkoaGhvP/++wDM\nmjWL7t2707NnT+Lj4ykuLnZJsI1JU/5Da8q5geT3qGvq+TlbvUXe29ubzMxMjh49yrFjx8jMzGT/\n/v0MHTqUkydPkp2dTXBwMB999JGr4hVCCGGDhw7X+Pj4AFBRUUF1dTUBAQHExsZaLljo168fJpOp\nYaMUQghhH/UQ1dXVqmfPnsrPz0/NmjXrvudfeukllZ6efl872uIWsskmm2yy2bg500MXbNbpdBw9\nepTi4mLi4uIwGo3ExMQA8OGHH9K8eXPGjx9/335Kpk8KIYTbWT27plWrVgwfPpysrCwA1qxZw7ff\nfkt6enqDBSeEEMIx9Rb5wsJCioqKALh16xa7d++mV69e7Nq1i4ULF7Jt2za8vb3r60IIIYQb1Ttc\nU1BQwMSJEzGbzZjNZl5//XWGDBlCUFAQFRUVxMbGAhAdHU1aWppLAhZCCGEDRwf1N27cqEJDQ5VO\np1NZWVmW9u+//15FRUWp8PBwFRUVpfbu3Wt57vbt22ry5MkqODhYhYSEqIyMDEfDaDD25FdjxIgR\nKiwszJXh2szW/MrKytSLL76oQkJCVI8ePdTs2bPdFbpV7Pn8srKyVFhYmOratatKTEx0R9hWuzu/\nw4cPW9qvXbumYmJilJ+fn5o2bVqtfVatWqXCwsJURESEGjZsmCosLHR12FaxJ7dHtbZYm18NW2qL\nw0U+JydH5ebmqpiYmFqBHjlyRBUUFCillDpx4oTS6/WW5+bMmaOSk5MtjxvrH5lS9uWnlFIZGRlq\n/PjxKjw83KXx2srW/MrKypTRaFRKKVVRUaEGDBigdu7c6frArWTP59e3b1916NAhpZRSL7zwwiOZ\n382bN9X+/fvVp59+WqtQ3L59WwUEBKhr164ppZRKSkpSKSkpLo/bGrbmplTTqC315aeU7bXFsduh\nAyEhIXW2R0ZGWv4fGhrKrVu3qKysxMvLi9WrV5Obm2t5vm3bto6G0WDsya+0tJTFixezfPlyxowZ\n46pQ7WJrfi1atGDQoEEAeHl50bt3by5duuSSWO1ha36FhYXcuHGDp59+GoA33niDrVu3MmzYMJfE\na6sH5efj40P//v05c+ZMrXZPT0/atGlDaWkpbdq0oaSkhKCgIFeEajNbcwOaRG2pLz97aotL1q7J\nyMggKioKLy8vyw+5H3zwAVFRUYwZM4arV6+6IowGc3d+AMnJycycOdNyIdmj7t78ahQVFbF9+3aG\nDBnipsic4+78Ll26hMFgsDyn1+sb9UHsYTw8PGo91ul0LFmyhLCwMPR6PTk5OUyaNMlN0Tnm3tya\nWm25Nz+wr7ZYVeRjY2MJDw+/b9u+fftD9z158iSzZ8/ms88+A6CqqgqTyUT//v05fPgw0dHRzJw5\n0+qAG4Iz8zt69Cjnzp1j5MiRjeZaAWfmV6Oqqopx48YxY8YMOnXq1ECRW6ch8mtMHMnvXiUlJSQm\nJpKdnc3ly5cJDw9367IkzsytqdWWe9lbW6wartm9e7fNAQGYTCbi4+NZt24dgYGBgPb1ycfHh/j4\neABeffVVVq5caVf/zuLM/A4ePEhWVhaBgYFUVVVx9epVBg8ezN69e50Zsk2cmV+NKVOm0K1bNxIT\nE50RokOcmZ9er6+1TIfJZEKv1zslTnvZm19dcnJyCAwMtOT72muvkZqa6rT+beXM3JpSbamLvbXF\nqcM1dx9dioqKGD58OKmpqURHR1vaPTw8GDFiBJmZmQDs2bOHHj16ODOMBmNNflOnTuXSpUucP3+e\n/fv3Exwc7NYCbwtr8gPt63BJSQmLFy92dYgOsSa/J598En9/fw4dOoRSinXr1jFq1Ch3hGuzus7u\n7m3r3Lkzp06dorCwENCKUGhoqEvic4Q1uTWV2vKgNrtriyO/Diul1JYtW5TBYFDe3t6qXbt2atiw\nYUoppebNm6d8fX1VZGSkZfvtt9+UUkrl5eWpgQMHqoiICPX888+r/Px8R8NoMPbkV+P8+fONfnaN\nrfnl5+crDw8PFRoaamlfuXKlm7N4MHs+v5oplF26dFHTp093Z/gP9aD8lFKqY8eOKiAgQPn5+SmD\nwaBycnKUUkqtXbvWMoXy5ZdfVtevX3dX+PWyNrf27dtbcmsKtUWpB+dXw5ba0mC3/xNCCOF+cmco\nIYRowqTICyFEEyZFXgghmjAp8kII0YRJkRdCiCZMirwQQjRh/wdVyE1u1GcBOAAAAABJRU5ErkJg\ngg==\n" } ], "prompt_number": 13 }, { "cell_type": "markdown", "metadata": {}, "source": [ "Convert the 'County Code' into a FIPS, ie add on the '06' California prefix" ] }, { "cell_type": "code", "collapsed": false, "input": [ "#sites_df['FIPS'] = sites_df['County Code'].apply(lambda x: '0' + (str(6000 + int(x) )))\n", "sites_df['FIPS'] = sites_df['County Code'].apply(lambda x: 6000 + int(x) )" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 14 }, { "cell_type": "code", "collapsed": false, "input": [ "sites_df['FIPS'][100:110]" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "pyout", "prompt_number": 15, "text": [ "100 6037\n", "101 6037\n", "102 6037\n", "103 6037\n", "104 6037\n", "105 6037\n", "106 6037\n", "107 6037\n", "108 6039\n", "109 6039\n", "Name: FIPS" ] } ], "prompt_number": 15 }, { "cell_type": "markdown", "metadata": {}, "source": [ "Next Up: Calculate county wide averages\n", "---------------------------------------" ] }, { "cell_type": "code", "collapsed": false, "input": [ "county_averages = sites_df.groupby('FIPS')['Mean Ozone'].mean()\n", "county_averages.index" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "pyout", "prompt_number": 26, "text": [ "Int64Index([6001, 6005, 6007, 6009, 6011, 6013, 6017, 6019, 6021, 6023, 6025, 6027, 6029, 6031, 6033, 6037, 6039, 6041, 6043, 6045, 6047, 6053, 6055, 6057, 6059, 6061, 6065, 6067, 6069, 6071, 6073, 6075, 6077, 6079, 6081, 6083, 6085, 6087, 6089, 6093, 6095, 6097, 6099, 6101, 6103, 6107, 6109, 6111, 6113], dtype=int64)" ] } ], "prompt_number": 26 }, { "cell_type": "code", "collapsed": false, "input": [ "county_averages.hist(bins = 20)" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "pyout", "prompt_number": 18, "text": [ "" ] }, { "output_type": "display_data", "png": "iVBORw0KGgoAAAANSUhEUgAAAXgAAAD9CAYAAAC2l2x5AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAGFJJREFUeJzt3X9sVfX9x/FX17JMwo/CAgUp21UGkyL0duC6EckuEyTq\nmDL9Q1SgAtPoFoYxfpclS+b2h+AMy5CZmBixW7boksW4ToFNIifCmGNAu5lhdCNtAvJjzolSihTK\n5/sHcmvvbcs995zbz30fn4+EuA/cz72vfnrPu+V1L12Fc84JAJA4n/IdAABQGgx4AEgoBjwAJBQD\nHgASigEPAAnFgAeAhAo94NetW6cZM2Zo5syZuuOOO3TmzJlS5AIARBRqwHd0dOipp57S/v379frr\nr6unp0fPPfdcqbIBACKoCnPjUaNGadiwYerq6lJlZaW6uro0adKkUmUDAEQQasCPHTtWDz74oD73\nuc/psssu06JFi7RgwYI+t6moqIg1IAB8UsT9gwVCVTQHDx7Uz3/+c3V0dOjIkSPq7OzUb37zm7zb\nOefM/vrRj37kPcMnMXuY/B89y4r4Vdrn5ifl/Mv1l/X8pRBqwO/du1dz587VZz/7WVVVVelb3/qW\ndu/eXZJgvnR0dPiOUDTL2SXy+0b+5Ak14K+66iq99tprOn36tJxz2r59u+rq6kqVDQAQQagBX19f\nr+XLl2vOnDmaNWuWJOmee+4pSTBfmpqafEcomuXsEvl9I3/yVLiYy5+KioqS9UmAdPGF/GKeYzw3\nUb5KMTv5l6w5giDwHaFolrNL5PeN/MnDgAeAhKKigTlUNEgiKhoAQMEY8Dks93iWs0vk9438ycOA\nB4CEooOHOXTwSCI6eABAwRjwOSz3eJazS+T3jfzJw4AHgISig4c5dPBIIjp4AEDBGPA5LPd4lrNL\n5PeN/MnDgAeAhKKDhzl08EgiOngAQMEY8Dks93iWs0vk9438ycOAB4CEooOHOXTwSKKy6ODffPNN\nNTQ0ZH+NHj1ajz/+eKyhAADRhR7wX/ziF9Xa2qrW1lbt27dPw4cP15IlS0qRzQvLPZ7l7BL5fSN/\n8kTq4Ldv364pU6Zo8uTJceUBAMQkUge/cuVKzZkzR/fff3/vHVZUaMWKFUqlUpKk6upqpdNpZTIZ\nSb1fZVmzLnY9f/589XbwwUf/zRSwrtCOHTu852fNOpPJKAgCNTc3S5JSqZR+/OMfx97BFz3gu7u7\nNWnSJB04cEDjxo3rvUNeZEWJ8SIrkqgsXmS9aOvWrZo9e3af4Z4EF7/CWmQ5u0R+38ifPEUP+Gef\nfVZLly6NMwsAIEZFVTSnTp3S5z//ebW3t2vkyJF975CKBiVGRYMkKsXs5B86wRwGPJKorDr4pLLc\n41nOLpHfN/InDwMeABKKigbmUNEgiahoAAAFY8DnsNzjWc4ukd838icPAx4AEooOHubQwSOJ6OAB\nAAVjwOew3ONZzi6R3zfyJw8DHgASig4e5tDBI4no4AEABWPA57Dc41nOLpHfN/InDwMeABKKDh7m\n0MEjiejgAQAFY8DnsNzjWc4ukd838icPAx4AEip0B3/ixAmtXr1a//znP1VRUaHNmzfrK1/5Su8d\n0sGjxOjgkUSlmJ1VYTd873vf04033qjf/e53OnfunE6dOhVrIABAPEJVNO+//7527typlStXSpKq\nqqo0evTokgTzxXKPZzm7RH7fyJ88ob6Db29v17hx43T33Xfr73//u2bPnq2NGzdq+PDhfW7X1NSk\nVColSaqurlY6nVYmk5HU+0ko13VbW1tZ5WHd/7rXxXWmoHW55GfNOggCNTc3S1J2XsYtVAe/d+9e\nffWrX9Xu3bt1zTXXaO3atRo1apR+8pOf9N4hHTxKjA4eSeT9ffC1tbWqra3VNddcI0m67bbbtH//\n/lgDAQDiEWrAT5gwQZMnT9Zbb70lSdq+fbtmzJhRkmC+5FcAdljOLpHfN/InT+h30WzatEl33nmn\nuru7NWXKFD3zzDOlyAUAiIifRQNz6OCRRN47eACAHQz4HJZ7PMvZJfL7Rv7kYcADQELRwcMcOngk\nER08AKBgDPgclns8y9kl8vtG/uRhwANAQtHBwxw6eCQRHTwAoGAM+ByWezzL2SXy+0b+5GHAA0BC\n0cHDHDp4JBEdPACgYAz4HJZ7PMvZJfL7Rv7kYcADQELRwcMcOngkER08AKBgDPgclns8y9kl8vtG\n/uRhwANAQhXVwadSKY0aNUqVlZUaNmyY9uzZ03uHdPAoMTp4JFEpZmdVsUGCINDYsWNjDQMAiE/R\nFU1SvxOy3ONZzi6R3zfyJ0/R38EvWLBAlZWVuvfee/Xtb3+7z583NTUplUpJkqqrq5VOp5XJZCT1\nfhLKdd3W1lZWeVj3v+51cZ0paF0u+UuxHjVqrE6efE9hXXbZCHV1nfSe/5O2DoJAzc3NkpSdl3Er\nqoM/evSoJk6cqHfeeUcLFy7Upk2bNG/evAt3SAePEqOD7x/nYlvZvA9+4sSJkqRx48ZpyZIlfV5k\nBQCUh9ADvqurSydPXvjr3KlTp/SnP/1JM2fOjD2YL/kVgB2Ws0vk9438yRO6gz9+/LiWLFkiSTp3\n7pzuvPNOXX/99bEHAwBEw8+igTl0zf3jXGwrmw4eAFD+GPA5LPd4lrNL5PeN/MnDgAeAhKKDhzl0\nzf3jXGyjgwcAFIwBn8Nyj2c5u0R+38ifPAx4AEgoOniYQ9fcP87FNjp4AEDBGPA5LPd4lrNL5PeN\n/MnDgAeAhKKDhzl0zf3jXGyjgwcAFIwBn8Nyj2c5u0R+38ifPAx4AEgoOniYQ9fcP87FNjp4AEDB\nGPA5LPd4lrNL5PeN/MnDgAeAhCqqg+/p6dGcOXNUW1urP/zhD33vkA4eJUbX3D/Oxbay6eA3btyo\nurq6j55QAIByFHrAHz58WFu2bNHq1asT+VXfco9nObtEft/InzxVYTc88MADeuyxx/TBBx8MeJum\npialUilJUnV1tdLptDKZjKTeT0K5rtva2soqj4X1jTcu1unTnQpr5Mgxaml5vqjH73VxnSlgXVXk\n3zorJfWE3hXl4yt2He48Pr7WkORj3bsOgkDNzc2SlJ2XcQvVwb/44ovaunWrnnjiCQVBoA0bNtDB\nY8i73yiPN9T7hvJaoIO3zXsHv3v3brW0tOiKK67Q0qVL9corr2j58uWxBgIAxCPUgH/kkUd06NAh\ntbe367nnntPXv/51/epXvypVNi8s93iWs0v28+fWHdZYP3/r+Ush0vvgeRcNAJQvfhYNIqODH3gf\nHTwK5b2DBwDYwYDPYbnHs5xdsp+fDt4v6/lLgQEPAAlFB4/I6OAH3kcHj0LRwQMACsaAz2G5x7Oc\nXbKfnw7eL+v5S4EBDwAJRQePyOjgB95HB49C0cEDAArGgM9huceznF2yn58O3i/r+UuBAQ8ACUUH\nj8jo4AfeRwePQtHBAwAKxoDPYbnHs5xdsp+fDt4v6/lLgQEPAAlFB4/I6OAH3kcHj0LRwQMACsaA\nz2G5x7OcXbKfnw7eL+v5S4EBDwAJFbqD//DDD/W1r31NZ86cUXd3t26++WatW7eu9w7p4D9x6OAH\n3kcHj0KVYnZWhd3wmc98Rjt27NDw4cN17tw5XXvttdq1a5euvfbaWIMBAKIpqqIZPny4JKm7u1s9\nPT0aO3ZsrKF8stzjWc4u2c9PB++X9fylEPo7eEk6f/68vvSlL+ngwYO67777VFdX1+fPm5qalEql\nJEnV1dVKp9PKZDKSej8J5bpua2srqzxDuR41aqxOnnxP0QQf/TdT0LrYvMU+XvHrYh6v6qPaJKxK\nST1F7LtUnoHWlUXlHDlyjFpanr9wb2Xw/LW2DoJAzc3NkpSdl3GL9D74999/X4sWLdL69euzHwAd\nvF0+uu2kd/BJ38e1Hp+yex/86NGjddNNN2nv3r1x5QEAxCT0gP/vf/+rEydOSJJOnz6tl19+WQ0N\nDbEH88Vyj2c5u2Q/v/UO3np++8+f+IXu4I8ePaoVK1bo/PnzOn/+vJYtW6brrruuFNkAABHws2iQ\nRQfPvrD7uNbjU3YdPACgfDHgc1ju8Sxnl+znt95hW89v//kTPwY8ACQUHTyy6ODZF3Yf13p86OAB\nAAVjwOew3ONZzi7Zz2+9w7ae3/7zJ34MeABIKDp4ZNHBsy/sPq71+NDBAwAKxoDPYbnHs5xdsp/f\neodtPb/950/8GPAAkFB08Miig2df2H1c6/GhgwcAFIwBn8Nyj2c5u2Q/v/UO23p++8+f+DHgASCh\n6OCRRQfPvrD7uNbjQwcPACgYAz6H5R7PcnbJfn7rHbb1/PafP/FjwANAQoXu4A8dOqTly5frP//5\njyoqKnTPPfdozZo1vXdIB28WHTz7wu7jWo9PKWZn6AF/7NgxHTt2TOl0Wp2dnZo9e7ZeeOEFTZ8+\nvWQhMTQY8OwLu49rPT5l8SLrhAkTlE6nJUkjRozQ9OnTdeTIkVhD+WS5x7OcXbKf33qHbT2//edP\n/KqibO7o6FBra6saGxv7/H5TU5NSqZQkqbq6Wul0WplMRlLvJ6Fc121tbbHf/403Ltbp050Ka+TI\nMWppeT72PIOtey/ysGtd4s/7W1d99N14FGEeL8qax+tv7ft6tXz9BUGg5uZmScrOy7gV/T74zs5O\nZTIZ/fCHP9Qtt9zSe4dUNHmiVApDeZZUH+wLu8/CtW7p+vNe0UjS2bNndeutt+quu+7qM9wBAOUj\n9IB3zmnVqlWqq6vT2rVrS5HJK8s9nuXsFwS+A0QU+A4QUeA7QCT2n//xCz3g//znP+vXv/61duzY\noYaGBjU0NGjbtm2lyAYAiICfRTMELHWAVrpf9pXHPgvXuqXrryw6eABA+WPA57Dc41nOfkHgO0BE\nge8AEQW+A0Ri//kfPwY8ACQUHfwQsNQBWul+2Vce+yxc65auPzp4AEBBGPA5LPd4lrNfEPgOEFHg\nO0BEge8Akdh//sePAQ8ACUUHPwQsdYBWul/2lcc+C9e6peuPDh4AUBAGfA7LPZ7l7BcEvgNEFPgO\nEFHgO0Ak9p//8WPAA0BC0cEPAUsdoJXul33lsc/CtW7p+qODBwAUhAGfw3KPZzn7BYHvABEFvgNE\nFPgOEIn953/8GPAAkFB08EPAUgdopftlX3nss3CtW7r+6OABAAVhwOew3ONZzn5B4DtARIHvABEF\nvgNEYv/5Hz8GPAAkVOgOfuXKlXrppZc0fvx4vf766/l3SAefx1IHaKX7ZV957LNwrVu6/rx38Hff\nfbe2bdsWawgAQPxCD/h58+ZpzJgxpchSFiz3eJazXxD4DhBR4DtARIHvAJHYf/7Hr6oUd9rU1KRU\nKiVJqq6uVjqdViaTkdT7SYhjfeDAAa1d+39yTqqpuVySdPz4EUmDr3fseFk9Pd2hP66RI8eopeX5\novL2urjOFLCu+uivl2FVSuopYt+l8gy2jrqfx7P3eEP7/Bz66y/eeZW7DoJAzc3NkpSdl3Er6n3w\nHR0dWrx4sfcO/umnn9b9929Wd/eKkDvv1VB2cnTb7GNfPPuG+vqz3sGX5Dv4oVRVdZW6u+8Jueve\nkmQBgHLC2yTzBL4DRBD4DhBR4DtARIHvABEFvgNEQgefL/SAX7p0qebOnau33npLkydP1jPPPFOK\nXACAiEz/LJqnn35aa9bsVlfX0yF32ukA2cc+9vXuo4MPh4oGABKKAZ8n8B0ggsB3gIgC3wEiCnwH\niCjwHSASOvh8DHgASCgGfJ6M7wARZHwHiCjjO0BEGd8BIsr4DhDJxX9MhF4MeABIKAZ8nsB3gAgC\n3wEiCnwHiCjwHSCiwHeASOjg8zHgASChGPB5Mr4DRJDxHSCijO8AEWV8B4go4ztAJHTw+RjwAJBQ\nDPg8ge8AEQS+A0QU+A4QUeA7QESB7wCR0MHnY8ADQEIx4PNkfAeIIOM7QEQZ3wEiyvgOEFHGd4BI\n6ODzMeABIKEY8HkC3wEiCHwHiCjwHSCiwHeAiALfASKhg8/HgAeAhGLA58n4DhBBxneAiDK+A0SU\n8R0goozvAJHQwedjwANAQjHg8wS+A0QQ+A4QUeA7QESB7wARBb4DREIHn48Bn6fNd4AILGeXyO+b\n7fxtbbbzl0LoAb9t2zZdddVVmjp1qh599NFSZPLshO8AEVjOLpHfN9v5T5ywnb8UQg34np4effe7\n39W2bdt04MABPfvss3rjjTdKlQ0AEEGoAb9nzx594QtfUCqV0rBhw3T77bfr97//famyedLhO0AE\nHb4DRNThO0BEHb4DRNThO0AkHR0dviOUnaowN3777bc1efLk7Lq2tlZ//etf825XUVERPVkom4vY\nM1jGXw68q+iPbaj2Xcxe7jkH2jfw2Zfm8eLel5u/XHMOtK/Q84/r8ULuusT198tfDpS/NI9X7kIN\n+EI+WOdc0WEAAPEJVdFMmjRJhw4dyq4PHTqk2tra2EMBAKILNeDnzJmjf/3rX+ro6FB3d7d++9vf\n6pvf/GapsgEAIghV0VRVVekXv/iFFi1apJ6eHq1atUrTp08vVTYAQASX/A4+933vN9xwg9588039\n+9//1g9+8ANJ0po1azR16lTV19ertbU1u3flypWqqanRzJkz+9znww8/rNraWjU0NKihoUHbtm2L\n+cPqP3t/+st+6NAhzZ8/XzNmzNDVV1+txx9/PHv7//3vf1q4cKGmTZum66+/vqTvvS1F/qE6+yj5\nP/zwQzU2NiqdTquuri77PJNsnP9g+S2c/0U9PT1qaGjQ4sWLs79n4fwHy1/us0eSUqmUZs2apYaG\nBn35y1/O/n5RZ+8Gce7cOTdlyhTX3t7uuru7XX19vTtw4ECf27z00kvuhhtucM4599prr7nGxsbs\nn7366qtu//797uqrr+6z5+GHH3YbNmwY7KEji5L96NGjrrW11Tnn3MmTJ920adPcG2+84Zxz7qGH\nHnKPPvqoc8659evXu+9///um8g/F2UfN75xzp06dcs45d/bsWdfY2Oh27drlnLNx/oPlt3L+zjm3\nYcMGd8cdd7jFixdnf8/K+Q+Uv9xnj3POpVIp9+677+bdbzFnP+h38IW8772lpUUrVqyQJDU2NurE\niRM6duyYJGnevHkaM2bMQF9YLv3VJ4Jisx8/flwTJkxQOp2WJI0YMULTp0/X22+/nbdnxYoVeuGF\nF0zll4bmnU5R8kvS8OHDJUnd3d3q6enJPo8snP9g+SUb53/48GFt2bJFq1ev7pPXyvkPlF8q79kz\nWMZizn7QAd/f+94/PigKvU1/Nm3apPr6eq1ataokf80rNvvhw4f73Kajo0Otra1qbGyUJB0/flw1\nNTWSpJqamj6fFAv5pdKffRz5e3p6lE6nVVNTo/nz56uurk6SnfMfKL9U3ud/8TYPPPCAHnvsMX3q\nU31HRLmf/6XyS+U7ey7epqKiQgsWLNCcOXP01FNPZW9TzNkPOuALfZN/7lebS+2777771N7erra2\nNk2cOFEPPvhgQY8TRhzZOzs7ddttt2njxo0aMWJEv49Rqn8IUar8Q3H2uTkGM1D+yspKtbW16fDh\nw3r11Vf7/UmB5Xz+A+Uv9/N3zunFF1/U+PHj1dDQMOh3u+V4/pfKX86z56Jdu3aptbVVW7du1RNP\nPKGdO3f2+xiFPM6gA76Q973n3ubw4cOaNGnSoA86fvz4bMDVq1drz549lwwaVtTsZ8+e1a233qq7\n7rpLt9xyS/Y2NTU12Qrq6NGjGj9+fOzZS5l/KM4+jvwXjR49WjfddJP27dsnyc755+bfu3evJBvn\nv3v3brW0tOiKK67Q0qVL9corr2j58uWSbJz/YPktzJ7LL79ckjRu3DgtWbJEf/vb3yQVefaDFfRn\nz551V155pWtvb3dnzpy55IsFf/nLX/Je6Ghvb897kfXIkSPZ//2zn/3MLV269JIvFoQVJfv58+fd\nsmXL3Nq1a/Pu96GHHnLr1693zjm3bt26kr3IVKr8Q3H2UfO/88477r333nPOOdfV1eXmzZvntm/f\n7pyzcf6D5bdw/h8XBIH7xje+kV1bOP/B8pf77Dl16pT74IMPnHPOdXZ2urlz57o//vGPzrnizn7Q\nAe+cc1u2bHHTpk1zU6ZMcY888ohzzrknn3zSPfnkk9nbfOc733FTpkxxs2bNcvv27cv+/u233+4m\nTpzoPv3pT7va2lq3efNm55xzy5YtczNnznSzZs1yN998szt27Nglgxaj2Ow7d+50FRUVrr6+3qXT\naZdOp93WrVudc869++677rrrrnNTp051CxcuzF7IVvIP1dlHyf+Pf/zDNTQ0uPr6ejdz5kz305/+\nNHt7C+c/WH4L5/9xQRD0eReKhfMfLH+5z56DBw+6+vp6V19f72bMmJHd61xxZ1/hHD88BgCSiP9H\nJwBIKAY8ACQUAx4AEooBDwAJxYAHgIRiwANAQv0/u/+a97WGUZgAAAAASUVORK5CYII=\n" } ], "prompt_number": 18 }, { "cell_type": "code", "collapsed": false, "input": [ "county_averages.mean(), county_averages.std()" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "pyout", "prompt_number": 19, "text": [ "(0.033272136153468475, 0.006327595808016743)" ] } ], "prompt_number": 19 }, { "cell_type": "code", "collapsed": false, "input": [ "med = pd.read_csv(open('FIPSAsthmaCounty.csv'), sep=',')" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 28 }, { "cell_type": "code", "collapsed": false, "input": [ "med = med.set_index('FIPS')\n", "med.columns = ['county', 'prevalence']\n", "med.index" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "pyout", "prompt_number": 29, "text": [ "Int64Index([6005, 6011, 6027, 6001, 6003, 6007, 6009, 6013, 6015, 6017, 6019, 6021, 6023, 6025, 6029, 6031, 6033, 6035, 6037, 6039, 6041, 6043, 6045, 6047, 6049, 6051, 6053, 6055, 6057, 6059, 6061, 6063, 6065, 6067, 6071, 6073, 6075, 6077, 6079, 6081, 6083, 6085, 6087, 6089, 6091, 6093, 6095, 6097, 6099, 6101, 6103, 6105, 6107, 6109, 6111, 6113, 6115], dtype=int64)" ] } ], "prompt_number": 29 }, { "cell_type": "code", "collapsed": false, "input": [ "ozone = DataFrame(county_averages)" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 22 }, { "cell_type": "code", "collapsed": false, "input": [ "both = pd.concat([med, ozone], axis = 1)\n", " " ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 32 }, { "cell_type": "code", "collapsed": false, "input": [ "both[:10]" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
countyprevalenceMean Ozone
FIPS
6001 Alameda 9.8 0.025886
6003 Alpine 8.7 NaN
6005 Amador 8.7 0.031071
6007 Butte 9.7 0.039171
6009 Calaveras 8.7 0.036388
6011 Colusa 13.7 0.030787
6013 Contra Costa 9.6 0.027290
6015 Del Norte 9.2 NaN
6017 El Dorado 8.3 0.040176
6019 Fresno 11.3 0.040742
\n", "
" ], "output_type": "pyout", "prompt_number": 35, "text": [ " county prevalence Mean Ozone\n", "FIPS \n", "6001 Alameda 9.8 0.025886\n", "6003 Alpine 8.7 NaN\n", "6005 Amador 8.7 0.031071\n", "6007 Butte 9.7 0.039171\n", "6009 Calaveras 8.7 0.036388\n", "6011 Colusa 13.7 0.030787\n", "6013 Contra Costa 9.6 0.027290\n", "6015 Del Norte 9.2 NaN\n", "6017 El Dorado 8.3 0.040176\n", "6019 Fresno 11.3 0.040742" ] } ], "prompt_number": 35 }, { "cell_type": "code", "collapsed": false, "input": [ "both = both.dropna()\n", "both[:10]" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
countyprevalenceMean Ozone
FIPS
6001 Alameda 9.8 0.025886
6005 Amador 8.7 0.031071
6007 Butte 9.7 0.039171
6009 Calaveras 8.7 0.036388
6011 Colusa 13.7 0.030787
6013 Contra Costa 9.6 0.027290
6017 El Dorado 8.3 0.040176
6019 Fresno 11.3 0.040742
6021 Glenn 13.7 0.032210
6023 Humboldt 7.0 0.023115
\n", "
" ], "output_type": "pyout", "prompt_number": 37, "text": [ " county prevalence Mean Ozone\n", "FIPS \n", "6001 Alameda 9.8 0.025886\n", "6005 Amador 8.7 0.031071\n", "6007 Butte 9.7 0.039171\n", "6009 Calaveras 8.7 0.036388\n", "6011 Colusa 13.7 0.030787\n", "6013 Contra Costa 9.6 0.027290\n", "6017 El Dorado 8.3 0.040176\n", "6019 Fresno 11.3 0.040742\n", "6021 Glenn 13.7 0.032210\n", "6023 Humboldt 7.0 0.023115" ] } ], "prompt_number": 37 }, { "cell_type": "code", "collapsed": false, "input": [ "plt.scatter(both['Mean Ozone'], both['prevalence'])" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "pyout", "prompt_number": 39, "text": [ "" ] }, { "output_type": "display_data", "png": "iVBORw0KGgoAAAANSUhEUgAAAXkAAAD9CAYAAABZVQdHAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3XlcVPX+P/DXDMyKoIgsJihuuLLlgpokpmBuZbiiuZF1\nv2a2mXXL7r1oN5fMyjTr22LZ77bcvOW+ZoqiqGnirqlcUCFBNkEYYGDm8/tD5Ssp+5w5cHg9Hw8f\nD+bM53zOaz7MvD18zjIqIYQAEREpklruAEREJB0WeSIiBWORJyJSMBZ5IiIFY5EnIlIwFnkiIgWr\ntMhHR0fD09MT/v7+5ZavWLECXbp0Qffu3fHaa69JGpCIiGrPsbInp0+fjtmzZ2PKlClly/bs2YON\nGzfi5MmT0Gg0yMjIkDwkERHVTqV78qGhoXB1dS237OOPP8brr78OjUYDAHB3d5cuHRER1Umle/L3\nc/HiRezbtw9vvPEG9Ho93n33XfTs2bNcG5VKZbOARESNia1vQlDjA6+lpaXIycnBoUOHsHTpUowb\nN+6+7YQQ9erfP/7xD9kzNJRczMRMjSFXfcwkhRoXeW9vb0RGRgIAevXqBbVajaysLJsHIyKiuqtx\nkR81ahR2794NALhw4QLMZjPc3NxsHoyIiOqu0jn5qKgo7N27F1lZWfDx8cGCBQsQHR2N6Oho+Pv7\nQ6vV4uuvv7ZX1joJCwuTO8J91cdczFQ9zFR99TFXfcwkBZWQYCJIpVJJNr9ERKRUUtROXvFKRKRg\nLPJERArGIk9EpGAs8kRECsYiT0SkYCzyREQKxiJPRKRgLPJERArGIk9EpGAs8kRECsYiT0SkYCzy\nREQKxiJPRKRgLPJERArGIk9EpGAs8kRECsYiT0SkYCzyREQKxiJPRKRgLPJERArGIk9EpGCOcgcg\nIiAnJwd79uyBg4MDBg8eDCcnJ7kjkUKohBDC5p2qVJCgWyJFSk5ORu/eYSgq6gKgCC1aZODo0X1o\n3ry53NHIzqSonZyuIZLZCy+8gezsGbh5cxtu3tyN1NRQzJ+/SO5YpBAs8kQyS05OgcXy0O1HKpjN\nDyExMUXWTKQcLPJEMhs4sC/0+hUAigDkwWj8FI880kfuWKQQLPJEMlu8eD4GDXKEo6MrHBw8MH58\nd7zwwnNyxyKF4IFXonqioKAAarUaBoNB7igkE7sfeI2Ojoanpyf8/f3veW7ZsmVQq9XIzs62aSCi\nxsrJyYkFnmyu0iI/ffp0bN++/Z7lV69exc8//4w2bdpIFoyIiOqu0iIfGhoKV1fXe5a//PLLeOed\ndyQLRUREtlHjK143bNgAb29vBAQEVNouJiam7OewsDCEhYXVdFNERIoWGxuL2NhYSbdR5YHX5ORk\njBw5EqdOnYLJZMLAgQPx888/w8XFBW3btsXRo0fh5uZWvlMeeCUiqjHZr3hNTExEcnIyAgMD0bZt\nW6SkpKBHjx64fv26TUMREZFt1Gi6xt/fH+np6WWP27Zti99++4332CBZZGZmYv/+/TAajRg4cCA0\nGk2FbRMSEpCYmIhu3bqhS5cudkxZtSNHjuDy5csICAiAn5+f3HFIaUQlJkyYIFq2bCm0Wq3w9vYW\nq1evLvd827ZtRVZW1j3rVdEtUZ2dPn1aNGvWUri4DBXOzj1Ejx4PC5PJdN+2b765QBiNrYSLyyhh\nMHiITz75zM5pK/bii68Jo7H17Wzu4l//+kbuSCQjKWonL4aiBikkZDCOHBkDIf4HgBUGQyTeeuth\nzJnzcrl2Fy5cQFDQwygsPAnAA8Al6HQ9kJ5+BU2bNpUjepmEhAT07/8YTKaTAFwBnIFe3w85OenQ\n6/WyZiN5yD4nT1RfXLlyBUIMuP1IjcLC/khMvHJPu6tXr0Kr7YxbBR4AOkCjaYG0tDR7Ra3QlStX\n4OgYiFsFHgC6QaUyIDMzU85YpDAs8tQg9e3bG1rthwAsALLg5PQv9O/f+5523bp1Q0nJaQAHby/Z\nAEfHwnpxIV9gYCBKSw8DOHZ7yfdo0kQHLy8vOWORwrDIU4P0+ecfIijod2i1zeHo6IOnn34UUVFR\n97Tz8vLC2rVfw8lpBHQ6NzRvPgvbtv1UL6ZDfH198fXX/wuD4RHodG7w8PgrduxYD0dHfmEb2Q7n\n5KnBEkIgJycHer0eRqOx0ralpaXIzs5GixYtoFbXr32bkpIS5OTk1MtsZF9S1E4WeSKieoIHXomI\nqEZY5ImIFIxFnohIwVjkiYgUjEWeiEjBWOSJiBSMRZ6ISMFY5ImIFIxFnohIwVjkiYgUjEWeiEjB\nWOSJiBSMRZ6ISMFY5ImIFIxFnohIwVjkiYgUjEWeiEjBWOSJiBSMRZ6ISMFY5ImIFIxFnohIwVjk\niYgUjEWeiEjBKi3y0dHR8PT0hL+/f9myuXPnokuXLggMDERkZCRyc3MlD0lERLVTaZGfPn06tm/f\nXm5ZREQEzpw5gxMnTsDPzw+LFi2SNCAREdVepUU+NDQUrq6u5ZaFh4dDrb61WkhICFJSUqRLR0RE\ndeJYl5VXr16NqKio+z4XExNT9nNYWBjCwsLqsikiqiUhBJYvX4nlyz+HSqXC66/PxtNPPyV3LAIQ\nGxuL2NhYSbehEkKIyhokJydj5MiROHXqVLnlb7/9No4dO4Yff/zx3k5VKlTRLRHZyaeffoGXXloG\nk2k1gBIYjdOwevUijB8/Tu5o9CdS1M5anV3z1VdfYevWrfjmm29sGoaIbO/LL9fCZFoMoA+AUJhM\n87Fmzb07Z6RMNZ6u2b59O5YuXYq9e/dCr9dLkYmIbKhJEyOA9LLHKlU6nJ2N8gUiu6p0uiYqKgp7\n9+5FZmYmPD09MX/+fCxatAhmsxnNmzcHAPTt2xerVq0q3ymna4jqjUOHDmHQoJEwmZ6FSlUKo/FT\nxMf/goCAALmj0Z9IUTurnJOvVacs8kT1ysmTJ7FmzTdQq9V46qmp6Ny5s9yR6D5Y5ImIFKzeHHgl\nIqKGgUWeiEjBWOSJiBSMRZ6ISMFY5IkUbuPGjRg6dByeeOJJHD58WO44ZGc8u4ZIwX74YS2mT38Z\nJtPbAG7CaIzB3r3b0LNnT7mj0X3w7BqiBig+Ph49eoTB1zcAzz33CoqLi+227YULV8Jk+hjAFACz\nYDK9ipUrP7fb9kl+LPJEEvr9998REfE4jh37Cy5f/gqrV5/FX/7yot22f2uv0OGuJQ6wWvlXdmPC\nIk8koc2bN6OkZDyAKAAPorBwNX744Xu7bX/OnKdhNM4C8B8AX8JoXIyZM6fZbfskvzrdT56IKmcw\nGODgkHnXkkzodAa7bX/KlMnQaDRYteor6PVavPnmWvTt29du2yf58cArkYSys7PRvXtvZGaGo6Sk\nM4zGD7Fo0ct4/vlZckejeoj3riECkJaWhvPnz6NNmzZo27at3HGqlJGRgQ8+WIH09Gw89lgEHnvs\nMbkjUT3FIk+N3vr1GzBp0lPQaLrAbD6P+fPnYe5c+x3IJJISizw1aoWFhWjRohVMpp0AegJIgcHQ\nAwkJ+9CpU6cK1zt//jzi4+Ph4eGBoUOHwsHBocK2RHKSonbywCs1GGlpaVCpmuBWgQcAb2i1QUhM\nTKywyG/YsAETJz4NlWooVKrT6NPnM2zf/hMLPTUaPIWSGowHHngADg7FAH65veR3mM3HKv0CjGnT\nZsJk2oCCgjXIzz+MQ4fSsGHDBrvkJaoPWOSpwdDpdFi//ns4O0fB2bkz9PoQrFz5Ltq1a3ff9lar\nFXl51wH0uL3EERZLENLS0uyWmUhunJMn2eXn5yMmZiFOn76IXr38MW/eq5V+SXxBQQGSk5PxwAMP\nwNXVtdK+e/QYgBMnBsBiiQFwBgZDOA4c2Ibg4GDbvggiG+CBV1Kc0tJS9O49EGfPtkZx8UgYDN+j\nb18Ldu3aCJVKVef+U1NTMXz4OJw6dQR6vRM+/fQjTJo00QbJiWyPRZ4U5+jRoxg4cDLy88/g1uxh\nCQyG1jh9+kCF0zC1UVxcDK1Wa5P/OIikwrNrSHEsFgtUKg2AO8VXDZXKERaLxabb0el0Nu2PqKHg\ngVeSVXBwMLy8HKDRvABgF3S6GejSpR3at28vdzQiRWCRJ1lptVrEx/+M8eOLERT0T0ye7IzduzdB\nreZbk8gWOCdPRFRP8JuhiIioRljkiYgUjGfXUKNVWFiI7du3o6ioCI888gg8PT3ljkRkc5XuyUdH\nR8PT0xP+/v5ly7KzsxEeHg4/Pz9ERETgxo0bkocksrW8vDwEBvbDlCnL8cwza9G5czDOnj0rdywi\nm6u0yE+fPh3bt28vt2zx4sUIDw/HhQsXMGjQICxevFjSgERSWLbsA1y+7I/8/D3Iz/8Jubnz8Je/\nvFKtdUtLS/HFF1/gb3/7OzZt2iRxUqK6qbTIh4aG3nNvkI0bN2Lq1KkAgKlTp2L9+vXSpSOSSHLy\nHzCbQ3DnIiwh+iA19Y8q17NYLIiIeALPP/8N/vlPFaKiXsW8efMlTktUezWek09PTy+bu/T09ER6\nevp928XExJT9HBYWhrCwsFoFJJLCI4/0w48/vo+CgnEAmkKnexdhYQ9Vud7+/ftx5EgSTKbjABxR\nUDALS5e2xRtvvAInJyfJc5OyxMbGIjY2VtJt1OnAq0qlqvBeIHcXeaL6ZsqUyTh16jyWL/eBEMCA\nAUOxYsU7Va6Xl5cHtdoH//fRcYdarUd+fj6LPNXYn3eA58+3/V+FNT6F0tPTs+x+3NeuXYOHh4fN\nQ1H9k5SUhGHDxqJTp96Ijp6F/Pz8WvVz8uRJDBgwAp07h+Dll1+H2Wy2cdKqHT16FKGhw7Bly27M\nmfMqbtzIxI4d66pVpENCQgAkAPgXgBQ4Os5D+/bt+TmgeqvGRf6xxx7DmjVrAABr1qzBqFGjbB6K\n6pfc3Fz06TMQO3cG48KF5fj22zwMHz62xlfmXb16Ff37h2PfvuH4/ff38MknxxEdPUui1Pd36dIl\nhIUNxYEDY3D+/LtYsSIOc+e+We31PTw8sGfPVnTpsgIuLr3Qv/8p7Nq1gXe3pPpLVGLChAmiZcuW\nQqPRCG9vb7F69WqRlZUlBg0aJDp27CjCw8NFTk7OPetV0S01MJs2bRIuLoMEIG7/KxFarYvIzMys\nUT8ff/yxMBim3tVPttBoDMJqtUqUvLwfflgrnJ29BOAsgKkCyBfAVeHk5GaX7dvKunXrRMuWHYWT\nk5uIjHxS5OXlyR2JbESK2lnpnPx333133+W7du2S4L8bqq+0Wi2EuAlA4NbZKIUQohQajabCdW7e\nvAmdTgetVluuH5Xq5t2t4OBQcR+2dOjQIUybNhsm038AtAPwIoDZAF6BRqOtfOV65NixY5g48S8o\nLPwBQCds2fIKpkz5H6xb943c0aie4m0NqEoDBgyAj4+ATjcVwBcwGodh4sTJcHFxuadtdnY2+vQZ\nhObNveDk1BRvvrmg7LnIyEg0bXoCjo7PA/gcRuNwvPrqXLtMdezYsRNFRdMBPASgJYB3AWyA0fgE\n5s2bK/n2beXnn39GScmTAAYA8EJx8XvYuXOb3LGoHuNtDahKOp0OBw/uwuLF7+LixTg8/PAEzJo1\n875tp09/DgkJnVBauhNAJt5/fyAefLA7IiMj0axZMxw/Ho9Fi95FauoBjBjxKiZPftIur6F5c1do\ntXEoKrqz5BIMBg2++GIBJkwYb/PtXbt2DSkpKejQoUOV30NblcuXLyMjIwOdOnWCq6srtNp4lJbe\n+avqEpo0aWaTzKRQNp8AEpyTb8xatPAVwMW75t0Xipdemit3LJGbmyvatesuDIbRwsFhrjAYPMT6\n9esl2daHH64Ser2rcHEJFk5OLcSOHTtq3dfcuW8Kvd5NuLgEiWbNWoq4uDjh5xckDIZRwsHhVWE0\neol///sHG6YnOUlRO7knTzbVqpU3MjMPAOgAwAqD4SB8fQfLHQsuLi44fjweX3/9NXJzcxERsQU9\ne/a0+XYuXLiA116LQVHRMRQV+QKIw+jRTyAzM7XGX0EYGxuLVau+RVHR7ygqcgPwb0RFzcCGDd9i\n5cqVcHTMQXT0OvTp08fmr4OUg0WebOrLLz9EWNhQCLEOQvyBTp0MeOaZZ+SOBQBwdnbGrFnSnrJ5\n8eJFaLUPorDQ9/aSUFiteqSlpaFNmzY16uvcuXOwWgcBcLu9ZAxSUqLQv/+jcHQMg9V6DELoWOSp\nUizyZFPBwcH4/ffjiIuLQ5MmTTB48OBKz8JRmo4dO8JsPgYgGYAvgDio1UXw8vKqcV9dunSBWv0u\ngCzcKvTfA9CisHA3gO4A8vHdd4F46qlJLPRUIRZ5sjkvLy+MHTtW7hiy8PPzw5IlMXj11Qeh0/mi\ntPQqfvzx2xpP1QC3Lnl/9tmJWLGiE7RabwDXUFRkgNnc/XaLJlCrA5CSkmLT10DKwu94VTiz2Yxl\nyz7Ab7+dQWBgJ8yd+zL0er3NtyOEwDfffIuNG3fBy8sNb7zxSq32XpXClmfXXLlyBdevX0enTp3Q\nufOD+OOPvwJ4CkACDIYInDp1CO3bt7dJbpKXFLWTRV7BhBAYMuQJ7N9vRmHhGOj1G9C7txl79myB\nWm3bSyTefnsJFi78GibTi3B0PAs3t/U4c+Yo3Nzcql6Zqu3s2bOIiBiF69evwdHRAV9//QXGjBkt\ndyyyERZ5qpGLFy8iKGggTKb/AtACKIWTkx8OHtxQ7tu+bKFJkxYoKDgM4NYepcEwHh98MKjeHHRV\nEiEEcnNz4ezsDAcHB7njkA1JUTs5J69gZrMZarUewJ0Dnw5Qqw2S3PmxtNQMwLnssRDOstxhsjFQ\nqVRo1owXQFH18LYGCtapUyf4+LhCo3kBQDw0mlfh4eFo8714AJg48UkYDJMA7AfwKRwdN2LEiBE2\n346tZWVlYejQMWjatCU6dnwQBw4cqNZ6JpMJTz75NJo1ewCtW3fFhg0bJE5qH7m5uRg1ahKaNWuJ\ndu0C8csvv8gdierK5pdXCV7xWp9kZGSIceOmCT+/XiIycrJIS0uTZDtms1m8+uqbonPnEBEaOkwk\nJCRIsh1b69NnkNBonhPAVQH8KJycWojLly9Xud6ECdFCrx8tgGQB7BYGg4c4cuSIHRJLKzx8lNBq\npwvgigC2CKOxhTh//rzcsRoNKWon5+Sp0SosLISzsysslgIAt+a2mzSZgI8/HoEnn6z8njouLp64\nefMYgFYAAAeH1zB/vgvmzZsncWrpWK1WaLV6WCw3ABgBAAbD01i27EHMnHn/exWRbUlROzldQ4ph\nNptx+vRp/Pe//63WB0Wr1d4+y+jOeeZWAMlo2rRples6ObkASLqrr6RqrVcXOTk5OH78OLKzsyXp\nX61WQ693xq0LuQBAQK2W/nWRtFjkSRFSU1PRufOD6Ns3Et2798P48dNgsVgqXcfBwQELFy6E0TgQ\nwN9hNA5H5856PProo1Vub/nyhTAax0Klmge9fgI8Pc9gypQpNno191q/fgO8vTtgwIDJ8PbugO++\n+7ck21m2bAmMxiFQqf4Gg2EUfH1vIjIyUpJtkX1wuoYavLy8PDz88DCcOjUQVusCAIUwGofggw+m\n4Omnn65y/Z07d2L//gNo1eoBTJs2rdpXpx48eBA7duyEq2szTJs2rcI93jNnzuDcuXPo2LEjAgMD\na/LSkJWVhW3btmHGjGdRXLwDQF8Ap2AwhCEp6Sw8PT1r1F91xMbGYs+eWHh4uGP69OkwGo0230Ze\nXh727t0LBwcHhIWFVbqNixcv4sSJE2jTpg169epl8yz1iSS10+az/IIHXsl+UlJSRMuW7YVK1VwA\n5+66xfG7YubMF+SOJ5Yv/0gYDJ7CxWWUMBpbin/+c0m11z1//rxo3ryVcHIKF0BXAfQTQIEAhGja\ntLc4cOCAhMmlc+d35uz8iHB27i/atete4VdJfvPNt8JodBcuLqOEk1Mb8fzz8t+2WkpS1E4WeWrQ\nxo2bJhwd5wlghADevl3gi4TROFCsWrVK1mzp6elCp2sqgKTbuf4Qer2bSEpKqtb6/fsPFSrV8tvr\nWgUwWgCLBHBeGAzNxR9//CHtC5DI2LFThYPDvLLXpdU+K2bOfPGedkVFRUKvdxHAqdttc4TR6COO\nHj0qQ2r7kKJ2ck6eGrRLly6jtHQAgBUAvgLQDWp1G4SFuVVrqkZK165dg07njVt3owSAltDpOlT7\nhmKXL1+BEANuP1IBGACN5iMYDP2wcuV7aNmype1D20Fi4hVYLP/3uszmh3Hp0pV72mVlZUGl0uPW\nHTcBoBkcHQNx5cq9baliLPLUoA0YEAKDYRVufW9rPHQ6I2bNmojNm3+Ao6O8F3TfumlYBoDtt5fs\nRWlpIjp37lyt9fv16w2dbgUAC4AcGAxfYe7cqUhMPI3o6KnShLaDhx/ufft3VgygAEbjZxgwoPc9\n7Tw9PeHsbADw7e0lCSgtPVTj4xqNns3/NhCcriH7KSwsFEOHjhYajZPQaIxi/PhpoqSkRO5YZfbt\n2yeaNfMSOl1z4ezcQuzcubPa6964cUP06xcutFpn4ehoEM8++5KwWq0SprWPmvzOEhIShIeHr9Dp\nmguDoan44Ye1dk5rX1LUTp5dQ4qQm5sLtVoNZ2fnqhvbmcViQWZmJlq0aFGrG4plZ2dDp9PByclJ\ngnTyqe7vzGq1IjMzE66uror/AhrehZKISMF4xSsRVSovLw9jx06Fm1trdOrUE/v27ZM7EsmMe/JE\nCvLoo6MRG9sExcUxAE7AaHwaJ04cRIcOHeSORtXA+8kTUYWsVit27doEiyUXgAFAWwCb8Msvv7DI\nN2KcriGyM6vVikuXLiEpKcmme20qlQo6nROAq7eXCKhUV9CkSRObbYManloX+UWLFqFbt27w9/fH\nxIkTUVxcbMtcRIqUl5eHkJBHEBg4EN269UNExCibfXZUKhUWL34bRmMEgAXQ68egdesbvMFYI1er\nIp+cnIzPPvsMx44dw6lTp2CxWPD999/bOhtRvVBcXIxdu3Zh+/btuHnzZp36mjNnHk6dageT6TIK\nCy/jwAFg4cKlNkoKzJ79LNat+xSvvVaERYtCceRILAwGg836p4anVnPyLi4u0Gg0MJlMcHBwgMlk\nQqtWrWydjUh2ubm56NNnEFJTHaBSGeDklIJff42Ft7d3rfo7evQUiov/hlv7V1oUFk7Ar7+us2nm\niIgIRERE2LRParhqVeSbN2+OOXPmoHXr1jAYDBgyZAgGDx5crk1MTEzZz2FhYQgLC6tLTiJZLFiw\nGP/9bwDM5i8AqFBQ8A/Mnv1XrFv3r1r1161bR5w5swklJY8AENDrN8Pfv6NNM1PDERsbi9jYWEm3\nUatTKBMTEzFy5EjExcWhadOmGDt2LMaMGYNJkybd6pSnUJJCjBgRhS1bhgGYfHtJLPz9/4aTJ+Nq\n1V9GRgb69QtHerqAEGb4+blj796tPDhKAOrRxVBHjx5Fv3794ObmBkdHR0RGRiI+Pt6mweo7IQS+\n+moNpk2bibffXoSCggK5I5EEBgzoBaPxSwAFAEqg13+Kfv161Lo/d3d3nD59GDt2fILdu7/G4cO7\nWeBJUrXakz9x4gQmTZqEI0eOQK/XY9q0aejduzdmzZp1q9NGsCc/e/YrWL06FibTVOj1cfDzS8GR\nI7HQarVyRyMbKi0txaRJM7Bu3Y9Qqx3Rt28/bN78g+LuI0P1Q726d80777yDNWvWQK1W48EHH8Tn\nn39edvMgpRd5k8mEpk3dUFr6BwBXAALOziFYu/YtDBkyRO54JIHs7GxYLBa0aNECKpVK7jikUPWq\nyFfaqcKLfE5ODjw9W6OkJAd3jl27uAzDmjXPYNSoUfKGI6IGq97MyTd2rq6u6NWrL7TavwA4DpVq\nBRwdTyI0NFTuaERE5bDI19LWrWsxerQKrVtPxkMPbcOBA7vg5uYmdyySgNVqhdVqlTsGUa1wuoao\nAkIIvPzy6/joow8hhBVRUVPwxRcfKf6LK0g+nK4hsqNPPvkUn376C0pKklBamo7//CcZf//7P+WO\nRVQjLPJEFdi8eQ9MphcAeAJoisLCv2LbtliZUxHVDIs8NTolJSXYu3cvdu3ahfz8/Arb+fh4wtEx\noeyxWp2AVq087RGRyGY4J0+NSn5+Pvr3H4LExAKo1U3QpEk6Dh3aDR8fn3vapqWlITi4H27eDACg\nh0azD4cPx8LPz8/+walR4HnyRJXIy8vDjz/+iKKiIgwdOhS+vr73tHnzzRgsW3YBRUX/AqCGg0MM\nhg37HRs3fnffPnNycrBp0yZYLBYMHToUXl5e0r4IatRY5IkqkJWVheDgh5Cd3QlWqxscHDZjz56t\n6NmzZ7l2o0dPxU8/DQAQfXtJPDp1egnnzx+2e2aiP+PZNUQVeO+95UhLexgFBRtQWLga+flL8Nxz\nr9/T7qGHgmE0/gu3bjhmgU73Ofr0edDueYnshUWeFCE1NQMlJf53LQnA9esZ97R7/vnnMHy4D7Ta\nVtDrvRAUdBkffrjEfkGJ7IxFXoGEEFi58mM8/PBIjB49BefPn5c7kuSGD38ERuNHAP4LIBd6/QI8\n+ugj97RzdHTEDz+sQUrKRVy6dBwHD+6Ci4uL3fMS2Qvn5BXo739/C8uW/QST6e9QqS7C2XkZTp06\ngtatW8sdTVKLFi3FW2+9jZKSYkRGjseaNZ9Ar9fLHYuo2njgtYEqKirC7NmvYtu2n+Hm5oaPPlqM\n/v37S7a9Zs0eQG5uLIBbp/ppNDOxcGF7vPLKK5Jts764877j7YCpIZKidtbqO16pZqZPfxYbNmSj\nsHAtUlPPYsiQJ5CQcKBRn28thKi0EFf1fEW4g0FUHufk7WDduv+gsPALAN0BjIPFMhbbtm2TbHvP\nPz8TRuN4AOugUr0Dg+EnjBs3TrLt1URBQQEefzwKWq0BTk7N8f77K8o9f+PGDYSHj4JGo4OzsztW\nr/6q2n3/8ssv8PDwhaOjBgEB/ZCcnGzb8EQNEIu8Heh0RgBpZY8dHNJgNBol2978+W9iyZJnMGDA\nl3jiidM4fHhvvZmPnznzZezcKVBamgGT6RDefPN9bNmypez5SZOewb597rBYbiA/fzdmz56H/fv3\nV9nvlSvGJD7DAAALkklEQVRX8PjjE5CR8Tms1gKcOfM4Bg9+nHv1REICEnXbYH344UfCaGwrgKVC\nq50ufHw6iRs3bsgdSxaenh0EcFYA4va/xeKFF+aUPe/k5CaAa2XPq9V/FW+99VaV/a5du1a4uDx+\nV79WodM1ExkZGVK+HCKbkqJ2ck7eDmbPfhbt2rXB1q274OnZDrNnL0PTpk3ljiULd3d3pKefAtAF\ngIBOdxJeXgFlz7u6uqOg4BQAr7Ln3d0fq1a/VuvvAIoB6AAkw2o18/RIavR4dg3Z1YEDBzBkyChY\nLI/DweEPeHml4Nix/WXFeMeOHYiMfBJWayQcHC6hXTsTDh/eDYPBUGm/Qgg88cQk/PLL7ygtDYFa\nvRFLlszDc8/NtMfLIrIJnkJJNhMfH4+TJ0+iffv2GDx4sF1POUxMTMTOnTvh5OSE0aNHw8nJqdzz\n586dw+7du9GsWTOMHj262ue6W61WbNy4EVevXkWvXr3Qp08fKeITSYZFnmxi4cKlePvtlRAiAmr1\nfkyaFIH//d/lcsciavRY5KnOsrOz0bKlL8zmcwBaAciD0dgVhw9vR/fu3eWOR9So8S6UVGdZWVnQ\nalvgVoEHABdoNB2Qnp4uZywikgiLfCPTpk0bGI0CwBcALAC2wGo9h4CAgCrWJKKGiEW+kdFqtdi9\nezPatVsOlUoLD4/nsHXrj3B3d5c7GhFJgHPyjZjFYoGDg4PcMYjoNs7Jk02xwBMpH4s8EZGC1brI\n37hxA2PGjEGXLl3QtWtXHDp0yJa5qAHKzMxEVlaW3DGI6C61LvIvvPAChg0bhnPnzuHkyZPo0qWL\nLXNRA1JcXIzhw8eiVav2eOCBdhgxYhyKi4vljkVEqGWRz83NRVxcHKKjowHc+t7MxnrDLQL+8Y+3\nsWePGWbzdZjN6di9uxALFiySOxYRoZbfDJWUlAR3d3dMnz4dJ06cQI8ePbB8+fJy90iPiYkp+zks\nLAxhYWF1zUr1VFzcURQWzsStuz8ChYVPIS7uC3lDETUAsbGxiI2NlXQbtTqF8ujRo+jbty/i4+PR\nq1cvvPjii3BxccGCBQtudcpTKBuVadNm4ttv9SgpeR+AgEbzIqZMseDzz1fKHY2oQak3965JS0tD\n3759kZSUBADYv38/Fi9ejM2bN0sWlOqvjIwM9O4dhuxsVwgh0KJFLn79NRYtWrSQOxpRg1Jvvsjb\ny8sLPj4+uHDhAvz8/LBr1y5069bNpsGo4XB3d8eZM0cQFxcHlUqF/v37S/r1hkRUfbW+4vXEiROY\nMWMGzGYz2rdvjy+//LLs4Cv35ImIaq7eTNdU2SmLPBFRjfG2BkREVCMs8kRECsYiT0SkYCzyREQK\nxiJPRKRgLPJERArGIk9ElUpNTUV8fDyuX78udxSqBRZ5IqrQqlWfokOHAAwb9hLatu2Kn35aJ3ck\nqiFeDEVE95WcnIyuXXuhsPAwgHYAfoPRGI60tMtwdnaWO54i8WIoIrKbxMREaLXdcKvAA0APqNVu\nSE1NlTMW1RCLPBHdl5+fH8zm0wDO314SDyFy4OPjI2csqiEWeSK6Lx8fH6xa9T70+r5wcfGHk9Nj\nWLv2/8HJyUnuaFQDnJMnokplZWXh6tWraNu2Lb/mU2K8CyURkYLxwCsREdUIizwRkYKxyBMRKRiL\nPBGRgrHIExEpGIs8EZGCscgTESkYizwRkYKxyBMRKRiLPBGRgrHIExEpGIs8EZGCscgTESlYoyny\nsbGxcke4r/qYi5mqh5mqrz7mqo+ZpFDrIm+xWBAcHIyRI0faMo9k6usvtD7mYqbqYabqq4+56mMm\nKdS6yC9fvhxdu3aFSqWyZR4iIrKhWhX5lJQUbN26FTNmzOCXgxAR1WO1+maosWPH4o033kBeXh7e\nffddbNq0qXyn3LsnIqoVW+84O9Z0hc2bN8PDwwPBwcEVzmlx756IqH6o8XRNfHw8Nm7ciLZt2yIq\nKgq7d+/GlClTpMhGRER1VKcv8t67d+99p2uIiKh+qPN58px/JyKqv6pV5Ldv347OnTujY8eOWLJk\nSdnyAQMGYOPGjQCA559/Hh07dkRgYCASEhLK2kRHR8PT0xP+/v7l+szOzkZ4eDj8/PwQERGBGzdu\n1Ch4RZnuVtNMMTEx8Pb2RnBwMIKDg7F9+3a7ZLp69SoGDhyIbt26oXv37vjwww/L2td1nKTKJddY\nFRUVISQkBEFBQejatStef/31svZyvacqyyTXON1xv+tZ5PzsVZSpruNU11y+vr4ICAhAcHAwevfu\nXbZczrGqKFONx0pUobS0VLRv314kJSUJs9ksAgMDxdmzZ8u12bJlixg6dKgQQohDhw6JkJCQsuf2\n7dsnjh07Jrp3715unblz54olS5YIIYRYvHixeO2116qKInmmmJgYsWzZsmrnsFWma9euiYSEBCGE\nEDdv3hR+fn7i3LlzQoi6jZOUueQaKyGEKCgoEEIIUVJSIkJCQsT+/fuFEPK+pyrKJOc4CSHEsmXL\nxMSJE8XIkSPLlsk5ThVlqss42SKXr6+vyMrKuqdfOceqokw1Hasq9+R//fVXdOjQAb6+vtBoNJgw\nYQI2bNhQrs3GjRsxdepUAEBISAhu3LiBtLQ0AEBoaChcXV3v6ffudaZOnYr169dXFUXyTEDtzwyq\nbab09HR4eXkhKCgIANCkSRN06dIFqamp96xT03GSMhcgz1gBgNFoBACYzWZYLJay36Uc76mqMgHy\njVNF17PIOU6VXWNT23GyRa6Kti/nWFWUqbLl91NlkU9NTYWPj0/ZY29v73If9Oq2+bP09HR4enoC\nADw9Pcu9MLkyAcCKFSsQGBiIp556qkZ/mtU2U0pKSrk2ycnJSEhIQEhICIC6jZOUuQD5xspisSAo\nKAienp4YOHAgunbtCkCe91RVmQD7j9OdNi+99BKWLl0Ktbr8x1zOz15FmYDaj5MtcqlUKgwePBg9\ne/bEZ599VtZGzrGqKBNQs7GqsshX98Dqn/9nqckBWZVKVeP2UmSaOXMmkpKScPz4cbRs2RJz5syx\na6b8/HyMGTMGy5cvR5MmTe67jZoe6JYql5xj5eDggOPHjyMlJQX79u277/Ua9n5PVZRJjnESQpS7\nnqWyvT57jVNVmeoyTnXJdcf+/fuRkJCAbdu24aOPPkJcXNx9t2GPsaoqU03Hqsoi36pVK1y9erXs\n8dWrV+Ht7V1pm5SUFLRq1arSfj09PcumT65duwYPD4+qokieycPDo+wXOWPGDPz66692y1RSUoLR\no0fjySefxKhRo8ra1GWcpMwl51jd0bRpUwwfPhy//fYbgPrxnrqT6ejRowDkG6fKrmeRa5wqy1SX\ncaprLgB44IEHAADu7u544okncOTIEQDyvqf+nOnOmNR4rKqatC8pKRHt2rUTSUlJori4uMqDBwcP\nHrznQEtSUtJ9D7wuXrxYCCHEokWLanRAQ6pMf/zxR9nP7733noiKirJLJqvVKiZPnixefPHFe/qt\nyzhJmUuuscrIyBA5OTlCCCFMJpMIDQ0Vu3btEkLI956qLJNc43S32NhYMWLEiLLHcn/27pepLuNU\n11wFBQUiLy9PCCFEfn6+6Nevn9ixY4cQQr6xqixTTceqyiIvhBBbt24Vfn5+on379mLhwoVCCCE+\n+eQT8cknn5S1mTVrlmjfvr0ICAgQv/32W9nyCRMmiJYtWwqtViu8vb3F6tWrhRBCZGVliUGDBomO\nHTuK8PDwsg9JdUmRafLkycLf318EBASIxx9/XKSlpdklU1xcnFCpVCIwMFAEBQWJoKAgsW3bNpuM\nk1S55BqrkydPiuDgYBEYGCj8/f3FO++8U9ZervdUZZnkGqe7xcbGljuTRc7PXkWZ6jpOdcmVmJgo\nAgMDRWBgoOjWrVvZukLIN1aVZarpWNXpilciIqrfGs03QxERNUYs8kRECsYiT0SkYCzyREQKxiJP\nRKRgLPJERAr2/wFdpk3WC52XcQAAAABJRU5ErkJggg==\n" } ], "prompt_number": 39 }, { "cell_type": "code", "collapsed": false, "input": [ "z = np.polyfit(both['Mean Ozone'], both['prevalence'], 1)\n", "p = np.poly1d(z)\n", "plt.scatter(both['Mean Ozone'], both['prevalence'])\n", "plt.plot(both['Mean Ozone'],p(both['Mean Ozone']),\"r--\")\n", "#plt.ylim(both['prevalence'].min(), both['prevalence'].max())\n", "#plt.xlim(both['Mean Ozone'].min(), both['Mean Ozone'].max())\n" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "pyout", "prompt_number": 59, "text": [ "[]" ] }, { "output_type": "display_data", "png": "iVBORw0KGgoAAAANSUhEUgAAAXkAAAD9CAYAAABZVQdHAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3XlcVXX+x/HXZblwL4sispii4IIrorlrKu5pWqaZW26U\n05iZlVlTOTNqY2pmpZY1Tdnyq2ZGp0wzt0xxQ80Fd01jQEUFERCEy36/vz9QRmKHezlw+TwfDx4P\nOPd7vud9v1w+Hr9n0ymlFEIIIWySndYBhBBCWI8UeSGEsGFS5IUQwoZJkRdCCBsmRV4IIWyYFHkh\nhLBhJRb50NBQfHx8CAoKKrB81apVtG7dmnbt2vHKK69YNaAQQoiKcyjpxWnTpjFr1iwmT56cv2zX\nrl1s3LiRkydP4ujoSHx8vNVDCiGEqJgS9+R79+6Nh4dHgWUffvghr776Ko6OjgB4eXlZL50QQohK\nKXFPvigXL15kz549vPbaazg7O/P222/TuXPnAm10Op3FAgohRG1i6ZsQlPvAa05ODklJSRw8eJBl\ny5bx+OOPF9lOKVWtvv76179qnqGm5JJMkqk25KqOmayh3EW+UaNGjBo1CoAuXbpgZ2dHQkKCxYMJ\nIYSovHIX+ZEjR7Jz504ALly4QFZWFp6enhYPJoQQovJKnJMfP348u3fvJiEhAT8/PxYuXEhoaCih\noaEEBQWh1+v58ssvqyprpYSEhGgdoUjVMZdkKhvJVHbVMVd1zGQNOmWFiSCdTme1+SUhhLBV1qid\ncsWrEELYMCnyQghhw6TICyGEDZMiL4QQNkyKvBBC2DAp8kIIYcOkyAshhA2TIi+EEDZMirwQQtgw\nKfJCCGHDpMgLIYQNkyIvhBA2TIq8EELYMCnyQghhw6TICyGEDZMiL4QQNkyKvBBC2DAp8kIIYcOk\nyAshhA2TIi+EEDZMirwQQtgwB60DCCEgKSmJXbt2YW9vz8CBA3FxcdE6krAROqWUsninOh1W6FYI\nmxQdHU3XriFkZLQGMqhfP54jR/ZQr149raOJKmaN2inTNUJobPbs10hMfIrbt7dw+/ZOrl7tzYIF\ni7WOJWyEFHkhNBYdHUNubq87P+nIyupFZGSMppmE7ZAiL4TG+vXrgbPzKiADSMFo/Jj+/btrHUvY\nCCnyQmhsyZIFDBjggIODB/b23owd247Zs5/VOpawEXLgVYhqIi0tDTs7OwwGg9ZRhEaq/MBraGgo\nPj4+BAUFFXpt+fLl2NnZkZiYaNFAQtRWLi4uUuCFxZVY5KdNm8bWrVsLLb9y5Qo//fQTTZo0sVow\nIYQQlVdike/duzceHh6Flr/44ou89dZbVgslhBDCMsp9xeuGDRto1KgR7du3L7Hd/Pnz878PCQkh\nJCSkvJsSQgibFhYWRlhYmFW3UeqB1+joaEaMGMGpU6cwmUz069ePn376CXd3dwICAjhy5Aienp4F\nO5UDr0IIUW6aX/EaGRlJdHQ0wcHBBAQEEBMTQ6dOnbhx44ZFQwkhhLCMck3XBAUFERcXl/9zQEAA\nR48elXtsCE3cvHmTffv2YTQa6devH46OjsW2jYiIIDIykrZt29K6desqTFm6w4cPc+nSJdq3b09g\nYKDWcYStUSUYN26catCggdLr9apRo0ZqzZo1BV4PCAhQCQkJhdYrpVshKu306dOqbt0Gyt19qHJz\n66Q6deqjTCZTkW3nzVuojMaGyt19pDIYvNVHH/2jitMW7/nnX1FGY+M72bzUV199rXUkoSFr1E65\nGErUSN26DeTw4cdQ6o+AGYNhFG+80Yc5c14s0O7ChQt06NCH9PSTgDfwG05OnYiLu0ydOnW0iJ4v\nIiKCBx54GJPpJOABnMHZuSdJSXE4Oztrmk1oQ/M5eSGqi8uXL6NU3zs/2ZGe/gCRkZcLtbty5Qp6\nfSvyCjxAcxwd6xMbG1tVUYt1+fJlHByCySvwAG3R6QzcvHlTy1jCxkiRFzVSjx5d0etXArlAAi4u\nX/HAA10LtWvbti3Z2aeBA3eWbMDBIb1aXMgXHBxMTs4h4NidJf/C1dUJX19fLWMJGyNFXtRIn3yy\nkg4dfkWvr4eDgx/Tpz/I+PHjC7Xz9fVl3bovcXEZjpOTJ/XqzWTLlu+qxXSIv78/X375dwyG/jg5\neeLt/Se2bfseBwd5YJuwHJmTFzWWUoqkpCScnZ0xGo0lts3JySExMZH69etjZ1e99m2ys7NJSkqq\nltlE1bJG7ZQiL4QQ1YQceBVCCFEuUuSFEMKGSZEXQggbJkVeCCFsmBR5IYSwYVLkhRDChkmRF0II\nGyZFXgghbJgUeSGEsGFS5IUQwoZJkRdCCBsmRV4IIWyYFHkhhLBhUuSFEMKGSZEXQggbJkVeCCFs\nmBR5IYSwYVLkhRDChkmRF0IIGyZFXgghbJgUeSGEsGFS5IUQwoZJkRdCCBtWYpEPDQ3Fx8eHoKCg\n/GVz586ldevWBAcHM2rUKJKTk60eUgghRMWUWOSnTZvG1q1bCywbPHgwZ86c4cSJEwQGBrJ48WKr\nBhRCCFFxJRb53r174+HhUWDZoEGDsLPLW61bt27ExMRYL50QQohKcajMymvWrGH8+PFFvjZ//vz8\n70NCQggJCanMpoQQFaSUYsWK91mx4hN0Oh2vvjqL6dOf1DqWAMLCwggLC7PqNnRKKVVSg+joaEaM\nGMGpU6cKLF+0aBHHjh3j22+/LdypTkcp3QohqsjHH3/KCy8sx2RaA2RjNE5lzZrFjB37uNbRxO9Y\no3ZW6Oyazz//nM2bN/P1119bNIwQwvI++2wdJtMSoDvQG5NpAV98UXjnTNimck/XbN26lWXLlrF7\n926cnZ2tkUkIYUGurkYgLv9nnS4ONzejdoFElSpxumb8+PHs3r2bmzdv4uPjw4IFC1i8eDFZWVnU\nq1cPgB49erB69eqCncp0jRDVxsGDBxkwYAQm0zPodDkYjR8THv4z7du31zqa+B1r1M5S5+Qr1KkU\neSGqlZMnT/LFF19jZ2fHk09OoVWrVlpHEkWQIi+EEDas2hx4FUIIUTNIkRdCCBsmRV4IIWyYFHkh\nhLBhUuSFsHEbN25k6NDHefTRJzh06JDWcUQVk7NrhLBha9euY9q0FzGZFgG3MRrns3v3Fjp37qx1\nNFEEObtGiBooPDycTp1C8Pdvz7PPvkRmZmaVbfvNN9/HZPoQmAzMxGR6mfff/6TKti+0J0VeCCv6\n9ddfGTz4EY4de5pLlz5nzZqzPP3081W2/by9Qvt7lthjNsv/smsTKfJCWNGmTZvIzh4LjAfuJz19\nDWvX/qvKtj9nznSMxpnAf4DPMBqXMGPG1CrbvtBepe4nL4QomcFgwN7+5j1LbuLkZKiy7U+ePAlH\nR0dWr/4cZ2c98+ato0ePHlW2faE9OfAqhBUlJibSrl1Xbt4cRHZ2K4zGlSxe/CLPPTdT62iiGpJ7\n1wgBxMbGcv78eZo0aUJAQIDWcUoVHx/Pe++tIi4ukYcfHszDDz+sdSRRTUmRF7Xe999vYOLEJ3F0\nbE1W1nkWLHiduXOr7kCmENYkRV7Uaunp6dSv3xCTaTvQGYjBYOhERMQeWrZsWex658+fJzw8HG9v\nb4YOHYq9vX2xbYXQkjVqpxx4FTVGbGwsOp0reQUeoBF6fQciIyOLLfIbNmxgwoTp6HRD0elO0737\nP9i69Tsp9KLWkFMoRY1x3333YW+fCfx8Z8mvZGUdK/EBGFOnzsBk2kBa2hekph7i4MFYNmzYUCV5\nhagOpMiLGsPJyYnvv/8Xbm7jcXNrhbNzN95//22aNm1aZHuz2UxKyg2g050lDuTmdiA2NrbKMguh\nNZmTF5pLTU1l/vw3OX36Il26BPH66y+X+JD4tLQ0oqOjue+++/Dw8Cix706d+nLiRF9yc+cDZzAY\nBrF//xY6duxo2TchhAXIgVdhc3JycujatR9nzzYmM3MEBsO/6NEjlx07NqLT6Srd/9WrV3noocc5\ndeowzs4ufPzxB0ycOMECyYWwPCnywuYcOXKEfv0mkZp6hrzZw2wMhsacPr2/2GmYisjMzESv11vk\nHw4hrEXOrhE2Jzc3F53OEbhbfO3Q6RzIzc216HacnJws2p8QNYUceBWa6tixI76+9jg6zgZ24OT0\nFK1bN6VZs2ZaRxPCJkiRF5rS6/WEh//E2LGZdOjwNyZNcmPnzh+ws5OPphCWIHPyQghRTciToYQQ\nQpSLFHkhhLBhcnaNqLXS09PZunUrGRkZ9O/fHx8fH60jCWFxJe7Jh4aG4uPjQ1BQUP6yxMREBg0a\nRGBgIIMHD+bWrVtWDymEpaWkpBAc3JPJk1fwhz+so1Wrjpw9e1brWOL3cnPh4kW4elXrJDVWiUV+\n2rRpbN26tcCyJUuWMGjQIC5cuMCAAQNYsmSJVQMKYQ3Ll7/HpUtBpKbuIjX1O5KTX+fpp18q07o5\nOTl8+umn/PnPf+GHH36wctJaQqm8Qv7ZZ/D22zBlCnTqBG5uMHgw7N6tdcIaq8Tpmt69exMdHV1g\n2caNG9l9Z8CnTJlCSEiIFHpR40RHXyMrqxt3L8JSqjtXr/6j1PVyc3MZPPhRDh1Kw2TqjYvLy8ye\nfYxFi/5q5cQ25LffYNEi+PxzGDQI0tPh9GlwcoLkZHj6aejdG555Btq0ySv0osLKPScfFxeXP3fp\n4+NDXFxcke3mz5+f/31ISAghISEVCiiENfTv35Nvv32XtLTHgTo4Ob1NSEivUtfbt28fhw9HYTId\nBxxIS5vJsmUBvPbaS7i4uFg9d41y4waEh8OtW3DqFPz4I/z6a8E2TZvC2LHQrh14eWmTU0NhYWGE\nhYVZdRuVOvCq0+mKvRfIvUVeiOpm8uRJnDp1nhUr/FAK+vYdyqpVb5W6XkpKCnZ2fvzvT8cLOztn\nUlNTa2+RN5ny9spnFvNw8kcfhW7d4K23wMMDevUCudgNKLwDvGDBAotvo9xF3sfHh9jYWHx9fbl+\n/Tre3t4WDyWqn6ioKGbOfJnIyEv06tWFlSuX4urqWu5+Tp48yaxZrxEXF8+wYf1ZsmQBer3eComL\nd+TIEZ5//s8kJCQxZ87LzJv3cpnfS7du3YDpwFdACA4Oq2nWrFnt+DvIzYWTJ/MOhP72W973//53\n4Xb29rB2LQwbBiXcMlpUEVWKqKgo1a5du/yf586dq5YsWaKUUmrx4sXqlVdeKbROGboVNcitW7eU\nt3cTZW+/SEG4cnJ6QvXp86Aym83l6ufy5cvKzc1bwWoF+5TB8KCaOPEpK6Uu2sWLF5WLS30FnyjY\nq4zGEPXHP84uVx9Hjx5VrVt3Ve7uviokZLi6du2aldJqxGxWatMmpfIOhxb+athQqblzlfriC6W+\n/FKphAStE9sMa9TOEnscN26catCggXJ0dFSNGjVSa9asUQkJCWrAgAGqRYsWatCgQSopKalKggrt\n/PDDD8rdfcA9f+fZSq93Vzdv3ixXPx9++KEyGKbc00+icnQ0lPsfi4pau3adcnPzVeCmYIqCVAVX\nlIuLZ5Vs31LWr1+vGjRooVxcPNWoUU+olJSUine2Y4dSBkPxBf3uV+vWSkVFWew9iKJZo3aWOF3z\nz3/+s8jlO3bssPj/KET1pdfrUeo2oMg7GyUdpXJwdHQsdp3bt2/j5ORUYCom737ut+9thb198X1Y\n0sGDB5k6dRYm03+ApsDzwCzgJRwdq3a6qDKOHTvGhAlPk56+FmjJjz++xOTJf2T9+q9LXvHCBZg9\nG353SnQBfn55Z7MsWgT33w9y732bIEc/RKn69u2Ln5/CyWkK8ClG4zAmTJiEu7t7obaJiYl07z6A\nevV8cXGpw7x5C/NfGzVqFHXqnMDB4TngE4zGh3j55blV8iCPbdu2k5ExDegFNADeBjZgND7K66/P\ntfr2LeWnn34iO/sJoC/gS2bmO2zfvuV/DZKTYfz4vAObOt3/vlq2LFzgu3eH1NT/7a9fvpzXplMn\nKfA2RG5rIErl5OTEgQM7WLLkbS5e3EufPuOYOXNGkW2nTXuWiIiW5ORsB27y7rv9uP/+dowaNYq6\ndety/Hg4ixe/zdWr+xk+/GUmTXqiSt5DvXoe6PV7yci4u+Q3DAZHPv10IePGjbX49q5fv05MTAzN\nmzcv9Tm0pbl06RLx8fG0bNkSDw8P9PpwVE42/2QCY/gPmCi5KA8YAN98A7Xh4LAozOITQErm5Guz\n+vX9FVy8Zzr3TfXCC3O1jqWSk5NV06btlMEwWtnbz1UGg7f6/vvvrbKtlStXK2dnD+Xu3lG5uNRX\n27Ztq3Bfc+fOU886uJQ+Z37366efLPhORFWzRu2UPXlhUQ0bNuLmzf1Ac8CMwXAAf/+BWsfC3d2d\n48fD+fLLL0lOTmbw4B/p3Lmzxbdz4cIFXnllPhkZx8jI8Af2Mnr0o9y8ebX0RxDOmQPvvFNgUXFn\n7u9q2ZJ/9ulDaGgo3bt3t0R0YaOkyAuL+uyzlYSEDEWp9Sh1jZYtDfzhD3/QOhYAbm5uzCzugh0L\nuXjxInr9/aSn+99Z0huz2ZnY2FiaNGmSt+jSJfD3L6aHgg7ZedPTfA0z9kAu4IjBUB+Ha+0xf7MT\npZykyIsSyZOhhMXFxsayd+9eXF1dGThwYIln4diaCxcu0KFDb9LTD1EfF+Ipxzx4dDTc/YeAvEve\nhw9/krS0XwBP4GvgSeAI0A5IxcUlmB07vpZCbyOsUTtlT15YnK+vL2PGjNE6RtVRCubPh4ULCSTv\nOCgEFN/+wIG8M1tKERISwjPPTGDVqpbo9Y2A62RkGMjKanenhSt2du2JiYmp7DsQNkz25G1cVlYW\ny5e/x9GjZwgObsncuS/ibIVLzZVSfP31N2zcuANfX09ee+0lfH19Lb4dzXXoACdOlKlpYr9+6L79\nttJn11y+fJkbN27QsmVLWrW6n2vX/kTeHn0EBsNgTp06SLNmzSq1DVE9WKN2SpG3YUophgx5lH37\nskhPfwxn5w107ZrFrl0/YmfhG0QtWrSUN9/8EpPpeRwczuLp+T1nzhzB09PTotupMtu3w5AhZWv7\nl7/k7clXwbnlZ8+eZfDgkdy4cR0HB3u+/PJTHntstNW3K6qGFHlRLhcvXqRDh36YTP8F9EAOLi6B\nHDiwocDTvizB1bU+aWmHgLw9SoNhLO+9N6DaHHQt1sGD0KNH2dvfugV16lgvTxkopUhOTsbNzQ17\ne3tNswjLkjl5US5ZWVnY2TkDdw982mNnZyArK8vi28rJyQL+93AHpdyssp0Ky8gAg6Hs7c+dg1at\nrJenEnQ6HXXr1tU6hqgh5LYGNqxly5b4+Xng6DgbCMfR8WW8vR0svhcPMGHCExgME4F9wMc4OGxk\n+PDhFt9Omdx7Of/dr2IKvGnOHIY+OJo67r60aN6R/fv25R1ILaXAm0wmnnhiOnXr3kfjxm3YsGGD\nNd5JlUtOTmbkyInUrduApk2D+fnnn7WOJCrL4pdXKbnitTqJj49Xjz8+VQUGdlGjRk1SsbGxVtlO\nVlaWevnleapVq26qd+9hKiIiwirbKWDdurJfCTpmTJFddO8+QDk6PqvgioJvlYtLfXXp0qVSNz1u\nXKhydh6tIFrBTmUweKvDhw9b+h1WuUGDRiq9fpqCywp+VEZjfXX+/HmtY9Ua1qidMicvqr9//hMm\nTCh7++xscCh9JjI9PR03Nw9yc9OAvLltV9dxfPjhcJ54ouR76ri7+3D79jGgIQD29q+wYIE7r7/+\netlzVjNmsxm93pnc3FuAEQCDYTrLl9/PjBlF36tIWJY1aqdM14jqIzGx6KmWogq8vX3eQdB79tez\nMjM5feoU/718uUx/KHq9/s5ZRnfPMzcD0dQpw4FVFxd3IOqevqLKtF5lJCUlcfz4cRITE63Sv52d\nHc7ObkD0nSUKOzvrvy9hZRb/v4GS6RpRipycsk+zQN4TiEoRExOjAgLaKlfXFspg8FFjxkxWOTk5\npa63bNm7ymgMUPBnZTQ+qDp37quysrJKXe/f/16rjEZfpdO9ppydxyp//zYqOTm5TG+/Itav/14Z\njfWUu3s7ZTB4qG+++ZdVtvPRR/9QRmMjpdPNUwbDw6pt264qPT3dKtsShVmjdsp0jbCuP/4R/v73\nsrVdtw4ee6zcm0hJSaFPn2GcOtUPs3khkI7ROIT33pvM9OnTS11/+/bt7Nu3n4YN72Pq1Kml30js\njgMHDrBt23Y8POoyderUYvd4z5w5w7lz52jRogXBwcHleWskJCSwZcsWnnrqGTIztwE9gFMYDCFE\nRZ3Fx8enXP2VRVhYGLt2heHt7cW0adMwGo0W30ZKSgq7d+/G3t6ekJCQErdx8eJFTpw4QZMmTejS\npYvFs1QnVqmdFv9nQ8mefK105EjZ98w9Lfe4vZiYGNWgQTOl09VTcO6ezbytZswo37NbrWHFig+U\nweCj3N1HKqOxgfrb35aWed3z58+revUaKheXQQraKOipIE2BUnXqdFX79++3YnLrufs7c3Prr9zc\nHlBNm7Yr9lGSX3/9jTIavZS7+0jl4tJEPfec9rettiZr1E4p8qJ8Ll8uezF/5BGlMjOtGufxx6cq\nB4fXFQxXsOjOpjOU0dhPrV692qrbLk1cXJxycqqjIOpOrmvK2dlTRZXxWakPPDBU6XQr7qxrVjBa\nwWIF55XBUK/GPkB8zJgpyt7+9fz3pdc/o2bMeL5Qu4yMDOXs7K7g1J22Scpo9FNHjhzRIHXVsEbt\nlAOvomiZmTBxYuGDoI0bF90+NrZwmf/+e9Bb9/mpv/12iZycvsAq4HOgLXZ2TQgJ8SzTVI01Xb9+\nHSenRoD/nSUNcHJqXuYbil26dBml+t75SQf0xdHxAwyGnrz//js0aNDA8qGrQGTkZXJz//e+srL6\n8Ntvlwu1S0hIQKdzJu+OmwB1cXAI5vLlwm1F8aTI13ZKwbJlhYu5s3PeI+Pu1b8/nD5d9H67FeaG\ny6Jv324YDKvJe25rOE5ORmbOnMCmTWtxKMNplNaUd9OweODus1V3k5MTSasyXknbs2dXnJxWkXcf\n+SQMhs+ZO3cKkZGnCQ2dYp3QVaBPn653fmeZQBpG4z/o27droXY+Pj64uRmAu5/DCHJyDpb7uEat\nZ/H/GyiZrqm2Tp1Savjwsk21rFunddoySU9PV0OHjlaOji7K0dGoxo6dqrKzs7WOlW/Pnj2qbl1f\n5eRUT7m51Vfbt28v87q3bt1SPXsOUnq9m3JwMKhnnnlBmc1mK6atGuX5nUVERChvb3/l5FRPGQx1\n1Nq1NeNzWVHWqJ1ydo0tunUL1q+H0NDS2777LsyeXSV3ULSm5ORk7OzscHNzK71xFcvNzeXmzZvU\nr1+/QjcUS0xMxMnJCRcXFyuk005Zf2dms5mbN2/i4eFh8w+gkbtQioIyM2HbtrwrQn/9FQYPhqVL\ni277t7/B3LlWnyMXQlScXPFaW5nNsH8/PPts4XnzRx6Bf/0LrlyBrl3zbp17+3bhCZjXX5cCXwuk\npKQwZswUPD0b07JlZ/bs2aN1JKEx2ZOvbs6fzyvaO3dCUBCsXl10u2nTYPFizQ54iurpwQdHExbm\nSmbmfOAERuN0Tpw4QPPmzbWOJspA7idvS+Li8q7w/PRTOH686DZjx8KuXdCgAbRsWbX5RI1jNpvZ\nseMHcnOTAQN5z5n9gZ9//lmKfC0mRd7asrLy5stPn8772r07b+rl9wIC4Ouv8x7wXMMPgoqSmc1m\n/vvf/2Jvb4+/vz86C/2+dTodTk4umExXgEBAodNdxtW1v0X6FzVThadrFi9ezFdffYWdnR1BQUF8\n9tln+ff8qJXTNWYzREXBqVN5xfzPf4a2bSEyEpo0yZt6adcOOnXKmyMfMkTmyGuhlJQUBgx4mLNn\nI1Eqh169urJp09oy3y+nNKtWreZPf3oLkykUZ+cTBARc5ujRPRjK81QsoZlqc3ZNdHQ0/fv359y5\nczg5OTF27FiGDRvGlClTrBa02rp2Le/g59mzUL9+XiFv1w5yc+GJJ/KeMOTsrHVKUQmZmZns3buX\nnJwcevXqVanTNKdPn8X//V8amZmfADkYDGOYO7cLCxbMs1je7du3s3NnGL6+3kyfPt3mTr20ZdVm\nTt7d3R1HR0dMJhP29vaYTCYaNmxo0WA1hpcXrFwJbdpo/oBnYXnJycl07z6Aq1ft0ekMuLjE8Msv\nYTRq1KhC/R05corMzD+Td2KbnvT0cfzyy3qLZh48eDCDBw+2aJ+i5qpQka9Xrx5z5syhcePGGAwG\nhgwZwsCBAwu0mT9/fv73ISEhhISEVCZn9eXoCD16aJ1CWMnChUv473/bk5X1KaAjLe2vzJr1J9av\n/6pC/bVt24IzZ34gO7s/oHB23kRQUAuLZhY1R1hYGGFhYVbdRoWmayIjIxkxYgR79+6lTp06jBkz\nhscee4yJEyfmdVqbpmuETRs+fDw//jgMmHRnSRhBQX/m5Mm9FeovPj6enj0HERenUCqLwEAvdu/e\njKurq8Uyi5qr2lwMdeTIEXr27ImnpycODg6MGjWK8PBwiwar7pRSfP75F0ydOoNFixaTlpamdSRh\nBX37dsFo/AxIA7Jxdv6Ynj07Vbg/Ly8vTp8+xLZtH7Fz55ccOrRTCrywqgrtyZ84cYKJEydy+PBh\nnJ2dmTp1Kl27dmXmzJl5ndaCPflZs15izZowTKYpODvvJTAwhsOHw9DLGTM2JScnh4kTn2L9+m+x\ns3OgR4+ebNq0Vg5mCquoNmfXALz11lt88cUX2NnZcf/99/PJJ5/k3zzI1ou8yWSiTh1PcnKuAR6A\nws2tG+vWvcGQIUO0jiesIDExkdzcXOrXr2+x89qF+L1qVeRL7NTGi3xSUhI+Po3Jzk7i7rFrd/dh\nfPHFHxg5cqS24YQQNVa1mZOv7Tw8POjSpQd6/dPAcXS6VTg4nKR3795aRxNCiAKkyFfQ5s3rGD1a\nR+PGk+jVawv79+/A09NT61jCCsxmM2azWesYQlSITNcIUQylFC+++CoffLASpcyMHz+ZTz/9wOYf\nXCG0I9M1QlShjz76mI8//pns7ChycuL4z3+i+ctf/qZ1LCHKRYq8EMXYtGkXJtNswAeoQ3r6n9iy\nJUzjVEKf7WksAAAOn0lEQVSUjxR5UetkZ2eze/duduzYQWpqarHt/Px8cHCIyP/Zzi6Chg3lIS2i\nZpE5eVGrpKam8sADQ4iMTMPOzhVX1zgOHtyJn59fobaxsbF07NiT27fbA844Ou7h0KEwAgMDqz64\nqBXkPHkhSpCSksK3335LRkYGQ4cOxd/fv1CbefPms3z5BTIyvgLssLefz7Bhv7Jx4z+L7DMpKYkf\nfviB3Nxchg4diq+vr3XfhKjVpMgLUYyEhAQ6duxFYmJLzGZP7O03sWvXZjp37lyg3ejRU/juu75A\n6J0l4bRs+QLnzx+q8sxC/J6cXSNEMd55ZwWxsX1IS9tAevoaUlOX8uyzrxZq16tXR4zGr8i74Vgu\nTk6f0L37/VWeV4iqIkVe2ISrV+PJzg66Z0l7btyIL9Tuueee5aGH/NDrG+Ls7EuHDpdYuXJp1QUV\noopJkbdBSinef/9D+vQZwejRkzl//rzWkazuoYf6YzR+APwXSMbZeSEPPlj4AdYODg6sXfsFMTEX\n+e234xw4sAN3d/cqzytEVZE5eRv0l7+8wfLl32Ey/QWd7iJubss5deowjRs31jqaVS1evIw33lhE\ndnYmo0aN5YsvPsJZnq8rahA58FpDZWRkMGvWy2zZ8hOenp588MESHnjgAattr27d+0hODgPyTvVz\ndJzBm28246WXXrLaNquLu587uR2wqImqzYO8RflMm/YMGzYkkp6+jqtXzzJkyKNEROyv1edbK6VK\nLMSlvV4c2cEQoiCZk68C69f/h/T0T4F2wOPk5o5hy5YtVtvec8/NwGgcC6xHp3sLg+E7Hn/8catt\nrzzS0tJ45JHx6PUGXFzq8e67qwq8fuvWLQYNGomjoxNubl6sWfN5mfv++eef8fb2x8HBkfbtexId\nHW3Z8ELUQFLkq4CTkxGIzf/Z3j4Wo9Fote0tWDCPpUv/QN++n/Hoo6c5dGh3tZmPnzHjRbZvV+Tk\nxGMyHWTevHf58ccf81+fOPEP7NnjRW7uLVJTdzJr1uvs27ev1H4vX77MI4+MIz7+E8zmNM6ceYSB\nAx+RvXohlBVYqdsaa+XKD5TRGKBgmdLrpyk/v5bq1q1bWsfShI9PcwVnFag7X0vU7Nlz8l93cfFU\ncD3/dTu7P6k33nij1H7XrVun3N0fuadfs3Jyqqvi4+Ot+XaEsChr1E6Zk68Cs2Y9Q9OmTdi8eQc+\nPk2ZNWs5derU0TqWJry8vIiLOwW0BhROTifx9W2f/7qHhxdpaacA3/zXvbweLlO/ZvOvQCbgBERj\nNmfJ6ZGi1pOza0SV2r9/P0OGjCQ39xHs7a/h6xvDsWP78ovxtm3bGDXqCczmUdjb/0bTpiYOHdqJ\nwWAosV+lFI8+OpGff/6VnJxu2NltZOnS13n22RlV8baEsAg5hVJYTHh4OCdPnqRZs2YMHDiwSk85\njIyMZPv27bi4uDB69GhcXFwKvH7u3Dl27txJ3bp1GT16dJnPdTebzWzcuJErV67QpUsXunfvbo34\nQliNFHlhEW++uYxFi95HqcHY2e1j4sTB/P3vK7SOJUStJ0VeVFpiYiINGviTlXUOaAikYDS24dCh\nrbRr107reELUanIXSlFpCQkJ6PX1ySvwAO44OjYnLi5Oy1hCCCuRIl/LNGnSBKNRAZ8CucCPmM3n\naN++fSlrCiFqIinytYxer2fnzk00bboCnU6Pt/ezbN78LV5eXlpHE0JYgczJ12K5ubnY29trHUMI\ncYfMyQuLkgIvhO2TIi+EEDaswkX+1q1bPPbYY7Ru3Zo2bdpw8OBBS+YSNdDNmzdJSEjQOoYQ4h4V\nLvKzZ89m2LBhnDt3jpMnT9K6dWtL5hI1SGZmJg89NIaGDZtx331NGT78cTIzM7WOJYSggkU+OTmZ\nvXv3EhoaCuQ9N7O23nBLwF//uohdu7LIyrpBVlYcO3ems3DhYq1jCSGo4JOhoqKi8PLyYtq0aZw4\ncYJOnTqxYsWKAvdInz9/fv73ISEhhISEVDarqKb27j1CevoM8u7+COnpT7J376fahhKiBggLCyMs\nLMyq26jQKZRHjhyhR48ehIeH06VLF55//nnc3d1ZuHBhXqdyCmWtMnXqDL75xpns7HcBhaPj80ye\nnMsnn7yvdTQhapRqc++a2NhYevToQVRUFAD79u1jyZIlbNq0yWpBRfUVHx9P164hJCZ6oJSifv1k\nfvkljPr162sdTYgapdo8yNvX1xc/Pz8uXLhAYGAgO3bsoG3bthYNJmoOLy8vzpw5zN69e9HpdDzw\nwANWfbyhEKLsKnzF64kTJ3jqqafIysqiWbNmfPbZZ/kHX2VPXgghyq/aTNeU2qkUeSGEKDe5rYEQ\nQohykSIvhBA2TIq8EELYMCnyQghhw6TICyGEDZMiL4QQNkyKvBCiRFevXiU8PJwbN25oHUVUgBR5\nIUSxVq/+mObN2zNs2AsEBLThu+/Wax1JlJNcDCWEKFJ0dDRt2nQhPf0Q0BQ4itE4iNjYS7i5uWkd\nzybJxVBCiCoTGRmJXt+WvAIP0Ak7O0+uXr2qZSxRTlLkhRBFCgwMJCvrNHD+zpJwlErCz89Py1ii\nnKTICyGK5Ofnx+rV7+Ls3AN39yBcXB5m3br/w8XFRetoohxkTl4IUaKEhASuXLlCQECAPObTyuQu\nlEIIYcPkwKsQQohykSIvhBA2TIq8EELYMCnyQghhw6TICyGEDZMiL4QQNkyKvBBC2DAp8kIIYcOk\nyAshhA2TIi+EEDZMirwQQtgwKfJCCGHDpMgLIYQNqzVFPiwsTOsIRaqOuSRT2UimsquOuapjJmuo\ncJHPzc2lY8eOjBgxwpJ5rKa6/kKrYy7JVDaSqeyqY67qmMkaKlzkV6xYQZs2bdDpdJbMI4QQwoIq\nVORjYmLYvHkzTz31lDwcRAghqrEKPRlqzJgxvPbaa6SkpPD222/zww8/FOxU9u6FEKJCLL3j7FDe\nFTZt2oS3tzcdO3Ysdk5L9u6FEKJ6KPd0TXh4OBs3biQgIIDx48ezc+dOJk+ebI1sQgghKqlSD/Le\nvXt3kdM1QgghqodKnycv8+9CCFF9lanIb926lVatWtGiRQuWLl2av7xv375s3LgRgOeee44WLVoQ\nHBxMREREfpvQ0FB8fHwICgoq0GdiYiKDBg0iMDCQwYMHc+vWrXIFLy7Tvcqbaf78+TRq1IiOHTvS\nsWNHtm7dWiWZrly5Qr9+/Wjbti3t2rVj5cqV+e0rO07WyqXVWGVkZNCtWzc6dOhAmzZtePXVV/Pb\na/WZKimTVuN0V1HXs2j5t1dcpsqOU2Vz+fv70759ezp27EjXrl3zl2s5VsVlKvdYqVLk5OSoZs2a\nqaioKJWVlaWCg4PV2bNnC7T58ccf1dChQ5VSSh08eFB169Yt/7U9e/aoY8eOqXbt2hVYZ+7cuWrp\n0qVKKaWWLFmiXnnlldKiWD3T/Pnz1fLly8ucw1KZrl+/riIiIpRSSt2+fVsFBgaqc+fOKaUqN07W\nzKXVWCmlVFpamlJKqezsbNWtWze1b98+pZS2n6niMmk5TkoptXz5cjVhwgQ1YsSI/GVajlNxmSoz\nTpbI5e/vrxISEgr1q+VYFZepvGNV6p78L7/8QvPmzfH398fR0ZFx48axYcOGAm02btzIlClTAOjW\nrRu3bt0iNjYWgN69e+Ph4VGo33vXmTJlCt9//31pUayeCSp+ZlBFM8XFxeHr60uHDh0AcHV1pXXr\n1ly9erXQOuUdJ2vmAm3GCsBoNAKQlZVFbm5u/u9Si89UaZlAu3Eq7noWLceppGtsKjpOlshV3Pa1\nHKviMpW0vCilFvmrV6/i5+eX/3OjRo0K/KGXtc3vxcXF4ePjA4CPj0+BN6ZVJoBVq1YRHBzMk08+\nWa7/mlU0U0xMTIE20dHRRERE0K1bN6By42TNXKDdWOXm5tKhQwd8fHzo168fbdq0AbT5TJWWCap+\nnO62eeGFF1i2bBl2dgX/zLX82ysuE1R8nCyRS6fTMXDgQDp37sw//vGP/DZajlVxmaB8Y1VqkS/r\ngdXf/8tSngOyOp2u3O2tkWnGjBlERUVx/PhxGjRowJw5c6o0U2pqKo899hgrVqzA1dW1yG2U90C3\ntXJpOVb29vYcP36cmJgY9uzZU+T1GlX9mSoukxbjpJQqcD1LSXt9VTVOpWWqzDhVJtdd+/btIyIi\ngi1btvDBBx+wd+/eIrdRFWNVWqbyjlWpRb5hw4ZcuXIl/+crV67QqFGjEtvExMTQsGHDEvv18fHJ\nnz65fv063t7epUWxeiZvb+/8X+RTTz3FL7/8UmWZsrOzGT16NE888QQjR47Mb1OZcbJmLi3H6q46\nderw0EMPcfToUaB6fKbuZjpy5Aig3TiVdD2LVuNUUqbKjFNlcwHcd999AHh5efHoo49y+PBhQNvP\n1O8z3R2Tco9VaZP22dnZqmnTpioqKkplZmaWevDgwIEDhQ60REVFFXngdcmSJUoppRYvXlyuAxrW\nynTt2rX879955x01fvz4KslkNpvVpEmT1PPPP1+o38qMkzVzaTVW8fHxKikpSSmllMlkUr1791Y7\nduxQSmn3mSopk1bjdK+wsDA1fPjw/J+1/tsrKlNlxqmyudLS0lRKSopSSqnU1FTVs2dPtW3bNqWU\ndmNVUqbyjlWpRV4ppTZv3qwCAwNVs2bN1JtvvqmUUuqjjz5SH330UX6bmTNnqmbNmqn27duro0eP\n5i8fN26catCggdLr9apRo0ZqzZo1SimlEhIS1IABA1SLFi3UoEGD8v9IysoamSZNmqSCgoJU+/bt\n1SOPPKJiY2OrJNPevXuVTqdTwcHBqkOHDqpDhw5qy5YtFhkna+XSaqxOnjypOnbsqIKDg1VQUJB6\n66238ttr9ZkqKZNW43SvsLCwAmeyaPm3V1ymyo5TZXJFRkaq4OBgFRwcrNq2bZu/rlLajVVJmco7\nVpW64lUIIUT1VmueDCWEELWRFHkhhLBhUuSFEMKGSZEXQggbJkVeCCFsmBR5IYSwYf8PpgqwFYgC\nl+sAAAAASUVORK5CYII=\n" } ], "prompt_number": 59 }, { "cell_type": "code", "collapsed": false, "input": [ "print 'r= '+str(both['Mean Ozone'].corr(both['prevalence']))" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "r= 0.218297247024\n" ] } ], "prompt_number": 63 }, { "cell_type": "markdown", "metadata": {}, "source": [ "As we are dealing with atmosphere and not a physical law, this is pretty good.\n", "r should be higher once we use the data for 2007" ] }, { "cell_type": "code", "collapsed": false, "input": [], "language": "python", "metadata": {}, "outputs": [] } ], "metadata": {} } ] }