Análise de correlação e associação com Python.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"provenance":[],"authorship_tag":"ABX9TyNZBKq9fgkLVNtjY25DEWF8"},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"}},"cells":[{"cell_type":"code","execution_count":6,"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"XoYb32NM4sRI","executionInfo":{"status":"ok","timestamp":1692981123794,"user_tz":180,"elapsed":3810,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"6e087cd7-f5f0-4b2e-95f6-726f716d2c49"},"outputs":[{"output_type":"stream","name":"stdout","text":["Collecting spicy\n","  Downloading spicy-0.16.0-py2.py3-none-any.whl (1.7 kB)\n","Requirement already satisfied: scipy in /usr/local/lib/python3.10/dist-packages (from spicy) (1.10.1)\n","Requirement already satisfied: numpy<1.27.0,>=1.19.5 in /usr/local/lib/python3.10/dist-packages (from scipy->spicy) (1.23.5)\n","Installing collected packages: spicy\n","Successfully installed spicy-0.16.0\n"]}],"source":["! sudo pip install spicy"]},{"cell_type":"code","source":["! sudo pip install pingouin"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"OfNrV_SeiKuj","executionInfo":{"status":"ok","timestamp":1692981106283,"user_tz":180,"elapsed":5493,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"98c1ca71-3561-4abb-c2be-d7b29b204f83"},"execution_count":4,"outputs":[{"output_type":"stream","name":"stdout","text":["Collecting pingouin\n","  Downloading pingouin-0.5.3-py3-none-any.whl (198 kB)\n","\u001b[?25l     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m0.0/198.6 kB\u001b[0m \u001b[31m?\u001b[0m eta \u001b[36m-:--:--\u001b[0m\r\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m198.6/198.6 kB\u001b[0m \u001b[31m6.0 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n","\u001b[?25hRequirement already satisfied: numpy>=1.19 in /usr/local/lib/python3.10/dist-packages (from pingouin) (1.23.5)\n","Requirement already satisfied: scipy>=1.7 in /usr/local/lib/python3.10/dist-packages (from pingouin) (1.10.1)\n","Requirement already satisfied: pandas>=1.0 in /usr/local/lib/python3.10/dist-packages (from pingouin) (1.5.3)\n","Requirement already satisfied: matplotlib>=3.0.2 in /usr/local/lib/python3.10/dist-packages (from pingouin) (3.7.1)\n","Requirement already satisfied: seaborn>=0.11 in /usr/local/lib/python3.10/dist-packages (from pingouin) (0.12.2)\n","Requirement already satisfied: statsmodels>=0.13 in /usr/local/lib/python3.10/dist-packages (from pingouin) (0.14.0)\n","Requirement already satisfied: scikit-learn in /usr/local/lib/python3.10/dist-packages (from pingouin) (1.2.2)\n","Collecting pandas-flavor>=0.2.0 (from pingouin)\n","  Downloading pandas_flavor-0.6.0-py3-none-any.whl (7.2 kB)\n","Collecting outdated (from pingouin)\n","  Downloading outdated-0.2.2-py2.py3-none-any.whl (7.5 kB)\n","Requirement already satisfied: tabulate in /usr/local/lib/python3.10/dist-packages (from pingouin) (0.9.0)\n","Requirement already satisfied: contourpy>=1.0.1 in /usr/local/lib/python3.10/dist-packages (from matplotlib>=3.0.2->pingouin) (1.1.0)\n","Requirement already satisfied: cycler>=0.10 in /usr/local/lib/python3.10/dist-packages (from matplotlib>=3.0.2->pingouin) (0.11.0)\n","Requirement already satisfied: fonttools>=4.22.0 in /usr/local/lib/python3.10/dist-packages (from matplotlib>=3.0.2->pingouin) (4.42.0)\n","Requirement already satisfied: kiwisolver>=1.0.1 in /usr/local/lib/python3.10/dist-packages (from matplotlib>=3.0.2->pingouin) (1.4.4)\n","Requirement already satisfied: packaging>=20.0 in /usr/local/lib/python3.10/dist-packages (from matplotlib>=3.0.2->pingouin) (23.1)\n","Requirement already satisfied: pillow>=6.2.0 in /usr/local/lib/python3.10/dist-packages (from matplotlib>=3.0.2->pingouin) (9.4.0)\n","Requirement already satisfied: pyparsing>=2.3.1 in /usr/local/lib/python3.10/dist-packages (from matplotlib>=3.0.2->pingouin) (3.1.1)\n","Requirement already satisfied: python-dateutil>=2.7 in /usr/local/lib/python3.10/dist-packages (from matplotlib>=3.0.2->pingouin) (2.8.2)\n","Requirement already satisfied: pytz>=2020.1 in /usr/local/lib/python3.10/dist-packages (from pandas>=1.0->pingouin) (2023.3)\n","Requirement already satisfied: xarray in /usr/local/lib/python3.10/dist-packages (from pandas-flavor>=0.2.0->pingouin) (2023.7.0)\n","Requirement already satisfied: patsy>=0.5.2 in /usr/local/lib/python3.10/dist-packages (from statsmodels>=0.13->pingouin) (0.5.3)\n","Requirement already satisfied: setuptools>=44 in /usr/local/lib/python3.10/dist-packages (from outdated->pingouin) (67.7.2)\n","Collecting littleutils (from outdated->pingouin)\n","  Downloading littleutils-0.2.2.tar.gz (6.6 kB)\n","  Preparing metadata (setup.py) ... \u001b[?25l\u001b[?25hdone\n","Requirement already satisfied: requests in /usr/local/lib/python3.10/dist-packages (from outdated->pingouin) (2.31.0)\n","Requirement already satisfied: joblib>=1.1.1 in /usr/local/lib/python3.10/dist-packages (from scikit-learn->pingouin) (1.3.2)\n","Requirement already satisfied: threadpoolctl>=2.0.0 in /usr/local/lib/python3.10/dist-packages (from scikit-learn->pingouin) (3.2.0)\n","Requirement already satisfied: six in /usr/local/lib/python3.10/dist-packages (from patsy>=0.5.2->statsmodels>=0.13->pingouin) (1.16.0)\n","Requirement already satisfied: charset-normalizer<4,>=2 in /usr/local/lib/python3.10/dist-packages (from requests->outdated->pingouin) (3.2.0)\n","Requirement already satisfied: idna<4,>=2.5 in /usr/local/lib/python3.10/dist-packages (from requests->outdated->pingouin) (3.4)\n","Requirement already satisfied: urllib3<3,>=1.21.1 in /usr/local/lib/python3.10/dist-packages (from requests->outdated->pingouin) (2.0.4)\n","Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.10/dist-packages (from requests->outdated->pingouin) (2023.7.22)\n","Building wheels for collected packages: littleutils\n","  Building wheel for littleutils (setup.py) ... \u001b[?25l\u001b[?25hdone\n","  Created wheel for littleutils: filename=littleutils-0.2.2-py3-none-any.whl size=7029 sha256=964d8de165b461c9191e2a1db5c131a8786745d89071a36340ba25052f37c15d\n","  Stored in directory: /root/.cache/pip/wheels/3d/fe/b0/27a9892da57472e538c7452a721a9cf463cc03cf7379889266\n","Successfully built littleutils\n","Installing collected packages: littleutils, outdated, pandas-flavor, pingouin\n","Successfully installed littleutils-0.2.2 outdated-0.2.2 pandas-flavor-0.6.0 pingouin-0.5.3\n"]}]},{"cell_type":"code","source":["import pandas as pd # leitura e manipulacao de arquivos\n","import numpy as np # analise numerica\n","import seaborn as sns # analise grafica\n","import matplotlib.pyplot as plt # analise grafica"],"metadata":{"id":"3wVt9q-ciiP7","executionInfo":{"status":"ok","timestamp":1692981757297,"user_tz":180,"elapsed":247,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}}},"execution_count":16,"outputs":[]},{"cell_type":"code","source":["import pingouin as pg\n","from spicy import stats as st"],"metadata":{"id":"P8zH7JKVivHX","executionInfo":{"status":"ok","timestamp":1692981312565,"user_tz":180,"elapsed":634,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}}},"execution_count":9,"outputs":[]},{"cell_type":"markdown","source":["##Dados"],"metadata":{"id":"TwcPoNo9mIGY"}},{"cell_type":"code","source":["# dados\n","dados_tratamentos = pd.read_csv('dados_tratamentos.csv', sep=';')\n","dados_bolsa = pd.read_csv('dados_bolsa.csv', sep=';', decimal=',')\n","dados_nps = pd.read_csv('nps_example.csv', sep=';')"],"metadata":{"id":"8YzMARF0i1mW","executionInfo":{"status":"ok","timestamp":1692982058349,"user_tz":180,"elapsed":271,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}}},"execution_count":17,"outputs":[]},{"cell_type":"code","source":["dados_tratamentos.head()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"_qcbElENkomG","executionInfo":{"status":"ok","timestamp":1692981701093,"user_tz":180,"elapsed":338,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"0c8beed9-321f-4cbb-9b77-2bc15d35ed45"},"execution_count":13,"outputs":[{"output_type":"execute_result","data":{"text/plain":["   id   tratamento      evolucao\n","0   1      tratado      melhorou\n","1   2      tratado      melhorou\n","2   3  nao-tratado      melhorou\n","3   4      tratado      melhorou\n","4   5      tratado  nao-melhorou"],"text/html":["\n","  <div id=\"df-1a3f8666-650b-49d0-ad8b-ed897d13484b\" class=\"colab-df-container\">\n","    <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>id</th>\n","      <th>tratamento</th>\n","      <th>evolucao</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>tratado</td>\n","      <td>melhorou</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2</td>\n","      <td>tratado</td>\n","      <td>melhorou</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>3</td>\n","      <td>nao-tratado</td>\n","      <td>melhorou</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>4</td>\n","      <td>tratado</td>\n","      <td>melhorou</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>5</td>\n","      <td>tratado</td>\n","      <td>nao-melhorou</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1a3f8666-650b-49d0-ad8b-ed897d13484b')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-1a3f8666-650b-49d0-ad8b-ed897d13484b 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-1a3f8666-650b-49d0-ad8b-ed897d13484b');\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","\n","\n","<div id=\"df-1315ad3d-237a-450b-86fc-7feb220b19d4\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-1315ad3d-237a-450b-86fc-7feb220b19d4')\"\n","            title=\"Suggest charts.\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\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-quickchart: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-quickchart {\n","    background-color: #3B4455;\n","    fill: #D2E3FC;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart: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","    async function quickchart(key) {\n","      const charts = await google.colab.kernel.invokeFunction(\n","          'suggestCharts', [key], {});\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-1315ad3d-237a-450b-86fc-7feb220b19d4 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":13}]},{"cell_type":"code","source":["dados_bolsa.head()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"3PZIE7fLkq8J","executionInfo":{"status":"ok","timestamp":1692982061427,"user_tz":180,"elapsed":247,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"7d1ecdc8-b2e4-4ec9-d3bf-68f6ddc8491e"},"execution_count":18,"outputs":[{"output_type":"execute_result","data":{"text/plain":["         data     petr4     bbdc3     vale5     ambv4     itub4\n","0  2004-05-26 -0.002270  0.009524  0.013699  0.032668  0.009843\n","1  2004-05-27  0.026301  0.028396  0.028303  0.014060  0.021442\n","2  2004-05-28 -0.016484 -0.000092 -0.025261  0.019151  0.000000\n","3  2004-05-31  0.010986 -0.009174  0.011235 -0.001786  0.000000\n","4  2004-06-01  0.028142  0.023056 -0.004518  0.013629  0.012107"],"text/html":["\n","  <div id=\"df-a76e4987-f672-468a-93a1-653120a26918\" class=\"colab-df-container\">\n","    <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>data</th>\n","      <th>petr4</th>\n","      <th>bbdc3</th>\n","      <th>vale5</th>\n","      <th>ambv4</th>\n","      <th>itub4</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>2004-05-26</td>\n","      <td>-0.002270</td>\n","      <td>0.009524</td>\n","      <td>0.013699</td>\n","      <td>0.032668</td>\n","      <td>0.009843</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2004-05-27</td>\n","      <td>0.026301</td>\n","      <td>0.028396</td>\n","      <td>0.028303</td>\n","      <td>0.014060</td>\n","      <td>0.021442</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2004-05-28</td>\n","      <td>-0.016484</td>\n","      <td>-0.000092</td>\n","      <td>-0.025261</td>\n","      <td>0.019151</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2004-05-31</td>\n","      <td>0.010986</td>\n","      <td>-0.009174</td>\n","      <td>0.011235</td>\n","      <td>-0.001786</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>2004-06-01</td>\n","      <td>0.028142</td>\n","      <td>0.023056</td>\n","      <td>-0.004518</td>\n","      <td>0.013629</td>\n","      <td>0.012107</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a76e4987-f672-468a-93a1-653120a26918')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-a76e4987-f672-468a-93a1-653120a26918 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-a76e4987-f672-468a-93a1-653120a26918');\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","\n","\n","<div id=\"df-ef72e73e-7282-4c53-8e11-379be0fe84d4\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-ef72e73e-7282-4c53-8e11-379be0fe84d4')\"\n","            title=\"Suggest charts.\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\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-quickchart: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-quickchart {\n","    background-color: #3B4455;\n","    fill: #D2E3FC;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart: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","    async function quickchart(key) {\n","      const charts = await google.colab.kernel.invokeFunction(\n","          'suggestCharts', [key], {});\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-ef72e73e-7282-4c53-8e11-379be0fe84d4 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":18}]},{"cell_type":"code","source":["dados_nps.head()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"FV-s90GCktXE","executionInfo":{"status":"ok","timestamp":1692981720773,"user_tz":180,"elapsed":254,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"15ba4526-0287-46c1-86bb-a3889dce01eb"},"execution_count":15,"outputs":[{"output_type":"execute_result","data":{"text/plain":["         id response_status            how_long_listening    age  nps_score  \\\n","0  11706300        Complete            Less than 6 months  25-34       10.0   \n","1  11706302        Complete   1 year to less than 3 years  25-34       10.0   \n","2  11706307        Complete  6 months to less than a year  35-44       10.0   \n","3  11706312        Complete            Less than 6 months  35-44       10.0   \n","4  11706316        Complete  6 months to less than a year  25-34       10.0   \n","\n","   gender  \n","0  Female  \n","1  Female  \n","2  Female  \n","3  Female  \n","4    Male  "],"text/html":["\n","  <div id=\"df-8ad93d9b-d8ff-4848-9b2c-b2028b927a44\" class=\"colab-df-container\">\n","    <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>id</th>\n","      <th>response_status</th>\n","      <th>how_long_listening</th>\n","      <th>age</th>\n","      <th>nps_score</th>\n","      <th>gender</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>11706300</td>\n","      <td>Complete</td>\n","      <td>Less than 6 months</td>\n","      <td>25-34</td>\n","      <td>10.0</td>\n","      <td>Female</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>11706302</td>\n","      <td>Complete</td>\n","      <td>1 year to less than 3 years</td>\n","      <td>25-34</td>\n","      <td>10.0</td>\n","      <td>Female</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>11706307</td>\n","      <td>Complete</td>\n","      <td>6 months to less than a year</td>\n","      <td>35-44</td>\n","      <td>10.0</td>\n","      <td>Female</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>11706312</td>\n","      <td>Complete</td>\n","      <td>Less than 6 months</td>\n","      <td>35-44</td>\n","      <td>10.0</td>\n","      <td>Female</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>11706316</td>\n","      <td>Complete</td>\n","      <td>6 months to less than a year</td>\n","      <td>25-34</td>\n","      <td>10.0</td>\n","      <td>Male</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-8ad93d9b-d8ff-4848-9b2c-b2028b927a44')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-8ad93d9b-d8ff-4848-9b2c-b2028b927a44 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-8ad93d9b-d8ff-4848-9b2c-b2028b927a44');\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","\n","\n","<div id=\"df-396dede2-a7fb-450d-b3dc-b371604c3195\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-396dede2-a7fb-450d-b3dc-b371604c3195')\"\n","            title=\"Suggest charts.\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\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-quickchart: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-quickchart {\n","    background-color: #3B4455;\n","    fill: #D2E3FC;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart: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","    async function quickchart(key) {\n","      const charts = await google.colab.kernel.invokeFunction(\n","          'suggestCharts', [key], {});\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-396dede2-a7fb-450d-b3dc-b371604c3195 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":15}]},{"cell_type":"markdown","source":["##Phi"],"metadata":{"id":"feehet3RmLAs"}},{"cell_type":"code","source":["# crosstab- criar tabelas cruzadas\n","tabela = pd.crosstab(dados_tratamentos['tratamento'],\n","                     dados_tratamentos['evolucao'])\n","tabela"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":143},"id":"_lFxIrnymMiZ","executionInfo":{"status":"ok","timestamp":1692982345736,"user_tz":180,"elapsed":253,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"da4843ef-0e9e-42bf-a111-16b36c498915"},"execution_count":19,"outputs":[{"output_type":"execute_result","data":{"text/plain":["evolucao     melhorou  nao-melhorou\n","tratamento                         \n","nao-tratado        26            29\n","tratado            35            15"],"text/html":["\n","  <div id=\"df-bed7d907-475d-41f1-893b-9170a9dcad3a\" 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>evolucao</th>\n","      <th>melhorou</th>\n","      <th>nao-melhorou</th>\n","    </tr>\n","    <tr>\n","      <th>tratamento</th>\n","      <th></th>\n","      <th></th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>nao-tratado</th>\n","      <td>26</td>\n","      <td>29</td>\n","    </tr>\n","    <tr>\n","      <th>tratado</th>\n","      <td>35</td>\n","      <td>15</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-bed7d907-475d-41f1-893b-9170a9dcad3a')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-bed7d907-475d-41f1-893b-9170a9dcad3a 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-bed7d907-475d-41f1-893b-9170a9dcad3a');\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","\n","\n","<div id=\"df-9036c0da-9b4b-45c6-b8c7-4cb537b7998d\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-9036c0da-9b4b-45c6-b8c7-4cb537b7998d')\"\n","            title=\"Suggest charts.\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\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-quickchart: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-quickchart {\n","    background-color: #3B4455;\n","    fill: #D2E3FC;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart: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","    async function quickchart(key) {\n","      const charts = await google.colab.kernel.invokeFunction(\n","          'suggestCharts', [key], {});\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-9036c0da-9b4b-45c6-b8c7-4cb537b7998d button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":19}]},{"cell_type":"code","source":["# obter qui-quadrado\n","qui_quadrado = st.chi2_contingency(tabela)[0]\n","qui_quadrado"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"LiIHcCPip5nJ","executionInfo":{"status":"ok","timestamp":1692983586753,"user_tz":180,"elapsed":357,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"a9891750-5442-4980-afbd-bf0ef3c0446a"},"execution_count":28,"outputs":[{"output_type":"execute_result","data":{"text/plain":["4.6625668947297125"]},"metadata":{},"execution_count":28}]},{"cell_type":"code","source":["# tamanho da amostra\n","n = np.sum(np.sum(tabela))\n","n"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"ArfkKoABr4gS","executionInfo":{"status":"ok","timestamp":1692983674207,"user_tz":180,"elapsed":268,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"2aad683f-3b04-4017-b6b6-5ea79a7f7d94"},"execution_count":31,"outputs":[{"output_type":"execute_result","data":{"text/plain":["105"]},"metadata":{},"execution_count":31}]},{"cell_type":"code","source":["# obter o Phi\n","Phi = np.sqrt(qui_quadrado / n)\n","Phi"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"7L1Nov4TsNHG","executionInfo":{"status":"ok","timestamp":1692983769263,"user_tz":180,"elapsed":2,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"a52a98d1-3252-49c0-e5f0-dea018beac5d"},"execution_count":32,"outputs":[{"output_type":"execute_result","data":{"text/plain":["0.21072588592155886"]},"metadata":{},"execution_count":32}]},{"cell_type":"markdown","source":["##Teste de Qui-Quadrado"],"metadata":{"id":"a9wmQZbjs3jK"}},{"cell_type":"code","source":["qui, p, gl, t_esp = st.chi2_contingency(tabela)\n","qui, p"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"NrkGYmzSs7UB","executionInfo":{"status":"ok","timestamp":1692984043923,"user_tz":180,"elapsed":302,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"2f24c844-1409-42e0-b590-f259441b0784"},"execution_count":38,"outputs":[{"output_type":"execute_result","data":{"text/plain":["(4.6625668947297125, 0.030827072412198585)"]},"metadata":{},"execution_count":38}]},{"cell_type":"markdown","source":["Temos evidencia para rejeitar a hipotese nula, uma vez que o p-value resultou um valor menor que 0.05"],"metadata":{"id":"LLNrvFHkz5Y3"}},{"cell_type":"markdown","source":["##V de cramer"],"metadata":{"id":"Ps7qGIWw0ExV"}},{"cell_type":"code","source":["# limpeza nos dados\n","dados_nps_filtrados = dados_nps[(dados_nps['response_status'] == 'Complete') & (dados_nps['nps_score'].notna()) & (dados_nps['gender'].notna())].reset_index()"],"metadata":{"id":"TlW5xEV20HRX","executionInfo":{"status":"ok","timestamp":1692986305237,"user_tz":180,"elapsed":273,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}}},"execution_count":42,"outputs":[]},{"cell_type":"code","source":["# criar grupos\n","def create_nps_groups (x):\n","  if x <= 5:\n","    return 'detratores'\n","  elif x >= 9:\n","    return 'promotores'\n","  else:\n","    return 'neutros'"],"metadata":{"id":"QH5_j-Fu2PmX","executionInfo":{"status":"ok","timestamp":1692986477143,"user_tz":180,"elapsed":270,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}}},"execution_count":44,"outputs":[]},{"cell_type":"code","source":["# aplicar a função\n","dados_nps_filtrados['nps_groups'] = dados_nps_filtrados['nps_score'].apply(lambda x: create_nps_groups(x))"],"metadata":{"id":"7AoWqfVv20WS","executionInfo":{"status":"ok","timestamp":1692986863771,"user_tz":180,"elapsed":274,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}}},"execution_count":48,"outputs":[]},{"cell_type":"code","source":["# verificando a função\n","dados_nps_filtrados.groupby('nps_groups').size().to_frame('n')"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":175},"id":"u6JQrTlm3XhO","executionInfo":{"status":"ok","timestamp":1692986894630,"user_tz":180,"elapsed":284,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"53fbfe6b-3fca-4948-f4dc-505503296c86"},"execution_count":50,"outputs":[{"output_type":"execute_result","data":{"text/plain":["               n\n","nps_groups      \n","detratores    25\n","neutros      171\n","promotores  2047"],"text/html":["\n","  <div id=\"df-33b35cb8-8c4e-4395-8e51-d0b46d4bae93\" class=\"colab-df-container\">\n","    <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>n</th>\n","    </tr>\n","    <tr>\n","      <th>nps_groups</th>\n","      <th></th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>detratores</th>\n","      <td>25</td>\n","    </tr>\n","    <tr>\n","      <th>neutros</th>\n","      <td>171</td>\n","    </tr>\n","    <tr>\n","      <th>promotores</th>\n","      <td>2047</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-33b35cb8-8c4e-4395-8e51-d0b46d4bae93')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-33b35cb8-8c4e-4395-8e51-d0b46d4bae93 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-33b35cb8-8c4e-4395-8e51-d0b46d4bae93');\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","\n","\n","<div id=\"df-69870579-0f61-443a-bd26-e46f93c4bd45\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-69870579-0f61-443a-bd26-e46f93c4bd45')\"\n","            title=\"Suggest charts.\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\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-quickchart: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-quickchart {\n","    background-color: #3B4455;\n","    fill: #D2E3FC;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart: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","    async function quickchart(key) {\n","      const charts = await google.colab.kernel.invokeFunction(\n","          'suggestCharts', [key], {});\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-69870579-0f61-443a-bd26-e46f93c4bd45 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":50}]},{"cell_type":"code","source":["# criando tabela cruzada\n","tabela = pd.crosstab(dados_nps_filtrados['gender'],\n","                     dados_nps_filtrados['nps_groups'])\n","tabela"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":143},"id":"l5fKvE3F3vt5","executionInfo":{"status":"ok","timestamp":1692986931075,"user_tz":180,"elapsed":273,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"4e121a89-87aa-47e4-d54a-1a5c7444ba0b"},"execution_count":53,"outputs":[{"output_type":"execute_result","data":{"text/plain":["nps_groups  detratores  neutros  promotores\n","gender                                     \n","Female              12      105        1565\n","Male                13       66         482"],"text/html":["\n","  <div id=\"df-f62f9348-53bc-4a94-ae63-4a2ddfa40f88\" 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>nps_groups</th>\n","      <th>detratores</th>\n","      <th>neutros</th>\n","      <th>promotores</th>\n","    </tr>\n","    <tr>\n","      <th>gender</th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>Female</th>\n","      <td>12</td>\n","      <td>105</td>\n","      <td>1565</td>\n","    </tr>\n","    <tr>\n","      <th>Male</th>\n","      <td>13</td>\n","      <td>66</td>\n","      <td>482</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f62f9348-53bc-4a94-ae63-4a2ddfa40f88')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-f62f9348-53bc-4a94-ae63-4a2ddfa40f88 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-f62f9348-53bc-4a94-ae63-4a2ddfa40f88');\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","\n","\n","<div id=\"df-bad47734-e728-4eb4-a3be-3b7e9990baeb\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-bad47734-e728-4eb4-a3be-3b7e9990baeb')\"\n","            title=\"Suggest charts.\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\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-quickchart: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-quickchart {\n","    background-color: #3B4455;\n","    fill: #D2E3FC;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart: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","    async function quickchart(key) {\n","      const charts = await google.colab.kernel.invokeFunction(\n","          'suggestCharts', [key], {});\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-bad47734-e728-4eb4-a3be-3b7e9990baeb button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":53}]},{"cell_type":"code","source":["# v de cramer método 1\n","vcramer_1 = st.contingency.association(tabela, method='cramer')\n","vcramer_1"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"YzgQ2hOn41u9","executionInfo":{"status":"ok","timestamp":1692987085613,"user_tz":180,"elapsed":281,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"c2926e16-acf4-4aa3-be55-a19d10e180de"},"execution_count":54,"outputs":[{"output_type":"execute_result","data":{"text/plain":["0.1134646600588705"]},"metadata":{},"execution_count":54}]},{"cell_type":"code","source":["# v de cramer método 2\n","# obter valor do qui quadrado\n","qui_quadrado = st.chi2_contingency(tabela)[0]"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"wgMKk0Gz5Q_1","executionInfo":{"status":"ok","timestamp":1692987154503,"user_tz":180,"elapsed":291,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"391f8187-ce11-4aac-d9ff-dc2200b83580"},"execution_count":55,"outputs":[{"output_type":"execute_result","data":{"text/plain":["0.1134646600588705"]},"metadata":{},"execution_count":55}]},{"cell_type":"code","source":["# tamanho da amostra\n","n = np.sum(np.sum(tabela))\n","n"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"p7ZW-pSF7A4u","executionInfo":{"status":"ok","timestamp":1692987602247,"user_tz":180,"elapsed":271,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"4bc31fad-4db3-46cb-a18b-dcae56176a68"},"execution_count":60,"outputs":[{"output_type":"execute_result","data":{"text/plain":["2243"]},"metadata":{},"execution_count":60}]},{"cell_type":"code","source":["# minimo entre r e c\n","minshape = min(tabela.shape)-1\n","minshape"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"0HXD9Yxy7ERx","executionInfo":{"status":"ok","timestamp":1692987608370,"user_tz":180,"elapsed":288,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"27f02244-49ab-427d-94ec-62e52cc364e7"},"execution_count":61,"outputs":[{"output_type":"execute_result","data":{"text/plain":["1"]},"metadata":{},"execution_count":61}]},{"cell_type":"code","source":["# v de cramer\n","vcramer_2 = np.sqrt(qui_quadrado / (n * minshape))\n","vcramer_2"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"coBhdf_B7Iwf","executionInfo":{"status":"ok","timestamp":1692987595210,"user_tz":180,"elapsed":4,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"6fa74869-b2ca-453b-9c24-a66249ce7a45"},"execution_count":59,"outputs":[{"output_type":"execute_result","data":{"text/plain":["0.1134646600588705"]},"metadata":{},"execution_count":59}]},{"cell_type":"code","source":["# teste qui-quadrado\n","qui, p, gl, t_esp = st.chi2_contingency(tabela)\n","qui, p"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"Fw1e37lF5peT","executionInfo":{"status":"ok","timestamp":1692987262081,"user_tz":180,"elapsed":272,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"7be5a755-d88e-4dc2-fea9-c93ddfe4a4f9"},"execution_count":56,"outputs":[{"output_type":"execute_result","data":{"text/plain":["(28.87689583154292, 5.363666207418583e-07)"]},"metadata":{},"execution_count":56}]},{"cell_type":"markdown","source":["Temos evidencia para rejeitar a hipotese nula, uma vez que o p-value resultou um valor menor que 0.05"],"metadata":{"id":"xoP4QwC37aZq"}},{"cell_type":"markdown","source":["##Correlação"],"metadata":{"id":"PTKwS0n57emo"}},{"cell_type":"code","source":["# verificar dados nulos\n","dados_bolsa[dados_bolsa.isnull()]"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":423},"id":"s97kJD5N7hEl","executionInfo":{"status":"ok","timestamp":1692987778871,"user_tz":180,"elapsed":291,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"a3f6b760-e9de-4c86-ef9f-e7d887465955"},"execution_count":62,"outputs":[{"output_type":"execute_result","data":{"text/plain":["     data  petr4  bbdc3  vale5  ambv4  itub4\n","0     NaN    NaN    NaN    NaN    NaN    NaN\n","1     NaN    NaN    NaN    NaN    NaN    NaN\n","2     NaN    NaN    NaN    NaN    NaN    NaN\n","3     NaN    NaN    NaN    NaN    NaN    NaN\n","4     NaN    NaN    NaN    NaN    NaN    NaN\n","...   ...    ...    ...    ...    ...    ...\n","1773  NaN    NaN    NaN    NaN    NaN    NaN\n","1774  NaN    NaN    NaN    NaN    NaN    NaN\n","1775  NaN    NaN    NaN    NaN    NaN    NaN\n","1776  NaN    NaN    NaN    NaN    NaN    NaN\n","1777  NaN    NaN    NaN    NaN    NaN    NaN\n","\n","[1778 rows x 6 columns]"],"text/html":["\n","  <div id=\"df-4e07c2ed-d3dd-4be7-adcb-1935a3c42143\" class=\"colab-df-container\">\n","    <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>data</th>\n","      <th>petr4</th>\n","      <th>bbdc3</th>\n","      <th>vale5</th>\n","      <th>ambv4</th>\n","      <th>itub4</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>1773</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1774</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1775</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1776</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1777</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>1778 rows × 6 columns</p>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-4e07c2ed-d3dd-4be7-adcb-1935a3c42143')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-4e07c2ed-d3dd-4be7-adcb-1935a3c42143 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-4e07c2ed-d3dd-4be7-adcb-1935a3c42143');\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","\n","\n","<div id=\"df-3017b895-3747-4c91-921b-6b25ae4025a3\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-3017b895-3747-4c91-921b-6b25ae4025a3')\"\n","            title=\"Suggest charts.\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\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-quickchart: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-quickchart {\n","    background-color: #3B4455;\n","    fill: #D2E3FC;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart: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","    async function quickchart(key) {\n","      const charts = await google.colab.kernel.invokeFunction(\n","          'suggestCharts', [key], {});\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-3017b895-3747-4c91-921b-6b25ae4025a3 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":62}]},{"cell_type":"code","source":["# tratar os dados nulos\n","dados_bolsa_filtrados = dados_bolsa.dropna()\n","dados_bolsa_filtrados"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":423},"id":"Uk2lFEOi73cf","executionInfo":{"status":"ok","timestamp":1692987806291,"user_tz":180,"elapsed":268,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"e857057a-d6aa-4a09-b078-1d2f996758fb"},"execution_count":64,"outputs":[{"output_type":"execute_result","data":{"text/plain":["            data     petr4     bbdc3     vale5     ambv4     itub4\n","0     2004-05-26 -0.002270  0.009524  0.013699  0.032668  0.009843\n","1     2004-05-27  0.026301  0.028396  0.028303  0.014060  0.021442\n","2     2004-05-28 -0.016484 -0.000092 -0.025261  0.019151  0.000000\n","3     2004-05-31  0.010986 -0.009174  0.011235 -0.001786  0.000000\n","4     2004-06-01  0.028142  0.023056 -0.004518  0.013629  0.012107\n","...          ...       ...       ...       ...       ...       ...\n","1773  2011-03-14  0.003905 -0.000407 -0.002139 -0.010953  0.004765\n","1774  2011-03-15 -0.008487  0.004473 -0.016724 -0.004873  0.011994\n","1775  2011-03-16 -0.009272 -0.017409 -0.025294 -0.020699 -0.023705\n","1776  2011-03-17  0.010799 -0.001236  0.027293 -0.001136 -0.005364\n","1777  2011-03-18 -0.006410  0.011551  0.019817  0.012287  0.021289\n","\n","[1604 rows x 6 columns]"],"text/html":["\n","  <div id=\"df-fc511902-0cbd-4bc2-afad-9a414998b2c7\" class=\"colab-df-container\">\n","    <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>data</th>\n","      <th>petr4</th>\n","      <th>bbdc3</th>\n","      <th>vale5</th>\n","      <th>ambv4</th>\n","      <th>itub4</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>2004-05-26</td>\n","      <td>-0.002270</td>\n","      <td>0.009524</td>\n","      <td>0.013699</td>\n","      <td>0.032668</td>\n","      <td>0.009843</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2004-05-27</td>\n","      <td>0.026301</td>\n","      <td>0.028396</td>\n","      <td>0.028303</td>\n","      <td>0.014060</td>\n","      <td>0.021442</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2004-05-28</td>\n","      <td>-0.016484</td>\n","      <td>-0.000092</td>\n","      <td>-0.025261</td>\n","      <td>0.019151</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2004-05-31</td>\n","      <td>0.010986</td>\n","      <td>-0.009174</td>\n","      <td>0.011235</td>\n","      <td>-0.001786</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>2004-06-01</td>\n","      <td>0.028142</td>\n","      <td>0.023056</td>\n","      <td>-0.004518</td>\n","      <td>0.013629</td>\n","      <td>0.012107</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","    </tr>\n","    <tr>\n","      <th>1773</th>\n","      <td>2011-03-14</td>\n","      <td>0.003905</td>\n","      <td>-0.000407</td>\n","      <td>-0.002139</td>\n","      <td>-0.010953</td>\n","      <td>0.004765</td>\n","    </tr>\n","    <tr>\n","      <th>1774</th>\n","      <td>2011-03-15</td>\n","      <td>-0.008487</td>\n","      <td>0.004473</td>\n","      <td>-0.016724</td>\n","      <td>-0.004873</td>\n","      <td>0.011994</td>\n","    </tr>\n","    <tr>\n","      <th>1775</th>\n","      <td>2011-03-16</td>\n","      <td>-0.009272</td>\n","      <td>-0.017409</td>\n","      <td>-0.025294</td>\n","      <td>-0.020699</td>\n","      <td>-0.023705</td>\n","    </tr>\n","    <tr>\n","      <th>1776</th>\n","      <td>2011-03-17</td>\n","      <td>0.010799</td>\n","      <td>-0.001236</td>\n","      <td>0.027293</td>\n","      <td>-0.001136</td>\n","      <td>-0.005364</td>\n","    </tr>\n","    <tr>\n","      <th>1777</th>\n","      <td>2011-03-18</td>\n","      <td>-0.006410</td>\n","      <td>0.011551</td>\n","      <td>0.019817</td>\n","      <td>0.012287</td>\n","      <td>0.021289</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>1604 rows × 6 columns</p>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-fc511902-0cbd-4bc2-afad-9a414998b2c7')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-fc511902-0cbd-4bc2-afad-9a414998b2c7 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-fc511902-0cbd-4bc2-afad-9a414998b2c7');\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","\n","\n","<div id=\"df-089f7a67-8c25-4245-8882-9d0307a8275b\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-089f7a67-8c25-4245-8882-9d0307a8275b')\"\n","            title=\"Suggest charts.\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\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-quickchart: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-quickchart {\n","    background-color: #3B4455;\n","    fill: #D2E3FC;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart: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","    async function quickchart(key) {\n","      const charts = await google.colab.kernel.invokeFunction(\n","          'suggestCharts', [key], {});\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-089f7a67-8c25-4245-8882-9d0307a8275b button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":64}]},{"cell_type":"markdown","source":["\n","\n","*   Pearson\n","\n"],"metadata":{"id":"x6lq3bOD8jTV"}},{"cell_type":"code","source":["# correlacao\n","pearson_correl = dados_bolsa_filtrados.corr()\n","pearson_correl"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":262},"id":"s_Ej-Jhf8mLN","executionInfo":{"status":"ok","timestamp":1692988014650,"user_tz":180,"elapsed":273,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"cc974a1c-16c1-4985-c802-3df54bd1da99"},"execution_count":65,"outputs":[{"output_type":"stream","name":"stderr","text":["<ipython-input-65-545e8d9cee13>:2: FutureWarning: The default value of numeric_only in DataFrame.corr is deprecated. In a future version, it will default to False. Select only valid columns or specify the value of numeric_only to silence this warning.\n","  pearson_correl = dados_bolsa_filtrados.corr()\n"]},{"output_type":"execute_result","data":{"text/plain":["          petr4     bbdc3     vale5     ambv4     itub4\n","petr4  1.000000  0.539247  0.724023  0.392074  0.593834\n","bbdc3  0.539247  1.000000  0.592143  0.470529  0.778506\n","vale5  0.724023  0.592143  1.000000  0.482919  0.642838\n","ambv4  0.392074  0.470529  0.482919  1.000000  0.488886\n","itub4  0.593834  0.778506  0.642838  0.488886  1.000000"],"text/html":["\n","  <div id=\"df-1e947f7c-9c1b-433d-837f-20cf74f3c38e\" class=\"colab-df-container\">\n","    <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>petr4</th>\n","      <th>bbdc3</th>\n","      <th>vale5</th>\n","      <th>ambv4</th>\n","      <th>itub4</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>petr4</th>\n","      <td>1.000000</td>\n","      <td>0.539247</td>\n","      <td>0.724023</td>\n","      <td>0.392074</td>\n","      <td>0.593834</td>\n","    </tr>\n","    <tr>\n","      <th>bbdc3</th>\n","      <td>0.539247</td>\n","      <td>1.000000</td>\n","      <td>0.592143</td>\n","      <td>0.470529</td>\n","      <td>0.778506</td>\n","    </tr>\n","    <tr>\n","      <th>vale5</th>\n","      <td>0.724023</td>\n","      <td>0.592143</td>\n","      <td>1.000000</td>\n","      <td>0.482919</td>\n","      <td>0.642838</td>\n","    </tr>\n","    <tr>\n","      <th>ambv4</th>\n","      <td>0.392074</td>\n","      <td>0.470529</td>\n","      <td>0.482919</td>\n","      <td>1.000000</td>\n","      <td>0.488886</td>\n","    </tr>\n","    <tr>\n","      <th>itub4</th>\n","      <td>0.593834</td>\n","      <td>0.778506</td>\n","      <td>0.642838</td>\n","      <td>0.488886</td>\n","      <td>1.000000</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1e947f7c-9c1b-433d-837f-20cf74f3c38e')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-1e947f7c-9c1b-433d-837f-20cf74f3c38e 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-1e947f7c-9c1b-433d-837f-20cf74f3c38e');\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","\n","\n","<div id=\"df-ea901b0a-f3e6-4e1e-b529-0201f610b384\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-ea901b0a-f3e6-4e1e-b529-0201f610b384')\"\n","            title=\"Suggest charts.\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\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-quickchart: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-quickchart {\n","    background-color: #3B4455;\n","    fill: #D2E3FC;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart: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","    async function quickchart(key) {\n","      const charts = await google.colab.kernel.invokeFunction(\n","          'suggestCharts', [key], {});\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-ea901b0a-f3e6-4e1e-b529-0201f610b384 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":65}]},{"cell_type":"code","source":["# matriz ajustada\n","pearson_correl.style.background_gradient(cmap='coolwarm').set_precision(2)"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":262},"id":"znjOsstx81nm","executionInfo":{"status":"ok","timestamp":1692988306733,"user_tz":180,"elapsed":312,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"f6e6322c-8397-4535-9af3-009048ed35cb"},"execution_count":69,"outputs":[{"output_type":"stream","name":"stderr","text":["<ipython-input-69-254f00349427>:2: FutureWarning: this method is deprecated in favour of `Styler.format(precision=..)`\n","  pearson_correl.style.background_gradient(cmap='coolwarm').set_precision(2)\n"]},{"output_type":"execute_result","data":{"text/plain":["<pandas.io.formats.style.Styler at 0x7e30129446a0>"],"text/html":["<style type=\"text/css\">\n","#T_af196_row0_col0, #T_af196_row1_col1, #T_af196_row2_col2, #T_af196_row3_col3, #T_af196_row4_col4 {\n","  background-color: #b40426;\n","  color: #f1f1f1;\n","}\n","#T_af196_row0_col1, #T_af196_row1_col3 {\n","  background-color: #6384eb;\n","  color: #f1f1f1;\n","}\n","#T_af196_row0_col2 {\n","  background-color: #d4dbe6;\n","  color: #000000;\n","}\n","#T_af196_row0_col3, #T_af196_row3_col0, #T_af196_row3_col1, #T_af196_row3_col2, #T_af196_row3_col4 {\n","  background-color: #3b4cc0;\n","  color: #f1f1f1;\n","}\n","#T_af196_row0_col4 {\n","  background-color: #7da0f9;\n","  color: #f1f1f1;\n","}\n","#T_af196_row1_col0 {\n","  background-color: #89acfd;\n","  color: #000000;\n","}\n","#T_af196_row1_col2 {\n","  background-color: #80a3fa;\n","  color: #f1f1f1;\n","}\n","#T_af196_row1_col4 {\n","  background-color: #edd2c3;\n","  color: #000000;\n","}\n","#T_af196_row2_col0 {\n","  background-color: #e8d6cc;\n","  color: #000000;\n","}\n","#T_af196_row2_col1 {\n","  background-color: #85a8fc;\n","  color: #f1f1f1;\n","}\n","#T_af196_row2_col3 {\n","  background-color: #6a8bef;\n","  color: #f1f1f1;\n","}\n","#T_af196_row2_col4 {\n","  background-color: #9fbfff;\n","  color: #000000;\n","}\n","#T_af196_row4_col0 {\n","  background-color: #a9c6fd;\n","  color: #000000;\n","}\n","#T_af196_row4_col1 {\n","  background-color: #efcfbf;\n","  color: #000000;\n","}\n","#T_af196_row4_col2 {\n","  background-color: #a2c1ff;\n","  color: #000000;\n","}\n","#T_af196_row4_col3 {\n","  background-color: #6c8ff1;\n","  color: #f1f1f1;\n","}\n","</style>\n","<table id=\"T_af196\" class=\"dataframe\">\n","  <thead>\n","    <tr>\n","      <th class=\"blank level0\" >&nbsp;</th>\n","      <th id=\"T_af196_level0_col0\" class=\"col_heading level0 col0\" >petr4</th>\n","      <th id=\"T_af196_level0_col1\" class=\"col_heading level0 col1\" >bbdc3</th>\n","      <th id=\"T_af196_level0_col2\" class=\"col_heading level0 col2\" >vale5</th>\n","      <th id=\"T_af196_level0_col3\" class=\"col_heading level0 col3\" >ambv4</th>\n","      <th id=\"T_af196_level0_col4\" class=\"col_heading level0 col4\" >itub4</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th id=\"T_af196_level0_row0\" class=\"row_heading level0 row0\" >petr4</th>\n","      <td id=\"T_af196_row0_col0\" class=\"data row0 col0\" >1.00</td>\n","      <td id=\"T_af196_row0_col1\" class=\"data row0 col1\" >0.54</td>\n","      <td id=\"T_af196_row0_col2\" class=\"data row0 col2\" >0.72</td>\n","      <td id=\"T_af196_row0_col3\" class=\"data row0 col3\" >0.39</td>\n","      <td id=\"T_af196_row0_col4\" class=\"data row0 col4\" >0.59</td>\n","    </tr>\n","    <tr>\n","      <th id=\"T_af196_level0_row1\" class=\"row_heading level0 row1\" >bbdc3</th>\n","      <td id=\"T_af196_row1_col0\" class=\"data row1 col0\" >0.54</td>\n","      <td id=\"T_af196_row1_col1\" class=\"data row1 col1\" >1.00</td>\n","      <td id=\"T_af196_row1_col2\" class=\"data row1 col2\" >0.59</td>\n","      <td id=\"T_af196_row1_col3\" class=\"data row1 col3\" >0.47</td>\n","      <td id=\"T_af196_row1_col4\" class=\"data row1 col4\" >0.78</td>\n","    </tr>\n","    <tr>\n","      <th id=\"T_af196_level0_row2\" class=\"row_heading level0 row2\" >vale5</th>\n","      <td id=\"T_af196_row2_col0\" class=\"data row2 col0\" >0.72</td>\n","      <td id=\"T_af196_row2_col1\" class=\"data row2 col1\" >0.59</td>\n","      <td id=\"T_af196_row2_col2\" class=\"data row2 col2\" >1.00</td>\n","      <td id=\"T_af196_row2_col3\" class=\"data row2 col3\" >0.48</td>\n","      <td id=\"T_af196_row2_col4\" class=\"data row2 col4\" >0.64</td>\n","    </tr>\n","    <tr>\n","      <th id=\"T_af196_level0_row3\" class=\"row_heading level0 row3\" >ambv4</th>\n","      <td id=\"T_af196_row3_col0\" class=\"data row3 col0\" >0.39</td>\n","      <td id=\"T_af196_row3_col1\" class=\"data row3 col1\" >0.47</td>\n","      <td id=\"T_af196_row3_col2\" class=\"data row3 col2\" >0.48</td>\n","      <td id=\"T_af196_row3_col3\" class=\"data row3 col3\" >1.00</td>\n","      <td id=\"T_af196_row3_col4\" class=\"data row3 col4\" >0.49</td>\n","    </tr>\n","    <tr>\n","      <th id=\"T_af196_level0_row4\" class=\"row_heading level0 row4\" >itub4</th>\n","      <td id=\"T_af196_row4_col0\" class=\"data row4 col0\" >0.59</td>\n","      <td id=\"T_af196_row4_col1\" class=\"data row4 col1\" >0.78</td>\n","      <td id=\"T_af196_row4_col2\" class=\"data row4 col2\" >0.64</td>\n","      <td id=\"T_af196_row4_col3\" class=\"data row4 col3\" >0.49</td>\n","      <td id=\"T_af196_row4_col4\" class=\"data row4 col4\" >1.00</td>\n","    </tr>\n","  </tbody>\n","</table>\n"]},"metadata":{},"execution_count":69}]},{"cell_type":"code","source":["# colunas para correlacionar\n","correl_columns = ['petr4', 'bbdc3', 'vale5', 'ambv4', 'itub4']\n","# teste\n","pg.pairwise_corr(dados_bolsa_filtrados,\n","                columns = correl_columns,\n","                method = 'pearson')"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":363},"id":"zOErTMOn97N7","executionInfo":{"status":"ok","timestamp":1692988457542,"user_tz":180,"elapsed":306,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"c2184d68-7b32-4a65-ac6c-e98d20989901"},"execution_count":72,"outputs":[{"output_type":"execute_result","data":{"text/plain":["       X      Y   method alternative     n         r         CI95%  \\\n","0  petr4  bbdc3  pearson   two-sided  1604  0.539247   [0.5, 0.57]   \n","1  petr4  vale5  pearson   two-sided  1604  0.724023   [0.7, 0.75]   \n","2  petr4  ambv4  pearson   two-sided  1604  0.392074  [0.35, 0.43]   \n","3  petr4  itub4  pearson   two-sided  1604  0.593834  [0.56, 0.62]   \n","4  bbdc3  vale5  pearson   two-sided  1604  0.592143  [0.56, 0.62]   \n","5  bbdc3  ambv4  pearson   two-sided  1604  0.470529  [0.43, 0.51]   \n","6  bbdc3  itub4  pearson   two-sided  1604  0.778506   [0.76, 0.8]   \n","7  vale5  ambv4  pearson   two-sided  1604  0.482919  [0.44, 0.52]   \n","8  vale5  itub4  pearson   two-sided  1604  0.642838  [0.61, 0.67]   \n","9  ambv4  itub4  pearson   two-sided  1604  0.488886  [0.45, 0.53]   \n","\n","           p-unc        BF10  power  \n","0  1.094616e-121  7.488e+117    1.0  \n","1  1.122582e-260  3.654e+256    1.0  \n","2   4.390573e-60   3.057e+56    1.0  \n","3  1.793002e-153  3.791e+149    1.0  \n","4  2.143940e-152  3.189e+148    1.0  \n","5   3.714265e-89   2.774e+85    1.0  \n","6   0.000000e+00         inf    1.0  \n","7   1.738600e-94   5.688e+90    1.0  \n","8  1.064830e-187  5.347e+183    1.0  \n","9   3.929767e-97   2.467e+93    1.0  "],"text/html":["\n","  <div id=\"df-beb3a8bd-d94c-4e4b-971e-17bec93a4e31\" class=\"colab-df-container\">\n","    <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>X</th>\n","      <th>Y</th>\n","      <th>method</th>\n","      <th>alternative</th>\n","      <th>n</th>\n","      <th>r</th>\n","      <th>CI95%</th>\n","      <th>p-unc</th>\n","      <th>BF10</th>\n","      <th>power</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>petr4</td>\n","      <td>bbdc3</td>\n","      <td>pearson</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.539247</td>\n","      <td>[0.5, 0.57]</td>\n","      <td>1.094616e-121</td>\n","      <td>7.488e+117</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>petr4</td>\n","      <td>vale5</td>\n","      <td>pearson</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.724023</td>\n","      <td>[0.7, 0.75]</td>\n","      <td>1.122582e-260</td>\n","      <td>3.654e+256</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>petr4</td>\n","      <td>ambv4</td>\n","      <td>pearson</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.392074</td>\n","      <td>[0.35, 0.43]</td>\n","      <td>4.390573e-60</td>\n","      <td>3.057e+56</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>petr4</td>\n","      <td>itub4</td>\n","      <td>pearson</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.593834</td>\n","      <td>[0.56, 0.62]</td>\n","      <td>1.793002e-153</td>\n","      <td>3.791e+149</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>bbdc3</td>\n","      <td>vale5</td>\n","      <td>pearson</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.592143</td>\n","      <td>[0.56, 0.62]</td>\n","      <td>2.143940e-152</td>\n","      <td>3.189e+148</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>bbdc3</td>\n","      <td>ambv4</td>\n","      <td>pearson</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.470529</td>\n","      <td>[0.43, 0.51]</td>\n","      <td>3.714265e-89</td>\n","      <td>2.774e+85</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>bbdc3</td>\n","      <td>itub4</td>\n","      <td>pearson</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.778506</td>\n","      <td>[0.76, 0.8]</td>\n","      <td>0.000000e+00</td>\n","      <td>inf</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>vale5</td>\n","      <td>ambv4</td>\n","      <td>pearson</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.482919</td>\n","      <td>[0.44, 0.52]</td>\n","      <td>1.738600e-94</td>\n","      <td>5.688e+90</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>vale5</td>\n","      <td>itub4</td>\n","      <td>pearson</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.642838</td>\n","      <td>[0.61, 0.67]</td>\n","      <td>1.064830e-187</td>\n","      <td>5.347e+183</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>9</th>\n","      <td>ambv4</td>\n","      <td>itub4</td>\n","      <td>pearson</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.488886</td>\n","      <td>[0.45, 0.53]</td>\n","      <td>3.929767e-97</td>\n","      <td>2.467e+93</td>\n","      <td>1.0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-beb3a8bd-d94c-4e4b-971e-17bec93a4e31')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-beb3a8bd-d94c-4e4b-971e-17bec93a4e31 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-beb3a8bd-d94c-4e4b-971e-17bec93a4e31');\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","\n","\n","<div id=\"df-e1084a15-b058-4886-ab31-722bdcc002b0\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-e1084a15-b058-4886-ab31-722bdcc002b0')\"\n","            title=\"Suggest charts.\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\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-quickchart: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-quickchart {\n","    background-color: #3B4455;\n","    fill: #D2E3FC;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart: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","    async function quickchart(key) {\n","      const charts = await google.colab.kernel.invokeFunction(\n","          'suggestCharts', [key], {});\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-e1084a15-b058-4886-ab31-722bdcc002b0 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":72}]},{"cell_type":"markdown","source":["\n","\n","*   Spearman\n","\n"],"metadata":{"id":"pxS2bqLR_Ing"}},{"cell_type":"code","source":["# correlacao\n","spearman_correlacao = dados_bolsa_filtrados.corr(method = 'spearman')\n","spearman_correlacao"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":262},"id":"QGHFyx54_IDT","executionInfo":{"status":"ok","timestamp":1692988806558,"user_tz":180,"elapsed":396,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"63a8387e-9952-45b3-bc2e-33cf9d0d94c2"},"execution_count":75,"outputs":[{"output_type":"stream","name":"stderr","text":["<ipython-input-75-7ddd07dc76b4>:2: FutureWarning: The default value of numeric_only in DataFrame.corr is deprecated. In a future version, it will default to False. Select only valid columns or specify the value of numeric_only to silence this warning.\n","  spearman_correlacao = dados_bolsa_filtrados.corr(method = 'spearman')\n"]},{"output_type":"execute_result","data":{"text/plain":["          petr4     bbdc3     vale5     ambv4     itub4\n","petr4  1.000000  0.472143  0.644211  0.330002  0.531198\n","bbdc3  0.472143  1.000000  0.505002  0.419052  0.758946\n","vale5  0.644211  0.505002  1.000000  0.404373  0.574199\n","ambv4  0.330002  0.419052  0.404373  1.000000  0.449118\n","itub4  0.531198  0.758946  0.574199  0.449118  1.000000"],"text/html":["\n","  <div id=\"df-dd9968bb-38c6-4bbb-b98e-ca8d0e53711b\" class=\"colab-df-container\">\n","    <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>petr4</th>\n","      <th>bbdc3</th>\n","      <th>vale5</th>\n","      <th>ambv4</th>\n","      <th>itub4</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>petr4</th>\n","      <td>1.000000</td>\n","      <td>0.472143</td>\n","      <td>0.644211</td>\n","      <td>0.330002</td>\n","      <td>0.531198</td>\n","    </tr>\n","    <tr>\n","      <th>bbdc3</th>\n","      <td>0.472143</td>\n","      <td>1.000000</td>\n","      <td>0.505002</td>\n","      <td>0.419052</td>\n","      <td>0.758946</td>\n","    </tr>\n","    <tr>\n","      <th>vale5</th>\n","      <td>0.644211</td>\n","      <td>0.505002</td>\n","      <td>1.000000</td>\n","      <td>0.404373</td>\n","      <td>0.574199</td>\n","    </tr>\n","    <tr>\n","      <th>ambv4</th>\n","      <td>0.330002</td>\n","      <td>0.419052</td>\n","      <td>0.404373</td>\n","      <td>1.000000</td>\n","      <td>0.449118</td>\n","    </tr>\n","    <tr>\n","      <th>itub4</th>\n","      <td>0.531198</td>\n","      <td>0.758946</td>\n","      <td>0.574199</td>\n","      <td>0.449118</td>\n","      <td>1.000000</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-dd9968bb-38c6-4bbb-b98e-ca8d0e53711b')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-dd9968bb-38c6-4bbb-b98e-ca8d0e53711b 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-dd9968bb-38c6-4bbb-b98e-ca8d0e53711b');\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","\n","\n","<div id=\"df-d549e545-bccf-45b3-be02-b34f8663ec58\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-d549e545-bccf-45b3-be02-b34f8663ec58')\"\n","            title=\"Suggest charts.\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\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-quickchart: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-quickchart {\n","    background-color: #3B4455;\n","    fill: #D2E3FC;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart: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","    async function quickchart(key) {\n","      const charts = await google.colab.kernel.invokeFunction(\n","          'suggestCharts', [key], {});\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-d549e545-bccf-45b3-be02-b34f8663ec58 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":75}]},{"cell_type":"code","source":["# matriz ajustada\n","spearman_correlacao.style.background_gradient(cmap='coolwarm').set_precision(2)"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":262},"id":"gVo0eYpP_ky1","executionInfo":{"status":"ok","timestamp":1692988889553,"user_tz":180,"elapsed":324,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"09024a68-f20b-4fbb-d886-6b111b60adef"},"execution_count":76,"outputs":[{"output_type":"stream","name":"stderr","text":["<ipython-input-76-980577ec7d2f>:2: FutureWarning: this method is deprecated in favour of `Styler.format(precision=..)`\n","  spearman_correlacao.style.background_gradient(cmap='coolwarm').set_precision(2)\n"]},{"output_type":"execute_result","data":{"text/plain":["<pandas.io.formats.style.Styler at 0x7e3011e98d60>"],"text/html":["<style type=\"text/css\">\n","#T_3f6af_row0_col0, #T_3f6af_row1_col1, #T_3f6af_row2_col2, #T_3f6af_row3_col3, #T_3f6af_row4_col4 {\n","  background-color: #b40426;\n","  color: #f1f1f1;\n","}\n","#T_3f6af_row0_col1 {\n","  background-color: #5673e0;\n","  color: #f1f1f1;\n","}\n","#T_3f6af_row0_col2 {\n","  background-color: #c1d4f4;\n","  color: #000000;\n","}\n","#T_3f6af_row0_col3, #T_3f6af_row3_col0, #T_3f6af_row3_col1, #T_3f6af_row3_col2, #T_3f6af_row3_col4 {\n","  background-color: #3b4cc0;\n","  color: #f1f1f1;\n","}\n","#T_3f6af_row0_col4 {\n","  background-color: #6a8bef;\n","  color: #f1f1f1;\n","}\n","#T_3f6af_row1_col0 {\n","  background-color: #80a3fa;\n","  color: #f1f1f1;\n","}\n","#T_3f6af_row1_col2 {\n","  background-color: #7093f3;\n","  color: #f1f1f1;\n","}\n","#T_3f6af_row1_col3 {\n","  background-color: #6485ec;\n","  color: #f1f1f1;\n","}\n","#T_3f6af_row1_col4 {\n","  background-color: #ebd3c6;\n","  color: #000000;\n","}\n","#T_3f6af_row2_col0 {\n","  background-color: #d5dbe5;\n","  color: #000000;\n","}\n","#T_3f6af_row2_col1 {\n","  background-color: #688aef;\n","  color: #f1f1f1;\n","}\n","#T_3f6af_row2_col3 {\n","  background-color: #5d7ce6;\n","  color: #f1f1f1;\n","}\n","#T_3f6af_row2_col4 {\n","  background-color: #85a8fc;\n","  color: #f1f1f1;\n","}\n","#T_3f6af_row4_col0 {\n","  background-color: #9ebeff;\n","  color: #000000;\n","}\n","#T_3f6af_row4_col1 {\n","  background-color: #efcebd;\n","  color: #000000;\n","}\n","#T_3f6af_row4_col2 {\n","  background-color: #98b9ff;\n","  color: #000000;\n","}\n","#T_3f6af_row4_col3 {\n","  background-color: #7396f5;\n","  color: #f1f1f1;\n","}\n","</style>\n","<table id=\"T_3f6af\" class=\"dataframe\">\n","  <thead>\n","    <tr>\n","      <th class=\"blank level0\" >&nbsp;</th>\n","      <th id=\"T_3f6af_level0_col0\" class=\"col_heading level0 col0\" >petr4</th>\n","      <th id=\"T_3f6af_level0_col1\" class=\"col_heading level0 col1\" >bbdc3</th>\n","      <th id=\"T_3f6af_level0_col2\" class=\"col_heading level0 col2\" >vale5</th>\n","      <th id=\"T_3f6af_level0_col3\" class=\"col_heading level0 col3\" >ambv4</th>\n","      <th id=\"T_3f6af_level0_col4\" class=\"col_heading level0 col4\" >itub4</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th id=\"T_3f6af_level0_row0\" class=\"row_heading level0 row0\" >petr4</th>\n","      <td id=\"T_3f6af_row0_col0\" class=\"data row0 col0\" >1.00</td>\n","      <td id=\"T_3f6af_row0_col1\" class=\"data row0 col1\" >0.47</td>\n","      <td id=\"T_3f6af_row0_col2\" class=\"data row0 col2\" >0.64</td>\n","      <td id=\"T_3f6af_row0_col3\" class=\"data row0 col3\" >0.33</td>\n","      <td id=\"T_3f6af_row0_col4\" class=\"data row0 col4\" >0.53</td>\n","    </tr>\n","    <tr>\n","      <th id=\"T_3f6af_level0_row1\" class=\"row_heading level0 row1\" >bbdc3</th>\n","      <td id=\"T_3f6af_row1_col0\" class=\"data row1 col0\" >0.47</td>\n","      <td id=\"T_3f6af_row1_col1\" class=\"data row1 col1\" >1.00</td>\n","      <td id=\"T_3f6af_row1_col2\" class=\"data row1 col2\" >0.51</td>\n","      <td id=\"T_3f6af_row1_col3\" class=\"data row1 col3\" >0.42</td>\n","      <td id=\"T_3f6af_row1_col4\" class=\"data row1 col4\" >0.76</td>\n","    </tr>\n","    <tr>\n","      <th id=\"T_3f6af_level0_row2\" class=\"row_heading level0 row2\" >vale5</th>\n","      <td id=\"T_3f6af_row2_col0\" class=\"data row2 col0\" >0.64</td>\n","      <td id=\"T_3f6af_row2_col1\" class=\"data row2 col1\" >0.51</td>\n","      <td id=\"T_3f6af_row2_col2\" class=\"data row2 col2\" >1.00</td>\n","      <td id=\"T_3f6af_row2_col3\" class=\"data row2 col3\" >0.40</td>\n","      <td id=\"T_3f6af_row2_col4\" class=\"data row2 col4\" >0.57</td>\n","    </tr>\n","    <tr>\n","      <th id=\"T_3f6af_level0_row3\" class=\"row_heading level0 row3\" >ambv4</th>\n","      <td id=\"T_3f6af_row3_col0\" class=\"data row3 col0\" >0.33</td>\n","      <td id=\"T_3f6af_row3_col1\" class=\"data row3 col1\" >0.42</td>\n","      <td id=\"T_3f6af_row3_col2\" class=\"data row3 col2\" >0.40</td>\n","      <td id=\"T_3f6af_row3_col3\" class=\"data row3 col3\" >1.00</td>\n","      <td id=\"T_3f6af_row3_col4\" class=\"data row3 col4\" >0.45</td>\n","    </tr>\n","    <tr>\n","      <th id=\"T_3f6af_level0_row4\" class=\"row_heading level0 row4\" >itub4</th>\n","      <td id=\"T_3f6af_row4_col0\" class=\"data row4 col0\" >0.53</td>\n","      <td id=\"T_3f6af_row4_col1\" class=\"data row4 col1\" >0.76</td>\n","      <td id=\"T_3f6af_row4_col2\" class=\"data row4 col2\" >0.57</td>\n","      <td id=\"T_3f6af_row4_col3\" class=\"data row4 col3\" >0.45</td>\n","      <td id=\"T_3f6af_row4_col4\" class=\"data row4 col4\" >1.00</td>\n","    </tr>\n","  </tbody>\n","</table>\n"]},"metadata":{},"execution_count":76}]},{"cell_type":"code","source":["# colunas para correlacionar\n","correl_columns = ['petr4', 'bbdc3', 'vale5', 'ambv4', 'itub4']\n","# teste\n","pg.pairwise_corr(dados_bolsa_filtrados,\n","                columns = correl_columns,\n","                method = 'spearman')"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":363},"id":"06OY5_BoAN_f","executionInfo":{"status":"ok","timestamp":1692988932760,"user_tz":180,"elapsed":263,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"1a816027-714a-452e-9424-0811aaf5f7c0"},"execution_count":77,"outputs":[{"output_type":"execute_result","data":{"text/plain":["       X      Y    method alternative     n         r         CI95%  \\\n","0  petr4  bbdc3  spearman   two-sided  1604  0.472143  [0.43, 0.51]   \n","1  petr4  vale5  spearman   two-sided  1604  0.644211  [0.61, 0.67]   \n","2  petr4  ambv4  spearman   two-sided  1604  0.330002  [0.29, 0.37]   \n","3  petr4  itub4  spearman   two-sided  1604  0.531198   [0.5, 0.57]   \n","4  bbdc3  vale5  spearman   two-sided  1604  0.505002  [0.47, 0.54]   \n","5  bbdc3  ambv4  spearman   two-sided  1604  0.419052  [0.38, 0.46]   \n","6  bbdc3  itub4  spearman   two-sided  1604  0.758946  [0.74, 0.78]   \n","7  vale5  ambv4  spearman   two-sided  1604  0.404373  [0.36, 0.44]   \n","8  vale5  itub4  spearman   two-sided  1604  0.574199  [0.54, 0.61]   \n","9  ambv4  itub4  spearman   two-sided  1604  0.449118  [0.41, 0.49]   \n","\n","           p-unc  power  \n","0   7.723804e-90    1.0  \n","1  9.494683e-189    1.0  \n","2   4.669599e-42    1.0  \n","3  1.762927e-117    1.0  \n","4  1.513500e-104    1.0  \n","5   3.166567e-69    1.0  \n","6  8.700692e-301    1.0  \n","7   3.794800e-64    1.0  \n","8  2.395419e-141    1.0  \n","9   1.896860e-80    1.0  "],"text/html":["\n","  <div id=\"df-0b28aa36-4f98-43e0-be36-14d03dcd6a2e\" class=\"colab-df-container\">\n","    <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>X</th>\n","      <th>Y</th>\n","      <th>method</th>\n","      <th>alternative</th>\n","      <th>n</th>\n","      <th>r</th>\n","      <th>CI95%</th>\n","      <th>p-unc</th>\n","      <th>power</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>petr4</td>\n","      <td>bbdc3</td>\n","      <td>spearman</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.472143</td>\n","      <td>[0.43, 0.51]</td>\n","      <td>7.723804e-90</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>petr4</td>\n","      <td>vale5</td>\n","      <td>spearman</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.644211</td>\n","      <td>[0.61, 0.67]</td>\n","      <td>9.494683e-189</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>petr4</td>\n","      <td>ambv4</td>\n","      <td>spearman</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.330002</td>\n","      <td>[0.29, 0.37]</td>\n","      <td>4.669599e-42</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>petr4</td>\n","      <td>itub4</td>\n","      <td>spearman</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.531198</td>\n","      <td>[0.5, 0.57]</td>\n","      <td>1.762927e-117</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>bbdc3</td>\n","      <td>vale5</td>\n","      <td>spearman</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.505002</td>\n","      <td>[0.47, 0.54]</td>\n","      <td>1.513500e-104</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>bbdc3</td>\n","      <td>ambv4</td>\n","      <td>spearman</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.419052</td>\n","      <td>[0.38, 0.46]</td>\n","      <td>3.166567e-69</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>bbdc3</td>\n","      <td>itub4</td>\n","      <td>spearman</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.758946</td>\n","      <td>[0.74, 0.78]</td>\n","      <td>8.700692e-301</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>vale5</td>\n","      <td>ambv4</td>\n","      <td>spearman</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.404373</td>\n","      <td>[0.36, 0.44]</td>\n","      <td>3.794800e-64</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>vale5</td>\n","      <td>itub4</td>\n","      <td>spearman</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.574199</td>\n","      <td>[0.54, 0.61]</td>\n","      <td>2.395419e-141</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>9</th>\n","      <td>ambv4</td>\n","      <td>itub4</td>\n","      <td>spearman</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.449118</td>\n","      <td>[0.41, 0.49]</td>\n","      <td>1.896860e-80</td>\n","      <td>1.0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-0b28aa36-4f98-43e0-be36-14d03dcd6a2e')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-0b28aa36-4f98-43e0-be36-14d03dcd6a2e 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-0b28aa36-4f98-43e0-be36-14d03dcd6a2e');\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","\n","\n","<div id=\"df-44e45706-5f9e-48a7-b9b4-bdaed7a48264\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-44e45706-5f9e-48a7-b9b4-bdaed7a48264')\"\n","            title=\"Suggest charts.\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\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-quickchart: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-quickchart {\n","    background-color: #3B4455;\n","    fill: #D2E3FC;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart: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","    async function quickchart(key) {\n","      const charts = await google.colab.kernel.invokeFunction(\n","          'suggestCharts', [key], {});\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-44e45706-5f9e-48a7-b9b4-bdaed7a48264 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":77}]},{"cell_type":"markdown","source":["\n","\n","*   Kendall\n","\n"],"metadata":{"id":"yRoA8NNPAS17"}},{"cell_type":"code","source":["kendall_correlacao = dados_bolsa_filtrados.corr()\n","kendall_correlacao"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":262},"id":"g_kYpt0QAotm","executionInfo":{"status":"ok","timestamp":1692989063976,"user_tz":180,"elapsed":270,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"346f70d8-ab62-40bf-d34b-daf7882ddcc6"},"execution_count":78,"outputs":[{"output_type":"stream","name":"stderr","text":["<ipython-input-78-6ee957bafea4>:1: FutureWarning: The default value of numeric_only in DataFrame.corr is deprecated. In a future version, it will default to False. Select only valid columns or specify the value of numeric_only to silence this warning.\n","  kendall_correlacao = dados_bolsa_filtrados.corr()\n"]},{"output_type":"execute_result","data":{"text/plain":["          petr4     bbdc3     vale5     ambv4     itub4\n","petr4  1.000000  0.539247  0.724023  0.392074  0.593834\n","bbdc3  0.539247  1.000000  0.592143  0.470529  0.778506\n","vale5  0.724023  0.592143  1.000000  0.482919  0.642838\n","ambv4  0.392074  0.470529  0.482919  1.000000  0.488886\n","itub4  0.593834  0.778506  0.642838  0.488886  1.000000"],"text/html":["\n","  <div id=\"df-e69b1abc-8bc9-4ec0-8c84-56f2b096f3fe\" class=\"colab-df-container\">\n","    <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>petr4</th>\n","      <th>bbdc3</th>\n","      <th>vale5</th>\n","      <th>ambv4</th>\n","      <th>itub4</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>petr4</th>\n","      <td>1.000000</td>\n","      <td>0.539247</td>\n","      <td>0.724023</td>\n","      <td>0.392074</td>\n","      <td>0.593834</td>\n","    </tr>\n","    <tr>\n","      <th>bbdc3</th>\n","      <td>0.539247</td>\n","      <td>1.000000</td>\n","      <td>0.592143</td>\n","      <td>0.470529</td>\n","      <td>0.778506</td>\n","    </tr>\n","    <tr>\n","      <th>vale5</th>\n","      <td>0.724023</td>\n","      <td>0.592143</td>\n","      <td>1.000000</td>\n","      <td>0.482919</td>\n","      <td>0.642838</td>\n","    </tr>\n","    <tr>\n","      <th>ambv4</th>\n","      <td>0.392074</td>\n","      <td>0.470529</td>\n","      <td>0.482919</td>\n","      <td>1.000000</td>\n","      <td>0.488886</td>\n","    </tr>\n","    <tr>\n","      <th>itub4</th>\n","      <td>0.593834</td>\n","      <td>0.778506</td>\n","      <td>0.642838</td>\n","      <td>0.488886</td>\n","      <td>1.000000</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-e69b1abc-8bc9-4ec0-8c84-56f2b096f3fe')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-e69b1abc-8bc9-4ec0-8c84-56f2b096f3fe 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-e69b1abc-8bc9-4ec0-8c84-56f2b096f3fe');\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","\n","\n","<div id=\"df-e7f3d168-e7b0-40d0-baa4-08661039da9a\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-e7f3d168-e7b0-40d0-baa4-08661039da9a')\"\n","            title=\"Suggest charts.\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\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-quickchart: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-quickchart {\n","    background-color: #3B4455;\n","    fill: #D2E3FC;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart: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","    async function quickchart(key) {\n","      const charts = await google.colab.kernel.invokeFunction(\n","          'suggestCharts', [key], {});\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-e7f3d168-e7b0-40d0-baa4-08661039da9a button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":78}]},{"cell_type":"code","source":["# matriz ajustada\n","kendall_correlacao.style.background_gradient(cmap='coolwarm').set_precision(2)"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":262},"id":"hgGsDu3ZAxJc","executionInfo":{"status":"ok","timestamp":1692989127481,"user_tz":180,"elapsed":352,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"2544baf1-dc97-4fc0-bd76-a12b2d8e4771"},"execution_count":79,"outputs":[{"output_type":"stream","name":"stderr","text":["<ipython-input-79-2b9ff8799a26>:2: FutureWarning: this method is deprecated in favour of `Styler.format(precision=..)`\n","  kendall_correlacao.style.background_gradient(cmap='coolwarm').set_precision(2)\n"]},{"output_type":"execute_result","data":{"text/plain":["<pandas.io.formats.style.Styler at 0x7e3011dfe6b0>"],"text/html":["<style type=\"text/css\">\n","#T_2640a_row0_col0, #T_2640a_row1_col1, #T_2640a_row2_col2, #T_2640a_row3_col3, #T_2640a_row4_col4 {\n","  background-color: #b40426;\n","  color: #f1f1f1;\n","}\n","#T_2640a_row0_col1, #T_2640a_row1_col3 {\n","  background-color: #6384eb;\n","  color: #f1f1f1;\n","}\n","#T_2640a_row0_col2 {\n","  background-color: #d4dbe6;\n","  color: #000000;\n","}\n","#T_2640a_row0_col3, #T_2640a_row3_col0, #T_2640a_row3_col1, #T_2640a_row3_col2, #T_2640a_row3_col4 {\n","  background-color: #3b4cc0;\n","  color: #f1f1f1;\n","}\n","#T_2640a_row0_col4 {\n","  background-color: #7da0f9;\n","  color: #f1f1f1;\n","}\n","#T_2640a_row1_col0 {\n","  background-color: #89acfd;\n","  color: #000000;\n","}\n","#T_2640a_row1_col2 {\n","  background-color: #80a3fa;\n","  color: #f1f1f1;\n","}\n","#T_2640a_row1_col4 {\n","  background-color: #edd2c3;\n","  color: #000000;\n","}\n","#T_2640a_row2_col0 {\n","  background-color: #e8d6cc;\n","  color: #000000;\n","}\n","#T_2640a_row2_col1 {\n","  background-color: #85a8fc;\n","  color: #f1f1f1;\n","}\n","#T_2640a_row2_col3 {\n","  background-color: #6a8bef;\n","  color: #f1f1f1;\n","}\n","#T_2640a_row2_col4 {\n","  background-color: #9fbfff;\n","  color: #000000;\n","}\n","#T_2640a_row4_col0 {\n","  background-color: #a9c6fd;\n","  color: #000000;\n","}\n","#T_2640a_row4_col1 {\n","  background-color: #efcfbf;\n","  color: #000000;\n","}\n","#T_2640a_row4_col2 {\n","  background-color: #a2c1ff;\n","  color: #000000;\n","}\n","#T_2640a_row4_col3 {\n","  background-color: #6c8ff1;\n","  color: #f1f1f1;\n","}\n","</style>\n","<table id=\"T_2640a\" class=\"dataframe\">\n","  <thead>\n","    <tr>\n","      <th class=\"blank level0\" >&nbsp;</th>\n","      <th id=\"T_2640a_level0_col0\" class=\"col_heading level0 col0\" >petr4</th>\n","      <th id=\"T_2640a_level0_col1\" class=\"col_heading level0 col1\" >bbdc3</th>\n","      <th id=\"T_2640a_level0_col2\" class=\"col_heading level0 col2\" >vale5</th>\n","      <th id=\"T_2640a_level0_col3\" class=\"col_heading level0 col3\" >ambv4</th>\n","      <th id=\"T_2640a_level0_col4\" class=\"col_heading level0 col4\" >itub4</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th id=\"T_2640a_level0_row0\" class=\"row_heading level0 row0\" >petr4</th>\n","      <td id=\"T_2640a_row0_col0\" class=\"data row0 col0\" >1.00</td>\n","      <td id=\"T_2640a_row0_col1\" class=\"data row0 col1\" >0.54</td>\n","      <td id=\"T_2640a_row0_col2\" class=\"data row0 col2\" >0.72</td>\n","      <td id=\"T_2640a_row0_col3\" class=\"data row0 col3\" >0.39</td>\n","      <td id=\"T_2640a_row0_col4\" class=\"data row0 col4\" >0.59</td>\n","    </tr>\n","    <tr>\n","      <th id=\"T_2640a_level0_row1\" class=\"row_heading level0 row1\" >bbdc3</th>\n","      <td id=\"T_2640a_row1_col0\" class=\"data row1 col0\" >0.54</td>\n","      <td id=\"T_2640a_row1_col1\" class=\"data row1 col1\" >1.00</td>\n","      <td id=\"T_2640a_row1_col2\" class=\"data row1 col2\" >0.59</td>\n","      <td id=\"T_2640a_row1_col3\" class=\"data row1 col3\" >0.47</td>\n","      <td id=\"T_2640a_row1_col4\" class=\"data row1 col4\" >0.78</td>\n","    </tr>\n","    <tr>\n","      <th id=\"T_2640a_level0_row2\" class=\"row_heading level0 row2\" >vale5</th>\n","      <td id=\"T_2640a_row2_col0\" class=\"data row2 col0\" >0.72</td>\n","      <td id=\"T_2640a_row2_col1\" class=\"data row2 col1\" >0.59</td>\n","      <td id=\"T_2640a_row2_col2\" class=\"data row2 col2\" >1.00</td>\n","      <td id=\"T_2640a_row2_col3\" class=\"data row2 col3\" >0.48</td>\n","      <td id=\"T_2640a_row2_col4\" class=\"data row2 col4\" >0.64</td>\n","    </tr>\n","    <tr>\n","      <th id=\"T_2640a_level0_row3\" class=\"row_heading level0 row3\" >ambv4</th>\n","      <td id=\"T_2640a_row3_col0\" class=\"data row3 col0\" >0.39</td>\n","      <td id=\"T_2640a_row3_col1\" class=\"data row3 col1\" >0.47</td>\n","      <td id=\"T_2640a_row3_col2\" class=\"data row3 col2\" >0.48</td>\n","      <td id=\"T_2640a_row3_col3\" class=\"data row3 col3\" >1.00</td>\n","      <td id=\"T_2640a_row3_col4\" class=\"data row3 col4\" >0.49</td>\n","    </tr>\n","    <tr>\n","      <th id=\"T_2640a_level0_row4\" class=\"row_heading level0 row4\" >itub4</th>\n","      <td id=\"T_2640a_row4_col0\" class=\"data row4 col0\" >0.59</td>\n","      <td id=\"T_2640a_row4_col1\" class=\"data row4 col1\" >0.78</td>\n","      <td id=\"T_2640a_row4_col2\" class=\"data row4 col2\" >0.64</td>\n","      <td id=\"T_2640a_row4_col3\" class=\"data row4 col3\" >0.49</td>\n","      <td id=\"T_2640a_row4_col4\" class=\"data row4 col4\" >1.00</td>\n","    </tr>\n","  </tbody>\n","</table>\n"]},"metadata":{},"execution_count":79}]},{"cell_type":"code","source":["correl_columns = ['petr4', 'bbdc3', 'vale5', 'ambv4', 'itub4']\n","correl_columns"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"zKm15RqKBBvt","executionInfo":{"status":"ok","timestamp":1692989211903,"user_tz":180,"elapsed":254,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"e2a2ba42-7d59-48ba-a0b8-621ec6654bb5"},"execution_count":80,"outputs":[{"output_type":"execute_result","data":{"text/plain":["['petr4', 'bbdc3', 'vale5', 'ambv4', 'itub4']"]},"metadata":{},"execution_count":80}]},{"cell_type":"code","source":["# teste\n","pg.pairwise_corr(dados_bolsa_filtrados,\n","                 columns = correl_columns,\n","                 method = 'kendall')"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":363},"id":"nzN7SrcEBVBX","executionInfo":{"status":"ok","timestamp":1692989320382,"user_tz":180,"elapsed":302,"user":{"displayName":"Isabella Orlando","userId":"14405721422426458542"}},"outputId":"05c1869b-88a7-4738-89d8-00cbd610b672"},"execution_count":82,"outputs":[{"output_type":"execute_result","data":{"text/plain":["       X      Y   method alternative     n         r         CI95%  \\\n","0  petr4  bbdc3  kendall   two-sided  1604  0.332691  [0.29, 0.38]   \n","1  petr4  vale5  kendall   two-sided  1604  0.471033  [0.43, 0.51]   \n","2  petr4  ambv4  kendall   two-sided  1604  0.231311  [0.18, 0.28]   \n","3  petr4  itub4  kendall   two-sided  1604  0.378755  [0.34, 0.42]   \n","4  bbdc3  vale5  kendall   two-sided  1604  0.358557   [0.32, 0.4]   \n","5  bbdc3  ambv4  kendall   two-sided  1604  0.294492  [0.25, 0.34]   \n","6  bbdc3  itub4  kendall   two-sided  1604  0.571953   [0.54, 0.6]   \n","7  vale5  ambv4  kendall   two-sided  1604  0.282942  [0.24, 0.33]   \n","8  vale5  itub4  kendall   two-sided  1604  0.411663  [0.37, 0.45]   \n","9  ambv4  itub4  kendall   two-sided  1604  0.318638  [0.27, 0.36]   \n","\n","           p-unc  power  \n","0   1.358166e-88    1.0  \n","1  9.805061e-176    1.0  \n","2   8.582460e-44    1.0  \n","3  2.531465e-114    1.0  \n","4  1.375615e-102    1.0  \n","5   8.231269e-70    1.0  \n","6  7.030155e-258    1.0  \n","7   1.246269e-64    1.0  \n","8  1.100820e-134    1.0  \n","9   1.852468e-81    1.0  "],"text/html":["\n","  <div id=\"df-a017bd78-4efc-4c5f-8e3e-5bc8df453e5e\" class=\"colab-df-container\">\n","    <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>X</th>\n","      <th>Y</th>\n","      <th>method</th>\n","      <th>alternative</th>\n","      <th>n</th>\n","      <th>r</th>\n","      <th>CI95%</th>\n","      <th>p-unc</th>\n","      <th>power</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>petr4</td>\n","      <td>bbdc3</td>\n","      <td>kendall</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.332691</td>\n","      <td>[0.29, 0.38]</td>\n","      <td>1.358166e-88</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>petr4</td>\n","      <td>vale5</td>\n","      <td>kendall</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.471033</td>\n","      <td>[0.43, 0.51]</td>\n","      <td>9.805061e-176</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>petr4</td>\n","      <td>ambv4</td>\n","      <td>kendall</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.231311</td>\n","      <td>[0.18, 0.28]</td>\n","      <td>8.582460e-44</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>petr4</td>\n","      <td>itub4</td>\n","      <td>kendall</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.378755</td>\n","      <td>[0.34, 0.42]</td>\n","      <td>2.531465e-114</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>bbdc3</td>\n","      <td>vale5</td>\n","      <td>kendall</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.358557</td>\n","      <td>[0.32, 0.4]</td>\n","      <td>1.375615e-102</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>bbdc3</td>\n","      <td>ambv4</td>\n","      <td>kendall</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.294492</td>\n","      <td>[0.25, 0.34]</td>\n","      <td>8.231269e-70</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>bbdc3</td>\n","      <td>itub4</td>\n","      <td>kendall</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.571953</td>\n","      <td>[0.54, 0.6]</td>\n","      <td>7.030155e-258</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>vale5</td>\n","      <td>ambv4</td>\n","      <td>kendall</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.282942</td>\n","      <td>[0.24, 0.33]</td>\n","      <td>1.246269e-64</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>vale5</td>\n","      <td>itub4</td>\n","      <td>kendall</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.411663</td>\n","      <td>[0.37, 0.45]</td>\n","      <td>1.100820e-134</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>9</th>\n","      <td>ambv4</td>\n","      <td>itub4</td>\n","      <td>kendall</td>\n","      <td>two-sided</td>\n","      <td>1604</td>\n","      <td>0.318638</td>\n","      <td>[0.27, 0.36]</td>\n","      <td>1.852468e-81</td>\n","      <td>1.0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a017bd78-4efc-4c5f-8e3e-5bc8df453e5e')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-a017bd78-4efc-4c5f-8e3e-5bc8df453e5e 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-a017bd78-4efc-4c5f-8e3e-5bc8df453e5e');\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","\n","\n","<div id=\"df-4dd7b3e2-96c1-4c4a-824f-b9c56946fa75\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-4dd7b3e2-96c1-4c4a-824f-b9c56946fa75')\"\n","            title=\"Suggest charts.\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\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-quickchart: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-quickchart {\n","    background-color: #3B4455;\n","    fill: #D2E3FC;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart: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","    async function quickchart(key) {\n","      const charts = await google.colab.kernel.invokeFunction(\n","          'suggestCharts', [key], {});\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-4dd7b3e2-96c1-4c4a-824f-b9c56946fa75 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":82}]}]}