![\"Open](\"https://colab.research.google.com/assets/colab-badge.svg\"){kind=icon}
"
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {
"id": "Woz84olkInHF"
},
"outputs": [],
"source": [
"import numpy as np\n",
"import pandas as pd\n",
"\n",
"import matplotlib.pyplot as plt\n",
"import seaborn as sns\n",
"\n",
"palette=sns.color_palette()\n",
"sns.set_theme()"
]
},
{
"cell_type": "code",
"source": [
"df=pd.read_csv('DUQ_hourly.csv',\n",
" index_col='Datetime',\n",
" parse_dates=True)"
],
"metadata": {
"id": "QNsp2XuhN5jq"
},
"execution_count": 52,
"outputs": []
},
{
"cell_type": "code",
"source": [
"df.info()"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "kQWggu9cPoJm",
"outputId": "d0ea6413-e39d-444d-9d72-42ba1a6fb030"
},
"execution_count": 18,
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
"| \n", " | ds | \n", "trend | \n", "yhat_lower | \n", "yhat_upper | \n", "trend_lower | \n", "trend_upper | \n", "additive_terms | \n", "additive_terms_lower | \n", "additive_terms_upper | \n", "daily | \n", "... | \n", "weekly | \n", "weekly_lower | \n", "weekly_upper | \n", "yearly | \n", "yearly_lower | \n", "yearly_upper | \n", "multiplicative_terms | \n", "multiplicative_terms_lower | \n", "multiplicative_terms_upper | \n", "yhat | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "2016-01-01 00:00:00 | \n", "1587.411121 | \n", "1289.872403 | \n", "1709.200353 | \n", "1587.411121 | \n", "1587.411121 | \n", "-79.404115 | \n", "-79.404115 | \n", "-79.404115 | \n", "-102.704821 | \n", "... | \n", "57.072075 | \n", "57.072075 | \n", "57.072075 | \n", "-33.771369 | \n", "-33.771369 | \n", "-33.771369 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "1508.007006 | \n", "
| 1 | \n", "2016-01-01 01:00:00 | \n", "1587.404299 | \n", "1208.570563 | \n", "1637.622988 | \n", "1587.404299 | \n", "1587.404299 | \n", "-171.543092 | \n", "-171.543092 | \n", "-171.543092 | \n", "-194.292211 | \n", "... | \n", "56.436864 | \n", "56.436864 | \n", "56.436864 | \n", "-33.687744 | \n", "-33.687744 | \n", "-33.687744 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "1415.861208 | \n", "
| 2 | \n", "2016-01-01 02:00:00 | \n", "1587.397477 | \n", "1129.266689 | \n", "1559.934477 | \n", "1587.397477 | \n", "1587.397477 | \n", "-240.691261 | \n", "-240.691261 | \n", "-240.691261 | \n", "-262.793208 | \n", "... | \n", "55.704201 | \n", "55.704201 | \n", "55.704201 | \n", "-33.602253 | \n", "-33.602253 | \n", "-33.602253 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "1346.706216 | \n", "
| 3 | \n", "2016-01-01 03:00:00 | \n", "1587.390655 | \n", "1105.440848 | \n", "1524.564908 | \n", "1587.390655 | \n", "1587.390655 | \n", "-280.398922 | \n", "-280.398922 | \n", "-280.398922 | \n", "-301.740829 | \n", "... | \n", "54.856803 | \n", "54.856803 | \n", "54.856803 | \n", "-33.514896 | \n", "-33.514896 | \n", "-33.514896 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "1306.991733 | \n", "
| 4 | \n", "2016-01-01 04:00:00 | \n", "1587.383833 | \n", "1081.818916 | \n", "1512.757601 | \n", "1587.383833 | \n", "1587.383833 | \n", "-288.730027 | \n", "-288.730027 | \n", "-288.730027 | \n", "-309.181109 | \n", "... | \n", "53.876755 | \n", "53.876755 | \n", "53.876755 | \n", "-33.425673 | \n", "-33.425673 | \n", "-33.425673 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "1298.653805 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 22675 | \n", "2018-08-02 20:00:00 | \n", "1432.713026 | \n", "538.241389 | \n", "3412.151695 | \n", "15.511093 | \n", "2872.970023 | \n", "506.742825 | \n", "506.742825 | \n", "506.742825 | \n", "182.370554 | \n", "... | \n", "58.951510 | \n", "58.951510 | \n", "58.951510 | \n", "265.420762 | \n", "265.420762 | \n", "265.420762 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "1939.455852 | \n", "
| 22676 | \n", "2018-08-02 21:00:00 | \n", "1432.706204 | \n", "439.222654 | \n", "3367.968389 | \n", "15.366671 | \n", "2873.126313 | \n", "475.537975 | \n", "475.537975 | \n", "475.537975 | \n", "151.859624 | \n", "... | \n", "58.552356 | \n", "58.552356 | \n", "58.552356 | \n", "265.125995 | \n", "265.125995 | \n", "265.125995 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "1908.244179 | \n", "
| 22677 | \n", "2018-08-02 22:00:00 | \n", "1432.699382 | \n", "472.561048 | \n", "3309.789409 | \n", "15.222249 | \n", "2873.282603 | \n", "411.428325 | \n", "411.428325 | \n", "411.428325 | \n", "88.482067 | \n", "... | \n", "58.114950 | \n", "58.114950 | \n", "58.114950 | \n", "264.831308 | \n", "264.831308 | \n", "264.831308 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "1844.127708 | \n", "
| 22678 | \n", "2018-08-02 23:00:00 | \n", "1432.692560 | \n", "317.263981 | \n", "3260.508485 | \n", "15.077827 | \n", "2873.438893 | \n", "320.174408 | \n", "320.174408 | \n", "320.174408 | \n", "-1.988590 | \n", "... | \n", "57.626287 | \n", "57.626287 | \n", "57.626287 | \n", "264.536711 | \n", "264.536711 | \n", "264.536711 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "1752.866968 | \n", "
| 22679 | \n", "2018-08-03 00:00:00 | \n", "1432.685738 | \n", "213.141056 | \n", "3132.068297 | \n", "14.933405 | \n", "2873.595182 | \n", "218.609464 | \n", "218.609464 | \n", "218.609464 | \n", "-102.704821 | \n", "... | \n", "57.072075 | \n", "57.072075 | \n", "57.072075 | \n", "264.242210 | \n", "264.242210 | \n", "264.242210 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "1651.295202 | \n", "
22680 rows × 22 columns
\n", "