estabelecimento0.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Edson\\AppData\\Local\\Temp\\ipykernel_13008\\3409278919.py:1: DtypeWarning: Columns (8,18,21,22,24,26,28) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  df = pd.read_csv('estabelecimento0.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>20765798</th>\n",
       "      <th>0001</th>\n",
       "      <th>70</th>\n",
       "      <th>1</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>08</th>\n",
       "      <th>20010219</th>\n",
       "      <th>01</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>...</th>\n",
       "      <th>4569</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>76137801</td>\n",
       "      <td>1</td>\n",
       "      <td>65</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20081231</td>\n",
       "      <td>71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7557</td>\n",
       "      <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>61079117</td>\n",
       "      <td>205</td>\n",
       "      <td>56</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>19960527</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7099</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>6900758</td>\n",
       "      <td>1</td>\n",
       "      <td>62</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20181016</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7107</td>\n",
       "      <td>11.0</td>\n",
       "      <td>32423000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RODOLFO.COSTA@BISCALDIBUENO.ADV.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>38692695</td>\n",
       "      <td>1</td>\n",
       "      <td>92</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20081231</td>\n",
       "      <td>71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5401</td>\n",
       "      <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>4733969</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "      <td>SOUSA PECAS</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>3643</td>\n",
       "      <td>73.0</td>\n",
       "      <td>32652481</td>\n",
       "      <td>73.0</td>\n",
       "      <td>32652481.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>32652481</td>\n",
       "      <td>conteci.contabilidade@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>17486898</th>\n",
       "      <td>54718383</td>\n",
       "      <td>1</td>\n",
       "      <td>67</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20240413</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2531</td>\n",
       "      <td>81.0</td>\n",
       "      <td>71104883.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PRCONSULTORIACONTABIL@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17486899</th>\n",
       "      <td>54718394</td>\n",
       "      <td>1</td>\n",
       "      <td>47</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20240413</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8327</td>\n",
       "      <td>48.0</td>\n",
       "      <td>99113907.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LUISHS98C@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17486900</th>\n",
       "      <td>54718404</td>\n",
       "      <td>1</td>\n",
       "      <td>44</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20240413</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4479</td>\n",
       "      <td>32.0</td>\n",
       "      <td>84894601.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANDREGERSOUZA22@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17486901</th>\n",
       "      <td>54718415</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20240413</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1731</td>\n",
       "      <td>84.0</td>\n",
       "      <td>99335013.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DANTASJOSE707@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17486902</th>\n",
       "      <td>54718427</td>\n",
       "      <td>1</td>\n",
       "      <td>59</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20240413</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6727</td>\n",
       "      <td>16.0</td>\n",
       "      <td>32411276.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JULIA.CAMPOS23@OUTLOOK.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17486903 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          20765798  0001  70  1   Unnamed: 4  08  20010219  01 Unnamed: 8  \\\n",
       "0         76137801     1  65  1          NaN   8  20081231  71        NaN   \n",
       "1         61079117   205  56  2          NaN   8  19960527   1        NaN   \n",
       "2          6900758     1  62  1          NaN   4  20181016  63        NaN   \n",
       "3         38692695     1  92  1          NaN   8  20081231  71        NaN   \n",
       "4          4733969     1  22  1  SOUSA PECAS   4  20210422  63        NaN   \n",
       "...            ...   ...  .. ..          ...  ..       ...  ..        ...   \n",
       "17486898  54718383     1  67  1          NaN   2  20240413   0        NaN   \n",
       "17486899  54718394     1  47  1          NaN   2  20240413   0        NaN   \n",
       "17486900  54718404     1  44  1          NaN   2  20240413   0        NaN   \n",
       "17486901  54718415     1  24  1          NaN   2  20240413   0        NaN   \n",
       "17486902  54718427     1  59  1          NaN   2  20240413   0        NaN   \n",
       "\n",
       "          Unnamed: 9  ...  4569  Unnamed: 21 Unnamed: 22 Unnamed: 23  \\\n",
       "0                NaN  ...  7557          NaN         NaN         NaN   \n",
       "1                NaN  ...  7099          NaN         NaN         NaN   \n",
       "2                NaN  ...  7107         11.0    32423000         NaN   \n",
       "3                NaN  ...  5401          NaN         NaN         NaN   \n",
       "4                NaN  ...  3643         73.0    32652481        73.0   \n",
       "...              ...  ...   ...          ...         ...         ...   \n",
       "17486898         NaN  ...  2531         81.0  71104883.0         NaN   \n",
       "17486899         NaN  ...  8327         48.0  99113907.0         NaN   \n",
       "17486900         NaN  ...  4479         32.0  84894601.0         NaN   \n",
       "17486901         NaN  ...  1731         84.0  99335013.0         NaN   \n",
       "17486902         NaN  ...  6727         16.0  32411276.0         NaN   \n",
       "\n",
       "         Unnamed: 24 Unnamed: 25 Unnamed: 26  \\\n",
       "0                NaN         NaN         NaN   \n",
       "1                NaN         NaN         NaN   \n",
       "2                NaN         NaN         NaN   \n",
       "3                NaN         NaN         NaN   \n",
       "4         32652481.0        73.0    32652481   \n",
       "...              ...         ...         ...   \n",
       "17486898         NaN         NaN         NaN   \n",
       "17486899         NaN         NaN         NaN   \n",
       "17486900         NaN         NaN         NaN   \n",
       "17486901         NaN         NaN         NaN   \n",
       "17486902         NaN         NaN         NaN   \n",
       "\n",
       "                                 Unnamed: 27 Unnamed: 28 Unnamed: 29  \n",
       "0                                        NaN         NaN         NaN  \n",
       "1                                        NaN         NaN         NaN  \n",
       "2         RODOLFO.COSTA@BISCALDIBUENO.ADV.BR         NaN         NaN  \n",
       "3                                        NaN         NaN         NaN  \n",
       "4          conteci.contabilidade@hotmail.com         NaN         NaN  \n",
       "...                                      ...         ...         ...  \n",
       "17486898     PRCONSULTORIACONTABIL@GMAIL.COM         NaN         NaN  \n",
       "17486899                 LUISHS98C@GMAIL.COM         NaN         NaN  \n",
       "17486900           ANDREGERSOUZA22@GMAIL.COM         NaN         NaN  \n",
       "17486901             DANTASJOSE707@GMAIL.COM         NaN         NaN  \n",
       "17486902          JULIA.CAMPOS23@OUTLOOK.COM         NaN         NaN  \n",
       "\n",
       "[17486903 rows x 30 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('estabelecimento0.csv', encoding = 'latin1', sep = ';')\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>20765798</th>\n",
       "      <th>0001</th>\n",
       "      <th>70</th>\n",
       "      <th>1</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>08</th>\n",
       "      <th>20010219</th>\n",
       "      <th>01</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>...</th>\n",
       "      <th>4569</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>76137801</td>\n",
       "      <td>1</td>\n",
       "      <td>65</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20081231</td>\n",
       "      <td>71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7557</td>\n",
       "      <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>61079117</td>\n",
       "      <td>205</td>\n",
       "      <td>56</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>19960527</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7099</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>6900758</td>\n",
       "      <td>1</td>\n",
       "      <td>62</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>20181016</td>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7107</td>\n",
       "      <td>11.0</td>\n",
       "      <td>32423000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RODOLFO.COSTA@BISCALDIBUENO.ADV.BR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>38692695</td>\n",
       "      <td>1</td>\n",
       "      <td>92</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>20081231</td>\n",
       "      <td>71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5401</td>\n",
       "      <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>4733969</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "      <td>SOUSA PECAS</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>3643</td>\n",
       "      <td>73.0</td>\n",
       "      <td>32652481</td>\n",
       "      <td>73.0</td>\n",
       "      <td>32652481.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>32652481</td>\n",
       "      <td>conteci.contabilidade@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>17486897</th>\n",
       "      <td>54718371</td>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20240413</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6001</td>\n",
       "      <td>21.0</td>\n",
       "      <td>96517775.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DAVID_RUAN1@ICLOUD.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17486898</th>\n",
       "      <td>54718383</td>\n",
       "      <td>1</td>\n",
       "      <td>67</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20240413</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2531</td>\n",
       "      <td>81.0</td>\n",
       "      <td>71104883.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PRCONSULTORIACONTABIL@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17486899</th>\n",
       "      <td>54718394</td>\n",
       "      <td>1</td>\n",
       "      <td>47</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20240413</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8327</td>\n",
       "      <td>48.0</td>\n",
       "      <td>99113907.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LUISHS98C@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17486900</th>\n",
       "      <td>54718404</td>\n",
       "      <td>1</td>\n",
       "      <td>44</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20240413</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4479</td>\n",
       "      <td>32.0</td>\n",
       "      <td>84894601.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANDREGERSOUZA22@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17486901</th>\n",
       "      <td>54718415</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>20240413</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1731</td>\n",
       "      <td>84.0</td>\n",
       "      <td>99335013.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DANTASJOSE707@GMAIL.COM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17486902 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          20765798  0001  70  1   Unnamed: 4  08  20010219  01 Unnamed: 8  \\\n",
       "0         76137801     1  65  1          NaN   8  20081231  71        NaN   \n",
       "1         61079117   205  56  2          NaN   8  19960527   1        NaN   \n",
       "2          6900758     1  62  1          NaN   4  20181016  63        NaN   \n",
       "3         38692695     1  92  1          NaN   8  20081231  71        NaN   \n",
       "4          4733969     1  22  1  SOUSA PECAS   4  20210422  63        NaN   \n",
       "...            ...   ...  .. ..          ...  ..       ...  ..        ...   \n",
       "17486897  54718371     1  32  1          NaN   2  20240413   0        NaN   \n",
       "17486898  54718383     1  67  1          NaN   2  20240413   0        NaN   \n",
       "17486899  54718394     1  47  1          NaN   2  20240413   0        NaN   \n",
       "17486900  54718404     1  44  1          NaN   2  20240413   0        NaN   \n",
       "17486901  54718415     1  24  1          NaN   2  20240413   0        NaN   \n",
       "\n",
       "          Unnamed: 9  ...  4569  Unnamed: 21 Unnamed: 22 Unnamed: 23  \\\n",
       "0                NaN  ...  7557          NaN         NaN         NaN   \n",
       "1                NaN  ...  7099          NaN         NaN         NaN   \n",
       "2                NaN  ...  7107         11.0    32423000         NaN   \n",
       "3                NaN  ...  5401          NaN         NaN         NaN   \n",
       "4                NaN  ...  3643         73.0    32652481        73.0   \n",
       "...              ...  ...   ...          ...         ...         ...   \n",
       "17486897         NaN  ...  6001         21.0  96517775.0         NaN   \n",
       "17486898         NaN  ...  2531         81.0  71104883.0         NaN   \n",
       "17486899         NaN  ...  8327         48.0  99113907.0         NaN   \n",
       "17486900         NaN  ...  4479         32.0  84894601.0         NaN   \n",
       "17486901         NaN  ...  1731         84.0  99335013.0         NaN   \n",
       "\n",
       "         Unnamed: 24 Unnamed: 25 Unnamed: 26  \\\n",
       "0                NaN         NaN         NaN   \n",
       "1                NaN         NaN         NaN   \n",
       "2                NaN         NaN         NaN   \n",
       "3                NaN         NaN         NaN   \n",
       "4         32652481.0        73.0    32652481   \n",
       "...              ...         ...         ...   \n",
       "17486897         NaN         NaN         NaN   \n",
       "17486898         NaN         NaN         NaN   \n",
       "17486899         NaN         NaN         NaN   \n",
       "17486900         NaN         NaN         NaN   \n",
       "17486901         NaN         NaN         NaN   \n",
       "\n",
       "                                 Unnamed: 27 Unnamed: 28 Unnamed: 29  \n",
       "0                                        NaN         NaN         NaN  \n",
       "1                                        NaN         NaN         NaN  \n",
       "2         RODOLFO.COSTA@BISCALDIBUENO.ADV.BR         NaN         NaN  \n",
       "3                                        NaN         NaN         NaN  \n",
       "4          conteci.contabilidade@hotmail.com         NaN         NaN  \n",
       "...                                      ...         ...         ...  \n",
       "17486897              DAVID_RUAN1@ICLOUD.COM         NaN         NaN  \n",
       "17486898     PRCONSULTORIACONTABIL@GMAIL.COM         NaN         NaN  \n",
       "17486899                 LUISHS98C@GMAIL.COM         NaN         NaN  \n",
       "17486900           ANDREGERSOUZA22@GMAIL.COM         NaN         NaN  \n",
       "17486901             DANTASJOSE707@GMAIL.COM         NaN         NaN  \n",
       "\n",
       "[17486902 rows x 30 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.drop(df.tail(1).index, inplace=True)\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
}