Formatting.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-0.719057</td>\n",
       "      <td>-1.427226</td>\n",
       "      <td>0.092920</td>\n",
       "      <td>-1.513302</td>\n",
       "      <td>0.501699</td>\n",
       "      <td>-0.032344</td>\n",
       "      <td>0.809496</td>\n",
       "      <td>1.630693</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.060627</td>\n",
       "      <td>1.845326</td>\n",
       "      <td>-1.244052</td>\n",
       "      <td>-0.646792</td>\n",
       "      <td>1.295389</td>\n",
       "      <td>0.324024</td>\n",
       "      <td>1.517578</td>\n",
       "      <td>-1.357283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-0.322440</td>\n",
       "      <td>1.158838</td>\n",
       "      <td>0.296819</td>\n",
       "      <td>-0.556579</td>\n",
       "      <td>1.525666</td>\n",
       "      <td>1.033852</td>\n",
       "      <td>0.189367</td>\n",
       "      <td>-1.440268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-1.102373</td>\n",
       "      <td>0.722252</td>\n",
       "      <td>1.672365</td>\n",
       "      <td>0.306363</td>\n",
       "      <td>1.647472</td>\n",
       "      <td>0.455757</td>\n",
       "      <td>-0.743033</td>\n",
       "      <td>-1.922184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.916333</td>\n",
       "      <td>-1.301610</td>\n",
       "      <td>0.940713</td>\n",
       "      <td>1.377446</td>\n",
       "      <td>1.938142</td>\n",
       "      <td>1.296328</td>\n",
       "      <td>-1.544654</td>\n",
       "      <td>-0.821843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0.727986</td>\n",
       "      <td>0.919669</td>\n",
       "      <td>-0.975083</td>\n",
       "      <td>1.781746</td>\n",
       "      <td>1.638491</td>\n",
       "      <td>-0.847164</td>\n",
       "      <td>0.758838</td>\n",
       "      <td>-1.689786</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          0         1         2         3         4         5         6  \\\n",
       "0 -0.719057 -1.427226  0.092920 -1.513302  0.501699 -0.032344  0.809496   \n",
       "1  0.060627  1.845326 -1.244052 -0.646792  1.295389  0.324024  1.517578   \n",
       "2 -0.322440  1.158838  0.296819 -0.556579  1.525666  1.033852  0.189367   \n",
       "3 -1.102373  0.722252  1.672365  0.306363  1.647472  0.455757 -0.743033   \n",
       "4  0.916333 -1.301610  0.940713  1.377446  1.938142  1.296328 -1.544654   \n",
       "5  0.727986  0.919669 -0.975083  1.781746  1.638491 -0.847164  0.758838   \n",
       "\n",
       "          7  \n",
       "0  1.630693  \n",
       "1 -1.357283  \n",
       "2 -1.440268  \n",
       "3 -1.922184  \n",
       "4 -0.821843  \n",
       "5 -1.689786  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = np.random.uniform(-2 , 2 , size = (6,8))\n",
    "df = pd.DataFrame(data )\n",
    "df\n",
    "\n",
    "# https://www.codegrepper.com/code-examples/python/python+fstring"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Using f-strings to highlight negative values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "metadata": {},
   "outputs": [],
   "source": [
    "def negative_color(x):\n",
    "    if x > 0: \n",
    "        color = 'black'\n",
    "    else: \n",
    "        color = 'red'\n",
    "    \n",
    "    return f'color: { color }'\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "#T_d7166_row0_col0,#T_d7166_row0_col1,#T_d7166_row0_col3,#T_d7166_row0_col5,#T_d7166_row1_col2,#T_d7166_row1_col3,#T_d7166_row1_col7,#T_d7166_row2_col0,#T_d7166_row2_col3,#T_d7166_row2_col7,#T_d7166_row3_col0,#T_d7166_row3_col6,#T_d7166_row3_col7,#T_d7166_row4_col1,#T_d7166_row4_col6,#T_d7166_row4_col7,#T_d7166_row5_col2,#T_d7166_row5_col5,#T_d7166_row5_col7{\n",
       "            color:  red;\n",
       "        }#T_d7166_row0_col2,#T_d7166_row0_col4,#T_d7166_row0_col6,#T_d7166_row0_col7,#T_d7166_row1_col0,#T_d7166_row1_col1,#T_d7166_row1_col4,#T_d7166_row1_col5,#T_d7166_row1_col6,#T_d7166_row2_col1,#T_d7166_row2_col2,#T_d7166_row2_col4,#T_d7166_row2_col5,#T_d7166_row2_col6,#T_d7166_row3_col1,#T_d7166_row3_col2,#T_d7166_row3_col3,#T_d7166_row3_col4,#T_d7166_row3_col5,#T_d7166_row4_col0,#T_d7166_row4_col2,#T_d7166_row4_col3,#T_d7166_row4_col4,#T_d7166_row4_col5,#T_d7166_row5_col0,#T_d7166_row5_col1,#T_d7166_row5_col3,#T_d7166_row5_col4,#T_d7166_row5_col6{\n",
       "            color:  black;\n",
       "        }</style><table id=\"T_d7166_\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >0</th>        <th class=\"col_heading level0 col1\" >1</th>        <th class=\"col_heading level0 col2\" >2</th>        <th class=\"col_heading level0 col3\" >3</th>        <th class=\"col_heading level0 col4\" >4</th>        <th class=\"col_heading level0 col5\" >5</th>        <th class=\"col_heading level0 col6\" >6</th>        <th class=\"col_heading level0 col7\" >7</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_d7166_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "                        <td id=\"T_d7166_row0_col0\" class=\"data row0 col0\" >-0.719057</td>\n",
       "                        <td id=\"T_d7166_row0_col1\" class=\"data row0 col1\" >-1.427226</td>\n",
       "                        <td id=\"T_d7166_row0_col2\" class=\"data row0 col2\" >0.092920</td>\n",
       "                        <td id=\"T_d7166_row0_col3\" class=\"data row0 col3\" >-1.513302</td>\n",
       "                        <td id=\"T_d7166_row0_col4\" class=\"data row0 col4\" >0.501699</td>\n",
       "                        <td id=\"T_d7166_row0_col5\" class=\"data row0 col5\" >-0.032344</td>\n",
       "                        <td id=\"T_d7166_row0_col6\" class=\"data row0 col6\" >0.809496</td>\n",
       "                        <td id=\"T_d7166_row0_col7\" class=\"data row0 col7\" >1.630693</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_d7166_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "                        <td id=\"T_d7166_row1_col0\" class=\"data row1 col0\" >0.060627</td>\n",
       "                        <td id=\"T_d7166_row1_col1\" class=\"data row1 col1\" >1.845326</td>\n",
       "                        <td id=\"T_d7166_row1_col2\" class=\"data row1 col2\" >-1.244052</td>\n",
       "                        <td id=\"T_d7166_row1_col3\" class=\"data row1 col3\" >-0.646792</td>\n",
       "                        <td id=\"T_d7166_row1_col4\" class=\"data row1 col4\" >1.295389</td>\n",
       "                        <td id=\"T_d7166_row1_col5\" class=\"data row1 col5\" >0.324024</td>\n",
       "                        <td id=\"T_d7166_row1_col6\" class=\"data row1 col6\" >1.517578</td>\n",
       "                        <td id=\"T_d7166_row1_col7\" class=\"data row1 col7\" >-1.357283</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_d7166_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "                        <td id=\"T_d7166_row2_col0\" class=\"data row2 col0\" >-0.322440</td>\n",
       "                        <td id=\"T_d7166_row2_col1\" class=\"data row2 col1\" >1.158838</td>\n",
       "                        <td id=\"T_d7166_row2_col2\" class=\"data row2 col2\" >0.296819</td>\n",
       "                        <td id=\"T_d7166_row2_col3\" class=\"data row2 col3\" >-0.556579</td>\n",
       "                        <td id=\"T_d7166_row2_col4\" class=\"data row2 col4\" >1.525666</td>\n",
       "                        <td id=\"T_d7166_row2_col5\" class=\"data row2 col5\" >1.033852</td>\n",
       "                        <td id=\"T_d7166_row2_col6\" class=\"data row2 col6\" >0.189367</td>\n",
       "                        <td id=\"T_d7166_row2_col7\" class=\"data row2 col7\" >-1.440268</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_d7166_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "                        <td id=\"T_d7166_row3_col0\" class=\"data row3 col0\" >-1.102373</td>\n",
       "                        <td id=\"T_d7166_row3_col1\" class=\"data row3 col1\" >0.722252</td>\n",
       "                        <td id=\"T_d7166_row3_col2\" class=\"data row3 col2\" >1.672365</td>\n",
       "                        <td id=\"T_d7166_row3_col3\" class=\"data row3 col3\" >0.306363</td>\n",
       "                        <td id=\"T_d7166_row3_col4\" class=\"data row3 col4\" >1.647472</td>\n",
       "                        <td id=\"T_d7166_row3_col5\" class=\"data row3 col5\" >0.455757</td>\n",
       "                        <td id=\"T_d7166_row3_col6\" class=\"data row3 col6\" >-0.743033</td>\n",
       "                        <td id=\"T_d7166_row3_col7\" class=\"data row3 col7\" >-1.922184</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_d7166_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "                        <td id=\"T_d7166_row4_col0\" class=\"data row4 col0\" >0.916333</td>\n",
       "                        <td id=\"T_d7166_row4_col1\" class=\"data row4 col1\" >-1.301610</td>\n",
       "                        <td id=\"T_d7166_row4_col2\" class=\"data row4 col2\" >0.940713</td>\n",
       "                        <td id=\"T_d7166_row4_col3\" class=\"data row4 col3\" >1.377446</td>\n",
       "                        <td id=\"T_d7166_row4_col4\" class=\"data row4 col4\" >1.938142</td>\n",
       "                        <td id=\"T_d7166_row4_col5\" class=\"data row4 col5\" >1.296328</td>\n",
       "                        <td id=\"T_d7166_row4_col6\" class=\"data row4 col6\" >-1.544654</td>\n",
       "                        <td id=\"T_d7166_row4_col7\" class=\"data row4 col7\" >-0.821843</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_d7166_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "                        <td id=\"T_d7166_row5_col0\" class=\"data row5 col0\" >0.727986</td>\n",
       "                        <td id=\"T_d7166_row5_col1\" class=\"data row5 col1\" >0.919669</td>\n",
       "                        <td id=\"T_d7166_row5_col2\" class=\"data row5 col2\" >-0.975083</td>\n",
       "                        <td id=\"T_d7166_row5_col3\" class=\"data row5 col3\" >1.781746</td>\n",
       "                        <td id=\"T_d7166_row5_col4\" class=\"data row5 col4\" >1.638491</td>\n",
       "                        <td id=\"T_d7166_row5_col5\" class=\"data row5 col5\" >-0.847164</td>\n",
       "                        <td id=\"T_d7166_row5_col6\" class=\"data row5 col6\" >0.758838</td>\n",
       "                        <td id=\"T_d7166_row5_col7\" class=\"data row5 col7\" >-1.689786</td>\n",
       "            </tr>\n",
       "    </tbody></table>"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x14f0ad48>"
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.style.applymap(negative_color)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# To highlight the biggest value in each column"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "#T_fc195_row0_col7,#T_fc195_row1_col1,#T_fc195_row1_col6,#T_fc195_row3_col2,#T_fc195_row4_col0,#T_fc195_row4_col4,#T_fc195_row4_col5,#T_fc195_row5_col3{\n",
       "            background-color:  #CBCE91FF;\n",
       "        }</style><table id=\"T_fc195_\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >0</th>        <th class=\"col_heading level0 col1\" >1</th>        <th class=\"col_heading level0 col2\" >2</th>        <th class=\"col_heading level0 col3\" >3</th>        <th class=\"col_heading level0 col4\" >4</th>        <th class=\"col_heading level0 col5\" >5</th>        <th class=\"col_heading level0 col6\" >6</th>        <th class=\"col_heading level0 col7\" >7</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_fc195_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "                        <td id=\"T_fc195_row0_col0\" class=\"data row0 col0\" >-0.719057</td>\n",
       "                        <td id=\"T_fc195_row0_col1\" class=\"data row0 col1\" >-1.427226</td>\n",
       "                        <td id=\"T_fc195_row0_col2\" class=\"data row0 col2\" >0.092920</td>\n",
       "                        <td id=\"T_fc195_row0_col3\" class=\"data row0 col3\" >-1.513302</td>\n",
       "                        <td id=\"T_fc195_row0_col4\" class=\"data row0 col4\" >0.501699</td>\n",
       "                        <td id=\"T_fc195_row0_col5\" class=\"data row0 col5\" >-0.032344</td>\n",
       "                        <td id=\"T_fc195_row0_col6\" class=\"data row0 col6\" >0.809496</td>\n",
       "                        <td id=\"T_fc195_row0_col7\" class=\"data row0 col7\" >1.630693</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_fc195_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "                        <td id=\"T_fc195_row1_col0\" class=\"data row1 col0\" >0.060627</td>\n",
       "                        <td id=\"T_fc195_row1_col1\" class=\"data row1 col1\" >1.845326</td>\n",
       "                        <td id=\"T_fc195_row1_col2\" class=\"data row1 col2\" >-1.244052</td>\n",
       "                        <td id=\"T_fc195_row1_col3\" class=\"data row1 col3\" >-0.646792</td>\n",
       "                        <td id=\"T_fc195_row1_col4\" class=\"data row1 col4\" >1.295389</td>\n",
       "                        <td id=\"T_fc195_row1_col5\" class=\"data row1 col5\" >0.324024</td>\n",
       "                        <td id=\"T_fc195_row1_col6\" class=\"data row1 col6\" >1.517578</td>\n",
       "                        <td id=\"T_fc195_row1_col7\" class=\"data row1 col7\" >-1.357283</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_fc195_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "                        <td id=\"T_fc195_row2_col0\" class=\"data row2 col0\" >-0.322440</td>\n",
       "                        <td id=\"T_fc195_row2_col1\" class=\"data row2 col1\" >1.158838</td>\n",
       "                        <td id=\"T_fc195_row2_col2\" class=\"data row2 col2\" >0.296819</td>\n",
       "                        <td id=\"T_fc195_row2_col3\" class=\"data row2 col3\" >-0.556579</td>\n",
       "                        <td id=\"T_fc195_row2_col4\" class=\"data row2 col4\" >1.525666</td>\n",
       "                        <td id=\"T_fc195_row2_col5\" class=\"data row2 col5\" >1.033852</td>\n",
       "                        <td id=\"T_fc195_row2_col6\" class=\"data row2 col6\" >0.189367</td>\n",
       "                        <td id=\"T_fc195_row2_col7\" class=\"data row2 col7\" >-1.440268</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_fc195_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "                        <td id=\"T_fc195_row3_col0\" class=\"data row3 col0\" >-1.102373</td>\n",
       "                        <td id=\"T_fc195_row3_col1\" class=\"data row3 col1\" >0.722252</td>\n",
       "                        <td id=\"T_fc195_row3_col2\" class=\"data row3 col2\" >1.672365</td>\n",
       "                        <td id=\"T_fc195_row3_col3\" class=\"data row3 col3\" >0.306363</td>\n",
       "                        <td id=\"T_fc195_row3_col4\" class=\"data row3 col4\" >1.647472</td>\n",
       "                        <td id=\"T_fc195_row3_col5\" class=\"data row3 col5\" >0.455757</td>\n",
       "                        <td id=\"T_fc195_row3_col6\" class=\"data row3 col6\" >-0.743033</td>\n",
       "                        <td id=\"T_fc195_row3_col7\" class=\"data row3 col7\" >-1.922184</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_fc195_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "                        <td id=\"T_fc195_row4_col0\" class=\"data row4 col0\" >0.916333</td>\n",
       "                        <td id=\"T_fc195_row4_col1\" class=\"data row4 col1\" >-1.301610</td>\n",
       "                        <td id=\"T_fc195_row4_col2\" class=\"data row4 col2\" >0.940713</td>\n",
       "                        <td id=\"T_fc195_row4_col3\" class=\"data row4 col3\" >1.377446</td>\n",
       "                        <td id=\"T_fc195_row4_col4\" class=\"data row4 col4\" >1.938142</td>\n",
       "                        <td id=\"T_fc195_row4_col5\" class=\"data row4 col5\" >1.296328</td>\n",
       "                        <td id=\"T_fc195_row4_col6\" class=\"data row4 col6\" >-1.544654</td>\n",
       "                        <td id=\"T_fc195_row4_col7\" class=\"data row4 col7\" >-0.821843</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_fc195_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "                        <td id=\"T_fc195_row5_col0\" class=\"data row5 col0\" >0.727986</td>\n",
       "                        <td id=\"T_fc195_row5_col1\" class=\"data row5 col1\" >0.919669</td>\n",
       "                        <td id=\"T_fc195_row5_col2\" class=\"data row5 col2\" >-0.975083</td>\n",
       "                        <td id=\"T_fc195_row5_col3\" class=\"data row5 col3\" >1.781746</td>\n",
       "                        <td id=\"T_fc195_row5_col4\" class=\"data row5 col4\" >1.638491</td>\n",
       "                        <td id=\"T_fc195_row5_col5\" class=\"data row5 col5\" >-0.847164</td>\n",
       "                        <td id=\"T_fc195_row5_col6\" class=\"data row5 col6\" >0.758838</td>\n",
       "                        <td id=\"T_fc195_row5_col7\" class=\"data row5 col7\" >-1.689786</td>\n",
       "            </tr>\n",
       "    </tbody></table>"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x12632e88>"
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "colmax = df.style.highlight_max(color=\"#CBCE91FF\")\n",
    "colmax"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# To highlight the biggest value in entire Dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "#T_9ed1e_row4_col4{\n",
       "            background-color:  #CBCE91FF;\n",
       "        }</style><table id=\"T_9ed1e_\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >0</th>        <th class=\"col_heading level0 col1\" >1</th>        <th class=\"col_heading level0 col2\" >2</th>        <th class=\"col_heading level0 col3\" >3</th>        <th class=\"col_heading level0 col4\" >4</th>        <th class=\"col_heading level0 col5\" >5</th>        <th class=\"col_heading level0 col6\" >6</th>        <th class=\"col_heading level0 col7\" >7</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_9ed1e_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "                        <td id=\"T_9ed1e_row0_col0\" class=\"data row0 col0\" >-0.719057</td>\n",
       "                        <td id=\"T_9ed1e_row0_col1\" class=\"data row0 col1\" >-1.427226</td>\n",
       "                        <td id=\"T_9ed1e_row0_col2\" class=\"data row0 col2\" >0.092920</td>\n",
       "                        <td id=\"T_9ed1e_row0_col3\" class=\"data row0 col3\" >-1.513302</td>\n",
       "                        <td id=\"T_9ed1e_row0_col4\" class=\"data row0 col4\" >0.501699</td>\n",
       "                        <td id=\"T_9ed1e_row0_col5\" class=\"data row0 col5\" >-0.032344</td>\n",
       "                        <td id=\"T_9ed1e_row0_col6\" class=\"data row0 col6\" >0.809496</td>\n",
       "                        <td id=\"T_9ed1e_row0_col7\" class=\"data row0 col7\" >1.630693</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9ed1e_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "                        <td id=\"T_9ed1e_row1_col0\" class=\"data row1 col0\" >0.060627</td>\n",
       "                        <td id=\"T_9ed1e_row1_col1\" class=\"data row1 col1\" >1.845326</td>\n",
       "                        <td id=\"T_9ed1e_row1_col2\" class=\"data row1 col2\" >-1.244052</td>\n",
       "                        <td id=\"T_9ed1e_row1_col3\" class=\"data row1 col3\" >-0.646792</td>\n",
       "                        <td id=\"T_9ed1e_row1_col4\" class=\"data row1 col4\" >1.295389</td>\n",
       "                        <td id=\"T_9ed1e_row1_col5\" class=\"data row1 col5\" >0.324024</td>\n",
       "                        <td id=\"T_9ed1e_row1_col6\" class=\"data row1 col6\" >1.517578</td>\n",
       "                        <td id=\"T_9ed1e_row1_col7\" class=\"data row1 col7\" >-1.357283</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9ed1e_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "                        <td id=\"T_9ed1e_row2_col0\" class=\"data row2 col0\" >-0.322440</td>\n",
       "                        <td id=\"T_9ed1e_row2_col1\" class=\"data row2 col1\" >1.158838</td>\n",
       "                        <td id=\"T_9ed1e_row2_col2\" class=\"data row2 col2\" >0.296819</td>\n",
       "                        <td id=\"T_9ed1e_row2_col3\" class=\"data row2 col3\" >-0.556579</td>\n",
       "                        <td id=\"T_9ed1e_row2_col4\" class=\"data row2 col4\" >1.525666</td>\n",
       "                        <td id=\"T_9ed1e_row2_col5\" class=\"data row2 col5\" >1.033852</td>\n",
       "                        <td id=\"T_9ed1e_row2_col6\" class=\"data row2 col6\" >0.189367</td>\n",
       "                        <td id=\"T_9ed1e_row2_col7\" class=\"data row2 col7\" >-1.440268</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9ed1e_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "                        <td id=\"T_9ed1e_row3_col0\" class=\"data row3 col0\" >-1.102373</td>\n",
       "                        <td id=\"T_9ed1e_row3_col1\" class=\"data row3 col1\" >0.722252</td>\n",
       "                        <td id=\"T_9ed1e_row3_col2\" class=\"data row3 col2\" >1.672365</td>\n",
       "                        <td id=\"T_9ed1e_row3_col3\" class=\"data row3 col3\" >0.306363</td>\n",
       "                        <td id=\"T_9ed1e_row3_col4\" class=\"data row3 col4\" >1.647472</td>\n",
       "                        <td id=\"T_9ed1e_row3_col5\" class=\"data row3 col5\" >0.455757</td>\n",
       "                        <td id=\"T_9ed1e_row3_col6\" class=\"data row3 col6\" >-0.743033</td>\n",
       "                        <td id=\"T_9ed1e_row3_col7\" class=\"data row3 col7\" >-1.922184</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9ed1e_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "                        <td id=\"T_9ed1e_row4_col0\" class=\"data row4 col0\" >0.916333</td>\n",
       "                        <td id=\"T_9ed1e_row4_col1\" class=\"data row4 col1\" >-1.301610</td>\n",
       "                        <td id=\"T_9ed1e_row4_col2\" class=\"data row4 col2\" >0.940713</td>\n",
       "                        <td id=\"T_9ed1e_row4_col3\" class=\"data row4 col3\" >1.377446</td>\n",
       "                        <td id=\"T_9ed1e_row4_col4\" class=\"data row4 col4\" >1.938142</td>\n",
       "                        <td id=\"T_9ed1e_row4_col5\" class=\"data row4 col5\" >1.296328</td>\n",
       "                        <td id=\"T_9ed1e_row4_col6\" class=\"data row4 col6\" >-1.544654</td>\n",
       "                        <td id=\"T_9ed1e_row4_col7\" class=\"data row4 col7\" >-0.821843</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9ed1e_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "                        <td id=\"T_9ed1e_row5_col0\" class=\"data row5 col0\" >0.727986</td>\n",
       "                        <td id=\"T_9ed1e_row5_col1\" class=\"data row5 col1\" >0.919669</td>\n",
       "                        <td id=\"T_9ed1e_row5_col2\" class=\"data row5 col2\" >-0.975083</td>\n",
       "                        <td id=\"T_9ed1e_row5_col3\" class=\"data row5 col3\" >1.781746</td>\n",
       "                        <td id=\"T_9ed1e_row5_col4\" class=\"data row5 col4\" >1.638491</td>\n",
       "                        <td id=\"T_9ed1e_row5_col5\" class=\"data row5 col5\" >-0.847164</td>\n",
       "                        <td id=\"T_9ed1e_row5_col6\" class=\"data row5 col6\" >0.758838</td>\n",
       "                        <td id=\"T_9ed1e_row5_col7\" class=\"data row5 col7\" >-1.689786</td>\n",
       "            </tr>\n",
       "    </tbody></table>"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x14f06048>"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.style.highlight_max( axis=None , color=\"#CBCE91FF\")\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# To highlight biggest value in each row"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "#T_4ecc2_row0_col7,#T_4ecc2_row1_col1,#T_4ecc2_row2_col4,#T_4ecc2_row3_col2,#T_4ecc2_row4_col4,#T_4ecc2_row5_col3{\n",
       "            background-color:  #CBCE91FF;\n",
       "        }</style><table id=\"T_4ecc2_\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >0</th>        <th class=\"col_heading level0 col1\" >1</th>        <th class=\"col_heading level0 col2\" >2</th>        <th class=\"col_heading level0 col3\" >3</th>        <th class=\"col_heading level0 col4\" >4</th>        <th class=\"col_heading level0 col5\" >5</th>        <th class=\"col_heading level0 col6\" >6</th>        <th class=\"col_heading level0 col7\" >7</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_4ecc2_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "                        <td id=\"T_4ecc2_row0_col0\" class=\"data row0 col0\" >-0.719057</td>\n",
       "                        <td id=\"T_4ecc2_row0_col1\" class=\"data row0 col1\" >-1.427226</td>\n",
       "                        <td id=\"T_4ecc2_row0_col2\" class=\"data row0 col2\" >0.092920</td>\n",
       "                        <td id=\"T_4ecc2_row0_col3\" class=\"data row0 col3\" >-1.513302</td>\n",
       "                        <td id=\"T_4ecc2_row0_col4\" class=\"data row0 col4\" >0.501699</td>\n",
       "                        <td id=\"T_4ecc2_row0_col5\" class=\"data row0 col5\" >-0.032344</td>\n",
       "                        <td id=\"T_4ecc2_row0_col6\" class=\"data row0 col6\" >0.809496</td>\n",
       "                        <td id=\"T_4ecc2_row0_col7\" class=\"data row0 col7\" >1.630693</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_4ecc2_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "                        <td id=\"T_4ecc2_row1_col0\" class=\"data row1 col0\" >0.060627</td>\n",
       "                        <td id=\"T_4ecc2_row1_col1\" class=\"data row1 col1\" >1.845326</td>\n",
       "                        <td id=\"T_4ecc2_row1_col2\" class=\"data row1 col2\" >-1.244052</td>\n",
       "                        <td id=\"T_4ecc2_row1_col3\" class=\"data row1 col3\" >-0.646792</td>\n",
       "                        <td id=\"T_4ecc2_row1_col4\" class=\"data row1 col4\" >1.295389</td>\n",
       "                        <td id=\"T_4ecc2_row1_col5\" class=\"data row1 col5\" >0.324024</td>\n",
       "                        <td id=\"T_4ecc2_row1_col6\" class=\"data row1 col6\" >1.517578</td>\n",
       "                        <td id=\"T_4ecc2_row1_col7\" class=\"data row1 col7\" >-1.357283</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_4ecc2_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "                        <td id=\"T_4ecc2_row2_col0\" class=\"data row2 col0\" >-0.322440</td>\n",
       "                        <td id=\"T_4ecc2_row2_col1\" class=\"data row2 col1\" >1.158838</td>\n",
       "                        <td id=\"T_4ecc2_row2_col2\" class=\"data row2 col2\" >0.296819</td>\n",
       "                        <td id=\"T_4ecc2_row2_col3\" class=\"data row2 col3\" >-0.556579</td>\n",
       "                        <td id=\"T_4ecc2_row2_col4\" class=\"data row2 col4\" >1.525666</td>\n",
       "                        <td id=\"T_4ecc2_row2_col5\" class=\"data row2 col5\" >1.033852</td>\n",
       "                        <td id=\"T_4ecc2_row2_col6\" class=\"data row2 col6\" >0.189367</td>\n",
       "                        <td id=\"T_4ecc2_row2_col7\" class=\"data row2 col7\" >-1.440268</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_4ecc2_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "                        <td id=\"T_4ecc2_row3_col0\" class=\"data row3 col0\" >-1.102373</td>\n",
       "                        <td id=\"T_4ecc2_row3_col1\" class=\"data row3 col1\" >0.722252</td>\n",
       "                        <td id=\"T_4ecc2_row3_col2\" class=\"data row3 col2\" >1.672365</td>\n",
       "                        <td id=\"T_4ecc2_row3_col3\" class=\"data row3 col3\" >0.306363</td>\n",
       "                        <td id=\"T_4ecc2_row3_col4\" class=\"data row3 col4\" >1.647472</td>\n",
       "                        <td id=\"T_4ecc2_row3_col5\" class=\"data row3 col5\" >0.455757</td>\n",
       "                        <td id=\"T_4ecc2_row3_col6\" class=\"data row3 col6\" >-0.743033</td>\n",
       "                        <td id=\"T_4ecc2_row3_col7\" class=\"data row3 col7\" >-1.922184</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_4ecc2_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "                        <td id=\"T_4ecc2_row4_col0\" class=\"data row4 col0\" >0.916333</td>\n",
       "                        <td id=\"T_4ecc2_row4_col1\" class=\"data row4 col1\" >-1.301610</td>\n",
       "                        <td id=\"T_4ecc2_row4_col2\" class=\"data row4 col2\" >0.940713</td>\n",
       "                        <td id=\"T_4ecc2_row4_col3\" class=\"data row4 col3\" >1.377446</td>\n",
       "                        <td id=\"T_4ecc2_row4_col4\" class=\"data row4 col4\" >1.938142</td>\n",
       "                        <td id=\"T_4ecc2_row4_col5\" class=\"data row4 col5\" >1.296328</td>\n",
       "                        <td id=\"T_4ecc2_row4_col6\" class=\"data row4 col6\" >-1.544654</td>\n",
       "                        <td id=\"T_4ecc2_row4_col7\" class=\"data row4 col7\" >-0.821843</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_4ecc2_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "                        <td id=\"T_4ecc2_row5_col0\" class=\"data row5 col0\" >0.727986</td>\n",
       "                        <td id=\"T_4ecc2_row5_col1\" class=\"data row5 col1\" >0.919669</td>\n",
       "                        <td id=\"T_4ecc2_row5_col2\" class=\"data row5 col2\" >-0.975083</td>\n",
       "                        <td id=\"T_4ecc2_row5_col3\" class=\"data row5 col3\" >1.781746</td>\n",
       "                        <td id=\"T_4ecc2_row5_col4\" class=\"data row5 col4\" >1.638491</td>\n",
       "                        <td id=\"T_4ecc2_row5_col5\" class=\"data row5 col5\" >-0.847164</td>\n",
       "                        <td id=\"T_4ecc2_row5_col6\" class=\"data row5 col6\" >0.758838</td>\n",
       "                        <td id=\"T_4ecc2_row5_col7\" class=\"data row5 col7\" >-1.689786</td>\n",
       "            </tr>\n",
       "    </tbody></table>"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x13c35c08>"
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rowmax = df.style.highlight_max( axis=1 , color=\"#CBCE91FF\")\n",
    "rowmax\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Adding Bar plot to pandas DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "#T_3c0a2_row0_col0{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 28.8%, #EEA47FFF 28.8%, #EEA47FFF 45.0%, transparent 45.0%);\n",
       "        }#T_3c0a2_row0_col1{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 12.9%, #EEA47FFF 12.9%, #EEA47FFF 45.0%, transparent 45.0%);\n",
       "        }#T_3c0a2_row0_col2{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 47.1%, transparent 47.1%);\n",
       "        }#T_3c0a2_row0_col3{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 11.0%, #EEA47FFF 11.0%, #EEA47FFF 45.0%, transparent 45.0%);\n",
       "        }#T_3c0a2_row0_col4{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 56.3%, transparent 56.3%);\n",
       "        }#T_3c0a2_row0_col5{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 44.3%, #EEA47FFF 44.3%, #EEA47FFF 45.0%, transparent 45.0%);\n",
       "        }#T_3c0a2_row0_col6{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 63.2%, transparent 63.2%);\n",
       "        }#T_3c0a2_row0_col7{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 81.7%, transparent 81.7%);\n",
       "        }#T_3c0a2_row1_col0{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 46.4%, transparent 46.4%);\n",
       "        }#T_3c0a2_row1_col1{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 86.5%, transparent 86.5%);\n",
       "        }#T_3c0a2_row1_col2{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 17.0%, #EEA47FFF 17.0%, #EEA47FFF 45.0%, transparent 45.0%);\n",
       "        }#T_3c0a2_row1_col3{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 30.4%, #EEA47FFF 30.4%, #EEA47FFF 45.0%, transparent 45.0%);\n",
       "        }#T_3c0a2_row1_col4{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 74.1%, transparent 74.1%);\n",
       "        }#T_3c0a2_row1_col5{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 52.3%, transparent 52.3%);\n",
       "        }#T_3c0a2_row1_col6{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 79.1%, transparent 79.1%);\n",
       "        }#T_3c0a2_row1_col7{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 14.5%, #EEA47FFF 14.5%, #EEA47FFF 45.0%, transparent 45.0%);\n",
       "        }#T_3c0a2_row2_col0{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 37.7%, #EEA47FFF 37.7%, #EEA47FFF 45.0%, transparent 45.0%);\n",
       "        }#T_3c0a2_row2_col1{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 71.1%, transparent 71.1%);\n",
       "        }#T_3c0a2_row2_col2{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 51.7%, transparent 51.7%);\n",
       "        }#T_3c0a2_row2_col3{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 32.5%, #EEA47FFF 32.5%, #EEA47FFF 45.0%, transparent 45.0%);\n",
       "        }#T_3c0a2_row2_col4{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 79.3%, transparent 79.3%);\n",
       "        }#T_3c0a2_row2_col5{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 68.3%, transparent 68.3%);\n",
       "        }#T_3c0a2_row2_col6{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 49.3%, transparent 49.3%);\n",
       "        }#T_3c0a2_row2_col7{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 12.6%, #EEA47FFF 12.6%, #EEA47FFF 45.0%, transparent 45.0%);\n",
       "        }#T_3c0a2_row3_col0{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 20.2%, #EEA47FFF 20.2%, #EEA47FFF 45.0%, transparent 45.0%);\n",
       "        }#T_3c0a2_row3_col1{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 61.3%, transparent 61.3%);\n",
       "        }#T_3c0a2_row3_col2{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 82.6%, transparent 82.6%);\n",
       "        }#T_3c0a2_row3_col3{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 51.9%, transparent 51.9%);\n",
       "        }#T_3c0a2_row3_col4{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 82.1%, transparent 82.1%);\n",
       "        }#T_3c0a2_row3_col5{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 55.3%, transparent 55.3%);\n",
       "        }#T_3c0a2_row3_col6{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 28.3%, #EEA47FFF 28.3%, #EEA47FFF 45.0%, transparent 45.0%);\n",
       "        }#T_3c0a2_row3_col7{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 1.8%, #EEA47FFF 1.8%, #EEA47FFF 45.0%, transparent 45.0%);\n",
       "        }#T_3c0a2_row4_col0{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 65.6%, transparent 65.6%);\n",
       "        }#T_3c0a2_row4_col1{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 15.7%, #EEA47FFF 15.7%, #EEA47FFF 45.0%, transparent 45.0%);\n",
       "        }#T_3c0a2_row4_col2{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 66.2%, transparent 66.2%);\n",
       "        }#T_3c0a2_row4_col3{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 76.0%, transparent 76.0%);\n",
       "        }#T_3c0a2_row4_col4{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 88.6%, transparent 88.6%);\n",
       "        }#T_3c0a2_row4_col5{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 74.2%, transparent 74.2%);\n",
       "        }#T_3c0a2_row4_col6{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 10.2%, #EEA47FFF 10.2%, #EEA47FFF 45.0%, transparent 45.0%);\n",
       "        }#T_3c0a2_row4_col7{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 26.5%, #EEA47FFF 26.5%, #EEA47FFF 45.0%, transparent 45.0%);\n",
       "        }#T_3c0a2_row5_col0{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 61.4%, transparent 61.4%);\n",
       "        }#T_3c0a2_row5_col1{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 65.7%, transparent 65.7%);\n",
       "        }#T_3c0a2_row5_col2{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 23.1%, #EEA47FFF 23.1%, #EEA47FFF 45.0%, transparent 45.0%);\n",
       "        }#T_3c0a2_row5_col3{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 85.1%, transparent 85.1%);\n",
       "        }#T_3c0a2_row5_col4{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 81.9%, transparent 81.9%);\n",
       "        }#T_3c0a2_row5_col5{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 25.9%, #EEA47FFF 25.9%, #EEA47FFF 45.0%, transparent 45.0%);\n",
       "        }#T_3c0a2_row5_col6{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 45.0%, #9CC3D5FF 45.0%, #9CC3D5FF 62.1%, transparent 62.1%);\n",
       "        }#T_3c0a2_row5_col7{\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg, transparent 7.0%, #EEA47FFF 7.0%, #EEA47FFF 45.0%, transparent 45.0%);\n",
       "        }</style><table id=\"T_3c0a2_\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >0</th>        <th class=\"col_heading level0 col1\" >1</th>        <th class=\"col_heading level0 col2\" >2</th>        <th class=\"col_heading level0 col3\" >3</th>        <th class=\"col_heading level0 col4\" >4</th>        <th class=\"col_heading level0 col5\" >5</th>        <th class=\"col_heading level0 col6\" >6</th>        <th class=\"col_heading level0 col7\" >7</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_3c0a2_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "                        <td id=\"T_3c0a2_row0_col0\" class=\"data row0 col0\" >-0.719057</td>\n",
       "                        <td id=\"T_3c0a2_row0_col1\" class=\"data row0 col1\" >-1.427226</td>\n",
       "                        <td id=\"T_3c0a2_row0_col2\" class=\"data row0 col2\" >0.092920</td>\n",
       "                        <td id=\"T_3c0a2_row0_col3\" class=\"data row0 col3\" >-1.513302</td>\n",
       "                        <td id=\"T_3c0a2_row0_col4\" class=\"data row0 col4\" >0.501699</td>\n",
       "                        <td id=\"T_3c0a2_row0_col5\" class=\"data row0 col5\" >-0.032344</td>\n",
       "                        <td id=\"T_3c0a2_row0_col6\" class=\"data row0 col6\" >0.809496</td>\n",
       "                        <td id=\"T_3c0a2_row0_col7\" class=\"data row0 col7\" >1.630693</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_3c0a2_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "                        <td id=\"T_3c0a2_row1_col0\" class=\"data row1 col0\" >0.060627</td>\n",
       "                        <td id=\"T_3c0a2_row1_col1\" class=\"data row1 col1\" >1.845326</td>\n",
       "                        <td id=\"T_3c0a2_row1_col2\" class=\"data row1 col2\" >-1.244052</td>\n",
       "                        <td id=\"T_3c0a2_row1_col3\" class=\"data row1 col3\" >-0.646792</td>\n",
       "                        <td id=\"T_3c0a2_row1_col4\" class=\"data row1 col4\" >1.295389</td>\n",
       "                        <td id=\"T_3c0a2_row1_col5\" class=\"data row1 col5\" >0.324024</td>\n",
       "                        <td id=\"T_3c0a2_row1_col6\" class=\"data row1 col6\" >1.517578</td>\n",
       "                        <td id=\"T_3c0a2_row1_col7\" class=\"data row1 col7\" >-1.357283</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_3c0a2_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "                        <td id=\"T_3c0a2_row2_col0\" class=\"data row2 col0\" >-0.322440</td>\n",
       "                        <td id=\"T_3c0a2_row2_col1\" class=\"data row2 col1\" >1.158838</td>\n",
       "                        <td id=\"T_3c0a2_row2_col2\" class=\"data row2 col2\" >0.296819</td>\n",
       "                        <td id=\"T_3c0a2_row2_col3\" class=\"data row2 col3\" >-0.556579</td>\n",
       "                        <td id=\"T_3c0a2_row2_col4\" class=\"data row2 col4\" >1.525666</td>\n",
       "                        <td id=\"T_3c0a2_row2_col5\" class=\"data row2 col5\" >1.033852</td>\n",
       "                        <td id=\"T_3c0a2_row2_col6\" class=\"data row2 col6\" >0.189367</td>\n",
       "                        <td id=\"T_3c0a2_row2_col7\" class=\"data row2 col7\" >-1.440268</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_3c0a2_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "                        <td id=\"T_3c0a2_row3_col0\" class=\"data row3 col0\" >-1.102373</td>\n",
       "                        <td id=\"T_3c0a2_row3_col1\" class=\"data row3 col1\" >0.722252</td>\n",
       "                        <td id=\"T_3c0a2_row3_col2\" class=\"data row3 col2\" >1.672365</td>\n",
       "                        <td id=\"T_3c0a2_row3_col3\" class=\"data row3 col3\" >0.306363</td>\n",
       "                        <td id=\"T_3c0a2_row3_col4\" class=\"data row3 col4\" >1.647472</td>\n",
       "                        <td id=\"T_3c0a2_row3_col5\" class=\"data row3 col5\" >0.455757</td>\n",
       "                        <td id=\"T_3c0a2_row3_col6\" class=\"data row3 col6\" >-0.743033</td>\n",
       "                        <td id=\"T_3c0a2_row3_col7\" class=\"data row3 col7\" >-1.922184</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_3c0a2_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "                        <td id=\"T_3c0a2_row4_col0\" class=\"data row4 col0\" >0.916333</td>\n",
       "                        <td id=\"T_3c0a2_row4_col1\" class=\"data row4 col1\" >-1.301610</td>\n",
       "                        <td id=\"T_3c0a2_row4_col2\" class=\"data row4 col2\" >0.940713</td>\n",
       "                        <td id=\"T_3c0a2_row4_col3\" class=\"data row4 col3\" >1.377446</td>\n",
       "                        <td id=\"T_3c0a2_row4_col4\" class=\"data row4 col4\" >1.938142</td>\n",
       "                        <td id=\"T_3c0a2_row4_col5\" class=\"data row4 col5\" >1.296328</td>\n",
       "                        <td id=\"T_3c0a2_row4_col6\" class=\"data row4 col6\" >-1.544654</td>\n",
       "                        <td id=\"T_3c0a2_row4_col7\" class=\"data row4 col7\" >-0.821843</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_3c0a2_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "                        <td id=\"T_3c0a2_row5_col0\" class=\"data row5 col0\" >0.727986</td>\n",
       "                        <td id=\"T_3c0a2_row5_col1\" class=\"data row5 col1\" >0.919669</td>\n",
       "                        <td id=\"T_3c0a2_row5_col2\" class=\"data row5 col2\" >-0.975083</td>\n",
       "                        <td id=\"T_3c0a2_row5_col3\" class=\"data row5 col3\" >1.781746</td>\n",
       "                        <td id=\"T_3c0a2_row5_col4\" class=\"data row5 col4\" >1.638491</td>\n",
       "                        <td id=\"T_3c0a2_row5_col5\" class=\"data row5 col5\" >-0.847164</td>\n",
       "                        <td id=\"T_3c0a2_row5_col6\" class=\"data row5 col6\" >0.758838</td>\n",
       "                        <td id=\"T_3c0a2_row5_col7\" class=\"data row5 col7\" >-1.689786</td>\n",
       "            </tr>\n",
       "    </tbody></table>"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x1024fc48>"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.style.bar(width=90 , color= [ \"#EEA47FFF\" , \"#9CC3D5FF\" ], align= \"mid\" , vmin=(-2) , vmax = (2))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# To change color while hovering"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "    #T_5e62f_ tr:hover {\n",
       "          background-color: pink;\n",
       "    }</style><table id=\"T_5e62f_\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >0</th>        <th class=\"col_heading level0 col1\" >1</th>        <th class=\"col_heading level0 col2\" >2</th>        <th class=\"col_heading level0 col3\" >3</th>        <th class=\"col_heading level0 col4\" >4</th>        <th class=\"col_heading level0 col5\" >5</th>        <th class=\"col_heading level0 col6\" >6</th>        <th class=\"col_heading level0 col7\" >7</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_5e62f_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "                        <td id=\"T_5e62f_row0_col0\" class=\"data row0 col0\" >-0.719057</td>\n",
       "                        <td id=\"T_5e62f_row0_col1\" class=\"data row0 col1\" >-1.427226</td>\n",
       "                        <td id=\"T_5e62f_row0_col2\" class=\"data row0 col2\" >0.092920</td>\n",
       "                        <td id=\"T_5e62f_row0_col3\" class=\"data row0 col3\" >-1.513302</td>\n",
       "                        <td id=\"T_5e62f_row0_col4\" class=\"data row0 col4\" >0.501699</td>\n",
       "                        <td id=\"T_5e62f_row0_col5\" class=\"data row0 col5\" >-0.032344</td>\n",
       "                        <td id=\"T_5e62f_row0_col6\" class=\"data row0 col6\" >0.809496</td>\n",
       "                        <td id=\"T_5e62f_row0_col7\" class=\"data row0 col7\" >1.630693</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5e62f_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "                        <td id=\"T_5e62f_row1_col0\" class=\"data row1 col0\" >0.060627</td>\n",
       "                        <td id=\"T_5e62f_row1_col1\" class=\"data row1 col1\" >1.845326</td>\n",
       "                        <td id=\"T_5e62f_row1_col2\" class=\"data row1 col2\" >-1.244052</td>\n",
       "                        <td id=\"T_5e62f_row1_col3\" class=\"data row1 col3\" >-0.646792</td>\n",
       "                        <td id=\"T_5e62f_row1_col4\" class=\"data row1 col4\" >1.295389</td>\n",
       "                        <td id=\"T_5e62f_row1_col5\" class=\"data row1 col5\" >0.324024</td>\n",
       "                        <td id=\"T_5e62f_row1_col6\" class=\"data row1 col6\" >1.517578</td>\n",
       "                        <td id=\"T_5e62f_row1_col7\" class=\"data row1 col7\" >-1.357283</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5e62f_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "                        <td id=\"T_5e62f_row2_col0\" class=\"data row2 col0\" >-0.322440</td>\n",
       "                        <td id=\"T_5e62f_row2_col1\" class=\"data row2 col1\" >1.158838</td>\n",
       "                        <td id=\"T_5e62f_row2_col2\" class=\"data row2 col2\" >0.296819</td>\n",
       "                        <td id=\"T_5e62f_row2_col3\" class=\"data row2 col3\" >-0.556579</td>\n",
       "                        <td id=\"T_5e62f_row2_col4\" class=\"data row2 col4\" >1.525666</td>\n",
       "                        <td id=\"T_5e62f_row2_col5\" class=\"data row2 col5\" >1.033852</td>\n",
       "                        <td id=\"T_5e62f_row2_col6\" class=\"data row2 col6\" >0.189367</td>\n",
       "                        <td id=\"T_5e62f_row2_col7\" class=\"data row2 col7\" >-1.440268</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5e62f_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "                        <td id=\"T_5e62f_row3_col0\" class=\"data row3 col0\" >-1.102373</td>\n",
       "                        <td id=\"T_5e62f_row3_col1\" class=\"data row3 col1\" >0.722252</td>\n",
       "                        <td id=\"T_5e62f_row3_col2\" class=\"data row3 col2\" >1.672365</td>\n",
       "                        <td id=\"T_5e62f_row3_col3\" class=\"data row3 col3\" >0.306363</td>\n",
       "                        <td id=\"T_5e62f_row3_col4\" class=\"data row3 col4\" >1.647472</td>\n",
       "                        <td id=\"T_5e62f_row3_col5\" class=\"data row3 col5\" >0.455757</td>\n",
       "                        <td id=\"T_5e62f_row3_col6\" class=\"data row3 col6\" >-0.743033</td>\n",
       "                        <td id=\"T_5e62f_row3_col7\" class=\"data row3 col7\" >-1.922184</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5e62f_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "                        <td id=\"T_5e62f_row4_col0\" class=\"data row4 col0\" >0.916333</td>\n",
       "                        <td id=\"T_5e62f_row4_col1\" class=\"data row4 col1\" >-1.301610</td>\n",
       "                        <td id=\"T_5e62f_row4_col2\" class=\"data row4 col2\" >0.940713</td>\n",
       "                        <td id=\"T_5e62f_row4_col3\" class=\"data row4 col3\" >1.377446</td>\n",
       "                        <td id=\"T_5e62f_row4_col4\" class=\"data row4 col4\" >1.938142</td>\n",
       "                        <td id=\"T_5e62f_row4_col5\" class=\"data row4 col5\" >1.296328</td>\n",
       "                        <td id=\"T_5e62f_row4_col6\" class=\"data row4 col6\" >-1.544654</td>\n",
       "                        <td id=\"T_5e62f_row4_col7\" class=\"data row4 col7\" >-0.821843</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_5e62f_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "                        <td id=\"T_5e62f_row5_col0\" class=\"data row5 col0\" >0.727986</td>\n",
       "                        <td id=\"T_5e62f_row5_col1\" class=\"data row5 col1\" >0.919669</td>\n",
       "                        <td id=\"T_5e62f_row5_col2\" class=\"data row5 col2\" >-0.975083</td>\n",
       "                        <td id=\"T_5e62f_row5_col3\" class=\"data row5 col3\" >1.781746</td>\n",
       "                        <td id=\"T_5e62f_row5_col4\" class=\"data row5 col4\" >1.638491</td>\n",
       "                        <td id=\"T_5e62f_row5_col5\" class=\"data row5 col5\" >-0.847164</td>\n",
       "                        <td id=\"T_5e62f_row5_col6\" class=\"data row5 col6\" >0.758838</td>\n",
       "                        <td id=\"T_5e62f_row5_col7\" class=\"data row5 col7\" >-1.689786</td>\n",
       "            </tr>\n",
       "    </tbody></table>"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x11b47988>"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.style.set_table_styles([{'selector': 'tr:hover','props': [('background-color', 'pink')]}])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.7.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}