06_Generación_de_nuevos_datos_2da_Iteración.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Generación de nuevos datos_2da Iteración",
      "provenance": [],
      "collapsed_sections": [],
      "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/Narcilaq/Monografia/blob/main/Generaci%C3%B3n_de_nuevos_datos_2da_Iteraci%C3%B3n.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "V0IvozGyo43k"
      },
      "source": [
        "# **Carga de las Librerías**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "_ntWk9TvQepR"
      },
      "source": [
        "import numpy as np\n",
        "import pandas as pd\n",
        "import random\n",
        "\n",
        "import matplotlib.pyplot as plt\n",
        "from matplotlib import ticker"
      ],
      "execution_count": 1,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "_9kFRleP3y4K"
      },
      "source": [
        "# **Generación de Datos para Entrenamiento**"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "WDwpGR_Pxipd"
      },
      "source": [
        "Se genera un nuevo Dataset sintético, pero en esta ocasión a diferencia del primer set de datos donde los datos se generaron desde la hora 12 a la 24, en esta ocasión se generará desde la hora 11 a 24, puesto que se planea obtener no le dato de deformación sino la diferencia entre los registros consecutivos (tasa de variación)"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "p34GRBsj390s"
      },
      "source": [
        "xmin = 11\n",
        "xmax = 24\n",
        "t = np.linspace(xmin,xmax,xmax-xmin+1)\n",
        "P_var = 0.0005\n",
        "var = 1+np.random.uniform(-P_var,P_var,len(t))\n",
        "\n",
        "Nivel_Alerta_1_Verde = []\n",
        "\n",
        "for i in range(1000):\n",
        "\n",
        "  L = random.uniform(0.01000, 0.10000)\n",
        "  k = random.uniform(0.01000, 0.0256)\n",
        "\n",
        "  def DeformacionConVariabilidad(t0):\n",
        "    return (t-11), (L / (1. + np.exp(-k * (t - t0))*var)*-1)\n",
        "  \n",
        "  MiDefConVar=DeformacionConVariabilidad(24)\n",
        "  Nivel_Alerta_1_Verde.append([MiDefConVar[1]])\n",
        "\n",
        "\n",
        "Nivel_Alerta_2_Amarillo = []\n",
        "\n",
        "for i in range(1000):\n",
        "\n",
        "  L = random.uniform(0.10001, 0.50000)\n",
        "  k = random.uniform(0.02560, 0.03024)\n",
        "  \n",
        "  def DeformacionConVariabilidad(t0):\n",
        "    return (t-11), (L / (1. + np.exp(-k * (t - t0))*var)*-1)\n",
        "  \n",
        "  MiDefConVar=DeformacionConVariabilidad(24)\n",
        "  Nivel_Alerta_2_Amarillo.append([MiDefConVar[1]])\n",
        "\n",
        "\n",
        "Nivel_Alerta_3_Naranja = []\n",
        "\n",
        "for i in range(1000):\n",
        "\n",
        "  L = random.uniform(0.50001, 1.00000)\n",
        "  k = random.uniform(0.03024, 0.04117)\n",
        "  \n",
        "  def DeformacionConVariabilidad(t0):\n",
        "    return (t-11), (L / (1. + np.exp(-k * (t - t0))*var)*-1)\n",
        "  \n",
        "  MiDefConVar=DeformacionConVariabilidad(24)\n",
        "  Nivel_Alerta_3_Naranja.append([MiDefConVar[1]])\n",
        "\n",
        "\n",
        "Nivel_Alerta_4_Roja = []\n",
        "\n",
        "for i in range(1000):\n",
        "\n",
        "  L = random.uniform(1.0500, 1.20000)\n",
        "  k = random.uniform(0.04118, 0.05265)\n",
        "  \n",
        "  def DeformacionConVariabilidad(t0):\n",
        "    return (t-11), (L / (1. + np.exp(-k * (t - t0))*var)*-1)\n",
        "  \n",
        "  MiDefConVar=DeformacionConVariabilidad(24)\n",
        "  Nivel_Alerta_4_Roja.append([MiDefConVar[1]])"
      ],
      "execution_count": 2,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "XRgPX1EC5vqs",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 540
        },
        "outputId": "926370c0-5da6-4e4e-d80e-2f264bce7a5e"
      },
      "source": [
        "d_Al1 = pd.DataFrame(np.concatenate(Nivel_Alerta_1_Verde))\n",
        "d_Al1 = d_Al1.assign(Target='Alerta_1')\n",
        "\n",
        "d_Al2 = pd.DataFrame(np.concatenate(Nivel_Alerta_2_Amarillo))\n",
        "d_Al2 = d_Al2.assign(Target='Alerta_2')\n",
        "\n",
        "d_Al3 = pd.DataFrame(np.concatenate(Nivel_Alerta_3_Naranja))\n",
        "d_Al3 = d_Al3.assign(Target='Alerta_3')\n",
        "\n",
        "d_Al4 = pd.DataFrame(np.concatenate(Nivel_Alerta_4_Roja))\n",
        "d_Al4 = d_Al4.assign(Target='Alerta_4')  \n",
        "\n",
        "Data_Iter_2 = pd.concat([d_Al1, d_Al2, d_Al3, d_Al4], axis=0)\n",
        "\n",
        "Data_Iter_2.to_excel('2do_Dataset.xlsx')\n",
        "\n",
        "Data_Iter_2.head(15)"
      ],
      "execution_count": 3,
      "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>0</th>\n",
              "      <th>1</th>\n",
              "      <th>2</th>\n",
              "      <th>3</th>\n",
              "      <th>4</th>\n",
              "      <th>5</th>\n",
              "      <th>6</th>\n",
              "      <th>7</th>\n",
              "      <th>8</th>\n",
              "      <th>9</th>\n",
              "      <th>10</th>\n",
              "      <th>11</th>\n",
              "      <th>12</th>\n",
              "      <th>13</th>\n",
              "      <th>Target</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>-0.018153</td>\n",
              "      <td>-0.018251</td>\n",
              "      <td>-0.018353</td>\n",
              "      <td>-0.018450</td>\n",
              "      <td>-0.018547</td>\n",
              "      <td>-0.018650</td>\n",
              "      <td>-0.018755</td>\n",
              "      <td>-0.018853</td>\n",
              "      <td>-0.018952</td>\n",
              "      <td>-0.019051</td>\n",
              "      <td>-0.019155</td>\n",
              "      <td>-0.019251</td>\n",
              "      <td>-0.019352</td>\n",
              "      <td>-0.019453</td>\n",
              "      <td>Alerta_1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>-0.018583</td>\n",
              "      <td>-0.018700</td>\n",
              "      <td>-0.018820</td>\n",
              "      <td>-0.018937</td>\n",
              "      <td>-0.019052</td>\n",
              "      <td>-0.019174</td>\n",
              "      <td>-0.019298</td>\n",
              "      <td>-0.019416</td>\n",
              "      <td>-0.019533</td>\n",
              "      <td>-0.019651</td>\n",
              "      <td>-0.019774</td>\n",
              "      <td>-0.019889</td>\n",
              "      <td>-0.020009</td>\n",
              "      <td>-0.020129</td>\n",
              "      <td>Alerta_1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>-0.040692</td>\n",
              "      <td>-0.040914</td>\n",
              "      <td>-0.041144</td>\n",
              "      <td>-0.041365</td>\n",
              "      <td>-0.041584</td>\n",
              "      <td>-0.041817</td>\n",
              "      <td>-0.042055</td>\n",
              "      <td>-0.042279</td>\n",
              "      <td>-0.042502</td>\n",
              "      <td>-0.042726</td>\n",
              "      <td>-0.042961</td>\n",
              "      <td>-0.043179</td>\n",
              "      <td>-0.043408</td>\n",
              "      <td>-0.043637</td>\n",
              "      <td>Alerta_1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>-0.041160</td>\n",
              "      <td>-0.041490</td>\n",
              "      <td>-0.041829</td>\n",
              "      <td>-0.042159</td>\n",
              "      <td>-0.042486</td>\n",
              "      <td>-0.042829</td>\n",
              "      <td>-0.043177</td>\n",
              "      <td>-0.043510</td>\n",
              "      <td>-0.043843</td>\n",
              "      <td>-0.044177</td>\n",
              "      <td>-0.044522</td>\n",
              "      <td>-0.044850</td>\n",
              "      <td>-0.045190</td>\n",
              "      <td>-0.045529</td>\n",
              "      <td>Alerta_1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>-0.034403</td>\n",
              "      <td>-0.034589</td>\n",
              "      <td>-0.034781</td>\n",
              "      <td>-0.034967</td>\n",
              "      <td>-0.035149</td>\n",
              "      <td>-0.035345</td>\n",
              "      <td>-0.035545</td>\n",
              "      <td>-0.035732</td>\n",
              "      <td>-0.035919</td>\n",
              "      <td>-0.036107</td>\n",
              "      <td>-0.036303</td>\n",
              "      <td>-0.036486</td>\n",
              "      <td>-0.036678</td>\n",
              "      <td>-0.036870</td>\n",
              "      <td>Alerta_1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>-0.020712</td>\n",
              "      <td>-0.020880</td>\n",
              "      <td>-0.021054</td>\n",
              "      <td>-0.021223</td>\n",
              "      <td>-0.021390</td>\n",
              "      <td>-0.021565</td>\n",
              "      <td>-0.021743</td>\n",
              "      <td>-0.021914</td>\n",
              "      <td>-0.022084</td>\n",
              "      <td>-0.022255</td>\n",
              "      <td>-0.022431</td>\n",
              "      <td>-0.022599</td>\n",
              "      <td>-0.022773</td>\n",
              "      <td>-0.022947</td>\n",
              "      <td>Alerta_1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>-0.016523</td>\n",
              "      <td>-0.016769</td>\n",
              "      <td>-0.017018</td>\n",
              "      <td>-0.017265</td>\n",
              "      <td>-0.017511</td>\n",
              "      <td>-0.017764</td>\n",
              "      <td>-0.018020</td>\n",
              "      <td>-0.018270</td>\n",
              "      <td>-0.018521</td>\n",
              "      <td>-0.018772</td>\n",
              "      <td>-0.019028</td>\n",
              "      <td>-0.019277</td>\n",
              "      <td>-0.019531</td>\n",
              "      <td>-0.019786</td>\n",
              "      <td>Alerta_1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>-0.009546</td>\n",
              "      <td>-0.009683</td>\n",
              "      <td>-0.009823</td>\n",
              "      <td>-0.009961</td>\n",
              "      <td>-0.010098</td>\n",
              "      <td>-0.010240</td>\n",
              "      <td>-0.010383</td>\n",
              "      <td>-0.010523</td>\n",
              "      <td>-0.010662</td>\n",
              "      <td>-0.010803</td>\n",
              "      <td>-0.010946</td>\n",
              "      <td>-0.011085</td>\n",
              "      <td>-0.011227</td>\n",
              "      <td>-0.011369</td>\n",
              "      <td>Alerta_1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>-0.032428</td>\n",
              "      <td>-0.032808</td>\n",
              "      <td>-0.033196</td>\n",
              "      <td>-0.033577</td>\n",
              "      <td>-0.033957</td>\n",
              "      <td>-0.034350</td>\n",
              "      <td>-0.034748</td>\n",
              "      <td>-0.035133</td>\n",
              "      <td>-0.035519</td>\n",
              "      <td>-0.035907</td>\n",
              "      <td>-0.036303</td>\n",
              "      <td>-0.036685</td>\n",
              "      <td>-0.037078</td>\n",
              "      <td>-0.037470</td>\n",
              "      <td>Alerta_1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>-0.038575</td>\n",
              "      <td>-0.038998</td>\n",
              "      <td>-0.039429</td>\n",
              "      <td>-0.039853</td>\n",
              "      <td>-0.040274</td>\n",
              "      <td>-0.040712</td>\n",
              "      <td>-0.041154</td>\n",
              "      <td>-0.041582</td>\n",
              "      <td>-0.042011</td>\n",
              "      <td>-0.042441</td>\n",
              "      <td>-0.042881</td>\n",
              "      <td>-0.043305</td>\n",
              "      <td>-0.043741</td>\n",
              "      <td>-0.044176</td>\n",
              "      <td>Alerta_1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>-0.036731</td>\n",
              "      <td>-0.037218</td>\n",
              "      <td>-0.037715</td>\n",
              "      <td>-0.038204</td>\n",
              "      <td>-0.038691</td>\n",
              "      <td>-0.039195</td>\n",
              "      <td>-0.039703</td>\n",
              "      <td>-0.040198</td>\n",
              "      <td>-0.040694</td>\n",
              "      <td>-0.041192</td>\n",
              "      <td>-0.041700</td>\n",
              "      <td>-0.042192</td>\n",
              "      <td>-0.042696</td>\n",
              "      <td>-0.043199</td>\n",
              "      <td>Alerta_1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>-0.019527</td>\n",
              "      <td>-0.019806</td>\n",
              "      <td>-0.020090</td>\n",
              "      <td>-0.020371</td>\n",
              "      <td>-0.020650</td>\n",
              "      <td>-0.020939</td>\n",
              "      <td>-0.021230</td>\n",
              "      <td>-0.021514</td>\n",
              "      <td>-0.021799</td>\n",
              "      <td>-0.022084</td>\n",
              "      <td>-0.022376</td>\n",
              "      <td>-0.022658</td>\n",
              "      <td>-0.022948</td>\n",
              "      <td>-0.023237</td>\n",
              "      <td>Alerta_1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>-0.036180</td>\n",
              "      <td>-0.036383</td>\n",
              "      <td>-0.036593</td>\n",
              "      <td>-0.036796</td>\n",
              "      <td>-0.036996</td>\n",
              "      <td>-0.037210</td>\n",
              "      <td>-0.037428</td>\n",
              "      <td>-0.037632</td>\n",
              "      <td>-0.037837</td>\n",
              "      <td>-0.038042</td>\n",
              "      <td>-0.038257</td>\n",
              "      <td>-0.038457</td>\n",
              "      <td>-0.038667</td>\n",
              "      <td>-0.038877</td>\n",
              "      <td>Alerta_1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>-0.018746</td>\n",
              "      <td>-0.018945</td>\n",
              "      <td>-0.019149</td>\n",
              "      <td>-0.019350</td>\n",
              "      <td>-0.019549</td>\n",
              "      <td>-0.019755</td>\n",
              "      <td>-0.019964</td>\n",
              "      <td>-0.020167</td>\n",
              "      <td>-0.020369</td>\n",
              "      <td>-0.020572</td>\n",
              "      <td>-0.020780</td>\n",
              "      <td>-0.020980</td>\n",
              "      <td>-0.021186</td>\n",
              "      <td>-0.021392</td>\n",
              "      <td>Alerta_1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>-0.035707</td>\n",
              "      <td>-0.036066</td>\n",
              "      <td>-0.036432</td>\n",
              "      <td>-0.036791</td>\n",
              "      <td>-0.037148</td>\n",
              "      <td>-0.037520</td>\n",
              "      <td>-0.037896</td>\n",
              "      <td>-0.038258</td>\n",
              "      <td>-0.038621</td>\n",
              "      <td>-0.038986</td>\n",
              "      <td>-0.039359</td>\n",
              "      <td>-0.039718</td>\n",
              "      <td>-0.040087</td>\n",
              "      <td>-0.040456</td>\n",
              "      <td>Alerta_1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "           0         1         2  ...        12        13    Target\n",
              "0  -0.018153 -0.018251 -0.018353  ... -0.019352 -0.019453  Alerta_1\n",
              "1  -0.018583 -0.018700 -0.018820  ... -0.020009 -0.020129  Alerta_1\n",
              "2  -0.040692 -0.040914 -0.041144  ... -0.043408 -0.043637  Alerta_1\n",
              "3  -0.041160 -0.041490 -0.041829  ... -0.045190 -0.045529  Alerta_1\n",
              "4  -0.034403 -0.034589 -0.034781  ... -0.036678 -0.036870  Alerta_1\n",
              "5  -0.020712 -0.020880 -0.021054  ... -0.022773 -0.022947  Alerta_1\n",
              "6  -0.016523 -0.016769 -0.017018  ... -0.019531 -0.019786  Alerta_1\n",
              "7  -0.009546 -0.009683 -0.009823  ... -0.011227 -0.011369  Alerta_1\n",
              "8  -0.032428 -0.032808 -0.033196  ... -0.037078 -0.037470  Alerta_1\n",
              "9  -0.038575 -0.038998 -0.039429  ... -0.043741 -0.044176  Alerta_1\n",
              "10 -0.036731 -0.037218 -0.037715  ... -0.042696 -0.043199  Alerta_1\n",
              "11 -0.019527 -0.019806 -0.020090  ... -0.022948 -0.023237  Alerta_1\n",
              "12 -0.036180 -0.036383 -0.036593  ... -0.038667 -0.038877  Alerta_1\n",
              "13 -0.018746 -0.018945 -0.019149  ... -0.021186 -0.021392  Alerta_1\n",
              "14 -0.035707 -0.036066 -0.036432  ... -0.040087 -0.040456  Alerta_1\n",
              "\n",
              "[15 rows x 15 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "_o8K8jKLynzf"
      },
      "source": [
        "Generados los nuevos datos sintéticos se realiza un feature engineering transformando los datos de deformación bruta entre las 11 y 24 horas a las tasas de cambio registradas entre las 12 y 24 horas.  "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "pNgkvVtyLdYZ",
        "outputId": "568a4e53-e39f-43e9-d1ec-7f03bf9e2646"
      },
      "source": [
        "Labels = Data_Iter_2.Target\n",
        "Data_Iter_2 = (Data_Iter_2.drop(['Target'], axis =1).diff(axis=1).drop([0], axis =1))\n",
        "Data_Iter_2['Target'] = Labels\n",
        "Data_Iter_2.columns =['Señal_0', 'Señal_1', 'Señal_2', 'Señal_3', 'Señal_4', 'Señal_5','Señal_6', \n",
        "               'Señal_7', 'Señal_8', 'Señal_9', 'Señal_10', 'Señal_11','Señal_12','Target']\n",
        "Data_Iter_2.head()"
      ],
      "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>Señal_0</th>\n",
              "      <th>Señal_1</th>\n",
              "      <th>Señal_2</th>\n",
              "      <th>Señal_3</th>\n",
              "      <th>Señal_4</th>\n",
              "      <th>Señal_5</th>\n",
              "      <th>Señal_6</th>\n",
              "      <th>Señal_7</th>\n",
              "      <th>Señal_8</th>\n",
              "      <th>Señal_9</th>\n",
              "      <th>Señal_10</th>\n",
              "      <th>Señal_11</th>\n",
              "      <th>Señal_12</th>\n",
              "      <th>Target</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>-0.000098</td>\n",
              "      <td>-0.000102</td>\n",
              "      <td>-0.000098</td>\n",
              "      <td>-0.000096</td>\n",
              "      <td>-0.000103</td>\n",
              "      <td>-0.000105</td>\n",
              "      <td>-0.000099</td>\n",
              "      <td>-0.000098</td>\n",
              "      <td>-0.000099</td>\n",
              "      <td>-0.000104</td>\n",
              "      <td>-0.000096</td>\n",
              "      <td>-0.000101</td>\n",
              "      <td>-0.000101</td>\n",
              "      <td>Alerta_1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>-0.000117</td>\n",
              "      <td>-0.000120</td>\n",
              "      <td>-0.000116</td>\n",
              "      <td>-0.000115</td>\n",
              "      <td>-0.000122</td>\n",
              "      <td>-0.000124</td>\n",
              "      <td>-0.000117</td>\n",
              "      <td>-0.000117</td>\n",
              "      <td>-0.000118</td>\n",
              "      <td>-0.000123</td>\n",
              "      <td>-0.000115</td>\n",
              "      <td>-0.000120</td>\n",
              "      <td>-0.000120</td>\n",
              "      <td>Alerta_1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>-0.000222</td>\n",
              "      <td>-0.000230</td>\n",
              "      <td>-0.000221</td>\n",
              "      <td>-0.000218</td>\n",
              "      <td>-0.000234</td>\n",
              "      <td>-0.000238</td>\n",
              "      <td>-0.000223</td>\n",
              "      <td>-0.000223</td>\n",
              "      <td>-0.000225</td>\n",
              "      <td>-0.000235</td>\n",
              "      <td>-0.000218</td>\n",
              "      <td>-0.000229</td>\n",
              "      <td>-0.000229</td>\n",
              "      <td>Alerta_1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>-0.000330</td>\n",
              "      <td>-0.000339</td>\n",
              "      <td>-0.000330</td>\n",
              "      <td>-0.000327</td>\n",
              "      <td>-0.000343</td>\n",
              "      <td>-0.000348</td>\n",
              "      <td>-0.000333</td>\n",
              "      <td>-0.000333</td>\n",
              "      <td>-0.000334</td>\n",
              "      <td>-0.000345</td>\n",
              "      <td>-0.000328</td>\n",
              "      <td>-0.000340</td>\n",
              "      <td>-0.000340</td>\n",
              "      <td>Alerta_1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>-0.000186</td>\n",
              "      <td>-0.000193</td>\n",
              "      <td>-0.000185</td>\n",
              "      <td>-0.000183</td>\n",
              "      <td>-0.000196</td>\n",
              "      <td>-0.000199</td>\n",
              "      <td>-0.000187</td>\n",
              "      <td>-0.000187</td>\n",
              "      <td>-0.000188</td>\n",
              "      <td>-0.000197</td>\n",
              "      <td>-0.000182</td>\n",
              "      <td>-0.000192</td>\n",
              "      <td>-0.000192</td>\n",
              "      <td>Alerta_1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "    Señal_0   Señal_1   Señal_2  ...  Señal_11  Señal_12    Target\n",
              "0 -0.000098 -0.000102 -0.000098  ... -0.000101 -0.000101  Alerta_1\n",
              "1 -0.000117 -0.000120 -0.000116  ... -0.000120 -0.000120  Alerta_1\n",
              "2 -0.000222 -0.000230 -0.000221  ... -0.000229 -0.000229  Alerta_1\n",
              "3 -0.000330 -0.000339 -0.000330  ... -0.000340 -0.000340  Alerta_1\n",
              "4 -0.000186 -0.000193 -0.000185  ... -0.000192 -0.000192  Alerta_1\n",
              "\n",
              "[5 rows x 14 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "87lz8Y57_YYz"
      },
      "source": [
        "Data_Iter_2.to_excel('2do_Dataset_Tasas.xlsx')"
      ],
      "execution_count": 5,
      "outputs": []
    }
  ]
}