socio8.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>44022923</th>\n",
       "      <th>2</th>\n",
       "      <th>GRAZIELLA ALBERGONI GALLO</th>\n",
       "      <th>***223458**</th>\n",
       "      <th>49</th>\n",
       "      <th>20211026</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "      <th>***000000**</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>00</th>\n",
       "      <th>5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>44022969</td>\n",
       "      <td>2</td>\n",
       "      <td>JOSE HENRIQUE DE LIMA SOARES</td>\n",
       "      <td>***218445**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</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>1</th>\n",
       "      <td>44022980</td>\n",
       "      <td>2</td>\n",
       "      <td>ADAILTON HUDSON DE SOUSA</td>\n",
       "      <td>***662421**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</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>2</th>\n",
       "      <td>44022980</td>\n",
       "      <td>2</td>\n",
       "      <td>CELMA SARAIVA LEITE</td>\n",
       "      <td>***407431**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>44023230</td>\n",
       "      <td>2</td>\n",
       "      <td>PAULO FERNANDO GOMES MOREIRA</td>\n",
       "      <td>***180570**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>44023266</td>\n",
       "      <td>2</td>\n",
       "      <td>EDUARDO ALVES DONATO</td>\n",
       "      <td>***335698**</td>\n",
       "      <td>49</td>\n",
       "      <td>20240319</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>...</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>2019144</th>\n",
       "      <td>28106597</td>\n",
       "      <td>2</td>\n",
       "      <td>ALBERTO ALVES MARQUES FILHO</td>\n",
       "      <td>***121848**</td>\n",
       "      <td>10</td>\n",
       "      <td>20170531</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019145</th>\n",
       "      <td>28106597</td>\n",
       "      <td>2</td>\n",
       "      <td>RAFAEL GUSTAVO BATISTA DA SILVA</td>\n",
       "      <td>***570848**</td>\n",
       "      <td>16</td>\n",
       "      <td>20170531</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>2019146</th>\n",
       "      <td>28106597</td>\n",
       "      <td>2</td>\n",
       "      <td>ALEXANDRE DE OLIVEIRA CAMPOS</td>\n",
       "      <td>***464678**</td>\n",
       "      <td>10</td>\n",
       "      <td>20170531</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019147</th>\n",
       "      <td>28106738</td>\n",
       "      <td>2</td>\n",
       "      <td>ADILSON MAFRA</td>\n",
       "      <td>***904349**</td>\n",
       "      <td>49</td>\n",
       "      <td>20170417</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019148</th>\n",
       "      <td>28106738</td>\n",
       "      <td>2</td>\n",
       "      <td>RODRIGO CARMELO AGOSTINI</td>\n",
       "      <td>***335025**</td>\n",
       "      <td>49</td>\n",
       "      <td>20200721</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2019149 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         44022923  2        GRAZIELLA ALBERGONI GALLO  ***223458**  49  \\\n",
       "0        44022969  2     JOSE HENRIQUE DE LIMA SOARES  ***218445**  49   \n",
       "1        44022980  2         ADAILTON HUDSON DE SOUSA  ***662421**  49   \n",
       "2        44022980  2              CELMA SARAIVA LEITE  ***407431**  49   \n",
       "3        44023230  2     PAULO FERNANDO GOMES MOREIRA  ***180570**  49   \n",
       "4        44023266  2             EDUARDO ALVES DONATO  ***335698**  49   \n",
       "...           ... ..                              ...          ...  ..   \n",
       "2019144  28106597  2      ALBERTO ALVES MARQUES FILHO  ***121848**  10   \n",
       "2019145  28106597  2  RAFAEL GUSTAVO BATISTA DA SILVA  ***570848**  16   \n",
       "2019146  28106597  2     ALEXANDRE DE OLIVEIRA CAMPOS  ***464678**  10   \n",
       "2019147  28106738  2                    ADILSON MAFRA  ***904349**  49   \n",
       "2019148  28106738  2         RODRIGO CARMELO AGOSTINI  ***335025**  49   \n",
       "\n",
       "         20211026  Unnamed: 6  ***000000** Unnamed: 8  00  5  \n",
       "0        20211026         NaN  ***000000**        NaN   0  4  \n",
       "1        20211026         NaN  ***000000**        NaN   0  3  \n",
       "2        20211026         NaN  ***000000**        NaN   0  6  \n",
       "3        20211026         NaN  ***000000**        NaN   0  6  \n",
       "4        20240319         NaN  ***000000**        NaN   0  5  \n",
       "...           ...         ...          ...        ...  .. ..  \n",
       "2019144  20170531         NaN  ***000000**        NaN   0  6  \n",
       "2019145  20170531         NaN  ***000000**        NaN   0  4  \n",
       "2019146  20170531         NaN  ***000000**        NaN   0  6  \n",
       "2019147  20170417         NaN  ***000000**        NaN   0  6  \n",
       "2019148  20200721         NaN  ***000000**        NaN   0  5  \n",
       "\n",
       "[2019149 rows x 11 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('socio8.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>44022923</td>\n",
       "      <td>2</td>\n",
       "      <td>GRAZIELLA ALBERGONI GALLO</td>\n",
       "      <td>***223458**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</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>44022969</td>\n",
       "      <td>2</td>\n",
       "      <td>JOSE HENRIQUE DE LIMA SOARES</td>\n",
       "      <td>***218445**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</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>44022980</td>\n",
       "      <td>2</td>\n",
       "      <td>ADAILTON HUDSON DE SOUSA</td>\n",
       "      <td>***662421**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</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>44022980</td>\n",
       "      <td>2</td>\n",
       "      <td>CELMA SARAIVA LEITE</td>\n",
       "      <td>***407431**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>44023230</td>\n",
       "      <td>2</td>\n",
       "      <td>PAULO FERNANDO GOMES MOREIRA</td>\n",
       "      <td>***180570**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</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>2019145</th>\n",
       "      <td>28106597</td>\n",
       "      <td>2</td>\n",
       "      <td>ALBERTO ALVES MARQUES FILHO</td>\n",
       "      <td>***121848**</td>\n",
       "      <td>10</td>\n",
       "      <td>20170531</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019146</th>\n",
       "      <td>28106597</td>\n",
       "      <td>2</td>\n",
       "      <td>RAFAEL GUSTAVO BATISTA DA SILVA</td>\n",
       "      <td>***570848**</td>\n",
       "      <td>16</td>\n",
       "      <td>20170531</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>2019147</th>\n",
       "      <td>28106597</td>\n",
       "      <td>2</td>\n",
       "      <td>ALEXANDRE DE OLIVEIRA CAMPOS</td>\n",
       "      <td>***464678**</td>\n",
       "      <td>10</td>\n",
       "      <td>20170531</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019148</th>\n",
       "      <td>28106738</td>\n",
       "      <td>2</td>\n",
       "      <td>ADILSON MAFRA</td>\n",
       "      <td>***904349**</td>\n",
       "      <td>49</td>\n",
       "      <td>20170417</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019149</th>\n",
       "      <td>28106738</td>\n",
       "      <td>2</td>\n",
       "      <td>RODRIGO CARMELO AGOSTINI</td>\n",
       "      <td>***335025**</td>\n",
       "      <td>49</td>\n",
       "      <td>20200721</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2019150 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               0   1                                2            3   4   \\\n",
       "0        44022923   2        GRAZIELLA ALBERGONI GALLO  ***223458**  49   \n",
       "1        44022969   2     JOSE HENRIQUE DE LIMA SOARES  ***218445**  49   \n",
       "2        44022980   2         ADAILTON HUDSON DE SOUSA  ***662421**  49   \n",
       "3        44022980   2              CELMA SARAIVA LEITE  ***407431**  49   \n",
       "4        44023230   2     PAULO FERNANDO GOMES MOREIRA  ***180570**  49   \n",
       "...           ...  ..                              ...          ...  ..   \n",
       "2019145  28106597   2      ALBERTO ALVES MARQUES FILHO  ***121848**  10   \n",
       "2019146  28106597   2  RAFAEL GUSTAVO BATISTA DA SILVA  ***570848**  16   \n",
       "2019147  28106597   2     ALEXANDRE DE OLIVEIRA CAMPOS  ***464678**  10   \n",
       "2019148  28106738   2                    ADILSON MAFRA  ***904349**  49   \n",
       "2019149  28106738   2         RODRIGO CARMELO AGOSTINI  ***335025**  49   \n",
       "\n",
       "               5   6            7    8   9   10  \n",
       "0        20211026 NaN  ***000000**  NaN   0   5  \n",
       "1        20211026 NaN  ***000000**  NaN   0   4  \n",
       "2        20211026 NaN  ***000000**  NaN   0   3  \n",
       "3        20211026 NaN  ***000000**  NaN   0   6  \n",
       "4        20211026 NaN  ***000000**  NaN   0   6  \n",
       "...           ...  ..          ...  ...  ..  ..  \n",
       "2019145  20170531 NaN  ***000000**  NaN   0   6  \n",
       "2019146  20170531 NaN  ***000000**  NaN   0   4  \n",
       "2019147  20170531 NaN  ***000000**  NaN   0   6  \n",
       "2019148  20170417 NaN  ***000000**  NaN   0   6  \n",
       "2019149  20200721 NaN  ***000000**  NaN   0   5  \n",
       "\n",
       "[2019150 rows x 11 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('socio8.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>44022923</td>\n",
       "      <td>2</td>\n",
       "      <td>GRAZIELLA ALBERGONI GALLO</td>\n",
       "      <td>***223458**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</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>44022969</td>\n",
       "      <td>2</td>\n",
       "      <td>JOSE HENRIQUE DE LIMA SOARES</td>\n",
       "      <td>***218445**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</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>44022980</td>\n",
       "      <td>2</td>\n",
       "      <td>ADAILTON HUDSON DE SOUSA</td>\n",
       "      <td>***662421**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</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>44022980</td>\n",
       "      <td>2</td>\n",
       "      <td>CELMA SARAIVA LEITE</td>\n",
       "      <td>***407431**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>44023230</td>\n",
       "      <td>2</td>\n",
       "      <td>PAULO FERNANDO GOMES MOREIRA</td>\n",
       "      <td>***180570**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</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>2019145</th>\n",
       "      <td>28106597</td>\n",
       "      <td>2</td>\n",
       "      <td>ALBERTO ALVES MARQUES FILHO</td>\n",
       "      <td>***121848**</td>\n",
       "      <td>10</td>\n",
       "      <td>20170531</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019146</th>\n",
       "      <td>28106597</td>\n",
       "      <td>2</td>\n",
       "      <td>RAFAEL GUSTAVO BATISTA DA SILVA</td>\n",
       "      <td>***570848**</td>\n",
       "      <td>16</td>\n",
       "      <td>20170531</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>2019147</th>\n",
       "      <td>28106597</td>\n",
       "      <td>2</td>\n",
       "      <td>ALEXANDRE DE OLIVEIRA CAMPOS</td>\n",
       "      <td>***464678**</td>\n",
       "      <td>10</td>\n",
       "      <td>20170531</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019148</th>\n",
       "      <td>28106738</td>\n",
       "      <td>2</td>\n",
       "      <td>ADILSON MAFRA</td>\n",
       "      <td>***904349**</td>\n",
       "      <td>49</td>\n",
       "      <td>20170417</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019149</th>\n",
       "      <td>28106738</td>\n",
       "      <td>2</td>\n",
       "      <td>RODRIGO CARMELO AGOSTINI</td>\n",
       "      <td>***335025**</td>\n",
       "      <td>49</td>\n",
       "      <td>20200721</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2019150 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ  INDEFICADOR MATRIZ/FILIAL                     RAZÃO SOCIAL  \\\n",
       "0        44022923                          2        GRAZIELLA ALBERGONI GALLO   \n",
       "1        44022969                          2     JOSE HENRIQUE DE LIMA SOARES   \n",
       "2        44022980                          2         ADAILTON HUDSON DE SOUSA   \n",
       "3        44022980                          2              CELMA SARAIVA LEITE   \n",
       "4        44023230                          2     PAULO FERNANDO GOMES MOREIRA   \n",
       "...           ...                        ...                              ...   \n",
       "2019145  28106597                          2      ALBERTO ALVES MARQUES FILHO   \n",
       "2019146  28106597                          2  RAFAEL GUSTAVO BATISTA DA SILVA   \n",
       "2019147  28106597                          2     ALEXANDRE DE OLIVEIRA CAMPOS   \n",
       "2019148  28106738                          2                    ADILSON MAFRA   \n",
       "2019149  28106738                          2         RODRIGO CARMELO AGOSTINI   \n",
       "\n",
       "        NOME FANTASIA  SITUAÇÃO CADASTRAL  DATA SITUAÇÃO CADASTRAL  \\\n",
       "0         ***223458**                  49                 20211026   \n",
       "1         ***218445**                  49                 20211026   \n",
       "2         ***662421**                  49                 20211026   \n",
       "3         ***407431**                  49                 20211026   \n",
       "4         ***180570**                  49                 20211026   \n",
       "...               ...                 ...                      ...   \n",
       "2019145   ***121848**                  10                 20170531   \n",
       "2019146   ***570848**                  16                 20170531   \n",
       "2019147   ***464678**                  10                 20170531   \n",
       "2019148   ***904349**                  49                 20170417   \n",
       "2019149   ***335025**                  49                 20200721   \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",
       "2019145                        NaN  ***000000**                      NaN   \n",
       "2019146                        NaN  ***000000**                      NaN   \n",
       "2019147                        NaN  ***000000**                      NaN   \n",
       "2019148                        NaN  ***000000**                      NaN   \n",
       "2019149                        NaN  ***000000**                      NaN   \n",
       "\n",
       "         DATA INICIO ATIVIDADE  CNAE-FISCAL  \n",
       "0                            0            5  \n",
       "1                            0            4  \n",
       "2                            0            3  \n",
       "3                            0            6  \n",
       "4                            0            6  \n",
       "...                        ...          ...  \n",
       "2019145                      0            6  \n",
       "2019146                      0            4  \n",
       "2019147                      0            6  \n",
       "2019148                      0            6  \n",
       "2019149                      0            5  \n",
       "\n",
       "[2019150 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>44022923</td>\n",
       "      <td>2</td>\n",
       "      <td>GRAZIELLA ALBERGONI GALLO</td>\n",
       "      <td>***223458**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</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>44022969</td>\n",
       "      <td>2</td>\n",
       "      <td>JOSE HENRIQUE DE LIMA SOARES</td>\n",
       "      <td>***218445**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</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>44022980</td>\n",
       "      <td>2</td>\n",
       "      <td>ADAILTON HUDSON DE SOUSA</td>\n",
       "      <td>***662421**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</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>44022980</td>\n",
       "      <td>2</td>\n",
       "      <td>CELMA SARAIVA LEITE</td>\n",
       "      <td>***407431**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>44023230</td>\n",
       "      <td>2</td>\n",
       "      <td>PAULO FERNANDO GOMES MOREIRA</td>\n",
       "      <td>***180570**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</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>2019144</th>\n",
       "      <td>28106597</td>\n",
       "      <td>2</td>\n",
       "      <td>JOSE DE MELLO CORREA</td>\n",
       "      <td>***066338**</td>\n",
       "      <td>10</td>\n",
       "      <td>20170531</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>2019145</th>\n",
       "      <td>28106597</td>\n",
       "      <td>2</td>\n",
       "      <td>ALBERTO ALVES MARQUES FILHO</td>\n",
       "      <td>***121848**</td>\n",
       "      <td>10</td>\n",
       "      <td>20170531</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019146</th>\n",
       "      <td>28106597</td>\n",
       "      <td>2</td>\n",
       "      <td>RAFAEL GUSTAVO BATISTA DA SILVA</td>\n",
       "      <td>***570848**</td>\n",
       "      <td>16</td>\n",
       "      <td>20170531</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>2019147</th>\n",
       "      <td>28106597</td>\n",
       "      <td>2</td>\n",
       "      <td>ALEXANDRE DE OLIVEIRA CAMPOS</td>\n",
       "      <td>***464678**</td>\n",
       "      <td>10</td>\n",
       "      <td>20170531</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019148</th>\n",
       "      <td>28106738</td>\n",
       "      <td>2</td>\n",
       "      <td>ADILSON MAFRA</td>\n",
       "      <td>***904349**</td>\n",
       "      <td>49</td>\n",
       "      <td>20170417</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2019149 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ  INDEFICADOR MATRIZ/FILIAL                     RAZÃO SOCIAL  \\\n",
       "0        44022923                          2        GRAZIELLA ALBERGONI GALLO   \n",
       "1        44022969                          2     JOSE HENRIQUE DE LIMA SOARES   \n",
       "2        44022980                          2         ADAILTON HUDSON DE SOUSA   \n",
       "3        44022980                          2              CELMA SARAIVA LEITE   \n",
       "4        44023230                          2     PAULO FERNANDO GOMES MOREIRA   \n",
       "...           ...                        ...                              ...   \n",
       "2019144  28106597                          2             JOSE DE MELLO CORREA   \n",
       "2019145  28106597                          2      ALBERTO ALVES MARQUES FILHO   \n",
       "2019146  28106597                          2  RAFAEL GUSTAVO BATISTA DA SILVA   \n",
       "2019147  28106597                          2     ALEXANDRE DE OLIVEIRA CAMPOS   \n",
       "2019148  28106738                          2                    ADILSON MAFRA   \n",
       "\n",
       "        NOME FANTASIA  SITUAÇÃO CADASTRAL  DATA SITUAÇÃO CADASTRAL  \\\n",
       "0         ***223458**                  49                 20211026   \n",
       "1         ***218445**                  49                 20211026   \n",
       "2         ***662421**                  49                 20211026   \n",
       "3         ***407431**                  49                 20211026   \n",
       "4         ***180570**                  49                 20211026   \n",
       "...               ...                 ...                      ...   \n",
       "2019144   ***066338**                  10                 20170531   \n",
       "2019145   ***121848**                  10                 20170531   \n",
       "2019146   ***570848**                  16                 20170531   \n",
       "2019147   ***464678**                  10                 20170531   \n",
       "2019148   ***904349**                  49                 20170417   \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",
       "2019144                        NaN  ***000000**                      NaN   \n",
       "2019145                        NaN  ***000000**                      NaN   \n",
       "2019146                        NaN  ***000000**                      NaN   \n",
       "2019147                        NaN  ***000000**                      NaN   \n",
       "2019148                        NaN  ***000000**                      NaN   \n",
       "\n",
       "         DATA INICIO ATIVIDADE  CNAE-FISCAL  \n",
       "0                            0            5  \n",
       "1                            0            4  \n",
       "2                            0            3  \n",
       "3                            0            6  \n",
       "4                            0            6  \n",
       "...                        ...          ...  \n",
       "2019144                      0            7  \n",
       "2019145                      0            6  \n",
       "2019146                      0            4  \n",
       "2019147                      0            6  \n",
       "2019148                      0            6  \n",
       "\n",
       "[2019149 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>44022923</td>\n",
       "      <td>2</td>\n",
       "      <td>GRAZIELLA ALBERGONI GALLO</td>\n",
       "      <td>***223458**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</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>44022969</td>\n",
       "      <td>2</td>\n",
       "      <td>JOSE HENRIQUE DE LIMA SOARES</td>\n",
       "      <td>***218445**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</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>44022980</td>\n",
       "      <td>2</td>\n",
       "      <td>ADAILTON HUDSON DE SOUSA</td>\n",
       "      <td>***662421**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</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>44022980</td>\n",
       "      <td>2</td>\n",
       "      <td>CELMA SARAIVA LEITE</td>\n",
       "      <td>***407431**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>44023230</td>\n",
       "      <td>2</td>\n",
       "      <td>PAULO FERNANDO GOMES MOREIRA</td>\n",
       "      <td>***180570**</td>\n",
       "      <td>49</td>\n",
       "      <td>20211026</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</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>2019144</th>\n",
       "      <td>28106597</td>\n",
       "      <td>2</td>\n",
       "      <td>JOSE DE MELLO CORREA</td>\n",
       "      <td>***066338**</td>\n",
       "      <td>10</td>\n",
       "      <td>20170531</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>2019145</th>\n",
       "      <td>28106597</td>\n",
       "      <td>2</td>\n",
       "      <td>ALBERTO ALVES MARQUES FILHO</td>\n",
       "      <td>***121848**</td>\n",
       "      <td>10</td>\n",
       "      <td>20170531</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019146</th>\n",
       "      <td>28106597</td>\n",
       "      <td>2</td>\n",
       "      <td>RAFAEL GUSTAVO BATISTA DA SILVA</td>\n",
       "      <td>***570848**</td>\n",
       "      <td>16</td>\n",
       "      <td>20170531</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>2019147</th>\n",
       "      <td>28106597</td>\n",
       "      <td>2</td>\n",
       "      <td>ALEXANDRE DE OLIVEIRA CAMPOS</td>\n",
       "      <td>***464678**</td>\n",
       "      <td>10</td>\n",
       "      <td>20170531</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019148</th>\n",
       "      <td>28106738</td>\n",
       "      <td>2</td>\n",
       "      <td>ADILSON MAFRA</td>\n",
       "      <td>***904349**</td>\n",
       "      <td>49</td>\n",
       "      <td>20170417</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2019149 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ  INDEFICADOR MATRIZ/FILIAL                     RAZÃO SOCIAL  \\\n",
       "0        44022923                          2        GRAZIELLA ALBERGONI GALLO   \n",
       "1        44022969                          2     JOSE HENRIQUE DE LIMA SOARES   \n",
       "2        44022980                          2         ADAILTON HUDSON DE SOUSA   \n",
       "3        44022980                          2              CELMA SARAIVA LEITE   \n",
       "4        44023230                          2     PAULO FERNANDO GOMES MOREIRA   \n",
       "...           ...                        ...                              ...   \n",
       "2019144  28106597                          2             JOSE DE MELLO CORREA   \n",
       "2019145  28106597                          2      ALBERTO ALVES MARQUES FILHO   \n",
       "2019146  28106597                          2  RAFAEL GUSTAVO BATISTA DA SILVA   \n",
       "2019147  28106597                          2     ALEXANDRE DE OLIVEIRA CAMPOS   \n",
       "2019148  28106738                          2                    ADILSON MAFRA   \n",
       "\n",
       "        NOME FANTASIA  SITUAÇÃO CADASTRAL  DATA SITUAÇÃO CADASTRAL  \\\n",
       "0         ***223458**                  49                 20211026   \n",
       "1         ***218445**                  49                 20211026   \n",
       "2         ***662421**                  49                 20211026   \n",
       "3         ***407431**                  49                 20211026   \n",
       "4         ***180570**                  49                 20211026   \n",
       "...               ...                 ...                      ...   \n",
       "2019144   ***066338**                  10                 20170531   \n",
       "2019145   ***121848**                  10                 20170531   \n",
       "2019146   ***570848**                  16                 20170531   \n",
       "2019147   ***464678**                  10                 20170531   \n",
       "2019148   ***904349**                  49                 20170417   \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",
       "2019144                        NaN  ***000000**                      NaN   \n",
       "2019145                        NaN  ***000000**                      NaN   \n",
       "2019146                        NaN  ***000000**                      NaN   \n",
       "2019147                        NaN  ***000000**                      NaN   \n",
       "2019148                        NaN  ***000000**                      NaN   \n",
       "\n",
       "         DATA INICIO ATIVIDADE  CNAE-FISCAL  \n",
       "0                            0            5  \n",
       "1                            0            4  \n",
       "2                            0            3  \n",
       "3                            0            6  \n",
       "4                            0            6  \n",
       "...                        ...          ...  \n",
       "2019144                      0            7  \n",
       "2019145                      0            6  \n",
       "2019146                      0            4  \n",
       "2019147                      0            6  \n",
       "2019148                      0            6  \n",
       "\n",
       "[2019149 rows x 11 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.to_csv('n_socio8.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
}