LogisticRegression_v.1.0.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 127,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import sklearn\n",
    "from sklearn.preprocessing import OneHotEncoder\n",
    "import matplotlib.pyplot as plt\n",
    "import numpy as np\n",
    "from sklearn.model_selection import learning_curve\n",
    "from sklearn.model_selection import train_test_split\n",
    "from sklearn.linear_model import LogisticRegression\n",
    "from sklearn.metrics import accuracy_score\n",
    "from sklearn.preprocessing import StandardScaler\n",
    "import joblib"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 128,
   "metadata": {},
   "outputs": [],
   "source": [
    "original = pd.read_csv('Data_Train.csv', sep = ';')\n",
    "df = original.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ID                                   0\n",
       "edad                                 0\n",
       "trabajo                              0\n",
       "estado_civil                         0\n",
       "educacion                            0\n",
       "deuda                                0\n",
       "saldo                                0\n",
       "vivienda                             0\n",
       "prestamo                             0\n",
       "tipo_contacto                    12072\n",
       "duracion                             0\n",
       "fecha_contacto                       0\n",
       "campaign                             0\n",
       "tiempo_transcurrido                  0\n",
       "contactos_anteriores                 0\n",
       "resultado_campanas_anteriores    34670\n",
       "target                               0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 129,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dropna(subset=['educacion'], inplace=True)\n",
    "\n",
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ID                               0\n",
       "edad                             0\n",
       "trabajo                          0\n",
       "estado_civil                     0\n",
       "educacion                        0\n",
       "deuda                            0\n",
       "saldo                            0\n",
       "vivienda                         0\n",
       "prestamo                         0\n",
       "tipo_contacto                    0\n",
       "duracion                         0\n",
       "fecha_contacto                   0\n",
       "campaign                         0\n",
       "tiempo_transcurrido              0\n",
       "contactos_anteriores             0\n",
       "resultado_campanas_anteriores    0\n",
       "target                           0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 130,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Reemplaza los valores nulos en las columnas especificadas con \"Sin Información\"\n",
    "df[['tipo_contacto', 'resultado_campanas_anteriores']] = df[['tipo_contacto', 'resultado_campanas_anteriores']].fillna(\"Sin Información\")\n",
    "\n",
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Buscamos modelo predictivo para nuestra columna \"Target\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "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>ID</th>\n",
       "      <th>edad</th>\n",
       "      <th>trabajo</th>\n",
       "      <th>estado_civil</th>\n",
       "      <th>educacion</th>\n",
       "      <th>deuda</th>\n",
       "      <th>saldo</th>\n",
       "      <th>vivienda</th>\n",
       "      <th>prestamo</th>\n",
       "      <th>tipo_contacto</th>\n",
       "      <th>duracion</th>\n",
       "      <th>fecha_contacto</th>\n",
       "      <th>campaign</th>\n",
       "      <th>tiempo_transcurrido</th>\n",
       "      <th>contactos_anteriores</th>\n",
       "      <th>resultado_campanas_anteriores</th>\n",
       "      <th>target</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>17724</th>\n",
       "      <td>17725</td>\n",
       "      <td>55</td>\n",
       "      <td>self-employed</td>\n",
       "      <td>casado</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>1810</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>296</td>\n",
       "      <td>13-may-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17588</th>\n",
       "      <td>17589</td>\n",
       "      <td>54</td>\n",
       "      <td>management</td>\n",
       "      <td>divorciado</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>427</td>\n",
       "      <td>si</td>\n",
       "      <td>si</td>\n",
       "      <td>movil</td>\n",
       "      <td>85</td>\n",
       "      <td>4-feb-2021</td>\n",
       "      <td>2</td>\n",
       "      <td>231</td>\n",
       "      <td>2</td>\n",
       "      <td>otro</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16107</th>\n",
       "      <td>16108</td>\n",
       "      <td>40</td>\n",
       "      <td>admin.</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>0</td>\n",
       "      <td>si</td>\n",
       "      <td>si</td>\n",
       "      <td>movil</td>\n",
       "      <td>145</td>\n",
       "      <td>9-jul-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          ID  edad        trabajo estado_civil              educacion deuda  \\\n",
       "17724  17725    55  self-employed       casado         universitarios    no   \n",
       "17588  17589    54     management   divorciado         universitarios    no   \n",
       "16107  16108    40         admin.       casado  secundaria/superiores    no   \n",
       "\n",
       "       saldo vivienda prestamo tipo_contacto  duracion fecha_contacto  \\\n",
       "17724   1810       si       no         movil       296    13-may-2021   \n",
       "17588    427       si       si         movil        85     4-feb-2021   \n",
       "16107      0       si       si         movil       145     9-jul-2021   \n",
       "\n",
       "       campaign  tiempo_transcurrido  contactos_anteriores  \\\n",
       "17724         1                   -1                     0   \n",
       "17588         2                  231                     2   \n",
       "16107         1                   -1                     0   \n",
       "\n",
       "      resultado_campanas_anteriores target  \n",
       "17724               Sin Información     no  \n",
       "17588                          otro     no  \n",
       "16107               Sin Información     no  "
      ]
     },
     "execution_count": 131,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_train = df.copy()\n",
    "df_train.sample(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_train.loc[df_train['target'] == 'no', 'target'] = 0\n",
    "df_train.loc[df_train['target'] == 'si', 'target'] = 1\n",
    "df_train['target'] = df_train['target'].astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "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>ID</th>\n",
       "      <th>edad</th>\n",
       "      <th>trabajo</th>\n",
       "      <th>estado_civil</th>\n",
       "      <th>educacion</th>\n",
       "      <th>deuda</th>\n",
       "      <th>saldo</th>\n",
       "      <th>vivienda</th>\n",
       "      <th>prestamo</th>\n",
       "      <th>tipo_contacto</th>\n",
       "      <th>duracion</th>\n",
       "      <th>fecha_contacto</th>\n",
       "      <th>campaign</th>\n",
       "      <th>tiempo_transcurrido</th>\n",
       "      <th>contactos_anteriores</th>\n",
       "      <th>resultado_campanas_anteriores</th>\n",
       "      <th>target</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>23774</th>\n",
       "      <td>23775</td>\n",
       "      <td>43</td>\n",
       "      <td>technician</td>\n",
       "      <td>soltero</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>-266</td>\n",
       "      <td>si</td>\n",
       "      <td>si</td>\n",
       "      <td>movil</td>\n",
       "      <td>12</td>\n",
       "      <td>15-may-2021</td>\n",
       "      <td>5</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22845</th>\n",
       "      <td>22846</td>\n",
       "      <td>56</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>casado</td>\n",
       "      <td>priamaria</td>\n",
       "      <td>no</td>\n",
       "      <td>175</td>\n",
       "      <td>no</td>\n",
       "      <td>si</td>\n",
       "      <td>movil</td>\n",
       "      <td>188</td>\n",
       "      <td>8-jul-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44077</th>\n",
       "      <td>44078</td>\n",
       "      <td>33</td>\n",
       "      <td>management</td>\n",
       "      <td>soltero</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>48</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>400</td>\n",
       "      <td>11-may-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>173</td>\n",
       "      <td>5</td>\n",
       "      <td>sin_exito</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29632</th>\n",
       "      <td>29633</td>\n",
       "      <td>22</td>\n",
       "      <td>admin.</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>967</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>525</td>\n",
       "      <td>4-jun-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21665</th>\n",
       "      <td>21666</td>\n",
       "      <td>39</td>\n",
       "      <td>technician</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>4444</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>244</td>\n",
       "      <td>21-may-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39327</th>\n",
       "      <td>39328</td>\n",
       "      <td>25</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>soltero</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>si</td>\n",
       "      <td>15</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>fijo</td>\n",
       "      <td>44</td>\n",
       "      <td>6-may-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39339</th>\n",
       "      <td>39340</td>\n",
       "      <td>40</td>\n",
       "      <td>unemployed</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>219</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>357</td>\n",
       "      <td>5-may-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34631</th>\n",
       "      <td>34632</td>\n",
       "      <td>44</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>casado</td>\n",
       "      <td>priamaria</td>\n",
       "      <td>no</td>\n",
       "      <td>186</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>152</td>\n",
       "      <td>13-may-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>370</td>\n",
       "      <td>1</td>\n",
       "      <td>sin_exito</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1854</th>\n",
       "      <td>1855</td>\n",
       "      <td>30</td>\n",
       "      <td>management</td>\n",
       "      <td>soltero</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>0</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>108</td>\n",
       "      <td>6-feb-2021</td>\n",
       "      <td>4</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38645</th>\n",
       "      <td>38646</td>\n",
       "      <td>33</td>\n",
       "      <td>technician</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>1968</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>1817</td>\n",
       "      <td>20-apr-2021</td>\n",
       "      <td>3</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19939</th>\n",
       "      <td>19940</td>\n",
       "      <td>45</td>\n",
       "      <td>housemaid</td>\n",
       "      <td>casado</td>\n",
       "      <td>priamaria</td>\n",
       "      <td>no</td>\n",
       "      <td>403</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>144</td>\n",
       "      <td>2-apr-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2604</th>\n",
       "      <td>2605</td>\n",
       "      <td>62</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>casado</td>\n",
       "      <td>priamaria</td>\n",
       "      <td>no</td>\n",
       "      <td>115</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>fijo</td>\n",
       "      <td>75</td>\n",
       "      <td>29-apr-2021</td>\n",
       "      <td>3</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20136</th>\n",
       "      <td>20137</td>\n",
       "      <td>31</td>\n",
       "      <td>services</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>-214</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>198</td>\n",
       "      <td>27-may-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20489</th>\n",
       "      <td>20490</td>\n",
       "      <td>36</td>\n",
       "      <td>technician</td>\n",
       "      <td>divorciado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>556</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>154</td>\n",
       "      <td>18-nov-2021</td>\n",
       "      <td>3</td>\n",
       "      <td>189</td>\n",
       "      <td>1</td>\n",
       "      <td>sin_exito</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12305</th>\n",
       "      <td>12306</td>\n",
       "      <td>32</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>casado</td>\n",
       "      <td>priamaria</td>\n",
       "      <td>no</td>\n",
       "      <td>1261</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>104</td>\n",
       "      <td>21-nov-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>182</td>\n",
       "      <td>1</td>\n",
       "      <td>sin_exito</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43617</th>\n",
       "      <td>43618</td>\n",
       "      <td>48</td>\n",
       "      <td>admin.</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>-509</td>\n",
       "      <td>no</td>\n",
       "      <td>si</td>\n",
       "      <td>movil</td>\n",
       "      <td>302</td>\n",
       "      <td>8-jul-2021</td>\n",
       "      <td>3</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3088</th>\n",
       "      <td>3089</td>\n",
       "      <td>36</td>\n",
       "      <td>management</td>\n",
       "      <td>soltero</td>\n",
       "      <td>priamaria</td>\n",
       "      <td>no</td>\n",
       "      <td>51</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>fijo</td>\n",
       "      <td>179</td>\n",
       "      <td>14-jul-2021</td>\n",
       "      <td>3</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35276</th>\n",
       "      <td>35277</td>\n",
       "      <td>43</td>\n",
       "      <td>technician</td>\n",
       "      <td>divorciado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>-191</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>76</td>\n",
       "      <td>11-jun-2021</td>\n",
       "      <td>3</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37721</th>\n",
       "      <td>37722</td>\n",
       "      <td>53</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>casado</td>\n",
       "      <td>priamaria</td>\n",
       "      <td>no</td>\n",
       "      <td>109</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>86</td>\n",
       "      <td>22-aug-2021</td>\n",
       "      <td>4</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20946</th>\n",
       "      <td>20947</td>\n",
       "      <td>31</td>\n",
       "      <td>housemaid</td>\n",
       "      <td>casado</td>\n",
       "      <td>priamaria</td>\n",
       "      <td>no</td>\n",
       "      <td>25</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>169</td>\n",
       "      <td>21-aug-2021</td>\n",
       "      <td>5</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20326</th>\n",
       "      <td>20327</td>\n",
       "      <td>40</td>\n",
       "      <td>self-employed</td>\n",
       "      <td>casado</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>1498</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>62</td>\n",
       "      <td>4-feb-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2363</th>\n",
       "      <td>2364</td>\n",
       "      <td>33</td>\n",
       "      <td>technician</td>\n",
       "      <td>soltero</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>151</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>104</td>\n",
       "      <td>20-apr-2021</td>\n",
       "      <td>3</td>\n",
       "      <td>236</td>\n",
       "      <td>6</td>\n",
       "      <td>sin_exito</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13940</th>\n",
       "      <td>13941</td>\n",
       "      <td>44</td>\n",
       "      <td>management</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>238</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>147</td>\n",
       "      <td>19-aug-2021</td>\n",
       "      <td>3</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7603</th>\n",
       "      <td>7604</td>\n",
       "      <td>41</td>\n",
       "      <td>management</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>280</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>87</td>\n",
       "      <td>27-feb-2021</td>\n",
       "      <td>2</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19833</th>\n",
       "      <td>19834</td>\n",
       "      <td>40</td>\n",
       "      <td>management</td>\n",
       "      <td>casado</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>132</td>\n",
       "      <td>si</td>\n",
       "      <td>si</td>\n",
       "      <td>movil</td>\n",
       "      <td>170</td>\n",
       "      <td>18-nov-2021</td>\n",
       "      <td>2</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44028</th>\n",
       "      <td>44029</td>\n",
       "      <td>54</td>\n",
       "      <td>retired</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>6449</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>487</td>\n",
       "      <td>19-jun-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35372</th>\n",
       "      <td>35373</td>\n",
       "      <td>37</td>\n",
       "      <td>technician</td>\n",
       "      <td>casado</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>0</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>53</td>\n",
       "      <td>20-nov-2021</td>\n",
       "      <td>3</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2535</th>\n",
       "      <td>2536</td>\n",
       "      <td>36</td>\n",
       "      <td>services</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>-182</td>\n",
       "      <td>si</td>\n",
       "      <td>si</td>\n",
       "      <td>movil</td>\n",
       "      <td>19</td>\n",
       "      <td>8-may-2021</td>\n",
       "      <td>6</td>\n",
       "      <td>304</td>\n",
       "      <td>11</td>\n",
       "      <td>otro</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32869</th>\n",
       "      <td>32870</td>\n",
       "      <td>27</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>soltero</td>\n",
       "      <td>priamaria</td>\n",
       "      <td>no</td>\n",
       "      <td>68</td>\n",
       "      <td>si</td>\n",
       "      <td>si</td>\n",
       "      <td>movil</td>\n",
       "      <td>50</td>\n",
       "      <td>11-may-2021</td>\n",
       "      <td>5</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37736</th>\n",
       "      <td>37737</td>\n",
       "      <td>59</td>\n",
       "      <td>retired</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>278</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>141</td>\n",
       "      <td>12-aug-2021</td>\n",
       "      <td>3</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          ID  edad        trabajo estado_civil              educacion deuda  \\\n",
       "23774  23775    43     technician      soltero  secundaria/superiores    no   \n",
       "22845  22846    56    blue-collar       casado              priamaria    no   \n",
       "44077  44078    33     management      soltero         universitarios    no   \n",
       "29632  29633    22         admin.       casado  secundaria/superiores    no   \n",
       "21665  21666    39     technician       casado  secundaria/superiores    no   \n",
       "39327  39328    25    blue-collar      soltero  secundaria/superiores    si   \n",
       "39339  39340    40     unemployed       casado  secundaria/superiores    no   \n",
       "34631  34632    44    blue-collar       casado              priamaria    no   \n",
       "1854    1855    30     management      soltero         universitarios    no   \n",
       "38645  38646    33     technician       casado  secundaria/superiores    no   \n",
       "19939  19940    45      housemaid       casado              priamaria    no   \n",
       "2604    2605    62    blue-collar       casado              priamaria    no   \n",
       "20136  20137    31       services       casado  secundaria/superiores    no   \n",
       "20489  20490    36     technician   divorciado  secundaria/superiores    no   \n",
       "12305  12306    32    blue-collar       casado              priamaria    no   \n",
       "43617  43618    48         admin.       casado  secundaria/superiores    no   \n",
       "3088    3089    36     management      soltero              priamaria    no   \n",
       "35276  35277    43     technician   divorciado  secundaria/superiores    no   \n",
       "37721  37722    53    blue-collar       casado              priamaria    no   \n",
       "20946  20947    31      housemaid       casado              priamaria    no   \n",
       "20326  20327    40  self-employed       casado         universitarios    no   \n",
       "2363    2364    33     technician      soltero  secundaria/superiores    no   \n",
       "13940  13941    44     management       casado  secundaria/superiores    no   \n",
       "7603    7604    41     management       casado  secundaria/superiores    no   \n",
       "19833  19834    40     management       casado         universitarios    no   \n",
       "44028  44029    54        retired       casado  secundaria/superiores    no   \n",
       "35372  35373    37     technician       casado         universitarios    no   \n",
       "2535    2536    36       services       casado  secundaria/superiores    no   \n",
       "32869  32870    27    blue-collar      soltero              priamaria    no   \n",
       "37736  37737    59        retired       casado  secundaria/superiores    no   \n",
       "\n",
       "       saldo vivienda prestamo    tipo_contacto  duracion fecha_contacto  \\\n",
       "23774   -266       si       si            movil        12    15-may-2021   \n",
       "22845    175       no       si            movil       188     8-jul-2021   \n",
       "44077     48       si       no            movil       400    11-may-2021   \n",
       "29632    967       si       no  Sin Información       525     4-jun-2021   \n",
       "21665   4444       si       no  Sin Información       244    21-may-2021   \n",
       "39327     15       si       no             fijo        44     6-may-2021   \n",
       "39339    219       si       no  Sin Información       357     5-may-2021   \n",
       "34631    186       si       no            movil       152    13-may-2021   \n",
       "1854       0       no       no            movil       108     6-feb-2021   \n",
       "38645   1968       si       no            movil      1817    20-apr-2021   \n",
       "19939    403       no       no            movil       144     2-apr-2021   \n",
       "2604     115       no       no             fijo        75    29-apr-2021   \n",
       "20136   -214       si       no  Sin Información       198    27-may-2021   \n",
       "20489    556       si       no            movil       154    18-nov-2021   \n",
       "12305   1261       si       no            movil       104    21-nov-2021   \n",
       "43617   -509       no       si            movil       302     8-jul-2021   \n",
       "3088      51       no       no             fijo       179    14-jul-2021   \n",
       "35276   -191       no       no  Sin Información        76    11-jun-2021   \n",
       "37721    109       no       no            movil        86    22-aug-2021   \n",
       "20946     25       no       no            movil       169    21-aug-2021   \n",
       "20326   1498       no       no            movil        62     4-feb-2021   \n",
       "2363     151       si       no            movil       104    20-apr-2021   \n",
       "13940    238       no       no            movil       147    19-aug-2021   \n",
       "7603     280       si       no            movil        87    27-feb-2021   \n",
       "19833    132       si       si            movil       170    18-nov-2021   \n",
       "44028   6449       no       no  Sin Información       487    19-jun-2021   \n",
       "35372      0       no       no            movil        53    20-nov-2021   \n",
       "2535    -182       si       si            movil        19     8-may-2021   \n",
       "32869     68       si       si            movil        50    11-may-2021   \n",
       "37736    278       no       no            movil       141    12-aug-2021   \n",
       "\n",
       "       campaign  tiempo_transcurrido  contactos_anteriores  \\\n",
       "23774         5                   -1                     0   \n",
       "22845         1                   -1                     0   \n",
       "44077         1                  173                     5   \n",
       "29632         1                   -1                     0   \n",
       "21665         1                   -1                     0   \n",
       "39327         1                   -1                     0   \n",
       "39339         1                   -1                     0   \n",
       "34631         1                  370                     1   \n",
       "1854          4                   -1                     0   \n",
       "38645         3                   -1                     0   \n",
       "19939         1                   -1                     0   \n",
       "2604          3                   -1                     0   \n",
       "20136         1                   -1                     0   \n",
       "20489         3                  189                     1   \n",
       "12305         1                  182                     1   \n",
       "43617         3                   -1                     0   \n",
       "3088          3                   -1                     0   \n",
       "35276         3                   -1                     0   \n",
       "37721         4                   -1                     0   \n",
       "20946         5                   -1                     0   \n",
       "20326         1                   -1                     0   \n",
       "2363          3                  236                     6   \n",
       "13940         3                   -1                     0   \n",
       "7603          2                   -1                     0   \n",
       "19833         2                   -1                     0   \n",
       "44028         1                   -1                     0   \n",
       "35372         3                   -1                     0   \n",
       "2535          6                  304                    11   \n",
       "32869         5                   -1                     0   \n",
       "37736         3                   -1                     0   \n",
       "\n",
       "      resultado_campanas_anteriores  target  \n",
       "23774               Sin Información       0  \n",
       "22845               Sin Información       0  \n",
       "44077                     sin_exito       0  \n",
       "29632               Sin Información       0  \n",
       "21665               Sin Información       0  \n",
       "39327               Sin Información       0  \n",
       "39339               Sin Información       0  \n",
       "34631                     sin_exito       0  \n",
       "1854                Sin Información       0  \n",
       "38645               Sin Información       1  \n",
       "19939               Sin Información       0  \n",
       "2604                Sin Información       0  \n",
       "20136               Sin Información       0  \n",
       "20489                     sin_exito       0  \n",
       "12305                     sin_exito       0  \n",
       "43617               Sin Información       0  \n",
       "3088                Sin Información       0  \n",
       "35276               Sin Información       0  \n",
       "37721               Sin Información       0  \n",
       "20946               Sin Información       0  \n",
       "20326               Sin Información       0  \n",
       "2363                      sin_exito       0  \n",
       "13940               Sin Información       0  \n",
       "7603                Sin Información       1  \n",
       "19833               Sin Información       0  \n",
       "44028               Sin Información       0  \n",
       "35372               Sin Información       0  \n",
       "2535                           otro       0  \n",
       "32869               Sin Información       0  \n",
       "37736               Sin Información       0  "
      ]
     },
     "execution_count": 133,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_train.sample(30)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "educacion\n",
      "secundaria/superiores    22713\n",
      "universitarios           13025\n",
      "priamaria                 6708\n",
      "Name: count, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "# Supongamos que tienes un DataFrame llamado df y quieres contar los valores en la columna 'columna_deseada'\n",
    "conteo_valores = df['educacion'].value_counts()\n",
    "print(conteo_valores)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Reemplaza el valor erróneo en la columna 'educacion'\n",
    "df_train['educacion'] = df_train['educacion'].replace('priamaria', 'primaria')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "educacion\n",
      "secundaria/superiores    22713\n",
      "universitarios           13025\n",
      "priamaria                 6708\n",
      "Name: count, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "# Supongamos que tienes un DataFrame llamado df y quieres contar los valores en la columna 'columna_deseada'\n",
    "conteo_valores = df['educacion'].value_counts()\n",
    "print(conteo_valores)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "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>edad</th>\n",
       "      <th>trabajo</th>\n",
       "      <th>estado_civil</th>\n",
       "      <th>educacion</th>\n",
       "      <th>deuda</th>\n",
       "      <th>saldo</th>\n",
       "      <th>vivienda</th>\n",
       "      <th>prestamo</th>\n",
       "      <th>tipo_contacto</th>\n",
       "      <th>duracion</th>\n",
       "      <th>campaign</th>\n",
       "      <th>tiempo_transcurrido</th>\n",
       "      <th>contactos_anteriores</th>\n",
       "      <th>resultado_campanas_anteriores</th>\n",
       "      <th>target</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>28437</th>\n",
       "      <td>27</td>\n",
       "      <td>self-employed</td>\n",
       "      <td>soltero</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>1393</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>382</td>\n",
       "      <td>1</td>\n",
       "      <td>271</td>\n",
       "      <td>1</td>\n",
       "      <td>sin_exito</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32531</th>\n",
       "      <td>40</td>\n",
       "      <td>technician</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>109</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>402</td>\n",
       "      <td>22</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21558</th>\n",
       "      <td>31</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>soltero</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>-190</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>127</td>\n",
       "      <td>2</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       edad        trabajo estado_civil              educacion deuda  saldo  \\\n",
       "28437    27  self-employed      soltero         universitarios    no   1393   \n",
       "32531    40     technician       casado  secundaria/superiores    no    109   \n",
       "21558    31    blue-collar      soltero  secundaria/superiores    no   -190   \n",
       "\n",
       "      vivienda prestamo    tipo_contacto  duracion  campaign  \\\n",
       "28437       no       no            movil       382         1   \n",
       "32531       no       no  Sin Información       402        22   \n",
       "21558       si       no            movil       127         2   \n",
       "\n",
       "       tiempo_transcurrido  contactos_anteriores  \\\n",
       "28437                  271                     1   \n",
       "32531                   -1                     0   \n",
       "21558                   -1                     0   \n",
       "\n",
       "      resultado_campanas_anteriores  target  \n",
       "28437                     sin_exito       0  \n",
       "32531               Sin Información       0  \n",
       "21558               Sin Información       0  "
      ]
     },
     "execution_count": 137,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "columns_to_delete = ['fecha_contacto', 'ID']\n",
    "df_train.drop(columns=columns_to_delete,inplace=True)\n",
    "\n",
    "df_train.sample(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(42446, 38)\n"
     ]
    },
    {
     "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>edad</th>\n",
       "      <th>saldo</th>\n",
       "      <th>duracion</th>\n",
       "      <th>campaign</th>\n",
       "      <th>tiempo_transcurrido</th>\n",
       "      <th>contactos_anteriores</th>\n",
       "      <th>target</th>\n",
       "      <th>trabajo_admin.</th>\n",
       "      <th>trabajo_blue-collar</th>\n",
       "      <th>trabajo_entrepreneur</th>\n",
       "      <th>...</th>\n",
       "      <th>vivienda_si</th>\n",
       "      <th>prestamo_no</th>\n",
       "      <th>prestamo_si</th>\n",
       "      <th>tipo_contacto_Sin Información</th>\n",
       "      <th>tipo_contacto_fijo</th>\n",
       "      <th>tipo_contacto_movil</th>\n",
       "      <th>resultado_campanas_anteriores_Sin Información</th>\n",
       "      <th>resultado_campanas_anteriores_exito</th>\n",
       "      <th>resultado_campanas_anteriores_otro</th>\n",
       "      <th>resultado_campanas_anteriores_sin_exito</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10683</th>\n",
       "      <td>37</td>\n",
       "      <td>146</td>\n",
       "      <td>135</td>\n",
       "      <td>1</td>\n",
       "      <td>336</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30090</th>\n",
       "      <td>34</td>\n",
       "      <td>255</td>\n",
       "      <td>344</td>\n",
       "      <td>10</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9142</th>\n",
       "      <td>36</td>\n",
       "      <td>302</td>\n",
       "      <td>60</td>\n",
       "      <td>6</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11360</th>\n",
       "      <td>28</td>\n",
       "      <td>1633</td>\n",
       "      <td>233</td>\n",
       "      <td>1</td>\n",
       "      <td>95</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39841</th>\n",
       "      <td>47</td>\n",
       "      <td>881</td>\n",
       "      <td>143</td>\n",
       "      <td>1</td>\n",
       "      <td>370</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       edad  saldo  duracion  campaign  tiempo_transcurrido  \\\n",
       "10683    37    146       135         1                  336   \n",
       "30090    34    255       344        10                   -1   \n",
       "9142     36    302        60         6                   -1   \n",
       "11360    28   1633       233         1                   95   \n",
       "39841    47    881       143         1                  370   \n",
       "\n",
       "       contactos_anteriores  target  trabajo_admin.  trabajo_blue-collar  \\\n",
       "10683                     3       0             0.0                  0.0   \n",
       "30090                     0       0             1.0                  0.0   \n",
       "9142                      0       0             0.0                  0.0   \n",
       "11360                     1       0             0.0                  0.0   \n",
       "39841                     2       0             0.0                  1.0   \n",
       "\n",
       "       trabajo_entrepreneur  ...  vivienda_si  prestamo_no  prestamo_si  \\\n",
       "10683                   0.0  ...          1.0          1.0          0.0   \n",
       "30090                   0.0  ...          0.0          0.0          1.0   \n",
       "9142                    0.0  ...          0.0          1.0          0.0   \n",
       "11360                   0.0  ...          0.0          1.0          0.0   \n",
       "39841                   0.0  ...          1.0          1.0          0.0   \n",
       "\n",
       "       tipo_contacto_Sin Información  tipo_contacto_fijo  tipo_contacto_movil  \\\n",
       "10683                            0.0                 0.0                  1.0   \n",
       "30090                            0.0                 1.0                  0.0   \n",
       "9142                             1.0                 0.0                  0.0   \n",
       "11360                            0.0                 0.0                  1.0   \n",
       "39841                            0.0                 0.0                  1.0   \n",
       "\n",
       "       resultado_campanas_anteriores_Sin Información  \\\n",
       "10683                                            0.0   \n",
       "30090                                            1.0   \n",
       "9142                                             1.0   \n",
       "11360                                            0.0   \n",
       "39841                                            0.0   \n",
       "\n",
       "       resultado_campanas_anteriores_exito  \\\n",
       "10683                                  0.0   \n",
       "30090                                  0.0   \n",
       "9142                                   0.0   \n",
       "11360                                  1.0   \n",
       "39841                                  0.0   \n",
       "\n",
       "       resultado_campanas_anteriores_otro  \\\n",
       "10683                                 0.0   \n",
       "30090                                 0.0   \n",
       "9142                                  0.0   \n",
       "11360                                 0.0   \n",
       "39841                                 0.0   \n",
       "\n",
       "       resultado_campanas_anteriores_sin_exito  \n",
       "10683                                      1.0  \n",
       "30090                                      0.0  \n",
       "9142                                       0.0  \n",
       "11360                                      0.0  \n",
       "39841                                      1.0  \n",
       "\n",
       "[5 rows x 38 columns]"
      ]
     },
     "execution_count": 138,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "#Instancio el OneHot\n",
    "onehot=OneHotEncoder()\n",
    "\n",
    "# Aplico el OneHot a la columna job y guardo el resultao en a\n",
    "onehot.fit(df_train[['trabajo','estado_civil','educacion','deuda','vivienda','prestamo','tipo_contacto','resultado_campanas_anteriores']])\n",
    "a=onehot.transform(df_train[['trabajo','estado_civil','educacion','deuda','vivienda','prestamo','tipo_contacto','resultado_campanas_anteriores']])\n",
    "\n",
    "# Convierto el a en data frame y lo llamo encoded_df\n",
    "encoded_df = pd.DataFrame(a.toarray(), columns=onehot.get_feature_names_out(['trabajo','estado_civil','educacion','deuda','vivienda','prestamo','tipo_contacto','resultado_campanas_anteriores']))\n",
    "\n",
    "# Reseteo el índice de los dos data frames antes de concatenarlos\n",
    "df_train.reset_index(drop=True, inplace=True)\n",
    "encoded_df.reset_index(drop=True, inplace=True)\n",
    "\n",
    "# concateno los dos data frames y los guardo machacando el df\n",
    "df_train=pd.concat([df_train,encoded_df],axis=1)\n",
    "\n",
    "# Elimino la columna Job original antigua, la categórica\n",
    "df_train.drop(columns=['trabajo','estado_civil','educacion','deuda','vivienda','prestamo','tipo_contacto','resultado_campanas_anteriores'],inplace=True)\n",
    "\n",
    "# Muestro tamaño yu sample del data frame df transformado\n",
    "print(df_train.shape)\n",
    "df_train.sample(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 139,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Tamaño X (42446, 37)\n",
      "Tamaño y (42446,)\n"
     ]
    }
   ],
   "source": [
    "X = df_train.drop(columns=[\"target\"],inplace=False)\n",
    "y = df_train[\"target\"]\n",
    "\n",
    "print(\"Tamaño X\",X.shape)\n",
    "print(\"Tamaño y\",y.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 140,
   "metadata": {},
   "outputs": [],
   "source": [
    "X_train, X_test, y_train, y_test = train_test_split(X, y, test_size = 0.25, random_state = 0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 141,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Tamaño X_train (31834, 37)\n",
      "Tamaño y_train (31834,)\n",
      "Tamaño X_test (10612, 37)\n",
      "Tamaño y_test (10612,)\n"
     ]
    }
   ],
   "source": [
    "print(\"Tamaño X_train\",X_train.shape)\n",
    "print(\"Tamaño y_train\",y_train.shape)\n",
    "print(\"Tamaño X_test\",X_test.shape)\n",
    "print(\"Tamaño y_test\",y_test.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[1 0 0 ... 0 0 0]\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "c:\\Users\\GuillemEdoBertran\\.conda\\envs\\ML_IMPELIA\\lib\\site-packages\\sklearn\\linear_model\\_logistic.py:469: ConvergenceWarning: lbfgs failed to converge (status=1):\n",
      "STOP: TOTAL NO. of ITERATIONS REACHED LIMIT.\n",
      "\n",
      "Increase the number of iterations (max_iter) or scale the data as shown in:\n",
      "    https://scikit-learn.org/stable/modules/preprocessing.html\n",
      "Please also refer to the documentation for alternative solver options:\n",
      "    https://scikit-learn.org/stable/modules/linear_model.html#logistic-regression\n",
      "  n_iter_i = _check_optimize_result(\n"
     ]
    }
   ],
   "source": [
    "# Suponiendo que X es tu conjunto de características y y es tu variable objetivo\n",
    "model = LogisticRegression()\n",
    "model.fit(X_train, y_train)\n",
    "y_pred = model.predict_proba(X_test)[:,1]\n",
    "y_pred_dicotomico = (y_pred > 0.65) *1\n",
    "print(y_pred_dicotomico)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 143,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Precisión del modelo de árbol de decisión: 0.8921032793064455\n"
     ]
    }
   ],
   "source": [
    "accuracy = accuracy_score(y_test, y_pred_dicotomico)\n",
    "print(\"Precisión del modelo de árbol de decisión:\", accuracy)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Estandarización controlada\n",
    "\n",
    "estandarizador = StandardScaler()\n",
    "estandarizador.fit(X_train)\n",
    "\n",
    "X_train_std=estandarizador.transform(X_train)\n",
    "X_test_std=estandarizador.transform(X_test)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Precisión del modelo de árbol de decisión: 0.8921032793064455\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "c:\\Users\\GuillemEdoBertran\\.conda\\envs\\ML_IMPELIA\\lib\\site-packages\\sklearn\\base.py:493: UserWarning: X does not have valid feature names, but LogisticRegression was fitted with feature names\n",
      "  warnings.warn(\n"
     ]
    }
   ],
   "source": [
    "# Suponiendo que X es tu conjunto de características y y es tu variable objetivo\n",
    "model_std = LogisticRegression()\n",
    "model_std.fit(X_train_std, y_train)\n",
    "y_pred_std = model.predict_proba(X_test_std)[:,1]\n",
    "y_pred_std_dicotomico = (y_pred_dicotomico > 0.65) *1\n",
    "\n",
    "accuracy = accuracy_score(y_test, y_pred_std_dicotomico)\n",
    "print(\"Precisión del modelo de árbol de decisión:\", accuracy)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "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>ID</th>\n",
       "      <th>edad</th>\n",
       "      <th>trabajo</th>\n",
       "      <th>estado_civil</th>\n",
       "      <th>educacion</th>\n",
       "      <th>deuda</th>\n",
       "      <th>saldo</th>\n",
       "      <th>vivienda</th>\n",
       "      <th>prestamo</th>\n",
       "      <th>tipo_contacto</th>\n",
       "      <th>duracion</th>\n",
       "      <th>fecha_contacto</th>\n",
       "      <th>campaign</th>\n",
       "      <th>tiempo_transcurrido</th>\n",
       "      <th>contactos_anteriores</th>\n",
       "      <th>resultado_campanas_anteriores</th>\n",
       "      <th>target</th>\n",
       "      <th>target_predicho</th>\n",
       "      <th>target_predicho_dic</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>40623</th>\n",
       "      <td>40624</td>\n",
       "      <td>49</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>divorciado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>848</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>109</td>\n",
       "      <td>19-jun-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.011085</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30428</th>\n",
       "      <td>30429</td>\n",
       "      <td>60</td>\n",
       "      <td>management</td>\n",
       "      <td>casado</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>261</td>\n",
       "      <td>si</td>\n",
       "      <td>si</td>\n",
       "      <td>movil</td>\n",
       "      <td>128</td>\n",
       "      <td>1-jun-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>192</td>\n",
       "      <td>1</td>\n",
       "      <td>sin_exito</td>\n",
       "      <td>no</td>\n",
       "      <td>0.033559</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4562</th>\n",
       "      <td>4563</td>\n",
       "      <td>53</td>\n",
       "      <td>services</td>\n",
       "      <td>divorciado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>-223</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>160</td>\n",
       "      <td>20-jun-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.029934</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          ID  edad      trabajo estado_civil              educacion deuda  \\\n",
       "40623  40624    49  blue-collar   divorciado  secundaria/superiores    no   \n",
       "30428  30429    60   management       casado         universitarios    no   \n",
       "4562    4563    53     services   divorciado  secundaria/superiores    no   \n",
       "\n",
       "       saldo vivienda prestamo    tipo_contacto  duracion fecha_contacto  \\\n",
       "40623    848       si       no  Sin Información       109    19-jun-2021   \n",
       "30428    261       si       si            movil       128     1-jun-2021   \n",
       "4562    -223       no       no  Sin Información       160    20-jun-2021   \n",
       "\n",
       "       campaign  tiempo_transcurrido  contactos_anteriores  \\\n",
       "40623         1                   -1                     0   \n",
       "30428         1                  192                     1   \n",
       "4562          1                   -1                     0   \n",
       "\n",
       "      resultado_campanas_anteriores target  target_predicho  \\\n",
       "40623               Sin Información     no         0.011085   \n",
       "30428                     sin_exito     no         0.033559   \n",
       "4562                Sin Información     no         0.029934   \n",
       "\n",
       "       target_predicho_dic  \n",
       "40623                False  \n",
       "30428                False  \n",
       "4562                 False  "
      ]
     },
     "execution_count": 146,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 'model' es tu modelo entrenado DecisionTreeClassifier y 'df_train' es tu DataFrame original con las características de entrenamiento\n",
    "# Selecciona todas las características (X) de tu DataFrame original 'df_train'\n",
    "X_base_datos = df_train.drop('target', axis=1, inplace=False)  # Asegúrate de excluir la columna de la variable objetivo si está presente\n",
    "\n",
    "X_base_datos_std=estandarizador.fit_transform(X_base_datos)\n",
    "\n",
    "\n",
    "# Realiza la predicción utilizando el modelo entrenado\n",
    "model_std.fit(X_base_datos_std,y)\n",
    "y_pred_base_datos = model_std.predict_proba(X_base_datos_std)\n",
    "\n",
    "# Ahora 'y_pred_base_datos' contiene las predicciones para toda tu base de datos\n",
    "# utilizaremos la predicion de todo el df y lo agregamos en una nueva columna para comprar valores reales a los predichos\n",
    "\n",
    "df['target_predicho'] = y_pred_base_datos[:,1]\n",
    "df['target_predicho_dic'] = df['target_predicho'] > 0.65\n",
    "\n",
    "df.sample(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "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>ID</th>\n",
       "      <th>edad</th>\n",
       "      <th>trabajo</th>\n",
       "      <th>estado_civil</th>\n",
       "      <th>educacion</th>\n",
       "      <th>deuda</th>\n",
       "      <th>saldo</th>\n",
       "      <th>vivienda</th>\n",
       "      <th>prestamo</th>\n",
       "      <th>tipo_contacto</th>\n",
       "      <th>duracion</th>\n",
       "      <th>fecha_contacto</th>\n",
       "      <th>campaign</th>\n",
       "      <th>tiempo_transcurrido</th>\n",
       "      <th>contactos_anteriores</th>\n",
       "      <th>resultado_campanas_anteriores</th>\n",
       "      <th>target</th>\n",
       "      <th>target_predicho</th>\n",
       "      <th>target_predicho_dic</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>24942</th>\n",
       "      <td>24943</td>\n",
       "      <td>30</td>\n",
       "      <td>admin.</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>116</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>15</td>\n",
       "      <td>31-jul-2021</td>\n",
       "      <td>19</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.003971</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23965</th>\n",
       "      <td>23966</td>\n",
       "      <td>34</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>soltero</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>1351</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>334</td>\n",
       "      <td>14-may-2021</td>\n",
       "      <td>2</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.080792</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6704</th>\n",
       "      <td>6705</td>\n",
       "      <td>23</td>\n",
       "      <td>admin.</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>349</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>108</td>\n",
       "      <td>18-may-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.039072</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41599</th>\n",
       "      <td>41600</td>\n",
       "      <td>74</td>\n",
       "      <td>retired</td>\n",
       "      <td>casado</td>\n",
       "      <td>priamaria</td>\n",
       "      <td>no</td>\n",
       "      <td>0</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>fijo</td>\n",
       "      <td>113</td>\n",
       "      <td>4-sep-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.092105</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40103</th>\n",
       "      <td>40104</td>\n",
       "      <td>35</td>\n",
       "      <td>housemaid</td>\n",
       "      <td>casado</td>\n",
       "      <td>priamaria</td>\n",
       "      <td>no</td>\n",
       "      <td>8127</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>315</td>\n",
       "      <td>6-jun-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.036373</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31088</th>\n",
       "      <td>31089</td>\n",
       "      <td>76</td>\n",
       "      <td>retired</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>2302</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>fijo</td>\n",
       "      <td>110</td>\n",
       "      <td>5-feb-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>87</td>\n",
       "      <td>2</td>\n",
       "      <td>sin_exito</td>\n",
       "      <td>no</td>\n",
       "      <td>0.143108</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34444</th>\n",
       "      <td>34445</td>\n",
       "      <td>33</td>\n",
       "      <td>management</td>\n",
       "      <td>soltero</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>369</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>143</td>\n",
       "      <td>25-aug-2021</td>\n",
       "      <td>10</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.049992</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16011</th>\n",
       "      <td>16012</td>\n",
       "      <td>46</td>\n",
       "      <td>management</td>\n",
       "      <td>soltero</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>244</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>244</td>\n",
       "      <td>15-may-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.024587</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15147</th>\n",
       "      <td>15148</td>\n",
       "      <td>35</td>\n",
       "      <td>unemployed</td>\n",
       "      <td>soltero</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>0</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>740</td>\n",
       "      <td>30-jul-2021</td>\n",
       "      <td>3</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.508779</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13176</th>\n",
       "      <td>13177</td>\n",
       "      <td>52</td>\n",
       "      <td>management</td>\n",
       "      <td>casado</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>168</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>165</td>\n",
       "      <td>28-aug-2021</td>\n",
       "      <td>4</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.074890</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32580</th>\n",
       "      <td>32581</td>\n",
       "      <td>47</td>\n",
       "      <td>unemployed</td>\n",
       "      <td>casado</td>\n",
       "      <td>priamaria</td>\n",
       "      <td>no</td>\n",
       "      <td>122</td>\n",
       "      <td>no</td>\n",
       "      <td>si</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>240</td>\n",
       "      <td>5-jun-2021</td>\n",
       "      <td>3</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.015548</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27807</th>\n",
       "      <td>27808</td>\n",
       "      <td>36</td>\n",
       "      <td>housemaid</td>\n",
       "      <td>soltero</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>7171</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>216</td>\n",
       "      <td>20-may-2021</td>\n",
       "      <td>2</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.016589</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33758</th>\n",
       "      <td>33759</td>\n",
       "      <td>26</td>\n",
       "      <td>unemployed</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>285</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>265</td>\n",
       "      <td>6-may-2021</td>\n",
       "      <td>2</td>\n",
       "      <td>342</td>\n",
       "      <td>2</td>\n",
       "      <td>sin_exito</td>\n",
       "      <td>no</td>\n",
       "      <td>0.071439</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>975</th>\n",
       "      <td>976</td>\n",
       "      <td>35</td>\n",
       "      <td>self-employed</td>\n",
       "      <td>casado</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>333</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>78</td>\n",
       "      <td>17-jun-2021</td>\n",
       "      <td>5</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.014423</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23536</th>\n",
       "      <td>23537</td>\n",
       "      <td>35</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>casado</td>\n",
       "      <td>priamaria</td>\n",
       "      <td>no</td>\n",
       "      <td>0</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>145</td>\n",
       "      <td>21-jul-2021</td>\n",
       "      <td>3</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.045051</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10436</th>\n",
       "      <td>10437</td>\n",
       "      <td>33</td>\n",
       "      <td>management</td>\n",
       "      <td>soltero</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>8514</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>131</td>\n",
       "      <td>20-aug-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.132395</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37644</th>\n",
       "      <td>37645</td>\n",
       "      <td>54</td>\n",
       "      <td>technician</td>\n",
       "      <td>divorciado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>2156</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>261</td>\n",
       "      <td>3-feb-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>195</td>\n",
       "      <td>4</td>\n",
       "      <td>sin_exito</td>\n",
       "      <td>si</td>\n",
       "      <td>0.093079</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32626</th>\n",
       "      <td>32627</td>\n",
       "      <td>32</td>\n",
       "      <td>management</td>\n",
       "      <td>casado</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>2458</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>77</td>\n",
       "      <td>4-may-2021</td>\n",
       "      <td>2</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.032057</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>219</td>\n",
       "      <td>52</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>divorciado</td>\n",
       "      <td>priamaria</td>\n",
       "      <td>no</td>\n",
       "      <td>3990</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>1548</td>\n",
       "      <td>19-nov-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>153</td>\n",
       "      <td>1</td>\n",
       "      <td>otro</td>\n",
       "      <td>no</td>\n",
       "      <td>0.975242</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28036</th>\n",
       "      <td>28037</td>\n",
       "      <td>29</td>\n",
       "      <td>services</td>\n",
       "      <td>soltero</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>1788</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>353</td>\n",
       "      <td>27-oct-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>si</td>\n",
       "      <td>0.237354</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38755</th>\n",
       "      <td>38756</td>\n",
       "      <td>43</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>soltero</td>\n",
       "      <td>priamaria</td>\n",
       "      <td>no</td>\n",
       "      <td>0</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>71</td>\n",
       "      <td>9-may-2021</td>\n",
       "      <td>3</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.015863</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7165</th>\n",
       "      <td>7166</td>\n",
       "      <td>35</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>444</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>244</td>\n",
       "      <td>15-apr-2021</td>\n",
       "      <td>3</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.037446</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41037</th>\n",
       "      <td>41038</td>\n",
       "      <td>58</td>\n",
       "      <td>self-employed</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>1407</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>58</td>\n",
       "      <td>30-may-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.007722</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23360</th>\n",
       "      <td>23361</td>\n",
       "      <td>36</td>\n",
       "      <td>technician</td>\n",
       "      <td>divorciado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>566</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>129</td>\n",
       "      <td>20-may-2021</td>\n",
       "      <td>2</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.011955</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31372</th>\n",
       "      <td>31373</td>\n",
       "      <td>27</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>-335</td>\n",
       "      <td>si</td>\n",
       "      <td>si</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>324</td>\n",
       "      <td>4-jun-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.012163</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41612</th>\n",
       "      <td>41613</td>\n",
       "      <td>41</td>\n",
       "      <td>housemaid</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>13</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>155</td>\n",
       "      <td>11-aug-2021</td>\n",
       "      <td>4</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.042492</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13283</th>\n",
       "      <td>13284</td>\n",
       "      <td>30</td>\n",
       "      <td>technician</td>\n",
       "      <td>soltero</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>1028</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>653</td>\n",
       "      <td>21-nov-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.342348</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22490</th>\n",
       "      <td>22491</td>\n",
       "      <td>49</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>casado</td>\n",
       "      <td>priamaria</td>\n",
       "      <td>no</td>\n",
       "      <td>4</td>\n",
       "      <td>si</td>\n",
       "      <td>si</td>\n",
       "      <td>movil</td>\n",
       "      <td>161</td>\n",
       "      <td>2-feb-2021</td>\n",
       "      <td>2</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.014813</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12210</th>\n",
       "      <td>12211</td>\n",
       "      <td>51</td>\n",
       "      <td>admin.</td>\n",
       "      <td>casado</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>1463</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>fijo</td>\n",
       "      <td>185</td>\n",
       "      <td>23-jul-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.062743</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17222</th>\n",
       "      <td>17223</td>\n",
       "      <td>26</td>\n",
       "      <td>technician</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>370</td>\n",
       "      <td>no</td>\n",
       "      <td>si</td>\n",
       "      <td>movil</td>\n",
       "      <td>1061</td>\n",
       "      <td>8-jul-2021</td>\n",
       "      <td>4</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>si</td>\n",
       "      <td>0.572249</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          ID  edad        trabajo estado_civil              educacion deuda  \\\n",
       "24942  24943    30         admin.       casado  secundaria/superiores    no   \n",
       "23965  23966    34    blue-collar      soltero  secundaria/superiores    no   \n",
       "6704    6705    23         admin.       casado  secundaria/superiores    no   \n",
       "41599  41600    74        retired       casado              priamaria    no   \n",
       "40103  40104    35      housemaid       casado              priamaria    no   \n",
       "31088  31089    76        retired       casado  secundaria/superiores    no   \n",
       "34444  34445    33     management      soltero         universitarios    no   \n",
       "16011  16012    46     management      soltero  secundaria/superiores    no   \n",
       "15147  15148    35     unemployed      soltero  secundaria/superiores    no   \n",
       "13176  13177    52     management       casado         universitarios    no   \n",
       "32580  32581    47     unemployed       casado              priamaria    no   \n",
       "27807  27808    36      housemaid      soltero  secundaria/superiores    no   \n",
       "33758  33759    26     unemployed       casado  secundaria/superiores    no   \n",
       "975      976    35  self-employed       casado         universitarios    no   \n",
       "23536  23537    35    blue-collar       casado              priamaria    no   \n",
       "10436  10437    33     management      soltero         universitarios    no   \n",
       "37644  37645    54     technician   divorciado  secundaria/superiores    no   \n",
       "32626  32627    32     management       casado         universitarios    no   \n",
       "218      219    52    blue-collar   divorciado              priamaria    no   \n",
       "28036  28037    29       services      soltero         universitarios    no   \n",
       "38755  38756    43    blue-collar      soltero              priamaria    no   \n",
       "7165    7166    35    blue-collar       casado  secundaria/superiores    no   \n",
       "41037  41038    58  self-employed       casado  secundaria/superiores    no   \n",
       "23360  23361    36     technician   divorciado  secundaria/superiores    no   \n",
       "31372  31373    27    blue-collar       casado  secundaria/superiores    no   \n",
       "41612  41613    41      housemaid       casado  secundaria/superiores    no   \n",
       "13283  13284    30     technician      soltero         universitarios    no   \n",
       "22490  22491    49    blue-collar       casado              priamaria    no   \n",
       "12210  12211    51         admin.       casado         universitarios    no   \n",
       "17222  17223    26     technician       casado  secundaria/superiores    no   \n",
       "\n",
       "       saldo vivienda prestamo    tipo_contacto  duracion fecha_contacto  \\\n",
       "24942    116       si       no            movil        15    31-jul-2021   \n",
       "23965   1351       si       no            movil       334    14-may-2021   \n",
       "6704     349       si       no            movil       108    18-may-2021   \n",
       "41599      0       no       no             fijo       113     4-sep-2021   \n",
       "40103   8127       no       no  Sin Información       315     6-jun-2021   \n",
       "31088   2302       no       no             fijo       110     5-feb-2021   \n",
       "34444    369       no       no            movil       143    25-aug-2021   \n",
       "16011    244       si       no  Sin Información       244    15-may-2021   \n",
       "15147      0       no       no            movil       740    30-jul-2021   \n",
       "13176    168       no       no            movil       165    28-aug-2021   \n",
       "32580    122       no       si  Sin Información       240     5-jun-2021   \n",
       "27807   7171       si       no  Sin Información       216    20-may-2021   \n",
       "33758    285       si       no            movil       265     6-may-2021   \n",
       "975      333       no       no  Sin Información        78    17-jun-2021   \n",
       "23536      0       no       no            movil       145    21-jul-2021   \n",
       "10436   8514       no       no            movil       131    20-aug-2021   \n",
       "37644   2156       si       no            movil       261     3-feb-2021   \n",
       "32626   2458       si       no            movil        77     4-may-2021   \n",
       "218     3990       no       no            movil      1548    19-nov-2021   \n",
       "28036   1788       no       no            movil       353    27-oct-2021   \n",
       "38755      0       no       no  Sin Información        71     9-may-2021   \n",
       "7165     444       si       no            movil       244    15-apr-2021   \n",
       "41037   1407       si       no  Sin Información        58    30-may-2021   \n",
       "23360    566       si       no  Sin Información       129    20-may-2021   \n",
       "31372   -335       si       si  Sin Información       324     4-jun-2021   \n",
       "41612     13       no       no            movil       155    11-aug-2021   \n",
       "13283   1028       si       no            movil       653    21-nov-2021   \n",
       "22490      4       si       si            movil       161     2-feb-2021   \n",
       "12210   1463       si       no             fijo       185    23-jul-2021   \n",
       "17222    370       no       si            movil      1061     8-jul-2021   \n",
       "\n",
       "       campaign  tiempo_transcurrido  contactos_anteriores  \\\n",
       "24942        19                   -1                     0   \n",
       "23965         2                   -1                     0   \n",
       "6704          1                   -1                     0   \n",
       "41599         1                   -1                     0   \n",
       "40103         1                   -1                     0   \n",
       "31088         1                   87                     2   \n",
       "34444        10                   -1                     0   \n",
       "16011         1                   -1                     0   \n",
       "15147         3                   -1                     0   \n",
       "13176         4                   -1                     0   \n",
       "32580         3                   -1                     0   \n",
       "27807         2                   -1                     0   \n",
       "33758         2                  342                     2   \n",
       "975           5                   -1                     0   \n",
       "23536         3                   -1                     0   \n",
       "10436         1                   -1                     0   \n",
       "37644         1                  195                     4   \n",
       "32626         2                   -1                     0   \n",
       "218           1                  153                     1   \n",
       "28036         1                   -1                     0   \n",
       "38755         3                   -1                     0   \n",
       "7165          3                   -1                     0   \n",
       "41037         1                   -1                     0   \n",
       "23360         2                   -1                     0   \n",
       "31372         1                   -1                     0   \n",
       "41612         4                   -1                     0   \n",
       "13283         1                   -1                     0   \n",
       "22490         2                   -1                     0   \n",
       "12210         1                   -1                     0   \n",
       "17222         4                   -1                     0   \n",
       "\n",
       "      resultado_campanas_anteriores target  target_predicho  \\\n",
       "24942               Sin Información     no         0.003971   \n",
       "23965               Sin Información     no         0.080792   \n",
       "6704                Sin Información     no         0.039072   \n",
       "41599               Sin Información     no         0.092105   \n",
       "40103               Sin Información     no         0.036373   \n",
       "31088                     sin_exito     no         0.143108   \n",
       "34444               Sin Información     no         0.049992   \n",
       "16011               Sin Información     no         0.024587   \n",
       "15147               Sin Información     no         0.508779   \n",
       "13176               Sin Información     no         0.074890   \n",
       "32580               Sin Información     no         0.015548   \n",
       "27807               Sin Información     no         0.016589   \n",
       "33758                     sin_exito     no         0.071439   \n",
       "975                 Sin Información     no         0.014423   \n",
       "23536               Sin Información     no         0.045051   \n",
       "10436               Sin Información     no         0.132395   \n",
       "37644                     sin_exito     si         0.093079   \n",
       "32626               Sin Información     no         0.032057   \n",
       "218                            otro     no         0.975242   \n",
       "28036               Sin Información     si         0.237354   \n",
       "38755               Sin Información     no         0.015863   \n",
       "7165                Sin Información     no         0.037446   \n",
       "41037               Sin Información     no         0.007722   \n",
       "23360               Sin Información     no         0.011955   \n",
       "31372               Sin Información     no         0.012163   \n",
       "41612               Sin Información     no         0.042492   \n",
       "13283               Sin Información     no         0.342348   \n",
       "22490               Sin Información     no         0.014813   \n",
       "12210               Sin Información     no         0.062743   \n",
       "17222               Sin Información     si         0.572249   \n",
       "\n",
       "       target_predicho_dic  \n",
       "24942                False  \n",
       "23965                False  \n",
       "6704                 False  \n",
       "41599                False  \n",
       "40103                False  \n",
       "31088                False  \n",
       "34444                False  \n",
       "16011                False  \n",
       "15147                False  \n",
       "13176                False  \n",
       "32580                False  \n",
       "27807                False  \n",
       "33758                False  \n",
       "975                  False  \n",
       "23536                False  \n",
       "10436                False  \n",
       "37644                False  \n",
       "32626                False  \n",
       "218                   True  \n",
       "28036                False  \n",
       "38755                False  \n",
       "7165                 False  \n",
       "41037                False  \n",
       "23360                False  \n",
       "31372                False  \n",
       "41612                False  \n",
       "13283                False  \n",
       "22490                False  \n",
       "12210                False  \n",
       "17222                False  "
      ]
     },
     "execution_count": 147,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sample(30)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(array([30397.,  5819.,  2015.,  1009.,   741.,   568.,   605.,   518.,\n",
       "          381.,   393.]),\n",
       " array([1.68601370e-05, 1.00015167e-01, 2.00013473e-01, 3.00011780e-01,\n",
       "        4.00010086e-01, 5.00008393e-01, 6.00006699e-01, 7.00005006e-01,\n",
       "        8.00003312e-01, 9.00001619e-01, 9.99999925e-01]),\n",
       " <BarContainer object of 10 artists>)"
      ]
     },
     "execution_count": 148,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAjkAAAGdCAYAAADwjmIIAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjguMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8g+/7EAAAACXBIWXMAAA9hAAAPYQGoP6dpAAAqlklEQVR4nO3df3BU9b3/8VcS3A0ouxExCbmEH8IViPzSAGH91aK5rBKtXHEKytCIQS40YUrS8kv4BsTewmCtUEEYa2v8A8qPjtCaYDAGgasEkECugIZbNdzAwAYUkoWoSUjO949OzmVLUDbkh/vh+Zg5I3vO+3z2fT4G9jVnzzkJsyzLEgAAgGHC27sBAACA1kDIAQAARiLkAAAAIxFyAACAkQg5AADASIQcAABgJEIOAAAwEiEHAAAYqUN7N9CeGhoadPLkSXXu3FlhYWHt3Q4AALgKlmXp/PnziouLU3j4lc/XXNch5+TJk4qPj2/vNgAAQDMcP35c3bt3v+L26zrkdO7cWdI/JsnlcrVzNwAA4Gr4/X7Fx8fbn+NXcl2HnMavqFwuFyEHAIAQ832XmnDhMQAAMBIhBwAAGImQAwAAjETIAQAARiLkAAAAIxFyAACAkQg5AADASIQcAABgJEIOAAAwEiEHAAAYiZADAACMRMgBAABGIuQAAAAjEXIAAICROrR3A6bqNTevvVsI2rGlKe3dAgAALSaoMzmrV6/W4MGD5XK55HK55PF49M4779jbv/32W6Wnp+uWW27RTTfdpHHjxqmioiJgjPLycqWkpKhTp06Kjo7WrFmzdPHixYCaHTt26K677pLT6VTfvn2Vk5NzWS+rVq1Sr169FBkZqaSkJO3bty+YQwEAAIYLKuR0795dS5cuVXFxsfbv368HHnhAjz32mI4cOSJJyszM1Ntvv61NmzZp586dOnnypB5//HF7//r6eqWkpKi2tla7d+/Wm2++qZycHGVnZ9s1ZWVlSklJ0ahRo1RSUqKZM2dqypQp2rZtm12zYcMGZWVlaeHChTpw4ICGDBkir9er06dPX+t8AAAAQ4RZlmVdywBdunTRiy++qCeeeEK33nqr1q1bpyeeeEKSVFpaqgEDBqioqEgjR47UO++8o0ceeUQnT55UTEyMJGnNmjWaM2eOzpw5I4fDoTlz5igvL0+HDx+232PChAmqrKxUfn6+JCkpKUnDhw/XypUrJUkNDQ2Kj4/XjBkzNHfu3Kvu3e/3y+12q6qqSi6X61qm4TJ8XQUAQOu42s/vZl94XF9fr/Xr16u6uloej0fFxcWqq6tTcnKyXdO/f3/16NFDRUVFkqSioiINGjTIDjiS5PV65ff77bNBRUVFAWM01jSOUVtbq+Li4oCa8PBwJScn2zVXUlNTI7/fH7AAAAAzBR1yDh06pJtuuklOp1PTpk3T5s2blZCQIJ/PJ4fDoaioqID6mJgY+Xw+SZLP5wsIOI3bG7d9V43f79c333yjL7/8UvX19U3WNI5xJUuWLJHb7baX+Pj4YA8fAACEiKBDTr9+/VRSUqK9e/dq+vTpSk1N1SeffNIavbW4efPmqaqqyl6OHz/e3i0BAIBWEvQt5A6HQ3379pUkJSYm6qOPPtKKFSs0fvx41dbWqrKyMuBsTkVFhWJjYyVJsbGxl90F1Xj31aU1/3xHVkVFhVwulzp27KiIiAhFREQ0WdM4xpU4nU45nc5gDxkAAISga34YYENDg2pqapSYmKgbbrhBhYWF9rajR4+qvLxcHo9HkuTxeHTo0KGAu6AKCgrkcrmUkJBg11w6RmNN4xgOh0OJiYkBNQ0NDSosLLRrAAAAgjqTM2/ePD388MPq0aOHzp8/r3Xr1mnHjh3atm2b3G630tLSlJWVpS5dusjlcmnGjBnyeDwaOXKkJGn06NFKSEjQpEmTtGzZMvl8Pi1YsEDp6en2GZZp06Zp5cqVmj17tp555hlt375dGzduVF7e/92tlJWVpdTUVA0bNkwjRozQ8uXLVV1drcmTJ7fg1AAAgFAWVMg5ffq0fvazn+nUqVNyu90aPHiwtm3bpn/7t3+TJL388ssKDw/XuHHjVFNTI6/Xq1dffdXePyIiQrm5uZo+fbo8Ho9uvPFGpaamavHixXZN7969lZeXp8zMTK1YsULdu3fX66+/Lq/Xa9eMHz9eZ86cUXZ2tnw+n4YOHar8/PzLLkYGAADXr2t+Tk4o4zk5gXhODgAgFLT6c3IAAAB+yAg5AADASIQcAABgJEIOAAAwEiEHAAAYiZADAACMRMgBAABGIuQAAAAjEXIAAICRCDkAAMBIhBwAAGAkQg4AADASIQcAABiJkAMAAIxEyAEAAEYi5AAAACMRcgAAgJEIOQAAwEiEHAAAYCRCDgAAMBIhBwAAGImQAwAAjETIAQAARiLkAAAAIxFyAACAkQg5AADASIQcAABgJEIOAAAwEiEHAAAYiZADAACMRMgBAABGIuQAAAAjEXIAAICRCDkAAMBIhBwAAGAkQg4AADASIQcAABiJkAMAAIxEyAEAAEYi5AAAACMRcgAAgJEIOQAAwEiEHAAAYCRCDgAAMBIhBwAAGImQAwAAjETIAQAARgoq5CxZskTDhw9X586dFR0drbFjx+ro0aMBNT/+8Y8VFhYWsEybNi2gpry8XCkpKerUqZOio6M1a9YsXbx4MaBmx44duuuuu+R0OtW3b1/l5ORc1s+qVavUq1cvRUZGKikpSfv27QvmcAAAgMGCCjk7d+5Uenq69uzZo4KCAtXV1Wn06NGqrq4OqHv22Wd16tQpe1m2bJm9rb6+XikpKaqtrdXu3bv15ptvKicnR9nZ2XZNWVmZUlJSNGrUKJWUlGjmzJmaMmWKtm3bZtds2LBBWVlZWrhwoQ4cOKAhQ4bI6/Xq9OnTzZ0LAABgkDDLsqzm7nzmzBlFR0dr586duv/++yX940zO0KFDtXz58ib3eeedd/TII4/o5MmTiomJkSStWbNGc+bM0ZkzZ+RwODRnzhzl5eXp8OHD9n4TJkxQZWWl8vPzJUlJSUkaPny4Vq5cKUlqaGhQfHy8ZsyYoblz515V/36/X263W1VVVXK5XM2dhib1mpvXouO1hWNLU9q7BQAAvtfVfn5f0zU5VVVVkqQuXboErF+7dq26du2qgQMHat68efr666/tbUVFRRo0aJAdcCTJ6/XK7/fryJEjdk1ycnLAmF6vV0VFRZKk2tpaFRcXB9SEh4crOTnZrmlKTU2N/H5/wAIAAMzUobk7NjQ0aObMmbrnnns0cOBAe/1TTz2lnj17Ki4uTh9//LHmzJmjo0eP6q233pIk+Xy+gIAjyX7t8/m+s8bv9+ubb77RuXPnVF9f32RNaWnpFXtesmSJnn/++eYeMgAACCHNDjnp6ek6fPiwPvjgg4D1U6dOtf88aNAgdevWTQ8++KA+//xz9enTp/mdtoB58+YpKyvLfu33+xUfH9+OHQEAgNbSrJCTkZGh3Nxc7dq1S927d//O2qSkJEnSZ599pj59+ig2Nvayu6AqKiokSbGxsfZ/G9ddWuNyudSxY0dFREQoIiKiyZrGMZridDrldDqv7iABAEBIC+qaHMuylJGRoc2bN2v79u3q3bv39+5TUlIiSerWrZskyePx6NChQwF3QRUUFMjlcikhIcGuKSwsDBinoKBAHo9HkuRwOJSYmBhQ09DQoMLCQrsGAABc34I6k5Oenq5169bpr3/9qzp37mxfQ+N2u9WxY0d9/vnnWrduncaMGaNbbrlFH3/8sTIzM3X//fdr8ODBkqTRo0crISFBkyZN0rJly+Tz+bRgwQKlp6fbZ1mmTZumlStXavbs2XrmmWe0fft2bdy4UXl5/3fHUlZWllJTUzVs2DCNGDFCy5cvV3V1tSZPntxScwMAAEJYUCFn9erVkv5xm/il3njjDT399NNyOBx677337MARHx+vcePGacGCBXZtRESEcnNzNX36dHk8Ht14441KTU3V4sWL7ZrevXsrLy9PmZmZWrFihbp3767XX39dXq/Xrhk/frzOnDmj7Oxs+Xw+DR06VPn5+ZddjAwAAK5P1/ScnFDHc3IC8ZwcAEAoaJPn5AAAAPxQEXIAAICRCDkAAMBIhBwAAGAkQg4AADASIQcAABiJkAMAAIxEyAEAAEYi5AAAACMRcgAAgJEIOQAAwEiEHAAAYCRCDgAAMBIhBwAAGImQAwAAjETIAQAARiLkAAAAIxFyAACAkQg5AADASIQcAABgJEIOAAAwEiEHAAAYiZADAACMRMgBAABGIuQAAAAjEXIAAICRCDkAAMBIhBwAAGAkQg4AADASIQcAABiJkAMAAIxEyAEAAEYi5AAAACMRcgAAgJEIOQAAwEiEHAAAYCRCDgAAMBIhBwAAGImQAwAAjETIAQAARiLkAAAAIxFyAACAkQg5AADASIQcAABgJEIOAAAwEiEHAAAYKaiQs2TJEg0fPlydO3dWdHS0xo4dq6NHjwbUfPvtt0pPT9ctt9yim266SePGjVNFRUVATXl5uVJSUtSpUydFR0dr1qxZunjxYkDNjh07dNddd8npdKpv377Kycm5rJ9Vq1apV69eioyMVFJSkvbt2xfM4QAAAIMFFXJ27typ9PR07dmzRwUFBaqrq9Po0aNVXV1t12RmZurtt9/Wpk2btHPnTp08eVKPP/64vb2+vl4pKSmqra3V7t279eabbyonJ0fZ2dl2TVlZmVJSUjRq1CiVlJRo5syZmjJlirZt22bXbNiwQVlZWVq4cKEOHDigIUOGyOv16vTp09cyHwAAwBBhlmVZzd35zJkzio6O1s6dO3X//ferqqpKt956q9atW6cnnnhCklRaWqoBAwaoqKhII0eO1DvvvKNHHnlEJ0+eVExMjCRpzZo1mjNnjs6cOSOHw6E5c+YoLy9Phw8ftt9rwoQJqqysVH5+viQpKSlJw4cP18qVKyVJDQ0Nio+P14wZMzR37tyr6t/v98vtdquqqkoul6u509CkXnPzWnS8tnBsaUp7twAAwPe62s/va7omp6qqSpLUpUsXSVJxcbHq6uqUnJxs1/Tv3189evRQUVGRJKmoqEiDBg2yA44keb1e+f1+HTlyxK65dIzGmsYxamtrVVxcHFATHh6u5ORkuwYAAFzfOjR3x4aGBs2cOVP33HOPBg4cKEny+XxyOByKiooKqI2JiZHP57NrLg04jdsbt31Xjd/v1zfffKNz586pvr6+yZrS0tIr9lxTU6Oamhr7td/vD+KIAQBAKGn2mZz09HQdPnxY69evb8l+WtWSJUvkdrvtJT4+vr1bAgAAraRZIScjI0O5ubl6//331b17d3t9bGysamtrVVlZGVBfUVGh2NhYu+af77ZqfP19NS6XSx07dlTXrl0VERHRZE3jGE2ZN2+eqqqq7OX48ePBHTgAAAgZQYUcy7KUkZGhzZs3a/v27erdu3fA9sTERN1www0qLCy01x09elTl5eXyeDySJI/Ho0OHDgXcBVVQUCCXy6WEhAS75tIxGmsax3A4HEpMTAyoaWhoUGFhoV3TFKfTKZfLFbAAAAAzBXVNTnp6utatW6e//vWv6ty5s30NjdvtVseOHeV2u5WWlqasrCx16dJFLpdLM2bMkMfj0ciRIyVJo0ePVkJCgiZNmqRly5bJ5/NpwYIFSk9Pl9PplCRNmzZNK1eu1OzZs/XMM89o+/bt2rhxo/Ly/u+OpaysLKWmpmrYsGEaMWKEli9frurqak2ePLml5gYAAISwoELO6tWrJUk//vGPA9a/8cYbevrppyVJL7/8ssLDwzVu3DjV1NTI6/Xq1VdftWsjIiKUm5ur6dOny+Px6MYbb1RqaqoWL15s1/Tu3Vt5eXnKzMzUihUr1L17d73++uvyer12zfjx43XmzBllZ2fL5/Np6NChys/Pv+xiZAAAcH26pufkhDqekxOI5+QAAEJBmzwnBwAA4IeKkAMAAIxEyAEAAEYi5AAAACMRcgAAgJEIOQAAwEiEHAAAYCRCDgAAMBIhBwAAGImQAwAAjETIAQAARiLkAAAAIxFyAACAkQg5AADASIQcAABgJEIOAAAwEiEHAAAYiZADAACMRMgBAABGIuQAAAAjEXIAAICRCDkAAMBIhBwAAGAkQg4AADASIQcAABiJkAMAAIxEyAEAAEYi5AAAACMRcgAAgJEIOQAAwEiEHAAAYCRCDgAAMBIhBwAAGImQAwAAjETIAQAARiLkAAAAIxFyAACAkQg5AADASIQcAABgJEIOAAAwEiEHAAAYiZADAACMRMgBAABGIuQAAAAjEXIAAICRCDkAAMBIhBwAAGCkoEPOrl279OijjyouLk5hYWHasmVLwPann35aYWFhActDDz0UUHP27FlNnDhRLpdLUVFRSktL04ULFwJqPv74Y913332KjIxUfHy8li1bdlkvmzZtUv/+/RUZGalBgwZp69atwR4OAAAwVNAhp7q6WkOGDNGqVauuWPPQQw/p1KlT9vLnP/85YPvEiRN15MgRFRQUKDc3V7t27dLUqVPt7X6/X6NHj1bPnj1VXFysF198UYsWLdJrr71m1+zevVtPPvmk0tLSdPDgQY0dO1Zjx47V4cOHgz0kAABgoDDLsqxm7xwWps2bN2vs2LH2uqefflqVlZWXneFp9OmnnyohIUEfffSRhg0bJknKz8/XmDFjdOLECcXFxWn16tWaP3++fD6fHA6HJGnu3LnasmWLSktLJUnjx49XdXW1cnNz7bFHjhypoUOHas2aNVfVv9/vl9vtVlVVlVwuVzNm4Mp6zc1r0fHawrGlKe3dAgAA3+tqP79b5ZqcHTt2KDo6Wv369dP06dP11Vdf2duKiooUFRVlBxxJSk5OVnh4uPbu3WvX3H///XbAkSSv16ujR4/q3Llzdk1ycnLA+3q9XhUVFbXGIQEAgBDToaUHfOihh/T444+rd+/e+vzzz/Xcc8/p4YcfVlFRkSIiIuTz+RQdHR3YRIcO6tKli3w+nyTJ5/Opd+/eATUxMTH2tptvvlk+n89ed2lN4xhNqampUU1Njf3a7/df07ECAIAfrhYPORMmTLD/PGjQIA0ePFh9+vTRjh079OCDD7b02wVlyZIlev7559u1BwAA0DZa/Rby2267TV27dtVnn30mSYqNjdXp06cDai5evKizZ88qNjbWrqmoqAioaXz9fTWN25syb948VVVV2cvx48ev7eAAAMAPVquHnBMnTuirr75St27dJEkej0eVlZUqLi62a7Zv366GhgYlJSXZNbt27VJdXZ1dU1BQoH79+unmm2+2awoLCwPeq6CgQB6P54q9OJ1OuVyugAUAAJgp6JBz4cIFlZSUqKSkRJJUVlamkpISlZeX68KFC5o1a5b27NmjY8eOqbCwUI899pj69u0rr9crSRowYIAeeughPfvss9q3b58+/PBDZWRkaMKECYqLi5MkPfXUU3I4HEpLS9ORI0e0YcMGrVixQllZWXYfv/jFL5Sfn6+XXnpJpaWlWrRokfbv36+MjIwWmBYAABDqgg45+/fv15133qk777xTkpSVlaU777xT2dnZioiI0Mcff6yf/OQnuv3225WWlqbExET913/9l5xOpz3G2rVr1b9/fz344IMaM2aM7r333oBn4Ljdbr377rsqKytTYmKifvnLXyo7OzvgWTp333231q1bp9dee01DhgzRX/7yF23ZskUDBw68lvkAAACGuKbn5IQ6npMTiOfkAABCQbs+JwcAAKC9EXIAAICRCDkAAMBIhBwAAGAkQg4AADASIQcAABiJkAMAAIxEyAEAAEYi5AAAACMRcgAAgJEIOQAAwEiEHAAAYCRCDgAAMBIhBwAAGImQAwAAjETIAQAARiLkAAAAIxFyAACAkQg5AADASIQcAABgJEIOAAAwEiEHAAAYiZADAACMRMgBAABGIuQAAAAjEXIAAICRCDkAAMBIhBwAAGAkQg4AADASIQcAABiJkAMAAIxEyAEAAEYi5AAAACMRcgAAgJEIOQAAwEiEHAAAYCRCDgAAMBIhBwAAGImQAwAAjETIAQAARiLkAAAAIxFyAACAkQg5AADASIQcAABgJEIOAAAwEiEHAAAYiZADAACMFHTI2bVrlx599FHFxcUpLCxMW7ZsCdhuWZays7PVrVs3dezYUcnJyfr73/8eUHP27FlNnDhRLpdLUVFRSktL04ULFwJqPv74Y913332KjIxUfHy8li1bdlkvmzZtUv/+/RUZGalBgwZp69atwR4OAAAwVNAhp7q6WkOGDNGqVaua3L5s2TL9/ve/15o1a7R3717deOON8nq9+vbbb+2aiRMn6siRIyooKFBubq527dqlqVOn2tv9fr9Gjx6tnj17qri4WC+++KIWLVqk1157za7ZvXu3nnzySaWlpengwYMaO3asxo4dq8OHDwd7SAAAwEBhlmVZzd45LEybN2/W2LFjJf3jLE5cXJx++ctf6le/+pUkqaqqSjExMcrJydGECRP06aefKiEhQR999JGGDRsmScrPz9eYMWN04sQJxcXFafXq1Zo/f758Pp8cDockae7cudqyZYtKS0slSePHj1d1dbVyc3PtfkaOHKmhQ4dqzZo1V9W/3++X2+1WVVWVXC5Xc6ehSb3m5rXoeG3h2NKU9m4BAIDvdbWf3y16TU5ZWZl8Pp+Sk5PtdW63W0lJSSoqKpIkFRUVKSoqyg44kpScnKzw8HDt3bvXrrn//vvtgCNJXq9XR48e1blz5+yaS9+nsabxfZpSU1Mjv98fsAAAADO1aMjx+XySpJiYmID1MTEx9jafz6fo6OiA7R06dFCXLl0Capoa49L3uFJN4/amLFmyRG63217i4+ODPUQAABAirqu7q+bNm6eqqip7OX78eHu3BAAAWkmLhpzY2FhJUkVFRcD6iooKe1tsbKxOnz4dsP3ixYs6e/ZsQE1TY1z6HleqadzeFKfTKZfLFbAAAAAztWjI6d27t2JjY1VYWGiv8/v92rt3rzwejyTJ4/GosrJSxcXFds327dvV0NCgpKQku2bXrl2qq6uzawoKCtSvXz/dfPPNds2l79NY0/g+AADg+hZ0yLlw4YJKSkpUUlIi6R8XG5eUlKi8vFxhYWGaOXOmfv3rX+tvf/ubDh06pJ/97GeKi4uz78AaMGCAHnroIT377LPat2+fPvzwQ2VkZGjChAmKi4uTJD311FNyOBxKS0vTkSNHtGHDBq1YsUJZWVl2H7/4xS+Un5+vl156SaWlpVq0aJH279+vjIyMa58VAAAQ8joEu8P+/fs1atQo+3Vj8EhNTVVOTo5mz56t6upqTZ06VZWVlbr33nuVn5+vyMhIe5+1a9cqIyNDDz74oMLDwzVu3Dj9/ve/t7e73W69++67Sk9PV2Jiorp27ars7OyAZ+ncfffdWrdunRYsWKDnnntO//qv/6otW7Zo4MCBzZoIAABglmt6Tk6o4zk5gXhODgAgFLTLc3IAAAB+KAg5AADASIQcAABgJEIOAAAwEiEHAAAYiZADAACMRMgBAABGIuQAAAAjEXIAAICRCDkAAMBIhBwAAGAkQg4AADASIQcAABiJkAMAAIxEyAEAAEYi5AAAACMRcgAAgJEIOQAAwEiEHAAAYCRCDgAAMBIhBwAAGImQAwAAjETIAQAARiLkAAAAIxFyAACAkQg5AADASIQcAABgJEIOAAAwEiEHAAAYiZADAACMRMgBAABGIuQAAAAjEXIAAICRCDkAAMBIhBwAAGAkQg4AADASIQcAABiJkAMAAIxEyAEAAEYi5AAAACMRcgAAgJEIOQAAwEgd2rsB/HD0mpvX3i0E7djSlPZuAQDwA8WZHAAAYCRCDgAAMBIhBwAAGImQAwAAjNTiIWfRokUKCwsLWPr3729v//bbb5Wenq5bbrlFN910k8aNG6eKioqAMcrLy5WSkqJOnTopOjpas2bN0sWLFwNqduzYobvuuktOp1N9+/ZVTk5OSx8KAAAIYa1yJueOO+7QqVOn7OWDDz6wt2VmZurtt9/Wpk2btHPnTp08eVKPP/64vb2+vl4pKSmqra3V7t279eabbyonJ0fZ2dl2TVlZmVJSUjRq1CiVlJRo5syZmjJlirZt29YahwMAAEJQq9xC3qFDB8XGxl62vqqqSn/84x+1bt06PfDAA5KkN954QwMGDNCePXs0cuRIvfvuu/rkk0/03nvvKSYmRkOHDtULL7ygOXPmaNGiRXI4HFqzZo169+6tl156SZI0YMAAffDBB3r55Zfl9Xpb45AAAECIaZUzOX//+98VFxen2267TRMnTlR5ebkkqbi4WHV1dUpOTrZr+/fvrx49eqioqEiSVFRUpEGDBikmJsau8Xq98vv9OnLkiF1z6RiNNY1jXElNTY38fn/AAgAAzNTiIScpKUk5OTnKz8/X6tWrVVZWpvvuu0/nz5+Xz+eTw+FQVFRUwD4xMTHy+XySJJ/PFxBwGrc3bvuuGr/fr2+++eaKvS1ZskRut9te4uPjr/VwAQDAD1SLf1318MMP238ePHiwkpKS1LNnT23cuFEdO3Zs6bcLyrx585SVlWW/9vv9BB0AAAzV6reQR0VF6fbbb9dnn32m2NhY1dbWqrKyMqCmoqLCvoYnNjb2srutGl9/X43L5frOIOV0OuVyuQIWAABgplYPORcuXNDnn3+ubt26KTExUTfccIMKCwvt7UePHlV5ebk8Ho8kyePx6NChQzp9+rRdU1BQIJfLpYSEBLvm0jEaaxrHAAAAaPGQ86tf/Uo7d+7UsWPHtHv3bv37v/+7IiIi9OSTT8rtdistLU1ZWVl6//33VVxcrMmTJ8vj8WjkyJGSpNGjRyshIUGTJk3Sf//3f2vbtm1asGCB0tPT5XQ6JUnTpk3TF198odmzZ6u0tFSvvvqqNm7cqMzMzJY+HAAAEKJa/JqcEydO6Mknn9RXX32lW2+9Vffee6/27NmjW2+9VZL08ssvKzw8XOPGjVNNTY28Xq9effVVe/+IiAjl5uZq+vTp8ng8uvHGG5WamqrFixfbNb1791ZeXp4yMzO1YsUKde/eXa+//jq3jwMAAFuYZVlWezfRXvx+v9xut6qqqlr8+pxec/NadDw07djSlPZuAQDQxq7285vfXQUAAIxEyAEAAEYi5AAAACMRcgAAgJEIOQAAwEiEHAAAYCRCDgAAMBIhBwAAGImQAwAAjETIAQAARiLkAAAAIxFyAACAkQg5AADASIQcAABgJEIOAAAwEiEHAAAYiZADAACMRMgBAABGIuQAAAAjEXIAAICRCDkAAMBIhBwAAGAkQg4AADASIQcAABiJkAMAAIxEyAEAAEYi5AAAACMRcgAAgJE6tHcDwLXoNTevvVsI2rGlKe3dAgBcFziTAwAAjETIAQAARiLkAAAAIxFyAACAkQg5AADASIQcAABgJEIOAAAwEiEHAAAYiZADAACMRMgBAABGIuQAAAAj8burgDYWir9vS+J3bgEIPZzJAQAARiLkAAAAI/F1FYCrEopfs/EVG3B9I+QAwA8IYRJoOYQcAMYKxcAQikJxnglm1weuyQEAAEYK+TM5q1at0osvviifz6chQ4bolVde0YgRI9q7LQDAD1gonn0KRe19xiykz+Rs2LBBWVlZWrhwoQ4cOKAhQ4bI6/Xq9OnT7d0aAABoZyEdcn73u9/p2Wef1eTJk5WQkKA1a9aoU6dO+tOf/tTerQEAgHYWsl9X1dbWqri4WPPmzbPXhYeHKzk5WUVFRU3uU1NTo5qaGvt1VVWVJMnv97d4fw01X7f4mAAAhJLW+Hy9dFzLsr6zLmRDzpdffqn6+nrFxMQErI+JiVFpaWmT+yxZskTPP//8Zevj4+NbpUcAAK5n7uWtO/758+fldruvuD1kQ05zzJs3T1lZWfbrhoYGnT17VrfccovCwsJa7H38fr/i4+N1/PhxuVyuFhsXgZjntsNctw3muW0wz22jNefZsiydP39ecXFx31kXsiGna9euioiIUEVFRcD6iooKxcbGNrmP0+mU0+kMWBcVFdVaLcrlcvEXqA0wz22HuW4bzHPbYJ7bRmvN83edwWkUshceOxwOJSYmqrCw0F7X0NCgwsJCeTyeduwMAAD8EITsmRxJysrKUmpqqoYNG6YRI0Zo+fLlqq6u1uTJk9u7NQAA0M5COuSMHz9eZ86cUXZ2tnw+n4YOHar8/PzLLkZua06nUwsXLrzsqzG0LOa57TDXbYN5bhvMc9v4IcxzmPV9918BAACEoJC9JgcAAOC7EHIAAICRCDkAAMBIhBwAAGAkQk4zrVq1Sr169VJkZKSSkpK0b9++76zftGmT+vfvr8jISA0aNEhbt25to05DWzDz/Ic//EH33Xefbr75Zt18881KTk7+3v8v+Idgf54brV+/XmFhYRo7dmzrNmiQYOe6srJS6enp6tatm5xOp26//Xb+/bgKwc7z8uXL1a9fP3Xs2FHx8fHKzMzUt99+20bdhqZdu3bp0UcfVVxcnMLCwrRly5bv3WfHjh2666675HQ61bdvX+Xk5LRukxaCtn79esvhcFh/+tOfrCNHjljPPvusFRUVZVVUVDRZ/+GHH1oRERHWsmXLrE8++cRasGCBdcMNN1iHDh1q485DS7Dz/NRTT1mrVq2yDh48aH366afW008/bbndbuvEiRNt3HloCXaeG5WVlVn/8i//Yt13333WY4891jbNhrhg57qmpsYaNmyYNWbMGOuDDz6wysrKrB07dlglJSVt3HloCXae165dazmdTmvt2rVWWVmZtW3bNqtbt25WZmZmG3ceWrZu3WrNnz/feuuttyxJ1ubNm7+z/osvvrA6depkZWVlWZ988on1yiuvWBEREVZ+fn6r9UjIaYYRI0ZY6enp9uv6+norLi7OWrJkSZP1P/3pT62UlJSAdUlJSdZ//Md/tGqfoS7Yef5nFy9etDp37my9+eabrdWiEZozzxcvXrTuvvtu6/XXX7dSU1MJOVcp2LlevXq1ddttt1m1tbVt1aIRgp3n9PR064EHHghYl5WVZd1zzz2t2qdJribkzJ4927rjjjsC1o0fP97yer2t1hdfVwWptrZWxcXFSk5OtteFh4crOTlZRUVFTe5TVFQUUC9JXq/3ivVo3jz/s6+//lp1dXXq0qVLa7UZ8po7z4sXL1Z0dLTS0tLaok0jNGeu//a3v8nj8Sg9PV0xMTEaOHCgfvOb36i+vr6t2g45zZnnu+++W8XFxfZXWl988YW2bt2qMWPGtEnP14v2+CwM6Scet4cvv/xS9fX1lz1VOSYmRqWlpU3u4/P5mqz3+Xyt1meoa848/7M5c+YoLi7usr9U+D/NmecPPvhAf/zjH1VSUtIGHZqjOXP9xRdfaPv27Zo4caK2bt2qzz77TD//+c9VV1enhQsXtkXbIac58/zUU0/pyy+/1L333ivLsnTx4kVNmzZNzz33XFu0fN240meh3+/XN998o44dO7b4e3ImB0ZaunSp1q9fr82bNysyMrK92zHG+fPnNWnSJP3hD39Q165d27sd4zU0NCg6OlqvvfaaEhMTNX78eM2fP19r1qxp79aMsmPHDv3mN7/Rq6++qgMHDuitt95SXl6eXnjhhfZuDdeIMzlB6tq1qyIiIlRRURGwvqKiQrGxsU3uExsbG1Q9mjfPjX77299q6dKleu+99zR48ODWbDPkBTvPn3/+uY4dO6ZHH33UXtfQ0CBJ6tChg44ePao+ffq0btMhqjk/0926ddMNN9ygiIgIe92AAQPk8/lUW1srh8PRqj2HoubM8//7f/9PkyZN0pQpUyRJgwYNUnV1taZOnar58+crPJzzAS3hSp+FLperVc7iSJzJCZrD4VBiYqIKCwvtdQ0NDSosLJTH42lyH4/HE1AvSQUFBVesR/PmWZKWLVumF154Qfn5+Ro2bFhbtBrSgp3n/v3769ChQyopKbGXn/zkJxo1apRKSkoUHx/flu2HlOb8TN9zzz367LPP7CApSf/zP/+jbt26EXCuoDnz/PXXX18WZBqDpcWvd2wx7fJZ2GqXNBts/fr1ltPptHJycqxPPvnEmjp1qhUVFWX5fD7Lsixr0qRJ1ty5c+36Dz/80OrQoYP129/+1vr000+thQsXcgv5VQh2npcuXWo5HA7rL3/5i3Xq1Cl7OX/+fHsdQkgIdp7/GXdXXb1g57q8vNzq3LmzlZGRYR09etTKzc21oqOjrV//+tftdQghIdh5XrhwodW5c2frz3/+s/XFF19Y7777rtWnTx/rpz/9aXsdQkg4f/68dfDgQevgwYOWJOt3v/uddfDgQet///d/LcuyrLlz51qTJk2y6xtvIZ81a5b16aefWqtWreIW8h+qV155xerRo4flcDisESNGWHv27LG3/ehHP7JSU1MD6jdu3GjdfvvtlsPhsO644w4rLy+vjTsOTcHMc8+ePS1Jly0LFy5s+8ZDTLA/z5ci5AQn2LnevXu3lZSUZDmdTuu2226z/vM//9O6ePFiG3cdeoKZ57q6OmvRokVWnz59rMjISCs+Pt76+c9/bp07d67tGw8h77//fpP/5jbObWpqqvWjH/3osn2GDh1qORwO67bbbrPeeOONVu0xzLI4FwcAAMzDNTkAAMBIhBwAAGAkQg4AADASIQcAABiJkAMAAIxEyAEAAEYi5AAAACMRcgAAgJEIOQAAwEiEHAAAYCRCDgAAMBIhBwAAGOn/A4ssAu+X/5VzAAAAAElFTkSuQmCC",
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.hist(df['target_predicho'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "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>target</th>\n",
       "      <th>target_predicho</th>\n",
       "      <th>target_predicho_dic</th>\n",
       "      <th>ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>36661</th>\n",
       "      <td>no</td>\n",
       "      <td>0.070921</td>\n",
       "      <td>False</td>\n",
       "      <td>36662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33325</th>\n",
       "      <td>no</td>\n",
       "      <td>0.056180</td>\n",
       "      <td>False</td>\n",
       "      <td>33326</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26726</th>\n",
       "      <td>no</td>\n",
       "      <td>0.032154</td>\n",
       "      <td>False</td>\n",
       "      <td>26727</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29328</th>\n",
       "      <td>no</td>\n",
       "      <td>0.008599</td>\n",
       "      <td>False</td>\n",
       "      <td>29329</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22177</th>\n",
       "      <td>no</td>\n",
       "      <td>0.039354</td>\n",
       "      <td>False</td>\n",
       "      <td>22178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13926</th>\n",
       "      <td>no</td>\n",
       "      <td>0.087462</td>\n",
       "      <td>False</td>\n",
       "      <td>13927</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13411</th>\n",
       "      <td>si</td>\n",
       "      <td>0.054171</td>\n",
       "      <td>False</td>\n",
       "      <td>13412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11788</th>\n",
       "      <td>no</td>\n",
       "      <td>0.113482</td>\n",
       "      <td>False</td>\n",
       "      <td>11789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29202</th>\n",
       "      <td>no</td>\n",
       "      <td>0.047742</td>\n",
       "      <td>False</td>\n",
       "      <td>29203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32780</th>\n",
       "      <td>no</td>\n",
       "      <td>0.033526</td>\n",
       "      <td>False</td>\n",
       "      <td>32781</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      target  target_predicho  target_predicho_dic     ID\n",
       "36661     no         0.070921                False  36662\n",
       "33325     no         0.056180                False  33326\n",
       "26726     no         0.032154                False  26727\n",
       "29328     no         0.008599                False  29329\n",
       "22177     no         0.039354                False  22178\n",
       "13926     no         0.087462                False  13927\n",
       "13411     si         0.054171                False  13412\n",
       "11788     no         0.113482                False  11789\n",
       "29202     no         0.047742                False  29203\n",
       "32780     no         0.033526                False  32781"
      ]
     },
     "execution_count": 149,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[['target','target_predicho','target_predicho_dic','ID']].sample(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 150,
   "metadata": {},
   "outputs": [],
   "source": [
    "saldo_5000 = df[['target','target_predicho','target_predicho_dic','ID']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 151,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "saldo\n",
       "False    39801\n",
       "True      2645\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 151,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "saldo_5000 = df['saldo'] >= 5000\n",
    "saldo_5000.value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## MODELO PREDICTIVO CON 'DATA_TEST'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 152,
   "metadata": {},
   "outputs": [],
   "source": [
    "og_test = pd.read_csv('Data_Test.csv', sep = ';')\n",
    "df_test = og_test.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 153,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ID                                  0\n",
       "edad                                0\n",
       "trabajo                             0\n",
       "estado_civil                        0\n",
       "educacion                           0\n",
       "deuda                               0\n",
       "saldo                               0\n",
       "vivienda                            0\n",
       "prestamo                            0\n",
       "tipo_contacto                    1233\n",
       "duracion                            0\n",
       "fecha_contacto                      0\n",
       "campaign                            0\n",
       "tiempo_transcurrido                 0\n",
       "contactos_anteriores                0\n",
       "resultado_campanas_anteriores    3494\n",
       "target                              0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 153,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_test.dropna(subset=['educacion'], inplace=True)\n",
    "\n",
    "df_test.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 154,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ID                               0\n",
       "edad                             0\n",
       "trabajo                          0\n",
       "estado_civil                     0\n",
       "educacion                        0\n",
       "deuda                            0\n",
       "saldo                            0\n",
       "vivienda                         0\n",
       "prestamo                         0\n",
       "tipo_contacto                    0\n",
       "duracion                         0\n",
       "fecha_contacto                   0\n",
       "campaign                         0\n",
       "tiempo_transcurrido              0\n",
       "contactos_anteriores             0\n",
       "resultado_campanas_anteriores    0\n",
       "target                           0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 154,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Reemplaza los valores nulos en las columnas especificadas con \"Sin Información\"\n",
    "df_test[['tipo_contacto', 'resultado_campanas_anteriores']] = df_test[['tipo_contacto', 'resultado_campanas_anteriores']].fillna(\"Sin Información\")\n",
    "\n",
    "df_test.isnull().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Buscamos modelo predictivo para nuestra columna \"Target\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 155,
   "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>ID</th>\n",
       "      <th>edad</th>\n",
       "      <th>trabajo</th>\n",
       "      <th>estado_civil</th>\n",
       "      <th>educacion</th>\n",
       "      <th>deuda</th>\n",
       "      <th>saldo</th>\n",
       "      <th>vivienda</th>\n",
       "      <th>prestamo</th>\n",
       "      <th>tipo_contacto</th>\n",
       "      <th>duracion</th>\n",
       "      <th>fecha_contacto</th>\n",
       "      <th>campaign</th>\n",
       "      <th>tiempo_transcurrido</th>\n",
       "      <th>contactos_anteriores</th>\n",
       "      <th>resultado_campanas_anteriores</th>\n",
       "      <th>target</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>817</th>\n",
       "      <td>50818</td>\n",
       "      <td>32</td>\n",
       "      <td>unemployed</td>\n",
       "      <td>soltero</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>336</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>139</td>\n",
       "      <td>8-may-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>536</th>\n",
       "      <td>50537</td>\n",
       "      <td>32</td>\n",
       "      <td>management</td>\n",
       "      <td>casado</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>62</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>166</td>\n",
       "      <td>14-may-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2715</th>\n",
       "      <td>52716</td>\n",
       "      <td>40</td>\n",
       "      <td>technician</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>169</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>43</td>\n",
       "      <td>18-aug-2021</td>\n",
       "      <td>4</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         ID  edad     trabajo estado_civil              educacion deuda  \\\n",
       "817   50818    32  unemployed      soltero         universitarios    no   \n",
       "536   50537    32  management       casado         universitarios    no   \n",
       "2715  52716    40  technician       casado  secundaria/superiores    no   \n",
       "\n",
       "      saldo vivienda prestamo    tipo_contacto  duracion fecha_contacto  \\\n",
       "817     336       si       no  Sin Información       139     8-may-2021   \n",
       "536      62       si       no            movil       166    14-may-2021   \n",
       "2715    169       si       no            movil        43    18-aug-2021   \n",
       "\n",
       "      campaign  tiempo_transcurrido  contactos_anteriores  \\\n",
       "817          1                   -1                     0   \n",
       "536          1                   -1                     0   \n",
       "2715         4                   -1                     0   \n",
       "\n",
       "     resultado_campanas_anteriores target  \n",
       "817                Sin Información     no  \n",
       "536                Sin Información     no  \n",
       "2715               Sin Información     no  "
      ]
     },
     "execution_count": 155,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_test_model = df_test.copy()\n",
    "df_test_model.sample(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 156,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_test_model.loc[df_test_model['target'] == 'no', 'target'] = 0\n",
    "df_test_model.loc[df_test_model['target'] == 'si', 'target'] = 1\n",
    "df_test_model['target'] = df_test_model['target'].astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 157,
   "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>ID</th>\n",
       "      <th>edad</th>\n",
       "      <th>trabajo</th>\n",
       "      <th>estado_civil</th>\n",
       "      <th>educacion</th>\n",
       "      <th>deuda</th>\n",
       "      <th>saldo</th>\n",
       "      <th>vivienda</th>\n",
       "      <th>prestamo</th>\n",
       "      <th>tipo_contacto</th>\n",
       "      <th>duracion</th>\n",
       "      <th>fecha_contacto</th>\n",
       "      <th>campaign</th>\n",
       "      <th>tiempo_transcurrido</th>\n",
       "      <th>contactos_anteriores</th>\n",
       "      <th>resultado_campanas_anteriores</th>\n",
       "      <th>target</th>\n",
       "      <th>target_predicho</th>\n",
       "      <th>target_predicho_dic</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>18763</th>\n",
       "      <td>18764</td>\n",
       "      <td>54</td>\n",
       "      <td>admin.</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>1335</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>448</td>\n",
       "      <td>24-jul-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.146123</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12829</th>\n",
       "      <td>12830</td>\n",
       "      <td>36</td>\n",
       "      <td>services</td>\n",
       "      <td>soltero</td>\n",
       "      <td>priamaria</td>\n",
       "      <td>no</td>\n",
       "      <td>58</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>134</td>\n",
       "      <td>6-may-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.012371</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35648</th>\n",
       "      <td>35649</td>\n",
       "      <td>59</td>\n",
       "      <td>retired</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>5706</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>471</td>\n",
       "      <td>25-jul-2021</td>\n",
       "      <td>2</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.208151</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15497</th>\n",
       "      <td>15498</td>\n",
       "      <td>32</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>soltero</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>-219</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>446</td>\n",
       "      <td>7-may-2021</td>\n",
       "      <td>6</td>\n",
       "      <td>342</td>\n",
       "      <td>2</td>\n",
       "      <td>sin_exito</td>\n",
       "      <td>no</td>\n",
       "      <td>0.108149</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1192</th>\n",
       "      <td>1193</td>\n",
       "      <td>41</td>\n",
       "      <td>admin.</td>\n",
       "      <td>casado</td>\n",
       "      <td>priamaria</td>\n",
       "      <td>no</td>\n",
       "      <td>4488</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>321</td>\n",
       "      <td>9-jul-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.082579</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          ID  edad      trabajo estado_civil              educacion deuda  \\\n",
       "18763  18764    54       admin.       casado  secundaria/superiores    no   \n",
       "12829  12830    36     services      soltero              priamaria    no   \n",
       "35648  35649    59      retired       casado  secundaria/superiores    no   \n",
       "15497  15498    32  blue-collar      soltero  secundaria/superiores    no   \n",
       "1192    1193    41       admin.       casado              priamaria    no   \n",
       "\n",
       "       saldo vivienda prestamo    tipo_contacto  duracion fecha_contacto  \\\n",
       "18763   1335       si       no            movil       448    24-jul-2021   \n",
       "12829     58       si       no  Sin Información       134     6-may-2021   \n",
       "35648   5706       si       no            movil       471    25-jul-2021   \n",
       "15497   -219       si       no            movil       446     7-may-2021   \n",
       "1192    4488       si       no            movil       321     9-jul-2021   \n",
       "\n",
       "       campaign  tiempo_transcurrido  contactos_anteriores  \\\n",
       "18763         1                   -1                     0   \n",
       "12829         1                   -1                     0   \n",
       "35648         2                   -1                     0   \n",
       "15497         6                  342                     2   \n",
       "1192          1                   -1                     0   \n",
       "\n",
       "      resultado_campanas_anteriores target  target_predicho  \\\n",
       "18763               Sin Información     no         0.146123   \n",
       "12829               Sin Información     no         0.012371   \n",
       "35648               Sin Información     no         0.208151   \n",
       "15497                     sin_exito     no         0.108149   \n",
       "1192                Sin Información     no         0.082579   \n",
       "\n",
       "       target_predicho_dic  \n",
       "18763                False  \n",
       "12829                False  \n",
       "35648                False  \n",
       "15497                False  \n",
       "1192                 False  "
      ]
     },
     "execution_count": 157,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sample(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "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>ID</th>\n",
       "      <th>edad</th>\n",
       "      <th>trabajo</th>\n",
       "      <th>estado_civil</th>\n",
       "      <th>educacion</th>\n",
       "      <th>deuda</th>\n",
       "      <th>saldo</th>\n",
       "      <th>vivienda</th>\n",
       "      <th>prestamo</th>\n",
       "      <th>tipo_contacto</th>\n",
       "      <th>duracion</th>\n",
       "      <th>fecha_contacto</th>\n",
       "      <th>campaign</th>\n",
       "      <th>tiempo_transcurrido</th>\n",
       "      <th>contactos_anteriores</th>\n",
       "      <th>resultado_campanas_anteriores</th>\n",
       "      <th>target</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3448</th>\n",
       "      <td>53449</td>\n",
       "      <td>44</td>\n",
       "      <td>technician</td>\n",
       "      <td>divorciado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>0</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>56</td>\n",
       "      <td>12-aug-2021</td>\n",
       "      <td>2</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1350</th>\n",
       "      <td>51351</td>\n",
       "      <td>43</td>\n",
       "      <td>management</td>\n",
       "      <td>casado</td>\n",
       "      <td>priamria</td>\n",
       "      <td>no</td>\n",
       "      <td>8167</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>114</td>\n",
       "      <td>19-may-2021</td>\n",
       "      <td>2</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>351</th>\n",
       "      <td>50352</td>\n",
       "      <td>50</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>casado</td>\n",
       "      <td>priamria</td>\n",
       "      <td>no</td>\n",
       "      <td>4108</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>526</td>\n",
       "      <td>7-aug-2021</td>\n",
       "      <td>2</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>si</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3268</th>\n",
       "      <td>53269</td>\n",
       "      <td>40</td>\n",
       "      <td>management</td>\n",
       "      <td>soltero</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>192</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>71</td>\n",
       "      <td>16-may-2021</td>\n",
       "      <td>11</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1792</th>\n",
       "      <td>51793</td>\n",
       "      <td>53</td>\n",
       "      <td>entrepreneur</td>\n",
       "      <td>casado</td>\n",
       "      <td>priamria</td>\n",
       "      <td>no</td>\n",
       "      <td>27</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>fijo</td>\n",
       "      <td>230</td>\n",
       "      <td>10-sep-2021</td>\n",
       "      <td>3</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>si</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         ID  edad       trabajo estado_civil              educacion deuda  \\\n",
       "3448  53449    44    technician   divorciado  secundaria/superiores    no   \n",
       "1350  51351    43    management       casado               priamria    no   \n",
       "351   50352    50   blue-collar       casado               priamria    no   \n",
       "3268  53269    40    management      soltero  secundaria/superiores    no   \n",
       "1792  51793    53  entrepreneur       casado               priamria    no   \n",
       "\n",
       "      saldo vivienda prestamo    tipo_contacto  duracion fecha_contacto  \\\n",
       "3448      0       no       no            movil        56    12-aug-2021   \n",
       "1350   8167       si       no  Sin Información       114    19-may-2021   \n",
       "351    4108       si       no            movil       526     7-aug-2021   \n",
       "3268    192       si       no  Sin Información        71    16-may-2021   \n",
       "1792     27       si       no             fijo       230    10-sep-2021   \n",
       "\n",
       "      campaign  tiempo_transcurrido  contactos_anteriores  \\\n",
       "3448         2                   -1                     0   \n",
       "1350         2                   -1                     0   \n",
       "351          2                   -1                     0   \n",
       "3268        11                   -1                     0   \n",
       "1792         3                   -1                     0   \n",
       "\n",
       "     resultado_campanas_anteriores target  \n",
       "3448               Sin Información     no  \n",
       "1350               Sin Información     no  \n",
       "351                Sin Información     si  \n",
       "3268               Sin Información     no  \n",
       "1792               Sin Información     si  "
      ]
     },
     "execution_count": 158,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_test.sample(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 159,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Reemplaza el valor erróneo en la columna 'educacion'\n",
    "df_test_model['educacion'] = df_test_model['educacion'].replace('priamaria', 'primaria')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 160,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "educacion\n",
      "secundaria/superiores    2271\n",
      "universitarios           1318\n",
      "priamria                  666\n",
      "Name: count, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "# Supongamos que tienes un DataFrame llamado df y quieres contar los valores en la columna 'columna_deseada'\n",
    "conteo_valores = df_test['educacion'].value_counts()\n",
    "print(conteo_valores)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 161,
   "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>edad</th>\n",
       "      <th>trabajo</th>\n",
       "      <th>estado_civil</th>\n",
       "      <th>educacion</th>\n",
       "      <th>deuda</th>\n",
       "      <th>saldo</th>\n",
       "      <th>vivienda</th>\n",
       "      <th>prestamo</th>\n",
       "      <th>tipo_contacto</th>\n",
       "      <th>duracion</th>\n",
       "      <th>campaign</th>\n",
       "      <th>tiempo_transcurrido</th>\n",
       "      <th>contactos_anteriores</th>\n",
       "      <th>resultado_campanas_anteriores</th>\n",
       "      <th>target</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1620</th>\n",
       "      <td>57</td>\n",
       "      <td>retired</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>523</td>\n",
       "      <td>no</td>\n",
       "      <td>si</td>\n",
       "      <td>movil</td>\n",
       "      <td>49</td>\n",
       "      <td>6</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3232</th>\n",
       "      <td>33</td>\n",
       "      <td>management</td>\n",
       "      <td>soltero</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>71</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>107</td>\n",
       "      <td>6</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1987</th>\n",
       "      <td>37</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>soltero</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>48</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>140</td>\n",
       "      <td>2</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      edad      trabajo estado_civil              educacion deuda  saldo  \\\n",
       "1620    57      retired       casado  secundaria/superiores    no    523   \n",
       "3232    33   management      soltero         universitarios    no     71   \n",
       "1987    37  blue-collar      soltero  secundaria/superiores    no     48   \n",
       "\n",
       "     vivienda prestamo tipo_contacto  duracion  campaign  tiempo_transcurrido  \\\n",
       "1620       no       si         movil        49         6                   -1   \n",
       "3232       no       no         movil       107         6                   -1   \n",
       "1987       no       no         movil       140         2                   -1   \n",
       "\n",
       "      contactos_anteriores resultado_campanas_anteriores  target  \n",
       "1620                     0               Sin Información       0  \n",
       "3232                     0               Sin Información       0  \n",
       "1987                     0               Sin Información       0  "
      ]
     },
     "execution_count": 161,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "columns_to_delete = ['fecha_contacto', 'ID']\n",
    "df_test_model.drop(columns=columns_to_delete,inplace=True)\n",
    "\n",
    "df_test_model.sample(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 162,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(4255, 38)\n"
     ]
    },
    {
     "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>edad</th>\n",
       "      <th>saldo</th>\n",
       "      <th>duracion</th>\n",
       "      <th>campaign</th>\n",
       "      <th>tiempo_transcurrido</th>\n",
       "      <th>contactos_anteriores</th>\n",
       "      <th>target</th>\n",
       "      <th>trabajo_admin.</th>\n",
       "      <th>trabajo_blue-collar</th>\n",
       "      <th>trabajo_entrepreneur</th>\n",
       "      <th>...</th>\n",
       "      <th>vivienda_si</th>\n",
       "      <th>prestamo_no</th>\n",
       "      <th>prestamo_si</th>\n",
       "      <th>tipo_contacto_Sin Información</th>\n",
       "      <th>tipo_contacto_fijo</th>\n",
       "      <th>tipo_contacto_movil</th>\n",
       "      <th>resultado_campanas_anteriores_Sin Información</th>\n",
       "      <th>resultado_campanas_anteriores_exito</th>\n",
       "      <th>resultado_campanas_anteriores_otro</th>\n",
       "      <th>resultado_campanas_anteriores_sin_exito</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2622</th>\n",
       "      <td>71</td>\n",
       "      <td>2850</td>\n",
       "      <td>185</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3149</th>\n",
       "      <td>28</td>\n",
       "      <td>2269</td>\n",
       "      <td>331</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3171</th>\n",
       "      <td>38</td>\n",
       "      <td>1198</td>\n",
       "      <td>63</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4198</th>\n",
       "      <td>39</td>\n",
       "      <td>4143</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4008</th>\n",
       "      <td>52</td>\n",
       "      <td>-9</td>\n",
       "      <td>123</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      edad  saldo  duracion  campaign  tiempo_transcurrido  \\\n",
       "2622    71   2850       185         1                   -1   \n",
       "3149    28   2269       331         1                   -1   \n",
       "3171    38   1198        63         1                   -1   \n",
       "4198    39   4143        21         1                   -1   \n",
       "4008    52     -9       123         1                   -1   \n",
       "\n",
       "      contactos_anteriores  target  trabajo_admin.  trabajo_blue-collar  \\\n",
       "2622                     0       1             0.0                  0.0   \n",
       "3149                     0       0             0.0                  0.0   \n",
       "3171                     0       0             0.0                  0.0   \n",
       "4198                     0       0             0.0                  1.0   \n",
       "4008                     0       0             0.0                  0.0   \n",
       "\n",
       "      trabajo_entrepreneur  ...  vivienda_si  prestamo_no  prestamo_si  \\\n",
       "2622                   0.0  ...          0.0          1.0          0.0   \n",
       "3149                   0.0  ...          1.0          1.0          0.0   \n",
       "3171                   0.0  ...          1.0          1.0          0.0   \n",
       "4198                   0.0  ...          1.0          0.0          1.0   \n",
       "4008                   0.0  ...          0.0          1.0          0.0   \n",
       "\n",
       "      tipo_contacto_Sin Información  tipo_contacto_fijo  tipo_contacto_movil  \\\n",
       "2622                            0.0                 0.0                  1.0   \n",
       "3149                            1.0                 0.0                  0.0   \n",
       "3171                            0.0                 0.0                  1.0   \n",
       "4198                            1.0                 0.0                  0.0   \n",
       "4008                            1.0                 0.0                  0.0   \n",
       "\n",
       "      resultado_campanas_anteriores_Sin Información  \\\n",
       "2622                                            1.0   \n",
       "3149                                            1.0   \n",
       "3171                                            1.0   \n",
       "4198                                            1.0   \n",
       "4008                                            1.0   \n",
       "\n",
       "      resultado_campanas_anteriores_exito  resultado_campanas_anteriores_otro  \\\n",
       "2622                                  0.0                                 0.0   \n",
       "3149                                  0.0                                 0.0   \n",
       "3171                                  0.0                                 0.0   \n",
       "4198                                  0.0                                 0.0   \n",
       "4008                                  0.0                                 0.0   \n",
       "\n",
       "      resultado_campanas_anteriores_sin_exito  \n",
       "2622                                      0.0  \n",
       "3149                                      0.0  \n",
       "3171                                      0.0  \n",
       "4198                                      0.0  \n",
       "4008                                      0.0  \n",
       "\n",
       "[5 rows x 38 columns]"
      ]
     },
     "execution_count": 162,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "#Instancio el OneHot\n",
    "onehot=OneHotEncoder()\n",
    "\n",
    "# Aplico el OneHot a la columna job y guardo el resultao en a\n",
    "onehot.fit(df_test_model[['trabajo','estado_civil','educacion','deuda','vivienda','prestamo','tipo_contacto','resultado_campanas_anteriores']])\n",
    "a=onehot.transform(df_test_model[['trabajo','estado_civil','educacion','deuda','vivienda','prestamo','tipo_contacto','resultado_campanas_anteriores']])\n",
    "\n",
    "# Convierto el a en data frame y lo llamo encoded_df\n",
    "encoded_df = pd.DataFrame(a.toarray(), columns=onehot.get_feature_names_out(['trabajo','estado_civil','educacion','deuda','vivienda','prestamo','tipo_contacto','resultado_campanas_anteriores']))\n",
    "\n",
    "# Reseteo el índice de los dos data frames antes de concatenarlos\n",
    "df_test_model.reset_index(drop=True, inplace=True)\n",
    "encoded_df.reset_index(drop=True, inplace=True)\n",
    "\n",
    "# concateno los dos data frames y los guardo machacando el df\n",
    "df_test_model=pd.concat([df_test_model,encoded_df],axis=1)\n",
    "\n",
    "# Elimino la columna Job original antigua, la categórica\n",
    "df_test_model.drop(columns=['trabajo','estado_civil','educacion','deuda','vivienda','prestamo','tipo_contacto','resultado_campanas_anteriores'],inplace=True)\n",
    "\n",
    "# Muestro tamaño yu sample del data frame df transformado\n",
    "print(df_test_model.shape)\n",
    "df_test_model.sample(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 163,
   "metadata": {},
   "outputs": [],
   "source": [
    "X_base_datos_test = df_test_model.drop('target', axis=1, inplace=False)  # Asegúrate de excluir la columna de la variable objetivo si está presente\n",
    "\n",
    "X_base_datos_std_test=estandarizador.fit_transform(X_base_datos_test)\n",
    "\n",
    "\n",
    "# Realiza la predicción utilizando el modelo previamente entrenado\n",
    "\n",
    "y_pred_base_datos_test = model_std.predict_proba(X_base_datos_std_test)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 164,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[0.9855587 , 0.0144413 ],\n",
       "       [0.56476309, 0.43523691],\n",
       "       [0.9410834 , 0.0589166 ],\n",
       "       ...,\n",
       "       [0.93790364, 0.06209636],\n",
       "       [0.86309974, 0.13690026],\n",
       "       [0.98692601, 0.01307399]])"
      ]
     },
     "execution_count": 164,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y_pred_base_datos_test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 165,
   "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>ID</th>\n",
       "      <th>edad</th>\n",
       "      <th>trabajo</th>\n",
       "      <th>estado_civil</th>\n",
       "      <th>educacion</th>\n",
       "      <th>deuda</th>\n",
       "      <th>saldo</th>\n",
       "      <th>vivienda</th>\n",
       "      <th>prestamo</th>\n",
       "      <th>tipo_contacto</th>\n",
       "      <th>duracion</th>\n",
       "      <th>fecha_contacto</th>\n",
       "      <th>campaign</th>\n",
       "      <th>tiempo_transcurrido</th>\n",
       "      <th>contactos_anteriores</th>\n",
       "      <th>resultado_campanas_anteriores</th>\n",
       "      <th>target</th>\n",
       "      <th>target_predicho_test</th>\n",
       "      <th>target_predicho_dic_test</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4093</th>\n",
       "      <td>54094</td>\n",
       "      <td>38</td>\n",
       "      <td>technician</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>994</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>119</td>\n",
       "      <td>9-jun-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.023479</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3873</th>\n",
       "      <td>53874</td>\n",
       "      <td>36</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>casado</td>\n",
       "      <td>priamria</td>\n",
       "      <td>no</td>\n",
       "      <td>1925</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>904</td>\n",
       "      <td>20-apr-2021</td>\n",
       "      <td>2</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>si</td>\n",
       "      <td>0.352985</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289</th>\n",
       "      <td>50290</td>\n",
       "      <td>54</td>\n",
       "      <td>retired</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>1139</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>155</td>\n",
       "      <td>14-may-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>177</td>\n",
       "      <td>7</td>\n",
       "      <td>sin_exito</td>\n",
       "      <td>no</td>\n",
       "      <td>0.101135</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         ID  edad      trabajo estado_civil              educacion deuda  \\\n",
       "4093  54094    38   technician       casado  secundaria/superiores    no   \n",
       "3873  53874    36  blue-collar       casado               priamria    no   \n",
       "289   50290    54      retired       casado  secundaria/superiores    no   \n",
       "\n",
       "      saldo vivienda prestamo    tipo_contacto  duracion fecha_contacto  \\\n",
       "4093    994       no       no  Sin Información       119     9-jun-2021   \n",
       "3873   1925       si       no            movil       904    20-apr-2021   \n",
       "289    1139       si       no            movil       155    14-may-2021   \n",
       "\n",
       "      campaign  tiempo_transcurrido  contactos_anteriores  \\\n",
       "4093         1                   -1                     0   \n",
       "3873         2                   -1                     0   \n",
       "289          1                  177                     7   \n",
       "\n",
       "     resultado_campanas_anteriores target  target_predicho_test  \\\n",
       "4093               Sin Información     no              0.023479   \n",
       "3873               Sin Información     si              0.352985   \n",
       "289                      sin_exito     no              0.101135   \n",
       "\n",
       "      target_predicho_dic_test  \n",
       "4093                     False  \n",
       "3873                     False  \n",
       "289                      False  "
      ]
     },
     "execution_count": 165,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "\n",
    "# Ahora 'y_pred_base_datos' contiene las predicciones para toda tu base de datos\n",
    "# utilizaremos la predicion de todo el df y lo agregamos en una nueva columna para comprar valores reales a los predichos\n",
    "\n",
    "df_test['target_predicho_test'] = y_pred_base_datos_test[:,1]\n",
    "df_test['target_predicho_dic_test'] = df_test['target_predicho_test'] > 0.65\n",
    "\n",
    "df_test.sample(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 170,
   "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>target</th>\n",
       "      <th>target_predicho_test</th>\n",
       "      <th>target_predicho_dic_test</th>\n",
       "      <th>ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2141</th>\n",
       "      <td>si</td>\n",
       "      <td>0.877233</td>\n",
       "      <td>True</td>\n",
       "      <td>52142</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>no</td>\n",
       "      <td>0.050777</td>\n",
       "      <td>False</td>\n",
       "      <td>50315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2917</th>\n",
       "      <td>no</td>\n",
       "      <td>0.015466</td>\n",
       "      <td>False</td>\n",
       "      <td>52918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3272</th>\n",
       "      <td>si</td>\n",
       "      <td>0.881811</td>\n",
       "      <td>True</td>\n",
       "      <td>53273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2964</th>\n",
       "      <td>no</td>\n",
       "      <td>0.006984</td>\n",
       "      <td>False</td>\n",
       "      <td>52965</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2583</th>\n",
       "      <td>no</td>\n",
       "      <td>0.026992</td>\n",
       "      <td>False</td>\n",
       "      <td>52584</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1424</th>\n",
       "      <td>no</td>\n",
       "      <td>0.015912</td>\n",
       "      <td>False</td>\n",
       "      <td>51425</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4008</th>\n",
       "      <td>no</td>\n",
       "      <td>0.010768</td>\n",
       "      <td>False</td>\n",
       "      <td>54009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4270</th>\n",
       "      <td>no</td>\n",
       "      <td>0.039696</td>\n",
       "      <td>False</td>\n",
       "      <td>54271</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3579</th>\n",
       "      <td>no</td>\n",
       "      <td>0.098310</td>\n",
       "      <td>False</td>\n",
       "      <td>53580</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     target  target_predicho_test  target_predicho_dic_test     ID\n",
       "2141     si              0.877233                      True  52142\n",
       "314      no              0.050777                     False  50315\n",
       "2917     no              0.015466                     False  52918\n",
       "3272     si              0.881811                      True  53273\n",
       "2964     no              0.006984                     False  52965\n",
       "2583     no              0.026992                     False  52584\n",
       "1424     no              0.015912                     False  51425\n",
       "4008     no              0.010768                     False  54009\n",
       "4270     no              0.039696                     False  54271\n",
       "3579     no              0.098310                     False  53580"
      ]
     },
     "execution_count": 170,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_test[['target','target_predicho_test','target_predicho_dic_test','ID']].sample(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 167,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "target_predicho_dic_test\n",
       "False    4101\n",
       "True      154\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 167,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_test['target_predicho_dic_test'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 186,
   "metadata": {},
   "outputs": [],
   "source": [
    "saldo_5000_test = df_test[['target','target_predicho_test','target_predicho_dic_test','ID']]\n",
    "saldo_5000_test = df_test[df_test['saldo'] >= 5000]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 189,
   "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>ID</th>\n",
       "      <th>edad</th>\n",
       "      <th>trabajo</th>\n",
       "      <th>estado_civil</th>\n",
       "      <th>educacion</th>\n",
       "      <th>deuda</th>\n",
       "      <th>saldo</th>\n",
       "      <th>vivienda</th>\n",
       "      <th>prestamo</th>\n",
       "      <th>tipo_contacto</th>\n",
       "      <th>duracion</th>\n",
       "      <th>fecha_contacto</th>\n",
       "      <th>campaign</th>\n",
       "      <th>tiempo_transcurrido</th>\n",
       "      <th>contactos_anteriores</th>\n",
       "      <th>resultado_campanas_anteriores</th>\n",
       "      <th>target</th>\n",
       "      <th>target_predicho_test</th>\n",
       "      <th>target_predicho_dic_test</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>50007</td>\n",
       "      <td>41</td>\n",
       "      <td>admin.</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>5110</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>231</td>\n",
       "      <td>13-apr-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.070027</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>50021</td>\n",
       "      <td>47</td>\n",
       "      <td>self-employed</td>\n",
       "      <td>divorciado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>8515</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>14</td>\n",
       "      <td>20-nov-2021</td>\n",
       "      <td>7</td>\n",
       "      <td>112</td>\n",
       "      <td>4</td>\n",
       "      <td>otro</td>\n",
       "      <td>no</td>\n",
       "      <td>0.008337</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>50046</td>\n",
       "      <td>32</td>\n",
       "      <td>admin.</td>\n",
       "      <td>soltero</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>10218</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>149</td>\n",
       "      <td>19-nov-2021</td>\n",
       "      <td>2</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.068193</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>50061</td>\n",
       "      <td>60</td>\n",
       "      <td>retired</td>\n",
       "      <td>casado</td>\n",
       "      <td>priamria</td>\n",
       "      <td>no</td>\n",
       "      <td>71188</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>205</td>\n",
       "      <td>6-oct-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.366118</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>50064</td>\n",
       "      <td>30</td>\n",
       "      <td>technician</td>\n",
       "      <td>soltero</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>6619</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>239</td>\n",
       "      <td>21-aug-2021</td>\n",
       "      <td>8</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.048295</td>\n",
       "      <td>False</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4387</th>\n",
       "      <td>54388</td>\n",
       "      <td>38</td>\n",
       "      <td>management</td>\n",
       "      <td>casado</td>\n",
       "      <td>universitarios</td>\n",
       "      <td>no</td>\n",
       "      <td>12877</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>118</td>\n",
       "      <td>17-jun-2021</td>\n",
       "      <td>3</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.029913</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4393</th>\n",
       "      <td>54394</td>\n",
       "      <td>42</td>\n",
       "      <td>housemaid</td>\n",
       "      <td>casado</td>\n",
       "      <td>priamria</td>\n",
       "      <td>no</td>\n",
       "      <td>14752</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>107</td>\n",
       "      <td>19-may-2021</td>\n",
       "      <td>2</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.016167</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4397</th>\n",
       "      <td>54398</td>\n",
       "      <td>49</td>\n",
       "      <td>services</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>5673</td>\n",
       "      <td>no</td>\n",
       "      <td>si</td>\n",
       "      <td>movil</td>\n",
       "      <td>357</td>\n",
       "      <td>4-aug-2021</td>\n",
       "      <td>3</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.081009</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4400</th>\n",
       "      <td>54401</td>\n",
       "      <td>33</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>soltero</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>5137</td>\n",
       "      <td>si</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>123</td>\n",
       "      <td>6-may-2021</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sin Información</td>\n",
       "      <td>no</td>\n",
       "      <td>0.042741</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4411</th>\n",
       "      <td>54412</td>\n",
       "      <td>75</td>\n",
       "      <td>blue-collar</td>\n",
       "      <td>casado</td>\n",
       "      <td>secundaria/superiores</td>\n",
       "      <td>no</td>\n",
       "      <td>6053</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>movil</td>\n",
       "      <td>865</td>\n",
       "      <td>11-feb-2021</td>\n",
       "      <td>2</td>\n",
       "      <td>190</td>\n",
       "      <td>1</td>\n",
       "      <td>sin_exito</td>\n",
       "      <td>no</td>\n",
       "      <td>0.645371</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>281 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         ID  edad        trabajo estado_civil              educacion deuda  \\\n",
       "6     50007    41         admin.       casado  secundaria/superiores    no   \n",
       "20    50021    47  self-employed   divorciado  secundaria/superiores    no   \n",
       "45    50046    32         admin.      soltero  secundaria/superiores    no   \n",
       "60    50061    60        retired       casado               priamria    no   \n",
       "63    50064    30     technician      soltero         universitarios    no   \n",
       "...     ...   ...            ...          ...                    ...   ...   \n",
       "4387  54388    38     management       casado         universitarios    no   \n",
       "4393  54394    42      housemaid       casado               priamria    no   \n",
       "4397  54398    49       services       casado  secundaria/superiores    no   \n",
       "4400  54401    33    blue-collar      soltero  secundaria/superiores    no   \n",
       "4411  54412    75    blue-collar       casado  secundaria/superiores    no   \n",
       "\n",
       "      saldo vivienda prestamo    tipo_contacto  duracion fecha_contacto  \\\n",
       "6      5110       si       no            movil       231    13-apr-2021   \n",
       "20     8515       si       no  Sin Información        14    20-nov-2021   \n",
       "45    10218       si       no            movil       149    19-nov-2021   \n",
       "60    71188       no       no            movil       205     6-oct-2021   \n",
       "63     6619       si       no            movil       239    21-aug-2021   \n",
       "...     ...      ...      ...              ...       ...            ...   \n",
       "4387  12877       no       no  Sin Información       118    17-jun-2021   \n",
       "4393  14752       no       no  Sin Información       107    19-may-2021   \n",
       "4397   5673       no       si            movil       357     4-aug-2021   \n",
       "4400   5137       si       no            movil       123     6-may-2021   \n",
       "4411   6053       no       no            movil       865    11-feb-2021   \n",
       "\n",
       "      campaign  tiempo_transcurrido  contactos_anteriores  \\\n",
       "6            1                   -1                     0   \n",
       "20           7                  112                     4   \n",
       "45           2                   -1                     0   \n",
       "60           1                   -1                     0   \n",
       "63           8                   -1                     0   \n",
       "...        ...                  ...                   ...   \n",
       "4387         3                   -1                     0   \n",
       "4393         2                   -1                     0   \n",
       "4397         3                   -1                     0   \n",
       "4400         1                   -1                     0   \n",
       "4411         2                  190                     1   \n",
       "\n",
       "     resultado_campanas_anteriores target  target_predicho_test  \\\n",
       "6                  Sin Información     no              0.070027   \n",
       "20                            otro     no              0.008337   \n",
       "45                 Sin Información     no              0.068193   \n",
       "60                 Sin Información     no              0.366118   \n",
       "63                 Sin Información     no              0.048295   \n",
       "...                            ...    ...                   ...   \n",
       "4387               Sin Información     no              0.029913   \n",
       "4393               Sin Información     no              0.016167   \n",
       "4397               Sin Información     no              0.081009   \n",
       "4400               Sin Información     no              0.042741   \n",
       "4411                     sin_exito     no              0.645371   \n",
       "\n",
       "      target_predicho_dic_test  \n",
       "6                        False  \n",
       "20                       False  \n",
       "45                       False  \n",
       "60                       False  \n",
       "63                       False  \n",
       "...                        ...  \n",
       "4387                     False  \n",
       "4393                     False  \n",
       "4397                     False  \n",
       "4400                     False  \n",
       "4411                     False  \n",
       "\n",
       "[281 rows x 19 columns]"
      ]
     },
     "execution_count": 189,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "saldo_5000_test"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "ML_IMPELIA",
   "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.10.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}