{ "metadata": { "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.8.5-final" }, "orig_nbformat": 2, "kernelspec": { "name": "python3", "display_name": "Python 3", "language": "python" } }, "nbformat": 4, "nbformat_minor": 2, "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "X = pd.read_csv('xtraining_SC_GGP_AXA_FR.csv')\n", "y = pd.read_csv('ytraining_SC_GGP_AXA_FR.csv')\n", "Xscore = pd.read_csv('xscoring_SC_GGP_AXA_FR.csv')" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " target\n", "count 1000.000000\n", "mean 0.170000\n", "std 0.375821\n", "min 0.000000\n", "25% 0.000000\n", "50% 0.000000\n", "75% 0.000000\n", "max 1.000000" ], "text/html": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
target
count1000.000000
mean0.170000
std0.375821
min0.000000
25%0.000000
50%0.000000
75%0.000000
max1.000000
\n
" }, "metadata": {}, "execution_count": 3 } ], "source": [ "y.describe()" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " age surface montant_assure \\\n", "count 1000.000000 1000.000000 1000.000000 \n", "mean 42.198000 86.863400 22461.069000 \n", "std 14.710853 28.498626 9076.273609 \n", "min 15.000000 31.270000 4478.000000 \n", "25% 31.000000 66.235000 15574.500000 \n", "50% 42.000000 80.605000 21201.000000 \n", "75% 52.000000 104.842500 27597.000000 \n", "max 94.000000 179.780000 55852.000000 \n", "\n", " nb_sinistres_depuis_ouverture cotisation_n-1 cotisation_n \\\n", "count 1000.000000 1000.000000 1000.000000 \n", "mean 1.492000 272.762170 286.046570 \n", "std 0.954383 76.378759 82.097481 \n", "min 0.000000 175.380000 181.360000 \n", "25% 1.000000 211.842500 220.230000 \n", "50% 1.000000 227.525000 240.705000 \n", "75% 2.000000 360.062500 372.647500 \n", "max 4.000000 440.870000 510.490000 \n", "\n", " duree_contrat duree_dernier_sinistre duree_zero_sinistre \\\n", "count 1000.000000 1000.000000 1000.000000 \n", "mean 4883.704000 40.023000 3444.616000 \n", "std 2716.954916 41.793913 2826.615494 \n", "min 49.000000 0.000000 0.000000 \n", "25% 2637.750000 1.000000 565.000000 \n", "50% 4819.000000 29.000000 3111.500000 \n", "75% 7353.250000 68.000000 6037.000000 \n", "max 9526.000000 202.000000 9429.000000 \n", "\n", " depa_01 ... cate_Artisans, cate_Cadres cate_Employés \\\n", "count 1000.000000 ... 1000.000000 1000.000000 1000.000000 \n", "mean 0.009000 ... 0.174000 0.162000 0.341000 \n", "std 0.094488 ... 0.379299 0.368635 0.474283 \n", "min 0.000000 ... 0.000000 0.000000 0.000000 \n", "25% 0.000000 ... 0.000000 0.000000 0.000000 \n", "50% 0.000000 ... 0.000000 0.000000 0.000000 \n", "75% 0.000000 ... 0.000000 0.000000 1.000000 \n", "max 1.000000 ... 1.000000 1.000000 1.000000 \n", "\n", " cate_Inactifs cate_Ouvriers type_Appartement type_Maison \\\n", "count 1000.000000 1000.000000 1000.00000 1000.00000 \n", "mean 0.067000 0.125000 0.63400 0.36600 \n", "std 0.250147 0.330884 0.48195 0.48195 \n", "min 0.000000 0.000000 0.00000 0.00000 \n", "25% 0.000000 0.000000 0.00000 0.00000 \n", "50% 0.000000 0.000000 1.00000 0.00000 \n", "75% 0.000000 0.000000 1.00000 1.00000 \n", "max 1.000000 1.000000 1.00000 1.00000 \n", "\n", " stat_Locataire stat_Occupant stat_Propriétaire \n", "count 1000.000000 1000.000000 1000.000000 \n", "mean 0.586000 0.028000 0.386000 \n", "std 0.492795 0.165055 0.487074 \n", "min 0.000000 0.000000 0.000000 \n", "25% 0.000000 0.000000 0.000000 \n", "50% 1.000000 0.000000 0.000000 \n", "75% 1.000000 0.000000 1.000000 \n", "max 1.000000 1.000000 1.000000 \n", "\n", "[8 rows x 121 columns]" ], "text/html": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
agesurfacemontant_assurenb_sinistres_depuis_ouverturecotisation_n-1cotisation_nduree_contratduree_dernier_sinistreduree_zero_sinistredepa_01...cate_Artisans,cate_Cadrescate_Employéscate_Inactifscate_Ouvrierstype_Appartementtype_Maisonstat_Locatairestat_Occupantstat_Propriétaire
count1000.0000001000.0000001000.0000001000.0000001000.0000001000.0000001000.0000001000.0000001000.0000001000.000000...1000.0000001000.0000001000.0000001000.0000001000.0000001000.000001000.000001000.0000001000.0000001000.000000
mean42.19800086.86340022461.0690001.492000272.762170286.0465704883.70400040.0230003444.6160000.009000...0.1740000.1620000.3410000.0670000.1250000.634000.366000.5860000.0280000.386000
std14.71085328.4986269076.2736090.95438376.37875982.0974812716.95491641.7939132826.6154940.094488...0.3792990.3686350.4742830.2501470.3308840.481950.481950.4927950.1650550.487074
min15.00000031.2700004478.0000000.000000175.380000181.36000049.0000000.0000000.0000000.000000...0.0000000.0000000.0000000.0000000.0000000.000000.000000.0000000.0000000.000000
25%31.00000066.23500015574.5000001.000000211.842500220.2300002637.7500001.000000565.0000000.000000...0.0000000.0000000.0000000.0000000.0000000.000000.000000.0000000.0000000.000000
50%42.00000080.60500021201.0000001.000000227.525000240.7050004819.00000029.0000003111.5000000.000000...0.0000000.0000000.0000000.0000000.0000001.000000.000001.0000000.0000000.000000
75%52.000000104.84250027597.0000002.000000360.062500372.6475007353.25000068.0000006037.0000000.000000...0.0000000.0000001.0000000.0000000.0000001.000001.000001.0000000.0000001.000000
max94.000000179.78000055852.0000004.000000440.870000510.4900009526.000000202.0000009429.0000001.000000...1.0000001.0000001.0000001.0000001.0000001.000001.000001.0000001.0000001.000000
\n

8 rows × 121 columns

\n
" }, "metadata": {}, "execution_count": 4 } ], "source": [ "X.describe()" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " age surface montant_assure nb_sinistres_depuis_ouverture \\\n", "count 300.00000 300.000000 300.000000 300.000000 \n", "mean 42.59000 86.704767 22894.856667 1.466667 \n", "std 14.62949 30.453970 9374.614330 0.992727 \n", "min 15.00000 29.360000 7217.000000 0.000000 \n", "25% 31.00000 63.672500 15281.750000 1.000000 \n", "50% 43.00000 78.530000 20810.500000 1.000000 \n", "75% 54.00000 107.357500 28494.750000 2.000000 \n", "max 86.00000 169.560000 50948.000000 5.000000 \n", "\n", " cotisation_n-1 cotisation_n duree_contrat duree_dernier_sinistre \\\n", "count 300.000000 300.000000 300.000000 300.000000 \n", "mean 274.989200 288.086200 4810.156667 34.820000 \n", "std 80.104622 86.567491 2673.566074 39.671826 \n", "min 172.470000 180.700000 88.000000 0.000000 \n", "25% 212.580000 221.105000 2521.000000 1.000000 \n", "50% 227.590000 240.395000 5101.000000 19.500000 \n", "75% 364.185000 370.237500 7099.500000 62.000000 \n", "max 450.560000 599.500000 9530.000000 189.000000 \n", "\n", " duree_zero_sinistre depa_01 ... cate_Artisans, cate_Cadres \\\n", "count 300.000000 300.000000 ... 300.000000 300.000000 \n", "mean 3174.016667 0.010000 ... 0.156667 0.186667 \n", "std 2745.057079 0.099665 ... 0.364094 0.390295 \n", "min 0.000000 0.000000 ... 0.000000 0.000000 \n", "25% 472.500000 0.000000 ... 0.000000 0.000000 \n", "50% 2566.500000 0.000000 ... 0.000000 0.000000 \n", "75% 5547.250000 0.000000 ... 0.000000 0.000000 \n", "max 9019.000000 1.000000 ... 1.000000 1.000000 \n", "\n", " cate_Employés cate_Inactifs cate_Ouvriers type_Appartement \\\n", "count 300.000000 300.000000 300.000000 300.000000 \n", "mean 0.370000 0.023333 0.116667 0.626667 \n", "std 0.483611 0.151212 0.321559 0.484498 \n", "min 0.000000 0.000000 0.000000 0.000000 \n", "25% 0.000000 0.000000 0.000000 0.000000 \n", "50% 0.000000 0.000000 0.000000 1.000000 \n", "75% 1.000000 0.000000 0.000000 1.000000 \n", "max 1.000000 1.000000 1.000000 1.000000 \n", "\n", " type_Maison stat_Locataire stat_Occupant stat_Propriétaire \n", "count 300.000000 300.000000 300.000000 300.000000 \n", "mean 0.373333 0.560000 0.016667 0.423333 \n", "std 0.484498 0.497216 0.128233 0.494913 \n", "min 0.000000 0.000000 0.000000 0.000000 \n", "25% 0.000000 0.000000 0.000000 0.000000 \n", "50% 0.000000 1.000000 0.000000 0.000000 \n", "75% 1.000000 1.000000 0.000000 1.000000 \n", "max 1.000000 1.000000 1.000000 1.000000 \n", "\n", "[8 rows x 121 columns]" ], "text/html": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
agesurfacemontant_assurenb_sinistres_depuis_ouverturecotisation_n-1cotisation_nduree_contratduree_dernier_sinistreduree_zero_sinistredepa_01...cate_Artisans,cate_Cadrescate_Employéscate_Inactifscate_Ouvrierstype_Appartementtype_Maisonstat_Locatairestat_Occupantstat_Propriétaire
count300.00000300.000000300.000000300.000000300.000000300.000000300.000000300.000000300.000000300.000000...300.000000300.000000300.000000300.000000300.000000300.000000300.000000300.000000300.000000300.000000
mean42.5900086.70476722894.8566671.466667274.989200288.0862004810.15666734.8200003174.0166670.010000...0.1566670.1866670.3700000.0233330.1166670.6266670.3733330.5600000.0166670.423333
std14.6294930.4539709374.6143300.99272780.10462286.5674912673.56607439.6718262745.0570790.099665...0.3640940.3902950.4836110.1512120.3215590.4844980.4844980.4972160.1282330.494913
min15.0000029.3600007217.0000000.000000172.470000180.70000088.0000000.0000000.0000000.000000...0.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.000000
25%31.0000063.67250015281.7500001.000000212.580000221.1050002521.0000001.000000472.5000000.000000...0.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.000000
50%43.0000078.53000020810.5000001.000000227.590000240.3950005101.00000019.5000002566.5000000.000000...0.0000000.0000000.0000000.0000000.0000001.0000000.0000001.0000000.0000000.000000
75%54.00000107.35750028494.7500002.000000364.185000370.2375007099.50000062.0000005547.2500000.000000...0.0000000.0000001.0000000.0000000.0000001.0000001.0000001.0000000.0000001.000000
max86.00000169.56000050948.0000005.000000450.560000599.5000009530.000000189.0000009019.0000001.000000...1.0000001.0000001.0000001.0000001.0000001.0000001.0000001.0000001.0000001.000000
\n

