acao_3_tratar_conceitos_fundamentalistas_mensais.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "69ec3098",
   "metadata": {},
   "source": [
    "# Objetivo\n",
    "\n",
    "Aqui vamos atuar em cima das bases mensais para calcular conceitos e avaliações fundamentalistas. São elas:\n",
    "- Graham atualizado por setor\n",
    "- Flag - Acima ou abaixo do preço de graham ajustado?\n",
    "- Flag - Acima ou abaixo do `DY %` médio do setor?\n",
    "- Flag - Acima de 10% de DY?\n",
    "\n",
    "## Bibliotecas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "78ca57c0",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Geral\n",
    "import warnings\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "\n",
    "# Plots\n",
    "import seaborn as sns\n",
    "import plotly.express as px\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "# Remover warnings chatos do pandas\n",
    "warnings.filterwarnings(\"ignore\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "42081934",
   "metadata": {},
   "source": [
    "## Calcular Preço de Graham Ajustado"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "id": "cbd3cad7",
   "metadata": {},
   "outputs": [],
   "source": [
    "def calcular_preco_graham_setor(pl, pvp, lpa, vpa):\n",
    "    # Calcular valor\n",
    "    val = pl * pvp * lpa * vpa\n",
    "    if val > 0:\n",
    "        return round(np.sqrt(val), 2)\n",
    "    else:\n",
    "        return np.nan"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c8595b98",
   "metadata": {},
   "source": [
    "# Execução"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "d2282dd7",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Carregar base(s)\n",
    "df = pd.read_csv('dados/2_TRA/fundamentus_2023-11-02.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b3a67546",
   "metadata": {},
   "source": [
    "**Agregados por setor necessários**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "71798399",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Gerar agregados\n",
    "df_agg = df[['SETOR', 'P_POR_L', 'P_POR_VP', 'DIV_YIELD']].groupby('SETOR').median().reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "7871e012",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Modificar colunas\n",
    "df_agg.columns = [c if c == 'SETOR' else f'AGG_{c}' for c in df_agg.columns]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "69edc53b",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Unificar informações na base\n",
    "df = pd.merge(df, df_agg, on='SETOR', how='left')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "7febfbdc",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Calcular cotação de graham ajustada ao setor\n",
    "df['COTACAO_GRAHAM_SETOR'] = df.apply(lambda x: calcular_preco_graham_setor(x['AGG_P_POR_L'],\n",
    "                                                                            x['AGG_P_POR_VP'],\n",
    "                                                                            x['LPA'],\n",
    "                                                                            x['VPA']), axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "8f5f12c1",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Criar razão - Acima indica um valor de cotação abaixo do que deveria\n",
    "df['RAZAO_COTACAO_GRAHAM'] = (df['COTACAO_GRAHAM_SETOR']/df['COTACAO']).round(2)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "70e6a6a6",
   "metadata": {},
   "source": [
    "**Criar Flags**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "95185d2f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['FLAG_MENOR_GRAHAM_SETOR'] = (df['COTACAO'] < df['COTACAO_GRAHAM_SETOR']).astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "34f7364c",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['FLAG_DY_ACIMA_10'] = (df['DIV_YIELD'] >= 10).astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "9d23414f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['FLAG_DY_ACIMA_DY_SETOR'] = (df['DIV_YIELD'] >= df['AGG_DIV_YIELD']).astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "a6065922",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['FLAG_MENOR_GRAHAM_ACIMA_DY_SETOR'] = (df['FLAG_DY_ACIMA_DY_SETOR'] == 1) & (df['FLAG_DY_ACIMA_DY_SETOR'] == 1)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b824a552",
   "metadata": {},
   "source": [
    "**Avaliação de Carteira**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "d8147761",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Definir papeis atuais a partir da carteira e seus setores\n",
    "papeis_atuais = ['BBAS3','ITSA3','EGIE3','TAEE4','PETR4','PRIO3','VALE3','TUPY3']\n",
    "setores_atuais = df.loc[df['PAPEL'].isin(papeis_atuais), 'SETOR'].unique().tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "a3ae754f",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Criar dataframe de análise\n",
    "df_aval = df.loc[df['SETOR'].isin(setores_atuais)] "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "37c015e2",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Flag para apontar papeis de sua carteira\n",
    "df_aval['CARTEIRA'] = df_aval['PAPEL'].isin(papeis_atuais).astype(int).copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "2e7051cd",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Definir colunas de analise\n",
    "cols = ['PAPEL','SETOR','COTACAO','COTACAO_GRAHAM_SETOR', 'RAZAO_COTACAO_GRAHAM', 'DIV_YIELD','AGG_DIV_YIELD', 'P_POR_L']\n",
    "cols += ['OSCILACOES_%_2023', 'LPA', 'VPA', 'MARG_EBIT', 'MARG_LIQUIDA']\n",
    "cols += [c for c in df.columns if 'FLAG' in c]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "8653df2e",
   "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>PAPEL</th>\n",
       "      <th>SETOR</th>\n",
       "      <th>COTACAO</th>\n",
       "      <th>COTACAO_GRAHAM_SETOR</th>\n",
       "      <th>RAZAO_COTACAO_GRAHAM</th>\n",
       "      <th>DIV_YIELD</th>\n",
       "      <th>AGG_DIV_YIELD</th>\n",
       "      <th>P_POR_L</th>\n",
       "      <th>OSCILACOES_%_2023</th>\n",
       "      <th>LPA</th>\n",
       "      <th>VPA</th>\n",
       "      <th>MARG_EBIT</th>\n",
       "      <th>MARG_LIQUIDA</th>\n",
       "      <th>FLAG_MENOR_GRAHAM_SETOR</th>\n",
       "      <th>FLAG_DY_ACIMA_10</th>\n",
       "      <th>FLAG_DY_ACIMA_DY_SETOR</th>\n",
       "      <th>FLAG_MENOR_GRAHAM_ACIMA_DY_SETOR</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>TAEE4</td>\n",
       "      <td>Energia Elétrica</td>\n",
       "      <td>11.27</td>\n",
       "      <td>9.17</td>\n",
       "      <td>0.81</td>\n",
       "      <td>10.0</td>\n",
       "      <td>6.80</td>\n",
       "      <td>9.97</td>\n",
       "      <td>2.98</td>\n",
       "      <td>1.13</td>\n",
       "      <td>6.47</td>\n",
       "      <td>63.1</td>\n",
       "      <td>49.8</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>EGIE3</td>\n",
       "      <td>Energia Elétrica</td>\n",
       "      <td>40.62</td>\n",
       "      <td>21.60</td>\n",
       "      <td>0.53</td>\n",
       "      <td>8.7</td>\n",
       "      <td>6.80</td>\n",
       "      <td>10.23</td>\n",
       "      <td>14.38</td>\n",
       "      <td>3.97</td>\n",
       "      <td>10.22</td>\n",
       "      <td>46.6</td>\n",
       "      <td>28.5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>BBAS3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>49.34</td>\n",
       "      <td>68.82</td>\n",
       "      <td>1.39</td>\n",
       "      <td>9.3</td>\n",
       "      <td>6.55</td>\n",
       "      <td>4.27</td>\n",
       "      <td>52.02</td>\n",
       "      <td>11.55</td>\n",
       "      <td>54.86</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>ITSA3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>8.82</td>\n",
       "      <td>9.01</td>\n",
       "      <td>1.02</td>\n",
       "      <td>7.8</td>\n",
       "      <td>6.55</td>\n",
       "      <td>6.45</td>\n",
       "      <td>4.08</td>\n",
       "      <td>1.37</td>\n",
       "      <td>7.92</td>\n",
       "      <td>14.1</td>\n",
       "      <td>175.5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>283</th>\n",
       "      <td>TUPY3</td>\n",
       "      <td>Material de Transporte</td>\n",
       "      <td>24.91</td>\n",
       "      <td>22.39</td>\n",
       "      <td>0.90</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.95</td>\n",
       "      <td>7.93</td>\n",
       "      <td>-5.31</td>\n",
       "      <td>3.14</td>\n",
       "      <td>21.56</td>\n",
       "      <td>8.2</td>\n",
       "      <td>4.2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291</th>\n",
       "      <td>VALE3</td>\n",
       "      <td>Mineração</td>\n",
       "      <td>62.68</td>\n",
       "      <td>50.97</td>\n",
       "      <td>0.81</td>\n",
       "      <td>6.5</td>\n",
       "      <td>12.70</td>\n",
       "      <td>5.00</td>\n",
       "      <td>-26.08</td>\n",
       "      <td>12.54</td>\n",
       "      <td>41.20</td>\n",
       "      <td>37.8</td>\n",
       "      <td>27.8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>303</th>\n",
       "      <td>PETR4</td>\n",
       "      <td>Petróleo, Gás e Biocombustíveis</td>\n",
       "      <td>37.85</td>\n",
       "      <td>49.10</td>\n",
       "      <td>1.30</td>\n",
       "      <td>24.4</td>\n",
       "      <td>1.35</td>\n",
       "      <td>3.16</td>\n",
       "      <td>90.66</td>\n",
       "      <td>11.99</td>\n",
       "      <td>28.42</td>\n",
       "      <td>45.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306</th>\n",
       "      <td>PRIO3</td>\n",
       "      <td>Petróleo, Gás e Biocombustíveis</td>\n",
       "      <td>49.70</td>\n",
       "      <td>18.98</td>\n",
       "      <td>0.38</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.35</td>\n",
       "      <td>11.85</td>\n",
       "      <td>33.57</td>\n",
       "      <td>4.20</td>\n",
       "      <td>12.12</td>\n",
       "      <td>57.3</td>\n",
       "      <td>46.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     PAPEL                            SETOR  COTACAO  COTACAO_GRAHAM_SETOR  \\\n",
       "155  TAEE4                 Energia Elétrica    11.27                  9.17   \n",
       "157  EGIE3                 Energia Elétrica    40.62                 21.60   \n",
       "210  BBAS3       Intermediários Financeiros    49.34                 68.82   \n",
       "218  ITSA3       Intermediários Financeiros     8.82                  9.01   \n",
       "283  TUPY3           Material de Transporte    24.91                 22.39   \n",
       "291  VALE3                        Mineração    62.68                 50.97   \n",
       "303  PETR4  Petróleo, Gás e Biocombustíveis    37.85                 49.10   \n",
       "306  PRIO3  Petróleo, Gás e Biocombustíveis    49.70                 18.98   \n",
       "\n",
       "     RAZAO_COTACAO_GRAHAM  DIV_YIELD  AGG_DIV_YIELD  P_POR_L  \\\n",
       "155                  0.81       10.0           6.80     9.97   \n",
       "157                  0.53        8.7           6.80    10.23   \n",
       "210                  1.39        9.3           6.55     4.27   \n",
       "218                  1.02        7.8           6.55     6.45   \n",
       "283                  0.90        3.0           2.95     7.93   \n",
       "291                  0.81        6.5          12.70     5.00   \n",
       "303                  1.30       24.4           1.35     3.16   \n",
       "306                  0.38        0.0           1.35    11.85   \n",
       "\n",
       "     OSCILACOES_%_2023    LPA    VPA  MARG_EBIT  MARG_LIQUIDA  \\\n",
       "155               2.98   1.13   6.47       63.1          49.8   \n",
       "157              14.38   3.97  10.22       46.6          28.5   \n",
       "210              52.02  11.55  54.86        NaN           0.0   \n",
       "218               4.08   1.37   7.92       14.1         175.5   \n",
       "283              -5.31   3.14  21.56        8.2           4.2   \n",
       "291             -26.08  12.54  41.20       37.8          27.8   \n",
       "303              90.66  11.99  28.42       45.0          27.0   \n",
       "306              33.57   4.20  12.12       57.3          46.0   \n",
       "\n",
       "     FLAG_MENOR_GRAHAM_SETOR  FLAG_DY_ACIMA_10  FLAG_DY_ACIMA_DY_SETOR  \\\n",
       "155                        0                 1                       1   \n",
       "157                        0                 0                       1   \n",
       "210                        1                 0                       1   \n",
       "218                        1                 0                       1   \n",
       "283                        0                 0                       1   \n",
       "291                        0                 0                       0   \n",
       "303                        1                 1                       1   \n",
       "306                        0                 0                       0   \n",
       "\n",
       "     FLAG_MENOR_GRAHAM_ACIMA_DY_SETOR  \n",
       "155                              True  \n",
       "157                              True  \n",
       "210                              True  \n",
       "218                              True  \n",
       "283                              True  \n",
       "291                             False  \n",
       "303                              True  \n",
       "306                             False  "
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Visualizar\n",
    "df_aval.loc[df_aval['CARTEIRA'] == 1, cols]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "id": "326972fc",
   "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>PAPEL</th>\n",
       "      <th>SETOR</th>\n",
       "      <th>COTACAO</th>\n",
       "      <th>COTACAO_GRAHAM_SETOR</th>\n",
       "      <th>RAZAO_COTACAO_GRAHAM</th>\n",
       "      <th>DIV_YIELD</th>\n",
       "      <th>AGG_DIV_YIELD</th>\n",
       "      <th>P_POR_L</th>\n",
       "      <th>OSCILACOES_%_2023</th>\n",
       "      <th>LPA</th>\n",
       "      <th>VPA</th>\n",
       "      <th>MARG_EBIT</th>\n",
       "      <th>MARG_LIQUIDA</th>\n",
       "      <th>FLAG_MENOR_GRAHAM_SETOR</th>\n",
       "      <th>FLAG_DY_ACIMA_10</th>\n",
       "      <th>FLAG_DY_ACIMA_DY_SETOR</th>\n",
       "      <th>FLAG_MENOR_GRAHAM_ACIMA_DY_SETOR</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>MERC4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>7.16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.3</td>\n",
       "      <td>6.55</td>\n",
       "      <td>-35.86</td>\n",
       "      <td>1.10</td>\n",
       "      <td>-0.20</td>\n",
       "      <td>13.81</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>BRBI11</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>11.65</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.2</td>\n",
       "      <td>6.55</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2.87</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>BNBR3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>93.06</td>\n",
       "      <td>148.53</td>\n",
       "      <td>1.60</td>\n",
       "      <td>6.7</td>\n",
       "      <td>6.55</td>\n",
       "      <td>3.60</td>\n",
       "      <td>32.07</td>\n",
       "      <td>25.85</td>\n",
       "      <td>114.19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>BAZA3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>86.89</td>\n",
       "      <td>127.39</td>\n",
       "      <td>1.47</td>\n",
       "      <td>6.4</td>\n",
       "      <td>6.55</td>\n",
       "      <td>3.90</td>\n",
       "      <td>85.77</td>\n",
       "      <td>22.28</td>\n",
       "      <td>97.45</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>BBAS3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>49.34</td>\n",
       "      <td>68.82</td>\n",
       "      <td>1.39</td>\n",
       "      <td>9.3</td>\n",
       "      <td>6.55</td>\n",
       "      <td>4.27</td>\n",
       "      <td>52.02</td>\n",
       "      <td>11.55</td>\n",
       "      <td>54.86</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>BMEB4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>11.64</td>\n",
       "      <td>16.03</td>\n",
       "      <td>1.38</td>\n",
       "      <td>6.9</td>\n",
       "      <td>6.55</td>\n",
       "      <td>4.46</td>\n",
       "      <td>23.02</td>\n",
       "      <td>2.61</td>\n",
       "      <td>13.18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>ABCB4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>19.35</td>\n",
       "      <td>25.30</td>\n",
       "      <td>1.31</td>\n",
       "      <td>6.2</td>\n",
       "      <td>6.55</td>\n",
       "      <td>5.42</td>\n",
       "      <td>5.04</td>\n",
       "      <td>3.57</td>\n",
       "      <td>23.98</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>PINE4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>3.53</td>\n",
       "      <td>4.62</td>\n",
       "      <td>1.31</td>\n",
       "      <td>4.6</td>\n",
       "      <td>6.55</td>\n",
       "      <td>6.18</td>\n",
       "      <td>127.05</td>\n",
       "      <td>0.57</td>\n",
       "      <td>5.02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>BGIP4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>22.36</td>\n",
       "      <td>31.05</td>\n",
       "      <td>1.39</td>\n",
       "      <td>15.3</td>\n",
       "      <td>6.55</td>\n",
       "      <td>6.13</td>\n",
       "      <td>46.85</td>\n",
       "      <td>3.65</td>\n",
       "      <td>35.35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>BMEB3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>13.47</td>\n",
       "      <td>16.03</td>\n",
       "      <td>1.19</td>\n",
       "      <td>5.4</td>\n",
       "      <td>6.55</td>\n",
       "      <td>5.16</td>\n",
       "      <td>41.09</td>\n",
       "      <td>2.61</td>\n",
       "      <td>13.18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>ITSA4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>8.74</td>\n",
       "      <td>9.01</td>\n",
       "      <td>1.03</td>\n",
       "      <td>7.9</td>\n",
       "      <td>6.55</td>\n",
       "      <td>6.39</td>\n",
       "      <td>7.95</td>\n",
       "      <td>1.37</td>\n",
       "      <td>7.92</td>\n",
       "      <td>14.1</td>\n",
       "      <td>175.5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>BRSR6</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>11.00</td>\n",
       "      <td>17.90</td>\n",
       "      <td>1.63</td>\n",
       "      <td>8.6</td>\n",
       "      <td>6.55</td>\n",
       "      <td>5.90</td>\n",
       "      <td>21.19</td>\n",
       "      <td>1.86</td>\n",
       "      <td>23.04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>ITSA3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>8.82</td>\n",
       "      <td>9.01</td>\n",
       "      <td>1.02</td>\n",
       "      <td>7.8</td>\n",
       "      <td>6.55</td>\n",
       "      <td>6.45</td>\n",
       "      <td>4.08</td>\n",
       "      <td>1.37</td>\n",
       "      <td>7.92</td>\n",
       "      <td>14.1</td>\n",
       "      <td>175.5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>BRSR3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>11.65</td>\n",
       "      <td>17.90</td>\n",
       "      <td>1.54</td>\n",
       "      <td>8.1</td>\n",
       "      <td>6.55</td>\n",
       "      <td>6.25</td>\n",
       "      <td>15.78</td>\n",
       "      <td>1.86</td>\n",
       "      <td>23.04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>ITUB3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>23.13</td>\n",
       "      <td>20.46</td>\n",
       "      <td>0.88</td>\n",
       "      <td>6.5</td>\n",
       "      <td>6.55</td>\n",
       "      <td>7.18</td>\n",
       "      <td>9.64</td>\n",
       "      <td>3.22</td>\n",
       "      <td>17.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>BGIP3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>27.06</td>\n",
       "      <td>31.05</td>\n",
       "      <td>1.15</td>\n",
       "      <td>11.5</td>\n",
       "      <td>6.55</td>\n",
       "      <td>7.42</td>\n",
       "      <td>15.05</td>\n",
       "      <td>3.65</td>\n",
       "      <td>35.35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>PINE3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>4.16</td>\n",
       "      <td>4.62</td>\n",
       "      <td>1.11</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.55</td>\n",
       "      <td>7.28</td>\n",
       "      <td>194.10</td>\n",
       "      <td>0.57</td>\n",
       "      <td>5.02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>BEES3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>8.56</td>\n",
       "      <td>7.21</td>\n",
       "      <td>0.84</td>\n",
       "      <td>7.3</td>\n",
       "      <td>6.55</td>\n",
       "      <td>8.12</td>\n",
       "      <td>64.82</td>\n",
       "      <td>1.05</td>\n",
       "      <td>6.63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>ITUB4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>26.96</td>\n",
       "      <td>20.46</td>\n",
       "      <td>0.76</td>\n",
       "      <td>5.5</td>\n",
       "      <td>6.55</td>\n",
       "      <td>8.37</td>\n",
       "      <td>11.15</td>\n",
       "      <td>3.22</td>\n",
       "      <td>17.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>BBDC3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>12.45</td>\n",
       "      <td>12.74</td>\n",
       "      <td>1.02</td>\n",
       "      <td>7.4</td>\n",
       "      <td>6.55</td>\n",
       "      <td>8.58</td>\n",
       "      <td>-2.23</td>\n",
       "      <td>1.45</td>\n",
       "      <td>14.97</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>BMIN4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>15.99</td>\n",
       "      <td>20.13</td>\n",
       "      <td>1.26</td>\n",
       "      <td>9.9</td>\n",
       "      <td>6.55</td>\n",
       "      <td>8.23</td>\n",
       "      <td>32.27</td>\n",
       "      <td>1.94</td>\n",
       "      <td>27.96</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>BEES4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>9.61</td>\n",
       "      <td>7.21</td>\n",
       "      <td>0.75</td>\n",
       "      <td>6.5</td>\n",
       "      <td>6.55</td>\n",
       "      <td>9.11</td>\n",
       "      <td>55.84</td>\n",
       "      <td>1.05</td>\n",
       "      <td>6.63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>BBDC4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>14.16</td>\n",
       "      <td>12.74</td>\n",
       "      <td>0.90</td>\n",
       "      <td>7.1</td>\n",
       "      <td>6.55</td>\n",
       "      <td>9.76</td>\n",
       "      <td>-1.27</td>\n",
       "      <td>1.45</td>\n",
       "      <td>14.97</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>BRIV3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>10.53</td>\n",
       "      <td>12.72</td>\n",
       "      <td>1.21</td>\n",
       "      <td>1.5</td>\n",
       "      <td>6.55</td>\n",
       "      <td>9.31</td>\n",
       "      <td>14.37</td>\n",
       "      <td>1.13</td>\n",
       "      <td>19.17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>BRIV4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>10.51</td>\n",
       "      <td>12.72</td>\n",
       "      <td>1.21</td>\n",
       "      <td>6.1</td>\n",
       "      <td>6.55</td>\n",
       "      <td>9.29</td>\n",
       "      <td>19.40</td>\n",
       "      <td>1.13</td>\n",
       "      <td>19.17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>BRSR5</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>18.20</td>\n",
       "      <td>17.90</td>\n",
       "      <td>0.98</td>\n",
       "      <td>5.3</td>\n",
       "      <td>6.55</td>\n",
       "      <td>9.76</td>\n",
       "      <td>8.46</td>\n",
       "      <td>1.86</td>\n",
       "      <td>23.04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>BMGB4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>2.35</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.43</td>\n",
       "      <td>16.4</td>\n",
       "      <td>6.55</td>\n",
       "      <td>10.17</td>\n",
       "      <td>7.72</td>\n",
       "      <td>0.23</td>\n",
       "      <td>6.58</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>SANB3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>12.35</td>\n",
       "      <td>9.90</td>\n",
       "      <td>0.80</td>\n",
       "      <td>6.6</td>\n",
       "      <td>6.55</td>\n",
       "      <td>10.57</td>\n",
       "      <td>-2.18</td>\n",
       "      <td>1.17</td>\n",
       "      <td>11.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>RPAD5</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>7.80</td>\n",
       "      <td>8.31</td>\n",
       "      <td>1.07</td>\n",
       "      <td>7.4</td>\n",
       "      <td>6.55</td>\n",
       "      <td>10.85</td>\n",
       "      <td>21.98</td>\n",
       "      <td>0.72</td>\n",
       "      <td>12.83</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>RPAD3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>7.76</td>\n",
       "      <td>8.31</td>\n",
       "      <td>1.07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.55</td>\n",
       "      <td>10.80</td>\n",
       "      <td>8.68</td>\n",
       "      <td>0.72</td>\n",
       "      <td>12.83</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>BPAC5</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>7.79</td>\n",
       "      <td>4.71</td>\n",
       "      <td>0.60</td>\n",
       "      <td>3.2</td>\n",
       "      <td>6.55</td>\n",
       "      <td>10.66</td>\n",
       "      <td>42.14</td>\n",
       "      <td>0.73</td>\n",
       "      <td>4.06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>SANB11</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>26.21</td>\n",
       "      <td>19.79</td>\n",
       "      <td>0.76</td>\n",
       "      <td>6.6</td>\n",
       "      <td>6.55</td>\n",
       "      <td>11.21</td>\n",
       "      <td>-2.12</td>\n",
       "      <td>2.34</td>\n",
       "      <td>22.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>RPAD6</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>7.60</td>\n",
       "      <td>8.31</td>\n",
       "      <td>1.09</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.55</td>\n",
       "      <td>10.57</td>\n",
       "      <td>13.60</td>\n",
       "      <td>0.72</td>\n",
       "      <td>12.83</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>BMIN3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>23.92</td>\n",
       "      <td>20.13</td>\n",
       "      <td>0.84</td>\n",
       "      <td>5.9</td>\n",
       "      <td>6.55</td>\n",
       "      <td>12.31</td>\n",
       "      <td>31.24</td>\n",
       "      <td>1.94</td>\n",
       "      <td>27.96</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>SANB4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>13.84</td>\n",
       "      <td>9.90</td>\n",
       "      <td>0.72</td>\n",
       "      <td>6.5</td>\n",
       "      <td>6.55</td>\n",
       "      <td>11.84</td>\n",
       "      <td>-2.55</td>\n",
       "      <td>1.17</td>\n",
       "      <td>11.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>BPAC11</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>29.23</td>\n",
       "      <td>14.12</td>\n",
       "      <td>0.48</td>\n",
       "      <td>2.5</td>\n",
       "      <td>6.55</td>\n",
       "      <td>13.34</td>\n",
       "      <td>24.08</td>\n",
       "      <td>2.19</td>\n",
       "      <td>12.18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>BPAN4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>7.61</td>\n",
       "      <td>5.00</td>\n",
       "      <td>0.66</td>\n",
       "      <td>3.4</td>\n",
       "      <td>6.55</td>\n",
       "      <td>14.18</td>\n",
       "      <td>25.37</td>\n",
       "      <td>0.54</td>\n",
       "      <td>6.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>BPAC3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>13.26</td>\n",
       "      <td>4.71</td>\n",
       "      <td>0.36</td>\n",
       "      <td>1.9</td>\n",
       "      <td>6.55</td>\n",
       "      <td>18.15</td>\n",
       "      <td>3.72</td>\n",
       "      <td>0.73</td>\n",
       "      <td>4.06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>CRIV3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>5.70</td>\n",
       "      <td>4.38</td>\n",
       "      <td>0.77</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.55</td>\n",
       "      <td>22.45</td>\n",
       "      <td>10.04</td>\n",
       "      <td>0.25</td>\n",
       "      <td>10.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>CRIV4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>5.65</td>\n",
       "      <td>4.38</td>\n",
       "      <td>0.78</td>\n",
       "      <td>8.5</td>\n",
       "      <td>6.55</td>\n",
       "      <td>22.25</td>\n",
       "      <td>18.51</td>\n",
       "      <td>0.25</td>\n",
       "      <td>10.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      PAPEL                       SETOR  COTACAO  COTACAO_GRAHAM_SETOR  \\\n",
       "206   MERC4  Intermediários Financeiros     7.16                   NaN   \n",
       "207  BRBI11  Intermediários Financeiros    11.65                   NaN   \n",
       "208   BNBR3  Intermediários Financeiros    93.06                148.53   \n",
       "209   BAZA3  Intermediários Financeiros    86.89                127.39   \n",
       "210   BBAS3  Intermediários Financeiros    49.34                 68.82   \n",
       "211   BMEB4  Intermediários Financeiros    11.64                 16.03   \n",
       "212   ABCB4  Intermediários Financeiros    19.35                 25.30   \n",
       "213   PINE4  Intermediários Financeiros     3.53                  4.62   \n",
       "214   BGIP4  Intermediários Financeiros    22.36                 31.05   \n",
       "215   BMEB3  Intermediários Financeiros    13.47                 16.03   \n",
       "216   ITSA4  Intermediários Financeiros     8.74                  9.01   \n",
       "217   BRSR6  Intermediários Financeiros    11.00                 17.90   \n",
       "218   ITSA3  Intermediários Financeiros     8.82                  9.01   \n",
       "219   BRSR3  Intermediários Financeiros    11.65                 17.90   \n",
       "220   ITUB3  Intermediários Financeiros    23.13                 20.46   \n",
       "221   BGIP3  Intermediários Financeiros    27.06                 31.05   \n",
       "222   PINE3  Intermediários Financeiros     4.16                  4.62   \n",
       "223   BEES3  Intermediários Financeiros     8.56                  7.21   \n",
       "224   ITUB4  Intermediários Financeiros    26.96                 20.46   \n",
       "225   BBDC3  Intermediários Financeiros    12.45                 12.74   \n",
       "226   BMIN4  Intermediários Financeiros    15.99                 20.13   \n",
       "227   BEES4  Intermediários Financeiros     9.61                  7.21   \n",
       "228   BBDC4  Intermediários Financeiros    14.16                 12.74   \n",
       "229   BRIV3  Intermediários Financeiros    10.53                 12.72   \n",
       "230   BRIV4  Intermediários Financeiros    10.51                 12.72   \n",
       "231   BRSR5  Intermediários Financeiros    18.20                 17.90   \n",
       "232   BMGB4  Intermediários Financeiros     2.35                  3.36   \n",
       "233   SANB3  Intermediários Financeiros    12.35                  9.90   \n",
       "234   RPAD5  Intermediários Financeiros     7.80                  8.31   \n",
       "235   RPAD3  Intermediários Financeiros     7.76                  8.31   \n",
       "236   BPAC5  Intermediários Financeiros     7.79                  4.71   \n",
       "237  SANB11  Intermediários Financeiros    26.21                 19.79   \n",
       "238   RPAD6  Intermediários Financeiros     7.60                  8.31   \n",
       "239   BMIN3  Intermediários Financeiros    23.92                 20.13   \n",
       "240   SANB4  Intermediários Financeiros    13.84                  9.90   \n",
       "241  BPAC11  Intermediários Financeiros    29.23                 14.12   \n",
       "242   BPAN4  Intermediários Financeiros     7.61                  5.00   \n",
       "245   BPAC3  Intermediários Financeiros    13.26                  4.71   \n",
       "246   CRIV3  Intermediários Financeiros     5.70                  4.38   \n",
       "247   CRIV4  Intermediários Financeiros     5.65                  4.38   \n",
       "\n",
       "     RAZAO_COTACAO_GRAHAM  DIV_YIELD  AGG_DIV_YIELD  P_POR_L  \\\n",
       "206                   NaN        6.3           6.55   -35.86   \n",
       "207                   NaN        7.2           6.55     0.00   \n",
       "208                  1.60        6.7           6.55     3.60   \n",
       "209                  1.47        6.4           6.55     3.90   \n",
       "210                  1.39        9.3           6.55     4.27   \n",
       "211                  1.38        6.9           6.55     4.46   \n",
       "212                  1.31        6.2           6.55     5.42   \n",
       "213                  1.31        4.6           6.55     6.18   \n",
       "214                  1.39       15.3           6.55     6.13   \n",
       "215                  1.19        5.4           6.55     5.16   \n",
       "216                  1.03        7.9           6.55     6.39   \n",
       "217                  1.63        8.6           6.55     5.90   \n",
       "218                  1.02        7.8           6.55     6.45   \n",
       "219                  1.54        8.1           6.55     6.25   \n",
       "220                  0.88        6.5           6.55     7.18   \n",
       "221                  1.15       11.5           6.55     7.42   \n",
       "222                  1.11        0.0           6.55     7.28   \n",
       "223                  0.84        7.3           6.55     8.12   \n",
       "224                  0.76        5.5           6.55     8.37   \n",
       "225                  1.02        7.4           6.55     8.58   \n",
       "226                  1.26        9.9           6.55     8.23   \n",
       "227                  0.75        6.5           6.55     9.11   \n",
       "228                  0.90        7.1           6.55     9.76   \n",
       "229                  1.21        1.5           6.55     9.31   \n",
       "230                  1.21        6.1           6.55     9.29   \n",
       "231                  0.98        5.3           6.55     9.76   \n",
       "232                  1.43       16.4           6.55    10.17   \n",
       "233                  0.80        6.6           6.55    10.57   \n",
       "234                  1.07        7.4           6.55    10.85   \n",
       "235                  1.07        0.0           6.55    10.80   \n",
       "236                  0.60        3.2           6.55    10.66   \n",
       "237                  0.76        6.6           6.55    11.21   \n",
       "238                  1.09        0.0           6.55    10.57   \n",
       "239                  0.84        5.9           6.55    12.31   \n",
       "240                  0.72        6.5           6.55    11.84   \n",
       "241                  0.48        2.5           6.55    13.34   \n",
       "242                  0.66        3.4           6.55    14.18   \n",
       "245                  0.36        1.9           6.55    18.15   \n",
       "246                  0.77        0.0           6.55    22.45   \n",
       "247                  0.78        8.5           6.55    22.25   \n",
       "\n",
       "     OSCILACOES_%_2023    LPA     VPA  MARG_EBIT  MARG_LIQUIDA  \\\n",
       "206               1.10  -0.20   13.81        NaN           0.0   \n",
       "207               2.87   0.00    0.00        NaN           NaN   \n",
       "208              32.07  25.85  114.19        NaN           0.0   \n",
       "209              85.77  22.28   97.45        NaN           0.0   \n",
       "210              52.02  11.55   54.86        NaN           0.0   \n",
       "211              23.02   2.61   13.18        NaN           0.0   \n",
       "212               5.04   3.57   23.98        NaN           0.0   \n",
       "213             127.05   0.57    5.02        NaN           0.0   \n",
       "214              46.85   3.65   35.35        NaN           0.0   \n",
       "215              41.09   2.61   13.18        NaN           0.0   \n",
       "216               7.95   1.37    7.92       14.1         175.5   \n",
       "217              21.19   1.86   23.04        NaN           0.0   \n",
       "218               4.08   1.37    7.92       14.1         175.5   \n",
       "219              15.78   1.86   23.04        NaN           0.0   \n",
       "220               9.64   3.22   17.40        NaN           0.0   \n",
       "221              15.05   3.65   35.35        NaN           0.0   \n",
       "222             194.10   0.57    5.02        NaN           0.0   \n",
       "223              64.82   1.05    6.63        NaN           0.0   \n",
       "224              11.15   3.22   17.40        NaN           0.0   \n",
       "225              -2.23   1.45   14.97        NaN           0.0   \n",
       "226              32.27   1.94   27.96        NaN           0.0   \n",
       "227              55.84   1.05    6.63        NaN           0.0   \n",
       "228              -1.27   1.45   14.97        NaN           0.0   \n",
       "229              14.37   1.13   19.17        NaN           0.0   \n",
       "230              19.40   1.13   19.17        NaN           0.0   \n",
       "231               8.46   1.86   23.04        NaN           0.0   \n",
       "232               7.72   0.23    6.58        NaN           0.0   \n",
       "233              -2.18   1.17   11.20        NaN           0.0   \n",
       "234              21.98   0.72   12.83        NaN           0.0   \n",
       "235               8.68   0.72   12.83        NaN           0.0   \n",
       "236              42.14   0.73    4.06        NaN           0.0   \n",
       "237              -2.12   2.34   22.40        NaN           0.0   \n",
       "238              13.60   0.72   12.83        NaN           0.0   \n",
       "239              31.24   1.94   27.96        NaN           0.0   \n",
       "240              -2.55   1.17   11.20        NaN           0.0   \n",
       "241              24.08   2.19   12.18        NaN           0.0   \n",
       "242              25.37   0.54    6.20        NaN           0.0   \n",
       "245               3.72   0.73    4.06        NaN           0.0   \n",
       "246              10.04   0.25   10.29        NaN           0.0   \n",
       "247              18.51   0.25   10.29        NaN           0.0   \n",
       "\n",
       "     FLAG_MENOR_GRAHAM_SETOR  FLAG_DY_ACIMA_10  FLAG_DY_ACIMA_DY_SETOR  \\\n",
       "206                        0                 0                       0   \n",
       "207                        0                 0                       1   \n",
       "208                        1                 0                       1   \n",
       "209                        1                 0                       0   \n",
       "210                        1                 0                       1   \n",
       "211                        1                 0                       1   \n",
       "212                        1                 0                       0   \n",
       "213                        1                 0                       0   \n",
       "214                        1                 1                       1   \n",
       "215                        1                 0                       0   \n",
       "216                        1                 0                       1   \n",
       "217                        1                 0                       1   \n",
       "218                        1                 0                       1   \n",
       "219                        1                 0                       1   \n",
       "220                        0                 0                       0   \n",
       "221                        1                 1                       1   \n",
       "222                        1                 0                       0   \n",
       "223                        0                 0                       1   \n",
       "224                        0                 0                       0   \n",
       "225                        1                 0                       1   \n",
       "226                        1                 0                       1   \n",
       "227                        0                 0                       0   \n",
       "228                        0                 0                       1   \n",
       "229                        1                 0                       0   \n",
       "230                        1                 0                       0   \n",
       "231                        0                 0                       0   \n",
       "232                        1                 1                       1   \n",
       "233                        0                 0                       1   \n",
       "234                        1                 0                       1   \n",
       "235                        1                 0                       0   \n",
       "236                        0                 0                       0   \n",
       "237                        0                 0                       1   \n",
       "238                        1                 0                       0   \n",
       "239                        0                 0                       0   \n",
       "240                        0                 0                       0   \n",
       "241                        0                 0                       0   \n",
       "242                        0                 0                       0   \n",
       "245                        0                 0                       0   \n",
       "246                        0                 0                       0   \n",
       "247                        0                 0                       1   \n",
       "\n",
       "     FLAG_MENOR_GRAHAM_ACIMA_DY_SETOR  \n",
       "206                             False  \n",
       "207                              True  \n",
       "208                              True  \n",
       "209                             False  \n",
       "210                              True  \n",
       "211                              True  \n",
       "212                             False  \n",
       "213                             False  \n",
       "214                              True  \n",
       "215                             False  \n",
       "216                              True  \n",
       "217                              True  \n",
       "218                              True  \n",
       "219                              True  \n",
       "220                             False  \n",
       "221                              True  \n",
       "222                             False  \n",
       "223                              True  \n",
       "224                             False  \n",
       "225                              True  \n",
       "226                              True  \n",
       "227                             False  \n",
       "228                              True  \n",
       "229                             False  \n",
       "230                             False  \n",
       "231                             False  \n",
       "232                              True  \n",
       "233                              True  \n",
       "234                              True  \n",
       "235                             False  \n",
       "236                             False  \n",
       "237                              True  \n",
       "238                             False  \n",
       "239                             False  \n",
       "240                             False  \n",
       "241                             False  \n",
       "242                             False  \n",
       "245                             False  \n",
       "246                             False  \n",
       "247                              True  "
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_viz[cols]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "id": "92abcf0b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.plotly.v1+json": {
       "config": {
        "plotlyServerURL": "https://plot.ly"
       },
       "data": [
        {
         "customdata": [
          [
           2.95,
           "POMO3",
           4.34,
           4.13
          ],
          [
           2.95,
           "RAPT3",
           9.78,
           9.42
          ],
          [
           2.95,
           "RSUL4",
           46,
           75
          ],
          [
           2.95,
           "POMO4",
           4.34,
           5.3
          ],
          [
           2.95,
           "RAPT4",
           9.78,
           11.06
          ],
          [
           2.95,
           "TUPY3",
           22.39,
           24.91
          ]
         ],
         "hovertemplate": "FLAG_MENOR_GRAHAM_ACIMA_DY_SETOR=True<br>P_POR_VP=%{x}<br>DIV_YIELD=%{y}<br>AGG_DIV_YIELD=%{customdata[0]}<br>PAPEL=%{customdata[1]}<br>COTACAO_GRAHAM_SETOR=%{customdata[2]}<br>COTACAO=%{customdata[3]}<extra></extra>",
         "legendgroup": "True",
         "marker": {
          "color": "#636efa",
          "symbol": "circle"
         },
         "mode": "markers",
         "name": "True",
         "orientation": "v",
         "showlegend": true,
         "type": "scatter",
         "x": [
          1.2,
          1.06,
          2.82,
          1.54,
          1.24,
          1.16
         ],
         "xaxis": "x",
         "y": [
          9.1,
          5.4,
          3.8,
          7.1,
          4.6,
          3
         ],
         "yaxis": "y"
        },
        {
         "customdata": [
          [
           2.95,
           "FRAS3",
           7.53,
           14.56
          ]
         ],
         "hovertemplate": "FLAG_MENOR_GRAHAM_ACIMA_DY_SETOR=False<br>P_POR_VP=%{x}<br>DIV_YIELD=%{y}<br>AGG_DIV_YIELD=%{customdata[0]}<br>PAPEL=%{customdata[1]}<br>COTACAO_GRAHAM_SETOR=%{customdata[2]}<br>COTACAO=%{customdata[3]}<extra></extra>",
         "legendgroup": "False",
         "marker": {
          "color": "#EF553B",
          "symbol": "circle"
         },
         "mode": "markers",
         "name": "False",
         "orientation": "v",
         "showlegend": true,
         "type": "scatter",
         "x": [
          2.07
         ],
         "xaxis": "x",
         "y": [
          2.9
         ],
         "yaxis": "y"
        }
       ],
       "layout": {
        "legend": {
         "title": {
          "text": "FLAG_MENOR_GRAHAM_ACIMA_DY_SETOR"
         },
         "tracegroupgap": 0
        },
        "margin": {
         "t": 60
        },
        "template": {
         "data": {
          "bar": [
           {
            "error_x": {
             "color": "#2a3f5f"
            },
            "error_y": {
             "color": "#2a3f5f"
            },
            "marker": {
             "line": {
              "color": "#E5ECF6",
              "width": 0.5
             },
             "pattern": {
              "fillmode": "overlay",
              "size": 10,
              "solidity": 0.2
             }
            },
            "type": "bar"
           }
          ],
          "barpolar": [
           {
            "marker": {
             "line": {
              "color": "#E5ECF6",
              "width": 0.5
             },
             "pattern": {
              "fillmode": "overlay",
              "size": 10,
              "solidity": 0.2
             }
            },
            "type": "barpolar"
           }
          ],
          "carpet": [
           {
            "aaxis": {
             "endlinecolor": "#2a3f5f",
             "gridcolor": "white",
             "linecolor": "white",
             "minorgridcolor": "white",
             "startlinecolor": "#2a3f5f"
            },
            "baxis": {
             "endlinecolor": "#2a3f5f",
             "gridcolor": "white",
             "linecolor": "white",
             "minorgridcolor": "white",
             "startlinecolor": "#2a3f5f"
            },
            "type": "carpet"
           }
          ],
          "choropleth": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "type": "choropleth"
           }
          ],
          "contour": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "contour"
           }
          ],
          "contourcarpet": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "type": "contourcarpet"
           }
          ],
          "heatmap": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "heatmap"
           }
          ],
          "heatmapgl": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "heatmapgl"
           }
          ],
          "histogram": [
           {
            "marker": {
             "pattern": {
              "fillmode": "overlay",
              "size": 10,
              "solidity": 0.2
             }
            },
            "type": "histogram"
           }
          ],
          "histogram2d": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "histogram2d"
           }
          ],
          "histogram2dcontour": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "histogram2dcontour"
           }
          ],
          "mesh3d": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "type": "mesh3d"
           }
          ],
          "parcoords": [
           {
            "line": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "parcoords"
           }
          ],
          "pie": [
           {
            "automargin": true,
            "type": "pie"
           }
          ],
          "scatter": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scatter"
           }
          ],
          "scatter3d": [
           {
            "line": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scatter3d"
           }
          ],
          "scattercarpet": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scattercarpet"
           }
          ],
          "scattergeo": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scattergeo"
           }
          ],
          "scattergl": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scattergl"
           }
          ],
          "scattermapbox": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scattermapbox"
           }
          ],
          "scatterpolar": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scatterpolar"
           }
          ],
          "scatterpolargl": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scatterpolargl"
           }
          ],
          "scatterternary": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scatterternary"
           }
          ],
          "surface": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "surface"
           }
          ],
          "table": [
           {
            "cells": {
             "fill": {
              "color": "#EBF0F8"
             },
             "line": {
              "color": "white"
             }
            },
            "header": {
             "fill": {
              "color": "#C8D4E3"
             },
             "line": {
              "color": "white"
             }
            },
            "type": "table"
           }
          ]
         },
         "layout": {
          "annotationdefaults": {
           "arrowcolor": "#2a3f5f",
           "arrowhead": 0,
           "arrowwidth": 1
          },
          "autotypenumbers": "strict",
          "coloraxis": {
           "colorbar": {
            "outlinewidth": 0,
            "ticks": ""
           }
          },
          "colorscale": {
           "diverging": [
            [
             0,
             "#8e0152"
            ],
            [
             0.1,
             "#c51b7d"
            ],
            [
             0.2,
             "#de77ae"
            ],
            [
             0.3,
             "#f1b6da"
            ],
            [
             0.4,
             "#fde0ef"
            ],
            [
             0.5,
             "#f7f7f7"
            ],
            [
             0.6,
             "#e6f5d0"
            ],
            [
             0.7,
             "#b8e186"
            ],
            [
             0.8,
             "#7fbc41"
            ],
            [
             0.9,
             "#4d9221"
            ],
            [
             1,
             "#276419"
            ]
           ],
           "sequential": [
            [
             0,
             "#0d0887"
            ],
            [
             0.1111111111111111,
             "#46039f"
            ],
            [
             0.2222222222222222,
             "#7201a8"
            ],
            [
             0.3333333333333333,
             "#9c179e"
            ],
            [
             0.4444444444444444,
             "#bd3786"
            ],
            [
             0.5555555555555556,
             "#d8576b"
            ],
            [
             0.6666666666666666,
             "#ed7953"
            ],
            [
             0.7777777777777778,
             "#fb9f3a"
            ],
            [
             0.8888888888888888,
             "#fdca26"
            ],
            [
             1,
             "#f0f921"
            ]
           ],
           "sequentialminus": [
            [
             0,
             "#0d0887"
            ],
            [
             0.1111111111111111,
             "#46039f"
            ],
            [
             0.2222222222222222,
             "#7201a8"
            ],
            [
             0.3333333333333333,
             "#9c179e"
            ],
            [
             0.4444444444444444,
             "#bd3786"
            ],
            [
             0.5555555555555556,
             "#d8576b"
            ],
            [
             0.6666666666666666,
             "#ed7953"
            ],
            [
             0.7777777777777778,
             "#fb9f3a"
            ],
            [
             0.8888888888888888,
             "#fdca26"
            ],
            [
             1,
             "#f0f921"
            ]
           ]
          },
          "colorway": [
           "#636efa",
           "#EF553B",
           "#00cc96",
           "#ab63fa",
           "#FFA15A",
           "#19d3f3",
           "#FF6692",
           "#B6E880",
           "#FF97FF",
           "#FECB52"
          ],
          "font": {
           "color": "#2a3f5f"
          },
          "geo": {
           "bgcolor": "white",
           "lakecolor": "white",
           "landcolor": "#E5ECF6",
           "showlakes": true,
           "showland": true,
           "subunitcolor": "white"
          },
          "hoverlabel": {
           "align": "left"
          },
          "hovermode": "closest",
          "mapbox": {
           "style": "light"
          },
          "paper_bgcolor": "white",
          "plot_bgcolor": "#E5ECF6",
          "polar": {
           "angularaxis": {
            "gridcolor": "white",
            "linecolor": "white",
            "ticks": ""
           },
           "bgcolor": "#E5ECF6",
           "radialaxis": {
            "gridcolor": "white",
            "linecolor": "white",
            "ticks": ""
           }
          },
          "scene": {
           "xaxis": {
            "backgroundcolor": "#E5ECF6",
            "gridcolor": "white",
            "gridwidth": 2,
            "linecolor": "white",
            "showbackground": true,
            "ticks": "",
            "zerolinecolor": "white"
           },
           "yaxis": {
            "backgroundcolor": "#E5ECF6",
            "gridcolor": "white",
            "gridwidth": 2,
            "linecolor": "white",
            "showbackground": true,
            "ticks": "",
            "zerolinecolor": "white"
           },
           "zaxis": {
            "backgroundcolor": "#E5ECF6",
            "gridcolor": "white",
            "gridwidth": 2,
            "linecolor": "white",
            "showbackground": true,
            "ticks": "",
            "zerolinecolor": "white"
           }
          },
          "shapedefaults": {
           "line": {
            "color": "#2a3f5f"
           }
          },
          "ternary": {
           "aaxis": {
            "gridcolor": "white",
            "linecolor": "white",
            "ticks": ""
           },
           "baxis": {
            "gridcolor": "white",
            "linecolor": "white",
            "ticks": ""
           },
           "bgcolor": "#E5ECF6",
           "caxis": {
            "gridcolor": "white",
            "linecolor": "white",
            "ticks": ""
           }
          },
          "title": {
           "x": 0.05
          },
          "xaxis": {
           "automargin": true,
           "gridcolor": "white",
           "linecolor": "white",
           "ticks": "",
           "title": {
            "standoff": 15
           },
           "zerolinecolor": "white",
           "zerolinewidth": 2
          },
          "yaxis": {
           "automargin": true,
           "gridcolor": "white",
           "linecolor": "white",
           "ticks": "",
           "title": {
            "standoff": 15
           },
           "zerolinecolor": "white",
           "zerolinewidth": 2
          }
         }
        },
        "xaxis": {
         "anchor": "y",
         "domain": [
          0,
          1
         ],
         "title": {
          "text": "P_POR_VP"
         }
        },
        "yaxis": {
         "anchor": "x",
         "domain": [
          0,
          1
         ],
         "title": {
          "text": "DIV_YIELD"
         }
        }
       }
      },
      "text/html": [
       "<div>                            <div id=\"73a25f67-60f2-46ba-bbd4-55e5a114e9ad\" class=\"plotly-graph-div\" style=\"height:525px; width:100%;\"></div>            <script type=\"text/javascript\">                require([\"plotly\"], function(Plotly) {                    window.PLOTLYENV=window.PLOTLYENV || {};                                    if (document.getElementById(\"73a25f67-60f2-46ba-bbd4-55e5a114e9ad\")) {                    Plotly.newPlot(                        \"73a25f67-60f2-46ba-bbd4-55e5a114e9ad\",                        [{\"customdata\":[[2.95,\"POMO3\",4.34,4.13],[2.95,\"RAPT3\",9.78,9.42],[2.95,\"RSUL4\",46.0,75.0],[2.95,\"POMO4\",4.34,5.3],[2.95,\"RAPT4\",9.78,11.06],[2.95,\"TUPY3\",22.39,24.91]],\"hovertemplate\":\"FLAG_MENOR_GRAHAM_ACIMA_DY_SETOR=True<br>P_POR_VP=%{x}<br>DIV_YIELD=%{y}<br>AGG_DIV_YIELD=%{customdata[0]}<br>PAPEL=%{customdata[1]}<br>COTACAO_GRAHAM_SETOR=%{customdata[2]}<br>COTACAO=%{customdata[3]}<extra></extra>\",\"legendgroup\":\"True\",\"marker\":{\"color\":\"#636efa\",\"symbol\":\"circle\"},\"mode\":\"markers\",\"name\":\"True\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[1.2,1.06,2.82,1.54,1.24,1.16],\"xaxis\":\"x\",\"y\":[9.1,5.4,3.8,7.1,4.6,3.0],\"yaxis\":\"y\",\"type\":\"scatter\"},{\"customdata\":[[2.95,\"FRAS3\",7.53,14.56]],\"hovertemplate\":\"FLAG_MENOR_GRAHAM_ACIMA_DY_SETOR=False<br>P_POR_VP=%{x}<br>DIV_YIELD=%{y}<br>AGG_DIV_YIELD=%{customdata[0]}<br>PAPEL=%{customdata[1]}<br>COTACAO_GRAHAM_SETOR=%{customdata[2]}<br>COTACAO=%{customdata[3]}<extra></extra>\",\"legendgroup\":\"False\",\"marker\":{\"color\":\"#EF553B\",\"symbol\":\"circle\"},\"mode\":\"markers\",\"name\":\"False\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[2.07],\"xaxis\":\"x\",\"y\":[2.9],\"yaxis\":\"y\",\"type\":\"scatter\"}],                        {\"template\":{\"data\":{\"bar\":[{\"error_x\":{\"color\":\"#2a3f5f\"},\"error_y\":{\"color\":\"#2a3f5f\"},\"marker\":{\"line\":{\"color\":\"#E5ECF6\",\"width\":0.5},\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"bar\"}],\"barpolar\":[{\"marker\":{\"line\":{\"color\":\"#E5ECF6\",\"width\":0.5},\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"barpolar\"}],\"carpet\":[{\"aaxis\":{\"endlinecolor\":\"#2a3f5f\",\"gridcolor\":\"white\",\"linecolor\":\"white\",\"minorgridcolor\":\"white\",\"startlinecolor\":\"#2a3f5f\"},\"baxis\":{\"endlinecolor\":\"#2a3f5f\",\"gridcolor\":\"white\",\"linecolor\":\"white\",\"minorgridcolor\":\"white\",\"startlinecolor\":\"#2a3f5f\"},\"type\":\"carpet\"}],\"choropleth\":[{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"type\":\"choropleth\"}],\"contour\":[{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]],\"type\":\"contour\"}],\"contourcarpet\":[{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"type\":\"contourcarpet\"}],\"heatmap\":[{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]],\"type\":\"heatmap\"}],\"heatmapgl\":[{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]],\"type\":\"heatmapgl\"}],\"histogram\":[{\"marker\":{\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"histogram\"}],\"histogram2d\":[{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]],\"type\":\"histogram2d\"}],\"histogram2dcontour\":[{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]],\"type\":\"histogram2dcontour\"}],\"mesh3d\":[{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"type\":\"mesh3d\"}],\"parcoords\":[{\"line\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"type\":\"parcoords\"}],\"pie\":[{\"automargin\":true,\"type\":\"pie\"}],\"scatter\":[{\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"type\":\"scatter\"}],\"scatter3d\":[{\"line\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"type\":\"scatter3d\"}],\"scattercarpet\":[{\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"type\":\"scattercarpet\"}],\"scattergeo\":[{\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"type\":\"scattergeo\"}],\"scattergl\":[{\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"type\":\"scattergl\"}],\"scattermapbox\":[{\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"type\":\"scattermapbox\"}],\"scatterpolar\":[{\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"type\":\"scatterpolar\"}],\"scatterpolargl\":[{\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"type\":\"scatterpolargl\"}],\"scatterternary\":[{\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"type\":\"scatterternary\"}],\"surface\":[{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]],\"type\":\"surface\"}],\"table\":[{\"cells\":{\"fill\":{\"color\":\"#EBF0F8\"},\"line\":{\"color\":\"white\"}},\"header\":{\"fill\":{\"color\":\"#C8D4E3\"},\"line\":{\"color\":\"white\"}},\"type\":\"table\"}]},\"layout\":{\"annotationdefaults\":{\"arrowcolor\":\"#2a3f5f\",\"arrowhead\":0,\"arrowwidth\":1},\"autotypenumbers\":\"strict\",\"coloraxis\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"colorscale\":{\"diverging\":[[0,\"#8e0152\"],[0.1,\"#c51b7d\"],[0.2,\"#de77ae\"],[0.3,\"#f1b6da\"],[0.4,\"#fde0ef\"],[0.5,\"#f7f7f7\"],[0.6,\"#e6f5d0\"],[0.7,\"#b8e186\"],[0.8,\"#7fbc41\"],[0.9,\"#4d9221\"],[1,\"#276419\"]],\"sequential\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]],\"sequentialminus\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]},\"colorway\":[\"#636efa\",\"#EF553B\",\"#00cc96\",\"#ab63fa\",\"#FFA15A\",\"#19d3f3\",\"#FF6692\",\"#B6E880\",\"#FF97FF\",\"#FECB52\"],\"font\":{\"color\":\"#2a3f5f\"},\"geo\":{\"bgcolor\":\"white\",\"lakecolor\":\"white\",\"landcolor\":\"#E5ECF6\",\"showlakes\":true,\"showland\":true,\"subunitcolor\":\"white\"},\"hoverlabel\":{\"align\":\"left\"},\"hovermode\":\"closest\",\"mapbox\":{\"style\":\"light\"},\"paper_bgcolor\":\"white\",\"plot_bgcolor\":\"#E5ECF6\",\"polar\":{\"angularaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"},\"bgcolor\":\"#E5ECF6\",\"radialaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"}},\"scene\":{\"xaxis\":{\"backgroundcolor\":\"#E5ECF6\",\"gridcolor\":\"white\",\"gridwidth\":2,\"linecolor\":\"white\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"white\"},\"yaxis\":{\"backgroundcolor\":\"#E5ECF6\",\"gridcolor\":\"white\",\"gridwidth\":2,\"linecolor\":\"white\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"white\"},\"zaxis\":{\"backgroundcolor\":\"#E5ECF6\",\"gridcolor\":\"white\",\"gridwidth\":2,\"linecolor\":\"white\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"white\"}},\"shapedefaults\":{\"line\":{\"color\":\"#2a3f5f\"}},\"ternary\":{\"aaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"},\"baxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"},\"bgcolor\":\"#E5ECF6\",\"caxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"}},\"title\":{\"x\":0.05},\"xaxis\":{\"automargin\":true,\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\",\"title\":{\"standoff\":15},\"zerolinecolor\":\"white\",\"zerolinewidth\":2},\"yaxis\":{\"automargin\":true,\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\",\"title\":{\"standoff\":15},\"zerolinecolor\":\"white\",\"zerolinewidth\":2}}},\"xaxis\":{\"anchor\":\"y\",\"domain\":[0.0,1.0],\"title\":{\"text\":\"P_POR_VP\"}},\"yaxis\":{\"anchor\":\"x\",\"domain\":[0.0,1.0],\"title\":{\"text\":\"DIV_YIELD\"}},\"legend\":{\"title\":{\"text\":\"FLAG_MENOR_GRAHAM_ACIMA_DY_SETOR\"},\"tracegroupgap\":0},\"margin\":{\"t\":60}},                        {\"responsive\": true}                    ).then(function(){\n",
       "                            \n",
       "var gd = document.getElementById('73a25f67-60f2-46ba-bbd4-55e5a114e9ad');\n",
       "var x = new MutationObserver(function (mutations, observer) {{\n",
       "        var display = window.getComputedStyle(gd).display;\n",
       "        if (!display || display === 'none') {{\n",
       "            console.log([gd, 'removed!']);\n",
       "            Plotly.purge(gd);\n",
       "            observer.disconnect();\n",
       "        }}\n",
       "}});\n",
       "\n",
       "// Listen for the removal of the full notebook cells\n",
       "var notebookContainer = gd.closest('#notebook-container');\n",
       "if (notebookContainer) {{\n",
       "    x.observe(notebookContainer, {childList: true});\n",
       "}}\n",
       "\n",
       "// Listen for the clearing of the current output cell\n",
       "var outputEl = gd.closest('.output');\n",
       "if (outputEl) {{\n",
       "    x.observe(outputEl, {childList: true});\n",
       "}}\n",
       "\n",
       "                        })                };                });            </script>        </div>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Gráfico Setorial 1 - P_POR_L (Anos de retorno de investimento via lucro) x DIV_YIELD (%)\n",
    "# Definir dataframe para visualizar\n",
    "cond = (df_aval['SETOR'] == setores_atuais[2]) & (df_aval['DIV_YIELD'] < 1000) & (df_aval['COTACAO_GRAHAM_SETOR'].notnull())\n",
    "df_viz = df_aval[cond].copy()\n",
    "\n",
    "fig = px.scatter(data_frame=df_viz, x='P_POR_VP', y='DIV_YIELD',\n",
    "                 hover_data=['AGG_DIV_YIELD','PAPEL','COTACAO_GRAHAM_SETOR','COTACAO'], color='FLAG_MENOR_GRAHAM_ACIMA_DY_SETOR')\n",
    "fig.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "04070e50",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Gráfico Setorial 1 - P_POR_L (Anos de retorno de investimento via lucro) x DIV_YIELD (%)\n",
    "# Definir dataframe para visualizar\n",
    "cond = (df_aval['SETOR'] == setores_atuais[1]) & (df_aval['DIV_YIELD'] < 1000) & (df_aval['COTACAO_GRAHAM_SETOR'].notnull())\n",
    "df_viz = df_aval[cond].copy()\n",
    "\n",
    "fig = px.scatter(data_frame=df_viz, x='P_POR_L', y='DIV_YIELD',\n",
    "                 hover_data=['AGG_DIV_YIELD','PAPEL','COTACAO_GRAHAM_SETOR','COTACAO'], color='FLAG_MENOR_GRAHAM_ACIMA_DY_SETOR')\n",
    "fig.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "25a85ebf",
   "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>PAPEL</th>\n",
       "      <th>SETOR</th>\n",
       "      <th>COTACAO</th>\n",
       "      <th>COTACAO_GRAHAM_SETOR</th>\n",
       "      <th>RAZAO_COTACAO_GRAHAM</th>\n",
       "      <th>DIV_YIELD</th>\n",
       "      <th>AGG_DIV_YIELD</th>\n",
       "      <th>P_POR_L</th>\n",
       "      <th>OSCILACOES_%_2023</th>\n",
       "      <th>LPA</th>\n",
       "      <th>VPA</th>\n",
       "      <th>MARG_EBIT</th>\n",
       "      <th>MARG_LIQUIDA</th>\n",
       "      <th>FLAG_MENOR_GRAHAM_SETOR</th>\n",
       "      <th>FLAG_DY_ACIMA_10</th>\n",
       "      <th>FLAG_DY_ACIMA_DY_SETOR</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>PINE3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>4.16</td>\n",
       "      <td>4.62</td>\n",
       "      <td>1.11</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.55</td>\n",
       "      <td>7.28</td>\n",
       "      <td>194.10</td>\n",
       "      <td>0.57</td>\n",
       "      <td>5.02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>RPAD3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>7.76</td>\n",
       "      <td>8.31</td>\n",
       "      <td>1.07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.55</td>\n",
       "      <td>10.80</td>\n",
       "      <td>8.68</td>\n",
       "      <td>0.72</td>\n",
       "      <td>12.83</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>CRIV3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>5.70</td>\n",
       "      <td>4.38</td>\n",
       "      <td>0.77</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.55</td>\n",
       "      <td>22.45</td>\n",
       "      <td>10.04</td>\n",
       "      <td>0.25</td>\n",
       "      <td>10.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>RPAD6</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>7.60</td>\n",
       "      <td>8.31</td>\n",
       "      <td>1.09</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.55</td>\n",
       "      <td>10.57</td>\n",
       "      <td>13.60</td>\n",
       "      <td>0.72</td>\n",
       "      <td>12.83</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>BRIV3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>10.53</td>\n",
       "      <td>12.72</td>\n",
       "      <td>1.21</td>\n",
       "      <td>1.5</td>\n",
       "      <td>6.55</td>\n",
       "      <td>9.31</td>\n",
       "      <td>14.37</td>\n",
       "      <td>1.13</td>\n",
       "      <td>19.17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>BPAC3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>13.26</td>\n",
       "      <td>4.71</td>\n",
       "      <td>0.36</td>\n",
       "      <td>1.9</td>\n",
       "      <td>6.55</td>\n",
       "      <td>18.15</td>\n",
       "      <td>3.72</td>\n",
       "      <td>0.73</td>\n",
       "      <td>4.06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>BPAC11</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>29.23</td>\n",
       "      <td>14.12</td>\n",
       "      <td>0.48</td>\n",
       "      <td>2.5</td>\n",
       "      <td>6.55</td>\n",
       "      <td>13.34</td>\n",
       "      <td>24.08</td>\n",
       "      <td>2.19</td>\n",
       "      <td>12.18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>BPAC5</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>7.79</td>\n",
       "      <td>4.71</td>\n",
       "      <td>0.60</td>\n",
       "      <td>3.2</td>\n",
       "      <td>6.55</td>\n",
       "      <td>10.66</td>\n",
       "      <td>42.14</td>\n",
       "      <td>0.73</td>\n",
       "      <td>4.06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>BPAN4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>7.61</td>\n",
       "      <td>5.00</td>\n",
       "      <td>0.66</td>\n",
       "      <td>3.4</td>\n",
       "      <td>6.55</td>\n",
       "      <td>14.18</td>\n",
       "      <td>25.37</td>\n",
       "      <td>0.54</td>\n",
       "      <td>6.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>PINE4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>3.53</td>\n",
       "      <td>4.62</td>\n",
       "      <td>1.31</td>\n",
       "      <td>4.6</td>\n",
       "      <td>6.55</td>\n",
       "      <td>6.18</td>\n",
       "      <td>127.05</td>\n",
       "      <td>0.57</td>\n",
       "      <td>5.02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>BRSR5</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>18.20</td>\n",
       "      <td>17.90</td>\n",
       "      <td>0.98</td>\n",
       "      <td>5.3</td>\n",
       "      <td>6.55</td>\n",
       "      <td>9.76</td>\n",
       "      <td>8.46</td>\n",
       "      <td>1.86</td>\n",
       "      <td>23.04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>BMEB3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>13.47</td>\n",
       "      <td>16.03</td>\n",
       "      <td>1.19</td>\n",
       "      <td>5.4</td>\n",
       "      <td>6.55</td>\n",
       "      <td>5.16</td>\n",
       "      <td>41.09</td>\n",
       "      <td>2.61</td>\n",
       "      <td>13.18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>ITUB4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>26.96</td>\n",
       "      <td>20.46</td>\n",
       "      <td>0.76</td>\n",
       "      <td>5.5</td>\n",
       "      <td>6.55</td>\n",
       "      <td>8.37</td>\n",
       "      <td>11.15</td>\n",
       "      <td>3.22</td>\n",
       "      <td>17.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>BMIN3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>23.92</td>\n",
       "      <td>20.13</td>\n",
       "      <td>0.84</td>\n",
       "      <td>5.9</td>\n",
       "      <td>6.55</td>\n",
       "      <td>12.31</td>\n",
       "      <td>31.24</td>\n",
       "      <td>1.94</td>\n",
       "      <td>27.96</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>BRIV4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>10.51</td>\n",
       "      <td>12.72</td>\n",
       "      <td>1.21</td>\n",
       "      <td>6.1</td>\n",
       "      <td>6.55</td>\n",
       "      <td>9.29</td>\n",
       "      <td>19.40</td>\n",
       "      <td>1.13</td>\n",
       "      <td>19.17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>ABCB4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>19.35</td>\n",
       "      <td>25.30</td>\n",
       "      <td>1.31</td>\n",
       "      <td>6.2</td>\n",
       "      <td>6.55</td>\n",
       "      <td>5.42</td>\n",
       "      <td>5.04</td>\n",
       "      <td>3.57</td>\n",
       "      <td>23.98</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>MERC4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>7.16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.3</td>\n",
       "      <td>6.55</td>\n",
       "      <td>-35.86</td>\n",
       "      <td>1.10</td>\n",
       "      <td>-0.20</td>\n",
       "      <td>13.81</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>BAZA3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>86.89</td>\n",
       "      <td>127.39</td>\n",
       "      <td>1.47</td>\n",
       "      <td>6.4</td>\n",
       "      <td>6.55</td>\n",
       "      <td>3.90</td>\n",
       "      <td>85.77</td>\n",
       "      <td>22.28</td>\n",
       "      <td>97.45</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>ITUB3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>23.13</td>\n",
       "      <td>20.46</td>\n",
       "      <td>0.88</td>\n",
       "      <td>6.5</td>\n",
       "      <td>6.55</td>\n",
       "      <td>7.18</td>\n",
       "      <td>9.64</td>\n",
       "      <td>3.22</td>\n",
       "      <td>17.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>SANB4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>13.84</td>\n",
       "      <td>9.90</td>\n",
       "      <td>0.72</td>\n",
       "      <td>6.5</td>\n",
       "      <td>6.55</td>\n",
       "      <td>11.84</td>\n",
       "      <td>-2.55</td>\n",
       "      <td>1.17</td>\n",
       "      <td>11.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>BEES4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>9.61</td>\n",
       "      <td>7.21</td>\n",
       "      <td>0.75</td>\n",
       "      <td>6.5</td>\n",
       "      <td>6.55</td>\n",
       "      <td>9.11</td>\n",
       "      <td>55.84</td>\n",
       "      <td>1.05</td>\n",
       "      <td>6.63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>SANB11</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>26.21</td>\n",
       "      <td>19.79</td>\n",
       "      <td>0.76</td>\n",
       "      <td>6.6</td>\n",
       "      <td>6.55</td>\n",
       "      <td>11.21</td>\n",
       "      <td>-2.12</td>\n",
       "      <td>2.34</td>\n",
       "      <td>22.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>SANB3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>12.35</td>\n",
       "      <td>9.90</td>\n",
       "      <td>0.80</td>\n",
       "      <td>6.6</td>\n",
       "      <td>6.55</td>\n",
       "      <td>10.57</td>\n",
       "      <td>-2.18</td>\n",
       "      <td>1.17</td>\n",
       "      <td>11.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>BNBR3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>93.06</td>\n",
       "      <td>148.53</td>\n",
       "      <td>1.60</td>\n",
       "      <td>6.7</td>\n",
       "      <td>6.55</td>\n",
       "      <td>3.60</td>\n",
       "      <td>32.07</td>\n",
       "      <td>25.85</td>\n",
       "      <td>114.19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>BMEB4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>11.64</td>\n",
       "      <td>16.03</td>\n",
       "      <td>1.38</td>\n",
       "      <td>6.9</td>\n",
       "      <td>6.55</td>\n",
       "      <td>4.46</td>\n",
       "      <td>23.02</td>\n",
       "      <td>2.61</td>\n",
       "      <td>13.18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>BBDC4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>14.16</td>\n",
       "      <td>12.74</td>\n",
       "      <td>0.90</td>\n",
       "      <td>7.1</td>\n",
       "      <td>6.55</td>\n",
       "      <td>9.76</td>\n",
       "      <td>-1.27</td>\n",
       "      <td>1.45</td>\n",
       "      <td>14.97</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>BRBI11</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>11.65</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.2</td>\n",
       "      <td>6.55</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2.87</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>BEES3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>8.56</td>\n",
       "      <td>7.21</td>\n",
       "      <td>0.84</td>\n",
       "      <td>7.3</td>\n",
       "      <td>6.55</td>\n",
       "      <td>8.12</td>\n",
       "      <td>64.82</td>\n",
       "      <td>1.05</td>\n",
       "      <td>6.63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>BBDC3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>12.45</td>\n",
       "      <td>12.74</td>\n",
       "      <td>1.02</td>\n",
       "      <td>7.4</td>\n",
       "      <td>6.55</td>\n",
       "      <td>8.58</td>\n",
       "      <td>-2.23</td>\n",
       "      <td>1.45</td>\n",
       "      <td>14.97</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>RPAD5</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>7.80</td>\n",
       "      <td>8.31</td>\n",
       "      <td>1.07</td>\n",
       "      <td>7.4</td>\n",
       "      <td>6.55</td>\n",
       "      <td>10.85</td>\n",
       "      <td>21.98</td>\n",
       "      <td>0.72</td>\n",
       "      <td>12.83</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>ITSA3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>8.82</td>\n",
       "      <td>9.01</td>\n",
       "      <td>1.02</td>\n",
       "      <td>7.8</td>\n",
       "      <td>6.55</td>\n",
       "      <td>6.45</td>\n",
       "      <td>4.08</td>\n",
       "      <td>1.37</td>\n",
       "      <td>7.92</td>\n",
       "      <td>14.1</td>\n",
       "      <td>175.5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>ITSA4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>8.74</td>\n",
       "      <td>9.01</td>\n",
       "      <td>1.03</td>\n",
       "      <td>7.9</td>\n",
       "      <td>6.55</td>\n",
       "      <td>6.39</td>\n",
       "      <td>7.95</td>\n",
       "      <td>1.37</td>\n",
       "      <td>7.92</td>\n",
       "      <td>14.1</td>\n",
       "      <td>175.5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>BRSR3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>11.65</td>\n",
       "      <td>17.90</td>\n",
       "      <td>1.54</td>\n",
       "      <td>8.1</td>\n",
       "      <td>6.55</td>\n",
       "      <td>6.25</td>\n",
       "      <td>15.78</td>\n",
       "      <td>1.86</td>\n",
       "      <td>23.04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>CRIV4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>5.65</td>\n",
       "      <td>4.38</td>\n",
       "      <td>0.78</td>\n",
       "      <td>8.5</td>\n",
       "      <td>6.55</td>\n",
       "      <td>22.25</td>\n",
       "      <td>18.51</td>\n",
       "      <td>0.25</td>\n",
       "      <td>10.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>BRSR6</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>11.00</td>\n",
       "      <td>17.90</td>\n",
       "      <td>1.63</td>\n",
       "      <td>8.6</td>\n",
       "      <td>6.55</td>\n",
       "      <td>5.90</td>\n",
       "      <td>21.19</td>\n",
       "      <td>1.86</td>\n",
       "      <td>23.04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>BBAS3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>49.34</td>\n",
       "      <td>68.82</td>\n",
       "      <td>1.39</td>\n",
       "      <td>9.3</td>\n",
       "      <td>6.55</td>\n",
       "      <td>4.27</td>\n",
       "      <td>52.02</td>\n",
       "      <td>11.55</td>\n",
       "      <td>54.86</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>BMIN4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>15.99</td>\n",
       "      <td>20.13</td>\n",
       "      <td>1.26</td>\n",
       "      <td>9.9</td>\n",
       "      <td>6.55</td>\n",
       "      <td>8.23</td>\n",
       "      <td>32.27</td>\n",
       "      <td>1.94</td>\n",
       "      <td>27.96</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>BGIP3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>27.06</td>\n",
       "      <td>31.05</td>\n",
       "      <td>1.15</td>\n",
       "      <td>11.5</td>\n",
       "      <td>6.55</td>\n",
       "      <td>7.42</td>\n",
       "      <td>15.05</td>\n",
       "      <td>3.65</td>\n",
       "      <td>35.35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>BGIP4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>22.36</td>\n",
       "      <td>31.05</td>\n",
       "      <td>1.39</td>\n",
       "      <td>15.3</td>\n",
       "      <td>6.55</td>\n",
       "      <td>6.13</td>\n",
       "      <td>46.85</td>\n",
       "      <td>3.65</td>\n",
       "      <td>35.35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>BMGB4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>2.35</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.43</td>\n",
       "      <td>16.4</td>\n",
       "      <td>6.55</td>\n",
       "      <td>10.17</td>\n",
       "      <td>7.72</td>\n",
       "      <td>0.23</td>\n",
       "      <td>6.58</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>BSLI3</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>12.61</td>\n",
       "      <td>6.06</td>\n",
       "      <td>0.48</td>\n",
       "      <td>1110.5</td>\n",
       "      <td>6.55</td>\n",
       "      <td>16.99</td>\n",
       "      <td>-29.38</td>\n",
       "      <td>0.74</td>\n",
       "      <td>6.63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>BSLI4</td>\n",
       "      <td>Intermediários Financeiros</td>\n",
       "      <td>11.94</td>\n",
       "      <td>6.06</td>\n",
       "      <td>0.51</td>\n",
       "      <td>1290.1</td>\n",
       "      <td>6.55</td>\n",
       "      <td>16.09</td>\n",
       "      <td>-16.10</td>\n",
       "      <td>0.74</td>\n",
       "      <td>6.63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      PAPEL                       SETOR  COTACAO  COTACAO_GRAHAM_SETOR  \\\n",
       "222   PINE3  Intermediários Financeiros     4.16                  4.62   \n",
       "235   RPAD3  Intermediários Financeiros     7.76                  8.31   \n",
       "246   CRIV3  Intermediários Financeiros     5.70                  4.38   \n",
       "238   RPAD6  Intermediários Financeiros     7.60                  8.31   \n",
       "229   BRIV3  Intermediários Financeiros    10.53                 12.72   \n",
       "245   BPAC3  Intermediários Financeiros    13.26                  4.71   \n",
       "241  BPAC11  Intermediários Financeiros    29.23                 14.12   \n",
       "236   BPAC5  Intermediários Financeiros     7.79                  4.71   \n",
       "242   BPAN4  Intermediários Financeiros     7.61                  5.00   \n",
       "213   PINE4  Intermediários Financeiros     3.53                  4.62   \n",
       "231   BRSR5  Intermediários Financeiros    18.20                 17.90   \n",
       "215   BMEB3  Intermediários Financeiros    13.47                 16.03   \n",
       "224   ITUB4  Intermediários Financeiros    26.96                 20.46   \n",
       "239   BMIN3  Intermediários Financeiros    23.92                 20.13   \n",
       "230   BRIV4  Intermediários Financeiros    10.51                 12.72   \n",
       "212   ABCB4  Intermediários Financeiros    19.35                 25.30   \n",
       "206   MERC4  Intermediários Financeiros     7.16                   NaN   \n",
       "209   BAZA3  Intermediários Financeiros    86.89                127.39   \n",
       "220   ITUB3  Intermediários Financeiros    23.13                 20.46   \n",
       "240   SANB4  Intermediários Financeiros    13.84                  9.90   \n",
       "227   BEES4  Intermediários Financeiros     9.61                  7.21   \n",
       "237  SANB11  Intermediários Financeiros    26.21                 19.79   \n",
       "233   SANB3  Intermediários Financeiros    12.35                  9.90   \n",
       "208   BNBR3  Intermediários Financeiros    93.06                148.53   \n",
       "211   BMEB4  Intermediários Financeiros    11.64                 16.03   \n",
       "228   BBDC4  Intermediários Financeiros    14.16                 12.74   \n",
       "207  BRBI11  Intermediários Financeiros    11.65                   NaN   \n",
       "223   BEES3  Intermediários Financeiros     8.56                  7.21   \n",
       "225   BBDC3  Intermediários Financeiros    12.45                 12.74   \n",
       "234   RPAD5  Intermediários Financeiros     7.80                  8.31   \n",
       "218   ITSA3  Intermediários Financeiros     8.82                  9.01   \n",
       "216   ITSA4  Intermediários Financeiros     8.74                  9.01   \n",
       "219   BRSR3  Intermediários Financeiros    11.65                 17.90   \n",
       "247   CRIV4  Intermediários Financeiros     5.65                  4.38   \n",
       "217   BRSR6  Intermediários Financeiros    11.00                 17.90   \n",
       "210   BBAS3  Intermediários Financeiros    49.34                 68.82   \n",
       "226   BMIN4  Intermediários Financeiros    15.99                 20.13   \n",
       "221   BGIP3  Intermediários Financeiros    27.06                 31.05   \n",
       "214   BGIP4  Intermediários Financeiros    22.36                 31.05   \n",
       "232   BMGB4  Intermediários Financeiros     2.35                  3.36   \n",
       "244   BSLI3  Intermediários Financeiros    12.61                  6.06   \n",
       "243   BSLI4  Intermediários Financeiros    11.94                  6.06   \n",
       "\n",
       "     RAZAO_COTACAO_GRAHAM  DIV_YIELD  AGG_DIV_YIELD  P_POR_L  \\\n",
       "222                  1.11        0.0           6.55     7.28   \n",
       "235                  1.07        0.0           6.55    10.80   \n",
       "246                  0.77        0.0           6.55    22.45   \n",
       "238                  1.09        0.0           6.55    10.57   \n",
       "229                  1.21        1.5           6.55     9.31   \n",
       "245                  0.36        1.9           6.55    18.15   \n",
       "241                  0.48        2.5           6.55    13.34   \n",
       "236                  0.60        3.2           6.55    10.66   \n",
       "242                  0.66        3.4           6.55    14.18   \n",
       "213                  1.31        4.6           6.55     6.18   \n",
       "231                  0.98        5.3           6.55     9.76   \n",
       "215                  1.19        5.4           6.55     5.16   \n",
       "224                  0.76        5.5           6.55     8.37   \n",
       "239                  0.84        5.9           6.55    12.31   \n",
       "230                  1.21        6.1           6.55     9.29   \n",
       "212                  1.31        6.2           6.55     5.42   \n",
       "206                   NaN        6.3           6.55   -35.86   \n",
       "209                  1.47        6.4           6.55     3.90   \n",
       "220                  0.88        6.5           6.55     7.18   \n",
       "240                  0.72        6.5           6.55    11.84   \n",
       "227                  0.75        6.5           6.55     9.11   \n",
       "237                  0.76        6.6           6.55    11.21   \n",
       "233                  0.80        6.6           6.55    10.57   \n",
       "208                  1.60        6.7           6.55     3.60   \n",
       "211                  1.38        6.9           6.55     4.46   \n",
       "228                  0.90        7.1           6.55     9.76   \n",
       "207                   NaN        7.2           6.55     0.00   \n",
       "223                  0.84        7.3           6.55     8.12   \n",
       "225                  1.02        7.4           6.55     8.58   \n",
       "234                  1.07        7.4           6.55    10.85   \n",
       "218                  1.02        7.8           6.55     6.45   \n",
       "216                  1.03        7.9           6.55     6.39   \n",
       "219                  1.54        8.1           6.55     6.25   \n",
       "247                  0.78        8.5           6.55    22.25   \n",
       "217                  1.63        8.6           6.55     5.90   \n",
       "210                  1.39        9.3           6.55     4.27   \n",
       "226                  1.26        9.9           6.55     8.23   \n",
       "221                  1.15       11.5           6.55     7.42   \n",
       "214                  1.39       15.3           6.55     6.13   \n",
       "232                  1.43       16.4           6.55    10.17   \n",
       "244                  0.48     1110.5           6.55    16.99   \n",
       "243                  0.51     1290.1           6.55    16.09   \n",
       "\n",
       "     OSCILACOES_%_2023    LPA     VPA  MARG_EBIT  MARG_LIQUIDA  \\\n",
       "222             194.10   0.57    5.02        NaN           0.0   \n",
       "235               8.68   0.72   12.83        NaN           0.0   \n",
       "246              10.04   0.25   10.29        NaN           0.0   \n",
       "238              13.60   0.72   12.83        NaN           0.0   \n",
       "229              14.37   1.13   19.17        NaN           0.0   \n",
       "245               3.72   0.73    4.06        NaN           0.0   \n",
       "241              24.08   2.19   12.18        NaN           0.0   \n",
       "236              42.14   0.73    4.06        NaN           0.0   \n",
       "242              25.37   0.54    6.20        NaN           0.0   \n",
       "213             127.05   0.57    5.02        NaN           0.0   \n",
       "231               8.46   1.86   23.04        NaN           0.0   \n",
       "215              41.09   2.61   13.18        NaN           0.0   \n",
       "224              11.15   3.22   17.40        NaN           0.0   \n",
       "239              31.24   1.94   27.96        NaN           0.0   \n",
       "230              19.40   1.13   19.17        NaN           0.0   \n",
       "212               5.04   3.57   23.98        NaN           0.0   \n",
       "206               1.10  -0.20   13.81        NaN           0.0   \n",
       "209              85.77  22.28   97.45        NaN           0.0   \n",
       "220               9.64   3.22   17.40        NaN           0.0   \n",
       "240              -2.55   1.17   11.20        NaN           0.0   \n",
       "227              55.84   1.05    6.63        NaN           0.0   \n",
       "237              -2.12   2.34   22.40        NaN           0.0   \n",
       "233              -2.18   1.17   11.20        NaN           0.0   \n",
       "208              32.07  25.85  114.19        NaN           0.0   \n",
       "211              23.02   2.61   13.18        NaN           0.0   \n",
       "228              -1.27   1.45   14.97        NaN           0.0   \n",
       "207               2.87   0.00    0.00        NaN           NaN   \n",
       "223              64.82   1.05    6.63        NaN           0.0   \n",
       "225              -2.23   1.45   14.97        NaN           0.0   \n",
       "234              21.98   0.72   12.83        NaN           0.0   \n",
       "218               4.08   1.37    7.92       14.1         175.5   \n",
       "216               7.95   1.37    7.92       14.1         175.5   \n",
       "219              15.78   1.86   23.04        NaN           0.0   \n",
       "247              18.51   0.25   10.29        NaN           0.0   \n",
       "217              21.19   1.86   23.04        NaN           0.0   \n",
       "210              52.02  11.55   54.86        NaN           0.0   \n",
       "226              32.27   1.94   27.96        NaN           0.0   \n",
       "221              15.05   3.65   35.35        NaN           0.0   \n",
       "214              46.85   3.65   35.35        NaN           0.0   \n",
       "232               7.72   0.23    6.58        NaN           0.0   \n",
       "244             -29.38   0.74    6.63        NaN           0.0   \n",
       "243             -16.10   0.74    6.63        NaN           0.0   \n",
       "\n",
       "     FLAG_MENOR_GRAHAM_SETOR  FLAG_DY_ACIMA_10  FLAG_DY_ACIMA_DY_SETOR  \n",
       "222                        1                 0                       0  \n",
       "235                        1                 0                       0  \n",
       "246                        0                 0                       0  \n",
       "238                        1                 0                       0  \n",
       "229                        1                 0                       0  \n",
       "245                        0                 0                       0  \n",
       "241                        0                 0                       0  \n",
       "236                        0                 0                       0  \n",
       "242                        0                 0                       0  \n",
       "213                        1                 0                       0  \n",
       "231                        0                 0                       0  \n",
       "215                        1                 0                       0  \n",
       "224                        0                 0                       0  \n",
       "239                        0                 0                       0  \n",
       "230                        1                 0                       0  \n",
       "212                        1                 0                       0  \n",
       "206                        0                 0                       0  \n",
       "209                        1                 0                       0  \n",
       "220                        0                 0                       0  \n",
       "240                        0                 0                       0  \n",
       "227                        0                 0                       0  \n",
       "237                        0                 0                       1  \n",
       "233                        0                 0                       1  \n",
       "208                        1                 0                       1  \n",
       "211                        1                 0                       1  \n",
       "228                        0                 0                       1  \n",
       "207                        0                 0                       1  \n",
       "223                        0                 0                       1  \n",
       "225                        1                 0                       1  \n",
       "234                        1                 0                       1  \n",
       "218                        1                 0                       1  \n",
       "216                        1                 0                       1  \n",
       "219                        1                 0                       1  \n",
       "247                        0                 0                       1  \n",
       "217                        1                 0                       1  \n",
       "210                        1                 0                       1  \n",
       "226                        1                 0                       1  \n",
       "221                        1                 1                       1  \n",
       "214                        1                 1                       1  \n",
       "232                        1                 1                       1  \n",
       "244                        0                 1                       1  \n",
       "243                        0                 1                       1  "
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_viz[cols].sort_values('DIV_YIELD')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ef87a9b8",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}