Comparacion_de_precios.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Comparación de precios de iPhones en Perú\n",
    "\n",
    "Se utilizarán tecnicas de web scraping para conseguir información sobre las distintas tiendas.\n",
    "\n",
    "Coders:\n",
    "- Anchante Fernandez, Marcello\n",
    "- Batalla Flores, Stephano"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Objetivos\n",
    "\n",
    "- Determinar precios de 3 tiendas conocidas: Saga Falabella, Hiraoka y Mercado Libre."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Resultados de iPhone's vendidos por Falabella"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "## En caso no contar con los paquetes\n",
    "# !pip install bs4\n",
    "# !pip install requests\n",
    "# !pip install pandas\n",
    "# !pip install pdfkit\n",
    "# !pip install jinja2\n",
    "# !pip install yagmail\n",
    "\n",
    "## Importante instalar el archivo 'wkhtmltox-0.12.6-1.msvc2015-win64.exe'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from bs4 import BeautifulSoup\n",
    "import re\n",
    "import requests\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "def obtener_enlaces(url):\n",
    "    content = requests.get(url).text\n",
    "    soup = BeautifulSoup(content, 'html.parser')\n",
    "    enlaces_similares = re.findall(r\"https://www\\.falabella\\.com\\.pe/falabella-pe/product/\\w+\", content)\n",
    "    celulares_enlaces = list(set(enlaces_similares))\n",
    "        \n",
    "    return celulares_enlaces\n",
    "    \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "celulares_enlaces = obtener_enlaces('https://www.falabella.com.pe/falabella-pe/category/cat760706/Celulares-y-Telefonos?sortBy=derived.price.search%2Cdesc&facetSelected=true&f.derived.variant.sellerId=FALABELLA&f.product.brandName=apple')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "def precio(url):\n",
    " \n",
    "    precios = []\n",
    "    titulos = []\n",
    "    marcas = []\n",
    "    modelos = []\n",
    "    capacidades = []\n",
    "    ext = []\n",
    "\n",
    "    for u in url:\n",
    "        content = requests.get(u).text\n",
    "        soup = BeautifulSoup(content, 'html.parser')\n",
    "        \n",
    "        titulo = soup.find('div', class_='jsx-1442607798')\n",
    "        precio = soup.find('span', class_='copy17')\n",
    "\n",
    "        if titulo and precio:\n",
    "            titulos.append(titulo.text)\n",
    "            precios.append(int(precio.text.replace(' ', '').replace(',', '').replace('S/','')))\n",
    "\n",
    "            marca = 'Apple'\n",
    "            modelo_match = re.search(r'iPhone\\s([\\w\\s]+)\\s\\d+GB', titulo.text)\n",
    "            modelo = modelo_match.group(1).strip() if modelo_match else \"\"\n",
    "            capacidad_match = re.search(r'\\d+GB', titulo.text)\n",
    "            capacidad = capacidad_match.group(0) if capacidad_match else \"\"\n",
    "            extras_match = re.search(r'\\+\\s*(.*)$', titulo.text)\n",
    "            extras = extras_match.group(1).strip() if extras_match else \"-\"\n",
    "            \n",
    "            capacidad = re.sub(r'(\\d+)(GB)', r'\\1 \\2', capacidad)\n",
    "\n",
    "            marcas.append(marca)\n",
    "            modelos.append('iPhone ' + modelo.lstrip().rstrip())\n",
    "            capacidades.append(capacidad)\n",
    "            ext.append(extras)\n",
    "        \n",
    "    tabla = pd.DataFrame({'Marca': marcas, \n",
    "                          'Modelo': modelos, \n",
    "                          'Capacidad': capacidades, \n",
    "                          'Extras': ext, \n",
    "                          'Precio (S/.)': precios, \n",
    "                          'Enlace':(celulares_enlaces),\n",
    "                          'Tienda':'Falabella'})\n",
    "    return tabla\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>Marca</th>\n",
       "      <th>Modelo</th>\n",
       "      <th>Capacidad</th>\n",
       "      <th>Extras</th>\n",
       "      <th>Precio (S/.)</th>\n",
       "      <th>Enlace</th>\n",
       "      <th>Tienda</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>-</td>\n",
       "      <td>5899</td>\n",
       "      <td>https://www.falabella.com.pe/falabella-pe/prod...</td>\n",
       "      <td>Falabella</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>-</td>\n",
       "      <td>4099</td>\n",
       "      <td>https://www.falabella.com.pe/falabella-pe/prod...</td>\n",
       "      <td>Falabella</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>-</td>\n",
       "      <td>5599</td>\n",
       "      <td>https://www.falabella.com.pe/falabella-pe/prod...</td>\n",
       "      <td>Falabella</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 13</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>-</td>\n",
       "      <td>3399</td>\n",
       "      <td>https://www.falabella.com.pe/falabella-pe/prod...</td>\n",
       "      <td>Falabella</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>-</td>\n",
       "      <td>4799</td>\n",
       "      <td>https://www.falabella.com.pe/falabella-pe/prod...</td>\n",
       "      <td>Falabella</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 11</td>\n",
       "      <td>64 GB</td>\n",
       "      <td>-</td>\n",
       "      <td>1799</td>\n",
       "      <td>https://www.falabella.com.pe/falabella-pe/prod...</td>\n",
       "      <td>Falabella</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>-</td>\n",
       "      <td>4299</td>\n",
       "      <td>https://www.falabella.com.pe/falabella-pe/prod...</td>\n",
       "      <td>Falabella</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone SE</td>\n",
       "      <td>64 GB</td>\n",
       "      <td>-</td>\n",
       "      <td>1499</td>\n",
       "      <td>https://www.falabella.com.pe/falabella-pe/prod...</td>\n",
       "      <td>Falabella</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 11</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>-</td>\n",
       "      <td>2299</td>\n",
       "      <td>https://www.falabella.com.pe/falabella-pe/prod...</td>\n",
       "      <td>Falabella</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 11</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Case iPhone 11 Transparente</td>\n",
       "      <td>3599</td>\n",
       "      <td>https://www.falabella.com.pe/falabella-pe/prod...</td>\n",
       "      <td>Falabella</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>-</td>\n",
       "      <td>5699</td>\n",
       "      <td>https://www.falabella.com.pe/falabella-pe/prod...</td>\n",
       "      <td>Falabella</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 13</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>-</td>\n",
       "      <td>3099</td>\n",
       "      <td>https://www.falabella.com.pe/falabella-pe/prod...</td>\n",
       "      <td>Falabella</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Audífonos AirPods 2nda Generación</td>\n",
       "      <td>5849</td>\n",
       "      <td>https://www.falabella.com.pe/falabella-pe/prod...</td>\n",
       "      <td>Falabella</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Audífonos AirPods 2nda Generación</td>\n",
       "      <td>5849</td>\n",
       "      <td>https://www.falabella.com.pe/falabella-pe/prod...</td>\n",
       "      <td>Falabella</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Audífonos AirPods 2nda Generación</td>\n",
       "      <td>5849</td>\n",
       "      <td>https://www.falabella.com.pe/falabella-pe/prod...</td>\n",
       "      <td>Falabella</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 11</td>\n",
       "      <td>64 GB</td>\n",
       "      <td>Case iPhone 11 Transparente</td>\n",
       "      <td>3299</td>\n",
       "      <td>https://www.falabella.com.pe/falabella-pe/prod...</td>\n",
       "      <td>Falabella</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>-</td>\n",
       "      <td>5099</td>\n",
       "      <td>https://www.falabella.com.pe/falabella-pe/prod...</td>\n",
       "      <td>Falabella</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>-</td>\n",
       "      <td>3799</td>\n",
       "      <td>https://www.falabella.com.pe/falabella-pe/prod...</td>\n",
       "      <td>Falabella</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Audífonos AirPods 2nda Generación</td>\n",
       "      <td>5849</td>\n",
       "      <td>https://www.falabella.com.pe/falabella-pe/prod...</td>\n",
       "      <td>Falabella</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Marca             Modelo Capacidad                             Extras  \\\n",
       "0   Apple  iPhone 14 Pro Max    256 GB                                  -   \n",
       "1   Apple          iPhone 14    256 GB                                  -   \n",
       "2   Apple      iPhone 14 Pro    256 GB                                  -   \n",
       "3   Apple          iPhone 13    256 GB                                  -   \n",
       "4   Apple     iPhone 14 Plus    256 GB                                  -   \n",
       "5   Apple          iPhone 11     64 GB                                  -   \n",
       "6   Apple     iPhone 14 Plus    128 GB                                  -   \n",
       "7   Apple          iPhone SE     64 GB                                  -   \n",
       "8   Apple          iPhone 11    128 GB                                  -   \n",
       "9   Apple          iPhone 11    128 GB        Case iPhone 11 Transparente   \n",
       "10  Apple  iPhone 14 Pro Max    128 GB                                  -   \n",
       "11  Apple          iPhone 13    128 GB                                  -   \n",
       "12  Apple          iPhone 14    128 GB  Audífonos AirPods 2nda Generación   \n",
       "13  Apple          iPhone 14    128 GB  Audífonos AirPods 2nda Generación   \n",
       "14  Apple          iPhone 14    128 GB  Audífonos AirPods 2nda Generación   \n",
       "15  Apple          iPhone 11     64 GB        Case iPhone 11 Transparente   \n",
       "16  Apple      iPhone 14 Pro    128 GB                                  -   \n",
       "17  Apple          iPhone 14    128 GB                                  -   \n",
       "18  Apple          iPhone 14    128 GB  Audífonos AirPods 2nda Generación   \n",
       "\n",
       "    Precio (S/.)                                             Enlace     Tienda  \n",
       "0           5899  https://www.falabella.com.pe/falabella-pe/prod...  Falabella  \n",
       "1           4099  https://www.falabella.com.pe/falabella-pe/prod...  Falabella  \n",
       "2           5599  https://www.falabella.com.pe/falabella-pe/prod...  Falabella  \n",
       "3           3399  https://www.falabella.com.pe/falabella-pe/prod...  Falabella  \n",
       "4           4799  https://www.falabella.com.pe/falabella-pe/prod...  Falabella  \n",
       "5           1799  https://www.falabella.com.pe/falabella-pe/prod...  Falabella  \n",
       "6           4299  https://www.falabella.com.pe/falabella-pe/prod...  Falabella  \n",
       "7           1499  https://www.falabella.com.pe/falabella-pe/prod...  Falabella  \n",
       "8           2299  https://www.falabella.com.pe/falabella-pe/prod...  Falabella  \n",
       "9           3599  https://www.falabella.com.pe/falabella-pe/prod...  Falabella  \n",
       "10          5699  https://www.falabella.com.pe/falabella-pe/prod...  Falabella  \n",
       "11          3099  https://www.falabella.com.pe/falabella-pe/prod...  Falabella  \n",
       "12          5849  https://www.falabella.com.pe/falabella-pe/prod...  Falabella  \n",
       "13          5849  https://www.falabella.com.pe/falabella-pe/prod...  Falabella  \n",
       "14          5849  https://www.falabella.com.pe/falabella-pe/prod...  Falabella  \n",
       "15          3299  https://www.falabella.com.pe/falabella-pe/prod...  Falabella  \n",
       "16          5099  https://www.falabella.com.pe/falabella-pe/prod...  Falabella  \n",
       "17          3799  https://www.falabella.com.pe/falabella-pe/prod...  Falabella  \n",
       "18          5849  https://www.falabella.com.pe/falabella-pe/prod...  Falabella  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "falabella = precio(celulares_enlaces)\n",
    "falabella"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Resultados de iPhone's vendidos por MercadoLibre"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from bs4 import BeautifulSoup\n",
    "import re\n",
    "import requests\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "def tabla_mercadolibre(url):\n",
    "\n",
    "    response = requests.get(url)\n",
    "    soup = BeautifulSoup(response.text, \"html.parser\")\n",
    "\n",
    "    product_list = soup.find_all(\"div\", class_=\"ui-search-result__content-wrapper\")\n",
    "    resultados = soup.find_all('span', attrs={#'class':\"andes-money-amount__fraction\",\n",
    "                                              #'aria-hidden':'true'\n",
    "                                              'class':'andes-money-amount ui-search-price__part shops__price-part andes-money-amount--cents-superscript'})\n",
    "    \n",
    "    \n",
    "\n",
    "    precios = []\n",
    "    for resultado in resultados:\n",
    "        precios.append(int(resultado.find_all('span', class_='andes-money-amount__fraction')[0].text.replace('.','')))\n",
    "    \n",
    "\n",
    "    mar = []\n",
    "    mod = []\n",
    "    cap = []\n",
    "    col = []\n",
    "        \n",
    "\n",
    "    for product in product_list:\n",
    "\n",
    "        name = product.find(\"h2\", class_=\"ui-search-item__title\").text.strip()\n",
    "        \n",
    "        marca = 'Apple'\n",
    "\n",
    "        modelo = re.findall(r\"(.*?)\\s\\(\", name)\n",
    "        if len(modelo) > 0:\n",
    "            modelo = re.findall(r\"(.*?)\\s\\(\", name)[0]\n",
    "        else: modelo = '-'\n",
    "\n",
    "        capacidad = re.findall(r\"\\((.*?)\\)\",name)[0]\n",
    "        color = re.findall(r\"\\-\\s(.+)$\",name)\n",
    "        if len(color) > 0:\n",
    "            color = re.findall(r\"\\-\\s(.+)$\", name)[0]\n",
    "        else: color = 'No especificado'\n",
    "        \n",
    "        capacidad = re.sub(r'(\\d+)\\s*([gG]b)', r'\\1 GB', capacidad)\n",
    "        mar.append(marca)\n",
    "        mod.append(modelo.replace('Apple ',''))\n",
    "        cap.append(capacidad)\n",
    "        col.append(color)\n",
    "       \n",
    "    # return mar, mod, cap, col, precios\n",
    "    return pd.DataFrame({'Marca':mar,\n",
    "                            'Modelo':mod,\n",
    "                            'Capacidad':cap,\n",
    "                            'Color':col,\n",
    "                            'Precio (S/.)':precios,\n",
    "                            'Tienda':'Mercado Libre'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>Marca</th>\n",
       "      <th>Modelo</th>\n",
       "      <th>Capacidad</th>\n",
       "      <th>Color</th>\n",
       "      <th>Precio (S/.)</th>\n",
       "      <th>Tienda</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 13</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Azul medianoche</td>\n",
       "      <td>3349</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 13</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Blanco estelar</td>\n",
       "      <td>3349</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 11</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Negro</td>\n",
       "      <td>2149</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Morado oscuro</td>\n",
       "      <td>6299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Negro espacial</td>\n",
       "      <td>5699</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 13</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Azul</td>\n",
       "      <td>3349</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 11</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Blanco</td>\n",
       "      <td>2149</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Negro espacial</td>\n",
       "      <td>6299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Morado oscuro</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Color oro</td>\n",
       "      <td>5699</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Morado</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Negro espacial</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 12</td>\n",
       "      <td>64 GB</td>\n",
       "      <td>Negro</td>\n",
       "      <td>3099</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Color plata</td>\n",
       "      <td>5699</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Color oro</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Color plata</td>\n",
       "      <td>6299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Color plata</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Blanco estelar</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Azul</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>(PRODUCT)RED</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Morado oscuro</td>\n",
       "      <td>5899</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Color oro</td>\n",
       "      <td>5899</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Morado</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Blanco estelar</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Medianoche</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Azul</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>(PRODUCT)RED</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 12 mini</td>\n",
       "      <td>64 GB</td>\n",
       "      <td>Negro</td>\n",
       "      <td>3619</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 11</td>\n",
       "      <td>64 GB</td>\n",
       "      <td>Blanco</td>\n",
       "      <td>1899</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 11</td>\n",
       "      <td>64 GB</td>\n",
       "      <td>Negro</td>\n",
       "      <td>1899</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 13</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>3349</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 11</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>2149</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5699</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 12</td>\n",
       "      <td>64 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>3099</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 12 Mini</td>\n",
       "      <td>64 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>3619</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>6299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5899</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 11</td>\n",
       "      <td>64 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>1899</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 11</td>\n",
       "      <td>64 GB</td>\n",
       "      <td>Negro + 20w Usb-c Power Adapter</td>\n",
       "      <td>2089</td>\n",
       "      <td>Mercado Libre</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Marca             Modelo Capacidad                            Color  \\\n",
       "0   Apple          iPhone 13    128 GB                  Azul medianoche   \n",
       "1   Apple          iPhone 13    128 GB                   Blanco estelar   \n",
       "2   Apple          iPhone 11    128 GB                            Negro   \n",
       "3   Apple  iPhone 14 Pro Max    256 GB                    Morado oscuro   \n",
       "4   Apple  iPhone 14 Pro Max    128 GB                   Negro espacial   \n",
       "5   Apple          iPhone 13    128 GB                             Azul   \n",
       "6   Apple          iPhone 11    128 GB                           Blanco   \n",
       "7   Apple  iPhone 14 Pro Max    256 GB                   Negro espacial   \n",
       "8   Apple      iPhone 14 Pro    128 GB                    Morado oscuro   \n",
       "9   Apple  iPhone 14 Pro Max    128 GB                        Color oro   \n",
       "10  Apple          iPhone 14    128 GB                           Morado   \n",
       "11  Apple      iPhone 14 Pro    128 GB                   Negro espacial   \n",
       "12  Apple          iPhone 12     64 GB                            Negro   \n",
       "13  Apple  iPhone 14 Pro Max    128 GB                      Color plata   \n",
       "14  Apple      iPhone 14 Pro    128 GB                        Color oro   \n",
       "15  Apple  iPhone 14 Pro Max    256 GB                      Color plata   \n",
       "16  Apple      iPhone 14 Pro    128 GB                      Color plata   \n",
       "17  Apple     iPhone 14 Plus    128 GB                   Blanco estelar   \n",
       "18  Apple     iPhone 14 Plus    128 GB                             Azul   \n",
       "19  Apple     iPhone 14 Plus    128 GB                     (PRODUCT)RED   \n",
       "20  Apple      iPhone 14 Pro    256 GB                    Morado oscuro   \n",
       "21  Apple      iPhone 14 Pro    256 GB                        Color oro   \n",
       "22  Apple     iPhone 14 Plus    256 GB                           Morado   \n",
       "23  Apple     iPhone 14 Plus    256 GB                   Blanco estelar   \n",
       "24  Apple     iPhone 14 Plus    256 GB                       Medianoche   \n",
       "25  Apple     iPhone 14 Plus    256 GB                             Azul   \n",
       "26  Apple     iPhone 14 Plus    256 GB                     (PRODUCT)RED   \n",
       "27  Apple     iPhone 12 mini     64 GB                            Negro   \n",
       "28  Apple          iPhone 11     64 GB                           Blanco   \n",
       "29  Apple          iPhone 11     64 GB                            Negro   \n",
       "30  Apple          iPhone 13    128 GB                  No especificado   \n",
       "31  Apple          iPhone 11    128 GB                  No especificado   \n",
       "32  Apple  iPhone 14 Pro Max    128 GB                  No especificado   \n",
       "33  Apple          iPhone 14    128 GB                  No especificado   \n",
       "34  Apple      iPhone 14 Pro    128 GB                  No especificado   \n",
       "35  Apple     iPhone 14 Plus    128 GB                  No especificado   \n",
       "36  Apple          iPhone 12     64 GB                  No especificado   \n",
       "37  Apple     iPhone 12 Mini     64 GB                  No especificado   \n",
       "38  Apple  iPhone 14 Pro Max    256 GB                  No especificado   \n",
       "39  Apple      iPhone 14 Pro    256 GB                  No especificado   \n",
       "40  Apple     iPhone 14 Plus    256 GB                  No especificado   \n",
       "41  Apple          iPhone 11     64 GB                  No especificado   \n",
       "42  Apple          iPhone 11     64 GB  Negro + 20w Usb-c Power Adapter   \n",
       "\n",
       "    Precio (S/.)         Tienda  \n",
       "0           3349  Mercado Libre  \n",
       "1           3349  Mercado Libre  \n",
       "2           2149  Mercado Libre  \n",
       "3           6299  Mercado Libre  \n",
       "4           5699  Mercado Libre  \n",
       "5           3349  Mercado Libre  \n",
       "6           2149  Mercado Libre  \n",
       "7           6299  Mercado Libre  \n",
       "8           5299  Mercado Libre  \n",
       "9           5699  Mercado Libre  \n",
       "10          4299  Mercado Libre  \n",
       "11          5299  Mercado Libre  \n",
       "12          3099  Mercado Libre  \n",
       "13          5699  Mercado Libre  \n",
       "14          5299  Mercado Libre  \n",
       "15          6299  Mercado Libre  \n",
       "16          5299  Mercado Libre  \n",
       "17          4299  Mercado Libre  \n",
       "18          4299  Mercado Libre  \n",
       "19          4299  Mercado Libre  \n",
       "20          5899  Mercado Libre  \n",
       "21          5899  Mercado Libre  \n",
       "22          5299  Mercado Libre  \n",
       "23          5299  Mercado Libre  \n",
       "24          5299  Mercado Libre  \n",
       "25          5299  Mercado Libre  \n",
       "26          5299  Mercado Libre  \n",
       "27          3619  Mercado Libre  \n",
       "28          1899  Mercado Libre  \n",
       "29          1899  Mercado Libre  \n",
       "30          3349  Mercado Libre  \n",
       "31          2149  Mercado Libre  \n",
       "32          5699  Mercado Libre  \n",
       "33          4299  Mercado Libre  \n",
       "34          5299  Mercado Libre  \n",
       "35          4299  Mercado Libre  \n",
       "36          3099  Mercado Libre  \n",
       "37          3619  Mercado Libre  \n",
       "38          6299  Mercado Libre  \n",
       "39          5899  Mercado Libre  \n",
       "40          5299  Mercado Libre  \n",
       "41          1899  Mercado Libre  \n",
       "42          2089  Mercado Libre  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mercado_libre =(tabla_mercadolibre('https://listado.mercadolibre.com.pe/celulares-telefonos/celulares-smartphones/apple/nuevo/_Tienda_apple_af_to#unapplied_filter_id%3Dinstallments%26unapplied_filter_name%3DPago%26unapplied_value_id%3Dno_interest%26unapplied_value_name%3DSin+inter%C3%A9s%26unapplied_autoselect%3Dfalse'))\n",
    "mercado_libre"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Resultados de iPhone's vendidos por Hiraoka"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from bs4 import BeautifulSoup\n",
    "import re\n",
    "import requests\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "def tabla_hiraoka(url):\n",
    "    content = requests.get(url).text\n",
    "    soup = BeautifulSoup(content, 'html.parser')\n",
    "    results = int(soup.find('span', class_='toolbar-number').text)\n",
    "    pages = results//20 + 1\n",
    "    urls = []\n",
    "    for page in range(1,pages+1):\n",
    "        urls.append(f'https://hiraoka.com.pe/apple-peru/iphone?p={page}')\n",
    "    precios = []\n",
    "    titles = []\n",
    "    listas = []\n",
    "    celular = []\n",
    "    for url in urls:\n",
    "        content = requests.get(url).text\n",
    "        soup = BeautifulSoup(content, 'html.parser')\n",
    "        prices = soup.find_all('span',attrs = {'data-price-type':'finalPrice'})\n",
    "        titles.append(soup.find_all('a',class_='product-item-link'))\n",
    "        for price in prices:\n",
    "            precios.append(int(float(price.text.replace('S/ ','').replace(',',''))))\n",
    "\n",
    "        \n",
    "        content = requests.get(url).text\n",
    "        soup = BeautifulSoup(content, 'html.parser')\n",
    "        titles = soup.find_all('a',class_='product-item-link')\n",
    "\n",
    "            \n",
    "        for title in titles:\n",
    "            listas.append(title.text.strip().replace('APPLE','Apple'))\n",
    "\n",
    "        celular =  [elemento for elemento in listas if elemento != 'Apple']\n",
    "        while '' in celular:\n",
    "            celular.remove('')\n",
    "        regex = r'^(.*?)\\s(\\d+\\.\\d+)\\\"\\s(\\d+GB)\\s(.+)$'\n",
    "        modelo = []\n",
    "        capacidad= []\n",
    "        color = []\n",
    "        for item in celular:\n",
    "            match = re.search(regex, item)\n",
    "            if match:\n",
    "                modelo.append(match.group(1))\n",
    "                capacidad.append(match.group(3))\n",
    "                color.append(match.group(4))\n",
    "            capacidades = []\n",
    "            for elemento in capacidad:\n",
    "                capacidades.append(re.sub(r'(\\d+)(GB)', r'\\1 \\2', elemento))\n",
    "                \n",
    "    hiraoka = pd.DataFrame({'Marca':'Apple',\n",
    "                    'Modelo':modelo,\n",
    "                    'Capacidad':capacidades,\n",
    "                    'Color':color,\n",
    "                    'Precio (S/.)':precios,\n",
    "                    'Tienda':'Hiraoka'})\n",
    "    return hiraoka"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>Marca</th>\n",
       "      <th>Modelo</th>\n",
       "      <th>Capacidad</th>\n",
       "      <th>Color</th>\n",
       "      <th>Precio (S/.)</th>\n",
       "      <th>Tienda</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 11</td>\n",
       "      <td>64 GB</td>\n",
       "      <td>Blanco</td>\n",
       "      <td>3199</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Blanco Estelar</td>\n",
       "      <td>6299</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Morado</td>\n",
       "      <td>6299</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 11</td>\n",
       "      <td>64 GB</td>\n",
       "      <td>4GB RAM Negro</td>\n",
       "      <td>3199</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 11</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Blanco</td>\n",
       "      <td>3499</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 11</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Negro</td>\n",
       "      <td>3499</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 13</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Azul</td>\n",
       "      <td>5799</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 13</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Verde</td>\n",
       "      <td>4399</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Blanco Estelar</td>\n",
       "      <td>4999</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Medianoche</td>\n",
       "      <td>4999</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Azul</td>\n",
       "      <td>3899</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Medianoche</td>\n",
       "      <td>6299</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Medianoche</td>\n",
       "      <td>5599</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Blanco Estelar</td>\n",
       "      <td>5599</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Negro Espacial</td>\n",
       "      <td>5199</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Morado Oscuro</td>\n",
       "      <td>5199</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 13 Pro</td>\n",
       "      <td>512 GB</td>\n",
       "      <td>Grafito</td>\n",
       "      <td>6199</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Plata</td>\n",
       "      <td>5199</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Medianoche</td>\n",
       "      <td>5599</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Plata</td>\n",
       "      <td>5799</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Morado</td>\n",
       "      <td>5599</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 13 Pro</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Azul Sierra</td>\n",
       "      <td>5199</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Rojo</td>\n",
       "      <td>4999</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 13</td>\n",
       "      <td>512 GB</td>\n",
       "      <td>Verde</td>\n",
       "      <td>4999</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Negro Espacial</td>\n",
       "      <td>5799</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Blanco Estelar</td>\n",
       "      <td>5599</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Morado Oscuro</td>\n",
       "      <td>5799</td>\n",
       "      <td>Hiraoka</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Marca             Modelo Capacidad           Color  Precio (S/.)   Tienda\n",
       "0   Apple          iPhone 11     64 GB          Blanco          3199  Hiraoka\n",
       "1   Apple     iPhone 14 Plus    256 GB  Blanco Estelar          6299  Hiraoka\n",
       "2   Apple     iPhone 14 Plus    256 GB          Morado          6299  Hiraoka\n",
       "3   Apple          iPhone 11     64 GB   4GB RAM Negro          3199  Hiraoka\n",
       "4   Apple          iPhone 11    128 GB          Blanco          3499  Hiraoka\n",
       "5   Apple          iPhone 11    128 GB           Negro          3499  Hiraoka\n",
       "6   Apple          iPhone 13    256 GB            Azul          5799  Hiraoka\n",
       "7   Apple          iPhone 13    256 GB           Verde          4399  Hiraoka\n",
       "8   Apple          iPhone 14    128 GB  Blanco Estelar          4999  Hiraoka\n",
       "9   Apple          iPhone 14    128 GB      Medianoche          4999  Hiraoka\n",
       "10  Apple          iPhone 14    128 GB            Azul          3899  Hiraoka\n",
       "11  Apple     iPhone 14 Plus    256 GB      Medianoche          6299  Hiraoka\n",
       "12  Apple     iPhone 14 Plus    128 GB      Medianoche          5599  Hiraoka\n",
       "13  Apple     iPhone 14 Plus    128 GB  Blanco Estelar          5599  Hiraoka\n",
       "14  Apple      iPhone 14 Pro    128 GB  Negro Espacial          5199  Hiraoka\n",
       "15  Apple      iPhone 14 Pro    128 GB   Morado Oscuro          5199  Hiraoka\n",
       "16  Apple      iPhone 13 Pro    512 GB         Grafito          6199  Hiraoka\n",
       "17  Apple      iPhone 14 Pro    128 GB           Plata          5199  Hiraoka\n",
       "18  Apple          iPhone 14    256 GB      Medianoche          5599  Hiraoka\n",
       "19  Apple  iPhone 14 Pro Max    128 GB           Plata          5799  Hiraoka\n",
       "20  Apple     iPhone 14 Plus    128 GB          Morado          5599  Hiraoka\n",
       "21  Apple      iPhone 13 Pro    256 GB     Azul Sierra          5199  Hiraoka\n",
       "22  Apple     iPhone 14 Plus    256 GB            Rojo          4999  Hiraoka\n",
       "23  Apple          iPhone 13    512 GB           Verde          4999  Hiraoka\n",
       "24  Apple  iPhone 14 Pro Max    128 GB  Negro Espacial          5799  Hiraoka\n",
       "25  Apple          iPhone 14    256 GB  Blanco Estelar          5599  Hiraoka\n",
       "26  Apple  iPhone 14 Pro Max    128 GB   Morado Oscuro          5799  Hiraoka"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hiraoka = tabla_hiraoka('https://hiraoka.com.pe/apple-peru/iphone')\n",
    "hiraoka"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Exportando cada tabla"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "falabella.to_csv('iPhones_Falabella.csv', index=False)\n",
    "\n",
    "mercado_libre.to_csv('iPhones_Mercado_Libre.csv', index=False)\n",
    "\n",
    "hiraoka.to_csv('iPhones_Hiraoka.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "precios_iphone = pd.concat([mercado_libre,hiraoka,falabella]).iloc[:,:7].reset_index().drop('index', axis = 1)\n",
    "precios_iphone['Color'] = precios_iphone['Color'].fillna('No especificado')\n",
    "precios_iphone['Extras'] = precios_iphone['Extras'].fillna('-')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "precios_iphone.to_csv('iPhones_Tiendas.csv',index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Filtrando iPhones"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>Marca</th>\n",
       "      <th>Modelo</th>\n",
       "      <th>Capacidad</th>\n",
       "      <th>Color</th>\n",
       "      <th>Precio (S/.)</th>\n",
       "      <th>Tienda</th>\n",
       "      <th>Extras</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Morado</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Blanco Estelar</td>\n",
       "      <td>4999</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Medianoche</td>\n",
       "      <td>4999</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Azul</td>\n",
       "      <td>3899</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Medianoche</td>\n",
       "      <td>5599</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Blanco Estelar</td>\n",
       "      <td>5599</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>4099</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5849</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>Audífonos AirPods 2nda Generación</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5849</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>Audífonos AirPods 2nda Generación</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5849</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>Audífonos AirPods 2nda Generación</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>3799</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5849</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>Audífonos AirPods 2nda Generación</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Marca     Modelo Capacidad            Color  Precio (S/.)         Tienda  \\\n",
       "10  Apple  iPhone 14    128 GB           Morado          4299  Mercado Libre   \n",
       "33  Apple  iPhone 14    128 GB  No especificado          4299  Mercado Libre   \n",
       "51  Apple  iPhone 14    128 GB   Blanco Estelar          4999        Hiraoka   \n",
       "52  Apple  iPhone 14    128 GB       Medianoche          4999        Hiraoka   \n",
       "53  Apple  iPhone 14    128 GB             Azul          3899        Hiraoka   \n",
       "61  Apple  iPhone 14    256 GB       Medianoche          5599        Hiraoka   \n",
       "68  Apple  iPhone 14    256 GB   Blanco Estelar          5599        Hiraoka   \n",
       "71  Apple  iPhone 14    256 GB  No especificado          4099      Falabella   \n",
       "82  Apple  iPhone 14    128 GB  No especificado          5849      Falabella   \n",
       "83  Apple  iPhone 14    128 GB  No especificado          5849      Falabella   \n",
       "84  Apple  iPhone 14    128 GB  No especificado          5849      Falabella   \n",
       "87  Apple  iPhone 14    128 GB  No especificado          3799      Falabella   \n",
       "88  Apple  iPhone 14    128 GB  No especificado          5849      Falabella   \n",
       "\n",
       "                               Extras  \n",
       "10                                  -  \n",
       "33                                  -  \n",
       "51                                  -  \n",
       "52                                  -  \n",
       "53                                  -  \n",
       "61                                  -  \n",
       "68                                  -  \n",
       "71                                  -  \n",
       "82  Audífonos AirPods 2nda Generación  \n",
       "83  Audífonos AirPods 2nda Generación  \n",
       "84  Audífonos AirPods 2nda Generación  \n",
       "87                                  -  \n",
       "88  Audífonos AirPods 2nda Generación  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "precios_iphone[precios_iphone['Modelo'] == 'iPhone 14']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Buscador de filas\n",
    "\n",
    "# Este buscador nos permite buscar similar a los caracteres escritos.\n",
    "\n",
    "def buscar_filas(busqueda, dataframe):\n",
    "    resultado = dataframe[dataframe.apply(lambda row: row.astype(str).str.contains(busqueda, case=False).any(), axis=1)]\n",
    "    return resultado\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Modelo de iPhoneiPhone 14\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Marca</th>\n",
       "      <th>Modelo</th>\n",
       "      <th>Capacidad</th>\n",
       "      <th>Color</th>\n",
       "      <th>Precio (S/.)</th>\n",
       "      <th>Tienda</th>\n",
       "      <th>Extras</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Morado oscuro</td>\n",
       "      <td>6299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Negro espacial</td>\n",
       "      <td>5699</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Negro espacial</td>\n",
       "      <td>6299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Morado oscuro</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Color oro</td>\n",
       "      <td>5699</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Morado</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Negro espacial</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Color plata</td>\n",
       "      <td>5699</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Color oro</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Color plata</td>\n",
       "      <td>6299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Color plata</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Blanco estelar</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Azul</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>(PRODUCT)RED</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Morado oscuro</td>\n",
       "      <td>5899</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Color oro</td>\n",
       "      <td>5899</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Morado</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Blanco estelar</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Medianoche</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Azul</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>(PRODUCT)RED</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5699</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>6299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5899</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Blanco Estelar</td>\n",
       "      <td>6299</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Morado</td>\n",
       "      <td>6299</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Blanco Estelar</td>\n",
       "      <td>4999</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Medianoche</td>\n",
       "      <td>4999</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Azul</td>\n",
       "      <td>3899</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Medianoche</td>\n",
       "      <td>6299</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Medianoche</td>\n",
       "      <td>5599</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Blanco Estelar</td>\n",
       "      <td>5599</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Negro Espacial</td>\n",
       "      <td>5199</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Morado Oscuro</td>\n",
       "      <td>5199</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Plata</td>\n",
       "      <td>5199</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Medianoche</td>\n",
       "      <td>5599</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Plata</td>\n",
       "      <td>5799</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Morado</td>\n",
       "      <td>5599</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Rojo</td>\n",
       "      <td>4999</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Negro Espacial</td>\n",
       "      <td>5799</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Blanco Estelar</td>\n",
       "      <td>5599</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Morado Oscuro</td>\n",
       "      <td>5799</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5899</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>4099</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5599</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>4799</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>4299</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5699</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5849</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>Audífonos AirPods 2nda Generación</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5849</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>Audífonos AirPods 2nda Generación</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5849</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>Audífonos AirPods 2nda Generación</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5099</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>3799</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5849</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>Audífonos AirPods 2nda Generación</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Marca             Modelo Capacidad            Color  Precio (S/.)  \\\n",
       "3   Apple  iPhone 14 Pro Max    256 GB    Morado oscuro          6299   \n",
       "4   Apple  iPhone 14 Pro Max    128 GB   Negro espacial          5699   \n",
       "7   Apple  iPhone 14 Pro Max    256 GB   Negro espacial          6299   \n",
       "8   Apple      iPhone 14 Pro    128 GB    Morado oscuro          5299   \n",
       "9   Apple  iPhone 14 Pro Max    128 GB        Color oro          5699   \n",
       "10  Apple          iPhone 14    128 GB           Morado          4299   \n",
       "11  Apple      iPhone 14 Pro    128 GB   Negro espacial          5299   \n",
       "13  Apple  iPhone 14 Pro Max    128 GB      Color plata          5699   \n",
       "14  Apple      iPhone 14 Pro    128 GB        Color oro          5299   \n",
       "15  Apple  iPhone 14 Pro Max    256 GB      Color plata          6299   \n",
       "16  Apple      iPhone 14 Pro    128 GB      Color plata          5299   \n",
       "17  Apple     iPhone 14 Plus    128 GB   Blanco estelar          4299   \n",
       "18  Apple     iPhone 14 Plus    128 GB             Azul          4299   \n",
       "19  Apple     iPhone 14 Plus    128 GB     (PRODUCT)RED          4299   \n",
       "20  Apple      iPhone 14 Pro    256 GB    Morado oscuro          5899   \n",
       "21  Apple      iPhone 14 Pro    256 GB        Color oro          5899   \n",
       "22  Apple     iPhone 14 Plus    256 GB           Morado          5299   \n",
       "23  Apple     iPhone 14 Plus    256 GB   Blanco estelar          5299   \n",
       "24  Apple     iPhone 14 Plus    256 GB       Medianoche          5299   \n",
       "25  Apple     iPhone 14 Plus    256 GB             Azul          5299   \n",
       "26  Apple     iPhone 14 Plus    256 GB     (PRODUCT)RED          5299   \n",
       "32  Apple  iPhone 14 Pro Max    128 GB  No especificado          5699   \n",
       "33  Apple          iPhone 14    128 GB  No especificado          4299   \n",
       "34  Apple      iPhone 14 Pro    128 GB  No especificado          5299   \n",
       "35  Apple     iPhone 14 Plus    128 GB  No especificado          4299   \n",
       "38  Apple  iPhone 14 Pro Max    256 GB  No especificado          6299   \n",
       "39  Apple      iPhone 14 Pro    256 GB  No especificado          5899   \n",
       "40  Apple     iPhone 14 Plus    256 GB  No especificado          5299   \n",
       "44  Apple     iPhone 14 Plus    256 GB   Blanco Estelar          6299   \n",
       "45  Apple     iPhone 14 Plus    256 GB           Morado          6299   \n",
       "51  Apple          iPhone 14    128 GB   Blanco Estelar          4999   \n",
       "52  Apple          iPhone 14    128 GB       Medianoche          4999   \n",
       "53  Apple          iPhone 14    128 GB             Azul          3899   \n",
       "54  Apple     iPhone 14 Plus    256 GB       Medianoche          6299   \n",
       "55  Apple     iPhone 14 Plus    128 GB       Medianoche          5599   \n",
       "56  Apple     iPhone 14 Plus    128 GB   Blanco Estelar          5599   \n",
       "57  Apple      iPhone 14 Pro    128 GB   Negro Espacial          5199   \n",
       "58  Apple      iPhone 14 Pro    128 GB    Morado Oscuro          5199   \n",
       "60  Apple      iPhone 14 Pro    128 GB            Plata          5199   \n",
       "61  Apple          iPhone 14    256 GB       Medianoche          5599   \n",
       "62  Apple  iPhone 14 Pro Max    128 GB            Plata          5799   \n",
       "63  Apple     iPhone 14 Plus    128 GB           Morado          5599   \n",
       "65  Apple     iPhone 14 Plus    256 GB             Rojo          4999   \n",
       "67  Apple  iPhone 14 Pro Max    128 GB   Negro Espacial          5799   \n",
       "68  Apple          iPhone 14    256 GB   Blanco Estelar          5599   \n",
       "69  Apple  iPhone 14 Pro Max    128 GB    Morado Oscuro          5799   \n",
       "70  Apple  iPhone 14 Pro Max    256 GB  No especificado          5899   \n",
       "71  Apple          iPhone 14    256 GB  No especificado          4099   \n",
       "72  Apple      iPhone 14 Pro    256 GB  No especificado          5599   \n",
       "74  Apple     iPhone 14 Plus    256 GB  No especificado          4799   \n",
       "76  Apple     iPhone 14 Plus    128 GB  No especificado          4299   \n",
       "80  Apple  iPhone 14 Pro Max    128 GB  No especificado          5699   \n",
       "82  Apple          iPhone 14    128 GB  No especificado          5849   \n",
       "83  Apple          iPhone 14    128 GB  No especificado          5849   \n",
       "84  Apple          iPhone 14    128 GB  No especificado          5849   \n",
       "86  Apple      iPhone 14 Pro    128 GB  No especificado          5099   \n",
       "87  Apple          iPhone 14    128 GB  No especificado          3799   \n",
       "88  Apple          iPhone 14    128 GB  No especificado          5849   \n",
       "\n",
       "           Tienda                             Extras  \n",
       "3   Mercado Libre                                  -  \n",
       "4   Mercado Libre                                  -  \n",
       "7   Mercado Libre                                  -  \n",
       "8   Mercado Libre                                  -  \n",
       "9   Mercado Libre                                  -  \n",
       "10  Mercado Libre                                  -  \n",
       "11  Mercado Libre                                  -  \n",
       "13  Mercado Libre                                  -  \n",
       "14  Mercado Libre                                  -  \n",
       "15  Mercado Libre                                  -  \n",
       "16  Mercado Libre                                  -  \n",
       "17  Mercado Libre                                  -  \n",
       "18  Mercado Libre                                  -  \n",
       "19  Mercado Libre                                  -  \n",
       "20  Mercado Libre                                  -  \n",
       "21  Mercado Libre                                  -  \n",
       "22  Mercado Libre                                  -  \n",
       "23  Mercado Libre                                  -  \n",
       "24  Mercado Libre                                  -  \n",
       "25  Mercado Libre                                  -  \n",
       "26  Mercado Libre                                  -  \n",
       "32  Mercado Libre                                  -  \n",
       "33  Mercado Libre                                  -  \n",
       "34  Mercado Libre                                  -  \n",
       "35  Mercado Libre                                  -  \n",
       "38  Mercado Libre                                  -  \n",
       "39  Mercado Libre                                  -  \n",
       "40  Mercado Libre                                  -  \n",
       "44        Hiraoka                                  -  \n",
       "45        Hiraoka                                  -  \n",
       "51        Hiraoka                                  -  \n",
       "52        Hiraoka                                  -  \n",
       "53        Hiraoka                                  -  \n",
       "54        Hiraoka                                  -  \n",
       "55        Hiraoka                                  -  \n",
       "56        Hiraoka                                  -  \n",
       "57        Hiraoka                                  -  \n",
       "58        Hiraoka                                  -  \n",
       "60        Hiraoka                                  -  \n",
       "61        Hiraoka                                  -  \n",
       "62        Hiraoka                                  -  \n",
       "63        Hiraoka                                  -  \n",
       "65        Hiraoka                                  -  \n",
       "67        Hiraoka                                  -  \n",
       "68        Hiraoka                                  -  \n",
       "69        Hiraoka                                  -  \n",
       "70      Falabella                                  -  \n",
       "71      Falabella                                  -  \n",
       "72      Falabella                                  -  \n",
       "74      Falabella                                  -  \n",
       "76      Falabella                                  -  \n",
       "80      Falabella                                  -  \n",
       "82      Falabella  Audífonos AirPods 2nda Generación  \n",
       "83      Falabella  Audífonos AirPods 2nda Generación  \n",
       "84      Falabella  Audífonos AirPods 2nda Generación  \n",
       "86      Falabella                                  -  \n",
       "87      Falabella                                  -  \n",
       "88      Falabella  Audífonos AirPods 2nda Generación  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "buscar_filas(busqueda = input('Modelo de iPhone'), dataframe= precios_iphone)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Modelo de iPhoneiPhone 14\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Marca</th>\n",
       "      <th>Modelo</th>\n",
       "      <th>Capacidad</th>\n",
       "      <th>Color</th>\n",
       "      <th>Precio (S/.)</th>\n",
       "      <th>Tienda</th>\n",
       "      <th>Extras</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>3799</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Azul</td>\n",
       "      <td>3899</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>4099</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Morado</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Blanco Estelar</td>\n",
       "      <td>4999</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Medianoche</td>\n",
       "      <td>4999</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Medianoche</td>\n",
       "      <td>5599</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Blanco Estelar</td>\n",
       "      <td>5599</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5849</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>Audífonos AirPods 2nda Generación</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5849</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>Audífonos AirPods 2nda Generación</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5849</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>Audífonos AirPods 2nda Generación</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5849</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>Audífonos AirPods 2nda Generación</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Marca     Modelo Capacidad            Color  Precio (S/.)         Tienda  \\\n",
       "87  Apple  iPhone 14    128 GB  No especificado          3799      Falabella   \n",
       "53  Apple  iPhone 14    128 GB             Azul          3899        Hiraoka   \n",
       "71  Apple  iPhone 14    256 GB  No especificado          4099      Falabella   \n",
       "10  Apple  iPhone 14    128 GB           Morado          4299  Mercado Libre   \n",
       "33  Apple  iPhone 14    128 GB  No especificado          4299  Mercado Libre   \n",
       "51  Apple  iPhone 14    128 GB   Blanco Estelar          4999        Hiraoka   \n",
       "52  Apple  iPhone 14    128 GB       Medianoche          4999        Hiraoka   \n",
       "61  Apple  iPhone 14    256 GB       Medianoche          5599        Hiraoka   \n",
       "68  Apple  iPhone 14    256 GB   Blanco Estelar          5599        Hiraoka   \n",
       "82  Apple  iPhone 14    128 GB  No especificado          5849      Falabella   \n",
       "83  Apple  iPhone 14    128 GB  No especificado          5849      Falabella   \n",
       "84  Apple  iPhone 14    128 GB  No especificado          5849      Falabella   \n",
       "88  Apple  iPhone 14    128 GB  No especificado          5849      Falabella   \n",
       "\n",
       "                               Extras  \n",
       "87                                  -  \n",
       "53                                  -  \n",
       "71                                  -  \n",
       "10                                  -  \n",
       "33                                  -  \n",
       "51                                  -  \n",
       "52                                  -  \n",
       "61                                  -  \n",
       "68                                  -  \n",
       "82  Audífonos AirPods 2nda Generación  \n",
       "83  Audífonos AirPods 2nda Generación  \n",
       "84  Audífonos AirPods 2nda Generación  \n",
       "88  Audífonos AirPods 2nda Generación  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "precios_iphone[precios_iphone['Modelo'] == input('Modelo de iPhone')].sort_values('Precio (S/.)')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Presupuestando un iPhone"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "def presupuesto(df, max=10000, min=0, asc = True, busqueda = 'iPhone'):\n",
    "    df1 = df[df['Precio (S/.)']>= min]\n",
    "    df2 = df1[df1['Precio (S/.)'] <= max].sort_values('Precio (S/.)', ascending = asc)\n",
    "\n",
    "    resultado = df2[df2.apply(lambda row: row.astype(str).str.contains(busqueda, case=False).any(), axis=1)]\n",
    "    \n",
    "    return resultado"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Valor Máximo7000\n",
      "Valor mínimo2000\n",
      "Orden ascedente= True or FalseTrue\n",
      "Modelo de iPhoneiPhone 14\n"
     ]
    }
   ],
   "source": [
    "max=int(input('Valor Máximo'))\n",
    "min=int(input('Valor mínimo'))\n",
    "asc = bool(input('Orden ascedente= True or False'))\n",
    "busqueda=input('Modelo de iPhone')\n",
    "\n",
    "df = presupuesto(precios_iphone, max=max, min=min, asc = asc, busqueda=busqueda)\n",
    "\n",
    "df.to_csv('preferencias.csv',index=False)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>Marca</th>\n",
       "      <th>Modelo</th>\n",
       "      <th>Capacidad</th>\n",
       "      <th>Color</th>\n",
       "      <th>Precio (S/.)</th>\n",
       "      <th>Tienda</th>\n",
       "      <th>Extras</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>3799</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Azul</td>\n",
       "      <td>3899</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>4099</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Blanco estelar</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Azul</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>4299</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>(PRODUCT)RED</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Morado</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>4299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>4799</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Blanco Estelar</td>\n",
       "      <td>4999</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Rojo</td>\n",
       "      <td>4999</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Medianoche</td>\n",
       "      <td>4999</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5099</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Negro Espacial</td>\n",
       "      <td>5199</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Plata</td>\n",
       "      <td>5199</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Morado Oscuro</td>\n",
       "      <td>5199</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Color plata</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>(PRODUCT)RED</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Morado</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Blanco estelar</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Negro espacial</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Medianoche</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Color oro</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Morado oscuro</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Azul</td>\n",
       "      <td>5299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Blanco Estelar</td>\n",
       "      <td>5599</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5599</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Medianoche</td>\n",
       "      <td>5599</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Blanco Estelar</td>\n",
       "      <td>5599</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Morado</td>\n",
       "      <td>5599</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Medianoche</td>\n",
       "      <td>5599</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Negro espacial</td>\n",
       "      <td>5699</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Color plata</td>\n",
       "      <td>5699</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5699</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5699</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Color oro</td>\n",
       "      <td>5699</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Negro Espacial</td>\n",
       "      <td>5799</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Morado Oscuro</td>\n",
       "      <td>5799</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>Plata</td>\n",
       "      <td>5799</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5849</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>Audífonos AirPods 2nda Generación</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5849</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>Audífonos AirPods 2nda Generación</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5849</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>Audífonos AirPods 2nda Generación</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14</td>\n",
       "      <td>128 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5849</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>Audífonos AirPods 2nda Generación</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5899</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Color oro</td>\n",
       "      <td>5899</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Morado oscuro</td>\n",
       "      <td>5899</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>5899</td>\n",
       "      <td>Falabella</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Medianoche</td>\n",
       "      <td>6299</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Morado</td>\n",
       "      <td>6299</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>No especificado</td>\n",
       "      <td>6299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Color plata</td>\n",
       "      <td>6299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Negro espacial</td>\n",
       "      <td>6299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Pro Max</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Morado oscuro</td>\n",
       "      <td>6299</td>\n",
       "      <td>Mercado Libre</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Apple</td>\n",
       "      <td>iPhone 14 Plus</td>\n",
       "      <td>256 GB</td>\n",
       "      <td>Blanco Estelar</td>\n",
       "      <td>6299</td>\n",
       "      <td>Hiraoka</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Marca             Modelo Capacidad            Color  Precio (S/.)  \\\n",
       "87  Apple          iPhone 14    128 GB  No especificado          3799   \n",
       "53  Apple          iPhone 14    128 GB             Azul          3899   \n",
       "71  Apple          iPhone 14    256 GB  No especificado          4099   \n",
       "33  Apple          iPhone 14    128 GB  No especificado          4299   \n",
       "17  Apple     iPhone 14 Plus    128 GB   Blanco estelar          4299   \n",
       "18  Apple     iPhone 14 Plus    128 GB             Azul          4299   \n",
       "76  Apple     iPhone 14 Plus    128 GB  No especificado          4299   \n",
       "19  Apple     iPhone 14 Plus    128 GB     (PRODUCT)RED          4299   \n",
       "10  Apple          iPhone 14    128 GB           Morado          4299   \n",
       "35  Apple     iPhone 14 Plus    128 GB  No especificado          4299   \n",
       "74  Apple     iPhone 14 Plus    256 GB  No especificado          4799   \n",
       "51  Apple          iPhone 14    128 GB   Blanco Estelar          4999   \n",
       "65  Apple     iPhone 14 Plus    256 GB             Rojo          4999   \n",
       "52  Apple          iPhone 14    128 GB       Medianoche          4999   \n",
       "86  Apple      iPhone 14 Pro    128 GB  No especificado          5099   \n",
       "57  Apple      iPhone 14 Pro    128 GB   Negro Espacial          5199   \n",
       "60  Apple      iPhone 14 Pro    128 GB            Plata          5199   \n",
       "58  Apple      iPhone 14 Pro    128 GB    Morado Oscuro          5199   \n",
       "16  Apple      iPhone 14 Pro    128 GB      Color plata          5299   \n",
       "26  Apple     iPhone 14 Plus    256 GB     (PRODUCT)RED          5299   \n",
       "40  Apple     iPhone 14 Plus    256 GB  No especificado          5299   \n",
       "22  Apple     iPhone 14 Plus    256 GB           Morado          5299   \n",
       "23  Apple     iPhone 14 Plus    256 GB   Blanco estelar          5299   \n",
       "11  Apple      iPhone 14 Pro    128 GB   Negro espacial          5299   \n",
       "34  Apple      iPhone 14 Pro    128 GB  No especificado          5299   \n",
       "24  Apple     iPhone 14 Plus    256 GB       Medianoche          5299   \n",
       "14  Apple      iPhone 14 Pro    128 GB        Color oro          5299   \n",
       "8   Apple      iPhone 14 Pro    128 GB    Morado oscuro          5299   \n",
       "25  Apple     iPhone 14 Plus    256 GB             Azul          5299   \n",
       "68  Apple          iPhone 14    256 GB   Blanco Estelar          5599   \n",
       "72  Apple      iPhone 14 Pro    256 GB  No especificado          5599   \n",
       "55  Apple     iPhone 14 Plus    128 GB       Medianoche          5599   \n",
       "56  Apple     iPhone 14 Plus    128 GB   Blanco Estelar          5599   \n",
       "63  Apple     iPhone 14 Plus    128 GB           Morado          5599   \n",
       "61  Apple          iPhone 14    256 GB       Medianoche          5599   \n",
       "4   Apple  iPhone 14 Pro Max    128 GB   Negro espacial          5699   \n",
       "13  Apple  iPhone 14 Pro Max    128 GB      Color plata          5699   \n",
       "32  Apple  iPhone 14 Pro Max    128 GB  No especificado          5699   \n",
       "80  Apple  iPhone 14 Pro Max    128 GB  No especificado          5699   \n",
       "9   Apple  iPhone 14 Pro Max    128 GB        Color oro          5699   \n",
       "67  Apple  iPhone 14 Pro Max    128 GB   Negro Espacial          5799   \n",
       "69  Apple  iPhone 14 Pro Max    128 GB    Morado Oscuro          5799   \n",
       "62  Apple  iPhone 14 Pro Max    128 GB            Plata          5799   \n",
       "82  Apple          iPhone 14    128 GB  No especificado          5849   \n",
       "83  Apple          iPhone 14    128 GB  No especificado          5849   \n",
       "84  Apple          iPhone 14    128 GB  No especificado          5849   \n",
       "88  Apple          iPhone 14    128 GB  No especificado          5849   \n",
       "39  Apple      iPhone 14 Pro    256 GB  No especificado          5899   \n",
       "21  Apple      iPhone 14 Pro    256 GB        Color oro          5899   \n",
       "20  Apple      iPhone 14 Pro    256 GB    Morado oscuro          5899   \n",
       "70  Apple  iPhone 14 Pro Max    256 GB  No especificado          5899   \n",
       "54  Apple     iPhone 14 Plus    256 GB       Medianoche          6299   \n",
       "45  Apple     iPhone 14 Plus    256 GB           Morado          6299   \n",
       "38  Apple  iPhone 14 Pro Max    256 GB  No especificado          6299   \n",
       "15  Apple  iPhone 14 Pro Max    256 GB      Color plata          6299   \n",
       "7   Apple  iPhone 14 Pro Max    256 GB   Negro espacial          6299   \n",
       "3   Apple  iPhone 14 Pro Max    256 GB    Morado oscuro          6299   \n",
       "44  Apple     iPhone 14 Plus    256 GB   Blanco Estelar          6299   \n",
       "\n",
       "           Tienda                             Extras  \n",
       "87      Falabella                                  -  \n",
       "53        Hiraoka                                  -  \n",
       "71      Falabella                                  -  \n",
       "33  Mercado Libre                                  -  \n",
       "17  Mercado Libre                                  -  \n",
       "18  Mercado Libre                                  -  \n",
       "76      Falabella                                  -  \n",
       "19  Mercado Libre                                  -  \n",
       "10  Mercado Libre                                  -  \n",
       "35  Mercado Libre                                  -  \n",
       "74      Falabella                                  -  \n",
       "51        Hiraoka                                  -  \n",
       "65        Hiraoka                                  -  \n",
       "52        Hiraoka                                  -  \n",
       "86      Falabella                                  -  \n",
       "57        Hiraoka                                  -  \n",
       "60        Hiraoka                                  -  \n",
       "58        Hiraoka                                  -  \n",
       "16  Mercado Libre                                  -  \n",
       "26  Mercado Libre                                  -  \n",
       "40  Mercado Libre                                  -  \n",
       "22  Mercado Libre                                  -  \n",
       "23  Mercado Libre                                  -  \n",
       "11  Mercado Libre                                  -  \n",
       "34  Mercado Libre                                  -  \n",
       "24  Mercado Libre                                  -  \n",
       "14  Mercado Libre                                  -  \n",
       "8   Mercado Libre                                  -  \n",
       "25  Mercado Libre                                  -  \n",
       "68        Hiraoka                                  -  \n",
       "72      Falabella                                  -  \n",
       "55        Hiraoka                                  -  \n",
       "56        Hiraoka                                  -  \n",
       "63        Hiraoka                                  -  \n",
       "61        Hiraoka                                  -  \n",
       "4   Mercado Libre                                  -  \n",
       "13  Mercado Libre                                  -  \n",
       "32  Mercado Libre                                  -  \n",
       "80      Falabella                                  -  \n",
       "9   Mercado Libre                                  -  \n",
       "67        Hiraoka                                  -  \n",
       "69        Hiraoka                                  -  \n",
       "62        Hiraoka                                  -  \n",
       "82      Falabella  Audífonos AirPods 2nda Generación  \n",
       "83      Falabella  Audífonos AirPods 2nda Generación  \n",
       "84      Falabella  Audífonos AirPods 2nda Generación  \n",
       "88      Falabella  Audífonos AirPods 2nda Generación  \n",
       "39  Mercado Libre                                  -  \n",
       "21  Mercado Libre                                  -  \n",
       "20  Mercado Libre                                  -  \n",
       "70      Falabella                                  -  \n",
       "54        Hiraoka                                  -  \n",
       "45        Hiraoka                                  -  \n",
       "38  Mercado Libre                                  -  \n",
       "15  Mercado Libre                                  -  \n",
       "7   Mercado Libre                                  -  \n",
       "3   Mercado Libre                                  -  \n",
       "44        Hiraoka                                  -  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Creando un reporte PDF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Se ha creado el documento PDF: Reporte de iPhone 14.pdf\n"
     ]
    }
   ],
   "source": [
    "import pdfkit\n",
    "import jinja2\n",
    "\n",
    "\n",
    "# Valores para las variables del título\n",
    "modelo_seleccionado = busqueda\n",
    "minimo = min\n",
    "maximo = max\n",
    "\n",
    "# Estableciendo el HTML\n",
    "template_html = '''\n",
    "<!DOCTYPE html>\n",
    "<html>\n",
    "<head>\n",
    "    <meta charset=\"UTF-8\">\n",
    "    <link rel=\"stylesheet\">\n",
    "    <style>\n",
    "        body {\n",
    "            display: flex;\n",
    "            align-items: center;\n",
    "            justify-content: center;\n",
    "            min-height: 100vh;\n",
    "            background: linear-gradient(#b7328d);\n",
    "        }\n",
    "        table {\n",
    "            border-collapse: collapse;\n",
    "            width: 100%;\n",
    "        \n",
    "        }\n",
    "        th, td {\n",
    "            border: 1px solid black;\n",
    "            padding: 8px;\n",
    "            text-align: center;\n",
    "        }\n",
    "    </style>\n",
    "</head>\n",
    "<body>\n",
    "    <h1>Resultado de {{modelo_seleccionado}} entre S/. {{minimo}} y S/. {{maximo}}</h1>\n",
    "    <table>\n",
    "        <tr>\n",
    "            {% for col in df.columns %}\n",
    "                <th>{{ col }}</th>\n",
    "            {% endfor %}\n",
    "        </tr>\n",
    "        {% for _, row in df.iterrows() %}\n",
    "            <tr>\n",
    "                {% for value in row %}\n",
    "                    <td>{{ value }}</td>\n",
    "                {% endfor %}\n",
    "            </tr>\n",
    "        {% endfor %}\n",
    "    </table>\n",
    "</body>\n",
    "</html>\n",
    "'''\n",
    "\n",
    "# Generando el HTML a partir de la plantilla con los valores de las variables\n",
    "jinja_template = jinja2.Template(template_html)\n",
    "html_content = jinja_template.render(df=df, modelo_seleccionado=modelo_seleccionado, minimo=minimo, maximo=maximo)\n",
    "\n",
    "# Generando el PDF\n",
    "output_pdf = f'Reporte de {busqueda}.pdf'\n",
    "\n",
    "wkhtmltopdf_path = r'C:\\Program Files\\wkhtmltopdf\\bin\\wkhtmltopdf.exe'\n",
    "\n",
    "# Configuración de pdfkit\n",
    "options = {\n",
    "    'page-size': 'A4',\n",
    "    'margin-top': '10mm',\n",
    "    'margin-right': '10mm',\n",
    "    'margin-bottom': '10mm',\n",
    "    'margin-left': '10mm'\n",
    "}\n",
    "\n",
    "# Generar el PDF proporcionando la ruta del ejecutable y las opciones de configuración\n",
    "pdfkit.from_string(html_content, output_pdf, configuration=pdfkit.configuration(wkhtmltopdf=wkhtmltopdf_path), options=options)\n",
    "\n",
    "print(f'Se ha creado el documento PDF: {output_pdf}')\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Enviando el reporte por email"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Introduce el destinatario20211804@lamolina.edu.pe\n",
      "Correo enviado satisfactoriamente a 20211804@lamolina.edu.pe\n"
     ]
    }
   ],
   "source": [
    "import yagmail\n",
    "\n",
    "email = 'maaf162125@gmail.com'\n",
    "contraseña = 'ofojwaxwhymqgcsk'\n",
    "\n",
    "yag = yagmail.SMTP(user=email, password=contraseña)\n",
    "\n",
    "destinatario = input('Introduce el destinatario')\n",
    "asunto = f'📊 Reporte de iPhones en las tiendas 📱📈'\n",
    "\n",
    "mensaje = f'''\n",
    "¡Hola! 👋😃\n",
    "\n",
    "Espero que te encuentres bien. Adjunto encontrarás el reporte actualizado de {busqueda} en el mercado.\n",
    "Te adjuntaremos un documento con todos los celulares entre S/. {min} y S/. {max}.\n",
    "\n",
    "¡Estos son los datos más recientes! 📊📈 Si necesitas alguna información adicional o tienes alguna pregunta, no dudes en contactarme.\n",
    "\n",
    "** Los datos recopilados son de las tiendas de Falabella, Hiraoka y MercadoLibre.\n",
    "\n",
    "** Si deseas más información y características de los modelos, visita https://www.apple.com/la/iphone/compare\n",
    "\n",
    "\n",
    "¡Que tengas un gran día! 🌟📅\n",
    "\n",
    "\n",
    "Saludos cordiales,\n",
    "Marcello y Stephano\n",
    "Estudiantes de Estadística Informática, UNALM\n",
    "'''\n",
    "\n",
    "archivo = output_pdf\n",
    "\n",
    "yag.send(destinatario, asunto, [mensaje], attachments=[archivo])\n",
    "\n",
    "print(f'Correo enviado satisfactoriamente a {destinatario}')\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Información y características de cada celular"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import webbrowser\n",
    "\n",
    "# URL de la página que deseas abrir\n",
    "url = \"https://www.apple.com/la/iphone/compare/\"\n",
    "\n",
    "# Abre la página web en el navegador predeterminado\n",
    "webbrowser.open(url)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}