8 rows × 121 columns

\n
" }, "metadata": {}, "execution_count": 5 } ], "source": [ "Xscore.describe()" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [], "source": [ "from sklearn.preprocessing import MinMaxScaler\n", "\n", "scaler = MinMaxScaler()\n", "X = scaler.fit_transform(X)\n", "Xscore = scaler.transform(Xscore)" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " 0 1 2 3 4 \\\n", "count 1000.000000 1000.000000 1000.000000 1000.000000 1000.000000 \n", "mean 0.344278 0.374341 0.350042 0.373000 0.366802 \n", "std 0.186213 0.191897 0.176671 0.238596 0.287690 \n", "min 0.000000 0.000000 0.000000 0.000000 0.000000 \n", "25% 0.202532 0.235439 0.215994 0.250000 0.137340 \n", "50% 0.341772 0.332200 0.325515 0.250000 0.196410 \n", "75% 0.468354 0.495404 0.450014 0.500000 0.695629 \n", "max 1.000000 1.000000 1.000000 1.000000 1.000000 \n", "\n", " 5 6 7 8 9 ... \\\n", "count 1000.000000 1000.000000 1000.000000 1000.000000 1000.000000 ... \n", "mean 0.318071 0.510151 0.198134 0.365321 0.009000 ... \n", "std 0.249438 0.286689 0.206901 0.299779 0.094488 ... \n", "min 0.000000 0.000000 0.000000 0.000000 0.000000 ... \n", "25% 0.118099 0.273161 0.004950 0.059922 0.000000 ... \n", "50% 0.180309 0.503324 0.143564 0.329993 0.000000 ... \n", "75% 0.581191 0.770734 0.336634 0.640259 0.000000 ... \n", "max 1.000000 1.000000 1.000000 1.000000 1.000000 ... \n", "\n", " 111 112 113 114 115 \\\n", "count 1000.000000 1000.000000 1000.000000 1000.000000 1000.000000 \n", "mean 0.174000 0.162000 0.341000 0.067000 0.125000 \n", "std 0.379299 0.368635 0.474283 0.250147 0.330884 \n", "min 0.000000 0.000000 0.000000 0.000000 0.000000 \n", "25% 0.000000 0.000000 0.000000 0.000000 0.000000 \n", "50% 0.000000 0.000000 0.000000 0.000000 0.000000 \n", "75% 0.000000 0.000000 1.000000 0.000000 0.000000 \n", "max 1.000000 1.000000 1.000000 1.000000 1.000000 \n", "\n", " 116 117 118 119 120 \n", "count 1000.00000 1000.00000 1000.000000 1000.000000 1000.000000 \n", "mean 0.63400 0.36600 0.586000 0.028000 0.386000 \n", "std 0.48195 0.48195 0.492795 0.165055 0.487074 \n", "min 0.00000 0.00000 0.000000 0.000000 0.000000 \n", "25% 0.00000 0.00000 0.000000 0.000000 0.000000 \n", "50% 1.00000 0.00000 1.000000 0.000000 0.000000 \n", "75% 1.00000 1.00000 1.000000 0.000000 1.000000 \n", "max 1.00000 1.00000 1.000000 1.000000 1.000000 \n", "\n", "[8 rows x 121 columns]" ], "text/html": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
0123456789...111112113114115116117118119120
count1000.0000001000.0000001000.0000001000.0000001000.0000001000.0000001000.0000001000.0000001000.0000001000.000000...1000.0000001000.0000001000.0000001000.0000001000.0000001000.000001000.000001000.0000001000.0000001000.000000
mean0.3442780.3743410.3500420.3730000.3668020.3180710.5101510.1981340.3653210.009000...0.1740000.1620000.3410000.0670000.1250000.634000.366000.5860000.0280000.386000
std0.1862130.1918970.1766710.2385960.2876900.2494380.2866890.2069010.2997790.094488...0.3792990.3686350.4742830.2501470.3308840.481950.481950.4927950.1650550.487074
min0.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.000000...0.0000000.0000000.0000000.0000000.0000000.000000.000000.0000000.0000000.000000
25%0.2025320.2354390.2159940.2500000.1373400.1180990.2731610.0049500.0599220.000000...0.0000000.0000000.0000000.0000000.0000000.000000.000000.0000000.0000000.000000
50%0.3417720.3322000.3255150.2500000.1964100.1803090.5033240.1435640.3299930.000000...0.0000000.0000000.0000000.0000000.0000001.000000.000001.0000000.0000000.000000
75%0.4683540.4954040.4500140.5000000.6956290.5811910.7707340.3366340.6402590.000000...0.0000000.0000001.0000000.0000000.0000001.000001.000001.0000000.0000001.000000
max1.0000001.0000001.0000001.0000001.0000001.0000001.0000001.0000001.0000001.000000...1.0000001.0000001.0000001.0000001.0000001.000001.000001.0000001.0000001.000000
\n

8 rows × 121 columns

\n
" }, "metadata": {}, "execution_count": 7 } ], "source": [ "pd.DataFrame(X).describe()" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " 0 1 2 3 4 5 \\\n", "count 300.000000 300.000000 300.000000 300.000000 300.000000 300.000000 \n", "mean 0.349241 0.373273 0.358486 0.366667 0.375190 0.324268 \n", "std 0.185183 0.205063 0.182478 0.248182 0.301724 0.263019 \n", "min 0.000000 -0.012861 0.053315 0.000000 -0.010961 -0.002005 \n", "25% 0.202532 0.218184 0.210296 0.250000 0.140118 0.120758 \n", "50% 0.354430 0.318228 0.317914 0.250000 0.196655 0.179367 \n", "75% 0.493671 0.512339 0.467488 0.500000 0.711157 0.573869 \n", "max 0.898734 0.931183 0.904543 1.250000 1.036499 1.270440 \n", "\n", " 6 7 8 9 ... 111 \\\n", "count 300.000000 300.000000 300.000000 300.000000 ... 300.000000 \n", "mean 0.502391 0.172376 0.336623 0.010000 ... 0.156667 \n", "std 0.282111 0.196395 0.291129 0.099665 ... 0.364094 \n", "min 0.004115 0.000000 0.000000 0.000000 ... 0.000000 \n", "25% 0.260842 0.004950 0.050111 0.000000 ... 0.000000 \n", "50% 0.533080 0.096535 0.272192 0.000000 ... 0.000000 \n", "75% 0.743959 0.306931 0.588318 0.000000 ... 0.000000 \n", "max 1.000422 0.935644 0.956517 1.000000 ... 1.000000 \n", "\n", " 112 113 114 115 116 117 \\\n", "count 300.000000 300.000000 300.000000 300.000000 300.000000 300.000000 \n", "mean 0.186667 0.370000 0.023333 0.116667 0.626667 0.373333 \n", "std 0.390295 0.483611 0.151212 0.321559 0.484498 0.484498 \n", "min 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 \n", "25% 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 \n", "50% 0.000000 0.000000 0.000000 0.000000 1.000000 0.000000 \n", "75% 0.000000 1.000000 0.000000 0.000000 1.000000 1.000000 \n", "max 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 \n", "\n", " 118 119 120 \n", "count 300.000000 300.000000 300.000000 \n", "mean 0.560000 0.016667 0.423333 \n", "std 0.497216 0.128233 0.494913 \n", "min 0.000000 0.000000 0.000000 \n", "25% 0.000000 0.000000 0.000000 \n", "50% 1.000000 0.000000 0.000000 \n", "75% 1.000000 0.000000 1.000000 \n", "max 1.000000 1.000000 1.000000 \n", "\n", "[8 rows x 121 columns]" ], "text/html": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
0123456789...111112113114115116117118119120
count300.000000300.000000300.000000300.000000300.000000300.000000300.000000300.000000300.000000300.000000...300.000000300.000000300.000000300.000000300.000000300.000000300.000000300.000000300.000000300.000000
mean0.3492410.3732730.3584860.3666670.3751900.3242680.5023910.1723760.3366230.010000...0.1566670.1866670.3700000.0233330.1166670.6266670.3733330.5600000.0166670.423333
std0.1851830.2050630.1824780.2481820.3017240.2630190.2821110.1963950.2911290.099665...0.3640940.3902950.4836110.1512120.3215590.4844980.4844980.4972160.1282330.494913
min0.000000-0.0128610.0533150.000000-0.010961-0.0020050.0041150.0000000.0000000.000000...0.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.000000
25%0.2025320.2181840.2102960.2500000.1401180.1207580.2608420.0049500.0501110.000000...0.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.000000
50%0.3544300.3182280.3179140.2500000.1966550.1793670.5330800.0965350.2721920.000000...0.0000000.0000000.0000000.0000000.0000001.0000000.0000001.0000000.0000000.000000
75%0.4936710.5123390.4674880.5000000.7111570.5738690.7439590.3069310.5883180.000000...0.0000000.0000001.0000000.0000000.0000001.0000001.0000001.0000000.0000001.000000
max0.8987340.9311830.9045431.2500001.0364991.2704401.0004220.9356440.9565171.000000...1.0000001.0000001.0000001.0000001.0000001.0000001.0000001.0000001.0000001.000000
\n

