empresa3.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "IMPORTAR TABELA"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>9253555</th>\n",
       "      <th>FRANCISCO ENIVALDO RODRIGUES DE OLIVEIRA</th>\n",
       "      <th>2135</th>\n",
       "      <th>50</th>\n",
       "      <th>30000</th>\n",
       "      <th>1</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9253556</td>\n",
       "      <td>BORGES E PIRETT LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>20000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>9253557</td>\n",
       "      <td>FARMACIA E DROGARIA PLUS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>100000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>9253558</td>\n",
       "      <td>EMBALAGENS VIVETO LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>15000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>9253559</td>\n",
       "      <td>DISTRIBUIDORA RICHTER LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>5</td>\n",
       "      <td>33000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>9253560</td>\n",
       "      <td>L.M. AMARAL DA SILVA &amp; CIA.LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>1000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048570</th>\n",
       "      <td>10351718</td>\n",
       "      <td>TECEDOR &amp; DOMINGOS REPRESENTACOES COMERCIAIS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>5000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048571</th>\n",
       "      <td>10351719</td>\n",
       "      <td>TREVISO &amp; TREVISO LTDA.</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>30000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>10351720</td>\n",
       "      <td>INES FERREIRA DA ROCHA MACHADO</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>10000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>10351721</td>\n",
       "      <td>C D F CONSULTORIA EM GESTAO EMPRESARIAL UNIPES...</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>1000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>10351722</td>\n",
       "      <td>KESSIA CRISTINA OLIVEIRA DA SILVA</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>20000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1048575 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          9253555           FRANCISCO ENIVALDO RODRIGUES DE OLIVEIRA  2135  \\\n",
       "0         9253556                               BORGES E PIRETT LTDA  2062   \n",
       "1         9253557                      FARMACIA E DROGARIA PLUS LTDA  2062   \n",
       "2         9253558                             EMBALAGENS VIVETO LTDA  2062   \n",
       "3         9253559                         DISTRIBUIDORA RICHTER LTDA  2062   \n",
       "4         9253560                    L.M. AMARAL DA SILVA & CIA.LTDA  2062   \n",
       "...           ...                                                ...   ...   \n",
       "1048570  10351718  TECEDOR & DOMINGOS REPRESENTACOES COMERCIAIS LTDA  2062   \n",
       "1048571  10351719                            TREVISO & TREVISO LTDA.  2062   \n",
       "1048572  10351720                     INES FERREIRA DA ROCHA MACHADO  2135   \n",
       "1048573  10351721  C D F CONSULTORIA EM GESTAO EMPRESARIAL UNIPES...  2062   \n",
       "1048574  10351722                  KESSIA CRISTINA OLIVEIRA DA SILVA  2135   \n",
       "\n",
       "         50    30000    1 Unnamed: 6  \n",
       "0        49    20000  1.0        NaN  \n",
       "1        49   100000  1.0        NaN  \n",
       "2        49    15000  1.0        NaN  \n",
       "3         5    33000  1.0        NaN  \n",
       "4        49     1000  1.0        NaN  \n",
       "...      ..      ...  ...        ...  \n",
       "1048570  49     5000  1.0        NaN  \n",
       "1048571  49    30000  1.0        NaN  \n",
       "1048572  50    10000  1.0        NaN  \n",
       "1048573  49  1000000  1.0        NaN  \n",
       "1048574  50    20000  1.0        NaN  \n",
       "\n",
       "[1048575 rows x 7 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('empresa3.csv', encoding = 'latin-1', sep = ';')\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "ELIMINAR O HEAD (CABEÇALHO)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9253555</td>\n",
       "      <td>FRANCISCO ENIVALDO RODRIGUES DE OLIVEIRA</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>30000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>9253556</td>\n",
       "      <td>BORGES E PIRETT LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>20000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>9253557</td>\n",
       "      <td>FARMACIA E DROGARIA PLUS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>100000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>9253558</td>\n",
       "      <td>EMBALAGENS VIVETO LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>15000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>9253559</td>\n",
       "      <td>DISTRIBUIDORA RICHTER LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>5</td>\n",
       "      <td>33000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048571</th>\n",
       "      <td>10351718</td>\n",
       "      <td>TECEDOR &amp; DOMINGOS REPRESENTACOES COMERCIAIS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>5000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>10351719</td>\n",
       "      <td>TREVISO &amp; TREVISO LTDA.</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>30000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>10351720</td>\n",
       "      <td>INES FERREIRA DA ROCHA MACHADO</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>10000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>10351721</td>\n",
       "      <td>C D F CONSULTORIA EM GESTAO EMPRESARIAL UNIPES...</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>1000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048575</th>\n",
       "      <td>10351722</td>\n",
       "      <td>KESSIA CRISTINA OLIVEIRA DA SILVA</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>20000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1048576 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                0                                                  1     2  \\\n",
       "0         9253555           FRANCISCO ENIVALDO RODRIGUES DE OLIVEIRA  2135   \n",
       "1         9253556                               BORGES E PIRETT LTDA  2062   \n",
       "2         9253557                      FARMACIA E DROGARIA PLUS LTDA  2062   \n",
       "3         9253558                             EMBALAGENS VIVETO LTDA  2062   \n",
       "4         9253559                         DISTRIBUIDORA RICHTER LTDA  2062   \n",
       "...           ...                                                ...   ...   \n",
       "1048571  10351718  TECEDOR & DOMINGOS REPRESENTACOES COMERCIAIS LTDA  2062   \n",
       "1048572  10351719                            TREVISO & TREVISO LTDA.  2062   \n",
       "1048573  10351720                     INES FERREIRA DA ROCHA MACHADO  2135   \n",
       "1048574  10351721  C D F CONSULTORIA EM GESTAO EMPRESARIAL UNIPES...  2062   \n",
       "1048575  10351722                  KESSIA CRISTINA OLIVEIRA DA SILVA  2135   \n",
       "\n",
       "          3        4    5    6  \n",
       "0        50    30000  1.0  NaN  \n",
       "1        49    20000  1.0  NaN  \n",
       "2        49   100000  1.0  NaN  \n",
       "3        49    15000  1.0  NaN  \n",
       "4         5    33000  1.0  NaN  \n",
       "...      ..      ...  ...  ...  \n",
       "1048571  49     5000  1.0  NaN  \n",
       "1048572  49    30000  1.0  NaN  \n",
       "1048573  50    10000  1.0  NaN  \n",
       "1048574  49  1000000  1.0  NaN  \n",
       "1048575  50    20000  1.0  NaN  \n",
       "\n",
       "[1048576 rows x 7 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('empresa3.CSV', encoding = 'latin-1', sep = ';', header=None)\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "INSERIR HEAD (CABEÇALHO)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CNPJ</th>\n",
       "      <th>INDEFICADOR MATRIZ/FILIAL</th>\n",
       "      <th>RAZÃO SOCIAL</th>\n",
       "      <th>NOME FANTASIA</th>\n",
       "      <th>SITUAÇÃO CADASTRAL</th>\n",
       "      <th>DATA SITUAÇÃO CADASTRAL</th>\n",
       "      <th>CO-PAÍS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9253555</td>\n",
       "      <td>FRANCISCO ENIVALDO RODRIGUES DE OLIVEIRA</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>30000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>9253556</td>\n",
       "      <td>BORGES E PIRETT LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>20000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>9253557</td>\n",
       "      <td>FARMACIA E DROGARIA PLUS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>100000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>9253558</td>\n",
       "      <td>EMBALAGENS VIVETO LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>15000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>9253559</td>\n",
       "      <td>DISTRIBUIDORA RICHTER LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>5</td>\n",
       "      <td>33000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048571</th>\n",
       "      <td>10351718</td>\n",
       "      <td>TECEDOR &amp; DOMINGOS REPRESENTACOES COMERCIAIS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>5000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>10351719</td>\n",
       "      <td>TREVISO &amp; TREVISO LTDA.</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>30000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>10351720</td>\n",
       "      <td>INES FERREIRA DA ROCHA MACHADO</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>10000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>10351721</td>\n",
       "      <td>C D F CONSULTORIA EM GESTAO EMPRESARIAL UNIPES...</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>1000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048575</th>\n",
       "      <td>10351722</td>\n",
       "      <td>KESSIA CRISTINA OLIVEIRA DA SILVA</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>20000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1048576 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ                          INDEFICADOR MATRIZ/FILIAL  \\\n",
       "0         9253555           FRANCISCO ENIVALDO RODRIGUES DE OLIVEIRA   \n",
       "1         9253556                               BORGES E PIRETT LTDA   \n",
       "2         9253557                      FARMACIA E DROGARIA PLUS LTDA   \n",
       "3         9253558                             EMBALAGENS VIVETO LTDA   \n",
       "4         9253559                         DISTRIBUIDORA RICHTER LTDA   \n",
       "...           ...                                                ...   \n",
       "1048571  10351718  TECEDOR & DOMINGOS REPRESENTACOES COMERCIAIS LTDA   \n",
       "1048572  10351719                            TREVISO & TREVISO LTDA.   \n",
       "1048573  10351720                     INES FERREIRA DA ROCHA MACHADO   \n",
       "1048574  10351721  C D F CONSULTORIA EM GESTAO EMPRESARIAL UNIPES...   \n",
       "1048575  10351722                  KESSIA CRISTINA OLIVEIRA DA SILVA   \n",
       "\n",
       "         RAZÃO SOCIAL  NOME FANTASIA SITUAÇÃO CADASTRAL  \\\n",
       "0                2135             50              30000   \n",
       "1                2062             49              20000   \n",
       "2                2062             49             100000   \n",
       "3                2062             49              15000   \n",
       "4                2062              5              33000   \n",
       "...               ...            ...                ...   \n",
       "1048571          2062             49               5000   \n",
       "1048572          2062             49              30000   \n",
       "1048573          2135             50              10000   \n",
       "1048574          2062             49            1000000   \n",
       "1048575          2135             50              20000   \n",
       "\n",
       "         DATA SITUAÇÃO CADASTRAL CO-PAÍS  \n",
       "0                            1.0     NaN  \n",
       "1                            1.0     NaN  \n",
       "2                            1.0     NaN  \n",
       "3                            1.0     NaN  \n",
       "4                            1.0     NaN  \n",
       "...                          ...     ...  \n",
       "1048571                      1.0     NaN  \n",
       "1048572                      1.0     NaN  \n",
       "1048573                      1.0     NaN  \n",
       "1048574                      1.0     NaN  \n",
       "1048575                      1.0     NaN  \n",
       "\n",
       "[1048576 rows x 7 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns = ['CNPJ', 'INDEFICADOR MATRIZ/FILIAL', 'RAZÃO SOCIAL', 'NOME FANTASIA', 'SITUAÇÃO CADASTRAL',\n",
    "                    'DATA SITUAÇÃO CADASTRAL', 'CO-PAÍS']\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "ELIMINAR A ÚLTIMA LINHA"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>CNPJ</th>\n",
       "      <th>INDEFICADOR MATRIZ/FILIAL</th>\n",
       "      <th>RAZÃO SOCIAL</th>\n",
       "      <th>NOME FANTASIA</th>\n",
       "      <th>SITUAÇÃO CADASTRAL</th>\n",
       "      <th>DATA SITUAÇÃO CADASTRAL</th>\n",
       "      <th>CO-PAÍS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9253555</td>\n",
       "      <td>FRANCISCO ENIVALDO RODRIGUES DE OLIVEIRA</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>30000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>9253556</td>\n",
       "      <td>BORGES E PIRETT LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>20000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>9253557</td>\n",
       "      <td>FARMACIA E DROGARIA PLUS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>100000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>9253558</td>\n",
       "      <td>EMBALAGENS VIVETO LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>15000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>9253559</td>\n",
       "      <td>DISTRIBUIDORA RICHTER LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>5</td>\n",
       "      <td>33000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048570</th>\n",
       "      <td>10351717</td>\n",
       "      <td>GENEZIO AVELINO CARDOSO</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>4000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048571</th>\n",
       "      <td>10351718</td>\n",
       "      <td>TECEDOR &amp; DOMINGOS REPRESENTACOES COMERCIAIS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>5000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>10351719</td>\n",
       "      <td>TREVISO &amp; TREVISO LTDA.</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>30000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>10351720</td>\n",
       "      <td>INES FERREIRA DA ROCHA MACHADO</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>10000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>10351721</td>\n",
       "      <td>C D F CONSULTORIA EM GESTAO EMPRESARIAL UNIPES...</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>1000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1048575 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ                          INDEFICADOR MATRIZ/FILIAL  \\\n",
       "0         9253555           FRANCISCO ENIVALDO RODRIGUES DE OLIVEIRA   \n",
       "1         9253556                               BORGES E PIRETT LTDA   \n",
       "2         9253557                      FARMACIA E DROGARIA PLUS LTDA   \n",
       "3         9253558                             EMBALAGENS VIVETO LTDA   \n",
       "4         9253559                         DISTRIBUIDORA RICHTER LTDA   \n",
       "...           ...                                                ...   \n",
       "1048570  10351717                            GENEZIO AVELINO CARDOSO   \n",
       "1048571  10351718  TECEDOR & DOMINGOS REPRESENTACOES COMERCIAIS LTDA   \n",
       "1048572  10351719                            TREVISO & TREVISO LTDA.   \n",
       "1048573  10351720                     INES FERREIRA DA ROCHA MACHADO   \n",
       "1048574  10351721  C D F CONSULTORIA EM GESTAO EMPRESARIAL UNIPES...   \n",
       "\n",
       "         RAZÃO SOCIAL  NOME FANTASIA SITUAÇÃO CADASTRAL  \\\n",
       "0                2135             50              30000   \n",
       "1                2062             49              20000   \n",
       "2                2062             49             100000   \n",
       "3                2062             49              15000   \n",
       "4                2062              5              33000   \n",
       "...               ...            ...                ...   \n",
       "1048570          2135             50               4000   \n",
       "1048571          2062             49               5000   \n",
       "1048572          2062             49              30000   \n",
       "1048573          2135             50              10000   \n",
       "1048574          2062             49            1000000   \n",
       "\n",
       "         DATA SITUAÇÃO CADASTRAL CO-PAÍS  \n",
       "0                            1.0     NaN  \n",
       "1                            1.0     NaN  \n",
       "2                            1.0     NaN  \n",
       "3                            1.0     NaN  \n",
       "4                            1.0     NaN  \n",
       "...                          ...     ...  \n",
       "1048570                      1.0     NaN  \n",
       "1048571                      1.0     NaN  \n",
       "1048572                      1.0     NaN  \n",
       "1048573                      1.0     NaN  \n",
       "1048574                      1.0     NaN  \n",
       "\n",
       "[1048575 rows x 7 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.drop(df.tail(1).index, inplace=True)\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "EXPORTAR TABELA:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>CNPJ</th>\n",
       "      <th>INDEFICADOR MATRIZ/FILIAL</th>\n",
       "      <th>RAZÃO SOCIAL</th>\n",
       "      <th>NOME FANTASIA</th>\n",
       "      <th>SITUAÇÃO CADASTRAL</th>\n",
       "      <th>DATA SITUAÇÃO CADASTRAL</th>\n",
       "      <th>CO-PAÍS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9253555</td>\n",
       "      <td>FRANCISCO ENIVALDO RODRIGUES DE OLIVEIRA</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>30000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>9253556</td>\n",
       "      <td>BORGES E PIRETT LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>20000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>9253557</td>\n",
       "      <td>FARMACIA E DROGARIA PLUS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>100000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>9253558</td>\n",
       "      <td>EMBALAGENS VIVETO LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>15000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>9253559</td>\n",
       "      <td>DISTRIBUIDORA RICHTER LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>5</td>\n",
       "      <td>33000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048570</th>\n",
       "      <td>10351717</td>\n",
       "      <td>GENEZIO AVELINO CARDOSO</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>4000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048571</th>\n",
       "      <td>10351718</td>\n",
       "      <td>TECEDOR &amp; DOMINGOS REPRESENTACOES COMERCIAIS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>5000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>10351719</td>\n",
       "      <td>TREVISO &amp; TREVISO LTDA.</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>30000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>10351720</td>\n",
       "      <td>INES FERREIRA DA ROCHA MACHADO</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>10000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>10351721</td>\n",
       "      <td>C D F CONSULTORIA EM GESTAO EMPRESARIAL UNIPES...</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>1000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1048575 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ                          INDEFICADOR MATRIZ/FILIAL  \\\n",
       "0         9253555           FRANCISCO ENIVALDO RODRIGUES DE OLIVEIRA   \n",
       "1         9253556                               BORGES E PIRETT LTDA   \n",
       "2         9253557                      FARMACIA E DROGARIA PLUS LTDA   \n",
       "3         9253558                             EMBALAGENS VIVETO LTDA   \n",
       "4         9253559                         DISTRIBUIDORA RICHTER LTDA   \n",
       "...           ...                                                ...   \n",
       "1048570  10351717                            GENEZIO AVELINO CARDOSO   \n",
       "1048571  10351718  TECEDOR & DOMINGOS REPRESENTACOES COMERCIAIS LTDA   \n",
       "1048572  10351719                            TREVISO & TREVISO LTDA.   \n",
       "1048573  10351720                     INES FERREIRA DA ROCHA MACHADO   \n",
       "1048574  10351721  C D F CONSULTORIA EM GESTAO EMPRESARIAL UNIPES...   \n",
       "\n",
       "         RAZÃO SOCIAL  NOME FANTASIA SITUAÇÃO CADASTRAL  \\\n",
       "0                2135             50              30000   \n",
       "1                2062             49              20000   \n",
       "2                2062             49             100000   \n",
       "3                2062             49              15000   \n",
       "4                2062              5              33000   \n",
       "...               ...            ...                ...   \n",
       "1048570          2135             50               4000   \n",
       "1048571          2062             49               5000   \n",
       "1048572          2062             49              30000   \n",
       "1048573          2135             50              10000   \n",
       "1048574          2062             49            1000000   \n",
       "\n",
       "         DATA SITUAÇÃO CADASTRAL CO-PAÍS  \n",
       "0                            1.0     NaN  \n",
       "1                            1.0     NaN  \n",
       "2                            1.0     NaN  \n",
       "3                            1.0     NaN  \n",
       "4                            1.0     NaN  \n",
       "...                          ...     ...  \n",
       "1048570                      1.0     NaN  \n",
       "1048571                      1.0     NaN  \n",
       "1048572                      1.0     NaN  \n",
       "1048573                      1.0     NaN  \n",
       "1048574                      1.0     NaN  \n",
       "\n",
       "[1048575 rows x 7 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.to_csv('n_empresa3.csv', index=False)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>CNPJ</th>\n",
       "      <th>INDEFICADOR MATRIZ/FILIAL</th>\n",
       "      <th>RAZÃO SOCIAL</th>\n",
       "      <th>NOME FANTASIA</th>\n",
       "      <th>SITUAÇÃO CADASTRAL</th>\n",
       "      <th>DATA SITUAÇÃO CADASTRAL</th>\n",
       "      <th>CO-PAÍS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9253555</td>\n",
       "      <td>FRANCISCO ENIVALDO RODRIGUES DE OLIVEIRA</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>30000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>9253556</td>\n",
       "      <td>BORGES E PIRETT LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>20000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>9253557</td>\n",
       "      <td>FARMACIA E DROGARIA PLUS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>100000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>9253558</td>\n",
       "      <td>EMBALAGENS VIVETO LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>15000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>9253559</td>\n",
       "      <td>DISTRIBUIDORA RICHTER LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>5</td>\n",
       "      <td>33000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048570</th>\n",
       "      <td>10351717</td>\n",
       "      <td>GENEZIO AVELINO CARDOSO</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>4000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048571</th>\n",
       "      <td>10351718</td>\n",
       "      <td>TECEDOR &amp; DOMINGOS REPRESENTACOES COMERCIAIS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>5000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>10351719</td>\n",
       "      <td>TREVISO &amp; TREVISO LTDA.</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>30000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>10351720</td>\n",
       "      <td>INES FERREIRA DA ROCHA MACHADO</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>10000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>10351721</td>\n",
       "      <td>C D F CONSULTORIA EM GESTAO EMPRESARIAL UNIPES...</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>1000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1048575 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ                          INDEFICADOR MATRIZ/FILIAL  \\\n",
       "0         9253555           FRANCISCO ENIVALDO RODRIGUES DE OLIVEIRA   \n",
       "1         9253556                               BORGES E PIRETT LTDA   \n",
       "2         9253557                      FARMACIA E DROGARIA PLUS LTDA   \n",
       "3         9253558                             EMBALAGENS VIVETO LTDA   \n",
       "4         9253559                         DISTRIBUIDORA RICHTER LTDA   \n",
       "...           ...                                                ...   \n",
       "1048570  10351717                            GENEZIO AVELINO CARDOSO   \n",
       "1048571  10351718  TECEDOR & DOMINGOS REPRESENTACOES COMERCIAIS LTDA   \n",
       "1048572  10351719                            TREVISO & TREVISO LTDA.   \n",
       "1048573  10351720                     INES FERREIRA DA ROCHA MACHADO   \n",
       "1048574  10351721  C D F CONSULTORIA EM GESTAO EMPRESARIAL UNIPES...   \n",
       "\n",
       "         RAZÃO SOCIAL  NOME FANTASIA SITUAÇÃO CADASTRAL  \\\n",
       "0                2135             50              30000   \n",
       "1                2062             49              20000   \n",
       "2                2062             49             100000   \n",
       "3                2062             49              15000   \n",
       "4                2062              5              33000   \n",
       "...               ...            ...                ...   \n",
       "1048570          2135             50               4000   \n",
       "1048571          2062             49               5000   \n",
       "1048572          2062             49              30000   \n",
       "1048573          2135             50              10000   \n",
       "1048574          2062             49            1000000   \n",
       "\n",
       "         DATA SITUAÇÃO CADASTRAL CO-PAÍS  \n",
       "0                            1.0     NaN  \n",
       "1                            1.0     NaN  \n",
       "2                            1.0     NaN  \n",
       "3                            1.0     NaN  \n",
       "4                            1.0     NaN  \n",
       "...                          ...     ...  \n",
       "1048570                      1.0     NaN  \n",
       "1048571                      1.0     NaN  \n",
       "1048572                      1.0     NaN  \n",
       "1048573                      1.0     NaN  \n",
       "1048574                      1.0     NaN  \n",
       "\n",
       "[1048575 rows x 7 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.to_excel('n_empresa3.xlsx', index=False)\n",
    "df"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "venv",
   "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.12.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}