{ "cells": [ { "cell_type": "code", "execution_count": 178, "id": "23983c15", "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "import seaborn as sns\n", "import matplotlib.pyplot as plt" ] }, { "cell_type": "code", "execution_count": 179, "id": "75d122bb", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
| \n", " | city | \n", "store_name | \n", "manufacturer | \n", "brand | \n", "class | \n", "size | \n", "sku | \n", "price_bracket | \n", "year | \n", "month | \n", "value_sales | \n", "volume_sales | \n", "average_price | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "AL BAHA | \n", "HM No 57296 GS-CENTER-AL BAHA MAIN RD AL BAHA | \n", "NOVA FOODS | \n", "LARA | \n", "COCONUT | \n", "0.75L | \n", "LARA COCONUT 0.75L TWIN PACK | \n", "21-30 | \n", "2024 | \n", "12 | \n", "830.86 | \n", "30.1 | \n", "27.6 | \n", "
| 1 | \n", "AL KHARJ | \n", "HM No 55697 GS-CENTER-AL KHARJ MAIN RD AL K... | \n", "PALM & GRAIN GROUP | \n", "NAJMA | \n", "CANOLA | \n", "0.5L | \n", "NAJMA CANOLA 0.5L TWIN PACK | \n", "41-50 | \n", "2024 | \n", "10 | \n", "373.10 | \n", "9.1 | \n", "41.0 | \n", "
| 2 | \n", "RIYADH | \n", "HM No 86781 GS-CENTER-RIYADH MAIN RD RIYADH | \n", "AL HILAL INDUSTRIES | \n", "BAYTNA | \n", "SUNFLOWER | \n", "0.75L | \n", "BAYTNA SUNFLOWER 0.75L ECO | \n", "101+ | \n", "2023 | \n", "1 | \n", "171.70 | \n", "1.7 | \n", "101.0 | \n", "
| 3 | \n", "DAMMAM | \n", "HM No 95753 GS-CENTER-DAMMAM MAIN RD DAMMAM | \n", "PALM & GRAIN GROUP | \n", "NOUR | \n", "CORN | \n", "0.6L | \n", "NOUR CORN 0.6L TWIN PACK | \n", "61-70 | \n", "2022 | \n", "2 | \n", "1226.10 | \n", "20.1 | \n", "61.0 | \n", "
| 4 | \n", "JAZAN | \n", "HM No 56338 GS-CENTER-JAZAN MAIN RD JAZAN | \n", "DESERT SUN CO | \n", "NOUR | \n", "VEGETABLE | \n", "1L | \n", "NOUR VEGETABLE 1L | \n", "81-90 | \n", "2024 | \n", "2 | \n", "996.30 | \n", "12.3 | \n", "81.0 | \n", "
| \n", " | year | \n", "month | \n", "value_sales | \n", "volume_sales | \n", "average_price | \n", "
|---|---|---|---|---|---|
| count | \n", "2000.000000 | \n", "2000.000000 | \n", "2000.000000 | \n", "2000.000000 | \n", "2000.000000 | \n", "
| mean | \n", "2022.990500 | \n", "6.639500 | \n", "614.839355 | \n", "9.972100 | \n", "60.990230 | \n", "
| std | \n", "0.820211 | \n", "3.468942 | \n", "750.794991 | \n", "9.862369 | \n", "29.457029 | \n", "
| min | \n", "2022.000000 | \n", "1.000000 | \n", "6.960000 | \n", "0.500000 | \n", "11.000000 | \n", "
| 25% | \n", "2022.000000 | \n", "4.000000 | \n", "132.000000 | \n", "2.900000 | \n", "37.337500 | \n", "
| 50% | \n", "2023.000000 | \n", "7.000000 | \n", "368.320000 | \n", "7.000000 | \n", "61.000000 | \n", "
| 75% | \n", "2024.000000 | \n", "10.000000 | \n", "794.100000 | \n", "13.800000 | \n", "81.000000 | \n", "
| max | \n", "2024.000000 | \n", "12.000000 | \n", "6253.200000 | \n", "81.700000 | \n", "140.000000 | \n", "
| \n", " | city | \n", "store_name | \n", "manufacturer | \n", "brand | \n", "class | \n", "size | \n", "sku | \n", "price_bracket | \n", "year | \n", "month | \n", "value_sales | \n", "volume_sales | \n", "average_price | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "AL BAHA | \n", "HM No 57296 GS-CENTER-AL BAHA MAIN RD AL BAHA | \n", "NOVA FOODS | \n", "LARA | \n", "COCONUT | \n", "0.75 | \n", "LARA COCONUT 0.75L TWIN PACK | \n", "21-30 | \n", "2024 | \n", "12 | \n", "830.86 | \n", "30.1 | \n", "27.6 | \n", "
| 1 | \n", "AL KHARJ | \n", "HM No 55697 GS-CENTER-AL KHARJ MAIN RD AL K... | \n", "PALM & GRAIN GROUP | \n", "NAJMA | \n", "CANOLA | \n", "0.50 | \n", "NAJMA CANOLA 0.5L TWIN PACK | \n", "41-50 | \n", "2024 | \n", "10 | \n", "373.10 | \n", "9.1 | \n", "41.0 | \n", "
| 2 | \n", "RIYADH | \n", "HM No 86781 GS-CENTER-RIYADH MAIN RD RIYADH | \n", "AL HILAL INDUSTRIES | \n", "BAYTNA | \n", "SUNFLOWER | \n", "0.75 | \n", "BAYTNA SUNFLOWER 0.75L ECO | \n", "101+ | \n", "2023 | \n", "1 | \n", "171.70 | \n", "1.7 | \n", "101.0 | \n", "
| 3 | \n", "DAMMAM | \n", "HM No 95753 GS-CENTER-DAMMAM MAIN RD DAMMAM | \n", "PALM & GRAIN GROUP | \n", "NOUR | \n", "CORN | \n", "0.60 | \n", "NOUR CORN 0.6L TWIN PACK | \n", "61-70 | \n", "2022 | \n", "2 | \n", "1226.10 | \n", "20.1 | \n", "61.0 | \n", "
| 4 | \n", "JAZAN | \n", "HM No 56338 GS-CENTER-JAZAN MAIN RD JAZAN | \n", "DESERT SUN CO | \n", "NOUR | \n", "VEGETABLE | \n", "1.00 | \n", "NOUR VEGETABLE 1L | \n", "81-90 | \n", "2024 | \n", "2 | \n", "996.30 | \n", "12.3 | \n", "81.0 | \n", "
| \n", " | city | \n", "store_name | \n", "manufacturer | \n", "brand | \n", "class | \n", "size | \n", "sku | \n", "price_bracket | \n", "year | \n", "month | \n", "value_sales | \n", "volume_sales | \n", "average_price | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "AL BAHA | \n", "HM No 57296 GS-CENTER-AL BAHA MAIN RD AL BAHA | \n", "NOVA FOODS | \n", "LARA | \n", "COCONUT | \n", "0.75 | \n", "LARA COCONUT 0.75L TWIN PACK | \n", "21-30 | \n", "2024 | \n", "12 | \n", "830.86 | \n", "30.1 | \n", "27.6 | \n", "
| 1 | \n", "AL KHARJ | \n", "HM No 55697 GS-CENTER-AL KHARJ MAIN RD AL K... | \n", "PALM & GRAIN GROUP | \n", "NAJMA | \n", "CANOLA | \n", "0.50 | \n", "NAJMA CANOLA 0.5L TWIN PACK | \n", "41-50 | \n", "2024 | \n", "10 | \n", "373.10 | \n", "9.1 | \n", "41.0 | \n", "
| 2 | \n", "RIYADH | \n", "HM No 86781 GS-CENTER-RIYADH MAIN RD RIYADH | \n", "AL HILAL INDUSTRIES | \n", "BAYTNA | \n", "SUNFLOWER | \n", "0.75 | \n", "BAYTNA SUNFLOWER 0.75L ECO | \n", "101+ | \n", "2023 | \n", "1 | \n", "171.70 | \n", "1.7 | \n", "101.0 | \n", "
| 3 | \n", "DAMMAM | \n", "HM No 95753 GS-CENTER-DAMMAM MAIN RD DAMMAM | \n", "PALM & GRAIN GROUP | \n", "NOUR | \n", "CORN | \n", "0.60 | \n", "NOUR CORN 0.6L TWIN PACK | \n", "61-70 | \n", "2022 | \n", "2 | \n", "1226.10 | \n", "20.1 | \n", "61.0 | \n", "
| 4 | \n", "Other | \n", "HM No 56338 GS-CENTER-JAZAN MAIN RD JAZAN | \n", "DESERT SUN CO | \n", "NOUR | \n", "VEGETABLE | \n", "1.00 | \n", "NOUR VEGETABLE 1L | \n", "81-90 | \n", "2024 | \n", "2 | \n", "996.30 | \n", "12.3 | \n", "81.0 | \n", "
| \n", " | city | \n", "store_name | \n", "manufacturer | \n", "brand | \n", "class | \n", "size | \n", "sku | \n", "price_bracket | \n", "year | \n", "month | \n", "value_sales | \n", "volume_sales | \n", "average_price | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "AL BAHA | \n", "HM No 57296 GS-CENTER-AL BAHA MAIN RD AL BAHA | \n", "NOVA FOODS | \n", "LARA | \n", "COCONUT | \n", "0.75 | \n", "LARA COCONUT 0.75L TWIN PACK | \n", "21-30 | \n", "2024 | \n", "12 | \n", "830.86 | \n", "30.1 | \n", "27.6 | \n", "
| 1 | \n", "AL KHARJ | \n", "HM No 55697 GS-CENTER-AL KHARJ MAIN RD AL K... | \n", "PALM & GRAIN GROUP | \n", "NAJMA | \n", "CANOLA | \n", "0.50 | \n", "NAJMA CANOLA 0.5L TWIN PACK | \n", "41-50 | \n", "2024 | \n", "10 | \n", "373.10 | \n", "9.1 | \n", "41.0 | \n", "
| 2 | \n", "RIYADH | \n", "HM No 86781 GS-CENTER-RIYADH MAIN RD RIYADH | \n", "AL HILAL INDUSTRIES | \n", "BAYTNA | \n", "SUNFLOWER | \n", "0.75 | \n", "BAYTNA SUNFLOWER 0.75L ECO | \n", "101-151 | \n", "2023 | \n", "1 | \n", "171.70 | \n", "1.7 | \n", "101.0 | \n", "
| 3 | \n", "DAMMAM | \n", "HM No 95753 GS-CENTER-DAMMAM MAIN RD DAMMAM | \n", "PALM & GRAIN GROUP | \n", "NOUR | \n", "CORN | \n", "0.60 | \n", "NOUR CORN 0.6L TWIN PACK | \n", "61-70 | \n", "2022 | \n", "2 | \n", "1226.10 | \n", "20.1 | \n", "61.0 | \n", "
| 4 | \n", "Other | \n", "HM No 56338 GS-CENTER-JAZAN MAIN RD JAZAN | \n", "DESERT SUN CO | \n", "NOUR | \n", "VEGETABLE | \n", "1.00 | \n", "NOUR VEGETABLE 1L | \n", "81-90 | \n", "2024 | \n", "2 | \n", "996.30 | \n", "12.3 | \n", "81.0 | \n", "
| \n", " | city | \n", "manufacturer | \n", "brand | \n", "class | \n", "size | \n", "year | \n", "month | \n", "value_sales | \n", "volume_sales | \n", "average_price | \n", "price_min | \n", "price_max | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "AL BAHA | \n", "NOVA FOODS | \n", "LARA | \n", "COCONUT | \n", "0.75 | \n", "2024 | \n", "12 | \n", "830.86 | \n", "30.1 | \n", "27.6 | \n", "21 | \n", "30 | \n", "
| 1 | \n", "AL KHARJ | \n", "PALM & GRAIN GROUP | \n", "NAJMA | \n", "CANOLA | \n", "0.50 | \n", "2024 | \n", "10 | \n", "373.10 | \n", "9.1 | \n", "41.0 | \n", "41 | \n", "50 | \n", "
| 2 | \n", "RIYADH | \n", "AL HILAL INDUSTRIES | \n", "BAYTNA | \n", "SUNFLOWER | \n", "0.75 | \n", "2023 | \n", "1 | \n", "171.70 | \n", "1.7 | \n", "101.0 | \n", "101 | \n", "151 | \n", "
| 3 | \n", "DAMMAM | \n", "PALM & GRAIN GROUP | \n", "NOUR | \n", "CORN | \n", "0.60 | \n", "2022 | \n", "2 | \n", "1226.10 | \n", "20.1 | \n", "61.0 | \n", "61 | \n", "70 | \n", "
| 4 | \n", "Other | \n", "DESERT SUN CO | \n", "NOUR | \n", "VEGETABLE | \n", "1.00 | \n", "2024 | \n", "2 | \n", "996.30 | \n", "12.3 | \n", "81.0 | \n", "81 | \n", "90 | \n", "
ColumnTransformer(transformers=[('one_pip_col',\n",
" Pipeline(steps=[('encoder',\n",
" OneHotEncoder(handle_unknown='ignore'))]),\n",
" ['city', 'manufacturer', 'brand', 'class']),\n",
" ('num_pip_col',\n",
" Pipeline(steps=[('scaler', StandardScaler())]),\n",
" ['month', 'price_min', 'price_max']),\n",
" ('ske_pip_col',\n",
" Pipeline(steps=[('ske',\n",
" FunctionTransformer(func=<ufunc 'log1p'>)),\n",
" ('scaler', StandardScaler())]),\n",
" ['size', 'volume_sales'])])In a Jupyter environment, please rerun this cell to show the HTML representation or trust the notebook. ['city', 'manufacturer', 'brand', 'class']
['month', 'price_min', 'price_max']
| \n", " | \n",
" \n",
" copy\n",
" copy: bool, default=True If False, try to avoid a copy and do inplace scaling instead. This is not guaranteed to always work inplace; e.g. if the data is not a NumPy array or scipy.sparse CSR matrix, a copy may still be returned.\n", " \n", " | \n",
" True | \n", "
| \n", " | \n",
" \n",
" with_mean\n",
" with_mean: bool, default=True If True, center the data before scaling. This does not work (and will raise an exception) when attempted on sparse matrices, because centering them entails building a dense matrix which in common use cases is likely to be too large to fit in memory.\n", " \n", " | \n",
" True | \n", "
| \n", " | \n",
" \n",
" with_std\n",
" with_std: bool, default=True If True, scale the data to unit variance (or equivalently, unit standard deviation).\n", " \n", " | \n",
" True | \n", "
['size', 'volume_sales']
| \n", " | \n",
" \n",
" copy\n",
" copy: bool, default=True If False, try to avoid a copy and do inplace scaling instead. This is not guaranteed to always work inplace; e.g. if the data is not a NumPy array or scipy.sparse CSR matrix, a copy may still be returned.\n", " \n", " | \n",
" True | \n", "
| \n", " | \n",
" \n",
" with_mean\n",
" with_mean: bool, default=True If True, center the data before scaling. This does not work (and will raise an exception) when attempted on sparse matrices, because centering them entails building a dense matrix which in common use cases is likely to be too large to fit in memory.\n", " \n", " | \n",
" True | \n", "
| \n", " | \n",
" \n",
" with_std\n",
" with_std: bool, default=True If True, scale the data to unit variance (or equivalently, unit standard deviation).\n", " \n", " | \n",
" True | \n", "
| \n", " | Name | \n", "accuracy_score | \n", "
|---|---|---|
| 0 | \n", "Decision Tree | \n", "0.964259 | \n", "
| 1 | \n", "Random Forest | \n", "0.987792 | \n", "
| 2 | \n", "Extra Trees | \n", "0.987004 | \n", "
| 3 | \n", "Gradient Boosting | \n", "0.988802 | \n", "
| 4 | \n", "K-Neighbors | \n", "0.758445 | \n", "
| 5 | \n", "XGBoost | \n", "0.988465 | \n", "
| 6 | \n", "AdaBoost | \n", "0.918885 | \n", "