Dia01_Imersão_Alura.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Dia01- Imersão Alura",
      "provenance": [],
      "collapsed_sections": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "0fIW-TZgEJF8"
      },
      "source": [
        "### 3º Imersão de dados da Alura\n",
        "Análise de dados, python, pandas e novos fármacos\n",
        "\n",
        "O projeto da imersão foi baseado no Laboratory innovation science at Harvard.\n",
        "\n"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "AM-S4zsmFIsD"
      },
      "source": [
        "### Neste notebook veremos\n",
        "01: Investigar por que a classe de tratamento é muito desbalanceada \n",
        "\n",
        "02: Visualizar as últimas linhas do dataset\n",
        "\n",
        "03: Calcular a proporção das classes tratamento\n",
        "\n",
        "04: Quantificar os tipos de drogas investigados?\n",
        "\n",
        "05: Aplicar metódo query como forma de analisar a funcionalidade\n",
        "\n",
        "06: Trataremos os campos do dataset\n",
        "\n",
        "07: Demais ajustes\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "32TQCWYqEIbo"
      },
      "source": [
        "# Importando biblioteca necessárias para os pontos acima\n",
        "import pandas as pd\n",
        "import matplotlib.pyplot as plt\n",
        "\n"
      ],
      "execution_count": 9,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "1B6yiyAJnTPX"
      },
      "source": [
        "# Importando dados. \n",
        "# Os dados estão no GitHub, vamos acessá-los pela url, não sendo necessário fazer download para máquina.\n",
        "# Atribuimos a URL na variável 'dados' e fazemos a leitura com o pandas.\n",
        "\n",
        "dados = 'https://github.com/alura-cursos/imersaodados3/blob/main/dados/dados_experimentos.zip?raw=true'\n",
        "dados = pd.read_csv(dados, compression = 'zip')"
      ],
      "execution_count": 10,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "WHshxUvUw9-i"
      },
      "source": [
        "**01: Investigar por que a classe de tratamento é muito desbalanceada**\n",
        "\n",
        "É possível perceber que com o tratamento 'com_controle', foi aplicada apenas uma droga, sendo a 'cacb2b860', fazendo com que os dados fiquem desbalanceado."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "9X79MrIA7DhO",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 470
        },
        "outputId": "bf49a439-5ad8-4ba5-9979-4af6ae8aa180"
      },
      "source": [
        "dados.groupby(['tratamento', 'droga']).count()"
      ],
      "execution_count": 11,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>tempo</th>\n",
              "      <th>dose</th>\n",
              "      <th>g-0</th>\n",
              "      <th>g-1</th>\n",
              "      <th>g-2</th>\n",
              "      <th>g-3</th>\n",
              "      <th>g-4</th>\n",
              "      <th>g-5</th>\n",
              "      <th>g-6</th>\n",
              "      <th>g-7</th>\n",
              "      <th>g-8</th>\n",
              "      <th>g-9</th>\n",
              "      <th>g-10</th>\n",
              "      <th>g-11</th>\n",
              "      <th>g-12</th>\n",
              "      <th>g-13</th>\n",
              "      <th>g-14</th>\n",
              "      <th>g-15</th>\n",
              "      <th>g-16</th>\n",
              "      <th>g-17</th>\n",
              "      <th>g-18</th>\n",
              "      <th>g-19</th>\n",
              "      <th>g-20</th>\n",
              "      <th>g-21</th>\n",
              "      <th>g-22</th>\n",
              "      <th>g-23</th>\n",
              "      <th>g-24</th>\n",
              "      <th>g-25</th>\n",
              "      <th>g-26</th>\n",
              "      <th>g-27</th>\n",
              "      <th>g-28</th>\n",
              "      <th>g-29</th>\n",
              "      <th>g-30</th>\n",
              "      <th>g-31</th>\n",
              "      <th>g-32</th>\n",
              "      <th>g-33</th>\n",
              "      <th>g-34</th>\n",
              "      <th>g-35</th>\n",
              "      <th>g-36</th>\n",
              "      <th>...</th>\n",
              "      <th>c-60</th>\n",
              "      <th>c-61</th>\n",
              "      <th>c-62</th>\n",
              "      <th>c-63</th>\n",
              "      <th>c-64</th>\n",
              "      <th>c-65</th>\n",
              "      <th>c-66</th>\n",
              "      <th>c-67</th>\n",
              "      <th>c-68</th>\n",
              "      <th>c-69</th>\n",
              "      <th>c-70</th>\n",
              "      <th>c-71</th>\n",
              "      <th>c-72</th>\n",
              "      <th>c-73</th>\n",
              "      <th>c-74</th>\n",
              "      <th>c-75</th>\n",
              "      <th>c-76</th>\n",
              "      <th>c-77</th>\n",
              "      <th>c-78</th>\n",
              "      <th>c-79</th>\n",
              "      <th>c-80</th>\n",
              "      <th>c-81</th>\n",
              "      <th>c-82</th>\n",
              "      <th>c-83</th>\n",
              "      <th>c-84</th>\n",
              "      <th>c-85</th>\n",
              "      <th>c-86</th>\n",
              "      <th>c-87</th>\n",
              "      <th>c-88</th>\n",
              "      <th>c-89</th>\n",
              "      <th>c-90</th>\n",
              "      <th>c-91</th>\n",
              "      <th>c-92</th>\n",
              "      <th>c-93</th>\n",
              "      <th>c-94</th>\n",
              "      <th>c-95</th>\n",
              "      <th>c-96</th>\n",
              "      <th>c-97</th>\n",
              "      <th>c-98</th>\n",
              "      <th>c-99</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>tratamento</th>\n",
              "      <th>droga</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>com_controle</th>\n",
              "      <th>cacb2b860</th>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>...</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "      <td>1866</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th rowspan=\"10\" valign=\"top\">com_droga</th>\n",
              "      <th>00199ff52</th>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>...</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>00251fc41</th>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>...</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>00321ea80</th>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>...</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>0034c0847</th>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>...</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ff9565933</th>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>...</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ffd66e220</th>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>...</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ffe357f8f</th>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>...</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ffed8e1c9</th>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>...</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>fff7d208d</th>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>...</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>3289 rows × 875 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                          id  tempo  dose   g-0  ...  c-96  c-97  c-98  c-99\n",
              "tratamento   droga                               ...                        \n",
              "com_controle cacb2b860  1866   1866  1866  1866  ...  1866  1866  1866  1866\n",
              "com_droga    00199ff52     6      6     6     6  ...     6     6     6     6\n",
              "             00251fc41     6      6     6     6  ...     6     6     6     6\n",
              "             00321ea80    12     12    12    12  ...    12    12    12    12\n",
              "             0034c0847     6      6     6     6  ...     6     6     6     6\n",
              "...                      ...    ...   ...   ...  ...   ...   ...   ...   ...\n",
              "             ff9565933     6      6     6     6  ...     6     6     6     6\n",
              "             ffd66e220     6      6     6     6  ...     6     6     6     6\n",
              "             ffe357f8f     1      1     1     1  ...     1     1     1     1\n",
              "             ffed8e1c9     6      6     6     6  ...     6     6     6     6\n",
              "             fff7d208d     6      6     6     6  ...     6     6     6     6\n",
              "\n",
              "[3289 rows x 875 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "yUCyIN2LGmbz"
      },
      "source": [
        "**02: Visualizar as últimas linhas do dataset**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 253
        },
        "id": "CwDepCLF-rJm",
        "outputId": "a82b2053-25d6-448e-a039-9aedc98f8a2b"
      },
      "source": [
        "# Para ler a 'rodapé' do dataset, podemos utilizar a função .tail().\n",
        "dados.tail()"
      ],
      "execution_count": 12,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>tratamento</th>\n",
              "      <th>tempo</th>\n",
              "      <th>dose</th>\n",
              "      <th>droga</th>\n",
              "      <th>g-0</th>\n",
              "      <th>g-1</th>\n",
              "      <th>g-2</th>\n",
              "      <th>g-3</th>\n",
              "      <th>g-4</th>\n",
              "      <th>g-5</th>\n",
              "      <th>g-6</th>\n",
              "      <th>g-7</th>\n",
              "      <th>g-8</th>\n",
              "      <th>g-9</th>\n",
              "      <th>g-10</th>\n",
              "      <th>g-11</th>\n",
              "      <th>g-12</th>\n",
              "      <th>g-13</th>\n",
              "      <th>g-14</th>\n",
              "      <th>g-15</th>\n",
              "      <th>g-16</th>\n",
              "      <th>g-17</th>\n",
              "      <th>g-18</th>\n",
              "      <th>g-19</th>\n",
              "      <th>g-20</th>\n",
              "      <th>g-21</th>\n",
              "      <th>g-22</th>\n",
              "      <th>g-23</th>\n",
              "      <th>g-24</th>\n",
              "      <th>g-25</th>\n",
              "      <th>g-26</th>\n",
              "      <th>g-27</th>\n",
              "      <th>g-28</th>\n",
              "      <th>g-29</th>\n",
              "      <th>g-30</th>\n",
              "      <th>g-31</th>\n",
              "      <th>g-32</th>\n",
              "      <th>g-33</th>\n",
              "      <th>g-34</th>\n",
              "      <th>...</th>\n",
              "      <th>c-60</th>\n",
              "      <th>c-61</th>\n",
              "      <th>c-62</th>\n",
              "      <th>c-63</th>\n",
              "      <th>c-64</th>\n",
              "      <th>c-65</th>\n",
              "      <th>c-66</th>\n",
              "      <th>c-67</th>\n",
              "      <th>c-68</th>\n",
              "      <th>c-69</th>\n",
              "      <th>c-70</th>\n",
              "      <th>c-71</th>\n",
              "      <th>c-72</th>\n",
              "      <th>c-73</th>\n",
              "      <th>c-74</th>\n",
              "      <th>c-75</th>\n",
              "      <th>c-76</th>\n",
              "      <th>c-77</th>\n",
              "      <th>c-78</th>\n",
              "      <th>c-79</th>\n",
              "      <th>c-80</th>\n",
              "      <th>c-81</th>\n",
              "      <th>c-82</th>\n",
              "      <th>c-83</th>\n",
              "      <th>c-84</th>\n",
              "      <th>c-85</th>\n",
              "      <th>c-86</th>\n",
              "      <th>c-87</th>\n",
              "      <th>c-88</th>\n",
              "      <th>c-89</th>\n",
              "      <th>c-90</th>\n",
              "      <th>c-91</th>\n",
              "      <th>c-92</th>\n",
              "      <th>c-93</th>\n",
              "      <th>c-94</th>\n",
              "      <th>c-95</th>\n",
              "      <th>c-96</th>\n",
              "      <th>c-97</th>\n",
              "      <th>c-98</th>\n",
              "      <th>c-99</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>23809</th>\n",
              "      <td>id_fffb1ceed</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D2</td>\n",
              "      <td>df1d0a5a1</td>\n",
              "      <td>0.1394</td>\n",
              "      <td>-0.0636</td>\n",
              "      <td>-0.1112</td>\n",
              "      <td>-0.5080</td>\n",
              "      <td>-0.4713</td>\n",
              "      <td>0.7201</td>\n",
              "      <td>0.5773</td>\n",
              "      <td>0.3055</td>\n",
              "      <td>-0.4726</td>\n",
              "      <td>0.1269</td>\n",
              "      <td>0.2531</td>\n",
              "      <td>0.1730</td>\n",
              "      <td>-0.4532</td>\n",
              "      <td>-1.0790</td>\n",
              "      <td>0.2474</td>\n",
              "      <td>-0.4550</td>\n",
              "      <td>0.3588</td>\n",
              "      <td>0.1600</td>\n",
              "      <td>-0.7362</td>\n",
              "      <td>-0.1103</td>\n",
              "      <td>0.8550</td>\n",
              "      <td>-0.4139</td>\n",
              "      <td>0.5541</td>\n",
              "      <td>0.2310</td>\n",
              "      <td>-0.5573</td>\n",
              "      <td>-0.4397</td>\n",
              "      <td>-0.9260</td>\n",
              "      <td>-0.2424</td>\n",
              "      <td>-0.6686</td>\n",
              "      <td>0.2326</td>\n",
              "      <td>0.6456</td>\n",
              "      <td>0.0136</td>\n",
              "      <td>-0.5141</td>\n",
              "      <td>-0.6320</td>\n",
              "      <td>0.7166</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0807</td>\n",
              "      <td>0.4024</td>\n",
              "      <td>-0.0895</td>\n",
              "      <td>0.4420</td>\n",
              "      <td>0.9641</td>\n",
              "      <td>-0.1846</td>\n",
              "      <td>-0.0014</td>\n",
              "      <td>0.3154</td>\n",
              "      <td>-0.2071</td>\n",
              "      <td>-0.6158</td>\n",
              "      <td>-0.2977</td>\n",
              "      <td>0.0992</td>\n",
              "      <td>0.6838</td>\n",
              "      <td>0.5259</td>\n",
              "      <td>0.7882</td>\n",
              "      <td>0.3119</td>\n",
              "      <td>-0.7697</td>\n",
              "      <td>0.2203</td>\n",
              "      <td>-1.0710</td>\n",
              "      <td>0.5979</td>\n",
              "      <td>0.0848</td>\n",
              "      <td>-0.2555</td>\n",
              "      <td>0.6293</td>\n",
              "      <td>1.1660</td>\n",
              "      <td>0.3329</td>\n",
              "      <td>0.2754</td>\n",
              "      <td>0.4108</td>\n",
              "      <td>-0.1252</td>\n",
              "      <td>-0.2340</td>\n",
              "      <td>0.2267</td>\n",
              "      <td>0.1969</td>\n",
              "      <td>0.0262</td>\n",
              "      <td>-0.8121</td>\n",
              "      <td>0.3434</td>\n",
              "      <td>0.5372</td>\n",
              "      <td>-0.3246</td>\n",
              "      <td>0.0631</td>\n",
              "      <td>0.9171</td>\n",
              "      <td>0.5258</td>\n",
              "      <td>0.4680</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23810</th>\n",
              "      <td>id_fffb70c0c</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D2</td>\n",
              "      <td>ecf3b6b74</td>\n",
              "      <td>-1.3260</td>\n",
              "      <td>0.3478</td>\n",
              "      <td>-0.3743</td>\n",
              "      <td>0.9905</td>\n",
              "      <td>-0.7178</td>\n",
              "      <td>0.6621</td>\n",
              "      <td>-0.2252</td>\n",
              "      <td>-0.5565</td>\n",
              "      <td>0.5112</td>\n",
              "      <td>0.6727</td>\n",
              "      <td>-0.1851</td>\n",
              "      <td>2.8650</td>\n",
              "      <td>-0.2140</td>\n",
              "      <td>-0.6153</td>\n",
              "      <td>0.8362</td>\n",
              "      <td>0.5584</td>\n",
              "      <td>-0.2589</td>\n",
              "      <td>0.1292</td>\n",
              "      <td>0.0148</td>\n",
              "      <td>0.0949</td>\n",
              "      <td>-0.2182</td>\n",
              "      <td>-0.9235</td>\n",
              "      <td>0.0749</td>\n",
              "      <td>-1.5910</td>\n",
              "      <td>-0.8359</td>\n",
              "      <td>-0.9217</td>\n",
              "      <td>0.3013</td>\n",
              "      <td>0.1716</td>\n",
              "      <td>0.0880</td>\n",
              "      <td>0.1842</td>\n",
              "      <td>0.1835</td>\n",
              "      <td>0.5436</td>\n",
              "      <td>-0.0533</td>\n",
              "      <td>-0.0491</td>\n",
              "      <td>0.9543</td>\n",
              "      <td>...</td>\n",
              "      <td>0.1410</td>\n",
              "      <td>1.2640</td>\n",
              "      <td>-0.8663</td>\n",
              "      <td>0.8129</td>\n",
              "      <td>-0.1514</td>\n",
              "      <td>-0.4652</td>\n",
              "      <td>-0.7390</td>\n",
              "      <td>-1.3270</td>\n",
              "      <td>0.9925</td>\n",
              "      <td>1.0570</td>\n",
              "      <td>-0.3355</td>\n",
              "      <td>-0.2555</td>\n",
              "      <td>0.8219</td>\n",
              "      <td>0.6995</td>\n",
              "      <td>-0.2942</td>\n",
              "      <td>0.2408</td>\n",
              "      <td>-0.7781</td>\n",
              "      <td>-0.0929</td>\n",
              "      <td>-0.0329</td>\n",
              "      <td>0.0781</td>\n",
              "      <td>-1.4440</td>\n",
              "      <td>-0.0921</td>\n",
              "      <td>0.3188</td>\n",
              "      <td>-1.1080</td>\n",
              "      <td>0.4895</td>\n",
              "      <td>-0.2144</td>\n",
              "      <td>1.0960</td>\n",
              "      <td>0.3335</td>\n",
              "      <td>0.4444</td>\n",
              "      <td>-1.1130</td>\n",
              "      <td>0.4286</td>\n",
              "      <td>0.4426</td>\n",
              "      <td>0.0423</td>\n",
              "      <td>-0.3195</td>\n",
              "      <td>-0.8086</td>\n",
              "      <td>-0.9798</td>\n",
              "      <td>-0.2084</td>\n",
              "      <td>-0.1224</td>\n",
              "      <td>-0.2715</td>\n",
              "      <td>0.3689</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23811</th>\n",
              "      <td>id_fffc1c3f4</td>\n",
              "      <td>com_controle</td>\n",
              "      <td>48</td>\n",
              "      <td>D2</td>\n",
              "      <td>cacb2b860</td>\n",
              "      <td>0.3942</td>\n",
              "      <td>0.3756</td>\n",
              "      <td>0.3109</td>\n",
              "      <td>-0.7389</td>\n",
              "      <td>0.5505</td>\n",
              "      <td>-0.0159</td>\n",
              "      <td>-0.2541</td>\n",
              "      <td>0.1745</td>\n",
              "      <td>-0.0340</td>\n",
              "      <td>0.4865</td>\n",
              "      <td>-0.1854</td>\n",
              "      <td>0.0716</td>\n",
              "      <td>0.1729</td>\n",
              "      <td>-0.0434</td>\n",
              "      <td>0.1542</td>\n",
              "      <td>-0.2192</td>\n",
              "      <td>-0.0302</td>\n",
              "      <td>-0.4218</td>\n",
              "      <td>0.4057</td>\n",
              "      <td>-0.5372</td>\n",
              "      <td>0.1521</td>\n",
              "      <td>-0.2651</td>\n",
              "      <td>0.2310</td>\n",
              "      <td>-0.8101</td>\n",
              "      <td>0.4943</td>\n",
              "      <td>0.6905</td>\n",
              "      <td>-0.3720</td>\n",
              "      <td>-1.4110</td>\n",
              "      <td>0.4516</td>\n",
              "      <td>1.2300</td>\n",
              "      <td>-0.1949</td>\n",
              "      <td>-1.3280</td>\n",
              "      <td>-0.4276</td>\n",
              "      <td>-0.0040</td>\n",
              "      <td>-0.3086</td>\n",
              "      <td>...</td>\n",
              "      <td>0.6845</td>\n",
              "      <td>0.7127</td>\n",
              "      <td>0.7294</td>\n",
              "      <td>0.4718</td>\n",
              "      <td>-0.2020</td>\n",
              "      <td>0.2783</td>\n",
              "      <td>0.4934</td>\n",
              "      <td>0.4144</td>\n",
              "      <td>0.5449</td>\n",
              "      <td>1.4690</td>\n",
              "      <td>-0.6142</td>\n",
              "      <td>0.6068</td>\n",
              "      <td>0.3434</td>\n",
              "      <td>0.9880</td>\n",
              "      <td>-0.0468</td>\n",
              "      <td>-0.1882</td>\n",
              "      <td>-0.0087</td>\n",
              "      <td>-0.0356</td>\n",
              "      <td>0.5718</td>\n",
              "      <td>0.4971</td>\n",
              "      <td>0.1057</td>\n",
              "      <td>0.2111</td>\n",
              "      <td>0.6992</td>\n",
              "      <td>0.0708</td>\n",
              "      <td>0.6169</td>\n",
              "      <td>0.2248</td>\n",
              "      <td>0.5994</td>\n",
              "      <td>0.2689</td>\n",
              "      <td>0.0305</td>\n",
              "      <td>1.2320</td>\n",
              "      <td>0.5409</td>\n",
              "      <td>0.3755</td>\n",
              "      <td>0.7343</td>\n",
              "      <td>0.2807</td>\n",
              "      <td>0.4116</td>\n",
              "      <td>0.6422</td>\n",
              "      <td>0.2256</td>\n",
              "      <td>0.7592</td>\n",
              "      <td>0.6656</td>\n",
              "      <td>0.3808</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23812</th>\n",
              "      <td>id_fffcb9e7c</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>8b87a7a83</td>\n",
              "      <td>0.6660</td>\n",
              "      <td>0.2324</td>\n",
              "      <td>0.4392</td>\n",
              "      <td>0.2044</td>\n",
              "      <td>0.8531</td>\n",
              "      <td>-0.0343</td>\n",
              "      <td>0.0323</td>\n",
              "      <td>0.0463</td>\n",
              "      <td>0.4299</td>\n",
              "      <td>-0.7985</td>\n",
              "      <td>0.5742</td>\n",
              "      <td>0.1421</td>\n",
              "      <td>2.2700</td>\n",
              "      <td>0.2046</td>\n",
              "      <td>0.5363</td>\n",
              "      <td>-1.7330</td>\n",
              "      <td>0.1450</td>\n",
              "      <td>0.6097</td>\n",
              "      <td>0.2024</td>\n",
              "      <td>0.9865</td>\n",
              "      <td>-0.7805</td>\n",
              "      <td>0.9608</td>\n",
              "      <td>0.3440</td>\n",
              "      <td>2.7650</td>\n",
              "      <td>0.4925</td>\n",
              "      <td>0.6698</td>\n",
              "      <td>0.2374</td>\n",
              "      <td>-0.3372</td>\n",
              "      <td>0.8771</td>\n",
              "      <td>-2.6560</td>\n",
              "      <td>-0.2000</td>\n",
              "      <td>-0.2043</td>\n",
              "      <td>0.6797</td>\n",
              "      <td>-0.0248</td>\n",
              "      <td>-0.0927</td>\n",
              "      <td>...</td>\n",
              "      <td>0.3360</td>\n",
              "      <td>-0.6136</td>\n",
              "      <td>0.5011</td>\n",
              "      <td>0.9261</td>\n",
              "      <td>0.4419</td>\n",
              "      <td>0.0295</td>\n",
              "      <td>0.4220</td>\n",
              "      <td>0.4677</td>\n",
              "      <td>-0.1184</td>\n",
              "      <td>0.4524</td>\n",
              "      <td>0.4135</td>\n",
              "      <td>0.1356</td>\n",
              "      <td>-0.5801</td>\n",
              "      <td>0.0411</td>\n",
              "      <td>1.0240</td>\n",
              "      <td>1.0340</td>\n",
              "      <td>-0.0270</td>\n",
              "      <td>-0.4194</td>\n",
              "      <td>0.7403</td>\n",
              "      <td>-0.6793</td>\n",
              "      <td>-0.1423</td>\n",
              "      <td>0.7307</td>\n",
              "      <td>0.7946</td>\n",
              "      <td>-0.0650</td>\n",
              "      <td>0.9038</td>\n",
              "      <td>0.2324</td>\n",
              "      <td>0.9676</td>\n",
              "      <td>1.0940</td>\n",
              "      <td>0.4290</td>\n",
              "      <td>0.5187</td>\n",
              "      <td>-0.1105</td>\n",
              "      <td>0.4258</td>\n",
              "      <td>-0.2012</td>\n",
              "      <td>0.1506</td>\n",
              "      <td>1.5230</td>\n",
              "      <td>0.7101</td>\n",
              "      <td>0.1732</td>\n",
              "      <td>0.7015</td>\n",
              "      <td>-0.6290</td>\n",
              "      <td>0.0740</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23813</th>\n",
              "      <td>id_ffffdd77b</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D1</td>\n",
              "      <td>972f41291</td>\n",
              "      <td>-0.8598</td>\n",
              "      <td>1.0240</td>\n",
              "      <td>-0.1361</td>\n",
              "      <td>0.7952</td>\n",
              "      <td>-0.3611</td>\n",
              "      <td>-3.6750</td>\n",
              "      <td>-1.2420</td>\n",
              "      <td>0.9146</td>\n",
              "      <td>3.0790</td>\n",
              "      <td>1.2460</td>\n",
              "      <td>1.9460</td>\n",
              "      <td>1.4370</td>\n",
              "      <td>2.9780</td>\n",
              "      <td>2.2370</td>\n",
              "      <td>-0.6818</td>\n",
              "      <td>0.6870</td>\n",
              "      <td>-1.1060</td>\n",
              "      <td>0.0182</td>\n",
              "      <td>-0.9247</td>\n",
              "      <td>-0.0738</td>\n",
              "      <td>-0.1919</td>\n",
              "      <td>-0.7722</td>\n",
              "      <td>-1.4050</td>\n",
              "      <td>-1.0050</td>\n",
              "      <td>-1.1170</td>\n",
              "      <td>-0.5293</td>\n",
              "      <td>-1.1720</td>\n",
              "      <td>-0.2885</td>\n",
              "      <td>0.1599</td>\n",
              "      <td>-0.4250</td>\n",
              "      <td>0.3591</td>\n",
              "      <td>-0.1420</td>\n",
              "      <td>-0.9530</td>\n",
              "      <td>-0.2005</td>\n",
              "      <td>-1.8340</td>\n",
              "      <td>...</td>\n",
              "      <td>-6.9170</td>\n",
              "      <td>-1.8640</td>\n",
              "      <td>-2.5090</td>\n",
              "      <td>-4.7130</td>\n",
              "      <td>-1.7250</td>\n",
              "      <td>-3.8650</td>\n",
              "      <td>-3.0800</td>\n",
              "      <td>-4.1530</td>\n",
              "      <td>-1.2030</td>\n",
              "      <td>-1.1690</td>\n",
              "      <td>-4.1460</td>\n",
              "      <td>-1.2670</td>\n",
              "      <td>-1.1300</td>\n",
              "      <td>-2.4390</td>\n",
              "      <td>0.1591</td>\n",
              "      <td>-2.2490</td>\n",
              "      <td>-2.5860</td>\n",
              "      <td>-1.9520</td>\n",
              "      <td>-2.1810</td>\n",
              "      <td>-4.6690</td>\n",
              "      <td>-3.9450</td>\n",
              "      <td>-2.9560</td>\n",
              "      <td>-2.7930</td>\n",
              "      <td>-2.1560</td>\n",
              "      <td>-2.4100</td>\n",
              "      <td>-1.8190</td>\n",
              "      <td>-3.3480</td>\n",
              "      <td>-0.1414</td>\n",
              "      <td>-2.6430</td>\n",
              "      <td>-2.5810</td>\n",
              "      <td>-3.3890</td>\n",
              "      <td>-1.7450</td>\n",
              "      <td>-6.6300</td>\n",
              "      <td>-4.0950</td>\n",
              "      <td>-7.3860</td>\n",
              "      <td>-1.4160</td>\n",
              "      <td>-3.5770</td>\n",
              "      <td>-0.4775</td>\n",
              "      <td>-2.1500</td>\n",
              "      <td>-4.2520</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 877 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                 id    tratamento  tempo dose  ...    c-96    c-97    c-98    c-99\n",
              "23809  id_fffb1ceed     com_droga     24   D2  ...  0.0631  0.9171  0.5258  0.4680\n",
              "23810  id_fffb70c0c     com_droga     24   D2  ... -0.2084 -0.1224 -0.2715  0.3689\n",
              "23811  id_fffc1c3f4  com_controle     48   D2  ...  0.2256  0.7592  0.6656  0.3808\n",
              "23812  id_fffcb9e7c     com_droga     24   D1  ...  0.1732  0.7015 -0.6290  0.0740\n",
              "23813  id_ffffdd77b     com_droga     72   D1  ... -3.5770 -0.4775 -2.1500 -4.2520\n",
              "\n",
              "[5 rows x 877 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 12
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "-2v8w2jlGsgv"
      },
      "source": [
        "**03: Calcular a proporção das classes tratamento**\n",
        "\n",
        "Com a função abaixo, podemos perceber que a classe de tratamento 'com_droga' representa 92% do dataset, mostrando que é bastante desproporcional a classe 'com_controle'"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "XdVdJU3qG3iM",
        "outputId": "65ae4439-73d3-403e-f14a-186de3ba912c"
      },
      "source": [
        "# Para cálcular a proporção entre os valores de um campo, podemos utilizar a função value_counts(), atribuindo ao campo desejado.\n",
        "dados['tratamento'].value_counts(normalize=True)*100\n",
        "\n"
      ],
      "execution_count": 13,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "com_droga       92.164273\n",
              "com_controle     7.835727\n",
              "Name: tratamento, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ZM2puziIAky4",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 264
        },
        "outputId": "6ab0b8f6-53c9-44e7-870c-9529dab80080"
      },
      "source": [
        "#Podemos ainda evidenciar a a proporcionalidade das classes por meio de gráficos.\n",
        "\n",
        "tipos_tratamentos = dados['tratamento'].value_counts(normalize=True)\n",
        "\n",
        "plt.title('Proporcionalidade entre os tratamentos')\n",
        "labels = dados['tratamento'].unique()\n",
        "explode = (0.3,0)\n",
        "\n",
        "plt.pie(tipos_tratamentos, labels=labels, explode=explode, shadow=True, autopct='%1.1f%%', rotatelabels=False, colors = None)\n",
        "\n",
        "\n",
        "plt.show()"
      ],
      "execution_count": 66,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAVoAAAD3CAYAAABcpJzyAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3deXxcVf3/8ddnliyTtWm60mUonQa60AXKsAkFyhqoKFTZlyKKIiqiEpWfVlGM4lcBFVBUVkVAWQIBESiLAk2B0lK2ENoGSvc122SZ5fz+OLd0mjZN2mRyM8nn+XjMI5O522eWvOfm3HPPFWMMSimlUsfjdgFKKdXfadAqpVSKadAqpVSKadAqpVSKadAqpVSKadAqpVSKadCmCRF5R0RmpXgbQRExIuJzfn9KRC7uyrz7sC0jIuO7U69S6WJABq2I1IpIs4g0ish6EblLRHLdrmtPjDGTjDEv9PI2TzXG3N2b20wlEblERP7ndh3tdfdLK2k9tSIyu6fq6kl9ubbeMCCD1nGGMSYXmAEcClzXfobufvD3Rm9uS3VMRLxu17A7+vlIc8aYAXcDaoHZSb/fCDzh3DfAlUANsNJ57HLgQ2ALUAGMTFrWAN8AVgCbnHV5nGkebIB/BGwA7gEKnGlBZ9nLgI+Bl5K29R7QALwLzGhfM5AJ3ASscW43AZnOtFnAJ8A1zjbXApcm1VsKvAnUA6uA+UnTttfkc35/AfiSc98L/Np5jiuc1yh53kuT6l4BfKXda/5dp5Y1wDxn2fFJz+fXzuuwHrgdyN7D+zfP2dZW4GlgbLv34wrn/dsG/AEQ4CCgBYgDjcA2Z/67gNuAJ4EmYDYwEvgXsBFYCXxjD7UUOO/rRud9vi7p/R8PvAjUOa/bAx2s42On7kbndgRwCfAy8FtgM/Az4ABggfP7JuBvQKGzjnuBBNDsrON7zuMPAeucGl4CJiVt9y7gVuApZ5mXgeHYz9NW4H1getL8Hb4uwHzgQee1aADeAQ7tpLY5znzbsJ+1g5LWdy2w2llXNXCC27nRrcxxuwBXnvTOoTXaebOvd343wDNAEZANHO98qGdgA+F3OKGYNP/zzvxjgA/YEU7zsAE9DsgFHgbudaYFnWXvAXKcbc11PlwzseEwHidE2tX8U2AhMBQYArySVP8sIObM4wdOAyLAoKTpU7BfAgdjg+3MdjXtLmivcP7wRjvP9fl285Zig0CAY51tbv+SOMXZzmTnuf6dnYP2t9gvsCIgD3gc+EUH791nndf0IMCHDbZX2r0fTwCFzvuxETjFmXYJ8L9267sLG0JHOa9JAHgD+BGQ4bx3K4CTO6jnHuAxp+6g8/5f5ky7H/ihs94s4OgO1rHT655Uawy4ynme2c7n4UTs53AINjhv2t3nOumxeU5t27+cl7R77puAQ5z6FmAD9CLsF+vPgOedeT17el2wQduC/bx5gV8ACzuqDZiA/WI7Efs5/Z7zvmYAJdidgJFJr88BbudGtzLH7QJcedL2TW/EfpN+hP1Wz3amGeD4pHn/Avwq6fdcIAoEk+Y/JWn614DnnPvPAV9LmlbiLOtL+uMalzT9aeCbe6h5e9AuB05LmnYyUOvcn4Xdc0j+o90AHN7Bem8Cfuvc317T7oJ2AXBF0nIn0S4c2q330e3PBfgrUJ40bYKz7HhsMDcl/yFh9+hWdrDep3CCzPndgw31sUnvx9FJ0x8Eypz7l7D7oL0n6fcw8HG7eb4P3LmbWrxAGzAx6bGvAC849+8B/gSM6uTzuNPrnlTrx50sdybw5u4+Ix3MX+hsZ/t/VXcBdyRNvwp4L+n3KezY89/j64IN2meTpk0EmjuqDfh/wIPt3sfV2M/veOxndjbg39u/7754G8httGcaYwqNMWONMV8zxjQnTVuVdH8kNowBMMY0Yv9126+D+T9yltllWee+DxjWwbKjsSHamd2td2TS75uNMbGk3yPYLwhEJCwiz4vIRhGpw+6pFndxm+2f56dE5FQRWSgiW0RkG3bPprgLyw7B2YsUkW3Osv92Ht+dscDNSfNuwYZ18vuxLun+p899D5JrGwuM3L5+Zxs/YOf3bLti7N5Y+/diey3fc2pb5PQamddJHXuqCxEZJiL/EJHVIlIP3Mce3jsR8YpIuYgsd+avTap7u/VJ95t38/v2164rr0v71z1rD23L7f+uEs7z3c8Y8yHwLWx4b3Ce88jdriVNDOSg3ROTdH8N9kMGgIjkAIOx377bjU66P8ZZZpdlnWkxdv4wJ29rFfbf787sbr1rOpi3vb9j/00fbYwpwLaHSheWW8uuzxMAEcnEtt39GhhmjCnEtnlKZ8ti/3VtxrYdFjq3AmMPVO7OKmz7b2HSLdsY80oXnoPpwuOrsHvTyevPM8actpvlNmH/Q2n/XqwGMMasM8ZcbowZid3TvbWDLm1dqQvgBuexKcaYfOACdn7v2s9/HrapZTa2LTnoPN6V97u9vXlddqd9be3/rgT7Gdn+2v3dGHO0M48BfrkPNfcZGrSdux+4VESmOYFyA1BljKlNmue7IjJIREYD3wQeSFr2ahHZ3+k+dgP2gEjy3mayPwPfEZFDxBovImN3M9/9wHUiMkREirHtZvd18fnkAVuMMS0ichj2j7ErHgS+ISKjRGQQUJY0LQPbBrgRiInIqdimheRlLxGRiSISAH68fYKzJ3MH8FsRGQogIvuJyMkd1HE78H0RmeTMWyAic7v4HNYDo0QkYw/zLAIaRORaEcl29goni8jM9jMaY+LOc/u5iOQ579W3cd4LEZkrIqOc2bdiAyOxm21udB4f10n9edgmrzoR2Q97gLH98xvXbv5W7H9gAeznb191+XXpQPvaHgRKReQEEfFjD962Aq+ISImIHO/8vbVgv4h397qlDQ3aThhjnsW2J/0Lu2d2AHBOu9kewx4oWAJUYtt1wbZN3os9aLES+6G5ag/begj4OXavswHbzlm0m1l/BrwOvAUsAxY7j3XF14CfikgDNqAf7OJyd2DbkJc623s4qe4GbM+LB7GBch52r3n79KewbcELsAc8FrRb97XO4wudf3GfxbZn78IY8wh27+YfzrxvA6d28TkswB74XCcimzpYfxw4HZiGfc82Yb8ACzpY51XYNuYVwP+w791fnWkzgSoRacS+Ht80xqzYzTYj2Pf9Zeff8sM72NZPsAdl67Cfs4fbTf8F9gt4m4h8B9tG/BF2L/Fd7AHUfbIPr0t7O9VmjKnG7pH/zlnXGdgul23YL+1y5/F12IO+39/X2vsCcRqi1T4SEQOEnHYlpZTahe7RKqVUimnQKqVUimnTgVJKpZju0SqlVIpp0CqlVIpp0CqlVIpp0CqlVIpp0CqlVIpp0CqlVIpp0CqlVIpp0CqlVIpp0CqlVIpp0CqlVIpp0CqlVIpp0CqlVIpp0CqlVIpp0CqlVIpp0CqlVIpp0CqlVIp1dM11pfZZsKwyC3vRvu23POwVYLdf0TT5ZwsQqS0vjbpTrVKpp1dYUHslWFaZAYzHXqV2QtJtBDZU87GXH99bW4BPsFdsXYW9quxy7NVxa2rLS5u6XbxSLtGgVR0KllUOAo4AjsJe5rrEGDNGRLy9XEoCeA97uewq5+c7teWliV6uQ6l9okGrPuUE63HACcaYWcBBIiLuVtWhBuB1bPAuAF7Q5gfVV2nQDnDBssqxwBeNMXOBGSKSrgdI64BK4FHgqdry0kaX61HqUxq0A1CwrHIk8AWTiF8gHu8hbteTAi3Ac9jQfay2vHSjy/WoAU6DdoAIllUWAueaRPwCxHN4Gu+57q0Y8Bhwa2156QK3i1EDkwZtPxcsqxxnYm3fw+O7SDyebLfrcdl7wK3APbXlpfVuF6MGDg3afmrs9x4/ysTb/p/4Mk/qwwe03NII3Af8oba89G23i1H9nwZtPxIsq/SaRPxsE4/90OPPnOJ2PWmiEvhRbXnpYrcLUf2XBm0/MeZbD34en/83Hl/GWLdrSVOPYQP3LbcLUf2PBm2aG33V3w7F6/2TNytvutu19AMJbJPCdbXlpavcLkb1Hxq0aWr0N/+xHyZ+mye74HRtg+1xLcAtwPXaH1f1BA3aNDP6m/dnEY/90pOd/1Xx+vxu19PPfQR8pba89Gm3C1HpTYM2jYy87NY5voIhd3gyAkPdrmWAuQe4ura8dIvbhaj0pEGbBoZ98fp8X+GI+3yFw7WZwD3rgatqy0sfcrsQlX40aPu44ef/8oyMIcE7PVm5g92uRQHwCHBlbXnpWrcLUelDg7aPKjz6/IzAhCP+7C8ee754PAPldNl0sRH4Ym156fNuF6LSgwZtHzT4tG8emL3/jEpfXvE4t2tRHYoD368tL73R7UJU36dB24cEQmEJTDjy3EDo8Ns8Wbn5btejuuSfwKXaDUztiQZtHxEIhX05U2b/PDBu5tXi82u3rfTyHvC52vLSarcLUX2TBm0fEAiFc/MP+/z9maMmlWqvgrRVD1xcW176qNuFqL5Hg9Zl+eGzxuZOPuGJjCFjJ7tdi+q2BHBFbXnpHW4XovoWDVoXFRwx99C86aUVvvwhI9yuRfWo79SWl/6f20WovkOD1gWBUFi8+UNOLQjPvcuXXzzE7XpUSlxfW176I7eLUH2DBm0vC4TC4s0b8vmCI+be5svTkO3nbsaeuqt/ZAOcBm0vsnuyQ88qOHzubb68wcVu16N6xV+By2vLSxNuF6Lco0HbS5yQPbvg8Lm3asgOOPdieyToH9sApad29gKnTXau7skOWBcCenBsANOgTbFAKCziyzgjf+aZN/nyBuvAMAPX1cGyymvdLkK5Q4M29U7Mn3nmr/yFI7QLlyoPllVe4HYRqvdp0KZQIBSemjP5hOszRx5Y4nYtqs/4S7Cs8jNuF6F6lwZtigRC4TFZwem/CEw4Yqbbtag+JQN4JFhWGXK7ENV7NGhTIBAKF/qHBH+aN/WUE0Q8OnaBam8w8FiwrDLgdiGqd2jQ9rBAKJzpzRn03YLDzvqc+PwZbtej+qyDgN+5XYTqHRq0PSgQCnuAi/MP+/yFnqwcHU9WdWZesKzyXLeLUKmnQduzTsyZfMJl/qL9RrtdiEobtwfLKg9wuwiVWhq0PSQQCu/vLx57RSB0+Ay3a1FpJR/4R7CsUgd778c0aHtAIBQO4PFdmT/zzKPF4/W5XY9KO4cC5W4XoVJHg7abAqGwAF/Mm1F6gjdQoKfXqn11dbCs8kS3i1CpoUHbfVMyho0/O2vMlIPdLkSlNQFuDZZVZrpdiOp5GrTdEAiF8xDP5XkzTp8p4tHXUnXXeOC7bhehep6Gwz5ymgzOyZk4a7o3kK8DeKue8oNgWWXQ7SJUz9Kg3XcTJDPnuMD4w6a7XYjqV7KxV2ZQ/YgG7T4IhMJe4Py86acdKL4MPY1S9bQ5wbLKUreLUD1Hg3bfHO4bNHJS5ogSPQCmUuWWYFlllttFqJ6hQbuXAqFwADg3b/ppU8Tj8bpdj+q3xgHfcLsI1TM0aPfeSZmjJ4/zDxqpw9ypVLtGR/jqHzRo90IgFB4CnJ476bipbteiBoShwJfdLkJ1nwbt3vl85qhJQ705g0a6XYgaML6rJzGkPw3aLgqEwiOAwwMlR01wuxY1oIwE5rldhOoeDdqum+0vGpXjKxim1/9Sve1aHd0rvWnQdkEgFC4Ejs2ZdNx4Eb0yjep1Y4EL3S5C7TsN2q452pNTmO0vHjPF7ULUgKVjIKQxDdpOBELhLOC03MknjNWxZpWLDgyWVR7jdhFq32jQdu4wPN7szOEhHdNAuU27eqUpDdo9cMY0mJM97pACHdNA9QFnBcsqi9wuQu09Ddo9Gw8UZY2ePN7tQpQCsoAvul2E2nsatHt2uPgzja9w+IFuF6KUQ3sfpCEN2g4EQuEM4MhA6PAi8fi0D6PqK47Qy5OnHw3ajh0I+DNHHjjR7UKUaud8twtQe6dPBq2IXCIiv3e5jKM82fl484do+6zqa3RQ8DTTJ4O2IyLSK/1YA6FwDnBIIHT4EL3oouqDDg2WVQ52uwjVdV0KERG5SETeEpGlInKviARFZIHz2HMiMsaZ7y4RuU1EForIChGZJSJ/FZH3ROSuTrZxqYh8ICKLgKOSHr9LRG4XkSrgVyIyzVn/WyLyiIgMcuab6Ty2RERuFJG3nceDIvJfEVns3I7swlOeCHj9Q4K6N6v6Ig8w2+0iVNd1GrQiMgm4DjjeGDMV+CbwO+BuY8zBwN+AW5IWGQQcAVwNVAC/BSYBU0RkWgfbGAH8BBuwR2ODLtko4EhjzLeBe4BrnW0vA37szHMn8BVjzDQgnrTsBuBEY8wMbNeY5Fo7chTiifjyBge7MK9SbjjF7QJU13Vlj/Z44CFjzCYAY8wWbJD+3Zl+LzYct3vcGGOwIbjeGLPMGJMA3gGCHWwjDLxgjNlojGkDHmg3/SFjTFxECoBCY8yLzuN3A8eISCGQZ4x51Xn870nL+oE7RGQZ8BC7hvhOAqGwH5iYud9BWeL16zWbVF91ktsFqK5LRftjq/MzkXR/++/72sba1I16rgbWA1OBQ4GMTuYfC3gzR0wIdmObSqXayGBZpQ5ylCa6ErQLgLkiMhhARIqAV4BznOnnA//tZh1VwLEiMlhE/MDc3c1kjKkDtorIZ5yHLgReNMZsAxpEJOw8fk7SYgXAWmev+kKgswsqTgDwFQ4fu29PRalec7LbBaiu6XQP0xjzjoj8HHhRROLAm8BVwJ0i8l1gI3Bpd4owxqwVkfnAq8A2YMkeZr8YuF1EAsCKpG1fhm0iSAAvAnXO47cC/xKRi4B/0/ne8SGI1HtzBo3apyejVO+ZBfza7SJU58Q2p6Y/Eck1xjQ698uAEcaYb+7NOgKhcCZwa8aIkljhkV/UkZJUX/dJbXnpaLeLUJ3rT31ES52uXW8DnwF+tg/rGAWQMXT//Xq0MqVSY5SO5pUeen0ga6c/bPurel5ojFnWnfUaYx5g194KeysIiDdv8JBurmcX9a8/RuPSp8FA7tSTyZ/5WbY+/1ciHy5CvD58hcMpPu1beLJyd1ouVr+RTZW/IdG0DRByp51M/qGfBWDrC3fSvOINMobuT/Hp1wDQ+M7zJCL15M/8bE8/BdU3TQWed7sItWe9HrTGmHDnc7mmBIh4swuKe3KlbRtraVz6NMMv+g3i9bPhwR+RPX4mWcFpFB57MeLxsvWFO6lb+BCDZrVr7vZ4GXTcZWQOH0+iNcLau79FVnA6vrzBtK1bzsh5v2fzU7fQtrEWX+EImpY9w9C5P+3J8lXfpkGbBvpT00FPGA1EPNm5PRq00c2fkDGiBI8/C/F4yRw9mcgHr5C9/wzEYztBZI4sIdawaZdlfblFZA63J6h5MgP4B48m3rAZEEwihjGGRLQV8XipX/QweTPOQPSKOwPJVLcLUJ3ToHUEQmEfMEwyc2Liy8zvyXVnFI+l9ZN3iDfXk4i20LzideL1O4dq41vPkD3u0D2uJ1a3nrb1K8gcWYInM0D2AYey9q5v4M0dhGTm0Lb2AwITjujJ0lXfd7DbBajO6a7PDkWAySgeM7inLynuLx5NfvhsNjzw/xB/FhlDx4Hs+I6re+UB8HjJmTirw3Uk2prZ+MgNFJ1wOZ5Me1WdgvDZFITPBmDzU7dQcPT5NCx9mpaVb+IfGqTwyHM6XJ/qNyYFyyp9teWlMbcLUR3TPdodigF8hSN6tNlgu7ypJzHikpsZfv4v8WTl4i+yHRsalz1LZPkiis/4Dh0FvInH2PjIDeRMnEWgZNcxcdrWL8cYg79oFJH3/8eQM8uIbV1HdMvqVDwV1bdkAiPdLkLtmQbtDsWkqMcBQLxpGwCx+g1EPniVnInH0rziDeqr/sXQs36Ep4NhFYwxbH7qZvyDR5N/2Od2O8+2/95H4WcugEQMTMI+KIKJte52ftXvDHO7ALVn2nSwQxBo9WblFaRi5RsfvYFEcwN4vBSdeAWerFy2PHM7Jh5l/QPXAfaA2OCTv06sYTOb/30Lw+b+hNbV79L0zvP4hwRZc+dVAAw65iKyD5gJQOSDV8kYPh5fnh2eNGPoONb85Ur8Q4O2iUINBBq0fVy/OTOsuwKh8HVAUdHsK073FQwNuV2PUnvh8try0j+7XYTqmDYd7DAYaBWfDo2o0o7u0fZxGrQ75AAxdAxalX40aPs4DVo+7UPrB+Li9We7XY9Se0mDto/ToLWyAAMgXp/u0ap0o0Hbx2nQWtmAEV+GVzx6/qpKOwG3C1B7pkFrZQHGEyjQZgOVjnTnoI/ToLWyAMTj09dDpSMN2j5O3yArC8DE2+Kdzaj2jTGGRNPWj00iHnW7lv7CJOKZnszARm92/utu16L2TIM2iYlFNWhTRESQzMCg1tqlLzW+/eybJOJ6pkz3jQSejNRUPex2IWrPNGitGICJtekISCnk8WflBULh0sxRE4+K1Lz6WnPNwpVu15Tm4sCugxirPkeD1ooDmJg2HfQGb3ZeYd7BJ52Yd/BJi4Cy2vJSvUKA6tf04I9lA9YkjNHBH3rTYcCCYFnlv4NlldPcLkapVNGgtXbsyZqE7tX2vpOBxcGyyr8Fyyr3d7sYpXqaBq21o23WJLSd1h0CnAe8HyyrvCVYVjnU7YKU6inaRmt9uhdrYtFm0YFl3JQBXAVcGiyr/D/g17XlpY1dXnp+wcHAL4C+fLXldHUo8+tq3S4iHWnQWjHsHhUm2tJAZmCQy/UoyAV+DHw1WFb5M+CPteWlbR3NPKfEPwuY4Pz62KXT/B/PHuc7My9Thqe+1AEj4XYB6UqbDqwmnKBNRFsaXK5F7WwocAu2SeH8YFllR1fOrAcmAqcD4TuXROMXP9r88L/ejb7Q2GaaeqvYfq7DLzq1Zxq0VjP229qTaG3SoO2b9gfuwx40O6X9xIrq6GLgWuBmbCAEYgm23b00+uKXH2++6fmVsedaY6ald0vud/Ssvn2kl7JxBELhG4F43ozTp2XvP+Nkt+tRnXoe2wd3UfsJc0r8OcBs7N6tAGuB+LAcyf7yIRlHTx/hOcznEW0223v5zK/THZF9oEHrCITC1wLDAxOOHJ47ZfY5btejuuxfwA9ry0ur20+YU+IfBJQCx2P3xtYBZnyRJ/+y6f7jDhrimerp6Brvqj0DZDK/Tvdq94EGrSMQCl8MHJ4xfLwpPOq8r7pdj9orMeBOYH5teema9hPnlPiHA5/D9kSIABsAZozwDLl4asYJ+w/ylPRmsWlqHfPrRrhdRLrSoHUEQuHZwHmSkb22+PTv/EB3dNJSM7aN9pe15aXb2k+cU+LfH5iLPWhWD2wBOC7oHX3OZP/sEXmeMb1ZbJpZyPy6I9wuIl3pwbAdNgPGtDVHTWtks9vFqH2SDZQBy4Nlld8JllXu1B+6ojq6ErgR+BWwDXuALe/52viqrzzRcuedb7bdv6XZbOj1qtNDrdsFpDMN2h22bL8Tb9q62s1CVLcVYQP1g2BZ5bxgWaV3+4SK6qipqI6+C8zHdhszQBDIfuT92AfzHmu+/eH3oo82tpm6ni6qelOcabc3fnrL/0U9Ny1s3WmeuhbDGfdHmHp7I5NubeTON9s+XfaQPzVy8G2NvLrKnrwYSxhm39NEJNor/5V+1Bsb6a80aHdY5/yUWN16Ddr+YTTwF+CtYFnlZ5MnVFRHExXV0TeA7wN3YS83PyZh8N+1JLr0sseaf/fM8th/WmKmuaeKKSn2suSKXJZckcsbX84h4Bc+d6B/p3n+8FobE4s9LL0ilxcuDnDNf1poixv++EaUm0/J4snzA/z6VRu+t70W5YKD/QT8vdLMVdsbG+mvNGgdkZqqVmA1kNO26SMN2v5lIvBosKzy5WBZ5dHJEyqqo9GK6ugLwPewPRiKgdHNMeR3i9pe/eoTLTe/uir231jC9OjR9udWxjmgyMPYwp3/BAVoaDMYY2hsg6JswecBvwciUYhEDX4PbGsxPP5BlIum+ne/gZ5X21sb6o/0YFiSQCh8LnCc+DLWF8/53g9EPPpF1D89AXy/trz07fYT5pT4C4BTgJOwY2CsAxJjCyT38kMyjp081DPDI9Ltz8W8x5qZMcLL1w/L2OnxhlbDnH9EeH9TgoZWwwNnZ1M6wc/HdQkueqSZ1jj88fQs7l4S5YwSH7OCvdYdeCLz697rrY31NxokO/sQ8JpYWzzR3LDe7WJUypwOLA2WVd4dLKvcqadBRXW0rqI6+gC2SaEK2/ww7KM603TdgtbK6xa0/qFmc/yd7uygtMUNFdUx5k7cNSSfXh5j2jAva75tmxi+/lQL9a2GMQUeXrgkh1cvs00OnzQkOKjYw4WPNPPFf0b4YHPKR/fUNtpu0KDd2adNBvHGLdp80L95gIuwB8x+EyyrHJw8saI6uqGiOvoX7MA2H2APmA1+e0NiyzX/af3nja+03fFJfWKfLsXzVE2MGSM8DMvd9c/vziVRPn+QDxFhfJGH/Qs9vL9p57FcfrighZ8dl8ktVW18abqfX83O4icvtu6yrh60kfl1kVRuoL/ToN3ZeuyYB97oltWr3C5G9YpM4GpgRbCs8ofBsspA8sSK6ujHwE3ADdgTHYJAwf8+jq/5WmXLPX96o+2+TZHEuvYr3ZP7345y7uTdt62OyReeW2l7FaxvTFC9OcG4QTsOdr1YG2NkrofQYC+RKHjE3iKpPV+rNqVrHwC0jbadQCj8A2CIN2dQW9HJX/+u6JkLA8064KfAHbXlpTsNAj+nxO8BDgbOBYYBG4EmAc6b4p98ash3fH6m7HGIzaY2w5ibGlnxjVwKsuxH6/bXbS+CKw7NYE1DgksebWZto8EYKDs6gwsOtu24xhhOui/CA2cHKMoW3tsY5/yHm4kl4LbSLI4ak7L22juZXzcvVSsfCDRo2wmEwqcBZwGrik7++iW+3KKxbtekXFEDXAc8VFteutMfyZwSvw97vbMvAvnYcG7N8OKZN91/yHFB37HZfsnp9YpT50vMr/uL20WkM2062NW72+9EN328y0AlasAIAQ8Ai4JllSckT6iojsYqqqOvYIdlvB8YBIxui+O9/fXoa5c/3nzzSx/Fnm+Lm/4yfuvLbheQ7nSPtp1AKOzBtsk1+YvH5gw69uKr3K5J9QnPYIdlXNx+wpwSfx62Owq0W2IAABLtSURBVNip2DPN1gHxkXkS+PIhGcdMHeY51OsRb/vl0oExZouIFDO/ToOiGzRodyMQCp8HzALWFJdec6UnK6fY5ZJU32CAB7HDMi5vP3FOiX8wtuvYLOzg4+sAUzLYU3jZDP9xEwZ7pqThsIxPML/uDLeL6CkiUgicZ4y5dS+XmwV8xxhz+r5sV5sOdm8J4AWIbvlEmw/UdoJtl30vWFb5h2BZ5bDkiRXV0c0V1dG7gR8CbwNjgSHVmxPbvvdM6yM3/Lftjx9tS9T0ftnd8pLbBfSwQuBru5sgkrrB4DVod285Tjev1tXvvu92MarP8WP/WJcHyyqvD5ZV5iVPrKiOrgF+D1wPrMJ2CStctDq+/qqnWv7++0Wtd21oSqRLP+1nujKTiFwkIm+JyFIRuVdEgiKywHnsOREZ48x3l4jcJiILRWSFiMwSkb+KyHsiclcn2zhFRBY723jOeaxIRB51trNQRA52Hp/vrPcFZzvfcFZTDhwgIktE5EZn+/8VkQrgXRHJEpE7RWSZiLwpIsftpo4cZ92LnHk+236eXZbRpoPdC4TCXwcOAjYWn37NVZ7MnCK3a1J91ibg58Ct7a/UO6fEL8Ak4BxglDNvI8Dcib4Dzyjxn1CYJX2yaSphzEaPyLDO2mdFZBLwCHCkMWaTiBQBdwP/NMbcLSLzgDnGmDOdMM3CdpGbA9wLHAW8A7wGXGaMWbKbbQwBFgPHGGNWikiR0378O2CTMeYnInI88BtjzDQRmY9tNz8OyAOqgeHAfsATxpjJznpnAZXAZGe91wCTjDHzRORA4D/YqysfjtN0ICI3AO8aY+5zmiIWAdON6fgioLpH27EqIADQurbmDZdrUX1bMfBboDpYVnlhsKzy078rZ1jGt7FnmN2G/ZsLAtkPvRt7f95jzbdWVEcfb2ozfe5aXAL/6eJBsOOBh4wxm8AeQAOOAP7uTL8XSB7M53Fj9/CWAeuNMcuMMQls2AY72MbhwEvGmJVJ28BZ773OYwuAwSKS70yrNMa0OnVtwPZ93p1F29frrO8+Z33vY089ntBu/pOAMhFZAryA/eLY46DxGrQdext7QMMfef+/b5pEIuUnk6u0FwTuAZYEyypLkydUVEfjFdXRKuzA5Pdg97LGxBL4/7w4uvjyx5tvWbAy9mxfulKviPwnRavefr5wIun+9t97sp00ed3xPax7by9HL8BZxphpzm2MMWaPA+5o0HYgUlPVjL3S6tB409bm2NY177hdk0obU4AngmWVLwbLKg9PnlBRHW2rqI4uAL6L/Xd7CDCqsQ1z08K2l698suXmRatjL8cSJrab9fYaY0wceLqLsy8A5orIYLDtpsAr2OYSgPOB/3azpIXAMSKyf9I2cNZ7vvPYLGwzQv0e1tOA/ZLrSPL6JmD3VNsfEH8auGr7WaMiMr2z4jVo9+x/ON+CzSvfeN3lWlT6OQZ4NVhW+UiwrPLA5AkV1dGmiuro49jAfQ7bdjhiQ5Np+9lLbc9+9z8tv3t7Q/zNhEsHUeKG/zC/rksj2Blj3sG2Ub8oIkuB3wBXAZeKyFvAhcA3u1OPMWYj8GXgYWcbDziT5gOHONspBy7uZD2bgZdF5G0RuXE3s9wKeERkmbONS4wx7UfsuR57QPQtEXnH+X2P9GDYHgRCYcF21RkCbB182tVf9WbnDXW5LJWe4tgrOcyvLS/9pP3EOSX+YcCZ2LbIFuwAR0wf7im+eFrGCeMGeQ5sv0yKfY75dY/28jb7LQ3aTgRC4UOBK4GPcqedOjNwwMzT3K5JpbUW4HfAL2rLS7e2nzinxB8EzsY2P9ThXMtuVtA76lx7pd6Uj70RS5jNPo8MZ36dq80X/YkGbScCoXAm9ohynWTmmOJTvvEt8fmz3a5Lpb1t2H91b6ktL93pumROl7ADsSdH7I+9QnM9wJkH+kJnHuifXZQtKfvPKho3v/FfX39NqtbfGRGpwg5fmexCY8wyN+rpCRq0XRAIhT8PlAKr8md+7jNZY6Yc73ZNqt9YjW1nvLO2vHSnni3OsIzTsH1Oh2C7KEU8glxwsH/KKeN9x+dmSEEKajqQ+XV6RmQP0qDtgkAoXAz8Eljjycr1Dj75Kt2rVT3tfewYCg+3nzCnxO/Htt1+AXu13vVAa7YP72UzMmYeM9b7mSyfBNovty9aY+b1zJ/Vz+yJdakdNGi7KBAKX4AdLOQT3atVKbQQO0rYi+0nzCnxZ2PPdPostjfMWiBWlC2ZXz7Ef+TMkd4j/F7p1mVxE8bM8/yk/s7urEPtSoO2iwKh8BBsm9oayQh4Bp9y1Tc8/sxct+tS/dZTwLdqy0s/aD9hTok/HzjZuRls4CbGFEjul2ZkHDNlqOcQr2fvr9QbT5iI1yNDmV+3tx34VSe0H20XRWqqNmJPYBhu2iLRlo/f6m+jGqm+5UTsGUi7qKiO1ldURx/CXqn3VWyn+mEf15mmHz3f+uQPF7T+fl+u1Bs3PKAhmxq6R7sXAqFwEbatdgNeX7z41G9d6ckM6GAzqseZWPSOj3595pe7Mu+cEv9o4PPAdOyANZsAjhztHXHBwf7Zo/I947q42UOZX6fjeqSABu1eCoTCn8MO7rwqMOHIktwps8/pbBml9oaJx1pNrHXMx7/9woauLuN0CRuP7RI2HtiK7YfLaSHfuLMO8s0ekuMZ0dHyjW1mQe4N9Sd0NF11jwbtXgqEwrnAjdgPccug47801z9o5ESXy1L9SKxh888/+cNF1+3Lsk6XsCnYcQZGkHSl3nMm+yeVTvAdn58pO/0XZowhmmBGxvX1b3a3drV7GrT7IBAKzwIuBVZ684fkFh3/pSvF689yuSzVD8Sb61d4s/NDteWlie6sx7lS70xsl7BCbJewFr8Hz7zp/hnH7e87NuCXXIBtLWZBYbnuzaaSBu0+CITCXuxwdyOBjbkHnzwjEAr3m+sqKXeYRDzetu7Dz6y959uv9tQ655T4M4HPAGcBGdjrmEXzM/FfOi3juKPHeKfHDeHAz+vf6qltql1p0O6jQCi8H3bUnrVAtOjkr1/iyy1K+Xnoqv+Kbv7kjtV3fKVLB8D21pwSfy4wG3uGI9jAHT1ukNx208K2qlRsU+2g3bv2UaSmajV2PNH9ABoWP/G4ScR1EA61T+KR+k/a1i+/MlXrr6iONlZURx8FrsWOuToa+HjFVvNaqrapdtA92m4IhMIZwE+wl7zZmj/zzKOzxhysbV1qr5hEPNG2rub4tfdcs8vZYKkyp8Q/HGitqI7uMoKY6nkatN0UCIVD2DFrVyGSKDrxqxf48oq72m9RKaJbVt+9+k9fvsTtOlTqaNNBN0VqqmqAZ4FRGGPqXnngX4loy54upaHUp2INmz5sW/fh5W7XoVJLg7Zn/BP4BBgab9wcaXjzqYeMSXSre47q/xItTQ3Ny1/77MaKX0XdrkWllgZtD4jUVLUAvwe8QE7rqmWftKxc3NUL26kByMRjsciK176++d+/f9ftWlTqadD2kEhN1Xrshd2GAd6GN59cFN3ySdqOCK9Sq+XjpbdH3nvpXrfrUL1Dg7YHRWqqlgKPYUdTYtvL/3g83tK40d2qVF/Tun75fxsWV347UlOlR6IHCA3anvcY8A4w0rRFovWvPvj3RLSlwe2iVN8Qq9+4qnHp02dGaqq0XXYA0aDtYZGaqhjwJ6AZGBTd8sm2+qqH7zWxaHMni6p+Lt60dXPTey+e3rC4covbtajepUGbApGaqm3Ab4AsIK9t/Ycb6xc//jcTj7W5XJpySTxSV1e/+ImLtj5/p44pMABp0KZIpKbqI+D/sCMn5bSuent141v/+YdJJOKdLKr6mXhzQ0P9649dHd2w8im3a1Hu0KBNoUhN1QfAzdhLRWc1r3h9ZdO7L/zT6Ol4A0aitamp4Y2Ka6Mba+/Sg18DlwZtikVqqt4CbscOwpwRqf7f+801Cys0a/u/RFtzc/0bT/y4bf3yP2rIDmwatL0gUlO1ELgbGAX4Gpc9syRS/fLDevZY/5WItrQ0vPnkDW1rq2+K1FTp+zzA+dwuYAB5HsgB5gKrmt5ZsCzR1tySO/n4L4jHq+9DPxJvaWxoeP2xG9vWLy+P1FRpm7zS0bt6UyAUFuAU4FxgNdCaNXbqmLxpp50rPr0UTn8Qa9yyuW7hg/8Xr9vwa+0rq7bToHVBIBQ+BrgMO8p9s3/ouOKC8FnnezKyC10uTXVDdMvq1XULH/p5orn+zxqyKpkGrUsCofAM4Ers1XTrvXmDcwqPvuA8b6BgpMulqX3Q8sm779W/9uiPScT+pW2yqj0NWhcFQuHxwNWAATaJP8tXcMQXTs0YEpzhcmmqi4xJJCLVLy9qeuf5HwAvaO8CtTsatC4LhMLDgW8Dg7DttuRMPG5yYMIRZ4jXl+FqcWqPEq1N9fVvPP5c29oPfhSpqXrb7XpU36VB2wcEQuF8YB4wHTuAeNRfPLYo/7DPzfVm5w93tzq1O20bVn5Yt+jhJ01r042RmqpP3K5H9W0atH1EIBT2ACcC52DbbbeJL8NbcMQXTs4YOm6mu9Wp7Uw81tb03ouLItUv/wO4J1JTpSOzqU5p0PYxgVD4AOxBsjxgDWACBx0zMWfCUWdoFzB3xRq3bKhf9K8XYlvX3gq8pO2xqqs0aPugQCicB1wCzMQ2JbR58wbn5B0y58SMwaOnulrcAGQS8XjLx8uWNSx58knisVsjNVWr3a5JpRcN2j7KaUo4DjgPaAPWA2QFp4/NmXRcqTcrd4ib9Q0U0W3rVjS88fiS2La1/wQejtRUtbpdk0o/GrR9XCAUHglcAEwCNgBNeH2e/OmnH5k5etIx4vH63a2wf0q0RrY2vvP8Gy0r33gX+IszOJBS+0SDNg04e7eHAhcBAWw3sLivaFRh3vTSU/yFw0pcLbAfMYl4tOWjt5Y0LP33u8SjjwNPRWqqIm7XpdKbBm0aCYTCucBnsb0TGoDNAFljpowKlBw9y5c/5AA360tnxiQS0U2r3m9Y8uR78fqNrwD3R2qq1rpdl+ofNGjTUCAUHgdcDASxYVsPkDl68n45JUfP8hUMHe9ieWnFJOKx6MbatxqXPbsiVrd+FXAPsFR7FKiepEGbpgKhsBeYhh12cQSwBdv/lsxRk0bmHHj0sb6CYRNcLLFPM/FYW9v6D99sfOuZ2njT1jrgceDZSE1Vi9u1qf5HgzbNOYE7FTgb2A/YCmwDyNzvoBHZocPD/kEjJ+mYt5aJtTW3rqle3LjsmY8SLY11QAXwv0hNVaPbtan+S4O2n3ACdwo2cEdhmxO2AHgChdk5B35mauaICYd4snKKXSzTFcYYE2/YtKLl42XvRT6s2kI8ug14FHhV92BVb9Cg7WecHgpTgNOB8UAM2y0sCrYdNzs4baq/aPRk8fmz3as09RItjZvaNqxcFvngldWxuvUxYBPwMPBGpKZKL/2ueo0GbT/lXM1hJHA09sSHDCCCPXhmxOv3Zo07dFzm8ANCvsIRof4y6Hi8pWFDbMuamuaVi1e2rauJYYegfB14EXhfLy2j3KBBOwAEQuEsYCI2cCcBgu0etg1IAPiH7D84a/SkkH/wmJA3t2iseDxe1wreC4loa2O8fsOKtk0fL2/5aOm6eMOmLOzzWw0swO691rlbpRroNGgHmEAoXARMBsJACfZKyHHsnm4LgGQE/Fljpwb9RfuN8uUNHu4JFIzw+LPyXCvaYYzBRFu2xSP162Pb1nzUuvq9j9rWfRgDsnEGTwdeAhYDa7WLluorNGgHsEAonA0cgG3TPQwocCZFsHu8n57X780dHMgYNm64b9DIEb684uGeQMEwjz8zT7ypGVHMxNqa480N6+ORbRvi9ZvWR7eu2RDdsHJTorUxGzuymcGOAbEUeBNYDmzWcFV9kQatAj5t0x0BTMA2L4zHBq/B/iveCjRiQ/jTD434s3y+/CF53tyiXE+gIM+blZfrycrJE392QDweH+LxIB4v4vGAMRhjwBgS8ViiraXJtDVHEq1NTYnWpqZ4c0MkEdnWFG/cGkm0Nnqxl2cPYPe4BdvMsRx4DagBVmubq0oHGrSqQ84pvyOA4UDIuQ3DBu32ABZ27F1uv8WT5kn+gG2f3+/cMpyfXmyIbp/XA2wEVgIfYq8WvB7YosGq0pEGrdorgVA4A8jH/vue6/wcBBQ7t0HY8PQ5Ny82QLcHaZwdB+K2suOMtibn1gBs0uEIVX+iQauUUinmcbsApZTq7zRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxTRolVIqxf4/JRANXPvNMHIAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "RQ5W3ya1L5dd"
      },
      "source": [
        "**04: Quantificar os tipos de drogas investigados?**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 204
        },
        "id": "sYLVQMHIUQj9",
        "outputId": "d1eb4c30-f82c-4ac6-b4fb-9c3d0288549c"
      },
      "source": [
        "# Quantificando as drogas utilizadas\n",
        "dados.droga.drop_duplicates().count()\n",
        "\n",
        "top_five = dados['droga'].value_counts()\n",
        "top_five = top_five.to_frame().reset_index()\n",
        "columns = {'index': 'Drogas', 'droga':'Quantidade'}\n",
        "top_five = top_five.rename(columns=columns)\n",
        "top_five = top_five.head()\n",
        "top_five"
      ],
      "execution_count": 269,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Drogas</th>\n",
              "      <th>Quantidade</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>cacb2b860</td>\n",
              "      <td>1866</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>87d714366</td>\n",
              "      <td>718</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>9f80f3f77</td>\n",
              "      <td>246</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>8b87a7a83</td>\n",
              "      <td>203</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5628cb3ee</td>\n",
              "      <td>202</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      Drogas  Quantidade\n",
              "0  cacb2b860        1866\n",
              "1  87d714366         718\n",
              "2  9f80f3f77         246\n",
              "3  8b87a7a83         203\n",
              "4  5628cb3ee         202"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 269
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 295
        },
        "id": "VDDWUHoGWycG",
        "outputId": "e4a65c91-5ef0-477a-8e0f-e562d8c4ebc6"
      },
      "source": [
        "\n",
        "# Plotando gráfico das top 5 drogas utilizadas.\n",
        "title = 'Top 5 drogas utilizadas'\n",
        "\n",
        "top_five.plot.line(x='Drogas',\n",
        "                  y='Quantidade',  \n",
        "                  title=title, \n",
        "                  rot = 0,\n",
        "                  grid = True,\n",
        "                  legend = True,\n",
        "                  fontsize = 10,\n",
        "                  colormap = 'Dark2')\n",
        "plt.show()"
      ],
      "execution_count": 302,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYoAAAEWCAYAAAB42tAoAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3deXgV5fXA8e/JAgESdoisAoooIiABFBdkUUTUQv1ZK1oRtaWoaBf3ulGV1rZWWsVqrfsKFkUp4oII4oZA2PdN0CD7HoGQ5fz+mDdhuNzc5CY3mSzn8zz3ydx33pk5M5k7Z9Z3RFUxxhhjChMXdADGGGMqNksUxhhjIrJEYYwxJiJLFMYYYyKyRGGMMSYiSxTGGGMiskRhqgQRaSMiKiIJQccSSyKSKSLtXPdLIvKI6z5XRFaVwfQ2iMj5sR6vqdwsUZhicRus/E+eiBz0fb86RtN4SUQOh0wrPhbjrgxEZKaI/NJfpqrJqro+tK6qfq6qHcovOlOdWaIwxeI2WMmqmgx8B1zqK3s9hpP6q39aqppb2hGKx9Z1Y0rIfjymVESkpoj8Q0R+cJ9/iEhN16+PiGSIyB9EZIc7rRGro494EXnMjXc9cHFI/5kiMkZEvgQOAO1E5CwRmSsie93fs3z124rILBHZLyKfiMhTIvKar/9/RWSLG3aWiJzq6zdIRJa7YTeJyO2FxDw6ZJwFp8tEZAxwLjDOHUmNc3VURE4MM64+IpLhun8echSWJSIzXb+LRWSBiOwTke9FZHTIeK4RkY0islNE7g3p11NEvhaRPSKyWUTGiUgN109EZKyIbHPjXiIinSL+00ylZYnClNa9wJlAV6AL0BO4z9f/OKAx0AK4FnhWRCKdMrlJRHaJSLqI/F+Eer8CLgFOB7oDl4epcw0wAkgB9gPvA08AjYDHgfdFpJGr+wYwx/Ub7Yb1+wBoDzQF5gP+o6jngV+ragrQCfg0Qtxhqeq9wOfAKHckNSqKYSf4jvaaA+uBN13vH4FhQH28ZHqjiAwBEJGOwNN489ocb95b+kadC/wO7//XC+gP3OT6DQB6AycB9YArgJ1RzrapJCxRmNK6GnhIVbep6nbgjxy7kb1fVbNU9TO8jfUVhYzrCY5sjO8HXhKRswupewXwD1X9XlV3AX8OU+clVV2mqjl4G7Y1qvqqquao6pvASuBSEWkN9AAeUNXDqvoFMNk/IlV9QVX3q2oWXiLpIiL1XO9soKOI1FXV3ao6v5CYy5Q7vfYGMFNV/+3inqmqS1Q1T1UX4yWQ89wglwNTVHWWm6/7gbz88alquqrOdstrA/Bv37DZeAn4ZEBUdYWqbi6H2TQBsERhSqs5sNH3faMry7dbVX+M0L+Aqs5X1Z1uwzQVb6/9sgjT/T5kvKH8/UPjzB+mheu3S1UPhBvWneZ6VETWicg+YIPr1dj9/T9gELBRRD4TkV6FxFzWxuBtvG/NLxCRM0RkhohsF5G9wEiOxH3UMnT/p52+YU8SkSnulNs+4E/5w6rqp8A44Clgm4g8KyJ1y3b2TFAsUZjS+gE43ve9tSvL10BE6kToH4kCUki/zUCrkPGGG76wOPOH2eTG1VBEavv6+cd9FTAYOB/vNEsbVy4AqjpXVQfjHQm9C7xVSMw/Av5pHBch3qiIyJXAUOByVc329XoD7+iolarWA57hyDI9ahm6+W/kG/ZpvKOu9qpaF/iDb1hU9QlVTQM64p2CuqOk8ZuKzRKFKa03gftEpImINAYeAF4LqfNHEakhIufiXVf4b7gRicjlIpIsInEiMgD4BSGngHzeAm4VkZYi0gC4u4g4pwInichV7uLxz/E2cFNUdSMwDxjt4uwFXOobNgXIwtvbro23Z50fcw0RuVpE6rkN9D58p29CLAR6i0hrd9rqnpD+W4F2RczHMUTkdOBJYIg7/eeXgne0dEhEeuIlvXwTgUtE5Bx3kfohjt4mpLj5yRSRk4EbfdPs4Y5WEvES4CEKn29TyVmiMKX1CN5GdjGwBO9C7yO+/luA3Xh79K8DI1V1ZSHj+g3eHv4e4G/Ar1R1ZiF1/wN8BCxy03wnUpCquhMvSd2Gt8G/E7hEVXe4KlfjXbDd6eKfgJccAF7BO021CVgOzA4Z/TXABnd6ZqQbV7gYprnxLgbSgSkhVf4JXC4iu0XkiUjzE2Iw0AD4wnfn0weu303AQyKyHy+JFxztqOoy4Ga8o47NeP+nDN94b8dLLPvxlvcEX7+6rmw33rLZifc/M1WQ2IuLTFkRkT7Aa6rasqi6FY2ITABWquqDQcdiTNDsiMIYCk6lnOBOew3E20t/N+i4jKkIqlS7OMaUwnF4p68a4Z1+uVFVFwQbkjEVg516MsYYE5GdejLGGBNRhT/11LhxY23Tpk2Jhv3xxx+pU6dO0RXLmcUVHYsrOhZXdKpiXOnp6TtUtUnMglHVCv1JS0vTkpoxY0aJhy1LFld0LK7oWFzRqYpxAfM0htthO/VkjDEmIksUxhhjIrJEYYwxJqIKfzHbGFM5ZGdnk5GRwaFDh8L2r1evHitWrCjnqIpWmeNKSkqiZcuWJCYmlmksliiMMTGRkZFBSkoKbdq0QeTYRn/3799PSkpKAJFFVlnjUlV27txJRkYGbdu2LdNY7NSTMSYmDh06RKNGjcImCRN7IkKjRo0KPYKLJUsUxpiYsSRRvspreVfJRJGVm8PTSz5j1aHdQYdijDGVXpVMFHmax/PLv+T1nSvJU3uXijHVSUZGBoMHD6Z9+/a0a9eOUaNGkZWVVfSAUZg5cyZfffVVwfdnnnmGV1555Zh6GzZsoFOnTlGNe/jw4UycOLHUMcZSlUwUtRJqcHfahaw/vJf31i8OOhxjTDlRVS677DKGDBnCmjVrWLNmDQcPHuTOO++M6XRCE8XIkSMZNmxYTKdRkVTJRAFw2Qmn06ZGXR5N/5CDOdlFD2CMqfQ+/fRTkpKSuO666wCIj49n7NixvPLKK4wbN45Ro0YV1L3kkkuYOXMmADfeeCPdu3fn1FNP5cEHj7yrqk2bNjz44IN069aN0047jZUrV7JhwwaeeeYZxo4dS9euXfn8888ZPXo0jz32GADp6el06dKFLl268NRTTxWMa8OGDZx77rl069aNbt26FSQaVWXUqFF06NCB888/n23bthUMk56eznnnnUdaWhoXXnghmzdvLrNlF0mVvT02TuK4qmEH/rRlLs8v/5JRnfsEHZIx1caD3/yPZbt+OKosNyeX+IT4Eo/z1IbN+eMZl0ass2zZMtLS0o4qq1u3Lm3atCEnJ6fQ4caMGUPDhg3Jzc2lf//+LF68mM6dOwPQuHFj5s+fz7/+9S8ee+wxnnvuOUaOHElycjK33347ANOnTy8Y13XXXce4cePo3bs3d9xxR0F506ZNmTZtGklJSaxZs4ahQ4cyb948Jk2axKpVq1i+fDlbt26lY8eOXH/99WRnZ3PLLbfw3nvv0aRJEyZMmMC9997LCy+8EPWyK60qmygAOtZqxIBWpzBu8QyubN+dxrWSgw7JGFMBvfXWWzz77LPk5OSwefNmli9fXpAoLrvsMgDS0tJ4552Ir2Znz5497Nmzh969ewNwzTXX8MEH3uvLs7OzGTVqFAsXLiQ+Pp7Vq1cDMGvWLIYOHUp8fDzNmzenX79+AKxZs4alS5dywQUXAJCbm0uzZs1iP/PFUKUTBcAful9E/3f/weMLP+FPvYYEHY4x1UK4Pf/yeLCtY8eOx1wI3rdvH1u2bKFRo0YFG2eg4PmDDRs28NhjjzF37lwaNGjA8OHDj3o2oWbNmoB3GivSUUlRxo4dS2pqKosWLSIvL4+kpKSI9VWVU089la+//rrE04yVKnuNIt+J9Zvyiw5n8PqqOazZs63oAYwxlVb//v05cOBAwR1Iubm53HbbbYwaNYq2bduycOFC8vLy+P7775kzZw7gJbA6depQr149tm7dWnAEEElKSgr79+8/prx+/frUr1+fL774AoDXX3+9oN/evXtp1qwZcXFxvPrqq+Tm5gLQu3dvJkyYQG5uLps3b2bGjBkAtG/fnu3btxckiuzsbJYtW1aKpVNyVT5RAPz+9P7UTkhkzLypQYdijClDIsKkSZOYOHEi7du3p1GjRsTFxXHvvfdy9tln07ZtWzp27Mitt95Kt27dADjttNM4/fTTOfnkk7nqqqs4++yzi5zOpZdeyqRJkwouZvu9+OKL3HzzzXTt2hX1vWr6pptu4uWXX6ZLly6sXLmy4KVEP/3pT2nfvj0dO3Zk2LBh9OrVC4AaNWowceJE7rrrLrp06ULXrl2PutOqXMXy5RZl8YnVi4ueWjxTW7xwl36xaU2JxxcrVfFFKWXJ4opOUHEtX748Yv99+/aVUyRHfPnll9q6dWtNT08vtE4QcRVHceMKt9yxFxeVzPWnnEXL5Po8NPd9cvPsITxjqoOzzjqLjRs3Fhw9mJKpNokiKSGRe9IuYtmuzby9bn7Q4RhjTKVRZKIQkRdEZJuILPWVTRCRhe6zQUQWuvI2InLQ1+8Z3zBpIrJERNaKyBMSQOthP2nbma6NW/GX+R9zIPtweU/emCpPfefkTdkrr+VdnCOKl4CB/gJV/bmqdlXVrsDbgP/m4nX5/VR1pK/8aeBXQHv3OWqc5UFEeLDnxWw9sI9nl31e9ADGmGJLSkpi586dlizKibr3URR1m20sFPkcharOEpE24fq5o4IrgH6RxiEizYC6qjrbfX8FGAIUfR9ajPVIbcOg4zvxryWfMfSkHqTWrlveIRhTJbVs2ZKMjAy2b98etv+hQ4fKZaMWrcocV/4b7sqaFCf7u0QxRVU7hZT3Bh5X1e6+esuA1cA+4D5V/VxEugOPqur5rt65wF2qekkh0xsBjABITU1NGz9+fEnmjczMTJKTj30ae2v2Ae7M+Jxzk1vwyybRtewYC4XFFTSLKzoWV3QsruiUJq6+ffum52+XY6I4t0YBbYClYcqfBm7zfa8JNHLdacD3QF2gO/CJr965eImn3G6PDTX6m/9pqxfv1uU7N5d4/CVlt1VGx+KKjsUVnaoYFxXl9lgRSQAuAyb4kk6Wqu503enAOuAkYBPgPz5q6coCc2uXfqQkJvHI3PeDDMMYYyq80tweez6wUlUz8gtEpImIxLvudngXrder6mZgn4ic6a5rDAPeK8W0S61Bzdr8tms/PvthDTMyVgUZijHGVGjFuT32TeBroIOIZIjIDa7XlcCbIdV7A4vd7bITgZGqusv1uwl4DliLd6RR7heyQ117ci+OT2nEI3OnkpOXG3Q4xhhTIRXnrqehhZQPD1P2Nt7tsuHqzwPK/8pxBDXiE/hD94H8esbrTFiTztUdegYdkjHGVDjV5snswgw6vhM9U9vw2IKPycyO7Xt1jTGmKqj2iUJEuL/HxWw/mMnTSz4LOhxjjKlwqn2iADi9SSsGt+vCv5d+zg8/7g06HGOMqVAsUTh3d7sQRflr+kdBh2KMMRWKJQqnVUpDrj/lbN5et4AlOwJ9xMMYYyoUSxQ+t3TpS4OatXl47vvWsJkxxjiWKHzq1kji96efz1db1vPJ9yuCDscYYyoESxQhru7QkxPqNeGReR+QbQ/hGWOMJYpQiXHx3Nf9Itbt3c7rq+YEHY4xxgTOEkUY57c6hV7HtePxBZ+w7/ChoMMxxphAWaIIQ0R4oMfF7M46wLjFM4IOxxhjAmWJohCnNW7B/51wOs8v/5Lv9+8qegBjjKmiLFFEcGfahQjCo/PtITxjTPVliSKC5nXq8etO5/Le+kUs2P590OEYY0wgLFEU4cbTzqNJrWQemjPFHsIzxlRLliiKkJxYk9tOv4C52zYydePSoMMxxphyZ4miGK5s350O9VP507wPOZybE3Q4xhhTrixRFENCXDz39RjExv07eWXl7KDDMcaYcmWJopj6tuzAec3bM3bhdHZnHQg6HGOMKTeWKKJwX4+L2Z99iCcWfRp0KMYYU24sUUThlIbH8fP23Xlpxdd8u29H0OEYY0y5KDJRiMgLIrJNRJb6ykaLyCYRWeg+g3z97hGRtSKySkQu9JUPdGVrReTu2M9K+bj99AtIjIvnz/M+DDoUY4wpF8U5ongJGBimfKyqdnWfqQAi0hG4EjjVDfMvEYkXkXjgKeAioCMw1NWtdFJr1+XG03ozdeNS5mzdEHQ4xhhT5opMFKo6CyhuY0eDgfGqmqWq3wJrgZ7us1ZV16vqYWC8q1sp/frU3qTWrstDc+xNeMaYqk+Ks6ETkTbAFFXt5L6PBoYD+4B5wG2qultExgGzVfU1V+954AM3moGq+ktXfg1whqqOKmR6I4ARAKmpqWnjx48v0cxlZmaSnJxcomGLMmt/Bs/uWMrNTbrQK7lZhYmrNCyu6Fhc0bG4olOauPr27Zuuqt1jFoyqFvkB2gBLfd9TgXi8I5IxwAuufBzwC1+954HL3ec5X/k1wLjiTDstLU1LasaMGSUetii5ebk64N1/6Blv/VkPZh+OatiyjKs0LK7oWFzRsbiiU5q4gHlajO1rcT8luutJVbeqaq6q5gH/wTu1BLAJaOWr2tKVFVZeacVJHA/0uJiMzD28sOKroMMxxpgyU6JEISL+cy0/BfLviJoMXCkiNUWkLdAemAPMBdqLSFsRqYF3wXtyycOuGM5ufiL9W57Mk4s+ZeehzKDDMcaYMlGc22PfBL4GOohIhojcAPxVRJaIyGKgL/A7AFVdBrwFLAc+BG52Rx45wCjgI2AF8JarW+nd12MQB3KyeXzB9KBDMcaYMpFQVAVVHRqm+PkI9cfgXbcILZ8KTI0qukqgff2mXN2hJ6+t+obrO57FCfWaBB2SMcbElD2ZHQO/73o+tRISGTO3yuVBY4yxRBELjWslM6pzXz7+fgVfbV4XdDjGGBNTlihi5Jcdz6ZFnfo8PHcqeZoXdDjGGBMzlihiJCkhkbvTBrJk5ybeWbcg6HCMMSZmLFHE0OB2nenSuCWPpn/EwZzDQYdjjDExYYkihvIfwttyYB//WfZF0OEYY0xMWKKIsTOOa8vA1qfy1OKZbDuwP+hwjDGm1CxRlIE/dL+IrNwc/r5gWtChGGNMqVmiKAPt6jXm2lN68eaauazcvSXocIwxplQsUZSR33bpR0piTR6xh/CMMZWcJYoy0iCpDrd26cfMTav5bNPqoMMxxpgSs0RRhoafchbHpzTk4blTyc2zh/CMMZWTJYoyVDM+gXvSBrJy9xbeWpsedDjGGFMilijK2MVtTqN70+P52/yP+TE7K+hwjDEmapYoypiIcH+Pi9l2cD9PL50VdDjGGBM1SxTlIK1pa37StjPPLJnF5h/3Bh2OMcZExRJFObk7bSB5msff5n8cdCjGGBMVSxTlpHVKQ67reDb/XTufjVn7gg7HGGOKzRJFObq1c1/q16zFG7tWoapBh2OMMcViiaIc1atZi9917c+yQzv5NGNV0OEYY0yxFJkoROQFEdkmIkt9ZX8TkZUislhEJolIfVfeRkQOishC93nGN0yaiCwRkbUi8oSISNnMUsV2zclnclxibR6ZO5WcvNygwzHGmCIV54jiJWBgSNk0oJOqdgZWA/f4+q1T1a7uM9JX/jTwK6C9+4SOs1pIjItnaIMOrNm7jTdWzw06HGOMKVKRiUJVZwG7Qso+VtUc93U20DLSOESkGVBXVWerd3L+FWBIyUKu/LrVbsoZqW35+4Jp7D98KOhwjDEmIinORVURaQNMUdVOYfr9D5igqq+5esvwjjL2Afep6uci0h14VFXPd8OcC9ylqpcUMr0RwAiA1NTUtPHjx0c/Z0BmZibJycklGrYsZWZmsi0xlwd++JpL67Xj5w1PCjokoGIvL4ur+Cyu6FTFuPr27Zuuqt1jFoyqFvkB2gBLw5TfC0ziSMKpCTRy3WnA90BdoDvwiW+4c/EST5HTTktL05KaMWNGiYctS/lx3fLZeG338r2asX93sAE5FX15VTQWV3QsruiUJi5gnhZj+1rcT4nvehKR4cAlwNUuMFQ1S1V3uu50YB1wErCJo09PtXRl1drd3S4E4NH0DwOOxBhjCleiRCEiA4E7gZ+o6gFfeRMRiXfd7fAuWq9X1c3APhE5093tNAx4r9TRV3LNk+sz4tRzmbR+IQu3fx90OMYYE1Zxbo99E/ga6CAiGSJyAzAOSAGmhdwG2xtYLCILgYnASFXNvxB+E/AcsBbvSOOD2M5K5XRz5z40Tkrm4bnv20N4xpgKKaGoCqo6NEzx84XUfRt4u5B+84BjLoZXd8mJNbnt9PO55+t3+fC7ZVx0vC0iY0zFYk9mVwBDT+rBSfWbMmbuBxzOzSl6AGOMKUeWKCqAhLh47u0+iA37d/Lqqm+CDscYY45iiaKC6NeyA+c2P5GxC6ezJ+tA0QMYY0w5sURRQXhvwhvE3qyDPLloRtDhGGNMAUsUFUjHhs25on0aL674io37dwYdjjHGAJYoKpw7ug0gPi6OP8+zh/CMMRWDJYoK5rjadRnZqTdTNiwhfdvGoMMxxhhLFBXRjZ3OI7VWCn+cYw/hGWOCZ4miAqqdWIM7ug1g/vbvmLJhSdDhGGOqOUsUFdTPTkzjlAbH8ed5H5JlD+EZYwJkiaKCio+L44GeF/Nd5i5eXP5V0OEYY6oxSxQV2LnN29O3RQeeWPwpuw79GHQ4xphqyhJFBXdfj0FkZmcxduH0oEMxxlRTligquA4NUrnqpJ68unI26/duDzocY0w1ZImiErjt9POpGZ/AmHn2Cg9jTPmzRFEJNKmVwqjOffnou+V8vWV90OEYY6oZSxSVxC9PPYdmtevx8Jz3ydO8oMMxxlQjligqiVoJidyVdiGLd25i0vpFQYdjjKlGLFFUIped0JXOjVrwl/QPOZiTHXQ4xphqwhJFJRIncdzf82J++HEvzy//IuhwjDHVhCWKSqbXce24sHVHxi2eyY6DmUGHY4ypBoqVKETkBRHZJiJLfWUNRWSaiKxxfxu4chGRJ0RkrYgsFpFuvmGudfXXiMi1sZ+d6uHe7hdxKCebvy+YFnQoxphqoLhHFC8BA0PK7gamq2p7YLr7DnAR0N59RgBPg5dYgAeBM4CewIP5ycVEp129Jlxz8pm8vnoOq/dsDTocY0wVV6xEoaqzgF0hxYOBl133y8AQX/kr6pkN1BeRZsCFwDRV3aWqu4FpHJt8TDH9rmt/khNr8sjcqUGHYoyp4qS4L8YRkTbAFFXt5L7vUdX6rluA3apaX0SmAI+q6heu33TgLqAPkKSqj7jy+4GDqvpYmGmNwDsaITU1NW38+PElmrnMzEySk5NLNGxZilVcU/Z8y/jdq7j7uO50qtW4wsQVaxZXdCyu6FTFuPr27Zuuqt1jFUtCLEaiqioiMXsVm6o+CzwL0L17d+3Tp0+JxjNz5kxKOmxZilVcZ+aczZeTHue9rAxuvPAy4uNKd29CVV9esWZxRcfiik5Fiqs0W5at7pQS7u82V74JaOWr19KVFVZuSigpIZF70gayYvcWJq6bH3Q4xpgqqjSJYjKQf+fStcB7vvJh7u6nM4G9qroZ+AgYICIN3EXsAa7MlMKlbTvTrUlr/pr+EQeyDwcdjjGmCiru7bFvAl8DHUQkQ0RuAB4FLhCRNcD57jvAVGA9sBb4D3ATgKruAh4G5rrPQ67MlIKI8ECPi9l6cD/PLJ0VdDjGmCqoWNcoVHVoIb36h6mrwM2FjOcF4IViR2eKpXvq8Vzc5jSeXvoZV3XoyXG16wYdkjGmCrEns6uIe9IGkpOXx9/mfxx0KMaYKsYSRRXRpm4jrjulF2+tSWf5rs1Bh2OMqUIsUVQht3bpR72atXhk7lSK+3yMMcYUxRJFFVK/Zm1+26Ufs35Yw4xNq4MOxxhTRViiqGKGnXwmbVIa8cjc98nJyw06HGNMFWCJooqpEZ/AvT0uYvWebYxfPS/ocIwxVYAliipoYOtTOSO1DY8tmMb+w4eCDscYU8lZoqiCRIT7e1zMjkOZPL3ks6DDMcZUcpYoqqiuTVoxpF1X/r3sc37I3BN0OMaYSswSRRV2d9qFAPxlvjWpZYwpOUsUVVjL5Ab8suM5vL1uAYt3ZAQdjjGmkrJEUcWN6tyHRkl1eGju+/YQnjGmRCxRVHEpNZL4fdfzmb3lWz7+bnnQ4RhjKiFLFNXA1R16cmK9JoyZ9wHZ9hCeMSZKliiqgYS4eO7rMYj1+3bw2spvgg7HGFPJWKKoJvq3PJmzm53A4ws/YW/WwaDDMcZUIpYoqon8N+HtyTrIk4tnBB2OMaYSsURRjZzaqDk/O7EbLyz/ku/221tojTHFY4mimrmj2wDiJI5H0z8MOhRjTCVhiaKaaVanHr/udC6Tv11M+rbvgg7HGFMJWKKohm467Tya1krhYXsIzxhTDCVOFCLSQUQW+j77ROS3IjJaRDb5ygf5hrlHRNaKyCoRuTA2s2CiVSexJrd3u4B52zby/salQYdjjKngSpwoVHWVqnZV1a5AGnAAmOR6j83vp6pTAUSkI3AlcCowEPiXiMSXLnxTUj8/sTsnNziOP8/7gKzcnKDDMcZUYLE69dQfWKeqGyPUGQyMV9UsVf0WWAv0jNH0TZTi4+K4v8cgNu7fxcsrvg46HGNMBSaxOEctIi8A81V1nIiMBoYD+4B5wG2qultExgGzVfU1N8zzwAeqOjHM+EYAIwBSU1PTxo8fX6K4MjMzSU5OLtGwZakixfWXLfNYl7WHv7fsjRw8XGHi8qtIy8vP4oqOxRWd0sTVt2/fdFXtHrNgVLVUH6AGsANIdd9TgXi8o5UxwAuufBzwC99wzwOXFzX+tLQ0LakZM2aUeNiyVJHiWrFrs7Z68W59cPbkChWXn8UVHYsrOlUxLmCelnLb7v/E4tTTRXhHE1td4tmqqrmqmgf8hyOnlzYBrXzDtXRlJkAnNziOK9v34OWVs9mS/WPQ4RhjKqBYJIqhwJv5X0Skma/fT4H822omA1eKSE0RaQu0B+bEYPqmlG4//QJqxMUzdusCVu/ZGnQ4xpgKplSJQkTqABcA7/iK/yoiS0RkMdAX+B2Aqi4D3gKWAx8CN6uqtXldATStncJz/a9hf+5hBk0ex5ur59rzFcaYAgmlGVhVf7Eqa/YAABeeSURBVAQahZRdE6H+GLzrFqaCObd5e8a0OIsJORnc8eXbfLF5LY/2+ikpNZKCDs0YEzB7MtsUaJCQxOsDrufObgP437eLGTj5SRbZu7aNqfYsUZijxMfFcWuXfky86Ncczs1hyPtP89yyL+xUlDHVmCUKE1bP1DZ8POQ39G1xEqPnTOG66S+z65DdFWVMdWSJwhSqQc3aPN9/GA+dcSmzNq1hwHv/ZPaW9UGHZYwpZ5YoTEQiwvUdz+a9i28iKT6RKz78D2MXfkJuXl7QoRljyoklClMspzVuwYeDb2Vw2y78fcEnDP3oObYc2Bd0WMaYcmCJwhRbcmJNnuj9cx4/53IW7PieAe/+k08zVgUdljGmjFmiMFEREa5o352pl95C09opDJv2Ig/Pncpha6rcmCrLEoUpkfb1m/K/S25m2Mln8u+ls7hs6r/ZuH9n0GEZY8qAJQpTYrUSEvlTryH8u+/VrN+3nYHvPcGUbxcHHZYxJsYsUZhSu7jNaXz0k1tpXz+VkTPf4O6vJnEwJzvosIwxMWKJwsREq5SGvD3o19x02nm8tuobLvnfOGuJ1pgqwhKFiZnEuHj+0P0iXhtwPTsOZTJo8jjGW0u0xlR6lihMzPVpcRIfD/4NaU1bc/uXbzNq1nj2Hz4UdFjGmBKyRGHKRGrturwx4IajWqJdbC3RGlMpWaIwZSa0JdrB1hKtMZWSJQpT5sK1RLvbWqI1ptKwRGHKRWhLtBdYS7TGVBqWKEy5sZZojamcLFGYcmct0RpTuZQ6UYjIBhFZIiILRWSeK2soItNEZI3728CVi4g8ISJrRWSxiHQr7fRN5RTaEu2F71lLtMZUVLE6ouirql1Vtbv7fjcwXVXbA9Pdd4CLgPbuMwJ4OkbTN5WQvyXaJrWsJVpjKqqyOvU0GHjZdb8MDPGVv6Ke2UB9EWlWRjGYSiJcS7Tf7d8VdFjGGCcWiUKBj0UkXURGuLJUVd3surcAqa67BfC9b9gMV2aqudCWaC9875/WEq0xFYSU9uEnEWmhqptEpCkwDbgFmKyq9X11dqtqAxGZAjyqql+48unAXao6L2ScI/BOTZGampo2fvz4EsWWmZlJcnJyiYYtSxZXZNuzD/DU9kWszdpLv5RWDKnZkoYp9YIO6xgVZXmFsriiUxXj6tu3b7rvUkDpqWrMPsBo4HZgFdDMlTUDVrnufwNDffUL6hX2SUtL05KaMWNGiYctSxZX0Q7n5uiYuVO1xQt36RmvPqyrdm8JOqRjVKTl5WdxRacqxgXM0xhu20t16klE6ohISn43MABYCkwGrnXVrgXec92TgWHu7qczgb165BSVMQX8LdHuyz1sLdEaE6CEUg6fCkwSkfxxvaGqH4rIXOAtEbkB2Ahc4epPBQYBa4EDwHWlnL6p4vq0OIkxLc5ifM733P7l23yxeR1/7jWElBpJQYdmTLVRqkShquuBLmHKdwL9w5QrcHNppmmqnwYJSbzR7waeWjKTxxZMY+H27/lXn6F0btwy6NCMqRbsyWxTKfhbos2ylmiNKVeWKEylEtoS7fXTX7GWaI0pY5YoTKWT3xLtH8+4lM82reaC9/7JN1u+DTosY6osSxSmUhIRbvC1RPuzD5/lHwunW0u0xpQBSxSmUvO3RPvYgmnWEq0xZcAShan0wrVEO8NaojUmZixRmCohtCXaa6a9yCPWEq0xMWGJwlQp/pZon7GWaI2JCUsUpsoJbYl24OQnmLJhSdBhGVNpWaIwVdbFbU7jo5/cygn1mjByxuvc89UkDuZkBx2WMZWOJQpTpbVKacg7g0Zy02nn8eqqb7h0ylOs2bMt6LCMqVQsUZgqz98S7faD+xn0vyetJVpjomCJwlQbfVqcxMeDf0O3Jq25/cu3uWXWBPYfPhR0WMZUeJYoTLWSWrsubwy4gTu7DWDyt4u4aPKTLN6REXRYxlRolihMtWMt0RoTHUsUptqylmiNKR5LFKZaC22JdsB7T1hLtMaEsERhqj1/S7Q14xOsJVpjQliiMMYJbYn2qo+fZ6u1RGuMJQpj/Pwt0c7f/h0DrCVaYyxRGBOqsJZos/Nygw7NmECUOFGISCsRmSEiy0VkmYj8xpWPFpFNIrLQfQb5hrlHRNaKyCoRuTAWM2BMWTm2JdpnrCVaUy2V5ogiB7hNVTsCZwI3i0hH12+sqnZ1n6kArt+VwKnAQOBfIhJfiukbU+byW6J9pu/VrNtrLdGa6qnEiUJVN6vqfNe9H1gBtIgwyGBgvKpmqeq3wFqgZ0mnb0x5uiRMS7SH8uylSKZ6kFg8jSoibYBZQCfg98BwYB8wD++oY7eIjANmq+prbpjngQ9UdWKY8Y0ARgCkpqamjR8/vkRxZWZmkpycXKJhy5LFFZ2KFFeO5jFx9xqm7PWetaghcdSJS6ROXCK14xKpE59AsvteUB6f6MoSvLJ4rzxByuYSYUVaXn4WV3RKE1ffvn3TVbV7rGJJKO0IRCQZeBv4raruE5GngYcBdX//DlwfzThV9VngWYDu3btrnz59ShTbzJkzKemwZcniik5Fi+t8+vHNlm8ZP/tTGrZoxt6sA+w9fJA9WQfZe/gg27IOsPfgQTKzsyKOp1ZCIvVr1KZezVrUq1GL+iF/69Ws7f563xvU9Lrr1qhFYlzhZ20r2vLKZ3FFpyLFVapEISKJeEnidVV9B0BVt/r6/weY4r5uAlr5Bm/pyoypdM44ri0H659Anx59Cq2Tk5fLvsOH2JN1gD2HD7LXJZK9WQfZ45KLP8Fs3L+roM6BnMMRp18noYYvwRxJKPVr1GLXni18tzLpqCSTn4Dq1kgiIUKSMSacEicKERHgeWCFqj7uK2+mqpvd158CS133ZOANEXkcaA60B+aUdPrGVHQJcfE0TKpDw6Q6UQ97ODeHfYcPuURyoCCZ5CeSgkTjvn+7b0dB0jmUm81/v15T6LhTEmuGJJBjj2pCy+vVrEXdxCTi4+yO+uqoNEcUZwPXAEtEZKEr+wMwVES64p162gD8GkBVl4nIW8ByvDumblZVuzHdmDBqxCfQuFYyjWtFf4562oxP6XJGjyNHL4cjJ5q1e7e5egfJyi38Ar0gpNSoedTpsmMSjDuqCT3aSalRszSLwwSsxIlCVb8AJEyvqRGGGQOMKek0jTFFS5Q4mtZOoWntlKiHPZiTfVRC2es7mgl3+mzLgb0F3w9HeCAxToRE4oh/9VPg6A2Hd3KiqDKJXN99EylmmW/Yw4cPU2PCV6Ucnz++MDFHir2Q+Yk7lE0f+lARlPpitjGm6qiVkEithESOq103quFUlUO52ezOyk8mB44kFXdKbM2362nVqhWKd6elhgxfrLL8YY+6WbN049v8w2aOa3ZcyNhCuvTo6RdaFjKto8rQowsKmZ/8sswdu6koLFEYY0pNRKiVUINaCTVoXqde2Doz982kT88+5RtYMcycOZM+5/QJOoxjzJw5M+gQCtiVKWOMMRFZojDGGBORJQpjjDERWaIwxhgTkSUKY4wxEVmiMMYYE5ElCmOMMRFZojDGGBNRTN5HUZZEZDuwsYSDNwZ2xDCcWLG4omNxRcfiik5VjOt4VW0Sq0AqfKIoDRGZF8uXd8SKxRUdiys6Fld0LK6i2aknY4wxEVmiMMYYE1FVTxTPBh1AISyu6Fhc0bG4omNxFaFKX6MwxhhTelX9iMIYY0wpWaIwxhgTUaVMFCKSWUj530RkpYgsFpFJIlLflQ8XkXGFDPM7EVkmIktF5E0RSXLlIiJjRGS1iKwQkVt95U+IyFo3nW5lNZ+FxScin4vIQvf5QUTeLWTYDSLSWEQ6+OovFJF9IvJbV+dnbvx5InLMrXgi0lpEMkXkdvc9SUTmiMgiN9wffXXDLjPXr4+b9jIR+Sz2Syo8EfmNW3bLfPN8sotlgYicEGEdaCsi37j/9QQRqeHKm7jyBSJyroh86Fsez4hIfJjpRPofTPCVb5Aj76Avr2UUbh3bICKNw9RtLSIz3DwtFpFBrvzqkPnLE5GuRUy3WOuxr36iiLwsIkvc+nWPKy90nSwLbtkscXHP85XfIt72Z5mI/NWVXSAi6a5+uoj089Uf6soXu3XomOXtq9tHRKYU0i/s+hdTqlrpPkBmIeUDgATX/RfgL657ODAuTP0WwLdALff9LWC4674OeAWIc9+bur+DgA/wXnF7JvBNGc5nofH56rwNDCtk+A1A45CyeGAL3gM5AKcAHYCZQPcw45gI/Be43X0XINl1JwLfAGcWsczqA8uB1v7yclhPOgFLgdp4b3P8BDgRuBu4rxjrwFvAla77GeBG130l8JxvOnV9y+Zt3zAF04n0Pwjp93fggfJYPpHmP9y64/o/61sOHYENYeqcBqyLMo5C12NfnauA8a67touxTaR1soyWWbjfVV+3ftUMWfdPB5r71sdNrjsB2JY/HuCvwOgI0+wDTCmkX9j1L5afQI4oRGSYy6KLRORVEbnUt4f2iYikunrJIvKiL+v+n28cY10GnS4iTQBU9WNVzXFVZgMtfZNtJSIzRWSNiDzoK08AaolIAt7K94MrvxF4SFXz3Li3ufLBwCvqmQ3UF5FmsV1CRyksPkSkLtAPeNd9byQiH7vl8hxHv689X3+8H/FGAFVdoaqrwk1YRIbgbUSW5Ze5+c4/okt0n/w7IgpbZlcB76jqdyHlZe0UvER+wK0Xn7lYfgvcKCIzXL1jlrGICN6ynejqvAwMcXvJfwUGuz3KWqq6zzeeGoC6Pe3Q6eQ76n+Qz03zCuDNWC2AYipsHbvT/fbmiMiJrkyB/Bdq1/PV9RsKjM//IiJPi8i8wvb2w6zHPUXka7c9+EpEOvimXcfFWQs4DOwrYp0sLzcCj6pqFhxZx1V1garmL6NleMu5Jt5vU/DmR/CW6Q8AInKi2w4uEpH5InKCG76uiLwvIqvckUOcm8Yx658bzwnuaCPdHb2d7MqbiMjbIjLXfc4ucu7KKutGyIynAqs5kkkbAg04cgfWL4G/u+6/AP/wDdvA/VXgatf9AOGPFv4H/MJ1Dwc2A43wVrCluL1n4DdAJrAdeN03/E7gXmAe3hFEe1c+BTjHV286YfbEY7i8wsbn+g0DJvq+P4HbGwUudsspdM/nBWBUmOnM9M8HkAx87f6Oxh1RuH7xwEIX11+Kscz+ATzlppFOEXuOMVx2p7h1rRHeBvBr4Mkw83PMMsZrPmGtr04rYKlvfRoXMq2PgN3AG0C8KztqOsX4H/QG5pXHsilqHcPba77Xt55Ncd3NgCVAhpvftDDjWwd08n1v6FtvZgKdi1iP63LkzMD5wNuuOxEvAW0HfgRGFLVOltHy+haY79blEa5sIfBHvKOZz4AeYYa7HPgk5Ps+vG3TLN968w3wU9ed5NbdPsAhoJ2b12nA5UWsf9M58hs8A/jUdb+B24YBrYEVRc1zEEcU/YD/quoOAFXdhbfn/5GILAHuwEsm4K0kT+UPqKq7XWceMMF1vwac45+AiNwL5ACv+4qnqepOVT0IvAOcIyIN8I4Q2gLN8bL7L1z9msAh9R6h/w/ej7tcFREfeHtu/r3P3njLA1V9H2/F8Y+vBvATvFNJRRkNjNUje2oFVDVXVbvi/d96ikgn16uwZZYApOElrwuB+0XkpGLEUCqqugJvZ+Nj4EO8H3Ouv04xlnFxp3Uh3ka0Jt46HlYR/4PQ/2eZK2L+3/T97eWL8SVVbYl3GvbV/D1bN74zgAOqutQ3mStEZD6wAO+33TEkjND5rgf8V0SWAmM5sj3oiff/a+7ivU1E2kHEdbIsnKOq3YCLgJtFpDfeOt4Q73T0HcBb7kgBABE5FW9d/LX7noh3FHK6m5/FwD0ikgK0UNVJbr4OqeoBN5o5qrpeVXPxllfBdi90/RORZOAsvOW4EPi36w/ednWcK5+Md6SSHGmGK8rF7Cfx9tBOw1uQSVEOX3CYKSLDgUvwjjg0XB3f9/OBb1V1u6pm4yWQs1z/DPcdYBLQ2XVvwtu7zNfSlZWFQuNzF756Au9HMb6LgPmqurUYdc8A/ioiG/BOofxBREb5K6jqHmAGMNAVFbbMMoCPVPVHt4MwC+gSRdwlpqrPq2qaqvbGS5yrQ6oUtox34p1WTHD1ivw/q+oh4D28DW9hwv4P3HQu48gOUHmJ9BsI9/u5Ae86Bqr6Nd5v1X8R9kp8G30RaQvcDvRX1c5462uSr3+49fhhYIaqdgIu9dW/CvhQVbPVO7XzJXDUDRhh1smYU9VN7u82vPW8J27dV88cvJ3ZxgAi0tLVG6aq69xourpxrHPbqbc4stwLnXSk7yHrXxywR1W7+j6nuKpxeNdw8stbhNsh9AsiUXwK/ExEGgGISEO8PYj8H+G1vrrTgJvzv7i9H/Divtx1XwV84foPBO4EfuLLwvkuEJGGIlILGIK3kn0HnCkitV327w+scPXfxbtABXAeRzYwk4Fh4jkT2Kuqm6NfDMUSKb7L8U4HHPLVn4W3PBCRi/BO6fkVe49VVc9V1Taq2gbv1NGfVHWcO7+ZfzdZLeACYKUbrLBl9h7eEVyCiNTGS0L581GmRKSp+9sab0P8RkiVsMvY/XhncGQ9uxZvPkLHn5x/jcpt7C/myPIIp7D/wfnASlXNKO68xUikdeznvr9f++r3BxCRU/A24tvd9zi8aywF1yfwTiP9COwV79rjRSHTD7ce+7cHw0Ni7eemVQdv731lEetkTIlIHbfXnx/DALxT2QXrvjtargHscHG9D9ytql/6RrUJ6Cju+qqLeYWq7gcyxLs+iIjUdL8Z8I6U2rrl/HPgi8LWP/WuW3wrIj9z/URE8nfOPgZu8c1TxLvTgGDuesL70S0FFgEv4WXA9Xjn/P4GzHT1kvEuIubXvcyVZwKPu/JPgSaufC3wPd4phoXAM658uPtHzgDWAA/6Yvkj3kq1FHiVI3ct5P+Dl+D9SLq4csE7HbbO9Suz6xNFxDcTGBhSt5FbCZbhnfrZyJFrQXXw9pLrhQzzU7y9oSxgK96ef2gMozly11NnvFMIi11MD/jqhV1mrt8deHc+LQV+W47r2uduuovw9mqPmp8ilnE7YI5br/7rKx+Ou0YBpAJzfcvjSY6cXw+dTtj/gev3EjAyoN/jMfOPd43iL26+5gInurod8XayFuH9xgb4xtMHmF3IvK3GO2f+Dr479wpZj3u5+guAR3B3VuFtD/7r1u/lwB1FrZNlsKzauXlf5OLIv45TA++071K86xf9XPl9eIlyoe+Tf0fUSLykvBjvmmojV94eb7u2GG+b2M4t21l4v69VeHfhxRWx/rXFO+W6yC2v/OuXjfGOXBe78meKmm9rwsMYY0xEFeUahTHGmArKEoUxxpiILFEYY4yJyBKFMcaYiCxRGGOMiSih6CrGVD0ikot3G28i3lP8r+A9iZ4XaGDGVECWKEx1dVC9Jh/yH8p7A+/hMH+DkYhIgh5paNKYaslOPZlqT72mGEYAo9wTrMNFZLKIfApMd0/0vyteC8azRaQzFLTCOU1ca70istE1SYGrn+76jXBl8SLyknjvfVgiIr8LbKaNiYIdURgDqOp68V740tQVdcNr5XSXiDwJLFDVIeK9eOYVvLZ6HsRrkfPPrvmYG3yjvN4NWwuYKyJv4707oYV6bRiR3+yEMRWdHVEYE9409Vo2Bq+VzlcBVPVToJF471A4B9eukap+yNGt9d4qIovw3ovSCq9ZhvVAOxF50iWWfRhTCViiMAZwzVXn4r11DLz2eUo6rj54jfz1UtUueO0QJanXTH4XvPaNRgLPlSJkY8qNJQpT7bkWPJ/Ba+gvXONnnwNXu7p9gB3qtc75JV5rqYjIAI601lsP2K2qB8R7q9iZrk5jvNfEvo3XWFyZvm/dmFixaxSmuqrlXtySf3vsq3gtEoczGnhBRBYDBzjSFP4fgTdF5Bq81nK3APvxWuwcKSIr8Fr6nO3qtwBelCMv+rknpnNkTBmx1mONKSHx3n2cq6o5ItILeDr/lltjqhI7ojCm5FrjvfIyDjgM/CrgeIwpE3ZEYYwxJiK7mG2MMSYiSxTGGGMiskRhjDEmIksUxhhjIrJEYYwxJqL/Bw56D+/eMXTKAAAAAElFTkSuQmCC\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "RT8TAMz_0Nzq"
      },
      "source": [
        "**Aplicar metódo query como forma de analisar a funcionalidade**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 439
        },
        "id": "KvYo2b000PHJ",
        "outputId": "d0085dbd-520c-40aa-c180-949544c8d026"
      },
      "source": [
        "dados.query('tempo ==  24')"
      ],
      "execution_count": 322,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>tratamento</th>\n",
              "      <th>tempo</th>\n",
              "      <th>dose</th>\n",
              "      <th>droga</th>\n",
              "      <th>g-0</th>\n",
              "      <th>g-1</th>\n",
              "      <th>g-2</th>\n",
              "      <th>g-3</th>\n",
              "      <th>g-4</th>\n",
              "      <th>g-5</th>\n",
              "      <th>g-6</th>\n",
              "      <th>g-7</th>\n",
              "      <th>g-8</th>\n",
              "      <th>g-9</th>\n",
              "      <th>g-10</th>\n",
              "      <th>g-11</th>\n",
              "      <th>g-12</th>\n",
              "      <th>g-13</th>\n",
              "      <th>g-14</th>\n",
              "      <th>g-15</th>\n",
              "      <th>g-16</th>\n",
              "      <th>g-17</th>\n",
              "      <th>g-18</th>\n",
              "      <th>g-19</th>\n",
              "      <th>g-20</th>\n",
              "      <th>g-21</th>\n",
              "      <th>g-22</th>\n",
              "      <th>g-23</th>\n",
              "      <th>g-24</th>\n",
              "      <th>g-25</th>\n",
              "      <th>g-26</th>\n",
              "      <th>g-27</th>\n",
              "      <th>g-28</th>\n",
              "      <th>g-29</th>\n",
              "      <th>g-30</th>\n",
              "      <th>g-31</th>\n",
              "      <th>g-32</th>\n",
              "      <th>g-33</th>\n",
              "      <th>g-34</th>\n",
              "      <th>...</th>\n",
              "      <th>c-60</th>\n",
              "      <th>c-61</th>\n",
              "      <th>c-62</th>\n",
              "      <th>c-63</th>\n",
              "      <th>c-64</th>\n",
              "      <th>c-65</th>\n",
              "      <th>c-66</th>\n",
              "      <th>c-67</th>\n",
              "      <th>c-68</th>\n",
              "      <th>c-69</th>\n",
              "      <th>c-70</th>\n",
              "      <th>c-71</th>\n",
              "      <th>c-72</th>\n",
              "      <th>c-73</th>\n",
              "      <th>c-74</th>\n",
              "      <th>c-75</th>\n",
              "      <th>c-76</th>\n",
              "      <th>c-77</th>\n",
              "      <th>c-78</th>\n",
              "      <th>c-79</th>\n",
              "      <th>c-80</th>\n",
              "      <th>c-81</th>\n",
              "      <th>c-82</th>\n",
              "      <th>c-83</th>\n",
              "      <th>c-84</th>\n",
              "      <th>c-85</th>\n",
              "      <th>c-86</th>\n",
              "      <th>c-87</th>\n",
              "      <th>c-88</th>\n",
              "      <th>c-89</th>\n",
              "      <th>c-90</th>\n",
              "      <th>c-91</th>\n",
              "      <th>c-92</th>\n",
              "      <th>c-93</th>\n",
              "      <th>c-94</th>\n",
              "      <th>c-95</th>\n",
              "      <th>c-96</th>\n",
              "      <th>c-97</th>\n",
              "      <th>c-98</th>\n",
              "      <th>c-99</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>id_000644bb2</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>b68db1d53</td>\n",
              "      <td>1.0620</td>\n",
              "      <td>0.5577</td>\n",
              "      <td>-0.2479</td>\n",
              "      <td>-0.6208</td>\n",
              "      <td>-0.1944</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>-1.0220</td>\n",
              "      <td>-0.0326</td>\n",
              "      <td>0.5548</td>\n",
              "      <td>-0.0921</td>\n",
              "      <td>1.1830</td>\n",
              "      <td>0.1530</td>\n",
              "      <td>0.5574</td>\n",
              "      <td>-0.4015</td>\n",
              "      <td>0.1789</td>\n",
              "      <td>-0.6528</td>\n",
              "      <td>-0.7969</td>\n",
              "      <td>0.6342</td>\n",
              "      <td>0.1778</td>\n",
              "      <td>-0.3694</td>\n",
              "      <td>-0.5688</td>\n",
              "      <td>-1.1360</td>\n",
              "      <td>-1.1880</td>\n",
              "      <td>0.6940</td>\n",
              "      <td>0.4393</td>\n",
              "      <td>0.2664</td>\n",
              "      <td>0.1907</td>\n",
              "      <td>0.1628</td>\n",
              "      <td>-0.2853</td>\n",
              "      <td>0.5819</td>\n",
              "      <td>0.2934</td>\n",
              "      <td>-0.5584</td>\n",
              "      <td>-0.0916</td>\n",
              "      <td>-0.3010</td>\n",
              "      <td>-0.1537</td>\n",
              "      <td>...</td>\n",
              "      <td>0.4805</td>\n",
              "      <td>0.4965</td>\n",
              "      <td>0.3680</td>\n",
              "      <td>0.8427</td>\n",
              "      <td>0.1042</td>\n",
              "      <td>0.1403</td>\n",
              "      <td>0.1758</td>\n",
              "      <td>1.2570</td>\n",
              "      <td>-0.5979</td>\n",
              "      <td>1.2250</td>\n",
              "      <td>-0.0553</td>\n",
              "      <td>0.7351</td>\n",
              "      <td>0.5810</td>\n",
              "      <td>0.9590</td>\n",
              "      <td>0.2427</td>\n",
              "      <td>0.0495</td>\n",
              "      <td>0.4141</td>\n",
              "      <td>0.8432</td>\n",
              "      <td>0.6162</td>\n",
              "      <td>-0.7318</td>\n",
              "      <td>1.2120</td>\n",
              "      <td>0.6362</td>\n",
              "      <td>-0.4427</td>\n",
              "      <td>0.1288</td>\n",
              "      <td>1.4840</td>\n",
              "      <td>0.1799</td>\n",
              "      <td>0.5367</td>\n",
              "      <td>-0.1111</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>0.6685</td>\n",
              "      <td>0.2862</td>\n",
              "      <td>0.2584</td>\n",
              "      <td>0.8076</td>\n",
              "      <td>0.5523</td>\n",
              "      <td>-0.1912</td>\n",
              "      <td>0.6584</td>\n",
              "      <td>-0.3981</td>\n",
              "      <td>0.2139</td>\n",
              "      <td>0.3801</td>\n",
              "      <td>0.4176</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>id_001762a82</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>e06749542</td>\n",
              "      <td>-0.6111</td>\n",
              "      <td>0.2941</td>\n",
              "      <td>-0.9901</td>\n",
              "      <td>0.2277</td>\n",
              "      <td>1.2810</td>\n",
              "      <td>0.5203</td>\n",
              "      <td>0.0543</td>\n",
              "      <td>-0.2225</td>\n",
              "      <td>-0.1586</td>\n",
              "      <td>0.4289</td>\n",
              "      <td>0.0361</td>\n",
              "      <td>0.3543</td>\n",
              "      <td>0.8310</td>\n",
              "      <td>-0.9129</td>\n",
              "      <td>0.7677</td>\n",
              "      <td>-0.2512</td>\n",
              "      <td>0.7087</td>\n",
              "      <td>0.0481</td>\n",
              "      <td>-0.4486</td>\n",
              "      <td>1.2570</td>\n",
              "      <td>1.2550</td>\n",
              "      <td>0.3359</td>\n",
              "      <td>-0.5103</td>\n",
              "      <td>-0.2993</td>\n",
              "      <td>-1.1950</td>\n",
              "      <td>-0.3208</td>\n",
              "      <td>-0.1187</td>\n",
              "      <td>1.0030</td>\n",
              "      <td>0.9133</td>\n",
              "      <td>0.0376</td>\n",
              "      <td>0.3015</td>\n",
              "      <td>-0.9578</td>\n",
              "      <td>0.5354</td>\n",
              "      <td>1.1360</td>\n",
              "      <td>1.1310</td>\n",
              "      <td>...</td>\n",
              "      <td>0.6701</td>\n",
              "      <td>2.0780</td>\n",
              "      <td>1.3350</td>\n",
              "      <td>0.9889</td>\n",
              "      <td>0.5017</td>\n",
              "      <td>2.0020</td>\n",
              "      <td>0.8918</td>\n",
              "      <td>0.4290</td>\n",
              "      <td>0.0716</td>\n",
              "      <td>0.8465</td>\n",
              "      <td>0.6596</td>\n",
              "      <td>1.3710</td>\n",
              "      <td>1.0580</td>\n",
              "      <td>1.7570</td>\n",
              "      <td>1.0030</td>\n",
              "      <td>0.2152</td>\n",
              "      <td>1.6920</td>\n",
              "      <td>-0.2930</td>\n",
              "      <td>1.4590</td>\n",
              "      <td>1.0950</td>\n",
              "      <td>0.5854</td>\n",
              "      <td>1.7270</td>\n",
              "      <td>0.5580</td>\n",
              "      <td>1.3090</td>\n",
              "      <td>1.0100</td>\n",
              "      <td>0.6980</td>\n",
              "      <td>0.5455</td>\n",
              "      <td>1.0170</td>\n",
              "      <td>1.2910</td>\n",
              "      <td>1.5430</td>\n",
              "      <td>1.8390</td>\n",
              "      <td>1.1570</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>1.9010</td>\n",
              "      <td>1.4270</td>\n",
              "      <td>0.4519</td>\n",
              "      <td>1.2120</td>\n",
              "      <td>0.3765</td>\n",
              "      <td>0.7848</td>\n",
              "      <td>1.3990</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>id_001bd861f</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D2</td>\n",
              "      <td>746ca1f5a</td>\n",
              "      <td>2.0440</td>\n",
              "      <td>1.7000</td>\n",
              "      <td>-1.5390</td>\n",
              "      <td>5.9440</td>\n",
              "      <td>-2.1670</td>\n",
              "      <td>-4.0360</td>\n",
              "      <td>3.6950</td>\n",
              "      <td>1.4530</td>\n",
              "      <td>0.9724</td>\n",
              "      <td>-2.4380</td>\n",
              "      <td>5.1340</td>\n",
              "      <td>-4.6600</td>\n",
              "      <td>5.7960</td>\n",
              "      <td>4.9700</td>\n",
              "      <td>1.5540</td>\n",
              "      <td>2.4790</td>\n",
              "      <td>-3.8010</td>\n",
              "      <td>-1.0230</td>\n",
              "      <td>5.3110</td>\n",
              "      <td>-0.5660</td>\n",
              "      <td>-4.4450</td>\n",
              "      <td>1.2210</td>\n",
              "      <td>1.3750</td>\n",
              "      <td>0.3932</td>\n",
              "      <td>0.3392</td>\n",
              "      <td>4.3510</td>\n",
              "      <td>5.7540</td>\n",
              "      <td>-1.6590</td>\n",
              "      <td>5.3000</td>\n",
              "      <td>5.6050</td>\n",
              "      <td>5.5320</td>\n",
              "      <td>3.7860</td>\n",
              "      <td>0.9197</td>\n",
              "      <td>1.9310</td>\n",
              "      <td>2.4870</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.8904</td>\n",
              "      <td>2.0590</td>\n",
              "      <td>0.5052</td>\n",
              "      <td>0.6890</td>\n",
              "      <td>0.5340</td>\n",
              "      <td>0.5135</td>\n",
              "      <td>0.6507</td>\n",
              "      <td>0.9838</td>\n",
              "      <td>0.4532</td>\n",
              "      <td>-0.3212</td>\n",
              "      <td>0.2662</td>\n",
              "      <td>0.6864</td>\n",
              "      <td>1.6300</td>\n",
              "      <td>1.3810</td>\n",
              "      <td>0.0061</td>\n",
              "      <td>0.2908</td>\n",
              "      <td>0.2598</td>\n",
              "      <td>0.1266</td>\n",
              "      <td>-0.3526</td>\n",
              "      <td>1.1750</td>\n",
              "      <td>-1.1030</td>\n",
              "      <td>1.3650</td>\n",
              "      <td>1.0610</td>\n",
              "      <td>0.4034</td>\n",
              "      <td>1.0880</td>\n",
              "      <td>-0.4230</td>\n",
              "      <td>0.4013</td>\n",
              "      <td>0.1726</td>\n",
              "      <td>0.7464</td>\n",
              "      <td>0.9418</td>\n",
              "      <td>0.1855</td>\n",
              "      <td>1.1720</td>\n",
              "      <td>0.8325</td>\n",
              "      <td>0.6486</td>\n",
              "      <td>0.8090</td>\n",
              "      <td>1.5880</td>\n",
              "      <td>2.4670</td>\n",
              "      <td>0.0357</td>\n",
              "      <td>0.1351</td>\n",
              "      <td>-0.3179</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>id_0031dd989</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D2</td>\n",
              "      <td>96b9ac123</td>\n",
              "      <td>-0.4764</td>\n",
              "      <td>-0.5513</td>\n",
              "      <td>1.8560</td>\n",
              "      <td>-0.2618</td>\n",
              "      <td>-0.3310</td>\n",
              "      <td>-0.9612</td>\n",
              "      <td>0.4863</td>\n",
              "      <td>-0.0016</td>\n",
              "      <td>0.7438</td>\n",
              "      <td>0.2910</td>\n",
              "      <td>-0.6689</td>\n",
              "      <td>-1.4810</td>\n",
              "      <td>2.6120</td>\n",
              "      <td>-0.4991</td>\n",
              "      <td>0.7944</td>\n",
              "      <td>0.0863</td>\n",
              "      <td>0.1186</td>\n",
              "      <td>0.9520</td>\n",
              "      <td>0.7175</td>\n",
              "      <td>0.1592</td>\n",
              "      <td>0.7757</td>\n",
              "      <td>-0.2172</td>\n",
              "      <td>0.3885</td>\n",
              "      <td>0.0115</td>\n",
              "      <td>1.2140</td>\n",
              "      <td>1.1120</td>\n",
              "      <td>-0.9593</td>\n",
              "      <td>0.6762</td>\n",
              "      <td>0.3141</td>\n",
              "      <td>-0.8370</td>\n",
              "      <td>-0.2764</td>\n",
              "      <td>1.8360</td>\n",
              "      <td>0.4373</td>\n",
              "      <td>-0.1574</td>\n",
              "      <td>-1.3220</td>\n",
              "      <td>...</td>\n",
              "      <td>0.5968</td>\n",
              "      <td>0.0590</td>\n",
              "      <td>0.9950</td>\n",
              "      <td>0.5613</td>\n",
              "      <td>0.9197</td>\n",
              "      <td>0.4971</td>\n",
              "      <td>0.3617</td>\n",
              "      <td>0.1428</td>\n",
              "      <td>-0.6113</td>\n",
              "      <td>-0.7031</td>\n",
              "      <td>0.6656</td>\n",
              "      <td>0.2473</td>\n",
              "      <td>0.6499</td>\n",
              "      <td>0.1502</td>\n",
              "      <td>0.5858</td>\n",
              "      <td>0.3250</td>\n",
              "      <td>-0.8120</td>\n",
              "      <td>-0.8011</td>\n",
              "      <td>-0.7457</td>\n",
              "      <td>-0.4241</td>\n",
              "      <td>0.2077</td>\n",
              "      <td>-0.0393</td>\n",
              "      <td>0.1799</td>\n",
              "      <td>0.4427</td>\n",
              "      <td>1.0110</td>\n",
              "      <td>0.8037</td>\n",
              "      <td>-0.0167</td>\n",
              "      <td>0.4888</td>\n",
              "      <td>0.6246</td>\n",
              "      <td>0.4411</td>\n",
              "      <td>-0.4718</td>\n",
              "      <td>1.0620</td>\n",
              "      <td>0.3601</td>\n",
              "      <td>0.4402</td>\n",
              "      <td>0.2655</td>\n",
              "      <td>0.5741</td>\n",
              "      <td>0.8093</td>\n",
              "      <td>-0.0269</td>\n",
              "      <td>0.4259</td>\n",
              "      <td>0.9279</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>id_006e27d96</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D2</td>\n",
              "      <td>808cb9eea</td>\n",
              "      <td>0.0549</td>\n",
              "      <td>0.2602</td>\n",
              "      <td>1.6680</td>\n",
              "      <td>0.0603</td>\n",
              "      <td>-0.3156</td>\n",
              "      <td>0.3733</td>\n",
              "      <td>0.8216</td>\n",
              "      <td>0.2614</td>\n",
              "      <td>-0.2959</td>\n",
              "      <td>-0.6601</td>\n",
              "      <td>-0.2911</td>\n",
              "      <td>-0.6416</td>\n",
              "      <td>0.4660</td>\n",
              "      <td>-1.6660</td>\n",
              "      <td>-0.9087</td>\n",
              "      <td>0.0857</td>\n",
              "      <td>-0.2296</td>\n",
              "      <td>-0.3963</td>\n",
              "      <td>-0.1919</td>\n",
              "      <td>0.0664</td>\n",
              "      <td>0.8645</td>\n",
              "      <td>-0.3914</td>\n",
              "      <td>-0.2941</td>\n",
              "      <td>0.2530</td>\n",
              "      <td>0.4741</td>\n",
              "      <td>0.0369</td>\n",
              "      <td>0.8243</td>\n",
              "      <td>0.1756</td>\n",
              "      <td>0.3598</td>\n",
              "      <td>0.2285</td>\n",
              "      <td>-0.1091</td>\n",
              "      <td>-0.0181</td>\n",
              "      <td>0.4631</td>\n",
              "      <td>-0.3700</td>\n",
              "      <td>-0.5516</td>\n",
              "      <td>...</td>\n",
              "      <td>0.3294</td>\n",
              "      <td>-1.2490</td>\n",
              "      <td>-1.0080</td>\n",
              "      <td>-0.1963</td>\n",
              "      <td>-1.5560</td>\n",
              "      <td>0.5306</td>\n",
              "      <td>-0.8311</td>\n",
              "      <td>0.3223</td>\n",
              "      <td>0.3583</td>\n",
              "      <td>-0.5219</td>\n",
              "      <td>-0.9115</td>\n",
              "      <td>0.5118</td>\n",
              "      <td>-1.3270</td>\n",
              "      <td>0.0223</td>\n",
              "      <td>0.1380</td>\n",
              "      <td>-0.4484</td>\n",
              "      <td>-1.3550</td>\n",
              "      <td>-0.9543</td>\n",
              "      <td>0.5938</td>\n",
              "      <td>-0.9862</td>\n",
              "      <td>-0.2432</td>\n",
              "      <td>-0.8455</td>\n",
              "      <td>0.3119</td>\n",
              "      <td>-0.3904</td>\n",
              "      <td>-0.5096</td>\n",
              "      <td>0.0203</td>\n",
              "      <td>-0.7539</td>\n",
              "      <td>0.9720</td>\n",
              "      <td>-0.6325</td>\n",
              "      <td>1.0530</td>\n",
              "      <td>0.0946</td>\n",
              "      <td>0.0294</td>\n",
              "      <td>0.1041</td>\n",
              "      <td>-0.1413</td>\n",
              "      <td>-1.5430</td>\n",
              "      <td>-1.4180</td>\n",
              "      <td>0.0691</td>\n",
              "      <td>0.1536</td>\n",
              "      <td>0.2948</td>\n",
              "      <td>-0.9860</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23802</th>\n",
              "      <td>id_fff3976bd</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>87d714366</td>\n",
              "      <td>3.2890</td>\n",
              "      <td>2.1270</td>\n",
              "      <td>0.9770</td>\n",
              "      <td>2.0490</td>\n",
              "      <td>2.3170</td>\n",
              "      <td>-0.5355</td>\n",
              "      <td>-0.6357</td>\n",
              "      <td>-6.9060</td>\n",
              "      <td>-4.4830</td>\n",
              "      <td>-2.8400</td>\n",
              "      <td>-5.3310</td>\n",
              "      <td>0.6547</td>\n",
              "      <td>-2.2080</td>\n",
              "      <td>3.6030</td>\n",
              "      <td>0.6380</td>\n",
              "      <td>-2.1280</td>\n",
              "      <td>-3.1680</td>\n",
              "      <td>-4.2180</td>\n",
              "      <td>-0.3170</td>\n",
              "      <td>0.2140</td>\n",
              "      <td>-1.7660</td>\n",
              "      <td>-1.9700</td>\n",
              "      <td>-1.4820</td>\n",
              "      <td>-1.3710</td>\n",
              "      <td>-0.2628</td>\n",
              "      <td>-0.5276</td>\n",
              "      <td>-2.4160</td>\n",
              "      <td>-0.4638</td>\n",
              "      <td>-3.8630</td>\n",
              "      <td>-0.8880</td>\n",
              "      <td>-1.9850</td>\n",
              "      <td>2.0530</td>\n",
              "      <td>-1.4700</td>\n",
              "      <td>-3.3220</td>\n",
              "      <td>1.8800</td>\n",
              "      <td>...</td>\n",
              "      <td>-9.9170</td>\n",
              "      <td>-4.0200</td>\n",
              "      <td>-6.7560</td>\n",
              "      <td>-9.9170</td>\n",
              "      <td>-4.1240</td>\n",
              "      <td>-8.5110</td>\n",
              "      <td>-5.7500</td>\n",
              "      <td>-8.4760</td>\n",
              "      <td>-6.9470</td>\n",
              "      <td>-4.7650</td>\n",
              "      <td>-9.7690</td>\n",
              "      <td>-5.7900</td>\n",
              "      <td>-9.9170</td>\n",
              "      <td>-5.7450</td>\n",
              "      <td>-2.3570</td>\n",
              "      <td>-9.1190</td>\n",
              "      <td>-4.5980</td>\n",
              "      <td>-8.7760</td>\n",
              "      <td>-7.7980</td>\n",
              "      <td>-4.1620</td>\n",
              "      <td>-6.1510</td>\n",
              "      <td>-5.7400</td>\n",
              "      <td>-6.8700</td>\n",
              "      <td>-9.1000</td>\n",
              "      <td>-3.3360</td>\n",
              "      <td>-6.6420</td>\n",
              "      <td>-2.2750</td>\n",
              "      <td>-3.4720</td>\n",
              "      <td>-6.2670</td>\n",
              "      <td>-6.3980</td>\n",
              "      <td>-8.6300</td>\n",
              "      <td>-8.1490</td>\n",
              "      <td>-6.2900</td>\n",
              "      <td>-8.0970</td>\n",
              "      <td>-8.7330</td>\n",
              "      <td>-2.3780</td>\n",
              "      <td>-8.4480</td>\n",
              "      <td>-4.4550</td>\n",
              "      <td>-5.7930</td>\n",
              "      <td>-3.7000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23804</th>\n",
              "      <td>id_fff506720</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>74515bfd2</td>\n",
              "      <td>-1.0140</td>\n",
              "      <td>0.1709</td>\n",
              "      <td>-0.4291</td>\n",
              "      <td>1.8750</td>\n",
              "      <td>0.9859</td>\n",
              "      <td>0.3009</td>\n",
              "      <td>0.0650</td>\n",
              "      <td>-1.3920</td>\n",
              "      <td>-1.0410</td>\n",
              "      <td>1.4790</td>\n",
              "      <td>-0.4459</td>\n",
              "      <td>0.7377</td>\n",
              "      <td>-0.0037</td>\n",
              "      <td>-0.0995</td>\n",
              "      <td>-0.2393</td>\n",
              "      <td>-1.1670</td>\n",
              "      <td>-0.9359</td>\n",
              "      <td>1.1260</td>\n",
              "      <td>0.3450</td>\n",
              "      <td>-1.0780</td>\n",
              "      <td>2.7230</td>\n",
              "      <td>0.5255</td>\n",
              "      <td>0.6368</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>-0.1172</td>\n",
              "      <td>0.8256</td>\n",
              "      <td>0.2120</td>\n",
              "      <td>2.1500</td>\n",
              "      <td>0.5925</td>\n",
              "      <td>-0.7637</td>\n",
              "      <td>0.1157</td>\n",
              "      <td>0.0919</td>\n",
              "      <td>-0.5855</td>\n",
              "      <td>-0.6233</td>\n",
              "      <td>-0.7982</td>\n",
              "      <td>...</td>\n",
              "      <td>-1.1130</td>\n",
              "      <td>0.6549</td>\n",
              "      <td>-1.0250</td>\n",
              "      <td>-2.6910</td>\n",
              "      <td>-0.6001</td>\n",
              "      <td>-1.3260</td>\n",
              "      <td>-1.5960</td>\n",
              "      <td>-0.3137</td>\n",
              "      <td>-0.4209</td>\n",
              "      <td>-0.9542</td>\n",
              "      <td>-1.4760</td>\n",
              "      <td>-1.0180</td>\n",
              "      <td>-1.1360</td>\n",
              "      <td>0.1523</td>\n",
              "      <td>-1.0130</td>\n",
              "      <td>-0.4065</td>\n",
              "      <td>0.8502</td>\n",
              "      <td>-0.0978</td>\n",
              "      <td>-0.7339</td>\n",
              "      <td>-0.5680</td>\n",
              "      <td>-0.5700</td>\n",
              "      <td>0.7834</td>\n",
              "      <td>-2.5930</td>\n",
              "      <td>-2.1570</td>\n",
              "      <td>-0.7917</td>\n",
              "      <td>-0.9154</td>\n",
              "      <td>1.5140</td>\n",
              "      <td>-3.1070</td>\n",
              "      <td>-0.2346</td>\n",
              "      <td>-0.2662</td>\n",
              "      <td>-0.6730</td>\n",
              "      <td>0.3175</td>\n",
              "      <td>-1.5510</td>\n",
              "      <td>-1.2800</td>\n",
              "      <td>-0.7632</td>\n",
              "      <td>-0.6736</td>\n",
              "      <td>-0.4097</td>\n",
              "      <td>0.2282</td>\n",
              "      <td>-0.3213</td>\n",
              "      <td>-0.0836</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23809</th>\n",
              "      <td>id_fffb1ceed</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D2</td>\n",
              "      <td>df1d0a5a1</td>\n",
              "      <td>0.1394</td>\n",
              "      <td>-0.0636</td>\n",
              "      <td>-0.1112</td>\n",
              "      <td>-0.5080</td>\n",
              "      <td>-0.4713</td>\n",
              "      <td>0.7201</td>\n",
              "      <td>0.5773</td>\n",
              "      <td>0.3055</td>\n",
              "      <td>-0.4726</td>\n",
              "      <td>0.1269</td>\n",
              "      <td>0.2531</td>\n",
              "      <td>0.1730</td>\n",
              "      <td>-0.4532</td>\n",
              "      <td>-1.0790</td>\n",
              "      <td>0.2474</td>\n",
              "      <td>-0.4550</td>\n",
              "      <td>0.3588</td>\n",
              "      <td>0.1600</td>\n",
              "      <td>-0.7362</td>\n",
              "      <td>-0.1103</td>\n",
              "      <td>0.8550</td>\n",
              "      <td>-0.4139</td>\n",
              "      <td>0.5541</td>\n",
              "      <td>0.2310</td>\n",
              "      <td>-0.5573</td>\n",
              "      <td>-0.4397</td>\n",
              "      <td>-0.9260</td>\n",
              "      <td>-0.2424</td>\n",
              "      <td>-0.6686</td>\n",
              "      <td>0.2326</td>\n",
              "      <td>0.6456</td>\n",
              "      <td>0.0136</td>\n",
              "      <td>-0.5141</td>\n",
              "      <td>-0.6320</td>\n",
              "      <td>0.7166</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0807</td>\n",
              "      <td>0.4024</td>\n",
              "      <td>-0.0895</td>\n",
              "      <td>0.4420</td>\n",
              "      <td>0.9641</td>\n",
              "      <td>-0.1846</td>\n",
              "      <td>-0.0014</td>\n",
              "      <td>0.3154</td>\n",
              "      <td>-0.2071</td>\n",
              "      <td>-0.6158</td>\n",
              "      <td>-0.2977</td>\n",
              "      <td>0.0992</td>\n",
              "      <td>0.6838</td>\n",
              "      <td>0.5259</td>\n",
              "      <td>0.7882</td>\n",
              "      <td>0.3119</td>\n",
              "      <td>-0.7697</td>\n",
              "      <td>0.2203</td>\n",
              "      <td>-1.0710</td>\n",
              "      <td>0.5979</td>\n",
              "      <td>0.0848</td>\n",
              "      <td>-0.2555</td>\n",
              "      <td>0.6293</td>\n",
              "      <td>1.1660</td>\n",
              "      <td>0.3329</td>\n",
              "      <td>0.2754</td>\n",
              "      <td>0.4108</td>\n",
              "      <td>-0.1252</td>\n",
              "      <td>-0.2340</td>\n",
              "      <td>0.2267</td>\n",
              "      <td>0.1969</td>\n",
              "      <td>0.0262</td>\n",
              "      <td>-0.8121</td>\n",
              "      <td>0.3434</td>\n",
              "      <td>0.5372</td>\n",
              "      <td>-0.3246</td>\n",
              "      <td>0.0631</td>\n",
              "      <td>0.9171</td>\n",
              "      <td>0.5258</td>\n",
              "      <td>0.4680</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23810</th>\n",
              "      <td>id_fffb70c0c</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D2</td>\n",
              "      <td>ecf3b6b74</td>\n",
              "      <td>-1.3260</td>\n",
              "      <td>0.3478</td>\n",
              "      <td>-0.3743</td>\n",
              "      <td>0.9905</td>\n",
              "      <td>-0.7178</td>\n",
              "      <td>0.6621</td>\n",
              "      <td>-0.2252</td>\n",
              "      <td>-0.5565</td>\n",
              "      <td>0.5112</td>\n",
              "      <td>0.6727</td>\n",
              "      <td>-0.1851</td>\n",
              "      <td>2.8650</td>\n",
              "      <td>-0.2140</td>\n",
              "      <td>-0.6153</td>\n",
              "      <td>0.8362</td>\n",
              "      <td>0.5584</td>\n",
              "      <td>-0.2589</td>\n",
              "      <td>0.1292</td>\n",
              "      <td>0.0148</td>\n",
              "      <td>0.0949</td>\n",
              "      <td>-0.2182</td>\n",
              "      <td>-0.9235</td>\n",
              "      <td>0.0749</td>\n",
              "      <td>-1.5910</td>\n",
              "      <td>-0.8359</td>\n",
              "      <td>-0.9217</td>\n",
              "      <td>0.3013</td>\n",
              "      <td>0.1716</td>\n",
              "      <td>0.0880</td>\n",
              "      <td>0.1842</td>\n",
              "      <td>0.1835</td>\n",
              "      <td>0.5436</td>\n",
              "      <td>-0.0533</td>\n",
              "      <td>-0.0491</td>\n",
              "      <td>0.9543</td>\n",
              "      <td>...</td>\n",
              "      <td>0.1410</td>\n",
              "      <td>1.2640</td>\n",
              "      <td>-0.8663</td>\n",
              "      <td>0.8129</td>\n",
              "      <td>-0.1514</td>\n",
              "      <td>-0.4652</td>\n",
              "      <td>-0.7390</td>\n",
              "      <td>-1.3270</td>\n",
              "      <td>0.9925</td>\n",
              "      <td>1.0570</td>\n",
              "      <td>-0.3355</td>\n",
              "      <td>-0.2555</td>\n",
              "      <td>0.8219</td>\n",
              "      <td>0.6995</td>\n",
              "      <td>-0.2942</td>\n",
              "      <td>0.2408</td>\n",
              "      <td>-0.7781</td>\n",
              "      <td>-0.0929</td>\n",
              "      <td>-0.0329</td>\n",
              "      <td>0.0781</td>\n",
              "      <td>-1.4440</td>\n",
              "      <td>-0.0921</td>\n",
              "      <td>0.3188</td>\n",
              "      <td>-1.1080</td>\n",
              "      <td>0.4895</td>\n",
              "      <td>-0.2144</td>\n",
              "      <td>1.0960</td>\n",
              "      <td>0.3335</td>\n",
              "      <td>0.4444</td>\n",
              "      <td>-1.1130</td>\n",
              "      <td>0.4286</td>\n",
              "      <td>0.4426</td>\n",
              "      <td>0.0423</td>\n",
              "      <td>-0.3195</td>\n",
              "      <td>-0.8086</td>\n",
              "      <td>-0.9798</td>\n",
              "      <td>-0.2084</td>\n",
              "      <td>-0.1224</td>\n",
              "      <td>-0.2715</td>\n",
              "      <td>0.3689</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23812</th>\n",
              "      <td>id_fffcb9e7c</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>8b87a7a83</td>\n",
              "      <td>0.6660</td>\n",
              "      <td>0.2324</td>\n",
              "      <td>0.4392</td>\n",
              "      <td>0.2044</td>\n",
              "      <td>0.8531</td>\n",
              "      <td>-0.0343</td>\n",
              "      <td>0.0323</td>\n",
              "      <td>0.0463</td>\n",
              "      <td>0.4299</td>\n",
              "      <td>-0.7985</td>\n",
              "      <td>0.5742</td>\n",
              "      <td>0.1421</td>\n",
              "      <td>2.2700</td>\n",
              "      <td>0.2046</td>\n",
              "      <td>0.5363</td>\n",
              "      <td>-1.7330</td>\n",
              "      <td>0.1450</td>\n",
              "      <td>0.6097</td>\n",
              "      <td>0.2024</td>\n",
              "      <td>0.9865</td>\n",
              "      <td>-0.7805</td>\n",
              "      <td>0.9608</td>\n",
              "      <td>0.3440</td>\n",
              "      <td>2.7650</td>\n",
              "      <td>0.4925</td>\n",
              "      <td>0.6698</td>\n",
              "      <td>0.2374</td>\n",
              "      <td>-0.3372</td>\n",
              "      <td>0.8771</td>\n",
              "      <td>-2.6560</td>\n",
              "      <td>-0.2000</td>\n",
              "      <td>-0.2043</td>\n",
              "      <td>0.6797</td>\n",
              "      <td>-0.0248</td>\n",
              "      <td>-0.0927</td>\n",
              "      <td>...</td>\n",
              "      <td>0.3360</td>\n",
              "      <td>-0.6136</td>\n",
              "      <td>0.5011</td>\n",
              "      <td>0.9261</td>\n",
              "      <td>0.4419</td>\n",
              "      <td>0.0295</td>\n",
              "      <td>0.4220</td>\n",
              "      <td>0.4677</td>\n",
              "      <td>-0.1184</td>\n",
              "      <td>0.4524</td>\n",
              "      <td>0.4135</td>\n",
              "      <td>0.1356</td>\n",
              "      <td>-0.5801</td>\n",
              "      <td>0.0411</td>\n",
              "      <td>1.0240</td>\n",
              "      <td>1.0340</td>\n",
              "      <td>-0.0270</td>\n",
              "      <td>-0.4194</td>\n",
              "      <td>0.7403</td>\n",
              "      <td>-0.6793</td>\n",
              "      <td>-0.1423</td>\n",
              "      <td>0.7307</td>\n",
              "      <td>0.7946</td>\n",
              "      <td>-0.0650</td>\n",
              "      <td>0.9038</td>\n",
              "      <td>0.2324</td>\n",
              "      <td>0.9676</td>\n",
              "      <td>1.0940</td>\n",
              "      <td>0.4290</td>\n",
              "      <td>0.5187</td>\n",
              "      <td>-0.1105</td>\n",
              "      <td>0.4258</td>\n",
              "      <td>-0.2012</td>\n",
              "      <td>0.1506</td>\n",
              "      <td>1.5230</td>\n",
              "      <td>0.7101</td>\n",
              "      <td>0.1732</td>\n",
              "      <td>0.7015</td>\n",
              "      <td>-0.6290</td>\n",
              "      <td>0.0740</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>7772 rows × 877 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                 id tratamento  tempo dose  ...    c-96    c-97    c-98    c-99\n",
              "0      id_000644bb2  com_droga     24   D1  ... -0.3981  0.2139  0.3801  0.4176\n",
              "5      id_001762a82  com_droga     24   D1  ...  1.2120  0.3765  0.7848  1.3990\n",
              "6      id_001bd861f  com_droga     24   D2  ...  2.4670  0.0357  0.1351 -0.3179\n",
              "17     id_0031dd989  com_droga     24   D2  ...  0.8093 -0.0269  0.4259  0.9279\n",
              "32     id_006e27d96  com_droga     24   D2  ...  0.0691  0.1536  0.2948 -0.9860\n",
              "...             ...        ...    ...  ...  ...     ...     ...     ...     ...\n",
              "23802  id_fff3976bd  com_droga     24   D1  ... -8.4480 -4.4550 -5.7930 -3.7000\n",
              "23804  id_fff506720  com_droga     24   D1  ... -0.4097  0.2282 -0.3213 -0.0836\n",
              "23809  id_fffb1ceed  com_droga     24   D2  ...  0.0631  0.9171  0.5258  0.4680\n",
              "23810  id_fffb70c0c  com_droga     24   D2  ... -0.2084 -0.1224 -0.2715  0.3689\n",
              "23812  id_fffcb9e7c  com_droga     24   D1  ...  0.1732  0.7015 -0.6290  0.0740\n",
              "\n",
              "[7772 rows x 877 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 322
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "KJIaaarQ1loi"
      },
      "source": [
        "**Tratando os campos do dataset**\n",
        "\n",
        "Com este método, substituimos o hífen dos campos g-0, g-1, g-n para um 'vázio', normalizando para g0, g1, gn"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 439
        },
        "id": "0TQebA6T1mpb",
        "outputId": "14dc475e-8ee1-4327-e13d-8cd06f2e2e51"
      },
      "source": [
        "dados.columns = dados.columns.str.replace('-', '')\n",
        "dados"
      ],
      "execution_count": 324,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>tratamento</th>\n",
              "      <th>tempo</th>\n",
              "      <th>dose</th>\n",
              "      <th>droga</th>\n",
              "      <th>g0</th>\n",
              "      <th>g1</th>\n",
              "      <th>g2</th>\n",
              "      <th>g3</th>\n",
              "      <th>g4</th>\n",
              "      <th>g5</th>\n",
              "      <th>g6</th>\n",
              "      <th>g7</th>\n",
              "      <th>g8</th>\n",
              "      <th>g9</th>\n",
              "      <th>g10</th>\n",
              "      <th>g11</th>\n",
              "      <th>g12</th>\n",
              "      <th>g13</th>\n",
              "      <th>g14</th>\n",
              "      <th>g15</th>\n",
              "      <th>g16</th>\n",
              "      <th>g17</th>\n",
              "      <th>g18</th>\n",
              "      <th>g19</th>\n",
              "      <th>g20</th>\n",
              "      <th>g21</th>\n",
              "      <th>g22</th>\n",
              "      <th>g23</th>\n",
              "      <th>g24</th>\n",
              "      <th>g25</th>\n",
              "      <th>g26</th>\n",
              "      <th>g27</th>\n",
              "      <th>g28</th>\n",
              "      <th>g29</th>\n",
              "      <th>g30</th>\n",
              "      <th>g31</th>\n",
              "      <th>g32</th>\n",
              "      <th>g33</th>\n",
              "      <th>g34</th>\n",
              "      <th>...</th>\n",
              "      <th>c60</th>\n",
              "      <th>c61</th>\n",
              "      <th>c62</th>\n",
              "      <th>c63</th>\n",
              "      <th>c64</th>\n",
              "      <th>c65</th>\n",
              "      <th>c66</th>\n",
              "      <th>c67</th>\n",
              "      <th>c68</th>\n",
              "      <th>c69</th>\n",
              "      <th>c70</th>\n",
              "      <th>c71</th>\n",
              "      <th>c72</th>\n",
              "      <th>c73</th>\n",
              "      <th>c74</th>\n",
              "      <th>c75</th>\n",
              "      <th>c76</th>\n",
              "      <th>c77</th>\n",
              "      <th>c78</th>\n",
              "      <th>c79</th>\n",
              "      <th>c80</th>\n",
              "      <th>c81</th>\n",
              "      <th>c82</th>\n",
              "      <th>c83</th>\n",
              "      <th>c84</th>\n",
              "      <th>c85</th>\n",
              "      <th>c86</th>\n",
              "      <th>c87</th>\n",
              "      <th>c88</th>\n",
              "      <th>c89</th>\n",
              "      <th>c90</th>\n",
              "      <th>c91</th>\n",
              "      <th>c92</th>\n",
              "      <th>c93</th>\n",
              "      <th>c94</th>\n",
              "      <th>c95</th>\n",
              "      <th>c96</th>\n",
              "      <th>c97</th>\n",
              "      <th>c98</th>\n",
              "      <th>c99</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>id_000644bb2</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>b68db1d53</td>\n",
              "      <td>1.0620</td>\n",
              "      <td>0.5577</td>\n",
              "      <td>-0.2479</td>\n",
              "      <td>-0.6208</td>\n",
              "      <td>-0.1944</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>-1.0220</td>\n",
              "      <td>-0.0326</td>\n",
              "      <td>0.5548</td>\n",
              "      <td>-0.0921</td>\n",
              "      <td>1.1830</td>\n",
              "      <td>0.1530</td>\n",
              "      <td>0.5574</td>\n",
              "      <td>-0.4015</td>\n",
              "      <td>0.1789</td>\n",
              "      <td>-0.6528</td>\n",
              "      <td>-0.7969</td>\n",
              "      <td>0.6342</td>\n",
              "      <td>0.1778</td>\n",
              "      <td>-0.3694</td>\n",
              "      <td>-0.5688</td>\n",
              "      <td>-1.1360</td>\n",
              "      <td>-1.1880</td>\n",
              "      <td>0.6940</td>\n",
              "      <td>0.4393</td>\n",
              "      <td>0.2664</td>\n",
              "      <td>0.1907</td>\n",
              "      <td>0.1628</td>\n",
              "      <td>-0.2853</td>\n",
              "      <td>0.5819</td>\n",
              "      <td>0.2934</td>\n",
              "      <td>-0.5584</td>\n",
              "      <td>-0.0916</td>\n",
              "      <td>-0.3010</td>\n",
              "      <td>-0.1537</td>\n",
              "      <td>...</td>\n",
              "      <td>0.4805</td>\n",
              "      <td>0.4965</td>\n",
              "      <td>0.3680</td>\n",
              "      <td>0.8427</td>\n",
              "      <td>0.1042</td>\n",
              "      <td>0.1403</td>\n",
              "      <td>0.1758</td>\n",
              "      <td>1.2570</td>\n",
              "      <td>-0.5979</td>\n",
              "      <td>1.2250</td>\n",
              "      <td>-0.0553</td>\n",
              "      <td>0.7351</td>\n",
              "      <td>0.5810</td>\n",
              "      <td>0.9590</td>\n",
              "      <td>0.2427</td>\n",
              "      <td>0.0495</td>\n",
              "      <td>0.4141</td>\n",
              "      <td>0.8432</td>\n",
              "      <td>0.6162</td>\n",
              "      <td>-0.7318</td>\n",
              "      <td>1.2120</td>\n",
              "      <td>0.6362</td>\n",
              "      <td>-0.4427</td>\n",
              "      <td>0.1288</td>\n",
              "      <td>1.4840</td>\n",
              "      <td>0.1799</td>\n",
              "      <td>0.5367</td>\n",
              "      <td>-0.1111</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>0.6685</td>\n",
              "      <td>0.2862</td>\n",
              "      <td>0.2584</td>\n",
              "      <td>0.8076</td>\n",
              "      <td>0.5523</td>\n",
              "      <td>-0.1912</td>\n",
              "      <td>0.6584</td>\n",
              "      <td>-0.3981</td>\n",
              "      <td>0.2139</td>\n",
              "      <td>0.3801</td>\n",
              "      <td>0.4176</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>id_000779bfc</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D1</td>\n",
              "      <td>df89a8e5a</td>\n",
              "      <td>0.0743</td>\n",
              "      <td>0.4087</td>\n",
              "      <td>0.2991</td>\n",
              "      <td>0.0604</td>\n",
              "      <td>1.0190</td>\n",
              "      <td>0.5207</td>\n",
              "      <td>0.2341</td>\n",
              "      <td>0.3372</td>\n",
              "      <td>-0.4047</td>\n",
              "      <td>0.8507</td>\n",
              "      <td>-1.1520</td>\n",
              "      <td>-0.4201</td>\n",
              "      <td>-0.0958</td>\n",
              "      <td>0.4590</td>\n",
              "      <td>0.0803</td>\n",
              "      <td>0.2250</td>\n",
              "      <td>0.5293</td>\n",
              "      <td>0.2839</td>\n",
              "      <td>-0.3494</td>\n",
              "      <td>0.2883</td>\n",
              "      <td>0.9449</td>\n",
              "      <td>-0.1646</td>\n",
              "      <td>-0.2657</td>\n",
              "      <td>-0.3372</td>\n",
              "      <td>0.3135</td>\n",
              "      <td>-0.4316</td>\n",
              "      <td>0.4773</td>\n",
              "      <td>0.2075</td>\n",
              "      <td>-0.4216</td>\n",
              "      <td>-0.1161</td>\n",
              "      <td>-0.0499</td>\n",
              "      <td>-0.2627</td>\n",
              "      <td>0.9959</td>\n",
              "      <td>-0.2483</td>\n",
              "      <td>0.2655</td>\n",
              "      <td>...</td>\n",
              "      <td>0.4083</td>\n",
              "      <td>0.0319</td>\n",
              "      <td>0.3905</td>\n",
              "      <td>0.7099</td>\n",
              "      <td>0.2912</td>\n",
              "      <td>0.4151</td>\n",
              "      <td>-0.2840</td>\n",
              "      <td>-0.3104</td>\n",
              "      <td>-0.6373</td>\n",
              "      <td>0.2887</td>\n",
              "      <td>-0.0765</td>\n",
              "      <td>0.2539</td>\n",
              "      <td>0.4443</td>\n",
              "      <td>0.5932</td>\n",
              "      <td>0.2031</td>\n",
              "      <td>0.7639</td>\n",
              "      <td>0.5499</td>\n",
              "      <td>-0.3322</td>\n",
              "      <td>-0.0977</td>\n",
              "      <td>0.4329</td>\n",
              "      <td>-0.2782</td>\n",
              "      <td>0.7827</td>\n",
              "      <td>0.5934</td>\n",
              "      <td>0.3402</td>\n",
              "      <td>0.1499</td>\n",
              "      <td>0.4420</td>\n",
              "      <td>0.9366</td>\n",
              "      <td>0.8193</td>\n",
              "      <td>-0.4236</td>\n",
              "      <td>0.3192</td>\n",
              "      <td>-0.4265</td>\n",
              "      <td>0.7543</td>\n",
              "      <td>0.4708</td>\n",
              "      <td>0.0230</td>\n",
              "      <td>0.2957</td>\n",
              "      <td>0.4899</td>\n",
              "      <td>0.1522</td>\n",
              "      <td>0.1241</td>\n",
              "      <td>0.6077</td>\n",
              "      <td>0.7371</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>id_000a6266a</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>18bb41b2c</td>\n",
              "      <td>0.6280</td>\n",
              "      <td>0.5817</td>\n",
              "      <td>1.5540</td>\n",
              "      <td>-0.0764</td>\n",
              "      <td>-0.0323</td>\n",
              "      <td>1.2390</td>\n",
              "      <td>0.1715</td>\n",
              "      <td>0.2155</td>\n",
              "      <td>0.0065</td>\n",
              "      <td>1.2300</td>\n",
              "      <td>-0.4797</td>\n",
              "      <td>-0.5631</td>\n",
              "      <td>-0.0366</td>\n",
              "      <td>-1.8300</td>\n",
              "      <td>0.6057</td>\n",
              "      <td>-0.3278</td>\n",
              "      <td>0.6042</td>\n",
              "      <td>-0.3075</td>\n",
              "      <td>-0.1147</td>\n",
              "      <td>-0.0570</td>\n",
              "      <td>-0.0799</td>\n",
              "      <td>-0.8181</td>\n",
              "      <td>-1.5320</td>\n",
              "      <td>0.2307</td>\n",
              "      <td>0.4901</td>\n",
              "      <td>0.4780</td>\n",
              "      <td>-1.3970</td>\n",
              "      <td>4.6240</td>\n",
              "      <td>-0.0437</td>\n",
              "      <td>1.2870</td>\n",
              "      <td>-1.8530</td>\n",
              "      <td>0.6069</td>\n",
              "      <td>0.4290</td>\n",
              "      <td>0.1783</td>\n",
              "      <td>0.0018</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.5477</td>\n",
              "      <td>-0.7576</td>\n",
              "      <td>-0.0444</td>\n",
              "      <td>0.1894</td>\n",
              "      <td>-0.0014</td>\n",
              "      <td>-2.3640</td>\n",
              "      <td>-0.4682</td>\n",
              "      <td>0.1210</td>\n",
              "      <td>-0.5177</td>\n",
              "      <td>-0.0604</td>\n",
              "      <td>0.1682</td>\n",
              "      <td>-0.4436</td>\n",
              "      <td>0.4963</td>\n",
              "      <td>0.1363</td>\n",
              "      <td>0.3335</td>\n",
              "      <td>0.9760</td>\n",
              "      <td>-0.0427</td>\n",
              "      <td>-0.1235</td>\n",
              "      <td>0.0959</td>\n",
              "      <td>0.0690</td>\n",
              "      <td>-0.9416</td>\n",
              "      <td>-0.7548</td>\n",
              "      <td>-0.1109</td>\n",
              "      <td>-0.6272</td>\n",
              "      <td>0.3019</td>\n",
              "      <td>0.1172</td>\n",
              "      <td>0.1093</td>\n",
              "      <td>-0.3113</td>\n",
              "      <td>0.3019</td>\n",
              "      <td>-0.0873</td>\n",
              "      <td>-0.7250</td>\n",
              "      <td>-0.6297</td>\n",
              "      <td>0.6103</td>\n",
              "      <td>0.0223</td>\n",
              "      <td>-1.3240</td>\n",
              "      <td>-0.3174</td>\n",
              "      <td>-0.6417</td>\n",
              "      <td>-0.2187</td>\n",
              "      <td>-1.4080</td>\n",
              "      <td>0.6931</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>id_0015fd391</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>8c7f86626</td>\n",
              "      <td>-0.5138</td>\n",
              "      <td>-0.2491</td>\n",
              "      <td>-0.2656</td>\n",
              "      <td>0.5288</td>\n",
              "      <td>4.0620</td>\n",
              "      <td>-0.8095</td>\n",
              "      <td>-1.9590</td>\n",
              "      <td>0.1792</td>\n",
              "      <td>-0.1321</td>\n",
              "      <td>-1.0600</td>\n",
              "      <td>-0.8269</td>\n",
              "      <td>-0.3584</td>\n",
              "      <td>-0.8511</td>\n",
              "      <td>-0.5844</td>\n",
              "      <td>-2.5690</td>\n",
              "      <td>0.8183</td>\n",
              "      <td>-0.0532</td>\n",
              "      <td>-0.8554</td>\n",
              "      <td>0.1160</td>\n",
              "      <td>-2.3520</td>\n",
              "      <td>2.1200</td>\n",
              "      <td>-1.1580</td>\n",
              "      <td>-0.7191</td>\n",
              "      <td>-0.8004</td>\n",
              "      <td>-1.4670</td>\n",
              "      <td>-0.0107</td>\n",
              "      <td>-0.8995</td>\n",
              "      <td>0.2406</td>\n",
              "      <td>-0.2479</td>\n",
              "      <td>-1.0890</td>\n",
              "      <td>-0.7575</td>\n",
              "      <td>0.0881</td>\n",
              "      <td>-2.7370</td>\n",
              "      <td>0.8745</td>\n",
              "      <td>0.5787</td>\n",
              "      <td>...</td>\n",
              "      <td>-2.1220</td>\n",
              "      <td>-0.3752</td>\n",
              "      <td>-2.3820</td>\n",
              "      <td>-3.7350</td>\n",
              "      <td>-2.9740</td>\n",
              "      <td>-1.4930</td>\n",
              "      <td>-1.6600</td>\n",
              "      <td>-3.1660</td>\n",
              "      <td>0.2816</td>\n",
              "      <td>-0.2990</td>\n",
              "      <td>-1.1870</td>\n",
              "      <td>-0.5044</td>\n",
              "      <td>-1.7750</td>\n",
              "      <td>-1.6120</td>\n",
              "      <td>-0.9215</td>\n",
              "      <td>-1.0810</td>\n",
              "      <td>-3.0520</td>\n",
              "      <td>-3.4470</td>\n",
              "      <td>-2.7740</td>\n",
              "      <td>-1.8460</td>\n",
              "      <td>-0.5568</td>\n",
              "      <td>-3.3960</td>\n",
              "      <td>-2.9510</td>\n",
              "      <td>-1.1550</td>\n",
              "      <td>-3.2620</td>\n",
              "      <td>-1.5390</td>\n",
              "      <td>-2.4600</td>\n",
              "      <td>-0.9417</td>\n",
              "      <td>-1.5550</td>\n",
              "      <td>0.2431</td>\n",
              "      <td>-2.0990</td>\n",
              "      <td>-0.6441</td>\n",
              "      <td>-5.6300</td>\n",
              "      <td>-1.3780</td>\n",
              "      <td>-0.8632</td>\n",
              "      <td>-1.2880</td>\n",
              "      <td>-1.6210</td>\n",
              "      <td>-0.8784</td>\n",
              "      <td>-0.3876</td>\n",
              "      <td>-0.8154</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>id_001626bd3</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D2</td>\n",
              "      <td>7cbed3131</td>\n",
              "      <td>-0.3254</td>\n",
              "      <td>-0.4009</td>\n",
              "      <td>0.9700</td>\n",
              "      <td>0.6919</td>\n",
              "      <td>1.4180</td>\n",
              "      <td>-0.8244</td>\n",
              "      <td>-0.2800</td>\n",
              "      <td>-0.1498</td>\n",
              "      <td>-0.8789</td>\n",
              "      <td>0.8630</td>\n",
              "      <td>-0.2219</td>\n",
              "      <td>-0.5121</td>\n",
              "      <td>-0.9577</td>\n",
              "      <td>1.1750</td>\n",
              "      <td>0.2042</td>\n",
              "      <td>0.1970</td>\n",
              "      <td>0.1244</td>\n",
              "      <td>-1.7090</td>\n",
              "      <td>-0.3543</td>\n",
              "      <td>-0.5160</td>\n",
              "      <td>-0.3330</td>\n",
              "      <td>-0.2685</td>\n",
              "      <td>0.7649</td>\n",
              "      <td>0.2057</td>\n",
              "      <td>1.3720</td>\n",
              "      <td>0.6835</td>\n",
              "      <td>0.8056</td>\n",
              "      <td>-0.3754</td>\n",
              "      <td>-1.2090</td>\n",
              "      <td>0.2965</td>\n",
              "      <td>-0.0712</td>\n",
              "      <td>0.6389</td>\n",
              "      <td>0.6674</td>\n",
              "      <td>-0.0783</td>\n",
              "      <td>1.1740</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.2274</td>\n",
              "      <td>0.3215</td>\n",
              "      <td>0.1535</td>\n",
              "      <td>-0.4640</td>\n",
              "      <td>-0.5943</td>\n",
              "      <td>0.3973</td>\n",
              "      <td>0.1500</td>\n",
              "      <td>0.5178</td>\n",
              "      <td>0.5159</td>\n",
              "      <td>0.6091</td>\n",
              "      <td>0.1813</td>\n",
              "      <td>-0.4249</td>\n",
              "      <td>0.7832</td>\n",
              "      <td>0.6529</td>\n",
              "      <td>0.5648</td>\n",
              "      <td>0.4817</td>\n",
              "      <td>0.0587</td>\n",
              "      <td>0.5303</td>\n",
              "      <td>0.6376</td>\n",
              "      <td>-0.3966</td>\n",
              "      <td>-1.4950</td>\n",
              "      <td>-0.9625</td>\n",
              "      <td>-0.0541</td>\n",
              "      <td>0.6273</td>\n",
              "      <td>0.4563</td>\n",
              "      <td>0.0698</td>\n",
              "      <td>0.8134</td>\n",
              "      <td>0.1924</td>\n",
              "      <td>0.6054</td>\n",
              "      <td>-0.1824</td>\n",
              "      <td>0.0042</td>\n",
              "      <td>0.0048</td>\n",
              "      <td>0.6670</td>\n",
              "      <td>1.0690</td>\n",
              "      <td>0.5523</td>\n",
              "      <td>-0.3031</td>\n",
              "      <td>0.1094</td>\n",
              "      <td>0.2885</td>\n",
              "      <td>-0.3786</td>\n",
              "      <td>0.7125</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23809</th>\n",
              "      <td>id_fffb1ceed</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D2</td>\n",
              "      <td>df1d0a5a1</td>\n",
              "      <td>0.1394</td>\n",
              "      <td>-0.0636</td>\n",
              "      <td>-0.1112</td>\n",
              "      <td>-0.5080</td>\n",
              "      <td>-0.4713</td>\n",
              "      <td>0.7201</td>\n",
              "      <td>0.5773</td>\n",
              "      <td>0.3055</td>\n",
              "      <td>-0.4726</td>\n",
              "      <td>0.1269</td>\n",
              "      <td>0.2531</td>\n",
              "      <td>0.1730</td>\n",
              "      <td>-0.4532</td>\n",
              "      <td>-1.0790</td>\n",
              "      <td>0.2474</td>\n",
              "      <td>-0.4550</td>\n",
              "      <td>0.3588</td>\n",
              "      <td>0.1600</td>\n",
              "      <td>-0.7362</td>\n",
              "      <td>-0.1103</td>\n",
              "      <td>0.8550</td>\n",
              "      <td>-0.4139</td>\n",
              "      <td>0.5541</td>\n",
              "      <td>0.2310</td>\n",
              "      <td>-0.5573</td>\n",
              "      <td>-0.4397</td>\n",
              "      <td>-0.9260</td>\n",
              "      <td>-0.2424</td>\n",
              "      <td>-0.6686</td>\n",
              "      <td>0.2326</td>\n",
              "      <td>0.6456</td>\n",
              "      <td>0.0136</td>\n",
              "      <td>-0.5141</td>\n",
              "      <td>-0.6320</td>\n",
              "      <td>0.7166</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0807</td>\n",
              "      <td>0.4024</td>\n",
              "      <td>-0.0895</td>\n",
              "      <td>0.4420</td>\n",
              "      <td>0.9641</td>\n",
              "      <td>-0.1846</td>\n",
              "      <td>-0.0014</td>\n",
              "      <td>0.3154</td>\n",
              "      <td>-0.2071</td>\n",
              "      <td>-0.6158</td>\n",
              "      <td>-0.2977</td>\n",
              "      <td>0.0992</td>\n",
              "      <td>0.6838</td>\n",
              "      <td>0.5259</td>\n",
              "      <td>0.7882</td>\n",
              "      <td>0.3119</td>\n",
              "      <td>-0.7697</td>\n",
              "      <td>0.2203</td>\n",
              "      <td>-1.0710</td>\n",
              "      <td>0.5979</td>\n",
              "      <td>0.0848</td>\n",
              "      <td>-0.2555</td>\n",
              "      <td>0.6293</td>\n",
              "      <td>1.1660</td>\n",
              "      <td>0.3329</td>\n",
              "      <td>0.2754</td>\n",
              "      <td>0.4108</td>\n",
              "      <td>-0.1252</td>\n",
              "      <td>-0.2340</td>\n",
              "      <td>0.2267</td>\n",
              "      <td>0.1969</td>\n",
              "      <td>0.0262</td>\n",
              "      <td>-0.8121</td>\n",
              "      <td>0.3434</td>\n",
              "      <td>0.5372</td>\n",
              "      <td>-0.3246</td>\n",
              "      <td>0.0631</td>\n",
              "      <td>0.9171</td>\n",
              "      <td>0.5258</td>\n",
              "      <td>0.4680</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23810</th>\n",
              "      <td>id_fffb70c0c</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D2</td>\n",
              "      <td>ecf3b6b74</td>\n",
              "      <td>-1.3260</td>\n",
              "      <td>0.3478</td>\n",
              "      <td>-0.3743</td>\n",
              "      <td>0.9905</td>\n",
              "      <td>-0.7178</td>\n",
              "      <td>0.6621</td>\n",
              "      <td>-0.2252</td>\n",
              "      <td>-0.5565</td>\n",
              "      <td>0.5112</td>\n",
              "      <td>0.6727</td>\n",
              "      <td>-0.1851</td>\n",
              "      <td>2.8650</td>\n",
              "      <td>-0.2140</td>\n",
              "      <td>-0.6153</td>\n",
              "      <td>0.8362</td>\n",
              "      <td>0.5584</td>\n",
              "      <td>-0.2589</td>\n",
              "      <td>0.1292</td>\n",
              "      <td>0.0148</td>\n",
              "      <td>0.0949</td>\n",
              "      <td>-0.2182</td>\n",
              "      <td>-0.9235</td>\n",
              "      <td>0.0749</td>\n",
              "      <td>-1.5910</td>\n",
              "      <td>-0.8359</td>\n",
              "      <td>-0.9217</td>\n",
              "      <td>0.3013</td>\n",
              "      <td>0.1716</td>\n",
              "      <td>0.0880</td>\n",
              "      <td>0.1842</td>\n",
              "      <td>0.1835</td>\n",
              "      <td>0.5436</td>\n",
              "      <td>-0.0533</td>\n",
              "      <td>-0.0491</td>\n",
              "      <td>0.9543</td>\n",
              "      <td>...</td>\n",
              "      <td>0.1410</td>\n",
              "      <td>1.2640</td>\n",
              "      <td>-0.8663</td>\n",
              "      <td>0.8129</td>\n",
              "      <td>-0.1514</td>\n",
              "      <td>-0.4652</td>\n",
              "      <td>-0.7390</td>\n",
              "      <td>-1.3270</td>\n",
              "      <td>0.9925</td>\n",
              "      <td>1.0570</td>\n",
              "      <td>-0.3355</td>\n",
              "      <td>-0.2555</td>\n",
              "      <td>0.8219</td>\n",
              "      <td>0.6995</td>\n",
              "      <td>-0.2942</td>\n",
              "      <td>0.2408</td>\n",
              "      <td>-0.7781</td>\n",
              "      <td>-0.0929</td>\n",
              "      <td>-0.0329</td>\n",
              "      <td>0.0781</td>\n",
              "      <td>-1.4440</td>\n",
              "      <td>-0.0921</td>\n",
              "      <td>0.3188</td>\n",
              "      <td>-1.1080</td>\n",
              "      <td>0.4895</td>\n",
              "      <td>-0.2144</td>\n",
              "      <td>1.0960</td>\n",
              "      <td>0.3335</td>\n",
              "      <td>0.4444</td>\n",
              "      <td>-1.1130</td>\n",
              "      <td>0.4286</td>\n",
              "      <td>0.4426</td>\n",
              "      <td>0.0423</td>\n",
              "      <td>-0.3195</td>\n",
              "      <td>-0.8086</td>\n",
              "      <td>-0.9798</td>\n",
              "      <td>-0.2084</td>\n",
              "      <td>-0.1224</td>\n",
              "      <td>-0.2715</td>\n",
              "      <td>0.3689</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23811</th>\n",
              "      <td>id_fffc1c3f4</td>\n",
              "      <td>com_controle</td>\n",
              "      <td>48</td>\n",
              "      <td>D2</td>\n",
              "      <td>cacb2b860</td>\n",
              "      <td>0.3942</td>\n",
              "      <td>0.3756</td>\n",
              "      <td>0.3109</td>\n",
              "      <td>-0.7389</td>\n",
              "      <td>0.5505</td>\n",
              "      <td>-0.0159</td>\n",
              "      <td>-0.2541</td>\n",
              "      <td>0.1745</td>\n",
              "      <td>-0.0340</td>\n",
              "      <td>0.4865</td>\n",
              "      <td>-0.1854</td>\n",
              "      <td>0.0716</td>\n",
              "      <td>0.1729</td>\n",
              "      <td>-0.0434</td>\n",
              "      <td>0.1542</td>\n",
              "      <td>-0.2192</td>\n",
              "      <td>-0.0302</td>\n",
              "      <td>-0.4218</td>\n",
              "      <td>0.4057</td>\n",
              "      <td>-0.5372</td>\n",
              "      <td>0.1521</td>\n",
              "      <td>-0.2651</td>\n",
              "      <td>0.2310</td>\n",
              "      <td>-0.8101</td>\n",
              "      <td>0.4943</td>\n",
              "      <td>0.6905</td>\n",
              "      <td>-0.3720</td>\n",
              "      <td>-1.4110</td>\n",
              "      <td>0.4516</td>\n",
              "      <td>1.2300</td>\n",
              "      <td>-0.1949</td>\n",
              "      <td>-1.3280</td>\n",
              "      <td>-0.4276</td>\n",
              "      <td>-0.0040</td>\n",
              "      <td>-0.3086</td>\n",
              "      <td>...</td>\n",
              "      <td>0.6845</td>\n",
              "      <td>0.7127</td>\n",
              "      <td>0.7294</td>\n",
              "      <td>0.4718</td>\n",
              "      <td>-0.2020</td>\n",
              "      <td>0.2783</td>\n",
              "      <td>0.4934</td>\n",
              "      <td>0.4144</td>\n",
              "      <td>0.5449</td>\n",
              "      <td>1.4690</td>\n",
              "      <td>-0.6142</td>\n",
              "      <td>0.6068</td>\n",
              "      <td>0.3434</td>\n",
              "      <td>0.9880</td>\n",
              "      <td>-0.0468</td>\n",
              "      <td>-0.1882</td>\n",
              "      <td>-0.0087</td>\n",
              "      <td>-0.0356</td>\n",
              "      <td>0.5718</td>\n",
              "      <td>0.4971</td>\n",
              "      <td>0.1057</td>\n",
              "      <td>0.2111</td>\n",
              "      <td>0.6992</td>\n",
              "      <td>0.0708</td>\n",
              "      <td>0.6169</td>\n",
              "      <td>0.2248</td>\n",
              "      <td>0.5994</td>\n",
              "      <td>0.2689</td>\n",
              "      <td>0.0305</td>\n",
              "      <td>1.2320</td>\n",
              "      <td>0.5409</td>\n",
              "      <td>0.3755</td>\n",
              "      <td>0.7343</td>\n",
              "      <td>0.2807</td>\n",
              "      <td>0.4116</td>\n",
              "      <td>0.6422</td>\n",
              "      <td>0.2256</td>\n",
              "      <td>0.7592</td>\n",
              "      <td>0.6656</td>\n",
              "      <td>0.3808</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23812</th>\n",
              "      <td>id_fffcb9e7c</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>8b87a7a83</td>\n",
              "      <td>0.6660</td>\n",
              "      <td>0.2324</td>\n",
              "      <td>0.4392</td>\n",
              "      <td>0.2044</td>\n",
              "      <td>0.8531</td>\n",
              "      <td>-0.0343</td>\n",
              "      <td>0.0323</td>\n",
              "      <td>0.0463</td>\n",
              "      <td>0.4299</td>\n",
              "      <td>-0.7985</td>\n",
              "      <td>0.5742</td>\n",
              "      <td>0.1421</td>\n",
              "      <td>2.2700</td>\n",
              "      <td>0.2046</td>\n",
              "      <td>0.5363</td>\n",
              "      <td>-1.7330</td>\n",
              "      <td>0.1450</td>\n",
              "      <td>0.6097</td>\n",
              "      <td>0.2024</td>\n",
              "      <td>0.9865</td>\n",
              "      <td>-0.7805</td>\n",
              "      <td>0.9608</td>\n",
              "      <td>0.3440</td>\n",
              "      <td>2.7650</td>\n",
              "      <td>0.4925</td>\n",
              "      <td>0.6698</td>\n",
              "      <td>0.2374</td>\n",
              "      <td>-0.3372</td>\n",
              "      <td>0.8771</td>\n",
              "      <td>-2.6560</td>\n",
              "      <td>-0.2000</td>\n",
              "      <td>-0.2043</td>\n",
              "      <td>0.6797</td>\n",
              "      <td>-0.0248</td>\n",
              "      <td>-0.0927</td>\n",
              "      <td>...</td>\n",
              "      <td>0.3360</td>\n",
              "      <td>-0.6136</td>\n",
              "      <td>0.5011</td>\n",
              "      <td>0.9261</td>\n",
              "      <td>0.4419</td>\n",
              "      <td>0.0295</td>\n",
              "      <td>0.4220</td>\n",
              "      <td>0.4677</td>\n",
              "      <td>-0.1184</td>\n",
              "      <td>0.4524</td>\n",
              "      <td>0.4135</td>\n",
              "      <td>0.1356</td>\n",
              "      <td>-0.5801</td>\n",
              "      <td>0.0411</td>\n",
              "      <td>1.0240</td>\n",
              "      <td>1.0340</td>\n",
              "      <td>-0.0270</td>\n",
              "      <td>-0.4194</td>\n",
              "      <td>0.7403</td>\n",
              "      <td>-0.6793</td>\n",
              "      <td>-0.1423</td>\n",
              "      <td>0.7307</td>\n",
              "      <td>0.7946</td>\n",
              "      <td>-0.0650</td>\n",
              "      <td>0.9038</td>\n",
              "      <td>0.2324</td>\n",
              "      <td>0.9676</td>\n",
              "      <td>1.0940</td>\n",
              "      <td>0.4290</td>\n",
              "      <td>0.5187</td>\n",
              "      <td>-0.1105</td>\n",
              "      <td>0.4258</td>\n",
              "      <td>-0.2012</td>\n",
              "      <td>0.1506</td>\n",
              "      <td>1.5230</td>\n",
              "      <td>0.7101</td>\n",
              "      <td>0.1732</td>\n",
              "      <td>0.7015</td>\n",
              "      <td>-0.6290</td>\n",
              "      <td>0.0740</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23813</th>\n",
              "      <td>id_ffffdd77b</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D1</td>\n",
              "      <td>972f41291</td>\n",
              "      <td>-0.8598</td>\n",
              "      <td>1.0240</td>\n",
              "      <td>-0.1361</td>\n",
              "      <td>0.7952</td>\n",
              "      <td>-0.3611</td>\n",
              "      <td>-3.6750</td>\n",
              "      <td>-1.2420</td>\n",
              "      <td>0.9146</td>\n",
              "      <td>3.0790</td>\n",
              "      <td>1.2460</td>\n",
              "      <td>1.9460</td>\n",
              "      <td>1.4370</td>\n",
              "      <td>2.9780</td>\n",
              "      <td>2.2370</td>\n",
              "      <td>-0.6818</td>\n",
              "      <td>0.6870</td>\n",
              "      <td>-1.1060</td>\n",
              "      <td>0.0182</td>\n",
              "      <td>-0.9247</td>\n",
              "      <td>-0.0738</td>\n",
              "      <td>-0.1919</td>\n",
              "      <td>-0.7722</td>\n",
              "      <td>-1.4050</td>\n",
              "      <td>-1.0050</td>\n",
              "      <td>-1.1170</td>\n",
              "      <td>-0.5293</td>\n",
              "      <td>-1.1720</td>\n",
              "      <td>-0.2885</td>\n",
              "      <td>0.1599</td>\n",
              "      <td>-0.4250</td>\n",
              "      <td>0.3591</td>\n",
              "      <td>-0.1420</td>\n",
              "      <td>-0.9530</td>\n",
              "      <td>-0.2005</td>\n",
              "      <td>-1.8340</td>\n",
              "      <td>...</td>\n",
              "      <td>-6.9170</td>\n",
              "      <td>-1.8640</td>\n",
              "      <td>-2.5090</td>\n",
              "      <td>-4.7130</td>\n",
              "      <td>-1.7250</td>\n",
              "      <td>-3.8650</td>\n",
              "      <td>-3.0800</td>\n",
              "      <td>-4.1530</td>\n",
              "      <td>-1.2030</td>\n",
              "      <td>-1.1690</td>\n",
              "      <td>-4.1460</td>\n",
              "      <td>-1.2670</td>\n",
              "      <td>-1.1300</td>\n",
              "      <td>-2.4390</td>\n",
              "      <td>0.1591</td>\n",
              "      <td>-2.2490</td>\n",
              "      <td>-2.5860</td>\n",
              "      <td>-1.9520</td>\n",
              "      <td>-2.1810</td>\n",
              "      <td>-4.6690</td>\n",
              "      <td>-3.9450</td>\n",
              "      <td>-2.9560</td>\n",
              "      <td>-2.7930</td>\n",
              "      <td>-2.1560</td>\n",
              "      <td>-2.4100</td>\n",
              "      <td>-1.8190</td>\n",
              "      <td>-3.3480</td>\n",
              "      <td>-0.1414</td>\n",
              "      <td>-2.6430</td>\n",
              "      <td>-2.5810</td>\n",
              "      <td>-3.3890</td>\n",
              "      <td>-1.7450</td>\n",
              "      <td>-6.6300</td>\n",
              "      <td>-4.0950</td>\n",
              "      <td>-7.3860</td>\n",
              "      <td>-1.4160</td>\n",
              "      <td>-3.5770</td>\n",
              "      <td>-0.4775</td>\n",
              "      <td>-2.1500</td>\n",
              "      <td>-4.2520</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>23814 rows × 877 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                 id    tratamento  tempo dose  ...     c96     c97     c98     c99\n",
              "0      id_000644bb2     com_droga     24   D1  ... -0.3981  0.2139  0.3801  0.4176\n",
              "1      id_000779bfc     com_droga     72   D1  ...  0.1522  0.1241  0.6077  0.7371\n",
              "2      id_000a6266a     com_droga     48   D1  ... -0.6417 -0.2187 -1.4080  0.6931\n",
              "3      id_0015fd391     com_droga     48   D1  ... -1.6210 -0.8784 -0.3876 -0.8154\n",
              "4      id_001626bd3     com_droga     72   D2  ...  0.1094  0.2885 -0.3786  0.7125\n",
              "...             ...           ...    ...  ...  ...     ...     ...     ...     ...\n",
              "23809  id_fffb1ceed     com_droga     24   D2  ...  0.0631  0.9171  0.5258  0.4680\n",
              "23810  id_fffb70c0c     com_droga     24   D2  ... -0.2084 -0.1224 -0.2715  0.3689\n",
              "23811  id_fffc1c3f4  com_controle     48   D2  ...  0.2256  0.7592  0.6656  0.3808\n",
              "23812  id_fffcb9e7c     com_droga     24   D1  ...  0.1732  0.7015 -0.6290  0.0740\n",
              "23813  id_ffffdd77b     com_droga     72   D1  ... -3.5770 -0.4775 -2.1500 -4.2520\n",
              "\n",
              "[23814 rows x 877 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 324
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "sERa0Zxv2ccH"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}