8 rows × 121 columns

\n
" }, "metadata": {}, "execution_count": 8 } ], "source": [ "pd.DataFrame(Xscore).describe()" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "0.2" ] }, "metadata": {}, "execution_count": 9 } ], "source": [ "from sklearn.model_selection import train_test_split \n", "\n", "X_train, X_test, y_train, y_test = train_test_split(X, y, test_size=0.2, random_state=42)\n", "len(X_test)/len(X)" ] }, { "cell_type": "code", "execution_count": 10, "metadata": {}, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " 0 1 2 3 4 5 \\\n", "count 800.000000 800.000000 800.000000 800.000000 800.000000 800.000000 \n", "mean 0.344747 0.373978 0.352949 0.368750 0.368131 0.318731 \n", "std 0.185341 0.189740 0.180912 0.234917 0.286502 0.249066 \n", "min 0.000000 0.010774 0.000000 0.000000 0.000000 0.000000 \n", "25% 0.202532 0.235439 0.215002 0.250000 0.138178 0.119444 \n", "50% 0.341772 0.335903 0.328045 0.250000 0.199066 0.180445 \n", "75% 0.468354 0.488570 0.460938 0.500000 0.694037 0.581207 \n", "max 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 \n", "\n", " 6 7 8 9 ... 111 \\\n", "count 800.000000 800.000000 800.000000 800.000000 ... 800.000000 \n", "mean 0.506860 0.197333 0.358045 0.006250 ... 0.172500 \n", "std 0.288273 0.201852 0.298163 0.078859 ... 0.378051 \n", "min 0.001688 0.000000 0.000000 0.000000 ... 0.000000 \n", "25% 0.266092 0.004950 0.057376 0.000000 ... 0.000000 \n", "50% 0.499156 0.153465 0.312971 0.000000 ... 0.000000 \n", "75% 0.768756 0.336634 0.627559 0.000000 ... 0.000000 \n", "max 1.000000 1.000000 1.000000 1.000000 ... 1.000000 \n", "\n", " 112 113 114 115 116 117 \\\n", "count 800.000000 800.000000 800.000000 800.000000 800.00000 800.00000 \n", "mean 0.165000 0.342500 0.073750 0.122500 0.63375 0.36625 \n", "std 0.371413 0.474843 0.261527 0.328068 0.48208 0.48208 \n", "min 0.000000 0.000000 0.000000 0.000000 0.00000 0.00000 \n", "25% 0.000000 0.000000 0.000000 0.000000 0.00000 0.00000 \n", "50% 0.000000 0.000000 0.000000 0.000000 1.00000 0.00000 \n", "75% 0.000000 1.000000 0.000000 0.000000 1.00000 1.00000 \n", "max 1.000000 1.000000 1.000000 1.000000 1.00000 1.00000 \n", "\n", " 118 119 120 \n", "count 800.000000 800.000000 800.000000 \n", "mean 0.580000 0.027500 0.392500 \n", "std 0.493867 0.163637 0.488613 \n", "min 0.000000 0.000000 0.000000 \n", "25% 0.000000 0.000000 0.000000 \n", "50% 1.000000 0.000000 0.000000 \n", "75% 1.000000 0.000000 1.000000 \n", "max 1.000000 1.000000 1.000000 \n", "\n", "[8 rows x 121 columns]" ], "text/html": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
0123456789...111112113114115116117118119120
count800.000000800.000000800.000000800.000000800.000000800.000000800.000000800.000000800.000000800.000000...800.000000800.000000800.000000800.000000800.000000800.00000800.00000800.000000800.000000800.000000
mean0.3447470.3739780.3529490.3687500.3681310.3187310.5068600.1973330.3580450.006250...0.1725000.1650000.3425000.0737500.1225000.633750.366250.5800000.0275000.392500
std0.1853410.1897400.1809120.2349170.2865020.2490660.2882730.2018520.2981630.078859...0.3780510.3714130.4748430.2615270.3280680.482080.482080.4938670.1636370.488613
min0.0000000.0107740.0000000.0000000.0000000.0000000.0016880.0000000.0000000.000000...0.0000000.0000000.0000000.0000000.0000000.000000.000000.0000000.0000000.000000
25%0.2025320.2354390.2150020.2500000.1381780.1194440.2660920.0049500.0573760.000000...0.0000000.0000000.0000000.0000000.0000000.000000.000000.0000000.0000000.000000
50%0.3417720.3359030.3280450.2500000.1990660.1804450.4991560.1534650.3129710.000000...0.0000000.0000000.0000000.0000000.0000001.000000.000001.0000000.0000000.000000
75%0.4683540.4885700.4609380.5000000.6940370.5812070.7687560.3366340.6275590.000000...0.0000000.0000001.0000000.0000000.0000001.000001.000001.0000000.0000001.000000
max1.0000001.0000001.0000001.0000001.0000001.0000001.0000001.0000001.0000001.000000...1.0000001.0000001.0000001.0000001.0000001.000001.000001.0000001.0000001.000000
\n

8 rows × 121 columns

\n
" }, "metadata": {}, "execution_count": 10 } ], "source": [ "pd.DataFrame(X_train).describe()" ] }, { "cell_type": "code", "execution_count": 11, "metadata": {}, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " 0 1 2 3 4 5 \\\n", "count 200.000000 200.000000 200.000000 200.000000 200.000000 200.000000 \n", "mean 0.342405 0.375793 0.338414 0.390000 0.361484 0.315430 \n", "std 0.190125 0.200777 0.158461 0.252674 0.293059 0.251531 \n", "min 0.000000 0.000000 0.053295 0.000000 0.016498 0.028742 \n", "25% 0.215190 0.235506 0.231868 0.250000 0.129421 0.111909 \n", "50% 0.341772 0.319541 0.310498 0.500000 0.185242 0.179564 \n", "75% 0.443038 0.518955 0.424106 0.500000 0.707051 0.580143 \n", "max 0.949367 0.982291 0.834294 1.000000 0.890956 0.831921 \n", "\n", " 6 7 8 9 ... 111 \\\n", "count 200.000000 200.000000 200.000000 200.000000 ... 200.000000 \n", "mean 0.523317 0.201337 0.394428 0.020000 ... 0.180000 \n", "std 0.280589 0.226485 0.305180 0.140351 ... 0.385152 \n", "min 0.000000 0.000000 0.000000 0.000000 ... 0.000000 \n", "25% 0.287802 0.004950 0.077871 0.000000 ... 0.000000 \n", "50% 0.532605 0.123762 0.390550 0.000000 ... 0.000000 \n", "75% 0.772475 0.329208 0.671148 0.000000 ... 0.000000 \n", "max 0.996307 0.930693 0.968607 1.000000 ... 1.000000 \n", "\n", " 112 113 114 115 116 117 \\\n", "count 200.000000 200.000000 200.000000 200.000000 200.000000 200.000000 \n", "mean 0.150000 0.335000 0.040000 0.135000 0.635000 0.365000 \n", "std 0.357967 0.473175 0.196451 0.342581 0.482638 0.482638 \n", "min 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 \n", "25% 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 \n", "50% 0.000000 0.000000 0.000000 0.000000 1.000000 0.000000 \n", "75% 0.000000 1.000000 0.000000 0.000000 1.000000 1.000000 \n", "max 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 \n", "\n", " 118 119 120 \n", "count 200.000000 200.000000 200.000000 \n", "mean 0.610000 0.030000 0.360000 \n", "std 0.488974 0.171015 0.481205 \n", "min 0.000000 0.000000 0.000000 \n", "25% 0.000000 0.000000 0.000000 \n", "50% 1.000000 0.000000 0.000000 \n", "75% 1.000000 0.000000 1.000000 \n", "max 1.000000 1.000000 1.000000 \n", "\n", "[8 rows x 121 columns]" ], "text/html": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
0123456789...111112113114115116117118119120
count200.000000200.000000200.000000200.000000200.000000200.000000200.000000200.000000200.000000200.000000...200.000000200.000000200.000000200.000000200.000000200.000000200.000000200.000000200.000000200.000000
mean0.3424050.3757930.3384140.3900000.3614840.3154300.5233170.2013370.3944280.020000...0.1800000.1500000.3350000.0400000.1350000.6350000.3650000.6100000.0300000.360000
std0.1901250.2007770.1584610.2526740.2930590.2515310.2805890.2264850.3051800.140351...0.3851520.3579670.4731750.1964510.3425810.4826380.4826380.4889740.1710150.481205
min0.0000000.0000000.0532950.0000000.0164980.0287420.0000000.0000000.0000000.000000...0.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.000000
25%0.2151900.2355060.2318680.2500000.1294210.1119090.2878020.0049500.0778710.000000...0.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.000000
50%0.3417720.3195410.3104980.5000000.1852420.1795640.5326050.1237620.3905500.000000...0.0000000.0000000.0000000.0000000.0000001.0000000.0000001.0000000.0000000.000000
75%0.4430380.5189550.4241060.5000000.7070510.5801430.7724750.3292080.6711480.000000...0.0000000.0000001.0000000.0000000.0000001.0000001.0000001.0000000.0000001.000000
max0.9493670.9822910.8342941.0000000.8909560.8319210.9963070.9306930.9686071.000000...1.0000001.0000001.0000001.0000001.0000001.0000001.0000001.0000001.0000001.000000
\n

8 rows × 121 columns

