estabelecimento1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Edson\\AppData\\Local\\Temp\\ipykernel_1592\\1121772681.py:1: DtypeWarning: Columns (8,22,24,26,28) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  df = pd.read_csv('estabelecimento1.csv', encoding = 'latin1', sep = ';')\n"
     ]
    },
    {
     "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>07396865</th>\n",
       "      <th>0001</th>\n",
       "      <th>68</th>\n",
       "      <th>1</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>08</th>\n",
       "      <th>20170210</th>\n",
       "      <th>01</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>...</th>\n",
       "      <th>8297</th>\n",
       "      <th>47</th>\n",
       "      <th>33851125</th>\n",
       "      <th>47.1</th>\n",
       "      <th>33851125.1</th>\n",
       "      <th>47.2</th>\n",
       "      <th>33851125.2</th>\n",
       "      <th>Unnamed: 27</th>\n",
       "      <th>Unnamed: 28</th>\n",
       "      <th>Unnamed: 29</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>64904295</td>\n",
       "      <td>18</td>\n",
       "      <td>51</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20161110</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2785</td>\n",
       "      <td>11.0</td>\n",
       "      <td>36491000</td>\n",
       "      <td>31.0</td>\n",
       "      <td>33880436.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>33118379</td>\n",
       "      <td>CLAUDIO.GIGLIO@CAMIL.COM.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>76016369</td>\n",
       "      <td>3</td>\n",
       "      <td>16</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20231113</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7071</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>52302726</td>\n",
       "      <td>1</td>\n",
       "      <td>82</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20210406</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6131</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7396923</td>\n",
       "      <td>1</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20140115</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7107</td>\n",
       "      <td>11.0</td>\n",
       "      <td>69658088</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3650261</td>\n",
       "      <td>1</td>\n",
       "      <td>45</td>\n",
       "      <td>1</td>\n",
       "      <td>OTICA PERFEICAO</td>\n",
       "      <td>4</td>\n",
       "      <td>20190322</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8113</td>\n",
       "      <td>48.0</td>\n",
       "      <td>2423953</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>48.0</td>\n",
       "      <td>2423953</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <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>4753429</th>\n",
       "      <td>35540760</td>\n",
       "      <td>1</td>\n",
       "      <td>76</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20220107</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7691</td>\n",
       "      <td>44.0</td>\n",
       "      <td>98257068.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753430</th>\n",
       "      <td>38755201</td>\n",
       "      <td>1</td>\n",
       "      <td>71</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20210228</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7097</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>psolriopreto@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753431</th>\n",
       "      <td>27880649</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>RESIDENCIAL VIENA</td>\n",
       "      <td>2</td>\n",
       "      <td>20170420</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8669</td>\n",
       "      <td>54.0</td>\n",
       "      <td>34626517.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CONTATO@EXATAADMINISTRADORA.COM.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753432</th>\n",
       "      <td>38755560</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20210228</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2141</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>avantepocinhos@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>38755068</td>\n",
       "      <td>1</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20210228</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>809</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>JABSALTOFALANTES@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4753434 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         07396865  0001  68  1         Unnamed: 4  08  20170210  01  \\\n",
       "0        64904295    18  51  2                NaN   8  20161110   1   \n",
       "1        76016369     3  16  2                NaN   4  20231113  63   \n",
       "2        52302726     1  82  1                NaN   4  20210406  63   \n",
       "3         7396923     1  53  1                NaN   8  20140115   1   \n",
       "4         3650261     1  45  1    OTICA PERFEICAO   4  20190322  63   \n",
       "...           ...   ...  .. ..                ...  ..       ...  ..   \n",
       "4753429  35540760     1  76  1                NaN   4  20220107  63   \n",
       "4753430  38755201     1  71  1                NaN   8  20210228   1   \n",
       "4753431  27880649     1   9  1  RESIDENCIAL VIENA   2  20170420   0   \n",
       "4753432  38755560     1  29  1                NaN   8  20210228   1   \n",
       "4753433  38755068     1  53  1                NaN   8  20210228   1   \n",
       "\n",
       "        Unnamed: 8  Unnamed: 9  ...  8297    47    33851125  47.1  33851125.1  \\\n",
       "0              NaN         NaN  ...  2785  11.0    36491000  31.0  33880436.0   \n",
       "1              NaN         NaN  ...  7071   NaN         NaN   NaN         NaN   \n",
       "2              NaN         NaN  ...  6131   NaN         NaN   NaN         NaN   \n",
       "3              NaN         NaN  ...  7107  11.0    69658088   NaN         NaN   \n",
       "4              NaN         NaN  ...  8113  48.0     2423953   NaN         NaN   \n",
       "...            ...         ...  ...   ...   ...         ...   ...         ...   \n",
       "4753429        NaN         NaN  ...  7691  44.0  98257068.0   NaN         NaN   \n",
       "4753430        NaN         NaN  ...  7097   0.0         0.0   NaN         NaN   \n",
       "4753431        NaN         NaN  ...  8669  54.0  34626517.0   NaN         NaN   \n",
       "4753432        NaN         NaN  ...  2141   0.0         0.0   NaN         NaN   \n",
       "4753433        NaN         NaN  ...   809   0.0         0.0   NaN         NaN   \n",
       "\n",
       "         47.2 33851125.2                         Unnamed: 27  Unnamed: 28  \\\n",
       "0        82.0   33118379         CLAUDIO.GIGLIO@CAMIL.COM.BR          NaN   \n",
       "1         NaN        NaN                                 NaN          NaN   \n",
       "2         NaN        NaN                                 NaN          NaN   \n",
       "3         NaN        NaN                                 NaN          NaN   \n",
       "4        48.0    2423953                                 NaN          NaN   \n",
       "...       ...        ...                                 ...          ...   \n",
       "4753429   NaN        NaN                                 NaN          NaN   \n",
       "4753430   0.0        0.0              psolriopreto@gmail.com          NaN   \n",
       "4753431   NaN        NaN  CONTATO@EXATAADMINISTRADORA.COM.BR          NaN   \n",
       "4753432   0.0        0.0            avantepocinhos@gmail.com          NaN   \n",
       "4753433   0.0        0.0          JABSALTOFALANTES@GMAIL.COM          NaN   \n",
       "\n",
       "        Unnamed: 29  \n",
       "0               NaN  \n",
       "1               NaN  \n",
       "2               NaN  \n",
       "3               NaN  \n",
       "4               NaN  \n",
       "...             ...  \n",
       "4753429         NaN  \n",
       "4753430         NaN  \n",
       "4753431         NaN  \n",
       "4753432         NaN  \n",
       "4753433         NaN  \n",
       "\n",
       "[4753434 rows x 30 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('estabelecimento1.csv', encoding = 'latin1', sep = ';')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Edson\\AppData\\Local\\Temp\\ipykernel_1592\\2024243377.py:1: DtypeWarning: Columns (8,22,24,26,28) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  df = pd.read_csv('estabelecimento1.csv', encoding = 'latin1', sep = ';', header=None)\n"
     ]
    },
    {
     "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>...</th>\n",
       "      <th>20</th>\n",
       "      <th>21</th>\n",
       "      <th>22</th>\n",
       "      <th>23</th>\n",
       "      <th>24</th>\n",
       "      <th>25</th>\n",
       "      <th>26</th>\n",
       "      <th>27</th>\n",
       "      <th>28</th>\n",
       "      <th>29</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7396865</td>\n",
       "      <td>1</td>\n",
       "      <td>68</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20170210</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8297</td>\n",
       "      <td>47.0</td>\n",
       "      <td>33851125</td>\n",
       "      <td>47.0</td>\n",
       "      <td>33851125.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>33851125</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>64904295</td>\n",
       "      <td>18</td>\n",
       "      <td>51</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20161110</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2785</td>\n",
       "      <td>11.0</td>\n",
       "      <td>36491000</td>\n",
       "      <td>31.0</td>\n",
       "      <td>33880436.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>33118379</td>\n",
       "      <td>CLAUDIO.GIGLIO@CAMIL.COM.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>76016369</td>\n",
       "      <td>3</td>\n",
       "      <td>16</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20231113</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7071</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>52302726</td>\n",
       "      <td>1</td>\n",
       "      <td>82</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20210406</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6131</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7396923</td>\n",
       "      <td>1</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20140115</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7107</td>\n",
       "      <td>11.0</td>\n",
       "      <td>69658088</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <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>4753430</th>\n",
       "      <td>35540760</td>\n",
       "      <td>1</td>\n",
       "      <td>76</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20220107</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7691</td>\n",
       "      <td>44.0</td>\n",
       "      <td>98257068.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753431</th>\n",
       "      <td>38755201</td>\n",
       "      <td>1</td>\n",
       "      <td>71</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20210228</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7097</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>psolriopreto@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753432</th>\n",
       "      <td>27880649</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>RESIDENCIAL VIENA</td>\n",
       "      <td>2</td>\n",
       "      <td>20170420</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8669</td>\n",
       "      <td>54.0</td>\n",
       "      <td>34626517.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CONTATO@EXATAADMINISTRADORA.COM.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>38755560</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20210228</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2141</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>avantepocinhos@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753434</th>\n",
       "      <td>38755068</td>\n",
       "      <td>1</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20210228</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>809</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>JABSALTOFALANTES@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4753435 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               0   1   2   3                  4   5         6   7    8   9   \\\n",
       "0         7396865   1  68   1                NaN   8  20170210   1  NaN NaN   \n",
       "1        64904295  18  51   2                NaN   8  20161110   1  NaN NaN   \n",
       "2        76016369   3  16   2                NaN   4  20231113  63  NaN NaN   \n",
       "3        52302726   1  82   1                NaN   4  20210406  63  NaN NaN   \n",
       "4         7396923   1  53   1                NaN   8  20140115   1  NaN NaN   \n",
       "...           ...  ..  ..  ..                ...  ..       ...  ..  ...  ..   \n",
       "4753430  35540760   1  76   1                NaN   4  20220107  63  NaN NaN   \n",
       "4753431  38755201   1  71   1                NaN   8  20210228   1  NaN NaN   \n",
       "4753432  27880649   1   9   1  RESIDENCIAL VIENA   2  20170420   0  NaN NaN   \n",
       "4753433  38755560   1  29   1                NaN   8  20210228   1  NaN NaN   \n",
       "4753434  38755068   1  53   1                NaN   8  20210228   1  NaN NaN   \n",
       "\n",
       "         ...    20    21          22    23          24    25        26  \\\n",
       "0        ...  8297  47.0    33851125  47.0  33851125.0  47.0  33851125   \n",
       "1        ...  2785  11.0    36491000  31.0  33880436.0  82.0  33118379   \n",
       "2        ...  7071   NaN         NaN   NaN         NaN   NaN       NaN   \n",
       "3        ...  6131   NaN         NaN   NaN         NaN   NaN       NaN   \n",
       "4        ...  7107  11.0    69658088   NaN         NaN   NaN       NaN   \n",
       "...      ...   ...   ...         ...   ...         ...   ...       ...   \n",
       "4753430  ...  7691  44.0  98257068.0   NaN         NaN   NaN       NaN   \n",
       "4753431  ...  7097   0.0         0.0   NaN         NaN   0.0       0.0   \n",
       "4753432  ...  8669  54.0  34626517.0   NaN         NaN   NaN       NaN   \n",
       "4753433  ...  2141   0.0         0.0   NaN         NaN   0.0       0.0   \n",
       "4753434  ...   809   0.0         0.0   NaN         NaN   0.0       0.0   \n",
       "\n",
       "                                         27   28  29  \n",
       "0                                       NaN  NaN NaN  \n",
       "1               CLAUDIO.GIGLIO@CAMIL.COM.BR  NaN NaN  \n",
       "2                                       NaN  NaN NaN  \n",
       "3                                       NaN  NaN NaN  \n",
       "4                                       NaN  NaN NaN  \n",
       "...                                     ...  ...  ..  \n",
       "4753430                                 NaN  NaN NaN  \n",
       "4753431              psolriopreto@gmail.com  NaN NaN  \n",
       "4753432  CONTATO@EXATAADMINISTRADORA.COM.BR  NaN NaN  \n",
       "4753433            avantepocinhos@gmail.com  NaN NaN  \n",
       "4753434          JABSALTOFALANTES@GMAIL.COM  NaN NaN  \n",
       "\n",
       "[4753435 rows x 30 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('estabelecimento1.csv', encoding = 'latin1', 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>DESCRIÇÃO TIPO LOGRADOURO</th>\n",
       "      <th>LOGRADOURO</th>\n",
       "      <th>NUMERO</th>\n",
       "      <th>COMPLEMENTO</th>\n",
       "      <th>BAIRRO</th>\n",
       "      <th>CEP</th>\n",
       "      <th>UF</th>\n",
       "      <th>CODIGO MUNICIPIO</th>\n",
       "      <th>MUNICIPIO</th>\n",
       "      <th>DDD-TELEFONE-1</th>\n",
       "      <th>...</th>\n",
       "      <th>CAPITAL SOCIAL DA EMPRESA</th>\n",
       "      <th>PORTE-EMPRESA</th>\n",
       "      <th>OPÇÃO PELO SIMPLES</th>\n",
       "      <th>DATA OPCAO PELO SIMPLES</th>\n",
       "      <th>DATA EXCLUSÃO DO SIMPLES</th>\n",
       "      <th>OPÇÃO PELO MEI</th>\n",
       "      <th>SITUAÇÃO ESPECIAL</th>\n",
       "      <th>DATA SITUAÇÃO ESPECIAL</th>\n",
       "      <th>FILLER</th>\n",
       "      <th>FIM DE REGISTRO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7396865</td>\n",
       "      <td>1</td>\n",
       "      <td>68</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20170210</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8297</td>\n",
       "      <td>47.0</td>\n",
       "      <td>33851125</td>\n",
       "      <td>47.0</td>\n",
       "      <td>33851125.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>33851125</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>64904295</td>\n",
       "      <td>18</td>\n",
       "      <td>51</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20161110</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2785</td>\n",
       "      <td>11.0</td>\n",
       "      <td>36491000</td>\n",
       "      <td>31.0</td>\n",
       "      <td>33880436.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>33118379</td>\n",
       "      <td>CLAUDIO.GIGLIO@CAMIL.COM.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>76016369</td>\n",
       "      <td>3</td>\n",
       "      <td>16</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20231113</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7071</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>52302726</td>\n",
       "      <td>1</td>\n",
       "      <td>82</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20210406</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6131</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7396923</td>\n",
       "      <td>1</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20140115</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7107</td>\n",
       "      <td>11.0</td>\n",
       "      <td>69658088</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <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>4753430</th>\n",
       "      <td>35540760</td>\n",
       "      <td>1</td>\n",
       "      <td>76</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20220107</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7691</td>\n",
       "      <td>44.0</td>\n",
       "      <td>98257068.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753431</th>\n",
       "      <td>38755201</td>\n",
       "      <td>1</td>\n",
       "      <td>71</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20210228</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7097</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>psolriopreto@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753432</th>\n",
       "      <td>27880649</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>RESIDENCIAL VIENA</td>\n",
       "      <td>2</td>\n",
       "      <td>20170420</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8669</td>\n",
       "      <td>54.0</td>\n",
       "      <td>34626517.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CONTATO@EXATAADMINISTRADORA.COM.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>38755560</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20210228</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2141</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>avantepocinhos@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753434</th>\n",
       "      <td>38755068</td>\n",
       "      <td>1</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20210228</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>809</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>JABSALTOFALANTES@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4753435 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         DESCRIÇÃO TIPO LOGRADOURO  LOGRADOURO  NUMERO  COMPLEMENTO  \\\n",
       "0                          7396865           1      68            1   \n",
       "1                         64904295          18      51            2   \n",
       "2                         76016369           3      16            2   \n",
       "3                         52302726           1      82            1   \n",
       "4                          7396923           1      53            1   \n",
       "...                            ...         ...     ...          ...   \n",
       "4753430                   35540760           1      76            1   \n",
       "4753431                   38755201           1      71            1   \n",
       "4753432                   27880649           1       9            1   \n",
       "4753433                   38755560           1      29            1   \n",
       "4753434                   38755068           1      53            1   \n",
       "\n",
       "                    BAIRRO  CEP        UF  CODIGO MUNICIPIO MUNICIPIO  \\\n",
       "0                      NaN    8  20170210                 1       NaN   \n",
       "1                      NaN    8  20161110                 1       NaN   \n",
       "2                      NaN    4  20231113                63       NaN   \n",
       "3                      NaN    4  20210406                63       NaN   \n",
       "4                      NaN    8  20140115                 1       NaN   \n",
       "...                    ...  ...       ...               ...       ...   \n",
       "4753430                NaN    4  20220107                63       NaN   \n",
       "4753431                NaN    8  20210228                 1       NaN   \n",
       "4753432  RESIDENCIAL VIENA    2  20170420                 0       NaN   \n",
       "4753433                NaN    8  20210228                 1       NaN   \n",
       "4753434                NaN    8  20210228                 1       NaN   \n",
       "\n",
       "         DDD-TELEFONE-1  ...  CAPITAL SOCIAL DA EMPRESA  PORTE-EMPRESA  \\\n",
       "0                   NaN  ...                       8297           47.0   \n",
       "1                   NaN  ...                       2785           11.0   \n",
       "2                   NaN  ...                       7071            NaN   \n",
       "3                   NaN  ...                       6131            NaN   \n",
       "4                   NaN  ...                       7107           11.0   \n",
       "...                 ...  ...                        ...            ...   \n",
       "4753430             NaN  ...                       7691           44.0   \n",
       "4753431             NaN  ...                       7097            0.0   \n",
       "4753432             NaN  ...                       8669           54.0   \n",
       "4753433             NaN  ...                       2141            0.0   \n",
       "4753434             NaN  ...                        809            0.0   \n",
       "\n",
       "        OPÇÃO PELO SIMPLES DATA OPCAO PELO SIMPLES DATA EXCLUSÃO DO SIMPLES  \\\n",
       "0                 33851125                    47.0               33851125.0   \n",
       "1                 36491000                    31.0               33880436.0   \n",
       "2                      NaN                     NaN                      NaN   \n",
       "3                      NaN                     NaN                      NaN   \n",
       "4                 69658088                     NaN                      NaN   \n",
       "...                    ...                     ...                      ...   \n",
       "4753430         98257068.0                     NaN                      NaN   \n",
       "4753431                0.0                     NaN                      NaN   \n",
       "4753432         34626517.0                     NaN                      NaN   \n",
       "4753433                0.0                     NaN                      NaN   \n",
       "4753434                0.0                     NaN                      NaN   \n",
       "\n",
       "        OPÇÃO PELO MEI SITUAÇÃO ESPECIAL              DATA SITUAÇÃO ESPECIAL  \\\n",
       "0                 47.0          33851125                                 NaN   \n",
       "1                 82.0          33118379         CLAUDIO.GIGLIO@CAMIL.COM.BR   \n",
       "2                  NaN               NaN                                 NaN   \n",
       "3                  NaN               NaN                                 NaN   \n",
       "4                  NaN               NaN                                 NaN   \n",
       "...                ...               ...                                 ...   \n",
       "4753430            NaN               NaN                                 NaN   \n",
       "4753431            0.0               0.0              psolriopreto@gmail.com   \n",
       "4753432            NaN               NaN  CONTATO@EXATAADMINISTRADORA.COM.BR   \n",
       "4753433            0.0               0.0            avantepocinhos@gmail.com   \n",
       "4753434            0.0               0.0          JABSALTOFALANTES@GMAIL.COM   \n",
       "\n",
       "         FILLER FIM DE REGISTRO  \n",
       "0           NaN             NaN  \n",
       "1           NaN             NaN  \n",
       "2           NaN             NaN  \n",
       "3           NaN             NaN  \n",
       "4           NaN             NaN  \n",
       "...         ...             ...  \n",
       "4753430     NaN             NaN  \n",
       "4753431     NaN             NaN  \n",
       "4753432     NaN             NaN  \n",
       "4753433     NaN             NaN  \n",
       "4753434     NaN             NaN  \n",
       "\n",
       "[4753435 rows x 30 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns = ['DESCRIÇÃO TIPO LOGRADOURO', 'LOGRADOURO', 'NUMERO', 'COMPLEMENTO', 'BAIRRO', 'CEP',\n",
    "                'UF', 'CODIGO MUNICIPIO', 'MUNICIPIO', 'DDD-TELEFONE-1', 'DDD', 'TELEFONE-1', 'DDD-TELEFONE-2',\n",
    "                'DDD-2', 'TELEFONE-2', 'DDD-FAX', 'NU-DDD-FAX', 'NU-FAX', 'CORREIO ELETRONICO', \n",
    "                'QUALIFICAÇÃO DO RESPONSÁVEL', 'CAPITAL SOCIAL DA EMPRESA', 'PORTE-EMPRESA', 'OPÇÃO PELO SIMPLES',\n",
    "                'DATA OPCAO PELO SIMPLES', 'DATA EXCLUSÃO DO SIMPLES', 'OPÇÃO PELO MEI', 'SITUAÇÃO ESPECIAL',\n",
    "                'DATA SITUAÇÃO ESPECIAL', 'FILLER', 'FIM DE REGISTRO']\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>DESCRIÇÃO TIPO LOGRADOURO</th>\n",
       "      <th>LOGRADOURO</th>\n",
       "      <th>NUMERO</th>\n",
       "      <th>COMPLEMENTO</th>\n",
       "      <th>BAIRRO</th>\n",
       "      <th>CEP</th>\n",
       "      <th>UF</th>\n",
       "      <th>CODIGO MUNICIPIO</th>\n",
       "      <th>MUNICIPIO</th>\n",
       "      <th>DDD-TELEFONE-1</th>\n",
       "      <th>...</th>\n",
       "      <th>CAPITAL SOCIAL DA EMPRESA</th>\n",
       "      <th>PORTE-EMPRESA</th>\n",
       "      <th>OPÇÃO PELO SIMPLES</th>\n",
       "      <th>DATA OPCAO PELO SIMPLES</th>\n",
       "      <th>DATA EXCLUSÃO DO SIMPLES</th>\n",
       "      <th>OPÇÃO PELO MEI</th>\n",
       "      <th>SITUAÇÃO ESPECIAL</th>\n",
       "      <th>DATA SITUAÇÃO ESPECIAL</th>\n",
       "      <th>FILLER</th>\n",
       "      <th>FIM DE REGISTRO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7396865</td>\n",
       "      <td>1</td>\n",
       "      <td>68</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20170210</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8297</td>\n",
       "      <td>47.0</td>\n",
       "      <td>33851125</td>\n",
       "      <td>47.0</td>\n",
       "      <td>33851125.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>33851125</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>64904295</td>\n",
       "      <td>18</td>\n",
       "      <td>51</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20161110</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2785</td>\n",
       "      <td>11.0</td>\n",
       "      <td>36491000</td>\n",
       "      <td>31.0</td>\n",
       "      <td>33880436.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>33118379</td>\n",
       "      <td>CLAUDIO.GIGLIO@CAMIL.COM.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>76016369</td>\n",
       "      <td>3</td>\n",
       "      <td>16</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20231113</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7071</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>52302726</td>\n",
       "      <td>1</td>\n",
       "      <td>82</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20210406</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6131</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7396923</td>\n",
       "      <td>1</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20140115</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7107</td>\n",
       "      <td>11.0</td>\n",
       "      <td>69658088</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <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>4753429</th>\n",
       "      <td>35540182</td>\n",
       "      <td>1</td>\n",
       "      <td>78</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20220112</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5901</td>\n",
       "      <td>21.0</td>\n",
       "      <td>21266286.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ROBSONGAJR@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753430</th>\n",
       "      <td>35540760</td>\n",
       "      <td>1</td>\n",
       "      <td>76</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20220107</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7691</td>\n",
       "      <td>44.0</td>\n",
       "      <td>98257068.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753431</th>\n",
       "      <td>38755201</td>\n",
       "      <td>1</td>\n",
       "      <td>71</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20210228</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7097</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>psolriopreto@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753432</th>\n",
       "      <td>27880649</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>RESIDENCIAL VIENA</td>\n",
       "      <td>2</td>\n",
       "      <td>20170420</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8669</td>\n",
       "      <td>54.0</td>\n",
       "      <td>34626517.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CONTATO@EXATAADMINISTRADORA.COM.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>38755560</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20210228</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2141</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>avantepocinhos@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4753434 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         DESCRIÇÃO TIPO LOGRADOURO  LOGRADOURO  NUMERO  COMPLEMENTO  \\\n",
       "0                          7396865           1      68            1   \n",
       "1                         64904295          18      51            2   \n",
       "2                         76016369           3      16            2   \n",
       "3                         52302726           1      82            1   \n",
       "4                          7396923           1      53            1   \n",
       "...                            ...         ...     ...          ...   \n",
       "4753429                   35540182           1      78            1   \n",
       "4753430                   35540760           1      76            1   \n",
       "4753431                   38755201           1      71            1   \n",
       "4753432                   27880649           1       9            1   \n",
       "4753433                   38755560           1      29            1   \n",
       "\n",
       "                    BAIRRO  CEP        UF  CODIGO MUNICIPIO MUNICIPIO  \\\n",
       "0                      NaN    8  20170210                 1       NaN   \n",
       "1                      NaN    8  20161110                 1       NaN   \n",
       "2                      NaN    4  20231113                63       NaN   \n",
       "3                      NaN    4  20210406                63       NaN   \n",
       "4                      NaN    8  20140115                 1       NaN   \n",
       "...                    ...  ...       ...               ...       ...   \n",
       "4753429                NaN    4  20220112                63       NaN   \n",
       "4753430                NaN    4  20220107                63       NaN   \n",
       "4753431                NaN    8  20210228                 1       NaN   \n",
       "4753432  RESIDENCIAL VIENA    2  20170420                 0       NaN   \n",
       "4753433                NaN    8  20210228                 1       NaN   \n",
       "\n",
       "         DDD-TELEFONE-1  ...  CAPITAL SOCIAL DA EMPRESA  PORTE-EMPRESA  \\\n",
       "0                   NaN  ...                       8297           47.0   \n",
       "1                   NaN  ...                       2785           11.0   \n",
       "2                   NaN  ...                       7071            NaN   \n",
       "3                   NaN  ...                       6131            NaN   \n",
       "4                   NaN  ...                       7107           11.0   \n",
       "...                 ...  ...                        ...            ...   \n",
       "4753429             NaN  ...                       5901           21.0   \n",
       "4753430             NaN  ...                       7691           44.0   \n",
       "4753431             NaN  ...                       7097            0.0   \n",
       "4753432             NaN  ...                       8669           54.0   \n",
       "4753433             NaN  ...                       2141            0.0   \n",
       "\n",
       "        OPÇÃO PELO SIMPLES DATA OPCAO PELO SIMPLES DATA EXCLUSÃO DO SIMPLES  \\\n",
       "0                 33851125                    47.0               33851125.0   \n",
       "1                 36491000                    31.0               33880436.0   \n",
       "2                      NaN                     NaN                      NaN   \n",
       "3                      NaN                     NaN                      NaN   \n",
       "4                 69658088                     NaN                      NaN   \n",
       "...                    ...                     ...                      ...   \n",
       "4753429         21266286.0                     NaN                      NaN   \n",
       "4753430         98257068.0                     NaN                      NaN   \n",
       "4753431                0.0                     NaN                      NaN   \n",
       "4753432         34626517.0                     NaN                      NaN   \n",
       "4753433                0.0                     NaN                      NaN   \n",
       "\n",
       "        OPÇÃO PELO MEI SITUAÇÃO ESPECIAL              DATA SITUAÇÃO ESPECIAL  \\\n",
       "0                 47.0          33851125                                 NaN   \n",
       "1                 82.0          33118379         CLAUDIO.GIGLIO@CAMIL.COM.BR   \n",
       "2                  NaN               NaN                                 NaN   \n",
       "3                  NaN               NaN                                 NaN   \n",
       "4                  NaN               NaN                                 NaN   \n",
       "...                ...               ...                                 ...   \n",
       "4753429            NaN               NaN              ROBSONGAJR@HOTMAIL.COM   \n",
       "4753430            NaN               NaN                                 NaN   \n",
       "4753431            0.0               0.0              psolriopreto@gmail.com   \n",
       "4753432            NaN               NaN  CONTATO@EXATAADMINISTRADORA.COM.BR   \n",
       "4753433            0.0               0.0            avantepocinhos@gmail.com   \n",
       "\n",
       "         FILLER FIM DE REGISTRO  \n",
       "0           NaN             NaN  \n",
       "1           NaN             NaN  \n",
       "2           NaN             NaN  \n",
       "3           NaN             NaN  \n",
       "4           NaN             NaN  \n",
       "...         ...             ...  \n",
       "4753429     NaN             NaN  \n",
       "4753430     NaN             NaN  \n",
       "4753431     NaN             NaN  \n",
       "4753432     NaN             NaN  \n",
       "4753433     NaN             NaN  \n",
       "\n",
       "[4753434 rows x 30 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>DESCRIÇÃO TIPO LOGRADOURO</th>\n",
       "      <th>LOGRADOURO</th>\n",
       "      <th>NUMERO</th>\n",
       "      <th>COMPLEMENTO</th>\n",
       "      <th>BAIRRO</th>\n",
       "      <th>CEP</th>\n",
       "      <th>UF</th>\n",
       "      <th>CODIGO MUNICIPIO</th>\n",
       "      <th>MUNICIPIO</th>\n",
       "      <th>DDD-TELEFONE-1</th>\n",
       "      <th>...</th>\n",
       "      <th>CAPITAL SOCIAL DA EMPRESA</th>\n",
       "      <th>PORTE-EMPRESA</th>\n",
       "      <th>OPÇÃO PELO SIMPLES</th>\n",
       "      <th>DATA OPCAO PELO SIMPLES</th>\n",
       "      <th>DATA EXCLUSÃO DO SIMPLES</th>\n",
       "      <th>OPÇÃO PELO MEI</th>\n",
       "      <th>SITUAÇÃO ESPECIAL</th>\n",
       "      <th>DATA SITUAÇÃO ESPECIAL</th>\n",
       "      <th>FILLER</th>\n",
       "      <th>FIM DE REGISTRO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7396865</td>\n",
       "      <td>1</td>\n",
       "      <td>68</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20170210</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8297</td>\n",
       "      <td>47.0</td>\n",
       "      <td>33851125</td>\n",
       "      <td>47.0</td>\n",
       "      <td>33851125.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>33851125</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>64904295</td>\n",
       "      <td>18</td>\n",
       "      <td>51</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20161110</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2785</td>\n",
       "      <td>11.0</td>\n",
       "      <td>36491000</td>\n",
       "      <td>31.0</td>\n",
       "      <td>33880436.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>33118379</td>\n",
       "      <td>CLAUDIO.GIGLIO@CAMIL.COM.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>76016369</td>\n",
       "      <td>3</td>\n",
       "      <td>16</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20231113</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7071</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>52302726</td>\n",
       "      <td>1</td>\n",
       "      <td>82</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20210406</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6131</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7396923</td>\n",
       "      <td>1</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20140115</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7107</td>\n",
       "      <td>11.0</td>\n",
       "      <td>69658088</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <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>4753429</th>\n",
       "      <td>35540182</td>\n",
       "      <td>1</td>\n",
       "      <td>78</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20220112</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5901</td>\n",
       "      <td>21.0</td>\n",
       "      <td>21266286.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ROBSONGAJR@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753430</th>\n",
       "      <td>35540760</td>\n",
       "      <td>1</td>\n",
       "      <td>76</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20220107</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7691</td>\n",
       "      <td>44.0</td>\n",
       "      <td>98257068.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753431</th>\n",
       "      <td>38755201</td>\n",
       "      <td>1</td>\n",
       "      <td>71</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20210228</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7097</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>psolriopreto@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753432</th>\n",
       "      <td>27880649</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>RESIDENCIAL VIENA</td>\n",
       "      <td>2</td>\n",
       "      <td>20170420</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8669</td>\n",
       "      <td>54.0</td>\n",
       "      <td>34626517.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CONTATO@EXATAADMINISTRADORA.COM.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>38755560</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20210228</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2141</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>avantepocinhos@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4753434 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         DESCRIÇÃO TIPO LOGRADOURO  LOGRADOURO  NUMERO  COMPLEMENTO  \\\n",
       "0                          7396865           1      68            1   \n",
       "1                         64904295          18      51            2   \n",
       "2                         76016369           3      16            2   \n",
       "3                         52302726           1      82            1   \n",
       "4                          7396923           1      53            1   \n",
       "...                            ...         ...     ...          ...   \n",
       "4753429                   35540182           1      78            1   \n",
       "4753430                   35540760           1      76            1   \n",
       "4753431                   38755201           1      71            1   \n",
       "4753432                   27880649           1       9            1   \n",
       "4753433                   38755560           1      29            1   \n",
       "\n",
       "                    BAIRRO  CEP        UF  CODIGO MUNICIPIO MUNICIPIO  \\\n",
       "0                      NaN    8  20170210                 1       NaN   \n",
       "1                      NaN    8  20161110                 1       NaN   \n",
       "2                      NaN    4  20231113                63       NaN   \n",
       "3                      NaN    4  20210406                63       NaN   \n",
       "4                      NaN    8  20140115                 1       NaN   \n",
       "...                    ...  ...       ...               ...       ...   \n",
       "4753429                NaN    4  20220112                63       NaN   \n",
       "4753430                NaN    4  20220107                63       NaN   \n",
       "4753431                NaN    8  20210228                 1       NaN   \n",
       "4753432  RESIDENCIAL VIENA    2  20170420                 0       NaN   \n",
       "4753433                NaN    8  20210228                 1       NaN   \n",
       "\n",
       "         DDD-TELEFONE-1  ...  CAPITAL SOCIAL DA EMPRESA  PORTE-EMPRESA  \\\n",
       "0                   NaN  ...                       8297           47.0   \n",
       "1                   NaN  ...                       2785           11.0   \n",
       "2                   NaN  ...                       7071            NaN   \n",
       "3                   NaN  ...                       6131            NaN   \n",
       "4                   NaN  ...                       7107           11.0   \n",
       "...                 ...  ...                        ...            ...   \n",
       "4753429             NaN  ...                       5901           21.0   \n",
       "4753430             NaN  ...                       7691           44.0   \n",
       "4753431             NaN  ...                       7097            0.0   \n",
       "4753432             NaN  ...                       8669           54.0   \n",
       "4753433             NaN  ...                       2141            0.0   \n",
       "\n",
       "        OPÇÃO PELO SIMPLES DATA OPCAO PELO SIMPLES DATA EXCLUSÃO DO SIMPLES  \\\n",
       "0                 33851125                    47.0               33851125.0   \n",
       "1                 36491000                    31.0               33880436.0   \n",
       "2                      NaN                     NaN                      NaN   \n",
       "3                      NaN                     NaN                      NaN   \n",
       "4                 69658088                     NaN                      NaN   \n",
       "...                    ...                     ...                      ...   \n",
       "4753429         21266286.0                     NaN                      NaN   \n",
       "4753430         98257068.0                     NaN                      NaN   \n",
       "4753431                0.0                     NaN                      NaN   \n",
       "4753432         34626517.0                     NaN                      NaN   \n",
       "4753433                0.0                     NaN                      NaN   \n",
       "\n",
       "        OPÇÃO PELO MEI SITUAÇÃO ESPECIAL              DATA SITUAÇÃO ESPECIAL  \\\n",
       "0                 47.0          33851125                                 NaN   \n",
       "1                 82.0          33118379         CLAUDIO.GIGLIO@CAMIL.COM.BR   \n",
       "2                  NaN               NaN                                 NaN   \n",
       "3                  NaN               NaN                                 NaN   \n",
       "4                  NaN               NaN                                 NaN   \n",
       "...                ...               ...                                 ...   \n",
       "4753429            NaN               NaN              ROBSONGAJR@HOTMAIL.COM   \n",
       "4753430            NaN               NaN                                 NaN   \n",
       "4753431            0.0               0.0              psolriopreto@gmail.com   \n",
       "4753432            NaN               NaN  CONTATO@EXATAADMINISTRADORA.COM.BR   \n",
       "4753433            0.0               0.0            avantepocinhos@gmail.com   \n",
       "\n",
       "         FILLER FIM DE REGISTRO  \n",
       "0           NaN             NaN  \n",
       "1           NaN             NaN  \n",
       "2           NaN             NaN  \n",
       "3           NaN             NaN  \n",
       "4           NaN             NaN  \n",
       "...         ...             ...  \n",
       "4753429     NaN             NaN  \n",
       "4753430     NaN             NaN  \n",
       "4753431     NaN             NaN  \n",
       "4753432     NaN             NaN  \n",
       "4753433     NaN             NaN  \n",
       "\n",
       "[4753434 rows x 30 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.to_csv('n_estabelecimento1.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
}