Pandas-Styling.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "8d2f7234",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "e928981c",
   "metadata": {},
   "outputs": [],
   "source": [
    "np.random.seed(24)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "0845cf49",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "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>A</th>\n",
       "      <th>B</th>\n",
       "      <th>C</th>\n",
       "      <th>D</th>\n",
       "      <th>E</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.329212</td>\n",
       "      <td>-0.770033</td>\n",
       "      <td>-0.316280</td>\n",
       "      <td>-0.990810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2.0</td>\n",
       "      <td>-1.070816</td>\n",
       "      <td>-1.438713</td>\n",
       "      <td>0.564417</td>\n",
       "      <td>0.295722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3.0</td>\n",
       "      <td>-1.626404</td>\n",
       "      <td>0.219565</td>\n",
       "      <td>0.678805</td>\n",
       "      <td>1.889273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4.0</td>\n",
       "      <td>0.961538</td>\n",
       "      <td>0.104011</td>\n",
       "      <td>-0.481165</td>\n",
       "      <td>0.850229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5.0</td>\n",
       "      <td>1.453425</td>\n",
       "      <td>1.057737</td>\n",
       "      <td>0.165562</td>\n",
       "      <td>0.515018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6.0</td>\n",
       "      <td>-1.336936</td>\n",
       "      <td>0.562861</td>\n",
       "      <td>1.392855</td>\n",
       "      <td>-0.063328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7.0</td>\n",
       "      <td>0.121668</td>\n",
       "      <td>1.207603</td>\n",
       "      <td>-0.002040</td>\n",
       "      <td>1.627796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8.0</td>\n",
       "      <td>0.354493</td>\n",
       "      <td>1.037528</td>\n",
       "      <td>-0.385684</td>\n",
       "      <td>0.519818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9.0</td>\n",
       "      <td>1.686583</td>\n",
       "      <td>-1.325963</td>\n",
       "      <td>1.428984</td>\n",
       "      <td>-2.089354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10.0</td>\n",
       "      <td>-0.129820</td>\n",
       "      <td>0.631523</td>\n",
       "      <td>-0.586538</td>\n",
       "      <td>0.290720</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      A         B         C         D         E\n",
       "0   1.0  1.329212 -0.770033 -0.316280 -0.990810\n",
       "1   2.0 -1.070816 -1.438713  0.564417  0.295722\n",
       "2   3.0 -1.626404  0.219565  0.678805  1.889273\n",
       "3   4.0  0.961538  0.104011 -0.481165  0.850229\n",
       "4   5.0  1.453425  1.057737  0.165562  0.515018\n",
       "5   6.0 -1.336936  0.562861  1.392855 -0.063328\n",
       "6   7.0  0.121668  1.207603 -0.002040  1.627796\n",
       "7   8.0  0.354493  1.037528 -0.385684  0.519818\n",
       "8   9.0  1.686583 -1.325963  1.428984 -2.089354\n",
       "9  10.0 -0.129820  0.631523 -0.586538  0.290720"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame({'A': np.linspace(1, 10, 10)})\n",
    "df = pd.concat([df, pd.DataFrame(np.random.randn(10,4), columns=list('BCDE'))],\n",
    "              axis=1)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "6faa030d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "Negative numbers red and positive numbers black:\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_e1d20_row0_col0, #T_e1d20_row0_col1, #T_e1d20_row1_col0, #T_e1d20_row1_col3, #T_e1d20_row1_col4, #T_e1d20_row2_col0, #T_e1d20_row2_col2, #T_e1d20_row2_col3, #T_e1d20_row2_col4, #T_e1d20_row3_col0, #T_e1d20_row3_col1, #T_e1d20_row3_col2, #T_e1d20_row3_col4, #T_e1d20_row4_col0, #T_e1d20_row4_col1, #T_e1d20_row4_col2, #T_e1d20_row4_col3, #T_e1d20_row4_col4, #T_e1d20_row5_col0, #T_e1d20_row5_col2, #T_e1d20_row5_col3, #T_e1d20_row6_col0, #T_e1d20_row6_col1, #T_e1d20_row6_col2, #T_e1d20_row6_col4, #T_e1d20_row7_col0, #T_e1d20_row7_col1, #T_e1d20_row7_col2, #T_e1d20_row7_col4, #T_e1d20_row8_col0, #T_e1d20_row8_col1, #T_e1d20_row8_col3, #T_e1d20_row9_col0, #T_e1d20_row9_col2, #T_e1d20_row9_col4 {\n",
       "  color: black;\n",
       "}\n",
       "#T_e1d20_row0_col2, #T_e1d20_row0_col3, #T_e1d20_row0_col4, #T_e1d20_row1_col1, #T_e1d20_row1_col2, #T_e1d20_row2_col1, #T_e1d20_row3_col3, #T_e1d20_row5_col1, #T_e1d20_row5_col4, #T_e1d20_row6_col3, #T_e1d20_row7_col3, #T_e1d20_row8_col2, #T_e1d20_row8_col4, #T_e1d20_row9_col1, #T_e1d20_row9_col3 {\n",
       "  color: red;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_e1d20_\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th class=\"col_heading level0 col0\" >A</th>\n",
       "      <th class=\"col_heading level0 col1\" >B</th>\n",
       "      <th class=\"col_heading level0 col2\" >C</th>\n",
       "      <th class=\"col_heading level0 col3\" >D</th>\n",
       "      <th class=\"col_heading level0 col4\" >E</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_e1d20_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "      <td id=\"T_e1d20_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
       "      <td id=\"T_e1d20_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
       "      <td id=\"T_e1d20_row0_col2\" class=\"data row0 col2\" >-0.770033</td>\n",
       "      <td id=\"T_e1d20_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
       "      <td id=\"T_e1d20_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_e1d20_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "      <td id=\"T_e1d20_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
       "      <td id=\"T_e1d20_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
       "      <td id=\"T_e1d20_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
       "      <td id=\"T_e1d20_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
       "      <td id=\"T_e1d20_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_e1d20_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "      <td id=\"T_e1d20_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
       "      <td id=\"T_e1d20_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
       "      <td id=\"T_e1d20_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
       "      <td id=\"T_e1d20_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
       "      <td id=\"T_e1d20_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_e1d20_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "      <td id=\"T_e1d20_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
       "      <td id=\"T_e1d20_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
       "      <td id=\"T_e1d20_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
       "      <td id=\"T_e1d20_row3_col3\" class=\"data row3 col3\" >-0.481165</td>\n",
       "      <td id=\"T_e1d20_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_e1d20_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "      <td id=\"T_e1d20_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
       "      <td id=\"T_e1d20_row4_col1\" class=\"data row4 col1\" >1.453425</td>\n",
       "      <td id=\"T_e1d20_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
       "      <td id=\"T_e1d20_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
       "      <td id=\"T_e1d20_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_e1d20_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "      <td id=\"T_e1d20_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
       "      <td id=\"T_e1d20_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
       "      <td id=\"T_e1d20_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
       "      <td id=\"T_e1d20_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
       "      <td id=\"T_e1d20_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_e1d20_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "      <td id=\"T_e1d20_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
       "      <td id=\"T_e1d20_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
       "      <td id=\"T_e1d20_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
       "      <td id=\"T_e1d20_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
       "      <td id=\"T_e1d20_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_e1d20_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "      <td id=\"T_e1d20_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
       "      <td id=\"T_e1d20_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
       "      <td id=\"T_e1d20_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
       "      <td id=\"T_e1d20_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
       "      <td id=\"T_e1d20_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_e1d20_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "      <td id=\"T_e1d20_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
       "      <td id=\"T_e1d20_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
       "      <td id=\"T_e1d20_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
       "      <td id=\"T_e1d20_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
       "      <td id=\"T_e1d20_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_e1d20_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "      <td id=\"T_e1d20_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
       "      <td id=\"T_e1d20_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
       "      <td id=\"T_e1d20_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
       "      <td id=\"T_e1d20_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
       "      <td id=\"T_e1d20_row9_col4\" class=\"data row9 col4\" >0.290720</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x1e3373003d0>"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def color_negative_red(val):\n",
    "    color = 'red' if val < 0 else 'black'\n",
    "    return 'color: %s' % color\n",
    "print(\"\\nNegative numbers red and positive numbers black:\")\n",
    "df.style.applymap(color_negative_red)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "2f0f8d5c",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Original array:\n",
      "      A         B         C         D         E\n",
      "0   1.0  1.329212       NaN -0.316280 -0.990810\n",
      "1   2.0 -1.070816 -1.438713  0.564417  0.295722\n",
      "2   3.0 -1.626404  0.219565  0.678805  1.889273\n",
      "3   4.0  0.961538  0.104011       NaN  0.850229\n",
      "4   5.0       NaN  1.057737  0.165562  0.515018\n",
      "5   6.0 -1.336936  0.562861  1.392855 -0.063328\n",
      "6   7.0  0.121668  1.207603 -0.002040  1.627796\n",
      "7   8.0  0.354493  1.037528 -0.385684  0.519818\n",
      "8   9.0  1.686583 -1.325963  1.428984 -2.089354\n",
      "9  10.0 -0.129820  0.631523 -0.586538       NaN\n",
      "\n",
      "Negative numbers red and positive numbers black:\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_1d402_row0_col2, #T_1d402_row3_col3, #T_1d402_row4_col1, #T_1d402_row9_col4 {\n",
       "  background-color: red;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_1d402_\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th class=\"col_heading level0 col0\" >A</th>\n",
       "      <th class=\"col_heading level0 col1\" >B</th>\n",
       "      <th class=\"col_heading level0 col2\" >C</th>\n",
       "      <th class=\"col_heading level0 col3\" >D</th>\n",
       "      <th class=\"col_heading level0 col4\" >E</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_1d402_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "      <td id=\"T_1d402_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
       "      <td id=\"T_1d402_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
       "      <td id=\"T_1d402_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
       "      <td id=\"T_1d402_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
       "      <td id=\"T_1d402_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_1d402_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "      <td id=\"T_1d402_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
       "      <td id=\"T_1d402_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
       "      <td id=\"T_1d402_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
       "      <td id=\"T_1d402_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
       "      <td id=\"T_1d402_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_1d402_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "      <td id=\"T_1d402_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
       "      <td id=\"T_1d402_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
       "      <td id=\"T_1d402_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
       "      <td id=\"T_1d402_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
       "      <td id=\"T_1d402_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_1d402_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "      <td id=\"T_1d402_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
       "      <td id=\"T_1d402_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
       "      <td id=\"T_1d402_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
       "      <td id=\"T_1d402_row3_col3\" class=\"data row3 col3\" >nan</td>\n",
       "      <td id=\"T_1d402_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_1d402_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "      <td id=\"T_1d402_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
       "      <td id=\"T_1d402_row4_col1\" class=\"data row4 col1\" >nan</td>\n",
       "      <td id=\"T_1d402_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
       "      <td id=\"T_1d402_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
       "      <td id=\"T_1d402_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_1d402_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "      <td id=\"T_1d402_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
       "      <td id=\"T_1d402_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
       "      <td id=\"T_1d402_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
       "      <td id=\"T_1d402_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
       "      <td id=\"T_1d402_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_1d402_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "      <td id=\"T_1d402_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
       "      <td id=\"T_1d402_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
       "      <td id=\"T_1d402_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
       "      <td id=\"T_1d402_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
       "      <td id=\"T_1d402_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_1d402_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "      <td id=\"T_1d402_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
       "      <td id=\"T_1d402_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
       "      <td id=\"T_1d402_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
       "      <td id=\"T_1d402_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
       "      <td id=\"T_1d402_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_1d402_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "      <td id=\"T_1d402_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
       "      <td id=\"T_1d402_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
       "      <td id=\"T_1d402_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
       "      <td id=\"T_1d402_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
       "      <td id=\"T_1d402_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_1d402_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "      <td id=\"T_1d402_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
       "      <td id=\"T_1d402_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
       "      <td id=\"T_1d402_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
       "      <td id=\"T_1d402_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
       "      <td id=\"T_1d402_row9_col4\" class=\"data row9 col4\" >nan</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x1e3372c3e50>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Q2\n",
    "df.iloc[0, 2] = np.nan\n",
    "df.iloc[3, 3] = np.nan\n",
    "df.iloc[4, 1] = np.nan\n",
    "df.iloc[9, 4] = np.nan\n",
    "print(\"Original array:\")\n",
    "print(df)\n",
    "def color_negative_red(val):\n",
    "    color = 'red' if val < 0 else 'black'\n",
    "    return 'color: %s' % color\n",
    "print(\"\\nNegative numbers red and positive numbers black:\")\n",
    "df.style.highlight_null(null_color='red')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "7da42830",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Original array:\n",
      "      A         B         C         D         E\n",
      "0   1.0  1.329212       NaN -0.316280 -0.990810\n",
      "1   2.0 -1.070816 -1.438713  0.564417  0.295722\n",
      "2   3.0 -1.626404  0.219565  0.678805  1.889273\n",
      "3   4.0  0.961538  0.104011       NaN  0.850229\n",
      "4   5.0       NaN  1.057737  0.165562  0.515018\n",
      "5   6.0 -1.336936  0.562861  1.392855 -0.063328\n",
      "6   7.0  0.121668  1.207603 -0.002040  1.627796\n",
      "7   8.0  0.354493  1.037528 -0.385684  0.519818\n",
      "8   9.0  1.686583 -1.325963  1.428984 -2.089354\n",
      "9  10.0 -0.129820  0.631523 -0.586538       NaN\n",
      "\n",
      "Highlight the maximum value in each column:\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_917b9_row2_col4, #T_917b9_row6_col2, #T_917b9_row8_col1, #T_917b9_row8_col3 {\n",
       "  background-color: green;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_917b9_\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th class=\"col_heading level0 col0\" >A</th>\n",
       "      <th class=\"col_heading level0 col1\" >B</th>\n",
       "      <th class=\"col_heading level0 col2\" >C</th>\n",
       "      <th class=\"col_heading level0 col3\" >D</th>\n",
       "      <th class=\"col_heading level0 col4\" >E</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_917b9_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "      <td id=\"T_917b9_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
       "      <td id=\"T_917b9_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
       "      <td id=\"T_917b9_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
       "      <td id=\"T_917b9_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
       "      <td id=\"T_917b9_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_917b9_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "      <td id=\"T_917b9_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
       "      <td id=\"T_917b9_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
       "      <td id=\"T_917b9_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
       "      <td id=\"T_917b9_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
       "      <td id=\"T_917b9_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_917b9_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "      <td id=\"T_917b9_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
       "      <td id=\"T_917b9_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
       "      <td id=\"T_917b9_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
       "      <td id=\"T_917b9_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
       "      <td id=\"T_917b9_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_917b9_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "      <td id=\"T_917b9_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
       "      <td id=\"T_917b9_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
       "      <td id=\"T_917b9_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
       "      <td id=\"T_917b9_row3_col3\" class=\"data row3 col3\" >nan</td>\n",
       "      <td id=\"T_917b9_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_917b9_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "      <td id=\"T_917b9_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
       "      <td id=\"T_917b9_row4_col1\" class=\"data row4 col1\" >nan</td>\n",
       "      <td id=\"T_917b9_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
       "      <td id=\"T_917b9_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
       "      <td id=\"T_917b9_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_917b9_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "      <td id=\"T_917b9_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
       "      <td id=\"T_917b9_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
       "      <td id=\"T_917b9_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
       "      <td id=\"T_917b9_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
       "      <td id=\"T_917b9_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_917b9_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "      <td id=\"T_917b9_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
       "      <td id=\"T_917b9_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
       "      <td id=\"T_917b9_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
       "      <td id=\"T_917b9_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
       "      <td id=\"T_917b9_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_917b9_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "      <td id=\"T_917b9_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
       "      <td id=\"T_917b9_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
       "      <td id=\"T_917b9_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
       "      <td id=\"T_917b9_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
       "      <td id=\"T_917b9_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_917b9_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "      <td id=\"T_917b9_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
       "      <td id=\"T_917b9_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
       "      <td id=\"T_917b9_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
       "      <td id=\"T_917b9_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
       "      <td id=\"T_917b9_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_917b9_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "      <td id=\"T_917b9_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
       "      <td id=\"T_917b9_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
       "      <td id=\"T_917b9_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
       "      <td id=\"T_917b9_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
       "      <td id=\"T_917b9_row9_col4\" class=\"data row9 col4\" >nan</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x1e337300580>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Q3\n",
    "print(\"Original array:\")\n",
    "print(df)\n",
    "def highlight_max(s):\n",
    "    '''\n",
    "    highlight the maximum in a Series green.\n",
    "    '''\n",
    "    is_max = s == s.max()\n",
    "    return ['background-color: green' if v else '' for v in is_max]\n",
    "\n",
    "print(\"\\nHighlight the maximum value in each column:\")\n",
    "df.style.apply(highlight_max,subset=pd.IndexSlice[:, ['B', 'C', 'D', 'E']])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "46798207",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Original array:\n",
      "      A         B         C         D         E\n",
      "0   1.0  1.329212       NaN -0.316280 -0.990810\n",
      "1   2.0 -1.070816 -1.438713  0.564417  0.295722\n",
      "2   3.0 -1.626404  0.219565  0.678805  1.889273\n",
      "3   4.0  0.961538  0.104011       NaN  0.850229\n",
      "4   5.0       NaN  1.057737  0.165562  0.515018\n",
      "5   6.0 -1.336936  0.562861  1.392855 -0.063328\n",
      "6   7.0  0.121668  1.207603 -0.002040  1.627796\n",
      "7   8.0  0.354493  1.037528 -0.385684  0.519818\n",
      "8   9.0  1.686583 -1.325963  1.428984 -2.089354\n",
      "9  10.0 -0.129820  0.631523 -0.586538       NaN\n",
      "\n",
      "Highlight the maximum value in each column:\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_f4cd5_row1_col2, #T_f4cd5_row2_col1, #T_f4cd5_row8_col4, #T_f4cd5_row9_col3 {\n",
       "  background-color: red;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_f4cd5_\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th class=\"col_heading level0 col0\" >A</th>\n",
       "      <th class=\"col_heading level0 col1\" >B</th>\n",
       "      <th class=\"col_heading level0 col2\" >C</th>\n",
       "      <th class=\"col_heading level0 col3\" >D</th>\n",
       "      <th class=\"col_heading level0 col4\" >E</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_f4cd5_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "      <td id=\"T_f4cd5_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
       "      <td id=\"T_f4cd5_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
       "      <td id=\"T_f4cd5_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
       "      <td id=\"T_f4cd5_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
       "      <td id=\"T_f4cd5_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f4cd5_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "      <td id=\"T_f4cd5_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
       "      <td id=\"T_f4cd5_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
       "      <td id=\"T_f4cd5_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
       "      <td id=\"T_f4cd5_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
       "      <td id=\"T_f4cd5_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f4cd5_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "      <td id=\"T_f4cd5_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
       "      <td id=\"T_f4cd5_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
       "      <td id=\"T_f4cd5_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
       "      <td id=\"T_f4cd5_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
       "      <td id=\"T_f4cd5_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f4cd5_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "      <td id=\"T_f4cd5_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
       "      <td id=\"T_f4cd5_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
       "      <td id=\"T_f4cd5_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
       "      <td id=\"T_f4cd5_row3_col3\" class=\"data row3 col3\" >nan</td>\n",
       "      <td id=\"T_f4cd5_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f4cd5_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "      <td id=\"T_f4cd5_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
       "      <td id=\"T_f4cd5_row4_col1\" class=\"data row4 col1\" >nan</td>\n",
       "      <td id=\"T_f4cd5_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
       "      <td id=\"T_f4cd5_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
       "      <td id=\"T_f4cd5_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f4cd5_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "      <td id=\"T_f4cd5_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
       "      <td id=\"T_f4cd5_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
       "      <td id=\"T_f4cd5_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
       "      <td id=\"T_f4cd5_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
       "      <td id=\"T_f4cd5_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f4cd5_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "      <td id=\"T_f4cd5_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
       "      <td id=\"T_f4cd5_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
       "      <td id=\"T_f4cd5_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
       "      <td id=\"T_f4cd5_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
       "      <td id=\"T_f4cd5_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f4cd5_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "      <td id=\"T_f4cd5_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
       "      <td id=\"T_f4cd5_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
       "      <td id=\"T_f4cd5_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
       "      <td id=\"T_f4cd5_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
       "      <td id=\"T_f4cd5_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f4cd5_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "      <td id=\"T_f4cd5_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
       "      <td id=\"T_f4cd5_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
       "      <td id=\"T_f4cd5_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
       "      <td id=\"T_f4cd5_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
       "      <td id=\"T_f4cd5_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f4cd5_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "      <td id=\"T_f4cd5_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
       "      <td id=\"T_f4cd5_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
       "      <td id=\"T_f4cd5_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
       "      <td id=\"T_f4cd5_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
       "      <td id=\"T_f4cd5_row9_col4\" class=\"data row9 col4\" >nan</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x1e3381ed1c0>"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Q4\n",
    "print(\"Original array:\")\n",
    "print(df)\n",
    "def highlight_min(s):\n",
    "    '''\n",
    "    highlight the minimum in a Series red.\n",
    "    '''\n",
    "    is_min = s == s.min()\n",
    "    return ['background-color: red' if v else '' for v in is_min]\n",
    "\n",
    "print(\"\\nHighlight the maximum value in each column:\")\n",
    "df.style.apply(highlight_min,subset=pd.IndexSlice[:, ['B', 'C', 'D', 'E']])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "3efa8f56",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Original array:\n",
      "      A         B         C         D         E\n",
      "0   1.0  1.329212       NaN -0.316280 -0.990810\n",
      "1   2.0 -1.070816 -1.438713  0.564417  0.295722\n",
      "2   3.0 -1.626404  0.219565  0.678805  1.889273\n",
      "3   4.0  0.961538  0.104011       NaN  0.850229\n",
      "4   5.0       NaN  1.057737  0.165562  0.515018\n",
      "5   6.0 -1.336936  0.562861  1.392855 -0.063328\n",
      "6   7.0  0.121668  1.207603 -0.002040  1.627796\n",
      "7   8.0  0.354493  1.037528 -0.385684  0.519818\n",
      "8   9.0  1.686583 -1.325963  1.428984 -2.089354\n",
      "9  10.0 -0.129820  0.631523 -0.586538       NaN\n",
      "\n",
      "Highlight the maximum value in each column:\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_4b7dd_row2_col4, #T_4b7dd_row8_col3 {\n",
       "  background-color: green;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_4b7dd_\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th class=\"col_heading level0 col0\" >A</th>\n",
       "      <th class=\"col_heading level0 col1\" >B</th>\n",
       "      <th class=\"col_heading level0 col2\" >C</th>\n",
       "      <th class=\"col_heading level0 col3\" >D</th>\n",
       "      <th class=\"col_heading level0 col4\" >E</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_4b7dd_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "      <td id=\"T_4b7dd_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
       "      <td id=\"T_4b7dd_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
       "      <td id=\"T_4b7dd_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
       "      <td id=\"T_4b7dd_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
       "      <td id=\"T_4b7dd_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b7dd_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "      <td id=\"T_4b7dd_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
       "      <td id=\"T_4b7dd_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
       "      <td id=\"T_4b7dd_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
       "      <td id=\"T_4b7dd_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
       "      <td id=\"T_4b7dd_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b7dd_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "      <td id=\"T_4b7dd_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
       "      <td id=\"T_4b7dd_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
       "      <td id=\"T_4b7dd_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
       "      <td id=\"T_4b7dd_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
       "      <td id=\"T_4b7dd_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b7dd_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "      <td id=\"T_4b7dd_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
       "      <td id=\"T_4b7dd_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
       "      <td id=\"T_4b7dd_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
       "      <td id=\"T_4b7dd_row3_col3\" class=\"data row3 col3\" >nan</td>\n",
       "      <td id=\"T_4b7dd_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b7dd_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "      <td id=\"T_4b7dd_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
       "      <td id=\"T_4b7dd_row4_col1\" class=\"data row4 col1\" >nan</td>\n",
       "      <td id=\"T_4b7dd_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
       "      <td id=\"T_4b7dd_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
       "      <td id=\"T_4b7dd_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b7dd_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "      <td id=\"T_4b7dd_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
       "      <td id=\"T_4b7dd_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
       "      <td id=\"T_4b7dd_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
       "      <td id=\"T_4b7dd_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
       "      <td id=\"T_4b7dd_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b7dd_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "      <td id=\"T_4b7dd_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
       "      <td id=\"T_4b7dd_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
       "      <td id=\"T_4b7dd_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
       "      <td id=\"T_4b7dd_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
       "      <td id=\"T_4b7dd_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b7dd_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "      <td id=\"T_4b7dd_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
       "      <td id=\"T_4b7dd_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
       "      <td id=\"T_4b7dd_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
       "      <td id=\"T_4b7dd_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
       "      <td id=\"T_4b7dd_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b7dd_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "      <td id=\"T_4b7dd_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
       "      <td id=\"T_4b7dd_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
       "      <td id=\"T_4b7dd_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
       "      <td id=\"T_4b7dd_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
       "      <td id=\"T_4b7dd_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b7dd_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "      <td id=\"T_4b7dd_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
       "      <td id=\"T_4b7dd_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
       "      <td id=\"T_4b7dd_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
       "      <td id=\"T_4b7dd_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
       "      <td id=\"T_4b7dd_row9_col4\" class=\"data row9 col4\" >nan</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x1e338206340>"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Q5\n",
    "print(\"Original array:\")\n",
    "print(df)\n",
    "def highlight_max(s):\n",
    "    '''\n",
    "    highlight the maximum in a Series green.\n",
    "    '''\n",
    "    is_max = s == s.max()\n",
    "    return ['background-color: green' if v else '' for v in is_max]\n",
    "\n",
    "print(\"\\nHighlight the maximum value in each column:\")\n",
    "df.style.apply(highlight_max,subset=pd.IndexSlice[:, ['D', 'E']])"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}