{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": true }, "outputs": [], "source": [ "%matplotlib notebook\n", "import pandas as pd\n", "import numpy as np" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
| \n", " | P | \n", "Ph-24 | \n", "Ph-25 | \n", "Ph-26 | \n", "Ph-27 | \n", "Ph-28 | \n", "Ph-29 | \n", "Ph-30 | \n", "Ph-31 | \n", "Ph-32 | \n", "... | \n", "month_Dec | \n", "month_Feb | \n", "month_Jan | \n", "month_Jul | \n", "month_Jun | \n", "month_Mar | \n", "month_May | \n", "month_Nov | \n", "month_Oct | \n", "month_Sep | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Fecha_hora | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
| 2016-08-09 00:00:00 | \n", "95.3264 | \n", "54.8461 | \n", "45.1982 | \n", "44.7123 | \n", "46.2995 | \n", "42.9422 | \n", "44.3551 | \n", "46.3440 | \n", "45.6826 | \n", "42.6676 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 2016-08-09 01:00:00 | \n", "82.8532 | \n", "52.2179 | \n", "54.8461 | \n", "45.1982 | \n", "44.7123 | \n", "46.2995 | \n", "42.9422 | \n", "44.3551 | \n", "46.3440 | \n", "45.6826 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 2016-08-09 02:00:00 | \n", "57.9764 | \n", "61.9198 | \n", "52.2179 | \n", "54.8461 | \n", "45.1982 | \n", "44.7123 | \n", "46.2995 | \n", "42.9422 | \n", "44.3551 | \n", "46.3440 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 2016-08-09 03:00:00 | \n", "67.6407 | \n", "36.8105 | \n", "61.9198 | \n", "52.2179 | \n", "54.8461 | \n", "45.1982 | \n", "44.7123 | \n", "46.2995 | \n", "42.9422 | \n", "44.3551 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 2016-08-09 04:00:00 | \n", "66.4892 | \n", "34.8274 | \n", "36.8105 | \n", "61.9198 | \n", "52.2179 | \n", "54.8461 | \n", "45.1982 | \n", "44.7123 | \n", "46.2995 | \n", "42.9422 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
5 rows × 94 columns
\n", "| \n", " | P | \n", "Ph-24 | \n", "Ph-25 | \n", "Ph-26 | \n", "Ph-27 | \n", "Ph-28 | \n", "Ph-29 | \n", "Ph-30 | \n", "Ph-31 | \n", "Ph-32 | \n", "... | \n", "month_Dec | \n", "month_Feb | \n", "month_Jan | \n", "month_Jul | \n", "month_Jun | \n", "month_Mar | \n", "month_May | \n", "month_Nov | \n", "month_Oct | \n", "month_Sep | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| count | \n", "20520.000000 | \n", "20520.000000 | \n", "20520.000000 | \n", "20520.000000 | \n", "20520.000000 | \n", "20520.000000 | \n", "20520.000000 | \n", "20520.000000 | \n", "20520.000000 | \n", "20520.000000 | \n", "... | \n", "20520.000000 | \n", "20520.000000 | \n", "20520.000000 | \n", "20520.000000 | \n", "20520.000000 | \n", "20520.000000 | \n", "20520.000000 | \n", "20520.000000 | \n", "20520.000000 | \n", "20520.000000 | \n", "
| mean | \n", "72.093873 | \n", "72.053371 | \n", "72.051262 | \n", "72.048388 | \n", "72.043583 | \n", "72.039969 | \n", "72.035831 | \n", "72.032904 | \n", "72.029738 | \n", "72.025476 | \n", "... | \n", "0.085380 | \n", "0.065497 | \n", "0.072515 | \n", "0.072515 | \n", "0.070175 | \n", "0.072515 | \n", "0.072515 | \n", "0.105263 | \n", "0.108772 | \n", "0.105263 | \n", "
| std | \n", "34.183615 | \n", "34.176714 | \n", "34.177036 | \n", "34.176854 | \n", "34.173544 | \n", "34.172700 | \n", "34.170911 | \n", "34.170539 | \n", "34.169971 | \n", "34.168179 | \n", "... | \n", "0.279453 | \n", "0.247407 | \n", "0.259344 | \n", "0.259344 | \n", "0.255449 | \n", "0.259344 | \n", "0.259344 | \n", "0.306900 | \n", "0.311360 | \n", "0.306900 | \n", "
| min | \n", "18.704900 | \n", "18.704900 | \n", "18.704900 | \n", "18.704900 | \n", "18.704900 | \n", "18.704900 | \n", "18.704900 | \n", "18.704900 | \n", "18.704900 | \n", "18.704900 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "
| 25% | \n", "48.164400 | \n", "48.156475 | \n", "48.154175 | \n", "48.152250 | \n", "48.147300 | \n", "48.145375 | \n", "48.140500 | \n", "48.134600 | \n", "48.132500 | \n", "48.130500 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "
| 50% | \n", "65.084300 | \n", "65.010100 | \n", "65.008500 | \n", "65.007250 | \n", "65.002250 | \n", "64.996600 | \n", "64.995100 | \n", "64.993600 | \n", "64.989550 | \n", "64.985950 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "
| 75% | \n", "88.620925 | \n", "88.541800 | \n", "88.541800 | \n", "88.531450 | \n", "88.526450 | \n", "88.521425 | \n", "88.517825 | \n", "88.516725 | \n", "88.513675 | \n", "88.496425 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "
| max | \n", "329.440000 | \n", "329.440000 | \n", "329.440000 | \n", "329.440000 | \n", "329.440000 | \n", "329.440000 | \n", "329.440000 | \n", "329.440000 | \n", "329.440000 | \n", "329.440000 | \n", "... | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "
8 rows × 94 columns
\n", "| \n", " | Ph-24 | \n", "Ph-25 | \n", "Ph-26 | \n", "Ph-27 | \n", "Ph-28 | \n", "Ph-29 | \n", "Ph-30 | \n", "Ph-31 | \n", "Ph-32 | \n", "Ph-33 | \n", "... | \n", "month_Dec | \n", "month_Feb | \n", "month_Jan | \n", "month_Jul | \n", "month_Jun | \n", "month_Mar | \n", "month_May | \n", "month_Nov | \n", "month_Oct | \n", "month_Sep | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Fecha_hora | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
| 2016-08-09 00:00:00 | \n", "54.8461 | \n", "45.1982 | \n", "44.7123 | \n", "46.2995 | \n", "42.9422 | \n", "44.3551 | \n", "46.3440 | \n", "45.6826 | \n", "42.6676 | \n", "39.0872 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 2016-08-09 01:00:00 | \n", "52.2179 | \n", "54.8461 | \n", "45.1982 | \n", "44.7123 | \n", "46.2995 | \n", "42.9422 | \n", "44.3551 | \n", "46.3440 | \n", "45.6826 | \n", "42.6676 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 2016-08-09 02:00:00 | \n", "61.9198 | \n", "52.2179 | \n", "54.8461 | \n", "45.1982 | \n", "44.7123 | \n", "46.2995 | \n", "42.9422 | \n", "44.3551 | \n", "46.3440 | \n", "45.6826 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 2016-08-09 03:00:00 | \n", "36.8105 | \n", "61.9198 | \n", "52.2179 | \n", "54.8461 | \n", "45.1982 | \n", "44.7123 | \n", "46.2995 | \n", "42.9422 | \n", "44.3551 | \n", "46.3440 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 2016-08-09 04:00:00 | \n", "34.8274 | \n", "36.8105 | \n", "61.9198 | \n", "52.2179 | \n", "54.8461 | \n", "45.1982 | \n", "44.7123 | \n", "46.2995 | \n", "42.9422 | \n", "44.3551 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
5 rows × 93 columns
\n", "