Live_08_09_2022_Pandas_Fundamentus.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "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/Trading-com-Dados/tutoriais_publicos/blob/main/Live_08_09_2022_Pandas_Fundamentus.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "<img src=\"https://tradingcomdados.com/images/logotipo/logotipo-trading-com-dados.svg\" width=\"300\" align=\"left\"/>"
      ],
      "metadata": {
        "id": "AGVU28RsIhWy"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "##Pandas e Fundamentus"
      ],
      "metadata": {
        "id": "9IYKqcwVI8b8"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Documentação da lib utilizada: \n",
        "- https://pandas.pydata.org/docs/\n",
        "- https://pypi.org/project/fundamentus/\n",
        "\n",
        "- Esse código não é uma recomendação de investimento e deve ser utilizado somente para fins educacionais.\n",
        "- Autor: https://www.linkedin.com/in/arthur-camargo/\n"
      ],
      "metadata": {
        "id": "p1DYd5Nq4Q63"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "###Importando Bibliotecas"
      ],
      "metadata": {
        "id": "lPSaGjKBI-eA"
      }
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "CupVcoCXHYc0",
        "outputId": "e82914ec-f2b7-4e39-bfb0-ce3abacbf501"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Looking in indexes: https://pypi.org/simple, https://us-python.pkg.dev/colab-wheels/public/simple/\n",
            "Collecting fundamentus\n",
            "  Downloading fundamentus-0.2.0-py3-none-any.whl (13 kB)\n",
            "Requirement already satisfied: pandas>=1.1.5 in /usr/local/lib/python3.7/dist-packages (from fundamentus) (1.3.5)\n",
            "Requirement already satisfied: lxml>=4.6.2 in /usr/local/lib/python3.7/dist-packages (from fundamentus) (4.9.1)\n",
            "Requirement already satisfied: tabulate>=0.8.7 in /usr/local/lib/python3.7/dist-packages (from fundamentus) (0.8.10)\n",
            "Collecting requests>=2.25.1\n",
            "  Downloading requests-2.28.1-py3-none-any.whl (62 kB)\n",
            "\u001b[K     |████████████████████████████████| 62 kB 826 kB/s \n",
            "\u001b[?25hCollecting requests-cache>=0.5.2\n",
            "  Downloading requests_cache-0.9.6-py3-none-any.whl (47 kB)\n",
            "\u001b[K     |████████████████████████████████| 47 kB 4.8 MB/s \n",
            "\u001b[?25hRequirement already satisfied: python-dateutil>=2.7.3 in /usr/local/lib/python3.7/dist-packages (from pandas>=1.1.5->fundamentus) (2.8.2)\n",
            "Requirement already satisfied: numpy>=1.17.3 in /usr/local/lib/python3.7/dist-packages (from pandas>=1.1.5->fundamentus) (1.21.6)\n",
            "Requirement already satisfied: pytz>=2017.3 in /usr/local/lib/python3.7/dist-packages (from pandas>=1.1.5->fundamentus) (2022.2.1)\n",
            "Requirement already satisfied: six>=1.5 in /usr/local/lib/python3.7/dist-packages (from python-dateutil>=2.7.3->pandas>=1.1.5->fundamentus) (1.15.0)\n",
            "Requirement already satisfied: charset-normalizer<3,>=2 in /usr/local/lib/python3.7/dist-packages (from requests>=2.25.1->fundamentus) (2.1.1)\n",
            "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.7/dist-packages (from requests>=2.25.1->fundamentus) (2022.6.15)\n",
            "Requirement already satisfied: urllib3<1.27,>=1.21.1 in /usr/local/lib/python3.7/dist-packages (from requests>=2.25.1->fundamentus) (1.24.3)\n",
            "Requirement already satisfied: idna<4,>=2.5 in /usr/local/lib/python3.7/dist-packages (from requests>=2.25.1->fundamentus) (2.10)\n",
            "Collecting urllib3<1.27,>=1.21.1\n",
            "  Downloading urllib3-1.26.12-py2.py3-none-any.whl (140 kB)\n",
            "\u001b[K     |████████████████████████████████| 140 kB 31.0 MB/s \n",
            "\u001b[?25hCollecting cattrs>=1.8\n",
            "  Downloading cattrs-22.1.0-py3-none-any.whl (33 kB)\n",
            "Requirement already satisfied: appdirs>=1.4.4 in /usr/local/lib/python3.7/dist-packages (from requests-cache>=0.5.2->fundamentus) (1.4.4)\n",
            "Requirement already satisfied: attrs>=21.2 in /usr/local/lib/python3.7/dist-packages (from requests-cache>=0.5.2->fundamentus) (22.1.0)\n",
            "Collecting url-normalize>=1.4\n",
            "  Downloading url_normalize-1.4.3-py2.py3-none-any.whl (6.8 kB)\n",
            "Collecting exceptiongroup\n",
            "  Downloading exceptiongroup-1.0.0rc9-py3-none-any.whl (12 kB)\n",
            "Requirement already satisfied: typing_extensions in /usr/local/lib/python3.7/dist-packages (from cattrs>=1.8->requests-cache>=0.5.2->fundamentus) (4.1.1)\n",
            "Installing collected packages: urllib3, exceptiongroup, url-normalize, requests, cattrs, requests-cache, fundamentus\n",
            "  Attempting uninstall: urllib3\n",
            "    Found existing installation: urllib3 1.24.3\n",
            "    Uninstalling urllib3-1.24.3:\n",
            "      Successfully uninstalled urllib3-1.24.3\n",
            "  Attempting uninstall: requests\n",
            "    Found existing installation: requests 2.23.0\n",
            "    Uninstalling requests-2.23.0:\n",
            "      Successfully uninstalled requests-2.23.0\n",
            "Successfully installed cattrs-22.1.0 exceptiongroup-1.0.0rc9 fundamentus-0.2.0 requests-2.28.1 requests-cache-0.9.6 url-normalize-1.4.3 urllib3-1.26.12\n",
            "Looking in indexes: https://pypi.org/simple, https://us-python.pkg.dev/colab-wheels/public/simple/\n",
            "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"
          ]
        }
      ],
      "source": [
        "!pip install fundamentus\n",
        "!pip install plotly"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import fundamentus\n",
        "import numpy as np\n",
        "import pandas as pd\n",
        "import matplotlib.pyplot as plt\n",
        "import plotly.graph_objects as go\n",
        "from plotly.subplots import make_subplots"
      ],
      "metadata": {
        "id": "zqixne0yJ-5R"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "##Pandas"
      ],
      "metadata": {
        "id": "fnbAvOHEKQBR"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df = fundamentus.get_resultado()"
      ],
      "metadata": {
        "id": "HYn5j0UFKOWc"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 301
        },
        "id": "shcIXOKRKUwi",
        "outputId": "fb7f9b34-a9d0-4689-987d-a1b06f384fac"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Multiples  cotacao      pl   pvp    psr      dy     pa    pcg  pebit   pacl  \\\n",
              "papel                                                                         \n",
              "AALR3        19.70  -42.20  2.03  2.100  0.0000  0.905 -25.07  31.44  -2.48   \n",
              "ABCB3         0.00    0.00  0.00  0.000  0.0000  0.000   0.00   0.00   0.00   \n",
              "ABCB4        19.70    6.40  0.91  0.000  0.0583  0.000   0.00   0.00   0.00   \n",
              "ABEV3        15.50   18.03  2.83  3.173  0.0389  1.787  56.24  15.75 -22.59   \n",
              "ABYA3         4.91 -214.80  1.76  2.055  0.0000  0.527   1.98  19.96  -2.75   \n",
              "\n",
              "Multiples  evebit  evebitda  mrgebit  mrgliq    roic     roe  liqc  \\\n",
              "papel                                                                \n",
              "AALR3       39.11     15.19   0.0668 -0.0422  0.0330 -0.0482  0.83   \n",
              "ABCB3        0.00      0.00   0.0000  0.0000  0.0000  0.1418  0.00   \n",
              "ABCB4        0.00      0.00   0.0000  0.0000  0.0000  0.1418  0.00   \n",
              "ABEV3       14.94     11.17   0.2015  0.1827  0.1533  0.1570  1.13   \n",
              "ABYA3       33.67     33.67   0.1029 -0.0096  0.0278 -0.0082  2.09   \n",
              "\n",
              "Multiples        liq2m       patrliq  divbpatr     c5y  \n",
              "papel                                                   \n",
              "AALR3        5995930.0  1.145370e+09      0.71  0.0086  \n",
              "ABCB3              0.0  4.910570e+09      0.00  0.2080  \n",
              "ABCB4       13669900.0  4.910570e+09      0.00  0.2080  \n",
              "ABEV3      370393000.0  8.626310e+10      0.04  0.1195  \n",
              "ABYA3              0.0  2.920600e+08      1.31  0.1641  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-53628833-5c84-4568-b07a-4b6035e3eaf5\">\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>Multiples</th>\n",
              "      <th>cotacao</th>\n",
              "      <th>pl</th>\n",
              "      <th>pvp</th>\n",
              "      <th>psr</th>\n",
              "      <th>dy</th>\n",
              "      <th>pa</th>\n",
              "      <th>pcg</th>\n",
              "      <th>pebit</th>\n",
              "      <th>pacl</th>\n",
              "      <th>evebit</th>\n",
              "      <th>evebitda</th>\n",
              "      <th>mrgebit</th>\n",
              "      <th>mrgliq</th>\n",
              "      <th>roic</th>\n",
              "      <th>roe</th>\n",
              "      <th>liqc</th>\n",
              "      <th>liq2m</th>\n",
              "      <th>patrliq</th>\n",
              "      <th>divbpatr</th>\n",
              "      <th>c5y</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>papel</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>AALR3</th>\n",
              "      <td>19.70</td>\n",
              "      <td>-42.20</td>\n",
              "      <td>2.03</td>\n",
              "      <td>2.100</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.905</td>\n",
              "      <td>-25.07</td>\n",
              "      <td>31.44</td>\n",
              "      <td>-2.48</td>\n",
              "      <td>39.11</td>\n",
              "      <td>15.19</td>\n",
              "      <td>0.0668</td>\n",
              "      <td>-0.0422</td>\n",
              "      <td>0.0330</td>\n",
              "      <td>-0.0482</td>\n",
              "      <td>0.83</td>\n",
              "      <td>5995930.0</td>\n",
              "      <td>1.145370e+09</td>\n",
              "      <td>0.71</td>\n",
              "      <td>0.0086</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ABCB3</th>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.1418</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4.910570e+09</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.2080</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ABCB4</th>\n",
              "      <td>19.70</td>\n",
              "      <td>6.40</td>\n",
              "      <td>0.91</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.0583</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.1418</td>\n",
              "      <td>0.00</td>\n",
              "      <td>13669900.0</td>\n",
              "      <td>4.910570e+09</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.2080</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ABEV3</th>\n",
              "      <td>15.50</td>\n",
              "      <td>18.03</td>\n",
              "      <td>2.83</td>\n",
              "      <td>3.173</td>\n",
              "      <td>0.0389</td>\n",
              "      <td>1.787</td>\n",
              "      <td>56.24</td>\n",
              "      <td>15.75</td>\n",
              "      <td>-22.59</td>\n",
              "      <td>14.94</td>\n",
              "      <td>11.17</td>\n",
              "      <td>0.2015</td>\n",
              "      <td>0.1827</td>\n",
              "      <td>0.1533</td>\n",
              "      <td>0.1570</td>\n",
              "      <td>1.13</td>\n",
              "      <td>370393000.0</td>\n",
              "      <td>8.626310e+10</td>\n",
              "      <td>0.04</td>\n",
              "      <td>0.1195</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ABYA3</th>\n",
              "      <td>4.91</td>\n",
              "      <td>-214.80</td>\n",
              "      <td>1.76</td>\n",
              "      <td>2.055</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.527</td>\n",
              "      <td>1.98</td>\n",
              "      <td>19.96</td>\n",
              "      <td>-2.75</td>\n",
              "      <td>33.67</td>\n",
              "      <td>33.67</td>\n",
              "      <td>0.1029</td>\n",
              "      <td>-0.0096</td>\n",
              "      <td>0.0278</td>\n",
              "      <td>-0.0082</td>\n",
              "      <td>2.09</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2.920600e+08</td>\n",
              "      <td>1.31</td>\n",
              "      <td>0.1641</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-53628833-5c84-4568-b07a-4b6035e3eaf5')\"\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-53628833-5c84-4568-b07a-4b6035e3eaf5 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-53628833-5c84-4568-b07a-4b6035e3eaf5');\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": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "type(df)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "S8ugkNhnKYCK",
        "outputId": "89bd6ee3-05e0-4823-d01d-b4041fbb8ab4"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "pandas.core.frame.DataFrame"
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.index"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "CdeHUUK5KlNi",
        "outputId": "dba7ac79-86e5-46b0-9736-1ce9200d52c4"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['AALR3', 'ABCB3', 'ABCB4', 'ABEV3', 'ABYA3', 'ACES3', 'ACES4', 'ADHM3',\n",
              "       'AEDU11', 'AEDU3',\n",
              "       ...\n",
              "       'WHRL3', 'WHRL4', 'WISA3', 'WISA4', 'WIZS3', 'WLMM3', 'WLMM4', 'WMBY3',\n",
              "       'WSON33', 'YDUQ3'],\n",
              "      dtype='object', name='papel', length=968)"
            ]
          },
          "metadata": {},
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "lista_de_ativos = df.index\n",
        "lista_de_ativos"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "NEQJkAriK2C5",
        "outputId": "900c9516-0f9a-417b-ae07-45f18e1e6da6"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['AALR3', 'ABCB3', 'ABCB4', 'ABEV3', 'ABYA3', 'ACES3', 'ACES4', 'ADHM3',\n",
              "       'AEDU11', 'AEDU3',\n",
              "       ...\n",
              "       'WHRL3', 'WHRL4', 'WISA3', 'WISA4', 'WIZS3', 'WLMM3', 'WLMM4', 'WMBY3',\n",
              "       'WSON33', 'YDUQ3'],\n",
              "      dtype='object', name='papel', length=968)"
            ]
          },
          "metadata": {},
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.columns"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "-yGttupcK8tB",
        "outputId": "89855e2d-00f5-47dd-cffa-f6f67cfa5bf3"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['cotacao', 'pl', 'pvp', 'psr', 'dy', 'pa', 'pcg', 'pebit', 'pacl',\n",
              "       'evebit', 'evebitda', 'mrgebit', 'mrgliq', 'roic', 'roe', 'liqc',\n",
              "       'liq2m', 'patrliq', 'divbpatr', 'c5y'],\n",
              "      dtype='object', name='Multiples')"
            ]
          },
          "metadata": {},
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "lista_de_indicadores = df.columns"
      ],
      "metadata": {
        "id": "I3p9WCbjLAEq"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "lista_de_indicadores"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "uDcaTu3KLDXx",
        "outputId": "b124d0ee-6057-443b-af96-433b4b6d2c84"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['cotacao', 'pl', 'pvp', 'psr', 'dy', 'pa', 'pcg', 'pebit', 'pacl',\n",
              "       'evebit', 'evebitda', 'mrgebit', 'mrgliq', 'roic', 'roe', 'liqc',\n",
              "       'liq2m', 'patrliq', 'divbpatr', 'c5y'],\n",
              "      dtype='object', name='Multiples')"
            ]
          },
          "metadata": {},
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "type(lista_de_indicadores)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "S455tmAdLElK",
        "outputId": "f444217f-f82e-40ff-f053-5946cbdc7ec0"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "pandas.core.indexes.base.Index"
            ]
          },
          "metadata": {},
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#df.info retorna informaçãoes sobre o tipo de dados e ausência de nulls\n",
        "df.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "PPZOQMEhLGnh",
        "outputId": "6d24303c-e5c3-4737-8642-c02dd317a120"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "Index: 968 entries, AALR3 to YDUQ3\n",
            "Data columns (total 20 columns):\n",
            " #   Column    Non-Null Count  Dtype  \n",
            "---  ------    --------------  -----  \n",
            " 0   cotacao   968 non-null    float64\n",
            " 1   pl        968 non-null    float64\n",
            " 2   pvp       968 non-null    float64\n",
            " 3   psr       968 non-null    float64\n",
            " 4   dy        968 non-null    float64\n",
            " 5   pa        968 non-null    float64\n",
            " 6   pcg       968 non-null    float64\n",
            " 7   pebit     968 non-null    float64\n",
            " 8   pacl      968 non-null    float64\n",
            " 9   evebit    968 non-null    float64\n",
            " 10  evebitda  968 non-null    float64\n",
            " 11  mrgebit   968 non-null    float64\n",
            " 12  mrgliq    968 non-null    float64\n",
            " 13  roic      968 non-null    float64\n",
            " 14  roe       968 non-null    float64\n",
            " 15  liqc      968 non-null    float64\n",
            " 16  liq2m     968 non-null    float64\n",
            " 17  patrliq   968 non-null    float64\n",
            " 18  divbpatr  968 non-null    float64\n",
            " 19  c5y       968 non-null    float64\n",
            "dtypes: float64(20)\n",
            "memory usage: 158.8+ KB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Seleção pela coluna\n",
        "\n",
        "df['dy']"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "v6GV74pxMPW5",
        "outputId": "a0cbea12-6cfd-4691-a7d2-5482740d692d"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "papel\n",
              "AALR3     0.0000\n",
              "ABCB3     0.0000\n",
              "ABCB4     0.0583\n",
              "ABEV3     0.0389\n",
              "ABYA3     0.0000\n",
              "           ...  \n",
              "WLMM3     0.0402\n",
              "WLMM4     0.0334\n",
              "WMBY3     0.0000\n",
              "WSON33    0.0000\n",
              "YDUQ3     0.0104\n",
              "Name: dy, Length: 968, dtype: float64"
            ]
          },
          "metadata": {},
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Pandas Series outro tipo de estrutura de dados trabalhado no Pandas, um vetor de dados com labels em índice e coluna formato 1x1\n",
        "\n",
        "type(df['dy'])"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Y5VAmBY0Mc2w",
        "outputId": "6cf54148-6437-4d74-d5cf-72b9995f3ef5"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "pandas.core.series.Series"
            ]
          },
          "metadata": {},
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.sort_values(by='pl', ascending=True)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 519
        },
        "id": "dYw-AbYxMjNB",
        "outputId": "7d4a8a0b-70f2-4112-e646-b218da987c24"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Multiples  cotacao        pl       pvp     psr      dy     pa    pcg   pebit  \\\n",
              "papel                                                                          \n",
              "GNDI3        66.95  -3584.82      5.84   3.423  0.0239  2.378  79.65   87.05   \n",
              "TRAD3         4.35  -1355.27      2.08  11.880  0.0000  1.989   5.08  -19.34   \n",
              "PLDN4       486.00   -553.07      1.08   0.919  0.0000  0.611   1.07  -75.56   \n",
              "MGLU3         4.29   -484.01      2.65   0.819  0.0000  0.839   3.71  103.08   \n",
              "EMBR3        13.50   -469.33      0.70   0.490  0.0000  0.197   0.70    6.02   \n",
              "...            ...       ...       ...     ...     ...    ...    ...     ...   \n",
              "UBBR11       14.75   1201.81      3.91   0.000  0.0000  0.000   0.00    0.00   \n",
              "UBBR3        18.00   1466.61      4.77   0.000  0.0000  0.000   0.00    0.00   \n",
              "CALI4        50.00   4770.51     39.82   2.493  0.0086  0.803   1.62   51.65   \n",
              "BBTG12        3.15  29554.00  24180.60   0.000  0.0000  0.000   0.00    0.00   \n",
              "AERI3         2.53  38770.40      2.00   0.805  0.0082  0.580   1.47   10.96   \n",
              "\n",
              "Multiples   pacl  evebit  evebitda  mrgebit  mrgliq    roic     roe   liqc  \\\n",
              "papel                                                                        \n",
              "GNDI3      -6.21   91.13     50.88   0.0393 -0.0009  0.0309 -0.0016   1.17   \n",
              "TRAD3       5.13  -15.69    -20.29  -0.6144 -0.0083 -0.1674 -0.0015  11.19   \n",
              "PLDN4       3.10  -33.12    -33.12  -0.0122 -0.0017 -0.0127 -0.0020  10.81   \n",
              "MGLU3      -8.28  120.62     27.09   0.0079 -0.0017  0.0111 -0.0055   1.64   \n",
              "EMBR3      -1.31   10.34      6.48   0.0813 -0.0007  0.0442 -0.0015   2.03   \n",
              "...          ...     ...       ...      ...     ...     ...     ...    ...   \n",
              "UBBR11      0.00    0.00      0.00   0.0000  0.0000  0.0000  0.0033   0.00   \n",
              "UBBR3       0.00    0.00      0.00   0.0000  0.0000  0.0000  0.0033   0.00   \n",
              "CALI4      -2.75   82.60     76.25   0.0483  0.0005  0.0179  0.0083   3.58   \n",
              "BBTG12      0.00    0.00      0.00   0.0000  0.0000  0.0000  0.8182   0.00   \n",
              "AERI3     -10.75   15.46     12.19   0.0735  0.0000  0.0966  0.0001   2.49   \n",
              "\n",
              "Multiples        liq2m       patrliq  divbpatr     c5y  \n",
              "papel                                                   \n",
              "GNDI3              0.0  7.116080e+09      0.53  0.2523  \n",
              "TRAD3        4287570.0  5.897110e+08      0.01  0.0000  \n",
              "PLDN4              0.0  2.899390e+08      0.01  0.1026  \n",
              "MGLU3      662764000.0  1.093780e+10      0.63  0.3005  \n",
              "EMBR3       79165400.0  1.435570e+10      1.15  0.0883  \n",
              "...                ...           ...       ...     ...  \n",
              "UBBR11             0.0  1.031720e+10      0.00  0.1058  \n",
              "UBBR3              0.0  1.031720e+10      0.00  0.1058  \n",
              "CALI4              0.0  4.672000e+06     26.54  1.0787  \n",
              "BBTG12             0.0  1.100000e+04      0.00  0.0000  \n",
              "AERI3       10065000.0  9.673940e+08      1.71  0.0000  \n",
              "\n",
              "[968 rows x 20 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-c09b16cb-5206-448f-bb9a-fbcf86bde0e6\">\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>Multiples</th>\n",
              "      <th>cotacao</th>\n",
              "      <th>pl</th>\n",
              "      <th>pvp</th>\n",
              "      <th>psr</th>\n",
              "      <th>dy</th>\n",
              "      <th>pa</th>\n",
              "      <th>pcg</th>\n",
              "      <th>pebit</th>\n",
              "      <th>pacl</th>\n",
              "      <th>evebit</th>\n",
              "      <th>evebitda</th>\n",
              "      <th>mrgebit</th>\n",
              "      <th>mrgliq</th>\n",
              "      <th>roic</th>\n",
              "      <th>roe</th>\n",
              "      <th>liqc</th>\n",
              "      <th>liq2m</th>\n",
              "      <th>patrliq</th>\n",
              "      <th>divbpatr</th>\n",
              "      <th>c5y</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>papel</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>GNDI3</th>\n",
              "      <td>66.95</td>\n",
              "      <td>-3584.82</td>\n",
              "      <td>5.84</td>\n",
              "      <td>3.423</td>\n",
              "      <td>0.0239</td>\n",
              "      <td>2.378</td>\n",
              "      <td>79.65</td>\n",
              "      <td>87.05</td>\n",
              "      <td>-6.21</td>\n",
              "      <td>91.13</td>\n",
              "      <td>50.88</td>\n",
              "      <td>0.0393</td>\n",
              "      <td>-0.0009</td>\n",
              "      <td>0.0309</td>\n",
              "      <td>-0.0016</td>\n",
              "      <td>1.17</td>\n",
              "      <td>0.0</td>\n",
              "      <td>7.116080e+09</td>\n",
              "      <td>0.53</td>\n",
              "      <td>0.2523</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>TRAD3</th>\n",
              "      <td>4.35</td>\n",
              "      <td>-1355.27</td>\n",
              "      <td>2.08</td>\n",
              "      <td>11.880</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>1.989</td>\n",
              "      <td>5.08</td>\n",
              "      <td>-19.34</td>\n",
              "      <td>5.13</td>\n",
              "      <td>-15.69</td>\n",
              "      <td>-20.29</td>\n",
              "      <td>-0.6144</td>\n",
              "      <td>-0.0083</td>\n",
              "      <td>-0.1674</td>\n",
              "      <td>-0.0015</td>\n",
              "      <td>11.19</td>\n",
              "      <td>4287570.0</td>\n",
              "      <td>5.897110e+08</td>\n",
              "      <td>0.01</td>\n",
              "      <td>0.0000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PLDN4</th>\n",
              "      <td>486.00</td>\n",
              "      <td>-553.07</td>\n",
              "      <td>1.08</td>\n",
              "      <td>0.919</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.611</td>\n",
              "      <td>1.07</td>\n",
              "      <td>-75.56</td>\n",
              "      <td>3.10</td>\n",
              "      <td>-33.12</td>\n",
              "      <td>-33.12</td>\n",
              "      <td>-0.0122</td>\n",
              "      <td>-0.0017</td>\n",
              "      <td>-0.0127</td>\n",
              "      <td>-0.0020</td>\n",
              "      <td>10.81</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2.899390e+08</td>\n",
              "      <td>0.01</td>\n",
              "      <td>0.1026</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MGLU3</th>\n",
              "      <td>4.29</td>\n",
              "      <td>-484.01</td>\n",
              "      <td>2.65</td>\n",
              "      <td>0.819</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.839</td>\n",
              "      <td>3.71</td>\n",
              "      <td>103.08</td>\n",
              "      <td>-8.28</td>\n",
              "      <td>120.62</td>\n",
              "      <td>27.09</td>\n",
              "      <td>0.0079</td>\n",
              "      <td>-0.0017</td>\n",
              "      <td>0.0111</td>\n",
              "      <td>-0.0055</td>\n",
              "      <td>1.64</td>\n",
              "      <td>662764000.0</td>\n",
              "      <td>1.093780e+10</td>\n",
              "      <td>0.63</td>\n",
              "      <td>0.3005</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>EMBR3</th>\n",
              "      <td>13.50</td>\n",
              "      <td>-469.33</td>\n",
              "      <td>0.70</td>\n",
              "      <td>0.490</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.197</td>\n",
              "      <td>0.70</td>\n",
              "      <td>6.02</td>\n",
              "      <td>-1.31</td>\n",
              "      <td>10.34</td>\n",
              "      <td>6.48</td>\n",
              "      <td>0.0813</td>\n",
              "      <td>-0.0007</td>\n",
              "      <td>0.0442</td>\n",
              "      <td>-0.0015</td>\n",
              "      <td>2.03</td>\n",
              "      <td>79165400.0</td>\n",
              "      <td>1.435570e+10</td>\n",
              "      <td>1.15</td>\n",
              "      <td>0.0883</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>UBBR11</th>\n",
              "      <td>14.75</td>\n",
              "      <td>1201.81</td>\n",
              "      <td>3.91</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0033</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.031720e+10</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.1058</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>UBBR3</th>\n",
              "      <td>18.00</td>\n",
              "      <td>1466.61</td>\n",
              "      <td>4.77</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0033</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.031720e+10</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.1058</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CALI4</th>\n",
              "      <td>50.00</td>\n",
              "      <td>4770.51</td>\n",
              "      <td>39.82</td>\n",
              "      <td>2.493</td>\n",
              "      <td>0.0086</td>\n",
              "      <td>0.803</td>\n",
              "      <td>1.62</td>\n",
              "      <td>51.65</td>\n",
              "      <td>-2.75</td>\n",
              "      <td>82.60</td>\n",
              "      <td>76.25</td>\n",
              "      <td>0.0483</td>\n",
              "      <td>0.0005</td>\n",
              "      <td>0.0179</td>\n",
              "      <td>0.0083</td>\n",
              "      <td>3.58</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4.672000e+06</td>\n",
              "      <td>26.54</td>\n",
              "      <td>1.0787</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BBTG12</th>\n",
              "      <td>3.15</td>\n",
              "      <td>29554.00</td>\n",
              "      <td>24180.60</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.8182</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.100000e+04</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>AERI3</th>\n",
              "      <td>2.53</td>\n",
              "      <td>38770.40</td>\n",
              "      <td>2.00</td>\n",
              "      <td>0.805</td>\n",
              "      <td>0.0082</td>\n",
              "      <td>0.580</td>\n",
              "      <td>1.47</td>\n",
              "      <td>10.96</td>\n",
              "      <td>-10.75</td>\n",
              "      <td>15.46</td>\n",
              "      <td>12.19</td>\n",
              "      <td>0.0735</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0966</td>\n",
              "      <td>0.0001</td>\n",
              "      <td>2.49</td>\n",
              "      <td>10065000.0</td>\n",
              "      <td>9.673940e+08</td>\n",
              "      <td>1.71</td>\n",
              "      <td>0.0000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>968 rows × 20 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-c09b16cb-5206-448f-bb9a-fbcf86bde0e6')\"\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-c09b16cb-5206-448f-bb9a-fbcf86bde0e6 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-c09b16cb-5206-448f-bb9a-fbcf86bde0e6');\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": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#loc localiza linhas e colunas pelo seu label\n",
        "df.loc['GNDI3']"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "uM7Q5EN4M4vg",
        "outputId": "8541541a-0a31-40f3-8f92-e6d83d75da4b"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Multiples\n",
              "cotacao     6.695000e+01\n",
              "pl         -3.584820e+03\n",
              "pvp         5.840000e+00\n",
              "psr         3.423000e+00\n",
              "dy          2.390000e-02\n",
              "pa          2.378000e+00\n",
              "pcg         7.965000e+01\n",
              "pebit       8.705000e+01\n",
              "pacl       -6.210000e+00\n",
              "evebit      9.113000e+01\n",
              "evebitda    5.088000e+01\n",
              "mrgebit     3.930000e-02\n",
              "mrgliq     -9.000000e-04\n",
              "roic        3.090000e-02\n",
              "roe        -1.600000e-03\n",
              "liqc        1.170000e+00\n",
              "liq2m       0.000000e+00\n",
              "patrliq     7.116080e+09\n",
              "divbpatr    5.300000e-01\n",
              "c5y         2.523000e-01\n",
              "Name: GNDI3, dtype: float64"
            ]
          },
          "metadata": {},
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.loc[['GNDI3'],['pl']]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 112
        },
        "id": "TlDAFhF4NXoQ",
        "outputId": "359d8f3d-044d-461d-81e9-aba909b5006e"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Multiples       pl\n",
              "papel             \n",
              "GNDI3     -3584.82"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-3a19e4e8-1ad1-41be-bbf0-5d3b596e865d\">\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>Multiples</th>\n",
              "      <th>pl</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>papel</th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>GNDI3</th>\n",
              "      <td>-3584.82</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-3a19e4e8-1ad1-41be-bbf0-5d3b596e865d')\"\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-3a19e4e8-1ad1-41be-bbf0-5d3b596e865d 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-3a19e4e8-1ad1-41be-bbf0-5d3b596e865d');\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": 17
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#iloc localiza linha e coluna pela sua posição, lembre-se python inicia a indexação em 0 (primeira posição)\n",
        "df.iloc[[0],[0]]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 112
        },
        "id": "zz1iR1fxNf8Y",
        "outputId": "119c71b1-d882-4304-aa59-4ac4364b3997"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Multiples  cotacao\n",
              "papel             \n",
              "AALR3         19.7"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-556c0523-8484-4572-8a47-31dbd57e6709\">\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>Multiples</th>\n",
              "      <th>cotacao</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>papel</th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>AALR3</th>\n",
              "      <td>19.7</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-556c0523-8484-4572-8a47-31dbd57e6709')\"\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-556c0523-8484-4572-8a47-31dbd57e6709 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-556c0523-8484-4572-8a47-31dbd57e6709');\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": 18
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.loc[['GNDI3', 'MELK3'],['dy']]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 143
        },
        "id": "3U_CpUmCNqZI",
        "outputId": "3a5d5f5c-7165-40ab-d170-10a8d67edacc"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Multiples      dy\n",
              "papel            \n",
              "GNDI3      0.0239\n",
              "MELK3      0.1029"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-c0d32d0c-e8f5-44b4-8af5-25ae6d70b265\">\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>Multiples</th>\n",
              "      <th>dy</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>papel</th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>GNDI3</th>\n",
              "      <td>0.0239</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MELK3</th>\n",
              "      <td>0.1029</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-c0d32d0c-e8f5-44b4-8af5-25ae6d70b265')\"\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-c0d32d0c-e8f5-44b4-8af5-25ae6d70b265 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-c0d32d0c-e8f5-44b4-8af5-25ae6d70b265');\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": "code",
      "source": [
        "#exemplo de slicing com loc, lembre-se da estrutura linha (i) coluna (j), df.loc[[i],[j]] \n",
        "\n",
        "df.loc['GNDI3':'GPAR3', 'pl':'pa']"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 238
        },
        "id": "410smmc5N4co",
        "outputId": "de6f042d-d5d0-4ed6-f2cb-d8236a3a623f"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Multiples       pl   pvp     psr      dy     pa\n",
              "papel                                          \n",
              "GNDI3     -3584.82  5.84   3.423  0.0239  2.378\n",
              "GOAU3         1.90  0.64   0.121  0.2604  0.133\n",
              "GOAU4         2.00  0.68   0.128  0.2473  0.140\n",
              "GOLL4        -0.75 -0.21   0.371  0.0000  0.255\n",
              "GPAR3         3.67  2.66  14.650  0.3967  1.251"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-2b66ad56-13cd-4ea8-8e8d-f04c5ad25372\">\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>Multiples</th>\n",
              "      <th>pl</th>\n",
              "      <th>pvp</th>\n",
              "      <th>psr</th>\n",
              "      <th>dy</th>\n",
              "      <th>pa</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>papel</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>GNDI3</th>\n",
              "      <td>-3584.82</td>\n",
              "      <td>5.84</td>\n",
              "      <td>3.423</td>\n",
              "      <td>0.0239</td>\n",
              "      <td>2.378</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>GOAU3</th>\n",
              "      <td>1.90</td>\n",
              "      <td>0.64</td>\n",
              "      <td>0.121</td>\n",
              "      <td>0.2604</td>\n",
              "      <td>0.133</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>GOAU4</th>\n",
              "      <td>2.00</td>\n",
              "      <td>0.68</td>\n",
              "      <td>0.128</td>\n",
              "      <td>0.2473</td>\n",
              "      <td>0.140</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>GOLL4</th>\n",
              "      <td>-0.75</td>\n",
              "      <td>-0.21</td>\n",
              "      <td>0.371</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.255</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>GPAR3</th>\n",
              "      <td>3.67</td>\n",
              "      <td>2.66</td>\n",
              "      <td>14.650</td>\n",
              "      <td>0.3967</td>\n",
              "      <td>1.251</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-2b66ad56-13cd-4ea8-8e8d-f04c5ad25372')\"\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-2b66ad56-13cd-4ea8-8e8d-f04c5ad25372 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-2b66ad56-13cd-4ea8-8e8d-f04c5ad25372');\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": 20
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#filtros usados em conjunto através do operador & \n",
        "\n",
        "df[(df.pl > 15) & (df.dy > 0.05)]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 521
        },
        "id": "dh3_magBOHR4",
        "outputId": "2c20e99d-bf4e-479e-9d05-25ea968aaa72"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Multiples  cotacao      pl   pvp         psr      dy     pa    pcg   pebit  \\\n",
              "papel                                                                        \n",
              "B3SA3        13.00   17.77  3.84       7.929  0.0545  1.673  13.06   13.80   \n",
              "BRGE6         8.50   18.03  0.49     150.769  0.0890  0.198   0.55   -1.00   \n",
              "DESK3        11.10   29.70  1.08       1.781  4.0000  0.403 -16.12    8.24   \n",
              "EEEL3       421.01   33.42  1.87       3.856  0.2999  0.866   3.78    7.72   \n",
              "EEEL4       410.00   32.55  1.82       3.755  0.3387  0.844   3.68    7.52   \n",
              "EGIE3        40.35   18.76  4.16       2.695  0.0555  0.830  14.79    5.46   \n",
              "LCAM3        24.15   17.42  2.47       1.726  0.0608  0.575   5.09    5.57   \n",
              "MOAR3       473.00  106.60  6.95  125972.000  0.0992  2.887   9.28 -160.07   \n",
              "MTRE3         5.15   19.45  0.55       0.841  0.0553  0.302   0.60   11.26   \n",
              "PSSA3        21.17   15.22  1.45       0.568  0.0571  0.298   5.03    0.69   \n",
              "RPAD5         7.10   20.49  0.57       0.000  0.0795  0.567   9.76 -143.77   \n",
              "STBP3         8.76   20.07  3.21       4.248  0.0773  1.496   9.44   15.46   \n",
              "\n",
              "Multiples   pacl  evebit  evebitda   mrgebit     mrgliq    roic     roe  \\\n",
              "papel                                                                     \n",
              "B3SA3      -7.92   13.37     11.27    0.5744     0.4461  0.1792  0.2160   \n",
              "BRGE6       1.31    1.36      1.37 -150.8160    10.4181 -0.3707  0.0273   \n",
              "DESK3      -1.01   12.28      6.98    0.2161     0.0758  0.0611  0.0363   \n",
              "EEEL3      -7.64    7.26      7.08    0.4994     0.1041  0.1386  0.0559   \n",
              "EEEL4      -7.44    7.06      6.88    0.4994     0.1041  0.1386  0.0559   \n",
              "EGIE3      -1.38    8.16      6.92    0.4939     0.1438  0.1737  0.2215   \n",
              "LCAM3      -1.38    9.94      7.57    0.3100     0.0991  0.1354  0.1421   \n",
              "MOAR3     -19.13 -161.09   -164.63 -787.0000  1181.7400 -0.0307  0.0652   \n",
              "MTRE3       1.13   12.34     10.98    0.0747     0.0488  0.0315  0.0284   \n",
              "PSSA3      -1.91    0.22      0.21    0.8229     0.0374  0.5425  0.0956   \n",
              "RPAD5       9.78 -128.38   -128.38    0.0000     0.0000 -0.0042  0.0278   \n",
              "STBP3      -5.42   14.08      9.86    0.2747     0.2117  0.1250  0.1601   \n",
              "\n",
              "Multiples   liqc         liq2m       patrliq  divbpatr     c5y  \n",
              "papel                                                           \n",
              "B3SA3       1.57  4.627960e+08  2.065320e+10      0.61  0.2573  \n",
              "BRGE6       2.62  3.415800e+02  1.271290e+09      0.00 -0.4093  \n",
              "DESK3       0.90  2.882030e+06  8.968280e+08      0.99  0.0000  \n",
              "EEEL3       2.19  0.000000e+00  2.177320e+09      0.26  0.0309  \n",
              "EEEL4       2.19  0.000000e+00  2.177320e+09      0.26  0.0309  \n",
              "EGIE3       1.40  7.556260e+07  7.923410e+09      2.60  0.1363  \n",
              "LCAM3       1.48  0.000000e+00  4.965670e+09      2.38  0.3855  \n",
              "MOAR3       3.53  2.216470e+05  8.334080e+08      1.04 -0.3299  \n",
              "MTRE3       3.41  2.213570e+06  9.849940e+08      0.29  0.4799  \n",
              "PSSA3       1.10  4.195490e+07  9.409950e+09      0.00  0.0769  \n",
              "RPAD5      16.08  1.317230e+03  1.056030e+09      0.00 -0.1630  \n",
              "STBP3       2.59  2.642410e+07  2.355220e+09      0.14  0.1793  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-1c615932-aa9b-4525-bb23-782829b7b856\">\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>Multiples</th>\n",
              "      <th>cotacao</th>\n",
              "      <th>pl</th>\n",
              "      <th>pvp</th>\n",
              "      <th>psr</th>\n",
              "      <th>dy</th>\n",
              "      <th>pa</th>\n",
              "      <th>pcg</th>\n",
              "      <th>pebit</th>\n",
              "      <th>pacl</th>\n",
              "      <th>evebit</th>\n",
              "      <th>evebitda</th>\n",
              "      <th>mrgebit</th>\n",
              "      <th>mrgliq</th>\n",
              "      <th>roic</th>\n",
              "      <th>roe</th>\n",
              "      <th>liqc</th>\n",
              "      <th>liq2m</th>\n",
              "      <th>patrliq</th>\n",
              "      <th>divbpatr</th>\n",
              "      <th>c5y</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>papel</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>B3SA3</th>\n",
              "      <td>13.00</td>\n",
              "      <td>17.77</td>\n",
              "      <td>3.84</td>\n",
              "      <td>7.929</td>\n",
              "      <td>0.0545</td>\n",
              "      <td>1.673</td>\n",
              "      <td>13.06</td>\n",
              "      <td>13.80</td>\n",
              "      <td>-7.92</td>\n",
              "      <td>13.37</td>\n",
              "      <td>11.27</td>\n",
              "      <td>0.5744</td>\n",
              "      <td>0.4461</td>\n",
              "      <td>0.1792</td>\n",
              "      <td>0.2160</td>\n",
              "      <td>1.57</td>\n",
              "      <td>4.627960e+08</td>\n",
              "      <td>2.065320e+10</td>\n",
              "      <td>0.61</td>\n",
              "      <td>0.2573</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BRGE6</th>\n",
              "      <td>8.50</td>\n",
              "      <td>18.03</td>\n",
              "      <td>0.49</td>\n",
              "      <td>150.769</td>\n",
              "      <td>0.0890</td>\n",
              "      <td>0.198</td>\n",
              "      <td>0.55</td>\n",
              "      <td>-1.00</td>\n",
              "      <td>1.31</td>\n",
              "      <td>1.36</td>\n",
              "      <td>1.37</td>\n",
              "      <td>-150.8160</td>\n",
              "      <td>10.4181</td>\n",
              "      <td>-0.3707</td>\n",
              "      <td>0.0273</td>\n",
              "      <td>2.62</td>\n",
              "      <td>3.415800e+02</td>\n",
              "      <td>1.271290e+09</td>\n",
              "      <td>0.00</td>\n",
              "      <td>-0.4093</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>DESK3</th>\n",
              "      <td>11.10</td>\n",
              "      <td>29.70</td>\n",
              "      <td>1.08</td>\n",
              "      <td>1.781</td>\n",
              "      <td>4.0000</td>\n",
              "      <td>0.403</td>\n",
              "      <td>-16.12</td>\n",
              "      <td>8.24</td>\n",
              "      <td>-1.01</td>\n",
              "      <td>12.28</td>\n",
              "      <td>6.98</td>\n",
              "      <td>0.2161</td>\n",
              "      <td>0.0758</td>\n",
              "      <td>0.0611</td>\n",
              "      <td>0.0363</td>\n",
              "      <td>0.90</td>\n",
              "      <td>2.882030e+06</td>\n",
              "      <td>8.968280e+08</td>\n",
              "      <td>0.99</td>\n",
              "      <td>0.0000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>EEEL3</th>\n",
              "      <td>421.01</td>\n",
              "      <td>33.42</td>\n",
              "      <td>1.87</td>\n",
              "      <td>3.856</td>\n",
              "      <td>0.2999</td>\n",
              "      <td>0.866</td>\n",
              "      <td>3.78</td>\n",
              "      <td>7.72</td>\n",
              "      <td>-7.64</td>\n",
              "      <td>7.26</td>\n",
              "      <td>7.08</td>\n",
              "      <td>0.4994</td>\n",
              "      <td>0.1041</td>\n",
              "      <td>0.1386</td>\n",
              "      <td>0.0559</td>\n",
              "      <td>2.19</td>\n",
              "      <td>0.000000e+00</td>\n",
              "      <td>2.177320e+09</td>\n",
              "      <td>0.26</td>\n",
              "      <td>0.0309</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>EEEL4</th>\n",
              "      <td>410.00</td>\n",
              "      <td>32.55</td>\n",
              "      <td>1.82</td>\n",
              "      <td>3.755</td>\n",
              "      <td>0.3387</td>\n",
              "      <td>0.844</td>\n",
              "      <td>3.68</td>\n",
              "      <td>7.52</td>\n",
              "      <td>-7.44</td>\n",
              "      <td>7.06</td>\n",
              "      <td>6.88</td>\n",
              "      <td>0.4994</td>\n",
              "      <td>0.1041</td>\n",
              "      <td>0.1386</td>\n",
              "      <td>0.0559</td>\n",
              "      <td>2.19</td>\n",
              "      <td>0.000000e+00</td>\n",
              "      <td>2.177320e+09</td>\n",
              "      <td>0.26</td>\n",
              "      <td>0.0309</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>EGIE3</th>\n",
              "      <td>40.35</td>\n",
              "      <td>18.76</td>\n",
              "      <td>4.16</td>\n",
              "      <td>2.695</td>\n",
              "      <td>0.0555</td>\n",
              "      <td>0.830</td>\n",
              "      <td>14.79</td>\n",
              "      <td>5.46</td>\n",
              "      <td>-1.38</td>\n",
              "      <td>8.16</td>\n",
              "      <td>6.92</td>\n",
              "      <td>0.4939</td>\n",
              "      <td>0.1438</td>\n",
              "      <td>0.1737</td>\n",
              "      <td>0.2215</td>\n",
              "      <td>1.40</td>\n",
              "      <td>7.556260e+07</td>\n",
              "      <td>7.923410e+09</td>\n",
              "      <td>2.60</td>\n",
              "      <td>0.1363</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>LCAM3</th>\n",
              "      <td>24.15</td>\n",
              "      <td>17.42</td>\n",
              "      <td>2.47</td>\n",
              "      <td>1.726</td>\n",
              "      <td>0.0608</td>\n",
              "      <td>0.575</td>\n",
              "      <td>5.09</td>\n",
              "      <td>5.57</td>\n",
              "      <td>-1.38</td>\n",
              "      <td>9.94</td>\n",
              "      <td>7.57</td>\n",
              "      <td>0.3100</td>\n",
              "      <td>0.0991</td>\n",
              "      <td>0.1354</td>\n",
              "      <td>0.1421</td>\n",
              "      <td>1.48</td>\n",
              "      <td>0.000000e+00</td>\n",
              "      <td>4.965670e+09</td>\n",
              "      <td>2.38</td>\n",
              "      <td>0.3855</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MOAR3</th>\n",
              "      <td>473.00</td>\n",
              "      <td>106.60</td>\n",
              "      <td>6.95</td>\n",
              "      <td>125972.000</td>\n",
              "      <td>0.0992</td>\n",
              "      <td>2.887</td>\n",
              "      <td>9.28</td>\n",
              "      <td>-160.07</td>\n",
              "      <td>-19.13</td>\n",
              "      <td>-161.09</td>\n",
              "      <td>-164.63</td>\n",
              "      <td>-787.0000</td>\n",
              "      <td>1181.7400</td>\n",
              "      <td>-0.0307</td>\n",
              "      <td>0.0652</td>\n",
              "      <td>3.53</td>\n",
              "      <td>2.216470e+05</td>\n",
              "      <td>8.334080e+08</td>\n",
              "      <td>1.04</td>\n",
              "      <td>-0.3299</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MTRE3</th>\n",
              "      <td>5.15</td>\n",
              "      <td>19.45</td>\n",
              "      <td>0.55</td>\n",
              "      <td>0.841</td>\n",
              "      <td>0.0553</td>\n",
              "      <td>0.302</td>\n",
              "      <td>0.60</td>\n",
              "      <td>11.26</td>\n",
              "      <td>1.13</td>\n",
              "      <td>12.34</td>\n",
              "      <td>10.98</td>\n",
              "      <td>0.0747</td>\n",
              "      <td>0.0488</td>\n",
              "      <td>0.0315</td>\n",
              "      <td>0.0284</td>\n",
              "      <td>3.41</td>\n",
              "      <td>2.213570e+06</td>\n",
              "      <td>9.849940e+08</td>\n",
              "      <td>0.29</td>\n",
              "      <td>0.4799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PSSA3</th>\n",
              "      <td>21.17</td>\n",
              "      <td>15.22</td>\n",
              "      <td>1.45</td>\n",
              "      <td>0.568</td>\n",
              "      <td>0.0571</td>\n",
              "      <td>0.298</td>\n",
              "      <td>5.03</td>\n",
              "      <td>0.69</td>\n",
              "      <td>-1.91</td>\n",
              "      <td>0.22</td>\n",
              "      <td>0.21</td>\n",
              "      <td>0.8229</td>\n",
              "      <td>0.0374</td>\n",
              "      <td>0.5425</td>\n",
              "      <td>0.0956</td>\n",
              "      <td>1.10</td>\n",
              "      <td>4.195490e+07</td>\n",
              "      <td>9.409950e+09</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0769</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>RPAD5</th>\n",
              "      <td>7.10</td>\n",
              "      <td>20.49</td>\n",
              "      <td>0.57</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.0795</td>\n",
              "      <td>0.567</td>\n",
              "      <td>9.76</td>\n",
              "      <td>-143.77</td>\n",
              "      <td>9.78</td>\n",
              "      <td>-128.38</td>\n",
              "      <td>-128.38</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>-0.0042</td>\n",
              "      <td>0.0278</td>\n",
              "      <td>16.08</td>\n",
              "      <td>1.317230e+03</td>\n",
              "      <td>1.056030e+09</td>\n",
              "      <td>0.00</td>\n",
              "      <td>-0.1630</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>STBP3</th>\n",
              "      <td>8.76</td>\n",
              "      <td>20.07</td>\n",
              "      <td>3.21</td>\n",
              "      <td>4.248</td>\n",
              "      <td>0.0773</td>\n",
              "      <td>1.496</td>\n",
              "      <td>9.44</td>\n",
              "      <td>15.46</td>\n",
              "      <td>-5.42</td>\n",
              "      <td>14.08</td>\n",
              "      <td>9.86</td>\n",
              "      <td>0.2747</td>\n",
              "      <td>0.2117</td>\n",
              "      <td>0.1250</td>\n",
              "      <td>0.1601</td>\n",
              "      <td>2.59</td>\n",
              "      <td>2.642410e+07</td>\n",
              "      <td>2.355220e+09</td>\n",
              "      <td>0.14</td>\n",
              "      <td>0.1793</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1c615932-aa9b-4525-bb23-782829b7b856')\"\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-1c615932-aa9b-4525-bb23-782829b7b856 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-1c615932-aa9b-4525-bb23-782829b7b856');\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": 21
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.loc[:,['pl']] > 10"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 455
        },
        "id": "fJ9ZGyZBOQ7I",
        "outputId": "e3ca68dd-7163-4035-e542-6e9bccb08509"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Multiples     pl\n",
              "papel           \n",
              "AALR3      False\n",
              "ABCB3      False\n",
              "ABCB4      False\n",
              "ABEV3       True\n",
              "ABYA3      False\n",
              "...          ...\n",
              "WLMM3      False\n",
              "WLMM4       True\n",
              "WMBY3      False\n",
              "WSON33     False\n",
              "YDUQ3       True\n",
              "\n",
              "[968 rows x 1 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-210a0ddb-c176-45d7-a7e4-dd238e81d79a\">\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>Multiples</th>\n",
              "      <th>pl</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>papel</th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>AALR3</th>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ABCB3</th>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ABCB4</th>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ABEV3</th>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ABYA3</th>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>WLMM3</th>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>WLMM4</th>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>WMBY3</th>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>WSON33</th>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>YDUQ3</th>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>968 rows × 1 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-210a0ddb-c176-45d7-a7e4-dd238e81d79a')\"\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-210a0ddb-c176-45d7-a7e4-dd238e81d79a 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-210a0ddb-c176-45d7-a7e4-dd238e81d79a');\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": 22
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "##Exercício\n",
        "\n",
        "Criar um gráfico que sumarize um grupo de métricas fundamentalistas de um determinado setor"
      ],
      "metadata": {
        "id": "4VODNwyYPPLT"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#lista de empresas através do código do setor\n",
        "\n",
        "fundamentus.list_papel_setor(8)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "jaAojsTLO8aX",
        "outputId": "20026ffa-c64b-4e5c-9aaa-bff65d642e22"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['PCAR3',\n",
              " 'PFRM3',\n",
              " 'DMVF3',\n",
              " 'ASAI3',\n",
              " 'CRFB3',\n",
              " 'GMAT3',\n",
              " 'VVEO3',\n",
              " 'PGMN3',\n",
              " 'BLAU3',\n",
              " 'HYPE3',\n",
              " 'PNVL3',\n",
              " 'RADL3']"
            ]
          },
          "metadata": {},
          "execution_count": 40
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "setor = fundamentus.list_papel_setor(8)\n",
        "setor"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "bC-gzwGaPl3n",
        "outputId": "3faa0c61-5868-469f-dd3a-3712b10cce80"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['PCAR3',\n",
              " 'PFRM3',\n",
              " 'DMVF3',\n",
              " 'ASAI3',\n",
              " 'CRFB3',\n",
              " 'GMAT3',\n",
              " 'VVEO3',\n",
              " 'PGMN3',\n",
              " 'BLAU3',\n",
              " 'HYPE3',\n",
              " 'PNVL3',\n",
              " 'RADL3']"
            ]
          },
          "metadata": {},
          "execution_count": 24
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.query('index in @setor')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 521
        },
        "id": "_vvIMjFWQK7O",
        "outputId": "f3b4cc81-85c4-4c08-c6b1-391509c4af36"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Multiples  cotacao     pl   pvp    psr      dy     pa    pcg  pebit    pacl  \\\n",
              "papel                                                                         \n",
              "ASAI3        19.10  16.12  7.78  0.546  0.0090  0.770 -44.87   7.32   -1.31   \n",
              "BLAU3        32.99  18.88  3.44  4.390  0.0222  2.483   4.55  14.09    5.74   \n",
              "CRFB3        20.32  16.16  2.14  0.491  0.0270  0.539 -15.09  10.04   -1.80   \n",
              "DMVF3         5.00  13.71  0.30  0.193  0.0000  0.175   3.94   2.51   -1.24   \n",
              "GMAT3         6.51  16.52  2.10  0.774  0.0000  1.258   3.05  13.11    5.55   \n",
              "HYPE3        43.44  20.27  2.70  4.139  0.0284  1.315   9.86  12.55   -6.41   \n",
              "PCAR3        22.00   3.10  0.42  0.126  0.0161  0.129   7.10   1.81   -0.43   \n",
              "PFRM3         3.72   4.82  0.40  0.066  0.0727  0.107   0.50   1.60    3.10   \n",
              "PGMN3         5.14  17.83  1.05  0.289  0.0000  0.354   1.96   6.48   -2.26   \n",
              "PNVL3        12.12  22.01  1.69  0.509  0.0156  0.728   2.81  19.31 -135.10   \n",
              "RADL3        22.68  45.67  7.47  1.420  0.0110  2.317  11.54  24.87  -17.35   \n",
              "VVEO3        17.50  17.53  2.24  0.719  0.0232  0.707   2.71  13.14   -6.59   \n",
              "\n",
              "Multiples  evebit  evebitda  mrgebit  mrgliq    roic     roe  liqc  \\\n",
              "papel                                                                \n",
              "ASAI3        9.67      7.85   0.0746  0.0339  0.1504  0.4826  0.95   \n",
              "BLAU3       12.94     12.31   0.3115  0.2311  0.2926  0.1821  4.30   \n",
              "CRFB3       13.29     10.08   0.0489  0.0332  0.0699  0.1327  0.92   \n",
              "DMVF3        2.20      1.11   0.0770  0.0141  0.0854  0.0219  1.19   \n",
              "GMAT3       14.41     11.33   0.0591  0.0476  0.1229  0.1269  2.98   \n",
              "HYPE3       15.53     14.56   0.3298  0.2042  0.1153  0.1330  1.77   \n",
              "PCAR3        3.21      2.02   0.0694  0.0446  0.0934  0.1341  1.06   \n",
              "PFRM3        4.53      3.08   0.0408  0.0147  0.0944  0.0820  1.46   \n",
              "PGMN3        8.32      4.41   0.0446  0.0162  0.0723  0.0589  1.55   \n",
              "PNVL3       27.20      9.47   0.0263  0.0231  0.0465  0.0767  1.85   \n",
              "RADL3       25.90     13.45   0.0571  0.0319  0.1276  0.1636  1.57   \n",
              "VVEO3       16.37     12.18   0.0547  0.0410  0.0775  0.1279  1.82   \n",
              "\n",
              "Multiples        liq2m       patrliq  divbpatr     c5y  \n",
              "papel                                                   \n",
              "ASAI3      144645000.0  3.311000e+09      3.43  0.6182  \n",
              "BLAU3       15169800.0  1.720940e+09      0.18  0.1446  \n",
              "CRFB3       73833100.0  1.993600e+10      0.89  0.1406  \n",
              "DMVF3         432491.0  8.432170e+08      0.05  0.2654  \n",
              "GMAT3       37806700.0  6.861070e+09      0.34  0.2924  \n",
              "HYPE3      112642000.0  1.020800e+10      0.79  0.1717  \n",
              "PCAR3       63080000.0  1.426900e+10      0.59 -0.0361  \n",
              "PFRM3         718234.0  1.165640e+09      0.89  0.1491  \n",
              "PGMN3        6385390.0  2.172580e+09      0.46  0.0796  \n",
              "PNVL3        6603170.0  1.079580e+09      0.81  0.1145  \n",
              "RADL3      128497000.0  5.014180e+09      0.47  0.1736  \n",
              "VVEO3        3567390.0  2.232320e+09      0.88  0.0000  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-3d63d0c6-9411-4b7f-9821-8ea4c27ecfaa\">\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>Multiples</th>\n",
              "      <th>cotacao</th>\n",
              "      <th>pl</th>\n",
              "      <th>pvp</th>\n",
              "      <th>psr</th>\n",
              "      <th>dy</th>\n",
              "      <th>pa</th>\n",
              "      <th>pcg</th>\n",
              "      <th>pebit</th>\n",
              "      <th>pacl</th>\n",
              "      <th>evebit</th>\n",
              "      <th>evebitda</th>\n",
              "      <th>mrgebit</th>\n",
              "      <th>mrgliq</th>\n",
              "      <th>roic</th>\n",
              "      <th>roe</th>\n",
              "      <th>liqc</th>\n",
              "      <th>liq2m</th>\n",
              "      <th>patrliq</th>\n",
              "      <th>divbpatr</th>\n",
              "      <th>c5y</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>papel</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>ASAI3</th>\n",
              "      <td>19.10</td>\n",
              "      <td>16.12</td>\n",
              "      <td>7.78</td>\n",
              "      <td>0.546</td>\n",
              "      <td>0.0090</td>\n",
              "      <td>0.770</td>\n",
              "      <td>-44.87</td>\n",
              "      <td>7.32</td>\n",
              "      <td>-1.31</td>\n",
              "      <td>9.67</td>\n",
              "      <td>7.85</td>\n",
              "      <td>0.0746</td>\n",
              "      <td>0.0339</td>\n",
              "      <td>0.1504</td>\n",
              "      <td>0.4826</td>\n",
              "      <td>0.95</td>\n",
              "      <td>144645000.0</td>\n",
              "      <td>3.311000e+09</td>\n",
              "      <td>3.43</td>\n",
              "      <td>0.6182</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BLAU3</th>\n",
              "      <td>32.99</td>\n",
              "      <td>18.88</td>\n",
              "      <td>3.44</td>\n",
              "      <td>4.390</td>\n",
              "      <td>0.0222</td>\n",
              "      <td>2.483</td>\n",
              "      <td>4.55</td>\n",
              "      <td>14.09</td>\n",
              "      <td>5.74</td>\n",
              "      <td>12.94</td>\n",
              "      <td>12.31</td>\n",
              "      <td>0.3115</td>\n",
              "      <td>0.2311</td>\n",
              "      <td>0.2926</td>\n",
              "      <td>0.1821</td>\n",
              "      <td>4.30</td>\n",
              "      <td>15169800.0</td>\n",
              "      <td>1.720940e+09</td>\n",
              "      <td>0.18</td>\n",
              "      <td>0.1446</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CRFB3</th>\n",
              "      <td>20.32</td>\n",
              "      <td>16.16</td>\n",
              "      <td>2.14</td>\n",
              "      <td>0.491</td>\n",
              "      <td>0.0270</td>\n",
              "      <td>0.539</td>\n",
              "      <td>-15.09</td>\n",
              "      <td>10.04</td>\n",
              "      <td>-1.80</td>\n",
              "      <td>13.29</td>\n",
              "      <td>10.08</td>\n",
              "      <td>0.0489</td>\n",
              "      <td>0.0332</td>\n",
              "      <td>0.0699</td>\n",
              "      <td>0.1327</td>\n",
              "      <td>0.92</td>\n",
              "      <td>73833100.0</td>\n",
              "      <td>1.993600e+10</td>\n",
              "      <td>0.89</td>\n",
              "      <td>0.1406</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>DMVF3</th>\n",
              "      <td>5.00</td>\n",
              "      <td>13.71</td>\n",
              "      <td>0.30</td>\n",
              "      <td>0.193</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.175</td>\n",
              "      <td>3.94</td>\n",
              "      <td>2.51</td>\n",
              "      <td>-1.24</td>\n",
              "      <td>2.20</td>\n",
              "      <td>1.11</td>\n",
              "      <td>0.0770</td>\n",
              "      <td>0.0141</td>\n",
              "      <td>0.0854</td>\n",
              "      <td>0.0219</td>\n",
              "      <td>1.19</td>\n",
              "      <td>432491.0</td>\n",
              "      <td>8.432170e+08</td>\n",
              "      <td>0.05</td>\n",
              "      <td>0.2654</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>GMAT3</th>\n",
              "      <td>6.51</td>\n",
              "      <td>16.52</td>\n",
              "      <td>2.10</td>\n",
              "      <td>0.774</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>1.258</td>\n",
              "      <td>3.05</td>\n",
              "      <td>13.11</td>\n",
              "      <td>5.55</td>\n",
              "      <td>14.41</td>\n",
              "      <td>11.33</td>\n",
              "      <td>0.0591</td>\n",
              "      <td>0.0476</td>\n",
              "      <td>0.1229</td>\n",
              "      <td>0.1269</td>\n",
              "      <td>2.98</td>\n",
              "      <td>37806700.0</td>\n",
              "      <td>6.861070e+09</td>\n",
              "      <td>0.34</td>\n",
              "      <td>0.2924</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>HYPE3</th>\n",
              "      <td>43.44</td>\n",
              "      <td>20.27</td>\n",
              "      <td>2.70</td>\n",
              "      <td>4.139</td>\n",
              "      <td>0.0284</td>\n",
              "      <td>1.315</td>\n",
              "      <td>9.86</td>\n",
              "      <td>12.55</td>\n",
              "      <td>-6.41</td>\n",
              "      <td>15.53</td>\n",
              "      <td>14.56</td>\n",
              "      <td>0.3298</td>\n",
              "      <td>0.2042</td>\n",
              "      <td>0.1153</td>\n",
              "      <td>0.1330</td>\n",
              "      <td>1.77</td>\n",
              "      <td>112642000.0</td>\n",
              "      <td>1.020800e+10</td>\n",
              "      <td>0.79</td>\n",
              "      <td>0.1717</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PCAR3</th>\n",
              "      <td>22.00</td>\n",
              "      <td>3.10</td>\n",
              "      <td>0.42</td>\n",
              "      <td>0.126</td>\n",
              "      <td>0.0161</td>\n",
              "      <td>0.129</td>\n",
              "      <td>7.10</td>\n",
              "      <td>1.81</td>\n",
              "      <td>-0.43</td>\n",
              "      <td>3.21</td>\n",
              "      <td>2.02</td>\n",
              "      <td>0.0694</td>\n",
              "      <td>0.0446</td>\n",
              "      <td>0.0934</td>\n",
              "      <td>0.1341</td>\n",
              "      <td>1.06</td>\n",
              "      <td>63080000.0</td>\n",
              "      <td>1.426900e+10</td>\n",
              "      <td>0.59</td>\n",
              "      <td>-0.0361</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PFRM3</th>\n",
              "      <td>3.72</td>\n",
              "      <td>4.82</td>\n",
              "      <td>0.40</td>\n",
              "      <td>0.066</td>\n",
              "      <td>0.0727</td>\n",
              "      <td>0.107</td>\n",
              "      <td>0.50</td>\n",
              "      <td>1.60</td>\n",
              "      <td>3.10</td>\n",
              "      <td>4.53</td>\n",
              "      <td>3.08</td>\n",
              "      <td>0.0408</td>\n",
              "      <td>0.0147</td>\n",
              "      <td>0.0944</td>\n",
              "      <td>0.0820</td>\n",
              "      <td>1.46</td>\n",
              "      <td>718234.0</td>\n",
              "      <td>1.165640e+09</td>\n",
              "      <td>0.89</td>\n",
              "      <td>0.1491</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PGMN3</th>\n",
              "      <td>5.14</td>\n",
              "      <td>17.83</td>\n",
              "      <td>1.05</td>\n",
              "      <td>0.289</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.354</td>\n",
              "      <td>1.96</td>\n",
              "      <td>6.48</td>\n",
              "      <td>-2.26</td>\n",
              "      <td>8.32</td>\n",
              "      <td>4.41</td>\n",
              "      <td>0.0446</td>\n",
              "      <td>0.0162</td>\n",
              "      <td>0.0723</td>\n",
              "      <td>0.0589</td>\n",
              "      <td>1.55</td>\n",
              "      <td>6385390.0</td>\n",
              "      <td>2.172580e+09</td>\n",
              "      <td>0.46</td>\n",
              "      <td>0.0796</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PNVL3</th>\n",
              "      <td>12.12</td>\n",
              "      <td>22.01</td>\n",
              "      <td>1.69</td>\n",
              "      <td>0.509</td>\n",
              "      <td>0.0156</td>\n",
              "      <td>0.728</td>\n",
              "      <td>2.81</td>\n",
              "      <td>19.31</td>\n",
              "      <td>-135.10</td>\n",
              "      <td>27.20</td>\n",
              "      <td>9.47</td>\n",
              "      <td>0.0263</td>\n",
              "      <td>0.0231</td>\n",
              "      <td>0.0465</td>\n",
              "      <td>0.0767</td>\n",
              "      <td>1.85</td>\n",
              "      <td>6603170.0</td>\n",
              "      <td>1.079580e+09</td>\n",
              "      <td>0.81</td>\n",
              "      <td>0.1145</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>RADL3</th>\n",
              "      <td>22.68</td>\n",
              "      <td>45.67</td>\n",
              "      <td>7.47</td>\n",
              "      <td>1.420</td>\n",
              "      <td>0.0110</td>\n",
              "      <td>2.317</td>\n",
              "      <td>11.54</td>\n",
              "      <td>24.87</td>\n",
              "      <td>-17.35</td>\n",
              "      <td>25.90</td>\n",
              "      <td>13.45</td>\n",
              "      <td>0.0571</td>\n",
              "      <td>0.0319</td>\n",
              "      <td>0.1276</td>\n",
              "      <td>0.1636</td>\n",
              "      <td>1.57</td>\n",
              "      <td>128497000.0</td>\n",
              "      <td>5.014180e+09</td>\n",
              "      <td>0.47</td>\n",
              "      <td>0.1736</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>VVEO3</th>\n",
              "      <td>17.50</td>\n",
              "      <td>17.53</td>\n",
              "      <td>2.24</td>\n",
              "      <td>0.719</td>\n",
              "      <td>0.0232</td>\n",
              "      <td>0.707</td>\n",
              "      <td>2.71</td>\n",
              "      <td>13.14</td>\n",
              "      <td>-6.59</td>\n",
              "      <td>16.37</td>\n",
              "      <td>12.18</td>\n",
              "      <td>0.0547</td>\n",
              "      <td>0.0410</td>\n",
              "      <td>0.0775</td>\n",
              "      <td>0.1279</td>\n",
              "      <td>1.82</td>\n",
              "      <td>3567390.0</td>\n",
              "      <td>2.232320e+09</td>\n",
              "      <td>0.88</td>\n",
              "      <td>0.0000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-3d63d0c6-9411-4b7f-9821-8ea4c27ecfaa')\"\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-3d63d0c6-9411-4b7f-9821-8ea4c27ecfaa 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-3d63d0c6-9411-4b7f-9821-8ea4c27ecfaa');\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": 25
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.query('index in @setor').loc[:,['mrgebit', 'mrgliq', 'roic', 'roe']]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 457
        },
        "id": "HKl1jFfhQYgG",
        "outputId": "51fc236b-f26f-41aa-9716-4ae1134d7faf"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Multiples  mrgebit  mrgliq    roic     roe\n",
              "papel                                     \n",
              "ASAI3       0.0746  0.0339  0.1504  0.4826\n",
              "BLAU3       0.3115  0.2311  0.2926  0.1821\n",
              "CRFB3       0.0489  0.0332  0.0699  0.1327\n",
              "DMVF3       0.0770  0.0141  0.0854  0.0219\n",
              "GMAT3       0.0591  0.0476  0.1229  0.1269\n",
              "HYPE3       0.3298  0.2042  0.1153  0.1330\n",
              "PCAR3       0.0694  0.0446  0.0934  0.1341\n",
              "PFRM3       0.0408  0.0147  0.0944  0.0820\n",
              "PGMN3       0.0446  0.0162  0.0723  0.0589\n",
              "PNVL3       0.0263  0.0231  0.0465  0.0767\n",
              "RADL3       0.0571  0.0319  0.1276  0.1636\n",
              "VVEO3       0.0547  0.0410  0.0775  0.1279"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-eab23b22-4928-49d0-9755-3d02dfb29a44\">\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>Multiples</th>\n",
              "      <th>mrgebit</th>\n",
              "      <th>mrgliq</th>\n",
              "      <th>roic</th>\n",
              "      <th>roe</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>papel</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>ASAI3</th>\n",
              "      <td>0.0746</td>\n",
              "      <td>0.0339</td>\n",
              "      <td>0.1504</td>\n",
              "      <td>0.4826</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BLAU3</th>\n",
              "      <td>0.3115</td>\n",
              "      <td>0.2311</td>\n",
              "      <td>0.2926</td>\n",
              "      <td>0.1821</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CRFB3</th>\n",
              "      <td>0.0489</td>\n",
              "      <td>0.0332</td>\n",
              "      <td>0.0699</td>\n",
              "      <td>0.1327</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>DMVF3</th>\n",
              "      <td>0.0770</td>\n",
              "      <td>0.0141</td>\n",
              "      <td>0.0854</td>\n",
              "      <td>0.0219</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>GMAT3</th>\n",
              "      <td>0.0591</td>\n",
              "      <td>0.0476</td>\n",
              "      <td>0.1229</td>\n",
              "      <td>0.1269</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>HYPE3</th>\n",
              "      <td>0.3298</td>\n",
              "      <td>0.2042</td>\n",
              "      <td>0.1153</td>\n",
              "      <td>0.1330</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PCAR3</th>\n",
              "      <td>0.0694</td>\n",
              "      <td>0.0446</td>\n",
              "      <td>0.0934</td>\n",
              "      <td>0.1341</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PFRM3</th>\n",
              "      <td>0.0408</td>\n",
              "      <td>0.0147</td>\n",
              "      <td>0.0944</td>\n",
              "      <td>0.0820</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PGMN3</th>\n",
              "      <td>0.0446</td>\n",
              "      <td>0.0162</td>\n",
              "      <td>0.0723</td>\n",
              "      <td>0.0589</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PNVL3</th>\n",
              "      <td>0.0263</td>\n",
              "      <td>0.0231</td>\n",
              "      <td>0.0465</td>\n",
              "      <td>0.0767</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>RADL3</th>\n",
              "      <td>0.0571</td>\n",
              "      <td>0.0319</td>\n",
              "      <td>0.1276</td>\n",
              "      <td>0.1636</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>VVEO3</th>\n",
              "      <td>0.0547</td>\n",
              "      <td>0.0410</td>\n",
              "      <td>0.0775</td>\n",
              "      <td>0.1279</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-eab23b22-4928-49d0-9755-3d02dfb29a44')\"\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-eab23b22-4928-49d0-9755-3d02dfb29a44 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-eab23b22-4928-49d0-9755-3d02dfb29a44');\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": 26
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "varejo = df.query('index in @setor').loc[:,['mrgebit', 'mrgliq', 'roic', 'roe']]\n",
        "varejo"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 457
        },
        "id": "uRFNFOzaR3YW",
        "outputId": "81063f5c-78d6-4139-98fe-88ac984b30d0"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Multiples  mrgebit  mrgliq    roic     roe\n",
              "papel                                     \n",
              "ASAI3       0.0746  0.0339  0.1504  0.4826\n",
              "BLAU3       0.3115  0.2311  0.2926  0.1821\n",
              "CRFB3       0.0489  0.0332  0.0699  0.1327\n",
              "DMVF3       0.0770  0.0141  0.0854  0.0219\n",
              "GMAT3       0.0591  0.0476  0.1229  0.1269\n",
              "HYPE3       0.3298  0.2042  0.1153  0.1330\n",
              "PCAR3       0.0694  0.0446  0.0934  0.1341\n",
              "PFRM3       0.0408  0.0147  0.0944  0.0820\n",
              "PGMN3       0.0446  0.0162  0.0723  0.0589\n",
              "PNVL3       0.0263  0.0231  0.0465  0.0767\n",
              "RADL3       0.0571  0.0319  0.1276  0.1636\n",
              "VVEO3       0.0547  0.0410  0.0775  0.1279"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-efe333a3-a895-484b-a7fc-f12c87c4d483\">\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>Multiples</th>\n",
              "      <th>mrgebit</th>\n",
              "      <th>mrgliq</th>\n",
              "      <th>roic</th>\n",
              "      <th>roe</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>papel</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>ASAI3</th>\n",
              "      <td>0.0746</td>\n",
              "      <td>0.0339</td>\n",
              "      <td>0.1504</td>\n",
              "      <td>0.4826</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BLAU3</th>\n",
              "      <td>0.3115</td>\n",
              "      <td>0.2311</td>\n",
              "      <td>0.2926</td>\n",
              "      <td>0.1821</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CRFB3</th>\n",
              "      <td>0.0489</td>\n",
              "      <td>0.0332</td>\n",
              "      <td>0.0699</td>\n",
              "      <td>0.1327</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>DMVF3</th>\n",
              "      <td>0.0770</td>\n",
              "      <td>0.0141</td>\n",
              "      <td>0.0854</td>\n",
              "      <td>0.0219</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>GMAT3</th>\n",
              "      <td>0.0591</td>\n",
              "      <td>0.0476</td>\n",
              "      <td>0.1229</td>\n",
              "      <td>0.1269</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>HYPE3</th>\n",
              "      <td>0.3298</td>\n",
              "      <td>0.2042</td>\n",
              "      <td>0.1153</td>\n",
              "      <td>0.1330</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PCAR3</th>\n",
              "      <td>0.0694</td>\n",
              "      <td>0.0446</td>\n",
              "      <td>0.0934</td>\n",
              "      <td>0.1341</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PFRM3</th>\n",
              "      <td>0.0408</td>\n",
              "      <td>0.0147</td>\n",
              "      <td>0.0944</td>\n",
              "      <td>0.0820</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PGMN3</th>\n",
              "      <td>0.0446</td>\n",
              "      <td>0.0162</td>\n",
              "      <td>0.0723</td>\n",
              "      <td>0.0589</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PNVL3</th>\n",
              "      <td>0.0263</td>\n",
              "      <td>0.0231</td>\n",
              "      <td>0.0465</td>\n",
              "      <td>0.0767</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>RADL3</th>\n",
              "      <td>0.0571</td>\n",
              "      <td>0.0319</td>\n",
              "      <td>0.1276</td>\n",
              "      <td>0.1636</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>VVEO3</th>\n",
              "      <td>0.0547</td>\n",
              "      <td>0.0410</td>\n",
              "      <td>0.0775</td>\n",
              "      <td>0.1279</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-efe333a3-a895-484b-a7fc-f12c87c4d483')\"\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-efe333a3-a895-484b-a7fc-f12c87c4d483 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-efe333a3-a895-484b-a7fc-f12c87c4d483');\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": 35
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "fig = make_subplots(rows=2,\n",
        "                    cols=2,\n",
        "                    row_heights=[4,4],\n",
        "                    column_widths=[4,4],\n",
        "                    subplot_titles=('Margem EBTIDA', 'Margem Líquida', 'ROIC', 'ROE'),\n",
        "                    shared_xaxes=False)\n",
        "fig.add_trace(go.Bar(name='Margem_Ebtida', x=varejo.index, y=varejo['mrgebit']), row=1, col=1)\n",
        "fig.add_trace(go.Bar(name='Margem_Liquida', x=varejo.index, y=varejo['mrgliq']), row=1, col=2)\n",
        "fig.add_trace(go.Bar(name='ROIC', x=varejo.index, y=varejo['roic']), row=2, col=1)\n",
        "fig.add_trace(go.Bar(name='ROE', x=varejo.index, y=varejo['roe']), row=2, col=2)\n",
        "fig.update_layout(title_text='<b>Overview Rentabilidade Varejo<b>', \n",
        "                  template='plotly_dark',#template pré-definido da plotly\n",
        "                  showlegend=False, #esconder ou mostrar legenda\n",
        "                  height=500, #altura\n",
        "                  width=900) #largura\n",
        "fig.show()\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 517
        },
        "id": "ImvMtjK8R-t-",
        "outputId": "862a208e-23b6-4c14-8231-97fb5cd9bbc1"
      },
      "execution_count": null,
      "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=\"b4599bcd-d04f-4feb-844f-e47081befd40\" class=\"plotly-graph-div\" style=\"height:500px; width:900px;\"></div>            <script type=\"text/javascript\">                                    window.PLOTLYENV=window.PLOTLYENV || {};                                    if (document.getElementById(\"b4599bcd-d04f-4feb-844f-e47081befd40\")) {                    Plotly.newPlot(                        \"b4599bcd-d04f-4feb-844f-e47081befd40\",                        [{\"name\":\"Margem_Ebtida\",\"x\":[\"ASAI3\",\"BLAU3\",\"CRFB3\",\"DMVF3\",\"GMAT3\",\"HYPE3\",\"PCAR3\",\"PFRM3\",\"PGMN3\",\"PNVL3\",\"RADL3\",\"VVEO3\"],\"y\":[0.0746,0.3115,0.0489,0.077,0.0591,0.3298,0.0694,0.0408,0.0446,0.0263,0.0571,0.0547],\"type\":\"bar\",\"xaxis\":\"x\",\"yaxis\":\"y\"},{\"name\":\"Margem_Liquida\",\"x\":[\"ASAI3\",\"BLAU3\",\"CRFB3\",\"DMVF3\",\"GMAT3\",\"HYPE3\",\"PCAR3\",\"PFRM3\",\"PGMN3\",\"PNVL3\",\"RADL3\",\"VVEO3\"],\"y\":[0.0339,0.2311,0.0332,0.0141,0.047599999999999996,0.20420000000000002,0.0446,0.0147,0.016200000000000003,0.0231,0.0319,0.040999999999999995],\"type\":\"bar\",\"xaxis\":\"x2\",\"yaxis\":\"y2\"},{\"name\":\"ROIC\",\"x\":[\"ASAI3\",\"BLAU3\",\"CRFB3\",\"DMVF3\",\"GMAT3\",\"HYPE3\",\"PCAR3\",\"PFRM3\",\"PGMN3\",\"PNVL3\",\"RADL3\",\"VVEO3\"],\"y\":[0.15039999999999998,0.2926,0.0699,0.08539999999999999,0.1229,0.1153,0.0934,0.0944,0.0723,0.04650000000000001,0.1276,0.0775],\"type\":\"bar\",\"xaxis\":\"x3\",\"yaxis\":\"y3\"},{\"name\":\"ROE\",\"x\":[\"ASAI3\",\"BLAU3\",\"CRFB3\",\"DMVF3\",\"GMAT3\",\"HYPE3\",\"PCAR3\",\"PFRM3\",\"PGMN3\",\"PNVL3\",\"RADL3\",\"VVEO3\"],\"y\":[0.4826,0.1821,0.13269999999999998,0.0219,0.12689999999999999,0.133,0.1341,0.08199999999999999,0.058899999999999994,0.0767,0.1636,0.12789999999999999],\"type\":\"bar\",\"xaxis\":\"x4\",\"yaxis\":\"y4\"}],                        {\"template\":{\"data\":{\"barpolar\":[{\"marker\":{\"line\":{\"color\":\"rgb(17,17,17)\",\"width\":0.5},\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"barpolar\"}],\"bar\":[{\"error_x\":{\"color\":\"#f2f5fa\"},\"error_y\":{\"color\":\"#f2f5fa\"},\"marker\":{\"line\":{\"color\":\"rgb(17,17,17)\",\"width\":0.5},\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"bar\"}],\"carpet\":[{\"aaxis\":{\"endlinecolor\":\"#A2B1C6\",\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"minorgridcolor\":\"#506784\",\"startlinecolor\":\"#A2B1C6\"},\"baxis\":{\"endlinecolor\":\"#A2B1C6\",\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"minorgridcolor\":\"#506784\",\"startlinecolor\":\"#A2B1C6\"},\"type\":\"carpet\"}],\"choropleth\":[{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"type\":\"choropleth\"}],\"contourcarpet\":[{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"type\":\"contourcarpet\"}],\"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\"}],\"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\"}],\"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\"}],\"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\"}],\"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\"}],\"histogram\":[{\"marker\":{\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"histogram\"}],\"mesh3d\":[{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"type\":\"mesh3d\"}],\"parcoords\":[{\"line\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"type\":\"parcoords\"}],\"pie\":[{\"automargin\":true,\"type\":\"pie\"}],\"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\":{\"line\":{\"color\":\"#283442\"}},\"type\":\"scattergl\"}],\"scattermapbox\":[{\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"type\":\"scattermapbox\"}],\"scatterpolargl\":[{\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"type\":\"scatterpolargl\"}],\"scatterpolar\":[{\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"type\":\"scatterpolar\"}],\"scatter\":[{\"marker\":{\"line\":{\"color\":\"#283442\"}},\"type\":\"scatter\"}],\"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\":\"#506784\"},\"line\":{\"color\":\"rgb(17,17,17)\"}},\"header\":{\"fill\":{\"color\":\"#2a3f5f\"},\"line\":{\"color\":\"rgb(17,17,17)\"}},\"type\":\"table\"}]},\"layout\":{\"annotationdefaults\":{\"arrowcolor\":\"#f2f5fa\",\"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\":\"#f2f5fa\"},\"geo\":{\"bgcolor\":\"rgb(17,17,17)\",\"lakecolor\":\"rgb(17,17,17)\",\"landcolor\":\"rgb(17,17,17)\",\"showlakes\":true,\"showland\":true,\"subunitcolor\":\"#506784\"},\"hoverlabel\":{\"align\":\"left\"},\"hovermode\":\"closest\",\"mapbox\":{\"style\":\"dark\"},\"paper_bgcolor\":\"rgb(17,17,17)\",\"plot_bgcolor\":\"rgb(17,17,17)\",\"polar\":{\"angularaxis\":{\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"ticks\":\"\"},\"bgcolor\":\"rgb(17,17,17)\",\"radialaxis\":{\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"ticks\":\"\"}},\"scene\":{\"xaxis\":{\"backgroundcolor\":\"rgb(17,17,17)\",\"gridcolor\":\"#506784\",\"gridwidth\":2,\"linecolor\":\"#506784\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"#C8D4E3\"},\"yaxis\":{\"backgroundcolor\":\"rgb(17,17,17)\",\"gridcolor\":\"#506784\",\"gridwidth\":2,\"linecolor\":\"#506784\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"#C8D4E3\"},\"zaxis\":{\"backgroundcolor\":\"rgb(17,17,17)\",\"gridcolor\":\"#506784\",\"gridwidth\":2,\"linecolor\":\"#506784\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"#C8D4E3\"}},\"shapedefaults\":{\"line\":{\"color\":\"#f2f5fa\"}},\"sliderdefaults\":{\"bgcolor\":\"#C8D4E3\",\"bordercolor\":\"rgb(17,17,17)\",\"borderwidth\":1,\"tickwidth\":0},\"ternary\":{\"aaxis\":{\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"ticks\":\"\"},\"baxis\":{\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"ticks\":\"\"},\"bgcolor\":\"rgb(17,17,17)\",\"caxis\":{\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"ticks\":\"\"}},\"title\":{\"x\":0.05},\"updatemenudefaults\":{\"bgcolor\":\"#506784\",\"borderwidth\":0},\"xaxis\":{\"automargin\":true,\"gridcolor\":\"#283442\",\"linecolor\":\"#506784\",\"ticks\":\"\",\"title\":{\"standoff\":15},\"zerolinecolor\":\"#283442\",\"zerolinewidth\":2},\"yaxis\":{\"automargin\":true,\"gridcolor\":\"#283442\",\"linecolor\":\"#506784\",\"ticks\":\"\",\"title\":{\"standoff\":15},\"zerolinecolor\":\"#283442\",\"zerolinewidth\":2}}},\"xaxis\":{\"anchor\":\"y\",\"domain\":[0.0,0.45]},\"yaxis\":{\"anchor\":\"x\",\"domain\":[0.625,1.0]},\"xaxis2\":{\"anchor\":\"y2\",\"domain\":[0.55,1.0]},\"yaxis2\":{\"anchor\":\"x2\",\"domain\":[0.625,1.0]},\"xaxis3\":{\"anchor\":\"y3\",\"domain\":[0.0,0.45]},\"yaxis3\":{\"anchor\":\"x3\",\"domain\":[0.0,0.375]},\"xaxis4\":{\"anchor\":\"y4\",\"domain\":[0.55,1.0]},\"yaxis4\":{\"anchor\":\"x4\",\"domain\":[0.0,0.375]},\"annotations\":[{\"font\":{\"size\":16},\"showarrow\":false,\"text\":\"Margem EBTIDA\",\"x\":0.225,\"xanchor\":\"center\",\"xref\":\"paper\",\"y\":1.0,\"yanchor\":\"bottom\",\"yref\":\"paper\"},{\"font\":{\"size\":16},\"showarrow\":false,\"text\":\"Margem L\\u00edquida\",\"x\":0.775,\"xanchor\":\"center\",\"xref\":\"paper\",\"y\":1.0,\"yanchor\":\"bottom\",\"yref\":\"paper\"},{\"font\":{\"size\":16},\"showarrow\":false,\"text\":\"ROIC\",\"x\":0.225,\"xanchor\":\"center\",\"xref\":\"paper\",\"y\":0.375,\"yanchor\":\"bottom\",\"yref\":\"paper\"},{\"font\":{\"size\":16},\"showarrow\":false,\"text\":\"ROE\",\"x\":0.775,\"xanchor\":\"center\",\"xref\":\"paper\",\"y\":0.375,\"yanchor\":\"bottom\",\"yref\":\"paper\"}],\"title\":{\"text\":\"<b>Overview Rentabilidade Varejo<b>\"},\"showlegend\":false,\"height\":500,\"width\":900},                        {\"responsive\": true}                    ).then(function(){\n",
              "                            \n",
              "var gd = document.getElementById('b4599bcd-d04f-4feb-844f-e47081befd40');\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": [
        "varejo2 = df.query('index in @setor').loc[:,['pl', 'pvp', 'evebitda', 'dy']]\n",
        "varejo2"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 457
        },
        "id": "-EIA9SgI837G",
        "outputId": "3641ab71-96bc-404c-f439-5648262cb34e"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Multiples     pl   pvp  evebitda      dy\n",
              "papel                                   \n",
              "ASAI3      16.12  7.78      7.85  0.0090\n",
              "BLAU3      18.88  3.44     12.31  0.0222\n",
              "CRFB3      16.16  2.14     10.08  0.0270\n",
              "DMVF3      13.71  0.30      1.11  0.0000\n",
              "GMAT3      16.52  2.10     11.33  0.0000\n",
              "HYPE3      20.27  2.70     14.56  0.0284\n",
              "PCAR3       3.10  0.42      2.02  0.0161\n",
              "PFRM3       4.82  0.40      3.08  0.0727\n",
              "PGMN3      17.83  1.05      4.41  0.0000\n",
              "PNVL3      22.01  1.69      9.47  0.0156\n",
              "RADL3      45.67  7.47     13.45  0.0110\n",
              "VVEO3      17.53  2.24     12.18  0.0232"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-fc997df1-f3bf-4633-9a50-41331dcd8016\">\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>Multiples</th>\n",
              "      <th>pl</th>\n",
              "      <th>pvp</th>\n",
              "      <th>evebitda</th>\n",
              "      <th>dy</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>papel</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>ASAI3</th>\n",
              "      <td>16.12</td>\n",
              "      <td>7.78</td>\n",
              "      <td>7.85</td>\n",
              "      <td>0.0090</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BLAU3</th>\n",
              "      <td>18.88</td>\n",
              "      <td>3.44</td>\n",
              "      <td>12.31</td>\n",
              "      <td>0.0222</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CRFB3</th>\n",
              "      <td>16.16</td>\n",
              "      <td>2.14</td>\n",
              "      <td>10.08</td>\n",
              "      <td>0.0270</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>DMVF3</th>\n",
              "      <td>13.71</td>\n",
              "      <td>0.30</td>\n",
              "      <td>1.11</td>\n",
              "      <td>0.0000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>GMAT3</th>\n",
              "      <td>16.52</td>\n",
              "      <td>2.10</td>\n",
              "      <td>11.33</td>\n",
              "      <td>0.0000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>HYPE3</th>\n",
              "      <td>20.27</td>\n",
              "      <td>2.70</td>\n",
              "      <td>14.56</td>\n",
              "      <td>0.0284</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PCAR3</th>\n",
              "      <td>3.10</td>\n",
              "      <td>0.42</td>\n",
              "      <td>2.02</td>\n",
              "      <td>0.0161</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PFRM3</th>\n",
              "      <td>4.82</td>\n",
              "      <td>0.40</td>\n",
              "      <td>3.08</td>\n",
              "      <td>0.0727</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PGMN3</th>\n",
              "      <td>17.83</td>\n",
              "      <td>1.05</td>\n",
              "      <td>4.41</td>\n",
              "      <td>0.0000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PNVL3</th>\n",
              "      <td>22.01</td>\n",
              "      <td>1.69</td>\n",
              "      <td>9.47</td>\n",
              "      <td>0.0156</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>RADL3</th>\n",
              "      <td>45.67</td>\n",
              "      <td>7.47</td>\n",
              "      <td>13.45</td>\n",
              "      <td>0.0110</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>VVEO3</th>\n",
              "      <td>17.53</td>\n",
              "      <td>2.24</td>\n",
              "      <td>12.18</td>\n",
              "      <td>0.0232</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-fc997df1-f3bf-4633-9a50-41331dcd8016')\"\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-fc997df1-f3bf-4633-9a50-41331dcd8016 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-fc997df1-f3bf-4633-9a50-41331dcd8016');\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": 37
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#ORDENANDO OS VALORES\n",
        "\n",
        "#Para fazer isso deixar o shared xaxes = False  e adicionar o fig.update_xaxes(categoryorder='total descending')\n",
        "\n",
        "fig = make_subplots(rows=2,\n",
        "                    cols=2,\n",
        "                    row_heights=[5,5],\n",
        "                    column_widths=[3,3],\n",
        "                    subplot_titles=('Preço/Lucro', 'P/VP', 'EV/EBTIDA', 'Dividend Yeld'),\n",
        "                    shared_xaxes=False)\n",
        "fig.add_trace(go.Bar(name='Margem_Ebtida', x=varejo2.index, y=varejo2['pl']), row=1, col=1)\n",
        "fig.add_trace(go.Bar(name='Margem_Liquida', x=varejo2.index, y=varejo2['pvp']), row=1, col=2)\n",
        "fig.add_trace(go.Bar(name='ROIC', x=varejo2.index, y=varejo2['evebitda']), row=2, col=1)\n",
        "fig.add_trace(go.Bar(name='ROE', x=varejo2.index, y=varejo2['dy']), row=2, col=2)\n",
        "fig.update_layout(title_text='<b>Avaliação por Múltiplos Varejo<b>', \n",
        "                  template='plotly_dark',#template pré-definido da plotly\n",
        "                  showlegend=False, #esconder ou mostrar legenda\n",
        "                  height=500, #altura\n",
        "                  width=900) #largura\n",
        "fig.update_xaxes(categoryorder='total descending')\n",
        "fig.show()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 517
        },
        "id": "RU8BOMskUBqF",
        "outputId": "332a4c97-2658-4db5-c6f3-f2304a7f4e69"
      },
      "execution_count": null,
      "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=\"e5ee98b0-8c77-467d-b8b0-44851f1d45c1\" class=\"plotly-graph-div\" style=\"height:500px; width:900px;\"></div>            <script type=\"text/javascript\">                                    window.PLOTLYENV=window.PLOTLYENV || {};                                    if (document.getElementById(\"e5ee98b0-8c77-467d-b8b0-44851f1d45c1\")) {                    Plotly.newPlot(                        \"e5ee98b0-8c77-467d-b8b0-44851f1d45c1\",                        [{\"name\":\"Margem_Ebtida\",\"x\":[\"ASAI3\",\"BLAU3\",\"CRFB3\",\"DMVF3\",\"GMAT3\",\"HYPE3\",\"PCAR3\",\"PFRM3\",\"PGMN3\",\"PNVL3\",\"RADL3\",\"VVEO3\"],\"y\":[16.12,18.88,16.16,13.71,16.52,20.27,3.1,4.82,17.83,22.01,45.67,17.53],\"type\":\"bar\",\"xaxis\":\"x\",\"yaxis\":\"y\"},{\"name\":\"Margem_Liquida\",\"x\":[\"ASAI3\",\"BLAU3\",\"CRFB3\",\"DMVF3\",\"GMAT3\",\"HYPE3\",\"PCAR3\",\"PFRM3\",\"PGMN3\",\"PNVL3\",\"RADL3\",\"VVEO3\"],\"y\":[7.78,3.44,2.14,0.3,2.1,2.7,0.42,0.4,1.05,1.69,7.47,2.24],\"type\":\"bar\",\"xaxis\":\"x2\",\"yaxis\":\"y2\"},{\"name\":\"ROIC\",\"x\":[\"ASAI3\",\"BLAU3\",\"CRFB3\",\"DMVF3\",\"GMAT3\",\"HYPE3\",\"PCAR3\",\"PFRM3\",\"PGMN3\",\"PNVL3\",\"RADL3\",\"VVEO3\"],\"y\":[7.85,12.31,10.08,1.11,11.33,14.56,2.02,3.08,4.41,9.47,13.45,12.18],\"type\":\"bar\",\"xaxis\":\"x3\",\"yaxis\":\"y3\"},{\"name\":\"ROE\",\"x\":[\"ASAI3\",\"BLAU3\",\"CRFB3\",\"DMVF3\",\"GMAT3\",\"HYPE3\",\"PCAR3\",\"PFRM3\",\"PGMN3\",\"PNVL3\",\"RADL3\",\"VVEO3\"],\"y\":[0.009000000000000001,0.0222,0.027000000000000003,0.0,0.0,0.028399999999999998,0.0161,0.0727,0.0,0.015600000000000001,0.011000000000000001,0.0232],\"type\":\"bar\",\"xaxis\":\"x4\",\"yaxis\":\"y4\"}],                        {\"template\":{\"data\":{\"barpolar\":[{\"marker\":{\"line\":{\"color\":\"rgb(17,17,17)\",\"width\":0.5},\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"barpolar\"}],\"bar\":[{\"error_x\":{\"color\":\"#f2f5fa\"},\"error_y\":{\"color\":\"#f2f5fa\"},\"marker\":{\"line\":{\"color\":\"rgb(17,17,17)\",\"width\":0.5},\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"bar\"}],\"carpet\":[{\"aaxis\":{\"endlinecolor\":\"#A2B1C6\",\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"minorgridcolor\":\"#506784\",\"startlinecolor\":\"#A2B1C6\"},\"baxis\":{\"endlinecolor\":\"#A2B1C6\",\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"minorgridcolor\":\"#506784\",\"startlinecolor\":\"#A2B1C6\"},\"type\":\"carpet\"}],\"choropleth\":[{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"type\":\"choropleth\"}],\"contourcarpet\":[{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"type\":\"contourcarpet\"}],\"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\"}],\"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\"}],\"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\"}],\"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\"}],\"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\"}],\"histogram\":[{\"marker\":{\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"histogram\"}],\"mesh3d\":[{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"type\":\"mesh3d\"}],\"parcoords\":[{\"line\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"type\":\"parcoords\"}],\"pie\":[{\"automargin\":true,\"type\":\"pie\"}],\"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\":{\"line\":{\"color\":\"#283442\"}},\"type\":\"scattergl\"}],\"scattermapbox\":[{\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"type\":\"scattermapbox\"}],\"scatterpolargl\":[{\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"type\":\"scatterpolargl\"}],\"scatterpolar\":[{\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"type\":\"scatterpolar\"}],\"scatter\":[{\"marker\":{\"line\":{\"color\":\"#283442\"}},\"type\":\"scatter\"}],\"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\":\"#506784\"},\"line\":{\"color\":\"rgb(17,17,17)\"}},\"header\":{\"fill\":{\"color\":\"#2a3f5f\"},\"line\":{\"color\":\"rgb(17,17,17)\"}},\"type\":\"table\"}]},\"layout\":{\"annotationdefaults\":{\"arrowcolor\":\"#f2f5fa\",\"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\":\"#f2f5fa\"},\"geo\":{\"bgcolor\":\"rgb(17,17,17)\",\"lakecolor\":\"rgb(17,17,17)\",\"landcolor\":\"rgb(17,17,17)\",\"showlakes\":true,\"showland\":true,\"subunitcolor\":\"#506784\"},\"hoverlabel\":{\"align\":\"left\"},\"hovermode\":\"closest\",\"mapbox\":{\"style\":\"dark\"},\"paper_bgcolor\":\"rgb(17,17,17)\",\"plot_bgcolor\":\"rgb(17,17,17)\",\"polar\":{\"angularaxis\":{\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"ticks\":\"\"},\"bgcolor\":\"rgb(17,17,17)\",\"radialaxis\":{\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"ticks\":\"\"}},\"scene\":{\"xaxis\":{\"backgroundcolor\":\"rgb(17,17,17)\",\"gridcolor\":\"#506784\",\"gridwidth\":2,\"linecolor\":\"#506784\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"#C8D4E3\"},\"yaxis\":{\"backgroundcolor\":\"rgb(17,17,17)\",\"gridcolor\":\"#506784\",\"gridwidth\":2,\"linecolor\":\"#506784\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"#C8D4E3\"},\"zaxis\":{\"backgroundcolor\":\"rgb(17,17,17)\",\"gridcolor\":\"#506784\",\"gridwidth\":2,\"linecolor\":\"#506784\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"#C8D4E3\"}},\"shapedefaults\":{\"line\":{\"color\":\"#f2f5fa\"}},\"sliderdefaults\":{\"bgcolor\":\"#C8D4E3\",\"bordercolor\":\"rgb(17,17,17)\",\"borderwidth\":1,\"tickwidth\":0},\"ternary\":{\"aaxis\":{\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"ticks\":\"\"},\"baxis\":{\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"ticks\":\"\"},\"bgcolor\":\"rgb(17,17,17)\",\"caxis\":{\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"ticks\":\"\"}},\"title\":{\"x\":0.05},\"updatemenudefaults\":{\"bgcolor\":\"#506784\",\"borderwidth\":0},\"xaxis\":{\"automargin\":true,\"gridcolor\":\"#283442\",\"linecolor\":\"#506784\",\"ticks\":\"\",\"title\":{\"standoff\":15},\"zerolinecolor\":\"#283442\",\"zerolinewidth\":2},\"yaxis\":{\"automargin\":true,\"gridcolor\":\"#283442\",\"linecolor\":\"#506784\",\"ticks\":\"\",\"title\":{\"standoff\":15},\"zerolinecolor\":\"#283442\",\"zerolinewidth\":2}}},\"xaxis\":{\"anchor\":\"y\",\"domain\":[0.0,0.45],\"categoryorder\":\"total descending\"},\"yaxis\":{\"anchor\":\"x\",\"domain\":[0.625,1.0]},\"xaxis2\":{\"anchor\":\"y2\",\"domain\":[0.55,1.0],\"categoryorder\":\"total descending\"},\"yaxis2\":{\"anchor\":\"x2\",\"domain\":[0.625,1.0]},\"xaxis3\":{\"anchor\":\"y3\",\"domain\":[0.0,0.45],\"categoryorder\":\"total descending\"},\"yaxis3\":{\"anchor\":\"x3\",\"domain\":[0.0,0.375]},\"xaxis4\":{\"anchor\":\"y4\",\"domain\":[0.55,1.0],\"categoryorder\":\"total descending\"},\"yaxis4\":{\"anchor\":\"x4\",\"domain\":[0.0,0.375]},\"annotations\":[{\"font\":{\"size\":16},\"showarrow\":false,\"text\":\"Pre\\u00e7o/Lucro\",\"x\":0.225,\"xanchor\":\"center\",\"xref\":\"paper\",\"y\":1.0,\"yanchor\":\"bottom\",\"yref\":\"paper\"},{\"font\":{\"size\":16},\"showarrow\":false,\"text\":\"P/VP\",\"x\":0.775,\"xanchor\":\"center\",\"xref\":\"paper\",\"y\":1.0,\"yanchor\":\"bottom\",\"yref\":\"paper\"},{\"font\":{\"size\":16},\"showarrow\":false,\"text\":\"EV/EBTIDA\",\"x\":0.225,\"xanchor\":\"center\",\"xref\":\"paper\",\"y\":0.375,\"yanchor\":\"bottom\",\"yref\":\"paper\"},{\"font\":{\"size\":16},\"showarrow\":false,\"text\":\"Dividend Yeld\",\"x\":0.775,\"xanchor\":\"center\",\"xref\":\"paper\",\"y\":0.375,\"yanchor\":\"bottom\",\"yref\":\"paper\"}],\"title\":{\"text\":\"<b>Avalia\\u00e7\\u00e3o por M\\u00faltiplos Varejo<b>\"},\"showlegend\":false,\"height\":500,\"width\":900},                        {\"responsive\": true}                    ).then(function(){\n",
              "                            \n",
              "var gd = document.getElementById('e5ee98b0-8c77-467d-b8b0-44851f1d45c1');\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": [],
      "metadata": {
        "id": "Zah5WC8KZtQy"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}