estabelecimento3.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Edson\\AppData\\Local\\Temp\\ipykernel_9068\\565687779.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('estabelecimento3.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>27364560</th>\n",
       "      <th>0001</th>\n",
       "      <th>81</th>\n",
       "      <th>1</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>08</th>\n",
       "      <th>20221219</th>\n",
       "      <th>01</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>...</th>\n",
       "      <th>7107</th>\n",
       "      <th>11</th>\n",
       "      <th>21659600</th>\n",
       "      <th>11.1</th>\n",
       "      <th>21659601</th>\n",
       "      <th>Unnamed: 25</th>\n",
       "      <th>Unnamed: 26</th>\n",
       "      <th>SERGIO.CAPPELLINI@PCA.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>20101604</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20180222</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6425</td>\n",
       "      <td>16.0</td>\n",
       "      <td>37214671.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SERGIOBONAMIM@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>27364588</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20210422</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>3661</td>\n",
       "      <td>73.0</td>\n",
       "      <td>35250001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>rildonunes2016@hotmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>27364600</td>\n",
       "      <td>1</td>\n",
       "      <td>95</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20221103</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8705</td>\n",
       "      <td>55.0</td>\n",
       "      <td>91043738.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SPARREMBERGERD@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>27364613</td>\n",
       "      <td>1</td>\n",
       "      <td>64</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20211021</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2571</td>\n",
       "      <td>83.0</td>\n",
       "      <td>96172438.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DANIEL-SIQUEIRA90@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>27364626</td>\n",
       "      <td>1</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>BEL TERAPIA HOLISTICA</td>\n",
       "      <td>8</td>\n",
       "      <td>20230328</td>\n",
       "      <td>75</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7107</td>\n",
       "      <td>11.0</td>\n",
       "      <td>82893215.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BELCERIBELLI@HOTMAIL.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>15265563</td>\n",
       "      <td>1</td>\n",
       "      <td>89</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20180201</td>\n",
       "      <td>67</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4481</td>\n",
       "      <td>31.0</td>\n",
       "      <td>87733438.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>lucontagem26@hotmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753430</th>\n",
       "      <td>15266288</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20120326</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>59243850.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SON.AI@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753431</th>\n",
       "      <td>15266303</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20180201</td>\n",
       "      <td>67</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4123</td>\n",
       "      <td>31.0</td>\n",
       "      <td>35822027.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>mejvilar@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753432</th>\n",
       "      <td>15266318</td>\n",
       "      <td>1</td>\n",
       "      <td>96</td>\n",
       "      <td>1</td>\n",
       "      <td>RESTAURANTE RECANTO DO SABOR</td>\n",
       "      <td>8</td>\n",
       "      <td>20130227</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2051</td>\n",
       "      <td>83.0</td>\n",
       "      <td>88316614.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JUNIORCLAUDINOADM@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>15266336</td>\n",
       "      <td>1</td>\n",
       "      <td>78</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20231028</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6477</td>\n",
       "      <td>11.0</td>\n",
       "      <td>34357826.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>niccalcados@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": [
       "         27364560  0001  81  1                    Unnamed: 4  08  20221219  \\\n",
       "0        20101604     2  12  2                           NaN   8  20180222   \n",
       "1        27364588     1  19  1                           NaN   4  20210422   \n",
       "2        27364600     1  95  1                           NaN   8  20221103   \n",
       "3        27364613     1  64  1                           NaN   8  20211021   \n",
       "4        27364626     1  33  1         BEL TERAPIA HOLISTICA   8  20230328   \n",
       "...           ...   ...  .. ..                           ...  ..       ...   \n",
       "4753429  15265563     1  89  1                           NaN   8  20180201   \n",
       "4753430  15266288     1  18  1                           NaN   2  20120326   \n",
       "4753431  15266303     1  28  1                           NaN   8  20180201   \n",
       "4753432  15266318     1  96  1  RESTAURANTE RECANTO DO SABOR   8  20130227   \n",
       "4753433  15266336     1  78  1                           NaN   8  20231028   \n",
       "\n",
       "         01 Unnamed: 8  Unnamed: 9  ...  7107    11    21659600 11.1 21659601  \\\n",
       "0         1        NaN         NaN  ...  6425  16.0  37214671.0  NaN      NaN   \n",
       "1        63        NaN         NaN  ...  3661  73.0  35250001.0  NaN      NaN   \n",
       "2         1        NaN         NaN  ...  8705  55.0  91043738.0  NaN      NaN   \n",
       "3         1        NaN         NaN  ...  2571  83.0  96172438.0  NaN      NaN   \n",
       "4        75        NaN         NaN  ...  7107  11.0  82893215.0  NaN      NaN   \n",
       "...      ..        ...         ...  ...   ...   ...         ...  ...      ...   \n",
       "4753429  67        NaN         NaN  ...  4481  31.0  87733438.0  NaN      NaN   \n",
       "4753430   0        NaN         NaN  ...  7107  11.0  59243850.0  NaN      NaN   \n",
       "4753431  67        NaN         NaN  ...  4123  31.0  35822027.0  NaN      NaN   \n",
       "4753432   1        NaN         NaN  ...  2051  83.0  88316614.0  NaN      NaN   \n",
       "4753433   1        NaN         NaN  ...  6477  11.0  34357826.0  NaN      NaN   \n",
       "\n",
       "        Unnamed: 25 Unnamed: 26   SERGIO.CAPPELLINI@PCA.COM.BR  Unnamed: 28  \\\n",
       "0               NaN         NaN        SERGIOBONAMIM@GMAIL.COM          NaN   \n",
       "1               NaN         NaN     rildonunes2016@hotmail.com          NaN   \n",
       "2               NaN         NaN       SPARREMBERGERD@GMAIL.COM          NaN   \n",
       "3               NaN         NaN  DANIEL-SIQUEIRA90@HOTMAIL.COM          NaN   \n",
       "4               NaN         NaN       BELCERIBELLI@HOTMAIL.COM          NaN   \n",
       "...             ...         ...                            ...          ...   \n",
       "4753429         NaN         NaN       lucontagem26@hotmail.com          NaN   \n",
       "4753430         NaN         NaN             SON.AI@HOTMAIL.COM          NaN   \n",
       "4753431         NaN         NaN             mejvilar@gmail.com          NaN   \n",
       "4753432         NaN         NaN  JUNIORCLAUDINOADM@HOTMAIL.COM          NaN   \n",
       "4753433         NaN         NaN          niccalcados@gmail.com          NaN   \n",
       "\n",
       "        Unnamed: 29  \n",
       "0               NaN  \n",
       "1               NaN  \n",
       "2               NaN  \n",
       "3               NaN  \n",
       "4               NaN  \n",
       "...             ...  \n",
       "4753429         NaN  \n",
       "4753430         NaN  \n",
       "4753431         NaN  \n",
       "4753432         NaN  \n",
       "4753433         NaN  \n",
       "\n",
       "[4753434 rows x 30 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('estabelecimento3.csv', encoding = 'latin1', sep = ';')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Edson\\AppData\\Local\\Temp\\ipykernel_9068\\610598172.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('estabelecimento3.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>27364560</td>\n",
       "      <td>1</td>\n",
       "      <td>81</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20221219</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>21659600.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>21659601.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SERGIO.CAPPELLINI@PCA.COM.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20101604</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20180222</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6425</td>\n",
       "      <td>16.0</td>\n",
       "      <td>37214671.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SERGIOBONAMIM@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>27364588</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20210422</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>3661</td>\n",
       "      <td>73.0</td>\n",
       "      <td>35250001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>rildonunes2016@hotmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>27364600</td>\n",
       "      <td>1</td>\n",
       "      <td>95</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20221103</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8705</td>\n",
       "      <td>55.0</td>\n",
       "      <td>91043738.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SPARREMBERGERD@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>27364613</td>\n",
       "      <td>1</td>\n",
       "      <td>64</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20211021</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2571</td>\n",
       "      <td>83.0</td>\n",
       "      <td>96172438.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DANIEL-SIQUEIRA90@HOTMAIL.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>15265563</td>\n",
       "      <td>1</td>\n",
       "      <td>89</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20180201</td>\n",
       "      <td>67</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4481</td>\n",
       "      <td>31.0</td>\n",
       "      <td>87733438.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>lucontagem26@hotmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753431</th>\n",
       "      <td>15266288</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20120326</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>59243850.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SON.AI@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753432</th>\n",
       "      <td>15266303</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20180201</td>\n",
       "      <td>67</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4123</td>\n",
       "      <td>31.0</td>\n",
       "      <td>35822027.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>mejvilar@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>15266318</td>\n",
       "      <td>1</td>\n",
       "      <td>96</td>\n",
       "      <td>1</td>\n",
       "      <td>RESTAURANTE RECANTO DO SABOR</td>\n",
       "      <td>8</td>\n",
       "      <td>20130227</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2051</td>\n",
       "      <td>83.0</td>\n",
       "      <td>88316614.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JUNIORCLAUDINOADM@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753434</th>\n",
       "      <td>15266336</td>\n",
       "      <td>1</td>\n",
       "      <td>78</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20231028</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6477</td>\n",
       "      <td>11.0</td>\n",
       "      <td>34357826.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>niccalcados@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4753435 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               0   1   2   3                             4   5         6   7   \\\n",
       "0        27364560   1  81   1                           NaN   8  20221219   1   \n",
       "1        20101604   2  12   2                           NaN   8  20180222   1   \n",
       "2        27364588   1  19   1                           NaN   4  20210422  63   \n",
       "3        27364600   1  95   1                           NaN   8  20221103   1   \n",
       "4        27364613   1  64   1                           NaN   8  20211021   1   \n",
       "...           ...  ..  ..  ..                           ...  ..       ...  ..   \n",
       "4753430  15265563   1  89   1                           NaN   8  20180201  67   \n",
       "4753431  15266288   1  18   1                           NaN   2  20120326   0   \n",
       "4753432  15266303   1  28   1                           NaN   8  20180201  67   \n",
       "4753433  15266318   1  96   1  RESTAURANTE RECANTO DO SABOR   8  20130227   1   \n",
       "4753434  15266336   1  78   1                           NaN   8  20231028   1   \n",
       "\n",
       "          8   9   ...    20    21          22    23          24  25   26  \\\n",
       "0        NaN NaN  ...  7107  11.0  21659600.0  11.0  21659601.0 NaN  NaN   \n",
       "1        NaN NaN  ...  6425  16.0  37214671.0   NaN         NaN NaN  NaN   \n",
       "2        NaN NaN  ...  3661  73.0  35250001.0   NaN         NaN NaN  NaN   \n",
       "3        NaN NaN  ...  8705  55.0  91043738.0   NaN         NaN NaN  NaN   \n",
       "4        NaN NaN  ...  2571  83.0  96172438.0   NaN         NaN NaN  NaN   \n",
       "...      ...  ..  ...   ...   ...         ...   ...         ...  ..  ...   \n",
       "4753430  NaN NaN  ...  4481  31.0  87733438.0   NaN         NaN NaN  NaN   \n",
       "4753431  NaN NaN  ...  7107  11.0  59243850.0   NaN         NaN NaN  NaN   \n",
       "4753432  NaN NaN  ...  4123  31.0  35822027.0   NaN         NaN NaN  NaN   \n",
       "4753433  NaN NaN  ...  2051  83.0  88316614.0   NaN         NaN NaN  NaN   \n",
       "4753434  NaN NaN  ...  6477  11.0  34357826.0   NaN         NaN NaN  NaN   \n",
       "\n",
       "                                    27   28  29  \n",
       "0         SERGIO.CAPPELLINI@PCA.COM.BR  NaN NaN  \n",
       "1              SERGIOBONAMIM@GMAIL.COM  NaN NaN  \n",
       "2           rildonunes2016@hotmail.com  NaN NaN  \n",
       "3             SPARREMBERGERD@GMAIL.COM  NaN NaN  \n",
       "4        DANIEL-SIQUEIRA90@HOTMAIL.COM  NaN NaN  \n",
       "...                                ...  ...  ..  \n",
       "4753430       lucontagem26@hotmail.com  NaN NaN  \n",
       "4753431             SON.AI@HOTMAIL.COM  NaN NaN  \n",
       "4753432             mejvilar@gmail.com  NaN NaN  \n",
       "4753433  JUNIORCLAUDINOADM@HOTMAIL.COM  NaN NaN  \n",
       "4753434          niccalcados@gmail.com  NaN NaN  \n",
       "\n",
       "[4753435 rows x 30 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('estabelecimento3.csv', encoding = 'latin1', sep = ';', header=None)\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>27364560</td>\n",
       "      <td>1</td>\n",
       "      <td>81</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20221219</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>21659600.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>21659601.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SERGIO.CAPPELLINI@PCA.COM.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20101604</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20180222</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6425</td>\n",
       "      <td>16.0</td>\n",
       "      <td>37214671.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SERGIOBONAMIM@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>27364588</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20210422</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>3661</td>\n",
       "      <td>73.0</td>\n",
       "      <td>35250001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>rildonunes2016@hotmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>27364600</td>\n",
       "      <td>1</td>\n",
       "      <td>95</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20221103</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8705</td>\n",
       "      <td>55.0</td>\n",
       "      <td>91043738.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SPARREMBERGERD@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>27364613</td>\n",
       "      <td>1</td>\n",
       "      <td>64</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20211021</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2571</td>\n",
       "      <td>83.0</td>\n",
       "      <td>96172438.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DANIEL-SIQUEIRA90@HOTMAIL.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>15265563</td>\n",
       "      <td>1</td>\n",
       "      <td>89</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20180201</td>\n",
       "      <td>67</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4481</td>\n",
       "      <td>31.0</td>\n",
       "      <td>87733438.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>lucontagem26@hotmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753431</th>\n",
       "      <td>15266288</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20120326</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>59243850.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SON.AI@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753432</th>\n",
       "      <td>15266303</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20180201</td>\n",
       "      <td>67</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4123</td>\n",
       "      <td>31.0</td>\n",
       "      <td>35822027.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>mejvilar@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>15266318</td>\n",
       "      <td>1</td>\n",
       "      <td>96</td>\n",
       "      <td>1</td>\n",
       "      <td>RESTAURANTE RECANTO DO SABOR</td>\n",
       "      <td>8</td>\n",
       "      <td>20130227</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2051</td>\n",
       "      <td>83.0</td>\n",
       "      <td>88316614.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JUNIORCLAUDINOADM@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753434</th>\n",
       "      <td>15266336</td>\n",
       "      <td>1</td>\n",
       "      <td>78</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20231028</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6477</td>\n",
       "      <td>11.0</td>\n",
       "      <td>34357826.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>niccalcados@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4753435 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         DESCRIÇÃO TIPO LOGRADOURO  LOGRADOURO  NUMERO  COMPLEMENTO  \\\n",
       "0                         27364560           1      81            1   \n",
       "1                         20101604           2      12            2   \n",
       "2                         27364588           1      19            1   \n",
       "3                         27364600           1      95            1   \n",
       "4                         27364613           1      64            1   \n",
       "...                            ...         ...     ...          ...   \n",
       "4753430                   15265563           1      89            1   \n",
       "4753431                   15266288           1      18            1   \n",
       "4753432                   15266303           1      28            1   \n",
       "4753433                   15266318           1      96            1   \n",
       "4753434                   15266336           1      78            1   \n",
       "\n",
       "                               BAIRRO  CEP        UF  CODIGO MUNICIPIO  \\\n",
       "0                                 NaN    8  20221219                 1   \n",
       "1                                 NaN    8  20180222                 1   \n",
       "2                                 NaN    4  20210422                63   \n",
       "3                                 NaN    8  20221103                 1   \n",
       "4                                 NaN    8  20211021                 1   \n",
       "...                               ...  ...       ...               ...   \n",
       "4753430                           NaN    8  20180201                67   \n",
       "4753431                           NaN    2  20120326                 0   \n",
       "4753432                           NaN    8  20180201                67   \n",
       "4753433  RESTAURANTE RECANTO DO SABOR    8  20130227                 1   \n",
       "4753434                           NaN    8  20231028                 1   \n",
       "\n",
       "        MUNICIPIO  DDD-TELEFONE-1  ...  CAPITAL SOCIAL DA EMPRESA  \\\n",
       "0             NaN             NaN  ...                       7107   \n",
       "1             NaN             NaN  ...                       6425   \n",
       "2             NaN             NaN  ...                       3661   \n",
       "3             NaN             NaN  ...                       8705   \n",
       "4             NaN             NaN  ...                       2571   \n",
       "...           ...             ...  ...                        ...   \n",
       "4753430       NaN             NaN  ...                       4481   \n",
       "4753431       NaN             NaN  ...                       7107   \n",
       "4753432       NaN             NaN  ...                       4123   \n",
       "4753433       NaN             NaN  ...                       2051   \n",
       "4753434       NaN             NaN  ...                       6477   \n",
       "\n",
       "         PORTE-EMPRESA OPÇÃO PELO SIMPLES DATA OPCAO PELO SIMPLES  \\\n",
       "0                 11.0         21659600.0                    11.0   \n",
       "1                 16.0         37214671.0                     NaN   \n",
       "2                 73.0         35250001.0                     NaN   \n",
       "3                 55.0         91043738.0                     NaN   \n",
       "4                 83.0         96172438.0                     NaN   \n",
       "...                ...                ...                     ...   \n",
       "4753430           31.0         87733438.0                     NaN   \n",
       "4753431           11.0         59243850.0                     NaN   \n",
       "4753432           31.0         35822027.0                     NaN   \n",
       "4753433           83.0         88316614.0                     NaN   \n",
       "4753434           11.0         34357826.0                     NaN   \n",
       "\n",
       "        DATA EXCLUSÃO DO SIMPLES OPÇÃO PELO MEI SITUAÇÃO ESPECIAL  \\\n",
       "0                     21659601.0            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         SERGIO.CAPPELLINI@PCA.COM.BR     NaN             NaN  \n",
       "1              SERGIOBONAMIM@GMAIL.COM     NaN             NaN  \n",
       "2           rildonunes2016@hotmail.com     NaN             NaN  \n",
       "3             SPARREMBERGERD@GMAIL.COM     NaN             NaN  \n",
       "4        DANIEL-SIQUEIRA90@HOTMAIL.COM     NaN             NaN  \n",
       "...                                ...     ...             ...  \n",
       "4753430       lucontagem26@hotmail.com     NaN             NaN  \n",
       "4753431             SON.AI@HOTMAIL.COM     NaN             NaN  \n",
       "4753432             mejvilar@gmail.com     NaN             NaN  \n",
       "4753433  JUNIORCLAUDINOADM@HOTMAIL.COM     NaN             NaN  \n",
       "4753434          niccalcados@gmail.com     NaN             NaN  \n",
       "\n",
       "[4753435 rows x 30 columns]"
      ]
     },
     "execution_count": 6,
     "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": 7,
   "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>27364560</td>\n",
       "      <td>1</td>\n",
       "      <td>81</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20221219</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>21659600.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>21659601.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SERGIO.CAPPELLINI@PCA.COM.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20101604</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20180222</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6425</td>\n",
       "      <td>16.0</td>\n",
       "      <td>37214671.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SERGIOBONAMIM@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>27364588</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20210422</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>3661</td>\n",
       "      <td>73.0</td>\n",
       "      <td>35250001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>rildonunes2016@hotmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>27364600</td>\n",
       "      <td>1</td>\n",
       "      <td>95</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20221103</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8705</td>\n",
       "      <td>55.0</td>\n",
       "      <td>91043738.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SPARREMBERGERD@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>27364613</td>\n",
       "      <td>1</td>\n",
       "      <td>64</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20211021</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2571</td>\n",
       "      <td>83.0</td>\n",
       "      <td>96172438.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DANIEL-SIQUEIRA90@HOTMAIL.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>15266249</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>20211009</td>\n",
       "      <td>74</td>\n",
       "      <td>NaN</td>\n",
       "      <td>573.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9707</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>15265563</td>\n",
       "      <td>1</td>\n",
       "      <td>89</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20180201</td>\n",
       "      <td>67</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4481</td>\n",
       "      <td>31.0</td>\n",
       "      <td>87733438.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>lucontagem26@hotmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753431</th>\n",
       "      <td>15266288</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20120326</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>59243850.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SON.AI@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753432</th>\n",
       "      <td>15266303</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20180201</td>\n",
       "      <td>67</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4123</td>\n",
       "      <td>31.0</td>\n",
       "      <td>35822027.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>mejvilar@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>15266318</td>\n",
       "      <td>1</td>\n",
       "      <td>96</td>\n",
       "      <td>1</td>\n",
       "      <td>RESTAURANTE RECANTO DO SABOR</td>\n",
       "      <td>8</td>\n",
       "      <td>20130227</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2051</td>\n",
       "      <td>83.0</td>\n",
       "      <td>88316614.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JUNIORCLAUDINOADM@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                         27364560           1      81            1   \n",
       "1                         20101604           2      12            2   \n",
       "2                         27364588           1      19            1   \n",
       "3                         27364600           1      95            1   \n",
       "4                         27364613           1      64            1   \n",
       "...                            ...         ...     ...          ...   \n",
       "4753429                   15266249           1      10            1   \n",
       "4753430                   15265563           1      89            1   \n",
       "4753431                   15266288           1      18            1   \n",
       "4753432                   15266303           1      28            1   \n",
       "4753433                   15266318           1      96            1   \n",
       "\n",
       "                               BAIRRO  CEP        UF  CODIGO MUNICIPIO  \\\n",
       "0                                 NaN    8  20221219                 1   \n",
       "1                                 NaN    8  20180222                 1   \n",
       "2                                 NaN    4  20210422                63   \n",
       "3                                 NaN    8  20221103                 1   \n",
       "4                                 NaN    8  20211021                 1   \n",
       "...                               ...  ...       ...               ...   \n",
       "4753429                           NaN    3  20211009                74   \n",
       "4753430                           NaN    8  20180201                67   \n",
       "4753431                           NaN    2  20120326                 0   \n",
       "4753432                           NaN    8  20180201                67   \n",
       "4753433  RESTAURANTE RECANTO DO SABOR    8  20130227                 1   \n",
       "\n",
       "        MUNICIPIO  DDD-TELEFONE-1  ...  CAPITAL SOCIAL DA EMPRESA  \\\n",
       "0             NaN             NaN  ...                       7107   \n",
       "1             NaN             NaN  ...                       6425   \n",
       "2             NaN             NaN  ...                       3661   \n",
       "3             NaN             NaN  ...                       8705   \n",
       "4             NaN             NaN  ...                       2571   \n",
       "...           ...             ...  ...                        ...   \n",
       "4753429       NaN           573.0  ...                       9707   \n",
       "4753430       NaN             NaN  ...                       4481   \n",
       "4753431       NaN             NaN  ...                       7107   \n",
       "4753432       NaN             NaN  ...                       4123   \n",
       "4753433       NaN             NaN  ...                       2051   \n",
       "\n",
       "         PORTE-EMPRESA OPÇÃO PELO SIMPLES DATA OPCAO PELO SIMPLES  \\\n",
       "0                 11.0         21659600.0                    11.0   \n",
       "1                 16.0         37214671.0                     NaN   \n",
       "2                 73.0         35250001.0                     NaN   \n",
       "3                 55.0         91043738.0                     NaN   \n",
       "4                 83.0         96172438.0                     NaN   \n",
       "...                ...                ...                     ...   \n",
       "4753429            NaN                NaN                     NaN   \n",
       "4753430           31.0         87733438.0                     NaN   \n",
       "4753431           11.0         59243850.0                     NaN   \n",
       "4753432           31.0         35822027.0                     NaN   \n",
       "4753433           83.0         88316614.0                     NaN   \n",
       "\n",
       "        DATA EXCLUSÃO DO SIMPLES OPÇÃO PELO MEI SITUAÇÃO ESPECIAL  \\\n",
       "0                     21659601.0            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         SERGIO.CAPPELLINI@PCA.COM.BR     NaN             NaN  \n",
       "1              SERGIOBONAMIM@GMAIL.COM     NaN             NaN  \n",
       "2           rildonunes2016@hotmail.com     NaN             NaN  \n",
       "3             SPARREMBERGERD@GMAIL.COM     NaN             NaN  \n",
       "4        DANIEL-SIQUEIRA90@HOTMAIL.COM     NaN             NaN  \n",
       "...                                ...     ...             ...  \n",
       "4753429                            NaN     NaN             NaN  \n",
       "4753430       lucontagem26@hotmail.com     NaN             NaN  \n",
       "4753431             SON.AI@HOTMAIL.COM     NaN             NaN  \n",
       "4753432             mejvilar@gmail.com     NaN             NaN  \n",
       "4753433  JUNIORCLAUDINOADM@HOTMAIL.COM     NaN             NaN  \n",
       "\n",
       "[4753434 rows x 30 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.drop(df.tail(1).index, inplace=True)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>27364560</td>\n",
       "      <td>1</td>\n",
       "      <td>81</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20221219</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>21659600.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>21659601.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SERGIO.CAPPELLINI@PCA.COM.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20101604</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20180222</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6425</td>\n",
       "      <td>16.0</td>\n",
       "      <td>37214671.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SERGIOBONAMIM@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>27364588</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20210422</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>3661</td>\n",
       "      <td>73.0</td>\n",
       "      <td>35250001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>rildonunes2016@hotmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>27364600</td>\n",
       "      <td>1</td>\n",
       "      <td>95</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20221103</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8705</td>\n",
       "      <td>55.0</td>\n",
       "      <td>91043738.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SPARREMBERGERD@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>27364613</td>\n",
       "      <td>1</td>\n",
       "      <td>64</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20211021</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2571</td>\n",
       "      <td>83.0</td>\n",
       "      <td>96172438.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DANIEL-SIQUEIRA90@HOTMAIL.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>15266249</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>20211009</td>\n",
       "      <td>74</td>\n",
       "      <td>NaN</td>\n",
       "      <td>573.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9707</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>15265563</td>\n",
       "      <td>1</td>\n",
       "      <td>89</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20180201</td>\n",
       "      <td>67</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4481</td>\n",
       "      <td>31.0</td>\n",
       "      <td>87733438.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>lucontagem26@hotmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753431</th>\n",
       "      <td>15266288</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20120326</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>59243850.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SON.AI@HOTMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753432</th>\n",
       "      <td>15266303</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20180201</td>\n",
       "      <td>67</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4123</td>\n",
       "      <td>31.0</td>\n",
       "      <td>35822027.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>mejvilar@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753433</th>\n",
       "      <td>15266318</td>\n",
       "      <td>1</td>\n",
       "      <td>96</td>\n",
       "      <td>1</td>\n",
       "      <td>RESTAURANTE RECANTO DO SABOR</td>\n",
       "      <td>8</td>\n",
       "      <td>20130227</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2051</td>\n",
       "      <td>83.0</td>\n",
       "      <td>88316614.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JUNIORCLAUDINOADM@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                         27364560           1      81            1   \n",
       "1                         20101604           2      12            2   \n",
       "2                         27364588           1      19            1   \n",
       "3                         27364600           1      95            1   \n",
       "4                         27364613           1      64            1   \n",
       "...                            ...         ...     ...          ...   \n",
       "4753429                   15266249           1      10            1   \n",
       "4753430                   15265563           1      89            1   \n",
       "4753431                   15266288           1      18            1   \n",
       "4753432                   15266303           1      28            1   \n",
       "4753433                   15266318           1      96            1   \n",
       "\n",
       "                               BAIRRO  CEP        UF  CODIGO MUNICIPIO  \\\n",
       "0                                 NaN    8  20221219                 1   \n",
       "1                                 NaN    8  20180222                 1   \n",
       "2                                 NaN    4  20210422                63   \n",
       "3                                 NaN    8  20221103                 1   \n",
       "4                                 NaN    8  20211021                 1   \n",
       "...                               ...  ...       ...               ...   \n",
       "4753429                           NaN    3  20211009                74   \n",
       "4753430                           NaN    8  20180201                67   \n",
       "4753431                           NaN    2  20120326                 0   \n",
       "4753432                           NaN    8  20180201                67   \n",
       "4753433  RESTAURANTE RECANTO DO SABOR    8  20130227                 1   \n",
       "\n",
       "        MUNICIPIO  DDD-TELEFONE-1  ...  CAPITAL SOCIAL DA EMPRESA  \\\n",
       "0             NaN             NaN  ...                       7107   \n",
       "1             NaN             NaN  ...                       6425   \n",
       "2             NaN             NaN  ...                       3661   \n",
       "3             NaN             NaN  ...                       8705   \n",
       "4             NaN             NaN  ...                       2571   \n",
       "...           ...             ...  ...                        ...   \n",
       "4753429       NaN           573.0  ...                       9707   \n",
       "4753430       NaN             NaN  ...                       4481   \n",
       "4753431       NaN             NaN  ...                       7107   \n",
       "4753432       NaN             NaN  ...                       4123   \n",
       "4753433       NaN             NaN  ...                       2051   \n",
       "\n",
       "         PORTE-EMPRESA OPÇÃO PELO SIMPLES DATA OPCAO PELO SIMPLES  \\\n",
       "0                 11.0         21659600.0                    11.0   \n",
       "1                 16.0         37214671.0                     NaN   \n",
       "2                 73.0         35250001.0                     NaN   \n",
       "3                 55.0         91043738.0                     NaN   \n",
       "4                 83.0         96172438.0                     NaN   \n",
       "...                ...                ...                     ...   \n",
       "4753429            NaN                NaN                     NaN   \n",
       "4753430           31.0         87733438.0                     NaN   \n",
       "4753431           11.0         59243850.0                     NaN   \n",
       "4753432           31.0         35822027.0                     NaN   \n",
       "4753433           83.0         88316614.0                     NaN   \n",
       "\n",
       "        DATA EXCLUSÃO DO SIMPLES OPÇÃO PELO MEI SITUAÇÃO ESPECIAL  \\\n",
       "0                     21659601.0            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         SERGIO.CAPPELLINI@PCA.COM.BR     NaN             NaN  \n",
       "1              SERGIOBONAMIM@GMAIL.COM     NaN             NaN  \n",
       "2           rildonunes2016@hotmail.com     NaN             NaN  \n",
       "3             SPARREMBERGERD@GMAIL.COM     NaN             NaN  \n",
       "4        DANIEL-SIQUEIRA90@HOTMAIL.COM     NaN             NaN  \n",
       "...                                ...     ...             ...  \n",
       "4753429                            NaN     NaN             NaN  \n",
       "4753430       lucontagem26@hotmail.com     NaN             NaN  \n",
       "4753431             SON.AI@HOTMAIL.COM     NaN             NaN  \n",
       "4753432             mejvilar@gmail.com     NaN             NaN  \n",
       "4753433  JUNIORCLAUDINOADM@HOTMAIL.COM     NaN             NaN  \n",
       "\n",
       "[4753434 rows x 30 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.to_csv('n_estabelecimento3.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
}