\n
" }, "metadata": {}, "execution_count": 11 } ], "source": [ "pd.DataFrame(X_test).describe()" ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " target\n", "count 800.000000\n", "mean 0.170000\n", "std 0.375868\n", "min 0.000000\n", "25% 0.000000\n", "50% 0.000000\n", "75% 0.000000\n", "max 1.000000" ], "text/html": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
target
count800.000000
mean0.170000
std0.375868
min0.000000
25%0.000000
50%0.000000
75%0.000000
max1.000000
\n
" }, "metadata": {}, "execution_count": 12 } ], "source": [ "pd.DataFrame(y_train).describe()" ] }, { "cell_type": "code", "execution_count": 13, "metadata": {}, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " target\n", "count 200.000000\n", "mean 0.170000\n", "std 0.376575\n", "min 0.000000\n", "25% 0.000000\n", "50% 0.000000\n", "75% 0.000000\n", "max 1.000000" ], "text/html": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
target
count200.000000
mean0.170000
std0.376575
min0.000000
25%0.000000
50%0.000000
75%0.000000
max1.000000
\n
" }, "metadata": {}, "execution_count": 13 } ], "source": [ "pd.DataFrame(y_test).describe()" ] }, { "cell_type": "code", "execution_count": 14, "metadata": {}, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ "target\n0.0 664\n1.0 136\ndtype: int64 target\n1.0 664\n0.0 664\ndtype: int64\n" ] } ], "source": [ "from imblearn.over_sampling import SMOTE\n", "\n", "sm = SMOTE(random_state=42)\n", "x_train_res, y_train_res = sm.fit_sample(X_train, y_train)\n", "\n", "print(y_train.value_counts(), y_train_res.value_counts())" ] }, { "cell_type": "code", "execution_count": 15, "metadata": {}, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ " precision recall f1-score support\n\n non résilié 0.93 0.92 0.92 166\n resilié 0.62 0.68 0.65 34\n\n accuracy 0.88 200\n macro avg 0.78 0.80 0.79 200\nweighted avg 0.88 0.88 0.88 200\n\n" ] } ], "source": [ "from sklearn.ensemble import RandomForestClassifier\n", "from sklearn.metrics import classification_report\n", "\n", "model_RF = RandomForestClassifier(n_estimators=1000)\n", "model_RF.fit(x_train_res , y_train_res)\n", "y_pred = model_RF.predict(X_test)\n", "target_names = ['non résilié', 'resilié'] # 1 résilié, 0 pas résilié\n", "print(classification_report(y_test, y_pred,target_names=target_names))" ] }, { "cell_type": "code", "execution_count": 16, "metadata": {}, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ " precision recall f1-score support\n\n non résilié 0.94 0.91 0.92 166\n resilié 0.62 0.71 0.66 34\n\n accuracy 0.88 200\n macro avg 0.78 0.81 0.79 200\nweighted avg 0.88 0.88 0.88 200\n\n" ] } ], "source": [ "from sklearn.ensemble import GradientBoostingClassifier\n", "\n", "model_GB = GradientBoostingClassifier(n_estimators=1000)\n", "model_GB.fit(x_train_res , y_train_res)\n", "y_pred = model_GB.predict(X_test)\n", "target_names = ['non résilié', 'resilié'] \n", "print(classification_report(y_test, y_pred,target_names=target_names))" ] }, { "cell_type": "code", "execution_count": 17, "metadata": {}, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ " precision recall f1-score support\n\n non résilié 0.93 0.88 0.90 166\n resilié 0.53 0.68 0.60 34\n\n accuracy 0.84 200\n macro avg 0.73 0.78 0.75 200\nweighted avg 0.86 0.84 0.85 200\n\n" ] } ], "source": [ "from sklearn.ensemble import AdaBoostClassifier\n", "\n", "model_AB = AdaBoostClassifier()\n", "model_AB.fit(x_train_res , y_train_res)\n", "y_pred = model_AB.predict(X_test)\n", "target_names = ['non résilié', 'resilié'] \n", "print(classification_report(y_test, y_pred,target_names=target_names))" ] }, { "cell_type": "code", "execution_count": 18, "metadata": { "tags": [] }, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ "| iter | target | learni... | n_esti... |\n", "-------------------------------------------------\n", "| \u001b[0m 1 \u001b[0m | \u001b[0m 0.7089 \u001b[0m | \u001b[0m-0.008298\u001b[0m | \u001b[0m 24.41 \u001b[0m |\n", "| \u001b[0m 2 \u001b[0m | \u001b[0m 0.6923 \u001b[0m | \u001b[0m-0.04999 \u001b[0m | \u001b[0m 16.05 \u001b[0m |\n", "| \u001b[0m 3 \u001b[0m | \u001b[0m 0.7073 \u001b[0m | \u001b[0m-0.03532 \u001b[0m | \u001b[0m 11.85 \u001b[0m |\n", "| \u001b[0m 4 \u001b[0m | \u001b[0m 0.6897 \u001b[0m | \u001b[0m-0.03137 \u001b[0m | \u001b[0m 16.91 \u001b[0m |\n", "| \u001b[0m 5 \u001b[0m | \u001b[0m 0.6829 \u001b[0m | \u001b[0m-0.01032 \u001b[0m | \u001b[0m 20.78 \u001b[0m |\n", "| \u001b[95m 6 \u001b[0m | \u001b[95m 0.72 \u001b[0m | \u001b[95m-0.008081\u001b[0m | \u001b[95m 23.7 \u001b[0m |\n", "| \u001b[0m 7 \u001b[0m | \u001b[0m 0.6753 \u001b[0m | \u001b[0m-0.02955 \u001b[0m | \u001b[0m 27.56 \u001b[0m |\n", "| \u001b[0m 8 \u001b[0m | \u001b[0m 0.7105 \u001b[0m | \u001b[0m-0.04726 \u001b[0m | \u001b[0m 23.41 \u001b[0m |\n", "| \u001b[95m 9 \u001b[0m | \u001b[95m 0.7273 \u001b[0m | \u001b[95m-0.00827 \u001b[0m | \u001b[95m 21.17 \u001b[0m |\n", "| \u001b[0m 10 \u001b[0m | \u001b[0m 0.7229 \u001b[0m | \u001b[0m-0.03596 \u001b[0m | \u001b[0m 13.96 \u001b[0m |\n", "| \u001b[0m 11 \u001b[0m | \u001b[0m 0.7179 \u001b[0m | \u001b[0m-0.007011\u001b[0m | \u001b[0m 21.28 \u001b[0m |\n", "| \u001b[0m 12 \u001b[0m | \u001b[0m 0.7073 \u001b[0m | \u001b[0m 0.01039 \u001b[0m | \u001b[0m 13.78 \u001b[0m |\n", "| \u001b[95m 13 \u001b[0m | \u001b[95m 0.7317 \u001b[0m | \u001b[95m-0.03507 \u001b[0m | \u001b[95m 22.58 \u001b[0m |\n", "| \u001b[0m 14 \u001b[0m | \u001b[0m 0.7013 \u001b[0m | \u001b[0m 0.01136 \u001b[0m | \u001b[0m 22.72 \u001b[0m |\n", "| \u001b[0m 15 \u001b[0m | \u001b[0m 0.6977 \u001b[0m | \u001b[0m-0.01044 \u001b[0m | \u001b[0m 13.23 \u001b[0m |\n", "| \u001b[0m 16 \u001b[0m | \u001b[0m 0.7105 \u001b[0m | \u001b[0m-0.05 \u001b[0m | \u001b[0m 22.49 \u001b[0m |\n", "| \u001b[0m 17 \u001b[0m | \u001b[0m 0.6829 \u001b[0m | \u001b[0m-0.01468 \u001b[0m | \u001b[0m 21.17 \u001b[0m |\n", "| \u001b[0m 18 \u001b[0m | \u001b[0m 0.72 \u001b[0m | \u001b[0m 0.01099 \u001b[0m | \u001b[0m 17.86 \u001b[0m |\n", "| \u001b[0m 19 \u001b[0m | \u001b[0m 0.6923 \u001b[0m | \u001b[0m 0.00532 \u001b[0m | \u001b[0m 24.04 \u001b[0m |\n", "| \u001b[0m 20 \u001b[0m | \u001b[0m 0.6966 \u001b[0m | \u001b[0m-0.03516 \u001b[0m | \u001b[0m 18.13 \u001b[0m |\n", "| \u001b[0m 21 \u001b[0m | \u001b[0m 0.7073 \u001b[0m | \u001b[0m 0.01034 \u001b[0m | \u001b[0m 13.78 \u001b[0m |\n", "| \u001b[0m 22 \u001b[0m | \u001b[0m 0.7273 \u001b[0m | \u001b[0m-0.03031 \u001b[0m | \u001b[0m 22.57 \u001b[0m |\n", "| \u001b[0m 23 \u001b[0m | \u001b[0m 0.6829 \u001b[0m | \u001b[0m-0.01265 \u001b[0m | \u001b[0m 21.18 \u001b[0m |\n", "| \u001b[0m 24 \u001b[0m | \u001b[0m 0.7317 \u001b[0m | \u001b[0m-0.03232 \u001b[0m | \u001b[0m 22.58 \u001b[0m |\n", "| \u001b[0m 25 \u001b[0m | \u001b[0m 0.6835 \u001b[0m | \u001b[0m-0.03319 \u001b[0m | \u001b[0m 23.68 \u001b[0m |\n", "| \u001b[0m 26 \u001b[0m | \u001b[0m 0.7229 \u001b[0m | \u001b[0m-0.03413 \u001b[0m | \u001b[0m 13.97 \u001b[0m |\n", "| \u001b[0m 27 \u001b[0m | \u001b[0m 0.7297 \u001b[0m | \u001b[0m-0.02612 \u001b[0m | \u001b[0m 22.58 \u001b[0m |\n", "| \u001b[0m 28 \u001b[0m | \u001b[0m 0.7013 \u001b[0m | \u001b[0m 0.000315\u001b[0m | \u001b[0m 21.18 \u001b[0m |\n", "| \u001b[0m 29 \u001b[0m | \u001b[0m 0.7073 \u001b[0m | \u001b[0m-0.02756 \u001b[0m | \u001b[0m 22.59 \u001b[0m |\n", "| \u001b[0m 30 \u001b[0m | \u001b[0m 0.72 \u001b[0m | \u001b[0m 0.000387\u001b[0m | \u001b[0m 23.7 \u001b[0m |\n", "| \u001b[0m 31 \u001b[0m | \u001b[0m 0.6923 \u001b[0m | \u001b[0m 0.003145\u001b[0m | \u001b[0m 23.71 \u001b[0m |\n", "| \u001b[0m 32 \u001b[0m | \u001b[0m 0.7229 \u001b[0m | \u001b[0m-0.02833 \u001b[0m | \u001b[0m 13.96 \u001b[0m |\n", "| \u001b[0m 33 \u001b[0m | \u001b[0m 0.7105 \u001b[0m | \u001b[0m-0.04397 \u001b[0m | \u001b[0m 22.58 \u001b[0m |\n", "| \u001b[0m 34 \u001b[0m | \u001b[0m 0.6842 \u001b[0m | \u001b[0m-0.003856\u001b[0m | \u001b[0m 19.76 \u001b[0m |\n", "| \u001b[0m 35 \u001b[0m | \u001b[0m 0.7059 \u001b[0m | \u001b[0m-0.03591 \u001b[0m | \u001b[0m 22.57 \u001b[0m |\n", "| \u001b[0m 36 \u001b[0m | \u001b[0m 0.7229 \u001b[0m | \u001b[0m-0.01857 \u001b[0m | \u001b[0m 14.29 \u001b[0m |\n", "| \u001b[0m 37 \u001b[0m | \u001b[0m 0.72 \u001b[0m | \u001b[0m-0.00727 \u001b[0m | \u001b[0m 23.7 \u001b[0m |\n", "| \u001b[95m 38 \u001b[0m | \u001b[95m 0.7368 \u001b[0m | \u001b[95m-0.02643 \u001b[0m | \u001b[95m 14.29 \u001b[0m |\n", "| \u001b[0m 39 \u001b[0m | \u001b[0m 0.6923 \u001b[0m | \u001b[0m-0.01537 \u001b[0m | \u001b[0m 22.58 \u001b[0m |\n", "| \u001b[0m 40 \u001b[0m | \u001b[0m 0.7229 \u001b[0m | \u001b[0m-0.02017 \u001b[0m | \u001b[0m 14.28 \u001b[0m |\n", "| \u001b[0m 41 \u001b[0m | \u001b[0m 0.7143 \u001b[0m | \u001b[0m-0.02964 \u001b[0m | \u001b[0m 14.29 \u001b[0m |\n", "| \u001b[0m 42 \u001b[0m | \u001b[0m 0.7143 \u001b[0m | \u001b[0m-0.03763 \u001b[0m | \u001b[0m 14.28 \u001b[0m |\n", "| \u001b[0m 43 \u001b[0m | \u001b[0m 0.6977 \u001b[0m | \u001b[0m-0.02414 \u001b[0m | \u001b[0m 14.28 \u001b[0m |\n", "| \u001b[0m 44 \u001b[0m | \u001b[0m 0.72 \u001b[0m | \u001b[0m-0.004892\u001b[0m | \u001b[0m 23.7 \u001b[0m |\n", "| \u001b[0m 45 \u001b[0m | \u001b[0m 0.725 \u001b[0m | \u001b[0m-0.006783\u001b[0m | \u001b[0m 27.31 \u001b[0m |\n", "| \u001b[0m 46 \u001b[0m | \u001b[0m 0.7143 \u001b[0m | \u001b[0m-0.0317 \u001b[0m | \u001b[0m 14.29 \u001b[0m |\n", "| \u001b[0m 47 \u001b[0m | \u001b[0m 0.7059 \u001b[0m | \u001b[0m-0.03789 \u001b[0m | \u001b[0m 22.58 \u001b[0m |\n", "| \u001b[0m 48 \u001b[0m | \u001b[0m 0.7229 \u001b[0m | \u001b[0m-0.02697 \u001b[0m | \u001b[0m 13.96 \u001b[0m |\n", "| \u001b[0m 49 \u001b[0m | \u001b[0m 0.7273 \u001b[0m | \u001b[0m-0.02878 \u001b[0m | \u001b[0m 22.58 \u001b[0m |\n", "| \u001b[0m 50 \u001b[0m | \u001b[0m 0.725 \u001b[0m | \u001b[0m-0.004436\u001b[0m | \u001b[0m 27.31 \u001b[0m |\n", "| \u001b[0m 51 \u001b[0m | \u001b[0m 0.7179 \u001b[0m | \u001b[0m-0.006697\u001b[0m | \u001b[0m 21.28 \u001b[0m |\n", "| \u001b[0m 52 \u001b[0m | \u001b[0m 0.7273 \u001b[0m | \u001b[0m-0.02933 \u001b[0m | \u001b[0m 22.59 \u001b[0m |\n", "| \u001b[0m 53 \u001b[0m | \u001b[0m 0.7143 \u001b[0m | \u001b[0m-0.01339 \u001b[0m | \u001b[0m 14.28 \u001b[0m |\n", "| \u001b[0m 54 \u001b[0m | \u001b[0m 0.6835 \u001b[0m | \u001b[0m-0.03413 \u001b[0m | \u001b[0m 23.39 \u001b[0m |\n", "| \u001b[0m 55 \u001b[0m | \u001b[0m 0.6923 \u001b[0m | \u001b[0m-0.02074 \u001b[0m | \u001b[0m 29.96 \u001b[0m |\n", "| \u001b[0m 56 \u001b[0m | \u001b[0m 0.7229 \u001b[0m | \u001b[0m-0.03278 \u001b[0m | \u001b[0m 13.96 \u001b[0m |\n", "| \u001b[0m 57 \u001b[0m | \u001b[0m 0.6977 \u001b[0m | \u001b[0m-0.02405 \u001b[0m | \u001b[0m 14.29 \u001b[0m |\n", "| \u001b[0m 58 \u001b[0m | \u001b[0m 0.7297 \u001b[0m | \u001b[0m-0.02543 \u001b[0m | \u001b[0m 22.58 \u001b[0m |\n", "| \u001b[0m 59 \u001b[0m | \u001b[0m 0.7229 \u001b[0m | \u001b[0m-0.03681 \u001b[0m | \u001b[0m 13.97 \u001b[0m |\n", "| \u001b[0m 60 \u001b[0m | \u001b[0m 0.6494 \u001b[0m | \u001b[0m-0.009551\u001b[0m | \u001b[0m 27.31 \u001b[0m |\n", "| \u001b[0m 61 \u001b[0m | \u001b[0m 0.6829 \u001b[0m | \u001b[0m 0.006223\u001b[0m | \u001b[0m 16.56 \u001b[0m |\n", "| \u001b[0m 62 \u001b[0m | \u001b[0m 0.6933 \u001b[0m | \u001b[0m 0.02765 \u001b[0m | \u001b[0m 13.92 \u001b[0m |\n", "| \u001b[0m 63 \u001b[0m | \u001b[0m 0.7317 \u001b[0m | \u001b[0m-0.03269 \u001b[0m | \u001b[0m 22.59 \u001b[0m |\n", "| \u001b[0m 64 \u001b[0m | \u001b[0m 0.6753 \u001b[0m | \u001b[0m-0.02335 \u001b[0m | \u001b[0m 22.58 \u001b[0m |\n", "| \u001b[0m 65 \u001b[0m | \u001b[0m 0.7073 \u001b[0m | \u001b[0m-0.03869 \u001b[0m | \u001b[0m 13.97 \u001b[0m |\n", "| \u001b[0m 66 \u001b[0m | \u001b[0m 0.7229 \u001b[0m | \u001b[0m-0.03417 \u001b[0m | \u001b[0m 13.96 \u001b[0m |\n", "| \u001b[0m 67 \u001b[0m | \u001b[0m 0.7229 \u001b[0m | \u001b[0m-0.0304 \u001b[0m | \u001b[0m 13.96 \u001b[0m |\n", "| \u001b[0m 68 \u001b[0m | \u001b[0m 0.7105 \u001b[0m | \u001b[0m 0.02672 \u001b[0m | \u001b[0m 23.46 \u001b[0m |\n", "| \u001b[0m 69 \u001b[0m | \u001b[0m 0.7073 \u001b[0m | \u001b[0m-0.03992 \u001b[0m | \u001b[0m 13.97 \u001b[0m |\n", "| \u001b[0m 70 \u001b[0m | \u001b[0m 0.7317 \u001b[0m | \u001b[0m-0.03472 \u001b[0m | \u001b[0m 22.58 \u001b[0m |\n", "| \u001b[0m 71 \u001b[0m | \u001b[0m 0.6753 \u001b[0m | \u001b[0m 0.01585 \u001b[0m | \u001b[0m 19.81 \u001b[0m |\n", "| \u001b[0m 72 \u001b[0m | \u001b[0m 0.7297 \u001b[0m | \u001b[0m-0.02563 \u001b[0m | \u001b[0m 22.57 \u001b[0m |\n", "| \u001b[0m 73 \u001b[0m | \u001b[0m 0.7297 \u001b[0m | \u001b[0m-0.02604 \u001b[0m | \u001b[0m 22.58 \u001b[0m |\n", "| \u001b[0m 74 \u001b[0m | \u001b[0m 0.7317 \u001b[0m | \u001b[0m-0.03239 \u001b[0m | \u001b[0m 22.57 \u001b[0m |\n", "| \u001b[0m 75 \u001b[0m | \u001b[0m 0.7105 \u001b[0m | \u001b[0m-0.02205 \u001b[0m | \u001b[0m 22.57 \u001b[0m |\n", "| \u001b[0m 76 \u001b[0m | \u001b[0m 0.7209 \u001b[0m | \u001b[0m-0.02868 \u001b[0m | \u001b[0m 19.62 \u001b[0m |\n", "| \u001b[0m 77 \u001b[0m | \u001b[0m 0.7059 \u001b[0m | \u001b[0m-0.03574 \u001b[0m | \u001b[0m 22.57 \u001b[0m |\n", "| \u001b[0m 78 \u001b[0m | \u001b[0m 0.725 \u001b[0m | \u001b[0m-0.002359\u001b[0m | \u001b[0m 27.31 \u001b[0m |\n", "| \u001b[0m 79 \u001b[0m | \u001b[0m 0.7273 \u001b[0m | \u001b[0m-0.02864 \u001b[0m | \u001b[0m 22.57 \u001b[0m |\n", "| \u001b[0m 80 \u001b[0m | \u001b[0m 0.6753 \u001b[0m | \u001b[0m 0.03513 \u001b[0m | \u001b[0m 20.67 \u001b[0m |\n", "| \u001b[0m 81 \u001b[0m | \u001b[0m 0.7143 \u001b[0m | \u001b[0m-0.02885 \u001b[0m | \u001b[0m 14.29 \u001b[0m |\n", "| \u001b[0m 82 \u001b[0m | \u001b[0m 0.72 \u001b[0m | \u001b[0m-0.000691\u001b[0m | \u001b[0m 23.7 \u001b[0m |\n", "| \u001b[0m 83 \u001b[0m | \u001b[0m 0.7143 \u001b[0m | \u001b[0m-0.02838 \u001b[0m | \u001b[0m 14.28 \u001b[0m |\n", "| \u001b[0m 84 \u001b[0m | \u001b[0m 0.7229 \u001b[0m | \u001b[0m-0.0215 \u001b[0m | \u001b[0m 14.27 \u001b[0m |\n", "| \u001b[0m 85 \u001b[0m | \u001b[0m 0.725 \u001b[0m | \u001b[0m-0.001135\u001b[0m | \u001b[0m 27.31 \u001b[0m |\n", "| \u001b[0m 86 \u001b[0m | \u001b[0m 0.7273 \u001b[0m | \u001b[0m-0.02949 \u001b[0m | \u001b[0m 22.58 \u001b[0m |\n", "| \u001b[0m 87 \u001b[0m | \u001b[0m 0.7143 \u001b[0m | \u001b[0m-0.01783 \u001b[0m | \u001b[0m 14.27 \u001b[0m |\n", "| \u001b[0m 88 \u001b[0m | \u001b[0m 0.7143 \u001b[0m | \u001b[0m-0.01541 \u001b[0m | \u001b[0m 14.28 \u001b[0m |\n", "| \u001b[0m 89 \u001b[0m | \u001b[0m 0.7229 \u001b[0m | \u001b[0m-0.03371 \u001b[0m | \u001b[0m 13.97 \u001b[0m |\n", "| \u001b[0m 90 \u001b[0m | \u001b[0m 0.6667 \u001b[0m | \u001b[0m 0.03289 \u001b[0m | \u001b[0m 29.7 \u001b[0m |\n", "| \u001b[0m 91 \u001b[0m | \u001b[0m 0.7013 \u001b[0m | \u001b[0m-0.004525\u001b[0m | \u001b[0m 21.17 \u001b[0m |\n", "| \u001b[0m 92 \u001b[0m | \u001b[0m 0.725 \u001b[0m | \u001b[0m-0.006537\u001b[0m | \u001b[0m 27.3 \u001b[0m |\n", "| \u001b[0m 93 \u001b[0m | \u001b[0m 0.7317 \u001b[0m | \u001b[0m-0.03363 \u001b[0m | \u001b[0m 22.58 \u001b[0m |\n", "| \u001b[0m 94 \u001b[0m | \u001b[0m 0.72 \u001b[0m | \u001b[0m 0.01181 \u001b[0m | \u001b[0m 17.85 \u001b[0m |\n", "| \u001b[0m 95 \u001b[0m | \u001b[0m 0.7273 \u001b[0m | \u001b[0m-0.02811 \u001b[0m | \u001b[0m 22.56 \u001b[0m |\n", "| \u001b[0m 96 \u001b[0m | \u001b[0m 0.7179 \u001b[0m | \u001b[0m 0.03583 \u001b[0m | \u001b[0m 11.03 \u001b[0m |\n", "| \u001b[0m 97 \u001b[0m | \u001b[0m 0.6988 \u001b[0m | \u001b[0m-0.04844 \u001b[0m | \u001b[0m 11.03 \u001b[0m |\n", "| \u001b[0m 98 \u001b[0m | \u001b[0m 0.72 \u001b[0m | \u001b[0m-0.005421\u001b[0m | \u001b[0m 23.69 \u001b[0m |\n", "| \u001b[0m 99 \u001b[0m | \u001b[0m 0.725 \u001b[0m | \u001b[0m-0.003373\u001b[0m | \u001b[0m 27.31 \u001b[0m |\n", "| \u001b[0m 100 \u001b[0m | \u001b[0m 0.7229 \u001b[0m | \u001b[0m-0.02875 \u001b[0m | \u001b[0m 13.97 \u001b[0m |\n", "| \u001b[0m 101 \u001b[0m | \u001b[0m 0.7317 \u001b[0m | \u001b[0m-0.0317 \u001b[0m | \u001b[0m 22.57 \u001b[0m |\n", "| \u001b[0m 102 \u001b[0m | \u001b[0m 0.725 \u001b[0m | \u001b[0m-0.003994\u001b[0m | \u001b[0m 27.3 \u001b[0m |\n", "| \u001b[0m 103 \u001b[0m | \u001b[0m 0.7317 \u001b[0m | \u001b[0m-0.02606 \u001b[0m | \u001b[0m 13.97 \u001b[0m |\n", "| \u001b[0m 104 \u001b[0m | \u001b[0m 0.7317 \u001b[0m | \u001b[0m-0.03203 \u001b[0m | \u001b[0m 22.56 \u001b[0m |\n", "| \u001b[0m 105 \u001b[0m | \u001b[0m 0.6667 \u001b[0m | \u001b[0m-0.01108 \u001b[0m | \u001b[0m 23.7 \u001b[0m |\n", "| \u001b[0m 106 \u001b[0m | \u001b[0m 0.7229 \u001b[0m | \u001b[0m-0.03034 \u001b[0m | \u001b[0m 13.97 \u001b[0m |\n", "| \u001b[0m 107 \u001b[0m | \u001b[0m 0.7273 \u001b[0m | \u001b[0m-0.02879 \u001b[0m | \u001b[0m 22.56 \u001b[0m |\n", "| \u001b[0m 108 \u001b[0m | \u001b[0m 0.725 \u001b[0m | \u001b[0m 0.001284\u001b[0m | \u001b[0m 27.3 \u001b[0m |\n", "| \u001b[0m 109 \u001b[0m | \u001b[0m 0.6977 \u001b[0m | \u001b[0m-0.02414 \u001b[0m | \u001b[0m 13.96 \u001b[0m |\n", "| \u001b[0m 110 \u001b[0m | \u001b[0m 0.7229 \u001b[0m | \u001b[0m-0.02835 \u001b[0m | \u001b[0m 13.96 \u001b[0m |\n", "| \u001b[0m 111 \u001b[0m | \u001b[0m 0.7317 \u001b[0m | \u001b[0m-0.02569 \u001b[0m | \u001b[0m 13.97 \u001b[0m |\n", "| \u001b[0m 112 \u001b[0m | \u001b[0m 0.7059 \u001b[0m | \u001b[0m-0.03629 \u001b[0m | \u001b[0m 22.56 \u001b[0m |\n", "| \u001b[0m 113 \u001b[0m | \u001b[0m 0.7317 \u001b[0m | \u001b[0m-0.03362 \u001b[0m | \u001b[0m 22.55 \u001b[0m |\n", "| \u001b[0m 114 \u001b[0m | \u001b[0m 0.7297 \u001b[0m | \u001b[0m-0.0264 \u001b[0m | \u001b[0m 22.55 \u001b[0m |\n", "| \u001b[0m 115 \u001b[0m | \u001b[0m 0.7105 \u001b[0m | \u001b[0m-0.02175 \u001b[0m | \u001b[0m 22.55 \u001b[0m |\n", "| \u001b[0m 116 \u001b[0m | \u001b[0m 0.6753 \u001b[0m | \u001b[0m 0.02889 \u001b[0m | \u001b[0m 20.23 \u001b[0m |\n", "| \u001b[0m 117 \u001b[0m | \u001b[0m 0.7105 \u001b[0m | \u001b[0m-0.03839 \u001b[0m | \u001b[0m 22.55 \u001b[0m |\n", "| \u001b[0m 118 \u001b[0m | \u001b[0m 0.6494 \u001b[0m | \u001b[0m-0.00918 \u001b[0m | \u001b[0m 27.3 \u001b[0m |\n", "| \u001b[0m 119 \u001b[0m | \u001b[0m 0.7027 \u001b[0m | \u001b[0m 0.02998 \u001b[0m | \u001b[0m 27.67 \u001b[0m |\n", "| \u001b[0m 120 \u001b[0m | \u001b[0m 0.6818 \u001b[0m | \u001b[0m-0.01368 \u001b[0m | \u001b[0m 10.26 \u001b[0m |\n", "| \u001b[0m 121 \u001b[0m | \u001b[0m 0.7229 \u001b[0m | \u001b[0m-0.02186 \u001b[0m | \u001b[0m 13.98 \u001b[0m |\n", "| \u001b[0m 122 \u001b[0m | \u001b[0m 0.7273 \u001b[0m | \u001b[0m-0.02985 \u001b[0m | \u001b[0m 22.55 \u001b[0m |\n", "| \u001b[0m 123 \u001b[0m | \u001b[0m 0.72 \u001b[0m | \u001b[0m 0.01326 \u001b[0m | \u001b[0m 17.85 \u001b[0m |\n", "| \u001b[0m 124 \u001b[0m | \u001b[0m 0.7073 \u001b[0m | \u001b[0m-0.03763 \u001b[0m | \u001b[0m 12.63 \u001b[0m |\n", "| \u001b[0m 125 \u001b[0m | \u001b[0m 0.7317 \u001b[0m | \u001b[0m-0.02649 \u001b[0m | \u001b[0m 13.98 \u001b[0m |\n", "| \u001b[0m 126 \u001b[0m | \u001b[0m 0.725 \u001b[0m | \u001b[0m 0.000708\u001b[0m | \u001b[0m 27.31 \u001b[0m |\n", "| \u001b[0m 127 \u001b[0m | \u001b[0m 0.7073 \u001b[0m | \u001b[0m-0.04029 \u001b[0m | \u001b[0m 13.49 \u001b[0m |\n", "| \u001b[0m 128 \u001b[0m | \u001b[0m 0.6818 \u001b[0m | \u001b[0m-0.0342 \u001b[0m | \u001b[0m 19.62 \u001b[0m |\n", "| \u001b[0m 129 \u001b[0m | \u001b[0m 0.6977 \u001b[0m | \u001b[0m-0.02281 \u001b[0m | \u001b[0m 13.97 \u001b[0m |\n", "| \u001b[0m 130 \u001b[0m | \u001b[0m 0.7342 \u001b[0m | \u001b[0m-0.04295 \u001b[0m | \u001b[0m 20.19 \u001b[0m |\n", "| \u001b[0m 131 \u001b[0m | \u001b[0m 0.7342 \u001b[0m | \u001b[0m-0.04592 \u001b[0m | \u001b[0m 20.19 \u001b[0m |\n", "| \u001b[0m 132 \u001b[0m | \u001b[0m 0.7342 \u001b[0m | \u001b[0m-0.0392 \u001b[0m | \u001b[0m 20.18 \u001b[0m |\n", "| \u001b[0m 133 \u001b[0m | \u001b[0m 0.6842 \u001b[0m | \u001b[0m 0.002835\u001b[0m | \u001b[0m 11.47 \u001b[0m |\n", "| \u001b[0m 134 \u001b[0m | \u001b[0m 0.7105 \u001b[0m | \u001b[0m-0.022 \u001b[0m | \u001b[0m 22.56 \u001b[0m |\n", "| \u001b[0m 135 \u001b[0m | \u001b[0m 0.7317 \u001b[0m | \u001b[0m-0.03169 \u001b[0m | \u001b[0m 22.55 \u001b[0m |\n", "| \u001b[0m 136 \u001b[0m | \u001b[0m 0.7342 \u001b[0m | \u001b[0m-0.04505 \u001b[0m | \u001b[0m 20.19 \u001b[0m |\n", "| \u001b[0m 137 \u001b[0m | \u001b[0m 0.6923 \u001b[0m | \u001b[0m-0.01419 \u001b[0m | \u001b[0m 22.83 \u001b[0m |\n", "| \u001b[0m 138 \u001b[0m | \u001b[0m 0.6966 \u001b[0m | \u001b[0m-0.03732 \u001b[0m | \u001b[0m 18.91 \u001b[0m |\n", "| \u001b[0m 139 \u001b[0m | \u001b[0m 0.6977 \u001b[0m | \u001b[0m-0.03507 \u001b[0m | \u001b[0m 20.18 \u001b[0m |\n", "| \u001b[0m 140 \u001b[0m | \u001b[0m 0.7229 \u001b[0m | \u001b[0m-0.02949 \u001b[0m | \u001b[0m 13.97 \u001b[0m |\n", "| \u001b[0m 141 \u001b[0m | \u001b[0m 0.7143 \u001b[0m | \u001b[0m-0.01192 \u001b[0m | \u001b[0m 14.29 \u001b[0m |\n", "| \u001b[95m 142 \u001b[0m | \u001b[95m 0.7436 \u001b[0m | \u001b[95m-0.04955 \u001b[0m | \u001b[95m 20.19 \u001b[0m |\n", "| \u001b[0m 143 \u001b[0m | \u001b[0m 0.7317 \u001b[0m | \u001b[0m-0.02579 \u001b[0m | \u001b[0m 13.98 \u001b[0m |\n", "| \u001b[0m 144 \u001b[0m | \u001b[0m 0.7059 \u001b[0m | \u001b[0m-0.03712 \u001b[0m | \u001b[0m 22.55 \u001b[0m |\n", "| \u001b[0m 145 \u001b[0m | \u001b[0m 0.7436 \u001b[0m | \u001b[0m-0.04984 \u001b[0m | \u001b[0m 20.19 \u001b[0m |\n", "| \u001b[0m 146 \u001b[0m | \u001b[0m 0.7342 \u001b[0m | \u001b[0m-0.04167 \u001b[0m | \u001b[0m 20.18 \u001b[0m |\n", "| \u001b[0m 147 \u001b[0m | \u001b[0m 0.7105 \u001b[0m | \u001b[0m-0.03834 \u001b[0m | \u001b[0m 22.59 \u001b[0m |\n", "| \u001b[0m 148 \u001b[0m | \u001b[0m 0.7342 \u001b[0m | \u001b[0m-0.04779 \u001b[0m | \u001b[0m 20.2 \u001b[0m |\n", "| \u001b[0m 149 \u001b[0m | \u001b[0m 0.6494 \u001b[0m | \u001b[0m-0.0114 \u001b[0m | \u001b[0m 27.3 \u001b[0m |\n", "| \u001b[0m 150 \u001b[0m | \u001b[0m 0.7342 \u001b[0m | \u001b[0m-0.04754 \u001b[0m | \u001b[0m 20.18 \u001b[0m |\n", "| \u001b[0m 151 \u001b[0m | \u001b[0m 0.7229 \u001b[0m | \u001b[0m-0.02047 \u001b[0m | \u001b[0m 11.35 \u001b[0m |\n", "| \u001b[0m 152 \u001b[0m | \u001b[0m 0.7229 \u001b[0m | \u001b[0m-0.02718 \u001b[0m | \u001b[0m 13.98 \u001b[0m |\n", "| \u001b[0m 153 \u001b[0m | \u001b[0m 0.7342 \u001b[0m | \u001b[0m-0.04512 \u001b[0m | \u001b[0m 20.18 \u001b[0m |\n", "| \u001b[0m 154 \u001b[0m | \u001b[0m 0.7294 \u001b[0m | \u001b[0m-0.0198 \u001b[0m | \u001b[0m 19.62 \u001b[0m |\n", "| \u001b[0m 155 \u001b[0m | \u001b[0m 0.7294 \u001b[0m | \u001b[0m-0.02184 \u001b[0m | \u001b[0m 19.61 \u001b[0m |\n", "| \u001b[95m 156 \u001b[0m | \u001b[95m 0.7654 \u001b[0m | \u001b[95m-0.02304 \u001b[0m | \u001b[95m 19.61 \u001b[0m |\n", "| \u001b[0m 157 \u001b[0m | \u001b[0m 0.7294 \u001b[0m | \u001b[0m-0.01931 \u001b[0m | \u001b[0m 19.61 \u001b[0m |\n", "| \u001b[0m 158 \u001b[0m | \u001b[0m 0.6966 \u001b[0m | \u001b[0m-0.03566 \u001b[0m | \u001b[0m 18.6 \u001b[0m |\n", "| \u001b[0m 159 \u001b[0m | \u001b[0m 0.7436 \u001b[0m | \u001b[0m-0.04827 \u001b[0m | \u001b[0m 20.2 \u001b[0m |\n", "| \u001b[0m 160 \u001b[0m | \u001b[0m 0.6923 \u001b[0m | \u001b[0m-0.02572 \u001b[0m | \u001b[0m 19.61 \u001b[0m |\n", "| \u001b[0m 161 \u001b[0m | \u001b[0m 0.7342 \u001b[0m | \u001b[0m-0.04471 \u001b[0m | \u001b[0m 20.18 \u001b[0m |\n", "| \u001b[0m 162 \u001b[0m | \u001b[0m 0.7342 \u001b[0m | \u001b[0m-0.04209 \u001b[0m | \u001b[0m 20.18 \u001b[0m |\n", "| \u001b[0m 163 \u001b[0m | \u001b[0m 0.6316 \u001b[0m | \u001b[0m-0.01572 \u001b[0m | \u001b[0m 24.41 \u001b[0m |\n", "| \u001b[0m 164 \u001b[0m | \u001b[0m 0.7342 \u001b[0m | \u001b[0m-0.04472 \u001b[0m | \u001b[0m 20.17 \u001b[0m |\n", "| \u001b[0m 165 \u001b[0m | \u001b[0m 0.6966 \u001b[0m | \u001b[0m-0.02401 \u001b[0m | \u001b[0m 19.62 \u001b[0m |\n", "| \u001b[0m 166 \u001b[0m | \u001b[0m 0.7229 \u001b[0m | \u001b[0m-0.01921 \u001b[0m | \u001b[0m 13.98 \u001b[0m |\n", "| \u001b[0m 167 \u001b[0m | \u001b[0m 0.7229 \u001b[0m | \u001b[0m-0.03052 \u001b[0m | \u001b[0m 13.98 \u001b[0m |\n", "| \u001b[0m 168 \u001b[0m | \u001b[0m 0.7342 \u001b[0m | \u001b[0m-0.04705 \u001b[0m | \u001b[0m 20.2 \u001b[0m |\n", "| \u001b[0m 169 \u001b[0m | \u001b[0m 0.7 \u001b[0m | \u001b[0m 0.04646 \u001b[0m | \u001b[0m 12.87 \u001b[0m |\n", "| \u001b[0m 170 \u001b[0m | \u001b[0m 0.6923 \u001b[0m | \u001b[0m-0.02636 \u001b[0m | \u001b[0m 19.62 \u001b[0m |\n", "| \u001b[0m 171 \u001b[0m | \u001b[0m 0.7436 \u001b[0m | \u001b[0m-0.04914 \u001b[0m | \u001b[0m 20.17 \u001b[0m |\n", "| \u001b[0m 172 \u001b[0m | \u001b[0m 0.7342 \u001b[0m | \u001b[0m-0.04669 \u001b[0m | \u001b[0m 20.17 \u001b[0m |\n", "| \u001b[0m 173 \u001b[0m | \u001b[0m 0.7342 \u001b[0m | \u001b[0m-0.04572 \u001b[0m | \u001b[0m 20.2 \u001b[0m |\n", "| \u001b[0m 174 \u001b[0m | \u001b[0m 0.7273 \u001b[0m | \u001b[0m-0.04561 \u001b[0m | \u001b[0m 18.47 \u001b[0m |\n", "| \u001b[95m 175 \u001b[0m | \u001b[95m 0.7848 \u001b[0m | \u001b[95m 0.04772 \u001b[0m | \u001b[95m 17.78 \u001b[0m |\n", "| \u001b[0m 176 \u001b[0m | \u001b[0m 0.7848 \u001b[0m | \u001b[0m 0.04406 \u001b[0m | \u001b[0m 17.78 \u001b[0m |\n", "| \u001b[0m 177 \u001b[0m | \u001b[0m 0.7848 \u001b[0m | \u001b[0m 0.04471 \u001b[0m | \u001b[0m 17.78 \u001b[0m |\n", "| \u001b[0m 178 \u001b[0m | \u001b[0m 0.7317 \u001b[0m | \u001b[0m 0.03386 \u001b[0m | \u001b[0m 18.93 \u001b[0m |\n", "| \u001b[0m 179 \u001b[0m | \u001b[0m 0.7632 \u001b[0m | \u001b[0m 0.04011 \u001b[0m | \u001b[0m 18.93 \u001b[0m |\n", "| \u001b[0m 180 \u001b[0m | \u001b[0m 0.7848 \u001b[0m | \u001b[0m 0.04769 \u001b[0m | \u001b[0m 17.78 \u001b[0m |\n", "| \u001b[0m 181 \u001b[0m | \u001b[0m 0.7317 \u001b[0m | \u001b[0m 0.03206 \u001b[0m | \u001b[0m 18.94 \u001b[0m |\n", "| \u001b[0m 182 \u001b[0m | \u001b[0m 0.7532 \u001b[0m | \u001b[0m 0.04485 \u001b[0m | \u001b[0m 18.92 \u001b[0m |\n", "| \u001b[0m 183 \u001b[0m | \u001b[0m 0.7632 \u001b[0m | \u001b[0m 0.042 \u001b[0m | \u001b[0m 18.93 \u001b[0m |\n", "| \u001b[0m 184 \u001b[0m | \u001b[0m 0.72 \u001b[0m | \u001b[0m 0.01095 \u001b[0m | \u001b[0m 17.86 \u001b[0m |\n", "| \u001b[0m 185 \u001b[0m | \u001b[0m 0.7143 \u001b[0m | \u001b[0m-0.04837 \u001b[0m | \u001b[0m 15.47 \u001b[0m |\n", "| \u001b[0m 186 \u001b[0m | \u001b[0m 0.7848 \u001b[0m | \u001b[0m 0.0473 \u001b[0m | \u001b[0m 17.78 \u001b[0m |\n", "| \u001b[0m 187 \u001b[0m | \u001b[0m 0.6829 \u001b[0m | \u001b[0m-0.0407 \u001b[0m | \u001b[0m 23.65 \u001b[0m |\n", "| \u001b[0m 188 \u001b[0m | \u001b[0m 0.6923 \u001b[0m | \u001b[0m-0.01221 \u001b[0m | \u001b[0m 26.04 \u001b[0m |\n", "| \u001b[0m 189 \u001b[0m | \u001b[0m 0.7532 \u001b[0m | \u001b[0m 0.04529 \u001b[0m | \u001b[0m 18.94 \u001b[0m |\n", "| \u001b[0m 190 \u001b[0m | \u001b[0m 0.7848 \u001b[0m | \u001b[0m 0.04348 \u001b[0m | \u001b[0m 17.79 \u001b[0m |\n", "| \u001b[0m 191 \u001b[0m | \u001b[0m 0.7 \u001b[0m | \u001b[0m 0.04061 \u001b[0m | \u001b[0m 12.46 \u001b[0m |\n", "| \u001b[0m 192 \u001b[0m | \u001b[0m 0.7848 \u001b[0m | \u001b[0m 0.04312 \u001b[0m | \u001b[0m 17.79 \u001b[0m |\n", "| \u001b[0m 193 \u001b[0m | \u001b[0m 0.7532 \u001b[0m | \u001b[0m 0.04991 \u001b[0m | \u001b[0m 18.93 \u001b[0m |\n", "| \u001b[0m 194 \u001b[0m | \u001b[0m 0.7848 \u001b[0m | \u001b[0m 0.04101 \u001b[0m | \u001b[0m 17.79 \u001b[0m |\n", "| \u001b[0m 195 \u001b[0m | \u001b[0m 0.7073 \u001b[0m | \u001b[0m 0.0367 \u001b[0m | \u001b[0m 17.79 \u001b[0m |\n", "| \u001b[0m 196 \u001b[0m | \u001b[0m 0.7848 \u001b[0m | \u001b[0m 0.0435 \u001b[0m | \u001b[0m 17.78 \u001b[0m |\n", "| \u001b[0m 197 \u001b[0m | \u001b[0m 0.6923 \u001b[0m | \u001b[0m 0.02793 \u001b[0m | \u001b[0m 24.72 \u001b[0m |\n", "| \u001b[0m 198 \u001b[0m | \u001b[0m 0.7013 \u001b[0m | \u001b[0m 0.01218 \u001b[0m | \u001b[0m 22.56 \u001b[0m |\n", "| \u001b[0m 199 \u001b[0m | \u001b[0m 0.7073 \u001b[0m | \u001b[0m 0.007552\u001b[0m | \u001b[0m 13.13 \u001b[0m |\n", "| \u001b[0m 200 \u001b[0m | \u001b[0m 0.6761 \u001b[0m | \u001b[0m 0.03671 \u001b[0m | \u001b[0m 28.28 \u001b[0m |\n", "| \u001b[0m 201 \u001b[0m | \u001b[0m 0.7105 \u001b[0m | \u001b[0m 0.03921 \u001b[0m | \u001b[0m 18.93 \u001b[0m |\n", "| \u001b[0m 202 \u001b[0m | \u001b[0m 0.7848 \u001b[0m | \u001b[0m 0.04867 \u001b[0m | \u001b[0m 17.78 \u001b[0m |\n", "| \u001b[0m 203 \u001b[0m | \u001b[0m 0.7436 \u001b[0m | \u001b[0m 0.03745 \u001b[0m | \u001b[0m 18.93 \u001b[0m |\n", "| \u001b[0m 204 \u001b[0m | \u001b[0m 0.7532 \u001b[0m | \u001b[0m 0.04703 \u001b[0m | \u001b[0m 18.93 \u001b[0m |\n", "| \u001b[0m 205 \u001b[0m | \u001b[0m 0.7317 \u001b[0m | \u001b[0m 0.02761 \u001b[0m | \u001b[0m 18.92 \u001b[0m |\n", "| \u001b[0m 206 \u001b[0m | \u001b[0m 0.7532 \u001b[0m | \u001b[0m 0.04951 \u001b[0m | \u001b[0m 18.93 \u001b[0m |\n", "| \u001b[0m 207 \u001b[0m | \u001b[0m 0.7848 \u001b[0m | \u001b[0m 0.04445 \u001b[0m | \u001b[0m 17.77 \u001b[0m |\n", "| \u001b[0m 208 \u001b[0m | \u001b[0m 0.7848 \u001b[0m | \u001b[0m 0.04138 \u001b[0m | \u001b[0m 17.79 \u001b[0m |\n", "| \u001b[0m 209 \u001b[0m | \u001b[0m 0.6667 \u001b[0m | \u001b[0m-0.02362 \u001b[0m | \u001b[0m 23.7 \u001b[0m |\n", "| \u001b[0m 210 \u001b[0m | \u001b[0m 0.7632 \u001b[0m | \u001b[0m 0.04247 \u001b[0m | \u001b[0m 18.93 \u001b[0m |\n", "=================================================\n", "max\n", "{'target': 0.7848101265822784, 'params': {'learning_rate': 0.047715766463314324, 'n_estimators': 17.779424609189796}}\n" ] } ], "source": [ "from bayes_opt import BayesianOptimization\n", "from sklearn.metrics import f1_score\n", "\n", "# Basic Example : https://github.com/fmfn/BayesianOptimization/blob/master/examples/basic-tour.ipynb\n", "\n", "def black_box_function(n_estimators, learning_rate=0):\n", " model = AdaBoostClassifier(n_estimators = int(n_estimators),\n", " learning_rate = 10**learning_rate,\n", " random_state = 42)\n", " model.fit(x_train_res , y_train_res)\n", " y_pred = model.predict(X_test)\n", " return f1_score(y_test, y_pred)\n", "\n", "pbounds = {'n_estimators':(10, 30), 'learning_rate':(-0.05, 0.05)}\n", "\n", "optimizer = BayesianOptimization(\n", " f=black_box_function,\n", " pbounds=pbounds,\n", " verbose=2, # verbose = 1 prints only when a maximum is observed, verbose = 0 is silent\n", " random_state=1,\n", ")\n", "\n", "optimizer.maximize(\n", " init_points=10,\n", " n_iter=200,\n", ")\n", "\n", "print('max')\n", "\n", "print(optimizer.max)" ] }, { "cell_type": "code", "execution_count": 19, "metadata": {}, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ "F1 0.7848101265822784\n precision recall f1-score support\n\n non résilié 0.98 0.92 0.95 166\n resilié 0.69 0.91 0.78 34\n\n accuracy 0.92 200\n macro avg 0.83 0.91 0.87 200\nweighted avg 0.93 0.92 0.92 200\n\n" ] } ], "source": [ "model = AdaBoostClassifier(n_estimators = int(optimizer.max['params']['n_estimators']),\n", " learning_rate = 10**optimizer.max['params']['learning_rate'],\n", " random_state = 42)\n", "model.fit(x_train_res , y_train_res)\n", "y_pred = model.predict(X_test)\n", "print(\"F1\", f1_score(y_test, y_pred))\n", "print(classification_report(y_test, y_pred,target_names=target_names))" ] }, { "cell_type": "code", "execution_count": 20, "metadata": {}, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "0.2733333333333333" ] }, "metadata": {}, "execution_count": 20 } ], "source": [ "yscore = model.predict(Xscore)\n", "np.mean(yscore)" ] }, { "cell_type": "code", "execution_count": 21, "metadata": {}, "outputs": [], "source": [ "yDF = pd.DataFrame(data = yscore.astype(int), columns=['target'])\n", "yDF.index+=1000\n", "yDF.to_csv(\"result_schindler_hugo.csv\")" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ] }