respostas_aula01.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "aula01.ipynb",
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 253
        },
        "id": "cnOT_g_euXSf",
        "outputId": "a5304892-2fab-4f3e-f42b-d7d675770400"
      },
      "source": [
        "import pandas as pd\n",
        "\n",
        "url_dados = 'https://github.com/alura-cursos/imersaodados3/blob/main/dados/dados_experimentos.zip?raw=true'\n",
        "\n",
        "dados = pd.read_csv(url_dados, compression = 'zip')\n",
        "\n",
        "dados.head()\n"
      ],
      "execution_count": 49,
      "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>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",
              "  </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",
              "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",
              "[5 rows x 877 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 49
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "CWsNpe-kumlo",
        "outputId": "1ebfc8c2-9ed3-4849-b2c0-35e98de707cc"
      },
      "source": [
        "dados.shape"
      ],
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(23814, 877)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "q55oVwlDgF8U"
      },
      "source": [
        "### Desafios da AULA 01\n",
        "\n",
        "Desafio 01: Investigar por que a classe tratamento é tão desbalanceada?\n",
        "\n",
        "Desafio 02: Plotar as 5 últimas linhas da tabela\n",
        "\n",
        "Desafio 03: Proporção das classes tratamento.\n",
        "\n",
        "Desafio 04: Quantas tipos de drogas foram investigados.\n",
        "\n",
        "Desafio 05: Procurar na documentação o método query(pandas).\n",
        "\n",
        "Desafio 06: Renomear as colunas tirando o hífen.\n",
        "\n",
        "Desafio 07: Deixar os gráficos bonitões. (Matplotlib.pyplot)\n",
        "\n",
        "Desafio 08: Resumo do que você aprendeu com os dados\n",
        "\n",
        "Serão respondidos a seguir. "
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "0N-MRcEpfEuC"
      },
      "source": [
        "# Desafio 02: Plotar as 5 últimas linhas da tabela."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 253
        },
        "id": "BFBH7iJ2dJgs",
        "outputId": "9a4fc7db-1154-430b-e488-ea2223e00bdc"
      },
      "source": [
        "dados.tail()"
      ],
      "execution_count": 4,
      "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": 4
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "HauIhuSDe_Tk"
      },
      "source": [
        "# Desafio 03: Proporção das classes tratamento."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "iwGXjBBKdNBB",
        "outputId": "cc2894ad-861a-4f1b-b604-4c7a2b52b52a"
      },
      "source": [
        "dados['tratamento'].value_counts(normalize = True)"
      ],
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "com_droga       0.921643\n",
              "com_controle    0.078357\n",
              "Name: tratamento, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "slOPd5Pddxaf",
        "outputId": "677e867a-1952-4ca1-8c73-a98423e5f2a4"
      },
      "source": [
        "dados['droga'].unique()\n"
      ],
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array(['b68db1d53', 'df89a8e5a', '18bb41b2c', ..., '573c787a2',\n",
              "       'b2fe3eca7', 'dd4a96d16'], dtype=object)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "UkeXnFaXeuMX"
      },
      "source": [
        "# Desafio 04: Quantos tipos de drogas foram investigados.\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "FBHXesHMeYA_",
        "outputId": "ec0e0d85-9c34-4543-b7c5-bb7e2f8d04f2"
      },
      "source": [
        "dados['droga'].value_counts()"
      ],
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "cacb2b860    1866\n",
              "87d714366     718\n",
              "9f80f3f77     246\n",
              "8b87a7a83     203\n",
              "5628cb3ee     202\n",
              "             ... \n",
              "40b490d82       1\n",
              "809527b9d       1\n",
              "6fbceecd4       1\n",
              "3276db5ea       1\n",
              "57f5932fb       1\n",
              "Name: droga, Length: 3289, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "pYr7criRfL2o"
      },
      "source": [
        "# Desafio 06: Renomear as colunas tirando o hífen.\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "S4siNhOmfRlE",
        "outputId": "856f3d8c-69ea-4618-8f44-98db8d7d7516"
      },
      "source": [
        "dados.columns"
      ],
      "execution_count": 50,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['id', 'tratamento', 'tempo', 'dose', 'droga', 'g-0', 'g-1', 'g-2',\n",
              "       'g-3', 'g-4',\n",
              "       ...\n",
              "       'c-90', 'c-91', 'c-92', 'c-93', 'c-94', 'c-95', 'c-96', 'c-97', 'c-98',\n",
              "       'c-99'],\n",
              "      dtype='object', length=877)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 50
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "N_U1aEXBsGvi",
        "outputId": "a3dfcdd9-7988-47b0-c64e-b272d272e1ac"
      },
      "source": [
        "dados.columns = dados.columns.str.replace('-', '')\n",
        "dados.columns\n"
      ],
      "execution_count": 51,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['id', 'tratamento', 'tempo', 'dose', 'droga', 'g0', 'g1', 'g2', 'g3',\n",
              "       'g4',\n",
              "       ...\n",
              "       'c90', 'c91', 'c92', 'c93', 'c94', 'c95', 'c96', 'c97', 'c98', 'c99'],\n",
              "      dtype='object', length=877)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 51
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "TMmjzxwzg--Z"
      },
      "source": [
        "# Desafio 05: Procurar na documentação método query pandas.\n",
        "\n",
        "https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.query.html?highlight=query%20pandas#pandas.DataFrame.query"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 439
        },
        "id": "oh5QFQhWu4Hm",
        "outputId": "649be432-fcb0-4b9e-b8c5-f8ce4f533251"
      },
      "source": [
        "dados.query('g0 > 0')"
      ],
      "execution_count": 53,
      "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>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>7</th>\n",
              "      <td>id_0020d0484</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>8b87a7a83</td>\n",
              "      <td>0.2711</td>\n",
              "      <td>0.5133</td>\n",
              "      <td>-0.1327</td>\n",
              "      <td>2.5950</td>\n",
              "      <td>0.6980</td>\n",
              "      <td>0.5846</td>\n",
              "      <td>-0.2633</td>\n",
              "      <td>-2.1490</td>\n",
              "      <td>0.4881</td>\n",
              "      <td>1.4750</td>\n",
              "      <td>-0.0488</td>\n",
              "      <td>-0.0561</td>\n",
              "      <td>0.1641</td>\n",
              "      <td>0.1749</td>\n",
              "      <td>-0.3464</td>\n",
              "      <td>-0.1811</td>\n",
              "      <td>0.5685</td>\n",
              "      <td>1.2970</td>\n",
              "      <td>1.0510</td>\n",
              "      <td>-0.9585</td>\n",
              "      <td>0.7911</td>\n",
              "      <td>-0.2991</td>\n",
              "      <td>2.7420</td>\n",
              "      <td>-0.5979</td>\n",
              "      <td>-1.0240</td>\n",
              "      <td>0.7268</td>\n",
              "      <td>0.1590</td>\n",
              "      <td>-1.9730</td>\n",
              "      <td>1.1340</td>\n",
              "      <td>-2.5720</td>\n",
              "      <td>0.2068</td>\n",
              "      <td>0.9992</td>\n",
              "      <td>-0.1958</td>\n",
              "      <td>0.2262</td>\n",
              "      <td>1.0140</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.2623</td>\n",
              "      <td>-0.5500</td>\n",
              "      <td>-0.0530</td>\n",
              "      <td>0.2077</td>\n",
              "      <td>-0.0825</td>\n",
              "      <td>0.2156</td>\n",
              "      <td>0.8142</td>\n",
              "      <td>1.0990</td>\n",
              "      <td>1.0860</td>\n",
              "      <td>0.4011</td>\n",
              "      <td>-0.1342</td>\n",
              "      <td>0.4653</td>\n",
              "      <td>-0.1104</td>\n",
              "      <td>0.3935</td>\n",
              "      <td>1.2370</td>\n",
              "      <td>-0.5072</td>\n",
              "      <td>0.0351</td>\n",
              "      <td>0.5084</td>\n",
              "      <td>-0.1248</td>\n",
              "      <td>0.4351</td>\n",
              "      <td>0.1389</td>\n",
              "      <td>0.6726</td>\n",
              "      <td>0.6070</td>\n",
              "      <td>0.3431</td>\n",
              "      <td>-0.4116</td>\n",
              "      <td>0.1194</td>\n",
              "      <td>0.3420</td>\n",
              "      <td>0.1331</td>\n",
              "      <td>0.8541</td>\n",
              "      <td>0.6282</td>\n",
              "      <td>0.3230</td>\n",
              "      <td>-0.4140</td>\n",
              "      <td>0.2532</td>\n",
              "      <td>0.0513</td>\n",
              "      <td>0.8600</td>\n",
              "      <td>1.4250</td>\n",
              "      <td>0.6633</td>\n",
              "      <td>0.4562</td>\n",
              "      <td>-0.9622</td>\n",
              "      <td>0.0260</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>23807</th>\n",
              "      <td>id_fff7e6992</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>a28556d51</td>\n",
              "      <td>0.1420</td>\n",
              "      <td>-0.3696</td>\n",
              "      <td>-0.0093</td>\n",
              "      <td>-0.2495</td>\n",
              "      <td>-0.0175</td>\n",
              "      <td>0.0959</td>\n",
              "      <td>-0.2201</td>\n",
              "      <td>0.2443</td>\n",
              "      <td>0.4879</td>\n",
              "      <td>0.3432</td>\n",
              "      <td>0.4151</td>\n",
              "      <td>0.9056</td>\n",
              "      <td>0.3538</td>\n",
              "      <td>0.5246</td>\n",
              "      <td>-0.4441</td>\n",
              "      <td>-0.1605</td>\n",
              "      <td>-0.3720</td>\n",
              "      <td>-0.5619</td>\n",
              "      <td>-0.1409</td>\n",
              "      <td>0.1255</td>\n",
              "      <td>0.1214</td>\n",
              "      <td>-0.1975</td>\n",
              "      <td>-0.4367</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.4301</td>\n",
              "      <td>-0.7606</td>\n",
              "      <td>-0.0248</td>\n",
              "      <td>0.0270</td>\n",
              "      <td>-0.0367</td>\n",
              "      <td>-1.2480</td>\n",
              "      <td>0.0559</td>\n",
              "      <td>-0.0984</td>\n",
              "      <td>0.5537</td>\n",
              "      <td>0.1063</td>\n",
              "      <td>0.3893</td>\n",
              "      <td>...</td>\n",
              "      <td>0.5554</td>\n",
              "      <td>0.2225</td>\n",
              "      <td>-0.0903</td>\n",
              "      <td>0.9227</td>\n",
              "      <td>-0.0460</td>\n",
              "      <td>0.3756</td>\n",
              "      <td>1.0730</td>\n",
              "      <td>-0.6904</td>\n",
              "      <td>0.9298</td>\n",
              "      <td>1.0500</td>\n",
              "      <td>0.4646</td>\n",
              "      <td>0.4481</td>\n",
              "      <td>0.9771</td>\n",
              "      <td>0.7187</td>\n",
              "      <td>0.5299</td>\n",
              "      <td>0.1079</td>\n",
              "      <td>1.2010</td>\n",
              "      <td>0.2529</td>\n",
              "      <td>-0.4546</td>\n",
              "      <td>0.7998</td>\n",
              "      <td>0.6401</td>\n",
              "      <td>-1.3370</td>\n",
              "      <td>0.6542</td>\n",
              "      <td>0.8561</td>\n",
              "      <td>0.4829</td>\n",
              "      <td>0.3213</td>\n",
              "      <td>-0.0177</td>\n",
              "      <td>-0.2656</td>\n",
              "      <td>0.4626</td>\n",
              "      <td>0.0030</td>\n",
              "      <td>0.8775</td>\n",
              "      <td>0.5230</td>\n",
              "      <td>0.1589</td>\n",
              "      <td>0.7715</td>\n",
              "      <td>0.5497</td>\n",
              "      <td>0.6929</td>\n",
              "      <td>0.3738</td>\n",
              "      <td>0.8636</td>\n",
              "      <td>0.4494</td>\n",
              "      <td>0.1218</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23808</th>\n",
              "      <td>id_fff8c2444</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D1</td>\n",
              "      <td>6c3a459be</td>\n",
              "      <td>0.1608</td>\n",
              "      <td>-1.0500</td>\n",
              "      <td>0.2551</td>\n",
              "      <td>-0.2239</td>\n",
              "      <td>-0.2431</td>\n",
              "      <td>0.4256</td>\n",
              "      <td>-0.1166</td>\n",
              "      <td>-0.1777</td>\n",
              "      <td>-0.7480</td>\n",
              "      <td>0.1368</td>\n",
              "      <td>0.5493</td>\n",
              "      <td>-0.5083</td>\n",
              "      <td>0.4112</td>\n",
              "      <td>0.1181</td>\n",
              "      <td>0.7861</td>\n",
              "      <td>-0.1877</td>\n",
              "      <td>0.2476</td>\n",
              "      <td>0.1956</td>\n",
              "      <td>0.0273</td>\n",
              "      <td>0.1182</td>\n",
              "      <td>-0.5037</td>\n",
              "      <td>-0.5939</td>\n",
              "      <td>0.4825</td>\n",
              "      <td>-0.5187</td>\n",
              "      <td>0.1618</td>\n",
              "      <td>-0.2253</td>\n",
              "      <td>0.3153</td>\n",
              "      <td>0.4839</td>\n",
              "      <td>0.0520</td>\n",
              "      <td>1.3850</td>\n",
              "      <td>0.6502</td>\n",
              "      <td>-0.4198</td>\n",
              "      <td>0.2723</td>\n",
              "      <td>-0.3629</td>\n",
              "      <td>1.0820</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.2720</td>\n",
              "      <td>-0.6021</td>\n",
              "      <td>0.2451</td>\n",
              "      <td>0.6607</td>\n",
              "      <td>-0.1849</td>\n",
              "      <td>-0.6546</td>\n",
              "      <td>-0.5798</td>\n",
              "      <td>0.3449</td>\n",
              "      <td>-0.6208</td>\n",
              "      <td>0.2949</td>\n",
              "      <td>0.4158</td>\n",
              "      <td>0.8586</td>\n",
              "      <td>0.3868</td>\n",
              "      <td>1.0030</td>\n",
              "      <td>-0.4593</td>\n",
              "      <td>0.6498</td>\n",
              "      <td>0.8293</td>\n",
              "      <td>-0.7645</td>\n",
              "      <td>0.5379</td>\n",
              "      <td>0.5610</td>\n",
              "      <td>0.2577</td>\n",
              "      <td>-0.5493</td>\n",
              "      <td>0.2690</td>\n",
              "      <td>0.6392</td>\n",
              "      <td>-0.5774</td>\n",
              "      <td>-0.3393</td>\n",
              "      <td>0.5068</td>\n",
              "      <td>-0.2005</td>\n",
              "      <td>-0.4559</td>\n",
              "      <td>0.3734</td>\n",
              "      <td>0.0789</td>\n",
              "      <td>0.3538</td>\n",
              "      <td>0.0558</td>\n",
              "      <td>0.3377</td>\n",
              "      <td>-0.4753</td>\n",
              "      <td>-0.2504</td>\n",
              "      <td>-0.7415</td>\n",
              "      <td>0.8413</td>\n",
              "      <td>-0.4259</td>\n",
              "      <td>0.2434</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>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",
              "  </tbody>\n",
              "</table>\n",
              "<p>11769 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",
              "6      id_001bd861f     com_droga     24   D2  ...  2.4670  0.0357  0.1351 -0.3179\n",
              "7      id_0020d0484     com_droga     48   D1  ...  0.6633  0.4562 -0.9622  0.0260\n",
              "...             ...           ...    ...  ...  ...     ...     ...     ...     ...\n",
              "23807  id_fff7e6992     com_droga     48   D1  ...  0.3738  0.8636  0.4494  0.1218\n",
              "23808  id_fff8c2444     com_droga     72   D1  ... -0.7415  0.8413 -0.4259  0.2434\n",
              "23809  id_fffb1ceed     com_droga     24   D2  ...  0.0631  0.9171  0.5258  0.4680\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",
              "\n",
              "[11769 rows x 877 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 53
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 439
        },
        "id": "_s44-eOLvCC4",
        "outputId": "875effb9-c312-4fdf-f2a2-53c2ee211db4"
      },
      "source": [
        "dados.query('tratamento == \"com_controle\"')"
      ],
      "execution_count": 58,
      "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>25</th>\n",
              "      <td>id_0054388ec</td>\n",
              "      <td>com_controle</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>cacb2b860</td>\n",
              "      <td>-0.6696</td>\n",
              "      <td>-0.2718</td>\n",
              "      <td>-1.2230</td>\n",
              "      <td>-0.6226</td>\n",
              "      <td>-0.7220</td>\n",
              "      <td>0.1588</td>\n",
              "      <td>0.7785</td>\n",
              "      <td>0.7062</td>\n",
              "      <td>-0.7951</td>\n",
              "      <td>1.3770</td>\n",
              "      <td>0.2856</td>\n",
              "      <td>-0.8331</td>\n",
              "      <td>0.3879</td>\n",
              "      <td>1.3290</td>\n",
              "      <td>-0.4746</td>\n",
              "      <td>0.0857</td>\n",
              "      <td>-0.2745</td>\n",
              "      <td>-0.1093</td>\n",
              "      <td>0.2603</td>\n",
              "      <td>0.7386</td>\n",
              "      <td>-0.6665</td>\n",
              "      <td>-1.6520</td>\n",
              "      <td>-0.9262</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>1.6310</td>\n",
              "      <td>-0.2933</td>\n",
              "      <td>0.2043</td>\n",
              "      <td>-2.2070</td>\n",
              "      <td>0.1383</td>\n",
              "      <td>-0.4966</td>\n",
              "      <td>0.6922</td>\n",
              "      <td>-0.4077</td>\n",
              "      <td>0.2303</td>\n",
              "      <td>-0.0456</td>\n",
              "      <td>-0.7447</td>\n",
              "      <td>...</td>\n",
              "      <td>0.6976</td>\n",
              "      <td>-0.0178</td>\n",
              "      <td>0.3768</td>\n",
              "      <td>0.4318</td>\n",
              "      <td>-0.1051</td>\n",
              "      <td>0.3933</td>\n",
              "      <td>-0.3189</td>\n",
              "      <td>0.4128</td>\n",
              "      <td>-0.2116</td>\n",
              "      <td>-1.0410</td>\n",
              "      <td>0.7798</td>\n",
              "      <td>0.1579</td>\n",
              "      <td>1.7250</td>\n",
              "      <td>1.4490</td>\n",
              "      <td>0.9117</td>\n",
              "      <td>-0.0754</td>\n",
              "      <td>-0.8396</td>\n",
              "      <td>0.7640</td>\n",
              "      <td>1.2080</td>\n",
              "      <td>1.1890</td>\n",
              "      <td>0.2114</td>\n",
              "      <td>0.6335</td>\n",
              "      <td>0.3265</td>\n",
              "      <td>-0.1056</td>\n",
              "      <td>0.5478</td>\n",
              "      <td>0.7477</td>\n",
              "      <td>1.2340</td>\n",
              "      <td>0.5035</td>\n",
              "      <td>-0.6591</td>\n",
              "      <td>0.3023</td>\n",
              "      <td>0.6171</td>\n",
              "      <td>0.6405</td>\n",
              "      <td>0.5429</td>\n",
              "      <td>0.3562</td>\n",
              "      <td>1.3290</td>\n",
              "      <td>0.5573</td>\n",
              "      <td>0.8837</td>\n",
              "      <td>0.5534</td>\n",
              "      <td>0.8976</td>\n",
              "      <td>1.0050</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>id_0079af0fb</td>\n",
              "      <td>com_controle</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>cacb2b860</td>\n",
              "      <td>-0.1636</td>\n",
              "      <td>-1.8230</td>\n",
              "      <td>-0.5211</td>\n",
              "      <td>0.3054</td>\n",
              "      <td>-1.1280</td>\n",
              "      <td>0.6041</td>\n",
              "      <td>0.3856</td>\n",
              "      <td>-0.1670</td>\n",
              "      <td>-0.5400</td>\n",
              "      <td>0.2721</td>\n",
              "      <td>-0.2479</td>\n",
              "      <td>0.0761</td>\n",
              "      <td>-0.4054</td>\n",
              "      <td>2.9760</td>\n",
              "      <td>-0.7679</td>\n",
              "      <td>0.6995</td>\n",
              "      <td>0.0752</td>\n",
              "      <td>0.5943</td>\n",
              "      <td>0.4266</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>1.0410</td>\n",
              "      <td>-0.1131</td>\n",
              "      <td>0.6593</td>\n",
              "      <td>-0.6890</td>\n",
              "      <td>0.5115</td>\n",
              "      <td>-0.2512</td>\n",
              "      <td>-0.8775</td>\n",
              "      <td>-1.3810</td>\n",
              "      <td>0.1419</td>\n",
              "      <td>-0.0363</td>\n",
              "      <td>0.2559</td>\n",
              "      <td>2.5290</td>\n",
              "      <td>0.2853</td>\n",
              "      <td>1.4690</td>\n",
              "      <td>-0.3626</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.3420</td>\n",
              "      <td>0.2815</td>\n",
              "      <td>-0.7493</td>\n",
              "      <td>-0.2701</td>\n",
              "      <td>0.1205</td>\n",
              "      <td>0.2396</td>\n",
              "      <td>0.3506</td>\n",
              "      <td>-0.9233</td>\n",
              "      <td>0.2490</td>\n",
              "      <td>-0.0824</td>\n",
              "      <td>0.4841</td>\n",
              "      <td>1.1940</td>\n",
              "      <td>-1.1650</td>\n",
              "      <td>-0.4853</td>\n",
              "      <td>1.1080</td>\n",
              "      <td>-0.5979</td>\n",
              "      <td>0.7438</td>\n",
              "      <td>0.2050</td>\n",
              "      <td>-0.2761</td>\n",
              "      <td>-0.1748</td>\n",
              "      <td>0.3385</td>\n",
              "      <td>-0.3500</td>\n",
              "      <td>-0.0309</td>\n",
              "      <td>-0.0409</td>\n",
              "      <td>-0.0735</td>\n",
              "      <td>0.2732</td>\n",
              "      <td>-1.2100</td>\n",
              "      <td>0.0089</td>\n",
              "      <td>0.0317</td>\n",
              "      <td>0.4721</td>\n",
              "      <td>-0.3880</td>\n",
              "      <td>-0.6828</td>\n",
              "      <td>-0.6594</td>\n",
              "      <td>-0.2043</td>\n",
              "      <td>0.3571</td>\n",
              "      <td>-0.1319</td>\n",
              "      <td>0.2187</td>\n",
              "      <td>0.0737</td>\n",
              "      <td>0.6498</td>\n",
              "      <td>-1.4820</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>id_007bfbb91</td>\n",
              "      <td>com_controle</td>\n",
              "      <td>24</td>\n",
              "      <td>D2</td>\n",
              "      <td>cacb2b860</td>\n",
              "      <td>-1.3200</td>\n",
              "      <td>-1.7340</td>\n",
              "      <td>-0.0741</td>\n",
              "      <td>1.5440</td>\n",
              "      <td>-1.8290</td>\n",
              "      <td>-0.0951</td>\n",
              "      <td>0.3829</td>\n",
              "      <td>-1.8700</td>\n",
              "      <td>-0.0324</td>\n",
              "      <td>2.7670</td>\n",
              "      <td>-0.0438</td>\n",
              "      <td>-0.0147</td>\n",
              "      <td>0.1276</td>\n",
              "      <td>0.2968</td>\n",
              "      <td>-0.0704</td>\n",
              "      <td>-0.3767</td>\n",
              "      <td>2.5790</td>\n",
              "      <td>0.4069</td>\n",
              "      <td>-0.3868</td>\n",
              "      <td>-0.2782</td>\n",
              "      <td>1.8180</td>\n",
              "      <td>-2.9390</td>\n",
              "      <td>-0.1150</td>\n",
              "      <td>-0.8009</td>\n",
              "      <td>-1.4440</td>\n",
              "      <td>0.5412</td>\n",
              "      <td>-0.0804</td>\n",
              "      <td>-0.4444</td>\n",
              "      <td>2.9230</td>\n",
              "      <td>2.8270</td>\n",
              "      <td>-0.3437</td>\n",
              "      <td>1.6570</td>\n",
              "      <td>-1.9200</td>\n",
              "      <td>0.3442</td>\n",
              "      <td>1.7160</td>\n",
              "      <td>...</td>\n",
              "      <td>0.4009</td>\n",
              "      <td>0.7649</td>\n",
              "      <td>0.2789</td>\n",
              "      <td>0.4465</td>\n",
              "      <td>0.9492</td>\n",
              "      <td>0.6385</td>\n",
              "      <td>1.5510</td>\n",
              "      <td>-0.1220</td>\n",
              "      <td>0.6688</td>\n",
              "      <td>0.4396</td>\n",
              "      <td>0.6947</td>\n",
              "      <td>0.9761</td>\n",
              "      <td>1.2430</td>\n",
              "      <td>1.4770</td>\n",
              "      <td>-0.0081</td>\n",
              "      <td>1.0040</td>\n",
              "      <td>1.4420</td>\n",
              "      <td>-0.3482</td>\n",
              "      <td>0.3297</td>\n",
              "      <td>1.2070</td>\n",
              "      <td>0.0524</td>\n",
              "      <td>0.5346</td>\n",
              "      <td>0.7643</td>\n",
              "      <td>0.4067</td>\n",
              "      <td>0.3817</td>\n",
              "      <td>0.4566</td>\n",
              "      <td>0.7736</td>\n",
              "      <td>0.5316</td>\n",
              "      <td>0.2790</td>\n",
              "      <td>0.9735</td>\n",
              "      <td>0.7412</td>\n",
              "      <td>1.0340</td>\n",
              "      <td>0.7393</td>\n",
              "      <td>1.1020</td>\n",
              "      <td>0.3786</td>\n",
              "      <td>0.2636</td>\n",
              "      <td>-0.5751</td>\n",
              "      <td>0.3362</td>\n",
              "      <td>0.8543</td>\n",
              "      <td>0.9180</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>id_008a986b7</td>\n",
              "      <td>com_controle</td>\n",
              "      <td>48</td>\n",
              "      <td>D2</td>\n",
              "      <td>cacb2b860</td>\n",
              "      <td>0.4860</td>\n",
              "      <td>0.1430</td>\n",
              "      <td>0.5281</td>\n",
              "      <td>-0.0022</td>\n",
              "      <td>-0.2334</td>\n",
              "      <td>-0.6607</td>\n",
              "      <td>0.6459</td>\n",
              "      <td>-0.0109</td>\n",
              "      <td>1.0120</td>\n",
              "      <td>-0.0864</td>\n",
              "      <td>-0.3817</td>\n",
              "      <td>-1.0600</td>\n",
              "      <td>0.9435</td>\n",
              "      <td>0.6296</td>\n",
              "      <td>0.3864</td>\n",
              "      <td>0.1420</td>\n",
              "      <td>0.9834</td>\n",
              "      <td>0.4189</td>\n",
              "      <td>0.7980</td>\n",
              "      <td>-0.2132</td>\n",
              "      <td>0.7651</td>\n",
              "      <td>-1.2410</td>\n",
              "      <td>0.0747</td>\n",
              "      <td>-1.5750</td>\n",
              "      <td>0.1535</td>\n",
              "      <td>-0.0840</td>\n",
              "      <td>0.6705</td>\n",
              "      <td>-0.7517</td>\n",
              "      <td>-0.2756</td>\n",
              "      <td>-1.0920</td>\n",
              "      <td>-0.8683</td>\n",
              "      <td>0.3021</td>\n",
              "      <td>-0.3164</td>\n",
              "      <td>-0.2074</td>\n",
              "      <td>0.4587</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.2189</td>\n",
              "      <td>-0.5262</td>\n",
              "      <td>-0.2982</td>\n",
              "      <td>-0.2491</td>\n",
              "      <td>-0.6373</td>\n",
              "      <td>-1.0040</td>\n",
              "      <td>-0.6726</td>\n",
              "      <td>-0.0321</td>\n",
              "      <td>-0.5398</td>\n",
              "      <td>-0.7518</td>\n",
              "      <td>0.0370</td>\n",
              "      <td>0.7213</td>\n",
              "      <td>-0.3466</td>\n",
              "      <td>0.2354</td>\n",
              "      <td>-0.4432</td>\n",
              "      <td>-0.1020</td>\n",
              "      <td>-0.9391</td>\n",
              "      <td>-1.1970</td>\n",
              "      <td>0.1365</td>\n",
              "      <td>-0.9264</td>\n",
              "      <td>0.5828</td>\n",
              "      <td>-0.7379</td>\n",
              "      <td>-0.4354</td>\n",
              "      <td>0.6077</td>\n",
              "      <td>-0.3771</td>\n",
              "      <td>-0.6525</td>\n",
              "      <td>-0.4169</td>\n",
              "      <td>-1.0640</td>\n",
              "      <td>-0.3331</td>\n",
              "      <td>-0.5761</td>\n",
              "      <td>-0.3085</td>\n",
              "      <td>-0.1866</td>\n",
              "      <td>0.7629</td>\n",
              "      <td>0.3288</td>\n",
              "      <td>-0.9915</td>\n",
              "      <td>-0.3694</td>\n",
              "      <td>-0.4979</td>\n",
              "      <td>0.5281</td>\n",
              "      <td>-0.9245</td>\n",
              "      <td>-0.9367</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>63</th>\n",
              "      <td>id_009d8340f</td>\n",
              "      <td>com_controle</td>\n",
              "      <td>24</td>\n",
              "      <td>D2</td>\n",
              "      <td>cacb2b860</td>\n",
              "      <td>0.4471</td>\n",
              "      <td>-0.0839</td>\n",
              "      <td>-0.3864</td>\n",
              "      <td>0.3196</td>\n",
              "      <td>0.2584</td>\n",
              "      <td>-0.3156</td>\n",
              "      <td>-0.1187</td>\n",
              "      <td>1.1610</td>\n",
              "      <td>0.5838</td>\n",
              "      <td>-0.2996</td>\n",
              "      <td>-0.3995</td>\n",
              "      <td>1.0700</td>\n",
              "      <td>0.2969</td>\n",
              "      <td>-0.2785</td>\n",
              "      <td>0.9678</td>\n",
              "      <td>-0.1409</td>\n",
              "      <td>1.0850</td>\n",
              "      <td>-0.0656</td>\n",
              "      <td>-0.6502</td>\n",
              "      <td>0.3527</td>\n",
              "      <td>0.1998</td>\n",
              "      <td>0.0975</td>\n",
              "      <td>0.0563</td>\n",
              "      <td>-0.3578</td>\n",
              "      <td>-0.0657</td>\n",
              "      <td>0.5316</td>\n",
              "      <td>0.6573</td>\n",
              "      <td>-0.5355</td>\n",
              "      <td>1.2380</td>\n",
              "      <td>-0.4994</td>\n",
              "      <td>-0.8140</td>\n",
              "      <td>0.2567</td>\n",
              "      <td>-0.8155</td>\n",
              "      <td>1.1180</td>\n",
              "      <td>-0.2501</td>\n",
              "      <td>...</td>\n",
              "      <td>0.2427</td>\n",
              "      <td>0.5214</td>\n",
              "      <td>0.0587</td>\n",
              "      <td>-0.5903</td>\n",
              "      <td>0.1332</td>\n",
              "      <td>-0.3517</td>\n",
              "      <td>-0.3276</td>\n",
              "      <td>-0.4955</td>\n",
              "      <td>0.1359</td>\n",
              "      <td>-0.3010</td>\n",
              "      <td>0.5725</td>\n",
              "      <td>-0.1126</td>\n",
              "      <td>-0.0874</td>\n",
              "      <td>1.2220</td>\n",
              "      <td>-0.0641</td>\n",
              "      <td>0.0246</td>\n",
              "      <td>-0.5659</td>\n",
              "      <td>-0.7402</td>\n",
              "      <td>1.1170</td>\n",
              "      <td>-0.0612</td>\n",
              "      <td>-1.3040</td>\n",
              "      <td>-0.4025</td>\n",
              "      <td>0.3760</td>\n",
              "      <td>-0.0873</td>\n",
              "      <td>0.8064</td>\n",
              "      <td>-0.0170</td>\n",
              "      <td>0.3092</td>\n",
              "      <td>0.2671</td>\n",
              "      <td>0.3311</td>\n",
              "      <td>-0.4572</td>\n",
              "      <td>0.4795</td>\n",
              "      <td>0.3939</td>\n",
              "      <td>0.7665</td>\n",
              "      <td>0.7932</td>\n",
              "      <td>-0.6804</td>\n",
              "      <td>-0.0435</td>\n",
              "      <td>0.0949</td>\n",
              "      <td>0.2000</td>\n",
              "      <td>-0.4326</td>\n",
              "      <td>0.9364</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>23729</th>\n",
              "      <td>id_ff1f9e5fc</td>\n",
              "      <td>com_controle</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>cacb2b860</td>\n",
              "      <td>0.0465</td>\n",
              "      <td>0.6430</td>\n",
              "      <td>-0.2453</td>\n",
              "      <td>0.3521</td>\n",
              "      <td>0.6195</td>\n",
              "      <td>-0.6659</td>\n",
              "      <td>0.8263</td>\n",
              "      <td>0.5933</td>\n",
              "      <td>0.1388</td>\n",
              "      <td>-0.2246</td>\n",
              "      <td>-0.6127</td>\n",
              "      <td>-0.1687</td>\n",
              "      <td>1.5170</td>\n",
              "      <td>0.6243</td>\n",
              "      <td>-0.8399</td>\n",
              "      <td>-0.1881</td>\n",
              "      <td>-0.1583</td>\n",
              "      <td>0.0622</td>\n",
              "      <td>-0.1170</td>\n",
              "      <td>0.7722</td>\n",
              "      <td>0.0063</td>\n",
              "      <td>0.7347</td>\n",
              "      <td>-0.4820</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0938</td>\n",
              "      <td>-0.6062</td>\n",
              "      <td>0.6108</td>\n",
              "      <td>-0.4900</td>\n",
              "      <td>0.1075</td>\n",
              "      <td>0.3029</td>\n",
              "      <td>-0.1369</td>\n",
              "      <td>0.1946</td>\n",
              "      <td>0.1745</td>\n",
              "      <td>1.1030</td>\n",
              "      <td>0.3444</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.4342</td>\n",
              "      <td>0.0541</td>\n",
              "      <td>0.9346</td>\n",
              "      <td>0.7595</td>\n",
              "      <td>-0.0139</td>\n",
              "      <td>0.2990</td>\n",
              "      <td>-0.7176</td>\n",
              "      <td>0.8572</td>\n",
              "      <td>0.2990</td>\n",
              "      <td>-0.2060</td>\n",
              "      <td>0.9029</td>\n",
              "      <td>0.4144</td>\n",
              "      <td>0.0802</td>\n",
              "      <td>0.0686</td>\n",
              "      <td>-0.3934</td>\n",
              "      <td>0.2344</td>\n",
              "      <td>1.0940</td>\n",
              "      <td>0.0144</td>\n",
              "      <td>-1.0080</td>\n",
              "      <td>0.8748</td>\n",
              "      <td>1.2900</td>\n",
              "      <td>0.5188</td>\n",
              "      <td>0.5824</td>\n",
              "      <td>0.0182</td>\n",
              "      <td>0.7578</td>\n",
              "      <td>1.1910</td>\n",
              "      <td>-0.3264</td>\n",
              "      <td>0.6882</td>\n",
              "      <td>0.7486</td>\n",
              "      <td>0.6438</td>\n",
              "      <td>0.6085</td>\n",
              "      <td>0.1621</td>\n",
              "      <td>-0.2065</td>\n",
              "      <td>0.8314</td>\n",
              "      <td>-0.1891</td>\n",
              "      <td>-0.0074</td>\n",
              "      <td>0.2131</td>\n",
              "      <td>-0.1419</td>\n",
              "      <td>-0.2422</td>\n",
              "      <td>0.0457</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23747</th>\n",
              "      <td>id_ff469c482</td>\n",
              "      <td>com_controle</td>\n",
              "      <td>72</td>\n",
              "      <td>D1</td>\n",
              "      <td>cacb2b860</td>\n",
              "      <td>-0.6204</td>\n",
              "      <td>-1.3800</td>\n",
              "      <td>-1.1880</td>\n",
              "      <td>-0.6573</td>\n",
              "      <td>-0.8408</td>\n",
              "      <td>-0.2447</td>\n",
              "      <td>1.3490</td>\n",
              "      <td>-0.5155</td>\n",
              "      <td>1.2610</td>\n",
              "      <td>-0.1790</td>\n",
              "      <td>-0.7182</td>\n",
              "      <td>-0.7885</td>\n",
              "      <td>0.3022</td>\n",
              "      <td>2.0140</td>\n",
              "      <td>0.1667</td>\n",
              "      <td>-0.7325</td>\n",
              "      <td>-0.1553</td>\n",
              "      <td>0.8400</td>\n",
              "      <td>-0.1069</td>\n",
              "      <td>-0.7247</td>\n",
              "      <td>1.3430</td>\n",
              "      <td>1.5010</td>\n",
              "      <td>-1.3370</td>\n",
              "      <td>0.7190</td>\n",
              "      <td>-0.0843</td>\n",
              "      <td>0.4841</td>\n",
              "      <td>-0.9104</td>\n",
              "      <td>1.3990</td>\n",
              "      <td>0.7447</td>\n",
              "      <td>-1.2110</td>\n",
              "      <td>0.6562</td>\n",
              "      <td>0.1265</td>\n",
              "      <td>0.3036</td>\n",
              "      <td>2.2600</td>\n",
              "      <td>-1.3770</td>\n",
              "      <td>...</td>\n",
              "      <td>0.9633</td>\n",
              "      <td>-0.4057</td>\n",
              "      <td>-0.2206</td>\n",
              "      <td>0.5111</td>\n",
              "      <td>-0.8666</td>\n",
              "      <td>0.4692</td>\n",
              "      <td>0.8903</td>\n",
              "      <td>0.6648</td>\n",
              "      <td>0.2922</td>\n",
              "      <td>0.2440</td>\n",
              "      <td>1.0960</td>\n",
              "      <td>1.2420</td>\n",
              "      <td>1.0430</td>\n",
              "      <td>1.4310</td>\n",
              "      <td>1.0040</td>\n",
              "      <td>1.0320</td>\n",
              "      <td>0.7345</td>\n",
              "      <td>0.8025</td>\n",
              "      <td>0.7174</td>\n",
              "      <td>0.1932</td>\n",
              "      <td>-0.2609</td>\n",
              "      <td>0.3501</td>\n",
              "      <td>0.5916</td>\n",
              "      <td>0.9193</td>\n",
              "      <td>0.1398</td>\n",
              "      <td>0.0243</td>\n",
              "      <td>0.4820</td>\n",
              "      <td>-0.4428</td>\n",
              "      <td>-0.1235</td>\n",
              "      <td>0.4166</td>\n",
              "      <td>0.8209</td>\n",
              "      <td>0.7366</td>\n",
              "      <td>0.5468</td>\n",
              "      <td>1.1450</td>\n",
              "      <td>0.5254</td>\n",
              "      <td>0.6224</td>\n",
              "      <td>-0.9630</td>\n",
              "      <td>0.8872</td>\n",
              "      <td>-0.0742</td>\n",
              "      <td>-0.6777</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23768</th>\n",
              "      <td>id_ff89331ca</td>\n",
              "      <td>com_controle</td>\n",
              "      <td>72</td>\n",
              "      <td>D2</td>\n",
              "      <td>cacb2b860</td>\n",
              "      <td>-0.1051</td>\n",
              "      <td>0.4335</td>\n",
              "      <td>0.3648</td>\n",
              "      <td>-0.0525</td>\n",
              "      <td>-0.3632</td>\n",
              "      <td>-0.3228</td>\n",
              "      <td>-2.3190</td>\n",
              "      <td>-0.5294</td>\n",
              "      <td>0.1878</td>\n",
              "      <td>0.5047</td>\n",
              "      <td>1.3820</td>\n",
              "      <td>0.6107</td>\n",
              "      <td>2.4790</td>\n",
              "      <td>0.4347</td>\n",
              "      <td>0.9422</td>\n",
              "      <td>-0.1042</td>\n",
              "      <td>-0.2611</td>\n",
              "      <td>1.5760</td>\n",
              "      <td>-0.0232</td>\n",
              "      <td>-0.2455</td>\n",
              "      <td>0.8058</td>\n",
              "      <td>-2.4180</td>\n",
              "      <td>-0.5838</td>\n",
              "      <td>-0.1626</td>\n",
              "      <td>-0.8609</td>\n",
              "      <td>-0.2021</td>\n",
              "      <td>0.1494</td>\n",
              "      <td>0.6618</td>\n",
              "      <td>1.3080</td>\n",
              "      <td>-0.7822</td>\n",
              "      <td>0.3923</td>\n",
              "      <td>-0.4608</td>\n",
              "      <td>-1.7090</td>\n",
              "      <td>0.3173</td>\n",
              "      <td>0.7622</td>\n",
              "      <td>...</td>\n",
              "      <td>1.2340</td>\n",
              "      <td>-0.1665</td>\n",
              "      <td>-0.0318</td>\n",
              "      <td>0.8694</td>\n",
              "      <td>0.4048</td>\n",
              "      <td>0.1281</td>\n",
              "      <td>0.0164</td>\n",
              "      <td>1.0670</td>\n",
              "      <td>1.5790</td>\n",
              "      <td>0.2428</td>\n",
              "      <td>1.1330</td>\n",
              "      <td>-1.2310</td>\n",
              "      <td>0.3626</td>\n",
              "      <td>-0.4737</td>\n",
              "      <td>0.2937</td>\n",
              "      <td>0.1638</td>\n",
              "      <td>-0.1554</td>\n",
              "      <td>0.9236</td>\n",
              "      <td>0.0937</td>\n",
              "      <td>0.9598</td>\n",
              "      <td>0.4738</td>\n",
              "      <td>-0.2608</td>\n",
              "      <td>0.3577</td>\n",
              "      <td>-1.2040</td>\n",
              "      <td>0.8125</td>\n",
              "      <td>1.4260</td>\n",
              "      <td>0.2223</td>\n",
              "      <td>0.3079</td>\n",
              "      <td>1.1490</td>\n",
              "      <td>1.7320</td>\n",
              "      <td>-0.1219</td>\n",
              "      <td>0.4885</td>\n",
              "      <td>0.4963</td>\n",
              "      <td>0.9434</td>\n",
              "      <td>-0.4779</td>\n",
              "      <td>0.6951</td>\n",
              "      <td>0.9517</td>\n",
              "      <td>-0.8110</td>\n",
              "      <td>-0.1748</td>\n",
              "      <td>-0.3626</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23793</th>\n",
              "      <td>id_ffd26f361</td>\n",
              "      <td>com_controle</td>\n",
              "      <td>48</td>\n",
              "      <td>D2</td>\n",
              "      <td>cacb2b860</td>\n",
              "      <td>0.6008</td>\n",
              "      <td>0.2781</td>\n",
              "      <td>-0.3319</td>\n",
              "      <td>-0.8782</td>\n",
              "      <td>0.9281</td>\n",
              "      <td>0.7535</td>\n",
              "      <td>0.5971</td>\n",
              "      <td>1.6350</td>\n",
              "      <td>-0.3146</td>\n",
              "      <td>0.4984</td>\n",
              "      <td>-1.1890</td>\n",
              "      <td>0.3772</td>\n",
              "      <td>-0.8196</td>\n",
              "      <td>0.1083</td>\n",
              "      <td>-2.0350</td>\n",
              "      <td>0.4135</td>\n",
              "      <td>0.7586</td>\n",
              "      <td>-0.4024</td>\n",
              "      <td>-0.0449</td>\n",
              "      <td>0.3335</td>\n",
              "      <td>0.2358</td>\n",
              "      <td>0.7919</td>\n",
              "      <td>-0.8775</td>\n",
              "      <td>0.4232</td>\n",
              "      <td>1.8460</td>\n",
              "      <td>-2.0940</td>\n",
              "      <td>0.1438</td>\n",
              "      <td>-0.6604</td>\n",
              "      <td>0.7243</td>\n",
              "      <td>0.0338</td>\n",
              "      <td>-0.0182</td>\n",
              "      <td>-0.2022</td>\n",
              "      <td>0.8827</td>\n",
              "      <td>0.3147</td>\n",
              "      <td>-0.9263</td>\n",
              "      <td>...</td>\n",
              "      <td>0.1934</td>\n",
              "      <td>1.2240</td>\n",
              "      <td>-0.1178</td>\n",
              "      <td>0.1459</td>\n",
              "      <td>-0.1242</td>\n",
              "      <td>0.3106</td>\n",
              "      <td>-0.7959</td>\n",
              "      <td>0.5681</td>\n",
              "      <td>0.3663</td>\n",
              "      <td>0.4874</td>\n",
              "      <td>-0.0548</td>\n",
              "      <td>0.1810</td>\n",
              "      <td>1.3470</td>\n",
              "      <td>1.6210</td>\n",
              "      <td>-0.8260</td>\n",
              "      <td>0.3377</td>\n",
              "      <td>0.3264</td>\n",
              "      <td>0.9241</td>\n",
              "      <td>0.3012</td>\n",
              "      <td>1.2980</td>\n",
              "      <td>-0.2789</td>\n",
              "      <td>0.7019</td>\n",
              "      <td>-0.3528</td>\n",
              "      <td>0.7383</td>\n",
              "      <td>1.0300</td>\n",
              "      <td>0.6527</td>\n",
              "      <td>1.6750</td>\n",
              "      <td>-0.5046</td>\n",
              "      <td>0.2942</td>\n",
              "      <td>0.2950</td>\n",
              "      <td>1.2470</td>\n",
              "      <td>0.9569</td>\n",
              "      <td>-0.2065</td>\n",
              "      <td>-0.4918</td>\n",
              "      <td>0.7863</td>\n",
              "      <td>0.0504</td>\n",
              "      <td>0.8813</td>\n",
              "      <td>0.7757</td>\n",
              "      <td>-0.5272</td>\n",
              "      <td>0.7082</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",
              "  </tbody>\n",
              "</table>\n",
              "<p>1866 rows × 877 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                 id    tratamento  tempo dose  ...     c96     c97     c98     c99\n",
              "25     id_0054388ec  com_controle     48   D1  ...  0.8837  0.5534  0.8976  1.0050\n",
              "38     id_0079af0fb  com_controle     24   D1  ...  0.2187  0.0737  0.6498 -1.4820\n",
              "40     id_007bfbb91  com_controle     24   D2  ... -0.5751  0.3362  0.8543  0.9180\n",
              "47     id_008a986b7  com_controle     48   D2  ... -0.4979  0.5281 -0.9245 -0.9367\n",
              "63     id_009d8340f  com_controle     24   D2  ...  0.0949  0.2000 -0.4326  0.9364\n",
              "...             ...           ...    ...  ...  ...     ...     ...     ...     ...\n",
              "23729  id_ff1f9e5fc  com_controle     24   D1  ...  0.2131 -0.1419 -0.2422  0.0457\n",
              "23747  id_ff469c482  com_controle     72   D1  ... -0.9630  0.8872 -0.0742 -0.6777\n",
              "23768  id_ff89331ca  com_controle     72   D2  ...  0.9517 -0.8110 -0.1748 -0.3626\n",
              "23793  id_ffd26f361  com_controle     48   D2  ...  0.8813  0.7757 -0.5272  0.7082\n",
              "23811  id_fffc1c3f4  com_controle     48   D2  ...  0.2256  0.7592  0.6656  0.3808\n",
              "\n",
              "[1866 rows x 877 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 58
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "1l_UMEWFuehf"
      },
      "source": [
        "# Desafio 07: Deixar os gráficos bonitões. (Matplotlib.pyplot)\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 315
        },
        "id": "b9NhKTX7umBW",
        "outputId": "064adeac-c829-4ecf-f205-63406800f7af"
      },
      "source": [
        "grafico = dados['tempo'].value_counts().plot.bar()\n",
        "grafico.set_title(\"Tempo\")\n",
        "grafico.set_xlabel(\"Horas\")\n",
        "grafico.set_ylabel(\"Experimentos\")\n"
      ],
      "execution_count": 63,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Text(0, 0.5, 'Experimentos')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 63
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYsAAAEZCAYAAABmTgnDAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAa/UlEQVR4nO3dfbRddX3n8fcHIig+8JhmQRIb1FgHLSqmgKXTB6A82RKmImKtBso07Rqm2mmnFurMylSgVde0FLTSSSUaHBUBZRFalpiith1bkPAwKCCTiGKS8nAlCCqKBr/zx/nderjcm3243HPvDff9Wuuss/dv//be37Mifu7e+7f3TlUhSdKO7DLTBUiSZj/DQpLUybCQJHUyLCRJnQwLSVInw0KS1MmwkCR1MiykDkm+0/f5UZLv9c2/eabrk6ZDvClPGlySrwP/sar+fqZrkaaTRxbSJCXZJclZSb6a5MEklyXZpy1bkqSSnJ5kc5KHkvxOkp9JcluSbyV5f9+2TkvyhSTvT/Jwkq8kOapv+QFJ1iXZlmRTkt+aid+sucuwkCbvd4GTgF8ADgAeAv5qTJ/DgKXAG4G/BN4JHA28HDglyS+M6ftVYD9gFfCp0fABLgW2tP2cDPxpkiOH8JukcRkW0uT9DvDOqtpSVY8B/wM4Ocm8vj7nVNX3q+ozwHeBj1fVA1W1Ffgn4NV9fR8A/rKqflhVnwDuAl6XZDFwBPBHbVu3Ah8E3jr0Xyg187q7SJrATwJXJvlRX9vjwIK++fv7pr83zvzz+ua31hMvIt5D70jiAGBbVX17zLJlT6N26SnxyEKavM3A8VW1V9/n2e2oYTIWJknf/AuBf22ffZI8f8yyye5HesoMC2ny/ho4L8lPAiSZn2T509jeTwBvS/KsJG8A/h1wTVVtBv4Z+LMkz05yMHAG8L+fZv3SwDwNJU3eBUCAzyQ5gN41h08AV01yezfQuxj+TXqnq06uqgfbsjfRC6d/pXchfZXDdzWdvM9CmgWSnEbv/o2fm+lapPF4GkqS1MmwkCR18jSUJKmTRxaSpE6GhSSp0zNy6Ox+++1XS5YsmekyJGmnctNNN32zquaPt+wZGRZLlixhw4YNM12GJO1Uktwz0TJPQ0mSOhkWkqROhoUkqZNhIUnqZFhIkjoZFpKkToaFJKmTYSFJ6vSMvClvui056+9muoSh+vq7XzfTJUiaYR5ZSJI6GRaSpE5DDYsk/yXJ7Um+nOTj7WXzBya5IcmmJJ9Islvru3ub39SWL+nbztmt/a4kxw6zZknSkw0tLJIsBN4GLKuqVwC7AqcC7wHOr6qX0Hvx/BltlTOAh1r7+a0fSQ5q670cOA74QJJdh1W3JOnJhn0aah7wnCTzgD2Ae4EjgSva8rXASW16eZunLT8qSVr7pVX1WFV9DdgEHDrkuiVJfYYWFlW1FfifwDfohcTDwE3At6pqe+u2BVjYphcCm9u621v/ffvbx1nn3yRZmWRDkg0jIyNT/4MkaQ4b5mmovekdFRwIHAA8l95ppKGoqtVVtayqls2fP+67OyRJkzTM01BHA1+rqpGq+iHwKeAIYK92WgpgEbC1TW8FFgO05XsCD/a3j7OOJGkaDDMsvgEcnmSPdu3hKOAO4HPAya3PCuCqNr2uzdOWf7aqqrWf2kZLHQgsBb44xLolSWMM7Q7uqrohyRXAzcB24BZgNfB3wKVJzm1tF7dVLgY+kmQTsI3eCCiq6vYkl9ELmu3AmVX1+LDqliQ92VAf91FVq4BVY5rvZpzRTFX1feANE2znPOC8KS9Qwse1SIPw2VCSdloG/fTxcR+SpE6GhSSpk2EhSepkWEiSOhkWkqROhoUkqZNhIUnqZFhIkjoZFpKkToaFJKmTYSFJ6mRYSJI6GRaSpE6GhSSpk2EhSeo0tLBI8lNJbu37PJLk95Lsk2R9ko3te+/WP0kuTLIpyW1JDunb1orWf2OSFRPvVZI0DEMLi6q6q6peVVWvAl4DPApcCZwFXFdVS4Hr2jzA8fTer70UWAlcBJBkH3pv2zuM3hv2Vo0GjCRpekzXaaijgK9W1T3AcmBta18LnNSmlwOXVM/1wF5J9geOBdZX1baqeghYDxw3TXVLkpi+sDgV+HibXlBV97bp+4AFbXohsLlvnS2tbaL2J0iyMsmGJBtGRkamsnZJmvOGHhZJdgNOBC4fu6yqCqip2E9Vra6qZVW1bP78+VOxSUlSMx1HFscDN1fV/W3+/nZ6ifb9QGvfCizuW29Ra5uoXZI0TaYjLN7Ej09BAawDRkc0rQCu6mt/axsVdTjwcDtddS1wTJK924XtY1qbJGmazBvmxpM8F/hl4Lf7mt8NXJbkDOAe4JTWfg1wArCJ3sip0wGqaluSc4AbW793VdW2YdYtSXqioYZFVX0X2HdM24P0RkeN7VvAmRNsZw2wZhg1SpK6eQe3JKmTYSFJ6mRYSJI6GRaSpE6GhSSpk2EhSepkWEiSOhkWkqROhoUkqZNhIUnqZFhIkjoZFpKkToaFJKmTYSFJ6mRYSJI6GRaSpE5DDYskeyW5IslXktyZ5LVJ9kmyPsnG9r1365skFybZlOS2JIf0bWdF678xyYqJ9yhJGoZhH1lcAHy6ql4GvBK4EzgLuK6qlgLXtXmA44Gl7bMSuAggyT7AKuAw4FBg1WjASJKmx9DCIsmewM8DFwNU1Q+q6lvAcmBt67YWOKlNLwcuqZ7rgb2S7A8cC6yvqm1V9RCwHjhuWHVLkp5smEcWBwIjwIeS3JLkg0meCyyoqntbn/uABW16IbC5b/0trW2i9idIsjLJhiQbRkZGpvinSNLcNsywmAccAlxUVa8GvsuPTzkBUFUF1FTsrKpWV9Wyqlo2f/78qdikJKkZZlhsAbZU1Q1t/gp64XF/O71E+36gLd8KLO5bf1Frm6hdkjRNhhYWVXUfsDnJT7Wmo4A7gHXA6IimFcBVbXod8NY2Kupw4OF2uupa4Jgke7cL28e0NknSNJk35O3/LvDRJLsBdwOn0wuoy5KcAdwDnNL6XgOcAGwCHm19qaptSc4Bbmz93lVV24ZctySpz1DDoqpuBZaNs+iocfoWcOYE21kDrJna6iRJg/IObklSJ8NCktTJsJAkdTIsJEmdnnJYtCGsBw+jGEnS7DRQWCT5fJIXtIf63Qz8TZK/GG5pkqTZYtAjiz2r6hHg1+g97O8w4OjhlSVJmk0GDYt57dEcpwB/O8R6JEmz0KBh8S56j9j4alXdmORFwMbhlSVJmk0GuoO7qi4HLu+bvxt4/bCKkiTNLoNe4F6U5MokD7TPJ5MsGnZxkqTZYdDTUB+i91TYA9rn6tYmSZoDBg2L+VX1oara3j4fBnzDkCTNEYOGxYNJfiPJru3zG8CDwyxMkjR7DBoWv0lv2Ox9wL3AycBpQ6pJkjTLDPo+i0VVdWJ/Q5IjgM1TX5IkabYZ9MjifQO2PUGSryf5UpJbk2xobfskWZ9kY/veu7UnyYVJNiW5LckhfdtZ0fpvTLJiov1JkoZjh0cWSV4L/CwwP8nv9y16AbDrgPv4par6Zt/8WcB1VfXuJGe1+T8CjgeWts9hwEXAYe15VKvovXGvgJuSrKuqhwbcvyTpaeo6stgNeB69UHl+3+cRetctJmM5sLZNrwVO6mu/pHquB/Zqjxg5FlhfVdtaQKwHjpvkviVJk7DDI4uq+gfgH5J8uKrumcT2C/hMkgL+V1WtBhZU1b1t+X3Agja9kCdeA9nS2iZqlyRNk0EvcO+eZDWwpH+dqjqyY72fq6qtSX4CWJ/kK/0Lq6pakDxtSVYCKwFe+MIXTsUmJUnNoGFxOfDXwAeBxwfdeFVtbd8PJLkSOBS4P8n+VXVvO830QOu+FVjct/qi1rYV+MUx7Z8fZ1+rgdUAy5Ytm5IAkiT1DDoaantVXVRVX6yqm0Y/O1ohyXOTPH90GjgG+DK9x4aMjmhaAVzVptcBb22jog4HHm6nq64Fjmlv6Nu7befap/IjJUlPz6BHFlcn+U/AlcBjo41VtW0H6ywArkwyup+PVdWnk9wIXJbkDOAeejf7AVwDnABsAh4FTh/dR5JzgBtbv3d17FeSNMUGDYvRI4E/7Gsr4EUTrdAeY/7KcdofBI4ap72AMyfY1hpgzYC1SpKm2KDvszhw2IVIkmavQd9nsUeS/9ZGRJFkaZJfGW5pkqTZ4qm8z+IH9O7mht4IpXOHUpEkadYZNCxeXFXvBX4IUFWPAhlaVZKkWWXQsPhBkufQu6hNkhfTNypKkvTMNuhoqFXAp4HFST4KHIHvs5CkOWPQ0VDrk9wMHE7v9NPbxzxJVpL0DDboaSjoPbxvV3pPov35JL82nJIkSbPNQEcWSdYABwO3Az9qzQV8akh1SZJmkUGvWRxeVQcNtRJJ0qw16Gmof0liWEjSHDXokcUl9ALjPnpDZkPvcU4HD60ySdKsMWhYXAy8BfgSP75mIUmaIwYNi5GqWjfUSiRJs9agYXFLko8BV/PE91k4GkqS5oBBw+I59ELimL42h85K0hwx6B3cp092B0l2BTYAW6vqV5IcCFwK7AvcBLylqn6QZHd6F9JfAzwIvLGqvt62cTZwBr33f7+tqnytqiRNox2GRZJ3VNV7k7yP9hDBflX1tgH28XbgTuAFbf49wPlVdWmSv6YXAhe174eq6iVJTm393tiG7J4KvBw4APj7JC+tqscH+4mSpKer6z6LO9v3BnpHAWM/O5RkEfA64INtPsCRwBWty1rgpDa9vM3Tlh/V+i8HLq2qx6rqa/Te0X1o5y+TJE2ZHR5ZVNXV7TTST1fVf53E9v8SeAfw/Da/L/Ctqtre5rfQe+YU7Xtz2+/2JA+3/guB6/u22b+OJGkadN7B3U73HPFUN9xeu/pAVXUegUyFJCuTbEiyYWRkZDp2KUlzxqCjoW5Nsg64HPjuaGPH0NkjgBOTnAA8m941iwuAvZLMa0cXi+i9opX2vRjYkmQesCe9C92j7aP61/k3VbUaWA2wbNmyJ11fkSRN3qDPhno2vf/jPhL41fb5lR2tUFVnV9WiqlpC7wL1Z6vqzcDngJNbtxXAVW16XZunLf9sVVVrPzXJ7m0k1VLgiwPWLUmaAkMfOjuOPwIuTXIucAu9R4nQvj+SZBOwjV7AUFW3J7kMuAPYDpzpSChJml6Dvs/ipfSGty6oqlckORg4sarOHWT9qvo88Pk2fTfjjGaqqu8Db5hg/fOA8wbZlyRp6g16GupvgLOBHwJU1W20v/wlSc98g4bFHlU19jrB9nF7SpKecQYNi28meTHtLu4kJwP3Dq0qSdKsMujQ2TPpDUt9WZKtwNeANw+tKknSrDLoaKi7gaOTPBfYpaq+PdyyJEmzyUCnoZLsm+RC4J+Azye5IMm+wy1NkjRbDHrN4lJgBHg9vRvmRoBPDKsoSdLsMug1i/2r6py++XOTvHEYBUmSZp9Bjyw+k+TUJLu0zymALyCSpDli0LD4LeBj9F6t+hi901K/neTbSR4ZVnGSpNlh0NFQz+/uJUl6php0NNQZY+Z3TbJqOCVJkmabQU9DHZXkmiT7J3kFvTfXebQhSXPEoKehfr2NfvoSvZcf/XpVfWGolUmSZo1BT0MtBd4OfBK4B3hLkj2GWZgkafYY9DTU1cB/r6rfBn4B2AjcOLSqJEmzyqBhcWhVXQdQPX8O/IcdrZDk2Um+mOT/Jrk9yZ+09gOT3JBkU5JPJNmtte/e5je15Uv6tnV2a78rybGT+aGSpMnbYVgkeQdAVT2SZOxb7E7r2PZjwJFV9UrgVcBxSQ4H3gOcX1UvAR4CRkdanQE81NrPb/1IchC9Fy29HDgO+ECSXQf7eZKkqdB1ZNH/Nryzxyw7bkcrtiOQ77TZZ7VPAUcCV7T2tcBJbXp5m6ctPypJWvulVfVYVX0N2MQ4r2WVJA1PV1hkgunx5p+8cu9+jFuBB4D1wFeBb1XV6Fv2tgAL2/RCYDNAW/4wsG9/+zjrSJKmQVdY1ATT480/eeWqx6vqVcAiekcDL3tq5Q0uycokG5JsGBkZGdZuJGlO6gqLVyZ5JMm3gYPb9Oj8Tw+6k6r6FvA54LXAXklG7+9YBGxt01uBxQBt+Z7Ag/3t46zTv4/VVbWsqpbNnz9/0NIkSQPYYVhU1a5V9YKqen5VzWvTo/PP2tG6SeYn2atNPwf4ZeBOeqFxcuu2AriqTa9r87Tln62qau2nttFSBwJLgS8+9Z8qSZqsQd9nMRn7A2vbyKVdgMuq6m+T3AFcmuRc4Bbg4tb/YuAjSTYB22gX16vq9iSXAXcA24Ezq+rxIdYtSRpjaGFRVbcBrx6n/W7GGc1UVd8Hxg7PHV12HnDeVNcoSRrMoDflSZLmMMNCktTJsJAkdTIsJEmdDAtJUifDQpLUybCQJHUyLCRJnQwLSVInw0KS1MmwkCR1MiwkSZ0MC0lSJ8NCktTJsJAkdTIsJEmdhhYWSRYn+VySO5LcnuTtrX2fJOuTbGzfe7f2JLkwyaYktyU5pG9bK1r/jUlWTLRPSdJwDPPIYjvwB1V1EHA4cGaSg4CzgOuqailwXZsHOJ7e+7WXAiuBi6AXLsAq4DB6b9hbNRowkqTpMbSwqKp7q+rmNv1t4E5gIbAcWNu6rQVOatPLgUuq53pgryT7A8cC66tqW1U9BKwHjhtW3ZKkJ5uWaxZJltB7H/cNwIKqurctug9Y0KYXApv7VtvS2iZqlyRNk6GHRZLnAZ8Efq+qHulfVlUF1BTtZ2WSDUk2jIyMTMUmJUnNUMMiybPoBcVHq+pTrfn+dnqJ9v1Aa98KLO5bfVFrm6j9CapqdVUtq6pl8+fPn9ofIklz3DBHQwW4GLizqv6ib9E6YHRE0wrgqr72t7ZRUYcDD7fTVdcCxyTZu13YPqa1SZKmybwhbvsI4C3Al5Lc2tr+GHg3cFmSM4B7gFPasmuAE4BNwKPA6QBVtS3JOcCNrd+7qmrbEOuWJI0xtLCoqv8DZILFR43Tv4AzJ9jWGmDN1FUnSXoqvINbktTJsJAkdTIsJEmdDAtJUifDQpLUybCQJHUyLCRJnQwLSVInw0KS1MmwkCR1MiwkSZ0MC0lSJ8NCktTJsJAkdTIsJEmdDAtJUifDQpLUaZjv4F6T5IEkX+5r2yfJ+iQb2/ferT1JLkyyKcltSQ7pW2dF678xyYrx9iVJGq5hHll8GDhuTNtZwHVVtRS4rs0DHA8sbZ+VwEXQCxdgFXAYcCiwajRgJEnTZ2hhUVX/CGwb07wcWNum1wIn9bVfUj3XA3sl2R84FlhfVduq6iFgPU8OIEnSkE33NYsFVXVvm74PWNCmFwKb+/ptaW0TtT9JkpVJNiTZMDIyMrVVS9IcN2MXuKuqgJrC7a2uqmVVtWz+/PlTtVlJEtMfFve300u07wda+1ZgcV+/Ra1tonZJ0jSa7rBYB4yOaFoBXNXX/tY2Kupw4OF2uupa4Jgke7cL28e0NknSNJo3rA0n+Tjwi8B+SbbQG9X0buCyJGcA9wCntO7XACcAm4BHgdMBqmpbknOAG1u/d1XV2IvmkqQhG1pYVNWbJlh01Dh9Czhzgu2sAdZMYWmSpKfIO7glSZ0MC0lSJ8NCktTJsJAkdTIsJEmdDAtJUifDQpLUybCQJHUyLCRJnQwLSVInw0KS1MmwkCR1MiwkSZ0MC0lSJ8NCktTJsJAkddppwiLJcUnuSrIpyVkzXY8kzSU7RVgk2RX4K+B44CDgTUkOmtmqJGnu2CnCAjgU2FRVd1fVD4BLgeUzXJMkzRlDewf3FFsIbO6b3wIc1t8hyUpgZZv9TpK7pqm2mbAf8M3p2lneM117mjP899t5PdP/7X5yogU7S1h0qqrVwOqZrmM6JNlQVctmug5Njv9+O6+5/G+3s5yG2gos7ptf1NokSdNgZwmLG4GlSQ5MshtwKrBuhmuSpDljpzgNVVXbk/xn4FpgV2BNVd0+w2XNpDlxuu0ZzH+/ndec/bdLVc10DZKkWW5nOQ0lSZpBhoUkqZNhIUnqZFhI0oCS/MRM1zBTDItZLsmLkqxJcm6S5yX5myRfTnJ5kiUzXZ92LMkLkvxZko8k+fUxyz4wU3WpW5J9xnz2Bb6YZO8k+8x0fdPNsJj9PkzvPpPvANcDX6H3QMVPA2tmriwN6ENAgE8Cpyb5ZJLd27LDZ64sDeCbwE19nw30Hj10c5ueUxw6O8sluaWqXt2mv1FVLxxvmWanJLdW1av65t8JnACcCKyvqkNmrDjtUJI/AH4Z+MOq+lJr+1pVHTizlc2MneKmvDnuR0leCuwJ7JFkWVVtSPISejcoanbbPckuVfUjgKo6L8lW4B+B581sadqRqvrzJJ8Azk+yGVgFzNm/rg2L2e8dwNXAj4CTgLOTHEwvPFbuaEXNClcDRwJ/P9pQVR9Och/wvhmrSgOpqi3AG5KcCKwH9pjhkmaMp6F2Qkn+Fjhx9K9VzV5J3gZcWVWbOztr1knyMnrXKW4AHgdeXFVfTnJcVX16ZqubXobFLJdkvAcmHgl8FqCqTpzeivRUJHkY+C7wVeDjwOVVNTKzVWkQLejPBO4EXgW8vaquastunmvXmzwNNfstBm4HPkjvfGmAnwH+fCaL0sDuBl4DHA28EfiTJDfRC45PVdW3Z7I47dBvAa+pqu+0YepXJFlSVRfQ++9wTvHIYpZLsgvwdnojaP6wqm5NcndVvWiGS9MAxv4FmuRZ9IY+vwk4uqrmz1hx2qEkt1fVy/vmnwdcAdwBHNk/ym0uMCx2EkkWAecD99O7XvHCjlU0C+xoeHOSParq0emuSYNJ8lng96vq1r62efTub3pzVc2p0YiGxU4myeuAI6rqj2e6FnVL8tKq+n8zXYeeuvYH2vaqum+cZUdU1RdmoKwZY1hIkjr5uA9JUifDQpLUybCQJinJd8bMn5bk/TNVjzRMhoU0Q9rIGmmn4P9YpSFoN3GtAfYDRoDTq+obST4MfB94NfCFJJcCFwDPBr7X+t2V5OX0Hm++G70/6l5fVRun+3dIowwLafKek+TWvvl9gNHHs7wPWFtVa5P8JnAhvQdBAiwCfraqHk/yAuDfV9X2JEcDfwq8Hvgd4IKq+miS3fAJw5phhoU0ed8b866K04Blbfa1wK+16Y8A7+1b7/KqerxN7wmsTbKU3uNcntXa/wV4Zxvr/ymPKjTTvGYhTb/v9k2fA3yuql4B/Cq901FU1cfovSDpe8A1SY6c9iqlPoaFNBz/DJzapt8M/NME/fYEtrbp00Ybk7wIuLuqLgSuAg4eTpnSYAwLaTh+Fzg9yW3AW+g9DHI87wX+LMktPPG08CnAl9s1kVcAlwyzWKmLj/uQJHXyyEKS1MmwkCR1MiwkSZ0MC0lSJ8NCktTJsJAkdTIsJEmdDAtJUqf/D2C6NChgPbnnAAAAAElFTkSuQmCC\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "bSK6yfmUw-3Q"
      },
      "source": [
        "## Usando o matplotlib.pyplot"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 313
        },
        "id": "zFgaeeJBxGbp",
        "outputId": "453a3633-9434-4961-8db2-51b9174f761a"
      },
      "source": [
        "dados['tratamento'].value_counts().plot.bar(title='Tipos de tratamento', xlabel='Tratamento', ylabel='Experimentos', rot=0)\n"
      ],
      "execution_count": 64,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7f6c3f4ee1d0>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 64
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZEAAAEXCAYAAABsyHmSAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAa+UlEQVR4nO3de7hkVX3m8e/LXZGrdBiuaSU4Bg2i9gDeIlEHAU0wXvECDWFER42aaAxmMoEBTYij0TFGDIwIJlEEr6AYZFBIojbQIDY3DT0IAWygoZFGyYDAb/7Y68Ti5JzT1bupc7r6fD/Ps5/atfbaa6+qrq737NuqVBWSJPWx0Vx3QJI0vgwRSVJvhogkqTdDRJLUmyEiSerNEJEk9WaIaCwluSbJAXO4/YVJKskmc9UHaX1giGi9lOSnA9PDSf514Pnrq+opVXXRXPezjyTHJ/nbdWzjgCS3PFp9ejStz33To8+/orReqqrHTcwnuRH4L1X1f+auR7MnSYBU1cNz3RdpTdwT0VhKcmOSF7X545N8Psnnktyb5IokTxuo+6tJLkryk3YY7LcGlh2S5Nq23q1J3j3N9jZO8sEkdya5AXjJpOXbJPlkkhWtnfcl2XiKdg4C/gh4Tdur+n4rvyjJ+5N8G7gPeGKSo5Jc1/p2Q5I3tbpbAl8Hdh7YO9s5yb5Jvtte54okH0uy2cC2K8lbklzf2jwxyR5JvpNkdZKzJtV/aZIrW3vfSbL3pPf/3UmWJbmnvfdbzNC3zZN8JMmP2/SRJJuvxT+51ldV5eS0Xk/AjcCLpisDjgd+DrwS2BR4N/CjNr8psJzui3sz4AXAvcB/bOuuAJ7X5rcDnjFNH94M/ADYDdge+BZQwCZt+ZeAvwa2BH4JuBR40zRtHQ/87aSyi4B/AZ5Cd4RgU7qg2gMI8Hy6cHlGq38AcMukNp4J7N/WXwhcB7xzYHkBXwG2btu5H7gQeCKwDXAtsLjVfTpwB7AfsDGwuL3nmw+8/5cCO7f34zrgzTP07QRgSXtvFgDfAU6c68+W07pP7oloQ3F5VX2+qn4O/AWwBd0X6v7A44CTquqBqvom8FXgtW29nwN7Jdm6qu6uqiumaf/VwEeq6uaqWgX82cSCJDsCh9B9Yf+squ4APgwctpav4fSquqaqHqyqn1fV16rq/1bnYuAbwPOmW7mqLq+qJW39G+lC7fmTqn2gqlZX1TXA1cA3quqGqrqHbg/i6a3eMcBfV9UlVfVQVZ1BFzr7D7T10ar6cXs/zgX2meG1vR44oaruqKqVwP8ADh/yfdF6zBDRhuLmiZnqziXcQvdX8s7AzfXI8ws3Abu0+VfQBcBNSS5O8qxp2t95cButjQm/TLfnsKId+vkJ3Rf4L/V9DQBJDk6yJMmq1uYhwA7TrZzkSUm+muS2JKuBP52i/u0D8/86xfOJc1G/DLxr4vW07e9G9z5MuG1g/r6BdaeyM498z26a1JbGlCGiDcVuEzNJNgJ2BX7cpt1a2YTdgVsBquqyqjqU7gv/y8BZ07S/YnAbrY0JN9P9lb5DVW3bpq2r6inTtDXd0Nn/Vt7OF3wB+CCwY1VtC5xHd2hrujZOpjvktmdVbU13CC9T1BvGzcD7B17PtlX12Kr67BDrTtW3H9MF04TdW5nGnCGiDcUzk7y83bfxTrov9SXAJXR/Jb8nyabt3pLfBM5MslmS1yfZph0GWw1Md0XUWcDbk+yaZDvg2IkFVbWC7lDTh5JsnWSjdsJ68qGkCbcDCycF22SbAZsDK4EHkxwMHDipjccn2WagbKv2Gn6a5MnAf52h/TU5FXhzkv3S2TLJS5JsNcS6U/Xts8AfJ1mQZAfgT4B1usxZ6wdDRBuKrwCvAe6mO9b+8nZe4QG60DgYuBP4OHBEVf2grXc4cGM7/PNmumP3UzkVOB/4PnAF8MVJy4+g++K/tvXh88BO07R1dnu8K8mU52Cq6l7g7XThdTfwOuCcgeU/oPtivqEdbtqZ7oKC19FdOHAq8Llptr9GVbUUeCPwsbb95cCRQ647Vd/eBywFlgFX0b2H7+vbP60/UuWPUmm8JTke+JWqesNc90Wab9wTkST1ZohIknrzcJYkqTf3RCRJvc27ARh32GGHWrhw4Vx3Q5LGyuWXX35nVS2YXD7vQmThwoUsXbp0rrshSWMlyU1TlXs4S5LUmyEiSerNEJEk9WaISJJ6M0QkSb0ZIpKk3gwRSVJvhogkqTdDRJLU27y7Y31cLDz2a3PdhQ3GjSe9ZK67IG2w3BORJPVmiEiSejNEJEm9GSKSpN4MEUlSb4aIJKk3Q0SS1JshIknqzRCRJPVmiEiSejNEJEm9GSKSpN4MEUlSb4aIJKm3kYVIkt2SfCvJtUmuSfKOVr59kguSXN8et2vlSfLRJMuTLEvyjIG2Frf61ydZPFD+zCRXtXU+miSjej2SpH9vlHsiDwLvqqq9gP2BtybZCzgWuLCq9gQubM8BDgb2bNMxwMnQhQ5wHLAfsC9w3ETwtDpvHFjvoBG+HknSJCMLkapaUVVXtPl7geuAXYBDgTNatTOAl7X5Q4FPV2cJsG2SnYAXAxdU1aqquhu4ADioLdu6qpZUVQGfHmhLkjQLZuWcSJKFwNOBS4Adq2pFW3QbsGOb3wW4eWC1W1rZTOW3TFE+1faPSbI0ydKVK1eu02uRJP3CyEMkyeOALwDvrKrVg8vaHkSNug9VdUpVLaqqRQsWLBj15iRp3hhpiCTZlC5A/q6qvtiKb2+HomiPd7TyW4HdBlbftZXNVL7rFOWSpFkyyquzAnwSuK6q/mJg0TnAxBVWi4GvDJQf0a7S2h+4px32Oh84MMl27YT6gcD5bdnqJPu3bR0x0JYkaRZsMsK2nwMcDlyV5MpW9kfAScBZSY4GbgJe3ZadBxwCLAfuA44CqKpVSU4ELmv1TqiqVW3+LcDpwGOAr7dJkjRLRhYiVfVPwHT3bbxwivoFvHWatk4DTpuifCnw1HXopiRpHXjHuiSpN0NEktSbISJJ6s0QkST1ZohIknozRCRJvRkikqTeDBFJUm+GiCSpN0NEktSbISJJ6s0QkST1ZohIknozRCRJvRkikqTeDBFJUm+GiCSpN0NEktSbISJJ6s0QkST1ZohIknozRCRJvRkikqTeDBFJUm+GiCSpN0NEktSbISJJ6s0QkST1ZohIknozRCRJvRkikqTeDBFJUm+GiCSpN0NEktSbISJJ6s0QkST1ZohIknozRCRJvY0sRJKcluSOJFcPlB2f5NYkV7bpkIFl702yPMkPk7x4oPygVrY8ybED5U9Ickkr/1ySzUb1WiRJUxvlnsjpwEFTlH+4qvZp03kASfYCDgOe0tb5eJKNk2wM/BVwMLAX8NpWF+DPW1u/AtwNHD3C1yJJmsLIQqSq/gFYNWT1Q4Ezq+r+qvoRsBzYt03Lq+qGqnoAOBM4NEmAFwCfb+ufAbzsUX0BkqQ1motzIm9Lsqwd7tqule0C3DxQ55ZWNl3544GfVNWDk8qnlOSYJEuTLF25cuWj9Tokad5b6xBJsl2SvXtu72RgD2AfYAXwoZ7trJWqOqWqFlXVogULFszGJiVpXhgqRJJclGTrJNsDVwCnJvmLtd1YVd1eVQ9V1cPAqXSHqwBuBXYbqLprK5uu/C5g2ySbTCqXJM2iYfdEtqmq1cDLgU9X1X7Ai9Z2Y0l2Gnj628DElVvnAIcl2TzJE4A9gUuBy4A925VYm9GdfD+nqgr4FvDKtv5i4Ctr2x9J0rrZZM1VunotAF4N/LdhVkjyWeAAYIcktwDHAQck2Qco4EbgTQBVdU2Ss4BrgQeBt1bVQ62dtwHnAxsDp1XVNW0TfwicmeR9wPeATw75WiRJj5JhQ+QEui/yb1fVZUmeCFw/0wpV9dopiqf9oq+q9wPvn6L8POC8Kcpv4BeHwyRJc2CoEKmqs4GzB57fALxiVJ2SJI2HYU+s75rkS+0O9DuSfCHJrqPunCRp/TbsifVP0Z383rlN57YySdI8NmyILKiqT1XVg206HfCGC0ma54YNkbuSvGFiPKskb6C7V0OSNI8NGyK/Q3d57210d5q/EjhyRH2SJI2JYS/x3bWqfmuwIMlzeOS4VpKkeWbYPZG/HLJMkjSPzLgnkuRZwLOBBUl+f2DR1nR3kEuS5rE1Hc7aDHhcq7fVQPlqfjFulSRpnpoxRKrqYuDiJKdX1U2z1CdJ0pgY9sT65klOARYOrlNVLxhFpyRJ42HYEDkb+ATwv4GHRtcdSdI4GTZEHqyqk0faE0nS2Bn2Et9zk7wlyU5Jtp+YRtozSdJ6b9g9kcXt8Q8Gygp44qPbHUnSOBn290SeMOqOSJLGz7C/J/LYJH/crtAiyZ5JXjrarkmS1ndr83siD9DdvQ5wK/C+kfRIkjQ2hg2RParqA8DPAarqPiAj65UkaSwMGyIPJHkM3cl0kuwB3D+yXkmSxsKwV2cdB/w9sFuSvwOeg78nIknz3rBXZ12Q5Apgf7rDWO+oqjtH2jNJ0npv2MNZALvQDf++GfDrSV4+mi5JksbFUHsiSU4D9gauAR5uxQV8cUT9kiSNgWHPiexfVXuNtCeSpLEz7OGs7yYxRCRJjzDsnsin6YLkNrpLewNUVe09sp5JktZ7w4bIJ4HDgav4xTkRSdI8N2yIrKyqc0baE0nS2Bk2RL6X5DPAuQzcqV5VXp0lSfPYsCHyGLrwOHCgzEt8JWmeG/aO9aNG3RFJ0viZMUSSvKeqPpDkL2mDLw6qqrePrGeSpPXemvZErmuPS0fdEUnS+JkxRKrq3CQbA79WVe+epT5JksbEGu9Yr6qH6IZ+lyTpEYa9OuvKJOcAZwM/myj0El9Jmt+GHTtrC+Au4AXAb7bppTOtkOS0JHckuXqgbPskFyS5vj1u18qT5KNJlidZluQZA+ssbvWvT7J4oPyZSa5q63w0iT/XK0mzbJSX+J4OfIxu3K0JxwIXVtVJSY5tz/8QOBjYs037AScD+yXZnu5XFRfRXR12eZJzquruVueNwCXAecBBwNd79FOS1NNQeyJJnpTkwom9iiR7J/njmdapqn8AVk0qPhQ4o82fAbxsoPzT1VkCbJtkJ+DFwAVVtaoFxwXAQW3Z1lW1pKqKLqhehiRpVg17OOtU4L3AzwGqahlwWI/t7VhVK9r8bcCObX4X4OaBere0spnKb5miXJI0i4YNkcdW1aWTyh5clw23PYh/dwPjKCQ5JsnSJEtXrlw5G5uUpHlh2BC5M8ketC/9JK8EVsy8ypRub4eiaI93tPJbgd0G6u3aymYq33WK8ilV1SlVtaiqFi1YsKBHtyVJUxk2RN4K/DXw5CS3Au8E3txje+cAE1dYLQa+MlB+RLtKa3/gnnbY63zgwCTbtSu5DgTOb8tWJ9m/XZV1xEBbkqRZMuzVWTcAL0qyJbBRVd27pnWSfBY4ANghyS10V1mdBJyV5GjgJuDVrfp5wCHAcuA+4Ki23VVJTgQua/VOqKqJk/VvobsC7DF0V2V5ZZYkzbKhQiTJ4+lC4LlAJfknui/0u6Zbp6peO82iF05Rt+j2dqZq5zTgtCnKlwJPXXPvJUmjMuzhrDOBlcArgFe2+c+NqlOSpPEw7LAnO1XViQPP35fkNaPokCRpfAy7J/KNJIcl2ahNr6Y76S1JmseGDZE3Ap+h+4nc++kOb70pyb1JVo+qc5Kk9duwV2dtNeqOSJLGz7BjZx096fnGSY4bTZckSeNi2MNZL0xyXpKdkjwVWAK4dyJJ89ywh7Ne167GuoruR6leV1XfHmnPJEnrvWEPZ+0JvAP4At2d5ocneewoOyZJWv8NezjrXOC/V9WbgOcD1/OLoUgkSfPUsDcb7ltVq+Hfhij5UJJzR9ctSdI4mHFPJMl7AKpqdZJXTVp85Kg6JUkaD2s6nDX464XvnbTsoEe5L5KkMbOmEMk081M9lyTNM2sKkZpmfqrnkqR5Zk0n1p/WxsYK8JiBcbICbDHSnkmS1nszhkhVbTxbHZEkjZ9h7xORJOnfMUQkSb0ZIpKk3gwRSVJvhogkqTdDRJLUmyEiSerNEJEk9WaISJJ6M0QkSb0ZIpKk3gwRSVJvhogkqTdDRJLUmyEiSerNEJEk9WaISJJ6M0QkSb0ZIpKk3gwRSVJvhogkqbc5CZEkNya5KsmVSZa2su2TXJDk+va4XStPko8mWZ5kWZJnDLSzuNW/PsniuXgtkjSfzeWeyG9U1T5Vtag9Pxa4sKr2BC5szwEOBvZs0zHAydCFDnAcsB+wL3DcRPBIkmbH+nQ461DgjDZ/BvCygfJPV2cJsG2SnYAXAxdU1aqquhu4ADhotjstSfPZXIVIAd9IcnmSY1rZjlW1os3fBuzY5ncBbh5Y95ZWNl25JGmWbDJH231uVd2a5JeAC5L8YHBhVVWSerQ21oLqGIDdd9/90WpWkua9OdkTqapb2+MdwJfozmnc3g5T0R7vaNVvBXYbWH3XVjZd+VTbO6WqFlXVogULFjyaL0WS5rVZD5EkWybZamIeOBC4GjgHmLjCajHwlTZ/DnBEu0prf+CedtjrfODAJNu1E+oHtjJJ0iyZi8NZOwJfSjKx/c9U1d8nuQw4K8nRwE3Aq1v984BDgOXAfcBRAFW1KsmJwGWt3glVtWr2XoYkadZDpKpuAJ42RfldwAunKC/grdO0dRpw2qPdR0nScNanS3wlSWPGEJEk9WaISJJ6M0QkSb0ZIpKk3gwRSVJvhogkqTdDRJLUmyEiSerNEJEk9WaISJJ6M0QkSb0ZIpKk3gwRSVJvhogkqTdDRJLUmyEiSerNEJEk9WaISJJ6M0QkSb0ZIpKk3gwRSVJvhogkqTdDRJLU2yZz3QFJ42XhsV+b6y5sUG486SVz3YV14p6IJKk3Q0SS1JshIknqzRCRJPVmiEiSejNEJEm9GSKSpN4MEUlSb4aIJKk3Q0SS1JshIknqzRCRJPVmiEiSejNEJEm9jX2IJDkoyQ+TLE9y7Fz3R5Lmk7EOkSQbA38FHAzsBbw2yV5z2ytJmj/GOkSAfYHlVXVDVT0AnAkcOsd9kqR5Y9x/2XAX4OaB57cA+02ulOQY4Jj29KdJfjgLfZsPdgDunOtOrEn+fK57oDni5/PR9ctTFY57iAylqk4BTpnrfmxokiytqkVz3Q9pKn4+Z8e4H866Fdht4PmurUySNAvGPUQuA/ZM8oQkmwGHAefMcZ8kad4Y68NZVfVgkrcB5wMbA6dV1TVz3K35xEOEWp/5+ZwFqaq57oMkaUyN++EsSdIcMkQkSb0ZIpKk3gwRrbMkRyb52Fz3Q+ojybZJ3tJjvQOSfHUUfRonhohGJslYX/2neWNbYMoQ8TO8ZobIBijJEUmWJfl+kr9JsjDJN1vZhUl2b/VOT3JykiVJbmh/WZ2W5Lokp69hG0cl+ecklwLPGSg/PcknklwCfCDJPq39ZUm+lGS7Vu8/tbIrk/zPJFe38oVJ/jHJFW169sjeKI3ULH0OD2qfk+8nubCVbZ/ky207S5Ls3cqPb+1e1Lbz9tbMScAeA5/FA9pn8Bzg2iRbJPlUkquSfC/Jb0zRjy1b25e2OvNnDL+qctqAJuApwD8DO7Tn2wPnAovb898BvtzmT6cbtDJ0A1euBn6N7o+Ly4F9ptnGTsC/AAuAzYBvAx8baPOrwMbt+TLg+W3+BOAjbf5q4Flt/iTg6jb/WGCLNr8nsHSu31On9fZzuIBu7LwnTGyjPf4lcFybfwFwZZs/HvgOsDnduFp3AZsCCyc+f63eAcDPBtp9F909aABPbp/9LVq9r7byPwXe0Oa3ba99y7n+d5iNyT2RDc8LgLOr6k6AqloFPAv4TFv+N8BzB+qfW90n/yrg9qq6qqoeBq6h+881lf2Ai6pqZXWjJ39u0vKzq+qhJNsA21bVxa38DODXk2wLbFVV323lnxlYd1Pg1CRXAWfTDfGv8TMbn8P9gX+oqh8NbIPW7t+0sm8Cj0+ydVv2taq6v/XrDmDHadq+dKLd1t7ftvZ+ANwEPGlS/QOBY5NcCVxEFzK7T9P2BsXjfbq/PT48MD/xvO/n42fr0J/fA24Hnkb3l+j/W4e2ND5G8TmcaTsAD83Q9tp+hgO8oqrm3Qjh7olseL4JvCrJ46E7Pky3C39YW/564B/XcRuXAM9P8vgkmwKvmqpSVd0D3J3kea3ocODiqvoJcG+SiWH7DxtYbRtgRfsr9HC64Ww0fmbjc7iEbs/2CQPboLX7+lZ2AHBnVa2eoZ17ga1mWD7Y3pPo9jAmh8X5wO8mSav39LV6JWPMPZENTFVdk+T9wMVJHgK+B/wu8KkkfwCsBI5ax22sSHI88F3gJ8CVM1RfDHwiyWOBGwa2fTTdYauHgYuBe1r5x4EvJDkC+HvWba9Gc2SWPocr0/1W0BeTbER3eOo/0537OC3JMuA+us/gTO3cleTb7eKOrwNfm1Tl48DJ7RDrg8CRVXV/y4sJJwIfAZa1vvwIeOm6vL5x4dhZmhNJHldVP23zxwI7VdU75rhbktaSeyKaKy9J8l66z+BNwJFz2x1Jfbgnohm1+z02n1R8eFVdNRf90fzk53D9ZYhIknrz6ixJUm+GiCSpN0+sS9No9zhc2J7+B7qb01a25/u2u/WnW3cfYOeqOm+0vZx2+wuBZ1fVZ9ZQVVon7olI06iqu6pqn6raB/gE8OGJ51X1QGYe4XUf4JDZ6emUFgKvm8Pta57wxLo0hHZz5U+Bp9INxfJ0uoEnzwT+F91YSf9KdwPdj4DlwGOAW4E/a2WPqFdVP0xyJPAyYEu6ASc/SDeo5eF0Q3QcUlWrkuwB/BXdoIP3AW+sqh+0UW5XA4vo9pbeU1WfT7IE+NW23TOAk9u0iO6Gud+vqm+N4K3SPOPhLGnt7Up3qOihNrDf86rqwSQvAv60ql6R5E+ARVX1NoCp6gGvaO09lS6UtqALnz+sqqcn+TBwBN2d0KcAb66q69twMR+nG+QQulGVn0s3wuw5wOeBY4F3V9VL2/bfBVRV/VqSJwPfSPKkqnJsMq0TQ0Rae2dX1UNtfhvgjCR7AkU3CvFUZqr3raq6l248sXvohkyHbkTbvZM8Dng2cPbAUBuD90x8uY01dm2S6UalfS7dEOm0PZiJkWiXDfWKpWkYItLaGxzP60S6EPjtdjL7omnWmane5FFrB0e03YTu3OVP2rmZqQyun2nqSCPhiXVp3WxDd94DHjl0y+SRYaert0ZtBNofJXkVQDpPW8Nqk7c/zEi00lozRKR18wHgz5J8j0fu2X8L2Kv95OprZqg3rNcDRyf5Pt0PNa3p51eXAQ+1n439PbpzKBu1kWg/RxuJtkc/pEfw6ixJUm/uiUiSejNEJEm9GSKSpN4MEUlSb4aIJKk3Q0SS1JshIknq7f8D0e5bRUo2vDMAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 312
        },
        "id": "KrtM6b-q3YJ7",
        "outputId": "9c3205af-a29c-4827-b935-77a5e44c9eb8"
      },
      "source": [
        "dados['dose'].value_counts().plot.bar(title='Tipos de dose', xlabel='Dose', ylabel='Experimentos', rot=0)\n"
      ],
      "execution_count": 65,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7f6c3f4f6290>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 65
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZEAAAEWCAYAAACnlKo3AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAbWElEQVR4nO3de5QlZX3u8e8DCF65CCMHZjCDOsaAwUtmAYm5uMAg4AWPEkWJDIYjmpBooh6FHBOMSKIeI2qMGgxESJSLqGEwJEgQTI4JyIAIArKYcAkzggx3DAoM/M4f9bZuOt0zm6J37+np72etvbrqrbeqfnvT9DP1Vu2qVBWSJPWxybgLkCTNXYaIJKk3Q0SS1JshIknqzRCRJPVmiEiSejNENCcluTLJi8e4/8VJKslm46pB2hAYItogJfnhwOvhJD8amD+4qnatqgvGXWcfSd6X5O8e4zZenGTVTNU0kzbk2jTz/FeUNkhV9eSJ6SQ3AP+rqv55fBXNniQBUlUPj7sWaX08EtGclOSGJC9p0+9LckaS05Lcm+TSJM8b6PtzSS5IclcbBnvlwLL9k1zV1lud5F3T7G/TJB9JcluS64CXTVq+VZITktzctvOBJJtOsZ19gT8EXteOqr7T2i9IcmySbwL3Ac9I8qYkV7farkvyltb3ScA/AjsOHJ3tmGT3JP/e3ufNST6ZZPOBfVeS30lybdvmMUmemeTfktyT5PRJ/V+e5LK2vX9Lstukz/9dSS5Pcnf77B+/jtq2SPKxJN9vr48l2eJR/CfXhqqqfPnaoF/ADcBLpmsD3gc8CBwIPA54F3B9m34csJLuD/fmwF7AvcDPtnVvBn6lTW8DvHCaGt4KfA/YCXgqcD5QwGZt+VeAvwKeBDwN+Bbwlmm29T7g7ya1XQD8J7Ar3QjB4+iC6plAgF+jC5cXtv4vBlZN2sYvAHu29RcDVwO/P7C8gDOBLdt+7gfOA54BbAVcBSxrfV8A3ArsAWwKLGuf+RYDn/+3gB3b53E18NZ11PZ+4ML22SwA/g04Zty/W74e+8sjEW0sLqmqM6rqQeCjwOPp/qDuCTwZ+GBVPVBVXwe+Cry+rfcgsEuSLavqzqq6dJrtvxb4WFXdVFV3AH82sSDJ9sD+dH+w/6uqbgWOAw56lO/hc1V1ZVWtraoHq+ofquo/qvMN4GvAr0y3clVdUlUXtvVvoAu1X5vU7cNVdU9VXQl8F/haVV1XVXfTHUG8oPU7HPirqrqoqh6qqpPoQmfPgW19oqq+3z6Ps4Dnr+O9HQy8v6purao1wJ8Abxzyc9EGzBDRxuKmiYnqziWsovtX8o7ATfXI8ws3Agvb9GvoAuDGJN9I8ovTbH/HwX20bUz4Gbojh5vb0M9ddH/An9b3PQAk2S/JhUnuaNvcH9huupWTPDvJV5PckuQe4E+n6P+DgekfTTE/cS7qZ4B3Tryftv+d6D6HCbcMTN83sO5UduSRn9mNk7alOcoQ0cZip4mJJJsAi4Dvt9dOrW3C04HVAFV1cVUdQPcH/++B06fZ/s2D+2jbmHAT3b/St6uqrdtry6radZptTXfr7J+0t/MFXwI+AmxfVVsDZ9MNbU23jU/TDbktqaot6YbwMkW/YdwEHDvwfrauqidW1SlDrDtVbd+nC6YJT29tmuMMEW0sfiHJq9v3Nn6f7o/6hcBFdP9KfneSx7XvlrwCODXJ5kkOTrJVGwa7B5juiqjTgbclWZRkG+DIiQVVdTPdUNOfJ9kyySbthPXkoaQJPwAWTwq2yTYHtgDWAGuT7AfsM2kb2ybZaqDtKe09/DDJc4DfXsf21+ezwFuT7JHOk5K8LMlThlh3qtpOAd6bZEGS7YA/Bh7TZc7aMBgi2licCbwOuJNurP3V7bzCA3ShsR9wG/Ap4JCq+l5b743ADW345610Y/dT+SxwDvAd4FLgy5OWH0L3h/+qVsMZwA7TbOuL7eftSaY8B1NV9wJvowuvO4E3AMsHln+P7g/zdW24aUe6CwreQHfhwGeB06bZ/3pV1QrgzcAn2/5XAocOue5UtX0AWAFcDlxB9xl+oG992nCkyodSaW5L8j7gWVX1m+OuRZpvPBKRJPVmiEiSenM4S5LUm0cikqTe5t0NGLfbbrtavHjxuMuQpDnlkksuua2qFkxun3chsnjxYlasWDHuMiRpTkly41TtDmdJknozRCRJvRkikqTeDBFJUm+GiCSpN0NEktSbISJJ6s0QkST1NrIQSXJikluTfHeg7f8m+V6Sy5N8JcnWA8uOSrIyyTVJXjrQvm9rW5nkyIH2nZNc1NpPS7L5qN6LJGlqo/zG+ufoHmhz8kDbucBRVbU2yYeAo4D3JNkFOAjYle65y/+c5Nltnb8Efp3umdkXJ1leVVcBHwKOq6pTk3wGOIzu8aAbhcVH/sO4S9ho3PDBl427BGmjNbIjkar6F+COSW1fq6q1bfZCuudgAxwAnFpV91fV9XRPUdu9vVZW1XXtCXWnAgckCbAX3dPjAE4CXjWq9yJJmto4z4n8FvCPbXohcNPAslWtbbr2bYG7BgJpon1KSQ5PsiLJijVr1sxQ+ZKksYRIkv8DrAU+Pxv7q6rjq2ppVS1dsOC/3YRSktTTrN/FN8mhwMuBveunT8RaDew00G1Ra2Oa9tuBrZNs1o5GBvtLkmbJrB6JJNkXeDfwyqq6b2DRcuCgJFsk2RlYAnwLuBhY0q7E2pzu5PvyFj7nAwe29ZcBZ87W+5AkdUZ5ie8pwL8DP5tkVZLD6K7WegpwbpLL2lVVVNWVwOnAVcA/AUdU1UPtKON3gXOAq4HTW1+A9wDvSLKS7hzJCaN6L5KkqY1sOKuqXj9F87R/6KvqWODYKdrPBs6eov06uqu3JEljMu+ebCjpsfE7TDNrrn+PydueSJJ6M0QkSb0ZIpKk3gwRSVJvhogkqTdDRJLUmyEiSerNEJEk9WaISJJ6M0QkSb0ZIpKk3gwRSVJvhogkqTdDRJLUmyEiSerNEJEk9WaISJJ6M0QkSb0ZIpKk3gwRSVJvhogkqTdDRJLUmyEiSerNEJEk9TayEElyYpJbk3x3oO2pSc5Ncm37uU1rT5JPJFmZ5PIkLxxYZ1nrf22SZQPtv5DkirbOJ5JkVO9FkjS1UR6JfA7Yd1LbkcB5VbUEOK/NA+wHLGmvw4FPQxc6wNHAHsDuwNETwdP6vHlgvcn7kiSN2MhCpKr+BbhjUvMBwElt+iTgVQPtJ1fnQmDrJDsALwXOrao7qupO4Fxg37Zsy6q6sKoKOHlgW5KkWTLb50S2r6qb2/QtwPZteiFw00C/Va1tXe2rpmifUpLDk6xIsmLNmjWP7R1Ikn5ibCfW2xFEzdK+jq+qpVW1dMGCBbOxS0maF2Y7RH7QhqJoP29t7auBnQb6LWpt62pfNEW7JGkWzXaILAcmrrBaBpw50H5Iu0prT+DuNux1DrBPkm3aCfV9gHPasnuS7NmuyjpkYFuSpFmy2ag2nOQU4MXAdklW0V1l9UHg9CSHATcCr23dzwb2B1YC9wFvAqiqO5IcA1zc+r2/qiZO1v8O3RVgTwD+sb0kSbNoZCFSVa+fZtHeU/Qt4IhptnMicOIU7SuA5z6WGiVJj43fWJck9WaISJJ6M0QkSb0ZIpKk3gwRSVJvhogkqTdDRJLUmyEiSerNEJEk9WaISJJ6M0QkSb0ZIpKk3gwRSVJvhogkqTdDRJLUmyEiSerNEJEk9WaISJJ6M0QkSb0ZIpKk3gwRSVJvhogkqTdDRJLUmyEiSertUYdIkm2S7DaKYiRJc8tQIZLkgiRbJnkqcCnw2SQf7bvTJH+Q5Mok301ySpLHJ9k5yUVJViY5Lcnmre8WbX5lW754YDtHtfZrkry0bz2SpH6GPRLZqqruAV4NnFxVewAv6bPDJAuBtwFLq+q5wKbAQcCHgOOq6lnAncBhbZXDgDtb+3GtH0l2aevtCuwLfCrJpn1qkiT1M2yIbJZkB+C1wFdnYL+bAU9IshnwROBmYC/gjLb8JOBVbfqANk9bvneStPZTq+r+qroeWAnsPgO1SZKGNGyIvB84B/iPqro4yTOAa/vssKpWAx8B/pMuPO4GLgHuqqq1rdsqYGGbXgjc1NZd2/pvO9g+xTqPkOTwJCuSrFizZk2fsiVJUxgqRKrqi1W1W1X9dpu/rqpe02eHSbahO4rYGdgReBLdcNTIVNXxVbW0qpYuWLBglLuSpHll2BPri5J8Jcmt7fWlJIt67vMlwPVVtaaqHgS+DLwI2LoNbwEsAla36dXATq2OzYCtgNsH26dYR5I0C4YdzvobYDndkcOOwFmtrY//BPZM8sR2bmNv4CrgfODA1mcZcGabXt7macu/XlXV2g9qV2/tDCwBvtWzJklSD8OGyIKq+puqWttenwN6jQtV1UV0J8gvBa5oNRwPvAd4R5KVdOc8TmirnABs29rfARzZtnMlcDpdAP0TcERVPdSnJklSP5utvwsAtyf5TeCUNv96uiGlXqrqaODoSc3XMcXVVVX1Y+A3ptnOscCxfeuQJD02wx6J/Bbd5b230F1RdSBw6IhqkiTNEcMeiSyqqlcONiR5EY+8xFaSNM8MeyTyF0O2SZLmkXUeiST5ReCXgAVJ3jGwaEu625VIkuax9Q1nbQ48ufV7ykD7Pfz0clxJ0jy1zhCpqm8A30jyuaq6cZZqkiTNEcOeWN8iyfHA4sF1qmqvURQlSZobhg2RLwKfAf4a8At9kiRg+BBZW1WfHmklkqQ5Z9hLfM9K8jtJdkjy1InXSCuTJG3whj0SmbgB4v8eaCvgGTNbjiRpLhkqRKpq51EXIkmae4Z9nsgTk7y3XaFFkiVJXj7a0iRJG7pH8zyRB+i+vQ7dw58+MJKKJElzxrAh8syq+jDwIEBV3QdkZFVJkuaEYUPkgSRPoDuZTpJnAvePrCpJ0pww7NVZR9M9PXCnJJ+neyb6oaMqSpI0Nwx7dda5SS4F9qQbxnp7Vd020sokSRu8YYezABbS3f59c+BXk7x6NCVJkuaKoY5EkpwI7AZcCTzcmgv48ojqkiTNAcOeE9mzqnYZaSWSpDln2OGsf09iiEiSHmHYI5GT6YLkFrpLewNUVe02ssokSRu8YUPkBOCNwBX89JyIJGmeGzZE1lTV8pFWIkmac4Y9J/LtJF9I8vokr5549d1pkq2TnJHke0muTvKL7Rkl5ya5tv3cpvVNkk8kWZnk8iQvHNjOstb/2iTLpt+jJGkUhg2RJ9CdC9kHeEV7PZa7+H4c+Keqeg7wPOBq4EjgvKpaApzX5gH2A5a01+HApwHaQ7GOBvYAdgeOnggeSdLsGPYb62+aqR0m2Qr4VdptU6rqAbp7cx0AvLh1Owm4AHgPcABwclUVcGE7itmh9T23qu5o2z0X2Bc4ZaZqlSSt2zpDJMm7q+rDSf6CdvPFQVX1th773BlYA/xNkucBlwBvB7avqptbn1uA7dv0QuCmgfVXtbbp2iVJs2R9RyJXt58rZnifLwR+r6ouSvJxfjp0BXTXDif5b6HVV5LD6YbCePrTnz5Tm5WkeW+dIVJVZyXZFPj5qnrXDO1zFbCqqi5q82fQhcgPkuxQVTe34apb2/LVwE4D6y9qbav56fDXRPsF07yP44HjAZYuXTpj4SRJ8916T6xX1UN0t36fEVV1C3BTkp9tTXsDVwHLgYkrrJYBZ7bp5cAh7SqtPYG727DXOcA+SbZpJ9T3aW2SpFky7PdELkuyHPgi8F8TjVXV9waMvwd8PsnmwHXAm+gC7fQkhwE3Aq9tfc8G9gdWAve1vlTVHUmOAS5u/d4/cZJdkjQ7hg2RxwO3A3sNtPW+i29VXQYsnWLR3lP0LeCIabZzInBinxokSY/drF/iK0naeAz1ZcMkz05yXpLvtvndkrx3tKVJkjZ0w35j/bPAUcCDAFV1OXDQqIqSJM0Nw4bIE6vqW5Pa1s50MZKkuWXYELktyTNp31pPciBw87pXkSRt7Ia9OusIui/rPSfJauB64OCRVSVJmhOGvTrrOuAlSZ4EbFJV9462LEnSXDDs1VnbJvkE8K/ABUk+nmTb0ZYmSdrQDXtO5FS6O+++BjiwTZ82qqIkSXPDsOdEdqiqYwbmP5DkdaMoSJI0dwx7JPK1JAcl2aS9Xos3O5SkeW/YEHkz8AW6R+TeTze89ZYk9ya5Z1TFSZI2bMNenfWUURciSZp7hr0667BJ85smOXo0JUmS5ophh7P2TnJ2kh2SPBe4EPDoRJLmuWGHs97Qrsa6gu6hVG+oqm+OtDJJ0gZv2OGsJcDbgS/RPXXwjUmeOMrCJEkbvmGHs84C/qiq3gL8GnAtP30srSRpnhr2y4a7V9U98JPH1f55krNGV5YkaS5Y55FIkncDVNU9SX5j0uJDR1WUJGluWN9w1uDTC4+atGzfGa5FkjTHrC9EMs30VPOSpHlmfSFS00xPNS9JmmfWd2L9ee3eWAGeMHCfrACPH2llkqQN3jpDpKo2na1CJElzz7DfE5lx7f5b307y1Ta/c5KLkqxMclqSzVv7Fm1+ZVu+eGAbR7X2a5K8dDzvRJLmr7GFCN034K8emP8QcFxVPQu4E5i46eNhwJ2t/bjWjyS70F09tivdlWKfSuKRkyTNorGESJJFwMuAv27zAfYCzmhdTgJe1aYPaPO05Xu3/gcAp1bV/VV1PbAS2H123oEkCcZ3JPIx4N3Aw21+W+Cuqlrb5lcBC9v0QuAmgLb87tb/J+1TrCNJmgWzHiJJXg7cWlWXzOI+D0+yIsmKNWvWzNZuJWmjN44jkRcBr0xyA91jdvcCPg5snWTiarFFwOo2vRrYCaAt3wq4fbB9inUeoaqOr6qlVbV0wYIFM/tuJGkem/UQqaqjqmpRVS2mOzH+9ao6GDgfOLB1Wwac2aaXt3na8q+3m0AuBw5qV2/tDCwBvjVLb0OSxPB38Z0N7wFOTfIB4NvACa39BOBvk6wE7qDdz6uqrkxyOnAVsBY4oqoemv2yJWn+GmuIVNUFwAVt+jqmuLqqqn4MTL6D8MSyY4FjR1ehJGldxvk9EUnSHGeISJJ6M0QkSb0ZIpKk3gwRSVJvhogkqTdDRJLUmyEiSerNEJEk9WaISJJ6M0QkSb0ZIpKk3gwRSVJvhogkqTdDRJLUmyEiSerNEJEk9WaISJJ6M0QkSb0ZIpKk3gwRSVJvhogkqTdDRJLUmyEiSerNEJEk9WaISJJ6m/UQSbJTkvOTXJXkyiRvb+1PTXJukmvbz21ae5J8IsnKJJcneeHAtpa1/tcmWTbb70WS5rtxHImsBd5ZVbsAewJHJNkFOBI4r6qWAOe1eYD9gCXtdTjwaehCBzga2APYHTh6IngkSbNj1kOkqm6uqkvb9L3A1cBC4ADgpNbtJOBVbfoA4OTqXAhsnWQH4KXAuVV1R1XdCZwL7DuLb0WS5r2xnhNJshh4AXARsH1V3dwW3QJs36YXAjcNrLaqtU3XPtV+Dk+yIsmKNWvWzFj9kjTfjS1EkjwZ+BLw+1V1z+CyqiqgZmpfVXV8VS2tqqULFiyYqc1K0rw3lhBJ8ji6APl8VX25Nf+gDVPRft7a2lcDOw2svqi1TdcuSZol47g6K8AJwNVV9dGBRcuBiSuslgFnDrQf0q7S2hO4uw17nQPsk2SbdkJ9n9YmSZolm41hny8C3ghckeSy1vaHwAeB05McBtwIvLYtOxvYH1gJ3Ae8CaCq7khyDHBx6/f+qrpjdt6CJAnGECJV9f+ATLN47yn6F3DENNs6EThx5qqTJD0afmNdktSbISJJ6s0QkST1ZohIknozRCRJvRkikqTeDBFJUm+GiCSpN0NEktSbISJJ6s0QkST1ZohIknozRCRJvRkikqTeDBFJUm+GiCSpN0NEktSbISJJ6s0QkST1ZohIknozRCRJvRkikqTeDBFJUm+GiCSpN0NEktTbnA+RJPsmuSbJyiRHjrseSZpP5nSIJNkU+EtgP2AX4PVJdhlvVZI0f8zpEAF2B1ZW1XVV9QBwKnDAmGuSpHljs3EX8BgtBG4amF8F7DG5U5LDgcPb7A+TXDMLtc0H2wG3jbuI9cmHxl2BxsTfz5n1M1M1zvUQGUpVHQ8cP+46NjZJVlTV0nHXIU3F38/ZMdeHs1YDOw3ML2ptkqRZMNdD5GJgSZKdk2wOHAQsH3NNkjRvzOnhrKpam+R3gXOATYETq+rKMZc1nzhEqA2Zv5+zIFU17hokSXPUXB/OkiSNkSEiSerNENF6JXkoyWVJrkzynSTvTLJJW7ZtkvOT/DDJJ8ddq+af9fx+/nqSS5Jc0X7uNe56NzZz+sS6Zs2Pqur5AEmeBnwB2BI4Gvgx8EfAc9tLmm3r+v28DXhFVX0/yXPpLsJZOLZKN0KeWNd6JflhVT15YP4ZdJdXb1ftFyjJocDSqvrd8VSp+WqY38/WHuB2YIequn/2K904OZylR62qrqO7pPpp465Fmmwdv5+vAS41QGaWw1mSNnpJdgU+BOwz7lo2Nh6J6FFrwwUPAbeOuxZpssm/n0kWAV8BDqmq/xhnbRsjQ0SPSpIFwGeAT5Yn1LSBmfz7mWRr4B+AI6vqm+OtbuPkiXWtV5KHgCuAxwFrgb8FPlpVD7flN9BdDbM5cBewT1VdNZ5qNd+s6/czyXuBo4BrB1bZp6o8ip4hhogkqTeHsyRJvRkikqTeDBFJUm+GiCSpN0NEktSb31iXppFkW+C8Nvs/6L7AtqbN715VD6xj3ecDO1bV2aOtctr9LwZ+qaq+MI79a/7wSESaRlXdXlXPb3eI/Qxw3MR8VT2QZF3/CHs+sP/sVDqlxcAbxrh/zRN+T0QaQpL3AT+ku939j4EXAN8ETgU+Djwe+BHwJuB6YCXwBGA18Get7RH9quqadvfjVwFPApYAH6H70uYbgfuB/avqjiTPBP4SWADcB7y5qr6X5HPAPcBSuqOld1fVGUkuBH6u7fck4NPttZTuC3nvqKrzR/BRaZ5xOEt69BbRDRU9lGRL4Feqam2SlwB/WlWvSfLHDNwaf6p+dHeVhS6YXkAXMCuB91TVC5IcBxwCfAw4HnhrVV2bZA/gU8DEA5Z2AH4ZeA6wHDgDOBJ4V1W9vO3/nUBV1c8neQ7wtSTPrqofj/Bz0jxgiEiP3her6qE2vRVwUpIlQNHdemMq6+p3flXdC9yb5G7grNZ+BbBbkicDvwR8sXskBgBbDKz/9+0WNFcl2X6a/f8y8BcA7QjmRuDZwOVDvWNpGoaI9Oj918D0MXQh8D/byewLpllnXf0Gn2/x8MD8w3T/j24C3DXx9L4pDK6fafpII+GJdemx2YruvAfAoQPt9wJPGaLfelXVPcD1SX4Duif0JXneelabvP9/BQ5u6z8beDpwzaOpQ5qKISI9Nh8G/izJt3nkkf35wC5JLkvyunX0G9bBwGFJvgNcCRywnv6XAw8l+U6SP6A7h7JJkiuA04BDfcKfZoJXZ0mSevNIRJLUmyEiSerNEJEk9WaISJJ6M0QkSb0ZIpKk3gwRSVJv/x+YHdDpoTnMKQAAAABJRU5ErkJggg==\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "oA3izonTuhvm"
      },
      "source": [
        "#Desafio 08: Resumo do que você aprendeu com os dados.\n",
        "\n",
        "1. Foram realizados 23814 experimentos, onde 3289 drogas foram analisadas em \n",
        "culturas com o uso da droga ou com controle; \n",
        "\n",
        "2. As culturas com o uso de alguma droga totalizaram 1866 experimentos (92,16% dos experimentos);\n",
        "\n",
        "3. As culturas com droga e com controle têm praticamente a mesma distribuição de observação em horas (tempo);\n",
        "\n",
        "4. Dois tipos de doses D1 e D2 foram administradas, onde 51% dos experimentos foram com D1 e 49% foram com D2. Essa mesma distribuição foi observada para casos de tratamento com droga e com controle.\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "cV0cebOk3wQj",
        "outputId": "a83ab807-2ae3-4bed-91f0-35c95017bd1f"
      },
      "source": [
        "c_droga = dados.query('tratamento == \"com_droga\"')\n",
        "c_droga['tempo'].value_counts(normalize = True)"
      ],
      "execution_count": 76,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "48    0.346364\n",
              "72    0.327137\n",
              "24    0.326499\n",
              "Name: tempo, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 76
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "3ST6t03z70CY",
        "outputId": "964d2ff3-572b-4a92-8083-73a5eab4153d"
      },
      "source": [
        "c_droga['dose'].value_counts(normalize = True)"
      ],
      "execution_count": 77,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "D1    0.510115\n",
              "D2    0.489885\n",
              "Name: dose, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 77
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "GuJ0R5tN6hVN",
        "outputId": "a173bf59-cae9-434b-9bee-6776f4a34a0f"
      },
      "source": [
        "c_controle = dados.query('tratamento == \"com_controle\"')\n",
        "c_controle['tempo'].value_counts(normalize = True)"
      ],
      "execution_count": 73,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "48    0.347267\n",
              "72    0.327974\n",
              "24    0.324759\n",
              "Name: tempo, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 73
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "R7NvGR-a74j1",
        "outputId": "d6ee1b2a-426c-4439-915d-e11fb99f8ac0"
      },
      "source": [
        "c_controle['dose'].value_counts(normalize = True)"
      ],
      "execution_count": 78,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "D1    0.509646\n",
              "D2    0.490354\n",
              "Name: dose, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 78
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "nl8ZQekt7Aex",
        "outputId": "33aa32fa-addb-47ac-d1cf-1559d48118d4"
      },
      "source": [
        "dados['dose'].value_counts(normalize = True)"
      ],
      "execution_count": 74,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "D1    0.510078\n",
              "D2    0.489922\n",
              "Name: dose, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 74
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Ag0snC2d7e3V"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}