socio2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "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>41623537</th>\n",
       "      <th>2</th>\n",
       "      <th>ELISABETE SOARES DE FREITAS RODRIGUES</th>\n",
       "      <th>***212774**</th>\n",
       "      <th>22</th>\n",
       "      <th>20210419</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "      <th>***000000**</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>0</th>\n",
       "      <th>5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>41623559</td>\n",
       "      <td>2</td>\n",
       "      <td>AGNALDO DOS ANJOS GOIS</td>\n",
       "      <td>***222711**</td>\n",
       "      <td>49</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>41623572</td>\n",
       "      <td>2</td>\n",
       "      <td>CAIO COSTA SANTOS ALVES DA SILVA</td>\n",
       "      <td>***981752**</td>\n",
       "      <td>49</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>41623603</td>\n",
       "      <td>2</td>\n",
       "      <td>MONIQUE EVELLE NASCIMENTO COSTA</td>\n",
       "      <td>***488415**</td>\n",
       "      <td>49</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>41623603</td>\n",
       "      <td>2</td>\n",
       "      <td>LUCAS ROBERTO DA COSTA DE SANTANA</td>\n",
       "      <td>***125625**</td>\n",
       "      <td>22</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>41623615</td>\n",
       "      <td>2</td>\n",
       "      <td>ALINE MIRANDA LISBOA</td>\n",
       "      <td>***694036**</td>\n",
       "      <td>49</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048570</th>\n",
       "      <td>7784728</td>\n",
       "      <td>2</td>\n",
       "      <td>DOUGLAS DOS REIS</td>\n",
       "      <td>***386908**</td>\n",
       "      <td>49</td>\n",
       "      <td>20051202</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048571</th>\n",
       "      <td>7784728</td>\n",
       "      <td>2</td>\n",
       "      <td>DOUGLAS JERICO DE CARVALHO REIS</td>\n",
       "      <td>***909078**</td>\n",
       "      <td>22</td>\n",
       "      <td>20051202</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>7784737</td>\n",
       "      <td>2</td>\n",
       "      <td>FERNANDA MARA DOS SANTOS</td>\n",
       "      <td>***641768**</td>\n",
       "      <td>49</td>\n",
       "      <td>20051124</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>7784737</td>\n",
       "      <td>2</td>\n",
       "      <td>HELENA MARA BARBOSA DOS SANTOS</td>\n",
       "      <td>***312128**</td>\n",
       "      <td>22</td>\n",
       "      <td>20051124</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>7784753</td>\n",
       "      <td>2</td>\n",
       "      <td>WANDERLEY RESENDE DOMINGUES</td>\n",
       "      <td>***529308**</td>\n",
       "      <td>49</td>\n",
       "      <td>20060110</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1048575 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         41623537  2 ELISABETE SOARES DE FREITAS RODRIGUES  ***212774**  22  \\\n",
       "0        41623559  2                AGNALDO DOS ANJOS GOIS  ***222711**  49   \n",
       "1        41623572  2      CAIO COSTA SANTOS ALVES DA SILVA  ***981752**  49   \n",
       "2        41623603  2       MONIQUE EVELLE NASCIMENTO COSTA  ***488415**  49   \n",
       "3        41623603  2     LUCAS ROBERTO DA COSTA DE SANTANA  ***125625**  22   \n",
       "4        41623615  2                  ALINE MIRANDA LISBOA  ***694036**  49   \n",
       "...           ... ..                                   ...          ...  ..   \n",
       "1048570   7784728  2                      DOUGLAS DOS REIS  ***386908**  49   \n",
       "1048571   7784728  2       DOUGLAS JERICO DE CARVALHO REIS  ***909078**  22   \n",
       "1048572   7784737  2              FERNANDA MARA DOS SANTOS  ***641768**  49   \n",
       "1048573   7784737  2        HELENA MARA BARBOSA DOS SANTOS  ***312128**  22   \n",
       "1048574   7784753  2           WANDERLEY RESENDE DOMINGUES  ***529308**  49   \n",
       "\n",
       "         20210419  Unnamed: 6  ***000000** Unnamed: 8  0  5  \n",
       "0        20210419         NaN  ***000000**        NaN  0  5  \n",
       "1        20210419         NaN  ***000000**        NaN  0  4  \n",
       "2        20210419         NaN  ***000000**        NaN  0  3  \n",
       "3        20210419         NaN  ***000000**        NaN  0  4  \n",
       "4        20210419         NaN  ***000000**        NaN  0  4  \n",
       "...           ...         ...          ...        ... .. ..  \n",
       "1048570  20051202         NaN  ***000000**        NaN  0  7  \n",
       "1048571  20051202         NaN  ***000000**        NaN  0  5  \n",
       "1048572  20051124         NaN  ***000000**        NaN  0  5  \n",
       "1048573  20051124         NaN  ***000000**        NaN  0  7  \n",
       "1048574  20060110         NaN  ***000000**        NaN  0  8  \n",
       "\n",
       "[1048575 rows x 11 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('socio2.CSV', encoding='LATIN-1', sep=';')\n",
    "df"
   ]
  },
  {
   "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",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>41623537</td>\n",
       "      <td>2</td>\n",
       "      <td>ELISABETE SOARES DE FREITAS RODRIGUES</td>\n",
       "      <td>***212774**</td>\n",
       "      <td>22</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>41623559</td>\n",
       "      <td>2</td>\n",
       "      <td>AGNALDO DOS ANJOS GOIS</td>\n",
       "      <td>***222711**</td>\n",
       "      <td>49</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>41623572</td>\n",
       "      <td>2</td>\n",
       "      <td>CAIO COSTA SANTOS ALVES DA SILVA</td>\n",
       "      <td>***981752**</td>\n",
       "      <td>49</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>41623603</td>\n",
       "      <td>2</td>\n",
       "      <td>MONIQUE EVELLE NASCIMENTO COSTA</td>\n",
       "      <td>***488415**</td>\n",
       "      <td>49</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>41623603</td>\n",
       "      <td>2</td>\n",
       "      <td>LUCAS ROBERTO DA COSTA DE SANTANA</td>\n",
       "      <td>***125625**</td>\n",
       "      <td>22</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048571</th>\n",
       "      <td>7784728</td>\n",
       "      <td>2</td>\n",
       "      <td>DOUGLAS DOS REIS</td>\n",
       "      <td>***386908**</td>\n",
       "      <td>49</td>\n",
       "      <td>20051202</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>7784728</td>\n",
       "      <td>2</td>\n",
       "      <td>DOUGLAS JERICO DE CARVALHO REIS</td>\n",
       "      <td>***909078**</td>\n",
       "      <td>22</td>\n",
       "      <td>20051202</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>7784737</td>\n",
       "      <td>2</td>\n",
       "      <td>FERNANDA MARA DOS SANTOS</td>\n",
       "      <td>***641768**</td>\n",
       "      <td>49</td>\n",
       "      <td>20051124</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>7784737</td>\n",
       "      <td>2</td>\n",
       "      <td>HELENA MARA BARBOSA DOS SANTOS</td>\n",
       "      <td>***312128**</td>\n",
       "      <td>22</td>\n",
       "      <td>20051124</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048575</th>\n",
       "      <td>7784753</td>\n",
       "      <td>2</td>\n",
       "      <td>WANDERLEY RESENDE DOMINGUES</td>\n",
       "      <td>***529308**</td>\n",
       "      <td>49</td>\n",
       "      <td>20060110</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1048576 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               0   1                                      2            3   4   \\\n",
       "0        41623537   2  ELISABETE SOARES DE FREITAS RODRIGUES  ***212774**  22   \n",
       "1        41623559   2                 AGNALDO DOS ANJOS GOIS  ***222711**  49   \n",
       "2        41623572   2       CAIO COSTA SANTOS ALVES DA SILVA  ***981752**  49   \n",
       "3        41623603   2        MONIQUE EVELLE NASCIMENTO COSTA  ***488415**  49   \n",
       "4        41623603   2      LUCAS ROBERTO DA COSTA DE SANTANA  ***125625**  22   \n",
       "...           ...  ..                                    ...          ...  ..   \n",
       "1048571   7784728   2                       DOUGLAS DOS REIS  ***386908**  49   \n",
       "1048572   7784728   2        DOUGLAS JERICO DE CARVALHO REIS  ***909078**  22   \n",
       "1048573   7784737   2               FERNANDA MARA DOS SANTOS  ***641768**  49   \n",
       "1048574   7784737   2         HELENA MARA BARBOSA DOS SANTOS  ***312128**  22   \n",
       "1048575   7784753   2            WANDERLEY RESENDE DOMINGUES  ***529308**  49   \n",
       "\n",
       "               5   6            7    8   9   10  \n",
       "0        20210419 NaN  ***000000**  NaN   0   5  \n",
       "1        20210419 NaN  ***000000**  NaN   0   5  \n",
       "2        20210419 NaN  ***000000**  NaN   0   4  \n",
       "3        20210419 NaN  ***000000**  NaN   0   3  \n",
       "4        20210419 NaN  ***000000**  NaN   0   4  \n",
       "...           ...  ..          ...  ...  ..  ..  \n",
       "1048571  20051202 NaN  ***000000**  NaN   0   7  \n",
       "1048572  20051202 NaN  ***000000**  NaN   0   5  \n",
       "1048573  20051124 NaN  ***000000**  NaN   0   5  \n",
       "1048574  20051124 NaN  ***000000**  NaN   0   7  \n",
       "1048575  20060110 NaN  ***000000**  NaN   0   8  \n",
       "\n",
       "[1048576 rows x 11 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('socio2.CSV', encoding='LATIN-1', sep=';', header=None)\n",
    "df"
   ]
  },
  {
   "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>MOTIVO SITUAÇÃO CADASTRAL</th>\n",
       "      <th>CO-PAÍS</th>\n",
       "      <th>CÓDIGO NATUREZA JURIDICA</th>\n",
       "      <th>DATA INICIO ATIVIDADE</th>\n",
       "      <th>CNAE-FISCAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>41623537</td>\n",
       "      <td>2</td>\n",
       "      <td>ELISABETE SOARES DE FREITAS RODRIGUES</td>\n",
       "      <td>***212774**</td>\n",
       "      <td>22</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>41623559</td>\n",
       "      <td>2</td>\n",
       "      <td>AGNALDO DOS ANJOS GOIS</td>\n",
       "      <td>***222711**</td>\n",
       "      <td>49</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>41623572</td>\n",
       "      <td>2</td>\n",
       "      <td>CAIO COSTA SANTOS ALVES DA SILVA</td>\n",
       "      <td>***981752**</td>\n",
       "      <td>49</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>41623603</td>\n",
       "      <td>2</td>\n",
       "      <td>MONIQUE EVELLE NASCIMENTO COSTA</td>\n",
       "      <td>***488415**</td>\n",
       "      <td>49</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>41623603</td>\n",
       "      <td>2</td>\n",
       "      <td>LUCAS ROBERTO DA COSTA DE SANTANA</td>\n",
       "      <td>***125625**</td>\n",
       "      <td>22</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048571</th>\n",
       "      <td>7784728</td>\n",
       "      <td>2</td>\n",
       "      <td>DOUGLAS DOS REIS</td>\n",
       "      <td>***386908**</td>\n",
       "      <td>49</td>\n",
       "      <td>20051202</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>7784728</td>\n",
       "      <td>2</td>\n",
       "      <td>DOUGLAS JERICO DE CARVALHO REIS</td>\n",
       "      <td>***909078**</td>\n",
       "      <td>22</td>\n",
       "      <td>20051202</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>7784737</td>\n",
       "      <td>2</td>\n",
       "      <td>FERNANDA MARA DOS SANTOS</td>\n",
       "      <td>***641768**</td>\n",
       "      <td>49</td>\n",
       "      <td>20051124</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>7784737</td>\n",
       "      <td>2</td>\n",
       "      <td>HELENA MARA BARBOSA DOS SANTOS</td>\n",
       "      <td>***312128**</td>\n",
       "      <td>22</td>\n",
       "      <td>20051124</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048575</th>\n",
       "      <td>7784753</td>\n",
       "      <td>2</td>\n",
       "      <td>WANDERLEY RESENDE DOMINGUES</td>\n",
       "      <td>***529308**</td>\n",
       "      <td>49</td>\n",
       "      <td>20060110</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1048576 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ  INDEFICADOR MATRIZ/FILIAL  \\\n",
       "0        41623537                          2   \n",
       "1        41623559                          2   \n",
       "2        41623572                          2   \n",
       "3        41623603                          2   \n",
       "4        41623603                          2   \n",
       "...           ...                        ...   \n",
       "1048571   7784728                          2   \n",
       "1048572   7784728                          2   \n",
       "1048573   7784737                          2   \n",
       "1048574   7784737                          2   \n",
       "1048575   7784753                          2   \n",
       "\n",
       "                                  RAZÃO SOCIAL NOME FANTASIA  \\\n",
       "0        ELISABETE SOARES DE FREITAS RODRIGUES   ***212774**   \n",
       "1                       AGNALDO DOS ANJOS GOIS   ***222711**   \n",
       "2             CAIO COSTA SANTOS ALVES DA SILVA   ***981752**   \n",
       "3              MONIQUE EVELLE NASCIMENTO COSTA   ***488415**   \n",
       "4            LUCAS ROBERTO DA COSTA DE SANTANA   ***125625**   \n",
       "...                                        ...           ...   \n",
       "1048571                       DOUGLAS DOS REIS   ***386908**   \n",
       "1048572        DOUGLAS JERICO DE CARVALHO REIS   ***909078**   \n",
       "1048573               FERNANDA MARA DOS SANTOS   ***641768**   \n",
       "1048574         HELENA MARA BARBOSA DOS SANTOS   ***312128**   \n",
       "1048575            WANDERLEY RESENDE DOMINGUES   ***529308**   \n",
       "\n",
       "         SITUAÇÃO CADASTRAL  DATA SITUAÇÃO CADASTRAL  \\\n",
       "0                        22                 20210419   \n",
       "1                        49                 20210419   \n",
       "2                        49                 20210419   \n",
       "3                        49                 20210419   \n",
       "4                        22                 20210419   \n",
       "...                     ...                      ...   \n",
       "1048571                  49                 20051202   \n",
       "1048572                  22                 20051202   \n",
       "1048573                  49                 20051124   \n",
       "1048574                  22                 20051124   \n",
       "1048575                  49                 20060110   \n",
       "\n",
       "         MOTIVO SITUAÇÃO CADASTRAL      CO-PAÍS CÓDIGO NATUREZA JURIDICA  \\\n",
       "0                              NaN  ***000000**                      NaN   \n",
       "1                              NaN  ***000000**                      NaN   \n",
       "2                              NaN  ***000000**                      NaN   \n",
       "3                              NaN  ***000000**                      NaN   \n",
       "4                              NaN  ***000000**                      NaN   \n",
       "...                            ...          ...                      ...   \n",
       "1048571                        NaN  ***000000**                      NaN   \n",
       "1048572                        NaN  ***000000**                      NaN   \n",
       "1048573                        NaN  ***000000**                      NaN   \n",
       "1048574                        NaN  ***000000**                      NaN   \n",
       "1048575                        NaN  ***000000**                      NaN   \n",
       "\n",
       "         DATA INICIO ATIVIDADE  CNAE-FISCAL  \n",
       "0                            0            5  \n",
       "1                            0            5  \n",
       "2                            0            4  \n",
       "3                            0            3  \n",
       "4                            0            4  \n",
       "...                        ...          ...  \n",
       "1048571                      0            7  \n",
       "1048572                      0            5  \n",
       "1048573                      0            5  \n",
       "1048574                      0            7  \n",
       "1048575                      0            8  \n",
       "\n",
       "[1048576 rows x 11 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', 'MOTIVO SITUAÇÃO CADASTRAL', 'CO-PAÍS', \n",
    "              'CÓDIGO NATUREZA JURIDICA', 'DATA INICIO ATIVIDADE', 'CNAE-FISCAL']\n",
    "df"
   ]
  },
  {
   "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>MOTIVO SITUAÇÃO CADASTRAL</th>\n",
       "      <th>CO-PAÍS</th>\n",
       "      <th>CÓDIGO NATUREZA JURIDICA</th>\n",
       "      <th>DATA INICIO ATIVIDADE</th>\n",
       "      <th>CNAE-FISCAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>41623537</td>\n",
       "      <td>2</td>\n",
       "      <td>ELISABETE SOARES DE FREITAS RODRIGUES</td>\n",
       "      <td>***212774**</td>\n",
       "      <td>22</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>41623559</td>\n",
       "      <td>2</td>\n",
       "      <td>AGNALDO DOS ANJOS GOIS</td>\n",
       "      <td>***222711**</td>\n",
       "      <td>49</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>41623572</td>\n",
       "      <td>2</td>\n",
       "      <td>CAIO COSTA SANTOS ALVES DA SILVA</td>\n",
       "      <td>***981752**</td>\n",
       "      <td>49</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>41623603</td>\n",
       "      <td>2</td>\n",
       "      <td>MONIQUE EVELLE NASCIMENTO COSTA</td>\n",
       "      <td>***488415**</td>\n",
       "      <td>49</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>41623603</td>\n",
       "      <td>2</td>\n",
       "      <td>LUCAS ROBERTO DA COSTA DE SANTANA</td>\n",
       "      <td>***125625**</td>\n",
       "      <td>22</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048570</th>\n",
       "      <td>7784699</td>\n",
       "      <td>2</td>\n",
       "      <td>GUILHERME BOECHAT ASSERUY SILVA</td>\n",
       "      <td>***247116**</td>\n",
       "      <td>22</td>\n",
       "      <td>20060113</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048571</th>\n",
       "      <td>7784728</td>\n",
       "      <td>2</td>\n",
       "      <td>DOUGLAS DOS REIS</td>\n",
       "      <td>***386908**</td>\n",
       "      <td>49</td>\n",
       "      <td>20051202</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>7784728</td>\n",
       "      <td>2</td>\n",
       "      <td>DOUGLAS JERICO DE CARVALHO REIS</td>\n",
       "      <td>***909078**</td>\n",
       "      <td>22</td>\n",
       "      <td>20051202</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>7784737</td>\n",
       "      <td>2</td>\n",
       "      <td>FERNANDA MARA DOS SANTOS</td>\n",
       "      <td>***641768**</td>\n",
       "      <td>49</td>\n",
       "      <td>20051124</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>7784737</td>\n",
       "      <td>2</td>\n",
       "      <td>HELENA MARA BARBOSA DOS SANTOS</td>\n",
       "      <td>***312128**</td>\n",
       "      <td>22</td>\n",
       "      <td>20051124</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1048575 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ  INDEFICADOR MATRIZ/FILIAL  \\\n",
       "0        41623537                          2   \n",
       "1        41623559                          2   \n",
       "2        41623572                          2   \n",
       "3        41623603                          2   \n",
       "4        41623603                          2   \n",
       "...           ...                        ...   \n",
       "1048570   7784699                          2   \n",
       "1048571   7784728                          2   \n",
       "1048572   7784728                          2   \n",
       "1048573   7784737                          2   \n",
       "1048574   7784737                          2   \n",
       "\n",
       "                                  RAZÃO SOCIAL NOME FANTASIA  \\\n",
       "0        ELISABETE SOARES DE FREITAS RODRIGUES   ***212774**   \n",
       "1                       AGNALDO DOS ANJOS GOIS   ***222711**   \n",
       "2             CAIO COSTA SANTOS ALVES DA SILVA   ***981752**   \n",
       "3              MONIQUE EVELLE NASCIMENTO COSTA   ***488415**   \n",
       "4            LUCAS ROBERTO DA COSTA DE SANTANA   ***125625**   \n",
       "...                                        ...           ...   \n",
       "1048570        GUILHERME BOECHAT ASSERUY SILVA   ***247116**   \n",
       "1048571                       DOUGLAS DOS REIS   ***386908**   \n",
       "1048572        DOUGLAS JERICO DE CARVALHO REIS   ***909078**   \n",
       "1048573               FERNANDA MARA DOS SANTOS   ***641768**   \n",
       "1048574         HELENA MARA BARBOSA DOS SANTOS   ***312128**   \n",
       "\n",
       "         SITUAÇÃO CADASTRAL  DATA SITUAÇÃO CADASTRAL  \\\n",
       "0                        22                 20210419   \n",
       "1                        49                 20210419   \n",
       "2                        49                 20210419   \n",
       "3                        49                 20210419   \n",
       "4                        22                 20210419   \n",
       "...                     ...                      ...   \n",
       "1048570                  22                 20060113   \n",
       "1048571                  49                 20051202   \n",
       "1048572                  22                 20051202   \n",
       "1048573                  49                 20051124   \n",
       "1048574                  22                 20051124   \n",
       "\n",
       "         MOTIVO SITUAÇÃO CADASTRAL      CO-PAÍS CÓDIGO NATUREZA JURIDICA  \\\n",
       "0                              NaN  ***000000**                      NaN   \n",
       "1                              NaN  ***000000**                      NaN   \n",
       "2                              NaN  ***000000**                      NaN   \n",
       "3                              NaN  ***000000**                      NaN   \n",
       "4                              NaN  ***000000**                      NaN   \n",
       "...                            ...          ...                      ...   \n",
       "1048570                        NaN  ***000000**                      NaN   \n",
       "1048571                        NaN  ***000000**                      NaN   \n",
       "1048572                        NaN  ***000000**                      NaN   \n",
       "1048573                        NaN  ***000000**                      NaN   \n",
       "1048574                        NaN  ***000000**                      NaN   \n",
       "\n",
       "         DATA INICIO ATIVIDADE  CNAE-FISCAL  \n",
       "0                            0            5  \n",
       "1                            0            5  \n",
       "2                            0            4  \n",
       "3                            0            3  \n",
       "4                            0            4  \n",
       "...                        ...          ...  \n",
       "1048570                      0            4  \n",
       "1048571                      0            7  \n",
       "1048572                      0            5  \n",
       "1048573                      0            5  \n",
       "1048574                      0            7  \n",
       "\n",
       "[1048575 rows x 11 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.drop(df.tail(1).index, inplace=True)\n",
    "df"
   ]
  },
  {
   "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>MOTIVO SITUAÇÃO CADASTRAL</th>\n",
       "      <th>CO-PAÍS</th>\n",
       "      <th>CÓDIGO NATUREZA JURIDICA</th>\n",
       "      <th>DATA INICIO ATIVIDADE</th>\n",
       "      <th>CNAE-FISCAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>41623537</td>\n",
       "      <td>2</td>\n",
       "      <td>ELISABETE SOARES DE FREITAS RODRIGUES</td>\n",
       "      <td>***212774**</td>\n",
       "      <td>22</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>41623559</td>\n",
       "      <td>2</td>\n",
       "      <td>AGNALDO DOS ANJOS GOIS</td>\n",
       "      <td>***222711**</td>\n",
       "      <td>49</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>41623572</td>\n",
       "      <td>2</td>\n",
       "      <td>CAIO COSTA SANTOS ALVES DA SILVA</td>\n",
       "      <td>***981752**</td>\n",
       "      <td>49</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>41623603</td>\n",
       "      <td>2</td>\n",
       "      <td>MONIQUE EVELLE NASCIMENTO COSTA</td>\n",
       "      <td>***488415**</td>\n",
       "      <td>49</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>41623603</td>\n",
       "      <td>2</td>\n",
       "      <td>LUCAS ROBERTO DA COSTA DE SANTANA</td>\n",
       "      <td>***125625**</td>\n",
       "      <td>22</td>\n",
       "      <td>20210419</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048570</th>\n",
       "      <td>7784699</td>\n",
       "      <td>2</td>\n",
       "      <td>GUILHERME BOECHAT ASSERUY SILVA</td>\n",
       "      <td>***247116**</td>\n",
       "      <td>22</td>\n",
       "      <td>20060113</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048571</th>\n",
       "      <td>7784728</td>\n",
       "      <td>2</td>\n",
       "      <td>DOUGLAS DOS REIS</td>\n",
       "      <td>***386908**</td>\n",
       "      <td>49</td>\n",
       "      <td>20051202</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>7784728</td>\n",
       "      <td>2</td>\n",
       "      <td>DOUGLAS JERICO DE CARVALHO REIS</td>\n",
       "      <td>***909078**</td>\n",
       "      <td>22</td>\n",
       "      <td>20051202</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>7784737</td>\n",
       "      <td>2</td>\n",
       "      <td>FERNANDA MARA DOS SANTOS</td>\n",
       "      <td>***641768**</td>\n",
       "      <td>49</td>\n",
       "      <td>20051124</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>7784737</td>\n",
       "      <td>2</td>\n",
       "      <td>HELENA MARA BARBOSA DOS SANTOS</td>\n",
       "      <td>***312128**</td>\n",
       "      <td>22</td>\n",
       "      <td>20051124</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1048575 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ  INDEFICADOR MATRIZ/FILIAL  \\\n",
       "0        41623537                          2   \n",
       "1        41623559                          2   \n",
       "2        41623572                          2   \n",
       "3        41623603                          2   \n",
       "4        41623603                          2   \n",
       "...           ...                        ...   \n",
       "1048570   7784699                          2   \n",
       "1048571   7784728                          2   \n",
       "1048572   7784728                          2   \n",
       "1048573   7784737                          2   \n",
       "1048574   7784737                          2   \n",
       "\n",
       "                                  RAZÃO SOCIAL NOME FANTASIA  \\\n",
       "0        ELISABETE SOARES DE FREITAS RODRIGUES   ***212774**   \n",
       "1                       AGNALDO DOS ANJOS GOIS   ***222711**   \n",
       "2             CAIO COSTA SANTOS ALVES DA SILVA   ***981752**   \n",
       "3              MONIQUE EVELLE NASCIMENTO COSTA   ***488415**   \n",
       "4            LUCAS ROBERTO DA COSTA DE SANTANA   ***125625**   \n",
       "...                                        ...           ...   \n",
       "1048570        GUILHERME BOECHAT ASSERUY SILVA   ***247116**   \n",
       "1048571                       DOUGLAS DOS REIS   ***386908**   \n",
       "1048572        DOUGLAS JERICO DE CARVALHO REIS   ***909078**   \n",
       "1048573               FERNANDA MARA DOS SANTOS   ***641768**   \n",
       "1048574         HELENA MARA BARBOSA DOS SANTOS   ***312128**   \n",
       "\n",
       "         SITUAÇÃO CADASTRAL  DATA SITUAÇÃO CADASTRAL  \\\n",
       "0                        22                 20210419   \n",
       "1                        49                 20210419   \n",
       "2                        49                 20210419   \n",
       "3                        49                 20210419   \n",
       "4                        22                 20210419   \n",
       "...                     ...                      ...   \n",
       "1048570                  22                 20060113   \n",
       "1048571                  49                 20051202   \n",
       "1048572                  22                 20051202   \n",
       "1048573                  49                 20051124   \n",
       "1048574                  22                 20051124   \n",
       "\n",
       "         MOTIVO SITUAÇÃO CADASTRAL      CO-PAÍS CÓDIGO NATUREZA JURIDICA  \\\n",
       "0                              NaN  ***000000**                      NaN   \n",
       "1                              NaN  ***000000**                      NaN   \n",
       "2                              NaN  ***000000**                      NaN   \n",
       "3                              NaN  ***000000**                      NaN   \n",
       "4                              NaN  ***000000**                      NaN   \n",
       "...                            ...          ...                      ...   \n",
       "1048570                        NaN  ***000000**                      NaN   \n",
       "1048571                        NaN  ***000000**                      NaN   \n",
       "1048572                        NaN  ***000000**                      NaN   \n",
       "1048573                        NaN  ***000000**                      NaN   \n",
       "1048574                        NaN  ***000000**                      NaN   \n",
       "\n",
       "         DATA INICIO ATIVIDADE  CNAE-FISCAL  \n",
       "0                            0            5  \n",
       "1                            0            5  \n",
       "2                            0            4  \n",
       "3                            0            3  \n",
       "4                            0            4  \n",
       "...                        ...          ...  \n",
       "1048570                      0            4  \n",
       "1048571                      0            7  \n",
       "1048572                      0            5  \n",
       "1048573                      0            5  \n",
       "1048574                      0            7  \n",
       "\n",
       "[1048575 rows x 11 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.to_csv('n_socio2.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
}