{ "cells": [ { "cell_type": "code", "execution_count": 26, "id": "702c8313-4ccd-4478-a648-1087978f8af5", "metadata": {}, "outputs": [], "source": [ "import pickle\n", "import pandas as pd\n", "import matplotlib.pyplot as plt" ] }, { "cell_type": "code", "execution_count": 16, "id": "06393522-6a98-46d1-98ec-adc8a889be25", "metadata": {}, "outputs": [], "source": [ "df = pd.read_pickle('data/test_data.pkl')\n", "df = df.loc[(df[\"Branch\"] == \"15\") & (df[\"Group\"].isin([\"6\",\"7\",\"4\",\"1\"]))]" ] }, { "cell_type": "code", "execution_count": 17, "id": "c67e2a79-d310-4832-a8e5-f16fecb6b9be", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | sales | \n", "DayInYear | \n", "time_idx | \n", "Wahl | \n", "Baustelle | \n", "MontagLangesWE | \n", "FreitagLangesWE | \n", "nosale | \n", "holiday | \n", "AufSommerzeit | \n", "... | \n", "Branch | \n", "Weekday | \n", "Date | \n", "MTXWTH_Day_precip | \n", "MTXWTH_Temp_max | \n", "MTXWTH_Temp_min | \n", "Start | \n", "End | \n", "ShiftLength | \n", "weight | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
270300 | \n", "1600.9030 | \n", "177 | \n", "2369 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "none | \n", "0.0 | \n", "... | \n", "15 | \n", "6 | \n", "2022-06-26 | \n", "0.0 | \n", "28.52 | \n", "17.47 | \n", "7.0 | \n", "10.983333 | \n", "240.0 | \n", "1 | \n", "
270301 | \n", "1811.1958 | \n", "178 | \n", "2370 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "none | \n", "0.0 | \n", "... | \n", "15 | \n", "0 | \n", "2022-06-27 | \n", "0.0 | \n", "25.75 | \n", "16.70 | \n", "6.0 | \n", "13.983333 | \n", "480.0 | \n", "1 | \n", "
270302 | \n", "1784.2916 | \n", "179 | \n", "2371 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "none | \n", "0.0 | \n", "... | \n", "15 | \n", "1 | \n", "2022-06-28 | \n", "0.0 | \n", "23.57 | \n", "14.17 | \n", "6.0 | \n", "13.983333 | \n", "480.0 | \n", "1 | \n", "
270303 | \n", "1757.3488 | \n", "180 | \n", "2372 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "none | \n", "0.0 | \n", "... | \n", "15 | \n", "2 | \n", "2022-06-29 | \n", "0.0 | \n", "26.81 | \n", "13.09 | \n", "6.0 | \n", "13.983333 | \n", "480.0 | \n", "1 | \n", "
270304 | \n", "1741.0982 | \n", "181 | \n", "2373 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "none | \n", "0.0 | \n", "... | \n", "15 | \n", "3 | \n", "2022-06-30 | \n", "0.0 | \n", "27.26 | \n", "15.00 | \n", "6.0 | \n", "13.983333 | \n", "480.0 | \n", "1 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
287065 | \n", "1643.1700 | \n", "173 | \n", "2730 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "none | \n", "0.0 | \n", "... | \n", "15 | \n", "3 | \n", "2023-06-22 | \n", "0.0 | \n", "26.93 | \n", "13.06 | \n", "6.0 | \n", "16.983333 | \n", "660.0 | \n", "1 | \n", "
287066 | \n", "1597.3518 | \n", "174 | \n", "2731 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "none | \n", "0.0 | \n", "... | \n", "15 | \n", "4 | \n", "2023-06-23 | \n", "1.0 | \n", "23.99 | \n", "15.98 | \n", "6.0 | \n", "16.983333 | \n", "660.0 | \n", "1 | \n", "
287067 | \n", "1683.6228 | \n", "175 | \n", "2732 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "none | \n", "0.0 | \n", "... | \n", "15 | \n", "5 | \n", "2023-06-24 | \n", "0.0 | \n", "25.99 | \n", "12.04 | \n", "6.0 | \n", "15.983333 | \n", "600.0 | \n", "1 | \n", "
287068 | \n", "1785.2180 | \n", "176 | \n", "2733 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "none | \n", "0.0 | \n", "... | \n", "15 | \n", "6 | \n", "2023-06-25 | \n", "0.0 | \n", "28.99 | \n", "15.02 | \n", "7.0 | \n", "15.983333 | \n", "540.0 | \n", "1 | \n", "
287069 | \n", "1589.9020 | \n", "177 | \n", "2734 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "none | \n", "0.0 | \n", "... | \n", "15 | \n", "0 | \n", "2023-06-26 | \n", "0.0 | \n", "27.96 | \n", "17.01 | \n", "6.0 | \n", "16.983333 | \n", "660.0 | \n", "1 | \n", "
1464 rows × 22 columns
\n", "\n", " | time_idx | \n", "Group | \n", "Branch | \n", "h | \n", "q | \n", "pred | \n", "pred_idx | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "2490 | \n", "1 | \n", "15 | \n", "1 | \n", "0 | \n", "1826.949707 | \n", "2490 | \n", "
1 | \n", "2490 | \n", "1 | \n", "15 | \n", "2 | \n", "0 | \n", "1856.215088 | \n", "2491 | \n", "
2 | \n", "2490 | \n", "1 | \n", "15 | \n", "3 | \n", "0 | \n", "1871.929688 | \n", "2492 | \n", "
3 | \n", "2490 | \n", "1 | \n", "15 | \n", "4 | \n", "0 | \n", "1866.095825 | \n", "2493 | \n", "
4 | \n", "2490 | \n", "1 | \n", "15 | \n", "5 | \n", "0 | \n", "1787.610840 | \n", "2494 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
115 | \n", "2490 | \n", "7 | \n", "15 | \n", "26 | \n", "0 | \n", "1655.261475 | \n", "2515 | \n", "
116 | \n", "2490 | \n", "7 | \n", "15 | \n", "27 | \n", "0 | \n", "1794.728027 | \n", "2516 | \n", "
117 | \n", "2490 | \n", "7 | \n", "15 | \n", "28 | \n", "0 | \n", "1600.507812 | \n", "2517 | \n", "
118 | \n", "2490 | \n", "7 | \n", "15 | \n", "29 | \n", "0 | \n", "1595.128540 | \n", "2518 | \n", "
119 | \n", "2490 | \n", "7 | \n", "15 | \n", "30 | \n", "0 | \n", "1557.557007 | \n", "2519 | \n", "
120 rows × 7 columns
\n", "\n", " | time_idx | \n", "sales | \n", "Group | \n", "
---|---|---|---|
270300 | \n", "2369 | \n", "1600.9030 | \n", "1 | \n", "
270301 | \n", "2370 | \n", "1811.1958 | \n", "1 | \n", "
270302 | \n", "2371 | \n", "1784.2916 | \n", "1 | \n", "
270303 | \n", "2372 | \n", "1757.3488 | \n", "1 | \n", "
270304 | \n", "2373 | \n", "1741.0982 | \n", "1 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "
287065 | \n", "2730 | \n", "1643.1700 | \n", "7 | \n", "
287066 | \n", "2731 | \n", "1597.3518 | \n", "7 | \n", "
287067 | \n", "2732 | \n", "1683.6228 | \n", "7 | \n", "
287068 | \n", "2733 | \n", "1785.2180 | \n", "7 | \n", "
287069 | \n", "2734 | \n", "1589.9020 | \n", "7 | \n", "
1464 rows × 3 columns
\n", "