{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Exogenous Variables and Time Series Forecasting" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "[](https://nbviewer.org/github/gautamnaik1994/SalesForecasting_ML_CaseStudy/blob/main/notebooks/modelling/02.SARIMAX.ipynb?flush_cache=true)" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import plotly.io as pio\n", "pio.renderers.default = \"colab+notebook_connected+vscode\"\n", "\n", "import pandas as pd\n", "import numpy as np\n", "import duckdb as db\n", "import matplotlib.pyplot as plt\n", "import plotly.express as px\n", "import plotly.graph_objects as go\n", "import optuna\n", "import warnings\n", "\n", "warnings.filterwarnings('ignore')\n", "\n", "from IPython.display import display, Markdown\n", "from statsforecast import StatsForecast\n", "from statsforecast.models import AutoARIMA, MSTL, MFLES, AutoMFLES\n", "# ConformalIntervals\n", "from statsforecast.models import ConformalIntervals\n", "# mape\n", "from sklearn.metrics import mean_absolute_percentage_error\n", "# sarimax\n", "from statsmodels.tsa.statespace.sarimax import SARIMAX\n", "\n", "optuna.logging.set_verbosity(optuna.logging.ERROR)" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "orig = pd.read_parquet(\"../../data/processed/train_enhanced.parquet\")\n", "train_agg = pd.read_parquet(\"../../data/processed/train_agg.parquet\")\n", "train_region_code_agg = pd.read_parquet(\"../../data/processed/train_region_code_agg.parquet\")\n", "holiday_df= pd.read_csv(\"../../data/processed/holidays.csv\")" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Region Sales Forecasting" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
| \n", " | Date | \n", "Region_Code | \n", "Total_Sales | \n", "Avg_Sales | \n", "Total_Orders | \n", "Avg_Orders | \n", "Num_Stores | \n", "Holiday | \n", "Total_Discounts | \n", "
|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "2018-01-01 | \n", "R4 | \n", "2286812 | \n", "45736 | \n", "2914 | \n", "58 | \n", "50 | \n", "1 | \n", "50 | \n", "
| 1 | \n", "2018-01-01 | \n", "R2 | \n", "4436859 | \n", "42256 | \n", "5644 | \n", "54 | \n", "105 | \n", "1 | \n", "105 | \n", "
| 2 | \n", "2018-01-01 | \n", "R3 | \n", "3527439 | \n", "41017 | \n", "4599 | \n", "53 | \n", "86 | \n", "1 | \n", "86 | \n", "
| 3 | \n", "2018-01-01 | \n", "R1 | \n", "5094374 | \n", "41084 | \n", "6509 | \n", "52 | \n", "124 | \n", "1 | \n", "124 | \n", "
| 4 | \n", "2018-01-02 | \n", "R4 | \n", "2545119 | \n", "50902 | \n", "3057 | \n", "61 | \n", "50 | \n", "0 | \n", "50 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 2059 | \n", "2019-05-30 | \n", "R4 | \n", "1966320 | \n", "39326 | \n", "2829 | \n", "57 | \n", "50 | \n", "0 | \n", "4 | \n", "
| 2060 | \n", "2019-05-31 | \n", "R2 | \n", "4351299 | \n", "41441 | \n", "6411 | \n", "61 | \n", "105 | \n", "1 | \n", "11 | \n", "
| 2061 | \n", "2019-05-31 | \n", "R4 | \n", "1909319 | \n", "38186 | \n", "2746 | \n", "55 | \n", "50 | \n", "1 | \n", "1 | \n", "
| 2062 | \n", "2019-05-31 | \n", "R1 | \n", "5900798 | \n", "47587 | \n", "9433 | \n", "76 | \n", "124 | \n", "1 | \n", "18 | \n", "
| 2063 | \n", "2019-05-31 | \n", "R3 | \n", "3440408 | \n", "40005 | \n", "5012 | \n", "58 | \n", "86 | \n", "1 | \n", "9 | \n", "
2064 rows × 9 columns
\n", "| \n", " | unique_id | \n", "ds | \n", "y | \n", "Holiday | \n", "Total_Discounts | \n", "idx | \n", "
|---|---|---|---|---|---|---|
| 0 | \n", "R4 | \n", "2018-01-01 | \n", "2286812 | \n", "1 | \n", "50 | \n", "1 | \n", "
| 1 | \n", "R2 | \n", "2018-01-01 | \n", "4436859 | \n", "1 | \n", "105 | \n", "1 | \n", "
| 2 | \n", "R3 | \n", "2018-01-01 | \n", "3527439 | \n", "1 | \n", "86 | \n", "1 | \n", "
| 3 | \n", "R1 | \n", "2018-01-01 | \n", "5094374 | \n", "1 | \n", "124 | \n", "1 | \n", "
| 4 | \n", "R4 | \n", "2018-01-02 | \n", "2545119 | \n", "0 | \n", "50 | \n", "2 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 2059 | \n", "R4 | \n", "2019-05-30 | \n", "1966320 | \n", "0 | \n", "4 | \n", "515 | \n", "
| 2061 | \n", "R4 | \n", "2019-05-31 | \n", "1909319 | \n", "1 | \n", "1 | \n", "516 | \n", "
| 2062 | \n", "R1 | \n", "2019-05-31 | \n", "5900798 | \n", "1 | \n", "18 | \n", "516 | \n", "
| 2060 | \n", "R2 | \n", "2019-05-31 | \n", "4351299 | \n", "1 | \n", "11 | \n", "516 | \n", "
| 2063 | \n", "R3 | \n", "2019-05-31 | \n", "3440408 | \n", "1 | \n", "9 | \n", "516 | \n", "
2064 rows × 6 columns
\n", "| \n", " | unique_id | \n", "ds | \n", "y | \n", "Holiday | \n", "Total_Discounts | \n", "idx | \n", "
|---|---|---|---|---|---|---|
| 0 | \n", "R4 | \n", "2018-01-01 | \n", "2286812 | \n", "1 | \n", "50 | \n", "1 | \n", "
| 1 | \n", "R2 | \n", "2018-01-01 | \n", "4436859 | \n", "1 | \n", "105 | \n", "1 | \n", "
| 2 | \n", "R3 | \n", "2018-01-01 | \n", "3527439 | \n", "1 | \n", "86 | \n", "1 | \n", "
| 3 | \n", "R1 | \n", "2018-01-01 | \n", "5094374 | \n", "1 | \n", "124 | \n", "1 | \n", "
| 4 | \n", "R4 | \n", "2018-01-02 | \n", "2545119 | \n", "0 | \n", "50 | \n", "2 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 1640 | \n", "R3 | \n", "2019-02-15 | \n", "3300873 | \n", "0 | \n", "73 | \n", "411 | \n", "
| 1644 | \n", "R2 | \n", "2019-02-16 | \n", "4485144 | \n", "0 | \n", "93 | \n", "412 | \n", "
| 1645 | \n", "R4 | \n", "2019-02-16 | \n", "2120472 | \n", "0 | \n", "49 | \n", "412 | \n", "
| 1646 | \n", "R1 | \n", "2019-02-16 | \n", "6426930 | \n", "0 | \n", "108 | \n", "412 | \n", "
| 1647 | \n", "R3 | \n", "2019-02-16 | \n", "3960552 | \n", "0 | \n", "76 | \n", "412 | \n", "
1648 rows × 6 columns
\n", "| \n", " | unique_id | \n", "ds | \n", "y | \n", "Holiday | \n", "Total_Discounts | \n", "idx | \n", "
|---|---|---|---|---|---|---|
| 1648 | \n", "R3 | \n", "2019-02-17 | \n", "4253736 | \n", "0 | \n", "83 | \n", "413 | \n", "
| 1649 | \n", "R1 | \n", "2019-02-17 | \n", "6858420 | \n", "0 | \n", "120 | \n", "413 | \n", "
| 1650 | \n", "R4 | \n", "2019-02-17 | \n", "2341383 | \n", "0 | \n", "49 | \n", "413 | \n", "
| 1651 | \n", "R2 | \n", "2019-02-17 | \n", "4888986 | \n", "0 | \n", "99 | \n", "413 | \n", "
| 1652 | \n", "R3 | \n", "2019-02-18 | \n", "3948027 | \n", "0 | \n", "78 | \n", "414 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 2059 | \n", "R4 | \n", "2019-05-30 | \n", "1966320 | \n", "0 | \n", "4 | \n", "515 | \n", "
| 2061 | \n", "R4 | \n", "2019-05-31 | \n", "1909319 | \n", "1 | \n", "1 | \n", "516 | \n", "
| 2062 | \n", "R1 | \n", "2019-05-31 | \n", "5900798 | \n", "1 | \n", "18 | \n", "516 | \n", "
| 2060 | \n", "R2 | \n", "2019-05-31 | \n", "4351299 | \n", "1 | \n", "11 | \n", "516 | \n", "
| 2063 | \n", "R3 | \n", "2019-05-31 | \n", "3440408 | \n", "1 | \n", "9 | \n", "516 | \n", "
416 rows × 6 columns
\n", "| \n", " | unique_id | \n", "ds | \n", "AutoARIMA | \n", "AutoARIMA-lo-95 | \n", "AutoARIMA-hi-95 | \n", "MSTL | \n", "MSTL-lo-95 | \n", "MSTL-hi-95 | \n", "AutoMFLES | \n", "AutoMFLES-lo-95 | \n", "AutoMFLES-hi-95 | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "R1 | \n", "2019-02-17 | \n", "6666489.000 | \n", "4.967450e+06 | \n", "8365528.000 | \n", "7860963.500 | \n", "7.173004e+06 | \n", "8548923.000 | \n", "6284394.000 | \n", "5568465.000 | \n", "7000323.000 | \n", "
| 1 | \n", "R1 | \n", "2019-02-18 | \n", "6439762.000 | \n", "4.580992e+06 | \n", "8298532.500 | \n", "6418570.500 | \n", "5.809900e+06 | \n", "7027240.500 | \n", "6035970.500 | \n", "5626605.500 | \n", "6445336.000 | \n", "
| 2 | \n", "R1 | \n", "2019-02-19 | \n", "4717097.500 | \n", "2.828473e+06 | \n", "6605722.500 | \n", "3911237.750 | \n", "1.795879e+06 | \n", "6026596.500 | \n", "4297116.000 | \n", "1185046.375 | \n", "7409185.500 | \n", "
| 3 | \n", "R1 | \n", "2019-02-20 | \n", "5539322.500 | \n", "3.644876e+06 | \n", "7433769.500 | \n", "5014326.500 | \n", "3.016612e+06 | \n", "7012041.000 | \n", "5055353.000 | \n", "2069786.250 | \n", "8040920.000 | \n", "
| 4 | \n", "R1 | \n", "2019-02-21 | \n", "5380298.000 | \n", "3.484707e+06 | \n", "7275888.500 | \n", "4978095.000 | \n", "2.719740e+06 | \n", "7236449.000 | \n", "4924604.000 | \n", "1592243.250 | \n", "8256965.000 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 411 | \n", "R4 | \n", "2019-05-27 | \n", "2244195.000 | \n", "1.554406e+06 | \n", "2933983.750 | \n", "2056336.500 | \n", "1.980181e+06 | \n", "2132491.750 | \n", "1875758.875 | \n", "1646278.875 | \n", "2105238.750 | \n", "
| 412 | \n", "R4 | \n", "2019-05-28 | \n", "2234609.750 | \n", "1.544821e+06 | \n", "2924398.500 | \n", "1933951.875 | \n", "1.729963e+06 | \n", "2137941.000 | \n", "1820966.250 | \n", "1588354.000 | \n", "2053578.625 | \n", "
| 413 | \n", "R4 | \n", "2019-05-29 | \n", "2052491.625 | \n", "1.362703e+06 | \n", "2742280.250 | \n", "1975758.500 | \n", "1.717912e+06 | \n", "2233604.500 | \n", "1684806.250 | \n", "1307494.750 | \n", "2062117.875 | \n", "
| 414 | \n", "R4 | \n", "2019-05-30 | \n", "1860788.375 | \n", "1.171000e+06 | \n", "2550577.000 | \n", "1572959.375 | \n", "1.177561e+06 | \n", "1968357.625 | \n", "1647948.625 | \n", "1221317.625 | \n", "2074579.625 | \n", "
| 415 | \n", "R4 | \n", "2019-05-31 | \n", "1395954.375 | \n", "7.061657e+05 | \n", "2085743.125 | \n", "1374726.000 | \n", "9.185508e+05 | \n", "1830901.250 | \n", "1486565.500 | \n", "1341881.250 | \n", "1631249.875 | \n", "
416 rows × 11 columns
\n", "| \n", " | Date | \n", "Total_Sales | \n", "Avg_Sales | \n", "Total_Orders | \n", "Avg_Orders | \n", "Holiday | \n", "Total_Discounts | \n", "
|---|---|---|---|---|---|---|---|
| 0 | \n", "2018-01-01 | \n", "15345484 | \n", "42042 | \n", "19666 | \n", "54 | \n", "1 | \n", "365 | \n", "
| 1 | \n", "2018-01-02 | \n", "19592415 | \n", "53678 | \n", "25326 | \n", "69 | \n", "0 | \n", "365 | \n", "
| 2 | \n", "2018-01-03 | \n", "18652527 | \n", "51103 | \n", "24047 | \n", "66 | \n", "0 | \n", "365 | \n", "
| 3 | \n", "2018-01-04 | \n", "19956267 | \n", "54675 | \n", "25584 | \n", "70 | \n", "0 | \n", "364 | \n", "
| 4 | \n", "2018-01-05 | \n", "22902651 | \n", "62747 | \n", "28436 | \n", "78 | \n", "0 | \n", "364 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 511 | \n", "2019-05-27 | \n", "17197023 | \n", "47115 | \n", "25447 | \n", "70 | \n", "0 | \n", "321 | \n", "
| 512 | \n", "2019-05-28 | \n", "18652065 | \n", "51102 | \n", "27184 | \n", "74 | \n", "0 | \n", "319 | \n", "
| 513 | \n", "2019-05-29 | \n", "16213497 | \n", "44421 | \n", "24047 | \n", "66 | \n", "0 | \n", "193 | \n", "
| 514 | \n", "2019-05-30 | \n", "16082139 | \n", "44061 | \n", "24318 | \n", "67 | \n", "0 | \n", "76 | \n", "
| 515 | \n", "2019-05-31 | \n", "15601825 | \n", "42745 | \n", "23602 | \n", "65 | \n", "1 | \n", "39 | \n", "
516 rows × 7 columns
\n", "| \n", " | ds | \n", "y | \n", "Holiday | \n", "Total_Discounts | \n", "idx | \n", "unique_id | \n", "
|---|---|---|---|---|---|---|
| 0 | \n", "2018-01-01 | \n", "15345484 | \n", "1 | \n", "365 | \n", "1 | \n", "1 | \n", "
| 1 | \n", "2018-01-02 | \n", "19592415 | \n", "0 | \n", "365 | \n", "2 | \n", "1 | \n", "
| 2 | \n", "2018-01-03 | \n", "18652527 | \n", "0 | \n", "365 | \n", "3 | \n", "1 | \n", "
| 3 | \n", "2018-01-04 | \n", "19956267 | \n", "0 | \n", "364 | \n", "4 | \n", "1 | \n", "
| 4 | \n", "2018-01-05 | \n", "22902651 | \n", "0 | \n", "364 | \n", "5 | \n", "1 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 511 | \n", "2019-05-27 | \n", "17197023 | \n", "0 | \n", "321 | \n", "512 | \n", "1 | \n", "
| 512 | \n", "2019-05-28 | \n", "18652065 | \n", "0 | \n", "319 | \n", "513 | \n", "1 | \n", "
| 513 | \n", "2019-05-29 | \n", "16213497 | \n", "0 | \n", "193 | \n", "514 | \n", "1 | \n", "
| 514 | \n", "2019-05-30 | \n", "16082139 | \n", "0 | \n", "76 | \n", "515 | \n", "1 | \n", "
| 515 | \n", "2019-05-31 | \n", "15601825 | \n", "1 | \n", "39 | \n", "516 | \n", "1 | \n", "
516 rows × 6 columns
\n", "| \n", " | ds | \n", "y | \n", "Holiday | \n", "Total_Discounts | \n", "idx | \n", "unique_id | \n", "
|---|---|---|---|---|---|---|
| 0 | \n", "2018-01-01 | \n", "15345484 | \n", "1 | \n", "365 | \n", "1 | \n", "1 | \n", "
| 1 | \n", "2018-01-02 | \n", "19592415 | \n", "0 | \n", "365 | \n", "2 | \n", "1 | \n", "
| 2 | \n", "2018-01-03 | \n", "18652527 | \n", "0 | \n", "365 | \n", "3 | \n", "1 | \n", "
| 3 | \n", "2018-01-04 | \n", "19956267 | \n", "0 | \n", "364 | \n", "4 | \n", "1 | \n", "
| 4 | \n", "2018-01-05 | \n", "22902651 | \n", "0 | \n", "364 | \n", "5 | \n", "1 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 407 | \n", "2019-02-12 | \n", "12384495 | \n", "0 | \n", "7 | \n", "408 | \n", "1 | \n", "
| 408 | \n", "2019-02-13 | \n", "12457656 | \n", "0 | \n", "39 | \n", "409 | \n", "1 | \n", "
| 409 | \n", "2019-02-14 | \n", "13301838 | \n", "0 | \n", "139 | \n", "410 | \n", "1 | \n", "
| 410 | \n", "2019-02-15 | \n", "14306637 | \n", "0 | \n", "307 | \n", "411 | \n", "1 | \n", "
| 411 | \n", "2019-02-16 | \n", "16993098 | \n", "0 | \n", "326 | \n", "412 | \n", "1 | \n", "
412 rows × 6 columns
\n", "| \n", " | ds | \n", "y | \n", "Holiday | \n", "Total_Discounts | \n", "idx | \n", "unique_id | \n", "
|---|---|---|---|---|---|---|
| 412 | \n", "2019-02-17 | \n", "18342525 | \n", "0 | \n", "351 | \n", "413 | \n", "1 | \n", "
| 413 | \n", "2019-02-18 | \n", "16319103 | \n", "0 | \n", "319 | \n", "414 | \n", "1 | \n", "
| 414 | \n", "2019-02-19 | \n", "15816166 | \n", "1 | \n", "222 | \n", "415 | \n", "1 | \n", "
| 415 | \n", "2019-02-20 | \n", "12800094 | \n", "0 | \n", "59 | \n", "416 | \n", "1 | \n", "
| 416 | \n", "2019-02-21 | \n", "12383694 | \n", "0 | \n", "37 | \n", "417 | \n", "1 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 511 | \n", "2019-05-27 | \n", "17197023 | \n", "0 | \n", "321 | \n", "512 | \n", "1 | \n", "
| 512 | \n", "2019-05-28 | \n", "18652065 | \n", "0 | \n", "319 | \n", "513 | \n", "1 | \n", "
| 513 | \n", "2019-05-29 | \n", "16213497 | \n", "0 | \n", "193 | \n", "514 | \n", "1 | \n", "
| 514 | \n", "2019-05-30 | \n", "16082139 | \n", "0 | \n", "76 | \n", "515 | \n", "1 | \n", "
| 515 | \n", "2019-05-31 | \n", "15601825 | \n", "1 | \n", "39 | \n", "516 | \n", "1 | \n", "
104 rows × 6 columns
\n", "| \n", " | unique_id | \n", "ds | \n", "AutoARIMA | \n", "AutoARIMA-lo-95 | \n", "AutoARIMA-hi-95 | \n", "MSTL | \n", "MSTL-lo-95 | \n", "MSTL-hi-95 | \n", "AutoMFLES | \n", "AutoMFLES-lo-95 | \n", "AutoMFLES-hi-95 | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1 | \n", "2019-02-17 | \n", "17897164.0 | \n", "13301840.0 | \n", "22492488.0 | \n", "20815704.0 | \n", "18865470.0 | \n", "22765938.0 | \n", "16443518.0 | \n", "15116372.00 | \n", "17770664.0 | \n", "
| 1 | \n", "1 | \n", "2019-02-18 | \n", "17645540.0 | \n", "12640227.0 | \n", "22650854.0 | \n", "17287290.0 | \n", "15781578.0 | \n", "18793000.0 | \n", "16055208.0 | \n", "15050656.00 | \n", "17059760.0 | \n", "
| 2 | \n", "1 | \n", "2019-02-19 | \n", "13183467.0 | \n", "8105391.5 | \n", "18261542.0 | \n", "10942386.0 | \n", "5298980.0 | \n", "16585792.0 | \n", "11509044.0 | \n", "2970222.25 | \n", "20047866.0 | \n", "
| 3 | \n", "1 | \n", "2019-02-20 | \n", "14814651.0 | \n", "9723128.0 | \n", "19906174.0 | \n", "13533622.0 | \n", "8225240.0 | \n", "18842004.0 | \n", "12900191.0 | \n", "4727806.50 | \n", "21072574.0 | \n", "
| 4 | \n", "1 | \n", "2019-02-21 | \n", "14426889.0 | \n", "9332863.0 | \n", "19520914.0 | \n", "13593423.0 | \n", "7848842.5 | \n", "19338004.0 | \n", "12633228.0 | \n", "3807427.25 | \n", "21459028.0 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 99 | \n", "1 | \n", "2019-05-27 | \n", "17838166.0 | \n", "12724844.0 | \n", "22951490.0 | \n", "16683699.0 | \n", "16239398.0 | \n", "17128000.0 | \n", "16079478.0 | \n", "15046672.00 | \n", "17112284.0 | \n", "
| 100 | \n", "1 | \n", "2019-05-28 | \n", "17814770.0 | \n", "12701448.0 | \n", "22928094.0 | \n", "15773848.0 | \n", "14561388.0 | \n", "16986308.0 | \n", "16055208.0 | \n", "14594145.00 | \n", "17516272.0 | \n", "
| 101 | \n", "1 | \n", "2019-05-29 | \n", "16340833.0 | \n", "11227510.0 | \n", "21454156.0 | \n", "15926136.0 | \n", "13938983.0 | \n", "17913290.0 | \n", "14526238.0 | \n", "11550098.00 | \n", "17502378.0 | \n", "
| 102 | \n", "1 | \n", "2019-05-30 | \n", "14972177.0 | \n", "9858854.0 | \n", "20085500.0 | \n", "12472893.0 | \n", "9664525.0 | \n", "15281260.0 | \n", "13106480.0 | \n", "10257496.00 | \n", "15955465.0 | \n", "
| 103 | \n", "1 | \n", "2019-05-31 | \n", "11072638.0 | \n", "5959315.0 | \n", "16185961.0 | \n", "10983630.0 | \n", "7566960.5 | \n", "14400299.0 | \n", "9288397.0 | \n", "8639927.00 | \n", "9936868.0 | \n", "
104 rows × 11 columns
\n", "