estabelecimento9.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_5764\\1115042560.py:1: DtypeWarning: Columns (8,21,22,24,25,26,28) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  df = pd.read_csv('estabelecimento9.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>79242905</th>\n",
       "      <th>0001</th>\n",
       "      <th>28</th>\n",
       "      <th>1</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>08</th>\n",
       "      <th>19870122</th>\n",
       "      <th>01</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>...</th>\n",
       "      <th>8173</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>47041223</td>\n",
       "      <td>1</td>\n",
       "      <td>60</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20051103</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6425</td>\n",
       "      <td>16.0</td>\n",
       "      <td>37216090</td>\n",
       "      <td>16.0</td>\n",
       "      <td>37014022.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>37014022</td>\n",
       "      <td>ASSEMBLEIADEDEUSFRANCA@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4938273</td>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20020131</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7963</td>\n",
       "      <td>41.0</td>\n",
       "      <td>2292148</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>2292148</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5561924</td>\n",
       "      <td>1</td>\n",
       "      <td>80</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20050516</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6131</td>\n",
       "      <td>19.0</td>\n",
       "      <td>34651679</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>42005868</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>19960630</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>3313</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>2054384</td>\n",
       "      <td>1</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>IVO COMERCIO &amp; SERVICOS</td>\n",
       "      <td>4</td>\n",
       "      <td>20181025</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2491</td>\n",
       "      <td>81.0</td>\n",
       "      <td>4264607</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>24513020</td>\n",
       "      <td>4</td>\n",
       "      <td>77</td>\n",
       "      <td>2</td>\n",
       "      <td>TRANSFIGUEIREDO</td>\n",
       "      <td>8</td>\n",
       "      <td>19951228</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1761</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>4753430</th>\n",
       "      <td>24514093</td>\n",
       "      <td>2</td>\n",
       "      <td>11</td>\n",
       "      <td>2</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>1981</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>4753431</th>\n",
       "      <td>5991530</td>\n",
       "      <td>1</td>\n",
       "      <td>62</td>\n",
       "      <td>1</td>\n",
       "      <td>CENTRO DE FORMACAO DE CONDUTORES VANTE</td>\n",
       "      <td>2</td>\n",
       "      <td>20051103</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4701</td>\n",
       "      <td>38.0</td>\n",
       "      <td>38213634.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AUTOESCOLAVANTE@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753432</th>\n",
       "      <td>24515793</td>\n",
       "      <td>2</td>\n",
       "      <td>20</td>\n",
       "      <td>2</td>\n",
       "      <td>LOJAS RIBAMAR</td>\n",
       "      <td>2</td>\n",
       "      <td>20010526</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1639</td>\n",
       "      <td>84.0</td>\n",
       "      <td>34211688.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>96849190.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>34211567.0</td>\n",
       "      <td>FMCONTABILIDADE2012@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>2600132</td>\n",
       "      <td>1</td>\n",
       "      <td>80</td>\n",
       "      <td>1</td>\n",
       "      <td>TROON</td>\n",
       "      <td>2</td>\n",
       "      <td>20010225</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7107</td>\n",
       "      <td>11.0</td>\n",
       "      <td>30446555.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JLPINTO@MONTBLANC.COM.BS</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": [
       "         79242905  0001  28  1                              Unnamed: 4  08  \\\n",
       "0        47041223     1  60  1                                     NaN   2   \n",
       "1         4938273     1  32  1                                     NaN   2   \n",
       "2         5561924     1  80  1                                     NaN   8   \n",
       "3        42005868     1  24  1                                     NaN   8   \n",
       "4         2054384     1  50  1                 IVO COMERCIO & SERVICOS   4   \n",
       "...           ...   ...  .. ..                                     ...  ..   \n",
       "4753429  24513020     4  77  2                         TRANSFIGUEIREDO   8   \n",
       "4753430  24514093     2  11  2                                     NaN   8   \n",
       "4753431   5991530     1  62  1  CENTRO DE FORMACAO DE CONDUTORES VANTE   2   \n",
       "4753432  24515793     2  20  2                           LOJAS RIBAMAR   2   \n",
       "4753433   2600132     1  80  1                                   TROON   2   \n",
       "\n",
       "         19870122  01 Unnamed: 8  Unnamed: 9  ...  8173  Unnamed: 21  \\\n",
       "0        20051103   0        NaN         NaN  ...  6425         16.0   \n",
       "1        20020131   0        NaN         NaN  ...  7963         41.0   \n",
       "2        20050516   1        NaN         NaN  ...  6131         19.0   \n",
       "3        19960630   1        NaN         NaN  ...  3313          NaN   \n",
       "4        20181025  63        NaN         NaN  ...  2491         81.0   \n",
       "...           ...  ..        ...         ...  ...   ...          ...   \n",
       "4753429  19951228   1        NaN         NaN  ...  1761          NaN   \n",
       "4753430  20081231  71        NaN         NaN  ...  1981          NaN   \n",
       "4753431  20051103   0        NaN         NaN  ...  4701         38.0   \n",
       "4753432  20010526   0        NaN         NaN  ...  1639         84.0   \n",
       "4753433  20010225   0        NaN         NaN  ...  7107         11.0   \n",
       "\n",
       "        Unnamed: 22 Unnamed: 23 Unnamed: 24 Unnamed: 25 Unnamed: 26  \\\n",
       "0          37216090        16.0  37014022.0        16.0    37014022   \n",
       "1           2292148         NaN         NaN        41.0     2292148   \n",
       "2          34651679         NaN         NaN         NaN         NaN   \n",
       "3               NaN         NaN         NaN         NaN         NaN   \n",
       "4           4264607         NaN         NaN         NaN         NaN   \n",
       "...             ...         ...         ...         ...         ...   \n",
       "4753429         NaN         NaN         NaN         NaN         NaN   \n",
       "4753430         NaN         NaN         NaN         NaN         NaN   \n",
       "4753431  38213634.0         NaN         NaN         NaN         NaN   \n",
       "4753432  34211688.0        84.0  96849190.0        84.0  34211567.0   \n",
       "4753433  30446555.0         NaN         NaN         NaN         NaN   \n",
       "\n",
       "                                Unnamed: 27  Unnamed: 28 Unnamed: 29  \n",
       "0        ASSEMBLEIADEDEUSFRANCA@HOTMAIL.COM          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           AUTOESCOLAVANTE@GMAIL.COM          NaN         NaN  \n",
       "4753432       FMCONTABILIDADE2012@GMAIL.COM          NaN         NaN  \n",
       "4753433            JLPINTO@MONTBLANC.COM.BS          NaN         NaN  \n",
       "\n",
       "[4753434 rows x 30 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('estabelecimento9.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_5764\\2859765701.py:1: DtypeWarning: Columns (8,10,21,22,24,25,26,28) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  df = pd.read_csv('estabelecimento9.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>79242905</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>19870122</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8173</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>47041223</td>\n",
       "      <td>1</td>\n",
       "      <td>60</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20051103</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6425</td>\n",
       "      <td>16.0</td>\n",
       "      <td>37216090</td>\n",
       "      <td>16.0</td>\n",
       "      <td>37014022.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>37014022</td>\n",
       "      <td>ASSEMBLEIADEDEUSFRANCA@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4938273</td>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20020131</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7963</td>\n",
       "      <td>41.0</td>\n",
       "      <td>2292148</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>2292148</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5561924</td>\n",
       "      <td>1</td>\n",
       "      <td>80</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20050516</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6131</td>\n",
       "      <td>19.0</td>\n",
       "      <td>34651679</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>42005868</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>19960630</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>3313</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>24513020</td>\n",
       "      <td>4</td>\n",
       "      <td>77</td>\n",
       "      <td>2</td>\n",
       "      <td>TRANSFIGUEIREDO</td>\n",
       "      <td>8</td>\n",
       "      <td>19951228</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1761</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>4753431</th>\n",
       "      <td>24514093</td>\n",
       "      <td>2</td>\n",
       "      <td>11</td>\n",
       "      <td>2</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>1981</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>4753432</th>\n",
       "      <td>5991530</td>\n",
       "      <td>1</td>\n",
       "      <td>62</td>\n",
       "      <td>1</td>\n",
       "      <td>CENTRO DE FORMACAO DE CONDUTORES VANTE</td>\n",
       "      <td>2</td>\n",
       "      <td>20051103</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4701</td>\n",
       "      <td>38.0</td>\n",
       "      <td>38213634.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AUTOESCOLAVANTE@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>24515793</td>\n",
       "      <td>2</td>\n",
       "      <td>20</td>\n",
       "      <td>2</td>\n",
       "      <td>LOJAS RIBAMAR</td>\n",
       "      <td>2</td>\n",
       "      <td>20010526</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1639</td>\n",
       "      <td>84.0</td>\n",
       "      <td>34211688.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>96849190.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>34211567.0</td>\n",
       "      <td>FMCONTABILIDADE2012@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753434</th>\n",
       "      <td>2600132</td>\n",
       "      <td>1</td>\n",
       "      <td>80</td>\n",
       "      <td>1</td>\n",
       "      <td>TROON</td>\n",
       "      <td>2</td>\n",
       "      <td>20010225</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7107</td>\n",
       "      <td>11.0</td>\n",
       "      <td>30446555.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JLPINTO@MONTBLANC.COM.BS</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   \\\n",
       "0        79242905   1  28   1                                     NaN   8   \n",
       "1        47041223   1  60   1                                     NaN   2   \n",
       "2         4938273   1  32   1                                     NaN   2   \n",
       "3         5561924   1  80   1                                     NaN   8   \n",
       "4        42005868   1  24   1                                     NaN   8   \n",
       "...           ...  ..  ..  ..                                     ...  ..   \n",
       "4753430  24513020   4  77   2                         TRANSFIGUEIREDO   8   \n",
       "4753431  24514093   2  11   2                                     NaN   8   \n",
       "4753432   5991530   1  62   1  CENTRO DE FORMACAO DE CONDUTORES VANTE   2   \n",
       "4753433  24515793   2  20   2                           LOJAS RIBAMAR   2   \n",
       "4753434   2600132   1  80   1                                   TROON   2   \n",
       "\n",
       "               6   7    8   9   ...    20    21          22    23          24  \\\n",
       "0        19870122   1  NaN NaN  ...  8173   NaN         NaN   NaN         NaN   \n",
       "1        20051103   0  NaN NaN  ...  6425  16.0    37216090  16.0  37014022.0   \n",
       "2        20020131   0  NaN NaN  ...  7963  41.0     2292148   NaN         NaN   \n",
       "3        20050516   1  NaN NaN  ...  6131  19.0    34651679   NaN         NaN   \n",
       "4        19960630   1  NaN NaN  ...  3313   NaN         NaN   NaN         NaN   \n",
       "...           ...  ..  ...  ..  ...   ...   ...         ...   ...         ...   \n",
       "4753430  19951228   1  NaN NaN  ...  1761   NaN         NaN   NaN         NaN   \n",
       "4753431  20081231  71  NaN NaN  ...  1981   NaN         NaN   NaN         NaN   \n",
       "4753432  20051103   0  NaN NaN  ...  4701  38.0  38213634.0   NaN         NaN   \n",
       "4753433  20010526   0  NaN NaN  ...  1639  84.0  34211688.0  84.0  96849190.0   \n",
       "4753434  20010225   0  NaN NaN  ...  7107  11.0  30446555.0   NaN         NaN   \n",
       "\n",
       "           25          26                                  27   28  29  \n",
       "0         NaN         NaN                                 NaN  NaN NaN  \n",
       "1        16.0    37014022  ASSEMBLEIADEDEUSFRANCA@HOTMAIL.COM  NaN NaN  \n",
       "2        41.0     2292148                                 NaN  NaN NaN  \n",
       "3         NaN         NaN                                 NaN  NaN NaN  \n",
       "4         NaN         NaN                                 NaN  NaN NaN  \n",
       "...       ...         ...                                 ...  ...  ..  \n",
       "4753430   NaN         NaN                                 NaN  NaN NaN  \n",
       "4753431   NaN         NaN                                 NaN  NaN NaN  \n",
       "4753432   NaN         NaN           AUTOESCOLAVANTE@GMAIL.COM  NaN NaN  \n",
       "4753433  84.0  34211567.0       FMCONTABILIDADE2012@GMAIL.COM  NaN NaN  \n",
       "4753434   NaN         NaN            JLPINTO@MONTBLANC.COM.BS  NaN NaN  \n",
       "\n",
       "[4753435 rows x 30 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('estabelecimento9.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>79242905</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>19870122</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8173</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>47041223</td>\n",
       "      <td>1</td>\n",
       "      <td>60</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20051103</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6425</td>\n",
       "      <td>16.0</td>\n",
       "      <td>37216090</td>\n",
       "      <td>16.0</td>\n",
       "      <td>37014022.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>37014022</td>\n",
       "      <td>ASSEMBLEIADEDEUSFRANCA@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4938273</td>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20020131</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7963</td>\n",
       "      <td>41.0</td>\n",
       "      <td>2292148</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>2292148</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5561924</td>\n",
       "      <td>1</td>\n",
       "      <td>80</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20050516</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6131</td>\n",
       "      <td>19.0</td>\n",
       "      <td>34651679</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>42005868</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>19960630</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>3313</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>24513020</td>\n",
       "      <td>4</td>\n",
       "      <td>77</td>\n",
       "      <td>2</td>\n",
       "      <td>TRANSFIGUEIREDO</td>\n",
       "      <td>8</td>\n",
       "      <td>19951228</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1761</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>4753431</th>\n",
       "      <td>24514093</td>\n",
       "      <td>2</td>\n",
       "      <td>11</td>\n",
       "      <td>2</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>1981</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>4753432</th>\n",
       "      <td>5991530</td>\n",
       "      <td>1</td>\n",
       "      <td>62</td>\n",
       "      <td>1</td>\n",
       "      <td>CENTRO DE FORMACAO DE CONDUTORES VANTE</td>\n",
       "      <td>2</td>\n",
       "      <td>20051103</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4701</td>\n",
       "      <td>38.0</td>\n",
       "      <td>38213634.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AUTOESCOLAVANTE@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>24515793</td>\n",
       "      <td>2</td>\n",
       "      <td>20</td>\n",
       "      <td>2</td>\n",
       "      <td>LOJAS RIBAMAR</td>\n",
       "      <td>2</td>\n",
       "      <td>20010526</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1639</td>\n",
       "      <td>84.0</td>\n",
       "      <td>34211688.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>96849190.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>34211567.0</td>\n",
       "      <td>FMCONTABILIDADE2012@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753434</th>\n",
       "      <td>2600132</td>\n",
       "      <td>1</td>\n",
       "      <td>80</td>\n",
       "      <td>1</td>\n",
       "      <td>TROON</td>\n",
       "      <td>2</td>\n",
       "      <td>20010225</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7107</td>\n",
       "      <td>11.0</td>\n",
       "      <td>30446555.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JLPINTO@MONTBLANC.COM.BS</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                         79242905           1      28            1   \n",
       "1                         47041223           1      60            1   \n",
       "2                          4938273           1      32            1   \n",
       "3                          5561924           1      80            1   \n",
       "4                         42005868           1      24            1   \n",
       "...                            ...         ...     ...          ...   \n",
       "4753430                   24513020           4      77            2   \n",
       "4753431                   24514093           2      11            2   \n",
       "4753432                    5991530           1      62            1   \n",
       "4753433                   24515793           2      20            2   \n",
       "4753434                    2600132           1      80            1   \n",
       "\n",
       "                                         BAIRRO  CEP        UF  \\\n",
       "0                                           NaN    8  19870122   \n",
       "1                                           NaN    2  20051103   \n",
       "2                                           NaN    2  20020131   \n",
       "3                                           NaN    8  20050516   \n",
       "4                                           NaN    8  19960630   \n",
       "...                                         ...  ...       ...   \n",
       "4753430                         TRANSFIGUEIREDO    8  19951228   \n",
       "4753431                                     NaN    8  20081231   \n",
       "4753432  CENTRO DE FORMACAO DE CONDUTORES VANTE    2  20051103   \n",
       "4753433                           LOJAS RIBAMAR    2  20010526   \n",
       "4753434                                   TROON    2  20010225   \n",
       "\n",
       "         CODIGO MUNICIPIO MUNICIPIO  DDD-TELEFONE-1  ...  \\\n",
       "0                       1       NaN             NaN  ...   \n",
       "1                       0       NaN             NaN  ...   \n",
       "2                       0       NaN             NaN  ...   \n",
       "3                       1       NaN             NaN  ...   \n",
       "4                       1       NaN             NaN  ...   \n",
       "...                   ...       ...             ...  ...   \n",
       "4753430                 1       NaN             NaN  ...   \n",
       "4753431                71       NaN             NaN  ...   \n",
       "4753432                 0       NaN             NaN  ...   \n",
       "4753433                 0       NaN             NaN  ...   \n",
       "4753434                 0       NaN             NaN  ...   \n",
       "\n",
       "        CAPITAL SOCIAL DA EMPRESA  PORTE-EMPRESA OPÇÃO PELO SIMPLES  \\\n",
       "0                            8173            NaN                NaN   \n",
       "1                            6425           16.0           37216090   \n",
       "2                            7963           41.0            2292148   \n",
       "3                            6131           19.0           34651679   \n",
       "4                            3313            NaN                NaN   \n",
       "...                           ...            ...                ...   \n",
       "4753430                      1761            NaN                NaN   \n",
       "4753431                      1981            NaN                NaN   \n",
       "4753432                      4701           38.0         38213634.0   \n",
       "4753433                      1639           84.0         34211688.0   \n",
       "4753434                      7107           11.0         30446555.0   \n",
       "\n",
       "        DATA OPCAO PELO SIMPLES DATA EXCLUSÃO DO SIMPLES OPÇÃO PELO MEI  \\\n",
       "0                           NaN                      NaN            NaN   \n",
       "1                          16.0               37014022.0           16.0   \n",
       "2                           NaN                      NaN           41.0   \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                    84.0               96849190.0           84.0   \n",
       "4753434                     NaN                      NaN            NaN   \n",
       "\n",
       "        SITUAÇÃO ESPECIAL              DATA SITUAÇÃO ESPECIAL  FILLER  \\\n",
       "0                     NaN                                 NaN     NaN   \n",
       "1                37014022  ASSEMBLEIADEDEUSFRANCA@HOTMAIL.COM     NaN   \n",
       "2                 2292148                                 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           AUTOESCOLAVANTE@GMAIL.COM     NaN   \n",
       "4753433        34211567.0       FMCONTABILIDADE2012@GMAIL.COM     NaN   \n",
       "4753434               NaN            JLPINTO@MONTBLANC.COM.BS     NaN   \n",
       "\n",
       "        FIM DE REGISTRO  \n",
       "0                   NaN  \n",
       "1                   NaN  \n",
       "2                   NaN  \n",
       "3                   NaN  \n",
       "4                   NaN  \n",
       "...                 ...  \n",
       "4753430             NaN  \n",
       "4753431             NaN  \n",
       "4753432             NaN  \n",
       "4753433             NaN  \n",
       "4753434             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>79242905</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>19870122</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8173</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>47041223</td>\n",
       "      <td>1</td>\n",
       "      <td>60</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20051103</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6425</td>\n",
       "      <td>16.0</td>\n",
       "      <td>37216090</td>\n",
       "      <td>16.0</td>\n",
       "      <td>37014022.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>37014022</td>\n",
       "      <td>ASSEMBLEIADEDEUSFRANCA@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4938273</td>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20020131</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7963</td>\n",
       "      <td>41.0</td>\n",
       "      <td>2292148</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>2292148</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5561924</td>\n",
       "      <td>1</td>\n",
       "      <td>80</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20050516</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6131</td>\n",
       "      <td>19.0</td>\n",
       "      <td>34651679</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>42005868</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>19960630</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>3313</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>24512592</td>\n",
       "      <td>2</td>\n",
       "      <td>70</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20181120</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5623</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>4753430</th>\n",
       "      <td>24513020</td>\n",
       "      <td>4</td>\n",
       "      <td>77</td>\n",
       "      <td>2</td>\n",
       "      <td>TRANSFIGUEIREDO</td>\n",
       "      <td>8</td>\n",
       "      <td>19951228</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1761</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>4753431</th>\n",
       "      <td>24514093</td>\n",
       "      <td>2</td>\n",
       "      <td>11</td>\n",
       "      <td>2</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>1981</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>4753432</th>\n",
       "      <td>5991530</td>\n",
       "      <td>1</td>\n",
       "      <td>62</td>\n",
       "      <td>1</td>\n",
       "      <td>CENTRO DE FORMACAO DE CONDUTORES VANTE</td>\n",
       "      <td>2</td>\n",
       "      <td>20051103</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4701</td>\n",
       "      <td>38.0</td>\n",
       "      <td>38213634.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AUTOESCOLAVANTE@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>24515793</td>\n",
       "      <td>2</td>\n",
       "      <td>20</td>\n",
       "      <td>2</td>\n",
       "      <td>LOJAS RIBAMAR</td>\n",
       "      <td>2</td>\n",
       "      <td>20010526</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1639</td>\n",
       "      <td>84.0</td>\n",
       "      <td>34211688.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>96849190.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>34211567.0</td>\n",
       "      <td>FMCONTABILIDADE2012@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4753434 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         DESCRIÇÃO TIPO LOGRADOURO  LOGRADOURO  NUMERO  COMPLEMENTO  \\\n",
       "0                         79242905           1      28            1   \n",
       "1                         47041223           1      60            1   \n",
       "2                          4938273           1      32            1   \n",
       "3                          5561924           1      80            1   \n",
       "4                         42005868           1      24            1   \n",
       "...                            ...         ...     ...          ...   \n",
       "4753429                   24512592           2      70            2   \n",
       "4753430                   24513020           4      77            2   \n",
       "4753431                   24514093           2      11            2   \n",
       "4753432                    5991530           1      62            1   \n",
       "4753433                   24515793           2      20            2   \n",
       "\n",
       "                                         BAIRRO  CEP        UF  \\\n",
       "0                                           NaN    8  19870122   \n",
       "1                                           NaN    2  20051103   \n",
       "2                                           NaN    2  20020131   \n",
       "3                                           NaN    8  20050516   \n",
       "4                                           NaN    8  19960630   \n",
       "...                                         ...  ...       ...   \n",
       "4753429                                     NaN    4  20181120   \n",
       "4753430                         TRANSFIGUEIREDO    8  19951228   \n",
       "4753431                                     NaN    8  20081231   \n",
       "4753432  CENTRO DE FORMACAO DE CONDUTORES VANTE    2  20051103   \n",
       "4753433                           LOJAS RIBAMAR    2  20010526   \n",
       "\n",
       "         CODIGO MUNICIPIO MUNICIPIO  DDD-TELEFONE-1  ...  \\\n",
       "0                       1       NaN             NaN  ...   \n",
       "1                       0       NaN             NaN  ...   \n",
       "2                       0       NaN             NaN  ...   \n",
       "3                       1       NaN             NaN  ...   \n",
       "4                       1       NaN             NaN  ...   \n",
       "...                   ...       ...             ...  ...   \n",
       "4753429                63       NaN             NaN  ...   \n",
       "4753430                 1       NaN             NaN  ...   \n",
       "4753431                71       NaN             NaN  ...   \n",
       "4753432                 0       NaN             NaN  ...   \n",
       "4753433                 0       NaN             NaN  ...   \n",
       "\n",
       "        CAPITAL SOCIAL DA EMPRESA  PORTE-EMPRESA OPÇÃO PELO SIMPLES  \\\n",
       "0                            8173            NaN                NaN   \n",
       "1                            6425           16.0           37216090   \n",
       "2                            7963           41.0            2292148   \n",
       "3                            6131           19.0           34651679   \n",
       "4                            3313            NaN                NaN   \n",
       "...                           ...            ...                ...   \n",
       "4753429                      5623            NaN                NaN   \n",
       "4753430                      1761            NaN                NaN   \n",
       "4753431                      1981            NaN                NaN   \n",
       "4753432                      4701           38.0         38213634.0   \n",
       "4753433                      1639           84.0         34211688.0   \n",
       "\n",
       "        DATA OPCAO PELO SIMPLES DATA EXCLUSÃO DO SIMPLES OPÇÃO PELO MEI  \\\n",
       "0                           NaN                      NaN            NaN   \n",
       "1                          16.0               37014022.0           16.0   \n",
       "2                           NaN                      NaN           41.0   \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                    84.0               96849190.0           84.0   \n",
       "\n",
       "        SITUAÇÃO ESPECIAL              DATA SITUAÇÃO ESPECIAL  FILLER  \\\n",
       "0                     NaN                                 NaN     NaN   \n",
       "1                37014022  ASSEMBLEIADEDEUSFRANCA@HOTMAIL.COM     NaN   \n",
       "2                 2292148                                 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           AUTOESCOLAVANTE@GMAIL.COM     NaN   \n",
       "4753433        34211567.0       FMCONTABILIDADE2012@GMAIL.COM     NaN   \n",
       "\n",
       "        FIM DE REGISTRO  \n",
       "0                   NaN  \n",
       "1                   NaN  \n",
       "2                   NaN  \n",
       "3                   NaN  \n",
       "4                   NaN  \n",
       "...                 ...  \n",
       "4753429             NaN  \n",
       "4753430             NaN  \n",
       "4753431             NaN  \n",
       "4753432             NaN  \n",
       "4753433             NaN  \n",
       "\n",
       "[4753434 rows x 30 columns]"
      ]
     },
     "execution_count": 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>79242905</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>19870122</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8173</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>47041223</td>\n",
       "      <td>1</td>\n",
       "      <td>60</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20051103</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6425</td>\n",
       "      <td>16.0</td>\n",
       "      <td>37216090</td>\n",
       "      <td>16.0</td>\n",
       "      <td>37014022.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>37014022</td>\n",
       "      <td>ASSEMBLEIADEDEUSFRANCA@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4938273</td>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20020131</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7963</td>\n",
       "      <td>41.0</td>\n",
       "      <td>2292148</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>2292148</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5561924</td>\n",
       "      <td>1</td>\n",
       "      <td>80</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20050516</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6131</td>\n",
       "      <td>19.0</td>\n",
       "      <td>34651679</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>42005868</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>19960630</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>3313</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>24512592</td>\n",
       "      <td>2</td>\n",
       "      <td>70</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20181120</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5623</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>4753430</th>\n",
       "      <td>24513020</td>\n",
       "      <td>4</td>\n",
       "      <td>77</td>\n",
       "      <td>2</td>\n",
       "      <td>TRANSFIGUEIREDO</td>\n",
       "      <td>8</td>\n",
       "      <td>19951228</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1761</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>4753431</th>\n",
       "      <td>24514093</td>\n",
       "      <td>2</td>\n",
       "      <td>11</td>\n",
       "      <td>2</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>1981</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>4753432</th>\n",
       "      <td>5991530</td>\n",
       "      <td>1</td>\n",
       "      <td>62</td>\n",
       "      <td>1</td>\n",
       "      <td>CENTRO DE FORMACAO DE CONDUTORES VANTE</td>\n",
       "      <td>2</td>\n",
       "      <td>20051103</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4701</td>\n",
       "      <td>38.0</td>\n",
       "      <td>38213634.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AUTOESCOLAVANTE@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>24515793</td>\n",
       "      <td>2</td>\n",
       "      <td>20</td>\n",
       "      <td>2</td>\n",
       "      <td>LOJAS RIBAMAR</td>\n",
       "      <td>2</td>\n",
       "      <td>20010526</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1639</td>\n",
       "      <td>84.0</td>\n",
       "      <td>34211688.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>96849190.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>34211567.0</td>\n",
       "      <td>FMCONTABILIDADE2012@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4753434 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         DESCRIÇÃO TIPO LOGRADOURO  LOGRADOURO  NUMERO  COMPLEMENTO  \\\n",
       "0                         79242905           1      28            1   \n",
       "1                         47041223           1      60            1   \n",
       "2                          4938273           1      32            1   \n",
       "3                          5561924           1      80            1   \n",
       "4                         42005868           1      24            1   \n",
       "...                            ...         ...     ...          ...   \n",
       "4753429                   24512592           2      70            2   \n",
       "4753430                   24513020           4      77            2   \n",
       "4753431                   24514093           2      11            2   \n",
       "4753432                    5991530           1      62            1   \n",
       "4753433                   24515793           2      20            2   \n",
       "\n",
       "                                         BAIRRO  CEP        UF  \\\n",
       "0                                           NaN    8  19870122   \n",
       "1                                           NaN    2  20051103   \n",
       "2                                           NaN    2  20020131   \n",
       "3                                           NaN    8  20050516   \n",
       "4                                           NaN    8  19960630   \n",
       "...                                         ...  ...       ...   \n",
       "4753429                                     NaN    4  20181120   \n",
       "4753430                         TRANSFIGUEIREDO    8  19951228   \n",
       "4753431                                     NaN    8  20081231   \n",
       "4753432  CENTRO DE FORMACAO DE CONDUTORES VANTE    2  20051103   \n",
       "4753433                           LOJAS RIBAMAR    2  20010526   \n",
       "\n",
       "         CODIGO MUNICIPIO MUNICIPIO  DDD-TELEFONE-1  ...  \\\n",
       "0                       1       NaN             NaN  ...   \n",
       "1                       0       NaN             NaN  ...   \n",
       "2                       0       NaN             NaN  ...   \n",
       "3                       1       NaN             NaN  ...   \n",
       "4                       1       NaN             NaN  ...   \n",
       "...                   ...       ...             ...  ...   \n",
       "4753429                63       NaN             NaN  ...   \n",
       "4753430                 1       NaN             NaN  ...   \n",
       "4753431                71       NaN             NaN  ...   \n",
       "4753432                 0       NaN             NaN  ...   \n",
       "4753433                 0       NaN             NaN  ...   \n",
       "\n",
       "        CAPITAL SOCIAL DA EMPRESA  PORTE-EMPRESA OPÇÃO PELO SIMPLES  \\\n",
       "0                            8173            NaN                NaN   \n",
       "1                            6425           16.0           37216090   \n",
       "2                            7963           41.0            2292148   \n",
       "3                            6131           19.0           34651679   \n",
       "4                            3313            NaN                NaN   \n",
       "...                           ...            ...                ...   \n",
       "4753429                      5623            NaN                NaN   \n",
       "4753430                      1761            NaN                NaN   \n",
       "4753431                      1981            NaN                NaN   \n",
       "4753432                      4701           38.0         38213634.0   \n",
       "4753433                      1639           84.0         34211688.0   \n",
       "\n",
       "        DATA OPCAO PELO SIMPLES DATA EXCLUSÃO DO SIMPLES OPÇÃO PELO MEI  \\\n",
       "0                           NaN                      NaN            NaN   \n",
       "1                          16.0               37014022.0           16.0   \n",
       "2                           NaN                      NaN           41.0   \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                    84.0               96849190.0           84.0   \n",
       "\n",
       "        SITUAÇÃO ESPECIAL              DATA SITUAÇÃO ESPECIAL  FILLER  \\\n",
       "0                     NaN                                 NaN     NaN   \n",
       "1                37014022  ASSEMBLEIADEDEUSFRANCA@HOTMAIL.COM     NaN   \n",
       "2                 2292148                                 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           AUTOESCOLAVANTE@GMAIL.COM     NaN   \n",
       "4753433        34211567.0       FMCONTABILIDADE2012@GMAIL.COM     NaN   \n",
       "\n",
       "        FIM DE REGISTRO  \n",
       "0                   NaN  \n",
       "1                   NaN  \n",
       "2                   NaN  \n",
       "3                   NaN  \n",
       "4                   NaN  \n",
       "...                 ...  \n",
       "4753429             NaN  \n",
       "4753430             NaN  \n",
       "4753431             NaN  \n",
       "4753432             NaN  \n",
       "4753433             NaN  \n",
       "\n",
       "[4753434 rows x 30 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.to_csv('n_estabelecimento9.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
}