03_Notebooks/02_Desarrollo/04_Transformacion de datos.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "d31dea65",
   "metadata": {},
   "source": [
    "# TRANSFORMACIÓN DE DATOS"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "swiss-fault",
   "metadata": {},
   "source": [
    "## IMPORTAR PAQUETES"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "adjacent-toddler",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "%matplotlib inline\n",
    "from sklearn.preprocessing import OneHotEncoder\n",
    "from sklearn.preprocessing import OrdinalEncoder\n",
    "from sklearn.preprocessing import LabelEncoder\n",
    "from category_encoders import TargetEncoder\n",
    "from sklearn.preprocessing import KBinsDiscretizer\n",
    "from sklearn.preprocessing import Binarizer\n",
    "from sklearn.preprocessing import PowerTransformer\n",
    "from sklearn.preprocessing import QuantileTransformer\n",
    "from sklearn.feature_extraction.text import CountVectorizer\n",
    "from sklearn.feature_extraction.text import TfidfVectorizer\n",
    "from sklearn.preprocessing import MinMaxScaler\n",
    "from sklearn.preprocessing import StandardScaler\n",
    "from sklearn.preprocessing import RobustScaler\n",
    "from sklearn.preprocessing import MaxAbsScaler\n",
    "from imblearn.under_sampling import RandomUnderSampler\n",
    "from imblearn.over_sampling import RandomOverSampler\n",
    "\n",
    "#Automcompletar rápido\n",
    "%config IPCompleter.greedy=True"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "graduate-compensation",
   "metadata": {},
   "source": [
    "## IMPORTAR LOS DATOS"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3a5b94ef",
   "metadata": {},
   "source": [
    "1.- Sustituir la ruta del proyecto."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "f9d2de58",
   "metadata": {},
   "outputs": [],
   "source": [
    "ruta_proyecto = 'C:/Users/pelop/OneDrive/Desktop/Curso Data Science Pedro/2 CURSO DATA SCIENCE/03_MACHINE_LEARNING/07_CASOS/01_LEADSCORING'"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c3363765",
   "metadata": {},
   "source": [
    "2.- Nombrar los ficheros de datos."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "a9e2e04a",
   "metadata": {},
   "outputs": [],
   "source": [
    "nombre_cat = 'cat_resultado_eda.pickle'\n",
    "nombre_num = 'num_resultado_eda.pickle'"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b9825018",
   "metadata": {},
   "source": [
    "3.- Cargar los datos."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "cab6ebcd",
   "metadata": {},
   "outputs": [],
   "source": [
    "cat = pd.read_pickle(ruta_proyecto + '/02_Datos/03_Trabajo/' + nombre_cat).reset_index(drop = True)\n",
    "num = pd.read_pickle(ruta_proyecto + '/02_Datos/03_Trabajo/' + nombre_num).reset_index(drop = True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a1350902",
   "metadata": {},
   "source": [
    "4.- Separar la target."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "98184a13-9a35-4b65-be8e-02a309ff60b5",
   "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>compra</th>\n",
       "      <th>visitas_total</th>\n",
       "      <th>tiempo_en_site_total</th>\n",
       "      <th>paginas_vistas_visita</th>\n",
       "      <th>score_actividad</th>\n",
       "      <th>score_perfil</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>660737</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>660728</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>674</td>\n",
       "      <td>2.5</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>660727</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1532</td>\n",
       "      <td>2.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>660719</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>305</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>17.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>660673</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1640</td>\n",
       "      <td>2.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       id  compra  visitas_total  tiempo_en_site_total  paginas_vistas_visita  \\\n",
       "0  660737       0              0                     0                    0.0   \n",
       "1  660728       0              5                   674                    2.5   \n",
       "2  660727       1              2                  1532                    2.0   \n",
       "3  660719       0              1                   305                    1.0   \n",
       "4  660673       1              2                  1640                    2.0   \n",
       "\n",
       "   score_actividad  score_perfil  \n",
       "0             15.0          15.0  \n",
       "1             15.0          15.0  \n",
       "2             14.0          20.0  \n",
       "3             13.0          17.0  \n",
       "4             14.0          20.0  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "num.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "095b0ef2",
   "metadata": {},
   "outputs": [],
   "source": [
    "target = num[['compra']].copy().reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "169c27e9-76d5-41a7-8b88-b7a39f178e94",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "id\n",
      "origen\n",
      "fuente\n",
      "ult_actividad\n",
      "ambito\n",
      "ocupacion\n",
      "descarga_lm\n"
     ]
    }
   ],
   "source": [
    "for i in cat.columns.to_list():\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "557dccd6-56b7-4942-8bfe-fe48ae2764cb",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "id\n",
      "compra\n",
      "visitas_total\n",
      "tiempo_en_site_total\n",
      "paginas_vistas_visita\n",
      "score_actividad\n",
      "score_perfil\n"
     ]
    }
   ],
   "source": [
    "for i in num.columns.to_list():\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6291dc65-e04a-4a82-953f-f8409362dfea",
   "metadata": {},
   "source": [
    "* Para las numéricas no vamos a hacer ni **discretización** ni **binarización**, ya que no estamos buscando ningún tipo de generalización ni de interpretación en este caso. Solo estamos buscando capacidad predictiva. Discretizar es útil cuando a posteriori queremos dar una explicación a los resultados. Y como vamos a realizar una segmentación (**KMeans**) no tiene tampoco mucho sentido discretizar.\n",
    "* Tampoco vamos a hacer la **normalización** pues ya vimos en el EDA que las variables numéricas eran bastante normales (distribución gaussiana).\n",
    "* Por otro lado sí tenemos que hacer **reescalado** pues el algoritmo de KMeans es muy sensible a la escala. **MinMaxScaling** es la opción más razonable para este caso ya que como tenemos muchas variables categóricas con OHE (entre 0 y 1), minmaxscaling también nos las va a dejar en este formato. Además como vamos a hacer un cluster es aún más determinante la escala."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9790d322",
   "metadata": {},
   "source": [
    "## TRANSFORMACIÓN DE CATEGÓRICAS"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "34272ab9-d42d-419b-8b7d-c4f016b6b372",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "origen\n",
       "Landing Page Submission    3081\n",
       "API                        1522\n",
       "Lead Add Form               236\n",
       "OTROS                        34\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cat.origen.value_counts() # Es una variable nominal -> OHE"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "7a7d41be-e2a7-4a19-9e81-ca7042c25693",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "fuente\n",
       "Google            1878\n",
       "Direct Traffic    1567\n",
       "Organic Search     752\n",
       "Chat               307\n",
       "Reference          222\n",
       "OTROS              147\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cat.fuente.value_counts() # Es una variable nominal -> OHE"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "bb579aad-79f2-45ad-9c3e-95e5dc076dde",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ult_actividad\n",
       "Email Opened               2014\n",
       "SMS Sent                   1516\n",
       "Page Visited on Website     381\n",
       "Converted to Lead           302\n",
       "Chat Conversation           276\n",
       "OTROS                       237\n",
       "Email Link Clicked          147\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cat.ult_actividad.value_counts() # Es una variable nominal -> OHE"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "8d43ce12-178f-4cde-be64-33b9b1052fe7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ambito\n",
       "Select                               1226\n",
       "Finance Management                    609\n",
       "Human Resource Management             518\n",
       "Marketing Management                  510\n",
       "OTROS                                 383\n",
       "Operations Management                 335\n",
       "Business Administration               254\n",
       "Banking, Investment And Insurance     227\n",
       "IT Projects Management                224\n",
       "Supply Chain Management               222\n",
       "Media and Advertising                 139\n",
       "Travel and Tourism                    116\n",
       "International Business                110\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cat.ambito.value_counts() # Es una variable nominal -> OHE"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "15dd43bf-f4fe-4968-8e60-60e6d1bb2fec",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ocupacion\n",
       "Unemployed              4329\n",
       "Working Professional     421\n",
       "Student                  100\n",
       "OTROS                     23\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cat.ocupacion.value_counts() # Esta está en la zona gris, pues podríamos decir que OTROS < Student < Unemployed < Working Professional\n",
    "                             # Pero como tampoco está muy claro que es mejor la dejamos como nominal y no ordinal -> OHE"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "693f58b4-e0e6-4566-83b5-ed6ad872ae2a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "descarga_lm\n",
       "No     3035\n",
       "Yes    1838\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cat.descarga_lm.value_counts() # Es una variable nominal -> OHE"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f1fa5201",
   "metadata": {},
   "source": [
    "### One Hot Encoding"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "da9b786a",
   "metadata": {},
   "source": [
    "#### Variables a aplicar OHE"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "6e36cf47",
   "metadata": {},
   "outputs": [],
   "source": [
    "var_ohe = ['origen','fuente','ult_actividad','ambito','ocupacion','descarga_lm']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "db8d4634",
   "metadata": {},
   "source": [
    "#### Instanciar"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "e75c2ee4",
   "metadata": {},
   "outputs": [],
   "source": [
    "ohe = OneHotEncoder(sparse_output = False, handle_unknown='ignore')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "26c9f58f",
   "metadata": {},
   "source": [
    "#### Entrenar y aplicar"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "4162d5a7",
   "metadata": {},
   "outputs": [],
   "source": [
    "cat_ohe = ohe.fit_transform(cat[var_ohe])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c9131f15",
   "metadata": {},
   "source": [
    "#### Guardar como dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "783255d7",
   "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>origen_API</th>\n",
       "      <th>origen_Landing Page Submission</th>\n",
       "      <th>origen_Lead Add Form</th>\n",
       "      <th>origen_OTROS</th>\n",
       "      <th>fuente_Chat</th>\n",
       "      <th>fuente_Direct Traffic</th>\n",
       "      <th>fuente_Google</th>\n",
       "      <th>fuente_OTROS</th>\n",
       "      <th>fuente_Organic Search</th>\n",
       "      <th>fuente_Reference</th>\n",
       "      <th>...</th>\n",
       "      <th>ambito_Operations Management</th>\n",
       "      <th>ambito_Select</th>\n",
       "      <th>ambito_Supply Chain Management</th>\n",
       "      <th>ambito_Travel and Tourism</th>\n",
       "      <th>ocupacion_OTROS</th>\n",
       "      <th>ocupacion_Student</th>\n",
       "      <th>ocupacion_Unemployed</th>\n",
       "      <th>ocupacion_Working Professional</th>\n",
       "      <th>descarga_lm_No</th>\n",
       "      <th>descarga_lm_Yes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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>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>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>...</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>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\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>0.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>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>3</th>\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>0.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>0.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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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>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>...</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",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4868</th>\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>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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4869</th>\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>0.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>0.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>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4870</th>\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>0.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>0.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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4871</th>\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>0.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>0.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>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4872</th>\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>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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4873 rows × 36 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      origen_API  origen_Landing Page Submission  origen_Lead Add Form  \\\n",
       "0            1.0                             0.0                   0.0   \n",
       "1            1.0                             0.0                   0.0   \n",
       "2            0.0                             1.0                   0.0   \n",
       "3            0.0                             1.0                   0.0   \n",
       "4            0.0                             1.0                   0.0   \n",
       "...          ...                             ...                   ...   \n",
       "4868         0.0                             1.0                   0.0   \n",
       "4869         0.0                             1.0                   0.0   \n",
       "4870         0.0                             1.0                   0.0   \n",
       "4871         0.0                             1.0                   0.0   \n",
       "4872         0.0                             1.0                   0.0   \n",
       "\n",
       "      origen_OTROS  fuente_Chat  fuente_Direct Traffic  fuente_Google  \\\n",
       "0              0.0          1.0                    0.0            0.0   \n",
       "1              0.0          0.0                    0.0            0.0   \n",
       "2              0.0          0.0                    1.0            0.0   \n",
       "3              0.0          0.0                    1.0            0.0   \n",
       "4              0.0          0.0                    0.0            1.0   \n",
       "...            ...          ...                    ...            ...   \n",
       "4868           0.0          0.0                    0.0            1.0   \n",
       "4869           0.0          0.0                    1.0            0.0   \n",
       "4870           0.0          0.0                    1.0            0.0   \n",
       "4871           0.0          0.0                    1.0            0.0   \n",
       "4872           0.0          0.0                    0.0            1.0   \n",
       "\n",
       "      fuente_OTROS  fuente_Organic Search  fuente_Reference  ...  \\\n",
       "0              0.0                    0.0               0.0  ...   \n",
       "1              0.0                    1.0               0.0  ...   \n",
       "2              0.0                    0.0               0.0  ...   \n",
       "3              0.0                    0.0               0.0  ...   \n",
       "4              0.0                    0.0               0.0  ...   \n",
       "...            ...                    ...               ...  ...   \n",
       "4868           0.0                    0.0               0.0  ...   \n",
       "4869           0.0                    0.0               0.0  ...   \n",
       "4870           0.0                    0.0               0.0  ...   \n",
       "4871           0.0                    0.0               0.0  ...   \n",
       "4872           0.0                    0.0               0.0  ...   \n",
       "\n",
       "      ambito_Operations Management  ambito_Select  \\\n",
       "0                              0.0            1.0   \n",
       "1                              0.0            1.0   \n",
       "2                              0.0            0.0   \n",
       "3                              0.0            0.0   \n",
       "4                              0.0            0.0   \n",
       "...                            ...            ...   \n",
       "4868                           0.0            0.0   \n",
       "4869                           0.0            0.0   \n",
       "4870                           0.0            0.0   \n",
       "4871                           0.0            0.0   \n",
       "4872                           0.0            0.0   \n",
       "\n",
       "      ambito_Supply Chain Management  ambito_Travel and Tourism  \\\n",
       "0                                0.0                        0.0   \n",
       "1                                0.0                        0.0   \n",
       "2                                0.0                        0.0   \n",
       "3                                0.0                        0.0   \n",
       "4                                1.0                        0.0   \n",
       "...                              ...                        ...   \n",
       "4868                             0.0                        0.0   \n",
       "4869                             0.0                        0.0   \n",
       "4870                             0.0                        0.0   \n",
       "4871                             0.0                        0.0   \n",
       "4872                             0.0                        0.0   \n",
       "\n",
       "      ocupacion_OTROS  ocupacion_Student  ocupacion_Unemployed  \\\n",
       "0                 0.0                0.0                   1.0   \n",
       "1                 0.0                0.0                   1.0   \n",
       "2                 0.0                1.0                   0.0   \n",
       "3                 0.0                0.0                   1.0   \n",
       "4                 0.0                0.0                   1.0   \n",
       "...               ...                ...                   ...   \n",
       "4868              0.0                0.0                   1.0   \n",
       "4869              0.0                0.0                   1.0   \n",
       "4870              0.0                0.0                   1.0   \n",
       "4871              0.0                0.0                   1.0   \n",
       "4872              0.0                0.0                   1.0   \n",
       "\n",
       "      ocupacion_Working Professional  descarga_lm_No  descarga_lm_Yes  \n",
       "0                                0.0             1.0              0.0  \n",
       "1                                0.0             1.0              0.0  \n",
       "2                                0.0             0.0              1.0  \n",
       "3                                0.0             1.0              0.0  \n",
       "4                                0.0             1.0              0.0  \n",
       "...                              ...             ...              ...  \n",
       "4868                             0.0             1.0              0.0  \n",
       "4869                             0.0             0.0              1.0  \n",
       "4870                             0.0             1.0              0.0  \n",
       "4871                             0.0             0.0              1.0  \n",
       "4872                             0.0             1.0              0.0  \n",
       "\n",
       "[4873 rows x 36 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cat_ohe = pd.DataFrame(cat_ohe, columns = ohe.get_feature_names_out())\n",
    "cat_ohe"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ec6bd31a",
   "metadata": {},
   "source": [
    "## TRANSFORMACIÓN DE NUMÉRICAS"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "541c70bd-7321-4477-9ace-998ecf02e7d4",
   "metadata": {},
   "source": [
    "No hay transformaciones que aplicar a las variables numéricas en este caso"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "87434e0c",
   "metadata": {},
   "source": [
    "## UNIFICAR DATASETS TRANSFORMADOS"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "db926f25-4bee-4b22-86d8-406813c9ab56",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.concat([cat_ohe,num], axis=1)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5f9ffae2",
   "metadata": {},
   "source": [
    "## REESCALAR VARIABLES"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fbc62831",
   "metadata": {},
   "source": [
    "### Con Min-Max"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "c35ea0a2",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 4873 entries, 0 to 4872\n",
      "Data columns (total 43 columns):\n",
      " #   Column                                    Non-Null Count  Dtype  \n",
      "---  ------                                    --------------  -----  \n",
      " 0   origen_API                                4873 non-null   float64\n",
      " 1   origen_Landing Page Submission            4873 non-null   float64\n",
      " 2   origen_Lead Add Form                      4873 non-null   float64\n",
      " 3   origen_OTROS                              4873 non-null   float64\n",
      " 4   fuente_Chat                               4873 non-null   float64\n",
      " 5   fuente_Direct Traffic                     4873 non-null   float64\n",
      " 6   fuente_Google                             4873 non-null   float64\n",
      " 7   fuente_OTROS                              4873 non-null   float64\n",
      " 8   fuente_Organic Search                     4873 non-null   float64\n",
      " 9   fuente_Reference                          4873 non-null   float64\n",
      " 10  ult_actividad_Chat Conversation           4873 non-null   float64\n",
      " 11  ult_actividad_Converted to Lead           4873 non-null   float64\n",
      " 12  ult_actividad_Email Link Clicked          4873 non-null   float64\n",
      " 13  ult_actividad_Email Opened                4873 non-null   float64\n",
      " 14  ult_actividad_OTROS                       4873 non-null   float64\n",
      " 15  ult_actividad_Page Visited on Website     4873 non-null   float64\n",
      " 16  ult_actividad_SMS Sent                    4873 non-null   float64\n",
      " 17  ambito_Banking, Investment And Insurance  4873 non-null   float64\n",
      " 18  ambito_Business Administration            4873 non-null   float64\n",
      " 19  ambito_Finance Management                 4873 non-null   float64\n",
      " 20  ambito_Human Resource Management          4873 non-null   float64\n",
      " 21  ambito_IT Projects Management             4873 non-null   float64\n",
      " 22  ambito_International Business             4873 non-null   float64\n",
      " 23  ambito_Marketing Management               4873 non-null   float64\n",
      " 24  ambito_Media and Advertising              4873 non-null   float64\n",
      " 25  ambito_OTROS                              4873 non-null   float64\n",
      " 26  ambito_Operations Management              4873 non-null   float64\n",
      " 27  ambito_Select                             4873 non-null   float64\n",
      " 28  ambito_Supply Chain Management            4873 non-null   float64\n",
      " 29  ambito_Travel and Tourism                 4873 non-null   float64\n",
      " 30  ocupacion_OTROS                           4873 non-null   float64\n",
      " 31  ocupacion_Student                         4873 non-null   float64\n",
      " 32  ocupacion_Unemployed                      4873 non-null   float64\n",
      " 33  ocupacion_Working Professional            4873 non-null   float64\n",
      " 34  descarga_lm_No                            4873 non-null   float64\n",
      " 35  descarga_lm_Yes                           4873 non-null   float64\n",
      " 36  id                                        4873 non-null   int64  \n",
      " 37  compra                                    4873 non-null   int64  \n",
      " 38  visitas_total                             4873 non-null   Int64  \n",
      " 39  tiempo_en_site_total                      4873 non-null   int64  \n",
      " 40  paginas_vistas_visita                     4873 non-null   float64\n",
      " 41  score_actividad                           4873 non-null   float64\n",
      " 42  score_perfil                              4873 non-null   float64\n",
      "dtypes: Int64(1), float64(39), int64(3)\n",
      "memory usage: 1.6 MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "de92d3fe",
   "metadata": {},
   "source": [
    "#### Variables a reescalar con Min-Max"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "4c9e40ba",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['visitas_total', 'tiempo_en_site_total', 'paginas_vistas_visita',\n",
       "       'score_actividad', 'score_perfil'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "var_mms = df.iloc[:,38:].columns\n",
    "var_mms"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b0b18ca7",
   "metadata": {},
   "source": [
    "#### Instanciar"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "44a71f10",
   "metadata": {},
   "outputs": [],
   "source": [
    "mms = MinMaxScaler()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "57f8f537",
   "metadata": {},
   "source": [
    "#### Entrenar y aplicar"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "b45d4fa8",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_mms = mms.fit_transform(df[var_mms])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "aea83d81",
   "metadata": {},
   "source": [
    "#### Guardar como dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "d5ba3f86",
   "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>visitas_total_mms</th>\n",
       "      <th>tiempo_en_site_total_mms</th>\n",
       "      <th>paginas_vistas_visita_mms</th>\n",
       "      <th>score_actividad_mms</th>\n",
       "      <th>score_perfil_mms</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.727273</td>\n",
       "      <td>0.444444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.10</td>\n",
       "      <td>0.296655</td>\n",
       "      <td>0.125</td>\n",
       "      <td>0.727273</td>\n",
       "      <td>0.444444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.04</td>\n",
       "      <td>0.674296</td>\n",
       "      <td>0.100</td>\n",
       "      <td>0.636364</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.02</td>\n",
       "      <td>0.134243</td>\n",
       "      <td>0.050</td>\n",
       "      <td>0.545455</td>\n",
       "      <td>0.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.04</td>\n",
       "      <td>0.721831</td>\n",
       "      <td>0.100</td>\n",
       "      <td>0.636364</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4868</th>\n",
       "      <td>0.16</td>\n",
       "      <td>0.447183</td>\n",
       "      <td>0.200</td>\n",
       "      <td>0.727273</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4869</th>\n",
       "      <td>0.04</td>\n",
       "      <td>0.779049</td>\n",
       "      <td>0.100</td>\n",
       "      <td>0.636364</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4870</th>\n",
       "      <td>0.10</td>\n",
       "      <td>0.092430</td>\n",
       "      <td>0.125</td>\n",
       "      <td>0.636364</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4871</th>\n",
       "      <td>0.04</td>\n",
       "      <td>0.104754</td>\n",
       "      <td>0.100</td>\n",
       "      <td>0.636364</td>\n",
       "      <td>0.888889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4872</th>\n",
       "      <td>0.06</td>\n",
       "      <td>0.219630</td>\n",
       "      <td>0.150</td>\n",
       "      <td>0.727273</td>\n",
       "      <td>0.555556</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4873 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      visitas_total_mms  tiempo_en_site_total_mms  paginas_vistas_visita_mms  \\\n",
       "0                  0.00                  0.000000                      0.000   \n",
       "1                  0.10                  0.296655                      0.125   \n",
       "2                  0.04                  0.674296                      0.100   \n",
       "3                  0.02                  0.134243                      0.050   \n",
       "4                  0.04                  0.721831                      0.100   \n",
       "...                 ...                       ...                        ...   \n",
       "4868               0.16                  0.447183                      0.200   \n",
       "4869               0.04                  0.779049                      0.100   \n",
       "4870               0.10                  0.092430                      0.125   \n",
       "4871               0.04                  0.104754                      0.100   \n",
       "4872               0.06                  0.219630                      0.150   \n",
       "\n",
       "      score_actividad_mms  score_perfil_mms  \n",
       "0                0.727273          0.444444  \n",
       "1                0.727273          0.444444  \n",
       "2                0.636364          1.000000  \n",
       "3                0.545455          0.666667  \n",
       "4                0.636364          1.000000  \n",
       "...                   ...               ...  \n",
       "4868             0.727273          1.000000  \n",
       "4869             0.636364          1.000000  \n",
       "4870             0.636364          1.000000  \n",
       "4871             0.636364          0.888889  \n",
       "4872             0.727273          0.555556  \n",
       "\n",
       "[4873 rows x 5 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Añadir sufijos a los nombres\n",
    "nombres_mms = [variable + '_mms' for variable in var_mms]\n",
    "\n",
    "#Guardar como dataframe\n",
    "df_mms = pd.DataFrame(df_mms,columns = nombres_mms)\n",
    "df_mms"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "118dac36",
   "metadata": {},
   "source": [
    "## UNIFICAR DATASETS REESCALADOS"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "c96a5a73-4dd8-47fa-bfa8-f32c4ca921df",
   "metadata": {},
   "outputs": [],
   "source": [
    "id = df.id"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "922d60e8-214c-474d-a146-e93c64241486",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 4873 entries, 0 to 4872\n",
      "Data columns (total 43 columns):\n",
      " #   Column                                    Non-Null Count  Dtype  \n",
      "---  ------                                    --------------  -----  \n",
      " 0   id                                        4873 non-null   int64  \n",
      " 1   origen_API                                4873 non-null   float64\n",
      " 2   origen_Landing Page Submission            4873 non-null   float64\n",
      " 3   origen_Lead Add Form                      4873 non-null   float64\n",
      " 4   origen_OTROS                              4873 non-null   float64\n",
      " 5   fuente_Chat                               4873 non-null   float64\n",
      " 6   fuente_Direct Traffic                     4873 non-null   float64\n",
      " 7   fuente_Google                             4873 non-null   float64\n",
      " 8   fuente_OTROS                              4873 non-null   float64\n",
      " 9   fuente_Organic Search                     4873 non-null   float64\n",
      " 10  fuente_Reference                          4873 non-null   float64\n",
      " 11  ult_actividad_Chat Conversation           4873 non-null   float64\n",
      " 12  ult_actividad_Converted to Lead           4873 non-null   float64\n",
      " 13  ult_actividad_Email Link Clicked          4873 non-null   float64\n",
      " 14  ult_actividad_Email Opened                4873 non-null   float64\n",
      " 15  ult_actividad_OTROS                       4873 non-null   float64\n",
      " 16  ult_actividad_Page Visited on Website     4873 non-null   float64\n",
      " 17  ult_actividad_SMS Sent                    4873 non-null   float64\n",
      " 18  ambito_Banking, Investment And Insurance  4873 non-null   float64\n",
      " 19  ambito_Business Administration            4873 non-null   float64\n",
      " 20  ambito_Finance Management                 4873 non-null   float64\n",
      " 21  ambito_Human Resource Management          4873 non-null   float64\n",
      " 22  ambito_IT Projects Management             4873 non-null   float64\n",
      " 23  ambito_International Business             4873 non-null   float64\n",
      " 24  ambito_Marketing Management               4873 non-null   float64\n",
      " 25  ambito_Media and Advertising              4873 non-null   float64\n",
      " 26  ambito_OTROS                              4873 non-null   float64\n",
      " 27  ambito_Operations Management              4873 non-null   float64\n",
      " 28  ambito_Select                             4873 non-null   float64\n",
      " 29  ambito_Supply Chain Management            4873 non-null   float64\n",
      " 30  ambito_Travel and Tourism                 4873 non-null   float64\n",
      " 31  ocupacion_OTROS                           4873 non-null   float64\n",
      " 32  ocupacion_Student                         4873 non-null   float64\n",
      " 33  ocupacion_Unemployed                      4873 non-null   float64\n",
      " 34  ocupacion_Working Professional            4873 non-null   float64\n",
      " 35  descarga_lm_No                            4873 non-null   float64\n",
      " 36  descarga_lm_Yes                           4873 non-null   float64\n",
      " 37  visitas_total_mms                         4873 non-null   float64\n",
      " 38  tiempo_en_site_total_mms                  4873 non-null   float64\n",
      " 39  paginas_vistas_visita_mms                 4873 non-null   float64\n",
      " 40  score_actividad_mms                       4873 non-null   float64\n",
      " 41  score_perfil_mms                          4873 non-null   float64\n",
      " 42  compra                                    4873 non-null   int64  \n",
      "dtypes: float64(41), int64(2)\n",
      "memory usage: 1.6 MB\n"
     ]
    }
   ],
   "source": [
    "pd.concat([id,cat_ohe,df_mms,target], axis = 1).info()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4412d913",
   "metadata": {},
   "source": [
    "### Unir todos los dataframes en el tablón analítico"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "id": "bbacffcc",
   "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>origen_API</th>\n",
       "      <th>origen_Landing Page Submission</th>\n",
       "      <th>origen_Lead Add Form</th>\n",
       "      <th>origen_OTROS</th>\n",
       "      <th>fuente_Chat</th>\n",
       "      <th>fuente_Direct Traffic</th>\n",
       "      <th>fuente_Google</th>\n",
       "      <th>fuente_OTROS</th>\n",
       "      <th>fuente_Organic Search</th>\n",
       "      <th>fuente_Reference</th>\n",
       "      <th>...</th>\n",
       "      <th>ocupacion_Unemployed</th>\n",
       "      <th>ocupacion_Working Professional</th>\n",
       "      <th>descarga_lm_No</th>\n",
       "      <th>descarga_lm_Yes</th>\n",
       "      <th>visitas_total_mms</th>\n",
       "      <th>tiempo_en_site_total_mms</th>\n",
       "      <th>paginas_vistas_visita_mms</th>\n",
       "      <th>score_actividad_mms</th>\n",
       "      <th>score_perfil_mms</th>\n",
       "      <th>compra</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>660737</th>\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>0.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>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.727273</td>\n",
       "      <td>0.444444</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>660728</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.10</td>\n",
       "      <td>0.296655</td>\n",
       "      <td>0.125</td>\n",
       "      <td>0.727273</td>\n",
       "      <td>0.444444</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>660727</th>\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>0.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>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.674296</td>\n",
       "      <td>0.100</td>\n",
       "      <td>0.636364</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>660719</th>\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>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.134243</td>\n",
       "      <td>0.050</td>\n",
       "      <td>0.545455</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>660673</th>\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>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>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.721831</td>\n",
       "      <td>0.100</td>\n",
       "      <td>0.636364</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>579697</th>\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>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>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.16</td>\n",
       "      <td>0.447183</td>\n",
       "      <td>0.200</td>\n",
       "      <td>0.727273</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>579642</th>\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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.779049</td>\n",
       "      <td>0.100</td>\n",
       "      <td>0.636364</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>579615</th>\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>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>0.10</td>\n",
       "      <td>0.092430</td>\n",
       "      <td>0.125</td>\n",
       "      <td>0.636364</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>579546</th>\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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.104754</td>\n",
       "      <td>0.100</td>\n",
       "      <td>0.636364</td>\n",
       "      <td>0.888889</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>579538</th>\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>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>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.06</td>\n",
       "      <td>0.219630</td>\n",
       "      <td>0.150</td>\n",
       "      <td>0.727273</td>\n",
       "      <td>0.555556</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4873 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        origen_API  origen_Landing Page Submission  origen_Lead Add Form  \\\n",
       "id                                                                         \n",
       "660737         1.0                             0.0                   0.0   \n",
       "660728         1.0                             0.0                   0.0   \n",
       "660727         0.0                             1.0                   0.0   \n",
       "660719         0.0                             1.0                   0.0   \n",
       "660673         0.0                             1.0                   0.0   \n",
       "...            ...                             ...                   ...   \n",
       "579697         0.0                             1.0                   0.0   \n",
       "579642         0.0                             1.0                   0.0   \n",
       "579615         0.0                             1.0                   0.0   \n",
       "579546         0.0                             1.0                   0.0   \n",
       "579538         0.0                             1.0                   0.0   \n",
       "\n",
       "        origen_OTROS  fuente_Chat  fuente_Direct Traffic  fuente_Google  \\\n",
       "id                                                                        \n",
       "660737           0.0          1.0                    0.0            0.0   \n",
       "660728           0.0          0.0                    0.0            0.0   \n",
       "660727           0.0          0.0                    1.0            0.0   \n",
       "660719           0.0          0.0                    1.0            0.0   \n",
       "660673           0.0          0.0                    0.0            1.0   \n",
       "...              ...          ...                    ...            ...   \n",
       "579697           0.0          0.0                    0.0            1.0   \n",
       "579642           0.0          0.0                    1.0            0.0   \n",
       "579615           0.0          0.0                    1.0            0.0   \n",
       "579546           0.0          0.0                    1.0            0.0   \n",
       "579538           0.0          0.0                    0.0            1.0   \n",
       "\n",
       "        fuente_OTROS  fuente_Organic Search  fuente_Reference  ...  \\\n",
       "id                                                             ...   \n",
       "660737           0.0                    0.0               0.0  ...   \n",
       "660728           0.0                    1.0               0.0  ...   \n",
       "660727           0.0                    0.0               0.0  ...   \n",
       "660719           0.0                    0.0               0.0  ...   \n",
       "660673           0.0                    0.0               0.0  ...   \n",
       "...              ...                    ...               ...  ...   \n",
       "579697           0.0                    0.0               0.0  ...   \n",
       "579642           0.0                    0.0               0.0  ...   \n",
       "579615           0.0                    0.0               0.0  ...   \n",
       "579546           0.0                    0.0               0.0  ...   \n",
       "579538           0.0                    0.0               0.0  ...   \n",
       "\n",
       "        ocupacion_Unemployed  ocupacion_Working Professional  descarga_lm_No  \\\n",
       "id                                                                             \n",
       "660737                   1.0                             0.0             1.0   \n",
       "660728                   1.0                             0.0             1.0   \n",
       "660727                   0.0                             0.0             0.0   \n",
       "660719                   1.0                             0.0             1.0   \n",
       "660673                   1.0                             0.0             1.0   \n",
       "...                      ...                             ...             ...   \n",
       "579697                   1.0                             0.0             1.0   \n",
       "579642                   1.0                             0.0             0.0   \n",
       "579615                   1.0                             0.0             1.0   \n",
       "579546                   1.0                             0.0             0.0   \n",
       "579538                   1.0                             0.0             1.0   \n",
       "\n",
       "        descarga_lm_Yes  visitas_total_mms  tiempo_en_site_total_mms  \\\n",
       "id                                                                     \n",
       "660737              0.0               0.00                  0.000000   \n",
       "660728              0.0               0.10                  0.296655   \n",
       "660727              1.0               0.04                  0.674296   \n",
       "660719              0.0               0.02                  0.134243   \n",
       "660673              0.0               0.04                  0.721831   \n",
       "...                 ...                ...                       ...   \n",
       "579697              0.0               0.16                  0.447183   \n",
       "579642              1.0               0.04                  0.779049   \n",
       "579615              0.0               0.10                  0.092430   \n",
       "579546              1.0               0.04                  0.104754   \n",
       "579538              0.0               0.06                  0.219630   \n",
       "\n",
       "        paginas_vistas_visita_mms  score_actividad_mms  score_perfil_mms  \\\n",
       "id                                                                         \n",
       "660737                      0.000             0.727273          0.444444   \n",
       "660728                      0.125             0.727273          0.444444   \n",
       "660727                      0.100             0.636364          1.000000   \n",
       "660719                      0.050             0.545455          0.666667   \n",
       "660673                      0.100             0.636364          1.000000   \n",
       "...                           ...                  ...               ...   \n",
       "579697                      0.200             0.727273          1.000000   \n",
       "579642                      0.100             0.636364          1.000000   \n",
       "579615                      0.125             0.636364          1.000000   \n",
       "579546                      0.100             0.636364          0.888889   \n",
       "579538                      0.150             0.727273          0.555556   \n",
       "\n",
       "        compra  \n",
       "id              \n",
       "660737       0  \n",
       "660728       0  \n",
       "660727       1  \n",
       "660719       0  \n",
       "660673       1  \n",
       "...        ...  \n",
       "579697       1  \n",
       "579642       0  \n",
       "579615       1  \n",
       "579546       0  \n",
       "579538       1  \n",
       "\n",
       "[4873 rows x 42 columns]"
      ]
     },
     "execution_count": 100,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tablon = pd.concat([id,cat_ohe,df_mms,target], axis = 1).set_index('id')\n",
    "df_tablon"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0ec7aeb3-7a3c-45f5-926f-8dd41786bce6",
   "metadata": {},
   "source": [
    "Comprobaciones:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "id": "73d6350c-2d4c-4e99-bb52-b8117cd6ed66",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "id                                          0\n",
       "origen_API                                  0\n",
       "origen_Landing Page Submission              0\n",
       "origen_Lead Add Form                        0\n",
       "origen_OTROS                                0\n",
       "fuente_Chat                                 0\n",
       "fuente_Direct Traffic                       0\n",
       "fuente_Google                               0\n",
       "fuente_OTROS                                0\n",
       "fuente_Organic Search                       0\n",
       "fuente_Reference                            0\n",
       "ult_actividad_Chat Conversation             0\n",
       "ult_actividad_Converted to Lead             0\n",
       "ult_actividad_Email Link Clicked            0\n",
       "ult_actividad_Email Opened                  0\n",
       "ult_actividad_OTROS                         0\n",
       "ult_actividad_Page Visited on Website       0\n",
       "ult_actividad_SMS Sent                      0\n",
       "ambito_Banking, Investment And Insurance    0\n",
       "ambito_Business Administration              0\n",
       "ambito_Finance Management                   0\n",
       "ambito_Human Resource Management            0\n",
       "ambito_IT Projects Management               0\n",
       "ambito_International Business               0\n",
       "ambito_Marketing Management                 0\n",
       "ambito_Media and Advertising                0\n",
       "ambito_OTROS                                0\n",
       "ambito_Operations Management                0\n",
       "ambito_Select                               0\n",
       "ambito_Supply Chain Management              0\n",
       "ambito_Travel and Tourism                   0\n",
       "ocupacion_OTROS                             0\n",
       "ocupacion_Student                           0\n",
       "ocupacion_Unemployed                        0\n",
       "ocupacion_Working Professional              0\n",
       "descarga_lm_No                              0\n",
       "descarga_lm_Yes                             0\n",
       "visitas_total_mms                           0\n",
       "tiempo_en_site_total_mms                    0\n",
       "paginas_vistas_visita_mms                   0\n",
       "score_actividad_mms                         0\n",
       "score_perfil_mms                            0\n",
       "compra                                      0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tablon.isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "id": "c8b044d9-7013-4f98-920e-96dd20919a79",
   "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>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>origen_API</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.312333</td>\n",
       "      <td>0.463492</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>origen_Landing Page Submission</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.632259</td>\n",
       "      <td>0.482240</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>origen_Lead Add Form</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.048430</td>\n",
       "      <td>0.214695</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>origen_OTROS</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.006977</td>\n",
       "      <td>0.083246</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fuente_Chat</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.063000</td>\n",
       "      <td>0.242988</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fuente_Direct Traffic</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.321568</td>\n",
       "      <td>0.467126</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fuente_Google</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.385389</td>\n",
       "      <td>0.486737</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fuente_OTROS</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.030166</td>\n",
       "      <td>0.171062</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fuente_Organic Search</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.154320</td>\n",
       "      <td>0.361292</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fuente_Reference</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.045557</td>\n",
       "      <td>0.208544</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ult_actividad_Chat Conversation</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.056639</td>\n",
       "      <td>0.231175</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ult_actividad_Converted to Lead</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.061974</td>\n",
       "      <td>0.241133</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ult_actividad_Email Link Clicked</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.030166</td>\n",
       "      <td>0.171062</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ult_actividad_Email Opened</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.413298</td>\n",
       "      <td>0.492476</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ult_actividad_OTROS</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.048635</td>\n",
       "      <td>0.215127</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ult_actividad_Page Visited on Website</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.078186</td>\n",
       "      <td>0.268491</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ult_actividad_SMS Sent</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.311102</td>\n",
       "      <td>0.462992</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ambito_Banking, Investment And Insurance</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.046583</td>\n",
       "      <td>0.210766</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ambito_Business Administration</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.052124</td>\n",
       "      <td>0.222300</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ambito_Finance Management</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.124974</td>\n",
       "      <td>0.330724</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ambito_Human Resource Management</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.106300</td>\n",
       "      <td>0.308253</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ambito_IT Projects Management</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.045968</td>\n",
       "      <td>0.209436</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ambito_International Business</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.022573</td>\n",
       "      <td>0.148554</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ambito_Marketing Management</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.104658</td>\n",
       "      <td>0.306144</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ambito_Media and Advertising</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.028525</td>\n",
       "      <td>0.166483</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ambito_OTROS</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.078596</td>\n",
       "      <td>0.269135</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ambito_Operations Management</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.068746</td>\n",
       "      <td>0.253048</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ambito_Select</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.251590</td>\n",
       "      <td>0.433972</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ambito_Supply Chain Management</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.045557</td>\n",
       "      <td>0.208544</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ambito_Travel and Tourism</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.023805</td>\n",
       "      <td>0.152456</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ocupacion_OTROS</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.004720</td>\n",
       "      <td>0.068546</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ocupacion_Student</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.020521</td>\n",
       "      <td>0.141789</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ocupacion_Unemployed</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.888364</td>\n",
       "      <td>0.314950</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ocupacion_Working Professional</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.086394</td>\n",
       "      <td>0.280974</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>descarga_lm_No</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.622820</td>\n",
       "      <td>0.484730</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>descarga_lm_Yes</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.377180</td>\n",
       "      <td>0.484730</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>visitas_total_mms</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.082582</td>\n",
       "      <td>0.069312</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.040000</td>\n",
       "      <td>0.060000</td>\n",
       "      <td>0.100000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tiempo_en_site_total_mms</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.265526</td>\n",
       "      <td>0.243646</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.057218</td>\n",
       "      <td>0.160651</td>\n",
       "      <td>0.475792</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>paginas_vistas_visita_mms</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.144179</td>\n",
       "      <td>0.096391</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.100000</td>\n",
       "      <td>0.125000</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>score_actividad_mms</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.641139</td>\n",
       "      <td>0.086536</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.636364</td>\n",
       "      <td>0.636364</td>\n",
       "      <td>0.636364</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>score_perfil_mms</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.588686</td>\n",
       "      <td>0.158562</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.555556</td>\n",
       "      <td>0.555556</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>compra</th>\n",
       "      <td>4873.0</td>\n",
       "      <td>0.415555</td>\n",
       "      <td>0.492868</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           count      mean       std  min  \\\n",
       "origen_API                                4873.0  0.312333  0.463492  0.0   \n",
       "origen_Landing Page Submission            4873.0  0.632259  0.482240  0.0   \n",
       "origen_Lead Add Form                      4873.0  0.048430  0.214695  0.0   \n",
       "origen_OTROS                              4873.0  0.006977  0.083246  0.0   \n",
       "fuente_Chat                               4873.0  0.063000  0.242988  0.0   \n",
       "fuente_Direct Traffic                     4873.0  0.321568  0.467126  0.0   \n",
       "fuente_Google                             4873.0  0.385389  0.486737  0.0   \n",
       "fuente_OTROS                              4873.0  0.030166  0.171062  0.0   \n",
       "fuente_Organic Search                     4873.0  0.154320  0.361292  0.0   \n",
       "fuente_Reference                          4873.0  0.045557  0.208544  0.0   \n",
       "ult_actividad_Chat Conversation           4873.0  0.056639  0.231175  0.0   \n",
       "ult_actividad_Converted to Lead           4873.0  0.061974  0.241133  0.0   \n",
       "ult_actividad_Email Link Clicked          4873.0  0.030166  0.171062  0.0   \n",
       "ult_actividad_Email Opened                4873.0  0.413298  0.492476  0.0   \n",
       "ult_actividad_OTROS                       4873.0  0.048635  0.215127  0.0   \n",
       "ult_actividad_Page Visited on Website     4873.0  0.078186  0.268491  0.0   \n",
       "ult_actividad_SMS Sent                    4873.0  0.311102  0.462992  0.0   \n",
       "ambito_Banking, Investment And Insurance  4873.0  0.046583  0.210766  0.0   \n",
       "ambito_Business Administration            4873.0  0.052124  0.222300  0.0   \n",
       "ambito_Finance Management                 4873.0  0.124974  0.330724  0.0   \n",
       "ambito_Human Resource Management          4873.0  0.106300  0.308253  0.0   \n",
       "ambito_IT Projects Management             4873.0  0.045968  0.209436  0.0   \n",
       "ambito_International Business             4873.0  0.022573  0.148554  0.0   \n",
       "ambito_Marketing Management               4873.0  0.104658  0.306144  0.0   \n",
       "ambito_Media and Advertising              4873.0  0.028525  0.166483  0.0   \n",
       "ambito_OTROS                              4873.0  0.078596  0.269135  0.0   \n",
       "ambito_Operations Management              4873.0  0.068746  0.253048  0.0   \n",
       "ambito_Select                             4873.0  0.251590  0.433972  0.0   \n",
       "ambito_Supply Chain Management            4873.0  0.045557  0.208544  0.0   \n",
       "ambito_Travel and Tourism                 4873.0  0.023805  0.152456  0.0   \n",
       "ocupacion_OTROS                           4873.0  0.004720  0.068546  0.0   \n",
       "ocupacion_Student                         4873.0  0.020521  0.141789  0.0   \n",
       "ocupacion_Unemployed                      4873.0  0.888364  0.314950  0.0   \n",
       "ocupacion_Working Professional            4873.0  0.086394  0.280974  0.0   \n",
       "descarga_lm_No                            4873.0  0.622820  0.484730  0.0   \n",
       "descarga_lm_Yes                           4873.0  0.377180  0.484730  0.0   \n",
       "visitas_total_mms                         4873.0  0.082582  0.069312  0.0   \n",
       "tiempo_en_site_total_mms                  4873.0  0.265526  0.243646  0.0   \n",
       "paginas_vistas_visita_mms                 4873.0  0.144179  0.096391  0.0   \n",
       "score_actividad_mms                       4873.0  0.641139  0.086536  0.0   \n",
       "score_perfil_mms                          4873.0  0.588686  0.158562  0.0   \n",
       "compra                                    4873.0  0.415555  0.492868  0.0   \n",
       "\n",
       "                                               25%       50%       75%  max  \n",
       "origen_API                                0.000000  0.000000  1.000000  1.0  \n",
       "origen_Landing Page Submission            0.000000  1.000000  1.000000  1.0  \n",
       "origen_Lead Add Form                      0.000000  0.000000  0.000000  1.0  \n",
       "origen_OTROS                              0.000000  0.000000  0.000000  1.0  \n",
       "fuente_Chat                               0.000000  0.000000  0.000000  1.0  \n",
       "fuente_Direct Traffic                     0.000000  0.000000  1.000000  1.0  \n",
       "fuente_Google                             0.000000  0.000000  1.000000  1.0  \n",
       "fuente_OTROS                              0.000000  0.000000  0.000000  1.0  \n",
       "fuente_Organic Search                     0.000000  0.000000  0.000000  1.0  \n",
       "fuente_Reference                          0.000000  0.000000  0.000000  1.0  \n",
       "ult_actividad_Chat Conversation           0.000000  0.000000  0.000000  1.0  \n",
       "ult_actividad_Converted to Lead           0.000000  0.000000  0.000000  1.0  \n",
       "ult_actividad_Email Link Clicked          0.000000  0.000000  0.000000  1.0  \n",
       "ult_actividad_Email Opened                0.000000  0.000000  1.000000  1.0  \n",
       "ult_actividad_OTROS                       0.000000  0.000000  0.000000  1.0  \n",
       "ult_actividad_Page Visited on Website     0.000000  0.000000  0.000000  1.0  \n",
       "ult_actividad_SMS Sent                    0.000000  0.000000  1.000000  1.0  \n",
       "ambito_Banking, Investment And Insurance  0.000000  0.000000  0.000000  1.0  \n",
       "ambito_Business Administration            0.000000  0.000000  0.000000  1.0  \n",
       "ambito_Finance Management                 0.000000  0.000000  0.000000  1.0  \n",
       "ambito_Human Resource Management          0.000000  0.000000  0.000000  1.0  \n",
       "ambito_IT Projects Management             0.000000  0.000000  0.000000  1.0  \n",
       "ambito_International Business             0.000000  0.000000  0.000000  1.0  \n",
       "ambito_Marketing Management               0.000000  0.000000  0.000000  1.0  \n",
       "ambito_Media and Advertising              0.000000  0.000000  0.000000  1.0  \n",
       "ambito_OTROS                              0.000000  0.000000  0.000000  1.0  \n",
       "ambito_Operations Management              0.000000  0.000000  0.000000  1.0  \n",
       "ambito_Select                             0.000000  0.000000  1.000000  1.0  \n",
       "ambito_Supply Chain Management            0.000000  0.000000  0.000000  1.0  \n",
       "ambito_Travel and Tourism                 0.000000  0.000000  0.000000  1.0  \n",
       "ocupacion_OTROS                           0.000000  0.000000  0.000000  1.0  \n",
       "ocupacion_Student                         0.000000  0.000000  0.000000  1.0  \n",
       "ocupacion_Unemployed                      1.000000  1.000000  1.000000  1.0  \n",
       "ocupacion_Working Professional            0.000000  0.000000  0.000000  1.0  \n",
       "descarga_lm_No                            0.000000  1.000000  1.000000  1.0  \n",
       "descarga_lm_Yes                           0.000000  0.000000  1.000000  1.0  \n",
       "visitas_total_mms                         0.040000  0.060000  0.100000  1.0  \n",
       "tiempo_en_site_total_mms                  0.057218  0.160651  0.475792  1.0  \n",
       "paginas_vistas_visita_mms                 0.100000  0.125000  0.200000  1.0  \n",
       "score_actividad_mms                       0.636364  0.636364  0.636364  1.0  \n",
       "score_perfil_mms                          0.555556  0.555556  0.666667  1.0  \n",
       "compra                                    0.000000  0.000000  1.000000  1.0  "
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tablon.describe().T"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9f098f8a",
   "metadata": {},
   "source": [
    "## GUARDAR DATASET TRAS TRANSFORMACIÓN DE DATOS"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7656ba95",
   "metadata": {},
   "source": [
    "En formato pickle para no perder las modificaciones de metadatos."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "id": "782bf43c",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Definir los nombres del archivo\n",
    "ruta_df_tablon = ruta_proyecto + '/02_Datos/03_Trabajo/' + 'df_tablon.pickle'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "id": "44c7dd60",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Guardar los archivos\n",
    "df_tablon.to_pickle(ruta_df_tablon)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.12.3"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {
    "height": "calc(100% - 180px)",
    "left": "10px",
    "top": "150px",
    "width": "346.95px"
   },
   "toc_section_display": true,
   "toc_window_display": true
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "position": {
    "height": "546.85px",
    "left": "890.75px",
    "right": "20px",
    "top": "117px",
    "width": "350px"
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}