{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": true }, "outputs": [], "source": [ "%matplotlib notebook\n", "import matplotlib.pyplot as plt\n", "import pandas as pd\n", "import numpy as np" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Fecha_horaPPh-1Ph-2Ph-3Ph-24Ph-48Ph-168lunmmjvsabdom
02016-08-01 00:00:0055.4450NaNNaNNaNNaNNaNNaN1000
12016-08-01 01:00:0040.116955.4450NaNNaNNaNNaNNaN1000
22016-08-01 02:00:0034.064540.116955.4450NaNNaNNaNNaN1000
32016-08-01 03:00:0031.126134.064540.116955.4450NaNNaNNaN1000
42016-08-01 04:00:0029.724031.126134.064540.1169NaNNaNNaN1000
\n", "
" ], "text/plain": [ " Fecha_hora P Ph-1 Ph-2 Ph-3 Ph-24 Ph-48 \\\n", "0 2016-08-01 00:00:00 55.4450 NaN NaN NaN NaN NaN \n", "1 2016-08-01 01:00:00 40.1169 55.4450 NaN NaN NaN NaN \n", "2 2016-08-01 02:00:00 34.0645 40.1169 55.4450 NaN NaN NaN \n", "3 2016-08-01 03:00:00 31.1261 34.0645 40.1169 55.4450 NaN NaN \n", "4 2016-08-01 04:00:00 29.7240 31.1261 34.0645 40.1169 NaN NaN \n", "\n", " Ph-168 lun mmjv sab dom \n", "0 NaN 1 0 0 0 \n", "1 NaN 1 0 0 0 \n", "2 NaN 1 0 0 0 \n", "3 NaN 1 0 0 0 \n", "4 NaN 1 0 0 0 " ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "prices = pd.read_excel(\"lbrprices.xlsx\")\n", "prices.head()" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "Index(['Fecha_hora', 'P', 'Ph-1', 'Ph-2', 'Ph-3', 'Ph-24', 'Ph-48', 'Ph-168',\n", " 'lun', 'mmjv', 'sab', 'dom'],\n", " dtype='object')" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "prices.columns" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "0 2016-08-01 00:00:00\n", "1 2016-08-01 01:00:00\n", "2 2016-08-01 02:00:00\n", "3 2016-08-01 03:00:00\n", "4 2016-08-01 04:00:00\n", "Name: Fecha_hora, dtype: datetime64[ns]" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "prices['Fecha_hora'].head()" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": true }, "outputs": [], "source": [ "prices = prices[['Fecha_hora', 'P']]" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Fecha_horaP
02016-08-01 00:00:0055.4450
12016-08-01 01:00:0040.1169
22016-08-01 02:00:0034.0645
32016-08-01 03:00:0031.1261
42016-08-01 04:00:0029.7240
\n", "
" ], "text/plain": [ " Fecha_hora P\n", "0 2016-08-01 00:00:00 55.4450\n", "1 2016-08-01 01:00:00 40.1169\n", "2 2016-08-01 02:00:00 34.0645\n", "3 2016-08-01 03:00:00 31.1261\n", "4 2016-08-01 04:00:00 29.7240" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "prices.head()" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Fecha_horaPP
02016-08-01 00:00:0055.4450NaN
12016-08-01 01:00:0040.1169NaN
22016-08-01 02:00:0034.0645NaN
32016-08-01 03:00:0031.1261NaN
42016-08-01 04:00:0029.7240NaN
52016-08-01 05:00:0032.3707NaN
62016-08-01 06:00:0035.1250NaN
72016-08-01 07:00:0038.6416NaN
82016-08-01 08:00:0048.4632NaN
92016-08-01 09:00:0049.4265NaN
102016-08-01 10:00:0045.0187NaN
112016-08-01 11:00:0045.5868NaN
122016-08-01 12:00:0047.5454NaN
132016-08-01 13:00:0047.6542NaN
142016-08-01 14:00:0046.3099NaN
152016-08-01 15:00:0048.1719NaN
162016-08-01 16:00:0047.4186NaN
172016-08-01 17:00:0045.7651NaN
182016-08-01 18:00:0048.9220NaN
192016-08-01 19:00:0050.3570NaN
202016-08-01 20:00:0045.0160NaN
212016-08-01 21:00:0050.7729NaN
222016-08-01 22:00:0048.3555NaN
232016-08-01 23:00:0049.8514NaN
242016-08-02 00:00:0042.208755.4450
252016-08-02 01:00:0038.871540.1169
262016-08-02 02:00:0035.539234.0645
272016-08-02 03:00:0038.838731.1261
282016-08-02 04:00:0033.062029.7240
292016-08-02 05:00:0035.247132.3707
............
206822018-12-10 18:00:00106.412869.6707
206832018-12-10 19:00:00129.257873.3712
206842018-12-10 20:00:00117.115069.1453
206852018-12-10 21:00:00144.882070.0111
206862018-12-10 22:00:00103.700066.9332
206872018-12-10 23:00:0088.465559.1993
206882018-12-11 00:00:0070.476251.8596
206892018-12-11 01:00:0063.954347.1863
206902018-12-11 02:00:0058.560046.0043
206912018-12-11 03:00:0052.107045.0487
206922018-12-11 04:00:0053.968645.3595
206932018-12-11 05:00:0061.563948.9978
206942018-12-11 06:00:0074.741067.7778
206952018-12-11 07:00:0085.115980.6690
206962018-12-11 08:00:0094.7120105.9934
206972018-12-11 09:00:00100.5628110.8088
206982018-12-11 10:00:0096.5661116.1816
206992018-12-11 11:00:00106.0722122.7567
207002018-12-11 12:00:00106.3128125.5741
207012018-12-11 13:00:00105.6875112.8655
207022018-12-11 14:00:00106.1539130.4650
207032018-12-11 15:00:00102.3658136.3701
207042018-12-11 16:00:00103.0934130.1201
207052018-12-11 17:00:00101.9319110.6386
207062018-12-11 18:00:00125.8868106.4128
207072018-12-11 19:00:00101.8847129.2578
207082018-12-11 20:00:00109.3477117.1150
207092018-12-11 21:00:00109.5164144.8820
207102018-12-11 22:00:00101.5718103.7000
207112018-12-11 23:00:0075.213888.4655
\n", "

20712 rows × 3 columns

\n", "
" ], "text/plain": [ " Fecha_hora P P\n", "0 2016-08-01 00:00:00 55.4450 NaN\n", "1 2016-08-01 01:00:00 40.1169 NaN\n", "2 2016-08-01 02:00:00 34.0645 NaN\n", "3 2016-08-01 03:00:00 31.1261 NaN\n", "4 2016-08-01 04:00:00 29.7240 NaN\n", "5 2016-08-01 05:00:00 32.3707 NaN\n", "6 2016-08-01 06:00:00 35.1250 NaN\n", "7 2016-08-01 07:00:00 38.6416 NaN\n", "8 2016-08-01 08:00:00 48.4632 NaN\n", "9 2016-08-01 09:00:00 49.4265 NaN\n", "10 2016-08-01 10:00:00 45.0187 NaN\n", "11 2016-08-01 11:00:00 45.5868 NaN\n", "12 2016-08-01 12:00:00 47.5454 NaN\n", "13 2016-08-01 13:00:00 47.6542 NaN\n", "14 2016-08-01 14:00:00 46.3099 NaN\n", "15 2016-08-01 15:00:00 48.1719 NaN\n", "16 2016-08-01 16:00:00 47.4186 NaN\n", "17 2016-08-01 17:00:00 45.7651 NaN\n", "18 2016-08-01 18:00:00 48.9220 NaN\n", "19 2016-08-01 19:00:00 50.3570 NaN\n", "20 2016-08-01 20:00:00 45.0160 NaN\n", "21 2016-08-01 21:00:00 50.7729 NaN\n", "22 2016-08-01 22:00:00 48.3555 NaN\n", "23 2016-08-01 23:00:00 49.8514 NaN\n", "24 2016-08-02 00:00:00 42.2087 55.4450\n", "25 2016-08-02 01:00:00 38.8715 40.1169\n", "26 2016-08-02 02:00:00 35.5392 34.0645\n", "27 2016-08-02 03:00:00 38.8387 31.1261\n", "28 2016-08-02 04:00:00 33.0620 29.7240\n", "29 2016-08-02 05:00:00 35.2471 32.3707\n", "... ... ... ...\n", "20682 2018-12-10 18:00:00 106.4128 69.6707\n", "20683 2018-12-10 19:00:00 129.2578 73.3712\n", "20684 2018-12-10 20:00:00 117.1150 69.1453\n", "20685 2018-12-10 21:00:00 144.8820 70.0111\n", "20686 2018-12-10 22:00:00 103.7000 66.9332\n", "20687 2018-12-10 23:00:00 88.4655 59.1993\n", "20688 2018-12-11 00:00:00 70.4762 51.8596\n", "20689 2018-12-11 01:00:00 63.9543 47.1863\n", "20690 2018-12-11 02:00:00 58.5600 46.0043\n", "20691 2018-12-11 03:00:00 52.1070 45.0487\n", "20692 2018-12-11 04:00:00 53.9686 45.3595\n", "20693 2018-12-11 05:00:00 61.5639 48.9978\n", "20694 2018-12-11 06:00:00 74.7410 67.7778\n", "20695 2018-12-11 07:00:00 85.1159 80.6690\n", "20696 2018-12-11 08:00:00 94.7120 105.9934\n", "20697 2018-12-11 09:00:00 100.5628 110.8088\n", "20698 2018-12-11 10:00:00 96.5661 116.1816\n", "20699 2018-12-11 11:00:00 106.0722 122.7567\n", "20700 2018-12-11 12:00:00 106.3128 125.5741\n", "20701 2018-12-11 13:00:00 105.6875 112.8655\n", "20702 2018-12-11 14:00:00 106.1539 130.4650\n", "20703 2018-12-11 15:00:00 102.3658 136.3701\n", "20704 2018-12-11 16:00:00 103.0934 130.1201\n", "20705 2018-12-11 17:00:00 101.9319 110.6386\n", "20706 2018-12-11 18:00:00 125.8868 106.4128\n", "20707 2018-12-11 19:00:00 101.8847 129.2578\n", "20708 2018-12-11 20:00:00 109.3477 117.1150\n", "20709 2018-12-11 21:00:00 109.5164 144.8820\n", "20710 2018-12-11 22:00:00 101.5718 103.7000\n", "20711 2018-12-11 23:00:00 75.2138 88.4655\n", "\n", "[20712 rows x 3 columns]" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "pd.concat([prices, prices['P'].shift(24)], axis=1)" ] }, { "cell_type": "code", "execution_count": 11, "metadata": { "collapsed": true, "scrolled": true }, "outputs": [], "source": [ "prices = prices.set_index([\"Fecha_hora\"])" ] }, { "cell_type": "code", "execution_count": 16, "metadata": {}, "outputs": [ { "data": { "application/javascript": [ "/* Put everything inside the global mpl namespace */\n", "window.mpl = {};\n", "\n", "\n", "mpl.get_websocket_type = function() {\n", " if (typeof(WebSocket) !== 'undefined') {\n", " return WebSocket;\n", " } else if (typeof(MozWebSocket) !== 'undefined') {\n", " return MozWebSocket;\n", " } else {\n", " alert('Your browser does not have WebSocket support.' +\n", " 'Please try Chrome, Safari or Firefox ≥ 6. ' +\n", " 'Firefox 4 and 5 are also supported but you ' +\n", " 'have to enable WebSockets in about:config.');\n", " };\n", "}\n", "\n", "mpl.figure = function(figure_id, websocket, ondownload, parent_element) {\n", " this.id = figure_id;\n", "\n", " this.ws = websocket;\n", "\n", " this.supports_binary = (this.ws.binaryType != undefined);\n", "\n", " if (!this.supports_binary) {\n", " var warnings = document.getElementById(\"mpl-warnings\");\n", " if (warnings) {\n", " warnings.style.display = 'block';\n", " warnings.textContent = (\n", " \"This browser does not support binary websocket messages. \" +\n", " \"Performance may be slow.\");\n", " }\n", " }\n", "\n", " this.imageObj = new Image();\n", "\n", " this.context = undefined;\n", " this.message = undefined;\n", " this.canvas = undefined;\n", " this.rubberband_canvas = undefined;\n", " this.rubberband_context = undefined;\n", " this.format_dropdown = undefined;\n", "\n", " this.image_mode = 'full';\n", "\n", " this.root = $('
');\n", " this._root_extra_style(this.root)\n", " this.root.attr('style', 'display: inline-block');\n", "\n", " $(parent_element).append(this.root);\n", "\n", " this._init_header(this);\n", " this._init_canvas(this);\n", " this._init_toolbar(this);\n", "\n", " var fig = this;\n", "\n", " this.waiting = false;\n", "\n", " this.ws.onopen = function () {\n", " fig.send_message(\"supports_binary\", {value: fig.supports_binary});\n", " fig.send_message(\"send_image_mode\", {});\n", " if (mpl.ratio != 1) {\n", " fig.send_message(\"set_dpi_ratio\", {'dpi_ratio': mpl.ratio});\n", " }\n", " fig.send_message(\"refresh\", {});\n", " }\n", "\n", " this.imageObj.onload = function() {\n", " if (fig.image_mode == 'full') {\n", " // Full images could contain transparency (where diff images\n", " // almost always do), so we need to clear the canvas so that\n", " // there is no ghosting.\n", " fig.context.clearRect(0, 0, fig.canvas.width, fig.canvas.height);\n", " }\n", " fig.context.drawImage(fig.imageObj, 0, 0);\n", " };\n", "\n", " this.imageObj.onunload = function() {\n", " fig.ws.close();\n", " }\n", "\n", " this.ws.onmessage = this._make_on_message_function(this);\n", "\n", " this.ondownload = ondownload;\n", "}\n", "\n", "mpl.figure.prototype._init_header = function() {\n", " var titlebar = $(\n", " '
');\n", " var titletext = $(\n", " '
');\n", " titlebar.append(titletext)\n", " this.root.append(titlebar);\n", " this.header = titletext[0];\n", "}\n", "\n", "\n", "\n", "mpl.figure.prototype._canvas_extra_style = function(canvas_div) {\n", "\n", "}\n", "\n", "\n", "mpl.figure.prototype._root_extra_style = function(canvas_div) {\n", "\n", "}\n", "\n", "mpl.figure.prototype._init_canvas = function() {\n", " var fig = this;\n", "\n", " var canvas_div = $('
');\n", "\n", " canvas_div.attr('style', 'position: relative; clear: both; outline: 0');\n", "\n", " function canvas_keyboard_event(event) {\n", " return fig.key_event(event, event['data']);\n", " }\n", "\n", " canvas_div.keydown('key_press', canvas_keyboard_event);\n", " canvas_div.keyup('key_release', canvas_keyboard_event);\n", " this.canvas_div = canvas_div\n", " this._canvas_extra_style(canvas_div)\n", " this.root.append(canvas_div);\n", "\n", " var canvas = $('');\n", " canvas.addClass('mpl-canvas');\n", " canvas.attr('style', \"left: 0; top: 0; z-index: 0; outline: 0\")\n", "\n", " this.canvas = canvas[0];\n", " this.context = canvas[0].getContext(\"2d\");\n", "\n", " var backingStore = this.context.backingStorePixelRatio ||\n", "\tthis.context.webkitBackingStorePixelRatio ||\n", "\tthis.context.mozBackingStorePixelRatio ||\n", "\tthis.context.msBackingStorePixelRatio ||\n", "\tthis.context.oBackingStorePixelRatio ||\n", "\tthis.context.backingStorePixelRatio || 1;\n", "\n", " mpl.ratio = (window.devicePixelRatio || 1) / backingStore;\n", "\n", " var rubberband = $('');\n", " rubberband.attr('style', \"position: absolute; left: 0; top: 0; z-index: 1;\")\n", "\n", " var pass_mouse_events = true;\n", "\n", " canvas_div.resizable({\n", " start: function(event, ui) {\n", " pass_mouse_events = false;\n", " },\n", " resize: function(event, ui) {\n", " fig.request_resize(ui.size.width, ui.size.height);\n", " },\n", " stop: function(event, ui) {\n", " pass_mouse_events = true;\n", " fig.request_resize(ui.size.width, ui.size.height);\n", " },\n", " });\n", "\n", " function mouse_event_fn(event) {\n", " if (pass_mouse_events)\n", " return fig.mouse_event(event, event['data']);\n", " }\n", "\n", " rubberband.mousedown('button_press', mouse_event_fn);\n", " rubberband.mouseup('button_release', mouse_event_fn);\n", " // Throttle sequential mouse events to 1 every 20ms.\n", " rubberband.mousemove('motion_notify', mouse_event_fn);\n", "\n", " rubberband.mouseenter('figure_enter', mouse_event_fn);\n", " rubberband.mouseleave('figure_leave', mouse_event_fn);\n", "\n", " canvas_div.on(\"wheel\", function (event) {\n", " event = event.originalEvent;\n", " event['data'] = 'scroll'\n", " if (event.deltaY < 0) {\n", " event.step = 1;\n", " } else {\n", " event.step = -1;\n", " }\n", " mouse_event_fn(event);\n", " });\n", "\n", " canvas_div.append(canvas);\n", " canvas_div.append(rubberband);\n", "\n", " this.rubberband = rubberband;\n", " this.rubberband_canvas = rubberband[0];\n", " this.rubberband_context = rubberband[0].getContext(\"2d\");\n", " this.rubberband_context.strokeStyle = \"#000000\";\n", "\n", " this._resize_canvas = function(width, height) {\n", " // Keep the size of the canvas, canvas container, and rubber band\n", " // canvas in synch.\n", " canvas_div.css('width', width)\n", " canvas_div.css('height', height)\n", "\n", " canvas.attr('width', width * mpl.ratio);\n", " canvas.attr('height', height * mpl.ratio);\n", " canvas.attr('style', 'width: ' + width + 'px; height: ' + height + 'px;');\n", "\n", " rubberband.attr('width', width);\n", " rubberband.attr('height', height);\n", " }\n", "\n", " // Set the figure to an initial 600x600px, this will subsequently be updated\n", " // upon first draw.\n", " this._resize_canvas(600, 600);\n", "\n", " // Disable right mouse context menu.\n", " $(this.rubberband_canvas).bind(\"contextmenu\",function(e){\n", " return false;\n", " });\n", "\n", " function set_focus () {\n", " canvas.focus();\n", " canvas_div.focus();\n", " }\n", "\n", " window.setTimeout(set_focus, 100);\n", "}\n", "\n", "mpl.figure.prototype._init_toolbar = function() {\n", " var fig = this;\n", "\n", " var nav_element = $('
')\n", " nav_element.attr('style', 'width: 100%');\n", " this.root.append(nav_element);\n", "\n", " // Define a callback function for later on.\n", " function toolbar_event(event) {\n", " return fig.toolbar_button_onclick(event['data']);\n", " }\n", " function toolbar_mouse_event(event) {\n", " return fig.toolbar_button_onmouseover(event['data']);\n", " }\n", "\n", " for(var toolbar_ind in mpl.toolbar_items) {\n", " var name = mpl.toolbar_items[toolbar_ind][0];\n", " var tooltip = mpl.toolbar_items[toolbar_ind][1];\n", " var image = mpl.toolbar_items[toolbar_ind][2];\n", " var method_name = mpl.toolbar_items[toolbar_ind][3];\n", "\n", " if (!name) {\n", " // put a spacer in here.\n", " continue;\n", " }\n", " var button = $('');\n", " button.click(method_name, toolbar_event);\n", " button.mouseover(tooltip, toolbar_mouse_event);\n", " nav_element.append(button);\n", " }\n", "\n", " // Add the status bar.\n", " var status_bar = $('');\n", " nav_element.append(status_bar);\n", " this.message = status_bar[0];\n", "\n", " // Add the close button to the window.\n", " var buttongrp = $('
');\n", " var button = $('');\n", " button.click(function (evt) { fig.handle_close(fig, {}); } );\n", " button.mouseover('Stop Interaction', toolbar_mouse_event);\n", " buttongrp.append(button);\n", " var titlebar = this.root.find($('.ui-dialog-titlebar'));\n", " titlebar.prepend(buttongrp);\n", "}\n", "\n", "mpl.figure.prototype._root_extra_style = function(el){\n", " var fig = this\n", " el.on(\"remove\", function(){\n", "\tfig.close_ws(fig, {});\n", " });\n", "}\n", "\n", "mpl.figure.prototype._canvas_extra_style = function(el){\n", " // this is important to make the div 'focusable\n", " el.attr('tabindex', 0)\n", " // reach out to IPython and tell the keyboard manager to turn it's self\n", " // off when our div gets focus\n", "\n", " // location in version 3\n", " if (IPython.notebook.keyboard_manager) {\n", " IPython.notebook.keyboard_manager.register_events(el);\n", " }\n", " else {\n", " // location in version 2\n", " IPython.keyboard_manager.register_events(el);\n", " }\n", "\n", "}\n", "\n", "mpl.figure.prototype._key_event_extra = function(event, name) {\n", " var manager = IPython.notebook.keyboard_manager;\n", " if (!manager)\n", " manager = IPython.keyboard_manager;\n", "\n", " // Check for shift+enter\n", " if (event.shiftKey && event.which == 13) {\n", " this.canvas_div.blur();\n", " event.shiftKey = false;\n", " // Send a \"J\" for go to next cell\n", " event.which = 74;\n", " event.keyCode = 74;\n", " manager.command_mode();\n", " manager.handle_keydown(event);\n", " }\n", "}\n", "\n", "mpl.figure.prototype.handle_save = function(fig, msg) {\n", " fig.ondownload(fig, null);\n", "}\n", "\n", "\n", "mpl.find_output_cell = function(html_output) {\n", " // Return the cell and output element which can be found *uniquely* in the notebook.\n", " // Note - this is a bit hacky, but it is done because the \"notebook_saving.Notebook\"\n", " // IPython event is triggered only after the cells have been serialised, which for\n", " // our purposes (turning an active figure into a static one), is too late.\n", " var cells = IPython.notebook.get_cells();\n", " var ncells = cells.length;\n", " for (var i=0; i= 3 moved mimebundle to data attribute of output\n", " data = data.data;\n", " }\n", " if (data['text/html'] == html_output) {\n", " return [cell, data, j];\n", " }\n", " }\n", " }\n", " }\n", "}\n", "\n", "// Register the function which deals with the matplotlib target/channel.\n", "// The kernel may be null if the page has been refreshed.\n", "if (IPython.notebook.kernel != null) {\n", " IPython.notebook.kernel.comm_manager.register_target('matplotlib', mpl.mpl_figure_comm);\n", "}\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/plain": [ "" ] }, "execution_count": 17, "metadata": {}, "output_type": "execute_result" } ], "source": [ "prices.plot()" ] }, { "cell_type": "code", "execution_count": 53, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
PPh-24Ph-25Ph-26Ph-27Ph-28Ph-29Ph-30Ph-31Ph-32...Ph-183Ph-184Ph-185Ph-186Ph-187Ph-188Ph-189Ph-190Ph-191Ph-192
Fecha_hora
2016-08-09 00:00:0095.326454.846145.198244.712346.299542.942244.355146.344045.682642.6676...49.426548.463238.641635.125032.370729.724031.126134.064540.116955.4450
2016-08-09 01:00:0082.853252.217954.846145.198244.712346.299542.942244.355146.344045.6826...45.018749.426548.463238.641635.125032.370729.724031.126134.064540.1169
2016-08-09 02:00:0057.976461.919852.217954.846145.198244.712346.299542.942244.355146.3440...45.586845.018749.426548.463238.641635.125032.370729.724031.126134.0645
2016-08-09 03:00:0067.640736.810561.919852.217954.846145.198244.712346.299542.942244.3551...47.545445.586845.018749.426548.463238.641635.125032.370729.724031.1261
2016-08-09 04:00:0066.489234.827436.810561.919852.217954.846145.198244.712346.299542.9422...47.654247.545445.586845.018749.426548.463238.641635.125032.370729.7240
2016-08-09 05:00:0068.680734.582434.827436.810561.919852.217954.846145.198244.712346.2995...46.309947.654247.545445.586845.018749.426548.463238.641635.125032.3707
2016-08-09 06:00:0066.925949.448134.582434.827436.810561.919852.217954.846145.198244.7123...48.171946.309947.654247.545445.586845.018749.426548.463238.641635.1250
2016-08-09 07:00:0066.805755.672149.448134.582434.827436.810561.919852.217954.846145.1982...47.418648.171946.309947.654247.545445.586845.018749.426548.463238.6416
2016-08-09 08:00:0085.245557.097455.672149.448134.582434.827436.810561.919852.217954.8461...45.765147.418648.171946.309947.654247.545445.586845.018749.426548.4632
2016-08-09 09:00:0079.128367.036857.097455.672149.448134.582434.827436.810561.919852.2179...48.922045.765147.418648.171946.309947.654247.545445.586845.018749.4265
2016-08-09 10:00:0079.496054.468167.036857.097455.672149.448134.582434.827436.810561.9198...50.357048.922045.765147.418648.171946.309947.654247.545445.586845.0187
2016-08-09 11:00:0095.866654.445054.468167.036857.097455.672149.448134.582434.827436.8105...45.016050.357048.922045.765147.418648.171946.309947.654247.545445.5868
2016-08-09 12:00:0080.838454.025054.445054.468167.036857.097455.672149.448134.582434.8274...50.772945.016050.357048.922045.765147.418648.171946.309947.654247.5454
2016-08-09 13:00:0095.367256.339254.025054.445054.468167.036857.097455.672149.448134.5824...48.355550.772945.016050.357048.922045.765147.418648.171946.309947.6542
2016-08-09 14:00:0085.483766.547356.339254.025054.445054.468167.036857.097455.672149.4481...49.851448.355550.772945.016050.357048.922045.765147.418648.171946.3099
2016-08-09 15:00:0095.334058.873866.547356.339254.025054.445054.468167.036857.097455.6721...42.208749.851448.355550.772945.016050.357048.922045.765147.418648.1719
2016-08-09 16:00:0093.613560.197358.873866.547356.339254.025054.445054.468167.036857.0974...38.871542.208749.851448.355550.772945.016050.357048.922045.765147.4186
2016-08-09 17:00:0093.320459.747760.197358.873866.547356.339254.025054.445054.468167.0368...35.539238.871542.208749.851448.355550.772945.016050.357048.922045.7651
2016-08-09 18:00:0078.543559.934559.747760.197358.873866.547356.339254.025054.445054.4681...38.838735.539238.871542.208749.851448.355550.772945.016050.357048.9220
2016-08-09 19:00:0079.716356.915459.934559.747760.197358.873866.547356.339254.025054.4450...33.062038.838735.539238.871542.208749.851448.355550.772945.016050.3570
2016-08-09 20:00:0098.430264.537856.915459.934559.747760.197358.873866.547356.339254.0250...35.247133.062038.838735.539238.871542.208749.851448.355550.772945.0160
2016-08-09 21:00:0079.124558.552864.537856.915459.934559.747760.197358.873866.547356.3392...36.109135.247133.062038.838735.539238.871542.208749.851448.355550.7729
2016-08-09 22:00:0079.000458.972358.552864.537856.915459.934559.747760.197358.873866.5473...36.749536.109135.247133.062038.838735.539238.871542.208749.851448.3555
2016-08-09 23:00:0097.395568.242358.972358.552864.537856.915459.934559.747760.197358.8738...41.174136.749536.109135.247133.062038.838735.539238.871542.208749.8514
2016-08-10 00:00:0051.731895.326468.242358.972358.552864.537856.915459.934559.747760.1973...40.251741.174136.749536.109135.247133.062038.838735.539238.871542.2087
\n", "

25 rows × 51 columns

\n", "
" ], "text/plain": [ " P Ph-24 Ph-25 Ph-26 Ph-27 Ph-28 \\\n", "Fecha_hora \n", "2016-08-09 00:00:00 95.3264 54.8461 45.1982 44.7123 46.2995 42.9422 \n", "2016-08-09 01:00:00 82.8532 52.2179 54.8461 45.1982 44.7123 46.2995 \n", "2016-08-09 02:00:00 57.9764 61.9198 52.2179 54.8461 45.1982 44.7123 \n", "2016-08-09 03:00:00 67.6407 36.8105 61.9198 52.2179 54.8461 45.1982 \n", "2016-08-09 04:00:00 66.4892 34.8274 36.8105 61.9198 52.2179 54.8461 \n", "2016-08-09 05:00:00 68.6807 34.5824 34.8274 36.8105 61.9198 52.2179 \n", "2016-08-09 06:00:00 66.9259 49.4481 34.5824 34.8274 36.8105 61.9198 \n", "2016-08-09 07:00:00 66.8057 55.6721 49.4481 34.5824 34.8274 36.8105 \n", "2016-08-09 08:00:00 85.2455 57.0974 55.6721 49.4481 34.5824 34.8274 \n", "2016-08-09 09:00:00 79.1283 67.0368 57.0974 55.6721 49.4481 34.5824 \n", "2016-08-09 10:00:00 79.4960 54.4681 67.0368 57.0974 55.6721 49.4481 \n", "2016-08-09 11:00:00 95.8666 54.4450 54.4681 67.0368 57.0974 55.6721 \n", "2016-08-09 12:00:00 80.8384 54.0250 54.4450 54.4681 67.0368 57.0974 \n", "2016-08-09 13:00:00 95.3672 56.3392 54.0250 54.4450 54.4681 67.0368 \n", "2016-08-09 14:00:00 85.4837 66.5473 56.3392 54.0250 54.4450 54.4681 \n", "2016-08-09 15:00:00 95.3340 58.8738 66.5473 56.3392 54.0250 54.4450 \n", "2016-08-09 16:00:00 93.6135 60.1973 58.8738 66.5473 56.3392 54.0250 \n", "2016-08-09 17:00:00 93.3204 59.7477 60.1973 58.8738 66.5473 56.3392 \n", "2016-08-09 18:00:00 78.5435 59.9345 59.7477 60.1973 58.8738 66.5473 \n", "2016-08-09 19:00:00 79.7163 56.9154 59.9345 59.7477 60.1973 58.8738 \n", "2016-08-09 20:00:00 98.4302 64.5378 56.9154 59.9345 59.7477 60.1973 \n", "2016-08-09 21:00:00 79.1245 58.5528 64.5378 56.9154 59.9345 59.7477 \n", "2016-08-09 22:00:00 79.0004 58.9723 58.5528 64.5378 56.9154 59.9345 \n", "2016-08-09 23:00:00 97.3955 68.2423 58.9723 58.5528 64.5378 56.9154 \n", "2016-08-10 00:00:00 51.7318 95.3264 68.2423 58.9723 58.5528 64.5378 \n", "\n", " Ph-29 Ph-30 Ph-31 Ph-32 ... Ph-183 \\\n", "Fecha_hora ... \n", "2016-08-09 00:00:00 44.3551 46.3440 45.6826 42.6676 ... 49.4265 \n", "2016-08-09 01:00:00 42.9422 44.3551 46.3440 45.6826 ... 45.0187 \n", "2016-08-09 02:00:00 46.2995 42.9422 44.3551 46.3440 ... 45.5868 \n", "2016-08-09 03:00:00 44.7123 46.2995 42.9422 44.3551 ... 47.5454 \n", "2016-08-09 04:00:00 45.1982 44.7123 46.2995 42.9422 ... 47.6542 \n", "2016-08-09 05:00:00 54.8461 45.1982 44.7123 46.2995 ... 46.3099 \n", "2016-08-09 06:00:00 52.2179 54.8461 45.1982 44.7123 ... 48.1719 \n", "2016-08-09 07:00:00 61.9198 52.2179 54.8461 45.1982 ... 47.4186 \n", "2016-08-09 08:00:00 36.8105 61.9198 52.2179 54.8461 ... 45.7651 \n", "2016-08-09 09:00:00 34.8274 36.8105 61.9198 52.2179 ... 48.9220 \n", "2016-08-09 10:00:00 34.5824 34.8274 36.8105 61.9198 ... 50.3570 \n", "2016-08-09 11:00:00 49.4481 34.5824 34.8274 36.8105 ... 45.0160 \n", "2016-08-09 12:00:00 55.6721 49.4481 34.5824 34.8274 ... 50.7729 \n", "2016-08-09 13:00:00 57.0974 55.6721 49.4481 34.5824 ... 48.3555 \n", "2016-08-09 14:00:00 67.0368 57.0974 55.6721 49.4481 ... 49.8514 \n", "2016-08-09 15:00:00 54.4681 67.0368 57.0974 55.6721 ... 42.2087 \n", "2016-08-09 16:00:00 54.4450 54.4681 67.0368 57.0974 ... 38.8715 \n", "2016-08-09 17:00:00 54.0250 54.4450 54.4681 67.0368 ... 35.5392 \n", "2016-08-09 18:00:00 56.3392 54.0250 54.4450 54.4681 ... 38.8387 \n", "2016-08-09 19:00:00 66.5473 56.3392 54.0250 54.4450 ... 33.0620 \n", "2016-08-09 20:00:00 58.8738 66.5473 56.3392 54.0250 ... 35.2471 \n", "2016-08-09 21:00:00 60.1973 58.8738 66.5473 56.3392 ... 36.1091 \n", "2016-08-09 22:00:00 59.7477 60.1973 58.8738 66.5473 ... 36.7495 \n", "2016-08-09 23:00:00 59.9345 59.7477 60.1973 58.8738 ... 41.1741 \n", "2016-08-10 00:00:00 56.9154 59.9345 59.7477 60.1973 ... 40.2517 \n", "\n", " Ph-184 Ph-185 Ph-186 Ph-187 Ph-188 Ph-189 \\\n", "Fecha_hora \n", "2016-08-09 00:00:00 48.4632 38.6416 35.1250 32.3707 29.7240 31.1261 \n", "2016-08-09 01:00:00 49.4265 48.4632 38.6416 35.1250 32.3707 29.7240 \n", "2016-08-09 02:00:00 45.0187 49.4265 48.4632 38.6416 35.1250 32.3707 \n", "2016-08-09 03:00:00 45.5868 45.0187 49.4265 48.4632 38.6416 35.1250 \n", "2016-08-09 04:00:00 47.5454 45.5868 45.0187 49.4265 48.4632 38.6416 \n", "2016-08-09 05:00:00 47.6542 47.5454 45.5868 45.0187 49.4265 48.4632 \n", "2016-08-09 06:00:00 46.3099 47.6542 47.5454 45.5868 45.0187 49.4265 \n", "2016-08-09 07:00:00 48.1719 46.3099 47.6542 47.5454 45.5868 45.0187 \n", "2016-08-09 08:00:00 47.4186 48.1719 46.3099 47.6542 47.5454 45.5868 \n", "2016-08-09 09:00:00 45.7651 47.4186 48.1719 46.3099 47.6542 47.5454 \n", "2016-08-09 10:00:00 48.9220 45.7651 47.4186 48.1719 46.3099 47.6542 \n", "2016-08-09 11:00:00 50.3570 48.9220 45.7651 47.4186 48.1719 46.3099 \n", "2016-08-09 12:00:00 45.0160 50.3570 48.9220 45.7651 47.4186 48.1719 \n", "2016-08-09 13:00:00 50.7729 45.0160 50.3570 48.9220 45.7651 47.4186 \n", "2016-08-09 14:00:00 48.3555 50.7729 45.0160 50.3570 48.9220 45.7651 \n", "2016-08-09 15:00:00 49.8514 48.3555 50.7729 45.0160 50.3570 48.9220 \n", "2016-08-09 16:00:00 42.2087 49.8514 48.3555 50.7729 45.0160 50.3570 \n", "2016-08-09 17:00:00 38.8715 42.2087 49.8514 48.3555 50.7729 45.0160 \n", "2016-08-09 18:00:00 35.5392 38.8715 42.2087 49.8514 48.3555 50.7729 \n", "2016-08-09 19:00:00 38.8387 35.5392 38.8715 42.2087 49.8514 48.3555 \n", "2016-08-09 20:00:00 33.0620 38.8387 35.5392 38.8715 42.2087 49.8514 \n", "2016-08-09 21:00:00 35.2471 33.0620 38.8387 35.5392 38.8715 42.2087 \n", "2016-08-09 22:00:00 36.1091 35.2471 33.0620 38.8387 35.5392 38.8715 \n", "2016-08-09 23:00:00 36.7495 36.1091 35.2471 33.0620 38.8387 35.5392 \n", "2016-08-10 00:00:00 41.1741 36.7495 36.1091 35.2471 33.0620 38.8387 \n", "\n", " Ph-190 Ph-191 Ph-192 \n", "Fecha_hora \n", "2016-08-09 00:00:00 34.0645 40.1169 55.4450 \n", "2016-08-09 01:00:00 31.1261 34.0645 40.1169 \n", "2016-08-09 02:00:00 29.7240 31.1261 34.0645 \n", "2016-08-09 03:00:00 32.3707 29.7240 31.1261 \n", "2016-08-09 04:00:00 35.1250 32.3707 29.7240 \n", "2016-08-09 05:00:00 38.6416 35.1250 32.3707 \n", "2016-08-09 06:00:00 48.4632 38.6416 35.1250 \n", "2016-08-09 07:00:00 49.4265 48.4632 38.6416 \n", "2016-08-09 08:00:00 45.0187 49.4265 48.4632 \n", "2016-08-09 09:00:00 45.5868 45.0187 49.4265 \n", "2016-08-09 10:00:00 47.5454 45.5868 45.0187 \n", "2016-08-09 11:00:00 47.6542 47.5454 45.5868 \n", "2016-08-09 12:00:00 46.3099 47.6542 47.5454 \n", "2016-08-09 13:00:00 48.1719 46.3099 47.6542 \n", "2016-08-09 14:00:00 47.4186 48.1719 46.3099 \n", "2016-08-09 15:00:00 45.7651 47.4186 48.1719 \n", "2016-08-09 16:00:00 48.9220 45.7651 47.4186 \n", "2016-08-09 17:00:00 50.3570 48.9220 45.7651 \n", "2016-08-09 18:00:00 45.0160 50.3570 48.9220 \n", "2016-08-09 19:00:00 50.7729 45.0160 50.3570 \n", "2016-08-09 20:00:00 48.3555 50.7729 45.0160 \n", "2016-08-09 21:00:00 49.8514 48.3555 50.7729 \n", "2016-08-09 22:00:00 42.2087 49.8514 48.3555 \n", "2016-08-09 23:00:00 38.8715 42.2087 49.8514 \n", "2016-08-10 00:00:00 35.5392 38.8715 42.2087 \n", "\n", "[25 rows x 51 columns]" ] }, "execution_count": 53, "metadata": {}, "output_type": "execute_result" } ], "source": [ "prices_shifted = pd.concat([prices]+[prices['P'].shift(i) for i in range(24,49)]+[prices['P'].shift(i) for i in range(168,193)], axis=1).dropna()\n", "prices_shifted.columns = ['P']+['Ph-{}'.format(i) for i in range(24,49)] + ['Ph-{}'.format(i) for i in range(168,193)]\n", "prices_shifted.head(25)" ] }, { "cell_type": "code", "execution_count": 69, "metadata": { "collapsed": true }, "outputs": [], "source": [ "prices_shifted['day_of_week'] = prices_shifted.index.weekday_name" ] }, { "cell_type": "code", "execution_count": 70, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "Index(['P', 'Ph-24', 'Ph-25', 'Ph-26', 'Ph-27', 'Ph-28', 'Ph-29', 'Ph-30',\n", " 'Ph-31', 'Ph-32', 'Ph-33', 'Ph-34', 'Ph-35', 'Ph-36', 'Ph-37', 'Ph-38',\n", " 'Ph-39', 'Ph-40', 'Ph-41', 'Ph-42', 'Ph-43', 'Ph-44', 'Ph-45', 'Ph-46',\n", " 'Ph-47', 'Ph-48', 'Ph-168', 'Ph-169', 'Ph-170', 'Ph-171', 'Ph-172',\n", " 'Ph-173', 'Ph-174', 'Ph-175', 'Ph-176', 'Ph-177', 'Ph-178', 'Ph-179',\n", " 'Ph-180', 'Ph-181', 'Ph-182', 'Ph-183', 'Ph-184', 'Ph-185', 'Ph-186',\n", " 'Ph-187', 'Ph-188', 'Ph-189', 'Ph-190', 'Ph-191', 'Ph-192',\n", " 'day_of_week'],\n", " dtype='object')" ] }, "execution_count": 70, "metadata": {}, "output_type": "execute_result" } ], "source": [ "prices_shifted.columns" ] }, { "cell_type": "code", "execution_count": 71, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "Int64Index([ 8, 8, 8, 8, 8, 8, 8, 8, 8, 8,\n", " ...\n", " 12, 12, 12, 12, 12, 12, 12, 12, 12, 12],\n", " dtype='int64', name='Fecha_hora', length=20520)" ] }, "execution_count": 71, "metadata": {}, "output_type": "execute_result" } ], "source": [ "prices_shifted.index.month" ] }, { "cell_type": "code", "execution_count": 72, "metadata": { "collapsed": true }, "outputs": [], "source": [ "import calendar" ] }, { "cell_type": "code", "execution_count": 75, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "'Aug'" ] }, "execution_count": 75, "metadata": {}, "output_type": "execute_result" } ], "source": [ "calendar.month_abbr[8]" ] }, { "cell_type": "code", "execution_count": 76, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
PPh-24Ph-25Ph-26Ph-27Ph-28Ph-29Ph-30Ph-31Ph-32...Ph-185Ph-186Ph-187Ph-188Ph-189Ph-190Ph-191Ph-192day_of_weekmonth
Fecha_hora
2016-08-09 00:00:0095.326454.846145.198244.712346.299542.942244.355146.344045.682642.6676...38.641635.125032.370729.724031.126134.064540.116955.4450TuesdayAug
2016-08-09 01:00:0082.853252.217954.846145.198244.712346.299542.942244.355146.344045.6826...48.463238.641635.125032.370729.724031.126134.064540.1169TuesdayAug
2016-08-09 02:00:0057.976461.919852.217954.846145.198244.712346.299542.942244.355146.3440...49.426548.463238.641635.125032.370729.724031.126134.0645TuesdayAug
2016-08-09 03:00:0067.640736.810561.919852.217954.846145.198244.712346.299542.942244.3551...45.018749.426548.463238.641635.125032.370729.724031.1261TuesdayAug
2016-08-09 04:00:0066.489234.827436.810561.919852.217954.846145.198244.712346.299542.9422...45.586845.018749.426548.463238.641635.125032.370729.7240TuesdayAug
2016-08-09 05:00:0068.680734.582434.827436.810561.919852.217954.846145.198244.712346.2995...47.545445.586845.018749.426548.463238.641635.125032.3707TuesdayAug
2016-08-09 06:00:0066.925949.448134.582434.827436.810561.919852.217954.846145.198244.7123...47.654247.545445.586845.018749.426548.463238.641635.1250TuesdayAug
2016-08-09 07:00:0066.805755.672149.448134.582434.827436.810561.919852.217954.846145.1982...46.309947.654247.545445.586845.018749.426548.463238.6416TuesdayAug
2016-08-09 08:00:0085.245557.097455.672149.448134.582434.827436.810561.919852.217954.8461...48.171946.309947.654247.545445.586845.018749.426548.4632TuesdayAug
2016-08-09 09:00:0079.128367.036857.097455.672149.448134.582434.827436.810561.919852.2179...47.418648.171946.309947.654247.545445.586845.018749.4265TuesdayAug
\n", "

10 rows × 53 columns

\n", "
" ], "text/plain": [ " P Ph-24 Ph-25 Ph-26 Ph-27 Ph-28 \\\n", "Fecha_hora \n", "2016-08-09 00:00:00 95.3264 54.8461 45.1982 44.7123 46.2995 42.9422 \n", "2016-08-09 01:00:00 82.8532 52.2179 54.8461 45.1982 44.7123 46.2995 \n", "2016-08-09 02:00:00 57.9764 61.9198 52.2179 54.8461 45.1982 44.7123 \n", "2016-08-09 03:00:00 67.6407 36.8105 61.9198 52.2179 54.8461 45.1982 \n", "2016-08-09 04:00:00 66.4892 34.8274 36.8105 61.9198 52.2179 54.8461 \n", "2016-08-09 05:00:00 68.6807 34.5824 34.8274 36.8105 61.9198 52.2179 \n", "2016-08-09 06:00:00 66.9259 49.4481 34.5824 34.8274 36.8105 61.9198 \n", "2016-08-09 07:00:00 66.8057 55.6721 49.4481 34.5824 34.8274 36.8105 \n", "2016-08-09 08:00:00 85.2455 57.0974 55.6721 49.4481 34.5824 34.8274 \n", "2016-08-09 09:00:00 79.1283 67.0368 57.0974 55.6721 49.4481 34.5824 \n", "\n", " Ph-29 Ph-30 Ph-31 Ph-32 ... Ph-185 \\\n", "Fecha_hora ... \n", "2016-08-09 00:00:00 44.3551 46.3440 45.6826 42.6676 ... 38.6416 \n", "2016-08-09 01:00:00 42.9422 44.3551 46.3440 45.6826 ... 48.4632 \n", "2016-08-09 02:00:00 46.2995 42.9422 44.3551 46.3440 ... 49.4265 \n", "2016-08-09 03:00:00 44.7123 46.2995 42.9422 44.3551 ... 45.0187 \n", "2016-08-09 04:00:00 45.1982 44.7123 46.2995 42.9422 ... 45.5868 \n", "2016-08-09 05:00:00 54.8461 45.1982 44.7123 46.2995 ... 47.5454 \n", "2016-08-09 06:00:00 52.2179 54.8461 45.1982 44.7123 ... 47.6542 \n", "2016-08-09 07:00:00 61.9198 52.2179 54.8461 45.1982 ... 46.3099 \n", "2016-08-09 08:00:00 36.8105 61.9198 52.2179 54.8461 ... 48.1719 \n", "2016-08-09 09:00:00 34.8274 36.8105 61.9198 52.2179 ... 47.4186 \n", "\n", " Ph-186 Ph-187 Ph-188 Ph-189 Ph-190 Ph-191 \\\n", "Fecha_hora \n", "2016-08-09 00:00:00 35.1250 32.3707 29.7240 31.1261 34.0645 40.1169 \n", "2016-08-09 01:00:00 38.6416 35.1250 32.3707 29.7240 31.1261 34.0645 \n", "2016-08-09 02:00:00 48.4632 38.6416 35.1250 32.3707 29.7240 31.1261 \n", "2016-08-09 03:00:00 49.4265 48.4632 38.6416 35.1250 32.3707 29.7240 \n", "2016-08-09 04:00:00 45.0187 49.4265 48.4632 38.6416 35.1250 32.3707 \n", "2016-08-09 05:00:00 45.5868 45.0187 49.4265 48.4632 38.6416 35.1250 \n", "2016-08-09 06:00:00 47.5454 45.5868 45.0187 49.4265 48.4632 38.6416 \n", "2016-08-09 07:00:00 47.6542 47.5454 45.5868 45.0187 49.4265 48.4632 \n", "2016-08-09 08:00:00 46.3099 47.6542 47.5454 45.5868 45.0187 49.4265 \n", "2016-08-09 09:00:00 48.1719 46.3099 47.6542 47.5454 45.5868 45.0187 \n", "\n", " Ph-192 day_of_week month \n", "Fecha_hora \n", "2016-08-09 00:00:00 55.4450 Tuesday Aug \n", "2016-08-09 01:00:00 40.1169 Tuesday Aug \n", "2016-08-09 02:00:00 34.0645 Tuesday Aug \n", "2016-08-09 03:00:00 31.1261 Tuesday Aug \n", "2016-08-09 04:00:00 29.7240 Tuesday Aug \n", "2016-08-09 05:00:00 32.3707 Tuesday Aug \n", "2016-08-09 06:00:00 35.1250 Tuesday Aug \n", "2016-08-09 07:00:00 38.6416 Tuesday Aug \n", "2016-08-09 08:00:00 48.4632 Tuesday Aug \n", "2016-08-09 09:00:00 49.4265 Tuesday Aug \n", "\n", "[10 rows x 53 columns]" ] }, "execution_count": 76, "metadata": {}, "output_type": "execute_result" } ], "source": [ "prices_shifted['month'] = prices_shifted.index.month\n", "prices_shifted['month'] = prices_shifted['month'].apply(lambda x: calendar.month_abbr[x])\n", "prices_shifted.head(10)" ] }, { "cell_type": "code", "execution_count": 79, "metadata": { "collapsed": true }, "outputs": [], "source": [ "prices = pd.get_dummies(prices_shifted)" ] }, { "cell_type": "code", "execution_count": 85, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
PPh-24Ph-25Ph-26Ph-27Ph-28Ph-29Ph-30Ph-31Ph-32...month_Decmonth_Febmonth_Janmonth_Julmonth_Junmonth_Marmonth_Maymonth_Novmonth_Octmonth_Sep
count20520.00000020520.00000020520.00000020520.00000020520.00000020520.00000020520.00000020520.00000020520.00000020520.000000...20520.00000020520.00000020520.00000020520.00000020520.00000020520.00000020520.00000020520.00000020520.00000020520.000000
mean72.09387372.05337172.05126272.04838872.04358372.03996972.03583172.03290472.02973872.025476...0.0853800.0654970.0725150.0725150.0701750.0725150.0725150.1052630.1087720.105263
std34.18361534.17671434.17703634.17685434.17354434.17270034.17091134.17053934.16997134.168179...0.2794530.2474070.2593440.2593440.2554490.2593440.2593440.3069000.3113600.306900
min18.70490018.70490018.70490018.70490018.70490018.70490018.70490018.70490018.70490018.704900...0.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.000000
25%48.16440048.15647548.15417548.15225048.14730048.14537548.14050048.13460048.13250048.130500...0.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.000000
50%65.08430065.01010065.00850065.00725065.00225064.99660064.99510064.99360064.98955064.985950...0.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.000000
75%88.62092588.54180088.54180088.53145088.52645088.52142588.51782588.51672588.51367588.496425...0.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.000000
max329.440000329.440000329.440000329.440000329.440000329.440000329.440000329.440000329.440000329.440000...1.0000001.0000001.0000001.0000001.0000001.0000001.0000001.0000001.0000001.000000
\n", "

8 rows × 70 columns

\n", "
" ], "text/plain": [ " P Ph-24 Ph-25 Ph-26 Ph-27 \\\n", "count 20520.000000 20520.000000 20520.000000 20520.000000 20520.000000 \n", "mean 72.093873 72.053371 72.051262 72.048388 72.043583 \n", "std 34.183615 34.176714 34.177036 34.176854 34.173544 \n", "min 18.704900 18.704900 18.704900 18.704900 18.704900 \n", "25% 48.164400 48.156475 48.154175 48.152250 48.147300 \n", "50% 65.084300 65.010100 65.008500 65.007250 65.002250 \n", "75% 88.620925 88.541800 88.541800 88.531450 88.526450 \n", "max 329.440000 329.440000 329.440000 329.440000 329.440000 \n", "\n", " Ph-28 Ph-29 Ph-30 Ph-31 Ph-32 \\\n", "count 20520.000000 20520.000000 20520.000000 20520.000000 20520.000000 \n", "mean 72.039969 72.035831 72.032904 72.029738 72.025476 \n", "std 34.172700 34.170911 34.170539 34.169971 34.168179 \n", "min 18.704900 18.704900 18.704900 18.704900 18.704900 \n", "25% 48.145375 48.140500 48.134600 48.132500 48.130500 \n", "50% 64.996600 64.995100 64.993600 64.989550 64.985950 \n", "75% 88.521425 88.517825 88.516725 88.513675 88.496425 \n", "max 329.440000 329.440000 329.440000 329.440000 329.440000 \n", "\n", " ... month_Dec month_Feb month_Jan month_Jul \\\n", "count ... 20520.000000 20520.000000 20520.000000 20520.000000 \n", "mean ... 0.085380 0.065497 0.072515 0.072515 \n", "std ... 0.279453 0.247407 0.259344 0.259344 \n", "min ... 0.000000 0.000000 0.000000 0.000000 \n", "25% ... 0.000000 0.000000 0.000000 0.000000 \n", "50% ... 0.000000 0.000000 0.000000 0.000000 \n", "75% ... 0.000000 0.000000 0.000000 0.000000 \n", "max ... 1.000000 1.000000 1.000000 1.000000 \n", "\n", " month_Jun month_Mar month_May month_Nov month_Oct \\\n", "count 20520.000000 20520.000000 20520.000000 20520.000000 20520.000000 \n", "mean 0.070175 0.072515 0.072515 0.105263 0.108772 \n", "std 0.255449 0.259344 0.259344 0.306900 0.311360 \n", "min 0.000000 0.000000 0.000000 0.000000 0.000000 \n", "25% 0.000000 0.000000 0.000000 0.000000 0.000000 \n", "50% 0.000000 0.000000 0.000000 0.000000 0.000000 \n", "75% 0.000000 0.000000 0.000000 0.000000 0.000000 \n", "max 1.000000 1.000000 1.000000 1.000000 1.000000 \n", "\n", " month_Sep \n", "count 20520.000000 \n", "mean 0.105263 \n", "std 0.306900 \n", "min 0.000000 \n", "25% 0.000000 \n", "50% 0.000000 \n", "75% 0.000000 \n", "max 1.000000 \n", "\n", "[8 rows x 70 columns]" ] }, "execution_count": 85, "metadata": {}, "output_type": "execute_result" } ], "source": [ "prices.describe()" ] }, { "cell_type": "code", "execution_count": 86, "metadata": { "collapsed": true }, "outputs": [], "source": [ "prices.to_csv(\"lbrprices_transformed.csv\")" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.6.3" } }, "nbformat": 4, "nbformat_minor": 2 }