empresa8.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>32066830</th>\n",
       "      <th>PASTELLO PASTELARIA GOURMET LTDA</th>\n",
       "      <th>2062</th>\n",
       "      <th>49</th>\n",
       "      <th>5000,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>32066831</td>\n",
       "      <td>PARTIDO REPUBLICANO DA ORDEM SOCIAL - PACATUBA...</td>\n",
       "      <td>3271</td>\n",
       "      <td>16</td>\n",
       "      <td>0,00</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>32066832</td>\n",
       "      <td>JOSE ALIPIO GARCIA GOUVEA - ESPORTES</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>2</th>\n",
       "      <td>32066833</td>\n",
       "      <td>M&amp;M COMERCIO DE PRODUTOS AGROPECUARIOS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>10000,00</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>32066834</td>\n",
       "      <td>ISAIAS RODRIGUES 12415932809</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>4</th>\n",
       "      <td>32066835</td>\n",
       "      <td>JOSE DENNES DOS SANTOS SILVA</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>...</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>36627970</td>\n",
       "      <td>GILVANDERSON SANTOS DA SILVA 45301862880</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>100,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494855</th>\n",
       "      <td>36627971</td>\n",
       "      <td>JONATHAS AUGUSTO DOS SANTOS CAMILO 40993054811</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>3000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494856</th>\n",
       "      <td>36627972</td>\n",
       "      <td>ANGELINA ANTUNES DA LUZ BORGES 87429187900</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>4494857</th>\n",
       "      <td>36627973</td>\n",
       "      <td>ANTONIO PEREIRA ARANTES NETO 01699985170</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>4494858</th>\n",
       "      <td>36627975</td>\n",
       "      <td>MICHELI PINHEIRO FLOR 06035748902</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": [
       "         32066830                   PASTELLO PASTELARIA GOURMET LTDA  2062  \\\n",
       "0        32066831  PARTIDO REPUBLICANO DA ORDEM SOCIAL - PACATUBA...  3271   \n",
       "1        32066832               JOSE ALIPIO GARCIA GOUVEA - ESPORTES  2135   \n",
       "2        32066833        M&M COMERCIO DE PRODUTOS AGROPECUARIOS LTDA  2062   \n",
       "3        32066834                       ISAIAS RODRIGUES 12415932809  2135   \n",
       "4        32066835                       JOSE DENNES DOS SANTOS SILVA  2135   \n",
       "...           ...                                                ...   ...   \n",
       "4494854  36627970           GILVANDERSON SANTOS DA SILVA 45301862880  2135   \n",
       "4494855  36627971     JONATHAS AUGUSTO DOS SANTOS CAMILO 40993054811  2135   \n",
       "4494856  36627972         ANGELINA ANTUNES DA LUZ BORGES 87429187900  2135   \n",
       "4494857  36627973           ANTONIO PEREIRA ARANTES NETO 01699985170  2135   \n",
       "4494858  36627975                  MICHELI PINHEIRO FLOR 06035748902  2135   \n",
       "\n",
       "         49   5000,00   01 Unnamed: 6  \n",
       "0        16      0,00  5.0        NaN  \n",
       "1        50  10000,00  1.0        NaN  \n",
       "2        49  10000,00  3.0        NaN  \n",
       "3        50   5000,00  1.0        NaN  \n",
       "4        50   1000,00  1.0        NaN  \n",
       "...      ..       ...  ...        ...  \n",
       "4494854  50    100,00  1.0        NaN  \n",
       "4494855  50   3000,00  1.0        NaN  \n",
       "4494856  50   1000,00  1.0        NaN  \n",
       "4494857  50   1000,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('empresa8.CSV', encoding='LATIN-1', sep=';')\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "ELIMINAR HEAD"
   ]
  },
  {
   "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>32066830</td>\n",
       "      <td>PASTELLO PASTELARIA GOURMET LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>5000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>32066831</td>\n",
       "      <td>PARTIDO REPUBLICANO DA ORDEM SOCIAL - PACATUBA...</td>\n",
       "      <td>3271</td>\n",
       "      <td>16</td>\n",
       "      <td>0,00</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>32066832</td>\n",
       "      <td>JOSE ALIPIO GARCIA GOUVEA - ESPORTES</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>3</th>\n",
       "      <td>32066833</td>\n",
       "      <td>M&amp;M COMERCIO DE PRODUTOS AGROPECUARIOS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>10000,00</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>32066834</td>\n",
       "      <td>ISAIAS RODRIGUES 12415932809</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>...</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>36627970</td>\n",
       "      <td>GILVANDERSON SANTOS DA SILVA 45301862880</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>100,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494856</th>\n",
       "      <td>36627971</td>\n",
       "      <td>JONATHAS AUGUSTO DOS SANTOS CAMILO 40993054811</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>3000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494857</th>\n",
       "      <td>36627972</td>\n",
       "      <td>ANGELINA ANTUNES DA LUZ BORGES 87429187900</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>4494858</th>\n",
       "      <td>36627973</td>\n",
       "      <td>ANTONIO PEREIRA ARANTES NETO 01699985170</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>4494859</th>\n",
       "      <td>36627975</td>\n",
       "      <td>MICHELI PINHEIRO FLOR 06035748902</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        32066830                   PASTELLO PASTELARIA GOURMET LTDA  2062   \n",
       "1        32066831  PARTIDO REPUBLICANO DA ORDEM SOCIAL - PACATUBA...  3271   \n",
       "2        32066832               JOSE ALIPIO GARCIA GOUVEA - ESPORTES  2135   \n",
       "3        32066833        M&M COMERCIO DE PRODUTOS AGROPECUARIOS LTDA  2062   \n",
       "4        32066834                       ISAIAS RODRIGUES 12415932809  2135   \n",
       "...           ...                                                ...   ...   \n",
       "4494855  36627970           GILVANDERSON SANTOS DA SILVA 45301862880  2135   \n",
       "4494856  36627971     JONATHAS AUGUSTO DOS SANTOS CAMILO 40993054811  2135   \n",
       "4494857  36627972         ANGELINA ANTUNES DA LUZ BORGES 87429187900  2135   \n",
       "4494858  36627973           ANTONIO PEREIRA ARANTES NETO 01699985170  2135   \n",
       "4494859  36627975                  MICHELI PINHEIRO FLOR 06035748902  2135   \n",
       "\n",
       "          3         4    5    6  \n",
       "0        49   5000,00  1.0  NaN  \n",
       "1        16      0,00  5.0  NaN  \n",
       "2        50  10000,00  1.0  NaN  \n",
       "3        49  10000,00  3.0  NaN  \n",
       "4        50   5000,00  1.0  NaN  \n",
       "...      ..       ...  ...  ...  \n",
       "4494855  50    100,00  1.0  NaN  \n",
       "4494856  50   3000,00  1.0  NaN  \n",
       "4494857  50   1000,00  1.0  NaN  \n",
       "4494858  50   1000,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('empresa8.CSV', encoding='LATIN-1', sep=';', header=None)\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "INSERIR HEAD"
   ]
  },
  {
   "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>32066830</td>\n",
       "      <td>PASTELLO PASTELARIA GOURMET LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>5000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>32066831</td>\n",
       "      <td>PARTIDO REPUBLICANO DA ORDEM SOCIAL - PACATUBA...</td>\n",
       "      <td>3271</td>\n",
       "      <td>16</td>\n",
       "      <td>0,00</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>32066832</td>\n",
       "      <td>JOSE ALIPIO GARCIA GOUVEA - ESPORTES</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>3</th>\n",
       "      <td>32066833</td>\n",
       "      <td>M&amp;M COMERCIO DE PRODUTOS AGROPECUARIOS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>10000,00</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>32066834</td>\n",
       "      <td>ISAIAS RODRIGUES 12415932809</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>...</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>36627970</td>\n",
       "      <td>GILVANDERSON SANTOS DA SILVA 45301862880</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>100,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494856</th>\n",
       "      <td>36627971</td>\n",
       "      <td>JONATHAS AUGUSTO DOS SANTOS CAMILO 40993054811</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>3000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494857</th>\n",
       "      <td>36627972</td>\n",
       "      <td>ANGELINA ANTUNES DA LUZ BORGES 87429187900</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>4494858</th>\n",
       "      <td>36627973</td>\n",
       "      <td>ANTONIO PEREIRA ARANTES NETO 01699985170</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>4494859</th>\n",
       "      <td>36627975</td>\n",
       "      <td>MICHELI PINHEIRO FLOR 06035748902</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        32066830                   PASTELLO PASTELARIA GOURMET LTDA   \n",
       "1        32066831  PARTIDO REPUBLICANO DA ORDEM SOCIAL - PACATUBA...   \n",
       "2        32066832               JOSE ALIPIO GARCIA GOUVEA - ESPORTES   \n",
       "3        32066833        M&M COMERCIO DE PRODUTOS AGROPECUARIOS LTDA   \n",
       "4        32066834                       ISAIAS RODRIGUES 12415932809   \n",
       "...           ...                                                ...   \n",
       "4494855  36627970           GILVANDERSON SANTOS DA SILVA 45301862880   \n",
       "4494856  36627971     JONATHAS AUGUSTO DOS SANTOS CAMILO 40993054811   \n",
       "4494857  36627972         ANGELINA ANTUNES DA LUZ BORGES 87429187900   \n",
       "4494858  36627973           ANTONIO PEREIRA ARANTES NETO 01699985170   \n",
       "4494859  36627975                  MICHELI PINHEIRO FLOR 06035748902   \n",
       "\n",
       "         RAZÃO SOCIAL  NOME FANTASIA SITUAÇÃO CADASTRAL  \\\n",
       "0                2062             49            5000,00   \n",
       "1                3271             16               0,00   \n",
       "2                2135             50           10000,00   \n",
       "3                2062             49           10000,00   \n",
       "4                2135             50            5000,00   \n",
       "...               ...            ...                ...   \n",
       "4494855          2135             50             100,00   \n",
       "4494856          2135             50            3000,00   \n",
       "4494857          2135             50            1000,00   \n",
       "4494858          2135             50            1000,00   \n",
       "4494859          2135             50            1000,00   \n",
       "\n",
       "         DATA SITUAÇÃO CADASTRAL CO-PAÍS  \n",
       "0                            1.0     NaN  \n",
       "1                            5.0     NaN  \n",
       "2                            1.0     NaN  \n",
       "3                            3.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>32066830</td>\n",
       "      <td>PASTELLO PASTELARIA GOURMET LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>5000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>32066831</td>\n",
       "      <td>PARTIDO REPUBLICANO DA ORDEM SOCIAL - PACATUBA...</td>\n",
       "      <td>3271</td>\n",
       "      <td>16</td>\n",
       "      <td>0,00</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>32066832</td>\n",
       "      <td>JOSE ALIPIO GARCIA GOUVEA - ESPORTES</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>3</th>\n",
       "      <td>32066833</td>\n",
       "      <td>M&amp;M COMERCIO DE PRODUTOS AGROPECUARIOS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>10000,00</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>32066834</td>\n",
       "      <td>ISAIAS RODRIGUES 12415932809</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>...</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>36627969</td>\n",
       "      <td>VINICIUS ESMERELI 23381366831</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>2000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494855</th>\n",
       "      <td>36627970</td>\n",
       "      <td>GILVANDERSON SANTOS DA SILVA 45301862880</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>100,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494856</th>\n",
       "      <td>36627971</td>\n",
       "      <td>JONATHAS AUGUSTO DOS SANTOS CAMILO 40993054811</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>3000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494857</th>\n",
       "      <td>36627972</td>\n",
       "      <td>ANGELINA ANTUNES DA LUZ BORGES 87429187900</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>4494858</th>\n",
       "      <td>36627973</td>\n",
       "      <td>ANTONIO PEREIRA ARANTES NETO 01699985170</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": [
       "             CNPJ                          INDEFICADOR MATRIZ/FILIAL  \\\n",
       "0        32066830                   PASTELLO PASTELARIA GOURMET LTDA   \n",
       "1        32066831  PARTIDO REPUBLICANO DA ORDEM SOCIAL - PACATUBA...   \n",
       "2        32066832               JOSE ALIPIO GARCIA GOUVEA - ESPORTES   \n",
       "3        32066833        M&M COMERCIO DE PRODUTOS AGROPECUARIOS LTDA   \n",
       "4        32066834                       ISAIAS RODRIGUES 12415932809   \n",
       "...           ...                                                ...   \n",
       "4494854  36627969                      VINICIUS ESMERELI 23381366831   \n",
       "4494855  36627970           GILVANDERSON SANTOS DA SILVA 45301862880   \n",
       "4494856  36627971     JONATHAS AUGUSTO DOS SANTOS CAMILO 40993054811   \n",
       "4494857  36627972         ANGELINA ANTUNES DA LUZ BORGES 87429187900   \n",
       "4494858  36627973           ANTONIO PEREIRA ARANTES NETO 01699985170   \n",
       "\n",
       "         RAZÃO SOCIAL  NOME FANTASIA SITUAÇÃO CADASTRAL  \\\n",
       "0                2062             49            5000,00   \n",
       "1                3271             16               0,00   \n",
       "2                2135             50           10000,00   \n",
       "3                2062             49           10000,00   \n",
       "4                2135             50            5000,00   \n",
       "...               ...            ...                ...   \n",
       "4494854          2135             50            2000,00   \n",
       "4494855          2135             50             100,00   \n",
       "4494856          2135             50            3000,00   \n",
       "4494857          2135             50            1000,00   \n",
       "4494858          2135             50            1000,00   \n",
       "\n",
       "         DATA SITUAÇÃO CADASTRAL CO-PAÍS  \n",
       "0                            1.0     NaN  \n",
       "1                            5.0     NaN  \n",
       "2                            1.0     NaN  \n",
       "3                            3.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>32066830</td>\n",
       "      <td>PASTELLO PASTELARIA GOURMET LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>5000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>32066831</td>\n",
       "      <td>PARTIDO REPUBLICANO DA ORDEM SOCIAL - PACATUBA...</td>\n",
       "      <td>3271</td>\n",
       "      <td>16</td>\n",
       "      <td>0,00</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>32066832</td>\n",
       "      <td>JOSE ALIPIO GARCIA GOUVEA - ESPORTES</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>3</th>\n",
       "      <td>32066833</td>\n",
       "      <td>M&amp;M COMERCIO DE PRODUTOS AGROPECUARIOS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>10000,00</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>32066834</td>\n",
       "      <td>ISAIAS RODRIGUES 12415932809</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>...</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>36627969</td>\n",
       "      <td>VINICIUS ESMERELI 23381366831</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>2000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494855</th>\n",
       "      <td>36627970</td>\n",
       "      <td>GILVANDERSON SANTOS DA SILVA 45301862880</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>100,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494856</th>\n",
       "      <td>36627971</td>\n",
       "      <td>JONATHAS AUGUSTO DOS SANTOS CAMILO 40993054811</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>3000,00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4494857</th>\n",
       "      <td>36627972</td>\n",
       "      <td>ANGELINA ANTUNES DA LUZ BORGES 87429187900</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>4494858</th>\n",
       "      <td>36627973</td>\n",
       "      <td>ANTONIO PEREIRA ARANTES NETO 01699985170</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": [
       "             CNPJ                          INDEFICADOR MATRIZ/FILIAL  \\\n",
       "0        32066830                   PASTELLO PASTELARIA GOURMET LTDA   \n",
       "1        32066831  PARTIDO REPUBLICANO DA ORDEM SOCIAL - PACATUBA...   \n",
       "2        32066832               JOSE ALIPIO GARCIA GOUVEA - ESPORTES   \n",
       "3        32066833        M&M COMERCIO DE PRODUTOS AGROPECUARIOS LTDA   \n",
       "4        32066834                       ISAIAS RODRIGUES 12415932809   \n",
       "...           ...                                                ...   \n",
       "4494854  36627969                      VINICIUS ESMERELI 23381366831   \n",
       "4494855  36627970           GILVANDERSON SANTOS DA SILVA 45301862880   \n",
       "4494856  36627971     JONATHAS AUGUSTO DOS SANTOS CAMILO 40993054811   \n",
       "4494857  36627972         ANGELINA ANTUNES DA LUZ BORGES 87429187900   \n",
       "4494858  36627973           ANTONIO PEREIRA ARANTES NETO 01699985170   \n",
       "\n",
       "         RAZÃO SOCIAL  NOME FANTASIA SITUAÇÃO CADASTRAL  \\\n",
       "0                2062             49            5000,00   \n",
       "1                3271             16               0,00   \n",
       "2                2135             50           10000,00   \n",
       "3                2062             49           10000,00   \n",
       "4                2135             50            5000,00   \n",
       "...               ...            ...                ...   \n",
       "4494854          2135             50            2000,00   \n",
       "4494855          2135             50             100,00   \n",
       "4494856          2135             50            3000,00   \n",
       "4494857          2135             50            1000,00   \n",
       "4494858          2135             50            1000,00   \n",
       "\n",
       "         DATA SITUAÇÃO CADASTRAL CO-PAÍS  \n",
       "0                            1.0     NaN  \n",
       "1                            5.0     NaN  \n",
       "2                            1.0     NaN  \n",
       "3                            3.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_empresa8.csv', 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
}