01_match_confirmaciones_de_envio_ronda_1.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",
    "\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 = '1'\n",
    "fecha = '2022_04_25'   # FIXME: cambiar fecha!! Está mal!!\n",
    "fecha_rand = '2022_04_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": [
    "#Importar bases de scraps (randomization) de todos los paises\n",
    "scrap_arg = pd.read_stata(path_data + fr'\\randomization\\round{ronda}_{fecha_rand}\\randomization_ARG_{fecha_rand}_round_{ronda}.dta')\n",
    "scrap_col = pd.read_stata(path_data + fr'\\randomization\\round{ronda}_{fecha_rand}\\randomization_COL_{fecha_rand}_round_{ronda}.dta')\n",
    "scrap_ecu = pd.read_stata(path_data + fr'\\randomization\\round{ronda}_{fecha_rand}\\randomization_ECU_{fecha_rand}_round_{ronda}.dta')\n",
    "scrap_per = pd.read_stata(path_data + fr'\\randomization\\round{ronda}_{fecha_rand}\\randomization_PER_{fecha_rand}_round_{ronda}.dta')\n",
    "scrap_full_no_backup = pd.concat([scrap_arg,scrap_col,scrap_ecu,scrap_per])\n",
    "\n",
    "#Importar bases de scraps (randomization backups) de la ronda\n",
    "scrap_arg_backup = pd.read_stata(path_data + fr'\\randomization\\backup\\round{ronda}\\randomization_ARG_{fecha_rand}_round_{ronda}_backup1.dta')\n",
    "scrap_arg_backup2 = pd.read_stata(path_data + fr'\\randomization\\backup\\round{ronda}\\randomization_ARG_2022_04_19_round_1_v2scrape.dta')\n",
    "scrap_col_backup = pd.read_stata(path_data + fr'\\randomization\\backup\\round{ronda}\\randomization_COL_{fecha_rand}_round_{ronda}_backup1.dta')\n",
    "scrap_ecu_backup = pd.read_stata(path_data + fr'\\randomization\\backup\\round{ronda}\\randomization_ECU_{fecha_rand}_round_{ronda}_backup1.dta')\n",
    "scrap_per_backup = pd.read_stata(path_data + fr'\\randomization\\backup\\round{ronda}\\randomization_PER_{fecha_rand}_round_{ronda}_backup1.dta')\n",
    "scrap_full_backup = pd.concat([scrap_arg,scrap_col,scrap_ecu,scrap_per])\n",
    "\n",
    "###Construir una unica base uniendo las de los cuatro paises\n",
    "scrap_full = pd.concat([scrap_arg,scrap_col,scrap_ecu,scrap_per,\n",
    "                        scrap_arg_backup,scrap_arg_backup2,scrap_col_backup,scrap_ecu_backup,scrap_per_backup])\n",
    "scrap_full = scrap_full.reset_index()\n",
    "scrap_full.drop(columns='index')\n",
    "\n",
    "scrap_full['script_string_3'] = scrap_full['script_string_3'].astype('str')\n",
    "scrap_full.drop(columns=['index','Unnamed01','Unnamed011'], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "False    3696\n",
      "dtype: int64\n",
      "False    3696\n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "print(scrap_full_backup.duplicated(subset=['inmobiliaria','municipio']).value_counts())\n",
    "print(scrap_full_no_backup.duplicated(subset=['inmobiliaria','municipio']).value_counts())\n",
    "\n",
    "# Nota: las que se repiten son unicamente entre backups y no backups... Son las que fallaron y tuvimos que enviar de nuevo!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Importar base de mails recibidos \n",
    "rtas_full = pd.read_excel(path_datain + fr\"\\round_{ronda}\\mails_round_{ronda}_{fecha}.xlsx\") # Ultima descarga de gmail"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Se dropearon 208 observaciones.\n",
      "Se dropearon 226 observaciones.\n",
      "Se dropearon 5 observaciones.\n",
      "Se dropearon 8 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",
    "# Exporto las obs dropeadas\n",
    "# rtas_full_out.to_excel(path_deleted + fr\"\\observaciones_eliminadas_round_{ronda}_{fecha}.xlsx\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Se dropearon 12 observaciones.\n",
      "Match confirmaciones realizado.\n",
      "Cantidad de mails de @properati:\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "True     3645\n",
       "False    1980\n",
       "Name: conf_envio, dtype: int64"
      ]
     },
     "execution_count": 8,
     "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": 9,
   "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": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['rodriguezmanuel.w@gmail.com' 'rodriguezmanuelw@gmail.com'\n",
      " 'gomez.pablo.u@gmail.com' 'gomez.pablou@gmail.com'\n",
      " 'rodriguez.manuelw@gmail.com' 'gomezpablo.u@gmail.com'\n",
      " 'rodriguez.manuel.w@gmail.com' 'gomezpablou@gmail.com'\n",
      " 'jfmanuelrodriguez@gmail.com' 'jfmanuel.rodriguez@gmail.com'\n",
      " 'phpablo.gomez@gmail.com' 'jf.manuelrodriguez@gmail.com'\n",
      " 'ph.pablo.gomez@gmail.com' 'ph.pablogomez@gmail.com'\n",
      " 'jf.manuel.rodriguez@gmail.com' 'phpablogomez@gmail.com'\n",
      " 'manuelrodriguez.jf@gmail.com' 'manuel.rodriguez.jf@gmail.com'\n",
      " 'manuelrodriguezjf@gmail.com' 'pablomngomez@gmail.com'\n",
      " 'pablo.mngomez@gmail.com' 'pablomn.gomez@gmail.com'\n",
      " 'pablo.mn.gomez@gmail.com' 'manuel.rodriguezjf@gmail.com'\n",
      " 'fh.pablo.gomez@gmail.com' 'fhpablogomez@gmail.com'\n",
      " 'jc.manuel.rodriguez@gmail.com' 'jcmanuelrodriguez@gmail.com'\n",
      " 'jc.manuelrodriguez@gmail.com' 'fh.pablogomez@gmail.com'\n",
      " 'fhpablo.gomez@gmail.com' 'jcmanuel.rodriguez@gmail.com'\n",
      " 'rodriguez.jc.manuel@gmail.com' 'pablogomezfh@gmail.com'\n",
      " 'rodriguezjc.manuel@gmail.com' 'rodriguezjcmanuel@gmail.com'\n",
      " 'pablogomez.fh@gmail.com' 'rodriguez.jcmanuel@gmail.com'\n",
      " 'pablo.gomez.fh@gmail.com' 'pablo.gomezfh@gmail.com'\n",
      " 'gomezfhpablo@gmail.com' 'rodriguezmanueljf@gmail.com'\n",
      " 'gomezfh.pablo@gmail.com' 'gomez.fhpablo@gmail.com'\n",
      " 'rodriguez.manueljf@gmail.com' 'gomez.fh.pablo@gmail.com'\n",
      " 'rodriguezmanuel.jf@gmail.com' 'rodriguez.manuel.jf@gmail.com']\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodriguezmanuel.w@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 rodriguezmanuelw@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 44 \n",
      "Cantidad de respuestas: 28\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.pablo.u@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 49 \n",
      "Cantidad de respuestas: 33\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 3 - El 9.090909090909092 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de gomez.pablou@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 37 \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 rodriguez.manuelw@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 gomezpablo.u@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 37 \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 rodriguez.manuel.w@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 46 \n",
      "Cantidad de respuestas: 31\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 1 - El 3.225806451612903 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de gomezpablou@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 42 \n",
      "Cantidad de respuestas: 28\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 jfmanuelrodriguez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 81 \n",
      "Cantidad de respuestas: 57\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 jfmanuel.rodriguez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 85 \n",
      "Cantidad de respuestas: 57\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 phpablo.gomez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 87 \n",
      "Cantidad de respuestas: 57\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 jf.manuelrodriguez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 85 \n",
      "Cantidad de respuestas: 54\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 ph.pablo.gomez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 87 \n",
      "Cantidad de respuestas: 57\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 ph.pablogomez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 81 \n",
      "Cantidad de respuestas: 56\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 jf.manuel.rodriguez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 89 \n",
      "Cantidad de respuestas: 57\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 phpablogomez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 81 \n",
      "Cantidad de respuestas: 54\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 manuelrodriguez.jf@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 40 \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 manuel.rodriguez.jf@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 48 \n",
      "Cantidad de respuestas: 28\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 manuelrodriguezjf@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 39 \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 pablomngomez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 46 \n",
      "Cantidad de respuestas: 27\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 1 - El 3.7037037037037033 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de pablo.mngomez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 47 \n",
      "Cantidad de respuestas: 28\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 pablomn.gomez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 42 \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 pablo.mn.gomez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 41 \n",
      "Cantidad de respuestas: 28\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.rodriguezjf@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 44 \n",
      "Cantidad de respuestas: 28\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 fh.pablo.gomez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 91 \n",
      "Cantidad de respuestas: 55\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 fhpablogomez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 88 \n",
      "Cantidad de respuestas: 56\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 1 - El 1.7857142857142856 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de jc.manuel.rodriguez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 83 \n",
      "Cantidad de respuestas: 57\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 jcmanuelrodriguez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 85 \n",
      "Cantidad de respuestas: 54\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 jc.manuelrodriguez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 83 \n",
      "Cantidad de respuestas: 55\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 fh.pablogomez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 89 \n",
      "Cantidad de respuestas: 57\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 fhpablo.gomez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 87 \n",
      "Cantidad de respuestas: 54\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 jcmanuel.rodriguez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 87 \n",
      "Cantidad de respuestas: 54\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.jc.manuel@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 47 \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 pablogomezfh@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 39 \n",
      "Cantidad de respuestas: 28\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 1 - El 3.571428571428571 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodriguezjc.manuel@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 41 \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 rodriguezjcmanuel@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 45 \n",
      "Cantidad de respuestas: 28\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 1 - El 3.571428571428571 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de pablogomez.fh@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 45 \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 rodriguez.jcmanuel@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 pablo.gomez.fh@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 pablo.gomezfh@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 41 \n",
      "Cantidad de respuestas: 28\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 gomezfhpablo@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 89 \n",
      "Cantidad de respuestas: 55\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 rodriguezmanueljf@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 85 \n",
      "Cantidad de respuestas: 55\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.pablo@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 86 \n",
      "Cantidad de respuestas: 56\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.fhpablo@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 91 \n",
      "Cantidad de respuestas: 55\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.manueljf@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 85 \n",
      "Cantidad de respuestas: 57\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.fh.pablo@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 83 \n",
      "Cantidad de respuestas: 59\n",
      "1) Match por id de properati\n",
      "script_string_3 -> body, (max sust.: 0)\n",
      "[====================] 100%\n",
      "Faltan: 1 - El 1.694915254237288 % de las observaciones\n",
      "\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de rodriguezmanuel.jf@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 85 \n",
      "Cantidad de respuestas: 54\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.jf@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 90 \n",
      "Cantidad de respuestas: 52\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",
      "['wjose.rodriguez.p@gmail.com' 'wjose.rodriguezp@gmail.com'\n",
      " 'scarlos.gonzalez.m@gmail.com' 'scarlosgonzalez.m@gmail.com'\n",
      " 'scarlos.gonzalezm@gmail.com' 'scarlosgonzalezm@gmail.com'\n",
      " 'wjoserodriguezp@gmail.com' 'wjoserodriguez.p@gmail.com'\n",
      " 'josedrodriguezw@gmail.com' 'jose.d.rodriguezw@gmail.com'\n",
      " 'carlos.mz.gonzalez@gmail.com' 'carlosmz.gonzalez@gmail.com'\n",
      " 'carlosmzgonzalez@gmail.com' 'carlos.mzgonzalez@gmail.com'\n",
      " 'jose.drodriguezw@gmail.com' 'josed.rodriguezw@gmail.com'\n",
      " 'jp.gonzalez.carlos@gmail.com' 'rodriguezljose.c@gmail.com'\n",
      " 'rodriguezljosec@gmail.com' 'jpgonzalezcarlos@gmail.com'\n",
      " 'jp.gonzalezcarlos@gmail.com' 'rodriguezl.jose.c@gmail.com'\n",
      " 'rodriguezl.josec@gmail.com' 'jpgonzalez.carlos@gmail.com'\n",
      " 'carlos.gonzalezxw@gmail.com' 'rodriguez.mjosev@gmail.com'\n",
      " 'rodriguezmjose.v@gmail.com' 'carlosgonzalez.xw@gmail.com'\n",
      " 'carlosgonzalezxw@gmail.com' 'rodriguez.mjose.v@gmail.com'\n",
      " 'carlos.gonzalez.xw@gmail.com' 'rodriguezmjosev@gmail.com'\n",
      " 'josef.rodriguez.u@gmail.com' 'jcarlosu.gonzalez@gmail.com'\n",
      " 'jcarlos.u.gonzalez@gmail.com' 'josefrodriguezu@gmail.com'\n",
      " 'josefrodriguez.u@gmail.com' 'josef.rodriguezu@gmail.com'\n",
      " 'jcarlosugonzalez@gmail.com' 'jcarlos.ugonzalez@gmail.com'\n",
      " 'r.joserodriguezt@gmail.com' 'wgonzalez.carlosp@gmail.com'\n",
      " 'wgonzalezcarlos.p@gmail.com' 'r.jose.rodriguezt@gmail.com'\n",
      " 'rjose.rodriguezt@gmail.com' 'wgonzalez.carlos.p@gmail.com'\n",
      " 'rjoserodriguezt@gmail.com' 'wgonzalezcarlosp@gmail.com']\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de wjose.rodriguez.p@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 17 \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 wjose.rodriguezp@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 17 \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 scarlos.gonzalez.m@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 scarlosgonzalez.m@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 19 \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 scarlos.gonzalezm@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 18 \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 scarlosgonzalezm@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 19 \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 wjoserodriguezp@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 wjoserodriguez.p@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 josedrodriguezw@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 39 \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 jose.d.rodriguezw@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 39 \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 carlos.mz.gonzalez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 34 \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 carlosmz.gonzalez@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 carlosmzgonzalez@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 carlos.mzgonzalez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 36 \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 jose.drodriguezw@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 40 \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 josed.rodriguezw@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 jp.gonzalez.carlos@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 17 \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 rodriguezljose.c@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 rodriguezljosec@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 17 \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 jpgonzalezcarlos@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 15 \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 jp.gonzalezcarlos@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 rodriguezl.jose.c@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 rodriguezl.josec@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 19 \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 jpgonzalez.carlos@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 18 \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 carlos.gonzalezxw@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 38 \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 rodriguez.mjosev@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 rodriguezmjose.v@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 36 \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 carlosgonzalez.xw@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 39 \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 carlosgonzalezxw@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 34 \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 rodriguez.mjose.v@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 carlos.gonzalez.xw@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 38 \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 rodriguezmjosev@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 josef.rodriguez.u@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 19 \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 jcarlosu.gonzalez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 17 \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 jcarlos.u.gonzalez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 21 \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 josefrodriguezu@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 josefrodriguez.u@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 19 \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 josef.rodriguezu@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 18 \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 jcarlosugonzalez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 18 \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 jcarlos.ugonzalez@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 22 \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 r.joserodriguezt@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 34 \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 wgonzalez.carlosp@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 wgonzalezcarlos.p@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 35 \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 r.jose.rodriguezt@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 39 \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 rjose.rodriguezt@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 35 \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 wgonzalez.carlos.p@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 39 \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 rjoserodriguezt@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 33 \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 wgonzalezcarlosp@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",
      "end of script\n",
      "['zambrano.fluis@gmail.com' 'w.garciajuan@gmail.com'\n",
      " 'zambranofluis@gmail.com' 'zambrano.f.luis@gmail.com'\n",
      " 'w.garcia.juan@gmail.com' 'wgarcia.juan@gmail.com'\n",
      " 'wgarciajuan@gmail.com' 'zambranof.luis@gmail.com'\n",
      " 'zambrano.luispt@gmail.com' 'juan.pwgarcia@gmail.com'\n",
      " 'juanpw.garcia@gmail.com' 'juan.pw.garcia@gmail.com'\n",
      " 'zambranoluis.pt@gmail.com' 'zambranoluispt@gmail.com'\n",
      " 'zambrano.luis.pt@gmail.com' 'juanpwgarcia@gmail.com'\n",
      " 'zambranok.luis@gmail.com' 'zambrano.kluis@gmail.com'\n",
      " 'zambrano.k.luis@gmail.com' 'pgarcia.juan.c@gmail.com'\n",
      " 'pgarciajuan.c@gmail.com' 'pgarcia.juanc@gmail.com'\n",
      " 'zambranokluis@gmail.com' 'pgarciajuanc@gmail.com'\n",
      " 'luism.zambranoj@gmail.com' 'luis.mzambranoj@gmail.com'\n",
      " 'hgarcia.juan.s@gmail.com' 'hgarciajuan.s@gmail.com'\n",
      " 'luis.m.zambranoj@gmail.com' 'luismzambranoj@gmail.com'\n",
      " 'hgarciajuans@gmail.com' 'hgarcia.juans@gmail.com'\n",
      " 'luisbzambranom@gmail.com' 'luis.b.zambranom@gmail.com'\n",
      " 'fgarciajuanp@gmail.com' 'luis.bzambranom@gmail.com'\n",
      " 'luisb.zambranom@gmail.com' 'fgarcia.juan.p@gmail.com'\n",
      " 'fgarciajuan.p@gmail.com' 'fgarcia.juanp@gmail.com'\n",
      " 'pgarciajuanf@gmail.com' 'pgarcia.juan.f@gmail.com'\n",
      " 'luisc.zambranor@gmail.com' 'luis.c.zambranor@gmail.com'\n",
      " 'pgarcia.juanf@gmail.com' 'luisczambranor@gmail.com'\n",
      " 'luis.czambranor@gmail.com' 'pgarciajuan.f@gmail.com']\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de zambrano.fluis@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 w.garciajuan@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 zambranofluis@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 zambrano.f.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 w.garcia.juan@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 wgarcia.juan@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 wgarciajuan@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 zambranof.luis@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 zambrano.luispt@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 18 \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 juan.pwgarcia@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 18 \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 juanpw.garcia@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 14 \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 juan.pw.garcia@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 zambranoluis.pt@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 18 \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 zambranoluispt@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 15 \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 zambrano.luis.pt@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 17 \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 juanpwgarcia@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 14 \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 zambranok.luis@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 zambrano.kluis@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 zambrano.k.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 pgarcia.juan.c@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 pgarciajuan.c@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 pgarcia.juanc@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 zambranokluis@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 pgarciajuanc@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 luism.zambranoj@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 luis.mzambranoj@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 hgarcia.juan.s@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 17 \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 hgarciajuan.s@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 18 \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 luis.m.zambranoj@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 18 \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 luismzambranoj@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 hgarciajuans@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 hgarcia.juans@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 18 \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 luisbzambranom@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 luis.b.zambranom@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 fgarciajuanp@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 luis.bzambranom@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 luisb.zambranom@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 9 \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 fgarcia.juan.p@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 fgarciajuan.p@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 fgarcia.juanp@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 pgarciajuanf@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 pgarcia.juan.f@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 luisc.zambranor@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 luis.c.zambranor@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 17 \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 pgarcia.juanf@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 19 \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 luisczambranor@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 17 \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 luis.czambranor@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 17 \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 pgarciajuan.f@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 17 \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",
      "end of script\n",
      "['alejandro.mdominguezu@gmail.com' 'florescdaniel.p@gmail.com'\n",
      " 'floresc.daniel.p@gmail.com' 'alejandrom.dominguezu@gmail.com'\n",
      " 'floresc.danielp@gmail.com' 'alejandromdominguezu@gmail.com'\n",
      " 'alejandro.m.dominguezu@gmail.com' 'florescdanielp@gmail.com'\n",
      " 'j.danielflorest@gmail.com' 'j.daniel.florest@gmail.com'\n",
      " 'fdominguezalejandrog@gmail.com' 'jdaniel.florest@gmail.com'\n",
      " 'fdominguez.alejandro.g@gmail.com' 'fdominguez.alejandrog@gmail.com'\n",
      " 'fdominguezalejandro.g@gmail.com' 'jdanielflorest@gmail.com'\n",
      " 'j.daniel.floresu@gmail.com' 'mdominguezalejandroh@gmail.com'\n",
      " 'j.danielfloresu@gmail.com' 'mdominguezalejandro.h@gmail.com'\n",
      " 'jdanielfloresu@gmail.com' 'mdominguez.alejandroh@gmail.com'\n",
      " 'jdaniel.floresu@gmail.com' 'mdominguez.alejandro.h@gmail.com'\n",
      " 'pdominguezalejandroj@gmail.com' 'pdominguez.alejandroj@gmail.com'\n",
      " 'jdanielfloresj@gmail.com' 'pdominguez.alejandro.j@gmail.com'\n",
      " 'pdominguezalejandro.j@gmail.com' 'jdaniel.floresj@gmail.com'\n",
      " 'j.danielfloresj@gmail.com' 'j.daniel.floresj@gmail.com'\n",
      " 'jdaniel.floresn@gmail.com' 'pdominguezalejandro.h@gmail.com'\n",
      " 'pdominguezalejandroh@gmail.com' 'pdominguez.alejandro.h@gmail.com'\n",
      " 'pdominguez.alejandroh@gmail.com' 'j.daniel.floresn@gmail.com'\n",
      " 'jdanielfloresn@gmail.com' 'j.danielfloresn@gmail.com'\n",
      " 'bdominguez.alejandroc@gmail.com' 'bdominguezalejandro.c@gmail.com'\n",
      " 'bfloresdaniel.j@gmail.com' 'bflores.danielj@gmail.com'\n",
      " 'bdominguezalejandroc@gmail.com' 'bflores.daniel.j@gmail.com'\n",
      " 'bdominguez.alejandro.c@gmail.com' 'bfloresdanielj@gmail.com']\n",
      "\n",
      "###########################################################\n",
      "Analisis de respuestas de alejandro.mdominguezu@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 florescdaniel.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 floresc.daniel.p@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 alejandrom.dominguezu@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 9 \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 floresc.danielp@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 alejandromdominguezu@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 alejandro.m.dominguezu@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 florescdanielp@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 j.danielflorest@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 17 \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 j.daniel.florest@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 21 \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 fdominguezalejandrog@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 19 \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 jdaniel.florest@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 18 \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 fdominguez.alejandro.g@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 16 \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 fdominguez.alejandrog@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 21 \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 fdominguezalejandro.g@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 19 \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 jdanielflorest@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 19 \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 j.daniel.floresu@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 mdominguezalejandroh@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 j.danielfloresu@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 13 \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 mdominguezalejandro.h@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 jdanielfloresu@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 mdominguez.alejandroh@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 jdaniel.floresu@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 13 \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 mdominguez.alejandro.h@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 pdominguezalejandroj@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 21 \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 pdominguez.alejandroj@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 18 \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 jdanielfloresj@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 18 \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 pdominguez.alejandro.j@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 21 \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 pdominguezalejandro.j@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 jdaniel.floresj@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 19 \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 j.danielfloresj@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 j.daniel.floresj@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 jdaniel.floresn@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 9 \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 pdominguezalejandro.h@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 pdominguezalejandroh@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 pdominguez.alejandro.h@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 pdominguez.alejandroh@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 13 \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.daniel.floresn@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 jdanielfloresn@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 j.danielfloresn@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 bdominguez.alejandroc@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 23 \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 bdominguezalejandro.c@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 bfloresdaniel.j@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 17 \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 bflores.danielj@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 18 \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 bdominguezalejandroc@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 18 \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 bflores.daniel.j@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 bdominguez.alejandro.c@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 21 \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 bfloresdanielj@gmail.com\n",
      "Cantidad de publicaciones scrapeadas: 17 \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",
      "end of script\n",
      "C:\\Users\\Nico\\Dropbox\\BID-LGBTQ+\\campo\\data\\mails_matches\\matched\\confirmaciones_de_envio\\sent_mails_conf_envio_round_1_2022_08_04.xlsx creado\n"
     ]
    }
   ],
   "source": [
    "import importlib\n",
    "importlib.reload(matching)\n",
    "\n",
    "##### Matcheo @properati con scraps\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": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "both          3633\n",
       "left_only        0\n",
       "right_only       0\n",
       "Name: _merge, dtype: int64"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matched._merge.value_counts()\n",
    "\n",
    "#### Nota: ##########################################\n",
    "# Los 9 right_only son todos de la propiedad de Ine!!\n",
    "#####################################################\n",
    "\n",
    "matched = matched[-matched.body.str.contains(\"miberniel\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "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>inmobiliaria</th>\n",
       "      <th>fecha</th>\n",
       "      <th>link</th>\n",
       "      <th>municipio</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</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>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",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [inmobiliaria, fecha, link, municipio, ciudad, pais_x, descripcion, precio, moneda, caracteristicas, ambientes, habitaciones, banos, m2_totales, m2_cubiertos, cocheras, id, precio_local, p_m2, p_m2_above_mdn, n_adds, n_adds_above_mdn, m2_above_mdn, common_name, capital, treatment, ses, male_name, mail, male_couple, female_couple, script, script_string, script_string_2, script_string_3, randomization_seed, nombre, nombre_2, profesional, vivienda, n_adds_muni, n_adds_muni_above_mdn, random, index_rtas, match_confiab_x, match_step_x, Unnamed: 0, subject, from, to, body, date, cc, thread_id, mimeType, pais_y, conf_envio, date_clean, index_scrap, match_confiab_y, match_step_y, match_string, match2_string, _merge]\n",
       "Index: []"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matched[matched.id]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "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>inmobiliaria</th>\n",
       "      <th>fecha</th>\n",
       "      <th>link</th>\n",
       "      <th>municipio</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</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>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>6</th>\n",
       "      <td>heredia</td>\n",
       "      <td>2022-02-18</td>\n",
       "      <td>properati.com.ar/detalle/4ae45_alquiler_depart...</td>\n",
       "      <td>caba</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>hetero</td>\n",
       "      <td>high</td>\n",
       "      <td>Pablo</td>\n",
       "      <td>gomez.pablo.u@gmail.com</td>\n",
       "      <td>Juan</td>\n",
       "      <td>María</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Buenos días, mi nombre es Pablo, junto a mi pa...</td>\n",
       "      <td>Pablo y María.</td>\n",
       "      <td>Código 150</td>\n",
       "      <td>23.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>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>92</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>gomez.pablo.u@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Tue, 19 Apr 2022 16:59:01 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18042c36649755f4</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>arg</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-04-19</td>\n",
       "      <td>21.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1410, end=1419, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>raices puerto madero</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>properati.com.ar/detalle/3z6bc_alquiler_depart...</td>\n",
       "      <td>caba</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>174150.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>neutral</td>\n",
       "      <td>Manuel</td>\n",
       "      <td>jf.manuel.rodriguez@gmail.com</td>\n",
       "      <td>Luis</td>\n",
       "      <td>Laura</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Buenos días, mi nombre es Manuel, junto a mi p...</td>\n",
       "      <td>Manuel y Laura.</td>\n",
       "      <td>Código 1373</td>\n",
       "      <td>23.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>NaN</td>\n",
       "      <td>49.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2243</td>\n",
       "      <td>Hiciste una consulta por la propiedad Florida ...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com.ar&gt;</td>\n",
       "      <td>jf.manuel.rodriguez@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Tue, 19 Apr 2022 16:31:36 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18042aa4a41e721a</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>arg</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-04-19</td>\n",
       "      <td>23.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1365, end=1375, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>inmobiliaria sergio andre</td>\n",
       "      <td>2022-04-18</td>\n",
       "      <td>properati.com.ar/detalle/4foc6_alquiler_depart...</td>\n",
       "      <td>jose_c_paz</td>\n",
       "      <td>buenos aires ampliado</td>\n",
       "      <td>arg</td>\n",
       "      <td>departamento dos ambientes con lavadero y coch...</td>\n",
       "      <td>35000.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['2ambientes', '1bano', '40 m²totales']</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "      <td>6070</td>\n",
       "      <td>35000.0</td>\n",
       "      <td>875.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>homo</td>\n",
       "      <td>neutral</td>\n",
       "      <td>Manuel</td>\n",
       "      <td>jcmanuel.rodriguez@gmail.com</td>\n",
       "      <td>Luis</td>\n",
       "      <td></td>\n",
       "      <td>2.0</td>\n",
       "      <td>Hola, somos una pareja interesada en alquilar ...</td>\n",
       "      <td>Manuel y Luis</td>\n",
       "      <td>Código 6070</td>\n",
       "      <td>23.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>NaN</td>\n",
       "      <td>17.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2639</td>\n",
       "      <td>Hiciste una consulta por la propiedad Arenales...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com.ar&gt;</td>\n",
       "      <td>jcmanuel.rodriguez@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 20 Apr 2022 14:24:31 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>180475c4af0edc24</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>arg</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-04-20</td>\n",
       "      <td>26.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1255, end=1265, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>heredia</td>\n",
       "      <td>2022-02-18</td>\n",
       "      <td>properati.com.ar/detalle/4adue_alquiler_depart...</td>\n",
       "      <td>vicente_lopez</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>trans</td>\n",
       "      <td>neutral</td>\n",
       "      <td>Pablo</td>\n",
       "      <td>gomez.fh.pablo@gmail.com</td>\n",
       "      <td>Luis</td>\n",
       "      <td>María</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Buenos días, mi nombre es Pablo, junto a mi pa...</td>\n",
       "      <td>Pablo y María.</td>\n",
       "      <td>Código 194</td>\n",
       "      <td>23.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>NaN</td>\n",
       "      <td>15.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1469</td>\n",
       "      <td>Hiciste una consulta por la propiedad Sanchez ...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com.ar&gt;</td>\n",
       "      <td>gomez.fh.pablo@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 20 Apr 2022 17:52:19 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>180481a8a38daedc</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>arg</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-04-20</td>\n",
       "      <td>29.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1273, end=1282, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>administracion capogrosso</td>\n",
       "      <td>2022-04-06</td>\n",
       "      <td>properati.com.ar/detalle/4eukm_alquiler_depart...</td>\n",
       "      <td>rosario</td>\n",
       "      <td>rosario ampliado</td>\n",
       "      <td>arg</td>\n",
       "      <td>descripcion: es un departamento semipiso. con ...</td>\n",
       "      <td>38000.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['2ambientes', '1bano', '43 m²totales']</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "      <td>9364</td>\n",
       "      <td>38000.0</td>\n",
       "      <td>883.720947</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>trans</td>\n",
       "      <td>neutral</td>\n",
       "      <td>Manuel</td>\n",
       "      <td>rodriguez.manuel.jf@gmail.com</td>\n",
       "      <td>Pablo</td>\n",
       "      <td>María</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Hola, somos una pareja interesada en alquilar ...</td>\n",
       "      <td>Manuel y María (ella es trans)</td>\n",
       "      <td>Código 9364</td>\n",
       "      <td>23.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>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3165</td>\n",
       "      <td>Hiciste una consulta por la propiedad Alsina 1174</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com.ar&gt;</td>\n",
       "      <td>rodriguez.manuel.jf@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 20 Apr 2022 17:55:54 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>180481dd04110cfc</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>arg</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-04-20</td>\n",
       "      <td>31.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1261, end=1271, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>grupo habitat</td>\n",
       "      <td>2022-02-19</td>\n",
       "      <td>properati.com.co/detalle/2kqd7_arriendo_aparta...</td>\n",
       "      <td>bello</td>\n",
       "      <td>medellin ampliado</td>\n",
       "      <td>col</td>\n",
       "      <td>apto 52 mts, 2 alcobas, 1 closet, 1 bano, sala...</td>\n",
       "      <td>1200000.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['2habitaciones', '1bano', '52 m²totales']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1172</td>\n",
       "      <td>1200000.0</td>\n",
       "      <td>23076.923828</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>hetero</td>\n",
       "      <td>high</td>\n",
       "      <td>José</td>\n",
       "      <td>wjoserodriguezp@gmail.com</td>\n",
       "      <td>Luis</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 1172</td>\n",
       "      <td>35.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>NaN</td>\n",
       "      <td>7.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4090</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartame...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>wjoserodriguezp@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Tue, 19 Apr 2022 18:07:21 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1804301ee86fb295</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-04-19</td>\n",
       "      <td>3.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1341, end=1351, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>luque ospina y cia sa</td>\n",
       "      <td>2022-04-18</td>\n",
       "      <td>properati.com.co/detalle/2qqfi_arriendo_aparta...</td>\n",
       "      <td>bogota</td>\n",
       "      <td>bogota ampliado</td>\n",
       "      <td>col</td>\n",
       "      <td>luque ospina ofrece en arrendamiento apartamen...</td>\n",
       "      <td>1430400.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['1habitacion', '2banos', '60 m²totales']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>a578</td>\n",
       "      <td>1430400.0</td>\n",
       "      <td>23840.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>hetero</td>\n",
       "      <td>neutral</td>\n",
       "      <td>Carlos</td>\n",
       "      <td>carlos.mz.gonzalez@gmail.com</td>\n",
       "      <td>José</td>\n",
       "      <td>Luz</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Buenos días, mi nombre es Carlos, junto a mi p...</td>\n",
       "      <td>Carlos y Luz.</td>\n",
       "      <td>Código a578</td>\n",
       "      <td>35.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>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3511</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartame...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>carlos.mz.gonzalez@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Tue, 19 Apr 2022 20:03:50 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18043173399b0d7d</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-04-19</td>\n",
       "      <td>19.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1398, end=1408, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>vivir bien propiedad raiz s.a.s</td>\n",
       "      <td>2022-04-12</td>\n",
       "      <td>properati.com.co/detalle/2qg2w_arriendo_aparta...</td>\n",
       "      <td>sabaneta</td>\n",
       "      <td>medellin ampliado</td>\n",
       "      <td>col</td>\n",
       "      <td>arrienda hermoso apto de 80 mts con 3 alcobas ...</td>\n",
       "      <td>2200000.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['3habitaciones', '2banos', '80 m²totales']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1237</td>\n",
       "      <td>2200000.0</td>\n",
       "      <td>27500.000000</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>homo</td>\n",
       "      <td>high</td>\n",
       "      <td>José</td>\n",
       "      <td>rodriguezljose.c@gmail.com</td>\n",
       "      <td>Luis</td>\n",
       "      <td></td>\n",
       "      <td>2.0</td>\n",
       "      <td>Hola, somos una pareja interesada en arrendar ...</td>\n",
       "      <td>José y Luis</td>\n",
       "      <td>Código 1237</td>\n",
       "      <td>35.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>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4329</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartame...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>rodriguezljose.c@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Tue, 19 Apr 2022 20:04:36 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>180436d49926c268</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-04-19</td>\n",
       "      <td>0.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>8</th>\n",
       "      <td>inmobiliaria la heredad sas</td>\n",
       "      <td>2021-10-29</td>\n",
       "      <td>properati.com.co/detalle/2hsag_arriendo_aparta...</td>\n",
       "      <td>copacabana</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>22.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>homo</td>\n",
       "      <td>high</td>\n",
       "      <td>José</td>\n",
       "      <td>rodriguezljose.c@gmail.com</td>\n",
       "      <td>Carlos</td>\n",
       "      <td></td>\n",
       "      <td>1.0</td>\n",
       "      <td>Buenos días, mi nombre es José, junto a mi par...</td>\n",
       "      <td>José y Carlos.</td>\n",
       "      <td>Código 9842</td>\n",
       "      <td>35.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>NaN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4323</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartame...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>rodriguezljose.c@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Tue, 19 Apr 2022 20:05:28 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>180436d49926c268</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-04-19</td>\n",
       "      <td>2.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1380, end=1390, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>espacio inmobiliario &amp; cia ltda</td>\n",
       "      <td>2022-04-08</td>\n",
       "      <td>properati.com.co/detalle/2qb4n_arriendo_aparta...</td>\n",
       "      <td>bogota</td>\n",
       "      <td>bogota ampliado</td>\n",
       "      <td>col</td>\n",
       "      <td>apartamento de 61 mts2 piso 6, sol de la manan...</td>\n",
       "      <td>1250000.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>a213</td>\n",
       "      <td>1250000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>homo</td>\n",
       "      <td>high</td>\n",
       "      <td>José</td>\n",
       "      <td>rodriguezl.jose.c@gmail.com</td>\n",
       "      <td>Luis</td>\n",
       "      <td></td>\n",
       "      <td>2.0</td>\n",
       "      <td>Hola, somos una pareja interesada en arrendar ...</td>\n",
       "      <td>José y Luis</td>\n",
       "      <td>Código a213</td>\n",
       "      <td>35.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>NaN</td>\n",
       "      <td>11.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4325</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartame...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>rodriguezl.jose.c@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Tue, 19 Apr 2022 20:05:16 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>180436de5a758cb7</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-04-19</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1400, end=1410, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>inmoreinversiones</td>\n",
       "      <td>2022-03-23</td>\n",
       "      <td>properati.com.co/detalle/2pbw1_arriendo_aparta...</td>\n",
       "      <td>bogota</td>\n",
       "      <td>bogota ampliado</td>\n",
       "      <td>col</td>\n",
       "      <td>hermoso apartamento para estrenar, excelente u...</td>\n",
       "      <td>1850000.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['3habitaciones', '3banos', '88 m²totales']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>a24</td>\n",
       "      <td>1850000.0</td>\n",
       "      <td>21022.726562</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>homo</td>\n",
       "      <td>neutral</td>\n",
       "      <td>Carlos</td>\n",
       "      <td>carlos.gonzalezxw@gmail.com</td>\n",
       "      <td>Luis</td>\n",
       "      <td></td>\n",
       "      <td>2.0</td>\n",
       "      <td>Hola, somos una pareja interesada en arrendar ...</td>\n",
       "      <td>Carlos y Luis</td>\n",
       "      <td>Código a24</td>\n",
       "      <td>35.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>NaN</td>\n",
       "      <td>13.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3796</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartame...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>carlos.gonzalezxw@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Tue, 19 Apr 2022 20:10:25 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1804372472dc4439</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-04-19</td>\n",
       "      <td>8.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1290, end=1299, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>crear inmobiliaria</td>\n",
       "      <td>2022-04-02</td>\n",
       "      <td>properati.com.co/detalle/2q23r_arriendo_aparta...</td>\n",
       "      <td>bogota</td>\n",
       "      <td>bogota ampliado</td>\n",
       "      <td>col</td>\n",
       "      <td>espectacular apartamento ubicado en chapinero ...</td>\n",
       "      <td>4100000.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['3habitaciones', '3banos']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>a101</td>\n",
       "      <td>4100000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.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>José</td>\n",
       "      <td>rodriguez.mjosev@gmail.com</td>\n",
       "      <td>Carlos</td>\n",
       "      <td></td>\n",
       "      <td>1.0</td>\n",
       "      <td>Buenos días, mi nombre es José, junto a mi par...</td>\n",
       "      <td>José y Carlos.</td>\n",
       "      <td>Código a101</td>\n",
       "      <td>35.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>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4342</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartame...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>rodriguez.mjosev@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Mon, 25 Apr 2022 16:22:17 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1806187e72bbbf68</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-04-25</td>\n",
       "      <td>10.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1289, end=1299, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>vivir bien propiedad raiz s.a.s</td>\n",
       "      <td>2022-04-02</td>\n",
       "      <td>properati.com.co/detalle/2q2lf_arriendo_aparta...</td>\n",
       "      <td>itagui</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>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>homo</td>\n",
       "      <td>neutral</td>\n",
       "      <td>José</td>\n",
       "      <td>rodriguez.mjose.v@gmail.com</td>\n",
       "      <td>Juan</td>\n",
       "      <td></td>\n",
       "      <td>1.0</td>\n",
       "      <td>Buenos días, mi nombre es José, junto a mi par...</td>\n",
       "      <td>José y Juan.</td>\n",
       "      <td>Código 1240</td>\n",
       "      <td>35.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>NaN</td>\n",
       "      <td>18.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4446</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartame...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>rodriguez.mjose.v@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Tue, 19 Apr 2022 20:10:25 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18043729f468a39e</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-04-19</td>\n",
       "      <td>3.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1280, end=1290, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>vivir bien propiedad raiz s.a.s</td>\n",
       "      <td>2021-10-09</td>\n",
       "      <td>properati.com.co/detalle/2hb58_arriendo_aparta...</td>\n",
       "      <td>envigado</td>\n",
       "      <td>medellin ampliado</td>\n",
       "      <td>col</td>\n",
       "      <td>arrienda apto en envigado barrio el trianon de...</td>\n",
       "      <td>1100000.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>1065</td>\n",
       "      <td>1100000.0</td>\n",
       "      <td>15714.286133</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>trans</td>\n",
       "      <td>high</td>\n",
       "      <td>José</td>\n",
       "      <td>josefrodriguez.u@gmail.com</td>\n",
       "      <td>Juan</td>\n",
       "      <td>Mónica</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Hola, somos una pareja interesada en arrendar ...</td>\n",
       "      <td>José y Mónica (ella es trans)</td>\n",
       "      <td>Código 1065</td>\n",
       "      <td>35.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>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4516</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartame...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>josefrodriguez.u@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 20 Apr 2022 15:29:46 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18047980aae821f2</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-04-20</td>\n",
       "      <td>10.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1257, end=1267, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>servicio integral inmobiliario</td>\n",
       "      <td>2021-11-13</td>\n",
       "      <td>properati.com.co/detalle/2i7ih_arriendo_aparta...</td>\n",
       "      <td>bogota</td>\n",
       "      <td>bogota ampliado</td>\n",
       "      <td>col</td>\n",
       "      <td>excelente apto muy iluminado ideal para famili...</td>\n",
       "      <td>1315000.0</td>\n",
       "      <td>$</td>\n",
       "      <td>['3habitaciones', '2banos', '64 m²totales']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>a137</td>\n",
       "      <td>1315000.0</td>\n",
       "      <td>20546.875000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.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>Carlos</td>\n",
       "      <td>wgonzalezcarlos.p@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 a137</td>\n",
       "      <td>35.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>NaN</td>\n",
       "      <td>22.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4015</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartame...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>wgonzalezcarlos.p@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 20 Apr 2022 15:32:03 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1804798fb938eddd</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-04-20</td>\n",
       "      <td>1.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1336, end=1346, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>evaluaciones inmobiliarias</td>\n",
       "      <td>2022-03-20</td>\n",
       "      <td>properati.com.co/detalle/2p7qo_arriendo_aparta...</td>\n",
       "      <td>bogota</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>trans</td>\n",
       "      <td>neutral</td>\n",
       "      <td>Carlos</td>\n",
       "      <td>wgonzalezcarlos.p@gmail.com</td>\n",
       "      <td>Luis</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 (ella es trans)</td>\n",
       "      <td>Código a564</td>\n",
       "      <td>35.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>NaN</td>\n",
       "      <td>18.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4000</td>\n",
       "      <td>Hiciste una consulta por la propiedad Apartaes...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>wgonzalezcarlos.p@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Wed, 20 Apr 2022 15:35:53 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>180479d9f2a13b51</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>col</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-04-20</td>\n",
       "      <td>5.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1303, end=1313, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>century 21 innovation</td>\n",
       "      <td>2022-04-12</td>\n",
       "      <td>properati.com.ec/detalle/eiv7_alquiler_departa...</td>\n",
       "      <td>guayaquil</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>15.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>hetero</td>\n",
       "      <td>neutral</td>\n",
       "      <td>Juan</td>\n",
       "      <td>juanpw.garcia@gmail.com</td>\n",
       "      <td>Luis</td>\n",
       "      <td>Rosa</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Hola, somos una pareja interesada en alquilar ...</td>\n",
       "      <td>Juan y Rosa</td>\n",
       "      <td>Código 6170</td>\n",
       "      <td>26.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>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5039</td>\n",
       "      <td>Hiciste una consulta por la propiedad Las Cumbres</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>juanpw.garcia@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Tue, 19 Apr 2022 18:37:00 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>180431d16f19228b</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>ecu</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-04-19</td>\n",
       "      <td>8.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1172, end=1182, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>century 21 imperial</td>\n",
       "      <td>2022-04-04</td>\n",
       "      <td>properati.com.ec/detalle/egfk_alquiler_departa...</td>\n",
       "      <td>quito</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>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>homo</td>\n",
       "      <td>high</td>\n",
       "      <td>Juan</td>\n",
       "      <td>pgarcia.juanc@gmail.com</td>\n",
       "      <td>Luis</td>\n",
       "      <td></td>\n",
       "      <td>2.0</td>\n",
       "      <td>Hola, somos una pareja interesada en alquilar ...</td>\n",
       "      <td>Juan y Luis</td>\n",
       "      <td>Código 6216</td>\n",
       "      <td>26.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>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5108</td>\n",
       "      <td>Hiciste una consulta por la propiedad Alonso D...</td>\n",
       "      <td>Properati &lt;contacts@mailing.properati.com&gt;</td>\n",
       "      <td>pgarcia.juanc@gmail.com</td>\n",
       "      <td>[&lt;p&gt;-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...</td>\n",
       "      <td>Tue, 19 Apr 2022 18:41:10 +0000 (UTC)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1804320e63897895</td>\n",
       "      <td>multipart/alternative</td>\n",
       "      <td>ecu</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-04-19</td>\n",
       "      <td>2.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[Match(start=1289, end=1299, dist=0, matched='...</td>\n",
       "      <td>nan</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                       inmobiliaria      fecha  \\\n",
       "6                           heredia 2022-02-18   \n",
       "49             raices puerto madero 2021-09-12   \n",
       "17        inmobiliaria sergio andre 2022-04-18   \n",
       "15                          heredia 2022-02-18   \n",
       "5         administracion capogrosso 2022-04-06   \n",
       "7                     grupo habitat 2022-02-19   \n",
       "3             luque ospina y cia sa 2022-04-18   \n",
       "10  vivir bien propiedad raiz s.a.s 2022-04-12   \n",
       "8       inmobiliaria la heredad sas 2021-10-29   \n",
       "11  espacio inmobiliario & cia ltda 2022-04-08   \n",
       "13                inmoreinversiones 2022-03-23   \n",
       "0                crear inmobiliaria 2022-04-02   \n",
       "18  vivir bien propiedad raiz s.a.s 2022-04-02   \n",
       "4   vivir bien propiedad raiz s.a.s 2021-10-09   \n",
       "22   servicio integral inmobiliario 2021-11-13   \n",
       "18       evaluaciones inmobiliarias 2022-03-20   \n",
       "0             century 21 innovation 2022-04-12   \n",
       "2               century 21 imperial 2022-04-04   \n",
       "\n",
       "                                                 link      municipio  \\\n",
       "6   properati.com.ar/detalle/4ae45_alquiler_depart...           caba   \n",
       "49  properati.com.ar/detalle/3z6bc_alquiler_depart...           caba   \n",
       "17  properati.com.ar/detalle/4foc6_alquiler_depart...     jose_c_paz   \n",
       "15  properati.com.ar/detalle/4adue_alquiler_depart...  vicente_lopez   \n",
       "5   properati.com.ar/detalle/4eukm_alquiler_depart...        rosario   \n",
       "7   properati.com.co/detalle/2kqd7_arriendo_aparta...          bello   \n",
       "3   properati.com.co/detalle/2qqfi_arriendo_aparta...         bogota   \n",
       "10  properati.com.co/detalle/2qg2w_arriendo_aparta...       sabaneta   \n",
       "8   properati.com.co/detalle/2hsag_arriendo_aparta...     copacabana   \n",
       "11  properati.com.co/detalle/2qb4n_arriendo_aparta...         bogota   \n",
       "13  properati.com.co/detalle/2pbw1_arriendo_aparta...         bogota   \n",
       "0   properati.com.co/detalle/2q23r_arriendo_aparta...         bogota   \n",
       "18  properati.com.co/detalle/2q2lf_arriendo_aparta...         itagui   \n",
       "4   properati.com.co/detalle/2hb58_arriendo_aparta...       envigado   \n",
       "22  properati.com.co/detalle/2i7ih_arriendo_aparta...         bogota   \n",
       "18  properati.com.co/detalle/2p7qo_arriendo_aparta...         bogota   \n",
       "0   properati.com.ec/detalle/eiv7_alquiler_departa...      guayaquil   \n",
       "2   properati.com.ec/detalle/egfk_alquiler_departa...          quito   \n",
       "\n",
       "                   ciudad pais_x  \\\n",
       "6   buenos aires ampliado    arg   \n",
       "49  buenos aires ampliado    arg   \n",
       "17  buenos aires ampliado    arg   \n",
       "15  buenos aires ampliado    arg   \n",
       "5        rosario ampliado    arg   \n",
       "7       medellin ampliado    col   \n",
       "3         bogota ampliado    col   \n",
       "10      medellin ampliado    col   \n",
       "8       medellin ampliado    col   \n",
       "11        bogota ampliado    col   \n",
       "13        bogota ampliado    col   \n",
       "0         bogota ampliado    col   \n",
       "18      medellin ampliado    col   \n",
       "4       medellin ampliado    col   \n",
       "22        bogota ampliado    col   \n",
       "18        bogota ampliado    col   \n",
       "0      guayaquil ampliado    ecu   \n",
       "2          quito ampliado    ecu   \n",
       "\n",
       "                                          descripcion     precio moneda  \\\n",
       "6   edificio de 14 pisos, 5 departamentos por piso...    32000.0      $   \n",
       "49  se trata de un departamento en el edificio kav...      900.0    usd   \n",
       "17  departamento dos ambientes con lavadero y coch...    35000.0      $   \n",
       "15  edificio de 9 pisos, 4 departamentos por piso,...    40000.0      $   \n",
       "5   descripcion: es un departamento semipiso. con ...    38000.0      $   \n",
       "7   apto 52 mts, 2 alcobas, 1 closet, 1 bano, sala...  1200000.0      $   \n",
       "3   luque ospina ofrece en arrendamiento apartamen...  1430400.0      $   \n",
       "10  arrienda hermoso apto de 80 mts con 3 alcobas ...  2200000.0      $   \n",
       "8   hermoso apartamento de 70mts en el sector de c...  1175000.0      $   \n",
       "11  apartamento de 61 mts2 piso 6, sol de la manan...  1250000.0      $   \n",
       "13  hermoso apartamento para estrenar, excelente u...  1850000.0      $   \n",
       "0   espectacular apartamento ubicado en chapinero ...  4100000.0      $   \n",
       "18  arrienda apto en unidad cerrada en itagui de 3...  1300000.0      $   \n",
       "4   arrienda apto en envigado barrio el trianon de...  1100000.0      $   \n",
       "22  excelente apto muy iluminado ideal para famili...  1315000.0      $   \n",
       "18  se alquila apto full amoblado en bogota  la so...  2400000.0      $   \n",
       "0   alquilo moderno apartamento en torres del jard...      680.0      $   \n",
       "2   rento departamento de 2 habitaciones   c. c. e...      550.0      $   \n",
       "\n",
       "                                caracteristicas  ambientes  habitaciones  \\\n",
       "6                                                      NaN           NaN   \n",
       "49                                                     NaN           NaN   \n",
       "17      ['2ambientes', '1bano', '40 m²totales']        2.0           NaN   \n",
       "15                                                     NaN           NaN   \n",
       "5       ['2ambientes', '1bano', '43 m²totales']        2.0           NaN   \n",
       "7    ['2habitaciones', '1bano', '52 m²totales']        NaN           2.0   \n",
       "3     ['1habitacion', '2banos', '60 m²totales']        NaN           1.0   \n",
       "10  ['3habitaciones', '2banos', '80 m²totales']        NaN           3.0   \n",
       "8   ['3habitaciones', '2banos', '70 m²totales']        NaN           3.0   \n",
       "11                  ['3habitaciones', '2banos']        NaN           3.0   \n",
       "13  ['3habitaciones', '3banos', '88 m²totales']        NaN           3.0   \n",
       "0                   ['3habitaciones', '3banos']        NaN           3.0   \n",
       "18  ['3habitaciones', '2banos', '60 m²totales']        NaN           3.0   \n",
       "4   ['3habitaciones', '2banos', '70 m²totales']        NaN           3.0   \n",
       "22  ['3habitaciones', '2banos', '64 m²totales']        NaN           3.0   \n",
       "18                     ['1habitacion', '1bano']        NaN           1.0   \n",
       "0                   ['3habitaciones', '2banos']        NaN           3.0   \n",
       "2                   ['2habitaciones', '2banos']        NaN           2.0   \n",
       "\n",
       "    banos  m2_totales  m2_cubiertos cocheras    id  precio_local  \\\n",
       "6     NaN         NaN           NaN            150       32000.0   \n",
       "49    NaN         NaN           NaN           1373      174150.0   \n",
       "17    1.0        40.0           NaN           6070       35000.0   \n",
       "15    NaN         NaN           NaN            194       40000.0   \n",
       "5     1.0        43.0           NaN           9364       38000.0   \n",
       "7     1.0        52.0           NaN      NaN  1172     1200000.0   \n",
       "3     2.0        60.0           NaN      NaN  a578     1430400.0   \n",
       "10    2.0        80.0           NaN      NaN  1237     2200000.0   \n",
       "8     2.0        70.0           NaN      NaN  9842     1175000.0   \n",
       "11    2.0         NaN           NaN      NaN  a213     1250000.0   \n",
       "13    3.0        88.0           NaN      NaN   a24     1850000.0   \n",
       "0     3.0         NaN           NaN      NaN  a101     4100000.0   \n",
       "18    2.0        60.0           NaN      NaN  1240     1300000.0   \n",
       "4     2.0        70.0           NaN      NaN  1065     1100000.0   \n",
       "22    2.0        64.0           NaN      NaN  a137     1315000.0   \n",
       "18    1.0         NaN           NaN      NaN  a564     2400000.0   \n",
       "0     2.0         NaN           NaN      NaN  6170         680.0   \n",
       "2     2.0         NaN           NaN      NaN  6216         550.0   \n",
       "\n",
       "            p_m2  p_m2_above_mdn  n_adds  n_adds_above_mdn  m2_above_mdn  \\\n",
       "6            NaN             NaN     5.0               1.0           NaN   \n",
       "49           NaN             NaN     1.0               0.0           NaN   \n",
       "17    875.000000             0.0     8.0               1.0           0.0   \n",
       "15           NaN             NaN     5.0               1.0           NaN   \n",
       "5     883.720947             0.0     2.0               0.0           0.0   \n",
       "7   23076.923828             0.0     1.0               0.0           0.0   \n",
       "3   23840.000000             0.0    26.0               1.0           0.0   \n",
       "10  27500.000000             1.0    17.0               1.0           1.0   \n",
       "8   16785.714844             0.0    22.0               1.0           0.0   \n",
       "11           NaN             NaN    16.0               1.0           NaN   \n",
       "13  21022.726562             0.0     5.0               1.0           1.0   \n",
       "0            NaN             NaN     2.0               0.0           NaN   \n",
       "18  21666.666016             0.0    17.0               1.0           0.0   \n",
       "4   15714.286133             0.0    17.0               1.0           0.0   \n",
       "22  20546.875000             0.0    10.0               1.0           0.0   \n",
       "18           NaN             NaN     1.0               0.0           NaN   \n",
       "0            NaN             NaN    15.0               1.0           NaN   \n",
       "2            NaN             NaN     5.0               1.0           NaN   \n",
       "\n",
       "    common_name  capital treatment      ses male_name  \\\n",
       "6           2.0      1.0    hetero     high     Pablo   \n",
       "49          1.0      1.0    hetero  neutral    Manuel   \n",
       "17          1.0      0.0      homo  neutral    Manuel   \n",
       "15          2.0      0.0     trans  neutral     Pablo   \n",
       "5           1.0      0.0     trans  neutral    Manuel   \n",
       "7           1.0      0.0    hetero     high      José   \n",
       "3           1.0      1.0    hetero  neutral    Carlos   \n",
       "10          3.0      0.0      homo     high      José   \n",
       "8           6.0      0.0      homo     high      José   \n",
       "11          2.0      1.0      homo     high      José   \n",
       "13          1.0      1.0      homo  neutral    Carlos   \n",
       "0           1.0      1.0      homo  neutral      José   \n",
       "18          3.0      0.0      homo  neutral      José   \n",
       "4           3.0      0.0     trans     high      José   \n",
       "22          1.0      1.0     trans  neutral    Carlos   \n",
       "18          1.0      1.0     trans  neutral    Carlos   \n",
       "0           1.0      0.0    hetero  neutral      Juan   \n",
       "2           1.0      1.0      homo     high      Juan   \n",
       "\n",
       "                             mail male_couple female_couple  script  \\\n",
       "6         gomez.pablo.u@gmail.com        Juan         María     1.0   \n",
       "49  jf.manuel.rodriguez@gmail.com        Luis         Laura     1.0   \n",
       "17   jcmanuel.rodriguez@gmail.com        Luis                   2.0   \n",
       "15       gomez.fh.pablo@gmail.com        Luis         María     1.0   \n",
       "5   rodriguez.manuel.jf@gmail.com       Pablo         María     2.0   \n",
       "7       wjoserodriguezp@gmail.com        Luis         María     1.0   \n",
       "3    carlos.mz.gonzalez@gmail.com        José           Luz     1.0   \n",
       "10     rodriguezljose.c@gmail.com        Luis                   2.0   \n",
       "8      rodriguezljose.c@gmail.com      Carlos                   1.0   \n",
       "11    rodriguezl.jose.c@gmail.com        Luis                   2.0   \n",
       "13    carlos.gonzalezxw@gmail.com        Luis                   2.0   \n",
       "0      rodriguez.mjosev@gmail.com      Carlos                   1.0   \n",
       "18    rodriguez.mjose.v@gmail.com        Juan                   1.0   \n",
       "4      josefrodriguez.u@gmail.com        Juan        Mónica     2.0   \n",
       "22    wgonzalezcarlos.p@gmail.com        Luis           Ana     1.0   \n",
       "18    wgonzalezcarlos.p@gmail.com        Luis           Luz     2.0   \n",
       "0         juanpw.garcia@gmail.com        Luis          Rosa     2.0   \n",
       "2         pgarcia.juanc@gmail.com        Luis                   2.0   \n",
       "\n",
       "                                        script_string  \\\n",
       "6   Buenos días, mi nombre es Pablo, junto a mi pa...   \n",
       "49  Buenos días, mi nombre es Manuel, junto a mi p...   \n",
       "17  Hola, somos una pareja interesada en alquilar ...   \n",
       "15  Buenos días, mi nombre es Pablo, junto a mi pa...   \n",
       "5   Hola, somos una pareja interesada en alquilar ...   \n",
       "7   Buenos días, mi nombre es José, junto a mi par...   \n",
       "3   Buenos días, mi nombre es Carlos, junto a mi p...   \n",
       "10  Hola, somos una pareja interesada en arrendar ...   \n",
       "8   Buenos días, mi nombre es José, junto a mi par...   \n",
       "11  Hola, somos una pareja interesada en arrendar ...   \n",
       "13  Hola, somos una pareja interesada en arrendar ...   \n",
       "0   Buenos días, mi nombre es José, junto a mi par...   \n",
       "18  Buenos días, mi nombre es José, junto a mi par...   \n",
       "4   Hola, somos una pareja interesada en arrendar ...   \n",
       "22  Buenos días, mi nombre es Carlos, junto a mi p...   \n",
       "18  Hola, somos una pareja interesada en arrendar ...   \n",
       "0   Hola, somos una pareja interesada en alquilar ...   \n",
       "2   Hola, somos una pareja interesada en alquilar ...   \n",
       "\n",
       "                   script_string_2 script_string_3  randomization_seed nombre  \\\n",
       "6                   Pablo y María.      Código 150                23.0    NaN   \n",
       "49                 Manuel y Laura.     Código 1373                23.0    NaN   \n",
       "17                   Manuel y Luis     Código 6070                23.0    NaN   \n",
       "15                  Pablo y María.      Código 194                23.0    NaN   \n",
       "5   Manuel y María (ella es trans)     Código 9364                23.0    NaN   \n",
       "7                    José y María.     Código 1172                35.0    NaN   \n",
       "3                    Carlos y Luz.     Código a578                35.0    NaN   \n",
       "10                     José y Luis     Código 1237                35.0    NaN   \n",
       "8                   José y Carlos.     Código 9842                35.0    NaN   \n",
       "11                     José y Luis     Código a213                35.0    NaN   \n",
       "13                   Carlos y Luis      Código a24                35.0    NaN   \n",
       "0                   José y Carlos.     Código a101                35.0    NaN   \n",
       "18                    José y Juan.     Código 1240                35.0    NaN   \n",
       "4    José y Mónica (ella es trans)     Código 1065                35.0    NaN   \n",
       "22                   Carlos y Ana.     Código a137                35.0    NaN   \n",
       "18    Carlos y Luz (ella es trans)     Código a564                35.0    NaN   \n",
       "0                      Juan y Rosa     Código 6170                26.0    NaN   \n",
       "2                      Juan y Luis     Código 6216                26.0    NaN   \n",
       "\n",
       "   nombre_2  profesional  vivienda  n_adds_muni  n_adds_muni_above_mdn  \\\n",
       "6       NaN          NaN       NaN          NaN                    NaN   \n",
       "49      NaN          NaN       NaN          NaN                    NaN   \n",
       "17      NaN          NaN       NaN          NaN                    NaN   \n",
       "15      NaN          NaN       NaN          NaN                    NaN   \n",
       "5       NaN          NaN       NaN          NaN                    NaN   \n",
       "7       NaN          NaN       NaN          NaN                    NaN   \n",
       "3       NaN          NaN       NaN          NaN                    NaN   \n",
       "10      NaN          NaN       NaN          NaN                    NaN   \n",
       "8       NaN          NaN       NaN          NaN                    NaN   \n",
       "11      NaN          NaN       NaN          NaN                    NaN   \n",
       "13      NaN          NaN       NaN          NaN                    NaN   \n",
       "0       NaN          NaN       NaN          NaN                    NaN   \n",
       "18      NaN          NaN       NaN          NaN                    NaN   \n",
       "4       NaN          NaN       NaN          NaN                    NaN   \n",
       "22      NaN          NaN       NaN          NaN                    NaN   \n",
       "18      NaN          NaN       NaN          NaN                    NaN   \n",
       "0       NaN          NaN       NaN          NaN                    NaN   \n",
       "2       NaN          NaN       NaN          NaN                    NaN   \n",
       "\n",
       "    random  index_rtas  match_confiab_x  match_step_x  Unnamed: 0  \\\n",
       "6      NaN         6.0            100.0           1.0          92   \n",
       "49     NaN        49.0            100.0           1.0        2243   \n",
       "17     NaN        17.0            100.0           1.0        2639   \n",
       "15     NaN        15.0            100.0           1.0        1469   \n",
       "5      NaN         5.0            100.0           1.0        3165   \n",
       "7      NaN         7.0            100.0           1.0        4090   \n",
       "3      NaN         3.0            100.0           1.0        3511   \n",
       "10     NaN        10.0            100.0           1.0        4329   \n",
       "8      NaN         8.0            100.0           1.0        4323   \n",
       "11     NaN        11.0            100.0           1.0        4325   \n",
       "13     NaN        13.0            100.0           1.0        3796   \n",
       "0      NaN         0.0            100.0           1.0        4342   \n",
       "18     NaN        18.0            100.0           1.0        4446   \n",
       "4      NaN         4.0            100.0           1.0        4516   \n",
       "22     NaN        22.0            100.0           1.0        4015   \n",
       "18     NaN        18.0            100.0           1.0        4000   \n",
       "0      NaN         0.0            100.0           1.0        5039   \n",
       "2      NaN         2.0            100.0           1.0        5108   \n",
       "\n",
       "                                              subject  \\\n",
       "6   Hiciste una consulta por la propiedad Neuquen 602   \n",
       "49  Hiciste una consulta por la propiedad Florida ...   \n",
       "17  Hiciste una consulta por la propiedad Arenales...   \n",
       "15  Hiciste una consulta por la propiedad Sanchez ...   \n",
       "5   Hiciste una consulta por la propiedad Alsina 1174   \n",
       "7   Hiciste una consulta por la propiedad Apartame...   \n",
       "3   Hiciste una consulta por la propiedad Apartame...   \n",
       "10  Hiciste una consulta por la propiedad Apartame...   \n",
       "8   Hiciste una consulta por la propiedad Apartame...   \n",
       "11  Hiciste una consulta por la propiedad Apartame...   \n",
       "13  Hiciste una consulta por la propiedad Apartame...   \n",
       "0   Hiciste una consulta por la propiedad Apartame...   \n",
       "18  Hiciste una consulta por la propiedad Apartame...   \n",
       "4   Hiciste una consulta por la propiedad Apartame...   \n",
       "22  Hiciste una consulta por la propiedad Apartame...   \n",
       "18  Hiciste una consulta por la propiedad Apartaes...   \n",
       "0   Hiciste una consulta por la propiedad Las Cumbres   \n",
       "2   Hiciste una consulta por la propiedad Alonso D...   \n",
       "\n",
       "                                             from  \\\n",
       "6   Properati <contacts@mailing.properati.com.ar>   \n",
       "49  Properati <contacts@mailing.properati.com.ar>   \n",
       "17  Properati <contacts@mailing.properati.com.ar>   \n",
       "15  Properati <contacts@mailing.properati.com.ar>   \n",
       "5   Properati <contacts@mailing.properati.com.ar>   \n",
       "7      Properati <contacts@mailing.properati.com>   \n",
       "3      Properati <contacts@mailing.properati.com>   \n",
       "10     Properati <contacts@mailing.properati.com>   \n",
       "8      Properati <contacts@mailing.properati.com>   \n",
       "11     Properati <contacts@mailing.properati.com>   \n",
       "13     Properati <contacts@mailing.properati.com>   \n",
       "0      Properati <contacts@mailing.properati.com>   \n",
       "18     Properati <contacts@mailing.properati.com>   \n",
       "4      Properati <contacts@mailing.properati.com>   \n",
       "22     Properati <contacts@mailing.properati.com>   \n",
       "18     Properati <contacts@mailing.properati.com>   \n",
       "0      Properati <contacts@mailing.properati.com>   \n",
       "2      Properati <contacts@mailing.properati.com>   \n",
       "\n",
       "                               to  \\\n",
       "6         gomez.pablo.u@gmail.com   \n",
       "49  jf.manuel.rodriguez@gmail.com   \n",
       "17   jcmanuel.rodriguez@gmail.com   \n",
       "15       gomez.fh.pablo@gmail.com   \n",
       "5   rodriguez.manuel.jf@gmail.com   \n",
       "7       wjoserodriguezp@gmail.com   \n",
       "3    carlos.mz.gonzalez@gmail.com   \n",
       "10     rodriguezljose.c@gmail.com   \n",
       "8      rodriguezljose.c@gmail.com   \n",
       "11    rodriguezl.jose.c@gmail.com   \n",
       "13    carlos.gonzalezxw@gmail.com   \n",
       "0      rodriguez.mjosev@gmail.com   \n",
       "18    rodriguez.mjose.v@gmail.com   \n",
       "4      josefrodriguez.u@gmail.com   \n",
       "22    wgonzalezcarlos.p@gmail.com   \n",
       "18    wgonzalezcarlos.p@gmail.com   \n",
       "0         juanpw.garcia@gmail.com   \n",
       "2         pgarcia.juanc@gmail.com   \n",
       "\n",
       "                                                 body  \\\n",
       "6   [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "49  [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "17  [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "15  [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "5   [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "7   [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "3   [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "10  [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "8   [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "11  [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "13  [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "0   [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "18  [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "4   [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "22  [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "18  [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "0   [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "2   [<p>-- SOLICITUD DE ENTREVISTA --\\r\\n\\r\\n*DATO...   \n",
       "\n",
       "                                     date  cc         thread_id  \\\n",
       "6   Tue, 19 Apr 2022 16:59:01 +0000 (UTC) NaN  18042c36649755f4   \n",
       "49  Tue, 19 Apr 2022 16:31:36 +0000 (UTC) NaN  18042aa4a41e721a   \n",
       "17  Wed, 20 Apr 2022 14:24:31 +0000 (UTC) NaN  180475c4af0edc24   \n",
       "15  Wed, 20 Apr 2022 17:52:19 +0000 (UTC) NaN  180481a8a38daedc   \n",
       "5   Wed, 20 Apr 2022 17:55:54 +0000 (UTC) NaN  180481dd04110cfc   \n",
       "7   Tue, 19 Apr 2022 18:07:21 +0000 (UTC) NaN  1804301ee86fb295   \n",
       "3   Tue, 19 Apr 2022 20:03:50 +0000 (UTC) NaN  18043173399b0d7d   \n",
       "10  Tue, 19 Apr 2022 20:04:36 +0000 (UTC) NaN  180436d49926c268   \n",
       "8   Tue, 19 Apr 2022 20:05:28 +0000 (UTC) NaN  180436d49926c268   \n",
       "11  Tue, 19 Apr 2022 20:05:16 +0000 (UTC) NaN  180436de5a758cb7   \n",
       "13  Tue, 19 Apr 2022 20:10:25 +0000 (UTC) NaN  1804372472dc4439   \n",
       "0   Mon, 25 Apr 2022 16:22:17 +0000 (UTC) NaN  1806187e72bbbf68   \n",
       "18  Tue, 19 Apr 2022 20:10:25 +0000 (UTC) NaN  18043729f468a39e   \n",
       "4   Wed, 20 Apr 2022 15:29:46 +0000 (UTC) NaN  18047980aae821f2   \n",
       "22  Wed, 20 Apr 2022 15:32:03 +0000 (UTC) NaN  1804798fb938eddd   \n",
       "18  Wed, 20 Apr 2022 15:35:53 +0000 (UTC) NaN  180479d9f2a13b51   \n",
       "0   Tue, 19 Apr 2022 18:37:00 +0000 (UTC) NaN  180431d16f19228b   \n",
       "2   Tue, 19 Apr 2022 18:41:10 +0000 (UTC) NaN  1804320e63897895   \n",
       "\n",
       "                 mimeType pais_y  conf_envio  date_clean  index_scrap  \\\n",
       "6   multipart/alternative    arg        True  2022-04-19         21.0   \n",
       "49  multipart/alternative    arg        True  2022-04-19         23.0   \n",
       "17  multipart/alternative    arg        True  2022-04-20         26.0   \n",
       "15  multipart/alternative    arg        True  2022-04-20         29.0   \n",
       "5   multipart/alternative    arg        True  2022-04-20         31.0   \n",
       "7   multipart/alternative    col        True  2022-04-19          3.0   \n",
       "3   multipart/alternative    col        True  2022-04-19         19.0   \n",
       "10  multipart/alternative    col        True  2022-04-19          0.0   \n",
       "8   multipart/alternative    col        True  2022-04-19          2.0   \n",
       "11  multipart/alternative    col        True  2022-04-19          0.0   \n",
       "13  multipart/alternative    col        True  2022-04-19          8.0   \n",
       "0   multipart/alternative    col        True  2022-04-25         10.0   \n",
       "18  multipart/alternative    col        True  2022-04-19          3.0   \n",
       "4   multipart/alternative    col        True  2022-04-20         10.0   \n",
       "22  multipart/alternative    col        True  2022-04-20          1.0   \n",
       "18  multipart/alternative    col        True  2022-04-20          5.0   \n",
       "0   multipart/alternative    ecu        True  2022-04-19          8.0   \n",
       "2   multipart/alternative    ecu        True  2022-04-19          2.0   \n",
       "\n",
       "    match_confiab_y  match_step_y  \\\n",
       "6             100.0           1.0   \n",
       "49            100.0           1.0   \n",
       "17            100.0           1.0   \n",
       "15            100.0           1.0   \n",
       "5             100.0           1.0   \n",
       "7             100.0           1.0   \n",
       "3             100.0           1.0   \n",
       "10            100.0           1.0   \n",
       "8             100.0           1.0   \n",
       "11            100.0           1.0   \n",
       "13            100.0           1.0   \n",
       "0             100.0           1.0   \n",
       "18            100.0           1.0   \n",
       "4             100.0           1.0   \n",
       "22            100.0           1.0   \n",
       "18            100.0           1.0   \n",
       "0             100.0           1.0   \n",
       "2             100.0           1.0   \n",
       "\n",
       "                                         match_string match2_string _merge  \n",
       "6   [Match(start=1410, end=1419, dist=0, matched='...           nan   both  \n",
       "49  [Match(start=1365, end=1375, dist=0, matched='...           nan   both  \n",
       "17  [Match(start=1255, end=1265, dist=0, matched='...           nan   both  \n",
       "15  [Match(start=1273, end=1282, dist=0, matched='...           nan   both  \n",
       "5   [Match(start=1261, end=1271, dist=0, matched='...           nan   both  \n",
       "7   [Match(start=1341, end=1351, dist=0, matched='...           nan   both  \n",
       "3   [Match(start=1398, end=1408, dist=0, matched='...           nan   both  \n",
       "10  [Match(start=1263, end=1273, dist=0, matched='...           nan   both  \n",
       "8   [Match(start=1380, end=1390, dist=0, matched='...           nan   both  \n",
       "11  [Match(start=1400, end=1410, dist=0, matched='...           nan   both  \n",
       "13  [Match(start=1290, end=1299, dist=0, matched='...           nan   both  \n",
       "0   [Match(start=1289, end=1299, dist=0, matched='...           nan   both  \n",
       "18  [Match(start=1280, end=1290, dist=0, matched='...           nan   both  \n",
       "4   [Match(start=1257, end=1267, dist=0, matched='...           nan   both  \n",
       "22  [Match(start=1336, end=1346, dist=0, matched='...           nan   both  \n",
       "18  [Match(start=1303, end=1313, dist=0, matched='...           nan   both  \n",
       "0   [Match(start=1172, end=1182, dist=0, matched='...           nan   both  \n",
       "2   [Match(start=1289, end=1299, dist=0, matched='...           nan   both  "
      ]
     },
     "execution_count": 32,
     "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 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}