First Jupyter Notebook.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# First Jupyter Notebook\n",
    "\n",
    "This is a `markdown` cell, it shows formatted text. Press the \">|\" button in the tool bar or `shift` + `return` to execute this cell, i.e. display the formatted text. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#This is a code cell containing lines that will be interpreted into matchine instructions \n",
    "#press '>|' in the tool bar or the \"shift\" and \"return\" return keys (simultaneously) to execute these lines\n",
    "import numpy as np\n",
    "import scipy as sp\n",
    "import pandas as pd\n",
    "import sklearn as sk\n",
    "import matplotlib.pyplot as plt\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "6\n"
     ]
    }
   ],
   "source": [
    "practice_list = [0,1,2,3,4,5,6]\n",
    "biggest = practice_list[0]\n",
    "for value in practice_list:\n",
    "    if value > biggest:\n",
    "        biggest = value\n",
    "print (biggest)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[0, 2, 4, 6]\n",
      "[6, 5, 4, 3, 2, 1, 0]\n",
      "[2, 3, 4, 5, 6]\n"
     ]
    }
   ],
   "source": [
    "print (practice_list[::2])\n",
    "print (practice_list[::-1])\n",
    "print (practice_list[(len(practice_list)-5):])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(333, 32)\n",
      "0                  Boston Roxbury\n",
      "1                  Boston Roxbury\n",
      "2                  Boston Roxbury\n",
      "3                  Boston Roxbury\n",
      "4                  Boston Roxbury\n",
      "5                  Boston Roxbury\n",
      "6                  Boston Roxbury\n",
      "7                  Boston Roxbury\n",
      "8                  Boston Roxbury\n",
      "9                  Boston Roxbury\n",
      "10                 Boston Roxbury\n",
      "11                 Boston Roxbury\n",
      "12                 Boston Roxbury\n",
      "13                 Boston Roxbury\n",
      "14                 Boston Roxbury\n",
      "15                 Boston Roxbury\n",
      "16                 Boston Roxbury\n",
      "17                 Boston Roxbury\n",
      "18                 Boston Roxbury\n",
      "19                 Boston Roxbury\n",
      "20                 Boston Roxbury\n",
      "21                 Boston Roxbury\n",
      "22                 Boston Roxbury\n",
      "23                 Boston Roxbury\n",
      "24                 Boston Roxbury\n",
      "25                 Boston Roxbury\n",
      "26                 Boston Roxbury\n",
      "27                 Boston Roxbury\n",
      "28                 Boston Roxbury\n",
      "29                 Boston Roxbury\n",
      "                  ...            \n",
      "303    Lynn Water Treatment Plant\n",
      "304    Lynn Water Treatment Plant\n",
      "305    Lynn Water Treatment Plant\n",
      "306    Lynn Water Treatment Plant\n",
      "307    Lynn Water Treatment Plant\n",
      "308    Lynn Water Treatment Plant\n",
      "309    Lynn Water Treatment Plant\n",
      "310    Lynn Water Treatment Plant\n",
      "311    Lynn Water Treatment Plant\n",
      "312    Lynn Water Treatment Plant\n",
      "313    Lynn Water Treatment Plant\n",
      "314    Lynn Water Treatment Plant\n",
      "315    Lynn Water Treatment Plant\n",
      "316    Lynn Water Treatment Plant\n",
      "317    Lynn Water Treatment Plant\n",
      "318    Lynn Water Treatment Plant\n",
      "319    Lynn Water Treatment Plant\n",
      "320    Lynn Water Treatment Plant\n",
      "321    Lynn Water Treatment Plant\n",
      "322    Lynn Water Treatment Plant\n",
      "323    Lynn Water Treatment Plant\n",
      "324    Lynn Water Treatment Plant\n",
      "325    Lynn Water Treatment Plant\n",
      "326    Lynn Water Treatment Plant\n",
      "327    Lynn Water Treatment Plant\n",
      "328    Lynn Water Treatment Plant\n",
      "329    Lynn Water Treatment Plant\n",
      "330    Lynn Water Treatment Plant\n",
      "331    Lynn Water Treatment Plant\n",
      "332    Lynn Water Treatment Plant\n",
      "Name: Local ID, Length: 333, dtype: object\n"
     ]
    }
   ],
   "source": [
    "my_data = pd.read_csv('mass_aq_data/boston_year_to_date/boston_co.csv')\n",
    "print (my_data.shape)\n",
    "print (my_data['Local ID'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>State Code</th>\n",
       "      <th>County Code</th>\n",
       "      <th>Tribal Code</th>\n",
       "      <th>Site ID</th>\n",
       "      <th>Support Agency Code</th>\n",
       "      <th>Location Address</th>\n",
       "      <th>City Code</th>\n",
       "      <th>Postal Code</th>\n",
       "      <th>Local ID</th>\n",
       "      <th>Local Name</th>\n",
       "      <th>...</th>\n",
       "      <th>Duration Code</th>\n",
       "      <th>Method ID</th>\n",
       "      <th>Measure Unit Code</th>\n",
       "      <th>Sample Collection Start Date</th>\n",
       "      <th>Sample Collection Start Time</th>\n",
       "      <th>Measure Value</th>\n",
       "      <th>Measure Unit</th>\n",
       "      <th>Null Data Code</th>\n",
       "      <th>Qualifier Code</th>\n",
       "      <th>Data Validity Code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-01 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.670</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-02 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>1.053</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-03 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.253</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-04 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.304</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-05 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.343</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-06 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.277</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-07 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.274</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-08 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.252</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-09 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.405</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-10 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.514</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-11 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.406</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-12 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.280</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-13 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.213</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-14 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.269</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-15 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.493</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-16 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.626</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-17 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.601</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-18 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.294</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-19 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.326</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-20 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.404</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-21 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.628</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-22 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.663</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-23 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.194</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-24 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.252</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-25 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.285</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-26 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.360</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-27 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.243</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-28 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.278</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-29 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.311</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-01-30 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.327</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-04-28 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.253</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-04-30 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.165</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-01 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.189</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-02 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.522</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-03 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.241</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-04 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.251</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-05 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.226</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-06 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.197</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-07 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.191</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-08 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.165</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-09 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.248</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-10 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.240</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-11 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.183</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-12 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.197</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-14 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.201</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-15 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.230</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-16 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.239</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-17 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.248</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-18 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.243</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-19 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.200</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-21 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.186</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-22 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.230</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-23 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.315</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-24 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.286</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-25 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.186</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-26 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.178</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-29 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.156</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-30 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.213</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-05-31 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.225</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>\\t\\t\\t\\tMA</td>\n",
       "      <td>'025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>'250250042</td>\n",
       "      <td>'0660</td>\n",
       "      <td>HARRISON AV</td>\n",
       "      <td>7000</td>\n",
       "      <td>'02119</td>\n",
       "      <td>Boston Roxbury</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>'593</td>\n",
       "      <td>'007</td>\n",
       "      <td>2017-06-01 00:00:00</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>0.229</td>\n",
       "      <td>ppm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>147 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    \\t\\tState Code County Code  Tribal Code     Site ID Support Agency Code  \\\n",
       "0           \\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "1       \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "2       \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "3       \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "4       \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "5       \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "6       \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "7       \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "8       \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "9       \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "10      \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "11      \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "12      \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "13      \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "14      \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "15      \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "16      \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "17      \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "18      \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "19      \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "20      \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "21      \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "22      \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "23      \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "24      \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "25      \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "26      \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "27      \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "28      \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "29      \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "..             ...         ...          ...         ...                 ...   \n",
       "117     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "118     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "119     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "120     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "121     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "122     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "123     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "124     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "125     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "126     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "127     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "128     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "129     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "130     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "131     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "132     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "133     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "134     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "135     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "136     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "137     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "138     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "139     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "140     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "141     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "142     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "143     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "144     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "145     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "146     \\t\\t\\t\\tMA        '025          NaN  '250250042               '0660   \n",
       "\n",
       "    Location Address  City Code Postal Code        Local ID Local Name  \\\n",
       "0        HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "1        HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "2        HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "3        HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "4        HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "5        HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "6        HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "7        HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "8        HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "9        HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "10       HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "11       HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "12       HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "13       HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "14       HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "15       HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "16       HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "17       HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "18       HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "19       HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "20       HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "21       HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "22       HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "23       HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "24       HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "25       HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "26       HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "27       HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "28       HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "29       HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "..               ...        ...         ...             ...        ...   \n",
       "117      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "118      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "119      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "120      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "121      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "122      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "123      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "124      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "125      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "126      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "127      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "128      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "129      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "130      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "131      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "132      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "133      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "134      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "135      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "136      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "137      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "138      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "139      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "140      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "141      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "142      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "143      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "144      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "145      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "146      HARRISON AV       7000      '02119  Boston Roxbury     BOSTON   \n",
       "\n",
       "            ...          Duration Code Method ID Measure Unit Code  \\\n",
       "0           ...                      1     '593               '007   \n",
       "1           ...                      1     '593               '007   \n",
       "2           ...                      1     '593               '007   \n",
       "3           ...                      1     '593               '007   \n",
       "4           ...                      1     '593               '007   \n",
       "5           ...                      1     '593               '007   \n",
       "6           ...                      1     '593               '007   \n",
       "7           ...                      1     '593               '007   \n",
       "8           ...                      1     '593               '007   \n",
       "9           ...                      1     '593               '007   \n",
       "10          ...                      1     '593               '007   \n",
       "11          ...                      1     '593               '007   \n",
       "12          ...                      1     '593               '007   \n",
       "13          ...                      1     '593               '007   \n",
       "14          ...                      1     '593               '007   \n",
       "15          ...                      1     '593               '007   \n",
       "16          ...                      1     '593               '007   \n",
       "17          ...                      1     '593               '007   \n",
       "18          ...                      1     '593               '007   \n",
       "19          ...                      1     '593               '007   \n",
       "20          ...                      1     '593               '007   \n",
       "21          ...                      1     '593               '007   \n",
       "22          ...                      1     '593               '007   \n",
       "23          ...                      1     '593               '007   \n",
       "24          ...                      1     '593               '007   \n",
       "25          ...                      1     '593               '007   \n",
       "26          ...                      1     '593               '007   \n",
       "27          ...                      1     '593               '007   \n",
       "28          ...                      1     '593               '007   \n",
       "29          ...                      1     '593               '007   \n",
       "..          ...                    ...       ...               ...   \n",
       "117         ...                      1     '593               '007   \n",
       "118         ...                      1     '593               '007   \n",
       "119         ...                      1     '593               '007   \n",
       "120         ...                      1     '593               '007   \n",
       "121         ...                      1     '593               '007   \n",
       "122         ...                      1     '593               '007   \n",
       "123         ...                      1     '593               '007   \n",
       "124         ...                      1     '593               '007   \n",
       "125         ...                      1     '593               '007   \n",
       "126         ...                      1     '593               '007   \n",
       "127         ...                      1     '593               '007   \n",
       "128         ...                      1     '593               '007   \n",
       "129         ...                      1     '593               '007   \n",
       "130         ...                      1     '593               '007   \n",
       "131         ...                      1     '593               '007   \n",
       "132         ...                      1     '593               '007   \n",
       "133         ...                      1     '593               '007   \n",
       "134         ...                      1     '593               '007   \n",
       "135         ...                      1     '593               '007   \n",
       "136         ...                      1     '593               '007   \n",
       "137         ...                      1     '593               '007   \n",
       "138         ...                      1     '593               '007   \n",
       "139         ...                      1     '593               '007   \n",
       "140         ...                      1     '593               '007   \n",
       "141         ...                      1     '593               '007   \n",
       "142         ...                      1     '593               '007   \n",
       "143         ...                      1     '593               '007   \n",
       "144         ...                      1     '593               '007   \n",
       "145         ...                      1     '593               '007   \n",
       "146         ...                      1     '593               '007   \n",
       "\n",
       "    Sample Collection Start Date Sample Collection Start Time  Measure Value  \\\n",
       "0            2017-01-01 00:00:00                     00:00:00          0.670   \n",
       "1            2017-01-02 00:00:00                     00:00:00          1.053   \n",
       "2            2017-01-03 00:00:00                     00:00:00          0.253   \n",
       "3            2017-01-04 00:00:00                     00:00:00          0.304   \n",
       "4            2017-01-05 00:00:00                     00:00:00          0.343   \n",
       "5            2017-01-06 00:00:00                     00:00:00          0.277   \n",
       "6            2017-01-07 00:00:00                     00:00:00          0.274   \n",
       "7            2017-01-08 00:00:00                     00:00:00          0.252   \n",
       "8            2017-01-09 00:00:00                     00:00:00          0.405   \n",
       "9            2017-01-10 00:00:00                     00:00:00          0.514   \n",
       "10           2017-01-11 00:00:00                     00:00:00          0.406   \n",
       "11           2017-01-12 00:00:00                     00:00:00          0.280   \n",
       "12           2017-01-13 00:00:00                     00:00:00          0.213   \n",
       "13           2017-01-14 00:00:00                     00:00:00          0.269   \n",
       "14           2017-01-15 00:00:00                     00:00:00          0.493   \n",
       "15           2017-01-16 00:00:00                     00:00:00          0.626   \n",
       "16           2017-01-17 00:00:00                     00:00:00          0.601   \n",
       "17           2017-01-18 00:00:00                     00:00:00          0.294   \n",
       "18           2017-01-19 00:00:00                     00:00:00          0.326   \n",
       "19           2017-01-20 00:00:00                     00:00:00          0.404   \n",
       "20           2017-01-21 00:00:00                     00:00:00          0.628   \n",
       "21           2017-01-22 00:00:00                     00:00:00          0.663   \n",
       "22           2017-01-23 00:00:00                     00:00:00          0.194   \n",
       "23           2017-01-24 00:00:00                     00:00:00          0.252   \n",
       "24           2017-01-25 00:00:00                     00:00:00          0.285   \n",
       "25           2017-01-26 00:00:00                     00:00:00          0.360   \n",
       "26           2017-01-27 00:00:00                     00:00:00          0.243   \n",
       "27           2017-01-28 00:00:00                     00:00:00          0.278   \n",
       "28           2017-01-29 00:00:00                     00:00:00          0.311   \n",
       "29           2017-01-30 00:00:00                     00:00:00          0.327   \n",
       "..                           ...                          ...            ...   \n",
       "117          2017-04-28 00:00:00                     00:00:00          0.253   \n",
       "118          2017-04-30 00:00:00                     00:00:00          0.165   \n",
       "119          2017-05-01 00:00:00                     00:00:00          0.189   \n",
       "120          2017-05-02 00:00:00                     00:00:00          0.522   \n",
       "121          2017-05-03 00:00:00                     00:00:00          0.241   \n",
       "122          2017-05-04 00:00:00                     00:00:00          0.251   \n",
       "123          2017-05-05 00:00:00                     00:00:00          0.226   \n",
       "124          2017-05-06 00:00:00                     00:00:00          0.197   \n",
       "125          2017-05-07 00:00:00                     00:00:00          0.191   \n",
       "126          2017-05-08 00:00:00                     00:00:00          0.165   \n",
       "127          2017-05-09 00:00:00                     00:00:00          0.248   \n",
       "128          2017-05-10 00:00:00                     00:00:00          0.240   \n",
       "129          2017-05-11 00:00:00                     00:00:00          0.183   \n",
       "130          2017-05-12 00:00:00                     00:00:00          0.197   \n",
       "131          2017-05-14 00:00:00                     00:00:00          0.201   \n",
       "132          2017-05-15 00:00:00                     00:00:00          0.230   \n",
       "133          2017-05-16 00:00:00                     00:00:00          0.239   \n",
       "134          2017-05-17 00:00:00                     00:00:00          0.248   \n",
       "135          2017-05-18 00:00:00                     00:00:00          0.243   \n",
       "136          2017-05-19 00:00:00                     00:00:00          0.200   \n",
       "137          2017-05-21 00:00:00                     00:00:00          0.186   \n",
       "138          2017-05-22 00:00:00                     00:00:00          0.230   \n",
       "139          2017-05-23 00:00:00                     00:00:00          0.315   \n",
       "140          2017-05-24 00:00:00                     00:00:00          0.286   \n",
       "141          2017-05-25 00:00:00                     00:00:00          0.186   \n",
       "142          2017-05-26 00:00:00                     00:00:00          0.178   \n",
       "143          2017-05-29 00:00:00                     00:00:00          0.156   \n",
       "144          2017-05-30 00:00:00                     00:00:00          0.213   \n",
       "145          2017-05-31 00:00:00                     00:00:00          0.225   \n",
       "146          2017-06-01 00:00:00                     00:00:00          0.229   \n",
       "\n",
       "     Measure Unit Null Data Code Qualifier Code  Data Validity Code  \n",
       "0             ppm            NaN            NaN                 NaN  \n",
       "1             ppm            NaN            NaN                 NaN  \n",
       "2             ppm            NaN            NaN                 NaN  \n",
       "3             ppm            NaN            NaN                 NaN  \n",
       "4             ppm            NaN            NaN                 NaN  \n",
       "5             ppm            NaN            NaN                 NaN  \n",
       "6             ppm            NaN            NaN                 NaN  \n",
       "7             ppm            NaN            NaN                 NaN  \n",
       "8             ppm            NaN            NaN                 NaN  \n",
       "9             ppm            NaN            NaN                 NaN  \n",
       "10            ppm            NaN            NaN                 NaN  \n",
       "11            ppm            NaN            NaN                 NaN  \n",
       "12            ppm            NaN            NaN                 NaN  \n",
       "13            ppm            NaN            NaN                 NaN  \n",
       "14            ppm            NaN            NaN                 NaN  \n",
       "15            ppm            NaN            NaN                 NaN  \n",
       "16            ppm            NaN            NaN                 NaN  \n",
       "17            ppm            NaN            NaN                 NaN  \n",
       "18            ppm            NaN            NaN                 NaN  \n",
       "19            ppm            NaN            NaN                 NaN  \n",
       "20            ppm            NaN            NaN                 NaN  \n",
       "21            ppm            NaN            NaN                 NaN  \n",
       "22            ppm            NaN            NaN                 NaN  \n",
       "23            ppm            NaN            NaN                 NaN  \n",
       "24            ppm            NaN            NaN                 NaN  \n",
       "25            ppm            NaN            NaN                 NaN  \n",
       "26            ppm            NaN            NaN                 NaN  \n",
       "27            ppm            NaN            NaN                 NaN  \n",
       "28            ppm            NaN            NaN                 NaN  \n",
       "29            ppm            NaN            NaN                 NaN  \n",
       "..            ...            ...            ...                 ...  \n",
       "117           ppm            NaN            NaN                 NaN  \n",
       "118           ppm            NaN            NaN                 NaN  \n",
       "119           ppm            NaN            NaN                 NaN  \n",
       "120           ppm            NaN            NaN                 NaN  \n",
       "121           ppm            NaN            NaN                 NaN  \n",
       "122           ppm            NaN            NaN                 NaN  \n",
       "123           ppm            NaN            NaN                 NaN  \n",
       "124           ppm            NaN            NaN                 NaN  \n",
       "125           ppm            NaN            NaN                 NaN  \n",
       "126           ppm            NaN            NaN                 NaN  \n",
       "127           ppm            NaN            NaN                 NaN  \n",
       "128           ppm            NaN            NaN                 NaN  \n",
       "129           ppm            NaN            NaN                 NaN  \n",
       "130           ppm            NaN            NaN                 NaN  \n",
       "131           ppm            NaN            NaN                 NaN  \n",
       "132           ppm            NaN            NaN                 NaN  \n",
       "133           ppm            NaN            NaN                 NaN  \n",
       "134           ppm            NaN            NaN                 NaN  \n",
       "135           ppm            NaN            NaN                 NaN  \n",
       "136           ppm            NaN            NaN                 NaN  \n",
       "137           ppm            NaN            NaN                 NaN  \n",
       "138           ppm            NaN            NaN                 NaN  \n",
       "139           ppm            NaN            NaN                 NaN  \n",
       "140           ppm            NaN            NaN                 NaN  \n",
       "141           ppm            NaN            NaN                 NaN  \n",
       "142           ppm            NaN            NaN                 NaN  \n",
       "143           ppm            NaN            NaN                 NaN  \n",
       "144           ppm            NaN            NaN                 NaN  \n",
       "145           ppm            NaN            NaN                 NaN  \n",
       "146           ppm            NaN            NaN                 NaN  \n",
       "\n",
       "[147 rows x 32 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "my_data[my_data['Local ID'] == 'Boston Roxbury']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python 3",
   "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.6.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}