Create_Logistic_Regression_and_MLP_Features.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "UXOc2TYranAV"
      },
      "outputs": [],
      "source": [
        "from google.colab import drive\n",
        "import os\n",
        "import pandas as pd\n",
        "import numpy as np\n",
        "from scipy.stats import skew, kurtosis\n",
        "import json"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "pd.set_option('display.max_columns', None)"
      ],
      "metadata": {
        "id": "B_Zdc3ySdLBq"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "## 0. Load Data From Drive"
      ],
      "metadata": {
        "id": "JAAqalX0aw3a"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "drive.mount('/content/drive/')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "vUHLmRHMapco",
        "outputId": "5d083f2f-db4c-48ff-bec0-b82cb098708f"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Mounted at /content/drive/\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "DATA_DIR = '/content/drive/My Drive/CS6140_final_project/Data/'\n",
        "PREPROCESSED_DATA_F = 'preprocessed_data_variable_hour_window_cols.csv'\n",
        "PREPROCESSED_DATA_LOC = os.path.join(DATA_DIR, PREPROCESSED_DATA_F)"
      ],
      "metadata": {
        "id": "Tx-shHqdapeg"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df = pd.read_csv(\n",
        "    PREPROCESSED_DATA_LOC,\n",
        ")\n",
        "print(f\"- {format(len(df), ',')} total rows in df.\")"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "0gFDZD1wa8UJ",
        "outputId": "6f66fc60-f248-4dbf-dc8e-8376570a5815"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "- 876,100 total rows in df.\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 394
        },
        "id": "MpUj3aJwvChw",
        "outputId": "c68544fa-6764-4431-8af4-27757a66c256"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "              datetime  machineID        volt      rotate    pressure  \\\n",
              "0  2015-01-01 06:00:00          1  176.217853  418.504078  113.077935   \n",
              "1  2015-01-01 07:00:00          1  162.879223  402.747490   95.460525   \n",
              "2  2015-01-01 08:00:00          1  170.989902  527.349825   75.237905   \n",
              "3  2015-01-01 09:00:00          1  162.462833  346.149335  109.248561   \n",
              "4  2015-01-01 10:00:00          1  157.610021  435.376873  111.886648   \n",
              "\n",
              "   vibration  12_machineID_time_window  12_order_in_time_window  \\\n",
              "0  45.087686                         1                        1   \n",
              "1  43.413973                         1                        2   \n",
              "2  34.178847                         1                        3   \n",
              "3  41.122144                         1                        4   \n",
              "4  25.990511                         1                        5   \n",
              "\n",
              "  12_machine_example_ID       12_step_ID  24_machineID_time_window  \\\n",
              "0            (001, 001)  (001, 001, 001)                         1   \n",
              "1            (001, 001)  (001, 001, 002)                         1   \n",
              "2            (001, 001)  (001, 001, 003)                         1   \n",
              "3            (001, 001)  (001, 001, 004)                         1   \n",
              "4            (001, 001)  (001, 001, 005)                         1   \n",
              "\n",
              "   24_order_in_time_window 24_machine_example_ID       24_step_ID  \\\n",
              "0                        1            (001, 001)  (001, 001, 001)   \n",
              "1                        2            (001, 001)  (001, 001, 002)   \n",
              "2                        3            (001, 001)  (001, 001, 003)   \n",
              "3                        4            (001, 001)  (001, 001, 004)   \n",
              "4                        5            (001, 001)  (001, 001, 005)   \n",
              "\n",
              "   48_machineID_time_window  48_order_in_time_window 48_machine_example_ID  \\\n",
              "0                         1                        1            (001, 001)   \n",
              "1                         1                        2            (001, 001)   \n",
              "2                         1                        3            (001, 001)   \n",
              "3                         1                        4            (001, 001)   \n",
              "4                         1                        5            (001, 001)   \n",
              "\n",
              "        48_step_ID  72_machineID_time_window  72_order_in_time_window  \\\n",
              "0  (001, 001, 001)                         1                        1   \n",
              "1  (001, 001, 002)                         1                        2   \n",
              "2  (001, 001, 003)                         1                        3   \n",
              "3  (001, 001, 004)                         1                        4   \n",
              "4  (001, 001, 005)                         1                        5   \n",
              "\n",
              "  72_machine_example_ID       72_step_ID  comp1_maint  comp2_maint  \\\n",
              "0            (001, 001)  (001, 001, 001)            0            0   \n",
              "1            (001, 001)  (001, 001, 002)            0            0   \n",
              "2            (001, 001)  (001, 001, 003)            0            0   \n",
              "3            (001, 001)  (001, 001, 004)            0            0   \n",
              "4            (001, 001)  (001, 001, 005)            0            0   \n",
              "\n",
              "   comp3_maint  comp4_maint  error1  error2  error3  error4  error5  \\\n",
              "0            0            0       0       0       0       0       0   \n",
              "1            0            0       0       0       0       0       0   \n",
              "2            0            0       0       0       0       0       0   \n",
              "3            0            0       0       0       0       0       0   \n",
              "4            0            0       0       0       0       0       0   \n",
              "\n",
              "   comp1_failure  comp2_failure  comp3_failure  comp4_failure  age  model2  \\\n",
              "0              0              0              0              0   18   False   \n",
              "1              0              0              0              0   18   False   \n",
              "2              0              0              0              0   18   False   \n",
              "3              0              0              0              0   18   False   \n",
              "4              0              0              0              0   18   False   \n",
              "\n",
              "   model3  model4  \n",
              "0    True   False  \n",
              "1    True   False  \n",
              "2    True   False  \n",
              "3    True   False  \n",
              "4    True   False  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-0dc0f6c4-a031-4e14-8e06-dfb547b3aaf7\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>datetime</th>\n",
              "      <th>machineID</th>\n",
              "      <th>volt</th>\n",
              "      <th>rotate</th>\n",
              "      <th>pressure</th>\n",
              "      <th>vibration</th>\n",
              "      <th>12_machineID_time_window</th>\n",
              "      <th>12_order_in_time_window</th>\n",
              "      <th>12_machine_example_ID</th>\n",
              "      <th>12_step_ID</th>\n",
              "      <th>24_machineID_time_window</th>\n",
              "      <th>24_order_in_time_window</th>\n",
              "      <th>24_machine_example_ID</th>\n",
              "      <th>24_step_ID</th>\n",
              "      <th>48_machineID_time_window</th>\n",
              "      <th>48_order_in_time_window</th>\n",
              "      <th>48_machine_example_ID</th>\n",
              "      <th>48_step_ID</th>\n",
              "      <th>72_machineID_time_window</th>\n",
              "      <th>72_order_in_time_window</th>\n",
              "      <th>72_machine_example_ID</th>\n",
              "      <th>72_step_ID</th>\n",
              "      <th>comp1_maint</th>\n",
              "      <th>comp2_maint</th>\n",
              "      <th>comp3_maint</th>\n",
              "      <th>comp4_maint</th>\n",
              "      <th>error1</th>\n",
              "      <th>error2</th>\n",
              "      <th>error3</th>\n",
              "      <th>error4</th>\n",
              "      <th>error5</th>\n",
              "      <th>comp1_failure</th>\n",
              "      <th>comp2_failure</th>\n",
              "      <th>comp3_failure</th>\n",
              "      <th>comp4_failure</th>\n",
              "      <th>age</th>\n",
              "      <th>model2</th>\n",
              "      <th>model3</th>\n",
              "      <th>model4</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2015-01-01 06:00:00</td>\n",
              "      <td>1</td>\n",
              "      <td>176.217853</td>\n",
              "      <td>418.504078</td>\n",
              "      <td>113.077935</td>\n",
              "      <td>45.087686</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 001)</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 001)</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 001)</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 001)</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2015-01-01 07:00:00</td>\n",
              "      <td>1</td>\n",
              "      <td>162.879223</td>\n",
              "      <td>402.747490</td>\n",
              "      <td>95.460525</td>\n",
              "      <td>43.413973</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 002)</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 002)</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 002)</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 002)</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2015-01-01 08:00:00</td>\n",
              "      <td>1</td>\n",
              "      <td>170.989902</td>\n",
              "      <td>527.349825</td>\n",
              "      <td>75.237905</td>\n",
              "      <td>34.178847</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 003)</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 003)</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 003)</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 003)</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2015-01-01 09:00:00</td>\n",
              "      <td>1</td>\n",
              "      <td>162.462833</td>\n",
              "      <td>346.149335</td>\n",
              "      <td>109.248561</td>\n",
              "      <td>41.122144</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 004)</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 004)</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 004)</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 004)</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2015-01-01 10:00:00</td>\n",
              "      <td>1</td>\n",
              "      <td>157.610021</td>\n",
              "      <td>435.376873</td>\n",
              "      <td>111.886648</td>\n",
              "      <td>25.990511</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 005)</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 005)</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 005)</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 005)</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-0dc0f6c4-a031-4e14-8e06-dfb547b3aaf7')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-0dc0f6c4-a031-4e14-8e06-dfb547b3aaf7 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-0dc0f6c4-a031-4e14-8e06-dfb547b3aaf7');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-cf83a542-030d-4d31-8cec-9ec61d7bbc63\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-cf83a542-030d-4d31-8cec-9ec61d7bbc63')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-cf83a542-030d-4d31-8cec-9ec61d7bbc63 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "df"
            }
          },
          "metadata": {},
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## 1. Postprocess Data"
      ],
      "metadata": {
        "id": "fuEAmSHpcCAp"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df['datetime'] = pd.to_datetime(df['datetime'])\n",
        "df['12_machine_example_ID'] = df['12_machine_example_ID'].astype(str)\n",
        "df['24_machine_example_ID'] = df['24_machine_example_ID'].astype(str)\n",
        "df['48_machine_example_ID'] = df['48_machine_example_ID'].astype(str)\n",
        "df['72_machine_example_ID'] = df['72_machine_example_ID'].astype(str)\n",
        "df['12_step_ID'] = df['12_step_ID'].astype(str)\n",
        "df['24_step_ID'] = df['24_step_ID'].astype(str)\n",
        "df['48_step_ID'] = df['48_step_ID'].astype(str)\n",
        "df['72_step_ID'] = df['72_step_ID'].astype(str)\n",
        "df['model2'] = df['model2'].astype(int)\n",
        "df['model3'] = df['model3'].astype(int)\n",
        "df['model4'] = df['model4'].astype(int)\n",
        "df.info()"
      ],
      "metadata": {
        "id": "-TMdgBYBbHny",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "dc3b32e0-350e-4ab3-ee2c-49a6dd18d30b"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 876100 entries, 0 to 876099\n",
            "Data columns (total 39 columns):\n",
            " #   Column                    Non-Null Count   Dtype         \n",
            "---  ------                    --------------   -----         \n",
            " 0   datetime                  876100 non-null  datetime64[ns]\n",
            " 1   machineID                 876100 non-null  int64         \n",
            " 2   volt                      876100 non-null  float64       \n",
            " 3   rotate                    876100 non-null  float64       \n",
            " 4   pressure                  876100 non-null  float64       \n",
            " 5   vibration                 876100 non-null  float64       \n",
            " 6   12_machineID_time_window  876100 non-null  int64         \n",
            " 7   12_order_in_time_window   876100 non-null  int64         \n",
            " 8   12_machine_example_ID     876100 non-null  object        \n",
            " 9   12_step_ID                876100 non-null  object        \n",
            " 10  24_machineID_time_window  876100 non-null  int64         \n",
            " 11  24_order_in_time_window   876100 non-null  int64         \n",
            " 12  24_machine_example_ID     876100 non-null  object        \n",
            " 13  24_step_ID                876100 non-null  object        \n",
            " 14  48_machineID_time_window  876100 non-null  int64         \n",
            " 15  48_order_in_time_window   876100 non-null  int64         \n",
            " 16  48_machine_example_ID     876100 non-null  object        \n",
            " 17  48_step_ID                876100 non-null  object        \n",
            " 18  72_machineID_time_window  876100 non-null  int64         \n",
            " 19  72_order_in_time_window   876100 non-null  int64         \n",
            " 20  72_machine_example_ID     876100 non-null  object        \n",
            " 21  72_step_ID                876100 non-null  object        \n",
            " 22  comp1_maint               876100 non-null  int64         \n",
            " 23  comp2_maint               876100 non-null  int64         \n",
            " 24  comp3_maint               876100 non-null  int64         \n",
            " 25  comp4_maint               876100 non-null  int64         \n",
            " 26  error1                    876100 non-null  int64         \n",
            " 27  error2                    876100 non-null  int64         \n",
            " 28  error3                    876100 non-null  int64         \n",
            " 29  error4                    876100 non-null  int64         \n",
            " 30  error5                    876100 non-null  int64         \n",
            " 31  comp1_failure             876100 non-null  int64         \n",
            " 32  comp2_failure             876100 non-null  int64         \n",
            " 33  comp3_failure             876100 non-null  int64         \n",
            " 34  comp4_failure             876100 non-null  int64         \n",
            " 35  age                       876100 non-null  int64         \n",
            " 36  model2                    876100 non-null  int64         \n",
            " 37  model3                    876100 non-null  int64         \n",
            " 38  model4                    876100 non-null  int64         \n",
            "dtypes: datetime64[ns](1), float64(4), int64(26), object(8)\n",
            "memory usage: 260.7+ MB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 394
        },
        "id": "kkGuBtU2AzBV",
        "outputId": "e5ec9769-03cb-4d21-cc21-445ea3978c6d"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "             datetime  machineID        volt      rotate    pressure  \\\n",
              "0 2015-01-01 06:00:00          1  176.217853  418.504078  113.077935   \n",
              "1 2015-01-01 07:00:00          1  162.879223  402.747490   95.460525   \n",
              "2 2015-01-01 08:00:00          1  170.989902  527.349825   75.237905   \n",
              "3 2015-01-01 09:00:00          1  162.462833  346.149335  109.248561   \n",
              "4 2015-01-01 10:00:00          1  157.610021  435.376873  111.886648   \n",
              "\n",
              "   vibration  12_machineID_time_window  12_order_in_time_window  \\\n",
              "0  45.087686                         1                        1   \n",
              "1  43.413973                         1                        2   \n",
              "2  34.178847                         1                        3   \n",
              "3  41.122144                         1                        4   \n",
              "4  25.990511                         1                        5   \n",
              "\n",
              "  12_machine_example_ID       12_step_ID  24_machineID_time_window  \\\n",
              "0            (001, 001)  (001, 001, 001)                         1   \n",
              "1            (001, 001)  (001, 001, 002)                         1   \n",
              "2            (001, 001)  (001, 001, 003)                         1   \n",
              "3            (001, 001)  (001, 001, 004)                         1   \n",
              "4            (001, 001)  (001, 001, 005)                         1   \n",
              "\n",
              "   24_order_in_time_window 24_machine_example_ID       24_step_ID  \\\n",
              "0                        1            (001, 001)  (001, 001, 001)   \n",
              "1                        2            (001, 001)  (001, 001, 002)   \n",
              "2                        3            (001, 001)  (001, 001, 003)   \n",
              "3                        4            (001, 001)  (001, 001, 004)   \n",
              "4                        5            (001, 001)  (001, 001, 005)   \n",
              "\n",
              "   48_machineID_time_window  48_order_in_time_window 48_machine_example_ID  \\\n",
              "0                         1                        1            (001, 001)   \n",
              "1                         1                        2            (001, 001)   \n",
              "2                         1                        3            (001, 001)   \n",
              "3                         1                        4            (001, 001)   \n",
              "4                         1                        5            (001, 001)   \n",
              "\n",
              "        48_step_ID  72_machineID_time_window  72_order_in_time_window  \\\n",
              "0  (001, 001, 001)                         1                        1   \n",
              "1  (001, 001, 002)                         1                        2   \n",
              "2  (001, 001, 003)                         1                        3   \n",
              "3  (001, 001, 004)                         1                        4   \n",
              "4  (001, 001, 005)                         1                        5   \n",
              "\n",
              "  72_machine_example_ID       72_step_ID  comp1_maint  comp2_maint  \\\n",
              "0            (001, 001)  (001, 001, 001)            0            0   \n",
              "1            (001, 001)  (001, 001, 002)            0            0   \n",
              "2            (001, 001)  (001, 001, 003)            0            0   \n",
              "3            (001, 001)  (001, 001, 004)            0            0   \n",
              "4            (001, 001)  (001, 001, 005)            0            0   \n",
              "\n",
              "   comp3_maint  comp4_maint  error1  error2  error3  error4  error5  \\\n",
              "0            0            0       0       0       0       0       0   \n",
              "1            0            0       0       0       0       0       0   \n",
              "2            0            0       0       0       0       0       0   \n",
              "3            0            0       0       0       0       0       0   \n",
              "4            0            0       0       0       0       0       0   \n",
              "\n",
              "   comp1_failure  comp2_failure  comp3_failure  comp4_failure  age  model2  \\\n",
              "0              0              0              0              0   18       0   \n",
              "1              0              0              0              0   18       0   \n",
              "2              0              0              0              0   18       0   \n",
              "3              0              0              0              0   18       0   \n",
              "4              0              0              0              0   18       0   \n",
              "\n",
              "   model3  model4  \n",
              "0       1       0  \n",
              "1       1       0  \n",
              "2       1       0  \n",
              "3       1       0  \n",
              "4       1       0  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-fc266cbd-2d70-470e-b2ab-6b455d03a191\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>datetime</th>\n",
              "      <th>machineID</th>\n",
              "      <th>volt</th>\n",
              "      <th>rotate</th>\n",
              "      <th>pressure</th>\n",
              "      <th>vibration</th>\n",
              "      <th>12_machineID_time_window</th>\n",
              "      <th>12_order_in_time_window</th>\n",
              "      <th>12_machine_example_ID</th>\n",
              "      <th>12_step_ID</th>\n",
              "      <th>24_machineID_time_window</th>\n",
              "      <th>24_order_in_time_window</th>\n",
              "      <th>24_machine_example_ID</th>\n",
              "      <th>24_step_ID</th>\n",
              "      <th>48_machineID_time_window</th>\n",
              "      <th>48_order_in_time_window</th>\n",
              "      <th>48_machine_example_ID</th>\n",
              "      <th>48_step_ID</th>\n",
              "      <th>72_machineID_time_window</th>\n",
              "      <th>72_order_in_time_window</th>\n",
              "      <th>72_machine_example_ID</th>\n",
              "      <th>72_step_ID</th>\n",
              "      <th>comp1_maint</th>\n",
              "      <th>comp2_maint</th>\n",
              "      <th>comp3_maint</th>\n",
              "      <th>comp4_maint</th>\n",
              "      <th>error1</th>\n",
              "      <th>error2</th>\n",
              "      <th>error3</th>\n",
              "      <th>error4</th>\n",
              "      <th>error5</th>\n",
              "      <th>comp1_failure</th>\n",
              "      <th>comp2_failure</th>\n",
              "      <th>comp3_failure</th>\n",
              "      <th>comp4_failure</th>\n",
              "      <th>age</th>\n",
              "      <th>model2</th>\n",
              "      <th>model3</th>\n",
              "      <th>model4</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2015-01-01 06:00:00</td>\n",
              "      <td>1</td>\n",
              "      <td>176.217853</td>\n",
              "      <td>418.504078</td>\n",
              "      <td>113.077935</td>\n",
              "      <td>45.087686</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 001)</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 001)</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 001)</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 001)</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2015-01-01 07:00:00</td>\n",
              "      <td>1</td>\n",
              "      <td>162.879223</td>\n",
              "      <td>402.747490</td>\n",
              "      <td>95.460525</td>\n",
              "      <td>43.413973</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 002)</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 002)</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 002)</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 002)</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2015-01-01 08:00:00</td>\n",
              "      <td>1</td>\n",
              "      <td>170.989902</td>\n",
              "      <td>527.349825</td>\n",
              "      <td>75.237905</td>\n",
              "      <td>34.178847</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 003)</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 003)</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 003)</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 003)</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2015-01-01 09:00:00</td>\n",
              "      <td>1</td>\n",
              "      <td>162.462833</td>\n",
              "      <td>346.149335</td>\n",
              "      <td>109.248561</td>\n",
              "      <td>41.122144</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 004)</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 004)</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 004)</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 004)</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2015-01-01 10:00:00</td>\n",
              "      <td>1</td>\n",
              "      <td>157.610021</td>\n",
              "      <td>435.376873</td>\n",
              "      <td>111.886648</td>\n",
              "      <td>25.990511</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 005)</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 005)</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 005)</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>(001, 001, 005)</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-fc266cbd-2d70-470e-b2ab-6b455d03a191')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-fc266cbd-2d70-470e-b2ab-6b455d03a191 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-fc266cbd-2d70-470e-b2ab-6b455d03a191');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-60a75c54-d506-4c52-aeff-e892e3e7b56c\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-60a75c54-d506-4c52-aeff-e892e3e7b56c')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-60a75c54-d506-4c52-aeff-e892e3e7b56c button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "df"
            }
          },
          "metadata": {},
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "def aggregate_by_time_window(df: pd.DataFrame, time_window: int) -> pd.DataFrame:\n",
        "    \"\"\"\n",
        "    Purpose: Groups and aggregates the data based on the time windows passed in.\n",
        "    :param df: DataFrame containing machine data.\n",
        "    :param time_window: int representing the number of hours to group and aggregate the data into;\n",
        "        choose from 12, 24, 48, 72.\n",
        "    :return: DataFrame with data grouped and aggregated by 'machine_example_ID'\n",
        "    \"\"\"\n",
        "\n",
        "    # Check if the time window is valid\n",
        "    valid_time_windows = [12, 24, 48, 72]\n",
        "    if time_window not in valid_time_windows:\n",
        "        raise ValueError(\"Invalid time window. Please choose one of 12, 24, 48, 72.\")\n",
        "\n",
        "    def range(x):\n",
        "      return np.max(x) - np.min(x)\n",
        "\n",
        "    # Define aggregation functions for each column\n",
        "    agg_funcs = {\n",
        "        'datetime': 'first',\n",
        "        'machineID': 'first',\n",
        "        'volt': [\n",
        "            'mean', 'std', skew, kurtosis, 'min', 'max', range\n",
        "        ],\n",
        "        'rotate': [\n",
        "            'mean', 'std', skew, kurtosis, 'min', 'max', range\n",
        "        ],\n",
        "        'pressure': [\n",
        "            'mean', 'std', skew, kurtosis, 'min', 'max', range\n",
        "        ],\n",
        "        'vibration': [\n",
        "            'mean', 'std', skew, kurtosis, 'min', 'max', range\n",
        "        ],\n",
        "        'comp1_maint': 'sum',\n",
        "        'comp2_maint': 'sum',\n",
        "        'comp3_maint': 'sum',\n",
        "        'comp4_maint': 'sum',\n",
        "        'error1': 'sum',\n",
        "        'error2': 'sum',\n",
        "        'error3': 'sum',\n",
        "        'error4': 'sum',\n",
        "        'error5': 'sum',\n",
        "        'comp1_failure': 'sum',\n",
        "        'comp2_failure': 'sum',\n",
        "        'comp3_failure': 'sum',\n",
        "        'comp4_failure': 'sum',\n",
        "        'age': 'first',\n",
        "        'model2': 'max',\n",
        "        'model3': 'max',\n",
        "        'model4': 'max'\n",
        "    }\n",
        "\n",
        "    # Group by the selected columns and aggregate using agg_funcs\n",
        "    aggregated_df = df.groupby(\n",
        "                      f'{time_window}_machine_example_ID'\n",
        "                    ).agg(agg_funcs).reset_index()\n",
        "\n",
        "    return aggregated_df"
      ],
      "metadata": {
        "id": "QZqov3p6LVMC"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "aggregated_df = aggregate_by_time_window(df, 24)"
      ],
      "metadata": {
        "id": "zF60CQzUO3sL"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "aggregated_df.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "3bkYmmgiau5f",
        "outputId": "02cd7d66-9f56-4665-aec2-04df6439a427"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 12200 entries, 0 to 12199\n",
            "Data columns (total 48 columns):\n",
            " #   Column                     Non-Null Count  Dtype         \n",
            "---  ------                     --------------  -----         \n",
            " 0   (72_machine_example_ID, )  12200 non-null  object        \n",
            " 1   (datetime, first)          12200 non-null  datetime64[ns]\n",
            " 2   (machineID, first)         12200 non-null  int64         \n",
            " 3   (volt, mean)               12200 non-null  float64       \n",
            " 4   (volt, std)                12200 non-null  float64       \n",
            " 5   (volt, skew)               12200 non-null  float64       \n",
            " 6   (volt, kurtosis)           12200 non-null  float64       \n",
            " 7   (volt, min)                12200 non-null  float64       \n",
            " 8   (volt, max)                12200 non-null  float64       \n",
            " 9   (volt, range)              12200 non-null  float64       \n",
            " 10  (rotate, mean)             12200 non-null  float64       \n",
            " 11  (rotate, std)              12200 non-null  float64       \n",
            " 12  (rotate, skew)             12200 non-null  float64       \n",
            " 13  (rotate, kurtosis)         12200 non-null  float64       \n",
            " 14  (rotate, min)              12200 non-null  float64       \n",
            " 15  (rotate, max)              12200 non-null  float64       \n",
            " 16  (rotate, range)            12200 non-null  float64       \n",
            " 17  (pressure, mean)           12200 non-null  float64       \n",
            " 18  (pressure, std)            12200 non-null  float64       \n",
            " 19  (pressure, skew)           12200 non-null  float64       \n",
            " 20  (pressure, kurtosis)       12200 non-null  float64       \n",
            " 21  (pressure, min)            12200 non-null  float64       \n",
            " 22  (pressure, max)            12200 non-null  float64       \n",
            " 23  (pressure, range)          12200 non-null  float64       \n",
            " 24  (vibration, mean)          12200 non-null  float64       \n",
            " 25  (vibration, std)           12200 non-null  float64       \n",
            " 26  (vibration, skew)          12200 non-null  float64       \n",
            " 27  (vibration, kurtosis)      12200 non-null  float64       \n",
            " 28  (vibration, min)           12200 non-null  float64       \n",
            " 29  (vibration, max)           12200 non-null  float64       \n",
            " 30  (vibration, range)         12200 non-null  float64       \n",
            " 31  (comp1_maint, sum)         12200 non-null  int64         \n",
            " 32  (comp2_maint, sum)         12200 non-null  int64         \n",
            " 33  (comp3_maint, sum)         12200 non-null  int64         \n",
            " 34  (comp4_maint, sum)         12200 non-null  int64         \n",
            " 35  (error1, sum)              12200 non-null  int64         \n",
            " 36  (error2, sum)              12200 non-null  int64         \n",
            " 37  (error3, sum)              12200 non-null  int64         \n",
            " 38  (error4, sum)              12200 non-null  int64         \n",
            " 39  (error5, sum)              12200 non-null  int64         \n",
            " 40  (comp1_failure, sum)       12200 non-null  int64         \n",
            " 41  (comp2_failure, sum)       12200 non-null  int64         \n",
            " 42  (comp3_failure, sum)       12200 non-null  int64         \n",
            " 43  (comp4_failure, sum)       12200 non-null  int64         \n",
            " 44  (age, first)               12200 non-null  int64         \n",
            " 45  (model2, max)              12200 non-null  int64         \n",
            " 46  (model3, max)              12200 non-null  int64         \n",
            " 47  (model4, max)              12200 non-null  int64         \n",
            "dtypes: datetime64[ns](1), float64(28), int64(18), object(1)\n",
            "memory usage: 4.5+ MB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "aggregated_df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 425
        },
        "id": "k8b0o0bUc-A4",
        "outputId": "a42cefc2-ec36-4e7a-97aa-178505852522"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "  24_machine_example_ID            datetime machineID        volt             \\\n",
              "                                      first     first        mean        std   \n",
              "0            (001, 001) 2015-01-01 06:00:00         1  169.733809  11.233120   \n",
              "1            (001, 002) 2015-01-02 06:00:00         1  170.356866  15.033766   \n",
              "2            (001, 003) 2015-01-03 06:00:00         1  172.566760  12.805887   \n",
              "3            (001, 004) 2015-01-04 06:00:00         1  171.333562  21.282989   \n",
              "4            (001, 005) 2015-01-05 06:00:00         1  171.393482  13.858179   \n",
              "\n",
              "                                                              rotate  \\\n",
              "       skew  kurtosis         min         max      range        mean   \n",
              "0  0.621126  0.692484  151.335682  200.872430  49.536748  445.179865   \n",
              "1 -0.153168 -0.550910  140.776309  197.363125  56.586815  454.242875   \n",
              "2  0.584383 -0.745664  154.199258  195.564941  41.365683  450.897424   \n",
              "3 -0.186068  0.013508  127.163620  215.656488  88.492868  441.310894   \n",
              "4 -0.474058  0.071414  138.826437  197.636954  58.810518  468.359778   \n",
              "\n",
              "                                                                      \\\n",
              "         std      skew  kurtosis         min         max       range   \n",
              "0  48.717395  0.095361 -0.925833  346.149335  527.349825  181.200490   \n",
              "1  40.858613 -0.004614 -1.249600  384.645962  521.837936  137.191975   \n",
              "2  45.129934  0.494953  0.442788  374.127148  568.972310  194.845162   \n",
              "3  34.033248 -0.317283  0.381821  365.213804  517.348533  152.134729   \n",
              "4  42.645922  0.215679  0.165255  392.124959  575.505189  183.380231   \n",
              "\n",
              "     pressure                                                        \\\n",
              "         mean        std      skew  kurtosis        min         max   \n",
              "0   96.797113  10.079880 -0.098792 -0.409428  75.237905  113.077935   \n",
              "1  100.787669  11.384920  0.263643 -0.457870  80.668287  127.014498   \n",
              "2  100.240400   9.861049  0.067344 -1.053918  85.246610  117.148227   \n",
              "3   98.087115   9.480559  0.422419 -0.487941  82.400818  118.853452   \n",
              "4  104.452155  10.968382 -0.433933  0.008458  78.721961  126.464580   \n",
              "\n",
              "              vibration                                                      \\\n",
              "       range       mean       std      skew  kurtosis        min        max   \n",
              "0  37.840031  40.385160  5.853209 -0.251997  0.436215  25.990511  52.355876   \n",
              "1  46.346211  38.471831  5.121860  0.087263 -0.880854  29.527665  47.862484   \n",
              "2  31.901618  52.351479  5.830561  0.158237  0.358548  39.273567  66.764515   \n",
              "3  36.452635  51.607772  5.294177  0.174354 -0.648749  41.674887  62.464103   \n",
              "4  47.742619  39.999324  5.506359  0.683191  0.074323  32.813967  52.383097   \n",
              "\n",
              "             comp1_maint comp2_maint comp3_maint comp4_maint error1 error2  \\\n",
              "       range         sum         sum         sum         sum    sum    sum   \n",
              "0  26.365365           0           0           0           0      0      0   \n",
              "1  18.334820           0           0           0           0      0      0   \n",
              "2  27.490947           0           0           0           0      1      0   \n",
              "3  20.789216           0           0           0           0      0      0   \n",
              "4  19.569130           1           0           0           0      0      0   \n",
              "\n",
              "  error3 error4 error5 comp1_failure comp2_failure comp3_failure  \\\n",
              "     sum    sum    sum           sum           sum           sum   \n",
              "0      0      0      0             0             0             0   \n",
              "1      0      0      0             0             0             0   \n",
              "2      1      0      0             0             0             0   \n",
              "3      0      0      1             0             0             0   \n",
              "4      0      0      0             0             0             0   \n",
              "\n",
              "  comp4_failure   age model2 model3 model4  \n",
              "            sum first    max    max    max  \n",
              "0             0    18      0      1      0  \n",
              "1             0    18      0      1      0  \n",
              "2             0    18      0      1      0  \n",
              "3             0    18      0      1      0  \n",
              "4             1    18      0      1      0  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-8ba246ca-2c4a-4226-8c72-7bd4424563b2\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead tr th {\n",
              "        text-align: left;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr>\n",
              "      <th></th>\n",
              "      <th>24_machine_example_ID</th>\n",
              "      <th>datetime</th>\n",
              "      <th>machineID</th>\n",
              "      <th colspan=\"7\" halign=\"left\">volt</th>\n",
              "      <th colspan=\"7\" halign=\"left\">rotate</th>\n",
              "      <th colspan=\"7\" halign=\"left\">pressure</th>\n",
              "      <th colspan=\"7\" halign=\"left\">vibration</th>\n",
              "      <th>comp1_maint</th>\n",
              "      <th>comp2_maint</th>\n",
              "      <th>comp3_maint</th>\n",
              "      <th>comp4_maint</th>\n",
              "      <th>error1</th>\n",
              "      <th>error2</th>\n",
              "      <th>error3</th>\n",
              "      <th>error4</th>\n",
              "      <th>error5</th>\n",
              "      <th>comp1_failure</th>\n",
              "      <th>comp2_failure</th>\n",
              "      <th>comp3_failure</th>\n",
              "      <th>comp4_failure</th>\n",
              "      <th>age</th>\n",
              "      <th>model2</th>\n",
              "      <th>model3</th>\n",
              "      <th>model4</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th>first</th>\n",
              "      <th>first</th>\n",
              "      <th>mean</th>\n",
              "      <th>std</th>\n",
              "      <th>skew</th>\n",
              "      <th>kurtosis</th>\n",
              "      <th>min</th>\n",
              "      <th>max</th>\n",
              "      <th>range</th>\n",
              "      <th>mean</th>\n",
              "      <th>std</th>\n",
              "      <th>skew</th>\n",
              "      <th>kurtosis</th>\n",
              "      <th>min</th>\n",
              "      <th>max</th>\n",
              "      <th>range</th>\n",
              "      <th>mean</th>\n",
              "      <th>std</th>\n",
              "      <th>skew</th>\n",
              "      <th>kurtosis</th>\n",
              "      <th>min</th>\n",
              "      <th>max</th>\n",
              "      <th>range</th>\n",
              "      <th>mean</th>\n",
              "      <th>std</th>\n",
              "      <th>skew</th>\n",
              "      <th>kurtosis</th>\n",
              "      <th>min</th>\n",
              "      <th>max</th>\n",
              "      <th>range</th>\n",
              "      <th>sum</th>\n",
              "      <th>sum</th>\n",
              "      <th>sum</th>\n",
              "      <th>sum</th>\n",
              "      <th>sum</th>\n",
              "      <th>sum</th>\n",
              "      <th>sum</th>\n",
              "      <th>sum</th>\n",
              "      <th>sum</th>\n",
              "      <th>sum</th>\n",
              "      <th>sum</th>\n",
              "      <th>sum</th>\n",
              "      <th>sum</th>\n",
              "      <th>first</th>\n",
              "      <th>max</th>\n",
              "      <th>max</th>\n",
              "      <th>max</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>2015-01-01 06:00:00</td>\n",
              "      <td>1</td>\n",
              "      <td>169.733809</td>\n",
              "      <td>11.233120</td>\n",
              "      <td>0.621126</td>\n",
              "      <td>0.692484</td>\n",
              "      <td>151.335682</td>\n",
              "      <td>200.872430</td>\n",
              "      <td>49.536748</td>\n",
              "      <td>445.179865</td>\n",
              "      <td>48.717395</td>\n",
              "      <td>0.095361</td>\n",
              "      <td>-0.925833</td>\n",
              "      <td>346.149335</td>\n",
              "      <td>527.349825</td>\n",
              "      <td>181.200490</td>\n",
              "      <td>96.797113</td>\n",
              "      <td>10.079880</td>\n",
              "      <td>-0.098792</td>\n",
              "      <td>-0.409428</td>\n",
              "      <td>75.237905</td>\n",
              "      <td>113.077935</td>\n",
              "      <td>37.840031</td>\n",
              "      <td>40.385160</td>\n",
              "      <td>5.853209</td>\n",
              "      <td>-0.251997</td>\n",
              "      <td>0.436215</td>\n",
              "      <td>25.990511</td>\n",
              "      <td>52.355876</td>\n",
              "      <td>26.365365</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>(001, 002)</td>\n",
              "      <td>2015-01-02 06:00:00</td>\n",
              "      <td>1</td>\n",
              "      <td>170.356866</td>\n",
              "      <td>15.033766</td>\n",
              "      <td>-0.153168</td>\n",
              "      <td>-0.550910</td>\n",
              "      <td>140.776309</td>\n",
              "      <td>197.363125</td>\n",
              "      <td>56.586815</td>\n",
              "      <td>454.242875</td>\n",
              "      <td>40.858613</td>\n",
              "      <td>-0.004614</td>\n",
              "      <td>-1.249600</td>\n",
              "      <td>384.645962</td>\n",
              "      <td>521.837936</td>\n",
              "      <td>137.191975</td>\n",
              "      <td>100.787669</td>\n",
              "      <td>11.384920</td>\n",
              "      <td>0.263643</td>\n",
              "      <td>-0.457870</td>\n",
              "      <td>80.668287</td>\n",
              "      <td>127.014498</td>\n",
              "      <td>46.346211</td>\n",
              "      <td>38.471831</td>\n",
              "      <td>5.121860</td>\n",
              "      <td>0.087263</td>\n",
              "      <td>-0.880854</td>\n",
              "      <td>29.527665</td>\n",
              "      <td>47.862484</td>\n",
              "      <td>18.334820</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>(001, 003)</td>\n",
              "      <td>2015-01-03 06:00:00</td>\n",
              "      <td>1</td>\n",
              "      <td>172.566760</td>\n",
              "      <td>12.805887</td>\n",
              "      <td>0.584383</td>\n",
              "      <td>-0.745664</td>\n",
              "      <td>154.199258</td>\n",
              "      <td>195.564941</td>\n",
              "      <td>41.365683</td>\n",
              "      <td>450.897424</td>\n",
              "      <td>45.129934</td>\n",
              "      <td>0.494953</td>\n",
              "      <td>0.442788</td>\n",
              "      <td>374.127148</td>\n",
              "      <td>568.972310</td>\n",
              "      <td>194.845162</td>\n",
              "      <td>100.240400</td>\n",
              "      <td>9.861049</td>\n",
              "      <td>0.067344</td>\n",
              "      <td>-1.053918</td>\n",
              "      <td>85.246610</td>\n",
              "      <td>117.148227</td>\n",
              "      <td>31.901618</td>\n",
              "      <td>52.351479</td>\n",
              "      <td>5.830561</td>\n",
              "      <td>0.158237</td>\n",
              "      <td>0.358548</td>\n",
              "      <td>39.273567</td>\n",
              "      <td>66.764515</td>\n",
              "      <td>27.490947</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>(001, 004)</td>\n",
              "      <td>2015-01-04 06:00:00</td>\n",
              "      <td>1</td>\n",
              "      <td>171.333562</td>\n",
              "      <td>21.282989</td>\n",
              "      <td>-0.186068</td>\n",
              "      <td>0.013508</td>\n",
              "      <td>127.163620</td>\n",
              "      <td>215.656488</td>\n",
              "      <td>88.492868</td>\n",
              "      <td>441.310894</td>\n",
              "      <td>34.033248</td>\n",
              "      <td>-0.317283</td>\n",
              "      <td>0.381821</td>\n",
              "      <td>365.213804</td>\n",
              "      <td>517.348533</td>\n",
              "      <td>152.134729</td>\n",
              "      <td>98.087115</td>\n",
              "      <td>9.480559</td>\n",
              "      <td>0.422419</td>\n",
              "      <td>-0.487941</td>\n",
              "      <td>82.400818</td>\n",
              "      <td>118.853452</td>\n",
              "      <td>36.452635</td>\n",
              "      <td>51.607772</td>\n",
              "      <td>5.294177</td>\n",
              "      <td>0.174354</td>\n",
              "      <td>-0.648749</td>\n",
              "      <td>41.674887</td>\n",
              "      <td>62.464103</td>\n",
              "      <td>20.789216</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>(001, 005)</td>\n",
              "      <td>2015-01-05 06:00:00</td>\n",
              "      <td>1</td>\n",
              "      <td>171.393482</td>\n",
              "      <td>13.858179</td>\n",
              "      <td>-0.474058</td>\n",
              "      <td>0.071414</td>\n",
              "      <td>138.826437</td>\n",
              "      <td>197.636954</td>\n",
              "      <td>58.810518</td>\n",
              "      <td>468.359778</td>\n",
              "      <td>42.645922</td>\n",
              "      <td>0.215679</td>\n",
              "      <td>0.165255</td>\n",
              "      <td>392.124959</td>\n",
              "      <td>575.505189</td>\n",
              "      <td>183.380231</td>\n",
              "      <td>104.452155</td>\n",
              "      <td>10.968382</td>\n",
              "      <td>-0.433933</td>\n",
              "      <td>0.008458</td>\n",
              "      <td>78.721961</td>\n",
              "      <td>126.464580</td>\n",
              "      <td>47.742619</td>\n",
              "      <td>39.999324</td>\n",
              "      <td>5.506359</td>\n",
              "      <td>0.683191</td>\n",
              "      <td>0.074323</td>\n",
              "      <td>32.813967</td>\n",
              "      <td>52.383097</td>\n",
              "      <td>19.569130</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-8ba246ca-2c4a-4226-8c72-7bd4424563b2')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-8ba246ca-2c4a-4226-8c72-7bd4424563b2 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-8ba246ca-2c4a-4226-8c72-7bd4424563b2');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-138ef795-af59-4eeb-bffe-9985ce4cd453\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-138ef795-af59-4eeb-bffe-9985ce4cd453')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-138ef795-af59-4eeb-bffe-9985ce4cd453 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "aggregated_df"
            }
          },
          "metadata": {},
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Flatten MultiIndex columns\n",
        "aggregated_df.columns = [\n",
        "    col[0] if i == 0 else '_'.join(col).strip() for i, col in enumerate(aggregated_df.columns.values)\n",
        "]\n",
        "aggregated_df.head(1)"
      ],
      "metadata": {
        "id": "GE1rbAAfiPpl",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 117
        },
        "outputId": "449747af-cb41-43ba-8385-b2cbcd1196f9"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "  72_machine_example_ID      datetime_first  machineID_first   volt_mean  \\\n",
              "0            (001, 001) 2015-01-01 06:00:00                1  170.885811   \n",
              "\n",
              "    volt_std  volt_skew  volt_kurtosis    volt_min   volt_max  volt_range  \\\n",
              "0  12.988999   0.236573      -0.187545  140.776309  200.87243   60.096121   \n",
              "\n",
              "   rotate_mean  rotate_std  rotate_skew  rotate_kurtosis  rotate_min  \\\n",
              "0   450.106721   44.537872      0.16778        -0.494777  346.149335   \n",
              "\n",
              "   rotate_max  rotate_range  pressure_mean  pressure_std  pressure_skew  \\\n",
              "0   568.97231    222.822975      99.275061     10.467413        0.12748   \n",
              "\n",
              "   pressure_kurtosis  pressure_min  pressure_max  pressure_range  \\\n",
              "0          -0.432249     75.237905    127.014498       51.776593   \n",
              "\n",
              "   vibration_mean  vibration_std  vibration_skew  vibration_kurtosis  \\\n",
              "0       43.736157       8.298338        0.335899           -0.301468   \n",
              "\n",
              "   vibration_min  vibration_max  vibration_range  comp1_maint_sum  \\\n",
              "0      25.990511      66.764515        40.774004                0   \n",
              "\n",
              "   comp2_maint_sum  comp3_maint_sum  comp4_maint_sum  error1_sum  error2_sum  \\\n",
              "0                0                0                0           1           0   \n",
              "\n",
              "   error3_sum  error4_sum  error5_sum  comp1_failure_sum  comp2_failure_sum  \\\n",
              "0           1           0           0                  0                  0   \n",
              "\n",
              "   comp3_failure_sum  comp4_failure_sum  age_first  model2_max  model3_max  \\\n",
              "0                  0                  0         18           0           1   \n",
              "\n",
              "   model4_max  \n",
              "0           0  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-78000244-0367-44ec-9cfa-390af2836399\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>72_machine_example_ID</th>\n",
              "      <th>datetime_first</th>\n",
              "      <th>machineID_first</th>\n",
              "      <th>volt_mean</th>\n",
              "      <th>volt_std</th>\n",
              "      <th>volt_skew</th>\n",
              "      <th>volt_kurtosis</th>\n",
              "      <th>volt_min</th>\n",
              "      <th>volt_max</th>\n",
              "      <th>volt_range</th>\n",
              "      <th>rotate_mean</th>\n",
              "      <th>rotate_std</th>\n",
              "      <th>rotate_skew</th>\n",
              "      <th>rotate_kurtosis</th>\n",
              "      <th>rotate_min</th>\n",
              "      <th>rotate_max</th>\n",
              "      <th>rotate_range</th>\n",
              "      <th>pressure_mean</th>\n",
              "      <th>pressure_std</th>\n",
              "      <th>pressure_skew</th>\n",
              "      <th>pressure_kurtosis</th>\n",
              "      <th>pressure_min</th>\n",
              "      <th>pressure_max</th>\n",
              "      <th>pressure_range</th>\n",
              "      <th>vibration_mean</th>\n",
              "      <th>vibration_std</th>\n",
              "      <th>vibration_skew</th>\n",
              "      <th>vibration_kurtosis</th>\n",
              "      <th>vibration_min</th>\n",
              "      <th>vibration_max</th>\n",
              "      <th>vibration_range</th>\n",
              "      <th>comp1_maint_sum</th>\n",
              "      <th>comp2_maint_sum</th>\n",
              "      <th>comp3_maint_sum</th>\n",
              "      <th>comp4_maint_sum</th>\n",
              "      <th>error1_sum</th>\n",
              "      <th>error2_sum</th>\n",
              "      <th>error3_sum</th>\n",
              "      <th>error4_sum</th>\n",
              "      <th>error5_sum</th>\n",
              "      <th>comp1_failure_sum</th>\n",
              "      <th>comp2_failure_sum</th>\n",
              "      <th>comp3_failure_sum</th>\n",
              "      <th>comp4_failure_sum</th>\n",
              "      <th>age_first</th>\n",
              "      <th>model2_max</th>\n",
              "      <th>model3_max</th>\n",
              "      <th>model4_max</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>2015-01-01 06:00:00</td>\n",
              "      <td>1</td>\n",
              "      <td>170.885811</td>\n",
              "      <td>12.988999</td>\n",
              "      <td>0.236573</td>\n",
              "      <td>-0.187545</td>\n",
              "      <td>140.776309</td>\n",
              "      <td>200.87243</td>\n",
              "      <td>60.096121</td>\n",
              "      <td>450.106721</td>\n",
              "      <td>44.537872</td>\n",
              "      <td>0.16778</td>\n",
              "      <td>-0.494777</td>\n",
              "      <td>346.149335</td>\n",
              "      <td>568.97231</td>\n",
              "      <td>222.822975</td>\n",
              "      <td>99.275061</td>\n",
              "      <td>10.467413</td>\n",
              "      <td>0.12748</td>\n",
              "      <td>-0.432249</td>\n",
              "      <td>75.237905</td>\n",
              "      <td>127.014498</td>\n",
              "      <td>51.776593</td>\n",
              "      <td>43.736157</td>\n",
              "      <td>8.298338</td>\n",
              "      <td>0.335899</td>\n",
              "      <td>-0.301468</td>\n",
              "      <td>25.990511</td>\n",
              "      <td>66.764515</td>\n",
              "      <td>40.774004</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-78000244-0367-44ec-9cfa-390af2836399')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-78000244-0367-44ec-9cfa-390af2836399 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-78000244-0367-44ec-9cfa-390af2836399');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "aggregated_df"
            }
          },
          "metadata": {},
          "execution_count": 67
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "def rename_first_column(df: pd.DataFrame) -> pd.DataFrame:\n",
        "    \"\"\"\n",
        "    Purpose: Renames the first column of the input dataframe by removing the first\n",
        "        3 characters.\n",
        "    :param df: DataFrame containing machine data.\n",
        "    :return: DataFrame with the first column renamed.\n",
        "    \"\"\"\n",
        "\n",
        "    # Extract the common part of the column names\n",
        "    common_part = df.columns[0][:3]  # Assuming the first column follows the pattern\n",
        "\n",
        "    # Replace the common part with an empty string\n",
        "    new_column_name = df.columns[0].replace(common_part, '')\n",
        "\n",
        "    # Rename the column\n",
        "    df.rename(columns={df.columns[0]: new_column_name}, inplace=True)\n",
        "\n",
        "    return df"
      ],
      "metadata": {
        "id": "rAPC8pIbfOzK"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "aggregated_df = rename_first_column(aggregated_df)\n",
        "aggregated_df.tail(1)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 117
        },
        "id": "tuAaOdyvyFnn",
        "outputId": "220a4f84-dc79-45d2-ac74-770c928369f3"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      machine_example_ID      datetime_first  machineID_first  volt_mean  \\\n",
              "12199         (100, 122) 2015-12-30 06:00:00              100  170.15341   \n",
              "\n",
              "        volt_std  volt_skew  volt_kurtosis    volt_min    volt_max  \\\n",
              "12199  14.952094  -0.061634      -0.334672  136.363542  204.190937   \n",
              "\n",
              "       volt_range  rotate_mean  rotate_std  rotate_skew  rotate_kurtosis  \\\n",
              "12199   67.827395   458.133285   59.734066     0.407187        -0.664071   \n",
              "\n",
              "       rotate_min  rotate_max  rotate_range  pressure_mean  pressure_std  \\\n",
              "12199  356.662576  578.429999    221.767423     101.209942      8.435513   \n",
              "\n",
              "       pressure_skew  pressure_kurtosis  pressure_min  pressure_max  \\\n",
              "12199       -0.64779           0.674782     79.095538     117.42634   \n",
              "\n",
              "       pressure_range  vibration_mean  vibration_std  vibration_skew  \\\n",
              "12199       38.330802       39.712244       5.706438        0.078506   \n",
              "\n",
              "       vibration_kurtosis  vibration_min  vibration_max  vibration_range  \\\n",
              "12199            -0.70524      27.457001       50.83221        23.375209   \n",
              "\n",
              "       comp1_maint_sum  comp2_maint_sum  comp3_maint_sum  comp4_maint_sum  \\\n",
              "12199                0                0                0                0   \n",
              "\n",
              "       error1_sum  error2_sum  error3_sum  error4_sum  error5_sum  \\\n",
              "12199           0           0           0           0           0   \n",
              "\n",
              "       comp1_failure_sum  comp2_failure_sum  comp3_failure_sum  \\\n",
              "12199                  0                  0                  0   \n",
              "\n",
              "       comp4_failure_sum  age_first  model2_max  model3_max  model4_max  \n",
              "12199                  0          5           0           0           1  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-ba4150bc-d061-4c0a-908c-0b495fc87156\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>machine_example_ID</th>\n",
              "      <th>datetime_first</th>\n",
              "      <th>machineID_first</th>\n",
              "      <th>volt_mean</th>\n",
              "      <th>volt_std</th>\n",
              "      <th>volt_skew</th>\n",
              "      <th>volt_kurtosis</th>\n",
              "      <th>volt_min</th>\n",
              "      <th>volt_max</th>\n",
              "      <th>volt_range</th>\n",
              "      <th>rotate_mean</th>\n",
              "      <th>rotate_std</th>\n",
              "      <th>rotate_skew</th>\n",
              "      <th>rotate_kurtosis</th>\n",
              "      <th>rotate_min</th>\n",
              "      <th>rotate_max</th>\n",
              "      <th>rotate_range</th>\n",
              "      <th>pressure_mean</th>\n",
              "      <th>pressure_std</th>\n",
              "      <th>pressure_skew</th>\n",
              "      <th>pressure_kurtosis</th>\n",
              "      <th>pressure_min</th>\n",
              "      <th>pressure_max</th>\n",
              "      <th>pressure_range</th>\n",
              "      <th>vibration_mean</th>\n",
              "      <th>vibration_std</th>\n",
              "      <th>vibration_skew</th>\n",
              "      <th>vibration_kurtosis</th>\n",
              "      <th>vibration_min</th>\n",
              "      <th>vibration_max</th>\n",
              "      <th>vibration_range</th>\n",
              "      <th>comp1_maint_sum</th>\n",
              "      <th>comp2_maint_sum</th>\n",
              "      <th>comp3_maint_sum</th>\n",
              "      <th>comp4_maint_sum</th>\n",
              "      <th>error1_sum</th>\n",
              "      <th>error2_sum</th>\n",
              "      <th>error3_sum</th>\n",
              "      <th>error4_sum</th>\n",
              "      <th>error5_sum</th>\n",
              "      <th>comp1_failure_sum</th>\n",
              "      <th>comp2_failure_sum</th>\n",
              "      <th>comp3_failure_sum</th>\n",
              "      <th>comp4_failure_sum</th>\n",
              "      <th>age_first</th>\n",
              "      <th>model2_max</th>\n",
              "      <th>model3_max</th>\n",
              "      <th>model4_max</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>12199</th>\n",
              "      <td>(100, 122)</td>\n",
              "      <td>2015-12-30 06:00:00</td>\n",
              "      <td>100</td>\n",
              "      <td>170.15341</td>\n",
              "      <td>14.952094</td>\n",
              "      <td>-0.061634</td>\n",
              "      <td>-0.334672</td>\n",
              "      <td>136.363542</td>\n",
              "      <td>204.190937</td>\n",
              "      <td>67.827395</td>\n",
              "      <td>458.133285</td>\n",
              "      <td>59.734066</td>\n",
              "      <td>0.407187</td>\n",
              "      <td>-0.664071</td>\n",
              "      <td>356.662576</td>\n",
              "      <td>578.429999</td>\n",
              "      <td>221.767423</td>\n",
              "      <td>101.209942</td>\n",
              "      <td>8.435513</td>\n",
              "      <td>-0.64779</td>\n",
              "      <td>0.674782</td>\n",
              "      <td>79.095538</td>\n",
              "      <td>117.42634</td>\n",
              "      <td>38.330802</td>\n",
              "      <td>39.712244</td>\n",
              "      <td>5.706438</td>\n",
              "      <td>0.078506</td>\n",
              "      <td>-0.70524</td>\n",
              "      <td>27.457001</td>\n",
              "      <td>50.83221</td>\n",
              "      <td>23.375209</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>5</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-ba4150bc-d061-4c0a-908c-0b495fc87156')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-ba4150bc-d061-4c0a-908c-0b495fc87156 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-ba4150bc-d061-4c0a-908c-0b495fc87156');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe"
            }
          },
          "metadata": {},
          "execution_count": 69
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "def remove_max_time_window(df: pd.DataFrame) -> pd.DataFrame:\n",
        "    \"\"\"\n",
        "    Purpose: Removes the last time window from the input dataframe.\n",
        "    :param df: DataFrame containing machine data.\n",
        "    :return: DataFrame with the last time window removed.\n",
        "    \"\"\"\n",
        "\n",
        "    print(f\"- {format(len(df), ',')} total entries.\")\n",
        "\n",
        "    # Extract machine ID and time window\n",
        "    df[['machineID', 'time_window']] = df['machine_example_ID'].str.extract(r'\\((\\d+),\\s*(\\d+)\\)')\n",
        "\n",
        "    # Convert machineID and time_window to integers\n",
        "    df['machineID'] = df['machineID'].astype(int)\n",
        "    df['time_window'] = df['time_window'].astype(int)\n",
        "\n",
        "    # Group by machine ID and find the maximum time window for each machine\n",
        "    max_time_windows = df.groupby('machineID')['time_window'].max()\n",
        "\n",
        "    # Filter out rows where the time window matches the maximum time window for each machine\n",
        "    filtered_df = df[~df.apply(lambda row: row['time_window'] == max_time_windows[row['machineID']], axis=1)].copy()\n",
        "\n",
        "    # Drop machineID and time_window columns\n",
        "    filtered_df.drop(columns=['machineID', 'time_window'], inplace=True)\n",
        "\n",
        "    print(f\"- {format(len(filtered_df), ',')} total entries after removal.\")\n",
        "\n",
        "    return filtered_df"
      ],
      "metadata": {
        "id": "g3sb6_e4zJ0W"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Remove entries corresponding to maximum machineID_time_window\n",
        "aggregated_df = remove_max_time_window(aggregated_df)\n",
        "aggregated_df.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Doy14irk0Ktv",
        "outputId": "1818a10d-a01a-43a7-baa3-fa50da0c5520"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "- 12,200 total entries.\n",
            "- 12,100 total entries after removal.\n",
            "<class 'pandas.core.frame.DataFrame'>\n",
            "Index: 12100 entries, 0 to 12198\n",
            "Data columns (total 48 columns):\n",
            " #   Column              Non-Null Count  Dtype         \n",
            "---  ------              --------------  -----         \n",
            " 0   machine_example_ID  12100 non-null  object        \n",
            " 1   datetime_first      12100 non-null  datetime64[ns]\n",
            " 2   machineID_first     12100 non-null  int64         \n",
            " 3   volt_mean           12100 non-null  float64       \n",
            " 4   volt_std            12100 non-null  float64       \n",
            " 5   volt_skew           12100 non-null  float64       \n",
            " 6   volt_kurtosis       12100 non-null  float64       \n",
            " 7   volt_min            12100 non-null  float64       \n",
            " 8   volt_max            12100 non-null  float64       \n",
            " 9   volt_range          12100 non-null  float64       \n",
            " 10  rotate_mean         12100 non-null  float64       \n",
            " 11  rotate_std          12100 non-null  float64       \n",
            " 12  rotate_skew         12100 non-null  float64       \n",
            " 13  rotate_kurtosis     12100 non-null  float64       \n",
            " 14  rotate_min          12100 non-null  float64       \n",
            " 15  rotate_max          12100 non-null  float64       \n",
            " 16  rotate_range        12100 non-null  float64       \n",
            " 17  pressure_mean       12100 non-null  float64       \n",
            " 18  pressure_std        12100 non-null  float64       \n",
            " 19  pressure_skew       12100 non-null  float64       \n",
            " 20  pressure_kurtosis   12100 non-null  float64       \n",
            " 21  pressure_min        12100 non-null  float64       \n",
            " 22  pressure_max        12100 non-null  float64       \n",
            " 23  pressure_range      12100 non-null  float64       \n",
            " 24  vibration_mean      12100 non-null  float64       \n",
            " 25  vibration_std       12100 non-null  float64       \n",
            " 26  vibration_skew      12100 non-null  float64       \n",
            " 27  vibration_kurtosis  12100 non-null  float64       \n",
            " 28  vibration_min       12100 non-null  float64       \n",
            " 29  vibration_max       12100 non-null  float64       \n",
            " 30  vibration_range     12100 non-null  float64       \n",
            " 31  comp1_maint_sum     12100 non-null  int64         \n",
            " 32  comp2_maint_sum     12100 non-null  int64         \n",
            " 33  comp3_maint_sum     12100 non-null  int64         \n",
            " 34  comp4_maint_sum     12100 non-null  int64         \n",
            " 35  error1_sum          12100 non-null  int64         \n",
            " 36  error2_sum          12100 non-null  int64         \n",
            " 37  error3_sum          12100 non-null  int64         \n",
            " 38  error4_sum          12100 non-null  int64         \n",
            " 39  error5_sum          12100 non-null  int64         \n",
            " 40  comp1_failure_sum   12100 non-null  int64         \n",
            " 41  comp2_failure_sum   12100 non-null  int64         \n",
            " 42  comp3_failure_sum   12100 non-null  int64         \n",
            " 43  comp4_failure_sum   12100 non-null  int64         \n",
            " 44  age_first           12100 non-null  int64         \n",
            " 45  model2_max          12100 non-null  int64         \n",
            " 46  model3_max          12100 non-null  int64         \n",
            " 47  model4_max          12100 non-null  int64         \n",
            "dtypes: datetime64[ns](1), float64(28), int64(18), object(1)\n",
            "memory usage: 4.5+ MB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## 2. Create Features"
      ],
      "metadata": {
        "id": "Kyqoead4ePzn"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "### 2a. Logistic Regression"
      ],
      "metadata": {
        "id": "nx5MNemAelJA"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "#### Create Logistic Regression Data Matrix From Postprocessed Data"
      ],
      "metadata": {
        "id": "uubjqAFLbWlX"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Create the data matrix containing the features for a logistic regression model\n",
        "X = aggregated_df.drop(\n",
        "    columns=[\n",
        "        'datetime_first',\n",
        "        'machineID_first',\n",
        "        'machine_example_ID',\n",
        "    ]\n",
        ")\n",
        "X.head()"
      ],
      "metadata": {
        "id": "MTX4m2vsbVOj",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 224
        },
        "outputId": "7990b6d7-db5d-4205-cde3-94bca826d0be"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "    volt_mean   volt_std  volt_skew  volt_kurtosis    volt_min    volt_max  \\\n",
              "0  170.885811  12.988999   0.236573      -0.187545  140.776309  200.872430   \n",
              "1  171.487472  17.667202  -0.256072       0.979570  121.502718  215.656488   \n",
              "2  172.183333  13.290595  -0.031461      -0.494151  143.506562  200.741045   \n",
              "3  169.639459  15.727822  -0.083465      -0.091825  130.223881  203.777627   \n",
              "4  170.271970  16.233572  -0.112900       0.767195  119.059047  216.955936   \n",
              "\n",
              "   volt_range  rotate_mean  rotate_std  rotate_skew  rotate_kurtosis  \\\n",
              "0   60.096121   450.106721   44.537872     0.167780        -0.494777   \n",
              "1   94.153770   450.703413   41.818685    -0.127176         0.406995   \n",
              "2   57.234483   451.975443   39.772529     0.226721        -0.114202   \n",
              "3   73.553746   447.914585   48.995525     0.056837         0.721875   \n",
              "4   97.896889   460.005194   51.218599    -0.527761         1.135857   \n",
              "\n",
              "   rotate_min  rotate_max  rotate_range  pressure_mean  pressure_std  \\\n",
              "0  346.149335  568.972310    222.822975      99.275061     10.467413   \n",
              "1  345.418513  575.505189    230.086676     101.323552     10.213230   \n",
              "2  361.562141  552.372925    190.810784      99.888028      9.198322   \n",
              "3  307.175549  586.945963    279.770414      98.173025     11.176246   \n",
              "4  283.244579  568.837979    285.593399     101.344157     10.064452   \n",
              "\n",
              "   pressure_skew  pressure_kurtosis  pressure_min  pressure_max  \\\n",
              "0       0.127480          -0.432249     75.237905    127.014498   \n",
              "1       0.023665          -0.433038     78.721961    126.464580   \n",
              "2      -0.291560          -0.892300     81.565288    117.164152   \n",
              "3      -0.537925           1.053841     58.733724    119.749926   \n",
              "4      -0.316597           0.350864     68.760655    123.952205   \n",
              "\n",
              "   pressure_range  vibration_mean  vibration_std  vibration_skew  \\\n",
              "0       51.776593       43.736157       8.298338        0.335899   \n",
              "1       47.742619       44.487873       7.103904        0.401587   \n",
              "2       35.598864       39.924214       4.944806        0.141510   \n",
              "3       61.016203       40.227433       5.115975        0.194594   \n",
              "4       55.191550       40.225275       5.192884       -0.189996   \n",
              "\n",
              "   vibration_kurtosis  vibration_min  vibration_max  vibration_range  \\\n",
              "0           -0.301468      25.990511      66.764515        40.774004   \n",
              "1           -0.431127      32.813967      62.464103        29.650136   \n",
              "2            0.069886      29.031392      54.919547        25.888155   \n",
              "3           -0.757725      30.127114      51.786687        21.659573   \n",
              "4           -0.016270      27.105512      52.884798        25.779285   \n",
              "\n",
              "   comp1_maint_sum  comp2_maint_sum  comp3_maint_sum  comp4_maint_sum  \\\n",
              "0                0                0                0                0   \n",
              "1                1                0                0                0   \n",
              "2                0                0                0                0   \n",
              "3                0                0                0                0   \n",
              "4                0                0                0                0   \n",
              "\n",
              "   error1_sum  error2_sum  error3_sum  error4_sum  error5_sum  \\\n",
              "0           1           0           1           0           0   \n",
              "1           0           0           0           0           1   \n",
              "2           0           0           0           0           0   \n",
              "3           0           0           0           1           0   \n",
              "4           0           0           0           0           0   \n",
              "\n",
              "   comp1_failure_sum  comp2_failure_sum  comp3_failure_sum  comp4_failure_sum  \\\n",
              "0                  0                  0                  0                  0   \n",
              "1                  0                  0                  0                  1   \n",
              "2                  0                  0                  0                  0   \n",
              "3                  0                  0                  0                  0   \n",
              "4                  0                  0                  0                  0   \n",
              "\n",
              "   age_first  model2_max  model3_max  model4_max  \n",
              "0         18           0           1           0  \n",
              "1         18           0           1           0  \n",
              "2         18           0           1           0  \n",
              "3         18           0           1           0  \n",
              "4         18           0           1           0  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-6a57ed75-4249-4de9-ad4d-50ce848a5500\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>volt_mean</th>\n",
              "      <th>volt_std</th>\n",
              "      <th>volt_skew</th>\n",
              "      <th>volt_kurtosis</th>\n",
              "      <th>volt_min</th>\n",
              "      <th>volt_max</th>\n",
              "      <th>volt_range</th>\n",
              "      <th>rotate_mean</th>\n",
              "      <th>rotate_std</th>\n",
              "      <th>rotate_skew</th>\n",
              "      <th>rotate_kurtosis</th>\n",
              "      <th>rotate_min</th>\n",
              "      <th>rotate_max</th>\n",
              "      <th>rotate_range</th>\n",
              "      <th>pressure_mean</th>\n",
              "      <th>pressure_std</th>\n",
              "      <th>pressure_skew</th>\n",
              "      <th>pressure_kurtosis</th>\n",
              "      <th>pressure_min</th>\n",
              "      <th>pressure_max</th>\n",
              "      <th>pressure_range</th>\n",
              "      <th>vibration_mean</th>\n",
              "      <th>vibration_std</th>\n",
              "      <th>vibration_skew</th>\n",
              "      <th>vibration_kurtosis</th>\n",
              "      <th>vibration_min</th>\n",
              "      <th>vibration_max</th>\n",
              "      <th>vibration_range</th>\n",
              "      <th>comp1_maint_sum</th>\n",
              "      <th>comp2_maint_sum</th>\n",
              "      <th>comp3_maint_sum</th>\n",
              "      <th>comp4_maint_sum</th>\n",
              "      <th>error1_sum</th>\n",
              "      <th>error2_sum</th>\n",
              "      <th>error3_sum</th>\n",
              "      <th>error4_sum</th>\n",
              "      <th>error5_sum</th>\n",
              "      <th>comp1_failure_sum</th>\n",
              "      <th>comp2_failure_sum</th>\n",
              "      <th>comp3_failure_sum</th>\n",
              "      <th>comp4_failure_sum</th>\n",
              "      <th>age_first</th>\n",
              "      <th>model2_max</th>\n",
              "      <th>model3_max</th>\n",
              "      <th>model4_max</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>170.885811</td>\n",
              "      <td>12.988999</td>\n",
              "      <td>0.236573</td>\n",
              "      <td>-0.187545</td>\n",
              "      <td>140.776309</td>\n",
              "      <td>200.872430</td>\n",
              "      <td>60.096121</td>\n",
              "      <td>450.106721</td>\n",
              "      <td>44.537872</td>\n",
              "      <td>0.167780</td>\n",
              "      <td>-0.494777</td>\n",
              "      <td>346.149335</td>\n",
              "      <td>568.972310</td>\n",
              "      <td>222.822975</td>\n",
              "      <td>99.275061</td>\n",
              "      <td>10.467413</td>\n",
              "      <td>0.127480</td>\n",
              "      <td>-0.432249</td>\n",
              "      <td>75.237905</td>\n",
              "      <td>127.014498</td>\n",
              "      <td>51.776593</td>\n",
              "      <td>43.736157</td>\n",
              "      <td>8.298338</td>\n",
              "      <td>0.335899</td>\n",
              "      <td>-0.301468</td>\n",
              "      <td>25.990511</td>\n",
              "      <td>66.764515</td>\n",
              "      <td>40.774004</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>171.487472</td>\n",
              "      <td>17.667202</td>\n",
              "      <td>-0.256072</td>\n",
              "      <td>0.979570</td>\n",
              "      <td>121.502718</td>\n",
              "      <td>215.656488</td>\n",
              "      <td>94.153770</td>\n",
              "      <td>450.703413</td>\n",
              "      <td>41.818685</td>\n",
              "      <td>-0.127176</td>\n",
              "      <td>0.406995</td>\n",
              "      <td>345.418513</td>\n",
              "      <td>575.505189</td>\n",
              "      <td>230.086676</td>\n",
              "      <td>101.323552</td>\n",
              "      <td>10.213230</td>\n",
              "      <td>0.023665</td>\n",
              "      <td>-0.433038</td>\n",
              "      <td>78.721961</td>\n",
              "      <td>126.464580</td>\n",
              "      <td>47.742619</td>\n",
              "      <td>44.487873</td>\n",
              "      <td>7.103904</td>\n",
              "      <td>0.401587</td>\n",
              "      <td>-0.431127</td>\n",
              "      <td>32.813967</td>\n",
              "      <td>62.464103</td>\n",
              "      <td>29.650136</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>172.183333</td>\n",
              "      <td>13.290595</td>\n",
              "      <td>-0.031461</td>\n",
              "      <td>-0.494151</td>\n",
              "      <td>143.506562</td>\n",
              "      <td>200.741045</td>\n",
              "      <td>57.234483</td>\n",
              "      <td>451.975443</td>\n",
              "      <td>39.772529</td>\n",
              "      <td>0.226721</td>\n",
              "      <td>-0.114202</td>\n",
              "      <td>361.562141</td>\n",
              "      <td>552.372925</td>\n",
              "      <td>190.810784</td>\n",
              "      <td>99.888028</td>\n",
              "      <td>9.198322</td>\n",
              "      <td>-0.291560</td>\n",
              "      <td>-0.892300</td>\n",
              "      <td>81.565288</td>\n",
              "      <td>117.164152</td>\n",
              "      <td>35.598864</td>\n",
              "      <td>39.924214</td>\n",
              "      <td>4.944806</td>\n",
              "      <td>0.141510</td>\n",
              "      <td>0.069886</td>\n",
              "      <td>29.031392</td>\n",
              "      <td>54.919547</td>\n",
              "      <td>25.888155</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>169.639459</td>\n",
              "      <td>15.727822</td>\n",
              "      <td>-0.083465</td>\n",
              "      <td>-0.091825</td>\n",
              "      <td>130.223881</td>\n",
              "      <td>203.777627</td>\n",
              "      <td>73.553746</td>\n",
              "      <td>447.914585</td>\n",
              "      <td>48.995525</td>\n",
              "      <td>0.056837</td>\n",
              "      <td>0.721875</td>\n",
              "      <td>307.175549</td>\n",
              "      <td>586.945963</td>\n",
              "      <td>279.770414</td>\n",
              "      <td>98.173025</td>\n",
              "      <td>11.176246</td>\n",
              "      <td>-0.537925</td>\n",
              "      <td>1.053841</td>\n",
              "      <td>58.733724</td>\n",
              "      <td>119.749926</td>\n",
              "      <td>61.016203</td>\n",
              "      <td>40.227433</td>\n",
              "      <td>5.115975</td>\n",
              "      <td>0.194594</td>\n",
              "      <td>-0.757725</td>\n",
              "      <td>30.127114</td>\n",
              "      <td>51.786687</td>\n",
              "      <td>21.659573</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>170.271970</td>\n",
              "      <td>16.233572</td>\n",
              "      <td>-0.112900</td>\n",
              "      <td>0.767195</td>\n",
              "      <td>119.059047</td>\n",
              "      <td>216.955936</td>\n",
              "      <td>97.896889</td>\n",
              "      <td>460.005194</td>\n",
              "      <td>51.218599</td>\n",
              "      <td>-0.527761</td>\n",
              "      <td>1.135857</td>\n",
              "      <td>283.244579</td>\n",
              "      <td>568.837979</td>\n",
              "      <td>285.593399</td>\n",
              "      <td>101.344157</td>\n",
              "      <td>10.064452</td>\n",
              "      <td>-0.316597</td>\n",
              "      <td>0.350864</td>\n",
              "      <td>68.760655</td>\n",
              "      <td>123.952205</td>\n",
              "      <td>55.191550</td>\n",
              "      <td>40.225275</td>\n",
              "      <td>5.192884</td>\n",
              "      <td>-0.189996</td>\n",
              "      <td>-0.016270</td>\n",
              "      <td>27.105512</td>\n",
              "      <td>52.884798</td>\n",
              "      <td>25.779285</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-6a57ed75-4249-4de9-ad4d-50ce848a5500')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-6a57ed75-4249-4de9-ad4d-50ce848a5500 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-6a57ed75-4249-4de9-ad4d-50ce848a5500');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-1e7d183e-e501-43b7-b947-7e8c22631804\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-1e7d183e-e501-43b7-b947-7e8c22631804')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-1e7d183e-e501-43b7-b947-7e8c22631804 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "X"
            }
          },
          "metadata": {},
          "execution_count": 71
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "X.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "vHfo1yQ1sG2U",
        "outputId": "b65202df-1bc3-46b3-fff6-ba3a508fb4e2"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "Index: 12100 entries, 0 to 12198\n",
            "Data columns (total 45 columns):\n",
            " #   Column              Non-Null Count  Dtype  \n",
            "---  ------              --------------  -----  \n",
            " 0   volt_mean           12100 non-null  float64\n",
            " 1   volt_std            12100 non-null  float64\n",
            " 2   volt_skew           12100 non-null  float64\n",
            " 3   volt_kurtosis       12100 non-null  float64\n",
            " 4   volt_min            12100 non-null  float64\n",
            " 5   volt_max            12100 non-null  float64\n",
            " 6   volt_range          12100 non-null  float64\n",
            " 7   rotate_mean         12100 non-null  float64\n",
            " 8   rotate_std          12100 non-null  float64\n",
            " 9   rotate_skew         12100 non-null  float64\n",
            " 10  rotate_kurtosis     12100 non-null  float64\n",
            " 11  rotate_min          12100 non-null  float64\n",
            " 12  rotate_max          12100 non-null  float64\n",
            " 13  rotate_range        12100 non-null  float64\n",
            " 14  pressure_mean       12100 non-null  float64\n",
            " 15  pressure_std        12100 non-null  float64\n",
            " 16  pressure_skew       12100 non-null  float64\n",
            " 17  pressure_kurtosis   12100 non-null  float64\n",
            " 18  pressure_min        12100 non-null  float64\n",
            " 19  pressure_max        12100 non-null  float64\n",
            " 20  pressure_range      12100 non-null  float64\n",
            " 21  vibration_mean      12100 non-null  float64\n",
            " 22  vibration_std       12100 non-null  float64\n",
            " 23  vibration_skew      12100 non-null  float64\n",
            " 24  vibration_kurtosis  12100 non-null  float64\n",
            " 25  vibration_min       12100 non-null  float64\n",
            " 26  vibration_max       12100 non-null  float64\n",
            " 27  vibration_range     12100 non-null  float64\n",
            " 28  comp1_maint_sum     12100 non-null  int64  \n",
            " 29  comp2_maint_sum     12100 non-null  int64  \n",
            " 30  comp3_maint_sum     12100 non-null  int64  \n",
            " 31  comp4_maint_sum     12100 non-null  int64  \n",
            " 32  error1_sum          12100 non-null  int64  \n",
            " 33  error2_sum          12100 non-null  int64  \n",
            " 34  error3_sum          12100 non-null  int64  \n",
            " 35  error4_sum          12100 non-null  int64  \n",
            " 36  error5_sum          12100 non-null  int64  \n",
            " 37  comp1_failure_sum   12100 non-null  int64  \n",
            " 38  comp2_failure_sum   12100 non-null  int64  \n",
            " 39  comp3_failure_sum   12100 non-null  int64  \n",
            " 40  comp4_failure_sum   12100 non-null  int64  \n",
            " 41  age_first           12100 non-null  int64  \n",
            " 42  model2_max          12100 non-null  int64  \n",
            " 43  model3_max          12100 non-null  int64  \n",
            " 44  model4_max          12100 non-null  int64  \n",
            "dtypes: float64(28), int64(17)\n",
            "memory usage: 4.2 MB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "#### Save Logistic Regression Data Matrix as JSON"
      ],
      "metadata": {
        "id": "hKTAgfAsdVBn"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "SAVE_FILENAME = 'LogReg_features_matrix.json'\n",
        "SAVE_LOC = os.path.join(DATA_DIR, SAVE_FILENAME)"
      ],
      "metadata": {
        "id": "yVcmO1LidVIy"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Convert the X dataframe to a JSON serializable numpy matrix\n",
        "X = np.array(X).tolist()\n",
        "\n",
        "# Write the JSON object to a file\n",
        "with open(SAVE_LOC, mode = 'w') as f:\n",
        "  json.dump(X, fp = f, indent = 4)"
      ],
      "metadata": {
        "id": "m52dogh5dVPV"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "### 2b. MLP"
      ],
      "metadata": {
        "id": "VmMzrvi8fhsB"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "#### Create MLP Data Dict From Preprocessed Data"
      ],
      "metadata": {
        "id": "6_gYCHzWvl7-"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Create the data matrix containing the features for a logistic regression model\n",
        "X = aggregated_df.drop(\n",
        "    columns=[\n",
        "        'datetime_first',\n",
        "        'machineID_first',\n",
        "    ]\n",
        ")\n",
        "X.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 224
        },
        "id": "n-WgD89UvvB5",
        "outputId": "17987a12-eb05-437a-e18f-439cf937e711"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "  machine_example_ID   volt_mean   volt_std  volt_skew  volt_kurtosis  \\\n",
              "0         (001, 001)  170.885811  12.988999   0.236573      -0.187545   \n",
              "1         (001, 002)  171.487472  17.667202  -0.256072       0.979570   \n",
              "2         (001, 003)  172.183333  13.290595  -0.031461      -0.494151   \n",
              "3         (001, 004)  169.639459  15.727822  -0.083465      -0.091825   \n",
              "4         (001, 005)  170.271970  16.233572  -0.112900       0.767195   \n",
              "\n",
              "     volt_min    volt_max  volt_range  rotate_mean  rotate_std  rotate_skew  \\\n",
              "0  140.776309  200.872430   60.096121   450.106721   44.537872     0.167780   \n",
              "1  121.502718  215.656488   94.153770   450.703413   41.818685    -0.127176   \n",
              "2  143.506562  200.741045   57.234483   451.975443   39.772529     0.226721   \n",
              "3  130.223881  203.777627   73.553746   447.914585   48.995525     0.056837   \n",
              "4  119.059047  216.955936   97.896889   460.005194   51.218599    -0.527761   \n",
              "\n",
              "   rotate_kurtosis  rotate_min  rotate_max  rotate_range  pressure_mean  \\\n",
              "0        -0.494777  346.149335  568.972310    222.822975      99.275061   \n",
              "1         0.406995  345.418513  575.505189    230.086676     101.323552   \n",
              "2        -0.114202  361.562141  552.372925    190.810784      99.888028   \n",
              "3         0.721875  307.175549  586.945963    279.770414      98.173025   \n",
              "4         1.135857  283.244579  568.837979    285.593399     101.344157   \n",
              "\n",
              "   pressure_std  pressure_skew  pressure_kurtosis  pressure_min  pressure_max  \\\n",
              "0     10.467413       0.127480          -0.432249     75.237905    127.014498   \n",
              "1     10.213230       0.023665          -0.433038     78.721961    126.464580   \n",
              "2      9.198322      -0.291560          -0.892300     81.565288    117.164152   \n",
              "3     11.176246      -0.537925           1.053841     58.733724    119.749926   \n",
              "4     10.064452      -0.316597           0.350864     68.760655    123.952205   \n",
              "\n",
              "   pressure_range  vibration_mean  vibration_std  vibration_skew  \\\n",
              "0       51.776593       43.736157       8.298338        0.335899   \n",
              "1       47.742619       44.487873       7.103904        0.401587   \n",
              "2       35.598864       39.924214       4.944806        0.141510   \n",
              "3       61.016203       40.227433       5.115975        0.194594   \n",
              "4       55.191550       40.225275       5.192884       -0.189996   \n",
              "\n",
              "   vibration_kurtosis  vibration_min  vibration_max  vibration_range  \\\n",
              "0           -0.301468      25.990511      66.764515        40.774004   \n",
              "1           -0.431127      32.813967      62.464103        29.650136   \n",
              "2            0.069886      29.031392      54.919547        25.888155   \n",
              "3           -0.757725      30.127114      51.786687        21.659573   \n",
              "4           -0.016270      27.105512      52.884798        25.779285   \n",
              "\n",
              "   comp1_maint_sum  comp2_maint_sum  comp3_maint_sum  comp4_maint_sum  \\\n",
              "0                0                0                0                0   \n",
              "1                1                0                0                0   \n",
              "2                0                0                0                0   \n",
              "3                0                0                0                0   \n",
              "4                0                0                0                0   \n",
              "\n",
              "   error1_sum  error2_sum  error3_sum  error4_sum  error5_sum  \\\n",
              "0           1           0           1           0           0   \n",
              "1           0           0           0           0           1   \n",
              "2           0           0           0           0           0   \n",
              "3           0           0           0           1           0   \n",
              "4           0           0           0           0           0   \n",
              "\n",
              "   comp1_failure_sum  comp2_failure_sum  comp3_failure_sum  comp4_failure_sum  \\\n",
              "0                  0                  0                  0                  0   \n",
              "1                  0                  0                  0                  1   \n",
              "2                  0                  0                  0                  0   \n",
              "3                  0                  0                  0                  0   \n",
              "4                  0                  0                  0                  0   \n",
              "\n",
              "   age_first  model2_max  model3_max  model4_max  \n",
              "0         18           0           1           0  \n",
              "1         18           0           1           0  \n",
              "2         18           0           1           0  \n",
              "3         18           0           1           0  \n",
              "4         18           0           1           0  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-1506c745-9ddd-40b0-8ec4-ffe990ded071\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>machine_example_ID</th>\n",
              "      <th>volt_mean</th>\n",
              "      <th>volt_std</th>\n",
              "      <th>volt_skew</th>\n",
              "      <th>volt_kurtosis</th>\n",
              "      <th>volt_min</th>\n",
              "      <th>volt_max</th>\n",
              "      <th>volt_range</th>\n",
              "      <th>rotate_mean</th>\n",
              "      <th>rotate_std</th>\n",
              "      <th>rotate_skew</th>\n",
              "      <th>rotate_kurtosis</th>\n",
              "      <th>rotate_min</th>\n",
              "      <th>rotate_max</th>\n",
              "      <th>rotate_range</th>\n",
              "      <th>pressure_mean</th>\n",
              "      <th>pressure_std</th>\n",
              "      <th>pressure_skew</th>\n",
              "      <th>pressure_kurtosis</th>\n",
              "      <th>pressure_min</th>\n",
              "      <th>pressure_max</th>\n",
              "      <th>pressure_range</th>\n",
              "      <th>vibration_mean</th>\n",
              "      <th>vibration_std</th>\n",
              "      <th>vibration_skew</th>\n",
              "      <th>vibration_kurtosis</th>\n",
              "      <th>vibration_min</th>\n",
              "      <th>vibration_max</th>\n",
              "      <th>vibration_range</th>\n",
              "      <th>comp1_maint_sum</th>\n",
              "      <th>comp2_maint_sum</th>\n",
              "      <th>comp3_maint_sum</th>\n",
              "      <th>comp4_maint_sum</th>\n",
              "      <th>error1_sum</th>\n",
              "      <th>error2_sum</th>\n",
              "      <th>error3_sum</th>\n",
              "      <th>error4_sum</th>\n",
              "      <th>error5_sum</th>\n",
              "      <th>comp1_failure_sum</th>\n",
              "      <th>comp2_failure_sum</th>\n",
              "      <th>comp3_failure_sum</th>\n",
              "      <th>comp4_failure_sum</th>\n",
              "      <th>age_first</th>\n",
              "      <th>model2_max</th>\n",
              "      <th>model3_max</th>\n",
              "      <th>model4_max</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>(001, 001)</td>\n",
              "      <td>170.885811</td>\n",
              "      <td>12.988999</td>\n",
              "      <td>0.236573</td>\n",
              "      <td>-0.187545</td>\n",
              "      <td>140.776309</td>\n",
              "      <td>200.872430</td>\n",
              "      <td>60.096121</td>\n",
              "      <td>450.106721</td>\n",
              "      <td>44.537872</td>\n",
              "      <td>0.167780</td>\n",
              "      <td>-0.494777</td>\n",
              "      <td>346.149335</td>\n",
              "      <td>568.972310</td>\n",
              "      <td>222.822975</td>\n",
              "      <td>99.275061</td>\n",
              "      <td>10.467413</td>\n",
              "      <td>0.127480</td>\n",
              "      <td>-0.432249</td>\n",
              "      <td>75.237905</td>\n",
              "      <td>127.014498</td>\n",
              "      <td>51.776593</td>\n",
              "      <td>43.736157</td>\n",
              "      <td>8.298338</td>\n",
              "      <td>0.335899</td>\n",
              "      <td>-0.301468</td>\n",
              "      <td>25.990511</td>\n",
              "      <td>66.764515</td>\n",
              "      <td>40.774004</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>(001, 002)</td>\n",
              "      <td>171.487472</td>\n",
              "      <td>17.667202</td>\n",
              "      <td>-0.256072</td>\n",
              "      <td>0.979570</td>\n",
              "      <td>121.502718</td>\n",
              "      <td>215.656488</td>\n",
              "      <td>94.153770</td>\n",
              "      <td>450.703413</td>\n",
              "      <td>41.818685</td>\n",
              "      <td>-0.127176</td>\n",
              "      <td>0.406995</td>\n",
              "      <td>345.418513</td>\n",
              "      <td>575.505189</td>\n",
              "      <td>230.086676</td>\n",
              "      <td>101.323552</td>\n",
              "      <td>10.213230</td>\n",
              "      <td>0.023665</td>\n",
              "      <td>-0.433038</td>\n",
              "      <td>78.721961</td>\n",
              "      <td>126.464580</td>\n",
              "      <td>47.742619</td>\n",
              "      <td>44.487873</td>\n",
              "      <td>7.103904</td>\n",
              "      <td>0.401587</td>\n",
              "      <td>-0.431127</td>\n",
              "      <td>32.813967</td>\n",
              "      <td>62.464103</td>\n",
              "      <td>29.650136</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>(001, 003)</td>\n",
              "      <td>172.183333</td>\n",
              "      <td>13.290595</td>\n",
              "      <td>-0.031461</td>\n",
              "      <td>-0.494151</td>\n",
              "      <td>143.506562</td>\n",
              "      <td>200.741045</td>\n",
              "      <td>57.234483</td>\n",
              "      <td>451.975443</td>\n",
              "      <td>39.772529</td>\n",
              "      <td>0.226721</td>\n",
              "      <td>-0.114202</td>\n",
              "      <td>361.562141</td>\n",
              "      <td>552.372925</td>\n",
              "      <td>190.810784</td>\n",
              "      <td>99.888028</td>\n",
              "      <td>9.198322</td>\n",
              "      <td>-0.291560</td>\n",
              "      <td>-0.892300</td>\n",
              "      <td>81.565288</td>\n",
              "      <td>117.164152</td>\n",
              "      <td>35.598864</td>\n",
              "      <td>39.924214</td>\n",
              "      <td>4.944806</td>\n",
              "      <td>0.141510</td>\n",
              "      <td>0.069886</td>\n",
              "      <td>29.031392</td>\n",
              "      <td>54.919547</td>\n",
              "      <td>25.888155</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>(001, 004)</td>\n",
              "      <td>169.639459</td>\n",
              "      <td>15.727822</td>\n",
              "      <td>-0.083465</td>\n",
              "      <td>-0.091825</td>\n",
              "      <td>130.223881</td>\n",
              "      <td>203.777627</td>\n",
              "      <td>73.553746</td>\n",
              "      <td>447.914585</td>\n",
              "      <td>48.995525</td>\n",
              "      <td>0.056837</td>\n",
              "      <td>0.721875</td>\n",
              "      <td>307.175549</td>\n",
              "      <td>586.945963</td>\n",
              "      <td>279.770414</td>\n",
              "      <td>98.173025</td>\n",
              "      <td>11.176246</td>\n",
              "      <td>-0.537925</td>\n",
              "      <td>1.053841</td>\n",
              "      <td>58.733724</td>\n",
              "      <td>119.749926</td>\n",
              "      <td>61.016203</td>\n",
              "      <td>40.227433</td>\n",
              "      <td>5.115975</td>\n",
              "      <td>0.194594</td>\n",
              "      <td>-0.757725</td>\n",
              "      <td>30.127114</td>\n",
              "      <td>51.786687</td>\n",
              "      <td>21.659573</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>(001, 005)</td>\n",
              "      <td>170.271970</td>\n",
              "      <td>16.233572</td>\n",
              "      <td>-0.112900</td>\n",
              "      <td>0.767195</td>\n",
              "      <td>119.059047</td>\n",
              "      <td>216.955936</td>\n",
              "      <td>97.896889</td>\n",
              "      <td>460.005194</td>\n",
              "      <td>51.218599</td>\n",
              "      <td>-0.527761</td>\n",
              "      <td>1.135857</td>\n",
              "      <td>283.244579</td>\n",
              "      <td>568.837979</td>\n",
              "      <td>285.593399</td>\n",
              "      <td>101.344157</td>\n",
              "      <td>10.064452</td>\n",
              "      <td>-0.316597</td>\n",
              "      <td>0.350864</td>\n",
              "      <td>68.760655</td>\n",
              "      <td>123.952205</td>\n",
              "      <td>55.191550</td>\n",
              "      <td>40.225275</td>\n",
              "      <td>5.192884</td>\n",
              "      <td>-0.189996</td>\n",
              "      <td>-0.016270</td>\n",
              "      <td>27.105512</td>\n",
              "      <td>52.884798</td>\n",
              "      <td>25.779285</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1506c745-9ddd-40b0-8ec4-ffe990ded071')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-1506c745-9ddd-40b0-8ec4-ffe990ded071 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-1506c745-9ddd-40b0-8ec4-ffe990ded071');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-ad5aab16-486b-4be4-8fbe-a12eb009aa75\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-ad5aab16-486b-4be4-8fbe-a12eb009aa75')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-ad5aab16-486b-4be4-8fbe-a12eb009aa75 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "X"
            }
          },
          "metadata": {},
          "execution_count": 75
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "X.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "frMIT-Ecv0jB",
        "outputId": "992f4a39-a6d5-4fcf-f205-0d8a87898581"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "Index: 12100 entries, 0 to 12198\n",
            "Data columns (total 46 columns):\n",
            " #   Column              Non-Null Count  Dtype  \n",
            "---  ------              --------------  -----  \n",
            " 0   machine_example_ID  12100 non-null  object \n",
            " 1   volt_mean           12100 non-null  float64\n",
            " 2   volt_std            12100 non-null  float64\n",
            " 3   volt_skew           12100 non-null  float64\n",
            " 4   volt_kurtosis       12100 non-null  float64\n",
            " 5   volt_min            12100 non-null  float64\n",
            " 6   volt_max            12100 non-null  float64\n",
            " 7   volt_range          12100 non-null  float64\n",
            " 8   rotate_mean         12100 non-null  float64\n",
            " 9   rotate_std          12100 non-null  float64\n",
            " 10  rotate_skew         12100 non-null  float64\n",
            " 11  rotate_kurtosis     12100 non-null  float64\n",
            " 12  rotate_min          12100 non-null  float64\n",
            " 13  rotate_max          12100 non-null  float64\n",
            " 14  rotate_range        12100 non-null  float64\n",
            " 15  pressure_mean       12100 non-null  float64\n",
            " 16  pressure_std        12100 non-null  float64\n",
            " 17  pressure_skew       12100 non-null  float64\n",
            " 18  pressure_kurtosis   12100 non-null  float64\n",
            " 19  pressure_min        12100 non-null  float64\n",
            " 20  pressure_max        12100 non-null  float64\n",
            " 21  pressure_range      12100 non-null  float64\n",
            " 22  vibration_mean      12100 non-null  float64\n",
            " 23  vibration_std       12100 non-null  float64\n",
            " 24  vibration_skew      12100 non-null  float64\n",
            " 25  vibration_kurtosis  12100 non-null  float64\n",
            " 26  vibration_min       12100 non-null  float64\n",
            " 27  vibration_max       12100 non-null  float64\n",
            " 28  vibration_range     12100 non-null  float64\n",
            " 29  comp1_maint_sum     12100 non-null  int64  \n",
            " 30  comp2_maint_sum     12100 non-null  int64  \n",
            " 31  comp3_maint_sum     12100 non-null  int64  \n",
            " 32  comp4_maint_sum     12100 non-null  int64  \n",
            " 33  error1_sum          12100 non-null  int64  \n",
            " 34  error2_sum          12100 non-null  int64  \n",
            " 35  error3_sum          12100 non-null  int64  \n",
            " 36  error4_sum          12100 non-null  int64  \n",
            " 37  error5_sum          12100 non-null  int64  \n",
            " 38  comp1_failure_sum   12100 non-null  int64  \n",
            " 39  comp2_failure_sum   12100 non-null  int64  \n",
            " 40  comp3_failure_sum   12100 non-null  int64  \n",
            " 41  comp4_failure_sum   12100 non-null  int64  \n",
            " 42  age_first           12100 non-null  int64  \n",
            " 43  model2_max          12100 non-null  int64  \n",
            " 44  model3_max          12100 non-null  int64  \n",
            " 45  model4_max          12100 non-null  int64  \n",
            "dtypes: float64(28), int64(17), object(1)\n",
            "memory usage: 4.3+ MB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Create dict with machine_example_ID keys and corresponding rows as a list value\n",
        "machine_summary_dict = X.set_index('machine_example_ID').T.to_dict('list')"
      ],
      "metadata": {
        "id": "e-xIUkt8v3jJ"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "i = 0\n",
        "for k, v in machine_summary_dict.items():\n",
        "    i += 1\n",
        "    if i > 5:\n",
        "        break\n",
        "    print(f\"{k}: {v}\")"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "1YIaGdanv539",
        "outputId": "c8032915-38c2-4c37-9141-b3f93797f31a"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "(001, 001): [170.8858114624484, 12.988998585540942, 0.23657261238213764, -0.18754454523144837, 140.776309290179, 200.872429816452, 60.09612052627301, 450.1067211349322, 44.5378720679287, 0.16777975702039052, -0.49477721853209644, 346.149335043074, 568.972310325907, 222.82297528283294, 99.27506051721805, 10.467412730403368, 0.127479588845299, -0.43224858709881886, 75.2379048586662, 127.014497747491, 51.77659288882481, 43.73615663190936, 8.298337892989313, 0.33589869397807204, -0.3014679076312867, 25.9905109982024, 66.7645147253914, 40.774003727189, 0.0, 0.0, 0.0, 0.0, 1.0, 0.0, 1.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 18.0, 0.0, 1.0, 0.0]\n",
            "(001, 002): [171.4874722590641, 17.667201768926702, -0.25607222161856363, 0.9795697255810554, 121.502718006153, 215.656488291429, 94.15377028527601, 450.7034130376246, 41.81868548546561, -0.1271760080238314, 0.40699488567150555, 345.418513385006, 575.50518940115, 230.086676016144, 101.32355213528129, 10.213230127528549, 0.02366549919009111, -0.433037955494592, 78.7219612688046, 126.464580238711, 47.74261896990639, 44.4878725915423, 7.103903867840124, 0.4015869783391968, -0.4311273258771289, 32.8139669206376, 62.464102741692, 29.650135821054405, 1.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 1.0, 0.0, 0.0, 0.0, 1.0, 18.0, 0.0, 1.0, 0.0]\n",
            "(001, 003): [172.18333273683083, 13.290594658578787, -0.03146121495204261, -0.49415116739024256, 143.506561798543, 200.741045025064, 57.23448322652101, 451.975443410148, 39.77252862728511, 0.22672053833080974, -0.11420171024446857, 361.562140621931, 552.372924953164, 190.81078433123298, 99.88802784431513, 9.19832204011173, -0.2915601123419381, -0.8922997188275601, 81.5652879473298, 117.164152149271, 35.59886420194121, 39.924213596328165, 4.944806157255963, 0.14150975292041887, 0.06988631071650797, 29.0313915642058, 54.9195465697047, 25.8881550054989, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 18.0, 0.0, 1.0, 0.0]\n",
            "(001, 004): [169.63945884885837, 15.727822172273905, -0.08346524415867926, -0.09182501240132179, 130.22388127441, 203.777627001903, 73.55374572749301, 447.9145846688167, 48.99552483869081, 0.05683686333625458, 0.7218753163320133, 307.175548839697, 586.9459625212, 279.77041368150304, 98.1730253362725, 11.176246221376763, -0.5379254837034404, 1.0538410186815144, 58.7337237736923, 119.749926388903, 61.01620261521071, 40.22743266422524, 5.115975454557192, 0.19459398502937034, -0.7577248327451622, 30.1271140698899, 51.7866867590289, 21.659572689139004, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 1.0, 0.0, 0.0, 0.0, 0.0, 0.0, 18.0, 0.0, 1.0, 0.0]\n",
            "(001, 005): [170.2719700766968, 16.233572111905097, -0.11289993590660327, 0.7671946407249246, 119.059046981385, 216.955936428285, 97.89688944690002, 460.00519367865695, 51.21859888353039, -0.5277609702547483, 1.135857268391911, 283.244579426427, 568.837978608126, 285.59339918169906, 101.34415666275262, 10.064451881322316, -0.31659746187853705, 0.3508644551838671, 68.7606546156509, 123.952205053366, 55.191550437715094, 40.22527461753664, 5.192883572671079, -0.18999600211832843, -0.01627013941452171, 27.1055123597247, 52.884797512349, 25.779285152624304, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 18.0, 0.0, 1.0, 0.0]\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "#### Save MLP Data Dict as JSON"
      ],
      "metadata": {
        "id": "HN9e1qaOwASC"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "SAVE_FILENAME = 'MLP_features_dict.json'\n",
        "SAVE_LOC = os.path.join(DATA_DIR, SAVE_FILENAME)"
      ],
      "metadata": {
        "id": "ihJkv4e8wBDU"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "with open(SAVE_LOC, mode = 'w') as json_f:\n",
        "  json.dump(obj = machine_summary_dict, fp = json_f, indent = 4)"
      ],
      "metadata": {
        "id": "CznQZN5VwDl0"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}