socio5.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>44969517</th>\n",
       "      <th>2</th>\n",
       "      <th>SERGIO MONTEIRO</th>\n",
       "      <th>***828488**</th>\n",
       "      <th>49</th>\n",
       "      <th>19951103</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>44969517</td>\n",
       "      <td>1</td>\n",
       "      <td>FEMARA PARTICIPACOES E NEGOCIOS S/A</td>\n",
       "      <td>18320263000143</td>\n",
       "      <td>22</td>\n",
       "      <td>20131007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***828488**</td>\n",
       "      <td>SERGIO MONTEIRO</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>81215345</td>\n",
       "      <td>2</td>\n",
       "      <td>ROBERTO PADILHA</td>\n",
       "      <td>***461879**</td>\n",
       "      <td>49</td>\n",
       "      <td>20010711</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>2</th>\n",
       "      <td>81215345</td>\n",
       "      <td>2</td>\n",
       "      <td>VILMA CARVALHO DE OLIVEIRA</td>\n",
       "      <td>***378579**</td>\n",
       "      <td>22</td>\n",
       "      <td>20010711</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***461879**</td>\n",
       "      <td>ROBERTO PADILHA</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>81218885</td>\n",
       "      <td>2</td>\n",
       "      <td>NATAL MANENTI</td>\n",
       "      <td>***904839**</td>\n",
       "      <td>49</td>\n",
       "      <td>19900209</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>81218885</td>\n",
       "      <td>2</td>\n",
       "      <td>BERNADETE DAMASCENO DANDOLINI</td>\n",
       "      <td>***539929**</td>\n",
       "      <td>22</td>\n",
       "      <td>19900209</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>...</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>1580969</td>\n",
       "      <td>2</td>\n",
       "      <td>TEOGENES TEMISTOCLES LEAL PEREIRA</td>\n",
       "      <td>***920763**</td>\n",
       "      <td>49</td>\n",
       "      <td>20160301</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>2019145</th>\n",
       "      <td>1580969</td>\n",
       "      <td>2</td>\n",
       "      <td>ANDREIA LEAL PEREIRA MESQUITA</td>\n",
       "      <td>***071073**</td>\n",
       "      <td>22</td>\n",
       "      <td>20160301</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>2019146</th>\n",
       "      <td>1580919</td>\n",
       "      <td>2</td>\n",
       "      <td>FRANCISCO ASSIS DA SILVA</td>\n",
       "      <td>***601191**</td>\n",
       "      <td>49</td>\n",
       "      <td>19850705</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>2019147</th>\n",
       "      <td>1580919</td>\n",
       "      <td>2</td>\n",
       "      <td>DORIAN BRITO MEDEIROS</td>\n",
       "      <td>***857131**</td>\n",
       "      <td>49</td>\n",
       "      <td>19850705</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>60575784</td>\n",
       "      <td>2</td>\n",
       "      <td>CARLOS MANUEL ROCHA DE OLIVEIRA FREITAS</td>\n",
       "      <td>***363108**</td>\n",
       "      <td>49</td>\n",
       "      <td>19871214</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>2019149 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         44969517  2                          SERGIO MONTEIRO     ***828488**  \\\n",
       "0        44969517  1      FEMARA PARTICIPACOES E NEGOCIOS S/A  18320263000143   \n",
       "1        81215345  2                          ROBERTO PADILHA     ***461879**   \n",
       "2        81215345  2               VILMA CARVALHO DE OLIVEIRA     ***378579**   \n",
       "3        81218885  2                            NATAL MANENTI     ***904839**   \n",
       "4        81218885  2            BERNADETE DAMASCENO DANDOLINI     ***539929**   \n",
       "...           ... ..                                      ...             ...   \n",
       "2019144   1580969  2        TEOGENES TEMISTOCLES LEAL PEREIRA     ***920763**   \n",
       "2019145   1580969  2            ANDREIA LEAL PEREIRA MESQUITA     ***071073**   \n",
       "2019146   1580919  2                 FRANCISCO ASSIS DA SILVA     ***601191**   \n",
       "2019147   1580919  2                    DORIAN BRITO MEDEIROS     ***857131**   \n",
       "2019148  60575784  2  CARLOS MANUEL ROCHA DE OLIVEIRA FREITAS     ***363108**   \n",
       "\n",
       "         49  19951103  Unnamed: 6  ***000000**       Unnamed: 8  00  5  \n",
       "0        22  20131007         NaN  ***828488**  SERGIO MONTEIRO   5  0  \n",
       "1        49  20010711         NaN  ***000000**              NaN   0  6  \n",
       "2        22  20010711         NaN  ***461879**  ROBERTO PADILHA   5  7  \n",
       "3        49  19900209         NaN  ***000000**              NaN   0  6  \n",
       "4        22  19900209         NaN  ***000000**              NaN   0  7  \n",
       "...      ..       ...         ...          ...              ...  .. ..  \n",
       "2019144  49  20160301         NaN  ***000000**              NaN   0  5  \n",
       "2019145  22  20160301         NaN  ***000000**              NaN   0  5  \n",
       "2019146  49  19850705         NaN  ***000000**              NaN   0  7  \n",
       "2019147  49  19850705         NaN  ***000000**              NaN   0  6  \n",
       "2019148  49  19871214         NaN  ***000000**              NaN   0  8  \n",
       "\n",
       "[2019149 rows x 11 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('socio5.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>44969517</td>\n",
       "      <td>2</td>\n",
       "      <td>SERGIO MONTEIRO</td>\n",
       "      <td>***828488**</td>\n",
       "      <td>49</td>\n",
       "      <td>19951103</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>44969517</td>\n",
       "      <td>1</td>\n",
       "      <td>FEMARA PARTICIPACOES E NEGOCIOS S/A</td>\n",
       "      <td>18320263000143</td>\n",
       "      <td>22</td>\n",
       "      <td>20131007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***828488**</td>\n",
       "      <td>SERGIO MONTEIRO</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>81215345</td>\n",
       "      <td>2</td>\n",
       "      <td>ROBERTO PADILHA</td>\n",
       "      <td>***461879**</td>\n",
       "      <td>49</td>\n",
       "      <td>20010711</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>81215345</td>\n",
       "      <td>2</td>\n",
       "      <td>VILMA CARVALHO DE OLIVEIRA</td>\n",
       "      <td>***378579**</td>\n",
       "      <td>22</td>\n",
       "      <td>20010711</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***461879**</td>\n",
       "      <td>ROBERTO PADILHA</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>81218885</td>\n",
       "      <td>2</td>\n",
       "      <td>NATAL MANENTI</td>\n",
       "      <td>***904839**</td>\n",
       "      <td>49</td>\n",
       "      <td>19900209</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>1580969</td>\n",
       "      <td>2</td>\n",
       "      <td>TEOGENES TEMISTOCLES LEAL PEREIRA</td>\n",
       "      <td>***920763**</td>\n",
       "      <td>49</td>\n",
       "      <td>20160301</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>2019146</th>\n",
       "      <td>1580969</td>\n",
       "      <td>2</td>\n",
       "      <td>ANDREIA LEAL PEREIRA MESQUITA</td>\n",
       "      <td>***071073**</td>\n",
       "      <td>22</td>\n",
       "      <td>20160301</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>2019147</th>\n",
       "      <td>1580919</td>\n",
       "      <td>2</td>\n",
       "      <td>FRANCISCO ASSIS DA SILVA</td>\n",
       "      <td>***601191**</td>\n",
       "      <td>49</td>\n",
       "      <td>19850705</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>2019148</th>\n",
       "      <td>1580919</td>\n",
       "      <td>2</td>\n",
       "      <td>DORIAN BRITO MEDEIROS</td>\n",
       "      <td>***857131**</td>\n",
       "      <td>49</td>\n",
       "      <td>19850705</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>60575784</td>\n",
       "      <td>2</td>\n",
       "      <td>CARLOS MANUEL ROCHA DE OLIVEIRA FREITAS</td>\n",
       "      <td>***363108**</td>\n",
       "      <td>49</td>\n",
       "      <td>19871214</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>2019150 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               0   1                                        2   \\\n",
       "0        44969517   2                          SERGIO MONTEIRO   \n",
       "1        44969517   1      FEMARA PARTICIPACOES E NEGOCIOS S/A   \n",
       "2        81215345   2                          ROBERTO PADILHA   \n",
       "3        81215345   2               VILMA CARVALHO DE OLIVEIRA   \n",
       "4        81218885   2                            NATAL MANENTI   \n",
       "...           ...  ..                                      ...   \n",
       "2019145   1580969   2        TEOGENES TEMISTOCLES LEAL PEREIRA   \n",
       "2019146   1580969   2            ANDREIA LEAL PEREIRA MESQUITA   \n",
       "2019147   1580919   2                 FRANCISCO ASSIS DA SILVA   \n",
       "2019148   1580919   2                    DORIAN BRITO MEDEIROS   \n",
       "2019149  60575784   2  CARLOS MANUEL ROCHA DE OLIVEIRA FREITAS   \n",
       "\n",
       "                     3   4         5   6            7                8   9   \\\n",
       "0           ***828488**  49  19951103 NaN  ***000000**              NaN   0   \n",
       "1        18320263000143  22  20131007 NaN  ***828488**  SERGIO MONTEIRO   5   \n",
       "2           ***461879**  49  20010711 NaN  ***000000**              NaN   0   \n",
       "3           ***378579**  22  20010711 NaN  ***461879**  ROBERTO PADILHA   5   \n",
       "4           ***904839**  49  19900209 NaN  ***000000**              NaN   0   \n",
       "...                 ...  ..       ...  ..          ...              ...  ..   \n",
       "2019145     ***920763**  49  20160301 NaN  ***000000**              NaN   0   \n",
       "2019146     ***071073**  22  20160301 NaN  ***000000**              NaN   0   \n",
       "2019147     ***601191**  49  19850705 NaN  ***000000**              NaN   0   \n",
       "2019148     ***857131**  49  19850705 NaN  ***000000**              NaN   0   \n",
       "2019149     ***363108**  49  19871214 NaN  ***000000**              NaN   0   \n",
       "\n",
       "         10  \n",
       "0         5  \n",
       "1         0  \n",
       "2         6  \n",
       "3         7  \n",
       "4         6  \n",
       "...      ..  \n",
       "2019145   5  \n",
       "2019146   5  \n",
       "2019147   7  \n",
       "2019148   6  \n",
       "2019149   8  \n",
       "\n",
       "[2019150 rows x 11 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('socio5.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>44969517</td>\n",
       "      <td>2</td>\n",
       "      <td>SERGIO MONTEIRO</td>\n",
       "      <td>***828488**</td>\n",
       "      <td>49</td>\n",
       "      <td>19951103</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>44969517</td>\n",
       "      <td>1</td>\n",
       "      <td>FEMARA PARTICIPACOES E NEGOCIOS S/A</td>\n",
       "      <td>18320263000143</td>\n",
       "      <td>22</td>\n",
       "      <td>20131007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***828488**</td>\n",
       "      <td>SERGIO MONTEIRO</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>81215345</td>\n",
       "      <td>2</td>\n",
       "      <td>ROBERTO PADILHA</td>\n",
       "      <td>***461879**</td>\n",
       "      <td>49</td>\n",
       "      <td>20010711</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>81215345</td>\n",
       "      <td>2</td>\n",
       "      <td>VILMA CARVALHO DE OLIVEIRA</td>\n",
       "      <td>***378579**</td>\n",
       "      <td>22</td>\n",
       "      <td>20010711</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***461879**</td>\n",
       "      <td>ROBERTO PADILHA</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>81218885</td>\n",
       "      <td>2</td>\n",
       "      <td>NATAL MANENTI</td>\n",
       "      <td>***904839**</td>\n",
       "      <td>49</td>\n",
       "      <td>19900209</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>1580969</td>\n",
       "      <td>2</td>\n",
       "      <td>TEOGENES TEMISTOCLES LEAL PEREIRA</td>\n",
       "      <td>***920763**</td>\n",
       "      <td>49</td>\n",
       "      <td>20160301</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>2019146</th>\n",
       "      <td>1580969</td>\n",
       "      <td>2</td>\n",
       "      <td>ANDREIA LEAL PEREIRA MESQUITA</td>\n",
       "      <td>***071073**</td>\n",
       "      <td>22</td>\n",
       "      <td>20160301</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>2019147</th>\n",
       "      <td>1580919</td>\n",
       "      <td>2</td>\n",
       "      <td>FRANCISCO ASSIS DA SILVA</td>\n",
       "      <td>***601191**</td>\n",
       "      <td>49</td>\n",
       "      <td>19850705</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>2019148</th>\n",
       "      <td>1580919</td>\n",
       "      <td>2</td>\n",
       "      <td>DORIAN BRITO MEDEIROS</td>\n",
       "      <td>***857131**</td>\n",
       "      <td>49</td>\n",
       "      <td>19850705</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>60575784</td>\n",
       "      <td>2</td>\n",
       "      <td>CARLOS MANUEL ROCHA DE OLIVEIRA FREITAS</td>\n",
       "      <td>***363108**</td>\n",
       "      <td>49</td>\n",
       "      <td>19871214</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>2019150 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ  INDEFICADOR MATRIZ/FILIAL  \\\n",
       "0        44969517                          2   \n",
       "1        44969517                          1   \n",
       "2        81215345                          2   \n",
       "3        81215345                          2   \n",
       "4        81218885                          2   \n",
       "...           ...                        ...   \n",
       "2019145   1580969                          2   \n",
       "2019146   1580969                          2   \n",
       "2019147   1580919                          2   \n",
       "2019148   1580919                          2   \n",
       "2019149  60575784                          2   \n",
       "\n",
       "                                    RAZÃO SOCIAL   NOME FANTASIA  \\\n",
       "0                                SERGIO MONTEIRO     ***828488**   \n",
       "1            FEMARA PARTICIPACOES E NEGOCIOS S/A  18320263000143   \n",
       "2                                ROBERTO PADILHA     ***461879**   \n",
       "3                     VILMA CARVALHO DE OLIVEIRA     ***378579**   \n",
       "4                                  NATAL MANENTI     ***904839**   \n",
       "...                                          ...             ...   \n",
       "2019145        TEOGENES TEMISTOCLES LEAL PEREIRA     ***920763**   \n",
       "2019146            ANDREIA LEAL PEREIRA MESQUITA     ***071073**   \n",
       "2019147                 FRANCISCO ASSIS DA SILVA     ***601191**   \n",
       "2019148                    DORIAN BRITO MEDEIROS     ***857131**   \n",
       "2019149  CARLOS MANUEL ROCHA DE OLIVEIRA FREITAS     ***363108**   \n",
       "\n",
       "         SITUAÇÃO CADASTRAL  DATA SITUAÇÃO CADASTRAL  \\\n",
       "0                        49                 19951103   \n",
       "1                        22                 20131007   \n",
       "2                        49                 20010711   \n",
       "3                        22                 20010711   \n",
       "4                        49                 19900209   \n",
       "...                     ...                      ...   \n",
       "2019145                  49                 20160301   \n",
       "2019146                  22                 20160301   \n",
       "2019147                  49                 19850705   \n",
       "2019148                  49                 19850705   \n",
       "2019149                  49                 19871214   \n",
       "\n",
       "         MOTIVO SITUAÇÃO CADASTRAL      CO-PAÍS CÓDIGO NATUREZA JURIDICA  \\\n",
       "0                              NaN  ***000000**                      NaN   \n",
       "1                              NaN  ***828488**          SERGIO MONTEIRO   \n",
       "2                              NaN  ***000000**                      NaN   \n",
       "3                              NaN  ***461879**          ROBERTO PADILHA   \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                            5            0  \n",
       "2                            0            6  \n",
       "3                            5            7  \n",
       "4                            0            6  \n",
       "...                        ...          ...  \n",
       "2019145                      0            5  \n",
       "2019146                      0            5  \n",
       "2019147                      0            7  \n",
       "2019148                      0            6  \n",
       "2019149                      0            8  \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>44969517</td>\n",
       "      <td>2</td>\n",
       "      <td>SERGIO MONTEIRO</td>\n",
       "      <td>***828488**</td>\n",
       "      <td>49</td>\n",
       "      <td>19951103</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>44969517</td>\n",
       "      <td>1</td>\n",
       "      <td>FEMARA PARTICIPACOES E NEGOCIOS S/A</td>\n",
       "      <td>18320263000143</td>\n",
       "      <td>22</td>\n",
       "      <td>20131007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***828488**</td>\n",
       "      <td>SERGIO MONTEIRO</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>81215345</td>\n",
       "      <td>2</td>\n",
       "      <td>ROBERTO PADILHA</td>\n",
       "      <td>***461879**</td>\n",
       "      <td>49</td>\n",
       "      <td>20010711</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>81215345</td>\n",
       "      <td>2</td>\n",
       "      <td>VILMA CARVALHO DE OLIVEIRA</td>\n",
       "      <td>***378579**</td>\n",
       "      <td>22</td>\n",
       "      <td>20010711</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***461879**</td>\n",
       "      <td>ROBERTO PADILHA</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>81218885</td>\n",
       "      <td>2</td>\n",
       "      <td>NATAL MANENTI</td>\n",
       "      <td>***904839**</td>\n",
       "      <td>49</td>\n",
       "      <td>19900209</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>3223106</td>\n",
       "      <td>2</td>\n",
       "      <td>GANUZIA DAS CHAGAS SANTANA</td>\n",
       "      <td>***213135**</td>\n",
       "      <td>16</td>\n",
       "      <td>20170622</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>2019145</th>\n",
       "      <td>1580969</td>\n",
       "      <td>2</td>\n",
       "      <td>TEOGENES TEMISTOCLES LEAL PEREIRA</td>\n",
       "      <td>***920763**</td>\n",
       "      <td>49</td>\n",
       "      <td>20160301</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>2019146</th>\n",
       "      <td>1580969</td>\n",
       "      <td>2</td>\n",
       "      <td>ANDREIA LEAL PEREIRA MESQUITA</td>\n",
       "      <td>***071073**</td>\n",
       "      <td>22</td>\n",
       "      <td>20160301</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>2019147</th>\n",
       "      <td>1580919</td>\n",
       "      <td>2</td>\n",
       "      <td>FRANCISCO ASSIS DA SILVA</td>\n",
       "      <td>***601191**</td>\n",
       "      <td>49</td>\n",
       "      <td>19850705</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>2019148</th>\n",
       "      <td>1580919</td>\n",
       "      <td>2</td>\n",
       "      <td>DORIAN BRITO MEDEIROS</td>\n",
       "      <td>***857131**</td>\n",
       "      <td>49</td>\n",
       "      <td>19850705</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  \\\n",
       "0        44969517                          2   \n",
       "1        44969517                          1   \n",
       "2        81215345                          2   \n",
       "3        81215345                          2   \n",
       "4        81218885                          2   \n",
       "...           ...                        ...   \n",
       "2019144   3223106                          2   \n",
       "2019145   1580969                          2   \n",
       "2019146   1580969                          2   \n",
       "2019147   1580919                          2   \n",
       "2019148   1580919                          2   \n",
       "\n",
       "                                RAZÃO SOCIAL   NOME FANTASIA  \\\n",
       "0                            SERGIO MONTEIRO     ***828488**   \n",
       "1        FEMARA PARTICIPACOES E NEGOCIOS S/A  18320263000143   \n",
       "2                            ROBERTO PADILHA     ***461879**   \n",
       "3                 VILMA CARVALHO DE OLIVEIRA     ***378579**   \n",
       "4                              NATAL MANENTI     ***904839**   \n",
       "...                                      ...             ...   \n",
       "2019144           GANUZIA DAS CHAGAS SANTANA     ***213135**   \n",
       "2019145    TEOGENES TEMISTOCLES LEAL PEREIRA     ***920763**   \n",
       "2019146        ANDREIA LEAL PEREIRA MESQUITA     ***071073**   \n",
       "2019147             FRANCISCO ASSIS DA SILVA     ***601191**   \n",
       "2019148                DORIAN BRITO MEDEIROS     ***857131**   \n",
       "\n",
       "         SITUAÇÃO CADASTRAL  DATA SITUAÇÃO CADASTRAL  \\\n",
       "0                        49                 19951103   \n",
       "1                        22                 20131007   \n",
       "2                        49                 20010711   \n",
       "3                        22                 20010711   \n",
       "4                        49                 19900209   \n",
       "...                     ...                      ...   \n",
       "2019144                  16                 20170622   \n",
       "2019145                  49                 20160301   \n",
       "2019146                  22                 20160301   \n",
       "2019147                  49                 19850705   \n",
       "2019148                  49                 19850705   \n",
       "\n",
       "         MOTIVO SITUAÇÃO CADASTRAL      CO-PAÍS CÓDIGO NATUREZA JURIDICA  \\\n",
       "0                              NaN  ***000000**                      NaN   \n",
       "1                              NaN  ***828488**          SERGIO MONTEIRO   \n",
       "2                              NaN  ***000000**                      NaN   \n",
       "3                              NaN  ***461879**          ROBERTO PADILHA   \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                            5            0  \n",
       "2                            0            6  \n",
       "3                            5            7  \n",
       "4                            0            6  \n",
       "...                        ...          ...  \n",
       "2019144                      0            5  \n",
       "2019145                      0            5  \n",
       "2019146                      0            5  \n",
       "2019147                      0            7  \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>44969517</td>\n",
       "      <td>2</td>\n",
       "      <td>SERGIO MONTEIRO</td>\n",
       "      <td>***828488**</td>\n",
       "      <td>49</td>\n",
       "      <td>19951103</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>44969517</td>\n",
       "      <td>1</td>\n",
       "      <td>FEMARA PARTICIPACOES E NEGOCIOS S/A</td>\n",
       "      <td>18320263000143</td>\n",
       "      <td>22</td>\n",
       "      <td>20131007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***828488**</td>\n",
       "      <td>SERGIO MONTEIRO</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>81215345</td>\n",
       "      <td>2</td>\n",
       "      <td>ROBERTO PADILHA</td>\n",
       "      <td>***461879**</td>\n",
       "      <td>49</td>\n",
       "      <td>20010711</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>81215345</td>\n",
       "      <td>2</td>\n",
       "      <td>VILMA CARVALHO DE OLIVEIRA</td>\n",
       "      <td>***378579**</td>\n",
       "      <td>22</td>\n",
       "      <td>20010711</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***461879**</td>\n",
       "      <td>ROBERTO PADILHA</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>81218885</td>\n",
       "      <td>2</td>\n",
       "      <td>NATAL MANENTI</td>\n",
       "      <td>***904839**</td>\n",
       "      <td>49</td>\n",
       "      <td>19900209</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>3223106</td>\n",
       "      <td>2</td>\n",
       "      <td>GANUZIA DAS CHAGAS SANTANA</td>\n",
       "      <td>***213135**</td>\n",
       "      <td>16</td>\n",
       "      <td>20170622</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>2019145</th>\n",
       "      <td>1580969</td>\n",
       "      <td>2</td>\n",
       "      <td>TEOGENES TEMISTOCLES LEAL PEREIRA</td>\n",
       "      <td>***920763**</td>\n",
       "      <td>49</td>\n",
       "      <td>20160301</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>2019146</th>\n",
       "      <td>1580969</td>\n",
       "      <td>2</td>\n",
       "      <td>ANDREIA LEAL PEREIRA MESQUITA</td>\n",
       "      <td>***071073**</td>\n",
       "      <td>22</td>\n",
       "      <td>20160301</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>2019147</th>\n",
       "      <td>1580919</td>\n",
       "      <td>2</td>\n",
       "      <td>FRANCISCO ASSIS DA SILVA</td>\n",
       "      <td>***601191**</td>\n",
       "      <td>49</td>\n",
       "      <td>19850705</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>2019148</th>\n",
       "      <td>1580919</td>\n",
       "      <td>2</td>\n",
       "      <td>DORIAN BRITO MEDEIROS</td>\n",
       "      <td>***857131**</td>\n",
       "      <td>49</td>\n",
       "      <td>19850705</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  \\\n",
       "0        44969517                          2   \n",
       "1        44969517                          1   \n",
       "2        81215345                          2   \n",
       "3        81215345                          2   \n",
       "4        81218885                          2   \n",
       "...           ...                        ...   \n",
       "2019144   3223106                          2   \n",
       "2019145   1580969                          2   \n",
       "2019146   1580969                          2   \n",
       "2019147   1580919                          2   \n",
       "2019148   1580919                          2   \n",
       "\n",
       "                                RAZÃO SOCIAL   NOME FANTASIA  \\\n",
       "0                            SERGIO MONTEIRO     ***828488**   \n",
       "1        FEMARA PARTICIPACOES E NEGOCIOS S/A  18320263000143   \n",
       "2                            ROBERTO PADILHA     ***461879**   \n",
       "3                 VILMA CARVALHO DE OLIVEIRA     ***378579**   \n",
       "4                              NATAL MANENTI     ***904839**   \n",
       "...                                      ...             ...   \n",
       "2019144           GANUZIA DAS CHAGAS SANTANA     ***213135**   \n",
       "2019145    TEOGENES TEMISTOCLES LEAL PEREIRA     ***920763**   \n",
       "2019146        ANDREIA LEAL PEREIRA MESQUITA     ***071073**   \n",
       "2019147             FRANCISCO ASSIS DA SILVA     ***601191**   \n",
       "2019148                DORIAN BRITO MEDEIROS     ***857131**   \n",
       "\n",
       "         SITUAÇÃO CADASTRAL  DATA SITUAÇÃO CADASTRAL  \\\n",
       "0                        49                 19951103   \n",
       "1                        22                 20131007   \n",
       "2                        49                 20010711   \n",
       "3                        22                 20010711   \n",
       "4                        49                 19900209   \n",
       "...                     ...                      ...   \n",
       "2019144                  16                 20170622   \n",
       "2019145                  49                 20160301   \n",
       "2019146                  22                 20160301   \n",
       "2019147                  49                 19850705   \n",
       "2019148                  49                 19850705   \n",
       "\n",
       "         MOTIVO SITUAÇÃO CADASTRAL      CO-PAÍS CÓDIGO NATUREZA JURIDICA  \\\n",
       "0                              NaN  ***000000**                      NaN   \n",
       "1                              NaN  ***828488**          SERGIO MONTEIRO   \n",
       "2                              NaN  ***000000**                      NaN   \n",
       "3                              NaN  ***461879**          ROBERTO PADILHA   \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                            5            0  \n",
       "2                            0            6  \n",
       "3                            5            7  \n",
       "4                            0            6  \n",
       "...                        ...          ...  \n",
       "2019144                      0            5  \n",
       "2019145                      0            5  \n",
       "2019146                      0            5  \n",
       "2019147                      0            7  \n",
       "2019148                      0            6  \n",
       "\n",
       "[2019149 rows x 11 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.to_csv('n_socio5.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
}