Pandas-Styling3.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "ca057356",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "deca8165",
   "metadata": {},
   "outputs": [],
   "source": [
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "a11ca407",
   "metadata": {},
   "outputs": [],
   "source": [
    "np.random.seed(24)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "0e66fd6e",
   "metadata": {},
   "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>NaN</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>NaN</td>\n",
       "      <td>0.850229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</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>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      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"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Q8\n",
    "df = pd.DataFrame({'A': np.linspace(1,10,10)})\n",
    "df = pd.concat([df, pd.DataFrame(np.random.randn(10,4), columns=list('BCDE'))], axis=1)\n",
    "\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",
    "\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "a7b95e69",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_a53cf_row0_col0, #T_a53cf_row0_col3, #T_a53cf_row1_col0, #T_a53cf_row1_col3, #T_a53cf_row2_col0, #T_a53cf_row2_col3, #T_a53cf_row3_col0, #T_a53cf_row3_col3, #T_a53cf_row4_col0, #T_a53cf_row4_col3, #T_a53cf_row5_col0, #T_a53cf_row5_col3, #T_a53cf_row6_col0, #T_a53cf_row6_col3, #T_a53cf_row7_col0, #T_a53cf_row7_col3, #T_a53cf_row8_col0, #T_a53cf_row8_col3, #T_a53cf_row9_col0, #T_a53cf_row9_col3 {\n",
       "  background-color: red;\n",
       "}\n",
       "#T_a53cf_row0_col1, #T_a53cf_row0_col2, #T_a53cf_row0_col4, #T_a53cf_row1_col1, #T_a53cf_row1_col2, #T_a53cf_row1_col4, #T_a53cf_row2_col1, #T_a53cf_row2_col2, #T_a53cf_row2_col4, #T_a53cf_row3_col1, #T_a53cf_row3_col2, #T_a53cf_row3_col4, #T_a53cf_row4_col1, #T_a53cf_row4_col2, #T_a53cf_row4_col4, #T_a53cf_row5_col1, #T_a53cf_row5_col2, #T_a53cf_row5_col4, #T_a53cf_row6_col1, #T_a53cf_row6_col2, #T_a53cf_row6_col4, #T_a53cf_row7_col1, #T_a53cf_row7_col2, #T_a53cf_row7_col4, #T_a53cf_row8_col1, #T_a53cf_row8_col2, #T_a53cf_row8_col4, #T_a53cf_row9_col1, #T_a53cf_row9_col2, #T_a53cf_row9_col4 {\n",
       "  background-color: grey;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_a53cf_\">\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_a53cf_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "      <td id=\"T_a53cf_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
       "      <td id=\"T_a53cf_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
       "      <td id=\"T_a53cf_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
       "      <td id=\"T_a53cf_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
       "      <td id=\"T_a53cf_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_a53cf_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "      <td id=\"T_a53cf_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
       "      <td id=\"T_a53cf_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
       "      <td id=\"T_a53cf_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
       "      <td id=\"T_a53cf_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
       "      <td id=\"T_a53cf_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_a53cf_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "      <td id=\"T_a53cf_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
       "      <td id=\"T_a53cf_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
       "      <td id=\"T_a53cf_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
       "      <td id=\"T_a53cf_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
       "      <td id=\"T_a53cf_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_a53cf_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "      <td id=\"T_a53cf_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
       "      <td id=\"T_a53cf_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
       "      <td id=\"T_a53cf_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
       "      <td id=\"T_a53cf_row3_col3\" class=\"data row3 col3\" >nan</td>\n",
       "      <td id=\"T_a53cf_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_a53cf_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "      <td id=\"T_a53cf_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
       "      <td id=\"T_a53cf_row4_col1\" class=\"data row4 col1\" >nan</td>\n",
       "      <td id=\"T_a53cf_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
       "      <td id=\"T_a53cf_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
       "      <td id=\"T_a53cf_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_a53cf_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "      <td id=\"T_a53cf_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
       "      <td id=\"T_a53cf_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
       "      <td id=\"T_a53cf_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
       "      <td id=\"T_a53cf_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
       "      <td id=\"T_a53cf_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_a53cf_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "      <td id=\"T_a53cf_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
       "      <td id=\"T_a53cf_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
       "      <td id=\"T_a53cf_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
       "      <td id=\"T_a53cf_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
       "      <td id=\"T_a53cf_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_a53cf_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "      <td id=\"T_a53cf_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
       "      <td id=\"T_a53cf_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
       "      <td id=\"T_a53cf_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
       "      <td id=\"T_a53cf_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
       "      <td id=\"T_a53cf_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_a53cf_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "      <td id=\"T_a53cf_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
       "      <td id=\"T_a53cf_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
       "      <td id=\"T_a53cf_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
       "      <td id=\"T_a53cf_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
       "      <td id=\"T_a53cf_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_a53cf_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "      <td id=\"T_a53cf_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
       "      <td id=\"T_a53cf_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
       "      <td id=\"T_a53cf_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
       "      <td id=\"T_a53cf_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
       "      <td id=\"T_a53cf_row9_col4\" class=\"data row9 col4\" >nan</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x25b8291b100>"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def highlight_cols(x):\n",
    "    #copy df to new - original data are not changed\n",
    "    df = x.copy()\n",
    "    #select all values to default value - red color\n",
    "    df.loc[:,:] = 'background-color: red'\n",
    "    #overwrite values grey color\n",
    "    df[['B','C', 'E']] = 'background-color: grey'\n",
    "    #return color df\n",
    "    return df    \n",
    "\n",
    "df.style.apply(highlight_cols, axis=None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "3b4e30ee",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_976d7_ th {\n",
       "  font-size: 12px;\n",
       "  text-align: center;\n",
       "  font-weight: bold;\n",
       "  color: #6d6d6d;\n",
       "  background-color: #f7ffff;\n",
       "}\n",
       "#T_976d7_ td {\n",
       "  font-size: 12px;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_976d7_\">\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_976d7_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "      <td id=\"T_976d7_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
       "      <td id=\"T_976d7_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
       "      <td id=\"T_976d7_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
       "      <td id=\"T_976d7_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
       "      <td id=\"T_976d7_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_976d7_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "      <td id=\"T_976d7_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
       "      <td id=\"T_976d7_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
       "      <td id=\"T_976d7_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
       "      <td id=\"T_976d7_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
       "      <td id=\"T_976d7_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_976d7_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "      <td id=\"T_976d7_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
       "      <td id=\"T_976d7_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
       "      <td id=\"T_976d7_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
       "      <td id=\"T_976d7_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
       "      <td id=\"T_976d7_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_976d7_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "      <td id=\"T_976d7_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
       "      <td id=\"T_976d7_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
       "      <td id=\"T_976d7_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
       "      <td id=\"T_976d7_row3_col3\" class=\"data row3 col3\" >nan</td>\n",
       "      <td id=\"T_976d7_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_976d7_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "      <td id=\"T_976d7_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
       "      <td id=\"T_976d7_row4_col1\" class=\"data row4 col1\" >nan</td>\n",
       "      <td id=\"T_976d7_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
       "      <td id=\"T_976d7_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
       "      <td id=\"T_976d7_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_976d7_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "      <td id=\"T_976d7_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
       "      <td id=\"T_976d7_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
       "      <td id=\"T_976d7_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
       "      <td id=\"T_976d7_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
       "      <td id=\"T_976d7_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_976d7_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "      <td id=\"T_976d7_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
       "      <td id=\"T_976d7_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
       "      <td id=\"T_976d7_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
       "      <td id=\"T_976d7_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
       "      <td id=\"T_976d7_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_976d7_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "      <td id=\"T_976d7_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
       "      <td id=\"T_976d7_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
       "      <td id=\"T_976d7_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
       "      <td id=\"T_976d7_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
       "      <td id=\"T_976d7_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_976d7_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "      <td id=\"T_976d7_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
       "      <td id=\"T_976d7_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
       "      <td id=\"T_976d7_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
       "      <td id=\"T_976d7_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
       "      <td id=\"T_976d7_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_976d7_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "      <td id=\"T_976d7_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
       "      <td id=\"T_976d7_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
       "      <td id=\"T_976d7_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
       "      <td id=\"T_976d7_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
       "      <td id=\"T_976d7_row9_col4\" class=\"data row9 col4\" >nan</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x25b8304b0a0>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Q9 CSS properties of table dataframe.\n",
    "th_props = [\n",
    "  ('font-size', '12px'),\n",
    "  ('text-align', 'center'),\n",
    "  ('font-weight', 'bold'),\n",
    "  ('color', '#6d6d6d'),\n",
    "  ('background-color', '#f7ffff')\n",
    "  ]\n",
    "\n",
    "# Set CSS properties for td elements in dataframe\n",
    "td_props = [\n",
    "  ('font-size', '12px')\n",
    "  ]\n",
    "\n",
    "# Set table styles\n",
    "styles = [\n",
    "  dict(selector=\"th\", props=th_props),\n",
    "  dict(selector=\"td\", props=td_props)\n",
    "  ]\n",
    "(df.style\n",
    "        .set_table_styles(styles))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "3f2cbdee",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_fed1a_row0_col0, #T_fed1a_row0_col1, #T_fed1a_row0_col2, #T_fed1a_row0_col3, #T_fed1a_row0_col4, #T_fed1a_row1_col0, #T_fed1a_row1_col1, #T_fed1a_row1_col2, #T_fed1a_row1_col3, #T_fed1a_row1_col4, #T_fed1a_row2_col0, #T_fed1a_row2_col1, #T_fed1a_row2_col2, #T_fed1a_row2_col3, #T_fed1a_row2_col4, #T_fed1a_row3_col0, #T_fed1a_row3_col1, #T_fed1a_row3_col2, #T_fed1a_row3_col3, #T_fed1a_row3_col4, #T_fed1a_row8_col0, #T_fed1a_row8_col1, #T_fed1a_row8_col2, #T_fed1a_row8_col3, #T_fed1a_row8_col4 {\n",
       "  background-color: white;\n",
       "}\n",
       "#T_fed1a_row4_col0, #T_fed1a_row4_col1, #T_fed1a_row4_col2, #T_fed1a_row4_col3, #T_fed1a_row4_col4, #T_fed1a_row5_col0, #T_fed1a_row5_col1, #T_fed1a_row5_col2, #T_fed1a_row5_col3, #T_fed1a_row5_col4, #T_fed1a_row6_col0, #T_fed1a_row6_col1, #T_fed1a_row6_col2, #T_fed1a_row6_col3, #T_fed1a_row6_col4, #T_fed1a_row7_col0, #T_fed1a_row7_col1, #T_fed1a_row7_col2, #T_fed1a_row7_col3, #T_fed1a_row7_col4, #T_fed1a_row9_col0, #T_fed1a_row9_col1, #T_fed1a_row9_col2, #T_fed1a_row9_col3, #T_fed1a_row9_col4 {\n",
       "  background-color: yellow;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_fed1a_\">\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_fed1a_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "      <td id=\"T_fed1a_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
       "      <td id=\"T_fed1a_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
       "      <td id=\"T_fed1a_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
       "      <td id=\"T_fed1a_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
       "      <td id=\"T_fed1a_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_fed1a_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "      <td id=\"T_fed1a_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
       "      <td id=\"T_fed1a_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
       "      <td id=\"T_fed1a_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
       "      <td id=\"T_fed1a_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
       "      <td id=\"T_fed1a_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_fed1a_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "      <td id=\"T_fed1a_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
       "      <td id=\"T_fed1a_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
       "      <td id=\"T_fed1a_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
       "      <td id=\"T_fed1a_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
       "      <td id=\"T_fed1a_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_fed1a_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "      <td id=\"T_fed1a_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
       "      <td id=\"T_fed1a_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
       "      <td id=\"T_fed1a_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
       "      <td id=\"T_fed1a_row3_col3\" class=\"data row3 col3\" >nan</td>\n",
       "      <td id=\"T_fed1a_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_fed1a_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "      <td id=\"T_fed1a_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
       "      <td id=\"T_fed1a_row4_col1\" class=\"data row4 col1\" >nan</td>\n",
       "      <td id=\"T_fed1a_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
       "      <td id=\"T_fed1a_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
       "      <td id=\"T_fed1a_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_fed1a_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "      <td id=\"T_fed1a_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
       "      <td id=\"T_fed1a_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
       "      <td id=\"T_fed1a_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
       "      <td id=\"T_fed1a_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
       "      <td id=\"T_fed1a_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_fed1a_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "      <td id=\"T_fed1a_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
       "      <td id=\"T_fed1a_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
       "      <td id=\"T_fed1a_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
       "      <td id=\"T_fed1a_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
       "      <td id=\"T_fed1a_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_fed1a_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "      <td id=\"T_fed1a_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
       "      <td id=\"T_fed1a_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
       "      <td id=\"T_fed1a_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
       "      <td id=\"T_fed1a_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
       "      <td id=\"T_fed1a_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_fed1a_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "      <td id=\"T_fed1a_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
       "      <td id=\"T_fed1a_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
       "      <td id=\"T_fed1a_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
       "      <td id=\"T_fed1a_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
       "      <td id=\"T_fed1a_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_fed1a_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "      <td id=\"T_fed1a_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
       "      <td id=\"T_fed1a_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
       "      <td id=\"T_fed1a_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
       "      <td id=\"T_fed1a_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
       "      <td id=\"T_fed1a_row9_col4\" class=\"data row9 col4\" >nan</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x25b82929af0>"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Q10\n",
    "def highlight_greaterthan(x):\n",
    "    if x.C > .5:\n",
    "        return ['background-color: yellow']*5\n",
    "    else:\n",
    "        return ['background-color: white']*5 \n",
    "df.style.apply(highlight_greaterthan, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "3b14a6ba",
   "metadata": {},
   "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>NaN</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>NaN</td>\n",
       "      <td>0.850229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</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>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      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"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Q11\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "dddc5a77",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_f5d99_row0_col0, #T_f5d99_row1_col2, #T_f5d99_row2_col1, #T_f5d99_row8_col4, #T_f5d99_row9_col3 {\n",
       "  background-color: #440154;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row0_col1 {\n",
       "  background-color: #b8de29;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_f5d99_row0_col2, #T_f5d99_row3_col3, #T_f5d99_row4_col1, #T_f5d99_row9_col4 {\n",
       "  background-color: #000000;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row0_col3 {\n",
       "  background-color: #472f7d;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row0_col4 {\n",
       "  background-color: #38598c;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row1_col0 {\n",
       "  background-color: #482878;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row1_col1 {\n",
       "  background-color: #443983;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row1_col3 {\n",
       "  background-color: #1fa187;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row1_col4, #T_f5d99_row7_col1 {\n",
       "  background-color: #22a884;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row2_col0 {\n",
       "  background-color: #3e4989;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row2_col2, #T_f5d99_row2_col3 {\n",
       "  background-color: #28ae80;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row2_col4, #T_f5d99_row6_col2, #T_f5d99_row8_col1, #T_f5d99_row8_col3, #T_f5d99_row9_col0 {\n",
       "  background-color: #fde725;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_f5d99_row3_col0 {\n",
       "  background-color: #31688e;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row3_col1, #T_f5d99_row7_col0 {\n",
       "  background-color: #6ece58;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_f5d99_row3_col2 {\n",
       "  background-color: #20a486;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row3_col4 {\n",
       "  background-color: #58c765;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_f5d99_row4_col0 {\n",
       "  background-color: #26828e;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row4_col2 {\n",
       "  background-color: #dae319;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_f5d99_row4_col3 {\n",
       "  background-color: #2c718e;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row4_col4, #T_f5d99_row7_col4 {\n",
       "  background-color: #31b57b;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row5_col0 {\n",
       "  background-color: #1f9e89;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row5_col1 {\n",
       "  background-color: #482071;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row5_col2 {\n",
       "  background-color: #60ca60;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_f5d99_row5_col3 {\n",
       "  background-color: #f4e61e;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_f5d99_row5_col4 {\n",
       "  background-color: #20928c;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row6_col0 {\n",
       "  background-color: #35b779;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row6_col1 {\n",
       "  background-color: #1f978b;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row6_col3 {\n",
       "  background-color: #365d8d;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row6_col4, #T_f5d99_row7_col2 {\n",
       "  background-color: #d5e21a;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_f5d99_row7_col3 {\n",
       "  background-color: #482475;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row8_col0 {\n",
       "  background-color: #b5de2b;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_f5d99_row8_col2 {\n",
       "  background-color: #471063;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row9_col1 {\n",
       "  background-color: #25848e;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_f5d99_row9_col2 {\n",
       "  background-color: #70cf57;\n",
       "  color: #000000;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_f5d99_\">\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_f5d99_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "      <td id=\"T_f5d99_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
       "      <td id=\"T_f5d99_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
       "      <td id=\"T_f5d99_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
       "      <td id=\"T_f5d99_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
       "      <td id=\"T_f5d99_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f5d99_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "      <td id=\"T_f5d99_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
       "      <td id=\"T_f5d99_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
       "      <td id=\"T_f5d99_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
       "      <td id=\"T_f5d99_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
       "      <td id=\"T_f5d99_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f5d99_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "      <td id=\"T_f5d99_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
       "      <td id=\"T_f5d99_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
       "      <td id=\"T_f5d99_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
       "      <td id=\"T_f5d99_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
       "      <td id=\"T_f5d99_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f5d99_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "      <td id=\"T_f5d99_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
       "      <td id=\"T_f5d99_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
       "      <td id=\"T_f5d99_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
       "      <td id=\"T_f5d99_row3_col3\" class=\"data row3 col3\" >nan</td>\n",
       "      <td id=\"T_f5d99_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f5d99_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "      <td id=\"T_f5d99_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
       "      <td id=\"T_f5d99_row4_col1\" class=\"data row4 col1\" >nan</td>\n",
       "      <td id=\"T_f5d99_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
       "      <td id=\"T_f5d99_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
       "      <td id=\"T_f5d99_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f5d99_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "      <td id=\"T_f5d99_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
       "      <td id=\"T_f5d99_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
       "      <td id=\"T_f5d99_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
       "      <td id=\"T_f5d99_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
       "      <td id=\"T_f5d99_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f5d99_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "      <td id=\"T_f5d99_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
       "      <td id=\"T_f5d99_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
       "      <td id=\"T_f5d99_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
       "      <td id=\"T_f5d99_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
       "      <td id=\"T_f5d99_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f5d99_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "      <td id=\"T_f5d99_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
       "      <td id=\"T_f5d99_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
       "      <td id=\"T_f5d99_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
       "      <td id=\"T_f5d99_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
       "      <td id=\"T_f5d99_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f5d99_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "      <td id=\"T_f5d99_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
       "      <td id=\"T_f5d99_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
       "      <td id=\"T_f5d99_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
       "      <td id=\"T_f5d99_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
       "      <td id=\"T_f5d99_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f5d99_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "      <td id=\"T_f5d99_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
       "      <td id=\"T_f5d99_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
       "      <td id=\"T_f5d99_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
       "      <td id=\"T_f5d99_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
       "      <td id=\"T_f5d99_row9_col4\" class=\"data row9 col4\" >nan</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x25b87b89ac0>"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cm = sns.light_palette('red', as_cmap=True)\n",
    "\n",
    "df.style.background_gradient(cmap='viridis')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "1d986730",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_873c1_row0_col2 {\n",
       "  background-color: #000000;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_873c1_row1_col2 {\n",
       "  background-color: #fff7fb;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_873c1_row2_col2 {\n",
       "  background-color: #358fc0;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_873c1_row3_col2 {\n",
       "  background-color: #4a98c5;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_873c1_row4_col2 {\n",
       "  background-color: #03476f;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_873c1_row5_col2 {\n",
       "  background-color: #056fae;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_873c1_row6_col2 {\n",
       "  background-color: #023858;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_873c1_row7_col2 {\n",
       "  background-color: #034973;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_873c1_row8_col2 {\n",
       "  background-color: #f9f2f8;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_873c1_row9_col2 {\n",
       "  background-color: #056aa6;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_873c1_\">\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_873c1_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "      <td id=\"T_873c1_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
       "      <td id=\"T_873c1_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
       "      <td id=\"T_873c1_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
       "      <td id=\"T_873c1_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
       "      <td id=\"T_873c1_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_873c1_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "      <td id=\"T_873c1_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
       "      <td id=\"T_873c1_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
       "      <td id=\"T_873c1_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
       "      <td id=\"T_873c1_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
       "      <td id=\"T_873c1_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_873c1_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "      <td id=\"T_873c1_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
       "      <td id=\"T_873c1_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
       "      <td id=\"T_873c1_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
       "      <td id=\"T_873c1_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
       "      <td id=\"T_873c1_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_873c1_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "      <td id=\"T_873c1_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
       "      <td id=\"T_873c1_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
       "      <td id=\"T_873c1_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
       "      <td id=\"T_873c1_row3_col3\" class=\"data row3 col3\" >nan</td>\n",
       "      <td id=\"T_873c1_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_873c1_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "      <td id=\"T_873c1_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
       "      <td id=\"T_873c1_row4_col1\" class=\"data row4 col1\" >nan</td>\n",
       "      <td id=\"T_873c1_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
       "      <td id=\"T_873c1_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
       "      <td id=\"T_873c1_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_873c1_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "      <td id=\"T_873c1_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
       "      <td id=\"T_873c1_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
       "      <td id=\"T_873c1_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
       "      <td id=\"T_873c1_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
       "      <td id=\"T_873c1_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_873c1_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "      <td id=\"T_873c1_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
       "      <td id=\"T_873c1_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
       "      <td id=\"T_873c1_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
       "      <td id=\"T_873c1_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
       "      <td id=\"T_873c1_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_873c1_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "      <td id=\"T_873c1_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
       "      <td id=\"T_873c1_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
       "      <td id=\"T_873c1_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
       "      <td id=\"T_873c1_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
       "      <td id=\"T_873c1_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_873c1_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "      <td id=\"T_873c1_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
       "      <td id=\"T_873c1_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
       "      <td id=\"T_873c1_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
       "      <td id=\"T_873c1_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
       "      <td id=\"T_873c1_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_873c1_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "      <td id=\"T_873c1_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
       "      <td id=\"T_873c1_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
       "      <td id=\"T_873c1_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
       "      <td id=\"T_873c1_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
       "      <td id=\"T_873c1_row9_col4\" class=\"data row9 col4\" >nan</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x25b87ac2040>"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Q12\n",
    "df.style.background_gradient(subset=['C'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "1ed1cbfb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_4f747_row0_col0, #T_4f747_row1_col2, #T_4f747_row2_col1, #T_4f747_row8_col4, #T_4f747_row9_col3 {\n",
       "  background-color: #fff7fb;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_4f747_row0_col1 {\n",
       "  background-color: #045585;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_4f747_row0_col2, #T_4f747_row3_col3, #T_4f747_row4_col1, #T_4f747_row9_col4 {\n",
       "  background-color: #000000;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_4f747_row0_col3 {\n",
       "  background-color: #eae6f1;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_4f747_row0_col4 {\n",
       "  background-color: #c8cde4;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_4f747_row1_col0 {\n",
       "  background-color: #eee9f3;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_4f747_row1_col1 {\n",
       "  background-color: #e3e0ee;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_4f747_row1_col3 {\n",
       "  background-color: #509ac6;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_4f747_row1_col4, #T_4f747_row7_col1 {\n",
       "  background-color: #4295c3;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_4f747_row2_col0 {\n",
       "  background-color: #d7d6e9;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_4f747_row2_col2, #T_4f747_row2_col3 {\n",
       "  background-color: #358fc0;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_4f747_row2_col4, #T_4f747_row6_col2, #T_4f747_row8_col1, #T_4f747_row8_col3, #T_4f747_row9_col0 {\n",
       "  background-color: #023858;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_4f747_row3_col0 {\n",
       "  background-color: #b4c4df;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_4f747_row3_col1, #T_4f747_row7_col0 {\n",
       "  background-color: #056ba7;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_4f747_row3_col2 {\n",
       "  background-color: #4a98c5;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_4f747_row3_col4 {\n",
       "  background-color: #0872b1;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_4f747_row4_col0 {\n",
       "  background-color: #8bb2d4;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_4f747_row4_col2 {\n",
       "  background-color: #03476f;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_4f747_row4_col3 {\n",
       "  background-color: #a7bddb;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_4f747_row4_col4, #T_4f747_row7_col4 {\n",
       "  background-color: #2a88bc;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_4f747_row5_col0 {\n",
       "  background-color: #589ec8;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_4f747_row5_col1 {\n",
       "  background-color: #f2ecf5;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_4f747_row5_col2 {\n",
       "  background-color: #056fae;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_4f747_row5_col3 {\n",
       "  background-color: #023c5f;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_4f747_row5_col4 {\n",
       "  background-color: #6fa7ce;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_4f747_row6_col0 {\n",
       "  background-color: #2685bb;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_4f747_row6_col1 {\n",
       "  background-color: #65a3cb;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_4f747_row6_col3 {\n",
       "  background-color: #c2cbe2;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_4f747_row6_col4, #T_4f747_row7_col2 {\n",
       "  background-color: #034973;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_4f747_row7_col3 {\n",
       "  background-color: #f0eaf4;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_4f747_row8_col0 {\n",
       "  background-color: #045687;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_4f747_row8_col2 {\n",
       "  background-color: #f9f2f8;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_4f747_row9_col1 {\n",
       "  background-color: #88b1d4;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_4f747_row9_col2 {\n",
       "  background-color: #056aa6;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_4f747_\">\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_4f747_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "      <td id=\"T_4f747_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
       "      <td id=\"T_4f747_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
       "      <td id=\"T_4f747_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
       "      <td id=\"T_4f747_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
       "      <td id=\"T_4f747_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4f747_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "      <td id=\"T_4f747_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
       "      <td id=\"T_4f747_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
       "      <td id=\"T_4f747_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
       "      <td id=\"T_4f747_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
       "      <td id=\"T_4f747_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4f747_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "      <td id=\"T_4f747_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
       "      <td id=\"T_4f747_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
       "      <td id=\"T_4f747_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
       "      <td id=\"T_4f747_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
       "      <td id=\"T_4f747_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4f747_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "      <td id=\"T_4f747_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
       "      <td id=\"T_4f747_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
       "      <td id=\"T_4f747_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
       "      <td id=\"T_4f747_row3_col3\" class=\"data row3 col3\" >nan</td>\n",
       "      <td id=\"T_4f747_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4f747_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "      <td id=\"T_4f747_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
       "      <td id=\"T_4f747_row4_col1\" class=\"data row4 col1\" >nan</td>\n",
       "      <td id=\"T_4f747_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
       "      <td id=\"T_4f747_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
       "      <td id=\"T_4f747_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4f747_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "      <td id=\"T_4f747_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
       "      <td id=\"T_4f747_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
       "      <td id=\"T_4f747_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
       "      <td id=\"T_4f747_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
       "      <td id=\"T_4f747_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4f747_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "      <td id=\"T_4f747_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
       "      <td id=\"T_4f747_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
       "      <td id=\"T_4f747_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
       "      <td id=\"T_4f747_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
       "      <td id=\"T_4f747_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4f747_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "      <td id=\"T_4f747_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
       "      <td id=\"T_4f747_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
       "      <td id=\"T_4f747_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
       "      <td id=\"T_4f747_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
       "      <td id=\"T_4f747_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4f747_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "      <td id=\"T_4f747_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
       "      <td id=\"T_4f747_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
       "      <td id=\"T_4f747_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
       "      <td id=\"T_4f747_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
       "      <td id=\"T_4f747_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4f747_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "      <td id=\"T_4f747_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
       "      <td id=\"T_4f747_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
       "      <td id=\"T_4f747_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
       "      <td id=\"T_4f747_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
       "      <td id=\"T_4f747_row9_col4\" class=\"data row9 col4\" >nan</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x25b85b487c0>"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Q13\n",
    "df.style.background_gradient()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "482c0550",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_5f630_  {\n",
       "  border: 4px solid #7a7;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_5f630_\">\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_5f630_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "      <td id=\"T_5f630_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
       "      <td id=\"T_5f630_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
       "      <td id=\"T_5f630_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
       "      <td id=\"T_5f630_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
       "      <td id=\"T_5f630_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_5f630_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "      <td id=\"T_5f630_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
       "      <td id=\"T_5f630_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
       "      <td id=\"T_5f630_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
       "      <td id=\"T_5f630_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
       "      <td id=\"T_5f630_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_5f630_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "      <td id=\"T_5f630_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
       "      <td id=\"T_5f630_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
       "      <td id=\"T_5f630_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
       "      <td id=\"T_5f630_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
       "      <td id=\"T_5f630_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_5f630_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "      <td id=\"T_5f630_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
       "      <td id=\"T_5f630_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
       "      <td id=\"T_5f630_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
       "      <td id=\"T_5f630_row3_col3\" class=\"data row3 col3\" >nan</td>\n",
       "      <td id=\"T_5f630_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_5f630_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "      <td id=\"T_5f630_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
       "      <td id=\"T_5f630_row4_col1\" class=\"data row4 col1\" >nan</td>\n",
       "      <td id=\"T_5f630_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
       "      <td id=\"T_5f630_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
       "      <td id=\"T_5f630_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_5f630_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "      <td id=\"T_5f630_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
       "      <td id=\"T_5f630_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
       "      <td id=\"T_5f630_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
       "      <td id=\"T_5f630_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
       "      <td id=\"T_5f630_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_5f630_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "      <td id=\"T_5f630_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
       "      <td id=\"T_5f630_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
       "      <td id=\"T_5f630_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
       "      <td id=\"T_5f630_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
       "      <td id=\"T_5f630_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_5f630_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "      <td id=\"T_5f630_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
       "      <td id=\"T_5f630_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
       "      <td id=\"T_5f630_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
       "      <td id=\"T_5f630_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
       "      <td id=\"T_5f630_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_5f630_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "      <td id=\"T_5f630_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
       "      <td id=\"T_5f630_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
       "      <td id=\"T_5f630_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
       "      <td id=\"T_5f630_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
       "      <td id=\"T_5f630_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_5f630_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "      <td id=\"T_5f630_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
       "      <td id=\"T_5f630_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
       "      <td id=\"T_5f630_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
       "      <td id=\"T_5f630_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
       "      <td id=\"T_5f630_row9_col4\" class=\"data row9 col4\" >nan</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x25b87c2f640>"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Q14\n",
    "df.style.set_table_styles([{'selector':'','props':[('border','4px solid #7a7')]}])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "766c0edd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_a2ade_row0_col1 {\n",
       "  width: 10em;\n",
       "  height: 80%;\n",
       "  background: linear-gradient(90deg,#d65f5f 89.2%, transparent 89.2%);\n",
       "}\n",
       "#T_a2ade_row1_col1 {\n",
       "  width: 10em;\n",
       "  height: 80%;\n",
       "  background: linear-gradient(90deg,#d65f5f 16.8%, transparent 16.8%);\n",
       "}\n",
       "#T_a2ade_row1_col2, #T_a2ade_row2_col1 {\n",
       "  width: 10em;\n",
       "  height: 80%;\n",
       "}\n",
       "#T_a2ade_row2_col2 {\n",
       "  width: 10em;\n",
       "  height: 80%;\n",
       "  background: linear-gradient(90deg,#d65f5f 62.7%, transparent 62.7%);\n",
       "}\n",
       "#T_a2ade_row3_col1 {\n",
       "  width: 10em;\n",
       "  height: 80%;\n",
       "  background: linear-gradient(90deg,#d65f5f 78.1%, transparent 78.1%);\n",
       "}\n",
       "#T_a2ade_row3_col2 {\n",
       "  width: 10em;\n",
       "  height: 80%;\n",
       "  background: linear-gradient(90deg,#d65f5f 58.3%, transparent 58.3%);\n",
       "}\n",
       "#T_a2ade_row4_col2 {\n",
       "  width: 10em;\n",
       "  height: 80%;\n",
       "  background: linear-gradient(90deg,#d65f5f 94.3%, transparent 94.3%);\n",
       "}\n",
       "#T_a2ade_row5_col1 {\n",
       "  width: 10em;\n",
       "  height: 80%;\n",
       "  background: linear-gradient(90deg,#d65f5f 8.7%, transparent 8.7%);\n",
       "}\n",
       "#T_a2ade_row5_col2 {\n",
       "  width: 10em;\n",
       "  height: 80%;\n",
       "  background: linear-gradient(90deg,#d65f5f 75.6%, transparent 75.6%);\n",
       "}\n",
       "#T_a2ade_row6_col1 {\n",
       "  width: 10em;\n",
       "  height: 80%;\n",
       "  background: linear-gradient(90deg,#d65f5f 52.8%, transparent 52.8%);\n",
       "}\n",
       "#T_a2ade_row6_col2, #T_a2ade_row8_col1 {\n",
       "  width: 10em;\n",
       "  height: 80%;\n",
       "  background: linear-gradient(90deg,#d65f5f 100.0%, transparent 100.0%);\n",
       "}\n",
       "#T_a2ade_row7_col1 {\n",
       "  width: 10em;\n",
       "  height: 80%;\n",
       "  background: linear-gradient(90deg,#d65f5f 59.8%, transparent 59.8%);\n",
       "}\n",
       "#T_a2ade_row7_col2 {\n",
       "  width: 10em;\n",
       "  height: 80%;\n",
       "  background: linear-gradient(90deg,#d65f5f 93.6%, transparent 93.6%);\n",
       "}\n",
       "#T_a2ade_row8_col2 {\n",
       "  width: 10em;\n",
       "  height: 80%;\n",
       "  background: linear-gradient(90deg,#d65f5f 4.3%, transparent 4.3%);\n",
       "}\n",
       "#T_a2ade_row9_col1 {\n",
       "  width: 10em;\n",
       "  height: 80%;\n",
       "  background: linear-gradient(90deg,#d65f5f 45.2%, transparent 45.2%);\n",
       "}\n",
       "#T_a2ade_row9_col2 {\n",
       "  width: 10em;\n",
       "  height: 80%;\n",
       "  background: linear-gradient(90deg,#d65f5f 78.2%, transparent 78.2%);\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_a2ade_\">\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_a2ade_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "      <td id=\"T_a2ade_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
       "      <td id=\"T_a2ade_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
       "      <td id=\"T_a2ade_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
       "      <td id=\"T_a2ade_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
       "      <td id=\"T_a2ade_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_a2ade_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "      <td id=\"T_a2ade_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
       "      <td id=\"T_a2ade_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
       "      <td id=\"T_a2ade_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
       "      <td id=\"T_a2ade_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
       "      <td id=\"T_a2ade_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_a2ade_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "      <td id=\"T_a2ade_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
       "      <td id=\"T_a2ade_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
       "      <td id=\"T_a2ade_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
       "      <td id=\"T_a2ade_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
       "      <td id=\"T_a2ade_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_a2ade_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "      <td id=\"T_a2ade_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
       "      <td id=\"T_a2ade_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
       "      <td id=\"T_a2ade_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
       "      <td id=\"T_a2ade_row3_col3\" class=\"data row3 col3\" >nan</td>\n",
       "      <td id=\"T_a2ade_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_a2ade_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "      <td id=\"T_a2ade_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
       "      <td id=\"T_a2ade_row4_col1\" class=\"data row4 col1\" >nan</td>\n",
       "      <td id=\"T_a2ade_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
       "      <td id=\"T_a2ade_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
       "      <td id=\"T_a2ade_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_a2ade_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "      <td id=\"T_a2ade_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
       "      <td id=\"T_a2ade_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
       "      <td id=\"T_a2ade_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
       "      <td id=\"T_a2ade_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
       "      <td id=\"T_a2ade_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_a2ade_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "      <td id=\"T_a2ade_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
       "      <td id=\"T_a2ade_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
       "      <td id=\"T_a2ade_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
       "      <td id=\"T_a2ade_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
       "      <td id=\"T_a2ade_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_a2ade_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "      <td id=\"T_a2ade_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
       "      <td id=\"T_a2ade_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
       "      <td id=\"T_a2ade_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
       "      <td id=\"T_a2ade_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
       "      <td id=\"T_a2ade_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_a2ade_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "      <td id=\"T_a2ade_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
       "      <td id=\"T_a2ade_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
       "      <td id=\"T_a2ade_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
       "      <td id=\"T_a2ade_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
       "      <td id=\"T_a2ade_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_a2ade_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "      <td id=\"T_a2ade_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
       "      <td id=\"T_a2ade_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
       "      <td id=\"T_a2ade_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
       "      <td id=\"T_a2ade_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
       "      <td id=\"T_a2ade_row9_col4\" class=\"data row9 col4\" >nan</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x25b87c2ffd0>"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Q15\n",
    "df.style.bar(subset=['B', 'C'], color='#d65f5f')"
   ]
  }
 ],
 "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
}