empresa4.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>13846070</th>\n",
       "      <th>MARCOS ANTONIO PEREIRA AMADOR 60257981330</th>\n",
       "      <th>2135</th>\n",
       "      <th>50</th>\n",
       "      <th>1</th>\n",
       "      <th>1.1</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>13846071</td>\n",
       "      <td>CESAR APARECIDO NICOLETI</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>18000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>13846072</td>\n",
       "      <td>ANA PAULA RODRIGUES DA SILVA 00725813016</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>13846073</td>\n",
       "      <td>DOMINGO CUSSI NINA 23479340822</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>13846074</td>\n",
       "      <td>C.S. CARVALHO</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>5000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>13846075</td>\n",
       "      <td>MINISTERIO INTERNACIONAL PACTO ETERNO COM JESUS</td>\n",
       "      <td>3220</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>5.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>14916939</td>\n",
       "      <td>JEFERSON CORSO 01976288002</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048571</th>\n",
       "      <td>14916940</td>\n",
       "      <td>ROSANE DE OLIVEIRA GALVAO ALMEIDA 33173929837</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>14916941</td>\n",
       "      <td>HILARIA SOUSA DE OLIVEIRA ALVES 00673740188</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>5000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>14916942</td>\n",
       "      <td>RAFAEL PEREIRA RODRIGUES 01144805082</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>14916943</td>\n",
       "      <td>DEUSDETH VAZ DA COSTA 09628878387</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</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": [
       "         13846070        MARCOS ANTONIO PEREIRA AMADOR 60257981330  2135  50  \\\n",
       "0        13846071                         CESAR APARECIDO NICOLETI  2135  50   \n",
       "1        13846072         ANA PAULA RODRIGUES DA SILVA 00725813016  2135  50   \n",
       "2        13846073                   DOMINGO CUSSI NINA 23479340822  2135  50   \n",
       "3        13846074                                    C.S. CARVALHO  2135  50   \n",
       "4        13846075  MINISTERIO INTERNACIONAL PACTO ETERNO COM JESUS  3220  16   \n",
       "...           ...                                              ...   ...  ..   \n",
       "1048570  14916939                       JEFERSON CORSO 01976288002  2135  50   \n",
       "1048571  14916940    ROSANE DE OLIVEIRA GALVAO ALMEIDA 33173929837  2135  50   \n",
       "1048572  14916941      HILARIA SOUSA DE OLIVEIRA ALVES 00673740188  2135  50   \n",
       "1048573  14916942             RAFAEL PEREIRA RODRIGUES 01144805082  2135  50   \n",
       "1048574  14916943                DEUSDETH VAZ DA COSTA 09628878387  2135  50   \n",
       "\n",
       "             1  1.1 Unnamed: 6  \n",
       "0        18000  1.0        NaN  \n",
       "1            1  1.0        NaN  \n",
       "2            1  1.0        NaN  \n",
       "3         5000  1.0        NaN  \n",
       "4            0  5.0        NaN  \n",
       "...        ...  ...        ...  \n",
       "1048570      1  1.0        NaN  \n",
       "1048571      1  1.0        NaN  \n",
       "1048572   5000  1.0        NaN  \n",
       "1048573      1  1.0        NaN  \n",
       "1048574      1  1.0        NaN  \n",
       "\n",
       "[1048575 rows x 7 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('empresa4.CSV', encoding='LATIN-1', sep=';')\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "ELIMINANDO O 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>13846070</td>\n",
       "      <td>MARCOS ANTONIO PEREIRA AMADOR 60257981330</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>13846071</td>\n",
       "      <td>CESAR APARECIDO NICOLETI</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>18000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>13846072</td>\n",
       "      <td>ANA PAULA RODRIGUES DA SILVA 00725813016</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>13846073</td>\n",
       "      <td>DOMINGO CUSSI NINA 23479340822</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>13846074</td>\n",
       "      <td>C.S. CARVALHO</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>5000</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>14916939</td>\n",
       "      <td>JEFERSON CORSO 01976288002</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>14916940</td>\n",
       "      <td>ROSANE DE OLIVEIRA GALVAO ALMEIDA 33173929837</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>14916941</td>\n",
       "      <td>HILARIA SOUSA DE OLIVEIRA ALVES 00673740188</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>5000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>14916942</td>\n",
       "      <td>RAFAEL PEREIRA RODRIGUES 01144805082</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048575</th>\n",
       "      <td>14916943</td>\n",
       "      <td>DEUSDETH VAZ DA COSTA 09628878387</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</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   3  \\\n",
       "0        13846070      MARCOS ANTONIO PEREIRA AMADOR 60257981330  2135  50   \n",
       "1        13846071                       CESAR APARECIDO NICOLETI  2135  50   \n",
       "2        13846072       ANA PAULA RODRIGUES DA SILVA 00725813016  2135  50   \n",
       "3        13846073                 DOMINGO CUSSI NINA 23479340822  2135  50   \n",
       "4        13846074                                  C.S. CARVALHO  2135  50   \n",
       "...           ...                                            ...   ...  ..   \n",
       "1048571  14916939                     JEFERSON CORSO 01976288002  2135  50   \n",
       "1048572  14916940  ROSANE DE OLIVEIRA GALVAO ALMEIDA 33173929837  2135  50   \n",
       "1048573  14916941    HILARIA SOUSA DE OLIVEIRA ALVES 00673740188  2135  50   \n",
       "1048574  14916942           RAFAEL PEREIRA RODRIGUES 01144805082  2135  50   \n",
       "1048575  14916943              DEUSDETH VAZ DA COSTA 09628878387  2135  50   \n",
       "\n",
       "             4    5    6  \n",
       "0            1  1.0  NaN  \n",
       "1        18000  1.0  NaN  \n",
       "2            1  1.0  NaN  \n",
       "3            1  1.0  NaN  \n",
       "4         5000  1.0  NaN  \n",
       "...        ...  ...  ...  \n",
       "1048571      1  1.0  NaN  \n",
       "1048572      1  1.0  NaN  \n",
       "1048573   5000  1.0  NaN  \n",
       "1048574      1  1.0  NaN  \n",
       "1048575      1  1.0  NaN  \n",
       "\n",
       "[1048576 rows x 7 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('empresa4.CSV', encoding='LATIN-1', sep=';', header=None)\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "INSERIR O HEAD (CABEÇ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>13846070</td>\n",
       "      <td>MARCOS ANTONIO PEREIRA AMADOR 60257981330</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>13846071</td>\n",
       "      <td>CESAR APARECIDO NICOLETI</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>18000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>13846072</td>\n",
       "      <td>ANA PAULA RODRIGUES DA SILVA 00725813016</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>13846073</td>\n",
       "      <td>DOMINGO CUSSI NINA 23479340822</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>13846074</td>\n",
       "      <td>C.S. CARVALHO</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>5000</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>14916939</td>\n",
       "      <td>JEFERSON CORSO 01976288002</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>14916940</td>\n",
       "      <td>ROSANE DE OLIVEIRA GALVAO ALMEIDA 33173929837</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>14916941</td>\n",
       "      <td>HILARIA SOUSA DE OLIVEIRA ALVES 00673740188</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>5000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>14916942</td>\n",
       "      <td>RAFAEL PEREIRA RODRIGUES 01144805082</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048575</th>\n",
       "      <td>14916943</td>\n",
       "      <td>DEUSDETH VAZ DA COSTA 09628878387</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</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        13846070      MARCOS ANTONIO PEREIRA AMADOR 60257981330   \n",
       "1        13846071                       CESAR APARECIDO NICOLETI   \n",
       "2        13846072       ANA PAULA RODRIGUES DA SILVA 00725813016   \n",
       "3        13846073                 DOMINGO CUSSI NINA 23479340822   \n",
       "4        13846074                                  C.S. CARVALHO   \n",
       "...           ...                                            ...   \n",
       "1048571  14916939                     JEFERSON CORSO 01976288002   \n",
       "1048572  14916940  ROSANE DE OLIVEIRA GALVAO ALMEIDA 33173929837   \n",
       "1048573  14916941    HILARIA SOUSA DE OLIVEIRA ALVES 00673740188   \n",
       "1048574  14916942           RAFAEL PEREIRA RODRIGUES 01144805082   \n",
       "1048575  14916943              DEUSDETH VAZ DA COSTA 09628878387   \n",
       "\n",
       "         RAZÃO SOCIAL  NOME FANTASIA SITUAÇÃO CADASTRAL  \\\n",
       "0                2135             50                  1   \n",
       "1                2135             50              18000   \n",
       "2                2135             50                  1   \n",
       "3                2135             50                  1   \n",
       "4                2135             50               5000   \n",
       "...               ...            ...                ...   \n",
       "1048571          2135             50                  1   \n",
       "1048572          2135             50                  1   \n",
       "1048573          2135             50               5000   \n",
       "1048574          2135             50                  1   \n",
       "1048575          2135             50                  1   \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": 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>13846070</td>\n",
       "      <td>MARCOS ANTONIO PEREIRA AMADOR 60257981330</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>13846071</td>\n",
       "      <td>CESAR APARECIDO NICOLETI</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>18000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>13846072</td>\n",
       "      <td>ANA PAULA RODRIGUES DA SILVA 00725813016</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>13846073</td>\n",
       "      <td>DOMINGO CUSSI NINA 23479340822</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>13846074</td>\n",
       "      <td>C.S. CARVALHO</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>5000</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>14916938</td>\n",
       "      <td>WENDER PAIXAO DE OLIVEIRA SOUSA 67917933253</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>35000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048571</th>\n",
       "      <td>14916939</td>\n",
       "      <td>JEFERSON CORSO 01976288002</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>14916940</td>\n",
       "      <td>ROSANE DE OLIVEIRA GALVAO ALMEIDA 33173929837</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>14916941</td>\n",
       "      <td>HILARIA SOUSA DE OLIVEIRA ALVES 00673740188</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>5000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>14916942</td>\n",
       "      <td>RAFAEL PEREIRA RODRIGUES 01144805082</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</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        13846070      MARCOS ANTONIO PEREIRA AMADOR 60257981330   \n",
       "1        13846071                       CESAR APARECIDO NICOLETI   \n",
       "2        13846072       ANA PAULA RODRIGUES DA SILVA 00725813016   \n",
       "3        13846073                 DOMINGO CUSSI NINA 23479340822   \n",
       "4        13846074                                  C.S. CARVALHO   \n",
       "...           ...                                            ...   \n",
       "1048570  14916938    WENDER PAIXAO DE OLIVEIRA SOUSA 67917933253   \n",
       "1048571  14916939                     JEFERSON CORSO 01976288002   \n",
       "1048572  14916940  ROSANE DE OLIVEIRA GALVAO ALMEIDA 33173929837   \n",
       "1048573  14916941    HILARIA SOUSA DE OLIVEIRA ALVES 00673740188   \n",
       "1048574  14916942           RAFAEL PEREIRA RODRIGUES 01144805082   \n",
       "\n",
       "         RAZÃO SOCIAL  NOME FANTASIA SITUAÇÃO CADASTRAL  \\\n",
       "0                2135             50                  1   \n",
       "1                2135             50              18000   \n",
       "2                2135             50                  1   \n",
       "3                2135             50                  1   \n",
       "4                2135             50               5000   \n",
       "...               ...            ...                ...   \n",
       "1048570          2135             50              35000   \n",
       "1048571          2135             50                  1   \n",
       "1048572          2135             50                  1   \n",
       "1048573          2135             50               5000   \n",
       "1048574          2135             50                  1   \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": 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>13846070</td>\n",
       "      <td>MARCOS ANTONIO PEREIRA AMADOR 60257981330</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>13846071</td>\n",
       "      <td>CESAR APARECIDO NICOLETI</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>18000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>13846072</td>\n",
       "      <td>ANA PAULA RODRIGUES DA SILVA 00725813016</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>13846073</td>\n",
       "      <td>DOMINGO CUSSI NINA 23479340822</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>13846074</td>\n",
       "      <td>C.S. CARVALHO</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>5000</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>14916938</td>\n",
       "      <td>WENDER PAIXAO DE OLIVEIRA SOUSA 67917933253</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>35000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048571</th>\n",
       "      <td>14916939</td>\n",
       "      <td>JEFERSON CORSO 01976288002</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>14916940</td>\n",
       "      <td>ROSANE DE OLIVEIRA GALVAO ALMEIDA 33173929837</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>14916941</td>\n",
       "      <td>HILARIA SOUSA DE OLIVEIRA ALVES 00673740188</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>5000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>14916942</td>\n",
       "      <td>RAFAEL PEREIRA RODRIGUES 01144805082</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</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        13846070      MARCOS ANTONIO PEREIRA AMADOR 60257981330   \n",
       "1        13846071                       CESAR APARECIDO NICOLETI   \n",
       "2        13846072       ANA PAULA RODRIGUES DA SILVA 00725813016   \n",
       "3        13846073                 DOMINGO CUSSI NINA 23479340822   \n",
       "4        13846074                                  C.S. CARVALHO   \n",
       "...           ...                                            ...   \n",
       "1048570  14916938    WENDER PAIXAO DE OLIVEIRA SOUSA 67917933253   \n",
       "1048571  14916939                     JEFERSON CORSO 01976288002   \n",
       "1048572  14916940  ROSANE DE OLIVEIRA GALVAO ALMEIDA 33173929837   \n",
       "1048573  14916941    HILARIA SOUSA DE OLIVEIRA ALVES 00673740188   \n",
       "1048574  14916942           RAFAEL PEREIRA RODRIGUES 01144805082   \n",
       "\n",
       "         RAZÃO SOCIAL  NOME FANTASIA SITUAÇÃO CADASTRAL  \\\n",
       "0                2135             50                  1   \n",
       "1                2135             50              18000   \n",
       "2                2135             50                  1   \n",
       "3                2135             50                  1   \n",
       "4                2135             50               5000   \n",
       "...               ...            ...                ...   \n",
       "1048570          2135             50              35000   \n",
       "1048571          2135             50                  1   \n",
       "1048572          2135             50                  1   \n",
       "1048573          2135             50               5000   \n",
       "1048574          2135             50                  1   \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": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.to_csv('n_empresa4.csv', index=False)\n",
    "df"
   ]
  },
  {
   "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>13846070</td>\n",
       "      <td>MARCOS ANTONIO PEREIRA AMADOR 60257981330</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>13846071</td>\n",
       "      <td>CESAR APARECIDO NICOLETI</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>18000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>13846072</td>\n",
       "      <td>ANA PAULA RODRIGUES DA SILVA 00725813016</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>13846073</td>\n",
       "      <td>DOMINGO CUSSI NINA 23479340822</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>13846074</td>\n",
       "      <td>C.S. CARVALHO</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>5000</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>14916938</td>\n",
       "      <td>WENDER PAIXAO DE OLIVEIRA SOUSA 67917933253</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>35000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048571</th>\n",
       "      <td>14916939</td>\n",
       "      <td>JEFERSON CORSO 01976288002</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>14916940</td>\n",
       "      <td>ROSANE DE OLIVEIRA GALVAO ALMEIDA 33173929837</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>14916941</td>\n",
       "      <td>HILARIA SOUSA DE OLIVEIRA ALVES 00673740188</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>5000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>14916942</td>\n",
       "      <td>RAFAEL PEREIRA RODRIGUES 01144805082</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1</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        13846070      MARCOS ANTONIO PEREIRA AMADOR 60257981330   \n",
       "1        13846071                       CESAR APARECIDO NICOLETI   \n",
       "2        13846072       ANA PAULA RODRIGUES DA SILVA 00725813016   \n",
       "3        13846073                 DOMINGO CUSSI NINA 23479340822   \n",
       "4        13846074                                  C.S. CARVALHO   \n",
       "...           ...                                            ...   \n",
       "1048570  14916938    WENDER PAIXAO DE OLIVEIRA SOUSA 67917933253   \n",
       "1048571  14916939                     JEFERSON CORSO 01976288002   \n",
       "1048572  14916940  ROSANE DE OLIVEIRA GALVAO ALMEIDA 33173929837   \n",
       "1048573  14916941    HILARIA SOUSA DE OLIVEIRA ALVES 00673740188   \n",
       "1048574  14916942           RAFAEL PEREIRA RODRIGUES 01144805082   \n",
       "\n",
       "         RAZÃO SOCIAL  NOME FANTASIA SITUAÇÃO CADASTRAL  \\\n",
       "0                2135             50                  1   \n",
       "1                2135             50              18000   \n",
       "2                2135             50                  1   \n",
       "3                2135             50                  1   \n",
       "4                2135             50               5000   \n",
       "...               ...            ...                ...   \n",
       "1048570          2135             50              35000   \n",
       "1048571          2135             50                  1   \n",
       "1048572          2135             50                  1   \n",
       "1048573          2135             50               5000   \n",
       "1048574          2135             50                  1   \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.to_excel('n_empresa4.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
}