02_match_confirmaciones_de_envio_round_2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Codigo para clasificar mensajes recibidos + matchear (SOLO CONFIRMACION DE PROPERATI)\n",
    "#Ultima actualizacion: 6/05/2022\n",
    "\n",
    "#Inputs: (A) base de scraps de properati (randomization) y (B) base de mails con respuestas, en las cuales haya confirmaciones de properati\n",
    "#Outputs: (A) sent_mails_conf_envio_[FECHA], que agrupa las publicaciones a las que les enviamos correctamente el mail, y (B) not_sent_mails_conf_envio_[FECHA]_[PAIS] que muestra, para cada país, las inmobiliarias a las que les tenemos que reenviar los correos."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Importar paquetes necesarios para la clasificacion\n",
    "\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from datetime import datetime\n",
    "import matching_v1 as matching\n",
    "import tools\n",
    "\n",
    "pd.set_option('display.max_columns', None)\n",
    "pd.set_option('display.max_rows', 20)\n",
    "\n",
    "pd.options.mode.chained_assignment = None  # default='warn'\n",
    "\n",
    "#### Ronda y fecha de la ronda\n",
    "ronda = '2'\n",
    "fecha_out = '2022_05_10'\n",
    "fecha_rand = '2022_05_03'\n",
    "fecha_descarga = '2022_05_19'\n",
    "\n",
    "#### Establecer rutas de entrada y salida para las bases (si se cambian, comentar las que no se usen)\n",
    "#Rutas Nico\n",
    "path_dropbox = r\"C:\\Users\\Nico\\Dropbox\"\n",
    "\n",
    "#Rutas Juli\n",
    "# path_data = r\"C:\\Users\\Nico\\Dropbox\\BID-LGBTQ+\\campo\"\n",
    "\n",
    "#Rutas Luis\n",
    "# path_data = r\"C:\\Users\\Nico\\Dropbox\\BID-LGBTQ+\\campo\"\n",
    "\n",
    "#### Rutas utilizadas:\n",
    "path_data = path_dropbox + r\"\\BID-LGBTQ+\\campo\\data\"\n",
    "path_dataout = path_data + r\"\\mails_matches\\matched\\confirmaciones_de_envio\"\n",
    "path_datain = path_data + r\"\\mails_matches\\to_match\"\n",
    "path_deleted = path_data + r\"\\mails_matches\\deleted\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Importo bases de seleccion (tienen la variable nombre, n_adds_abv_mun y algunas otras)\n",
    "files = tools.crea_lista_de_archivos(path_data + fr\"\\randomization\\round2_2022_05_03\", \"dta\")\n",
    "\n",
    "df_concat = []\n",
    "for file in files:\n",
    "    df_temp = pd.read_stata(file)\n",
    "    df_concat += [df_temp]\n",
    "    \n",
    "scrap_full = pd.concat(df_concat)\n",
    "scrap_full = scrap_full.reset_index(drop=True)\n",
    "scrap_full['script_string_3'] = scrap_full['script_string_3'].astype('str')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Importar base de mails recibidos \n",
    "rtas_p1 = pd.read_excel(path_datain + fr\"\\mails_total_{fecha_descarga}_parte1.xlsx\")\n",
    "rtas_p2 = pd.read_excel(path_datain + fr\"\\mails_total_{fecha_descarga}_parte2.xlsx\")\n",
    "rtas_p3 = pd.read_excel(path_datain + fr\"\\mails_total_{fecha_descarga}_parte3.xlsx\")\n",
    "\n",
    "rtas_full = pd.concat([rtas_p1,rtas_p2,rtas_p3])\n",
    "rtas_full.to_excel(path_datain + fr\"\\mails_total_{fecha_descarga}.xlsx\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Base de correos desde los que enviamos\n",
    "mails_df = pd.read_excel(path_dropbox + r\"\\BID-LGBTQ+\\campo\\0_instrucciones\\2-Emails para Intervención.xlsx\")\n",
    "mails_df['Usuario_clean'] = mails_df.Usuario.apply(matching.clean_mail)\n",
    "users = mails_df['Usuario_clean'].to_list()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Se dropearon 423 observaciones.\n",
      "Se dropearon 221 observaciones.\n",
      "Se dropearon 146 observaciones.\n",
      "Se dropearon 656 observaciones.\n"
     ]
    }
   ],
   "source": [
    "#### Elimino observaciones que se corresponden a mails de prueba o de Google\n",
    "\n",
    "# Dropeo observaciones que tienen Google en el mail / user\n",
    "prev = len(rtas_full)\n",
    "rtas_full_out = rtas_full[rtas_full['from'].str.contains(\"Google\", na=False) == True]\n",
    "rtas_full =     rtas_full[rtas_full['from'].str.contains(\"Google\", na=False) == False]\n",
    "print(\"Se dropearon\", prev - len(rtas_full), \"observaciones.\")\n",
    "\n",
    "# Dropeo observaciones de prueba de Juli\n",
    "prev = len(rtas_full) \n",
    "to_concat = rtas_full[rtas_full['from'].str.contains(\"Julian test\", na=False) == True]\n",
    "rtas_full = rtas_full[rtas_full['from'].str.contains(\"Julian test\", na=False) == False]\n",
    "rtas_full_out = pd.concat([rtas_full_out,rtas_full[rtas_full['from'].str.contains(\"Julian test\", na=False) == True]])\n",
    "\n",
    "print(\"Se dropearon\", prev - len(rtas_full), \"observaciones.\")\n",
    "\n",
    "# Dropeo observaciones de prueba\n",
    "prev = len(rtas_full) \n",
    "to_concat = rtas_full[rtas_full['subject'].str.contains(\"prueba\", na=False) == True]\n",
    "rtas_full = rtas_full[rtas_full['subject'].str.contains(\"prueba\", na=False) == False]\n",
    "rtas_full_out = pd.concat([rtas_full_out,to_concat])\n",
    "print(\"Se dropearon\", prev - len(rtas_full), \"observaciones.\")\n",
    "\n",
    "# Dropeo observaciones de prueba (from == to, ¡nos los autoenviamos!)\n",
    "prev = len(rtas_full) \n",
    "for user in users:\n",
    "    to_concat = rtas_full[rtas_full['from'].apply(matching.clean_mail).str.contains(user)==True ]\n",
    "    rtas_full = rtas_full[rtas_full['from'].apply(matching.clean_mail).str.contains(user)==False]\n",
    "    rtas_full_out = pd.concat([rtas_full_out,to_concat])\n",
    "print(\"Se dropearon\", prev - len(rtas_full), \"observaciones.\")\n",
    "\n",
    "\n",
    "\n",
    "# Exporto las obs dropeadas\n",
    "rtas_full_out.to_excel(path_deleted + r\"\\observaciones_eliminadas_round_{ronda}_{fecha_out}.xlsx\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Se dropearon 20 observaciones.\n",
      "Match confirmaciones realizado.\n",
      "Cantidad de mails de @properati:\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "True     7281\n",
       "False    4931\n",
       "Name: conf_envio, dtype: int64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "##### Identifica mails que vienen de properati 'contacts@mailing.properati.com'\n",
    "\n",
    "# Filtro nulls\n",
    "before = len(rtas_full)\n",
    "rtas_full = rtas_full.dropna(subset=['from','body'])\n",
    "after = len(rtas_full)\n",
    "print(\"Se dropearon\", before-after, \"observaciones.\")\n",
    "\n",
    "# Creo binaria con True para los mails de properati\n",
    "mails_properati = ['contacts@mailing.properati.com']\n",
    "\n",
    "rtas_full['conf_envio'] = rtas_full['from'].apply(matching.match_string_con_lista, lista_matchs=mails_properati)\n",
    "print(\"Match confirmaciones realizado.\\nCantidad de mails de @properati:\")\n",
    "\n",
    "# Reporta los resultados\n",
    "rtas_full['conf_envio'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "##### Limpio las fechas\n",
    "rtas_full['date_clean'] = rtas_full['date'].str.replace(\".+,\\s\",\"\",regex=True)\n",
    "rtas_full['date_clean'] = rtas_full['date_clean'].str.replace(\"\\-|\\+|(0\\d00)(.*)\",\"\",regex=True)\n",
    "rtas_full['date_clean'] = rtas_full['date_clean'].str.replace(\"GMT\",\"\")\n",
    "rtas_full['date_clean'] = rtas_full['date_clean'].str.lstrip(' ').str.rstrip(' ')\n",
    "rtas_full['date_clean'] = rtas_full['date_clean'].str.zfill(20)\n",
    "rtas_full['date_clean'] = pd.to_datetime(rtas_full['date_clean'], format=\"%d %b %Y %H:%M:%S\")\n",
    "rtas_full['date_clean'] = rtas_full['date_clean'].dt.date  # Solo me quedo dia-mes-año"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['pablom.ngomez@gmail.com' 'jcmanuelrodrigue.z@gmail.com'\n",
      " 'gome.zpablou@gmail.com' 'rodriguez.j.cmanuel@gmail.com'\n",
      " 'pablom.ngome.z@gmail.com' 'rodriguez.manuel.j.f@gmail.com'\n",
      " 'ro.driguezmanuelw@gmail.com' 'manuelrodrigue.zjf@gmail.com'\n",
      " 'rodriguez.j.c.manuel@gmail.com' 'gomezf.hpablo@gmail.com'\n",
      " 'f.h.pablogomez@gmail.com' 'rodriguez.manuelj.f@gmail.com'\n",
      " 'p.hpablo.gomez@gmail.com' 'pablogome.z.f.h@gmail.com'\n",
      " 'rodriguezj.cmanuel@gmail.com' 'pablo.gomez.f.h@gmail.com'\n",
      " 'jfmanuelrodrigue.z@gmail.com' 'pablogome.zf.h@gmail.com'\n",
      " 'j.fmanuelrodriguez@gmail.com' 'p.hpablogome.z@gmail.com'\n",
      " 'j.fmanuel.rodriguez@gmail.com' 'f.h.pablo.gomez@gmail.com'\n",
      " 'rodrigue.zmanuel.w@gmail.com' 'p.h.pablo.gomez@gmail.com'\n",
      " 'rodrigue.z.manuel.w@gmail.com' 'rodrigue.zmanuelw@gmail.com'\n",
      " 'rodriguezmanuelj.f@gmail.com' 'gomezf.h.pablo@gmail.com'\n",
      " 'f.hpablogomez@gmail.com' 'j.cmanuelrodriguez@gmail.com'\n",
      " 'manuel.rodriguez.j.f@gmail.com' 'p.h.pablogomez@gmail.com'\n",
      " 'gomezfh.pa.blo@gmail.com' 'gome.zpablo.u@gmail.com'\n",
      " 'j.f.manuel.rodriguez@gmail.com' 'rodrigue.zmanueljf@gmail.com'\n",
      " 'manuel.rodriguezj.f@gmail.com' 'j.c.manuelrodriguez@gmail.com'\n",
      " 'manuelrodriguezj.f@gmail.com' 'pablo.m.ngomez@gmail.com'\n",
      " 'f.hpablogome.z@gmail.com' 'gome.z.pablou@gmail.com'\n",
      " 'gomez.f.h.pablo@gmail.com' 'pablogomezf.h@gmail.com'\n",
      " 'rodriguezj.c.manuel@gmail.com' 'pablo.m.n.gome.z@gmail.com'\n",
      " 'j.cmanuel.rodriguez@gmail.com' 'gome.z.pablo.u@gmail.com']\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de pablom.ngomez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 37 \n",
      "Cantidad de respuestas: 22\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de jcmanuelrodrigue.z@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 37 \n",
      "Cantidad de respuestas: 27\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de gome.zpablou@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 136 \n",
      "Cantidad de respuestas: 86\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodriguez.j.cmanuel@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 42 \n",
      "Cantidad de respuestas: 29\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de pablom.ngome.z@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 41 \n",
      "Cantidad de respuestas: 27\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodriguez.manuel.j.f@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 32 \n",
      "Cantidad de respuestas: 20\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de ro.driguezmanuelw@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 122 \n",
      "Cantidad de respuestas: 78\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de manuelrodrigue.zjf@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 35 \n",
      "Cantidad de respuestas: 24\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodriguez.j.c.manuel@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 37 \n",
      "Cantidad de respuestas: 24\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de gomezf.hpablo@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 119 \n",
      "Cantidad de respuestas: 76\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de f.h.pablogomez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 39 \n",
      "Cantidad de respuestas: 24\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodriguez.manuelj.f@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 23 \n",
      "Cantidad de respuestas: 17\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de p.hpablo.gomez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 33 \n",
      "Cantidad de respuestas: 23\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de pablogome.z.f.h@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 31 \n",
      "Cantidad de respuestas: 18\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodriguezj.cmanuel@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 32 \n",
      "Cantidad de respuestas: 19\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de pablo.gomez.f.h@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 31 \n",
      "Cantidad de respuestas: 21\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de jfmanuelrodrigue.z@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 133 \n",
      "Cantidad de respuestas: 85\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de pablogome.zf.h@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 31 \n",
      "Cantidad de respuestas: 22\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.fmanuelrodriguez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 115 \n",
      "Cantidad de respuestas: 70\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de p.hpablogome.z@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 32 \n",
      "Cantidad de respuestas: 20\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.fmanuel.rodriguez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 101 \n",
      "Cantidad de respuestas: 65\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de f.h.pablo.gomez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 36 \n",
      "Cantidad de respuestas: 19\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodrigue.zmanuel.w@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 122 \n",
      "Cantidad de respuestas: 68\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de p.h.pablo.gomez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 38 \n",
      "Cantidad de respuestas: 24\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodrigue.z.manuel.w@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 139 \n",
      "Cantidad de respuestas: 86\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodrigue.zmanuelw@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 140 \n",
      "Cantidad de respuestas: 84\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodriguezmanuelj.f@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 32 \n",
      "Cantidad de respuestas: 19\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de gomezf.h.pablo@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 138 \n",
      "Cantidad de respuestas: 88\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de f.hpablogomez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 35 \n",
      "Cantidad de respuestas: 22\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.cmanuelrodriguez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 31 \n",
      "Cantidad de respuestas: 18\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de manuel.rodriguez.j.f@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 41 \n",
      "Cantidad de respuestas: 27\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de p.h.pablogomez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 27 \n",
      "Cantidad de respuestas: 17\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de gomezfh.pa.blo@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 134 \n",
      "Cantidad de respuestas: 114\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de gome.zpablo.u@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 105 \n",
      "Cantidad de respuestas: 71\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.f.manuel.rodriguez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 130 \n",
      "Cantidad de respuestas: 80\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodrigue.zmanueljf@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 30 \n",
      "Cantidad de respuestas: 19\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de manuel.rodriguezj.f@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 28 \n",
      "Cantidad de respuestas: 20\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.c.manuelrodriguez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 37 \n",
      "Cantidad de respuestas: 26\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de manuelrodriguezj.f@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 26 \n",
      "Cantidad de respuestas: 18\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de pablo.m.ngomez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 24 \n",
      "Cantidad de respuestas: 18\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de f.hpablogome.z@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 35 \n",
      "Cantidad de respuestas: 21\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de gome.z.pablou@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 118 \n",
      "Cantidad de respuestas: 74\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de gomez.f.h.pablo@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 124 \n",
      "Cantidad de respuestas: 81\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de pablogomezf.h@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 24 \n",
      "Cantidad de respuestas: 15\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodriguezj.c.manuel@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 29 \n",
      "Cantidad de respuestas: 22\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de pablo.m.n.gome.z@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 21 \n",
      "Cantidad de respuestas: 15\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.cmanuel.rodriguez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 22 \n",
      "Cantidad de respuestas: 17\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de gome.z.pablo.u@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 127 \n",
      "Cantidad de respuestas: 75\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "end of script\n",
      "['j.p.gonzalez.carlos@gmail.com' 'j.carlosugonzalez@gmail.com'\n",
      " 'w.gonzalez.carlosp@gmail.com' 'carlos.gonzalezx.w@gmail.com'\n",
      " 'rjoserodriguez.t@gmail.com' 'carlosm.zgonzalez@gmail.com'\n",
      " 'j.carlos.u.gonzalez@gmail.com' 'rodriguez.m.jose.v@gmail.com'\n",
      " 'carlosgonzalezx.w@gmail.com' 'w.gonzalezcarlos.p@gmail.com'\n",
      " 's.carlos.gonzalez.m@gmail.com' 's.carlosgonzalezm@gmail.com'\n",
      " 'w.gonzalezcarlosp@gmail.com' 'rodriguez.m.josev@gmail.com'\n",
      " 'rodriguezm.jose.v@gmail.com' 'rodriguez.l.josec@gmail.com'\n",
      " 'jose.d.rodriguez.w@gmail.com' 'rodriguez.ljose.c@gmail.com'\n",
      " 'carlosm.z.gonzalez@gmail.com' 'jose.f.rodriguezu@gmail.com'\n",
      " 'j.carlosu.gonzalez@gmail.com' 'j.carlos.ugonzalez@gmail.com'\n",
      " 'r.jose.rodriguez.t@gmail.com' 'j.pgonzalez.carlos@gmail.com'\n",
      " 'carlos.gonzalez.x.w@gmail.com' 'josed.rodriguez.w@gmail.com'\n",
      " 's.carlos.gonzalezm@gmail.com' 'w.joserodriguez.p@gmail.com'\n",
      " 'w.jose.rodriguezp@gmail.com' 'r.joserodriguez.t@gmail.com'\n",
      " 'w.joserodriguezp@gmail.com' 's.carlosgonzalez.m@gmail.com'\n",
      " 'rodriguez.l.jose.c@gmail.com' 'rjose.rodriguez.t@gmail.com'\n",
      " 'jose.drodriguez.w@gmail.com' 'carlos.m.zgonzalez@gmail.com'\n",
      " 'rodriguez.ljosec@gmail.com' 'rodriguezm.josev@gmail.com'\n",
      " 'j.p.gonzalezcarlos@gmail.com' 'jose.f.rodriguez.u@gmail.com'\n",
      " 'j.pgonzalezcarlos@gmail.com' 'jose.frodriguez.u@gmail.com'\n",
      " 'w.jose.rodriguez.p@gmail.com' 'carlos.m.z.gonzalez@gmail.com'\n",
      " 'jose.frodriguezu@gmail.com' 'carlosgonzalez.x.w@gmail.com'\n",
      " 'w.gonzalez.carlos.p@gmail.com' 'josedrodriguez.w@gmail.com']\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.p.gonzalez.carlos@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 9 \n",
      "Cantidad de respuestas: 5\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.carlosugonzalez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 10 \n",
      "Cantidad de respuestas: 7\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de w.gonzalez.carlosp@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 13 \n",
      "Cantidad de respuestas: 9\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de carlos.gonzalezx.w@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 59 \n",
      "Cantidad de respuestas: 37\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rjoserodriguez.t@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 11 \n",
      "Cantidad de respuestas: 7\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de carlosm.zgonzalez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 51 \n",
      "Cantidad de respuestas: 30\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.carlos.u.gonzalez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 12 \n",
      "Cantidad de respuestas: 8\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodriguez.m.jose.v@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 13 \n",
      "Cantidad de respuestas: 9\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de carlosgonzalezx.w@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 56 \n",
      "Cantidad de respuestas: 32\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de w.gonzalezcarlos.p@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 11 \n",
      "Cantidad de respuestas: 6\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de s.carlos.gonzalez.m@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 11 \n",
      "Cantidad de respuestas: 7\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de s.carlosgonzalezm@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 12 \n",
      "Cantidad de respuestas: 8\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de w.gonzalezcarlosp@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 12 \n",
      "Cantidad de respuestas: 7\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodriguez.m.josev@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 10 \n",
      "Cantidad de respuestas: 8\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodriguezm.jose.v@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 11 \n",
      "Cantidad de respuestas: 7\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodriguez.l.josec@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 16 \n",
      "Cantidad de respuestas: 10\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de jose.d.rodriguez.w@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 55 \n",
      "Cantidad de respuestas: 37\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodriguez.ljose.c@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 12 \n",
      "Cantidad de respuestas: 8\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de carlosm.z.gonzalez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 61 \n",
      "Cantidad de respuestas: 38\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de jose.f.rodriguezu@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 62 \n",
      "Cantidad de respuestas: 35\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.carlosu.gonzalez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 16 \n",
      "Cantidad de respuestas: 9\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.carlos.ugonzalez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 12 \n",
      "Cantidad de respuestas: 8\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de r.jose.rodriguez.t@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 10 \n",
      "Cantidad de respuestas: 6\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.pgonzalez.carlos@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 14 \n",
      "Cantidad de respuestas: 7\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de carlos.gonzalez.x.w@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 48 \n",
      "Cantidad de respuestas: 35\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de josed.rodriguez.w@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 56 \n",
      "Cantidad de respuestas: 33\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de s.carlos.gonzalezm@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 10 \n",
      "Cantidad de respuestas: 6\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de w.joserodriguez.p@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 11 \n",
      "Cantidad de respuestas: 7\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de w.jose.rodriguezp@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 8 \n",
      "Cantidad de respuestas: 5\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de r.joserodriguez.t@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 5 \n",
      "Cantidad de respuestas: 4\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de w.joserodriguezp@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 11 \n",
      "Cantidad de respuestas: 7\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de s.carlosgonzalez.m@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 10 \n",
      "Cantidad de respuestas: 6\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodriguez.l.jose.c@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 11 \n",
      "Cantidad de respuestas: 7\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rjose.rodriguez.t@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 8 \n",
      "Cantidad de respuestas: 5\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de jose.drodriguez.w@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 63 \n",
      "Cantidad de respuestas: 38\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de carlos.m.zgonzalez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 57 \n",
      "Cantidad de respuestas: 32\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodriguez.ljosec@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 10 \n",
      "Cantidad de respuestas: 8\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodriguezm.josev@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 10 \n",
      "Cantidad de respuestas: 7\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.p.gonzalezcarlos@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 7 \n",
      "Cantidad de respuestas: 4\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de jose.f.rodriguez.u@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 72 \n",
      "Cantidad de respuestas: 39\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.pgonzalezcarlos@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 10 \n",
      "Cantidad de respuestas: 5\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de jose.frodriguez.u@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 48 \n",
      "Cantidad de respuestas: 30\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de w.jose.rodriguez.p@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 11 \n",
      "Cantidad de respuestas: 8\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de carlos.m.z.gonzalez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 39 \n",
      "Cantidad de respuestas: 25\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de jose.frodriguezu@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 45 \n",
      "Cantidad de respuestas: 27\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de carlosgonzalez.x.w@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 55 \n",
      "Cantidad de respuestas: 36\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de w.gonzalez.carlos.p@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 9 \n",
      "Cantidad de respuestas: 6\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de josedrodriguez.w@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 55 \n",
      "Cantidad de respuestas: 33\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "end of script\n",
      "['luismzambrano.j@gmail.com' 'p.garcia.juanf@gmail.com'\n",
      " 'zam.branof.luis@gmail.com' 'luis.mzambrano.j@gmail.com'\n",
      " 'luisbzambrano.m@gmail.com' 'luis.c.zambrano.r@gmail.com'\n",
      " 'p.garciajuanc@gmail.com' 'wg.arciajuan@gmail.com'\n",
      " 'juanp.w.garcia@gmail.com' 'zam.brano.k.luis@gmail.com'\n",
      " 'zambrano.luisp.t@gmail.com' 'luisc.zambrano.r@gmail.com'\n",
      " 'juan.p.w.garcia@gmail.com' 'p.garciajuanf@gmail.com'\n",
      " 'zam.branok.luis@gmail.com' 'juan.p.wgarcia@gmail.com'\n",
      " 'juanp.wgarcia@gmail.com' 'zambrano.luis.p.t@gmail.com'\n",
      " 'w.g.arcia.juan@gmail.com' 'p.garciajuan.f@gmail.com'\n",
      " 'p.garcia.juan.f@gmail.com' 'p.garcia.juan.c@gmail.com'\n",
      " 'f.garcia.juanp@gmail.com' 'h.garciajuans@gmail.com'\n",
      " 'wg.arcia.juan@gmail.com' 'p.garciajuan.c@gmail.com'\n",
      " 'luisb.zambrano.m@gmail.com' 'zam.brano.f.luis@gmail.com'\n",
      " 'luis.m.zambrano.j@gmail.com' 'f.garciajuanp@gmail.com'\n",
      " 'zambranoluis.p.t@gmail.com' 'luisczambrano.r@gmail.com'\n",
      " 'h.garcia.juan.s@gmail.com' 'zam.brano.fluis@gmail.com'\n",
      " 'p.garcia.juanc@gmail.com' 'zambranoluisp.t@gmail.com'\n",
      " 'zam.branofluis@gmail.com' 'zam.brano.kluis@gmail.com'\n",
      " 'luis.czambrano.r@gmail.com' 'h.garcia.juans@gmail.com'\n",
      " 'luism.zambrano.j@gmail.com' 'luis.b.zambrano.m@gmail.com'\n",
      " 'w.g.arciajuan@gmail.com' 'f.garcia.juan.p@gmail.com'\n",
      " 'f.garciajuan.p@gmail.com' 'luis.bzambrano.m@gmail.com'\n",
      " 'h.garciajuan.s@gmail.com' 'zam.branokluis@gmail.com']\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de luismzambrano.j@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 6 \n",
      "Cantidad de respuestas: 4\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de p.garcia.juanf@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 6 \n",
      "Cantidad de respuestas: 5\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de zam.branof.luis@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 7 \n",
      "Cantidad de respuestas: 5\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de luis.mzambrano.j@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 7 \n",
      "Cantidad de respuestas: 5\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de luisbzambrano.m@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 29 \n",
      "Cantidad de respuestas: 17\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de luis.c.zambrano.r@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 30 \n",
      "Cantidad de respuestas: 17\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de p.garciajuanc@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 8 \n",
      "Cantidad de respuestas: 5\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de wg.arciajuan@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 6 \n",
      "Cantidad de respuestas: 4\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de juanp.w.garcia@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 5 \n",
      "Cantidad de respuestas: 4\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de zam.brano.k.luis@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 8 \n",
      "Cantidad de respuestas: 4\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de zambrano.luisp.t@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 3 \n",
      "Cantidad de respuestas: 2\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de luisc.zambrano.r@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 27 \n",
      "Cantidad de respuestas: 13\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de juan.p.w.garcia@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 8 \n",
      "Cantidad de respuestas: 5\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de p.garciajuanf@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 8 \n",
      "Cantidad de respuestas: 5\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de zam.branok.luis@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 9 \n",
      "Cantidad de respuestas: 5\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de juan.p.wgarcia@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 6 \n",
      "Cantidad de respuestas: 3\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de juanp.wgarcia@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 7 \n",
      "Cantidad de respuestas: 5\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de zambrano.luis.p.t@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 11 \n",
      "Cantidad de respuestas: 5\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de w.g.arcia.juan@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 14 \n",
      "Cantidad de respuestas: 8\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de p.garciajuan.f@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 7 \n",
      "Cantidad de respuestas: 4\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de p.garcia.juan.f@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 7 \n",
      "Cantidad de respuestas: 4\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de p.garcia.juan.c@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 6 \n",
      "Cantidad de respuestas: 4\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de f.garcia.juanp@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 31 \n",
      "Cantidad de respuestas: 20\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de h.garciajuans@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 22 \n",
      "Cantidad de respuestas: 14\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de wg.arcia.juan@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 11 \n",
      "Cantidad de respuestas: 5\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de p.garciajuan.c@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 8 \n",
      "Cantidad de respuestas: 4\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de luisb.zambrano.m@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 24 \n",
      "Cantidad de respuestas: 14\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de zam.brano.f.luis@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 10 \n",
      "Cantidad de respuestas: 6\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de luis.m.zambrano.j@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 8 \n",
      "Cantidad de respuestas: 4\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de f.garciajuanp@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 30 \n",
      "Cantidad de respuestas: 16\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de zambranoluis.p.t@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 6 \n",
      "Cantidad de respuestas: 3\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de luisczambrano.r@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 20 \n",
      "Cantidad de respuestas: 13\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de h.garcia.juan.s@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 20 \n",
      "Cantidad de respuestas: 12\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de zam.brano.fluis@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 7 \n",
      "Cantidad de respuestas: 3\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de p.garcia.juanc@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 2 \n",
      "Cantidad de respuestas: 2\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de zambranoluisp.t@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 1 \n",
      "Cantidad de respuestas: 1\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de zam.branofluis@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 4 \n",
      "Cantidad de respuestas: 2\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de zam.brano.kluis@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 8 \n",
      "Cantidad de respuestas: 4\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de luis.czambrano.r@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 31 \n",
      "Cantidad de respuestas: 18\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de h.garcia.juans@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 28 \n",
      "Cantidad de respuestas: 16\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de luism.zambrano.j@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 6 \n",
      "Cantidad de respuestas: 4\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de luis.b.zambrano.m@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 20 \n",
      "Cantidad de respuestas: 11\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de w.g.arciajuan@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 4 \n",
      "Cantidad de respuestas: 3\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de f.garcia.juan.p@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 23 \n",
      "Cantidad de respuestas: 15\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de f.garciajuan.p@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 27 \n",
      "Cantidad de respuestas: 12\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de luis.bzambrano.m@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 30 \n",
      "Cantidad de respuestas: 16\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de h.garciajuan.s@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 16 \n",
      "Cantidad de respuestas: 8\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de zam.branokluis@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 5 \n",
      "Cantidad de respuestas: 3\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "end of script\n",
      "['jdanielflores.t@gmail.com' 'jdanielflores.j@gmail.com'\n",
      " 'b.dominguez.alejandro.c@gmail.com' 'm.dominguezalejandro.h@gmail.com'\n",
      " 'b.flores.daniel.j@gmail.com' 'p.dominguezalejandroj@gmail.com'\n",
      " 'p.dominguez.alejandro.h@gmail.com' 'p.dominguezalejandro.h@gmail.com'\n",
      " 'bflore.s.danielj@gmail.com' 'jdanielflores.u@gmail.com'\n",
      " 'alejandro.m.dominguez.u@gmail.com' 'm.dominguez.alejandro.h@gmail.com'\n",
      " 'j.daniel.flores.n@gmail.com' 'p.dominguez.alejandroj@gmail.com'\n",
      " 'p.dominguezalejandroh@gmail.com' 'jdaniel.flores.u@gmail.com'\n",
      " 'j.danielflores.u@gmail.com' 'm.dominguez.alejandroh@gmail.com'\n",
      " 'jdaniel.flores.n@gmail.com' 'flores.c.daniel.p@gmail.com'\n",
      " 'jdanielflores.n@gmail.com' 'j.danielflores.t@gmail.com'\n",
      " 'floresc.daniel.p@gmail.com' 'f.dominguezalejandro.g@gmail.com'\n",
      " 'jdaniel.flores.t@gmail.com' 'flores.c.danielp@gmail.com'\n",
      " 'm.dominguezalejandroh@gmail.com' 'p.dominguez.alejandroh@gmail.com'\n",
      " 'j.danielflores.j@gmail.com' 'j.daniel.flores.t@gmail.com'\n",
      " 'p.dominguezalejandro.j@gmail.com' 'b.dominguez.alejandroc@gmail.com'\n",
      " 'f.dominguez.alejandro.g@gmail.com' 'j.daniel.flores.j@gmail.com'\n",
      " 'alejandro.mdominguez.u@gmail.com' 'p.dominguez.alejandro.j@gmail.com'\n",
      " 'f.dominguez.alejandrog@gmail.com' 'j.danielflores.n@gmail.com'\n",
      " 'j.daniel.flores.u@gmail.com' 'alejandromdominguez.u@gmail.com'\n",
      " 'jdaniel.flores.j@gmail.com' 'b.dominguezalejandroc@gmail.com'\n",
      " 'b.floresdaniel.j@gmail.com' 'b.floresdanielj@gmail.com'\n",
      " 'f.dominguezalejandrog@gmail.com' 'b.dominguezalejandro.c@gmail.com'\n",
      " 'flore.sc.danielp@gmail.com' 'alejandrom.dominguez.u@gmail.com']\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de jdanielflores.t@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 7 \n",
      "Cantidad de respuestas: 6\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de jdanielflores.j@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 12 \n",
      "Cantidad de respuestas: 10\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de b.dominguez.alejandro.c@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 25 \n",
      "Cantidad de respuestas: 15\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de m.dominguezalejandro.h@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 5 \n",
      "Cantidad de respuestas: 4\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de b.flores.daniel.j@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 32 \n",
      "Cantidad de respuestas: 17\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de p.dominguezalejandroj@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 7 \n",
      "Cantidad de respuestas: 6\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de p.dominguez.alejandro.h@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 7 \n",
      "Cantidad de respuestas: 7\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de p.dominguezalejandro.h@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 15 \n",
      "Cantidad de respuestas: 10\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de bflore.s.danielj@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 30 \n",
      "Cantidad de respuestas: 20\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de jdanielflores.u@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 13 \n",
      "Cantidad de respuestas: 10\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de alejandro.m.dominguez.u@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 31 \n",
      "Cantidad de respuestas: 21\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de m.dominguez.alejandro.h@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 10 \n",
      "Cantidad de respuestas: 8\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.daniel.flores.n@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 11 \n",
      "Cantidad de respuestas: 10\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de p.dominguez.alejandroj@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 16 \n",
      "Cantidad de respuestas: 11\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de p.dominguezalejandroh@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 16 \n",
      "Cantidad de respuestas: 10\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de jdaniel.flores.u@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 16 \n",
      "Cantidad de respuestas: 8\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.danielflores.u@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 7 \n",
      "Cantidad de respuestas: 6\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de m.dominguez.alejandroh@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 16 \n",
      "Cantidad de respuestas: 12\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de jdaniel.flores.n@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 13 \n",
      "Cantidad de respuestas: 10\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de flores.c.daniel.p@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 30 \n",
      "Cantidad de respuestas: 21\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de jdanielflores.n@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 11 \n",
      "Cantidad de respuestas: 7\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.danielflores.t@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 11 \n",
      "Cantidad de respuestas: 9\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de floresc.daniel.p@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 20 \n",
      "Cantidad de respuestas: 14\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de f.dominguezalejandro.g@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 13 \n",
      "Cantidad de respuestas: 10\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de jdaniel.flores.t@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 8 \n",
      "Cantidad de respuestas: 7\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de flores.c.danielp@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 28 \n",
      "Cantidad de respuestas: 18\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de m.dominguezalejandroh@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 12 \n",
      "Cantidad de respuestas: 9\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de p.dominguez.alejandroh@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 10 \n",
      "Cantidad de respuestas: 9\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.danielflores.j@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 9 \n",
      "Cantidad de respuestas: 8\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.daniel.flores.t@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 14 \n",
      "Cantidad de respuestas: 10\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de p.dominguezalejandro.j@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 9 \n",
      "Cantidad de respuestas: 8\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de b.dominguez.alejandroc@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 26 \n",
      "Cantidad de respuestas: 18\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de f.dominguez.alejandro.g@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 11 \n",
      "Cantidad de respuestas: 9\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.daniel.flores.j@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 12 \n",
      "Cantidad de respuestas: 8\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de alejandro.mdominguez.u@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 29 \n",
      "Cantidad de respuestas: 21\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de p.dominguez.alejandro.j@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 14 \n",
      "Cantidad de respuestas: 11\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de f.dominguez.alejandrog@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 14 \n",
      "Cantidad de respuestas: 10\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.danielflores.n@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 10 \n",
      "Cantidad de respuestas: 6\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de j.daniel.flores.u@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 8 \n",
      "Cantidad de respuestas: 6\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de alejandromdominguez.u@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 28 \n",
      "Cantidad de respuestas: 17\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de jdaniel.flores.j@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 10 \n",
      "Cantidad de respuestas: 7\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de b.dominguezalejandroc@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 28 \n",
      "Cantidad de respuestas: 17\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de b.floresdaniel.j@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 25 \n",
      "Cantidad de respuestas: 18\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de b.floresdanielj@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 25 \n",
      "Cantidad de respuestas: 17\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de f.dominguezalejandrog@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 8 \n",
      "Cantidad de respuestas: 6\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de b.dominguezalejandro.c@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 36 \n",
      "Cantidad de respuestas: 22\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de flore.sc.danielp@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 27 \n",
      "Cantidad de respuestas: 17\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de alejandrom.dominguez.u@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 31 \n",
      "Cantidad de respuestas: 20\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 0 - El 0.0 % de las observaciones\n",
      "\n",
      "end of script\n",
      "C:\\Users\\Nico\\Dropbox\\BID-LGBTQ+\\campo\\data\\mails_matches\\matched\\confirmaciones_de_envio\\sent_mails_conf_envio_round_2_2022_08_04.xlsx creado\n"
     ]
    }
   ],
   "source": [
    "##### Matcheo @properati con scraps\n",
    "from importlib import reload\n",
    "reload(matching)\n",
    "rtas_full.reset_index(drop=True, inplace=True)\n",
    "\n",
    "fin_ronda_1 = pd.to_datetime(\"2022-05-03\").date()\n",
    "rtas_properati = rtas_full.loc[(rtas_full['date_clean']>fin_ronda_1) & (rtas_full['conf_envio']==True)]\n",
    "\n",
    "today = datetime.now()\n",
    "today = today.strftime(\"%Y_%m_%d\")\n",
    "nombre = f'mails_conf_envio_round_{ronda}_{today}'\n",
    "\n",
    "rtas_properati['index_scrap'] = np.nan\n",
    "rtas_properati['match_confiab'] = np.nan\n",
    "rtas_properati['match_step'] = np.nan\n",
    "rtas_properati['match_string'] = np.nan\n",
    "rtas_properati['match2_string'] = np.nan\n",
    "scrap_full['index_rtas'] = np.nan\n",
    "scrap_full['match_confiab'] = np.nan\n",
    "scrap_full['match_step'] = np.nan\n",
    "\n",
    "matched_arg = matching.full_proceso_solo_id(path=path_dataout, rtas_full=rtas_properati[rtas_properati['pais']=='arg'], scrap_full=scrap_full[scrap_full['pais']=='arg'], pais='_ARG')\n",
    "matched_col = matching.full_proceso_solo_id(path=path_dataout, rtas_full=rtas_properati[rtas_properati['pais']=='col'], scrap_full=scrap_full[scrap_full['pais']=='col'], pais='_COL')\n",
    "matched_ecu = matching.full_proceso_solo_id(path=path_dataout, rtas_full=rtas_properati[rtas_properati['pais']=='ecu'], scrap_full=scrap_full[scrap_full['pais']=='ecu'], pais='_ECU')\n",
    "matched_per = matching.full_proceso_solo_id(path=path_dataout, rtas_full=rtas_properati[rtas_properati['pais']=='per'], scrap_full=scrap_full[scrap_full['pais']=='per'], pais='_PER')\n",
    "\n",
    "# Exporto los matcheados a un único Excel\n",
    "matched = pd.concat([matched_arg,matched_col,matched_ecu,matched_per])\n",
    "matched.to_excel(path_dataout + \"\\\\sent_\" + nombre +\".xlsx\")\n",
    "print(path_dataout + \"\\\\sent_\" + nombre +\".xlsx creado\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "both          3636\n",
       "left_only        0\n",
       "right_only       0\n",
       "Name: _merge, dtype: int64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matched._merge.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>index_x</th>\n",
       "      <th>inmobiliaria</th>\n",
       "      <th>municipio</th>\n",
       "      <th>nombre</th>\n",
       "      <th>fecha</th>\n",
       "      <th>link</th>\n",
       "      <th>ciudad</th>\n",
       "      <th>pais_x</th>\n",
       "      <th>descripcion</th>\n",
       "      <th>precio</th>\n",
       "      <th>moneda</th>\n",
       "      <th>caracteristicas</th>\n",
       "      <th>ambientes</th>\n",
       "      <th>habitaciones</th>\n",
       "      <th>banos</th>\n",
       "      <th>m2_totales</th>\n",
       "      <th>m2_cubiertos</th>\n",
       "      <th>cocheras</th>\n",
       "      <th>id</th>\n",
       "      <th>precio_local</th>\n",
       "      <th>p_m2</th>\n",
       "      <th>p_m2_above_mdn</th>\n",
       "      <th>n_adds</th>\n",
       "      <th>n_adds_above_mdn</th>\n",
       "      <th>m2_above_mdn</th>\n",
       "      <th>common_name</th>\n",
       "      <th>capital</th>\n",
       "      <th>treatment</th>\n",
       "      <th>ses</th>\n",
       "      <th>male_name</th>\n",
       "      <th>mail</th>\n",
       "      <th>male_couple</th>\n",
       "      <th>female_couple</th>\n",
       "      <th>script</th>\n",
       "      <th>script_string</th>\n",
       "      <th>script_string_2</th>\n",
       "      <th>script_string_3</th>\n",
       "      <th>randomization_seed</th>\n",
       "      <th>nombre_2</th>\n",
       "      <th>profesional</th>\n",
       "      <th>vivienda</th>\n",
       "      <th>n_adds_muni</th>\n",
       "      <th>n_adds_muni_above_mdn</th>\n",
       "      <th>random</th>\n",
       "      <th>index_rtas</th>\n",
       "      <th>match_confiab_x</th>\n",
       "      <th>match_step_x</th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>subject</th>\n",
       "      <th>from</th>\n",
       "      <th>to</th>\n",
       "      <th>body</th>\n",
       "      <th>date</th>\n",
       "      <th>cc</th>\n",
       "      <th>thread_id</th>\n",
       "      <th>mimeType</th>\n",
       "      <th>pais_y</th>\n",
       "      <th>index_y</th>\n",
       "      <th>conf_envio</th>\n",
       "      <th>date_clean</th>\n",
       "      <th>index_scrap</th>\n",
       "      <th>match_confiab_y</th>\n",
       "      <th>match_step_y</th>\n",
       "      <th>match_string</th>\n",
       "      <th>match2_string</th>\n",
       "      <th>_merge</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>719</td>\n",
       "      <td>heredia</td>\n",
       "      <td>caba</td>\n",
       "      <td>departamento en alquiler en neuquen 602</td>\n",
       "      <td>2022-02-18</td>\n",
       "      <td>properati.com.ar/detalle/4ae45_alquiler_depart...</td>\n",
       "      <td>buenos aires ampliado</td>\n",
       "      <td>arg</td>\n",
       "      <td>edificio de 14 pisos, 5 departamentos por piso...</td>\n",
       "      <td>32000.0</td>\n",
       "      <td>$</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "      <td>150</td>\n",
       "      <td>32000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>trans</td>\n",
       "      <td>neutral</td>\n",
       "      <td>Manuel</td>\n",
       "      <td>rodriguez.j.cmanuel@gmail.com</td>\n",
       "      <td>Luis</td>\n",
       "      <td>Belén</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Hola, somos una pareja interesada en alquilar ...</td>\n",
       "      <td>Manuel y Belén (ella es trans)</td>\n",
       "      <td>Código 150</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1214</td>\n",
       "      <td>Hiciste una consulta por la propiedad Neuquen 602</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com.ar&gt;</td>\n",
       "      <td>rodriguez.j.cmanuel@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --_x000D_\\n_x00...</td>\n",
       "      <td>Wed, 04 May 2022 17:25:48 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>180901b4bb14d042</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>arg</td>\n",
       "      <td>141.0</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-05-04</td>\n",
       "      <td>16.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1351, end=1360, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1360</td>\n",
       "      <td>amadeo propiedades</td>\n",
       "      <td>lomas_de_zamora</td>\n",
       "      <td>departamento en alquiler en hipolito yrigoyen ...</td>\n",
       "      <td>2022-01-11</td>\n",
       "      <td>properati.com.ar/detalle/47suq_alquiler_depart...</td>\n",
       "      <td>buenos aires ampliado</td>\n",
       "      <td>arg</td>\n",
       "      <td>departamento 2 amb, ubicado en hipolito yrigoy...</td>\n",
       "      <td>26000.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['2ambientes', '1bano', '26 m²totales']</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "      <td>5389</td>\n",
       "      <td>26000.0</td>\n",
       "      <td>1000.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>trans</td>\n",
       "      <td>neutral</td>\n",
       "      <td>Manuel</td>\n",
       "      <td>rodriguez.j.cmanuel@gmail.com</td>\n",
       "      <td>Pablo</td>\n",
       "      <td>Florencia</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Buenos días, mi nombre es Manuel, junto a mi p...</td>\n",
       "      <td>Manuel y Florencia.</td>\n",
       "      <td>Código 5389</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1149</td>\n",
       "      <td>Hiciste una consulta por la propiedad Hipolito...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com.ar&gt;</td>\n",
       "      <td>rodriguez.j.cmanuel@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --_x000D_\\n_x00...</td>\n",
       "      <td>Wed, 04 May 2022 19:52:48 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18090a1dda3ef7c7</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>arg</td>\n",
       "      <td>76.0</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-05-04</td>\n",
       "      <td>24.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1533, end=1543, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>943</td>\n",
       "      <td>raices puerto madero</td>\n",
       "      <td>caba</td>\n",
       "      <td>departamento en alquiler en florida 1065</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>properati.com.ar/detalle/3z6bc_alquiler_depart...</td>\n",
       "      <td>buenos aires ampliado</td>\n",
       "      <td>arg</td>\n",
       "      <td>se trata de un departamento en el edificio kav...</td>\n",
       "      <td>900.0</td>\n",
       "      <td>usd</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "      <td>1373</td>\n",
       "      <td>179550.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>homo</td>\n",
       "      <td>neutral</td>\n",
       "      <td>Pablo</td>\n",
       "      <td>pablom.ngome.z@gmail.com</td>\n",
       "      <td>Manuel</td>\n",
       "      <td></td>\n",
       "      <td>2.0</td>\n",
       "      <td>Hola, somos una pareja interesada en alquilar ...</td>\n",
       "      <td>Pablo y Manuel</td>\n",
       "      <td>Código 1373</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1539</td>\n",
       "      <td>Hiciste una consulta por la propiedad Florida ...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com.ar&gt;</td>\n",
       "      <td>pablom.ngome.z@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 04 May 2022 17:43:55 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>180902be574364f4</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>arg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-05-04</td>\n",
       "      <td>18.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1276, end=1286, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1415</td>\n",
       "      <td>paula di gaeta estudio inmobiliario</td>\n",
       "      <td>lomas_de_zamora</td>\n",
       "      <td>departamento en alquiler en fray mamerto esqui...</td>\n",
       "      <td>2022-04-26</td>\n",
       "      <td>properati.com.ar/detalle/4g9js_alquiler_depart...</td>\n",
       "      <td>buenos aires ampliado</td>\n",
       "      <td>arg</td>\n",
       "      <td>departamento de dos ambientes opcional con coc...</td>\n",
       "      <td>22000.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['2ambientes', '1bano', '30 m²totales']</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "      <td>3891</td>\n",
       "      <td>22000.0</td>\n",
       "      <td>733.333313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>trans</td>\n",
       "      <td>neutral</td>\n",
       "      <td>Pablo</td>\n",
       "      <td>pablogome.zf.h@gmail.com</td>\n",
       "      <td>Luis</td>\n",
       "      <td>Laura</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Buenos días, mi nombre es Pablo, junto a mi pa...</td>\n",
       "      <td>Pablo y Laura.</td>\n",
       "      <td>Código 3891</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>42</td>\n",
       "      <td>Hiciste una consulta por la propiedad Fray Mam...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com.ar&gt;</td>\n",
       "      <td>pablogome.zf.h@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 04 May 2022 20:09:32 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18090b137e0bb927</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>arg</td>\n",
       "      <td>42.0</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-05-04</td>\n",
       "      <td>17.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1361, end=1371, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1810</td>\n",
       "      <td>pescio inmobiliaria</td>\n",
       "      <td>san_miguel</td>\n",
       "      <td>departamento en alquiler en conesa 960</td>\n",
       "      <td>2022-04-26</td>\n",
       "      <td>properati.com.ar/detalle/4g96q_alquiler_depart...</td>\n",
       "      <td>buenos aires ampliado</td>\n",
       "      <td>arg</td>\n",
       "      <td>excelente mono ambiente en alquiler ubicado so...</td>\n",
       "      <td>35000.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['1ambiente', '1bano', '32 m²totales']</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "      <td>6320</td>\n",
       "      <td>35000.0</td>\n",
       "      <td>1093.750000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>hetero</td>\n",
       "      <td>neutral</td>\n",
       "      <td>Manuel</td>\n",
       "      <td>j.fmanuel.rodriguez@gmail.com</td>\n",
       "      <td>Luis</td>\n",
       "      <td>Belén</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Buenos días, mi nombre es Manuel, junto a mi p...</td>\n",
       "      <td>Manuel y Belén.</td>\n",
       "      <td>Código 6320</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2624</td>\n",
       "      <td>Hiciste una consulta por la propiedad Conesa 960</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com.ar&gt;</td>\n",
       "      <td>j.fmanuel.rodriguez@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 04 May 2022 19:21:54 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>180908592af9b9da</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>arg</td>\n",
       "      <td>343.0</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-05-04</td>\n",
       "      <td>61.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1272, end=1282, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2018</td>\n",
       "      <td>heredia</td>\n",
       "      <td>vicente_lopez</td>\n",
       "      <td>departamento en alquiler en sanchez de bustama...</td>\n",
       "      <td>2022-02-18</td>\n",
       "      <td>properati.com.ar/detalle/4adue_alquiler_depart...</td>\n",
       "      <td>buenos aires ampliado</td>\n",
       "      <td>arg</td>\n",
       "      <td>edificio de 9 pisos, 4 departamentos por piso,...</td>\n",
       "      <td>40000.0</td>\n",
       "      <td>$</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "      <td>194</td>\n",
       "      <td>40000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>hetero</td>\n",
       "      <td>high</td>\n",
       "      <td>Manuel</td>\n",
       "      <td>rodrigue.z.manuel.w@gmail.com</td>\n",
       "      <td>Luis</td>\n",
       "      <td>Florencia</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Hola, somos una pareja interesada en alquilar ...</td>\n",
       "      <td>Manuel y Florencia</td>\n",
       "      <td>Código 194</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1670</td>\n",
       "      <td>Hiciste una consulta por la propiedad Sanchez ...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com.ar&gt;</td>\n",
       "      <td>rodrigue.z.manuel.w@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 04 May 2022 20:27:02 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18090c13b3494018</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>arg</td>\n",
       "      <td>271.0</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-05-04</td>\n",
       "      <td>87.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1271, end=1280, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2086</td>\n",
       "      <td>nbh   negocios bien hechos</td>\n",
       "      <td>bogota</td>\n",
       "      <td>apartamento en arriendo en chapinero</td>\n",
       "      <td>2022-03-15</td>\n",
       "      <td>properati.com.co/detalle/2ozax_arriendo_aparta...</td>\n",
       "      <td>bogota ampliado</td>\n",
       "      <td>col</td>\n",
       "      <td>se arrienda apartamento en el barrio antiguo c...</td>\n",
       "      <td>2282000.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['3habitaciones', '2banos', '90 m²totales']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>a359</td>\n",
       "      <td>2282000.0</td>\n",
       "      <td>25355.554688</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>hetero</td>\n",
       "      <td>high</td>\n",
       "      <td>José</td>\n",
       "      <td>jose.d.rodriguez.w@gmail.com</td>\n",
       "      <td>Juan</td>\n",
       "      <td>María</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Hola, somos una pareja interesada en arrendar ...</td>\n",
       "      <td>José y María</td>\n",
       "      <td>Código a359</td>\n",
       "      <td>12345.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3982</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartame...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>jose.d.rodriguez.w@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 04 May 2022 20:54:30 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18090da5ef1d69e6</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>191.0</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-05-04</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1301, end=1311, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2574</td>\n",
       "      <td>inmobiliaria la heredad sas</td>\n",
       "      <td>copacabana</td>\n",
       "      <td>apartamento en arriendo en copacabana</td>\n",
       "      <td>2021-10-29</td>\n",
       "      <td>properati.com.co/detalle/2hsag_arriendo_aparta...</td>\n",
       "      <td>medellin ampliado</td>\n",
       "      <td>col</td>\n",
       "      <td>hermoso apartamento de 70mts en el sector de c...</td>\n",
       "      <td>1175000.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['3habitaciones', '2banos', '70 m²totales']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9842</td>\n",
       "      <td>1175000.0</td>\n",
       "      <td>16785.714844</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>hetero</td>\n",
       "      <td>neutral</td>\n",
       "      <td>Carlos</td>\n",
       "      <td>carlosm.z.gonzalez@gmail.com</td>\n",
       "      <td>Juan</td>\n",
       "      <td>Luz</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Hola, somos una pareja interesada en arrendar ...</td>\n",
       "      <td>Carlos y Luz</td>\n",
       "      <td>Código 9842</td>\n",
       "      <td>12345.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>33.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2770</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartame...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>carlosm.z.gonzalez@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 04 May 2022 21:13:51 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18090ec18a7b6fd1</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-05-04</td>\n",
       "      <td>23.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1209, end=1219, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2787</td>\n",
       "      <td>vivir bien propiedad raiz s.a.s</td>\n",
       "      <td>sabaneta</td>\n",
       "      <td>apartamento en arriendo en sabaneta</td>\n",
       "      <td>2022-04-30</td>\n",
       "      <td>properati.com.co/detalle/2rusm_arriendo_aparta...</td>\n",
       "      <td>medellin ampliado</td>\n",
       "      <td>col</td>\n",
       "      <td>arrienda apto de 3 alcobas cerca al mayorca y ...</td>\n",
       "      <td>1350000.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['3habitaciones', '20banos', '60 m²totales']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1252</td>\n",
       "      <td>1350000.0</td>\n",
       "      <td>22500.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>hetero</td>\n",
       "      <td>neutral</td>\n",
       "      <td>Carlos</td>\n",
       "      <td>carlosm.z.gonzalez@gmail.com</td>\n",
       "      <td>Juan</td>\n",
       "      <td>Mónica</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Buenos días, mi nombre es Carlos, junto a mi p...</td>\n",
       "      <td>Carlos y Mónica.</td>\n",
       "      <td>Código 1252</td>\n",
       "      <td>12345.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2669</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartame...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>carlosm.z.gonzalez@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 04 May 2022 22:25:28 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18090ec18a7b6fd1</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-05-04</td>\n",
       "      <td>35.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1250, end=1260, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2263</td>\n",
       "      <td>constructora inmobiliaria gallego asocia</td>\n",
       "      <td>bogota</td>\n",
       "      <td>apartamento en arriendo en el salitre</td>\n",
       "      <td>2021-11-12</td>\n",
       "      <td>properati.com.co/detalle/2i64z_arriendo_aparta...</td>\n",
       "      <td>bogota ampliado</td>\n",
       "      <td>col</td>\n",
       "      <td>se arrienda amplio e iluminado apartamento ubi...</td>\n",
       "      <td>1700000.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['2habitaciones', '2banos', '55 m²totales']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>a754</td>\n",
       "      <td>1700000.0</td>\n",
       "      <td>30909.091797</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>trans</td>\n",
       "      <td>neutral</td>\n",
       "      <td>José</td>\n",
       "      <td>w.jose.rodriguezp@gmail.com</td>\n",
       "      <td>Juan</td>\n",
       "      <td>Ana</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Buenos días, mi nombre es José, junto a mi par...</td>\n",
       "      <td>José y Ana.</td>\n",
       "      <td>Código a754</td>\n",
       "      <td>12345.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3663</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartame...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>w.jose.rodriguezp@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 04 May 2022 21:31:26 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18090fc2a3027fff</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>33.0</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-05-04</td>\n",
       "      <td>2.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1383, end=1393, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2388</td>\n",
       "      <td>luque ospina y cia sa</td>\n",
       "      <td>bogota</td>\n",
       "      <td>apartamento en arriendo en el retiro</td>\n",
       "      <td>2022-04-29</td>\n",
       "      <td>properati.com.co/detalle/2rs1e_arriendo_aparta...</td>\n",
       "      <td>bogota ampliado</td>\n",
       "      <td>col</td>\n",
       "      <td>luque ospina ofrece en arriendo apartamento en...</td>\n",
       "      <td>1103000.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['1habitacion', '1bano', '36 m²totales']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>a587</td>\n",
       "      <td>1103000.0</td>\n",
       "      <td>30638.888672</td>\n",
       "      <td>1.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>trans</td>\n",
       "      <td>neutral</td>\n",
       "      <td>José</td>\n",
       "      <td>w.joserodriguezp@gmail.com</td>\n",
       "      <td>Juan</td>\n",
       "      <td>María</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Hola, somos una pareja interesada en arrendar ...</td>\n",
       "      <td>José y María (ella es trans)</td>\n",
       "      <td>Código a587</td>\n",
       "      <td>12345.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3654</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartame...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>w.joserodriguezp@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 04 May 2022 22:05:48 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18090fc2a3027fff</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>24.0</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-05-04</td>\n",
       "      <td>3.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1263, end=1273, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2115</td>\n",
       "      <td>espacio inmobiliario &amp; cia ltda</td>\n",
       "      <td>soacha</td>\n",
       "      <td>apartamento en arriendo en soacha</td>\n",
       "      <td>2022-03-15</td>\n",
       "      <td>properati.com.co/detalle/2oz2m_arriendo_aparta...</td>\n",
       "      <td>bogota ampliado</td>\n",
       "      <td>col</td>\n",
       "      <td>apartamento en 2 piso exterior, 44mtr2, 2 habi...</td>\n",
       "      <td>470000.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['2habitaciones', '1bano']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>a300</td>\n",
       "      <td>470000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>hetero</td>\n",
       "      <td>neutral</td>\n",
       "      <td>Carlos</td>\n",
       "      <td>carlos.m.zgonzalez@gmail.com</td>\n",
       "      <td>Juan</td>\n",
       "      <td>Ana</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Buenos días, mi nombre es Carlos, junto a mi p...</td>\n",
       "      <td>Carlos y Ana.</td>\n",
       "      <td>Código a300</td>\n",
       "      <td>12345.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2778</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartame...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>carlos.m.zgonzalez@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 04 May 2022 20:58:59 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18090de7613854dd</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-05-04</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1290, end=1300, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2286</td>\n",
       "      <td>espacio inmobiliario &amp; cia ltda</td>\n",
       "      <td>bogota</td>\n",
       "      <td>apartamento en arriendo en usaquen</td>\n",
       "      <td>2022-04-19</td>\n",
       "      <td>properati.com.co/detalle/2qsqi_arriendo_aparta...</td>\n",
       "      <td>bogota ampliado</td>\n",
       "      <td>col</td>\n",
       "      <td>apartamento en primer piso, totalmente remodel...</td>\n",
       "      <td>1102000.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['2habitaciones', '1bano']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>a299</td>\n",
       "      <td>1102000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>hetero</td>\n",
       "      <td>neutral</td>\n",
       "      <td>Carlos</td>\n",
       "      <td>carlos.m.zgonzalez@gmail.com</td>\n",
       "      <td>Luis</td>\n",
       "      <td>Ana</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Buenos días, mi nombre es Carlos, junto a mi p...</td>\n",
       "      <td>Carlos y Ana.</td>\n",
       "      <td>Código a299</td>\n",
       "      <td>12345.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2729</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartame...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>carlos.m.zgonzalez@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 04 May 2022 21:44:37 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18091083f8579abb</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-05-04</td>\n",
       "      <td>5.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1314, end=1324, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2634</td>\n",
       "      <td>vivir bien propiedad raiz s.a.s</td>\n",
       "      <td>envigado</td>\n",
       "      <td>apartamento en arriendo en envigado</td>\n",
       "      <td>2022-05-02</td>\n",
       "      <td>properati.com.co/detalle/2rw61_arriendo_aparta...</td>\n",
       "      <td>medellin ampliado</td>\n",
       "      <td>col</td>\n",
       "      <td>arrienda hermoso apto en envigado sector el sa...</td>\n",
       "      <td>2800000.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['3habitaciones', '2banos', '92 m²totales']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1260</td>\n",
       "      <td>2800000.0</td>\n",
       "      <td>30434.783203</td>\n",
       "      <td>1.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>hetero</td>\n",
       "      <td>neutral</td>\n",
       "      <td>Carlos</td>\n",
       "      <td>carlos.m.zgonzalez@gmail.com</td>\n",
       "      <td>Luis</td>\n",
       "      <td>Mónica</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Buenos días, mi nombre es Carlos, junto a mi p...</td>\n",
       "      <td>Carlos y Mónica.</td>\n",
       "      <td>Código 1260</td>\n",
       "      <td>12345.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2749</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartame...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>carlos.m.zgonzalez@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 04 May 2022 21:26:06 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18090ec18a7b6fd1</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-05-04</td>\n",
       "      <td>22.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1241, end=1251, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2291</td>\n",
       "      <td>evaluaciones inmobiliarias</td>\n",
       "      <td>bogota</td>\n",
       "      <td>apartamento en arriendo en cedritos</td>\n",
       "      <td>2022-03-20</td>\n",
       "      <td>properati.com.co/detalle/2p7qo_arriendo_aparta...</td>\n",
       "      <td>bogota ampliado</td>\n",
       "      <td>col</td>\n",
       "      <td>se alquila apto full amoblado en bogota  la so...</td>\n",
       "      <td>2400000.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['1habitacion', '1bano']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>a564</td>\n",
       "      <td>2400000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>hetero</td>\n",
       "      <td>high</td>\n",
       "      <td>José</td>\n",
       "      <td>josedrodriguez.w@gmail.com</td>\n",
       "      <td>Carlos</td>\n",
       "      <td>Luz</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Buenos días, mi nombre es José, junto a mi par...</td>\n",
       "      <td>José y Luz.</td>\n",
       "      <td>Código a564</td>\n",
       "      <td>12345.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3920</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartaes...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>josedrodriguez.w@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 04 May 2022 21:45:06 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1809108afb56453e</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>129.0</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-05-04</td>\n",
       "      <td>6.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1462, end=1472, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2355</td>\n",
       "      <td>inmoreinversiones</td>\n",
       "      <td>bogota</td>\n",
       "      <td>apartamento en arriendo en santa ana</td>\n",
       "      <td>2022-04-26</td>\n",
       "      <td>properati.com.co/detalle/2rajl_arriendo_aparta...</td>\n",
       "      <td>bogota ampliado</td>\n",
       "      <td>col</td>\n",
       "      <td>en venta y renta hermoso apartamento con excel...</td>\n",
       "      <td>2800000.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['4habitaciones', '3banos', '97 m²totales']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>v55</td>\n",
       "      <td>2800000.0</td>\n",
       "      <td>28865.978516</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>hetero</td>\n",
       "      <td>high</td>\n",
       "      <td>José</td>\n",
       "      <td>josedrodriguez.w@gmail.com</td>\n",
       "      <td>Juan</td>\n",
       "      <td>Mónica</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Buenos días, mi nombre es José, junto a mi par...</td>\n",
       "      <td>José y Mónica.</td>\n",
       "      <td>Código v55</td>\n",
       "      <td>12345.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3906</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartame...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>josedrodriguez.w@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 04 May 2022 21:52:19 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18090da5ef1d69e6</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>115.0</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-05-04</td>\n",
       "      <td>9.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1375, end=1384, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2667</td>\n",
       "      <td>santa maria y asociados sas</td>\n",
       "      <td>itagui</td>\n",
       "      <td>apartamento en arriendo en itagui</td>\n",
       "      <td>2022-04-28</td>\n",
       "      <td>properati.com.co/detalle/2q2lf_arriendo_aparta...</td>\n",
       "      <td>medellin ampliado</td>\n",
       "      <td>col</td>\n",
       "      <td>arrienda apto en unidad cerrada en itagui de 3...</td>\n",
       "      <td>1300000.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['3habitaciones', '2banos', '60 m²totales']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1240</td>\n",
       "      <td>1300000.0</td>\n",
       "      <td>21666.666016</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>hetero</td>\n",
       "      <td>high</td>\n",
       "      <td>José</td>\n",
       "      <td>josedrodriguez.w@gmail.com</td>\n",
       "      <td>Carlos</td>\n",
       "      <td>María</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Buenos días, mi nombre es José, junto a mi par...</td>\n",
       "      <td>José y María.</td>\n",
       "      <td>Código 1240</td>\n",
       "      <td>12345.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3928</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartame...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>josedrodriguez.w@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 04 May 2022 21:33:16 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18090fddb7ecf212</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>137.0</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-05-04</td>\n",
       "      <td>27.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1352, end=1362, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3052</td>\n",
       "      <td>century 21 imperial</td>\n",
       "      <td>quito</td>\n",
       "      <td>departamento en alquiler en alonso de torres y...</td>\n",
       "      <td>2022-04-04</td>\n",
       "      <td>properati.com.ec/detalle/egfk_alquiler_departa...</td>\n",
       "      <td>quito ampliado</td>\n",
       "      <td>ecu</td>\n",
       "      <td>rento departamento de 2 habitaciones   c. c. e...</td>\n",
       "      <td>550.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['2habitaciones', '2banos']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6216</td>\n",
       "      <td>550.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>hetero</td>\n",
       "      <td>neutral</td>\n",
       "      <td>Luis</td>\n",
       "      <td>luis.czambrano.r@gmail.com</td>\n",
       "      <td>Juan</td>\n",
       "      <td>Diana</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Buenos días, mi nombre es Luis, junto a mi par...</td>\n",
       "      <td>Luis y Diana.</td>\n",
       "      <td>Código 6216</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4347</td>\n",
       "      <td>Hiciste una consulta por la propiedad Alonso D...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>luis.czambrano.r@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 04 May 2022 19:50:35 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>180909fd7bac0c30</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>ecu</td>\n",
       "      <td>60.0</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-05-04</td>\n",
       "      <td>10.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1295, end=1305, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2951</td>\n",
       "      <td>century 21 innovation</td>\n",
       "      <td>guayaquil</td>\n",
       "      <td>departamento en alquiler en las cumbres</td>\n",
       "      <td>2022-04-12</td>\n",
       "      <td>properati.com.ec/detalle/eiv7_alquiler_departa...</td>\n",
       "      <td>guayaquil ampliado</td>\n",
       "      <td>ecu</td>\n",
       "      <td>alquilo moderno apartamento en torres del jard...</td>\n",
       "      <td>680.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['3habitaciones', '2banos']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6170</td>\n",
       "      <td>680.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>homo</td>\n",
       "      <td>high</td>\n",
       "      <td>Luis</td>\n",
       "      <td>luism.zambrano.j@gmail.com</td>\n",
       "      <td>José</td>\n",
       "      <td></td>\n",
       "      <td>1.0</td>\n",
       "      <td>Buenos días, mi nombre es Luis, junto a mi par...</td>\n",
       "      <td>Luis y José.</td>\n",
       "      <td>Código 6170</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3726</td>\n",
       "      <td>Hiciste una consulta por la propiedad Las Cumbres</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>luism.zambrano.j@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 04 May 2022 19:28:24 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>180908b8cf5ae6bb</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>ecu</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-05-04</td>\n",
       "      <td>2.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1335, end=1345, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    index_x                              inmobiliaria        municipio  \\\n",
       "19      719                                   heredia             caba   \n",
       "2      1360                        amadeo propiedades  lomas_de_zamora   \n",
       "10      943                      raices puerto madero             caba   \n",
       "2      1415       paula di gaeta estudio inmobiliario  lomas_de_zamora   \n",
       "27     1810                       pescio inmobiliaria       san_miguel   \n",
       "10     2018                                   heredia    vicente_lopez   \n",
       "36     2086                nbh   negocios bien hechos           bogota   \n",
       "33     2574               inmobiliaria la heredad sas       copacabana   \n",
       "7      2787           vivir bien propiedad raiz s.a.s         sabaneta   \n",
       "2      2263  constructora inmobiliaria gallego asocia           bogota   \n",
       "1      2388                     luque ospina y cia sa           bogota   \n",
       "31     2115           espacio inmobiliario & cia ltda           soacha   \n",
       "22     2286           espacio inmobiliario & cia ltda           bogota   \n",
       "27     2634           vivir bien propiedad raiz s.a.s         envigado   \n",
       "22     2291                evaluaciones inmobiliarias           bogota   \n",
       "20     2355                         inmoreinversiones           bogota   \n",
       "25     2667               santa maria y asociados sas           itagui   \n",
       "8      3052                       century 21 imperial            quito   \n",
       "1      2951                     century 21 innovation        guayaquil   \n",
       "\n",
       "                                               nombre      fecha  \\\n",
       "19            departamento en alquiler en neuquen 602 2022-02-18   \n",
       "2   departamento en alquiler en hipolito yrigoyen ... 2022-01-11   \n",
       "10           departamento en alquiler en florida 1065 2021-09-12   \n",
       "2   departamento en alquiler en fray mamerto esqui... 2022-04-26   \n",
       "27             departamento en alquiler en conesa 960 2022-04-26   \n",
       "10  departamento en alquiler en sanchez de bustama... 2022-02-18   \n",
       "36               apartamento en arriendo en chapinero 2022-03-15   \n",
       "33              apartamento en arriendo en copacabana 2021-10-29   \n",
       "7                 apartamento en arriendo en sabaneta 2022-04-30   \n",
       "2               apartamento en arriendo en el salitre 2021-11-12   \n",
       "1                apartamento en arriendo en el retiro 2022-04-29   \n",
       "31                  apartamento en arriendo en soacha 2022-03-15   \n",
       "22                 apartamento en arriendo en usaquen 2022-04-19   \n",
       "27                apartamento en arriendo en envigado 2022-05-02   \n",
       "22                apartamento en arriendo en cedritos 2022-03-20   \n",
       "20               apartamento en arriendo en santa ana 2022-04-26   \n",
       "25                  apartamento en arriendo en itagui 2022-04-28   \n",
       "8   departamento en alquiler en alonso de torres y... 2022-04-04   \n",
       "1             departamento en alquiler en las cumbres 2022-04-12   \n",
       "\n",
       "                                                 link                 ciudad  \\\n",
       "19  properati.com.ar/detalle/4ae45_alquiler_depart...  buenos aires ampliado   \n",
       "2   properati.com.ar/detalle/47suq_alquiler_depart...  buenos aires ampliado   \n",
       "10  properati.com.ar/detalle/3z6bc_alquiler_depart...  buenos aires ampliado   \n",
       "2   properati.com.ar/detalle/4g9js_alquiler_depart...  buenos aires ampliado   \n",
       "27  properati.com.ar/detalle/4g96q_alquiler_depart...  buenos aires ampliado   \n",
       "10  properati.com.ar/detalle/4adue_alquiler_depart...  buenos aires ampliado   \n",
       "36  properati.com.co/detalle/2ozax_arriendo_aparta...        bogota ampliado   \n",
       "33  properati.com.co/detalle/2hsag_arriendo_aparta...      medellin ampliado   \n",
       "7   properati.com.co/detalle/2rusm_arriendo_aparta...      medellin ampliado   \n",
       "2   properati.com.co/detalle/2i64z_arriendo_aparta...        bogota ampliado   \n",
       "1   properati.com.co/detalle/2rs1e_arriendo_aparta...        bogota ampliado   \n",
       "31  properati.com.co/detalle/2oz2m_arriendo_aparta...        bogota ampliado   \n",
       "22  properati.com.co/detalle/2qsqi_arriendo_aparta...        bogota ampliado   \n",
       "27  properati.com.co/detalle/2rw61_arriendo_aparta...      medellin ampliado   \n",
       "22  properati.com.co/detalle/2p7qo_arriendo_aparta...        bogota ampliado   \n",
       "20  properati.com.co/detalle/2rajl_arriendo_aparta...        bogota ampliado   \n",
       "25  properati.com.co/detalle/2q2lf_arriendo_aparta...      medellin ampliado   \n",
       "8   properati.com.ec/detalle/egfk_alquiler_departa...         quito ampliado   \n",
       "1   properati.com.ec/detalle/eiv7_alquiler_departa...     guayaquil ampliado   \n",
       "\n",
       "   pais_x                                        descripcion     precio  \\\n",
       "19    arg  edificio de 14 pisos, 5 departamentos por piso...    32000.0   \n",
       "2     arg  departamento 2 amb, ubicado en hipolito yrigoy...    26000.0   \n",
       "10    arg  se trata de un departamento en el edificio kav...      900.0   \n",
       "2     arg  departamento de dos ambientes opcional con coc...    22000.0   \n",
       "27    arg  excelente mono ambiente en alquiler ubicado so...    35000.0   \n",
       "10    arg  edificio de 9 pisos, 4 departamentos por piso,...    40000.0   \n",
       "36    col  se arrienda apartamento en el barrio antiguo c...  2282000.0   \n",
       "33    col  hermoso apartamento de 70mts en el sector de c...  1175000.0   \n",
       "7     col  arrienda apto de 3 alcobas cerca al mayorca y ...  1350000.0   \n",
       "2     col  se arrienda amplio e iluminado apartamento ubi...  1700000.0   \n",
       "1     col  luque ospina ofrece en arriendo apartamento en...  1103000.0   \n",
       "31    col  apartamento en 2 piso exterior, 44mtr2, 2 habi...   470000.0   \n",
       "22    col  apartamento en primer piso, totalmente remodel...  1102000.0   \n",
       "27    col  arrienda hermoso apto en envigado sector el sa...  2800000.0   \n",
       "22    col  se alquila apto full amoblado en bogota  la so...  2400000.0   \n",
       "20    col  en venta y renta hermoso apartamento con excel...  2800000.0   \n",
       "25    col  arrienda apto en unidad cerrada en itagui de 3...  1300000.0   \n",
       "8     ecu  rento departamento de 2 habitaciones   c. c. e...      550.0   \n",
       "1     ecu  alquilo moderno apartamento en torres del jard...      680.0   \n",
       "\n",
       "   moneda                               caracteristicas  ambientes  \\\n",
       "19      $                                                      NaN   \n",
       "2       $       ['2ambientes', '1bano', '26 m²totales']        2.0   \n",
       "10    usd                                                      NaN   \n",
       "2       $       ['2ambientes', '1bano', '30 m²totales']        2.0   \n",
       "27      $        ['1ambiente', '1bano', '32 m²totales']        1.0   \n",
       "10      $                                                      NaN   \n",
       "36      $   ['3habitaciones', '2banos', '90 m²totales']        NaN   \n",
       "33      $   ['3habitaciones', '2banos', '70 m²totales']        NaN   \n",
       "7       $  ['3habitaciones', '20banos', '60 m²totales']        NaN   \n",
       "2       $   ['2habitaciones', '2banos', '55 m²totales']        NaN   \n",
       "1       $      ['1habitacion', '1bano', '36 m²totales']        NaN   \n",
       "31      $                    ['2habitaciones', '1bano']        NaN   \n",
       "22      $                    ['2habitaciones', '1bano']        NaN   \n",
       "27      $   ['3habitaciones', '2banos', '92 m²totales']        NaN   \n",
       "22      $                      ['1habitacion', '1bano']        NaN   \n",
       "20      $   ['4habitaciones', '3banos', '97 m²totales']        NaN   \n",
       "25      $   ['3habitaciones', '2banos', '60 m²totales']        NaN   \n",
       "8       $                   ['2habitaciones', '2banos']        NaN   \n",
       "1       $                   ['3habitaciones', '2banos']        NaN   \n",
       "\n",
       "    habitaciones  banos  m2_totales  m2_cubiertos cocheras    id  \\\n",
       "19           NaN    NaN         NaN           NaN            150   \n",
       "2            NaN    1.0        26.0           NaN           5389   \n",
       "10           NaN    NaN         NaN           NaN           1373   \n",
       "2            NaN    1.0        30.0           NaN           3891   \n",
       "27           NaN    1.0        32.0           NaN           6320   \n",
       "10           NaN    NaN         NaN           NaN            194   \n",
       "36           3.0    2.0        90.0           NaN      NaN  a359   \n",
       "33           3.0    2.0        70.0           NaN      NaN  9842   \n",
       "7            3.0   20.0        60.0           NaN      NaN  1252   \n",
       "2            2.0    2.0        55.0           NaN      NaN  a754   \n",
       "1            1.0    1.0        36.0           NaN      NaN  a587   \n",
       "31           2.0    1.0         NaN           NaN      NaN  a300   \n",
       "22           2.0    1.0         NaN           NaN      NaN  a299   \n",
       "27           3.0    2.0        92.0           NaN      NaN  1260   \n",
       "22           1.0    1.0         NaN           NaN      NaN  a564   \n",
       "20           4.0    3.0        97.0           NaN      NaN   v55   \n",
       "25           3.0    2.0        60.0           NaN      NaN  1240   \n",
       "8            2.0    2.0         NaN           NaN      NaN  6216   \n",
       "1            3.0    2.0         NaN           NaN      NaN  6170   \n",
       "\n",
       "    precio_local          p_m2  p_m2_above_mdn  n_adds  n_adds_above_mdn  \\\n",
       "19       32000.0           NaN             NaN     5.0               1.0   \n",
       "2        26000.0   1000.000000             0.0     2.0               0.0   \n",
       "10      179550.0           NaN             NaN     1.0               0.0   \n",
       "2        22000.0    733.333313             0.0     8.0               1.0   \n",
       "27       35000.0   1093.750000             0.0     3.0               1.0   \n",
       "10       40000.0           NaN             NaN     5.0               1.0   \n",
       "36     2282000.0  25355.554688             1.0     4.0               1.0   \n",
       "33     1175000.0  16785.714844             0.0    18.0               1.0   \n",
       "7      1350000.0  22500.000000             0.0    17.0               1.0   \n",
       "2      1700000.0  30909.091797             1.0    11.0               1.0   \n",
       "1      1103000.0  30638.888672             1.0    28.0               1.0   \n",
       "31      470000.0           NaN             NaN    17.0               1.0   \n",
       "22     1102000.0           NaN             NaN    17.0               1.0   \n",
       "27     2800000.0  30434.783203             1.0    17.0               1.0   \n",
       "22     2400000.0           NaN             NaN     1.0               0.0   \n",
       "20     2800000.0  28865.978516             1.0     3.0               1.0   \n",
       "25     1300000.0  21666.666016             0.0    16.0               1.0   \n",
       "8          550.0           NaN             NaN     4.0               0.0   \n",
       "1          680.0           NaN             NaN    14.0               1.0   \n",
       "\n",
       "    m2_above_mdn  common_name  capital treatment      ses male_name  \\\n",
       "19           NaN          2.0      1.0     trans  neutral    Manuel   \n",
       "2            0.0          2.0      0.0     trans  neutral    Manuel   \n",
       "10           NaN          1.0      1.0      homo  neutral     Pablo   \n",
       "2            0.0          2.0      0.0     trans  neutral     Pablo   \n",
       "27           0.0          2.0      0.0    hetero  neutral    Manuel   \n",
       "10           NaN          2.0      0.0    hetero     high    Manuel   \n",
       "36           1.0          1.0      1.0    hetero     high      José   \n",
       "33           0.0          6.0      0.0    hetero  neutral    Carlos   \n",
       "7            0.0          3.0      0.0    hetero  neutral    Carlos   \n",
       "2            0.0          1.0      1.0     trans  neutral      José   \n",
       "1            0.0          1.0      1.0     trans  neutral      José   \n",
       "31           NaN          3.0      0.0    hetero  neutral    Carlos   \n",
       "22           NaN          3.0      1.0    hetero  neutral    Carlos   \n",
       "27           1.0          3.0      0.0    hetero  neutral    Carlos   \n",
       "22           NaN          1.0      1.0    hetero     high      José   \n",
       "20           1.0          1.0      1.0    hetero     high      José   \n",
       "25           0.0          5.0      0.0    hetero     high      José   \n",
       "8            NaN          1.0      1.0    hetero  neutral      Luis   \n",
       "1            NaN          1.0      0.0      homo     high      Luis   \n",
       "\n",
       "                             mail male_couple female_couple  script  \\\n",
       "19  rodriguez.j.cmanuel@gmail.com        Luis         Belén     2.0   \n",
       "2   rodriguez.j.cmanuel@gmail.com       Pablo     Florencia     1.0   \n",
       "10       pablom.ngome.z@gmail.com      Manuel                   2.0   \n",
       "2        pablogome.zf.h@gmail.com        Luis         Laura     1.0   \n",
       "27  j.fmanuel.rodriguez@gmail.com        Luis         Belén     1.0   \n",
       "10  rodrigue.z.manuel.w@gmail.com        Luis     Florencia     2.0   \n",
       "36   jose.d.rodriguez.w@gmail.com        Juan         María     2.0   \n",
       "33   carlosm.z.gonzalez@gmail.com        Juan           Luz     2.0   \n",
       "7    carlosm.z.gonzalez@gmail.com        Juan        Mónica     1.0   \n",
       "2     w.jose.rodriguezp@gmail.com        Juan           Ana     1.0   \n",
       "1      w.joserodriguezp@gmail.com        Juan         María     2.0   \n",
       "31   carlos.m.zgonzalez@gmail.com        Juan           Ana     1.0   \n",
       "22   carlos.m.zgonzalez@gmail.com        Luis           Ana     1.0   \n",
       "27   carlos.m.zgonzalez@gmail.com        Luis        Mónica     1.0   \n",
       "22     josedrodriguez.w@gmail.com      Carlos           Luz     1.0   \n",
       "20     josedrodriguez.w@gmail.com        Juan        Mónica     1.0   \n",
       "25     josedrodriguez.w@gmail.com      Carlos         María     1.0   \n",
       "8      luis.czambrano.r@gmail.com        Juan         Diana     1.0   \n",
       "1      luism.zambrano.j@gmail.com        José                   1.0   \n",
       "\n",
       "                                        script_string  \\\n",
       "19  Hola, somos una pareja interesada en alquilar ...   \n",
       "2   Buenos días, mi nombre es Manuel, junto a mi p...   \n",
       "10  Hola, somos una pareja interesada en alquilar ...   \n",
       "2   Buenos días, mi nombre es Pablo, junto a mi pa...   \n",
       "27  Buenos días, mi nombre es Manuel, junto a mi p...   \n",
       "10  Hola, somos una pareja interesada en alquilar ...   \n",
       "36  Hola, somos una pareja interesada en arrendar ...   \n",
       "33  Hola, somos una pareja interesada en arrendar ...   \n",
       "7   Buenos días, mi nombre es Carlos, junto a mi p...   \n",
       "2   Buenos días, mi nombre es José, junto a mi par...   \n",
       "1   Hola, somos una pareja interesada en arrendar ...   \n",
       "31  Buenos días, mi nombre es Carlos, junto a mi p...   \n",
       "22  Buenos días, mi nombre es Carlos, junto a mi p...   \n",
       "27  Buenos días, mi nombre es Carlos, junto a mi p...   \n",
       "22  Buenos días, mi nombre es José, junto a mi par...   \n",
       "20  Buenos días, mi nombre es José, junto a mi par...   \n",
       "25  Buenos días, mi nombre es José, junto a mi par...   \n",
       "8   Buenos días, mi nombre es Luis, junto a mi par...   \n",
       "1   Buenos días, mi nombre es Luis, junto a mi par...   \n",
       "\n",
       "                   script_string_2 script_string_3  randomization_seed  \\\n",
       "19  Manuel y Belén (ella es trans)      Código 150                 2.0   \n",
       "2              Manuel y Florencia.     Código 5389                 2.0   \n",
       "10                  Pablo y Manuel     Código 1373                 2.0   \n",
       "2                   Pablo y Laura.     Código 3891                 2.0   \n",
       "27                 Manuel y Belén.     Código 6320                 2.0   \n",
       "10              Manuel y Florencia      Código 194                 2.0   \n",
       "36                    José y María     Código a359             12345.0   \n",
       "33                    Carlos y Luz     Código 9842             12345.0   \n",
       "7                 Carlos y Mónica.     Código 1252             12345.0   \n",
       "2                      José y Ana.     Código a754             12345.0   \n",
       "1     José y María (ella es trans)     Código a587             12345.0   \n",
       "31                   Carlos y Ana.     Código a300             12345.0   \n",
       "22                   Carlos y Ana.     Código a299             12345.0   \n",
       "27                Carlos y Mónica.     Código 1260             12345.0   \n",
       "22                     José y Luz.     Código a564             12345.0   \n",
       "20                  José y Mónica.      Código v55             12345.0   \n",
       "25                   José y María.     Código 1240             12345.0   \n",
       "8                    Luis y Diana.     Código 6216                 2.0   \n",
       "1                     Luis y José.     Código 6170                 2.0   \n",
       "\n",
       "   nombre_2  profesional  vivienda  n_adds_muni  n_adds_muni_above_mdn  \\\n",
       "19      NaN          NaN       NaN          NaN                    NaN   \n",
       "2       NaN          NaN       NaN          NaN                    NaN   \n",
       "10      NaN          NaN       NaN          NaN                    NaN   \n",
       "2       NaN          NaN       NaN          NaN                    NaN   \n",
       "27      NaN          NaN       NaN          NaN                    NaN   \n",
       "10      NaN          NaN       NaN          NaN                    NaN   \n",
       "36      NaN          NaN       NaN          NaN                    NaN   \n",
       "33      NaN          NaN       NaN          NaN                    NaN   \n",
       "7       NaN          NaN       NaN          NaN                    NaN   \n",
       "2       NaN          NaN       NaN          NaN                    NaN   \n",
       "1       NaN          NaN       NaN          NaN                    NaN   \n",
       "31      NaN          NaN       NaN          NaN                    NaN   \n",
       "22      NaN          NaN       NaN          NaN                    NaN   \n",
       "27      NaN          NaN       NaN          NaN                    NaN   \n",
       "22      NaN          NaN       NaN          NaN                    NaN   \n",
       "20      NaN          NaN       NaN          NaN                    NaN   \n",
       "25      NaN          NaN       NaN          NaN                    NaN   \n",
       "8       NaN          NaN       NaN          NaN                    NaN   \n",
       "1       NaN          NaN       NaN          NaN                    NaN   \n",
       "\n",
       "    random  index_rtas  match_confiab_x  match_step_x  Unnamed: 0  \\\n",
       "19     NaN        19.0            100.0           1.0        1214   \n",
       "2      NaN         2.0            100.0           1.0        1149   \n",
       "10     NaN        10.0            100.0           1.0        1539   \n",
       "2      NaN         2.0            100.0           1.0          42   \n",
       "27     NaN        27.0            100.0           1.0        2624   \n",
       "10     NaN        10.0            100.0           1.0        1670   \n",
       "36     NaN        36.0            100.0           1.0        3982   \n",
       "33     NaN        33.0            100.0           1.0        2770   \n",
       "7      NaN         7.0            100.0           1.0        2669   \n",
       "2      NaN         2.0            100.0           1.0        3663   \n",
       "1      NaN         1.0            100.0           1.0        3654   \n",
       "31     NaN        31.0            100.0           1.0        2778   \n",
       "22     NaN        22.0            100.0           1.0        2729   \n",
       "27     NaN        27.0            100.0           1.0        2749   \n",
       "22     NaN        22.0            100.0           1.0        3920   \n",
       "20     NaN        20.0            100.0           1.0        3906   \n",
       "25     NaN        25.0            100.0           1.0        3928   \n",
       "8      NaN         8.0            100.0           1.0        4347   \n",
       "1      NaN         1.0            100.0           1.0        3726   \n",
       "\n",
       "                                              subject  \\\n",
       "19  Hiciste una consulta por la propiedad Neuquen 602   \n",
       "2   Hiciste una consulta por la propiedad Hipolito...   \n",
       "10  Hiciste una consulta por la propiedad Florida ...   \n",
       "2   Hiciste una consulta por la propiedad Fray Mam...   \n",
       "27   Hiciste una consulta por la propiedad Conesa 960   \n",
       "10  Hiciste una consulta por la propiedad Sanchez ...   \n",
       "36  Hiciste una consulta por la propiedad Apartame...   \n",
       "33  Hiciste una consulta por la propiedad Apartame...   \n",
       "7   Hiciste una consulta por la propiedad Apartame...   \n",
       "2   Hiciste una consulta por la propiedad Apartame...   \n",
       "1   Hiciste una consulta por la propiedad Apartame...   \n",
       "31  Hiciste una consulta por la propiedad Apartame...   \n",
       "22  Hiciste una consulta por la propiedad Apartame...   \n",
       "27  Hiciste una consulta por la propiedad Apartame...   \n",
       "22  Hiciste una consulta por la propiedad Apartaes...   \n",
       "20  Hiciste una consulta por la propiedad Apartame...   \n",
       "25  Hiciste una consulta por la propiedad Apartame...   \n",
       "8   Hiciste una consulta por la propiedad Alonso D...   \n",
       "1   Hiciste una consulta por la propiedad Las Cumbres   \n",
       "\n",
       "                                             from  \\\n",
       "19  Properati <contacts@mailing.properati.com.ar>   \n",
       "2   Properati <contacts@mailing.properati.com.ar>   \n",
       "10  Properati <contacts@mailing.properati.com.ar>   \n",
       "2   Properati <contacts@mailing.properati.com.ar>   \n",
       "27  Properati <contacts@mailing.properati.com.ar>   \n",
       "10  Properati <contacts@mailing.properati.com.ar>   \n",
       "36     Properati <contacts@mailing.properati.com>   \n",
       "33     Properati <contacts@mailing.properati.com>   \n",
       "7      Properati <contacts@mailing.properati.com>   \n",
       "2      Properati <contacts@mailing.properati.com>   \n",
       "1      Properati <contacts@mailing.properati.com>   \n",
       "31     Properati <contacts@mailing.properati.com>   \n",
       "22     Properati <contacts@mailing.properati.com>   \n",
       "27     Properati <contacts@mailing.properati.com>   \n",
       "22     Properati <contacts@mailing.properati.com>   \n",
       "20     Properati <contacts@mailing.properati.com>   \n",
       "25     Properati <contacts@mailing.properati.com>   \n",
       "8      Properati <contacts@mailing.properati.com>   \n",
       "1      Properati <contacts@mailing.properati.com>   \n",
       "\n",
       "                               to  \\\n",
       "19  rodriguez.j.cmanuel@gmail.com   \n",
       "2   rodriguez.j.cmanuel@gmail.com   \n",
       "10       pablom.ngome.z@gmail.com   \n",
       "2        pablogome.zf.h@gmail.com   \n",
       "27  j.fmanuel.rodriguez@gmail.com   \n",
       "10  rodrigue.z.manuel.w@gmail.com   \n",
       "36   jose.d.rodriguez.w@gmail.com   \n",
       "33   carlosm.z.gonzalez@gmail.com   \n",
       "7    carlosm.z.gonzalez@gmail.com   \n",
       "2     w.jose.rodriguezp@gmail.com   \n",
       "1      w.joserodriguezp@gmail.com   \n",
       "31   carlos.m.zgonzalez@gmail.com   \n",
       "22   carlos.m.zgonzalez@gmail.com   \n",
       "27   carlos.m.zgonzalez@gmail.com   \n",
       "22     josedrodriguez.w@gmail.com   \n",
       "20     josedrodriguez.w@gmail.com   \n",
       "25     josedrodriguez.w@gmail.com   \n",
       "8      luis.czambrano.r@gmail.com   \n",
       "1      luism.zambrano.j@gmail.com   \n",
       "\n",
       "                                                 body  \\\n",
       "19  [<p>-- SOLICITUD DE ENTREVISTA --_x000D_\\n_x00...   \n",
       "2   [<p>-- SOLICITUD DE ENTREVISTA --_x000D_\\n_x00...   \n",
       "10  [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "2   [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "27  [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "10  [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "36  [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "33  [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "7   [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "2   [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "1   [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "31  [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "22  [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "27  [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "22  [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "20  [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "25  [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "8   [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "1   [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "\n",
       "                                     date  cc         thread_id  \\\n",
       "19  Wed, 04 May 2022 17:25:48 +0000 (UTC) NaN  180901b4bb14d042   \n",
       "2   Wed, 04 May 2022 19:52:48 +0000 (UTC) NaN  18090a1dda3ef7c7   \n",
       "10  Wed, 04 May 2022 17:43:55 +0000 (UTC) NaN  180902be574364f4   \n",
       "2   Wed, 04 May 2022 20:09:32 +0000 (UTC) NaN  18090b137e0bb927   \n",
       "27  Wed, 04 May 2022 19:21:54 +0000 (UTC) NaN  180908592af9b9da   \n",
       "10  Wed, 04 May 2022 20:27:02 +0000 (UTC) NaN  18090c13b3494018   \n",
       "36  Wed, 04 May 2022 20:54:30 +0000 (UTC) NaN  18090da5ef1d69e6   \n",
       "33  Wed, 04 May 2022 21:13:51 +0000 (UTC) NaN  18090ec18a7b6fd1   \n",
       "7   Wed, 04 May 2022 22:25:28 +0000 (UTC) NaN  18090ec18a7b6fd1   \n",
       "2   Wed, 04 May 2022 21:31:26 +0000 (UTC) NaN  18090fc2a3027fff   \n",
       "1   Wed, 04 May 2022 22:05:48 +0000 (UTC) NaN  18090fc2a3027fff   \n",
       "31  Wed, 04 May 2022 20:58:59 +0000 (UTC) NaN  18090de7613854dd   \n",
       "22  Wed, 04 May 2022 21:44:37 +0000 (UTC) NaN  18091083f8579abb   \n",
       "27  Wed, 04 May 2022 21:26:06 +0000 (UTC) NaN  18090ec18a7b6fd1   \n",
       "22  Wed, 04 May 2022 21:45:06 +0000 (UTC) NaN  1809108afb56453e   \n",
       "20  Wed, 04 May 2022 21:52:19 +0000 (UTC) NaN  18090da5ef1d69e6   \n",
       "25  Wed, 04 May 2022 21:33:16 +0000 (UTC) NaN  18090fddb7ecf212   \n",
       "8   Wed, 04 May 2022 19:50:35 +0000 (UTC) NaN  180909fd7bac0c30   \n",
       "1   Wed, 04 May 2022 19:28:24 +0000 (UTC) NaN  180908b8cf5ae6bb   \n",
       "\n",
       "                 mimeType pais_y  index_y  conf_envio  date_clean  \\\n",
       "19  multipart/alternative    arg    141.0        True  2022-05-04   \n",
       "2   multipart/alternative    arg     76.0        True  2022-05-04   \n",
       "10  multipart/alternative    arg      NaN        True  2022-05-04   \n",
       "2   multipart/alternative    arg     42.0        True  2022-05-04   \n",
       "27  multipart/alternative    arg    343.0        True  2022-05-04   \n",
       "10  multipart/alternative    arg    271.0        True  2022-05-04   \n",
       "36  multipart/alternative    col    191.0        True  2022-05-04   \n",
       "33  multipart/alternative    col      NaN        True  2022-05-04   \n",
       "7   multipart/alternative    col      NaN        True  2022-05-04   \n",
       "2   multipart/alternative    col     33.0        True  2022-05-04   \n",
       "1   multipart/alternative    col     24.0        True  2022-05-04   \n",
       "31  multipart/alternative    col      NaN        True  2022-05-04   \n",
       "22  multipart/alternative    col      NaN        True  2022-05-04   \n",
       "27  multipart/alternative    col      NaN        True  2022-05-04   \n",
       "22  multipart/alternative    col    129.0        True  2022-05-04   \n",
       "20  multipart/alternative    col    115.0        True  2022-05-04   \n",
       "25  multipart/alternative    col    137.0        True  2022-05-04   \n",
       "8   multipart/alternative    ecu     60.0        True  2022-05-04   \n",
       "1   multipart/alternative    ecu      NaN        True  2022-05-04   \n",
       "\n",
       "    index_scrap  match_confiab_y  match_step_y  \\\n",
       "19         16.0            100.0           1.0   \n",
       "2          24.0            100.0           1.0   \n",
       "10         18.0            100.0           1.0   \n",
       "2          17.0            100.0           1.0   \n",
       "27         61.0            100.0           1.0   \n",
       "10         87.0            100.0           1.0   \n",
       "36          0.0            100.0           1.0   \n",
       "33         23.0            100.0           1.0   \n",
       "7          35.0            100.0           1.0   \n",
       "2           2.0            100.0           1.0   \n",
       "1           3.0            100.0           1.0   \n",
       "31          0.0            100.0           1.0   \n",
       "22          5.0            100.0           1.0   \n",
       "27         22.0            100.0           1.0   \n",
       "22          6.0            100.0           1.0   \n",
       "20          9.0            100.0           1.0   \n",
       "25         27.0            100.0           1.0   \n",
       "8          10.0            100.0           1.0   \n",
       "1           2.0            100.0           1.0   \n",
       "\n",
       "                                         match_string match2_string _merge  \n",
       "19  [Match(start=1351, end=1360, dist=0, matched='...           nan   both  \n",
       "2   [Match(start=1533, end=1543, dist=0, matched='...           nan   both  \n",
       "10  [Match(start=1276, end=1286, dist=0, matched='...           nan   both  \n",
       "2   [Match(start=1361, end=1371, dist=0, matched='...           nan   both  \n",
       "27  [Match(start=1272, end=1282, dist=0, matched='...           nan   both  \n",
       "10  [Match(start=1271, end=1280, dist=0, matched='...           nan   both  \n",
       "36  [Match(start=1301, end=1311, dist=0, matched='...           nan   both  \n",
       "33  [Match(start=1209, end=1219, dist=0, matched='...           nan   both  \n",
       "7   [Match(start=1250, end=1260, dist=0, matched='...           nan   both  \n",
       "2   [Match(start=1383, end=1393, dist=0, matched='...           nan   both  \n",
       "1   [Match(start=1263, end=1273, dist=0, matched='...           nan   both  \n",
       "31  [Match(start=1290, end=1300, dist=0, matched='...           nan   both  \n",
       "22  [Match(start=1314, end=1324, dist=0, matched='...           nan   both  \n",
       "27  [Match(start=1241, end=1251, dist=0, matched='...           nan   both  \n",
       "22  [Match(start=1462, end=1472, dist=0, matched='...           nan   both  \n",
       "20  [Match(start=1375, end=1384, dist=0, matched='...           nan   both  \n",
       "25  [Match(start=1352, end=1362, dist=0, matched='...           nan   both  \n",
       "8   [Match(start=1295, end=1305, dist=0, matched='...           nan   both  \n",
       "1   [Match(start=1335, end=1345, dist=0, matched='...           nan   both  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#### TODO:\n",
    "# Verificar manualmente que estos estén bien. El id de properati es muy corto así que accidentalmente podría generar errores de matcheo.\n",
    "matched[matched.id.str.len()<5]"
   ]
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "89e0abca33cf4a51fed40e84035a9d07b9b47798c9ddd5755346d755ba15d037"
  },
  "kernelspec": {
   "display_name": "Python 3.10.0 64-bit",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}