dwCognitiveIoT.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def readDataFrameFromCloudant(host,user,pw,database):\n",
    "    sparkSession = SQLContext.getOrCreate(sc).sparkSession\n",
    "\n",
    "    cloudantdata=sparkSession.read.format(\"com.cloudant.spark\"). \\\n",
    "    option(\"cloudant.host\",host). \\\n",
    "    option(\"cloudant.username\", user). \\\n",
    "    option(\"cloudant.password\", pw). \\\n",
    "    load(database)\n",
    "\n",
    "    cloudantdata.createOrReplaceTempView(\"washing\")\n",
    "    spark.sql(\"SELECT * from washing\").show()\n",
    "    return cloudantdata"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "+--------------------+--------------------+-----+--------+----------+---------+--------+-----+-----------+-------------+-------+\n",
      "|                 _id|                _rev|count|flowrate|fluidlevel|frequency|hardness|speed|temperature|           ts|voltage|\n",
      "+--------------------+--------------------+-----+--------+----------+---------+--------+-----+-----------+-------------+-------+\n",
      "|0007568c977866188...|1-f5c43083af9779c...|   95|      11|acceptable|     null|      75| null|        100|1489699043697|   null|\n",
      "|0007568c977866188...|1-7feb8945c3d4e0b...|   32|    null|      null|       62|    null| null|       null|1489699044417|    224|\n",
      "|0007568c977866188...|1-3f94674697d81b9...|   33|    null|      null|       74|    null| null|       null|1489699047419|    220|\n",
      "|0007568c977866188...|1-24ae3e443885f51...|   34|    null|      null|       78|    null| null|       null|1489699050422|    235|\n",
      "|0007568c977866188...|1-a35c5dc8dd08737...|  141|      11|acceptable|     null|      74| null|         85|1489699090018|   null|\n",
      "|0007568c977866188...|1-6bc5699b8d0299c...|  157|      11|acceptable|     null|      71| null|         89|1489699106108|   null|\n",
      "|0007568c977866188...|1-14b55d4c8e59181...|  161|      11|acceptable|     null|      76| null|         91|1489699110121|   null|\n",
      "|0007568c977866188...|1-2f83357ddcce3fb...|  181|      11|acceptable|     null|      80| null|         90|1489699130244|   null|\n",
      "|0007568c977866188...|1-09ae66c6bf6341c...|  183|      11|acceptable|     null|      71| null|         95|1489699132252|   null|\n",
      "|0007568c977866188...|1-5ea27c89d9a54c6...|  190|      11|acceptable|     null|      77| null|         88|1489699139280|   null|\n",
      "|0007568c977866188...|1-5d62012eabc99db...|  191|      11|acceptable|     null|      79| null|         96|1489699140287|   null|\n",
      "|0007568c977866188...|1-afb33de520a846f...|   41|    null|      null|     null|    null| 1083|       null|1489699153446|   null|\n",
      "|0007568c977866188...|1-2172fe0eec501d7...|   72|    null|      null|       73|    null| null|       null|1489699164748|    231|\n",
      "|0007568c977866188...|1-ffeaff7fc25dd7b...|   75|    null|      null|       66|    null| null|       null|1489699173756|    236|\n",
      "|0007568c977866188...|1-d216bf5465afaf1...|   14|      11|acceptable|     null|      71| null|         82|1489699199272|   null|\n",
      "|0007568c977866188...|1-4435c2efcc1fc2e...|    5|    null|      null|       78|    null| null|       null|1489699200205|    228|\n",
      "|0007568c977866188...|1-faf13041bbda5e0...|    6|    null|      null|       73|    null| null|       null|1489699203211|    230|\n",
      "|0007568c977866188...|1-338ce7e5a7632bc...|   27|      11|acceptable|     null|      72| null|         83|1489699212348|   null|\n",
      "|0007568c977866188...|1-15cfad02e841e31...|   29|      11|acceptable|     null|      73| null|         99|1489699214355|   null|\n",
      "|0007568c977866188...|1-bbec48a99853431...|   10|    null|      null|       78|    null| null|       null|1489699215235|    222|\n",
      "+--------------------+--------------------+-----+--------+----------+---------+--------+-----+-----------+-------------+-------+\n",
      "only showing top 20 rows\n",
      "\n"
     ]
    }
   ],
   "source": [
    "#TODO Please provide your Cloudant credentials here\n",
    "hostname = \"thisIsTheHostNameOfYourCloudantServiceInBluemix\"\n",
    "user = \"thisIsTheUserNameOfYourCloudantServiceInBluemix\"\n",
    "pw = \"thisIsThePasswordOfYourCloudantServiceInBluemix\"\n",
    "database = \"washing\" #as long as you didn't change this in the NodeRED flow the database name stays the same\n",
    "cloudantdata=readDataFrameFromCloudant(hostname, user, pw, database)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: pixiedust in /usr/local/src/bluemix_jupyter_bundle.v36/notebook/lib/python2.7/site-packages\r\n",
      "Requirement already satisfied: maven-artifact in /usr/local/src/bluemix_jupyter_bundle.v36/notebook/lib/python2.7/site-packages (from pixiedust)\r\n",
      "Requirement already satisfied: mpld3 in /usr/local/src/bluemix_jupyter_bundle.v36/notebook/lib/python2.7/site-packages (from pixiedust)\r\n",
      "Requirement already satisfied: lxml in /usr/local/src/bluemix_jupyter_bundle.v36/notebook/lib/python2.7/site-packages (from maven-artifact->pixiedust)\r\n"
     ]
    }
   ],
   "source": [
    "# install latest local version\n",
    "!pip install pixiedust"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false,
    "pixiedust": {
     "displayParams": {
      "aggregation": "SUM",
      "handlerId": "lineChart",
      "keyFields": "ts",
      "rowCount": "100",
      "showLegend": "true",
      "staticFigure": "false",
      "valueFields": "temperature,flowrate"
     }
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>\n",
       "$(\"#mapOptions7582f31b\").click(function(){\n",
       "    \n",
       "    var globalNested={}\n",
       "require(['base/js/dialog'],function(dialog){\n",
       "        var modal = dialog.modal;\n",
       "        var options = {\n",
       "            title: \"Pixiedust: Chart Options\",\n",
       "            body: '<form id=\"chartOptions7582f31b\"><style type=\"text/css\">\t.field-container {\t}\t.field-container ul {\t\toverflow-y: auto;\t\tborder: 1px solid #ccc;\t\tpadding: 5px 0 0 0;\t\tlist-style-type: none;\t}\t.field-container label {\t\tcolor: #008571;\t\tfont-weight: bold;\t}\t.field-container li {\t\tmargin: 0px 5px 5px 5px;\t\tpadding: 5px;\t\tborder: 1px solid #ccc;\t\tborder-radius: 5px;\t\tbackground-color: #daffff;\t\twidth: auto;\t\tmin-width: 150px;\t}\t.field-remove {\t\tcolor: #777;\t\tfont-size: 14px;\t\tfloat: right;\t\tmargin: 0px;\t\tcursor: pointer;\t}\t.field-remove:after {\t\tcontent: \"x\";\t}</style><div class=\"container col-sm-12\">\t<div class=\"row\">\t\t<div class=\"form-group col-sm-10\" style=\"padding-right:10px;\">\t\t\t<label for=\"title7582f31b\">Chart Title:</label>\t\t\t<input type=\"text\" class=\"form-control\" id=\"title7582f31b\" name=\"title\" value=\"\">\t\t</div>\t\t\t\t<div class=\"form-group col-sm-2\">\t\t\t<label class=\"field\">Static Figure:</label>\t\t\t<select class=\"form-control\" name=\"staticFigure\" style=\"margin-left: 0px;\">\t\t\t\t<option value=\"true\">Yes</option>\t\t\t\t<option value=\"false\" selected>No</option>\t\t\t</select>\t\t</div>\t\t\t</div>\t<div class=\"field-container row\">\t\t<div class=\"col-sm-4\" style=\"padding: 0px 5px 0px 0px;\">\t\t\t<label>Fields:</label>\t\t\t<ul id=\"allFields7582f31b\" style=\"height: 215px;\">\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f1\" class=\"field7582f31b\">_id<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f2\" class=\"field7582f31b\">_rev<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f3\" class=\"field7582f31b\">count<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f4\" class=\"field7582f31b\">flowrate<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f5\" class=\"field7582f31b\">fluidlevel<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f6\" class=\"field7582f31b\">frequency<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f7\" class=\"field7582f31b\">hardness<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f8\" class=\"field7582f31b\">speed<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f9\" class=\"field7582f31b\">temperature<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f10\" class=\"field7582f31b\">ts<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f11\" class=\"field7582f31b\">voltage<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t</ul>\t\t</div>\t\t<div class=\"col-sm-8\" style=\"padding: 0px 0px 0px 5px;\">\t\t\t\t\t\t<label>Keys:</label>\t\t\t<ul id=\"keyFields7582f31b\" style=\"height: 90px;\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f10-keyFields7582f31b\">ts<a class=\"field7582f31b-remove field-remove\"></a></li>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</ul>\t\t\t\t\t\t<label>Values:</label>\t\t\t\t\t\t<ul id=\"valueFields7582f31b\" style=\"height: 90px;\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f9-valueFields7582f31b\">temperature<a class=\"field7582f31b-remove field-remove\"></a></li>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f4-valueFields7582f31b\">flowrate<a class=\"field7582f31b-remove field-remove\"></a></li>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</ul>\t\t</div>\t</div>\t<div class=\"row\">\t\t\t\t\t\t<div class=\"col-sm-4\" style=\"padding: 0px 0px 0px 5px;\">\t\t\t<div class=\"form-group\">\t\t\t\t<label class=\"field\">Aggregation:</label>\t\t\t\t<select class=\"form-control\" name=\"aggregation\" style=\"margin-left: 0px;\">\t\t\t\t\t\t\t\t\t\t<option value=\"SUM\" selected>SUM</option>\t\t\t\t\t\t\t\t\t\t<option value=\"AVG\">AVG</option>\t\t\t\t\t\t\t\t\t\t<option value=\"MIN\">MIN</option>\t\t\t\t\t\t\t\t\t\t<option value=\"MAX\">MAX</option>\t\t\t\t\t\t\t\t\t\t<option value=\"COUNT\">COUNT</option>\t\t\t\t\t\t\t\t\t</select>\t\t\t</div>\t\t</div>\t\t\t\t\t\t<div class=\"col-sm-4\" style=\"padding: 0px 5px 0px 5px;\">\t\t\t<div class=\"form-group\">\t\t\t\t<label class=\"field\"># of Rows to Display:</label>\t\t\t\t<input class=\"form-control\" name=\"rowCount\" type=\"number\" min=\"1\" max=\"1000\" value=\"100\">\t\t\t</div>\t\t</div>\t\t\t\t<div class=\"col-sm-4\" style=\"padding: 0px 0px 0px 5px;\">\t\t\t<div class=\"form-group\">\t\t\t\t<label class=\"field\">Show Legend</label>\t\t\t\t<select class=\"form-control\" name=\"showLegend\" style=\"margin-left: 0px;\">\t\t\t\t\t<option value=\"true\">Yes</option>\t\t\t\t\t<option value=\"false\">No</option>\t\t\t\t</select>\t\t\t</div>\t\t</div>\t\t\t\t\t</div></div></form><div class=\"bootbox-body row\"></div>',\n",
       "            sanitize:false,\n",
       "            notebook: IPython.notebook,\n",
       "            buttons: {\n",
       "                \n",
       "                OK: {\n",
       "                    class : \"btn-primary btn-ok\",\n",
       "                    click: function() {\n",
       "                        \n",
       "(\n",
       "\n",
       "function() {\n",
       "    cellId = typeof cellId === \"undefined\" ? \"\" : cellId;\n",
       "    var curCell=IPython.notebook.get_cells().filter(function(cell){\n",
       "        return cell.cell_id==\"538324236C5541628FFDA97C3C5A0C68\".replace(\"cellId\",cellId);\n",
       "    });\n",
       "    curCell=curCell.length>0?curCell[0]:null;\n",
       "    console.log(\"curCell\",curCell);\n",
       "    var startWallToWall;\n",
       "    //Resend the display command\n",
       "    var callbacks = {\n",
       "        iopub:{\n",
       "            output:function(msg){\n",
       "                console.log(\"msg\", msg);\n",
       "                if (false){\n",
       "                    return curCell.output_area.handle_output.apply(curCell.output_area, arguments);\n",
       "                }\n",
       "                var msg_type=msg.header.msg_type;\n",
       "                var content = msg.content;\n",
       "                var executionTime = $(\"#execution7582f31b\");\n",
       "                if(msg_type===\"stream\"){\n",
       "                    $('#wrapperHTML7582f31b').html(content.text);\n",
       "                }else if (msg_type===\"display_data\" || msg_type===\"execute_result\"){\n",
       "                    var html=null;\n",
       "                    if (!!content.data[\"text/html\"]){\n",
       "                        html=content.data[\"text/html\"];\n",
       "                    }else if (!!content.data[\"image/png\"]){\n",
       "                        html=html||\"\";\n",
       "                        html+=\"<img src='data:image/png;base64,\" +content.data[\"image/png\"]+\"'></img>\";\n",
       "                    }\n",
       "                                                    \n",
       "                    if (!!content.data[\"application/javascript\"]){\n",
       "                        try{\n",
       "                            $('#wrapperJS7582f31b').html(\"<script type=\\\\\\\"text/javascript\\\\\\\">\"+content.data[\"application/javascript\"]+\"</s\" + \"cript>\");\n",
       "                        }catch(e){\n",
       "                            console.log(\"Invalid javascript output\",e, content.data);\n",
       "                        }\n",
       "                    }\n",
       "                    \n",
       "                    if (html){\n",
       "                        if(curCell&&curCell.output_area&&curCell.output_area.outputs){\n",
       "                            var data = JSON.parse(JSON.stringify(content.data));\n",
       "                            if(!!data[\"text/html\"])data[\"text/html\"]=html;\n",
       "                            curCell.output_area.outputs.push({\"data\": data,\"metadata\":content.metadata,\"output_type\":msg_type});\n",
       "                        }\n",
       "                        try{\n",
       "                            $('#wrapperHTML7582f31b').html(html);\n",
       "                        }catch(e){\n",
       "                            console.log(\"Invalid html output\", e, html);\n",
       "                            $('#wrapperHTML7582f31b').html( \"Invalid html output. <pre>\" \n",
       "                                + html.replace(/>/g,'&gt;').replace(/</g,'&lt;').replace(/\"/g,'&quot;') + \"<pre>\");\n",
       "                        }\n",
       "                    }\n",
       "                }else if (msg_type === \"error\") {\n",
       "                    require(['base/js/utils'], function(utils) {\n",
       "                        var tb = content.traceback;\n",
       "                        console.log(\"tb\",tb);\n",
       "                        if (tb && tb.length>0){\n",
       "                            var data = tb.reduce(function(res, frame){return res+frame+'\\\\n';},\"\");\n",
       "                            console.log(\"data\",data);\n",
       "                            data = utils.fixConsole(data);\n",
       "                            data = utils.fixCarriageReturn(data);\n",
       "                            data = utils.autoLinkUrls(data);\n",
       "                            $('#wrapperHTML7582f31b').html(\"<pre>\" + data +\"</pre>\");\n",
       "                        }\n",
       "                    });\n",
       "                }\n",
       "\n",
       "                //Append profiling info\n",
       "                if (executionTime.length > 0 && $(\"#execution7582f31b\").length == 0 ){\n",
       "                    $('#wrapperHTML7582f31b').append(executionTime);\n",
       "                }else if (startWallToWall && $(\"#execution7582f31b\").length > 0 ){\n",
       "                    $(\"#execution7582f31b\").append($(\"<div/>\").text(\"Wall to Wall time: \" + ( (new Date().getTime() - startWallToWall)/1000 ) + \"s\"));\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    }\n",
       "    \n",
       "    if (IPython && IPython.notebook && IPython.notebook.session && IPython.notebook.session.kernel){\n",
       "        var command = \"display(cloudantdata,cell_id='538324236C5541628FFDA97C3C5A0C68',handlerId='lineChart',prefix='7582f31b',keyFields='ts',valueFields='temperature,flowrate',staticFigure='false',aggregation='SUM',rowCount='100',showLegend='true')\".replace(\"cellId\",cellId);\n",
       "        function addOptions(options){\n",
       "            function getStringRep(v) {\n",
       "                if (!isNaN(parseFloat(v)) && isFinite(v)){\n",
       "                    return v.toString();\n",
       "                }\n",
       "                return \"'\" + v + \"'\";\n",
       "            }\n",
       "            for (var key in options){\n",
       "                var value = options[key];\n",
       "                var hasValue = value != null && typeof value !== 'undefined' && value !== '';\n",
       "                var replaceValue = hasValue ? (key+\"=\" + getStringRep(value) ) : \"\";\n",
       "                var pattern = (hasValue?\"\":\",\")+\"\\\\s*\" + key + \"\\\\s*=\\\\s*'(\\\\\\\\'|[^'])*'\";\n",
       "                var rpattern=new RegExp(pattern);\n",
       "                var n = command.search(rpattern);\n",
       "                if ( n >= 0 ){\n",
       "                    command = command.replace(rpattern, replaceValue);\n",
       "                }else if (hasValue){\n",
       "                    var n = command.lastIndexOf(\")\");\n",
       "                    command = [command.slice(0, n), (command[n-1]==\"(\"? \"\":\",\") + replaceValue, command.slice(n)].join('')\n",
       "                }        \n",
       "            }\n",
       "        }\n",
       "        if(typeof cellMetadata != \"undefined\" && cellMetadata.displayParams){\n",
       "            addOptions(cellMetadata.displayParams);\n",
       "            addOptions({\"showchrome\":\"true\"});\n",
       "        }\n",
       "        addOptions({});\n",
       "        \n",
       "        \n",
       "    \n",
       "var addValueToCommand = function(name, value) {\n",
       "    if (value) {\n",
       "        var startIndex, endIndex;\n",
       "        startIndex = command.indexOf(\",\"+name+\"=\");\n",
       "        if (startIndex >= 0) {\n",
       "            commaIndex = command.indexOf(\",\", startIndex+1);\n",
       "            quoteIndex = command.indexOf(\"'\", startIndex+1);\n",
       "            if (quoteIndex >=0 && quoteIndex < commaIndex) {\n",
       "                // value is enclosed in quotes - end of value will be second quote\n",
       "                endIndex = command.indexOf(\"'\", quoteIndex+1) + 1;\n",
       "            }\n",
       "            else if (commaIndex >= 0) {\n",
       "                // end of value is the comma\n",
       "                endIndex = commaIndex;\n",
       "            }\n",
       "            else {\n",
       "                // no quote or comma found - end of value is at the very end\n",
       "                endIndex = command.indexOf(\")\", startIndex+1);\n",
       "            }\n",
       "        }\n",
       "        else {\n",
       "            startIndex = endIndex = command.lastIndexOf(\")\");\n",
       "        }\n",
       "        var start = command.substring(0,startIndex);\n",
       "        var end = command.substring(endIndex);\n",
       "        command = start + \",\" + name +\"='\" + value + \"'\" + end;\n",
       "    }\n",
       "    else {\n",
       "        var startIndex, endIndex;\n",
       "        startIndex = command.indexOf(\",\"+name+\"=\");\n",
       "        if (startIndex >= 0) {\n",
       "            commaIndex = command.indexOf(\",\", startIndex+1);\n",
       "            quoteIndex = command.indexOf(\"'\", startIndex+1);\n",
       "            if (quoteIndex >=0 && quoteIndex < commaIndex) {\n",
       "                // value is enclosed in quotes - end of value will be second quote\n",
       "                endIndex = command.indexOf(\"'\", quoteIndex+1) + 1;\n",
       "            }\n",
       "            else if (commaIndex >= 0) {\n",
       "                // end of value is the comma\n",
       "                endIndex = commaIndex;\n",
       "            }\n",
       "            else {\n",
       "                // no quote or comma found - end of value is at the very end\n",
       "                endIndex = command.indexOf(\")\", startIndex+1);\n",
       "            }\n",
       "            var start = command.substring(0,startIndex);\n",
       "            var end = command.substring(endIndex);\n",
       "            command = start + end;\n",
       "        }\n",
       "    }\n",
       "};\n",
       "var getListValues = function(listId) {\n",
       "    var value = '';\n",
       "    $(listId + ' li').each(function(idx, li) {\n",
       "        if (value.length != 0) {\n",
       "            value += ',';\n",
       "        }\n",
       "        value += $(li).text();\n",
       "    });\n",
       "    return value;\n",
       "};\n",
       "addValueToCommand('keyFields',getListValues('#keyFields7582f31b'));\n",
       "addValueToCommand('valueFields',getListValues('#valueFields7582f31b'));\n",
       "$('#chartOptions7582f31b *').filter(':input').each(function(){\n",
       "    if ($(this).is(':checkbox')) {\n",
       "        addValueToCommand($(this).attr('name'),$(this).is(':checked')+'');\t\n",
       "    }\n",
       "    else {\n",
       "        addValueToCommand($(this).attr('name'),$(this).val());\n",
       "    }\n",
       "});\n",
       "$('#chartOptions7582f31b *').filter('select').each(function(){\n",
       "    addValueToCommand($(this).attr('name'),$(this).val());\n",
       "});\n",
       "\n",
       "\n",
       "        console.log(\"Running command2\",command);\n",
       "        var pattern = \"\\\\w*\\\\s*=\\\\s*'(\\\\\\\\'|[^'])*'\";\n",
       "        var rpattern=new RegExp(pattern,\"g\");\n",
       "        var n = command.match(rpattern);\n",
       "        var displayParams={}\n",
       "        for (var i = 0; i < n.length; i++){\n",
       "            var parts=n[i].split(\"=\");\n",
       "            var key = parts[0].trim();\n",
       "            var value = parts[1].trim()\n",
       "            if (!key.startsWith(\"nostore_\") && key != \"showchrome\" && key != \"prefix\" && key != \"cell_id\"){\n",
       "                displayParams[key] = value.substring(1,value.length-1);\n",
       "            }\n",
       "        }\n",
       "        if(curCell&&curCell.output_area){\n",
       "            curCell._metadata.pixiedust = curCell._metadata.pixiedust || {}\n",
       "            curCell._metadata.pixiedust.displayParams=displayParams\n",
       "            curCell.output_area.outputs=[];\n",
       "        }\n",
       "        $('#wrapperJS7582f31b').html(\"\")\n",
       "        $('#wrapperHTML7582f31b').html('<div style=\"width:100px;height:60px;left:47%;position:relative\"><i class=\"fa fa-circle-o-notch fa-spin\" style=\"font-size:48px\"></i></div>'+\n",
       "        '<div style=\"text-align:center\">Loading your data. Please wait...</div>');\n",
       "        startWallToWall = new Date().getTime();\n",
       "        IPython.notebook.session.kernel.execute(command, callbacks, {silent:false,store_history:false,stop_on_error:true});\n",
       "    }\n",
       "}\n",
       ")()\n",
       "\n",
       "                    }\n",
       "                },\n",
       "                Cancel: {\n",
       "                    class : \"btn-cancel\",\n",
       "                    click: function(){\n",
       "                        \n",
       "                    }\n",
       "                }\n",
       "                \n",
       "            }\n",
       "        };\n",
       "        var modal_obj = modal(options);\n",
       "        modal_obj.addClass('pixiedust');\n",
       "        modal_obj.on('shown.bs.modal', function(){\n",
       "            \n",
       "$('#chartOptions7582f31b *').filter(':input').each(function(){\n",
       "\tIPython.keyboard_manager.register_events($(this));\n",
       "});\n",
       "$('.field7582f31b').draggable({\n",
       "\thelper:\"clone\",\n",
       "\tcontainment:\"document\"\n",
       "});\n",
       "$('.field7582f31b-remove').click(function(e) {\n",
       "\te.preventDefault();\n",
       "\t$(this).parent().remove();\n",
       "\treturn false;\n",
       "});\n",
       "$('#keyFields7582f31b, #valueFields7582f31b').droppable({\n",
       "\tdrop:function(event, ui) {\n",
       "\t\tvar newId = ui.draggable.attr('id') + '-' + $(this).attr('id');\n",
       "\t\tif ( $('#'+newId).length == 0) { \n",
       "\t\t\tvar el = ui.draggable.clone(true, true);\n",
       "\t\t\tel.attr(\"id\",newId);\n",
       "\t\t\tel.find(\"a\").addClass(\"field-remove\");\n",
       "\t\t\tel.appendTo($(this));\n",
       "\t\t}\n",
       "\t}\n",
       "});\n",
       "\n",
       "        });\n",
       "\n",
       "        })\n",
       "\n",
       "});\n",
       "</script>\n",
       "<button id=\"mapOptions7582f31b\">Options</button>\n",
       "\n",
       "\n",
       "<style>\n",
       "\n",
       "</style>\n",
       "\n",
       "<div id=\"fig_el392831401358718993448750349467\"></div>\n",
       "<script>\n",
       "function mpld3_load_lib(url, callback){\n",
       "  var s = document.createElement('script');\n",
       "  s.src = url;\n",
       "  s.async = true;\n",
       "  s.onreadystatechange = s.onload = callback;\n",
       "  s.onerror = function(){console.warn(\"failed to load library \" + url);};\n",
       "  document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "}\n",
       "\n",
       "if(typeof(mpld3) !== \"undefined\" && mpld3._mpld3IsLoaded){\n",
       "   // already loaded: just create the figure\n",
       "   !function(mpld3){\n",
       "       // don't remove this comment\n",
       "mpld3.register_plugin(\"chart\", ChartPlugin);\n",
       "ChartPlugin.prototype = Object.create(mpld3.Plugin.prototype);\n",
       "ChartPlugin.prototype.constructor = ChartPlugin;\n",
       "ChartPlugin.prototype.requiredProps = [\"labels\"];\n",
       "function ChartPlugin(fig, props){\n",
       "\tmpld3.Plugin.call(this, fig, props);\n",
       "};\n",
       "ChartPlugin.prototype.draw = function(){\n",
       "\ttry{\n",
       "\t\t// FIXME: this is a very brittle way to select the x-axis element\n",
       "\t\tvar ax = this.fig.axes[0].elements[0];\n",
       "\n",
       "\t\t// getting the labels for xticks\n",
       "\t\tvar labels =  this.props.labels;\n",
       "\t\tconsole.info(\"labels: \"+labels);\n",
       "\t\t\n",
       "\t\t// see https://github.com/mbostock/d3/wiki/Formatting#d3_format\n",
       "\t\t// for d3js formating documentation\n",
       "\t\tax.axis.tickFormat(function(d){\n",
       "\t\t\ttry{\n",
       "\t\t\t\treturn labels[Math.floor(d)];\n",
       "\t\t\t}catch(e){\n",
       "\t\t\t\tconsole.log(e)\n",
       "\t\t\t}\n",
       "\t\t});\n",
       "\t\tax.axis.ticks(labels.length);\n",
       "\n",
       "\t\t// HACK: use reset to redraw figure\n",
       "\t\tthis.fig.reset(); \n",
       "\t}catch(e){\n",
       "\t\tconsole.log(e);\n",
       "\t}\n",
       "}// don't remove this comment\n",
       "mpld3.register_plugin(\"dialog\", DialogPlugin);\n",
       "DialogPlugin.prototype = Object.create(mpld3.Plugin.prototype);\n",
       "DialogPlugin.prototype.constructor = DialogPlugin;\n",
       "DialogPlugin.prototype.requiredProps = [\"handlerId\"];    \n",
       "function DialogPlugin(fig, props) {\n",
       "    mpld3.Plugin.call(this, fig, props);\n",
       "    var DialogPluginButton = mpld3.ButtonFactory({\n",
       "        buttonID: \"DialogPlugin\",\n",
       "        sticky: false,\n",
       "        onActivate: function() {\n",
       "            \n",
       "    var globalNested={}\n",
       "require(['base/js/dialog'],function(dialog){\n",
       "        var modal = dialog.modal;\n",
       "        var options = {\n",
       "            title: \"Pixiedust: Chart Options\",\n",
       "            body: '<form id=\"chartOptions7582f31b\"><style type=\"text/css\">\t.field-container {\t}\t.field-container ul {\t\toverflow-y: auto;\t\tborder: 1px solid #ccc;\t\tpadding: 5px 0 0 0;\t\tlist-style-type: none;\t}\t.field-container label {\t\tcolor: #008571;\t\tfont-weight: bold;\t}\t.field-container li {\t\tmargin: 0px 5px 5px 5px;\t\tpadding: 5px;\t\tborder: 1px solid #ccc;\t\tborder-radius: 5px;\t\tbackground-color: #daffff;\t\twidth: auto;\t\tmin-width: 150px;\t}\t.field-remove {\t\tcolor: #777;\t\tfont-size: 14px;\t\tfloat: right;\t\tmargin: 0px;\t\tcursor: pointer;\t}\t.field-remove:after {\t\tcontent: \"x\";\t}</style><div class=\"container col-sm-12\">\t<div class=\"row\">\t\t<div class=\"form-group col-sm-10\" style=\"padding-right:10px;\">\t\t\t<label for=\"title7582f31b\">Chart Title:</label>\t\t\t<input type=\"text\" class=\"form-control\" id=\"title7582f31b\" name=\"title\" value=\"\">\t\t</div>\t\t\t\t<div class=\"form-group col-sm-2\">\t\t\t<label class=\"field\">Static Figure:</label>\t\t\t<select class=\"form-control\" name=\"staticFigure\" style=\"margin-left: 0px;\">\t\t\t\t<option value=\"true\">Yes</option>\t\t\t\t<option value=\"false\" selected>No</option>\t\t\t</select>\t\t</div>\t\t\t</div>\t<div class=\"field-container row\">\t\t<div class=\"col-sm-4\" style=\"padding: 0px 5px 0px 0px;\">\t\t\t<label>Fields:</label>\t\t\t<ul id=\"allFields7582f31b\" style=\"height: 215px;\">\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f1\" class=\"field7582f31b\">_id<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f2\" class=\"field7582f31b\">_rev<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f3\" class=\"field7582f31b\">count<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f4\" class=\"field7582f31b\">flowrate<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f5\" class=\"field7582f31b\">fluidlevel<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f6\" class=\"field7582f31b\">frequency<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f7\" class=\"field7582f31b\">hardness<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f8\" class=\"field7582f31b\">speed<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f9\" class=\"field7582f31b\">temperature<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f10\" class=\"field7582f31b\">ts<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f11\" class=\"field7582f31b\">voltage<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t</ul>\t\t</div>\t\t<div class=\"col-sm-8\" style=\"padding: 0px 0px 0px 5px;\">\t\t\t\t\t\t<label>Keys:</label>\t\t\t<ul id=\"keyFields7582f31b\" style=\"height: 90px;\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f10-keyFields7582f31b\">ts<a class=\"field7582f31b-remove field-remove\"></a></li>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</ul>\t\t\t\t\t\t<label>Values:</label>\t\t\t\t\t\t<ul id=\"valueFields7582f31b\" style=\"height: 90px;\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f9-valueFields7582f31b\">temperature<a class=\"field7582f31b-remove field-remove\"></a></li>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f4-valueFields7582f31b\">flowrate<a class=\"field7582f31b-remove field-remove\"></a></li>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</ul>\t\t</div>\t</div>\t<div class=\"row\">\t\t\t\t\t\t<div class=\"col-sm-4\" style=\"padding: 0px 0px 0px 5px;\">\t\t\t<div class=\"form-group\">\t\t\t\t<label class=\"field\">Aggregation:</label>\t\t\t\t<select class=\"form-control\" name=\"aggregation\" style=\"margin-left: 0px;\">\t\t\t\t\t\t\t\t\t\t<option value=\"SUM\" selected>SUM</option>\t\t\t\t\t\t\t\t\t\t<option value=\"AVG\">AVG</option>\t\t\t\t\t\t\t\t\t\t<option value=\"MIN\">MIN</option>\t\t\t\t\t\t\t\t\t\t<option value=\"MAX\">MAX</option>\t\t\t\t\t\t\t\t\t\t<option value=\"COUNT\">COUNT</option>\t\t\t\t\t\t\t\t\t</select>\t\t\t</div>\t\t</div>\t\t\t\t\t\t<div class=\"col-sm-4\" style=\"padding: 0px 5px 0px 5px;\">\t\t\t<div class=\"form-group\">\t\t\t\t<label class=\"field\"># of Rows to Display:</label>\t\t\t\t<input class=\"form-control\" name=\"rowCount\" type=\"number\" min=\"1\" max=\"1000\" value=\"100\">\t\t\t</div>\t\t</div>\t\t\t\t<div class=\"col-sm-4\" style=\"padding: 0px 0px 0px 5px;\">\t\t\t<div class=\"form-group\">\t\t\t\t<label class=\"field\">Show Legend</label>\t\t\t\t<select class=\"form-control\" name=\"showLegend\" style=\"margin-left: 0px;\">\t\t\t\t\t<option value=\"true\">Yes</option>\t\t\t\t\t<option value=\"false\">No</option>\t\t\t\t</select>\t\t\t</div>\t\t</div>\t\t\t\t\t</div></div></form><div class=\"bootbox-body row\"></div>',\n",
       "            sanitize:false,\n",
       "            notebook: IPython.notebook,\n",
       "            buttons: {\n",
       "                \n",
       "                OK: {\n",
       "                    class : \"btn-primary btn-ok\",\n",
       "                    click: function() {\n",
       "                        \n",
       "(\n",
       "\n",
       "function() {\n",
       "    cellId = typeof cellId === \"undefined\" ? \"\" : cellId;\n",
       "    var curCell=IPython.notebook.get_cells().filter(function(cell){\n",
       "        return cell.cell_id==\"538324236C5541628FFDA97C3C5A0C68\".replace(\"cellId\",cellId);\n",
       "    });\n",
       "    curCell=curCell.length>0?curCell[0]:null;\n",
       "    console.log(\"curCell\",curCell);\n",
       "    var startWallToWall;\n",
       "    //Resend the display command\n",
       "    var callbacks = {\n",
       "        iopub:{\n",
       "            output:function(msg){\n",
       "                console.log(\"msg\", msg);\n",
       "                if (false){\n",
       "                    return curCell.output_area.handle_output.apply(curCell.output_area, arguments);\n",
       "                }\n",
       "                var msg_type=msg.header.msg_type;\n",
       "                var content = msg.content;\n",
       "                var executionTime = $(\"#execution7582f31b\");\n",
       "                if(msg_type===\"stream\"){\n",
       "                    $('#wrapperHTML7582f31b').html(content.text);\n",
       "                }else if (msg_type===\"display_data\" || msg_type===\"execute_result\"){\n",
       "                    var html=null;\n",
       "                    if (!!content.data[\"text/html\"]){\n",
       "                        html=content.data[\"text/html\"];\n",
       "                    }else if (!!content.data[\"image/png\"]){\n",
       "                        html=html||\"\";\n",
       "                        html+=\"<img src='data:image/png;base64,\" +content.data[\"image/png\"]+\"'></img>\";\n",
       "                    }\n",
       "                                                    \n",
       "                    if (!!content.data[\"application/javascript\"]){\n",
       "                        try{\n",
       "                            $('#wrapperJS7582f31b').html(\"<script type=\\\\\\\"text/javascript\\\\\\\">\"+content.data[\"application/javascript\"]+\"</s\" + \"cript>\");\n",
       "                        }catch(e){\n",
       "                            console.log(\"Invalid javascript output\",e, content.data);\n",
       "                        }\n",
       "                    }\n",
       "                    \n",
       "                    if (html){\n",
       "                        if(curCell&&curCell.output_area&&curCell.output_area.outputs){\n",
       "                            var data = JSON.parse(JSON.stringify(content.data));\n",
       "                            if(!!data[\"text/html\"])data[\"text/html\"]=html;\n",
       "                            curCell.output_area.outputs.push({\"data\": data,\"metadata\":content.metadata,\"output_type\":msg_type});\n",
       "                        }\n",
       "                        try{\n",
       "                            $('#wrapperHTML7582f31b').html(html);\n",
       "                        }catch(e){\n",
       "                            console.log(\"Invalid html output\", e, html);\n",
       "                            $('#wrapperHTML7582f31b').html( \"Invalid html output. <pre>\" \n",
       "                                + html.replace(/>/g,'&gt;').replace(/</g,'&lt;').replace(/\"/g,'&quot;') + \"<pre>\");\n",
       "                        }\n",
       "                    }\n",
       "                }else if (msg_type === \"error\") {\n",
       "                    require(['base/js/utils'], function(utils) {\n",
       "                        var tb = content.traceback;\n",
       "                        console.log(\"tb\",tb);\n",
       "                        if (tb && tb.length>0){\n",
       "                            var data = tb.reduce(function(res, frame){return res+frame+'\\\\n';},\"\");\n",
       "                            console.log(\"data\",data);\n",
       "                            data = utils.fixConsole(data);\n",
       "                            data = utils.fixCarriageReturn(data);\n",
       "                            data = utils.autoLinkUrls(data);\n",
       "                            $('#wrapperHTML7582f31b').html(\"<pre>\" + data +\"</pre>\");\n",
       "                        }\n",
       "                    });\n",
       "                }\n",
       "\n",
       "                //Append profiling info\n",
       "                if (executionTime.length > 0 && $(\"#execution7582f31b\").length == 0 ){\n",
       "                    $('#wrapperHTML7582f31b').append(executionTime);\n",
       "                }else if (startWallToWall && $(\"#execution7582f31b\").length > 0 ){\n",
       "                    $(\"#execution7582f31b\").append($(\"<div/>\").text(\"Wall to Wall time: \" + ( (new Date().getTime() - startWallToWall)/1000 ) + \"s\"));\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    }\n",
       "    \n",
       "    if (IPython && IPython.notebook && IPython.notebook.session && IPython.notebook.session.kernel){\n",
       "        var command = \"display(cloudantdata,cell_id='538324236C5541628FFDA97C3C5A0C68',handlerId='lineChart',prefix='7582f31b',keyFields='ts',valueFields='temperature,flowrate',staticFigure='false',aggregation='SUM',rowCount='100',showLegend='true')\".replace(\"cellId\",cellId);\n",
       "        function addOptions(options){\n",
       "            function getStringRep(v) {\n",
       "                if (!isNaN(parseFloat(v)) && isFinite(v)){\n",
       "                    return v.toString();\n",
       "                }\n",
       "                return \"'\" + v + \"'\";\n",
       "            }\n",
       "            for (var key in options){\n",
       "                var value = options[key];\n",
       "                var hasValue = value != null && typeof value !== 'undefined' && value !== '';\n",
       "                var replaceValue = hasValue ? (key+\"=\" + getStringRep(value) ) : \"\";\n",
       "                var pattern = (hasValue?\"\":\",\")+\"\\\\s*\" + key + \"\\\\s*=\\\\s*'(\\\\\\\\'|[^'])*'\";\n",
       "                var rpattern=new RegExp(pattern);\n",
       "                var n = command.search(rpattern);\n",
       "                if ( n >= 0 ){\n",
       "                    command = command.replace(rpattern, replaceValue);\n",
       "                }else if (hasValue){\n",
       "                    var n = command.lastIndexOf(\")\");\n",
       "                    command = [command.slice(0, n), (command[n-1]==\"(\"? \"\":\",\") + replaceValue, command.slice(n)].join('')\n",
       "                }        \n",
       "            }\n",
       "        }\n",
       "        if(typeof cellMetadata != \"undefined\" && cellMetadata.displayParams){\n",
       "            addOptions(cellMetadata.displayParams);\n",
       "            addOptions({\"showchrome\":\"true\"});\n",
       "        }\n",
       "        addOptions({});\n",
       "        \n",
       "        \n",
       "    \n",
       "var addValueToCommand = function(name, value) {\n",
       "    if (value) {\n",
       "        var startIndex, endIndex;\n",
       "        startIndex = command.indexOf(\",\"+name+\"=\");\n",
       "        if (startIndex >= 0) {\n",
       "            commaIndex = command.indexOf(\",\", startIndex+1);\n",
       "            quoteIndex = command.indexOf(\"'\", startIndex+1);\n",
       "            if (quoteIndex >=0 && quoteIndex < commaIndex) {\n",
       "                // value is enclosed in quotes - end of value will be second quote\n",
       "                endIndex = command.indexOf(\"'\", quoteIndex+1) + 1;\n",
       "            }\n",
       "            else if (commaIndex >= 0) {\n",
       "                // end of value is the comma\n",
       "                endIndex = commaIndex;\n",
       "            }\n",
       "            else {\n",
       "                // no quote or comma found - end of value is at the very end\n",
       "                endIndex = command.indexOf(\")\", startIndex+1);\n",
       "            }\n",
       "        }\n",
       "        else {\n",
       "            startIndex = endIndex = command.lastIndexOf(\")\");\n",
       "        }\n",
       "        var start = command.substring(0,startIndex);\n",
       "        var end = command.substring(endIndex);\n",
       "        command = start + \",\" + name +\"='\" + value + \"'\" + end;\n",
       "    }\n",
       "    else {\n",
       "        var startIndex, endIndex;\n",
       "        startIndex = command.indexOf(\",\"+name+\"=\");\n",
       "        if (startIndex >= 0) {\n",
       "            commaIndex = command.indexOf(\",\", startIndex+1);\n",
       "            quoteIndex = command.indexOf(\"'\", startIndex+1);\n",
       "            if (quoteIndex >=0 && quoteIndex < commaIndex) {\n",
       "                // value is enclosed in quotes - end of value will be second quote\n",
       "                endIndex = command.indexOf(\"'\", quoteIndex+1) + 1;\n",
       "            }\n",
       "            else if (commaIndex >= 0) {\n",
       "                // end of value is the comma\n",
       "                endIndex = commaIndex;\n",
       "            }\n",
       "            else {\n",
       "                // no quote or comma found - end of value is at the very end\n",
       "                endIndex = command.indexOf(\")\", startIndex+1);\n",
       "            }\n",
       "            var start = command.substring(0,startIndex);\n",
       "            var end = command.substring(endIndex);\n",
       "            command = start + end;\n",
       "        }\n",
       "    }\n",
       "};\n",
       "var getListValues = function(listId) {\n",
       "    var value = '';\n",
       "    $(listId + ' li').each(function(idx, li) {\n",
       "        if (value.length != 0) {\n",
       "            value += ',';\n",
       "        }\n",
       "        value += $(li).text();\n",
       "    });\n",
       "    return value;\n",
       "};\n",
       "addValueToCommand('keyFields',getListValues('#keyFields7582f31b'));\n",
       "addValueToCommand('valueFields',getListValues('#valueFields7582f31b'));\n",
       "$('#chartOptions7582f31b *').filter(':input').each(function(){\n",
       "    if ($(this).is(':checkbox')) {\n",
       "        addValueToCommand($(this).attr('name'),$(this).is(':checked')+'');\t\n",
       "    }\n",
       "    else {\n",
       "        addValueToCommand($(this).attr('name'),$(this).val());\n",
       "    }\n",
       "});\n",
       "$('#chartOptions7582f31b *').filter('select').each(function(){\n",
       "    addValueToCommand($(this).attr('name'),$(this).val());\n",
       "});\n",
       "\n",
       "\n",
       "        console.log(\"Running command2\",command);\n",
       "        var pattern = \"\\\\w*\\\\s*=\\\\s*'(\\\\\\\\'|[^'])*'\";\n",
       "        var rpattern=new RegExp(pattern,\"g\");\n",
       "        var n = command.match(rpattern);\n",
       "        var displayParams={}\n",
       "        for (var i = 0; i < n.length; i++){\n",
       "            var parts=n[i].split(\"=\");\n",
       "            var key = parts[0].trim();\n",
       "            var value = parts[1].trim()\n",
       "            if (!key.startsWith(\"nostore_\") && key != \"showchrome\" && key != \"prefix\" && key != \"cell_id\"){\n",
       "                displayParams[key] = value.substring(1,value.length-1);\n",
       "            }\n",
       "        }\n",
       "        if(curCell&&curCell.output_area){\n",
       "            curCell._metadata.pixiedust = curCell._metadata.pixiedust || {}\n",
       "            curCell._metadata.pixiedust.displayParams=displayParams\n",
       "            curCell.output_area.outputs=[];\n",
       "        }\n",
       "        $('#wrapperJS7582f31b').html(\"\")\n",
       "        $('#wrapperHTML7582f31b').html('<div style=\"width:100px;height:60px;left:47%;position:relative\"><i class=\"fa fa-circle-o-notch fa-spin\" style=\"font-size:48px\"></i></div>'+\n",
       "        '<div style=\"text-align:center\">Loading your data. Please wait...</div>');\n",
       "        startWallToWall = new Date().getTime();\n",
       "        IPython.notebook.session.kernel.execute(command, callbacks, {silent:false,store_history:false,stop_on_error:true});\n",
       "    }\n",
       "}\n",
       ")()\n",
       "\n",
       "                    }\n",
       "                },\n",
       "                Cancel: {\n",
       "                    class : \"btn-cancel\",\n",
       "                    click: function(){\n",
       "                        \n",
       "                    }\n",
       "                }\n",
       "                \n",
       "            }\n",
       "        };\n",
       "        var modal_obj = modal(options);\n",
       "        modal_obj.addClass('pixiedust');\n",
       "        modal_obj.on('shown.bs.modal', function(){\n",
       "            \n",
       "$('#chartOptions7582f31b *').filter(':input').each(function(){\n",
       "\tIPython.keyboard_manager.register_events($(this));\n",
       "});\n",
       "$('.field7582f31b').draggable({\n",
       "\thelper:\"clone\",\n",
       "\tcontainment:\"document\"\n",
       "});\n",
       "$('.field7582f31b-remove').click(function(e) {\n",
       "\te.preventDefault();\n",
       "\t$(this).parent().remove();\n",
       "\treturn false;\n",
       "});\n",
       "$('#keyFields7582f31b, #valueFields7582f31b').droppable({\n",
       "\tdrop:function(event, ui) {\n",
       "\t\tvar newId = ui.draggable.attr('id') + '-' + $(this).attr('id');\n",
       "\t\tif ( $('#'+newId).length == 0) { \n",
       "\t\t\tvar el = ui.draggable.clone(true, true);\n",
       "\t\t\tel.attr(\"id\",newId);\n",
       "\t\t\tel.find(\"a\").addClass(\"field-remove\");\n",
       "\t\t\tel.appendTo($(this));\n",
       "\t\t}\n",
       "\t}\n",
       "});\n",
       "\n",
       "        });\n",
       "\n",
       "        })\n",
       "\n",
       "        },\n",
       "        icon: function() {\n",
       "            return mpld3.icons[\"brush\"];\n",
       "        }\n",
       "    });\n",
       "    this.fig.buttons.push(DialogPluginButton);\n",
       "}\n",
       "       mpld3.draw_figure(\"fig_el392831401358718993448750349467\", {\"axes\": [{\"xlim\": [0.0, 1489614090000.0], \"yscale\": \"linear\", \"axesbg\": \"#FFFFFF\", \"texts\": [{\"v_baseline\": \"hanging\", \"h_anchor\": \"middle\", \"color\": \"#000000\", \"text\": \"ts\", \"coordinates\": \"axes\", \"zorder\": 3, \"alpha\": 1, \"fontsize\": 18.0, \"position\": [0.5, -0.059895833333333329], \"rotation\": -0.0, \"id\": \"el39283140135868045520\"}, {\"v_baseline\": \"auto\", \"h_anchor\": \"start\", \"color\": \"#00007F\", \"text\": \"temperature\", \"coordinates\": \"axes\", \"zorder\": 1000003.0, \"alpha\": 1, \"fontsize\": 14.399999999999999, \"position\": [0.7920698924731181, 0.93124999999999991], \"rotation\": -0.0, \"id\": \"el39283140134522198032\"}, {\"v_baseline\": \"auto\", \"h_anchor\": \"start\", \"color\": \"#000088\", \"text\": \"flowrate\", \"coordinates\": \"axes\", \"zorder\": 1000003.0, \"alpha\": 1, \"fontsize\": 14.399999999999999, \"position\": [0.7920698924731181, 0.87135416666666654], \"rotation\": -0.0, \"id\": \"el39283140134522199952\"}], \"zoomable\": true, \"images\": [], \"xdomain\": [0.0, 1489614090000.0], \"ylim\": [10.0, 100.0], \"paths\": [{\"edgecolor\": \"none\", \"facecolor\": \"none\", \"edgewidth\": 1.0, \"pathcodes\": [\"M\", \"L\", \"L\", \"L\", \"Z\"], \"yindex\": 1, \"coordinates\": \"axes\", \"dasharray\": \"10,0\", \"zorder\": 1000001.0, \"alpha\": 0, \"xindex\": 0, \"data\": \"data03\", \"id\": \"el39283140134522197648\"}], \"sharey\": [], \"sharex\": [], \"axesbgalpha\": null, \"axes\": [{\"scale\": \"linear\", \"tickformat\": null, \"grid\": {\"color\": \"#D3D3D3\", \"alpha\": 0.7, \"dasharray\": \"2,2\", \"gridOn\": true}, \"fontsize\": 12.0, \"position\": \"bottom\", \"nticks\": 100, \"tickvalues\": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99]}, {\"scale\": \"linear\", \"tickformat\": null, \"grid\": {\"color\": \"#D3D3D3\", \"alpha\": 0.7, \"dasharray\": \"2,2\", \"gridOn\": true}, \"fontsize\": 12.0, \"position\": \"left\", \"nticks\": 10, \"tickvalues\": null}], \"lines\": [{\"color\": \"#00007F\", \"yindex\": 1, \"coordinates\": \"data\", \"dasharray\": \"10,0\", \"zorder\": 2, \"alpha\": 1, \"xindex\": 0, \"linewidth\": 1.0, \"data\": \"data01\", \"id\": \"el39283140134784094800\"}, {\"color\": \"#000088\", \"yindex\": 2, \"coordinates\": \"data\", \"dasharray\": \"10,0\", \"zorder\": 2, \"alpha\": 1, \"xindex\": 0, \"linewidth\": 1.0, \"data\": \"data01\", \"id\": \"el39283140134784096336\"}, {\"color\": \"#00007F\", \"yindex\": 1, \"coordinates\": \"axes\", \"dasharray\": \"10,0\", \"zorder\": 1000002.0, \"alpha\": 1, \"xindex\": 0, \"linewidth\": 10.0, \"data\": \"data02\", \"id\": \"el39283140134522198544\"}, {\"color\": \"#000088\", \"yindex\": 2, \"coordinates\": \"axes\", \"dasharray\": \"10,0\", \"zorder\": 1000002.0, \"alpha\": 1, \"xindex\": 0, \"linewidth\": 10.0, \"data\": \"data02\", \"id\": \"el39283140134521586128\"}], \"markers\": [{\"edgecolor\": \"#000000\", \"facecolor\": \"#00007F\", \"edgewidth\": 0.5, \"yindex\": 1, \"coordinates\": \"data\", \"zorder\": 2, \"markerpath\": [[[0.0, 3.0], [0.7956093000000001, 3.0], [1.5587396123545605, 2.683901074764725], [2.121320343559643, 2.121320343559643], [2.683901074764725, 1.5587396123545605], [3.0, 0.7956093000000001], [3.0, 0.0], [3.0, -0.7956093000000001], [2.683901074764725, -1.5587396123545605], [2.121320343559643, -2.121320343559643], [1.5587396123545605, -2.683901074764725], [0.7956093000000001, -3.0], [0.0, -3.0], [-0.7956093000000001, -3.0], [-1.5587396123545605, -2.683901074764725], [-2.121320343559643, -2.121320343559643], [-2.683901074764725, -1.5587396123545605], [-3.0, -0.7956093000000001], [-3.0, 0.0], [-3.0, 0.7956093000000001], [-2.683901074764725, 1.5587396123545605], [-2.121320343559643, 2.121320343559643], [-1.5587396123545605, 2.683901074764725], [-0.7956093000000001, 3.0], [0.0, 3.0]], [\"M\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"Z\"]], \"alpha\": 1, \"xindex\": 0, \"data\": \"data01\", \"id\": \"el39283140134784094800pts\"}, {\"edgecolor\": \"#000000\", \"facecolor\": \"#000088\", \"edgewidth\": 0.5, \"yindex\": 2, \"coordinates\": \"data\", \"zorder\": 2, \"markerpath\": [[[0.0, 3.0], [0.7956093000000001, 3.0], [1.5587396123545605, 2.683901074764725], [2.121320343559643, 2.121320343559643], [2.683901074764725, 1.5587396123545605], [3.0, 0.7956093000000001], [3.0, 0.0], [3.0, -0.7956093000000001], [2.683901074764725, -1.5587396123545605], [2.121320343559643, -2.121320343559643], [1.5587396123545605, -2.683901074764725], [0.7956093000000001, -3.0], [0.0, -3.0], [-0.7956093000000001, -3.0], [-1.5587396123545605, -2.683901074764725], [-2.121320343559643, -2.121320343559643], [-2.683901074764725, -1.5587396123545605], [-3.0, -0.7956093000000001], [-3.0, 0.0], [-3.0, 0.7956093000000001], [-2.683901074764725, 1.5587396123545605], [-2.121320343559643, 2.121320343559643], [-1.5587396123545605, 2.683901074764725], [-0.7956093000000001, 3.0], [0.0, 3.0]], [\"M\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"Z\"]], \"alpha\": 1, \"xindex\": 0, \"data\": \"data01\", \"id\": \"el39283140134784096336pts\"}, {\"edgecolor\": \"#000000\", \"facecolor\": \"#00007F\", \"edgewidth\": 0.5, \"yindex\": 1, \"coordinates\": \"axes\", \"zorder\": 1000002.0, \"markerpath\": [[[0.0, 3.0], [0.7956093000000001, 3.0], [1.5587396123545605, 2.683901074764725], [2.121320343559643, 2.121320343559643], [2.683901074764725, 1.5587396123545605], [3.0, 0.7956093000000001], [3.0, 0.0], [3.0, -0.7956093000000001], [2.683901074764725, -1.5587396123545605], [2.121320343559643, -2.121320343559643], [1.5587396123545605, -2.683901074764725], [0.7956093000000001, -3.0], [0.0, -3.0], [-0.7956093000000001, -3.0], [-1.5587396123545605, -2.683901074764725], [-2.121320343559643, -2.121320343559643], [-2.683901074764725, -1.5587396123545605], [-3.0, -0.7956093000000001], [-3.0, 0.0], [-3.0, 0.7956093000000001], [-2.683901074764725, 1.5587396123545605], [-2.121320343559643, 2.121320343559643], [-1.5587396123545605, 2.683901074764725], [-0.7956093000000001, 3.0], [0.0, 3.0]], [\"M\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"Z\"]], \"alpha\": 1, \"xindex\": 0, \"data\": \"data02\", \"id\": \"el39283140134522198992pts\"}, {\"edgecolor\": \"#000000\", \"facecolor\": \"#000088\", \"edgewidth\": 0.5, \"yindex\": 2, \"coordinates\": \"axes\", \"zorder\": 1000002.0, \"markerpath\": [[[0.0, 3.0], [0.7956093000000001, 3.0], [1.5587396123545605, 2.683901074764725], [2.121320343559643, 2.121320343559643], [2.683901074764725, 1.5587396123545605], [3.0, 0.7956093000000001], [3.0, 0.0], [3.0, -0.7956093000000001], [2.683901074764725, -1.5587396123545605], [2.121320343559643, -2.121320343559643], [1.5587396123545605, -2.683901074764725], [0.7956093000000001, -3.0], [0.0, -3.0], [-0.7956093000000001, -3.0], [-1.5587396123545605, -2.683901074764725], [-2.121320343559643, -2.121320343559643], [-2.683901074764725, -1.5587396123545605], [-3.0, -0.7956093000000001], [-3.0, 0.0], [-3.0, 0.7956093000000001], [-2.683901074764725, 1.5587396123545605], [-2.121320343559643, 2.121320343559643], [-1.5587396123545605, 2.683901074764725], [-0.7956093000000001, 3.0], [0.0, 3.0]], [\"M\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"Z\"]], \"alpha\": 1, \"xindex\": 0, \"data\": \"data02\", \"id\": \"el39283140134521586576pts\"}], \"id\": \"el39283140135868045648\", \"ydomain\": [10.0, 100.0], \"collections\": [], \"xscale\": \"linear\", \"bbox\": [0.125, 0.099999999999999978, 0.77500000000000002, 0.80000000000000004]}], \"height\": 480.0, \"width\": 720.0, \"plugins\": [{\"type\": \"reset\"}, {\"enabled\": false, \"button\": true, \"type\": \"zoom\"}, {\"enabled\": false, \"button\": true, \"type\": \"boxzoom\"}, {\"labels\": [\"1489614021053\", \"1489614022065\", \"1489614023065\", \"1489614023066\", \"1489614024070\", \"1489614025071\", \"1489614025088\", \"1489614026067\", \"1489614026090\", \"1489614027093\", \"1489614028107\", \"1489614029070\", \"1489614029112\", \"1489614030078\", \"1489614030131\", \"1489614031133\", \"1489614032077\", \"1489614032147\", \"1489614033149\", \"1489614034153\", \"1489614035081\", \"1489614035101\", \"1489614035154\", \"1489614036159\", \"1489614037167\", \"1489614038105\", \"1489614038171\", \"1489614039176\", \"1489614040122\", \"1489614040179\", \"1489614041107\", \"1489614041185\", \"1489614042188\", \"1489614043203\", \"1489614044109\", \"1489614044213\", \"1489614045125\", \"1489614045219\", \"1489614046222\", \"1489614047150\", \"1489614047224\", \"1489614048227\", \"1489614049229\", \"1489614050128\", \"1489614050185\", \"1489614050233\", \"1489614051236\", \"1489614052238\", \"1489614053188\", \"1489614053240\", \"1489614054245\", \"1489614055131\", \"1489614055252\", \"1489614056201\", \"1489614056255\", \"1489614057259\", \"1489614058264\", \"1489614059204\", \"1489614059267\", \"1489614060133\", \"1489614060285\", \"1489614061291\", \"1489614062206\", \"1489614062295\", \"1489614063298\", \"1489614064301\", \"1489614065135\", \"1489614065216\", \"1489614065305\", \"1489614066307\", \"1489614067311\", \"1489614068220\", \"1489614068317\", \"1489614069321\", \"1489614070140\", \"1489614070328\", \"1489614071223\", \"1489614071333\", \"1489614072337\", \"1489614073343\", \"1489614074226\", \"1489614074347\", \"1489614075142\", \"1489614075352\", \"1489614076354\", \"1489614077234\", \"1489614077355\", \"1489614078357\", \"1489614079359\", \"1489614080145\", \"1489614080237\", \"1489614080365\", \"1489614081368\", \"1489614082373\", \"1489614083240\", \"1489614083378\", \"1489614084395\", \"1489614085159\", \"1489614085397\", \"1489614086255\"], \"type\": \"chart\"}, {\"handlerId\": \"lineChart\", \"type\": \"dialog\"}, {\"voffset\": 10, \"labels\": [98, 88, 80, 86, 99, 80, 87, 93, 83, 85, 87, 84, 86, 91, 93, 98, 91, 80, 95, 84, 94, 93, 98, 91, 91, 96, 80, 87, 98, 80, 86, 97, 82, 95, 94, 95, 82, 89, 98, 91, 88, 100, 92, 92, 89, 83, 88, 98, 91, 90, 94, 89, 91, 82, 87, 87, 93, 99, 84, 87, 95, 99, 82, 95, 84, 98, 92, 85, 95, 89, 89, 98, 93, 99, 83, 86, 84, 80, 81, 90, 95, 82, 88, 90, 96, 94, 90, 92, 96, 90, 93, 86, 80, 96, 97, 91, 93, 85, 81, 81], \"hoffset\": 0, \"location\": \"mouse\", \"type\": \"tooltip\", \"id\": \"el39283140134784094800pts\"}, {\"voffset\": 10, \"labels\": [11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11], \"hoffset\": 0, \"location\": \"mouse\", \"type\": \"tooltip\", \"id\": \"el39283140134784096336pts\"}], \"data\": {\"data02\": [[0.7203853046594981, 0.9458333333333332, 0.8859374999999998], [0.7605286738351255, 0.9458333333333332, 0.8859374999999998]], \"data03\": [[0.7003136200716846, 0.8468749999999999], [0.985663082437276, 0.8468749999999999], [0.985663082437276, 0.9791666666666665], [0.7003136200716846, 0.9791666666666665]], \"data01\": [[1489614021053.0, 98.0, 11.0], [1489614022065.0, 88.0, 11.0], [1489614023065.0, 80.0, 11.0], [1489614023066.0, 86.0, 11.0], [1489614024070.0, 99.0, 11.0], [1489614025071.0, 80.0, 11.0], [1489614025088.0, 87.0, 11.0], [1489614026067.0, 93.0, 11.0], [1489614026090.0, 83.0, 11.0], [1489614027093.0, 85.0, 11.0], [1489614028107.0, 87.0, 11.0], [1489614029070.0, 84.0, 11.0], [1489614029112.0, 86.0, 11.0], [1489614030078.0, 91.0, 11.0], [1489614030131.0, 93.0, 11.0], [1489614031133.0, 98.0, 11.0], [1489614032077.0, 91.0, 11.0], [1489614032147.0, 80.0, 11.0], [1489614033149.0, 95.0, 11.0], [1489614034153.0, 84.0, 11.0], [1489614035081.0, 94.0, 11.0], [1489614035101.0, 93.0, 11.0], [1489614035154.0, 98.0, 11.0], [1489614036159.0, 91.0, 11.0], [1489614037167.0, 91.0, 11.0], [1489614038105.0, 96.0, 11.0], [1489614038171.0, 80.0, 11.0], [1489614039176.0, 87.0, 11.0], [1489614040122.0, 98.0, 11.0], [1489614040179.0, 80.0, 11.0], [1489614041107.0, 86.0, 11.0], [1489614041185.0, 97.0, 11.0], [1489614042188.0, 82.0, 11.0], [1489614043203.0, 95.0, 11.0], [1489614044109.0, 94.0, 11.0], [1489614044213.0, 95.0, 11.0], [1489614045125.0, 82.0, 11.0], [1489614045219.0, 89.0, 11.0], [1489614046222.0, 98.0, 11.0], [1489614047150.0, 91.0, 11.0], [1489614047224.0, 88.0, 11.0], [1489614048227.0, 100.0, 11.0], [1489614049229.0, 92.0, 11.0], [1489614050128.0, 92.0, 11.0], [1489614050185.0, 89.0, 11.0], [1489614050233.0, 83.0, 11.0], [1489614051236.0, 88.0, 11.0], [1489614052238.0, 98.0, 11.0], [1489614053188.0, 91.0, 11.0], [1489614053240.0, 90.0, 11.0], [1489614054245.0, 94.0, 11.0], [1489614055131.0, 89.0, 11.0], [1489614055252.0, 91.0, 11.0], [1489614056201.0, 82.0, 11.0], [1489614056255.0, 87.0, 11.0], [1489614057259.0, 87.0, 11.0], [1489614058264.0, 93.0, 11.0], [1489614059204.0, 99.0, 11.0], [1489614059267.0, 84.0, 11.0], [1489614060133.0, 87.0, 11.0], [1489614060285.0, 95.0, 11.0], [1489614061291.0, 99.0, 11.0], [1489614062206.0, 82.0, 11.0], [1489614062295.0, 95.0, 11.0], [1489614063298.0, 84.0, 11.0], [1489614064301.0, 98.0, 11.0], [1489614065135.0, 92.0, 11.0], [1489614065216.0, 85.0, 11.0], [1489614065305.0, 95.0, 11.0], [1489614066307.0, 89.0, 11.0], [1489614067311.0, 89.0, 11.0], [1489614068220.0, 98.0, 11.0], [1489614068317.0, 93.0, 11.0], [1489614069321.0, 99.0, 11.0], [1489614070140.0, 83.0, 11.0], [1489614070328.0, 86.0, 11.0], [1489614071223.0, 84.0, 11.0], [1489614071333.0, 80.0, 11.0], [1489614072337.0, 81.0, 11.0], [1489614073343.0, 90.0, 11.0], [1489614074226.0, 95.0, 11.0], [1489614074347.0, 82.0, 11.0], [1489614075142.0, 88.0, 11.0], [1489614075352.0, 90.0, 11.0], [1489614076354.0, 96.0, 11.0], [1489614077234.0, 94.0, 11.0], [1489614077355.0, 90.0, 11.0], [1489614078357.0, 92.0, 11.0], [1489614079359.0, 96.0, 11.0], [1489614080145.0, 90.0, 11.0], [1489614080237.0, 93.0, 11.0], [1489614080365.0, 86.0, 11.0], [1489614081368.0, 80.0, 11.0], [1489614082373.0, 96.0, 11.0], [1489614083240.0, 97.0, 11.0], [1489614083378.0, 91.0, 11.0], [1489614084395.0, 93.0, 11.0], [1489614085159.0, 85.0, 11.0], [1489614085397.0, 81.0, 11.0], [1489614086255.0, 81.0, 11.0]]}, \"id\": \"el39283140135871899344\"});\n",
       "   }(mpld3);\n",
       "}else if(typeof define === \"function\" && define.amd){\n",
       "   // require.js is available: use it to load d3/mpld3\n",
       "   require.config({paths: {d3: \"https://mpld3.github.io/js/d3.v3.min\"}});\n",
       "   require([\"d3\"], function(d3){\n",
       "      window.d3 = d3;\n",
       "      mpld3_load_lib(\"https://mpld3.github.io/js/mpld3.v0.2.js\", function(){\n",
       "         // don't remove this comment\n",
       "mpld3.register_plugin(\"chart\", ChartPlugin);\n",
       "ChartPlugin.prototype = Object.create(mpld3.Plugin.prototype);\n",
       "ChartPlugin.prototype.constructor = ChartPlugin;\n",
       "ChartPlugin.prototype.requiredProps = [\"labels\"];\n",
       "function ChartPlugin(fig, props){\n",
       "\tmpld3.Plugin.call(this, fig, props);\n",
       "};\n",
       "ChartPlugin.prototype.draw = function(){\n",
       "\ttry{\n",
       "\t\t// FIXME: this is a very brittle way to select the x-axis element\n",
       "\t\tvar ax = this.fig.axes[0].elements[0];\n",
       "\n",
       "\t\t// getting the labels for xticks\n",
       "\t\tvar labels =  this.props.labels;\n",
       "\t\tconsole.info(\"labels: \"+labels);\n",
       "\t\t\n",
       "\t\t// see https://github.com/mbostock/d3/wiki/Formatting#d3_format\n",
       "\t\t// for d3js formating documentation\n",
       "\t\tax.axis.tickFormat(function(d){\n",
       "\t\t\ttry{\n",
       "\t\t\t\treturn labels[Math.floor(d)];\n",
       "\t\t\t}catch(e){\n",
       "\t\t\t\tconsole.log(e)\n",
       "\t\t\t}\n",
       "\t\t});\n",
       "\t\tax.axis.ticks(labels.length);\n",
       "\n",
       "\t\t// HACK: use reset to redraw figure\n",
       "\t\tthis.fig.reset(); \n",
       "\t}catch(e){\n",
       "\t\tconsole.log(e);\n",
       "\t}\n",
       "}// don't remove this comment\n",
       "mpld3.register_plugin(\"dialog\", DialogPlugin);\n",
       "DialogPlugin.prototype = Object.create(mpld3.Plugin.prototype);\n",
       "DialogPlugin.prototype.constructor = DialogPlugin;\n",
       "DialogPlugin.prototype.requiredProps = [\"handlerId\"];    \n",
       "function DialogPlugin(fig, props) {\n",
       "    mpld3.Plugin.call(this, fig, props);\n",
       "    var DialogPluginButton = mpld3.ButtonFactory({\n",
       "        buttonID: \"DialogPlugin\",\n",
       "        sticky: false,\n",
       "        onActivate: function() {\n",
       "            \n",
       "    var globalNested={}\n",
       "require(['base/js/dialog'],function(dialog){\n",
       "        var modal = dialog.modal;\n",
       "        var options = {\n",
       "            title: \"Pixiedust: Chart Options\",\n",
       "            body: '<form id=\"chartOptions7582f31b\"><style type=\"text/css\">\t.field-container {\t}\t.field-container ul {\t\toverflow-y: auto;\t\tborder: 1px solid #ccc;\t\tpadding: 5px 0 0 0;\t\tlist-style-type: none;\t}\t.field-container label {\t\tcolor: #008571;\t\tfont-weight: bold;\t}\t.field-container li {\t\tmargin: 0px 5px 5px 5px;\t\tpadding: 5px;\t\tborder: 1px solid #ccc;\t\tborder-radius: 5px;\t\tbackground-color: #daffff;\t\twidth: auto;\t\tmin-width: 150px;\t}\t.field-remove {\t\tcolor: #777;\t\tfont-size: 14px;\t\tfloat: right;\t\tmargin: 0px;\t\tcursor: pointer;\t}\t.field-remove:after {\t\tcontent: \"x\";\t}</style><div class=\"container col-sm-12\">\t<div class=\"row\">\t\t<div class=\"form-group col-sm-10\" style=\"padding-right:10px;\">\t\t\t<label for=\"title7582f31b\">Chart Title:</label>\t\t\t<input type=\"text\" class=\"form-control\" id=\"title7582f31b\" name=\"title\" value=\"\">\t\t</div>\t\t\t\t<div class=\"form-group col-sm-2\">\t\t\t<label class=\"field\">Static Figure:</label>\t\t\t<select class=\"form-control\" name=\"staticFigure\" style=\"margin-left: 0px;\">\t\t\t\t<option value=\"true\">Yes</option>\t\t\t\t<option value=\"false\" selected>No</option>\t\t\t</select>\t\t</div>\t\t\t</div>\t<div class=\"field-container row\">\t\t<div class=\"col-sm-4\" style=\"padding: 0px 5px 0px 0px;\">\t\t\t<label>Fields:</label>\t\t\t<ul id=\"allFields7582f31b\" style=\"height: 215px;\">\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f1\" class=\"field7582f31b\">_id<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f2\" class=\"field7582f31b\">_rev<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f3\" class=\"field7582f31b\">count<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f4\" class=\"field7582f31b\">flowrate<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f5\" class=\"field7582f31b\">fluidlevel<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f6\" class=\"field7582f31b\">frequency<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f7\" class=\"field7582f31b\">hardness<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f8\" class=\"field7582f31b\">speed<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f9\" class=\"field7582f31b\">temperature<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f10\" class=\"field7582f31b\">ts<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f11\" class=\"field7582f31b\">voltage<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t</ul>\t\t</div>\t\t<div class=\"col-sm-8\" style=\"padding: 0px 0px 0px 5px;\">\t\t\t\t\t\t<label>Keys:</label>\t\t\t<ul id=\"keyFields7582f31b\" style=\"height: 90px;\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f10-keyFields7582f31b\">ts<a class=\"field7582f31b-remove field-remove\"></a></li>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</ul>\t\t\t\t\t\t<label>Values:</label>\t\t\t\t\t\t<ul id=\"valueFields7582f31b\" style=\"height: 90px;\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f9-valueFields7582f31b\">temperature<a class=\"field7582f31b-remove field-remove\"></a></li>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f4-valueFields7582f31b\">flowrate<a class=\"field7582f31b-remove field-remove\"></a></li>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</ul>\t\t</div>\t</div>\t<div class=\"row\">\t\t\t\t\t\t<div class=\"col-sm-4\" style=\"padding: 0px 0px 0px 5px;\">\t\t\t<div class=\"form-group\">\t\t\t\t<label class=\"field\">Aggregation:</label>\t\t\t\t<select class=\"form-control\" name=\"aggregation\" style=\"margin-left: 0px;\">\t\t\t\t\t\t\t\t\t\t<option value=\"SUM\" selected>SUM</option>\t\t\t\t\t\t\t\t\t\t<option value=\"AVG\">AVG</option>\t\t\t\t\t\t\t\t\t\t<option value=\"MIN\">MIN</option>\t\t\t\t\t\t\t\t\t\t<option value=\"MAX\">MAX</option>\t\t\t\t\t\t\t\t\t\t<option value=\"COUNT\">COUNT</option>\t\t\t\t\t\t\t\t\t</select>\t\t\t</div>\t\t</div>\t\t\t\t\t\t<div class=\"col-sm-4\" style=\"padding: 0px 5px 0px 5px;\">\t\t\t<div class=\"form-group\">\t\t\t\t<label class=\"field\"># of Rows to Display:</label>\t\t\t\t<input class=\"form-control\" name=\"rowCount\" type=\"number\" min=\"1\" max=\"1000\" value=\"100\">\t\t\t</div>\t\t</div>\t\t\t\t<div class=\"col-sm-4\" style=\"padding: 0px 0px 0px 5px;\">\t\t\t<div class=\"form-group\">\t\t\t\t<label class=\"field\">Show Legend</label>\t\t\t\t<select class=\"form-control\" name=\"showLegend\" style=\"margin-left: 0px;\">\t\t\t\t\t<option value=\"true\">Yes</option>\t\t\t\t\t<option value=\"false\">No</option>\t\t\t\t</select>\t\t\t</div>\t\t</div>\t\t\t\t\t</div></div></form><div class=\"bootbox-body row\"></div>',\n",
       "            sanitize:false,\n",
       "            notebook: IPython.notebook,\n",
       "            buttons: {\n",
       "                \n",
       "                OK: {\n",
       "                    class : \"btn-primary btn-ok\",\n",
       "                    click: function() {\n",
       "                        \n",
       "(\n",
       "\n",
       "function() {\n",
       "    cellId = typeof cellId === \"undefined\" ? \"\" : cellId;\n",
       "    var curCell=IPython.notebook.get_cells().filter(function(cell){\n",
       "        return cell.cell_id==\"538324236C5541628FFDA97C3C5A0C68\".replace(\"cellId\",cellId);\n",
       "    });\n",
       "    curCell=curCell.length>0?curCell[0]:null;\n",
       "    console.log(\"curCell\",curCell);\n",
       "    var startWallToWall;\n",
       "    //Resend the display command\n",
       "    var callbacks = {\n",
       "        iopub:{\n",
       "            output:function(msg){\n",
       "                console.log(\"msg\", msg);\n",
       "                if (false){\n",
       "                    return curCell.output_area.handle_output.apply(curCell.output_area, arguments);\n",
       "                }\n",
       "                var msg_type=msg.header.msg_type;\n",
       "                var content = msg.content;\n",
       "                var executionTime = $(\"#execution7582f31b\");\n",
       "                if(msg_type===\"stream\"){\n",
       "                    $('#wrapperHTML7582f31b').html(content.text);\n",
       "                }else if (msg_type===\"display_data\" || msg_type===\"execute_result\"){\n",
       "                    var html=null;\n",
       "                    if (!!content.data[\"text/html\"]){\n",
       "                        html=content.data[\"text/html\"];\n",
       "                    }else if (!!content.data[\"image/png\"]){\n",
       "                        html=html||\"\";\n",
       "                        html+=\"<img src='data:image/png;base64,\" +content.data[\"image/png\"]+\"'></img>\";\n",
       "                    }\n",
       "                                                    \n",
       "                    if (!!content.data[\"application/javascript\"]){\n",
       "                        try{\n",
       "                            $('#wrapperJS7582f31b').html(\"<script type=\\\\\\\"text/javascript\\\\\\\">\"+content.data[\"application/javascript\"]+\"</s\" + \"cript>\");\n",
       "                        }catch(e){\n",
       "                            console.log(\"Invalid javascript output\",e, content.data);\n",
       "                        }\n",
       "                    }\n",
       "                    \n",
       "                    if (html){\n",
       "                        if(curCell&&curCell.output_area&&curCell.output_area.outputs){\n",
       "                            var data = JSON.parse(JSON.stringify(content.data));\n",
       "                            if(!!data[\"text/html\"])data[\"text/html\"]=html;\n",
       "                            curCell.output_area.outputs.push({\"data\": data,\"metadata\":content.metadata,\"output_type\":msg_type});\n",
       "                        }\n",
       "                        try{\n",
       "                            $('#wrapperHTML7582f31b').html(html);\n",
       "                        }catch(e){\n",
       "                            console.log(\"Invalid html output\", e, html);\n",
       "                            $('#wrapperHTML7582f31b').html( \"Invalid html output. <pre>\" \n",
       "                                + html.replace(/>/g,'&gt;').replace(/</g,'&lt;').replace(/\"/g,'&quot;') + \"<pre>\");\n",
       "                        }\n",
       "                    }\n",
       "                }else if (msg_type === \"error\") {\n",
       "                    require(['base/js/utils'], function(utils) {\n",
       "                        var tb = content.traceback;\n",
       "                        console.log(\"tb\",tb);\n",
       "                        if (tb && tb.length>0){\n",
       "                            var data = tb.reduce(function(res, frame){return res+frame+'\\\\n';},\"\");\n",
       "                            console.log(\"data\",data);\n",
       "                            data = utils.fixConsole(data);\n",
       "                            data = utils.fixCarriageReturn(data);\n",
       "                            data = utils.autoLinkUrls(data);\n",
       "                            $('#wrapperHTML7582f31b').html(\"<pre>\" + data +\"</pre>\");\n",
       "                        }\n",
       "                    });\n",
       "                }\n",
       "\n",
       "                //Append profiling info\n",
       "                if (executionTime.length > 0 && $(\"#execution7582f31b\").length == 0 ){\n",
       "                    $('#wrapperHTML7582f31b').append(executionTime);\n",
       "                }else if (startWallToWall && $(\"#execution7582f31b\").length > 0 ){\n",
       "                    $(\"#execution7582f31b\").append($(\"<div/>\").text(\"Wall to Wall time: \" + ( (new Date().getTime() - startWallToWall)/1000 ) + \"s\"));\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    }\n",
       "    \n",
       "    if (IPython && IPython.notebook && IPython.notebook.session && IPython.notebook.session.kernel){\n",
       "        var command = \"display(cloudantdata,cell_id='538324236C5541628FFDA97C3C5A0C68',handlerId='lineChart',prefix='7582f31b',keyFields='ts',valueFields='temperature,flowrate',staticFigure='false',aggregation='SUM',rowCount='100',showLegend='true')\".replace(\"cellId\",cellId);\n",
       "        function addOptions(options){\n",
       "            function getStringRep(v) {\n",
       "                if (!isNaN(parseFloat(v)) && isFinite(v)){\n",
       "                    return v.toString();\n",
       "                }\n",
       "                return \"'\" + v + \"'\";\n",
       "            }\n",
       "            for (var key in options){\n",
       "                var value = options[key];\n",
       "                var hasValue = value != null && typeof value !== 'undefined' && value !== '';\n",
       "                var replaceValue = hasValue ? (key+\"=\" + getStringRep(value) ) : \"\";\n",
       "                var pattern = (hasValue?\"\":\",\")+\"\\\\s*\" + key + \"\\\\s*=\\\\s*'(\\\\\\\\'|[^'])*'\";\n",
       "                var rpattern=new RegExp(pattern);\n",
       "                var n = command.search(rpattern);\n",
       "                if ( n >= 0 ){\n",
       "                    command = command.replace(rpattern, replaceValue);\n",
       "                }else if (hasValue){\n",
       "                    var n = command.lastIndexOf(\")\");\n",
       "                    command = [command.slice(0, n), (command[n-1]==\"(\"? \"\":\",\") + replaceValue, command.slice(n)].join('')\n",
       "                }        \n",
       "            }\n",
       "        }\n",
       "        if(typeof cellMetadata != \"undefined\" && cellMetadata.displayParams){\n",
       "            addOptions(cellMetadata.displayParams);\n",
       "            addOptions({\"showchrome\":\"true\"});\n",
       "        }\n",
       "        addOptions({});\n",
       "        \n",
       "        \n",
       "    \n",
       "var addValueToCommand = function(name, value) {\n",
       "    if (value) {\n",
       "        var startIndex, endIndex;\n",
       "        startIndex = command.indexOf(\",\"+name+\"=\");\n",
       "        if (startIndex >= 0) {\n",
       "            commaIndex = command.indexOf(\",\", startIndex+1);\n",
       "            quoteIndex = command.indexOf(\"'\", startIndex+1);\n",
       "            if (quoteIndex >=0 && quoteIndex < commaIndex) {\n",
       "                // value is enclosed in quotes - end of value will be second quote\n",
       "                endIndex = command.indexOf(\"'\", quoteIndex+1) + 1;\n",
       "            }\n",
       "            else if (commaIndex >= 0) {\n",
       "                // end of value is the comma\n",
       "                endIndex = commaIndex;\n",
       "            }\n",
       "            else {\n",
       "                // no quote or comma found - end of value is at the very end\n",
       "                endIndex = command.indexOf(\")\", startIndex+1);\n",
       "            }\n",
       "        }\n",
       "        else {\n",
       "            startIndex = endIndex = command.lastIndexOf(\")\");\n",
       "        }\n",
       "        var start = command.substring(0,startIndex);\n",
       "        var end = command.substring(endIndex);\n",
       "        command = start + \",\" + name +\"='\" + value + \"'\" + end;\n",
       "    }\n",
       "    else {\n",
       "        var startIndex, endIndex;\n",
       "        startIndex = command.indexOf(\",\"+name+\"=\");\n",
       "        if (startIndex >= 0) {\n",
       "            commaIndex = command.indexOf(\",\", startIndex+1);\n",
       "            quoteIndex = command.indexOf(\"'\", startIndex+1);\n",
       "            if (quoteIndex >=0 && quoteIndex < commaIndex) {\n",
       "                // value is enclosed in quotes - end of value will be second quote\n",
       "                endIndex = command.indexOf(\"'\", quoteIndex+1) + 1;\n",
       "            }\n",
       "            else if (commaIndex >= 0) {\n",
       "                // end of value is the comma\n",
       "                endIndex = commaIndex;\n",
       "            }\n",
       "            else {\n",
       "                // no quote or comma found - end of value is at the very end\n",
       "                endIndex = command.indexOf(\")\", startIndex+1);\n",
       "            }\n",
       "            var start = command.substring(0,startIndex);\n",
       "            var end = command.substring(endIndex);\n",
       "            command = start + end;\n",
       "        }\n",
       "    }\n",
       "};\n",
       "var getListValues = function(listId) {\n",
       "    var value = '';\n",
       "    $(listId + ' li').each(function(idx, li) {\n",
       "        if (value.length != 0) {\n",
       "            value += ',';\n",
       "        }\n",
       "        value += $(li).text();\n",
       "    });\n",
       "    return value;\n",
       "};\n",
       "addValueToCommand('keyFields',getListValues('#keyFields7582f31b'));\n",
       "addValueToCommand('valueFields',getListValues('#valueFields7582f31b'));\n",
       "$('#chartOptions7582f31b *').filter(':input').each(function(){\n",
       "    if ($(this).is(':checkbox')) {\n",
       "        addValueToCommand($(this).attr('name'),$(this).is(':checked')+'');\t\n",
       "    }\n",
       "    else {\n",
       "        addValueToCommand($(this).attr('name'),$(this).val());\n",
       "    }\n",
       "});\n",
       "$('#chartOptions7582f31b *').filter('select').each(function(){\n",
       "    addValueToCommand($(this).attr('name'),$(this).val());\n",
       "});\n",
       "\n",
       "\n",
       "        console.log(\"Running command2\",command);\n",
       "        var pattern = \"\\\\w*\\\\s*=\\\\s*'(\\\\\\\\'|[^'])*'\";\n",
       "        var rpattern=new RegExp(pattern,\"g\");\n",
       "        var n = command.match(rpattern);\n",
       "        var displayParams={}\n",
       "        for (var i = 0; i < n.length; i++){\n",
       "            var parts=n[i].split(\"=\");\n",
       "            var key = parts[0].trim();\n",
       "            var value = parts[1].trim()\n",
       "            if (!key.startsWith(\"nostore_\") && key != \"showchrome\" && key != \"prefix\" && key != \"cell_id\"){\n",
       "                displayParams[key] = value.substring(1,value.length-1);\n",
       "            }\n",
       "        }\n",
       "        if(curCell&&curCell.output_area){\n",
       "            curCell._metadata.pixiedust = curCell._metadata.pixiedust || {}\n",
       "            curCell._metadata.pixiedust.displayParams=displayParams\n",
       "            curCell.output_area.outputs=[];\n",
       "        }\n",
       "        $('#wrapperJS7582f31b').html(\"\")\n",
       "        $('#wrapperHTML7582f31b').html('<div style=\"width:100px;height:60px;left:47%;position:relative\"><i class=\"fa fa-circle-o-notch fa-spin\" style=\"font-size:48px\"></i></div>'+\n",
       "        '<div style=\"text-align:center\">Loading your data. Please wait...</div>');\n",
       "        startWallToWall = new Date().getTime();\n",
       "        IPython.notebook.session.kernel.execute(command, callbacks, {silent:false,store_history:false,stop_on_error:true});\n",
       "    }\n",
       "}\n",
       ")()\n",
       "\n",
       "                    }\n",
       "                },\n",
       "                Cancel: {\n",
       "                    class : \"btn-cancel\",\n",
       "                    click: function(){\n",
       "                        \n",
       "                    }\n",
       "                }\n",
       "                \n",
       "            }\n",
       "        };\n",
       "        var modal_obj = modal(options);\n",
       "        modal_obj.addClass('pixiedust');\n",
       "        modal_obj.on('shown.bs.modal', function(){\n",
       "            \n",
       "$('#chartOptions7582f31b *').filter(':input').each(function(){\n",
       "\tIPython.keyboard_manager.register_events($(this));\n",
       "});\n",
       "$('.field7582f31b').draggable({\n",
       "\thelper:\"clone\",\n",
       "\tcontainment:\"document\"\n",
       "});\n",
       "$('.field7582f31b-remove').click(function(e) {\n",
       "\te.preventDefault();\n",
       "\t$(this).parent().remove();\n",
       "\treturn false;\n",
       "});\n",
       "$('#keyFields7582f31b, #valueFields7582f31b').droppable({\n",
       "\tdrop:function(event, ui) {\n",
       "\t\tvar newId = ui.draggable.attr('id') + '-' + $(this).attr('id');\n",
       "\t\tif ( $('#'+newId).length == 0) { \n",
       "\t\t\tvar el = ui.draggable.clone(true, true);\n",
       "\t\t\tel.attr(\"id\",newId);\n",
       "\t\t\tel.find(\"a\").addClass(\"field-remove\");\n",
       "\t\t\tel.appendTo($(this));\n",
       "\t\t}\n",
       "\t}\n",
       "});\n",
       "\n",
       "        });\n",
       "\n",
       "        })\n",
       "\n",
       "        },\n",
       "        icon: function() {\n",
       "            return mpld3.icons[\"brush\"];\n",
       "        }\n",
       "    });\n",
       "    this.fig.buttons.push(DialogPluginButton);\n",
       "}\n",
       "         mpld3.draw_figure(\"fig_el392831401358718993448750349467\", {\"axes\": [{\"xlim\": [0.0, 1489614090000.0], \"yscale\": \"linear\", \"axesbg\": \"#FFFFFF\", \"texts\": [{\"v_baseline\": \"hanging\", \"h_anchor\": \"middle\", \"color\": \"#000000\", \"text\": \"ts\", \"coordinates\": \"axes\", \"zorder\": 3, \"alpha\": 1, \"fontsize\": 18.0, \"position\": [0.5, -0.059895833333333329], \"rotation\": -0.0, \"id\": \"el39283140135868045520\"}, {\"v_baseline\": \"auto\", \"h_anchor\": \"start\", \"color\": \"#00007F\", \"text\": \"temperature\", \"coordinates\": \"axes\", \"zorder\": 1000003.0, \"alpha\": 1, \"fontsize\": 14.399999999999999, \"position\": [0.7920698924731181, 0.93124999999999991], \"rotation\": -0.0, \"id\": \"el39283140134522198032\"}, {\"v_baseline\": \"auto\", \"h_anchor\": \"start\", \"color\": \"#000088\", \"text\": \"flowrate\", \"coordinates\": \"axes\", \"zorder\": 1000003.0, \"alpha\": 1, \"fontsize\": 14.399999999999999, \"position\": [0.7920698924731181, 0.87135416666666654], \"rotation\": -0.0, \"id\": \"el39283140134522199952\"}], \"zoomable\": true, \"images\": [], \"xdomain\": [0.0, 1489614090000.0], \"ylim\": [10.0, 100.0], \"paths\": [{\"edgecolor\": \"none\", \"facecolor\": \"none\", \"edgewidth\": 1.0, \"pathcodes\": [\"M\", \"L\", \"L\", \"L\", \"Z\"], \"yindex\": 1, \"coordinates\": \"axes\", \"dasharray\": \"10,0\", \"zorder\": 1000001.0, \"alpha\": 0, \"xindex\": 0, \"data\": \"data03\", \"id\": \"el39283140134522197648\"}], \"sharey\": [], \"sharex\": [], \"axesbgalpha\": null, \"axes\": [{\"scale\": \"linear\", \"tickformat\": null, \"grid\": {\"color\": \"#D3D3D3\", \"alpha\": 0.7, \"dasharray\": \"2,2\", \"gridOn\": true}, \"fontsize\": 12.0, \"position\": \"bottom\", \"nticks\": 100, \"tickvalues\": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99]}, {\"scale\": \"linear\", \"tickformat\": null, \"grid\": {\"color\": \"#D3D3D3\", \"alpha\": 0.7, \"dasharray\": \"2,2\", \"gridOn\": true}, \"fontsize\": 12.0, \"position\": \"left\", \"nticks\": 10, \"tickvalues\": null}], \"lines\": [{\"color\": \"#00007F\", \"yindex\": 1, \"coordinates\": \"data\", \"dasharray\": \"10,0\", \"zorder\": 2, \"alpha\": 1, \"xindex\": 0, \"linewidth\": 1.0, \"data\": \"data01\", \"id\": \"el39283140134784094800\"}, {\"color\": \"#000088\", \"yindex\": 2, \"coordinates\": \"data\", \"dasharray\": \"10,0\", \"zorder\": 2, \"alpha\": 1, \"xindex\": 0, \"linewidth\": 1.0, \"data\": \"data01\", \"id\": \"el39283140134784096336\"}, {\"color\": \"#00007F\", \"yindex\": 1, \"coordinates\": \"axes\", \"dasharray\": \"10,0\", \"zorder\": 1000002.0, \"alpha\": 1, \"xindex\": 0, \"linewidth\": 10.0, \"data\": \"data02\", \"id\": \"el39283140134522198544\"}, {\"color\": \"#000088\", \"yindex\": 2, \"coordinates\": \"axes\", \"dasharray\": \"10,0\", \"zorder\": 1000002.0, \"alpha\": 1, \"xindex\": 0, \"linewidth\": 10.0, \"data\": \"data02\", \"id\": \"el39283140134521586128\"}], \"markers\": [{\"edgecolor\": \"#000000\", \"facecolor\": \"#00007F\", \"edgewidth\": 0.5, \"yindex\": 1, \"coordinates\": \"data\", \"zorder\": 2, \"markerpath\": [[[0.0, 3.0], [0.7956093000000001, 3.0], [1.5587396123545605, 2.683901074764725], [2.121320343559643, 2.121320343559643], [2.683901074764725, 1.5587396123545605], [3.0, 0.7956093000000001], [3.0, 0.0], [3.0, -0.7956093000000001], [2.683901074764725, -1.5587396123545605], [2.121320343559643, -2.121320343559643], [1.5587396123545605, -2.683901074764725], [0.7956093000000001, -3.0], [0.0, -3.0], [-0.7956093000000001, -3.0], [-1.5587396123545605, -2.683901074764725], [-2.121320343559643, -2.121320343559643], [-2.683901074764725, -1.5587396123545605], [-3.0, -0.7956093000000001], [-3.0, 0.0], [-3.0, 0.7956093000000001], [-2.683901074764725, 1.5587396123545605], [-2.121320343559643, 2.121320343559643], [-1.5587396123545605, 2.683901074764725], [-0.7956093000000001, 3.0], [0.0, 3.0]], [\"M\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"Z\"]], \"alpha\": 1, \"xindex\": 0, \"data\": \"data01\", \"id\": \"el39283140134784094800pts\"}, {\"edgecolor\": \"#000000\", \"facecolor\": \"#000088\", \"edgewidth\": 0.5, \"yindex\": 2, \"coordinates\": \"data\", \"zorder\": 2, \"markerpath\": [[[0.0, 3.0], [0.7956093000000001, 3.0], [1.5587396123545605, 2.683901074764725], [2.121320343559643, 2.121320343559643], [2.683901074764725, 1.5587396123545605], [3.0, 0.7956093000000001], [3.0, 0.0], [3.0, -0.7956093000000001], [2.683901074764725, -1.5587396123545605], [2.121320343559643, -2.121320343559643], [1.5587396123545605, -2.683901074764725], [0.7956093000000001, -3.0], [0.0, -3.0], [-0.7956093000000001, -3.0], [-1.5587396123545605, -2.683901074764725], [-2.121320343559643, -2.121320343559643], [-2.683901074764725, -1.5587396123545605], [-3.0, -0.7956093000000001], [-3.0, 0.0], [-3.0, 0.7956093000000001], [-2.683901074764725, 1.5587396123545605], [-2.121320343559643, 2.121320343559643], [-1.5587396123545605, 2.683901074764725], [-0.7956093000000001, 3.0], [0.0, 3.0]], [\"M\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"Z\"]], \"alpha\": 1, \"xindex\": 0, \"data\": \"data01\", \"id\": \"el39283140134784096336pts\"}, {\"edgecolor\": \"#000000\", \"facecolor\": \"#00007F\", \"edgewidth\": 0.5, \"yindex\": 1, \"coordinates\": \"axes\", \"zorder\": 1000002.0, \"markerpath\": [[[0.0, 3.0], [0.7956093000000001, 3.0], [1.5587396123545605, 2.683901074764725], [2.121320343559643, 2.121320343559643], [2.683901074764725, 1.5587396123545605], [3.0, 0.7956093000000001], [3.0, 0.0], [3.0, -0.7956093000000001], [2.683901074764725, -1.5587396123545605], [2.121320343559643, -2.121320343559643], [1.5587396123545605, -2.683901074764725], [0.7956093000000001, -3.0], [0.0, -3.0], [-0.7956093000000001, -3.0], [-1.5587396123545605, -2.683901074764725], [-2.121320343559643, -2.121320343559643], [-2.683901074764725, -1.5587396123545605], [-3.0, -0.7956093000000001], [-3.0, 0.0], [-3.0, 0.7956093000000001], [-2.683901074764725, 1.5587396123545605], [-2.121320343559643, 2.121320343559643], [-1.5587396123545605, 2.683901074764725], [-0.7956093000000001, 3.0], [0.0, 3.0]], [\"M\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"Z\"]], \"alpha\": 1, \"xindex\": 0, \"data\": \"data02\", \"id\": \"el39283140134522198992pts\"}, {\"edgecolor\": \"#000000\", \"facecolor\": \"#000088\", \"edgewidth\": 0.5, \"yindex\": 2, \"coordinates\": \"axes\", \"zorder\": 1000002.0, \"markerpath\": [[[0.0, 3.0], [0.7956093000000001, 3.0], [1.5587396123545605, 2.683901074764725], [2.121320343559643, 2.121320343559643], [2.683901074764725, 1.5587396123545605], [3.0, 0.7956093000000001], [3.0, 0.0], [3.0, -0.7956093000000001], [2.683901074764725, -1.5587396123545605], [2.121320343559643, -2.121320343559643], [1.5587396123545605, -2.683901074764725], [0.7956093000000001, -3.0], [0.0, -3.0], [-0.7956093000000001, -3.0], [-1.5587396123545605, -2.683901074764725], [-2.121320343559643, -2.121320343559643], [-2.683901074764725, -1.5587396123545605], [-3.0, -0.7956093000000001], [-3.0, 0.0], [-3.0, 0.7956093000000001], [-2.683901074764725, 1.5587396123545605], [-2.121320343559643, 2.121320343559643], [-1.5587396123545605, 2.683901074764725], [-0.7956093000000001, 3.0], [0.0, 3.0]], [\"M\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"Z\"]], \"alpha\": 1, \"xindex\": 0, \"data\": \"data02\", \"id\": \"el39283140134521586576pts\"}], \"id\": \"el39283140135868045648\", \"ydomain\": [10.0, 100.0], \"collections\": [], \"xscale\": \"linear\", \"bbox\": [0.125, 0.099999999999999978, 0.77500000000000002, 0.80000000000000004]}], \"height\": 480.0, \"width\": 720.0, \"plugins\": [{\"type\": \"reset\"}, {\"enabled\": false, \"button\": true, \"type\": \"zoom\"}, {\"enabled\": false, \"button\": true, \"type\": \"boxzoom\"}, {\"labels\": [\"1489614021053\", \"1489614022065\", \"1489614023065\", \"1489614023066\", \"1489614024070\", \"1489614025071\", \"1489614025088\", \"1489614026067\", \"1489614026090\", \"1489614027093\", \"1489614028107\", \"1489614029070\", \"1489614029112\", \"1489614030078\", \"1489614030131\", \"1489614031133\", \"1489614032077\", \"1489614032147\", \"1489614033149\", \"1489614034153\", \"1489614035081\", \"1489614035101\", \"1489614035154\", \"1489614036159\", \"1489614037167\", \"1489614038105\", \"1489614038171\", \"1489614039176\", \"1489614040122\", \"1489614040179\", \"1489614041107\", \"1489614041185\", \"1489614042188\", \"1489614043203\", \"1489614044109\", \"1489614044213\", \"1489614045125\", \"1489614045219\", \"1489614046222\", \"1489614047150\", \"1489614047224\", \"1489614048227\", \"1489614049229\", \"1489614050128\", \"1489614050185\", \"1489614050233\", \"1489614051236\", \"1489614052238\", \"1489614053188\", \"1489614053240\", \"1489614054245\", \"1489614055131\", \"1489614055252\", \"1489614056201\", \"1489614056255\", \"1489614057259\", \"1489614058264\", \"1489614059204\", \"1489614059267\", \"1489614060133\", \"1489614060285\", \"1489614061291\", \"1489614062206\", \"1489614062295\", \"1489614063298\", \"1489614064301\", \"1489614065135\", \"1489614065216\", \"1489614065305\", \"1489614066307\", \"1489614067311\", \"1489614068220\", \"1489614068317\", \"1489614069321\", \"1489614070140\", \"1489614070328\", \"1489614071223\", \"1489614071333\", \"1489614072337\", \"1489614073343\", \"1489614074226\", \"1489614074347\", \"1489614075142\", \"1489614075352\", \"1489614076354\", \"1489614077234\", \"1489614077355\", \"1489614078357\", \"1489614079359\", \"1489614080145\", \"1489614080237\", \"1489614080365\", \"1489614081368\", \"1489614082373\", \"1489614083240\", \"1489614083378\", \"1489614084395\", \"1489614085159\", \"1489614085397\", \"1489614086255\"], \"type\": \"chart\"}, {\"handlerId\": \"lineChart\", \"type\": \"dialog\"}, {\"voffset\": 10, \"labels\": [98, 88, 80, 86, 99, 80, 87, 93, 83, 85, 87, 84, 86, 91, 93, 98, 91, 80, 95, 84, 94, 93, 98, 91, 91, 96, 80, 87, 98, 80, 86, 97, 82, 95, 94, 95, 82, 89, 98, 91, 88, 100, 92, 92, 89, 83, 88, 98, 91, 90, 94, 89, 91, 82, 87, 87, 93, 99, 84, 87, 95, 99, 82, 95, 84, 98, 92, 85, 95, 89, 89, 98, 93, 99, 83, 86, 84, 80, 81, 90, 95, 82, 88, 90, 96, 94, 90, 92, 96, 90, 93, 86, 80, 96, 97, 91, 93, 85, 81, 81], \"hoffset\": 0, \"location\": \"mouse\", \"type\": \"tooltip\", \"id\": \"el39283140134784094800pts\"}, {\"voffset\": 10, \"labels\": [11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11], \"hoffset\": 0, \"location\": \"mouse\", \"type\": \"tooltip\", \"id\": \"el39283140134784096336pts\"}], \"data\": {\"data02\": [[0.7203853046594981, 0.9458333333333332, 0.8859374999999998], [0.7605286738351255, 0.9458333333333332, 0.8859374999999998]], \"data03\": [[0.7003136200716846, 0.8468749999999999], [0.985663082437276, 0.8468749999999999], [0.985663082437276, 0.9791666666666665], [0.7003136200716846, 0.9791666666666665]], \"data01\": [[1489614021053.0, 98.0, 11.0], [1489614022065.0, 88.0, 11.0], [1489614023065.0, 80.0, 11.0], [1489614023066.0, 86.0, 11.0], [1489614024070.0, 99.0, 11.0], [1489614025071.0, 80.0, 11.0], [1489614025088.0, 87.0, 11.0], [1489614026067.0, 93.0, 11.0], [1489614026090.0, 83.0, 11.0], [1489614027093.0, 85.0, 11.0], [1489614028107.0, 87.0, 11.0], [1489614029070.0, 84.0, 11.0], [1489614029112.0, 86.0, 11.0], [1489614030078.0, 91.0, 11.0], [1489614030131.0, 93.0, 11.0], [1489614031133.0, 98.0, 11.0], [1489614032077.0, 91.0, 11.0], [1489614032147.0, 80.0, 11.0], [1489614033149.0, 95.0, 11.0], [1489614034153.0, 84.0, 11.0], [1489614035081.0, 94.0, 11.0], [1489614035101.0, 93.0, 11.0], [1489614035154.0, 98.0, 11.0], [1489614036159.0, 91.0, 11.0], [1489614037167.0, 91.0, 11.0], [1489614038105.0, 96.0, 11.0], [1489614038171.0, 80.0, 11.0], [1489614039176.0, 87.0, 11.0], [1489614040122.0, 98.0, 11.0], [1489614040179.0, 80.0, 11.0], [1489614041107.0, 86.0, 11.0], [1489614041185.0, 97.0, 11.0], [1489614042188.0, 82.0, 11.0], [1489614043203.0, 95.0, 11.0], [1489614044109.0, 94.0, 11.0], [1489614044213.0, 95.0, 11.0], [1489614045125.0, 82.0, 11.0], [1489614045219.0, 89.0, 11.0], [1489614046222.0, 98.0, 11.0], [1489614047150.0, 91.0, 11.0], [1489614047224.0, 88.0, 11.0], [1489614048227.0, 100.0, 11.0], [1489614049229.0, 92.0, 11.0], [1489614050128.0, 92.0, 11.0], [1489614050185.0, 89.0, 11.0], [1489614050233.0, 83.0, 11.0], [1489614051236.0, 88.0, 11.0], [1489614052238.0, 98.0, 11.0], [1489614053188.0, 91.0, 11.0], [1489614053240.0, 90.0, 11.0], [1489614054245.0, 94.0, 11.0], [1489614055131.0, 89.0, 11.0], [1489614055252.0, 91.0, 11.0], [1489614056201.0, 82.0, 11.0], [1489614056255.0, 87.0, 11.0], [1489614057259.0, 87.0, 11.0], [1489614058264.0, 93.0, 11.0], [1489614059204.0, 99.0, 11.0], [1489614059267.0, 84.0, 11.0], [1489614060133.0, 87.0, 11.0], [1489614060285.0, 95.0, 11.0], [1489614061291.0, 99.0, 11.0], [1489614062206.0, 82.0, 11.0], [1489614062295.0, 95.0, 11.0], [1489614063298.0, 84.0, 11.0], [1489614064301.0, 98.0, 11.0], [1489614065135.0, 92.0, 11.0], [1489614065216.0, 85.0, 11.0], [1489614065305.0, 95.0, 11.0], [1489614066307.0, 89.0, 11.0], [1489614067311.0, 89.0, 11.0], [1489614068220.0, 98.0, 11.0], [1489614068317.0, 93.0, 11.0], [1489614069321.0, 99.0, 11.0], [1489614070140.0, 83.0, 11.0], [1489614070328.0, 86.0, 11.0], [1489614071223.0, 84.0, 11.0], [1489614071333.0, 80.0, 11.0], [1489614072337.0, 81.0, 11.0], [1489614073343.0, 90.0, 11.0], [1489614074226.0, 95.0, 11.0], [1489614074347.0, 82.0, 11.0], [1489614075142.0, 88.0, 11.0], [1489614075352.0, 90.0, 11.0], [1489614076354.0, 96.0, 11.0], [1489614077234.0, 94.0, 11.0], [1489614077355.0, 90.0, 11.0], [1489614078357.0, 92.0, 11.0], [1489614079359.0, 96.0, 11.0], [1489614080145.0, 90.0, 11.0], [1489614080237.0, 93.0, 11.0], [1489614080365.0, 86.0, 11.0], [1489614081368.0, 80.0, 11.0], [1489614082373.0, 96.0, 11.0], [1489614083240.0, 97.0, 11.0], [1489614083378.0, 91.0, 11.0], [1489614084395.0, 93.0, 11.0], [1489614085159.0, 85.0, 11.0], [1489614085397.0, 81.0, 11.0], [1489614086255.0, 81.0, 11.0]]}, \"id\": \"el39283140135871899344\"});\n",
       "      });\n",
       "    });\n",
       "}else{\n",
       "    // require.js not available: dynamically load d3 & mpld3\n",
       "    mpld3_load_lib(\"https://mpld3.github.io/js/d3.v3.min.js\", function(){\n",
       "         mpld3_load_lib(\"https://mpld3.github.io/js/mpld3.v0.2.js\", function(){\n",
       "                 // don't remove this comment\n",
       "mpld3.register_plugin(\"chart\", ChartPlugin);\n",
       "ChartPlugin.prototype = Object.create(mpld3.Plugin.prototype);\n",
       "ChartPlugin.prototype.constructor = ChartPlugin;\n",
       "ChartPlugin.prototype.requiredProps = [\"labels\"];\n",
       "function ChartPlugin(fig, props){\n",
       "\tmpld3.Plugin.call(this, fig, props);\n",
       "};\n",
       "ChartPlugin.prototype.draw = function(){\n",
       "\ttry{\n",
       "\t\t// FIXME: this is a very brittle way to select the x-axis element\n",
       "\t\tvar ax = this.fig.axes[0].elements[0];\n",
       "\n",
       "\t\t// getting the labels for xticks\n",
       "\t\tvar labels =  this.props.labels;\n",
       "\t\tconsole.info(\"labels: \"+labels);\n",
       "\t\t\n",
       "\t\t// see https://github.com/mbostock/d3/wiki/Formatting#d3_format\n",
       "\t\t// for d3js formating documentation\n",
       "\t\tax.axis.tickFormat(function(d){\n",
       "\t\t\ttry{\n",
       "\t\t\t\treturn labels[Math.floor(d)];\n",
       "\t\t\t}catch(e){\n",
       "\t\t\t\tconsole.log(e)\n",
       "\t\t\t}\n",
       "\t\t});\n",
       "\t\tax.axis.ticks(labels.length);\n",
       "\n",
       "\t\t// HACK: use reset to redraw figure\n",
       "\t\tthis.fig.reset(); \n",
       "\t}catch(e){\n",
       "\t\tconsole.log(e);\n",
       "\t}\n",
       "}// don't remove this comment\n",
       "mpld3.register_plugin(\"dialog\", DialogPlugin);\n",
       "DialogPlugin.prototype = Object.create(mpld3.Plugin.prototype);\n",
       "DialogPlugin.prototype.constructor = DialogPlugin;\n",
       "DialogPlugin.prototype.requiredProps = [\"handlerId\"];    \n",
       "function DialogPlugin(fig, props) {\n",
       "    mpld3.Plugin.call(this, fig, props);\n",
       "    var DialogPluginButton = mpld3.ButtonFactory({\n",
       "        buttonID: \"DialogPlugin\",\n",
       "        sticky: false,\n",
       "        onActivate: function() {\n",
       "            \n",
       "    var globalNested={}\n",
       "require(['base/js/dialog'],function(dialog){\n",
       "        var modal = dialog.modal;\n",
       "        var options = {\n",
       "            title: \"Pixiedust: Chart Options\",\n",
       "            body: '<form id=\"chartOptions7582f31b\"><style type=\"text/css\">\t.field-container {\t}\t.field-container ul {\t\toverflow-y: auto;\t\tborder: 1px solid #ccc;\t\tpadding: 5px 0 0 0;\t\tlist-style-type: none;\t}\t.field-container label {\t\tcolor: #008571;\t\tfont-weight: bold;\t}\t.field-container li {\t\tmargin: 0px 5px 5px 5px;\t\tpadding: 5px;\t\tborder: 1px solid #ccc;\t\tborder-radius: 5px;\t\tbackground-color: #daffff;\t\twidth: auto;\t\tmin-width: 150px;\t}\t.field-remove {\t\tcolor: #777;\t\tfont-size: 14px;\t\tfloat: right;\t\tmargin: 0px;\t\tcursor: pointer;\t}\t.field-remove:after {\t\tcontent: \"x\";\t}</style><div class=\"container col-sm-12\">\t<div class=\"row\">\t\t<div class=\"form-group col-sm-10\" style=\"padding-right:10px;\">\t\t\t<label for=\"title7582f31b\">Chart Title:</label>\t\t\t<input type=\"text\" class=\"form-control\" id=\"title7582f31b\" name=\"title\" value=\"\">\t\t</div>\t\t\t\t<div class=\"form-group col-sm-2\">\t\t\t<label class=\"field\">Static Figure:</label>\t\t\t<select class=\"form-control\" name=\"staticFigure\" style=\"margin-left: 0px;\">\t\t\t\t<option value=\"true\">Yes</option>\t\t\t\t<option value=\"false\" selected>No</option>\t\t\t</select>\t\t</div>\t\t\t</div>\t<div class=\"field-container row\">\t\t<div class=\"col-sm-4\" style=\"padding: 0px 5px 0px 0px;\">\t\t\t<label>Fields:</label>\t\t\t<ul id=\"allFields7582f31b\" style=\"height: 215px;\">\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f1\" class=\"field7582f31b\">_id<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f2\" class=\"field7582f31b\">_rev<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f3\" class=\"field7582f31b\">count<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f4\" class=\"field7582f31b\">flowrate<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f5\" class=\"field7582f31b\">fluidlevel<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f6\" class=\"field7582f31b\">frequency<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f7\" class=\"field7582f31b\">hardness<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f8\" class=\"field7582f31b\">speed<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f9\" class=\"field7582f31b\">temperature<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f10\" class=\"field7582f31b\">ts<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f11\" class=\"field7582f31b\">voltage<a class=\"field7582f31b-remove\"></a></li>\t\t\t\t\t\t\t</ul>\t\t</div>\t\t<div class=\"col-sm-8\" style=\"padding: 0px 0px 0px 5px;\">\t\t\t\t\t\t<label>Keys:</label>\t\t\t<ul id=\"keyFields7582f31b\" style=\"height: 90px;\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f10-keyFields7582f31b\">ts<a class=\"field7582f31b-remove field-remove\"></a></li>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</ul>\t\t\t\t\t\t<label>Values:</label>\t\t\t\t\t\t<ul id=\"valueFields7582f31b\" style=\"height: 90px;\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f9-valueFields7582f31b\">temperature<a class=\"field7582f31b-remove field-remove\"></a></li>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li id=\"field7582f31b-f4-valueFields7582f31b\">flowrate<a class=\"field7582f31b-remove field-remove\"></a></li>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</ul>\t\t</div>\t</div>\t<div class=\"row\">\t\t\t\t\t\t<div class=\"col-sm-4\" style=\"padding: 0px 0px 0px 5px;\">\t\t\t<div class=\"form-group\">\t\t\t\t<label class=\"field\">Aggregation:</label>\t\t\t\t<select class=\"form-control\" name=\"aggregation\" style=\"margin-left: 0px;\">\t\t\t\t\t\t\t\t\t\t<option value=\"SUM\" selected>SUM</option>\t\t\t\t\t\t\t\t\t\t<option value=\"AVG\">AVG</option>\t\t\t\t\t\t\t\t\t\t<option value=\"MIN\">MIN</option>\t\t\t\t\t\t\t\t\t\t<option value=\"MAX\">MAX</option>\t\t\t\t\t\t\t\t\t\t<option value=\"COUNT\">COUNT</option>\t\t\t\t\t\t\t\t\t</select>\t\t\t</div>\t\t</div>\t\t\t\t\t\t<div class=\"col-sm-4\" style=\"padding: 0px 5px 0px 5px;\">\t\t\t<div class=\"form-group\">\t\t\t\t<label class=\"field\"># of Rows to Display:</label>\t\t\t\t<input class=\"form-control\" name=\"rowCount\" type=\"number\" min=\"1\" max=\"1000\" value=\"100\">\t\t\t</div>\t\t</div>\t\t\t\t<div class=\"col-sm-4\" style=\"padding: 0px 0px 0px 5px;\">\t\t\t<div class=\"form-group\">\t\t\t\t<label class=\"field\">Show Legend</label>\t\t\t\t<select class=\"form-control\" name=\"showLegend\" style=\"margin-left: 0px;\">\t\t\t\t\t<option value=\"true\">Yes</option>\t\t\t\t\t<option value=\"false\">No</option>\t\t\t\t</select>\t\t\t</div>\t\t</div>\t\t\t\t\t</div></div></form><div class=\"bootbox-body row\"></div>',\n",
       "            sanitize:false,\n",
       "            notebook: IPython.notebook,\n",
       "            buttons: {\n",
       "                \n",
       "                OK: {\n",
       "                    class : \"btn-primary btn-ok\",\n",
       "                    click: function() {\n",
       "                        \n",
       "(\n",
       "\n",
       "function() {\n",
       "    cellId = typeof cellId === \"undefined\" ? \"\" : cellId;\n",
       "    var curCell=IPython.notebook.get_cells().filter(function(cell){\n",
       "        return cell.cell_id==\"538324236C5541628FFDA97C3C5A0C68\".replace(\"cellId\",cellId);\n",
       "    });\n",
       "    curCell=curCell.length>0?curCell[0]:null;\n",
       "    console.log(\"curCell\",curCell);\n",
       "    var startWallToWall;\n",
       "    //Resend the display command\n",
       "    var callbacks = {\n",
       "        iopub:{\n",
       "            output:function(msg){\n",
       "                console.log(\"msg\", msg);\n",
       "                if (false){\n",
       "                    return curCell.output_area.handle_output.apply(curCell.output_area, arguments);\n",
       "                }\n",
       "                var msg_type=msg.header.msg_type;\n",
       "                var content = msg.content;\n",
       "                var executionTime = $(\"#execution7582f31b\");\n",
       "                if(msg_type===\"stream\"){\n",
       "                    $('#wrapperHTML7582f31b').html(content.text);\n",
       "                }else if (msg_type===\"display_data\" || msg_type===\"execute_result\"){\n",
       "                    var html=null;\n",
       "                    if (!!content.data[\"text/html\"]){\n",
       "                        html=content.data[\"text/html\"];\n",
       "                    }else if (!!content.data[\"image/png\"]){\n",
       "                        html=html||\"\";\n",
       "                        html+=\"<img src='data:image/png;base64,\" +content.data[\"image/png\"]+\"'></img>\";\n",
       "                    }\n",
       "                                                    \n",
       "                    if (!!content.data[\"application/javascript\"]){\n",
       "                        try{\n",
       "                            $('#wrapperJS7582f31b').html(\"<script type=\\\\\\\"text/javascript\\\\\\\">\"+content.data[\"application/javascript\"]+\"</s\" + \"cript>\");\n",
       "                        }catch(e){\n",
       "                            console.log(\"Invalid javascript output\",e, content.data);\n",
       "                        }\n",
       "                    }\n",
       "                    \n",
       "                    if (html){\n",
       "                        if(curCell&&curCell.output_area&&curCell.output_area.outputs){\n",
       "                            var data = JSON.parse(JSON.stringify(content.data));\n",
       "                            if(!!data[\"text/html\"])data[\"text/html\"]=html;\n",
       "                            curCell.output_area.outputs.push({\"data\": data,\"metadata\":content.metadata,\"output_type\":msg_type});\n",
       "                        }\n",
       "                        try{\n",
       "                            $('#wrapperHTML7582f31b').html(html);\n",
       "                        }catch(e){\n",
       "                            console.log(\"Invalid html output\", e, html);\n",
       "                            $('#wrapperHTML7582f31b').html( \"Invalid html output. <pre>\" \n",
       "                                + html.replace(/>/g,'&gt;').replace(/</g,'&lt;').replace(/\"/g,'&quot;') + \"<pre>\");\n",
       "                        }\n",
       "                    }\n",
       "                }else if (msg_type === \"error\") {\n",
       "                    require(['base/js/utils'], function(utils) {\n",
       "                        var tb = content.traceback;\n",
       "                        console.log(\"tb\",tb);\n",
       "                        if (tb && tb.length>0){\n",
       "                            var data = tb.reduce(function(res, frame){return res+frame+'\\\\n';},\"\");\n",
       "                            console.log(\"data\",data);\n",
       "                            data = utils.fixConsole(data);\n",
       "                            data = utils.fixCarriageReturn(data);\n",
       "                            data = utils.autoLinkUrls(data);\n",
       "                            $('#wrapperHTML7582f31b').html(\"<pre>\" + data +\"</pre>\");\n",
       "                        }\n",
       "                    });\n",
       "                }\n",
       "\n",
       "                //Append profiling info\n",
       "                if (executionTime.length > 0 && $(\"#execution7582f31b\").length == 0 ){\n",
       "                    $('#wrapperHTML7582f31b').append(executionTime);\n",
       "                }else if (startWallToWall && $(\"#execution7582f31b\").length > 0 ){\n",
       "                    $(\"#execution7582f31b\").append($(\"<div/>\").text(\"Wall to Wall time: \" + ( (new Date().getTime() - startWallToWall)/1000 ) + \"s\"));\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    }\n",
       "    \n",
       "    if (IPython && IPython.notebook && IPython.notebook.session && IPython.notebook.session.kernel){\n",
       "        var command = \"display(cloudantdata,cell_id='538324236C5541628FFDA97C3C5A0C68',handlerId='lineChart',prefix='7582f31b',keyFields='ts',valueFields='temperature,flowrate',staticFigure='false',aggregation='SUM',rowCount='100',showLegend='true')\".replace(\"cellId\",cellId);\n",
       "        function addOptions(options){\n",
       "            function getStringRep(v) {\n",
       "                if (!isNaN(parseFloat(v)) && isFinite(v)){\n",
       "                    return v.toString();\n",
       "                }\n",
       "                return \"'\" + v + \"'\";\n",
       "            }\n",
       "            for (var key in options){\n",
       "                var value = options[key];\n",
       "                var hasValue = value != null && typeof value !== 'undefined' && value !== '';\n",
       "                var replaceValue = hasValue ? (key+\"=\" + getStringRep(value) ) : \"\";\n",
       "                var pattern = (hasValue?\"\":\",\")+\"\\\\s*\" + key + \"\\\\s*=\\\\s*'(\\\\\\\\'|[^'])*'\";\n",
       "                var rpattern=new RegExp(pattern);\n",
       "                var n = command.search(rpattern);\n",
       "                if ( n >= 0 ){\n",
       "                    command = command.replace(rpattern, replaceValue);\n",
       "                }else if (hasValue){\n",
       "                    var n = command.lastIndexOf(\")\");\n",
       "                    command = [command.slice(0, n), (command[n-1]==\"(\"? \"\":\",\") + replaceValue, command.slice(n)].join('')\n",
       "                }        \n",
       "            }\n",
       "        }\n",
       "        if(typeof cellMetadata != \"undefined\" && cellMetadata.displayParams){\n",
       "            addOptions(cellMetadata.displayParams);\n",
       "            addOptions({\"showchrome\":\"true\"});\n",
       "        }\n",
       "        addOptions({});\n",
       "        \n",
       "        \n",
       "    \n",
       "var addValueToCommand = function(name, value) {\n",
       "    if (value) {\n",
       "        var startIndex, endIndex;\n",
       "        startIndex = command.indexOf(\",\"+name+\"=\");\n",
       "        if (startIndex >= 0) {\n",
       "            commaIndex = command.indexOf(\",\", startIndex+1);\n",
       "            quoteIndex = command.indexOf(\"'\", startIndex+1);\n",
       "            if (quoteIndex >=0 && quoteIndex < commaIndex) {\n",
       "                // value is enclosed in quotes - end of value will be second quote\n",
       "                endIndex = command.indexOf(\"'\", quoteIndex+1) + 1;\n",
       "            }\n",
       "            else if (commaIndex >= 0) {\n",
       "                // end of value is the comma\n",
       "                endIndex = commaIndex;\n",
       "            }\n",
       "            else {\n",
       "                // no quote or comma found - end of value is at the very end\n",
       "                endIndex = command.indexOf(\")\", startIndex+1);\n",
       "            }\n",
       "        }\n",
       "        else {\n",
       "            startIndex = endIndex = command.lastIndexOf(\")\");\n",
       "        }\n",
       "        var start = command.substring(0,startIndex);\n",
       "        var end = command.substring(endIndex);\n",
       "        command = start + \",\" + name +\"='\" + value + \"'\" + end;\n",
       "    }\n",
       "    else {\n",
       "        var startIndex, endIndex;\n",
       "        startIndex = command.indexOf(\",\"+name+\"=\");\n",
       "        if (startIndex >= 0) {\n",
       "            commaIndex = command.indexOf(\",\", startIndex+1);\n",
       "            quoteIndex = command.indexOf(\"'\", startIndex+1);\n",
       "            if (quoteIndex >=0 && quoteIndex < commaIndex) {\n",
       "                // value is enclosed in quotes - end of value will be second quote\n",
       "                endIndex = command.indexOf(\"'\", quoteIndex+1) + 1;\n",
       "            }\n",
       "            else if (commaIndex >= 0) {\n",
       "                // end of value is the comma\n",
       "                endIndex = commaIndex;\n",
       "            }\n",
       "            else {\n",
       "                // no quote or comma found - end of value is at the very end\n",
       "                endIndex = command.indexOf(\")\", startIndex+1);\n",
       "            }\n",
       "            var start = command.substring(0,startIndex);\n",
       "            var end = command.substring(endIndex);\n",
       "            command = start + end;\n",
       "        }\n",
       "    }\n",
       "};\n",
       "var getListValues = function(listId) {\n",
       "    var value = '';\n",
       "    $(listId + ' li').each(function(idx, li) {\n",
       "        if (value.length != 0) {\n",
       "            value += ',';\n",
       "        }\n",
       "        value += $(li).text();\n",
       "    });\n",
       "    return value;\n",
       "};\n",
       "addValueToCommand('keyFields',getListValues('#keyFields7582f31b'));\n",
       "addValueToCommand('valueFields',getListValues('#valueFields7582f31b'));\n",
       "$('#chartOptions7582f31b *').filter(':input').each(function(){\n",
       "    if ($(this).is(':checkbox')) {\n",
       "        addValueToCommand($(this).attr('name'),$(this).is(':checked')+'');\t\n",
       "    }\n",
       "    else {\n",
       "        addValueToCommand($(this).attr('name'),$(this).val());\n",
       "    }\n",
       "});\n",
       "$('#chartOptions7582f31b *').filter('select').each(function(){\n",
       "    addValueToCommand($(this).attr('name'),$(this).val());\n",
       "});\n",
       "\n",
       "\n",
       "        console.log(\"Running command2\",command);\n",
       "        var pattern = \"\\\\w*\\\\s*=\\\\s*'(\\\\\\\\'|[^'])*'\";\n",
       "        var rpattern=new RegExp(pattern,\"g\");\n",
       "        var n = command.match(rpattern);\n",
       "        var displayParams={}\n",
       "        for (var i = 0; i < n.length; i++){\n",
       "            var parts=n[i].split(\"=\");\n",
       "            var key = parts[0].trim();\n",
       "            var value = parts[1].trim()\n",
       "            if (!key.startsWith(\"nostore_\") && key != \"showchrome\" && key != \"prefix\" && key != \"cell_id\"){\n",
       "                displayParams[key] = value.substring(1,value.length-1);\n",
       "            }\n",
       "        }\n",
       "        if(curCell&&curCell.output_area){\n",
       "            curCell._metadata.pixiedust = curCell._metadata.pixiedust || {}\n",
       "            curCell._metadata.pixiedust.displayParams=displayParams\n",
       "            curCell.output_area.outputs=[];\n",
       "        }\n",
       "        $('#wrapperJS7582f31b').html(\"\")\n",
       "        $('#wrapperHTML7582f31b').html('<div style=\"width:100px;height:60px;left:47%;position:relative\"><i class=\"fa fa-circle-o-notch fa-spin\" style=\"font-size:48px\"></i></div>'+\n",
       "        '<div style=\"text-align:center\">Loading your data. Please wait...</div>');\n",
       "        startWallToWall = new Date().getTime();\n",
       "        IPython.notebook.session.kernel.execute(command, callbacks, {silent:false,store_history:false,stop_on_error:true});\n",
       "    }\n",
       "}\n",
       ")()\n",
       "\n",
       "                    }\n",
       "                },\n",
       "                Cancel: {\n",
       "                    class : \"btn-cancel\",\n",
       "                    click: function(){\n",
       "                        \n",
       "                    }\n",
       "                }\n",
       "                \n",
       "            }\n",
       "        };\n",
       "        var modal_obj = modal(options);\n",
       "        modal_obj.addClass('pixiedust');\n",
       "        modal_obj.on('shown.bs.modal', function(){\n",
       "            \n",
       "$('#chartOptions7582f31b *').filter(':input').each(function(){\n",
       "\tIPython.keyboard_manager.register_events($(this));\n",
       "});\n",
       "$('.field7582f31b').draggable({\n",
       "\thelper:\"clone\",\n",
       "\tcontainment:\"document\"\n",
       "});\n",
       "$('.field7582f31b-remove').click(function(e) {\n",
       "\te.preventDefault();\n",
       "\t$(this).parent().remove();\n",
       "\treturn false;\n",
       "});\n",
       "$('#keyFields7582f31b, #valueFields7582f31b').droppable({\n",
       "\tdrop:function(event, ui) {\n",
       "\t\tvar newId = ui.draggable.attr('id') + '-' + $(this).attr('id');\n",
       "\t\tif ( $('#'+newId).length == 0) { \n",
       "\t\t\tvar el = ui.draggable.clone(true, true);\n",
       "\t\t\tel.attr(\"id\",newId);\n",
       "\t\t\tel.find(\"a\").addClass(\"field-remove\");\n",
       "\t\t\tel.appendTo($(this));\n",
       "\t\t}\n",
       "\t}\n",
       "});\n",
       "\n",
       "        });\n",
       "\n",
       "        })\n",
       "\n",
       "        },\n",
       "        icon: function() {\n",
       "            return mpld3.icons[\"brush\"];\n",
       "        }\n",
       "    });\n",
       "    this.fig.buttons.push(DialogPluginButton);\n",
       "}\n",
       "                 mpld3.draw_figure(\"fig_el392831401358718993448750349467\", {\"axes\": [{\"xlim\": [0.0, 1489614090000.0], \"yscale\": \"linear\", \"axesbg\": \"#FFFFFF\", \"texts\": [{\"v_baseline\": \"hanging\", \"h_anchor\": \"middle\", \"color\": \"#000000\", \"text\": \"ts\", \"coordinates\": \"axes\", \"zorder\": 3, \"alpha\": 1, \"fontsize\": 18.0, \"position\": [0.5, -0.059895833333333329], \"rotation\": -0.0, \"id\": \"el39283140135868045520\"}, {\"v_baseline\": \"auto\", \"h_anchor\": \"start\", \"color\": \"#00007F\", \"text\": \"temperature\", \"coordinates\": \"axes\", \"zorder\": 1000003.0, \"alpha\": 1, \"fontsize\": 14.399999999999999, \"position\": [0.7920698924731181, 0.93124999999999991], \"rotation\": -0.0, \"id\": \"el39283140134522198032\"}, {\"v_baseline\": \"auto\", \"h_anchor\": \"start\", \"color\": \"#000088\", \"text\": \"flowrate\", \"coordinates\": \"axes\", \"zorder\": 1000003.0, \"alpha\": 1, \"fontsize\": 14.399999999999999, \"position\": [0.7920698924731181, 0.87135416666666654], \"rotation\": -0.0, \"id\": \"el39283140134522199952\"}], \"zoomable\": true, \"images\": [], \"xdomain\": [0.0, 1489614090000.0], \"ylim\": [10.0, 100.0], \"paths\": [{\"edgecolor\": \"none\", \"facecolor\": \"none\", \"edgewidth\": 1.0, \"pathcodes\": [\"M\", \"L\", \"L\", \"L\", \"Z\"], \"yindex\": 1, \"coordinates\": \"axes\", \"dasharray\": \"10,0\", \"zorder\": 1000001.0, \"alpha\": 0, \"xindex\": 0, \"data\": \"data03\", \"id\": \"el39283140134522197648\"}], \"sharey\": [], \"sharex\": [], \"axesbgalpha\": null, \"axes\": [{\"scale\": \"linear\", \"tickformat\": null, \"grid\": {\"color\": \"#D3D3D3\", \"alpha\": 0.7, \"dasharray\": \"2,2\", \"gridOn\": true}, \"fontsize\": 12.0, \"position\": \"bottom\", \"nticks\": 100, \"tickvalues\": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99]}, {\"scale\": \"linear\", \"tickformat\": null, \"grid\": {\"color\": \"#D3D3D3\", \"alpha\": 0.7, \"dasharray\": \"2,2\", \"gridOn\": true}, \"fontsize\": 12.0, \"position\": \"left\", \"nticks\": 10, \"tickvalues\": null}], \"lines\": [{\"color\": \"#00007F\", \"yindex\": 1, \"coordinates\": \"data\", \"dasharray\": \"10,0\", \"zorder\": 2, \"alpha\": 1, \"xindex\": 0, \"linewidth\": 1.0, \"data\": \"data01\", \"id\": \"el39283140134784094800\"}, {\"color\": \"#000088\", \"yindex\": 2, \"coordinates\": \"data\", \"dasharray\": \"10,0\", \"zorder\": 2, \"alpha\": 1, \"xindex\": 0, \"linewidth\": 1.0, \"data\": \"data01\", \"id\": \"el39283140134784096336\"}, {\"color\": \"#00007F\", \"yindex\": 1, \"coordinates\": \"axes\", \"dasharray\": \"10,0\", \"zorder\": 1000002.0, \"alpha\": 1, \"xindex\": 0, \"linewidth\": 10.0, \"data\": \"data02\", \"id\": \"el39283140134522198544\"}, {\"color\": \"#000088\", \"yindex\": 2, \"coordinates\": \"axes\", \"dasharray\": \"10,0\", \"zorder\": 1000002.0, \"alpha\": 1, \"xindex\": 0, \"linewidth\": 10.0, \"data\": \"data02\", \"id\": \"el39283140134521586128\"}], \"markers\": [{\"edgecolor\": \"#000000\", \"facecolor\": \"#00007F\", \"edgewidth\": 0.5, \"yindex\": 1, \"coordinates\": \"data\", \"zorder\": 2, \"markerpath\": [[[0.0, 3.0], [0.7956093000000001, 3.0], [1.5587396123545605, 2.683901074764725], [2.121320343559643, 2.121320343559643], [2.683901074764725, 1.5587396123545605], [3.0, 0.7956093000000001], [3.0, 0.0], [3.0, -0.7956093000000001], [2.683901074764725, -1.5587396123545605], [2.121320343559643, -2.121320343559643], [1.5587396123545605, -2.683901074764725], [0.7956093000000001, -3.0], [0.0, -3.0], [-0.7956093000000001, -3.0], [-1.5587396123545605, -2.683901074764725], [-2.121320343559643, -2.121320343559643], [-2.683901074764725, -1.5587396123545605], [-3.0, -0.7956093000000001], [-3.0, 0.0], [-3.0, 0.7956093000000001], [-2.683901074764725, 1.5587396123545605], [-2.121320343559643, 2.121320343559643], [-1.5587396123545605, 2.683901074764725], [-0.7956093000000001, 3.0], [0.0, 3.0]], [\"M\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"Z\"]], \"alpha\": 1, \"xindex\": 0, \"data\": \"data01\", \"id\": \"el39283140134784094800pts\"}, {\"edgecolor\": \"#000000\", \"facecolor\": \"#000088\", \"edgewidth\": 0.5, \"yindex\": 2, \"coordinates\": \"data\", \"zorder\": 2, \"markerpath\": [[[0.0, 3.0], [0.7956093000000001, 3.0], [1.5587396123545605, 2.683901074764725], [2.121320343559643, 2.121320343559643], [2.683901074764725, 1.5587396123545605], [3.0, 0.7956093000000001], [3.0, 0.0], [3.0, -0.7956093000000001], [2.683901074764725, -1.5587396123545605], [2.121320343559643, -2.121320343559643], [1.5587396123545605, -2.683901074764725], [0.7956093000000001, -3.0], [0.0, -3.0], [-0.7956093000000001, -3.0], [-1.5587396123545605, -2.683901074764725], [-2.121320343559643, -2.121320343559643], [-2.683901074764725, -1.5587396123545605], [-3.0, -0.7956093000000001], [-3.0, 0.0], [-3.0, 0.7956093000000001], [-2.683901074764725, 1.5587396123545605], [-2.121320343559643, 2.121320343559643], [-1.5587396123545605, 2.683901074764725], [-0.7956093000000001, 3.0], [0.0, 3.0]], [\"M\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"Z\"]], \"alpha\": 1, \"xindex\": 0, \"data\": \"data01\", \"id\": \"el39283140134784096336pts\"}, {\"edgecolor\": \"#000000\", \"facecolor\": \"#00007F\", \"edgewidth\": 0.5, \"yindex\": 1, \"coordinates\": \"axes\", \"zorder\": 1000002.0, \"markerpath\": [[[0.0, 3.0], [0.7956093000000001, 3.0], [1.5587396123545605, 2.683901074764725], [2.121320343559643, 2.121320343559643], [2.683901074764725, 1.5587396123545605], [3.0, 0.7956093000000001], [3.0, 0.0], [3.0, -0.7956093000000001], [2.683901074764725, -1.5587396123545605], [2.121320343559643, -2.121320343559643], [1.5587396123545605, -2.683901074764725], [0.7956093000000001, -3.0], [0.0, -3.0], [-0.7956093000000001, -3.0], [-1.5587396123545605, -2.683901074764725], [-2.121320343559643, -2.121320343559643], [-2.683901074764725, -1.5587396123545605], [-3.0, -0.7956093000000001], [-3.0, 0.0], [-3.0, 0.7956093000000001], [-2.683901074764725, 1.5587396123545605], [-2.121320343559643, 2.121320343559643], [-1.5587396123545605, 2.683901074764725], [-0.7956093000000001, 3.0], [0.0, 3.0]], [\"M\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"Z\"]], \"alpha\": 1, \"xindex\": 0, \"data\": \"data02\", \"id\": \"el39283140134522198992pts\"}, {\"edgecolor\": \"#000000\", \"facecolor\": \"#000088\", \"edgewidth\": 0.5, \"yindex\": 2, \"coordinates\": \"axes\", \"zorder\": 1000002.0, \"markerpath\": [[[0.0, 3.0], [0.7956093000000001, 3.0], [1.5587396123545605, 2.683901074764725], [2.121320343559643, 2.121320343559643], [2.683901074764725, 1.5587396123545605], [3.0, 0.7956093000000001], [3.0, 0.0], [3.0, -0.7956093000000001], [2.683901074764725, -1.5587396123545605], [2.121320343559643, -2.121320343559643], [1.5587396123545605, -2.683901074764725], [0.7956093000000001, -3.0], [0.0, -3.0], [-0.7956093000000001, -3.0], [-1.5587396123545605, -2.683901074764725], [-2.121320343559643, -2.121320343559643], [-2.683901074764725, -1.5587396123545605], [-3.0, -0.7956093000000001], [-3.0, 0.0], [-3.0, 0.7956093000000001], [-2.683901074764725, 1.5587396123545605], [-2.121320343559643, 2.121320343559643], [-1.5587396123545605, 2.683901074764725], [-0.7956093000000001, 3.0], [0.0, 3.0]], [\"M\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"C\", \"Z\"]], \"alpha\": 1, \"xindex\": 0, \"data\": \"data02\", \"id\": \"el39283140134521586576pts\"}], \"id\": \"el39283140135868045648\", \"ydomain\": [10.0, 100.0], \"collections\": [], \"xscale\": \"linear\", \"bbox\": [0.125, 0.099999999999999978, 0.77500000000000002, 0.80000000000000004]}], \"height\": 480.0, \"width\": 720.0, \"plugins\": [{\"type\": \"reset\"}, {\"enabled\": false, \"button\": true, \"type\": \"zoom\"}, {\"enabled\": false, \"button\": true, \"type\": \"boxzoom\"}, {\"labels\": [\"1489614021053\", \"1489614022065\", \"1489614023065\", \"1489614023066\", \"1489614024070\", \"1489614025071\", \"1489614025088\", \"1489614026067\", \"1489614026090\", \"1489614027093\", \"1489614028107\", \"1489614029070\", \"1489614029112\", \"1489614030078\", \"1489614030131\", \"1489614031133\", \"1489614032077\", \"1489614032147\", \"1489614033149\", \"1489614034153\", \"1489614035081\", \"1489614035101\", \"1489614035154\", \"1489614036159\", \"1489614037167\", \"1489614038105\", \"1489614038171\", \"1489614039176\", \"1489614040122\", \"1489614040179\", \"1489614041107\", \"1489614041185\", \"1489614042188\", \"1489614043203\", \"1489614044109\", \"1489614044213\", \"1489614045125\", \"1489614045219\", \"1489614046222\", \"1489614047150\", \"1489614047224\", \"1489614048227\", \"1489614049229\", \"1489614050128\", \"1489614050185\", \"1489614050233\", \"1489614051236\", \"1489614052238\", \"1489614053188\", \"1489614053240\", \"1489614054245\", \"1489614055131\", \"1489614055252\", \"1489614056201\", \"1489614056255\", \"1489614057259\", \"1489614058264\", \"1489614059204\", \"1489614059267\", \"1489614060133\", \"1489614060285\", \"1489614061291\", \"1489614062206\", \"1489614062295\", \"1489614063298\", \"1489614064301\", \"1489614065135\", \"1489614065216\", \"1489614065305\", \"1489614066307\", \"1489614067311\", \"1489614068220\", \"1489614068317\", \"1489614069321\", \"1489614070140\", \"1489614070328\", \"1489614071223\", \"1489614071333\", \"1489614072337\", \"1489614073343\", \"1489614074226\", \"1489614074347\", \"1489614075142\", \"1489614075352\", \"1489614076354\", \"1489614077234\", \"1489614077355\", \"1489614078357\", \"1489614079359\", \"1489614080145\", \"1489614080237\", \"1489614080365\", \"1489614081368\", \"1489614082373\", \"1489614083240\", \"1489614083378\", \"1489614084395\", \"1489614085159\", \"1489614085397\", \"1489614086255\"], \"type\": \"chart\"}, {\"handlerId\": \"lineChart\", \"type\": \"dialog\"}, {\"voffset\": 10, \"labels\": [98, 88, 80, 86, 99, 80, 87, 93, 83, 85, 87, 84, 86, 91, 93, 98, 91, 80, 95, 84, 94, 93, 98, 91, 91, 96, 80, 87, 98, 80, 86, 97, 82, 95, 94, 95, 82, 89, 98, 91, 88, 100, 92, 92, 89, 83, 88, 98, 91, 90, 94, 89, 91, 82, 87, 87, 93, 99, 84, 87, 95, 99, 82, 95, 84, 98, 92, 85, 95, 89, 89, 98, 93, 99, 83, 86, 84, 80, 81, 90, 95, 82, 88, 90, 96, 94, 90, 92, 96, 90, 93, 86, 80, 96, 97, 91, 93, 85, 81, 81], \"hoffset\": 0, \"location\": \"mouse\", \"type\": \"tooltip\", \"id\": \"el39283140134784094800pts\"}, {\"voffset\": 10, \"labels\": [11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11], \"hoffset\": 0, \"location\": \"mouse\", \"type\": \"tooltip\", \"id\": \"el39283140134784096336pts\"}], \"data\": {\"data02\": [[0.7203853046594981, 0.9458333333333332, 0.8859374999999998], [0.7605286738351255, 0.9458333333333332, 0.8859374999999998]], \"data03\": [[0.7003136200716846, 0.8468749999999999], [0.985663082437276, 0.8468749999999999], [0.985663082437276, 0.9791666666666665], [0.7003136200716846, 0.9791666666666665]], \"data01\": [[1489614021053.0, 98.0, 11.0], [1489614022065.0, 88.0, 11.0], [1489614023065.0, 80.0, 11.0], [1489614023066.0, 86.0, 11.0], [1489614024070.0, 99.0, 11.0], [1489614025071.0, 80.0, 11.0], [1489614025088.0, 87.0, 11.0], [1489614026067.0, 93.0, 11.0], [1489614026090.0, 83.0, 11.0], [1489614027093.0, 85.0, 11.0], [1489614028107.0, 87.0, 11.0], [1489614029070.0, 84.0, 11.0], [1489614029112.0, 86.0, 11.0], [1489614030078.0, 91.0, 11.0], [1489614030131.0, 93.0, 11.0], [1489614031133.0, 98.0, 11.0], [1489614032077.0, 91.0, 11.0], [1489614032147.0, 80.0, 11.0], [1489614033149.0, 95.0, 11.0], [1489614034153.0, 84.0, 11.0], [1489614035081.0, 94.0, 11.0], [1489614035101.0, 93.0, 11.0], [1489614035154.0, 98.0, 11.0], [1489614036159.0, 91.0, 11.0], [1489614037167.0, 91.0, 11.0], [1489614038105.0, 96.0, 11.0], [1489614038171.0, 80.0, 11.0], [1489614039176.0, 87.0, 11.0], [1489614040122.0, 98.0, 11.0], [1489614040179.0, 80.0, 11.0], [1489614041107.0, 86.0, 11.0], [1489614041185.0, 97.0, 11.0], [1489614042188.0, 82.0, 11.0], [1489614043203.0, 95.0, 11.0], [1489614044109.0, 94.0, 11.0], [1489614044213.0, 95.0, 11.0], [1489614045125.0, 82.0, 11.0], [1489614045219.0, 89.0, 11.0], [1489614046222.0, 98.0, 11.0], [1489614047150.0, 91.0, 11.0], [1489614047224.0, 88.0, 11.0], [1489614048227.0, 100.0, 11.0], [1489614049229.0, 92.0, 11.0], [1489614050128.0, 92.0, 11.0], [1489614050185.0, 89.0, 11.0], [1489614050233.0, 83.0, 11.0], [1489614051236.0, 88.0, 11.0], [1489614052238.0, 98.0, 11.0], [1489614053188.0, 91.0, 11.0], [1489614053240.0, 90.0, 11.0], [1489614054245.0, 94.0, 11.0], [1489614055131.0, 89.0, 11.0], [1489614055252.0, 91.0, 11.0], [1489614056201.0, 82.0, 11.0], [1489614056255.0, 87.0, 11.0], [1489614057259.0, 87.0, 11.0], [1489614058264.0, 93.0, 11.0], [1489614059204.0, 99.0, 11.0], [1489614059267.0, 84.0, 11.0], [1489614060133.0, 87.0, 11.0], [1489614060285.0, 95.0, 11.0], [1489614061291.0, 99.0, 11.0], [1489614062206.0, 82.0, 11.0], [1489614062295.0, 95.0, 11.0], [1489614063298.0, 84.0, 11.0], [1489614064301.0, 98.0, 11.0], [1489614065135.0, 92.0, 11.0], [1489614065216.0, 85.0, 11.0], [1489614065305.0, 95.0, 11.0], [1489614066307.0, 89.0, 11.0], [1489614067311.0, 89.0, 11.0], [1489614068220.0, 98.0, 11.0], [1489614068317.0, 93.0, 11.0], [1489614069321.0, 99.0, 11.0], [1489614070140.0, 83.0, 11.0], [1489614070328.0, 86.0, 11.0], [1489614071223.0, 84.0, 11.0], [1489614071333.0, 80.0, 11.0], [1489614072337.0, 81.0, 11.0], [1489614073343.0, 90.0, 11.0], [1489614074226.0, 95.0, 11.0], [1489614074347.0, 82.0, 11.0], [1489614075142.0, 88.0, 11.0], [1489614075352.0, 90.0, 11.0], [1489614076354.0, 96.0, 11.0], [1489614077234.0, 94.0, 11.0], [1489614077355.0, 90.0, 11.0], [1489614078357.0, 92.0, 11.0], [1489614079359.0, 96.0, 11.0], [1489614080145.0, 90.0, 11.0], [1489614080237.0, 93.0, 11.0], [1489614080365.0, 86.0, 11.0], [1489614081368.0, 80.0, 11.0], [1489614082373.0, 96.0, 11.0], [1489614083240.0, 97.0, 11.0], [1489614083378.0, 91.0, 11.0], [1489614084395.0, 93.0, 11.0], [1489614085159.0, 85.0, 11.0], [1489614085397.0, 81.0, 11.0], [1489614086255.0, 81.0, 11.0]]}, \"id\": \"el39283140135871899344\"});\n",
       "            })\n",
       "         });\n",
       "}\n",
       "</script><div class=\"executionTime\" id=\"execution7582f31b\">Execution time: 0.92s</div>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "from pixiedust.display import *\n",
    "display(cloudantdata)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "spark.sql(\"select avg(voltage), stdev(voltage), max(voltage) from washing\").show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "+-----------------+------------------+\n",
      "|             mean|               std|\n",
      "+-----------------+------------------+\n",
      "|229.3793103448276|6.5269430227078615|\n",
      "+-----------------+------------------+\n",
      "\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-3.8779931893052'), voltage=255),\n",
       " Row(zscore=Decimal('-4.4801982896444'), voltage=259),\n",
       " Row(zscore=Decimal('-4.1790957394748'), voltage=257),\n",
       " Row(zscore=Decimal('-2.8241342637116'), voltage=248),\n",
       " Row(zscore=Decimal('-3.1252368138812'), voltage=250),\n",
       " Row(zscore=Decimal('-2.9746855387964'), voltage=249),\n",
       " Row(zscore=Decimal('-3.1252368138812'), voltage=250),\n",
       " Row(zscore=Decimal('-3.8779931893052'), voltage=255),\n",
       " Row(zscore=Decimal('-2.9746855387964'), voltage=249),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-3.4263393640508'), voltage=252),\n",
       " Row(zscore=Decimal('-2.0713778882876'), voltage=243),\n",
       " Row(zscore=Decimal('-1.7702753381180'), voltage=241),\n",
       " Row(zscore=Decimal('-2.6735829886268'), voltage=247),\n",
       " Row(zscore=Decimal('-3.7274419142204'), voltage=254),\n",
       " Row(zscore=Decimal('-1.7702753381180'), voltage=241),\n",
       " Row(zscore=Decimal('-2.6735829886268'), voltage=247),\n",
       " Row(zscore=Decimal('-1.9208266132028'), voltage=242),\n",
       " Row(zscore=Decimal('-4.4801982896444'), voltage=259),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('-1.9208266132028'), voltage=242),\n",
       " Row(zscore=Decimal('-4.1790957394748'), voltage=257),\n",
       " Row(zscore=Decimal('-2.8241342637116'), voltage=248),\n",
       " Row(zscore=Decimal('-4.3296470145596'), voltage=258),\n",
       " Row(zscore=Decimal('-2.6735829886268'), voltage=247),\n",
       " Row(zscore=Decimal('-1.9208266132028'), voltage=242),\n",
       " Row(zscore=Decimal('-4.1790957394748'), voltage=257),\n",
       " Row(zscore=Decimal('-4.3296470145596'), voltage=258),\n",
       " Row(zscore=Decimal('-3.8779931893052'), voltage=255),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-3.4263393640508'), voltage=252),\n",
       " Row(zscore=Decimal('-3.4263393640508'), voltage=252),\n",
       " Row(zscore=Decimal('-3.8779931893052'), voltage=255),\n",
       " Row(zscore=Decimal('-4.4801982896444'), voltage=259),\n",
       " Row(zscore=Decimal('-2.5230317135420'), voltage=246),\n",
       " Row(zscore=Decimal('-3.1252368138812'), voltage=250),\n",
       " Row(zscore=Decimal('-2.9746855387964'), voltage=249),\n",
       " Row(zscore=Decimal('-4.3296470145596'), voltage=258),\n",
       " Row(zscore=Decimal('-2.9746855387964'), voltage=249),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-3.2757880889660'), voltage=251),\n",
       " Row(zscore=Decimal('-2.3724804384572'), voltage=245),\n",
       " Row(zscore=Decimal('-2.3724804384572'), voltage=245),\n",
       " Row(zscore=Decimal('-4.4801982896444'), voltage=259),\n",
       " Row(zscore=Decimal('-1.9208266132028'), voltage=242),\n",
       " Row(zscore=Decimal('-4.3296470145596'), voltage=258),\n",
       " Row(zscore=Decimal('-4.0285444643900'), voltage=256),\n",
       " Row(zscore=Decimal('-2.0713778882876'), voltage=243),\n",
       " Row(zscore=Decimal('-2.6735829886268'), voltage=247),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('-2.8241342637116'), voltage=248),\n",
       " Row(zscore=Decimal('-2.0713778882876'), voltage=243),\n",
       " Row(zscore=Decimal('-3.8779931893052'), voltage=255),\n",
       " Row(zscore=Decimal('-3.5768906391356'), voltage=253),\n",
       " Row(zscore=Decimal('-2.6735829886268'), voltage=247),\n",
       " Row(zscore=Decimal('-2.6735829886268'), voltage=247),\n",
       " Row(zscore=Decimal('-2.5230317135420'), voltage=246),\n",
       " Row(zscore=Decimal('-2.3724804384572'), voltage=245),\n",
       " Row(zscore=Decimal('-2.0713778882876'), voltage=243),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-1.7702753381180'), voltage=241),\n",
       " Row(zscore=Decimal('-4.1790957394748'), voltage=257),\n",
       " Row(zscore=Decimal('-2.2219291633724'), voltage=244),\n",
       " Row(zscore=Decimal('-1.9208266132028'), voltage=242),\n",
       " Row(zscore=Decimal('-1.9208266132028'), voltage=242),\n",
       " Row(zscore=Decimal('-3.1252368138812'), voltage=250),\n",
       " Row(zscore=Decimal('-2.3724804384572'), voltage=245),\n",
       " Row(zscore=Decimal('-3.2757880889660'), voltage=251),\n",
       " Row(zscore=Decimal('-3.1252368138812'), voltage=250),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-2.8241342637116'), voltage=248),\n",
       " Row(zscore=Decimal('-4.1790957394748'), voltage=257),\n",
       " Row(zscore=Decimal('-2.3724804384572'), voltage=245),\n",
       " Row(zscore=Decimal('-2.9746855387964'), voltage=249),\n",
       " Row(zscore=Decimal('-2.3724804384572'), voltage=245),\n",
       " Row(zscore=Decimal('-4.1790957394748'), voltage=257),\n",
       " Row(zscore=Decimal('-3.7274419142204'), voltage=254),\n",
       " Row(zscore=Decimal('-3.8779931893052'), voltage=255),\n",
       " Row(zscore=Decimal('-3.5768906391356'), voltage=253),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('-0.7164164125244'), voltage=234),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('0.4879937881540'), voltage=226),\n",
       " Row(zscore=Decimal('-1.1680702377788'), voltage=237),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('-2.8241342637116'), voltage=248),\n",
       " Row(zscore=Decimal('-3.4263393640508'), voltage=252),\n",
       " Row(zscore=Decimal('-2.5230317135420'), voltage=246),\n",
       " Row(zscore=Decimal('-1.7702753381180'), voltage=241),\n",
       " Row(zscore=Decimal('-3.7274419142204'), voltage=254),\n",
       " Row(zscore=Decimal('-3.2757880889660'), voltage=251),\n",
       " Row(zscore=Decimal('-4.0285444643900'), voltage=256),\n",
       " Row(zscore=Decimal('-3.8779931893052'), voltage=255),\n",
       " Row(zscore=Decimal('-2.6735829886268'), voltage=247),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('0.0363399628996'), voltage=229),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('0.7890963383236'), voltage=224),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('1.0901988884932'), voltage=222),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('0.6385450632388'), voltage=225),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-0.5658651374396'), voltage=233),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-1.4691727879484'), voltage=239),\n",
       " Row(zscore=Decimal('1.2407501635780'), voltage=221),\n",
       " Row(zscore=Decimal('0.3374425130692'), voltage=227),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('-1.3186215128636'), voltage=238),\n",
       " Row(zscore=Decimal('1.3913014386628'), voltage=220),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('0.9396476134084'), voltage=223),\n",
       " Row(zscore=Decimal('-0.4153138623548'), voltage=232),\n",
       " Row(zscore=Decimal('-0.2647625872700'), voltage=231),\n",
       " Row(zscore=Decimal('-1.0175189626940'), voltage=236),\n",
       " Row(zscore=Decimal('-0.1142113121852'), voltage=230),\n",
       " Row(zscore=Decimal('-0.8669676876092'), voltage=235),\n",
       " Row(zscore=Decimal('0.1868912379844'), voltage=228),\n",
       " ...]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = spark.sql(\"\"\"\n",
    "select mean(voltage) as mean, std(voltage) as std from (\n",
    "    SELECT ROW_NUMBER() OVER (ORDER BY ts desc) AS row, * FROM washing where voltage is not null\n",
    ") where\n",
    "row < 30\n",
    "\"\"\")\n",
    "               \n",
    "df.show()\n",
    "mean = df.first().mean\n",
    "std = df.first().std\n",
    "spark.sql(\"SELECT ({0}-voltage)/({1}+0.0001) as zscore, voltage FROM washing where voltage is not null order by ts desc\".format(mean,std)).collect()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "200"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import requests\n",
    "r = requests.get(\"https://1234thisismyname.mybluemix.net/edgemodelupdate?command=emergencyshutdown\")\n",
    "r.status_code"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2 with Spark 2.0",
   "language": "python",
   "name": "python2-spark20"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}