dataset_analysis_CL_1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "9c1a3c8a",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/mariangelapetruzzi/opt/anaconda3/lib/python3.9/site-packages/pandas/core/computation/expressions.py:21: UserWarning: Pandas requires version '2.8.4' or newer of 'numexpr' (version '2.8.1' currently installed).\n",
      "  from pandas.core.computation.check import NUMEXPR_INSTALLED\n",
      "/Users/mariangelapetruzzi/opt/anaconda3/lib/python3.9/site-packages/pandas/core/arrays/masked.py:60: UserWarning: Pandas requires version '1.3.6' or newer of 'bottleneck' (version '1.3.4' currently installed).\n",
      "  from pandas.core import (\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import glob\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b59dfe70",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "488e0583",
   "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>zenPrice</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Unnamed: 2</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>Unnamed: 5</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "      <th>Date:</th>\n",
       "      <th>21/12/2023</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>Unnamed: 10</th>\n",
       "      <th>Unnamed: 11</th>\n",
       "      <th>Unnamed: 12</th>\n",
       "      <th>Unnamed: 13</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Samsung Galaxy S23 256GB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Date</td>\n",
       "      <td>My price</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Mercado Libre / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Vtr / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>20/12/2023</td>\n",
       "      <td>$1,115,990</td>\n",
       "      <td>$840,000</td>\n",
       "      <td>$849,990</td>\n",
       "      <td>$839,990 / $839,990</td>\n",
       "      <td>$629,990</td>\n",
       "      <td>$799,990 / $799,990</td>\n",
       "      <td>$969,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$799,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$679,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>19/12/2023</td>\n",
       "      <td>$1,115,990</td>\n",
       "      <td>$840,000</td>\n",
       "      <td>$849,990</td>\n",
       "      <td>$839,990 / $839,990</td>\n",
       "      <td>$629,990</td>\n",
       "      <td>$799,990 / $799,990</td>\n",
       "      <td>$969,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$799,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$679,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320</th>\n",
       "      <td>06/02/2023</td>\n",
       "      <td>$1,091,760</td>\n",
       "      <td>$900,000</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321</th>\n",
       "      <td>05/02/2023</td>\n",
       "      <td>$1,091,760</td>\n",
       "      <td>$900,000</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>322</th>\n",
       "      <td>04/02/2023</td>\n",
       "      <td>$1,091,760</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323</th>\n",
       "      <td>03/02/2023</td>\n",
       "      <td>$1,091,760</td>\n",
       "      <td>$900,000</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324</th>\n",
       "      <td>02/02/2023</td>\n",
       "      <td>$1,091,760</td>\n",
       "      <td>$900,000</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>325 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       zenPrice  Unnamed: 1                Unnamed: 2           Unnamed: 3  \\\n",
       "0           NaN         NaN                       NaN                  NaN   \n",
       "1           NaN         NaN  Samsung Galaxy S23 256GB                  NaN   \n",
       "2          Date    My price             Wom / Loyalty  Falabella / Loyalty   \n",
       "3    20/12/2023  $1,115,990                  $840,000             $849,990   \n",
       "4    19/12/2023  $1,115,990                  $840,000             $849,990   \n",
       "..          ...         ...                       ...                  ...   \n",
       "320  06/02/2023  $1,091,760                  $900,000             $999,990   \n",
       "321  05/02/2023  $1,091,760                  $900,000                    -   \n",
       "322  04/02/2023  $1,091,760                         -                    -   \n",
       "323  03/02/2023  $1,091,760                  $900,000                    -   \n",
       "324  02/02/2023  $1,091,760                  $900,000                    -   \n",
       "\n",
       "              Unnamed: 4       Unnamed: 5           Unnamed: 6  \\\n",
       "0                    NaN              NaN                  NaN   \n",
       "1                    NaN              NaN                  NaN   \n",
       "2        Lider / Loyalty  Paris / Loyalty     Abcdin / Loyalty   \n",
       "3    $839,990 / $839,990         $629,990  $799,990 / $799,990   \n",
       "4    $839,990 / $839,990         $629,990  $799,990 / $799,990   \n",
       "..                   ...              ...                  ...   \n",
       "320             $999,990         $999,990             $999,990   \n",
       "321             $999,990         $999,990             $999,990   \n",
       "322                    -         $999,990                    -   \n",
       "323             $999,990         $999,990             $999,990   \n",
       "324                    -         $999,990             $999,990   \n",
       "\n",
       "               Date:               21/12/2023        Unnamed: 9  \\\n",
       "0                NaN                      NaN               NaN   \n",
       "1                NaN                      NaN               NaN   \n",
       "2    Claro / Loyalty  Mercado Libre / Loyalty  Aufbau / Loyalty   \n",
       "3           $969,990                        -                 -   \n",
       "4           $969,990                        -                 -   \n",
       "..               ...                      ...               ...   \n",
       "320                -                        -                 -   \n",
       "321                -                        -                 -   \n",
       "322                -                        -                 -   \n",
       "323                -                        -                 -   \n",
       "324                -                        -                 -   \n",
       "\n",
       "              Unnamed: 10       Unnamed: 11    Unnamed: 12         Unnamed: 13  \n",
       "0                     NaN               NaN            NaN                 NaN  \n",
       "1                     NaN               NaN            NaN                 NaN  \n",
       "2    Mac Online / Loyalty  Ripley / Loyalty  Vtr / Loyalty  Movistar / Loyalty  \n",
       "3                       -          $799,990              -            $679,990  \n",
       "4                       -          $799,990              -            $679,990  \n",
       "..                    ...               ...            ...                 ...  \n",
       "320                     -          $999,990              -            $999,990  \n",
       "321                     -          $999,990              -                   -  \n",
       "322                     -                 -              -            $999,990  \n",
       "323                     -          $999,990              -            $999,990  \n",
       "324                     -          $999,990              -            $999,990  \n",
       "\n",
       "[325 rows x 14 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#data=pd.read_excel(r\"Prices_Excel/CL/zenPrice_apple_iphone_11_64gb_202312211209.xlsx\") \n",
    "data=pd.read_excel(\"Prices_Excel/CL/zenPrice_samsung_galaxy_s23_256gb_202312211056.xlsx\",sheet_name='No Client') \n",
    "\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "47b31edc",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "44801924",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Samsung Galaxy S23 256GB'"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "product=data.iloc[1, 2]\n",
    "product=str(product)\n",
    "product"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "5c90a313",
   "metadata": {},
   "outputs": [],
   "source": [
    "def apresentar_primeiras_e_ultimas_com_reticencias(data):\n",
    "    # Obter as 3 primeiras linhas\n",
    "    primeiras_linhas = data.head(3)\n",
    "    \n",
    "    # Obter as 3 últimas linhas\n",
    "    ultimas_linhas = data.tail(3)\n",
    "    \n",
    "    # Criar uma linha de reticências\n",
    "    reticencias = pd.DataFrame({col: ['...'] for col in data.columns}, index=['...'])\n",
    "    \n",
    "    # Concatenar as partes\n",
    "    apresentacao = pd.concat([primeiras_linhas, reticencias, ultimas_linhas])\n",
    "    \n",
    "    return apresentacao\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "e7ddfc6c",
   "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>Date</th>\n",
       "      <th>My price</th>\n",
       "      <th>Wom / Loyalty</th>\n",
       "      <th>Falabella / Loyalty</th>\n",
       "      <th>Lider / Loyalty</th>\n",
       "      <th>Paris / Loyalty</th>\n",
       "      <th>Abcdin / Loyalty</th>\n",
       "      <th>Claro / Loyalty</th>\n",
       "      <th>Mercado Libre / Loyalty</th>\n",
       "      <th>Aufbau / Loyalty</th>\n",
       "      <th>Mac Online / Loyalty</th>\n",
       "      <th>Ripley / Loyalty</th>\n",
       "      <th>Vtr / Loyalty</th>\n",
       "      <th>Movistar / Loyalty</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20/12/2023</td>\n",
       "      <td>$1,115,990</td>\n",
       "      <td>$840,000</td>\n",
       "      <td>$849,990</td>\n",
       "      <td>$839,990 / $839,990</td>\n",
       "      <td>$629,990</td>\n",
       "      <td>$799,990 / $799,990</td>\n",
       "      <td>$969,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$799,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$679,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>19/12/2023</td>\n",
       "      <td>$1,115,990</td>\n",
       "      <td>$840,000</td>\n",
       "      <td>$849,990</td>\n",
       "      <td>$839,990 / $839,990</td>\n",
       "      <td>$629,990</td>\n",
       "      <td>$799,990 / $799,990</td>\n",
       "      <td>$969,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$799,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$679,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>18/12/2023</td>\n",
       "      <td>$1,115,990</td>\n",
       "      <td>$840,000</td>\n",
       "      <td>$849,990</td>\n",
       "      <td>$839,990 / $839,990</td>\n",
       "      <td>$629,990</td>\n",
       "      <td>$799,990 / $799,990</td>\n",
       "      <td>$969,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$799,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$679,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>17/12/2023</td>\n",
       "      <td>$1,115,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$849,990</td>\n",
       "      <td>$839,990 / $839,990</td>\n",
       "      <td>$629,990</td>\n",
       "      <td>$799,990 / $799,990</td>\n",
       "      <td>$969,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$764,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$679,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16/12/2023</td>\n",
       "      <td>$1,115,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$849,990</td>\n",
       "      <td>$839,990 / $839,990</td>\n",
       "      <td>$629,990</td>\n",
       "      <td>$799,990 / $799,990</td>\n",
       "      <td>$969,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$799,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$679,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>317</th>\n",
       "      <td>06/02/2023</td>\n",
       "      <td>$1,091,760</td>\n",
       "      <td>$900,000</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>318</th>\n",
       "      <td>05/02/2023</td>\n",
       "      <td>$1,091,760</td>\n",
       "      <td>$900,000</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>04/02/2023</td>\n",
       "      <td>$1,091,760</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320</th>\n",
       "      <td>03/02/2023</td>\n",
       "      <td>$1,091,760</td>\n",
       "      <td>$900,000</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321</th>\n",
       "      <td>02/02/2023</td>\n",
       "      <td>$1,091,760</td>\n",
       "      <td>$900,000</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>322 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "0          Date    My price Wom / Loyalty Falabella / Loyalty  \\\n",
       "0    20/12/2023  $1,115,990      $840,000            $849,990   \n",
       "1    19/12/2023  $1,115,990      $840,000            $849,990   \n",
       "2    18/12/2023  $1,115,990      $840,000            $849,990   \n",
       "3    17/12/2023  $1,115,990             -            $849,990   \n",
       "4    16/12/2023  $1,115,990             -            $849,990   \n",
       "..          ...         ...           ...                 ...   \n",
       "317  06/02/2023  $1,091,760      $900,000            $999,990   \n",
       "318  05/02/2023  $1,091,760      $900,000                   -   \n",
       "319  04/02/2023  $1,091,760             -                   -   \n",
       "320  03/02/2023  $1,091,760      $900,000                   -   \n",
       "321  02/02/2023  $1,091,760      $900,000                   -   \n",
       "\n",
       "0        Lider / Loyalty Paris / Loyalty     Abcdin / Loyalty Claro / Loyalty  \\\n",
       "0    $839,990 / $839,990        $629,990  $799,990 / $799,990        $969,990   \n",
       "1    $839,990 / $839,990        $629,990  $799,990 / $799,990        $969,990   \n",
       "2    $839,990 / $839,990        $629,990  $799,990 / $799,990        $969,990   \n",
       "3    $839,990 / $839,990        $629,990  $799,990 / $799,990        $969,990   \n",
       "4    $839,990 / $839,990        $629,990  $799,990 / $799,990        $969,990   \n",
       "..                   ...             ...                  ...             ...   \n",
       "317             $999,990        $999,990             $999,990               -   \n",
       "318             $999,990        $999,990             $999,990               -   \n",
       "319                    -        $999,990                    -               -   \n",
       "320             $999,990        $999,990             $999,990               -   \n",
       "321                    -        $999,990             $999,990               -   \n",
       "\n",
       "0   Mercado Libre / Loyalty Aufbau / Loyalty Mac Online / Loyalty  \\\n",
       "0                         -                -                    -   \n",
       "1                         -                -                    -   \n",
       "2                         -                -                    -   \n",
       "3                         -                -                    -   \n",
       "4                         -                -                    -   \n",
       "..                      ...              ...                  ...   \n",
       "317                       -                -                    -   \n",
       "318                       -                -                    -   \n",
       "319                       -                -                    -   \n",
       "320                       -                -                    -   \n",
       "321                       -                -                    -   \n",
       "\n",
       "0   Ripley / Loyalty Vtr / Loyalty Movistar / Loyalty  \n",
       "0           $799,990             -           $679,990  \n",
       "1           $799,990             -           $679,990  \n",
       "2           $799,990             -           $679,990  \n",
       "3           $764,990             -           $679,990  \n",
       "4           $799,990             -           $679,990  \n",
       "..               ...           ...                ...  \n",
       "317         $999,990             -           $999,990  \n",
       "318         $999,990             -                  -  \n",
       "319                -             -           $999,990  \n",
       "320         $999,990             -           $999,990  \n",
       "321         $999,990             -           $999,990  \n",
       "\n",
       "[322 rows x 14 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = data[2:]\n",
    "data.reset_index(drop=True, inplace=True)\n",
    "data.columns = data.iloc[0]\n",
    "data = data.drop([0])\n",
    "data.reset_index(drop=True, inplace=True)\n",
    "data\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "215e13e5",
   "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>Date</th>\n",
       "      <th>My price</th>\n",
       "      <th>Wom / Loyalty</th>\n",
       "      <th>Falabella / Loyalty</th>\n",
       "      <th>Lider / Loyalty</th>\n",
       "      <th>Paris / Loyalty</th>\n",
       "      <th>Abcdin / Loyalty</th>\n",
       "      <th>Claro / Loyalty</th>\n",
       "      <th>Mercado Libre / Loyalty</th>\n",
       "      <th>Aufbau / Loyalty</th>\n",
       "      <th>Mac Online / Loyalty</th>\n",
       "      <th>Ripley / Loyalty</th>\n",
       "      <th>Vtr / Loyalty</th>\n",
       "      <th>Movistar / Loyalty</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20/12/2023</td>\n",
       "      <td>$1,115,990</td>\n",
       "      <td>$840,000</td>\n",
       "      <td>$849,990</td>\n",
       "      <td>$839,990 / $839,990</td>\n",
       "      <td>$629,990</td>\n",
       "      <td>$799,990 / $799,990</td>\n",
       "      <td>$969,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$799,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$679,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>19/12/2023</td>\n",
       "      <td>$1,115,990</td>\n",
       "      <td>$840,000</td>\n",
       "      <td>$849,990</td>\n",
       "      <td>$839,990 / $839,990</td>\n",
       "      <td>$629,990</td>\n",
       "      <td>$799,990 / $799,990</td>\n",
       "      <td>$969,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$799,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$679,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>18/12/2023</td>\n",
       "      <td>$1,115,990</td>\n",
       "      <td>$840,000</td>\n",
       "      <td>$849,990</td>\n",
       "      <td>$839,990 / $839,990</td>\n",
       "      <td>$629,990</td>\n",
       "      <td>$799,990 / $799,990</td>\n",
       "      <td>$969,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$799,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$679,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>04/02/2023</td>\n",
       "      <td>$1,091,760</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320</th>\n",
       "      <td>03/02/2023</td>\n",
       "      <td>$1,091,760</td>\n",
       "      <td>$900,000</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321</th>\n",
       "      <td>02/02/2023</td>\n",
       "      <td>$1,091,760</td>\n",
       "      <td>$900,000</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Date    My price Wom / Loyalty Falabella / Loyalty  \\\n",
       "0    20/12/2023  $1,115,990      $840,000            $849,990   \n",
       "1    19/12/2023  $1,115,990      $840,000            $849,990   \n",
       "2    18/12/2023  $1,115,990      $840,000            $849,990   \n",
       "...         ...         ...           ...                 ...   \n",
       "319  04/02/2023  $1,091,760             -                   -   \n",
       "320  03/02/2023  $1,091,760      $900,000                   -   \n",
       "321  02/02/2023  $1,091,760      $900,000                   -   \n",
       "\n",
       "         Lider / Loyalty Paris / Loyalty     Abcdin / Loyalty Claro / Loyalty  \\\n",
       "0    $839,990 / $839,990        $629,990  $799,990 / $799,990        $969,990   \n",
       "1    $839,990 / $839,990        $629,990  $799,990 / $799,990        $969,990   \n",
       "2    $839,990 / $839,990        $629,990  $799,990 / $799,990        $969,990   \n",
       "...                  ...             ...                  ...             ...   \n",
       "319                    -        $999,990                    -               -   \n",
       "320             $999,990        $999,990             $999,990               -   \n",
       "321                    -        $999,990             $999,990               -   \n",
       "\n",
       "    Mercado Libre / Loyalty Aufbau / Loyalty Mac Online / Loyalty  \\\n",
       "0                         -                -                    -   \n",
       "1                         -                -                    -   \n",
       "2                         -                -                    -   \n",
       "...                     ...              ...                  ...   \n",
       "319                       -                -                    -   \n",
       "320                       -                -                    -   \n",
       "321                       -                -                    -   \n",
       "\n",
       "    Ripley / Loyalty Vtr / Loyalty Movistar / Loyalty  \n",
       "0           $799,990             -           $679,990  \n",
       "1           $799,990             -           $679,990  \n",
       "2           $799,990             -           $679,990  \n",
       "...              ...           ...                ...  \n",
       "319                -             -           $999,990  \n",
       "320         $999,990             -           $999,990  \n",
       "321         $999,990             -           $999,990  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "apresentar_primeiras_e_ultimas_com_reticencias(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "dbc4515e",
   "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>Date</th>\n",
       "      <th>My price</th>\n",
       "      <th>Wom / Loyalty</th>\n",
       "      <th>Falabella / Loyalty</th>\n",
       "      <th>Lider / Loyalty</th>\n",
       "      <th>Paris / Loyalty</th>\n",
       "      <th>Abcdin / Loyalty</th>\n",
       "      <th>Claro / Loyalty</th>\n",
       "      <th>Ripley / Loyalty</th>\n",
       "      <th>Movistar / Loyalty</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20/12/2023</td>\n",
       "      <td>$1,115,990</td>\n",
       "      <td>$840,000</td>\n",
       "      <td>$849,990</td>\n",
       "      <td>$839,990 / $839,990</td>\n",
       "      <td>$629,990</td>\n",
       "      <td>$799,990 / $799,990</td>\n",
       "      <td>$969,990</td>\n",
       "      <td>$799,990</td>\n",
       "      <td>$679,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>19/12/2023</td>\n",
       "      <td>$1,115,990</td>\n",
       "      <td>$840,000</td>\n",
       "      <td>$849,990</td>\n",
       "      <td>$839,990 / $839,990</td>\n",
       "      <td>$629,990</td>\n",
       "      <td>$799,990 / $799,990</td>\n",
       "      <td>$969,990</td>\n",
       "      <td>$799,990</td>\n",
       "      <td>$679,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>18/12/2023</td>\n",
       "      <td>$1,115,990</td>\n",
       "      <td>$840,000</td>\n",
       "      <td>$849,990</td>\n",
       "      <td>$839,990 / $839,990</td>\n",
       "      <td>$629,990</td>\n",
       "      <td>$799,990 / $799,990</td>\n",
       "      <td>$969,990</td>\n",
       "      <td>$799,990</td>\n",
       "      <td>$679,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>17/12/2023</td>\n",
       "      <td>$1,115,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$849,990</td>\n",
       "      <td>$839,990 / $839,990</td>\n",
       "      <td>$629,990</td>\n",
       "      <td>$799,990 / $799,990</td>\n",
       "      <td>$969,990</td>\n",
       "      <td>$764,990</td>\n",
       "      <td>$679,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16/12/2023</td>\n",
       "      <td>$1,115,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$849,990</td>\n",
       "      <td>$839,990 / $839,990</td>\n",
       "      <td>$629,990</td>\n",
       "      <td>$799,990 / $799,990</td>\n",
       "      <td>$969,990</td>\n",
       "      <td>$799,990</td>\n",
       "      <td>$679,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>317</th>\n",
       "      <td>06/02/2023</td>\n",
       "      <td>$1,091,760</td>\n",
       "      <td>$900,000</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>318</th>\n",
       "      <td>05/02/2023</td>\n",
       "      <td>$1,091,760</td>\n",
       "      <td>$900,000</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>04/02/2023</td>\n",
       "      <td>$1,091,760</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320</th>\n",
       "      <td>03/02/2023</td>\n",
       "      <td>$1,091,760</td>\n",
       "      <td>$900,000</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321</th>\n",
       "      <td>02/02/2023</td>\n",
       "      <td>$1,091,760</td>\n",
       "      <td>$900,000</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>322 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "0          Date    My price Wom / Loyalty Falabella / Loyalty  \\\n",
       "0    20/12/2023  $1,115,990      $840,000            $849,990   \n",
       "1    19/12/2023  $1,115,990      $840,000            $849,990   \n",
       "2    18/12/2023  $1,115,990      $840,000            $849,990   \n",
       "3    17/12/2023  $1,115,990             -            $849,990   \n",
       "4    16/12/2023  $1,115,990             -            $849,990   \n",
       "..          ...         ...           ...                 ...   \n",
       "317  06/02/2023  $1,091,760      $900,000            $999,990   \n",
       "318  05/02/2023  $1,091,760      $900,000                   -   \n",
       "319  04/02/2023  $1,091,760             -                   -   \n",
       "320  03/02/2023  $1,091,760      $900,000                   -   \n",
       "321  02/02/2023  $1,091,760      $900,000                   -   \n",
       "\n",
       "0        Lider / Loyalty Paris / Loyalty     Abcdin / Loyalty Claro / Loyalty  \\\n",
       "0    $839,990 / $839,990        $629,990  $799,990 / $799,990        $969,990   \n",
       "1    $839,990 / $839,990        $629,990  $799,990 / $799,990        $969,990   \n",
       "2    $839,990 / $839,990        $629,990  $799,990 / $799,990        $969,990   \n",
       "3    $839,990 / $839,990        $629,990  $799,990 / $799,990        $969,990   \n",
       "4    $839,990 / $839,990        $629,990  $799,990 / $799,990        $969,990   \n",
       "..                   ...             ...                  ...             ...   \n",
       "317             $999,990        $999,990             $999,990               -   \n",
       "318             $999,990        $999,990             $999,990               -   \n",
       "319                    -        $999,990                    -               -   \n",
       "320             $999,990        $999,990             $999,990               -   \n",
       "321                    -        $999,990             $999,990               -   \n",
       "\n",
       "0   Ripley / Loyalty Movistar / Loyalty  \n",
       "0           $799,990           $679,990  \n",
       "1           $799,990           $679,990  \n",
       "2           $799,990           $679,990  \n",
       "3           $764,990           $679,990  \n",
       "4           $799,990           $679,990  \n",
       "..               ...                ...  \n",
       "317         $999,990           $999,990  \n",
       "318         $999,990                  -  \n",
       "319                -           $999,990  \n",
       "320         $999,990           $999,990  \n",
       "321         $999,990           $999,990  \n",
       "\n",
       "[322 rows x 10 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "columns_to_drop = []\n",
    "for column in data.columns:\n",
    "    if (data[column] == '-').all():\n",
    "        columns_to_drop.append(column)\n",
    "\n",
    "# Eliminar colunas com todos os elementos sendo '-'\n",
    "if columns_to_drop:\n",
    "    data.drop(columns=columns_to_drop, inplace=True)\n",
    "\n",
    "# Mostrar o DataFrame resultante\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "d9a5e2fb",
   "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>Date</th>\n",
       "      <th>My price</th>\n",
       "      <th>Wom / Loyalty</th>\n",
       "      <th>Falabella / Loyalty</th>\n",
       "      <th>Lider / Loyalty</th>\n",
       "      <th>Paris / Loyalty</th>\n",
       "      <th>Abcdin / Loyalty</th>\n",
       "      <th>Claro / Loyalty</th>\n",
       "      <th>Ripley / Loyalty</th>\n",
       "      <th>Movistar / Loyalty</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20/12/2023</td>\n",
       "      <td>$1,115,990</td>\n",
       "      <td>$840,000</td>\n",
       "      <td>$849,990</td>\n",
       "      <td>$839,990 / $839,990</td>\n",
       "      <td>$629,990</td>\n",
       "      <td>$799,990 / $799,990</td>\n",
       "      <td>$969,990</td>\n",
       "      <td>$799,990</td>\n",
       "      <td>$679,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>19/12/2023</td>\n",
       "      <td>$1,115,990</td>\n",
       "      <td>$840,000</td>\n",
       "      <td>$849,990</td>\n",
       "      <td>$839,990 / $839,990</td>\n",
       "      <td>$629,990</td>\n",
       "      <td>$799,990 / $799,990</td>\n",
       "      <td>$969,990</td>\n",
       "      <td>$799,990</td>\n",
       "      <td>$679,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>18/12/2023</td>\n",
       "      <td>$1,115,990</td>\n",
       "      <td>$840,000</td>\n",
       "      <td>$849,990</td>\n",
       "      <td>$839,990 / $839,990</td>\n",
       "      <td>$629,990</td>\n",
       "      <td>$799,990 / $799,990</td>\n",
       "      <td>$969,990</td>\n",
       "      <td>$799,990</td>\n",
       "      <td>$679,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>04/02/2023</td>\n",
       "      <td>$1,091,760</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320</th>\n",
       "      <td>03/02/2023</td>\n",
       "      <td>$1,091,760</td>\n",
       "      <td>$900,000</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321</th>\n",
       "      <td>02/02/2023</td>\n",
       "      <td>$1,091,760</td>\n",
       "      <td>$900,000</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>-</td>\n",
       "      <td>$999,990</td>\n",
       "      <td>$999,990</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Date    My price Wom / Loyalty Falabella / Loyalty  \\\n",
       "0    20/12/2023  $1,115,990      $840,000            $849,990   \n",
       "1    19/12/2023  $1,115,990      $840,000            $849,990   \n",
       "2    18/12/2023  $1,115,990      $840,000            $849,990   \n",
       "...         ...         ...           ...                 ...   \n",
       "319  04/02/2023  $1,091,760             -                   -   \n",
       "320  03/02/2023  $1,091,760      $900,000                   -   \n",
       "321  02/02/2023  $1,091,760      $900,000                   -   \n",
       "\n",
       "         Lider / Loyalty Paris / Loyalty     Abcdin / Loyalty Claro / Loyalty  \\\n",
       "0    $839,990 / $839,990        $629,990  $799,990 / $799,990        $969,990   \n",
       "1    $839,990 / $839,990        $629,990  $799,990 / $799,990        $969,990   \n",
       "2    $839,990 / $839,990        $629,990  $799,990 / $799,990        $969,990   \n",
       "...                  ...             ...                  ...             ...   \n",
       "319                    -        $999,990                    -               -   \n",
       "320             $999,990        $999,990             $999,990               -   \n",
       "321                    -        $999,990             $999,990               -   \n",
       "\n",
       "    Ripley / Loyalty Movistar / Loyalty  \n",
       "0           $799,990           $679,990  \n",
       "1           $799,990           $679,990  \n",
       "2           $799,990           $679,990  \n",
       "...              ...                ...  \n",
       "319                -           $999,990  \n",
       "320         $999,990           $999,990  \n",
       "321         $999,990           $999,990  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "apresentar_primeiras_e_ultimas_com_reticencias(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "865d4c3d",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "2df1b7e3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['My price',\n",
       " 'Wom / Loyalty',\n",
       " 'Falabella / Loyalty',\n",
       " 'Lider / Loyalty',\n",
       " 'Paris / Loyalty',\n",
       " 'Abcdin / Loyalty',\n",
       " 'Claro / Loyalty',\n",
       " 'Ripley / Loyalty',\n",
       " 'Movistar / Loyalty']"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "companies=data.columns\n",
    "companies = companies.drop(companies[0])\n",
    "companies_list = companies.tolist()\n",
    "companies_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "88f335ae",
   "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>Samsung Galaxy S23 256GB</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>My price</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Wom / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Lider / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Paris / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Claro / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Samsung Galaxy S23 256GB\n",
       "0                 My price\n",
       "1            Wom / Loyalty\n",
       "2      Falabella / Loyalty\n",
       "3          Lider / Loyalty\n",
       "4          Paris / Loyalty\n",
       "5         Abcdin / Loyalty\n",
       "6          Claro / Loyalty\n",
       "7         Ripley / Loyalty\n",
       "8       Movistar / Loyalty"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_products_companies = pd.DataFrame({product: companies_list})\n",
    "df_products_companies "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "81e6a822",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "59f6a95c",
   "metadata": {},
   "source": [
    "# No Client "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "fc18ff4a",
   "metadata": {},
   "outputs": [],
   "source": [
    "def df_products(path_of_product,sheet_name):\n",
    "    data=pd.read_excel(p,sheet_name) \n",
    "    product=data.iloc[1, 2]\n",
    "    product=str(product)\n",
    "    data = data[2:]\n",
    "    data.reset_index(drop=True, inplace=True)\n",
    "    data.columns = data.iloc[0]\n",
    "    data = data.drop([0])\n",
    "    data.reset_index(drop=True, inplace=True)\n",
    "    columns_to_drop = []\n",
    "    for column in data.columns:\n",
    "        if (data[column] == '-').all():\n",
    "            columns_to_drop.append(column)\n",
    "    if columns_to_drop:\n",
    "        data.drop(columns=columns_to_drop, inplace=True)\n",
    "\n",
    "    companies=data.columns\n",
    "    companies = companies.drop(companies[0])\n",
    "    companies_list = companies.tolist()\n",
    "    df_products_companies = pd.DataFrame({product: companies_list})\n",
    "    \n",
    "    return df_products_companies\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c3493380",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2ec32526",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "714a0581",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Prices_Excel/CL/zenPrice_apple_iphone_14_plus_128gb_202312211141.xlsx',\n",
       " 'Prices_Excel/CL/zenPrice_samsung_galaxy_s23_256gb_202312211056.xlsx',\n",
       " 'Prices_Excel/CL/zenPrice_apple_iphone_13_128gb_202312211203.xlsx',\n",
       " 'Prices_Excel/CL/zenPrice_samsung_galaxy_z_fold4_256gb_5g_202312211119.xlsx',\n",
       " 'Prices_Excel/CL/zenPrice_samsung_galaxy_z_flip4_256gb_5g_202312211200.xlsx',\n",
       " 'Prices_Excel/CL/zenPrice_apple_iphone_14_pro_max_256gb_202312211108.xlsx',\n",
       " 'Prices_Excel/CL/zenPrice_apple_iphone_14_pro_128gb_202312211109.xlsx',\n",
       " 'Prices_Excel/CL/zenPrice_samsung_galaxy_s22_128gb_5g_202312211114.xlsx',\n",
       " 'Prices_Excel/CL/zenPrice_apple_iphone_14_128gb_202312211112.xlsx',\n",
       " 'Prices_Excel/CL/zenPrice_vivo_y16_64gb_202312211131.xlsx',\n",
       " 'Prices_Excel/CL/zenPrice_motorola_moto_e22i_64gb_202312211127.xlsx',\n",
       " 'Prices_Excel/CL/zenPrice_apple_iphone_11_128gb_202312211208.xlsx',\n",
       " 'Prices_Excel/CL/zenPrice_apple_iphone_14_512gb_202312211106.xlsx',\n",
       " 'Prices_Excel/CL/zenPrice_apple_iphone_11_64gb_202312211209.xlsx',\n",
       " 'Prices_Excel/CL/zenPrice_apple_iphone_14_plus_256gb_202312211134.xlsx',\n",
       " 'Prices_Excel/CL/zenPrice_samsung_galaxy_s22_256gb_5g_202312211114.xlsx',\n",
       " 'Prices_Excel/CL/zenPrice_apple_iphone_14_pro_256gb_202312211111.xlsx',\n",
       " 'Prices_Excel/CL/zenPrice_vivo_y22s_128gb_202312211055.xlsx',\n",
       " 'Prices_Excel/CL/zenPrice_samsung_galaxy_a23_128gb_5g_202312211117.xlsx',\n",
       " 'Prices_Excel/CL/zenPrice_apple_iphone_14_256gb_202312211108.xlsx',\n",
       " 'Prices_Excel/CL/zenPrice_apple_iphone_14_pro_max_128gb_202312211130.xlsx']"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "\n",
    "path = \"Prices_Excel/CL/\"  \n",
    "list_product = glob.glob(path + \"/*.xlsx\")\n",
    "list_product"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "8c9ba6e0",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/4p/q7_ch2s94c37xj9l5h3fltgh0000gn/T/ipykernel_13605/950026993.py:13: UserWarning: Pandas requires version '3.0.5' or newer of 'xlsxwriter' (version '3.0.3' currently installed).\n",
      "  df_complete.to_excel('Prices_Excel/processed_data/CL/CL_No_Client.xlsx', index=False)\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>Apple iPhone 14 Plus 128GB</th>\n",
       "      <th>Samsung Galaxy S23 256GB</th>\n",
       "      <th>Apple iPhone 13 128GB</th>\n",
       "      <th>Samsung Galaxy Z Fold4 256GB (5G)</th>\n",
       "      <th>Samsung Galaxy Z Flip4 256GB (5G)</th>\n",
       "      <th>Apple iPhone 14 Pro Max 256GB</th>\n",
       "      <th>Apple iPhone 14 Pro 128GB</th>\n",
       "      <th>Samsung Galaxy S22 128GB (5G)</th>\n",
       "      <th>Apple iPhone 14 128GB</th>\n",
       "      <th>Vivo Y16 64GB</th>\n",
       "      <th>...</th>\n",
       "      <th>Apple iPhone 11 128GB</th>\n",
       "      <th>Apple iPhone 14 512GB</th>\n",
       "      <th>Apple iPhone 11 64GB</th>\n",
       "      <th>Apple iPhone 14 Plus 256GB</th>\n",
       "      <th>Samsung Galaxy S22 256GB (5G)</th>\n",
       "      <th>Apple iPhone 14 Pro 256GB</th>\n",
       "      <th>Vivo Y22s 128GB</th>\n",
       "      <th>Samsung Galaxy A23 128GB (5G)</th>\n",
       "      <th>Apple iPhone 14 256GB</th>\n",
       "      <th>Apple iPhone 14 Pro Max 128GB</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>...</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>...</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>...</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Apple iPhone 14 Plus 128GB  Samsung Galaxy S23 256GB  \\\n",
       "0                      My price                 My price   \n",
       "1                 Wom / Loyalty            Wom / Loyalty   \n",
       "2           Falabella / Loyalty      Falabella / Loyalty   \n",
       "...                         ...                      ...   \n",
       "8              Ripley / Loyalty       Movistar / Loyalty   \n",
       "9            Movistar / Loyalty                      NaN   \n",
       "10                          NaN                      NaN   \n",
       "\n",
       "    Apple iPhone 13 128GB Samsung Galaxy Z Fold4 256GB (5G)  \\\n",
       "0                My price                          My price   \n",
       "1           Wom / Loyalty                     Wom / Loyalty   \n",
       "2     Falabella / Loyalty               Falabella / Loyalty   \n",
       "...                   ...                               ...   \n",
       "8    Mac Online / Loyalty                Movistar / Loyalty   \n",
       "9        Ripley / Loyalty                               NaN   \n",
       "10     Movistar / Loyalty                               NaN   \n",
       "\n",
       "    Samsung Galaxy Z Flip4 256GB (5G) Apple iPhone 14 Pro Max 256GB   \\\n",
       "0                            My price                       My price   \n",
       "1                       Wom / Loyalty                  Wom / Loyalty   \n",
       "2                 Falabella / Loyalty            Falabella / Loyalty   \n",
       "...                               ...                            ...   \n",
       "8                  Movistar / Loyalty               Ripley / Loyalty   \n",
       "9                                 NaN             Movistar / Loyalty   \n",
       "10                                NaN                            NaN   \n",
       "\n",
       "    Apple iPhone 14 Pro 128GB Samsung Galaxy S22 128GB (5G)  \\\n",
       "0                    My price                      My price   \n",
       "1               Wom / Loyalty                 Wom / Loyalty   \n",
       "2         Falabella / Loyalty           Falabella / Loyalty   \n",
       "...                       ...                           ...   \n",
       "8            Ripley / Loyalty            Movistar / Loyalty   \n",
       "9          Movistar / Loyalty                           NaN   \n",
       "10                        NaN                           NaN   \n",
       "\n",
       "    Apple iPhone 14 128GB         Vivo Y16 64GB  ... Apple iPhone 11 128GB  \\\n",
       "0                 My price             My price  ...              My price   \n",
       "1            Wom / Loyalty  Falabella / Loyalty  ...         Wom / Loyalty   \n",
       "2      Falabella / Loyalty      Paris / Loyalty  ...   Falabella / Loyalty   \n",
       "...                    ...                  ...  ...                   ...   \n",
       "8     Mac Online / Loyalty                  NaN  ...                   NaN   \n",
       "9         Ripley / Loyalty                  NaN  ...                   NaN   \n",
       "10      Movistar / Loyalty                  NaN  ...                   NaN   \n",
       "\n",
       "    Apple iPhone 14 512GB  Apple iPhone 11 64GB Apple iPhone 14 Plus 256GB   \\\n",
       "0                My price              My price                    My price   \n",
       "1           Wom / Loyalty         Wom / Loyalty               Wom / Loyalty   \n",
       "2     Falabella / Loyalty   Falabella / Loyalty         Falabella / Loyalty   \n",
       "...                   ...                   ...                         ...   \n",
       "8                     NaN  Mac Online / Loyalty          Movistar / Loyalty   \n",
       "9                     NaN      Ripley / Loyalty                         NaN   \n",
       "10                    NaN    Movistar / Loyalty                         NaN   \n",
       "\n",
       "    Samsung Galaxy S22 256GB (5G) Apple iPhone 14 Pro 256GB  \\\n",
       "0                        My price                  My price   \n",
       "1                   Wom / Loyalty             Wom / Loyalty   \n",
       "2             Falabella / Loyalty       Falabella / Loyalty   \n",
       "...                           ...                       ...   \n",
       "8              Movistar / Loyalty          Ripley / Loyalty   \n",
       "9                             NaN        Movistar / Loyalty   \n",
       "10                            NaN                       NaN   \n",
       "\n",
       "        Vivo Y22s 128GB  Samsung Galaxy A23 128GB (5G) Apple iPhone 14 256GB   \\\n",
       "0               My price                      My price               My price   \n",
       "1          Wom / Loyalty                 Wom / Loyalty          Wom / Loyalty   \n",
       "2    Falabella / Loyalty           Falabella / Loyalty    Falabella / Loyalty   \n",
       "...                  ...                           ...                    ...   \n",
       "8                    NaN            Movistar / Loyalty       Ripley / Loyalty   \n",
       "9                    NaN                           NaN     Movistar / Loyalty   \n",
       "10                   NaN                           NaN                    NaN   \n",
       "\n",
       "    Apple iPhone 14 Pro Max 128GB   \n",
       "0                         My price  \n",
       "1                    Wom / Loyalty  \n",
       "2              Falabella / Loyalty  \n",
       "...                            ...  \n",
       "8                 Ripley / Loyalty  \n",
       "9               Movistar / Loyalty  \n",
       "10                             NaN  \n",
       "\n",
       "[7 rows x 21 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "df_complete=pd.DataFrame()\n",
    "\n",
    "\n",
    "for p in list_product:\n",
    "    \n",
    "    \n",
    "\n",
    "    df_products_companies=df_products(p,sheet_name='No Client') \n",
    "    \n",
    "    \n",
    "    df_complete = pd.concat([df_complete, df_products_companies], axis=1)\n",
    "\n",
    "df_complete.to_excel('Prices_Excel/processed_data/CL/CL_No_Client.xlsx', index=False)\n",
    "apresentar_primeiras_e_ultimas_com_reticencias(df_complete)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4b0374fb",
   "metadata": {},
   "source": [
    "# Postpaid New Line"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "da13e230",
   "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>Apple iPhone 14 Plus 128GB</th>\n",
       "      <th>Samsung Galaxy S23 256GB</th>\n",
       "      <th>Apple iPhone 13 128GB</th>\n",
       "      <th>Samsung Galaxy Z Fold4 256GB (5G)</th>\n",
       "      <th>Samsung Galaxy Z Flip4 256GB (5G)</th>\n",
       "      <th>Apple iPhone 14 Pro Max 256GB</th>\n",
       "      <th>Apple iPhone 14 Pro 128GB</th>\n",
       "      <th>Samsung Galaxy S22 128GB (5G)</th>\n",
       "      <th>Apple iPhone 14 128GB</th>\n",
       "      <th>Vivo Y16 64GB</th>\n",
       "      <th>...</th>\n",
       "      <th>Apple iPhone 11 128GB</th>\n",
       "      <th>Apple iPhone 14 512GB</th>\n",
       "      <th>Apple iPhone 11 64GB</th>\n",
       "      <th>Apple iPhone 14 Plus 256GB</th>\n",
       "      <th>Samsung Galaxy S22 256GB (5G)</th>\n",
       "      <th>Apple iPhone 14 Pro 256GB</th>\n",
       "      <th>Vivo Y22s 128GB</th>\n",
       "      <th>Samsung Galaxy A23 128GB (5G)</th>\n",
       "      <th>Apple iPhone 14 256GB</th>\n",
       "      <th>Apple iPhone 14 Pro Max 128GB</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>...</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>...</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>...</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>...</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>...</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>...</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>...</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Apple iPhone 14 Plus 128GB  Samsung Galaxy S23 256GB Apple iPhone 13 128GB  \\\n",
       "0                     My price                 My price              My price   \n",
       "1                Wom / Loyalty            Wom / Loyalty         Wom / Loyalty   \n",
       "2          Falabella / Loyalty      Falabella / Loyalty   Falabella / Loyalty   \n",
       "3              Lider / Loyalty          Lider / Loyalty       Lider / Loyalty   \n",
       "4              Paris / Loyalty          Paris / Loyalty       Paris / Loyalty   \n",
       "5              Claro / Loyalty         Abcdin / Loyalty      Abcdin / Loyalty   \n",
       "6             Aufbau / Loyalty          Claro / Loyalty       Claro / Loyalty   \n",
       "7         Mac Online / Loyalty         Ripley / Loyalty      Aufbau / Loyalty   \n",
       "8             Ripley / Loyalty       Movistar / Loyalty  Mac Online / Loyalty   \n",
       "9           Movistar / Loyalty                      NaN      Ripley / Loyalty   \n",
       "10                         NaN                      NaN    Movistar / Loyalty   \n",
       "\n",
       "   Samsung Galaxy Z Fold4 256GB (5G) Samsung Galaxy Z Flip4 256GB (5G)  \\\n",
       "0                           My price                          My price   \n",
       "1                      Wom / Loyalty                     Wom / Loyalty   \n",
       "2                Falabella / Loyalty               Falabella / Loyalty   \n",
       "3                    Lider / Loyalty                   Lider / Loyalty   \n",
       "4                    Paris / Loyalty                   Paris / Loyalty   \n",
       "5                   Abcdin / Loyalty                  Abcdin / Loyalty   \n",
       "6                    Claro / Loyalty                   Claro / Loyalty   \n",
       "7                   Ripley / Loyalty                  Ripley / Loyalty   \n",
       "8                 Movistar / Loyalty                Movistar / Loyalty   \n",
       "9                                NaN                               NaN   \n",
       "10                               NaN                               NaN   \n",
       "\n",
       "   Apple iPhone 14 Pro Max 256GB  Apple iPhone 14 Pro 128GB  \\\n",
       "0                        My price                  My price   \n",
       "1                   Wom / Loyalty             Wom / Loyalty   \n",
       "2             Falabella / Loyalty       Falabella / Loyalty   \n",
       "3                 Lider / Loyalty           Lider / Loyalty   \n",
       "4                 Paris / Loyalty           Paris / Loyalty   \n",
       "5                 Claro / Loyalty           Claro / Loyalty   \n",
       "6                Aufbau / Loyalty          Aufbau / Loyalty   \n",
       "7            Mac Online / Loyalty      Mac Online / Loyalty   \n",
       "8                Ripley / Loyalty          Ripley / Loyalty   \n",
       "9              Movistar / Loyalty        Movistar / Loyalty   \n",
       "10                            NaN                       NaN   \n",
       "\n",
       "   Samsung Galaxy S22 128GB (5G) Apple iPhone 14 128GB         Vivo Y16 64GB  \\\n",
       "0                       My price               My price             My price   \n",
       "1                  Wom / Loyalty          Wom / Loyalty  Falabella / Loyalty   \n",
       "2            Falabella / Loyalty    Falabella / Loyalty      Paris / Loyalty   \n",
       "3                Lider / Loyalty        Lider / Loyalty     Abcdin / Loyalty   \n",
       "4                Paris / Loyalty        Paris / Loyalty      Claro / Loyalty   \n",
       "5               Abcdin / Loyalty       Abcdin / Loyalty     Ripley / Loyalty   \n",
       "6                Claro / Loyalty        Claro / Loyalty   Movistar / Loyalty   \n",
       "7               Ripley / Loyalty       Aufbau / Loyalty                  NaN   \n",
       "8             Movistar / Loyalty   Mac Online / Loyalty                  NaN   \n",
       "9                            NaN       Ripley / Loyalty                  NaN   \n",
       "10                           NaN     Movistar / Loyalty                  NaN   \n",
       "\n",
       "    ... Apple iPhone 11 128GB Apple iPhone 14 512GB  Apple iPhone 11 64GB  \\\n",
       "0   ...              My price              My price              My price   \n",
       "1   ...         Wom / Loyalty         Wom / Loyalty         Wom / Loyalty   \n",
       "2   ...   Falabella / Loyalty   Falabella / Loyalty   Falabella / Loyalty   \n",
       "3   ...       Paris / Loyalty       Paris / Loyalty       Lider / Loyalty   \n",
       "4   ...      Aufbau / Loyalty      Aufbau / Loyalty       Paris / Loyalty   \n",
       "5   ...  Mac Online / Loyalty  Mac Online / Loyalty      Abcdin / Loyalty   \n",
       "6   ...      Ripley / Loyalty    Movistar / Loyalty       Claro / Loyalty   \n",
       "7   ...    Movistar / Loyalty                   NaN      Aufbau / Loyalty   \n",
       "8   ...                   NaN                   NaN  Mac Online / Loyalty   \n",
       "9   ...                   NaN                   NaN      Ripley / Loyalty   \n",
       "10  ...                   NaN                   NaN    Movistar / Loyalty   \n",
       "\n",
       "   Apple iPhone 14 Plus 256GB  Samsung Galaxy S22 256GB (5G)  \\\n",
       "0                     My price                      My price   \n",
       "1                Wom / Loyalty                 Wom / Loyalty   \n",
       "2          Falabella / Loyalty           Falabella / Loyalty   \n",
       "3              Paris / Loyalty               Lider / Loyalty   \n",
       "4              Claro / Loyalty               Paris / Loyalty   \n",
       "5             Aufbau / Loyalty              Abcdin / Loyalty   \n",
       "6         Mac Online / Loyalty               Claro / Loyalty   \n",
       "7             Ripley / Loyalty              Ripley / Loyalty   \n",
       "8           Movistar / Loyalty            Movistar / Loyalty   \n",
       "9                          NaN                           NaN   \n",
       "10                         NaN                           NaN   \n",
       "\n",
       "   Apple iPhone 14 Pro 256GB     Vivo Y22s 128GB   \\\n",
       "0                   My price             My price   \n",
       "1              Wom / Loyalty        Wom / Loyalty   \n",
       "2        Falabella / Loyalty  Falabella / Loyalty   \n",
       "3            Lider / Loyalty      Paris / Loyalty   \n",
       "4            Paris / Loyalty     Abcdin / Loyalty   \n",
       "5            Claro / Loyalty      Claro / Loyalty   \n",
       "6           Aufbau / Loyalty     Ripley / Loyalty   \n",
       "7       Mac Online / Loyalty   Movistar / Loyalty   \n",
       "8           Ripley / Loyalty                  NaN   \n",
       "9         Movistar / Loyalty                  NaN   \n",
       "10                       NaN                  NaN   \n",
       "\n",
       "   Samsung Galaxy A23 128GB (5G) Apple iPhone 14 256GB   \\\n",
       "0                       My price               My price   \n",
       "1                  Wom / Loyalty          Wom / Loyalty   \n",
       "2            Falabella / Loyalty    Falabella / Loyalty   \n",
       "3                Lider / Loyalty        Lider / Loyalty   \n",
       "4                Paris / Loyalty        Paris / Loyalty   \n",
       "5               Abcdin / Loyalty        Claro / Loyalty   \n",
       "6                Claro / Loyalty       Aufbau / Loyalty   \n",
       "7               Ripley / Loyalty   Mac Online / Loyalty   \n",
       "8             Movistar / Loyalty       Ripley / Loyalty   \n",
       "9                            NaN     Movistar / Loyalty   \n",
       "10                           NaN                    NaN   \n",
       "\n",
       "   Apple iPhone 14 Pro Max 128GB   \n",
       "0                        My price  \n",
       "1                   Wom / Loyalty  \n",
       "2             Falabella / Loyalty  \n",
       "3                 Lider / Loyalty  \n",
       "4                 Paris / Loyalty  \n",
       "5                 Claro / Loyalty  \n",
       "6                Aufbau / Loyalty  \n",
       "7            Mac Online / Loyalty  \n",
       "8                Ripley / Loyalty  \n",
       "9              Movistar / Loyalty  \n",
       "10                            NaN  \n",
       "\n",
       "[11 rows x 21 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_complete=pd.DataFrame()\n",
    "\n",
    "\n",
    "for p in list_product:\n",
    "    \n",
    "    \n",
    "\n",
    "    df_products_companies=df_products(p,sheet_name='Postpaid New Line') \n",
    "    \n",
    "    \n",
    "    df_complete = pd.concat([df_complete, df_products_companies], axis=1)\n",
    "\n",
    "df_complete.to_excel('Prices_Excel/processed_data/CL/CL_Postpaid_New_Line.xlsx', index=False)\n",
    "df_complete "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a40595c4",
   "metadata": {},
   "source": [
    "# Postpaid Renew"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "ad4ee976",
   "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>Apple iPhone 14 Plus 128GB</th>\n",
       "      <th>Samsung Galaxy S23 256GB</th>\n",
       "      <th>Apple iPhone 13 128GB</th>\n",
       "      <th>Samsung Galaxy Z Fold4 256GB (5G)</th>\n",
       "      <th>Samsung Galaxy Z Flip4 256GB (5G)</th>\n",
       "      <th>Apple iPhone 14 Pro Max 256GB</th>\n",
       "      <th>Apple iPhone 14 Pro 128GB</th>\n",
       "      <th>Samsung Galaxy S22 128GB (5G)</th>\n",
       "      <th>Apple iPhone 14 128GB</th>\n",
       "      <th>Vivo Y16 64GB</th>\n",
       "      <th>...</th>\n",
       "      <th>Apple iPhone 11 128GB</th>\n",
       "      <th>Apple iPhone 14 512GB</th>\n",
       "      <th>Apple iPhone 11 64GB</th>\n",
       "      <th>Apple iPhone 14 Plus 256GB</th>\n",
       "      <th>Samsung Galaxy S22 256GB (5G)</th>\n",
       "      <th>Apple iPhone 14 Pro 256GB</th>\n",
       "      <th>Vivo Y22s 128GB</th>\n",
       "      <th>Samsung Galaxy A23 128GB (5G)</th>\n",
       "      <th>Apple iPhone 14 256GB</th>\n",
       "      <th>Apple iPhone 14 Pro Max 128GB</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>...</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>...</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>...</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>...</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>...</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>...</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>...</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Apple iPhone 14 Plus 128GB  Samsung Galaxy S23 256GB Apple iPhone 13 128GB  \\\n",
       "0                     My price                 My price              My price   \n",
       "1                Wom / Loyalty            Wom / Loyalty         Wom / Loyalty   \n",
       "2          Falabella / Loyalty      Falabella / Loyalty   Falabella / Loyalty   \n",
       "3              Lider / Loyalty          Lider / Loyalty       Lider / Loyalty   \n",
       "4              Paris / Loyalty          Paris / Loyalty       Paris / Loyalty   \n",
       "5              Claro / Loyalty         Abcdin / Loyalty      Abcdin / Loyalty   \n",
       "6             Aufbau / Loyalty          Claro / Loyalty       Claro / Loyalty   \n",
       "7         Mac Online / Loyalty         Ripley / Loyalty      Aufbau / Loyalty   \n",
       "8             Ripley / Loyalty       Movistar / Loyalty  Mac Online / Loyalty   \n",
       "9           Movistar / Loyalty                      NaN      Ripley / Loyalty   \n",
       "10                         NaN                      NaN    Movistar / Loyalty   \n",
       "\n",
       "   Samsung Galaxy Z Fold4 256GB (5G) Samsung Galaxy Z Flip4 256GB (5G)  \\\n",
       "0                           My price                          My price   \n",
       "1                      Wom / Loyalty                     Wom / Loyalty   \n",
       "2                Falabella / Loyalty               Falabella / Loyalty   \n",
       "3                    Lider / Loyalty                   Lider / Loyalty   \n",
       "4                    Paris / Loyalty                   Paris / Loyalty   \n",
       "5                   Abcdin / Loyalty                  Abcdin / Loyalty   \n",
       "6                    Claro / Loyalty                   Claro / Loyalty   \n",
       "7                   Ripley / Loyalty                  Ripley / Loyalty   \n",
       "8                 Movistar / Loyalty                Movistar / Loyalty   \n",
       "9                                NaN                               NaN   \n",
       "10                               NaN                               NaN   \n",
       "\n",
       "   Apple iPhone 14 Pro Max 256GB  Apple iPhone 14 Pro 128GB  \\\n",
       "0                        My price                  My price   \n",
       "1                   Wom / Loyalty             Wom / Loyalty   \n",
       "2             Falabella / Loyalty       Falabella / Loyalty   \n",
       "3                 Lider / Loyalty           Lider / Loyalty   \n",
       "4                 Paris / Loyalty           Paris / Loyalty   \n",
       "5                 Claro / Loyalty           Claro / Loyalty   \n",
       "6                Aufbau / Loyalty          Aufbau / Loyalty   \n",
       "7            Mac Online / Loyalty      Mac Online / Loyalty   \n",
       "8                Ripley / Loyalty          Ripley / Loyalty   \n",
       "9              Movistar / Loyalty        Movistar / Loyalty   \n",
       "10                            NaN                       NaN   \n",
       "\n",
       "   Samsung Galaxy S22 128GB (5G) Apple iPhone 14 128GB         Vivo Y16 64GB  \\\n",
       "0                       My price               My price             My price   \n",
       "1                  Wom / Loyalty          Wom / Loyalty  Falabella / Loyalty   \n",
       "2            Falabella / Loyalty    Falabella / Loyalty      Paris / Loyalty   \n",
       "3                Lider / Loyalty        Lider / Loyalty     Abcdin / Loyalty   \n",
       "4                Paris / Loyalty        Paris / Loyalty      Claro / Loyalty   \n",
       "5               Abcdin / Loyalty       Abcdin / Loyalty     Ripley / Loyalty   \n",
       "6                Claro / Loyalty        Claro / Loyalty   Movistar / Loyalty   \n",
       "7               Ripley / Loyalty       Aufbau / Loyalty                  NaN   \n",
       "8             Movistar / Loyalty   Mac Online / Loyalty                  NaN   \n",
       "9                            NaN       Ripley / Loyalty                  NaN   \n",
       "10                           NaN     Movistar / Loyalty                  NaN   \n",
       "\n",
       "    ... Apple iPhone 11 128GB Apple iPhone 14 512GB  Apple iPhone 11 64GB  \\\n",
       "0   ...              My price              My price              My price   \n",
       "1   ...         Wom / Loyalty         Wom / Loyalty         Wom / Loyalty   \n",
       "2   ...   Falabella / Loyalty   Falabella / Loyalty   Falabella / Loyalty   \n",
       "3   ...       Paris / Loyalty       Paris / Loyalty       Lider / Loyalty   \n",
       "4   ...      Aufbau / Loyalty      Aufbau / Loyalty       Paris / Loyalty   \n",
       "5   ...  Mac Online / Loyalty  Mac Online / Loyalty      Abcdin / Loyalty   \n",
       "6   ...      Ripley / Loyalty    Movistar / Loyalty       Claro / Loyalty   \n",
       "7   ...    Movistar / Loyalty                   NaN      Aufbau / Loyalty   \n",
       "8   ...                   NaN                   NaN  Mac Online / Loyalty   \n",
       "9   ...                   NaN                   NaN      Ripley / Loyalty   \n",
       "10  ...                   NaN                   NaN    Movistar / Loyalty   \n",
       "\n",
       "   Apple iPhone 14 Plus 256GB  Samsung Galaxy S22 256GB (5G)  \\\n",
       "0                     My price                      My price   \n",
       "1                Wom / Loyalty                 Wom / Loyalty   \n",
       "2          Falabella / Loyalty           Falabella / Loyalty   \n",
       "3              Paris / Loyalty               Lider / Loyalty   \n",
       "4              Claro / Loyalty               Paris / Loyalty   \n",
       "5             Aufbau / Loyalty              Abcdin / Loyalty   \n",
       "6         Mac Online / Loyalty               Claro / Loyalty   \n",
       "7             Ripley / Loyalty              Ripley / Loyalty   \n",
       "8           Movistar / Loyalty            Movistar / Loyalty   \n",
       "9                          NaN                           NaN   \n",
       "10                         NaN                           NaN   \n",
       "\n",
       "   Apple iPhone 14 Pro 256GB     Vivo Y22s 128GB   \\\n",
       "0                   My price             My price   \n",
       "1              Wom / Loyalty        Wom / Loyalty   \n",
       "2        Falabella / Loyalty  Falabella / Loyalty   \n",
       "3            Lider / Loyalty      Paris / Loyalty   \n",
       "4            Paris / Loyalty     Abcdin / Loyalty   \n",
       "5            Claro / Loyalty      Claro / Loyalty   \n",
       "6           Aufbau / Loyalty     Ripley / Loyalty   \n",
       "7       Mac Online / Loyalty   Movistar / Loyalty   \n",
       "8           Ripley / Loyalty                  NaN   \n",
       "9         Movistar / Loyalty                  NaN   \n",
       "10                       NaN                  NaN   \n",
       "\n",
       "   Samsung Galaxy A23 128GB (5G) Apple iPhone 14 256GB   \\\n",
       "0                       My price               My price   \n",
       "1                  Wom / Loyalty          Wom / Loyalty   \n",
       "2            Falabella / Loyalty    Falabella / Loyalty   \n",
       "3                Lider / Loyalty        Lider / Loyalty   \n",
       "4                Paris / Loyalty        Paris / Loyalty   \n",
       "5               Abcdin / Loyalty        Claro / Loyalty   \n",
       "6                Claro / Loyalty       Aufbau / Loyalty   \n",
       "7               Ripley / Loyalty   Mac Online / Loyalty   \n",
       "8             Movistar / Loyalty       Ripley / Loyalty   \n",
       "9                            NaN     Movistar / Loyalty   \n",
       "10                           NaN                    NaN   \n",
       "\n",
       "   Apple iPhone 14 Pro Max 128GB   \n",
       "0                        My price  \n",
       "1                   Wom / Loyalty  \n",
       "2             Falabella / Loyalty  \n",
       "3                 Lider / Loyalty  \n",
       "4                 Paris / Loyalty  \n",
       "5                 Claro / Loyalty  \n",
       "6                Aufbau / Loyalty  \n",
       "7            Mac Online / Loyalty  \n",
       "8                Ripley / Loyalty  \n",
       "9              Movistar / Loyalty  \n",
       "10                            NaN  \n",
       "\n",
       "[11 rows x 21 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_complete=pd.DataFrame()\n",
    "\n",
    "\n",
    "for p in list_product:\n",
    "    \n",
    "    \n",
    "\n",
    "    df_products_companies=df_products(p,sheet_name='Postpaid Renew') \n",
    "    \n",
    "    \n",
    "    df_complete = pd.concat([df_complete, df_products_companies], axis=1)\n",
    "\n",
    "df_complete.to_excel('Prices_Excel/processed_data/CL/CL_Postpaid_Renew.xlsx', index=False)\n",
    "df_complete "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "78a1fe45",
   "metadata": {},
   "source": [
    "# Postpaid Portability"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "10c71e80",
   "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>Apple iPhone 14 Plus 128GB</th>\n",
       "      <th>Samsung Galaxy S23 256GB</th>\n",
       "      <th>Apple iPhone 13 128GB</th>\n",
       "      <th>Samsung Galaxy Z Fold4 256GB (5G)</th>\n",
       "      <th>Samsung Galaxy Z Flip4 256GB (5G)</th>\n",
       "      <th>Apple iPhone 14 Pro Max 256GB</th>\n",
       "      <th>Apple iPhone 14 Pro 128GB</th>\n",
       "      <th>Samsung Galaxy S22 128GB (5G)</th>\n",
       "      <th>Apple iPhone 14 128GB</th>\n",
       "      <th>Vivo Y16 64GB</th>\n",
       "      <th>...</th>\n",
       "      <th>Apple iPhone 11 128GB</th>\n",
       "      <th>Apple iPhone 14 512GB</th>\n",
       "      <th>Apple iPhone 11 64GB</th>\n",
       "      <th>Apple iPhone 14 Plus 256GB</th>\n",
       "      <th>Samsung Galaxy S22 256GB (5G)</th>\n",
       "      <th>Apple iPhone 14 Pro 256GB</th>\n",
       "      <th>Vivo Y22s 128GB</th>\n",
       "      <th>Samsung Galaxy A23 128GB (5G)</th>\n",
       "      <th>Apple iPhone 14 256GB</th>\n",
       "      <th>Apple iPhone 14 Pro Max 128GB</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>...</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "      <td>My price</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>...</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "      <td>Wom / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>...</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "      <td>Falabella / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>...</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "      <td>Lider / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>...</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "      <td>Paris / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>...</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Abcdin / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>...</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Claro / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Aufbau / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mac Online / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ripley / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Movistar / Loyalty</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Apple iPhone 14 Plus 128GB  Samsung Galaxy S23 256GB Apple iPhone 13 128GB  \\\n",
       "0                     My price                 My price              My price   \n",
       "1                Wom / Loyalty            Wom / Loyalty         Wom / Loyalty   \n",
       "2          Falabella / Loyalty      Falabella / Loyalty   Falabella / Loyalty   \n",
       "3              Lider / Loyalty          Lider / Loyalty       Lider / Loyalty   \n",
       "4              Paris / Loyalty          Paris / Loyalty       Paris / Loyalty   \n",
       "5              Claro / Loyalty         Abcdin / Loyalty      Abcdin / Loyalty   \n",
       "6             Aufbau / Loyalty          Claro / Loyalty       Claro / Loyalty   \n",
       "7         Mac Online / Loyalty         Ripley / Loyalty      Aufbau / Loyalty   \n",
       "8             Ripley / Loyalty       Movistar / Loyalty  Mac Online / Loyalty   \n",
       "9           Movistar / Loyalty                      NaN      Ripley / Loyalty   \n",
       "10                         NaN                      NaN    Movistar / Loyalty   \n",
       "\n",
       "   Samsung Galaxy Z Fold4 256GB (5G) Samsung Galaxy Z Flip4 256GB (5G)  \\\n",
       "0                           My price                          My price   \n",
       "1                      Wom / Loyalty                     Wom / Loyalty   \n",
       "2                Falabella / Loyalty               Falabella / Loyalty   \n",
       "3                    Lider / Loyalty                   Lider / Loyalty   \n",
       "4                    Paris / Loyalty                   Paris / Loyalty   \n",
       "5                   Abcdin / Loyalty                  Abcdin / Loyalty   \n",
       "6                    Claro / Loyalty                   Claro / Loyalty   \n",
       "7                   Ripley / Loyalty                  Ripley / Loyalty   \n",
       "8                 Movistar / Loyalty                Movistar / Loyalty   \n",
       "9                                NaN                               NaN   \n",
       "10                               NaN                               NaN   \n",
       "\n",
       "   Apple iPhone 14 Pro Max 256GB  Apple iPhone 14 Pro 128GB  \\\n",
       "0                        My price                  My price   \n",
       "1                   Wom / Loyalty             Wom / Loyalty   \n",
       "2             Falabella / Loyalty       Falabella / Loyalty   \n",
       "3                 Lider / Loyalty           Lider / Loyalty   \n",
       "4                 Paris / Loyalty           Paris / Loyalty   \n",
       "5                 Claro / Loyalty           Claro / Loyalty   \n",
       "6                Aufbau / Loyalty          Aufbau / Loyalty   \n",
       "7            Mac Online / Loyalty      Mac Online / Loyalty   \n",
       "8                Ripley / Loyalty          Ripley / Loyalty   \n",
       "9              Movistar / Loyalty        Movistar / Loyalty   \n",
       "10                            NaN                       NaN   \n",
       "\n",
       "   Samsung Galaxy S22 128GB (5G) Apple iPhone 14 128GB         Vivo Y16 64GB  \\\n",
       "0                       My price               My price             My price   \n",
       "1                  Wom / Loyalty          Wom / Loyalty  Falabella / Loyalty   \n",
       "2            Falabella / Loyalty    Falabella / Loyalty      Paris / Loyalty   \n",
       "3                Lider / Loyalty        Lider / Loyalty     Abcdin / Loyalty   \n",
       "4                Paris / Loyalty        Paris / Loyalty      Claro / Loyalty   \n",
       "5               Abcdin / Loyalty       Abcdin / Loyalty     Ripley / Loyalty   \n",
       "6                Claro / Loyalty        Claro / Loyalty   Movistar / Loyalty   \n",
       "7               Ripley / Loyalty       Aufbau / Loyalty                  NaN   \n",
       "8             Movistar / Loyalty   Mac Online / Loyalty                  NaN   \n",
       "9                            NaN       Ripley / Loyalty                  NaN   \n",
       "10                           NaN     Movistar / Loyalty                  NaN   \n",
       "\n",
       "    ... Apple iPhone 11 128GB Apple iPhone 14 512GB  Apple iPhone 11 64GB  \\\n",
       "0   ...              My price              My price              My price   \n",
       "1   ...         Wom / Loyalty         Wom / Loyalty         Wom / Loyalty   \n",
       "2   ...   Falabella / Loyalty   Falabella / Loyalty   Falabella / Loyalty   \n",
       "3   ...       Paris / Loyalty       Paris / Loyalty       Lider / Loyalty   \n",
       "4   ...      Aufbau / Loyalty      Aufbau / Loyalty       Paris / Loyalty   \n",
       "5   ...  Mac Online / Loyalty  Mac Online / Loyalty      Abcdin / Loyalty   \n",
       "6   ...      Ripley / Loyalty    Movistar / Loyalty       Claro / Loyalty   \n",
       "7   ...    Movistar / Loyalty                   NaN      Aufbau / Loyalty   \n",
       "8   ...                   NaN                   NaN  Mac Online / Loyalty   \n",
       "9   ...                   NaN                   NaN      Ripley / Loyalty   \n",
       "10  ...                   NaN                   NaN    Movistar / Loyalty   \n",
       "\n",
       "   Apple iPhone 14 Plus 256GB  Samsung Galaxy S22 256GB (5G)  \\\n",
       "0                     My price                      My price   \n",
       "1                Wom / Loyalty                 Wom / Loyalty   \n",
       "2          Falabella / Loyalty           Falabella / Loyalty   \n",
       "3              Paris / Loyalty               Lider / Loyalty   \n",
       "4              Claro / Loyalty               Paris / Loyalty   \n",
       "5             Aufbau / Loyalty              Abcdin / Loyalty   \n",
       "6         Mac Online / Loyalty               Claro / Loyalty   \n",
       "7             Ripley / Loyalty              Ripley / Loyalty   \n",
       "8           Movistar / Loyalty            Movistar / Loyalty   \n",
       "9                          NaN                           NaN   \n",
       "10                         NaN                           NaN   \n",
       "\n",
       "   Apple iPhone 14 Pro 256GB     Vivo Y22s 128GB   \\\n",
       "0                   My price             My price   \n",
       "1              Wom / Loyalty        Wom / Loyalty   \n",
       "2        Falabella / Loyalty  Falabella / Loyalty   \n",
       "3            Lider / Loyalty      Paris / Loyalty   \n",
       "4            Paris / Loyalty     Abcdin / Loyalty   \n",
       "5            Claro / Loyalty      Claro / Loyalty   \n",
       "6           Aufbau / Loyalty     Ripley / Loyalty   \n",
       "7       Mac Online / Loyalty   Movistar / Loyalty   \n",
       "8           Ripley / Loyalty                  NaN   \n",
       "9         Movistar / Loyalty                  NaN   \n",
       "10                       NaN                  NaN   \n",
       "\n",
       "   Samsung Galaxy A23 128GB (5G) Apple iPhone 14 256GB   \\\n",
       "0                       My price               My price   \n",
       "1                  Wom / Loyalty          Wom / Loyalty   \n",
       "2            Falabella / Loyalty    Falabella / Loyalty   \n",
       "3                Lider / Loyalty        Lider / Loyalty   \n",
       "4                Paris / Loyalty        Paris / Loyalty   \n",
       "5               Abcdin / Loyalty        Claro / Loyalty   \n",
       "6                Claro / Loyalty       Aufbau / Loyalty   \n",
       "7               Ripley / Loyalty   Mac Online / Loyalty   \n",
       "8             Movistar / Loyalty       Ripley / Loyalty   \n",
       "9                            NaN     Movistar / Loyalty   \n",
       "10                           NaN                    NaN   \n",
       "\n",
       "   Apple iPhone 14 Pro Max 128GB   \n",
       "0                        My price  \n",
       "1                   Wom / Loyalty  \n",
       "2             Falabella / Loyalty  \n",
       "3                 Lider / Loyalty  \n",
       "4                 Paris / Loyalty  \n",
       "5                 Claro / Loyalty  \n",
       "6                Aufbau / Loyalty  \n",
       "7            Mac Online / Loyalty  \n",
       "8                Ripley / Loyalty  \n",
       "9              Movistar / Loyalty  \n",
       "10                            NaN  \n",
       "\n",
       "[11 rows x 21 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_complete=pd.DataFrame()\n",
    "\n",
    "\n",
    "for p in list_product:\n",
    "    \n",
    "    \n",
    "\n",
    "    df_products_companies=df_products(p,sheet_name='Postpaid Portability') \n",
    "    \n",
    "    \n",
    "    df_complete = pd.concat([df_complete, df_products_companies], axis=1)\n",
    "\n",
    "df_complete.to_excel('Prices_Excel/processed_data/CL/CL_Postpaid_Portability.xlsx', index=False)\n",
    "df_complete "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9d201bc0",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}