{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "CC - Module Python pour le Machine Learning Bekombo IABD B3 Soir" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "import numpy as np\n", "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "import seaborn as sns\n", "import pycaret as py" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | Store | \n", "Date | \n", "Daily_Sales | \n", "Holiday_Flag | \n", "Temperature | \n", "Fuel_Price | \n", "CPI | \n", "Unemployment | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "1 | \n", "2010-05-02 | \n", "1643690.90 | \n", "0 | \n", "42.31 | \n", "2.572 | \n", "211.096358 | \n", "8.106 | \n", "
1 | \n", "1 | \n", "2010-12-02 | \n", "1641957.44 | \n", "1 | \n", "38.51 | \n", "2.548 | \n", "211.242170 | \n", "8.106 | \n", "
2 | \n", "1 | \n", "2010-02-19 | \n", "1611968.17 | \n", "0 | \n", "39.93 | \n", "2.514 | \n", "211.289143 | \n", "8.106 | \n", "
3 | \n", "1 | \n", "2010-02-26 | \n", "1409727.59 | \n", "0 | \n", "46.63 | \n", "2.561 | \n", "211.319643 | \n", "8.106 | \n", "
4 | \n", "1 | \n", "2010-05-03 | \n", "1554806.68 | \n", "0 | \n", "46.50 | \n", "2.625 | \n", "211.350143 | \n", "8.106 | \n", "
\n", " | Store | \n", "Date | \n", "Daily_Sales | \n", "Holiday_Flag | \n", "Temperature | \n", "Fuel_Price | \n", "CPI | \n", "Unemployment | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "1 | \n", "2010-05-02 | \n", "1643690.90 | \n", "0 | \n", "42.31 | \n", "2.572 | \n", "211.096358 | \n", "8.106 | \n", "
1 | \n", "1 | \n", "2010-12-02 | \n", "1641957.44 | \n", "1 | \n", "38.51 | \n", "2.548 | \n", "211.242170 | \n", "8.106 | \n", "
2 | \n", "1 | \n", "2010-02-19 | \n", "1611968.17 | \n", "0 | \n", "39.93 | \n", "2.514 | \n", "211.289143 | \n", "8.106 | \n", "
3 | \n", "1 | \n", "2010-02-26 | \n", "1409727.59 | \n", "0 | \n", "46.63 | \n", "2.561 | \n", "211.319643 | \n", "8.106 | \n", "
4 | \n", "1 | \n", "2010-05-03 | \n", "1554806.68 | \n", "0 | \n", "46.50 | \n", "2.625 | \n", "211.350143 | \n", "8.106 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
6430 | \n", "45 | \n", "2012-09-28 | \n", "713173.95 | \n", "0 | \n", "64.88 | \n", "3.997 | \n", "192.013558 | \n", "8.684 | \n", "
6431 | \n", "45 | \n", "2012-05-10 | \n", "733455.07 | \n", "0 | \n", "64.89 | \n", "3.985 | \n", "192.170412 | \n", "8.667 | \n", "
6432 | \n", "45 | \n", "2012-12-10 | \n", "734464.36 | \n", "0 | \n", "54.47 | \n", "4.000 | \n", "192.327265 | \n", "8.667 | \n", "
6433 | \n", "45 | \n", "2012-10-19 | \n", "718125.53 | \n", "0 | \n", "56.47 | \n", "3.969 | \n", "192.330854 | \n", "8.667 | \n", "
6434 | \n", "45 | \n", "2012-10-26 | \n", "760281.43 | \n", "0 | \n", "58.85 | \n", "3.882 | \n", "192.308899 | \n", "8.667 | \n", "
6435 rows × 8 columns
\n", "\n", " | Store | \n", "Daily_Sales | \n", "Holiday_Flag | \n", "Temperature | \n", "Fuel_Price | \n", "CPI | \n", "Unemployment | \n", "
---|---|---|---|---|---|---|---|
count | \n", "6435.000000 | \n", "6.435000e+03 | \n", "6435.000000 | \n", "6435.000000 | \n", "6435.000000 | \n", "6435.000000 | \n", "6435.000000 | \n", "
mean | \n", "23.000000 | \n", "1.046965e+06 | \n", "0.069930 | \n", "60.663782 | \n", "3.358607 | \n", "171.578394 | \n", "7.999151 | \n", "
std | \n", "12.988182 | \n", "5.643666e+05 | \n", "0.255049 | \n", "18.444933 | \n", "0.459020 | \n", "39.356712 | \n", "1.875885 | \n", "
min | \n", "1.000000 | \n", "2.099862e+05 | \n", "0.000000 | \n", "-2.060000 | \n", "2.472000 | \n", "126.064000 | \n", "3.879000 | \n", "
25% | \n", "12.000000 | \n", "5.533501e+05 | \n", "0.000000 | \n", "47.460000 | \n", "2.933000 | \n", "131.735000 | \n", "6.891000 | \n", "
50% | \n", "23.000000 | \n", "9.607460e+05 | \n", "0.000000 | \n", "62.670000 | \n", "3.445000 | \n", "182.616521 | \n", "7.874000 | \n", "
75% | \n", "34.000000 | \n", "1.420159e+06 | \n", "0.000000 | \n", "74.940000 | \n", "3.735000 | \n", "212.743293 | \n", "8.622000 | \n", "
max | \n", "45.000000 | \n", "3.818686e+06 | \n", "1.000000 | \n", "100.140000 | \n", "4.468000 | \n", "227.232807 | \n", "14.313000 | \n", "
\n", " | Store | \n", "Date | \n", "Daily_Sales | \n", "Holiday_Flag | \n", "Temperature | \n", "Fuel_Price | \n", "CPI | \n", "Unemployment | \n", "Year | \n", "Month | \n", "Day | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "1 | \n", "2010-05-02 | \n", "1643690.90 | \n", "0 | \n", "42.31 | \n", "2.572 | \n", "211.096358 | \n", "8.106 | \n", "2010 | \n", "5 | \n", "2 | \n", "
1 | \n", "1 | \n", "2010-12-02 | \n", "1641957.44 | \n", "1 | \n", "38.51 | \n", "2.548 | \n", "211.242170 | \n", "8.106 | \n", "2010 | \n", "12 | \n", "2 | \n", "
2 | \n", "1 | \n", "2010-02-19 | \n", "1611968.17 | \n", "0 | \n", "39.93 | \n", "2.514 | \n", "211.289143 | \n", "8.106 | \n", "2010 | \n", "2 | \n", "19 | \n", "
3 | \n", "1 | \n", "2010-02-26 | \n", "1409727.59 | \n", "0 | \n", "46.63 | \n", "2.561 | \n", "211.319643 | \n", "8.106 | \n", "2010 | \n", "2 | \n", "26 | \n", "
4 | \n", "1 | \n", "2010-05-03 | \n", "1554806.68 | \n", "0 | \n", "46.50 | \n", "2.625 | \n", "211.350143 | \n", "8.106 | \n", "2010 | \n", "5 | \n", "3 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
6430 | \n", "45 | \n", "2012-09-28 | \n", "713173.95 | \n", "0 | \n", "64.88 | \n", "3.997 | \n", "192.013558 | \n", "8.684 | \n", "2012 | \n", "9 | \n", "28 | \n", "
6431 | \n", "45 | \n", "2012-05-10 | \n", "733455.07 | \n", "0 | \n", "64.89 | \n", "3.985 | \n", "192.170412 | \n", "8.667 | \n", "2012 | \n", "5 | \n", "10 | \n", "
6432 | \n", "45 | \n", "2012-12-10 | \n", "734464.36 | \n", "0 | \n", "54.47 | \n", "4.000 | \n", "192.327265 | \n", "8.667 | \n", "2012 | \n", "12 | \n", "10 | \n", "
6433 | \n", "45 | \n", "2012-10-19 | \n", "718125.53 | \n", "0 | \n", "56.47 | \n", "3.969 | \n", "192.330854 | \n", "8.667 | \n", "2012 | \n", "10 | \n", "19 | \n", "
6434 | \n", "45 | \n", "2012-10-26 | \n", "760281.43 | \n", "0 | \n", "58.85 | \n", "3.882 | \n", "192.308899 | \n", "8.667 | \n", "2012 | \n", "10 | \n", "26 | \n", "
6435 rows × 11 columns
\n", "\n", " | Store | \n", "Daily_Sales | \n", "Holiday_Flag | \n", "Temperature | \n", "Fuel_Price | \n", "CPI | \n", "Unemployment | \n", "Year | \n", "Month | \n", "Day | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "1 | \n", "1643690.90 | \n", "0 | \n", "42.31 | \n", "2.572 | \n", "211.096358 | \n", "8.106 | \n", "2010 | \n", "5 | \n", "2 | \n", "
1 | \n", "1 | \n", "1641957.44 | \n", "1 | \n", "38.51 | \n", "2.548 | \n", "211.242170 | \n", "8.106 | \n", "2010 | \n", "12 | \n", "2 | \n", "
2 | \n", "1 | \n", "1611968.17 | \n", "0 | \n", "39.93 | \n", "2.514 | \n", "211.289143 | \n", "8.106 | \n", "2010 | \n", "2 | \n", "19 | \n", "
3 | \n", "1 | \n", "1409727.59 | \n", "0 | \n", "46.63 | \n", "2.561 | \n", "211.319643 | \n", "8.106 | \n", "2010 | \n", "2 | \n", "26 | \n", "
4 | \n", "1 | \n", "1554806.68 | \n", "0 | \n", "46.50 | \n", "2.625 | \n", "211.350143 | \n", "8.106 | \n", "2010 | \n", "5 | \n", "3 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
6430 | \n", "45 | \n", "713173.95 | \n", "0 | \n", "64.88 | \n", "3.997 | \n", "192.013558 | \n", "8.684 | \n", "2012 | \n", "9 | \n", "28 | \n", "
6431 | \n", "45 | \n", "733455.07 | \n", "0 | \n", "64.89 | \n", "3.985 | \n", "192.170412 | \n", "8.667 | \n", "2012 | \n", "5 | \n", "10 | \n", "
6432 | \n", "45 | \n", "734464.36 | \n", "0 | \n", "54.47 | \n", "4.000 | \n", "192.327265 | \n", "8.667 | \n", "2012 | \n", "12 | \n", "10 | \n", "
6433 | \n", "45 | \n", "718125.53 | \n", "0 | \n", "56.47 | \n", "3.969 | \n", "192.330854 | \n", "8.667 | \n", "2012 | \n", "10 | \n", "19 | \n", "
6434 | \n", "45 | \n", "760281.43 | \n", "0 | \n", "58.85 | \n", "3.882 | \n", "192.308899 | \n", "8.667 | \n", "2012 | \n", "10 | \n", "26 | \n", "
6435 rows × 10 columns
\n", "\n", " | Description | \n", "Value | \n", "
---|---|---|
0 | \n", "Session id | \n", "8701 | \n", "
1 | \n", "Target | \n", "Daily_Sales | \n", "
2 | \n", "Target type | \n", "Regression | \n", "
3 | \n", "Original data shape | \n", "(6435, 10) | \n", "
4 | \n", "Transformed data shape | \n", "(6435, 10) | \n", "
5 | \n", "Transformed train set shape | \n", "(4504, 10) | \n", "
6 | \n", "Transformed test set shape | \n", "(1931, 10) | \n", "
7 | \n", "Numeric features | \n", "9 | \n", "
8 | \n", "Preprocess | \n", "True | \n", "
9 | \n", "Imputation type | \n", "simple | \n", "
10 | \n", "Numeric imputation | \n", "mean | \n", "
11 | \n", "Categorical imputation | \n", "mode | \n", "
12 | \n", "Normalize | \n", "True | \n", "
13 | \n", "Normalize method | \n", "minmax | \n", "
14 | \n", "Fold Generator | \n", "KFold | \n", "
15 | \n", "Fold Number | \n", "10 | \n", "
16 | \n", "CPU Jobs | \n", "-1 | \n", "
17 | \n", "Use GPU | \n", "False | \n", "
18 | \n", "Log Experiment | \n", "False | \n", "
19 | \n", "Experiment Name | \n", "reg-default-name | \n", "
20 | \n", "USI | \n", "b442 | \n", "
XGBRegressor(base_score=0.5, booster='gbtree', callbacks=None,\n", " colsample_bylevel=1, colsample_bynode=1, colsample_bytree=1,\n", " early_stopping_rounds=None, enable_categorical=False,\n", " eval_metric=None, gamma=0, gpu_id=-1, grow_policy='depthwise',\n", " importance_type=None, interaction_constraints='',\n", " learning_rate=0.300000012, max_bin=256, max_cat_to_onehot=4,\n", " max_delta_step=0, max_depth=6, max_leaves=0, min_child_weight=1,\n", " missing=nan, monotone_constraints='()', n_estimators=100,\n", " n_jobs=-1, num_parallel_tree=1, predictor='auto',\n", " random_state=8701, reg_alpha=0, reg_lambda=1, ...)In a Jupyter environment, please rerun this cell to show the HTML representation or trust the notebook.
XGBRegressor(base_score=0.5, booster='gbtree', callbacks=None,\n", " colsample_bylevel=1, colsample_bynode=1, colsample_bytree=1,\n", " early_stopping_rounds=None, enable_categorical=False,\n", " eval_metric=None, gamma=0, gpu_id=-1, grow_policy='depthwise',\n", " importance_type=None, interaction_constraints='',\n", " learning_rate=0.300000012, max_bin=256, max_cat_to_onehot=4,\n", " max_delta_step=0, max_depth=6, max_leaves=0, min_child_weight=1,\n", " missing=nan, monotone_constraints='()', n_estimators=100,\n", " n_jobs=-1, num_parallel_tree=1, predictor='auto',\n", " random_state=8701, reg_alpha=0, reg_lambda=1, ...)
\n", " | \n", " | \n", " |
---|---|---|
\n", " | \n", " | \n", " |
Initiated | \n", ". . . . . . . . . . . . . . . . . . | \n", "18:08:49 | \n", "
Status | \n", ". . . . . . . . . . . . . . . . . . | \n", "Selecting Estimator | \n", "
Estimator | \n", ". . . . . . . . . . . . . . . . . . | \n", "Compiling Library | \n", "
\n", " | MAE | \n", "MSE | \n", "RMSE | \n", "R2 | \n", "RMSLE | \n", "MAPE | \n", "
---|---|---|---|---|---|---|
Fold | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
0 | \n", "52721.7383 | \n", "7094510592.0000 | \n", "84228.9141 | \n", "0.9757 | \n", "0.1059 | \n", "0.0613 | \n", "
1 | \n", "50161.0195 | \n", "7583405056.0000 | \n", "87082.7500 | \n", "0.9753 | \n", "0.0860 | \n", "0.0557 | \n", "
2 | \n", "62588.3398 | \n", "11270412288.0000 | \n", "106162.1953 | \n", "0.9644 | \n", "0.0956 | \n", "0.0628 | \n", "
3 | \n", "54049.5859 | \n", "8522477568.0000 | \n", "92317.2656 | \n", "0.9736 | \n", "0.0835 | \n", "0.0559 | \n", "
4 | \n", "50440.2930 | \n", "6355119616.0000 | \n", "79719.0078 | \n", "0.9795 | \n", "0.0985 | \n", "0.0568 | \n", "
5 | \n", "55670.2578 | \n", "9608662016.0000 | \n", "98023.7812 | \n", "0.9691 | \n", "0.1001 | \n", "0.0625 | \n", "
6 | \n", "51194.2266 | \n", "6248470016.0000 | \n", "79047.2656 | \n", "0.9809 | \n", "0.0878 | \n", "0.0569 | \n", "
7 | \n", "52440.3828 | \n", "6610165248.0000 | \n", "81302.9219 | \n", "0.9787 | \n", "0.0849 | \n", "0.0570 | \n", "
8 | \n", "53432.1250 | \n", "6348822016.0000 | \n", "79679.4922 | \n", "0.9779 | \n", "0.1839 | \n", "0.0577 | \n", "
9 | \n", "47908.0195 | \n", "5803044352.0000 | \n", "76177.7188 | \n", "0.9821 | \n", "0.0788 | \n", "0.0527 | \n", "
Mean | \n", "53060.5988 | \n", "7544508876.8000 | \n", "86374.1312 | \n", "0.9757 | \n", "0.1005 | \n", "0.0579 | \n", "
Std | \n", "3801.4441 | \n", "1665330173.2997 | \n", "9166.1474 | \n", "0.0052 | \n", "0.0290 | \n", "0.0031 | \n", "
\n", " | MAE | \n", "MSE | \n", "RMSE | \n", "R2 | \n", "RMSLE | \n", "MAPE | \n", "
---|---|---|---|---|---|---|
Fold | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
0 | \n", "72144.2344 | \n", "13923403776.0000 | \n", "117997.4766 | \n", "0.9524 | \n", "0.1232 | \n", "0.0855 | \n", "
1 | \n", "67364.0469 | \n", "13027191808.0000 | \n", "114136.7266 | \n", "0.9575 | \n", "0.1079 | \n", "0.0743 | \n", "
2 | \n", "78961.5078 | \n", "16434673664.0000 | \n", "128197.7891 | \n", "0.9482 | \n", "0.1132 | \n", "0.0808 | \n", "
3 | \n", "72114.8594 | \n", "16118704128.0000 | \n", "126959.4609 | \n", "0.9501 | \n", "0.1129 | \n", "0.0774 | \n", "
4 | \n", "63425.8203 | \n", "9442840576.0000 | \n", "97174.2812 | \n", "0.9695 | \n", "0.0970 | \n", "0.0695 | \n", "
5 | \n", "66351.4609 | \n", "13681622016.0000 | \n", "116968.4688 | \n", "0.9560 | \n", "0.1107 | \n", "0.0740 | \n", "
6 | \n", "58300.6836 | \n", "8188753920.0000 | \n", "90491.7344 | \n", "0.9750 | \n", "0.0904 | \n", "0.0624 | \n", "
7 | \n", "65851.5703 | \n", "10858310656.0000 | \n", "104203.2188 | \n", "0.9651 | \n", "0.1024 | \n", "0.0723 | \n", "
8 | \n", "63356.6562 | \n", "10729723904.0000 | \n", "103584.3828 | \n", "0.9626 | \n", "0.0931 | \n", "0.0660 | \n", "
9 | \n", "60723.4258 | \n", "10246772736.0000 | \n", "101226.3438 | \n", "0.9683 | \n", "0.0908 | \n", "0.0660 | \n", "
Mean | \n", "66859.4266 | \n", "12265199718.4000 | \n", "110093.9883 | \n", "0.9605 | \n", "0.1042 | \n", "0.0728 | \n", "
Std | \n", "5818.0686 | \n", "2656402186.3040 | \n", "12021.3874 | \n", "0.0086 | \n", "0.0106 | \n", "0.0068 | \n", "
XGBRegressor(base_score=0.5, booster='gbtree', callbacks=None,\n", " colsample_bylevel=1, colsample_bynode=1, colsample_bytree=1,\n", " early_stopping_rounds=None, enable_categorical=False,\n", " eval_metric=None, gamma=0, gpu_id=-1, grow_policy='depthwise',\n", " importance_type=None, interaction_constraints='',\n", " learning_rate=0.300000012, max_bin=256, max_cat_to_onehot=4,\n", " max_delta_step=0, max_depth=6, max_leaves=0, min_child_weight=1,\n", " missing=nan, monotone_constraints='()', n_estimators=100,\n", " n_jobs=-1, num_parallel_tree=1, predictor='auto',\n", " random_state=8701, reg_alpha=0, reg_lambda=1, ...)In a Jupyter environment, please rerun this cell to show the HTML representation or trust the notebook.
XGBRegressor(base_score=0.5, booster='gbtree', callbacks=None,\n", " colsample_bylevel=1, colsample_bynode=1, colsample_bytree=1,\n", " early_stopping_rounds=None, enable_categorical=False,\n", " eval_metric=None, gamma=0, gpu_id=-1, grow_policy='depthwise',\n", " importance_type=None, interaction_constraints='',\n", " learning_rate=0.300000012, max_bin=256, max_cat_to_onehot=4,\n", " max_delta_step=0, max_depth=6, max_leaves=0, min_child_weight=1,\n", " missing=nan, monotone_constraints='()', n_estimators=100,\n", " n_jobs=-1, num_parallel_tree=1, predictor='auto',\n", " random_state=8701, reg_alpha=0, reg_lambda=1, ...)
\n", " | Store | \n", "Daily_Sales | \n", "Holiday_Flag | \n", "Temperature | \n", "Fuel_Price | \n", "CPI | \n", "Unemployment | \n", "Year | \n", "Month | \n", "Day | \n", "
---|---|---|---|---|---|---|---|---|---|---|
34 | \n", "1 | \n", "1453329.50 | \n", "0 | \n", "71.89 | \n", "2.603 | \n", "211.671989 | \n", "7.8380 | \n", "2010 | \n", "1 | \n", "10 | \n", "
177 | \n", "2 | \n", "1827440.43 | \n", "0 | \n", "69.24 | \n", "2.603 | \n", "211.329874 | \n", "8.1630 | \n", "2010 | \n", "1 | \n", "10 | \n", "
320 | \n", "3 | \n", "358784.10 | \n", "0 | \n", "73.60 | \n", "2.603 | \n", "214.984655 | \n", "7.5640 | \n", "2010 | \n", "1 | \n", "10 | \n", "
463 | \n", "4 | \n", "1842821.02 | \n", "0 | \n", "63.96 | \n", "2.619 | \n", "126.234600 | \n", "7.1270 | \n", "2010 | \n", "1 | \n", "10 | \n", "
606 | \n", "5 | \n", "283178.12 | \n", "0 | \n", "71.10 | \n", "2.603 | \n", "212.226946 | \n", "6.7680 | \n", "2010 | \n", "1 | \n", "10 | \n", "
749 | \n", "6 | \n", "1328468.89 | \n", "0 | \n", "70.69 | \n", "2.603 | \n", "213.190713 | \n", "7.0070 | \n", "2010 | \n", "1 | \n", "10 | \n", "
892 | \n", "7 | \n", "448998.73 | \n", "0 | \n", "49.99 | \n", "2.759 | \n", "190.673824 | \n", "9.1370 | \n", "2010 | \n", "1 | \n", "10 | \n", "
1035 | \n", "8 | \n", "804105.49 | \n", "0 | \n", "68.70 | \n", "2.603 | \n", "215.031003 | \n", "6.4330 | \n", "2010 | \n", "1 | \n", "10 | \n", "
1178 | \n", "9 | \n", "495692.19 | \n", "0 | \n", "69.08 | \n", "2.603 | \n", "215.214134 | \n", "6.5600 | \n", "2010 | \n", "1 | \n", "10 | \n", "
1321 | \n", "10 | \n", "1645892.97 | \n", "0 | \n", "86.01 | \n", "3.001 | \n", "126.234600 | \n", "9.0030 | \n", "2010 | \n", "1 | \n", "10 | \n", "
1464 | \n", "11 | \n", "1182490.46 | \n", "0 | \n", "75.11 | \n", "2.603 | \n", "214.984655 | \n", "7.5640 | \n", "2010 | \n", "1 | \n", "10 | \n", "
1607 | \n", "12 | \n", "850936.26 | \n", "0 | \n", "85.20 | \n", "3.001 | \n", "126.234600 | \n", "11.2185 | \n", "2010 | \n", "1 | \n", "10 | \n", "
1750 | \n", "13 | \n", "1765584.48 | \n", "0 | \n", "68.74 | \n", "2.853 | \n", "126.234600 | \n", "7.7950 | \n", "2010 | \n", "1 | \n", "10 | \n", "
1893 | \n", "14 | \n", "1855703.66 | \n", "0 | \n", "70.58 | \n", "2.707 | \n", "182.716838 | \n", "8.7240 | \n", "2010 | \n", "1 | \n", "10 | \n", "
2036 | \n", "15 | \n", "566945.95 | \n", "0 | \n", "59.69 | \n", "2.840 | \n", "132.756800 | \n", "8.0670 | \n", "2010 | \n", "1 | \n", "10 | \n", "
2179 | \n", "16 | \n", "463977.54 | \n", "0 | \n", "59.39 | \n", "2.759 | \n", "190.673824 | \n", "6.9860 | \n", "2010 | \n", "1 | \n", "10 | \n", "
2322 | \n", "17 | \n", "829207.27 | \n", "0 | \n", "60.07 | \n", "2.853 | \n", "126.234600 | \n", "6.8850 | \n", "2010 | \n", "1 | \n", "10 | \n", "
2465 | \n", "18 | \n", "948977.50 | \n", "0 | \n", "67.76 | \n", "2.717 | \n", "132.756800 | \n", "9.3310 | \n", "2010 | \n", "1 | \n", "10 | \n", "
2608 | \n", "19 | \n", "1379456.30 | \n", "0 | \n", "59.91 | \n", "2.840 | \n", "132.756800 | \n", "8.0670 | \n", "2010 | \n", "1 | \n", "10 | \n", "
2751 | \n", "20 | \n", "1933719.21 | \n", "0 | \n", "61.08 | \n", "2.707 | \n", "204.885097 | \n", "7.4840 | \n", "2010 | \n", "1 | \n", "10 | \n", "
2894 | \n", "21 | \n", "677158.39 | \n", "0 | \n", "70.28 | \n", "2.603 | \n", "211.329874 | \n", "8.1630 | \n", "2010 | \n", "1 | \n", "10 | \n", "
3037 | \n", "22 | \n", "905987.17 | \n", "0 | \n", "69.31 | \n", "2.717 | \n", "136.629757 | \n", "8.5720 | \n", "2010 | \n", "1 | \n", "10 | \n", "
3180 | \n", "23 | \n", "1129909.44 | \n", "0 | \n", "62.07 | \n", "2.717 | \n", "132.756800 | \n", "5.2870 | \n", "2010 | \n", "1 | \n", "10 | \n", "
3323 | \n", "24 | \n", "1215273.20 | \n", "0 | \n", "66.88 | \n", "2.840 | \n", "132.756800 | \n", "8.2750 | \n", "2010 | \n", "1 | \n", "10 | \n", "
3466 | \n", "25 | \n", "658640.14 | \n", "0 | \n", "57.56 | \n", "2.707 | \n", "204.885097 | \n", "7.4840 | \n", "2010 | \n", "1 | \n", "10 | \n", "
3609 | \n", "26 | \n", "923221.52 | \n", "0 | \n", "57.80 | \n", "2.717 | \n", "132.756800 | \n", "8.1490 | \n", "2010 | \n", "1 | \n", "10 | \n", "
3752 | \n", "27 | \n", "1543532.83 | \n", "0 | \n", "70.19 | \n", "2.840 | \n", "136.629757 | \n", "8.0210 | \n", "2010 | \n", "1 | \n", "10 | \n", "
3895 | \n", "28 | \n", "1203080.41 | \n", "0 | \n", "85.20 | \n", "3.001 | \n", "126.234600 | \n", "11.2185 | \n", "2010 | \n", "1 | \n", "10 | \n", "
4038 | \n", "29 | \n", "474698.01 | \n", "0 | \n", "69.31 | \n", "2.717 | \n", "132.756800 | \n", "10.5240 | \n", "2010 | \n", "1 | \n", "10 | \n", "
4181 | \n", "30 | \n", "445475.30 | \n", "0 | \n", "70.28 | \n", "2.603 | \n", "211.329874 | \n", "8.1630 | \n", "2010 | \n", "1 | \n", "10 | \n", "
4324 | \n", "31 | \n", "1213981.64 | \n", "0 | \n", "70.28 | \n", "2.603 | \n", "211.329874 | \n", "8.1630 | \n", "2010 | \n", "1 | \n", "10 | \n", "
4467 | \n", "32 | \n", "1061089.56 | \n", "0 | \n", "66.14 | \n", "2.759 | \n", "190.673824 | \n", "9.1370 | \n", "2010 | \n", "1 | \n", "10 | \n", "
4610 | \n", "33 | \n", "224294.39 | \n", "0 | \n", "91.45 | \n", "3.001 | \n", "126.234600 | \n", "9.2650 | \n", "2010 | \n", "1 | \n", "10 | \n", "
4753 | \n", "34 | \n", "865709.11 | \n", "0 | \n", "70.13 | \n", "2.619 | \n", "126.234600 | \n", "10.2100 | \n", "2010 | \n", "1 | \n", "10 | \n", "
4896 | \n", "35 | \n", "771065.21 | \n", "0 | \n", "70.19 | \n", "2.707 | \n", "136.629757 | \n", "8.7630 | \n", "2010 | \n", "1 | \n", "10 | \n", "
5039 | \n", "36 | \n", "422169.47 | \n", "0 | \n", "74.66 | \n", "2.567 | \n", "210.440443 | \n", "8.4760 | \n", "2010 | \n", "1 | \n", "10 | \n", "
5182 | \n", "37 | \n", "529877.93 | \n", "0 | \n", "74.66 | \n", "2.603 | \n", "210.440443 | \n", "8.4760 | \n", "2010 | \n", "1 | \n", "10 | \n", "
5325 | \n", "38 | \n", "360256.58 | \n", "0 | \n", "85.20 | \n", "3.001 | \n", "126.234600 | \n", "11.2185 | \n", "2010 | \n", "1 | \n", "10 | \n", "
5468 | \n", "39 | \n", "1219583.91 | \n", "0 | \n", "72.74 | \n", "2.603 | \n", "210.440443 | \n", "8.4760 | \n", "2010 | \n", "1 | \n", "10 | \n", "
5611 | \n", "40 | \n", "891152.33 | \n", "0 | \n", "62.01 | \n", "2.717 | \n", "132.756800 | \n", "5.2870 | \n", "2010 | \n", "1 | \n", "10 | \n", "
5754 | \n", "41 | \n", "1109216.35 | \n", "0 | \n", "62.67 | \n", "2.759 | \n", "190.673824 | \n", "7.5080 | \n", "2010 | \n", "1 | \n", "10 | \n", "
5897 | \n", "42 | \n", "481523.93 | \n", "0 | \n", "86.01 | \n", "3.001 | \n", "126.234600 | \n", "9.0030 | \n", "2010 | \n", "1 | \n", "10 | \n", "
6040 | \n", "43 | \n", "657108.77 | \n", "0 | \n", "77.93 | \n", "2.603 | \n", "203.593429 | \n", "10.2100 | \n", "2010 | \n", "1 | \n", "10 | \n", "
6183 | \n", "44 | \n", "300152.45 | \n", "0 | \n", "68.74 | \n", "2.853 | \n", "126.234600 | \n", "7.6100 | \n", "2010 | \n", "1 | \n", "10 | \n", "
6326 | \n", "45 | \n", "690007.76 | \n", "0 | \n", "70.58 | \n", "2.707 | \n", "182.716838 | \n", "8.7240 | \n", "2010 | \n", "1 | \n", "10 | \n", "