empresa0.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#IMPORTANDO TABELA = empresa0"
   ]
  },
  {
   "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>41273595</th>\n",
       "      <th>GILVAN PEREIRA XAVIER 01363090380</th>\n",
       "      <th>2135</th>\n",
       "      <th>50</th>\n",
       "      <th>3000</th>\n",
       "      <th>1</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>41273596</td>\n",
       "      <td>RODRIGO JOSE FERREIRA LOPES 05010247941</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>10000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>41273597</td>\n",
       "      <td>PACHARRUS QUEIROZ DA COSTA E SILVA 03618384335</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>2</th>\n",
       "      <td>41273598</td>\n",
       "      <td>GLORIA VIANA DIAS DA SILVA 13118961716</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1100</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>41273599</td>\n",
       "      <td>ANA PAULA DA SILVA DE PAULA 04659802957</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>2000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>41273600</td>\n",
       "      <td>41.273.600 AVANILSON BRUNO MATIAS DA SILVA</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>50000</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>42338470</td>\n",
       "      <td>FELOMENA PEREIRA COELHO ARAUJO 53880846120</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>500</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048571</th>\n",
       "      <td>42338471</td>\n",
       "      <td>ESPACO MY SOUL LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>10000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>42338472</td>\n",
       "      <td>JOANI PAIXAO CABRAL DE SOUSA 04475058821</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>600</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>42338473</td>\n",
       "      <td>BOX COSMETICOS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>20000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>42338474</td>\n",
       "      <td>DANIEL PEREIRA MARTINS JUNIOR 10021106614</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>7500</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": [
       "         41273595               GILVAN PEREIRA XAVIER 01363090380  2135  50  \\\n",
       "0        41273596         RODRIGO JOSE FERREIRA LOPES 05010247941  2135  50   \n",
       "1        41273597  PACHARRUS QUEIROZ DA COSTA E SILVA 03618384335  2135  50   \n",
       "2        41273598          GLORIA VIANA DIAS DA SILVA 13118961716  2135  50   \n",
       "3        41273599         ANA PAULA DA SILVA DE PAULA 04659802957  2135  50   \n",
       "4        41273600      41.273.600 AVANILSON BRUNO MATIAS DA SILVA  2135  50   \n",
       "...           ...                                             ...   ...  ..   \n",
       "1048570  42338470      FELOMENA PEREIRA COELHO ARAUJO 53880846120  2135  50   \n",
       "1048571  42338471                             ESPACO MY SOUL LTDA  2062  49   \n",
       "1048572  42338472        JOANI PAIXAO CABRAL DE SOUSA 04475058821  2135  50   \n",
       "1048573  42338473                             BOX COSMETICOS LTDA  2062  49   \n",
       "1048574  42338474       DANIEL PEREIRA MARTINS JUNIOR 10021106614  2135  50   \n",
       "\n",
       "          3000    1 Unnamed: 6  \n",
       "0        10000  1.0        NaN  \n",
       "1         5000  1.0        NaN  \n",
       "2         1100  1.0        NaN  \n",
       "3         2000  1.0        NaN  \n",
       "4        50000  1.0        NaN  \n",
       "...        ...  ...        ...  \n",
       "1048570    500  1.0        NaN  \n",
       "1048571  10000  3.0        NaN  \n",
       "1048572    600  1.0        NaN  \n",
       "1048573  20000  1.0        NaN  \n",
       "1048574   7500  1.0        NaN  \n",
       "\n",
       "[1048575 rows x 7 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('empresa0.CSV', encoding = 'latin1', sep = ';')\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "EXCLUIR O CABEÇALHO (HEAD) DA TABELA CSV"
   ]
  },
  {
   "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>41273595</td>\n",
       "      <td>GILVAN PEREIRA XAVIER 01363090380</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>3000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>41273596</td>\n",
       "      <td>RODRIGO JOSE FERREIRA LOPES 05010247941</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>10000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>41273597</td>\n",
       "      <td>PACHARRUS QUEIROZ DA COSTA E SILVA 03618384335</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>3</th>\n",
       "      <td>41273598</td>\n",
       "      <td>GLORIA VIANA DIAS DA SILVA 13118961716</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1100</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>41273599</td>\n",
       "      <td>ANA PAULA DA SILVA DE PAULA 04659802957</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>2000</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>42338470</td>\n",
       "      <td>FELOMENA PEREIRA COELHO ARAUJO 53880846120</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>500</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>42338471</td>\n",
       "      <td>ESPACO MY SOUL LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>10000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>42338472</td>\n",
       "      <td>JOANI PAIXAO CABRAL DE SOUSA 04475058821</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>600</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>42338473</td>\n",
       "      <td>BOX COSMETICOS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>20000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048575</th>\n",
       "      <td>42338474</td>\n",
       "      <td>DANIEL PEREIRA MARTINS JUNIOR 10021106614</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>7500</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        41273595               GILVAN PEREIRA XAVIER 01363090380  2135  50   \n",
       "1        41273596         RODRIGO JOSE FERREIRA LOPES 05010247941  2135  50   \n",
       "2        41273597  PACHARRUS QUEIROZ DA COSTA E SILVA 03618384335  2135  50   \n",
       "3        41273598          GLORIA VIANA DIAS DA SILVA 13118961716  2135  50   \n",
       "4        41273599         ANA PAULA DA SILVA DE PAULA 04659802957  2135  50   \n",
       "...           ...                                             ...   ...  ..   \n",
       "1048571  42338470      FELOMENA PEREIRA COELHO ARAUJO 53880846120  2135  50   \n",
       "1048572  42338471                             ESPACO MY SOUL LTDA  2062  49   \n",
       "1048573  42338472        JOANI PAIXAO CABRAL DE SOUSA 04475058821  2135  50   \n",
       "1048574  42338473                             BOX COSMETICOS LTDA  2062  49   \n",
       "1048575  42338474       DANIEL PEREIRA MARTINS JUNIOR 10021106614  2135  50   \n",
       "\n",
       "             4    5    6  \n",
       "0         3000  1.0  NaN  \n",
       "1        10000  1.0  NaN  \n",
       "2         5000  1.0  NaN  \n",
       "3         1100  1.0  NaN  \n",
       "4         2000  1.0  NaN  \n",
       "...        ...  ...  ...  \n",
       "1048571    500  1.0  NaN  \n",
       "1048572  10000  3.0  NaN  \n",
       "1048573    600  1.0  NaN  \n",
       "1048574  20000  1.0  NaN  \n",
       "1048575   7500  1.0  NaN  \n",
       "\n",
       "[1048576 rows x 7 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('empresa0.CSV', encoding = 'latin1', sep = ';', header=None)\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#criando cabeçalho (head) numa tabela Já existente"
   ]
  },
  {
   "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>41273595</td>\n",
       "      <td>GILVAN PEREIRA XAVIER 01363090380</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>3000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>41273596</td>\n",
       "      <td>RODRIGO JOSE FERREIRA LOPES 05010247941</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>10000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>41273597</td>\n",
       "      <td>PACHARRUS QUEIROZ DA COSTA E SILVA 03618384335</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>3</th>\n",
       "      <td>41273598</td>\n",
       "      <td>GLORIA VIANA DIAS DA SILVA 13118961716</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1100</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>41273599</td>\n",
       "      <td>ANA PAULA DA SILVA DE PAULA 04659802957</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>2000</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>42338470</td>\n",
       "      <td>FELOMENA PEREIRA COELHO ARAUJO 53880846120</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>500</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>42338471</td>\n",
       "      <td>ESPACO MY SOUL LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>10000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>42338472</td>\n",
       "      <td>JOANI PAIXAO CABRAL DE SOUSA 04475058821</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>600</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>42338473</td>\n",
       "      <td>BOX COSMETICOS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>20000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048575</th>\n",
       "      <td>42338474</td>\n",
       "      <td>DANIEL PEREIRA MARTINS JUNIOR 10021106614</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>7500</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        41273595               GILVAN PEREIRA XAVIER 01363090380   \n",
       "1        41273596         RODRIGO JOSE FERREIRA LOPES 05010247941   \n",
       "2        41273597  PACHARRUS QUEIROZ DA COSTA E SILVA 03618384335   \n",
       "3        41273598          GLORIA VIANA DIAS DA SILVA 13118961716   \n",
       "4        41273599         ANA PAULA DA SILVA DE PAULA 04659802957   \n",
       "...           ...                                             ...   \n",
       "1048571  42338470      FELOMENA PEREIRA COELHO ARAUJO 53880846120   \n",
       "1048572  42338471                             ESPACO MY SOUL LTDA   \n",
       "1048573  42338472        JOANI PAIXAO CABRAL DE SOUSA 04475058821   \n",
       "1048574  42338473                             BOX COSMETICOS LTDA   \n",
       "1048575  42338474       DANIEL PEREIRA MARTINS JUNIOR 10021106614   \n",
       "\n",
       "         RAZÃO SOCIAL  NOME FANTASIA SITUAÇÃO CADASTRAL  \\\n",
       "0                2135             50               3000   \n",
       "1                2135             50              10000   \n",
       "2                2135             50               5000   \n",
       "3                2135             50               1100   \n",
       "4                2135             50               2000   \n",
       "...               ...            ...                ...   \n",
       "1048571          2135             50                500   \n",
       "1048572          2062             49              10000   \n",
       "1048573          2135             50                600   \n",
       "1048574          2062             49              20000   \n",
       "1048575          2135             50               7500   \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                      3.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",
    "                    \n",
    "df\n"
   ]
  },
  {
   "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>41273595</td>\n",
       "      <td>GILVAN PEREIRA XAVIER 01363090380</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>3000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>41273596</td>\n",
       "      <td>RODRIGO JOSE FERREIRA LOPES 05010247941</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>10000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>41273597</td>\n",
       "      <td>PACHARRUS QUEIROZ DA COSTA E SILVA 03618384335</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>3</th>\n",
       "      <td>41273598</td>\n",
       "      <td>GLORIA VIANA DIAS DA SILVA 13118961716</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1100</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>41273599</td>\n",
       "      <td>ANA PAULA DA SILVA DE PAULA 04659802957</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>2000</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>42338469</td>\n",
       "      <td>VALDENIR SIMAO 77266307953</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>100</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048571</th>\n",
       "      <td>42338470</td>\n",
       "      <td>FELOMENA PEREIRA COELHO ARAUJO 53880846120</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>500</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>42338471</td>\n",
       "      <td>ESPACO MY SOUL LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>10000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>42338472</td>\n",
       "      <td>JOANI PAIXAO CABRAL DE SOUSA 04475058821</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>600</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>42338473</td>\n",
       "      <td>BOX COSMETICOS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>20000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1048575 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ                       INDEFICADOR MATRIZ/FILIAL  \\\n",
       "0        41273595               GILVAN PEREIRA XAVIER 01363090380   \n",
       "1        41273596         RODRIGO JOSE FERREIRA LOPES 05010247941   \n",
       "2        41273597  PACHARRUS QUEIROZ DA COSTA E SILVA 03618384335   \n",
       "3        41273598          GLORIA VIANA DIAS DA SILVA 13118961716   \n",
       "4        41273599         ANA PAULA DA SILVA DE PAULA 04659802957   \n",
       "...           ...                                             ...   \n",
       "1048570  42338469                      VALDENIR SIMAO 77266307953   \n",
       "1048571  42338470      FELOMENA PEREIRA COELHO ARAUJO 53880846120   \n",
       "1048572  42338471                             ESPACO MY SOUL LTDA   \n",
       "1048573  42338472        JOANI PAIXAO CABRAL DE SOUSA 04475058821   \n",
       "1048574  42338473                             BOX COSMETICOS LTDA   \n",
       "\n",
       "         RAZÃO SOCIAL  NOME FANTASIA SITUAÇÃO CADASTRAL  \\\n",
       "0                2135             50               3000   \n",
       "1                2135             50              10000   \n",
       "2                2135             50               5000   \n",
       "3                2135             50               1100   \n",
       "4                2135             50               2000   \n",
       "...               ...            ...                ...   \n",
       "1048570          2135             50                100   \n",
       "1048571          2135             50                500   \n",
       "1048572          2062             49              10000   \n",
       "1048573          2135             50                600   \n",
       "1048574          2062             49              20000   \n",
       "\n",
       "         DATA SITUAÇÃO CADASTRAL CO-PAÍS  \n",
       "0                            1.0     NaN  \n",
       "1                            1.0     NaN  \n",
       "2                            1.0     NaN  \n",
       "3                            1.0     NaN  \n",
       "4                            1.0     NaN  \n",
       "...                          ...     ...  \n",
       "1048570                      1.0     NaN  \n",
       "1048571                      1.0     NaN  \n",
       "1048572                      3.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>41273595</td>\n",
       "      <td>GILVAN PEREIRA XAVIER 01363090380</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>3000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>41273596</td>\n",
       "      <td>RODRIGO JOSE FERREIRA LOPES 05010247941</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>10000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>41273597</td>\n",
       "      <td>PACHARRUS QUEIROZ DA COSTA E SILVA 03618384335</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>3</th>\n",
       "      <td>41273598</td>\n",
       "      <td>GLORIA VIANA DIAS DA SILVA 13118961716</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>1100</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>41273599</td>\n",
       "      <td>ANA PAULA DA SILVA DE PAULA 04659802957</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>2000</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>42338469</td>\n",
       "      <td>VALDENIR SIMAO 77266307953</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>100</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048571</th>\n",
       "      <td>42338470</td>\n",
       "      <td>FELOMENA PEREIRA COELHO ARAUJO 53880846120</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>500</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>42338471</td>\n",
       "      <td>ESPACO MY SOUL LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>10000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>42338472</td>\n",
       "      <td>JOANI PAIXAO CABRAL DE SOUSA 04475058821</td>\n",
       "      <td>2135</td>\n",
       "      <td>50</td>\n",
       "      <td>600</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>42338473</td>\n",
       "      <td>BOX COSMETICOS LTDA</td>\n",
       "      <td>2062</td>\n",
       "      <td>49</td>\n",
       "      <td>20000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1048575 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ                       INDEFICADOR MATRIZ/FILIAL  \\\n",
       "0        41273595               GILVAN PEREIRA XAVIER 01363090380   \n",
       "1        41273596         RODRIGO JOSE FERREIRA LOPES 05010247941   \n",
       "2        41273597  PACHARRUS QUEIROZ DA COSTA E SILVA 03618384335   \n",
       "3        41273598          GLORIA VIANA DIAS DA SILVA 13118961716   \n",
       "4        41273599         ANA PAULA DA SILVA DE PAULA 04659802957   \n",
       "...           ...                                             ...   \n",
       "1048570  42338469                      VALDENIR SIMAO 77266307953   \n",
       "1048571  42338470      FELOMENA PEREIRA COELHO ARAUJO 53880846120   \n",
       "1048572  42338471                             ESPACO MY SOUL LTDA   \n",
       "1048573  42338472        JOANI PAIXAO CABRAL DE SOUSA 04475058821   \n",
       "1048574  42338473                             BOX COSMETICOS LTDA   \n",
       "\n",
       "         RAZÃO SOCIAL  NOME FANTASIA SITUAÇÃO CADASTRAL  \\\n",
       "0                2135             50               3000   \n",
       "1                2135             50              10000   \n",
       "2                2135             50               5000   \n",
       "3                2135             50               1100   \n",
       "4                2135             50               2000   \n",
       "...               ...            ...                ...   \n",
       "1048570          2135             50                100   \n",
       "1048571          2135             50                500   \n",
       "1048572          2062             49              10000   \n",
       "1048573          2135             50                600   \n",
       "1048574          2062             49              20000   \n",
       "\n",
       "         DATA SITUAÇÃO CADASTRAL CO-PAÍS  \n",
       "0                            1.0     NaN  \n",
       "1                            1.0     NaN  \n",
       "2                            1.0     NaN  \n",
       "3                            1.0     NaN  \n",
       "4                            1.0     NaN  \n",
       "...                          ...     ...  \n",
       "1048570                      1.0     NaN  \n",
       "1048571                      1.0     NaN  \n",
       "1048572                      3.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_empresa0.csv', index=False)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_excel('n_empresa0.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
}