{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"\n",
"Copyright © 2020-2021 by Fraunhofer-Gesellschaft. All rights reserved.
\n",
"Fraunhofer Institute for Integrated Circuits IIS, Division Engineering of Adaptive Systems EAS
\n",
"Münchner Straße 16, 01187 Dresden, Germany\n",
"\n",
"\n",
"---\n",
"\n",
"## ESB - Energy Saving by Blockchain\n",
"\n",
"Eurostars – EXP 00119832 / EUS-2019113348\n",
"\n",
"---\n",
"\n",
"## Prediction of Energy Consumption for Variable Customer Portfolios Including Aleatoric Uncertainty Estimation\n",
"\n",
"*Oliver Mey, André Schneider, Olaf Enge-Rosenblatt, Yesnier Bravo, Pit Stenzel*\n",
"\n",
"The notebook is part of a paper submission contributed to the **10th International Conference on Power Science and Engineering (ICPSE 2021)** will be held on Oct. 21-23, 2021 in Yildiz Technical University, Istanbul, Turkey.\n",
"\n",
"---\n",
"\n",
"# A1: Data Exploration\n",
"\n",
"This notebook loads the available datasets and explains the content and how the data is structured. Furthermore, a few sample plots illustrate the data.\n",
"\n",
"---\n",
"\n",
"\n",
"Version 0.3.7 (September 12, 2021)
\n",
"Authors: Oliver Mey, André Schneider (Fraunhofer IIS)
\n",
" "
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"import warnings, logging, os\n",
"warnings.filterwarnings('ignore')\n",
"logging.disable(logging.WARNING)\n",
"os.environ[\"TF_CPP_MIN_LOG_LEVEL\"] = \"3\""
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"import os\n",
"import joblib\n",
"import time\n",
"import numpy as np\n",
"import pandas as pd\n",
"import matplotlib.pyplot as plt\n",
"import holidays as hd\n",
"import seaborn as sns\n",
"import tensorflow as tf\n",
"\n",
"%matplotlib inline\n",
"sns.set(rc={'figure.figsize':(16, 6)})"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Configuration"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [],
"source": [
"path = '..'\n",
"categories = ['consumption', 'weather', 'profiles']\n",
"files = [path + '/data/' + '20201015_' + name + '.xlsx' for name in categories]\n",
"timezone = 'Europe/Madrid'"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Function Definitions"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [],
"source": [
"def fix_DST(data):\n",
" data = data[~data.index.duplicated(keep='first')]\n",
" data = data.resample('H').ffill()\n",
" return data\n",
"\n",
"def crop(data):\n",
" hour_index = data.index.hour\n",
" t0 = data[hour_index==0].head(1).index\n",
" tn = data[hour_index==23].tail(1).index\n",
" data.drop(data.loc[data.index < t0[0]].index, inplace=True)\n",
" data.drop(data.loc[data.index > tn[0]].index, inplace=True)\n",
" return"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Loading Consumption Data"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [],
"source": [
"consumptions = pd.read_excel(files[categories.index('consumption')], parse_dates=[0], index_col=0)\n",
"consumptions.columns = pd.DataFrame(consumptions.columns, columns=['customer']).index\n",
"consumptions.index.name = 'time'\n",
"fix_DST(consumptions)\n",
"crop(consumptions)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"The *consumptions* dataframe contains **499** columns. A column represents a single *customer* with a customer ID in the range of *0..498*. Each row in the dataframe contains the *consumption* values for a certain timestamp within the measurement period of about one year (Jan 01 - Dec 31, 2019). The time series were recorded with an hourly resolution. This means the dataframe contains **8760** rows (365 day x 24 hours)."
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"
| \n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "5 | \n", "6 | \n", "7 | \n", "8 | \n", "9 | \n", "... | \n", "489 | \n", "490 | \n", "491 | \n", "492 | \n", "493 | \n", "494 | \n", "495 | \n", "496 | \n", "497 | \n", "498 | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| time | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
| 2019-01-01 00:00:00 | \n", "0.039 | \n", "0.384 | \n", "0.986 | \n", "0.706 | \n", "0.304 | \n", "0.073 | \n", "3.262 | \n", "3.0 | \n", "0.645 | \n", "1.279 | \n", "... | \n", "0.431 | \n", "0.100 | \n", "0.010 | \n", "0.258 | \n", "0.009 | \n", "0.488 | \n", "0.810 | \n", "0.309 | \n", "0.366 | \n", "0.290 | \n", "
| 2019-01-01 01:00:00 | \n", "0.269 | \n", "0.051 | \n", "0.846 | \n", "2.210 | \n", "0.673 | \n", "0.047 | \n", "3.252 | \n", "4.0 | \n", "0.746 | \n", "0.851 | \n", "... | \n", "0.447 | \n", "0.025 | \n", "0.009 | \n", "0.232 | \n", "0.009 | \n", "0.447 | \n", "0.753 | \n", "0.381 | \n", "0.308 | \n", "0.369 | \n", "
| 2019-01-01 02:00:00 | \n", "0.331 | \n", "0.049 | \n", "0.970 | \n", "1.797 | \n", "0.310 | \n", "0.058 | \n", "3.043 | \n", "4.0 | \n", "0.678 | \n", "0.789 | \n", "... | \n", "0.439 | \n", "0.025 | \n", "0.009 | \n", "0.260 | \n", "0.009 | \n", "0.508 | \n", "0.092 | \n", "0.193 | \n", "0.137 | \n", "0.292 | \n", "
| 2019-01-01 03:00:00 | \n", "0.093 | \n", "0.049 | \n", "0.803 | \n", "1.010 | \n", "0.545 | \n", "0.059 | \n", "2.960 | \n", "4.0 | \n", "0.644 | \n", "0.637 | \n", "... | \n", "0.913 | \n", "0.023 | \n", "0.009 | \n", "0.252 | \n", "0.009 | \n", "0.511 | \n", "0.032 | \n", "0.124 | \n", "0.201 | \n", "0.358 | \n", "
| 2019-01-01 04:00:00 | \n", "0.116 | \n", "0.050 | \n", "1.303 | \n", "0.660 | \n", "0.410 | \n", "0.072 | \n", "3.054 | \n", "3.0 | \n", "0.130 | \n", "0.262 | \n", "... | \n", "1.256 | \n", "0.024 | \n", "0.009 | \n", "0.278 | \n", "0.009 | \n", "0.510 | \n", "0.081 | \n", "0.081 | \n", "0.223 | \n", "0.380 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 2019-12-31 19:00:00 | \n", "0.009 | \n", "0.052 | \n", "0.773 | \n", "0.138 | \n", "0.579 | \n", "0.322 | \n", "3.851 | \n", "2.0 | \n", "0.236 | \n", "0.303 | \n", "... | \n", "0.039 | \n", "1.308 | \n", "0.009 | \n", "1.761 | \n", "0.011 | \n", "2.036 | \n", "0.249 | \n", "0.223 | \n", "0.245 | \n", "0.573 | \n", "
| 2019-12-31 20:00:00 | \n", "0.009 | \n", "0.410 | \n", "0.738 | \n", "0.076 | \n", "0.229 | \n", "1.810 | \n", "3.767 | \n", "1.0 | \n", "0.053 | \n", "5.062 | \n", "... | \n", "0.036 | \n", "0.298 | \n", "0.027 | \n", "0.375 | \n", "0.011 | \n", "2.022 | \n", "0.058 | \n", "0.363 | \n", "0.354 | \n", "0.644 | \n", "
| 2019-12-31 21:00:00 | \n", "0.010 | \n", "0.058 | \n", "0.748 | \n", "0.072 | \n", "0.107 | \n", "1.478 | \n", "3.342 | \n", "1.0 | \n", "0.108 | \n", "2.140 | \n", "... | \n", "0.261 | \n", "0.120 | \n", "0.052 | \n", "0.463 | \n", "0.010 | \n", "1.107 | \n", "0.011 | \n", "0.573 | \n", "0.393 | \n", "0.635 | \n", "
| 2019-12-31 22:00:00 | \n", "0.009 | \n", "0.055 | \n", "0.873 | \n", "0.090 | \n", "0.071 | \n", "0.696 | \n", "3.084 | \n", "2.0 | \n", "0.067 | \n", "0.730 | \n", "... | \n", "2.799 | \n", "0.117 | \n", "0.051 | \n", "0.371 | \n", "0.011 | \n", "0.380 | \n", "0.039 | \n", "0.431 | \n", "0.429 | \n", "0.509 | \n", "
| 2019-12-31 23:00:00 | \n", "0.010 | \n", "0.056 | \n", "0.769 | \n", "1.001 | \n", "0.683 | \n", "1.017 | \n", "2.910 | \n", "2.0 | \n", "0.054 | \n", "0.646 | \n", "... | \n", "2.483 | \n", "0.111 | \n", "0.051 | \n", "0.435 | \n", "0.011 | \n", "0.404 | \n", "0.072 | \n", "0.300 | \n", "0.309 | \n", "0.419 | \n", "
8760 rows × 499 columns
\n", "| \n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "5 | \n", "6 | \n", "7 | \n", "8 | \n", "9 | \n", "... | \n", "489 | \n", "490 | \n", "491 | \n", "492 | \n", "493 | \n", "494 | \n", "495 | \n", "496 | \n", "497 | \n", "498 | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| count | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "... | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "
| mean | \n", "0.283303 | \n", "0.263868 | \n", "1.750522 | \n", "0.275184 | \n", "0.277605 | \n", "0.218282 | \n", "2.393745 | \n", "4.763017 | \n", "0.227725 | \n", "0.602395 | \n", "... | \n", "0.269928 | \n", "0.170956 | \n", "0.053764 | \n", "0.803501 | \n", "0.169984 | \n", "0.809818 | \n", "0.112445 | \n", "0.238333 | \n", "0.413233 | \n", "0.460819 | \n", "
| std | \n", "0.436013 | \n", "0.345561 | \n", "0.781109 | \n", "0.332088 | \n", "0.387865 | \n", "0.248986 | \n", "1.648356 | \n", "8.413416 | \n", "0.310379 | \n", "0.783770 | \n", "... | \n", "0.363086 | \n", "0.308614 | \n", "0.048554 | \n", "0.824487 | \n", "0.673361 | \n", "0.573233 | \n", "0.112697 | \n", "0.146475 | \n", "0.371725 | \n", "0.127375 | \n", "
| min | \n", "0.000000 | \n", "0.041000 | \n", "0.000000 | \n", "0.007000 | \n", "0.008000 | \n", "0.040000 | \n", "0.012000 | \n", "0.000000 | \n", "0.041000 | \n", "0.118000 | \n", "... | \n", "0.000000 | \n", "0.016000 | \n", "0.008000 | \n", "0.172000 | \n", "0.007000 | \n", "0.160000 | \n", "0.000000 | \n", "0.076000 | \n", "0.079000 | \n", "0.214000 | \n", "
| 25% | \n", "0.000000 | \n", "0.062000 | \n", "1.143750 | \n", "0.089000 | \n", "0.091000 | \n", "0.079000 | \n", "1.133750 | \n", "2.000000 | \n", "0.061000 | \n", "0.234000 | \n", "... | \n", "0.054000 | \n", "0.023000 | \n", "0.010000 | \n", "0.317750 | \n", "0.026000 | \n", "0.422000 | \n", "0.038000 | \n", "0.106000 | \n", "0.149000 | \n", "0.359000 | \n", "
| 50% | \n", "0.113000 | \n", "0.094000 | \n", "1.611000 | \n", "0.128000 | \n", "0.105000 | \n", "0.128000 | \n", "2.478500 | \n", "3.000000 | \n", "0.140000 | \n", "0.326000 | \n", "... | \n", "0.100000 | \n", "0.024000 | \n", "0.053000 | \n", "0.456000 | \n", "0.054000 | \n", "0.592000 | \n", "0.071000 | \n", "0.206500 | \n", "0.295000 | \n", "0.467000 | \n", "
| 75% | \n", "0.277000 | \n", "0.387250 | \n", "2.112250 | \n", "0.332000 | \n", "0.266000 | \n", "0.268000 | \n", "3.495000 | \n", "4.000000 | \n", "0.245000 | \n", "0.606000 | \n", "... | \n", "0.335250 | \n", "0.122000 | \n", "0.084000 | \n", "1.035250 | \n", "0.056000 | \n", "0.976000 | \n", "0.151000 | \n", "0.343000 | \n", "0.473000 | \n", "0.551000 | \n", "
| max | \n", "3.067000 | \n", "3.192000 | \n", "4.899000 | \n", "3.547000 | \n", "3.342000 | \n", "2.487000 | \n", "8.994000 | \n", "107.000000 | \n", "4.185000 | \n", "8.691000 | \n", "... | \n", "3.149000 | \n", "2.115000 | \n", "1.193000 | \n", "7.760000 | \n", "17.114000 | \n", "4.769000 | \n", "1.046000 | \n", "1.040000 | \n", "2.030000 | \n", "1.309000 | \n", "
8 rows × 499 columns
\n", "| \n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "5 | \n", "6 | \n", "7 | \n", "8 | \n", "9 | \n", "... | \n", "489 | \n", "490 | \n", "491 | \n", "492 | \n", "493 | \n", "494 | \n", "495 | \n", "496 | \n", "497 | \n", "498 | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| time | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
| 2019-01-01 00:00:00 | \n", "10.31 | \n", "10.35 | \n", "1.65 | \n", "1.70 | \n", "11.53 | \n", "10.76 | \n", "10.57 | \n", "0.43 | \n", "1.66 | \n", "10.49 | \n", "... | \n", "10.40 | \n", "9.53 | \n", "9.94 | \n", "3.19 | \n", "3.14 | \n", "3.20 | \n", "2.63 | \n", "1.51 | \n", "1.51 | \n", "1.51 | \n", "
| 2019-01-01 01:00:00 | \n", "10.34 | \n", "10.38 | \n", "1.33 | \n", "1.37 | \n", "11.78 | \n", "10.79 | \n", "10.61 | \n", "0.17 | \n", "1.33 | \n", "10.73 | \n", "... | \n", "10.65 | \n", "10.21 | \n", "10.63 | \n", "3.70 | \n", "3.65 | \n", "3.71 | \n", "2.08 | \n", "1.21 | \n", "1.21 | \n", "1.21 | \n", "
| 2019-01-01 02:00:00 | \n", "10.36 | \n", "10.40 | \n", "1.01 | \n", "1.05 | \n", "12.03 | \n", "10.82 | \n", "10.64 | \n", "-0.09 | \n", "1.01 | \n", "10.98 | \n", "... | \n", "10.90 | \n", "10.88 | \n", "11.33 | \n", "4.22 | \n", "4.17 | \n", "4.23 | \n", "1.53 | \n", "0.91 | \n", "0.91 | \n", "0.91 | \n", "
| 2019-01-01 03:00:00 | \n", "10.39 | \n", "10.43 | \n", "0.69 | \n", "0.73 | \n", "12.28 | \n", "10.84 | \n", "10.68 | \n", "-0.34 | \n", "0.69 | \n", "11.23 | \n", "... | \n", "11.14 | \n", "11.56 | \n", "12.02 | \n", "4.74 | \n", "4.69 | \n", "4.75 | \n", "0.99 | \n", "0.60 | \n", "0.60 | \n", "0.60 | \n", "
| 2019-01-01 04:00:00 | \n", "10.27 | \n", "10.31 | \n", "0.47 | \n", "0.51 | \n", "12.13 | \n", "10.73 | \n", "10.57 | \n", "-0.62 | \n", "0.48 | \n", "11.06 | \n", "... | \n", "10.97 | \n", "11.33 | \n", "11.79 | \n", "4.47 | \n", "4.42 | \n", "4.48 | \n", "0.76 | \n", "0.38 | \n", "0.38 | \n", "0.38 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 2019-12-31 19:00:00 | \n", "17.99 | \n", "18.03 | \n", "14.88 | \n", "14.94 | \n", "17.51 | \n", "18.15 | \n", "18.08 | \n", "12.33 | \n", "14.89 | \n", "16.91 | \n", "... | \n", "16.84 | \n", "16.00 | \n", "16.10 | \n", "11.62 | \n", "11.57 | \n", "11.63 | \n", "8.99 | \n", "13.20 | \n", "13.20 | \n", "13.20 | \n", "
| 2019-12-31 20:00:00 | \n", "17.87 | \n", "17.91 | \n", "14.69 | \n", "14.74 | \n", "17.32 | \n", "18.10 | \n", "18.01 | \n", "12.45 | \n", "14.70 | \n", "16.62 | \n", "... | \n", "16.54 | \n", "15.84 | \n", "16.01 | \n", "11.03 | \n", "10.98 | \n", "11.04 | \n", "8.11 | \n", "13.01 | \n", "13.01 | \n", "13.01 | \n", "
| 2019-12-31 21:00:00 | \n", "17.74 | \n", "17.78 | \n", "14.50 | \n", "14.55 | \n", "17.14 | \n", "18.05 | \n", "17.94 | \n", "12.57 | \n", "14.50 | \n", "16.33 | \n", "... | \n", "16.25 | \n", "15.68 | \n", "15.93 | \n", "10.44 | \n", "10.39 | \n", "10.45 | \n", "7.22 | \n", "12.82 | \n", "12.82 | \n", "12.82 | \n", "
| 2019-12-31 22:00:00 | \n", "17.74 | \n", "17.78 | \n", "14.50 | \n", "14.55 | \n", "17.14 | \n", "18.05 | \n", "17.94 | \n", "12.57 | \n", "14.50 | \n", "16.33 | \n", "... | \n", "16.25 | \n", "15.68 | \n", "15.93 | \n", "10.44 | \n", "10.39 | \n", "10.45 | \n", "7.22 | \n", "12.82 | \n", "12.82 | \n", "12.82 | \n", "
| 2019-12-31 23:00:00 | \n", "17.74 | \n", "17.78 | \n", "14.50 | \n", "14.55 | \n", "17.14 | \n", "18.05 | \n", "17.94 | \n", "12.57 | \n", "14.50 | \n", "16.33 | \n", "... | \n", "16.25 | \n", "15.68 | \n", "15.93 | \n", "10.44 | \n", "10.39 | \n", "10.45 | \n", "7.22 | \n", "12.82 | \n", "12.82 | \n", "12.82 | \n", "
8760 rows × 499 columns
\n", "| \n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "5 | \n", "6 | \n", "7 | \n", "8 | \n", "9 | \n", "... | \n", "489 | \n", "490 | \n", "491 | \n", "492 | \n", "493 | \n", "494 | \n", "495 | \n", "496 | \n", "497 | \n", "498 | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| count | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "... | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "8760.000000 | \n", "
| mean | \n", "18.677202 | \n", "18.695718 | \n", "19.025963 | \n", "19.074118 | \n", "18.640517 | \n", "18.575288 | \n", "18.575945 | \n", "16.410300 | \n", "19.031903 | \n", "18.483400 | \n", "... | \n", "18.428421 | \n", "18.076798 | \n", "18.121936 | \n", "18.029516 | \n", "18.013313 | \n", "18.032670 | \n", "16.298357 | \n", "17.600161 | \n", "17.600161 | \n", "17.600161 | \n", "
| std | \n", "4.170381 | \n", "4.156910 | \n", "8.816318 | \n", "8.815930 | \n", "4.049639 | \n", "3.999922 | \n", "4.043740 | \n", "8.096028 | \n", "8.816432 | \n", "4.382668 | \n", "... | \n", "4.401210 | \n", "4.164785 | \n", "4.071509 | \n", "7.831887 | \n", "7.862237 | \n", "7.825749 | \n", "8.248807 | \n", "8.541373 | \n", "8.541373 | \n", "8.541373 | \n", "
| min | \n", "8.340000 | \n", "8.380000 | \n", "-1.220000 | \n", "-1.180000 | \n", "8.540000 | \n", "8.550000 | \n", "8.460000 | \n", "-2.600000 | \n", "-1.220000 | \n", "7.560000 | \n", "... | \n", "7.460000 | \n", "7.090000 | \n", "7.390000 | \n", "1.730000 | \n", "1.680000 | \n", "1.740000 | \n", "-1.930000 | \n", "-1.410000 | \n", "-1.410000 | \n", "-1.410000 | \n", "
| 25% | \n", "15.477500 | \n", "15.500000 | \n", "12.287500 | \n", "12.337500 | \n", "15.520000 | \n", "15.520000 | \n", "15.470000 | \n", "10.097500 | \n", "12.290000 | \n", "15.050000 | \n", "... | \n", "14.970000 | \n", "14.890000 | \n", "15.000000 | \n", "11.937500 | \n", "11.890000 | \n", "11.940000 | \n", "9.917500 | \n", "10.947500 | \n", "10.947500 | \n", "10.947500 | \n", "
| 50% | \n", "18.600000 | \n", "18.630000 | \n", "18.630000 | \n", "18.680000 | \n", "18.580000 | \n", "18.525000 | \n", "18.510000 | \n", "15.830000 | \n", "18.640000 | \n", "18.380000 | \n", "... | \n", "18.335000 | \n", "18.315000 | \n", "18.330000 | \n", "17.150000 | \n", "17.125000 | \n", "17.160000 | \n", "15.570000 | \n", "17.150000 | \n", "17.150000 | \n", "17.150000 | \n", "
| 75% | \n", "21.680000 | \n", "21.692500 | \n", "25.290000 | \n", "25.330000 | \n", "21.640000 | \n", "21.470000 | \n", "21.500000 | \n", "22.042500 | \n", "25.292500 | \n", "21.800000 | \n", "... | \n", "21.760000 | \n", "21.380000 | \n", "21.330000 | \n", "23.270000 | \n", "23.262500 | \n", "23.262500 | \n", "22.180000 | \n", "23.762500 | \n", "23.762500 | \n", "23.762500 | \n", "
| max | \n", "31.440000 | \n", "31.420000 | \n", "42.070000 | \n", "42.120000 | \n", "29.450000 | \n", "30.900000 | \n", "31.010000 | \n", "38.570000 | \n", "42.080000 | \n", "29.650000 | \n", "... | \n", "29.650000 | \n", "29.680000 | \n", "29.840000 | \n", "43.050000 | \n", "43.100000 | \n", "43.040000 | \n", "39.010000 | \n", "39.710000 | \n", "39.710000 | \n", "39.710000 | \n", "
8 rows × 499 columns
\n", "| \n", " | customer | \n", "profile | \n", "
|---|---|---|
| 0 | \n", "5d6fcd1cf44b0324bc6b7254 | \n", "Actividades de los hogares como productores de... | \n", "
| 1 | \n", "5d6fcd1cf44b0324bc6b7257 | \n", "Actividades de los hogares como productores de... | \n", "
| 2 | \n", "5d6fcd1cf44b0324bc6b725a | \n", "Comercio al por menor de frutas y hortalizas e... | \n", "
| 3 | \n", "5d6fcd1cf44b0324bc6b725d | \n", "Actividades de los hogares como productores de... | \n", "
| 4 | \n", "5d6fcd1df44b0324bc6b7260 | \n", "Actividades de los hogares como productores de... | \n", "
| ... | \n", "... | \n", "... | \n", "
| 494 | \n", "5d6fcd7df44b0324bc6b79f7 | \n", "Actividades de los hogares como productores de... | \n", "
| 495 | \n", "5d6fcd7df44b0324bc6b79fd | \n", "Actividades de los hogares como productores de... | \n", "
| 496 | \n", "5d6fcd7ef44b0324bc6b7a00 | \n", "Otras actividades asociativas n.c.o.p. | \n", "
| 497 | \n", "5d6fcd7ef44b0324bc6b7a02 | \n", "Otras actividades asociativas n.c.o.p. | \n", "
| 498 | \n", "5d6fcd7ef44b0324bc6b7a03 | \n", "Otras actividades asociativas n.c.o.p. | \n", "
499 rows × 2 columns
\n", "| \n", " | profile | \n", "
|---|---|
| 0 | \n", "Actividades de los hogares como productores de... | \n", "
| 1 | \n", "Comercio al por menor de frutas y hortalizas e... | \n", "
| 2 | \n", "Fabricación de galletas y productos de panader... | \n", "
| 3 | \n", "Actividades de contabilidad, teneduría de libr... | \n", "
| 4 | \n", "Restaurantes y puestos de comidas | \n", "
| ... | \n", "... | \n", "
| 63 | \n", "Actividades generales de la Administración Púb... | \n", "
| 64 | \n", "Inversión colectiva, fondos y entidades financ... | \n", "
| 65 | \n", "Construcción de edificios | \n", "
| 66 | \n", "Actividades de fotocopiado, preparación de doc... | \n", "
| 67 | \n", "Compraventa de bienes inmobiliarios por cuenta... | \n", "
68 rows × 1 columns
\n", "| \n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "5 | \n", "6 | \n", "7 | \n", "8 | \n", "9 | \n", "... | \n", "489 | \n", "490 | \n", "491 | \n", "492 | \n", "493 | \n", "494 | \n", "495 | \n", "496 | \n", "497 | \n", "498 | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| time | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
| 2019-01-02 00:00:00 | \n", "10.31 | \n", "10.35 | \n", "1.65 | \n", "1.70 | \n", "11.53 | \n", "10.76 | \n", "10.57 | \n", "0.43 | \n", "1.66 | \n", "10.49 | \n", "... | \n", "10.40 | \n", "9.53 | \n", "9.94 | \n", "3.19 | \n", "3.14 | \n", "3.20 | \n", "2.63 | \n", "1.51 | \n", "1.51 | \n", "1.51 | \n", "
| 2019-01-02 01:00:00 | \n", "10.34 | \n", "10.38 | \n", "1.33 | \n", "1.37 | \n", "11.78 | \n", "10.79 | \n", "10.61 | \n", "0.17 | \n", "1.33 | \n", "10.73 | \n", "... | \n", "10.65 | \n", "10.21 | \n", "10.63 | \n", "3.70 | \n", "3.65 | \n", "3.71 | \n", "2.08 | \n", "1.21 | \n", "1.21 | \n", "1.21 | \n", "
| 2019-01-02 02:00:00 | \n", "10.36 | \n", "10.40 | \n", "1.01 | \n", "1.05 | \n", "12.03 | \n", "10.82 | \n", "10.64 | \n", "-0.09 | \n", "1.01 | \n", "10.98 | \n", "... | \n", "10.90 | \n", "10.88 | \n", "11.33 | \n", "4.22 | \n", "4.17 | \n", "4.23 | \n", "1.53 | \n", "0.91 | \n", "0.91 | \n", "0.91 | \n", "
| 2019-01-02 03:00:00 | \n", "10.39 | \n", "10.43 | \n", "0.69 | \n", "0.73 | \n", "12.28 | \n", "10.84 | \n", "10.68 | \n", "-0.34 | \n", "0.69 | \n", "11.23 | \n", "... | \n", "11.14 | \n", "11.56 | \n", "12.02 | \n", "4.74 | \n", "4.69 | \n", "4.75 | \n", "0.99 | \n", "0.60 | \n", "0.60 | \n", "0.60 | \n", "
| 2019-01-02 04:00:00 | \n", "10.27 | \n", "10.31 | \n", "0.47 | \n", "0.51 | \n", "12.13 | \n", "10.73 | \n", "10.57 | \n", "-0.62 | \n", "0.48 | \n", "11.06 | \n", "... | \n", "10.97 | \n", "11.33 | \n", "11.79 | \n", "4.47 | \n", "4.42 | \n", "4.48 | \n", "0.76 | \n", "0.38 | \n", "0.38 | \n", "0.38 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 2020-01-01 19:00:00 | \n", "17.99 | \n", "18.03 | \n", "14.88 | \n", "14.94 | \n", "17.51 | \n", "18.15 | \n", "18.08 | \n", "12.33 | \n", "14.89 | \n", "16.91 | \n", "... | \n", "16.84 | \n", "16.00 | \n", "16.10 | \n", "11.62 | \n", "11.57 | \n", "11.63 | \n", "8.99 | \n", "13.20 | \n", "13.20 | \n", "13.20 | \n", "
| 2020-01-01 20:00:00 | \n", "17.87 | \n", "17.91 | \n", "14.69 | \n", "14.74 | \n", "17.32 | \n", "18.10 | \n", "18.01 | \n", "12.45 | \n", "14.70 | \n", "16.62 | \n", "... | \n", "16.54 | \n", "15.84 | \n", "16.01 | \n", "11.03 | \n", "10.98 | \n", "11.04 | \n", "8.11 | \n", "13.01 | \n", "13.01 | \n", "13.01 | \n", "
| 2020-01-01 21:00:00 | \n", "17.74 | \n", "17.78 | \n", "14.50 | \n", "14.55 | \n", "17.14 | \n", "18.05 | \n", "17.94 | \n", "12.57 | \n", "14.50 | \n", "16.33 | \n", "... | \n", "16.25 | \n", "15.68 | \n", "15.93 | \n", "10.44 | \n", "10.39 | \n", "10.45 | \n", "7.22 | \n", "12.82 | \n", "12.82 | \n", "12.82 | \n", "
| 2020-01-01 22:00:00 | \n", "17.74 | \n", "17.78 | \n", "14.50 | \n", "14.55 | \n", "17.14 | \n", "18.05 | \n", "17.94 | \n", "12.57 | \n", "14.50 | \n", "16.33 | \n", "... | \n", "16.25 | \n", "15.68 | \n", "15.93 | \n", "10.44 | \n", "10.39 | \n", "10.45 | \n", "7.22 | \n", "12.82 | \n", "12.82 | \n", "12.82 | \n", "
| 2020-01-01 23:00:00 | \n", "17.74 | \n", "17.78 | \n", "14.50 | \n", "14.55 | \n", "17.14 | \n", "18.05 | \n", "17.94 | \n", "12.57 | \n", "14.50 | \n", "16.33 | \n", "... | \n", "16.25 | \n", "15.68 | \n", "15.93 | \n", "10.44 | \n", "10.39 | \n", "10.45 | \n", "7.22 | \n", "12.82 | \n", "12.82 | \n", "12.82 | \n", "
8760 rows × 499 columns
\n", "| \n", " | day_of_week | \n", "day_of_month | \n", "month | \n", "day_category | \n", "
|---|---|---|---|---|
| date | \n", "\n", " | \n", " | \n", " | \n", " |
| 2019-01-01 | \n", "1 | \n", "1 | \n", "1 | \n", "4 | \n", "
| 2019-01-02 | \n", "2 | \n", "2 | \n", "1 | \n", "1 | \n", "
| 2019-01-03 | \n", "3 | \n", "3 | \n", "1 | \n", "1 | \n", "
| 2019-01-04 | \n", "4 | \n", "4 | \n", "1 | \n", "2 | \n", "
| 2019-01-05 | \n", "5 | \n", "5 | \n", "1 | \n", "3 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 2019-12-27 | \n", "4 | \n", "27 | \n", "12 | \n", "2 | \n", "
| 2019-12-28 | \n", "5 | \n", "28 | \n", "12 | \n", "3 | \n", "
| 2019-12-29 | \n", "6 | \n", "29 | \n", "12 | \n", "4 | \n", "
| 2019-12-30 | \n", "0 | \n", "30 | \n", "12 | \n", "0 | \n", "
| 2019-12-31 | \n", "1 | \n", "31 | \n", "12 | \n", "1 | \n", "
365 rows × 4 columns
\n", "| \n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "5 | \n", "6 | \n", "7 | \n", "8 | \n", "9 | \n", "... | \n", "489 | \n", "490 | \n", "491 | \n", "492 | \n", "493 | \n", "494 | \n", "495 | \n", "496 | \n", "497 | \n", "498 | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| date | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
| 2019-01-01 | \n", "0.107208 | \n", "0.119875 | \n", "0.932625 | \n", "0.432833 | \n", "0.580750 | \n", "0.155292 | \n", "3.258292 | \n", "3.083333 | \n", "0.310667 | \n", "0.663500 | \n", "... | \n", "0.484083 | \n", "0.090833 | \n", "0.017417 | \n", "0.257833 | \n", "0.008958 | \n", "0.876458 | \n", "0.107708 | \n", "0.249500 | \n", "0.280333 | \n", "0.341458 | \n", "
| 2019-01-02 | \n", "0.145333 | \n", "0.112542 | \n", "1.224708 | \n", "0.394375 | \n", "0.312583 | \n", "0.201458 | \n", "3.240833 | \n", "3.125000 | \n", "0.359667 | \n", "1.056167 | \n", "... | \n", "0.535167 | \n", "0.207208 | \n", "0.017833 | \n", "1.256625 | \n", "0.008792 | \n", "1.031042 | \n", "0.043375 | \n", "0.256208 | \n", "0.329125 | \n", "0.364458 | \n", "
| 2019-01-03 | \n", "0.453875 | \n", "0.297750 | \n", "1.159792 | \n", "0.532375 | \n", "0.418292 | \n", "0.300583 | \n", "3.323167 | \n", "2.791667 | \n", "0.331083 | \n", "0.842958 | \n", "... | \n", "0.588833 | \n", "0.226792 | \n", "0.018042 | \n", "1.335750 | \n", "0.008917 | \n", "1.105083 | \n", "0.041417 | \n", "0.277292 | \n", "0.325250 | \n", "0.367042 | \n", "
| 2019-01-04 | \n", "0.640625 | \n", "0.288208 | \n", "1.158750 | \n", "0.387958 | \n", "0.459500 | \n", "0.205417 | \n", "3.309583 | \n", "2.875000 | \n", "0.280542 | \n", "1.194917 | \n", "... | \n", "0.486542 | \n", "0.215167 | \n", "0.017917 | \n", "1.038750 | \n", "0.008875 | \n", "1.100333 | \n", "0.038833 | \n", "0.317458 | \n", "0.329500 | \n", "0.371917 | \n", "
| 2019-01-05 | \n", "0.482958 | \n", "0.285708 | \n", "1.099417 | \n", "0.519792 | \n", "0.191208 | \n", "0.213208 | \n", "3.298625 | \n", "2.833333 | \n", "0.221875 | \n", "0.951708 | \n", "... | \n", "0.376167 | \n", "0.086333 | \n", "0.017625 | \n", "0.543000 | \n", "0.363250 | \n", "1.001625 | \n", "0.038625 | \n", "0.276875 | \n", "0.325792 | \n", "0.366250 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 2019-12-27 | \n", "0.000000 | \n", "0.114250 | \n", "1.130208 | \n", "0.275958 | \n", "0.220958 | \n", "0.129042 | \n", "3.240458 | \n", "2.859417 | \n", "0.347042 | \n", "0.844292 | \n", "... | \n", "0.387542 | \n", "0.271125 | \n", "0.021042 | \n", "1.155583 | \n", "0.599708 | \n", "0.865417 | \n", "0.040750 | \n", "0.292458 | \n", "0.287458 | \n", "0.511625 | \n", "
| 2019-12-28 | \n", "0.000000 | \n", "0.115958 | \n", "1.087667 | \n", "0.316417 | \n", "0.478667 | \n", "0.103792 | \n", "3.336417 | \n", "2.691667 | \n", "0.261583 | \n", "0.447042 | \n", "... | \n", "0.349333 | \n", "0.045125 | \n", "0.020500 | \n", "0.597792 | \n", "1.556708 | \n", "0.638792 | \n", "0.038958 | \n", "0.213125 | \n", "0.235708 | \n", "0.498042 | \n", "
| 2019-12-29 | \n", "0.262000 | \n", "0.116167 | \n", "0.928208 | \n", "0.262750 | \n", "0.444292 | \n", "0.148417 | \n", "3.481667 | \n", "2.900000 | \n", "0.404083 | \n", "0.786333 | \n", "... | \n", "0.342167 | \n", "0.045042 | \n", "0.020583 | \n", "0.402208 | \n", "0.281792 | \n", "0.736917 | \n", "0.038917 | \n", "0.210375 | \n", "0.200708 | \n", "0.500333 | \n", "
| 2019-12-30 | \n", "0.049375 | \n", "0.114875 | \n", "1.115000 | \n", "0.325542 | \n", "0.433208 | \n", "0.153667 | \n", "3.418458 | \n", "1.526958 | \n", "0.453750 | \n", "0.546667 | \n", "... | \n", "0.379167 | \n", "0.320083 | \n", "0.021000 | \n", "1.577417 | \n", "0.149375 | \n", "1.053792 | \n", "0.074458 | \n", "0.247208 | \n", "0.238250 | \n", "0.540667 | \n", "
| 2019-12-31 | \n", "0.053833 | \n", "0.118292 | \n", "1.009083 | \n", "0.372625 | \n", "0.347458 | \n", "0.327750 | \n", "3.376000 | \n", "1.250000 | \n", "0.305417 | \n", "0.845167 | \n", "... | \n", "0.345417 | \n", "0.278292 | \n", "0.021208 | \n", "0.846375 | \n", "0.026583 | \n", "0.946125 | \n", "0.127625 | \n", "0.241958 | \n", "0.224792 | \n", "0.520167 | \n", "
365 rows × 499 columns
\n", "| \n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "5 | \n", "6 | \n", "7 | \n", "8 | \n", "9 | \n", "... | \n", "489 | \n", "490 | \n", "491 | \n", "492 | \n", "493 | \n", "494 | \n", "495 | \n", "496 | \n", "497 | \n", "498 | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| date | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
| 2019-01-01 | \n", "12.328750 | \n", "12.363750 | \n", "5.349583 | \n", "5.397500 | \n", "13.213750 | \n", "12.522083 | \n", "12.431667 | \n", "4.043750 | \n", "5.355417 | \n", "12.523750 | \n", "... | \n", "12.446667 | \n", "12.350417 | \n", "12.591667 | \n", "8.065833 | \n", "8.027917 | \n", "8.072917 | \n", "4.481250 | \n", "4.748333 | \n", "4.748333 | \n", "4.748333 | \n", "
| 2019-01-02 | \n", "14.049583 | \n", "14.085417 | \n", "5.789167 | \n", "5.838750 | \n", "14.077083 | \n", "14.242500 | \n", "14.152083 | \n", "5.395417 | \n", "5.795833 | \n", "13.386667 | \n", "... | \n", "13.310000 | \n", "13.039167 | \n", "13.280417 | \n", "9.103750 | \n", "9.065417 | \n", "9.110417 | \n", "4.233750 | \n", "5.606667 | \n", "5.606667 | \n", "5.606667 | \n", "
| 2019-01-03 | \n", "14.383333 | \n", "14.418333 | \n", "6.513750 | \n", "6.562083 | \n", "14.542500 | \n", "14.576667 | \n", "14.485833 | \n", "5.731250 | \n", "6.519583 | \n", "13.852917 | \n", "... | \n", "13.775000 | \n", "13.766250 | \n", "14.007500 | \n", "9.659583 | \n", "9.622917 | \n", "9.667917 | \n", "5.296667 | \n", "6.423750 | \n", "6.423750 | \n", "6.423750 | \n", "
| 2019-01-04 | \n", "14.302917 | \n", "14.338333 | \n", "7.785417 | \n", "7.833750 | \n", "14.669583 | \n", "14.497083 | \n", "14.405833 | \n", "7.046250 | \n", "7.792500 | \n", "13.979167 | \n", "... | \n", "13.902500 | \n", "13.527083 | \n", "13.769583 | \n", "9.515417 | \n", "9.477500 | \n", "9.522500 | \n", "5.637917 | \n", "7.262500 | \n", "7.262500 | \n", "7.262500 | \n", "
| 2019-01-05 | \n", "13.712500 | \n", "13.747083 | \n", "7.265000 | \n", "7.313750 | \n", "13.882917 | \n", "13.905833 | \n", "13.815000 | \n", "7.292500 | \n", "7.271250 | \n", "13.191250 | \n", "... | \n", "13.115833 | \n", "13.099583 | \n", "13.341250 | \n", "9.204167 | \n", "9.166667 | \n", "9.211667 | \n", "4.648333 | \n", "6.455833 | \n", "6.455833 | \n", "6.455833 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 2019-12-27 | \n", "16.589583 | \n", "16.623333 | \n", "12.034167 | \n", "12.082917 | \n", "16.086250 | \n", "16.692500 | \n", "16.649167 | \n", "11.165417 | \n", "12.040417 | \n", "15.467083 | \n", "... | \n", "15.393750 | \n", "15.867083 | \n", "16.108750 | \n", "12.208750 | \n", "12.175417 | \n", "12.215417 | \n", "9.508750 | \n", "10.398333 | \n", "10.398333 | \n", "10.398333 | \n", "
| 2019-12-28 | \n", "16.762917 | \n", "16.797500 | \n", "13.096250 | \n", "13.143750 | \n", "16.247083 | \n", "16.866667 | \n", "16.822083 | \n", "11.322917 | \n", "13.101250 | \n", "15.627083 | \n", "... | \n", "15.554167 | \n", "16.672500 | \n", "16.915000 | \n", "12.948333 | \n", "12.915000 | \n", "12.955000 | \n", "10.972500 | \n", "11.366250 | \n", "11.366250 | \n", "11.366250 | \n", "
| 2019-12-29 | \n", "16.808333 | \n", "16.842500 | \n", "13.534583 | \n", "13.583750 | \n", "16.498333 | \n", "16.912500 | \n", "16.867083 | \n", "11.932917 | \n", "13.541250 | \n", "15.879583 | \n", "... | \n", "15.805417 | \n", "14.752083 | \n", "14.994583 | \n", "11.788750 | \n", "11.755417 | \n", "11.795417 | \n", "8.668750 | \n", "11.740833 | \n", "11.740833 | \n", "11.740833 | \n", "
| 2019-12-30 | \n", "16.168750 | \n", "16.202500 | \n", "10.853333 | \n", "10.902917 | \n", "15.985000 | \n", "16.271667 | \n", "16.227500 | \n", "9.983333 | \n", "10.860000 | \n", "15.364583 | \n", "... | \n", "15.292083 | \n", "15.672917 | \n", "15.914583 | \n", "11.605417 | \n", "11.572083 | \n", "11.612083 | \n", "9.310833 | \n", "9.405833 | \n", "9.405833 | \n", "9.405833 | \n", "
| 2019-12-31 | \n", "16.911250 | \n", "16.945833 | \n", "13.942083 | \n", "13.990833 | \n", "16.502917 | \n", "17.014167 | \n", "16.972083 | \n", "12.518750 | \n", "13.948333 | \n", "15.889167 | \n", "... | \n", "15.816667 | \n", "15.839167 | \n", "16.074167 | \n", "12.520833 | \n", "12.487083 | \n", "12.527500 | \n", "10.239583 | \n", "11.876250 | \n", "11.876250 | \n", "11.876250 | \n", "
365 rows × 499 columns
\n", "