empresa7.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "IMPORTAR TABELA"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>27499607</th>\n",
       "      <th>POLISERV MAQUINAS E EQUIPAMENTOS PARA ESCRITORIO LTDA</th>\n",
       "      <th>2062</th>\n",
       "      <th>49</th>\n",
       "      <th>0,00</th>\n",
       "      <th>01</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>27499608</td>\n",
       "      <td>ROSEMARA ANCELMO TIBURCIO DA SILVA 28813739842</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>15000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>27499609</td>\n",
       "      <td>ISMAEL COELHO DOS SANTOS 03077315297</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>27499610</td>\n",
       "      <td>LUCINETE RODRIGUES TAVARES 83022449100</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>20000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>27499611</td>\n",
       "      <td>MARCOS VINICIUS DOS SANTOS MIRANDA 05204479996</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>9000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>27499612</td>\n",
       "      <td>LUIS ANTONIO CAMARGO COSTA 41920658866</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>10000,00</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>4494854</th>\n",
       "      <td>32066825</td>\n",
       "      <td>V. A. CABRAL DOS SANTOS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>97000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494855</th>\n",
       "      <td>32066826</td>\n",
       "      <td>ITA ESTRUTURAS E REFORMAS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>30000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494856</th>\n",
       "      <td>32066827</td>\n",
       "      <td>D. F. DE LIMA SANTORO - ARQUITETURA</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>10000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494857</th>\n",
       "      <td>32066828</td>\n",
       "      <td>VIRGINIA OLIVEIRA CARDOSO 05579649622</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494858</th>\n",
       "      <td>32066829</td>\n",
       "      <td>KARINA CRISTINA BARROS KRETZSCHMAR 22543951814</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4494859 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         27499607 POLISERV MAQUINAS E EQUIPAMENTOS PARA ESCRITORIO LTDA  2062  \\\n",
       "0        27499608     ROSEMARA ANCELMO TIBURCIO DA SILVA 28813739842     2135   \n",
       "1        27499609               ISMAEL COELHO DOS SANTOS 03077315297     2135   \n",
       "2        27499610             LUCINETE RODRIGUES TAVARES 83022449100     2135   \n",
       "3        27499611     MARCOS VINICIUS DOS SANTOS MIRANDA 05204479996     2135   \n",
       "4        27499612             LUIS ANTONIO CAMARGO COSTA 41920658866     2135   \n",
       "...           ...                                                ...      ...   \n",
       "4494854  32066825                       V. A. CABRAL DOS SANTOS LTDA     2062   \n",
       "4494855  32066826                     ITA ESTRUTURAS E REFORMAS LTDA     2062   \n",
       "4494856  32066827                D. F. DE LIMA SANTORO - ARQUITETURA     2135   \n",
       "4494857  32066828              VIRGINIA OLIVEIRA CARDOSO 05579649622     2135   \n",
       "4494858  32066829     KARINA CRISTINA BARROS KRETZSCHMAR 22543951814     2135   \n",
       "\n",
       "         49      0,00   01 Unnamed: 6  \n",
       "0        50  15000,00  1.0        NaN  \n",
       "1        50   1000,00  1.0        NaN  \n",
       "2        50  20000,00  1.0        NaN  \n",
       "3        50   9000,00  1.0        NaN  \n",
       "4        50  10000,00  1.0        NaN  \n",
       "...      ..       ...  ...        ...  \n",
       "4494854  49  97000,00  1.0        NaN  \n",
       "4494855  49  30000,00  1.0        NaN  \n",
       "4494856  50  10000,00  1.0        NaN  \n",
       "4494857  50      1,00  1.0        NaN  \n",
       "4494858  50   1000,00  1.0        NaN  \n",
       "\n",
       "[4494859 rows x 7 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('empresa7.CSV', encoding='LATIN-1', sep=';')\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "ELIMINAR HEAD (CABEÇALHO)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>27499607</td>\n",
       "      <td>POLISERV MAQUINAS E EQUIPAMENTOS PARA ESCRITOR...</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>0,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>27499608</td>\n",
       "      <td>ROSEMARA ANCELMO TIBURCIO DA SILVA 28813739842</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>15000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>27499609</td>\n",
       "      <td>ISMAEL COELHO DOS SANTOS 03077315297</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>27499610</td>\n",
       "      <td>LUCINETE RODRIGUES TAVARES 83022449100</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>20000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>27499611</td>\n",
       "      <td>MARCOS VINICIUS DOS SANTOS MIRANDA 05204479996</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>9000,00</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>4494855</th>\n",
       "      <td>32066825</td>\n",
       "      <td>V. A. CABRAL DOS SANTOS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>97000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494856</th>\n",
       "      <td>32066826</td>\n",
       "      <td>ITA ESTRUTURAS E REFORMAS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>30000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494857</th>\n",
       "      <td>32066827</td>\n",
       "      <td>D. F. DE LIMA SANTORO - ARQUITETURA</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>10000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494858</th>\n",
       "      <td>32066828</td>\n",
       "      <td>VIRGINIA OLIVEIRA CARDOSO 05579649622</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494859</th>\n",
       "      <td>32066829</td>\n",
       "      <td>KARINA CRISTINA BARROS KRETZSCHMAR 22543951814</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4494860 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                0                                                  1     2  \\\n",
       "0        27499607  POLISERV MAQUINAS E EQUIPAMENTOS PARA ESCRITOR...  2062   \n",
       "1        27499608     ROSEMARA ANCELMO TIBURCIO DA SILVA 28813739842  2135   \n",
       "2        27499609               ISMAEL COELHO DOS SANTOS 03077315297  2135   \n",
       "3        27499610             LUCINETE RODRIGUES TAVARES 83022449100  2135   \n",
       "4        27499611     MARCOS VINICIUS DOS SANTOS MIRANDA 05204479996  2135   \n",
       "...           ...                                                ...   ...   \n",
       "4494855  32066825                       V. A. CABRAL DOS SANTOS LTDA  2062   \n",
       "4494856  32066826                     ITA ESTRUTURAS E REFORMAS LTDA  2062   \n",
       "4494857  32066827                D. F. DE LIMA SANTORO - ARQUITETURA  2135   \n",
       "4494858  32066828              VIRGINIA OLIVEIRA CARDOSO 05579649622  2135   \n",
       "4494859  32066829     KARINA CRISTINA BARROS KRETZSCHMAR 22543951814  2135   \n",
       "\n",
       "          3         4    5    6  \n",
       "0        49      0,00  1.0  NaN  \n",
       "1        50  15000,00  1.0  NaN  \n",
       "2        50   1000,00  1.0  NaN  \n",
       "3        50  20000,00  1.0  NaN  \n",
       "4        50   9000,00  1.0  NaN  \n",
       "...      ..       ...  ...  ...  \n",
       "4494855  49  97000,00  1.0  NaN  \n",
       "4494856  49  30000,00  1.0  NaN  \n",
       "4494857  50  10000,00  1.0  NaN  \n",
       "4494858  50      1,00  1.0  NaN  \n",
       "4494859  50   1000,00  1.0  NaN  \n",
       "\n",
       "[4494860 rows x 7 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('empresa7.CSV', encoding='LATIN-1', sep=';', header=None)\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "INSERIR HEAD (CABAÇALHO)"
   ]
  },
  {
   "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>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>27499607</td>\n",
       "      <td>POLISERV MAQUINAS E EQUIPAMENTOS PARA ESCRITOR...</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>0,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>27499608</td>\n",
       "      <td>ROSEMARA ANCELMO TIBURCIO DA SILVA 28813739842</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>15000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>27499609</td>\n",
       "      <td>ISMAEL COELHO DOS SANTOS 03077315297</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>27499610</td>\n",
       "      <td>LUCINETE RODRIGUES TAVARES 83022449100</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>20000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>27499611</td>\n",
       "      <td>MARCOS VINICIUS DOS SANTOS MIRANDA 05204479996</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>9000,00</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>4494855</th>\n",
       "      <td>32066825</td>\n",
       "      <td>V. A. CABRAL DOS SANTOS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>97000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494856</th>\n",
       "      <td>32066826</td>\n",
       "      <td>ITA ESTRUTURAS E REFORMAS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>30000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494857</th>\n",
       "      <td>32066827</td>\n",
       "      <td>D. F. DE LIMA SANTORO - ARQUITETURA</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>10000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494858</th>\n",
       "      <td>32066828</td>\n",
       "      <td>VIRGINIA OLIVEIRA CARDOSO 05579649622</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494859</th>\n",
       "      <td>32066829</td>\n",
       "      <td>KARINA CRISTINA BARROS KRETZSCHMAR 22543951814</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4494860 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ                          INDEFICADOR MATRIZ/FILIAL  \\\n",
       "0        27499607  POLISERV MAQUINAS E EQUIPAMENTOS PARA ESCRITOR...   \n",
       "1        27499608     ROSEMARA ANCELMO TIBURCIO DA SILVA 28813739842   \n",
       "2        27499609               ISMAEL COELHO DOS SANTOS 03077315297   \n",
       "3        27499610             LUCINETE RODRIGUES TAVARES 83022449100   \n",
       "4        27499611     MARCOS VINICIUS DOS SANTOS MIRANDA 05204479996   \n",
       "...           ...                                                ...   \n",
       "4494855  32066825                       V. A. CABRAL DOS SANTOS LTDA   \n",
       "4494856  32066826                     ITA ESTRUTURAS E REFORMAS LTDA   \n",
       "4494857  32066827                D. F. DE LIMA SANTORO - ARQUITETURA   \n",
       "4494858  32066828              VIRGINIA OLIVEIRA CARDOSO 05579649622   \n",
       "4494859  32066829     KARINA CRISTINA BARROS KRETZSCHMAR 22543951814   \n",
       "\n",
       "         RAZÃO SOCIAL  NOME FANTASIA SITUAÇÃO CADASTRAL  \\\n",
       "0                2062             49               0,00   \n",
       "1                2135             50           15000,00   \n",
       "2                2135             50            1000,00   \n",
       "3                2135             50           20000,00   \n",
       "4                2135             50            9000,00   \n",
       "...               ...            ...                ...   \n",
       "4494855          2062             49           97000,00   \n",
       "4494856          2062             49           30000,00   \n",
       "4494857          2135             50           10000,00   \n",
       "4494858          2135             50               1,00   \n",
       "4494859          2135             50            1000,00   \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",
       "4494855                      1.0     NaN  \n",
       "4494856                      1.0     NaN  \n",
       "4494857                      1.0     NaN  \n",
       "4494858                      1.0     NaN  \n",
       "4494859                      1.0     NaN  \n",
       "\n",
       "[4494860 rows x 7 columns]"
      ]
     },
     "execution_count": 4,
     "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": 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>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>27499607</td>\n",
       "      <td>POLISERV MAQUINAS E EQUIPAMENTOS PARA ESCRITOR...</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>0,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>27499608</td>\n",
       "      <td>ROSEMARA ANCELMO TIBURCIO DA SILVA 28813739842</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>15000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>27499609</td>\n",
       "      <td>ISMAEL COELHO DOS SANTOS 03077315297</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>27499610</td>\n",
       "      <td>LUCINETE RODRIGUES TAVARES 83022449100</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>20000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>27499611</td>\n",
       "      <td>MARCOS VINICIUS DOS SANTOS MIRANDA 05204479996</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>9000,00</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>4494854</th>\n",
       "      <td>32066824</td>\n",
       "      <td>32.066.824 MAIZA BARBOSA SANTANA</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>5000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494855</th>\n",
       "      <td>32066825</td>\n",
       "      <td>V. A. CABRAL DOS SANTOS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>97000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494856</th>\n",
       "      <td>32066826</td>\n",
       "      <td>ITA ESTRUTURAS E REFORMAS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>30000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494857</th>\n",
       "      <td>32066827</td>\n",
       "      <td>D. F. DE LIMA SANTORO - ARQUITETURA</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>10000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494858</th>\n",
       "      <td>32066828</td>\n",
       "      <td>VIRGINIA OLIVEIRA CARDOSO 05579649622</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4494859 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ                          INDEFICADOR MATRIZ/FILIAL  \\\n",
       "0        27499607  POLISERV MAQUINAS E EQUIPAMENTOS PARA ESCRITOR...   \n",
       "1        27499608     ROSEMARA ANCELMO TIBURCIO DA SILVA 28813739842   \n",
       "2        27499609               ISMAEL COELHO DOS SANTOS 03077315297   \n",
       "3        27499610             LUCINETE RODRIGUES TAVARES 83022449100   \n",
       "4        27499611     MARCOS VINICIUS DOS SANTOS MIRANDA 05204479996   \n",
       "...           ...                                                ...   \n",
       "4494854  32066824                   32.066.824 MAIZA BARBOSA SANTANA   \n",
       "4494855  32066825                       V. A. CABRAL DOS SANTOS LTDA   \n",
       "4494856  32066826                     ITA ESTRUTURAS E REFORMAS LTDA   \n",
       "4494857  32066827                D. F. DE LIMA SANTORO - ARQUITETURA   \n",
       "4494858  32066828              VIRGINIA OLIVEIRA CARDOSO 05579649622   \n",
       "\n",
       "         RAZÃO SOCIAL  NOME FANTASIA SITUAÇÃO CADASTRAL  \\\n",
       "0                2062             49               0,00   \n",
       "1                2135             50           15000,00   \n",
       "2                2135             50            1000,00   \n",
       "3                2135             50           20000,00   \n",
       "4                2135             50            9000,00   \n",
       "...               ...            ...                ...   \n",
       "4494854          2135             50            5000,00   \n",
       "4494855          2062             49           97000,00   \n",
       "4494856          2062             49           30000,00   \n",
       "4494857          2135             50           10000,00   \n",
       "4494858          2135             50               1,00   \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",
       "4494854                      1.0     NaN  \n",
       "4494855                      1.0     NaN  \n",
       "4494856                      1.0     NaN  \n",
       "4494857                      1.0     NaN  \n",
       "4494858                      1.0     NaN  \n",
       "\n",
       "[4494859 rows x 7 columns]"
      ]
     },
     "execution_count": 5,
     "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": 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>27499607</td>\n",
       "      <td>POLISERV MAQUINAS E EQUIPAMENTOS PARA ESCRITOR...</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>0,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>27499608</td>\n",
       "      <td>ROSEMARA ANCELMO TIBURCIO DA SILVA 28813739842</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>15000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>27499609</td>\n",
       "      <td>ISMAEL COELHO DOS SANTOS 03077315297</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>27499610</td>\n",
       "      <td>LUCINETE RODRIGUES TAVARES 83022449100</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>20000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>27499611</td>\n",
       "      <td>MARCOS VINICIUS DOS SANTOS MIRANDA 05204479996</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>9000,00</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>4494854</th>\n",
       "      <td>32066824</td>\n",
       "      <td>32.066.824 MAIZA BARBOSA SANTANA</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>5000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494855</th>\n",
       "      <td>32066825</td>\n",
       "      <td>V. A. CABRAL DOS SANTOS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>97000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494856</th>\n",
       "      <td>32066826</td>\n",
       "      <td>ITA ESTRUTURAS E REFORMAS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>30000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494857</th>\n",
       "      <td>32066827</td>\n",
       "      <td>D. F. DE LIMA SANTORO - ARQUITETURA</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>10000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494858</th>\n",
       "      <td>32066828</td>\n",
       "      <td>VIRGINIA OLIVEIRA CARDOSO 05579649622</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4494859 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ                          INDEFICADOR MATRIZ/FILIAL  \\\n",
       "0        27499607  POLISERV MAQUINAS E EQUIPAMENTOS PARA ESCRITOR...   \n",
       "1        27499608     ROSEMARA ANCELMO TIBURCIO DA SILVA 28813739842   \n",
       "2        27499609               ISMAEL COELHO DOS SANTOS 03077315297   \n",
       "3        27499610             LUCINETE RODRIGUES TAVARES 83022449100   \n",
       "4        27499611     MARCOS VINICIUS DOS SANTOS MIRANDA 05204479996   \n",
       "...           ...                                                ...   \n",
       "4494854  32066824                   32.066.824 MAIZA BARBOSA SANTANA   \n",
       "4494855  32066825                       V. A. CABRAL DOS SANTOS LTDA   \n",
       "4494856  32066826                     ITA ESTRUTURAS E REFORMAS LTDA   \n",
       "4494857  32066827                D. F. DE LIMA SANTORO - ARQUITETURA   \n",
       "4494858  32066828              VIRGINIA OLIVEIRA CARDOSO 05579649622   \n",
       "\n",
       "         RAZÃO SOCIAL  NOME FANTASIA SITUAÇÃO CADASTRAL  \\\n",
       "0                2062             49               0,00   \n",
       "1                2135             50           15000,00   \n",
       "2                2135             50            1000,00   \n",
       "3                2135             50           20000,00   \n",
       "4                2135             50            9000,00   \n",
       "...               ...            ...                ...   \n",
       "4494854          2135             50            5000,00   \n",
       "4494855          2062             49           97000,00   \n",
       "4494856          2062             49           30000,00   \n",
       "4494857          2135             50           10000,00   \n",
       "4494858          2135             50               1,00   \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",
       "4494854                      1.0     NaN  \n",
       "4494855                      1.0     NaN  \n",
       "4494856                      1.0     NaN  \n",
       "4494857                      1.0     NaN  \n",
       "4494858                      1.0     NaN  \n",
       "\n",
       "[4494859 rows x 7 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.to_csv('n_empresa7.csv', index=False)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "ename": "ValueError",
     "evalue": "This sheet is too large! Your sheet size is: 4494859, 7 Max sheet size is: 1048576, 16384",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mValueError\u001b[0m                                Traceback (most recent call last)",
      "Cell \u001b[1;32mIn[7], line 1\u001b[0m\n\u001b[1;32m----> 1\u001b[0m \u001b[43mdf\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mto_excel\u001b[49m\u001b[43m(\u001b[49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[38;5;124;43mn_empresa7.xlsx\u001b[39;49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mindex\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[38;5;28;43;01mFalse\u001b[39;49;00m\u001b[43m)\u001b[49m\n\u001b[0;32m      2\u001b[0m df\n",
      "File \u001b[1;32me:\\TRABALHO\\pandas\\venv\\Lib\\site-packages\\pandas\\util\\_decorators.py:333\u001b[0m, in \u001b[0;36mdeprecate_nonkeyword_arguments.<locals>.decorate.<locals>.wrapper\u001b[1;34m(*args, **kwargs)\u001b[0m\n\u001b[0;32m    327\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;28mlen\u001b[39m(args) \u001b[38;5;241m>\u001b[39m num_allow_args:\n\u001b[0;32m    328\u001b[0m     warnings\u001b[38;5;241m.\u001b[39mwarn(\n\u001b[0;32m    329\u001b[0m         msg\u001b[38;5;241m.\u001b[39mformat(arguments\u001b[38;5;241m=\u001b[39m_format_argument_list(allow_args)),\n\u001b[0;32m    330\u001b[0m         \u001b[38;5;167;01mFutureWarning\u001b[39;00m,\n\u001b[0;32m    331\u001b[0m         stacklevel\u001b[38;5;241m=\u001b[39mfind_stack_level(),\n\u001b[0;32m    332\u001b[0m     )\n\u001b[1;32m--> 333\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[43mfunc\u001b[49m\u001b[43m(\u001b[49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[43margs\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[43mkwargs\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[1;32me:\\TRABALHO\\pandas\\venv\\Lib\\site-packages\\pandas\\core\\generic.py:2417\u001b[0m, in \u001b[0;36mNDFrame.to_excel\u001b[1;34m(self, excel_writer, sheet_name, na_rep, float_format, columns, header, index, index_label, startrow, startcol, engine, merge_cells, inf_rep, freeze_panes, storage_options, engine_kwargs)\u001b[0m\n\u001b[0;32m   2404\u001b[0m \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01mpandas\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mio\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mformats\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mexcel\u001b[39;00m \u001b[38;5;28;01mimport\u001b[39;00m ExcelFormatter\n\u001b[0;32m   2406\u001b[0m formatter \u001b[38;5;241m=\u001b[39m ExcelFormatter(\n\u001b[0;32m   2407\u001b[0m     df,\n\u001b[0;32m   2408\u001b[0m     na_rep\u001b[38;5;241m=\u001b[39mna_rep,\n\u001b[1;32m   (...)\u001b[0m\n\u001b[0;32m   2415\u001b[0m     inf_rep\u001b[38;5;241m=\u001b[39minf_rep,\n\u001b[0;32m   2416\u001b[0m )\n\u001b[1;32m-> 2417\u001b[0m \u001b[43mformatter\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mwrite\u001b[49m\u001b[43m(\u001b[49m\n\u001b[0;32m   2418\u001b[0m \u001b[43m    \u001b[49m\u001b[43mexcel_writer\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m   2419\u001b[0m \u001b[43m    \u001b[49m\u001b[43msheet_name\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43msheet_name\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m   2420\u001b[0m \u001b[43m    \u001b[49m\u001b[43mstartrow\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mstartrow\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m   2421\u001b[0m \u001b[43m    \u001b[49m\u001b[43mstartcol\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mstartcol\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m   2422\u001b[0m \u001b[43m    \u001b[49m\u001b[43mfreeze_panes\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mfreeze_panes\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m   2423\u001b[0m \u001b[43m    \u001b[49m\u001b[43mengine\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mengine\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m   2424\u001b[0m \u001b[43m    \u001b[49m\u001b[43mstorage_options\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mstorage_options\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m   2425\u001b[0m \u001b[43m    \u001b[49m\u001b[43mengine_kwargs\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mengine_kwargs\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m   2426\u001b[0m \u001b[43m\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[1;32me:\\TRABALHO\\pandas\\venv\\Lib\\site-packages\\pandas\\io\\formats\\excel.py:931\u001b[0m, in \u001b[0;36mExcelFormatter.write\u001b[1;34m(self, writer, sheet_name, startrow, startcol, freeze_panes, engine, storage_options, engine_kwargs)\u001b[0m\n\u001b[0;32m    929\u001b[0m num_rows, num_cols \u001b[38;5;241m=\u001b[39m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mdf\u001b[38;5;241m.\u001b[39mshape\n\u001b[0;32m    930\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m num_rows \u001b[38;5;241m>\u001b[39m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mmax_rows \u001b[38;5;129;01mor\u001b[39;00m num_cols \u001b[38;5;241m>\u001b[39m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mmax_cols:\n\u001b[1;32m--> 931\u001b[0m     \u001b[38;5;28;01mraise\u001b[39;00m \u001b[38;5;167;01mValueError\u001b[39;00m(\n\u001b[0;32m    932\u001b[0m         \u001b[38;5;124mf\u001b[39m\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mThis sheet is too large! Your sheet size is: \u001b[39m\u001b[38;5;132;01m{\u001b[39;00mnum_rows\u001b[38;5;132;01m}\u001b[39;00m\u001b[38;5;124m, \u001b[39m\u001b[38;5;132;01m{\u001b[39;00mnum_cols\u001b[38;5;132;01m}\u001b[39;00m\u001b[38;5;124m \u001b[39m\u001b[38;5;124m\"\u001b[39m\n\u001b[0;32m    933\u001b[0m         \u001b[38;5;124mf\u001b[39m\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mMax sheet size is: \u001b[39m\u001b[38;5;132;01m{\u001b[39;00m\u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mmax_rows\u001b[38;5;132;01m}\u001b[39;00m\u001b[38;5;124m, \u001b[39m\u001b[38;5;132;01m{\u001b[39;00m\u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mmax_cols\u001b[38;5;132;01m}\u001b[39;00m\u001b[38;5;124m\"\u001b[39m\n\u001b[0;32m    934\u001b[0m     )\n\u001b[0;32m    936\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m engine_kwargs \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m:\n\u001b[0;32m    937\u001b[0m     engine_kwargs \u001b[38;5;241m=\u001b[39m {}\n",
      "\u001b[1;31mValueError\u001b[0m: This sheet is too large! Your sheet size is: 4494859, 7 Max sheet size is: 1048576, 16384"
     ]
    }
   ],
   "source": [
    "df.to_excel('n_empresa7.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
}