Python_Basics(Practice).ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyP1AKqF2RLMN90fFiJx89x2",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/Dhinesh-Fedor/Python---Basics/blob/main/Python_Basics(Practice).ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 12,
      "metadata": {
        "id": "nuB4U91-0Kdu",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        },
        "outputId": "841fb5cb-8155-466e-c949-4848c5a70b75"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                      Time   L06_347  LS06_347  LS06_348\n",
              "0      2009-01-01 00:00:00  0.137417  0.097500  0.016833\n",
              "1      2009-01-01 03:00:00  0.131250  0.088833  0.016417\n",
              "2      2009-01-01 06:00:00  0.113500  0.091250  0.016750\n",
              "3      2009-01-01 09:00:00  0.135750  0.091500  0.016250\n",
              "4      2009-01-01 12:00:00  0.140917  0.096167  0.017000\n",
              "...                    ...       ...       ...       ...\n",
              "11692  2013-01-01 12:00:00  1.710000  1.710000  0.129583\n",
              "11693  2013-01-01 15:00:00  1.420000  1.420000  0.096333\n",
              "11694  2013-01-01 18:00:00  1.178583  1.178583  0.083083\n",
              "11695  2013-01-01 21:00:00  0.898250  0.898250  0.077167\n",
              "11696  2013-01-02 00:00:00  0.860000  0.860000  0.075000\n",
              "\n",
              "[11697 rows x 4 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-65a5798f-3286-4d0c-9b38-f748d387200f\" 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>Time</th>\n",
              "      <th>L06_347</th>\n",
              "      <th>LS06_347</th>\n",
              "      <th>LS06_348</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2009-01-01 00:00:00</td>\n",
              "      <td>0.137417</td>\n",
              "      <td>0.097500</td>\n",
              "      <td>0.016833</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2009-01-01 03:00:00</td>\n",
              "      <td>0.131250</td>\n",
              "      <td>0.088833</td>\n",
              "      <td>0.016417</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2009-01-01 06:00:00</td>\n",
              "      <td>0.113500</td>\n",
              "      <td>0.091250</td>\n",
              "      <td>0.016750</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2009-01-01 09:00:00</td>\n",
              "      <td>0.135750</td>\n",
              "      <td>0.091500</td>\n",
              "      <td>0.016250</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2009-01-01 12:00:00</td>\n",
              "      <td>0.140917</td>\n",
              "      <td>0.096167</td>\n",
              "      <td>0.017000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11692</th>\n",
              "      <td>2013-01-01 12:00:00</td>\n",
              "      <td>1.710000</td>\n",
              "      <td>1.710000</td>\n",
              "      <td>0.129583</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11693</th>\n",
              "      <td>2013-01-01 15:00:00</td>\n",
              "      <td>1.420000</td>\n",
              "      <td>1.420000</td>\n",
              "      <td>0.096333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11694</th>\n",
              "      <td>2013-01-01 18:00:00</td>\n",
              "      <td>1.178583</td>\n",
              "      <td>1.178583</td>\n",
              "      <td>0.083083</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11695</th>\n",
              "      <td>2013-01-01 21:00:00</td>\n",
              "      <td>0.898250</td>\n",
              "      <td>0.898250</td>\n",
              "      <td>0.077167</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11696</th>\n",
              "      <td>2013-01-02 00:00:00</td>\n",
              "      <td>0.860000</td>\n",
              "      <td>0.860000</td>\n",
              "      <td>0.075000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>11697 rows × 4 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-65a5798f-3286-4d0c-9b38-f748d387200f')\"\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-65a5798f-3286-4d0c-9b38-f748d387200f 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-65a5798f-3286-4d0c-9b38-f748d387200f');\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-1e73e0fd-a4ec-4a47-b7d5-b02811de7fcc\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-1e73e0fd-a4ec-4a47-b7d5-b02811de7fcc')\"\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-1e73e0fd-a4ec-4a47-b7d5-b02811de7fcc button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "  <div id=\"id_0d9dd565-2265-4c0c-97d8-bfa54218828c\">\n",
              "    <style>\n",
              "      .colab-df-generate {\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-generate: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",
              "      [theme=dark] .colab-df-generate {\n",
              "        background-color: #3B4455;\n",
              "        fill: #D2E3FC;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate: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",
              "    <button class=\"colab-df-generate\" onclick=\"generateWithVariable('data_set')\"\n",
              "            title=\"Generate code using this dataframe.\"\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",
              "    <path d=\"M7,19H8.4L18.45,9,17,7.55,7,17.6ZM5,21V16.75L18.45,3.32a2,2,0,0,1,2.83,0l1.4,1.43a1.91,1.91,0,0,1,.58,1.4,1.91,1.91,0,0,1-.58,1.4L9.25,21ZM18.45,9,17,7.55Zm-12,3A5.31,5.31,0,0,0,4.9,8.1,5.31,5.31,0,0,0,1,6.5,5.31,5.31,0,0,0,4.9,4.9,5.31,5.31,0,0,0,6.5,1,5.31,5.31,0,0,0,8.1,4.9,5.31,5.31,0,0,0,12,6.5,5.46,5.46,0,0,0,6.5,12Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "    <script>\n",
              "      (() => {\n",
              "      const buttonEl =\n",
              "        document.querySelector('#id_0d9dd565-2265-4c0c-97d8-bfa54218828c button.colab-df-generate');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      buttonEl.onclick = () => {\n",
              "        google.colab.notebook.generateWithVariable('data_set');\n",
              "      }\n",
              "      })();\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "data_set",
              "summary": "{\n  \"name\": \"data_set\",\n  \"rows\": 11697,\n  \"fields\": [\n    {\n      \"column\": \"Time\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 11697,\n        \"samples\": [\n          \"2012-05-15 21:00:00\",\n          \"2010-05-03 00:00:00\",\n          \"2011-03-23 21:00:00\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"L06_347\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.7870651583227748,\n        \"min\": -0.0183333333333333,\n        \"max\": 25.65833333333333,\n        \"num_unique_values\": 5057,\n        \"samples\": [\n          0.0909166666666666,\n          0.1191666666666666,\n          0.07125\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LS06_347\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.7928968526982662,\n        \"min\": 0.035,\n        \"max\": 25.65833333333333,\n        \"num_unique_values\": 4903,\n        \"samples\": [\n          0.4049166666666667,\n          0.2288333333333333,\n          0.0934999999999999\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LS06_348\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.047724144665189816,\n        \"min\": 0.0020833333333333,\n        \"max\": 1.3283333333333334,\n        \"num_unique_values\": 1365,\n        \"samples\": [\n          0.0414166666666666,\n          0.0152499999999999,\n          0.0444999999999999\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 12
        }
      ],
      "source": [
        "#loading dataset\n",
        "\n",
        "import pandas as pd\n",
        "from datetime import datetime as dt\n",
        "\n",
        "data_set = pd.read_csv('flowdata.csv')\n",
        "data_set\n"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data_set.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "OMje7-E_FDkb",
        "outputId": "bc1b0e83-9f43-4e00-f252-39efafda6adc"
      },
      "execution_count": 13,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                  Time   L06_347  LS06_347  LS06_348\n",
              "0  2009-01-01 00:00:00  0.137417  0.097500  0.016833\n",
              "1  2009-01-01 03:00:00  0.131250  0.088833  0.016417\n",
              "2  2009-01-01 06:00:00  0.113500  0.091250  0.016750\n",
              "3  2009-01-01 09:00:00  0.135750  0.091500  0.016250\n",
              "4  2009-01-01 12:00:00  0.140917  0.096167  0.017000"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-ecbbb558-e05d-41c8-80d6-48f28aef7fa3\" 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>Time</th>\n",
              "      <th>L06_347</th>\n",
              "      <th>LS06_347</th>\n",
              "      <th>LS06_348</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2009-01-01 00:00:00</td>\n",
              "      <td>0.137417</td>\n",
              "      <td>0.097500</td>\n",
              "      <td>0.016833</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2009-01-01 03:00:00</td>\n",
              "      <td>0.131250</td>\n",
              "      <td>0.088833</td>\n",
              "      <td>0.016417</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2009-01-01 06:00:00</td>\n",
              "      <td>0.113500</td>\n",
              "      <td>0.091250</td>\n",
              "      <td>0.016750</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2009-01-01 09:00:00</td>\n",
              "      <td>0.135750</td>\n",
              "      <td>0.091500</td>\n",
              "      <td>0.016250</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2009-01-01 12:00:00</td>\n",
              "      <td>0.140917</td>\n",
              "      <td>0.096167</td>\n",
              "      <td>0.017000</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-ecbbb558-e05d-41c8-80d6-48f28aef7fa3')\"\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-ecbbb558-e05d-41c8-80d6-48f28aef7fa3 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-ecbbb558-e05d-41c8-80d6-48f28aef7fa3');\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-8aab9aa3-f63c-45c6-b31d-3b94b2c40027\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-8aab9aa3-f63c-45c6-b31d-3b94b2c40027')\"\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-8aab9aa3-f63c-45c6-b31d-3b94b2c40027 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": "data_set",
              "summary": "{\n  \"name\": \"data_set\",\n  \"rows\": 11697,\n  \"fields\": [\n    {\n      \"column\": \"Time\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 11697,\n        \"samples\": [\n          \"2012-05-15 21:00:00\",\n          \"2010-05-03 00:00:00\",\n          \"2011-03-23 21:00:00\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"L06_347\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.7870651583227748,\n        \"min\": -0.0183333333333333,\n        \"max\": 25.65833333333333,\n        \"num_unique_values\": 5057,\n        \"samples\": [\n          0.0909166666666666,\n          0.1191666666666666,\n          0.07125\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LS06_347\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.7928968526982662,\n        \"min\": 0.035,\n        \"max\": 25.65833333333333,\n        \"num_unique_values\": 4903,\n        \"samples\": [\n          0.4049166666666667,\n          0.2288333333333333,\n          0.0934999999999999\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LS06_348\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.047724144665189816,\n        \"min\": 0.0020833333333333,\n        \"max\": 1.3283333333333334,\n        \"num_unique_values\": 1365,\n        \"samples\": [\n          0.0414166666666666,\n          0.0152499999999999,\n          0.0444999999999999\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "print(data_set.info)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "qjdqwJfKByxk",
        "outputId": "3d84361b-a3e5-41ac-e986-511a48533a9b"
      },
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<bound method DataFrame.info of                       Time   L06_347  LS06_347  LS06_348\n",
            "0      2009-01-01 00:00:00  0.137417  0.097500  0.016833\n",
            "1      2009-01-01 03:00:00  0.131250  0.088833  0.016417\n",
            "2      2009-01-01 06:00:00  0.113500  0.091250  0.016750\n",
            "3      2009-01-01 09:00:00  0.135750  0.091500  0.016250\n",
            "4      2009-01-01 12:00:00  0.140917  0.096167  0.017000\n",
            "...                    ...       ...       ...       ...\n",
            "11692  2013-01-01 12:00:00  1.710000  1.710000  0.129583\n",
            "11693  2013-01-01 15:00:00  1.420000  1.420000  0.096333\n",
            "11694  2013-01-01 18:00:00  1.178583  1.178583  0.083083\n",
            "11695  2013-01-01 21:00:00  0.898250  0.898250  0.077167\n",
            "11696  2013-01-02 00:00:00  0.860000  0.860000  0.075000\n",
            "\n",
            "[11697 rows x 4 columns]>\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data_set.plot()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 447
        },
        "id": "pGFCdgjV94WS",
        "outputId": "038f9809-1a03-4903-f428-e7f8658dfad9"
      },
      "execution_count": 15,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<Axes: >"
            ]
          },
          "metadata": {},
          "execution_count": 15
        },
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<Figure size 640x480 with 1 Axes>"
            ],
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAioAAAGdCAYAAAA8F1jjAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjcuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/bCgiHAAAACXBIWXMAAA9hAAAPYQGoP6dpAABjmElEQVR4nO3dd3wUZf4H8M9sTU8gkIRA6EgTFUEB24FyIMepnNg5RM87fypyKh56Kp4FFcWGBbAhYkHUO5EigvQmRZDQDS2BAEkghGRTN7s7z++PJZudLcnuZssk+bx9RXZnZmeefXbKd542khBCgIiIiEiFNJFOABEREZE3DFSIiIhItRioEBERkWoxUCEiIiLVYqBCREREqsVAhYiIiFSLgQoRERGpFgMVIiIiUi1dpBPgSpZlnDp1CvHx8ZAkKdLJISIiIh8IIVBaWor09HRoNMErB1FdoHLq1ClkZGREOhlEREQUgNzcXLRr1y5o61NdoBIfHw/A/kUTEhIinBoiIiLyhclkQkZGhuM6HiyqC1RqqnsSEhIYqBARETUywW62wca0REREpFoMVIiIiEi1GKgQERGRaqmujQoRETUtQghYrVbYbLZIJ4UaSK/XQ6vVhnWbDFSIiChkqqurkZeXh4qKikgnhYJAkiS0a9cOcXFxYdsmAxUiIgoJWZaRnZ0NrVaL9PR0GAwGDuTZiAkhcObMGZw4cQLdunULW8kKAxUiIgqJ6upqyLKMjIwMxMTERDo5FAStW7dGTk4OLBZL2AIVNqYlIqKQCuZw6hRZkSgR495DREREqsVAhYiIiFSLgQoRERGpFgMVIiIiF/fccw9GjRrlcV5VVRXGjx+P5ORkxMXFYfTo0SgoKHBb7rPPPsNFF12EqKgopKSkYPz48T5tOysrC0OGDEFqaiqioqLQuXNnTJ48GRaLxePy8+fPhyRJbumVJMnj3+uvv+5TOtSCvX6IyC8Hti6H6fgeDLj1X5FOClFEPPbYY/jxxx/x3XffITExEQ8//DBuvvlmbNq0ybHMW2+9hTfffBOvv/46BgwYgPLycuTk5Pi0fr1ej7vvvhuXXnopkpKSsGvXLvzjH/+ALMt45ZVXFMvm5OTgX//6F66++mq39eTl5Sne//TTT7jvvvswevRo/790BDFQISK/9PzpNgDA3jYX4MKrboxwaqgxEUKg0hKZ0Wmj9dqg9FgpKSnB7NmzMW/ePFx77bUAgDlz5qBnz57YsmULBg4ciHPnzmHy5MlYvHgxrrvuOsdnL7roIp+20blzZ3Tu3NnxvkOHDli7di02bNigWM5ms2HMmDF44YUXsGHDBhQXFyvmp6WlKd4vXLgQQ4YMUay7MWCgQkQBKc87FOkkUCNTabGh13+WR2Tb+18cjhhDwy95O3bsgMViwdChQx3TevTogfbt22Pz5s0YOHAgVqxYAVmWcfLkSfTs2ROlpaW44oor8OabbyIjI8PvbR4+fBjLli3DzTffrJj+4osvIiUlBffdd59bEOOqoKAAP/74I+bOnev39iONbVSIKEAi0gkgCrv8/HwYDAYkJSUppqempiI/Px8AcPToUUc1zfTp0/Hf//4XRUVF+OMf/4jq6mqft3XFFVcgKioK3bp1w9VXX40XX3zRMW/jxo2YPXs2Pv74Y5/WNXfuXMTHx7sFO40BS1SIKDCCgQr5J1qvxf4Xh0ds2+EiyzIsFgveffddDBs2DADw9ddfIy0tDWvWrMHw4b7lwTfffIPS0lLs2rULkyZNwhtvvIEnnngCpaWlGDt2LD7++GO0atXKp3V9+umnGDNmDKKiogL+XpHCQIWIAsRAhfwjSVJQql8iKS0tDdXV1SguLlaUqhQUFDjahLRp0wYA0KtXL8f81q1bo1WrVjh+/LjP26qpJurVqxdsNhvuv/9+PP744zhy5AhycnJwww03OJaVZRkAoNPpkJWVhS5dujjmbdiwAVlZWfjmm2/8/8Iq4FfVz9SpU3HZZZchPj4eKSkpGDVqFLKyshTLDB482K0r1AMPPBDURBORCrBEhZqhfv36Qa/XY9WqVY5pWVlZOH78OAYNGgQAuPLKKx3TaxQVFaGwsBAdOnQIaLs1pTSyLKNHjx7Ys2cPMjMzHX833ngjhgwZgszMTLd2MLNnz0a/fv1w8cUXB7TtSPMrtF23bh3Gjx+Pyy67DFarFU8//TSGDRuG/fv3IzY21rHcP/7xD0VdGh9GRdQUMVChpq2kpASZmZmKacnJybjvvvswceJEtGzZEgkJCZgwYQIGDRqEgQMHAgAuuOAC3HTTTXjkkUfw0UcfISEhAU899RR69OiBIUOG1Lvdr776Cnq9Hn369IHRaMT27dvx1FNP4fbbb4der4der8eFF16o+ExN6Y7rdJPJhO+++w5vvvlm4BkRYX4FKsuWLVO8/+yzz5CSkoIdO3bgmmuucUyPiYlx6xZFRE0MS1SoiVu7di369u2rmHbffffh/fffh0ajwejRo2E2mzF8+HDMnDlTsdznn3+Oxx57DCNHjoRGo8Ef/vAHLFu2DHq9vt7t6nQ6vPbaazh48CCEEOjQoQMefvhhPPbYY35/h/nz50MIgTvvvNPvz6qFJETgZ5vDhw+jW7du2LNnjyOKGzx4MPbt2wchBNLS0nDDDTfg2Wef9VqqYjabYTabHe9NJhMyMjJQUlKChISEQJNGRKHyfCIAYEv3JzHwzqcjnBhSs6qqKmRnZ6NTp06NshEnuavrNzWZTEhMTAz69TvgVk2yLOPRRx/FlVdeqShquuuuu9ChQwekp6dj9+7dePLJJ5GVlYXvv//e43qmTp2KF154IdBkEBERURMWcKAyfvx47N27Fxs3blRMv//++x2v+/TpgzZt2uC6667DkSNHFK2Qazz11FOYOHGi431NiQoREVFTNGLECK8DtD399NN4+mmWVDoLKFB5+OGHsWTJEqxfvx7t2rWrc9kBAwYAsFcTeQpUjEYjjEZjIMkgIiJqdD755BNUVlZ6nNeyZcswp0b9/ApUhBCYMGECFixYgLVr16JTp071fqamxXRNv3IiIqLmrG3btpFOQqPiV6Ayfvx4zJs3DwsXLkR8fLxjuODExERER0fjyJEjmDdvHv70pz8hOTkZu3fvxmOPPYZrrrnG54cxEREREdXwK1CZNWsWAHvPHmdz5szBPffcA4PBgJUrV2L69OkoLy9HRkYGRo8ejcmTJwctwURERNR8+F31U5eMjAysW7euQQkiIiIiqsGnJxMREZFqMVAhIiIi1WKgQkRERKrFQIWIiMjFPffcg1GjRnmct2vXLtx4441ISUlBVFQUOnbsiNtvvx2nT592LHP8+HGMHDkSMTExSElJwaRJk2C1WhXrMZvNeOaZZ9ChQwcYjUZ07NgRn376qU/p+/7779G/f38kJSUhNjYWl1xyCb744guvyz/wwAOQJAnTp093TFu7di0kSfL49+uvv/qUjnAIeGRaIiKi5ubMmTO47rrr8Oc//xnLly9HUlIScnJysGjRIpSXlwMAbDYbRo4cibS0NPzyyy/Iy8vD3XffDb1ej1deecWxrttuuw0FBQWYPXs2unbtiry8PMiy7FM6WrZsiWeeeQY9evSAwWDAkiVLcO+99yIlJQXDhw9XLLtgwQJs2bIF6enpiulXXHEF8vLyFNOeffZZrFq1Cv379w8ke0KCgQoREYWHEIClIjLb1scAktTg1WzatAklJSX45JNPoNPZL6GdOnXCkCFDHMv8/PPP2L9/P1auXInU1FRccsklmDJlCp588kk8//zzMBgMWLZsGdatW4ejR486RqPt2LGjz+lwHSbkkUcewdy5c7Fx40ZFoHLy5ElMmDABy5cvx8iRIxWfMRgMSEtLc7y3WCxYuHAhJkyYACkIeRUsDFSIiCg8LBXAK+n1LxcKT58CDLENXk1aWhqsVisWLFiAW265xeMFffPmzejTpw9SU1Md04YPH44HH3wQ+/btQ9++fbFo0SL0798f06ZNwxdffIHY2FjceOONmDJlCqKjo/1KkxACq1evRlZWFl577TXHdFmWMXbsWEyaNAm9e/eudz2LFi3C2bNnce+99/q1/VBjoEJEROSjgQMH4umnn8Zdd92FBx54AJdffjmuvfZa3H333Y7AJD8/XxGkAFDMA4CjR49i48aNiIqKwoIFC1BYWIiHHnoIZ8+exZw5c3xKS0lJCdq2bQuz2QytVouZM2fij3/8o2P+a6+9Bp1Oh3/+858+rW/27NkYPnx4vc/wCzcGKkREFB76GHvJRqS2HSQvv/wyJk6ciNWrV2Pr1q344IMP8Morr2D9+vXo06ePT+uQZRmSJOGrr75CYmIiAOCtt97CLbfcgpkzZ/pUqhIfH4/MzEyUlZVh1apVmDhxIjp37ozBgwdjx44deOedd/Dbb7/5VI1z4sQJLF++HN9++61P6Q8n9vohIqLwkCR79Usk/oLc5iI5ORm33nor3njjDRw4cADp6el44403ANirhwoKChTL17yvaRPSpk0btG3b1hGkAEDPnj0hhMCJEyd8SoNGo0HXrl1xySWX4PHHH8ctt9yCqVOnAgA2bNiA06dPo3379tDpdNDpdDh27Bgef/xxj21h5syZg+TkZNx4441+50WoMVAhIiJqAIPBgC5dujh6/QwaNAh79uxRdFdesWIFEhIS0KtXLwDAlVdeiVOnTqGsrMyxzMGDB6HRaAKuepFlGWazGQAwduxY7N69G5mZmY6/9PR0TJo0CcuXL1d8TgiBOXPmOHomqQ2rfoiIiDwoKSlBZmamYtqePXuwfPly3HHHHbjgggsghMDixYuxdOlSR9uSYcOGoVevXhg7diymTZuG/Px8TJ48GePHj4fRaAQA3HXXXZgyZQruvfdevPDCCygsLMSkSZPwt7/9zadqn6lTp6J///7o0qULzGYzli5dii+++MLx8ODk5GQkJycrPqPX65GWlobu3bsrpq9evRrZ2dn4+9//HmhWhRQDFSIiIg/Wrl2Lvn37KqYNGTIEXbt2xeOPP47c3FwYjUZ069YNn3zyCcaOHQsA0Gq1WLJkCR588EEMGjQIsbGxGDduHF588UXHeuLi4rBixQpMmDAB/fv3R3JyMm677Ta89NJLPqWtvLwcDz30EE6cOIHo6Gj06NEDX375JW6//Xa/v+fs2bNxxRVXoEePHn5/NhwkUd8jkcPMZDIhMTERJSUlSEhIiHRyiMjV8/Y69S3dn8TAO5+OcGJIzaqqqpCdnY1OnTohKioq0smhIKjrNw3V9ZttVIiIiEi1GKgQERGpTFxcnNe/DRs2RDp5YcU2KkRERCrj2ojXWdu2bcOXEBVgoEJERKQyXbt2jXQSVINVP0RERKRaDFSIiIhItRioEBERkWoxUCEiIiLVYqBCREREqsVAhYiIiFSLgQoREZGLe+65B6NGjfI4b9euXbjxxhuRkpKCqKgodOzYEbfffrviacnHjx/HyJEjERMTg5SUFEyaNAlWq1WxHrPZjGeeeQYdOnSA0WhEx44d8emnn/qUvu+//x79+/dHUlISYmNjcckll+CLL77wuvwDDzwASZIwffp0xfSDBw/ipptuQqtWrZCQkICrrroKa9as8SkN4cJxVIiIiHx05swZXHfddfjzn/+M5cuXIykpCTk5OVi0aBHKy8sBADabDSNHjkRaWhp++eUX5OXl4e6774Zer8crr7ziWNdtt92GgoICzJ49G127dkVeXh5kWfYpHS1btsQzzzyDHj16wGAwYMmSJbj33nuRkpKC4cOHK5ZdsGABtmzZgvT0dLf1/PnPf0a3bt2wevVqREdHY/r06fjzn/+MI0eOIC0trQE5FTwMVIiIKCyEEKi0VkZk29G6aEiS1OD1bNq0CSUlJfjkk0+g09kvoZ06dcKQIUMcy/z888/Yv38/Vq5cidTUVFxyySWYMmUKnnzySTz//PMwGAxYtmwZ1q1bh6NHj6Jly5YAgI4dO/qcjsGDByveP/LII5g7dy42btyoCFROnjyJCRMmYPny5Rg5cqTiM4WFhTh06BBmz56Niy66CADw6quvYubMmdi7dy8DFSIial4qrZUYMG9ARLa99a6tiNHHNHg9aWlpsFqtWLBgAW655RaPwc/mzZvRp08fpKamOqYNHz4cDz74IPbt24e+ffti0aJF6N+/P6ZNm4YvvvgCsbGxuPHGGzFlyhRER0f7lSYhBFavXo2srCy89tprjumyLGPs2LGYNGkSevfu7fa55ORkdO/eHZ9//jkuvfRSGI1GfPjhh0hJSUG/fv38SkMoMVAhIiLy0cCBA/H000/jrrvuwgMPPIDLL78c1157Le6++25HYJKfn68IUgAo5gHA0aNHsXHjRkRFRWHBggUoLCzEQw89hLNnz2LOnDk+paWkpARt27aF2WyGVqvFzJkz8cc//tEx/7XXXoNOp8M///lPj5+XJAkrV67EqFGjEB8fD41Gg5SUFCxbtgwtWrTwO29ChYEKERGFRbQuGlvv2hqxbQfLyy+/jIkTJ2L16tXYunUrPvjgA7zyyitYv349+vTp49M6ZFmGJEn46quvkJiYCAB46623cMstt2DmzJk+larEx8cjMzMTZWVlWLVqFSZOnIjOnTtj8ODB2LFjB9555x389ttvXqu8hBAYP348UlJSsGHDBkRHR+OTTz7BDTfcgF9//RVt2rTxPVNCiIEKERGFhSRJQal+UYPk5GTceuutuPXWW/HKK6+gb9++eOONNzB37lykpaVh27ZtiuULCgoAwNHuo02bNmjbtq0jSAGAnj17QgiBEydOoFu3bvWmQaPROB5eeMkll+DAgQOYOnUqBg8ejA0bNuD06dNo3769Y3mbzYbHH38c06dPR05ODlavXo0lS5bg3LlzSEhIAADMnDkTK1aswNy5c/Hvf/+7YZkUJOyeTERE1AAGgwFdunRx9PoZNGgQ9uzZo+iuvGLFCiQkJKBXr14AgCuvvBKnTp1CWVmZY5mDBw9Co9GgXbt2AaVDlmWYzWYAwNixY7F7925kZmY6/tLT0zFp0iQsX74cAFBRUQHAHvA402g0Pvc+CgeWqBAREXlQUlKCzMxMxbQ9e/Zg+fLluOOOO3DBBRdACIHFixdj6dKljrYlw4YNQ69evTB27FhMmzYN+fn5mDx5MsaPHw+j0QgAuOuuuzBlyhTce++9eOGFF1BYWIhJkybhb3/7m0/VPlOnTkX//v3RpUsXmM1mLF26FF988QVmzZoFwF7ik5ycrPiMXq9HWloaunfvDsAeULVo0QLjxo3Df/7zH0RHR+Pjjz9Gdna2Ww+hSGKgQkRE5MHatWvRt29fxbQhQ4aga9euePzxx5Gbmwuj0Yhu3brhk08+wdixYwEAWq0WS5YswYMPPohBgwYhNjYW48aNw4svvuhYT1xcHFasWIEJEyagf//+SE5Oxm233YaXXnrJp7SVl5fjoYcewokTJxAdHY0ePXrgyy+/xO233+7z92vVqhWWLVuGZ555Btdeey0sFgt69+6NhQsX4uKLL/Z5PaEmCSFEpBPhzGQyITExESUlJY46MyJSkeftdepbuj+JgXc+HeHEkJpVVVUhOzsbnTp1QlRUVKSTQ0FQ128aqus326gQERGRajFQISIiUpm4uDivfxs2bIh08sKKbVSIiIhUxrURr7O2bduGLyEqwECFiIhIZWrGRyFW/RARUYiprM8GNUAkfksGKkREFBJ6vR5A7cBi1PhVV1cDsHfBDhdW/RARUUhotVokJSU5RmiNiYnx+twZUj9ZlnHmzBnExMRApwtf+MBAhYiIQqbm2TbOw8lT46XRaNC+ffuwBpwMVIiIKGQkSUKbNm2QkpICi8US6eRQAxkMBrdnA4UaAxUiIgo5rVYb1nYN1HSwMS0RERGpFgMVIiIiUi0GKkRERKRaDFSIiIhItRioEBERkWoxUCEiIiLVYqBCREREqsVAhYiIiFSLgQoRERGpll+BytSpU3HZZZchPj4eKSkpGDVqFLKyshTLVFVVYfz48UhOTkZcXBxGjx6NgoKCoCaaiIiImge/ApV169Zh/Pjx2LJlC1asWAGLxYJhw4ahvLzcscxjjz2GxYsX47vvvsO6detw6tQp3HzzzUFPOBERETV9fj3rZ9myZYr3n332GVJSUrBjxw5cc801KCkpwezZszFv3jxce+21AIA5c+agZ8+e2LJlCwYOHBi8lBMREVGT16A2KiUlJQCAli1bAgB27NgBi8WCoUOHOpbp0aMH2rdvj82bNzdkU0RERNQMBfz0ZFmW8eijj+LKK6/EhRdeCADIz8+HwWBAUlKSYtnU1FTk5+d7XI/ZbIbZbHa8N5lMgSaJiIiImpiAS1TGjx+PvXv3Yv78+Q1KwNSpU5GYmOj4y8jIaND6iIiIqOkIKFB5+OGHsWTJEqxZswbt2rVzTE9LS0N1dTWKi4sVyxcUFCAtLc3jup566imUlJQ4/nJzcwNJEhERETVBfgUqQgg8/PDDWLBgAVavXo1OnTop5vfr1w96vR6rVq1yTMvKysLx48cxaNAgj+s0Go1ISEhQ/BFRYyAinQAiagb8aqMyfvx4zJs3DwsXLkR8fLyj3UliYiKio6ORmJiI++67DxMnTkTLli2RkJCACRMmYNCgQezxQ0RERH7zK1CZNWsWAGDw4MGK6XPmzME999wDAHj77beh0WgwevRomM1mDB8+HDNnzgxKYolITaRIJ4CImgG/AhUh6i/qjYqKwowZMzBjxoyAE0VEREQE8Fk/RBQwtlEhotBjoEJERESqxUCFiALENipEFHoMVIiIiEi1GKgQUYDYRoWIQo+BChEREakWAxUiChDbqBBR6DFQISIiItVioEJEAWIbFSIKPQYqREREpFoMVIgoQGyjQkShx0CFiIiIVIuBChEFiG1UiCj0GKgQERGRajFQIaIAsY0KEYUeAxUiIiJSLQYqRBQgtlEhotBjoEJERESqxUCFiALENipEFHoMVIiIiEi1GKgQUYDYRoWIQo+BChEREakWAxUiChDbqBBR6DFQISIiItVioEJEAWIbFSIKPQYqREREpFoMVIgoQGyjQkShx0CFiIiIVIuBChEFiG1UiCj0GKgQERGRajFQIaIAsY0KEYUeAxUiIiJSLQYqRBQgtlEhotBjoEJERESqxUCFiALENipEFHoMVIiIiEi1GKgQUYDYRoWIQo+BChEREakWAxUiChDbqBBR6DFQISIiItVioEJEAWIbFSIKPQYqROQzIcuRTgIRNTMMVIgoQGyjQkShx0CFiIiIVIuBChEFiG1UiCj0GKgQkc+EYHBCROHFQIWIAsQ2KkQUegxUiIiISLUYqBCRz1j1Q0ThxkCFiIiIVIuBChEREakWAxUi8pkQHJmWiMKLgQoRERGpFgMVIiIiUi0GKkRERKRafgcq69evxw033ID09HRIkoQffvhBMf+ee+6BJEmKv+uvvz5Y6SWiCGL3ZCIKN78DlfLyclx88cWYMWOG12Wuv/565OXlOf6+/vrrBiWSiIiImiedvx8YMWIERowYUecyRqMRaWlpASeKiIiICAhRG5W1a9ciJSUF3bt3x4MPPoizZ896XdZsNsNkMin+iEidWPVDROEW9EDl+uuvx+eff45Vq1bhtddew7p16zBixAjYbDaPy0+dOhWJiYmOv4yMjGAniYhCQJL4UEIiCj2/q37qc8cddzhe9+nTBxdddBG6dOmCtWvX4rrrrnNb/qmnnsLEiRMd700mE4MVokaApStEFA4h757cuXNntGrVCocPH/Y432g0IiEhQfFHROrEkWmJKNxCHqicOHECZ8+eRZs2bUK9KSIKI1b9EFE4+F31U1ZWpigdyc7ORmZmJlq2bImWLVvihRdewOjRo5GWloYjR47giSeeQNeuXTF8+PCgJpyIiIiaPr8Dle3bt2PIkCGO9zXtS8aNG4dZs2Zh9+7dmDt3LoqLi5Geno5hw4ZhypQpMBqNwUs1EUUc26gQUTj4HagMHjy4zhPU8uXLG5QgIlIvBidEFG581g8RBYRtVIgoHBioEBERkWoxUCEi37Hqh4jCjIEKERERqRYDFSIiIlItBipE5DP2+iGicGOgQkRERKrFQIWIiIhUi4EKEfmMDyUkonBjoEJEgeGAb0QUBgxUiCgwbFhLRGHAQIWIiIhUi4EKEfmM3ZOJKNwYqBBRYNhGhYjCgIEKEQWGpStEFAYMVIjIZ6z6IaJwY6BCRIFh1Q8RhQEDFSIiIlItBipE5DNW/RBRuDFQISIiItVioEJERESqxUCFiIiIVIuBChH5jG1UiCjcGKgQERGRajFQISIiItVioEJEPmPVDxGFGwMVIiIiUi0GKkRERKRaDFSIyHes+iGiMGOgQkQB4kMJiSj0GKgQUYBYukJEocdAhYiIiFSLgQoR+U7IkU4BETUzDFSIKEBso0JEocdAhYgCxDYqRBR6DFSIyGccmZaIwo2BChEFiFU/RBR6DFSIiIhItRioEJHPWPVDROHGQIWIiIhUi4EKERERqRYDFSIiIlItBipE5DPBkWmJKMwYqBAREZFqMVAhIiIi1WKgQkQ+Y/dkIgo3BipEFCAGLUQUegxUiIiISLUYqBCRz1j1Q0ThxkCFiIiIVIuBChEFhqUrRBQGDFSIyA8MTogovBioEFHErDt4BodPl0Y6GUSkYrpIJ4CImqcDeSaM+3QbACDn1ZERTg0RqZXfJSrr16/HDTfcgPT0dEiShB9++EExXwiB//znP2jTpg2io6MxdOhQHDp0KFjpJSKVaGgPoMP55/Cd4Xm8qJsTpBQRUVPkd6BSXl6Oiy++GDNmzPA4f9q0aXj33XfxwQcfYOvWrYiNjcXw4cNRVVXV4MQSUYTJwWujknJ6My7THMTduhVBWycRNT1+V/2MGDECI0aM8DhPCIHp06dj8uTJuOmmmwAAn3/+OVJTU/HDDz/gjjvuaFhqiajpENZIp4CIGoGgNqbNzs5Gfn4+hg4d6piWmJiIAQMGYPPmzR4/YzabYTKZFH9E1PRJ7N5MRD4IaqCSn58PAEhNTVVMT01NdcxzNXXqVCQmJjr+MjIygpkkIgoioeiezECDiEIv4t2Tn3rqKZSUlDj+cnNzI50kIiIiUomgBippaWkAgIKCAsX0goICxzxXRqMRCQkJij8iag5YIkNE9QtqoNKpUyekpaVh1apVjmkmkwlbt27FoEGDgrkpIooAPpSQiMLN714/ZWVlOHz4sON9dnY2MjMz0bJlS7Rv3x6PPvooXnrpJXTr1g2dOnXCs88+i/T0dIwaNSqY6SaiSGPQQkRh4Hegsn37dgwZMsTxfuLEiQCAcePG4bPPPsMTTzyB8vJy3H///SguLsZVV12FZcuWISoqKnipJqImgIEOEdXP70Bl8ODBdRb/SpKEF198ES+++GKDEkZEREQU8V4/qlF5DrBURjoVRKomhBy0dXEcFSLyBQMVwB6kvNYReOOCSKeEqBFhoEFEocdABQBO7bT/a+aouERERGrCQIWIfMbuyUQUbgxUiIiISLUYqAAoN9sinQSixqfBpSssnSGi+jFQAXC0sCzSSSBqHFj1Q0RhxkAFACBFOgFEzRCDHiKqHwMVIiIiUi0GKgBYokJERKRODFSIyGfKkWkbVnXDkWmJyBcMVAAWqBAREakUAxUiiggOHkdEvmCgAhaoEPmKsUXzcrCgFPtP8dEiFFm6SCeAiBqpBkYtksSoR82sNhnD3l4PANj7wnDEGXm5oMhgiQoASCxTISJyZpVrA8lz5dURTAk1dwxUiMh3rPshojBjoEJEkcGgh4h8wECFiALUwEDDKVBhDyAi8oaBChFFhMS2YUTkAzbjJiKfharkQwi2aVejazS7oIcVwJBIJ4WaMQYqABQjqfCMSRQmrO5RNZsFnxteAwCcrLoPQExk00PNFqt+XLGunMg3DT1WnNuoNDApFAKytfZ1VWnk0kHNHgMVoiausrwUNqu1/gV9Ite/SADYmJaIvGGgArjU/ITmREwUCSVFZxD9ejvkTO0f6aS4YQUrEfmCgQoA5SmTd3bUdBzesgQA0MWWHeGUuBOs+lE1FnKRWjBQcSFkHp1E3iiOD17JmhH+1hQ5DFRc8HCkpkTVHdhcOtuRugieDUklGKgAkJzOmGyjQkREpB4MVADlbSdv7Yi8CuZdtuIGgXfvqsNTIakFAxUXPDaJfNPQY8U5OOFFkYi8YaDiguM5EBGxlIvUg4GKC7ZRoSZF1a1piYjqx0AFcDmZ8y6CyCsG8mF1tsyMJbtPodoa/nwXMn9rUgcGKi5Y80PkoyAGLTzuPPvLzF/w8LydeH/N4UgnhShiGKi44hmTKOzYHsKz40UVAIDle/PDvm3+JqQWDFTgMoA+AxVqQqQgt1EJ2fHB4051Nh4qjHQSiAAwUCGiiHEeaJGBitqs/f10pJNABICBihv2+iHy7mzOXqd3QQwuGKgQkRcMVFzwzo7Iuz6bJoRkvWwPoUb8TUgdGKgAiu7JbnFKpAOXstORTwM1WiLIh7hOYokjEYUXA5W6fDsOeCEJOHMwMtvPWga80Q1Y8H+R2T5RmHDMjrpFZNy+RnSDlF9ShRlrDuNsmTnSSaEQYKDiQtFGZf8P9n9nXBaRtGD9NPu/u7+JzPaJ6iAFs4kKqxlUTVL57/PX2Vvx+vIsPDxvZ6STQiHAQAUA+BRXoshqRHfvzYVzcKL28+Lh02UAgM1Hz0Y4Jer1+/ZVKMzPjXQyAqKLdALUhudLakqCPY5KMAl2TyYKi9+3/oweP91qf/N8SWQTEwCWqLiQVHTCLKm0RjoJRCGj9uqE5i7aVhrpJFCQnNu3ItJJaBAGKq5UFKjkm6oinQQirwSC2ABWVs9xR3bDir6MdBIoWFR0XQsEAxUoW9SracA3AfUW2xM1lHL/btwn0qbIKPNGidSBgQoRRZyabhCISF0YqLhgoz5qSiSpcRziPO7Uh79IE6LiRvW+aBxnsTDiCZOalFCeoHisNHFO3ZP5U1MEMVABlDXlKjoiG3cMTOQ79Rx11Bi1xjncr12MFjBFOikUAhxHBYDyNKmeUyYb01KzoaIbBHKn9l/nc8Or6KnJxVWavQDujHRyKMhYogLXMEXthySRHxpL3TQb01ID9NTYR1y9RrsnwilRqUZ+I8BABVD+iCo6X4pGco0h9VJ1nCJxZFo1cx78kr8PRVLQA5Xnn38ekiQp/nr06BHszQSXcH7JA7KpKz13Gr99/iROHzsQ6aSQA487VWOgQhEUkjYqvXv3xsqVK2s3olN7Uxh1tlFR881wY3b007/j0tJ1KD36OfB8XqSTE2LqLTR1vvbxOqhu/HkokkISQeh0OqSlpYVi1SGhOElyKO8mr32p/VHw8aiIcErIgZGKqvG5TBRJIbndOnToENLT09G5c2eMGTMGx48f97qs2WyGyWRS/IWf8PAq8tjrJzTU9BuHnKrHUXE+7lTUOIzOYxsVUoegByoDBgzAZ599hmXLlmHWrFnIzs7G1VdfjdJSz0/inDp1KhITEx1/GRkZwU6SX3hAEkUAj7s6SapuFU0UWkEPVEaMGIFbb70VF110EYYPH46lS5eiuLgY3377rcfln3rqKZSUlDj+cnNzg50kH6izjQqFRnMqqZKcvquQ1VVqoYhNGKjUKeI3UJHePjVQ4/79Qt7KNSkpCRdccAEOHz7scb7RaITRaAx1MuqkbNSnnpN5c7qghhPzFSgpLsKZ3IPo2mdgxNLA2wMi8kXIuwSUlZXhyJEjaNOmTag3FTBFcMIzJjUlXsYqsUzvi67/G459vyxtwMobdrBIgqGKryJS9cNxVEglgh6o/Otf/8K6deuQk5ODX375BX/5y1+g1Wpx552NY1hjNY2jwvt+Cibni00rFAMASjMXRCg1LqEJe9sRhVDjvpoEPVA5ceIE7rzzTnTv3h233XYbkpOTsWXLFrRu3TrYmwoaiQM6UCO292QJhr32I5bsPuU2r9478Uju7zzWGhH+VhQ5QW+jMn/+/GCvMqzUdDiyLUVoNLV8nTd3Bn6ufg3vfPsX4KLPvC7nqf1VZMfHcK5aUE/bMLJrWkcJNWbqHbYyjBQ15SyCpkZmYvWHAIBHdHVX43hsZ9CQUo0GloiIOt6RulSYrZFOAjWAVF0W6SQ0CAMVNzxhNnVNrUSlTvU++C9y+7ukKFGJWDLIBzPXeu61SY1DbPHvkU5CgzBQAfjQEWrCVHyIO/cq4Q2C6jj/Jln5ngfspMahrHXfSCehQVR8FiOiYPLYDiSibUN4g6BmkuI1f5/GTIpVb2cWXzBQgfI5I2zU1/Q1q6ofJ8EfC8N9fdsWvIv9W5YFsCoed2pTV3CyK7cYuUV8qGdjpLYRqn0R8pFpGxt1DWzUPC+o5J+6Aq9wjhP2+/ZVuHzXs8AuAANLvC5ntcl4fvE+tM8txoCaiao67tQn0mcC56Dl2Nly3DRjEwAg59WRkUoSBUiIxnerxhIVQLWDTakzVY1f4ztMG8A5UvHY6yd4d1dlpw75tNwPmafw5ZbjOFRQ+6R07uvq4y12PJDH9iqNmbpuxn3DEhUXnn7EfXIH9I5AWoiCqaEnqIITR5Ba1wI+Ft8UFZvwqX4aUqVzzolrUNoo+CotNsfrBDhX8/C3aswaY/MGlqjApceBhx+xApF9aCJRMDR0wLeqMpfqHNf1+Rhs9MhfiGu1meitOebvRymMyqosjtcv6T+NYEqouWOg4sLT+VIToTsIEYkHkTUDTa3qp87vE8wh9CWX00WA0YXe5qERZiO8y2tOumtOOL1rWsdPc8Oqn8aqEf5wRL6QnO5Fgj/gm/Kz1vKigNck8xhsRATScBZliI50QshHUr0DP6obS1RceBpCP9agjUBKiIKgnhNUq5J9yNq+2t9VnV+hSynIuWx/U+e0Klv9C5EqGCsLsCVqAvZG/T3SSaEAsI1KI6UcFdP9R9RIkYlAWcAaGs21Ss1ToNJZzkH3JX9BeWlxACt0OVYM8YElDI3zLq+p81blnVi0O8wpoWBqjMcaAxVfROh3bWptKUi9yk3n6l1GcgnwJJcTXlTHywJPgI93eVUWG2auPYwDeab6F6YG+aN2h8fpwRylVgiBo2fKIKt0iIgmw+nYPbJzXQQTEhgGKnA54XqINjl8dFPTfALAoNZNuzWmdQkunLcly5CtVhTmHvRp1b4WR3+w7gheX3YAI97Z4NPyTUVTLQScte4Irn1zHTo/vRRVFlb/hU7tDtT75zsjmI7AMFBxoaYnzLJEJTSaWtjp635SV6ASWL11XesT2P/Wn9Bq9mXYs/Kretck+zis9+nsvcg03o/x2h98TWSjsmf9Qmx/azRKzhYopjfC0nqfTFv2O67V/IZhml8xb+vxSCeHVIqBCpQncE8nc5aokJoZUe19ZhBvxSXXgKiOq6cs23BhxVYAgHbbrPpX7mOgdHvRh0iUKjBJ/61Pyzc2fVbfjf6mlcj64tFIJyUsHtIuwqeGN/CR4W20zN8Y6eQ0XY28SI6BCtR7h924dy0KlyT4OKR5sG/L6wgu/K1mYvdkpZjKU4r3jfw649UT+m8cr1NL90YwJaRmDFTg2ijQ0/NQIlX1QwCAM1nAf++z/xsEzalKTdEAtoHdEiWNa2NaHwMVX46fRvhEV2o4m2g+x2JkNe58ZqACZUDg6U4wUiPTNgumvPovUnNGAHv/C8y7LSibbNyHbOCC3y1RuT7nmEj2c1wUXx8931y7ljdVNudLEE+z5AUDFUBxx+f5XM4jKCQO/gy81QP47u66l6s4a//3XE5QSreaVYlKUL9rPb1+FPNqfyfXNl6eUtQYB6GihlMei9wHQqaRB/gMVFwF466zoggoL2z4epq6X961/3tgse+f+WRog3+j5hSo1DcyrX+rchua1uuy/m7L9+Wbx2/nOkaNmgQ3ac3j94w4lx9NtjWuruAMVACgnpFp/SpRkWVgWifg9S5AtYeHr/mFB7Gbk9trS1jIL0Evtain149/q+LddLOn3tisySl/sS12LJ0d6WT4jIEKfOme7IfT+2pfm055X84HsusAWxQUPB+686lEw21k2uD1+hHCt8Cm+fx23tv/RF4QR6YNyVrJnTJ346VK9Ns2MUJp8R+vhD6o64TsSnx/v/O74CeGGkxV5/xQC+VTU30OVJTb9dQgVrb5lrZm9ds5UXFNUNBwvKoQauQ7EAMVVw38QSucn5nS4LYU/HlCoVn1HKmntNDrx2QZmdOux87XR3pdxv3CUru/1jXSrKfc/3lfnm/pcvr07hPFPn2mcWrcFxZfKdqLNfKLqbo17rzllfD0AfT9ZXzt+waOTFtW7XyCZqPPkGBj2gD5nm+F+cdxScVm9C3fiJ0/fwnAQ/VDXb9DXfM8BIo52Ud8S5jTRx/64EffPtMIueaQmmLrH3aejHQSyF+NPAhkoPLdvYq3Df05W8pFTitr6EPgGvZxtbPYQtSAspEflBHhkmfOpS81gbzk1maqru7Jdf227jv2E5ov6kuh22c/0Ezz8TMUTKWlPo6E7APlTQOP21AJ/hhK4cVAxax8XHxDn/Wjh8V5bYGm6vynm3akknO2ob2i3J1aNAUVL3eE+fThoK+70ZMb9lDCY2vnKt7X1XbLuerHbS/2UDzQEia3afW5UJPj92caDRVfWN42+PDsJh8Jr28ouBp35jJQceNfoFL5zX2o/PIuzycWVlHUqdoaWF/+qjo+l/7bG4ixFuPYN5PqWEPTzldvRJ3jntT92ex9WzHg6Hu+b8vPEhVfbwaa+jFRozk2LBUc8C10VBz4+qLZByqyzaqc4McPaq0sRfSB/yL68I+oKrQ/orxEk+iYb2nooDqeKqZ3fwf88BBgs7jPa8zO+thGAUCFuf7vXma2ep3XuA9ZP/m6P9ezXEl+tts09xKV2vd1PuvHw37ta/jRPMIUdQpF9UFzCTwjr3Gf9Zp9oKIpL1C896fqx/nO/lxFFQDgjDbVMc285vUGpc1jr5/v/w5kfgXs/LJB63YoOw2cygzOuvykOEm9d2lE0tCc1HWhcR3HxHUUWkmj9fAhZaCijE38LVHh3bSS62MHIn9B/z0/eG1TPFHzaLyNXiPPW12kE6A2HovHffiRhYf6/7hDCxuYljpOThVBGqL/jW72f/9vA9DmouCsM+Tq/z3qOulpm+lFsa7gwdP+68zThdItgHfO87rW56FERSv5WPWjpu4vIaTGb2m2huK4cRrnJwRrpxqNO3ebfYmKK0+lJ95KVDQeT5pBPMXUeVIO8qns2C/BXV8oNeCYs+XtRYbctLpX7pY7+bRcnSUq9WWqp33RdX3OY7bUsb4QHzWqsf+UCXd9vAU7j5+rf2FXjfwOODDq+s42q9Xnp3qrXiPfnxiouPB00+ntJKq8yxTn/x/MU25TPH3XCjSvJNl7+5P6nFrwTMCfVavq+A5e59UbgDgWVO74h3+crngvadxPFXVV1zg/68c10Pf0ux9N/7MvqWxU/jp7K345chZ/men/TYAqG9M24LjzRtnrRz3fuby0GEUvdcXON2+KdFIapODEEexaPR9qCwL91bwDFY8Hhq/TlK3UQ3GMhbehWePZkSUfngvj7URfWFYd7OREnsbH/aTOhwjWztu99n8YdHKOYr77GCru63OuWqq74aV7ek8nXFjH8o1TUXlD9jX1HY/RRb8Hf6URvhez2mSM/+o3fLLhqGL6gbXfoDXO4dLy9RFKWXCkfnIpLl7/f2iRsyzSSWmQ5huoVBQB71zsPt3DCTZdFLgv57ZoCE4sTbw+3i0Q8zXa8+nOzvO6VHmnGiZ1NnB1mleetdp9vsd9sY6qpDqeniw8rcq1951XjeeYiEcFbtOuQSLKIp2UoBBwD0Ab3hMohM+i8sGyffn4cU8eXvrxgHJGIz732qxWlBSdUUzrbg1BkBlGzTdQ2fohUHzMwww/nofi4cFrwSwFqetZP9U+PsRNzUIaqKioGDn0grDP1ZdfnroUu/X6cX6uUF2bcl+Xz09Pljz0PlKpN/QfYJr+Y3xkeMvvzybZzoYgRQ1zrLAMNpdG0q7vG0ISwa9aqk+52QoDLHA77zfiQOXga1cj8d2uOHF4b6STEjTNN1DxcmL057Dz9cQcsDoOlszc4hBsMMKEDFSZgLk3ADs+87qYJNc/jkrzKjnx7aRaZ/BQT35JHk4VrnmsaLPi59OTfW3/IDR6n5ZTg+Ha7QCAARr/72ZTRSGyd28IdpIa5L3VhxRVhABgbWCg4rwnaHw4roPNUF2CPcb78Ln+VcV0NXQHD1RPy34AQO76ufUs2Xg030DFy47o1xNm6xrUKii8HyzBvJMBgNxz5UFdX2AEsOkdIHs9sPgR74vVUa1QuyrP+dO+ouncZdTyvp/4uo/WVVUDKBvTVkgSKiTJc8tzx6bqaEzrKRk+Do7YmEpUGur0+k8jnQQFA6woOT9eVA2b1R5giuLjMG36GLBUefqoV3GofYyGJgSNdevTNn8ljJIV12j3KGc04hIVB6s50ikImmYcqHgRYKAiQlD1E86g/tS54D93p15uT+OV3Z695Ils9aWRoueLaEuEdtCqiPC5LW3gQ+jXnLitAAZ0zMCAjhmQUUfVj1Mg7V661YCqH03zHPop3NdN15ITAHhQtxjfbFNWl58rs583qt4dhIQV/8LR758LeJtaWT0N3aN2fBLpJDTYoFMsUWn8vB35fpWMuN+tBndAqjrWFewzV0RqSly+w5HVwLaP6v2U1VL/nUJzGuUyGMFxfSWJNSPVljmVrJRqXIJBL+Oo1PXwQscyPlf9NM9AJdy787acIrdpf9TucHvkSOExeyPUaNneYNh2cKVf28mTUhyvNUI9jwXpbdsf6SSQk2YbqFRZGt5GRVLcdYTgORieuoQ2KS4X2K/v8OlTNrMv1VTNJ1DxPUypa2Taeqp+zm9F45Sv5ZLyoqWoZVKMo6Lcrlb2EGgyUFGVai+j0CZXKJ/JlWzJa9h2YHC8jkTVT/M5SzRuTf1K6NWuEyWeZ/hT9ePtIWxB0wTqSesQaOmTXFl/9c1FVduxf8n7imnnCo77va3swnKsOuC5e7pa1JmPXqpj3Berp9TjfEmK1mkVW6LMKDp9Elu+fA6F+bmAl3GFNK7r9rQtX9odAUAzDVTCXfXjbXudijYq3lsMicrP+Xnpd15a24ASFdljn/fG7dyZPMgNfbBtE9FsAxVPdbB2/rRRcV5hCEZtbG4lKj6ymZ0CFdkGnPzN4zgcvbYrR6E9+MOrbsvUF5h+8vZkmOf9FVsPnQooreHhlI+u41w4DQFeV8+eeocKP3/lcl6DRtiQ/8ntGHh4Oso++pPrCmuXOx/AnDi8Fzkv9kHK0QVuq7ed//2qLDZYbcq05Gz6Dudyz49z0UwDlXCLK/JS9eHSlsgiKXth+dsLyPkcp21Arx+5id3U/b5tBVrM6IFdbza9EZsD0dSvhN55CQIcJ/M9/613Fc6lKI7W7+EqSwzyLZbPQ60HqrI4aKsSZqcBtGZcDnw8xGu1keKi5ymYrCfAfFn/Kf6k3Yaq7V8FklSUHPoFx798GLaKAJ734iPnNipCyLBZrdg79Q/Y+v69ED4H0PV1T/bwIEHY0Kva3luio3xcWXrjHKicv7iVfPsQOsrH0UXOdlvX0byzeOjd71DyUmcUvtLLMf3w5kXouOLvaDF7oH29DFTCQlvl3kYF8NDeyFKpfGvzHvDmF1fikVffw+crdzimOe+7mgaMoyIHeFOn1rZsFevfBQD0rfDv8QtWi3oaJAdTMw5UvEy3no/q/3efcvqP/wIKlHcZzidj2RaChmCBHHxqfIjWb58Dr3UANrzpMsO3YMu1WFeucipROXvY/u/hFR4/+83iHx2vjaW57gtYfetOabB4qSqsR+JXI9D+8Bc4+OXjAX3eN06Biizw+9bluNCciQGF3yvbntRRvSPX2z3Z3i3Y+bTes0p5YbEdXlO7KacLQE0blRZ1tGdIkMqxO68MqVIxEqy1F8kzv29ySUfTC1QObF2O7Bcvwp71DXvaejB5rUpx2Ydkl+7IfTQ5KK/w3INwxf8+xjtVkzFyQ+3zc5wDlQZV/QR4KfMlTDl5dB92/PhJeKthAoyfdi5t/L2VPGm2gYq3AX1sVV66x/76MfDRYMUkRXfMmkAlXL1+PNn2MfBaR3tViL9bCuWdxaIJ9n9XveiyUR8DFZd8EGbfuxj/IXOi1/UAgK3ax3EffOi5Uhf59IH6F3LenBB4f/UhrM06Xf/CTvkoC1lRiiLLNiyMi8Vuo6HudlT1BLg1vX6cr18GlzvgbufWOV7bnO7saqp+dHXcMSeiHGZhb1hpRDXMFvuybr9YIxrwzdnpUu/7mWXNNHSSj6HP6ruVMxq4zzWIl9/KtYpQeBirI3ZaG6z/eprb9B4me/uWZKn2+A1WoBLK56K1/fwK9Pv1cfwW1iAgsPOxtcjTaOuNX7MNVFyVS/ZmYHJlHeN42JQHpaLqx2I/yMI1jorB6qHny9J/AeYSiB8eVE4vyraXCBW5F7k3Bq55qqj6cXbwZ7dJ8aI2nyySwW1+ZYXndYnSfJRs/dLx3pcutnXyMxBcty8Hw9behKNfTKh3WSsEtkQZUSlJ9lI+py7E+yqOYHLrZIxJT4PNWseFwMch9J2X0kG5PudAxGp2GsjrfN7V1dAySSpD1fkeIFpJoKz8/Oc1LgO8ub5XYwmiB7Om/dvrvIuqtocxJT4SMsolCZNbtcTG6CinyS49vbyUSF6T9bL7RA8lxM6PCQnkGKs5B0fDt8HNDp8uxfxtxwMaMNOW4/9TsMPOjxvlbE2HECYkuJpvoOL0gx7V6zCwYwb+kZaC8hJ/nrHhVKJyvq62SorytrBvDq8CVjx3vnGohOM6HTzd2/Q77n3UyqJy5QVE/nI08OvHkD//i9fPRKKm1tegTi+5FLlWewlU5t3qNknj3DXWQ7VB0RnP1RHn3h2MxJ/GO943NFDxtzdE1O8LcIHmJP6mq/+pp/+LLsA/2qTi362TIWQBjdP3PFldWyJjq2P8Gdnp+3ksXXNMq/3N4qEMlo1OgYsiUKmjW3SNJJShHLXHTmXZ+ao254tbwT4MPPqu4nOmk2Ee7+LMQWD1y363uXpOO8fvTUmK0X3DS5YFPkpKwML4ODyY5jTWicvN2u+5Z1w/6pHNJuOy4p/cpjv3WPPl0RjO8koqcdvUeXh/yWafP/P89BkwL5qIXk//YO+CrdI2KgE/AsSPkZu1Hq8s6tR8AxWd0fHynRZJAICt0VEoOOzH3Y3TTt5qj32gshNR3RuWri9vBjZNR/X2z/GrvhgjM9LxSGprv1ZRWqVsUKUpso99oCmuq0QldAest/ruQGvJvJaoeBAvVQJl9ou1WRvnnraSk7WvZeG4Q2vp2p6iwcXw/uWv1o/MWWksBACsjo2BLGTFcPfO6bbWUc0l1zOIXnWFe3XbSZ0y8DM4jatSda42/2oClbpOvl00eRAAKoT9uKwJVCSnE6/189FunztbWuk2LZTEjMuB9dMg//RkSNZfJUk4oj+fr07thsJ9ORWyFVmG2hLImr3INVBpm+2908Hx3esdr/dtcS/tBIByTe0xGWOru0r3TKkZTy/Yg70n7fvG4oXf4rvqhzDq178qlvM2RhYAfGmYinG6FfjB8B/8tDcPmqbVWQhSHe0aKyQJJ6VUx/uzA58OR5KCotkGKpKu9iDMjKoNWkZra8cJyNbrsCom2us6Cg/Xtl5vVWBv9Nc63nuJirBZkb3sPRQf2+N1mRp79+/BCqP9Aru+jjR4orYH8nnrOujcaLIu+6RuiveStxIVL0zfPwYAOJnU1ylNdr/vtQemVpuM699Zj7/O3upxHZ3Prm1QNYMQ9v+JA4t9qoLzp3eL4tcWsuJk5dyY1rndiBVAsVNAYy6t+7cwHbbv3yecgpOXWrX0unz/32ov5Ab4dqd8g2YzYiT7hVAuOmqf6FTVoyt3L/2yVRT7tO5gqTm2TId9v4v3x5g2qRjVLh3ro6MaXt3oJ1kWmLVsJ9b9ng+9VoNz2tr9o6omcD6n3HcHary3vTpz4pDj9UUrbve4jKStPfcm2ereB9//ZjHG7rwT782wP426b5G9hKadVKhYbvvR+kt5emqOI/b0TkhaPxpnh6v0ZdO76Fu+0W1y7uE92Pre3Th5tI72bhrPl/S9BgMGdMzAjJYS5GeLcPofmeg77K8el1WjZhuoaHS1AYXOyw54Y7t0PJraGsudAoXSSjMqzRYcOHwE1k3vuX3GNUg4dWSf4/Xvyz9Epy2TkTTnqnrTV1lm8hhuyLBHxopt5B7BljdudrzX+vjclGDZsmAG8Hwitq5Z5HG+t0Clc3VWnet1NNzTKYM/jcW/QAXZ9ju7C1Lsd28fJiXg4k7t8U18HK7P+wCwmvF7fikOFpRh0+GzHhudti4/BLHzC/+260SCgGnXQkjf/BV495L6l9f63mjUucBKyEJxshJO48s499D4a3oqru7QDsfPBx7WsjPOK3HbxqDsGQCAMempbvPqk4BymKsqcE5bd8ngu4YZjtfa/Ez7Cy8n3hqGTW/Uvqk8B9t7l0Ne7aF9hLPyQsCPBtkQAiVf3QvTT7WNwU1VVqDwELDmlaB2vT9otN9ALY6LheTU5iegG39zKawb34Uo9m2gww07duHBLYPRed5V6LDrbew31gYR5vPnHH+eBO3LxcUKK1bFRKNcklCKum/Ibj0+BT01ufjQMB2A95LaqZ/9F3tPFNe77YSyI5C0tTesp0ur6uxeLTWg+7Q/qss9B2z6L/+CAWcXwvale8mig5eqn9eSWwAAFicYoNFqkdK2U4PTGU7NNlCRnKp+9M5DfwPYka2MyP/lVPUS/1oKCl/uiZ5fXooLq5S9a1Zv34vE48oizsTPhzhem45s8zl9V579ryJQqaq235Xe2yYFAzpmoFCjcVxQC7+4DwPLVjmW1SCAQKUBdwsDd9mLEAesG+s2r8JsgcG1jYmPCgrtv4Nr8JdSme1oE3RQblvvehKEvYG0vtpeZPz++aq+mhKB4vkPQOtUBuxt0Cpp8T/tLzZOB/b715VUgsCBLfW3N3FwDlQsvldvnDp+CKXrZjreO/fKcG6jsu/8RWhxXCwsAOTy2rZZQm+/YKyPjsKvTqWNAoCtjiqpCqHD2y0SFY0vaxhfbYNWtnyPn/tBvtrxepPhSgBA191vAvl7EeXSLdwCYGFcLPK19hNy+3Nb7IGCLOPcmvehPZsFzfrzPU6sZpi2zIVwqt5DZTHweheIqRlev4eroqxNSDz0PRK21navF5AgzxwErHsNFYtcup6fOQhU+/40cpuHC+7GmGhFicrv+V4Cq+oK4Os7gZ1fus+b2g66lc9Cmt7Hp3TEHLF35c/QnEGiSXkT8b/42ioaswSMbZOKd1vYR6X11pus77aJwPZPgbxd7jPPf+bLBBMeTW2NgR0z0EIqQ8Ex7zcvF2pyHK93rF+CASVLPS73o/EZ7P7gXq/rqSHLMo4W1R4Ts179F26ePAMzv7Xng2vI0q7413rXGQwrDrvfiNmsVqTBfj5sL590m+/gpeony1B7Pvlg1wcNS2AEhCxQmTFjBjp27IioqCgMGDAA27b5fpEOh9zS2t0ww6k3hAVAv7ld6/xshsZz0eK1S65ED00ufjfoHYXdsZIZeD4R0yffiwFnf3Asa6qy4OiZMpSZrVi6/RBenb8CCzZkKtbnfE048lI/HM/NxW9R9ovA6tgYvDn3GwBASrXL+CCyFdMXbcWPvyjXBwCHTyq7u26NMmJJbAwE7HW7S/fkoaTS90ZtecV1P3X5wPY1btM+Xn8UC3aegIC9es3bfcons+x3y4vjqtCnU3v8fv5gi5HMkF5OQ/b/nsMFGu8HbZ5wqpp4PhEXZb7gcbmkw99D/PwsOkp5AASWvT7O6zqtv80DVj4HfHs3Cr+4B3g+EWff+YPHkXGd6YTFZUwTAVF2BqbVb0GUOg3Rf349sebafaz4c/ciWtuZwxBl7vthl2+vxWWltQ+G0zqlq93Gf+PoXmXV1gctEnFDu3T0zZkNANj67esYdOJTnNFqMD4tBX9rk4rfzgc1cxLj6/yOW2L1+DQpUdH40lkLlydXz7DegEW3r8DqS/+Cg3JbLLENRGY7p+/6wZW4+KjyIZVzEhMwuXUy/tTWqcfCax2AF1ugxbba0pUjH41B2Zt9kbDsn5De7uWotjuXkwmgNvgtLszHrtXzHQM2orocsFSiMj8Lx+Y9am9rs3qK23eRIKA53/iz9JBTb5BjvwAzLnMbygCA13E4PDUqL9NocMayCxJkPKhdhMGy8ncrO1eAvR//AyXz7weylgILx0NYzZBtMlBRBOQGcFEtPOR11jstkxyvP0tMQGaUER8n2QOV5a/fjXxtG88fXPIY8OE1bpPPLXoKALAqtjZQ2BQdhfg5fwDO1d/Ftt/qMXXOv0u3GlteHYnjh/fidGmVx3YrF2R/gVtzap/2/Jz+Cyw2TsaPO3PwSaK91PW9pNpHBKSL08je57lqOCA7PgN+ed998illG8OSswX4fdq1Pq1S0hlQqNFgh9EI8/ndygagrbX2PDAjcwa+zfoW5Rbfg+lIC8noSd988w0mTpyIDz74AAMGDMD06dMxfPhwZGVlISXF80ks1HKLKnD9tKW4SrMHVmjxtn4WirUabIiJwpbo2iLHKo0EgyzwQ1ysT+ud2rIFjEJg4rliAMCrLVtg3vkT+i85uYg/f+fwqO57xecSXm2FBADb5O74kyYLfwIAl1LVGGsxcL5osrfmGJZ+cj/QuXb+v3L+D199UYoxUNbRpktFePS3YQCA0z2yUWjQ48OkRDx6rhhnP7wB2XcswumV7yJelOGZNvai/LePLcDyF39Ff00WZsaMwwXIxfHWf8Afhv4Zl6THYcd3U5Fy0TB06DVAEUHtePMvGK4FXklugSsrq3BVtQW/7tqLvhf1QZxRh9NrP4INwO8GPbpXWzDg3/OwI8refXpxXAyebt0KANDBYsH9xSY80zoZCTYbPss7jcmWj9Dv331R3dN+4N7a1n4y3J19HBKATnumo0qSsDk6CoMrKmGD/UK2ID4OtmP3whTTHQ+Vf46xOvuF2wLgjvQ0j79jr+zPsNYI5MqtUVwR6wjhF9sG4gbtFsdyukW1Xb9bHbEPBZ98LhM5n/wVHf9vPszLnoVxy7uwjfsR2o5XOpbtJnIQVea0T72QBIs2Fgm2cpza+T00f1+JJFEM67uXIb/d9eh1/Fsc0+kQK8tolat8Iq351F4YPzq/7ueK3b6LAPBZYjw6VVvRvWAlkJJsTyeK0eq/w/DbSeXJ8aReB0ljgaXajAH7X8IxnQ6j2tVeeMalp+Lbk3l4u2ULxefGltirJ3+Ii0W61eoo5ahJg7eyl2vMb6OjlI9xd47Go9tuAQBYu76HC9t3wDVdWyPzcGdcojmq+Mwc63Bcp/kNc6LaAzgDi9aKh3U34H3rYo/b6HJqiXLCiy1Q1upitCh0uru3mlE0czgulnOwJf8wBt72BKre6A1Ag1xtBi6ozAQOzoGnVmfOd7VRtlLIssCqVT/hj5vutE8sPIgzkh4/JERjdWw0hpZX4PaXkmEWCai+dwXadOiOwvzjKP9oBNpLMk5rtUhxCWQOR1mRHeUcpD4P076fYd23GAUnjuBCk3IwPMtLbXHY2Bu9zJke8wTZ64G5N7hNruo5GrsNfXF5ofujDZwd1+nQ3mp1lEjWuL5iEWQABVotUm02VEkSouopoW2xcxa27FgLXWcB6/nzyT6jAVdVmoB3LkKJIQ0l7f6AFu0vRIlVj6gTG9GqzjW6G1i1EfjySgyqeg95SEbOqyMV81uWH/H4uQs7pOCdaPt3/KhFIu4pMcEoBAwAOn03DOhtL+UTsgybzQqd3n3YA4+EsI9xldLTfl5f/Mj5Dd4MJKQ7FiuHEQLAEb0e7S0WVL53BXq7nON3/vwlzGeOQljNiCr4zTGCrbn7vzCkQzvHcreaSrEiNgatXPatKVumYFnOMnw63HvvUTWRRAiepjdgwABcdtlleP99+wlRlmVkZGRgwoQJ+Pe/vY8nAAAmkwmJiYkoKSlBQkJC0NKUvf0npP94B7QC0MLeJXlUu3S35aacOYsBlVUY1t69SuFpXQf0z9mCKCGggcCm6GhMOV99sCz3JBJsMq7oqCxSnn8yDyd0OnSxWCEAvNSqBf5UVoG/lJahTKNBjBCKg3pWUgI+SkrEuuMncF9aKn4/X2f9W/ZxCAD9OrUHAAwur8BzZ4vQyiajRKPB/IQ43FhajjSbDfsNemgAdK+2wCxJuPx8mlpZbViTexJVkgSjsN/H9Tm/vg/zT+OKSmWvkDJJgg6o86RT7ZQmANiTba8PtwJ403IHntTPx8h2bXBcr8fo0jI8V1iEJXExaG+x4q9egoYav+TkolSrwfAM5W9xx1ngwbIT0ELgqg51F+FXF/4B/zLvwBBxCG+0TMIml4bJukMT8K1mOro5lczcVf005hleAQC83/1zvLFLhwukY5is+xxXaw+4XYCdL8quF+i9BgNWx0ajX5UZvczVmJsYDwGgb1U1BlfWVuk8a7kHY7Ur0FFzEjZJwimd1rF/vnKmEP8rehh/7t0K7QpW4uLSFdgZZUS6xYoUmw0DnPa5EWXl+MkpyH6kqNhxNzy6tAwdLBbcW1Lq+N1rLM09hXZWKw4Y9Li9rfvd8e2mUnyToCxRuax1f/x6praX3JUVlY783XgsF4leqtDEf845eib1mWuvlrg87XK8ctUrWHRkEb7YWAxLngGtRDmu1ezGqjgDjuhawiZkGFspS+jiD/8DN0m/og+Oo4N0GtGG02hjtSH6/D5bIUmIFt47wm+NMmJJXCwmFZ1DgixQKUnQQMDoZZeXAVRKEmKFwBmtBjuNRgytqPRYNH1fWgq2uVSDfX4qH33N1Tiq6YhOcg4sAL5MjMfbLVtgQlEx3nMquWhps2FZ7insNRrQzmJFG5sN/4uLxeboKEw9cxaurZiqJAn68991j9GA7tUWnNZq0cpmQ4wPp3krgE+SEjCkohKL4mLxeaL7+feiSit2R9fe3953rB3uxRaMbNcGJVpl+4hFJ04h1WrfdolGwv/i4/B2yxa4s8iGx00noRfAwA7tUHl+X4grzcCKs78gSgiPd9AFWi2Gtm8LnRB4+cxZ7DUacMBgwO2lZehRFoXxaddg1Lks3FN9ADrYG4u3qClJE3FoIfnWti1Lr8ct7dyPgf+ezEPXagskANWShHdaJEJAwhNF57DtgknQJaRAZ4wDJAmVJ3ZBV3QQqNoBWdcbugtvQdz++cgo34ZoIbA65R4kmL6GSaOBOXYEZrVogTO2vfhD7MvIPvguDrTJBABcUVGJcSWlMGsk7DQaMScpAd+ezEPPagtkABYJsEGCWZKgEwI/xMdhWnILt7R789vY36AP4iCKobp+Bz1Qqa6uRkxMDP773/9i1KhRjunjxo1DcXExFi5U1u2bzWaYzbXFfyaTCRkZGUH/ojln9uKGpXcGbX3BJp0/wch+9tmNlWWU19Pg0Jtkqw1ndVrF+zKN/cRukSTHepNsNhRrtUiw2RAlBGRIsElAqUbjuBuqESfLKAswPZHQwtgCA6NewrdbStFLykE73TlMfnQi7nrjW7RvGY0PJtwMU3UhRiwY5viMTggYhYDufD5VnP++MbLseJ1ks0EroMhfV/E2GTFCRvX5O1CtEDih937S0Ar787oDfep0fQyyQHWQ+mve3eUuTFr5KvYZLkZ5TFsYL74ZCakd0anXZYrlagKVoJP1gKa2CtMoC8jQQAcbNLAXh1e57KdGWYb5/LR4mww9BPSi9ilYGgD5Os+F0C1sNsgASs4fJwYBFHr57eNtMkq1/h8jCTYbTE7BQGurFRrYg6czXtJVI9Fmg1WSoBE138V+vqnJCys0KNeGZr9yzldfSQLnbyolaISAVvLjvFLWBVLsEUcj8yjZPsD+x/mncZHZ+7Nw7khPdbTd8kYrhMd2WkkeqvWKnX6rNKtVse/ohHA7d0bC5js3I87gPmxDoEIVqAS96qewsBA2mw2pqcreAampqfj9d/cW41OnTsULL3huOxBMsiHGp+VSolNwutL7sOWJxkSYrWZU2eofer19fHvkl+ejWq7/QVFCCqxTcaBBCuB+Ea157zqiRs0BZ9JqUce4vQAQliClVXQrFFYW1r8g7IHIObP3BwKO6DQC/778akwbJcFik6E/fwHZOPUexzJCUu47VknyeJKpcPruxVrvAUqNUq0GpX40E6urIWsw+BOkjOk5BvsK9yHzTKZjWrQuGpVWeynRyJ43AVc9hd71rGfLXVswfcd0bC/YjsPFhzGozSAcKT4CU7UJZpu53odlSpA8L6NRtrMyayQAApY68tv5YupvIHHO6fc21fPbBxKkeFpvfcGJM9fSDn8kRyXjbJU/A2Ha6aQoWEWVz0FKnD4OZed79AkJsEr2UZft6l6HRtLgpi43YW3uWky88h48u+lZx7yagPQj658Qa2kNuVUPdLr4anz2869Ik4rQUjLhkNwOlZpZAOpuc+ftGKzveHcNcCMVpCwctRDrctdh1q5ZmHHdjKAGKaEU9BKVU6dOoW3btvjll18waNAgx/QnnngC69atw9atysZI4SpRkYWMSmslrLIV1bZqmG1mtIhqgVi957YoQgjH8028qbZVQ5Ik6DV6VNvswYheo/f6OVnIsJ3vOmy2mqGRNNh+vAAp8XokxxkhIKCVtIjRx6DKWgWbsEEDDc6WWZESb4SkkVDzX0l1CUyVFuSeK0XXlFhUy9XQSTpoNVqUmEtw5HQl2idHISkqDhpJg/yyQpSUGXBBajwOnM7HvpPluLZ7G2i1Ms6VW6DVaHCosBCdk5NwMM+MhGg9UhMlbD1aglZJVcg/p0F6QiKW7D6JOKMRgECZWUa7FlG44ZJkpCVGQwMtDpwqw9kyGwZ0jUGiMQGbjh6HbI3C4O5toNPoYNAaUGGpQLQuGlZhRXJUMqJ10ZAkyS3PS6tLUWmtRIwuxu2AssgWCCFgkS2I0cXU+1t5UpOO+j4rCxnF5mLoNDpU26phla21v4+kgdlmhk6yfzersEI+X9xsEzb7n2zDOfM5x4U8OToZ1bZqR5GryWyCRqOBUWuE2WaGLGTE6eNgtplhqjYhOSoZkiShrLoMOo0OFtkCi80CrUYLCRLOVJ7B5WmXo8JagRJzCeIN8YjSRkEraWGRLdBpdGgd0xpFVUWQhYxqWzV0Gh3SYtOglbTQSlqYqk2otFZCFjI0kgbRumgkGhMV+VDfMSELGTbZBkgIqDi5Jh+1TmOnWGQLIAC91n6MaSUtJEmC5nzvhpp9wCpbISBQaa1Eta0aspChlbSQYf/XKlsdo+/WLA8AMboY6DQ6WGUrbMLmCI4MWgMsNvtyNd9ZFjKEEMgx5aBDQgdoJA1M1SbIQkYLYwvH9mP0MdBJ9gtThbUCRq0ROo0OOo3OkYel1aUQQkCn0SFaZ68uKygvQFpsGuIN8TBVmyBJEmRZhgwZBo0B8vl+KDXTrLIVQgiYbWZE6aKg1+ih1Wjt+6Zsg1FnRLQ2GhZhP1b0Gr39O8A+sKEsZEf+SJIEraRFaXUpYvWxqLDaj41OCZ3qPT4sNgsqrBWIN8Q7fpcaZdVlKDYXwypb0TqmNWL1sRBCoMxSBotsgSxkJBgSYDjfFq/SWolKayWqrFX29AkZVmGFBhpIkoQWUS2gk3Q4Zz6HeEM8orXREBCotlUjzhDn+J1Plp1EtC7a/j1h3y9TY1Nh1HovMTlachRmqxmFlYWIN8QjOTrZcQwkGBJgk20orCxEsbkYRq0RZZYy6DV66DQ6r8+OM1WboNfqHb+7yWxCcnQyhBAot5SjuLwAyfHp0Ek6WIXVsY+YbWbE6mMRo4tBqaUUUdooROuiEauPhU3YIAsZFZYK2IQNRq0RFtmCKG0UqmxVMGqNSIutu1o9VJps1Y+rUH1RIiIiCp1QXb+DXk5vMBjQr18/rFpVO66HLMtYtWqVooSFiIiIqD4h6Z48ceJEjBs3Dv3798fll1+O6dOno7y8HPfeW/8gPEREREQ1QhKo3H777Thz5gz+85//ID8/H5dccgmWLVvm1sCWiIiIqC4hGUelIdhGhYiIqPFpNG1UiIiIiIKFgQoRERGpFgMVIiIiUi0GKkRERKRaDFSIiIhItRioEBERkWoxUCEiIiLVYqBCREREqsVAhYiIiFQrJEPoN0TNQLkmkynCKSEiIiJf1Vy3gz3gveoCldLSUgBARkZGhFNCRERE/iotLUViYmLQ1qe6Z/3IsoxTp04hPj4ekiQFdd0mkwkZGRnIzc3lc4R8xDzzH/PMf8wz/zHP/Mc8C4yv+SaEQGlpKdLT06HRBK9liepKVDQaDdq1axfSbSQkJHAn9RPzzH/MM/8xz/zHPPMf8ywwvuRbMEtSarAxLREREakWAxUiIiJSrWYVqBiNRjz33HMwGo2RTkqjwTzzH/PMf8wz/zHP/Mc8C0yk8011jWmJiIiIajSrEhUiIiJqXBioEBERkWoxUCEiIiLVYqBCREREqtVsApUZM2agY8eOiIqKwoABA7Bt27ZIJykspk6dissuuwzx8fFISUnBqFGjkJWVpVimqqoK48ePR3JyMuLi4jB69GgUFBQoljl+/DhGjhyJmJgYpKSkYNKkSbBarYpl1q5di0svvRRGoxFdu3bFZ599FuqvFxavvvoqJEnCo48+6pjGPPPs5MmT+Otf/4rk5GRER0ejT58+2L59u2O+EAL/+c9/0KZNG0RHR2Po0KE4dOiQYh1FRUUYM2YMEhISkJSUhPvuuw9lZWWKZXbv3o2rr74aUVFRyMjIwLRp08Ly/YLNZrPh2WefRadOnRAdHY0uXbpgypQpimelNPc8W79+PW644Qakp6dDkiT88MMPivnhzJ/vvvsOPXr0QFRUFPr06YOlS5cG/fsGQ115ZrFY8OSTT6JPnz6IjY1Feno67r77bpw6dUqxDlXlmWgG5s+fLwwGg/j000/Fvn37xD/+8Q+RlJQkCgoKIp20kBs+fLiYM2eO2Lt3r8jMzBR/+tOfRPv27UVZWZljmQceeEBkZGSIVatWie3bt4uBAweKK664wjHfarWKCy+8UAwdOlTs3LlTLF26VLRq1Uo89dRTjmWOHj0qYmJixMSJE8X+/fvFe++9J7RarVi2bFlYv2+wbdu2TXTs2FFcdNFF4pFHHnFMZ565KyoqEh06dBD33HOP2Lp1qzh69KhYvny5OHz4sGOZV199VSQmJooffvhB7Nq1S9x4442iU6dOorKy0rHM9ddfLy6++GKxZcsWsWHDBtG1a1dx5513OuaXlJSI1NRUMWbMGLF3717x9ddfi+joaPHhhx+G9fsGw8svvyySk5PFkiVLRHZ2tvjuu+9EXFyceOeddxzLNPc8W7p0qXjmmWfE999/LwCIBQsWKOaHK382bdoktFqtmDZtmti/f7+YPHmy0Ov1Ys+ePSHPA3/VlWfFxcVi6NCh4ptvvhG///672Lx5s7j88stFv379FOtQU541i0Dl8ssvF+PHj3e8t9lsIj09XUydOjWCqYqM06dPCwBi3bp1Qgj7TqvX68V3333nWObAgQMCgNi8ebMQwr7TazQakZ+f71hm1qxZIiEhQZjNZiGEEE888YTo3bu3Ylu33367GD58eKi/UsiUlpaKbt26iRUrVog//OEPjkCFeebZk08+Ka666iqv82VZFmlpaeL11193TCsuLhZGo1F8/fXXQggh9u/fLwCIX3/91bHMTz/9JCRJEidPnhRCCDFz5kzRokULRz7WbLt79+7B/kohN3LkSPG3v/1NMe3mm28WY8aMEUIwz1y5XnTDmT+33XabGDlypCI9AwYMEP/3f/8X1O8YbJ6CO1fbtm0TAMSxY8eEEOrLsyZf9VNdXY0dO3Zg6NChjmkajQZDhw7F5s2bI5iyyCgpKQEAtGzZEgCwY8cOWCwWRf706NED7du3d+TP5s2b0adPH6SmpjqWGT58OEwmE/bt2+dYxnkdNcs05jweP348Ro4c6fa9mGeeLVq0CP3798ett96KlJQU9O3bFx9//LFjfnZ2NvLz8xXfOTExEQMGDFDkW1JSEvr37+9YZujQodBoNNi6datjmWuuuQYGg8GxzPDhw5GVlYVz586F+msG1RVXXIFVq1bh4MGDAIBdu3Zh48aNGDFiBADmWX3CmT9N7Xh1VlJSAkmSkJSUBEB9edbkA5XCwkLYbDbFBQMAUlNTkZ+fH6FURYYsy3j00Udx5ZVX4sILLwQA5Ofnw2AwOHbQGs75k5+f7zH/aubVtYzJZEJlZWUovk5IzZ8/H7/99humTp3qNo955tnRo0cxa9YsdOvWDcuXL8eDDz6If/7zn5g7dy6A2u9d17GYn5+PlJQUxXydToeWLVv6lbeNxb///W/ccccd6NGjB/R6Pfr27YtHH30UY8aMAcA8q08488fbMo05/wB7e7snn3wSd955p+OBg2rLM9U9PZlCZ/z48di7dy82btwY6aSoWm5uLh555BGsWLECUVFRkU5OoyHLMvr3749XXnkFANC3b1/s3bsXH3zwAcaNGxfh1KnTt99+i6+++grz5s1D7969kZmZiUcffRTp6enMMwo5i8WC2267DUIIzJo1K9LJ8arJl6i0atUKWq3WrUdGQUEB0tLSIpSq8Hv44YexZMkSrFmzBu3atXNMT0tLQ3V1NYqLixXLO+dPWlqax/yrmVfXMgkJCYiOjg721wmpHTt24PTp07j00kuh0+mg0+mwbt06vPvuu9DpdEhNTWWeedCmTRv06tVLMa1nz544fvw4gNrvXdexmJaWhtOnTyvmW61WFBUV+ZW3jcWkSZMcpSp9+vTB2LFj8dhjjzlK8phndQtn/nhbprHmX02QcuzYMaxYscJRmgKoL8+afKBiMBjQr18/rFq1yjFNlmWsWrUKgwYNimDKwkMIgYcffhgLFizA6tWr0alTJ8X8fv36Qa/XK/InKysLx48fd+TPoEGDsGfPHsWOW7Nj11yYBg0apFhHzTKNMY+vu+467NmzB5mZmY6//v37Y8yYMY7XzDN3V155pVvX94MHD6JDhw4AgE6dOiEtLU3xnU0mE7Zu3arIt+LiYuzYscOxzOrVqyHLMgYMGOBYZv369bBYLI5lVqxYge7du6NFixYh+36hUFFRAY1GeRrWarWQZRkA86w+4cyfpnS81gQphw4dwsqVK5GcnKyYr7o886vpbSM1f/58YTQaxWeffSb2798v7r//fpGUlKTokdFUPfjggyIxMVGsXbtW5OXlOf4qKiocyzzwwAOiffv2YvXq1WL79u1i0KBBYtCgQY75NV1thw0bJjIzM8WyZctE69atPXa1nTRpkjhw4ICYMWNGo+5q68q5148QzDNPtm3bJnQ6nXj55ZfFoUOHxFdffSViYmLEl19+6Vjm1VdfFUlJSWLhwoVi9+7d4qabbvLYlbRv375i69atYuPGjaJbt26KbpHFxcUiNTVVjB07Vuzdu1fMnz9fxMTENIqutq7GjRsn2rZt6+ie/P3334tWrVqJJ554wrFMc8+z0tJSsXPnTrFz504BQLz11lti586djh4q4cqfTZs2CZ1OJ9544w1x4MAB8dxzz6m2e3JdeVZdXS1uvPFG0a5dO5GZmam4Ljj34FFTnjWLQEUIId577z3Rvn17YTAYxOWXXy62bNkS6SSFBQCPf3PmzHEsU1lZKR566CHRokULERMTI/7yl7+IvLw8xXpycnLEiBEjRHR0tGjVqpV4/PHHhcViUSyzZs0acckllwiDwSA6d+6s2EZj5xqoMM88W7x4sbjwwguF0WgUPXr0EB999JFivizL4tlnnxWpqanCaDSK6667TmRlZSmWOXv2rLjzzjtFXFycSEhIEPfee68oLS1VLLNr1y5x1VVXCaPRKNq2bSteffXVkH+3UDCZTOKRRx4R7du3F1FRUaJz587imWeeUVwwmnuerVmzxuM5bNy4cUKI8ObPt99+Ky644AJhMBhE7969xY8//hiy790QdeVZdna21+vCmjVrHOtQU55JQjgNgUhERESkIk2+jQoRERE1XgxUiIiISLUYqBAREZFqMVAhIiIi1WKgQkRERKrFQIWIiIhUi4EKERERqRYDFSIiIlItBipERESkWgxUiIiISLUYqBAREZFqMVAhIiIi1fp/Z/gfA1MEDOwAAAAASUVORK5CYII=\n"
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Setting time as index\n",
        "data1 = data_set.set_index('Time')\n",
        "data1"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 455
        },
        "id": "4JV7wrPw-Z7y",
        "outputId": "c1522ee8-bae8-4b92-f412-7ab7f87e2f8d"
      },
      "execution_count": 16,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                      L06_347  LS06_347  LS06_348\n",
              "Time                                             \n",
              "2009-01-01 00:00:00  0.137417  0.097500  0.016833\n",
              "2009-01-01 03:00:00  0.131250  0.088833  0.016417\n",
              "2009-01-01 06:00:00  0.113500  0.091250  0.016750\n",
              "2009-01-01 09:00:00  0.135750  0.091500  0.016250\n",
              "2009-01-01 12:00:00  0.140917  0.096167  0.017000\n",
              "...                       ...       ...       ...\n",
              "2013-01-01 12:00:00  1.710000  1.710000  0.129583\n",
              "2013-01-01 15:00:00  1.420000  1.420000  0.096333\n",
              "2013-01-01 18:00:00  1.178583  1.178583  0.083083\n",
              "2013-01-01 21:00:00  0.898250  0.898250  0.077167\n",
              "2013-01-02 00:00:00  0.860000  0.860000  0.075000\n",
              "\n",
              "[11697 rows x 3 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-0ce7b847-7b8d-497c-9161-320d10f2ff8d\" 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>L06_347</th>\n",
              "      <th>LS06_347</th>\n",
              "      <th>LS06_348</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Time</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2009-01-01 00:00:00</th>\n",
              "      <td>0.137417</td>\n",
              "      <td>0.097500</td>\n",
              "      <td>0.016833</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2009-01-01 03:00:00</th>\n",
              "      <td>0.131250</td>\n",
              "      <td>0.088833</td>\n",
              "      <td>0.016417</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2009-01-01 06:00:00</th>\n",
              "      <td>0.113500</td>\n",
              "      <td>0.091250</td>\n",
              "      <td>0.016750</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2009-01-01 09:00:00</th>\n",
              "      <td>0.135750</td>\n",
              "      <td>0.091500</td>\n",
              "      <td>0.016250</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2009-01-01 12:00:00</th>\n",
              "      <td>0.140917</td>\n",
              "      <td>0.096167</td>\n",
              "      <td>0.017000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-01 12:00:00</th>\n",
              "      <td>1.710000</td>\n",
              "      <td>1.710000</td>\n",
              "      <td>0.129583</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-01 15:00:00</th>\n",
              "      <td>1.420000</td>\n",
              "      <td>1.420000</td>\n",
              "      <td>0.096333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-01 18:00:00</th>\n",
              "      <td>1.178583</td>\n",
              "      <td>1.178583</td>\n",
              "      <td>0.083083</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-01 21:00:00</th>\n",
              "      <td>0.898250</td>\n",
              "      <td>0.898250</td>\n",
              "      <td>0.077167</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-02 00:00:00</th>\n",
              "      <td>0.860000</td>\n",
              "      <td>0.860000</td>\n",
              "      <td>0.075000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>11697 rows × 3 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-0ce7b847-7b8d-497c-9161-320d10f2ff8d')\"\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-0ce7b847-7b8d-497c-9161-320d10f2ff8d 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-0ce7b847-7b8d-497c-9161-320d10f2ff8d');\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-2d6eedcc-4a1d-4004-a146-a7b0366ea199\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-2d6eedcc-4a1d-4004-a146-a7b0366ea199')\"\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-2d6eedcc-4a1d-4004-a146-a7b0366ea199 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "  <div id=\"id_b1d1312d-fe73-458d-85d8-a6f46a429103\">\n",
              "    <style>\n",
              "      .colab-df-generate {\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-generate: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",
              "      [theme=dark] .colab-df-generate {\n",
              "        background-color: #3B4455;\n",
              "        fill: #D2E3FC;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate: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",
              "    <button class=\"colab-df-generate\" onclick=\"generateWithVariable('data1')\"\n",
              "            title=\"Generate code using this dataframe.\"\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",
              "    <path d=\"M7,19H8.4L18.45,9,17,7.55,7,17.6ZM5,21V16.75L18.45,3.32a2,2,0,0,1,2.83,0l1.4,1.43a1.91,1.91,0,0,1,.58,1.4,1.91,1.91,0,0,1-.58,1.4L9.25,21ZM18.45,9,17,7.55Zm-12,3A5.31,5.31,0,0,0,4.9,8.1,5.31,5.31,0,0,0,1,6.5,5.31,5.31,0,0,0,4.9,4.9,5.31,5.31,0,0,0,6.5,1,5.31,5.31,0,0,0,8.1,4.9,5.31,5.31,0,0,0,12,6.5,5.46,5.46,0,0,0,6.5,12Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "    <script>\n",
              "      (() => {\n",
              "      const buttonEl =\n",
              "        document.querySelector('#id_b1d1312d-fe73-458d-85d8-a6f46a429103 button.colab-df-generate');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      buttonEl.onclick = () => {\n",
              "        google.colab.notebook.generateWithVariable('data1');\n",
              "      }\n",
              "      })();\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "data1",
              "summary": "{\n  \"name\": \"data1\",\n  \"rows\": 11697,\n  \"fields\": [\n    {\n      \"column\": \"Time\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 11697,\n        \"samples\": [\n          \"2012-05-15 21:00:00\",\n          \"2010-05-03 00:00:00\",\n          \"2011-03-23 21:00:00\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"L06_347\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.7870651583227748,\n        \"min\": -0.0183333333333333,\n        \"max\": 25.65833333333333,\n        \"num_unique_values\": 5057,\n        \"samples\": [\n          0.0909166666666666,\n          0.1191666666666666,\n          0.07125\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LS06_347\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.7928968526982662,\n        \"min\": 0.035,\n        \"max\": 25.65833333333333,\n        \"num_unique_values\": 4903,\n        \"samples\": [\n          0.4049166666666667,\n          0.2288333333333333,\n          0.0934999999999999\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LS06_348\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.047724144665189816,\n        \"min\": 0.0020833333333333,\n        \"max\": 1.3283333333333334,\n        \"num_unique_values\": 1365,\n        \"samples\": [\n          0.0414166666666666,\n          0.0152499999999999,\n          0.0444999999999999\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#printing the indices\n",
        "\n",
        "data1.index"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "gRuJdtwF_Q29",
        "outputId": "89c20e63-4ee3-4df3-c53a-38514b23bb67"
      },
      "execution_count": 17,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['2009-01-01 00:00:00', '2009-01-01 03:00:00', '2009-01-01 06:00:00',\n",
              "       '2009-01-01 09:00:00', '2009-01-01 12:00:00', '2009-01-01 15:00:00',\n",
              "       '2009-01-01 18:00:00', '2009-01-01 21:00:00', '2009-01-02 00:00:00',\n",
              "       '2009-01-02 03:00:00',\n",
              "       ...\n",
              "       '2012-12-31 21:00:00', '2013-01-01 00:00:00', '2013-01-01 03:00:00',\n",
              "       '2013-01-01 06:00:00', '2013-01-01 09:00:00', '2013-01-01 12:00:00',\n",
              "       '2013-01-01 15:00:00', '2013-01-01 18:00:00', '2013-01-01 21:00:00',\n",
              "       '2013-01-02 00:00:00'],\n",
              "      dtype='object', name='Time', length=11697)"
            ]
          },
          "metadata": {},
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Exercise-1\n",
        "\n",
        "#Select all data starting from 2012\n",
        "\n",
        "data2 = data1['2012-01-01 0:00:00':]\n",
        "data2\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 455
        },
        "id": "_VZEVxd4_pez",
        "outputId": "25b9ab6f-dcf5-47fe-f46f-13f7a455ff0e"
      },
      "execution_count": 18,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                      L06_347  LS06_347  LS06_348\n",
              "Time                                             \n",
              "2012-01-01 12:00:00  0.295000  0.285167  0.031750\n",
              "2012-01-01 15:00:00  0.301417  0.287750  0.031417\n",
              "2012-01-01 18:00:00  0.322083  0.304167  0.038083\n",
              "2012-01-01 21:00:00  0.355417  0.346500  0.080917\n",
              "2012-01-02 00:00:00  1.069333  0.970000  0.071917\n",
              "...                       ...       ...       ...\n",
              "2013-01-01 12:00:00  1.710000  1.710000  0.129583\n",
              "2013-01-01 15:00:00  1.420000  1.420000  0.096333\n",
              "2013-01-01 18:00:00  1.178583  1.178583  0.083083\n",
              "2013-01-01 21:00:00  0.898250  0.898250  0.077167\n",
              "2013-01-02 00:00:00  0.860000  0.860000  0.075000\n",
              "\n",
              "[2933 rows x 3 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-5a924e17-17df-4b86-ad2a-3a8903c05069\" 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>L06_347</th>\n",
              "      <th>LS06_347</th>\n",
              "      <th>LS06_348</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Time</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2012-01-01 12:00:00</th>\n",
              "      <td>0.295000</td>\n",
              "      <td>0.285167</td>\n",
              "      <td>0.031750</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2012-01-01 15:00:00</th>\n",
              "      <td>0.301417</td>\n",
              "      <td>0.287750</td>\n",
              "      <td>0.031417</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2012-01-01 18:00:00</th>\n",
              "      <td>0.322083</td>\n",
              "      <td>0.304167</td>\n",
              "      <td>0.038083</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2012-01-01 21:00:00</th>\n",
              "      <td>0.355417</td>\n",
              "      <td>0.346500</td>\n",
              "      <td>0.080917</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2012-01-02 00:00:00</th>\n",
              "      <td>1.069333</td>\n",
              "      <td>0.970000</td>\n",
              "      <td>0.071917</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-01 12:00:00</th>\n",
              "      <td>1.710000</td>\n",
              "      <td>1.710000</td>\n",
              "      <td>0.129583</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-01 15:00:00</th>\n",
              "      <td>1.420000</td>\n",
              "      <td>1.420000</td>\n",
              "      <td>0.096333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-01 18:00:00</th>\n",
              "      <td>1.178583</td>\n",
              "      <td>1.178583</td>\n",
              "      <td>0.083083</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-01 21:00:00</th>\n",
              "      <td>0.898250</td>\n",
              "      <td>0.898250</td>\n",
              "      <td>0.077167</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-02 00:00:00</th>\n",
              "      <td>0.860000</td>\n",
              "      <td>0.860000</td>\n",
              "      <td>0.075000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>2933 rows × 3 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-5a924e17-17df-4b86-ad2a-3a8903c05069')\"\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-5a924e17-17df-4b86-ad2a-3a8903c05069 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-5a924e17-17df-4b86-ad2a-3a8903c05069');\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-a2e2e090-e75e-4d4b-bb6f-2b3b977aa368\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-a2e2e090-e75e-4d4b-bb6f-2b3b977aa368')\"\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-a2e2e090-e75e-4d4b-bb6f-2b3b977aa368 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "  <div id=\"id_3f4e3cc0-75d9-42f4-98a7-c3a18fba6a7e\">\n",
              "    <style>\n",
              "      .colab-df-generate {\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-generate: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",
              "      [theme=dark] .colab-df-generate {\n",
              "        background-color: #3B4455;\n",
              "        fill: #D2E3FC;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate: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",
              "    <button class=\"colab-df-generate\" onclick=\"generateWithVariable('data2')\"\n",
              "            title=\"Generate code using this dataframe.\"\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",
              "    <path d=\"M7,19H8.4L18.45,9,17,7.55,7,17.6ZM5,21V16.75L18.45,3.32a2,2,0,0,1,2.83,0l1.4,1.43a1.91,1.91,0,0,1,.58,1.4,1.91,1.91,0,0,1-.58,1.4L9.25,21ZM18.45,9,17,7.55Zm-12,3A5.31,5.31,0,0,0,4.9,8.1,5.31,5.31,0,0,0,1,6.5,5.31,5.31,0,0,0,4.9,4.9,5.31,5.31,0,0,0,6.5,1,5.31,5.31,0,0,0,8.1,4.9,5.31,5.31,0,0,0,12,6.5,5.46,5.46,0,0,0,6.5,12Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "    <script>\n",
              "      (() => {\n",
              "      const buttonEl =\n",
              "        document.querySelector('#id_3f4e3cc0-75d9-42f4-98a7-c3a18fba6a7e button.colab-df-generate');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      buttonEl.onclick = () => {\n",
              "        google.colab.notebook.generateWithVariable('data2');\n",
              "      }\n",
              "      })();\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "data2",
              "summary": "{\n  \"name\": \"data2\",\n  \"rows\": 2933,\n  \"fields\": [\n    {\n      \"column\": \"Time\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 2933,\n        \"samples\": [\n          \"2012-06-19 03:00:00\",\n          \"2012-10-23 09:00:00\",\n          \"2012-12-19 06:00:00\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"L06_347\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.44667646083738927,\n        \"min\": 0.035,\n        \"max\": 6.249166666666667,\n        \"num_unique_values\": 1811,\n        \"samples\": [\n          0.0422499999999999,\n          0.2515833333333333,\n          0.0359166666666666\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LS06_347\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.44228406871361264,\n        \"min\": 0.035,\n        \"max\": 6.079166666666667,\n        \"num_unique_values\": 1932,\n        \"samples\": [\n          0.0996666666666666,\n          0.0914166666666666,\n          0.9544166666666666\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LS06_348\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.039614968603218274,\n        \"min\": 0.0020833333333333,\n        \"max\": 0.4835833333333333,\n        \"num_unique_values\": 768,\n        \"samples\": [\n          0.0464166666666666,\n          0.3520833333333333,\n          0.1226666666666666\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 18
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Exercise 2\n",
        "\n",
        "#select all data in january for all different years\n",
        "\n",
        "data1.index = pd.to_datetime(data1.index)\n",
        "\n",
        "data3 = data1[data1.index.month == 1]\n",
        "data3"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 455
        },
        "id": "Tg0d3QCDAx4A",
        "outputId": "d9f62dcb-ca64-4ca2-9424-87397d71593e"
      },
      "execution_count": 19,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                      L06_347  LS06_347  LS06_348\n",
              "Time                                             \n",
              "2009-01-01 00:00:00  0.137417  0.097500  0.016833\n",
              "2009-01-01 03:00:00  0.131250  0.088833  0.016417\n",
              "2009-01-01 06:00:00  0.113500  0.091250  0.016750\n",
              "2009-01-01 09:00:00  0.135750  0.091500  0.016250\n",
              "2009-01-01 12:00:00  0.140917  0.096167  0.017000\n",
              "...                       ...       ...       ...\n",
              "2013-01-01 12:00:00  1.710000  1.710000  0.129583\n",
              "2013-01-01 15:00:00  1.420000  1.420000  0.096333\n",
              "2013-01-01 18:00:00  1.178583  1.178583  0.083083\n",
              "2013-01-01 21:00:00  0.898250  0.898250  0.077167\n",
              "2013-01-02 00:00:00  0.860000  0.860000  0.075000\n",
              "\n",
              "[1001 rows x 3 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-1e7d877e-030f-4706-93ef-5d60d4e7b884\" 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>L06_347</th>\n",
              "      <th>LS06_347</th>\n",
              "      <th>LS06_348</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Time</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2009-01-01 00:00:00</th>\n",
              "      <td>0.137417</td>\n",
              "      <td>0.097500</td>\n",
              "      <td>0.016833</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2009-01-01 03:00:00</th>\n",
              "      <td>0.131250</td>\n",
              "      <td>0.088833</td>\n",
              "      <td>0.016417</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2009-01-01 06:00:00</th>\n",
              "      <td>0.113500</td>\n",
              "      <td>0.091250</td>\n",
              "      <td>0.016750</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2009-01-01 09:00:00</th>\n",
              "      <td>0.135750</td>\n",
              "      <td>0.091500</td>\n",
              "      <td>0.016250</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2009-01-01 12:00:00</th>\n",
              "      <td>0.140917</td>\n",
              "      <td>0.096167</td>\n",
              "      <td>0.017000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-01 12:00:00</th>\n",
              "      <td>1.710000</td>\n",
              "      <td>1.710000</td>\n",
              "      <td>0.129583</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-01 15:00:00</th>\n",
              "      <td>1.420000</td>\n",
              "      <td>1.420000</td>\n",
              "      <td>0.096333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-01 18:00:00</th>\n",
              "      <td>1.178583</td>\n",
              "      <td>1.178583</td>\n",
              "      <td>0.083083</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-01 21:00:00</th>\n",
              "      <td>0.898250</td>\n",
              "      <td>0.898250</td>\n",
              "      <td>0.077167</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-02 00:00:00</th>\n",
              "      <td>0.860000</td>\n",
              "      <td>0.860000</td>\n",
              "      <td>0.075000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1001 rows × 3 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-1e7d877e-030f-4706-93ef-5d60d4e7b884')\"\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-1e7d877e-030f-4706-93ef-5d60d4e7b884 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-1e7d877e-030f-4706-93ef-5d60d4e7b884');\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-f92e540a-03d2-464a-ab3b-e0bf1659677c\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-f92e540a-03d2-464a-ab3b-e0bf1659677c')\"\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-f92e540a-03d2-464a-ab3b-e0bf1659677c button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "  <div id=\"id_c565d148-826d-4825-83af-3ff79d40cc42\">\n",
              "    <style>\n",
              "      .colab-df-generate {\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-generate: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",
              "      [theme=dark] .colab-df-generate {\n",
              "        background-color: #3B4455;\n",
              "        fill: #D2E3FC;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate: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",
              "    <button class=\"colab-df-generate\" onclick=\"generateWithVariable('data3')\"\n",
              "            title=\"Generate code using this dataframe.\"\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",
              "    <path d=\"M7,19H8.4L18.45,9,17,7.55,7,17.6ZM5,21V16.75L18.45,3.32a2,2,0,0,1,2.83,0l1.4,1.43a1.91,1.91,0,0,1,.58,1.4,1.91,1.91,0,0,1-.58,1.4L9.25,21ZM18.45,9,17,7.55Zm-12,3A5.31,5.31,0,0,0,4.9,8.1,5.31,5.31,0,0,0,1,6.5,5.31,5.31,0,0,0,4.9,4.9,5.31,5.31,0,0,0,6.5,1,5.31,5.31,0,0,0,8.1,4.9,5.31,5.31,0,0,0,12,6.5,5.46,5.46,0,0,0,6.5,12Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "    <script>\n",
              "      (() => {\n",
              "      const buttonEl =\n",
              "        document.querySelector('#id_c565d148-826d-4825-83af-3ff79d40cc42 button.colab-df-generate');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      buttonEl.onclick = () => {\n",
              "        google.colab.notebook.generateWithVariable('data3');\n",
              "      }\n",
              "      })();\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "data3",
              "summary": "{\n  \"name\": \"data3\",\n  \"rows\": 1001,\n  \"fields\": [\n    {\n      \"column\": \"Time\",\n      \"properties\": {\n        \"dtype\": \"date\",\n        \"min\": \"2009-01-01 00:00:00\",\n        \"max\": \"2013-01-02 00:00:00\",\n        \"num_unique_values\": 1001,\n        \"samples\": [\n          \"2011-01-04 03:00:00\",\n          \"2012-01-25 15:00:00\",\n          \"2011-01-31 15:00:00\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"L06_347\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1.0012648229293415,\n        \"min\": 0.0465833333333333,\n        \"max\": 10.365,\n        \"num_unique_values\": 906,\n        \"samples\": [\n          0.3309166666666667,\n          0.1223333333333333,\n          0.1483333333333333\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LS06_347\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1.0226503571199586,\n        \"min\": 0.0447499999999999,\n        \"max\": 10.251666666666669,\n        \"num_unique_values\": 911,\n        \"samples\": [\n          0.6014166666666667,\n          0.20275,\n          0.9784166666666664\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LS06_348\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.04853893854281136,\n        \"min\": 0.0109999999999999,\n        \"max\": 0.6375000000000001,\n        \"num_unique_values\": 494,\n        \"samples\": [\n          0.0954999999999999,\n          0.0255833333333333,\n          0.0300833333333333\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Exercise 3\n",
        "#select all data in January, February and March for all different years\n",
        "\n",
        "\n",
        "data4 = data1[(data1.index.month == 1) | (data1.index.month == 2) | (data1.index.month == 3)]\n",
        "data4\n"
      ],
      "metadata": {
        "id": "kpX0OGSLIjmb",
        "outputId": "57e5dbd1-ffb3-495f-babb-843fb1d948bc",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 455
        }
      },
      "execution_count": 22,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                      L06_347  LS06_347  LS06_348\n",
              "Time                                             \n",
              "2009-01-01 00:00:00  0.137417  0.097500  0.016833\n",
              "2009-01-01 03:00:00  0.131250  0.088833  0.016417\n",
              "2009-01-01 06:00:00  0.113500  0.091250  0.016750\n",
              "2009-01-01 09:00:00  0.135750  0.091500  0.016250\n",
              "2009-01-01 12:00:00  0.140917  0.096167  0.017000\n",
              "...                       ...       ...       ...\n",
              "2013-01-01 12:00:00  1.710000  1.710000  0.129583\n",
              "2013-01-01 15:00:00  1.420000  1.420000  0.096333\n",
              "2013-01-01 18:00:00  1.178583  1.178583  0.083083\n",
              "2013-01-01 21:00:00  0.898250  0.898250  0.077167\n",
              "2013-01-02 00:00:00  0.860000  0.860000  0.075000\n",
              "\n",
              "[2897 rows x 3 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-343937b4-28e1-4c31-a102-9574296fc55e\" 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>L06_347</th>\n",
              "      <th>LS06_347</th>\n",
              "      <th>LS06_348</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Time</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2009-01-01 00:00:00</th>\n",
              "      <td>0.137417</td>\n",
              "      <td>0.097500</td>\n",
              "      <td>0.016833</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2009-01-01 03:00:00</th>\n",
              "      <td>0.131250</td>\n",
              "      <td>0.088833</td>\n",
              "      <td>0.016417</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2009-01-01 06:00:00</th>\n",
              "      <td>0.113500</td>\n",
              "      <td>0.091250</td>\n",
              "      <td>0.016750</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2009-01-01 09:00:00</th>\n",
              "      <td>0.135750</td>\n",
              "      <td>0.091500</td>\n",
              "      <td>0.016250</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2009-01-01 12:00:00</th>\n",
              "      <td>0.140917</td>\n",
              "      <td>0.096167</td>\n",
              "      <td>0.017000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-01 12:00:00</th>\n",
              "      <td>1.710000</td>\n",
              "      <td>1.710000</td>\n",
              "      <td>0.129583</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-01 15:00:00</th>\n",
              "      <td>1.420000</td>\n",
              "      <td>1.420000</td>\n",
              "      <td>0.096333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-01 18:00:00</th>\n",
              "      <td>1.178583</td>\n",
              "      <td>1.178583</td>\n",
              "      <td>0.083083</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-01 21:00:00</th>\n",
              "      <td>0.898250</td>\n",
              "      <td>0.898250</td>\n",
              "      <td>0.077167</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-02 00:00:00</th>\n",
              "      <td>0.860000</td>\n",
              "      <td>0.860000</td>\n",
              "      <td>0.075000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>2897 rows × 3 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-343937b4-28e1-4c31-a102-9574296fc55e')\"\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-343937b4-28e1-4c31-a102-9574296fc55e 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-343937b4-28e1-4c31-a102-9574296fc55e');\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-c6b9d296-1afe-4ec9-a68b-9baacb91bcaa\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-c6b9d296-1afe-4ec9-a68b-9baacb91bcaa')\"\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-c6b9d296-1afe-4ec9-a68b-9baacb91bcaa button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "  <div id=\"id_fac028f7-f9bb-4177-961a-40967aff6813\">\n",
              "    <style>\n",
              "      .colab-df-generate {\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-generate: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",
              "      [theme=dark] .colab-df-generate {\n",
              "        background-color: #3B4455;\n",
              "        fill: #D2E3FC;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate: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",
              "    <button class=\"colab-df-generate\" onclick=\"generateWithVariable('data4')\"\n",
              "            title=\"Generate code using this dataframe.\"\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",
              "    <path d=\"M7,19H8.4L18.45,9,17,7.55,7,17.6ZM5,21V16.75L18.45,3.32a2,2,0,0,1,2.83,0l1.4,1.43a1.91,1.91,0,0,1,.58,1.4,1.91,1.91,0,0,1-.58,1.4L9.25,21ZM18.45,9,17,7.55Zm-12,3A5.31,5.31,0,0,0,4.9,8.1,5.31,5.31,0,0,0,1,6.5,5.31,5.31,0,0,0,4.9,4.9,5.31,5.31,0,0,0,6.5,1,5.31,5.31,0,0,0,8.1,4.9,5.31,5.31,0,0,0,12,6.5,5.46,5.46,0,0,0,6.5,12Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "    <script>\n",
              "      (() => {\n",
              "      const buttonEl =\n",
              "        document.querySelector('#id_fac028f7-f9bb-4177-961a-40967aff6813 button.colab-df-generate');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      buttonEl.onclick = () => {\n",
              "        google.colab.notebook.generateWithVariable('data4');\n",
              "      }\n",
              "      })();\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "data4",
              "summary": "{\n  \"name\": \"data4\",\n  \"rows\": 2897,\n  \"fields\": [\n    {\n      \"column\": \"Time\",\n      \"properties\": {\n        \"dtype\": \"date\",\n        \"min\": \"2009-01-01 00:00:00\",\n        \"max\": \"2013-01-02 00:00:00\",\n        \"num_unique_values\": 2897,\n        \"samples\": [\n          \"2009-01-18 15:00:00\",\n          \"2012-02-09 15:00:00\",\n          \"2012-03-18 15:00:00\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"L06_347\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.7161993671029363,\n        \"min\": 0.0421666666666666,\n        \"max\": 10.365,\n        \"num_unique_values\": 2342,\n        \"samples\": [\n          0.3905833333333333,\n          0.3933333333333333,\n          0.2339166666666666\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LS06_347\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.7330698516846968,\n        \"min\": 0.0447499999999999,\n        \"max\": 10.251666666666669,\n        \"num_unique_values\": 2329,\n        \"samples\": [\n          0.5420833333333334,\n          0.669,\n          0.3100833333333334\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LS06_348\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.041861469297186996,\n        \"min\": 0.0080833333333333,\n        \"max\": 0.6375000000000001,\n        \"num_unique_values\": 833,\n        \"samples\": [\n          0.0535,\n          0.0096666666666666,\n          0.0379166666666666\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 22
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Exercise 4\n",
        "#select all 'daytime' data (between 8h and 20h) for all days\n",
        "\n",
        "data5 = data1[(data1.index.hour >= 8) & (data1.index.hour <= 20)]\n",
        "data5"
      ],
      "metadata": {
        "id": "xpY2ZhcWIlgT",
        "outputId": "f6075af3-abd6-4760-9253-c6abc82d7ba7",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 455
        }
      },
      "execution_count": 23,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                      L06_347  LS06_347  LS06_348\n",
              "Time                                             \n",
              "2009-01-01 09:00:00  0.135750  0.091500  0.016250\n",
              "2009-01-01 12:00:00  0.140917  0.096167  0.017000\n",
              "2009-01-01 15:00:00  0.099167  0.091667  0.017583\n",
              "2009-01-01 18:00:00  0.132667  0.090167  0.016250\n",
              "2009-01-02 09:00:00  0.141917  0.097083  0.016417\n",
              "...                       ...       ...       ...\n",
              "2012-12-31 18:00:00  0.617333  0.617333  0.060583\n",
              "2013-01-01 09:00:00  2.055000  2.055000  0.175667\n",
              "2013-01-01 12:00:00  1.710000  1.710000  0.129583\n",
              "2013-01-01 15:00:00  1.420000  1.420000  0.096333\n",
              "2013-01-01 18:00:00  1.178583  1.178583  0.083083\n",
              "\n",
              "[5848 rows x 3 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-37becee6-487d-421a-b6e7-a39fe98d1a69\" 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>L06_347</th>\n",
              "      <th>LS06_347</th>\n",
              "      <th>LS06_348</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Time</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2009-01-01 09:00:00</th>\n",
              "      <td>0.135750</td>\n",
              "      <td>0.091500</td>\n",
              "      <td>0.016250</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2009-01-01 12:00:00</th>\n",
              "      <td>0.140917</td>\n",
              "      <td>0.096167</td>\n",
              "      <td>0.017000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2009-01-01 15:00:00</th>\n",
              "      <td>0.099167</td>\n",
              "      <td>0.091667</td>\n",
              "      <td>0.017583</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2009-01-01 18:00:00</th>\n",
              "      <td>0.132667</td>\n",
              "      <td>0.090167</td>\n",
              "      <td>0.016250</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2009-01-02 09:00:00</th>\n",
              "      <td>0.141917</td>\n",
              "      <td>0.097083</td>\n",
              "      <td>0.016417</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2012-12-31 18:00:00</th>\n",
              "      <td>0.617333</td>\n",
              "      <td>0.617333</td>\n",
              "      <td>0.060583</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-01 09:00:00</th>\n",
              "      <td>2.055000</td>\n",
              "      <td>2.055000</td>\n",
              "      <td>0.175667</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-01 12:00:00</th>\n",
              "      <td>1.710000</td>\n",
              "      <td>1.710000</td>\n",
              "      <td>0.129583</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-01 15:00:00</th>\n",
              "      <td>1.420000</td>\n",
              "      <td>1.420000</td>\n",
              "      <td>0.096333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2013-01-01 18:00:00</th>\n",
              "      <td>1.178583</td>\n",
              "      <td>1.178583</td>\n",
              "      <td>0.083083</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5848 rows × 3 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-37becee6-487d-421a-b6e7-a39fe98d1a69')\"\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-37becee6-487d-421a-b6e7-a39fe98d1a69 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-37becee6-487d-421a-b6e7-a39fe98d1a69');\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-57fe175e-2308-4acf-9153-bdc728973c9a\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-57fe175e-2308-4acf-9153-bdc728973c9a')\"\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-57fe175e-2308-4acf-9153-bdc728973c9a button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "  <div id=\"id_e0ade5df-8704-4ca8-8576-c80e8e9a8c6d\">\n",
              "    <style>\n",
              "      .colab-df-generate {\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-generate: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",
              "      [theme=dark] .colab-df-generate {\n",
              "        background-color: #3B4455;\n",
              "        fill: #D2E3FC;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate: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",
              "    <button class=\"colab-df-generate\" onclick=\"generateWithVariable('data5')\"\n",
              "            title=\"Generate code using this dataframe.\"\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",
              "    <path d=\"M7,19H8.4L18.45,9,17,7.55,7,17.6ZM5,21V16.75L18.45,3.32a2,2,0,0,1,2.83,0l1.4,1.43a1.91,1.91,0,0,1,.58,1.4,1.91,1.91,0,0,1-.58,1.4L9.25,21ZM18.45,9,17,7.55Zm-12,3A5.31,5.31,0,0,0,4.9,8.1,5.31,5.31,0,0,0,1,6.5,5.31,5.31,0,0,0,4.9,4.9,5.31,5.31,0,0,0,6.5,1,5.31,5.31,0,0,0,8.1,4.9,5.31,5.31,0,0,0,12,6.5,5.46,5.46,0,0,0,6.5,12Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "    <script>\n",
              "      (() => {\n",
              "      const buttonEl =\n",
              "        document.querySelector('#id_e0ade5df-8704-4ca8-8576-c80e8e9a8c6d button.colab-df-generate');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      buttonEl.onclick = () => {\n",
              "        google.colab.notebook.generateWithVariable('data5');\n",
              "      }\n",
              "      })();\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "data5",
              "summary": "{\n  \"name\": \"data5\",\n  \"rows\": 5848,\n  \"fields\": [\n    {\n      \"column\": \"Time\",\n      \"properties\": {\n        \"dtype\": \"date\",\n        \"min\": \"2009-01-01 09:00:00\",\n        \"max\": \"2013-01-01 18:00:00\",\n        \"num_unique_values\": 5848,\n        \"samples\": [\n          \"2009-11-30 18:00:00\",\n          \"2009-07-21 18:00:00\",\n          \"2009-10-27 12:00:00\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"L06_347\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.8272921904765825,\n        \"min\": -0.0183333333333333,\n        \"max\": 25.65833333333333,\n        \"num_unique_values\": 3274,\n        \"samples\": [\n          0.1141666666666666,\n          0.0900833333333333,\n          0.1544166666666666\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LS06_347\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.83351855544775,\n        \"min\": 0.035,\n        \"max\": 25.65833333333333,\n        \"num_unique_values\": 3217,\n        \"samples\": [\n          0.0502499999999999,\n          0.8884166666666667,\n          0.2318333333333333\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LS06_348\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.047957914755595764,\n        \"min\": 0.0020833333333333,\n        \"max\": 1.2525,\n        \"num_unique_values\": 1025,\n        \"samples\": [\n          0.0690833333333333,\n          0.0106666666666666,\n          0.04825\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 23
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#IPS\n",
        "def check_password(password):\n",
        "  if not password[0].isalpha():\n",
        "    print(\"Bad\")\n",
        "    return\n",
        "  if len(password) < 8:\n",
        "    print(\"Bad\")\n",
        "    return\n",
        "  if not any(a.isdigit() for a in password):\n",
        "    print(\"Bad\")\n",
        "    return\n",
        "  if not any(a in \"@$!%*?&\" for a in password):\n",
        "    print(\"Bad\")\n",
        "    return\n",
        "  print(\"Good\")\n",
        "\n",
        "password = input()\n",
        "check_password(password)\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "UBQku9ToIv2j",
        "outputId": "66abdaff-d68f-499a-f996-f9b0b72c6daf"
      },
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "a1@defgh\n",
            "Good\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#IPS\n",
        "#using regex\n",
        "\n",
        "import re\n",
        "def check_password(password):\n",
        "  if re.match(r\"^(?=.*[a-zA-Z])(?=.*\\d)(?=.*[@$!%*?&])[A-Za-z\\d@$!%*?&]{8,}$\", password):\n",
        "    print(\"Good\")\n",
        "  else:\n",
        "    print(\"Bad\")\n",
        "\n",
        "password = input()\n",
        "\n",
        "check_password(password)\n",
        "\n"
      ],
      "metadata": {
        "id": "9ciLgFlIMn-y",
        "outputId": "e4bf91d8-1ca9-4158-d703-389ef0e679c6",
        "colab": {
          "base_uri": "https://localhost:8080/"
        }
      },
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "a1234567\n",
            "Bad\n"
          ]
        }
      ]
    }
  ]
}