google_cloud.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: sqlalchemy in /Users/carlosoliver/miniconda3/envs/flask_env/lib/python3.10/site-packages (2.0.30)\n",
      "Collecting pymysql\n",
      "  Using cached PyMySQL-1.1.1-py3-none-any.whl.metadata (4.4 kB)\n",
      "Requirement already satisfied: typing-extensions>=4.6.0 in /Users/carlosoliver/miniconda3/envs/flask_env/lib/python3.10/site-packages (from sqlalchemy) (4.12.1)\n",
      "Using cached PyMySQL-1.1.1-py3-none-any.whl (44 kB)\n",
      "Installing collected packages: pymysql\n",
      "Successfully installed pymysql-1.1.1\n",
      "Requirement already satisfied: PyMySQL in /Users/carlosoliver/miniconda3/envs/flask_env/lib/python3.10/site-packages (1.1.1)\n"
     ]
    }
   ],
   "source": [
    "#!pip install SQLAlchemy\n",
    "#!pip install mysql-connector-python\n",
    "#!pip install sqlalchemy pymysql\n",
    "#!pip install Faker\n",
    "#!pip install PyMySQL"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from sqlalchemy import create_engine, text\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "db_user = 'app'\n",
    "db_password = '**'\n",
    "db_host = '****'\n",
    "db_port = '**'\n",
    "db_name = '****'\n",
    "# Crear la cadena de conexión\n",
    "churro = f'mysql+pymysql://{db_user}:{db_password}@{db_host}:{db_port}/{db_name}'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "engine = create_engine(churro)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "  Tables_in_mysql_app\n",
      "0      Availabilities\n",
      "1              Events\n",
      "2           Feedbacks\n",
      "3            Meetings\n",
      "4            Partners\n",
      "5       SequelizeMeta\n",
      "6            Speakers\n",
      "7           Summaries\n",
      "8               Users\n"
     ]
    }
   ],
   "source": [
    "query = \"SHOW TABLES;\"\n",
    "tables = pd.read_sql(query, engine)\n",
    "print(tables)"
   ]
  },
  {
   "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>id</th>\n",
       "      <th>tipo_evento</th>\n",
       "      <th>titulo</th>\n",
       "      <th>speaker_id</th>\n",
       "      <th>tematica</th>\n",
       "      <th>duracion_min</th>\n",
       "      <th>sala</th>\n",
       "      <th>fecha</th>\n",
       "      <th>descripcion</th>\n",
       "      <th>interes</th>\n",
       "      <th>numero_asistentes</th>\n",
       "      <th>hora_inicio</th>\n",
       "      <th>hora_fin</th>\n",
       "      <th>createdAt</th>\n",
       "      <th>updatedAt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Conferencia</td>\n",
       "      <td>Tech Summit 2024</td>\n",
       "      <td>101</td>\n",
       "      <td>Tecnología</td>\n",
       "      <td>45</td>\n",
       "      <td>Sala A</td>\n",
       "      <td>2024-09-15</td>\n",
       "      <td>Annual technology summit</td>\n",
       "      <td>Todo</td>\n",
       "      <td>500</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>09:45:00</td>\n",
       "      <td>2024-06-24 10:46:26.180054</td>\n",
       "      <td>2024-06-24 10:46:26.180059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Taller</td>\n",
       "      <td>AI Workshop</td>\n",
       "      <td>102</td>\n",
       "      <td>Inteligencia Artificial</td>\n",
       "      <td>50</td>\n",
       "      <td>Sala B</td>\n",
       "      <td>2024-08-20</td>\n",
       "      <td>Introduction to AI and ML</td>\n",
       "      <td>Accesibilidad</td>\n",
       "      <td>100</td>\n",
       "      <td>10:00:00</td>\n",
       "      <td>10:50:00</td>\n",
       "      <td>2024-06-24 10:46:26.180054</td>\n",
       "      <td>2024-06-24 10:46:26.180059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Conferencia</td>\n",
       "      <td>Data Analytics Webinar</td>\n",
       "      <td>103</td>\n",
       "      <td>Analítica de Datos</td>\n",
       "      <td>55</td>\n",
       "      <td>Sala A</td>\n",
       "      <td>2024-07-10</td>\n",
       "      <td>Webinar on data analytics</td>\n",
       "      <td>Analítica</td>\n",
       "      <td>150</td>\n",
       "      <td>11:00:00</td>\n",
       "      <td>11:55:00</td>\n",
       "      <td>2024-06-24 10:46:26.180054</td>\n",
       "      <td>2024-06-24 10:46:26.180059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Taller</td>\n",
       "      <td>Accessibility Seminar</td>\n",
       "      <td>104</td>\n",
       "      <td>Accesibilidad</td>\n",
       "      <td>40</td>\n",
       "      <td>Sala B</td>\n",
       "      <td>2024-06-05</td>\n",
       "      <td>Seminar on accessibility in technology</td>\n",
       "      <td>Antiplagio</td>\n",
       "      <td>75</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>12:40:00</td>\n",
       "      <td>2024-06-24 10:46:26.180054</td>\n",
       "      <td>2024-06-24 10:46:26.180059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Conferencia</td>\n",
       "      <td>Plagiarism Prevention Conference</td>\n",
       "      <td>105</td>\n",
       "      <td>Prevención de Plagio</td>\n",
       "      <td>35</td>\n",
       "      <td>Sala A</td>\n",
       "      <td>2024-05-15</td>\n",
       "      <td>Conference on anti-plagiarism strategies</td>\n",
       "      <td>Certificación</td>\n",
       "      <td>50</td>\n",
       "      <td>13:00:00</td>\n",
       "      <td>13:35:00</td>\n",
       "      <td>2024-06-24 10:46:26.180054</td>\n",
       "      <td>2024-06-24 10:46:26.180059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>Taller</td>\n",
       "      <td>Certification Workshop</td>\n",
       "      <td>106</td>\n",
       "      <td>Certificación</td>\n",
       "      <td>30</td>\n",
       "      <td>Sala B</td>\n",
       "      <td>2024-04-20</td>\n",
       "      <td>Workshop on certification processes</td>\n",
       "      <td>Contenidos</td>\n",
       "      <td>80</td>\n",
       "      <td>14:00:00</td>\n",
       "      <td>14:30:00</td>\n",
       "      <td>2024-06-24 10:46:26.180054</td>\n",
       "      <td>2024-06-24 10:46:26.180059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>Conferencia</td>\n",
       "      <td>Content Creation Webinar</td>\n",
       "      <td>107</td>\n",
       "      <td>Creación de Contenidos</td>\n",
       "      <td>25</td>\n",
       "      <td>Sala A</td>\n",
       "      <td>2024-03-10</td>\n",
       "      <td>Webinar on creating engaging content</td>\n",
       "      <td>Generación de Vídeo</td>\n",
       "      <td>120</td>\n",
       "      <td>15:00:00</td>\n",
       "      <td>15:25:00</td>\n",
       "      <td>2024-06-24 10:46:26.180054</td>\n",
       "      <td>2024-06-24 10:46:26.180059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>Taller</td>\n",
       "      <td>Video Generation Seminar</td>\n",
       "      <td>108</td>\n",
       "      <td>Generación de Video</td>\n",
       "      <td>50</td>\n",
       "      <td>Sala B</td>\n",
       "      <td>2024-02-05</td>\n",
       "      <td>Seminar on video generation technologies</td>\n",
       "      <td>Gestión de la Formación</td>\n",
       "      <td>90</td>\n",
       "      <td>16:00:00</td>\n",
       "      <td>16:50:00</td>\n",
       "      <td>2024-06-24 10:46:26.180054</td>\n",
       "      <td>2024-06-24 10:46:26.180059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>Conferencia</td>\n",
       "      <td>Training Management Conference</td>\n",
       "      <td>109</td>\n",
       "      <td>Gestión de Formación</td>\n",
       "      <td>45</td>\n",
       "      <td>Sala A</td>\n",
       "      <td>2024-01-15</td>\n",
       "      <td>Conference on training management systems</td>\n",
       "      <td>Herramientas de autor</td>\n",
       "      <td>110</td>\n",
       "      <td>17:00:00</td>\n",
       "      <td>17:45:00</td>\n",
       "      <td>2024-06-24 10:46:26.180054</td>\n",
       "      <td>2024-06-24 10:46:26.180059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>Taller</td>\n",
       "      <td>Authoring Tools Workshop</td>\n",
       "      <td>110</td>\n",
       "      <td>Herramientas de Autor</td>\n",
       "      <td>55</td>\n",
       "      <td>Sala B</td>\n",
       "      <td>2024-12-20</td>\n",
       "      <td>Workshop on authoring tools for education</td>\n",
       "      <td>Inteligencia Artificial</td>\n",
       "      <td>130</td>\n",
       "      <td>18:00:00</td>\n",
       "      <td>18:55:00</td>\n",
       "      <td>2024-06-24 10:46:26.180054</td>\n",
       "      <td>2024-06-24 10:46:26.180059</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id  tipo_evento                            titulo  speaker_id  \\\n",
       "0   1  Conferencia                  Tech Summit 2024         101   \n",
       "1   2       Taller                       AI Workshop         102   \n",
       "2   3  Conferencia            Data Analytics Webinar         103   \n",
       "3   4       Taller             Accessibility Seminar         104   \n",
       "4   5  Conferencia  Plagiarism Prevention Conference         105   \n",
       "5   6       Taller            Certification Workshop         106   \n",
       "6   7  Conferencia          Content Creation Webinar         107   \n",
       "7   8       Taller          Video Generation Seminar         108   \n",
       "8   9  Conferencia    Training Management Conference         109   \n",
       "9  10       Taller          Authoring Tools Workshop         110   \n",
       "\n",
       "                  tematica  duracion_min    sala      fecha  \\\n",
       "0               Tecnología            45  Sala A 2024-09-15   \n",
       "1  Inteligencia Artificial            50  Sala B 2024-08-20   \n",
       "2       Analítica de Datos            55  Sala A 2024-07-10   \n",
       "3            Accesibilidad            40  Sala B 2024-06-05   \n",
       "4     Prevención de Plagio            35  Sala A 2024-05-15   \n",
       "5            Certificación            30  Sala B 2024-04-20   \n",
       "6   Creación de Contenidos            25  Sala A 2024-03-10   \n",
       "7      Generación de Video            50  Sala B 2024-02-05   \n",
       "8     Gestión de Formación            45  Sala A 2024-01-15   \n",
       "9    Herramientas de Autor            55  Sala B 2024-12-20   \n",
       "\n",
       "                                 descripcion                  interes  \\\n",
       "0                   Annual technology summit                     Todo   \n",
       "1                  Introduction to AI and ML            Accesibilidad   \n",
       "2                  Webinar on data analytics                Analítica   \n",
       "3     Seminar on accessibility in technology               Antiplagio   \n",
       "4   Conference on anti-plagiarism strategies            Certificación   \n",
       "5        Workshop on certification processes               Contenidos   \n",
       "6       Webinar on creating engaging content      Generación de Vídeo   \n",
       "7   Seminar on video generation technologies  Gestión de la Formación   \n",
       "8  Conference on training management systems    Herramientas de autor   \n",
       "9  Workshop on authoring tools for education  Inteligencia Artificial   \n",
       "\n",
       "   numero_asistentes hora_inicio  hora_fin                  createdAt  \\\n",
       "0                500    09:00:00  09:45:00 2024-06-24 10:46:26.180054   \n",
       "1                100    10:00:00  10:50:00 2024-06-24 10:46:26.180054   \n",
       "2                150    11:00:00  11:55:00 2024-06-24 10:46:26.180054   \n",
       "3                 75    12:00:00  12:40:00 2024-06-24 10:46:26.180054   \n",
       "4                 50    13:00:00  13:35:00 2024-06-24 10:46:26.180054   \n",
       "5                 80    14:00:00  14:30:00 2024-06-24 10:46:26.180054   \n",
       "6                120    15:00:00  15:25:00 2024-06-24 10:46:26.180054   \n",
       "7                 90    16:00:00  16:50:00 2024-06-24 10:46:26.180054   \n",
       "8                110    17:00:00  17:45:00 2024-06-24 10:46:26.180054   \n",
       "9                130    18:00:00  18:55:00 2024-06-24 10:46:26.180054   \n",
       "\n",
       "                   updatedAt  \n",
       "0 2024-06-24 10:46:26.180059  \n",
       "1 2024-06-24 10:46:26.180059  \n",
       "2 2024-06-24 10:46:26.180059  \n",
       "3 2024-06-24 10:46:26.180059  \n",
       "4 2024-06-24 10:46:26.180059  \n",
       "5 2024-06-24 10:46:26.180059  \n",
       "6 2024-06-24 10:46:26.180059  \n",
       "7 2024-06-24 10:46:26.180059  \n",
       "8 2024-06-24 10:46:26.180059  \n",
       "9 2024-06-24 10:46:26.180059  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "from datetime import datetime, timedelta\n",
    "\n",
    "# Crear un diccionario con 10 filas de datos\n",
    "data = {\n",
    "    'id': list(range(1, 11)),\n",
    "    'tipo_evento': ['Conferencia', 'Taller'] * 5,\n",
    "    'titulo': [\n",
    "        'Tech Summit 2024', 'AI Workshop', 'Data Analytics Webinar', 'Accessibility Seminar',\n",
    "        'Plagiarism Prevention Conference', 'Certification Workshop', 'Content Creation Webinar',\n",
    "        'Video Generation Seminar', 'Training Management Conference', 'Authoring Tools Workshop'\n",
    "    ],\n",
    "    'speaker_id': [101, 102, 103, 104, 105, 106, 107, 108, 109, 110],\n",
    "    'tematica': [\n",
    "        'Tecnología', 'Inteligencia Artificial', 'Analítica de Datos', 'Accesibilidad',\n",
    "        'Prevención de Plagio', 'Certificación', 'Creación de Contenidos', 'Generación de Video',\n",
    "        'Gestión de Formación', 'Herramientas de Autor'\n",
    "    ],\n",
    "    'duracion_min': [45, 50, 55, 40, 35, 30, 25, 50, 45, 55],\n",
    "    'sala': ['Sala A', 'Sala B'] * 5,\n",
    "    'fecha': [datetime.strptime(date, '%Y-%m-%d') for date in [\n",
    "        '2024-09-15', '2024-08-20', '2024-07-10', '2024-06-05', '2024-05-15', \n",
    "        '2024-04-20', '2024-03-10', '2024-02-05', '2024-01-15', '2024-12-20'\n",
    "    ]],\n",
    "    'descripcion': [\n",
    "        'Annual technology summit', 'Introduction to AI and ML', 'Webinar on data analytics', \n",
    "        'Seminar on accessibility in technology', 'Conference on anti-plagiarism strategies', \n",
    "        'Workshop on certification processes', 'Webinar on creating engaging content', \n",
    "        'Seminar on video generation technologies', 'Conference on training management systems', \n",
    "        'Workshop on authoring tools for education'\n",
    "    ],\n",
    "    'interes': [\n",
    "        'Todo', 'Accesibilidad', 'Analítica', 'Antiplagio', 'Certificación',\n",
    "        'Contenidos', 'Generación de Vídeo', 'Gestión de la Formación',\n",
    "        'Herramientas de autor', 'Inteligencia Artificial'\n",
    "    ],\n",
    "    'numero_asistentes': [500, 100, 150, 75, 50, 80, 120, 90, 110, 130],\n",
    "    'hora_inicio': [datetime.strptime(hour, '%H:%M').time() for hour in [\n",
    "        '09:00', '10:00', '11:00', '12:00', '13:00', '14:00', '15:00', '16:00', '17:00', '18:00'\n",
    "    ]],\n",
    "    'hora_fin': [(datetime.strptime(hour, '%H:%M') + timedelta(minutes=dur)).time() for hour, dur in zip(\n",
    "        ['09:00', '10:00', '11:00', '12:00', '13:00', '14:00', '15:00', '16:00', '17:00', '18:00'], \n",
    "        [45, 50, 55, 40, 35, 30, 25, 50, 45, 55]\n",
    "    )],\n",
    "    'createdAt': [datetime.now()] * 10,\n",
    "    'updatedAt': [datetime.now()] * 10\n",
    "}\n",
    "\n",
    "# Crear el DataFrame con las filas de datos\n",
    "Events = pd.DataFrame(data)\n",
    "\n",
    "Events\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>user_id</th>\n",
       "      <th>event_id</th>\n",
       "      <th>comentarios</th>\n",
       "      <th>rating</th>\n",
       "      <th>createdAt</th>\n",
       "      <th>updatedAt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>300</td>\n",
       "      <td>8</td>\n",
       "      <td>Las actividades prácticas fueron muy útiles.</td>\n",
       "      <td>5</td>\n",
       "      <td>2024-06-24 10:46:27.220557</td>\n",
       "      <td>2024-06-24 10:46:27.220892</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>219</td>\n",
       "      <td>2</td>\n",
       "      <td>No cumplió mis expectativas.</td>\n",
       "      <td>1</td>\n",
       "      <td>2024-06-24 10:46:27.220562</td>\n",
       "      <td>2024-06-24 10:46:27.220893</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>232</td>\n",
       "      <td>7</td>\n",
       "      <td>Presentadores muy preparados.</td>\n",
       "      <td>3</td>\n",
       "      <td>2024-06-24 10:46:27.220563</td>\n",
       "      <td>2024-06-24 10:46:27.220893</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>266</td>\n",
       "      <td>7</td>\n",
       "      <td>Inspirador y motivador.</td>\n",
       "      <td>2</td>\n",
       "      <td>2024-06-24 10:46:27.220564</td>\n",
       "      <td>2024-06-24 10:46:27.220894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>204</td>\n",
       "      <td>6</td>\n",
       "      <td>Podría ser mejor.</td>\n",
       "      <td>5</td>\n",
       "      <td>2024-06-24 10:46:27.220565</td>\n",
       "      <td>2024-06-24 10:46:27.220895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>495</th>\n",
       "      <td>496</td>\n",
       "      <td>267</td>\n",
       "      <td>11</td>\n",
       "      <td>Poco tiempo para preguntas.</td>\n",
       "      <td>4</td>\n",
       "      <td>2024-06-24 10:46:27.220853</td>\n",
       "      <td>2024-06-24 10:46:27.221188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>496</th>\n",
       "      <td>497</td>\n",
       "      <td>275</td>\n",
       "      <td>1</td>\n",
       "      <td>Claridad en los conceptos.</td>\n",
       "      <td>3</td>\n",
       "      <td>2024-06-24 10:46:27.220854</td>\n",
       "      <td>2024-06-24 10:46:27.221188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>497</th>\n",
       "      <td>498</td>\n",
       "      <td>218</td>\n",
       "      <td>9</td>\n",
       "      <td>Faltó interacción con el público.</td>\n",
       "      <td>4</td>\n",
       "      <td>2024-06-24 10:46:27.220854</td>\n",
       "      <td>2024-06-24 10:46:27.221189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498</th>\n",
       "      <td>499</td>\n",
       "      <td>226</td>\n",
       "      <td>4</td>\n",
       "      <td>El sonido no fue el mejor.</td>\n",
       "      <td>2</td>\n",
       "      <td>2024-06-24 10:46:27.220855</td>\n",
       "      <td>2024-06-24 10:46:27.221189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499</th>\n",
       "      <td>500</td>\n",
       "      <td>281</td>\n",
       "      <td>2</td>\n",
       "      <td>Bien organizado.</td>\n",
       "      <td>5</td>\n",
       "      <td>2024-06-24 10:46:27.220855</td>\n",
       "      <td>2024-06-24 10:46:27.221190</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>500 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      id  user_id  event_id                                   comentarios  \\\n",
       "0      1      300         8  Las actividades prácticas fueron muy útiles.   \n",
       "1      2      219         2                  No cumplió mis expectativas.   \n",
       "2      3      232         7                 Presentadores muy preparados.   \n",
       "3      4      266         7                       Inspirador y motivador.   \n",
       "4      5      204         6                             Podría ser mejor.   \n",
       "..   ...      ...       ...                                           ...   \n",
       "495  496      267        11                   Poco tiempo para preguntas.   \n",
       "496  497      275         1                    Claridad en los conceptos.   \n",
       "497  498      218         9             Faltó interacción con el público.   \n",
       "498  499      226         4                    El sonido no fue el mejor.   \n",
       "499  500      281         2                              Bien organizado.   \n",
       "\n",
       "     rating                  createdAt                  updatedAt  \n",
       "0         5 2024-06-24 10:46:27.220557 2024-06-24 10:46:27.220892  \n",
       "1         1 2024-06-24 10:46:27.220562 2024-06-24 10:46:27.220893  \n",
       "2         3 2024-06-24 10:46:27.220563 2024-06-24 10:46:27.220893  \n",
       "3         2 2024-06-24 10:46:27.220564 2024-06-24 10:46:27.220894  \n",
       "4         5 2024-06-24 10:46:27.220565 2024-06-24 10:46:27.220895  \n",
       "..      ...                        ...                        ...  \n",
       "495       4 2024-06-24 10:46:27.220853 2024-06-24 10:46:27.221188  \n",
       "496       3 2024-06-24 10:46:27.220854 2024-06-24 10:46:27.221188  \n",
       "497       4 2024-06-24 10:46:27.220854 2024-06-24 10:46:27.221189  \n",
       "498       2 2024-06-24 10:46:27.220855 2024-06-24 10:46:27.221189  \n",
       "499       5 2024-06-24 10:46:27.220855 2024-06-24 10:46:27.221190  \n",
       "\n",
       "[500 rows x 7 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "from datetime import datetime\n",
    "import random\n",
    "\n",
    "# Generar datos para 500 muestras\n",
    "ids = list(range(1, 501))\n",
    "user_ids = [random.randint(201, 300) for _ in range(500)]\n",
    "event_ids = [random.randint(1, 18) for _ in range(500)]\n",
    "comentarios = [\n",
    "    'Excelente evento!', 'Muy informativo.', 'Me encantó el contenido.', \n",
    "    'Bien organizado.', 'Podría ser mejor.', 'Experiencia increíble.', \n",
    "    'No fue lo que esperaba.', 'Buenos insights.', 'Muy recomendable.', \n",
    "    'Presentación regular.', 'Información muy útil.', 'Gran calidad en las presentaciones.', \n",
    "    'Interesante y educativo.', 'Mejor de lo que esperaba.', 'Faltó interacción con el público.', \n",
    "    'Contenido muy técnico.', 'Inspirador y motivador.', 'Muy buena logística.', \n",
    "    'Demasiado corto.', 'Debería haber más sesiones como esta.', 'Presentadores muy preparados.', \n",
    "    'Me ayudó mucho en mi trabajo.', 'No aportó mucho valor.', 'Excelente manejo del tema.', \n",
    "    'Muy dinámico.', 'Repetiría la experiencia.', 'Poco tiempo para preguntas.', \n",
    "    'El material de apoyo fue excelente.', 'Demasiada información en poco tiempo.', \n",
    "    'Claridad en los conceptos.', 'El sonido no fue el mejor.', 'Recomendado para todos.',\n",
    "    'Me encantó la interacción.', 'Los tiempos estuvieron bien manejados.', 'Faltó profundidad en algunos temas.',\n",
    "    'La organización fue impecable.', 'Hubo problemas técnicos.', 'Las actividades prácticas fueron muy útiles.',\n",
    "    'No cumplió mis expectativas.', 'El lugar fue adecuado.', 'Se aprendió mucho en poco tiempo.'\n",
    "]\n",
    "ratings = [random.randint(1, 5) for _ in range(500)]\n",
    "created_at = [datetime.now() for _ in range(500)]\n",
    "updated_at = [datetime.now() for _ in range(500)]\n",
    "\n",
    "# Crear el diccionario de datos\n",
    "data_feedbacks = {\n",
    "    'id': ids,\n",
    "    'user_id': user_ids,\n",
    "    'event_id': event_ids,\n",
    "    'comentarios': [random.choice(comentarios) for _ in range(500)],\n",
    "    'rating': ratings,\n",
    "    'createdAt': created_at,\n",
    "    'updatedAt': updated_at\n",
    "}\n",
    "\n",
    "# Crear el DataFrame con las filas de datos\n",
    "Feedbacks = pd.DataFrame(data_feedbacks)\n",
    "\n",
    "Feedbacks\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>partner_id</th>\n",
       "      <th>user_id</th>\n",
       "      <th>fecha</th>\n",
       "      <th>hora_inicio</th>\n",
       "      <th>hora_fin</th>\n",
       "      <th>createdAt</th>\n",
       "      <th>updatedAt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>235</td>\n",
       "      <td>2024-03-10</td>\n",
       "      <td>10:01:00</td>\n",
       "      <td>10:02:00</td>\n",
       "      <td>2024-06-24 10:46:27.891525</td>\n",
       "      <td>2024-06-24 10:46:27.891611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>219</td>\n",
       "      <td>2024-01-03</td>\n",
       "      <td>10:17:00</td>\n",
       "      <td>10:39:00</td>\n",
       "      <td>2024-06-24 10:46:27.891530</td>\n",
       "      <td>2024-06-24 10:46:27.891612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>263</td>\n",
       "      <td>2024-07-15</td>\n",
       "      <td>08:26:00</td>\n",
       "      <td>08:46:00</td>\n",
       "      <td>2024-06-24 10:46:27.891531</td>\n",
       "      <td>2024-06-24 10:46:27.891612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>276</td>\n",
       "      <td>2024-02-10</td>\n",
       "      <td>12:05:00</td>\n",
       "      <td>12:14:00</td>\n",
       "      <td>2024-06-24 10:46:27.891532</td>\n",
       "      <td>2024-06-24 10:46:27.891613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>225</td>\n",
       "      <td>2024-12-17</td>\n",
       "      <td>14:18:00</td>\n",
       "      <td>14:26:00</td>\n",
       "      <td>2024-06-24 10:46:27.891532</td>\n",
       "      <td>2024-06-24 10:46:27.891613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>96</td>\n",
       "      <td>2</td>\n",
       "      <td>230</td>\n",
       "      <td>2024-09-26</td>\n",
       "      <td>12:06:00</td>\n",
       "      <td>12:20:00</td>\n",
       "      <td>2024-06-24 10:46:27.891586</td>\n",
       "      <td>2024-06-24 10:46:27.891667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>97</td>\n",
       "      <td>1</td>\n",
       "      <td>215</td>\n",
       "      <td>2024-12-12</td>\n",
       "      <td>08:19:00</td>\n",
       "      <td>08:49:00</td>\n",
       "      <td>2024-06-24 10:46:27.891586</td>\n",
       "      <td>2024-06-24 10:46:27.891668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>98</td>\n",
       "      <td>2</td>\n",
       "      <td>212</td>\n",
       "      <td>2024-01-12</td>\n",
       "      <td>11:08:00</td>\n",
       "      <td>11:32:00</td>\n",
       "      <td>2024-06-24 10:46:27.891587</td>\n",
       "      <td>2024-06-24 10:46:27.891668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>99</td>\n",
       "      <td>5</td>\n",
       "      <td>299</td>\n",
       "      <td>2024-11-19</td>\n",
       "      <td>15:23:00</td>\n",
       "      <td>15:30:00</td>\n",
       "      <td>2024-06-24 10:46:27.891587</td>\n",
       "      <td>2024-06-24 10:46:27.891669</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>100</td>\n",
       "      <td>8</td>\n",
       "      <td>265</td>\n",
       "      <td>2024-07-08</td>\n",
       "      <td>10:12:00</td>\n",
       "      <td>10:35:00</td>\n",
       "      <td>2024-06-24 10:46:27.891588</td>\n",
       "      <td>2024-06-24 10:46:27.891669</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     id  partner_id  user_id      fecha hora_inicio  hora_fin  \\\n",
       "0     1           3      235 2024-03-10    10:01:00  10:02:00   \n",
       "1     2           7      219 2024-01-03    10:17:00  10:39:00   \n",
       "2     3           6      263 2024-07-15    08:26:00  08:46:00   \n",
       "3     4           6      276 2024-02-10    12:05:00  12:14:00   \n",
       "4     5           7      225 2024-12-17    14:18:00  14:26:00   \n",
       "..  ...         ...      ...        ...         ...       ...   \n",
       "95   96           2      230 2024-09-26    12:06:00  12:20:00   \n",
       "96   97           1      215 2024-12-12    08:19:00  08:49:00   \n",
       "97   98           2      212 2024-01-12    11:08:00  11:32:00   \n",
       "98   99           5      299 2024-11-19    15:23:00  15:30:00   \n",
       "99  100           8      265 2024-07-08    10:12:00  10:35:00   \n",
       "\n",
       "                    createdAt                  updatedAt  \n",
       "0  2024-06-24 10:46:27.891525 2024-06-24 10:46:27.891611  \n",
       "1  2024-06-24 10:46:27.891530 2024-06-24 10:46:27.891612  \n",
       "2  2024-06-24 10:46:27.891531 2024-06-24 10:46:27.891612  \n",
       "3  2024-06-24 10:46:27.891532 2024-06-24 10:46:27.891613  \n",
       "4  2024-06-24 10:46:27.891532 2024-06-24 10:46:27.891613  \n",
       "..                        ...                        ...  \n",
       "95 2024-06-24 10:46:27.891586 2024-06-24 10:46:27.891667  \n",
       "96 2024-06-24 10:46:27.891586 2024-06-24 10:46:27.891668  \n",
       "97 2024-06-24 10:46:27.891587 2024-06-24 10:46:27.891668  \n",
       "98 2024-06-24 10:46:27.891587 2024-06-24 10:46:27.891669  \n",
       "99 2024-06-24 10:46:27.891588 2024-06-24 10:46:27.891669  \n",
       "\n",
       "[100 rows x 8 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "from datetime import datetime, timedelta\n",
    "import random\n",
    "\n",
    "# Generar datos para 100 muestras\n",
    "ids = list(range(1, 101))\n",
    "partner_ids = [random.randint(1, 10) for _ in range(100)]  # Suponiendo que hay 10 partners\n",
    "user_ids = [random.randint(201, 300) for _ in range(100)]\n",
    "fechas = [datetime(2024, random.randint(1, 12), random.randint(1, 28)) for _ in range(100)]\n",
    "\n",
    "# Generar hora de inicio aleatoria entre las 8:00 y las 15:30 para asegurar máximo 30 minutos de duración\n",
    "hora_inicio = [datetime.strptime(f\"{random.randint(8, 15)}:{random.randint(0, 29):02d}\", '%H:%M').time() for _ in range(100)]\n",
    "hora_fin = [datetime.combine(fecha, inicio) + timedelta(minutes=random.randint(1, 30)) for fecha, inicio in zip(fechas, hora_inicio)]\n",
    "\n",
    "created_at = [datetime.now() for _ in range(100)]\n",
    "updated_at = [datetime.now() for _ in range(100)]\n",
    "\n",
    "# Crear el diccionario de datos\n",
    "data_meetings = {\n",
    "    'id': ids,\n",
    "    'partner_id': partner_ids,\n",
    "    'user_id': user_ids,\n",
    "    'fecha': fechas,\n",
    "    'hora_inicio': hora_inicio,\n",
    "    'hora_fin': [fin.time() for fin in hora_fin],  # Extraer solo la hora de fin\n",
    "    'createdAt': created_at,\n",
    "    'updatedAt': updated_at\n",
    "}\n",
    "\n",
    "# Crear el DataFrame con las filas de datos\n",
    "Meetings = pd.DataFrame(data_meetings)\n",
    "\n",
    "Meetings"
   ]
  },
  {
   "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>nombre_empresa</th>\n",
       "      <th>tipo_partnership</th>\n",
       "      <th>id</th>\n",
       "      <th>user_id</th>\n",
       "      <th>pagado</th>\n",
       "      <th>numero_meetings</th>\n",
       "      <th>eventos_participados</th>\n",
       "      <th>industria</th>\n",
       "      <th>importe_pagado</th>\n",
       "      <th>createdAt</th>\n",
       "      <th>updatedAt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SAMOO BY PENTEC</td>\n",
       "      <td>Organizador</td>\n",
       "      <td>1</td>\n",
       "      <td>301</td>\n",
       "      <td>True</td>\n",
       "      <td>5</td>\n",
       "      <td>9</td>\n",
       "      <td>Tecnología</td>\n",
       "      <td>4121</td>\n",
       "      <td>2024-06-24 10:46:28.738887</td>\n",
       "      <td>2024-06-24 10:46:28.741054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>OPEN LMS</td>\n",
       "      <td>Platinum</td>\n",
       "      <td>2</td>\n",
       "      <td>302</td>\n",
       "      <td>True</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>Tecnología</td>\n",
       "      <td>2368</td>\n",
       "      <td>2024-06-24 10:46:28.738887</td>\n",
       "      <td>2024-06-24 10:46:28.741054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>READSPEAKER</td>\n",
       "      <td>Platinum</td>\n",
       "      <td>3</td>\n",
       "      <td>303</td>\n",
       "      <td>True</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>Tecnología</td>\n",
       "      <td>3095</td>\n",
       "      <td>2024-06-24 10:46:28.738887</td>\n",
       "      <td>2024-06-24 10:46:28.741054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SMOWL</td>\n",
       "      <td>Gold</td>\n",
       "      <td>4</td>\n",
       "      <td>304</td>\n",
       "      <td>True</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>Tecnología</td>\n",
       "      <td>2851</td>\n",
       "      <td>2024-06-24 10:46:28.738887</td>\n",
       "      <td>2024-06-24 10:46:28.741054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>LVIS</td>\n",
       "      <td>Gold</td>\n",
       "      <td>5</td>\n",
       "      <td>305</td>\n",
       "      <td>True</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>Tecnología</td>\n",
       "      <td>3166</td>\n",
       "      <td>2024-06-24 10:46:28.738887</td>\n",
       "      <td>2024-06-24 10:46:28.741054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>TOTARA</td>\n",
       "      <td>Gold</td>\n",
       "      <td>6</td>\n",
       "      <td>306</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>Tecnología</td>\n",
       "      <td>1110</td>\n",
       "      <td>2024-06-24 10:46:28.738887</td>\n",
       "      <td>2024-06-24 10:46:28.741054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>ZOOM</td>\n",
       "      <td>Silver</td>\n",
       "      <td>7</td>\n",
       "      <td>307</td>\n",
       "      <td>True</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>Tecnología</td>\n",
       "      <td>4372</td>\n",
       "      <td>2024-06-24 10:46:28.738887</td>\n",
       "      <td>2024-06-24 10:46:28.741054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>ANHOLOGY</td>\n",
       "      <td>Silver</td>\n",
       "      <td>8</td>\n",
       "      <td>308</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>Tecnología</td>\n",
       "      <td>807</td>\n",
       "      <td>2024-06-24 10:46:28.738887</td>\n",
       "      <td>2024-06-24 10:46:28.741054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>ISPRING</td>\n",
       "      <td>Silver</td>\n",
       "      <td>9</td>\n",
       "      <td>309</td>\n",
       "      <td>True</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>Tecnología</td>\n",
       "      <td>1032</td>\n",
       "      <td>2024-06-24 10:46:28.738887</td>\n",
       "      <td>2024-06-24 10:46:28.741054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>COMPILATIO</td>\n",
       "      <td>Silver</td>\n",
       "      <td>10</td>\n",
       "      <td>310</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>Tecnología</td>\n",
       "      <td>3324</td>\n",
       "      <td>2024-06-24 10:46:28.738887</td>\n",
       "      <td>2024-06-24 10:46:28.741054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>OPTIUMASS</td>\n",
       "      <td>Silver</td>\n",
       "      <td>11</td>\n",
       "      <td>311</td>\n",
       "      <td>False</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Tecnología</td>\n",
       "      <td>4971</td>\n",
       "      <td>2024-06-24 10:46:28.738887</td>\n",
       "      <td>2024-06-24 10:46:28.741054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>BEMYVEGA</td>\n",
       "      <td>Silver</td>\n",
       "      <td>12</td>\n",
       "      <td>312</td>\n",
       "      <td>False</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>Tecnología</td>\n",
       "      <td>2355</td>\n",
       "      <td>2024-06-24 10:46:28.738887</td>\n",
       "      <td>2024-06-24 10:46:28.741054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>PANOPTO</td>\n",
       "      <td>Silver</td>\n",
       "      <td>13</td>\n",
       "      <td>313</td>\n",
       "      <td>True</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>Tecnología</td>\n",
       "      <td>2775</td>\n",
       "      <td>2024-06-24 10:46:28.738887</td>\n",
       "      <td>2024-06-24 10:46:28.741054</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     nombre_empresa tipo_partnership  id  user_id  pagado  numero_meetings  \\\n",
       "0   SAMOO BY PENTEC      Organizador   1      301    True                5   \n",
       "1          OPEN LMS         Platinum   2      302    True                6   \n",
       "2       READSPEAKER         Platinum   3      303    True                4   \n",
       "3             SMOWL             Gold   4      304    True                8   \n",
       "4              LVIS             Gold   5      305    True                1   \n",
       "5            TOTARA             Gold   6      306    True                3   \n",
       "6              ZOOM           Silver   7      307    True                9   \n",
       "7          ANHOLOGY           Silver   8      308    True                3   \n",
       "8           ISPRING           Silver   9      309    True                6   \n",
       "9        COMPILATIO           Silver  10      310    True                3   \n",
       "10        OPTIUMASS           Silver  11      311   False                2   \n",
       "11         BEMYVEGA           Silver  12      312   False                3   \n",
       "12          PANOPTO           Silver  13      313    True                1   \n",
       "\n",
       "    eventos_participados   industria  importe_pagado  \\\n",
       "0                      9  Tecnología            4121   \n",
       "1                      5  Tecnología            2368   \n",
       "2                      7  Tecnología            3095   \n",
       "3                      4  Tecnología            2851   \n",
       "4                      3  Tecnología            3166   \n",
       "5                      9  Tecnología            1110   \n",
       "6                      1  Tecnología            4372   \n",
       "7                      7  Tecnología             807   \n",
       "8                      2  Tecnología            1032   \n",
       "9                      4  Tecnología            3324   \n",
       "10                     3  Tecnología            4971   \n",
       "11                     5  Tecnología            2355   \n",
       "12                     5  Tecnología            2775   \n",
       "\n",
       "                    createdAt                  updatedAt  \n",
       "0  2024-06-24 10:46:28.738887 2024-06-24 10:46:28.741054  \n",
       "1  2024-06-24 10:46:28.738887 2024-06-24 10:46:28.741054  \n",
       "2  2024-06-24 10:46:28.738887 2024-06-24 10:46:28.741054  \n",
       "3  2024-06-24 10:46:28.738887 2024-06-24 10:46:28.741054  \n",
       "4  2024-06-24 10:46:28.738887 2024-06-24 10:46:28.741054  \n",
       "5  2024-06-24 10:46:28.738887 2024-06-24 10:46:28.741054  \n",
       "6  2024-06-24 10:46:28.738887 2024-06-24 10:46:28.741054  \n",
       "7  2024-06-24 10:46:28.738887 2024-06-24 10:46:28.741054  \n",
       "8  2024-06-24 10:46:28.738887 2024-06-24 10:46:28.741054  \n",
       "9  2024-06-24 10:46:28.738887 2024-06-24 10:46:28.741054  \n",
       "10 2024-06-24 10:46:28.738887 2024-06-24 10:46:28.741054  \n",
       "11 2024-06-24 10:46:28.738887 2024-06-24 10:46:28.741054  \n",
       "12 2024-06-24 10:46:28.738887 2024-06-24 10:46:28.741054  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "from datetime import datetime\n",
    "\n",
    "# Definir los partners y sus tipos de partnership\n",
    "partners_data = {\n",
    "    'nombre_empresa': ['SAMOO BY PENTEC', 'OPEN LMS', 'READSPEAKER', \n",
    "                       'SMOWL', 'LVIS', 'TOTARA', 'ZOOM', \n",
    "                       'ANHOLOGY', 'ISPRING', 'COMPILATIO', \n",
    "                       'OPTIUMASS', 'BEMYVEGA', 'PANOPTO'],\n",
    "    'tipo_partnership': ['Organizador', 'Platinum', 'Platinum', \n",
    "                         'Gold', 'Gold', 'Gold', \n",
    "                         'Silver', 'Silver', 'Silver', \n",
    "                         'Silver', 'Silver', 'Silver', 'Silver']\n",
    "}\n",
    "\n",
    "# Crear un DataFrame con los datos proporcionados\n",
    "Partners = pd.DataFrame(partners_data)\n",
    "\n",
    "# Agregar columnas adicionales según los requisitos (id, user_id, pagado, numero_meetings, eventos_participados, industria, importe_pagado, createdAt, updatedAt)\n",
    "\n",
    "# Generar datos aleatorios para las columnas adicionales\n",
    "Partners['id'] = range(1, len(Partners) + 1)  # IDs únicos para cada partner\n",
    "Partners['user_id'] = range(301, 301 + len(Partners))  # Suponiendo IDs de usuario únicos para cada partner\n",
    "Partners['pagado'] = [True, True, True, True, True, True, True, True, True, True, False, False, True]  # Suponiendo pagos aleatorios\n",
    "Partners['numero_meetings'] = [random.randint(1, 9) for _ in range(len(Partners))]  # Inicialmente ningún meeting\n",
    "Partners['eventos_participados'] = [random.randint(1, 9) for _ in range(len(Partners))]  # Inicialmente ningún evento participado\n",
    "Partners['industria'] = ['Tecnología'] * len(Partners)  # Suponiendo una industria común para todos\n",
    "Partners['importe_pagado'] = [random.randint(501, 5000) for _ in range(len(Partners))] # Inicialmente ningún importe pagado\n",
    "Partners['createdAt'] = datetime.now()  # Fecha de creación actual\n",
    "Partners['updatedAt'] = datetime.now()  # Fecha de actualización actual\n",
    "\n",
    "# Mostrar el DataFrame resultante\n",
    "Partners\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>user_id</th>\n",
       "      <th>partner_id</th>\n",
       "      <th>createdAt</th>\n",
       "      <th>updatedAt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>154</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>20</td>\n",
       "      <td>12</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>196</td>\n",
       "      <td>5</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>99</td>\n",
       "      <td>5</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>31</td>\n",
       "      <td>5</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>81</td>\n",
       "      <td>11</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>111</td>\n",
       "      <td>6</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>92</td>\n",
       "      <td>6</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>129</td>\n",
       "      <td>4</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>250</td>\n",
       "      <td>3</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>137</td>\n",
       "      <td>11</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>158</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>78</td>\n",
       "      <td>4</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>29</td>\n",
       "      <td>8</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>206</td>\n",
       "      <td>10</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>244</td>\n",
       "      <td>7</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>225</td>\n",
       "      <td>12</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>233</td>\n",
       "      <td>12</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>240</td>\n",
       "      <td>8</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>81</td>\n",
       "      <td>12</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>168</td>\n",
       "      <td>4</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>214</td>\n",
       "      <td>3</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>186</td>\n",
       "      <td>6</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>214</td>\n",
       "      <td>3</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>116</td>\n",
       "      <td>10</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>33</td>\n",
       "      <td>2</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>193</td>\n",
       "      <td>8</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>187</td>\n",
       "      <td>1</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>155</td>\n",
       "      <td>10</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>31</td>\n",
       "      <td>162</td>\n",
       "      <td>6</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>32</td>\n",
       "      <td>148</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>33</td>\n",
       "      <td>77</td>\n",
       "      <td>2</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>34</td>\n",
       "      <td>71</td>\n",
       "      <td>10</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>35</td>\n",
       "      <td>182</td>\n",
       "      <td>7</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>36</td>\n",
       "      <td>190</td>\n",
       "      <td>1</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>37</td>\n",
       "      <td>31</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>38</td>\n",
       "      <td>238</td>\n",
       "      <td>10</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>39</td>\n",
       "      <td>198</td>\n",
       "      <td>2</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>40</td>\n",
       "      <td>202</td>\n",
       "      <td>4</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>41</td>\n",
       "      <td>17</td>\n",
       "      <td>11</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>42</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>43</td>\n",
       "      <td>178</td>\n",
       "      <td>3</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>44</td>\n",
       "      <td>14</td>\n",
       "      <td>12</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>45</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>46</td>\n",
       "      <td>189</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>47</td>\n",
       "      <td>114</td>\n",
       "      <td>4</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>48</td>\n",
       "      <td>21</td>\n",
       "      <td>11</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>49</td>\n",
       "      <td>135</td>\n",
       "      <td>8</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>50</td>\n",
       "      <td>129</td>\n",
       "      <td>12</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "      <td>2024-06-24T11:01:34</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    id  user_id  partner_id            createdAt            updatedAt\n",
       "0    1      154           9  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "1    2       20          12  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "2    3      196           5  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "3    4       15           2  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "4    5       99           5  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "5    6       31           5  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "6    7       81          11  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "7    8      111           6  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "8    9       92           6  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "9   10      129           4  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "10  11      250           3  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "11  12      137          11  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "12  13      158           9  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "13  14       78           4  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "14  15       29           8  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "15  16      206          10  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "16  17      244           7  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "17  18      225          12  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "18  19      233          12  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "19  20      240           8  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "20  21       81          12  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "21  22      168           4  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "22  23      214           3  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "23  24      186           6  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "24  25      214           3  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "25  26      116          10  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "26  27       33           2  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "27  28      193           8  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "28  29      187           1  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "29  30      155          10  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "30  31      162           6  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "31  32      148           9  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "32  33       77           2  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "33  34       71          10  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "34  35      182           7  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "35  36      190           1  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "36  37       31           9  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "37  38      238          10  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "38  39      198           2  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "39  40      202           4  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "40  41       17          11  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "41  42       18           1  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "42  43      178           3  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "43  44       14          12  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "44  45        9           4  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "45  46      189           9  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "46  47      114           4  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "47  48       21          11  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "48  49      135           8  2024-06-24T11:01:34  2024-06-24T11:01:34\n",
       "49  50      129          12  2024-06-24T11:01:34  2024-06-24T11:01:34"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import random\n",
    "from datetime import datetime\n",
    "\n",
    "# Configuración inicial\n",
    "num_speakers = 50\n",
    "num_users = 250\n",
    "num_partners = 12\n",
    "\n",
    "# Generar datos\n",
    "data = []\n",
    "current_datetime = datetime.now().replace(microsecond=0).isoformat()\n",
    "\n",
    "# Generar lista de ids de users y partners\n",
    "user_ids = list(range(1, num_users + 1))\n",
    "partner_ids = list(range(1, num_partners + 1))\n",
    "\n",
    "# Generar 50 filas de datos\n",
    "for i in range(num_speakers):\n",
    "    user_id = random.choice(user_ids)\n",
    "    partner_id = random.choice(partner_ids)  # Aproximadamente 30% NaNs\n",
    "    data.append({\n",
    "        'id': i + 1,\n",
    "        'user_id': user_id,\n",
    "        'partner_id': partner_id,\n",
    "        'createdAt': current_datetime,\n",
    "        'updatedAt': current_datetime\n",
    "    })\n",
    "\n",
    "# Crear DataFrame\n",
    "Speakers = pd.DataFrame(data)\n",
    "\n",
    "# Mostrar las primeras filas del DataFrame\n",
    "Speakers\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>nombre</th>\n",
       "      <th>apellido</th>\n",
       "      <th>rol</th>\n",
       "      <th>token</th>\n",
       "      <th>password</th>\n",
       "      <th>pagado</th>\n",
       "      <th>puesto_trabajo</th>\n",
       "      <th>nombre_empresa</th>\n",
       "      <th>email</th>\n",
       "      <th>telefono</th>\n",
       "      <th>pais</th>\n",
       "      <th>interes</th>\n",
       "      <th>alergenos</th>\n",
       "      <th>linkedin</th>\n",
       "      <th>image_path</th>\n",
       "      <th>cluster</th>\n",
       "      <th>createdAt</th>\n",
       "      <th>updatedAt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Paul</td>\n",
       "      <td>Simpson</td>\n",
       "      <td>user</td>\n",
       "      <td>62ab0b8c-459a-4ff6-8df3-21b4c0f8d34b</td>\n",
       "      <td>pS8SSc^rd^</td>\n",
       "      <td>True</td>\n",
       "      <td>Analista de Datos Educativos</td>\n",
       "      <td>Dev Solutions</td>\n",
       "      <td>ryanperez@example.com</td>\n",
       "      <td>791.416.2777</td>\n",
       "      <td>UK</td>\n",
       "      <td>Finanzas</td>\n",
       "      <td>Gluten</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-06-27 11:17:16.019404</td>\n",
       "      <td>2024-06-27 11:17:16.019404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Michelle</td>\n",
       "      <td>Ramirez</td>\n",
       "      <td>user</td>\n",
       "      <td>dc709f7e-4580-4cd4-ab14-679bb81130b4</td>\n",
       "      <td>t*_W9LkxVP</td>\n",
       "      <td>False</td>\n",
       "      <td>Productor de Multimedia Educativa</td>\n",
       "      <td>Dev Solutions</td>\n",
       "      <td>colleengutierrez@example.net</td>\n",
       "      <td>675-759-0320x0716</td>\n",
       "      <td>Canada</td>\n",
       "      <td>Salud</td>\n",
       "      <td>Lactose</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-06-27 11:17:16.019404</td>\n",
       "      <td>2024-06-27 11:17:16.019404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>William</td>\n",
       "      <td>James</td>\n",
       "      <td>user</td>\n",
       "      <td>ba9c2dd4-1cfb-49b3-94b1-113c9b9fec3b</td>\n",
       "      <td>KJ5N0YGg*m</td>\n",
       "      <td>False</td>\n",
       "      <td>Tutor o Facilitador de e-Learning</td>\n",
       "      <td>Innovate Ltd</td>\n",
       "      <td>kevin69@example.org</td>\n",
       "      <td>(409)373-5551x7819</td>\n",
       "      <td>USA</td>\n",
       "      <td>Finanzas</td>\n",
       "      <td>Gluten</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-06-27 11:17:16.019404</td>\n",
       "      <td>2024-06-27 11:17:16.019404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Eric</td>\n",
       "      <td>Werner</td>\n",
       "      <td>speaker</td>\n",
       "      <td>55bbbdc4-6ce7-4d91-a3fd-d4bcbbb158d5</td>\n",
       "      <td>G4qGfq2y#A</td>\n",
       "      <td>True</td>\n",
       "      <td>Coordinador de Programas de e-Learning</td>\n",
       "      <td>Dev Solutions</td>\n",
       "      <td>jamesmills@example.net</td>\n",
       "      <td>6869608263</td>\n",
       "      <td>USA</td>\n",
       "      <td>Tecnología</td>\n",
       "      <td>Lactose</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-06-27 11:17:16.019404</td>\n",
       "      <td>2024-06-27 11:17:16.019404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Judith</td>\n",
       "      <td>Williams</td>\n",
       "      <td>partner</td>\n",
       "      <td>266fb749-7646-40f1-a932-1235c5098aed</td>\n",
       "      <td>%5Y(cd4LMu</td>\n",
       "      <td>True</td>\n",
       "      <td>Consultor de e-Learning</td>\n",
       "      <td>Innovate Ltd</td>\n",
       "      <td>frank09@example.com</td>\n",
       "      <td>+1-522-646-8737</td>\n",
       "      <td>France</td>\n",
       "      <td>Educación</td>\n",
       "      <td>Lactose</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-06-27 11:17:16.019404</td>\n",
       "      <td>2024-06-27 11:17:16.019404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>295</th>\n",
       "      <td>296</td>\n",
       "      <td>Vanessa</td>\n",
       "      <td>Lyons</td>\n",
       "      <td>speaker</td>\n",
       "      <td>c8a36eab-dd9b-4f82-b563-2e986a5a0d3c</td>\n",
       "      <td>XJ3SNze3$Y</td>\n",
       "      <td>False</td>\n",
       "      <td>Productor de Multimedia Educativa</td>\n",
       "      <td>Tech Corp</td>\n",
       "      <td>aarroyo@example.com</td>\n",
       "      <td>4628798996</td>\n",
       "      <td>UK</td>\n",
       "      <td>Educación</td>\n",
       "      <td>Gluten</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-06-27 11:17:16.019404</td>\n",
       "      <td>2024-06-27 11:17:16.019404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296</th>\n",
       "      <td>297</td>\n",
       "      <td>Carrie</td>\n",
       "      <td>Murray</td>\n",
       "      <td>partner</td>\n",
       "      <td>9d481b13-2560-40c6-9be5-026055579313</td>\n",
       "      <td>X@@Fl7AetL</td>\n",
       "      <td>True</td>\n",
       "      <td>Coordinador de Programas de e-Learning</td>\n",
       "      <td>Creative Inc</td>\n",
       "      <td>nnorris@example.com</td>\n",
       "      <td>001-558-318-8724</td>\n",
       "      <td>France</td>\n",
       "      <td>Finanzas</td>\n",
       "      <td>Peanuts</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-06-27 11:17:16.019404</td>\n",
       "      <td>2024-06-27 11:17:16.019404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297</th>\n",
       "      <td>298</td>\n",
       "      <td>Shelly</td>\n",
       "      <td>Franklin</td>\n",
       "      <td>partner</td>\n",
       "      <td>dc906864-14e1-4bd7-9a16-ab0925a0f57d</td>\n",
       "      <td>%9Kj&amp;)WkIs</td>\n",
       "      <td>True</td>\n",
       "      <td>Especialista en Evaluación y Certificación en ...</td>\n",
       "      <td>Dev Solutions</td>\n",
       "      <td>masonmark@example.net</td>\n",
       "      <td>411-784-5077</td>\n",
       "      <td>USA</td>\n",
       "      <td>Tecnología</td>\n",
       "      <td>Peanuts</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-06-27 11:17:16.019404</td>\n",
       "      <td>2024-06-27 11:17:16.019404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>299</td>\n",
       "      <td>Anna</td>\n",
       "      <td>Fernandez</td>\n",
       "      <td>partner</td>\n",
       "      <td>d4419165-5dcf-449d-8e18-53d49bccbfdf</td>\n",
       "      <td>AWk4klVc*^</td>\n",
       "      <td>False</td>\n",
       "      <td>Diseñador Instruccional</td>\n",
       "      <td>Tech Corp</td>\n",
       "      <td>manderson@example.com</td>\n",
       "      <td>450-481-1571x4846</td>\n",
       "      <td>USA</td>\n",
       "      <td>Educación</td>\n",
       "      <td>Nada</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-06-27 11:17:16.019404</td>\n",
       "      <td>2024-06-27 11:17:16.019404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>300</td>\n",
       "      <td>Abigail</td>\n",
       "      <td>Gray</td>\n",
       "      <td>partner</td>\n",
       "      <td>889557ef-9562-42c0-a7d3-5ad41953ebb8</td>\n",
       "      <td>pSFDBTjH*3</td>\n",
       "      <td>True</td>\n",
       "      <td>Desarrollador de Contenidos de e-Learning</td>\n",
       "      <td>Creative Inc</td>\n",
       "      <td>jonescraig@example.org</td>\n",
       "      <td>596-741-0133</td>\n",
       "      <td>Canada</td>\n",
       "      <td>Finanzas</td>\n",
       "      <td>Gluten</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-06-27 11:17:16.019404</td>\n",
       "      <td>2024-06-27 11:17:16.019404</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>300 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      id    nombre   apellido      rol                                 token  \\\n",
       "0      1      Paul    Simpson     user  62ab0b8c-459a-4ff6-8df3-21b4c0f8d34b   \n",
       "1      2  Michelle    Ramirez     user  dc709f7e-4580-4cd4-ab14-679bb81130b4   \n",
       "2      3   William      James     user  ba9c2dd4-1cfb-49b3-94b1-113c9b9fec3b   \n",
       "3      4      Eric     Werner  speaker  55bbbdc4-6ce7-4d91-a3fd-d4bcbbb158d5   \n",
       "4      5    Judith   Williams  partner  266fb749-7646-40f1-a932-1235c5098aed   \n",
       "..   ...       ...        ...      ...                                   ...   \n",
       "295  296   Vanessa      Lyons  speaker  c8a36eab-dd9b-4f82-b563-2e986a5a0d3c   \n",
       "296  297    Carrie     Murray  partner  9d481b13-2560-40c6-9be5-026055579313   \n",
       "297  298    Shelly   Franklin  partner  dc906864-14e1-4bd7-9a16-ab0925a0f57d   \n",
       "298  299      Anna  Fernandez  partner  d4419165-5dcf-449d-8e18-53d49bccbfdf   \n",
       "299  300   Abigail       Gray  partner  889557ef-9562-42c0-a7d3-5ad41953ebb8   \n",
       "\n",
       "       password  pagado                                     puesto_trabajo  \\\n",
       "0    pS8SSc^rd^    True                       Analista de Datos Educativos   \n",
       "1    t*_W9LkxVP   False                  Productor de Multimedia Educativa   \n",
       "2    KJ5N0YGg*m   False                  Tutor o Facilitador de e-Learning   \n",
       "3    G4qGfq2y#A    True             Coordinador de Programas de e-Learning   \n",
       "4    %5Y(cd4LMu    True                            Consultor de e-Learning   \n",
       "..          ...     ...                                                ...   \n",
       "295  XJ3SNze3$Y   False                  Productor de Multimedia Educativa   \n",
       "296  X@@Fl7AetL    True             Coordinador de Programas de e-Learning   \n",
       "297  %9Kj&)WkIs    True  Especialista en Evaluación y Certificación en ...   \n",
       "298  AWk4klVc*^   False                            Diseñador Instruccional   \n",
       "299  pSFDBTjH*3    True          Desarrollador de Contenidos de e-Learning   \n",
       "\n",
       "    nombre_empresa                         email            telefono    pais  \\\n",
       "0    Dev Solutions         ryanperez@example.com        791.416.2777      UK   \n",
       "1    Dev Solutions  colleengutierrez@example.net   675-759-0320x0716  Canada   \n",
       "2     Innovate Ltd           kevin69@example.org  (409)373-5551x7819     USA   \n",
       "3    Dev Solutions        jamesmills@example.net          6869608263     USA   \n",
       "4     Innovate Ltd           frank09@example.com     +1-522-646-8737  France   \n",
       "..             ...                           ...                 ...     ...   \n",
       "295      Tech Corp           aarroyo@example.com          4628798996      UK   \n",
       "296   Creative Inc           nnorris@example.com    001-558-318-8724  France   \n",
       "297  Dev Solutions         masonmark@example.net        411-784-5077     USA   \n",
       "298      Tech Corp         manderson@example.com   450-481-1571x4846     USA   \n",
       "299   Creative Inc        jonescraig@example.org        596-741-0133  Canada   \n",
       "\n",
       "        interes alergenos                         linkedin image_path  \\\n",
       "0      Finanzas    Gluten  http://linkedin.com/in/ficticio       nada   \n",
       "1         Salud   Lactose  http://linkedin.com/in/ficticio       nada   \n",
       "2      Finanzas    Gluten  http://linkedin.com/in/ficticio       nada   \n",
       "3    Tecnología   Lactose  http://linkedin.com/in/ficticio       nada   \n",
       "4     Educación   Lactose  http://linkedin.com/in/ficticio       nada   \n",
       "..          ...       ...                              ...        ...   \n",
       "295   Educación    Gluten  http://linkedin.com/in/ficticio       nada   \n",
       "296    Finanzas   Peanuts  http://linkedin.com/in/ficticio       nada   \n",
       "297  Tecnología   Peanuts  http://linkedin.com/in/ficticio       nada   \n",
       "298   Educación      Nada  http://linkedin.com/in/ficticio       nada   \n",
       "299    Finanzas    Gluten  http://linkedin.com/in/ficticio       nada   \n",
       "\n",
       "     cluster                  createdAt                  updatedAt  \n",
       "0          9 2024-06-27 11:17:16.019404 2024-06-27 11:17:16.019404  \n",
       "1          9 2024-06-27 11:17:16.019404 2024-06-27 11:17:16.019404  \n",
       "2          9 2024-06-27 11:17:16.019404 2024-06-27 11:17:16.019404  \n",
       "3          9 2024-06-27 11:17:16.019404 2024-06-27 11:17:16.019404  \n",
       "4          9 2024-06-27 11:17:16.019404 2024-06-27 11:17:16.019404  \n",
       "..       ...                        ...                        ...  \n",
       "295        9 2024-06-27 11:17:16.019404 2024-06-27 11:17:16.019404  \n",
       "296        9 2024-06-27 11:17:16.019404 2024-06-27 11:17:16.019404  \n",
       "297        9 2024-06-27 11:17:16.019404 2024-06-27 11:17:16.019404  \n",
       "298        9 2024-06-27 11:17:16.019404 2024-06-27 11:17:16.019404  \n",
       "299        9 2024-06-27 11:17:16.019404 2024-06-27 11:17:16.019404  \n",
       "\n",
       "[300 rows x 19 columns]"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import random\n",
    "from faker import Faker\n",
    "from datetime import datetime\n",
    "\n",
    "# Inicializar Faker\n",
    "fake = Faker()\n",
    "\n",
    "# Definir listas de posibles valores para algunas columnas\n",
    "roles = ['user', 'speaker', 'partner']\n",
    "pagado_options = [True, False]\n",
    "puestos_trabajo = [\n",
    "    \"Diseñador Instruccional\",\n",
    "    \"Desarrollador de Contenidos de e-Learning\",\n",
    "    \"Especialista en LMS (Learning Management Systems)\",\n",
    "    \"Tutor o Facilitador de e-Learning\",\n",
    "    \"Consultor de e-Learning\",\n",
    "    \"Productor de Multimedia Educativa\",\n",
    "    \"Analista de Datos Educativos\",\n",
    "    \"Coordinador de Programas de e-Learning\",\n",
    "    \"Diseñador Gráfico para e-Learning\",\n",
    "    \"Especialista en Evaluación y Certificación en Línea\"]\n",
    "nombre_empresas = ['Tech Corp', 'Innovate Ltd', 'Dev Solutions', 'Creative Inc']\n",
    "paises = ['USA', 'Canada', 'UK', 'Germany', 'France']\n",
    "intereses = ['Tecnología', 'Educación', 'Salud', 'Finanzas']\n",
    "food_allergens = ['Nada', 'Peanuts', 'Gluten', 'Lactose']\n",
    "current_datetime = datetime.now()\n",
    "\n",
    "# Generar datos\n",
    "data = []\n",
    "for i in range(300):\n",
    "    rol = random.choice(roles)\n",
    "    pagado = random.choice(pagado_options)\n",
    "    puesto_trabajo = random.choice(puestos_trabajo)\n",
    "    nombre_empresa = random.choice(nombre_empresas)\n",
    "    pais = random.choice(paises)\n",
    "    \n",
    "    record = {\n",
    "        'id': i + 1,\n",
    "        'nombre': fake.first_name(),\n",
    "        'apellido': fake.last_name(),\n",
    "        'rol': rol,\n",
    "        'token': fake.uuid4(),\n",
    "        'password': fake.password(),\n",
    "        'pagado': pagado,\n",
    "        'puesto_trabajo': puesto_trabajo,\n",
    "        'nombre_empresa': nombre_empresa,\n",
    "        'email': fake.email(),\n",
    "        'telefono': fake.phone_number(),\n",
    "        'pais': pais,\n",
    "        'interes': random.choice(intereses),\n",
    "        'alergenos': random.choice(food_allergens),\n",
    "        'linkedin': 'http://linkedin.com/in/ficticio',\n",
    "        'image_path': 'nada',\n",
    "        'cluster': 9,\n",
    "        'createdAt': current_datetime,\n",
    "        'updatedAt': current_datetime\n",
    "        \n",
    "    }\n",
    "    data.append(record)\n",
    "\n",
    "# Crear DataFrame\n",
    "Users = pd.DataFrame(data)\n",
    "\n",
    "# Mostrar DataFrame resultante\n",
    "Users\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>nombre</th>\n",
       "      <th>apellido</th>\n",
       "      <th>rol</th>\n",
       "      <th>token</th>\n",
       "      <th>password</th>\n",
       "      <th>pagado</th>\n",
       "      <th>puesto_trabajo</th>\n",
       "      <th>nombre_empresa</th>\n",
       "      <th>email</th>\n",
       "      <th>telefono</th>\n",
       "      <th>pais</th>\n",
       "      <th>interes</th>\n",
       "      <th>alergenos</th>\n",
       "      <th>linkedin</th>\n",
       "      <th>image_path</th>\n",
       "      <th>cluster</th>\n",
       "      <th>createdAt</th>\n",
       "      <th>updatedAt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Alexander</td>\n",
       "      <td>Leblanc</td>\n",
       "      <td>partner</td>\n",
       "      <td>19074a3f-4ee5-4cc6-893c-2f93378ecc5b</td>\n",
       "      <td>fbG)8D_Zu%</td>\n",
       "      <td>False</td>\n",
       "      <td>Coordinador de Programas de e-Learning</td>\n",
       "      <td>Innovate Ltd</td>\n",
       "      <td>zcoleman@example.net</td>\n",
       "      <td>(702)852-9685x154</td>\n",
       "      <td>USA</td>\n",
       "      <td>[\"Finanzas\", \"Educacion\"]</td>\n",
       "      <td>[\"Peanuts\", \"Lactose\"]</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-07-03 10:20:20.290297</td>\n",
       "      <td>2024-07-03 10:20:20.290297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Kenneth</td>\n",
       "      <td>Morales</td>\n",
       "      <td>user</td>\n",
       "      <td>50122733-f90d-46cd-86cc-f69789b691dd</td>\n",
       "      <td>@BTcUMOBa1</td>\n",
       "      <td>True</td>\n",
       "      <td>Especialista en LMS (Learning Management Systems)</td>\n",
       "      <td>Dev Solutions</td>\n",
       "      <td>roseerika@example.com</td>\n",
       "      <td>286-309-5230</td>\n",
       "      <td>UK</td>\n",
       "      <td>[\"Educacion\", \"Tecnologia\"]</td>\n",
       "      <td>[\"Gluten\", \"Nada\"]</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-07-03 10:20:20.290297</td>\n",
       "      <td>2024-07-03 10:20:20.290297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Brad</td>\n",
       "      <td>Dunn</td>\n",
       "      <td>partner</td>\n",
       "      <td>744d2aff-48ef-4d8d-97d0-4f71572a32ad</td>\n",
       "      <td>VEqEsRva&amp;0</td>\n",
       "      <td>True</td>\n",
       "      <td>Productor de Multimedia Educativa</td>\n",
       "      <td>Innovate Ltd</td>\n",
       "      <td>davidhughes@example.net</td>\n",
       "      <td>(893)898-6211x06035</td>\n",
       "      <td>Germany</td>\n",
       "      <td>[\"Salud\", \"Tecnologia\"]</td>\n",
       "      <td>[\"Peanuts\", \"Nada\"]</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-07-03 10:20:20.290297</td>\n",
       "      <td>2024-07-03 10:20:20.290297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Christine</td>\n",
       "      <td>Stephenson</td>\n",
       "      <td>speaker</td>\n",
       "      <td>5995b94e-f5bd-4d7b-9065-367f2d5adf18</td>\n",
       "      <td>%AwO2QYajd</td>\n",
       "      <td>False</td>\n",
       "      <td>Desarrollador de Contenidos de e-Learning</td>\n",
       "      <td>Tech Corp</td>\n",
       "      <td>donovanteresa@example.net</td>\n",
       "      <td>817.957.7858x829</td>\n",
       "      <td>UK</td>\n",
       "      <td>[\"Tecnologia\", \"Salud\"]</td>\n",
       "      <td>[\"Lactose\", \"Peanuts\"]</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-07-03 10:20:20.290297</td>\n",
       "      <td>2024-07-03 10:20:20.290297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Hunter</td>\n",
       "      <td>Roberts</td>\n",
       "      <td>speaker</td>\n",
       "      <td>77c0c131-b23d-48fd-8c74-c0f3cfb13a0e</td>\n",
       "      <td>^65&amp;cVRt#7</td>\n",
       "      <td>True</td>\n",
       "      <td>Especialista en Evaluación y Certificación en ...</td>\n",
       "      <td>Innovate Ltd</td>\n",
       "      <td>daviesjeffrey@example.com</td>\n",
       "      <td>(910)922-5074x1277</td>\n",
       "      <td>USA</td>\n",
       "      <td>[\"Educacion\", \"Tecnologia\"]</td>\n",
       "      <td>[\"Gluten\", \"Nada\"]</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-07-03 10:20:20.290297</td>\n",
       "      <td>2024-07-03 10:20:20.290297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>295</th>\n",
       "      <td>296</td>\n",
       "      <td>Christina</td>\n",
       "      <td>Johnson</td>\n",
       "      <td>user</td>\n",
       "      <td>3b8b4043-e7c4-4de8-91e6-aa7298e35e96</td>\n",
       "      <td>&amp;J^HKg0w^5</td>\n",
       "      <td>False</td>\n",
       "      <td>Coordinador de Programas de e-Learning</td>\n",
       "      <td>Tech Corp</td>\n",
       "      <td>jmoss@example.com</td>\n",
       "      <td>264.652.4464x334</td>\n",
       "      <td>USA</td>\n",
       "      <td>[\"Salud\", \"Educacion\"]</td>\n",
       "      <td>[\"Lactose\", \"Nada\"]</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-07-03 10:20:20.290297</td>\n",
       "      <td>2024-07-03 10:20:20.290297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296</th>\n",
       "      <td>297</td>\n",
       "      <td>Amy</td>\n",
       "      <td>Rich</td>\n",
       "      <td>user</td>\n",
       "      <td>b97b9db1-b486-4f3e-b6e1-6556858d3af7</td>\n",
       "      <td>#BT8+X4h5f</td>\n",
       "      <td>False</td>\n",
       "      <td>Especialista en LMS (Learning Management Systems)</td>\n",
       "      <td>Creative Inc</td>\n",
       "      <td>ggonzalez@example.com</td>\n",
       "      <td>(437)246-5291x49439</td>\n",
       "      <td>Germany</td>\n",
       "      <td>[\"Educacion\", \"Finanzas\"]</td>\n",
       "      <td>[\"Gluten\", \"Peanuts\"]</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-07-03 10:20:20.290297</td>\n",
       "      <td>2024-07-03 10:20:20.290297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297</th>\n",
       "      <td>298</td>\n",
       "      <td>Angela</td>\n",
       "      <td>Munoz</td>\n",
       "      <td>partner</td>\n",
       "      <td>ed89f7e8-d8b9-489b-93db-711d467e58f0</td>\n",
       "      <td>@T0&amp;rF$iC5</td>\n",
       "      <td>True</td>\n",
       "      <td>Diseñador Instruccional</td>\n",
       "      <td>Innovate Ltd</td>\n",
       "      <td>zhall@example.org</td>\n",
       "      <td>001-638-578-7387x0049</td>\n",
       "      <td>España</td>\n",
       "      <td>[\"Salud\", \"Finanzas\"]</td>\n",
       "      <td>[\"Peanuts\", \"Nada\"]</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-07-03 10:20:20.290297</td>\n",
       "      <td>2024-07-03 10:20:20.290297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>299</td>\n",
       "      <td>Destiny</td>\n",
       "      <td>Patel</td>\n",
       "      <td>speaker</td>\n",
       "      <td>a878ed79-2666-40b5-b810-2d51e54d75ae</td>\n",
       "      <td>3aQ0%JpM(a</td>\n",
       "      <td>True</td>\n",
       "      <td>Diseñador Gráfico para e-Learning</td>\n",
       "      <td>Tech Corp</td>\n",
       "      <td>dustingraham@example.com</td>\n",
       "      <td>(780)952-6474x215</td>\n",
       "      <td>France</td>\n",
       "      <td>[\"Tecnologia\", \"Finanzas\"]</td>\n",
       "      <td>[\"Nada\", \"Peanuts\"]</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-07-03 10:20:20.290297</td>\n",
       "      <td>2024-07-03 10:20:20.290297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>300</td>\n",
       "      <td>Kristina</td>\n",
       "      <td>Bolton</td>\n",
       "      <td>user</td>\n",
       "      <td>de3786a0-7d98-437a-b76d-198626996aac</td>\n",
       "      <td>1g0lYc9OR*</td>\n",
       "      <td>True</td>\n",
       "      <td>Diseñador Gráfico para e-Learning</td>\n",
       "      <td>Tech Corp</td>\n",
       "      <td>martinezkevin@example.net</td>\n",
       "      <td>+1-768-352-7628x461</td>\n",
       "      <td>France</td>\n",
       "      <td>[\"Tecnologia\", \"Salud\"]</td>\n",
       "      <td>[\"Gluten\", \"Nada\"]</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9</td>\n",
       "      <td>2024-07-03 10:20:20.290297</td>\n",
       "      <td>2024-07-03 10:20:20.290297</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>300 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      id     nombre    apellido      rol  \\\n",
       "0      1  Alexander     Leblanc  partner   \n",
       "1      2    Kenneth     Morales     user   \n",
       "2      3       Brad        Dunn  partner   \n",
       "3      4  Christine  Stephenson  speaker   \n",
       "4      5     Hunter     Roberts  speaker   \n",
       "..   ...        ...         ...      ...   \n",
       "295  296  Christina     Johnson     user   \n",
       "296  297        Amy        Rich     user   \n",
       "297  298     Angela       Munoz  partner   \n",
       "298  299    Destiny       Patel  speaker   \n",
       "299  300   Kristina      Bolton     user   \n",
       "\n",
       "                                    token    password  pagado  \\\n",
       "0    19074a3f-4ee5-4cc6-893c-2f93378ecc5b  fbG)8D_Zu%   False   \n",
       "1    50122733-f90d-46cd-86cc-f69789b691dd  @BTcUMOBa1    True   \n",
       "2    744d2aff-48ef-4d8d-97d0-4f71572a32ad  VEqEsRva&0    True   \n",
       "3    5995b94e-f5bd-4d7b-9065-367f2d5adf18  %AwO2QYajd   False   \n",
       "4    77c0c131-b23d-48fd-8c74-c0f3cfb13a0e  ^65&cVRt#7    True   \n",
       "..                                    ...         ...     ...   \n",
       "295  3b8b4043-e7c4-4de8-91e6-aa7298e35e96  &J^HKg0w^5   False   \n",
       "296  b97b9db1-b486-4f3e-b6e1-6556858d3af7  #BT8+X4h5f   False   \n",
       "297  ed89f7e8-d8b9-489b-93db-711d467e58f0  @T0&rF$iC5    True   \n",
       "298  a878ed79-2666-40b5-b810-2d51e54d75ae  3aQ0%JpM(a    True   \n",
       "299  de3786a0-7d98-437a-b76d-198626996aac  1g0lYc9OR*    True   \n",
       "\n",
       "                                        puesto_trabajo nombre_empresa  \\\n",
       "0               Coordinador de Programas de e-Learning   Innovate Ltd   \n",
       "1    Especialista en LMS (Learning Management Systems)  Dev Solutions   \n",
       "2                    Productor de Multimedia Educativa   Innovate Ltd   \n",
       "3            Desarrollador de Contenidos de e-Learning      Tech Corp   \n",
       "4    Especialista en Evaluación y Certificación en ...   Innovate Ltd   \n",
       "..                                                 ...            ...   \n",
       "295             Coordinador de Programas de e-Learning      Tech Corp   \n",
       "296  Especialista en LMS (Learning Management Systems)   Creative Inc   \n",
       "297                            Diseñador Instruccional   Innovate Ltd   \n",
       "298                  Diseñador Gráfico para e-Learning      Tech Corp   \n",
       "299                  Diseñador Gráfico para e-Learning      Tech Corp   \n",
       "\n",
       "                         email               telefono     pais  \\\n",
       "0         zcoleman@example.net      (702)852-9685x154      USA   \n",
       "1        roseerika@example.com           286-309-5230       UK   \n",
       "2      davidhughes@example.net    (893)898-6211x06035  Germany   \n",
       "3    donovanteresa@example.net       817.957.7858x829       UK   \n",
       "4    daviesjeffrey@example.com     (910)922-5074x1277      USA   \n",
       "..                         ...                    ...      ...   \n",
       "295          jmoss@example.com       264.652.4464x334      USA   \n",
       "296      ggonzalez@example.com    (437)246-5291x49439  Germany   \n",
       "297          zhall@example.org  001-638-578-7387x0049   España   \n",
       "298   dustingraham@example.com      (780)952-6474x215   France   \n",
       "299  martinezkevin@example.net    +1-768-352-7628x461   France   \n",
       "\n",
       "                         interes               alergenos  \\\n",
       "0      [\"Finanzas\", \"Educacion\"]  [\"Peanuts\", \"Lactose\"]   \n",
       "1    [\"Educacion\", \"Tecnologia\"]      [\"Gluten\", \"Nada\"]   \n",
       "2        [\"Salud\", \"Tecnologia\"]     [\"Peanuts\", \"Nada\"]   \n",
       "3        [\"Tecnologia\", \"Salud\"]  [\"Lactose\", \"Peanuts\"]   \n",
       "4    [\"Educacion\", \"Tecnologia\"]      [\"Gluten\", \"Nada\"]   \n",
       "..                           ...                     ...   \n",
       "295       [\"Salud\", \"Educacion\"]     [\"Lactose\", \"Nada\"]   \n",
       "296    [\"Educacion\", \"Finanzas\"]   [\"Gluten\", \"Peanuts\"]   \n",
       "297        [\"Salud\", \"Finanzas\"]     [\"Peanuts\", \"Nada\"]   \n",
       "298   [\"Tecnologia\", \"Finanzas\"]     [\"Nada\", \"Peanuts\"]   \n",
       "299      [\"Tecnologia\", \"Salud\"]      [\"Gluten\", \"Nada\"]   \n",
       "\n",
       "                            linkedin image_path  cluster  \\\n",
       "0    http://linkedin.com/in/ficticio       nada        9   \n",
       "1    http://linkedin.com/in/ficticio       nada        9   \n",
       "2    http://linkedin.com/in/ficticio       nada        9   \n",
       "3    http://linkedin.com/in/ficticio       nada        9   \n",
       "4    http://linkedin.com/in/ficticio       nada        9   \n",
       "..                               ...        ...      ...   \n",
       "295  http://linkedin.com/in/ficticio       nada        9   \n",
       "296  http://linkedin.com/in/ficticio       nada        9   \n",
       "297  http://linkedin.com/in/ficticio       nada        9   \n",
       "298  http://linkedin.com/in/ficticio       nada        9   \n",
       "299  http://linkedin.com/in/ficticio       nada        9   \n",
       "\n",
       "                     createdAt                  updatedAt  \n",
       "0   2024-07-03 10:20:20.290297 2024-07-03 10:20:20.290297  \n",
       "1   2024-07-03 10:20:20.290297 2024-07-03 10:20:20.290297  \n",
       "2   2024-07-03 10:20:20.290297 2024-07-03 10:20:20.290297  \n",
       "3   2024-07-03 10:20:20.290297 2024-07-03 10:20:20.290297  \n",
       "4   2024-07-03 10:20:20.290297 2024-07-03 10:20:20.290297  \n",
       "..                         ...                        ...  \n",
       "295 2024-07-03 10:20:20.290297 2024-07-03 10:20:20.290297  \n",
       "296 2024-07-03 10:20:20.290297 2024-07-03 10:20:20.290297  \n",
       "297 2024-07-03 10:20:20.290297 2024-07-03 10:20:20.290297  \n",
       "298 2024-07-03 10:20:20.290297 2024-07-03 10:20:20.290297  \n",
       "299 2024-07-03 10:20:20.290297 2024-07-03 10:20:20.290297  \n",
       "\n",
       "[300 rows x 19 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import random\n",
    "from faker import Faker\n",
    "from datetime import datetime\n",
    "import json\n",
    "\n",
    "# Inicializar Faker\n",
    "fake = Faker()\n",
    "\n",
    "# Definir listas de posibles valores para algunas columnas\n",
    "roles = ['user', 'speaker', 'partner']\n",
    "pagado_options = [True, False]\n",
    "puestos_trabajo = [\n",
    "    \"Diseñador Instruccional\",\n",
    "    \"Desarrollador de Contenidos de e-Learning\",\n",
    "    \"Especialista en LMS (Learning Management Systems)\",\n",
    "    \"Tutor o Facilitador de e-Learning\",\n",
    "    \"Consultor de e-Learning\",\n",
    "    \"Productor de Multimedia Educativa\",\n",
    "    \"Analista de Datos Educativos\",\n",
    "    \"Coordinador de Programas de e-Learning\",\n",
    "    \"Diseñador Gráfico para e-Learning\",\n",
    "    \"Especialista en Evaluación y Certificación en Línea\"]\n",
    "nombre_empresas = ['Tech Corp', 'Innovate Ltd', 'Dev Solutions', 'Creative Inc']\n",
    "paises = ['España','USA', 'Canada', 'UK', 'Germany', 'France']\n",
    "intereses = ['Tecnologia', 'Educacion', 'Salud', 'Finanzas']\n",
    "food_allergens = ['Nada', 'Peanuts', 'Gluten', 'Lactose']\n",
    "current_datetime = datetime.now()\n",
    "\n",
    "# Función para generar una lista de intereses/alergenos en formato de string\n",
    "def generate_random_list(values, num_elements=2):\n",
    "    return json.dumps(random.sample(values, num_elements))\n",
    "\n",
    "# Generar datos\n",
    "data = []\n",
    "for i in range(300):\n",
    "    rol = random.choice(roles)\n",
    "    pagado = random.choice(pagado_options)\n",
    "    puesto_trabajo = random.choice(puestos_trabajo)\n",
    "    nombre_empresa = random.choice(nombre_empresas)\n",
    "    pais = random.choice(paises)\n",
    "    \n",
    "    record = {\n",
    "        'id': i + 1,\n",
    "        'nombre': fake.first_name(),\n",
    "        'apellido': fake.last_name(),\n",
    "        'rol': rol,\n",
    "        'token': fake.uuid4(),\n",
    "        'password': fake.password(),\n",
    "        'pagado': pagado,\n",
    "        'puesto_trabajo': puesto_trabajo,\n",
    "        'nombre_empresa': nombre_empresa,\n",
    "        'email': fake.email(),\n",
    "        'telefono': fake.phone_number(),\n",
    "        'pais': pais,\n",
    "        'interes': generate_random_list(intereses),\n",
    "        'alergenos': generate_random_list(food_allergens),\n",
    "        'linkedin': 'http://linkedin.com/in/ficticio',\n",
    "        'image_path': 'nada',\n",
    "        'cluster': 9,\n",
    "        'createdAt': current_datetime,\n",
    "        'updatedAt': current_datetime\n",
    "    }\n",
    "    data.append(record)\n",
    "\n",
    "# Crear DataFrame\n",
    "Users = pd.DataFrame(data)\n",
    "\n",
    "# Mostrar DataFrame resultante\n",
    "Users\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "# Definir el endpoint al que se enviarán los datos\n",
    "endpoint_url = 'http://your-endpoint-url.com/api'\n",
    "\n",
    "# Enviar datos línea a línea\n",
    "for index, row in Users.iterrows():\n",
    "    response = requests.post(endpoint_url, json=row.to_dict())\n",
    "    if response.status_code == 200:\n",
    "        print(f\"Fila {index} enviada exitosamente.\")\n",
    "    else:\n",
    "        print(f\"Error al enviar la fila {index}: {response.text}\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "str"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(Users['interes'][0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [],
   "source": [
    "csv_path = 'users_data.csv'\n",
    "Users.to_csv(csv_path, index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "  Tables_in_mysql_app\n",
      "0              Events\n",
      "1           Feedbacks\n",
      "2            Meetings\n",
      "3            Partners\n",
      "4       SequelizeMeta\n",
      "5            Speakers\n",
      "6               Users\n"
     ]
    }
   ],
   "source": [
    "query = \"SHOW TABLES;\"\n",
    "tables = pd.read_sql(query, engine)\n",
    "print(tables)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [],
   "source": [
    "with engine.connect() as connection:\n",
    "    Users.to_sql(name='Users', con=connection, if_exists='append', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>nombre</th>\n",
       "      <th>apellido</th>\n",
       "      <th>rol</th>\n",
       "      <th>token</th>\n",
       "      <th>password</th>\n",
       "      <th>pagado</th>\n",
       "      <th>puesto_trabajo</th>\n",
       "      <th>nombre_empresa</th>\n",
       "      <th>email</th>\n",
       "      <th>telefono</th>\n",
       "      <th>pais</th>\n",
       "      <th>interes</th>\n",
       "      <th>alergenos</th>\n",
       "      <th>linkedIn</th>\n",
       "      <th>image_path</th>\n",
       "      <th>cluster</th>\n",
       "      <th>createdAt</th>\n",
       "      <th>updatedAt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Paul</td>\n",
       "      <td>Simpson</td>\n",
       "      <td>user</td>\n",
       "      <td>62ab0b8c-459a-4ff6-8df3-21b4c0f8d34b</td>\n",
       "      <td>pS8SSc^rd^</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Analista de Datos Educativos</td>\n",
       "      <td>Dev Solutions</td>\n",
       "      <td>ryanperez@example.com</td>\n",
       "      <td>791.416.2777</td>\n",
       "      <td>UK</td>\n",
       "      <td>Finanzas</td>\n",
       "      <td>Gluten</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2024-06-27 11:17:16</td>\n",
       "      <td>2024-06-27 11:17:16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Michelle</td>\n",
       "      <td>Ramirez</td>\n",
       "      <td>user</td>\n",
       "      <td>dc709f7e-4580-4cd4-ab14-679bb81130b4</td>\n",
       "      <td>t*_W9LkxVP</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Productor de Multimedia Educativa</td>\n",
       "      <td>Dev Solutions</td>\n",
       "      <td>colleengutierrez@example.net</td>\n",
       "      <td>675-759-0320x0716</td>\n",
       "      <td>Canada</td>\n",
       "      <td>Salud</td>\n",
       "      <td>Lactose</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2024-06-27 11:17:16</td>\n",
       "      <td>2024-06-27 11:17:16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>William</td>\n",
       "      <td>James</td>\n",
       "      <td>admin</td>\n",
       "      <td>ba9c2dd4-1cfb-49b3-94b1-113c9b9fec3b</td>\n",
       "      <td>KJ5N0YGg*m</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Tutor o Facilitador de e-Learning</td>\n",
       "      <td>Innovate Ltd</td>\n",
       "      <td>kevin69@example.org</td>\n",
       "      <td>(409)373-5551x7819</td>\n",
       "      <td>USA</td>\n",
       "      <td>Finanzas</td>\n",
       "      <td>Gluten</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2024-06-27 11:17:16</td>\n",
       "      <td>2024-06-27 11:17:16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Eric</td>\n",
       "      <td>Werner</td>\n",
       "      <td>speaker</td>\n",
       "      <td>55bbbdc4-6ce7-4d91-a3fd-d4bcbbb158d5</td>\n",
       "      <td>G4qGfq2y#A</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Coordinador de Programas de e-Learning</td>\n",
       "      <td>Dev Solutions</td>\n",
       "      <td>jamesmills@example.net</td>\n",
       "      <td>6869608263</td>\n",
       "      <td>USA</td>\n",
       "      <td>Tecnología</td>\n",
       "      <td>Lactose</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2024-06-27 11:17:16</td>\n",
       "      <td>2024-06-27 11:17:16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Judith</td>\n",
       "      <td>Williams</td>\n",
       "      <td>partner</td>\n",
       "      <td>266fb749-7646-40f1-a932-1235c5098aed</td>\n",
       "      <td>%5Y(cd4LMu</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Consultor de e-Learning</td>\n",
       "      <td>Innovate Ltd</td>\n",
       "      <td>frank09@example.com</td>\n",
       "      <td>+1-522-646-8737</td>\n",
       "      <td>France</td>\n",
       "      <td>Educación</td>\n",
       "      <td>Lactose</td>\n",
       "      <td>http://linkedin.com/in/ficticio</td>\n",
       "      <td>nada</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2024-06-27 11:17:16</td>\n",
       "      <td>2024-06-27 11:17:16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310</th>\n",
       "      <td>317</td>\n",
       "      <td>adfvsdvasdv</td>\n",
       "      <td>SDVsdv</td>\n",
       "      <td>user</td>\n",
       "      <td>None</td>\n",
       "      <td>$2a$10$opGhASKgKTK1kF4eZpQRTu1MqKXidApcSA/ebWw...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Coordinador de Programas de e-Learning</td>\n",
       "      <td>sdvsdvsadv</td>\n",
       "      <td>jklshdfkjsdf@gmail.com</td>\n",
       "      <td>322231313</td>\n",
       "      <td>Spain</td>\n",
       "      <td>[\"Generación de vídeo\",\"Sistema de Gestión\"]</td>\n",
       "      <td>[\"Lupino\"]</td>\n",
       "      <td>None</td>\n",
       "      <td>sadvsdv</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2024-07-02 11:55:35</td>\n",
       "      <td>2024-07-02 11:55:35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>311</th>\n",
       "      <td>318</td>\n",
       "      <td>dfbadfb</td>\n",
       "      <td>afdvgadfb</td>\n",
       "      <td>user</td>\n",
       "      <td>eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6M...</td>\n",
       "      <td>$2a$10$iNWEtc0GJfg7XXaBnAFmO.QjCfO9Q0F0Yy2HgHa...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Coordinador de Programas de e-Learning</td>\n",
       "      <td>fbvxycvbyfc</td>\n",
       "      <td>pagado3000@gmail.com</td>\n",
       "      <td>xcvxycvb</td>\n",
       "      <td>UK</td>\n",
       "      <td>[\"Herramientas del autor\"]</td>\n",
       "      <td>[\"Sésamo\"]</td>\n",
       "      <td>None</td>\n",
       "      <td>6565465</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2024-07-02 11:59:18</td>\n",
       "      <td>2024-07-02 11:59:19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>312</th>\n",
       "      <td>319</td>\n",
       "      <td>fsdv&lt;sdvs&lt;</td>\n",
       "      <td>dv&lt;sdv</td>\n",
       "      <td>user</td>\n",
       "      <td>eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6M...</td>\n",
       "      <td>$2a$10$eE5ocCfphmIqWDmdvQ9fxO36bEt6I38n/e8Ch/U...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Consultor de e-Learning</td>\n",
       "      <td>dsv&lt;sfv</td>\n",
       "      <td>WEFWWEF@gmail.com</td>\n",
       "      <td>sdfvsfdv</td>\n",
       "      <td>France</td>\n",
       "      <td>[\"Gestión de la formación\"]</td>\n",
       "      <td>[\"Sésamo\"]</td>\n",
       "      <td>None</td>\n",
       "      <td>315</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2024-07-02 12:10:43</td>\n",
       "      <td>2024-07-02 16:18:18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313</th>\n",
       "      <td>320</td>\n",
       "      <td>fsdv&lt;sdvs&lt;</td>\n",
       "      <td>dv&lt;sdv</td>\n",
       "      <td>user</td>\n",
       "      <td>None</td>\n",
       "      <td>$2a$10$J29Ch7TnBwOKUq66VyLbQulBFpeZtKXHlmlk64t...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consultor de e-Learning</td>\n",
       "      <td>dsv&lt;sfv</td>\n",
       "      <td>WEFWWEF@gmail.com</td>\n",
       "      <td>sdfvsfdv</td>\n",
       "      <td>France</td>\n",
       "      <td>[\"Gestión de la formación\"]</td>\n",
       "      <td>[\"Sésamo\"]</td>\n",
       "      <td>None</td>\n",
       "      <td>315</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2024-07-02 12:20:00</td>\n",
       "      <td>2024-07-02 12:20:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>321</td>\n",
       "      <td>sdvasdfv</td>\n",
       "      <td>sDVFSDV</td>\n",
       "      <td>user</td>\n",
       "      <td>eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6M...</td>\n",
       "      <td>$2a$10$B7SRPjlvYSM7/1MFnfMr4Ok7ICoZO1ju1FewbKu...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Tutor o Facilitador de e-Learning</td>\n",
       "      <td>adfgadf</td>\n",
       "      <td>kjsdf@gmail.com</td>\n",
       "      <td>65565656565</td>\n",
       "      <td>Spain</td>\n",
       "      <td>[\"Inteligencia artificial\",\"Gestión de la form...</td>\n",
       "      <td>[\"Sulfitos\",\"Cacahuetes\"]</td>\n",
       "      <td>None</td>\n",
       "      <td>sdfv</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2024-07-02 16:18:17</td>\n",
       "      <td>2024-07-02 16:18:41</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>315 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      id       nombre   apellido      rol  \\\n",
       "0      1         Paul    Simpson     user   \n",
       "1      2     Michelle    Ramirez     user   \n",
       "2      3      William      James    admin   \n",
       "3      4         Eric     Werner  speaker   \n",
       "4      5       Judith   Williams  partner   \n",
       "..   ...          ...        ...      ...   \n",
       "310  317  adfvsdvasdv     SDVsdv     user   \n",
       "311  318      dfbadfb  afdvgadfb     user   \n",
       "312  319   fsdv<sdvs<     dv<sdv     user   \n",
       "313  320   fsdv<sdvs<     dv<sdv     user   \n",
       "314  321     sdvasdfv    sDVFSDV     user   \n",
       "\n",
       "                                                 token  \\\n",
       "0                 62ab0b8c-459a-4ff6-8df3-21b4c0f8d34b   \n",
       "1                 dc709f7e-4580-4cd4-ab14-679bb81130b4   \n",
       "2                 ba9c2dd4-1cfb-49b3-94b1-113c9b9fec3b   \n",
       "3                 55bbbdc4-6ce7-4d91-a3fd-d4bcbbb158d5   \n",
       "4                 266fb749-7646-40f1-a932-1235c5098aed   \n",
       "..                                                 ...   \n",
       "310                                               None   \n",
       "311  eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6M...   \n",
       "312  eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6M...   \n",
       "313                                               None   \n",
       "314  eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6M...   \n",
       "\n",
       "                                              password  pagado  \\\n",
       "0                                           pS8SSc^rd^     1.0   \n",
       "1                                           t*_W9LkxVP     0.0   \n",
       "2                                           KJ5N0YGg*m     0.0   \n",
       "3                                           G4qGfq2y#A     1.0   \n",
       "4                                           %5Y(cd4LMu     1.0   \n",
       "..                                                 ...     ...   \n",
       "310  $2a$10$opGhASKgKTK1kF4eZpQRTu1MqKXidApcSA/ebWw...     0.0   \n",
       "311  $2a$10$iNWEtc0GJfg7XXaBnAFmO.QjCfO9Q0F0Yy2HgHa...     0.0   \n",
       "312  $2a$10$eE5ocCfphmIqWDmdvQ9fxO36bEt6I38n/e8Ch/U...     1.0   \n",
       "313  $2a$10$J29Ch7TnBwOKUq66VyLbQulBFpeZtKXHlmlk64t...     0.0   \n",
       "314  $2a$10$B7SRPjlvYSM7/1MFnfMr4Ok7ICoZO1ju1FewbKu...     1.0   \n",
       "\n",
       "                             puesto_trabajo nombre_empresa  \\\n",
       "0              Analista de Datos Educativos  Dev Solutions   \n",
       "1         Productor de Multimedia Educativa  Dev Solutions   \n",
       "2         Tutor o Facilitador de e-Learning   Innovate Ltd   \n",
       "3    Coordinador de Programas de e-Learning  Dev Solutions   \n",
       "4                   Consultor de e-Learning   Innovate Ltd   \n",
       "..                                      ...            ...   \n",
       "310  Coordinador de Programas de e-Learning     sdvsdvsadv   \n",
       "311  Coordinador de Programas de e-Learning    fbvxycvbyfc   \n",
       "312                 Consultor de e-Learning        dsv<sfv   \n",
       "313                 Consultor de e-Learning        dsv<sfv   \n",
       "314       Tutor o Facilitador de e-Learning        adfgadf   \n",
       "\n",
       "                            email            telefono    pais  \\\n",
       "0           ryanperez@example.com        791.416.2777      UK   \n",
       "1    colleengutierrez@example.net   675-759-0320x0716  Canada   \n",
       "2             kevin69@example.org  (409)373-5551x7819     USA   \n",
       "3          jamesmills@example.net          6869608263     USA   \n",
       "4             frank09@example.com     +1-522-646-8737  France   \n",
       "..                            ...                 ...     ...   \n",
       "310        jklshdfkjsdf@gmail.com           322231313   Spain   \n",
       "311          pagado3000@gmail.com            xcvxycvb      UK   \n",
       "312             WEFWWEF@gmail.com            sdfvsfdv  France   \n",
       "313             WEFWWEF@gmail.com            sdfvsfdv  France   \n",
       "314               kjsdf@gmail.com         65565656565   Spain   \n",
       "\n",
       "                                               interes  \\\n",
       "0                                             Finanzas   \n",
       "1                                                Salud   \n",
       "2                                             Finanzas   \n",
       "3                                           Tecnología   \n",
       "4                                            Educación   \n",
       "..                                                 ...   \n",
       "310       [\"Generación de vídeo\",\"Sistema de Gestión\"]   \n",
       "311                         [\"Herramientas del autor\"]   \n",
       "312                        [\"Gestión de la formación\"]   \n",
       "313                        [\"Gestión de la formación\"]   \n",
       "314  [\"Inteligencia artificial\",\"Gestión de la form...   \n",
       "\n",
       "                     alergenos                         linkedIn image_path  \\\n",
       "0                       Gluten  http://linkedin.com/in/ficticio       nada   \n",
       "1                      Lactose  http://linkedin.com/in/ficticio       nada   \n",
       "2                       Gluten  http://linkedin.com/in/ficticio       nada   \n",
       "3                      Lactose  http://linkedin.com/in/ficticio       nada   \n",
       "4                      Lactose  http://linkedin.com/in/ficticio       nada   \n",
       "..                         ...                              ...        ...   \n",
       "310                 [\"Lupino\"]                             None    sadvsdv   \n",
       "311                 [\"Sésamo\"]                             None    6565465   \n",
       "312                 [\"Sésamo\"]                             None        315   \n",
       "313                 [\"Sésamo\"]                             None        315   \n",
       "314  [\"Sulfitos\",\"Cacahuetes\"]                             None       sdfv   \n",
       "\n",
       "     cluster           createdAt           updatedAt  \n",
       "0        9.0 2024-06-27 11:17:16 2024-06-27 11:17:16  \n",
       "1        9.0 2024-06-27 11:17:16 2024-06-27 11:17:16  \n",
       "2        9.0 2024-06-27 11:17:16 2024-06-27 11:17:16  \n",
       "3        9.0 2024-06-27 11:17:16 2024-06-27 11:17:16  \n",
       "4        9.0 2024-06-27 11:17:16 2024-06-27 11:17:16  \n",
       "..       ...                 ...                 ...  \n",
       "310      NaN 2024-07-02 11:55:35 2024-07-02 11:55:35  \n",
       "311      NaN 2024-07-02 11:59:18 2024-07-02 11:59:19  \n",
       "312      NaN 2024-07-02 12:10:43 2024-07-02 16:18:18  \n",
       "313      3.0 2024-07-02 12:20:00 2024-07-02 12:20:00  \n",
       "314      NaN 2024-07-02 16:18:17 2024-07-02 16:18:41  \n",
       "\n",
       "[315 rows x 19 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "query = \"SELECT * FROM Users;\"\n",
    "tables = pd.read_sql(query, engine)\n",
    "tables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>partner_id</th>\n",
       "      <th>user_id</th>\n",
       "      <th>fecha</th>\n",
       "      <th>hora_inicio</th>\n",
       "      <th>hora_fin</th>\n",
       "      <th>createdAt</th>\n",
       "      <th>updatedAt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>235</td>\n",
       "      <td>2024-03-10</td>\n",
       "      <td>0 days 10:01:00</td>\n",
       "      <td>0 days 10:02:00</td>\n",
       "      <td>2024-06-24 10:46:28</td>\n",
       "      <td>2024-06-24 10:46:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>219</td>\n",
       "      <td>2024-01-03</td>\n",
       "      <td>0 days 10:17:00</td>\n",
       "      <td>0 days 10:39:00</td>\n",
       "      <td>2024-06-24 10:46:28</td>\n",
       "      <td>2024-06-24 10:46:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>263</td>\n",
       "      <td>2024-07-15</td>\n",
       "      <td>0 days 08:26:00</td>\n",
       "      <td>0 days 08:46:00</td>\n",
       "      <td>2024-06-24 10:46:28</td>\n",
       "      <td>2024-06-24 10:46:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>276</td>\n",
       "      <td>2024-02-10</td>\n",
       "      <td>0 days 12:05:00</td>\n",
       "      <td>0 days 12:14:00</td>\n",
       "      <td>2024-06-24 10:46:28</td>\n",
       "      <td>2024-06-24 10:46:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>225</td>\n",
       "      <td>2024-12-17</td>\n",
       "      <td>0 days 14:18:00</td>\n",
       "      <td>0 days 14:26:00</td>\n",
       "      <td>2024-06-24 10:46:28</td>\n",
       "      <td>2024-06-24 10:46:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>96</td>\n",
       "      <td>2</td>\n",
       "      <td>230</td>\n",
       "      <td>2024-09-26</td>\n",
       "      <td>0 days 12:06:00</td>\n",
       "      <td>0 days 12:20:00</td>\n",
       "      <td>2024-06-24 10:46:28</td>\n",
       "      <td>2024-06-24 10:46:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>97</td>\n",
       "      <td>1</td>\n",
       "      <td>215</td>\n",
       "      <td>2024-12-12</td>\n",
       "      <td>0 days 08:19:00</td>\n",
       "      <td>0 days 08:49:00</td>\n",
       "      <td>2024-06-24 10:46:28</td>\n",
       "      <td>2024-06-24 10:46:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>98</td>\n",
       "      <td>2</td>\n",
       "      <td>212</td>\n",
       "      <td>2024-01-12</td>\n",
       "      <td>0 days 11:08:00</td>\n",
       "      <td>0 days 11:32:00</td>\n",
       "      <td>2024-06-24 10:46:28</td>\n",
       "      <td>2024-06-24 10:46:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>99</td>\n",
       "      <td>5</td>\n",
       "      <td>299</td>\n",
       "      <td>2024-11-19</td>\n",
       "      <td>0 days 15:23:00</td>\n",
       "      <td>0 days 15:30:00</td>\n",
       "      <td>2024-06-24 10:46:28</td>\n",
       "      <td>2024-06-24 10:46:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>100</td>\n",
       "      <td>8</td>\n",
       "      <td>265</td>\n",
       "      <td>2024-07-08</td>\n",
       "      <td>0 days 10:12:00</td>\n",
       "      <td>0 days 10:35:00</td>\n",
       "      <td>2024-06-24 10:46:28</td>\n",
       "      <td>2024-06-24 10:46:28</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     id  partner_id  user_id      fecha     hora_inicio        hora_fin  \\\n",
       "0     1           3      235 2024-03-10 0 days 10:01:00 0 days 10:02:00   \n",
       "1     2           7      219 2024-01-03 0 days 10:17:00 0 days 10:39:00   \n",
       "2     3           6      263 2024-07-15 0 days 08:26:00 0 days 08:46:00   \n",
       "3     4           6      276 2024-02-10 0 days 12:05:00 0 days 12:14:00   \n",
       "4     5           7      225 2024-12-17 0 days 14:18:00 0 days 14:26:00   \n",
       "..  ...         ...      ...        ...             ...             ...   \n",
       "95   96           2      230 2024-09-26 0 days 12:06:00 0 days 12:20:00   \n",
       "96   97           1      215 2024-12-12 0 days 08:19:00 0 days 08:49:00   \n",
       "97   98           2      212 2024-01-12 0 days 11:08:00 0 days 11:32:00   \n",
       "98   99           5      299 2024-11-19 0 days 15:23:00 0 days 15:30:00   \n",
       "99  100           8      265 2024-07-08 0 days 10:12:00 0 days 10:35:00   \n",
       "\n",
       "             createdAt           updatedAt  \n",
       "0  2024-06-24 10:46:28 2024-06-24 10:46:28  \n",
       "1  2024-06-24 10:46:28 2024-06-24 10:46:28  \n",
       "2  2024-06-24 10:46:28 2024-06-24 10:46:28  \n",
       "3  2024-06-24 10:46:28 2024-06-24 10:46:28  \n",
       "4  2024-06-24 10:46:28 2024-06-24 10:46:28  \n",
       "..                 ...                 ...  \n",
       "95 2024-06-24 10:46:28 2024-06-24 10:46:28  \n",
       "96 2024-06-24 10:46:28 2024-06-24 10:46:28  \n",
       "97 2024-06-24 10:46:28 2024-06-24 10:46:28  \n",
       "98 2024-06-24 10:46:28 2024-06-24 10:46:28  \n",
       "99 2024-06-24 10:46:28 2024-06-24 10:46:28  \n",
       "\n",
       "[100 rows x 8 columns]"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Meetings.to_sql(\"Meetings\", engine, if_exists=\"replace\", index=False)\n",
    "query = \"SELECT * FROM Meetings;\"\n",
    "pd.read_sql(query, engine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Archivo CSV guardado correctamente.\n"
     ]
    }
   ],
   "source": [
    "query = \"\"\"\n",
    "    SELECT *\n",
    "    FROM Users \n",
    "\n",
    "\"\"\"\n",
    "user_new = pd.read_sql(query, engine)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Archivo CSV guardado correctamente.\n"
     ]
    }
   ],
   "source": [
    "\n",
    "# Guardar el DataFrame como un archivo CSV\n",
    "Users.to_csv('users_data.csv', index=False)\n",
    "\n",
    "print(\"Archivo CSV guardado correctamente.\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "ename": "OperationalError",
     "evalue": "(pymysql.err.OperationalError) (3140, 'Invalid JSON text: \"Invalid value.\" at position 0 in value for column \\'Events.asistentes\\'.')\n[SQL: UPDATE `Events` SET asistentes=%(asistentes)s]\n[parameters: {'asistentes': 'Nuevo valor para todos los asistentes'}]\n(Background on this error at: https://sqlalche.me/e/20/e3q8)",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mOperationalError\u001b[0m                          Traceback (most recent call last)",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/sqlalchemy/engine/base.py:1967\u001b[0m, in \u001b[0;36mConnection._exec_single_context\u001b[0;34m(self, dialect, context, statement, parameters)\u001b[0m\n\u001b[1;32m   1966\u001b[0m     \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;129;01mnot\u001b[39;00m evt_handled:\n\u001b[0;32m-> 1967\u001b[0m         \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mdialect\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mdo_execute\u001b[49m\u001b[43m(\u001b[49m\n\u001b[1;32m   1968\u001b[0m \u001b[43m            \u001b[49m\u001b[43mcursor\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mstr_statement\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43meffective_parameters\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mcontext\u001b[49m\n\u001b[1;32m   1969\u001b[0m \u001b[43m        \u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m   1971\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_has_events \u001b[38;5;129;01mor\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mengine\u001b[38;5;241m.\u001b[39m_has_events:\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/sqlalchemy/engine/default.py:924\u001b[0m, in \u001b[0;36mDefaultDialect.do_execute\u001b[0;34m(self, cursor, statement, parameters, context)\u001b[0m\n\u001b[1;32m    923\u001b[0m \u001b[38;5;28;01mdef\u001b[39;00m \u001b[38;5;21mdo_execute\u001b[39m(\u001b[38;5;28mself\u001b[39m, cursor, statement, parameters, context\u001b[38;5;241m=\u001b[39m\u001b[38;5;28;01mNone\u001b[39;00m):\n\u001b[0;32m--> 924\u001b[0m     \u001b[43mcursor\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mexecute\u001b[49m\u001b[43m(\u001b[49m\u001b[43mstatement\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mparameters\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/pymysql/cursors.py:153\u001b[0m, in \u001b[0;36mCursor.execute\u001b[0;34m(self, query, args)\u001b[0m\n\u001b[1;32m    151\u001b[0m query \u001b[38;5;241m=\u001b[39m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mmogrify(query, args)\n\u001b[0;32m--> 153\u001b[0m result \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_query\u001b[49m\u001b[43m(\u001b[49m\u001b[43mquery\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    154\u001b[0m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_executed \u001b[38;5;241m=\u001b[39m query\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/pymysql/cursors.py:322\u001b[0m, in \u001b[0;36mCursor._query\u001b[0;34m(self, q)\u001b[0m\n\u001b[1;32m    321\u001b[0m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_clear_result()\n\u001b[0;32m--> 322\u001b[0m \u001b[43mconn\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mquery\u001b[49m\u001b[43m(\u001b[49m\u001b[43mq\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    323\u001b[0m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_do_get_result()\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/pymysql/connections.py:563\u001b[0m, in \u001b[0;36mConnection.query\u001b[0;34m(self, sql, unbuffered)\u001b[0m\n\u001b[1;32m    562\u001b[0m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_execute_command(COMMAND\u001b[38;5;241m.\u001b[39mCOM_QUERY, sql)\n\u001b[0;32m--> 563\u001b[0m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_affected_rows \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_read_query_result\u001b[49m\u001b[43m(\u001b[49m\u001b[43munbuffered\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43munbuffered\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    564\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_affected_rows\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/pymysql/connections.py:825\u001b[0m, in \u001b[0;36mConnection._read_query_result\u001b[0;34m(self, unbuffered)\u001b[0m\n\u001b[1;32m    824\u001b[0m     result \u001b[38;5;241m=\u001b[39m MySQLResult(\u001b[38;5;28mself\u001b[39m)\n\u001b[0;32m--> 825\u001b[0m     \u001b[43mresult\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mread\u001b[49m\u001b[43m(\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    826\u001b[0m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_result \u001b[38;5;241m=\u001b[39m result\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/pymysql/connections.py:1199\u001b[0m, in \u001b[0;36mMySQLResult.read\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m   1198\u001b[0m \u001b[38;5;28;01mtry\u001b[39;00m:\n\u001b[0;32m-> 1199\u001b[0m     first_packet \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mconnection\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_read_packet\u001b[49m\u001b[43m(\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m   1201\u001b[0m     \u001b[38;5;28;01mif\u001b[39;00m first_packet\u001b[38;5;241m.\u001b[39mis_ok_packet():\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/pymysql/connections.py:775\u001b[0m, in \u001b[0;36mConnection._read_packet\u001b[0;34m(self, packet_type)\u001b[0m\n\u001b[1;32m    774\u001b[0m         \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_result\u001b[38;5;241m.\u001b[39munbuffered_active \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;01mFalse\u001b[39;00m\n\u001b[0;32m--> 775\u001b[0m     \u001b[43mpacket\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mraise_for_error\u001b[49m\u001b[43m(\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    776\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m packet\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/pymysql/protocol.py:219\u001b[0m, in \u001b[0;36mMysqlPacket.raise_for_error\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    218\u001b[0m     \u001b[38;5;28mprint\u001b[39m(\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124merrno =\u001b[39m\u001b[38;5;124m\"\u001b[39m, errno)\n\u001b[0;32m--> 219\u001b[0m \u001b[43merr\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mraise_mysql_exception\u001b[49m\u001b[43m(\u001b[49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_data\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/pymysql/err.py:150\u001b[0m, in \u001b[0;36mraise_mysql_exception\u001b[0;34m(data)\u001b[0m\n\u001b[1;32m    149\u001b[0m     errorclass \u001b[38;5;241m=\u001b[39m InternalError \u001b[38;5;28;01mif\u001b[39;00m errno \u001b[38;5;241m<\u001b[39m \u001b[38;5;241m1000\u001b[39m \u001b[38;5;28;01melse\u001b[39;00m OperationalError\n\u001b[0;32m--> 150\u001b[0m \u001b[38;5;28;01mraise\u001b[39;00m errorclass(errno, errval)\n",
      "\u001b[0;31mOperationalError\u001b[0m: (3140, 'Invalid JSON text: \"Invalid value.\" at position 0 in value for column \\'Events.asistentes\\'.')",
      "\nThe above exception was the direct cause of the following exception:\n",
      "\u001b[0;31mOperationalError\u001b[0m                          Traceback (most recent call last)",
      "Cell \u001b[0;32mIn[66], line 23\u001b[0m\n\u001b[1;32m     20\u001b[0m update_query \u001b[38;5;241m=\u001b[39m events_table\u001b[38;5;241m.\u001b[39mupdate()\u001b[38;5;241m.\u001b[39mvalues(asistentes\u001b[38;5;241m=\u001b[39mnew_attendees_value)\n\u001b[1;32m     22\u001b[0m \u001b[38;5;66;03m# Ejecutar la query de actualización\u001b[39;00m\n\u001b[0;32m---> 23\u001b[0m \u001b[43msession\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mexecute\u001b[49m\u001b[43m(\u001b[49m\u001b[43mupdate_query\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m     25\u001b[0m \u001b[38;5;66;03m# Confirmar los cambios en la base de datos\u001b[39;00m\n\u001b[1;32m     26\u001b[0m session\u001b[38;5;241m.\u001b[39mcommit()\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/sqlalchemy/orm/session.py:2351\u001b[0m, in \u001b[0;36mSession.execute\u001b[0;34m(self, statement, params, execution_options, bind_arguments, _parent_execute_state, _add_event)\u001b[0m\n\u001b[1;32m   2290\u001b[0m \u001b[38;5;28;01mdef\u001b[39;00m \u001b[38;5;21mexecute\u001b[39m(\n\u001b[1;32m   2291\u001b[0m     \u001b[38;5;28mself\u001b[39m,\n\u001b[1;32m   2292\u001b[0m     statement: Executable,\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m   2298\u001b[0m     _add_event: Optional[Any] \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;01mNone\u001b[39;00m,\n\u001b[1;32m   2299\u001b[0m ) \u001b[38;5;241m-\u001b[39m\u001b[38;5;241m>\u001b[39m Result[Any]:\n\u001b[1;32m   2300\u001b[0m \u001b[38;5;250m    \u001b[39m\u001b[38;5;124mr\u001b[39m\u001b[38;5;124;03m\"\"\"Execute a SQL expression construct.\u001b[39;00m\n\u001b[1;32m   2301\u001b[0m \n\u001b[1;32m   2302\u001b[0m \u001b[38;5;124;03m    Returns a :class:`_engine.Result` object representing\u001b[39;00m\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m   2349\u001b[0m \n\u001b[1;32m   2350\u001b[0m \u001b[38;5;124;03m    \"\"\"\u001b[39;00m\n\u001b[0;32m-> 2351\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_execute_internal\u001b[49m\u001b[43m(\u001b[49m\n\u001b[1;32m   2352\u001b[0m \u001b[43m        \u001b[49m\u001b[43mstatement\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   2353\u001b[0m \u001b[43m        \u001b[49m\u001b[43mparams\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   2354\u001b[0m \u001b[43m        \u001b[49m\u001b[43mexecution_options\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mexecution_options\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   2355\u001b[0m \u001b[43m        \u001b[49m\u001b[43mbind_arguments\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mbind_arguments\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   2356\u001b[0m \u001b[43m        \u001b[49m\u001b[43m_parent_execute_state\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43m_parent_execute_state\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   2357\u001b[0m \u001b[43m        \u001b[49m\u001b[43m_add_event\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43m_add_event\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   2358\u001b[0m \u001b[43m    \u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/sqlalchemy/orm/session.py:2245\u001b[0m, in \u001b[0;36mSession._execute_internal\u001b[0;34m(self, statement, params, execution_options, bind_arguments, _parent_execute_state, _add_event, _scalar_result)\u001b[0m\n\u001b[1;32m   2236\u001b[0m     result: Result[Any] \u001b[38;5;241m=\u001b[39m compile_state_cls\u001b[38;5;241m.\u001b[39morm_execute_statement(\n\u001b[1;32m   2237\u001b[0m         \u001b[38;5;28mself\u001b[39m,\n\u001b[1;32m   2238\u001b[0m         statement,\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m   2242\u001b[0m         conn,\n\u001b[1;32m   2243\u001b[0m     )\n\u001b[1;32m   2244\u001b[0m \u001b[38;5;28;01melse\u001b[39;00m:\n\u001b[0;32m-> 2245\u001b[0m     result \u001b[38;5;241m=\u001b[39m \u001b[43mconn\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mexecute\u001b[49m\u001b[43m(\u001b[49m\n\u001b[1;32m   2246\u001b[0m \u001b[43m        \u001b[49m\u001b[43mstatement\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mparams\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;129;43;01mor\u001b[39;49;00m\u001b[43m \u001b[49m\u001b[43m{\u001b[49m\u001b[43m}\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mexecution_options\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mexecution_options\u001b[49m\n\u001b[1;32m   2247\u001b[0m \u001b[43m    \u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m   2249\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m _scalar_result:\n\u001b[1;32m   2250\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m result\u001b[38;5;241m.\u001b[39mscalar()\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/sqlalchemy/engine/base.py:1418\u001b[0m, in \u001b[0;36mConnection.execute\u001b[0;34m(self, statement, parameters, execution_options)\u001b[0m\n\u001b[1;32m   1416\u001b[0m     \u001b[38;5;28;01mraise\u001b[39;00m exc\u001b[38;5;241m.\u001b[39mObjectNotExecutableError(statement) \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01merr\u001b[39;00m\n\u001b[1;32m   1417\u001b[0m \u001b[38;5;28;01melse\u001b[39;00m:\n\u001b[0;32m-> 1418\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[43mmeth\u001b[49m\u001b[43m(\u001b[49m\n\u001b[1;32m   1419\u001b[0m \u001b[43m        \u001b[49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[43m,\u001b[49m\n\u001b[1;32m   1420\u001b[0m \u001b[43m        \u001b[49m\u001b[43mdistilled_parameters\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   1421\u001b[0m \u001b[43m        \u001b[49m\u001b[43mexecution_options\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;129;43;01mor\u001b[39;49;00m\u001b[43m \u001b[49m\u001b[43mNO_OPTIONS\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   1422\u001b[0m \u001b[43m    \u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/sqlalchemy/sql/elements.py:515\u001b[0m, in \u001b[0;36mClauseElement._execute_on_connection\u001b[0;34m(self, connection, distilled_params, execution_options)\u001b[0m\n\u001b[1;32m    513\u001b[0m     \u001b[38;5;28;01mif\u001b[39;00m TYPE_CHECKING:\n\u001b[1;32m    514\u001b[0m         \u001b[38;5;28;01massert\u001b[39;00m \u001b[38;5;28misinstance\u001b[39m(\u001b[38;5;28mself\u001b[39m, Executable)\n\u001b[0;32m--> 515\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[43mconnection\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_execute_clauseelement\u001b[49m\u001b[43m(\u001b[49m\n\u001b[1;32m    516\u001b[0m \u001b[43m        \u001b[49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mdistilled_params\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mexecution_options\u001b[49m\n\u001b[1;32m    517\u001b[0m \u001b[43m    \u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    518\u001b[0m \u001b[38;5;28;01melse\u001b[39;00m:\n\u001b[1;32m    519\u001b[0m     \u001b[38;5;28;01mraise\u001b[39;00m exc\u001b[38;5;241m.\u001b[39mObjectNotExecutableError(\u001b[38;5;28mself\u001b[39m)\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/sqlalchemy/engine/base.py:1640\u001b[0m, in \u001b[0;36mConnection._execute_clauseelement\u001b[0;34m(self, elem, distilled_parameters, execution_options)\u001b[0m\n\u001b[1;32m   1628\u001b[0m compiled_cache: Optional[CompiledCacheType] \u001b[38;5;241m=\u001b[39m execution_options\u001b[38;5;241m.\u001b[39mget(\n\u001b[1;32m   1629\u001b[0m     \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mcompiled_cache\u001b[39m\u001b[38;5;124m\"\u001b[39m, \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mengine\u001b[38;5;241m.\u001b[39m_compiled_cache\n\u001b[1;32m   1630\u001b[0m )\n\u001b[1;32m   1632\u001b[0m compiled_sql, extracted_params, cache_hit \u001b[38;5;241m=\u001b[39m elem\u001b[38;5;241m.\u001b[39m_compile_w_cache(\n\u001b[1;32m   1633\u001b[0m     dialect\u001b[38;5;241m=\u001b[39mdialect,\n\u001b[1;32m   1634\u001b[0m     compiled_cache\u001b[38;5;241m=\u001b[39mcompiled_cache,\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m   1638\u001b[0m     linting\u001b[38;5;241m=\u001b[39m\u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mdialect\u001b[38;5;241m.\u001b[39mcompiler_linting \u001b[38;5;241m|\u001b[39m compiler\u001b[38;5;241m.\u001b[39mWARN_LINTING,\n\u001b[1;32m   1639\u001b[0m )\n\u001b[0;32m-> 1640\u001b[0m ret \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_execute_context\u001b[49m\u001b[43m(\u001b[49m\n\u001b[1;32m   1641\u001b[0m \u001b[43m    \u001b[49m\u001b[43mdialect\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   1642\u001b[0m \u001b[43m    \u001b[49m\u001b[43mdialect\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mexecution_ctx_cls\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_init_compiled\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   1643\u001b[0m \u001b[43m    \u001b[49m\u001b[43mcompiled_sql\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   1644\u001b[0m \u001b[43m    \u001b[49m\u001b[43mdistilled_parameters\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   1645\u001b[0m \u001b[43m    \u001b[49m\u001b[43mexecution_options\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   1646\u001b[0m \u001b[43m    \u001b[49m\u001b[43mcompiled_sql\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   1647\u001b[0m \u001b[43m    \u001b[49m\u001b[43mdistilled_parameters\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   1648\u001b[0m \u001b[43m    \u001b[49m\u001b[43melem\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   1649\u001b[0m \u001b[43m    \u001b[49m\u001b[43mextracted_params\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   1650\u001b[0m \u001b[43m    \u001b[49m\u001b[43mcache_hit\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mcache_hit\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   1651\u001b[0m \u001b[43m\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m   1652\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m has_events:\n\u001b[1;32m   1653\u001b[0m     \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mdispatch\u001b[38;5;241m.\u001b[39mafter_execute(\n\u001b[1;32m   1654\u001b[0m         \u001b[38;5;28mself\u001b[39m,\n\u001b[1;32m   1655\u001b[0m         elem,\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m   1659\u001b[0m         ret,\n\u001b[1;32m   1660\u001b[0m     )\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/sqlalchemy/engine/base.py:1846\u001b[0m, in \u001b[0;36mConnection._execute_context\u001b[0;34m(self, dialect, constructor, statement, parameters, execution_options, *args, **kw)\u001b[0m\n\u001b[1;32m   1844\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_exec_insertmany_context(dialect, context)\n\u001b[1;32m   1845\u001b[0m \u001b[38;5;28;01melse\u001b[39;00m:\n\u001b[0;32m-> 1846\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_exec_single_context\u001b[49m\u001b[43m(\u001b[49m\n\u001b[1;32m   1847\u001b[0m \u001b[43m        \u001b[49m\u001b[43mdialect\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mcontext\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mstatement\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mparameters\u001b[49m\n\u001b[1;32m   1848\u001b[0m \u001b[43m    \u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/sqlalchemy/engine/base.py:1986\u001b[0m, in \u001b[0;36mConnection._exec_single_context\u001b[0;34m(self, dialect, context, statement, parameters)\u001b[0m\n\u001b[1;32m   1983\u001b[0m     result \u001b[38;5;241m=\u001b[39m context\u001b[38;5;241m.\u001b[39m_setup_result_proxy()\n\u001b[1;32m   1985\u001b[0m \u001b[38;5;28;01mexcept\u001b[39;00m \u001b[38;5;167;01mBaseException\u001b[39;00m \u001b[38;5;28;01mas\u001b[39;00m e:\n\u001b[0;32m-> 1986\u001b[0m     \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_handle_dbapi_exception\u001b[49m\u001b[43m(\u001b[49m\n\u001b[1;32m   1987\u001b[0m \u001b[43m        \u001b[49m\u001b[43me\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mstr_statement\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43meffective_parameters\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mcursor\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mcontext\u001b[49m\n\u001b[1;32m   1988\u001b[0m \u001b[43m    \u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m   1990\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m result\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/sqlalchemy/engine/base.py:2353\u001b[0m, in \u001b[0;36mConnection._handle_dbapi_exception\u001b[0;34m(self, e, statement, parameters, cursor, context, is_sub_exec)\u001b[0m\n\u001b[1;32m   2351\u001b[0m \u001b[38;5;28;01melif\u001b[39;00m should_wrap:\n\u001b[1;32m   2352\u001b[0m     \u001b[38;5;28;01massert\u001b[39;00m sqlalchemy_exception \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;129;01mnot\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m\n\u001b[0;32m-> 2353\u001b[0m     \u001b[38;5;28;01mraise\u001b[39;00m sqlalchemy_exception\u001b[38;5;241m.\u001b[39mwith_traceback(exc_info[\u001b[38;5;241m2\u001b[39m]) \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01me\u001b[39;00m\n\u001b[1;32m   2354\u001b[0m \u001b[38;5;28;01melse\u001b[39;00m:\n\u001b[1;32m   2355\u001b[0m     \u001b[38;5;28;01massert\u001b[39;00m exc_info[\u001b[38;5;241m1\u001b[39m] \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;129;01mnot\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/sqlalchemy/engine/base.py:1967\u001b[0m, in \u001b[0;36mConnection._exec_single_context\u001b[0;34m(self, dialect, context, statement, parameters)\u001b[0m\n\u001b[1;32m   1965\u001b[0m                 \u001b[38;5;28;01mbreak\u001b[39;00m\n\u001b[1;32m   1966\u001b[0m     \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;129;01mnot\u001b[39;00m evt_handled:\n\u001b[0;32m-> 1967\u001b[0m         \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mdialect\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mdo_execute\u001b[49m\u001b[43m(\u001b[49m\n\u001b[1;32m   1968\u001b[0m \u001b[43m            \u001b[49m\u001b[43mcursor\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mstr_statement\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43meffective_parameters\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mcontext\u001b[49m\n\u001b[1;32m   1969\u001b[0m \u001b[43m        \u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m   1971\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_has_events \u001b[38;5;129;01mor\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mengine\u001b[38;5;241m.\u001b[39m_has_events:\n\u001b[1;32m   1972\u001b[0m     \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mdispatch\u001b[38;5;241m.\u001b[39mafter_cursor_execute(\n\u001b[1;32m   1973\u001b[0m         \u001b[38;5;28mself\u001b[39m,\n\u001b[1;32m   1974\u001b[0m         cursor,\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m   1978\u001b[0m         context\u001b[38;5;241m.\u001b[39mexecutemany,\n\u001b[1;32m   1979\u001b[0m     )\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/sqlalchemy/engine/default.py:924\u001b[0m, in \u001b[0;36mDefaultDialect.do_execute\u001b[0;34m(self, cursor, statement, parameters, context)\u001b[0m\n\u001b[1;32m    923\u001b[0m \u001b[38;5;28;01mdef\u001b[39;00m \u001b[38;5;21mdo_execute\u001b[39m(\u001b[38;5;28mself\u001b[39m, cursor, statement, parameters, context\u001b[38;5;241m=\u001b[39m\u001b[38;5;28;01mNone\u001b[39;00m):\n\u001b[0;32m--> 924\u001b[0m     \u001b[43mcursor\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mexecute\u001b[49m\u001b[43m(\u001b[49m\u001b[43mstatement\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mparameters\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/pymysql/cursors.py:153\u001b[0m, in \u001b[0;36mCursor.execute\u001b[0;34m(self, query, args)\u001b[0m\n\u001b[1;32m    149\u001b[0m     \u001b[38;5;28;01mpass\u001b[39;00m\n\u001b[1;32m    151\u001b[0m query \u001b[38;5;241m=\u001b[39m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mmogrify(query, args)\n\u001b[0;32m--> 153\u001b[0m result \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_query\u001b[49m\u001b[43m(\u001b[49m\u001b[43mquery\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    154\u001b[0m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_executed \u001b[38;5;241m=\u001b[39m query\n\u001b[1;32m    155\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m result\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/pymysql/cursors.py:322\u001b[0m, in \u001b[0;36mCursor._query\u001b[0;34m(self, q)\u001b[0m\n\u001b[1;32m    320\u001b[0m conn \u001b[38;5;241m=\u001b[39m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_get_db()\n\u001b[1;32m    321\u001b[0m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_clear_result()\n\u001b[0;32m--> 322\u001b[0m \u001b[43mconn\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mquery\u001b[49m\u001b[43m(\u001b[49m\u001b[43mq\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    323\u001b[0m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_do_get_result()\n\u001b[1;32m    324\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mrowcount\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/pymysql/connections.py:563\u001b[0m, in \u001b[0;36mConnection.query\u001b[0;34m(self, sql, unbuffered)\u001b[0m\n\u001b[1;32m    561\u001b[0m     sql \u001b[38;5;241m=\u001b[39m sql\u001b[38;5;241m.\u001b[39mencode(\u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mencoding, \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124msurrogateescape\u001b[39m\u001b[38;5;124m\"\u001b[39m)\n\u001b[1;32m    562\u001b[0m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_execute_command(COMMAND\u001b[38;5;241m.\u001b[39mCOM_QUERY, sql)\n\u001b[0;32m--> 563\u001b[0m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_affected_rows \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_read_query_result\u001b[49m\u001b[43m(\u001b[49m\u001b[43munbuffered\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43munbuffered\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    564\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_affected_rows\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/pymysql/connections.py:825\u001b[0m, in \u001b[0;36mConnection._read_query_result\u001b[0;34m(self, unbuffered)\u001b[0m\n\u001b[1;32m    823\u001b[0m \u001b[38;5;28;01melse\u001b[39;00m:\n\u001b[1;32m    824\u001b[0m     result \u001b[38;5;241m=\u001b[39m MySQLResult(\u001b[38;5;28mself\u001b[39m)\n\u001b[0;32m--> 825\u001b[0m     \u001b[43mresult\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mread\u001b[49m\u001b[43m(\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    826\u001b[0m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_result \u001b[38;5;241m=\u001b[39m result\n\u001b[1;32m    827\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m result\u001b[38;5;241m.\u001b[39mserver_status \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;129;01mnot\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m:\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/pymysql/connections.py:1199\u001b[0m, in \u001b[0;36mMySQLResult.read\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m   1197\u001b[0m \u001b[38;5;28;01mdef\u001b[39;00m \u001b[38;5;21mread\u001b[39m(\u001b[38;5;28mself\u001b[39m):\n\u001b[1;32m   1198\u001b[0m     \u001b[38;5;28;01mtry\u001b[39;00m:\n\u001b[0;32m-> 1199\u001b[0m         first_packet \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mconnection\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_read_packet\u001b[49m\u001b[43m(\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m   1201\u001b[0m         \u001b[38;5;28;01mif\u001b[39;00m first_packet\u001b[38;5;241m.\u001b[39mis_ok_packet():\n\u001b[1;32m   1202\u001b[0m             \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_read_ok_packet(first_packet)\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/pymysql/connections.py:775\u001b[0m, in \u001b[0;36mConnection._read_packet\u001b[0;34m(self, packet_type)\u001b[0m\n\u001b[1;32m    773\u001b[0m     \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_result \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;129;01mnot\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m \u001b[38;5;129;01mand\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_result\u001b[38;5;241m.\u001b[39munbuffered_active \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;28;01mTrue\u001b[39;00m:\n\u001b[1;32m    774\u001b[0m         \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_result\u001b[38;5;241m.\u001b[39munbuffered_active \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;01mFalse\u001b[39;00m\n\u001b[0;32m--> 775\u001b[0m     \u001b[43mpacket\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mraise_for_error\u001b[49m\u001b[43m(\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    776\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m packet\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/pymysql/protocol.py:219\u001b[0m, in \u001b[0;36mMysqlPacket.raise_for_error\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    217\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m DEBUG:\n\u001b[1;32m    218\u001b[0m     \u001b[38;5;28mprint\u001b[39m(\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124merrno =\u001b[39m\u001b[38;5;124m\"\u001b[39m, errno)\n\u001b[0;32m--> 219\u001b[0m \u001b[43merr\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mraise_mysql_exception\u001b[49m\u001b[43m(\u001b[49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_data\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[0;32m~/miniconda3/envs/API_ENV/lib/python3.10/site-packages/pymysql/err.py:150\u001b[0m, in \u001b[0;36mraise_mysql_exception\u001b[0;34m(data)\u001b[0m\n\u001b[1;32m    148\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m errorclass \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m:\n\u001b[1;32m    149\u001b[0m     errorclass \u001b[38;5;241m=\u001b[39m InternalError \u001b[38;5;28;01mif\u001b[39;00m errno \u001b[38;5;241m<\u001b[39m \u001b[38;5;241m1000\u001b[39m \u001b[38;5;28;01melse\u001b[39;00m OperationalError\n\u001b[0;32m--> 150\u001b[0m \u001b[38;5;28;01mraise\u001b[39;00m errorclass(errno, errval)\n",
      "\u001b[0;31mOperationalError\u001b[0m: (pymysql.err.OperationalError) (3140, 'Invalid JSON text: \"Invalid value.\" at position 0 in value for column \\'Events.asistentes\\'.')\n[SQL: UPDATE `Events` SET asistentes=%(asistentes)s]\n[parameters: {'asistentes': 'Nuevo valor para todos los asistentes'}]\n(Background on this error at: https://sqlalche.me/e/20/e3q8)"
     ]
    }
   ],
   "source": [
    "from sqlalchemy import create_engine, MetaData, Table, Column, Integer, String\n",
    "from sqlalchemy.orm import sessionmaker\n",
    "\n",
    "# Definir la metadata y la tabla\n",
    "metadata = MetaData()\n",
    "events_table = Table('Events', metadata,\n",
    "    Column('id', Integer, primary_key=True),\n",
    "    Column('nombre', String),\n",
    "    Column('asistentes', String)  # Definir la columna 'asistentes' como tipo String\n",
    ")\n",
    "\n",
    "# Crear la sesión\n",
    "Session = sessionmaker(bind=engine)\n",
    "session = Session()\n",
    "\n",
    "# Nuevo valor para actualizar en la columna 'asistentes'\n",
    "new_attendees_value = \"Nuevo valor para todos los asistentes\"\n",
    "\n",
    "# Construir la query de actualización\n",
    "update_query = events_table.update().values(asistentes=new_attendees_value)\n",
    "\n",
    "# Ejecutar la query de actualización\n",
    "session.execute(update_query)\n",
    "\n",
    "# Confirmar los cambios en la base de datos\n",
    "session.commit()\n",
    "\n",
    "# Cerrar la sesión\n",
    "session.close()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "puesto_trabajo                                     \n",
       "Productor de Multimedia Educativa                      36\n",
       "Desarrollador de Contenidos de e-Learning              35\n",
       "Coordinador de Programas de e-Learning                 34\n",
       "Analista de Datos Educativos                           31\n",
       "Tutor o Facilitador de e-Learning                      31\n",
       "Consultor de e-Learning                                30\n",
       "Especialista en LMS (Learning Management Systems)      30\n",
       "Diseñador Gráfico para e-Learning                      28\n",
       "Especialista en Evaluación y Certificación en Línea    23\n",
       "Diseñador Instruccional                                22\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 108,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Users[['puesto_trabajo']].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pais   \n",
       "USA        66\n",
       "France     64\n",
       "Canada     62\n",
       "UK         60\n",
       "Germany    48\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 109,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Users[['pais']].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "interes   \n",
       "Tecnología    79\n",
       "Finanzas      78\n",
       "Educación     77\n",
       "Salud         66\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 110,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Users[['interes']].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "alergenos\n",
       "Lactose      84\n",
       "Peanuts      82\n",
       "Gluten       68\n",
       "Nada         66\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 111,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Users[['alergenos']].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "'puesto_trabajo', 'pais', 'interes', 'alergenos'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#pd.to_sql(\"ponencias\", engine, if_exists=\"replace\", index=False)\n",
    "query = \"SELECT * FROM ponencias;\"\n",
    "pd.read_sql(query, engine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "API_ENV",
   "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.14"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}