SEP769_MySQL.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "SEP769_MySQL.ipynb",
      "provenance": [],
      "collapsed_sections": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "mCKzTJn_6VeX"
      },
      "source": [
        "Author: Ernani Fantinatti\n",
        "\n",
        "May 29, 2021\n",
        "\n",
        "---\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "xq3XSAubfrVL"
      },
      "source": [
        "!pip -q install PyMySQL"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "HSwnoxXK2ruK"
      },
      "source": [
        "import matplotlib.pyplot as plt"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "kz-OjEKCf2lW",
        "outputId": "0ea6d4f6-88c5-4c90-a287-918fed661222"
      },
      "source": [
        "%load_ext sql\n",
        "%config SqlMagic.feedback=False \n",
        "%config SqlMagic.autopandas=True\n",
        "%sql mysql+pymysql://ro:ro123@sep769.fantinatti.net/\n",
        "# query using %sql or %%sql\n",
        "df = %sql SELECT * FROM SEP769.SEP769"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "The sql extension is already loaded. To reload it, use:\n",
            "  %reload_ext sql\n",
            "   mysql+pymysql://ro:***@142.93.158.124/\n",
            " * mysql+pymysql://ro:***@sep769.fantinatti.net/\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        },
        "id": "dDtPDvGzgP2U",
        "outputId": "9a741c18-0175-40c4-ffff-d71f4e4ca48f"
      },
      "source": [
        "df"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>Datetime</th>\n",
              "      <th>Height</th>\n",
              "      <th>Flaginout</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>2021-05-28 00:20:38</td>\n",
              "      <td>2.00000</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>2021-05-28 00:20:38</td>\n",
              "      <td>2.00000</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>2021-05-28 00:20:38</td>\n",
              "      <td>2.00000</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4</td>\n",
              "      <td>2021-05-28 00:20:38</td>\n",
              "      <td>2.00000</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5</td>\n",
              "      <td>2021-05-28 00:20:38</td>\n",
              "      <td>2.00000</td>\n",
              "      <td>0</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>5914</th>\n",
              "      <td>5937</td>\n",
              "      <td>2021-05-30 04:06:06</td>\n",
              "      <td>0.16784</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5915</th>\n",
              "      <td>5938</td>\n",
              "      <td>2021-05-30 04:06:16</td>\n",
              "      <td>0.28938</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5916</th>\n",
              "      <td>5939</td>\n",
              "      <td>2021-05-30 04:06:26</td>\n",
              "      <td>0.16726</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5917</th>\n",
              "      <td>5940</td>\n",
              "      <td>2021-05-30 04:06:36</td>\n",
              "      <td>0.25612</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5918</th>\n",
              "      <td>5941</td>\n",
              "      <td>2021-05-30 04:06:46</td>\n",
              "      <td>0.32631</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5919 rows × 4 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "        id            Datetime   Height  Flaginout\n",
              "0        1 2021-05-28 00:20:38  2.00000          0\n",
              "1        2 2021-05-28 00:20:38  2.00000          0\n",
              "2        3 2021-05-28 00:20:38  2.00000          0\n",
              "3        4 2021-05-28 00:20:38  2.00000          0\n",
              "4        5 2021-05-28 00:20:38  2.00000          0\n",
              "...    ...                 ...      ...        ...\n",
              "5914  5937 2021-05-30 04:06:06  0.16784          1\n",
              "5915  5938 2021-05-30 04:06:16  0.28938          1\n",
              "5916  5939 2021-05-30 04:06:26  0.16726          1\n",
              "5917  5940 2021-05-30 04:06:36  0.25612          1\n",
              "5918  5941 2021-05-30 04:06:46  0.32631          1\n",
              "\n",
              "[5919 rows x 4 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 12
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "7_e3GLxX-6az",
        "outputId": "cc97813a-c513-435c-c429-e7beb21df438"
      },
      "source": [
        "%sql mysql+pymysql://ro:ro123@sep769.fantinatti.net/\n",
        "# query using %sql or %%sql\n",
        "df1 = %sql SELECT CAST(DATETIME AS DATE) as DATE, Height, Flaginout FROM SEP769.SEP769"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "   mysql+pymysql://ro:***@142.93.158.124/\n",
            " * mysql+pymysql://ro:***@sep769.fantinatti.net/\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        },
        "id": "bVW_-l2p_GsT",
        "outputId": "f51a1fb5-ca46-4548-ecb2-2ad25f07d9d2"
      },
      "source": [
        "df1"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>DATE</th>\n",
              "      <th>Height</th>\n",
              "      <th>Flaginout</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2021-05-28</td>\n",
              "      <td>2.00000</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2021-05-28</td>\n",
              "      <td>2.00000</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2021-05-28</td>\n",
              "      <td>2.00000</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2021-05-28</td>\n",
              "      <td>2.00000</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2021-05-28</td>\n",
              "      <td>2.00000</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5914</th>\n",
              "      <td>2021-05-30</td>\n",
              "      <td>0.16784</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5915</th>\n",
              "      <td>2021-05-30</td>\n",
              "      <td>0.28938</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5916</th>\n",
              "      <td>2021-05-30</td>\n",
              "      <td>0.16726</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5917</th>\n",
              "      <td>2021-05-30</td>\n",
              "      <td>0.25612</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5918</th>\n",
              "      <td>2021-05-30</td>\n",
              "      <td>0.32631</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5919 rows × 3 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "            DATE   Height  Flaginout\n",
              "0     2021-05-28  2.00000          0\n",
              "1     2021-05-28  2.00000          0\n",
              "2     2021-05-28  2.00000          0\n",
              "3     2021-05-28  2.00000          0\n",
              "4     2021-05-28  2.00000          0\n",
              "...          ...      ...        ...\n",
              "5914  2021-05-30  0.16784          1\n",
              "5915  2021-05-30  0.28938          1\n",
              "5916  2021-05-30  0.16726          1\n",
              "5917  2021-05-30  0.25612          1\n",
              "5918  2021-05-30  0.32631          1\n",
              "\n",
              "[5919 rows x 3 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 350
        },
        "id": "m4zAfOt_2m2J",
        "outputId": "f3aba806-c8ca-42d9-e8e9-474e08e29886"
      },
      "source": [
        "plt.hist(df['Height'])"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(array([3.112e+03, 8.890e+02, 3.020e+02, 3.470e+02, 2.650e+02, 0.000e+00,\n",
              "        0.000e+00, 1.000e+00, 0.000e+00, 1.003e+03]),\n",
              " array([0.10004 , 0.290036, 0.480032, 0.670028, 0.860024, 1.05002 ,\n",
              "        1.240016, 1.430012, 1.620008, 1.810004, 2.      ]),\n",
              " <a list of 10 Patch objects>)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 15
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX0AAAD4CAYAAAAAczaOAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAASXElEQVR4nO3df6zd9X3f8eer/EjXJCpmvmWeMTHpPEVGWoBZhKbRRpIVDFFnom6R0dY4GZPTCaZEqyY5jTSydGhEWssULUWixaqpMijKj8VN3FGXMEVdxA+TOQZDCTeEDFsOdmNCgqKxgd7743ysfXe5P4597z3Xzuf5kI7u97y/n+857+/3Hr/O936/33OcqkKS1IefWekGJEmTY+hLUkcMfUnqiKEvSR0x9CWpI2evdAPzWb16da1fv36l25CkM8pjjz32V1U1Ndu80zr0169fz759+1a6DUk6oyT53lzzPLwjSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdOa0/kbtY63d8dUWe97nb3rcizytJC3FPX5I6YuhLUkcMfUnqyIKhn+RnkzyS5FtJDib5t61+cZKHk0wn+eMk57b6G9r96TZ//eCxPt7qTye5ZrlWSpI0u3H29F8B3lNVbwcuBTYnuRL4NHB7Vf0t4EXgxjb+RuDFVr+9jSPJRmArcAmwGfi9JGct5cpIkua3YOjXyMvt7jntVsB7gM+3+i7g+ja9pd2nzX9vkrT6vVX1SlV9F5gGrliStZAkjWWsY/pJzkqyHzgK7AW+A/ywql5tQw4Ba9v0WuB5gDb/JeCvD+uzLDN8ru1J9iXZd+zYsZNfI0nSnMYK/ap6raouBS5ktHf+tuVqqKrurKpNVbVpamrW/+1LknSKTurqnar6IfAg8EvAeUlOfLjrQuBwmz4MrANo838e+MGwPssykqQJGOfqnakk57Xpvwb8CvAUo/D/R23YNuDLbXp3u0+b/7Wqqlbf2q7uuRjYADyyVCsiSVrYOF/DsAbY1a60+Rngvqr6SpIngXuT/DvgfwB3tfF3AX+UZBo4zuiKHarqYJL7gCeBV4Gbquq1pV0dSdJ8Fgz9qjoAXDZL/Vlmufqmqv4X8I/neKxbgVtPvk1J0lLwE7mS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOLBj6SdYleTDJk0kOJvloq38yyeEk+9vtusEyH08yneTpJNcM6ptbbTrJjuVZJUnSXM4eY8yrwG9W1TeTvBl4LMneNu/2qvoPw8FJNgJbgUuAvwn8eZK/3WZ/FvgV4BDwaJLdVfXkUqyIJGlhC4Z+VR0BjrTpHyd5Clg7zyJbgHur6hXgu0mmgSvavOmqehYgyb1trKEvSRNyUsf0k6wHLgMebqWbkxxIsjPJqlZbCzw/WOxQq81Vn/kc25PsS7Lv2LFjJ9OeJGkBY4d+kjcBXwA+VlU/Au4AfhG4lNFfAr+zFA1V1Z1VtamqNk1NTS3FQ0qSmnGO6ZPkHEaB/7mq+iJAVb0wmP/7wFfa3cPAusHiF7Ya89QlSRMwztU7Ae4Cnqqq3x3U1wyGvR94ok3vBrYmeUOSi4ENwCPAo8CGJBcnOZfRyd7dS7MakqRxjLOn/8vArwOPJ9nfar8F3JDkUqCA54CPAFTVwST3MTpB+ypwU1W9BpDkZuB+4CxgZ1UdXMJ1kSQtYJyrd/4CyCyz9syzzK3ArbPU98y3nCRpefmJXEnqiKEvSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqyIKhn2RdkgeTPJnkYJKPtvr5SfYmeab9XNXqSfKZJNNJDiS5fPBY29r4Z5JsW77VkiTNZpw9/VeB36yqjcCVwE1JNgI7gAeqagPwQLsPcC2wod22A3fA6E0CuAV4B3AFcMuJNwpJ0mQsGPpVdaSqvtmmfww8BawFtgC72rBdwPVtegtwd408BJyXZA1wDbC3qo5X1YvAXmDzkq6NJGleJ3VMP8l64DLgYeCCqjrSZn0fuKBNrwWeHyx2qNXmqs98ju1J9iXZd+zYsZNpT5K0gLFDP8mbgC8AH6uqHw3nVVUBtRQNVdWdVbWpqjZNTU0txUNKkpqxQj/JOYwC/3NV9cVWfqEdtqH9PNrqh4F1g8UvbLW56pKkCRnn6p0AdwFPVdXvDmbtBk5cgbMN+PKg/sF2Fc+VwEvtMND9wNVJVrUTuFe3miRpQs4eY8wvA78OPJ5kf6v9FnAbcF+SG4HvAR9o8/YA1wHTwE+ADwNU1fEkvw082sZ9qqqOL8laSJLGsmDoV9VfAJlj9ntnGV/ATXM81k5g58k0KElaOn4iV5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1JEFQz/JziRHkzwxqH0yyeEk+9vtusG8jyeZTvJ0kmsG9c2tNp1kx9KviiRpIePs6f8hsHmW+u1VdWm77QFIshHYClzSlvm9JGclOQv4LHAtsBG4oY2VJE3Q2QsNqKqvJ1k/5uNtAe6tqleA7yaZBq5o86ar6lmAJPe2sU+edMeSpFO2mGP6Nyc50A7/rGq1tcDzgzGHWm2u+usk2Z5kX5J9x44dW0R7kqSZTjX07wB+EbgUOAL8zlI1VFV3VtWmqto0NTW1VA8rSWKMwzuzqaoXTkwn+X3gK+3uYWDdYOiFrcY8dUnShJzSnn6SNYO77wdOXNmzG9ia5A1JLgY2AI8AjwIbklyc5FxGJ3t3n3rbkqRTseCefpJ7gKuA1UkOAbcAVyW5FCjgOeAjAFV1MMl9jE7QvgrcVFWvtce5GbgfOAvYWVUHl3xtJEnzGufqnRtmKd81z/hbgVtnqe8B9pxUd5KkJeUnciWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR1ZMPST7ExyNMkTg9r5SfYmeab9XNXqSfKZJNNJDiS5fLDMtjb+mSTblmd1JEnzGWdP/w+BzTNqO4AHqmoD8EC7D3AtsKHdtgN3wOhNArgFeAdwBXDLiTcKSdLkLBj6VfV14PiM8hZgV5veBVw/qN9dIw8B5yVZA1wD7K2q41X1IrCX17+RSJKW2dmnuNwFVXWkTX8fuKBNrwWeH4w71Gpz1V8nyXZGfyVw0UUXnWJ7krQ01u/46oo873O3vW9ZHnfRJ3KrqoBagl5OPN6dVbWpqjZNTU0t1cNKkjj10H+hHbah/Tza6oeBdYNxF7baXHVJ0gSdaujvBk5cgbMN+PKg/sF2Fc+VwEvtMND9wNVJVrUTuFe3miRpghY8pp/kHuAqYHWSQ4yuwrkNuC/JjcD3gA+04XuA64Bp4CfAhwGq6niS3wYebeM+VVUzTw5LkpbZgqFfVTfMMeu9s4wt4KY5HmcnsPOkupMkLSk/kStJHTH0Jakjp3qdvuaxUtf1wvJd2yvpp4N7+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdWVToJ3kuyeNJ9ifZ12rnJ9mb5Jn2c1WrJ8lnkkwnOZDk8qVYAUnS+JZiT//dVXVpVW1q93cAD1TVBuCBdh/gWmBDu20H7liC55YknYTlOLyzBdjVpncB1w/qd9fIQ8B5SdYsw/NLkuaw2NAv4M+SPJZke6tdUFVH2vT3gQva9Frg+cGyh1pNkjQhZy9y+XdV1eEkvwDsTfKXw5lVVUnqZB6wvXlsB7jooosW2Z4kaWhRe/pVdbj9PAp8CbgCeOHEYZv282gbfhhYN1j8wlab+Zh3VtWmqto0NTW1mPYkSTOccugneWOSN5+YBq4GngB2A9vasG3Al9v0buCD7SqeK4GXBoeBJEkTsJjDOxcAX0py4nH+c1X91ySPAvcluRH4HvCBNn4PcB0wDfwE+PAinluSdApOOfSr6lng7bPUfwC8d5Z6ATed6vNJkhbPT+RKUkcMfUnqiKEvSR0x9CWpI4a+JHVksZ/IlQBYv+OrK/K8z932vhV5XulM5Z6+JHXE0Jekjnh456fMSh1mkXRmcE9fkjrinr7OaCv5l40nkXUmck9fkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+JHVk4qGfZHOSp5NMJ9kx6eeXpJ5NNPSTnAV8FrgW2AjckGTjJHuQpJ5Nek//CmC6qp6tqv8N3AtsmXAPktStSf/PWWuB5wf3DwHvGA5Ish3Y3u6+nOTpCfV2KlYDf7XSTczD/hZn3v7y6Ql2MrszevudBk7r/vLpRfX3lrlmnHb/XWJV3QncudJ9jCPJvqratNJ9zMX+Fsf+Fsf+Fme5+pv04Z3DwLrB/QtbTZI0AZMO/UeBDUkuTnIusBXYPeEeJKlbEz28U1WvJrkZuB84C9hZVQcn2cMSO90PQ9nf4tjf4tjf4ixLf6mq5XhcSdJpyE/kSlJHDH1J6oihP4uFvioiyb9K8mSSA0keSPKWwbzXkuxvt2U5ST1Gfx9KcmzQxz8fzNuW5Jl227ZC/d0+6O3bSX44mDeJ7bczydEkT8wxP0k+0/o/kOTywbxJbL+F+vsnra/Hk3wjydsH855r9f1J9q1Qf1cleWnwe/w3g3nL/jUsY/T3rwe9PdFec+e3eZPYfuuSPNgy5GCSj84yZvleg1XlbXBjdIL5O8BbgXOBbwEbZ4x5N/BzbfpfAH88mPfyadDfh4D/NMuy5wPPtp+r2vSqSfc3Y/y/ZHRCfyLbrz3H3wMuB56YY/51wJ8CAa4EHp7U9huzv3eeeF5GX2ny8GDec8DqFd5+VwFfWexrY7n6mzH2V4GvTXj7rQEub9NvBr49y7/hZXsNuqf/egt+VURVPVhVP2l3H2L0eYPTpr95XAPsrarjVfUisBfYvML93QDcs8Q9zKuqvg4cn2fIFuDuGnkIOC/JGiaz/Rbsr6q+0Z4fJv/6G2f7zWUiX8Nykv2txOvvSFV9s03/GHiK0bcVDC3ba9DQf73Zvipi5i9k6EZG78gn/GySfUkeSnL9Cvb3a+3Pws8nOfGBuJNdt+Xsj3ZY7GLga4Pycm+/ccy1DpPYfidr5uuvgD9L8lhGX2myUn4pybeS/GmSS1rttNp+SX6OUWB+YVCe6PZLsh64DHh4xqxlew2edl/DcCZJ8k+BTcDfH5TfUlWHk7wV+FqSx6vqOxNu7U+Ae6rqlSQfAXYB75lwD+PYCny+ql4b1E6H7XdGSPJuRqH/rkH5XW37/QKwN8lftj3fSfomo9/jy0muA/4LsGHCPYzjV4H/XlXDvwomtv2SvInRG87HqupHy/Ecs3FP//XG+qqIJP8A+ATwD6vqlRP1qjrcfj4L/DdG7+IT7a+qfjDo6Q+AvzvuspPob2ArM/60nsD2G8dc63DafI1Ikr/D6He7pap+cKI+2H5HgS8xOqQyUVX1o6p6uU3vAc5JsprTaPs1873+lnX7JTmHUeB/rqq+OMuQ5XsNLucJizPxxuivn2cZHXY4cbLpkhljLmN0QmrDjPoq4A1tejXwDEt8omrM/tYMpt8PPFT/7yTQd1ufq9r0+ZPur417G6OTZpnk9hs813rmPhH5Pv7/k2iPTGr7jdnfRcA08M4Z9TcCbx5MfwPYvAL9/Y0Tv1dGofk/27Yc67Wx3P21+T/P6Lj/Gye9/dq2uBv4j/OMWbbX4JJv7J+GG6Mz599mFOyfaLVPMdqrB/hz4AVgf7vtbvV3Ao+3F/PjwI0r1N+/Bw62Ph4E3jZY9p+1wJgGPrwS/bX7nwRum7HcpLbfPcAR4P8wOiZ6I/AbwG+0+WH0n/18p/WxacLbb6H+/gB4cfD629fqb23b7lvt9/+JFerv5sHr7yEGb06zvTYm3V8b8yHg3hnLTWr7vYvRuYMDg9/hdZN6Dfo1DJLUEY/pS1JHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUkf8LT5VR+kWy8wYAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 173
        },
        "id": "xfFHqVZr2YGm",
        "outputId": "21a21b29-899a-4ecf-b921-82ed53bc0c72"
      },
      "source": [
        "df1[['DATE','Height']].groupby(['DATE']).mean()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Height</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>DATE</th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2021-05-28</th>\n",
              "      <td>0.693989</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021-05-29</th>\n",
              "      <td>0.329837</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021-05-30</th>\n",
              "      <td>0.321542</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "              Height\n",
              "DATE                \n",
              "2021-05-28  0.693989\n",
              "2021-05-29  0.329837\n",
              "2021-05-30  0.321542"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 16
        }
      ]
    }
  ]
}