estabelecimento5.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_8072\\476079849.py:1: DtypeWarning: Columns (8,21,22,24,26) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  df = pd.read_csv('estabelecimento5.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>65097180</th>\n",
       "      <th>0001</th>\n",
       "      <th>17</th>\n",
       "      <th>1</th>\n",
       "      <th>FAZENDA SANTA BARBARA</th>\n",
       "      <th>08</th>\n",
       "      <th>20020116</th>\n",
       "      <th>54</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>...</th>\n",
       "      <th>4861</th>\n",
       "      <th>Unnamed: 21</th>\n",
       "      <th>Unnamed: 22</th>\n",
       "      <th>Unnamed: 23</th>\n",
       "      <th>Unnamed: 24</th>\n",
       "      <th>Unnamed: 25</th>\n",
       "      <th>Unnamed: 26</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>65097222</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20081231</td>\n",
       "      <td>71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4723</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>1</th>\n",
       "      <td>83759134</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>DANYSAT</td>\n",
       "      <td>8</td>\n",
       "      <td>19990728</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>395</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>48266175</td>\n",
       "      <td>1</td>\n",
       "      <td>71</td>\n",
       "      <td>1</td>\n",
       "      <td>BAR E MERCEARIA SANTO ANTONIO</td>\n",
       "      <td>8</td>\n",
       "      <td>19831214</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7113</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>27793272</td>\n",
       "      <td>1</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20150209</td>\n",
       "      <td>73</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5865</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>65097388</td>\n",
       "      <td>1</td>\n",
       "      <td>36</td>\n",
       "      <td>1</td>\n",
       "      <td>A GATA Q'RI</td>\n",
       "      <td>8</td>\n",
       "      <td>20071210</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4123</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>...</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>51104899</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20230619</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4123</td>\n",
       "      <td>31.0</td>\n",
       "      <td>34356666.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLLIANNAOLIVEIRACOSTA@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753430</th>\n",
       "      <td>48491826</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20221102</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5813</td>\n",
       "      <td>71.0</td>\n",
       "      <td>92936688.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MATHEUS.MCUNHA@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753431</th>\n",
       "      <td>51104920</td>\n",
       "      <td>1</td>\n",
       "      <td>90</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20230619</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7607</td>\n",
       "      <td>42.0</td>\n",
       "      <td>99061715.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CPKOGA@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753432</th>\n",
       "      <td>51104931</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1</td>\n",
       "      <td>ORGANIZA SAUDE</td>\n",
       "      <td>2</td>\n",
       "      <td>20230619</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>3541</td>\n",
       "      <td>71.0</td>\n",
       "      <td>35113234.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ADM@ORGANIZASAUDE.COM.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>51104943</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>PODEMOS LAVINIA-SP</td>\n",
       "      <td>2</td>\n",
       "      <td>20230526</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6631</td>\n",
       "      <td>18.0</td>\n",
       "      <td>91200343.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PODEMOS.LAVINIA.SP@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": [
       "         65097180  0001  17  1          FAZENDA SANTA BARBARA  08  20020116  \\\n",
       "0        65097222     1  10  1                            NaN   8  20081231   \n",
       "1        83759134     1  18  1                        DANYSAT   8  19990728   \n",
       "2        48266175     1  71  1  BAR E MERCEARIA SANTO ANTONIO   8  19831214   \n",
       "3        27793272     1  42  1                            NaN   8  20150209   \n",
       "4        65097388     1  36  1                    A GATA Q'RI   8  20071210   \n",
       "...           ...   ...  .. ..                            ...  ..       ...   \n",
       "4753429  51104899     1  23  1                            NaN   2  20230619   \n",
       "4753430  48491826     1  27  1                            NaN   2  20221102   \n",
       "4753431  51104920     1  90  1                            NaN   2  20230619   \n",
       "4753432  51104931     1  70  1                 ORGANIZA SAUDE   2  20230619   \n",
       "4753433  51104943     1   3  1             PODEMOS LAVINIA-SP   2  20230526   \n",
       "\n",
       "         54 Unnamed: 8  Unnamed: 9  ...  4861  Unnamed: 21 Unnamed: 22  \\\n",
       "0        71        NaN         NaN  ...  4723          NaN         NaN   \n",
       "1         1        NaN         NaN  ...   395          NaN         NaN   \n",
       "2         1        NaN         NaN  ...  7113          NaN         NaN   \n",
       "3        73        NaN         NaN  ...  5865          NaN         NaN   \n",
       "4         1        NaN         NaN  ...  4123          NaN         NaN   \n",
       "...      ..        ...         ...  ...   ...          ...         ...   \n",
       "4753429   0        NaN         NaN  ...  4123         31.0  34356666.0   \n",
       "4753430   0        NaN         NaN  ...  5813         71.0  92936688.0   \n",
       "4753431   0        NaN         NaN  ...  7607         42.0  99061715.0   \n",
       "4753432   0        NaN         NaN  ...  3541         71.0  35113234.0   \n",
       "4753433   0        NaN         NaN  ...  6631         18.0  91200343.0   \n",
       "\n",
       "        Unnamed: 23 Unnamed: 24 Unnamed: 25 Unnamed: 26  \\\n",
       "0               NaN         NaN         NaN         NaN   \n",
       "1               NaN         NaN         NaN         NaN   \n",
       "2               NaN         NaN         NaN         NaN   \n",
       "3               NaN         NaN         NaN         NaN   \n",
       "4               NaN         NaN         NaN         NaN   \n",
       "...             ...         ...         ...         ...   \n",
       "4753429         NaN         NaN         NaN         NaN   \n",
       "4753430         NaN         NaN         NaN         NaN   \n",
       "4753431         NaN         NaN         NaN         NaN   \n",
       "4753432         NaN         NaN         NaN         NaN   \n",
       "4753433         NaN         NaN         NaN         NaN   \n",
       "\n",
       "                              Unnamed: 27  Unnamed: 28 Unnamed: 29  \n",
       "0                                     NaN          NaN         NaN  \n",
       "1                                     NaN          NaN         NaN  \n",
       "2                                     NaN          NaN         NaN  \n",
       "3                                     NaN          NaN         NaN  \n",
       "4                                     NaN          NaN         NaN  \n",
       "...                                   ...          ...         ...  \n",
       "4753429  POLLIANNAOLIVEIRACOSTA@GMAIL.COM          NaN         NaN  \n",
       "4753430        MATHEUS.MCUNHA@HOTMAIL.COM          NaN         NaN  \n",
       "4753431                  CPKOGA@GMAIL.COM          NaN         NaN  \n",
       "4753432          ADM@ORGANIZASAUDE.COM.BR          NaN         NaN  \n",
       "4753433      PODEMOS.LAVINIA.SP@GMAIL.COM          NaN         NaN  \n",
       "\n",
       "[4753434 rows x 30 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('estabelecimento5.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_8072\\2382185783.py:1: DtypeWarning: Columns (8,21,22,24,26) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  df = pd.read_csv('estabelecimento5.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>65097180</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>FAZENDA SANTA BARBARA</td>\n",
       "      <td>8</td>\n",
       "      <td>20020116</td>\n",
       "      <td>54</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4861</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>1</th>\n",
       "      <td>65097222</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20081231</td>\n",
       "      <td>71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4723</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>83759134</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>DANYSAT</td>\n",
       "      <td>8</td>\n",
       "      <td>19990728</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>395</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>48266175</td>\n",
       "      <td>1</td>\n",
       "      <td>71</td>\n",
       "      <td>1</td>\n",
       "      <td>BAR E MERCEARIA SANTO ANTONIO</td>\n",
       "      <td>8</td>\n",
       "      <td>19831214</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7113</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>27793272</td>\n",
       "      <td>1</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20150209</td>\n",
       "      <td>73</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5865</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>...</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>51104899</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20230619</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4123</td>\n",
       "      <td>31.0</td>\n",
       "      <td>34356666.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLLIANNAOLIVEIRACOSTA@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753431</th>\n",
       "      <td>48491826</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20221102</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5813</td>\n",
       "      <td>71.0</td>\n",
       "      <td>92936688.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MATHEUS.MCUNHA@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753432</th>\n",
       "      <td>51104920</td>\n",
       "      <td>1</td>\n",
       "      <td>90</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20230619</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7607</td>\n",
       "      <td>42.0</td>\n",
       "      <td>99061715.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CPKOGA@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>51104931</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1</td>\n",
       "      <td>ORGANIZA SAUDE</td>\n",
       "      <td>2</td>\n",
       "      <td>20230619</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>3541</td>\n",
       "      <td>71.0</td>\n",
       "      <td>35113234.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ADM@ORGANIZASAUDE.COM.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753434</th>\n",
       "      <td>51104943</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>PODEMOS LAVINIA-SP</td>\n",
       "      <td>2</td>\n",
       "      <td>20230526</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6631</td>\n",
       "      <td>18.0</td>\n",
       "      <td>91200343.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PODEMOS.LAVINIA.SP@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   \\\n",
       "0        65097180   1  17   1          FAZENDA SANTA BARBARA   8  20020116   \n",
       "1        65097222   1  10   1                            NaN   8  20081231   \n",
       "2        83759134   1  18   1                        DANYSAT   8  19990728   \n",
       "3        48266175   1  71   1  BAR E MERCEARIA SANTO ANTONIO   8  19831214   \n",
       "4        27793272   1  42   1                            NaN   8  20150209   \n",
       "...           ...  ..  ..  ..                            ...  ..       ...   \n",
       "4753430  51104899   1  23   1                            NaN   2  20230619   \n",
       "4753431  48491826   1  27   1                            NaN   2  20221102   \n",
       "4753432  51104920   1  90   1                            NaN   2  20230619   \n",
       "4753433  51104931   1  70   1                 ORGANIZA SAUDE   2  20230619   \n",
       "4753434  51104943   1   3   1             PODEMOS LAVINIA-SP   2  20230526   \n",
       "\n",
       "         7    8   9   ...    20    21          22  23   24  25   26  \\\n",
       "0        54  NaN NaN  ...  4861   NaN         NaN NaN  NaN NaN  NaN   \n",
       "1        71  NaN NaN  ...  4723   NaN         NaN NaN  NaN NaN  NaN   \n",
       "2         1  NaN NaN  ...   395   NaN         NaN NaN  NaN NaN  NaN   \n",
       "3         1  NaN NaN  ...  7113   NaN         NaN NaN  NaN NaN  NaN   \n",
       "4        73  NaN NaN  ...  5865   NaN         NaN NaN  NaN NaN  NaN   \n",
       "...      ..  ...  ..  ...   ...   ...         ...  ..  ...  ..  ...   \n",
       "4753430   0  NaN NaN  ...  4123  31.0  34356666.0 NaN  NaN NaN  NaN   \n",
       "4753431   0  NaN NaN  ...  5813  71.0  92936688.0 NaN  NaN NaN  NaN   \n",
       "4753432   0  NaN NaN  ...  7607  42.0  99061715.0 NaN  NaN NaN  NaN   \n",
       "4753433   0  NaN NaN  ...  3541  71.0  35113234.0 NaN  NaN NaN  NaN   \n",
       "4753434   0  NaN NaN  ...  6631  18.0  91200343.0 NaN  NaN NaN  NaN   \n",
       "\n",
       "                                       27  28  29  \n",
       "0                                     NaN NaN NaN  \n",
       "1                                     NaN NaN NaN  \n",
       "2                                     NaN NaN NaN  \n",
       "3                                     NaN NaN NaN  \n",
       "4                                     NaN NaN NaN  \n",
       "...                                   ...  ..  ..  \n",
       "4753430  POLLIANNAOLIVEIRACOSTA@GMAIL.COM NaN NaN  \n",
       "4753431        MATHEUS.MCUNHA@HOTMAIL.COM NaN NaN  \n",
       "4753432                  CPKOGA@GMAIL.COM NaN NaN  \n",
       "4753433          ADM@ORGANIZASAUDE.COM.BR NaN NaN  \n",
       "4753434      PODEMOS.LAVINIA.SP@GMAIL.COM NaN NaN  \n",
       "\n",
       "[4753435 rows x 30 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('estabelecimento5.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>65097180</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>FAZENDA SANTA BARBARA</td>\n",
       "      <td>8</td>\n",
       "      <td>20020116</td>\n",
       "      <td>54</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4861</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>1</th>\n",
       "      <td>65097222</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20081231</td>\n",
       "      <td>71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4723</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>83759134</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>DANYSAT</td>\n",
       "      <td>8</td>\n",
       "      <td>19990728</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>395</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>48266175</td>\n",
       "      <td>1</td>\n",
       "      <td>71</td>\n",
       "      <td>1</td>\n",
       "      <td>BAR E MERCEARIA SANTO ANTONIO</td>\n",
       "      <td>8</td>\n",
       "      <td>19831214</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7113</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>27793272</td>\n",
       "      <td>1</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20150209</td>\n",
       "      <td>73</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5865</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>...</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>51104899</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20230619</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4123</td>\n",
       "      <td>31.0</td>\n",
       "      <td>34356666.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLLIANNAOLIVEIRACOSTA@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753431</th>\n",
       "      <td>48491826</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20221102</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5813</td>\n",
       "      <td>71.0</td>\n",
       "      <td>92936688.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MATHEUS.MCUNHA@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753432</th>\n",
       "      <td>51104920</td>\n",
       "      <td>1</td>\n",
       "      <td>90</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20230619</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7607</td>\n",
       "      <td>42.0</td>\n",
       "      <td>99061715.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CPKOGA@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>51104931</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1</td>\n",
       "      <td>ORGANIZA SAUDE</td>\n",
       "      <td>2</td>\n",
       "      <td>20230619</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>3541</td>\n",
       "      <td>71.0</td>\n",
       "      <td>35113234.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ADM@ORGANIZASAUDE.COM.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753434</th>\n",
       "      <td>51104943</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>PODEMOS LAVINIA-SP</td>\n",
       "      <td>2</td>\n",
       "      <td>20230526</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6631</td>\n",
       "      <td>18.0</td>\n",
       "      <td>91200343.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PODEMOS.LAVINIA.SP@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                         65097180           1      17            1   \n",
       "1                         65097222           1      10            1   \n",
       "2                         83759134           1      18            1   \n",
       "3                         48266175           1      71            1   \n",
       "4                         27793272           1      42            1   \n",
       "...                            ...         ...     ...          ...   \n",
       "4753430                   51104899           1      23            1   \n",
       "4753431                   48491826           1      27            1   \n",
       "4753432                   51104920           1      90            1   \n",
       "4753433                   51104931           1      70            1   \n",
       "4753434                   51104943           1       3            1   \n",
       "\n",
       "                                BAIRRO  CEP        UF  CODIGO MUNICIPIO  \\\n",
       "0                FAZENDA SANTA BARBARA    8  20020116                54   \n",
       "1                                  NaN    8  20081231                71   \n",
       "2                              DANYSAT    8  19990728                 1   \n",
       "3        BAR E MERCEARIA SANTO ANTONIO    8  19831214                 1   \n",
       "4                                  NaN    8  20150209                73   \n",
       "...                                ...  ...       ...               ...   \n",
       "4753430                            NaN    2  20230619                 0   \n",
       "4753431                            NaN    2  20221102                 0   \n",
       "4753432                            NaN    2  20230619                 0   \n",
       "4753433                 ORGANIZA SAUDE    2  20230619                 0   \n",
       "4753434             PODEMOS LAVINIA-SP    2  20230526                 0   \n",
       "\n",
       "        MUNICIPIO  DDD-TELEFONE-1  ...  CAPITAL SOCIAL DA EMPRESA  \\\n",
       "0             NaN             NaN  ...                       4861   \n",
       "1             NaN             NaN  ...                       4723   \n",
       "2             NaN             NaN  ...                        395   \n",
       "3             NaN             NaN  ...                       7113   \n",
       "4             NaN             NaN  ...                       5865   \n",
       "...           ...             ...  ...                        ...   \n",
       "4753430       NaN             NaN  ...                       4123   \n",
       "4753431       NaN             NaN  ...                       5813   \n",
       "4753432       NaN             NaN  ...                       7607   \n",
       "4753433       NaN             NaN  ...                       3541   \n",
       "4753434       NaN             NaN  ...                       6631   \n",
       "\n",
       "         PORTE-EMPRESA OPÇÃO PELO SIMPLES DATA OPCAO PELO SIMPLES  \\\n",
       "0                  NaN                NaN                     NaN   \n",
       "1                  NaN                NaN                     NaN   \n",
       "2                  NaN                NaN                     NaN   \n",
       "3                  NaN                NaN                     NaN   \n",
       "4                  NaN                NaN                     NaN   \n",
       "...                ...                ...                     ...   \n",
       "4753430           31.0         34356666.0                     NaN   \n",
       "4753431           71.0         92936688.0                     NaN   \n",
       "4753432           42.0         99061715.0                     NaN   \n",
       "4753433           71.0         35113234.0                     NaN   \n",
       "4753434           18.0         91200343.0                     NaN   \n",
       "\n",
       "        DATA EXCLUSÃO DO SIMPLES OPÇÃO PELO MEI SITUAÇÃO ESPECIAL  \\\n",
       "0                            NaN            NaN               NaN   \n",
       "1                            NaN            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                      NaN            NaN               NaN   \n",
       "4753432                      NaN            NaN               NaN   \n",
       "4753433                      NaN            NaN               NaN   \n",
       "4753434                      NaN            NaN               NaN   \n",
       "\n",
       "                   DATA SITUAÇÃO ESPECIAL  FILLER FIM DE REGISTRO  \n",
       "0                                     NaN     NaN             NaN  \n",
       "1                                     NaN     NaN             NaN  \n",
       "2                                     NaN     NaN             NaN  \n",
       "3                                     NaN     NaN             NaN  \n",
       "4                                     NaN     NaN             NaN  \n",
       "...                                   ...     ...             ...  \n",
       "4753430  POLLIANNAOLIVEIRACOSTA@GMAIL.COM     NaN             NaN  \n",
       "4753431        MATHEUS.MCUNHA@HOTMAIL.COM     NaN             NaN  \n",
       "4753432                  CPKOGA@GMAIL.COM     NaN             NaN  \n",
       "4753433          ADM@ORGANIZASAUDE.COM.BR     NaN             NaN  \n",
       "4753434      PODEMOS.LAVINIA.SP@GMAIL.COM     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>65097180</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>FAZENDA SANTA BARBARA</td>\n",
       "      <td>8</td>\n",
       "      <td>20020116</td>\n",
       "      <td>54</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4861</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>1</th>\n",
       "      <td>65097222</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20081231</td>\n",
       "      <td>71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4723</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>83759134</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>DANYSAT</td>\n",
       "      <td>8</td>\n",
       "      <td>19990728</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>395</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>48266175</td>\n",
       "      <td>1</td>\n",
       "      <td>71</td>\n",
       "      <td>1</td>\n",
       "      <td>BAR E MERCEARIA SANTO ANTONIO</td>\n",
       "      <td>8</td>\n",
       "      <td>19831214</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7113</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>27793272</td>\n",
       "      <td>1</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20150209</td>\n",
       "      <td>73</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5865</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>...</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>51104888</td>\n",
       "      <td>1</td>\n",
       "      <td>43</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20230619</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8233</td>\n",
       "      <td>48.0</td>\n",
       "      <td>99158428.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CAMILAZANOLLA@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753430</th>\n",
       "      <td>51104899</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20230619</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4123</td>\n",
       "      <td>31.0</td>\n",
       "      <td>34356666.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLLIANNAOLIVEIRACOSTA@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753431</th>\n",
       "      <td>48491826</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20221102</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5813</td>\n",
       "      <td>71.0</td>\n",
       "      <td>92936688.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MATHEUS.MCUNHA@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753432</th>\n",
       "      <td>51104920</td>\n",
       "      <td>1</td>\n",
       "      <td>90</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20230619</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7607</td>\n",
       "      <td>42.0</td>\n",
       "      <td>99061715.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CPKOGA@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>51104931</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1</td>\n",
       "      <td>ORGANIZA SAUDE</td>\n",
       "      <td>2</td>\n",
       "      <td>20230619</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>3541</td>\n",
       "      <td>71.0</td>\n",
       "      <td>35113234.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ADM@ORGANIZASAUDE.COM.BR</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                         65097180           1      17            1   \n",
       "1                         65097222           1      10            1   \n",
       "2                         83759134           1      18            1   \n",
       "3                         48266175           1      71            1   \n",
       "4                         27793272           1      42            1   \n",
       "...                            ...         ...     ...          ...   \n",
       "4753429                   51104888           1      43            1   \n",
       "4753430                   51104899           1      23            1   \n",
       "4753431                   48491826           1      27            1   \n",
       "4753432                   51104920           1      90            1   \n",
       "4753433                   51104931           1      70            1   \n",
       "\n",
       "                                BAIRRO  CEP        UF  CODIGO MUNICIPIO  \\\n",
       "0                FAZENDA SANTA BARBARA    8  20020116                54   \n",
       "1                                  NaN    8  20081231                71   \n",
       "2                              DANYSAT    8  19990728                 1   \n",
       "3        BAR E MERCEARIA SANTO ANTONIO    8  19831214                 1   \n",
       "4                                  NaN    8  20150209                73   \n",
       "...                                ...  ...       ...               ...   \n",
       "4753429                            NaN    2  20230619                 0   \n",
       "4753430                            NaN    2  20230619                 0   \n",
       "4753431                            NaN    2  20221102                 0   \n",
       "4753432                            NaN    2  20230619                 0   \n",
       "4753433                 ORGANIZA SAUDE    2  20230619                 0   \n",
       "\n",
       "        MUNICIPIO  DDD-TELEFONE-1  ...  CAPITAL SOCIAL DA EMPRESA  \\\n",
       "0             NaN             NaN  ...                       4861   \n",
       "1             NaN             NaN  ...                       4723   \n",
       "2             NaN             NaN  ...                        395   \n",
       "3             NaN             NaN  ...                       7113   \n",
       "4             NaN             NaN  ...                       5865   \n",
       "...           ...             ...  ...                        ...   \n",
       "4753429       NaN             NaN  ...                       8233   \n",
       "4753430       NaN             NaN  ...                       4123   \n",
       "4753431       NaN             NaN  ...                       5813   \n",
       "4753432       NaN             NaN  ...                       7607   \n",
       "4753433       NaN             NaN  ...                       3541   \n",
       "\n",
       "         PORTE-EMPRESA OPÇÃO PELO SIMPLES DATA OPCAO PELO SIMPLES  \\\n",
       "0                  NaN                NaN                     NaN   \n",
       "1                  NaN                NaN                     NaN   \n",
       "2                  NaN                NaN                     NaN   \n",
       "3                  NaN                NaN                     NaN   \n",
       "4                  NaN                NaN                     NaN   \n",
       "...                ...                ...                     ...   \n",
       "4753429           48.0         99158428.0                     NaN   \n",
       "4753430           31.0         34356666.0                     NaN   \n",
       "4753431           71.0         92936688.0                     NaN   \n",
       "4753432           42.0         99061715.0                     NaN   \n",
       "4753433           71.0         35113234.0                     NaN   \n",
       "\n",
       "        DATA EXCLUSÃO DO SIMPLES OPÇÃO PELO MEI SITUAÇÃO ESPECIAL  \\\n",
       "0                            NaN            NaN               NaN   \n",
       "1                            NaN            NaN               NaN   \n",
       "2                            NaN            NaN               NaN   \n",
       "3                            NaN            NaN               NaN   \n",
       "4                            NaN            NaN               NaN   \n",
       "...                          ...            ...               ...   \n",
       "4753429                      NaN            NaN               NaN   \n",
       "4753430                      NaN            NaN               NaN   \n",
       "4753431                      NaN            NaN               NaN   \n",
       "4753432                      NaN            NaN               NaN   \n",
       "4753433                      NaN            NaN               NaN   \n",
       "\n",
       "                   DATA SITUAÇÃO ESPECIAL  FILLER FIM DE REGISTRO  \n",
       "0                                     NaN     NaN             NaN  \n",
       "1                                     NaN     NaN             NaN  \n",
       "2                                     NaN     NaN             NaN  \n",
       "3                                     NaN     NaN             NaN  \n",
       "4                                     NaN     NaN             NaN  \n",
       "...                                   ...     ...             ...  \n",
       "4753429         CAMILAZANOLLA@HOTMAIL.COM     NaN             NaN  \n",
       "4753430  POLLIANNAOLIVEIRACOSTA@GMAIL.COM     NaN             NaN  \n",
       "4753431        MATHEUS.MCUNHA@HOTMAIL.COM     NaN             NaN  \n",
       "4753432                  CPKOGA@GMAIL.COM     NaN             NaN  \n",
       "4753433          ADM@ORGANIZASAUDE.COM.BR     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>65097180</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>FAZENDA SANTA BARBARA</td>\n",
       "      <td>8</td>\n",
       "      <td>20020116</td>\n",
       "      <td>54</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4861</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>1</th>\n",
       "      <td>65097222</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20081231</td>\n",
       "      <td>71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4723</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>83759134</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>DANYSAT</td>\n",
       "      <td>8</td>\n",
       "      <td>19990728</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>395</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>48266175</td>\n",
       "      <td>1</td>\n",
       "      <td>71</td>\n",
       "      <td>1</td>\n",
       "      <td>BAR E MERCEARIA SANTO ANTONIO</td>\n",
       "      <td>8</td>\n",
       "      <td>19831214</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7113</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>27793272</td>\n",
       "      <td>1</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20150209</td>\n",
       "      <td>73</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5865</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>...</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>51104888</td>\n",
       "      <td>1</td>\n",
       "      <td>43</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20230619</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8233</td>\n",
       "      <td>48.0</td>\n",
       "      <td>99158428.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CAMILAZANOLLA@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753430</th>\n",
       "      <td>51104899</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20230619</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4123</td>\n",
       "      <td>31.0</td>\n",
       "      <td>34356666.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POLLIANNAOLIVEIRACOSTA@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753431</th>\n",
       "      <td>48491826</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20221102</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5813</td>\n",
       "      <td>71.0</td>\n",
       "      <td>92936688.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MATHEUS.MCUNHA@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753432</th>\n",
       "      <td>51104920</td>\n",
       "      <td>1</td>\n",
       "      <td>90</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20230619</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7607</td>\n",
       "      <td>42.0</td>\n",
       "      <td>99061715.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CPKOGA@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>51104931</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1</td>\n",
       "      <td>ORGANIZA SAUDE</td>\n",
       "      <td>2</td>\n",
       "      <td>20230619</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>3541</td>\n",
       "      <td>71.0</td>\n",
       "      <td>35113234.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ADM@ORGANIZASAUDE.COM.BR</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                         65097180           1      17            1   \n",
       "1                         65097222           1      10            1   \n",
       "2                         83759134           1      18            1   \n",
       "3                         48266175           1      71            1   \n",
       "4                         27793272           1      42            1   \n",
       "...                            ...         ...     ...          ...   \n",
       "4753429                   51104888           1      43            1   \n",
       "4753430                   51104899           1      23            1   \n",
       "4753431                   48491826           1      27            1   \n",
       "4753432                   51104920           1      90            1   \n",
       "4753433                   51104931           1      70            1   \n",
       "\n",
       "                                BAIRRO  CEP        UF  CODIGO MUNICIPIO  \\\n",
       "0                FAZENDA SANTA BARBARA    8  20020116                54   \n",
       "1                                  NaN    8  20081231                71   \n",
       "2                              DANYSAT    8  19990728                 1   \n",
       "3        BAR E MERCEARIA SANTO ANTONIO    8  19831214                 1   \n",
       "4                                  NaN    8  20150209                73   \n",
       "...                                ...  ...       ...               ...   \n",
       "4753429                            NaN    2  20230619                 0   \n",
       "4753430                            NaN    2  20230619                 0   \n",
       "4753431                            NaN    2  20221102                 0   \n",
       "4753432                            NaN    2  20230619                 0   \n",
       "4753433                 ORGANIZA SAUDE    2  20230619                 0   \n",
       "\n",
       "        MUNICIPIO  DDD-TELEFONE-1  ...  CAPITAL SOCIAL DA EMPRESA  \\\n",
       "0             NaN             NaN  ...                       4861   \n",
       "1             NaN             NaN  ...                       4723   \n",
       "2             NaN             NaN  ...                        395   \n",
       "3             NaN             NaN  ...                       7113   \n",
       "4             NaN             NaN  ...                       5865   \n",
       "...           ...             ...  ...                        ...   \n",
       "4753429       NaN             NaN  ...                       8233   \n",
       "4753430       NaN             NaN  ...                       4123   \n",
       "4753431       NaN             NaN  ...                       5813   \n",
       "4753432       NaN             NaN  ...                       7607   \n",
       "4753433       NaN             NaN  ...                       3541   \n",
       "\n",
       "         PORTE-EMPRESA OPÇÃO PELO SIMPLES DATA OPCAO PELO SIMPLES  \\\n",
       "0                  NaN                NaN                     NaN   \n",
       "1                  NaN                NaN                     NaN   \n",
       "2                  NaN                NaN                     NaN   \n",
       "3                  NaN                NaN                     NaN   \n",
       "4                  NaN                NaN                     NaN   \n",
       "...                ...                ...                     ...   \n",
       "4753429           48.0         99158428.0                     NaN   \n",
       "4753430           31.0         34356666.0                     NaN   \n",
       "4753431           71.0         92936688.0                     NaN   \n",
       "4753432           42.0         99061715.0                     NaN   \n",
       "4753433           71.0         35113234.0                     NaN   \n",
       "\n",
       "        DATA EXCLUSÃO DO SIMPLES OPÇÃO PELO MEI SITUAÇÃO ESPECIAL  \\\n",
       "0                            NaN            NaN               NaN   \n",
       "1                            NaN            NaN               NaN   \n",
       "2                            NaN            NaN               NaN   \n",
       "3                            NaN            NaN               NaN   \n",
       "4                            NaN            NaN               NaN   \n",
       "...                          ...            ...               ...   \n",
       "4753429                      NaN            NaN               NaN   \n",
       "4753430                      NaN            NaN               NaN   \n",
       "4753431                      NaN            NaN               NaN   \n",
       "4753432                      NaN            NaN               NaN   \n",
       "4753433                      NaN            NaN               NaN   \n",
       "\n",
       "                   DATA SITUAÇÃO ESPECIAL  FILLER FIM DE REGISTRO  \n",
       "0                                     NaN     NaN             NaN  \n",
       "1                                     NaN     NaN             NaN  \n",
       "2                                     NaN     NaN             NaN  \n",
       "3                                     NaN     NaN             NaN  \n",
       "4                                     NaN     NaN             NaN  \n",
       "...                                   ...     ...             ...  \n",
       "4753429         CAMILAZANOLLA@HOTMAIL.COM     NaN             NaN  \n",
       "4753430  POLLIANNAOLIVEIRACOSTA@GMAIL.COM     NaN             NaN  \n",
       "4753431        MATHEUS.MCUNHA@HOTMAIL.COM     NaN             NaN  \n",
       "4753432                  CPKOGA@GMAIL.COM     NaN             NaN  \n",
       "4753433          ADM@ORGANIZASAUDE.COM.BR     NaN             NaN  \n",
       "\n",
       "[4753434 rows x 30 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.to_csv('n_estabelecimento5.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
}