Weather Station Data Query.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "    <div class=\"bk-root\">\n",
       "        <a href=\"https://bokeh.pydata.org\" target=\"_blank\" class=\"bk-logo bk-logo-small bk-logo-notebook\"></a>\n",
       "        <span id=\"0b7fc20c-3a02-49a4-b190-86f4f0b8f95f\">Loading BokehJS ...</span>\n",
       "    </div>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "\n",
       "(function(root) {\n",
       "  function now() {\n",
       "    return new Date();\n",
       "  }\n",
       "\n",
       "  var force = true;\n",
       "\n",
       "  if (typeof (root._bokeh_onload_callbacks) === \"undefined\" || force === true) {\n",
       "    root._bokeh_onload_callbacks = [];\n",
       "    root._bokeh_is_loading = undefined;\n",
       "  }\n",
       "\n",
       "  var JS_MIME_TYPE = 'application/javascript';\n",
       "  var HTML_MIME_TYPE = 'text/html';\n",
       "  var EXEC_MIME_TYPE = 'application/vnd.bokehjs_exec.v0+json';\n",
       "  var CLASS_NAME = 'output_bokeh rendered_html';\n",
       "\n",
       "  /**\n",
       "   * Render data to the DOM node\n",
       "   */\n",
       "  function render(props, node) {\n",
       "    var script = document.createElement(\"script\");\n",
       "    node.appendChild(script);\n",
       "  }\n",
       "\n",
       "  /**\n",
       "   * Handle when an output is cleared or removed\n",
       "   */\n",
       "  function handleClearOutput(event, handle) {\n",
       "    var cell = handle.cell;\n",
       "\n",
       "    var id = cell.output_area._bokeh_element_id;\n",
       "    var server_id = cell.output_area._bokeh_server_id;\n",
       "    // Clean up Bokeh references\n",
       "    if (id != null && id in Bokeh.index) {\n",
       "      Bokeh.index[id].model.document.clear();\n",
       "      delete Bokeh.index[id];\n",
       "    }\n",
       "\n",
       "    if (server_id !== undefined) {\n",
       "      // Clean up Bokeh references\n",
       "      var cmd = \"from bokeh.io.state import curstate; print(curstate().uuid_to_server['\" + server_id + \"'].get_sessions()[0].document.roots[0]._id)\";\n",
       "      cell.notebook.kernel.execute(cmd, {\n",
       "        iopub: {\n",
       "          output: function(msg) {\n",
       "            var id = msg.content.text.trim();\n",
       "            if (id in Bokeh.index) {\n",
       "              Bokeh.index[id].model.document.clear();\n",
       "              delete Bokeh.index[id];\n",
       "            }\n",
       "          }\n",
       "        }\n",
       "      });\n",
       "      // Destroy server and session\n",
       "      var cmd = \"import bokeh.io.notebook as ion; ion.destroy_server('\" + server_id + \"')\";\n",
       "      cell.notebook.kernel.execute(cmd);\n",
       "    }\n",
       "  }\n",
       "\n",
       "  /**\n",
       "   * Handle when a new output is added\n",
       "   */\n",
       "  function handleAddOutput(event, handle) {\n",
       "    var output_area = handle.output_area;\n",
       "    var output = handle.output;\n",
       "\n",
       "    // limit handleAddOutput to display_data with EXEC_MIME_TYPE content only\n",
       "    if ((output.output_type != \"display_data\") || (!output.data.hasOwnProperty(EXEC_MIME_TYPE))) {\n",
       "      return\n",
       "    }\n",
       "\n",
       "    var toinsert = output_area.element.find(\".\" + CLASS_NAME.split(' ')[0]);\n",
       "\n",
       "    if (output.metadata[EXEC_MIME_TYPE][\"id\"] !== undefined) {\n",
       "      toinsert[toinsert.length - 1].firstChild.textContent = output.data[JS_MIME_TYPE];\n",
       "      // store reference to embed id on output_area\n",
       "      output_area._bokeh_element_id = output.metadata[EXEC_MIME_TYPE][\"id\"];\n",
       "    }\n",
       "    if (output.metadata[EXEC_MIME_TYPE][\"server_id\"] !== undefined) {\n",
       "      var bk_div = document.createElement(\"div\");\n",
       "      bk_div.innerHTML = output.data[HTML_MIME_TYPE];\n",
       "      var script_attrs = bk_div.children[0].attributes;\n",
       "      for (var i = 0; i < script_attrs.length; i++) {\n",
       "        toinsert[toinsert.length - 1].firstChild.setAttribute(script_attrs[i].name, script_attrs[i].value);\n",
       "      }\n",
       "      // store reference to server id on output_area\n",
       "      output_area._bokeh_server_id = output.metadata[EXEC_MIME_TYPE][\"server_id\"];\n",
       "    }\n",
       "  }\n",
       "\n",
       "  function register_renderer(events, OutputArea) {\n",
       "\n",
       "    function append_mime(data, metadata, element) {\n",
       "      // create a DOM node to render to\n",
       "      var toinsert = this.create_output_subarea(\n",
       "        metadata,\n",
       "        CLASS_NAME,\n",
       "        EXEC_MIME_TYPE\n",
       "      );\n",
       "      this.keyboard_manager.register_events(toinsert);\n",
       "      // Render to node\n",
       "      var props = {data: data, metadata: metadata[EXEC_MIME_TYPE]};\n",
       "      render(props, toinsert[toinsert.length - 1]);\n",
       "      element.append(toinsert);\n",
       "      return toinsert\n",
       "    }\n",
       "\n",
       "    /* Handle when an output is cleared or removed */\n",
       "    events.on('clear_output.CodeCell', handleClearOutput);\n",
       "    events.on('delete.Cell', handleClearOutput);\n",
       "\n",
       "    /* Handle when a new output is added */\n",
       "    events.on('output_added.OutputArea', handleAddOutput);\n",
       "\n",
       "    /**\n",
       "     * Register the mime type and append_mime function with output_area\n",
       "     */\n",
       "    OutputArea.prototype.register_mime_type(EXEC_MIME_TYPE, append_mime, {\n",
       "      /* Is output safe? */\n",
       "      safe: true,\n",
       "      /* Index of renderer in `output_area.display_order` */\n",
       "      index: 0\n",
       "    });\n",
       "  }\n",
       "\n",
       "  // register the mime type if in Jupyter Notebook environment and previously unregistered\n",
       "  if (root.Jupyter !== undefined) {\n",
       "    var events = require('base/js/events');\n",
       "    var OutputArea = require('notebook/js/outputarea').OutputArea;\n",
       "\n",
       "    if (OutputArea.prototype.mime_types().indexOf(EXEC_MIME_TYPE) == -1) {\n",
       "      register_renderer(events, OutputArea);\n",
       "    }\n",
       "  }\n",
       "\n",
       "  \n",
       "  if (typeof (root._bokeh_timeout) === \"undefined\" || force === true) {\n",
       "    root._bokeh_timeout = Date.now() + 5000;\n",
       "    root._bokeh_failed_load = false;\n",
       "  }\n",
       "\n",
       "  var NB_LOAD_WARNING = {'data': {'text/html':\n",
       "     \"<div style='background-color: #fdd'>\\n\"+\n",
       "     \"<p>\\n\"+\n",
       "     \"BokehJS does not appear to have successfully loaded. If loading BokehJS from CDN, this \\n\"+\n",
       "     \"may be due to a slow or bad network connection. Possible fixes:\\n\"+\n",
       "     \"</p>\\n\"+\n",
       "     \"<ul>\\n\"+\n",
       "     \"<li>re-rerun `output_notebook()` to attempt to load from CDN again, or</li>\\n\"+\n",
       "     \"<li>use INLINE resources instead, as so:</li>\\n\"+\n",
       "     \"</ul>\\n\"+\n",
       "     \"<code>\\n\"+\n",
       "     \"from bokeh.resources import INLINE\\n\"+\n",
       "     \"output_notebook(resources=INLINE)\\n\"+\n",
       "     \"</code>\\n\"+\n",
       "     \"</div>\"}};\n",
       "\n",
       "  function display_loaded() {\n",
       "    var el = document.getElementById(\"0b7fc20c-3a02-49a4-b190-86f4f0b8f95f\");\n",
       "    if (el != null) {\n",
       "      el.textContent = \"BokehJS is loading...\";\n",
       "    }\n",
       "    if (root.Bokeh !== undefined) {\n",
       "      if (el != null) {\n",
       "        el.textContent = \"BokehJS \" + root.Bokeh.version + \" successfully loaded.\";\n",
       "      }\n",
       "    } else if (Date.now() < root._bokeh_timeout) {\n",
       "      setTimeout(display_loaded, 100)\n",
       "    }\n",
       "  }\n",
       "\n",
       "\n",
       "  function run_callbacks() {\n",
       "    try {\n",
       "      root._bokeh_onload_callbacks.forEach(function(callback) { callback() });\n",
       "    }\n",
       "    finally {\n",
       "      delete root._bokeh_onload_callbacks\n",
       "    }\n",
       "    console.info(\"Bokeh: all callbacks have finished\");\n",
       "  }\n",
       "\n",
       "  function load_libs(js_urls, callback) {\n",
       "    root._bokeh_onload_callbacks.push(callback);\n",
       "    if (root._bokeh_is_loading > 0) {\n",
       "      console.log(\"Bokeh: BokehJS is being loaded, scheduling callback at\", now());\n",
       "      return null;\n",
       "    }\n",
       "    if (js_urls == null || js_urls.length === 0) {\n",
       "      run_callbacks();\n",
       "      return null;\n",
       "    }\n",
       "    console.log(\"Bokeh: BokehJS not loaded, scheduling load and callback at\", now());\n",
       "    root._bokeh_is_loading = js_urls.length;\n",
       "    for (var i = 0; i < js_urls.length; i++) {\n",
       "      var url = js_urls[i];\n",
       "      var s = document.createElement('script');\n",
       "      s.src = url;\n",
       "      s.async = false;\n",
       "      s.onreadystatechange = s.onload = function() {\n",
       "        root._bokeh_is_loading--;\n",
       "        if (root._bokeh_is_loading === 0) {\n",
       "          console.log(\"Bokeh: all BokehJS libraries loaded\");\n",
       "          run_callbacks()\n",
       "        }\n",
       "      };\n",
       "      s.onerror = function() {\n",
       "        console.warn(\"failed to load library \" + url);\n",
       "      };\n",
       "      console.log(\"Bokeh: injecting script tag for BokehJS library: \", url);\n",
       "      document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "    }\n",
       "  };var element = document.getElementById(\"0b7fc20c-3a02-49a4-b190-86f4f0b8f95f\");\n",
       "  if (element == null) {\n",
       "    console.log(\"Bokeh: ERROR: autoload.js configured with elementid '0b7fc20c-3a02-49a4-b190-86f4f0b8f95f' but no matching script tag was found. \")\n",
       "    return false;\n",
       "  }\n",
       "\n",
       "  var js_urls = [\"https://cdn.pydata.org/bokeh/release/bokeh-0.13.0.min.js\", \"https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.13.0.min.js\", \"https://cdn.pydata.org/bokeh/release/bokeh-tables-0.13.0.min.js\", \"https://cdn.pydata.org/bokeh/release/bokeh-gl-0.13.0.min.js\"];\n",
       "\n",
       "  var inline_js = [\n",
       "    function(Bokeh) {\n",
       "      Bokeh.set_log_level(\"info\");\n",
       "    },\n",
       "    \n",
       "    function(Bokeh) {\n",
       "      \n",
       "    },\n",
       "    function(Bokeh) {\n",
       "      console.log(\"Bokeh: injecting CSS: https://cdn.pydata.org/bokeh/release/bokeh-0.13.0.min.css\");\n",
       "      Bokeh.embed.inject_css(\"https://cdn.pydata.org/bokeh/release/bokeh-0.13.0.min.css\");\n",
       "      console.log(\"Bokeh: injecting CSS: https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.13.0.min.css\");\n",
       "      Bokeh.embed.inject_css(\"https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.13.0.min.css\");\n",
       "      console.log(\"Bokeh: injecting CSS: https://cdn.pydata.org/bokeh/release/bokeh-tables-0.13.0.min.css\");\n",
       "      Bokeh.embed.inject_css(\"https://cdn.pydata.org/bokeh/release/bokeh-tables-0.13.0.min.css\");\n",
       "    }\n",
       "  ];\n",
       "\n",
       "  function run_inline_js() {\n",
       "    \n",
       "    if ((root.Bokeh !== undefined) || (force === true)) {\n",
       "      for (var i = 0; i < inline_js.length; i++) {\n",
       "        inline_js[i].call(root, root.Bokeh);\n",
       "      }if (force === true) {\n",
       "        display_loaded();\n",
       "      }} else if (Date.now() < root._bokeh_timeout) {\n",
       "      setTimeout(run_inline_js, 100);\n",
       "    } else if (!root._bokeh_failed_load) {\n",
       "      console.log(\"Bokeh: BokehJS failed to load within specified timeout.\");\n",
       "      root._bokeh_failed_load = true;\n",
       "    } else if (force !== true) {\n",
       "      var cell = $(document.getElementById(\"0b7fc20c-3a02-49a4-b190-86f4f0b8f95f\")).parents('.cell').data().cell;\n",
       "      cell.output_area.append_execute_result(NB_LOAD_WARNING)\n",
       "    }\n",
       "\n",
       "  }\n",
       "\n",
       "  if (root._bokeh_is_loading === 0) {\n",
       "    console.log(\"Bokeh: BokehJS loaded, going straight to plotting\");\n",
       "    run_inline_js();\n",
       "  } else {\n",
       "    load_libs(js_urls, function() {\n",
       "      console.log(\"Bokeh: BokehJS plotting callback run at\", now());\n",
       "      run_inline_js();\n",
       "    });\n",
       "  }\n",
       "}(window));"
      ],
      "application/vnd.bokehjs_load.v0+json": "\n(function(root) {\n  function now() {\n    return new Date();\n  }\n\n  var force = true;\n\n  if (typeof (root._bokeh_onload_callbacks) === \"undefined\" || force === true) {\n    root._bokeh_onload_callbacks = [];\n    root._bokeh_is_loading = undefined;\n  }\n\n  \n\n  \n  if (typeof (root._bokeh_timeout) === \"undefined\" || force === true) {\n    root._bokeh_timeout = Date.now() + 5000;\n    root._bokeh_failed_load = false;\n  }\n\n  var NB_LOAD_WARNING = {'data': {'text/html':\n     \"<div style='background-color: #fdd'>\\n\"+\n     \"<p>\\n\"+\n     \"BokehJS does not appear to have successfully loaded. If loading BokehJS from CDN, this \\n\"+\n     \"may be due to a slow or bad network connection. Possible fixes:\\n\"+\n     \"</p>\\n\"+\n     \"<ul>\\n\"+\n     \"<li>re-rerun `output_notebook()` to attempt to load from CDN again, or</li>\\n\"+\n     \"<li>use INLINE resources instead, as so:</li>\\n\"+\n     \"</ul>\\n\"+\n     \"<code>\\n\"+\n     \"from bokeh.resources import INLINE\\n\"+\n     \"output_notebook(resources=INLINE)\\n\"+\n     \"</code>\\n\"+\n     \"</div>\"}};\n\n  function display_loaded() {\n    var el = document.getElementById(\"0b7fc20c-3a02-49a4-b190-86f4f0b8f95f\");\n    if (el != null) {\n      el.textContent = \"BokehJS is loading...\";\n    }\n    if (root.Bokeh !== undefined) {\n      if (el != null) {\n        el.textContent = \"BokehJS \" + root.Bokeh.version + \" successfully loaded.\";\n      }\n    } else if (Date.now() < root._bokeh_timeout) {\n      setTimeout(display_loaded, 100)\n    }\n  }\n\n\n  function run_callbacks() {\n    try {\n      root._bokeh_onload_callbacks.forEach(function(callback) { callback() });\n    }\n    finally {\n      delete root._bokeh_onload_callbacks\n    }\n    console.info(\"Bokeh: all callbacks have finished\");\n  }\n\n  function load_libs(js_urls, callback) {\n    root._bokeh_onload_callbacks.push(callback);\n    if (root._bokeh_is_loading > 0) {\n      console.log(\"Bokeh: BokehJS is being loaded, scheduling callback at\", now());\n      return null;\n    }\n    if (js_urls == null || js_urls.length === 0) {\n      run_callbacks();\n      return null;\n    }\n    console.log(\"Bokeh: BokehJS not loaded, scheduling load and callback at\", now());\n    root._bokeh_is_loading = js_urls.length;\n    for (var i = 0; i < js_urls.length; i++) {\n      var url = js_urls[i];\n      var s = document.createElement('script');\n      s.src = url;\n      s.async = false;\n      s.onreadystatechange = s.onload = function() {\n        root._bokeh_is_loading--;\n        if (root._bokeh_is_loading === 0) {\n          console.log(\"Bokeh: all BokehJS libraries loaded\");\n          run_callbacks()\n        }\n      };\n      s.onerror = function() {\n        console.warn(\"failed to load library \" + url);\n      };\n      console.log(\"Bokeh: injecting script tag for BokehJS library: \", url);\n      document.getElementsByTagName(\"head\")[0].appendChild(s);\n    }\n  };var element = document.getElementById(\"0b7fc20c-3a02-49a4-b190-86f4f0b8f95f\");\n  if (element == null) {\n    console.log(\"Bokeh: ERROR: autoload.js configured with elementid '0b7fc20c-3a02-49a4-b190-86f4f0b8f95f' but no matching script tag was found. \")\n    return false;\n  }\n\n  var js_urls = [\"https://cdn.pydata.org/bokeh/release/bokeh-0.13.0.min.js\", \"https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.13.0.min.js\", \"https://cdn.pydata.org/bokeh/release/bokeh-tables-0.13.0.min.js\", \"https://cdn.pydata.org/bokeh/release/bokeh-gl-0.13.0.min.js\"];\n\n  var inline_js = [\n    function(Bokeh) {\n      Bokeh.set_log_level(\"info\");\n    },\n    \n    function(Bokeh) {\n      \n    },\n    function(Bokeh) {\n      console.log(\"Bokeh: injecting CSS: https://cdn.pydata.org/bokeh/release/bokeh-0.13.0.min.css\");\n      Bokeh.embed.inject_css(\"https://cdn.pydata.org/bokeh/release/bokeh-0.13.0.min.css\");\n      console.log(\"Bokeh: injecting CSS: https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.13.0.min.css\");\n      Bokeh.embed.inject_css(\"https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.13.0.min.css\");\n      console.log(\"Bokeh: injecting CSS: https://cdn.pydata.org/bokeh/release/bokeh-tables-0.13.0.min.css\");\n      Bokeh.embed.inject_css(\"https://cdn.pydata.org/bokeh/release/bokeh-tables-0.13.0.min.css\");\n    }\n  ];\n\n  function run_inline_js() {\n    \n    if ((root.Bokeh !== undefined) || (force === true)) {\n      for (var i = 0; i < inline_js.length; i++) {\n        inline_js[i].call(root, root.Bokeh);\n      }if (force === true) {\n        display_loaded();\n      }} else if (Date.now() < root._bokeh_timeout) {\n      setTimeout(run_inline_js, 100);\n    } else if (!root._bokeh_failed_load) {\n      console.log(\"Bokeh: BokehJS failed to load within specified timeout.\");\n      root._bokeh_failed_load = true;\n    } else if (force !== true) {\n      var cell = $(document.getElementById(\"0b7fc20c-3a02-49a4-b190-86f4f0b8f95f\")).parents('.cell').data().cell;\n      cell.output_area.append_execute_result(NB_LOAD_WARNING)\n    }\n\n  }\n\n  if (root._bokeh_is_loading === 0) {\n    console.log(\"Bokeh: BokehJS loaded, going straight to plotting\");\n    run_inline_js();\n  } else {\n    load_libs(js_urls, function() {\n      console.log(\"Bokeh: BokehJS plotting callback run at\", now());\n      run_inline_js();\n    });\n  }\n}(window));"
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "%matplotlib inline\n",
    "import numpy as np                   # math\n",
    "import pandas as pd                  # manipulating data\n",
    "import matplotlib.pyplot as plt      # graphing\n",
    "import os                            # useful for handling filenames etc.\n",
    "\n",
    "# calculates the Pearson correlation coefficient, p-value, and does linear regression\n",
    "from scipy.stats import pearsonr, linregress\n",
    "\n",
    "#import seaborn as sns                # makes matplotlib beautiful\n",
    "#sns.set_style('darkgrid')\n",
    "\n",
    "import matplotlib as mpl             # control formatting\n",
    "mpl.rcParams['axes.titlesize'] = 16\n",
    "mpl.rcParams['axes.titleweight'] = 'semibold'\n",
    "\n",
    "# interactive graphs\n",
    "from bokeh.io import output_notebook, show, push_notebook\n",
    "from bokeh.plotting import figure\n",
    "from bokeh.layouts import row, column\n",
    "from bokeh.models import DatetimeTickFormatter, HoverTool\n",
    "output_notebook()\n",
    "\n",
    "# manage date and time\n",
    "from datetime import datetime, timedelta, date"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Time</th>\n",
       "      <th>TemperatureF</th>\n",
       "      <th>DewpointF</th>\n",
       "      <th>PressureIn</th>\n",
       "      <th>WindDirection</th>\n",
       "      <th>WindDirectionDegrees</th>\n",
       "      <th>WindSpeedMPH</th>\n",
       "      <th>WindSpeedGustMPH</th>\n",
       "      <th>Humidity</th>\n",
       "      <th>HourlyPrecipIn</th>\n",
       "      <th>Conditions</th>\n",
       "      <th>Clouds</th>\n",
       "      <th>dailyrainin</th>\n",
       "      <th>SolarRadiationWatts/m^2</th>\n",
       "      <th>SoftwareType</th>\n",
       "      <th>DateUTC&lt;br&gt;</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-11-01 12:49:32</td>\n",
       "      <td>72.3</td>\n",
       "      <td>48.0</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>202.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>44.49</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 19:49:32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018-11-01 12:54:36</td>\n",
       "      <td>72.5</td>\n",
       "      <td>48.2</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SE</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>0.21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>277.27</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 19:54:36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2018-11-01 12:59:56</td>\n",
       "      <td>73.4</td>\n",
       "      <td>45.7</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>South</td>\n",
       "      <td>187.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>0.21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>292.76</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 19:59:56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2018-11-01 13:04:44</td>\n",
       "      <td>74.3</td>\n",
       "      <td>44.2</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>ESE</td>\n",
       "      <td>114.0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>4.9</td>\n",
       "      <td>34.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>288.55</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:04:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2018-11-01 13:09:48</td>\n",
       "      <td>75.4</td>\n",
       "      <td>44.4</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SE</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.4</td>\n",
       "      <td>2.5</td>\n",
       "      <td>33.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>295.80</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:09:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2018-11-01 13:14:52</td>\n",
       "      <td>76.3</td>\n",
       "      <td>44.2</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SE</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>274.66</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:14:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2018-11-01 13:19:56</td>\n",
       "      <td>77.5</td>\n",
       "      <td>43.7</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSE</td>\n",
       "      <td>150.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>274.23</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:19:56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2018-11-01 13:24:44</td>\n",
       "      <td>78.8</td>\n",
       "      <td>45.7</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>South</td>\n",
       "      <td>186.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>287.99</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:24:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2018-11-01 13:29:32</td>\n",
       "      <td>79.7</td>\n",
       "      <td>45.5</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>East</td>\n",
       "      <td>97.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>279.70</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:29:32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2018-11-01 13:34:36</td>\n",
       "      <td>80.6</td>\n",
       "      <td>45.5</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>NE</td>\n",
       "      <td>39.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>290.42</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:34:36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2018-11-01 13:39:56</td>\n",
       "      <td>81.7</td>\n",
       "      <td>46.4</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>NE</td>\n",
       "      <td>46.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>280.35</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:39:56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2018-11-01 13:44:28</td>\n",
       "      <td>82.4</td>\n",
       "      <td>47.8</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>NE</td>\n",
       "      <td>49.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>266.63</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:44:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2018-11-01 13:49:16</td>\n",
       "      <td>82.9</td>\n",
       "      <td>49.3</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>212.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>260.77</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:49:16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2018-11-01 13:54:52</td>\n",
       "      <td>83.3</td>\n",
       "      <td>50.4</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>South</td>\n",
       "      <td>190.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>252.30</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:54:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2018-11-01 13:59:40</td>\n",
       "      <td>83.3</td>\n",
       "      <td>49.6</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SW</td>\n",
       "      <td>226.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>245.79</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:59:40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>2018-11-01 22:49:49</td>\n",
       "      <td>64.6</td>\n",
       "      <td>53.8</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>210.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 05:49:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>2018-11-01 22:54:53</td>\n",
       "      <td>64.4</td>\n",
       "      <td>52.0</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SW</td>\n",
       "      <td>221.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 05:54:53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>2018-11-01 22:59:57</td>\n",
       "      <td>64.2</td>\n",
       "      <td>51.4</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>200.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 05:59:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>2018-11-01 23:04:45</td>\n",
       "      <td>64.2</td>\n",
       "      <td>51.4</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SW</td>\n",
       "      <td>214.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:04:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>2018-11-01 23:09:49</td>\n",
       "      <td>64.0</td>\n",
       "      <td>51.3</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SW</td>\n",
       "      <td>219.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:09:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>2018-11-01 23:14:37</td>\n",
       "      <td>64.0</td>\n",
       "      <td>51.3</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>209.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:14:37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>2018-11-01 23:19:57</td>\n",
       "      <td>63.9</td>\n",
       "      <td>51.4</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>205.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:19:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>2018-11-01 23:24:45</td>\n",
       "      <td>63.7</td>\n",
       "      <td>51.3</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>208.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:24:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>2018-11-01 23:29:49</td>\n",
       "      <td>63.3</td>\n",
       "      <td>51.4</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>207.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:29:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>2018-11-01 23:34:21</td>\n",
       "      <td>63.1</td>\n",
       "      <td>51.3</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>206.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:34:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>2018-11-01 23:39:57</td>\n",
       "      <td>62.8</td>\n",
       "      <td>51.3</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>206.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:39:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>261</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262</th>\n",
       "      <td>2018-11-01 23:44:29</td>\n",
       "      <td>62.6</td>\n",
       "      <td>51.1</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SW</td>\n",
       "      <td>229.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:44:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>264</th>\n",
       "      <td>2018-11-01 23:49:17</td>\n",
       "      <td>62.6</td>\n",
       "      <td>50.4</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>213.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:49:17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>265</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>266</th>\n",
       "      <td>2018-11-01 23:54:53</td>\n",
       "      <td>62.6</td>\n",
       "      <td>49.5</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>200.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:54:53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>267</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>268</th>\n",
       "      <td>2018-11-01 23:59:57</td>\n",
       "      <td>62.8</td>\n",
       "      <td>49.6</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>208.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:59:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269</th>\n",
       "      <td>&lt;br&gt;</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>270 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Time  TemperatureF  DewpointF  PressureIn WindDirection  \\\n",
       "0    2018-11-01 12:49:32          72.3       48.0      -100.0           SSW   \n",
       "1                   <br>           NaN        NaN         NaN           NaN   \n",
       "2    2018-11-01 12:54:36          72.5       48.2      -100.0            SE   \n",
       "3                   <br>           NaN        NaN         NaN           NaN   \n",
       "4    2018-11-01 12:59:56          73.4       45.7      -100.0         South   \n",
       "5                   <br>           NaN        NaN         NaN           NaN   \n",
       "6    2018-11-01 13:04:44          74.3       44.2      -100.0           ESE   \n",
       "7                   <br>           NaN        NaN         NaN           NaN   \n",
       "8    2018-11-01 13:09:48          75.4       44.4      -100.0            SE   \n",
       "9                   <br>           NaN        NaN         NaN           NaN   \n",
       "10   2018-11-01 13:14:52          76.3       44.2      -100.0            SE   \n",
       "11                  <br>           NaN        NaN         NaN           NaN   \n",
       "12   2018-11-01 13:19:56          77.5       43.7      -100.0           SSE   \n",
       "13                  <br>           NaN        NaN         NaN           NaN   \n",
       "14   2018-11-01 13:24:44          78.8       45.7      -100.0         South   \n",
       "15                  <br>           NaN        NaN         NaN           NaN   \n",
       "16   2018-11-01 13:29:32          79.7       45.5      -100.0          East   \n",
       "17                  <br>           NaN        NaN         NaN           NaN   \n",
       "18   2018-11-01 13:34:36          80.6       45.5      -100.0            NE   \n",
       "19                  <br>           NaN        NaN         NaN           NaN   \n",
       "20   2018-11-01 13:39:56          81.7       46.4      -100.0            NE   \n",
       "21                  <br>           NaN        NaN         NaN           NaN   \n",
       "22   2018-11-01 13:44:28          82.4       47.8      -100.0            NE   \n",
       "23                  <br>           NaN        NaN         NaN           NaN   \n",
       "24   2018-11-01 13:49:16          82.9       49.3      -100.0           SSW   \n",
       "25                  <br>           NaN        NaN         NaN           NaN   \n",
       "26   2018-11-01 13:54:52          83.3       50.4      -100.0         South   \n",
       "27                  <br>           NaN        NaN         NaN           NaN   \n",
       "28   2018-11-01 13:59:40          83.3       49.6      -100.0            SW   \n",
       "29                  <br>           NaN        NaN         NaN           NaN   \n",
       "..                   ...           ...        ...         ...           ...   \n",
       "240  2018-11-01 22:49:49          64.6       53.8      -100.0           SSW   \n",
       "241                 <br>           NaN        NaN         NaN           NaN   \n",
       "242  2018-11-01 22:54:53          64.4       52.0      -100.0            SW   \n",
       "243                 <br>           NaN        NaN         NaN           NaN   \n",
       "244  2018-11-01 22:59:57          64.2       51.4      -100.0           SSW   \n",
       "245                 <br>           NaN        NaN         NaN           NaN   \n",
       "246  2018-11-01 23:04:45          64.2       51.4      -100.0            SW   \n",
       "247                 <br>           NaN        NaN         NaN           NaN   \n",
       "248  2018-11-01 23:09:49          64.0       51.3      -100.0            SW   \n",
       "249                 <br>           NaN        NaN         NaN           NaN   \n",
       "250  2018-11-01 23:14:37          64.0       51.3      -100.0           SSW   \n",
       "251                 <br>           NaN        NaN         NaN           NaN   \n",
       "252  2018-11-01 23:19:57          63.9       51.4      -100.0           SSW   \n",
       "253                 <br>           NaN        NaN         NaN           NaN   \n",
       "254  2018-11-01 23:24:45          63.7       51.3      -100.0           SSW   \n",
       "255                 <br>           NaN        NaN         NaN           NaN   \n",
       "256  2018-11-01 23:29:49          63.3       51.4      -100.0           SSW   \n",
       "257                 <br>           NaN        NaN         NaN           NaN   \n",
       "258  2018-11-01 23:34:21          63.1       51.3      -100.0           SSW   \n",
       "259                 <br>           NaN        NaN         NaN           NaN   \n",
       "260  2018-11-01 23:39:57          62.8       51.3      -100.0           SSW   \n",
       "261                 <br>           NaN        NaN         NaN           NaN   \n",
       "262  2018-11-01 23:44:29          62.6       51.1      -100.0            SW   \n",
       "263                 <br>           NaN        NaN         NaN           NaN   \n",
       "264  2018-11-01 23:49:17          62.6       50.4      -100.0           SSW   \n",
       "265                 <br>           NaN        NaN         NaN           NaN   \n",
       "266  2018-11-01 23:54:53          62.6       49.5      -100.0           SSW   \n",
       "267                 <br>           NaN        NaN         NaN           NaN   \n",
       "268  2018-11-01 23:59:57          62.8       49.6      -100.0           SSW   \n",
       "269                 <br>           NaN        NaN         NaN           NaN   \n",
       "\n",
       "     WindDirectionDegrees  WindSpeedMPH  WindSpeedGustMPH  Humidity  \\\n",
       "0                   202.0           0.0               0.0      42.0   \n",
       "1                     NaN           NaN               NaN       NaN   \n",
       "2                   133.0           0.0               0.0      42.0   \n",
       "3                     NaN           NaN               NaN       NaN   \n",
       "4                   187.0           0.0               0.0      37.0   \n",
       "5                     NaN           NaN               NaN       NaN   \n",
       "6                   114.0           1.8               4.9      34.0   \n",
       "7                     NaN           NaN               NaN       NaN   \n",
       "8                   133.0           0.4               2.5      33.0   \n",
       "9                     NaN           NaN               NaN       NaN   \n",
       "10                  139.0           0.0               0.0      32.0   \n",
       "11                    NaN           NaN               NaN       NaN   \n",
       "12                  150.0           0.0               0.0      30.0   \n",
       "13                    NaN           NaN               NaN       NaN   \n",
       "14                  186.0           0.0               0.0      31.0   \n",
       "15                    NaN           NaN               NaN       NaN   \n",
       "16                   97.0           0.0               0.0      30.0   \n",
       "17                    NaN           NaN               NaN       NaN   \n",
       "18                   39.0           0.0               0.0      29.0   \n",
       "19                    NaN           NaN               NaN       NaN   \n",
       "20                   46.0           0.0               0.0      29.0   \n",
       "21                    NaN           NaN               NaN       NaN   \n",
       "22                   49.0           0.0               0.0      30.0   \n",
       "23                    NaN           NaN               NaN       NaN   \n",
       "24                  212.0           0.0               0.0      31.0   \n",
       "25                    NaN           NaN               NaN       NaN   \n",
       "26                  190.0           0.0               0.0      32.0   \n",
       "27                    NaN           NaN               NaN       NaN   \n",
       "28                  226.0           0.0               0.0      31.0   \n",
       "29                    NaN           NaN               NaN       NaN   \n",
       "..                    ...           ...               ...       ...   \n",
       "240                 210.0           0.0               0.0      68.0   \n",
       "241                   NaN           NaN               NaN       NaN   \n",
       "242                 221.0           0.0               0.0      64.0   \n",
       "243                   NaN           NaN               NaN       NaN   \n",
       "244                 200.0           0.0               0.0      63.0   \n",
       "245                   NaN           NaN               NaN       NaN   \n",
       "246                 214.0           0.0               0.0      63.0   \n",
       "247                   NaN           NaN               NaN       NaN   \n",
       "248                 219.0           0.0               0.0      63.0   \n",
       "249                   NaN           NaN               NaN       NaN   \n",
       "250                 209.0           0.0               0.0      63.0   \n",
       "251                   NaN           NaN               NaN       NaN   \n",
       "252                 205.0           0.0               0.0      64.0   \n",
       "253                   NaN           NaN               NaN       NaN   \n",
       "254                 208.0           0.0               0.0      64.0   \n",
       "255                   NaN           NaN               NaN       NaN   \n",
       "256                 207.0           0.0               0.0      65.0   \n",
       "257                   NaN           NaN               NaN       NaN   \n",
       "258                 206.0           0.0               0.0      65.0   \n",
       "259                   NaN           NaN               NaN       NaN   \n",
       "260                 206.0           0.0               0.0      66.0   \n",
       "261                   NaN           NaN               NaN       NaN   \n",
       "262                 229.0           0.0               0.0      66.0   \n",
       "263                   NaN           NaN               NaN       NaN   \n",
       "264                 213.0           0.0               0.0      64.0   \n",
       "265                   NaN           NaN               NaN       NaN   \n",
       "266                 200.0           0.0               0.0      62.0   \n",
       "267                   NaN           NaN               NaN       NaN   \n",
       "268                 208.0           0.0               0.0      62.0   \n",
       "269                   NaN           NaN               NaN       NaN   \n",
       "\n",
       "     HourlyPrecipIn  Conditions  Clouds  dailyrainin  SolarRadiationWatts/m^2  \\\n",
       "0              0.00         NaN     NaN         0.00                    44.49   \n",
       "1               NaN         NaN     NaN          NaN                      NaN   \n",
       "2              0.21         NaN     NaN         0.04                   277.27   \n",
       "3               NaN         NaN     NaN          NaN                      NaN   \n",
       "4              0.21         NaN     NaN         0.04                   292.76   \n",
       "5               NaN         NaN     NaN          NaN                      NaN   \n",
       "6              0.00         NaN     NaN         0.04                   288.55   \n",
       "7               NaN         NaN     NaN          NaN                      NaN   \n",
       "8              0.00         NaN     NaN         0.04                   295.80   \n",
       "9               NaN         NaN     NaN          NaN                      NaN   \n",
       "10             0.00         NaN     NaN         0.04                   274.66   \n",
       "11              NaN         NaN     NaN          NaN                      NaN   \n",
       "12             0.00         NaN     NaN         0.04                   274.23   \n",
       "13              NaN         NaN     NaN          NaN                      NaN   \n",
       "14             0.00         NaN     NaN         0.04                   287.99   \n",
       "15              NaN         NaN     NaN          NaN                      NaN   \n",
       "16             0.00         NaN     NaN         0.04                   279.70   \n",
       "17              NaN         NaN     NaN          NaN                      NaN   \n",
       "18             0.00         NaN     NaN         0.04                   290.42   \n",
       "19              NaN         NaN     NaN          NaN                      NaN   \n",
       "20             0.00         NaN     NaN         0.04                   280.35   \n",
       "21              NaN         NaN     NaN          NaN                      NaN   \n",
       "22             0.00         NaN     NaN         0.04                   266.63   \n",
       "23              NaN         NaN     NaN          NaN                      NaN   \n",
       "24             0.00         NaN     NaN         0.04                   260.77   \n",
       "25              NaN         NaN     NaN          NaN                      NaN   \n",
       "26             0.00         NaN     NaN         0.04                   252.30   \n",
       "27              NaN         NaN     NaN          NaN                      NaN   \n",
       "28             0.00         NaN     NaN         0.04                   245.79   \n",
       "29              NaN         NaN     NaN          NaN                      NaN   \n",
       "..              ...         ...     ...          ...                      ...   \n",
       "240            0.00         NaN     NaN         0.00                     0.00   \n",
       "241             NaN         NaN     NaN          NaN                      NaN   \n",
       "242            0.00         NaN     NaN         0.00                     0.00   \n",
       "243             NaN         NaN     NaN          NaN                      NaN   \n",
       "244            0.00         NaN     NaN         0.00                     0.00   \n",
       "245             NaN         NaN     NaN          NaN                      NaN   \n",
       "246            0.00         NaN     NaN         0.00                     0.00   \n",
       "247             NaN         NaN     NaN          NaN                      NaN   \n",
       "248            0.00         NaN     NaN         0.00                     0.00   \n",
       "249             NaN         NaN     NaN          NaN                      NaN   \n",
       "250            0.00         NaN     NaN         0.00                     0.00   \n",
       "251             NaN         NaN     NaN          NaN                      NaN   \n",
       "252            0.00         NaN     NaN         0.00                     0.00   \n",
       "253             NaN         NaN     NaN          NaN                      NaN   \n",
       "254            0.00         NaN     NaN         0.00                     0.00   \n",
       "255             NaN         NaN     NaN          NaN                      NaN   \n",
       "256            0.00         NaN     NaN         0.00                     0.00   \n",
       "257             NaN         NaN     NaN          NaN                      NaN   \n",
       "258            0.00         NaN     NaN         0.00                     0.00   \n",
       "259             NaN         NaN     NaN          NaN                      NaN   \n",
       "260            0.00         NaN     NaN         0.00                     0.00   \n",
       "261             NaN         NaN     NaN          NaN                      NaN   \n",
       "262            0.00         NaN     NaN         0.00                     0.00   \n",
       "263             NaN         NaN     NaN          NaN                      NaN   \n",
       "264            0.00         NaN     NaN         0.00                     0.00   \n",
       "265             NaN         NaN     NaN          NaN                      NaN   \n",
       "266            0.00         NaN     NaN         0.00                     0.00   \n",
       "267             NaN         NaN     NaN          NaN                      NaN   \n",
       "268            0.00         NaN     NaN         0.00                     0.00   \n",
       "269             NaN         NaN     NaN          NaN                      NaN   \n",
       "\n",
       "             SoftwareType          DateUTC<br>  \n",
       "0    Weather logger V3.0.  2018-11-01 19:49:32  \n",
       "1                     NaN                  NaN  \n",
       "2    Weather logger V3.0.  2018-11-01 19:54:36  \n",
       "3                     NaN                  NaN  \n",
       "4    Weather logger V3.0.  2018-11-01 19:59:56  \n",
       "5                     NaN                  NaN  \n",
       "6    Weather logger V3.0.  2018-11-01 20:04:44  \n",
       "7                     NaN                  NaN  \n",
       "8    Weather logger V3.0.  2018-11-01 20:09:48  \n",
       "9                     NaN                  NaN  \n",
       "10   Weather logger V3.0.  2018-11-01 20:14:52  \n",
       "11                    NaN                  NaN  \n",
       "12   Weather logger V3.0.  2018-11-01 20:19:56  \n",
       "13                    NaN                  NaN  \n",
       "14   Weather logger V3.0.  2018-11-01 20:24:44  \n",
       "15                    NaN                  NaN  \n",
       "16   Weather logger V3.0.  2018-11-01 20:29:32  \n",
       "17                    NaN                  NaN  \n",
       "18   Weather logger V3.0.  2018-11-01 20:34:36  \n",
       "19                    NaN                  NaN  \n",
       "20   Weather logger V3.0.  2018-11-01 20:39:56  \n",
       "21                    NaN                  NaN  \n",
       "22   Weather logger V3.0.  2018-11-01 20:44:28  \n",
       "23                    NaN                  NaN  \n",
       "24   Weather logger V3.0.  2018-11-01 20:49:16  \n",
       "25                    NaN                  NaN  \n",
       "26   Weather logger V3.0.  2018-11-01 20:54:52  \n",
       "27                    NaN                  NaN  \n",
       "28   Weather logger V3.0.  2018-11-01 20:59:40  \n",
       "29                    NaN                  NaN  \n",
       "..                    ...                  ...  \n",
       "240  Weather logger V3.0.  2018-11-02 05:49:49  \n",
       "241                   NaN                  NaN  \n",
       "242  Weather logger V3.0.  2018-11-02 05:54:53  \n",
       "243                   NaN                  NaN  \n",
       "244  Weather logger V3.0.  2018-11-02 05:59:57  \n",
       "245                   NaN                  NaN  \n",
       "246  Weather logger V3.0.  2018-11-02 06:04:45  \n",
       "247                   NaN                  NaN  \n",
       "248  Weather logger V3.0.  2018-11-02 06:09:49  \n",
       "249                   NaN                  NaN  \n",
       "250  Weather logger V3.0.  2018-11-02 06:14:37  \n",
       "251                   NaN                  NaN  \n",
       "252  Weather logger V3.0.  2018-11-02 06:19:57  \n",
       "253                   NaN                  NaN  \n",
       "254  Weather logger V3.0.  2018-11-02 06:24:45  \n",
       "255                   NaN                  NaN  \n",
       "256  Weather logger V3.0.  2018-11-02 06:29:49  \n",
       "257                   NaN                  NaN  \n",
       "258  Weather logger V3.0.  2018-11-02 06:34:21  \n",
       "259                   NaN                  NaN  \n",
       "260  Weather logger V3.0.  2018-11-02 06:39:57  \n",
       "261                   NaN                  NaN  \n",
       "262  Weather logger V3.0.  2018-11-02 06:44:29  \n",
       "263                   NaN                  NaN  \n",
       "264  Weather logger V3.0.  2018-11-02 06:49:17  \n",
       "265                   NaN                  NaN  \n",
       "266  Weather logger V3.0.  2018-11-02 06:54:53  \n",
       "267                   NaN                  NaN  \n",
       "268  Weather logger V3.0.  2018-11-02 06:59:57  \n",
       "269                   NaN                  NaN  \n",
       "\n",
       "[270 rows x 16 columns]"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# An example of what the website query looks like without any processing\n",
    "CSV_URL = 'https://www.wunderground.com/weatherstation/WXDailyHistory.asp?\\\n",
    "ID=KCABERKE169&day=01&month=11&year=2018&graphspan=day&format=1'\n",
    "df = pd.read_csv(CSV_URL, index_col=False)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Time</th>\n",
       "      <th>TemperatureF</th>\n",
       "      <th>DewpointF</th>\n",
       "      <th>PressureIn</th>\n",
       "      <th>WindDirection</th>\n",
       "      <th>WindDirectionDegrees</th>\n",
       "      <th>WindSpeedMPH</th>\n",
       "      <th>WindSpeedGustMPH</th>\n",
       "      <th>Humidity</th>\n",
       "      <th>HourlyPrecipIn</th>\n",
       "      <th>Conditions</th>\n",
       "      <th>Clouds</th>\n",
       "      <th>dailyrainin</th>\n",
       "      <th>SolarRadiationWatts/m^2</th>\n",
       "      <th>SoftwareType</th>\n",
       "      <th>DateUTC&lt;br&gt;</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-11-01 12:49:32</td>\n",
       "      <td>72.3</td>\n",
       "      <td>48.0</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>202.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>44.49</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 19:49:32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018-11-01 12:54:36</td>\n",
       "      <td>72.5</td>\n",
       "      <td>48.2</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SE</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>0.21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>277.27</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 19:54:36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2018-11-01 12:59:56</td>\n",
       "      <td>73.4</td>\n",
       "      <td>45.7</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>South</td>\n",
       "      <td>187.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>0.21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>292.76</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 19:59:56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2018-11-01 13:04:44</td>\n",
       "      <td>74.3</td>\n",
       "      <td>44.2</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>ESE</td>\n",
       "      <td>114.0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>4.9</td>\n",
       "      <td>34.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>288.55</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:04:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2018-11-01 13:09:48</td>\n",
       "      <td>75.4</td>\n",
       "      <td>44.4</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SE</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.4</td>\n",
       "      <td>2.5</td>\n",
       "      <td>33.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>295.80</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:09:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2018-11-01 13:14:52</td>\n",
       "      <td>76.3</td>\n",
       "      <td>44.2</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SE</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>274.66</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:14:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2018-11-01 13:19:56</td>\n",
       "      <td>77.5</td>\n",
       "      <td>43.7</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSE</td>\n",
       "      <td>150.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>274.23</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:19:56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2018-11-01 13:24:44</td>\n",
       "      <td>78.8</td>\n",
       "      <td>45.7</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>South</td>\n",
       "      <td>186.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>287.99</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:24:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2018-11-01 13:29:32</td>\n",
       "      <td>79.7</td>\n",
       "      <td>45.5</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>East</td>\n",
       "      <td>97.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>279.70</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:29:32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2018-11-01 13:34:36</td>\n",
       "      <td>80.6</td>\n",
       "      <td>45.5</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>NE</td>\n",
       "      <td>39.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>290.42</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:34:36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2018-11-01 13:39:56</td>\n",
       "      <td>81.7</td>\n",
       "      <td>46.4</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>NE</td>\n",
       "      <td>46.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>280.35</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:39:56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2018-11-01 13:44:28</td>\n",
       "      <td>82.4</td>\n",
       "      <td>47.8</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>NE</td>\n",
       "      <td>49.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>266.63</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:44:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2018-11-01 13:49:16</td>\n",
       "      <td>82.9</td>\n",
       "      <td>49.3</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>212.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>260.77</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:49:16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2018-11-01 13:54:52</td>\n",
       "      <td>83.3</td>\n",
       "      <td>50.4</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>South</td>\n",
       "      <td>190.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>252.30</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:54:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2018-11-01 13:59:40</td>\n",
       "      <td>83.3</td>\n",
       "      <td>49.6</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SW</td>\n",
       "      <td>226.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>245.79</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 20:59:40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2018-11-01 14:04:44</td>\n",
       "      <td>83.3</td>\n",
       "      <td>48.7</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>South</td>\n",
       "      <td>183.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>239.89</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 21:04:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2018-11-01 14:09:48</td>\n",
       "      <td>83.5</td>\n",
       "      <td>48.9</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>203.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>243.23</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 21:09:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2018-11-01 14:14:52</td>\n",
       "      <td>83.5</td>\n",
       "      <td>48.9</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>NW</td>\n",
       "      <td>325.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>235.37</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 21:14:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2018-11-01 14:19:56</td>\n",
       "      <td>83.8</td>\n",
       "      <td>49.1</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSE</td>\n",
       "      <td>162.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>226.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 21:19:56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2018-11-01 14:24:12</td>\n",
       "      <td>84.0</td>\n",
       "      <td>50.2</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>195.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>227.39</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 21:24:12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>2018-11-01 14:29:48</td>\n",
       "      <td>84.2</td>\n",
       "      <td>48.6</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>NE</td>\n",
       "      <td>49.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>219.75</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 21:29:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>2018-11-01 14:34:52</td>\n",
       "      <td>84.4</td>\n",
       "      <td>45.9</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>WNW</td>\n",
       "      <td>287.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2.5</td>\n",
       "      <td>26.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>131.58</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 21:34:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>2018-11-01 14:39:56</td>\n",
       "      <td>84.4</td>\n",
       "      <td>44.8</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>NNW</td>\n",
       "      <td>342.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>4.9</td>\n",
       "      <td>25.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>216.19</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 21:39:56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>2018-11-01 14:44:28</td>\n",
       "      <td>84.6</td>\n",
       "      <td>46.9</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSE</td>\n",
       "      <td>152.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>132.06</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 21:44:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>2018-11-01 14:49:48</td>\n",
       "      <td>84.6</td>\n",
       "      <td>48.0</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>196.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>132.49</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 21:49:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>2018-11-01 14:54:52</td>\n",
       "      <td>84.7</td>\n",
       "      <td>47.1</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SE</td>\n",
       "      <td>137.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>193.70</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 21:54:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>2018-11-01 14:59:56</td>\n",
       "      <td>84.9</td>\n",
       "      <td>47.3</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>NW</td>\n",
       "      <td>307.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>115.30</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 21:59:56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>2018-11-01 15:04:44</td>\n",
       "      <td>84.7</td>\n",
       "      <td>50.0</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SE</td>\n",
       "      <td>130.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>2.5</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>125.16</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 22:04:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>2018-11-01 15:09:32</td>\n",
       "      <td>84.6</td>\n",
       "      <td>49.8</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>NNW</td>\n",
       "      <td>342.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>187.58</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 22:09:32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>2018-11-01 15:14:36</td>\n",
       "      <td>84.2</td>\n",
       "      <td>49.5</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>ESE</td>\n",
       "      <td>121.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>130.71</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-01 22:14:36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>2018-11-01 21:34:37</td>\n",
       "      <td>64.0</td>\n",
       "      <td>52.2</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>212.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 04:34:37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>2018-11-01 21:39:57</td>\n",
       "      <td>64.2</td>\n",
       "      <td>51.8</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SW</td>\n",
       "      <td>223.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 04:39:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>2018-11-01 21:44:45</td>\n",
       "      <td>64.2</td>\n",
       "      <td>51.4</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>South</td>\n",
       "      <td>190.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 04:44:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>2018-11-01 21:49:49</td>\n",
       "      <td>64.4</td>\n",
       "      <td>52.0</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>South</td>\n",
       "      <td>190.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 04:49:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>2018-11-01 21:54:53</td>\n",
       "      <td>64.4</td>\n",
       "      <td>53.2</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>204.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 04:54:53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>2018-11-01 21:59:41</td>\n",
       "      <td>64.2</td>\n",
       "      <td>52.7</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>West</td>\n",
       "      <td>274.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 04:59:41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>2018-11-01 22:04:45</td>\n",
       "      <td>64.2</td>\n",
       "      <td>50.5</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>202.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 05:04:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>2018-11-01 22:09:49</td>\n",
       "      <td>64.4</td>\n",
       "      <td>52.0</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SW</td>\n",
       "      <td>221.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 05:09:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>2018-11-01 22:14:05</td>\n",
       "      <td>64.4</td>\n",
       "      <td>51.1</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>202.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 05:14:05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>2018-11-01 22:19:57</td>\n",
       "      <td>64.6</td>\n",
       "      <td>50.0</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>192.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 05:19:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>2018-11-01 22:24:45</td>\n",
       "      <td>64.8</td>\n",
       "      <td>52.7</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>193.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 05:24:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>2018-11-01 22:29:49</td>\n",
       "      <td>65.1</td>\n",
       "      <td>53.6</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>192.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 05:29:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>2018-11-01 22:34:37</td>\n",
       "      <td>65.1</td>\n",
       "      <td>54.0</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>200.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 05:34:37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>2018-11-01 22:39:41</td>\n",
       "      <td>64.9</td>\n",
       "      <td>54.1</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>207.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 05:39:41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>2018-11-01 22:44:45</td>\n",
       "      <td>64.8</td>\n",
       "      <td>54.0</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>South</td>\n",
       "      <td>189.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 05:44:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>2018-11-01 22:49:49</td>\n",
       "      <td>64.6</td>\n",
       "      <td>53.8</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>210.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 05:49:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>2018-11-01 22:54:53</td>\n",
       "      <td>64.4</td>\n",
       "      <td>52.0</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SW</td>\n",
       "      <td>221.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 05:54:53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>2018-11-01 22:59:57</td>\n",
       "      <td>64.2</td>\n",
       "      <td>51.4</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>200.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 05:59:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>2018-11-01 23:04:45</td>\n",
       "      <td>64.2</td>\n",
       "      <td>51.4</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SW</td>\n",
       "      <td>214.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:04:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>2018-11-01 23:09:49</td>\n",
       "      <td>64.0</td>\n",
       "      <td>51.3</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SW</td>\n",
       "      <td>219.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:09:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>2018-11-01 23:14:37</td>\n",
       "      <td>64.0</td>\n",
       "      <td>51.3</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>209.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:14:37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>2018-11-01 23:19:57</td>\n",
       "      <td>63.9</td>\n",
       "      <td>51.4</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>205.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:19:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>2018-11-01 23:24:45</td>\n",
       "      <td>63.7</td>\n",
       "      <td>51.3</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>208.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:24:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>2018-11-01 23:29:49</td>\n",
       "      <td>63.3</td>\n",
       "      <td>51.4</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>207.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:29:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>2018-11-01 23:34:21</td>\n",
       "      <td>63.1</td>\n",
       "      <td>51.3</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>206.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:34:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>2018-11-01 23:39:57</td>\n",
       "      <td>62.8</td>\n",
       "      <td>51.3</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>206.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:39:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262</th>\n",
       "      <td>2018-11-01 23:44:29</td>\n",
       "      <td>62.6</td>\n",
       "      <td>51.1</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SW</td>\n",
       "      <td>229.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:44:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>264</th>\n",
       "      <td>2018-11-01 23:49:17</td>\n",
       "      <td>62.6</td>\n",
       "      <td>50.4</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>213.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:49:17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>266</th>\n",
       "      <td>2018-11-01 23:54:53</td>\n",
       "      <td>62.6</td>\n",
       "      <td>49.5</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>200.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:54:53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>268</th>\n",
       "      <td>2018-11-01 23:59:57</td>\n",
       "      <td>62.8</td>\n",
       "      <td>49.6</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>SSW</td>\n",
       "      <td>208.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Weather logger V3.0.</td>\n",
       "      <td>2018-11-02 06:59:57</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>135 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Time  TemperatureF  DewpointF  PressureIn WindDirection  \\\n",
       "0    2018-11-01 12:49:32          72.3       48.0      -100.0           SSW   \n",
       "2    2018-11-01 12:54:36          72.5       48.2      -100.0            SE   \n",
       "4    2018-11-01 12:59:56          73.4       45.7      -100.0         South   \n",
       "6    2018-11-01 13:04:44          74.3       44.2      -100.0           ESE   \n",
       "8    2018-11-01 13:09:48          75.4       44.4      -100.0            SE   \n",
       "10   2018-11-01 13:14:52          76.3       44.2      -100.0            SE   \n",
       "12   2018-11-01 13:19:56          77.5       43.7      -100.0           SSE   \n",
       "14   2018-11-01 13:24:44          78.8       45.7      -100.0         South   \n",
       "16   2018-11-01 13:29:32          79.7       45.5      -100.0          East   \n",
       "18   2018-11-01 13:34:36          80.6       45.5      -100.0            NE   \n",
       "20   2018-11-01 13:39:56          81.7       46.4      -100.0            NE   \n",
       "22   2018-11-01 13:44:28          82.4       47.8      -100.0            NE   \n",
       "24   2018-11-01 13:49:16          82.9       49.3      -100.0           SSW   \n",
       "26   2018-11-01 13:54:52          83.3       50.4      -100.0         South   \n",
       "28   2018-11-01 13:59:40          83.3       49.6      -100.0            SW   \n",
       "30   2018-11-01 14:04:44          83.3       48.7      -100.0         South   \n",
       "32   2018-11-01 14:09:48          83.5       48.9      -100.0           SSW   \n",
       "34   2018-11-01 14:14:52          83.5       48.9      -100.0            NW   \n",
       "36   2018-11-01 14:19:56          83.8       49.1      -100.0           SSE   \n",
       "38   2018-11-01 14:24:12          84.0       50.2      -100.0           SSW   \n",
       "40   2018-11-01 14:29:48          84.2       48.6      -100.0            NE   \n",
       "42   2018-11-01 14:34:52          84.4       45.9      -100.0           WNW   \n",
       "44   2018-11-01 14:39:56          84.4       44.8      -100.0           NNW   \n",
       "46   2018-11-01 14:44:28          84.6       46.9      -100.0           SSE   \n",
       "48   2018-11-01 14:49:48          84.6       48.0      -100.0           SSW   \n",
       "50   2018-11-01 14:54:52          84.7       47.1      -100.0            SE   \n",
       "52   2018-11-01 14:59:56          84.9       47.3      -100.0            NW   \n",
       "54   2018-11-01 15:04:44          84.7       50.0      -100.0            SE   \n",
       "56   2018-11-01 15:09:32          84.6       49.8      -100.0           NNW   \n",
       "58   2018-11-01 15:14:36          84.2       49.5      -100.0           ESE   \n",
       "..                   ...           ...        ...         ...           ...   \n",
       "210  2018-11-01 21:34:37          64.0       52.2      -100.0           SSW   \n",
       "212  2018-11-01 21:39:57          64.2       51.8      -100.0            SW   \n",
       "214  2018-11-01 21:44:45          64.2       51.4      -100.0         South   \n",
       "216  2018-11-01 21:49:49          64.4       52.0      -100.0         South   \n",
       "218  2018-11-01 21:54:53          64.4       53.2      -100.0           SSW   \n",
       "220  2018-11-01 21:59:41          64.2       52.7      -100.0          West   \n",
       "222  2018-11-01 22:04:45          64.2       50.5      -100.0           SSW   \n",
       "224  2018-11-01 22:09:49          64.4       52.0      -100.0            SW   \n",
       "226  2018-11-01 22:14:05          64.4       51.1      -100.0           SSW   \n",
       "228  2018-11-01 22:19:57          64.6       50.0      -100.0           SSW   \n",
       "230  2018-11-01 22:24:45          64.8       52.7      -100.0           SSW   \n",
       "232  2018-11-01 22:29:49          65.1       53.6      -100.0           SSW   \n",
       "234  2018-11-01 22:34:37          65.1       54.0      -100.0           SSW   \n",
       "236  2018-11-01 22:39:41          64.9       54.1      -100.0           SSW   \n",
       "238  2018-11-01 22:44:45          64.8       54.0      -100.0         South   \n",
       "240  2018-11-01 22:49:49          64.6       53.8      -100.0           SSW   \n",
       "242  2018-11-01 22:54:53          64.4       52.0      -100.0            SW   \n",
       "244  2018-11-01 22:59:57          64.2       51.4      -100.0           SSW   \n",
       "246  2018-11-01 23:04:45          64.2       51.4      -100.0            SW   \n",
       "248  2018-11-01 23:09:49          64.0       51.3      -100.0            SW   \n",
       "250  2018-11-01 23:14:37          64.0       51.3      -100.0           SSW   \n",
       "252  2018-11-01 23:19:57          63.9       51.4      -100.0           SSW   \n",
       "254  2018-11-01 23:24:45          63.7       51.3      -100.0           SSW   \n",
       "256  2018-11-01 23:29:49          63.3       51.4      -100.0           SSW   \n",
       "258  2018-11-01 23:34:21          63.1       51.3      -100.0           SSW   \n",
       "260  2018-11-01 23:39:57          62.8       51.3      -100.0           SSW   \n",
       "262  2018-11-01 23:44:29          62.6       51.1      -100.0            SW   \n",
       "264  2018-11-01 23:49:17          62.6       50.4      -100.0           SSW   \n",
       "266  2018-11-01 23:54:53          62.6       49.5      -100.0           SSW   \n",
       "268  2018-11-01 23:59:57          62.8       49.6      -100.0           SSW   \n",
       "\n",
       "     WindDirectionDegrees  WindSpeedMPH  WindSpeedGustMPH  Humidity  \\\n",
       "0                   202.0           0.0               0.0      42.0   \n",
       "2                   133.0           0.0               0.0      42.0   \n",
       "4                   187.0           0.0               0.0      37.0   \n",
       "6                   114.0           1.8               4.9      34.0   \n",
       "8                   133.0           0.4               2.5      33.0   \n",
       "10                  139.0           0.0               0.0      32.0   \n",
       "12                  150.0           0.0               0.0      30.0   \n",
       "14                  186.0           0.0               0.0      31.0   \n",
       "16                   97.0           0.0               0.0      30.0   \n",
       "18                   39.0           0.0               0.0      29.0   \n",
       "20                   46.0           0.0               0.0      29.0   \n",
       "22                   49.0           0.0               0.0      30.0   \n",
       "24                  212.0           0.0               0.0      31.0   \n",
       "26                  190.0           0.0               0.0      32.0   \n",
       "28                  226.0           0.0               0.0      31.0   \n",
       "30                  183.0           0.0               0.0      30.0   \n",
       "32                  203.0           0.0               0.0      30.0   \n",
       "34                  325.0           0.0               0.0      30.0   \n",
       "36                  162.0           0.0               0.0      30.0   \n",
       "38                  195.0           0.0               0.0      31.0   \n",
       "40                   49.0           0.0               0.0      29.0   \n",
       "42                  287.0           0.9               2.5      26.0   \n",
       "44                  342.0           0.9               4.9      25.0   \n",
       "46                  152.0           0.0               0.0      27.0   \n",
       "48                  196.0           0.0               0.0      28.0   \n",
       "50                  137.0           0.0               0.0      27.0   \n",
       "52                  307.0           0.0               0.0      27.0   \n",
       "54                  130.0           1.3               2.5      30.0   \n",
       "56                  342.0           0.0               0.0      30.0   \n",
       "58                  121.0           0.0               0.0      30.0   \n",
       "..                    ...           ...               ...       ...   \n",
       "210                 212.0           0.0               0.0      65.0   \n",
       "212                 223.0           0.0               0.0      64.0   \n",
       "214                 190.0           0.0               0.0      63.0   \n",
       "216                 190.0           0.0               0.0      64.0   \n",
       "218                 204.0           0.0               0.0      67.0   \n",
       "220                 274.0           0.0               0.0      66.0   \n",
       "222                 202.0           0.0               0.0      61.0   \n",
       "224                 221.0           0.0               0.0      64.0   \n",
       "226                 202.0           0.0               0.0      62.0   \n",
       "228                 192.0           0.0               0.0      59.0   \n",
       "230                 193.0           0.0               0.0      65.0   \n",
       "232                 192.0           0.0               0.0      66.0   \n",
       "234                 200.0           0.0               0.0      67.0   \n",
       "236                 207.0           0.0               0.0      68.0   \n",
       "238                 189.0           0.0               0.0      68.0   \n",
       "240                 210.0           0.0               0.0      68.0   \n",
       "242                 221.0           0.0               0.0      64.0   \n",
       "244                 200.0           0.0               0.0      63.0   \n",
       "246                 214.0           0.0               0.0      63.0   \n",
       "248                 219.0           0.0               0.0      63.0   \n",
       "250                 209.0           0.0               0.0      63.0   \n",
       "252                 205.0           0.0               0.0      64.0   \n",
       "254                 208.0           0.0               0.0      64.0   \n",
       "256                 207.0           0.0               0.0      65.0   \n",
       "258                 206.0           0.0               0.0      65.0   \n",
       "260                 206.0           0.0               0.0      66.0   \n",
       "262                 229.0           0.0               0.0      66.0   \n",
       "264                 213.0           0.0               0.0      64.0   \n",
       "266                 200.0           0.0               0.0      62.0   \n",
       "268                 208.0           0.0               0.0      62.0   \n",
       "\n",
       "     HourlyPrecipIn  Conditions  Clouds  dailyrainin  SolarRadiationWatts/m^2  \\\n",
       "0              0.00         NaN     NaN         0.00                    44.49   \n",
       "2              0.21         NaN     NaN         0.04                   277.27   \n",
       "4              0.21         NaN     NaN         0.04                   292.76   \n",
       "6              0.00         NaN     NaN         0.04                   288.55   \n",
       "8              0.00         NaN     NaN         0.04                   295.80   \n",
       "10             0.00         NaN     NaN         0.04                   274.66   \n",
       "12             0.00         NaN     NaN         0.04                   274.23   \n",
       "14             0.00         NaN     NaN         0.04                   287.99   \n",
       "16             0.00         NaN     NaN         0.04                   279.70   \n",
       "18             0.00         NaN     NaN         0.04                   290.42   \n",
       "20             0.00         NaN     NaN         0.04                   280.35   \n",
       "22             0.00         NaN     NaN         0.04                   266.63   \n",
       "24             0.00         NaN     NaN         0.04                   260.77   \n",
       "26             0.00         NaN     NaN         0.04                   252.30   \n",
       "28             0.00         NaN     NaN         0.04                   245.79   \n",
       "30             0.00         NaN     NaN         0.04                   239.89   \n",
       "32             0.00         NaN     NaN         0.04                   243.23   \n",
       "34             0.00         NaN     NaN         0.04                   235.37   \n",
       "36             0.00         NaN     NaN         0.04                   226.00   \n",
       "38             0.00         NaN     NaN         0.04                   227.39   \n",
       "40             0.00         NaN     NaN         0.04                   219.75   \n",
       "42             0.00         NaN     NaN         0.04                   131.58   \n",
       "44             0.00         NaN     NaN         0.04                   216.19   \n",
       "46             0.00         NaN     NaN         0.04                   132.06   \n",
       "48             0.00         NaN     NaN         0.04                   132.49   \n",
       "50             0.00         NaN     NaN         0.04                   193.70   \n",
       "52             0.00         NaN     NaN         0.04                   115.30   \n",
       "54             0.00         NaN     NaN         0.04                   125.16   \n",
       "56             0.00         NaN     NaN         0.04                   187.58   \n",
       "58             0.00         NaN     NaN         0.04                   130.71   \n",
       "..              ...         ...     ...          ...                      ...   \n",
       "210            0.00         NaN     NaN         0.00                     0.00   \n",
       "212            0.00         NaN     NaN         0.00                     0.00   \n",
       "214            0.00         NaN     NaN         0.00                     0.00   \n",
       "216            0.00         NaN     NaN         0.00                     0.00   \n",
       "218            0.00         NaN     NaN         0.00                     0.00   \n",
       "220            0.00         NaN     NaN         0.00                     0.00   \n",
       "222            0.00         NaN     NaN         0.00                     0.00   \n",
       "224            0.00         NaN     NaN         0.00                     0.00   \n",
       "226            0.00         NaN     NaN         0.00                     0.00   \n",
       "228            0.00         NaN     NaN         0.00                     0.00   \n",
       "230            0.00         NaN     NaN         0.00                     0.00   \n",
       "232            0.00         NaN     NaN         0.00                     0.00   \n",
       "234            0.00         NaN     NaN         0.00                     0.00   \n",
       "236            0.00         NaN     NaN         0.00                     0.00   \n",
       "238            0.00         NaN     NaN         0.00                     0.00   \n",
       "240            0.00         NaN     NaN         0.00                     0.00   \n",
       "242            0.00         NaN     NaN         0.00                     0.00   \n",
       "244            0.00         NaN     NaN         0.00                     0.00   \n",
       "246            0.00         NaN     NaN         0.00                     0.00   \n",
       "248            0.00         NaN     NaN         0.00                     0.00   \n",
       "250            0.00         NaN     NaN         0.00                     0.00   \n",
       "252            0.00         NaN     NaN         0.00                     0.00   \n",
       "254            0.00         NaN     NaN         0.00                     0.00   \n",
       "256            0.00         NaN     NaN         0.00                     0.00   \n",
       "258            0.00         NaN     NaN         0.00                     0.00   \n",
       "260            0.00         NaN     NaN         0.00                     0.00   \n",
       "262            0.00         NaN     NaN         0.00                     0.00   \n",
       "264            0.00         NaN     NaN         0.00                     0.00   \n",
       "266            0.00         NaN     NaN         0.00                     0.00   \n",
       "268            0.00         NaN     NaN         0.00                     0.00   \n",
       "\n",
       "             SoftwareType          DateUTC<br>  \n",
       "0    Weather logger V3.0.  2018-11-01 19:49:32  \n",
       "2    Weather logger V3.0.  2018-11-01 19:54:36  \n",
       "4    Weather logger V3.0.  2018-11-01 19:59:56  \n",
       "6    Weather logger V3.0.  2018-11-01 20:04:44  \n",
       "8    Weather logger V3.0.  2018-11-01 20:09:48  \n",
       "10   Weather logger V3.0.  2018-11-01 20:14:52  \n",
       "12   Weather logger V3.0.  2018-11-01 20:19:56  \n",
       "14   Weather logger V3.0.  2018-11-01 20:24:44  \n",
       "16   Weather logger V3.0.  2018-11-01 20:29:32  \n",
       "18   Weather logger V3.0.  2018-11-01 20:34:36  \n",
       "20   Weather logger V3.0.  2018-11-01 20:39:56  \n",
       "22   Weather logger V3.0.  2018-11-01 20:44:28  \n",
       "24   Weather logger V3.0.  2018-11-01 20:49:16  \n",
       "26   Weather logger V3.0.  2018-11-01 20:54:52  \n",
       "28   Weather logger V3.0.  2018-11-01 20:59:40  \n",
       "30   Weather logger V3.0.  2018-11-01 21:04:44  \n",
       "32   Weather logger V3.0.  2018-11-01 21:09:48  \n",
       "34   Weather logger V3.0.  2018-11-01 21:14:52  \n",
       "36   Weather logger V3.0.  2018-11-01 21:19:56  \n",
       "38   Weather logger V3.0.  2018-11-01 21:24:12  \n",
       "40   Weather logger V3.0.  2018-11-01 21:29:48  \n",
       "42   Weather logger V3.0.  2018-11-01 21:34:52  \n",
       "44   Weather logger V3.0.  2018-11-01 21:39:56  \n",
       "46   Weather logger V3.0.  2018-11-01 21:44:28  \n",
       "48   Weather logger V3.0.  2018-11-01 21:49:48  \n",
       "50   Weather logger V3.0.  2018-11-01 21:54:52  \n",
       "52   Weather logger V3.0.  2018-11-01 21:59:56  \n",
       "54   Weather logger V3.0.  2018-11-01 22:04:44  \n",
       "56   Weather logger V3.0.  2018-11-01 22:09:32  \n",
       "58   Weather logger V3.0.  2018-11-01 22:14:36  \n",
       "..                    ...                  ...  \n",
       "210  Weather logger V3.0.  2018-11-02 04:34:37  \n",
       "212  Weather logger V3.0.  2018-11-02 04:39:57  \n",
       "214  Weather logger V3.0.  2018-11-02 04:44:45  \n",
       "216  Weather logger V3.0.  2018-11-02 04:49:49  \n",
       "218  Weather logger V3.0.  2018-11-02 04:54:53  \n",
       "220  Weather logger V3.0.  2018-11-02 04:59:41  \n",
       "222  Weather logger V3.0.  2018-11-02 05:04:45  \n",
       "224  Weather logger V3.0.  2018-11-02 05:09:49  \n",
       "226  Weather logger V3.0.  2018-11-02 05:14:05  \n",
       "228  Weather logger V3.0.  2018-11-02 05:19:57  \n",
       "230  Weather logger V3.0.  2018-11-02 05:24:45  \n",
       "232  Weather logger V3.0.  2018-11-02 05:29:49  \n",
       "234  Weather logger V3.0.  2018-11-02 05:34:37  \n",
       "236  Weather logger V3.0.  2018-11-02 05:39:41  \n",
       "238  Weather logger V3.0.  2018-11-02 05:44:45  \n",
       "240  Weather logger V3.0.  2018-11-02 05:49:49  \n",
       "242  Weather logger V3.0.  2018-11-02 05:54:53  \n",
       "244  Weather logger V3.0.  2018-11-02 05:59:57  \n",
       "246  Weather logger V3.0.  2018-11-02 06:04:45  \n",
       "248  Weather logger V3.0.  2018-11-02 06:09:49  \n",
       "250  Weather logger V3.0.  2018-11-02 06:14:37  \n",
       "252  Weather logger V3.0.  2018-11-02 06:19:57  \n",
       "254  Weather logger V3.0.  2018-11-02 06:24:45  \n",
       "256  Weather logger V3.0.  2018-11-02 06:29:49  \n",
       "258  Weather logger V3.0.  2018-11-02 06:34:21  \n",
       "260  Weather logger V3.0.  2018-11-02 06:39:57  \n",
       "262  Weather logger V3.0.  2018-11-02 06:44:29  \n",
       "264  Weather logger V3.0.  2018-11-02 06:49:17  \n",
       "266  Weather logger V3.0.  2018-11-02 06:54:53  \n",
       "268  Weather logger V3.0.  2018-11-02 06:59:57  \n",
       "\n",
       "[135 rows x 16 columns]"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# We can clean-up the odd row structure trivially:\n",
    "dg = df.drop([2*i + 1 for i in range(df.shape[0] // 2)])\n",
    "dg"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "code_folding": []
   },
   "outputs": [],
   "source": [
    "# Method for grabbing data for a specific location and data and cleaning up the website query output\n",
    "def get_clean_df(location_id, date):\n",
    "    \"\"\"Get weather data from `location_id` on `date`, then\n",
    "    remove all the `<br>` tags in the file.\n",
    "    \n",
    "    `date` should be a list/tuple of 3 strings in the format\n",
    "    [MM, DD, YYYY].\n",
    "    \"\"\"\n",
    "    url = \"https://www.wunderground.com/weatherstation/WXDailyHistory.asp?\" + \\\n",
    "          \"ID={}&\".format(location_id) + \\\n",
    "          \"day={}&\".format(date[1]) + \\\n",
    "          \"month={}&\".format(date[0]) + \\\n",
    "          \"year={}&\".format(date[2]) + \\\n",
    "          \"graphspan=day&format=1\"\n",
    "    print(url)\n",
    "    data = pd.read_csv(url, index_col=False)\n",
    "    # drop every other row because it contains `<br>`\n",
    "    return data.drop([2*i + 1 for i in range(data.shape[0] // 2)])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://www.wunderground.com/weatherstation/WXDailyHistory.asp?ID=KCABERKE169&day=01&month=11&year=2018&graphspan=day&format=1\n"
     ]
    }
   ],
   "source": [
    "# Method to process weather data DataFrame \n",
    "#   - converts temperature/pressure to sensible units and drop unneeded columns\n",
    "def process_data(data_df):\n",
    "    def deg_f_to_c(deg_f):\n",
    "        return (5. / 9.) * (deg_f - 32)\n",
    "\n",
    "    def inhg_to_mbar(inhg):\n",
    "        return 33.863753 * inhg\n",
    "\n",
    "    data_df.reset_index()\n",
    "    for row in data_df.itertuples():\n",
    "        idx = row.Index\n",
    "        itime, tempf, dewf, pressure = row.Time, row.TemperatureF, row.DewpointF, row.PressureIn\n",
    "        data_df.loc[idx, 'Time'] = datetime.strptime(itime, '%Y-%m-%d %H:%M:%S')\n",
    "        data_df.loc[idx, 'Temperature'] = deg_f_to_c(tempf)\n",
    "        data_df.loc[idx, 'Dewpoint'] = deg_f_to_c(dewf)\n",
    "        data_df.loc[idx, 'Pressure'] = inhg_to_mbar(pressure)\n",
    "\n",
    "    return data_df.drop(['TemperatureF', 'DewpointF', 'PressureIn', 'Conditions', 'Clouds',\n",
    "                         'SoftwareType', 'DateUTC<br>'], axis=1)\n",
    "\n",
    "ws_data = process_data(get_clean_df('KCABERKE169', ['11', '01', '2018']))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Time</th>\n",
       "      <th>WindDirection</th>\n",
       "      <th>WindDirectionDegrees</th>\n",
       "      <th>WindSpeedMPH</th>\n",
       "      <th>WindSpeedGustMPH</th>\n",
       "      <th>Humidity</th>\n",
       "      <th>HourlyPrecipIn</th>\n",
       "      <th>dailyrainin</th>\n",
       "      <th>SolarRadiationWatts/m^2</th>\n",
       "      <th>Temperature</th>\n",
       "      <th>Dewpoint</th>\n",
       "      <th>Pressure</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-11-01 12:49:32</td>\n",
       "      <td>SSW</td>\n",
       "      <td>202.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>44.49</td>\n",
       "      <td>22.388889</td>\n",
       "      <td>8.888889</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018-11-01 12:54:36</td>\n",
       "      <td>SE</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>0.21</td>\n",
       "      <td>0.04</td>\n",
       "      <td>277.27</td>\n",
       "      <td>22.500000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2018-11-01 12:59:56</td>\n",
       "      <td>South</td>\n",
       "      <td>187.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>0.21</td>\n",
       "      <td>0.04</td>\n",
       "      <td>292.76</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>7.611111</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2018-11-01 13:04:44</td>\n",
       "      <td>ESE</td>\n",
       "      <td>114.0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>4.9</td>\n",
       "      <td>34.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>288.55</td>\n",
       "      <td>23.500000</td>\n",
       "      <td>6.777778</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2018-11-01 13:09:48</td>\n",
       "      <td>SE</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.4</td>\n",
       "      <td>2.5</td>\n",
       "      <td>33.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>295.80</td>\n",
       "      <td>24.111111</td>\n",
       "      <td>6.888889</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2018-11-01 13:14:52</td>\n",
       "      <td>SE</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>274.66</td>\n",
       "      <td>24.611111</td>\n",
       "      <td>6.777778</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2018-11-01 13:19:56</td>\n",
       "      <td>SSE</td>\n",
       "      <td>150.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>274.23</td>\n",
       "      <td>25.277778</td>\n",
       "      <td>6.500000</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2018-11-01 13:24:44</td>\n",
       "      <td>South</td>\n",
       "      <td>186.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>287.99</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>7.611111</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2018-11-01 13:29:32</td>\n",
       "      <td>East</td>\n",
       "      <td>97.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>279.70</td>\n",
       "      <td>26.500000</td>\n",
       "      <td>7.500000</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2018-11-01 13:34:36</td>\n",
       "      <td>NE</td>\n",
       "      <td>39.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>290.42</td>\n",
       "      <td>27.000000</td>\n",
       "      <td>7.500000</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2018-11-01 13:39:56</td>\n",
       "      <td>NE</td>\n",
       "      <td>46.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>280.35</td>\n",
       "      <td>27.611111</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2018-11-01 13:44:28</td>\n",
       "      <td>NE</td>\n",
       "      <td>49.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>266.63</td>\n",
       "      <td>28.000000</td>\n",
       "      <td>8.777778</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2018-11-01 13:49:16</td>\n",
       "      <td>SSW</td>\n",
       "      <td>212.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>260.77</td>\n",
       "      <td>28.277778</td>\n",
       "      <td>9.611111</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2018-11-01 13:54:52</td>\n",
       "      <td>South</td>\n",
       "      <td>190.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>252.30</td>\n",
       "      <td>28.500000</td>\n",
       "      <td>10.222222</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2018-11-01 13:59:40</td>\n",
       "      <td>SW</td>\n",
       "      <td>226.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>245.79</td>\n",
       "      <td>28.500000</td>\n",
       "      <td>9.777778</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2018-11-01 14:04:44</td>\n",
       "      <td>South</td>\n",
       "      <td>183.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>239.89</td>\n",
       "      <td>28.500000</td>\n",
       "      <td>9.277778</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2018-11-01 14:09:48</td>\n",
       "      <td>SSW</td>\n",
       "      <td>203.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>243.23</td>\n",
       "      <td>28.611111</td>\n",
       "      <td>9.388889</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2018-11-01 14:14:52</td>\n",
       "      <td>NW</td>\n",
       "      <td>325.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>235.37</td>\n",
       "      <td>28.611111</td>\n",
       "      <td>9.388889</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2018-11-01 14:19:56</td>\n",
       "      <td>SSE</td>\n",
       "      <td>162.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>226.00</td>\n",
       "      <td>28.777778</td>\n",
       "      <td>9.500000</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2018-11-01 14:24:12</td>\n",
       "      <td>SSW</td>\n",
       "      <td>195.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>227.39</td>\n",
       "      <td>28.888889</td>\n",
       "      <td>10.111111</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>2018-11-01 14:29:48</td>\n",
       "      <td>NE</td>\n",
       "      <td>49.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>219.75</td>\n",
       "      <td>29.000000</td>\n",
       "      <td>9.222222</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>2018-11-01 14:34:52</td>\n",
       "      <td>WNW</td>\n",
       "      <td>287.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2.5</td>\n",
       "      <td>26.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>131.58</td>\n",
       "      <td>29.111111</td>\n",
       "      <td>7.722222</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>2018-11-01 14:39:56</td>\n",
       "      <td>NNW</td>\n",
       "      <td>342.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>4.9</td>\n",
       "      <td>25.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>216.19</td>\n",
       "      <td>29.111111</td>\n",
       "      <td>7.111111</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>2018-11-01 14:44:28</td>\n",
       "      <td>SSE</td>\n",
       "      <td>152.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>132.06</td>\n",
       "      <td>29.222222</td>\n",
       "      <td>8.277778</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>2018-11-01 14:49:48</td>\n",
       "      <td>SSW</td>\n",
       "      <td>196.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>132.49</td>\n",
       "      <td>29.222222</td>\n",
       "      <td>8.888889</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>2018-11-01 14:54:52</td>\n",
       "      <td>SE</td>\n",
       "      <td>137.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>193.70</td>\n",
       "      <td>29.277778</td>\n",
       "      <td>8.388889</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>2018-11-01 14:59:56</td>\n",
       "      <td>NW</td>\n",
       "      <td>307.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>115.30</td>\n",
       "      <td>29.388889</td>\n",
       "      <td>8.500000</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>2018-11-01 15:04:44</td>\n",
       "      <td>SE</td>\n",
       "      <td>130.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>2.5</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>125.16</td>\n",
       "      <td>29.277778</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>2018-11-01 15:09:32</td>\n",
       "      <td>NNW</td>\n",
       "      <td>342.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>187.58</td>\n",
       "      <td>29.222222</td>\n",
       "      <td>9.888889</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>2018-11-01 15:14:36</td>\n",
       "      <td>ESE</td>\n",
       "      <td>121.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>130.71</td>\n",
       "      <td>29.000000</td>\n",
       "      <td>9.722222</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>2018-11-01 21:34:37</td>\n",
       "      <td>SSW</td>\n",
       "      <td>212.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17.777778</td>\n",
       "      <td>11.222222</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>2018-11-01 21:39:57</td>\n",
       "      <td>SW</td>\n",
       "      <td>223.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17.888889</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>2018-11-01 21:44:45</td>\n",
       "      <td>South</td>\n",
       "      <td>190.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17.888889</td>\n",
       "      <td>10.777778</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>2018-11-01 21:49:49</td>\n",
       "      <td>South</td>\n",
       "      <td>190.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>11.111111</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>2018-11-01 21:54:53</td>\n",
       "      <td>SSW</td>\n",
       "      <td>204.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>11.777778</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>2018-11-01 21:59:41</td>\n",
       "      <td>West</td>\n",
       "      <td>274.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17.888889</td>\n",
       "      <td>11.500000</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>2018-11-01 22:04:45</td>\n",
       "      <td>SSW</td>\n",
       "      <td>202.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17.888889</td>\n",
       "      <td>10.277778</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>2018-11-01 22:09:49</td>\n",
       "      <td>SW</td>\n",
       "      <td>221.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>11.111111</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>2018-11-01 22:14:05</td>\n",
       "      <td>SSW</td>\n",
       "      <td>202.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>10.611111</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>2018-11-01 22:19:57</td>\n",
       "      <td>SSW</td>\n",
       "      <td>192.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>18.111111</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>2018-11-01 22:24:45</td>\n",
       "      <td>SSW</td>\n",
       "      <td>193.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>18.222222</td>\n",
       "      <td>11.500000</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>2018-11-01 22:29:49</td>\n",
       "      <td>SSW</td>\n",
       "      <td>192.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>18.388889</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>2018-11-01 22:34:37</td>\n",
       "      <td>SSW</td>\n",
       "      <td>200.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>18.388889</td>\n",
       "      <td>12.222222</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>2018-11-01 22:39:41</td>\n",
       "      <td>SSW</td>\n",
       "      <td>207.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>18.277778</td>\n",
       "      <td>12.277778</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>2018-11-01 22:44:45</td>\n",
       "      <td>South</td>\n",
       "      <td>189.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>18.222222</td>\n",
       "      <td>12.222222</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>2018-11-01 22:49:49</td>\n",
       "      <td>SSW</td>\n",
       "      <td>210.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>18.111111</td>\n",
       "      <td>12.111111</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>2018-11-01 22:54:53</td>\n",
       "      <td>SW</td>\n",
       "      <td>221.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>11.111111</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>2018-11-01 22:59:57</td>\n",
       "      <td>SSW</td>\n",
       "      <td>200.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17.888889</td>\n",
       "      <td>10.777778</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>2018-11-01 23:04:45</td>\n",
       "      <td>SW</td>\n",
       "      <td>214.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17.888889</td>\n",
       "      <td>10.777778</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>2018-11-01 23:09:49</td>\n",
       "      <td>SW</td>\n",
       "      <td>219.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17.777778</td>\n",
       "      <td>10.722222</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>2018-11-01 23:14:37</td>\n",
       "      <td>SSW</td>\n",
       "      <td>209.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17.777778</td>\n",
       "      <td>10.722222</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>2018-11-01 23:19:57</td>\n",
       "      <td>SSW</td>\n",
       "      <td>205.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17.722222</td>\n",
       "      <td>10.777778</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>2018-11-01 23:24:45</td>\n",
       "      <td>SSW</td>\n",
       "      <td>208.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17.611111</td>\n",
       "      <td>10.722222</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>2018-11-01 23:29:49</td>\n",
       "      <td>SSW</td>\n",
       "      <td>207.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17.388889</td>\n",
       "      <td>10.777778</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>2018-11-01 23:34:21</td>\n",
       "      <td>SSW</td>\n",
       "      <td>206.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17.277778</td>\n",
       "      <td>10.722222</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>2018-11-01 23:39:57</td>\n",
       "      <td>SSW</td>\n",
       "      <td>206.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17.111111</td>\n",
       "      <td>10.722222</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262</th>\n",
       "      <td>2018-11-01 23:44:29</td>\n",
       "      <td>SW</td>\n",
       "      <td>229.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>10.611111</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>264</th>\n",
       "      <td>2018-11-01 23:49:17</td>\n",
       "      <td>SSW</td>\n",
       "      <td>213.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>10.222222</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>266</th>\n",
       "      <td>2018-11-01 23:54:53</td>\n",
       "      <td>SSW</td>\n",
       "      <td>200.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>9.722222</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>268</th>\n",
       "      <td>2018-11-01 23:59:57</td>\n",
       "      <td>SSW</td>\n",
       "      <td>208.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17.111111</td>\n",
       "      <td>9.777778</td>\n",
       "      <td>-3386.3753</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>135 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Time WindDirection  WindDirectionDegrees  WindSpeedMPH  \\\n",
       "0    2018-11-01 12:49:32           SSW                 202.0           0.0   \n",
       "2    2018-11-01 12:54:36            SE                 133.0           0.0   \n",
       "4    2018-11-01 12:59:56         South                 187.0           0.0   \n",
       "6    2018-11-01 13:04:44           ESE                 114.0           1.8   \n",
       "8    2018-11-01 13:09:48            SE                 133.0           0.4   \n",
       "10   2018-11-01 13:14:52            SE                 139.0           0.0   \n",
       "12   2018-11-01 13:19:56           SSE                 150.0           0.0   \n",
       "14   2018-11-01 13:24:44         South                 186.0           0.0   \n",
       "16   2018-11-01 13:29:32          East                  97.0           0.0   \n",
       "18   2018-11-01 13:34:36            NE                  39.0           0.0   \n",
       "20   2018-11-01 13:39:56            NE                  46.0           0.0   \n",
       "22   2018-11-01 13:44:28            NE                  49.0           0.0   \n",
       "24   2018-11-01 13:49:16           SSW                 212.0           0.0   \n",
       "26   2018-11-01 13:54:52         South                 190.0           0.0   \n",
       "28   2018-11-01 13:59:40            SW                 226.0           0.0   \n",
       "30   2018-11-01 14:04:44         South                 183.0           0.0   \n",
       "32   2018-11-01 14:09:48           SSW                 203.0           0.0   \n",
       "34   2018-11-01 14:14:52            NW                 325.0           0.0   \n",
       "36   2018-11-01 14:19:56           SSE                 162.0           0.0   \n",
       "38   2018-11-01 14:24:12           SSW                 195.0           0.0   \n",
       "40   2018-11-01 14:29:48            NE                  49.0           0.0   \n",
       "42   2018-11-01 14:34:52           WNW                 287.0           0.9   \n",
       "44   2018-11-01 14:39:56           NNW                 342.0           0.9   \n",
       "46   2018-11-01 14:44:28           SSE                 152.0           0.0   \n",
       "48   2018-11-01 14:49:48           SSW                 196.0           0.0   \n",
       "50   2018-11-01 14:54:52            SE                 137.0           0.0   \n",
       "52   2018-11-01 14:59:56            NW                 307.0           0.0   \n",
       "54   2018-11-01 15:04:44            SE                 130.0           1.3   \n",
       "56   2018-11-01 15:09:32           NNW                 342.0           0.0   \n",
       "58   2018-11-01 15:14:36           ESE                 121.0           0.0   \n",
       "..                   ...           ...                   ...           ...   \n",
       "210  2018-11-01 21:34:37           SSW                 212.0           0.0   \n",
       "212  2018-11-01 21:39:57            SW                 223.0           0.0   \n",
       "214  2018-11-01 21:44:45         South                 190.0           0.0   \n",
       "216  2018-11-01 21:49:49         South                 190.0           0.0   \n",
       "218  2018-11-01 21:54:53           SSW                 204.0           0.0   \n",
       "220  2018-11-01 21:59:41          West                 274.0           0.0   \n",
       "222  2018-11-01 22:04:45           SSW                 202.0           0.0   \n",
       "224  2018-11-01 22:09:49            SW                 221.0           0.0   \n",
       "226  2018-11-01 22:14:05           SSW                 202.0           0.0   \n",
       "228  2018-11-01 22:19:57           SSW                 192.0           0.0   \n",
       "230  2018-11-01 22:24:45           SSW                 193.0           0.0   \n",
       "232  2018-11-01 22:29:49           SSW                 192.0           0.0   \n",
       "234  2018-11-01 22:34:37           SSW                 200.0           0.0   \n",
       "236  2018-11-01 22:39:41           SSW                 207.0           0.0   \n",
       "238  2018-11-01 22:44:45         South                 189.0           0.0   \n",
       "240  2018-11-01 22:49:49           SSW                 210.0           0.0   \n",
       "242  2018-11-01 22:54:53            SW                 221.0           0.0   \n",
       "244  2018-11-01 22:59:57           SSW                 200.0           0.0   \n",
       "246  2018-11-01 23:04:45            SW                 214.0           0.0   \n",
       "248  2018-11-01 23:09:49            SW                 219.0           0.0   \n",
       "250  2018-11-01 23:14:37           SSW                 209.0           0.0   \n",
       "252  2018-11-01 23:19:57           SSW                 205.0           0.0   \n",
       "254  2018-11-01 23:24:45           SSW                 208.0           0.0   \n",
       "256  2018-11-01 23:29:49           SSW                 207.0           0.0   \n",
       "258  2018-11-01 23:34:21           SSW                 206.0           0.0   \n",
       "260  2018-11-01 23:39:57           SSW                 206.0           0.0   \n",
       "262  2018-11-01 23:44:29            SW                 229.0           0.0   \n",
       "264  2018-11-01 23:49:17           SSW                 213.0           0.0   \n",
       "266  2018-11-01 23:54:53           SSW                 200.0           0.0   \n",
       "268  2018-11-01 23:59:57           SSW                 208.0           0.0   \n",
       "\n",
       "     WindSpeedGustMPH  Humidity  HourlyPrecipIn  dailyrainin  \\\n",
       "0                 0.0      42.0            0.00         0.00   \n",
       "2                 0.0      42.0            0.21         0.04   \n",
       "4                 0.0      37.0            0.21         0.04   \n",
       "6                 4.9      34.0            0.00         0.04   \n",
       "8                 2.5      33.0            0.00         0.04   \n",
       "10                0.0      32.0            0.00         0.04   \n",
       "12                0.0      30.0            0.00         0.04   \n",
       "14                0.0      31.0            0.00         0.04   \n",
       "16                0.0      30.0            0.00         0.04   \n",
       "18                0.0      29.0            0.00         0.04   \n",
       "20                0.0      29.0            0.00         0.04   \n",
       "22                0.0      30.0            0.00         0.04   \n",
       "24                0.0      31.0            0.00         0.04   \n",
       "26                0.0      32.0            0.00         0.04   \n",
       "28                0.0      31.0            0.00         0.04   \n",
       "30                0.0      30.0            0.00         0.04   \n",
       "32                0.0      30.0            0.00         0.04   \n",
       "34                0.0      30.0            0.00         0.04   \n",
       "36                0.0      30.0            0.00         0.04   \n",
       "38                0.0      31.0            0.00         0.04   \n",
       "40                0.0      29.0            0.00         0.04   \n",
       "42                2.5      26.0            0.00         0.04   \n",
       "44                4.9      25.0            0.00         0.04   \n",
       "46                0.0      27.0            0.00         0.04   \n",
       "48                0.0      28.0            0.00         0.04   \n",
       "50                0.0      27.0            0.00         0.04   \n",
       "52                0.0      27.0            0.00         0.04   \n",
       "54                2.5      30.0            0.00         0.04   \n",
       "56                0.0      30.0            0.00         0.04   \n",
       "58                0.0      30.0            0.00         0.04   \n",
       "..                ...       ...             ...          ...   \n",
       "210               0.0      65.0            0.00         0.00   \n",
       "212               0.0      64.0            0.00         0.00   \n",
       "214               0.0      63.0            0.00         0.00   \n",
       "216               0.0      64.0            0.00         0.00   \n",
       "218               0.0      67.0            0.00         0.00   \n",
       "220               0.0      66.0            0.00         0.00   \n",
       "222               0.0      61.0            0.00         0.00   \n",
       "224               0.0      64.0            0.00         0.00   \n",
       "226               0.0      62.0            0.00         0.00   \n",
       "228               0.0      59.0            0.00         0.00   \n",
       "230               0.0      65.0            0.00         0.00   \n",
       "232               0.0      66.0            0.00         0.00   \n",
       "234               0.0      67.0            0.00         0.00   \n",
       "236               0.0      68.0            0.00         0.00   \n",
       "238               0.0      68.0            0.00         0.00   \n",
       "240               0.0      68.0            0.00         0.00   \n",
       "242               0.0      64.0            0.00         0.00   \n",
       "244               0.0      63.0            0.00         0.00   \n",
       "246               0.0      63.0            0.00         0.00   \n",
       "248               0.0      63.0            0.00         0.00   \n",
       "250               0.0      63.0            0.00         0.00   \n",
       "252               0.0      64.0            0.00         0.00   \n",
       "254               0.0      64.0            0.00         0.00   \n",
       "256               0.0      65.0            0.00         0.00   \n",
       "258               0.0      65.0            0.00         0.00   \n",
       "260               0.0      66.0            0.00         0.00   \n",
       "262               0.0      66.0            0.00         0.00   \n",
       "264               0.0      64.0            0.00         0.00   \n",
       "266               0.0      62.0            0.00         0.00   \n",
       "268               0.0      62.0            0.00         0.00   \n",
       "\n",
       "     SolarRadiationWatts/m^2  Temperature   Dewpoint   Pressure  \n",
       "0                      44.49    22.388889   8.888889 -3386.3753  \n",
       "2                     277.27    22.500000   9.000000 -3386.3753  \n",
       "4                     292.76    23.000000   7.611111 -3386.3753  \n",
       "6                     288.55    23.500000   6.777778 -3386.3753  \n",
       "8                     295.80    24.111111   6.888889 -3386.3753  \n",
       "10                    274.66    24.611111   6.777778 -3386.3753  \n",
       "12                    274.23    25.277778   6.500000 -3386.3753  \n",
       "14                    287.99    26.000000   7.611111 -3386.3753  \n",
       "16                    279.70    26.500000   7.500000 -3386.3753  \n",
       "18                    290.42    27.000000   7.500000 -3386.3753  \n",
       "20                    280.35    27.611111   8.000000 -3386.3753  \n",
       "22                    266.63    28.000000   8.777778 -3386.3753  \n",
       "24                    260.77    28.277778   9.611111 -3386.3753  \n",
       "26                    252.30    28.500000  10.222222 -3386.3753  \n",
       "28                    245.79    28.500000   9.777778 -3386.3753  \n",
       "30                    239.89    28.500000   9.277778 -3386.3753  \n",
       "32                    243.23    28.611111   9.388889 -3386.3753  \n",
       "34                    235.37    28.611111   9.388889 -3386.3753  \n",
       "36                    226.00    28.777778   9.500000 -3386.3753  \n",
       "38                    227.39    28.888889  10.111111 -3386.3753  \n",
       "40                    219.75    29.000000   9.222222 -3386.3753  \n",
       "42                    131.58    29.111111   7.722222 -3386.3753  \n",
       "44                    216.19    29.111111   7.111111 -3386.3753  \n",
       "46                    132.06    29.222222   8.277778 -3386.3753  \n",
       "48                    132.49    29.222222   8.888889 -3386.3753  \n",
       "50                    193.70    29.277778   8.388889 -3386.3753  \n",
       "52                    115.30    29.388889   8.500000 -3386.3753  \n",
       "54                    125.16    29.277778  10.000000 -3386.3753  \n",
       "56                    187.58    29.222222   9.888889 -3386.3753  \n",
       "58                    130.71    29.000000   9.722222 -3386.3753  \n",
       "..                       ...          ...        ...        ...  \n",
       "210                     0.00    17.777778  11.222222 -3386.3753  \n",
       "212                     0.00    17.888889  11.000000 -3386.3753  \n",
       "214                     0.00    17.888889  10.777778 -3386.3753  \n",
       "216                     0.00    18.000000  11.111111 -3386.3753  \n",
       "218                     0.00    18.000000  11.777778 -3386.3753  \n",
       "220                     0.00    17.888889  11.500000 -3386.3753  \n",
       "222                     0.00    17.888889  10.277778 -3386.3753  \n",
       "224                     0.00    18.000000  11.111111 -3386.3753  \n",
       "226                     0.00    18.000000  10.611111 -3386.3753  \n",
       "228                     0.00    18.111111  10.000000 -3386.3753  \n",
       "230                     0.00    18.222222  11.500000 -3386.3753  \n",
       "232                     0.00    18.388889  12.000000 -3386.3753  \n",
       "234                     0.00    18.388889  12.222222 -3386.3753  \n",
       "236                     0.00    18.277778  12.277778 -3386.3753  \n",
       "238                     0.00    18.222222  12.222222 -3386.3753  \n",
       "240                     0.00    18.111111  12.111111 -3386.3753  \n",
       "242                     0.00    18.000000  11.111111 -3386.3753  \n",
       "244                     0.00    17.888889  10.777778 -3386.3753  \n",
       "246                     0.00    17.888889  10.777778 -3386.3753  \n",
       "248                     0.00    17.777778  10.722222 -3386.3753  \n",
       "250                     0.00    17.777778  10.722222 -3386.3753  \n",
       "252                     0.00    17.722222  10.777778 -3386.3753  \n",
       "254                     0.00    17.611111  10.722222 -3386.3753  \n",
       "256                     0.00    17.388889  10.777778 -3386.3753  \n",
       "258                     0.00    17.277778  10.722222 -3386.3753  \n",
       "260                     0.00    17.111111  10.722222 -3386.3753  \n",
       "262                     0.00    17.000000  10.611111 -3386.3753  \n",
       "264                     0.00    17.000000  10.222222 -3386.3753  \n",
       "266                     0.00    17.000000   9.722222 -3386.3753  \n",
       "268                     0.00    17.111111   9.777778 -3386.3753  \n",
       "\n",
       "[135 rows x 12 columns]"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ws_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "  <div class=\"bk-root\" id=\"c4432f44-4910-46e7-bfe5-048a6b24c26e\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "(function(root) {\n",
       "  function embed_document(root) {\n",
       "    \n",
       "  var docs_json = {\"68226ee9-1c61-4940-83f8-65d99306c733\":{\"roots\":{\"references\":[{\"attributes\":{\"callback\":null},\"id\":\"ce3be6c2-fe59-429c-8d89-a978ec6e7fc5\",\"type\":\"DataRange1d\"},{\"attributes\":{\"days\":[1,15]},\"id\":\"7d5c8053-cc41-4eb8-a9ca-479a7b794c8f\",\"type\":\"DaysTicker\"},{\"attributes\":{\"num_minor_ticks\":5,\"tickers\":[{\"id\":\"d4860eb9-1f15-4b74-8162-47592613edf4\",\"type\":\"AdaptiveTicker\"},{\"id\":\"a7da3b09-c761-47ad-90b2-b5e5b802d29e\",\"type\":\"AdaptiveTicker\"},{\"id\":\"f4c50ec9-5cee-4491-8529-ee792b34d9a6\",\"type\":\"AdaptiveTicker\"},{\"id\":\"402cdc49-3c7f-4ae4-99d7-f4693ce55818\",\"type\":\"DaysTicker\"},{\"id\":\"1f674a6c-25ba-483f-bb07-aacbe5e2fca2\",\"type\":\"DaysTicker\"},{\"id\":\"c4bbb9f4-28d6-4d06-bf70-8d1625a8995b\",\"type\":\"DaysTicker\"},{\"id\":\"7d5c8053-cc41-4eb8-a9ca-479a7b794c8f\",\"type\":\"DaysTicker\"},{\"id\":\"fb2cbc84-3fc2-4ccc-8ff0-1c68f7a46fa4\",\"type\":\"MonthsTicker\"},{\"id\":\"38aa699c-612f-4b5d-b61f-de7ae29a0e6a\",\"type\":\"MonthsTicker\"},{\"id\":\"6d497a95-5324-46c8-b749-c8b3c9cb336b\",\"type\":\"MonthsTicker\"},{\"id\":\"ec20da02-f138-4c74-8ea5-7bd5bd1d45f5\",\"type\":\"MonthsTicker\"},{\"id\":\"e6693982-f78b-485b-a4db-70c588d37366\",\"type\":\"YearsTicker\"}]},\"id\":\"8e3e1cba-217a-48f0-8e39-d6910a0a3c12\",\"type\":\"DatetimeTicker\"},{\"attributes\":{\"bottom_units\":\"screen\",\"fill_alpha\":{\"value\":0.5},\"fill_color\":{\"value\":\"lightgrey\"},\"left_units\":\"screen\",\"level\":\"overlay\",\"line_alpha\":{\"value\":1.0},\"line_color\":{\"value\":\"black\"},\"line_dash\":[4,4],\"line_width\":{\"value\":2},\"plot\":null,\"render_mode\":\"css\",\"right_units\":\"screen\",\"top_units\":\"screen\"},\"id\":\"451a2dbe-1c10-4b8c-a7a4-754a668d8ec9\",\"type\":\"BoxAnnotation\"},{\"attributes\":{\"days\":[1,4,7,10,13,16,19,22,25,28]},\"id\":\"1f674a6c-25ba-483f-bb07-aacbe5e2fca2\",\"type\":\"DaysTicker\"},{\"attributes\":{},\"id\":\"c5fbe2cc-cb3b-4a26-bc28-fa019c713231\",\"type\":\"WheelZoomTool\"},{\"attributes\":{\"months\":[0,4,8]},\"id\":\"6d497a95-5324-46c8-b749-c8b3c9cb336b\",\"type\":\"MonthsTicker\"},{\"attributes\":{},\"id\":\"fa9fc752-eacc-42aa-b78a-3bf057341686\",\"type\":\"DatetimeTickFormatter\"},{\"attributes\":{},\"id\":\"f98d9f43-a47a-491a-ad0d-19a13bbc7fca\",\"type\":\"Selection\"},{\"attributes\":{\"days\":[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]},\"id\":\"402cdc49-3c7f-4ae4-99d7-f4693ce55818\",\"type\":\"DaysTicker\"},{\"attributes\":{},\"id\":\"8a2e25fb-867d-454f-8b01-608135e09b8e\",\"type\":\"SaveTool\"},{\"attributes\":{\"callback\":null,\"renderers\":\"auto\",\"tooltips\":[[\"Time\",\"$x\"],[\"Temp\",\"$y\"]]},\"id\":\"9c57e257-43bf-49c3-bb49-2eeeb0539b74\",\"type\":\"HoverTool\"},{\"attributes\":{\"line_alpha\":0.1,\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"x\"},\"y\":{\"field\":\"y\"}},\"id\":\"895f78b0-e785-43c9-b488-33f2b184ecab\",\"type\":\"Line\"},{\"attributes\":{},\"id\":\"75bb7c66-e842-4ce8-b37e-b7c3c65aff69\",\"type\":\"UnionRenderers\"},{\"attributes\":{\"axis_label\":\"Temperature\",\"formatter\":{\"id\":\"eff7d4bc-0722-4835-b58f-32f63e573a4e\",\"type\":\"BasicTickFormatter\"},\"plot\":{\"id\":\"7fce021b-701a-4f16-9dd3-11412053651f\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"c0bd1d3f-5fc2-4f7c-a5e3-15da5687600c\",\"type\":\"BasicTicker\"}},\"id\":\"14ef8822-d6dc-4406-90d8-4f33db26dc6b\",\"type\":\"LinearAxis\"},{\"attributes\":{},\"id\":\"eff7d4bc-0722-4835-b58f-32f63e573a4e\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"cfb83a46-6662-429a-bc48-04b8a546547d\",\"type\":\"ResetTool\"},{\"attributes\":{\"below\":[{\"id\":\"daf94aa0-0857-4b93-bcca-5b7e3652efab\",\"type\":\"DatetimeAxis\"}],\"left\":[{\"id\":\"14ef8822-d6dc-4406-90d8-4f33db26dc6b\",\"type\":\"LinearAxis\"}],\"plot_height\":480,\"plot_width\":960,\"renderers\":[{\"id\":\"daf94aa0-0857-4b93-bcca-5b7e3652efab\",\"type\":\"DatetimeAxis\"},{\"id\":\"fefc6de1-f7fb-4ad1-abf4-6b6fbf7ea85a\",\"type\":\"Grid\"},{\"id\":\"14ef8822-d6dc-4406-90d8-4f33db26dc6b\",\"type\":\"LinearAxis\"},{\"id\":\"d8b121d4-7bcb-4c78-b2a7-cf4caec47cfb\",\"type\":\"Grid\"},{\"id\":\"451a2dbe-1c10-4b8c-a7a4-754a668d8ec9\",\"type\":\"BoxAnnotation\"},{\"id\":\"dc6ff51a-bfe3-4812-89a3-820ed6da2e11\",\"type\":\"GlyphRenderer\"}],\"title\":{\"id\":\"94360d73-0261-49e1-b18d-b9b72074b399\",\"type\":\"Title\"},\"toolbar\":{\"id\":\"f54ea786-682c-43aa-9489-eeb867ceaa29\",\"type\":\"Toolbar\"},\"x_range\":{\"id\":\"a3116f66-6412-432d-b07d-61a9a5817b26\",\"type\":\"DataRange1d\"},\"x_scale\":{\"id\":\"47108de1-c7e4-467e-9387-0b5083193aa6\",\"type\":\"LinearScale\"},\"y_range\":{\"id\":\"ce3be6c2-fe59-429c-8d89-a978ec6e7fc5\",\"type\":\"DataRange1d\"},\"y_scale\":{\"id\":\"956e41d7-7920-4f27-933b-9ace0c36e230\",\"type\":\"LinearScale\"}},\"id\":\"7fce021b-701a-4f16-9dd3-11412053651f\",\"subtype\":\"Figure\",\"type\":\"Plot\"},{\"attributes\":{},\"id\":\"a87cdd6d-790f-4a1c-86f1-3bdd1ea97743\",\"type\":\"PanTool\"},{\"attributes\":{},\"id\":\"47108de1-c7e4-467e-9387-0b5083193aa6\",\"type\":\"LinearScale\"},{\"attributes\":{\"active_drag\":\"auto\",\"active_inspect\":\"auto\",\"active_multi\":null,\"active_scroll\":\"auto\",\"active_tap\":\"auto\",\"tools\":[{\"id\":\"a87cdd6d-790f-4a1c-86f1-3bdd1ea97743\",\"type\":\"PanTool\"},{\"id\":\"c5fbe2cc-cb3b-4a26-bc28-fa019c713231\",\"type\":\"WheelZoomTool\"},{\"id\":\"16c25854-e7ab-4065-afe9-fc2efb74a15b\",\"type\":\"BoxZoomTool\"},{\"id\":\"8a2e25fb-867d-454f-8b01-608135e09b8e\",\"type\":\"SaveTool\"},{\"id\":\"cfb83a46-6662-429a-bc48-04b8a546547d\",\"type\":\"ResetTool\"},{\"id\":\"258dd0f2-5168-4b90-a1ae-2647d71682d0\",\"type\":\"HelpTool\"},{\"id\":\"9c57e257-43bf-49c3-bb49-2eeeb0539b74\",\"type\":\"HoverTool\"}]},\"id\":\"f54ea786-682c-43aa-9489-eeb867ceaa29\",\"type\":\"Toolbar\"},{\"attributes\":{},\"id\":\"956e41d7-7920-4f27-933b-9ace0c36e230\",\"type\":\"LinearScale\"},{\"attributes\":{\"plot\":null,\"text\":\"Etcheverry Rooftop Temperature\"},\"id\":\"94360d73-0261-49e1-b18d-b9b72074b399\",\"type\":\"Title\"},{\"attributes\":{\"days\":[1,8,15,22]},\"id\":\"c4bbb9f4-28d6-4d06-bf70-8d1625a8995b\",\"type\":\"DaysTicker\"},{\"attributes\":{\"base\":24,\"mantissas\":[1,2,4,6,8,12],\"max_interval\":43200000.0,\"min_interval\":3600000.0,\"num_minor_ticks\":0},\"id\":\"f4c50ec9-5cee-4491-8529-ee792b34d9a6\",\"type\":\"AdaptiveTicker\"},{\"attributes\":{\"source\":{\"id\":\"3f886a22-7078-4d14-82dc-1a748f3b9c00\",\"type\":\"ColumnDataSource\"}},\"id\":\"6c1646a3-7020-4586-9af7-254bc11c2be0\",\"type\":\"CDSView\"},{\"attributes\":{\"months\":[0,1,2,3,4,5,6,7,8,9,10,11]},\"id\":\"fb2cbc84-3fc2-4ccc-8ff0-1c68f7a46fa4\",\"type\":\"MonthsTicker\"},{\"attributes\":{\"data_source\":{\"id\":\"3f886a22-7078-4d14-82dc-1a748f3b9c00\",\"type\":\"ColumnDataSource\"},\"glyph\":{\"id\":\"eb33b41c-0e4c-4c85-a0a6-bf601df9f08b\",\"type\":\"Line\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"895f78b0-e785-43c9-b488-33f2b184ecab\",\"type\":\"Line\"},\"selection_glyph\":null,\"view\":{\"id\":\"6c1646a3-7020-4586-9af7-254bc11c2be0\",\"type\":\"CDSView\"}},\"id\":\"dc6ff51a-bfe3-4812-89a3-820ed6da2e11\",\"type\":\"GlyphRenderer\"},{\"attributes\":{\"callback\":null,\"data\":{\"x\":[1541076572000.0,1541076876000.0,1541077196000.0,1541077484000.0,1541077788000.0,1541078092000.0,1541078396000.0,1541078684000.0,1541078972000.0,1541079276000.0,1541079596000.0,1541079868000.0,1541080156000.0,1541080492000.0,1541080780000.0,1541081084000.0,1541081388000.0,1541081692000.0,1541081996000.0,1541082252000.0,1541082588000.0,1541082892000.0,1541083196000.0,1541083468000.0,1541083788000.0,1541084092000.0,1541084396000.0,1541084684000.0,1541084972000.0,1541085276000.0,1541085564000.0,1541085884000.0,1541086172000.0,1541086492000.0,1541086796000.0,1541087068000.0,1541087356000.0,1541087692000.0,1541087980000.0,1541088268000.0,1541088588000.0,1541088892000.0,1541089196000.0,1541089484000.0,1541089788000.0,1541090092000.0,1541090396000.0,1541090668000.0,1541090988000.0,1541091292000.0,1541091580000.0,1541091884000.0,1541092188000.0,1541092492000.0,1541092780000.0,1541093084000.0,1541093372000.0,1541093692000.0,1541093980000.0,1541094284000.0,1541094588000.0,1541094892000.0,1541095196000.0,1541095484000.0,1541095756000.0,1541096092000.0,1541096396000.0,1541096684000.0,1541096988000.0,1541097244000.0,1541097596000.0,1541097884000.0,1541098188000.0,1541098492000.0,1541098796000.0,1541099084000.0,1541099388000.0,1541099692000.0,1541099996000.0,1541100284000.0,1541100588000.0,1541100892000.0,1541101196000.0,1541101484000.0,1541101756000.0,1541102076000.0,1541102396000.0,1541102684000.0,1541102988000.0,1541103292000.0,1541103580000.0,1541103852000.0,1541104188000.0,1541104476000.0,1541104780000.0,1541105084000.0,1541105356000.0,1541105692000.0,1541105996000.0,1541106285000.0,1541106589000.0,1541106893000.0,1541107197000.0,1541107485000.0,1541107789000.0,1541108077000.0,1541108397000.0,1541108685000.0,1541108989000.0,1541109293000.0,1541109581000.0,1541109885000.0,1541110189000.0,1541110445000.0,1541110797000.0,1541111085000.0,1541111389000.0,1541111677000.0,1541111981000.0,1541112285000.0,1541112589000.0,1541112893000.0,1541113197000.0,1541113485000.0,1541113789000.0,1541114077000.0,1541114397000.0,1541114685000.0,1541114989000.0,1541115261000.0,1541115597000.0,1541115869000.0,1541116157000.0,1541116493000.0,1541116797000.0],\"y\":{\"__ndarray__\":\"OY7jOI5jNkAAAAAAAIA2QAEAAAAAADdAAAAAAACAN0DIcRzHcRw4QMdxHMdxnDhAchzHcRxHOUAAAAAAAAA6QAEAAAAAgDpA////////OkDIcRzHcZw7QAEAAAAAADxAcxzHcRxHPEAAAAAAAIA8QAAAAAAAgDxAAAAAAACAPEDHcRzHcZw8QMdxHMdxnDxAchzHcRzHPEA5juM4juM8QAEAAAAAAD1AyHEcx3EcPUDIcRzHcRw9QI7jOI7jOD1AjuM4juM4PUBzHMdxHEc9QDqO4ziOYz1AcxzHcRxHPUCO4ziO4zg9QAEAAAAAAD1AOY7jOI7jPEDHcRzHcZw8QDiO4ziOYzxAcxzHcRxHPEDHcRzHcRw8QDqO4ziO4ztAyHEcx3GcO0BxHMdxHEc7QP///////zpAcxzHcRzHOkDIcRzHcZw6QMhxHMdxnDpAAQAAAACAOkA5juM4jmM6QDmO4ziOYzpAchzHcRxHOkDHcRzHcRw6QDiO4ziO4zlAjuM4juO4OUABAAAAAIA5QHIcx3EcRzlAyHEcx3EcOUAAAAAAAAA5QDmO4ziO4zhAcRzHcRzHOEBxHMdxHMc4QI/jOI7juDhA//////9/OEA6juM4jmM4QI7jOI7jODhAAQAAAAAAOEByHMdxHMc3QMdxHMdxnDdAOI7jOI5jN0CO4ziO4zg3QDqO4ziO4zZAchzHcRzHNkDIcRzHcZw2QDmO4ziOYzZAcRzHcRxHNkDHcRzHcRw2QP///////zVAOo7jOI7jNUByHMdxHMc1QI7jOI7juDVAyHEcx3GcNUABAAAAAIA1QHIcx3EcRzVAj+M4juM4NUAAAAAAAAA1QDiO4ziO4zRAjuM4juO4NEABAAAAAIA0QHIcx3EcRzRAyHEcx3EcNEA5juM4juMzQDmO4ziO4zNAyHEcx3EcNEByHMdxHEc0QDqO4ziOYzRAOo7jOI5jNEByHMdxHEc0QDmO4ziO4zNA//////9/M0DIcRzHcRwzQI/jOI7juDJAAAAAAACAMkBzHMdxHEcyQI7jOI7jODJAxnEcx3EcMkABAAAAAAAyQDqO4ziO4zFAchzHcRzHMUCO4ziO47gxQHIcx3EcxzFAchzHcRzHMUA6juM4juMxQDqO4ziO4zFAAQAAAAAAMkABAAAAAAAyQDqO4ziO4zFAOo7jOI7jMUABAAAAAAAyQAEAAAAAADJAxnEcx3EcMkCO4ziO4zgyQDiO4ziOYzJAOI7jOI5jMkBzHMdxHEcyQI7jOI7jODJAxnEcx3EcMkABAAAAAAAyQDqO4ziO4zFAOo7jOI7jMUByHMdxHMcxQHIcx3EcxzFAjuM4juO4MUDIcRzHcZwxQDmO4ziOYzFAchzHcRxHMUDHcRzHcRwxQAAAAAAAADFAAAAAAAAAMUAAAAAAAAAxQMdxHMdxHDFA\",\"dtype\":\"float64\",\"shape\":[135]}},\"selected\":{\"id\":\"f98d9f43-a47a-491a-ad0d-19a13bbc7fca\",\"type\":\"Selection\"},\"selection_policy\":{\"id\":\"75bb7c66-e842-4ce8-b37e-b7c3c65aff69\",\"type\":\"UnionRenderers\"}},\"id\":\"3f886a22-7078-4d14-82dc-1a748f3b9c00\",\"type\":\"ColumnDataSource\"},{\"attributes\":{\"plot\":{\"id\":\"7fce021b-701a-4f16-9dd3-11412053651f\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"8e3e1cba-217a-48f0-8e39-d6910a0a3c12\",\"type\":\"DatetimeTicker\"}},\"id\":\"fefc6de1-f7fb-4ad1-abf4-6b6fbf7ea85a\",\"type\":\"Grid\"},{\"attributes\":{\"base\":60,\"mantissas\":[1,2,5,10,15,20,30],\"max_interval\":1800000.0,\"min_interval\":1000.0,\"num_minor_ticks\":0},\"id\":\"a7da3b09-c761-47ad-90b2-b5e5b802d29e\",\"type\":\"AdaptiveTicker\"},{\"attributes\":{\"mantissas\":[1,2,5],\"max_interval\":500.0,\"num_minor_ticks\":0},\"id\":\"d4860eb9-1f15-4b74-8162-47592613edf4\",\"type\":\"AdaptiveTicker\"},{\"attributes\":{\"overlay\":{\"id\":\"451a2dbe-1c10-4b8c-a7a4-754a668d8ec9\",\"type\":\"BoxAnnotation\"}},\"id\":\"16c25854-e7ab-4065-afe9-fc2efb74a15b\",\"type\":\"BoxZoomTool\"},{\"attributes\":{\"axis_label\":\"Time\",\"formatter\":{\"id\":\"fa9fc752-eacc-42aa-b78a-3bf057341686\",\"type\":\"DatetimeTickFormatter\"},\"plot\":{\"id\":\"7fce021b-701a-4f16-9dd3-11412053651f\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"8e3e1cba-217a-48f0-8e39-d6910a0a3c12\",\"type\":\"DatetimeTicker\"}},\"id\":\"daf94aa0-0857-4b93-bcca-5b7e3652efab\",\"type\":\"DatetimeAxis\"},{\"attributes\":{\"dimension\":1,\"plot\":{\"id\":\"7fce021b-701a-4f16-9dd3-11412053651f\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"c0bd1d3f-5fc2-4f7c-a5e3-15da5687600c\",\"type\":\"BasicTicker\"}},\"id\":\"d8b121d4-7bcb-4c78-b2a7-cf4caec47cfb\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"e6693982-f78b-485b-a4db-70c588d37366\",\"type\":\"YearsTicker\"},{\"attributes\":{\"months\":[0,6]},\"id\":\"ec20da02-f138-4c74-8ea5-7bd5bd1d45f5\",\"type\":\"MonthsTicker\"},{\"attributes\":{},\"id\":\"c0bd1d3f-5fc2-4f7c-a5e3-15da5687600c\",\"type\":\"BasicTicker\"},{\"attributes\":{\"months\":[0,2,4,6,8,10]},\"id\":\"38aa699c-612f-4b5d-b61f-de7ae29a0e6a\",\"type\":\"MonthsTicker\"},{\"attributes\":{},\"id\":\"258dd0f2-5168-4b90-a1ae-2647d71682d0\",\"type\":\"HelpTool\"},{\"attributes\":{\"callback\":null},\"id\":\"a3116f66-6412-432d-b07d-61a9a5817b26\",\"type\":\"DataRange1d\"},{\"attributes\":{\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"x\"},\"y\":{\"field\":\"y\"}},\"id\":\"eb33b41c-0e4c-4c85-a0a6-bf601df9f08b\",\"type\":\"Line\"}],\"root_ids\":[\"7fce021b-701a-4f16-9dd3-11412053651f\"]},\"title\":\"Bokeh Application\",\"version\":\"0.13.0\"}};\n",
       "  var render_items = [{\"docid\":\"68226ee9-1c61-4940-83f8-65d99306c733\",\"roots\":{\"7fce021b-701a-4f16-9dd3-11412053651f\":\"c4432f44-4910-46e7-bfe5-048a6b24c26e\"}}];\n",
       "  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n",
       "\n",
       "  }\n",
       "  if (root.Bokeh !== undefined) {\n",
       "    embed_document(root);\n",
       "  } else {\n",
       "    var attempts = 0;\n",
       "    var timer = setInterval(function(root) {\n",
       "      if (root.Bokeh !== undefined) {\n",
       "        embed_document(root);\n",
       "        clearInterval(timer);\n",
       "      }\n",
       "      attempts++;\n",
       "      if (attempts > 100) {\n",
       "        console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\")\n",
       "        clearInterval(timer);\n",
       "      }\n",
       "    }, 10, root)\n",
       "  }\n",
       "})(window);"
      ],
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "7fce021b-701a-4f16-9dd3-11412053651f"
      }
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "p = figure(plot_width=960, plot_height=480, title='Etcheverry Rooftop Temperature', x_axis_type='datetime')\n",
    "\n",
    "p.line(ws_data['Time'], ws_data['Temperature'], line_width=2)\n",
    "p.add_tools(HoverTool(tooltips=[('Time', '$x'), ('Temp', '$y')]))\n",
    "\n",
    "p.xaxis.axis_label = 'Time'\n",
    "p.yaxis.axis_label = 'Temperature'\n",
    "\n",
    "show(p)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.15"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}