TuesdayAfterJospehus.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "flush-rebecca",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "table deleted\n"
     ]
    },
    {
     "data": {
      "application/javascript": [
       "/* Put everything inside the global mpl namespace */\n",
       "/* global mpl */\n",
       "window.mpl = {};\n",
       "\n",
       "mpl.get_websocket_type = function () {\n",
       "    if (typeof WebSocket !== 'undefined') {\n",
       "        return WebSocket;\n",
       "    } else if (typeof MozWebSocket !== 'undefined') {\n",
       "        return MozWebSocket;\n",
       "    } else {\n",
       "        alert(\n",
       "            'Your browser does not have WebSocket support. ' +\n",
       "                'Please try Chrome, Safari or Firefox ≥ 6. ' +\n",
       "                'Firefox 4 and 5 are also supported but you ' +\n",
       "                'have to enable WebSockets in about:config.'\n",
       "        );\n",
       "    }\n",
       "};\n",
       "\n",
       "mpl.figure = function (figure_id, websocket, ondownload, parent_element) {\n",
       "    this.id = figure_id;\n",
       "\n",
       "    this.ws = websocket;\n",
       "\n",
       "    this.supports_binary = this.ws.binaryType !== undefined;\n",
       "\n",
       "    if (!this.supports_binary) {\n",
       "        var warnings = document.getElementById('mpl-warnings');\n",
       "        if (warnings) {\n",
       "            warnings.style.display = 'block';\n",
       "            warnings.textContent =\n",
       "                'This browser does not support binary websocket messages. ' +\n",
       "                'Performance may be slow.';\n",
       "        }\n",
       "    }\n",
       "\n",
       "    this.imageObj = new Image();\n",
       "\n",
       "    this.context = undefined;\n",
       "    this.message = undefined;\n",
       "    this.canvas = undefined;\n",
       "    this.rubberband_canvas = undefined;\n",
       "    this.rubberband_context = undefined;\n",
       "    this.format_dropdown = undefined;\n",
       "\n",
       "    this.image_mode = 'full';\n",
       "\n",
       "    this.root = document.createElement('div');\n",
       "    this.root.setAttribute('style', 'display: inline-block');\n",
       "    this._root_extra_style(this.root);\n",
       "\n",
       "    parent_element.appendChild(this.root);\n",
       "\n",
       "    this._init_header(this);\n",
       "    this._init_canvas(this);\n",
       "    this._init_toolbar(this);\n",
       "\n",
       "    var fig = this;\n",
       "\n",
       "    this.waiting = false;\n",
       "\n",
       "    this.ws.onopen = function () {\n",
       "        fig.send_message('supports_binary', { value: fig.supports_binary });\n",
       "        fig.send_message('send_image_mode', {});\n",
       "        if (fig.ratio !== 1) {\n",
       "            fig.send_message('set_dpi_ratio', { dpi_ratio: fig.ratio });\n",
       "        }\n",
       "        fig.send_message('refresh', {});\n",
       "    };\n",
       "\n",
       "    this.imageObj.onload = function () {\n",
       "        if (fig.image_mode === 'full') {\n",
       "            // Full images could contain transparency (where diff images\n",
       "            // almost always do), so we need to clear the canvas so that\n",
       "            // there is no ghosting.\n",
       "            fig.context.clearRect(0, 0, fig.canvas.width, fig.canvas.height);\n",
       "        }\n",
       "        fig.context.drawImage(fig.imageObj, 0, 0);\n",
       "    };\n",
       "\n",
       "    this.imageObj.onunload = function () {\n",
       "        fig.ws.close();\n",
       "    };\n",
       "\n",
       "    this.ws.onmessage = this._make_on_message_function(this);\n",
       "\n",
       "    this.ondownload = ondownload;\n",
       "};\n",
       "\n",
       "mpl.figure.prototype._init_header = function () {\n",
       "    var titlebar = document.createElement('div');\n",
       "    titlebar.classList =\n",
       "        'ui-dialog-titlebar ui-widget-header ui-corner-all ui-helper-clearfix';\n",
       "    var titletext = document.createElement('div');\n",
       "    titletext.classList = 'ui-dialog-title';\n",
       "    titletext.setAttribute(\n",
       "        'style',\n",
       "        'width: 100%; text-align: center; padding: 3px;'\n",
       "    );\n",
       "    titlebar.appendChild(titletext);\n",
       "    this.root.appendChild(titlebar);\n",
       "    this.header = titletext;\n",
       "};\n",
       "\n",
       "mpl.figure.prototype._canvas_extra_style = function (_canvas_div) {};\n",
       "\n",
       "mpl.figure.prototype._root_extra_style = function (_canvas_div) {};\n",
       "\n",
       "mpl.figure.prototype._init_canvas = function () {\n",
       "    var fig = this;\n",
       "\n",
       "    var canvas_div = (this.canvas_div = document.createElement('div'));\n",
       "    canvas_div.setAttribute(\n",
       "        'style',\n",
       "        'border: 1px solid #ddd;' +\n",
       "            'box-sizing: content-box;' +\n",
       "            'clear: both;' +\n",
       "            'min-height: 1px;' +\n",
       "            'min-width: 1px;' +\n",
       "            'outline: 0;' +\n",
       "            'overflow: hidden;' +\n",
       "            'position: relative;' +\n",
       "            'resize: both;'\n",
       "    );\n",
       "\n",
       "    function on_keyboard_event_closure(name) {\n",
       "        return function (event) {\n",
       "            return fig.key_event(event, name);\n",
       "        };\n",
       "    }\n",
       "\n",
       "    canvas_div.addEventListener(\n",
       "        'keydown',\n",
       "        on_keyboard_event_closure('key_press')\n",
       "    );\n",
       "    canvas_div.addEventListener(\n",
       "        'keyup',\n",
       "        on_keyboard_event_closure('key_release')\n",
       "    );\n",
       "\n",
       "    this._canvas_extra_style(canvas_div);\n",
       "    this.root.appendChild(canvas_div);\n",
       "\n",
       "    var canvas = (this.canvas = document.createElement('canvas'));\n",
       "    canvas.classList.add('mpl-canvas');\n",
       "    canvas.setAttribute('style', 'box-sizing: content-box;');\n",
       "\n",
       "    this.context = canvas.getContext('2d');\n",
       "\n",
       "    var backingStore =\n",
       "        this.context.backingStorePixelRatio ||\n",
       "        this.context.webkitBackingStorePixelRatio ||\n",
       "        this.context.mozBackingStorePixelRatio ||\n",
       "        this.context.msBackingStorePixelRatio ||\n",
       "        this.context.oBackingStorePixelRatio ||\n",
       "        this.context.backingStorePixelRatio ||\n",
       "        1;\n",
       "\n",
       "    this.ratio = (window.devicePixelRatio || 1) / backingStore;\n",
       "    if (this.ratio !== 1) {\n",
       "        fig.send_message('set_dpi_ratio', { dpi_ratio: this.ratio });\n",
       "    }\n",
       "\n",
       "    var rubberband_canvas = (this.rubberband_canvas = document.createElement(\n",
       "        'canvas'\n",
       "    ));\n",
       "    rubberband_canvas.setAttribute(\n",
       "        'style',\n",
       "        'box-sizing: content-box; position: absolute; left: 0; top: 0; z-index: 1;'\n",
       "    );\n",
       "\n",
       "    // Apply a ponyfill if ResizeObserver is not implemented by browser.\n",
       "    if (this.ResizeObserver === undefined) {\n",
       "        if (window.ResizeObserver !== undefined) {\n",
       "            this.ResizeObserver = window.ResizeObserver;\n",
       "        } else {\n",
       "            var obs = _JSXTOOLS_RESIZE_OBSERVER({});\n",
       "            this.ResizeObserver = obs.ResizeObserver;\n",
       "        }\n",
       "    }\n",
       "\n",
       "    this.resizeObserverInstance = new this.ResizeObserver(function (entries) {\n",
       "        var nentries = entries.length;\n",
       "        for (var i = 0; i < nentries; i++) {\n",
       "            var entry = entries[i];\n",
       "            var width, height;\n",
       "            if (entry.contentBoxSize) {\n",
       "                if (entry.contentBoxSize instanceof Array) {\n",
       "                    // Chrome 84 implements new version of spec.\n",
       "                    width = entry.contentBoxSize[0].inlineSize;\n",
       "                    height = entry.contentBoxSize[0].blockSize;\n",
       "                } else {\n",
       "                    // Firefox implements old version of spec.\n",
       "                    width = entry.contentBoxSize.inlineSize;\n",
       "                    height = entry.contentBoxSize.blockSize;\n",
       "                }\n",
       "            } else {\n",
       "                // Chrome <84 implements even older version of spec.\n",
       "                width = entry.contentRect.width;\n",
       "                height = entry.contentRect.height;\n",
       "            }\n",
       "\n",
       "            // Keep the size of the canvas and rubber band canvas in sync with\n",
       "            // the canvas container.\n",
       "            if (entry.devicePixelContentBoxSize) {\n",
       "                // Chrome 84 implements new version of spec.\n",
       "                canvas.setAttribute(\n",
       "                    'width',\n",
       "                    entry.devicePixelContentBoxSize[0].inlineSize\n",
       "                );\n",
       "                canvas.setAttribute(\n",
       "                    'height',\n",
       "                    entry.devicePixelContentBoxSize[0].blockSize\n",
       "                );\n",
       "            } else {\n",
       "                canvas.setAttribute('width', width * fig.ratio);\n",
       "                canvas.setAttribute('height', height * fig.ratio);\n",
       "            }\n",
       "            canvas.setAttribute(\n",
       "                'style',\n",
       "                'width: ' + width + 'px; height: ' + height + 'px;'\n",
       "            );\n",
       "\n",
       "            rubberband_canvas.setAttribute('width', width);\n",
       "            rubberband_canvas.setAttribute('height', height);\n",
       "\n",
       "            // And update the size in Python. We ignore the initial 0/0 size\n",
       "            // that occurs as the element is placed into the DOM, which should\n",
       "            // otherwise not happen due to the minimum size styling.\n",
       "            if (width != 0 && height != 0) {\n",
       "                fig.request_resize(width, height);\n",
       "            }\n",
       "        }\n",
       "    });\n",
       "    this.resizeObserverInstance.observe(canvas_div);\n",
       "\n",
       "    function on_mouse_event_closure(name) {\n",
       "        return function (event) {\n",
       "            return fig.mouse_event(event, name);\n",
       "        };\n",
       "    }\n",
       "\n",
       "    rubberband_canvas.addEventListener(\n",
       "        'mousedown',\n",
       "        on_mouse_event_closure('button_press')\n",
       "    );\n",
       "    rubberband_canvas.addEventListener(\n",
       "        'mouseup',\n",
       "        on_mouse_event_closure('button_release')\n",
       "    );\n",
       "    // Throttle sequential mouse events to 1 every 20ms.\n",
       "    rubberband_canvas.addEventListener(\n",
       "        'mousemove',\n",
       "        on_mouse_event_closure('motion_notify')\n",
       "    );\n",
       "\n",
       "    rubberband_canvas.addEventListener(\n",
       "        'mouseenter',\n",
       "        on_mouse_event_closure('figure_enter')\n",
       "    );\n",
       "    rubberband_canvas.addEventListener(\n",
       "        'mouseleave',\n",
       "        on_mouse_event_closure('figure_leave')\n",
       "    );\n",
       "\n",
       "    canvas_div.addEventListener('wheel', function (event) {\n",
       "        if (event.deltaY < 0) {\n",
       "            event.step = 1;\n",
       "        } else {\n",
       "            event.step = -1;\n",
       "        }\n",
       "        on_mouse_event_closure('scroll')(event);\n",
       "    });\n",
       "\n",
       "    canvas_div.appendChild(canvas);\n",
       "    canvas_div.appendChild(rubberband_canvas);\n",
       "\n",
       "    this.rubberband_context = rubberband_canvas.getContext('2d');\n",
       "    this.rubberband_context.strokeStyle = '#000000';\n",
       "\n",
       "    this._resize_canvas = function (width, height, forward) {\n",
       "        if (forward) {\n",
       "            canvas_div.style.width = width + 'px';\n",
       "            canvas_div.style.height = height + 'px';\n",
       "        }\n",
       "    };\n",
       "\n",
       "    // Disable right mouse context menu.\n",
       "    this.rubberband_canvas.addEventListener('contextmenu', function (_e) {\n",
       "        event.preventDefault();\n",
       "        return false;\n",
       "    });\n",
       "\n",
       "    function set_focus() {\n",
       "        canvas.focus();\n",
       "        canvas_div.focus();\n",
       "    }\n",
       "\n",
       "    window.setTimeout(set_focus, 100);\n",
       "};\n",
       "\n",
       "mpl.figure.prototype._init_toolbar = function () {\n",
       "    var fig = this;\n",
       "\n",
       "    var toolbar = document.createElement('div');\n",
       "    toolbar.classList = 'mpl-toolbar';\n",
       "    this.root.appendChild(toolbar);\n",
       "\n",
       "    function on_click_closure(name) {\n",
       "        return function (_event) {\n",
       "            return fig.toolbar_button_onclick(name);\n",
       "        };\n",
       "    }\n",
       "\n",
       "    function on_mouseover_closure(tooltip) {\n",
       "        return function (event) {\n",
       "            if (!event.currentTarget.disabled) {\n",
       "                return fig.toolbar_button_onmouseover(tooltip);\n",
       "            }\n",
       "        };\n",
       "    }\n",
       "\n",
       "    fig.buttons = {};\n",
       "    var buttonGroup = document.createElement('div');\n",
       "    buttonGroup.classList = 'mpl-button-group';\n",
       "    for (var toolbar_ind in mpl.toolbar_items) {\n",
       "        var name = mpl.toolbar_items[toolbar_ind][0];\n",
       "        var tooltip = mpl.toolbar_items[toolbar_ind][1];\n",
       "        var image = mpl.toolbar_items[toolbar_ind][2];\n",
       "        var method_name = mpl.toolbar_items[toolbar_ind][3];\n",
       "\n",
       "        if (!name) {\n",
       "            /* Instead of a spacer, we start a new button group. */\n",
       "            if (buttonGroup.hasChildNodes()) {\n",
       "                toolbar.appendChild(buttonGroup);\n",
       "            }\n",
       "            buttonGroup = document.createElement('div');\n",
       "            buttonGroup.classList = 'mpl-button-group';\n",
       "            continue;\n",
       "        }\n",
       "\n",
       "        var button = (fig.buttons[name] = document.createElement('button'));\n",
       "        button.classList = 'mpl-widget';\n",
       "        button.setAttribute('role', 'button');\n",
       "        button.setAttribute('aria-disabled', 'false');\n",
       "        button.addEventListener('click', on_click_closure(method_name));\n",
       "        button.addEventListener('mouseover', on_mouseover_closure(tooltip));\n",
       "\n",
       "        var icon_img = document.createElement('img');\n",
       "        icon_img.src = '_images/' + image + '.png';\n",
       "        icon_img.srcset = '_images/' + image + '_large.png 2x';\n",
       "        icon_img.alt = tooltip;\n",
       "        button.appendChild(icon_img);\n",
       "\n",
       "        buttonGroup.appendChild(button);\n",
       "    }\n",
       "\n",
       "    if (buttonGroup.hasChildNodes()) {\n",
       "        toolbar.appendChild(buttonGroup);\n",
       "    }\n",
       "\n",
       "    var fmt_picker = document.createElement('select');\n",
       "    fmt_picker.classList = 'mpl-widget';\n",
       "    toolbar.appendChild(fmt_picker);\n",
       "    this.format_dropdown = fmt_picker;\n",
       "\n",
       "    for (var ind in mpl.extensions) {\n",
       "        var fmt = mpl.extensions[ind];\n",
       "        var option = document.createElement('option');\n",
       "        option.selected = fmt === mpl.default_extension;\n",
       "        option.innerHTML = fmt;\n",
       "        fmt_picker.appendChild(option);\n",
       "    }\n",
       "\n",
       "    var status_bar = document.createElement('span');\n",
       "    status_bar.classList = 'mpl-message';\n",
       "    toolbar.appendChild(status_bar);\n",
       "    this.message = status_bar;\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.request_resize = function (x_pixels, y_pixels) {\n",
       "    // Request matplotlib to resize the figure. Matplotlib will then trigger a resize in the client,\n",
       "    // which will in turn request a refresh of the image.\n",
       "    this.send_message('resize', { width: x_pixels, height: y_pixels });\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.send_message = function (type, properties) {\n",
       "    properties['type'] = type;\n",
       "    properties['figure_id'] = this.id;\n",
       "    this.ws.send(JSON.stringify(properties));\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.send_draw_message = function () {\n",
       "    if (!this.waiting) {\n",
       "        this.waiting = true;\n",
       "        this.ws.send(JSON.stringify({ type: 'draw', figure_id: this.id }));\n",
       "    }\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_save = function (fig, _msg) {\n",
       "    var format_dropdown = fig.format_dropdown;\n",
       "    var format = format_dropdown.options[format_dropdown.selectedIndex].value;\n",
       "    fig.ondownload(fig, format);\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_resize = function (fig, msg) {\n",
       "    var size = msg['size'];\n",
       "    if (size[0] !== fig.canvas.width || size[1] !== fig.canvas.height) {\n",
       "        fig._resize_canvas(size[0], size[1], msg['forward']);\n",
       "        fig.send_message('refresh', {});\n",
       "    }\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_rubberband = function (fig, msg) {\n",
       "    var x0 = msg['x0'] / fig.ratio;\n",
       "    var y0 = (fig.canvas.height - msg['y0']) / fig.ratio;\n",
       "    var x1 = msg['x1'] / fig.ratio;\n",
       "    var y1 = (fig.canvas.height - msg['y1']) / fig.ratio;\n",
       "    x0 = Math.floor(x0) + 0.5;\n",
       "    y0 = Math.floor(y0) + 0.5;\n",
       "    x1 = Math.floor(x1) + 0.5;\n",
       "    y1 = Math.floor(y1) + 0.5;\n",
       "    var min_x = Math.min(x0, x1);\n",
       "    var min_y = Math.min(y0, y1);\n",
       "    var width = Math.abs(x1 - x0);\n",
       "    var height = Math.abs(y1 - y0);\n",
       "\n",
       "    fig.rubberband_context.clearRect(\n",
       "        0,\n",
       "        0,\n",
       "        fig.canvas.width / fig.ratio,\n",
       "        fig.canvas.height / fig.ratio\n",
       "    );\n",
       "\n",
       "    fig.rubberband_context.strokeRect(min_x, min_y, width, height);\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_figure_label = function (fig, msg) {\n",
       "    // Updates the figure title.\n",
       "    fig.header.textContent = msg['label'];\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_cursor = function (fig, msg) {\n",
       "    var cursor = msg['cursor'];\n",
       "    switch (cursor) {\n",
       "        case 0:\n",
       "            cursor = 'pointer';\n",
       "            break;\n",
       "        case 1:\n",
       "            cursor = 'default';\n",
       "            break;\n",
       "        case 2:\n",
       "            cursor = 'crosshair';\n",
       "            break;\n",
       "        case 3:\n",
       "            cursor = 'move';\n",
       "            break;\n",
       "    }\n",
       "    fig.rubberband_canvas.style.cursor = cursor;\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_message = function (fig, msg) {\n",
       "    fig.message.textContent = msg['message'];\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_draw = function (fig, _msg) {\n",
       "    // Request the server to send over a new figure.\n",
       "    fig.send_draw_message();\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_image_mode = function (fig, msg) {\n",
       "    fig.image_mode = msg['mode'];\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_history_buttons = function (fig, msg) {\n",
       "    for (var key in msg) {\n",
       "        if (!(key in fig.buttons)) {\n",
       "            continue;\n",
       "        }\n",
       "        fig.buttons[key].disabled = !msg[key];\n",
       "        fig.buttons[key].setAttribute('aria-disabled', !msg[key]);\n",
       "    }\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_navigate_mode = function (fig, msg) {\n",
       "    if (msg['mode'] === 'PAN') {\n",
       "        fig.buttons['Pan'].classList.add('active');\n",
       "        fig.buttons['Zoom'].classList.remove('active');\n",
       "    } else if (msg['mode'] === 'ZOOM') {\n",
       "        fig.buttons['Pan'].classList.remove('active');\n",
       "        fig.buttons['Zoom'].classList.add('active');\n",
       "    } else {\n",
       "        fig.buttons['Pan'].classList.remove('active');\n",
       "        fig.buttons['Zoom'].classList.remove('active');\n",
       "    }\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.updated_canvas_event = function () {\n",
       "    // Called whenever the canvas gets updated.\n",
       "    this.send_message('ack', {});\n",
       "};\n",
       "\n",
       "// A function to construct a web socket function for onmessage handling.\n",
       "// Called in the figure constructor.\n",
       "mpl.figure.prototype._make_on_message_function = function (fig) {\n",
       "    return function socket_on_message(evt) {\n",
       "        if (evt.data instanceof Blob) {\n",
       "            /* FIXME: We get \"Resource interpreted as Image but\n",
       "             * transferred with MIME type text/plain:\" errors on\n",
       "             * Chrome.  But how to set the MIME type?  It doesn't seem\n",
       "             * to be part of the websocket stream */\n",
       "            evt.data.type = 'image/png';\n",
       "\n",
       "            /* Free the memory for the previous frames */\n",
       "            if (fig.imageObj.src) {\n",
       "                (window.URL || window.webkitURL).revokeObjectURL(\n",
       "                    fig.imageObj.src\n",
       "                );\n",
       "            }\n",
       "\n",
       "            fig.imageObj.src = (window.URL || window.webkitURL).createObjectURL(\n",
       "                evt.data\n",
       "            );\n",
       "            fig.updated_canvas_event();\n",
       "            fig.waiting = false;\n",
       "            return;\n",
       "        } else if (\n",
       "            typeof evt.data === 'string' &&\n",
       "            evt.data.slice(0, 21) === 'data:image/png;base64'\n",
       "        ) {\n",
       "            fig.imageObj.src = evt.data;\n",
       "            fig.updated_canvas_event();\n",
       "            fig.waiting = false;\n",
       "            return;\n",
       "        }\n",
       "\n",
       "        var msg = JSON.parse(evt.data);\n",
       "        var msg_type = msg['type'];\n",
       "\n",
       "        // Call the  \"handle_{type}\" callback, which takes\n",
       "        // the figure and JSON message as its only arguments.\n",
       "        try {\n",
       "            var callback = fig['handle_' + msg_type];\n",
       "        } catch (e) {\n",
       "            console.log(\n",
       "                \"No handler for the '\" + msg_type + \"' message type: \",\n",
       "                msg\n",
       "            );\n",
       "            return;\n",
       "        }\n",
       "\n",
       "        if (callback) {\n",
       "            try {\n",
       "                // console.log(\"Handling '\" + msg_type + \"' message: \", msg);\n",
       "                callback(fig, msg);\n",
       "            } catch (e) {\n",
       "                console.log(\n",
       "                    \"Exception inside the 'handler_\" + msg_type + \"' callback:\",\n",
       "                    e,\n",
       "                    e.stack,\n",
       "                    msg\n",
       "                );\n",
       "            }\n",
       "        }\n",
       "    };\n",
       "};\n",
       "\n",
       "// from http://stackoverflow.com/questions/1114465/getting-mouse-location-in-canvas\n",
       "mpl.findpos = function (e) {\n",
       "    //this section is from http://www.quirksmode.org/js/events_properties.html\n",
       "    var targ;\n",
       "    if (!e) {\n",
       "        e = window.event;\n",
       "    }\n",
       "    if (e.target) {\n",
       "        targ = e.target;\n",
       "    } else if (e.srcElement) {\n",
       "        targ = e.srcElement;\n",
       "    }\n",
       "    if (targ.nodeType === 3) {\n",
       "        // defeat Safari bug\n",
       "        targ = targ.parentNode;\n",
       "    }\n",
       "\n",
       "    // pageX,Y are the mouse positions relative to the document\n",
       "    var boundingRect = targ.getBoundingClientRect();\n",
       "    var x = e.pageX - (boundingRect.left + document.body.scrollLeft);\n",
       "    var y = e.pageY - (boundingRect.top + document.body.scrollTop);\n",
       "\n",
       "    return { x: x, y: y };\n",
       "};\n",
       "\n",
       "/*\n",
       " * return a copy of an object with only non-object keys\n",
       " * we need this to avoid circular references\n",
       " * http://stackoverflow.com/a/24161582/3208463\n",
       " */\n",
       "function simpleKeys(original) {\n",
       "    return Object.keys(original).reduce(function (obj, key) {\n",
       "        if (typeof original[key] !== 'object') {\n",
       "            obj[key] = original[key];\n",
       "        }\n",
       "        return obj;\n",
       "    }, {});\n",
       "}\n",
       "\n",
       "mpl.figure.prototype.mouse_event = function (event, name) {\n",
       "    var canvas_pos = mpl.findpos(event);\n",
       "\n",
       "    if (name === 'button_press') {\n",
       "        this.canvas.focus();\n",
       "        this.canvas_div.focus();\n",
       "    }\n",
       "\n",
       "    var x = canvas_pos.x * this.ratio;\n",
       "    var y = canvas_pos.y * this.ratio;\n",
       "\n",
       "    this.send_message(name, {\n",
       "        x: x,\n",
       "        y: y,\n",
       "        button: event.button,\n",
       "        step: event.step,\n",
       "        guiEvent: simpleKeys(event),\n",
       "    });\n",
       "\n",
       "    /* This prevents the web browser from automatically changing to\n",
       "     * the text insertion cursor when the button is pressed.  We want\n",
       "     * to control all of the cursor setting manually through the\n",
       "     * 'cursor' event from matplotlib */\n",
       "    event.preventDefault();\n",
       "    return false;\n",
       "};\n",
       "\n",
       "mpl.figure.prototype._key_event_extra = function (_event, _name) {\n",
       "    // Handle any extra behaviour associated with a key event\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.key_event = function (event, name) {\n",
       "    // Prevent repeat events\n",
       "    if (name === 'key_press') {\n",
       "        if (event.which === this._key) {\n",
       "            return;\n",
       "        } else {\n",
       "            this._key = event.which;\n",
       "        }\n",
       "    }\n",
       "    if (name === 'key_release') {\n",
       "        this._key = null;\n",
       "    }\n",
       "\n",
       "    var value = '';\n",
       "    if (event.ctrlKey && event.which !== 17) {\n",
       "        value += 'ctrl+';\n",
       "    }\n",
       "    if (event.altKey && event.which !== 18) {\n",
       "        value += 'alt+';\n",
       "    }\n",
       "    if (event.shiftKey && event.which !== 16) {\n",
       "        value += 'shift+';\n",
       "    }\n",
       "\n",
       "    value += 'k';\n",
       "    value += event.which.toString();\n",
       "\n",
       "    this._key_event_extra(event, name);\n",
       "\n",
       "    this.send_message(name, { key: value, guiEvent: simpleKeys(event) });\n",
       "    return false;\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.toolbar_button_onclick = function (name) {\n",
       "    if (name === 'download') {\n",
       "        this.handle_save(this, null);\n",
       "    } else {\n",
       "        this.send_message('toolbar_button', { name: name });\n",
       "    }\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.toolbar_button_onmouseover = function (tooltip) {\n",
       "    this.message.textContent = tooltip;\n",
       "};\n",
       "\n",
       "///////////////// REMAINING CONTENT GENERATED BY embed_js.py /////////////////\n",
       "// prettier-ignore\n",
       "var _JSXTOOLS_RESIZE_OBSERVER=function(A){var t,i=new WeakMap,n=new WeakMap,a=new WeakMap,r=new WeakMap,o=new Set;function s(e){if(!(this instanceof s))throw new TypeError(\"Constructor requires 'new' operator\");i.set(this,e)}function h(){throw new TypeError(\"Function is not a constructor\")}function c(e,t,i,n){e=0 in arguments?Number(arguments[0]):0,t=1 in arguments?Number(arguments[1]):0,i=2 in arguments?Number(arguments[2]):0,n=3 in arguments?Number(arguments[3]):0,this.right=(this.x=this.left=e)+(this.width=i),this.bottom=(this.y=this.top=t)+(this.height=n),Object.freeze(this)}function d(){t=requestAnimationFrame(d);var s=new WeakMap,p=new Set;o.forEach((function(t){r.get(t).forEach((function(i){var r=t instanceof window.SVGElement,o=a.get(t),d=r?0:parseFloat(o.paddingTop),f=r?0:parseFloat(o.paddingRight),l=r?0:parseFloat(o.paddingBottom),u=r?0:parseFloat(o.paddingLeft),g=r?0:parseFloat(o.borderTopWidth),m=r?0:parseFloat(o.borderRightWidth),w=r?0:parseFloat(o.borderBottomWidth),b=u+f,F=d+l,v=(r?0:parseFloat(o.borderLeftWidth))+m,W=g+w,y=r?0:t.offsetHeight-W-t.clientHeight,E=r?0:t.offsetWidth-v-t.clientWidth,R=b+v,z=F+W,M=r?t.width:parseFloat(o.width)-R-E,O=r?t.height:parseFloat(o.height)-z-y;if(n.has(t)){var k=n.get(t);if(k[0]===M&&k[1]===O)return}n.set(t,[M,O]);var S=Object.create(h.prototype);S.target=t,S.contentRect=new c(u,d,M,O),s.has(i)||(s.set(i,[]),p.add(i)),s.get(i).push(S)}))})),p.forEach((function(e){i.get(e).call(e,s.get(e),e)}))}return s.prototype.observe=function(i){if(i instanceof window.Element){r.has(i)||(r.set(i,new Set),o.add(i),a.set(i,window.getComputedStyle(i)));var n=r.get(i);n.has(this)||n.add(this),cancelAnimationFrame(t),t=requestAnimationFrame(d)}},s.prototype.unobserve=function(i){if(i instanceof window.Element&&r.has(i)){var n=r.get(i);n.has(this)&&(n.delete(this),n.size||(r.delete(i),o.delete(i))),n.size||r.delete(i),o.size||cancelAnimationFrame(t)}},A.DOMRectReadOnly=c,A.ResizeObserver=s,A.ResizeObserverEntry=h,A}; // eslint-disable-line\n",
       "mpl.toolbar_items = [[\"Home\", \"Reset original view\", \"fa fa-home icon-home\", \"home\"], [\"Back\", \"Back to previous view\", \"fa fa-arrow-left icon-arrow-left\", \"back\"], [\"Forward\", \"Forward to next view\", \"fa fa-arrow-right icon-arrow-right\", \"forward\"], [\"\", \"\", \"\", \"\"], [\"Pan\", \"Left button pans, Right button zooms\\nx/y fixes axis, CTRL fixes aspect\", \"fa fa-arrows icon-move\", \"pan\"], [\"Zoom\", \"Zoom to rectangle\\nx/y fixes axis, CTRL fixes aspect\", \"fa fa-square-o icon-check-empty\", \"zoom\"], [\"\", \"\", \"\", \"\"], [\"Download\", \"Download plot\", \"fa fa-floppy-o icon-save\", \"download\"]];\n",
       "\n",
       "mpl.extensions = [\"eps\", \"jpeg\", \"pdf\", \"png\", \"ps\", \"raw\", \"svg\", \"tif\"];\n",
       "\n",
       "mpl.default_extension = \"png\";/* global mpl */\n",
       "\n",
       "var comm_websocket_adapter = function (comm) {\n",
       "    // Create a \"websocket\"-like object which calls the given IPython comm\n",
       "    // object with the appropriate methods. Currently this is a non binary\n",
       "    // socket, so there is still some room for performance tuning.\n",
       "    var ws = {};\n",
       "\n",
       "    ws.close = function () {\n",
       "        comm.close();\n",
       "    };\n",
       "    ws.send = function (m) {\n",
       "        //console.log('sending', m);\n",
       "        comm.send(m);\n",
       "    };\n",
       "    // Register the callback with on_msg.\n",
       "    comm.on_msg(function (msg) {\n",
       "        //console.log('receiving', msg['content']['data'], msg);\n",
       "        // Pass the mpl event to the overridden (by mpl) onmessage function.\n",
       "        ws.onmessage(msg['content']['data']);\n",
       "    });\n",
       "    return ws;\n",
       "};\n",
       "\n",
       "mpl.mpl_figure_comm = function (comm, msg) {\n",
       "    // This is the function which gets called when the mpl process\n",
       "    // starts-up an IPython Comm through the \"matplotlib\" channel.\n",
       "\n",
       "    var id = msg.content.data.id;\n",
       "    // Get hold of the div created by the display call when the Comm\n",
       "    // socket was opened in Python.\n",
       "    var element = document.getElementById(id);\n",
       "    var ws_proxy = comm_websocket_adapter(comm);\n",
       "\n",
       "    function ondownload(figure, _format) {\n",
       "        window.open(figure.canvas.toDataURL());\n",
       "    }\n",
       "\n",
       "    var fig = new mpl.figure(id, ws_proxy, ondownload, element);\n",
       "\n",
       "    // Call onopen now - mpl needs it, as it is assuming we've passed it a real\n",
       "    // web socket which is closed, not our websocket->open comm proxy.\n",
       "    ws_proxy.onopen();\n",
       "\n",
       "    fig.parent_element = element;\n",
       "    fig.cell_info = mpl.find_output_cell(\"<div id='\" + id + \"'></div>\");\n",
       "    if (!fig.cell_info) {\n",
       "        console.error('Failed to find cell for figure', id, fig);\n",
       "        return;\n",
       "    }\n",
       "    fig.cell_info[0].output_area.element.on(\n",
       "        'cleared',\n",
       "        { fig: fig },\n",
       "        fig._remove_fig_handler\n",
       "    );\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_close = function (fig, msg) {\n",
       "    var width = fig.canvas.width / fig.ratio;\n",
       "    fig.cell_info[0].output_area.element.off(\n",
       "        'cleared',\n",
       "        fig._remove_fig_handler\n",
       "    );\n",
       "    fig.resizeObserverInstance.unobserve(fig.canvas_div);\n",
       "\n",
       "    // Update the output cell to use the data from the current canvas.\n",
       "    fig.push_to_output();\n",
       "    var dataURL = fig.canvas.toDataURL();\n",
       "    // Re-enable the keyboard manager in IPython - without this line, in FF,\n",
       "    // the notebook keyboard shortcuts fail.\n",
       "    IPython.keyboard_manager.enable();\n",
       "    fig.parent_element.innerHTML =\n",
       "        '<img src=\"' + dataURL + '\" width=\"' + width + '\">';\n",
       "    fig.close_ws(fig, msg);\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.close_ws = function (fig, msg) {\n",
       "    fig.send_message('closing', msg);\n",
       "    // fig.ws.close()\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.push_to_output = function (_remove_interactive) {\n",
       "    // Turn the data on the canvas into data in the output cell.\n",
       "    var width = this.canvas.width / this.ratio;\n",
       "    var dataURL = this.canvas.toDataURL();\n",
       "    this.cell_info[1]['text/html'] =\n",
       "        '<img src=\"' + dataURL + '\" width=\"' + width + '\">';\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.updated_canvas_event = function () {\n",
       "    // Tell IPython that the notebook contents must change.\n",
       "    IPython.notebook.set_dirty(true);\n",
       "    this.send_message('ack', {});\n",
       "    var fig = this;\n",
       "    // Wait a second, then push the new image to the DOM so\n",
       "    // that it is saved nicely (might be nice to debounce this).\n",
       "    setTimeout(function () {\n",
       "        fig.push_to_output();\n",
       "    }, 1000);\n",
       "};\n",
       "\n",
       "mpl.figure.prototype._init_toolbar = function () {\n",
       "    var fig = this;\n",
       "\n",
       "    var toolbar = document.createElement('div');\n",
       "    toolbar.classList = 'btn-toolbar';\n",
       "    this.root.appendChild(toolbar);\n",
       "\n",
       "    function on_click_closure(name) {\n",
       "        return function (_event) {\n",
       "            return fig.toolbar_button_onclick(name);\n",
       "        };\n",
       "    }\n",
       "\n",
       "    function on_mouseover_closure(tooltip) {\n",
       "        return function (event) {\n",
       "            if (!event.currentTarget.disabled) {\n",
       "                return fig.toolbar_button_onmouseover(tooltip);\n",
       "            }\n",
       "        };\n",
       "    }\n",
       "\n",
       "    fig.buttons = {};\n",
       "    var buttonGroup = document.createElement('div');\n",
       "    buttonGroup.classList = 'btn-group';\n",
       "    var button;\n",
       "    for (var toolbar_ind in mpl.toolbar_items) {\n",
       "        var name = mpl.toolbar_items[toolbar_ind][0];\n",
       "        var tooltip = mpl.toolbar_items[toolbar_ind][1];\n",
       "        var image = mpl.toolbar_items[toolbar_ind][2];\n",
       "        var method_name = mpl.toolbar_items[toolbar_ind][3];\n",
       "\n",
       "        if (!name) {\n",
       "            /* Instead of a spacer, we start a new button group. */\n",
       "            if (buttonGroup.hasChildNodes()) {\n",
       "                toolbar.appendChild(buttonGroup);\n",
       "            }\n",
       "            buttonGroup = document.createElement('div');\n",
       "            buttonGroup.classList = 'btn-group';\n",
       "            continue;\n",
       "        }\n",
       "\n",
       "        button = fig.buttons[name] = document.createElement('button');\n",
       "        button.classList = 'btn btn-default';\n",
       "        button.href = '#';\n",
       "        button.title = name;\n",
       "        button.innerHTML = '<i class=\"fa ' + image + ' fa-lg\"></i>';\n",
       "        button.addEventListener('click', on_click_closure(method_name));\n",
       "        button.addEventListener('mouseover', on_mouseover_closure(tooltip));\n",
       "        buttonGroup.appendChild(button);\n",
       "    }\n",
       "\n",
       "    if (buttonGroup.hasChildNodes()) {\n",
       "        toolbar.appendChild(buttonGroup);\n",
       "    }\n",
       "\n",
       "    // Add the status bar.\n",
       "    var status_bar = document.createElement('span');\n",
       "    status_bar.classList = 'mpl-message pull-right';\n",
       "    toolbar.appendChild(status_bar);\n",
       "    this.message = status_bar;\n",
       "\n",
       "    // Add the close button to the window.\n",
       "    var buttongrp = document.createElement('div');\n",
       "    buttongrp.classList = 'btn-group inline pull-right';\n",
       "    button = document.createElement('button');\n",
       "    button.classList = 'btn btn-mini btn-primary';\n",
       "    button.href = '#';\n",
       "    button.title = 'Stop Interaction';\n",
       "    button.innerHTML = '<i class=\"fa fa-power-off icon-remove icon-large\"></i>';\n",
       "    button.addEventListener('click', function (_evt) {\n",
       "        fig.handle_close(fig, {});\n",
       "    });\n",
       "    button.addEventListener(\n",
       "        'mouseover',\n",
       "        on_mouseover_closure('Stop Interaction')\n",
       "    );\n",
       "    buttongrp.appendChild(button);\n",
       "    var titlebar = this.root.querySelector('.ui-dialog-titlebar');\n",
       "    titlebar.insertBefore(buttongrp, titlebar.firstChild);\n",
       "};\n",
       "\n",
       "mpl.figure.prototype._remove_fig_handler = function (event) {\n",
       "    var fig = event.data.fig;\n",
       "    if (event.target !== this) {\n",
       "        // Ignore bubbled events from children.\n",
       "        return;\n",
       "    }\n",
       "    fig.close_ws(fig, {});\n",
       "};\n",
       "\n",
       "mpl.figure.prototype._root_extra_style = function (el) {\n",
       "    el.style.boxSizing = 'content-box'; // override notebook setting of border-box.\n",
       "};\n",
       "\n",
       "mpl.figure.prototype._canvas_extra_style = function (el) {\n",
       "    // this is important to make the div 'focusable\n",
       "    el.setAttribute('tabindex', 0);\n",
       "    // reach out to IPython and tell the keyboard manager to turn it's self\n",
       "    // off when our div gets focus\n",
       "\n",
       "    // location in version 3\n",
       "    if (IPython.notebook.keyboard_manager) {\n",
       "        IPython.notebook.keyboard_manager.register_events(el);\n",
       "    } else {\n",
       "        // location in version 2\n",
       "        IPython.keyboard_manager.register_events(el);\n",
       "    }\n",
       "};\n",
       "\n",
       "mpl.figure.prototype._key_event_extra = function (event, _name) {\n",
       "    var manager = IPython.notebook.keyboard_manager;\n",
       "    if (!manager) {\n",
       "        manager = IPython.keyboard_manager;\n",
       "    }\n",
       "\n",
       "    // Check for shift+enter\n",
       "    if (event.shiftKey && event.which === 13) {\n",
       "        this.canvas_div.blur();\n",
       "        // select the cell after this one\n",
       "        var index = IPython.notebook.find_cell_index(this.cell_info[0]);\n",
       "        IPython.notebook.select(index + 1);\n",
       "    }\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_save = function (fig, _msg) {\n",
       "    fig.ondownload(fig, null);\n",
       "};\n",
       "\n",
       "mpl.find_output_cell = function (html_output) {\n",
       "    // Return the cell and output element which can be found *uniquely* in the notebook.\n",
       "    // Note - this is a bit hacky, but it is done because the \"notebook_saving.Notebook\"\n",
       "    // IPython event is triggered only after the cells have been serialised, which for\n",
       "    // our purposes (turning an active figure into a static one), is too late.\n",
       "    var cells = IPython.notebook.get_cells();\n",
       "    var ncells = cells.length;\n",
       "    for (var i = 0; i < ncells; i++) {\n",
       "        var cell = cells[i];\n",
       "        if (cell.cell_type === 'code') {\n",
       "            for (var j = 0; j < cell.output_area.outputs.length; j++) {\n",
       "                var data = cell.output_area.outputs[j];\n",
       "                if (data.data) {\n",
       "                    // IPython >= 3 moved mimebundle to data attribute of output\n",
       "                    data = data.data;\n",
       "                }\n",
       "                if (data['text/html'] === html_output) {\n",
       "                    return [cell, data, j];\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    }\n",
       "};\n",
       "\n",
       "// Register the function which deals with the matplotlib target/channel.\n",
       "// The kernel may be null if the page has been refreshed.\n",
       "if (IPython.notebook.kernel !== null) {\n",
       "    IPython.notebook.kernel.comm_manager.register_target(\n",
       "        'matplotlib',\n",
       "        mpl.mpl_figure_comm\n",
       "    );\n",
       "}\n"
      ],
      "text/plain": [
       "<IPython.core.display.Javascript object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<img src=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAfQAAAHgCAYAAABTkZ8HAAAdlElEQVR4Xu3dZ4hk1doF4G3ArKP+UMGMOWDOglmMiArGH+Yf5gRGzDmhYlYEE5gxYFYUFQMiKmJAUTBhQjAr5rnsw9cyznTPVJ+erjqzvqdAuDBV3ft93lW9qiv0nWnixIkTiwsBAgQIECAwQwvMpNBn6P05PAECBAgQaAQUuiAQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYUesEQjECBAgAABhS4DBAgQIEAgQEChByzRCAQIECBAQKHLAAECBAgQCBBQ6AFLNAIBAgQIEFDoMkCAAAECBAIEFHrAEo1AgAABAgQUugwQIECAAIEAAYU+hiX+/vvv5fzzzy8nnXRSmX322cfwlfpzU+cdX2e+fCcVkAd5GF+BKb+6Qh+D+I8//lgmTJhQfvjhhzLffPON4Sv156bOO77OfPlOKiAP8jC+Agp9uvq6w05Xzim+GF++CnJ8M8C3f779+E5+Qx+DssIZA14PN+XbA9IYrsJ3DHg93JRvD0hjuMqM5juGUXu+qULvmWrKK85ogXLeMSy7h5vy7QFpDFfhOwa8Hm7Ktwekjl9FoY9hQd70Mga8Hm7KtwekMVyF7xjwergp3x6QxnCVGc13DKP2fFOF3jOVKxIgQIAAge4KKPTu7sbJCBAgQIBAzwIKvWcqVyRAgAABAt0VUOjd3Y2TESBAgACBngUUes9UrkiAAAECBLoroNCnsZurr766XHzxxeWrr74qq6++ernyyivLeuutN+Kt7rnnnnLqqaeWjz/+uCy33HLlwgsvLNtvv33fEjCa8958881l//33/8/Z6p+w/e233/py3ueff76xfe2118qXX35Z7r///rLzzjtP9Xs/++yz5dhjjy3vvPNOWXzxxcspp5xS9ttvv06et5518803n+JsddZFFllkXM9c/yTxfffdV957770y55xzlo022qjJ4gorrDDV7zuo/LY57yDze+2115b6X72f18sqq6xSTjvttLLddtt18mfDaM87SNvhAC+44ILmT2wfddRR5fLLL++k8bjeoXv84gp9KlB33XVX2Weffcp1111X1l9//SZI9Qfe+++/XxZaaKEpbvnSSy+VTTbZpPn77jvuuGO5/fbbmx+ir7/+ell11VV7XEn7q432vPVOW+8gdZ6hy0wzzVQWXnjh9ocYxS0fe+yx8uKLL5a111677LrrrtMs9I8++qhxPPjgg8tBBx1Unn766XL00UeXRx55pGyzzTaj+M7trjra8w4VevWd9E8D1+zMPPPM7Q7R46223Xbbsueee5Z11123/PXXX+Xkk08ub7/9dnn33XfL3HPPPexXGWR+25x3kPl96KGHyiyzzNI8aJ84cWK55ZZbmgenb7zxRlPuk18GaVvPMtrzDtJ2crtXX3217L777s19qD5AHqnQB23c411zXK+m0KfCW0u8/kC86qqrmmv9888/zW+FRxxxRDnxxBOnuOUee+xRfvnll/Lwww//+28bbLBBWWONNZoHBeN9Ge156522FuL3338/3keb5tevDySm9Rv6CSec0JR3LaahSy2tev7HH398mt9jel6hl/MOFfp3331X5p9//un57Uf9tb755pvmQehzzz3XPOgc7jLo/E56pl7O26X81rMvuOCCTakfeOCBnfvZMNy+p3bertj+/PPPZa211irXXHNNOeecc5qfpSMVepfyO+o76HS6gUIfAfKPP/4oc801V7n33nv/8zTwvvvu2xTIgw8+OMUtl1hiiebp4FqSQ5fTTz+9PPDAA+XNN9+cTisb/su0OW+909bfdBdddNHmwUq945x33nnD/oYxrocvpfRSkLWI6hknvUPfdNNNjXf9P8jp56WX8w4V+pJLLlnqH8Gozy6cccYZZeONN+7nUZvv9eGHHza/Tb711lsjPls0yPxODtLLebuS37///rt55q7+bKi/oa+88sqd+tkw+WF6OW9XbKtpfeBx2WWXlc0222yqhd6l/Pb9Dv5/31ChjyD/xRdfNEVXn8bZcMMN/73W8ccf3/yW88orr0xxy9lmm6156m2vvfb699/qI8szzzyzfP311+O64zbnffnll8sHH3xQVltttaYQL7nkklJf166vTy+22GLjet7Jv3gvBbn88ss3r/nX19KGLo8++mjZYYcdyq+//tq8VtyvSy/nrU+111JfZ511mkK/8cYby2233dZkpz4w6delPljbaaedmgeiL7zwwojfdpD5nfRQvZ530PmtD47qz4b6npN55pmneYltpPfLdMF2NOcdtG3Nw5133lnOPffcUp9yn2OOOaZZ6F0w7td9eqTvo9D/Hxf65KP/+eefZaWVVmoekJx99tl9zWYvBTmjFfpwgJtuummpv0nUYu/X5ZBDDin19f9a5lN7oNaVH4i9nnfQ+a3Pin366afNg+H6TF59wFYf7A/3G3oXbEdz3kHbfvbZZ80D4aeeeqr5haNepvUbeheM+3WfVuijlG7zFPYgn/Jpc97hSHbbbbcy66yzljvuuGOUYmO7ei+FPqM95T6cyHHHHdcUa/0NqB+Xww8/vHl5qD7zsvTSS0/1Ww4yv0MHG815u5TfepatttqqLLPMMuX666+f4mhdsJ38UFM776Bt68uUu+yyS/PGw6FLfamg/pyobyitz3hN+m/1Ol007sd9fNLv4Tf0qYjXN5nVj6jVj6rVS30qsIam/tAZ6U1x9anf+o7SoUv9uFB9hNmvN8WN5ryTj17vMPUduvVpw0svvbSvWeyl0Oub4upT7PWpw6HL3nvvXb799ttOviluOMCtt966zDvvvM1HysbzUt95Xd+8Wd9oWJ/2r6+fT+tS31Q0qPy2OW+X8lvPssUWWzQ/H+rrz5NfBmk70t6ndt5B2/7000/lk08++c8x6sttK664Yqk/B4b71FAXjad1n5ve/67QpyJaPwZW35RRH3HXoqxvxrr77rubz/bWj3bVj7TV19nrx9Tqpb7eXp9SrZ+ZrK/r1teA6pvM+vmxtdGc96yzzir1XfjLLrts8/pqfYdufWRcPxc+3NOG0zt89R2s9c1P9bLmmms2DyLqx1Lqm2DqD8b6Wvnnn39ebr311uY6Qx9bO+yww8oBBxxQnnnmmXLkkUf27WNroz1vzUv9rbg+SKqvs9anZOuDwyeffLJsueWW05vzP1/v0EMPbV7Trb+dT/rZ8wkTJvz7XoMu5bfNeQeZ35rN+pnzmtNaPkMfUX3iiSdKfdDWJdsajNGed5C2I90xJn/KvWvG43qH7vGLK/RpQNWPrA39YZn6kYkrrrii+Ux6vdSALbXUUv95RF7f7Vr/2MnQH5a56KKL+vqHZUZz3mOOOab5TbH+0ZwFFlig+Tx4/WhILdd+XEb6wyv1QUn9Laf+wZjqWK83dKn/u567fp66vh5c/4hPv/6wzGjPW3d/ww03NA9K6icm6jM19Y+PDPfHZqa3d33GY7hL/VTAkFeX8tvmvIPMb/1oWv07CPWPBNUHSXW39TfHWuZd/Nkw2vMO0rbXQu9Sfqf3/bft11PobeXcjgABAgQIdEhAoXdoGY5CgAABAgTaCij0tnJuR4AAAQIEOiSg0Du0DEchQIAAAQJtBRR6Wzm3I0CAAAECHRJQ6B1ahqMQIECAAIG2Agq9rZzbESBAgACBDgko9A4tw1EIECBAgEBbAYXeVs7tCBAgQIBAhwQUeoeW4SgECBAgQKCtgEJvK+d2BAgQIECgQwIKvUPLcBQCBAgQINBWQKG3lXM7AgQIECDQIQGF3qFlOAoBAgQIEGgroNDbyrkdAQIECBDokIBC79AyHIUAAQIECLQVUOht5dyOAAECBAh0SEChd2gZjkKAAAECBNoKKPS2cm5HgAABAgQ6JKDQO7QMRyFAgAABAm0FFHpbObcjQIAAAQIdElDoHVqGoxAgQIAAgbYCCr2tnNsRIECAAIEOCSj0Di3DUQgQIECAQFsBhd5Wzu0IECBAgECHBBR6h5bhKAQIECBAoK2AQm8r53YECBAgQKBDAgq9Q8twFAIECBAg0FZAobeVczsCBAgQINAhAYXeoWU4CgECBAgQaCug0NvKuR0BAgQIEOiQgELv0DIchQABAgQItBX4H6Gp3TNnHKU7AAAAAElFTkSuQmCC\" width=\"500\">"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "No handles with labels found to put in legend.\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "flow rates load is =  0.6380194708090458 0.004002129411673854 2.9012208599907954\n",
      "flow rates HP is =  0.6360194097720268 0.003983835952220649 1.898269662232681\n",
      "heat Capacity in kWh is:  3.351798855418726e-05\n",
      "Load in kWh is: 6.143664766908518e-05\n",
      "df whole is:     id            dateTime     Tamb  TtopTestTankHPCir  TbottomTestTankHpCir  \\\n",
      "0  760 2021-01-29 08:13:46  21.5079            36.3071               25.2608   \n",
      "\n",
      "   TtopSourceTank  TloadTankMix  TTopTestTankLoadCir  TloadMix  \\\n",
      "0         20.7308       23.4683              36.5107   22.0824   \n",
      "\n",
      "   TbottomSourceTank  ...       T2       T3       T4       T5       T6  \\\n",
      "0             18.198  ...  28.2052  26.8172  25.7006  37.3594  37.3594   \n",
      "\n",
      "        T7       T8       T9   flowHP  flowLoad  \n",
      "0  36.7823  35.3908  33.6608  1.89827  2.901221  \n",
      "\n",
      "[1 rows x 23 columns]\n",
      "Load in kWh is: 6.143664766908518e-05\n",
      "heat Capacity in kWh is:  3.351798855418726e-05\n",
      "________________________________________________________________\n",
      "flow rates load is =  0.6340193487350078 0.0039770376912244875 1.3231252342444757\n",
      "flow rates HP is =  0.6340193487350078 0.003971308166207377 -0.4637337145910134\n",
      "heat Capacity in kWh is:  3.351798855418726e-05\n",
      "Load in kWh is: 6.143664766908518e-05\n",
      "df whole is:     id            dateTime     Tamb  TtopTestTankHPCir  TbottomTestTankHpCir  \\\n",
      "0  760 2021-01-29 08:13:46  21.5079            36.3071               25.2608   \n",
      "\n",
      "   TtopSourceTank  TloadTankMix  TTopTestTankLoadCir  TloadMix  \\\n",
      "0         20.7308       23.4683              36.5107   22.0824   \n",
      "\n",
      "   TbottomSourceTank  ...       T2       T3       T4       T5       T6  \\\n",
      "0             18.198  ...  28.2052  26.8172  25.7006  37.3594  37.3594   \n",
      "\n",
      "        T7       T8       T9   flowHP  flowLoad  \n",
      "0  36.7823  35.3908  33.6608  1.89827  2.901221  \n",
      "\n",
      "[1 rows x 23 columns]\n",
      "Load in kWh is: 6.143664766908518e-05\n",
      "heat Capacity in kWh is:  3.351798855418726e-05\n",
      "________________________________________________________________\n",
      "flow rates load is =  0.6280191656239509 0.003939400110550439 -1.0440182043749497\n",
      "flow rates HP is =  0.6320192876979889 0.003958780380194105 -2.825737091414544\n",
      "heat Capacity in kWh is:  3.351798855418726e-05\n",
      "Load in kWh is: 6.143664766908518e-05\n",
      "df whole is:     id            dateTime     Tamb  TtopTestTankHPCir  TbottomTestTankHpCir  \\\n",
      "0  760 2021-01-29 08:13:46  21.5079            36.3071               25.2608   \n",
      "\n",
      "   TtopSourceTank  TloadTankMix  TTopTestTankLoadCir  TloadMix  \\\n",
      "0         20.7308       23.4683              36.5107   22.0824   \n",
      "\n",
      "   TbottomSourceTank  ...       T2       T3       T4       T5       T6  \\\n",
      "0             18.198  ...  28.2052  26.8172  25.7006  37.3594  37.3594   \n",
      "\n",
      "        T7       T8       T9   flowHP  flowLoad  \n",
      "0  36.7823  35.3908  33.6608  1.89827  2.901221  \n",
      "\n",
      "[1 rows x 23 columns]\n",
      "Load in kWh is: 6.143664766908518e-05\n",
      "heat Capacity in kWh is:  3.351798855418726e-05\n",
      "________________________________________________________________\n",
      "flow rates load is =  0.6340193487350078 0.0039770376912244875 1.3231252342444757\n",
      "flow rates HP is =  0.6300192266609699 0.003946252594180832 -5.187740468238238\n",
      "heat Capacity in kWh is:  -5.780231996930906e-05\n",
      "Load in kWh is: 8.945641848500882e-05\n",
      "df whole is:     id            dateTime     Tamb  TtopTestTankHPCir  TbottomTestTankHpCir  \\\n",
      "0  760 2021-01-29 08:13:46  21.5079            36.3071               25.2608   \n",
      "1  761 2021-01-29 08:13:47  21.5079            36.3071               25.2946   \n",
      "\n",
      "   TtopSourceTank  TloadTankMix  TTopTestTankLoadCir  TloadMix  \\\n",
      "0         20.7308       23.4683              36.5107   22.0824   \n",
      "1         20.7308       23.4345              36.4768   22.0824   \n",
      "\n",
      "   TbottomSourceTank  ...       T2       T3       T4       T5       T6  \\\n",
      "0            18.1980  ...  28.2052  26.8172  25.7006  37.3594  37.3594   \n",
      "1            18.1642  ...  28.2052  26.7834  25.7006  37.3594  37.3254   \n",
      "\n",
      "        T7       T8       T9   flowHP  flowLoad  \n",
      "0  36.7823  35.3908  33.6608  1.89827  2.901221  \n",
      "1  36.7483  35.3908  33.6947 -5.18774  1.323125  \n",
      "\n",
      "[2 rows x 23 columns]\n",
      "Load in kWh is: 8.945641848500882e-05\n",
      "heat Capacity in kWh is:  -5.780231996930906e-05\n",
      "________________________________________________________________\n",
      "flow rates load is =  0.6360194097720268 0.003989583551449171 2.1121730471176354\n",
      "flow rates HP is =  0.6340193487350078 0.003971308166207377 -0.4637337145910134\n",
      "heat Capacity in kWh is:  -5.780231996930906e-05\n",
      "Load in kWh is: 8.945641848500882e-05\n",
      "df whole is:     id            dateTime     Tamb  TtopTestTankHPCir  TbottomTestTankHpCir  \\\n",
      "0  760 2021-01-29 08:13:46  21.5079            36.3071               25.2608   \n",
      "1  761 2021-01-29 08:13:47  21.5079            36.3071               25.2946   \n",
      "\n",
      "   TtopSourceTank  TloadTankMix  TTopTestTankLoadCir  TloadMix  \\\n",
      "0         20.7308       23.4683              36.5107   22.0824   \n",
      "1         20.7308       23.4345              36.4768   22.0824   \n",
      "\n",
      "   TbottomSourceTank  ...       T2       T3       T4       T5       T6  \\\n",
      "0            18.1980  ...  28.2052  26.8172  25.7006  37.3594  37.3594   \n",
      "1            18.1642  ...  28.2052  26.7834  25.7006  37.3594  37.3254   \n",
      "\n",
      "        T7       T8       T9   flowHP  flowLoad  \n",
      "0  36.7823  35.3908  33.6608  1.89827  2.901221  \n",
      "1  36.7483  35.3908  33.6947 -5.18774  1.323125  \n",
      "\n",
      "[2 rows x 23 columns]\n",
      "Load in kWh is: 8.945641848500882e-05\n",
      "heat Capacity in kWh is:  -5.780231996930906e-05\n",
      "________________________________________________________________\n",
      "flow rates load is =  0.6340193487350078 0.0039770376912244875 1.3231252342444757\n",
      "flow rates HP is =  0.6300192266609699 0.003946252594180832 -5.187740468238238\n",
      "heat Capacity in kWh is:  -0.00014939954584182707\n",
      "Load in kWh is: 0.00011754772159883816\n",
      "df whole is:     id            dateTime     Tamb  TtopTestTankHPCir  TbottomTestTankHpCir  \\\n",
      "0  760 2021-01-29 08:13:46  21.5079            36.3071               25.2608   \n",
      "1  761 2021-01-29 08:13:47  21.5079            36.3071               25.2946   \n",
      "2  762 2021-01-29 08:13:49  21.5417            36.3410               25.2946   \n",
      "\n",
      "   TtopSourceTank  TloadTankMix  TTopTestTankLoadCir  TloadMix  \\\n",
      "0         20.7308       23.4683              36.5107   22.0824   \n",
      "1         20.7308       23.4345              36.4768   22.0824   \n",
      "2         20.7308       23.4345              36.5107   22.1162   \n",
      "\n",
      "   TbottomSourceTank  ...       T2       T3       T4       T5       T6  \\\n",
      "0            18.1980  ...  28.2052  26.8172  25.7006  37.3594  37.3594   \n",
      "1            18.1642  ...  28.2052  26.7834  25.7006  37.3594  37.3254   \n",
      "2            18.1980  ...  28.1713  26.8172  25.7344  37.3254  37.3254   \n",
      "\n",
      "        T7       T8       T9   flowHP  flowLoad  \n",
      "0  36.7823  35.3908  33.6608  1.89827  2.901221  \n",
      "1  36.7483  35.3908  33.6947 -5.18774  1.323125  \n",
      "2  36.7823  35.3908  33.6947 -5.18774  1.323125  \n",
      "\n",
      "[3 rows x 23 columns]\n",
      "Load in kWh is: 0.00011754772159883816\n",
      "heat Capacity in kWh is:  -0.00014939954584182707\n",
      "________________________________________________________________\n",
      "flow rates load is =  0.6340193487350078 0.0039770376912244875 1.3231252342444757\n",
      "flow rates HP is =  0.6300192266609699 0.003946252594180832 -5.187740468238238\n",
      "heat Capacity in kWh is:  -0.00014939954584182707\n",
      "Load in kWh is: 0.00011754772159883816\n",
      "df whole is:     id            dateTime     Tamb  TtopTestTankHPCir  TbottomTestTankHpCir  \\\n",
      "0  760 2021-01-29 08:13:46  21.5079            36.3071               25.2608   \n",
      "1  761 2021-01-29 08:13:47  21.5079            36.3071               25.2946   \n",
      "2  762 2021-01-29 08:13:49  21.5417            36.3410               25.2946   \n",
      "\n",
      "   TtopSourceTank  TloadTankMix  TTopTestTankLoadCir  TloadMix  \\\n",
      "0         20.7308       23.4683              36.5107   22.0824   \n",
      "1         20.7308       23.4345              36.4768   22.0824   \n",
      "2         20.7308       23.4345              36.5107   22.1162   \n",
      "\n",
      "   TbottomSourceTank  ...       T2       T3       T4       T5       T6  \\\n",
      "0            18.1980  ...  28.2052  26.8172  25.7006  37.3594  37.3594   \n",
      "1            18.1642  ...  28.2052  26.7834  25.7006  37.3594  37.3254   \n",
      "2            18.1980  ...  28.1713  26.8172  25.7344  37.3254  37.3254   \n",
      "\n",
      "        T7       T8       T9   flowHP  flowLoad  \n",
      "0  36.7823  35.3908  33.6608  1.89827  2.901221  \n",
      "1  36.7483  35.3908  33.6947 -5.18774  1.323125  \n",
      "2  36.7823  35.3908  33.6947 -5.18774  1.323125  \n",
      "\n",
      "[3 rows x 23 columns]\n",
      "Load in kWh is: 0.00011754772159883816\n",
      "heat Capacity in kWh is:  -0.00014939954584182707\n",
      "________________________________________________________________\n",
      "flow rates load is =  0.6320192876979889 0.003964491830999805 0.5340774213713702\n",
      "flow rates HP is =  0.6300192266609699 0.003946252594180832 -5.187740468238238\n",
      "heat Capacity in kWh is:  -0.0002412770427741013\n",
      "Load in kWh is: 0.0001288281060812381\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "df whole is:     id            dateTime     Tamb  TtopTestTankHPCir  TbottomTestTankHpCir  \\\n",
      "0  760 2021-01-29 08:13:46  21.5079            36.3071               25.2608   \n",
      "1  761 2021-01-29 08:13:47  21.5079            36.3071               25.2946   \n",
      "2  762 2021-01-29 08:13:49  21.5417            36.3410               25.2946   \n",
      "3  763 2021-01-29 08:13:51  21.5417            36.3410               25.2608   \n",
      "\n",
      "   TtopSourceTank  TloadTankMix  TTopTestTankLoadCir  TloadMix  \\\n",
      "0         20.7308       23.4683              36.5107   22.0824   \n",
      "1         20.7308       23.4345              36.4768   22.0824   \n",
      "2         20.7308       23.4345              36.5107   22.1162   \n",
      "3         20.7308       23.4345              36.5107   22.0824   \n",
      "\n",
      "   TbottomSourceTank  ...       T2       T3       T4       T5       T6  \\\n",
      "0            18.1980  ...  28.2052  26.8172  25.7006  37.3594  37.3594   \n",
      "1            18.1642  ...  28.2052  26.7834  25.7006  37.3594  37.3254   \n",
      "2            18.1980  ...  28.1713  26.8172  25.7344  37.3254  37.3254   \n",
      "3            18.1642  ...  28.1713  26.8172  25.7344  37.3594  37.2915   \n",
      "\n",
      "        T7       T8       T9   flowHP  flowLoad  \n",
      "0  36.7823  35.3908  33.6608  1.89827  2.901221  \n",
      "1  36.7483  35.3908  33.6947 -5.18774  1.323125  \n",
      "2  36.7823  35.3908  33.6947 -5.18774  1.323125  \n",
      "3  36.7823  35.3569  33.6947 -5.18774  0.534077  \n",
      "\n",
      "[4 rows x 23 columns]\n",
      "Load in kWh is: 0.0001288281060812381\n",
      "heat Capacity in kWh is:  -0.0002412770427741013\n",
      "________________________________________________________________\n",
      "flow rates load is =  0.6340193487350078 0.0039770376912244875 1.3231252342444757\n",
      "flow rates HP is =  0.6340193487350078 0.003971308166207377 -0.4637337145910134\n",
      "heat Capacity in kWh is:  -0.0002412770427741013\n",
      "Load in kWh is: 0.0001288281060812381\n",
      "df whole is:     id            dateTime     Tamb  TtopTestTankHPCir  TbottomTestTankHpCir  \\\n",
      "0  760 2021-01-29 08:13:46  21.5079            36.3071               25.2608   \n",
      "1  761 2021-01-29 08:13:47  21.5079            36.3071               25.2946   \n",
      "2  762 2021-01-29 08:13:49  21.5417            36.3410               25.2946   \n",
      "3  763 2021-01-29 08:13:51  21.5417            36.3410               25.2608   \n",
      "\n",
      "   TtopSourceTank  TloadTankMix  TTopTestTankLoadCir  TloadMix  \\\n",
      "0         20.7308       23.4683              36.5107   22.0824   \n",
      "1         20.7308       23.4345              36.4768   22.0824   \n",
      "2         20.7308       23.4345              36.5107   22.1162   \n",
      "3         20.7308       23.4345              36.5107   22.0824   \n",
      "\n",
      "   TbottomSourceTank  ...       T2       T3       T4       T5       T6  \\\n",
      "0            18.1980  ...  28.2052  26.8172  25.7006  37.3594  37.3594   \n",
      "1            18.1642  ...  28.2052  26.7834  25.7006  37.3594  37.3254   \n",
      "2            18.1980  ...  28.1713  26.8172  25.7344  37.3254  37.3254   \n",
      "3            18.1642  ...  28.1713  26.8172  25.7344  37.3594  37.2915   \n",
      "\n",
      "        T7       T8       T9   flowHP  flowLoad  \n",
      "0  36.7823  35.3908  33.6608  1.89827  2.901221  \n",
      "1  36.7483  35.3908  33.6947 -5.18774  1.323125  \n",
      "2  36.7823  35.3908  33.6947 -5.18774  1.323125  \n",
      "3  36.7823  35.3569  33.6947 -5.18774  0.534077  \n",
      "\n",
      "[4 rows x 23 columns]\n",
      "Load in kWh is: 0.0001288281060812381\n",
      "heat Capacity in kWh is:  -0.0002412770427741013\n",
      "________________________________________________________________\n",
      "flow rates load is =  0.6340193487350078 0.0039770376912244875 1.3231252342444757\n",
      "flow rates HP is =  0.6340193487350078 0.003971308166207377 -0.4637337145910134\n",
      "heat Capacity in kWh is:  -0.0002412770427741013\n",
      "Load in kWh is: 0.0001288281060812381\n",
      "df whole is:     id            dateTime     Tamb  TtopTestTankHPCir  TbottomTestTankHpCir  \\\n",
      "0  760 2021-01-29 08:13:46  21.5079            36.3071               25.2608   \n",
      "1  761 2021-01-29 08:13:47  21.5079            36.3071               25.2946   \n",
      "2  762 2021-01-29 08:13:49  21.5417            36.3410               25.2946   \n",
      "3  763 2021-01-29 08:13:51  21.5417            36.3410               25.2608   \n",
      "\n",
      "   TtopSourceTank  TloadTankMix  TTopTestTankLoadCir  TloadMix  \\\n",
      "0         20.7308       23.4683              36.5107   22.0824   \n",
      "1         20.7308       23.4345              36.4768   22.0824   \n",
      "2         20.7308       23.4345              36.5107   22.1162   \n",
      "3         20.7308       23.4345              36.5107   22.0824   \n",
      "\n",
      "   TbottomSourceTank  ...       T2       T3       T4       T5       T6  \\\n",
      "0            18.1980  ...  28.2052  26.8172  25.7006  37.3594  37.3594   \n",
      "1            18.1642  ...  28.2052  26.7834  25.7006  37.3594  37.3254   \n",
      "2            18.1980  ...  28.1713  26.8172  25.7344  37.3254  37.3254   \n",
      "3            18.1642  ...  28.1713  26.8172  25.7344  37.3594  37.2915   \n",
      "\n",
      "        T7       T8       T9   flowHP  flowLoad  \n",
      "0  36.7823  35.3908  33.6608  1.89827  2.901221  \n",
      "1  36.7483  35.3908  33.6947 -5.18774  1.323125  \n",
      "2  36.7823  35.3908  33.6947 -5.18774  1.323125  \n",
      "3  36.7823  35.3569  33.6947 -5.18774  0.534077  \n",
      "\n",
      "[4 rows x 23 columns]\n",
      "Load in kWh is: 0.0001288281060812381\n",
      "heat Capacity in kWh is:  -0.0002412770427741013\n",
      "________________________________________________________________\n",
      "flow rates load is =  0.6320192876979889 0.003964491830999805 0.5340774213713702\n",
      "flow rates HP is =  0.6340193487350078 0.003971308166207377 -0.4637337145910134\n",
      "heat Capacity in kWh is:  -0.0002494903766685233\n",
      "Load in kWh is: 0.00014016711643467786\n"
     ]
    },
    {
     "ename": "KeyboardInterrupt",
     "evalue": "",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mKeyboardInterrupt\u001b[0m                         Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-1-0efdc67d2325>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m    340\u001b[0m     \u001b[0;31m#restTem = InletTem(dfs(lol))\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    341\u001b[0m     \u001b[0;31m#print (df)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 342\u001b[0;31m     \u001b[0mfig\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0max\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mplotObject\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdf\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0max\u001b[0m\u001b[0;34m,\u001b[0m  \u001b[0mfig\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0malpha\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m0.7\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mscm\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mscm\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    343\u001b[0m     \u001b[0mprint\u001b[0m \u001b[0;34m(\u001b[0m\u001b[0;34m'df whole is:'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mdfs\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlol\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    344\u001b[0m     \u001b[0mtoCsv\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdfs\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlol\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mlist2df\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mLoad_kWh\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlol\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m'Load_kW'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mlist2df\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mmct\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlol\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m'Heat_Capacity_kW'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m<ipython-input-1-0efdc67d2325>\u001b[0m in \u001b[0;36mplotObject\u001b[0;34m(df, ax, fig, alpha, scm)\u001b[0m\n\u001b[1;32m    221\u001b[0m                 label = 'Layer ' + str(i))\n\u001b[1;32m    222\u001b[0m         \u001b[0max\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mlegend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mbbox_to_anchor\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;36m0.4\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;36m0.8\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 223\u001b[0;31m     \u001b[0mfig\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcanvas\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdraw\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    224\u001b[0m     \u001b[0max\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mlegend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    225\u001b[0m     \u001b[0;31m#plt.legend(loc='upper left')\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.7/site-packages/matplotlib/backends/backend_webagg_core.py\u001b[0m in \u001b[0;36mdraw\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    150\u001b[0m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_png_is_old\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;32mTrue\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    151\u001b[0m         \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 152\u001b[0;31m             \u001b[0msuper\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdraw\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    153\u001b[0m         \u001b[0;32mfinally\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    154\u001b[0m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mmanager\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mrefresh_all\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m  \u001b[0;31m# Swap the frames.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.7/site-packages/matplotlib/backends/backend_agg.py\u001b[0m in \u001b[0;36mdraw\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    405\u001b[0m              (self.toolbar._wait_cursor_for_draw_cm() if self.toolbar\n\u001b[1;32m    406\u001b[0m               else nullcontext()):\n\u001b[0;32m--> 407\u001b[0;31m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mfigure\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdraw\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mrenderer\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    408\u001b[0m             \u001b[0;31m# A GUI class may be need to update a window using this draw, so\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    409\u001b[0m             \u001b[0;31m# don't forget to call the superclass.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.7/site-packages/matplotlib/artist.py\u001b[0m in \u001b[0;36mdraw_wrapper\u001b[0;34m(artist, renderer, *args, **kwargs)\u001b[0m\n\u001b[1;32m     39\u001b[0m                 \u001b[0mrenderer\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mstart_filter\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     40\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 41\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mdraw\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0martist\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mrenderer\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m*\u001b[0m\u001b[0margs\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     42\u001b[0m         \u001b[0;32mfinally\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     43\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0martist\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_agg_filter\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.7/site-packages/matplotlib/figure.py\u001b[0m in \u001b[0;36mdraw\u001b[0;34m(self, renderer)\u001b[0m\n\u001b[1;32m   1862\u001b[0m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mpatch\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdraw\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mrenderer\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1863\u001b[0m             mimage._draw_list_compositing_images(\n\u001b[0;32m-> 1864\u001b[0;31m                 renderer, self, artists, self.suppressComposite)\n\u001b[0m\u001b[1;32m   1865\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1866\u001b[0m             \u001b[0mrenderer\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mclose_group\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'figure'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.7/site-packages/matplotlib/image.py\u001b[0m in \u001b[0;36m_draw_list_compositing_images\u001b[0;34m(renderer, parent, artists, suppress_composite)\u001b[0m\n\u001b[1;32m    129\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0mnot_composite\u001b[0m \u001b[0;32mor\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0mhas_images\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    130\u001b[0m         \u001b[0;32mfor\u001b[0m \u001b[0ma\u001b[0m \u001b[0;32min\u001b[0m \u001b[0martists\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 131\u001b[0;31m             \u001b[0ma\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdraw\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mrenderer\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    132\u001b[0m     \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    133\u001b[0m         \u001b[0;31m# Composite any adjacent images together\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.7/site-packages/matplotlib/artist.py\u001b[0m in \u001b[0;36mdraw_wrapper\u001b[0;34m(artist, renderer, *args, **kwargs)\u001b[0m\n\u001b[1;32m     39\u001b[0m                 \u001b[0mrenderer\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mstart_filter\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     40\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 41\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mdraw\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0martist\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mrenderer\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m*\u001b[0m\u001b[0margs\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     42\u001b[0m         \u001b[0;32mfinally\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     43\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0martist\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_agg_filter\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.7/site-packages/matplotlib/cbook/deprecation.py\u001b[0m in \u001b[0;36mwrapper\u001b[0;34m(*inner_args, **inner_kwargs)\u001b[0m\n\u001b[1;32m    409\u001b[0m                          \u001b[0;32melse\u001b[0m \u001b[0mdeprecation_addendum\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    410\u001b[0m                 **kwargs)\n\u001b[0;32m--> 411\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0mfunc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m*\u001b[0m\u001b[0minner_args\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0minner_kwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    412\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    413\u001b[0m     \u001b[0;32mreturn\u001b[0m \u001b[0mwrapper\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.7/site-packages/matplotlib/axes/_base.py\u001b[0m in \u001b[0;36mdraw\u001b[0;34m(self, renderer, inframe)\u001b[0m\n\u001b[1;32m   2745\u001b[0m             \u001b[0mrenderer\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mstop_rasterizing\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2746\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2747\u001b[0;31m         \u001b[0mmimage\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_draw_list_compositing_images\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mrenderer\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0martists\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2748\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2749\u001b[0m         \u001b[0mrenderer\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mclose_group\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'axes'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.7/site-packages/matplotlib/image.py\u001b[0m in \u001b[0;36m_draw_list_compositing_images\u001b[0;34m(renderer, parent, artists, suppress_composite)\u001b[0m\n\u001b[1;32m    129\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0mnot_composite\u001b[0m \u001b[0;32mor\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0mhas_images\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    130\u001b[0m         \u001b[0;32mfor\u001b[0m \u001b[0ma\u001b[0m \u001b[0;32min\u001b[0m \u001b[0martists\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 131\u001b[0;31m             \u001b[0ma\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdraw\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mrenderer\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    132\u001b[0m     \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    133\u001b[0m         \u001b[0;31m# Composite any adjacent images together\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.7/site-packages/matplotlib/artist.py\u001b[0m in \u001b[0;36mdraw_wrapper\u001b[0;34m(artist, renderer, *args, **kwargs)\u001b[0m\n\u001b[1;32m     39\u001b[0m                 \u001b[0mrenderer\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mstart_filter\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     40\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 41\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mdraw\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0martist\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mrenderer\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m*\u001b[0m\u001b[0margs\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     42\u001b[0m         \u001b[0;32mfinally\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     43\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0martist\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_agg_filter\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.7/site-packages/matplotlib/axis.py\u001b[0m in \u001b[0;36mdraw\u001b[0;34m(self, renderer, *args, **kwargs)\u001b[0m\n\u001b[1;32m   1174\u001b[0m         \u001b[0;31m# the actual bbox\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1175\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1176\u001b[0;31m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_update_label_position\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mrenderer\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1177\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1178\u001b[0m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mlabel\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdraw\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mrenderer\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.7/site-packages/matplotlib/axis.py\u001b[0m in \u001b[0;36m_update_label_position\u001b[0;34m(self, renderer)\u001b[0m\n\u001b[1;32m   2059\u001b[0m         \u001b[0;31m# get bounding boxes for this axis and any siblings\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2060\u001b[0m         \u001b[0;31m# that have been set by `fig.align_xlabels()`\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2061\u001b[0;31m         \u001b[0mbboxes\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mbboxes2\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_get_tick_boxes_siblings\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mrenderer\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mrenderer\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2062\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2063\u001b[0m         \u001b[0mx\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0my\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mlabel\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_position\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.7/site-packages/matplotlib/axis.py\u001b[0m in \u001b[0;36m_get_tick_boxes_siblings\u001b[0;34m(self, renderer)\u001b[0m\n\u001b[1;32m   2044\u001b[0m         \u001b[0;32mfor\u001b[0m \u001b[0mnn\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxx\u001b[0m \u001b[0;32min\u001b[0m \u001b[0menumerate\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mgrp\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_siblings\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0maxes\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2045\u001b[0m             \u001b[0mticks_to_draw\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0maxx\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mxaxis\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_update_ticks\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2046\u001b[0;31m             \u001b[0mtlb\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mtlb2\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0maxx\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mxaxis\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_get_tick_bboxes\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mticks_to_draw\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mrenderer\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2047\u001b[0m             \u001b[0mbboxes\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mextend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mtlb\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2048\u001b[0m             \u001b[0mbboxes2\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mextend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mtlb2\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.7/site-packages/matplotlib/axis.py\u001b[0m in \u001b[0;36m_get_tick_bboxes\u001b[0;34m(self, ticks, renderer)\u001b[0m\n\u001b[1;32m   1090\u001b[0m         \u001b[0;34m\"\"\"Return lists of bboxes for ticks' label1's and label2's.\"\"\"\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1091\u001b[0m         return ([tick.label1.get_window_extent(renderer)\n\u001b[0;32m-> 1092\u001b[0;31m                  for tick in ticks if tick.label1.get_visible()],\n\u001b[0m\u001b[1;32m   1093\u001b[0m                 [tick.label2.get_window_extent(renderer)\n\u001b[1;32m   1094\u001b[0m                  for tick in ticks if tick.label2.get_visible()])\n",
      "\u001b[0;32m~/.local/lib/python3.7/site-packages/matplotlib/axis.py\u001b[0m in \u001b[0;36m<listcomp>\u001b[0;34m(.0)\u001b[0m\n\u001b[1;32m   1090\u001b[0m         \u001b[0;34m\"\"\"Return lists of bboxes for ticks' label1's and label2's.\"\"\"\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1091\u001b[0m         return ([tick.label1.get_window_extent(renderer)\n\u001b[0;32m-> 1092\u001b[0;31m                  for tick in ticks if tick.label1.get_visible()],\n\u001b[0m\u001b[1;32m   1093\u001b[0m                 [tick.label2.get_window_extent(renderer)\n\u001b[1;32m   1094\u001b[0m                  for tick in ticks if tick.label2.get_visible()])\n",
      "\u001b[0;32m~/.local/lib/python3.7/site-packages/matplotlib/text.py\u001b[0m in \u001b[0;36mget_window_extent\u001b[0;34m(self, renderer, dpi)\u001b[0m\n\u001b[1;32m    904\u001b[0m             \u001b[0mx\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0my\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_transform\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mtransform\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mx\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0my\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    905\u001b[0m             \u001b[0mbbox\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mbbox\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mtranslated\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mx\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0my\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 906\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mbbox\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    907\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    908\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mset_backgroundcolor\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcolor\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mKeyboardInterrupt\u001b[0m: "
     ]
    }
   ],
   "source": [
    "import time\n",
    "import board\n",
    "import busio\n",
    "import pandas as pd\n",
    "from pandas import DataFrame\n",
    "from matplotlib import pylab\n",
    "import matplotlib.pyplot as plt\n",
    "from pylab import *\n",
    "import pylab\n",
    "import numpy as np\n",
    "import matplotlib.colors as clrs\n",
    "import matplotlib.cm as cm\n",
    "import matplotlib\n",
    "from collections import deque\n",
    "#matplotlib.use('TkAgg')\n",
    "%matplotlib notebook\n",
    "#%matplotlib inline\n",
    "\n",
    "#import time\n",
    "import sys\n",
    "import sqlite3\n",
    "#from time import sleep\n",
    "\n",
    "#import adafruit_ads1x15.ads1015 as ADS\n",
    "import adafruit_ads1x15.ads1115 as ADS\n",
    "from adafruit_ads1x15.analog_in import AnalogIn\n",
    "\n",
    "import MySQLdb as db\n",
    "\n",
    "HOST = \"10.208.8.122\"\n",
    "PORT = 3306\n",
    "USER = \"yogi\"\n",
    "PASSWORD = \"bittoo\"\n",
    "DB = \"TemaccessToRemoteRp2\"\n",
    "'''\n",
    "try:\n",
    "    connection = db.Connection(host=HOST, port=PORT,\n",
    "                               user=USER, passwd=PASSWORD, db=DB)\n",
    "\n",
    "    c = connection.cursor()\n",
    "    c.execute(\"SELECT * from temSensor\")\n",
    "    result = c.fetchall()\n",
    "    for item in result:\n",
    "        print (item)\n",
    "\n",
    "except Exception as e:\n",
    "    print (e)\n",
    "'''\n",
    "connectionL = db.connect(host=\"10.208.8.121\",\n",
    "                     user=\"yogi\",\n",
    "                     passwd=\"bittoo\",\n",
    "                     db=\"allSensors\")\n",
    "\n",
    "#c = conn.cursor()\n",
    "connectionR = db.Connection(host=HOST, port=PORT,user=USER, passwd=PASSWORD, db=DB)\n",
    "\n",
    "cR = connectionR.cursor()\n",
    "cL =connectionL.cursor()\n",
    "\n",
    "i2c = busio.I2C(board.SCL, board.SDA)\n",
    "\n",
    "# Create the ADC object using the I2C bus\n",
    "ads = ADS.ADS1115(i2c)\n",
    "\n",
    "ads.gain = 1\n",
    "\n",
    "\n",
    "cL.execute('DROP TABLE IF EXISTS flowReadings;')\n",
    "print ('table deleted')\n",
    "\n",
    "\n",
    "cL.execute('CREATE TABLE flowReadings(id INT AUTO_INCREMENT PRIMARY KEY, ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP, flowHP FLOAT, flowLoad FLOAT);')\n",
    "\n",
    "\n",
    "#cvsFileName = import os.path\n",
    "#os.path.exists(file_path)\n",
    "\n",
    "lol=[[], [], []]\n",
    "flowRateLoad  = []\n",
    "\n",
    "def flatten(l_of_l):\n",
    "    T = l_of_l[0]\n",
    "    flattend_l = [val for sublist in T for val in sublist]\n",
    "    #print ('flattened list is =', flattend_l)\n",
    "    return flattend_l\n",
    "\n",
    "def mct(Lol):\n",
    "    mHP = Lol[2]\n",
    "    T = flatten(Lol)\n",
    "    mL = Lol[1]\n",
    "    #this is density as polynomial function of T\n",
    "    p_LperH = [999.8473664794213 + 6.29265190e-02*x[2] - 8.42930922e-03*x[2]**2 + 6.77190849e-05*x[2]**3 \\\n",
    " - 4.40840180e-07*x[2]**4 + 1.29302849e-09*x[2]**5 for x in T]\n",
    "\n",
    "    #pV = [(999.8473664794213 + 6.29265190e-02*x[2] - 8.42930922e-03*x[2]**2 + 6.77190849e-05*x[2]**3 - 4.40840180e-07*x[2]**4 + 1.29302849e-09*x[2]**5)*2.7777e-07*y for x, y in zip(T, mHP)  ]\n",
    "    # this is mass flow  in kg/S =  density*V(flow rate in m^3/sec)= d * (1000^-3/3600)\n",
    "    mF_kgPerS =[ x*2.7777e-07*y for x, y in zip(p_LperH, mHP)]\n",
    "    #this is Cp as functiono of T linear function\n",
    "    cP_kjPerkgK = [4.253264761904763 - 0.00470305*b[2] for b in T]\n",
    "    #mCT1 = sum([(4.253264761904763 - 0.00470305*b[2])*a*(b[2]-b[3]) for a, b in zip(mHP, T)])\n",
    "    #mCT_kW = [(4.253264761904763 - 0.00470305*b[2])*a*(b[3]-b[4]) for a, b in zip(mHP, T)]\n",
    "    #Cp*M*deltaT\n",
    "    mCT_kW = [c*a*(b[3]-b[4]) for c, a, b in zip(cP_kjPerkgK,mF_kgPerS, T)]\n",
    "    # sum(mct* 5/3600 (time stamp))  = kWh\n",
    "    mCT2_kWh = sum([m*c*(dt[3]-dt[4])*0.0013888889 for m, c, dt in zip(mF_kgPerS,  cP_kjPerkgK, T)])\n",
    "    print ('heat Capacity in kWh is: ', mCT2_kWh)\n",
    "    \n",
    "    #print (T[-1], mHP,'mCpDeltaT =', mCT)\n",
    "    #print ('mCT is:',mCT)\n",
    "    #print ('mF', mF_kgPerS, mHP[-1])\n",
    "    #print (' mCT_kW is:', mCT_kW)\n",
    "    #print ('mCTkWh is ',mCT2_kWh)\n",
    "    return mCT_kW\n",
    "\n",
    "l_id = []\n",
    "\n",
    "def idGenerator(Id, l_id):\n",
    "    if Id not in l_id:\n",
    "       l_id.append(Id) \n",
    "    #print (l_id)\n",
    "    return l_id\n",
    "\n",
    "#df_conc= None\n",
    "def dfs(Lol):\n",
    "    mHP = Lol[2]\n",
    "    T = flatten(Lol)\n",
    "    mL = Lol[1]\n",
    "    StartTemTestingtank = [ 'id', 'dateTime', 'Tamb', 'TtopTestTankHPCir', 'TbottomTestTankHpCir', 'TtopSourceTank', \\\n",
    "'TloadTankMix','TTopTestTankLoadCir', 'TloadMix', 'TbottomSourceTank', 'TbottomTestTankLoadCir']\n",
    "    l_T = ['T{}'.format(x) for x in range(0,10)]\n",
    "    L = StartTemTestingtank +l_T\n",
    "    df_mHP = DataFrame(mHP, columns=['flowHP'])\n",
    "    df_mL = DataFrame(mL, columns=['flowLoad'])\n",
    "    df_tem = DataFrame(T, columns = L)\n",
    "    df_conc = pd.concat([df_tem, df_mHP, df_mL], axis=1)\n",
    "    \n",
    "    #print (df_mL)\n",
    "    #print (df_mHP)\n",
    "    #print (df_tem)\n",
    "    #print (df_conc)\n",
    "    return df_conc\n",
    "\n",
    "def list2df(lis, column_name = None):\n",
    "    df  = pd.DataFrame(lis, columns = [column_name]) \n",
    "    return df\n",
    "    \n",
    "def toCsv(df_full, load_kW, heatCapacity_kW):\n",
    "    df_Tem_Flow_Load_capacity_conc = pd.concat([df_full, load_kW, heatCapacity_kW], axis=1)\n",
    "    import os.path\n",
    "    import datetime\n",
    "    file_name = 'csvFile_{}'.format(datetime.datetime.now().strftime(\"%Y_%m_%d\"))\n",
    "    suffix = '.csv'\n",
    "    filePath = os.path.join(os.getcwd(), file_name + suffix)\n",
    "    df_Tem_Flow_Load_capacity_conc.to_csv(filePath, header=True)\n",
    "    return df_Tem_Flow_Load_capacity_conc\n",
    "\n",
    "def Load_kWh(Lol):\n",
    "    \n",
    "    mHP = Lol[2]\n",
    "    T = flatten(Lol)\n",
    "    mL = Lol[1]\n",
    "    #this is density as polynomial function of T\n",
    "    p_LperH = [999.8473664794213 + 6.29265190e-02*x[10] - 8.42930922e-03*x[10]**2 + 6.77190849e-05*x[10]**3 \\\n",
    " - 4.40840180e-07*x[10]**4 + 1.29302849e-09*x[10]**5 for x in T]\n",
    "    #print ('denisty is:', p_LperH )\n",
    "    #print ('Tem is:', [x[10] for x in T])\n",
    "    # this is mass flow  in kg/S =  density*V(flow rate in m^3/sec)= d * (1000^-3/3600)\n",
    "    mF_kgPerS =[ x*2.7777e-07*y for x, y in zip(p_LperH, mL)]\n",
    "    #this is Cp as functiono of T linear function\n",
    "    cP_kjPerkgK = [4.253264761904763 - 0.00470305*b[10] for b in T]\n",
    "    #print ('Cp is:', cP_kjPerkgK)\n",
    "    #Cp*M*deltaT\n",
    "    mCT_kW = [c*a*(b[7]-b[10]) for c, a, b in zip(cP_kjPerkgK,mF_kgPerS, T)]\n",
    "    mCT2_kWh = sum([m*c*(dt[7]-dt[10])*0.0013888889 for m, c, dt in zip(mF_kgPerS,  cP_kjPerkgK, T)])\n",
    "    print ('Load in kWh is:', mCT2_kWh)\n",
    "    return mCT_kW\n",
    "    \n",
    "def tankStrat(df):\n",
    "    dfT = df.iloc[:, 11:-2]\n",
    "    #print (dfT.columns)\n",
    "    #print (dfT)\n",
    "    dfT = dfT[['T4', 'T3', 'T2', 'T1', 'T0', 'T9', 'T8', 'T7', 'T6', 'T5']]\n",
    "    dfT = dfT.rename({'T4':'T0', 'T3':'T1', 'T2':'T2', 'T1':'T3', 'T0':'T4', 'T9':'T5', 'T8':'T6',\\\n",
    "              'T7':'T7','T6':'T8','T5':'T9'}, axis='columns')\n",
    "    #dfT = dfT[['T4', 'T3', 'T2', 'T1', 'T0', 'T5', 'T6', 'T7', 'T8', 'T9']]\n",
    "    #dfT = dfT[['T4', 'T3', 'T2', 'T1', 'T0', 'T8', 'T9', 'T5', 'T6', 'T7']]\n",
    "    #dfT = dfT.rename({'T4':'T0', 'T3':'T1', 'T2':'T2', 'T1':'T3', 'T0':'T4', 'T8':'T5', 'T9':'T6',\\\n",
    "    #           'T5':'T7','T6':'T8','T7':'T9'}, axis='columns')\n",
    "    #dfT = dfT.rename({'T4':'T0', 'T3':'T1', 'T2':'T2', 'T1':'T3', 'T0':'T4', 'T5':'T5', 'T6':'T6',\\\n",
    "    #          'T7':'T7','T8':'T8','T9':'T9'}, axis='columns')\n",
    "    #dfT.columns = ['T4', 'T3', 'T2', 'T1', 'T0', 'T5', 'T6', 'T7', 'T8', 'T9']\n",
    "    #print (dfT)\n",
    "    return dfT\n",
    "#tankStratTem = tankStrat(df_conc)\n",
    "\n",
    "\n",
    "    \n",
    "def create_color_step_obj(cmap_name, n):\n",
    "    \"\"\"\n",
    "    Return scalarMap object with n colors in gradient from color map\n",
    "    given in cmap_name.\n",
    "    \"\"\"\n",
    "    cmap = plt.get_cmap(cmap_name)\n",
    "    values = range(n)\n",
    "    cNorm  = clrs.Normalize(vmin=values[0], vmax=values[-1])\n",
    "    scalarMap = cm.ScalarMappable(norm=cNorm, cmap=cmap)\n",
    "    return scalarMap\n",
    "\n",
    "#import logging\n",
    "#logging.getLogger().setLevel(logging.CRITICAL)\n",
    "\n",
    "# colors\n",
    "cmap_name = \"jet\"\n",
    "scm = create_color_step_obj(cmap_name, 10)\n",
    "\n",
    "\n",
    "def plotObject(df, ax, fig, alpha =0.7, scm=None):\n",
    "    ax.clear()\n",
    "    for i in range (0, df.shape[1]):\n",
    "        ax.plot(df.index, df.iloc[:, i], color= scm.to_rgba(i, alpha=alpha),\\\n",
    "                label = 'Layer ' + str(i))\n",
    "        ax.legend(bbox_to_anchor=(0.4,0.8))\n",
    "    fig.canvas.draw()\n",
    "    ax.legend()\n",
    "    #plt.legend(loc='upper left')\n",
    "    return fig, ax\n",
    "    \n",
    "# initialize figure and interactivity\n",
    "fig_size = plt.rcParams[\"figure.figsize\"]\n",
    "fig_size[0] = 5\n",
    "fig = plt.figure()\n",
    "ax = fig.add_subplot(111)\n",
    "plt.ion()\n",
    "\n",
    "fig.show()\n",
    "fig.canvas.draw()\n",
    "ax.legend(loc='best')\n",
    "ax.set_xlabel('Index')\n",
    "ax.set_ylabel('Tem, C', color='r')\n",
    "\n",
    "\n",
    "'''\n",
    "def plotObject(df, ax1,  fig, alpha =0.7, scm=None):\n",
    "    #ax2.clear()\n",
    "    ax1.clear()\n",
    "    for i in range (0, df.shape[1]):\n",
    "        ax1.plot(df.index, df.iloc[:, i], color= scm.to_rgba(i, alpha=alpha),\\\n",
    "                label = 'Layer ' + str(i+1))\n",
    "        ax1.legend(bbox_to_anchor=(0.4,0.8))\n",
    "    \n",
    "    #ax2.plot(dfFlowtem.index, dfFlowtem.iloc[:, 1])\n",
    "    #ax3.plot(dfFlowtem.index, dfFlowtem.iloc[:, 2])\n",
    "    \n",
    "    fig.canvas.draw()\n",
    "    #ax2.legend()\n",
    "    #ax3.legend()\n",
    "    #legend_without_duplicate_labels(ax2)\n",
    "    #plt.legend(loc='upper left')\n",
    "    return fig, ax1, ax2, ax3\n",
    "\n",
    "\n",
    "# initialize figure and interactivity\n",
    "#fig = plt.figure()\n",
    "fig, ax1 = plt.subplots(1)\n",
    "plt.ion()\n",
    "\n",
    "fig.show()\n",
    "fig.canvas.draw()\n",
    "ax1.legend(loc='best')\n",
    "ax1.set_xlabel('Index')\n",
    "ax1.set_ylabel('Tem, C', color='r')\n",
    "\n",
    "\n",
    "ax2.legend(loc='best')\n",
    "ax2.set_xlabel('Index')\n",
    "ax2.set_ylabel('Tank outlet, C', color='r')\n",
    "\n",
    "\n",
    "ax3.legend(loc='best')\n",
    "ax3.set_xlabel('Index')\n",
    "ax3.set_ylabel('TankInletTem, C', color='r')\n",
    "'''\n",
    "\n",
    "#plt.legend(loc='best')\n",
    "\n",
    "\n",
    "while True:\n",
    "    #c.execute(\"INSERT INTO flowReadings(flowHp, flowLoad) VALUES(?,?,?,?)\", (chan2.voltage, chan1.voltage))\n",
    "    #connection.commit()\n",
    "    chan1 = AnalogIn(ads, ADS.P0)\n",
    "    chan2 = AnalogIn(ads, ADS.P1)\n",
    "\n",
    "    chan1Vol = chan1.voltage\n",
    "    chan1curr = chan1Vol/159.42\n",
    "\n",
    "    chan2Vol = chan2.voltage\n",
    "    chan2curr=chan2Vol/159.65\n",
    "    #flow1 = ((chan1Vol/159.42)*1000 -4)/16*1000\n",
    "    flow1 = ((chan1Vol/159.42)-0.003956)/0.0000159\n",
    "    #flow2 = ((chan2Vol/159.65)*1000 -4)/16*4000 +20\n",
    "    #flow2 = ((chan2Vol/159.65)- 0.0005468893873066417)/1.09561608e-05\n",
    "    flow2 = ((chan2Vol/159.65)- 0.003973767754877122)/5.3038815e-06\n",
    "    cL.execute(\"INSERT INTO flowReadings(flowHp, flowLoad) VALUES(%s, %s)\", (flow2, flow1))\n",
    "    connectionL.commit()\n",
    "    #print('flow HP:',\"{:>5}\\t{:>5.3f}\".format(chan2.value, chan2.voltage), '\\n\\n')\n",
    "    #print('flow load:',\"{:>5}\\t{:>5.3f}\".format(chan1.value, chan1.voltage, '\\n\\n'))\n",
    "    print('flow rates load is = ',chan1Vol, chan1curr,flow1 )\n",
    "    print('flow rates HP is = ',chan2Vol, chan2curr,flow2 )\n",
    "\n",
    "    connectionR = db.Connection(host=HOST, port=PORT,user=USER, passwd=PASSWORD, db=DB)\n",
    "    cR = connectionR.cursor()\n",
    "    #c.execute(\"SELECT * from temSensor\")\n",
    "    cR.execute(\"SELECT * FROM temSensor ORDER BY id DESC LIMIT 1\")\n",
    "    result = cR.fetchall()\n",
    "    #print ('result is',result)\n",
    "    id = result[0][0]\n",
    "    idGenerator(id, l_id)\n",
    "    #print ('id is :', id)\n",
    "    flowRateLoad.append(flow1)\n",
    "\n",
    "    if lol[0] ==[] or id < lol[0][-1][0][0] :\n",
    "        lol[0].append(result)\n",
    "        #print (lol)\n",
    "        lol[1].append(flow1)\n",
    "        lol[2].append(flow2)\n",
    "    elif lol[0] != [] and id > lol[0][-1][0][0]:\n",
    "\n",
    "        lol[0].append(result)\n",
    "        lol[1].append(flow1)\n",
    "        lol[2].append(flow2)\n",
    "\n",
    "\n",
    "    mct(lol)\n",
    "    Load = Load_kWh(lol)\n",
    "    #print ('load in kWh is:', Load)\n",
    "    #print ('lol is:',lol)\n",
    "    #print ('df of tem is:',df_tem)\n",
    "    #print ('df is:', tankStrat(dfs(lol)))\n",
    "    df = tankStrat(dfs(lol))\n",
    "    #restTem = InletTem(dfs(lol))\n",
    "    #print (df)\n",
    "    fig, ax = plotObject(df, ax,  fig, alpha=0.7, scm=scm)\n",
    "    print ('df whole is:', dfs(lol))\n",
    "    toCsv(dfs(lol), list2df(Load_kWh(lol), 'Load_kW'), list2df(mct(lol),'Heat_Capacity_kW'))\n",
    "    #print ('df is:', df)\n",
    "    #plot(tankStrat(dfs(lol)), plotObject(tankStrat(dfs(lol))))\n",
    "    #plotObject(tankStrat(dfs(lol)))for i in range (0, 10):\n",
    "    #x = tankStrat(dfs(lol)).index[-1]\n",
    "    #y =tankStrat(dfs(lol)).iloc[-1]\n",
    "    #print ('x is:',x,'y is :',y)\n",
    "    #restTem = InletTem(dfs(lol))\n",
    "    #print ('rets of inlet tem values are:', restTem.iloc[:, 1])\n",
    "    print('________________________________________________________________')\n",
    "    time.sleep(0.05)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "legislative-carolina",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "1+1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "palestinian-trinidad",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}