![\"Open](\"https://colab.research.google.com/assets/colab-badge.svg\"){kind=icon}
"
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "KKRvdotGoCVs",
"colab_type": "text"
},
"source": [
"#Data Set Overivew\n",
"\n",
"The tutorial uses the [Iowa Liquor Retails Sales](https://console.cloud.google.com/marketplace/details/iowa-department-of-commerce/iowa-liquor-sales). We will be using the dataset to predict future sales for one of the stores\n",
"\n",
"This dataset contains every wholesale purchase of liquor in the State of Iowa by retailers for sale to individuals since January 1, 2012. \n",
"\n",
"The State of Iowa controls the wholesale distribution of liquor intended for retail sale, which means this dataset offers a complete view of retail liquor sales in the entire state. The dataset contains every wholesale order of liquor by all grocery stores, liquor stores, convenience stores, etc., with details about the store and location, the exact liquor brand and size, and the number of bottles ordered."
]
},
{
"cell_type": "code",
"metadata": {
"id": "oxappFRWR6qm",
"colab_type": "code",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 71
},
"outputId": "014a4b8e-162f-4ef2-8ea2-adf75fafc0a1"
},
"source": [
"#importing necessary packages\n",
"\n",
"import numpy as np\n",
"import matplotlib.pyplot as plt\n",
"import pandas as pd\n",
"import numpy as np\n",
"from datetime import datetime\n",
"import statsmodels.api as sm\n",
"import numpy as np \n",
"import xgboost as xgb\n",
"from sklearn.metrics import mean_squared_error, mean_absolute_error\n",
"import imageio\n",
"import os\n",
"from statsmodels.graphics.tsaplots import plot_acf\n",
"\n"
],
"execution_count": 1,
"outputs": [
{
"output_type": "stream",
"text": [
"/usr/local/lib/python3.6/dist-packages/statsmodels/tools/_testing.py:19: FutureWarning: pandas.util.testing is deprecated. Use the functions in the public API at pandas.testing instead.\n",
" import pandas.util.testing as tm\n"
],
"name": "stderr"
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "MI44fdd8Jtt5",
"colab_type": "text"
},
"source": [
"# Reading Data\n"
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "zp4xNDv3o5wy",
"colab_type": "text"
},
"source": [
"# Using GCP and Biq Query\n",
"To setup a project on Google Cloud Platform and use Big Query go to: http://console.cloud.google.com\n",
"\n",
"You can also watch my tutorial here: https://www.youtube.com/watch?v=m5qQ5GLmcZs"
]
},
{
"cell_type": "code",
"metadata": {
"id": "UnJynIZ72ypg",
"colab_type": "code",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 34
},
"outputId": "054666ca-31f3-4591-c022-dc82b3d68663"
},
"source": [
"from google.colab import auth\n",
"auth.authenticate_user()\n",
"print('Authenticated')\n",
"\n"
],
"execution_count": 3,
"outputs": [
{
"output_type": "stream",
"text": [
"Authenticated\n"
],
"name": "stdout"
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "cMa6SVLgp9wD",
"colab_type": "text"
},
"source": [
"# Pulling data for one store. \n",
"This dataset has quite a few dimensions, however, we will focus on just part for now which is just one store and for sales that have occured after 1st Jan 2018"
]
},
{
"cell_type": "code",
"metadata": {
"id": "qeVGiMch8Wnb",
"colab_type": "code",
"colab": {}
},
"source": [
"%%bigquery --project bold-sorter-281506 df2 # bold-sorter-281506 df2 is the project id ; df2 is the dataframe name\n",
"SELECT *\n",
"FROM `bigquery-public-data.iowa_liquor_sales.sales`\n",
"where store_number = '2633'\n",
"and date > '2018-01-01'"
],
"execution_count": 4,
"outputs": []
},
{
"cell_type": "markdown",
"metadata": {
"id": "W3hSsmL0qOsj",
"colab_type": "text"
},
"source": [
"# Using a direct link\n",
"A version of this dataset is also saved on my google drive. We can use it to pull the dataset\n"
]
},
{
"cell_type": "code",
"metadata": {
"id": "jCqoAXcjISWe",
"colab_type": "code",
"colab": {}
},
"source": [
"import pandas as pd\n",
"\n",
"url = 'https://drive.google.com/file/d/1g3UG_SWLEqn4rMuYCpTHqPlF0vnIDRDB/view?usp=sharing'\n",
"path = 'https://drive.google.com/uc?export=download&id='+url.split('/')[-2]\n",
"df2 = pd.read_csv(path)"
],
"execution_count": 2,
"outputs": []
},
{
"cell_type": "code",
"metadata": {
"id": "dMhpB4RxIp7i",
"colab_type": "code",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 37
},
"outputId": "212b9ba2-d2aa-4518-b853-b9dc18ed74bd"
},
"source": [
"path #save this path, just in case"
],
"execution_count": 3,
"outputs": [
{
"output_type": "execute_result",
"data": {
"application/vnd.google.colaboratory.intrinsic+json": {
"type": "string"
},
"text/plain": [
"'https://drive.google.com/uc?export=download&id=1g3UG_SWLEqn4rMuYCpTHqPlF0vnIDRDB'"
]
},
"metadata": {
"tags": []
},
"execution_count": 3
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "9js2qCkSq5Dd",
"colab_type": "text"
},
"source": [
"# Data Overview"
]
},
{
"cell_type": "code",
"metadata": {
"id": "sUNtTaXH_zod",
"colab_type": "code",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 394
},
"outputId": "53af867d-3d65-4bdf-909f-7ef50ff396ee"
},
"source": [
"df2.head(5)"
],
"execution_count": 4,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"| \n", " | invoice_and_item_number | \n", "date | \n", "store_number | \n", "store_name | \n", "address | \n", "city | \n", "zip_code | \n", "store_location | \n", "county_number | \n", "county | \n", "category | \n", "category_name | \n", "vendor_number | \n", "vendor_name | \n", "item_number | \n", "item_description | \n", "pack | \n", "bottle_volume_ml | \n", "state_bottle_cost | \n", "state_bottle_retail | \n", "bottles_sold | \n", "sale_dollars | \n", "volume_sold_liters | \n", "volume_sold_gallons | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "INV-19309700006 | \n", "2019-05-13 | \n", "2633 | \n", "Hy-Vee #3 / BDI / Des Moines | \n", "3221 SE 14th St | \n", "Des Moines | \n", "50320 | \n", "POINT (-93.596754 41.554101) | \n", "77 | \n", "POLK | \n", "1012300.0 | \n", "Single Malt Scotch | \n", "266 | \n", "Edrington Group USA LLC | \n", "5486 | \n", "Macallan 12 Yr Single Malt Scotch | \n", "12 | \n", "750 | \n", "34.99 | \n", "52.49 | \n", "84 | \n", "4409.16 | \n", "63.0 | \n", "16.64 | \n", "
| 1 | \n", "INV-15347200002 | \n", "2018-10-29 | \n", "2633 | \n", "Hy-Vee #3 / BDI / Des Moines | \n", "3221 SE 14th St | \n", "Des Moines | \n", "50320 | \n", "POINT (-93.596754 41.554101) | \n", "77 | \n", "POLK | \n", "1011600.0 | \n", "Straight Rye Whiskies | \n", "214 | \n", "GoAmericaGo Beverages LLC | \n", "27145 | \n", "WhistlePig Old World 12YR | \n", "6 | \n", "750 | \n", "64.17 | \n", "96.26 | \n", "30 | \n", "2887.80 | \n", "22.5 | \n", "5.94 | \n", "
| 2 | \n", "INV-11117400006 | \n", "2018-03-26 | \n", "2633 | \n", "Hy-Vee #3 / BDI / Des Moines | \n", "3221 SE 14th St | \n", "Des Moines | \n", "50320 | \n", "POINT (-93.596754 41.554101) | \n", "77 | \n", "POLK | \n", "1901200.0 | \n", "Special Order Items | \n", "459 | \n", "SURVILLE ENTERPRISES CORP | \n", "904955 | \n", "1921 Tequila Reposado | \n", "6 | \n", "750 | \n", "26.50 | \n", "39.75 | \n", "12 | \n", "477.00 | \n", "9.0 | \n", "2.38 | \n", "
| 3 | \n", "INV-10206700012 | \n", "2018-02-05 | \n", "2633 | \n", "Hy-Vee #3 / BDI / Des Moines | \n", "3221 SE 14th St | \n", "Des Moines | \n", "50320 | \n", "POINT (-93.596754 41.554101) | \n", "77 | \n", "POLK | \n", "1012300.0 | \n", "Single Malt Scotch | \n", "266 | \n", "Edrington Group USA LLC | \n", "5486 | \n", "Macallan 12 Yr Single Malt Scotch | \n", "12 | \n", "750 | \n", "34.99 | \n", "52.49 | \n", "12 | \n", "566.88 | \n", "9.0 | \n", "2.38 | \n", "
| 4 | \n", "INV-11743500040 | \n", "2018-04-26 | \n", "2633 | \n", "Hy-Vee #3 / BDI / Des Moines | \n", "3221 SE 14th St | \n", "Des Moines | \n", "50320 | \n", "POINT (-93.596754 41.554101) | \n", "77 | \n", "POLK | \n", "1011600.0 | \n", "Straight Rye Whiskies | \n", "306 | \n", "MISSISSIPPI RIVER DISTIL | \n", "27027 | \n", "Cody Road Rye | \n", "6 | \n", "750 | \n", "19.17 | \n", "28.76 | \n", "6 | \n", "172.56 | \n", "4.5 | \n", "1.19 | \n", "
| \n", " | date | \n", "sale_dollars | \n", "
|---|---|---|
| 50522 | \n", "2019-12-09 | \n", "1379.88 | \n", "
| 50523 | \n", "2019-11-25 | \n", "148.50 | \n", "
| 50524 | \n", "2019-10-24 | \n", "119.28 | \n", "
| 50525 | \n", "2019-10-17 | \n", "119.28 | \n", "
| 50526 | \n", "2019-10-21 | \n", "279.00 | \n", "
| \n", " | dayofweek | \n", "quarter | \n", "month | \n", "year | \n", "dayofyear | \n", "dayofmonth | \n", "weekofyear | \n", "flag | \n", "sale_dollars | \n", "
|---|---|---|---|---|---|---|---|---|---|
| date | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
| 2020-06-09 | \n", "1 | \n", "2 | \n", "6 | \n", "2020 | \n", "161 | \n", "9 | \n", "24 | \n", "1 | \n", "2588.94 | \n", "
| 2020-06-11 | \n", "3 | \n", "2 | \n", "6 | \n", "2020 | \n", "163 | \n", "11 | \n", "24 | \n", "1 | \n", "69550.07 | \n", "
| 2020-06-12 | \n", "4 | \n", "2 | \n", "6 | \n", "2020 | \n", "164 | \n", "12 | \n", "24 | \n", "1 | \n", "3011.43 | \n", "
| 2020-06-15 | \n", "0 | \n", "2 | \n", "6 | \n", "2020 | \n", "167 | \n", "15 | \n", "25 | \n", "1 | \n", "157158.24 | \n", "
| Description | Value | |
|---|---|---|
| 0 | \n", "session_id | \n", "7424 | \n", "
| 1 | \n", "Transform Target | \n", "True | \n", "
| 2 | \n", "Transform Target Method | \n", "yeo-johnson | \n", "
| 3 | \n", "Original Data | \n", "(385, 9) | \n", "
| 4 | \n", "Missing Values | \n", "False | \n", "
| 5 | \n", "Numeric Features | \n", "0 | \n", "
| 6 | \n", "Categorical Features | \n", "8 | \n", "
| 7 | \n", "Ordinal Features | \n", "False | \n", "
| 8 | \n", "High Cardinality Features | \n", "False | \n", "
| 9 | \n", "High Cardinality Method | \n", "None | \n", "
| 10 | \n", "Sampled Data | \n", "(385, 9) | \n", "
| 11 | \n", "Transformed Train Set | \n", "(269, 185) | \n", "
| 12 | \n", "Transformed Test Set | \n", "(116, 185) | \n", "
| 13 | \n", "Numeric Imputer | \n", "mean | \n", "
| 14 | \n", "Categorical Imputer | \n", "constant | \n", "
| 15 | \n", "Normalize | \n", "False | \n", "
| 16 | \n", "Normalize Method | \n", "None | \n", "
| 17 | \n", "Transformation | \n", "True | \n", "
| 18 | \n", "Transformation Method | \n", "yeo-johnson | \n", "
| 19 | \n", "PCA | \n", "False | \n", "
| 20 | \n", "PCA Method | \n", "None | \n", "
| 21 | \n", "PCA Components | \n", "None | \n", "
| 22 | \n", "Ignore Low Variance | \n", "False | \n", "
| 23 | \n", "Combine Rare Levels | \n", "True | \n", "
| 24 | \n", "Rare Level Threshold | \n", "0.100000 | \n", "
| 25 | \n", "Numeric Binning | \n", "False | \n", "
| 26 | \n", "Remove Outliers | \n", "False | \n", "
| 27 | \n", "Outliers Threshold | \n", "None | \n", "
| 28 | \n", "Remove Multicollinearity | \n", "True | \n", "
| 29 | \n", "Multicollinearity Threshold | \n", "0.950000 | \n", "
| 30 | \n", "Clustering | \n", "False | \n", "
| 31 | \n", "Clustering Iteration | \n", "None | \n", "
| 32 | \n", "Polynomial Features | \n", "False | \n", "
| 33 | \n", "Polynomial Degree | \n", "None | \n", "
| 34 | \n", "Trignometry Features | \n", "False | \n", "
| 35 | \n", "Polynomial Threshold | \n", "None | \n", "
| 36 | \n", "Group Features | \n", "False | \n", "
| 37 | \n", "Feature Selection | \n", "False | \n", "
| 38 | \n", "Features Selection Threshold | \n", "None | \n", "
| 39 | \n", "Feature Interaction | \n", "False | \n", "
| 40 | \n", "Feature Ratio | \n", "False | \n", "
| 41 | \n", "Interaction Threshold | \n", "None | \n", "
| MAE | MSE | RMSE | R2 | RMSLE | MAPE | |
|---|---|---|---|---|---|---|
| 0 | \n", "27679.6948 | \n", "2264608200.9779 | \n", "47587.8997 | \n", "0.1911 | \n", "1.5253 | \n", "2.2537 | \n", "
| 1 | \n", "20146.7760 | \n", "1059222094.4910 | \n", "32545.6924 | \n", "0.4035 | \n", "1.8166 | \n", "7.3706 | \n", "
| 2 | \n", "22913.6495 | \n", "1294520352.8960 | \n", "35979.4435 | \n", "0.6390 | \n", "1.4485 | \n", "4.7131 | \n", "
| 3 | \n", "26302.5325 | \n", "1491153629.4319 | \n", "38615.4584 | \n", "0.4787 | \n", "1.3046 | \n", "2.7212 | \n", "
| 4 | \n", "12672.3047 | \n", "290505824.6281 | \n", "17044.2314 | \n", "0.9023 | \n", "0.4905 | \n", "0.2488 | \n", "
| 5 | \n", "22265.6809 | \n", "1132222959.3479 | \n", "33648.5209 | \n", "0.5073 | \n", "1.3927 | \n", "4.4580 | \n", "
| 6 | \n", "30089.5524 | \n", "1691057520.9404 | \n", "41122.4698 | \n", "0.2322 | \n", "1.2405 | \n", "1.7433 | \n", "
| 7 | \n", "12221.3108 | \n", "292726304.6515 | \n", "17109.2462 | \n", "0.8936 | \n", "2.2399 | \n", "22.8773 | \n", "
| 8 | \n", "14928.2425 | \n", "446448142.5014 | \n", "21129.3195 | \n", "0.8614 | \n", "2.1695 | \n", "43.4240 | \n", "
| 9 | \n", "23426.3357 | \n", "1138782924.7624 | \n", "33745.8579 | \n", "0.7069 | \n", "1.4152 | \n", "5.9508 | \n", "
| Mean | \n", "21264.6080 | \n", "1110124795.4628 | \n", "31852.8140 | \n", "0.5816 | \n", "1.5043 | \n", "9.5761 | \n", "
| SD | \n", "5914.5261 | \n", "602808627.2661 | \n", "9773.5888 | \n", "0.2490 | \n", "0.4736 | \n", "12.8039 | \n", "
| MAE | MSE | RMSE | R2 | RMSLE | MAPE | |
|---|---|---|---|---|---|---|
| 0 | \n", "27525.6125 | \n", "2188265059.7911 | \n", "46778.8955 | \n", "0.2184 | \n", "1.5539 | \n", "3.3718 | \n", "
| 1 | \n", "18019.6723 | \n", "863400098.0486 | \n", "29383.6706 | \n", "0.5138 | \n", "1.8434 | \n", "9.8548 | \n", "
| 2 | \n", "20623.1988 | \n", "999423968.3243 | \n", "31613.6674 | \n", "0.7213 | \n", "1.3855 | \n", "5.2175 | \n", "
| 3 | \n", "25424.1035 | \n", "1381560599.9128 | \n", "37169.3503 | \n", "0.5170 | \n", "1.2760 | \n", "4.4262 | \n", "
| 4 | \n", "18984.4180 | \n", "714664998.4672 | \n", "26733.2190 | \n", "0.7597 | \n", "0.4317 | \n", "0.3100 | \n", "
| 5 | \n", "23495.2458 | \n", "1221173459.3436 | \n", "34945.2924 | \n", "0.4686 | \n", "1.3011 | \n", "4.6471 | \n", "
| 6 | \n", "28569.3458 | \n", "1518469599.4612 | \n", "38967.5455 | \n", "0.3106 | \n", "1.0935 | \n", "1.9208 | \n", "
| 7 | \n", "14249.2330 | \n", "440531493.3635 | \n", "20988.8421 | \n", "0.8398 | \n", "2.2965 | \n", "24.1798 | \n", "
| 8 | \n", "14287.6710 | \n", "393175643.5341 | \n", "19828.6571 | \n", "0.8779 | \n", "2.1633 | \n", "39.8652 | \n", "
| 9 | \n", "23791.5429 | \n", "1120916367.6505 | \n", "33480.0891 | \n", "0.7115 | \n", "1.3428 | \n", "4.9723 | \n", "
| Mean | \n", "21497.0044 | \n", "1084158128.7897 | \n", "31988.9229 | \n", "0.5939 | \n", "1.4688 | \n", "9.8766 | \n", "
| SD | \n", "4844.7420 | \n", "509941405.2227 | \n", "7801.7268 | \n", "0.2117 | \n", "0.5118 | \n", "11.8484 | \n", "
| \n", " | Model | \n", "MAE | \n", "MSE | \n", "RMSE | \n", "R2 | \n", "RMSLE | \n", "MAPE | \n", "
|---|---|---|---|---|---|---|---|
| 0 | \n", "Light Gradient Boosting Machine | \n", "22274.3454 | \n", "1.252090e+09 | \n", "35384.8774 | \n", "0.5623 | \n", "1.4822 | \n", "0 8.186057\n", "dtype: float64 | \n", "
| \n", " | Model | \n", "MAE | \n", "MSE | \n", "RMSE | \n", "R2 | \n", "RMSLE | \n", "MAPE | \n", "
|---|---|---|---|---|---|---|---|
| 0 | \n", "Light Gradient Boosting Machine | \n", "21132.048 | \n", "1.118844e+09 | \n", "33449.1286 | \n", "0.6089 | \n", "1.4375 | \n", "0 7.273443\n", "dtype: float64 | \n", "
| MAE | MSE | RMSE | R2 | RMSLE | MAPE | |
|---|---|---|---|---|---|---|
| 0 | \n", "26204.8845 | \n", "2194178302.1632 | \n", "46842.0570 | \n", "0.2163 | \n", "1.6064 | \n", "2.1330 | \n", "
| 1 | \n", "24156.1229 | \n", "1460002937.0579 | \n", "38209.9848 | \n", "0.1778 | \n", "1.9453 | \n", "11.8847 | \n", "
| 2 | \n", "26934.1278 | \n", "1459559865.2131 | \n", "38204.1865 | \n", "0.5929 | \n", "1.7032 | \n", "3.4440 | \n", "
| 3 | \n", "28300.8083 | \n", "1661870492.5534 | \n", "40766.0458 | \n", "0.4190 | \n", "1.3617 | \n", "2.0544 | \n", "
| 4 | \n", "14078.1126 | \n", "373011178.3488 | \n", "19313.4973 | \n", "0.8746 | \n", "0.9034 | \n", "0.3158 | \n", "
| 5 | \n", "23892.8310 | \n", "1239245903.1661 | \n", "35202.9246 | \n", "0.4608 | \n", "1.4607 | \n", "4.3862 | \n", "
| 6 | \n", "29783.0525 | \n", "1726573549.1814 | \n", "41552.0583 | \n", "0.2161 | \n", "1.2092 | \n", "2.3582 | \n", "
| 7 | \n", "10645.6674 | \n", "240928405.1008 | \n", "15521.8686 | \n", "0.9124 | \n", "2.1513 | \n", "8.1955 | \n", "
| 8 | \n", "14011.3135 | \n", "355327621.4132 | \n", "18850.1358 | \n", "0.8897 | \n", "2.0924 | \n", "35.1778 | \n", "
| 9 | \n", "21220.0470 | \n", "952218812.1188 | \n", "30858.0429 | \n", "0.7549 | \n", "1.3684 | \n", "4.9820 | \n", "
| Mean | \n", "21922.6967 | \n", "1166291706.6317 | \n", "32532.0802 | \n", "0.5514 | \n", "1.5802 | \n", "7.4932 | \n", "
| SD | \n", "6376.3570 | \n", "631089607.8990 | \n", "10390.1620 | \n", "0.2797 | \n", "0.3795 | \n", "9.7712 | \n", "
| MAE | MSE | RMSE | R2 | RMSLE | MAPE | |
|---|---|---|---|---|---|---|
| 0 | \n", "26273.0689 | \n", "2123700307.0776 | \n", "46083.6230 | \n", "0.2414 | \n", "1.5490 | \n", "1.9877 | \n", "
| 1 | \n", "19837.2453 | \n", "1133550913.4282 | \n", "33668.2479 | \n", "0.3616 | \n", "1.8145 | \n", "8.1207 | \n", "
| 2 | \n", "23571.7193 | \n", "1107879591.3639 | \n", "33284.8252 | \n", "0.6910 | \n", "1.3199 | \n", "4.6199 | \n", "
| 3 | \n", "24291.6852 | \n", "1290276880.1814 | \n", "35920.4243 | \n", "0.5489 | \n", "1.2278 | \n", "3.9043 | \n", "
| 4 | \n", "15501.2957 | \n", "507780986.5664 | \n", "22533.9962 | \n", "0.8292 | \n", "0.5135 | \n", "0.3012 | \n", "
| 5 | \n", "20724.9844 | \n", "1196060866.1864 | \n", "34584.1129 | \n", "0.4795 | \n", "1.2372 | \n", "2.2119 | \n", "
| 6 | \n", "30832.8317 | \n", "1721788508.9333 | \n", "41494.4395 | \n", "0.2183 | \n", "1.1698 | \n", "2.0790 | \n", "
| 7 | \n", "10463.0900 | \n", "221820014.4671 | \n", "14893.6233 | \n", "0.9194 | \n", "2.1726 | \n", "11.6417 | \n", "
| 8 | \n", "14531.6365 | \n", "395795499.5931 | \n", "19894.6098 | \n", "0.8771 | \n", "2.0696 | \n", "27.9784 | \n", "
| 9 | \n", "23860.4352 | \n", "1212252856.1683 | \n", "34817.4217 | \n", "0.6880 | \n", "1.2720 | \n", "3.8714 | \n", "
| Mean | \n", "20988.7992 | \n", "1091090642.3966 | \n", "31717.5324 | \n", "0.5855 | \n", "1.4346 | \n", "6.6716 | \n", "
| SD | \n", "5784.8870 | \n", "557748900.8410 | \n", "9224.3581 | \n", "0.2436 | \n", "0.4632 | \n", "7.7717 | \n", "
| \n", " | Model | \n", "MAE | \n", "MSE | \n", "RMSE | \n", "R2 | \n", "RMSLE | \n", "MAPE | \n", "
|---|---|---|---|---|---|---|---|
| 0 | \n", "Voting Regressor | \n", "22782.1274 | \n", "1.257876e+09 | \n", "35466.5436 | \n", "0.5603 | \n", "1.5146 | \n", "0 7.618574\n", "dtype: float64 | \n", "
| \n", " | dayofweek | \n", "quarter | \n", "month | \n", "year | \n", "dayofyear | \n", "dayofmonth | \n", "weekofyear | \n", "flag | \n", "sale_dollars | \n", "Label | \n", "
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1 | \n", "2 | \n", "6 | \n", "2020 | \n", "168 | \n", "16 | \n", "25 | \n", "1 | \n", "1376.22 | \n", "5256.0 | \n", "
| 1 | \n", "3 | \n", "2 | \n", "6 | \n", "2020 | \n", "170 | \n", "18 | \n", "25 | \n", "1 | \n", "77424.58 | \n", "53005.0 | \n", "
| 2 | \n", "4 | \n", "2 | \n", "6 | \n", "2020 | \n", "171 | \n", "19 | \n", "25 | \n", "1 | \n", "226.68 | \n", "5157.0 | \n", "
| 3 | \n", "0 | \n", "2 | \n", "6 | \n", "2020 | \n", "174 | \n", "22 | \n", "26 | \n", "1 | \n", "97385.87 | \n", "58606.0 | \n", "
| 4 | \n", "2 | \n", "2 | \n", "6 | \n", "2020 | \n", "176 | \n", "24 | \n", "26 | \n", "1 | \n", "3810.90 | \n", "7859.0 | \n", "
| \n", " | dayofweek | \n", "quarter | \n", "month | \n", "year | \n", "dayofyear | \n", "dayofmonth | \n", "weekofyear | \n", "flag | \n", "sale_dollars | \n", "Label | \n", "
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1 | \n", "2 | \n", "6 | \n", "2020 | \n", "168 | \n", "16 | \n", "25 | \n", "1 | \n", "1376.22 | \n", "0.0 | \n", "
| 1 | \n", "3 | \n", "2 | \n", "6 | \n", "2020 | \n", "170 | \n", "18 | \n", "25 | \n", "1 | \n", "77424.58 | \n", "0.0 | \n", "
| 2 | \n", "4 | \n", "2 | \n", "6 | \n", "2020 | \n", "171 | \n", "19 | \n", "25 | \n", "1 | \n", "226.68 | \n", "0.0 | \n", "
| 3 | \n", "0 | \n", "2 | \n", "6 | \n", "2020 | \n", "174 | \n", "22 | \n", "26 | \n", "1 | \n", "97385.87 | \n", "0.0 | \n", "