Analise_VisioLinkBrazauroFluidsHistoryRev20052024.ipynb

{
  "cells": [
    {
      "cell_type": "code",
      "source": [
        "!pip install markdown\n",
        "!pip install statsmodels\n",
        "!pip install scikit-learn\n",
        "!pip install PyGithub\n",
        "!pip install gitpython\n",
        "!pip install statsmodels\n",
        "!pip install dash\n",
        "!pip install xlwt\n",
        "!pip install openpyxl\n",
        "!pip install tensorflow\n",
        "!pip install scipy"
      ],
      "metadata": {
        "id": "zf02dsgr-YtN"
      },
      "id": "zf02dsgr-YtN",
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "execution_count": 47,
      "id": "c3d73818",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "c3d73818",
        "outputId": "87f7c6fd-7327-4476-b566-258f8ec58acf"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Download do arquivo concluído com sucesso!\n",
            "['Name', 'Asset Serial Number', 'Make', 'Model', 'Odometer', 'Odometer unit of measure', 'Odometer Last Reported Time', 'Sample Meter', 'Hour meter unit of measure', 'Sample Date', 'Fluid Sample', 'Lab report number', 'Lifetime Energy Generated Value', 'Service Meter Unit', 'Lifetime Energy Generated Timestamp', 'Lifetime Fuel Consumed Value', 'Service Meter Unit.1', 'Lifetime Fuel Consumed Timestamp', 'Severity', 'Recommendation', 'Odometer Value', 'Service Meter Unit.2', 'Odometer Timestamp', 'Hours Value', 'Service Meter Unit.3', 'Analysis Date', 'Last Known Location', 'Last Known Location Last Reported Time']\n"
          ]
        }
      ],
      "source": [
        "import requests\n",
        "import pandas as pd\n",
        "\n",
        "# URL do arquivo no repositório do GitHub\n",
        "file_url = 'https://raw.githubusercontent.com/CidClayQuirino/rnn-component-lIfe-cycle/main/FluidsHistoryBrazauro.csv'\n",
        "\n",
        "FluidsHistoryBrazauro = pd.read_csv(file_url)\n",
        "\n",
        "# Enviar solicitação GET para fazer o download do arquivo\n",
        "response = requests.get(file_url)\n",
        "\n",
        "# Verificar se a solicitação foi bem-sucedida\n",
        "if response.status_code == 200:\n",
        "    # Salvar o conteúdo do arquivo em um arquivo local\n",
        "    with open('faultCodesHistoryBrazauro.csv', 'wb') as file:\n",
        "        file.write(response.content)\n",
        "    print(\"Download do arquivo concluído com sucesso!\")\n",
        "else:\n",
        "    print(\"Erro ao fazer download do arquivo:\", response.text)\n",
        "\n",
        "    # Listar as colunas do DataFrame\n",
        "colunas = FluidsHistoryBrazauro.columns.tolist()\n",
        "\n",
        "# Exibir as colunas\n",
        "print(colunas)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 48,
      "id": "c0973dd7",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "c0973dd7",
        "outputId": "f21b4d4f-303c-439a-8e50-95fecf6a8d87"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "['Name', 'Asset Serial Number', 'Make', 'Model', 'Odometer', 'Odometer unit of measure', 'Odometer Last Reported Time', 'Sample Meter', 'Hour meter unit of measure', 'Sample Date', 'Fluid Sample', 'Lab report number', 'Lifetime Energy Generated Value', 'Service Meter Unit', 'Lifetime Energy Generated Timestamp', 'Lifetime Fuel Consumed Value', 'Service Meter Unit.1', 'Lifetime Fuel Consumed Timestamp', 'Severity', 'Recommendation', 'Odometer Value', 'Service Meter Unit.2', 'Odometer Timestamp', 'Hours Value', 'Service Meter Unit.3', 'Analysis Date', 'Last Known Location', 'Last Known Location Last Reported Time']\n"
          ]
        }
      ],
      "source": [
        "import pandas as pd\n",
        "\n",
        "dfFluyds = FluidsHistoryBrazauro\n",
        "\n",
        "# Listar as colunas do DataFrame\n",
        "colunas = dfFluyds.columns.tolist()\n",
        "\n",
        "# Exibir as colunas\n",
        "print(colunas)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 49,
      "id": "e127b652",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 568
        },
        "id": "e127b652",
        "outputId": "900ddea5-f92d-4436-884e-e96c67c97f77"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      Name Asset Serial Number Make   Model      Odometer  \\\n",
              "0  040-010            7W802866  CAT  777-05  29492.504596   \n",
              "1  040-010            7W802866  CAT  777-05  29492.504596   \n",
              "2  040-010            7W802866  CAT  777-05  29492.504596   \n",
              "3  040-010            7W802866  CAT  777-05  29492.504596   \n",
              "4  040-010            7W802866  CAT  777-05  29492.504596   \n",
              "\n",
              "  Odometer unit of measure Odometer Last Reported Time  Sample Meter  \\\n",
              "0                       mi   2024-05-19T18:02:13-06:00   5215.322506   \n",
              "1                       mi   2024-05-19T18:02:13-06:00   5215.322506   \n",
              "2                       mi   2024-05-19T18:02:13-06:00   5215.322506   \n",
              "3                       mi   2024-05-19T18:02:13-06:00   5215.322506   \n",
              "4                       mi   2024-05-19T18:02:13-06:00   5215.322506   \n",
              "\n",
              "  Hour meter unit of measure Sample Date  ...             Severity  \\\n",
              "0                          h  2024-04-26  ...   No Action Required   \n",
              "1                          h  2024-04-26  ...   No Action Required   \n",
              "2                          h  2024-04-26  ...   No Action Required   \n",
              "3                          h  2024-04-26  ...  Monitor Compartment   \n",
              "4                          h  2024-04-26  ...   No Action Required   \n",
              "\n",
              "                                      Recommendation  Odometer Value  \\\n",
              "0  Nível normal de desgaste. Óleo em condição de ...             NaN   \n",
              "1  Nível normal de desgaste. Óleo em condição de ...             NaN   \n",
              "2  Nível normal de desgaste. Monitorar nos interv...             NaN   \n",
              "3  O alto valor de sulfatação indica degradação d...             NaN   \n",
              "4  Nível normal de desgaste. Óleo em condição de ...             NaN   \n",
              "\n",
              "   Service Meter Unit.2  Odometer Timestamp  Hours Value Service Meter Unit.3  \\\n",
              "0                   NaN                 NaN       4914.0                    h   \n",
              "1                   NaN                 NaN       4914.0                    h   \n",
              "2                   NaN                 NaN       4914.0                    h   \n",
              "3                   NaN                 NaN       4914.0                    h   \n",
              "4                   NaN                 NaN       4914.0                    h   \n",
              "\n",
              "               Analysis Date     Last Known Location  \\\n",
              "0  2024-05-16T07:01:56-06:00  Itaituba, Brazil 68180   \n",
              "1  2024-05-16T07:02:48-06:00  Itaituba, Brazil 68180   \n",
              "2  2024-05-16T07:07:23-06:00  Itaituba, Brazil 68180   \n",
              "3  2024-05-16T07:03:16-06:00  Itaituba, Brazil 68180   \n",
              "4  2024-05-16T07:07:15-06:00  Itaituba, Brazil 68180   \n",
              "\n",
              "  Last Known Location Last Reported Time  \n",
              "0              2024-05-19T20:35:53-06:00  \n",
              "1              2024-05-19T20:35:53-06:00  \n",
              "2              2024-05-19T20:35:53-06:00  \n",
              "3              2024-05-19T20:35:53-06:00  \n",
              "4              2024-05-19T20:35:53-06:00  \n",
              "\n",
              "[5 rows x 28 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-5b9e8566-bd0a-4282-ae40-3dec3b9ee8e9\" 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>Name</th>\n",
              "      <th>Asset Serial Number</th>\n",
              "      <th>Make</th>\n",
              "      <th>Model</th>\n",
              "      <th>Odometer</th>\n",
              "      <th>Odometer unit of measure</th>\n",
              "      <th>Odometer Last Reported Time</th>\n",
              "      <th>Sample Meter</th>\n",
              "      <th>Hour meter unit of measure</th>\n",
              "      <th>Sample Date</th>\n",
              "      <th>...</th>\n",
              "      <th>Severity</th>\n",
              "      <th>Recommendation</th>\n",
              "      <th>Odometer Value</th>\n",
              "      <th>Service Meter Unit.2</th>\n",
              "      <th>Odometer Timestamp</th>\n",
              "      <th>Hours Value</th>\n",
              "      <th>Service Meter Unit.3</th>\n",
              "      <th>Analysis Date</th>\n",
              "      <th>Last Known Location</th>\n",
              "      <th>Last Known Location Last Reported Time</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>040-010</td>\n",
              "      <td>7W802866</td>\n",
              "      <td>CAT</td>\n",
              "      <td>777-05</td>\n",
              "      <td>29492.504596</td>\n",
              "      <td>mi</td>\n",
              "      <td>2024-05-19T18:02:13-06:00</td>\n",
              "      <td>5215.322506</td>\n",
              "      <td>h</td>\n",
              "      <td>2024-04-26</td>\n",
              "      <td>...</td>\n",
              "      <td>No Action Required</td>\n",
              "      <td>Nível normal de desgaste. Óleo em condição de ...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4914.0</td>\n",
              "      <td>h</td>\n",
              "      <td>2024-05-16T07:01:56-06:00</td>\n",
              "      <td>Itaituba, Brazil 68180</td>\n",
              "      <td>2024-05-19T20:35:53-06:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>040-010</td>\n",
              "      <td>7W802866</td>\n",
              "      <td>CAT</td>\n",
              "      <td>777-05</td>\n",
              "      <td>29492.504596</td>\n",
              "      <td>mi</td>\n",
              "      <td>2024-05-19T18:02:13-06:00</td>\n",
              "      <td>5215.322506</td>\n",
              "      <td>h</td>\n",
              "      <td>2024-04-26</td>\n",
              "      <td>...</td>\n",
              "      <td>No Action Required</td>\n",
              "      <td>Nível normal de desgaste. Óleo em condição de ...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4914.0</td>\n",
              "      <td>h</td>\n",
              "      <td>2024-05-16T07:02:48-06:00</td>\n",
              "      <td>Itaituba, Brazil 68180</td>\n",
              "      <td>2024-05-19T20:35:53-06:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>040-010</td>\n",
              "      <td>7W802866</td>\n",
              "      <td>CAT</td>\n",
              "      <td>777-05</td>\n",
              "      <td>29492.504596</td>\n",
              "      <td>mi</td>\n",
              "      <td>2024-05-19T18:02:13-06:00</td>\n",
              "      <td>5215.322506</td>\n",
              "      <td>h</td>\n",
              "      <td>2024-04-26</td>\n",
              "      <td>...</td>\n",
              "      <td>No Action Required</td>\n",
              "      <td>Nível normal de desgaste. Monitorar nos interv...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4914.0</td>\n",
              "      <td>h</td>\n",
              "      <td>2024-05-16T07:07:23-06:00</td>\n",
              "      <td>Itaituba, Brazil 68180</td>\n",
              "      <td>2024-05-19T20:35:53-06:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>040-010</td>\n",
              "      <td>7W802866</td>\n",
              "      <td>CAT</td>\n",
              "      <td>777-05</td>\n",
              "      <td>29492.504596</td>\n",
              "      <td>mi</td>\n",
              "      <td>2024-05-19T18:02:13-06:00</td>\n",
              "      <td>5215.322506</td>\n",
              "      <td>h</td>\n",
              "      <td>2024-04-26</td>\n",
              "      <td>...</td>\n",
              "      <td>Monitor Compartment</td>\n",
              "      <td>O alto valor de sulfatação indica degradação d...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4914.0</td>\n",
              "      <td>h</td>\n",
              "      <td>2024-05-16T07:03:16-06:00</td>\n",
              "      <td>Itaituba, Brazil 68180</td>\n",
              "      <td>2024-05-19T20:35:53-06:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>040-010</td>\n",
              "      <td>7W802866</td>\n",
              "      <td>CAT</td>\n",
              "      <td>777-05</td>\n",
              "      <td>29492.504596</td>\n",
              "      <td>mi</td>\n",
              "      <td>2024-05-19T18:02:13-06:00</td>\n",
              "      <td>5215.322506</td>\n",
              "      <td>h</td>\n",
              "      <td>2024-04-26</td>\n",
              "      <td>...</td>\n",
              "      <td>No Action Required</td>\n",
              "      <td>Nível normal de desgaste. Óleo em condição de ...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4914.0</td>\n",
              "      <td>h</td>\n",
              "      <td>2024-05-16T07:07:15-06:00</td>\n",
              "      <td>Itaituba, Brazil 68180</td>\n",
              "      <td>2024-05-19T20:35:53-06:00</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 28 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-5b9e8566-bd0a-4282-ae40-3dec3b9ee8e9')\"\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-5b9e8566-bd0a-4282-ae40-3dec3b9ee8e9 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-5b9e8566-bd0a-4282-ae40-3dec3b9ee8e9');\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-18572fe0-ab17-4a4d-86b3-45145d21ca33\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-18572fe0-ab17-4a4d-86b3-45145d21ca33')\"\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-18572fe0-ab17-4a4d-86b3-45145d21ca33 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": "dfFluyds"
            }
          },
          "metadata": {},
          "execution_count": 49
        }
      ],
      "source": [
        "import pandas as pd\n",
        "dfFluyds = FluidsHistoryBrazauro\n",
        "# Converter a coluna 'Fault Date' para o tipo datetime\n",
        "dfFluyds['Sample Date'] = pd.to_datetime(FluidsHistoryBrazauro['Sample Date'].str.slice(0, 10))\n",
        "dfFluyds.head()"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import pandas as pd\n",
        "from io import BytesIO\n",
        "\n",
        "# Função para salvar o DataFrame como CSV e enviar para o GitHub\n",
        "def salvar_e_enviar_para_github(dataframe, nome_arquivo, usuario, repositorio, token):\n",
        "    import requests\n",
        "    from base64 import b64encode\n",
        "\n",
        "    # Salvar DataFrame como CSV em um BytesIO\n",
        "    csv_bytes = BytesIO()\n",
        "    dataframe.to_csv(csv_bytes, index=False)\n",
        "\n",
        "    # Codificar o conteúdo CSV em base64\n",
        "    csv_content = b64encode(csv_bytes.getvalue()).decode()\n",
        "\n",
        "    # Configurar URL e cabeçalhos para a API do GitHub\n",
        "    url = f\"https://api.github.com/repos/{usuario}/{repositorio}/contents/{nome_arquivo}\"\n",
        "    headers = {\n",
        "        \"Authorization\": f\"token {token}\",\n",
        "        \"Content-Type\": \"application/json\"\n",
        "    }\n",
        "\n",
        "    # Configurar o payload para a API do GitHub\n",
        "    payload = {\n",
        "        \"message\": f\"Adicionando arquivo {nome_arquivo}\",\n",
        "        \"content\": csv_content\n",
        "    }\n",
        "\n",
        "    # Enviar a solicitação PUT para criar/atualizar o arquivo no repositório do GitHub\n",
        "    response = requests.put(url, headers=headers, json=payload)\n",
        "\n",
        "    # Verificar a resposta da API do GitHub\n",
        "    if response.status_code == 201:\n",
        "        print(f\"Arquivo {nome_arquivo} criado com sucesso no repositório {repositorio}.\")\n",
        "    elif response.status_code == 200:\n",
        "        print(f\"Arquivo {nome_arquivo} atualizado com sucesso no repositório {repositorio}.\")\n",
        "    else:\n",
        "        print(f\"Falha ao enviar arquivo para o GitHub: {response.status_code} - {response.json()}\")\n",
        "\n",
        "# Dados de exemplo para enviar o DataFrame para o GitHub\n",
        "seu_usuario = \"CidClayQuirino\"\n",
        "seu_repositorio = \"rnn-component-lIfe-cycle\"\n",
        "seu_token = \"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\"\n",
        "\n",
        "# Salvar e enviar o DataFrame filtrado para o GitHub\n",
        "salvar_e_enviar_para_github(dfFaultCode6P300101, \"dfFaultCode6P300101.csv\", seu_usuario, seu_repositorio, seu_token)\n",
        "salvar_e_enviar_para_github(dfFaultCode6P300111, \"dfFaultCode6P300111.csv\", seu_usuario, seu_repositorio, seu_token)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "baq9llTNYNWl",
        "outputId": "fe742c41-fdb5-4261-dd8c-42737e701ad4"
      },
      "id": "baq9llTNYNWl",
      "execution_count": 21,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Falha ao enviar arquivo para o GitHub: 422 - {'message': 'Invalid request.\\n\\n\"sha\" wasn\\'t supplied.', 'documentation_url': 'https://docs.github.com/rest/repos/contents#create-or-update-file-contents'}\n",
            "Falha ao enviar arquivo para o GitHub: 422 - {'message': 'Invalid request.\\n\\n\"sha\" wasn\\'t supplied.', 'documentation_url': 'https://docs.github.com/rest/repos/contents#create-or-update-file-contents'}\n"
          ]
        }
      ]
    }
  ],
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3 (ipykernel)",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "codemirror_mode": {
        "name": "ipython",
        "version": 3
      },
      "file_extension": ".py",
      "mimetype": "text/x-python",
      "name": "python",
      "nbconvert_exporter": "python",
      "pygments_lexer": "ipython3",
      "version": "3.11.5"
    },
    "colab": {
      "provenance": []
    }
  },
  "nbformat": 4,
  "nbformat_minor": 5
}