socio0.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>17024010</th>\n",
       "      <th>2</th>\n",
       "      <th>ANA PAULA GERVASIO SILVA</th>\n",
       "      <th>***064049**</th>\n",
       "      <th>22</th>\n",
       "      <th>20121011</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "      <th>***000000**</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>0</th>\n",
       "      <th>4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>17024062</td>\n",
       "      <td>2</td>\n",
       "      <td>ONEUR PEDRO NOQUELLI</td>\n",
       "      <td>***251009**</td>\n",
       "      <td>49</td>\n",
       "      <td>20120726</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>1</th>\n",
       "      <td>17024062</td>\n",
       "      <td>2</td>\n",
       "      <td>SAMUEL DA SILVA COSTA</td>\n",
       "      <td>***169299**</td>\n",
       "      <td>22</td>\n",
       "      <td>20130520</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>17024140</td>\n",
       "      <td>2</td>\n",
       "      <td>ADRIANO FERNANDES JARDIM</td>\n",
       "      <td>***957966**</td>\n",
       "      <td>49</td>\n",
       "      <td>20180814</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>3</th>\n",
       "      <td>17024303</td>\n",
       "      <td>2</td>\n",
       "      <td>MARIA APARECIDA RODRIGUES MIRANDA</td>\n",
       "      <td>***821800**</td>\n",
       "      <td>49</td>\n",
       "      <td>20140812</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>4</th>\n",
       "      <td>17024325</td>\n",
       "      <td>1</td>\n",
       "      <td>MRPAR PARTICIPACOES LTDA.</td>\n",
       "      <td>2,1281E+13</td>\n",
       "      <td>22</td>\n",
       "      <td>20141126</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***182348**</td>\n",
       "      <td>PRISCILA ROSSI</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048570</th>\n",
       "      <td>54559847</td>\n",
       "      <td>2</td>\n",
       "      <td>MAYARA MASCARELLO ONETTA QUADRI</td>\n",
       "      <td>***362431**</td>\n",
       "      <td>22</td>\n",
       "      <td>20240402</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048571</th>\n",
       "      <td>54559876</td>\n",
       "      <td>2</td>\n",
       "      <td>ROSENEIA LEAL</td>\n",
       "      <td>***422999**</td>\n",
       "      <td>65</td>\n",
       "      <td>20240402</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048572</th>\n",
       "      <td>54559920</td>\n",
       "      <td>2</td>\n",
       "      <td>DAIANE REGINA CHITOLINA FERRAZ</td>\n",
       "      <td>***133660**</td>\n",
       "      <td>49</td>\n",
       "      <td>20240402</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>1048573</th>\n",
       "      <td>54559930</td>\n",
       "      <td>2</td>\n",
       "      <td>JOEL CARNEIRO DOS SANTOS</td>\n",
       "      <td>***510087**</td>\n",
       "      <td>49</td>\n",
       "      <td>20240402</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>1048574</th>\n",
       "      <td>54559941</td>\n",
       "      <td>2</td>\n",
       "      <td>VICTORIA LOPES PARANHOS GONCALVES PINTO</td>\n",
       "      <td>***992177**</td>\n",
       "      <td>49</td>\n",
       "      <td>20240402</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1048575 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         17024010  2                 ANA PAULA GERVASIO SILVA  ***064049**  \\\n",
       "0        17024062  2                     ONEUR PEDRO NOQUELLI  ***251009**   \n",
       "1        17024062  2                    SAMUEL DA SILVA COSTA  ***169299**   \n",
       "2        17024140  2                 ADRIANO FERNANDES JARDIM  ***957966**   \n",
       "3        17024303  2        MARIA APARECIDA RODRIGUES MIRANDA  ***821800**   \n",
       "4        17024325  1                MRPAR PARTICIPACOES LTDA.   2,1281E+13   \n",
       "...           ... ..                                      ...          ...   \n",
       "1048570  54559847  2          MAYARA MASCARELLO ONETTA QUADRI  ***362431**   \n",
       "1048571  54559876  2                            ROSENEIA LEAL  ***422999**   \n",
       "1048572  54559920  2           DAIANE REGINA CHITOLINA FERRAZ  ***133660**   \n",
       "1048573  54559930  2                 JOEL CARNEIRO DOS SANTOS  ***510087**   \n",
       "1048574  54559941  2  VICTORIA LOPES PARANHOS GONCALVES PINTO  ***992177**   \n",
       "\n",
       "         22  20121011  Unnamed: 6  ***000000**      Unnamed: 8  0  4  \n",
       "0        49  20120726         NaN  ***000000**             NaN  0  7  \n",
       "1        22  20130520         NaN  ***000000**             NaN  0  4  \n",
       "2        49  20180814         NaN  ***000000**             NaN  0  5  \n",
       "3        49  20140812         NaN  ***000000**             NaN  0  7  \n",
       "4        22  20141126         NaN  ***182348**  PRISCILA ROSSI  5  0  \n",
       "...      ..       ...         ...          ...             ... .. ..  \n",
       "1048570  22  20240402         NaN  ***000000**             NaN  0  4  \n",
       "1048571  65  20240402         NaN  ***000000**             NaN  0  5  \n",
       "1048572  49  20240402         NaN  ***000000**             NaN  0  4  \n",
       "1048573  49  20240402         NaN  ***000000**             NaN  0  4  \n",
       "1048574  49  20240402         NaN  ***000000**             NaN  0  3  \n",
       "\n",
       "[1048575 rows x 11 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('socio0.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>17024010</td>\n",
       "      <td>2</td>\n",
       "      <td>ANA PAULA GERVASIO SILVA</td>\n",
       "      <td>***064049**</td>\n",
       "      <td>22</td>\n",
       "      <td>20121011</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>17024062</td>\n",
       "      <td>2</td>\n",
       "      <td>ONEUR PEDRO NOQUELLI</td>\n",
       "      <td>***251009**</td>\n",
       "      <td>49</td>\n",
       "      <td>20120726</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>2</th>\n",
       "      <td>17024062</td>\n",
       "      <td>2</td>\n",
       "      <td>SAMUEL DA SILVA COSTA</td>\n",
       "      <td>***169299**</td>\n",
       "      <td>22</td>\n",
       "      <td>20130520</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>17024140</td>\n",
       "      <td>2</td>\n",
       "      <td>ADRIANO FERNANDES JARDIM</td>\n",
       "      <td>***957966**</td>\n",
       "      <td>49</td>\n",
       "      <td>20180814</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>4</th>\n",
       "      <td>17024303</td>\n",
       "      <td>2</td>\n",
       "      <td>MARIA APARECIDA RODRIGUES MIRANDA</td>\n",
       "      <td>***821800**</td>\n",
       "      <td>49</td>\n",
       "      <td>20140812</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>1048571</th>\n",
       "      <td>54559847</td>\n",
       "      <td>2</td>\n",
       "      <td>MAYARA MASCARELLO ONETTA QUADRI</td>\n",
       "      <td>***362431**</td>\n",
       "      <td>22</td>\n",
       "      <td>20240402</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>1048572</th>\n",
       "      <td>54559876</td>\n",
       "      <td>2</td>\n",
       "      <td>ROSENEIA LEAL</td>\n",
       "      <td>***422999**</td>\n",
       "      <td>65</td>\n",
       "      <td>20240402</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>54559920</td>\n",
       "      <td>2</td>\n",
       "      <td>DAIANE REGINA CHITOLINA FERRAZ</td>\n",
       "      <td>***133660**</td>\n",
       "      <td>49</td>\n",
       "      <td>20240402</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>1048574</th>\n",
       "      <td>54559930</td>\n",
       "      <td>2</td>\n",
       "      <td>JOEL CARNEIRO DOS SANTOS</td>\n",
       "      <td>***510087**</td>\n",
       "      <td>49</td>\n",
       "      <td>20240402</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>1048575</th>\n",
       "      <td>54559941</td>\n",
       "      <td>2</td>\n",
       "      <td>VICTORIA LOPES PARANHOS GONCALVES PINTO</td>\n",
       "      <td>***992177**</td>\n",
       "      <td>49</td>\n",
       "      <td>20240402</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1048576 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               0   1                                        2            3   \\\n",
       "0        17024010   2                 ANA PAULA GERVASIO SILVA  ***064049**   \n",
       "1        17024062   2                     ONEUR PEDRO NOQUELLI  ***251009**   \n",
       "2        17024062   2                    SAMUEL DA SILVA COSTA  ***169299**   \n",
       "3        17024140   2                 ADRIANO FERNANDES JARDIM  ***957966**   \n",
       "4        17024303   2        MARIA APARECIDA RODRIGUES MIRANDA  ***821800**   \n",
       "...           ...  ..                                      ...          ...   \n",
       "1048571  54559847   2          MAYARA MASCARELLO ONETTA QUADRI  ***362431**   \n",
       "1048572  54559876   2                            ROSENEIA LEAL  ***422999**   \n",
       "1048573  54559920   2           DAIANE REGINA CHITOLINA FERRAZ  ***133660**   \n",
       "1048574  54559930   2                 JOEL CARNEIRO DOS SANTOS  ***510087**   \n",
       "1048575  54559941   2  VICTORIA LOPES PARANHOS GONCALVES PINTO  ***992177**   \n",
       "\n",
       "         4         5   6            7    8   9   10  \n",
       "0        22  20121011 NaN  ***000000**  NaN   0   4  \n",
       "1        49  20120726 NaN  ***000000**  NaN   0   7  \n",
       "2        22  20130520 NaN  ***000000**  NaN   0   4  \n",
       "3        49  20180814 NaN  ***000000**  NaN   0   5  \n",
       "4        49  20140812 NaN  ***000000**  NaN   0   7  \n",
       "...      ..       ...  ..          ...  ...  ..  ..  \n",
       "1048571  22  20240402 NaN  ***000000**  NaN   0   4  \n",
       "1048572  65  20240402 NaN  ***000000**  NaN   0   5  \n",
       "1048573  49  20240402 NaN  ***000000**  NaN   0   4  \n",
       "1048574  49  20240402 NaN  ***000000**  NaN   0   4  \n",
       "1048575  49  20240402 NaN  ***000000**  NaN   0   3  \n",
       "\n",
       "[1048576 rows x 11 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('socio0.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>17024010</td>\n",
       "      <td>2</td>\n",
       "      <td>ANA PAULA GERVASIO SILVA</td>\n",
       "      <td>***064049**</td>\n",
       "      <td>22</td>\n",
       "      <td>20121011</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>17024062</td>\n",
       "      <td>2</td>\n",
       "      <td>ONEUR PEDRO NOQUELLI</td>\n",
       "      <td>***251009**</td>\n",
       "      <td>49</td>\n",
       "      <td>20120726</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>2</th>\n",
       "      <td>17024062</td>\n",
       "      <td>2</td>\n",
       "      <td>SAMUEL DA SILVA COSTA</td>\n",
       "      <td>***169299**</td>\n",
       "      <td>22</td>\n",
       "      <td>20130520</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>17024140</td>\n",
       "      <td>2</td>\n",
       "      <td>ADRIANO FERNANDES JARDIM</td>\n",
       "      <td>***957966**</td>\n",
       "      <td>49</td>\n",
       "      <td>20180814</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>4</th>\n",
       "      <td>17024303</td>\n",
       "      <td>2</td>\n",
       "      <td>MARIA APARECIDA RODRIGUES MIRANDA</td>\n",
       "      <td>***821800**</td>\n",
       "      <td>49</td>\n",
       "      <td>20140812</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>1048571</th>\n",
       "      <td>54559847</td>\n",
       "      <td>2</td>\n",
       "      <td>MAYARA MASCARELLO ONETTA QUADRI</td>\n",
       "      <td>***362431**</td>\n",
       "      <td>22</td>\n",
       "      <td>20240402</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>1048572</th>\n",
       "      <td>54559876</td>\n",
       "      <td>2</td>\n",
       "      <td>ROSENEIA LEAL</td>\n",
       "      <td>***422999**</td>\n",
       "      <td>65</td>\n",
       "      <td>20240402</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>54559920</td>\n",
       "      <td>2</td>\n",
       "      <td>DAIANE REGINA CHITOLINA FERRAZ</td>\n",
       "      <td>***133660**</td>\n",
       "      <td>49</td>\n",
       "      <td>20240402</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>1048574</th>\n",
       "      <td>54559930</td>\n",
       "      <td>2</td>\n",
       "      <td>JOEL CARNEIRO DOS SANTOS</td>\n",
       "      <td>***510087**</td>\n",
       "      <td>49</td>\n",
       "      <td>20240402</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>1048575</th>\n",
       "      <td>54559941</td>\n",
       "      <td>2</td>\n",
       "      <td>VICTORIA LOPES PARANHOS GONCALVES PINTO</td>\n",
       "      <td>***992177**</td>\n",
       "      <td>49</td>\n",
       "      <td>20240402</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1048576 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ  INDEFICADOR MATRIZ/FILIAL  \\\n",
       "0        17024010                          2   \n",
       "1        17024062                          2   \n",
       "2        17024062                          2   \n",
       "3        17024140                          2   \n",
       "4        17024303                          2   \n",
       "...           ...                        ...   \n",
       "1048571  54559847                          2   \n",
       "1048572  54559876                          2   \n",
       "1048573  54559920                          2   \n",
       "1048574  54559930                          2   \n",
       "1048575  54559941                          2   \n",
       "\n",
       "                                    RAZÃO SOCIAL NOME FANTASIA  \\\n",
       "0                       ANA PAULA GERVASIO SILVA   ***064049**   \n",
       "1                           ONEUR PEDRO NOQUELLI   ***251009**   \n",
       "2                          SAMUEL DA SILVA COSTA   ***169299**   \n",
       "3                       ADRIANO FERNANDES JARDIM   ***957966**   \n",
       "4              MARIA APARECIDA RODRIGUES MIRANDA   ***821800**   \n",
       "...                                          ...           ...   \n",
       "1048571          MAYARA MASCARELLO ONETTA QUADRI   ***362431**   \n",
       "1048572                            ROSENEIA LEAL   ***422999**   \n",
       "1048573           DAIANE REGINA CHITOLINA FERRAZ   ***133660**   \n",
       "1048574                 JOEL CARNEIRO DOS SANTOS   ***510087**   \n",
       "1048575  VICTORIA LOPES PARANHOS GONCALVES PINTO   ***992177**   \n",
       "\n",
       "         SITUAÇÃO CADASTRAL  DATA SITUAÇÃO CADASTRAL  \\\n",
       "0                        22                 20121011   \n",
       "1                        49                 20120726   \n",
       "2                        22                 20130520   \n",
       "3                        49                 20180814   \n",
       "4                        49                 20140812   \n",
       "...                     ...                      ...   \n",
       "1048571                  22                 20240402   \n",
       "1048572                  65                 20240402   \n",
       "1048573                  49                 20240402   \n",
       "1048574                  49                 20240402   \n",
       "1048575                  49                 20240402   \n",
       "\n",
       "         MOTIVO SITUAÇÃO CADASTRAL      CO-PAÍS CÓDIGO NATUREZA JURIDICA  \\\n",
       "0                              NaN  ***000000**                      NaN   \n",
       "1                              NaN  ***000000**                      NaN   \n",
       "2                              NaN  ***000000**                      NaN   \n",
       "3                              NaN  ***000000**                      NaN   \n",
       "4                              NaN  ***000000**                      NaN   \n",
       "...                            ...          ...                      ...   \n",
       "1048571                        NaN  ***000000**                      NaN   \n",
       "1048572                        NaN  ***000000**                      NaN   \n",
       "1048573                        NaN  ***000000**                      NaN   \n",
       "1048574                        NaN  ***000000**                      NaN   \n",
       "1048575                        NaN  ***000000**                      NaN   \n",
       "\n",
       "         DATA INICIO ATIVIDADE  CNAE-FISCAL  \n",
       "0                            0            4  \n",
       "1                            0            7  \n",
       "2                            0            4  \n",
       "3                            0            5  \n",
       "4                            0            7  \n",
       "...                        ...          ...  \n",
       "1048571                      0            4  \n",
       "1048572                      0            5  \n",
       "1048573                      0            4  \n",
       "1048574                      0            4  \n",
       "1048575                      0            3  \n",
       "\n",
       "[1048576 rows x 11 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns = ['CNPJ', 'INDEFICADOR MATRIZ/FILIAL', 'RAZÃO SOCIAL', 'NOME FANTASIA', 'SITUAÇÃO CADASTRAL',\n",
    "              'DATA SITUAÇÃO CADASTRAL', 'MOTIVO SITUAÇÃO CADASTRAL', 'CO-PAÍS', \n",
    "              'CÓDIGO NATUREZA JURIDICA', 'DATA INICIO ATIVIDADE', 'CNAE-FISCAL']\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CNPJ</th>\n",
       "      <th>INDEFICADOR MATRIZ/FILIAL</th>\n",
       "      <th>RAZÃO SOCIAL</th>\n",
       "      <th>NOME FANTASIA</th>\n",
       "      <th>SITUAÇÃO CADASTRAL</th>\n",
       "      <th>DATA SITUAÇÃO CADASTRAL</th>\n",
       "      <th>MOTIVO SITUAÇÃO CADASTRAL</th>\n",
       "      <th>CO-PAÍS</th>\n",
       "      <th>CÓDIGO NATUREZA JURIDICA</th>\n",
       "      <th>DATA INICIO ATIVIDADE</th>\n",
       "      <th>CNAE-FISCAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>17024010</td>\n",
       "      <td>2</td>\n",
       "      <td>ANA PAULA GERVASIO SILVA</td>\n",
       "      <td>***064049**</td>\n",
       "      <td>22</td>\n",
       "      <td>20121011</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>17024062</td>\n",
       "      <td>2</td>\n",
       "      <td>ONEUR PEDRO NOQUELLI</td>\n",
       "      <td>***251009**</td>\n",
       "      <td>49</td>\n",
       "      <td>20120726</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>2</th>\n",
       "      <td>17024062</td>\n",
       "      <td>2</td>\n",
       "      <td>SAMUEL DA SILVA COSTA</td>\n",
       "      <td>***169299**</td>\n",
       "      <td>22</td>\n",
       "      <td>20130520</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>17024140</td>\n",
       "      <td>2</td>\n",
       "      <td>ADRIANO FERNANDES JARDIM</td>\n",
       "      <td>***957966**</td>\n",
       "      <td>49</td>\n",
       "      <td>20180814</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>4</th>\n",
       "      <td>17024303</td>\n",
       "      <td>2</td>\n",
       "      <td>MARIA APARECIDA RODRIGUES MIRANDA</td>\n",
       "      <td>***821800**</td>\n",
       "      <td>49</td>\n",
       "      <td>20140812</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>1048570</th>\n",
       "      <td>54559847</td>\n",
       "      <td>2</td>\n",
       "      <td>KEVIN HAIDUK DE SOUZA</td>\n",
       "      <td>***229089**</td>\n",
       "      <td>49</td>\n",
       "      <td>20240402</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>1048571</th>\n",
       "      <td>54559847</td>\n",
       "      <td>2</td>\n",
       "      <td>MAYARA MASCARELLO ONETTA QUADRI</td>\n",
       "      <td>***362431**</td>\n",
       "      <td>22</td>\n",
       "      <td>20240402</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>1048572</th>\n",
       "      <td>54559876</td>\n",
       "      <td>2</td>\n",
       "      <td>ROSENEIA LEAL</td>\n",
       "      <td>***422999**</td>\n",
       "      <td>65</td>\n",
       "      <td>20240402</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>54559920</td>\n",
       "      <td>2</td>\n",
       "      <td>DAIANE REGINA CHITOLINA FERRAZ</td>\n",
       "      <td>***133660**</td>\n",
       "      <td>49</td>\n",
       "      <td>20240402</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>1048574</th>\n",
       "      <td>54559930</td>\n",
       "      <td>2</td>\n",
       "      <td>JOEL CARNEIRO DOS SANTOS</td>\n",
       "      <td>***510087**</td>\n",
       "      <td>49</td>\n",
       "      <td>20240402</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1048575 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ  INDEFICADOR MATRIZ/FILIAL  \\\n",
       "0        17024010                          2   \n",
       "1        17024062                          2   \n",
       "2        17024062                          2   \n",
       "3        17024140                          2   \n",
       "4        17024303                          2   \n",
       "...           ...                        ...   \n",
       "1048570  54559847                          2   \n",
       "1048571  54559847                          2   \n",
       "1048572  54559876                          2   \n",
       "1048573  54559920                          2   \n",
       "1048574  54559930                          2   \n",
       "\n",
       "                              RAZÃO SOCIAL NOME FANTASIA  SITUAÇÃO CADASTRAL  \\\n",
       "0                 ANA PAULA GERVASIO SILVA   ***064049**                  22   \n",
       "1                     ONEUR PEDRO NOQUELLI   ***251009**                  49   \n",
       "2                    SAMUEL DA SILVA COSTA   ***169299**                  22   \n",
       "3                 ADRIANO FERNANDES JARDIM   ***957966**                  49   \n",
       "4        MARIA APARECIDA RODRIGUES MIRANDA   ***821800**                  49   \n",
       "...                                    ...           ...                 ...   \n",
       "1048570              KEVIN HAIDUK DE SOUZA   ***229089**                  49   \n",
       "1048571    MAYARA MASCARELLO ONETTA QUADRI   ***362431**                  22   \n",
       "1048572                      ROSENEIA LEAL   ***422999**                  65   \n",
       "1048573     DAIANE REGINA CHITOLINA FERRAZ   ***133660**                  49   \n",
       "1048574           JOEL CARNEIRO DOS SANTOS   ***510087**                  49   \n",
       "\n",
       "         DATA SITUAÇÃO CADASTRAL  MOTIVO SITUAÇÃO CADASTRAL      CO-PAÍS  \\\n",
       "0                       20121011                        NaN  ***000000**   \n",
       "1                       20120726                        NaN  ***000000**   \n",
       "2                       20130520                        NaN  ***000000**   \n",
       "3                       20180814                        NaN  ***000000**   \n",
       "4                       20140812                        NaN  ***000000**   \n",
       "...                          ...                        ...          ...   \n",
       "1048570                 20240402                        NaN  ***000000**   \n",
       "1048571                 20240402                        NaN  ***000000**   \n",
       "1048572                 20240402                        NaN  ***000000**   \n",
       "1048573                 20240402                        NaN  ***000000**   \n",
       "1048574                 20240402                        NaN  ***000000**   \n",
       "\n",
       "        CÓDIGO NATUREZA JURIDICA  DATA INICIO ATIVIDADE  CNAE-FISCAL  \n",
       "0                            NaN                      0            4  \n",
       "1                            NaN                      0            7  \n",
       "2                            NaN                      0            4  \n",
       "3                            NaN                      0            5  \n",
       "4                            NaN                      0            7  \n",
       "...                          ...                    ...          ...  \n",
       "1048570                      NaN                      0            3  \n",
       "1048571                      NaN                      0            4  \n",
       "1048572                      NaN                      0            5  \n",
       "1048573                      NaN                      0            4  \n",
       "1048574                      NaN                      0            4  \n",
       "\n",
       "[1048575 rows x 11 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.drop(df.tail(1).index, inplace=True)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CNPJ</th>\n",
       "      <th>INDEFICADOR MATRIZ/FILIAL</th>\n",
       "      <th>RAZÃO SOCIAL</th>\n",
       "      <th>NOME FANTASIA</th>\n",
       "      <th>SITUAÇÃO CADASTRAL</th>\n",
       "      <th>DATA SITUAÇÃO CADASTRAL</th>\n",
       "      <th>MOTIVO SITUAÇÃO CADASTRAL</th>\n",
       "      <th>CO-PAÍS</th>\n",
       "      <th>CÓDIGO NATUREZA JURIDICA</th>\n",
       "      <th>DATA INICIO ATIVIDADE</th>\n",
       "      <th>CNAE-FISCAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>17024010</td>\n",
       "      <td>2</td>\n",
       "      <td>ANA PAULA GERVASIO SILVA</td>\n",
       "      <td>***064049**</td>\n",
       "      <td>22</td>\n",
       "      <td>20121011</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>17024062</td>\n",
       "      <td>2</td>\n",
       "      <td>ONEUR PEDRO NOQUELLI</td>\n",
       "      <td>***251009**</td>\n",
       "      <td>49</td>\n",
       "      <td>20120726</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>2</th>\n",
       "      <td>17024062</td>\n",
       "      <td>2</td>\n",
       "      <td>SAMUEL DA SILVA COSTA</td>\n",
       "      <td>***169299**</td>\n",
       "      <td>22</td>\n",
       "      <td>20130520</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>17024140</td>\n",
       "      <td>2</td>\n",
       "      <td>ADRIANO FERNANDES JARDIM</td>\n",
       "      <td>***957966**</td>\n",
       "      <td>49</td>\n",
       "      <td>20180814</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>4</th>\n",
       "      <td>17024303</td>\n",
       "      <td>2</td>\n",
       "      <td>MARIA APARECIDA RODRIGUES MIRANDA</td>\n",
       "      <td>***821800**</td>\n",
       "      <td>49</td>\n",
       "      <td>20140812</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>1048570</th>\n",
       "      <td>54559847</td>\n",
       "      <td>2</td>\n",
       "      <td>KEVIN HAIDUK DE SOUZA</td>\n",
       "      <td>***229089**</td>\n",
       "      <td>49</td>\n",
       "      <td>20240402</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>1048571</th>\n",
       "      <td>54559847</td>\n",
       "      <td>2</td>\n",
       "      <td>MAYARA MASCARELLO ONETTA QUADRI</td>\n",
       "      <td>***362431**</td>\n",
       "      <td>22</td>\n",
       "      <td>20240402</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>1048572</th>\n",
       "      <td>54559876</td>\n",
       "      <td>2</td>\n",
       "      <td>ROSENEIA LEAL</td>\n",
       "      <td>***422999**</td>\n",
       "      <td>65</td>\n",
       "      <td>20240402</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048573</th>\n",
       "      <td>54559920</td>\n",
       "      <td>2</td>\n",
       "      <td>DAIANE REGINA CHITOLINA FERRAZ</td>\n",
       "      <td>***133660**</td>\n",
       "      <td>49</td>\n",
       "      <td>20240402</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>1048574</th>\n",
       "      <td>54559930</td>\n",
       "      <td>2</td>\n",
       "      <td>JOEL CARNEIRO DOS SANTOS</td>\n",
       "      <td>***510087**</td>\n",
       "      <td>49</td>\n",
       "      <td>20240402</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1048575 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ  INDEFICADOR MATRIZ/FILIAL  \\\n",
       "0        17024010                          2   \n",
       "1        17024062                          2   \n",
       "2        17024062                          2   \n",
       "3        17024140                          2   \n",
       "4        17024303                          2   \n",
       "...           ...                        ...   \n",
       "1048570  54559847                          2   \n",
       "1048571  54559847                          2   \n",
       "1048572  54559876                          2   \n",
       "1048573  54559920                          2   \n",
       "1048574  54559930                          2   \n",
       "\n",
       "                              RAZÃO SOCIAL NOME FANTASIA  SITUAÇÃO CADASTRAL  \\\n",
       "0                 ANA PAULA GERVASIO SILVA   ***064049**                  22   \n",
       "1                     ONEUR PEDRO NOQUELLI   ***251009**                  49   \n",
       "2                    SAMUEL DA SILVA COSTA   ***169299**                  22   \n",
       "3                 ADRIANO FERNANDES JARDIM   ***957966**                  49   \n",
       "4        MARIA APARECIDA RODRIGUES MIRANDA   ***821800**                  49   \n",
       "...                                    ...           ...                 ...   \n",
       "1048570              KEVIN HAIDUK DE SOUZA   ***229089**                  49   \n",
       "1048571    MAYARA MASCARELLO ONETTA QUADRI   ***362431**                  22   \n",
       "1048572                      ROSENEIA LEAL   ***422999**                  65   \n",
       "1048573     DAIANE REGINA CHITOLINA FERRAZ   ***133660**                  49   \n",
       "1048574           JOEL CARNEIRO DOS SANTOS   ***510087**                  49   \n",
       "\n",
       "         DATA SITUAÇÃO CADASTRAL  MOTIVO SITUAÇÃO CADASTRAL      CO-PAÍS  \\\n",
       "0                       20121011                        NaN  ***000000**   \n",
       "1                       20120726                        NaN  ***000000**   \n",
       "2                       20130520                        NaN  ***000000**   \n",
       "3                       20180814                        NaN  ***000000**   \n",
       "4                       20140812                        NaN  ***000000**   \n",
       "...                          ...                        ...          ...   \n",
       "1048570                 20240402                        NaN  ***000000**   \n",
       "1048571                 20240402                        NaN  ***000000**   \n",
       "1048572                 20240402                        NaN  ***000000**   \n",
       "1048573                 20240402                        NaN  ***000000**   \n",
       "1048574                 20240402                        NaN  ***000000**   \n",
       "\n",
       "        CÓDIGO NATUREZA JURIDICA  DATA INICIO ATIVIDADE  CNAE-FISCAL  \n",
       "0                            NaN                      0            4  \n",
       "1                            NaN                      0            7  \n",
       "2                            NaN                      0            4  \n",
       "3                            NaN                      0            5  \n",
       "4                            NaN                      0            7  \n",
       "...                          ...                    ...          ...  \n",
       "1048570                      NaN                      0            3  \n",
       "1048571                      NaN                      0            4  \n",
       "1048572                      NaN                      0            5  \n",
       "1048573                      NaN                      0            4  \n",
       "1048574                      NaN                      0            4  \n",
       "\n",
       "[1048575 rows x 11 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.to_csv('n_socio0.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
}