Exploração_Inicial_Dados.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "portfolio_01 = pd.read_csv('arquivos_de_dados/estaticos_portfolio1.csv')\n",
    "portfolio_02 = pd.read_csv('arquivos_de_dados/estaticos_portfolio2.csv')\n",
    "portfolio_03 = pd.read_csv('arquivos_de_dados/estaticos_portfolio3.csv')\n",
    "\n",
    "estatisticas_market = pd.read_csv('arquivos_de_dados/estaticos_market.csv/estaticos_market.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(462298, 182)\n",
      "(555, 182)\n",
      "(566, 2)\n",
      "(265, 2)\n"
     ]
    }
   ],
   "source": [
    "print(estatisticas_market.shape)\n",
    "print(portfolio_01.shape)\n",
    "print(portfolio_02.shape)\n",
    "print(portfolio_03.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "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>Unnamed: 0</th>\n",
       "      <th>id</th>\n",
       "      <th>fl_matriz</th>\n",
       "      <th>de_natureza_juridica</th>\n",
       "      <th>sg_uf</th>\n",
       "      <th>natureza_juridica_macro</th>\n",
       "      <th>de_ramo</th>\n",
       "      <th>setor</th>\n",
       "      <th>idade_empresa_anos</th>\n",
       "      <th>idade_emp_cat</th>\n",
       "      <th>...</th>\n",
       "      <th>media_meses_servicos</th>\n",
       "      <th>max_meses_servicos</th>\n",
       "      <th>min_meses_servicos</th>\n",
       "      <th>qt_funcionarios</th>\n",
       "      <th>qt_funcionarios_12meses</th>\n",
       "      <th>qt_funcionarios_24meses</th>\n",
       "      <th>tx_crescimento_12meses</th>\n",
       "      <th>tx_crescimento_24meses</th>\n",
       "      <th>tx_rotatividade</th>\n",
       "      <th>qt_filiais</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>a6984c3ae395090e3bee8ad63c3758b110de096d5d8195...</td>\n",
       "      <td>True</td>\n",
       "      <td>SOCIEDADE EMPRESARIA LIMITADA</td>\n",
       "      <td>RN</td>\n",
       "      <td>ENTIDADES EMPRESARIAIS</td>\n",
       "      <td>INDUSTRIA DA CONSTRUCAO</td>\n",
       "      <td>CONSTRUÇÃO CIVIL</td>\n",
       "      <td>14.457534</td>\n",
       "      <td>10 a 15</td>\n",
       "      <td>...</td>\n",
       "      <td>43.738462</td>\n",
       "      <td>93.266667</td>\n",
       "      <td>19.166667</td>\n",
       "      <td>26.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-3.703704</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>6178f41ade1365e44bc2c46654c2c8c0eaae27dcb476c4...</td>\n",
       "      <td>True</td>\n",
       "      <td>EMPRESARIO INDIVIDUAL</td>\n",
       "      <td>PI</td>\n",
       "      <td>OUTROS</td>\n",
       "      <td>SERVICOS DE ALOJAMENTO/ALIMENTACAO</td>\n",
       "      <td>SERVIÇO</td>\n",
       "      <td>1.463014</td>\n",
       "      <td>1 a 5</td>\n",
       "      <td>...</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",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>4a7e5069a397f12fdd7fd57111d6dc5d3ba558958efc02...</td>\n",
       "      <td>True</td>\n",
       "      <td>EMPRESARIO INDIVIDUAL</td>\n",
       "      <td>AM</td>\n",
       "      <td>OUTROS</td>\n",
       "      <td>TRANSPORTE, ARMAZENAGEM E CORREIO</td>\n",
       "      <td>SERVIÇO</td>\n",
       "      <td>7.093151</td>\n",
       "      <td>5 a 10</td>\n",
       "      <td>...</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",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>3348900fe63216a439d2e5238c79ddd46ede454df7b9d8...</td>\n",
       "      <td>True</td>\n",
       "      <td>EMPRESARIO INDIVIDUAL</td>\n",
       "      <td>AM</td>\n",
       "      <td>OUTROS</td>\n",
       "      <td>SERVICOS DIVERSOS</td>\n",
       "      <td>SERVIÇO</td>\n",
       "      <td>6.512329</td>\n",
       "      <td>5 a 10</td>\n",
       "      <td>...</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",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>1f9bcabc9d3173c1fe769899e4fac14b053037b953a1e4...</td>\n",
       "      <td>True</td>\n",
       "      <td>EMPRESARIO INDIVIDUAL</td>\n",
       "      <td>RN</td>\n",
       "      <td>OUTROS</td>\n",
       "      <td>SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS</td>\n",
       "      <td>SERVIÇO</td>\n",
       "      <td>3.200000</td>\n",
       "      <td>1 a 5</td>\n",
       "      <td>...</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",
       "      <td>0</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>462293</th>\n",
       "      <td>462293</td>\n",
       "      <td>469ee5fc984d0bb60aa2f40cda4d003d7c9b963d149ed3...</td>\n",
       "      <td>True</td>\n",
       "      <td>EMPRESARIO INDIVIDUAL</td>\n",
       "      <td>RN</td>\n",
       "      <td>OUTROS</td>\n",
       "      <td>COMERCIO E REPARACAO DE VEICULOS</td>\n",
       "      <td>COMERCIO</td>\n",
       "      <td>3.254795</td>\n",
       "      <td>1 a 5</td>\n",
       "      <td>...</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",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462294</th>\n",
       "      <td>462294</td>\n",
       "      <td>656f496e7e2fad708f0022d8ad97d2cb9344e839a5f3cb...</td>\n",
       "      <td>True</td>\n",
       "      <td>EMPRESARIO INDIVIDUAL</td>\n",
       "      <td>PI</td>\n",
       "      <td>OUTROS</td>\n",
       "      <td>SERVICOS ADMINISTRATIVOS</td>\n",
       "      <td>SERVIÇO</td>\n",
       "      <td>8.953425</td>\n",
       "      <td>5 a 10</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462295</th>\n",
       "      <td>462295</td>\n",
       "      <td>9b933a5cf2149d1338f00fb459d34a16b9b0f2e8d3e8e1...</td>\n",
       "      <td>True</td>\n",
       "      <td>ASSOCIACAO PRIVADA</td>\n",
       "      <td>MA</td>\n",
       "      <td>ENTIDADES SEM FINS LUCRATIVOS</td>\n",
       "      <td>SERVICOS DE SAUDE</td>\n",
       "      <td>SERVIÇO</td>\n",
       "      <td>20.745205</td>\n",
       "      <td>&gt; 20</td>\n",
       "      <td>...</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",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462296</th>\n",
       "      <td>462296</td>\n",
       "      <td>84db0f17467cf4f02439e01ade57150b6ac59d9dae53ed...</td>\n",
       "      <td>True</td>\n",
       "      <td>SOCIEDADE EMPRESARIA LIMITADA</td>\n",
       "      <td>RO</td>\n",
       "      <td>ENTIDADES EMPRESARIAIS</td>\n",
       "      <td>COMERCIO VAREJISTA</td>\n",
       "      <td>COMERCIO</td>\n",
       "      <td>1.909589</td>\n",
       "      <td>1 a 5</td>\n",
       "      <td>...</td>\n",
       "      <td>13.422222</td>\n",
       "      <td>19.733333</td>\n",
       "      <td>2.400000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462297</th>\n",
       "      <td>462297</td>\n",
       "      <td>3d43e934e150b86be1e67524f5ba1018b27da9ef25566d...</td>\n",
       "      <td>True</td>\n",
       "      <td>EMPRESARIO INDIVIDUAL</td>\n",
       "      <td>RO</td>\n",
       "      <td>OUTROS</td>\n",
       "      <td>TRANSPORTE, ARMAZENAGEM E CORREIO</td>\n",
       "      <td>SERVIÇO</td>\n",
       "      <td>0.797260</td>\n",
       "      <td>&lt;= 1</td>\n",
       "      <td>...</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",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>462298 rows × 182 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Unnamed: 0                                                 id  \\\n",
       "0                0  a6984c3ae395090e3bee8ad63c3758b110de096d5d8195...   \n",
       "1                1  6178f41ade1365e44bc2c46654c2c8c0eaae27dcb476c4...   \n",
       "2                2  4a7e5069a397f12fdd7fd57111d6dc5d3ba558958efc02...   \n",
       "3                3  3348900fe63216a439d2e5238c79ddd46ede454df7b9d8...   \n",
       "4                4  1f9bcabc9d3173c1fe769899e4fac14b053037b953a1e4...   \n",
       "...            ...                                                ...   \n",
       "462293      462293  469ee5fc984d0bb60aa2f40cda4d003d7c9b963d149ed3...   \n",
       "462294      462294  656f496e7e2fad708f0022d8ad97d2cb9344e839a5f3cb...   \n",
       "462295      462295  9b933a5cf2149d1338f00fb459d34a16b9b0f2e8d3e8e1...   \n",
       "462296      462296  84db0f17467cf4f02439e01ade57150b6ac59d9dae53ed...   \n",
       "462297      462297  3d43e934e150b86be1e67524f5ba1018b27da9ef25566d...   \n",
       "\n",
       "        fl_matriz           de_natureza_juridica sg_uf  \\\n",
       "0            True  SOCIEDADE EMPRESARIA LIMITADA    RN   \n",
       "1            True          EMPRESARIO INDIVIDUAL    PI   \n",
       "2            True          EMPRESARIO INDIVIDUAL    AM   \n",
       "3            True          EMPRESARIO INDIVIDUAL    AM   \n",
       "4            True          EMPRESARIO INDIVIDUAL    RN   \n",
       "...           ...                            ...   ...   \n",
       "462293       True          EMPRESARIO INDIVIDUAL    RN   \n",
       "462294       True          EMPRESARIO INDIVIDUAL    PI   \n",
       "462295       True             ASSOCIACAO PRIVADA    MA   \n",
       "462296       True  SOCIEDADE EMPRESARIA LIMITADA    RO   \n",
       "462297       True          EMPRESARIO INDIVIDUAL    RO   \n",
       "\n",
       "              natureza_juridica_macro  \\\n",
       "0              ENTIDADES EMPRESARIAIS   \n",
       "1                              OUTROS   \n",
       "2                              OUTROS   \n",
       "3                              OUTROS   \n",
       "4                              OUTROS   \n",
       "...                               ...   \n",
       "462293                         OUTROS   \n",
       "462294                         OUTROS   \n",
       "462295  ENTIDADES SEM FINS LUCRATIVOS   \n",
       "462296         ENTIDADES EMPRESARIAIS   \n",
       "462297                         OUTROS   \n",
       "\n",
       "                                               de_ramo             setor  \\\n",
       "0                              INDUSTRIA DA CONSTRUCAO  CONSTRUÇÃO CIVIL   \n",
       "1                   SERVICOS DE ALOJAMENTO/ALIMENTACAO           SERVIÇO   \n",
       "2                    TRANSPORTE, ARMAZENAGEM E CORREIO           SERVIÇO   \n",
       "3                                    SERVICOS DIVERSOS           SERVIÇO   \n",
       "4       SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS           SERVIÇO   \n",
       "...                                                ...               ...   \n",
       "462293                COMERCIO E REPARACAO DE VEICULOS          COMERCIO   \n",
       "462294                        SERVICOS ADMINISTRATIVOS           SERVIÇO   \n",
       "462295                               SERVICOS DE SAUDE           SERVIÇO   \n",
       "462296                              COMERCIO VAREJISTA          COMERCIO   \n",
       "462297               TRANSPORTE, ARMAZENAGEM E CORREIO           SERVIÇO   \n",
       "\n",
       "        idade_empresa_anos idade_emp_cat  ...  media_meses_servicos  \\\n",
       "0                14.457534       10 a 15  ...             43.738462   \n",
       "1                 1.463014         1 a 5  ...                   NaN   \n",
       "2                 7.093151        5 a 10  ...                   NaN   \n",
       "3                 6.512329        5 a 10  ...                   NaN   \n",
       "4                 3.200000         1 a 5  ...                   NaN   \n",
       "...                    ...           ...  ...                   ...   \n",
       "462293            3.254795         1 a 5  ...                   NaN   \n",
       "462294            8.953425        5 a 10  ...                   NaN   \n",
       "462295           20.745205          > 20  ...                   NaN   \n",
       "462296            1.909589         1 a 5  ...             13.422222   \n",
       "462297            0.797260          <= 1  ...                   NaN   \n",
       "\n",
       "        max_meses_servicos  min_meses_servicos  qt_funcionarios  \\\n",
       "0                93.266667           19.166667             26.0   \n",
       "1                      NaN                 NaN              NaN   \n",
       "2                      NaN                 NaN              NaN   \n",
       "3                      NaN                 NaN              NaN   \n",
       "4                      NaN                 NaN              NaN   \n",
       "...                    ...                 ...              ...   \n",
       "462293                 NaN                 NaN              NaN   \n",
       "462294                 NaN                 NaN              0.0   \n",
       "462295                 NaN                 NaN              NaN   \n",
       "462296           19.733333            2.400000              3.0   \n",
       "462297                 NaN                 NaN              NaN   \n",
       "\n",
       "        qt_funcionarios_12meses qt_funcionarios_24meses  \\\n",
       "0                          26.0                    27.0   \n",
       "1                           NaN                     NaN   \n",
       "2                           NaN                     NaN   \n",
       "3                           NaN                     NaN   \n",
       "4                           NaN                     NaN   \n",
       "...                         ...                     ...   \n",
       "462293                      NaN                     NaN   \n",
       "462294                      0.0                     0.0   \n",
       "462295                      NaN                     NaN   \n",
       "462296                      2.0                     0.0   \n",
       "462297                      NaN                     NaN   \n",
       "\n",
       "        tx_crescimento_12meses  tx_crescimento_24meses  tx_rotatividade  \\\n",
       "0                          0.0               -3.703704              0.0   \n",
       "1                          NaN                     NaN              NaN   \n",
       "2                          NaN                     NaN              NaN   \n",
       "3                          NaN                     NaN              NaN   \n",
       "4                          NaN                     NaN              NaN   \n",
       "...                        ...                     ...              ...   \n",
       "462293                     NaN                     NaN              NaN   \n",
       "462294                     NaN                     NaN              0.0   \n",
       "462295                     NaN                     NaN              NaN   \n",
       "462296                    50.0                     NaN              0.0   \n",
       "462297                     NaN                     NaN              NaN   \n",
       "\n",
       "       qt_filiais  \n",
       "0               0  \n",
       "1               0  \n",
       "2               0  \n",
       "3               0  \n",
       "4               0  \n",
       "...           ...  \n",
       "462293          0  \n",
       "462294          0  \n",
       "462295          0  \n",
       "462296          0  \n",
       "462297          0  \n",
       "\n",
       "[462298 rows x 182 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "estatisticas_market"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Observação\n",
    "Observamos que os arquivos portfolio_01 e estatisticas_market possuem exatamente o mesmo set de 'feats' de dados."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([ True,  True,  True,  True,  True,  True,  True,  True,  True,\n",
       "        True,  True,  True,  True,  True,  True,  True,  True,  True,\n",
       "        True,  True,  True,  True,  True,  True,  True,  True,  True,\n",
       "        True,  True,  True,  True,  True,  True,  True,  True,  True,\n",
       "        True,  True,  True,  True,  True,  True,  True,  True,  True,\n",
       "        True,  True,  True,  True,  True,  True,  True,  True,  True,\n",
       "        True,  True,  True,  True,  True,  True,  True,  True,  True,\n",
       "        True,  True,  True,  True,  True,  True,  True,  True,  True,\n",
       "        True,  True,  True,  True,  True,  True,  True,  True,  True,\n",
       "        True,  True,  True,  True,  True,  True,  True,  True,  True,\n",
       "        True,  True,  True,  True,  True,  True,  True,  True,  True,\n",
       "        True,  True,  True,  True,  True,  True,  True,  True,  True,\n",
       "        True,  True,  True,  True,  True,  True,  True,  True,  True,\n",
       "        True,  True,  True,  True,  True,  True,  True,  True,  True,\n",
       "        True,  True,  True,  True,  True,  True,  True,  True,  True,\n",
       "        True,  True,  True,  True,  True,  True,  True,  True,  True,\n",
       "        True,  True,  True,  True,  True,  True,  True,  True,  True,\n",
       "        True,  True,  True,  True,  True,  True,  True,  True,  True,\n",
       "        True,  True,  True,  True,  True,  True,  True,  True,  True,\n",
       "        True,  True,  True,  True,  True,  True,  True,  True,  True,\n",
       "        True,  True])"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "portfolio_01.columns == estatisticas_market.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Teste para ver se o arquivo estatistica_market contem todos os ids dos outros arquivos."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "True True True\n"
     ]
    }
   ],
   "source": [
    "coluna_id_dados_market = estatisticas_market['id']\n",
    "ids_port_01 = portfolio_01['id']\n",
    "ids_port_02 = portfolio_02['id']\n",
    "ids_port_03 = portfolio_03['id']\n",
    "\n",
    "market_contains_01 = set(coluna_id_dados_market).issuperset({*ids_port_01})\n",
    "market_contains_02 = set(coluna_id_dados_market).issuperset({*ids_port_02})\n",
    "market_contains_03 = set(coluna_id_dados_market).issuperset({*ids_port_03})\n",
    "\n",
    "print(market_contains_01, market_contains_02, market_contains_03)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Conferimos que o arquivo estatisticas_market contém todos os id que estão nos arquivos de porfolio."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "3913354c9e31cf5266291bd2ee93c11c6fecf1d74fca2b78dfa97ce019c2a609"
  },
  "kernelspec": {
   "display_name": "Python 3.9.7 ('aceleradev_ds')",
   "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.9.9"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}