dataset_analysis_CL_2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "c13dab79",
   "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"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "f6e6f0a3",
   "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"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "d70733e5",
   "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": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data=pd.read_excel(\"Prices_Excel/processed_data/CL/products_company/CL_No_Client.xlsx\") \n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "f00dbd0a",
   "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",
       " 'Aufbau / Loyalty',\n",
       " 'Mac Online / Loyalty',\n",
       " 'Ripley / Loyalty',\n",
       " 'Movistar / Loyalty']"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_companies= data['Apple iPhone 13 128GB']\n",
    "all_companies=all_companies.tolist()\n",
    "all_companies\n",
    "#type(all_companies)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "b78d8d7f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Apple iPhone 14 Plus 128GB ', 'Samsung Galaxy S23 256GB',\n",
       "       'Apple iPhone 13 128GB', 'Samsung Galaxy Z Fold4 256GB (5G)',\n",
       "       'Samsung Galaxy Z Flip4 256GB (5G)', 'Apple iPhone 14 Pro Max 256GB ',\n",
       "       'Apple iPhone 14 Pro 128GB', 'Samsung Galaxy S22 128GB (5G)',\n",
       "       'Apple iPhone 14 128GB ', 'Vivo Y16 64GB', 'Motorola Moto E22i  64GB',\n",
       "       'Apple iPhone 11 128GB', 'Apple iPhone 14 512GB',\n",
       "       'Apple iPhone 11 64GB', 'Apple iPhone 14 Plus 256GB ',\n",
       "       'Samsung Galaxy S22 256GB (5G)', 'Apple iPhone 14 Pro 256GB',\n",
       "       'Vivo Y22s 128GB ', 'Samsung Galaxy A23 128GB (5G)',\n",
       "       'Apple iPhone 14 256GB ', 'Apple iPhone 14 Pro Max 128GB '],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_products=data.columns\n",
    "\n",
    "all_products"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0f920fa6",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "8ae21bf6",
   "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>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>Aufbau / Loyalty</th>\n",
       "      <th>Mac Online / 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>Apple iPhone 14 Plus 128GB</td>\n",
       "      <td>Apple iPhone 14 Plus 128GB</td>\n",
       "      <td>Apple iPhone 14 Plus 128GB</td>\n",
       "      <td>Apple iPhone 14 Plus 128GB</td>\n",
       "      <td>Apple iPhone 14 Plus 128GB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Apple iPhone 14 Plus 128GB</td>\n",
       "      <td>Apple iPhone 14 Plus 128GB</td>\n",
       "      <td>Apple iPhone 14 Plus 128GB</td>\n",
       "      <td>Apple iPhone 14 Plus 128GB</td>\n",
       "      <td>Apple iPhone 14 Plus 128GB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Samsung Galaxy S23 256GB</td>\n",
       "      <td>Samsung Galaxy S23 256GB</td>\n",
       "      <td>Samsung Galaxy S23 256GB</td>\n",
       "      <td>Samsung Galaxy S23 256GB</td>\n",
       "      <td>Samsung Galaxy S23 256GB</td>\n",
       "      <td>Samsung Galaxy S23 256GB</td>\n",
       "      <td>Samsung Galaxy S23 256GB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Samsung Galaxy S23 256GB</td>\n",
       "      <td>Samsung Galaxy S23 256GB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Apple iPhone 13 128GB</td>\n",
       "      <td>Apple iPhone 13 128GB</td>\n",
       "      <td>Apple iPhone 13 128GB</td>\n",
       "      <td>Apple iPhone 13 128GB</td>\n",
       "      <td>Apple iPhone 13 128GB</td>\n",
       "      <td>Apple iPhone 13 128GB</td>\n",
       "      <td>Apple iPhone 13 128GB</td>\n",
       "      <td>Apple iPhone 13 128GB</td>\n",
       "      <td>Apple iPhone 13 128GB</td>\n",
       "      <td>Apple iPhone 13 128GB</td>\n",
       "      <td>Apple iPhone 13 128GB</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Samsung Galaxy A23 128GB (5G)</td>\n",
       "      <td>Samsung Galaxy A23 128GB (5G)</td>\n",
       "      <td>Samsung Galaxy A23 128GB (5G)</td>\n",
       "      <td>Samsung Galaxy A23 128GB (5G)</td>\n",
       "      <td>Samsung Galaxy A23 128GB (5G)</td>\n",
       "      <td>Samsung Galaxy A23 128GB (5G)</td>\n",
       "      <td>Samsung Galaxy A23 128GB (5G)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Samsung Galaxy A23 128GB (5G)</td>\n",
       "      <td>Samsung Galaxy A23 128GB (5G)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Apple iPhone 14 256GB</td>\n",
       "      <td>Apple iPhone 14 256GB</td>\n",
       "      <td>Apple iPhone 14 256GB</td>\n",
       "      <td>Apple iPhone 14 256GB</td>\n",
       "      <td>Apple iPhone 14 256GB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Apple iPhone 14 256GB</td>\n",
       "      <td>Apple iPhone 14 256GB</td>\n",
       "      <td>Apple iPhone 14 256GB</td>\n",
       "      <td>Apple iPhone 14 256GB</td>\n",
       "      <td>Apple iPhone 14 256GB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Apple iPhone 14 Pro Max 128GB</td>\n",
       "      <td>Apple iPhone 14 Pro Max 128GB</td>\n",
       "      <td>Apple iPhone 14 Pro Max 128GB</td>\n",
       "      <td>Apple iPhone 14 Pro Max 128GB</td>\n",
       "      <td>Apple iPhone 14 Pro Max 128GB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Apple iPhone 14 Pro Max 128GB</td>\n",
       "      <td>Apple iPhone 14 Pro Max 128GB</td>\n",
       "      <td>Apple iPhone 14 Pro Max 128GB</td>\n",
       "      <td>Apple iPhone 14 Pro Max 128GB</td>\n",
       "      <td>Apple iPhone 14 Pro Max 128GB</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           My price                   Wom / Loyalty  \\\n",
       "0       Apple iPhone 14 Plus 128GB      Apple iPhone 14 Plus 128GB    \n",
       "1          Samsung Galaxy S23 256GB        Samsung Galaxy S23 256GB   \n",
       "2             Apple iPhone 13 128GB           Apple iPhone 13 128GB   \n",
       "...                             ...                             ...   \n",
       "18    Samsung Galaxy A23 128GB (5G)   Samsung Galaxy A23 128GB (5G)   \n",
       "19           Apple iPhone 14 256GB           Apple iPhone 14 256GB    \n",
       "20   Apple iPhone 14 Pro Max 128GB   Apple iPhone 14 Pro Max 128GB    \n",
       "\n",
       "                Falabella / Loyalty                 Lider / Loyalty  \\\n",
       "0       Apple iPhone 14 Plus 128GB      Apple iPhone 14 Plus 128GB    \n",
       "1          Samsung Galaxy S23 256GB        Samsung Galaxy S23 256GB   \n",
       "2             Apple iPhone 13 128GB           Apple iPhone 13 128GB   \n",
       "...                             ...                             ...   \n",
       "18    Samsung Galaxy A23 128GB (5G)   Samsung Galaxy A23 128GB (5G)   \n",
       "19           Apple iPhone 14 256GB           Apple iPhone 14 256GB    \n",
       "20   Apple iPhone 14 Pro Max 128GB   Apple iPhone 14 Pro Max 128GB    \n",
       "\n",
       "                    Paris / Loyalty               Abcdin / Loyalty  \\\n",
       "0       Apple iPhone 14 Plus 128GB                             NaN   \n",
       "1          Samsung Galaxy S23 256GB       Samsung Galaxy S23 256GB   \n",
       "2             Apple iPhone 13 128GB          Apple iPhone 13 128GB   \n",
       "...                             ...                            ...   \n",
       "18    Samsung Galaxy A23 128GB (5G)  Samsung Galaxy A23 128GB (5G)   \n",
       "19           Apple iPhone 14 256GB                             NaN   \n",
       "20   Apple iPhone 14 Pro Max 128GB                             NaN   \n",
       "\n",
       "                    Claro / Loyalty                Aufbau / Loyalty  \\\n",
       "0       Apple iPhone 14 Plus 128GB      Apple iPhone 14 Plus 128GB    \n",
       "1          Samsung Galaxy S23 256GB                             NaN   \n",
       "2             Apple iPhone 13 128GB           Apple iPhone 13 128GB   \n",
       "...                             ...                             ...   \n",
       "18    Samsung Galaxy A23 128GB (5G)                             NaN   \n",
       "19           Apple iPhone 14 256GB           Apple iPhone 14 256GB    \n",
       "20   Apple iPhone 14 Pro Max 128GB   Apple iPhone 14 Pro Max 128GB    \n",
       "\n",
       "               Mac Online / Loyalty                Ripley / Loyalty  \\\n",
       "0       Apple iPhone 14 Plus 128GB      Apple iPhone 14 Plus 128GB    \n",
       "1                               NaN        Samsung Galaxy S23 256GB   \n",
       "2             Apple iPhone 13 128GB           Apple iPhone 13 128GB   \n",
       "...                             ...                             ...   \n",
       "18                              NaN   Samsung Galaxy A23 128GB (5G)   \n",
       "19           Apple iPhone 14 256GB           Apple iPhone 14 256GB    \n",
       "20   Apple iPhone 14 Pro Max 128GB   Apple iPhone 14 Pro Max 128GB    \n",
       "\n",
       "                 Movistar / Loyalty  \n",
       "0       Apple iPhone 14 Plus 128GB   \n",
       "1          Samsung Galaxy S23 256GB  \n",
       "2             Apple iPhone 13 128GB  \n",
       "...                             ...  \n",
       "18    Samsung Galaxy A23 128GB (5G)  \n",
       "19           Apple iPhone 14 256GB   \n",
       "20   Apple iPhone 14 Pro Max 128GB   "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "\n",
    "# Criando um dicionário para armazenar os produtos vendidos por cada empresa\n",
    "produtos_por_empresa = {companie: [] for companie in all_companies}\n",
    "\n",
    "\n",
    "for companie in all_companies:\n",
    "    for produto in all_products:\n",
    "        if companie in data[produto].values:\n",
    "            produtos_por_empresa[companie].append(produto)\n",
    "\n",
    "# Criando um novo DataFrame vazio para armazenar os dados reorganizados\n",
    "df_companies_products = pd.DataFrame(index=data.columns, columns=all_companies)  # Definindo as colunas como empresas do novo DataFrame\n",
    "\n",
    "# Preenchendo o novo DataFrame com os produtos vendidos por cada empresa\n",
    "for companie, produtos in produtos_por_empresa.items():\n",
    "    df_companies_products.loc[produtos, companie] = produtos\n",
    "\n",
    "df_companies_products.reset_index(drop=True, inplace=True)\n",
    "apresentar_primeiras_e_ultimas_com_reticencias(df_companies_products)\n",
    "    \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a886db25",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "00012b9b",
   "metadata": {},
   "outputs": [],
   "source": [
    "# criar função"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "a8f1c832",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "def companies_produduct(path):\n",
    "    data=pd.read_excel(path)\n",
    "    all_companies= data['Apple iPhone 13 128GB']\n",
    "    all_companies=all_companies.tolist()\n",
    "    all_products=data.columns\n",
    "    produtos_por_empresa = {companie: [] for companie in all_companies}\n",
    "    for companie in all_companies:\n",
    "        for produto in all_products:\n",
    "            if companie in data[produto].values:\n",
    "                produtos_por_empresa[companie].append(produto)\n",
    "    df_companies_products = pd.DataFrame(index=data.columns, columns=all_companies) \n",
    "\n",
    "\n",
    "    for companie, produtos in produtos_por_empresa.items():\n",
    "        df_companies_products.loc[produtos, companie] = produtos\n",
    "\n",
    "    df_companies_products.reset_index(drop=True, inplace=True)\n",
    "    return df_companies_products\n",
    "    \n",
    "\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "ee20fc23",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Prices_Excel/processed_data/CL/products_company/CL_Postpaid_Portability.xlsx',\n",
       " 'Prices_Excel/processed_data/CL/products_company/CL_Postpaid_New_Line.xlsx',\n",
       " 'Prices_Excel/processed_data/CL/products_company/CL_No_Client.xlsx',\n",
       " 'Prices_Excel/processed_data/CL/products_company/CL_Postpaid_Renew.xlsx']"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "path = \"Prices_Excel/processed_data/CL/products_company\"  \n",
    "list_path_cl = glob.glob(path + \"/*.xlsx\")\n",
    "list_path_cl"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "22c1b3c1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Prices_Excel/processed_data/CL/products_company/CL_Postpaid_Portability_companies_product.xlsx',\n",
       " 'Prices_Excel/processed_data/CL/products_company/CL_Postpaid_New_Line_companies_product.xlsx',\n",
       " 'Prices_Excel/processed_data/CL/products_company/CL_No_Client_companies_product.xlsx',\n",
       " 'Prices_Excel/processed_data/CL/products_company/CL_Postpaid_Renew_companies_product.xlsx']"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    " \n",
    "list_save_name = [item.replace('.xlsx', '_companies_product.xlsx') for item in list_path_cl]\n",
    "\n",
    "\n",
    "list_save_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "a6159beb",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/4p/q7_ch2s94c37xj9l5h3fltgh0000gn/T/ipykernel_44544/269743451.py:4: UserWarning: Pandas requires version '3.0.5' or newer of 'xlsxwriter' (version '3.0.3' currently installed).\n",
      "  df_companies_products.to_excel(save_name, index=False)\n",
      "/var/folders/4p/q7_ch2s94c37xj9l5h3fltgh0000gn/T/ipykernel_44544/269743451.py:4: UserWarning: Pandas requires version '3.0.5' or newer of 'xlsxwriter' (version '3.0.3' currently installed).\n",
      "  df_companies_products.to_excel(save_name, index=False)\n",
      "/var/folders/4p/q7_ch2s94c37xj9l5h3fltgh0000gn/T/ipykernel_44544/269743451.py:4: UserWarning: Pandas requires version '3.0.5' or newer of 'xlsxwriter' (version '3.0.3' currently installed).\n",
      "  df_companies_products.to_excel(save_name, index=False)\n",
      "/var/folders/4p/q7_ch2s94c37xj9l5h3fltgh0000gn/T/ipykernel_44544/269743451.py:4: UserWarning: Pandas requires version '3.0.5' or newer of 'xlsxwriter' (version '3.0.3' currently installed).\n",
      "  df_companies_products.to_excel(save_name, index=False)\n",
      "/var/folders/4p/q7_ch2s94c37xj9l5h3fltgh0000gn/T/ipykernel_44544/269743451.py:4: UserWarning: Pandas requires version '3.0.5' or newer of 'xlsxwriter' (version '3.0.3' currently installed).\n",
      "  df_companies_products.to_excel(save_name, index=False)\n",
      "/var/folders/4p/q7_ch2s94c37xj9l5h3fltgh0000gn/T/ipykernel_44544/269743451.py:4: UserWarning: Pandas requires version '3.0.5' or newer of 'xlsxwriter' (version '3.0.3' currently installed).\n",
      "  df_companies_products.to_excel(save_name, index=False)\n",
      "/var/folders/4p/q7_ch2s94c37xj9l5h3fltgh0000gn/T/ipykernel_44544/269743451.py:4: UserWarning: Pandas requires version '3.0.5' or newer of 'xlsxwriter' (version '3.0.3' currently installed).\n",
      "  df_companies_products.to_excel(save_name, index=False)\n",
      "/var/folders/4p/q7_ch2s94c37xj9l5h3fltgh0000gn/T/ipykernel_44544/269743451.py:4: UserWarning: Pandas requires version '3.0.5' or newer of 'xlsxwriter' (version '3.0.3' currently installed).\n",
      "  df_companies_products.to_excel(save_name, index=False)\n",
      "/var/folders/4p/q7_ch2s94c37xj9l5h3fltgh0000gn/T/ipykernel_44544/269743451.py:4: UserWarning: Pandas requires version '3.0.5' or newer of 'xlsxwriter' (version '3.0.3' currently installed).\n",
      "  df_companies_products.to_excel(save_name, index=False)\n",
      "/var/folders/4p/q7_ch2s94c37xj9l5h3fltgh0000gn/T/ipykernel_44544/269743451.py:4: UserWarning: Pandas requires version '3.0.5' or newer of 'xlsxwriter' (version '3.0.3' currently installed).\n",
      "  df_companies_products.to_excel(save_name, index=False)\n",
      "/var/folders/4p/q7_ch2s94c37xj9l5h3fltgh0000gn/T/ipykernel_44544/269743451.py:4: UserWarning: Pandas requires version '3.0.5' or newer of 'xlsxwriter' (version '3.0.3' currently installed).\n",
      "  df_companies_products.to_excel(save_name, index=False)\n",
      "/var/folders/4p/q7_ch2s94c37xj9l5h3fltgh0000gn/T/ipykernel_44544/269743451.py:4: UserWarning: Pandas requires version '3.0.5' or newer of 'xlsxwriter' (version '3.0.3' currently installed).\n",
      "  df_companies_products.to_excel(save_name, index=False)\n",
      "/var/folders/4p/q7_ch2s94c37xj9l5h3fltgh0000gn/T/ipykernel_44544/269743451.py:4: UserWarning: Pandas requires version '3.0.5' or newer of 'xlsxwriter' (version '3.0.3' currently installed).\n",
      "  df_companies_products.to_excel(save_name, index=False)\n",
      "/var/folders/4p/q7_ch2s94c37xj9l5h3fltgh0000gn/T/ipykernel_44544/269743451.py:4: UserWarning: Pandas requires version '3.0.5' or newer of 'xlsxwriter' (version '3.0.3' currently installed).\n",
      "  df_companies_products.to_excel(save_name, index=False)\n",
      "/var/folders/4p/q7_ch2s94c37xj9l5h3fltgh0000gn/T/ipykernel_44544/269743451.py:4: UserWarning: Pandas requires version '3.0.5' or newer of 'xlsxwriter' (version '3.0.3' currently installed).\n",
      "  df_companies_products.to_excel(save_name, index=False)\n",
      "/var/folders/4p/q7_ch2s94c37xj9l5h3fltgh0000gn/T/ipykernel_44544/269743451.py:4: UserWarning: Pandas requires version '3.0.5' or newer of 'xlsxwriter' (version '3.0.3' currently installed).\n",
      "  df_companies_products.to_excel(save_name, index=False)\n"
     ]
    }
   ],
   "source": [
    "for paths in list_path_cl:\n",
    "    for save_name in list_save_name:\n",
    "        df_companies_products=companies_produduct(paths)\n",
    "        df_companies_products.to_excel(save_name, index=False)\n",
    "\n",
    "    #df_companies_products"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "7924a918",
   "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
}