Análise_de_boas_ações_pagadoras_de_dividendos.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Análise de boas ações pagadoras de dividendos.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "mount_file_id": "1g52OJRuzr_a3yq2NG2Xb9nvyQ0tAkGVi",
      "authorship_tag": "ABX9TyMnZActsahDDIDCcK26bk1h",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/andrejuniorba/Analises_estudos/blob/main/An%C3%A1lise_de_boas_a%C3%A7%C3%B5es_pagadoras_de_dividendos.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# **Análise de boas ações pagadoras de dividendos**\n",
        "\n",
        "## Essa análise foi feita com base em uma tabela retirada do site Fundamentus.\n",
        "\n",
        "[Clique aqui para ver a tabela diretamente no site](https://www.fundamentus.com.br/resultado.php)\n",
        "\n",
        "## A ideia é verificar as melhores ações pagadoras de dividendos com base nos seguintes indicadores:\n",
        "\n",
        "###1. Dividend Yield (DY)\n",
        "\n",
        "###2. Margem Líquida\n",
        "\n",
        "###3. Dívida Bruta / Patrimônio Líquido\n",
        "\n",
        "###4. Preço da ação / Valor Patrimonial por Ação (P/VPA)\n",
        "\n",
        "    \n"
      ],
      "metadata": {
        "id": "Et-WZk4MSCGg"
      }
    },
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "id": "RhfAFfxJLwx8"
      },
      "outputs": [],
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n",
        "import matplotlib as plt\n",
        "\n"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Obtenção e armazenamento dos dados"
      ],
      "metadata": {
        "id": "8xy5s9S1u5ox"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df = pd.read_csv('/content/drive/MyDrive/Dados - Data Science/ACOES_empresas.csv')"
      ],
      "metadata": {
        "id": "Pu4If33iMMR6"
      },
      "execution_count": 2,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#Configurar para mostrar todas as colunas\n",
        "pd.set_option('max_columns',23)\n",
        "#Apresentando as 5 primeiras linhas do Dataframe\n",
        "df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 288
        },
        "id": "xjiE7M-7bXvu",
        "outputId": "0d2b370e-12b8-4103-a8ac-9d70e0aead86"
      },
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   Papel Cotação       P/L  P/VP    PSR Div.Yield P/Ativo P/Cap.Giro  P/EBIT  \\\n",
              "0  LWSA3    6,94  -1441,35  1,39  4,613     0,00%   0,886       2,94  190,41   \n",
              "1  ELMD3    15,4  -1326,62  2,83  4,618     0,00%   1,406       7,54   46,52   \n",
              "2  SCAR3      32   -360,29  1,19   6,66     0,45%   0,531      -6,73    13,7   \n",
              "3  BRPR3    9,14   -357,52  0,61  13,25     1,15%   0,383      18,47    20,5   \n",
              "4  RAIL3   15,87   -333,09     2  3,725     0,12%   0,658        6,7   17,48   \n",
              "\n",
              "  P/AtivCirc.Liq EV/EBIT EV/EBITDA Mrg Ebit Mrg. Líq. Liq. Corr.   ROIC  \\\n",
              "0           8,04  122,49     22,95    2,42%    -0,32%       2,75  0,71%   \n",
              "1         -13,58   47,46      18,3    9,93%    -0,35%       1,87  4,90%   \n",
              "2          -1,12   26,87     19,19   48,62%    -2,28%       0,49  3,96%   \n",
              "3          -1,33    30,3     30,04   64,63%    -3,71%       1,31  2,02%   \n",
              "4          -1,45   23,82     11,11   21,30%    -1,10%       1,87  4,47%   \n",
              "\n",
              "      ROE Liq.2meses  Patrim. Líq Dív.Brut/Patrim. Cresc. Rec.5a  \n",
              "0  -0,10%  145163000   2941450000             0,03        47,96%  \n",
              "1  -0,21%    3102910    760772000             0,69       111,77%  \n",
              "2  -0,33%     162567   1551380000             1,19       -13,01%  \n",
              "3  -0,17%   24444200   7072250000             0,41        -7,43%  \n",
              "4  -0,60%  168181000  14706100000             1,16         5,85%  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-bd215479-b206-4663-8429-d9a732e9bb72\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Cotação</th>\n",
              "      <th>P/L</th>\n",
              "      <th>P/VP</th>\n",
              "      <th>PSR</th>\n",
              "      <th>Div.Yield</th>\n",
              "      <th>P/Ativo</th>\n",
              "      <th>P/Cap.Giro</th>\n",
              "      <th>P/EBIT</th>\n",
              "      <th>P/AtivCirc.Liq</th>\n",
              "      <th>EV/EBIT</th>\n",
              "      <th>EV/EBITDA</th>\n",
              "      <th>Mrg Ebit</th>\n",
              "      <th>Mrg. Líq.</th>\n",
              "      <th>Liq. Corr.</th>\n",
              "      <th>ROIC</th>\n",
              "      <th>ROE</th>\n",
              "      <th>Liq.2meses</th>\n",
              "      <th>Patrim. Líq</th>\n",
              "      <th>Dív.Brut/Patrim.</th>\n",
              "      <th>Cresc. Rec.5a</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>LWSA3</td>\n",
              "      <td>6,94</td>\n",
              "      <td>-1441,35</td>\n",
              "      <td>1,39</td>\n",
              "      <td>4,613</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>0,886</td>\n",
              "      <td>2,94</td>\n",
              "      <td>190,41</td>\n",
              "      <td>8,04</td>\n",
              "      <td>122,49</td>\n",
              "      <td>22,95</td>\n",
              "      <td>2,42%</td>\n",
              "      <td>-0,32%</td>\n",
              "      <td>2,75</td>\n",
              "      <td>0,71%</td>\n",
              "      <td>-0,10%</td>\n",
              "      <td>145163000</td>\n",
              "      <td>2941450000</td>\n",
              "      <td>0,03</td>\n",
              "      <td>47,96%</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>ELMD3</td>\n",
              "      <td>15,4</td>\n",
              "      <td>-1326,62</td>\n",
              "      <td>2,83</td>\n",
              "      <td>4,618</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>1,406</td>\n",
              "      <td>7,54</td>\n",
              "      <td>46,52</td>\n",
              "      <td>-13,58</td>\n",
              "      <td>47,46</td>\n",
              "      <td>18,3</td>\n",
              "      <td>9,93%</td>\n",
              "      <td>-0,35%</td>\n",
              "      <td>1,87</td>\n",
              "      <td>4,90%</td>\n",
              "      <td>-0,21%</td>\n",
              "      <td>3102910</td>\n",
              "      <td>760772000</td>\n",
              "      <td>0,69</td>\n",
              "      <td>111,77%</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>SCAR3</td>\n",
              "      <td>32</td>\n",
              "      <td>-360,29</td>\n",
              "      <td>1,19</td>\n",
              "      <td>6,66</td>\n",
              "      <td>0,45%</td>\n",
              "      <td>0,531</td>\n",
              "      <td>-6,73</td>\n",
              "      <td>13,7</td>\n",
              "      <td>-1,12</td>\n",
              "      <td>26,87</td>\n",
              "      <td>19,19</td>\n",
              "      <td>48,62%</td>\n",
              "      <td>-2,28%</td>\n",
              "      <td>0,49</td>\n",
              "      <td>3,96%</td>\n",
              "      <td>-0,33%</td>\n",
              "      <td>162567</td>\n",
              "      <td>1551380000</td>\n",
              "      <td>1,19</td>\n",
              "      <td>-13,01%</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>BRPR3</td>\n",
              "      <td>9,14</td>\n",
              "      <td>-357,52</td>\n",
              "      <td>0,61</td>\n",
              "      <td>13,25</td>\n",
              "      <td>1,15%</td>\n",
              "      <td>0,383</td>\n",
              "      <td>18,47</td>\n",
              "      <td>20,5</td>\n",
              "      <td>-1,33</td>\n",
              "      <td>30,3</td>\n",
              "      <td>30,04</td>\n",
              "      <td>64,63%</td>\n",
              "      <td>-3,71%</td>\n",
              "      <td>1,31</td>\n",
              "      <td>2,02%</td>\n",
              "      <td>-0,17%</td>\n",
              "      <td>24444200</td>\n",
              "      <td>7072250000</td>\n",
              "      <td>0,41</td>\n",
              "      <td>-7,43%</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>RAIL3</td>\n",
              "      <td>15,87</td>\n",
              "      <td>-333,09</td>\n",
              "      <td>2</td>\n",
              "      <td>3,725</td>\n",
              "      <td>0,12%</td>\n",
              "      <td>0,658</td>\n",
              "      <td>6,7</td>\n",
              "      <td>17,48</td>\n",
              "      <td>-1,45</td>\n",
              "      <td>23,82</td>\n",
              "      <td>11,11</td>\n",
              "      <td>21,30%</td>\n",
              "      <td>-1,10%</td>\n",
              "      <td>1,87</td>\n",
              "      <td>4,47%</td>\n",
              "      <td>-0,60%</td>\n",
              "      <td>168181000</td>\n",
              "      <td>14706100000</td>\n",
              "      <td>1,16</td>\n",
              "      <td>5,85%</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-bd215479-b206-4663-8429-d9a732e9bb72')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-bd215479-b206-4663-8429-d9a732e9bb72 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-bd215479-b206-4663-8429-d9a732e9bb72');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Temos 467 papéis para nossa análise."
      ],
      "metadata": {
        "id": "HYZuRm-DJYVG"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#Vericando a quantidade de linhas e colunas\n",
        "df.shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "vpeSg7w7baWy",
        "outputId": "0b42af49-f6d4-4000-f9fd-2612807b490a"
      },
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(467, 21)"
            ]
          },
          "metadata": {},
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Veja que ao verificar os tipo de dados do nosso Dataframe, encontramos várias \"Strings\" não sendo ideal em nossa análise. Sendo assim, será preciso convertê-los para o tipo numérico \"float\"."
      ],
      "metadata": {
        "id": "IrpJZWxZH5Yo"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#Verificando os tipos de dados\n",
        "df.dtypes"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ouJ4jGYjb_SK",
        "outputId": "130c32da-6cf2-4680-e2bb-01ca290e8a82"
      },
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Papel               object\n",
              "Cotação             object\n",
              "P/L                 object\n",
              "P/VP                object\n",
              "PSR                 object\n",
              "Div.Yield           object\n",
              "P/Ativo             object\n",
              "P/Cap.Giro          object\n",
              "P/EBIT              object\n",
              "P/AtivCirc.Liq      object\n",
              "EV/EBIT             object\n",
              "EV/EBITDA           object\n",
              "Mrg Ebit            object\n",
              "Mrg. Líq.           object\n",
              "Liq. Corr.          object\n",
              "ROIC                object\n",
              "ROE                 object\n",
              "Liq.2meses          object\n",
              "Patrim. Líq          int64\n",
              "Dív.Brut/Patrim.    object\n",
              "Cresc. Rec.5a       object\n",
              "dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Transformação de dados"
      ],
      "metadata": {
        "id": "BFlcsPYZvdDT"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#Converter os dados numéricos em tipo float\n",
        "for coluna in ['Cotação','P/L','P/VP','PSR','P/Ativo','P/Cap.Giro','P/EBIT','P/AtivCirc.Liq','EV/EBIT','EV/EBITDA','Liq. Corr.','Liq.2meses','Dív.Brut/Patrim.']:\n",
        "#Para cada coluna deverá substituir a vírgula pelo ponto e converter o dado para float\n",
        "  df[coluna] = df[coluna].apply(lambda x: str(x).replace(',','.'))\n",
        "  df[coluna] = df[coluna].astype('float64')"
      ],
      "metadata": {
        "id": "hNY7RQOUn9MU"
      },
      "execution_count": 6,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#Converter os dados de porcentagem em tipo float (decimal)\n",
        "for coluna_porcento in ['Div.Yield', 'Mrg Ebit', 'Mrg. Líq.', 'ROIC' , 'ROE', 'Cresc. Rec.5a']:\n",
        "#Para cada coluna deverá substituir a vírgula pelo ponto, retirar o símbolo de porcentagem e converter o dado para float (divide por 100 para apresentar em decimal)\n",
        "  df[coluna_porcento] = df[coluna_porcento].apply(lambda x: str(x).replace(',','.'))\n",
        "  df[coluna_porcento] = df[coluna_porcento].str.rstrip('%')\n",
        "  df[coluna_porcento] = df[coluna_porcento].astype('float64') / 100"
      ],
      "metadata": {
        "id": "_hD9HAm6cFZI"
      },
      "execution_count": 7,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "Aqui já podemos verificar que as transformações dos respectivos dados foram bem sucedidas."
      ],
      "metadata": {
        "id": "JiFRGvpUI_89"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df.dtypes"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "29qdrOdLqhbk",
        "outputId": "1c110fc5-a836-4bf6-b4be-725e7c3c1f1a"
      },
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Papel                object\n",
              "Cotação             float64\n",
              "P/L                 float64\n",
              "P/VP                float64\n",
              "PSR                 float64\n",
              "Div.Yield           float64\n",
              "P/Ativo             float64\n",
              "P/Cap.Giro          float64\n",
              "P/EBIT              float64\n",
              "P/AtivCirc.Liq      float64\n",
              "EV/EBIT             float64\n",
              "EV/EBITDA           float64\n",
              "Mrg Ebit            float64\n",
              "Mrg. Líq.           float64\n",
              "Liq. Corr.          float64\n",
              "ROIC                float64\n",
              "ROE                 float64\n",
              "Liq.2meses          float64\n",
              "Patrim. Líq           int64\n",
              "Dív.Brut/Patrim.    float64\n",
              "Cresc. Rec.5a       float64\n",
              "dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 288
        },
        "id": "5SIBBFFIul_s",
        "outputId": "b95ea5d6-9909-460e-a3ad-8e8d9f61575e"
      },
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   Papel  Cotação      P/L  P/VP     PSR  Div.Yield  P/Ativo  P/Cap.Giro  \\\n",
              "0  LWSA3     6.94 -1441.35  1.39   4.613     0.0000    0.886        2.94   \n",
              "1  ELMD3    15.40 -1326.62  2.83   4.618     0.0000    1.406        7.54   \n",
              "2  SCAR3    32.00  -360.29  1.19   6.660     0.0045    0.531       -6.73   \n",
              "3  BRPR3     9.14  -357.52  0.61  13.250     0.0115    0.383       18.47   \n",
              "4  RAIL3    15.87  -333.09  2.00   3.725     0.0012    0.658        6.70   \n",
              "\n",
              "   P/EBIT  P/AtivCirc.Liq  EV/EBIT  EV/EBITDA  Mrg Ebit  Mrg. Líq.  \\\n",
              "0  190.41            8.04   122.49      22.95    0.0242    -0.0032   \n",
              "1   46.52          -13.58    47.46      18.30    0.0993    -0.0035   \n",
              "2   13.70           -1.12    26.87      19.19    0.4862    -0.0228   \n",
              "3   20.50           -1.33    30.30      30.04    0.6463    -0.0371   \n",
              "4   17.48           -1.45    23.82      11.11    0.2130    -0.0110   \n",
              "\n",
              "   Liq. Corr.    ROIC     ROE   Liq.2meses  Patrim. Líq  Dív.Brut/Patrim.  \\\n",
              "0        2.75  0.0071 -0.0010  145163000.0   2941450000              0.03   \n",
              "1        1.87  0.0490 -0.0021    3102910.0    760772000              0.69   \n",
              "2        0.49  0.0396 -0.0033     162567.0   1551380000              1.19   \n",
              "3        1.31  0.0202 -0.0017   24444200.0   7072250000              0.41   \n",
              "4        1.87  0.0447 -0.0060  168181000.0  14706100000              1.16   \n",
              "\n",
              "   Cresc. Rec.5a  \n",
              "0         0.4796  \n",
              "1         1.1177  \n",
              "2        -0.1301  \n",
              "3        -0.0743  \n",
              "4         0.0585  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-6c943334-4290-438c-bf41-2957fe2f1d7a\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Cotação</th>\n",
              "      <th>P/L</th>\n",
              "      <th>P/VP</th>\n",
              "      <th>PSR</th>\n",
              "      <th>Div.Yield</th>\n",
              "      <th>P/Ativo</th>\n",
              "      <th>P/Cap.Giro</th>\n",
              "      <th>P/EBIT</th>\n",
              "      <th>P/AtivCirc.Liq</th>\n",
              "      <th>EV/EBIT</th>\n",
              "      <th>EV/EBITDA</th>\n",
              "      <th>Mrg Ebit</th>\n",
              "      <th>Mrg. Líq.</th>\n",
              "      <th>Liq. Corr.</th>\n",
              "      <th>ROIC</th>\n",
              "      <th>ROE</th>\n",
              "      <th>Liq.2meses</th>\n",
              "      <th>Patrim. Líq</th>\n",
              "      <th>Dív.Brut/Patrim.</th>\n",
              "      <th>Cresc. Rec.5a</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>LWSA3</td>\n",
              "      <td>6.94</td>\n",
              "      <td>-1441.35</td>\n",
              "      <td>1.39</td>\n",
              "      <td>4.613</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.886</td>\n",
              "      <td>2.94</td>\n",
              "      <td>190.41</td>\n",
              "      <td>8.04</td>\n",
              "      <td>122.49</td>\n",
              "      <td>22.95</td>\n",
              "      <td>0.0242</td>\n",
              "      <td>-0.0032</td>\n",
              "      <td>2.75</td>\n",
              "      <td>0.0071</td>\n",
              "      <td>-0.0010</td>\n",
              "      <td>145163000.0</td>\n",
              "      <td>2941450000</td>\n",
              "      <td>0.03</td>\n",
              "      <td>0.4796</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>ELMD3</td>\n",
              "      <td>15.40</td>\n",
              "      <td>-1326.62</td>\n",
              "      <td>2.83</td>\n",
              "      <td>4.618</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>1.406</td>\n",
              "      <td>7.54</td>\n",
              "      <td>46.52</td>\n",
              "      <td>-13.58</td>\n",
              "      <td>47.46</td>\n",
              "      <td>18.30</td>\n",
              "      <td>0.0993</td>\n",
              "      <td>-0.0035</td>\n",
              "      <td>1.87</td>\n",
              "      <td>0.0490</td>\n",
              "      <td>-0.0021</td>\n",
              "      <td>3102910.0</td>\n",
              "      <td>760772000</td>\n",
              "      <td>0.69</td>\n",
              "      <td>1.1177</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>SCAR3</td>\n",
              "      <td>32.00</td>\n",
              "      <td>-360.29</td>\n",
              "      <td>1.19</td>\n",
              "      <td>6.660</td>\n",
              "      <td>0.0045</td>\n",
              "      <td>0.531</td>\n",
              "      <td>-6.73</td>\n",
              "      <td>13.70</td>\n",
              "      <td>-1.12</td>\n",
              "      <td>26.87</td>\n",
              "      <td>19.19</td>\n",
              "      <td>0.4862</td>\n",
              "      <td>-0.0228</td>\n",
              "      <td>0.49</td>\n",
              "      <td>0.0396</td>\n",
              "      <td>-0.0033</td>\n",
              "      <td>162567.0</td>\n",
              "      <td>1551380000</td>\n",
              "      <td>1.19</td>\n",
              "      <td>-0.1301</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>BRPR3</td>\n",
              "      <td>9.14</td>\n",
              "      <td>-357.52</td>\n",
              "      <td>0.61</td>\n",
              "      <td>13.250</td>\n",
              "      <td>0.0115</td>\n",
              "      <td>0.383</td>\n",
              "      <td>18.47</td>\n",
              "      <td>20.50</td>\n",
              "      <td>-1.33</td>\n",
              "      <td>30.30</td>\n",
              "      <td>30.04</td>\n",
              "      <td>0.6463</td>\n",
              "      <td>-0.0371</td>\n",
              "      <td>1.31</td>\n",
              "      <td>0.0202</td>\n",
              "      <td>-0.0017</td>\n",
              "      <td>24444200.0</td>\n",
              "      <td>7072250000</td>\n",
              "      <td>0.41</td>\n",
              "      <td>-0.0743</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>RAIL3</td>\n",
              "      <td>15.87</td>\n",
              "      <td>-333.09</td>\n",
              "      <td>2.00</td>\n",
              "      <td>3.725</td>\n",
              "      <td>0.0012</td>\n",
              "      <td>0.658</td>\n",
              "      <td>6.70</td>\n",
              "      <td>17.48</td>\n",
              "      <td>-1.45</td>\n",
              "      <td>23.82</td>\n",
              "      <td>11.11</td>\n",
              "      <td>0.2130</td>\n",
              "      <td>-0.0110</td>\n",
              "      <td>1.87</td>\n",
              "      <td>0.0447</td>\n",
              "      <td>-0.0060</td>\n",
              "      <td>168181000.0</td>\n",
              "      <td>14706100000</td>\n",
              "      <td>1.16</td>\n",
              "      <td>0.0585</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-6c943334-4290-438c-bf41-2957fe2f1d7a')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-6c943334-4290-438c-bf41-2957fe2f1d7a button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-6c943334-4290-438c-bf41-2957fe2f1d7a');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Análise e Limpeza dos dados"
      ],
      "metadata": {
        "id": "7CCi9eVHCzfK"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "#  **Dividend Yield (DY)**\n",
        "\n",
        "* DY = (total em proventos em dinheiro [últimos 12 meses] ÷ preço atual da ação) x 100\n",
        "\n",
        "* É um indicador que mede quanto a empresa paga aos seus investidores em dividendos e outros proventos em dinheiro. \n",
        "\n",
        "* Quanto maior for o DY, maior será o pagamento de dividendos daquela empresa. \n"
      ],
      "metadata": {
        "id": "LqeHk--HN_rX"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Inicialmente vamos filtrar as ações que são pagadoras de dividendos."
      ],
      "metadata": {
        "id": "vfbCnKeHC-et"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "filtro = df['Div.Yield'] > 0"
      ],
      "metadata": {
        "id": "B9LeGKCVDNbW"
      },
      "execution_count": 10,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_dividendos = df[filtro]"
      ],
      "metadata": {
        "id": "pB7IoR47CQFn"
      },
      "execution_count": 11,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "Após aplicação do filtro podemos perceber que só restaram as ações que pagam dividendos."
      ],
      "metadata": {
        "id": "QqnR_nyHC1sH"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df_dividendos.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 288
        },
        "id": "GQ2cwAyXCbcq",
        "outputId": "b6d450ce-acfd-413f-a405-70ee32975d17"
      },
      "execution_count": 12,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "    Papel  Cotação     P/L  P/VP     PSR  Div.Yield  P/Ativo  P/Cap.Giro  \\\n",
              "2   SCAR3    32.00 -360.29  1.19   6.660     0.0045    0.531       -6.73   \n",
              "3   BRPR3     9.14 -357.52  0.61  13.250     0.0115    0.383       18.47   \n",
              "4   RAIL3    15.87 -333.09  2.00   3.725     0.0012    0.658        6.70   \n",
              "11  DASA3    18.99  -60.11  1.41   0.952     0.0155    0.434       31.85   \n",
              "94  APER3    35.37    0.00  1.80   3.246     0.0020    1.008       15.07   \n",
              "\n",
              "    P/EBIT  P/AtivCirc.Liq  EV/EBIT  EV/EBITDA  Mrg Ebit  Mrg. Líq.  \\\n",
              "2    13.70           -1.12    26.87      19.19    0.4862    -0.0228   \n",
              "3    20.50           -1.33    30.30      30.04    0.6463    -0.0371   \n",
              "4    17.48           -1.45    23.82      11.11    0.2130    -0.0110   \n",
              "11   46.77           -1.04    74.80      13.97    0.0204    -0.0152   \n",
              "94    0.00           -5.77     0.00       0.00    0.0000     0.0000   \n",
              "\n",
              "    Liq. Corr.    ROIC     ROE   Liq.2meses  Patrim. Líq  Dív.Brut/Patrim.  \\\n",
              "2         0.49  0.0396 -0.0033     162567.0   1551380000              1.19   \n",
              "3         1.31  0.0202 -0.0017   24444200.0   7072250000              0.41   \n",
              "4         1.87  0.0447 -0.0060  168181000.0  14706100000              1.16   \n",
              "11        1.05  0.0111 -0.0234    8675320.0   7573560000              1.23   \n",
              "94        1.34  0.0000  0.0000    1368910.0    298664000              0.00   \n",
              "\n",
              "    Cresc. Rec.5a  \n",
              "2         -0.1301  \n",
              "3         -0.0743  \n",
              "4          0.0585  \n",
              "11         0.3481  \n",
              "94         0.1519  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-09fb5630-75a1-4367-9f30-ceb3316328bd\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Cotação</th>\n",
              "      <th>P/L</th>\n",
              "      <th>P/VP</th>\n",
              "      <th>PSR</th>\n",
              "      <th>Div.Yield</th>\n",
              "      <th>P/Ativo</th>\n",
              "      <th>P/Cap.Giro</th>\n",
              "      <th>P/EBIT</th>\n",
              "      <th>P/AtivCirc.Liq</th>\n",
              "      <th>EV/EBIT</th>\n",
              "      <th>EV/EBITDA</th>\n",
              "      <th>Mrg Ebit</th>\n",
              "      <th>Mrg. Líq.</th>\n",
              "      <th>Liq. Corr.</th>\n",
              "      <th>ROIC</th>\n",
              "      <th>ROE</th>\n",
              "      <th>Liq.2meses</th>\n",
              "      <th>Patrim. Líq</th>\n",
              "      <th>Dív.Brut/Patrim.</th>\n",
              "      <th>Cresc. Rec.5a</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>SCAR3</td>\n",
              "      <td>32.00</td>\n",
              "      <td>-360.29</td>\n",
              "      <td>1.19</td>\n",
              "      <td>6.660</td>\n",
              "      <td>0.0045</td>\n",
              "      <td>0.531</td>\n",
              "      <td>-6.73</td>\n",
              "      <td>13.70</td>\n",
              "      <td>-1.12</td>\n",
              "      <td>26.87</td>\n",
              "      <td>19.19</td>\n",
              "      <td>0.4862</td>\n",
              "      <td>-0.0228</td>\n",
              "      <td>0.49</td>\n",
              "      <td>0.0396</td>\n",
              "      <td>-0.0033</td>\n",
              "      <td>162567.0</td>\n",
              "      <td>1551380000</td>\n",
              "      <td>1.19</td>\n",
              "      <td>-0.1301</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>BRPR3</td>\n",
              "      <td>9.14</td>\n",
              "      <td>-357.52</td>\n",
              "      <td>0.61</td>\n",
              "      <td>13.250</td>\n",
              "      <td>0.0115</td>\n",
              "      <td>0.383</td>\n",
              "      <td>18.47</td>\n",
              "      <td>20.50</td>\n",
              "      <td>-1.33</td>\n",
              "      <td>30.30</td>\n",
              "      <td>30.04</td>\n",
              "      <td>0.6463</td>\n",
              "      <td>-0.0371</td>\n",
              "      <td>1.31</td>\n",
              "      <td>0.0202</td>\n",
              "      <td>-0.0017</td>\n",
              "      <td>24444200.0</td>\n",
              "      <td>7072250000</td>\n",
              "      <td>0.41</td>\n",
              "      <td>-0.0743</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>RAIL3</td>\n",
              "      <td>15.87</td>\n",
              "      <td>-333.09</td>\n",
              "      <td>2.00</td>\n",
              "      <td>3.725</td>\n",
              "      <td>0.0012</td>\n",
              "      <td>0.658</td>\n",
              "      <td>6.70</td>\n",
              "      <td>17.48</td>\n",
              "      <td>-1.45</td>\n",
              "      <td>23.82</td>\n",
              "      <td>11.11</td>\n",
              "      <td>0.2130</td>\n",
              "      <td>-0.0110</td>\n",
              "      <td>1.87</td>\n",
              "      <td>0.0447</td>\n",
              "      <td>-0.0060</td>\n",
              "      <td>168181000.0</td>\n",
              "      <td>14706100000</td>\n",
              "      <td>1.16</td>\n",
              "      <td>0.0585</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>DASA3</td>\n",
              "      <td>18.99</td>\n",
              "      <td>-60.11</td>\n",
              "      <td>1.41</td>\n",
              "      <td>0.952</td>\n",
              "      <td>0.0155</td>\n",
              "      <td>0.434</td>\n",
              "      <td>31.85</td>\n",
              "      <td>46.77</td>\n",
              "      <td>-1.04</td>\n",
              "      <td>74.80</td>\n",
              "      <td>13.97</td>\n",
              "      <td>0.0204</td>\n",
              "      <td>-0.0152</td>\n",
              "      <td>1.05</td>\n",
              "      <td>0.0111</td>\n",
              "      <td>-0.0234</td>\n",
              "      <td>8675320.0</td>\n",
              "      <td>7573560000</td>\n",
              "      <td>1.23</td>\n",
              "      <td>0.3481</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>94</th>\n",
              "      <td>APER3</td>\n",
              "      <td>35.37</td>\n",
              "      <td>0.00</td>\n",
              "      <td>1.80</td>\n",
              "      <td>3.246</td>\n",
              "      <td>0.0020</td>\n",
              "      <td>1.008</td>\n",
              "      <td>15.07</td>\n",
              "      <td>0.00</td>\n",
              "      <td>-5.77</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>1.34</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>1368910.0</td>\n",
              "      <td>298664000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.1519</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-09fb5630-75a1-4367-9f30-ceb3316328bd')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-09fb5630-75a1-4367-9f30-ceb3316328bd button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-09fb5630-75a1-4367-9f30-ceb3316328bd');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 12
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "De 467 papéis restaram 308"
      ],
      "metadata": {
        "id": "1cHwqELACwWg"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df_dividendos.shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "hDodECYqCfA5",
        "outputId": "f27a7498-99de-4dd2-9b2c-baa8c0f3b674"
      },
      "execution_count": 13,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(308, 21)"
            ]
          },
          "metadata": {},
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# **Margem Líquida**\n",
        "\n",
        "* O resultado é apresentado sempre em termos percentuais.\n",
        "LUCRO LÍQUIDO / RECEITA LÍQUIDA = MARGEM LÍQUIDA\n",
        "\n",
        "* Uma margem líquida alta indica que a empresa está conseguindo converter boa parte da receita em lucro líquido. Isso pode acontecer, por exemplo, com empresas que conseguem manter seus custos baixos ou cobrar preços elevados pelos seus produtos.\n",
        "\n",
        "* Margens líquidas altas chamam atenção para a entrada de novos competidores. \n",
        "\n",
        "* Margem líquida baixa é perigosa. Se o custo de uma empresa com baixa margem líquida aumentar, isso pode ser suficiente para neutralizar o lucro da empresa.\n"
      ],
      "metadata": {
        "id": "9OKHVqBsOiBQ"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Nessa etapa vamos filtrar as empresas que estão com Margem líquida positiva"
      ],
      "metadata": {
        "id": "-9scHafcOI9n"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "filtro2 = df_dividendos['Mrg. Líq.'] > 0"
      ],
      "metadata": {
        "id": "1rmjcdIDCnMs"
      },
      "execution_count": 14,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_mliquida = df_dividendos[filtro2]"
      ],
      "metadata": {
        "id": "_MBxGg6vHPSu"
      },
      "execution_count": 15,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_mliquida.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 288
        },
        "id": "AVPxRn9KHYdW",
        "outputId": "f625a804-702f-4f8a-f2d3-27d867a52388"
      },
      "execution_count": 16,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "     Papel  Cotação   P/L  P/VP    PSR  Div.Yield  P/Ativo  P/Cap.Giro  \\\n",
              "112  BRKM6    23.35  1.21  1.60  0.170     0.0260    0.214        1.21   \n",
              "115  USIM3    10.53  1.41  0.58  0.382     0.1660    0.337        0.92   \n",
              "117  USIM5    11.05  1.48  0.60  0.401     0.1740    0.354        0.97   \n",
              "118  EUCA4    10.20  1.84  0.48  0.375     0.0277    0.274        2.09   \n",
              "119  HBTS5    39.97  1.89  0.77  1.267     0.0289    0.268      -36.59   \n",
              "\n",
              "     P/EBIT  P/AtivCirc.Liq  EV/EBIT  EV/EBITDA  Mrg Ebit  Mrg. Líq.  \\\n",
              "112    0.75           -0.50     1.50       1.29    0.2270     0.1413   \n",
              "115    1.41            2.14     1.30       1.18    0.2713     0.2931   \n",
              "117    1.48            2.25     1.37       1.24    0.2713     0.2931   \n",
              "118    1.85           -3.16     2.67       2.08    0.2032     0.1794   \n",
              "119    2.85           -0.49     4.40       4.37    0.4445     0.6715   \n",
              "\n",
              "     Liq. Corr.    ROIC     ROE    Liq.2meses  Patrim. Líq  Dív.Brut/Patrim.  \\\n",
              "112        1.63  0.3971  1.3256  9.084900e+02  11598700000              2.68   \n",
              "115        3.69  0.3146  0.4068  7.561790e+06  22934500000              0.24   \n",
              "117        3.69  0.3146  0.4068  2.267570e+08  22934500000              0.24   \n",
              "118        1.62  0.1633  0.2615  8.412260e+05   1962860000              0.25   \n",
              "119        0.93  0.0975  0.4059  1.510660e+04    476819000              0.50   \n",
              "\n",
              "     Cresc. Rec.5a  \n",
              "112         0.1915  \n",
              "115         0.2837  \n",
              "117         0.2837  \n",
              "118         0.2017  \n",
              "119         0.7155  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-3fa93a08-ed75-4e25-a252-8f01ef303ace\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Cotação</th>\n",
              "      <th>P/L</th>\n",
              "      <th>P/VP</th>\n",
              "      <th>PSR</th>\n",
              "      <th>Div.Yield</th>\n",
              "      <th>P/Ativo</th>\n",
              "      <th>P/Cap.Giro</th>\n",
              "      <th>P/EBIT</th>\n",
              "      <th>P/AtivCirc.Liq</th>\n",
              "      <th>EV/EBIT</th>\n",
              "      <th>EV/EBITDA</th>\n",
              "      <th>Mrg Ebit</th>\n",
              "      <th>Mrg. Líq.</th>\n",
              "      <th>Liq. Corr.</th>\n",
              "      <th>ROIC</th>\n",
              "      <th>ROE</th>\n",
              "      <th>Liq.2meses</th>\n",
              "      <th>Patrim. Líq</th>\n",
              "      <th>Dív.Brut/Patrim.</th>\n",
              "      <th>Cresc. Rec.5a</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>112</th>\n",
              "      <td>BRKM6</td>\n",
              "      <td>23.35</td>\n",
              "      <td>1.21</td>\n",
              "      <td>1.60</td>\n",
              "      <td>0.170</td>\n",
              "      <td>0.0260</td>\n",
              "      <td>0.214</td>\n",
              "      <td>1.21</td>\n",
              "      <td>0.75</td>\n",
              "      <td>-0.50</td>\n",
              "      <td>1.50</td>\n",
              "      <td>1.29</td>\n",
              "      <td>0.2270</td>\n",
              "      <td>0.1413</td>\n",
              "      <td>1.63</td>\n",
              "      <td>0.3971</td>\n",
              "      <td>1.3256</td>\n",
              "      <td>9.084900e+02</td>\n",
              "      <td>11598700000</td>\n",
              "      <td>2.68</td>\n",
              "      <td>0.1915</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>115</th>\n",
              "      <td>USIM3</td>\n",
              "      <td>10.53</td>\n",
              "      <td>1.41</td>\n",
              "      <td>0.58</td>\n",
              "      <td>0.382</td>\n",
              "      <td>0.1660</td>\n",
              "      <td>0.337</td>\n",
              "      <td>0.92</td>\n",
              "      <td>1.41</td>\n",
              "      <td>2.14</td>\n",
              "      <td>1.30</td>\n",
              "      <td>1.18</td>\n",
              "      <td>0.2713</td>\n",
              "      <td>0.2931</td>\n",
              "      <td>3.69</td>\n",
              "      <td>0.3146</td>\n",
              "      <td>0.4068</td>\n",
              "      <td>7.561790e+06</td>\n",
              "      <td>22934500000</td>\n",
              "      <td>0.24</td>\n",
              "      <td>0.2837</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>117</th>\n",
              "      <td>USIM5</td>\n",
              "      <td>11.05</td>\n",
              "      <td>1.48</td>\n",
              "      <td>0.60</td>\n",
              "      <td>0.401</td>\n",
              "      <td>0.1740</td>\n",
              "      <td>0.354</td>\n",
              "      <td>0.97</td>\n",
              "      <td>1.48</td>\n",
              "      <td>2.25</td>\n",
              "      <td>1.37</td>\n",
              "      <td>1.24</td>\n",
              "      <td>0.2713</td>\n",
              "      <td>0.2931</td>\n",
              "      <td>3.69</td>\n",
              "      <td>0.3146</td>\n",
              "      <td>0.4068</td>\n",
              "      <td>2.267570e+08</td>\n",
              "      <td>22934500000</td>\n",
              "      <td>0.24</td>\n",
              "      <td>0.2837</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>118</th>\n",
              "      <td>EUCA4</td>\n",
              "      <td>10.20</td>\n",
              "      <td>1.84</td>\n",
              "      <td>0.48</td>\n",
              "      <td>0.375</td>\n",
              "      <td>0.0277</td>\n",
              "      <td>0.274</td>\n",
              "      <td>2.09</td>\n",
              "      <td>1.85</td>\n",
              "      <td>-3.16</td>\n",
              "      <td>2.67</td>\n",
              "      <td>2.08</td>\n",
              "      <td>0.2032</td>\n",
              "      <td>0.1794</td>\n",
              "      <td>1.62</td>\n",
              "      <td>0.1633</td>\n",
              "      <td>0.2615</td>\n",
              "      <td>8.412260e+05</td>\n",
              "      <td>1962860000</td>\n",
              "      <td>0.25</td>\n",
              "      <td>0.2017</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>119</th>\n",
              "      <td>HBTS5</td>\n",
              "      <td>39.97</td>\n",
              "      <td>1.89</td>\n",
              "      <td>0.77</td>\n",
              "      <td>1.267</td>\n",
              "      <td>0.0289</td>\n",
              "      <td>0.268</td>\n",
              "      <td>-36.59</td>\n",
              "      <td>2.85</td>\n",
              "      <td>-0.49</td>\n",
              "      <td>4.40</td>\n",
              "      <td>4.37</td>\n",
              "      <td>0.4445</td>\n",
              "      <td>0.6715</td>\n",
              "      <td>0.93</td>\n",
              "      <td>0.0975</td>\n",
              "      <td>0.4059</td>\n",
              "      <td>1.510660e+04</td>\n",
              "      <td>476819000</td>\n",
              "      <td>0.50</td>\n",
              "      <td>0.7155</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-3fa93a08-ed75-4e25-a252-8f01ef303ace')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-3fa93a08-ed75-4e25-a252-8f01ef303ace button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-3fa93a08-ed75-4e25-a252-8f01ef303ace');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Após aplicação do filtro restaram 256 empresas."
      ],
      "metadata": {
        "id": "6uuN7DrMOZBZ"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df_mliquida.shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "jYRnqOKeHd0X",
        "outputId": "a1a24a83-f363-41ed-81c2-3c7aed5f2e17"
      },
      "execution_count": 17,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(256, 21)"
            ]
          },
          "metadata": {},
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Resetando o index\n",
        "df_mliquida.reset_index(inplace=True, drop=False)"
      ],
      "metadata": {
        "id": "dyEiH3n_Hslr"
      },
      "execution_count": 18,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_mliquida.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 288
        },
        "id": "0zSS3KNBPrFY",
        "outputId": "103ac96c-2a76-452a-aee1-da44c838448e"
      },
      "execution_count": 19,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   index  Papel  Cotação   P/L  P/VP    PSR  Div.Yield  P/Ativo  P/Cap.Giro  \\\n",
              "0    112  BRKM6    23.35  1.21  1.60  0.170     0.0260    0.214        1.21   \n",
              "1    115  USIM3    10.53  1.41  0.58  0.382     0.1660    0.337        0.92   \n",
              "2    117  USIM5    11.05  1.48  0.60  0.401     0.1740    0.354        0.97   \n",
              "3    118  EUCA4    10.20  1.84  0.48  0.375     0.0277    0.274        2.09   \n",
              "4    119  HBTS5    39.97  1.89  0.77  1.267     0.0289    0.268      -36.59   \n",
              "\n",
              "   P/EBIT  P/AtivCirc.Liq  EV/EBIT  EV/EBITDA  Mrg Ebit  Mrg. Líq.  \\\n",
              "0    0.75           -0.50     1.50       1.29    0.2270     0.1413   \n",
              "1    1.41            2.14     1.30       1.18    0.2713     0.2931   \n",
              "2    1.48            2.25     1.37       1.24    0.2713     0.2931   \n",
              "3    1.85           -3.16     2.67       2.08    0.2032     0.1794   \n",
              "4    2.85           -0.49     4.40       4.37    0.4445     0.6715   \n",
              "\n",
              "   Liq. Corr.    ROIC     ROE    Liq.2meses  Patrim. Líq  Dív.Brut/Patrim.  \\\n",
              "0        1.63  0.3971  1.3256  9.084900e+02  11598700000              2.68   \n",
              "1        3.69  0.3146  0.4068  7.561790e+06  22934500000              0.24   \n",
              "2        3.69  0.3146  0.4068  2.267570e+08  22934500000              0.24   \n",
              "3        1.62  0.1633  0.2615  8.412260e+05   1962860000              0.25   \n",
              "4        0.93  0.0975  0.4059  1.510660e+04    476819000              0.50   \n",
              "\n",
              "   Cresc. Rec.5a  \n",
              "0         0.1915  \n",
              "1         0.2837  \n",
              "2         0.2837  \n",
              "3         0.2017  \n",
              "4         0.7155  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-b8a54d53-ed4a-4deb-88e1-b29ba3355a88\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>index</th>\n",
              "      <th>Papel</th>\n",
              "      <th>Cotação</th>\n",
              "      <th>P/L</th>\n",
              "      <th>P/VP</th>\n",
              "      <th>PSR</th>\n",
              "      <th>Div.Yield</th>\n",
              "      <th>P/Ativo</th>\n",
              "      <th>P/Cap.Giro</th>\n",
              "      <th>P/EBIT</th>\n",
              "      <th>P/AtivCirc.Liq</th>\n",
              "      <th>EV/EBIT</th>\n",
              "      <th>EV/EBITDA</th>\n",
              "      <th>Mrg Ebit</th>\n",
              "      <th>Mrg. Líq.</th>\n",
              "      <th>Liq. Corr.</th>\n",
              "      <th>ROIC</th>\n",
              "      <th>ROE</th>\n",
              "      <th>Liq.2meses</th>\n",
              "      <th>Patrim. Líq</th>\n",
              "      <th>Dív.Brut/Patrim.</th>\n",
              "      <th>Cresc. Rec.5a</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>112</td>\n",
              "      <td>BRKM6</td>\n",
              "      <td>23.35</td>\n",
              "      <td>1.21</td>\n",
              "      <td>1.60</td>\n",
              "      <td>0.170</td>\n",
              "      <td>0.0260</td>\n",
              "      <td>0.214</td>\n",
              "      <td>1.21</td>\n",
              "      <td>0.75</td>\n",
              "      <td>-0.50</td>\n",
              "      <td>1.50</td>\n",
              "      <td>1.29</td>\n",
              "      <td>0.2270</td>\n",
              "      <td>0.1413</td>\n",
              "      <td>1.63</td>\n",
              "      <td>0.3971</td>\n",
              "      <td>1.3256</td>\n",
              "      <td>9.084900e+02</td>\n",
              "      <td>11598700000</td>\n",
              "      <td>2.68</td>\n",
              "      <td>0.1915</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>115</td>\n",
              "      <td>USIM3</td>\n",
              "      <td>10.53</td>\n",
              "      <td>1.41</td>\n",
              "      <td>0.58</td>\n",
              "      <td>0.382</td>\n",
              "      <td>0.1660</td>\n",
              "      <td>0.337</td>\n",
              "      <td>0.92</td>\n",
              "      <td>1.41</td>\n",
              "      <td>2.14</td>\n",
              "      <td>1.30</td>\n",
              "      <td>1.18</td>\n",
              "      <td>0.2713</td>\n",
              "      <td>0.2931</td>\n",
              "      <td>3.69</td>\n",
              "      <td>0.3146</td>\n",
              "      <td>0.4068</td>\n",
              "      <td>7.561790e+06</td>\n",
              "      <td>22934500000</td>\n",
              "      <td>0.24</td>\n",
              "      <td>0.2837</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>117</td>\n",
              "      <td>USIM5</td>\n",
              "      <td>11.05</td>\n",
              "      <td>1.48</td>\n",
              "      <td>0.60</td>\n",
              "      <td>0.401</td>\n",
              "      <td>0.1740</td>\n",
              "      <td>0.354</td>\n",
              "      <td>0.97</td>\n",
              "      <td>1.48</td>\n",
              "      <td>2.25</td>\n",
              "      <td>1.37</td>\n",
              "      <td>1.24</td>\n",
              "      <td>0.2713</td>\n",
              "      <td>0.2931</td>\n",
              "      <td>3.69</td>\n",
              "      <td>0.3146</td>\n",
              "      <td>0.4068</td>\n",
              "      <td>2.267570e+08</td>\n",
              "      <td>22934500000</td>\n",
              "      <td>0.24</td>\n",
              "      <td>0.2837</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>118</td>\n",
              "      <td>EUCA4</td>\n",
              "      <td>10.20</td>\n",
              "      <td>1.84</td>\n",
              "      <td>0.48</td>\n",
              "      <td>0.375</td>\n",
              "      <td>0.0277</td>\n",
              "      <td>0.274</td>\n",
              "      <td>2.09</td>\n",
              "      <td>1.85</td>\n",
              "      <td>-3.16</td>\n",
              "      <td>2.67</td>\n",
              "      <td>2.08</td>\n",
              "      <td>0.2032</td>\n",
              "      <td>0.1794</td>\n",
              "      <td>1.62</td>\n",
              "      <td>0.1633</td>\n",
              "      <td>0.2615</td>\n",
              "      <td>8.412260e+05</td>\n",
              "      <td>1962860000</td>\n",
              "      <td>0.25</td>\n",
              "      <td>0.2017</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>119</td>\n",
              "      <td>HBTS5</td>\n",
              "      <td>39.97</td>\n",
              "      <td>1.89</td>\n",
              "      <td>0.77</td>\n",
              "      <td>1.267</td>\n",
              "      <td>0.0289</td>\n",
              "      <td>0.268</td>\n",
              "      <td>-36.59</td>\n",
              "      <td>2.85</td>\n",
              "      <td>-0.49</td>\n",
              "      <td>4.40</td>\n",
              "      <td>4.37</td>\n",
              "      <td>0.4445</td>\n",
              "      <td>0.6715</td>\n",
              "      <td>0.93</td>\n",
              "      <td>0.0975</td>\n",
              "      <td>0.4059</td>\n",
              "      <td>1.510660e+04</td>\n",
              "      <td>476819000</td>\n",
              "      <td>0.50</td>\n",
              "      <td>0.7155</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b8a54d53-ed4a-4deb-88e1-b29ba3355a88')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-b8a54d53-ed4a-4deb-88e1-b29ba3355a88 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-b8a54d53-ed4a-4deb-88e1-b29ba3355a88');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# **Preço da ação / Valor Patrimonial por Ação (P/VP)**\n",
        "\n",
        "* Se baseia na comparação entre o preço das ações e o valor patrimonial dela.\n",
        "\n",
        "* Muitos consideram esse um dos principais indicadores da avaliação e identificação de ações “baratas”\n",
        "\n",
        "* Se o P/VP for igual a 1, indica que a ação está sendo negociada por um preço equivalente ao patrimônio líquido da empresa;\n",
        "\n",
        "* Se for superior a 1, indica que a ação está sendo negociada por um preço superior ao patrimônio líquido da empresa, o que pode indicar que a empresa está com uma boa saúde financeira, com expectativas de crescimento, logo, com mais expectativas quanto à distribuição de dividendos.\n",
        "\n",
        "* Se for inferior a 1, indica que a ação está sendo negociada por um preço inferior ao patrimônio líquido da empresa. A compra de uma ação com P/VPA inferior a 1 deve ser muito bem estudada, uma vez que, com o índice nesse patamar, a empresa pode estar sinalizando que não está indo bem, ou seja, com problemas corporativos, financeiros, etc."
      ],
      "metadata": {
        "id": "qenFJXYyPR9q"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Filtrar empresas com P/VP maior ou igual a 1."
      ],
      "metadata": {
        "id": "0Uc3yoHBFUoP"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "filtro3 = df_mliquida['P/VP'] >=1"
      ],
      "metadata": {
        "id": "lSwop3sEUrJH"
      },
      "execution_count": 42,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_preco_vp = df_mliquida[filtro3]"
      ],
      "metadata": {
        "id": "M8ZxuoMOU61Q"
      },
      "execution_count": 43,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_preco_vp.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 288
        },
        "id": "1dBWXPLkVD68",
        "outputId": "9d857062-88c1-4d9e-d3bd-e07e40c1080e"
      },
      "execution_count": 44,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "    index  Papel  Cotação   P/L  P/VP    PSR  Div.Yield  P/Ativo  P/Cap.Giro  \\\n",
              "0     112  BRKM6    23.35  1.21  1.60  0.170     0.0260    0.214        1.21   \n",
              "6     121  BRKM3    41.32  2.14  2.84  0.300     0.2235    0.379        2.14   \n",
              "8     123  BRKM5    43.11  2.24  2.96  0.313     0.2142    0.395        2.23   \n",
              "11    126  MRFG3    15.03  2.49  3.09  0.115     0.2177    0.214        2.17   \n",
              "14    133  GGBR4    27.96  3.01  1.14  0.584     0.1184    0.672        2.41   \n",
              "\n",
              "    P/EBIT  P/AtivCirc.Liq  EV/EBIT  EV/EBITDA  Mrg Ebit  Mrg. Líq.  \\\n",
              "0     0.75           -0.50     1.50       1.29    0.2270     0.1413   \n",
              "6     1.32           -0.89     2.08       1.78    0.2270     0.1413   \n",
              "8     1.38           -0.93     2.14       1.83    0.2270     0.1413   \n",
              "11    0.74           -0.47     2.29       2.06    0.1546     0.0733   \n",
              "14    2.40            9.78     2.65       2.36    0.2438     0.1947   \n",
              "\n",
              "    Liq. Corr.    ROIC     ROE    Liq.2meses  Patrim. Líq  Dív.Brut/Patrim.  \\\n",
              "0         1.63  0.3971  1.3256  9.084900e+02  11598700000              2.68   \n",
              "6         1.63  0.3971  1.3256  4.546540e+05  11598700000              2.68   \n",
              "8         1.63  0.3971  1.3256  1.154650e+08  11598700000              2.68   \n",
              "11        1.29  0.4181  1.2416  1.274630e+08   3359720000              9.79   \n",
              "14        2.43  0.3592  0.3772  3.775660e+08  42328400000              0.30   \n",
              "\n",
              "    Cresc. Rec.5a  \n",
              "0          0.1915  \n",
              "6          0.1915  \n",
              "8          0.1915  \n",
              "11         0.4855  \n",
              "14         0.1745  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-3ac38721-ef7a-47bc-a74e-f4bd66b6e9df\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>index</th>\n",
              "      <th>Papel</th>\n",
              "      <th>Cotação</th>\n",
              "      <th>P/L</th>\n",
              "      <th>P/VP</th>\n",
              "      <th>PSR</th>\n",
              "      <th>Div.Yield</th>\n",
              "      <th>P/Ativo</th>\n",
              "      <th>P/Cap.Giro</th>\n",
              "      <th>P/EBIT</th>\n",
              "      <th>P/AtivCirc.Liq</th>\n",
              "      <th>EV/EBIT</th>\n",
              "      <th>EV/EBITDA</th>\n",
              "      <th>Mrg Ebit</th>\n",
              "      <th>Mrg. Líq.</th>\n",
              "      <th>Liq. Corr.</th>\n",
              "      <th>ROIC</th>\n",
              "      <th>ROE</th>\n",
              "      <th>Liq.2meses</th>\n",
              "      <th>Patrim. Líq</th>\n",
              "      <th>Dív.Brut/Patrim.</th>\n",
              "      <th>Cresc. Rec.5a</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>112</td>\n",
              "      <td>BRKM6</td>\n",
              "      <td>23.35</td>\n",
              "      <td>1.21</td>\n",
              "      <td>1.60</td>\n",
              "      <td>0.170</td>\n",
              "      <td>0.0260</td>\n",
              "      <td>0.214</td>\n",
              "      <td>1.21</td>\n",
              "      <td>0.75</td>\n",
              "      <td>-0.50</td>\n",
              "      <td>1.50</td>\n",
              "      <td>1.29</td>\n",
              "      <td>0.2270</td>\n",
              "      <td>0.1413</td>\n",
              "      <td>1.63</td>\n",
              "      <td>0.3971</td>\n",
              "      <td>1.3256</td>\n",
              "      <td>9.084900e+02</td>\n",
              "      <td>11598700000</td>\n",
              "      <td>2.68</td>\n",
              "      <td>0.1915</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>121</td>\n",
              "      <td>BRKM3</td>\n",
              "      <td>41.32</td>\n",
              "      <td>2.14</td>\n",
              "      <td>2.84</td>\n",
              "      <td>0.300</td>\n",
              "      <td>0.2235</td>\n",
              "      <td>0.379</td>\n",
              "      <td>2.14</td>\n",
              "      <td>1.32</td>\n",
              "      <td>-0.89</td>\n",
              "      <td>2.08</td>\n",
              "      <td>1.78</td>\n",
              "      <td>0.2270</td>\n",
              "      <td>0.1413</td>\n",
              "      <td>1.63</td>\n",
              "      <td>0.3971</td>\n",
              "      <td>1.3256</td>\n",
              "      <td>4.546540e+05</td>\n",
              "      <td>11598700000</td>\n",
              "      <td>2.68</td>\n",
              "      <td>0.1915</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>123</td>\n",
              "      <td>BRKM5</td>\n",
              "      <td>43.11</td>\n",
              "      <td>2.24</td>\n",
              "      <td>2.96</td>\n",
              "      <td>0.313</td>\n",
              "      <td>0.2142</td>\n",
              "      <td>0.395</td>\n",
              "      <td>2.23</td>\n",
              "      <td>1.38</td>\n",
              "      <td>-0.93</td>\n",
              "      <td>2.14</td>\n",
              "      <td>1.83</td>\n",
              "      <td>0.2270</td>\n",
              "      <td>0.1413</td>\n",
              "      <td>1.63</td>\n",
              "      <td>0.3971</td>\n",
              "      <td>1.3256</td>\n",
              "      <td>1.154650e+08</td>\n",
              "      <td>11598700000</td>\n",
              "      <td>2.68</td>\n",
              "      <td>0.1915</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>126</td>\n",
              "      <td>MRFG3</td>\n",
              "      <td>15.03</td>\n",
              "      <td>2.49</td>\n",
              "      <td>3.09</td>\n",
              "      <td>0.115</td>\n",
              "      <td>0.2177</td>\n",
              "      <td>0.214</td>\n",
              "      <td>2.17</td>\n",
              "      <td>0.74</td>\n",
              "      <td>-0.47</td>\n",
              "      <td>2.29</td>\n",
              "      <td>2.06</td>\n",
              "      <td>0.1546</td>\n",
              "      <td>0.0733</td>\n",
              "      <td>1.29</td>\n",
              "      <td>0.4181</td>\n",
              "      <td>1.2416</td>\n",
              "      <td>1.274630e+08</td>\n",
              "      <td>3359720000</td>\n",
              "      <td>9.79</td>\n",
              "      <td>0.4855</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>133</td>\n",
              "      <td>GGBR4</td>\n",
              "      <td>27.96</td>\n",
              "      <td>3.01</td>\n",
              "      <td>1.14</td>\n",
              "      <td>0.584</td>\n",
              "      <td>0.1184</td>\n",
              "      <td>0.672</td>\n",
              "      <td>2.41</td>\n",
              "      <td>2.40</td>\n",
              "      <td>9.78</td>\n",
              "      <td>2.65</td>\n",
              "      <td>2.36</td>\n",
              "      <td>0.2438</td>\n",
              "      <td>0.1947</td>\n",
              "      <td>2.43</td>\n",
              "      <td>0.3592</td>\n",
              "      <td>0.3772</td>\n",
              "      <td>3.775660e+08</td>\n",
              "      <td>42328400000</td>\n",
              "      <td>0.30</td>\n",
              "      <td>0.1745</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-3ac38721-ef7a-47bc-a74e-f4bd66b6e9df')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-3ac38721-ef7a-47bc-a74e-f4bd66b6e9df button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-3ac38721-ef7a-47bc-a74e-f4bd66b6e9df');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 44
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "#  **Dívida Bruta / Patrimônio Líquido**\n",
        "\n",
        "* Esse indicador nos mostra quanto de dívida uma empresa tem em relação ao seu capital próprio ou patrimônio líquido. Quanto maior o percentual, mais a empresa vai depender de dívidas para crescer.\n",
        "\n",
        "* Um alto percentual de Dívida Bruta / Patrimônio Líquido é um sinal de alerta porque indica que a empresa tem gastos elevados com pagamento de juros.\n",
        "\n",
        "* O pagamento de juros deixa a empresa vulnerável a mudanças das taxas de juros do mercado, o que são muitas vezes imprevisíveis.\n",
        "\n",
        "* Dê preferência à empresas com baixo endividamento ao invés de empresas com alto endividamento.\n"
      ],
      "metadata": {
        "id": "-IJ2eqrrQvil"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Organizando as empresas em ordem crescente com base na Dívida Bruta / Patrimônio Líquido"
      ],
      "metadata": {
        "id": "u3LwbyzjTntU"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df_ordenado = df_preco_vp.sort_values(by='Dív.Brut/Patrim.')"
      ],
      "metadata": {
        "id": "YpktX14LRwH1"
      },
      "execution_count": 45,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_ordenado.reset_index(inplace=True, drop=False)"
      ],
      "metadata": {
        "id": "xEoisfR8SA4t"
      },
      "execution_count": 46,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_ordenado.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 288
        },
        "id": "OYkav1CKSSp-",
        "outputId": "5e57df4d-f200-431a-c64c-53707d1e385b"
      },
      "execution_count": 48,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   level_0  index  Papel  Cotação   P/L  P/VP    PSR  Div.Yield  P/Ativo  \\\n",
              "0      132    290  SOND6    47.00  8.19  1.78  1.209     0.1411    1.251   \n",
              "1      108    253  CEBR3    14.00  6.85  1.16  2.855     1.0804    0.684   \n",
              "2      111    257  SOND5    40.30  7.02  1.52  1.036     0.1646    1.073   \n",
              "3       89    231  ATOM3     2.73  6.24  2.66  1.929     0.0222    1.782   \n",
              "4       86    228  CEBR5    12.50  6.12  1.04  2.549     1.2100    0.610   \n",
              "\n",
              "   P/Cap.Giro  P/EBIT  P/AtivCirc.Liq  EV/EBIT  EV/EBITDA  Mrg Ebit  \\\n",
              "0        3.44    6.45            4.43     4.73       4.31    0.1873   \n",
              "1        1.80    8.20            1.84     2.26       2.08    0.3483   \n",
              "2        2.95    5.53            3.80     3.81       3.47    0.1873   \n",
              "3        2.02    6.15            2.74     4.42       4.34    0.3138   \n",
              "4        1.60    7.32            1.65     1.38       1.27    0.3483   \n",
              "\n",
              "   Mrg. Líq.  Liq. Corr.    ROIC     ROE  Liq.2meses  Patrim. Líq  \\\n",
              "0     0.1476        2.69  0.2930  0.2169     5130.88     65022000   \n",
              "1     0.5563        2.61  0.1702  0.1697    81672.10    868046000   \n",
              "2     0.1476        2.69  0.2930  0.2169    10725.70     65022000   \n",
              "3     0.3089       10.02  0.5854  0.4254   120839.00     24467000   \n",
              "4     0.5563        2.61  0.1702  0.1697    86879.30    868046000   \n",
              "\n",
              "   Dív.Brut/Patrim.  Cresc. Rec.5a  \n",
              "0               0.0         0.1694  \n",
              "1               0.0        -0.4085  \n",
              "2               0.0         0.1694  \n",
              "3               0.0         0.5807  \n",
              "4               0.0        -0.4085  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-6992bef7-b94c-45c2-ba19-237f36abcd49\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>level_0</th>\n",
              "      <th>index</th>\n",
              "      <th>Papel</th>\n",
              "      <th>Cotação</th>\n",
              "      <th>P/L</th>\n",
              "      <th>P/VP</th>\n",
              "      <th>PSR</th>\n",
              "      <th>Div.Yield</th>\n",
              "      <th>P/Ativo</th>\n",
              "      <th>P/Cap.Giro</th>\n",
              "      <th>P/EBIT</th>\n",
              "      <th>P/AtivCirc.Liq</th>\n",
              "      <th>EV/EBIT</th>\n",
              "      <th>EV/EBITDA</th>\n",
              "      <th>Mrg Ebit</th>\n",
              "      <th>Mrg. Líq.</th>\n",
              "      <th>Liq. Corr.</th>\n",
              "      <th>ROIC</th>\n",
              "      <th>ROE</th>\n",
              "      <th>Liq.2meses</th>\n",
              "      <th>Patrim. Líq</th>\n",
              "      <th>Dív.Brut/Patrim.</th>\n",
              "      <th>Cresc. Rec.5a</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>132</td>\n",
              "      <td>290</td>\n",
              "      <td>SOND6</td>\n",
              "      <td>47.00</td>\n",
              "      <td>8.19</td>\n",
              "      <td>1.78</td>\n",
              "      <td>1.209</td>\n",
              "      <td>0.1411</td>\n",
              "      <td>1.251</td>\n",
              "      <td>3.44</td>\n",
              "      <td>6.45</td>\n",
              "      <td>4.43</td>\n",
              "      <td>4.73</td>\n",
              "      <td>4.31</td>\n",
              "      <td>0.1873</td>\n",
              "      <td>0.1476</td>\n",
              "      <td>2.69</td>\n",
              "      <td>0.2930</td>\n",
              "      <td>0.2169</td>\n",
              "      <td>5130.88</td>\n",
              "      <td>65022000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.1694</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>108</td>\n",
              "      <td>253</td>\n",
              "      <td>CEBR3</td>\n",
              "      <td>14.00</td>\n",
              "      <td>6.85</td>\n",
              "      <td>1.16</td>\n",
              "      <td>2.855</td>\n",
              "      <td>1.0804</td>\n",
              "      <td>0.684</td>\n",
              "      <td>1.80</td>\n",
              "      <td>8.20</td>\n",
              "      <td>1.84</td>\n",
              "      <td>2.26</td>\n",
              "      <td>2.08</td>\n",
              "      <td>0.3483</td>\n",
              "      <td>0.5563</td>\n",
              "      <td>2.61</td>\n",
              "      <td>0.1702</td>\n",
              "      <td>0.1697</td>\n",
              "      <td>81672.10</td>\n",
              "      <td>868046000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>-0.4085</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>111</td>\n",
              "      <td>257</td>\n",
              "      <td>SOND5</td>\n",
              "      <td>40.30</td>\n",
              "      <td>7.02</td>\n",
              "      <td>1.52</td>\n",
              "      <td>1.036</td>\n",
              "      <td>0.1646</td>\n",
              "      <td>1.073</td>\n",
              "      <td>2.95</td>\n",
              "      <td>5.53</td>\n",
              "      <td>3.80</td>\n",
              "      <td>3.81</td>\n",
              "      <td>3.47</td>\n",
              "      <td>0.1873</td>\n",
              "      <td>0.1476</td>\n",
              "      <td>2.69</td>\n",
              "      <td>0.2930</td>\n",
              "      <td>0.2169</td>\n",
              "      <td>10725.70</td>\n",
              "      <td>65022000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.1694</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>89</td>\n",
              "      <td>231</td>\n",
              "      <td>ATOM3</td>\n",
              "      <td>2.73</td>\n",
              "      <td>6.24</td>\n",
              "      <td>2.66</td>\n",
              "      <td>1.929</td>\n",
              "      <td>0.0222</td>\n",
              "      <td>1.782</td>\n",
              "      <td>2.02</td>\n",
              "      <td>6.15</td>\n",
              "      <td>2.74</td>\n",
              "      <td>4.42</td>\n",
              "      <td>4.34</td>\n",
              "      <td>0.3138</td>\n",
              "      <td>0.3089</td>\n",
              "      <td>10.02</td>\n",
              "      <td>0.5854</td>\n",
              "      <td>0.4254</td>\n",
              "      <td>120839.00</td>\n",
              "      <td>24467000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.5807</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>86</td>\n",
              "      <td>228</td>\n",
              "      <td>CEBR5</td>\n",
              "      <td>12.50</td>\n",
              "      <td>6.12</td>\n",
              "      <td>1.04</td>\n",
              "      <td>2.549</td>\n",
              "      <td>1.2100</td>\n",
              "      <td>0.610</td>\n",
              "      <td>1.60</td>\n",
              "      <td>7.32</td>\n",
              "      <td>1.65</td>\n",
              "      <td>1.38</td>\n",
              "      <td>1.27</td>\n",
              "      <td>0.3483</td>\n",
              "      <td>0.5563</td>\n",
              "      <td>2.61</td>\n",
              "      <td>0.1702</td>\n",
              "      <td>0.1697</td>\n",
              "      <td>86879.30</td>\n",
              "      <td>868046000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>-0.4085</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-6992bef7-b94c-45c2-ba19-237f36abcd49')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-6992bef7-b94c-45c2-ba19-237f36abcd49 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-6992bef7-b94c-45c2-ba19-237f36abcd49');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 48
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Após aplicar filtro restaram apenas 190 empresas."
      ],
      "metadata": {
        "id": "db_IFqOpFiPs"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df_preco_vp.shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "fXs8l6_AVUJP",
        "outputId": "eb02856b-5114-4a7e-d9ef-439c240ebf2c"
      },
      "execution_count": 49,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(190, 22)"
            ]
          },
          "metadata": {},
          "execution_count": 49
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Filtrar as empresas que tem o P/VP abaixo de 1.50, ou seja, próximo do seu valor patrimonial."
      ],
      "metadata": {
        "id": "kad5O_nSFn9y"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "filtro4 = df_preco_vp['P/VP'] < 1.50"
      ],
      "metadata": {
        "id": "iQ1yYqSwXjE8"
      },
      "execution_count": 83,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_preco_vp2 = df_preco_vp[filtro4]"
      ],
      "metadata": {
        "id": "9vemY-oHXohx"
      },
      "execution_count": 84,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_preco_vp2.reset_index(inplace=True, drop=False)"
      ],
      "metadata": {
        "id": "TTSOvFwCE5oq"
      },
      "execution_count": 85,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_preco_vp2.head(56)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "vKXgUtn2D6xJ",
        "outputId": "f57c0beb-161b-424a-90f7-5457aef0573d"
      },
      "execution_count": 114,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "    level_0  index   Papel  Cotação     P/L  P/VP     PSR  Div.Yield  P/Ativo  \\\n",
              "0        14    133   GGBR4    27.96    3.01  1.14   0.584     0.1184    0.672   \n",
              "1        15    134   PETR4    34.83    3.03  1.05   0.894     0.2240    0.455   \n",
              "2        19    140   ETER3    13.10    3.20  1.34   0.727     0.0485    0.759   \n",
              "3        20    141   CSNA3    19.84    3.20  1.20   0.551     0.1129    0.350   \n",
              "4        23    145   PETR3    37.67    3.27  1.13   0.967     0.2071    0.492   \n",
              "5        34    157   ENAT3    19.79    3.86  1.32   2.334     0.0863    0.861   \n",
              "6        37    163   RAPT3     8.94    4.24  1.12   0.306     0.0728    0.265   \n",
              "7        39    165   ROMI3    13.10    4.50  1.01   0.664     0.0685    0.499   \n",
              "8        42    168   PLPL3     2.43    4.63  1.49   0.389     0.0663    0.360   \n",
              "9        44    172   RAPT4    10.25    4.86  1.29   0.351     0.0635    0.304   \n",
              "10       47    177   JHSF3     7.07    4.91  1.04   2.305     0.0492    0.560   \n",
              "11       49    179   PEAB3    60.00    4.94  1.14  24.390     0.2093    0.980   \n",
              "12       50    180   AGRO3    30.74    4.96  1.27   1.634     0.7412    0.901   \n",
              "13       55    185   CEEB3    36.00    5.10  1.44   0.637     0.2385    0.377   \n",
              "14       56    186   EALT3     9.40    5.11  1.12   0.486     0.1215    0.423   \n",
              "15       58    188   CRPG5    37.51    5.20  1.24   1.162     0.1438    0.962   \n",
              "16       59    189   CMIG4    11.33    5.21  1.21   0.725     0.0887    0.488   \n",
              "17       66    197   CRPG6    39.50    5.47  1.31   1.223     0.1366    1.013   \n",
              "18       69    200   TRPL4    24.94    5.52  1.10   2.830     0.0797    0.548   \n",
              "19       74    208   ENBR3    21.76    5.78  1.09   0.666     0.1008    0.346   \n",
              "20       77    211   MTSA4    40.00    5.87  1.07   0.541     0.0557    0.750   \n",
              "21       82    222   CAML3     7.98    6.01  1.00   0.319     0.0337    0.362   \n",
              "22       83    224   ITSA4     9.37    6.03  1.26   9.698     0.0566    0.963   \n",
              "23       84    225   PEAB4    73.50    6.05  1.39  29.878     0.1879    1.200   \n",
              "24       86    228   CEBR5    12.50    6.12  1.04   2.549     1.2100    0.610   \n",
              "25       90    232   ITSA3     9.71    6.25  1.31  10.050     0.0546    0.998   \n",
              "26       93    236   POSI3     7.74    6.33  1.00   0.295     0.0440    0.265   \n",
              "27       96    239   ALUP4     8.89    6.39  1.10   1.591     0.0461    0.294   \n",
              "28       97    240   CEBR6    13.10    6.41  1.09   2.672     1.2700    0.640   \n",
              "29       98    241  ALUP11    26.80    6.42  1.11   1.598     0.0459    0.296   \n",
              "30       99    242   ALUP3     8.96    6.44  1.11   1.603     0.0458    0.297   \n",
              "31      100    243   JSLG3     5.94    6.46  1.26   0.360     0.0632    0.240   \n",
              "32      103    246   UCAS3     3.24    6.61  1.20   0.903     0.0333    0.682   \n",
              "33      108    253   CEBR3    14.00    6.85  1.16   2.855     1.0804    0.684   \n",
              "34      109    255   TRPL3    31.19    6.90  1.38   3.539     0.0637    0.685   \n",
              "35      112    258   ESPA3     3.27    7.03  1.10   1.068     0.0250    0.364   \n",
              "36      124    276   COCE5    50.46    7.66  1.10   0.457     0.0334    0.335   \n",
              "37      145    308   PSSA3    20.18    9.16  1.40   0.586     0.0462    0.307   \n",
              "38      149    313   TGMA3    15.06    9.33  1.42   0.980     0.0620    0.966   \n",
              "39      165    335   TIMS3    13.70   10.75  1.31   1.798     0.0375    0.676   \n",
              "40      166    336   BALM3    14.42   10.79  1.14   1.049     0.0174    0.630   \n",
              "41      167    338   TUPY3    22.32   10.91  1.21   0.407     0.0194    0.463   \n",
              "42      171    343   SBSP3    45.96   11.28  1.21   1.596     0.0205    0.581   \n",
              "43      183    361   UGPA3    13.63   12.98  1.44   0.130     0.0272    0.404   \n",
              "44      184    362   PRNR3     6.84   13.05  1.13   0.550     0.0137    0.648   \n",
              "45      189    369   VIVT3    50.06   13.87  1.20   1.885     0.0736    0.721   \n",
              "46      193    374   MDIA3    22.30   14.33  1.20   0.920     0.0873    0.758   \n",
              "47      198    380   BMOB3    13.69   15.09  1.22   1.546     0.0148    0.884   \n",
              "48      224    416   IGTI3     2.59   23.70  1.41   5.222     0.0115    0.661   \n",
              "49      228    424   SOMA3    11.01   26.38  1.20   2.500     0.0082    0.843   \n",
              "50      237    438   SULA4     8.28   34.91  1.30   0.512     0.0090    0.360   \n",
              "51      239    440  SULA11    25.19   35.40  1.32   0.519     0.0089    0.365   \n",
              "52      240    441   SULA3     8.59   36.21  1.35   0.531     0.0087    0.374   \n",
              "53      244    446   NGRD3     2.29   44.75  1.19   2.167     0.0065    0.739   \n",
              "54      255    462   AURE3    14.18  339.14  1.11   4.408     0.0071    0.498   \n",
              "\n",
              "    P/Cap.Giro  P/EBIT  P/AtivCirc.Liq  EV/EBIT  EV/EBITDA  Mrg Ebit  \\\n",
              "0         2.41    2.40            9.78     2.65       2.36    0.2438   \n",
              "1         6.56    2.06           -1.25     2.93       2.21    0.4333   \n",
              "2         1.44    3.10            2.54     2.33       2.19    0.2345   \n",
              "3         2.09    1.48           -1.44     2.33       2.05    0.3733   \n",
              "4         7.09    2.23           -1.36     3.09       2.34    0.4333   \n",
              "5         2.84    7.00            6.97     4.61       2.14    0.3336   \n",
              "6         0.92    2.30           -4.10     4.60       3.90    0.1331   \n",
              "7         1.65    4.55            5.49     6.55       5.41    0.1461   \n",
              "8         0.51    1.69            2.73     2.15       2.04    0.2303   \n",
              "9         1.06    2.64           -4.71     4.94       4.18    0.1331   \n",
              "10        4.01    4.28           -2.48     5.52       5.28    0.5380   \n",
              "11        2.53  -43.68            3.38   -28.12     -34.14   -0.5584   \n",
              "12        2.21    4.09            4.11     4.18       3.66    0.3992   \n",
              "13        6.95    2.80           -0.76     5.97       4.95    0.2279   \n",
              "14       25.43    4.29           -1.78     6.39       4.92    0.1134   \n",
              "15        2.06    5.31            2.60     4.65       4.00    0.2189   \n",
              "16        8.66    4.04           -1.40     5.25       4.46    0.1795   \n",
              "17        2.17    5.59            2.74     4.93       4.24    0.2189   \n",
              "18        5.82    4.08           -1.54     5.72       5.69    0.6932   \n",
              "19        3.78    3.48           -0.96     6.18       5.10    0.1914   \n",
              "20        1.49    4.44            1.56     4.22       3.80    0.1217   \n",
              "21        1.00    5.45          -12.89     8.86       6.67    0.0585   \n",
              "22       23.56   58.81          -10.94    62.29      40.86    0.1649   \n",
              "23        3.10  -53.51            4.15   -37.95     -46.07   -0.5584   \n",
              "24        1.60    7.32            1.65     1.38       1.27    0.3483   \n",
              "25       24.41   60.95          -11.34    64.42      42.26    0.1649   \n",
              "26        0.77    4.15            2.32     6.61       5.66    0.0711   \n",
              "27        3.95    2.11           -0.69     4.27       4.11    0.7528   \n",
              "28        1.68    7.67            1.73     1.73       1.60    0.3483   \n",
              "29        3.97    2.12           -0.69     4.28       4.12    0.7528   \n",
              "30        3.98    2.13           -0.70     4.29       4.12    0.7528   \n",
              "31        1.28    4.21           -0.52    12.41       7.65    0.0855   \n",
              "32        7.07    8.12           17.60     6.34       4.64    0.1113   \n",
              "33        1.80    8.20            1.84     2.26       2.08    0.3483   \n",
              "34        7.28    5.11           -1.93     6.75       6.71    0.6932   \n",
              "35        4.15    9.36           -1.28    18.56      10.19    0.1141   \n",
              "36       -6.79    3.02           -0.85     5.96       4.73    0.1513   \n",
              "37        5.92    0.72           -2.43     0.21       0.21    0.8112   \n",
              "38        3.35    8.98            6.02     8.77       7.31    0.1091   \n",
              "39        6.82    9.81           -3.29     8.41       3.14    0.1832   \n",
              "40        1.50   18.37            2.48    15.72      10.86    0.0571   \n",
              "41        1.35    4.75          276.76     6.81       4.39    0.0858   \n",
              "42       17.60    7.59           -1.48    11.03       7.09    0.2102   \n",
              "43        1.59    9.83           -4.23    18.84      12.27    0.0132   \n",
              "44        3.10    8.69            7.17     9.01       5.25    0.0633   \n",
              "45    -1697.94   16.58           -3.41    18.39       5.39    0.1137   \n",
              "46        2.97   15.23           23.22    16.86      10.54    0.0605   \n",
              "47        2.17   14.02            2.43     8.09       5.43    0.1103   \n",
              "48        2.73   12.37           -3.01    16.23      11.55    0.4223   \n",
              "49        5.38   27.91         -132.96    30.79      20.05    0.0896   \n",
              "50        0.96  -21.20           -7.53     7.57      10.95   -0.0241   \n",
              "51        0.98  -21.50           -7.64     7.27      10.52   -0.0241   \n",
              "52        1.00  -22.00           -7.81     6.77       9.80   -0.0241   \n",
              "53        2.36   26.79            7.52    16.45       7.92    0.0809   \n",
              "54        5.98   11.80           -1.39    13.19       8.88    0.3734   \n",
              "\n",
              "    Mrg. Líq.  Liq. Corr.    ROIC     ROE    Liq.2meses   Patrim. Líq  \\\n",
              "0      0.1947        2.43  0.3592  0.3772  3.775660e+08   42328400000   \n",
              "1      0.2967        1.53  0.2494  0.3456  2.430700e+09  434194000000   \n",
              "2      0.2277        3.57  0.3364  0.4182  1.731030e+07     605502000   \n",
              "3      0.1939        1.65  0.3334  0.3759  2.360060e+08   21883300000   \n",
              "4      0.2967        1.53  0.2494  0.3456  5.765990e+08  434194000000   \n",
              "5      0.6044        2.79  0.2270  0.3418  5.351210e+07    3984900000   \n",
              "6      0.0909        1.83  0.1596  0.2644  2.437300e+05    2624880000   \n",
              "7      0.1479        2.03  0.1302  0.2250  6.101240e+06     948928000   \n",
              "8      0.0840        4.90  0.2871  0.3225  2.512860e+06     332093000   \n",
              "9      0.0909        1.83  0.1596  0.2644  2.542270e+07    2624880000   \n",
              "10     0.4589        2.57  0.1417  0.2127  3.024490e+07    4599010000   \n",
              "11     4.9435       10.78 -0.0362  0.2298  2.160930e+03     679035000   \n",
              "12     0.3293        4.91  0.2785  0.2569  2.691150e+07    2469380000   \n",
              "13     0.1249        1.29  0.1457  0.2822  3.940730e+04    6556000000   \n",
              "14     0.0951        1.05  0.1102  0.2192  5.725670e+03     188886000   \n",
              "15     0.2234        4.62  0.2176  0.2388  5.038450e+05     876876000   \n",
              "16     0.1392        1.30  0.1329  0.2315  1.377750e+08   20667000000   \n",
              "17     0.2234        4.62  0.2176  0.2388  1.882250e+04     876876000   \n",
              "18     0.5178        3.29  0.1401  0.2000  4.084070e+07   14896500000   \n",
              "19     0.1266        1.46  0.1121  0.1893  7.636490e+07   11555100000   \n",
              "20     0.0922        2.81  0.2113  0.1818  8.513400e+04     329552000   \n",
              "21     0.0531        2.46  0.1014  0.1660  1.079400e+07    2878800000   \n",
              "22     1.7384        1.60  0.0177  0.2092  2.409270e+08   65555000000   \n",
              "23     4.9435       10.78 -0.0362  0.2298  3.582720e+03     679035000   \n",
              "24     0.5563        2.61  0.1702  0.1697  8.687930e+04     868046000   \n",
              "25     1.7384        1.60  0.0177  0.2092  1.106280e+06   65555000000   \n",
              "26     0.0472        1.69  0.1075  0.1574  2.172860e+07    1101320000   \n",
              "27     0.4479        1.78  0.1535  0.1726  1.208390e+05    7084130000   \n",
              "28     0.5563        2.61  0.1702  0.1697  5.674730e+05     868046000   \n",
              "29     0.4479        1.78  0.1535  0.1726  3.004320e+07    7084130000   \n",
              "30     0.4479        1.78  0.1535  0.1726  1.041350e+05    7084130000   \n",
              "31     0.0558        2.19  0.0667  0.1945  3.426710e+06    1354950000   \n",
              "32     0.1365        1.26  0.1075  0.1821  1.883350e+05     177759000   \n",
              "33     0.5563        2.61  0.1702  0.1697  8.167210e+04     868046000   \n",
              "34     0.5178        3.29  0.1401  0.2000  4.184870e+04   14896500000   \n",
              "35     0.1489        1.30  0.0418  0.1570  1.977090e+07     723328000   \n",
              "36     0.0596        0.86  0.1259  0.1431  8.017280e+05    3583410000   \n",
              "37     0.0640        1.09  0.5429  0.1532  3.985590e+07    9296640000   \n",
              "38     0.1049        2.51  0.1420  0.1523  3.763370e+06     699442000   \n",
              "39     0.1673        1.56  0.0891  0.1218  9.037040e+07   25338000000   \n",
              "40     0.0678        2.56  0.0443  0.1056  4.563300e+02     124110000   \n",
              "41     0.0369        2.24  0.1379  0.1106  2.510950e+07    2666340000   \n",
              "42     0.1415        1.34  0.0820  0.1075  1.745040e+08   25907400000   \n",
              "43     0.0103        1.71  0.0531  0.1110  1.086530e+08   10542200000   \n",
              "44     0.0429        1.68  0.0940  0.0870  1.040570e+06     234498000   \n",
              "45     0.1356        1.00  0.0496  0.0864  1.194590e+08   70102900000   \n",
              "46     0.0643        2.77  0.0591  0.0836  3.878600e+07    6313140000   \n",
              "47     0.1024        2.77  0.1175  0.0808  8.657860e+06    1021170000   \n",
              "48     0.3173        4.63  0.0725  0.0593  7.218350e+05    3407800000   \n",
              "49     0.0948        2.14  0.0335  0.0457  9.063970e+07    7173290000   \n",
              "50     0.0146        2.24 -0.0427  0.0372  1.351270e+05    8150850000   \n",
              "51     0.0146        2.24 -0.0427  0.0372  1.329400e+08    8150850000   \n",
              "52     0.0146        2.24 -0.0427  0.0372  7.011810e+04    8150850000   \n",
              "53     0.0476        2.88  0.0469  0.0267  3.428840e+06     457808000   \n",
              "54     0.0838        1.77  0.0483  0.0033  4.441070e+07   12820300000   \n",
              "\n",
              "    Dív.Brut/Patrim.  Cresc. Rec.5a  \n",
              "0               0.30         0.1745  \n",
              "1               0.64         0.0936  \n",
              "2               0.06         0.1740  \n",
              "3               1.41         0.2526  \n",
              "4               0.64         0.0936  \n",
              "5               0.15         0.3361  \n",
              "6               1.85         0.2794  \n",
              "7               0.61         0.2109  \n",
              "8               1.24         0.2553  \n",
              "9               1.85         0.2794  \n",
              "10              0.45         0.5690  \n",
              "11              0.03        -0.4614  \n",
              "12              0.26         0.5231  \n",
              "13              1.75         0.1446  \n",
              "14              0.60         0.1681  \n",
              "15              0.00         0.1208  \n",
              "16              0.48         0.1086  \n",
              "17              0.00         0.1208  \n",
              "18              0.52         0.1835  \n",
              "19              1.08         0.0896  \n",
              "20              0.12         0.2611  \n",
              "21              1.19         0.1938  \n",
              "22              0.15         0.1356  \n",
              "23              0.03        -0.4614  \n",
              "24              0.00        -0.4085  \n",
              "25              0.15         0.1356  \n",
              "26              1.16         0.1776  \n",
              "27              1.41         0.3818  \n",
              "28              0.00        -0.4085  \n",
              "29              1.41         0.3818  \n",
              "30              1.41         0.3818  \n",
              "31              2.95        -0.2395  \n",
              "32              0.08         0.1060  \n",
              "33              0.00        -0.4085  \n",
              "34              0.52         0.1835  \n",
              "35              1.27         0.3641  \n",
              "36              1.13         0.1461  \n",
              "37              0.00         0.0594  \n",
              "38              0.27        -0.0495  \n",
              "39              0.13         0.0296  \n",
              "40              0.16         0.0713  \n",
              "41              0.88         0.1431  \n",
              "42              0.68         0.0728  \n",
              "43              1.63         0.0657  \n",
              "44              0.33         0.0995  \n",
              "45              0.22         0.0040  \n",
              "46              0.26         0.1027  \n",
              "47              0.00         3.1003  \n",
              "48              0.99         0.0514  \n",
              "49              0.18         1.6523  \n",
              "50              0.41         0.0166  \n",
              "51              0.41         0.0166  \n",
              "52              0.41         0.0166  \n",
              "53              0.18         0.1448  \n",
              "54              0.38         0.0000  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-f9386be7-9136-4a4a-b11d-a99fc3f7713e\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>level_0</th>\n",
              "      <th>index</th>\n",
              "      <th>Papel</th>\n",
              "      <th>Cotação</th>\n",
              "      <th>P/L</th>\n",
              "      <th>P/VP</th>\n",
              "      <th>PSR</th>\n",
              "      <th>Div.Yield</th>\n",
              "      <th>P/Ativo</th>\n",
              "      <th>P/Cap.Giro</th>\n",
              "      <th>P/EBIT</th>\n",
              "      <th>P/AtivCirc.Liq</th>\n",
              "      <th>EV/EBIT</th>\n",
              "      <th>EV/EBITDA</th>\n",
              "      <th>Mrg Ebit</th>\n",
              "      <th>Mrg. Líq.</th>\n",
              "      <th>Liq. Corr.</th>\n",
              "      <th>ROIC</th>\n",
              "      <th>ROE</th>\n",
              "      <th>Liq.2meses</th>\n",
              "      <th>Patrim. Líq</th>\n",
              "      <th>Dív.Brut/Patrim.</th>\n",
              "      <th>Cresc. Rec.5a</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>14</td>\n",
              "      <td>133</td>\n",
              "      <td>GGBR4</td>\n",
              "      <td>27.96</td>\n",
              "      <td>3.01</td>\n",
              "      <td>1.14</td>\n",
              "      <td>0.584</td>\n",
              "      <td>0.1184</td>\n",
              "      <td>0.672</td>\n",
              "      <td>2.41</td>\n",
              "      <td>2.40</td>\n",
              "      <td>9.78</td>\n",
              "      <td>2.65</td>\n",
              "      <td>2.36</td>\n",
              "      <td>0.2438</td>\n",
              "      <td>0.1947</td>\n",
              "      <td>2.43</td>\n",
              "      <td>0.3592</td>\n",
              "      <td>0.3772</td>\n",
              "      <td>3.775660e+08</td>\n",
              "      <td>42328400000</td>\n",
              "      <td>0.30</td>\n",
              "      <td>0.1745</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>15</td>\n",
              "      <td>134</td>\n",
              "      <td>PETR4</td>\n",
              "      <td>34.83</td>\n",
              "      <td>3.03</td>\n",
              "      <td>1.05</td>\n",
              "      <td>0.894</td>\n",
              "      <td>0.2240</td>\n",
              "      <td>0.455</td>\n",
              "      <td>6.56</td>\n",
              "      <td>2.06</td>\n",
              "      <td>-1.25</td>\n",
              "      <td>2.93</td>\n",
              "      <td>2.21</td>\n",
              "      <td>0.4333</td>\n",
              "      <td>0.2967</td>\n",
              "      <td>1.53</td>\n",
              "      <td>0.2494</td>\n",
              "      <td>0.3456</td>\n",
              "      <td>2.430700e+09</td>\n",
              "      <td>434194000000</td>\n",
              "      <td>0.64</td>\n",
              "      <td>0.0936</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>19</td>\n",
              "      <td>140</td>\n",
              "      <td>ETER3</td>\n",
              "      <td>13.10</td>\n",
              "      <td>3.20</td>\n",
              "      <td>1.34</td>\n",
              "      <td>0.727</td>\n",
              "      <td>0.0485</td>\n",
              "      <td>0.759</td>\n",
              "      <td>1.44</td>\n",
              "      <td>3.10</td>\n",
              "      <td>2.54</td>\n",
              "      <td>2.33</td>\n",
              "      <td>2.19</td>\n",
              "      <td>0.2345</td>\n",
              "      <td>0.2277</td>\n",
              "      <td>3.57</td>\n",
              "      <td>0.3364</td>\n",
              "      <td>0.4182</td>\n",
              "      <td>1.731030e+07</td>\n",
              "      <td>605502000</td>\n",
              "      <td>0.06</td>\n",
              "      <td>0.1740</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>20</td>\n",
              "      <td>141</td>\n",
              "      <td>CSNA3</td>\n",
              "      <td>19.84</td>\n",
              "      <td>3.20</td>\n",
              "      <td>1.20</td>\n",
              "      <td>0.551</td>\n",
              "      <td>0.1129</td>\n",
              "      <td>0.350</td>\n",
              "      <td>2.09</td>\n",
              "      <td>1.48</td>\n",
              "      <td>-1.44</td>\n",
              "      <td>2.33</td>\n",
              "      <td>2.05</td>\n",
              "      <td>0.3733</td>\n",
              "      <td>0.1939</td>\n",
              "      <td>1.65</td>\n",
              "      <td>0.3334</td>\n",
              "      <td>0.3759</td>\n",
              "      <td>2.360060e+08</td>\n",
              "      <td>21883300000</td>\n",
              "      <td>1.41</td>\n",
              "      <td>0.2526</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>23</td>\n",
              "      <td>145</td>\n",
              "      <td>PETR3</td>\n",
              "      <td>37.67</td>\n",
              "      <td>3.27</td>\n",
              "      <td>1.13</td>\n",
              "      <td>0.967</td>\n",
              "      <td>0.2071</td>\n",
              "      <td>0.492</td>\n",
              "      <td>7.09</td>\n",
              "      <td>2.23</td>\n",
              "      <td>-1.36</td>\n",
              "      <td>3.09</td>\n",
              "      <td>2.34</td>\n",
              "      <td>0.4333</td>\n",
              "      <td>0.2967</td>\n",
              "      <td>1.53</td>\n",
              "      <td>0.2494</td>\n",
              "      <td>0.3456</td>\n",
              "      <td>5.765990e+08</td>\n",
              "      <td>434194000000</td>\n",
              "      <td>0.64</td>\n",
              "      <td>0.0936</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>34</td>\n",
              "      <td>157</td>\n",
              "      <td>ENAT3</td>\n",
              "      <td>19.79</td>\n",
              "      <td>3.86</td>\n",
              "      <td>1.32</td>\n",
              "      <td>2.334</td>\n",
              "      <td>0.0863</td>\n",
              "      <td>0.861</td>\n",
              "      <td>2.84</td>\n",
              "      <td>7.00</td>\n",
              "      <td>6.97</td>\n",
              "      <td>4.61</td>\n",
              "      <td>2.14</td>\n",
              "      <td>0.3336</td>\n",
              "      <td>0.6044</td>\n",
              "      <td>2.79</td>\n",
              "      <td>0.2270</td>\n",
              "      <td>0.3418</td>\n",
              "      <td>5.351210e+07</td>\n",
              "      <td>3984900000</td>\n",
              "      <td>0.15</td>\n",
              "      <td>0.3361</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>37</td>\n",
              "      <td>163</td>\n",
              "      <td>RAPT3</td>\n",
              "      <td>8.94</td>\n",
              "      <td>4.24</td>\n",
              "      <td>1.12</td>\n",
              "      <td>0.306</td>\n",
              "      <td>0.0728</td>\n",
              "      <td>0.265</td>\n",
              "      <td>0.92</td>\n",
              "      <td>2.30</td>\n",
              "      <td>-4.10</td>\n",
              "      <td>4.60</td>\n",
              "      <td>3.90</td>\n",
              "      <td>0.1331</td>\n",
              "      <td>0.0909</td>\n",
              "      <td>1.83</td>\n",
              "      <td>0.1596</td>\n",
              "      <td>0.2644</td>\n",
              "      <td>2.437300e+05</td>\n",
              "      <td>2624880000</td>\n",
              "      <td>1.85</td>\n",
              "      <td>0.2794</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>39</td>\n",
              "      <td>165</td>\n",
              "      <td>ROMI3</td>\n",
              "      <td>13.10</td>\n",
              "      <td>4.50</td>\n",
              "      <td>1.01</td>\n",
              "      <td>0.664</td>\n",
              "      <td>0.0685</td>\n",
              "      <td>0.499</td>\n",
              "      <td>1.65</td>\n",
              "      <td>4.55</td>\n",
              "      <td>5.49</td>\n",
              "      <td>6.55</td>\n",
              "      <td>5.41</td>\n",
              "      <td>0.1461</td>\n",
              "      <td>0.1479</td>\n",
              "      <td>2.03</td>\n",
              "      <td>0.1302</td>\n",
              "      <td>0.2250</td>\n",
              "      <td>6.101240e+06</td>\n",
              "      <td>948928000</td>\n",
              "      <td>0.61</td>\n",
              "      <td>0.2109</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>42</td>\n",
              "      <td>168</td>\n",
              "      <td>PLPL3</td>\n",
              "      <td>2.43</td>\n",
              "      <td>4.63</td>\n",
              "      <td>1.49</td>\n",
              "      <td>0.389</td>\n",
              "      <td>0.0663</td>\n",
              "      <td>0.360</td>\n",
              "      <td>0.51</td>\n",
              "      <td>1.69</td>\n",
              "      <td>2.73</td>\n",
              "      <td>2.15</td>\n",
              "      <td>2.04</td>\n",
              "      <td>0.2303</td>\n",
              "      <td>0.0840</td>\n",
              "      <td>4.90</td>\n",
              "      <td>0.2871</td>\n",
              "      <td>0.3225</td>\n",
              "      <td>2.512860e+06</td>\n",
              "      <td>332093000</td>\n",
              "      <td>1.24</td>\n",
              "      <td>0.2553</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>44</td>\n",
              "      <td>172</td>\n",
              "      <td>RAPT4</td>\n",
              "      <td>10.25</td>\n",
              "      <td>4.86</td>\n",
              "      <td>1.29</td>\n",
              "      <td>0.351</td>\n",
              "      <td>0.0635</td>\n",
              "      <td>0.304</td>\n",
              "      <td>1.06</td>\n",
              "      <td>2.64</td>\n",
              "      <td>-4.71</td>\n",
              "      <td>4.94</td>\n",
              "      <td>4.18</td>\n",
              "      <td>0.1331</td>\n",
              "      <td>0.0909</td>\n",
              "      <td>1.83</td>\n",
              "      <td>0.1596</td>\n",
              "      <td>0.2644</td>\n",
              "      <td>2.542270e+07</td>\n",
              "      <td>2624880000</td>\n",
              "      <td>1.85</td>\n",
              "      <td>0.2794</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>47</td>\n",
              "      <td>177</td>\n",
              "      <td>JHSF3</td>\n",
              "      <td>7.07</td>\n",
              "      <td>4.91</td>\n",
              "      <td>1.04</td>\n",
              "      <td>2.305</td>\n",
              "      <td>0.0492</td>\n",
              "      <td>0.560</td>\n",
              "      <td>4.01</td>\n",
              "      <td>4.28</td>\n",
              "      <td>-2.48</td>\n",
              "      <td>5.52</td>\n",
              "      <td>5.28</td>\n",
              "      <td>0.5380</td>\n",
              "      <td>0.4589</td>\n",
              "      <td>2.57</td>\n",
              "      <td>0.1417</td>\n",
              "      <td>0.2127</td>\n",
              "      <td>3.024490e+07</td>\n",
              "      <td>4599010000</td>\n",
              "      <td>0.45</td>\n",
              "      <td>0.5690</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>49</td>\n",
              "      <td>179</td>\n",
              "      <td>PEAB3</td>\n",
              "      <td>60.00</td>\n",
              "      <td>4.94</td>\n",
              "      <td>1.14</td>\n",
              "      <td>24.390</td>\n",
              "      <td>0.2093</td>\n",
              "      <td>0.980</td>\n",
              "      <td>2.53</td>\n",
              "      <td>-43.68</td>\n",
              "      <td>3.38</td>\n",
              "      <td>-28.12</td>\n",
              "      <td>-34.14</td>\n",
              "      <td>-0.5584</td>\n",
              "      <td>4.9435</td>\n",
              "      <td>10.78</td>\n",
              "      <td>-0.0362</td>\n",
              "      <td>0.2298</td>\n",
              "      <td>2.160930e+03</td>\n",
              "      <td>679035000</td>\n",
              "      <td>0.03</td>\n",
              "      <td>-0.4614</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>50</td>\n",
              "      <td>180</td>\n",
              "      <td>AGRO3</td>\n",
              "      <td>30.74</td>\n",
              "      <td>4.96</td>\n",
              "      <td>1.27</td>\n",
              "      <td>1.634</td>\n",
              "      <td>0.7412</td>\n",
              "      <td>0.901</td>\n",
              "      <td>2.21</td>\n",
              "      <td>4.09</td>\n",
              "      <td>4.11</td>\n",
              "      <td>4.18</td>\n",
              "      <td>3.66</td>\n",
              "      <td>0.3992</td>\n",
              "      <td>0.3293</td>\n",
              "      <td>4.91</td>\n",
              "      <td>0.2785</td>\n",
              "      <td>0.2569</td>\n",
              "      <td>2.691150e+07</td>\n",
              "      <td>2469380000</td>\n",
              "      <td>0.26</td>\n",
              "      <td>0.5231</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>55</td>\n",
              "      <td>185</td>\n",
              "      <td>CEEB3</td>\n",
              "      <td>36.00</td>\n",
              "      <td>5.10</td>\n",
              "      <td>1.44</td>\n",
              "      <td>0.637</td>\n",
              "      <td>0.2385</td>\n",
              "      <td>0.377</td>\n",
              "      <td>6.95</td>\n",
              "      <td>2.80</td>\n",
              "      <td>-0.76</td>\n",
              "      <td>5.97</td>\n",
              "      <td>4.95</td>\n",
              "      <td>0.2279</td>\n",
              "      <td>0.1249</td>\n",
              "      <td>1.29</td>\n",
              "      <td>0.1457</td>\n",
              "      <td>0.2822</td>\n",
              "      <td>3.940730e+04</td>\n",
              "      <td>6556000000</td>\n",
              "      <td>1.75</td>\n",
              "      <td>0.1446</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>56</td>\n",
              "      <td>186</td>\n",
              "      <td>EALT3</td>\n",
              "      <td>9.40</td>\n",
              "      <td>5.11</td>\n",
              "      <td>1.12</td>\n",
              "      <td>0.486</td>\n",
              "      <td>0.1215</td>\n",
              "      <td>0.423</td>\n",
              "      <td>25.43</td>\n",
              "      <td>4.29</td>\n",
              "      <td>-1.78</td>\n",
              "      <td>6.39</td>\n",
              "      <td>4.92</td>\n",
              "      <td>0.1134</td>\n",
              "      <td>0.0951</td>\n",
              "      <td>1.05</td>\n",
              "      <td>0.1102</td>\n",
              "      <td>0.2192</td>\n",
              "      <td>5.725670e+03</td>\n",
              "      <td>188886000</td>\n",
              "      <td>0.60</td>\n",
              "      <td>0.1681</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>58</td>\n",
              "      <td>188</td>\n",
              "      <td>CRPG5</td>\n",
              "      <td>37.51</td>\n",
              "      <td>5.20</td>\n",
              "      <td>1.24</td>\n",
              "      <td>1.162</td>\n",
              "      <td>0.1438</td>\n",
              "      <td>0.962</td>\n",
              "      <td>2.06</td>\n",
              "      <td>5.31</td>\n",
              "      <td>2.60</td>\n",
              "      <td>4.65</td>\n",
              "      <td>4.00</td>\n",
              "      <td>0.2189</td>\n",
              "      <td>0.2234</td>\n",
              "      <td>4.62</td>\n",
              "      <td>0.2176</td>\n",
              "      <td>0.2388</td>\n",
              "      <td>5.038450e+05</td>\n",
              "      <td>876876000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.1208</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>59</td>\n",
              "      <td>189</td>\n",
              "      <td>CMIG4</td>\n",
              "      <td>11.33</td>\n",
              "      <td>5.21</td>\n",
              "      <td>1.21</td>\n",
              "      <td>0.725</td>\n",
              "      <td>0.0887</td>\n",
              "      <td>0.488</td>\n",
              "      <td>8.66</td>\n",
              "      <td>4.04</td>\n",
              "      <td>-1.40</td>\n",
              "      <td>5.25</td>\n",
              "      <td>4.46</td>\n",
              "      <td>0.1795</td>\n",
              "      <td>0.1392</td>\n",
              "      <td>1.30</td>\n",
              "      <td>0.1329</td>\n",
              "      <td>0.2315</td>\n",
              "      <td>1.377750e+08</td>\n",
              "      <td>20667000000</td>\n",
              "      <td>0.48</td>\n",
              "      <td>0.1086</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>66</td>\n",
              "      <td>197</td>\n",
              "      <td>CRPG6</td>\n",
              "      <td>39.50</td>\n",
              "      <td>5.47</td>\n",
              "      <td>1.31</td>\n",
              "      <td>1.223</td>\n",
              "      <td>0.1366</td>\n",
              "      <td>1.013</td>\n",
              "      <td>2.17</td>\n",
              "      <td>5.59</td>\n",
              "      <td>2.74</td>\n",
              "      <td>4.93</td>\n",
              "      <td>4.24</td>\n",
              "      <td>0.2189</td>\n",
              "      <td>0.2234</td>\n",
              "      <td>4.62</td>\n",
              "      <td>0.2176</td>\n",
              "      <td>0.2388</td>\n",
              "      <td>1.882250e+04</td>\n",
              "      <td>876876000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.1208</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>69</td>\n",
              "      <td>200</td>\n",
              "      <td>TRPL4</td>\n",
              "      <td>24.94</td>\n",
              "      <td>5.52</td>\n",
              "      <td>1.10</td>\n",
              "      <td>2.830</td>\n",
              "      <td>0.0797</td>\n",
              "      <td>0.548</td>\n",
              "      <td>5.82</td>\n",
              "      <td>4.08</td>\n",
              "      <td>-1.54</td>\n",
              "      <td>5.72</td>\n",
              "      <td>5.69</td>\n",
              "      <td>0.6932</td>\n",
              "      <td>0.5178</td>\n",
              "      <td>3.29</td>\n",
              "      <td>0.1401</td>\n",
              "      <td>0.2000</td>\n",
              "      <td>4.084070e+07</td>\n",
              "      <td>14896500000</td>\n",
              "      <td>0.52</td>\n",
              "      <td>0.1835</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>74</td>\n",
              "      <td>208</td>\n",
              "      <td>ENBR3</td>\n",
              "      <td>21.76</td>\n",
              "      <td>5.78</td>\n",
              "      <td>1.09</td>\n",
              "      <td>0.666</td>\n",
              "      <td>0.1008</td>\n",
              "      <td>0.346</td>\n",
              "      <td>3.78</td>\n",
              "      <td>3.48</td>\n",
              "      <td>-0.96</td>\n",
              "      <td>6.18</td>\n",
              "      <td>5.10</td>\n",
              "      <td>0.1914</td>\n",
              "      <td>0.1266</td>\n",
              "      <td>1.46</td>\n",
              "      <td>0.1121</td>\n",
              "      <td>0.1893</td>\n",
              "      <td>7.636490e+07</td>\n",
              "      <td>11555100000</td>\n",
              "      <td>1.08</td>\n",
              "      <td>0.0896</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>77</td>\n",
              "      <td>211</td>\n",
              "      <td>MTSA4</td>\n",
              "      <td>40.00</td>\n",
              "      <td>5.87</td>\n",
              "      <td>1.07</td>\n",
              "      <td>0.541</td>\n",
              "      <td>0.0557</td>\n",
              "      <td>0.750</td>\n",
              "      <td>1.49</td>\n",
              "      <td>4.44</td>\n",
              "      <td>1.56</td>\n",
              "      <td>4.22</td>\n",
              "      <td>3.80</td>\n",
              "      <td>0.1217</td>\n",
              "      <td>0.0922</td>\n",
              "      <td>2.81</td>\n",
              "      <td>0.2113</td>\n",
              "      <td>0.1818</td>\n",
              "      <td>8.513400e+04</td>\n",
              "      <td>329552000</td>\n",
              "      <td>0.12</td>\n",
              "      <td>0.2611</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>82</td>\n",
              "      <td>222</td>\n",
              "      <td>CAML3</td>\n",
              "      <td>7.98</td>\n",
              "      <td>6.01</td>\n",
              "      <td>1.00</td>\n",
              "      <td>0.319</td>\n",
              "      <td>0.0337</td>\n",
              "      <td>0.362</td>\n",
              "      <td>1.00</td>\n",
              "      <td>5.45</td>\n",
              "      <td>-12.89</td>\n",
              "      <td>8.86</td>\n",
              "      <td>6.67</td>\n",
              "      <td>0.0585</td>\n",
              "      <td>0.0531</td>\n",
              "      <td>2.46</td>\n",
              "      <td>0.1014</td>\n",
              "      <td>0.1660</td>\n",
              "      <td>1.079400e+07</td>\n",
              "      <td>2878800000</td>\n",
              "      <td>1.19</td>\n",
              "      <td>0.1938</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>83</td>\n",
              "      <td>224</td>\n",
              "      <td>ITSA4</td>\n",
              "      <td>9.37</td>\n",
              "      <td>6.03</td>\n",
              "      <td>1.26</td>\n",
              "      <td>9.698</td>\n",
              "      <td>0.0566</td>\n",
              "      <td>0.963</td>\n",
              "      <td>23.56</td>\n",
              "      <td>58.81</td>\n",
              "      <td>-10.94</td>\n",
              "      <td>62.29</td>\n",
              "      <td>40.86</td>\n",
              "      <td>0.1649</td>\n",
              "      <td>1.7384</td>\n",
              "      <td>1.60</td>\n",
              "      <td>0.0177</td>\n",
              "      <td>0.2092</td>\n",
              "      <td>2.409270e+08</td>\n",
              "      <td>65555000000</td>\n",
              "      <td>0.15</td>\n",
              "      <td>0.1356</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>84</td>\n",
              "      <td>225</td>\n",
              "      <td>PEAB4</td>\n",
              "      <td>73.50</td>\n",
              "      <td>6.05</td>\n",
              "      <td>1.39</td>\n",
              "      <td>29.878</td>\n",
              "      <td>0.1879</td>\n",
              "      <td>1.200</td>\n",
              "      <td>3.10</td>\n",
              "      <td>-53.51</td>\n",
              "      <td>4.15</td>\n",
              "      <td>-37.95</td>\n",
              "      <td>-46.07</td>\n",
              "      <td>-0.5584</td>\n",
              "      <td>4.9435</td>\n",
              "      <td>10.78</td>\n",
              "      <td>-0.0362</td>\n",
              "      <td>0.2298</td>\n",
              "      <td>3.582720e+03</td>\n",
              "      <td>679035000</td>\n",
              "      <td>0.03</td>\n",
              "      <td>-0.4614</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>86</td>\n",
              "      <td>228</td>\n",
              "      <td>CEBR5</td>\n",
              "      <td>12.50</td>\n",
              "      <td>6.12</td>\n",
              "      <td>1.04</td>\n",
              "      <td>2.549</td>\n",
              "      <td>1.2100</td>\n",
              "      <td>0.610</td>\n",
              "      <td>1.60</td>\n",
              "      <td>7.32</td>\n",
              "      <td>1.65</td>\n",
              "      <td>1.38</td>\n",
              "      <td>1.27</td>\n",
              "      <td>0.3483</td>\n",
              "      <td>0.5563</td>\n",
              "      <td>2.61</td>\n",
              "      <td>0.1702</td>\n",
              "      <td>0.1697</td>\n",
              "      <td>8.687930e+04</td>\n",
              "      <td>868046000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>-0.4085</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>90</td>\n",
              "      <td>232</td>\n",
              "      <td>ITSA3</td>\n",
              "      <td>9.71</td>\n",
              "      <td>6.25</td>\n",
              "      <td>1.31</td>\n",
              "      <td>10.050</td>\n",
              "      <td>0.0546</td>\n",
              "      <td>0.998</td>\n",
              "      <td>24.41</td>\n",
              "      <td>60.95</td>\n",
              "      <td>-11.34</td>\n",
              "      <td>64.42</td>\n",
              "      <td>42.26</td>\n",
              "      <td>0.1649</td>\n",
              "      <td>1.7384</td>\n",
              "      <td>1.60</td>\n",
              "      <td>0.0177</td>\n",
              "      <td>0.2092</td>\n",
              "      <td>1.106280e+06</td>\n",
              "      <td>65555000000</td>\n",
              "      <td>0.15</td>\n",
              "      <td>0.1356</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>93</td>\n",
              "      <td>236</td>\n",
              "      <td>POSI3</td>\n",
              "      <td>7.74</td>\n",
              "      <td>6.33</td>\n",
              "      <td>1.00</td>\n",
              "      <td>0.295</td>\n",
              "      <td>0.0440</td>\n",
              "      <td>0.265</td>\n",
              "      <td>0.77</td>\n",
              "      <td>4.15</td>\n",
              "      <td>2.32</td>\n",
              "      <td>6.61</td>\n",
              "      <td>5.66</td>\n",
              "      <td>0.0711</td>\n",
              "      <td>0.0472</td>\n",
              "      <td>1.69</td>\n",
              "      <td>0.1075</td>\n",
              "      <td>0.1574</td>\n",
              "      <td>2.172860e+07</td>\n",
              "      <td>1101320000</td>\n",
              "      <td>1.16</td>\n",
              "      <td>0.1776</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>96</td>\n",
              "      <td>239</td>\n",
              "      <td>ALUP4</td>\n",
              "      <td>8.89</td>\n",
              "      <td>6.39</td>\n",
              "      <td>1.10</td>\n",
              "      <td>1.591</td>\n",
              "      <td>0.0461</td>\n",
              "      <td>0.294</td>\n",
              "      <td>3.95</td>\n",
              "      <td>2.11</td>\n",
              "      <td>-0.69</td>\n",
              "      <td>4.27</td>\n",
              "      <td>4.11</td>\n",
              "      <td>0.7528</td>\n",
              "      <td>0.4479</td>\n",
              "      <td>1.78</td>\n",
              "      <td>0.1535</td>\n",
              "      <td>0.1726</td>\n",
              "      <td>1.208390e+05</td>\n",
              "      <td>7084130000</td>\n",
              "      <td>1.41</td>\n",
              "      <td>0.3818</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>97</td>\n",
              "      <td>240</td>\n",
              "      <td>CEBR6</td>\n",
              "      <td>13.10</td>\n",
              "      <td>6.41</td>\n",
              "      <td>1.09</td>\n",
              "      <td>2.672</td>\n",
              "      <td>1.2700</td>\n",
              "      <td>0.640</td>\n",
              "      <td>1.68</td>\n",
              "      <td>7.67</td>\n",
              "      <td>1.73</td>\n",
              "      <td>1.73</td>\n",
              "      <td>1.60</td>\n",
              "      <td>0.3483</td>\n",
              "      <td>0.5563</td>\n",
              "      <td>2.61</td>\n",
              "      <td>0.1702</td>\n",
              "      <td>0.1697</td>\n",
              "      <td>5.674730e+05</td>\n",
              "      <td>868046000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>-0.4085</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>98</td>\n",
              "      <td>241</td>\n",
              "      <td>ALUP11</td>\n",
              "      <td>26.80</td>\n",
              "      <td>6.42</td>\n",
              "      <td>1.11</td>\n",
              "      <td>1.598</td>\n",
              "      <td>0.0459</td>\n",
              "      <td>0.296</td>\n",
              "      <td>3.97</td>\n",
              "      <td>2.12</td>\n",
              "      <td>-0.69</td>\n",
              "      <td>4.28</td>\n",
              "      <td>4.12</td>\n",
              "      <td>0.7528</td>\n",
              "      <td>0.4479</td>\n",
              "      <td>1.78</td>\n",
              "      <td>0.1535</td>\n",
              "      <td>0.1726</td>\n",
              "      <td>3.004320e+07</td>\n",
              "      <td>7084130000</td>\n",
              "      <td>1.41</td>\n",
              "      <td>0.3818</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>99</td>\n",
              "      <td>242</td>\n",
              "      <td>ALUP3</td>\n",
              "      <td>8.96</td>\n",
              "      <td>6.44</td>\n",
              "      <td>1.11</td>\n",
              "      <td>1.603</td>\n",
              "      <td>0.0458</td>\n",
              "      <td>0.297</td>\n",
              "      <td>3.98</td>\n",
              "      <td>2.13</td>\n",
              "      <td>-0.70</td>\n",
              "      <td>4.29</td>\n",
              "      <td>4.12</td>\n",
              "      <td>0.7528</td>\n",
              "      <td>0.4479</td>\n",
              "      <td>1.78</td>\n",
              "      <td>0.1535</td>\n",
              "      <td>0.1726</td>\n",
              "      <td>1.041350e+05</td>\n",
              "      <td>7084130000</td>\n",
              "      <td>1.41</td>\n",
              "      <td>0.3818</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>100</td>\n",
              "      <td>243</td>\n",
              "      <td>JSLG3</td>\n",
              "      <td>5.94</td>\n",
              "      <td>6.46</td>\n",
              "      <td>1.26</td>\n",
              "      <td>0.360</td>\n",
              "      <td>0.0632</td>\n",
              "      <td>0.240</td>\n",
              "      <td>1.28</td>\n",
              "      <td>4.21</td>\n",
              "      <td>-0.52</td>\n",
              "      <td>12.41</td>\n",
              "      <td>7.65</td>\n",
              "      <td>0.0855</td>\n",
              "      <td>0.0558</td>\n",
              "      <td>2.19</td>\n",
              "      <td>0.0667</td>\n",
              "      <td>0.1945</td>\n",
              "      <td>3.426710e+06</td>\n",
              "      <td>1354950000</td>\n",
              "      <td>2.95</td>\n",
              "      <td>-0.2395</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>103</td>\n",
              "      <td>246</td>\n",
              "      <td>UCAS3</td>\n",
              "      <td>3.24</td>\n",
              "      <td>6.61</td>\n",
              "      <td>1.20</td>\n",
              "      <td>0.903</td>\n",
              "      <td>0.0333</td>\n",
              "      <td>0.682</td>\n",
              "      <td>7.07</td>\n",
              "      <td>8.12</td>\n",
              "      <td>17.60</td>\n",
              "      <td>6.34</td>\n",
              "      <td>4.64</td>\n",
              "      <td>0.1113</td>\n",
              "      <td>0.1365</td>\n",
              "      <td>1.26</td>\n",
              "      <td>0.1075</td>\n",
              "      <td>0.1821</td>\n",
              "      <td>1.883350e+05</td>\n",
              "      <td>177759000</td>\n",
              "      <td>0.08</td>\n",
              "      <td>0.1060</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>108</td>\n",
              "      <td>253</td>\n",
              "      <td>CEBR3</td>\n",
              "      <td>14.00</td>\n",
              "      <td>6.85</td>\n",
              "      <td>1.16</td>\n",
              "      <td>2.855</td>\n",
              "      <td>1.0804</td>\n",
              "      <td>0.684</td>\n",
              "      <td>1.80</td>\n",
              "      <td>8.20</td>\n",
              "      <td>1.84</td>\n",
              "      <td>2.26</td>\n",
              "      <td>2.08</td>\n",
              "      <td>0.3483</td>\n",
              "      <td>0.5563</td>\n",
              "      <td>2.61</td>\n",
              "      <td>0.1702</td>\n",
              "      <td>0.1697</td>\n",
              "      <td>8.167210e+04</td>\n",
              "      <td>868046000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>-0.4085</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>109</td>\n",
              "      <td>255</td>\n",
              "      <td>TRPL3</td>\n",
              "      <td>31.19</td>\n",
              "      <td>6.90</td>\n",
              "      <td>1.38</td>\n",
              "      <td>3.539</td>\n",
              "      <td>0.0637</td>\n",
              "      <td>0.685</td>\n",
              "      <td>7.28</td>\n",
              "      <td>5.11</td>\n",
              "      <td>-1.93</td>\n",
              "      <td>6.75</td>\n",
              "      <td>6.71</td>\n",
              "      <td>0.6932</td>\n",
              "      <td>0.5178</td>\n",
              "      <td>3.29</td>\n",
              "      <td>0.1401</td>\n",
              "      <td>0.2000</td>\n",
              "      <td>4.184870e+04</td>\n",
              "      <td>14896500000</td>\n",
              "      <td>0.52</td>\n",
              "      <td>0.1835</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>112</td>\n",
              "      <td>258</td>\n",
              "      <td>ESPA3</td>\n",
              "      <td>3.27</td>\n",
              "      <td>7.03</td>\n",
              "      <td>1.10</td>\n",
              "      <td>1.068</td>\n",
              "      <td>0.0250</td>\n",
              "      <td>0.364</td>\n",
              "      <td>4.15</td>\n",
              "      <td>9.36</td>\n",
              "      <td>-1.28</td>\n",
              "      <td>18.56</td>\n",
              "      <td>10.19</td>\n",
              "      <td>0.1141</td>\n",
              "      <td>0.1489</td>\n",
              "      <td>1.30</td>\n",
              "      <td>0.0418</td>\n",
              "      <td>0.1570</td>\n",
              "      <td>1.977090e+07</td>\n",
              "      <td>723328000</td>\n",
              "      <td>1.27</td>\n",
              "      <td>0.3641</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>124</td>\n",
              "      <td>276</td>\n",
              "      <td>COCE5</td>\n",
              "      <td>50.46</td>\n",
              "      <td>7.66</td>\n",
              "      <td>1.10</td>\n",
              "      <td>0.457</td>\n",
              "      <td>0.0334</td>\n",
              "      <td>0.335</td>\n",
              "      <td>-6.79</td>\n",
              "      <td>3.02</td>\n",
              "      <td>-0.85</td>\n",
              "      <td>5.96</td>\n",
              "      <td>4.73</td>\n",
              "      <td>0.1513</td>\n",
              "      <td>0.0596</td>\n",
              "      <td>0.86</td>\n",
              "      <td>0.1259</td>\n",
              "      <td>0.1431</td>\n",
              "      <td>8.017280e+05</td>\n",
              "      <td>3583410000</td>\n",
              "      <td>1.13</td>\n",
              "      <td>0.1461</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>145</td>\n",
              "      <td>308</td>\n",
              "      <td>PSSA3</td>\n",
              "      <td>20.18</td>\n",
              "      <td>9.16</td>\n",
              "      <td>1.40</td>\n",
              "      <td>0.586</td>\n",
              "      <td>0.0462</td>\n",
              "      <td>0.307</td>\n",
              "      <td>5.92</td>\n",
              "      <td>0.72</td>\n",
              "      <td>-2.43</td>\n",
              "      <td>0.21</td>\n",
              "      <td>0.21</td>\n",
              "      <td>0.8112</td>\n",
              "      <td>0.0640</td>\n",
              "      <td>1.09</td>\n",
              "      <td>0.5429</td>\n",
              "      <td>0.1532</td>\n",
              "      <td>3.985590e+07</td>\n",
              "      <td>9296640000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0594</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>149</td>\n",
              "      <td>313</td>\n",
              "      <td>TGMA3</td>\n",
              "      <td>15.06</td>\n",
              "      <td>9.33</td>\n",
              "      <td>1.42</td>\n",
              "      <td>0.980</td>\n",
              "      <td>0.0620</td>\n",
              "      <td>0.966</td>\n",
              "      <td>3.35</td>\n",
              "      <td>8.98</td>\n",
              "      <td>6.02</td>\n",
              "      <td>8.77</td>\n",
              "      <td>7.31</td>\n",
              "      <td>0.1091</td>\n",
              "      <td>0.1049</td>\n",
              "      <td>2.51</td>\n",
              "      <td>0.1420</td>\n",
              "      <td>0.1523</td>\n",
              "      <td>3.763370e+06</td>\n",
              "      <td>699442000</td>\n",
              "      <td>0.27</td>\n",
              "      <td>-0.0495</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>165</td>\n",
              "      <td>335</td>\n",
              "      <td>TIMS3</td>\n",
              "      <td>13.70</td>\n",
              "      <td>10.75</td>\n",
              "      <td>1.31</td>\n",
              "      <td>1.798</td>\n",
              "      <td>0.0375</td>\n",
              "      <td>0.676</td>\n",
              "      <td>6.82</td>\n",
              "      <td>9.81</td>\n",
              "      <td>-3.29</td>\n",
              "      <td>8.41</td>\n",
              "      <td>3.14</td>\n",
              "      <td>0.1832</td>\n",
              "      <td>0.1673</td>\n",
              "      <td>1.56</td>\n",
              "      <td>0.0891</td>\n",
              "      <td>0.1218</td>\n",
              "      <td>9.037040e+07</td>\n",
              "      <td>25338000000</td>\n",
              "      <td>0.13</td>\n",
              "      <td>0.0296</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>166</td>\n",
              "      <td>336</td>\n",
              "      <td>BALM3</td>\n",
              "      <td>14.42</td>\n",
              "      <td>10.79</td>\n",
              "      <td>1.14</td>\n",
              "      <td>1.049</td>\n",
              "      <td>0.0174</td>\n",
              "      <td>0.630</td>\n",
              "      <td>1.50</td>\n",
              "      <td>18.37</td>\n",
              "      <td>2.48</td>\n",
              "      <td>15.72</td>\n",
              "      <td>10.86</td>\n",
              "      <td>0.0571</td>\n",
              "      <td>0.0678</td>\n",
              "      <td>2.56</td>\n",
              "      <td>0.0443</td>\n",
              "      <td>0.1056</td>\n",
              "      <td>4.563300e+02</td>\n",
              "      <td>124110000</td>\n",
              "      <td>0.16</td>\n",
              "      <td>0.0713</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>167</td>\n",
              "      <td>338</td>\n",
              "      <td>TUPY3</td>\n",
              "      <td>22.32</td>\n",
              "      <td>10.91</td>\n",
              "      <td>1.21</td>\n",
              "      <td>0.407</td>\n",
              "      <td>0.0194</td>\n",
              "      <td>0.463</td>\n",
              "      <td>1.35</td>\n",
              "      <td>4.75</td>\n",
              "      <td>276.76</td>\n",
              "      <td>6.81</td>\n",
              "      <td>4.39</td>\n",
              "      <td>0.0858</td>\n",
              "      <td>0.0369</td>\n",
              "      <td>2.24</td>\n",
              "      <td>0.1379</td>\n",
              "      <td>0.1106</td>\n",
              "      <td>2.510950e+07</td>\n",
              "      <td>2666340000</td>\n",
              "      <td>0.88</td>\n",
              "      <td>0.1431</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>171</td>\n",
              "      <td>343</td>\n",
              "      <td>SBSP3</td>\n",
              "      <td>45.96</td>\n",
              "      <td>11.28</td>\n",
              "      <td>1.21</td>\n",
              "      <td>1.596</td>\n",
              "      <td>0.0205</td>\n",
              "      <td>0.581</td>\n",
              "      <td>17.60</td>\n",
              "      <td>7.59</td>\n",
              "      <td>-1.48</td>\n",
              "      <td>11.03</td>\n",
              "      <td>7.09</td>\n",
              "      <td>0.2102</td>\n",
              "      <td>0.1415</td>\n",
              "      <td>1.34</td>\n",
              "      <td>0.0820</td>\n",
              "      <td>0.1075</td>\n",
              "      <td>1.745040e+08</td>\n",
              "      <td>25907400000</td>\n",
              "      <td>0.68</td>\n",
              "      <td>0.0728</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>183</td>\n",
              "      <td>361</td>\n",
              "      <td>UGPA3</td>\n",
              "      <td>13.63</td>\n",
              "      <td>12.98</td>\n",
              "      <td>1.44</td>\n",
              "      <td>0.130</td>\n",
              "      <td>0.0272</td>\n",
              "      <td>0.404</td>\n",
              "      <td>1.59</td>\n",
              "      <td>9.83</td>\n",
              "      <td>-4.23</td>\n",
              "      <td>18.84</td>\n",
              "      <td>12.27</td>\n",
              "      <td>0.0132</td>\n",
              "      <td>0.0103</td>\n",
              "      <td>1.71</td>\n",
              "      <td>0.0531</td>\n",
              "      <td>0.1110</td>\n",
              "      <td>1.086530e+08</td>\n",
              "      <td>10542200000</td>\n",
              "      <td>1.63</td>\n",
              "      <td>0.0657</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>184</td>\n",
              "      <td>362</td>\n",
              "      <td>PRNR3</td>\n",
              "      <td>6.84</td>\n",
              "      <td>13.05</td>\n",
              "      <td>1.13</td>\n",
              "      <td>0.550</td>\n",
              "      <td>0.0137</td>\n",
              "      <td>0.648</td>\n",
              "      <td>3.10</td>\n",
              "      <td>8.69</td>\n",
              "      <td>7.17</td>\n",
              "      <td>9.01</td>\n",
              "      <td>5.25</td>\n",
              "      <td>0.0633</td>\n",
              "      <td>0.0429</td>\n",
              "      <td>1.68</td>\n",
              "      <td>0.0940</td>\n",
              "      <td>0.0870</td>\n",
              "      <td>1.040570e+06</td>\n",
              "      <td>234498000</td>\n",
              "      <td>0.33</td>\n",
              "      <td>0.0995</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>189</td>\n",
              "      <td>369</td>\n",
              "      <td>VIVT3</td>\n",
              "      <td>50.06</td>\n",
              "      <td>13.87</td>\n",
              "      <td>1.20</td>\n",
              "      <td>1.885</td>\n",
              "      <td>0.0736</td>\n",
              "      <td>0.721</td>\n",
              "      <td>-1697.94</td>\n",
              "      <td>16.58</td>\n",
              "      <td>-3.41</td>\n",
              "      <td>18.39</td>\n",
              "      <td>5.39</td>\n",
              "      <td>0.1137</td>\n",
              "      <td>0.1356</td>\n",
              "      <td>1.00</td>\n",
              "      <td>0.0496</td>\n",
              "      <td>0.0864</td>\n",
              "      <td>1.194590e+08</td>\n",
              "      <td>70102900000</td>\n",
              "      <td>0.22</td>\n",
              "      <td>0.0040</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>193</td>\n",
              "      <td>374</td>\n",
              "      <td>MDIA3</td>\n",
              "      <td>22.30</td>\n",
              "      <td>14.33</td>\n",
              "      <td>1.20</td>\n",
              "      <td>0.920</td>\n",
              "      <td>0.0873</td>\n",
              "      <td>0.758</td>\n",
              "      <td>2.97</td>\n",
              "      <td>15.23</td>\n",
              "      <td>23.22</td>\n",
              "      <td>16.86</td>\n",
              "      <td>10.54</td>\n",
              "      <td>0.0605</td>\n",
              "      <td>0.0643</td>\n",
              "      <td>2.77</td>\n",
              "      <td>0.0591</td>\n",
              "      <td>0.0836</td>\n",
              "      <td>3.878600e+07</td>\n",
              "      <td>6313140000</td>\n",
              "      <td>0.26</td>\n",
              "      <td>0.1027</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>198</td>\n",
              "      <td>380</td>\n",
              "      <td>BMOB3</td>\n",
              "      <td>13.69</td>\n",
              "      <td>15.09</td>\n",
              "      <td>1.22</td>\n",
              "      <td>1.546</td>\n",
              "      <td>0.0148</td>\n",
              "      <td>0.884</td>\n",
              "      <td>2.17</td>\n",
              "      <td>14.02</td>\n",
              "      <td>2.43</td>\n",
              "      <td>8.09</td>\n",
              "      <td>5.43</td>\n",
              "      <td>0.1103</td>\n",
              "      <td>0.1024</td>\n",
              "      <td>2.77</td>\n",
              "      <td>0.1175</td>\n",
              "      <td>0.0808</td>\n",
              "      <td>8.657860e+06</td>\n",
              "      <td>1021170000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>3.1003</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>224</td>\n",
              "      <td>416</td>\n",
              "      <td>IGTI3</td>\n",
              "      <td>2.59</td>\n",
              "      <td>23.70</td>\n",
              "      <td>1.41</td>\n",
              "      <td>5.222</td>\n",
              "      <td>0.0115</td>\n",
              "      <td>0.661</td>\n",
              "      <td>2.73</td>\n",
              "      <td>12.37</td>\n",
              "      <td>-3.01</td>\n",
              "      <td>16.23</td>\n",
              "      <td>11.55</td>\n",
              "      <td>0.4223</td>\n",
              "      <td>0.3173</td>\n",
              "      <td>4.63</td>\n",
              "      <td>0.0725</td>\n",
              "      <td>0.0593</td>\n",
              "      <td>7.218350e+05</td>\n",
              "      <td>3407800000</td>\n",
              "      <td>0.99</td>\n",
              "      <td>0.0514</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>228</td>\n",
              "      <td>424</td>\n",
              "      <td>SOMA3</td>\n",
              "      <td>11.01</td>\n",
              "      <td>26.38</td>\n",
              "      <td>1.20</td>\n",
              "      <td>2.500</td>\n",
              "      <td>0.0082</td>\n",
              "      <td>0.843</td>\n",
              "      <td>5.38</td>\n",
              "      <td>27.91</td>\n",
              "      <td>-132.96</td>\n",
              "      <td>30.79</td>\n",
              "      <td>20.05</td>\n",
              "      <td>0.0896</td>\n",
              "      <td>0.0948</td>\n",
              "      <td>2.14</td>\n",
              "      <td>0.0335</td>\n",
              "      <td>0.0457</td>\n",
              "      <td>9.063970e+07</td>\n",
              "      <td>7173290000</td>\n",
              "      <td>0.18</td>\n",
              "      <td>1.6523</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50</th>\n",
              "      <td>237</td>\n",
              "      <td>438</td>\n",
              "      <td>SULA4</td>\n",
              "      <td>8.28</td>\n",
              "      <td>34.91</td>\n",
              "      <td>1.30</td>\n",
              "      <td>0.512</td>\n",
              "      <td>0.0090</td>\n",
              "      <td>0.360</td>\n",
              "      <td>0.96</td>\n",
              "      <td>-21.20</td>\n",
              "      <td>-7.53</td>\n",
              "      <td>7.57</td>\n",
              "      <td>10.95</td>\n",
              "      <td>-0.0241</td>\n",
              "      <td>0.0146</td>\n",
              "      <td>2.24</td>\n",
              "      <td>-0.0427</td>\n",
              "      <td>0.0372</td>\n",
              "      <td>1.351270e+05</td>\n",
              "      <td>8150850000</td>\n",
              "      <td>0.41</td>\n",
              "      <td>0.0166</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>51</th>\n",
              "      <td>239</td>\n",
              "      <td>440</td>\n",
              "      <td>SULA11</td>\n",
              "      <td>25.19</td>\n",
              "      <td>35.40</td>\n",
              "      <td>1.32</td>\n",
              "      <td>0.519</td>\n",
              "      <td>0.0089</td>\n",
              "      <td>0.365</td>\n",
              "      <td>0.98</td>\n",
              "      <td>-21.50</td>\n",
              "      <td>-7.64</td>\n",
              "      <td>7.27</td>\n",
              "      <td>10.52</td>\n",
              "      <td>-0.0241</td>\n",
              "      <td>0.0146</td>\n",
              "      <td>2.24</td>\n",
              "      <td>-0.0427</td>\n",
              "      <td>0.0372</td>\n",
              "      <td>1.329400e+08</td>\n",
              "      <td>8150850000</td>\n",
              "      <td>0.41</td>\n",
              "      <td>0.0166</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>52</th>\n",
              "      <td>240</td>\n",
              "      <td>441</td>\n",
              "      <td>SULA3</td>\n",
              "      <td>8.59</td>\n",
              "      <td>36.21</td>\n",
              "      <td>1.35</td>\n",
              "      <td>0.531</td>\n",
              "      <td>0.0087</td>\n",
              "      <td>0.374</td>\n",
              "      <td>1.00</td>\n",
              "      <td>-22.00</td>\n",
              "      <td>-7.81</td>\n",
              "      <td>6.77</td>\n",
              "      <td>9.80</td>\n",
              "      <td>-0.0241</td>\n",
              "      <td>0.0146</td>\n",
              "      <td>2.24</td>\n",
              "      <td>-0.0427</td>\n",
              "      <td>0.0372</td>\n",
              "      <td>7.011810e+04</td>\n",
              "      <td>8150850000</td>\n",
              "      <td>0.41</td>\n",
              "      <td>0.0166</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>53</th>\n",
              "      <td>244</td>\n",
              "      <td>446</td>\n",
              "      <td>NGRD3</td>\n",
              "      <td>2.29</td>\n",
              "      <td>44.75</td>\n",
              "      <td>1.19</td>\n",
              "      <td>2.167</td>\n",
              "      <td>0.0065</td>\n",
              "      <td>0.739</td>\n",
              "      <td>2.36</td>\n",
              "      <td>26.79</td>\n",
              "      <td>7.52</td>\n",
              "      <td>16.45</td>\n",
              "      <td>7.92</td>\n",
              "      <td>0.0809</td>\n",
              "      <td>0.0476</td>\n",
              "      <td>2.88</td>\n",
              "      <td>0.0469</td>\n",
              "      <td>0.0267</td>\n",
              "      <td>3.428840e+06</td>\n",
              "      <td>457808000</td>\n",
              "      <td>0.18</td>\n",
              "      <td>0.1448</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>54</th>\n",
              "      <td>255</td>\n",
              "      <td>462</td>\n",
              "      <td>AURE3</td>\n",
              "      <td>14.18</td>\n",
              "      <td>339.14</td>\n",
              "      <td>1.11</td>\n",
              "      <td>4.408</td>\n",
              "      <td>0.0071</td>\n",
              "      <td>0.498</td>\n",
              "      <td>5.98</td>\n",
              "      <td>11.80</td>\n",
              "      <td>-1.39</td>\n",
              "      <td>13.19</td>\n",
              "      <td>8.88</td>\n",
              "      <td>0.3734</td>\n",
              "      <td>0.0838</td>\n",
              "      <td>1.77</td>\n",
              "      <td>0.0483</td>\n",
              "      <td>0.0033</td>\n",
              "      <td>4.441070e+07</td>\n",
              "      <td>12820300000</td>\n",
              "      <td>0.38</td>\n",
              "      <td>0.0000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f9386be7-9136-4a4a-b11d-a99fc3f7713e')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-f9386be7-9136-4a4a-b11d-a99fc3f7713e button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-f9386be7-9136-4a4a-b11d-a99fc3f7713e');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 114
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Após aplicar filtro restaram apenas 55 empresas."
      ],
      "metadata": {
        "id": "Lz2GAfIuF0dt"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df_preco_vp2.shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "IzlJI_tiEccA",
        "outputId": "d659f375-204c-41e2-a2f6-1dfdf1bcc460"
      },
      "execution_count": 56,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(55, 22)"
            ]
          },
          "metadata": {},
          "execution_count": 56
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Visualização dos dados"
      ],
      "metadata": {
        "id": "BTigzK7cEhGC"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df_preco_vp2.plot(x = 'Papel',y ='Cotação', kind = 'bar', title = 'AÇÃO x COTAÇÃO')\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 542
        },
        "id": "fzs2DPVGGKBV",
        "outputId": "ee77a7fa-edc1-4e25-90ec-86c73adddc94"
      },
      "execution_count": 120,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<html>\n",
              "<head><meta charset=\"utf-8\" /></head>\n",
              "<body>\n",
              "    <div>            <script src=\"https://cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.5/MathJax.js?config=TeX-AMS-MML_SVG\"></script><script type=\"text/javascript\">if (window.MathJax) {MathJax.Hub.Config({SVG: {font: \"STIX-Web\"}});}</script>                <script type=\"text/javascript\">window.PlotlyConfig = {MathJaxConfig: 'local'};</script>\n",
              "        <script src=\"https://cdn.plot.ly/plotly-2.8.3.min.js\"></script>                <div id=\"152c67b7-fec0-4dbe-ad53-12091666f91d\" class=\"plotly-graph-div\" style=\"height:525px; width:100%;\"></div>            <script type=\"text/javascript\">                                    window.PLOTLYENV=window.PLOTLYENV || {};                                    if (document.getElementById(\"152c67b7-fec0-4dbe-ad53-12091666f91d\")) {                    Plotly.newPlot(                        \"152c67b7-fec0-4dbe-ad53-12091666f91d\",                        [{\"alignmentgroup\":\"True\",\"hovertemplate\":\"Papel=%{x}<br>Cota\\u00e7\\u00e3o=%{y}<extra></extra>\",\"legendgroup\":\"\",\"marker\":{\"color\":\"#636efa\",\"pattern\":{\"shape\":\"\"}},\"name\":\"\",\"offsetgroup\":\"\",\"orientation\":\"v\",\"showlegend\":false,\"textposition\":\"auto\",\"x\":[\"GGBR4\",\"PETR4\",\"ETER3\",\"CSNA3\",\"PETR3\",\"ENAT3\",\"RAPT3\",\"ROMI3\",\"PLPL3\",\"RAPT4\",\"JHSF3\",\"PEAB3\",\"AGRO3\",\"CEEB3\",\"EALT3\",\"CRPG5\",\"CMIG4\",\"CRPG6\",\"TRPL4\",\"ENBR3\",\"MTSA4\",\"CAML3\",\"ITSA4\",\"PEAB4\",\"CEBR5\",\"ITSA3\",\"POSI3\",\"ALUP4\",\"CEBR6\",\"ALUP11\",\"ALUP3\",\"JSLG3\",\"UCAS3\",\"CEBR3\",\"TRPL3\",\"ESPA3\",\"COCE5\",\"PSSA3\",\"TGMA3\",\"TIMS3\",\"BALM3\",\"TUPY3\",\"SBSP3\",\"UGPA3\",\"PRNR3\",\"VIVT3\",\"MDIA3\",\"BMOB3\",\"IGTI3\",\"SOMA3\",\"SULA4\",\"SULA11\",\"SULA3\",\"NGRD3\",\"AURE3\"],\"xaxis\":\"x\",\"y\":[27.96,34.83,13.1,19.84,37.67,19.79,8.94,13.1,2.43,10.25,7.07,60.0,30.74,36.0,9.4,37.51,11.33,39.5,24.94,21.76,40.0,7.98,9.37,73.5,12.5,9.71,7.74,8.89,13.1,26.8,8.96,5.94,3.24,14.0,31.19,3.27,50.46,20.18,15.06,13.7,14.42,22.32,45.96,13.63,6.84,50.06,22.3,13.69,2.59,11.01,8.28,25.19,8.59,2.29,14.18],\"yaxis\":\"y\",\"type\":\"bar\"}],                        {\"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\":\"Papel\"}},\"yaxis\":{\"anchor\":\"x\",\"domain\":[0.0,1.0],\"title\":{\"text\":\"Cota\\u00e7\\u00e3o\"}},\"legend\":{\"tracegroupgap\":0},\"title\":{\"text\":\"A\\u00c7\\u00c3O x COTA\\u00c7\\u00c3O\"},\"barmode\":\"relative\"},                        {\"responsive\": true}                    ).then(function(){\n",
              "                            \n",
              "var gd = document.getElementById('152c67b7-fec0-4dbe-ad53-12091666f91d');\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>\n",
              "</body>\n",
              "</html>"
            ]
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "!pip install plotly"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "KFq4bjG409x9",
        "outputId": "fbab69ff-f191-4555-a71a-36f6c2f0e32b"
      },
      "execution_count": 101,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Requirement already satisfied: plotly in /usr/local/lib/python3.7/dist-packages (5.5.0)\n",
            "Requirement already satisfied: tenacity>=6.2.0 in /usr/local/lib/python3.7/dist-packages (from plotly) (8.0.1)\n",
            "Requirement already satisfied: six in /usr/local/lib/python3.7/dist-packages (from plotly) (1.15.0)\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "pd.options.plotting.backend = 'plotly'"
      ],
      "metadata": {
        "id": "UaAgPRQO1B_q"
      },
      "execution_count": 102,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_preco_vp2.plot(x = 'Papel',y ='Div.Yield', kind = 'hist', title = 'AÇÃO x DIVIDENDOS x PATRIMÔNIO LÍQUIDO', color = 'Patrim. Líq')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 542
        },
        "id": "Vvx8eXlPyIPX",
        "outputId": "02bbfe75-b2d1-47f4-fab1-f07b9a659d18"
      },
      "execution_count": 121,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<html>\n",
              "<head><meta charset=\"utf-8\" /></head>\n",
              "<body>\n",
              "    <div>            <script src=\"https://cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.5/MathJax.js?config=TeX-AMS-MML_SVG\"></script><script type=\"text/javascript\">if (window.MathJax) {MathJax.Hub.Config({SVG: {font: \"STIX-Web\"}});}</script>                <script type=\"text/javascript\">window.PlotlyConfig = {MathJaxConfig: 'local'};</script>\n",
              "        <script src=\"https://cdn.plot.ly/plotly-2.8.3.min.js\"></script>                <div id=\"64f868d9-b844-4ad7-b7bc-551b44c7ea87\" class=\"plotly-graph-div\" style=\"height:525px; width:100%;\"></div>            <script type=\"text/javascript\">                                    window.PLOTLYENV=window.PLOTLYENV || {};                                    if (document.getElementById(\"64f868d9-b844-4ad7-b7bc-551b44c7ea87\")) {                    Plotly.newPlot(                        \"64f868d9-b844-4ad7-b7bc-551b44c7ea87\",                        [{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=42328400000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"42328400000\",\"marker\":{\"color\":\"#636efa\",\"pattern\":{\"shape\":\"\"}},\"name\":\"42328400000\",\"offsetgroup\":\"42328400000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"GGBR4\"],\"xaxis\":\"x\",\"y\":[0.1184],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=434194000000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"434194000000\",\"marker\":{\"color\":\"#EF553B\",\"pattern\":{\"shape\":\"\"}},\"name\":\"434194000000\",\"offsetgroup\":\"434194000000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"PETR4\",\"PETR3\"],\"xaxis\":\"x\",\"y\":[0.22399999999999998,0.2071],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=605502000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"605502000\",\"marker\":{\"color\":\"#00cc96\",\"pattern\":{\"shape\":\"\"}},\"name\":\"605502000\",\"offsetgroup\":\"605502000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"ETER3\"],\"xaxis\":\"x\",\"y\":[0.048499999999999995],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=21883300000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"21883300000\",\"marker\":{\"color\":\"#ab63fa\",\"pattern\":{\"shape\":\"\"}},\"name\":\"21883300000\",\"offsetgroup\":\"21883300000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"CSNA3\"],\"xaxis\":\"x\",\"y\":[0.11289999999999999],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=3984900000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"3984900000\",\"marker\":{\"color\":\"#FFA15A\",\"pattern\":{\"shape\":\"\"}},\"name\":\"3984900000\",\"offsetgroup\":\"3984900000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"ENAT3\"],\"xaxis\":\"x\",\"y\":[0.0863],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=2624880000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"2624880000\",\"marker\":{\"color\":\"#19d3f3\",\"pattern\":{\"shape\":\"\"}},\"name\":\"2624880000\",\"offsetgroup\":\"2624880000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"RAPT3\",\"RAPT4\"],\"xaxis\":\"x\",\"y\":[0.0728,0.0635],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=948928000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"948928000\",\"marker\":{\"color\":\"#FF6692\",\"pattern\":{\"shape\":\"\"}},\"name\":\"948928000\",\"offsetgroup\":\"948928000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"ROMI3\"],\"xaxis\":\"x\",\"y\":[0.06849999999999999],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=332093000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"332093000\",\"marker\":{\"color\":\"#B6E880\",\"pattern\":{\"shape\":\"\"}},\"name\":\"332093000\",\"offsetgroup\":\"332093000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"PLPL3\"],\"xaxis\":\"x\",\"y\":[0.0663],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=4599010000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"4599010000\",\"marker\":{\"color\":\"#FF97FF\",\"pattern\":{\"shape\":\"\"}},\"name\":\"4599010000\",\"offsetgroup\":\"4599010000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"JHSF3\"],\"xaxis\":\"x\",\"y\":[0.0492],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=679035000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"679035000\",\"marker\":{\"color\":\"#FECB52\",\"pattern\":{\"shape\":\"\"}},\"name\":\"679035000\",\"offsetgroup\":\"679035000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"PEAB3\",\"PEAB4\"],\"xaxis\":\"x\",\"y\":[0.20929999999999999,0.18789999999999998],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=2469380000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"2469380000\",\"marker\":{\"color\":\"#636efa\",\"pattern\":{\"shape\":\"\"}},\"name\":\"2469380000\",\"offsetgroup\":\"2469380000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"AGRO3\"],\"xaxis\":\"x\",\"y\":[0.7412000000000001],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=6556000000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"6556000000\",\"marker\":{\"color\":\"#EF553B\",\"pattern\":{\"shape\":\"\"}},\"name\":\"6556000000\",\"offsetgroup\":\"6556000000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"CEEB3\"],\"xaxis\":\"x\",\"y\":[0.23850000000000002],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=188886000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"188886000\",\"marker\":{\"color\":\"#00cc96\",\"pattern\":{\"shape\":\"\"}},\"name\":\"188886000\",\"offsetgroup\":\"188886000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"EALT3\"],\"xaxis\":\"x\",\"y\":[0.1215],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=876876000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"876876000\",\"marker\":{\"color\":\"#ab63fa\",\"pattern\":{\"shape\":\"\"}},\"name\":\"876876000\",\"offsetgroup\":\"876876000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"CRPG5\",\"CRPG6\"],\"xaxis\":\"x\",\"y\":[0.1438,0.1366],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=20667000000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"20667000000\",\"marker\":{\"color\":\"#FFA15A\",\"pattern\":{\"shape\":\"\"}},\"name\":\"20667000000\",\"offsetgroup\":\"20667000000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"CMIG4\"],\"xaxis\":\"x\",\"y\":[0.08869999999999999],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=14896500000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"14896500000\",\"marker\":{\"color\":\"#19d3f3\",\"pattern\":{\"shape\":\"\"}},\"name\":\"14896500000\",\"offsetgroup\":\"14896500000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"TRPL4\",\"TRPL3\"],\"xaxis\":\"x\",\"y\":[0.0797,0.0637],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=11555100000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"11555100000\",\"marker\":{\"color\":\"#FF6692\",\"pattern\":{\"shape\":\"\"}},\"name\":\"11555100000\",\"offsetgroup\":\"11555100000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"ENBR3\"],\"xaxis\":\"x\",\"y\":[0.1008],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=329552000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"329552000\",\"marker\":{\"color\":\"#B6E880\",\"pattern\":{\"shape\":\"\"}},\"name\":\"329552000\",\"offsetgroup\":\"329552000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"MTSA4\"],\"xaxis\":\"x\",\"y\":[0.0557],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=2878800000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"2878800000\",\"marker\":{\"color\":\"#FF97FF\",\"pattern\":{\"shape\":\"\"}},\"name\":\"2878800000\",\"offsetgroup\":\"2878800000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"CAML3\"],\"xaxis\":\"x\",\"y\":[0.0337],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=65555000000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"65555000000\",\"marker\":{\"color\":\"#FECB52\",\"pattern\":{\"shape\":\"\"}},\"name\":\"65555000000\",\"offsetgroup\":\"65555000000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"ITSA4\",\"ITSA3\"],\"xaxis\":\"x\",\"y\":[0.056600000000000004,0.0546],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=868046000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"868046000\",\"marker\":{\"color\":\"#636efa\",\"pattern\":{\"shape\":\"\"}},\"name\":\"868046000\",\"offsetgroup\":\"868046000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"CEBR5\",\"CEBR6\",\"CEBR3\"],\"xaxis\":\"x\",\"y\":[1.21,1.27,1.0804],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=1101320000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"1101320000\",\"marker\":{\"color\":\"#EF553B\",\"pattern\":{\"shape\":\"\"}},\"name\":\"1101320000\",\"offsetgroup\":\"1101320000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"POSI3\"],\"xaxis\":\"x\",\"y\":[0.044000000000000004],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=7084130000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"7084130000\",\"marker\":{\"color\":\"#00cc96\",\"pattern\":{\"shape\":\"\"}},\"name\":\"7084130000\",\"offsetgroup\":\"7084130000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"ALUP4\",\"ALUP11\",\"ALUP3\"],\"xaxis\":\"x\",\"y\":[0.0461,0.045899999999999996,0.0458],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=1354950000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"1354950000\",\"marker\":{\"color\":\"#ab63fa\",\"pattern\":{\"shape\":\"\"}},\"name\":\"1354950000\",\"offsetgroup\":\"1354950000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"JSLG3\"],\"xaxis\":\"x\",\"y\":[0.0632],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=177759000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"177759000\",\"marker\":{\"color\":\"#FFA15A\",\"pattern\":{\"shape\":\"\"}},\"name\":\"177759000\",\"offsetgroup\":\"177759000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"UCAS3\"],\"xaxis\":\"x\",\"y\":[0.0333],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=723328000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"723328000\",\"marker\":{\"color\":\"#19d3f3\",\"pattern\":{\"shape\":\"\"}},\"name\":\"723328000\",\"offsetgroup\":\"723328000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"ESPA3\"],\"xaxis\":\"x\",\"y\":[0.025],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=3583410000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"3583410000\",\"marker\":{\"color\":\"#FF6692\",\"pattern\":{\"shape\":\"\"}},\"name\":\"3583410000\",\"offsetgroup\":\"3583410000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"COCE5\"],\"xaxis\":\"x\",\"y\":[0.0334],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=9296640000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"9296640000\",\"marker\":{\"color\":\"#B6E880\",\"pattern\":{\"shape\":\"\"}},\"name\":\"9296640000\",\"offsetgroup\":\"9296640000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"PSSA3\"],\"xaxis\":\"x\",\"y\":[0.0462],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=699442000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"699442000\",\"marker\":{\"color\":\"#FF97FF\",\"pattern\":{\"shape\":\"\"}},\"name\":\"699442000\",\"offsetgroup\":\"699442000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"TGMA3\"],\"xaxis\":\"x\",\"y\":[0.062],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=25338000000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"25338000000\",\"marker\":{\"color\":\"#FECB52\",\"pattern\":{\"shape\":\"\"}},\"name\":\"25338000000\",\"offsetgroup\":\"25338000000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"TIMS3\"],\"xaxis\":\"x\",\"y\":[0.0375],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=124110000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"124110000\",\"marker\":{\"color\":\"#636efa\",\"pattern\":{\"shape\":\"\"}},\"name\":\"124110000\",\"offsetgroup\":\"124110000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"BALM3\"],\"xaxis\":\"x\",\"y\":[0.0174],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=2666340000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"2666340000\",\"marker\":{\"color\":\"#EF553B\",\"pattern\":{\"shape\":\"\"}},\"name\":\"2666340000\",\"offsetgroup\":\"2666340000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"TUPY3\"],\"xaxis\":\"x\",\"y\":[0.0194],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=25907400000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"25907400000\",\"marker\":{\"color\":\"#00cc96\",\"pattern\":{\"shape\":\"\"}},\"name\":\"25907400000\",\"offsetgroup\":\"25907400000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"SBSP3\"],\"xaxis\":\"x\",\"y\":[0.020499999999999997],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=10542200000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"10542200000\",\"marker\":{\"color\":\"#ab63fa\",\"pattern\":{\"shape\":\"\"}},\"name\":\"10542200000\",\"offsetgroup\":\"10542200000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"UGPA3\"],\"xaxis\":\"x\",\"y\":[0.027200000000000002],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=234498000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"234498000\",\"marker\":{\"color\":\"#FFA15A\",\"pattern\":{\"shape\":\"\"}},\"name\":\"234498000\",\"offsetgroup\":\"234498000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"PRNR3\"],\"xaxis\":\"x\",\"y\":[0.0137],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=70102900000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"70102900000\",\"marker\":{\"color\":\"#19d3f3\",\"pattern\":{\"shape\":\"\"}},\"name\":\"70102900000\",\"offsetgroup\":\"70102900000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"VIVT3\"],\"xaxis\":\"x\",\"y\":[0.0736],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=6313140000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"6313140000\",\"marker\":{\"color\":\"#FF6692\",\"pattern\":{\"shape\":\"\"}},\"name\":\"6313140000\",\"offsetgroup\":\"6313140000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"MDIA3\"],\"xaxis\":\"x\",\"y\":[0.0873],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=1021170000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"1021170000\",\"marker\":{\"color\":\"#B6E880\",\"pattern\":{\"shape\":\"\"}},\"name\":\"1021170000\",\"offsetgroup\":\"1021170000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"BMOB3\"],\"xaxis\":\"x\",\"y\":[0.0148],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=3407800000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"3407800000\",\"marker\":{\"color\":\"#FF97FF\",\"pattern\":{\"shape\":\"\"}},\"name\":\"3407800000\",\"offsetgroup\":\"3407800000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"IGTI3\"],\"xaxis\":\"x\",\"y\":[0.0115],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=7173290000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"7173290000\",\"marker\":{\"color\":\"#FECB52\",\"pattern\":{\"shape\":\"\"}},\"name\":\"7173290000\",\"offsetgroup\":\"7173290000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"SOMA3\"],\"xaxis\":\"x\",\"y\":[0.008199999999999999],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=8150850000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"8150850000\",\"marker\":{\"color\":\"#636efa\",\"pattern\":{\"shape\":\"\"}},\"name\":\"8150850000\",\"offsetgroup\":\"8150850000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"SULA4\",\"SULA11\",\"SULA3\"],\"xaxis\":\"x\",\"y\":[0.009000000000000001,0.0089,0.0087],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=457808000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"457808000\",\"marker\":{\"color\":\"#EF553B\",\"pattern\":{\"shape\":\"\"}},\"name\":\"457808000\",\"offsetgroup\":\"457808000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"NGRD3\"],\"xaxis\":\"x\",\"y\":[0.006500000000000001],\"yaxis\":\"y\",\"type\":\"histogram\"},{\"alignmentgroup\":\"True\",\"bingroup\":\"x\",\"histfunc\":\"sum\",\"hovertemplate\":\"Patrim. L\\u00edq=12820300000<br>Papel=%{x}<br>sum of Div.Yield=%{y}<extra></extra>\",\"legendgroup\":\"12820300000\",\"marker\":{\"color\":\"#00cc96\",\"pattern\":{\"shape\":\"\"}},\"name\":\"12820300000\",\"offsetgroup\":\"12820300000\",\"orientation\":\"v\",\"showlegend\":true,\"x\":[\"AURE3\"],\"xaxis\":\"x\",\"y\":[0.0070999999999999995],\"yaxis\":\"y\",\"type\":\"histogram\"}],                        {\"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\":\"Papel\"}},\"yaxis\":{\"anchor\":\"x\",\"domain\":[0.0,1.0],\"title\":{\"text\":\"sum of Div.Yield\"}},\"legend\":{\"title\":{\"text\":\"Patrim. L\\u00edq\"},\"tracegroupgap\":0},\"title\":{\"text\":\"A\\u00c7\\u00c3O x DIVIDENDOS x PATRIM\\u00d4NIO L\\u00cdQUIDO\"},\"barmode\":\"relative\"},                        {\"responsive\": true}                    ).then(function(){\n",
              "                            \n",
              "var gd = document.getElementById('64f868d9-b844-4ad7-b7bc-551b44c7ea87');\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>\n",
              "</body>\n",
              "</html>"
            ]
          },
          "metadata": {}
        }
      ]
    }
  ]
}