socio3.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>20314772</th>\n",
       "      <th>2</th>\n",
       "      <th>JUCELIO DA SILVA SANTOS</th>\n",
       "      <th>***998905**</th>\n",
       "      <th>49</th>\n",
       "      <th>20140523</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "      <th>***000000**</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>0</th>\n",
       "      <th>5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>21729597</td>\n",
       "      <td>2</td>\n",
       "      <td>DANIELA CARVALHO MENEZES LEAL</td>\n",
       "      <td>***430665**</td>\n",
       "      <td>49</td>\n",
       "      <td>20150121</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>22201398</td>\n",
       "      <td>2</td>\n",
       "      <td>GEORGE BATISTA DE JESUS</td>\n",
       "      <td>***661225**</td>\n",
       "      <td>49</td>\n",
       "      <td>20230926</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>17278344</td>\n",
       "      <td>2</td>\n",
       "      <td>GERALDO FERREIRA SOBRINHO</td>\n",
       "      <td>***793356**</td>\n",
       "      <td>49</td>\n",
       "      <td>20121119</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>3</th>\n",
       "      <td>17278344</td>\n",
       "      <td>2</td>\n",
       "      <td>VANILDA FELIX REGINATTO</td>\n",
       "      <td>***377828**</td>\n",
       "      <td>49</td>\n",
       "      <td>20121119</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>17278344</td>\n",
       "      <td>2</td>\n",
       "      <td>WILSON ROBERTO MOREIRA AMORIM</td>\n",
       "      <td>***605408**</td>\n",
       "      <td>22</td>\n",
       "      <td>20121119</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>6073099</td>\n",
       "      <td>2</td>\n",
       "      <td>RAMON IURY DA SILVA RODRIGUES</td>\n",
       "      <td>***423328**</td>\n",
       "      <td>22</td>\n",
       "      <td>20031202</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>1048571</th>\n",
       "      <td>2668172</td>\n",
       "      <td>2</td>\n",
       "      <td>DAIANE APARECIDA MAFESSONI THOMAZ</td>\n",
       "      <td>***895439**</td>\n",
       "      <td>16</td>\n",
       "      <td>20210707</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>6073113</td>\n",
       "      <td>2</td>\n",
       "      <td>ELWIS POLETTO BORGES</td>\n",
       "      <td>***026992**</td>\n",
       "      <td>22</td>\n",
       "      <td>20040113</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>6073113</td>\n",
       "      <td>2</td>\n",
       "      <td>LUIZ CARLOS POLETTO</td>\n",
       "      <td>***782389**</td>\n",
       "      <td>49</td>\n",
       "      <td>20040113</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>1048574</th>\n",
       "      <td>4401110</td>\n",
       "      <td>2</td>\n",
       "      <td>IONE APARECIDA DOS SANTOS PINHEIRO</td>\n",
       "      <td>***587919**</td>\n",
       "      <td>49</td>\n",
       "      <td>20010416</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>1048575 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         20314772  2             JUCELIO DA SILVA SANTOS  ***998905**  49  \\\n",
       "0        21729597  2       DANIELA CARVALHO MENEZES LEAL  ***430665**  49   \n",
       "1        22201398  2             GEORGE BATISTA DE JESUS  ***661225**  49   \n",
       "2        17278344  2           GERALDO FERREIRA SOBRINHO  ***793356**  49   \n",
       "3        17278344  2             VANILDA FELIX REGINATTO  ***377828**  49   \n",
       "4        17278344  2       WILSON ROBERTO MOREIRA AMORIM  ***605408**  22   \n",
       "...           ... ..                                 ...          ...  ..   \n",
       "1048570   6073099  2       RAMON IURY DA SILVA RODRIGUES  ***423328**  22   \n",
       "1048571   2668172  2   DAIANE APARECIDA MAFESSONI THOMAZ  ***895439**  16   \n",
       "1048572   6073113  2                ELWIS POLETTO BORGES  ***026992**  22   \n",
       "1048573   6073113  2                 LUIZ CARLOS POLETTO  ***782389**  49   \n",
       "1048574   4401110  2  IONE APARECIDA DOS SANTOS PINHEIRO  ***587919**  49   \n",
       "\n",
       "         20140523  Unnamed: 6  ***000000** Unnamed: 8  0  5  \n",
       "0        20150121         NaN  ***000000**        NaN  0  5  \n",
       "1        20230926         NaN  ***000000**        NaN  0  5  \n",
       "2        20121119         NaN  ***000000**        NaN  0  7  \n",
       "3        20121119         NaN  ***000000**        NaN  0  6  \n",
       "4        20121119         NaN  ***000000**        NaN  0  7  \n",
       "...           ...         ...          ...        ... .. ..  \n",
       "1048570  20031202         NaN  ***000000**        NaN  0  5  \n",
       "1048571  20210707         NaN  ***000000**        NaN  0  4  \n",
       "1048572  20040113         NaN  ***000000**        NaN  0  5  \n",
       "1048573  20040113         NaN  ***000000**        NaN  0  6  \n",
       "1048574  20010416         NaN  ***000000**        NaN  0  6  \n",
       "\n",
       "[1048575 rows x 11 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('socio3.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>20314772</td>\n",
       "      <td>2</td>\n",
       "      <td>JUCELIO DA SILVA SANTOS</td>\n",
       "      <td>***998905**</td>\n",
       "      <td>49</td>\n",
       "      <td>20140523</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>21729597</td>\n",
       "      <td>2</td>\n",
       "      <td>DANIELA CARVALHO MENEZES LEAL</td>\n",
       "      <td>***430665**</td>\n",
       "      <td>49</td>\n",
       "      <td>20150121</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>22201398</td>\n",
       "      <td>2</td>\n",
       "      <td>GEORGE BATISTA DE JESUS</td>\n",
       "      <td>***661225**</td>\n",
       "      <td>49</td>\n",
       "      <td>20230926</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>17278344</td>\n",
       "      <td>2</td>\n",
       "      <td>GERALDO FERREIRA SOBRINHO</td>\n",
       "      <td>***793356**</td>\n",
       "      <td>49</td>\n",
       "      <td>20121119</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>17278344</td>\n",
       "      <td>2</td>\n",
       "      <td>VANILDA FELIX REGINATTO</td>\n",
       "      <td>***377828**</td>\n",
       "      <td>49</td>\n",
       "      <td>20121119</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>1048571</th>\n",
       "      <td>6073099</td>\n",
       "      <td>2</td>\n",
       "      <td>RAMON IURY DA SILVA RODRIGUES</td>\n",
       "      <td>***423328**</td>\n",
       "      <td>22</td>\n",
       "      <td>20031202</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>2668172</td>\n",
       "      <td>2</td>\n",
       "      <td>DAIANE APARECIDA MAFESSONI THOMAZ</td>\n",
       "      <td>***895439**</td>\n",
       "      <td>16</td>\n",
       "      <td>20210707</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>6073113</td>\n",
       "      <td>2</td>\n",
       "      <td>ELWIS POLETTO BORGES</td>\n",
       "      <td>***026992**</td>\n",
       "      <td>22</td>\n",
       "      <td>20040113</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>6073113</td>\n",
       "      <td>2</td>\n",
       "      <td>LUIZ CARLOS POLETTO</td>\n",
       "      <td>***782389**</td>\n",
       "      <td>49</td>\n",
       "      <td>20040113</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>1048575</th>\n",
       "      <td>4401110</td>\n",
       "      <td>2</td>\n",
       "      <td>IONE APARECIDA DOS SANTOS PINHEIRO</td>\n",
       "      <td>***587919**</td>\n",
       "      <td>49</td>\n",
       "      <td>20010416</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>1048576 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               0   1                                   2            3   4   \\\n",
       "0        20314772   2             JUCELIO DA SILVA SANTOS  ***998905**  49   \n",
       "1        21729597   2       DANIELA CARVALHO MENEZES LEAL  ***430665**  49   \n",
       "2        22201398   2             GEORGE BATISTA DE JESUS  ***661225**  49   \n",
       "3        17278344   2           GERALDO FERREIRA SOBRINHO  ***793356**  49   \n",
       "4        17278344   2             VANILDA FELIX REGINATTO  ***377828**  49   \n",
       "...           ...  ..                                 ...          ...  ..   \n",
       "1048571   6073099   2       RAMON IURY DA SILVA RODRIGUES  ***423328**  22   \n",
       "1048572   2668172   2   DAIANE APARECIDA MAFESSONI THOMAZ  ***895439**  16   \n",
       "1048573   6073113   2                ELWIS POLETTO BORGES  ***026992**  22   \n",
       "1048574   6073113   2                 LUIZ CARLOS POLETTO  ***782389**  49   \n",
       "1048575   4401110   2  IONE APARECIDA DOS SANTOS PINHEIRO  ***587919**  49   \n",
       "\n",
       "               5   6            7    8   9   10  \n",
       "0        20140523 NaN  ***000000**  NaN   0   5  \n",
       "1        20150121 NaN  ***000000**  NaN   0   5  \n",
       "2        20230926 NaN  ***000000**  NaN   0   5  \n",
       "3        20121119 NaN  ***000000**  NaN   0   7  \n",
       "4        20121119 NaN  ***000000**  NaN   0   6  \n",
       "...           ...  ..          ...  ...  ..  ..  \n",
       "1048571  20031202 NaN  ***000000**  NaN   0   5  \n",
       "1048572  20210707 NaN  ***000000**  NaN   0   4  \n",
       "1048573  20040113 NaN  ***000000**  NaN   0   5  \n",
       "1048574  20040113 NaN  ***000000**  NaN   0   6  \n",
       "1048575  20010416 NaN  ***000000**  NaN   0   6  \n",
       "\n",
       "[1048576 rows x 11 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('socio3.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>20314772</td>\n",
       "      <td>2</td>\n",
       "      <td>JUCELIO DA SILVA SANTOS</td>\n",
       "      <td>***998905**</td>\n",
       "      <td>49</td>\n",
       "      <td>20140523</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>21729597</td>\n",
       "      <td>2</td>\n",
       "      <td>DANIELA CARVALHO MENEZES LEAL</td>\n",
       "      <td>***430665**</td>\n",
       "      <td>49</td>\n",
       "      <td>20150121</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>22201398</td>\n",
       "      <td>2</td>\n",
       "      <td>GEORGE BATISTA DE JESUS</td>\n",
       "      <td>***661225**</td>\n",
       "      <td>49</td>\n",
       "      <td>20230926</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>17278344</td>\n",
       "      <td>2</td>\n",
       "      <td>GERALDO FERREIRA SOBRINHO</td>\n",
       "      <td>***793356**</td>\n",
       "      <td>49</td>\n",
       "      <td>20121119</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>17278344</td>\n",
       "      <td>2</td>\n",
       "      <td>VANILDA FELIX REGINATTO</td>\n",
       "      <td>***377828**</td>\n",
       "      <td>49</td>\n",
       "      <td>20121119</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>1048571</th>\n",
       "      <td>6073099</td>\n",
       "      <td>2</td>\n",
       "      <td>RAMON IURY DA SILVA RODRIGUES</td>\n",
       "      <td>***423328**</td>\n",
       "      <td>22</td>\n",
       "      <td>20031202</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>2668172</td>\n",
       "      <td>2</td>\n",
       "      <td>DAIANE APARECIDA MAFESSONI THOMAZ</td>\n",
       "      <td>***895439**</td>\n",
       "      <td>16</td>\n",
       "      <td>20210707</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>6073113</td>\n",
       "      <td>2</td>\n",
       "      <td>ELWIS POLETTO BORGES</td>\n",
       "      <td>***026992**</td>\n",
       "      <td>22</td>\n",
       "      <td>20040113</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>6073113</td>\n",
       "      <td>2</td>\n",
       "      <td>LUIZ CARLOS POLETTO</td>\n",
       "      <td>***782389**</td>\n",
       "      <td>49</td>\n",
       "      <td>20040113</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>1048575</th>\n",
       "      <td>4401110</td>\n",
       "      <td>2</td>\n",
       "      <td>IONE APARECIDA DOS SANTOS PINHEIRO</td>\n",
       "      <td>***587919**</td>\n",
       "      <td>49</td>\n",
       "      <td>20010416</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>1048576 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ  INDEFICADOR MATRIZ/FILIAL  \\\n",
       "0        20314772                          2   \n",
       "1        21729597                          2   \n",
       "2        22201398                          2   \n",
       "3        17278344                          2   \n",
       "4        17278344                          2   \n",
       "...           ...                        ...   \n",
       "1048571   6073099                          2   \n",
       "1048572   2668172                          2   \n",
       "1048573   6073113                          2   \n",
       "1048574   6073113                          2   \n",
       "1048575   4401110                          2   \n",
       "\n",
       "                               RAZÃO SOCIAL NOME FANTASIA  SITUAÇÃO CADASTRAL  \\\n",
       "0                   JUCELIO DA SILVA SANTOS   ***998905**                  49   \n",
       "1             DANIELA CARVALHO MENEZES LEAL   ***430665**                  49   \n",
       "2                   GEORGE BATISTA DE JESUS   ***661225**                  49   \n",
       "3                 GERALDO FERREIRA SOBRINHO   ***793356**                  49   \n",
       "4                   VANILDA FELIX REGINATTO   ***377828**                  49   \n",
       "...                                     ...           ...                 ...   \n",
       "1048571       RAMON IURY DA SILVA RODRIGUES   ***423328**                  22   \n",
       "1048572   DAIANE APARECIDA MAFESSONI THOMAZ   ***895439**                  16   \n",
       "1048573                ELWIS POLETTO BORGES   ***026992**                  22   \n",
       "1048574                 LUIZ CARLOS POLETTO   ***782389**                  49   \n",
       "1048575  IONE APARECIDA DOS SANTOS PINHEIRO   ***587919**                  49   \n",
       "\n",
       "         DATA SITUAÇÃO CADASTRAL  MOTIVO SITUAÇÃO CADASTRAL      CO-PAÍS  \\\n",
       "0                       20140523                        NaN  ***000000**   \n",
       "1                       20150121                        NaN  ***000000**   \n",
       "2                       20230926                        NaN  ***000000**   \n",
       "3                       20121119                        NaN  ***000000**   \n",
       "4                       20121119                        NaN  ***000000**   \n",
       "...                          ...                        ...          ...   \n",
       "1048571                 20031202                        NaN  ***000000**   \n",
       "1048572                 20210707                        NaN  ***000000**   \n",
       "1048573                 20040113                        NaN  ***000000**   \n",
       "1048574                 20040113                        NaN  ***000000**   \n",
       "1048575                 20010416                        NaN  ***000000**   \n",
       "\n",
       "        CÓDIGO NATUREZA JURIDICA  DATA INICIO ATIVIDADE  CNAE-FISCAL  \n",
       "0                            NaN                      0            5  \n",
       "1                            NaN                      0            5  \n",
       "2                            NaN                      0            5  \n",
       "3                            NaN                      0            7  \n",
       "4                            NaN                      0            6  \n",
       "...                          ...                    ...          ...  \n",
       "1048571                      NaN                      0            5  \n",
       "1048572                      NaN                      0            4  \n",
       "1048573                      NaN                      0            5  \n",
       "1048574                      NaN                      0            6  \n",
       "1048575                      NaN                      0            6  \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>20314772</td>\n",
       "      <td>2</td>\n",
       "      <td>JUCELIO DA SILVA SANTOS</td>\n",
       "      <td>***998905**</td>\n",
       "      <td>49</td>\n",
       "      <td>20140523</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>21729597</td>\n",
       "      <td>2</td>\n",
       "      <td>DANIELA CARVALHO MENEZES LEAL</td>\n",
       "      <td>***430665**</td>\n",
       "      <td>49</td>\n",
       "      <td>20150121</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>22201398</td>\n",
       "      <td>2</td>\n",
       "      <td>GEORGE BATISTA DE JESUS</td>\n",
       "      <td>***661225**</td>\n",
       "      <td>49</td>\n",
       "      <td>20230926</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>17278344</td>\n",
       "      <td>2</td>\n",
       "      <td>GERALDO FERREIRA SOBRINHO</td>\n",
       "      <td>***793356**</td>\n",
       "      <td>49</td>\n",
       "      <td>20121119</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>17278344</td>\n",
       "      <td>2</td>\n",
       "      <td>VANILDA FELIX REGINATTO</td>\n",
       "      <td>***377828**</td>\n",
       "      <td>49</td>\n",
       "      <td>20121119</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>1048570</th>\n",
       "      <td>6073099</td>\n",
       "      <td>2</td>\n",
       "      <td>CLAUDIA HELENA RIBEIRO RODRIGUES</td>\n",
       "      <td>***154369**</td>\n",
       "      <td>49</td>\n",
       "      <td>20031202</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>1048571</th>\n",
       "      <td>6073099</td>\n",
       "      <td>2</td>\n",
       "      <td>RAMON IURY DA SILVA RODRIGUES</td>\n",
       "      <td>***423328**</td>\n",
       "      <td>22</td>\n",
       "      <td>20031202</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>2668172</td>\n",
       "      <td>2</td>\n",
       "      <td>DAIANE APARECIDA MAFESSONI THOMAZ</td>\n",
       "      <td>***895439**</td>\n",
       "      <td>16</td>\n",
       "      <td>20210707</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>6073113</td>\n",
       "      <td>2</td>\n",
       "      <td>ELWIS POLETTO BORGES</td>\n",
       "      <td>***026992**</td>\n",
       "      <td>22</td>\n",
       "      <td>20040113</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>6073113</td>\n",
       "      <td>2</td>\n",
       "      <td>LUIZ CARLOS POLETTO</td>\n",
       "      <td>***782389**</td>\n",
       "      <td>49</td>\n",
       "      <td>20040113</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>1048575 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ  INDEFICADOR MATRIZ/FILIAL  \\\n",
       "0        20314772                          2   \n",
       "1        21729597                          2   \n",
       "2        22201398                          2   \n",
       "3        17278344                          2   \n",
       "4        17278344                          2   \n",
       "...           ...                        ...   \n",
       "1048570   6073099                          2   \n",
       "1048571   6073099                          2   \n",
       "1048572   2668172                          2   \n",
       "1048573   6073113                          2   \n",
       "1048574   6073113                          2   \n",
       "\n",
       "                              RAZÃO SOCIAL NOME FANTASIA  SITUAÇÃO CADASTRAL  \\\n",
       "0                  JUCELIO DA SILVA SANTOS   ***998905**                  49   \n",
       "1            DANIELA CARVALHO MENEZES LEAL   ***430665**                  49   \n",
       "2                  GEORGE BATISTA DE JESUS   ***661225**                  49   \n",
       "3                GERALDO FERREIRA SOBRINHO   ***793356**                  49   \n",
       "4                  VANILDA FELIX REGINATTO   ***377828**                  49   \n",
       "...                                    ...           ...                 ...   \n",
       "1048570   CLAUDIA HELENA RIBEIRO RODRIGUES   ***154369**                  49   \n",
       "1048571      RAMON IURY DA SILVA RODRIGUES   ***423328**                  22   \n",
       "1048572  DAIANE APARECIDA MAFESSONI THOMAZ   ***895439**                  16   \n",
       "1048573               ELWIS POLETTO BORGES   ***026992**                  22   \n",
       "1048574                LUIZ CARLOS POLETTO   ***782389**                  49   \n",
       "\n",
       "         DATA SITUAÇÃO CADASTRAL  MOTIVO SITUAÇÃO CADASTRAL      CO-PAÍS  \\\n",
       "0                       20140523                        NaN  ***000000**   \n",
       "1                       20150121                        NaN  ***000000**   \n",
       "2                       20230926                        NaN  ***000000**   \n",
       "3                       20121119                        NaN  ***000000**   \n",
       "4                       20121119                        NaN  ***000000**   \n",
       "...                          ...                        ...          ...   \n",
       "1048570                 20031202                        NaN  ***000000**   \n",
       "1048571                 20031202                        NaN  ***000000**   \n",
       "1048572                 20210707                        NaN  ***000000**   \n",
       "1048573                 20040113                        NaN  ***000000**   \n",
       "1048574                 20040113                        NaN  ***000000**   \n",
       "\n",
       "        CÓDIGO NATUREZA JURIDICA  DATA INICIO ATIVIDADE  CNAE-FISCAL  \n",
       "0                            NaN                      0            5  \n",
       "1                            NaN                      0            5  \n",
       "2                            NaN                      0            5  \n",
       "3                            NaN                      0            7  \n",
       "4                            NaN                      0            6  \n",
       "...                          ...                    ...          ...  \n",
       "1048570                      NaN                      0            5  \n",
       "1048571                      NaN                      0            5  \n",
       "1048572                      NaN                      0            4  \n",
       "1048573                      NaN                      0            5  \n",
       "1048574                      NaN                      0            6  \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>20314772</td>\n",
       "      <td>2</td>\n",
       "      <td>JUCELIO DA SILVA SANTOS</td>\n",
       "      <td>***998905**</td>\n",
       "      <td>49</td>\n",
       "      <td>20140523</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>21729597</td>\n",
       "      <td>2</td>\n",
       "      <td>DANIELA CARVALHO MENEZES LEAL</td>\n",
       "      <td>***430665**</td>\n",
       "      <td>49</td>\n",
       "      <td>20150121</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>22201398</td>\n",
       "      <td>2</td>\n",
       "      <td>GEORGE BATISTA DE JESUS</td>\n",
       "      <td>***661225**</td>\n",
       "      <td>49</td>\n",
       "      <td>20230926</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>17278344</td>\n",
       "      <td>2</td>\n",
       "      <td>GERALDO FERREIRA SOBRINHO</td>\n",
       "      <td>***793356**</td>\n",
       "      <td>49</td>\n",
       "      <td>20121119</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>17278344</td>\n",
       "      <td>2</td>\n",
       "      <td>VANILDA FELIX REGINATTO</td>\n",
       "      <td>***377828**</td>\n",
       "      <td>49</td>\n",
       "      <td>20121119</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>1048570</th>\n",
       "      <td>6073099</td>\n",
       "      <td>2</td>\n",
       "      <td>CLAUDIA HELENA RIBEIRO RODRIGUES</td>\n",
       "      <td>***154369**</td>\n",
       "      <td>49</td>\n",
       "      <td>20031202</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>1048571</th>\n",
       "      <td>6073099</td>\n",
       "      <td>2</td>\n",
       "      <td>RAMON IURY DA SILVA RODRIGUES</td>\n",
       "      <td>***423328**</td>\n",
       "      <td>22</td>\n",
       "      <td>20031202</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>2668172</td>\n",
       "      <td>2</td>\n",
       "      <td>DAIANE APARECIDA MAFESSONI THOMAZ</td>\n",
       "      <td>***895439**</td>\n",
       "      <td>16</td>\n",
       "      <td>20210707</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>6073113</td>\n",
       "      <td>2</td>\n",
       "      <td>ELWIS POLETTO BORGES</td>\n",
       "      <td>***026992**</td>\n",
       "      <td>22</td>\n",
       "      <td>20040113</td>\n",
       "      <td>NaN</td>\n",
       "      <td>***000000**</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048574</th>\n",
       "      <td>6073113</td>\n",
       "      <td>2</td>\n",
       "      <td>LUIZ CARLOS POLETTO</td>\n",
       "      <td>***782389**</td>\n",
       "      <td>49</td>\n",
       "      <td>20040113</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>1048575 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNPJ  INDEFICADOR MATRIZ/FILIAL  \\\n",
       "0        20314772                          2   \n",
       "1        21729597                          2   \n",
       "2        22201398                          2   \n",
       "3        17278344                          2   \n",
       "4        17278344                          2   \n",
       "...           ...                        ...   \n",
       "1048570   6073099                          2   \n",
       "1048571   6073099                          2   \n",
       "1048572   2668172                          2   \n",
       "1048573   6073113                          2   \n",
       "1048574   6073113                          2   \n",
       "\n",
       "                              RAZÃO SOCIAL NOME FANTASIA  SITUAÇÃO CADASTRAL  \\\n",
       "0                  JUCELIO DA SILVA SANTOS   ***998905**                  49   \n",
       "1            DANIELA CARVALHO MENEZES LEAL   ***430665**                  49   \n",
       "2                  GEORGE BATISTA DE JESUS   ***661225**                  49   \n",
       "3                GERALDO FERREIRA SOBRINHO   ***793356**                  49   \n",
       "4                  VANILDA FELIX REGINATTO   ***377828**                  49   \n",
       "...                                    ...           ...                 ...   \n",
       "1048570   CLAUDIA HELENA RIBEIRO RODRIGUES   ***154369**                  49   \n",
       "1048571      RAMON IURY DA SILVA RODRIGUES   ***423328**                  22   \n",
       "1048572  DAIANE APARECIDA MAFESSONI THOMAZ   ***895439**                  16   \n",
       "1048573               ELWIS POLETTO BORGES   ***026992**                  22   \n",
       "1048574                LUIZ CARLOS POLETTO   ***782389**                  49   \n",
       "\n",
       "         DATA SITUAÇÃO CADASTRAL  MOTIVO SITUAÇÃO CADASTRAL      CO-PAÍS  \\\n",
       "0                       20140523                        NaN  ***000000**   \n",
       "1                       20150121                        NaN  ***000000**   \n",
       "2                       20230926                        NaN  ***000000**   \n",
       "3                       20121119                        NaN  ***000000**   \n",
       "4                       20121119                        NaN  ***000000**   \n",
       "...                          ...                        ...          ...   \n",
       "1048570                 20031202                        NaN  ***000000**   \n",
       "1048571                 20031202                        NaN  ***000000**   \n",
       "1048572                 20210707                        NaN  ***000000**   \n",
       "1048573                 20040113                        NaN  ***000000**   \n",
       "1048574                 20040113                        NaN  ***000000**   \n",
       "\n",
       "        CÓDIGO NATUREZA JURIDICA  DATA INICIO ATIVIDADE  CNAE-FISCAL  \n",
       "0                            NaN                      0            5  \n",
       "1                            NaN                      0            5  \n",
       "2                            NaN                      0            5  \n",
       "3                            NaN                      0            7  \n",
       "4                            NaN                      0            6  \n",
       "...                          ...                    ...          ...  \n",
       "1048570                      NaN                      0            5  \n",
       "1048571                      NaN                      0            5  \n",
       "1048572                      NaN                      0            4  \n",
       "1048573                      NaN                      0            5  \n",
       "1048574                      NaN                      0            6  \n",
       "\n",
       "[1048575 rows x 11 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.to_csv('n_socio3.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
}