estabelecimento7.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_6764\\1366258037.py:1: DtypeWarning: Columns (8,21,22,24,26,28) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  df = pd.read_csv('estabelecimento7.csv', encoding='LATIN-1', 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>36739367</th>\n",
       "      <th>0001</th>\n",
       "      <th>79</th>\n",
       "      <th>1</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>04</th>\n",
       "      <th>20220607</th>\n",
       "      <th>63</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>...</th>\n",
       "      <th>6001</th>\n",
       "      <th>21</th>\n",
       "      <th>34007698</th>\n",
       "      <th>Unnamed: 23</th>\n",
       "      <th>Unnamed: 24</th>\n",
       "      <th>Unnamed: 25</th>\n",
       "      <th>Unnamed: 26</th>\n",
       "      <th>ALINEAMARAL@MILOSCONTABILIDADE.COM.BR</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>36739377</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20200320</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5703</td>\n",
       "      <td>27.0</td>\n",
       "      <td>96405921.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GABRIELABRUNORO@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>36739389</td>\n",
       "      <td>1</td>\n",
       "      <td>39</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20200320</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6251</td>\n",
       "      <td>11.0</td>\n",
       "      <td>74354250.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GUSTAVOHENRIQUE.26CAUA@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>28217060</td>\n",
       "      <td>2</td>\n",
       "      <td>60</td>\n",
       "      <td>2</td>\n",
       "      <td>RESIDENCIAL ARMONA SPE LTDA</td>\n",
       "      <td>2</td>\n",
       "      <td>20190725</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8163</td>\n",
       "      <td>47.0</td>\n",
       "      <td>32685258.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FINANCEIRO@BFABBRIANI.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>36739413</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20221122</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6291</td>\n",
       "      <td>19.0</td>\n",
       "      <td>38456285.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CLAYTONSEGVIP@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>36739424</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>YASMIN YUNES SALLES GAUDARD</td>\n",
       "      <td>8</td>\n",
       "      <td>20210406</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>9701</td>\n",
       "      <td>61.0</td>\n",
       "      <td>33651958.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>YASMINYUNESS@GMAIL.COM</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>23297188</td>\n",
       "      <td>1</td>\n",
       "      <td>87</td>\n",
       "      <td>1</td>\n",
       "      <td>JUM JUM LEE</td>\n",
       "      <td>8</td>\n",
       "      <td>20151002</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>87053290.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>nicolaulee@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753430</th>\n",
       "      <td>23297202</td>\n",
       "      <td>1</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>FAST LAND</td>\n",
       "      <td>8</td>\n",
       "      <td>20220826</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7535</td>\n",
       "      <td>41.0</td>\n",
       "      <td>87295957.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>K.OLENIKI@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753431</th>\n",
       "      <td>23297215</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>PASTELARIA SABRINA</td>\n",
       "      <td>8</td>\n",
       "      <td>20150924</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>9627</td>\n",
       "      <td>63.0</td>\n",
       "      <td>84392290.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>lazaromdesousa@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753432</th>\n",
       "      <td>23297224</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20210319</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2909</td>\n",
       "      <td>21.0</td>\n",
       "      <td>26618460.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>jhonatasplay@hotmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>23297240</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>CLAUDIA MACHADO</td>\n",
       "      <td>8</td>\n",
       "      <td>20210705</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5249</td>\n",
       "      <td>32.0</td>\n",
       "      <td>33731190.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BRUNONASCIMENTO404@YAHOO.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": [
       "         36739367  0001  79  1                   Unnamed: 4  04  20220607  63  \\\n",
       "0        36739377     1   4  1                          NaN   2  20200320   0   \n",
       "1        36739389     1  39  1                          NaN   2  20200320   0   \n",
       "2        28217060     2  60  2  RESIDENCIAL ARMONA SPE LTDA   2  20190725   0   \n",
       "3        36739413     1  30  1                          NaN   4  20221122  63   \n",
       "4        36739424     1  10  1  YASMIN YUNES SALLES GAUDARD   8  20210406   1   \n",
       "...           ...   ...  .. ..                          ...  ..       ...  ..   \n",
       "4753429  23297188     1  87  1                  JUM JUM LEE   8  20151002   1   \n",
       "4753430  23297202     1  42  1                    FAST LAND   8  20220826   1   \n",
       "4753431  23297215     1  11  1           PASTELARIA SABRINA   8  20150924   1   \n",
       "4753432  23297224     1   2  1                          NaN   4  20210319  63   \n",
       "4753433  23297240     1   3  1              CLAUDIA MACHADO   8  20210705   1   \n",
       "\n",
       "        Unnamed: 8  Unnamed: 9  ...  6001    21    34007698 Unnamed: 23  \\\n",
       "0              NaN         NaN  ...  5703  27.0  96405921.0         NaN   \n",
       "1              NaN         NaN  ...  6251  11.0  74354250.0         NaN   \n",
       "2              NaN         NaN  ...  8163  47.0  32685258.0         NaN   \n",
       "3              NaN         NaN  ...  6291  19.0  38456285.0         NaN   \n",
       "4              NaN         NaN  ...  9701  61.0  33651958.0         NaN   \n",
       "...            ...         ...  ...   ...   ...         ...         ...   \n",
       "4753429        NaN         NaN  ...  7107  11.0  87053290.0         NaN   \n",
       "4753430        NaN         NaN  ...  7535  41.0  87295957.0         NaN   \n",
       "4753431        NaN         NaN  ...  9627  63.0  84392290.0         NaN   \n",
       "4753432        NaN         NaN  ...  2909  21.0  26618460.0         NaN   \n",
       "4753433        NaN         NaN  ...  5249  32.0  33731190.0         NaN   \n",
       "\n",
       "        Unnamed: 24 Unnamed: 25 Unnamed: 26  \\\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",
       "        ALINEAMARAL@MILOSCONTABILIDADE.COM.BR  Unnamed: 28 Unnamed: 29  \n",
       "0                 GABRIELABRUNORO@HOTMAIL.COM          NaN         NaN  \n",
       "1            GUSTAVOHENRIQUE.26CAUA@GMAIL.COM          NaN         NaN  \n",
       "2                   FINANCEIRO@BFABBRIANI.COM          NaN         NaN  \n",
       "3                     CLAYTONSEGVIP@GMAIL.COM          NaN         NaN  \n",
       "4                      YASMINYUNESS@GMAIL.COM          NaN         NaN  \n",
       "...                                       ...          ...         ...  \n",
       "4753429                  nicolaulee@gmail.com          NaN         NaN  \n",
       "4753430                 K.OLENIKI@HOTMAIL.COM          NaN         NaN  \n",
       "4753431              lazaromdesousa@gmail.com          NaN         NaN  \n",
       "4753432              jhonatasplay@hotmail.com          NaN         NaN  \n",
       "4753433       BRUNONASCIMENTO404@YAHOO.COM.BR          NaN         NaN  \n",
       "\n",
       "[4753434 rows x 30 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('estabelecimento7.csv', encoding='LATIN-1', sep=';')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Edson\\AppData\\Local\\Temp\\ipykernel_6764\\1101391398.py:1: DtypeWarning: Columns (8,21,22,24,26,28) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  df = pd.read_csv('estabelecimento7.csv', encoding='LATIN-1', 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>36739367</td>\n",
       "      <td>1</td>\n",
       "      <td>79</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20220607</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6001</td>\n",
       "      <td>21.0</td>\n",
       "      <td>34007698.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALINEAMARAL@MILOSCONTABILIDADE.COM.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>36739377</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20200320</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5703</td>\n",
       "      <td>27.0</td>\n",
       "      <td>96405921.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GABRIELABRUNORO@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>36739389</td>\n",
       "      <td>1</td>\n",
       "      <td>39</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20200320</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6251</td>\n",
       "      <td>11.0</td>\n",
       "      <td>74354250.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GUSTAVOHENRIQUE.26CAUA@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>28217060</td>\n",
       "      <td>2</td>\n",
       "      <td>60</td>\n",
       "      <td>2</td>\n",
       "      <td>RESIDENCIAL ARMONA SPE LTDA</td>\n",
       "      <td>2</td>\n",
       "      <td>20190725</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8163</td>\n",
       "      <td>47.0</td>\n",
       "      <td>32685258.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FINANCEIRO@BFABBRIANI.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>36739413</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20221122</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6291</td>\n",
       "      <td>19.0</td>\n",
       "      <td>38456285.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CLAYTONSEGVIP@GMAIL.COM</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>23297188</td>\n",
       "      <td>1</td>\n",
       "      <td>87</td>\n",
       "      <td>1</td>\n",
       "      <td>JUM JUM LEE</td>\n",
       "      <td>8</td>\n",
       "      <td>20151002</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>87053290.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>nicolaulee@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753431</th>\n",
       "      <td>23297202</td>\n",
       "      <td>1</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>FAST LAND</td>\n",
       "      <td>8</td>\n",
       "      <td>20220826</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7535</td>\n",
       "      <td>41.0</td>\n",
       "      <td>87295957.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>K.OLENIKI@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753432</th>\n",
       "      <td>23297215</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>PASTELARIA SABRINA</td>\n",
       "      <td>8</td>\n",
       "      <td>20150924</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>9627</td>\n",
       "      <td>63.0</td>\n",
       "      <td>84392290.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>lazaromdesousa@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>23297224</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20210319</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2909</td>\n",
       "      <td>21.0</td>\n",
       "      <td>26618460.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>jhonatasplay@hotmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753434</th>\n",
       "      <td>23297240</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>CLAUDIA MACHADO</td>\n",
       "      <td>8</td>\n",
       "      <td>20210705</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5249</td>\n",
       "      <td>32.0</td>\n",
       "      <td>33731190.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BRUNONASCIMENTO404@YAHOO.COM.BR</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   \\\n",
       "0        36739367   1  79   1                          NaN   4  20220607  63   \n",
       "1        36739377   1   4   1                          NaN   2  20200320   0   \n",
       "2        36739389   1  39   1                          NaN   2  20200320   0   \n",
       "3        28217060   2  60   2  RESIDENCIAL ARMONA SPE LTDA   2  20190725   0   \n",
       "4        36739413   1  30   1                          NaN   4  20221122  63   \n",
       "...           ...  ..  ..  ..                          ...  ..       ...  ..   \n",
       "4753430  23297188   1  87   1                  JUM JUM LEE   8  20151002   1   \n",
       "4753431  23297202   1  42   1                    FAST LAND   8  20220826   1   \n",
       "4753432  23297215   1  11   1           PASTELARIA SABRINA   8  20150924   1   \n",
       "4753433  23297224   1   2   1                          NaN   4  20210319  63   \n",
       "4753434  23297240   1   3   1              CLAUDIA MACHADO   8  20210705   1   \n",
       "\n",
       "          8   9   ...    20    21          22  23   24  25   26  \\\n",
       "0        NaN NaN  ...  6001  21.0  34007698.0 NaN  NaN NaN  NaN   \n",
       "1        NaN NaN  ...  5703  27.0  96405921.0 NaN  NaN NaN  NaN   \n",
       "2        NaN NaN  ...  6251  11.0  74354250.0 NaN  NaN NaN  NaN   \n",
       "3        NaN NaN  ...  8163  47.0  32685258.0 NaN  NaN NaN  NaN   \n",
       "4        NaN NaN  ...  6291  19.0  38456285.0 NaN  NaN NaN  NaN   \n",
       "...      ...  ..  ...   ...   ...         ...  ..  ...  ..  ...   \n",
       "4753430  NaN NaN  ...  7107  11.0  87053290.0 NaN  NaN NaN  NaN   \n",
       "4753431  NaN NaN  ...  7535  41.0  87295957.0 NaN  NaN NaN  NaN   \n",
       "4753432  NaN NaN  ...  9627  63.0  84392290.0 NaN  NaN NaN  NaN   \n",
       "4753433  NaN NaN  ...  2909  21.0  26618460.0 NaN  NaN NaN  NaN   \n",
       "4753434  NaN NaN  ...  5249  32.0  33731190.0 NaN  NaN NaN  NaN   \n",
       "\n",
       "                                            27   28  29  \n",
       "0        ALINEAMARAL@MILOSCONTABILIDADE.COM.BR  NaN NaN  \n",
       "1                  GABRIELABRUNORO@HOTMAIL.COM  NaN NaN  \n",
       "2             GUSTAVOHENRIQUE.26CAUA@GMAIL.COM  NaN NaN  \n",
       "3                    FINANCEIRO@BFABBRIANI.COM  NaN NaN  \n",
       "4                      CLAYTONSEGVIP@GMAIL.COM  NaN NaN  \n",
       "...                                        ...  ...  ..  \n",
       "4753430                   nicolaulee@gmail.com  NaN NaN  \n",
       "4753431                  K.OLENIKI@HOTMAIL.COM  NaN NaN  \n",
       "4753432               lazaromdesousa@gmail.com  NaN NaN  \n",
       "4753433               jhonatasplay@hotmail.com  NaN NaN  \n",
       "4753434        BRUNONASCIMENTO404@YAHOO.COM.BR  NaN NaN  \n",
       "\n",
       "[4753435 rows x 30 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('estabelecimento7.csv', encoding='LATIN-1', sep=';', header=None)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>36739367</td>\n",
       "      <td>1</td>\n",
       "      <td>79</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20220607</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6001</td>\n",
       "      <td>21.0</td>\n",
       "      <td>34007698.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALINEAMARAL@MILOSCONTABILIDADE.COM.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>36739377</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20200320</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5703</td>\n",
       "      <td>27.0</td>\n",
       "      <td>96405921.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GABRIELABRUNORO@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>36739389</td>\n",
       "      <td>1</td>\n",
       "      <td>39</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20200320</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6251</td>\n",
       "      <td>11.0</td>\n",
       "      <td>74354250.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GUSTAVOHENRIQUE.26CAUA@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>28217060</td>\n",
       "      <td>2</td>\n",
       "      <td>60</td>\n",
       "      <td>2</td>\n",
       "      <td>RESIDENCIAL ARMONA SPE LTDA</td>\n",
       "      <td>2</td>\n",
       "      <td>20190725</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8163</td>\n",
       "      <td>47.0</td>\n",
       "      <td>32685258.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FINANCEIRO@BFABBRIANI.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>36739413</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20221122</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6291</td>\n",
       "      <td>19.0</td>\n",
       "      <td>38456285.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CLAYTONSEGVIP@GMAIL.COM</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>23297188</td>\n",
       "      <td>1</td>\n",
       "      <td>87</td>\n",
       "      <td>1</td>\n",
       "      <td>JUM JUM LEE</td>\n",
       "      <td>8</td>\n",
       "      <td>20151002</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>87053290.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>nicolaulee@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753431</th>\n",
       "      <td>23297202</td>\n",
       "      <td>1</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>FAST LAND</td>\n",
       "      <td>8</td>\n",
       "      <td>20220826</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7535</td>\n",
       "      <td>41.0</td>\n",
       "      <td>87295957.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>K.OLENIKI@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753432</th>\n",
       "      <td>23297215</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>PASTELARIA SABRINA</td>\n",
       "      <td>8</td>\n",
       "      <td>20150924</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>9627</td>\n",
       "      <td>63.0</td>\n",
       "      <td>84392290.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>lazaromdesousa@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>23297224</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20210319</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2909</td>\n",
       "      <td>21.0</td>\n",
       "      <td>26618460.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>jhonatasplay@hotmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753434</th>\n",
       "      <td>23297240</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>CLAUDIA MACHADO</td>\n",
       "      <td>8</td>\n",
       "      <td>20210705</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5249</td>\n",
       "      <td>32.0</td>\n",
       "      <td>33731190.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BRUNONASCIMENTO404@YAHOO.COM.BR</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                         36739367           1      79            1   \n",
       "1                         36739377           1       4            1   \n",
       "2                         36739389           1      39            1   \n",
       "3                         28217060           2      60            2   \n",
       "4                         36739413           1      30            1   \n",
       "...                            ...         ...     ...          ...   \n",
       "4753430                   23297188           1      87            1   \n",
       "4753431                   23297202           1      42            1   \n",
       "4753432                   23297215           1      11            1   \n",
       "4753433                   23297224           1       2            1   \n",
       "4753434                   23297240           1       3            1   \n",
       "\n",
       "                              BAIRRO  CEP        UF  CODIGO MUNICIPIO  \\\n",
       "0                                NaN    4  20220607                63   \n",
       "1                                NaN    2  20200320                 0   \n",
       "2                                NaN    2  20200320                 0   \n",
       "3        RESIDENCIAL ARMONA SPE LTDA    2  20190725                 0   \n",
       "4                                NaN    4  20221122                63   \n",
       "...                              ...  ...       ...               ...   \n",
       "4753430                  JUM JUM LEE    8  20151002                 1   \n",
       "4753431                    FAST LAND    8  20220826                 1   \n",
       "4753432           PASTELARIA SABRINA    8  20150924                 1   \n",
       "4753433                          NaN    4  20210319                63   \n",
       "4753434              CLAUDIA MACHADO    8  20210705                 1   \n",
       "\n",
       "        MUNICIPIO  DDD-TELEFONE-1  ...  CAPITAL SOCIAL DA EMPRESA  \\\n",
       "0             NaN             NaN  ...                       6001   \n",
       "1             NaN             NaN  ...                       5703   \n",
       "2             NaN             NaN  ...                       6251   \n",
       "3             NaN             NaN  ...                       8163   \n",
       "4             NaN             NaN  ...                       6291   \n",
       "...           ...             ...  ...                        ...   \n",
       "4753430       NaN             NaN  ...                       7107   \n",
       "4753431       NaN             NaN  ...                       7535   \n",
       "4753432       NaN             NaN  ...                       9627   \n",
       "4753433       NaN             NaN  ...                       2909   \n",
       "4753434       NaN             NaN  ...                       5249   \n",
       "\n",
       "         PORTE-EMPRESA OPÇÃO PELO SIMPLES DATA OPCAO PELO SIMPLES  \\\n",
       "0                 21.0         34007698.0                     NaN   \n",
       "1                 27.0         96405921.0                     NaN   \n",
       "2                 11.0         74354250.0                     NaN   \n",
       "3                 47.0         32685258.0                     NaN   \n",
       "4                 19.0         38456285.0                     NaN   \n",
       "...                ...                ...                     ...   \n",
       "4753430           11.0         87053290.0                     NaN   \n",
       "4753431           41.0         87295957.0                     NaN   \n",
       "4753432           63.0         84392290.0                     NaN   \n",
       "4753433           21.0         26618460.0                     NaN   \n",
       "4753434           32.0         33731190.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        ALINEAMARAL@MILOSCONTABILIDADE.COM.BR     NaN             NaN  \n",
       "1                  GABRIELABRUNORO@HOTMAIL.COM     NaN             NaN  \n",
       "2             GUSTAVOHENRIQUE.26CAUA@GMAIL.COM     NaN             NaN  \n",
       "3                    FINANCEIRO@BFABBRIANI.COM     NaN             NaN  \n",
       "4                      CLAYTONSEGVIP@GMAIL.COM     NaN             NaN  \n",
       "...                                        ...     ...             ...  \n",
       "4753430                   nicolaulee@gmail.com     NaN             NaN  \n",
       "4753431                  K.OLENIKI@HOTMAIL.COM     NaN             NaN  \n",
       "4753432               lazaromdesousa@gmail.com     NaN             NaN  \n",
       "4753433               jhonatasplay@hotmail.com     NaN             NaN  \n",
       "4753434        BRUNONASCIMENTO404@YAHOO.COM.BR     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>36739367</td>\n",
       "      <td>1</td>\n",
       "      <td>79</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20220607</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6001</td>\n",
       "      <td>21.0</td>\n",
       "      <td>34007698.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALINEAMARAL@MILOSCONTABILIDADE.COM.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>36739377</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20200320</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5703</td>\n",
       "      <td>27.0</td>\n",
       "      <td>96405921.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GABRIELABRUNORO@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>36739389</td>\n",
       "      <td>1</td>\n",
       "      <td>39</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20200320</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6251</td>\n",
       "      <td>11.0</td>\n",
       "      <td>74354250.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GUSTAVOHENRIQUE.26CAUA@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>28217060</td>\n",
       "      <td>2</td>\n",
       "      <td>60</td>\n",
       "      <td>2</td>\n",
       "      <td>RESIDENCIAL ARMONA SPE LTDA</td>\n",
       "      <td>2</td>\n",
       "      <td>20190725</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8163</td>\n",
       "      <td>47.0</td>\n",
       "      <td>32685258.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FINANCEIRO@BFABBRIANI.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>36739413</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20221122</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6291</td>\n",
       "      <td>19.0</td>\n",
       "      <td>38456285.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CLAYTONSEGVIP@GMAIL.COM</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>23297174</td>\n",
       "      <td>1</td>\n",
       "      <td>63</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20210122</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6589</td>\n",
       "      <td>12.0</td>\n",
       "      <td>88945623.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SGFBRASIL@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753430</th>\n",
       "      <td>23297188</td>\n",
       "      <td>1</td>\n",
       "      <td>87</td>\n",
       "      <td>1</td>\n",
       "      <td>JUM JUM LEE</td>\n",
       "      <td>8</td>\n",
       "      <td>20151002</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>87053290.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>nicolaulee@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753431</th>\n",
       "      <td>23297202</td>\n",
       "      <td>1</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>FAST LAND</td>\n",
       "      <td>8</td>\n",
       "      <td>20220826</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7535</td>\n",
       "      <td>41.0</td>\n",
       "      <td>87295957.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>K.OLENIKI@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753432</th>\n",
       "      <td>23297215</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>PASTELARIA SABRINA</td>\n",
       "      <td>8</td>\n",
       "      <td>20150924</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>9627</td>\n",
       "      <td>63.0</td>\n",
       "      <td>84392290.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>lazaromdesousa@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>23297224</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20210319</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2909</td>\n",
       "      <td>21.0</td>\n",
       "      <td>26618460.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>jhonatasplay@hotmail.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                         36739367           1      79            1   \n",
       "1                         36739377           1       4            1   \n",
       "2                         36739389           1      39            1   \n",
       "3                         28217060           2      60            2   \n",
       "4                         36739413           1      30            1   \n",
       "...                            ...         ...     ...          ...   \n",
       "4753429                   23297174           1      63            1   \n",
       "4753430                   23297188           1      87            1   \n",
       "4753431                   23297202           1      42            1   \n",
       "4753432                   23297215           1      11            1   \n",
       "4753433                   23297224           1       2            1   \n",
       "\n",
       "                              BAIRRO  CEP        UF  CODIGO MUNICIPIO  \\\n",
       "0                                NaN    4  20220607                63   \n",
       "1                                NaN    2  20200320                 0   \n",
       "2                                NaN    2  20200320                 0   \n",
       "3        RESIDENCIAL ARMONA SPE LTDA    2  20190725                 0   \n",
       "4                                NaN    4  20221122                63   \n",
       "...                              ...  ...       ...               ...   \n",
       "4753429                          NaN    4  20210122                63   \n",
       "4753430                  JUM JUM LEE    8  20151002                 1   \n",
       "4753431                    FAST LAND    8  20220826                 1   \n",
       "4753432           PASTELARIA SABRINA    8  20150924                 1   \n",
       "4753433                          NaN    4  20210319                63   \n",
       "\n",
       "        MUNICIPIO  DDD-TELEFONE-1  ...  CAPITAL SOCIAL DA EMPRESA  \\\n",
       "0             NaN             NaN  ...                       6001   \n",
       "1             NaN             NaN  ...                       5703   \n",
       "2             NaN             NaN  ...                       6251   \n",
       "3             NaN             NaN  ...                       8163   \n",
       "4             NaN             NaN  ...                       6291   \n",
       "...           ...             ...  ...                        ...   \n",
       "4753429       NaN             NaN  ...                       6589   \n",
       "4753430       NaN             NaN  ...                       7107   \n",
       "4753431       NaN             NaN  ...                       7535   \n",
       "4753432       NaN             NaN  ...                       9627   \n",
       "4753433       NaN             NaN  ...                       2909   \n",
       "\n",
       "         PORTE-EMPRESA OPÇÃO PELO SIMPLES DATA OPCAO PELO SIMPLES  \\\n",
       "0                 21.0         34007698.0                     NaN   \n",
       "1                 27.0         96405921.0                     NaN   \n",
       "2                 11.0         74354250.0                     NaN   \n",
       "3                 47.0         32685258.0                     NaN   \n",
       "4                 19.0         38456285.0                     NaN   \n",
       "...                ...                ...                     ...   \n",
       "4753429           12.0         88945623.0                     NaN   \n",
       "4753430           11.0         87053290.0                     NaN   \n",
       "4753431           41.0         87295957.0                     NaN   \n",
       "4753432           63.0         84392290.0                     NaN   \n",
       "4753433           21.0         26618460.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        ALINEAMARAL@MILOSCONTABILIDADE.COM.BR     NaN             NaN  \n",
       "1                  GABRIELABRUNORO@HOTMAIL.COM     NaN             NaN  \n",
       "2             GUSTAVOHENRIQUE.26CAUA@GMAIL.COM     NaN             NaN  \n",
       "3                    FINANCEIRO@BFABBRIANI.COM     NaN             NaN  \n",
       "4                      CLAYTONSEGVIP@GMAIL.COM     NaN             NaN  \n",
       "...                                        ...     ...             ...  \n",
       "4753429                  SGFBRASIL@HOTMAIL.COM     NaN             NaN  \n",
       "4753430                   nicolaulee@gmail.com     NaN             NaN  \n",
       "4753431                  K.OLENIKI@HOTMAIL.COM     NaN             NaN  \n",
       "4753432               lazaromdesousa@gmail.com     NaN             NaN  \n",
       "4753433               jhonatasplay@hotmail.com     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>36739367</td>\n",
       "      <td>1</td>\n",
       "      <td>79</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20220607</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6001</td>\n",
       "      <td>21.0</td>\n",
       "      <td>34007698.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALINEAMARAL@MILOSCONTABILIDADE.COM.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>36739377</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20200320</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5703</td>\n",
       "      <td>27.0</td>\n",
       "      <td>96405921.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GABRIELABRUNORO@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>36739389</td>\n",
       "      <td>1</td>\n",
       "      <td>39</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20200320</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6251</td>\n",
       "      <td>11.0</td>\n",
       "      <td>74354250.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GUSTAVOHENRIQUE.26CAUA@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>28217060</td>\n",
       "      <td>2</td>\n",
       "      <td>60</td>\n",
       "      <td>2</td>\n",
       "      <td>RESIDENCIAL ARMONA SPE LTDA</td>\n",
       "      <td>2</td>\n",
       "      <td>20190725</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8163</td>\n",
       "      <td>47.0</td>\n",
       "      <td>32685258.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FINANCEIRO@BFABBRIANI.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>36739413</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20221122</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6291</td>\n",
       "      <td>19.0</td>\n",
       "      <td>38456285.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CLAYTONSEGVIP@GMAIL.COM</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>23297174</td>\n",
       "      <td>1</td>\n",
       "      <td>63</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20210122</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6589</td>\n",
       "      <td>12.0</td>\n",
       "      <td>88945623.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SGFBRASIL@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753430</th>\n",
       "      <td>23297188</td>\n",
       "      <td>1</td>\n",
       "      <td>87</td>\n",
       "      <td>1</td>\n",
       "      <td>JUM JUM LEE</td>\n",
       "      <td>8</td>\n",
       "      <td>20151002</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>87053290.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>nicolaulee@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753431</th>\n",
       "      <td>23297202</td>\n",
       "      <td>1</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>FAST LAND</td>\n",
       "      <td>8</td>\n",
       "      <td>20220826</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7535</td>\n",
       "      <td>41.0</td>\n",
       "      <td>87295957.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>K.OLENIKI@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753432</th>\n",
       "      <td>23297215</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>PASTELARIA SABRINA</td>\n",
       "      <td>8</td>\n",
       "      <td>20150924</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>9627</td>\n",
       "      <td>63.0</td>\n",
       "      <td>84392290.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>lazaromdesousa@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>23297224</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20210319</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2909</td>\n",
       "      <td>21.0</td>\n",
       "      <td>26618460.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>jhonatasplay@hotmail.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                         36739367           1      79            1   \n",
       "1                         36739377           1       4            1   \n",
       "2                         36739389           1      39            1   \n",
       "3                         28217060           2      60            2   \n",
       "4                         36739413           1      30            1   \n",
       "...                            ...         ...     ...          ...   \n",
       "4753429                   23297174           1      63            1   \n",
       "4753430                   23297188           1      87            1   \n",
       "4753431                   23297202           1      42            1   \n",
       "4753432                   23297215           1      11            1   \n",
       "4753433                   23297224           1       2            1   \n",
       "\n",
       "                              BAIRRO  CEP        UF  CODIGO MUNICIPIO  \\\n",
       "0                                NaN    4  20220607                63   \n",
       "1                                NaN    2  20200320                 0   \n",
       "2                                NaN    2  20200320                 0   \n",
       "3        RESIDENCIAL ARMONA SPE LTDA    2  20190725                 0   \n",
       "4                                NaN    4  20221122                63   \n",
       "...                              ...  ...       ...               ...   \n",
       "4753429                          NaN    4  20210122                63   \n",
       "4753430                  JUM JUM LEE    8  20151002                 1   \n",
       "4753431                    FAST LAND    8  20220826                 1   \n",
       "4753432           PASTELARIA SABRINA    8  20150924                 1   \n",
       "4753433                          NaN    4  20210319                63   \n",
       "\n",
       "        MUNICIPIO  DDD-TELEFONE-1  ...  CAPITAL SOCIAL DA EMPRESA  \\\n",
       "0             NaN             NaN  ...                       6001   \n",
       "1             NaN             NaN  ...                       5703   \n",
       "2             NaN             NaN  ...                       6251   \n",
       "3             NaN             NaN  ...                       8163   \n",
       "4             NaN             NaN  ...                       6291   \n",
       "...           ...             ...  ...                        ...   \n",
       "4753429       NaN             NaN  ...                       6589   \n",
       "4753430       NaN             NaN  ...                       7107   \n",
       "4753431       NaN             NaN  ...                       7535   \n",
       "4753432       NaN             NaN  ...                       9627   \n",
       "4753433       NaN             NaN  ...                       2909   \n",
       "\n",
       "         PORTE-EMPRESA OPÇÃO PELO SIMPLES DATA OPCAO PELO SIMPLES  \\\n",
       "0                 21.0         34007698.0                     NaN   \n",
       "1                 27.0         96405921.0                     NaN   \n",
       "2                 11.0         74354250.0                     NaN   \n",
       "3                 47.0         32685258.0                     NaN   \n",
       "4                 19.0         38456285.0                     NaN   \n",
       "...                ...                ...                     ...   \n",
       "4753429           12.0         88945623.0                     NaN   \n",
       "4753430           11.0         87053290.0                     NaN   \n",
       "4753431           41.0         87295957.0                     NaN   \n",
       "4753432           63.0         84392290.0                     NaN   \n",
       "4753433           21.0         26618460.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        ALINEAMARAL@MILOSCONTABILIDADE.COM.BR     NaN             NaN  \n",
       "1                  GABRIELABRUNORO@HOTMAIL.COM     NaN             NaN  \n",
       "2             GUSTAVOHENRIQUE.26CAUA@GMAIL.COM     NaN             NaN  \n",
       "3                    FINANCEIRO@BFABBRIANI.COM     NaN             NaN  \n",
       "4                      CLAYTONSEGVIP@GMAIL.COM     NaN             NaN  \n",
       "...                                        ...     ...             ...  \n",
       "4753429                  SGFBRASIL@HOTMAIL.COM     NaN             NaN  \n",
       "4753430                   nicolaulee@gmail.com     NaN             NaN  \n",
       "4753431                  K.OLENIKI@HOTMAIL.COM     NaN             NaN  \n",
       "4753432               lazaromdesousa@gmail.com     NaN             NaN  \n",
       "4753433               jhonatasplay@hotmail.com     NaN             NaN  \n",
       "\n",
       "[4753434 rows x 30 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.to_csv('n_estabelecimento7.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
}