Pandas_DF_Analysis_and_Styling.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyPJVcysWddktNU25FKGZKDV",
      "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/Tor-Storli/COLAB_DEMOS/blob/master/Pandas_DF_Analysis_and_Styling.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Install kaggle library\n"
      ],
      "metadata": {
        "id": "1s7pqJLLf-u0"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "!pip install kaggle"
      ],
      "metadata": {
        "id": "c_OOm-Ofczlm",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "077bd233-f640-4905-b9b0-9c12f1210b2c"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Looking in indexes: https://pypi.org/simple, https://us-python.pkg.dev/colab-wheels/public/simple/\n",
            "Requirement already satisfied: kaggle in /usr/local/lib/python3.8/dist-packages (1.5.12)\n",
            "Requirement already satisfied: certifi in /usr/local/lib/python3.8/dist-packages (from kaggle) (2022.12.7)\n",
            "Requirement already satisfied: urllib3 in /usr/local/lib/python3.8/dist-packages (from kaggle) (1.24.3)\n",
            "Requirement already satisfied: python-dateutil in /usr/local/lib/python3.8/dist-packages (from kaggle) (2.8.2)\n",
            "Requirement already satisfied: python-slugify in /usr/local/lib/python3.8/dist-packages (from kaggle) (8.0.0)\n",
            "Requirement already satisfied: six>=1.10 in /usr/local/lib/python3.8/dist-packages (from kaggle) (1.15.0)\n",
            "Requirement already satisfied: tqdm in /usr/local/lib/python3.8/dist-packages (from kaggle) (4.64.1)\n",
            "Requirement already satisfied: requests in /usr/local/lib/python3.8/dist-packages (from kaggle) (2.25.1)\n",
            "Requirement already satisfied: text-unidecode>=1.3 in /usr/local/lib/python3.8/dist-packages (from python-slugify->kaggle) (1.3)\n",
            "Requirement already satisfied: chardet<5,>=3.0.2 in /usr/local/lib/python3.8/dist-packages (from requests->kaggle) (4.0.0)\n",
            "Requirement already satisfied: idna<3,>=2.5 in /usr/local/lib/python3.8/dist-packages (from requests->kaggle) (2.10)\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "from google.colab import drive\n",
        "drive.mount('/content/drive')"
      ],
      "metadata": {
        "id": "7sP7b7hLgGsY",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "afd8789e-4a1f-43e9-cbb1-f4edd62fbe1b"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Mounted at /content/drive\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Create a temporary directory on this runtime"
      ],
      "metadata": {
        "id": "aQGfFXL6mxem"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "!mkdir ~/.kaggle"
      ],
      "metadata": {
        "id": "qNnkit-mmxp9",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "b3829c63-2ec2-4da5-cf19-7f3e9de35887"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "mkdir: cannot create directory ‘/root/.kaggle’: File exists\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Copy the kaggle.json API file over to the temporary directory on this runtime. It will not show up (it is hidden)\n"
      ],
      "metadata": {
        "id": "cOKbEMpUiNcZ"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "!cp /content/drive/MyDrive/kaggle/kaggle.json  ~/.kaggle/kaggle.json"
      ],
      "metadata": {
        "id": "ESqyDe7KgGzq"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "#### *<font color='orange'>(Tor)</font> I asked ChatGPT to explain what the <font color='yellow'>`!chmod 600`</font> command means. Here is what it said:*<br><br><font color='lightblue'>(ChatGPT)</font> Set permission security for accessing the file. The  <font color='yellow'>`chmod 600`</font> command in Google Colab changes the permissions of a file to allow only the owner to read and write to the file. The number 600 is an octal representation of the permissions, where 6 represents the permissions for the owner, 0 for the group and other users. In this case, the 6 means the owner has read and write permissions (rw-), while the group and others have no permissions (---). The chmod command is commonly used in Unix-based systems to change the permissions of files and directories.\n"
      ],
      "metadata": {
        "id": "81QGKy63jVno"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "! chmod 600 ~/.kaggle/kaggle.json"
      ],
      "metadata": {
        "id": "r11bCW3TjV83"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Download Dataset from kaggle"
      ],
      "metadata": {
        "id": "nHXV0b47rw_Y"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "! kaggle datasets download -d psycon/daily-coffee-price"
      ],
      "metadata": {
        "id": "c0t5qimnczsM",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "9814ff8f-8330-4a39-930a-92d4181fe80e"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Downloading daily-coffee-price.zip to /content\n",
            "\r  0% 0.00/72.5k [00:00<?, ?B/s]\r100% 72.5k/72.5k [00:00<00:00, 476kB/s]\n",
            "\r100% 72.5k/72.5k [00:00<00:00, 475kB/s]\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Refresh your Runtime folders. Next, let us unzip the data and refresh the folders. You should now see the unzipped file(s)."
      ],
      "metadata": {
        "id": "-nUkA_8mu1Th"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "! unzip daily-coffee-price.zip"
      ],
      "metadata": {
        "id": "3mtQk3fdu1lJ",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "ce24e161-a8f1-46ec-9497-da1abcb6e55f"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Archive:  daily-coffee-price.zip\n",
            "  inflating: coffee.csv              \n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Import Libraries"
      ],
      "metadata": {
        "id": "pmh_Edq0dSeC"
      }
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "gO-aqZUDcgZe"
      },
      "outputs": [],
      "source": [
        "import numpy as np\n",
        "import pandas as pd\n",
        "import matplotlib.pyplot as plt\n",
        "import seaborn as sns\n",
        "import os"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Create a padas DataFrame"
      ],
      "metadata": {
        "id": "3S63PqY6vmhU"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df = pd.read_csv('/content/coffee.csv', index_col='Date')\n",
        "df.head(20)"
      ],
      "metadata": {
        "id": "teTy0B5HczpF"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [],
      "metadata": {
        "id": "jJLUtpf-B15n"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "from google.colab import data_table\n",
        "data_table.DataTable(df.head(20), include_index=False, num_rows_per_page=10)"
      ],
      "metadata": {
        "id": "HXtnWKCkB1pu",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 312
        },
        "outputId": "4bbd9b97-59fe-45cf-a639-c0372497d2f6"
      },
      "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>Open</th>\n",
              "      <th>High</th>\n",
              "      <th>Low</th>\n",
              "      <th>Close</th>\n",
              "      <th>Volume</th>\n",
              "      <th>Currency</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Date</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2000-01-03</th>\n",
              "      <td>122.25</td>\n",
              "      <td>124.00</td>\n",
              "      <td>116.10</td>\n",
              "      <td>116.50</td>\n",
              "      <td>6640</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-04</th>\n",
              "      <td>116.25</td>\n",
              "      <td>120.50</td>\n",
              "      <td>115.75</td>\n",
              "      <td>116.25</td>\n",
              "      <td>5492</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-05</th>\n",
              "      <td>115.00</td>\n",
              "      <td>121.00</td>\n",
              "      <td>115.00</td>\n",
              "      <td>118.60</td>\n",
              "      <td>6165</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-06</th>\n",
              "      <td>119.00</td>\n",
              "      <td>121.40</td>\n",
              "      <td>116.50</td>\n",
              "      <td>116.85</td>\n",
              "      <td>5094</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-07</th>\n",
              "      <td>117.25</td>\n",
              "      <td>117.75</td>\n",
              "      <td>113.80</td>\n",
              "      <td>114.15</td>\n",
              "      <td>6855</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-10</th>\n",
              "      <td>123.50</td>\n",
              "      <td>126.00</td>\n",
              "      <td>116.70</td>\n",
              "      <td>117.55</td>\n",
              "      <td>7499</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-11</th>\n",
              "      <td>115.50</td>\n",
              "      <td>118.25</td>\n",
              "      <td>115.50</td>\n",
              "      <td>117.80</td>\n",
              "      <td>3976</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-12</th>\n",
              "      <td>117.80</td>\n",
              "      <td>120.50</td>\n",
              "      <td>116.90</td>\n",
              "      <td>118.95</td>\n",
              "      <td>5184</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-13</th>\n",
              "      <td>119.25</td>\n",
              "      <td>120.00</td>\n",
              "      <td>117.50</td>\n",
              "      <td>118.55</td>\n",
              "      <td>3717</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-14</th>\n",
              "      <td>117.75</td>\n",
              "      <td>120.25</td>\n",
              "      <td>112.25</td>\n",
              "      <td>112.55</td>\n",
              "      <td>10115</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-18</th>\n",
              "      <td>111.75</td>\n",
              "      <td>118.25</td>\n",
              "      <td>110.60</td>\n",
              "      <td>115.75</td>\n",
              "      <td>7364</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-19</th>\n",
              "      <td>116.50</td>\n",
              "      <td>118.25</td>\n",
              "      <td>114.75</td>\n",
              "      <td>116.70</td>\n",
              "      <td>6626</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-20</th>\n",
              "      <td>118.25</td>\n",
              "      <td>118.80</td>\n",
              "      <td>111.70</td>\n",
              "      <td>112.00</td>\n",
              "      <td>8834</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-21</th>\n",
              "      <td>112.00</td>\n",
              "      <td>113.50</td>\n",
              "      <td>110.80</td>\n",
              "      <td>111.20</td>\n",
              "      <td>5625</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-24</th>\n",
              "      <td>110.95</td>\n",
              "      <td>114.40</td>\n",
              "      <td>110.95</td>\n",
              "      <td>111.90</td>\n",
              "      <td>5821</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-25</th>\n",
              "      <td>111.60</td>\n",
              "      <td>113.70</td>\n",
              "      <td>111.60</td>\n",
              "      <td>112.85</td>\n",
              "      <td>4014</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-26</th>\n",
              "      <td>112.50</td>\n",
              "      <td>115.30</td>\n",
              "      <td>111.90</td>\n",
              "      <td>115.15</td>\n",
              "      <td>5796</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-27</th>\n",
              "      <td>114.75</td>\n",
              "      <td>116.40</td>\n",
              "      <td>112.80</td>\n",
              "      <td>114.60</td>\n",
              "      <td>5477</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-28</th>\n",
              "      <td>115.10</td>\n",
              "      <td>115.40</td>\n",
              "      <td>113.70</td>\n",
              "      <td>114.70</td>\n",
              "      <td>3334</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-31</th>\n",
              "      <td>113.75</td>\n",
              "      <td>114.00</td>\n",
              "      <td>110.50</td>\n",
              "      <td>111.10</td>\n",
              "      <td>6465</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "application/vnd.google.colaboratory.module+javascript": "\n      import \"https://ssl.gstatic.com/colaboratory/data_table/fb998edc550c7947/data_table.js\";\n\n      window.createDataTable({\n        data: [[{\n            'v': 122.25,\n            'f': \"122.25\",\n        },\n{\n            'v': 124.0,\n            'f': \"124.0\",\n        },\n{\n            'v': 116.1,\n            'f': \"116.1\",\n        },\n{\n            'v': 116.5,\n            'f': \"116.5\",\n        },\n{\n            'v': 6640,\n            'f': \"6640\",\n        },\n\"USD\"],\n [{\n            'v': 116.25,\n            'f': \"116.25\",\n        },\n{\n            'v': 120.5,\n            'f': \"120.5\",\n        },\n{\n            'v': 115.75,\n            'f': \"115.75\",\n        },\n{\n            'v': 116.25,\n            'f': \"116.25\",\n        },\n{\n            'v': 5492,\n            'f': \"5492\",\n        },\n\"USD\"],\n [{\n            'v': 115.0,\n            'f': \"115.0\",\n        },\n{\n            'v': 121.0,\n            'f': \"121.0\",\n        },\n{\n            'v': 115.0,\n            'f': \"115.0\",\n        },\n{\n            'v': 118.6,\n            'f': \"118.6\",\n        },\n{\n            'v': 6165,\n            'f': \"6165\",\n        },\n\"USD\"],\n [{\n            'v': 119.0,\n            'f': \"119.0\",\n        },\n{\n            'v': 121.4,\n            'f': \"121.4\",\n        },\n{\n            'v': 116.5,\n            'f': \"116.5\",\n        },\n{\n            'v': 116.85,\n            'f': \"116.85\",\n        },\n{\n            'v': 5094,\n            'f': \"5094\",\n        },\n\"USD\"],\n [{\n            'v': 117.25,\n            'f': \"117.25\",\n        },\n{\n            'v': 117.75,\n            'f': \"117.75\",\n        },\n{\n            'v': 113.8,\n            'f': \"113.8\",\n        },\n{\n            'v': 114.15,\n            'f': \"114.15\",\n        },\n{\n            'v': 6855,\n            'f': \"6855\",\n        },\n\"USD\"],\n [{\n            'v': 123.5,\n            'f': \"123.5\",\n        },\n{\n            'v': 126.0,\n            'f': \"126.0\",\n        },\n{\n            'v': 116.7,\n            'f': \"116.7\",\n        },\n{\n            'v': 117.55,\n            'f': \"117.55\",\n        },\n{\n            'v': 7499,\n            'f': \"7499\",\n        },\n\"USD\"],\n [{\n            'v': 115.5,\n            'f': \"115.5\",\n        },\n{\n            'v': 118.25,\n            'f': \"118.25\",\n        },\n{\n            'v': 115.5,\n            'f': \"115.5\",\n        },\n{\n            'v': 117.8,\n            'f': \"117.8\",\n        },\n{\n            'v': 3976,\n            'f': \"3976\",\n        },\n\"USD\"],\n [{\n            'v': 117.8,\n            'f': \"117.8\",\n        },\n{\n            'v': 120.5,\n            'f': \"120.5\",\n        },\n{\n            'v': 116.9,\n            'f': \"116.9\",\n        },\n{\n            'v': 118.95,\n            'f': \"118.95\",\n        },\n{\n            'v': 5184,\n            'f': \"5184\",\n        },\n\"USD\"],\n [{\n            'v': 119.25,\n            'f': \"119.25\",\n        },\n{\n            'v': 120.0,\n            'f': \"120.0\",\n        },\n{\n            'v': 117.5,\n            'f': \"117.5\",\n        },\n{\n            'v': 118.55,\n            'f': \"118.55\",\n        },\n{\n            'v': 3717,\n            'f': \"3717\",\n        },\n\"USD\"],\n [{\n            'v': 117.75,\n            'f': \"117.75\",\n        },\n{\n            'v': 120.25,\n            'f': \"120.25\",\n        },\n{\n            'v': 112.25,\n            'f': \"112.25\",\n        },\n{\n            'v': 112.55,\n            'f': \"112.55\",\n        },\n{\n            'v': 10115,\n            'f': \"10115\",\n        },\n\"USD\"],\n [{\n            'v': 111.75,\n            'f': \"111.75\",\n        },\n{\n            'v': 118.25,\n            'f': \"118.25\",\n        },\n{\n            'v': 110.6,\n            'f': \"110.6\",\n        },\n{\n            'v': 115.75,\n            'f': \"115.75\",\n        },\n{\n            'v': 7364,\n            'f': \"7364\",\n        },\n\"USD\"],\n [{\n            'v': 116.5,\n            'f': \"116.5\",\n        },\n{\n            'v': 118.25,\n            'f': \"118.25\",\n        },\n{\n            'v': 114.75,\n            'f': \"114.75\",\n        },\n{\n            'v': 116.7,\n            'f': \"116.7\",\n        },\n{\n            'v': 6626,\n            'f': \"6626\",\n        },\n\"USD\"],\n [{\n            'v': 118.25,\n            'f': \"118.25\",\n        },\n{\n            'v': 118.8,\n            'f': \"118.8\",\n        },\n{\n            'v': 111.7,\n            'f': \"111.7\",\n        },\n{\n            'v': 112.0,\n            'f': \"112.0\",\n        },\n{\n            'v': 8834,\n            'f': \"8834\",\n        },\n\"USD\"],\n [{\n            'v': 112.0,\n            'f': \"112.0\",\n        },\n{\n            'v': 113.5,\n            'f': \"113.5\",\n        },\n{\n            'v': 110.8,\n            'f': \"110.8\",\n        },\n{\n            'v': 111.2,\n            'f': \"111.2\",\n        },\n{\n            'v': 5625,\n            'f': \"5625\",\n        },\n\"USD\"],\n [{\n            'v': 110.95,\n            'f': \"110.95\",\n        },\n{\n            'v': 114.4,\n            'f': \"114.4\",\n        },\n{\n            'v': 110.95,\n            'f': \"110.95\",\n        },\n{\n            'v': 111.9,\n            'f': \"111.9\",\n        },\n{\n            'v': 5821,\n            'f': \"5821\",\n        },\n\"USD\"],\n [{\n            'v': 111.6,\n            'f': \"111.6\",\n        },\n{\n            'v': 113.7,\n            'f': \"113.7\",\n        },\n{\n            'v': 111.6,\n            'f': \"111.6\",\n        },\n{\n            'v': 112.85,\n            'f': \"112.85\",\n        },\n{\n            'v': 4014,\n            'f': \"4014\",\n        },\n\"USD\"],\n [{\n            'v': 112.5,\n            'f': \"112.5\",\n        },\n{\n            'v': 115.3,\n            'f': \"115.3\",\n        },\n{\n            'v': 111.9,\n            'f': \"111.9\",\n        },\n{\n            'v': 115.15,\n            'f': \"115.15\",\n        },\n{\n            'v': 5796,\n            'f': \"5796\",\n        },\n\"USD\"],\n [{\n            'v': 114.75,\n            'f': \"114.75\",\n        },\n{\n            'v': 116.4,\n            'f': \"116.4\",\n        },\n{\n            'v': 112.8,\n            'f': \"112.8\",\n        },\n{\n            'v': 114.6,\n            'f': \"114.6\",\n        },\n{\n            'v': 5477,\n            'f': \"5477\",\n        },\n\"USD\"],\n [{\n            'v': 115.1,\n            'f': \"115.1\",\n        },\n{\n            'v': 115.4,\n            'f': \"115.4\",\n        },\n{\n            'v': 113.7,\n            'f': \"113.7\",\n        },\n{\n            'v': 114.7,\n            'f': \"114.7\",\n        },\n{\n            'v': 3334,\n            'f': \"3334\",\n        },\n\"USD\"],\n [{\n            'v': 113.75,\n            'f': \"113.75\",\n        },\n{\n            'v': 114.0,\n            'f': \"114.0\",\n        },\n{\n            'v': 110.5,\n            'f': \"110.5\",\n        },\n{\n            'v': 111.1,\n            'f': \"111.1\",\n        },\n{\n            'v': 6465,\n            'f': \"6465\",\n        },\n\"USD\"]],\n        columns: [[\"number\", \"Open\"], [\"number\", \"High\"], [\"number\", \"Low\"], [\"number\", \"Close\"], [\"number\", \"Volume\"], [\"string\", \"Currency\"]],\n        columnOptions: [],\n        rowsPerPage: 10,\n        helpUrl: \"https://colab.research.google.com/notebooks/data_table.ipynb\",\n        suppressOutputScrolling: true,\n        minimumWidth: undefined,\n      });\n    ",
            "text/plain": [
              "<google.colab.data_table.DataTable object>"
            ]
          },
          "metadata": {},
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [],
      "metadata": {
        "id": "YlpUbhSDCC6B"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Enable Colab DataTable and display the pandas DataFrame"
      ],
      "metadata": {
        "id": "LC-C2SlyCVRP"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "data_table.enable_dataframe_formatter()\n",
        "df.head(20)"
      ],
      "metadata": {
        "id": "5EdTS-TDCDGj",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 515
        },
        "outputId": "963c8901-8221-4e7d-bed9-5d765b7ad45d"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "              Open    High     Low   Close  Volume Currency\n",
              "Date                                                       \n",
              "2000-01-03  122.25  124.00  116.10  116.50    6640      USD\n",
              "2000-01-04  116.25  120.50  115.75  116.25    5492      USD\n",
              "2000-01-05  115.00  121.00  115.00  118.60    6165      USD\n",
              "2000-01-06  119.00  121.40  116.50  116.85    5094      USD\n",
              "2000-01-07  117.25  117.75  113.80  114.15    6855      USD\n",
              "2000-01-10  123.50  126.00  116.70  117.55    7499      USD\n",
              "2000-01-11  115.50  118.25  115.50  117.80    3976      USD\n",
              "2000-01-12  117.80  120.50  116.90  118.95    5184      USD\n",
              "2000-01-13  119.25  120.00  117.50  118.55    3717      USD\n",
              "2000-01-14  117.75  120.25  112.25  112.55   10115      USD\n",
              "2000-01-18  111.75  118.25  110.60  115.75    7364      USD\n",
              "2000-01-19  116.50  118.25  114.75  116.70    6626      USD\n",
              "2000-01-20  118.25  118.80  111.70  112.00    8834      USD\n",
              "2000-01-21  112.00  113.50  110.80  111.20    5625      USD\n",
              "2000-01-24  110.95  114.40  110.95  111.90    5821      USD\n",
              "2000-01-25  111.60  113.70  111.60  112.85    4014      USD\n",
              "2000-01-26  112.50  115.30  111.90  115.15    5796      USD\n",
              "2000-01-27  114.75  116.40  112.80  114.60    5477      USD\n",
              "2000-01-28  115.10  115.40  113.70  114.70    3334      USD\n",
              "2000-01-31  113.75  114.00  110.50  111.10    6465      USD"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-464267cc-9350-4ca5-a350-a0c3d7734e28\">\n",
              "    <div 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>Open</th>\n",
              "      <th>High</th>\n",
              "      <th>Low</th>\n",
              "      <th>Close</th>\n",
              "      <th>Volume</th>\n",
              "      <th>Currency</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Date</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2000-01-03</th>\n",
              "      <td>122.25</td>\n",
              "      <td>124.00</td>\n",
              "      <td>116.10</td>\n",
              "      <td>116.50</td>\n",
              "      <td>6640</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-04</th>\n",
              "      <td>116.25</td>\n",
              "      <td>120.50</td>\n",
              "      <td>115.75</td>\n",
              "      <td>116.25</td>\n",
              "      <td>5492</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-05</th>\n",
              "      <td>115.00</td>\n",
              "      <td>121.00</td>\n",
              "      <td>115.00</td>\n",
              "      <td>118.60</td>\n",
              "      <td>6165</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-06</th>\n",
              "      <td>119.00</td>\n",
              "      <td>121.40</td>\n",
              "      <td>116.50</td>\n",
              "      <td>116.85</td>\n",
              "      <td>5094</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-07</th>\n",
              "      <td>117.25</td>\n",
              "      <td>117.75</td>\n",
              "      <td>113.80</td>\n",
              "      <td>114.15</td>\n",
              "      <td>6855</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-10</th>\n",
              "      <td>123.50</td>\n",
              "      <td>126.00</td>\n",
              "      <td>116.70</td>\n",
              "      <td>117.55</td>\n",
              "      <td>7499</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-11</th>\n",
              "      <td>115.50</td>\n",
              "      <td>118.25</td>\n",
              "      <td>115.50</td>\n",
              "      <td>117.80</td>\n",
              "      <td>3976</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-12</th>\n",
              "      <td>117.80</td>\n",
              "      <td>120.50</td>\n",
              "      <td>116.90</td>\n",
              "      <td>118.95</td>\n",
              "      <td>5184</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-13</th>\n",
              "      <td>119.25</td>\n",
              "      <td>120.00</td>\n",
              "      <td>117.50</td>\n",
              "      <td>118.55</td>\n",
              "      <td>3717</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-14</th>\n",
              "      <td>117.75</td>\n",
              "      <td>120.25</td>\n",
              "      <td>112.25</td>\n",
              "      <td>112.55</td>\n",
              "      <td>10115</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-18</th>\n",
              "      <td>111.75</td>\n",
              "      <td>118.25</td>\n",
              "      <td>110.60</td>\n",
              "      <td>115.75</td>\n",
              "      <td>7364</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-19</th>\n",
              "      <td>116.50</td>\n",
              "      <td>118.25</td>\n",
              "      <td>114.75</td>\n",
              "      <td>116.70</td>\n",
              "      <td>6626</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-20</th>\n",
              "      <td>118.25</td>\n",
              "      <td>118.80</td>\n",
              "      <td>111.70</td>\n",
              "      <td>112.00</td>\n",
              "      <td>8834</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-21</th>\n",
              "      <td>112.00</td>\n",
              "      <td>113.50</td>\n",
              "      <td>110.80</td>\n",
              "      <td>111.20</td>\n",
              "      <td>5625</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-24</th>\n",
              "      <td>110.95</td>\n",
              "      <td>114.40</td>\n",
              "      <td>110.95</td>\n",
              "      <td>111.90</td>\n",
              "      <td>5821</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-25</th>\n",
              "      <td>111.60</td>\n",
              "      <td>113.70</td>\n",
              "      <td>111.60</td>\n",
              "      <td>112.85</td>\n",
              "      <td>4014</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-26</th>\n",
              "      <td>112.50</td>\n",
              "      <td>115.30</td>\n",
              "      <td>111.90</td>\n",
              "      <td>115.15</td>\n",
              "      <td>5796</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-27</th>\n",
              "      <td>114.75</td>\n",
              "      <td>116.40</td>\n",
              "      <td>112.80</td>\n",
              "      <td>114.60</td>\n",
              "      <td>5477</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-28</th>\n",
              "      <td>115.10</td>\n",
              "      <td>115.40</td>\n",
              "      <td>113.70</td>\n",
              "      <td>114.70</td>\n",
              "      <td>3334</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-31</th>\n",
              "      <td>113.75</td>\n",
              "      <td>114.00</td>\n",
              "      <td>110.50</td>\n",
              "      <td>111.10</td>\n",
              "      <td>6465</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-464267cc-9350-4ca5-a350-a0c3d7734e28')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-464267cc-9350-4ca5-a350-a0c3d7734e28 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-464267cc-9350-4ca5-a350-a0c3d7734e28');\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",
              "  </div>\n",
              "  "
            ],
            "application/vnd.google.colaboratory.module+javascript": "\n      import \"https://ssl.gstatic.com/colaboratory/data_table/fb998edc550c7947/data_table.js\";\n\n      window.createDataTable({\n        data: [[\"2000-01-03\",\n{\n            'v': 122.25,\n            'f': \"122.25\",\n        },\n{\n            'v': 124.0,\n            'f': \"124.0\",\n        },\n{\n            'v': 116.1,\n            'f': \"116.1\",\n        },\n{\n            'v': 116.5,\n            'f': \"116.5\",\n        },\n{\n            'v': 6640,\n            'f': \"6640\",\n        },\n\"USD\"],\n [\"2000-01-04\",\n{\n            'v': 116.25,\n            'f': \"116.25\",\n        },\n{\n            'v': 120.5,\n            'f': \"120.5\",\n        },\n{\n            'v': 115.75,\n            'f': \"115.75\",\n        },\n{\n            'v': 116.25,\n            'f': \"116.25\",\n        },\n{\n            'v': 5492,\n            'f': \"5492\",\n        },\n\"USD\"],\n [\"2000-01-05\",\n{\n            'v': 115.0,\n            'f': \"115.0\",\n        },\n{\n            'v': 121.0,\n            'f': \"121.0\",\n        },\n{\n            'v': 115.0,\n            'f': \"115.0\",\n        },\n{\n            'v': 118.6,\n            'f': \"118.6\",\n        },\n{\n            'v': 6165,\n            'f': \"6165\",\n        },\n\"USD\"],\n [\"2000-01-06\",\n{\n            'v': 119.0,\n            'f': \"119.0\",\n        },\n{\n            'v': 121.4,\n            'f': \"121.4\",\n        },\n{\n            'v': 116.5,\n            'f': \"116.5\",\n        },\n{\n            'v': 116.85,\n            'f': \"116.85\",\n        },\n{\n            'v': 5094,\n            'f': \"5094\",\n        },\n\"USD\"],\n [\"2000-01-07\",\n{\n            'v': 117.25,\n            'f': \"117.25\",\n        },\n{\n            'v': 117.75,\n            'f': \"117.75\",\n        },\n{\n            'v': 113.8,\n            'f': \"113.8\",\n        },\n{\n            'v': 114.15,\n            'f': \"114.15\",\n        },\n{\n            'v': 6855,\n            'f': \"6855\",\n        },\n\"USD\"],\n [\"2000-01-10\",\n{\n            'v': 123.5,\n            'f': \"123.5\",\n        },\n{\n            'v': 126.0,\n            'f': \"126.0\",\n        },\n{\n            'v': 116.7,\n            'f': \"116.7\",\n        },\n{\n            'v': 117.55,\n            'f': \"117.55\",\n        },\n{\n            'v': 7499,\n            'f': \"7499\",\n        },\n\"USD\"],\n [\"2000-01-11\",\n{\n            'v': 115.5,\n            'f': \"115.5\",\n        },\n{\n            'v': 118.25,\n            'f': \"118.25\",\n        },\n{\n            'v': 115.5,\n            'f': \"115.5\",\n        },\n{\n            'v': 117.8,\n            'f': \"117.8\",\n        },\n{\n            'v': 3976,\n            'f': \"3976\",\n        },\n\"USD\"],\n [\"2000-01-12\",\n{\n            'v': 117.8,\n            'f': \"117.8\",\n        },\n{\n            'v': 120.5,\n            'f': \"120.5\",\n        },\n{\n            'v': 116.9,\n            'f': \"116.9\",\n        },\n{\n            'v': 118.95,\n            'f': \"118.95\",\n        },\n{\n            'v': 5184,\n            'f': \"5184\",\n        },\n\"USD\"],\n [\"2000-01-13\",\n{\n            'v': 119.25,\n            'f': \"119.25\",\n        },\n{\n            'v': 120.0,\n            'f': \"120.0\",\n        },\n{\n            'v': 117.5,\n            'f': \"117.5\",\n        },\n{\n            'v': 118.55,\n            'f': \"118.55\",\n        },\n{\n            'v': 3717,\n            'f': \"3717\",\n        },\n\"USD\"],\n [\"2000-01-14\",\n{\n            'v': 117.75,\n            'f': \"117.75\",\n        },\n{\n            'v': 120.25,\n            'f': \"120.25\",\n        },\n{\n            'v': 112.25,\n            'f': \"112.25\",\n        },\n{\n            'v': 112.55,\n            'f': \"112.55\",\n        },\n{\n            'v': 10115,\n            'f': \"10115\",\n        },\n\"USD\"],\n [\"2000-01-18\",\n{\n            'v': 111.75,\n            'f': \"111.75\",\n        },\n{\n            'v': 118.25,\n            'f': \"118.25\",\n        },\n{\n            'v': 110.6,\n            'f': \"110.6\",\n        },\n{\n            'v': 115.75,\n            'f': \"115.75\",\n        },\n{\n            'v': 7364,\n            'f': \"7364\",\n        },\n\"USD\"],\n [\"2000-01-19\",\n{\n            'v': 116.5,\n            'f': \"116.5\",\n        },\n{\n            'v': 118.25,\n            'f': \"118.25\",\n        },\n{\n            'v': 114.75,\n            'f': \"114.75\",\n        },\n{\n            'v': 116.7,\n            'f': \"116.7\",\n        },\n{\n            'v': 6626,\n            'f': \"6626\",\n        },\n\"USD\"],\n [\"2000-01-20\",\n{\n            'v': 118.25,\n            'f': \"118.25\",\n        },\n{\n            'v': 118.8,\n            'f': \"118.8\",\n        },\n{\n            'v': 111.7,\n            'f': \"111.7\",\n        },\n{\n            'v': 112.0,\n            'f': \"112.0\",\n        },\n{\n            'v': 8834,\n            'f': \"8834\",\n        },\n\"USD\"],\n [\"2000-01-21\",\n{\n            'v': 112.0,\n            'f': \"112.0\",\n        },\n{\n            'v': 113.5,\n            'f': \"113.5\",\n        },\n{\n            'v': 110.8,\n            'f': \"110.8\",\n        },\n{\n            'v': 111.2,\n            'f': \"111.2\",\n        },\n{\n            'v': 5625,\n            'f': \"5625\",\n        },\n\"USD\"],\n [\"2000-01-24\",\n{\n            'v': 110.95,\n            'f': \"110.95\",\n        },\n{\n            'v': 114.4,\n            'f': \"114.4\",\n        },\n{\n            'v': 110.95,\n            'f': \"110.95\",\n        },\n{\n            'v': 111.9,\n            'f': \"111.9\",\n        },\n{\n            'v': 5821,\n            'f': \"5821\",\n        },\n\"USD\"],\n [\"2000-01-25\",\n{\n            'v': 111.6,\n            'f': \"111.6\",\n        },\n{\n            'v': 113.7,\n            'f': \"113.7\",\n        },\n{\n            'v': 111.6,\n            'f': \"111.6\",\n        },\n{\n            'v': 112.85,\n            'f': \"112.85\",\n        },\n{\n            'v': 4014,\n            'f': \"4014\",\n        },\n\"USD\"],\n [\"2000-01-26\",\n{\n            'v': 112.5,\n            'f': \"112.5\",\n        },\n{\n            'v': 115.3,\n            'f': \"115.3\",\n        },\n{\n            'v': 111.9,\n            'f': \"111.9\",\n        },\n{\n            'v': 115.15,\n            'f': \"115.15\",\n        },\n{\n            'v': 5796,\n            'f': \"5796\",\n        },\n\"USD\"],\n [\"2000-01-27\",\n{\n            'v': 114.75,\n            'f': \"114.75\",\n        },\n{\n            'v': 116.4,\n            'f': \"116.4\",\n        },\n{\n            'v': 112.8,\n            'f': \"112.8\",\n        },\n{\n            'v': 114.6,\n            'f': \"114.6\",\n        },\n{\n            'v': 5477,\n            'f': \"5477\",\n        },\n\"USD\"],\n [\"2000-01-28\",\n{\n            'v': 115.1,\n            'f': \"115.1\",\n        },\n{\n            'v': 115.4,\n            'f': \"115.4\",\n        },\n{\n            'v': 113.7,\n            'f': \"113.7\",\n        },\n{\n            'v': 114.7,\n            'f': \"114.7\",\n        },\n{\n            'v': 3334,\n            'f': \"3334\",\n        },\n\"USD\"],\n [\"2000-01-31\",\n{\n            'v': 113.75,\n            'f': \"113.75\",\n        },\n{\n            'v': 114.0,\n            'f': \"114.0\",\n        },\n{\n            'v': 110.5,\n            'f': \"110.5\",\n        },\n{\n            'v': 111.1,\n            'f': \"111.1\",\n        },\n{\n            'v': 6465,\n            'f': \"6465\",\n        },\n\"USD\"]],\n        columns: [[\"string\", \"Date\"], [\"number\", \"Open\"], [\"number\", \"High\"], [\"number\", \"Low\"], [\"number\", \"Close\"], [\"number\", \"Volume\"], [\"string\", \"Currency\"]],\n        columnOptions: [{\"width\": \"1px\", \"className\": \"index_column\"}],\n        rowsPerPage: 25,\n        helpUrl: \"https://colab.research.google.com/notebooks/data_table.ipynb\",\n        suppressOutputScrolling: true,\n        minimumWidth: undefined,\n      });\n    "
          },
          "metadata": {},
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Enable Colab DataTable with pagination set to 10 per page. Display the pandas DataFrame"
      ],
      "metadata": {
        "id": "yExxqzf2C1Wy"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "data_table.DataTable(df.head(20), include_index=False, num_rows_per_page=10)"
      ],
      "metadata": {
        "id": "jP1lipz1CdRr",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 515
        },
        "outputId": "977cedde-adf0-475c-93f3-00644ed1fd5b"
      },
      "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>Open</th>\n",
              "      <th>High</th>\n",
              "      <th>Low</th>\n",
              "      <th>Close</th>\n",
              "      <th>Volume</th>\n",
              "      <th>Currency</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Date</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2000-01-03</th>\n",
              "      <td>122.25</td>\n",
              "      <td>124.00</td>\n",
              "      <td>116.10</td>\n",
              "      <td>116.50</td>\n",
              "      <td>6640</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-04</th>\n",
              "      <td>116.25</td>\n",
              "      <td>120.50</td>\n",
              "      <td>115.75</td>\n",
              "      <td>116.25</td>\n",
              "      <td>5492</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-05</th>\n",
              "      <td>115.00</td>\n",
              "      <td>121.00</td>\n",
              "      <td>115.00</td>\n",
              "      <td>118.60</td>\n",
              "      <td>6165</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-06</th>\n",
              "      <td>119.00</td>\n",
              "      <td>121.40</td>\n",
              "      <td>116.50</td>\n",
              "      <td>116.85</td>\n",
              "      <td>5094</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-07</th>\n",
              "      <td>117.25</td>\n",
              "      <td>117.75</td>\n",
              "      <td>113.80</td>\n",
              "      <td>114.15</td>\n",
              "      <td>6855</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-10</th>\n",
              "      <td>123.50</td>\n",
              "      <td>126.00</td>\n",
              "      <td>116.70</td>\n",
              "      <td>117.55</td>\n",
              "      <td>7499</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-11</th>\n",
              "      <td>115.50</td>\n",
              "      <td>118.25</td>\n",
              "      <td>115.50</td>\n",
              "      <td>117.80</td>\n",
              "      <td>3976</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-12</th>\n",
              "      <td>117.80</td>\n",
              "      <td>120.50</td>\n",
              "      <td>116.90</td>\n",
              "      <td>118.95</td>\n",
              "      <td>5184</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-13</th>\n",
              "      <td>119.25</td>\n",
              "      <td>120.00</td>\n",
              "      <td>117.50</td>\n",
              "      <td>118.55</td>\n",
              "      <td>3717</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-14</th>\n",
              "      <td>117.75</td>\n",
              "      <td>120.25</td>\n",
              "      <td>112.25</td>\n",
              "      <td>112.55</td>\n",
              "      <td>10115</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-18</th>\n",
              "      <td>111.75</td>\n",
              "      <td>118.25</td>\n",
              "      <td>110.60</td>\n",
              "      <td>115.75</td>\n",
              "      <td>7364</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-19</th>\n",
              "      <td>116.50</td>\n",
              "      <td>118.25</td>\n",
              "      <td>114.75</td>\n",
              "      <td>116.70</td>\n",
              "      <td>6626</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-20</th>\n",
              "      <td>118.25</td>\n",
              "      <td>118.80</td>\n",
              "      <td>111.70</td>\n",
              "      <td>112.00</td>\n",
              "      <td>8834</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-21</th>\n",
              "      <td>112.00</td>\n",
              "      <td>113.50</td>\n",
              "      <td>110.80</td>\n",
              "      <td>111.20</td>\n",
              "      <td>5625</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-24</th>\n",
              "      <td>110.95</td>\n",
              "      <td>114.40</td>\n",
              "      <td>110.95</td>\n",
              "      <td>111.90</td>\n",
              "      <td>5821</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-25</th>\n",
              "      <td>111.60</td>\n",
              "      <td>113.70</td>\n",
              "      <td>111.60</td>\n",
              "      <td>112.85</td>\n",
              "      <td>4014</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-26</th>\n",
              "      <td>112.50</td>\n",
              "      <td>115.30</td>\n",
              "      <td>111.90</td>\n",
              "      <td>115.15</td>\n",
              "      <td>5796</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-27</th>\n",
              "      <td>114.75</td>\n",
              "      <td>116.40</td>\n",
              "      <td>112.80</td>\n",
              "      <td>114.60</td>\n",
              "      <td>5477</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-28</th>\n",
              "      <td>115.10</td>\n",
              "      <td>115.40</td>\n",
              "      <td>113.70</td>\n",
              "      <td>114.70</td>\n",
              "      <td>3334</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-31</th>\n",
              "      <td>113.75</td>\n",
              "      <td>114.00</td>\n",
              "      <td>110.50</td>\n",
              "      <td>111.10</td>\n",
              "      <td>6465</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "application/vnd.google.colaboratory.module+javascript": "\n      import \"https://ssl.gstatic.com/colaboratory/data_table/fb998edc550c7947/data_table.js\";\n\n      window.createDataTable({\n        data: [[{\n            'v': 122.25,\n            'f': \"122.25\",\n        },\n{\n            'v': 124.0,\n            'f': \"124.0\",\n        },\n{\n            'v': 116.1,\n            'f': \"116.1\",\n        },\n{\n            'v': 116.5,\n            'f': \"116.5\",\n        },\n{\n            'v': 6640,\n            'f': \"6640\",\n        },\n\"USD\"],\n [{\n            'v': 116.25,\n            'f': \"116.25\",\n        },\n{\n            'v': 120.5,\n            'f': \"120.5\",\n        },\n{\n            'v': 115.75,\n            'f': \"115.75\",\n        },\n{\n            'v': 116.25,\n            'f': \"116.25\",\n        },\n{\n            'v': 5492,\n            'f': \"5492\",\n        },\n\"USD\"],\n [{\n            'v': 115.0,\n            'f': \"115.0\",\n        },\n{\n            'v': 121.0,\n            'f': \"121.0\",\n        },\n{\n            'v': 115.0,\n            'f': \"115.0\",\n        },\n{\n            'v': 118.6,\n            'f': \"118.6\",\n        },\n{\n            'v': 6165,\n            'f': \"6165\",\n        },\n\"USD\"],\n [{\n            'v': 119.0,\n            'f': \"119.0\",\n        },\n{\n            'v': 121.4,\n            'f': \"121.4\",\n        },\n{\n            'v': 116.5,\n            'f': \"116.5\",\n        },\n{\n            'v': 116.85,\n            'f': \"116.85\",\n        },\n{\n            'v': 5094,\n            'f': \"5094\",\n        },\n\"USD\"],\n [{\n            'v': 117.25,\n            'f': \"117.25\",\n        },\n{\n            'v': 117.75,\n            'f': \"117.75\",\n        },\n{\n            'v': 113.8,\n            'f': \"113.8\",\n        },\n{\n            'v': 114.15,\n            'f': \"114.15\",\n        },\n{\n            'v': 6855,\n            'f': \"6855\",\n        },\n\"USD\"],\n [{\n            'v': 123.5,\n            'f': \"123.5\",\n        },\n{\n            'v': 126.0,\n            'f': \"126.0\",\n        },\n{\n            'v': 116.7,\n            'f': \"116.7\",\n        },\n{\n            'v': 117.55,\n            'f': \"117.55\",\n        },\n{\n            'v': 7499,\n            'f': \"7499\",\n        },\n\"USD\"],\n [{\n            'v': 115.5,\n            'f': \"115.5\",\n        },\n{\n            'v': 118.25,\n            'f': \"118.25\",\n        },\n{\n            'v': 115.5,\n            'f': \"115.5\",\n        },\n{\n            'v': 117.8,\n            'f': \"117.8\",\n        },\n{\n            'v': 3976,\n            'f': \"3976\",\n        },\n\"USD\"],\n [{\n            'v': 117.8,\n            'f': \"117.8\",\n        },\n{\n            'v': 120.5,\n            'f': \"120.5\",\n        },\n{\n            'v': 116.9,\n            'f': \"116.9\",\n        },\n{\n            'v': 118.95,\n            'f': \"118.95\",\n        },\n{\n            'v': 5184,\n            'f': \"5184\",\n        },\n\"USD\"],\n [{\n            'v': 119.25,\n            'f': \"119.25\",\n        },\n{\n            'v': 120.0,\n            'f': \"120.0\",\n        },\n{\n            'v': 117.5,\n            'f': \"117.5\",\n        },\n{\n            'v': 118.55,\n            'f': \"118.55\",\n        },\n{\n            'v': 3717,\n            'f': \"3717\",\n        },\n\"USD\"],\n [{\n            'v': 117.75,\n            'f': \"117.75\",\n        },\n{\n            'v': 120.25,\n            'f': \"120.25\",\n        },\n{\n            'v': 112.25,\n            'f': \"112.25\",\n        },\n{\n            'v': 112.55,\n            'f': \"112.55\",\n        },\n{\n            'v': 10115,\n            'f': \"10115\",\n        },\n\"USD\"],\n [{\n            'v': 111.75,\n            'f': \"111.75\",\n        },\n{\n            'v': 118.25,\n            'f': \"118.25\",\n        },\n{\n            'v': 110.6,\n            'f': \"110.6\",\n        },\n{\n            'v': 115.75,\n            'f': \"115.75\",\n        },\n{\n            'v': 7364,\n            'f': \"7364\",\n        },\n\"USD\"],\n [{\n            'v': 116.5,\n            'f': \"116.5\",\n        },\n{\n            'v': 118.25,\n            'f': \"118.25\",\n        },\n{\n            'v': 114.75,\n            'f': \"114.75\",\n        },\n{\n            'v': 116.7,\n            'f': \"116.7\",\n        },\n{\n            'v': 6626,\n            'f': \"6626\",\n        },\n\"USD\"],\n [{\n            'v': 118.25,\n            'f': \"118.25\",\n        },\n{\n            'v': 118.8,\n            'f': \"118.8\",\n        },\n{\n            'v': 111.7,\n            'f': \"111.7\",\n        },\n{\n            'v': 112.0,\n            'f': \"112.0\",\n        },\n{\n            'v': 8834,\n            'f': \"8834\",\n        },\n\"USD\"],\n [{\n            'v': 112.0,\n            'f': \"112.0\",\n        },\n{\n            'v': 113.5,\n            'f': \"113.5\",\n        },\n{\n            'v': 110.8,\n            'f': \"110.8\",\n        },\n{\n            'v': 111.2,\n            'f': \"111.2\",\n        },\n{\n            'v': 5625,\n            'f': \"5625\",\n        },\n\"USD\"],\n [{\n            'v': 110.95,\n            'f': \"110.95\",\n        },\n{\n            'v': 114.4,\n            'f': \"114.4\",\n        },\n{\n            'v': 110.95,\n            'f': \"110.95\",\n        },\n{\n            'v': 111.9,\n            'f': \"111.9\",\n        },\n{\n            'v': 5821,\n            'f': \"5821\",\n        },\n\"USD\"],\n [{\n            'v': 111.6,\n            'f': \"111.6\",\n        },\n{\n            'v': 113.7,\n            'f': \"113.7\",\n        },\n{\n            'v': 111.6,\n            'f': \"111.6\",\n        },\n{\n            'v': 112.85,\n            'f': \"112.85\",\n        },\n{\n            'v': 4014,\n            'f': \"4014\",\n        },\n\"USD\"],\n [{\n            'v': 112.5,\n            'f': \"112.5\",\n        },\n{\n            'v': 115.3,\n            'f': \"115.3\",\n        },\n{\n            'v': 111.9,\n            'f': \"111.9\",\n        },\n{\n            'v': 115.15,\n            'f': \"115.15\",\n        },\n{\n            'v': 5796,\n            'f': \"5796\",\n        },\n\"USD\"],\n [{\n            'v': 114.75,\n            'f': \"114.75\",\n        },\n{\n            'v': 116.4,\n            'f': \"116.4\",\n        },\n{\n            'v': 112.8,\n            'f': \"112.8\",\n        },\n{\n            'v': 114.6,\n            'f': \"114.6\",\n        },\n{\n            'v': 5477,\n            'f': \"5477\",\n        },\n\"USD\"],\n [{\n            'v': 115.1,\n            'f': \"115.1\",\n        },\n{\n            'v': 115.4,\n            'f': \"115.4\",\n        },\n{\n            'v': 113.7,\n            'f': \"113.7\",\n        },\n{\n            'v': 114.7,\n            'f': \"114.7\",\n        },\n{\n            'v': 3334,\n            'f': \"3334\",\n        },\n\"USD\"],\n [{\n            'v': 113.75,\n            'f': \"113.75\",\n        },\n{\n            'v': 114.0,\n            'f': \"114.0\",\n        },\n{\n            'v': 110.5,\n            'f': \"110.5\",\n        },\n{\n            'v': 111.1,\n            'f': \"111.1\",\n        },\n{\n            'v': 6465,\n            'f': \"6465\",\n        },\n\"USD\"]],\n        columns: [[\"number\", \"Open\"], [\"number\", \"High\"], [\"number\", \"Low\"], [\"number\", \"Close\"], [\"number\", \"Volume\"], [\"string\", \"Currency\"]],\n        columnOptions: [],\n        rowsPerPage: 10,\n        helpUrl: \"https://colab.research.google.com/notebooks/data_table.ipynb\",\n        suppressOutputScrolling: true,\n        minimumWidth: undefined,\n      });\n    ",
            "text/plain": [
              "<google.colab.data_table.DataTable object>"
            ]
          },
          "metadata": {},
          "execution_count": 18
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Disable Colab dataTable and show DataFrame in native pandas dataframe display."
      ],
      "metadata": {
        "id": "yrP4qVrYCdJc"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "data_table.disable_dataframe_formatter()\n",
        "df.head(20)"
      ],
      "metadata": {
        "id": "p_aXhjfSCUy5",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 708
        },
        "outputId": "07190e6d-b999-4a71-9b12-16ccc0143551"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "              Open    High     Low   Close  Volume Currency\n",
              "Date                                                       \n",
              "2000-01-03  122.25  124.00  116.10  116.50    6640      USD\n",
              "2000-01-04  116.25  120.50  115.75  116.25    5492      USD\n",
              "2000-01-05  115.00  121.00  115.00  118.60    6165      USD\n",
              "2000-01-06  119.00  121.40  116.50  116.85    5094      USD\n",
              "2000-01-07  117.25  117.75  113.80  114.15    6855      USD\n",
              "2000-01-10  123.50  126.00  116.70  117.55    7499      USD\n",
              "2000-01-11  115.50  118.25  115.50  117.80    3976      USD\n",
              "2000-01-12  117.80  120.50  116.90  118.95    5184      USD\n",
              "2000-01-13  119.25  120.00  117.50  118.55    3717      USD\n",
              "2000-01-14  117.75  120.25  112.25  112.55   10115      USD\n",
              "2000-01-18  111.75  118.25  110.60  115.75    7364      USD\n",
              "2000-01-19  116.50  118.25  114.75  116.70    6626      USD\n",
              "2000-01-20  118.25  118.80  111.70  112.00    8834      USD\n",
              "2000-01-21  112.00  113.50  110.80  111.20    5625      USD\n",
              "2000-01-24  110.95  114.40  110.95  111.90    5821      USD\n",
              "2000-01-25  111.60  113.70  111.60  112.85    4014      USD\n",
              "2000-01-26  112.50  115.30  111.90  115.15    5796      USD\n",
              "2000-01-27  114.75  116.40  112.80  114.60    5477      USD\n",
              "2000-01-28  115.10  115.40  113.70  114.70    3334      USD\n",
              "2000-01-31  113.75  114.00  110.50  111.10    6465      USD"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-5a172e56-cfd4-4afd-950d-e52e51ba7a33\">\n",
              "    <div 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>Open</th>\n",
              "      <th>High</th>\n",
              "      <th>Low</th>\n",
              "      <th>Close</th>\n",
              "      <th>Volume</th>\n",
              "      <th>Currency</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Date</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2000-01-03</th>\n",
              "      <td>122.25</td>\n",
              "      <td>124.00</td>\n",
              "      <td>116.10</td>\n",
              "      <td>116.50</td>\n",
              "      <td>6640</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-04</th>\n",
              "      <td>116.25</td>\n",
              "      <td>120.50</td>\n",
              "      <td>115.75</td>\n",
              "      <td>116.25</td>\n",
              "      <td>5492</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-05</th>\n",
              "      <td>115.00</td>\n",
              "      <td>121.00</td>\n",
              "      <td>115.00</td>\n",
              "      <td>118.60</td>\n",
              "      <td>6165</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-06</th>\n",
              "      <td>119.00</td>\n",
              "      <td>121.40</td>\n",
              "      <td>116.50</td>\n",
              "      <td>116.85</td>\n",
              "      <td>5094</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-07</th>\n",
              "      <td>117.25</td>\n",
              "      <td>117.75</td>\n",
              "      <td>113.80</td>\n",
              "      <td>114.15</td>\n",
              "      <td>6855</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-10</th>\n",
              "      <td>123.50</td>\n",
              "      <td>126.00</td>\n",
              "      <td>116.70</td>\n",
              "      <td>117.55</td>\n",
              "      <td>7499</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-11</th>\n",
              "      <td>115.50</td>\n",
              "      <td>118.25</td>\n",
              "      <td>115.50</td>\n",
              "      <td>117.80</td>\n",
              "      <td>3976</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-12</th>\n",
              "      <td>117.80</td>\n",
              "      <td>120.50</td>\n",
              "      <td>116.90</td>\n",
              "      <td>118.95</td>\n",
              "      <td>5184</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-13</th>\n",
              "      <td>119.25</td>\n",
              "      <td>120.00</td>\n",
              "      <td>117.50</td>\n",
              "      <td>118.55</td>\n",
              "      <td>3717</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-14</th>\n",
              "      <td>117.75</td>\n",
              "      <td>120.25</td>\n",
              "      <td>112.25</td>\n",
              "      <td>112.55</td>\n",
              "      <td>10115</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-18</th>\n",
              "      <td>111.75</td>\n",
              "      <td>118.25</td>\n",
              "      <td>110.60</td>\n",
              "      <td>115.75</td>\n",
              "      <td>7364</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-19</th>\n",
              "      <td>116.50</td>\n",
              "      <td>118.25</td>\n",
              "      <td>114.75</td>\n",
              "      <td>116.70</td>\n",
              "      <td>6626</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-20</th>\n",
              "      <td>118.25</td>\n",
              "      <td>118.80</td>\n",
              "      <td>111.70</td>\n",
              "      <td>112.00</td>\n",
              "      <td>8834</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-21</th>\n",
              "      <td>112.00</td>\n",
              "      <td>113.50</td>\n",
              "      <td>110.80</td>\n",
              "      <td>111.20</td>\n",
              "      <td>5625</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-24</th>\n",
              "      <td>110.95</td>\n",
              "      <td>114.40</td>\n",
              "      <td>110.95</td>\n",
              "      <td>111.90</td>\n",
              "      <td>5821</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-25</th>\n",
              "      <td>111.60</td>\n",
              "      <td>113.70</td>\n",
              "      <td>111.60</td>\n",
              "      <td>112.85</td>\n",
              "      <td>4014</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-26</th>\n",
              "      <td>112.50</td>\n",
              "      <td>115.30</td>\n",
              "      <td>111.90</td>\n",
              "      <td>115.15</td>\n",
              "      <td>5796</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-27</th>\n",
              "      <td>114.75</td>\n",
              "      <td>116.40</td>\n",
              "      <td>112.80</td>\n",
              "      <td>114.60</td>\n",
              "      <td>5477</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-28</th>\n",
              "      <td>115.10</td>\n",
              "      <td>115.40</td>\n",
              "      <td>113.70</td>\n",
              "      <td>114.70</td>\n",
              "      <td>3334</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2000-01-31</th>\n",
              "      <td>113.75</td>\n",
              "      <td>114.00</td>\n",
              "      <td>110.50</td>\n",
              "      <td>111.10</td>\n",
              "      <td>6465</td>\n",
              "      <td>USD</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-5a172e56-cfd4-4afd-950d-e52e51ba7a33')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-5a172e56-cfd4-4afd-950d-e52e51ba7a33 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-5a172e56-cfd4-4afd-950d-e52e51ba7a33');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Style the resultset so that it highlights the min Close price as well as the min Volume. Also set the data text color to black"
      ],
      "metadata": {
        "id": "bVm_yP6YL_u8"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "(\n",
        "df[['Close','Volume']].head(5)\n",
        "  .style.highlight_min(axis=0)\n",
        "  .set_properties( **{'color':'black'})\n",
        ")"
      ],
      "metadata": {
        "id": "W16p--7Xczut",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 237
        },
        "outputId": "74634d15-acd4-4060-aa1c-8c163435b964"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x7f71e64d3f70>"
            ],
            "text/html": [
              "<style type=\"text/css\">\n",
              "#T_24728_row0_col0, #T_24728_row0_col1, #T_24728_row1_col0, #T_24728_row1_col1, #T_24728_row2_col0, #T_24728_row2_col1, #T_24728_row3_col0, #T_24728_row4_col1 {\n",
              "  color: black;\n",
              "}\n",
              "#T_24728_row3_col1, #T_24728_row4_col0 {\n",
              "  background-color: yellow;\n",
              "  color: black;\n",
              "}\n",
              "</style>\n",
              "<table id=\"T_24728_\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr>\n",
              "      <th class=\"blank level0\" >&nbsp;</th>\n",
              "      <th class=\"col_heading level0 col0\" >Close</th>\n",
              "      <th class=\"col_heading level0 col1\" >Volume</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th class=\"index_name level0\" >Date</th>\n",
              "      <th class=\"blank col0\" >&nbsp;</th>\n",
              "      <th class=\"blank col1\" >&nbsp;</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th id=\"T_24728_level0_row0\" class=\"row_heading level0 row0\" >2000-01-03</th>\n",
              "      <td id=\"T_24728_row0_col0\" class=\"data row0 col0\" >116.500000</td>\n",
              "      <td id=\"T_24728_row0_col1\" class=\"data row0 col1\" >6640</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_24728_level0_row1\" class=\"row_heading level0 row1\" >2000-01-04</th>\n",
              "      <td id=\"T_24728_row1_col0\" class=\"data row1 col0\" >116.250000</td>\n",
              "      <td id=\"T_24728_row1_col1\" class=\"data row1 col1\" >5492</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_24728_level0_row2\" class=\"row_heading level0 row2\" >2000-01-05</th>\n",
              "      <td id=\"T_24728_row2_col0\" class=\"data row2 col0\" >118.600000</td>\n",
              "      <td id=\"T_24728_row2_col1\" class=\"data row2 col1\" >6165</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_24728_level0_row3\" class=\"row_heading level0 row3\" >2000-01-06</th>\n",
              "      <td id=\"T_24728_row3_col0\" class=\"data row3 col0\" >116.850000</td>\n",
              "      <td id=\"T_24728_row3_col1\" class=\"data row3 col1\" >5094</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_24728_level0_row4\" class=\"row_heading level0 row4\" >2000-01-07</th>\n",
              "      <td id=\"T_24728_row4_col0\" class=\"data row4 col0\" >114.150000</td>\n",
              "      <td id=\"T_24728_row4_col1\" class=\"data row4 col1\" >6855</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n"
            ]
          },
          "metadata": {},
          "execution_count": 20
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Get Todays USD to EURO Exchange Rate"
      ],
      "metadata": {
        "id": "cOz7tl0OPlfP"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "import requests\n",
        "\n",
        "url = 'https://api.exchangerate.host/convert?from=USD&to=EUR'\n",
        "response = requests.get(url)\n",
        "data = response.json()"
      ],
      "metadata": {
        "id": "m6XWqaUbRVbl"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Style new DataFrame with different number of decimals as well as display prices in USD and EURO based on Exchange Rate.\n",
        "\n",
        "The format string \"{:20, .5f}\" specifies the format of the number to be displayed in the pandas dataframe. The first number \"20\" is the width of the field to be occupied by the number, the comma specifies that the number should be formatted with a comma as thousands separator and \".5f\" specifies that the number should be displayed with 5 decimal places. The \"$\" symbol in front of the format string represents the currency symbol and \"eurosymbol\" represents the Euro currency symbol."
      ],
      "metadata": {
        "id": "NQLuajTlaQ9T"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "exchrate = data['info']['rate']\n",
        "print(exchrate)\n",
        "cols=['Open','High','Low','Close']\n",
        "addcols=['OpenEuro','HighEuro','LowEuro','CloseEuro']\n",
        "df_new = df[cols].head(10)\n",
        "\n",
        "df_new['OpenEuro'] = df['Open'] * exchrate\n",
        "df_new['HighEuro'] = df['High'] * exchrate\n",
        "df_new['LowEuro'] = df['Low'] * exchrate\n",
        "df_new['CloseEuro'] = df['Close'] * exchrate\n",
        "\n",
        "eurosymbol = u\"\\N{euro sign}\"\n",
        "\n",
        "(df_new\n",
        " .style\n",
        " .format({\"Open\": \"${:20,.2f}\", \n",
        "          \"High\": \"${:20,.3f}\", \n",
        "          \"Low\": \"${:20,.4f}\",\n",
        "          \"Close\":\"${:20,.5f}\",\n",
        "          \"OpenEuro\": eurosymbol + \"{:20,.5f}\", \n",
        "          \"HighEuro\": eurosymbol + \"{:20,.4f}\",  \n",
        "          \"LowEuro\": eurosymbol + \"{:20,.3f}\",\n",
        "          \"CloseEuro\":eurosymbol + \"{:20,.2f}\"})\n",
        ")"
      ],
      "metadata": {
        "id": "QfPGYfoxPkqf",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 412
        },
        "outputId": "740cf55d-5d8a-4676-881f-bd1553d1ee36"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "0.931422\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x7f71e5ec6310>"
            ],
            "text/html": [
              "<style type=\"text/css\">\n",
              "</style>\n",
              "<table id=\"T_2df9a_\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr>\n",
              "      <th class=\"blank level0\" >&nbsp;</th>\n",
              "      <th class=\"col_heading level0 col0\" >Open</th>\n",
              "      <th class=\"col_heading level0 col1\" >High</th>\n",
              "      <th class=\"col_heading level0 col2\" >Low</th>\n",
              "      <th class=\"col_heading level0 col3\" >Close</th>\n",
              "      <th class=\"col_heading level0 col4\" >OpenEuro</th>\n",
              "      <th class=\"col_heading level0 col5\" >HighEuro</th>\n",
              "      <th class=\"col_heading level0 col6\" >LowEuro</th>\n",
              "      <th class=\"col_heading level0 col7\" >CloseEuro</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th class=\"index_name level0\" >Date</th>\n",
              "      <th class=\"blank col0\" >&nbsp;</th>\n",
              "      <th class=\"blank col1\" >&nbsp;</th>\n",
              "      <th class=\"blank col2\" >&nbsp;</th>\n",
              "      <th class=\"blank col3\" >&nbsp;</th>\n",
              "      <th class=\"blank col4\" >&nbsp;</th>\n",
              "      <th class=\"blank col5\" >&nbsp;</th>\n",
              "      <th class=\"blank col6\" >&nbsp;</th>\n",
              "      <th class=\"blank col7\" >&nbsp;</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th id=\"T_2df9a_level0_row0\" class=\"row_heading level0 row0\" >2000-01-03</th>\n",
              "      <td id=\"T_2df9a_row0_col0\" class=\"data row0 col0\" >$              122.25</td>\n",
              "      <td id=\"T_2df9a_row0_col1\" class=\"data row0 col1\" >$             124.000</td>\n",
              "      <td id=\"T_2df9a_row0_col2\" class=\"data row0 col2\" >$            116.1000</td>\n",
              "      <td id=\"T_2df9a_row0_col3\" class=\"data row0 col3\" >$           116.50000</td>\n",
              "      <td id=\"T_2df9a_row0_col4\" class=\"data row0 col4\" >€           113.86634</td>\n",
              "      <td id=\"T_2df9a_row0_col5\" class=\"data row0 col5\" >€            115.4963</td>\n",
              "      <td id=\"T_2df9a_row0_col6\" class=\"data row0 col6\" >€             108.138</td>\n",
              "      <td id=\"T_2df9a_row0_col7\" class=\"data row0 col7\" >€              108.51</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_2df9a_level0_row1\" class=\"row_heading level0 row1\" >2000-01-04</th>\n",
              "      <td id=\"T_2df9a_row1_col0\" class=\"data row1 col0\" >$              116.25</td>\n",
              "      <td id=\"T_2df9a_row1_col1\" class=\"data row1 col1\" >$             120.500</td>\n",
              "      <td id=\"T_2df9a_row1_col2\" class=\"data row1 col2\" >$            115.7500</td>\n",
              "      <td id=\"T_2df9a_row1_col3\" class=\"data row1 col3\" >$           116.25000</td>\n",
              "      <td id=\"T_2df9a_row1_col4\" class=\"data row1 col4\" >€           108.27781</td>\n",
              "      <td id=\"T_2df9a_row1_col5\" class=\"data row1 col5\" >€            112.2364</td>\n",
              "      <td id=\"T_2df9a_row1_col6\" class=\"data row1 col6\" >€             107.812</td>\n",
              "      <td id=\"T_2df9a_row1_col7\" class=\"data row1 col7\" >€              108.28</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_2df9a_level0_row2\" class=\"row_heading level0 row2\" >2000-01-05</th>\n",
              "      <td id=\"T_2df9a_row2_col0\" class=\"data row2 col0\" >$              115.00</td>\n",
              "      <td id=\"T_2df9a_row2_col1\" class=\"data row2 col1\" >$             121.000</td>\n",
              "      <td id=\"T_2df9a_row2_col2\" class=\"data row2 col2\" >$            115.0000</td>\n",
              "      <td id=\"T_2df9a_row2_col3\" class=\"data row2 col3\" >$           118.60000</td>\n",
              "      <td id=\"T_2df9a_row2_col4\" class=\"data row2 col4\" >€           107.11353</td>\n",
              "      <td id=\"T_2df9a_row2_col5\" class=\"data row2 col5\" >€            112.7021</td>\n",
              "      <td id=\"T_2df9a_row2_col6\" class=\"data row2 col6\" >€             107.114</td>\n",
              "      <td id=\"T_2df9a_row2_col7\" class=\"data row2 col7\" >€              110.47</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_2df9a_level0_row3\" class=\"row_heading level0 row3\" >2000-01-06</th>\n",
              "      <td id=\"T_2df9a_row3_col0\" class=\"data row3 col0\" >$              119.00</td>\n",
              "      <td id=\"T_2df9a_row3_col1\" class=\"data row3 col1\" >$             121.400</td>\n",
              "      <td id=\"T_2df9a_row3_col2\" class=\"data row3 col2\" >$            116.5000</td>\n",
              "      <td id=\"T_2df9a_row3_col3\" class=\"data row3 col3\" >$           116.85000</td>\n",
              "      <td id=\"T_2df9a_row3_col4\" class=\"data row3 col4\" >€           110.83922</td>\n",
              "      <td id=\"T_2df9a_row3_col5\" class=\"data row3 col5\" >€            113.0746</td>\n",
              "      <td id=\"T_2df9a_row3_col6\" class=\"data row3 col6\" >€             108.511</td>\n",
              "      <td id=\"T_2df9a_row3_col7\" class=\"data row3 col7\" >€              108.84</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_2df9a_level0_row4\" class=\"row_heading level0 row4\" >2000-01-07</th>\n",
              "      <td id=\"T_2df9a_row4_col0\" class=\"data row4 col0\" >$              117.25</td>\n",
              "      <td id=\"T_2df9a_row4_col1\" class=\"data row4 col1\" >$             117.750</td>\n",
              "      <td id=\"T_2df9a_row4_col2\" class=\"data row4 col2\" >$            113.8000</td>\n",
              "      <td id=\"T_2df9a_row4_col3\" class=\"data row4 col3\" >$           114.15000</td>\n",
              "      <td id=\"T_2df9a_row4_col4\" class=\"data row4 col4\" >€           109.20923</td>\n",
              "      <td id=\"T_2df9a_row4_col5\" class=\"data row4 col5\" >€            109.6749</td>\n",
              "      <td id=\"T_2df9a_row4_col6\" class=\"data row4 col6\" >€             105.996</td>\n",
              "      <td id=\"T_2df9a_row4_col7\" class=\"data row4 col7\" >€              106.32</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_2df9a_level0_row5\" class=\"row_heading level0 row5\" >2000-01-10</th>\n",
              "      <td id=\"T_2df9a_row5_col0\" class=\"data row5 col0\" >$              123.50</td>\n",
              "      <td id=\"T_2df9a_row5_col1\" class=\"data row5 col1\" >$             126.000</td>\n",
              "      <td id=\"T_2df9a_row5_col2\" class=\"data row5 col2\" >$            116.7000</td>\n",
              "      <td id=\"T_2df9a_row5_col3\" class=\"data row5 col3\" >$           117.55000</td>\n",
              "      <td id=\"T_2df9a_row5_col4\" class=\"data row5 col4\" >€           115.03062</td>\n",
              "      <td id=\"T_2df9a_row5_col5\" class=\"data row5 col5\" >€            117.3592</td>\n",
              "      <td id=\"T_2df9a_row5_col6\" class=\"data row5 col6\" >€             108.697</td>\n",
              "      <td id=\"T_2df9a_row5_col7\" class=\"data row5 col7\" >€              109.49</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_2df9a_level0_row6\" class=\"row_heading level0 row6\" >2000-01-11</th>\n",
              "      <td id=\"T_2df9a_row6_col0\" class=\"data row6 col0\" >$              115.50</td>\n",
              "      <td id=\"T_2df9a_row6_col1\" class=\"data row6 col1\" >$             118.250</td>\n",
              "      <td id=\"T_2df9a_row6_col2\" class=\"data row6 col2\" >$            115.5000</td>\n",
              "      <td id=\"T_2df9a_row6_col3\" class=\"data row6 col3\" >$           117.80000</td>\n",
              "      <td id=\"T_2df9a_row6_col4\" class=\"data row6 col4\" >€           107.57924</td>\n",
              "      <td id=\"T_2df9a_row6_col5\" class=\"data row6 col5\" >€            110.1407</td>\n",
              "      <td id=\"T_2df9a_row6_col6\" class=\"data row6 col6\" >€             107.579</td>\n",
              "      <td id=\"T_2df9a_row6_col7\" class=\"data row6 col7\" >€              109.72</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_2df9a_level0_row7\" class=\"row_heading level0 row7\" >2000-01-12</th>\n",
              "      <td id=\"T_2df9a_row7_col0\" class=\"data row7 col0\" >$              117.80</td>\n",
              "      <td id=\"T_2df9a_row7_col1\" class=\"data row7 col1\" >$             120.500</td>\n",
              "      <td id=\"T_2df9a_row7_col2\" class=\"data row7 col2\" >$            116.9000</td>\n",
              "      <td id=\"T_2df9a_row7_col3\" class=\"data row7 col3\" >$           118.95000</td>\n",
              "      <td id=\"T_2df9a_row7_col4\" class=\"data row7 col4\" >€           109.72151</td>\n",
              "      <td id=\"T_2df9a_row7_col5\" class=\"data row7 col5\" >€            112.2364</td>\n",
              "      <td id=\"T_2df9a_row7_col6\" class=\"data row7 col6\" >€             108.883</td>\n",
              "      <td id=\"T_2df9a_row7_col7\" class=\"data row7 col7\" >€              110.79</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_2df9a_level0_row8\" class=\"row_heading level0 row8\" >2000-01-13</th>\n",
              "      <td id=\"T_2df9a_row8_col0\" class=\"data row8 col0\" >$              119.25</td>\n",
              "      <td id=\"T_2df9a_row8_col1\" class=\"data row8 col1\" >$             120.000</td>\n",
              "      <td id=\"T_2df9a_row8_col2\" class=\"data row8 col2\" >$            117.5000</td>\n",
              "      <td id=\"T_2df9a_row8_col3\" class=\"data row8 col3\" >$           118.55000</td>\n",
              "      <td id=\"T_2df9a_row8_col4\" class=\"data row8 col4\" >€           111.07207</td>\n",
              "      <td id=\"T_2df9a_row8_col5\" class=\"data row8 col5\" >€            111.7706</td>\n",
              "      <td id=\"T_2df9a_row8_col6\" class=\"data row8 col6\" >€             109.442</td>\n",
              "      <td id=\"T_2df9a_row8_col7\" class=\"data row8 col7\" >€              110.42</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_2df9a_level0_row9\" class=\"row_heading level0 row9\" >2000-01-14</th>\n",
              "      <td id=\"T_2df9a_row9_col0\" class=\"data row9 col0\" >$              117.75</td>\n",
              "      <td id=\"T_2df9a_row9_col1\" class=\"data row9 col1\" >$             120.250</td>\n",
              "      <td id=\"T_2df9a_row9_col2\" class=\"data row9 col2\" >$            112.2500</td>\n",
              "      <td id=\"T_2df9a_row9_col3\" class=\"data row9 col3\" >$           112.55000</td>\n",
              "      <td id=\"T_2df9a_row9_col4\" class=\"data row9 col4\" >€           109.67494</td>\n",
              "      <td id=\"T_2df9a_row9_col5\" class=\"data row9 col5\" >€            112.0035</td>\n",
              "      <td id=\"T_2df9a_row9_col6\" class=\"data row9 col6\" >€             104.552</td>\n",
              "      <td id=\"T_2df9a_row9_col7\" class=\"data row9 col7\" >€              104.83</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n"
            ]
          },
          "metadata": {},
          "execution_count": 22
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df_new.describe()"
      ],
      "metadata": {
        "id": "gzl8jTBwjYbA",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 300
        },
        "outputId": "47b120a1-ebb6-495c-9449-ca03f89f7c69"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "             Open        High         Low       Close    OpenEuro    HighEuro  \\\n",
              "count   10.000000   10.000000   10.000000   10.000000   10.000000   10.000000   \n",
              "mean   118.355000  120.965000  115.600000  116.775000  110.238451  112.669462   \n",
              "std      2.760681    2.457082    1.578501    2.053757    2.571359    2.288580   \n",
              "min    115.000000  117.750000  112.250000  112.550000  107.113530  109.674940   \n",
              "25%    116.500000  120.062500  115.125000  116.312500  108.510663  111.828854   \n",
              "50%    117.775000  120.500000  115.925000  117.200000  109.698226  112.236351   \n",
              "75%    119.187500  121.300000  116.650000  118.362500  111.013860  112.981489   \n",
              "max    123.500000  126.000000  117.500000  118.950000  115.030617  117.359172   \n",
              "\n",
              "          LowEuro   CloseEuro  \n",
              "count   10.000000   10.000000  \n",
              "mean   107.672383  108.766804  \n",
              "std      1.470251    1.912914  \n",
              "min    104.552120  104.831546  \n",
              "25%    107.229958  108.336021  \n",
              "50%    107.975095  109.162658  \n",
              "75%    108.650376  110.245436  \n",
              "max    109.442085  110.792647  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-c7d480b8-438f-4197-bba4-0fefb7fddc3d\">\n",
              "    <div 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>Open</th>\n",
              "      <th>High</th>\n",
              "      <th>Low</th>\n",
              "      <th>Close</th>\n",
              "      <th>OpenEuro</th>\n",
              "      <th>HighEuro</th>\n",
              "      <th>LowEuro</th>\n",
              "      <th>CloseEuro</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>10.000000</td>\n",
              "      <td>10.000000</td>\n",
              "      <td>10.000000</td>\n",
              "      <td>10.000000</td>\n",
              "      <td>10.000000</td>\n",
              "      <td>10.000000</td>\n",
              "      <td>10.000000</td>\n",
              "      <td>10.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>mean</th>\n",
              "      <td>118.355000</td>\n",
              "      <td>120.965000</td>\n",
              "      <td>115.600000</td>\n",
              "      <td>116.775000</td>\n",
              "      <td>110.238451</td>\n",
              "      <td>112.669462</td>\n",
              "      <td>107.672383</td>\n",
              "      <td>108.766804</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>std</th>\n",
              "      <td>2.760681</td>\n",
              "      <td>2.457082</td>\n",
              "      <td>1.578501</td>\n",
              "      <td>2.053757</td>\n",
              "      <td>2.571359</td>\n",
              "      <td>2.288580</td>\n",
              "      <td>1.470251</td>\n",
              "      <td>1.912914</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>min</th>\n",
              "      <td>115.000000</td>\n",
              "      <td>117.750000</td>\n",
              "      <td>112.250000</td>\n",
              "      <td>112.550000</td>\n",
              "      <td>107.113530</td>\n",
              "      <td>109.674940</td>\n",
              "      <td>104.552120</td>\n",
              "      <td>104.831546</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25%</th>\n",
              "      <td>116.500000</td>\n",
              "      <td>120.062500</td>\n",
              "      <td>115.125000</td>\n",
              "      <td>116.312500</td>\n",
              "      <td>108.510663</td>\n",
              "      <td>111.828854</td>\n",
              "      <td>107.229958</td>\n",
              "      <td>108.336021</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50%</th>\n",
              "      <td>117.775000</td>\n",
              "      <td>120.500000</td>\n",
              "      <td>115.925000</td>\n",
              "      <td>117.200000</td>\n",
              "      <td>109.698226</td>\n",
              "      <td>112.236351</td>\n",
              "      <td>107.975095</td>\n",
              "      <td>109.162658</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75%</th>\n",
              "      <td>119.187500</td>\n",
              "      <td>121.300000</td>\n",
              "      <td>116.650000</td>\n",
              "      <td>118.362500</td>\n",
              "      <td>111.013860</td>\n",
              "      <td>112.981489</td>\n",
              "      <td>108.650376</td>\n",
              "      <td>110.245436</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>max</th>\n",
              "      <td>123.500000</td>\n",
              "      <td>126.000000</td>\n",
              "      <td>117.500000</td>\n",
              "      <td>118.950000</td>\n",
              "      <td>115.030617</td>\n",
              "      <td>117.359172</td>\n",
              "      <td>109.442085</td>\n",
              "      <td>110.792647</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-c7d480b8-438f-4197-bba4-0fefb7fddc3d')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-c7d480b8-438f-4197-bba4-0fefb7fddc3d 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-c7d480b8-438f-4197-bba4-0fefb7fddc3d');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 23
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### The format function has a `precision` argument to specifically help formatting floats, as well as decimal and thousands separators to support other locales, an `na_rep` argument to display missing data"
      ],
      "metadata": {
        "id": "S7DXSB7JjY0E"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "def style_missing_data(v, props=''):\n",
        "    return props if np.isnan(v) else None\n",
        "\n",
        "df_large = df_new + 1000000\n",
        "df_large.iloc[3:6,2:4] = np.nan\n",
        "(\n",
        "df_large.head(6)\n",
        "   .style\n",
        "   .applymap(style_missing_data, props='background-color: black; color:yellow; font-size:150%;')\n",
        "   .format(precision=3, thousands=\",\", na_rep = 'Missing Data')\n",
        ")"
      ],
      "metadata": {
        "id": "k41uHidUEVCz",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 316
        },
        "outputId": "4c725888-f464-422c-e821-c2ad8baa045c"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x7f71e5ec6880>"
            ],
            "text/html": [
              "<style type=\"text/css\">\n",
              "#T_98bc8_row3_col2, #T_98bc8_row3_col3, #T_98bc8_row4_col2, #T_98bc8_row4_col3, #T_98bc8_row5_col2, #T_98bc8_row5_col3 {\n",
              "  background-color: black;\n",
              "  color: yellow;\n",
              "  font-size: 150%;\n",
              "}\n",
              "</style>\n",
              "<table id=\"T_98bc8_\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr>\n",
              "      <th class=\"blank level0\" >&nbsp;</th>\n",
              "      <th class=\"col_heading level0 col0\" >Open</th>\n",
              "      <th class=\"col_heading level0 col1\" >High</th>\n",
              "      <th class=\"col_heading level0 col2\" >Low</th>\n",
              "      <th class=\"col_heading level0 col3\" >Close</th>\n",
              "      <th class=\"col_heading level0 col4\" >OpenEuro</th>\n",
              "      <th class=\"col_heading level0 col5\" >HighEuro</th>\n",
              "      <th class=\"col_heading level0 col6\" >LowEuro</th>\n",
              "      <th class=\"col_heading level0 col7\" >CloseEuro</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th class=\"index_name level0\" >Date</th>\n",
              "      <th class=\"blank col0\" >&nbsp;</th>\n",
              "      <th class=\"blank col1\" >&nbsp;</th>\n",
              "      <th class=\"blank col2\" >&nbsp;</th>\n",
              "      <th class=\"blank col3\" >&nbsp;</th>\n",
              "      <th class=\"blank col4\" >&nbsp;</th>\n",
              "      <th class=\"blank col5\" >&nbsp;</th>\n",
              "      <th class=\"blank col6\" >&nbsp;</th>\n",
              "      <th class=\"blank col7\" >&nbsp;</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th id=\"T_98bc8_level0_row0\" class=\"row_heading level0 row0\" >2000-01-03</th>\n",
              "      <td id=\"T_98bc8_row0_col0\" class=\"data row0 col0\" >1,000,122.250</td>\n",
              "      <td id=\"T_98bc8_row0_col1\" class=\"data row0 col1\" >1,000,124.000</td>\n",
              "      <td id=\"T_98bc8_row0_col2\" class=\"data row0 col2\" >1,000,116.100</td>\n",
              "      <td id=\"T_98bc8_row0_col3\" class=\"data row0 col3\" >1,000,116.500</td>\n",
              "      <td id=\"T_98bc8_row0_col4\" class=\"data row0 col4\" >1,000,113.866</td>\n",
              "      <td id=\"T_98bc8_row0_col5\" class=\"data row0 col5\" >1,000,115.496</td>\n",
              "      <td id=\"T_98bc8_row0_col6\" class=\"data row0 col6\" >1,000,108.138</td>\n",
              "      <td id=\"T_98bc8_row0_col7\" class=\"data row0 col7\" >1,000,108.511</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_98bc8_level0_row1\" class=\"row_heading level0 row1\" >2000-01-04</th>\n",
              "      <td id=\"T_98bc8_row1_col0\" class=\"data row1 col0\" >1,000,116.250</td>\n",
              "      <td id=\"T_98bc8_row1_col1\" class=\"data row1 col1\" >1,000,120.500</td>\n",
              "      <td id=\"T_98bc8_row1_col2\" class=\"data row1 col2\" >1,000,115.750</td>\n",
              "      <td id=\"T_98bc8_row1_col3\" class=\"data row1 col3\" >1,000,116.250</td>\n",
              "      <td id=\"T_98bc8_row1_col4\" class=\"data row1 col4\" >1,000,108.278</td>\n",
              "      <td id=\"T_98bc8_row1_col5\" class=\"data row1 col5\" >1,000,112.236</td>\n",
              "      <td id=\"T_98bc8_row1_col6\" class=\"data row1 col6\" >1,000,107.812</td>\n",
              "      <td id=\"T_98bc8_row1_col7\" class=\"data row1 col7\" >1,000,108.278</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_98bc8_level0_row2\" class=\"row_heading level0 row2\" >2000-01-05</th>\n",
              "      <td id=\"T_98bc8_row2_col0\" class=\"data row2 col0\" >1,000,115.000</td>\n",
              "      <td id=\"T_98bc8_row2_col1\" class=\"data row2 col1\" >1,000,121.000</td>\n",
              "      <td id=\"T_98bc8_row2_col2\" class=\"data row2 col2\" >1,000,115.000</td>\n",
              "      <td id=\"T_98bc8_row2_col3\" class=\"data row2 col3\" >1,000,118.600</td>\n",
              "      <td id=\"T_98bc8_row2_col4\" class=\"data row2 col4\" >1,000,107.114</td>\n",
              "      <td id=\"T_98bc8_row2_col5\" class=\"data row2 col5\" >1,000,112.702</td>\n",
              "      <td id=\"T_98bc8_row2_col6\" class=\"data row2 col6\" >1,000,107.114</td>\n",
              "      <td id=\"T_98bc8_row2_col7\" class=\"data row2 col7\" >1,000,110.467</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_98bc8_level0_row3\" class=\"row_heading level0 row3\" >2000-01-06</th>\n",
              "      <td id=\"T_98bc8_row3_col0\" class=\"data row3 col0\" >1,000,119.000</td>\n",
              "      <td id=\"T_98bc8_row3_col1\" class=\"data row3 col1\" >1,000,121.400</td>\n",
              "      <td id=\"T_98bc8_row3_col2\" class=\"data row3 col2\" >Missing Data</td>\n",
              "      <td id=\"T_98bc8_row3_col3\" class=\"data row3 col3\" >Missing Data</td>\n",
              "      <td id=\"T_98bc8_row3_col4\" class=\"data row3 col4\" >1,000,110.839</td>\n",
              "      <td id=\"T_98bc8_row3_col5\" class=\"data row3 col5\" >1,000,113.075</td>\n",
              "      <td id=\"T_98bc8_row3_col6\" class=\"data row3 col6\" >1,000,108.511</td>\n",
              "      <td id=\"T_98bc8_row3_col7\" class=\"data row3 col7\" >1,000,108.837</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_98bc8_level0_row4\" class=\"row_heading level0 row4\" >2000-01-07</th>\n",
              "      <td id=\"T_98bc8_row4_col0\" class=\"data row4 col0\" >1,000,117.250</td>\n",
              "      <td id=\"T_98bc8_row4_col1\" class=\"data row4 col1\" >1,000,117.750</td>\n",
              "      <td id=\"T_98bc8_row4_col2\" class=\"data row4 col2\" >Missing Data</td>\n",
              "      <td id=\"T_98bc8_row4_col3\" class=\"data row4 col3\" >Missing Data</td>\n",
              "      <td id=\"T_98bc8_row4_col4\" class=\"data row4 col4\" >1,000,109.209</td>\n",
              "      <td id=\"T_98bc8_row4_col5\" class=\"data row4 col5\" >1,000,109.675</td>\n",
              "      <td id=\"T_98bc8_row4_col6\" class=\"data row4 col6\" >1,000,105.996</td>\n",
              "      <td id=\"T_98bc8_row4_col7\" class=\"data row4 col7\" >1,000,106.322</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_98bc8_level0_row5\" class=\"row_heading level0 row5\" >2000-01-10</th>\n",
              "      <td id=\"T_98bc8_row5_col0\" class=\"data row5 col0\" >1,000,123.500</td>\n",
              "      <td id=\"T_98bc8_row5_col1\" class=\"data row5 col1\" >1,000,126.000</td>\n",
              "      <td id=\"T_98bc8_row5_col2\" class=\"data row5 col2\" >Missing Data</td>\n",
              "      <td id=\"T_98bc8_row5_col3\" class=\"data row5 col3\" >Missing Data</td>\n",
              "      <td id=\"T_98bc8_row5_col4\" class=\"data row5 col4\" >1,000,115.031</td>\n",
              "      <td id=\"T_98bc8_row5_col5\" class=\"data row5 col5\" >1,000,117.359</td>\n",
              "      <td id=\"T_98bc8_row5_col6\" class=\"data row5 col6\" >1,000,108.697</td>\n",
              "      <td id=\"T_98bc8_row5_col7\" class=\"data row5 col7\" >1,000,109.489</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n"
            ]
          },
          "metadata": {},
          "execution_count": 26
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Set css style values for headers, rows, cells\n",
        "\n",
        "Note: overwrite: (bool), default True\n",
        "Styles are replaced if True, or extended if False. CSS rules are preserved so most recent styles set will dominate if selectors intersect."
      ],
      "metadata": {
        "id": "Vg8soY9Hi46w"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "(\n",
        "df_new.head(10)\n",
        "  .style\n",
        "     .set_table_styles([  # create internal CSS classes\n",
        "        {'selector': 'th.col_heading', 'props': 'background-color: yellow;'},\n",
        "        {'selector': 'th.col_heading.level0', 'props': 'background-color: white;'},\n",
        "        {'selector': '.index_name', 'props': 'background-color: darkgrey;'},\n",
        "        {'selector': 'tr:nth-child(5)', 'props': 'background-color: grey;color:blue;'},\n",
        "        {'selector': 'tr:nth-child(5) td:nth-child(5)', 'props': 'background-color: black; color:yellow; font-size:150%;'},\n",
        "        {'selector': 'tr', 'props': 'background-color: lightgrey;color:blue;'}],\n",
        "        overwrite=False)\n",
        ")"
      ],
      "metadata": {
        "id": "9UlOeuBWc0tm",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 410
        },
        "outputId": "5c5dffe3-4c43-44ea-fa22-8287e11c50e3"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x7f71e5ea5880>"
            ],
            "text/html": [
              "<style type=\"text/css\">\n",
              "#T_b8959_ th.col_heading {\n",
              "  background-color: yellow;\n",
              "}\n",
              "#T_b8959_ th.col_heading.level0 {\n",
              "  background-color: white;\n",
              "}\n",
              "#T_b8959_ .index_name {\n",
              "  background-color: darkgrey;\n",
              "}\n",
              "#T_b8959_ tr:nth-child(5) {\n",
              "  background-color: grey;\n",
              "  color: blue;\n",
              "}\n",
              "#T_b8959_ tr:nth-child(5) td:nth-child(5) {\n",
              "  background-color: black;\n",
              "  color: yellow;\n",
              "  font-size: 150%;\n",
              "}\n",
              "#T_b8959_ tr {\n",
              "  background-color: lightgrey;\n",
              "  color: blue;\n",
              "}\n",
              "</style>\n",
              "<table id=\"T_b8959_\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr>\n",
              "      <th class=\"blank level0\" >&nbsp;</th>\n",
              "      <th class=\"col_heading level0 col0\" >Open</th>\n",
              "      <th class=\"col_heading level0 col1\" >High</th>\n",
              "      <th class=\"col_heading level0 col2\" >Low</th>\n",
              "      <th class=\"col_heading level0 col3\" >Close</th>\n",
              "      <th class=\"col_heading level0 col4\" >OpenEuro</th>\n",
              "      <th class=\"col_heading level0 col5\" >HighEuro</th>\n",
              "      <th class=\"col_heading level0 col6\" >LowEuro</th>\n",
              "      <th class=\"col_heading level0 col7\" >CloseEuro</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th class=\"index_name level0\" >Date</th>\n",
              "      <th class=\"blank col0\" >&nbsp;</th>\n",
              "      <th class=\"blank col1\" >&nbsp;</th>\n",
              "      <th class=\"blank col2\" >&nbsp;</th>\n",
              "      <th class=\"blank col3\" >&nbsp;</th>\n",
              "      <th class=\"blank col4\" >&nbsp;</th>\n",
              "      <th class=\"blank col5\" >&nbsp;</th>\n",
              "      <th class=\"blank col6\" >&nbsp;</th>\n",
              "      <th class=\"blank col7\" >&nbsp;</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th id=\"T_b8959_level0_row0\" class=\"row_heading level0 row0\" >2000-01-03</th>\n",
              "      <td id=\"T_b8959_row0_col0\" class=\"data row0 col0\" >122.250000</td>\n",
              "      <td id=\"T_b8959_row0_col1\" class=\"data row0 col1\" >124.000000</td>\n",
              "      <td id=\"T_b8959_row0_col2\" class=\"data row0 col2\" >116.100000</td>\n",
              "      <td id=\"T_b8959_row0_col3\" class=\"data row0 col3\" >116.500000</td>\n",
              "      <td id=\"T_b8959_row0_col4\" class=\"data row0 col4\" >113.866339</td>\n",
              "      <td id=\"T_b8959_row0_col5\" class=\"data row0 col5\" >115.496328</td>\n",
              "      <td id=\"T_b8959_row0_col6\" class=\"data row0 col6\" >108.138094</td>\n",
              "      <td id=\"T_b8959_row0_col7\" class=\"data row0 col7\" >108.510663</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_b8959_level0_row1\" class=\"row_heading level0 row1\" >2000-01-04</th>\n",
              "      <td id=\"T_b8959_row1_col0\" class=\"data row1 col0\" >116.250000</td>\n",
              "      <td id=\"T_b8959_row1_col1\" class=\"data row1 col1\" >120.500000</td>\n",
              "      <td id=\"T_b8959_row1_col2\" class=\"data row1 col2\" >115.750000</td>\n",
              "      <td id=\"T_b8959_row1_col3\" class=\"data row1 col3\" >116.250000</td>\n",
              "      <td id=\"T_b8959_row1_col4\" class=\"data row1 col4\" >108.277807</td>\n",
              "      <td id=\"T_b8959_row1_col5\" class=\"data row1 col5\" >112.236351</td>\n",
              "      <td id=\"T_b8959_row1_col6\" class=\"data row1 col6\" >107.812096</td>\n",
              "      <td id=\"T_b8959_row1_col7\" class=\"data row1 col7\" >108.277807</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_b8959_level0_row2\" class=\"row_heading level0 row2\" >2000-01-05</th>\n",
              "      <td id=\"T_b8959_row2_col0\" class=\"data row2 col0\" >115.000000</td>\n",
              "      <td id=\"T_b8959_row2_col1\" class=\"data row2 col1\" >121.000000</td>\n",
              "      <td id=\"T_b8959_row2_col2\" class=\"data row2 col2\" >115.000000</td>\n",
              "      <td id=\"T_b8959_row2_col3\" class=\"data row2 col3\" >118.600000</td>\n",
              "      <td id=\"T_b8959_row2_col4\" class=\"data row2 col4\" >107.113530</td>\n",
              "      <td id=\"T_b8959_row2_col5\" class=\"data row2 col5\" >112.702062</td>\n",
              "      <td id=\"T_b8959_row2_col6\" class=\"data row2 col6\" >107.113530</td>\n",
              "      <td id=\"T_b8959_row2_col7\" class=\"data row2 col7\" >110.466649</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_b8959_level0_row3\" class=\"row_heading level0 row3\" >2000-01-06</th>\n",
              "      <td id=\"T_b8959_row3_col0\" class=\"data row3 col0\" >119.000000</td>\n",
              "      <td id=\"T_b8959_row3_col1\" class=\"data row3 col1\" >121.400000</td>\n",
              "      <td id=\"T_b8959_row3_col2\" class=\"data row3 col2\" >116.500000</td>\n",
              "      <td id=\"T_b8959_row3_col3\" class=\"data row3 col3\" >116.850000</td>\n",
              "      <td id=\"T_b8959_row3_col4\" class=\"data row3 col4\" >110.839218</td>\n",
              "      <td id=\"T_b8959_row3_col5\" class=\"data row3 col5\" >113.074631</td>\n",
              "      <td id=\"T_b8959_row3_col6\" class=\"data row3 col6\" >108.510663</td>\n",
              "      <td id=\"T_b8959_row3_col7\" class=\"data row3 col7\" >108.836661</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_b8959_level0_row4\" class=\"row_heading level0 row4\" >2000-01-07</th>\n",
              "      <td id=\"T_b8959_row4_col0\" class=\"data row4 col0\" >117.250000</td>\n",
              "      <td id=\"T_b8959_row4_col1\" class=\"data row4 col1\" >117.750000</td>\n",
              "      <td id=\"T_b8959_row4_col2\" class=\"data row4 col2\" >113.800000</td>\n",
              "      <td id=\"T_b8959_row4_col3\" class=\"data row4 col3\" >114.150000</td>\n",
              "      <td id=\"T_b8959_row4_col4\" class=\"data row4 col4\" >109.209229</td>\n",
              "      <td id=\"T_b8959_row4_col5\" class=\"data row4 col5\" >109.674940</td>\n",
              "      <td id=\"T_b8959_row4_col6\" class=\"data row4 col6\" >105.995824</td>\n",
              "      <td id=\"T_b8959_row4_col7\" class=\"data row4 col7\" >106.321821</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_b8959_level0_row5\" class=\"row_heading level0 row5\" >2000-01-10</th>\n",
              "      <td id=\"T_b8959_row5_col0\" class=\"data row5 col0\" >123.500000</td>\n",
              "      <td id=\"T_b8959_row5_col1\" class=\"data row5 col1\" >126.000000</td>\n",
              "      <td id=\"T_b8959_row5_col2\" class=\"data row5 col2\" >116.700000</td>\n",
              "      <td id=\"T_b8959_row5_col3\" class=\"data row5 col3\" >117.550000</td>\n",
              "      <td id=\"T_b8959_row5_col4\" class=\"data row5 col4\" >115.030617</td>\n",
              "      <td id=\"T_b8959_row5_col5\" class=\"data row5 col5\" >117.359172</td>\n",
              "      <td id=\"T_b8959_row5_col6\" class=\"data row5 col6\" >108.696947</td>\n",
              "      <td id=\"T_b8959_row5_col7\" class=\"data row5 col7\" >109.488656</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_b8959_level0_row6\" class=\"row_heading level0 row6\" >2000-01-11</th>\n",
              "      <td id=\"T_b8959_row6_col0\" class=\"data row6 col0\" >115.500000</td>\n",
              "      <td id=\"T_b8959_row6_col1\" class=\"data row6 col1\" >118.250000</td>\n",
              "      <td id=\"T_b8959_row6_col2\" class=\"data row6 col2\" >115.500000</td>\n",
              "      <td id=\"T_b8959_row6_col3\" class=\"data row6 col3\" >117.800000</td>\n",
              "      <td id=\"T_b8959_row6_col4\" class=\"data row6 col4\" >107.579241</td>\n",
              "      <td id=\"T_b8959_row6_col5\" class=\"data row6 col5\" >110.140651</td>\n",
              "      <td id=\"T_b8959_row6_col6\" class=\"data row6 col6\" >107.579241</td>\n",
              "      <td id=\"T_b8959_row6_col7\" class=\"data row6 col7\" >109.721512</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_b8959_level0_row7\" class=\"row_heading level0 row7\" >2000-01-12</th>\n",
              "      <td id=\"T_b8959_row7_col0\" class=\"data row7 col0\" >117.800000</td>\n",
              "      <td id=\"T_b8959_row7_col1\" class=\"data row7 col1\" >120.500000</td>\n",
              "      <td id=\"T_b8959_row7_col2\" class=\"data row7 col2\" >116.900000</td>\n",
              "      <td id=\"T_b8959_row7_col3\" class=\"data row7 col3\" >118.950000</td>\n",
              "      <td id=\"T_b8959_row7_col4\" class=\"data row7 col4\" >109.721512</td>\n",
              "      <td id=\"T_b8959_row7_col5\" class=\"data row7 col5\" >112.236351</td>\n",
              "      <td id=\"T_b8959_row7_col6\" class=\"data row7 col6\" >108.883232</td>\n",
              "      <td id=\"T_b8959_row7_col7\" class=\"data row7 col7\" >110.792647</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_b8959_level0_row8\" class=\"row_heading level0 row8\" >2000-01-13</th>\n",
              "      <td id=\"T_b8959_row8_col0\" class=\"data row8 col0\" >119.250000</td>\n",
              "      <td id=\"T_b8959_row8_col1\" class=\"data row8 col1\" >120.000000</td>\n",
              "      <td id=\"T_b8959_row8_col2\" class=\"data row8 col2\" >117.500000</td>\n",
              "      <td id=\"T_b8959_row8_col3\" class=\"data row8 col3\" >118.550000</td>\n",
              "      <td id=\"T_b8959_row8_col4\" class=\"data row8 col4\" >111.072074</td>\n",
              "      <td id=\"T_b8959_row8_col5\" class=\"data row8 col5\" >111.770640</td>\n",
              "      <td id=\"T_b8959_row8_col6\" class=\"data row8 col6\" >109.442085</td>\n",
              "      <td id=\"T_b8959_row8_col7\" class=\"data row8 col7\" >110.420078</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_b8959_level0_row9\" class=\"row_heading level0 row9\" >2000-01-14</th>\n",
              "      <td id=\"T_b8959_row9_col0\" class=\"data row9 col0\" >117.750000</td>\n",
              "      <td id=\"T_b8959_row9_col1\" class=\"data row9 col1\" >120.250000</td>\n",
              "      <td id=\"T_b8959_row9_col2\" class=\"data row9 col2\" >112.250000</td>\n",
              "      <td id=\"T_b8959_row9_col3\" class=\"data row9 col3\" >112.550000</td>\n",
              "      <td id=\"T_b8959_row9_col4\" class=\"data row9 col4\" >109.674940</td>\n",
              "      <td id=\"T_b8959_row9_col5\" class=\"data row9 col5\" >112.003495</td>\n",
              "      <td id=\"T_b8959_row9_col6\" class=\"data row9 col6\" >104.552120</td>\n",
              "      <td id=\"T_b8959_row9_col7\" class=\"data row9 col7\" >104.831546</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n"
            ]
          },
          "metadata": {},
          "execution_count": 27
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Get min and max values from selected columns in dataframe"
      ],
      "metadata": {
        "id": "MPBs3TSxnAVd"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "cols=['Open','High','Low','Close']\n",
        "df_min = df_new[cols].min()\n",
        "df_max = df_new[cols].max()\n",
        "df_median = df_new.median()\n",
        "\n",
        "vmin = df_min.min()\n",
        "vmax = df_max.max()\n",
        "vmedian = df_median.median()\n",
        "\n",
        "print(type(vmedian))"
      ],
      "metadata": {
        "id": "rq-WwUumjzJy",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "564bb67a-f538-4aed-b958-ea1f069feca2"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'numpy.float64'>\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Stle dataframe according to min and max price values"
      ],
      "metadata": {
        "id": "xqugnTuMnIhk"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "\n",
        "cols=['Open','High','Low','Close']\n",
        "df_new[cols].head(10).style.background_gradient(cmap='YlOrRd', vmin=vmin, vmax=vmax)"
      ],
      "metadata": {
        "id": "EiYzLQAdczxl",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 394
        },
        "outputId": "d4b091d0-df63-4380-9274-a325d227cffd"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x7f71e5ea5e20>"
            ],
            "text/html": [
              "<style type=\"text/css\">\n",
              "#T_78543_row0_col0 {\n",
              "  background-color: #e7231e;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_78543_row0_col1 {\n",
              "  background-color: #c30424;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_78543_row0_col2 {\n",
              "  background-color: #fed06c;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row0_col3, #T_78543_row3_col2 {\n",
              "  background-color: #fec662;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row1_col0, #T_78543_row1_col3 {\n",
              "  background-color: #fecc68;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row1_col1, #T_78543_row7_col1 {\n",
              "  background-color: #fc5b2e;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_78543_row1_col2 {\n",
              "  background-color: #fed774;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row2_col0, #T_78543_row2_col2 {\n",
              "  background-color: #fee187;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row2_col1 {\n",
              "  background-color: #fa4a29;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_78543_row2_col3 {\n",
              "  background-color: #fd9841;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row3_col0 {\n",
              "  background-color: #fd903d;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row3_col1 {\n",
              "  background-color: #f43d25;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_78543_row3_col3 {\n",
              "  background-color: #febf5a;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row4_col0 {\n",
              "  background-color: #feb54f;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row4_col1, #T_78543_row9_col0 {\n",
              "  background-color: #feab49;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row4_col2 {\n",
              "  background-color: #ffefa5;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row4_col3 {\n",
              "  background-color: #ffeb9c;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row5_col0 {\n",
              "  background-color: #ce0c22;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_78543_row5_col1 {\n",
              "  background-color: #800026;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_78543_row5_col2 {\n",
              "  background-color: #fec35e;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row5_col3 {\n",
              "  background-color: #feaf4b;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row6_col0, #T_78543_row6_col2 {\n",
              "  background-color: #fedb7b;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row6_col1 {\n",
              "  background-color: #fea044;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row6_col3, #T_78543_row7_col0 {\n",
              "  background-color: #fea948;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row7_col2 {\n",
              "  background-color: #febe59;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row7_col3 {\n",
              "  background-color: #fd913e;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row8_col0 {\n",
              "  background-color: #fd883b;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_78543_row8_col1 {\n",
              "  background-color: #fc6c33;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_78543_row8_col2 {\n",
              "  background-color: #feb04b;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row8_col3 {\n",
              "  background-color: #fd9941;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row9_col1 {\n",
              "  background-color: #fc6430;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_78543_row9_col2 {\n",
              "  background-color: #ffffcc;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_78543_row9_col3 {\n",
              "  background-color: #fffcc5;\n",
              "  color: #000000;\n",
              "}\n",
              "</style>\n",
              "<table id=\"T_78543_\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr>\n",
              "      <th class=\"blank level0\" >&nbsp;</th>\n",
              "      <th class=\"col_heading level0 col0\" >Open</th>\n",
              "      <th class=\"col_heading level0 col1\" >High</th>\n",
              "      <th class=\"col_heading level0 col2\" >Low</th>\n",
              "      <th class=\"col_heading level0 col3\" >Close</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th class=\"index_name level0\" >Date</th>\n",
              "      <th class=\"blank col0\" >&nbsp;</th>\n",
              "      <th class=\"blank col1\" >&nbsp;</th>\n",
              "      <th class=\"blank col2\" >&nbsp;</th>\n",
              "      <th class=\"blank col3\" >&nbsp;</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th id=\"T_78543_level0_row0\" class=\"row_heading level0 row0\" >2000-01-03</th>\n",
              "      <td id=\"T_78543_row0_col0\" class=\"data row0 col0\" >122.250000</td>\n",
              "      <td id=\"T_78543_row0_col1\" class=\"data row0 col1\" >124.000000</td>\n",
              "      <td id=\"T_78543_row0_col2\" class=\"data row0 col2\" >116.100000</td>\n",
              "      <td id=\"T_78543_row0_col3\" class=\"data row0 col3\" >116.500000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_78543_level0_row1\" class=\"row_heading level0 row1\" >2000-01-04</th>\n",
              "      <td id=\"T_78543_row1_col0\" class=\"data row1 col0\" >116.250000</td>\n",
              "      <td id=\"T_78543_row1_col1\" class=\"data row1 col1\" >120.500000</td>\n",
              "      <td id=\"T_78543_row1_col2\" class=\"data row1 col2\" >115.750000</td>\n",
              "      <td id=\"T_78543_row1_col3\" class=\"data row1 col3\" >116.250000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_78543_level0_row2\" class=\"row_heading level0 row2\" >2000-01-05</th>\n",
              "      <td id=\"T_78543_row2_col0\" class=\"data row2 col0\" >115.000000</td>\n",
              "      <td id=\"T_78543_row2_col1\" class=\"data row2 col1\" >121.000000</td>\n",
              "      <td id=\"T_78543_row2_col2\" class=\"data row2 col2\" >115.000000</td>\n",
              "      <td id=\"T_78543_row2_col3\" class=\"data row2 col3\" >118.600000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_78543_level0_row3\" class=\"row_heading level0 row3\" >2000-01-06</th>\n",
              "      <td id=\"T_78543_row3_col0\" class=\"data row3 col0\" >119.000000</td>\n",
              "      <td id=\"T_78543_row3_col1\" class=\"data row3 col1\" >121.400000</td>\n",
              "      <td id=\"T_78543_row3_col2\" class=\"data row3 col2\" >116.500000</td>\n",
              "      <td id=\"T_78543_row3_col3\" class=\"data row3 col3\" >116.850000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_78543_level0_row4\" class=\"row_heading level0 row4\" >2000-01-07</th>\n",
              "      <td id=\"T_78543_row4_col0\" class=\"data row4 col0\" >117.250000</td>\n",
              "      <td id=\"T_78543_row4_col1\" class=\"data row4 col1\" >117.750000</td>\n",
              "      <td id=\"T_78543_row4_col2\" class=\"data row4 col2\" >113.800000</td>\n",
              "      <td id=\"T_78543_row4_col3\" class=\"data row4 col3\" >114.150000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_78543_level0_row5\" class=\"row_heading level0 row5\" >2000-01-10</th>\n",
              "      <td id=\"T_78543_row5_col0\" class=\"data row5 col0\" >123.500000</td>\n",
              "      <td id=\"T_78543_row5_col1\" class=\"data row5 col1\" >126.000000</td>\n",
              "      <td id=\"T_78543_row5_col2\" class=\"data row5 col2\" >116.700000</td>\n",
              "      <td id=\"T_78543_row5_col3\" class=\"data row5 col3\" >117.550000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_78543_level0_row6\" class=\"row_heading level0 row6\" >2000-01-11</th>\n",
              "      <td id=\"T_78543_row6_col0\" class=\"data row6 col0\" >115.500000</td>\n",
              "      <td id=\"T_78543_row6_col1\" class=\"data row6 col1\" >118.250000</td>\n",
              "      <td id=\"T_78543_row6_col2\" class=\"data row6 col2\" >115.500000</td>\n",
              "      <td id=\"T_78543_row6_col3\" class=\"data row6 col3\" >117.800000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_78543_level0_row7\" class=\"row_heading level0 row7\" >2000-01-12</th>\n",
              "      <td id=\"T_78543_row7_col0\" class=\"data row7 col0\" >117.800000</td>\n",
              "      <td id=\"T_78543_row7_col1\" class=\"data row7 col1\" >120.500000</td>\n",
              "      <td id=\"T_78543_row7_col2\" class=\"data row7 col2\" >116.900000</td>\n",
              "      <td id=\"T_78543_row7_col3\" class=\"data row7 col3\" >118.950000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_78543_level0_row8\" class=\"row_heading level0 row8\" >2000-01-13</th>\n",
              "      <td id=\"T_78543_row8_col0\" class=\"data row8 col0\" >119.250000</td>\n",
              "      <td id=\"T_78543_row8_col1\" class=\"data row8 col1\" >120.000000</td>\n",
              "      <td id=\"T_78543_row8_col2\" class=\"data row8 col2\" >117.500000</td>\n",
              "      <td id=\"T_78543_row8_col3\" class=\"data row8 col3\" >118.550000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_78543_level0_row9\" class=\"row_heading level0 row9\" >2000-01-14</th>\n",
              "      <td id=\"T_78543_row9_col0\" class=\"data row9 col0\" >117.750000</td>\n",
              "      <td id=\"T_78543_row9_col1\" class=\"data row9 col1\" >120.250000</td>\n",
              "      <td id=\"T_78543_row9_col2\" class=\"data row9 col2\" >112.250000</td>\n",
              "      <td id=\"T_78543_row9_col3\" class=\"data row9 col3\" >112.550000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n"
            ]
          },
          "metadata": {},
          "execution_count": 30
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "cols=['Open','High','Low','Close']\n",
        "(df[cols].head(10)\n",
        " .style.highlight_max(color='darkgreen')\n",
        " .set_properties(color=\"white\")\n",
        ")"
      ],
      "metadata": {
        "id": "89YAeUI41_qX",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 394
        },
        "outputId": "c04d686a-9017-4e85-9ab5-dbad0b4c07c7"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x7f71e5e970a0>"
            ],
            "text/html": [
              "<style type=\"text/css\">\n",
              "#T_0f14c_row0_col0, #T_0f14c_row0_col1, #T_0f14c_row0_col2, #T_0f14c_row0_col3, #T_0f14c_row1_col0, #T_0f14c_row1_col1, #T_0f14c_row1_col2, #T_0f14c_row1_col3, #T_0f14c_row2_col0, #T_0f14c_row2_col1, #T_0f14c_row2_col2, #T_0f14c_row2_col3, #T_0f14c_row3_col0, #T_0f14c_row3_col1, #T_0f14c_row3_col2, #T_0f14c_row3_col3, #T_0f14c_row4_col0, #T_0f14c_row4_col1, #T_0f14c_row4_col2, #T_0f14c_row4_col3, #T_0f14c_row5_col2, #T_0f14c_row5_col3, #T_0f14c_row6_col0, #T_0f14c_row6_col1, #T_0f14c_row6_col2, #T_0f14c_row6_col3, #T_0f14c_row7_col0, #T_0f14c_row7_col1, #T_0f14c_row7_col2, #T_0f14c_row8_col0, #T_0f14c_row8_col1, #T_0f14c_row8_col3, #T_0f14c_row9_col0, #T_0f14c_row9_col1, #T_0f14c_row9_col2, #T_0f14c_row9_col3 {\n",
              "  color: white;\n",
              "}\n",
              "#T_0f14c_row5_col0, #T_0f14c_row5_col1, #T_0f14c_row7_col3, #T_0f14c_row8_col2 {\n",
              "  background-color: darkgreen;\n",
              "  color: white;\n",
              "}\n",
              "</style>\n",
              "<table id=\"T_0f14c_\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr>\n",
              "      <th class=\"blank level0\" >&nbsp;</th>\n",
              "      <th class=\"col_heading level0 col0\" >Open</th>\n",
              "      <th class=\"col_heading level0 col1\" >High</th>\n",
              "      <th class=\"col_heading level0 col2\" >Low</th>\n",
              "      <th class=\"col_heading level0 col3\" >Close</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th class=\"index_name level0\" >Date</th>\n",
              "      <th class=\"blank col0\" >&nbsp;</th>\n",
              "      <th class=\"blank col1\" >&nbsp;</th>\n",
              "      <th class=\"blank col2\" >&nbsp;</th>\n",
              "      <th class=\"blank col3\" >&nbsp;</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th id=\"T_0f14c_level0_row0\" class=\"row_heading level0 row0\" >2000-01-03</th>\n",
              "      <td id=\"T_0f14c_row0_col0\" class=\"data row0 col0\" >122.250000</td>\n",
              "      <td id=\"T_0f14c_row0_col1\" class=\"data row0 col1\" >124.000000</td>\n",
              "      <td id=\"T_0f14c_row0_col2\" class=\"data row0 col2\" >116.100000</td>\n",
              "      <td id=\"T_0f14c_row0_col3\" class=\"data row0 col3\" >116.500000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_0f14c_level0_row1\" class=\"row_heading level0 row1\" >2000-01-04</th>\n",
              "      <td id=\"T_0f14c_row1_col0\" class=\"data row1 col0\" >116.250000</td>\n",
              "      <td id=\"T_0f14c_row1_col1\" class=\"data row1 col1\" >120.500000</td>\n",
              "      <td id=\"T_0f14c_row1_col2\" class=\"data row1 col2\" >115.750000</td>\n",
              "      <td id=\"T_0f14c_row1_col3\" class=\"data row1 col3\" >116.250000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_0f14c_level0_row2\" class=\"row_heading level0 row2\" >2000-01-05</th>\n",
              "      <td id=\"T_0f14c_row2_col0\" class=\"data row2 col0\" >115.000000</td>\n",
              "      <td id=\"T_0f14c_row2_col1\" class=\"data row2 col1\" >121.000000</td>\n",
              "      <td id=\"T_0f14c_row2_col2\" class=\"data row2 col2\" >115.000000</td>\n",
              "      <td id=\"T_0f14c_row2_col3\" class=\"data row2 col3\" >118.600000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_0f14c_level0_row3\" class=\"row_heading level0 row3\" >2000-01-06</th>\n",
              "      <td id=\"T_0f14c_row3_col0\" class=\"data row3 col0\" >119.000000</td>\n",
              "      <td id=\"T_0f14c_row3_col1\" class=\"data row3 col1\" >121.400000</td>\n",
              "      <td id=\"T_0f14c_row3_col2\" class=\"data row3 col2\" >116.500000</td>\n",
              "      <td id=\"T_0f14c_row3_col3\" class=\"data row3 col3\" >116.850000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_0f14c_level0_row4\" class=\"row_heading level0 row4\" >2000-01-07</th>\n",
              "      <td id=\"T_0f14c_row4_col0\" class=\"data row4 col0\" >117.250000</td>\n",
              "      <td id=\"T_0f14c_row4_col1\" class=\"data row4 col1\" >117.750000</td>\n",
              "      <td id=\"T_0f14c_row4_col2\" class=\"data row4 col2\" >113.800000</td>\n",
              "      <td id=\"T_0f14c_row4_col3\" class=\"data row4 col3\" >114.150000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_0f14c_level0_row5\" class=\"row_heading level0 row5\" >2000-01-10</th>\n",
              "      <td id=\"T_0f14c_row5_col0\" class=\"data row5 col0\" >123.500000</td>\n",
              "      <td id=\"T_0f14c_row5_col1\" class=\"data row5 col1\" >126.000000</td>\n",
              "      <td id=\"T_0f14c_row5_col2\" class=\"data row5 col2\" >116.700000</td>\n",
              "      <td id=\"T_0f14c_row5_col3\" class=\"data row5 col3\" >117.550000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_0f14c_level0_row6\" class=\"row_heading level0 row6\" >2000-01-11</th>\n",
              "      <td id=\"T_0f14c_row6_col0\" class=\"data row6 col0\" >115.500000</td>\n",
              "      <td id=\"T_0f14c_row6_col1\" class=\"data row6 col1\" >118.250000</td>\n",
              "      <td id=\"T_0f14c_row6_col2\" class=\"data row6 col2\" >115.500000</td>\n",
              "      <td id=\"T_0f14c_row6_col3\" class=\"data row6 col3\" >117.800000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_0f14c_level0_row7\" class=\"row_heading level0 row7\" >2000-01-12</th>\n",
              "      <td id=\"T_0f14c_row7_col0\" class=\"data row7 col0\" >117.800000</td>\n",
              "      <td id=\"T_0f14c_row7_col1\" class=\"data row7 col1\" >120.500000</td>\n",
              "      <td id=\"T_0f14c_row7_col2\" class=\"data row7 col2\" >116.900000</td>\n",
              "      <td id=\"T_0f14c_row7_col3\" class=\"data row7 col3\" >118.950000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_0f14c_level0_row8\" class=\"row_heading level0 row8\" >2000-01-13</th>\n",
              "      <td id=\"T_0f14c_row8_col0\" class=\"data row8 col0\" >119.250000</td>\n",
              "      <td id=\"T_0f14c_row8_col1\" class=\"data row8 col1\" >120.000000</td>\n",
              "      <td id=\"T_0f14c_row8_col2\" class=\"data row8 col2\" >117.500000</td>\n",
              "      <td id=\"T_0f14c_row8_col3\" class=\"data row8 col3\" >118.550000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_0f14c_level0_row9\" class=\"row_heading level0 row9\" >2000-01-14</th>\n",
              "      <td id=\"T_0f14c_row9_col0\" class=\"data row9 col0\" >117.750000</td>\n",
              "      <td id=\"T_0f14c_row9_col1\" class=\"data row9 col1\" >120.250000</td>\n",
              "      <td id=\"T_0f14c_row9_col2\" class=\"data row9 col2\" >112.250000</td>\n",
              "      <td id=\"T_0f14c_row9_col3\" class=\"data row9 col3\" >112.550000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n"
            ]
          },
          "metadata": {},
          "execution_count": 31
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "cols=['Open','High','Low','Close']\n",
        "(df[cols].head(10)\n",
        "   .style.background_gradient(axis=0).highlight_min(color='lightgreen')\n",
        ")"
      ],
      "metadata": {
        "id": "jhkvFtRL2ffe",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 394
        },
        "outputId": "dc2ce9ed-6035-426a-a99a-f0bbc7249e74"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x7f71e5ea5460>"
            ],
            "text/html": [
              "<style type=\"text/css\">\n",
              "#T_6df8d_row0_col0 {\n",
              "  background-color: #045e93;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_6df8d_row0_col1 {\n",
              "  background-color: #056fae;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_6df8d_row0_col2 {\n",
              "  background-color: #0c74b2;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_6df8d_row0_col3 {\n",
              "  background-color: #3b92c1;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_6df8d_row1_col0 {\n",
              "  background-color: #e7e3f0;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_6df8d_row1_col1, #T_6df8d_row7_col1 {\n",
              "  background-color: #b4c4df;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_6df8d_row1_col2 {\n",
              "  background-color: #2685bb;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_6df8d_row1_col3 {\n",
              "  background-color: #4e9ac6;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_6df8d_row2_col0, #T_6df8d_row4_col1, #T_6df8d_row9_col2, #T_6df8d_row9_col3 {\n",
              "  background-color: #fff7fb;\n",
              "  color: #000000;\n",
              "  background-color: lightgreen;\n",
              "}\n",
              "#T_6df8d_row2_col1 {\n",
              "  background-color: #9fbad9;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_6df8d_row2_col2 {\n",
              "  background-color: #67a4cc;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_6df8d_row2_col3 {\n",
              "  background-color: #03476f;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_6df8d_row3_col0 {\n",
              "  background-color: #80aed2;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_6df8d_row3_col1 {\n",
              "  background-color: #8bb2d4;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_6df8d_row3_col2 {\n",
              "  background-color: #05659f;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_6df8d_row3_col3 {\n",
              "  background-color: #2484ba;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_6df8d_row4_col0 {\n",
              "  background-color: #cccfe5;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_6df8d_row4_col2 {\n",
              "  background-color: #c1cae2;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_6df8d_row4_col3 {\n",
              "  background-color: #d0d1e6;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_6df8d_row5_col0, #T_6df8d_row5_col1, #T_6df8d_row7_col3, #T_6df8d_row8_col2 {\n",
              "  background-color: #023858;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_6df8d_row5_col2 {\n",
              "  background-color: #045f95;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_6df8d_row5_col3 {\n",
              "  background-color: #056ba7;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_6df8d_row6_col0, #T_6df8d_row6_col1 {\n",
              "  background-color: #f6eff7;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_6df8d_row6_col2 {\n",
              "  background-color: #3991c1;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_6df8d_row6_col3 {\n",
              "  background-color: #04649d;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_6df8d_row7_col0 {\n",
              "  background-color: #b5c4df;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_6df8d_row7_col2 {\n",
              "  background-color: #045788;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_6df8d_row8_col0 {\n",
              "  background-color: #73a9cf;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_6df8d_row8_col1 {\n",
              "  background-color: #c9cee4;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_6df8d_row8_col3 {\n",
              "  background-color: #034973;\n",
              "  color: #f1f1f1;\n",
              "}\n",
              "#T_6df8d_row9_col0 {\n",
              "  background-color: #b8c6e0;\n",
              "  color: #000000;\n",
              "}\n",
              "#T_6df8d_row9_col1 {\n",
              "  background-color: #bfc9e1;\n",
              "  color: #000000;\n",
              "}\n",
              "</style>\n",
              "<table id=\"T_6df8d_\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr>\n",
              "      <th class=\"blank level0\" >&nbsp;</th>\n",
              "      <th class=\"col_heading level0 col0\" >Open</th>\n",
              "      <th class=\"col_heading level0 col1\" >High</th>\n",
              "      <th class=\"col_heading level0 col2\" >Low</th>\n",
              "      <th class=\"col_heading level0 col3\" >Close</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th class=\"index_name level0\" >Date</th>\n",
              "      <th class=\"blank col0\" >&nbsp;</th>\n",
              "      <th class=\"blank col1\" >&nbsp;</th>\n",
              "      <th class=\"blank col2\" >&nbsp;</th>\n",
              "      <th class=\"blank col3\" >&nbsp;</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th id=\"T_6df8d_level0_row0\" class=\"row_heading level0 row0\" >2000-01-03</th>\n",
              "      <td id=\"T_6df8d_row0_col0\" class=\"data row0 col0\" >122.250000</td>\n",
              "      <td id=\"T_6df8d_row0_col1\" class=\"data row0 col1\" >124.000000</td>\n",
              "      <td id=\"T_6df8d_row0_col2\" class=\"data row0 col2\" >116.100000</td>\n",
              "      <td id=\"T_6df8d_row0_col3\" class=\"data row0 col3\" >116.500000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_6df8d_level0_row1\" class=\"row_heading level0 row1\" >2000-01-04</th>\n",
              "      <td id=\"T_6df8d_row1_col0\" class=\"data row1 col0\" >116.250000</td>\n",
              "      <td id=\"T_6df8d_row1_col1\" class=\"data row1 col1\" >120.500000</td>\n",
              "      <td id=\"T_6df8d_row1_col2\" class=\"data row1 col2\" >115.750000</td>\n",
              "      <td id=\"T_6df8d_row1_col3\" class=\"data row1 col3\" >116.250000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_6df8d_level0_row2\" class=\"row_heading level0 row2\" >2000-01-05</th>\n",
              "      <td id=\"T_6df8d_row2_col0\" class=\"data row2 col0\" >115.000000</td>\n",
              "      <td id=\"T_6df8d_row2_col1\" class=\"data row2 col1\" >121.000000</td>\n",
              "      <td id=\"T_6df8d_row2_col2\" class=\"data row2 col2\" >115.000000</td>\n",
              "      <td id=\"T_6df8d_row2_col3\" class=\"data row2 col3\" >118.600000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_6df8d_level0_row3\" class=\"row_heading level0 row3\" >2000-01-06</th>\n",
              "      <td id=\"T_6df8d_row3_col0\" class=\"data row3 col0\" >119.000000</td>\n",
              "      <td id=\"T_6df8d_row3_col1\" class=\"data row3 col1\" >121.400000</td>\n",
              "      <td id=\"T_6df8d_row3_col2\" class=\"data row3 col2\" >116.500000</td>\n",
              "      <td id=\"T_6df8d_row3_col3\" class=\"data row3 col3\" >116.850000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_6df8d_level0_row4\" class=\"row_heading level0 row4\" >2000-01-07</th>\n",
              "      <td id=\"T_6df8d_row4_col0\" class=\"data row4 col0\" >117.250000</td>\n",
              "      <td id=\"T_6df8d_row4_col1\" class=\"data row4 col1\" >117.750000</td>\n",
              "      <td id=\"T_6df8d_row4_col2\" class=\"data row4 col2\" >113.800000</td>\n",
              "      <td id=\"T_6df8d_row4_col3\" class=\"data row4 col3\" >114.150000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_6df8d_level0_row5\" class=\"row_heading level0 row5\" >2000-01-10</th>\n",
              "      <td id=\"T_6df8d_row5_col0\" class=\"data row5 col0\" >123.500000</td>\n",
              "      <td id=\"T_6df8d_row5_col1\" class=\"data row5 col1\" >126.000000</td>\n",
              "      <td id=\"T_6df8d_row5_col2\" class=\"data row5 col2\" >116.700000</td>\n",
              "      <td id=\"T_6df8d_row5_col3\" class=\"data row5 col3\" >117.550000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_6df8d_level0_row6\" class=\"row_heading level0 row6\" >2000-01-11</th>\n",
              "      <td id=\"T_6df8d_row6_col0\" class=\"data row6 col0\" >115.500000</td>\n",
              "      <td id=\"T_6df8d_row6_col1\" class=\"data row6 col1\" >118.250000</td>\n",
              "      <td id=\"T_6df8d_row6_col2\" class=\"data row6 col2\" >115.500000</td>\n",
              "      <td id=\"T_6df8d_row6_col3\" class=\"data row6 col3\" >117.800000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_6df8d_level0_row7\" class=\"row_heading level0 row7\" >2000-01-12</th>\n",
              "      <td id=\"T_6df8d_row7_col0\" class=\"data row7 col0\" >117.800000</td>\n",
              "      <td id=\"T_6df8d_row7_col1\" class=\"data row7 col1\" >120.500000</td>\n",
              "      <td id=\"T_6df8d_row7_col2\" class=\"data row7 col2\" >116.900000</td>\n",
              "      <td id=\"T_6df8d_row7_col3\" class=\"data row7 col3\" >118.950000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_6df8d_level0_row8\" class=\"row_heading level0 row8\" >2000-01-13</th>\n",
              "      <td id=\"T_6df8d_row8_col0\" class=\"data row8 col0\" >119.250000</td>\n",
              "      <td id=\"T_6df8d_row8_col1\" class=\"data row8 col1\" >120.000000</td>\n",
              "      <td id=\"T_6df8d_row8_col2\" class=\"data row8 col2\" >117.500000</td>\n",
              "      <td id=\"T_6df8d_row8_col3\" class=\"data row8 col3\" >118.550000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_6df8d_level0_row9\" class=\"row_heading level0 row9\" >2000-01-14</th>\n",
              "      <td id=\"T_6df8d_row9_col0\" class=\"data row9 col0\" >117.750000</td>\n",
              "      <td id=\"T_6df8d_row9_col1\" class=\"data row9 col1\" >120.250000</td>\n",
              "      <td id=\"T_6df8d_row9_col2\" class=\"data row9 col2\" >112.250000</td>\n",
              "      <td id=\"T_6df8d_row9_col3\" class=\"data row9 col3\" >112.550000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n"
            ]
          },
          "metadata": {},
          "execution_count": 32
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Show stock prices below $114 in bold red"
      ],
      "metadata": {
        "id": "t3fLdOl23gOS"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "print(vmedian)\n",
        "\n",
        "def style_lowprice(v, props=''):\n",
        "    return props if v < vmedian else None\n",
        "\n",
        "( df.iloc[10:20,1:3].style.applymap(style_lowprice, props='color:red;font-weight:bold; font-size:120%')\n",
        "              .applymap(lambda v: 'opacity: 80%;' if (v < vmedian) else None)\n",
        ")"
      ],
      "metadata": {
        "id": "xqDD1pgv3Cz3",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 469
        },
        "outputId": "280872df-1647-42bb-e5e8-574315eb51cf"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "114.0806755\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x7f71e5ec68e0>"
            ],
            "text/html": [
              "<style type=\"text/css\">\n",
              "#T_0bd45_row0_col1, #T_0bd45_row2_col1, #T_0bd45_row3_col0, #T_0bd45_row3_col1, #T_0bd45_row4_col1, #T_0bd45_row5_col0, #T_0bd45_row5_col1, #T_0bd45_row6_col1, #T_0bd45_row7_col1, #T_0bd45_row8_col1, #T_0bd45_row9_col0, #T_0bd45_row9_col1 {\n",
              "  color: red;\n",
              "  font-weight: bold;\n",
              "  font-size: 120%;\n",
              "  opacity: 80%;\n",
              "}\n",
              "</style>\n",
              "<table id=\"T_0bd45_\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr>\n",
              "      <th class=\"blank level0\" >&nbsp;</th>\n",
              "      <th class=\"col_heading level0 col0\" >High</th>\n",
              "      <th class=\"col_heading level0 col1\" >Low</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th class=\"index_name level0\" >Date</th>\n",
              "      <th class=\"blank col0\" >&nbsp;</th>\n",
              "      <th class=\"blank col1\" >&nbsp;</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th id=\"T_0bd45_level0_row0\" class=\"row_heading level0 row0\" >2000-01-18</th>\n",
              "      <td id=\"T_0bd45_row0_col0\" class=\"data row0 col0\" >118.250000</td>\n",
              "      <td id=\"T_0bd45_row0_col1\" class=\"data row0 col1\" >110.600000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_0bd45_level0_row1\" class=\"row_heading level0 row1\" >2000-01-19</th>\n",
              "      <td id=\"T_0bd45_row1_col0\" class=\"data row1 col0\" >118.250000</td>\n",
              "      <td id=\"T_0bd45_row1_col1\" class=\"data row1 col1\" >114.750000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_0bd45_level0_row2\" class=\"row_heading level0 row2\" >2000-01-20</th>\n",
              "      <td id=\"T_0bd45_row2_col0\" class=\"data row2 col0\" >118.800000</td>\n",
              "      <td id=\"T_0bd45_row2_col1\" class=\"data row2 col1\" >111.700000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_0bd45_level0_row3\" class=\"row_heading level0 row3\" >2000-01-21</th>\n",
              "      <td id=\"T_0bd45_row3_col0\" class=\"data row3 col0\" >113.500000</td>\n",
              "      <td id=\"T_0bd45_row3_col1\" class=\"data row3 col1\" >110.800000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_0bd45_level0_row4\" class=\"row_heading level0 row4\" >2000-01-24</th>\n",
              "      <td id=\"T_0bd45_row4_col0\" class=\"data row4 col0\" >114.400000</td>\n",
              "      <td id=\"T_0bd45_row4_col1\" class=\"data row4 col1\" >110.950000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_0bd45_level0_row5\" class=\"row_heading level0 row5\" >2000-01-25</th>\n",
              "      <td id=\"T_0bd45_row5_col0\" class=\"data row5 col0\" >113.700000</td>\n",
              "      <td id=\"T_0bd45_row5_col1\" class=\"data row5 col1\" >111.600000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_0bd45_level0_row6\" class=\"row_heading level0 row6\" >2000-01-26</th>\n",
              "      <td id=\"T_0bd45_row6_col0\" class=\"data row6 col0\" >115.300000</td>\n",
              "      <td id=\"T_0bd45_row6_col1\" class=\"data row6 col1\" >111.900000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_0bd45_level0_row7\" class=\"row_heading level0 row7\" >2000-01-27</th>\n",
              "      <td id=\"T_0bd45_row7_col0\" class=\"data row7 col0\" >116.400000</td>\n",
              "      <td id=\"T_0bd45_row7_col1\" class=\"data row7 col1\" >112.800000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_0bd45_level0_row8\" class=\"row_heading level0 row8\" >2000-01-28</th>\n",
              "      <td id=\"T_0bd45_row8_col0\" class=\"data row8 col0\" >115.400000</td>\n",
              "      <td id=\"T_0bd45_row8_col1\" class=\"data row8 col1\" >113.700000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_0bd45_level0_row9\" class=\"row_heading level0 row9\" >2000-01-31</th>\n",
              "      <td id=\"T_0bd45_row9_col0\" class=\"data row9 col0\" >114.000000</td>\n",
              "      <td id=\"T_0bd45_row9_col1\" class=\"data row9 col1\" >110.500000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n"
            ]
          },
          "metadata": {},
          "execution_count": 33
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Highlight max stock value by row comparing Open, High, Low, Close and format stock prices with two decimals"
      ],
      "metadata": {
        "id": "RP_HYD-v3uuK"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "def highlight_max(s, props=''):\n",
        "    return np.where(s == np.nanmax(s.values), props, '')\n",
        "\n",
        "(df.iloc[80:90,0:4]\n",
        "     .style\n",
        "     .format('{:.2f}')\n",
        "     .apply(highlight_max, props='color:white;background-color:green', axis=1)\n",
        ")"
      ],
      "metadata": {
        "id": "x7qRlSuV3C3V",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 394
        },
        "outputId": "1e2a1dbf-7b92-46ab-daa4-7688340047ab"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x7f71e5e97400>"
            ],
            "text/html": [
              "<style type=\"text/css\">\n",
              "#T_6cff3_row0_col1, #T_6cff3_row1_col1, #T_6cff3_row2_col1, #T_6cff3_row2_col3, #T_6cff3_row3_col1, #T_6cff3_row4_col1, #T_6cff3_row5_col1, #T_6cff3_row6_col1, #T_6cff3_row7_col3, #T_6cff3_row8_col1, #T_6cff3_row9_col0, #T_6cff3_row9_col1 {\n",
              "  color: white;\n",
              "  background-color: green;\n",
              "}\n",
              "</style>\n",
              "<table id=\"T_6cff3_\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr>\n",
              "      <th class=\"blank level0\" >&nbsp;</th>\n",
              "      <th class=\"col_heading level0 col0\" >Open</th>\n",
              "      <th class=\"col_heading level0 col1\" >High</th>\n",
              "      <th class=\"col_heading level0 col2\" >Low</th>\n",
              "      <th class=\"col_heading level0 col3\" >Close</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th class=\"index_name level0\" >Date</th>\n",
              "      <th class=\"blank col0\" >&nbsp;</th>\n",
              "      <th class=\"blank col1\" >&nbsp;</th>\n",
              "      <th class=\"blank col2\" >&nbsp;</th>\n",
              "      <th class=\"blank col3\" >&nbsp;</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th id=\"T_6cff3_level0_row0\" class=\"row_heading level0 row0\" >2000-04-27</th>\n",
              "      <td id=\"T_6cff3_row0_col0\" class=\"data row0 col0\" >94.75</td>\n",
              "      <td id=\"T_6cff3_row0_col1\" class=\"data row0 col1\" >95.35</td>\n",
              "      <td id=\"T_6cff3_row0_col2\" class=\"data row0 col2\" >94.50</td>\n",
              "      <td id=\"T_6cff3_row0_col3\" class=\"data row0 col3\" >94.85</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_6cff3_level0_row1\" class=\"row_heading level0 row1\" >2000-04-28</th>\n",
              "      <td id=\"T_6cff3_row1_col0\" class=\"data row1 col0\" >94.50</td>\n",
              "      <td id=\"T_6cff3_row1_col1\" class=\"data row1 col1\" >96.00</td>\n",
              "      <td id=\"T_6cff3_row1_col2\" class=\"data row1 col2\" >94.00</td>\n",
              "      <td id=\"T_6cff3_row1_col3\" class=\"data row1 col3\" >95.30</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_6cff3_level0_row2\" class=\"row_heading level0 row2\" >2000-05-01</th>\n",
              "      <td id=\"T_6cff3_row2_col0\" class=\"data row2 col0\" >96.00</td>\n",
              "      <td id=\"T_6cff3_row2_col1\" class=\"data row2 col1\" >100.30</td>\n",
              "      <td id=\"T_6cff3_row2_col2\" class=\"data row2 col2\" >99.00</td>\n",
              "      <td id=\"T_6cff3_row2_col3\" class=\"data row2 col3\" >100.30</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_6cff3_level0_row3\" class=\"row_heading level0 row3\" >2000-05-02</th>\n",
              "      <td id=\"T_6cff3_row3_col0\" class=\"data row3 col0\" >100.00</td>\n",
              "      <td id=\"T_6cff3_row3_col1\" class=\"data row3 col1\" >100.25</td>\n",
              "      <td id=\"T_6cff3_row3_col2\" class=\"data row3 col2\" >98.00</td>\n",
              "      <td id=\"T_6cff3_row3_col3\" class=\"data row3 col3\" >99.10</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_6cff3_level0_row4\" class=\"row_heading level0 row4\" >2000-05-03</th>\n",
              "      <td id=\"T_6cff3_row4_col0\" class=\"data row4 col0\" >98.00</td>\n",
              "      <td id=\"T_6cff3_row4_col1\" class=\"data row4 col1\" >98.35</td>\n",
              "      <td id=\"T_6cff3_row4_col2\" class=\"data row4 col2\" >94.25</td>\n",
              "      <td id=\"T_6cff3_row4_col3\" class=\"data row4 col3\" >94.45</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_6cff3_level0_row5\" class=\"row_heading level0 row5\" >2000-05-04</th>\n",
              "      <td id=\"T_6cff3_row5_col0\" class=\"data row5 col0\" >94.50</td>\n",
              "      <td id=\"T_6cff3_row5_col1\" class=\"data row5 col1\" >97.00</td>\n",
              "      <td id=\"T_6cff3_row5_col2\" class=\"data row5 col2\" >95.80</td>\n",
              "      <td id=\"T_6cff3_row5_col3\" class=\"data row5 col3\" >96.85</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_6cff3_level0_row6\" class=\"row_heading level0 row6\" >2000-05-05</th>\n",
              "      <td id=\"T_6cff3_row6_col0\" class=\"data row6 col0\" >97.00</td>\n",
              "      <td id=\"T_6cff3_row6_col1\" class=\"data row6 col1\" >97.50</td>\n",
              "      <td id=\"T_6cff3_row6_col2\" class=\"data row6 col2\" >96.50</td>\n",
              "      <td id=\"T_6cff3_row6_col3\" class=\"data row6 col3\" >96.85</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_6cff3_level0_row7\" class=\"row_heading level0 row7\" >2000-05-08</th>\n",
              "      <td id=\"T_6cff3_row7_col0\" class=\"data row7 col0\" >95.50</td>\n",
              "      <td id=\"T_6cff3_row7_col1\" class=\"data row7 col1\" >96.70</td>\n",
              "      <td id=\"T_6cff3_row7_col2\" class=\"data row7 col2\" >96.00</td>\n",
              "      <td id=\"T_6cff3_row7_col3\" class=\"data row7 col3\" >97.15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_6cff3_level0_row8\" class=\"row_heading level0 row8\" >2000-05-09</th>\n",
              "      <td id=\"T_6cff3_row8_col0\" class=\"data row8 col0\" >96.75</td>\n",
              "      <td id=\"T_6cff3_row8_col1\" class=\"data row8 col1\" >99.10</td>\n",
              "      <td id=\"T_6cff3_row8_col2\" class=\"data row8 col2\" >97.00</td>\n",
              "      <td id=\"T_6cff3_row8_col3\" class=\"data row8 col3\" >97.45</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_6cff3_level0_row9\" class=\"row_heading level0 row9\" >2000-05-10</th>\n",
              "      <td id=\"T_6cff3_row9_col0\" class=\"data row9 col0\" >98.50</td>\n",
              "      <td id=\"T_6cff3_row9_col1\" class=\"data row9 col1\" >98.50</td>\n",
              "      <td id=\"T_6cff3_row9_col2\" class=\"data row9 col2\" >97.00</td>\n",
              "      <td id=\"T_6cff3_row9_col3\" class=\"data row9 col3\" >97.25</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n"
            ]
          },
          "metadata": {},
          "execution_count": 34
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Do some css styling for headers, index_names,  rows, and also create hover effect for each row"
      ],
      "metadata": {
        "id": "sQRXdgaspBkE"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "cell_hover = {  # for row hover use <tr> instead of <td>\n",
        "    'selector': 'td:hover',\n",
        "    'props': [('background-color', 'white'),('color', 'blue')]\n",
        "}\n",
        "index_names = {\n",
        "    'selector': '.index_name',\n",
        "    'props': 'font-size: 120%; text-alignment: center; background-color: #6b0000; color: orange; font-weight:normal;'\n",
        "}\n",
        "headers = {\n",
        "    'selector': 'th:not(.index_name)',\n",
        "    'props': 'background-color: #883232; color: lightgreen; text-align:center;'\n",
        "}\n",
        "\n",
        "(df.iloc[50:60,0:4]\n",
        "    .style\n",
        "    .format(precision=2)\n",
        "    .set_table_styles([cell_hover, index_names, headers])\n",
        ")"
      ],
      "metadata": {
        "id": "cgmvk7ZT3C69",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 400
        },
        "outputId": "5e2a5841-ae7c-4f8d-a135-c0aaec3bbea5"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x7f71e5f32eb0>"
            ],
            "text/html": [
              "<style type=\"text/css\">\n",
              "#T_3050b_ td:hover {\n",
              "  background-color: white;\n",
              "  color: blue;\n",
              "}\n",
              "#T_3050b_ .index_name {\n",
              "  font-size: 120%;\n",
              "  text-alignment: center;\n",
              "  background-color: #6b0000;\n",
              "  color: orange;\n",
              "  font-weight: normal;\n",
              "}\n",
              "#T_3050b_ th:not(.index_name) {\n",
              "  background-color: #883232;\n",
              "  color: lightgreen;\n",
              "  text-align: center;\n",
              "}\n",
              "</style>\n",
              "<table id=\"T_3050b_\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr>\n",
              "      <th class=\"blank level0\" >&nbsp;</th>\n",
              "      <th class=\"col_heading level0 col0\" >Open</th>\n",
              "      <th class=\"col_heading level0 col1\" >High</th>\n",
              "      <th class=\"col_heading level0 col2\" >Low</th>\n",
              "      <th class=\"col_heading level0 col3\" >Close</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th class=\"index_name level0\" >Date</th>\n",
              "      <th class=\"blank col0\" >&nbsp;</th>\n",
              "      <th class=\"blank col1\" >&nbsp;</th>\n",
              "      <th class=\"blank col2\" >&nbsp;</th>\n",
              "      <th class=\"blank col3\" >&nbsp;</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th id=\"T_3050b_level0_row0\" class=\"row_heading level0 row0\" >2000-03-15</th>\n",
              "      <td id=\"T_3050b_row0_col0\" class=\"data row0 col0\" >103.00</td>\n",
              "      <td id=\"T_3050b_row0_col1\" class=\"data row0 col1\" >103.00</td>\n",
              "      <td id=\"T_3050b_row0_col2\" class=\"data row0 col2\" >101.50</td>\n",
              "      <td id=\"T_3050b_row0_col3\" class=\"data row0 col3\" >103.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_3050b_level0_row1\" class=\"row_heading level0 row1\" >2000-03-16</th>\n",
              "      <td id=\"T_3050b_row1_col0\" class=\"data row1 col0\" >103.50</td>\n",
              "      <td id=\"T_3050b_row1_col1\" class=\"data row1 col1\" >106.75</td>\n",
              "      <td id=\"T_3050b_row1_col2\" class=\"data row1 col2\" >103.50</td>\n",
              "      <td id=\"T_3050b_row1_col3\" class=\"data row1 col3\" >106.35</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_3050b_level0_row2\" class=\"row_heading level0 row2\" >2000-03-17</th>\n",
              "      <td id=\"T_3050b_row2_col0\" class=\"data row2 col0\" >105.00</td>\n",
              "      <td id=\"T_3050b_row2_col1\" class=\"data row2 col1\" >106.15</td>\n",
              "      <td id=\"T_3050b_row2_col2\" class=\"data row2 col2\" >105.50</td>\n",
              "      <td id=\"T_3050b_row2_col3\" class=\"data row2 col3\" >106.10</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_3050b_level0_row3\" class=\"row_heading level0 row3\" >2000-03-20</th>\n",
              "      <td id=\"T_3050b_row3_col0\" class=\"data row3 col0\" >106.00</td>\n",
              "      <td id=\"T_3050b_row3_col1\" class=\"data row3 col1\" >105.00</td>\n",
              "      <td id=\"T_3050b_row3_col2\" class=\"data row3 col2\" >103.25</td>\n",
              "      <td id=\"T_3050b_row3_col3\" class=\"data row3 col3\" >103.10</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_3050b_level0_row4\" class=\"row_heading level0 row4\" >2000-03-21</th>\n",
              "      <td id=\"T_3050b_row4_col0\" class=\"data row4 col0\" >103.50</td>\n",
              "      <td id=\"T_3050b_row4_col1\" class=\"data row4 col1\" >104.00</td>\n",
              "      <td id=\"T_3050b_row4_col2\" class=\"data row4 col2\" >103.50</td>\n",
              "      <td id=\"T_3050b_row4_col3\" class=\"data row4 col3\" >103.75</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_3050b_level0_row5\" class=\"row_heading level0 row5\" >2000-03-22</th>\n",
              "      <td id=\"T_3050b_row5_col0\" class=\"data row5 col0\" >104.50</td>\n",
              "      <td id=\"T_3050b_row5_col1\" class=\"data row5 col1\" >105.90</td>\n",
              "      <td id=\"T_3050b_row5_col2\" class=\"data row5 col2\" >104.50</td>\n",
              "      <td id=\"T_3050b_row5_col3\" class=\"data row5 col3\" >105.80</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_3050b_level0_row6\" class=\"row_heading level0 row6\" >2000-03-23</th>\n",
              "      <td id=\"T_3050b_row6_col0\" class=\"data row6 col0\" >105.75</td>\n",
              "      <td id=\"T_3050b_row6_col1\" class=\"data row6 col1\" >107.00</td>\n",
              "      <td id=\"T_3050b_row6_col2\" class=\"data row6 col2\" >101.50</td>\n",
              "      <td id=\"T_3050b_row6_col3\" class=\"data row6 col3\" >102.10</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_3050b_level0_row7\" class=\"row_heading level0 row7\" >2000-03-24</th>\n",
              "      <td id=\"T_3050b_row7_col0\" class=\"data row7 col0\" >102.75</td>\n",
              "      <td id=\"T_3050b_row7_col1\" class=\"data row7 col1\" >103.25</td>\n",
              "      <td id=\"T_3050b_row7_col2\" class=\"data row7 col2\" >101.05</td>\n",
              "      <td id=\"T_3050b_row7_col3\" class=\"data row7 col3\" >103.15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_3050b_level0_row8\" class=\"row_heading level0 row8\" >2000-03-27</th>\n",
              "      <td id=\"T_3050b_row8_col0\" class=\"data row8 col0\" >102.60</td>\n",
              "      <td id=\"T_3050b_row8_col1\" class=\"data row8 col1\" >103.25</td>\n",
              "      <td id=\"T_3050b_row8_col2\" class=\"data row8 col2\" >101.35</td>\n",
              "      <td id=\"T_3050b_row8_col3\" class=\"data row8 col3\" >103.15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th id=\"T_3050b_level0_row9\" class=\"row_heading level0 row9\" >2000-03-28</th>\n",
              "      <td id=\"T_3050b_row9_col0\" class=\"data row9 col0\" >104.00</td>\n",
              "      <td id=\"T_3050b_row9_col1\" class=\"data row9 col1\" >105.30</td>\n",
              "      <td id=\"T_3050b_row9_col2\" class=\"data row9 col2\" >103.80</td>\n",
              "      <td id=\"T_3050b_row9_col3\" class=\"data row9 col3\" >104.50</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n"
            ]
          },
          "metadata": {},
          "execution_count": 36
        }
      ]
    }
  ]
}