cap3_1_preprocessamento_dados.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "cap3_1_preprocessamento_dados.ipynb",
      "provenance": [],
      "authorship_tag": "ABX9TyNBlRLeXcP/X9QKF34KfSLk",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/viniciusrpb/cic0193_machinelearning/blob/main/cap3_1_preprocessamento_dados.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "fSakzQsCj3wi"
      },
      "source": [
        "# Capítulo 3\n",
        "\n",
        "## 3.1. Pré-processamento de dados tabulares\n",
        "\n",
        "Informações sobre o conjunto de dados podem ser acessadas aqui:\n",
        "\n",
        "https://archive.ics.uci.edu/ml/datasets/Codon+usage#\n",
        "\n",
        "É um conjunto de dados que pode ser utilizado para classificar microorganismos (vírus, bactérias, protozoários etc) em reino conforme suas características de sequenciamento de RNA."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "PiMASoC3qcUm"
      },
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n",
        "from sklearn import preprocessing"
      ],
      "execution_count": 39,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "K8LpQRP1mRMw"
      },
      "source": [
        "Primeiro, carregamos o arquivo .CSV associado ao conjunto de dados para um DataFrame:"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "nTJVXkEnq5IK"
      },
      "source": [
        "rawData = pd.read_csv('/datasets/tabular/codon_usage.csv')"
      ],
      "execution_count": 40,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "7mWIfi5tmdJo"
      },
      "source": [
        "Apresentação dos dados em um modelo tabular:"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 689
        },
        "id": "0o-1jy2wq-oh",
        "outputId": "b49ba962-1092-4928-f529-e47c010ee0d2"
      },
      "source": [
        "rawData"
      ],
      "execution_count": 41,
      "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>Kingdom</th>\n",
              "      <th>DNAtype</th>\n",
              "      <th>SpeciesID</th>\n",
              "      <th>Ncodons</th>\n",
              "      <th>SpeciesName</th>\n",
              "      <th>UUU</th>\n",
              "      <th>UUC</th>\n",
              "      <th>UUA</th>\n",
              "      <th>UUG</th>\n",
              "      <th>CUU</th>\n",
              "      <th>CUC</th>\n",
              "      <th>CUA</th>\n",
              "      <th>CUG</th>\n",
              "      <th>AUU</th>\n",
              "      <th>AUC</th>\n",
              "      <th>AUA</th>\n",
              "      <th>AUG</th>\n",
              "      <th>GUU</th>\n",
              "      <th>GUC</th>\n",
              "      <th>GUA</th>\n",
              "      <th>GUG</th>\n",
              "      <th>GCU</th>\n",
              "      <th>GCC</th>\n",
              "      <th>GCA</th>\n",
              "      <th>GCG</th>\n",
              "      <th>CCU</th>\n",
              "      <th>CCC</th>\n",
              "      <th>CCA</th>\n",
              "      <th>CCG</th>\n",
              "      <th>UGG</th>\n",
              "      <th>GGU</th>\n",
              "      <th>GGC</th>\n",
              "      <th>GGA</th>\n",
              "      <th>GGG</th>\n",
              "      <th>UCU</th>\n",
              "      <th>UCC</th>\n",
              "      <th>UCA</th>\n",
              "      <th>UCG</th>\n",
              "      <th>AGU</th>\n",
              "      <th>AGC</th>\n",
              "      <th>ACU</th>\n",
              "      <th>ACC</th>\n",
              "      <th>ACA</th>\n",
              "      <th>ACG</th>\n",
              "      <th>UAU</th>\n",
              "      <th>UAC</th>\n",
              "      <th>CAA</th>\n",
              "      <th>CAG</th>\n",
              "      <th>AAU</th>\n",
              "      <th>AAC</th>\n",
              "      <th>UGU</th>\n",
              "      <th>UGC</th>\n",
              "      <th>CAU</th>\n",
              "      <th>CAC</th>\n",
              "      <th>AAA</th>\n",
              "      <th>AAG</th>\n",
              "      <th>CGU</th>\n",
              "      <th>CGC</th>\n",
              "      <th>CGA</th>\n",
              "      <th>CGG</th>\n",
              "      <th>AGA</th>\n",
              "      <th>AGG</th>\n",
              "      <th>GAU</th>\n",
              "      <th>GAC</th>\n",
              "      <th>GAA</th>\n",
              "      <th>GAG</th>\n",
              "      <th>UAA</th>\n",
              "      <th>UAG</th>\n",
              "      <th>UGA</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>vrl</td>\n",
              "      <td>0.0</td>\n",
              "      <td>100217.0</td>\n",
              "      <td>1995.0</td>\n",
              "      <td>Epizootic haematopoietic necrosis virus</td>\n",
              "      <td>0.01654</td>\n",
              "      <td>0.01203</td>\n",
              "      <td>0.00050</td>\n",
              "      <td>0.00351</td>\n",
              "      <td>0.01203</td>\n",
              "      <td>0.03208</td>\n",
              "      <td>0.00100</td>\n",
              "      <td>0.04010</td>\n",
              "      <td>0.00551</td>\n",
              "      <td>0.02005</td>\n",
              "      <td>0.00752</td>\n",
              "      <td>0.02506</td>\n",
              "      <td>0.01103</td>\n",
              "      <td>0.04110</td>\n",
              "      <td>0.00902</td>\n",
              "      <td>0.03308</td>\n",
              "      <td>0.01003</td>\n",
              "      <td>0.05013</td>\n",
              "      <td>0.01554</td>\n",
              "      <td>0.01103</td>\n",
              "      <td>0.02356</td>\n",
              "      <td>0.03208</td>\n",
              "      <td>0.01203</td>\n",
              "      <td>0.00501</td>\n",
              "      <td>0.01003</td>\n",
              "      <td>0.01203</td>\n",
              "      <td>0.03158</td>\n",
              "      <td>0.01905</td>\n",
              "      <td>0.02456</td>\n",
              "      <td>0.01353</td>\n",
              "      <td>0.02155</td>\n",
              "      <td>0.00251</td>\n",
              "      <td>0.00652</td>\n",
              "      <td>0.00150</td>\n",
              "      <td>0.01554</td>\n",
              "      <td>0.00501</td>\n",
              "      <td>0.02105</td>\n",
              "      <td>0.00902</td>\n",
              "      <td>0.01053</td>\n",
              "      <td>0.00501</td>\n",
              "      <td>0.02256</td>\n",
              "      <td>0.00301</td>\n",
              "      <td>0.03108</td>\n",
              "      <td>0.00401</td>\n",
              "      <td>0.02607</td>\n",
              "      <td>0.00251</td>\n",
              "      <td>0.01153</td>\n",
              "      <td>0.00501</td>\n",
              "      <td>0.02356</td>\n",
              "      <td>0.01053</td>\n",
              "      <td>0.03860</td>\n",
              "      <td>0.00401</td>\n",
              "      <td>0.00702</td>\n",
              "      <td>0.00401</td>\n",
              "      <td>0.00451</td>\n",
              "      <td>0.01303</td>\n",
              "      <td>0.03559</td>\n",
              "      <td>0.01003</td>\n",
              "      <td>0.04612</td>\n",
              "      <td>0.01203</td>\n",
              "      <td>0.04361</td>\n",
              "      <td>0.00251</td>\n",
              "      <td>0.00050</td>\n",
              "      <td>0.00000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>vrl</td>\n",
              "      <td>0.0</td>\n",
              "      <td>100220.0</td>\n",
              "      <td>1474.0</td>\n",
              "      <td>Bohle iridovirus</td>\n",
              "      <td>0.02714</td>\n",
              "      <td>0.01357</td>\n",
              "      <td>0.00068</td>\n",
              "      <td>0.00678</td>\n",
              "      <td>0.00407</td>\n",
              "      <td>0.02849</td>\n",
              "      <td>0.00204</td>\n",
              "      <td>0.04410</td>\n",
              "      <td>0.01153</td>\n",
              "      <td>0.02510</td>\n",
              "      <td>0.00882</td>\n",
              "      <td>0.03324</td>\n",
              "      <td>0.00814</td>\n",
              "      <td>0.04071</td>\n",
              "      <td>0.00814</td>\n",
              "      <td>0.03256</td>\n",
              "      <td>0.01085</td>\n",
              "      <td>0.04885</td>\n",
              "      <td>0.01221</td>\n",
              "      <td>0.01357</td>\n",
              "      <td>0.00678</td>\n",
              "      <td>0.02714</td>\n",
              "      <td>0.01221</td>\n",
              "      <td>0.00407</td>\n",
              "      <td>0.01425</td>\n",
              "      <td>0.01221</td>\n",
              "      <td>0.01967</td>\n",
              "      <td>0.02239</td>\n",
              "      <td>0.01289</td>\n",
              "      <td>0.02103</td>\n",
              "      <td>0.01493</td>\n",
              "      <td>0.00407</td>\n",
              "      <td>0.00475</td>\n",
              "      <td>0.00068</td>\n",
              "      <td>0.02035</td>\n",
              "      <td>0.00950</td>\n",
              "      <td>0.02782</td>\n",
              "      <td>0.01425</td>\n",
              "      <td>0.00611</td>\n",
              "      <td>0.00475</td>\n",
              "      <td>0.02917</td>\n",
              "      <td>0.00407</td>\n",
              "      <td>0.02374</td>\n",
              "      <td>0.00882</td>\n",
              "      <td>0.02917</td>\n",
              "      <td>0.00271</td>\n",
              "      <td>0.01628</td>\n",
              "      <td>0.00204</td>\n",
              "      <td>0.01967</td>\n",
              "      <td>0.00543</td>\n",
              "      <td>0.03392</td>\n",
              "      <td>0.00136</td>\n",
              "      <td>0.00678</td>\n",
              "      <td>0.00136</td>\n",
              "      <td>0.00136</td>\n",
              "      <td>0.01696</td>\n",
              "      <td>0.03596</td>\n",
              "      <td>0.01221</td>\n",
              "      <td>0.04545</td>\n",
              "      <td>0.01560</td>\n",
              "      <td>0.04410</td>\n",
              "      <td>0.00271</td>\n",
              "      <td>0.00068</td>\n",
              "      <td>0.00000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>vrl</td>\n",
              "      <td>0.0</td>\n",
              "      <td>100755.0</td>\n",
              "      <td>4862.0</td>\n",
              "      <td>Sweet potato leaf curl virus</td>\n",
              "      <td>0.01974</td>\n",
              "      <td>0.02180</td>\n",
              "      <td>0.01357</td>\n",
              "      <td>0.01543</td>\n",
              "      <td>0.00782</td>\n",
              "      <td>0.01111</td>\n",
              "      <td>0.01028</td>\n",
              "      <td>0.01193</td>\n",
              "      <td>0.02283</td>\n",
              "      <td>0.01604</td>\n",
              "      <td>0.01316</td>\n",
              "      <td>0.02180</td>\n",
              "      <td>0.01625</td>\n",
              "      <td>0.01872</td>\n",
              "      <td>0.01213</td>\n",
              "      <td>0.01070</td>\n",
              "      <td>0.02406</td>\n",
              "      <td>0.01234</td>\n",
              "      <td>0.01440</td>\n",
              "      <td>0.00514</td>\n",
              "      <td>0.01604</td>\n",
              "      <td>0.01460</td>\n",
              "      <td>0.02098</td>\n",
              "      <td>0.01070</td>\n",
              "      <td>0.01728</td>\n",
              "      <td>0.01851</td>\n",
              "      <td>0.00864</td>\n",
              "      <td>0.01172</td>\n",
              "      <td>0.01892</td>\n",
              "      <td>0.01933</td>\n",
              "      <td>0.01419</td>\n",
              "      <td>0.01296</td>\n",
              "      <td>0.00967</td>\n",
              "      <td>0.01337</td>\n",
              "      <td>0.01337</td>\n",
              "      <td>0.01851</td>\n",
              "      <td>0.01131</td>\n",
              "      <td>0.01419</td>\n",
              "      <td>0.01090</td>\n",
              "      <td>0.02612</td>\n",
              "      <td>0.01275</td>\n",
              "      <td>0.01522</td>\n",
              "      <td>0.02365</td>\n",
              "      <td>0.02962</td>\n",
              "      <td>0.01789</td>\n",
              "      <td>0.01625</td>\n",
              "      <td>0.01234</td>\n",
              "      <td>0.01604</td>\n",
              "      <td>0.01687</td>\n",
              "      <td>0.02077</td>\n",
              "      <td>0.03949</td>\n",
              "      <td>0.00864</td>\n",
              "      <td>0.00596</td>\n",
              "      <td>0.00926</td>\n",
              "      <td>0.00596</td>\n",
              "      <td>0.01974</td>\n",
              "      <td>0.02489</td>\n",
              "      <td>0.03126</td>\n",
              "      <td>0.02036</td>\n",
              "      <td>0.02242</td>\n",
              "      <td>0.02468</td>\n",
              "      <td>0.00391</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00144</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>vrl</td>\n",
              "      <td>0.0</td>\n",
              "      <td>100880.0</td>\n",
              "      <td>1915.0</td>\n",
              "      <td>Northern cereal mosaic virus</td>\n",
              "      <td>0.01775</td>\n",
              "      <td>0.02245</td>\n",
              "      <td>0.01619</td>\n",
              "      <td>0.00992</td>\n",
              "      <td>0.01567</td>\n",
              "      <td>0.01358</td>\n",
              "      <td>0.00940</td>\n",
              "      <td>0.01723</td>\n",
              "      <td>0.02402</td>\n",
              "      <td>0.02245</td>\n",
              "      <td>0.02507</td>\n",
              "      <td>0.02924</td>\n",
              "      <td>0.02089</td>\n",
              "      <td>0.02141</td>\n",
              "      <td>0.01723</td>\n",
              "      <td>0.01932</td>\n",
              "      <td>0.02141</td>\n",
              "      <td>0.00679</td>\n",
              "      <td>0.02245</td>\n",
              "      <td>0.00522</td>\n",
              "      <td>0.01358</td>\n",
              "      <td>0.00418</td>\n",
              "      <td>0.01410</td>\n",
              "      <td>0.00574</td>\n",
              "      <td>0.01201</td>\n",
              "      <td>0.00992</td>\n",
              "      <td>0.00366</td>\n",
              "      <td>0.02402</td>\n",
              "      <td>0.02663</td>\n",
              "      <td>0.02872</td>\n",
              "      <td>0.00992</td>\n",
              "      <td>0.02350</td>\n",
              "      <td>0.00522</td>\n",
              "      <td>0.01619</td>\n",
              "      <td>0.00836</td>\n",
              "      <td>0.02037</td>\n",
              "      <td>0.01358</td>\n",
              "      <td>0.02089</td>\n",
              "      <td>0.00731</td>\n",
              "      <td>0.02141</td>\n",
              "      <td>0.00888</td>\n",
              "      <td>0.01567</td>\n",
              "      <td>0.01253</td>\n",
              "      <td>0.02298</td>\n",
              "      <td>0.01358</td>\n",
              "      <td>0.00992</td>\n",
              "      <td>0.00888</td>\n",
              "      <td>0.00783</td>\n",
              "      <td>0.00679</td>\n",
              "      <td>0.03133</td>\n",
              "      <td>0.04282</td>\n",
              "      <td>0.00627</td>\n",
              "      <td>0.00261</td>\n",
              "      <td>0.00261</td>\n",
              "      <td>0.00366</td>\n",
              "      <td>0.01410</td>\n",
              "      <td>0.01671</td>\n",
              "      <td>0.03760</td>\n",
              "      <td>0.01932</td>\n",
              "      <td>0.03029</td>\n",
              "      <td>0.03446</td>\n",
              "      <td>0.00261</td>\n",
              "      <td>0.00157</td>\n",
              "      <td>0.00000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>vrl</td>\n",
              "      <td>0.0</td>\n",
              "      <td>100887.0</td>\n",
              "      <td>22831.0</td>\n",
              "      <td>Soil-borne cereal mosaic virus</td>\n",
              "      <td>0.02816</td>\n",
              "      <td>0.01371</td>\n",
              "      <td>0.00767</td>\n",
              "      <td>0.03679</td>\n",
              "      <td>0.01380</td>\n",
              "      <td>0.00548</td>\n",
              "      <td>0.00473</td>\n",
              "      <td>0.02076</td>\n",
              "      <td>0.02716</td>\n",
              "      <td>0.00867</td>\n",
              "      <td>0.01310</td>\n",
              "      <td>0.02773</td>\n",
              "      <td>0.02803</td>\n",
              "      <td>0.00508</td>\n",
              "      <td>0.00920</td>\n",
              "      <td>0.02965</td>\n",
              "      <td>0.02878</td>\n",
              "      <td>0.00574</td>\n",
              "      <td>0.01572</td>\n",
              "      <td>0.01577</td>\n",
              "      <td>0.01007</td>\n",
              "      <td>0.00508</td>\n",
              "      <td>0.00604</td>\n",
              "      <td>0.00679</td>\n",
              "      <td>0.01205</td>\n",
              "      <td>0.03127</td>\n",
              "      <td>0.00775</td>\n",
              "      <td>0.00959</td>\n",
              "      <td>0.00797</td>\n",
              "      <td>0.02006</td>\n",
              "      <td>0.00359</td>\n",
              "      <td>0.00933</td>\n",
              "      <td>0.01191</td>\n",
              "      <td>0.01616</td>\n",
              "      <td>0.00788</td>\n",
              "      <td>0.02593</td>\n",
              "      <td>0.00854</td>\n",
              "      <td>0.01200</td>\n",
              "      <td>0.02098</td>\n",
              "      <td>0.02089</td>\n",
              "      <td>0.01367</td>\n",
              "      <td>0.01502</td>\n",
              "      <td>0.01809</td>\n",
              "      <td>0.02738</td>\n",
              "      <td>0.01796</td>\n",
              "      <td>0.01082</td>\n",
              "      <td>0.00705</td>\n",
              "      <td>0.01174</td>\n",
              "      <td>0.00858</td>\n",
              "      <td>0.03408</td>\n",
              "      <td>0.03964</td>\n",
              "      <td>0.00950</td>\n",
              "      <td>0.00429</td>\n",
              "      <td>0.00578</td>\n",
              "      <td>0.00604</td>\n",
              "      <td>0.01494</td>\n",
              "      <td>0.01734</td>\n",
              "      <td>0.04148</td>\n",
              "      <td>0.02483</td>\n",
              "      <td>0.03359</td>\n",
              "      <td>0.03679</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00044</td>\n",
              "      <td>0.00131</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13024</th>\n",
              "      <td>pri</td>\n",
              "      <td>0.0</td>\n",
              "      <td>9601.0</td>\n",
              "      <td>1097.0</td>\n",
              "      <td>Pongo pygmaeus abelii</td>\n",
              "      <td>0.02552</td>\n",
              "      <td>0.03555</td>\n",
              "      <td>0.00547</td>\n",
              "      <td>0.01367</td>\n",
              "      <td>0.01276</td>\n",
              "      <td>0.02097</td>\n",
              "      <td>0.00820</td>\n",
              "      <td>0.03555</td>\n",
              "      <td>0.01459</td>\n",
              "      <td>0.03920</td>\n",
              "      <td>0.01003</td>\n",
              "      <td>0.02097</td>\n",
              "      <td>0.00912</td>\n",
              "      <td>0.02005</td>\n",
              "      <td>0.01003</td>\n",
              "      <td>0.03737</td>\n",
              "      <td>0.02279</td>\n",
              "      <td>0.01367</td>\n",
              "      <td>0.01094</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.01641</td>\n",
              "      <td>0.01094</td>\n",
              "      <td>0.01185</td>\n",
              "      <td>0.00182</td>\n",
              "      <td>0.01094</td>\n",
              "      <td>0.00456</td>\n",
              "      <td>0.01276</td>\n",
              "      <td>0.01094</td>\n",
              "      <td>0.01276</td>\n",
              "      <td>0.02097</td>\n",
              "      <td>0.01003</td>\n",
              "      <td>0.01003</td>\n",
              "      <td>0.00091</td>\n",
              "      <td>0.01732</td>\n",
              "      <td>0.01459</td>\n",
              "      <td>0.01276</td>\n",
              "      <td>0.01276</td>\n",
              "      <td>0.01641</td>\n",
              "      <td>0.00820</td>\n",
              "      <td>0.02370</td>\n",
              "      <td>0.02097</td>\n",
              "      <td>0.02917</td>\n",
              "      <td>0.03464</td>\n",
              "      <td>0.02005</td>\n",
              "      <td>0.02005</td>\n",
              "      <td>0.01459</td>\n",
              "      <td>0.02461</td>\n",
              "      <td>0.01367</td>\n",
              "      <td>0.01459</td>\n",
              "      <td>0.01914</td>\n",
              "      <td>0.03008</td>\n",
              "      <td>0.00182</td>\n",
              "      <td>0.00547</td>\n",
              "      <td>0.00547</td>\n",
              "      <td>0.00820</td>\n",
              "      <td>0.01367</td>\n",
              "      <td>0.01094</td>\n",
              "      <td>0.01367</td>\n",
              "      <td>0.02279</td>\n",
              "      <td>0.02005</td>\n",
              "      <td>0.04102</td>\n",
              "      <td>0.00091</td>\n",
              "      <td>0.00091</td>\n",
              "      <td>0.00638</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13025</th>\n",
              "      <td>pri</td>\n",
              "      <td>1.0</td>\n",
              "      <td>9601.0</td>\n",
              "      <td>2067.0</td>\n",
              "      <td>mitochondrion Pongo pygmaeus abelii</td>\n",
              "      <td>0.01258</td>\n",
              "      <td>0.03193</td>\n",
              "      <td>0.01984</td>\n",
              "      <td>0.00629</td>\n",
              "      <td>0.01451</td>\n",
              "      <td>0.05322</td>\n",
              "      <td>0.07644</td>\n",
              "      <td>0.01258</td>\n",
              "      <td>0.03096</td>\n",
              "      <td>0.06386</td>\n",
              "      <td>0.03435</td>\n",
              "      <td>0.01258</td>\n",
              "      <td>0.00629</td>\n",
              "      <td>0.01258</td>\n",
              "      <td>0.01451</td>\n",
              "      <td>0.00871</td>\n",
              "      <td>0.01161</td>\n",
              "      <td>0.03338</td>\n",
              "      <td>0.02129</td>\n",
              "      <td>0.00242</td>\n",
              "      <td>0.00871</td>\n",
              "      <td>0.03338</td>\n",
              "      <td>0.01984</td>\n",
              "      <td>0.00048</td>\n",
              "      <td>0.00387</td>\n",
              "      <td>0.00774</td>\n",
              "      <td>0.01693</td>\n",
              "      <td>0.01451</td>\n",
              "      <td>0.01113</td>\n",
              "      <td>0.01016</td>\n",
              "      <td>0.02032</td>\n",
              "      <td>0.02371</td>\n",
              "      <td>0.00145</td>\n",
              "      <td>0.00339</td>\n",
              "      <td>0.01161</td>\n",
              "      <td>0.01451</td>\n",
              "      <td>0.05031</td>\n",
              "      <td>0.02854</td>\n",
              "      <td>0.00484</td>\n",
              "      <td>0.01016</td>\n",
              "      <td>0.02080</td>\n",
              "      <td>0.02177</td>\n",
              "      <td>0.00339</td>\n",
              "      <td>0.00822</td>\n",
              "      <td>0.03532</td>\n",
              "      <td>0.00242</td>\n",
              "      <td>0.00435</td>\n",
              "      <td>0.00290</td>\n",
              "      <td>0.01693</td>\n",
              "      <td>0.02661</td>\n",
              "      <td>0.00290</td>\n",
              "      <td>0.00097</td>\n",
              "      <td>0.00726</td>\n",
              "      <td>0.00629</td>\n",
              "      <td>0.00145</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00048</td>\n",
              "      <td>0.00194</td>\n",
              "      <td>0.01306</td>\n",
              "      <td>0.01838</td>\n",
              "      <td>0.00677</td>\n",
              "      <td>0.00242</td>\n",
              "      <td>0.00097</td>\n",
              "      <td>0.01887</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13026</th>\n",
              "      <td>pri</td>\n",
              "      <td>1.0</td>\n",
              "      <td>9602.0</td>\n",
              "      <td>1686.0</td>\n",
              "      <td>mitochondrion Pongo pygmaeus pygmaeus</td>\n",
              "      <td>0.01423</td>\n",
              "      <td>0.03321</td>\n",
              "      <td>0.01661</td>\n",
              "      <td>0.00356</td>\n",
              "      <td>0.01127</td>\n",
              "      <td>0.05042</td>\n",
              "      <td>0.09609</td>\n",
              "      <td>0.01068</td>\n",
              "      <td>0.02728</td>\n",
              "      <td>0.06643</td>\n",
              "      <td>0.02669</td>\n",
              "      <td>0.01246</td>\n",
              "      <td>0.00297</td>\n",
              "      <td>0.01542</td>\n",
              "      <td>0.01423</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00949</td>\n",
              "      <td>0.03915</td>\n",
              "      <td>0.01720</td>\n",
              "      <td>0.00119</td>\n",
              "      <td>0.00830</td>\n",
              "      <td>0.04033</td>\n",
              "      <td>0.02372</td>\n",
              "      <td>0.00119</td>\n",
              "      <td>0.00237</td>\n",
              "      <td>0.00237</td>\n",
              "      <td>0.02017</td>\n",
              "      <td>0.01423</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00593</td>\n",
              "      <td>0.01898</td>\n",
              "      <td>0.02610</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00119</td>\n",
              "      <td>0.00830</td>\n",
              "      <td>0.01661</td>\n",
              "      <td>0.05279</td>\n",
              "      <td>0.03618</td>\n",
              "      <td>0.00712</td>\n",
              "      <td>0.00712</td>\n",
              "      <td>0.02017</td>\n",
              "      <td>0.01898</td>\n",
              "      <td>0.00830</td>\n",
              "      <td>0.00652</td>\n",
              "      <td>0.03203</td>\n",
              "      <td>0.00119</td>\n",
              "      <td>0.00356</td>\n",
              "      <td>0.00474</td>\n",
              "      <td>0.02017</td>\n",
              "      <td>0.02432</td>\n",
              "      <td>0.00297</td>\n",
              "      <td>0.00119</td>\n",
              "      <td>0.00830</td>\n",
              "      <td>0.01186</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00178</td>\n",
              "      <td>0.01661</td>\n",
              "      <td>0.02788</td>\n",
              "      <td>0.00297</td>\n",
              "      <td>0.00356</td>\n",
              "      <td>0.00119</td>\n",
              "      <td>0.02017</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13027</th>\n",
              "      <td>pri</td>\n",
              "      <td>0.0</td>\n",
              "      <td>9606.0</td>\n",
              "      <td>40662582.0</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>0.01757</td>\n",
              "      <td>0.02028</td>\n",
              "      <td>0.00767</td>\n",
              "      <td>0.01293</td>\n",
              "      <td>0.01319</td>\n",
              "      <td>0.01959</td>\n",
              "      <td>0.00715</td>\n",
              "      <td>0.03964</td>\n",
              "      <td>0.01600</td>\n",
              "      <td>0.02082</td>\n",
              "      <td>0.00749</td>\n",
              "      <td>0.02204</td>\n",
              "      <td>0.01103</td>\n",
              "      <td>0.01446</td>\n",
              "      <td>0.00708</td>\n",
              "      <td>0.02812</td>\n",
              "      <td>0.01845</td>\n",
              "      <td>0.02773</td>\n",
              "      <td>0.01582</td>\n",
              "      <td>0.00737</td>\n",
              "      <td>0.01754</td>\n",
              "      <td>0.01979</td>\n",
              "      <td>0.01692</td>\n",
              "      <td>0.00692</td>\n",
              "      <td>0.01317</td>\n",
              "      <td>0.01075</td>\n",
              "      <td>0.02222</td>\n",
              "      <td>0.01647</td>\n",
              "      <td>0.01647</td>\n",
              "      <td>0.01522</td>\n",
              "      <td>0.01768</td>\n",
              "      <td>0.01221</td>\n",
              "      <td>0.00441</td>\n",
              "      <td>0.01213</td>\n",
              "      <td>0.01946</td>\n",
              "      <td>0.01312</td>\n",
              "      <td>0.01889</td>\n",
              "      <td>0.01511</td>\n",
              "      <td>0.00605</td>\n",
              "      <td>0.01219</td>\n",
              "      <td>0.01531</td>\n",
              "      <td>0.01234</td>\n",
              "      <td>0.03423</td>\n",
              "      <td>0.01696</td>\n",
              "      <td>0.01910</td>\n",
              "      <td>0.01058</td>\n",
              "      <td>0.01262</td>\n",
              "      <td>0.01086</td>\n",
              "      <td>0.01509</td>\n",
              "      <td>0.02444</td>\n",
              "      <td>0.03186</td>\n",
              "      <td>0.00454</td>\n",
              "      <td>0.01042</td>\n",
              "      <td>0.00617</td>\n",
              "      <td>0.01142</td>\n",
              "      <td>0.01217</td>\n",
              "      <td>0.01196</td>\n",
              "      <td>0.02178</td>\n",
              "      <td>0.02510</td>\n",
              "      <td>0.02896</td>\n",
              "      <td>0.03959</td>\n",
              "      <td>0.00099</td>\n",
              "      <td>0.00079</td>\n",
              "      <td>0.00156</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13028</th>\n",
              "      <td>pri</td>\n",
              "      <td>1.0</td>\n",
              "      <td>9606.0</td>\n",
              "      <td>8998998.0</td>\n",
              "      <td>mitochondrion Homo sapiens</td>\n",
              "      <td>0.01778</td>\n",
              "      <td>0.03724</td>\n",
              "      <td>0.01732</td>\n",
              "      <td>0.00600</td>\n",
              "      <td>0.01689</td>\n",
              "      <td>0.03854</td>\n",
              "      <td>0.07000</td>\n",
              "      <td>0.01308</td>\n",
              "      <td>0.03391</td>\n",
              "      <td>0.05137</td>\n",
              "      <td>0.04406</td>\n",
              "      <td>0.01225</td>\n",
              "      <td>0.01065</td>\n",
              "      <td>0.01415</td>\n",
              "      <td>0.01953</td>\n",
              "      <td>0.00661</td>\n",
              "      <td>0.01402</td>\n",
              "      <td>0.02956</td>\n",
              "      <td>0.02377</td>\n",
              "      <td>0.00319</td>\n",
              "      <td>0.01132</td>\n",
              "      <td>0.03343</td>\n",
              "      <td>0.01180</td>\n",
              "      <td>0.00177</td>\n",
              "      <td>0.00241</td>\n",
              "      <td>0.00891</td>\n",
              "      <td>0.02079</td>\n",
              "      <td>0.01952</td>\n",
              "      <td>0.00961</td>\n",
              "      <td>0.00969</td>\n",
              "      <td>0.02291</td>\n",
              "      <td>0.01920</td>\n",
              "      <td>0.00238</td>\n",
              "      <td>0.00355</td>\n",
              "      <td>0.00970</td>\n",
              "      <td>0.01463</td>\n",
              "      <td>0.04147</td>\n",
              "      <td>0.03269</td>\n",
              "      <td>0.00257</td>\n",
              "      <td>0.01292</td>\n",
              "      <td>0.02223</td>\n",
              "      <td>0.02051</td>\n",
              "      <td>0.00270</td>\n",
              "      <td>0.01055</td>\n",
              "      <td>0.03408</td>\n",
              "      <td>0.00166</td>\n",
              "      <td>0.00456</td>\n",
              "      <td>0.00404</td>\n",
              "      <td>0.01802</td>\n",
              "      <td>0.02358</td>\n",
              "      <td>0.00304</td>\n",
              "      <td>0.00277</td>\n",
              "      <td>0.00571</td>\n",
              "      <td>0.00653</td>\n",
              "      <td>0.00083</td>\n",
              "      <td>0.00041</td>\n",
              "      <td>0.00041</td>\n",
              "      <td>0.00451</td>\n",
              "      <td>0.01402</td>\n",
              "      <td>0.01651</td>\n",
              "      <td>0.00783</td>\n",
              "      <td>0.00156</td>\n",
              "      <td>0.00114</td>\n",
              "      <td>0.02161</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>13029 rows × 69 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "      Kingdom  DNAtype  SpeciesID  ...      UAA      UAG      UGA\n",
              "0         vrl      0.0   100217.0  ...  0.00251  0.00050  0.00000\n",
              "1         vrl      0.0   100220.0  ...  0.00271  0.00068  0.00000\n",
              "2         vrl      0.0   100755.0  ...  0.00391  0.00000  0.00144\n",
              "3         vrl      0.0   100880.0  ...  0.00261  0.00157  0.00000\n",
              "4         vrl      0.0   100887.0  ...  0.00000  0.00044  0.00131\n",
              "...       ...      ...        ...  ...      ...      ...      ...\n",
              "13024     pri      0.0     9601.0  ...  0.00091  0.00091  0.00638\n",
              "13025     pri      1.0     9601.0  ...  0.00242  0.00097  0.01887\n",
              "13026     pri      1.0     9602.0  ...  0.00356  0.00119  0.02017\n",
              "13027     pri      0.0     9606.0  ...  0.00099  0.00079  0.00156\n",
              "13028     pri      1.0     9606.0  ...  0.00156  0.00114  0.02161\n",
              "\n",
              "[13029 rows x 69 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 41
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "45lMB3YHmiUf"
      },
      "source": [
        "### Análise do conjunto de dados e seus atributos\n",
        "\n",
        "Aqui podemos ver a quantidade de instâncias x quantidade de atributos dos dados originais:"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "06L4xKRTrNFg",
        "outputId": "a6e328ea-88e6-4495-b0c1-3c5417d3f7cf"
      },
      "source": [
        "print(rawData.shape)"
      ],
      "execution_count": 42,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "(13029, 69)\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "QgOTJ4GUmsXH"
      },
      "source": [
        "Em seguida, estamos analisando os tipos de cada atributo do conjunto de dados. É importante observar que atributos numéricos devem estar representados como float64, atributos categóricos como categoric ou int."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "_01YC4nerU71",
        "outputId": "8c77a8c7-bad4-43ae-e37e-584f8516942e"
      },
      "source": [
        "rawData.dtypes"
      ],
      "execution_count": 43,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Kingdom         object\n",
              "DNAtype        float64\n",
              "SpeciesID      float64\n",
              "Ncodons        float64\n",
              "SpeciesName     object\n",
              "                ...   \n",
              "GAA            float64\n",
              "GAG            float64\n",
              "UAA            float64\n",
              "UAG            float64\n",
              "UGA            float64\n",
              "Length: 69, dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 43
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "AQhD-n3OnEE_"
      },
      "source": [
        "Após uma inspeção visual, vemos que o atributo *\"DNAtype\"* é do tipo categórico. Vamos corrigir seu tipo utilizando os comandos:"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "jMgGGFOWnEQf",
        "outputId": "e4f8b2f5-1fba-4151-e4d0-7496172cf902"
      },
      "source": [
        "rawData['DNAtype'] = rawData['DNAtype'].astype(object)\n",
        "\n",
        "rawData.dtypes"
      ],
      "execution_count": 44,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Kingdom         object\n",
              "DNAtype         object\n",
              "SpeciesID      float64\n",
              "Ncodons        float64\n",
              "SpeciesName     object\n",
              "                ...   \n",
              "GAA            float64\n",
              "GAG            float64\n",
              "UAA            float64\n",
              "UAG            float64\n",
              "UGA            float64\n",
              "Length: 69, dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 44
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "srIUJOhwnNhG"
      },
      "source": [
        "Vamos analisar a quantidade de valores que os atributos \"Kingdom\" (reino) e \"SpeciesName\" (Nome da espécie) possuem\n",
        ":"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "JtT36Ksdri-y",
        "outputId": "530100ec-9e36-47ea-daf9-44b18be8f769"
      },
      "source": [
        "print(rawData['Kingdom'].value_counts())"
      ],
      "execution_count": 45,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "bct    2920\n",
            "vrl    2832\n",
            "pln    2523\n",
            "vrt    2077\n",
            "inv    1345\n",
            "mam     572\n",
            "phg     220\n",
            "rod     215\n",
            "pri     180\n",
            "arc     126\n",
            "plm      18\n",
            "-         1\n",
            "Name: Kingdom, dtype: int64\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "O-5cimxir2g1",
        "outputId": "5aff896c-56ee-4922-ed3c-6ea6899354e7"
      },
      "source": [
        "print(rawData['SpeciesName'].value_counts())"
      ],
      "execution_count": 46,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Escherichia coli O157                         4\n",
            "Escherichia coli O111                         3\n",
            "Cotton leaf curl Rajasthan virus - [India     3\n",
            "Ageratum yellow vein Hualian virus-[Taiwan    3\n",
            "Squash leaf curl China virus - [Pumpkin       2\n",
            "                                             ..\n",
            "mitochondrion Austrofundulus transilis        1\n",
            "Cercospora nicotianae                         1\n",
            "Limonium bicolor                              1\n",
            "Streptococcus phage 700P1                     1\n",
            "Banana bunchy top virus                       1\n",
            "Name: SpeciesName, Length: 13017, dtype: int64\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "VI25hgxMpH82"
      },
      "source": [
        "### Filtragem de instâncias\n",
        "\n",
        "A seguir, vamos realizar uma filtragem de instâncias para amostrar apenas aquelas pertencentes aos reinos \"bct\", \"vrl\", \"pln\" e \"vrt\":"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "NHYY_OYysAsM",
        "outputId": "104a449a-7b1a-4dce-9571-01a6642ef2ce"
      },
      "source": [
        "flag1 = rawData['Kingdom'] == 'bct'\n",
        "flag2 = rawData['Kingdom'] == 'vrl'\n",
        "flag3 = rawData['Kingdom'] == 'pln'\n",
        "flag4 = rawData['Kingdom'] == 'vrt'\n",
        "\n",
        "df = rawData[ flag1 | flag2 | flag3 | flag4]\n",
        "\n",
        "print(df.shape)"
      ],
      "execution_count": 47,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "(10352, 69)\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "aT0BjwgHpcZl"
      },
      "source": [
        "### Seleção manual de atributos\n",
        "\n",
        "Suponha que queremos classificar os microorganismos conforme o reino (Kingdom). Precisamos separar o atributo associado como o atributo classe e remover os atributos SpeciesID e SpeciesName pois eles não são importantes devido à sua granulidade."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "YVF1q8nIxWlk"
      },
      "source": [
        "categories = df['Kingdom']\n",
        "\n",
        "species = df['SpeciesID']\n",
        "\n",
        "df = df.drop(['SpeciesName','SpeciesID','Kingdom'],axis=1)"
      ],
      "execution_count": 48,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "AgJO0ub6xsBK"
      },
      "source": [
        "### Remoção de instâncias com valores ausentes\n",
        "\n",
        "É comum que dados ausentes se apresentem como valores em branco \" \", interrogação \"?\" ou hífen \"-\". Substituímos esses caracteres por NaN e depois utilizamos o método dropna do DataFrame:"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "6mXZ4fMizrbK",
        "outputId": "1f3d8eb4-ae7f-4603-f9df-2a7aaa63a979"
      },
      "source": [
        "df = df.replace('-',np.NaN)\n",
        "df = df.replace(' ',np.NaN)\n",
        "df = df.replace('?',np.NaN)\n",
        "df = df.dropna(axis=0)\n",
        "\n",
        "print(df.shape)"
      ],
      "execution_count": 49,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "(10350, 66)\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "FsS367Wjx_2Q"
      },
      "source": [
        "### Transformação do espaço de atributos\n",
        "\n",
        "Como o atributo \"DNAtype\" é categórico, temos que transformá-lo para atributos numéricos para que os dados processados possam ser utilizados como entrada pelos modelos de aprendizado de máquina (em sua maioria, só aceitam dados em formato estruturado e numérico).\n",
        "\n",
        "A estratégia é converter o atributo \"DNAtype\" para binário por meio de variáveis Dummy."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 437
        },
        "id": "PVbt6Dxi2pPD",
        "outputId": "bf4045c5-9df6-42a8-a95e-dade5318b25e"
      },
      "source": [
        "df = pd.get_dummies(df)\n",
        "\n",
        "df"
      ],
      "execution_count": 50,
      "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>DNAtype</th>\n",
              "      <th>Ncodons</th>\n",
              "      <th>UUU</th>\n",
              "      <th>UUC</th>\n",
              "      <th>UUA</th>\n",
              "      <th>UUG</th>\n",
              "      <th>CUU</th>\n",
              "      <th>CUC</th>\n",
              "      <th>CUA</th>\n",
              "      <th>CUG</th>\n",
              "      <th>AUU</th>\n",
              "      <th>AUC</th>\n",
              "      <th>AUA</th>\n",
              "      <th>AUG</th>\n",
              "      <th>GUU</th>\n",
              "      <th>GUC</th>\n",
              "      <th>GUA</th>\n",
              "      <th>GUG</th>\n",
              "      <th>GCU</th>\n",
              "      <th>GCC</th>\n",
              "      <th>GCA</th>\n",
              "      <th>GCG</th>\n",
              "      <th>CCU</th>\n",
              "      <th>CCC</th>\n",
              "      <th>CCA</th>\n",
              "      <th>CCG</th>\n",
              "      <th>UGG</th>\n",
              "      <th>GGU</th>\n",
              "      <th>GGC</th>\n",
              "      <th>GGA</th>\n",
              "      <th>GGG</th>\n",
              "      <th>UCU</th>\n",
              "      <th>UCC</th>\n",
              "      <th>UCA</th>\n",
              "      <th>UCG</th>\n",
              "      <th>AGU</th>\n",
              "      <th>AGC</th>\n",
              "      <th>ACU</th>\n",
              "      <th>ACC</th>\n",
              "      <th>ACA</th>\n",
              "      <th>ACG</th>\n",
              "      <th>UAU</th>\n",
              "      <th>UAC</th>\n",
              "      <th>CAA</th>\n",
              "      <th>CAG</th>\n",
              "      <th>AAU</th>\n",
              "      <th>AAC</th>\n",
              "      <th>UGU</th>\n",
              "      <th>UGC</th>\n",
              "      <th>CAU</th>\n",
              "      <th>CAC</th>\n",
              "      <th>AAA</th>\n",
              "      <th>AAG</th>\n",
              "      <th>CGU</th>\n",
              "      <th>CGC</th>\n",
              "      <th>CGA</th>\n",
              "      <th>CGG</th>\n",
              "      <th>AGA</th>\n",
              "      <th>AGG</th>\n",
              "      <th>GAU</th>\n",
              "      <th>GAC</th>\n",
              "      <th>GAA</th>\n",
              "      <th>GAG</th>\n",
              "      <th>UAA</th>\n",
              "      <th>UAG</th>\n",
              "      <th>UGA</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0.0</td>\n",
              "      <td>1995.0</td>\n",
              "      <td>0.01654</td>\n",
              "      <td>0.01203</td>\n",
              "      <td>0.00050</td>\n",
              "      <td>0.00351</td>\n",
              "      <td>0.01203</td>\n",
              "      <td>0.03208</td>\n",
              "      <td>0.00100</td>\n",
              "      <td>0.04010</td>\n",
              "      <td>0.00551</td>\n",
              "      <td>0.02005</td>\n",
              "      <td>0.00752</td>\n",
              "      <td>0.02506</td>\n",
              "      <td>0.01103</td>\n",
              "      <td>0.04110</td>\n",
              "      <td>0.00902</td>\n",
              "      <td>0.03308</td>\n",
              "      <td>0.01003</td>\n",
              "      <td>0.05013</td>\n",
              "      <td>0.01554</td>\n",
              "      <td>0.01103</td>\n",
              "      <td>0.02356</td>\n",
              "      <td>0.03208</td>\n",
              "      <td>0.01203</td>\n",
              "      <td>0.00501</td>\n",
              "      <td>0.01003</td>\n",
              "      <td>0.01203</td>\n",
              "      <td>0.03158</td>\n",
              "      <td>0.01905</td>\n",
              "      <td>0.02456</td>\n",
              "      <td>0.01353</td>\n",
              "      <td>0.02155</td>\n",
              "      <td>0.00251</td>\n",
              "      <td>0.00652</td>\n",
              "      <td>0.00150</td>\n",
              "      <td>0.01554</td>\n",
              "      <td>0.00501</td>\n",
              "      <td>0.02105</td>\n",
              "      <td>0.00902</td>\n",
              "      <td>0.01053</td>\n",
              "      <td>0.00501</td>\n",
              "      <td>0.02256</td>\n",
              "      <td>0.00301</td>\n",
              "      <td>0.03108</td>\n",
              "      <td>0.00401</td>\n",
              "      <td>0.02607</td>\n",
              "      <td>0.00251</td>\n",
              "      <td>0.01153</td>\n",
              "      <td>0.00501</td>\n",
              "      <td>0.02356</td>\n",
              "      <td>0.01053</td>\n",
              "      <td>0.03860</td>\n",
              "      <td>0.00401</td>\n",
              "      <td>0.00702</td>\n",
              "      <td>0.00401</td>\n",
              "      <td>0.00451</td>\n",
              "      <td>0.01303</td>\n",
              "      <td>0.03559</td>\n",
              "      <td>0.01003</td>\n",
              "      <td>0.04612</td>\n",
              "      <td>0.01203</td>\n",
              "      <td>0.04361</td>\n",
              "      <td>0.00251</td>\n",
              "      <td>0.00050</td>\n",
              "      <td>0.00000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>0.0</td>\n",
              "      <td>1474.0</td>\n",
              "      <td>0.02714</td>\n",
              "      <td>0.01357</td>\n",
              "      <td>0.00068</td>\n",
              "      <td>0.00678</td>\n",
              "      <td>0.00407</td>\n",
              "      <td>0.02849</td>\n",
              "      <td>0.00204</td>\n",
              "      <td>0.04410</td>\n",
              "      <td>0.01153</td>\n",
              "      <td>0.02510</td>\n",
              "      <td>0.00882</td>\n",
              "      <td>0.03324</td>\n",
              "      <td>0.00814</td>\n",
              "      <td>0.04071</td>\n",
              "      <td>0.00814</td>\n",
              "      <td>0.03256</td>\n",
              "      <td>0.01085</td>\n",
              "      <td>0.04885</td>\n",
              "      <td>0.01221</td>\n",
              "      <td>0.01357</td>\n",
              "      <td>0.00678</td>\n",
              "      <td>0.02714</td>\n",
              "      <td>0.01221</td>\n",
              "      <td>0.00407</td>\n",
              "      <td>0.01425</td>\n",
              "      <td>0.01221</td>\n",
              "      <td>0.01967</td>\n",
              "      <td>0.02239</td>\n",
              "      <td>0.01289</td>\n",
              "      <td>0.02103</td>\n",
              "      <td>0.01493</td>\n",
              "      <td>0.00407</td>\n",
              "      <td>0.00475</td>\n",
              "      <td>0.00068</td>\n",
              "      <td>0.02035</td>\n",
              "      <td>0.00950</td>\n",
              "      <td>0.02782</td>\n",
              "      <td>0.01425</td>\n",
              "      <td>0.00611</td>\n",
              "      <td>0.00475</td>\n",
              "      <td>0.02917</td>\n",
              "      <td>0.00407</td>\n",
              "      <td>0.02374</td>\n",
              "      <td>0.00882</td>\n",
              "      <td>0.02917</td>\n",
              "      <td>0.00271</td>\n",
              "      <td>0.01628</td>\n",
              "      <td>0.00204</td>\n",
              "      <td>0.01967</td>\n",
              "      <td>0.00543</td>\n",
              "      <td>0.03392</td>\n",
              "      <td>0.00136</td>\n",
              "      <td>0.00678</td>\n",
              "      <td>0.00136</td>\n",
              "      <td>0.00136</td>\n",
              "      <td>0.01696</td>\n",
              "      <td>0.03596</td>\n",
              "      <td>0.01221</td>\n",
              "      <td>0.04545</td>\n",
              "      <td>0.01560</td>\n",
              "      <td>0.04410</td>\n",
              "      <td>0.00271</td>\n",
              "      <td>0.00068</td>\n",
              "      <td>0.00000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>0.0</td>\n",
              "      <td>4862.0</td>\n",
              "      <td>0.01974</td>\n",
              "      <td>0.02180</td>\n",
              "      <td>0.01357</td>\n",
              "      <td>0.01543</td>\n",
              "      <td>0.00782</td>\n",
              "      <td>0.01111</td>\n",
              "      <td>0.01028</td>\n",
              "      <td>0.01193</td>\n",
              "      <td>0.02283</td>\n",
              "      <td>0.01604</td>\n",
              "      <td>0.01316</td>\n",
              "      <td>0.02180</td>\n",
              "      <td>0.01625</td>\n",
              "      <td>0.01872</td>\n",
              "      <td>0.01213</td>\n",
              "      <td>0.01070</td>\n",
              "      <td>0.02406</td>\n",
              "      <td>0.01234</td>\n",
              "      <td>0.01440</td>\n",
              "      <td>0.00514</td>\n",
              "      <td>0.01604</td>\n",
              "      <td>0.01460</td>\n",
              "      <td>0.02098</td>\n",
              "      <td>0.01070</td>\n",
              "      <td>0.01728</td>\n",
              "      <td>0.01851</td>\n",
              "      <td>0.00864</td>\n",
              "      <td>0.01172</td>\n",
              "      <td>0.01892</td>\n",
              "      <td>0.01933</td>\n",
              "      <td>0.01419</td>\n",
              "      <td>0.01296</td>\n",
              "      <td>0.00967</td>\n",
              "      <td>0.01337</td>\n",
              "      <td>0.01337</td>\n",
              "      <td>0.01851</td>\n",
              "      <td>0.01131</td>\n",
              "      <td>0.01419</td>\n",
              "      <td>0.01090</td>\n",
              "      <td>0.02612</td>\n",
              "      <td>0.01275</td>\n",
              "      <td>0.01522</td>\n",
              "      <td>0.02365</td>\n",
              "      <td>0.02962</td>\n",
              "      <td>0.01789</td>\n",
              "      <td>0.01625</td>\n",
              "      <td>0.01234</td>\n",
              "      <td>0.01604</td>\n",
              "      <td>0.01687</td>\n",
              "      <td>0.02077</td>\n",
              "      <td>0.03949</td>\n",
              "      <td>0.00864</td>\n",
              "      <td>0.00596</td>\n",
              "      <td>0.00926</td>\n",
              "      <td>0.00596</td>\n",
              "      <td>0.01974</td>\n",
              "      <td>0.02489</td>\n",
              "      <td>0.03126</td>\n",
              "      <td>0.02036</td>\n",
              "      <td>0.02242</td>\n",
              "      <td>0.02468</td>\n",
              "      <td>0.00391</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00144</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>0.0</td>\n",
              "      <td>1915.0</td>\n",
              "      <td>0.01775</td>\n",
              "      <td>0.02245</td>\n",
              "      <td>0.01619</td>\n",
              "      <td>0.00992</td>\n",
              "      <td>0.01567</td>\n",
              "      <td>0.01358</td>\n",
              "      <td>0.00940</td>\n",
              "      <td>0.01723</td>\n",
              "      <td>0.02402</td>\n",
              "      <td>0.02245</td>\n",
              "      <td>0.02507</td>\n",
              "      <td>0.02924</td>\n",
              "      <td>0.02089</td>\n",
              "      <td>0.02141</td>\n",
              "      <td>0.01723</td>\n",
              "      <td>0.01932</td>\n",
              "      <td>0.02141</td>\n",
              "      <td>0.00679</td>\n",
              "      <td>0.02245</td>\n",
              "      <td>0.00522</td>\n",
              "      <td>0.01358</td>\n",
              "      <td>0.00418</td>\n",
              "      <td>0.01410</td>\n",
              "      <td>0.00574</td>\n",
              "      <td>0.01201</td>\n",
              "      <td>0.00992</td>\n",
              "      <td>0.00366</td>\n",
              "      <td>0.02402</td>\n",
              "      <td>0.02663</td>\n",
              "      <td>0.02872</td>\n",
              "      <td>0.00992</td>\n",
              "      <td>0.02350</td>\n",
              "      <td>0.00522</td>\n",
              "      <td>0.01619</td>\n",
              "      <td>0.00836</td>\n",
              "      <td>0.02037</td>\n",
              "      <td>0.01358</td>\n",
              "      <td>0.02089</td>\n",
              "      <td>0.00731</td>\n",
              "      <td>0.02141</td>\n",
              "      <td>0.00888</td>\n",
              "      <td>0.01567</td>\n",
              "      <td>0.01253</td>\n",
              "      <td>0.02298</td>\n",
              "      <td>0.01358</td>\n",
              "      <td>0.00992</td>\n",
              "      <td>0.00888</td>\n",
              "      <td>0.00783</td>\n",
              "      <td>0.00679</td>\n",
              "      <td>0.03133</td>\n",
              "      <td>0.04282</td>\n",
              "      <td>0.00627</td>\n",
              "      <td>0.00261</td>\n",
              "      <td>0.00261</td>\n",
              "      <td>0.00366</td>\n",
              "      <td>0.01410</td>\n",
              "      <td>0.01671</td>\n",
              "      <td>0.03760</td>\n",
              "      <td>0.01932</td>\n",
              "      <td>0.03029</td>\n",
              "      <td>0.03446</td>\n",
              "      <td>0.00261</td>\n",
              "      <td>0.00157</td>\n",
              "      <td>0.00000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>0.0</td>\n",
              "      <td>22831.0</td>\n",
              "      <td>0.02816</td>\n",
              "      <td>0.01371</td>\n",
              "      <td>0.00767</td>\n",
              "      <td>0.03679</td>\n",
              "      <td>0.01380</td>\n",
              "      <td>0.00548</td>\n",
              "      <td>0.00473</td>\n",
              "      <td>0.02076</td>\n",
              "      <td>0.02716</td>\n",
              "      <td>0.00867</td>\n",
              "      <td>0.01310</td>\n",
              "      <td>0.02773</td>\n",
              "      <td>0.02803</td>\n",
              "      <td>0.00508</td>\n",
              "      <td>0.00920</td>\n",
              "      <td>0.02965</td>\n",
              "      <td>0.02878</td>\n",
              "      <td>0.00574</td>\n",
              "      <td>0.01572</td>\n",
              "      <td>0.01577</td>\n",
              "      <td>0.01007</td>\n",
              "      <td>0.00508</td>\n",
              "      <td>0.00604</td>\n",
              "      <td>0.00679</td>\n",
              "      <td>0.01205</td>\n",
              "      <td>0.03127</td>\n",
              "      <td>0.00775</td>\n",
              "      <td>0.00959</td>\n",
              "      <td>0.00797</td>\n",
              "      <td>0.02006</td>\n",
              "      <td>0.00359</td>\n",
              "      <td>0.00933</td>\n",
              "      <td>0.01191</td>\n",
              "      <td>0.01616</td>\n",
              "      <td>0.00788</td>\n",
              "      <td>0.02593</td>\n",
              "      <td>0.00854</td>\n",
              "      <td>0.01200</td>\n",
              "      <td>0.02098</td>\n",
              "      <td>0.02089</td>\n",
              "      <td>0.01367</td>\n",
              "      <td>0.01502</td>\n",
              "      <td>0.01809</td>\n",
              "      <td>0.02738</td>\n",
              "      <td>0.01796</td>\n",
              "      <td>0.01082</td>\n",
              "      <td>0.00705</td>\n",
              "      <td>0.01174</td>\n",
              "      <td>0.00858</td>\n",
              "      <td>0.03408</td>\n",
              "      <td>0.03964</td>\n",
              "      <td>0.00950</td>\n",
              "      <td>0.00429</td>\n",
              "      <td>0.00578</td>\n",
              "      <td>0.00604</td>\n",
              "      <td>0.01494</td>\n",
              "      <td>0.01734</td>\n",
              "      <td>0.04148</td>\n",
              "      <td>0.02483</td>\n",
              "      <td>0.03359</td>\n",
              "      <td>0.03679</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00044</td>\n",
              "      <td>0.00131</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12057</th>\n",
              "      <td>1.0</td>\n",
              "      <td>1549.0</td>\n",
              "      <td>0.01679</td>\n",
              "      <td>0.03228</td>\n",
              "      <td>0.03486</td>\n",
              "      <td>0.00194</td>\n",
              "      <td>0.05939</td>\n",
              "      <td>0.04906</td>\n",
              "      <td>0.07037</td>\n",
              "      <td>0.00839</td>\n",
              "      <td>0.03551</td>\n",
              "      <td>0.02970</td>\n",
              "      <td>0.03034</td>\n",
              "      <td>0.01291</td>\n",
              "      <td>0.00839</td>\n",
              "      <td>0.01291</td>\n",
              "      <td>0.01097</td>\n",
              "      <td>0.00839</td>\n",
              "      <td>0.01743</td>\n",
              "      <td>0.03809</td>\n",
              "      <td>0.02841</td>\n",
              "      <td>0.00387</td>\n",
              "      <td>0.02582</td>\n",
              "      <td>0.02776</td>\n",
              "      <td>0.02518</td>\n",
              "      <td>0.00323</td>\n",
              "      <td>0.00452</td>\n",
              "      <td>0.00775</td>\n",
              "      <td>0.01679</td>\n",
              "      <td>0.01679</td>\n",
              "      <td>0.00323</td>\n",
              "      <td>0.01162</td>\n",
              "      <td>0.00968</td>\n",
              "      <td>0.00839</td>\n",
              "      <td>0.00129</td>\n",
              "      <td>0.00387</td>\n",
              "      <td>0.01420</td>\n",
              "      <td>0.01549</td>\n",
              "      <td>0.04067</td>\n",
              "      <td>0.03809</td>\n",
              "      <td>0.00710</td>\n",
              "      <td>0.00710</td>\n",
              "      <td>0.00775</td>\n",
              "      <td>0.03099</td>\n",
              "      <td>0.00323</td>\n",
              "      <td>0.01808</td>\n",
              "      <td>0.02195</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00581</td>\n",
              "      <td>0.01485</td>\n",
              "      <td>0.01808</td>\n",
              "      <td>0.00129</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00129</td>\n",
              "      <td>0.01549</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00323</td>\n",
              "      <td>0.01937</td>\n",
              "      <td>0.00581</td>\n",
              "      <td>0.00516</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.02905</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12058</th>\n",
              "      <td>0.0</td>\n",
              "      <td>8062.0</td>\n",
              "      <td>0.02270</td>\n",
              "      <td>0.01079</td>\n",
              "      <td>0.01191</td>\n",
              "      <td>0.01662</td>\n",
              "      <td>0.01240</td>\n",
              "      <td>0.00670</td>\n",
              "      <td>0.00521</td>\n",
              "      <td>0.01377</td>\n",
              "      <td>0.02493</td>\n",
              "      <td>0.01352</td>\n",
              "      <td>0.02282</td>\n",
              "      <td>0.02456</td>\n",
              "      <td>0.02394</td>\n",
              "      <td>0.01005</td>\n",
              "      <td>0.01228</td>\n",
              "      <td>0.01364</td>\n",
              "      <td>0.01563</td>\n",
              "      <td>0.01116</td>\n",
              "      <td>0.02543</td>\n",
              "      <td>0.00211</td>\n",
              "      <td>0.01488</td>\n",
              "      <td>0.01278</td>\n",
              "      <td>0.02406</td>\n",
              "      <td>0.00298</td>\n",
              "      <td>0.00955</td>\n",
              "      <td>0.01079</td>\n",
              "      <td>0.01302</td>\n",
              "      <td>0.02803</td>\n",
              "      <td>0.01129</td>\n",
              "      <td>0.02034</td>\n",
              "      <td>0.00546</td>\n",
              "      <td>0.01823</td>\n",
              "      <td>0.00136</td>\n",
              "      <td>0.01141</td>\n",
              "      <td>0.01067</td>\n",
              "      <td>0.02171</td>\n",
              "      <td>0.00571</td>\n",
              "      <td>0.01947</td>\n",
              "      <td>0.00409</td>\n",
              "      <td>0.03089</td>\n",
              "      <td>0.02022</td>\n",
              "      <td>0.02133</td>\n",
              "      <td>0.01327</td>\n",
              "      <td>0.03696</td>\n",
              "      <td>0.01712</td>\n",
              "      <td>0.02927</td>\n",
              "      <td>0.02716</td>\n",
              "      <td>0.01935</td>\n",
              "      <td>0.01178</td>\n",
              "      <td>0.03721</td>\n",
              "      <td>0.01997</td>\n",
              "      <td>0.00459</td>\n",
              "      <td>0.00385</td>\n",
              "      <td>0.00260</td>\n",
              "      <td>0.00360</td>\n",
              "      <td>0.01898</td>\n",
              "      <td>0.00558</td>\n",
              "      <td>0.04478</td>\n",
              "      <td>0.01526</td>\n",
              "      <td>0.04317</td>\n",
              "      <td>0.02444</td>\n",
              "      <td>0.00136</td>\n",
              "      <td>0.00012</td>\n",
              "      <td>0.00112</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12059</th>\n",
              "      <td>1.0</td>\n",
              "      <td>4309.0</td>\n",
              "      <td>0.03087</td>\n",
              "      <td>0.02367</td>\n",
              "      <td>0.00162</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00209</td>\n",
              "      <td>0.05082</td>\n",
              "      <td>0.06173</td>\n",
              "      <td>0.01694</td>\n",
              "      <td>0.00278</td>\n",
              "      <td>0.07055</td>\n",
              "      <td>0.00464</td>\n",
              "      <td>0.03110</td>\n",
              "      <td>0.00046</td>\n",
              "      <td>0.00232</td>\n",
              "      <td>0.00464</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00232</td>\n",
              "      <td>0.00743</td>\n",
              "      <td>0.02019</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.03249</td>\n",
              "      <td>0.04734</td>\n",
              "      <td>0.07844</td>\n",
              "      <td>0.00046</td>\n",
              "      <td>0.00023</td>\n",
              "      <td>0.00070</td>\n",
              "      <td>0.00162</td>\n",
              "      <td>0.00511</td>\n",
              "      <td>0.00093</td>\n",
              "      <td>0.00162</td>\n",
              "      <td>0.01926</td>\n",
              "      <td>0.01833</td>\n",
              "      <td>0.00023</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00975</td>\n",
              "      <td>0.03156</td>\n",
              "      <td>0.09770</td>\n",
              "      <td>0.02065</td>\n",
              "      <td>0.00023</td>\n",
              "      <td>0.00023</td>\n",
              "      <td>0.00395</td>\n",
              "      <td>0.03342</td>\n",
              "      <td>0.00046</td>\n",
              "      <td>0.00093</td>\n",
              "      <td>0.05755</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00186</td>\n",
              "      <td>0.00046</td>\n",
              "      <td>0.01880</td>\n",
              "      <td>0.06452</td>\n",
              "      <td>0.00023</td>\n",
              "      <td>0.00023</td>\n",
              "      <td>0.00023</td>\n",
              "      <td>0.00209</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00046</td>\n",
              "      <td>0.00186</td>\n",
              "      <td>0.01764</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.01532</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.07890</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12060</th>\n",
              "      <td>0.0</td>\n",
              "      <td>106417.0</td>\n",
              "      <td>0.01666</td>\n",
              "      <td>0.02917</td>\n",
              "      <td>0.00469</td>\n",
              "      <td>0.01083</td>\n",
              "      <td>0.00876</td>\n",
              "      <td>0.02408</td>\n",
              "      <td>0.00359</td>\n",
              "      <td>0.05573</td>\n",
              "      <td>0.01121</td>\n",
              "      <td>0.02984</td>\n",
              "      <td>0.00510</td>\n",
              "      <td>0.02345</td>\n",
              "      <td>0.01142</td>\n",
              "      <td>0.02352</td>\n",
              "      <td>0.00419</td>\n",
              "      <td>0.03424</td>\n",
              "      <td>0.01695</td>\n",
              "      <td>0.02921</td>\n",
              "      <td>0.01190</td>\n",
              "      <td>0.01277</td>\n",
              "      <td>0.01228</td>\n",
              "      <td>0.01878</td>\n",
              "      <td>0.01029</td>\n",
              "      <td>0.01184</td>\n",
              "      <td>0.01700</td>\n",
              "      <td>0.00935</td>\n",
              "      <td>0.02221</td>\n",
              "      <td>0.01436</td>\n",
              "      <td>0.01351</td>\n",
              "      <td>0.01115</td>\n",
              "      <td>0.02228</td>\n",
              "      <td>0.00788</td>\n",
              "      <td>0.00789</td>\n",
              "      <td>0.00803</td>\n",
              "      <td>0.02553</td>\n",
              "      <td>0.00872</td>\n",
              "      <td>0.02451</td>\n",
              "      <td>0.01060</td>\n",
              "      <td>0.01166</td>\n",
              "      <td>0.00782</td>\n",
              "      <td>0.02344</td>\n",
              "      <td>0.00701</td>\n",
              "      <td>0.03378</td>\n",
              "      <td>0.00864</td>\n",
              "      <td>0.02949</td>\n",
              "      <td>0.00965</td>\n",
              "      <td>0.01654</td>\n",
              "      <td>0.00586</td>\n",
              "      <td>0.01899</td>\n",
              "      <td>0.01797</td>\n",
              "      <td>0.02626</td>\n",
              "      <td>0.00409</td>\n",
              "      <td>0.01178</td>\n",
              "      <td>0.00469</td>\n",
              "      <td>0.00925</td>\n",
              "      <td>0.01147</td>\n",
              "      <td>0.01630</td>\n",
              "      <td>0.01258</td>\n",
              "      <td>0.03217</td>\n",
              "      <td>0.01540</td>\n",
              "      <td>0.03919</td>\n",
              "      <td>0.00060</td>\n",
              "      <td>0.00039</td>\n",
              "      <td>0.00144</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12061</th>\n",
              "      <td>1.0</td>\n",
              "      <td>4304.0</td>\n",
              "      <td>0.02881</td>\n",
              "      <td>0.04089</td>\n",
              "      <td>0.01789</td>\n",
              "      <td>0.00953</td>\n",
              "      <td>0.02695</td>\n",
              "      <td>0.04229</td>\n",
              "      <td>0.05855</td>\n",
              "      <td>0.01092</td>\n",
              "      <td>0.02370</td>\n",
              "      <td>0.04368</td>\n",
              "      <td>0.02486</td>\n",
              "      <td>0.01301</td>\n",
              "      <td>0.01603</td>\n",
              "      <td>0.02463</td>\n",
              "      <td>0.01696</td>\n",
              "      <td>0.00651</td>\n",
              "      <td>0.01394</td>\n",
              "      <td>0.04484</td>\n",
              "      <td>0.02602</td>\n",
              "      <td>0.00372</td>\n",
              "      <td>0.01278</td>\n",
              "      <td>0.02254</td>\n",
              "      <td>0.01998</td>\n",
              "      <td>0.00209</td>\n",
              "      <td>0.00372</td>\n",
              "      <td>0.00720</td>\n",
              "      <td>0.02533</td>\n",
              "      <td>0.02138</td>\n",
              "      <td>0.01046</td>\n",
              "      <td>0.01208</td>\n",
              "      <td>0.02463</td>\n",
              "      <td>0.01766</td>\n",
              "      <td>0.00093</td>\n",
              "      <td>0.00372</td>\n",
              "      <td>0.01231</td>\n",
              "      <td>0.00813</td>\n",
              "      <td>0.03950</td>\n",
              "      <td>0.02370</td>\n",
              "      <td>0.00256</td>\n",
              "      <td>0.00860</td>\n",
              "      <td>0.02091</td>\n",
              "      <td>0.02045</td>\n",
              "      <td>0.00302</td>\n",
              "      <td>0.00488</td>\n",
              "      <td>0.02904</td>\n",
              "      <td>0.00209</td>\n",
              "      <td>0.00511</td>\n",
              "      <td>0.00488</td>\n",
              "      <td>0.02277</td>\n",
              "      <td>0.02068</td>\n",
              "      <td>0.00116</td>\n",
              "      <td>0.00139</td>\n",
              "      <td>0.00302</td>\n",
              "      <td>0.01208</td>\n",
              "      <td>0.00279</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.00070</td>\n",
              "      <td>0.00395</td>\n",
              "      <td>0.01580</td>\n",
              "      <td>0.01812</td>\n",
              "      <td>0.00581</td>\n",
              "      <td>0.00232</td>\n",
              "      <td>0.00046</td>\n",
              "      <td>0.02556</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>10350 rows × 66 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       DNAtype   Ncodons      UUU      UUC  ...      GAG      UAA      UAG      UGA\n",
              "0          0.0    1995.0  0.01654  0.01203  ...  0.04361  0.00251  0.00050  0.00000\n",
              "1          0.0    1474.0  0.02714  0.01357  ...  0.04410  0.00271  0.00068  0.00000\n",
              "2          0.0    4862.0  0.01974  0.02180  ...  0.02468  0.00391  0.00000  0.00144\n",
              "3          0.0    1915.0  0.01775  0.02245  ...  0.03446  0.00261  0.00157  0.00000\n",
              "4          0.0   22831.0  0.02816  0.01371  ...  0.03679  0.00000  0.00044  0.00131\n",
              "...        ...       ...      ...      ...  ...      ...      ...      ...      ...\n",
              "12057      1.0    1549.0  0.01679  0.03228  ...  0.00581  0.00516  0.00000  0.02905\n",
              "12058      0.0    8062.0  0.02270  0.01079  ...  0.02444  0.00136  0.00012  0.00112\n",
              "12059      1.0    4309.0  0.03087  0.02367  ...  0.00000  0.01532  0.00000  0.07890\n",
              "12060      0.0  106417.0  0.01666  0.02917  ...  0.03919  0.00060  0.00039  0.00144\n",
              "12061      1.0    4304.0  0.02881  0.04089  ...  0.00581  0.00232  0.00046  0.02556\n",
              "\n",
              "[10350 rows x 66 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 50
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "zuiuDLvqzATc"
      },
      "source": [
        "Por fim, agora vamos normalizar todos os atributos do conjunto de dados para o intervalo [0,1]. Aqui, faremos a normalização por re-escalonamento:"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "C5O8mDCC3Rgp"
      },
      "source": [
        "X = df.values\n",
        "\n",
        "y = categories.values\n",
        "\n",
        "normalizer = preprocessing.MinMaxScaler()\n",
        "\n",
        "xscaled = normalizer.fit_transform(X)"
      ],
      "execution_count": 51,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "XEdrmlZ0xKov"
      },
      "source": [
        "Pronto! Agora o conjunto de dados está processado, em formato numérico, preparado para ser utilizado pelas técnicas de aprendizado de máquina."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "vmdZ1OCbzbNa",
        "outputId": "a237f699-1cb0-4e2d-9706-250168916191"
      },
      "source": [
        "xscaled"
      ],
      "execution_count": 52,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array([[0.00000000e+00, 2.91521417e-05, 1.27397366e-01, ...,\n",
              "        1.29248198e-01, 1.95236236e-02, 0.00000000e+00],\n",
              "       [0.00000000e+00, 1.38875530e-05, 2.09042594e-01, ...,\n",
              "        1.39546859e-01, 2.65521281e-02, 0.00000000e+00],\n",
              "       [0.00000000e+00, 1.13151328e-04, 1.52044982e-01, ...,\n",
              "        2.01338826e-01, 0.00000000e+00, 1.34957826e-02],\n",
              "       ...,\n",
              "       [1.11111111e-01, 9.69491830e-05, 2.37772472e-01, ...,\n",
              "        7.88877446e-01, 0.00000000e+00, 7.39456420e-01],\n",
              "       [0.00000000e+00, 3.08857420e-03, 1.28321651e-01, ...,\n",
              "        3.08959835e-02, 1.52284264e-02, 1.34957826e-02],\n",
              "       [1.11111111e-01, 9.68026898e-05, 2.21905569e-01, ...,\n",
              "        1.19464470e-01, 1.79617337e-02, 2.39550141e-01]])"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 52
        }
      ]
    }
  ]
}