Load-best-model.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "from sklearn.model_selection import train_test_split\n",
    "import xgboost as xgb\n",
    "from joblib import dump, load\n",
    "from xgboost import XGBClassifier"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "def warn(*args, **kwargs):\n",
    "    pass\n",
    "import warnings\n",
    "warnings.warn = warn"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Data reading, data cleaning\n",
    "data = pd.read_csv('dataset.csv',sep = ';') \n",
    "data = data.replace('unknown', np.nan)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "#categoricat variables\n",
    "data['education'] = data['education'].fillna(data['education'].mode()[0])\n",
    "data['job'] = data['job'].fillna(data['job'].mode()[0])\n",
    "data['marital'] = data['marital'].fillna(data['marital'].mode()[0])\n",
    "data['housing'] = data['housing'].fillna(data['housing'].mode()[0])\n",
    "data['default'] = data['default'].fillna(data['default'].mode()[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "#mean encoder\n",
    "data['y'].replace({\"no\":0, \"yes\":1}, inplace=True)\n",
    "\n",
    "Mean_encoded_job = data.groupby(['job'])['y'].mean().to_dict()   \n",
    "data['job'] =  data['job'].map(Mean_encoded_job) \n",
    "\n",
    "Mean_encoded_marital = data.groupby(['marital'])['y'].mean().to_dict()   \n",
    "data['marital'] =  data['marital'].map(Mean_encoded_marital) \n",
    "\n",
    "Mean_encoded_default = data.groupby(['default'])['y'].mean().to_dict()   \n",
    "data['default'] =  data['default'].map(Mean_encoded_default)\n",
    "\n",
    "Mean_encoded_housing = data.groupby(['housing'])['y'].mean().to_dict()   \n",
    "data['housing'] =  data['housing'].map(Mean_encoded_housing)\n",
    "\n",
    "Mean_encoded_loan = data.groupby(['loan'])['y'].mean().to_dict()   \n",
    "data['loan'] =  data['loan'].map(Mean_encoded_loan)\n",
    "\n",
    "Mean_encoded_contact = data.groupby(['contact'])['y'].mean().to_dict()   \n",
    "data['contact'] =  data['contact'].map(Mean_encoded_contact)\n",
    "\n",
    "Mean_encoded_month = data.groupby(['month'])['y'].mean().to_dict()   \n",
    "data['month'] =  data['month'].map(Mean_encoded_month)\n",
    "\n",
    "Mean_encoded_poutcome = data.groupby(['poutcome'])['y'].mean().to_dict()   \n",
    "data['poutcome'] =  data['poutcome'].map(Mean_encoded_poutcome)\n",
    "\n",
    "Mean_encoded_day_of_week = data.groupby(['day_of_week'])['y'].mean().to_dict()   \n",
    "data['day_of_week'] =  data['day_of_week'].map(Mean_encoded_day_of_week)\n",
    " \n",
    "Mean_encoded_education = data.groupby(['education'])['y'].mean().to_dict()   \n",
    "data['education'] =  data['education'].map(Mean_encoded_education)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_drop = pd.DataFrame()\n",
    "data_drop = data\n",
    "data_drop.fillna(data_drop.mean(), inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "XGBClassifier(base_score=0.5, booster=None, class_weight='balanced',\n",
       "              colsample_bylevel=1, colsample_bynode=1, colsample_bytree=1,\n",
       "              gamma=0, gpu_id=-1, importance_type='gain',\n",
       "              interaction_constraints=None, learning_rate=0.300000012,\n",
       "              max_delta_step=0, max_depth=5, min_child_weight=1, missing=nan,\n",
       "              monotone_constraints=None, n_estimators=100, n_jobs=-1,\n",
       "              num_parallel_tree=1, random_state=0, reg_alpha=0, reg_lambda=1,\n",
       "              scale_pos_weight=1, subsample=1, tree_method=None,\n",
       "              validate_parameters=False, verbosity=None)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#train test split\n",
    "y = data_drop[['y']]\n",
    "X = data_drop.drop(['y'], axis=1)\n",
    "\n",
    "X_train, X_test, y_train, y_test = train_test_split(X, y, test_size=0.2, random_state=1)\n",
    "\n",
    "clf = xgb.XGBClassifier(max_depth=5, n_estimators=100 ,class_weight='balanced', n_jobs=-1)\n",
    "clf.fit(X_train.to_numpy(), y_train.to_numpy())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[ 3.00000000e+01,  6.89431597e-02,  1.01727447e-01, ...,\n",
       "        -4.62000000e+01,  1.29900000e+00,  5.09910000e+03],\n",
       "       [ 5.80000000e+01,  8.13807004e-02,  1.01727447e-01, ...,\n",
       "        -3.48000000e+01,  6.35000000e-01,  5.00870000e+03],\n",
       "       [ 3.20000000e+01,  6.89431597e-02,  1.03209020e-01, ...,\n",
       "        -4.27000000e+01,  4.96300000e+00,  5.22810000e+03],\n",
       "       ...,\n",
       "       [ 3.60000000e+01,  6.89431597e-02,  1.01727447e-01, ...,\n",
       "        -3.64000000e+01,  4.85700000e+00,  5.19100000e+03],\n",
       "       [ 3.70000000e+01,  1.29185268e-01,  1.01727447e-01, ...,\n",
       "        -4.27000000e+01,  4.95500000e+00,  5.22810000e+03],\n",
       "       [ 3.50000000e+01,  6.89431597e-02,  1.40041494e-01, ...,\n",
       "        -4.62000000e+01,  1.29900000e+00,  5.09910000e+03]])"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "X_train.to_numpy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pickle\n",
    "pickle.dump(clf, open(\"model.dat\", \"wb\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "loaded_model = pickle.load(open(\"model.dat\", \"rb\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([0, 0, 0, ..., 0, 0, 0], dtype=int64)"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "loaded_model.predict(X_test.to_numpy())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>age</th>\n",
       "      <th>job</th>\n",
       "      <th>marital</th>\n",
       "      <th>education</th>\n",
       "      <th>default</th>\n",
       "      <th>housing</th>\n",
       "      <th>loan</th>\n",
       "      <th>contact</th>\n",
       "      <th>month</th>\n",
       "      <th>day_of_week</th>\n",
       "      <th>duration</th>\n",
       "      <th>campaign</th>\n",
       "      <th>pdays</th>\n",
       "      <th>previous</th>\n",
       "      <th>poutcome</th>\n",
       "      <th>emp.var.rate</th>\n",
       "      <th>cons.price.idx</th>\n",
       "      <th>cons.conf.idx</th>\n",
       "      <th>euribor3m</th>\n",
       "      <th>nr.employed</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>35577</th>\n",
       "      <td>32</td>\n",
       "      <td>0.068943</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.078246</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.109315</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.099483</td>\n",
       "      <td>114</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>92.893</td>\n",
       "      <td>-46.2</td>\n",
       "      <td>1.244</td>\n",
       "      <td>5099.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13950</th>\n",
       "      <td>33</td>\n",
       "      <td>0.068943</td>\n",
       "      <td>0.140041</td>\n",
       "      <td>0.082024</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.109315</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.090466</td>\n",
       "      <td>0.108087</td>\n",
       "      <td>103</td>\n",
       "      <td>2</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.4</td>\n",
       "      <td>93.918</td>\n",
       "      <td>-42.7</td>\n",
       "      <td>4.963</td>\n",
       "      <td>5228.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29451</th>\n",
       "      <td>25</td>\n",
       "      <td>0.104856</td>\n",
       "      <td>0.103209</td>\n",
       "      <td>0.138211</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.204787</td>\n",
       "      <td>0.099483</td>\n",
       "      <td>227</td>\n",
       "      <td>5</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>93.075</td>\n",
       "      <td>-47.1</td>\n",
       "      <td>1.405</td>\n",
       "      <td>5099.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32295</th>\n",
       "      <td>34</td>\n",
       "      <td>0.068943</td>\n",
       "      <td>0.140041</td>\n",
       "      <td>0.108355</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.108087</td>\n",
       "      <td>56</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>92.893</td>\n",
       "      <td>-46.2</td>\n",
       "      <td>1.313</td>\n",
       "      <td>5099.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27477</th>\n",
       "      <td>53</td>\n",
       "      <td>0.108260</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.113485</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.101439</td>\n",
       "      <td>0.108087</td>\n",
       "      <td>11</td>\n",
       "      <td>7</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>-0.1</td>\n",
       "      <td>93.200</td>\n",
       "      <td>-42.0</td>\n",
       "      <td>4.021</td>\n",
       "      <td>5195.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31507</th>\n",
       "      <td>46</td>\n",
       "      <td>0.081381</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.078246</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.108796</td>\n",
       "      <td>0.109315</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.116671</td>\n",
       "      <td>227</td>\n",
       "      <td>2</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>92.893</td>\n",
       "      <td>-46.2</td>\n",
       "      <td>1.334</td>\n",
       "      <td>5099.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32167</th>\n",
       "      <td>33</td>\n",
       "      <td>0.108260</td>\n",
       "      <td>0.140041</td>\n",
       "      <td>0.113485</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.108087</td>\n",
       "      <td>70</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>92.893</td>\n",
       "      <td>-46.2</td>\n",
       "      <td>1.313</td>\n",
       "      <td>5099.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24580</th>\n",
       "      <td>46</td>\n",
       "      <td>0.108260</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.108355</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.101439</td>\n",
       "      <td>0.099483</td>\n",
       "      <td>171</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>1</td>\n",
       "      <td>0.142286</td>\n",
       "      <td>-0.1</td>\n",
       "      <td>93.200</td>\n",
       "      <td>-42.0</td>\n",
       "      <td>4.191</td>\n",
       "      <td>5195.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2954</th>\n",
       "      <td>42</td>\n",
       "      <td>0.108260</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.113485</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.108796</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.116671</td>\n",
       "      <td>295</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.859</td>\n",
       "      <td>5191.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34998</th>\n",
       "      <td>30</td>\n",
       "      <td>0.081381</td>\n",
       "      <td>0.140041</td>\n",
       "      <td>0.108355</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.108087</td>\n",
       "      <td>159</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>92.893</td>\n",
       "      <td>-46.2</td>\n",
       "      <td>1.250</td>\n",
       "      <td>5099.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2045</th>\n",
       "      <td>59</td>\n",
       "      <td>0.068943</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.102490</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.108796</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.099483</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.857</td>\n",
       "      <td>5191.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15794</th>\n",
       "      <td>40</td>\n",
       "      <td>0.068943</td>\n",
       "      <td>0.140041</td>\n",
       "      <td>0.078246</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.090466</td>\n",
       "      <td>0.099483</td>\n",
       "      <td>824</td>\n",
       "      <td>5</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.4</td>\n",
       "      <td>93.918</td>\n",
       "      <td>-42.7</td>\n",
       "      <td>4.960</td>\n",
       "      <td>5228.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12405</th>\n",
       "      <td>32</td>\n",
       "      <td>0.068943</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.082024</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.108796</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.090466</td>\n",
       "      <td>0.099483</td>\n",
       "      <td>176</td>\n",
       "      <td>6</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.4</td>\n",
       "      <td>93.918</td>\n",
       "      <td>-42.7</td>\n",
       "      <td>4.960</td>\n",
       "      <td>5228.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26549</th>\n",
       "      <td>58</td>\n",
       "      <td>0.068943</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.078246</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.101439</td>\n",
       "      <td>0.121188</td>\n",
       "      <td>308</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>0.651129</td>\n",
       "      <td>-0.1</td>\n",
       "      <td>93.200</td>\n",
       "      <td>-42.0</td>\n",
       "      <td>4.076</td>\n",
       "      <td>5195.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23028</th>\n",
       "      <td>49</td>\n",
       "      <td>0.129185</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.138211</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.106021</td>\n",
       "      <td>0.117800</td>\n",
       "      <td>62</td>\n",
       "      <td>2</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.4</td>\n",
       "      <td>93.444</td>\n",
       "      <td>-36.1</td>\n",
       "      <td>4.965</td>\n",
       "      <td>5228.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19991</th>\n",
       "      <td>44</td>\n",
       "      <td>0.104856</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.113485</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.112767</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.106021</td>\n",
       "      <td>0.108087</td>\n",
       "      <td>179</td>\n",
       "      <td>3</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.4</td>\n",
       "      <td>93.444</td>\n",
       "      <td>-36.1</td>\n",
       "      <td>4.966</td>\n",
       "      <td>5228.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21393</th>\n",
       "      <td>40</td>\n",
       "      <td>0.108260</td>\n",
       "      <td>0.140041</td>\n",
       "      <td>0.138211</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.106021</td>\n",
       "      <td>0.117800</td>\n",
       "      <td>173</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.4</td>\n",
       "      <td>93.444</td>\n",
       "      <td>-36.1</td>\n",
       "      <td>4.963</td>\n",
       "      <td>5228.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8777</th>\n",
       "      <td>55</td>\n",
       "      <td>0.100000</td>\n",
       "      <td>0.103209</td>\n",
       "      <td>0.138211</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.105115</td>\n",
       "      <td>0.121188</td>\n",
       "      <td>221</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.4</td>\n",
       "      <td>94.465</td>\n",
       "      <td>-41.8</td>\n",
       "      <td>4.866</td>\n",
       "      <td>5228.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32235</th>\n",
       "      <td>41</td>\n",
       "      <td>0.129185</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.138211</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.108087</td>\n",
       "      <td>114</td>\n",
       "      <td>2</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>92.893</td>\n",
       "      <td>-46.2</td>\n",
       "      <td>1.313</td>\n",
       "      <td>5099.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1475</th>\n",
       "      <td>38</td>\n",
       "      <td>0.104856</td>\n",
       "      <td>0.140041</td>\n",
       "      <td>0.138211</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.108796</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.121188</td>\n",
       "      <td>459</td>\n",
       "      <td>2</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.855</td>\n",
       "      <td>5191.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1714</th>\n",
       "      <td>49</td>\n",
       "      <td>0.129185</td>\n",
       "      <td>0.103209</td>\n",
       "      <td>0.108355</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.108087</td>\n",
       "      <td>137</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.855</td>\n",
       "      <td>5191.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36717</th>\n",
       "      <td>31</td>\n",
       "      <td>0.112175</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.138211</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.108796</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.105115</td>\n",
       "      <td>0.108087</td>\n",
       "      <td>614</td>\n",
       "      <td>2</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>-2.9</td>\n",
       "      <td>92.963</td>\n",
       "      <td>-40.8</td>\n",
       "      <td>1.268</td>\n",
       "      <td>5076.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6907</th>\n",
       "      <td>54</td>\n",
       "      <td>0.112175</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.138211</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.121188</td>\n",
       "      <td>127</td>\n",
       "      <td>4</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.860</td>\n",
       "      <td>5191.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32425</th>\n",
       "      <td>32</td>\n",
       "      <td>0.108260</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.108355</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.108796</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.108087</td>\n",
       "      <td>428</td>\n",
       "      <td>3</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>92.893</td>\n",
       "      <td>-46.2</td>\n",
       "      <td>1.313</td>\n",
       "      <td>5099.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38002</th>\n",
       "      <td>29</td>\n",
       "      <td>0.104856</td>\n",
       "      <td>0.140041</td>\n",
       "      <td>0.138211</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.449123</td>\n",
       "      <td>0.117800</td>\n",
       "      <td>445</td>\n",
       "      <td>2</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>-3.4</td>\n",
       "      <td>92.379</td>\n",
       "      <td>-29.8</td>\n",
       "      <td>0.788</td>\n",
       "      <td>5017.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2736</th>\n",
       "      <td>34</td>\n",
       "      <td>0.104856</td>\n",
       "      <td>0.140041</td>\n",
       "      <td>0.138211</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.116671</td>\n",
       "      <td>148</td>\n",
       "      <td>2</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.859</td>\n",
       "      <td>5191.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38657</th>\n",
       "      <td>37</td>\n",
       "      <td>0.085165</td>\n",
       "      <td>0.103209</td>\n",
       "      <td>0.108355</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.109315</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.101439</td>\n",
       "      <td>0.116671</td>\n",
       "      <td>258</td>\n",
       "      <td>2</td>\n",
       "      <td>999</td>\n",
       "      <td>1</td>\n",
       "      <td>0.142286</td>\n",
       "      <td>-3.4</td>\n",
       "      <td>92.649</td>\n",
       "      <td>-30.1</td>\n",
       "      <td>0.719</td>\n",
       "      <td>5017.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21526</th>\n",
       "      <td>30</td>\n",
       "      <td>0.104856</td>\n",
       "      <td>0.140041</td>\n",
       "      <td>0.138211</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.106021</td>\n",
       "      <td>0.117800</td>\n",
       "      <td>176</td>\n",
       "      <td>2</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.4</td>\n",
       "      <td>93.444</td>\n",
       "      <td>-36.1</td>\n",
       "      <td>4.963</td>\n",
       "      <td>5228.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31977</th>\n",
       "      <td>26</td>\n",
       "      <td>0.129185</td>\n",
       "      <td>0.140041</td>\n",
       "      <td>0.078246</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.109315</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.121188</td>\n",
       "      <td>161</td>\n",
       "      <td>2</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>92.893</td>\n",
       "      <td>-46.2</td>\n",
       "      <td>1.327</td>\n",
       "      <td>5099.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27280</th>\n",
       "      <td>53</td>\n",
       "      <td>0.068943</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.102490</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.101439</td>\n",
       "      <td>0.108087</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>-0.1</td>\n",
       "      <td>93.200</td>\n",
       "      <td>-42.0</td>\n",
       "      <td>4.021</td>\n",
       "      <td>5195.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19432</th>\n",
       "      <td>30</td>\n",
       "      <td>0.104856</td>\n",
       "      <td>0.140041</td>\n",
       "      <td>0.138211</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.109315</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.106021</td>\n",
       "      <td>0.116671</td>\n",
       "      <td>131</td>\n",
       "      <td>3</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.4</td>\n",
       "      <td>93.444</td>\n",
       "      <td>-36.1</td>\n",
       "      <td>4.967</td>\n",
       "      <td>5228.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22835</th>\n",
       "      <td>54</td>\n",
       "      <td>0.068943</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.078246</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.106021</td>\n",
       "      <td>0.099483</td>\n",
       "      <td>140</td>\n",
       "      <td>2</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.4</td>\n",
       "      <td>93.444</td>\n",
       "      <td>-36.1</td>\n",
       "      <td>4.965</td>\n",
       "      <td>5228.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31261</th>\n",
       "      <td>33</td>\n",
       "      <td>0.108260</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.113485</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.116671</td>\n",
       "      <td>318</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>1</td>\n",
       "      <td>0.142286</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>92.893</td>\n",
       "      <td>-46.2</td>\n",
       "      <td>1.334</td>\n",
       "      <td>5099.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10904</th>\n",
       "      <td>51</td>\n",
       "      <td>0.081381</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.108355</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.108796</td>\n",
       "      <td>0.109315</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.105115</td>\n",
       "      <td>0.116671</td>\n",
       "      <td>269</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.4</td>\n",
       "      <td>94.465</td>\n",
       "      <td>-41.8</td>\n",
       "      <td>4.962</td>\n",
       "      <td>5228.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6782</th>\n",
       "      <td>49</td>\n",
       "      <td>0.068943</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.102490</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.116671</td>\n",
       "      <td>410</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.857</td>\n",
       "      <td>5191.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6154</th>\n",
       "      <td>31</td>\n",
       "      <td>0.068943</td>\n",
       "      <td>0.140041</td>\n",
       "      <td>0.108355</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.117800</td>\n",
       "      <td>410</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.857</td>\n",
       "      <td>5191.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20292</th>\n",
       "      <td>36</td>\n",
       "      <td>0.108260</td>\n",
       "      <td>0.140041</td>\n",
       "      <td>0.113485</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.108796</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.106021</td>\n",
       "      <td>0.099483</td>\n",
       "      <td>345</td>\n",
       "      <td>3</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.4</td>\n",
       "      <td>93.444</td>\n",
       "      <td>-36.1</td>\n",
       "      <td>4.965</td>\n",
       "      <td>5228.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7484</th>\n",
       "      <td>53</td>\n",
       "      <td>0.108260</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.113485</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.108087</td>\n",
       "      <td>264</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.864</td>\n",
       "      <td>5191.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26044</th>\n",
       "      <td>52</td>\n",
       "      <td>0.129185</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.108355</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.101439</td>\n",
       "      <td>0.116671</td>\n",
       "      <td>130</td>\n",
       "      <td>2</td>\n",
       "      <td>999</td>\n",
       "      <td>1</td>\n",
       "      <td>0.142286</td>\n",
       "      <td>-0.1</td>\n",
       "      <td>93.200</td>\n",
       "      <td>-42.0</td>\n",
       "      <td>4.120</td>\n",
       "      <td>5195.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>729</th>\n",
       "      <td>24</td>\n",
       "      <td>0.108260</td>\n",
       "      <td>0.140041</td>\n",
       "      <td>0.113485</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.108796</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.117800</td>\n",
       "      <td>421</td>\n",
       "      <td>2</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.857</td>\n",
       "      <td>5191.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18773</th>\n",
       "      <td>31</td>\n",
       "      <td>0.081381</td>\n",
       "      <td>0.140041</td>\n",
       "      <td>0.108355</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.108796</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.090466</td>\n",
       "      <td>0.121188</td>\n",
       "      <td>61</td>\n",
       "      <td>4</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.4</td>\n",
       "      <td>93.918</td>\n",
       "      <td>-42.7</td>\n",
       "      <td>4.968</td>\n",
       "      <td>5228.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20999</th>\n",
       "      <td>56</td>\n",
       "      <td>0.068943</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.102490</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.106021</td>\n",
       "      <td>0.121188</td>\n",
       "      <td>366</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.4</td>\n",
       "      <td>93.444</td>\n",
       "      <td>-36.1</td>\n",
       "      <td>4.964</td>\n",
       "      <td>5228.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16811</th>\n",
       "      <td>40</td>\n",
       "      <td>0.081381</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.078246</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.108796</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.090466</td>\n",
       "      <td>0.121188</td>\n",
       "      <td>63</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.4</td>\n",
       "      <td>93.918</td>\n",
       "      <td>-42.7</td>\n",
       "      <td>4.962</td>\n",
       "      <td>5228.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1086</th>\n",
       "      <td>53</td>\n",
       "      <td>0.252326</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.102490</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.116671</td>\n",
       "      <td>591</td>\n",
       "      <td>3</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.856</td>\n",
       "      <td>5191.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11405</th>\n",
       "      <td>36</td>\n",
       "      <td>0.068943</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.108355</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.108796</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.105115</td>\n",
       "      <td>0.108087</td>\n",
       "      <td>50</td>\n",
       "      <td>5</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.4</td>\n",
       "      <td>94.465</td>\n",
       "      <td>-41.8</td>\n",
       "      <td>4.959</td>\n",
       "      <td>5228.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21813</th>\n",
       "      <td>42</td>\n",
       "      <td>0.129185</td>\n",
       "      <td>0.140041</td>\n",
       "      <td>0.138211</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.108796</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.106021</td>\n",
       "      <td>0.116671</td>\n",
       "      <td>483</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.4</td>\n",
       "      <td>93.444</td>\n",
       "      <td>-36.1</td>\n",
       "      <td>4.964</td>\n",
       "      <td>5228.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14664</th>\n",
       "      <td>32</td>\n",
       "      <td>0.068943</td>\n",
       "      <td>0.103209</td>\n",
       "      <td>0.078246</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.090466</td>\n",
       "      <td>0.117800</td>\n",
       "      <td>146</td>\n",
       "      <td>4</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.4</td>\n",
       "      <td>93.918</td>\n",
       "      <td>-42.7</td>\n",
       "      <td>4.961</td>\n",
       "      <td>5228.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41013</th>\n",
       "      <td>29</td>\n",
       "      <td>0.129185</td>\n",
       "      <td>0.140041</td>\n",
       "      <td>0.108355</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.108796</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.438719</td>\n",
       "      <td>0.121188</td>\n",
       "      <td>330</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>0.651129</td>\n",
       "      <td>-1.1</td>\n",
       "      <td>94.601</td>\n",
       "      <td>-49.5</td>\n",
       "      <td>1.025</td>\n",
       "      <td>4963.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5992</th>\n",
       "      <td>34</td>\n",
       "      <td>0.108260</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.138211</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.108796</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.117800</td>\n",
       "      <td>162</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.857</td>\n",
       "      <td>5191.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19220</th>\n",
       "      <td>47</td>\n",
       "      <td>0.081381</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.108355</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.106021</td>\n",
       "      <td>0.116671</td>\n",
       "      <td>277</td>\n",
       "      <td>2</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.4</td>\n",
       "      <td>93.444</td>\n",
       "      <td>-36.1</td>\n",
       "      <td>4.967</td>\n",
       "      <td>5228.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19053</th>\n",
       "      <td>51</td>\n",
       "      <td>0.108260</td>\n",
       "      <td>0.103209</td>\n",
       "      <td>0.108355</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.108796</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.106021</td>\n",
       "      <td>0.117800</td>\n",
       "      <td>162</td>\n",
       "      <td>3</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.4</td>\n",
       "      <td>93.444</td>\n",
       "      <td>-36.1</td>\n",
       "      <td>4.968</td>\n",
       "      <td>5228.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011</th>\n",
       "      <td>37</td>\n",
       "      <td>0.129185</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.108355</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.099483</td>\n",
       "      <td>115</td>\n",
       "      <td>4</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.857</td>\n",
       "      <td>5191.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33185</th>\n",
       "      <td>54</td>\n",
       "      <td>0.068943</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.102490</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.117800</td>\n",
       "      <td>291</td>\n",
       "      <td>5</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>92.893</td>\n",
       "      <td>-46.2</td>\n",
       "      <td>1.291</td>\n",
       "      <td>5099.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40337</th>\n",
       "      <td>33</td>\n",
       "      <td>0.081381</td>\n",
       "      <td>0.140041</td>\n",
       "      <td>0.108355</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.106021</td>\n",
       "      <td>0.099483</td>\n",
       "      <td>486</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>2</td>\n",
       "      <td>0.142286</td>\n",
       "      <td>-1.7</td>\n",
       "      <td>94.027</td>\n",
       "      <td>-38.3</td>\n",
       "      <td>0.898</td>\n",
       "      <td>4991.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>770</th>\n",
       "      <td>37</td>\n",
       "      <td>0.068943</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.102490</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.112767</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.116671</td>\n",
       "      <td>195</td>\n",
       "      <td>2</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.856</td>\n",
       "      <td>5191.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8337</th>\n",
       "      <td>30</td>\n",
       "      <td>0.081381</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.108355</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.108796</td>\n",
       "      <td>0.109315</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.105115</td>\n",
       "      <td>0.117800</td>\n",
       "      <td>220</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>1.4</td>\n",
       "      <td>94.465</td>\n",
       "      <td>-41.8</td>\n",
       "      <td>4.864</td>\n",
       "      <td>5228.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29097</th>\n",
       "      <td>38</td>\n",
       "      <td>0.108260</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.113485</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.108796</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.204787</td>\n",
       "      <td>0.108087</td>\n",
       "      <td>1624</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>2</td>\n",
       "      <td>0.142286</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>93.075</td>\n",
       "      <td>-47.1</td>\n",
       "      <td>1.405</td>\n",
       "      <td>5099.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30687</th>\n",
       "      <td>32</td>\n",
       "      <td>0.068943</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.078246</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.115838</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.147376</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.117800</td>\n",
       "      <td>72</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>2</td>\n",
       "      <td>0.142286</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>92.893</td>\n",
       "      <td>-46.2</td>\n",
       "      <td>1.344</td>\n",
       "      <td>5099.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33048</th>\n",
       "      <td>46</td>\n",
       "      <td>0.068943</td>\n",
       "      <td>0.101727</td>\n",
       "      <td>0.102490</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.108796</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.064347</td>\n",
       "      <td>0.099483</td>\n",
       "      <td>338</td>\n",
       "      <td>2</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>92.893</td>\n",
       "      <td>-46.2</td>\n",
       "      <td>1.299</td>\n",
       "      <td>5099.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24024</th>\n",
       "      <td>30</td>\n",
       "      <td>0.108260</td>\n",
       "      <td>0.140041</td>\n",
       "      <td>0.138211</td>\n",
       "      <td>0.112662</td>\n",
       "      <td>0.108796</td>\n",
       "      <td>0.113402</td>\n",
       "      <td>0.052313</td>\n",
       "      <td>0.438719</td>\n",
       "      <td>0.116671</td>\n",
       "      <td>676</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>0.088322</td>\n",
       "      <td>-0.1</td>\n",
       "      <td>93.798</td>\n",
       "      <td>-40.4</td>\n",
       "      <td>4.936</td>\n",
       "      <td>5195.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8238 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       age       job   marital  education   default   housing      loan  \\\n",
       "35577   32  0.068943  0.101727   0.078246  0.112662  0.115838  0.109315   \n",
       "13950   33  0.068943  0.140041   0.082024  0.112662  0.115838  0.109315   \n",
       "29451   25  0.104856  0.103209   0.138211  0.112662  0.115838  0.113402   \n",
       "32295   34  0.068943  0.140041   0.108355  0.112662  0.115838  0.113402   \n",
       "27477   53  0.108260  0.101727   0.113485  0.112662  0.115838  0.113402   \n",
       "31507   46  0.081381  0.101727   0.078246  0.112662  0.108796  0.109315   \n",
       "32167   33  0.108260  0.140041   0.113485  0.112662  0.115838  0.113402   \n",
       "24580   46  0.108260  0.101727   0.108355  0.112662  0.115838  0.113402   \n",
       "2954    42  0.108260  0.101727   0.113485  0.112662  0.108796  0.113402   \n",
       "34998   30  0.081381  0.140041   0.108355  0.112662  0.115838  0.113402   \n",
       "2045    59  0.068943  0.101727   0.102490  0.112662  0.108796  0.113402   \n",
       "15794   40  0.068943  0.140041   0.078246  0.112662  0.115838  0.113402   \n",
       "12405   32  0.068943  0.101727   0.082024  0.112662  0.108796  0.113402   \n",
       "26549   58  0.068943  0.101727   0.078246  0.112662  0.115838  0.113402   \n",
       "23028   49  0.129185  0.101727   0.138211  0.112662  0.115838  0.113402   \n",
       "19991   44  0.104856  0.101727   0.113485  0.112662  0.115838  0.112767   \n",
       "21393   40  0.108260  0.140041   0.138211  0.112662  0.115838  0.113402   \n",
       "8777    55  0.100000  0.103209   0.138211  0.112662  0.115838  0.113402   \n",
       "32235   41  0.129185  0.101727   0.138211  0.112662  0.115838  0.113402   \n",
       "1475    38  0.104856  0.140041   0.138211  0.112662  0.108796  0.113402   \n",
       "1714    49  0.129185  0.103209   0.108355  0.112662  0.115838  0.113402   \n",
       "36717   31  0.112175  0.101727   0.138211  0.112662  0.108796  0.113402   \n",
       "6907    54  0.112175  0.101727   0.138211  0.112662  0.115838  0.113402   \n",
       "32425   32  0.108260  0.101727   0.108355  0.112662  0.108796  0.113402   \n",
       "38002   29  0.104856  0.140041   0.138211  0.112662  0.115838  0.113402   \n",
       "2736    34  0.104856  0.140041   0.138211  0.112662  0.115838  0.113402   \n",
       "38657   37  0.085165  0.103209   0.108355  0.112662  0.115838  0.109315   \n",
       "21526   30  0.104856  0.140041   0.138211  0.112662  0.115838  0.113402   \n",
       "31977   26  0.129185  0.140041   0.078246  0.112662  0.115838  0.109315   \n",
       "27280   53  0.068943  0.101727   0.102490  0.112662  0.115838  0.113402   \n",
       "...    ...       ...       ...        ...       ...       ...       ...   \n",
       "19432   30  0.104856  0.140041   0.138211  0.112662  0.115838  0.109315   \n",
       "22835   54  0.068943  0.101727   0.078246  0.112662  0.115838  0.113402   \n",
       "31261   33  0.108260  0.101727   0.113485  0.112662  0.115838  0.113402   \n",
       "10904   51  0.081381  0.101727   0.108355  0.112662  0.108796  0.109315   \n",
       "6782    49  0.068943  0.101727   0.102490  0.112662  0.115838  0.113402   \n",
       "6154    31  0.068943  0.140041   0.108355  0.112662  0.115838  0.113402   \n",
       "20292   36  0.108260  0.140041   0.113485  0.112662  0.108796  0.113402   \n",
       "7484    53  0.108260  0.101727   0.113485  0.112662  0.115838  0.113402   \n",
       "26044   52  0.129185  0.101727   0.108355  0.112662  0.115838  0.113402   \n",
       "729     24  0.108260  0.140041   0.113485  0.112662  0.108796  0.113402   \n",
       "18773   31  0.081381  0.140041   0.108355  0.112662  0.108796  0.113402   \n",
       "20999   56  0.068943  0.101727   0.102490  0.112662  0.115838  0.113402   \n",
       "16811   40  0.081381  0.101727   0.078246  0.112662  0.108796  0.113402   \n",
       "1086    53  0.252326  0.101727   0.102490  0.112662  0.115838  0.113402   \n",
       "11405   36  0.068943  0.101727   0.108355  0.112662  0.108796  0.113402   \n",
       "21813   42  0.129185  0.140041   0.138211  0.112662  0.108796  0.113402   \n",
       "14664   32  0.068943  0.103209   0.078246  0.112662  0.115838  0.113402   \n",
       "41013   29  0.129185  0.140041   0.108355  0.112662  0.108796  0.113402   \n",
       "5992    34  0.108260  0.101727   0.138211  0.112662  0.108796  0.113402   \n",
       "19220   47  0.081381  0.101727   0.108355  0.112662  0.115838  0.113402   \n",
       "19053   51  0.108260  0.103209   0.108355  0.112662  0.108796  0.113402   \n",
       "2011    37  0.129185  0.101727   0.108355  0.112662  0.115838  0.113402   \n",
       "33185   54  0.068943  0.101727   0.102490  0.112662  0.115838  0.113402   \n",
       "40337   33  0.081381  0.140041   0.108355  0.112662  0.115838  0.113402   \n",
       "770     37  0.068943  0.101727   0.102490  0.112662  0.115838  0.112767   \n",
       "8337    30  0.081381  0.101727   0.108355  0.112662  0.108796  0.109315   \n",
       "29097   38  0.108260  0.101727   0.113485  0.112662  0.108796  0.113402   \n",
       "30687   32  0.068943  0.101727   0.078246  0.112662  0.115838  0.113402   \n",
       "33048   46  0.068943  0.101727   0.102490  0.112662  0.108796  0.113402   \n",
       "24024   30  0.108260  0.140041   0.138211  0.112662  0.108796  0.113402   \n",
       "\n",
       "        contact     month  day_of_week  duration  campaign  pdays  previous  \\\n",
       "35577  0.147376  0.064347     0.099483       114         1    999         0   \n",
       "13950  0.147376  0.090466     0.108087       103         2    999         0   \n",
       "29451  0.147376  0.204787     0.099483       227         5    999         0   \n",
       "32295  0.147376  0.064347     0.108087        56         1    999         0   \n",
       "27477  0.147376  0.101439     0.108087        11         7    999         0   \n",
       "31507  0.147376  0.064347     0.116671       227         2    999         0   \n",
       "32167  0.147376  0.064347     0.108087        70         1    999         0   \n",
       "24580  0.147376  0.101439     0.099483       171         1    999         1   \n",
       "2954   0.052313  0.064347     0.116671       295         1    999         0   \n",
       "34998  0.147376  0.064347     0.108087       159         1    999         0   \n",
       "2045   0.052313  0.064347     0.099483        24         1    999         0   \n",
       "15794  0.147376  0.090466     0.099483       824         5    999         0   \n",
       "12405  0.052313  0.090466     0.099483       176         6    999         0   \n",
       "26549  0.147376  0.101439     0.121188       308         1      6         1   \n",
       "23028  0.147376  0.106021     0.117800        62         2    999         0   \n",
       "19991  0.147376  0.106021     0.108087       179         3    999         0   \n",
       "21393  0.147376  0.106021     0.117800       173         1    999         0   \n",
       "8777   0.052313  0.105115     0.121188       221         1    999         0   \n",
       "32235  0.147376  0.064347     0.108087       114         2    999         0   \n",
       "1475   0.052313  0.064347     0.121188       459         2    999         0   \n",
       "1714   0.052313  0.064347     0.108087       137         1    999         0   \n",
       "36717  0.052313  0.105115     0.108087       614         2    999         0   \n",
       "6907   0.052313  0.064347     0.121188       127         4    999         0   \n",
       "32425  0.147376  0.064347     0.108087       428         3    999         0   \n",
       "38002  0.147376  0.449123     0.117800       445         2    999         0   \n",
       "2736   0.052313  0.064347     0.116671       148         2    999         0   \n",
       "38657  0.147376  0.101439     0.116671       258         2    999         1   \n",
       "21526  0.147376  0.106021     0.117800       176         2    999         0   \n",
       "31977  0.147376  0.064347     0.121188       161         2    999         0   \n",
       "27280  0.147376  0.101439     0.108087       180         1    999         0   \n",
       "...         ...       ...          ...       ...       ...    ...       ...   \n",
       "19432  0.147376  0.106021     0.116671       131         3    999         0   \n",
       "22835  0.147376  0.106021     0.099483       140         2    999         0   \n",
       "31261  0.147376  0.064347     0.116671       318         1    999         1   \n",
       "10904  0.052313  0.105115     0.116671       269         1    999         0   \n",
       "6782   0.052313  0.064347     0.116671       410         1    999         0   \n",
       "6154   0.052313  0.064347     0.117800       410         1    999         0   \n",
       "20292  0.147376  0.106021     0.099483       345         3    999         0   \n",
       "7484   0.052313  0.064347     0.108087       264         1    999         0   \n",
       "26044  0.147376  0.101439     0.116671       130         2    999         1   \n",
       "729    0.052313  0.064347     0.117800       421         2    999         0   \n",
       "18773  0.147376  0.090466     0.121188        61         4    999         0   \n",
       "20999  0.147376  0.106021     0.121188       366         1    999         0   \n",
       "16811  0.147376  0.090466     0.121188        63         1    999         0   \n",
       "1086   0.052313  0.064347     0.116671       591         3    999         0   \n",
       "11405  0.052313  0.105115     0.108087        50         5    999         0   \n",
       "21813  0.147376  0.106021     0.116671       483         1    999         0   \n",
       "14664  0.147376  0.090466     0.117800       146         4    999         0   \n",
       "41013  0.052313  0.438719     0.121188       330         2      6         1   \n",
       "5992   0.052313  0.064347     0.117800       162         1    999         0   \n",
       "19220  0.147376  0.106021     0.116671       277         2    999         0   \n",
       "19053  0.147376  0.106021     0.117800       162         3    999         0   \n",
       "2011   0.052313  0.064347     0.099483       115         4    999         0   \n",
       "33185  0.052313  0.064347     0.117800       291         5    999         0   \n",
       "40337  0.147376  0.106021     0.099483       486         1    999         2   \n",
       "770    0.052313  0.064347     0.116671       195         2    999         0   \n",
       "8337   0.052313  0.105115     0.117800       220         1    999         0   \n",
       "29097  0.147376  0.204787     0.108087      1624         1    999         2   \n",
       "30687  0.147376  0.064347     0.117800        72         1    999         2   \n",
       "33048  0.052313  0.064347     0.099483       338         2    999         0   \n",
       "24024  0.052313  0.438719     0.116671       676         1    999         0   \n",
       "\n",
       "       poutcome  emp.var.rate  cons.price.idx  cons.conf.idx  euribor3m  \\\n",
       "35577  0.088322          -1.8          92.893          -46.2      1.244   \n",
       "13950  0.088322           1.4          93.918          -42.7      4.963   \n",
       "29451  0.088322          -1.8          93.075          -47.1      1.405   \n",
       "32295  0.088322          -1.8          92.893          -46.2      1.313   \n",
       "27477  0.088322          -0.1          93.200          -42.0      4.021   \n",
       "31507  0.088322          -1.8          92.893          -46.2      1.334   \n",
       "32167  0.088322          -1.8          92.893          -46.2      1.313   \n",
       "24580  0.142286          -0.1          93.200          -42.0      4.191   \n",
       "2954   0.088322           1.1          93.994          -36.4      4.859   \n",
       "34998  0.088322          -1.8          92.893          -46.2      1.250   \n",
       "2045   0.088322           1.1          93.994          -36.4      4.857   \n",
       "15794  0.088322           1.4          93.918          -42.7      4.960   \n",
       "12405  0.088322           1.4          93.918          -42.7      4.960   \n",
       "26549  0.651129          -0.1          93.200          -42.0      4.076   \n",
       "23028  0.088322           1.4          93.444          -36.1      4.965   \n",
       "19991  0.088322           1.4          93.444          -36.1      4.966   \n",
       "21393  0.088322           1.4          93.444          -36.1      4.963   \n",
       "8777   0.088322           1.4          94.465          -41.8      4.866   \n",
       "32235  0.088322          -1.8          92.893          -46.2      1.313   \n",
       "1475   0.088322           1.1          93.994          -36.4      4.855   \n",
       "1714   0.088322           1.1          93.994          -36.4      4.855   \n",
       "36717  0.088322          -2.9          92.963          -40.8      1.268   \n",
       "6907   0.088322           1.1          93.994          -36.4      4.860   \n",
       "32425  0.088322          -1.8          92.893          -46.2      1.313   \n",
       "38002  0.088322          -3.4          92.379          -29.8      0.788   \n",
       "2736   0.088322           1.1          93.994          -36.4      4.859   \n",
       "38657  0.142286          -3.4          92.649          -30.1      0.719   \n",
       "21526  0.088322           1.4          93.444          -36.1      4.963   \n",
       "31977  0.088322          -1.8          92.893          -46.2      1.327   \n",
       "27280  0.088322          -0.1          93.200          -42.0      4.021   \n",
       "...         ...           ...             ...            ...        ...   \n",
       "19432  0.088322           1.4          93.444          -36.1      4.967   \n",
       "22835  0.088322           1.4          93.444          -36.1      4.965   \n",
       "31261  0.142286          -1.8          92.893          -46.2      1.334   \n",
       "10904  0.088322           1.4          94.465          -41.8      4.962   \n",
       "6782   0.088322           1.1          93.994          -36.4      4.857   \n",
       "6154   0.088322           1.1          93.994          -36.4      4.857   \n",
       "20292  0.088322           1.4          93.444          -36.1      4.965   \n",
       "7484   0.088322           1.1          93.994          -36.4      4.864   \n",
       "26044  0.142286          -0.1          93.200          -42.0      4.120   \n",
       "729    0.088322           1.1          93.994          -36.4      4.857   \n",
       "18773  0.088322           1.4          93.918          -42.7      4.968   \n",
       "20999  0.088322           1.4          93.444          -36.1      4.964   \n",
       "16811  0.088322           1.4          93.918          -42.7      4.962   \n",
       "1086   0.088322           1.1          93.994          -36.4      4.856   \n",
       "11405  0.088322           1.4          94.465          -41.8      4.959   \n",
       "21813  0.088322           1.4          93.444          -36.1      4.964   \n",
       "14664  0.088322           1.4          93.918          -42.7      4.961   \n",
       "41013  0.651129          -1.1          94.601          -49.5      1.025   \n",
       "5992   0.088322           1.1          93.994          -36.4      4.857   \n",
       "19220  0.088322           1.4          93.444          -36.1      4.967   \n",
       "19053  0.088322           1.4          93.444          -36.1      4.968   \n",
       "2011   0.088322           1.1          93.994          -36.4      4.857   \n",
       "33185  0.088322          -1.8          92.893          -46.2      1.291   \n",
       "40337  0.142286          -1.7          94.027          -38.3      0.898   \n",
       "770    0.088322           1.1          93.994          -36.4      4.856   \n",
       "8337   0.088322           1.4          94.465          -41.8      4.864   \n",
       "29097  0.142286          -1.8          93.075          -47.1      1.405   \n",
       "30687  0.142286          -1.8          92.893          -46.2      1.344   \n",
       "33048  0.088322          -1.8          92.893          -46.2      1.299   \n",
       "24024  0.088322          -0.1          93.798          -40.4      4.936   \n",
       "\n",
       "       nr.employed  \n",
       "35577       5099.1  \n",
       "13950       5228.1  \n",
       "29451       5099.1  \n",
       "32295       5099.1  \n",
       "27477       5195.8  \n",
       "31507       5099.1  \n",
       "32167       5099.1  \n",
       "24580       5195.8  \n",
       "2954        5191.0  \n",
       "34998       5099.1  \n",
       "2045        5191.0  \n",
       "15794       5228.1  \n",
       "12405       5228.1  \n",
       "26549       5195.8  \n",
       "23028       5228.1  \n",
       "19991       5228.1  \n",
       "21393       5228.1  \n",
       "8777        5228.1  \n",
       "32235       5099.1  \n",
       "1475        5191.0  \n",
       "1714        5191.0  \n",
       "36717       5076.2  \n",
       "6907        5191.0  \n",
       "32425       5099.1  \n",
       "38002       5017.5  \n",
       "2736        5191.0  \n",
       "38657       5017.5  \n",
       "21526       5228.1  \n",
       "31977       5099.1  \n",
       "27280       5195.8  \n",
       "...            ...  \n",
       "19432       5228.1  \n",
       "22835       5228.1  \n",
       "31261       5099.1  \n",
       "10904       5228.1  \n",
       "6782        5191.0  \n",
       "6154        5191.0  \n",
       "20292       5228.1  \n",
       "7484        5191.0  \n",
       "26044       5195.8  \n",
       "729         5191.0  \n",
       "18773       5228.1  \n",
       "20999       5228.1  \n",
       "16811       5228.1  \n",
       "1086        5191.0  \n",
       "11405       5228.1  \n",
       "21813       5228.1  \n",
       "14664       5228.1  \n",
       "41013       4963.6  \n",
       "5992        5191.0  \n",
       "19220       5228.1  \n",
       "19053       5228.1  \n",
       "2011        5191.0  \n",
       "33185       5099.1  \n",
       "40337       4991.6  \n",
       "770         5191.0  \n",
       "8337        5228.1  \n",
       "29097       5099.1  \n",
       "30687       5099.1  \n",
       "33048       5099.1  \n",
       "24024       5195.8  \n",
       "\n",
       "[8238 rows x 20 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "X_test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "age\n",
      "job\n",
      "marital\n",
      "education\n",
      "default\n",
      "housing\n",
      "loan\n",
      "contact\n",
      "month\n",
      "day_of_week\n",
      "duration\n",
      "campaign\n",
      "pdays\n",
      "previous\n",
      "poutcome\n",
      "emp.var.rate\n",
      "cons.price.idx\n",
      "cons.conf.idx\n",
      "euribor3m\n",
      "nr.employed\n"
     ]
    }
   ],
   "source": [
    "for element in X_test:\n",
    "    print(element)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "tt = np.array([[32,0.068943,0.101727,0.078246,0.112662,0.115838,0.109315,0.147376,0.064347,0.099483,114,1,999,0, 0.088322,-1.8,92.893,-46.2,1.244,5099.1]])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([0], dtype=int64)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "loaded_model.predict(tt)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Test score: 91.30 %\n"
     ]
    }
   ],
   "source": [
    "score = loaded_model.score(X_test.to_numpy(), y_test.to_numpy())\n",
    "print(\"Test score: {0:.2f} %\".format(100 * score))\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[0 0 0 ... 0 0 0]\n"
     ]
    }
   ],
   "source": [
    "Ypredict = loaded_model.predict(X_test.to_numpy())\n",
    "print(Ypredict)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "a= Ypredict.reshape(-1,1)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[0],\n",
       "       [0],\n",
       "       [0],\n",
       "       ...,\n",
       "       [0],\n",
       "       [0],\n",
       "       [0]], dtype=int64)"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "a"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[0],\n",
       "       [0],\n",
       "       [1],\n",
       "       ...,\n",
       "       [0],\n",
       "       [0],\n",
       "       [1]], dtype=int64)"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y_test.to_numpy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "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.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}