weather_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Weather Analysis Task\n",
    "In this task, we are provided with a list of locations (CSV) where we need to collect daily weather data. The weather data will be for particular range of dates per location. In order to do this, we are relying on historic weather information from Dark Sky."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 143,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>loc_id</th>\n",
       "      <th>postal_code</th>\n",
       "      <th>date_first</th>\n",
       "      <th>date_last</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>AL3 5DQ</td>\n",
       "      <td>1485907200</td>\n",
       "      <td>1488326400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>a35e427b4130be7b2a892e286f0ebb91</td>\n",
       "      <td>CB2 3QF</td>\n",
       "      <td>1486944000</td>\n",
       "      <td>1488326400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>185674a2eb5c14fbdbb1d05a4109ea55</td>\n",
       "      <td>EX1 1GJ</td>\n",
       "      <td>1486425600</td>\n",
       "      <td>1488326400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>afbddd7f957a1c822293616e95a2d84c</td>\n",
       "      <td>NG2 5GR</td>\n",
       "      <td>1486512000</td>\n",
       "      <td>1488326400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>81cea1e224ad183b751acce139f4e276</td>\n",
       "      <td>GU21 6XX</td>\n",
       "      <td>1486080000</td>\n",
       "      <td>1488326400</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                             loc_id postal_code  date_first   date_last\n",
       "0  9be000ae23275d57e1273d211a54ffd7     AL3 5DQ  1485907200  1488326400\n",
       "1  a35e427b4130be7b2a892e286f0ebb91     CB2 3QF  1486944000  1488326400\n",
       "2  185674a2eb5c14fbdbb1d05a4109ea55     EX1 1GJ  1486425600  1488326400\n",
       "3  afbddd7f957a1c822293616e95a2d84c     NG2 5GR  1486512000  1488326400\n",
       "4  81cea1e224ad183b751acce139f4e276    GU21 6XX  1486080000  1488326400"
      ]
     },
     "execution_count": 143,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import requests\n",
    "import pandas as pd\n",
    "import re\n",
    "import getpass\n",
    "from datetime import datetime\n",
    "\n",
    "# read and explore locations.csv\n",
    "df_locations = pd.read_csv(\"locations.csv\")\n",
    "df_locations.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Google Maps API\n",
    "As the Dark Sky API requires location data in the form of geo coordinates (long, lat), we will utilize the Google Maps API to convert the postal_code data in the csv. The Google Maps API is able to detect the origin of the postal_code and is able to provide the converted geo coordinate data. However, there was timeout issues with the Google Maps API which caused geo coordinates to be empty. A loop to check for this was added to ensure we have complete information available."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 154,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# get lon and lat geo coordinates via Google Maps API\n",
    "def get_geo_coordinates(row):\n",
    "    long, lat, has_no_geoloc = 0, 0, True\n",
    "    \n",
    "    while has_no_geoloc:\n",
    "        # get geo coordinates via google api\n",
    "        resp = requests.get(\"https://maps.googleapis.com/maps/api/geocode/json?address=\" + re.sub(\"\\s\",\"%20\",row['postal_code']) + \"&json=1\")\n",
    "        if resp.status_code != 200:\n",
    "            # This means something went wrong.\n",
    "            raise Exception\n",
    "        else:\n",
    "            geo_data = resp.json()\n",
    "            if len(geo_data['results']) > 0:\n",
    "                long = geo_data['results'][0]['geometry']['location']['lng']\n",
    "                lat = geo_data['results'][0]['geometry']['location']['lat']\n",
    "                has_no_geoloc = False\n",
    "    return pd.Series([long, lat], index=['long', 'lat'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 155,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>loc_id</th>\n",
       "      <th>postal_code</th>\n",
       "      <th>date_first</th>\n",
       "      <th>date_last</th>\n",
       "      <th>long</th>\n",
       "      <th>lat</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>AL3 5DQ</td>\n",
       "      <td>1485907200</td>\n",
       "      <td>1488326400</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>51.751905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>a35e427b4130be7b2a892e286f0ebb91</td>\n",
       "      <td>CB2 3QF</td>\n",
       "      <td>1486944000</td>\n",
       "      <td>1488326400</td>\n",
       "      <td>0.120337</td>\n",
       "      <td>52.204212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>185674a2eb5c14fbdbb1d05a4109ea55</td>\n",
       "      <td>EX1 1GJ</td>\n",
       "      <td>1486425600</td>\n",
       "      <td>1488326400</td>\n",
       "      <td>-3.528028</td>\n",
       "      <td>50.723242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>afbddd7f957a1c822293616e95a2d84c</td>\n",
       "      <td>NG2 5GR</td>\n",
       "      <td>1486512000</td>\n",
       "      <td>1488326400</td>\n",
       "      <td>-1.127144</td>\n",
       "      <td>52.931983</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>81cea1e224ad183b751acce139f4e276</td>\n",
       "      <td>GU21 6XX</td>\n",
       "      <td>1486080000</td>\n",
       "      <td>1488326400</td>\n",
       "      <td>-0.558755</td>\n",
       "      <td>51.319326</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5f1ce9b7c8cd32c08d98310540fb6604</td>\n",
       "      <td>BS34 5DG</td>\n",
       "      <td>1487289600</td>\n",
       "      <td>1488326400</td>\n",
       "      <td>-2.595357</td>\n",
       "      <td>51.525159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>5180af03094779de849ca816c9f5b753</td>\n",
       "      <td>N10 1BY</td>\n",
       "      <td>1486944000</td>\n",
       "      <td>1488326400</td>\n",
       "      <td>-0.143414</td>\n",
       "      <td>51.592149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7f2aa8e72612f9130e06b32a0d2a58d7</td>\n",
       "      <td>BR1 1DN</td>\n",
       "      <td>1485907200</td>\n",
       "      <td>1488326400</td>\n",
       "      <td>0.016582</td>\n",
       "      <td>51.403891</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8b049b660e984912c48da213f2f7c650</td>\n",
       "      <td>LS29 9PA</td>\n",
       "      <td>1486425600</td>\n",
       "      <td>1488326400</td>\n",
       "      <td>-1.827509</td>\n",
       "      <td>53.924762</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>fe5d591b3509247487a917d4e8a33f65</td>\n",
       "      <td>SE1 9FU</td>\n",
       "      <td>1486512000</td>\n",
       "      <td>1488326400</td>\n",
       "      <td>-0.101308</td>\n",
       "      <td>51.507117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>f8a762f49d2abffe630be60295f71ed0</td>\n",
       "      <td>BN1 1GE</td>\n",
       "      <td>1487635200</td>\n",
       "      <td>1488326400</td>\n",
       "      <td>-0.138932</td>\n",
       "      <td>50.824856</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>58f7d1d3ce8cc4e808bf840b56714b38</td>\n",
       "      <td>CV37 6BA</td>\n",
       "      <td>1487289600</td>\n",
       "      <td>1488326400</td>\n",
       "      <td>-1.704784</td>\n",
       "      <td>52.190685</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>84d414ec45c5b436c8470ce314c3b83f</td>\n",
       "      <td>LS1 5AY</td>\n",
       "      <td>1486080000</td>\n",
       "      <td>1488326400</td>\n",
       "      <td>-1.544324</td>\n",
       "      <td>53.796806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>51fa5362e943615c7b31d367b461fd2c</td>\n",
       "      <td>TW6 3XA</td>\n",
       "      <td>1487808000</td>\n",
       "      <td>1488326400</td>\n",
       "      <td>-0.447730</td>\n",
       "      <td>51.459780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>c60d40fa98e6235ba0d1485c4253bfe6</td>\n",
       "      <td>W4 5TA</td>\n",
       "      <td>1487462400</td>\n",
       "      <td>1488326400</td>\n",
       "      <td>-0.262458</td>\n",
       "      <td>51.492629</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>07d09eab6c837d4b0c0b17aba37e1dcf</td>\n",
       "      <td>WC2E 9BH</td>\n",
       "      <td>1487635200</td>\n",
       "      <td>1488326400</td>\n",
       "      <td>-0.125737</td>\n",
       "      <td>51.511575</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>f69e492442cd452124c75e6805d8e37d</td>\n",
       "      <td>SE1 7LY</td>\n",
       "      <td>1486944000</td>\n",
       "      <td>1488326400</td>\n",
       "      <td>-0.113259</td>\n",
       "      <td>51.503146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>f5e2c06c5530335d2c994d20ed071bcb</td>\n",
       "      <td>WD17 2ED</td>\n",
       "      <td>1486512000</td>\n",
       "      <td>1488326400</td>\n",
       "      <td>-0.411626</td>\n",
       "      <td>51.669535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>RG1 3EY</td>\n",
       "      <td>1486425600</td>\n",
       "      <td>1488326400</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>51.455098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>11aeddbd12e79cae8dddb694e200f00d</td>\n",
       "      <td>SO15 1QF</td>\n",
       "      <td>1487808000</td>\n",
       "      <td>1488326400</td>\n",
       "      <td>-1.407188</td>\n",
       "      <td>50.903584</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              loc_id postal_code  date_first   date_last  \\\n",
       "0   9be000ae23275d57e1273d211a54ffd7     AL3 5DQ  1485907200  1488326400   \n",
       "1   a35e427b4130be7b2a892e286f0ebb91     CB2 3QF  1486944000  1488326400   \n",
       "2   185674a2eb5c14fbdbb1d05a4109ea55     EX1 1GJ  1486425600  1488326400   \n",
       "3   afbddd7f957a1c822293616e95a2d84c     NG2 5GR  1486512000  1488326400   \n",
       "4   81cea1e224ad183b751acce139f4e276    GU21 6XX  1486080000  1488326400   \n",
       "5   5f1ce9b7c8cd32c08d98310540fb6604    BS34 5DG  1487289600  1488326400   \n",
       "6   5180af03094779de849ca816c9f5b753     N10 1BY  1486944000  1488326400   \n",
       "7   7f2aa8e72612f9130e06b32a0d2a58d7     BR1 1DN  1485907200  1488326400   \n",
       "8   8b049b660e984912c48da213f2f7c650    LS29 9PA  1486425600  1488326400   \n",
       "9   fe5d591b3509247487a917d4e8a33f65     SE1 9FU  1486512000  1488326400   \n",
       "10  f8a762f49d2abffe630be60295f71ed0     BN1 1GE  1487635200  1488326400   \n",
       "11  58f7d1d3ce8cc4e808bf840b56714b38    CV37 6BA  1487289600  1488326400   \n",
       "12  84d414ec45c5b436c8470ce314c3b83f     LS1 5AY  1486080000  1488326400   \n",
       "13  51fa5362e943615c7b31d367b461fd2c     TW6 3XA  1487808000  1488326400   \n",
       "14  c60d40fa98e6235ba0d1485c4253bfe6      W4 5TA  1487462400  1488326400   \n",
       "15  07d09eab6c837d4b0c0b17aba37e1dcf    WC2E 9BH  1487635200  1488326400   \n",
       "16  f69e492442cd452124c75e6805d8e37d     SE1 7LY  1486944000  1488326400   \n",
       "17  f5e2c06c5530335d2c994d20ed071bcb    WD17 2ED  1486512000  1488326400   \n",
       "18  16bdd6fe40ed85ce99a456af6d7cff93     RG1 3EY  1486425600  1488326400   \n",
       "19  11aeddbd12e79cae8dddb694e200f00d    SO15 1QF  1487808000  1488326400   \n",
       "\n",
       "        long        lat  \n",
       "0  -0.340510  51.751905  \n",
       "1   0.120337  52.204212  \n",
       "2  -3.528028  50.723242  \n",
       "3  -1.127144  52.931983  \n",
       "4  -0.558755  51.319326  \n",
       "5  -2.595357  51.525159  \n",
       "6  -0.143414  51.592149  \n",
       "7   0.016582  51.403891  \n",
       "8  -1.827509  53.924762  \n",
       "9  -0.101308  51.507117  \n",
       "10 -0.138932  50.824856  \n",
       "11 -1.704784  52.190685  \n",
       "12 -1.544324  53.796806  \n",
       "13 -0.447730  51.459780  \n",
       "14 -0.262458  51.492629  \n",
       "15 -0.125737  51.511575  \n",
       "16 -0.113259  51.503146  \n",
       "17 -0.411626  51.669535  \n",
       "18 -0.968765  51.455098  \n",
       "19 -1.407188  50.903584  "
      ]
     },
     "execution_count": 155,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_locations[[\"long\", \"lat\"]] = df_locations.apply(get_geo_coordinates, axis=1)\n",
    "df_locations"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Dark Sky API\n",
    "In order to use the Dark Sky API, Dark Sky requires an api key to be provided. With an api key stored, we explore how the Dark Sky API behaves using various points of data."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "········\n"
     ]
    }
   ],
   "source": [
    "# get dark sky api key from user\n",
    "dark_sky_api_key = getpass.getpass()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'offset': 0, 'timezone': 'Europe/London', 'daily': {'data': [{'humidity': 0.73, 'time': 1487808000, 'apparentTemperatureMax': 42.39, 'visibility': 6.85, 'dewPoint': 38.42, 'windSpeed': 21.64, 'windBearing': 261, 'temperatureMax': 49.97, 'cloudCover': 0.66, 'precipType': 'rain', 'summary': 'Windy and mostly cloudy until evening.', 'apparentTemperatureMinTime': 1487883600, 'moonPhase': 0.89, 'sunsetTime': 1487871423, 'sunriseTime': 1487833432, 'icon': 'wind', 'temperatureMinTime': 1487887200, 'pressure': 1000.95, 'apparentTemperatureMin': 33.42, 'apparentTemperatureMaxTime': 1487833200, 'temperatureMaxTime': 1487833200, 'temperatureMin': 41.09}]}, 'latitude': 50.903584, 'longitude': -1.407188} \n",
      "\n",
      "-1 \n",
      "\n",
      "{'offset': 0, 'timezone': 'Europe/London', 'daily': {'data': [{'humidity': 0.82, 'time': 1490227200, 'precipIntensity': 0.0082, 'apparentTemperatureMax': 50.79, 'visibility': 6.27, 'dewPoint': 39.17, 'windSpeed': 14.36, 'precipIntensityMaxTime': 1490238000, 'windBearing': 51, 'precipIntensityMax': 0.0255, 'summary': 'Light rain until afternoon and breezy starting in the afternoon.', 'temperatureMax': 50.79, 'cloudCover': 0.81, 'precipType': 'rain', 'ozone': 428.43, 'precipProbability': 0.64, 'apparentTemperatureMinTime': 1490245200, 'moonPhase': 0.84, 'sunsetTime': 1490293447, 'sunriseTime': 1490248964, 'icon': 'rain', 'temperatureMinTime': 1490227200, 'pressure': 1013.81, 'apparentTemperatureMin': 34.26, 'apparentTemperatureMaxTime': 1490277600, 'temperatureMaxTime': 1490277600, 'temperatureMin': 37.92}]}, 'latitude': 50.903584, 'longitude': -1.407188} \n",
      "\n",
      "0.64\n"
     ]
    }
   ],
   "source": [
    "resp = requests.get(\"https://api.darksky.net/forecast/\" + dark_sky_api_key + \"/50.903584,-1.407188,1487808000?exclude=currently,minutely,hourly,flags\")\n",
    "if resp.status_code != 200:\n",
    "    # This means something went wrong.\n",
    "    raise Exception\n",
    "else:\n",
    "    weather_data = resp.json()\n",
    "    print(weather_data, \"\\n\")\n",
    "    try:\n",
    "        print(weather_data['daily']['data'][0]['precipProbability'])\n",
    "    except:\n",
    "        print(-1, \"\\n\")\n",
    "    \n",
    "resp = requests.get(\"https://api.darksky.net/forecast/\" + dark_sky_api_key + \"/50.903584,-1.407188,1490252400?exclude=currently,minutely,hourly,flags\")\n",
    "if resp.status_code != 200:\n",
    "    # This means something went wrong.\n",
    "    raise Exception\n",
    "else:\n",
    "    weather_data = resp.json()\n",
    "    print(weather_data, \"\\n\")\n",
    "    try:\n",
    "        print(weather_data['daily']['data'][0]['precipProbability'])\n",
    "    except:\n",
    "        print(-1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Dark Sky API exploration findings\n",
    "## Missing daily precipProbability information\n",
    "Unfortunately, Dark Sky does not keep all historic information for all locations. This can be seen in the short test cases above where test case one does not have any precipProbablity information while the test case two does. An except about this is shown below. Detailed information about this is further explained in Dark Sky API's [FAQ](https://darksky.net/dev/docs/faq).\n",
    "\n",
    "### Data Availability and Accuracy\n",
    "#### Are historical reports based on observational data?\n",
    "> Usually, but we sometimes fill in data from other sources if no observations are available.\n",
    "\n",
    "#### Why do historical reports sometimes change from the last time I requested them?\n",
    "> Several of our data sources aren’t real-time, and flow into our system after the fact. As a result, our historical data may continue changing for up to two weeks after a time has occurred. (In most cases, the changes are very minor!)\n",
    "\n",
    "#### Why are weather conditions sometimes missing from historical responses?\n",
    "> We omit weather data that we do not have. This may be because there aren't any weather stations near you, or the weather stations that are near you are missing sensors for the kind of weather that you care about, or the weather stations that are near you have those sensors but are producing suspect data (in which case we ignore it).\n",
    "\n",
    "#### Why isn't precipProbability always 0 or 1 for historical responses?\n",
    "> We don't have perfect historical data—weather stations don't cover every square inch of the planet!—and so these probabilities reflect our uncertainty about what happened.\n",
    "\n",
    "#### Can I get your previous forecasts instead of weather station observations?\n",
    "> Unfortunately, we do not have the storage capacity to store previous forecasts. Sorry!\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Clean-up and preperation of data\n",
    "The Dark Sky API expects a timestamp, longtitude, latitude. As the original locations.csv data provided only a date range and not the exact daily data, we expand the date ranges into daily rows into a new data frame to process."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 169,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>epoch</th>\n",
       "      <th>lat</th>\n",
       "      <th>loc_id</th>\n",
       "      <th>long</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-01-31</td>\n",
       "      <td>1485907200</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017-02-01</td>\n",
       "      <td>1485993600</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-02-02</td>\n",
       "      <td>1486080000</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017-02-03</td>\n",
       "      <td>1486166400</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017-02-04</td>\n",
       "      <td>1486252800</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2017-02-05</td>\n",
       "      <td>1486339200</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2017-02-06</td>\n",
       "      <td>1486425600</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2017-02-07</td>\n",
       "      <td>1486512000</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2017-02-08</td>\n",
       "      <td>1486598400</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2017-02-09</td>\n",
       "      <td>1486684800</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2017-02-10</td>\n",
       "      <td>1486771200</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2017-02-11</td>\n",
       "      <td>1486857600</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2017-02-12</td>\n",
       "      <td>1486944000</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2017-02-13</td>\n",
       "      <td>1487030400</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2017-02-14</td>\n",
       "      <td>1487116800</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2017-02-15</td>\n",
       "      <td>1487203200</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2017-02-16</td>\n",
       "      <td>1487289600</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2017-02-17</td>\n",
       "      <td>1487376000</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2017-02-18</td>\n",
       "      <td>1487462400</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2017-02-19</td>\n",
       "      <td>1487548800</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2017-02-20</td>\n",
       "      <td>1487635200</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2017-02-21</td>\n",
       "      <td>1487721600</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2017-02-22</td>\n",
       "      <td>1487808000</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2017-02-23</td>\n",
       "      <td>1487894400</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2017-02-24</td>\n",
       "      <td>1487980800</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2017-02-25</td>\n",
       "      <td>1488067200</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2017-02-26</td>\n",
       "      <td>1488153600</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2017-02-27</td>\n",
       "      <td>1488240000</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2017-02-12</td>\n",
       "      <td>1486944000</td>\n",
       "      <td>52.204212</td>\n",
       "      <td>a35e427b4130be7b2a892e286f0ebb91</td>\n",
       "      <td>0.120337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2017-02-13</td>\n",
       "      <td>1487030400</td>\n",
       "      <td>52.204212</td>\n",
       "      <td>a35e427b4130be7b2a892e286f0ebb91</td>\n",
       "      <td>0.120337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>317</th>\n",
       "      <td>2017-02-26</td>\n",
       "      <td>1488153600</td>\n",
       "      <td>51.669535</td>\n",
       "      <td>f5e2c06c5530335d2c994d20ed071bcb</td>\n",
       "      <td>-0.411626</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>318</th>\n",
       "      <td>2017-02-27</td>\n",
       "      <td>1488240000</td>\n",
       "      <td>51.669535</td>\n",
       "      <td>f5e2c06c5530335d2c994d20ed071bcb</td>\n",
       "      <td>-0.411626</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>2017-02-06</td>\n",
       "      <td>1486425600</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320</th>\n",
       "      <td>2017-02-07</td>\n",
       "      <td>1486512000</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321</th>\n",
       "      <td>2017-02-08</td>\n",
       "      <td>1486598400</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>322</th>\n",
       "      <td>2017-02-09</td>\n",
       "      <td>1486684800</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323</th>\n",
       "      <td>2017-02-10</td>\n",
       "      <td>1486771200</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324</th>\n",
       "      <td>2017-02-11</td>\n",
       "      <td>1486857600</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>325</th>\n",
       "      <td>2017-02-12</td>\n",
       "      <td>1486944000</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>326</th>\n",
       "      <td>2017-02-13</td>\n",
       "      <td>1487030400</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>327</th>\n",
       "      <td>2017-02-14</td>\n",
       "      <td>1487116800</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>328</th>\n",
       "      <td>2017-02-15</td>\n",
       "      <td>1487203200</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>329</th>\n",
       "      <td>2017-02-16</td>\n",
       "      <td>1487289600</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>330</th>\n",
       "      <td>2017-02-17</td>\n",
       "      <td>1487376000</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>331</th>\n",
       "      <td>2017-02-18</td>\n",
       "      <td>1487462400</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>332</th>\n",
       "      <td>2017-02-19</td>\n",
       "      <td>1487548800</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>333</th>\n",
       "      <td>2017-02-20</td>\n",
       "      <td>1487635200</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>334</th>\n",
       "      <td>2017-02-21</td>\n",
       "      <td>1487721600</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>335</th>\n",
       "      <td>2017-02-22</td>\n",
       "      <td>1487808000</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>336</th>\n",
       "      <td>2017-02-23</td>\n",
       "      <td>1487894400</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>337</th>\n",
       "      <td>2017-02-24</td>\n",
       "      <td>1487980800</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>338</th>\n",
       "      <td>2017-02-25</td>\n",
       "      <td>1488067200</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>339</th>\n",
       "      <td>2017-02-26</td>\n",
       "      <td>1488153600</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>340</th>\n",
       "      <td>2017-02-27</td>\n",
       "      <td>1488240000</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341</th>\n",
       "      <td>2017-02-22</td>\n",
       "      <td>1487808000</td>\n",
       "      <td>50.903584</td>\n",
       "      <td>11aeddbd12e79cae8dddb694e200f00d</td>\n",
       "      <td>-1.407188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>342</th>\n",
       "      <td>2017-02-23</td>\n",
       "      <td>1487894400</td>\n",
       "      <td>50.903584</td>\n",
       "      <td>11aeddbd12e79cae8dddb694e200f00d</td>\n",
       "      <td>-1.407188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>343</th>\n",
       "      <td>2017-02-24</td>\n",
       "      <td>1487980800</td>\n",
       "      <td>50.903584</td>\n",
       "      <td>11aeddbd12e79cae8dddb694e200f00d</td>\n",
       "      <td>-1.407188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>2017-02-25</td>\n",
       "      <td>1488067200</td>\n",
       "      <td>50.903584</td>\n",
       "      <td>11aeddbd12e79cae8dddb694e200f00d</td>\n",
       "      <td>-1.407188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>345</th>\n",
       "      <td>2017-02-26</td>\n",
       "      <td>1488153600</td>\n",
       "      <td>50.903584</td>\n",
       "      <td>11aeddbd12e79cae8dddb694e200f00d</td>\n",
       "      <td>-1.407188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>346</th>\n",
       "      <td>2017-02-27</td>\n",
       "      <td>1488240000</td>\n",
       "      <td>50.903584</td>\n",
       "      <td>11aeddbd12e79cae8dddb694e200f00d</td>\n",
       "      <td>-1.407188</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>347 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           date       epoch        lat                            loc_id  \\\n",
       "0    2017-01-31  1485907200  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "1    2017-02-01  1485993600  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "2    2017-02-02  1486080000  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "3    2017-02-03  1486166400  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "4    2017-02-04  1486252800  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "5    2017-02-05  1486339200  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "6    2017-02-06  1486425600  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "7    2017-02-07  1486512000  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "8    2017-02-08  1486598400  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "9    2017-02-09  1486684800  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "10   2017-02-10  1486771200  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "11   2017-02-11  1486857600  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "12   2017-02-12  1486944000  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "13   2017-02-13  1487030400  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "14   2017-02-14  1487116800  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "15   2017-02-15  1487203200  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "16   2017-02-16  1487289600  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "17   2017-02-17  1487376000  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "18   2017-02-18  1487462400  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "19   2017-02-19  1487548800  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "20   2017-02-20  1487635200  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "21   2017-02-21  1487721600  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "22   2017-02-22  1487808000  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "23   2017-02-23  1487894400  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "24   2017-02-24  1487980800  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "25   2017-02-25  1488067200  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "26   2017-02-26  1488153600  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "27   2017-02-27  1488240000  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "28   2017-02-12  1486944000  52.204212  a35e427b4130be7b2a892e286f0ebb91   \n",
       "29   2017-02-13  1487030400  52.204212  a35e427b4130be7b2a892e286f0ebb91   \n",
       "..          ...         ...        ...                               ...   \n",
       "317  2017-02-26  1488153600  51.669535  f5e2c06c5530335d2c994d20ed071bcb   \n",
       "318  2017-02-27  1488240000  51.669535  f5e2c06c5530335d2c994d20ed071bcb   \n",
       "319  2017-02-06  1486425600  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "320  2017-02-07  1486512000  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "321  2017-02-08  1486598400  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "322  2017-02-09  1486684800  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "323  2017-02-10  1486771200  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "324  2017-02-11  1486857600  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "325  2017-02-12  1486944000  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "326  2017-02-13  1487030400  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "327  2017-02-14  1487116800  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "328  2017-02-15  1487203200  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "329  2017-02-16  1487289600  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "330  2017-02-17  1487376000  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "331  2017-02-18  1487462400  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "332  2017-02-19  1487548800  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "333  2017-02-20  1487635200  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "334  2017-02-21  1487721600  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "335  2017-02-22  1487808000  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "336  2017-02-23  1487894400  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "337  2017-02-24  1487980800  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "338  2017-02-25  1488067200  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "339  2017-02-26  1488153600  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "340  2017-02-27  1488240000  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "341  2017-02-22  1487808000  50.903584  11aeddbd12e79cae8dddb694e200f00d   \n",
       "342  2017-02-23  1487894400  50.903584  11aeddbd12e79cae8dddb694e200f00d   \n",
       "343  2017-02-24  1487980800  50.903584  11aeddbd12e79cae8dddb694e200f00d   \n",
       "344  2017-02-25  1488067200  50.903584  11aeddbd12e79cae8dddb694e200f00d   \n",
       "345  2017-02-26  1488153600  50.903584  11aeddbd12e79cae8dddb694e200f00d   \n",
       "346  2017-02-27  1488240000  50.903584  11aeddbd12e79cae8dddb694e200f00d   \n",
       "\n",
       "          long  \n",
       "0    -0.340510  \n",
       "1    -0.340510  \n",
       "2    -0.340510  \n",
       "3    -0.340510  \n",
       "4    -0.340510  \n",
       "5    -0.340510  \n",
       "6    -0.340510  \n",
       "7    -0.340510  \n",
       "8    -0.340510  \n",
       "9    -0.340510  \n",
       "10   -0.340510  \n",
       "11   -0.340510  \n",
       "12   -0.340510  \n",
       "13   -0.340510  \n",
       "14   -0.340510  \n",
       "15   -0.340510  \n",
       "16   -0.340510  \n",
       "17   -0.340510  \n",
       "18   -0.340510  \n",
       "19   -0.340510  \n",
       "20   -0.340510  \n",
       "21   -0.340510  \n",
       "22   -0.340510  \n",
       "23   -0.340510  \n",
       "24   -0.340510  \n",
       "25   -0.340510  \n",
       "26   -0.340510  \n",
       "27   -0.340510  \n",
       "28    0.120337  \n",
       "29    0.120337  \n",
       "..         ...  \n",
       "317  -0.411626  \n",
       "318  -0.411626  \n",
       "319  -0.968765  \n",
       "320  -0.968765  \n",
       "321  -0.968765  \n",
       "322  -0.968765  \n",
       "323  -0.968765  \n",
       "324  -0.968765  \n",
       "325  -0.968765  \n",
       "326  -0.968765  \n",
       "327  -0.968765  \n",
       "328  -0.968765  \n",
       "329  -0.968765  \n",
       "330  -0.968765  \n",
       "331  -0.968765  \n",
       "332  -0.968765  \n",
       "333  -0.968765  \n",
       "334  -0.968765  \n",
       "335  -0.968765  \n",
       "336  -0.968765  \n",
       "337  -0.968765  \n",
       "338  -0.968765  \n",
       "339  -0.968765  \n",
       "340  -0.968765  \n",
       "341  -1.407188  \n",
       "342  -1.407188  \n",
       "343  -1.407188  \n",
       "344  -1.407188  \n",
       "345  -1.407188  \n",
       "346  -1.407188  \n",
       "\n",
       "[347 rows x 5 columns]"
      ]
     },
     "execution_count": 169,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rows_list = []\n",
    "for index, row in df_locations.iterrows():\n",
    "    i = 0\n",
    "    epoch = row['date_first']\n",
    "    while epoch < row['date_last']:\n",
    "        s = {\n",
    "            'loc_id' : row['loc_id'],\n",
    "            'epoch' : '%.0f' % epoch,\n",
    "            'date' : datetime.fromtimestamp(epoch).strftime('%Y-%m-%d'),\n",
    "            'long' : '%.6f' % row['long'],\n",
    "            'lat' : '%.6f' % row['lat'],\n",
    "        }\n",
    "        rows_list.append(s)\n",
    "        i += 1\n",
    "        epoch += (60*60*24)\n",
    "    \n",
    "df_locations_cleaned = pd.DataFrame(rows_list)\n",
    "df_locations_cleaned"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Obtaining weather data\n",
    "To address the occurance of missing data from the Dark Sky API, any API calls that come back with a valid response but missing the precipProbability data will be assigned a value of -1. Otherwise, the precipProbability data will be stored as a percentage value. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 176,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# get weather data via Dark Sky API\n",
    "def get_weather(row):\n",
    "    pp = None\n",
    "    resp = requests.get(\"https://api.darksky.net/forecast/\" + \n",
    "                        dark_sky_api_key + \"/\" + \n",
    "                        row['lat'] + \",\" +\n",
    "                        row['long'] + \",\" +\n",
    "                        row['epoch'] + \"?exclude=currently,minutely,hourly,flags\")\n",
    "    if resp.status_code != 200:\n",
    "        # This means something went wrong.\n",
    "        raise Exception\n",
    "    else:\n",
    "        weather_data = resp.json()\n",
    "        try:\n",
    "            pp = weather_data['daily']['data'][0]['precipProbability']\n",
    "        except:\n",
    "            pp = -1\n",
    "    if pp > 0:\n",
    "        pp = (pp*100)\n",
    "    print(\"Getting weather data for %s\" % row['loc_id'])\n",
    "    return pd.Series([\n",
    "        weather_data['daily']['data'][0]['summary'],\n",
    "        pp,\n",
    "        weather_data['daily']['data'][0]['humidity'],\n",
    "        weather_data['daily']['data'][0]['temperatureMin'],\n",
    "        weather_data['daily']['data'][0]['temperatureMax']], \n",
    "        index=['summary', 'precipProbability', 'humidity', 'temperatureMin', 'temperatureMax'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 177,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for 9be000ae23275d57e1273d211a54ffd7\n",
      "Getting weather data for a35e427b4130be7b2a892e286f0ebb91\n",
      "Getting weather data for a35e427b4130be7b2a892e286f0ebb91\n",
      "Getting weather data for a35e427b4130be7b2a892e286f0ebb91\n",
      "Getting weather data for a35e427b4130be7b2a892e286f0ebb91\n",
      "Getting weather data for a35e427b4130be7b2a892e286f0ebb91\n",
      "Getting weather data for a35e427b4130be7b2a892e286f0ebb91\n",
      "Getting weather data for a35e427b4130be7b2a892e286f0ebb91\n",
      "Getting weather data for a35e427b4130be7b2a892e286f0ebb91\n",
      "Getting weather data for a35e427b4130be7b2a892e286f0ebb91\n",
      "Getting weather data for a35e427b4130be7b2a892e286f0ebb91\n",
      "Getting weather data for a35e427b4130be7b2a892e286f0ebb91\n",
      "Getting weather data for a35e427b4130be7b2a892e286f0ebb91\n",
      "Getting weather data for a35e427b4130be7b2a892e286f0ebb91\n",
      "Getting weather data for a35e427b4130be7b2a892e286f0ebb91\n",
      "Getting weather data for a35e427b4130be7b2a892e286f0ebb91\n",
      "Getting weather data for a35e427b4130be7b2a892e286f0ebb91\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for 185674a2eb5c14fbdbb1d05a4109ea55\n",
      "Getting weather data for afbddd7f957a1c822293616e95a2d84c\n",
      "Getting weather data for afbddd7f957a1c822293616e95a2d84c\n",
      "Getting weather data for afbddd7f957a1c822293616e95a2d84c\n",
      "Getting weather data for afbddd7f957a1c822293616e95a2d84c\n",
      "Getting weather data for afbddd7f957a1c822293616e95a2d84c\n",
      "Getting weather data for afbddd7f957a1c822293616e95a2d84c\n",
      "Getting weather data for afbddd7f957a1c822293616e95a2d84c\n",
      "Getting weather data for afbddd7f957a1c822293616e95a2d84c\n",
      "Getting weather data for afbddd7f957a1c822293616e95a2d84c\n",
      "Getting weather data for afbddd7f957a1c822293616e95a2d84c\n",
      "Getting weather data for afbddd7f957a1c822293616e95a2d84c\n",
      "Getting weather data for afbddd7f957a1c822293616e95a2d84c\n",
      "Getting weather data for afbddd7f957a1c822293616e95a2d84c\n",
      "Getting weather data for afbddd7f957a1c822293616e95a2d84c\n",
      "Getting weather data for afbddd7f957a1c822293616e95a2d84c\n",
      "Getting weather data for afbddd7f957a1c822293616e95a2d84c\n",
      "Getting weather data for afbddd7f957a1c822293616e95a2d84c\n",
      "Getting weather data for afbddd7f957a1c822293616e95a2d84c\n",
      "Getting weather data for afbddd7f957a1c822293616e95a2d84c\n",
      "Getting weather data for afbddd7f957a1c822293616e95a2d84c\n",
      "Getting weather data for afbddd7f957a1c822293616e95a2d84c\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 81cea1e224ad183b751acce139f4e276\n",
      "Getting weather data for 5f1ce9b7c8cd32c08d98310540fb6604\n",
      "Getting weather data for 5f1ce9b7c8cd32c08d98310540fb6604\n",
      "Getting weather data for 5f1ce9b7c8cd32c08d98310540fb6604\n",
      "Getting weather data for 5f1ce9b7c8cd32c08d98310540fb6604\n",
      "Getting weather data for 5f1ce9b7c8cd32c08d98310540fb6604\n",
      "Getting weather data for 5f1ce9b7c8cd32c08d98310540fb6604\n",
      "Getting weather data for 5f1ce9b7c8cd32c08d98310540fb6604\n",
      "Getting weather data for 5f1ce9b7c8cd32c08d98310540fb6604\n",
      "Getting weather data for 5f1ce9b7c8cd32c08d98310540fb6604\n",
      "Getting weather data for 5f1ce9b7c8cd32c08d98310540fb6604\n",
      "Getting weather data for 5f1ce9b7c8cd32c08d98310540fb6604\n",
      "Getting weather data for 5f1ce9b7c8cd32c08d98310540fb6604\n",
      "Getting weather data for 5180af03094779de849ca816c9f5b753\n",
      "Getting weather data for 5180af03094779de849ca816c9f5b753\n",
      "Getting weather data for 5180af03094779de849ca816c9f5b753\n",
      "Getting weather data for 5180af03094779de849ca816c9f5b753\n",
      "Getting weather data for 5180af03094779de849ca816c9f5b753\n",
      "Getting weather data for 5180af03094779de849ca816c9f5b753\n",
      "Getting weather data for 5180af03094779de849ca816c9f5b753\n",
      "Getting weather data for 5180af03094779de849ca816c9f5b753\n",
      "Getting weather data for 5180af03094779de849ca816c9f5b753\n",
      "Getting weather data for 5180af03094779de849ca816c9f5b753\n",
      "Getting weather data for 5180af03094779de849ca816c9f5b753\n",
      "Getting weather data for 5180af03094779de849ca816c9f5b753\n",
      "Getting weather data for 5180af03094779de849ca816c9f5b753\n",
      "Getting weather data for 5180af03094779de849ca816c9f5b753\n",
      "Getting weather data for 5180af03094779de849ca816c9f5b753\n",
      "Getting weather data for 5180af03094779de849ca816c9f5b753\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 7f2aa8e72612f9130e06b32a0d2a58d7\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for 8b049b660e984912c48da213f2f7c650\n",
      "Getting weather data for fe5d591b3509247487a917d4e8a33f65\n",
      "Getting weather data for fe5d591b3509247487a917d4e8a33f65\n",
      "Getting weather data for fe5d591b3509247487a917d4e8a33f65\n",
      "Getting weather data for fe5d591b3509247487a917d4e8a33f65\n",
      "Getting weather data for fe5d591b3509247487a917d4e8a33f65\n",
      "Getting weather data for fe5d591b3509247487a917d4e8a33f65\n",
      "Getting weather data for fe5d591b3509247487a917d4e8a33f65\n",
      "Getting weather data for fe5d591b3509247487a917d4e8a33f65\n",
      "Getting weather data for fe5d591b3509247487a917d4e8a33f65\n",
      "Getting weather data for fe5d591b3509247487a917d4e8a33f65\n",
      "Getting weather data for fe5d591b3509247487a917d4e8a33f65\n",
      "Getting weather data for fe5d591b3509247487a917d4e8a33f65\n",
      "Getting weather data for fe5d591b3509247487a917d4e8a33f65\n",
      "Getting weather data for fe5d591b3509247487a917d4e8a33f65\n",
      "Getting weather data for fe5d591b3509247487a917d4e8a33f65\n",
      "Getting weather data for fe5d591b3509247487a917d4e8a33f65\n",
      "Getting weather data for fe5d591b3509247487a917d4e8a33f65\n",
      "Getting weather data for fe5d591b3509247487a917d4e8a33f65\n",
      "Getting weather data for fe5d591b3509247487a917d4e8a33f65\n",
      "Getting weather data for fe5d591b3509247487a917d4e8a33f65\n",
      "Getting weather data for fe5d591b3509247487a917d4e8a33f65\n",
      "Getting weather data for f8a762f49d2abffe630be60295f71ed0\n",
      "Getting weather data for f8a762f49d2abffe630be60295f71ed0\n",
      "Getting weather data for f8a762f49d2abffe630be60295f71ed0\n",
      "Getting weather data for f8a762f49d2abffe630be60295f71ed0\n",
      "Getting weather data for f8a762f49d2abffe630be60295f71ed0\n",
      "Getting weather data for f8a762f49d2abffe630be60295f71ed0\n",
      "Getting weather data for f8a762f49d2abffe630be60295f71ed0\n",
      "Getting weather data for f8a762f49d2abffe630be60295f71ed0\n",
      "Getting weather data for 58f7d1d3ce8cc4e808bf840b56714b38\n",
      "Getting weather data for 58f7d1d3ce8cc4e808bf840b56714b38\n",
      "Getting weather data for 58f7d1d3ce8cc4e808bf840b56714b38\n",
      "Getting weather data for 58f7d1d3ce8cc4e808bf840b56714b38\n",
      "Getting weather data for 58f7d1d3ce8cc4e808bf840b56714b38\n",
      "Getting weather data for 58f7d1d3ce8cc4e808bf840b56714b38\n",
      "Getting weather data for 58f7d1d3ce8cc4e808bf840b56714b38\n",
      "Getting weather data for 58f7d1d3ce8cc4e808bf840b56714b38\n",
      "Getting weather data for 58f7d1d3ce8cc4e808bf840b56714b38\n",
      "Getting weather data for 58f7d1d3ce8cc4e808bf840b56714b38\n",
      "Getting weather data for 58f7d1d3ce8cc4e808bf840b56714b38\n",
      "Getting weather data for 58f7d1d3ce8cc4e808bf840b56714b38\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 84d414ec45c5b436c8470ce314c3b83f\n",
      "Getting weather data for 51fa5362e943615c7b31d367b461fd2c\n",
      "Getting weather data for 51fa5362e943615c7b31d367b461fd2c\n",
      "Getting weather data for 51fa5362e943615c7b31d367b461fd2c\n",
      "Getting weather data for 51fa5362e943615c7b31d367b461fd2c\n",
      "Getting weather data for 51fa5362e943615c7b31d367b461fd2c\n",
      "Getting weather data for 51fa5362e943615c7b31d367b461fd2c\n",
      "Getting weather data for c60d40fa98e6235ba0d1485c4253bfe6\n",
      "Getting weather data for c60d40fa98e6235ba0d1485c4253bfe6\n",
      "Getting weather data for c60d40fa98e6235ba0d1485c4253bfe6\n",
      "Getting weather data for c60d40fa98e6235ba0d1485c4253bfe6\n",
      "Getting weather data for c60d40fa98e6235ba0d1485c4253bfe6\n",
      "Getting weather data for c60d40fa98e6235ba0d1485c4253bfe6\n",
      "Getting weather data for c60d40fa98e6235ba0d1485c4253bfe6\n",
      "Getting weather data for c60d40fa98e6235ba0d1485c4253bfe6\n",
      "Getting weather data for c60d40fa98e6235ba0d1485c4253bfe6\n",
      "Getting weather data for c60d40fa98e6235ba0d1485c4253bfe6\n",
      "Getting weather data for 07d09eab6c837d4b0c0b17aba37e1dcf\n",
      "Getting weather data for 07d09eab6c837d4b0c0b17aba37e1dcf\n",
      "Getting weather data for 07d09eab6c837d4b0c0b17aba37e1dcf\n",
      "Getting weather data for 07d09eab6c837d4b0c0b17aba37e1dcf\n",
      "Getting weather data for 07d09eab6c837d4b0c0b17aba37e1dcf\n",
      "Getting weather data for 07d09eab6c837d4b0c0b17aba37e1dcf\n",
      "Getting weather data for 07d09eab6c837d4b0c0b17aba37e1dcf\n",
      "Getting weather data for 07d09eab6c837d4b0c0b17aba37e1dcf\n",
      "Getting weather data for f69e492442cd452124c75e6805d8e37d\n",
      "Getting weather data for f69e492442cd452124c75e6805d8e37d\n",
      "Getting weather data for f69e492442cd452124c75e6805d8e37d\n",
      "Getting weather data for f69e492442cd452124c75e6805d8e37d\n",
      "Getting weather data for f69e492442cd452124c75e6805d8e37d\n",
      "Getting weather data for f69e492442cd452124c75e6805d8e37d\n",
      "Getting weather data for f69e492442cd452124c75e6805d8e37d\n",
      "Getting weather data for f69e492442cd452124c75e6805d8e37d\n",
      "Getting weather data for f69e492442cd452124c75e6805d8e37d\n",
      "Getting weather data for f69e492442cd452124c75e6805d8e37d\n",
      "Getting weather data for f69e492442cd452124c75e6805d8e37d\n",
      "Getting weather data for f69e492442cd452124c75e6805d8e37d\n",
      "Getting weather data for f69e492442cd452124c75e6805d8e37d\n",
      "Getting weather data for f69e492442cd452124c75e6805d8e37d\n",
      "Getting weather data for f69e492442cd452124c75e6805d8e37d\n",
      "Getting weather data for f69e492442cd452124c75e6805d8e37d\n",
      "Getting weather data for f5e2c06c5530335d2c994d20ed071bcb\n",
      "Getting weather data for f5e2c06c5530335d2c994d20ed071bcb\n",
      "Getting weather data for f5e2c06c5530335d2c994d20ed071bcb\n",
      "Getting weather data for f5e2c06c5530335d2c994d20ed071bcb\n",
      "Getting weather data for f5e2c06c5530335d2c994d20ed071bcb\n",
      "Getting weather data for f5e2c06c5530335d2c994d20ed071bcb\n",
      "Getting weather data for f5e2c06c5530335d2c994d20ed071bcb\n",
      "Getting weather data for f5e2c06c5530335d2c994d20ed071bcb\n",
      "Getting weather data for f5e2c06c5530335d2c994d20ed071bcb\n",
      "Getting weather data for f5e2c06c5530335d2c994d20ed071bcb\n",
      "Getting weather data for f5e2c06c5530335d2c994d20ed071bcb\n",
      "Getting weather data for f5e2c06c5530335d2c994d20ed071bcb\n",
      "Getting weather data for f5e2c06c5530335d2c994d20ed071bcb\n",
      "Getting weather data for f5e2c06c5530335d2c994d20ed071bcb\n",
      "Getting weather data for f5e2c06c5530335d2c994d20ed071bcb\n",
      "Getting weather data for f5e2c06c5530335d2c994d20ed071bcb\n",
      "Getting weather data for f5e2c06c5530335d2c994d20ed071bcb\n",
      "Getting weather data for f5e2c06c5530335d2c994d20ed071bcb\n",
      "Getting weather data for f5e2c06c5530335d2c994d20ed071bcb\n",
      "Getting weather data for f5e2c06c5530335d2c994d20ed071bcb\n",
      "Getting weather data for f5e2c06c5530335d2c994d20ed071bcb\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 16bdd6fe40ed85ce99a456af6d7cff93\n",
      "Getting weather data for 11aeddbd12e79cae8dddb694e200f00d\n",
      "Getting weather data for 11aeddbd12e79cae8dddb694e200f00d\n",
      "Getting weather data for 11aeddbd12e79cae8dddb694e200f00d\n",
      "Getting weather data for 11aeddbd12e79cae8dddb694e200f00d\n",
      "Getting weather data for 11aeddbd12e79cae8dddb694e200f00d\n",
      "Getting weather data for 11aeddbd12e79cae8dddb694e200f00d\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>epoch</th>\n",
       "      <th>lat</th>\n",
       "      <th>loc_id</th>\n",
       "      <th>long</th>\n",
       "      <th>summary</th>\n",
       "      <th>precipProbability</th>\n",
       "      <th>humidity</th>\n",
       "      <th>temperatureMin</th>\n",
       "      <th>temperatureMax</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-01-31</td>\n",
       "      <td>1485907200</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Foggy in the morning.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.96</td>\n",
       "      <td>46.65</td>\n",
       "      <td>50.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017-02-01</td>\n",
       "      <td>1485993600</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.90</td>\n",
       "      <td>48.01</td>\n",
       "      <td>51.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-02-02</td>\n",
       "      <td>1486080000</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.86</td>\n",
       "      <td>39.57</td>\n",
       "      <td>49.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017-02-03</td>\n",
       "      <td>1486166400</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Partly cloudy until afternoon.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.89</td>\n",
       "      <td>35.52</td>\n",
       "      <td>47.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017-02-04</td>\n",
       "      <td>1486252800</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.95</td>\n",
       "      <td>37.03</td>\n",
       "      <td>40.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2017-02-05</td>\n",
       "      <td>1486339200</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Mostly cloudy starting in the afternoon.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.90</td>\n",
       "      <td>32.72</td>\n",
       "      <td>44.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2017-02-06</td>\n",
       "      <td>1486425600</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Foggy in the morning.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.89</td>\n",
       "      <td>38.09</td>\n",
       "      <td>48.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2017-02-07</td>\n",
       "      <td>1486512000</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.90</td>\n",
       "      <td>35.42</td>\n",
       "      <td>39.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2017-02-08</td>\n",
       "      <td>1486598400</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Foggy overnight.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.89</td>\n",
       "      <td>33.52</td>\n",
       "      <td>35.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2017-02-09</td>\n",
       "      <td>1486684800</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Foggy until afternoon.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.94</td>\n",
       "      <td>32.72</td>\n",
       "      <td>34.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2017-02-10</td>\n",
       "      <td>1486771200</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Foggy until afternoon.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.94</td>\n",
       "      <td>31.97</td>\n",
       "      <td>35.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2017-02-11</td>\n",
       "      <td>1486857600</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Foggy starting in the evening.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.94</td>\n",
       "      <td>33.69</td>\n",
       "      <td>40.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2017-02-12</td>\n",
       "      <td>1486944000</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Foggy in the morning.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.85</td>\n",
       "      <td>37.99</td>\n",
       "      <td>48.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2017-02-13</td>\n",
       "      <td>1487030400</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.83</td>\n",
       "      <td>36.75</td>\n",
       "      <td>50.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2017-02-14</td>\n",
       "      <td>1487116800</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Foggy in the morning.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.94</td>\n",
       "      <td>45.27</td>\n",
       "      <td>51.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2017-02-15</td>\n",
       "      <td>1487203200</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Mostly cloudy until evening.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.87</td>\n",
       "      <td>42.42</td>\n",
       "      <td>51.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2017-02-16</td>\n",
       "      <td>1487289600</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Mostly cloudy until afternoon.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.86</td>\n",
       "      <td>42.33</td>\n",
       "      <td>52.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2017-02-17</td>\n",
       "      <td>1487376000</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Foggy in the morning.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.89</td>\n",
       "      <td>40.43</td>\n",
       "      <td>51.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2017-02-18</td>\n",
       "      <td>1487462400</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Mostly cloudy until evening.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.89</td>\n",
       "      <td>39.09</td>\n",
       "      <td>51.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2017-02-19</td>\n",
       "      <td>1487548800</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.88</td>\n",
       "      <td>48.72</td>\n",
       "      <td>59.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2017-02-20</td>\n",
       "      <td>1487635200</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Mostly cloudy throughout the day and breezy ov...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.90</td>\n",
       "      <td>49.27</td>\n",
       "      <td>54.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2017-02-21</td>\n",
       "      <td>1487721600</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.86</td>\n",
       "      <td>50.53</td>\n",
       "      <td>54.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2017-02-22</td>\n",
       "      <td>1487808000</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Windy and mostly cloudy until evening.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.76</td>\n",
       "      <td>40.19</td>\n",
       "      <td>50.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2017-02-23</td>\n",
       "      <td>1487894400</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Partly cloudy until afternoon.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.71</td>\n",
       "      <td>36.70</td>\n",
       "      <td>46.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2017-02-24</td>\n",
       "      <td>1487980800</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Overcast until evening.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.86</td>\n",
       "      <td>40.63</td>\n",
       "      <td>49.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2017-02-25</td>\n",
       "      <td>1488067200</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Mostly cloudy until evening.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.87</td>\n",
       "      <td>47.21</td>\n",
       "      <td>51.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2017-02-26</td>\n",
       "      <td>1488153600</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.89</td>\n",
       "      <td>37.36</td>\n",
       "      <td>46.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2017-02-27</td>\n",
       "      <td>1488240000</td>\n",
       "      <td>51.751905</td>\n",
       "      <td>9be000ae23275d57e1273d211a54ffd7</td>\n",
       "      <td>-0.340510</td>\n",
       "      <td>Mostly cloudy in the morning.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.85</td>\n",
       "      <td>34.02</td>\n",
       "      <td>44.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2017-02-12</td>\n",
       "      <td>1486944000</td>\n",
       "      <td>52.204212</td>\n",
       "      <td>a35e427b4130be7b2a892e286f0ebb91</td>\n",
       "      <td>0.120337</td>\n",
       "      <td>Clear throughout the day.</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.89</td>\n",
       "      <td>36.96</td>\n",
       "      <td>48.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2017-02-13</td>\n",
       "      <td>1487030400</td>\n",
       "      <td>52.204212</td>\n",
       "      <td>a35e427b4130be7b2a892e286f0ebb91</td>\n",
       "      <td>0.120337</td>\n",
       "      <td>Mostly cloudy starting in the afternoon.</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.86</td>\n",
       "      <td>36.06</td>\n",
       "      <td>50.94</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>317</th>\n",
       "      <td>2017-02-26</td>\n",
       "      <td>1488153600</td>\n",
       "      <td>51.669535</td>\n",
       "      <td>f5e2c06c5530335d2c994d20ed071bcb</td>\n",
       "      <td>-0.411626</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.88</td>\n",
       "      <td>37.41</td>\n",
       "      <td>47.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>318</th>\n",
       "      <td>2017-02-27</td>\n",
       "      <td>1488240000</td>\n",
       "      <td>51.669535</td>\n",
       "      <td>f5e2c06c5530335d2c994d20ed071bcb</td>\n",
       "      <td>-0.411626</td>\n",
       "      <td>Mostly cloudy in the morning.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.84</td>\n",
       "      <td>33.85</td>\n",
       "      <td>44.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>2017-02-06</td>\n",
       "      <td>1486425600</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Partly cloudy throughout the day.</td>\n",
       "      <td>98.0</td>\n",
       "      <td>0.88</td>\n",
       "      <td>39.10</td>\n",
       "      <td>49.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320</th>\n",
       "      <td>2017-02-07</td>\n",
       "      <td>1486512000</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.90</td>\n",
       "      <td>36.12</td>\n",
       "      <td>40.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321</th>\n",
       "      <td>2017-02-08</td>\n",
       "      <td>1486598400</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Foggy overnight.</td>\n",
       "      <td>98.0</td>\n",
       "      <td>0.87</td>\n",
       "      <td>33.74</td>\n",
       "      <td>35.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>322</th>\n",
       "      <td>2017-02-09</td>\n",
       "      <td>1486684800</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Foggy until afternoon.</td>\n",
       "      <td>98.0</td>\n",
       "      <td>0.94</td>\n",
       "      <td>32.42</td>\n",
       "      <td>34.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323</th>\n",
       "      <td>2017-02-10</td>\n",
       "      <td>1486771200</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Overcast throughout the day.</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.92</td>\n",
       "      <td>32.29</td>\n",
       "      <td>35.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324</th>\n",
       "      <td>2017-02-11</td>\n",
       "      <td>1486857600</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>98.0</td>\n",
       "      <td>0.92</td>\n",
       "      <td>34.30</td>\n",
       "      <td>41.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>325</th>\n",
       "      <td>2017-02-12</td>\n",
       "      <td>1486944000</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Partly cloudy in the morning.</td>\n",
       "      <td>96.0</td>\n",
       "      <td>0.83</td>\n",
       "      <td>37.95</td>\n",
       "      <td>49.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>326</th>\n",
       "      <td>2017-02-13</td>\n",
       "      <td>1487030400</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.85</td>\n",
       "      <td>35.80</td>\n",
       "      <td>49.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>327</th>\n",
       "      <td>2017-02-14</td>\n",
       "      <td>1487116800</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Foggy in the morning.</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.96</td>\n",
       "      <td>44.96</td>\n",
       "      <td>49.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>328</th>\n",
       "      <td>2017-02-15</td>\n",
       "      <td>1487203200</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.87</td>\n",
       "      <td>41.93</td>\n",
       "      <td>51.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>329</th>\n",
       "      <td>2017-02-16</td>\n",
       "      <td>1487289600</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.88</td>\n",
       "      <td>41.07</td>\n",
       "      <td>52.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>330</th>\n",
       "      <td>2017-02-17</td>\n",
       "      <td>1487376000</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Foggy in the morning.</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.90</td>\n",
       "      <td>39.52</td>\n",
       "      <td>52.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>331</th>\n",
       "      <td>2017-02-18</td>\n",
       "      <td>1487462400</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.89</td>\n",
       "      <td>38.06</td>\n",
       "      <td>51.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>332</th>\n",
       "      <td>2017-02-19</td>\n",
       "      <td>1487548800</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.90</td>\n",
       "      <td>48.59</td>\n",
       "      <td>58.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>333</th>\n",
       "      <td>2017-02-20</td>\n",
       "      <td>1487635200</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Overcast throughout the day and breezy overnight.</td>\n",
       "      <td>98.0</td>\n",
       "      <td>0.89</td>\n",
       "      <td>49.31</td>\n",
       "      <td>54.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>334</th>\n",
       "      <td>2017-02-21</td>\n",
       "      <td>1487721600</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Breezy in the morning and mostly cloudy throug...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.88</td>\n",
       "      <td>50.17</td>\n",
       "      <td>54.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>335</th>\n",
       "      <td>2017-02-22</td>\n",
       "      <td>1487808000</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Mostly cloudy throughout the day and windy unt...</td>\n",
       "      <td>97.0</td>\n",
       "      <td>0.75</td>\n",
       "      <td>40.46</td>\n",
       "      <td>50.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>336</th>\n",
       "      <td>2017-02-23</td>\n",
       "      <td>1487894400</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Partly cloudy throughout the day.</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.71</td>\n",
       "      <td>35.51</td>\n",
       "      <td>46.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>337</th>\n",
       "      <td>2017-02-24</td>\n",
       "      <td>1487980800</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Overcast throughout the day.</td>\n",
       "      <td>98.0</td>\n",
       "      <td>0.86</td>\n",
       "      <td>40.52</td>\n",
       "      <td>49.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>338</th>\n",
       "      <td>2017-02-25</td>\n",
       "      <td>1488067200</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Mostly cloudy throughout the day and breezy in...</td>\n",
       "      <td>97.0</td>\n",
       "      <td>0.89</td>\n",
       "      <td>46.85</td>\n",
       "      <td>50.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>339</th>\n",
       "      <td>2017-02-26</td>\n",
       "      <td>1488153600</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>93.0</td>\n",
       "      <td>0.88</td>\n",
       "      <td>36.46</td>\n",
       "      <td>46.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>340</th>\n",
       "      <td>2017-02-27</td>\n",
       "      <td>1488240000</td>\n",
       "      <td>51.455098</td>\n",
       "      <td>16bdd6fe40ed85ce99a456af6d7cff93</td>\n",
       "      <td>-0.968765</td>\n",
       "      <td>Mostly cloudy throughout the day and breezy st...</td>\n",
       "      <td>98.0</td>\n",
       "      <td>0.84</td>\n",
       "      <td>32.80</td>\n",
       "      <td>44.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341</th>\n",
       "      <td>2017-02-22</td>\n",
       "      <td>1487808000</td>\n",
       "      <td>50.903584</td>\n",
       "      <td>11aeddbd12e79cae8dddb694e200f00d</td>\n",
       "      <td>-1.407188</td>\n",
       "      <td>Windy and mostly cloudy until evening.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.73</td>\n",
       "      <td>41.09</td>\n",
       "      <td>49.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>342</th>\n",
       "      <td>2017-02-23</td>\n",
       "      <td>1487894400</td>\n",
       "      <td>50.903584</td>\n",
       "      <td>11aeddbd12e79cae8dddb694e200f00d</td>\n",
       "      <td>-1.407188</td>\n",
       "      <td>Partly cloudy until evening.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.67</td>\n",
       "      <td>36.11</td>\n",
       "      <td>47.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>343</th>\n",
       "      <td>2017-02-24</td>\n",
       "      <td>1487980800</td>\n",
       "      <td>50.903584</td>\n",
       "      <td>11aeddbd12e79cae8dddb694e200f00d</td>\n",
       "      <td>-1.407188</td>\n",
       "      <td>Overcast until evening.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.87</td>\n",
       "      <td>42.17</td>\n",
       "      <td>48.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>2017-02-25</td>\n",
       "      <td>1488067200</td>\n",
       "      <td>50.903584</td>\n",
       "      <td>11aeddbd12e79cae8dddb694e200f00d</td>\n",
       "      <td>-1.407188</td>\n",
       "      <td>Mostly cloudy throughout the day and breezy in...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.93</td>\n",
       "      <td>46.23</td>\n",
       "      <td>49.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>345</th>\n",
       "      <td>2017-02-26</td>\n",
       "      <td>1488153600</td>\n",
       "      <td>50.903584</td>\n",
       "      <td>11aeddbd12e79cae8dddb694e200f00d</td>\n",
       "      <td>-1.407188</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.87</td>\n",
       "      <td>36.36</td>\n",
       "      <td>46.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>346</th>\n",
       "      <td>2017-02-27</td>\n",
       "      <td>1488240000</td>\n",
       "      <td>50.903584</td>\n",
       "      <td>11aeddbd12e79cae8dddb694e200f00d</td>\n",
       "      <td>-1.407188</td>\n",
       "      <td>Partly cloudy throughout the day and breezy st...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.79</td>\n",
       "      <td>30.60</td>\n",
       "      <td>45.04</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>347 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           date       epoch        lat                            loc_id  \\\n",
       "0    2017-01-31  1485907200  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "1    2017-02-01  1485993600  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "2    2017-02-02  1486080000  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "3    2017-02-03  1486166400  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "4    2017-02-04  1486252800  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "5    2017-02-05  1486339200  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "6    2017-02-06  1486425600  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "7    2017-02-07  1486512000  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "8    2017-02-08  1486598400  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "9    2017-02-09  1486684800  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "10   2017-02-10  1486771200  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "11   2017-02-11  1486857600  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "12   2017-02-12  1486944000  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "13   2017-02-13  1487030400  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "14   2017-02-14  1487116800  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "15   2017-02-15  1487203200  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "16   2017-02-16  1487289600  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "17   2017-02-17  1487376000  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "18   2017-02-18  1487462400  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "19   2017-02-19  1487548800  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "20   2017-02-20  1487635200  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "21   2017-02-21  1487721600  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "22   2017-02-22  1487808000  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "23   2017-02-23  1487894400  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "24   2017-02-24  1487980800  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "25   2017-02-25  1488067200  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "26   2017-02-26  1488153600  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "27   2017-02-27  1488240000  51.751905  9be000ae23275d57e1273d211a54ffd7   \n",
       "28   2017-02-12  1486944000  52.204212  a35e427b4130be7b2a892e286f0ebb91   \n",
       "29   2017-02-13  1487030400  52.204212  a35e427b4130be7b2a892e286f0ebb91   \n",
       "..          ...         ...        ...                               ...   \n",
       "317  2017-02-26  1488153600  51.669535  f5e2c06c5530335d2c994d20ed071bcb   \n",
       "318  2017-02-27  1488240000  51.669535  f5e2c06c5530335d2c994d20ed071bcb   \n",
       "319  2017-02-06  1486425600  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "320  2017-02-07  1486512000  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "321  2017-02-08  1486598400  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "322  2017-02-09  1486684800  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "323  2017-02-10  1486771200  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "324  2017-02-11  1486857600  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "325  2017-02-12  1486944000  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "326  2017-02-13  1487030400  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "327  2017-02-14  1487116800  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "328  2017-02-15  1487203200  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "329  2017-02-16  1487289600  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "330  2017-02-17  1487376000  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "331  2017-02-18  1487462400  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "332  2017-02-19  1487548800  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "333  2017-02-20  1487635200  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "334  2017-02-21  1487721600  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "335  2017-02-22  1487808000  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "336  2017-02-23  1487894400  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "337  2017-02-24  1487980800  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "338  2017-02-25  1488067200  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "339  2017-02-26  1488153600  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "340  2017-02-27  1488240000  51.455098  16bdd6fe40ed85ce99a456af6d7cff93   \n",
       "341  2017-02-22  1487808000  50.903584  11aeddbd12e79cae8dddb694e200f00d   \n",
       "342  2017-02-23  1487894400  50.903584  11aeddbd12e79cae8dddb694e200f00d   \n",
       "343  2017-02-24  1487980800  50.903584  11aeddbd12e79cae8dddb694e200f00d   \n",
       "344  2017-02-25  1488067200  50.903584  11aeddbd12e79cae8dddb694e200f00d   \n",
       "345  2017-02-26  1488153600  50.903584  11aeddbd12e79cae8dddb694e200f00d   \n",
       "346  2017-02-27  1488240000  50.903584  11aeddbd12e79cae8dddb694e200f00d   \n",
       "\n",
       "          long                                            summary  \\\n",
       "0    -0.340510                              Foggy in the morning.   \n",
       "1    -0.340510                  Mostly cloudy throughout the day.   \n",
       "2    -0.340510                  Mostly cloudy throughout the day.   \n",
       "3    -0.340510                     Partly cloudy until afternoon.   \n",
       "4    -0.340510                  Mostly cloudy throughout the day.   \n",
       "5    -0.340510           Mostly cloudy starting in the afternoon.   \n",
       "6    -0.340510                              Foggy in the morning.   \n",
       "7    -0.340510                  Mostly cloudy throughout the day.   \n",
       "8    -0.340510                                   Foggy overnight.   \n",
       "9    -0.340510                             Foggy until afternoon.   \n",
       "10   -0.340510                             Foggy until afternoon.   \n",
       "11   -0.340510                     Foggy starting in the evening.   \n",
       "12   -0.340510                              Foggy in the morning.   \n",
       "13   -0.340510                  Mostly cloudy throughout the day.   \n",
       "14   -0.340510                              Foggy in the morning.   \n",
       "15   -0.340510                       Mostly cloudy until evening.   \n",
       "16   -0.340510                     Mostly cloudy until afternoon.   \n",
       "17   -0.340510                              Foggy in the morning.   \n",
       "18   -0.340510                       Mostly cloudy until evening.   \n",
       "19   -0.340510                  Mostly cloudy throughout the day.   \n",
       "20   -0.340510  Mostly cloudy throughout the day and breezy ov...   \n",
       "21   -0.340510                  Mostly cloudy throughout the day.   \n",
       "22   -0.340510             Windy and mostly cloudy until evening.   \n",
       "23   -0.340510                     Partly cloudy until afternoon.   \n",
       "24   -0.340510                            Overcast until evening.   \n",
       "25   -0.340510                       Mostly cloudy until evening.   \n",
       "26   -0.340510                  Mostly cloudy throughout the day.   \n",
       "27   -0.340510                      Mostly cloudy in the morning.   \n",
       "28    0.120337                          Clear throughout the day.   \n",
       "29    0.120337           Mostly cloudy starting in the afternoon.   \n",
       "..         ...                                                ...   \n",
       "317  -0.411626                  Mostly cloudy throughout the day.   \n",
       "318  -0.411626                      Mostly cloudy in the morning.   \n",
       "319  -0.968765                  Partly cloudy throughout the day.   \n",
       "320  -0.968765                  Mostly cloudy throughout the day.   \n",
       "321  -0.968765                                   Foggy overnight.   \n",
       "322  -0.968765                             Foggy until afternoon.   \n",
       "323  -0.968765                       Overcast throughout the day.   \n",
       "324  -0.968765                  Mostly cloudy throughout the day.   \n",
       "325  -0.968765                      Partly cloudy in the morning.   \n",
       "326  -0.968765                  Mostly cloudy throughout the day.   \n",
       "327  -0.968765                              Foggy in the morning.   \n",
       "328  -0.968765                  Mostly cloudy throughout the day.   \n",
       "329  -0.968765                  Mostly cloudy throughout the day.   \n",
       "330  -0.968765                              Foggy in the morning.   \n",
       "331  -0.968765                  Mostly cloudy throughout the day.   \n",
       "332  -0.968765                  Mostly cloudy throughout the day.   \n",
       "333  -0.968765  Overcast throughout the day and breezy overnight.   \n",
       "334  -0.968765  Breezy in the morning and mostly cloudy throug...   \n",
       "335  -0.968765  Mostly cloudy throughout the day and windy unt...   \n",
       "336  -0.968765                  Partly cloudy throughout the day.   \n",
       "337  -0.968765                       Overcast throughout the day.   \n",
       "338  -0.968765  Mostly cloudy throughout the day and breezy in...   \n",
       "339  -0.968765                  Mostly cloudy throughout the day.   \n",
       "340  -0.968765  Mostly cloudy throughout the day and breezy st...   \n",
       "341  -1.407188             Windy and mostly cloudy until evening.   \n",
       "342  -1.407188                       Partly cloudy until evening.   \n",
       "343  -1.407188                            Overcast until evening.   \n",
       "344  -1.407188  Mostly cloudy throughout the day and breezy in...   \n",
       "345  -1.407188                  Mostly cloudy throughout the day.   \n",
       "346  -1.407188  Partly cloudy throughout the day and breezy st...   \n",
       "\n",
       "     precipProbability  humidity  temperatureMin  temperatureMax  \n",
       "0                 -1.0      0.96           46.65           50.46  \n",
       "1                 -1.0      0.90           48.01           51.10  \n",
       "2                 -1.0      0.86           39.57           49.72  \n",
       "3                 -1.0      0.89           35.52           47.23  \n",
       "4                 -1.0      0.95           37.03           40.84  \n",
       "5                 -1.0      0.90           32.72           44.36  \n",
       "6                 -1.0      0.89           38.09           48.87  \n",
       "7                 -1.0      0.90           35.42           39.48  \n",
       "8                 -1.0      0.89           33.52           35.11  \n",
       "9                 -1.0      0.94           32.72           34.48  \n",
       "10                -1.0      0.94           31.97           35.39  \n",
       "11                -1.0      0.94           33.69           40.66  \n",
       "12                -1.0      0.85           37.99           48.04  \n",
       "13                -1.0      0.83           36.75           50.06  \n",
       "14                -1.0      0.94           45.27           51.64  \n",
       "15                -1.0      0.87           42.42           51.16  \n",
       "16                -1.0      0.86           42.33           52.93  \n",
       "17                -1.0      0.89           40.43           51.39  \n",
       "18                -1.0      0.89           39.09           51.83  \n",
       "19                -1.0      0.88           48.72           59.87  \n",
       "20                -1.0      0.90           49.27           54.15  \n",
       "21                -1.0      0.86           50.53           54.53  \n",
       "22                -1.0      0.76           40.19           50.71  \n",
       "23                -1.0      0.71           36.70           46.83  \n",
       "24                -1.0      0.86           40.63           49.36  \n",
       "25                -1.0      0.87           47.21           51.72  \n",
       "26                -1.0      0.89           37.36           46.73  \n",
       "27                -1.0      0.85           34.02           44.46  \n",
       "28                 0.0      0.89           36.96           48.83  \n",
       "29                 0.0      0.86           36.06           50.94  \n",
       "..                 ...       ...             ...             ...  \n",
       "317               -1.0      0.88           37.41           47.08  \n",
       "318               -1.0      0.84           33.85           44.83  \n",
       "319               98.0      0.88           39.10           49.18  \n",
       "320                0.0      0.90           36.12           40.36  \n",
       "321               98.0      0.87           33.74           35.61  \n",
       "322               98.0      0.94           32.42           34.79  \n",
       "323                0.0      0.92           32.29           35.58  \n",
       "324               98.0      0.92           34.30           41.10  \n",
       "325               96.0      0.83           37.95           49.47  \n",
       "326                0.0      0.85           35.80           49.64  \n",
       "327                0.0      0.96           44.96           49.63  \n",
       "328                0.0      0.87           41.93           51.42  \n",
       "329                0.0      0.88           41.07           52.44  \n",
       "330                0.0      0.90           39.52           52.31  \n",
       "331                0.0      0.89           38.06           51.55  \n",
       "332                0.0      0.90           48.59           58.82  \n",
       "333               98.0      0.89           49.31           54.14  \n",
       "334                0.0      0.88           50.17           54.08  \n",
       "335               97.0      0.75           40.46           50.22  \n",
       "336                0.0      0.71           35.51           46.92  \n",
       "337               98.0      0.86           40.52           49.52  \n",
       "338               97.0      0.89           46.85           50.89  \n",
       "339               93.0      0.88           36.46           46.54  \n",
       "340               98.0      0.84           32.80           44.78  \n",
       "341               -1.0      0.73           41.09           49.97  \n",
       "342               -1.0      0.67           36.11           47.98  \n",
       "343               -1.0      0.87           42.17           48.29  \n",
       "344               -1.0      0.93           46.23           49.95  \n",
       "345               -1.0      0.87           36.36           46.68  \n",
       "346               -1.0      0.79           30.60           45.04  \n",
       "\n",
       "[347 rows x 10 columns]"
      ]
     },
     "execution_count": 177,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_locations_cleaned[[\n",
    "    \"summary\", \n",
    "    \"precipProbability\", \n",
    "    \"humidity\", \n",
    "    \"temperatureMin\", \n",
    "    \"temperatureMax\"]] = df_locations_cleaned.apply(get_weather, axis=1)\n",
    "df_locations_cleaned"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Pivot data frame as precipitation report\n",
    "With the precipitation data appended to the cleaned data frame, a pivot of the data frame produces a simple precipitation report."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 179,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>date</th>\n",
       "      <th>2017-01-31</th>\n",
       "      <th>2017-02-01</th>\n",
       "      <th>2017-02-02</th>\n",
       "      <th>2017-02-03</th>\n",
       "      <th>2017-02-04</th>\n",
       "      <th>2017-02-05</th>\n",
       "      <th>2017-02-06</th>\n",
       "      <th>2017-02-07</th>\n",
       "      <th>2017-02-08</th>\n",
       "      <th>2017-02-09</th>\n",
       "      <th>...</th>\n",
       "      <th>2017-02-18</th>\n",
       "      <th>2017-02-19</th>\n",
       "      <th>2017-02-20</th>\n",
       "      <th>2017-02-21</th>\n",
       "      <th>2017-02-22</th>\n",
       "      <th>2017-02-23</th>\n",
       "      <th>2017-02-24</th>\n",
       "      <th>2017-02-25</th>\n",
       "      <th>2017-02-26</th>\n",
       "      <th>2017-02-27</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>loc_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>07d09eab6c837d4b0c0b17aba37e1dcf</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11aeddbd12e79cae8dddb694e200f00d</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16bdd6fe40ed85ce99a456af6d7cff93</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>98.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>98.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185674a2eb5c14fbdbb1d05a4109ea55</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5180af03094779de849ca816c9f5b753</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51fa5362e943615c7b31d367b461fd2c</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58f7d1d3ce8cc4e808bf840b56714b38</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>98.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5f1ce9b7c8cd32c08d98310540fb6604</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>98.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7f2aa8e72612f9130e06b32a0d2a58d7</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81cea1e224ad183b751acce139f4e276</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84d414ec45c5b436c8470ce314c3b83f</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8b049b660e984912c48da213f2f7c650</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9be000ae23275d57e1273d211a54ffd7</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>a35e427b4130be7b2a892e286f0ebb91</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>74.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>afbddd7f957a1c822293616e95a2d84c</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>c60d40fa98e6235ba0d1485c4253bfe6</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>f5e2c06c5530335d2c994d20ed071bcb</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>f69e492442cd452124c75e6805d8e37d</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>f8a762f49d2abffe630be60295f71ed0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fe5d591b3509247487a917d4e8a33f65</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "date                              2017-01-31  2017-02-01  2017-02-02  \\\n",
       "loc_id                                                                 \n",
       "07d09eab6c837d4b0c0b17aba37e1dcf         NaN         NaN         NaN   \n",
       "11aeddbd12e79cae8dddb694e200f00d         NaN         NaN         NaN   \n",
       "16bdd6fe40ed85ce99a456af6d7cff93         NaN         NaN         NaN   \n",
       "185674a2eb5c14fbdbb1d05a4109ea55         NaN         NaN         NaN   \n",
       "5180af03094779de849ca816c9f5b753         NaN         NaN         NaN   \n",
       "51fa5362e943615c7b31d367b461fd2c         NaN         NaN         NaN   \n",
       "58f7d1d3ce8cc4e808bf840b56714b38         NaN         NaN         NaN   \n",
       "5f1ce9b7c8cd32c08d98310540fb6604         NaN         NaN         NaN   \n",
       "7f2aa8e72612f9130e06b32a0d2a58d7        -1.0        -1.0        -1.0   \n",
       "81cea1e224ad183b751acce139f4e276         NaN         NaN        -1.0   \n",
       "84d414ec45c5b436c8470ce314c3b83f         NaN         NaN        -1.0   \n",
       "8b049b660e984912c48da213f2f7c650         NaN         NaN         NaN   \n",
       "9be000ae23275d57e1273d211a54ffd7        -1.0        -1.0        -1.0   \n",
       "a35e427b4130be7b2a892e286f0ebb91         NaN         NaN         NaN   \n",
       "afbddd7f957a1c822293616e95a2d84c         NaN         NaN         NaN   \n",
       "c60d40fa98e6235ba0d1485c4253bfe6         NaN         NaN         NaN   \n",
       "f5e2c06c5530335d2c994d20ed071bcb         NaN         NaN         NaN   \n",
       "f69e492442cd452124c75e6805d8e37d         NaN         NaN         NaN   \n",
       "f8a762f49d2abffe630be60295f71ed0         NaN         NaN         NaN   \n",
       "fe5d591b3509247487a917d4e8a33f65         NaN         NaN         NaN   \n",
       "\n",
       "date                              2017-02-03  2017-02-04  2017-02-05  \\\n",
       "loc_id                                                                 \n",
       "07d09eab6c837d4b0c0b17aba37e1dcf         NaN         NaN         NaN   \n",
       "11aeddbd12e79cae8dddb694e200f00d         NaN         NaN         NaN   \n",
       "16bdd6fe40ed85ce99a456af6d7cff93         NaN         NaN         NaN   \n",
       "185674a2eb5c14fbdbb1d05a4109ea55         NaN         NaN         NaN   \n",
       "5180af03094779de849ca816c9f5b753         NaN         NaN         NaN   \n",
       "51fa5362e943615c7b31d367b461fd2c         NaN         NaN         NaN   \n",
       "58f7d1d3ce8cc4e808bf840b56714b38         NaN         NaN         NaN   \n",
       "5f1ce9b7c8cd32c08d98310540fb6604         NaN         NaN         NaN   \n",
       "7f2aa8e72612f9130e06b32a0d2a58d7        -1.0        -1.0        -1.0   \n",
       "81cea1e224ad183b751acce139f4e276        -1.0        -1.0        -1.0   \n",
       "84d414ec45c5b436c8470ce314c3b83f        -1.0        -1.0        -1.0   \n",
       "8b049b660e984912c48da213f2f7c650         NaN         NaN         NaN   \n",
       "9be000ae23275d57e1273d211a54ffd7        -1.0        -1.0        -1.0   \n",
       "a35e427b4130be7b2a892e286f0ebb91         NaN         NaN         NaN   \n",
       "afbddd7f957a1c822293616e95a2d84c         NaN         NaN         NaN   \n",
       "c60d40fa98e6235ba0d1485c4253bfe6         NaN         NaN         NaN   \n",
       "f5e2c06c5530335d2c994d20ed071bcb         NaN         NaN         NaN   \n",
       "f69e492442cd452124c75e6805d8e37d         NaN         NaN         NaN   \n",
       "f8a762f49d2abffe630be60295f71ed0         NaN         NaN         NaN   \n",
       "fe5d591b3509247487a917d4e8a33f65         NaN         NaN         NaN   \n",
       "\n",
       "date                              2017-02-06  2017-02-07  2017-02-08  \\\n",
       "loc_id                                                                 \n",
       "07d09eab6c837d4b0c0b17aba37e1dcf         NaN         NaN         NaN   \n",
       "11aeddbd12e79cae8dddb694e200f00d         NaN         NaN         NaN   \n",
       "16bdd6fe40ed85ce99a456af6d7cff93        98.0         0.0        98.0   \n",
       "185674a2eb5c14fbdbb1d05a4109ea55        -1.0        -1.0        -1.0   \n",
       "5180af03094779de849ca816c9f5b753         NaN         NaN         NaN   \n",
       "51fa5362e943615c7b31d367b461fd2c         NaN         NaN         NaN   \n",
       "58f7d1d3ce8cc4e808bf840b56714b38         NaN         NaN         NaN   \n",
       "5f1ce9b7c8cd32c08d98310540fb6604         NaN         NaN         NaN   \n",
       "7f2aa8e72612f9130e06b32a0d2a58d7        -1.0        -1.0        -1.0   \n",
       "81cea1e224ad183b751acce139f4e276        -1.0        -1.0        -1.0   \n",
       "84d414ec45c5b436c8470ce314c3b83f        -1.0        -1.0        -1.0   \n",
       "8b049b660e984912c48da213f2f7c650        -1.0        -1.0        -1.0   \n",
       "9be000ae23275d57e1273d211a54ffd7        -1.0        -1.0        -1.0   \n",
       "a35e427b4130be7b2a892e286f0ebb91         NaN         NaN         NaN   \n",
       "afbddd7f957a1c822293616e95a2d84c         NaN        -1.0        -1.0   \n",
       "c60d40fa98e6235ba0d1485c4253bfe6         NaN         NaN         NaN   \n",
       "f5e2c06c5530335d2c994d20ed071bcb         NaN        -1.0        -1.0   \n",
       "f69e492442cd452124c75e6805d8e37d         NaN         NaN         NaN   \n",
       "f8a762f49d2abffe630be60295f71ed0         NaN         NaN         NaN   \n",
       "fe5d591b3509247487a917d4e8a33f65         NaN        -1.0        -1.0   \n",
       "\n",
       "date                              2017-02-09     ...      2017-02-18  \\\n",
       "loc_id                                           ...                   \n",
       "07d09eab6c837d4b0c0b17aba37e1dcf         NaN     ...             NaN   \n",
       "11aeddbd12e79cae8dddb694e200f00d         NaN     ...             NaN   \n",
       "16bdd6fe40ed85ce99a456af6d7cff93        98.0     ...             0.0   \n",
       "185674a2eb5c14fbdbb1d05a4109ea55        -1.0     ...            -1.0   \n",
       "5180af03094779de849ca816c9f5b753         NaN     ...            -1.0   \n",
       "51fa5362e943615c7b31d367b461fd2c         NaN     ...             NaN   \n",
       "58f7d1d3ce8cc4e808bf840b56714b38         NaN     ...             0.0   \n",
       "5f1ce9b7c8cd32c08d98310540fb6604         NaN     ...             0.0   \n",
       "7f2aa8e72612f9130e06b32a0d2a58d7        -1.0     ...            -1.0   \n",
       "81cea1e224ad183b751acce139f4e276        -1.0     ...            -1.0   \n",
       "84d414ec45c5b436c8470ce314c3b83f        -1.0     ...            -1.0   \n",
       "8b049b660e984912c48da213f2f7c650        -1.0     ...            -1.0   \n",
       "9be000ae23275d57e1273d211a54ffd7        -1.0     ...            -1.0   \n",
       "a35e427b4130be7b2a892e286f0ebb91         NaN     ...             0.0   \n",
       "afbddd7f957a1c822293616e95a2d84c        -1.0     ...            -1.0   \n",
       "c60d40fa98e6235ba0d1485c4253bfe6         NaN     ...            -1.0   \n",
       "f5e2c06c5530335d2c994d20ed071bcb        -1.0     ...            -1.0   \n",
       "f69e492442cd452124c75e6805d8e37d         NaN     ...            -1.0   \n",
       "f8a762f49d2abffe630be60295f71ed0         NaN     ...             NaN   \n",
       "fe5d591b3509247487a917d4e8a33f65        -1.0     ...            -1.0   \n",
       "\n",
       "date                              2017-02-19  2017-02-20  2017-02-21  \\\n",
       "loc_id                                                                 \n",
       "07d09eab6c837d4b0c0b17aba37e1dcf         NaN        -1.0        -1.0   \n",
       "11aeddbd12e79cae8dddb694e200f00d         NaN         NaN         NaN   \n",
       "16bdd6fe40ed85ce99a456af6d7cff93         0.0        98.0         0.0   \n",
       "185674a2eb5c14fbdbb1d05a4109ea55        -1.0        -1.0        -1.0   \n",
       "5180af03094779de849ca816c9f5b753        -1.0        -1.0        -1.0   \n",
       "51fa5362e943615c7b31d367b461fd2c         NaN         NaN         NaN   \n",
       "58f7d1d3ce8cc4e808bf840b56714b38         0.0        98.0         0.0   \n",
       "5f1ce9b7c8cd32c08d98310540fb6604         0.0        98.0         0.0   \n",
       "7f2aa8e72612f9130e06b32a0d2a58d7        -1.0        -1.0        -1.0   \n",
       "81cea1e224ad183b751acce139f4e276        -1.0        -1.0        -1.0   \n",
       "84d414ec45c5b436c8470ce314c3b83f        -1.0        -1.0        -1.0   \n",
       "8b049b660e984912c48da213f2f7c650        -1.0        -1.0        -1.0   \n",
       "9be000ae23275d57e1273d211a54ffd7        -1.0        -1.0        -1.0   \n",
       "a35e427b4130be7b2a892e286f0ebb91         0.0         0.0        67.0   \n",
       "afbddd7f957a1c822293616e95a2d84c        -1.0        -1.0        -1.0   \n",
       "c60d40fa98e6235ba0d1485c4253bfe6        -1.0        -1.0        -1.0   \n",
       "f5e2c06c5530335d2c994d20ed071bcb        -1.0        -1.0        -1.0   \n",
       "f69e492442cd452124c75e6805d8e37d        -1.0        -1.0        -1.0   \n",
       "f8a762f49d2abffe630be60295f71ed0         NaN        -1.0        -1.0   \n",
       "fe5d591b3509247487a917d4e8a33f65        -1.0        -1.0        -1.0   \n",
       "\n",
       "date                              2017-02-22  2017-02-23  2017-02-24  \\\n",
       "loc_id                                                                 \n",
       "07d09eab6c837d4b0c0b17aba37e1dcf        -1.0        -1.0        -1.0   \n",
       "11aeddbd12e79cae8dddb694e200f00d        -1.0        -1.0        -1.0   \n",
       "16bdd6fe40ed85ce99a456af6d7cff93        97.0         0.0        98.0   \n",
       "185674a2eb5c14fbdbb1d05a4109ea55        -1.0        -1.0        -1.0   \n",
       "5180af03094779de849ca816c9f5b753        -1.0        -1.0        -1.0   \n",
       "51fa5362e943615c7b31d367b461fd2c        -1.0        -1.0        -1.0   \n",
       "58f7d1d3ce8cc4e808bf840b56714b38        97.0         0.0        98.0   \n",
       "5f1ce9b7c8cd32c08d98310540fb6604        97.0         0.0        98.0   \n",
       "7f2aa8e72612f9130e06b32a0d2a58d7        -1.0        -1.0        -1.0   \n",
       "81cea1e224ad183b751acce139f4e276        -1.0        -1.0        -1.0   \n",
       "84d414ec45c5b436c8470ce314c3b83f        -1.0        -1.0        -1.0   \n",
       "8b049b660e984912c48da213f2f7c650        -1.0        -1.0        -1.0   \n",
       "9be000ae23275d57e1273d211a54ffd7        -1.0        -1.0        -1.0   \n",
       "a35e427b4130be7b2a892e286f0ebb91        66.0         0.0        52.0   \n",
       "afbddd7f957a1c822293616e95a2d84c        -1.0        -1.0        -1.0   \n",
       "c60d40fa98e6235ba0d1485c4253bfe6        -1.0        -1.0        -1.0   \n",
       "f5e2c06c5530335d2c994d20ed071bcb        -1.0        -1.0        -1.0   \n",
       "f69e492442cd452124c75e6805d8e37d        -1.0        -1.0        -1.0   \n",
       "f8a762f49d2abffe630be60295f71ed0        -1.0        -1.0        -1.0   \n",
       "fe5d591b3509247487a917d4e8a33f65        -1.0        -1.0        -1.0   \n",
       "\n",
       "date                              2017-02-25  2017-02-26  2017-02-27  \n",
       "loc_id                                                                \n",
       "07d09eab6c837d4b0c0b17aba37e1dcf        -1.0        -1.0        -1.0  \n",
       "11aeddbd12e79cae8dddb694e200f00d        -1.0        -1.0        -1.0  \n",
       "16bdd6fe40ed85ce99a456af6d7cff93        97.0        93.0        98.0  \n",
       "185674a2eb5c14fbdbb1d05a4109ea55        -1.0        -1.0        -1.0  \n",
       "5180af03094779de849ca816c9f5b753        -1.0        -1.0        -1.0  \n",
       "51fa5362e943615c7b31d367b461fd2c        -1.0        -1.0        -1.0  \n",
       "58f7d1d3ce8cc4e808bf840b56714b38        97.0        93.0        98.0  \n",
       "5f1ce9b7c8cd32c08d98310540fb6604        97.0        93.0        98.0  \n",
       "7f2aa8e72612f9130e06b32a0d2a58d7        -1.0        -1.0        -1.0  \n",
       "81cea1e224ad183b751acce139f4e276        -1.0        -1.0        -1.0  \n",
       "84d414ec45c5b436c8470ce314c3b83f        -1.0        -1.0        -1.0  \n",
       "8b049b660e984912c48da213f2f7c650        -1.0        -1.0        -1.0  \n",
       "9be000ae23275d57e1273d211a54ffd7        -1.0        -1.0        -1.0  \n",
       "a35e427b4130be7b2a892e286f0ebb91        64.0        57.0        74.0  \n",
       "afbddd7f957a1c822293616e95a2d84c        -1.0        -1.0        -1.0  \n",
       "c60d40fa98e6235ba0d1485c4253bfe6        -1.0        -1.0        -1.0  \n",
       "f5e2c06c5530335d2c994d20ed071bcb        -1.0        -1.0        -1.0  \n",
       "f69e492442cd452124c75e6805d8e37d        -1.0        -1.0        -1.0  \n",
       "f8a762f49d2abffe630be60295f71ed0        -1.0        -1.0        -1.0  \n",
       "fe5d591b3509247487a917d4e8a33f65        -1.0        -1.0        -1.0  \n",
       "\n",
       "[20 rows x 28 columns]"
      ]
     },
     "execution_count": 179,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_locations_cleaned.pivot(index='loc_id', columns='date', values='precipProbability')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Analysis of precipitation report\n",
    "In looking at the list of 20 locations, it is evident that precipitation data is only collected at select locations. In the list of 20 locations, only 4 locations had any precipitation data available from Dark Sky."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# To Do\n",
    "+ Error checking for weather data\n",
    "+ Collect more weather data from other sources\n",
    "+ Improve check for precipitation percentages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "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.5.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}