FTE_Week8.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Week 8 Fun Pandas Tricks and Final Thoughts\n",
    "\n",
    "Week 8 reading: **Pandas for Everyone** chapters 17 - 18 (pages 305 - 311), and Appendices\n",
    "\n",
    "Outline:\n",
    "\n",
    "* Giving color to Pandas\n",
    "    1. Color a cell based on value\n",
    "    2. Highlight max in column\n",
    "    3. Applying to entire Dataframe\n",
    "    4. Built-in styles\n",
    "        * Highlight nulls\n",
    "        * Heatmap style\n",
    "    \n",
    "## Overview\n",
    "\n",
    "The Pandas' Dataframe has the ability to change the way cells, rows, columns, or the entire table is displayed. Functions can be written that change style based on criteria. The overview below re-iterates selected parts of the Pandas Documentation on the subject (https://pandas.pydata.org/pandas-docs/stable/user_guide/style.html)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import seaborn as sns\n",
    "\n",
    "%matplotlib inline\n",
    "sns.set()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "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>-0.481165</td>\n",
       "      <td>0.850229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5.0</td>\n",
       "      <td>1.453425</td>\n",
       "      <td>1.057737</td>\n",
       "      <td>0.165562</td>\n",
       "      <td>0.515018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6.0</td>\n",
       "      <td>-1.336936</td>\n",
       "      <td>0.562861</td>\n",
       "      <td>1.392855</td>\n",
       "      <td>-0.063328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7.0</td>\n",
       "      <td>0.121668</td>\n",
       "      <td>1.207603</td>\n",
       "      <td>-0.002040</td>\n",
       "      <td>1.627796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8.0</td>\n",
       "      <td>0.354493</td>\n",
       "      <td>1.037528</td>\n",
       "      <td>-0.385684</td>\n",
       "      <td>0.519818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9.0</td>\n",
       "      <td>1.686583</td>\n",
       "      <td>-1.325963</td>\n",
       "      <td>1.428984</td>\n",
       "      <td>-2.089354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10.0</td>\n",
       "      <td>-0.129820</td>\n",
       "      <td>0.631523</td>\n",
       "      <td>-0.586538</td>\n",
       "      <td>0.290720</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      A         B         C         D         E\n",
       "0   1.0  1.329212       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 -0.481165  0.850229\n",
       "4   5.0  1.453425  1.057737  0.165562  0.515018\n",
       "5   6.0 -1.336936  0.562861  1.392855 -0.063328\n",
       "6   7.0  0.121668  1.207603 -0.002040  1.627796\n",
       "7   8.0  0.354493  1.037528 -0.385684  0.519818\n",
       "8   9.0  1.686583 -1.325963  1.428984 -2.089354\n",
       "9  10.0 -0.129820  0.631523 -0.586538  0.290720"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create a random dataframe with a couple of NaNs.\n",
    "np.random.seed(24)\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'))],\n",
    "               axis=1)\n",
    "df.iloc[0, 2] = np.nan\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Color a cell based on a value\n",
    "\n",
    "Dataframes have a style property that will take either an apply() or applymap() function to conditionally format cells. \n",
    "\n",
    "* `applymap(func)`: applies to individual elements\n",
    "* `apply(func)`: applies to column/row/table\n",
    "\n",
    "In both cases, `apply()` and `applymap()`, we are returning CSS styles.\n",
    "\n",
    "\n",
    "Let's color cells with negative numbers red."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [],
   "source": [
    "def color_negative_red(val):\n",
    "    \"\"\"\n",
    "    Takes a scalar and returns a string with\n",
    "    the css property `'color: red'` for negative\n",
    "    strings, black otherwise.\n",
    "    \"\"\"\n",
    "    color = 'red' if val < 0 else 'black'\n",
    "    return 'color: %s' % color\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row0_col0 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row0_col1 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row0_col2 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row0_col3 {\n",
       "            color:  red;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row0_col4 {\n",
       "            color:  red;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row1_col0 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row1_col1 {\n",
       "            color:  red;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row1_col2 {\n",
       "            color:  red;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row1_col3 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row1_col4 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row2_col0 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row2_col1 {\n",
       "            color:  red;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row2_col2 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row2_col3 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row2_col4 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row3_col0 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row3_col1 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row3_col2 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row3_col3 {\n",
       "            color:  red;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row3_col4 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row4_col0 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row4_col1 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row4_col2 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row4_col3 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row4_col4 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row5_col0 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row5_col1 {\n",
       "            color:  red;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row5_col2 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row5_col3 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row5_col4 {\n",
       "            color:  red;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row6_col0 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row6_col1 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row6_col2 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row6_col3 {\n",
       "            color:  red;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row6_col4 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row7_col0 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row7_col1 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row7_col2 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row7_col3 {\n",
       "            color:  red;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row7_col4 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row8_col0 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row8_col1 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row8_col2 {\n",
       "            color:  red;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row8_col3 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row8_col4 {\n",
       "            color:  red;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row9_col0 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row9_col1 {\n",
       "            color:  red;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row9_col2 {\n",
       "            color:  black;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row9_col3 {\n",
       "            color:  red;\n",
       "        }    #T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row9_col4 {\n",
       "            color:  black;\n",
       "        }</style>  \n",
       "<table id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6\" > \n",
       "<thead>    <tr> \n",
       "        <th class=\"blank level0\" ></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></thead> \n",
       "<tbody>    <tr> \n",
       "        <th id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6level0_row0\" class=\"row_heading level0 row0\" >0</th> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row0_col0\" class=\"data row0 col0\" >1</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row0_col1\" class=\"data row0 col1\" >1.32921</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row0_col2\" class=\"data row0 col2\" >nan</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row0_col3\" class=\"data row0 col3\" >-0.31628</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row0_col4\" class=\"data row0 col4\" >-0.99081</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6level0_row1\" class=\"row_heading level0 row1\" >1</th> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row1_col0\" class=\"data row1 col0\" >2</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row1_col1\" class=\"data row1 col1\" >-1.07082</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row1_col2\" class=\"data row1 col2\" >-1.43871</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row1_col3\" class=\"data row1 col3\" >0.564417</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row1_col4\" class=\"data row1 col4\" >0.295722</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6level0_row2\" class=\"row_heading level0 row2\" >2</th> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row2_col0\" class=\"data row2 col0\" >3</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row2_col1\" class=\"data row2 col1\" >-1.6264</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row2_col2\" class=\"data row2 col2\" >0.219565</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row2_col3\" class=\"data row2 col3\" >0.678805</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row2_col4\" class=\"data row2 col4\" >1.88927</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6level0_row3\" class=\"row_heading level0 row3\" >3</th> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row3_col0\" class=\"data row3 col0\" >4</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row3_col1\" class=\"data row3 col1\" >0.961538</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row3_col2\" class=\"data row3 col2\" >0.104011</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row3_col3\" class=\"data row3 col3\" >-0.481165</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row3_col4\" class=\"data row3 col4\" >0.850229</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6level0_row4\" class=\"row_heading level0 row4\" >4</th> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row4_col0\" class=\"data row4 col0\" >5</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row4_col1\" class=\"data row4 col1\" >1.45342</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row4_col2\" class=\"data row4 col2\" >1.05774</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row4_col3\" class=\"data row4 col3\" >0.165562</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row4_col4\" class=\"data row4 col4\" >0.515018</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6level0_row5\" class=\"row_heading level0 row5\" >5</th> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row5_col0\" class=\"data row5 col0\" >6</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row5_col1\" class=\"data row5 col1\" >-1.33694</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row5_col2\" class=\"data row5 col2\" >0.562861</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row5_col3\" class=\"data row5 col3\" >1.39285</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row5_col4\" class=\"data row5 col4\" >-0.063328</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6level0_row6\" class=\"row_heading level0 row6\" >6</th> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row6_col0\" class=\"data row6 col0\" >7</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row6_col1\" class=\"data row6 col1\" >0.121668</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row6_col2\" class=\"data row6 col2\" >1.2076</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row6_col3\" class=\"data row6 col3\" >-0.00204021</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row6_col4\" class=\"data row6 col4\" >1.6278</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6level0_row7\" class=\"row_heading level0 row7\" >7</th> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row7_col0\" class=\"data row7 col0\" >8</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row7_col1\" class=\"data row7 col1\" >0.354493</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row7_col2\" class=\"data row7 col2\" >1.03753</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row7_col3\" class=\"data row7 col3\" >-0.385684</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row7_col4\" class=\"data row7 col4\" >0.519818</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6level0_row8\" class=\"row_heading level0 row8\" >8</th> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row8_col0\" class=\"data row8 col0\" >9</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row8_col1\" class=\"data row8 col1\" >1.68658</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row8_col2\" class=\"data row8 col2\" >-1.32596</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row8_col3\" class=\"data row8 col3\" >1.42898</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row8_col4\" class=\"data row8 col4\" >-2.08935</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6level0_row9\" class=\"row_heading level0 row9\" >9</th> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row9_col0\" class=\"data row9 col0\" >10</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row9_col1\" class=\"data row9 col1\" >-0.12982</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row9_col2\" class=\"data row9 col2\" >0.631523</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row9_col3\" class=\"data row9 col3\" >-0.586538</td> \n",
       "        <td id=\"T_005821e4_3eaf_11e9_ba53_8c85902f5dd6row9_col4\" class=\"data row9 col4\" >0.29072</td> \n",
       "    </tr></tbody> \n",
       "</table> "
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x1a1ce64668>"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s = df.style.applymap(color_negative_red)\n",
    "s"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Highlight max in column\n",
    "\n",
    "Since we are working with columns, we have to use the `apply()` function. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [],
   "source": [
    "def highlight_max(s):\n",
    "    '''\n",
    "    highlight the maximum in a Series yellow.\n",
    "    '''\n",
    "    is_max = s == s.max()  # Build list is_max -- 1 if max, 0 otherwise\n",
    "    return ['background-color: yellow' if v else '' for v in is_max] # iterate list, return yellow for max"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "    #T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row2_col4 {\n",
       "            background-color:  yellow;\n",
       "        }    #T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row6_col2 {\n",
       "            background-color:  yellow;\n",
       "        }    #T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row8_col1 {\n",
       "            background-color:  yellow;\n",
       "        }    #T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row8_col3 {\n",
       "            background-color:  yellow;\n",
       "        }    #T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row9_col0 {\n",
       "            background-color:  yellow;\n",
       "        }</style>  \n",
       "<table id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6\" > \n",
       "<thead>    <tr> \n",
       "        <th class=\"blank level0\" ></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></thead> \n",
       "<tbody>    <tr> \n",
       "        <th id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6level0_row0\" class=\"row_heading level0 row0\" >0</th> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row0_col0\" class=\"data row0 col0\" >1</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row0_col1\" class=\"data row0 col1\" >1.32921</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row0_col2\" class=\"data row0 col2\" >nan</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row0_col3\" class=\"data row0 col3\" >-0.31628</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row0_col4\" class=\"data row0 col4\" >-0.99081</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6level0_row1\" class=\"row_heading level0 row1\" >1</th> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row1_col0\" class=\"data row1 col0\" >2</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row1_col1\" class=\"data row1 col1\" >-1.07082</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row1_col2\" class=\"data row1 col2\" >-1.43871</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row1_col3\" class=\"data row1 col3\" >0.564417</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row1_col4\" class=\"data row1 col4\" >0.295722</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6level0_row2\" class=\"row_heading level0 row2\" >2</th> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row2_col0\" class=\"data row2 col0\" >3</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row2_col1\" class=\"data row2 col1\" >-1.6264</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row2_col2\" class=\"data row2 col2\" >0.219565</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row2_col3\" class=\"data row2 col3\" >0.678805</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row2_col4\" class=\"data row2 col4\" >1.88927</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6level0_row3\" class=\"row_heading level0 row3\" >3</th> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row3_col0\" class=\"data row3 col0\" >4</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row3_col1\" class=\"data row3 col1\" >0.961538</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row3_col2\" class=\"data row3 col2\" >0.104011</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row3_col3\" class=\"data row3 col3\" >-0.481165</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row3_col4\" class=\"data row3 col4\" >0.850229</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6level0_row4\" class=\"row_heading level0 row4\" >4</th> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row4_col0\" class=\"data row4 col0\" >5</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row4_col1\" class=\"data row4 col1\" >1.45342</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row4_col2\" class=\"data row4 col2\" >1.05774</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row4_col3\" class=\"data row4 col3\" >0.165562</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row4_col4\" class=\"data row4 col4\" >0.515018</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6level0_row5\" class=\"row_heading level0 row5\" >5</th> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row5_col0\" class=\"data row5 col0\" >6</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row5_col1\" class=\"data row5 col1\" >-1.33694</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row5_col2\" class=\"data row5 col2\" >0.562861</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row5_col3\" class=\"data row5 col3\" >1.39285</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row5_col4\" class=\"data row5 col4\" >-0.063328</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6level0_row6\" class=\"row_heading level0 row6\" >6</th> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row6_col0\" class=\"data row6 col0\" >7</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row6_col1\" class=\"data row6 col1\" >0.121668</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row6_col2\" class=\"data row6 col2\" >1.2076</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row6_col3\" class=\"data row6 col3\" >-0.00204021</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row6_col4\" class=\"data row6 col4\" >1.6278</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6level0_row7\" class=\"row_heading level0 row7\" >7</th> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row7_col0\" class=\"data row7 col0\" >8</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row7_col1\" class=\"data row7 col1\" >0.354493</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row7_col2\" class=\"data row7 col2\" >1.03753</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row7_col3\" class=\"data row7 col3\" >-0.385684</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row7_col4\" class=\"data row7 col4\" >0.519818</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6level0_row8\" class=\"row_heading level0 row8\" >8</th> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row8_col0\" class=\"data row8 col0\" >9</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row8_col1\" class=\"data row8 col1\" >1.68658</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row8_col2\" class=\"data row8 col2\" >-1.32596</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row8_col3\" class=\"data row8 col3\" >1.42898</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row8_col4\" class=\"data row8 col4\" >-2.08935</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6level0_row9\" class=\"row_heading level0 row9\" >9</th> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row9_col0\" class=\"data row9 col0\" >10</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row9_col1\" class=\"data row9 col1\" >-0.12982</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row9_col2\" class=\"data row9 col2\" >0.631523</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row9_col3\" class=\"data row9 col3\" >-0.586538</td> \n",
       "        <td id=\"T_cfb3d6f6_3eb2_11e9_ba53_8c85902f5dd6row9_col4\" class=\"data row9 col4\" >0.29072</td> \n",
       "    </tr></tbody> \n",
       "</table> "
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x1a1ce49860>"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.style.apply(highlight_max)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "And, we can chain styles:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row0_col0 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row0_col1 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row0_col2 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row0_col3 {\n",
       "            color:  red;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row0_col4 {\n",
       "            color:  red;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row1_col0 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row1_col1 {\n",
       "            color:  red;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row1_col2 {\n",
       "            color:  red;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row1_col3 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row1_col4 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row2_col0 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row2_col1 {\n",
       "            color:  red;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row2_col2 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row2_col3 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row2_col4 {\n",
       "            color:  black;\n",
       "            background-color:  yellow;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row3_col0 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row3_col1 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row3_col2 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row3_col3 {\n",
       "            color:  red;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row3_col4 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row4_col0 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row4_col1 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row4_col2 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row4_col3 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row4_col4 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row5_col0 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row5_col1 {\n",
       "            color:  red;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row5_col2 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row5_col3 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row5_col4 {\n",
       "            color:  red;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row6_col0 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row6_col1 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row6_col2 {\n",
       "            color:  black;\n",
       "            background-color:  yellow;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row6_col3 {\n",
       "            color:  red;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row6_col4 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row7_col0 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row7_col1 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row7_col2 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row7_col3 {\n",
       "            color:  red;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row7_col4 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row8_col0 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row8_col1 {\n",
       "            color:  black;\n",
       "            background-color:  yellow;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row8_col2 {\n",
       "            color:  red;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row8_col3 {\n",
       "            color:  black;\n",
       "            background-color:  yellow;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row8_col4 {\n",
       "            color:  red;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row9_col0 {\n",
       "            color:  black;\n",
       "            background-color:  yellow;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row9_col1 {\n",
       "            color:  red;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row9_col2 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row9_col3 {\n",
       "            color:  red;\n",
       "            : ;\n",
       "        }    #T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row9_col4 {\n",
       "            color:  black;\n",
       "            : ;\n",
       "        }</style>  \n",
       "<table id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6\" > \n",
       "<thead>    <tr> \n",
       "        <th class=\"blank level0\" ></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></thead> \n",
       "<tbody>    <tr> \n",
       "        <th id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6level0_row0\" class=\"row_heading level0 row0\" >0</th> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row0_col0\" class=\"data row0 col0\" >1</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row0_col1\" class=\"data row0 col1\" >1.32921</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row0_col2\" class=\"data row0 col2\" >nan</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row0_col3\" class=\"data row0 col3\" >-0.31628</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row0_col4\" class=\"data row0 col4\" >-0.99081</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6level0_row1\" class=\"row_heading level0 row1\" >1</th> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row1_col0\" class=\"data row1 col0\" >2</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row1_col1\" class=\"data row1 col1\" >-1.07082</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row1_col2\" class=\"data row1 col2\" >-1.43871</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row1_col3\" class=\"data row1 col3\" >0.564417</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row1_col4\" class=\"data row1 col4\" >0.295722</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6level0_row2\" class=\"row_heading level0 row2\" >2</th> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row2_col0\" class=\"data row2 col0\" >3</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row2_col1\" class=\"data row2 col1\" >-1.6264</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row2_col2\" class=\"data row2 col2\" >0.219565</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row2_col3\" class=\"data row2 col3\" >0.678805</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row2_col4\" class=\"data row2 col4\" >1.88927</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6level0_row3\" class=\"row_heading level0 row3\" >3</th> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row3_col0\" class=\"data row3 col0\" >4</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row3_col1\" class=\"data row3 col1\" >0.961538</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row3_col2\" class=\"data row3 col2\" >0.104011</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row3_col3\" class=\"data row3 col3\" >-0.481165</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row3_col4\" class=\"data row3 col4\" >0.850229</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6level0_row4\" class=\"row_heading level0 row4\" >4</th> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row4_col0\" class=\"data row4 col0\" >5</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row4_col1\" class=\"data row4 col1\" >1.45342</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row4_col2\" class=\"data row4 col2\" >1.05774</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row4_col3\" class=\"data row4 col3\" >0.165562</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row4_col4\" class=\"data row4 col4\" >0.515018</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6level0_row5\" class=\"row_heading level0 row5\" >5</th> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row5_col0\" class=\"data row5 col0\" >6</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row5_col1\" class=\"data row5 col1\" >-1.33694</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row5_col2\" class=\"data row5 col2\" >0.562861</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row5_col3\" class=\"data row5 col3\" >1.39285</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row5_col4\" class=\"data row5 col4\" >-0.063328</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6level0_row6\" class=\"row_heading level0 row6\" >6</th> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row6_col0\" class=\"data row6 col0\" >7</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row6_col1\" class=\"data row6 col1\" >0.121668</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row6_col2\" class=\"data row6 col2\" >1.2076</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row6_col3\" class=\"data row6 col3\" >-0.00204021</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row6_col4\" class=\"data row6 col4\" >1.6278</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6level0_row7\" class=\"row_heading level0 row7\" >7</th> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row7_col0\" class=\"data row7 col0\" >8</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row7_col1\" class=\"data row7 col1\" >0.354493</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row7_col2\" class=\"data row7 col2\" >1.03753</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row7_col3\" class=\"data row7 col3\" >-0.385684</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row7_col4\" class=\"data row7 col4\" >0.519818</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6level0_row8\" class=\"row_heading level0 row8\" >8</th> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row8_col0\" class=\"data row8 col0\" >9</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row8_col1\" class=\"data row8 col1\" >1.68658</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row8_col2\" class=\"data row8 col2\" >-1.32596</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row8_col3\" class=\"data row8 col3\" >1.42898</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row8_col4\" class=\"data row8 col4\" >-2.08935</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6level0_row9\" class=\"row_heading level0 row9\" >9</th> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row9_col0\" class=\"data row9 col0\" >10</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row9_col1\" class=\"data row9 col1\" >-0.12982</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row9_col2\" class=\"data row9 col2\" >0.631523</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row9_col3\" class=\"data row9 col3\" >-0.586538</td> \n",
       "        <td id=\"T_e66eed54_3eb2_11e9_ba53_8c85902f5dd6row9_col4\" class=\"data row9 col4\" >0.29072</td> \n",
       "    </tr></tbody> \n",
       "</table> "
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x1a1ce490f0>"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.style.\\\n",
    "    applymap(color_negative_red).\\\n",
    "    apply(highlight_max)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Highlight row based on column value\n",
    "\n",
    "In this case, we have to return a list with as many elements as we have columns. \n",
    "\n",
    "The function below will color rows yellow where the value in the B column is greater than 1.  \n",
    "\n",
    "NOTE: The syntax `['background-color: yellow']*5` means to return a list with the shown element repeated 5 times."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [],
   "source": [
    "def highlight_greaterthan_1(s):\n",
    "    if s.B > 1.0:\n",
    "        return ['background-color: yellow']*5 # same as ['background-color: yellow','background-color: yellow','background-color: yellow','background-color: yellow','background-color: yellow']\n",
    "    else:\n",
    "        return ['background-color: white']*5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row0_col0 {\n",
       "            background-color:  yellow;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row0_col1 {\n",
       "            background-color:  yellow;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row0_col2 {\n",
       "            background-color:  yellow;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row0_col3 {\n",
       "            background-color:  yellow;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row0_col4 {\n",
       "            background-color:  yellow;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row1_col0 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row1_col1 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row1_col2 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row1_col3 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row1_col4 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row2_col0 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row2_col1 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row2_col2 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row2_col3 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row2_col4 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row3_col0 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row3_col1 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row3_col2 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row3_col3 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row3_col4 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row4_col0 {\n",
       "            background-color:  yellow;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row4_col1 {\n",
       "            background-color:  yellow;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row4_col2 {\n",
       "            background-color:  yellow;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row4_col3 {\n",
       "            background-color:  yellow;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row4_col4 {\n",
       "            background-color:  yellow;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row5_col0 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row5_col1 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row5_col2 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row5_col3 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row5_col4 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row6_col0 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row6_col1 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row6_col2 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row6_col3 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row6_col4 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row7_col0 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row7_col1 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row7_col2 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row7_col3 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row7_col4 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row8_col0 {\n",
       "            background-color:  yellow;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row8_col1 {\n",
       "            background-color:  yellow;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row8_col2 {\n",
       "            background-color:  yellow;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row8_col3 {\n",
       "            background-color:  yellow;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row8_col4 {\n",
       "            background-color:  yellow;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row9_col0 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row9_col1 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row9_col2 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row9_col3 {\n",
       "            background-color:  white;\n",
       "        }    #T_52223346_3ebb_11e9_ba53_8c85902f5dd6row9_col4 {\n",
       "            background-color:  white;\n",
       "        }</style>  \n",
       "<table id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6\" > \n",
       "<thead>    <tr> \n",
       "        <th class=\"blank level0\" ></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></thead> \n",
       "<tbody>    <tr> \n",
       "        <th id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6level0_row0\" class=\"row_heading level0 row0\" >0</th> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row0_col0\" class=\"data row0 col0\" >1</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row0_col1\" class=\"data row0 col1\" >1.32921</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row0_col2\" class=\"data row0 col2\" >nan</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row0_col3\" class=\"data row0 col3\" >-0.31628</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row0_col4\" class=\"data row0 col4\" >-0.99081</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6level0_row1\" class=\"row_heading level0 row1\" >1</th> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row1_col0\" class=\"data row1 col0\" >2</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row1_col1\" class=\"data row1 col1\" >-1.07082</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row1_col2\" class=\"data row1 col2\" >-1.43871</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row1_col3\" class=\"data row1 col3\" >0.564417</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row1_col4\" class=\"data row1 col4\" >0.295722</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6level0_row2\" class=\"row_heading level0 row2\" >2</th> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row2_col0\" class=\"data row2 col0\" >3</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row2_col1\" class=\"data row2 col1\" >-1.6264</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row2_col2\" class=\"data row2 col2\" >0.219565</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row2_col3\" class=\"data row2 col3\" >0.678805</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row2_col4\" class=\"data row2 col4\" >1.88927</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6level0_row3\" class=\"row_heading level0 row3\" >3</th> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row3_col0\" class=\"data row3 col0\" >4</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row3_col1\" class=\"data row3 col1\" >0.961538</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row3_col2\" class=\"data row3 col2\" >0.104011</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row3_col3\" class=\"data row3 col3\" >-0.481165</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row3_col4\" class=\"data row3 col4\" >0.850229</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6level0_row4\" class=\"row_heading level0 row4\" >4</th> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row4_col0\" class=\"data row4 col0\" >5</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row4_col1\" class=\"data row4 col1\" >1.45342</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row4_col2\" class=\"data row4 col2\" >1.05774</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row4_col3\" class=\"data row4 col3\" >0.165562</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row4_col4\" class=\"data row4 col4\" >0.515018</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6level0_row5\" class=\"row_heading level0 row5\" >5</th> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row5_col0\" class=\"data row5 col0\" >6</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row5_col1\" class=\"data row5 col1\" >-1.33694</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row5_col2\" class=\"data row5 col2\" >0.562861</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row5_col3\" class=\"data row5 col3\" >1.39285</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row5_col4\" class=\"data row5 col4\" >-0.063328</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6level0_row6\" class=\"row_heading level0 row6\" >6</th> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row6_col0\" class=\"data row6 col0\" >7</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row6_col1\" class=\"data row6 col1\" >0.121668</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row6_col2\" class=\"data row6 col2\" >1.2076</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row6_col3\" class=\"data row6 col3\" >-0.00204021</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row6_col4\" class=\"data row6 col4\" >1.6278</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6level0_row7\" class=\"row_heading level0 row7\" >7</th> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row7_col0\" class=\"data row7 col0\" >8</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row7_col1\" class=\"data row7 col1\" >0.354493</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row7_col2\" class=\"data row7 col2\" >1.03753</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row7_col3\" class=\"data row7 col3\" >-0.385684</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row7_col4\" class=\"data row7 col4\" >0.519818</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6level0_row8\" class=\"row_heading level0 row8\" >8</th> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row8_col0\" class=\"data row8 col0\" >9</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row8_col1\" class=\"data row8 col1\" >1.68658</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row8_col2\" class=\"data row8 col2\" >-1.32596</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row8_col3\" class=\"data row8 col3\" >1.42898</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row8_col4\" class=\"data row8 col4\" >-2.08935</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6level0_row9\" class=\"row_heading level0 row9\" >9</th> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row9_col0\" class=\"data row9 col0\" >10</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row9_col1\" class=\"data row9 col1\" >-0.12982</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row9_col2\" class=\"data row9 col2\" >0.631523</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row9_col3\" class=\"data row9 col3\" >-0.586538</td> \n",
       "        <td id=\"T_52223346_3ebb_11e9_ba53_8c85902f5dd6row9_col4\" class=\"data row9 col4\" >0.29072</td> \n",
       "    </tr></tbody> \n",
       "</table> "
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x1a1ce84668>"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.style.apply(highlight_greaterthan_1, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Applying to entire Dataframe\n",
    "\n",
    "In the case of using `apply()` for the entire table, we pass `axis=None`. Let's highlight the max value in the entire dataframe."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "def highlight_max(data, color='yellow'):\n",
    "    '''\n",
    "    highlight the maximum in a Series or DataFrame\n",
    "    '''\n",
    "    attr = 'background-color: {}'.format(color)\n",
    "    if data.ndim == 1:  # Series from .apply(axis=0) or axis=1\n",
    "        is_max = data == data.max()\n",
    "        return [attr if v else '' for v in is_max]\n",
    "    else:  # from .apply(axis=None)\n",
    "        is_max = data == data.max().max()\n",
    "        return pd.DataFrame(np.where(is_max, attr, ''),\n",
    "                            index=data.index, columns=data.columns)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "    #T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row9_col0 {\n",
       "            background-color:  darkorange;\n",
       "        }</style>  \n",
       "<table id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6\" > \n",
       "<thead>    <tr> \n",
       "        <th class=\"blank level0\" ></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></thead> \n",
       "<tbody>    <tr> \n",
       "        <th id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6level0_row0\" class=\"row_heading level0 row0\" >0</th> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row0_col0\" class=\"data row0 col0\" >1</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row0_col1\" class=\"data row0 col1\" >1.32921</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row0_col2\" class=\"data row0 col2\" >nan</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row0_col3\" class=\"data row0 col3\" >-0.31628</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row0_col4\" class=\"data row0 col4\" >-0.99081</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6level0_row1\" class=\"row_heading level0 row1\" >1</th> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row1_col0\" class=\"data row1 col0\" >2</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row1_col1\" class=\"data row1 col1\" >-1.07082</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row1_col2\" class=\"data row1 col2\" >-1.43871</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row1_col3\" class=\"data row1 col3\" >0.564417</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row1_col4\" class=\"data row1 col4\" >0.295722</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6level0_row2\" class=\"row_heading level0 row2\" >2</th> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row2_col0\" class=\"data row2 col0\" >3</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row2_col1\" class=\"data row2 col1\" >-1.6264</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row2_col2\" class=\"data row2 col2\" >0.219565</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row2_col3\" class=\"data row2 col3\" >0.678805</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row2_col4\" class=\"data row2 col4\" >1.88927</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6level0_row3\" class=\"row_heading level0 row3\" >3</th> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row3_col0\" class=\"data row3 col0\" >4</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row3_col1\" class=\"data row3 col1\" >0.961538</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row3_col2\" class=\"data row3 col2\" >0.104011</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row3_col3\" class=\"data row3 col3\" >-0.481165</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row3_col4\" class=\"data row3 col4\" >0.850229</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6level0_row4\" class=\"row_heading level0 row4\" >4</th> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row4_col0\" class=\"data row4 col0\" >5</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row4_col1\" class=\"data row4 col1\" >1.45342</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row4_col2\" class=\"data row4 col2\" >1.05774</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row4_col3\" class=\"data row4 col3\" >0.165562</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row4_col4\" class=\"data row4 col4\" >0.515018</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6level0_row5\" class=\"row_heading level0 row5\" >5</th> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row5_col0\" class=\"data row5 col0\" >6</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row5_col1\" class=\"data row5 col1\" >-1.33694</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row5_col2\" class=\"data row5 col2\" >0.562861</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row5_col3\" class=\"data row5 col3\" >1.39285</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row5_col4\" class=\"data row5 col4\" >-0.063328</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6level0_row6\" class=\"row_heading level0 row6\" >6</th> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row6_col0\" class=\"data row6 col0\" >7</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row6_col1\" class=\"data row6 col1\" >0.121668</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row6_col2\" class=\"data row6 col2\" >1.2076</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row6_col3\" class=\"data row6 col3\" >-0.00204021</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row6_col4\" class=\"data row6 col4\" >1.6278</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6level0_row7\" class=\"row_heading level0 row7\" >7</th> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row7_col0\" class=\"data row7 col0\" >8</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row7_col1\" class=\"data row7 col1\" >0.354493</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row7_col2\" class=\"data row7 col2\" >1.03753</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row7_col3\" class=\"data row7 col3\" >-0.385684</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row7_col4\" class=\"data row7 col4\" >0.519818</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6level0_row8\" class=\"row_heading level0 row8\" >8</th> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row8_col0\" class=\"data row8 col0\" >9</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row8_col1\" class=\"data row8 col1\" >1.68658</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row8_col2\" class=\"data row8 col2\" >-1.32596</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row8_col3\" class=\"data row8 col3\" >1.42898</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row8_col4\" class=\"data row8 col4\" >-2.08935</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6level0_row9\" class=\"row_heading level0 row9\" >9</th> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row9_col0\" class=\"data row9 col0\" >10</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row9_col1\" class=\"data row9 col1\" >-0.12982</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row9_col2\" class=\"data row9 col2\" >0.631523</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row9_col3\" class=\"data row9 col3\" >-0.586538</td> \n",
       "        <td id=\"T_dc8b5db2_3eb8_11e9_ba53_8c85902f5dd6row9_col4\" class=\"data row9 col4\" >0.29072</td> \n",
       "    </tr></tbody> \n",
       "</table> "
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x1a1ce84b38>"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.style.apply(highlight_max, color='darkorange', axis=None)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Built-in Styles\n",
    "\n",
    "Several situations come up often enough that Pandas has given us pre-made styles.\n",
    "\n",
    "\n",
    "**Highlight null**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "    #T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row0_col2 {\n",
       "            background-color:  red;\n",
       "        }</style>  \n",
       "<table id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6\" > \n",
       "<thead>    <tr> \n",
       "        <th class=\"blank level0\" ></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></thead> \n",
       "<tbody>    <tr> \n",
       "        <th id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6level0_row0\" class=\"row_heading level0 row0\" >0</th> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row0_col0\" class=\"data row0 col0\" >1</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row0_col1\" class=\"data row0 col1\" >1.32921</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row0_col2\" class=\"data row0 col2\" >nan</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row0_col3\" class=\"data row0 col3\" >-0.31628</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row0_col4\" class=\"data row0 col4\" >-0.99081</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6level0_row1\" class=\"row_heading level0 row1\" >1</th> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row1_col0\" class=\"data row1 col0\" >2</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row1_col1\" class=\"data row1 col1\" >-1.07082</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row1_col2\" class=\"data row1 col2\" >-1.43871</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row1_col3\" class=\"data row1 col3\" >0.564417</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row1_col4\" class=\"data row1 col4\" >0.295722</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6level0_row2\" class=\"row_heading level0 row2\" >2</th> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row2_col0\" class=\"data row2 col0\" >3</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row2_col1\" class=\"data row2 col1\" >-1.6264</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row2_col2\" class=\"data row2 col2\" >0.219565</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row2_col3\" class=\"data row2 col3\" >0.678805</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row2_col4\" class=\"data row2 col4\" >1.88927</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6level0_row3\" class=\"row_heading level0 row3\" >3</th> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row3_col0\" class=\"data row3 col0\" >4</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row3_col1\" class=\"data row3 col1\" >0.961538</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row3_col2\" class=\"data row3 col2\" >0.104011</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row3_col3\" class=\"data row3 col3\" >-0.481165</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row3_col4\" class=\"data row3 col4\" >0.850229</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6level0_row4\" class=\"row_heading level0 row4\" >4</th> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row4_col0\" class=\"data row4 col0\" >5</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row4_col1\" class=\"data row4 col1\" >1.45342</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row4_col2\" class=\"data row4 col2\" >1.05774</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row4_col3\" class=\"data row4 col3\" >0.165562</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row4_col4\" class=\"data row4 col4\" >0.515018</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6level0_row5\" class=\"row_heading level0 row5\" >5</th> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row5_col0\" class=\"data row5 col0\" >6</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row5_col1\" class=\"data row5 col1\" >-1.33694</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row5_col2\" class=\"data row5 col2\" >0.562861</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row5_col3\" class=\"data row5 col3\" >1.39285</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row5_col4\" class=\"data row5 col4\" >-0.063328</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6level0_row6\" class=\"row_heading level0 row6\" >6</th> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row6_col0\" class=\"data row6 col0\" >7</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row6_col1\" class=\"data row6 col1\" >0.121668</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row6_col2\" class=\"data row6 col2\" >1.2076</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row6_col3\" class=\"data row6 col3\" >-0.00204021</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row6_col4\" class=\"data row6 col4\" >1.6278</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6level0_row7\" class=\"row_heading level0 row7\" >7</th> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row7_col0\" class=\"data row7 col0\" >8</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row7_col1\" class=\"data row7 col1\" >0.354493</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row7_col2\" class=\"data row7 col2\" >1.03753</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row7_col3\" class=\"data row7 col3\" >-0.385684</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row7_col4\" class=\"data row7 col4\" >0.519818</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6level0_row8\" class=\"row_heading level0 row8\" >8</th> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row8_col0\" class=\"data row8 col0\" >9</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row8_col1\" class=\"data row8 col1\" >1.68658</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row8_col2\" class=\"data row8 col2\" >-1.32596</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row8_col3\" class=\"data row8 col3\" >1.42898</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row8_col4\" class=\"data row8 col4\" >-2.08935</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6level0_row9\" class=\"row_heading level0 row9\" >9</th> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row9_col0\" class=\"data row9 col0\" >10</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row9_col1\" class=\"data row9 col1\" >-0.12982</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row9_col2\" class=\"data row9 col2\" >0.631523</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row9_col3\" class=\"data row9 col3\" >-0.586538</td> \n",
       "        <td id=\"T_afb7ec66_3ebc_11e9_ba53_8c85902f5dd6row9_col4\" class=\"data row9 col4\" >0.29072</td> \n",
       "    </tr></tbody> \n",
       "</table> "
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x1a1ce586a0>"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.style.highlight_null(null_color='red')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Heatmap styling**\n",
    "\n",
    "This requires matplotlib but Seaborn looks nicer."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row0_col0 {\n",
       "            background-color:  #e5ffe5;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row0_col1 {\n",
       "            background-color:  #188d18;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row0_col2 {\n",
       "            background-color:  #e5ffe5;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row0_col3 {\n",
       "            background-color:  #c7eec7;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row0_col4 {\n",
       "            background-color:  #a6dca6;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row1_col0 {\n",
       "            background-color:  #ccf1cc;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row1_col1 {\n",
       "            background-color:  #c0eac0;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row1_col2 {\n",
       "            background-color:  #e5ffe5;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row1_col3 {\n",
       "            background-color:  #62b662;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row1_col4 {\n",
       "            background-color:  #5cb35c;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row2_col0 {\n",
       "            background-color:  #b3e3b3;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row2_col1 {\n",
       "            background-color:  #e5ffe5;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row2_col2 {\n",
       "            background-color:  #56af56;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row2_col3 {\n",
       "            background-color:  #56af56;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row2_col4 {\n",
       "            background-color:  #008000;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row3_col0 {\n",
       "            background-color:  #99d599;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row3_col1 {\n",
       "            background-color:  #329c32;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row3_col2 {\n",
       "            background-color:  #5fb55f;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row3_col3 {\n",
       "            background-color:  #daf9da;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row3_col4 {\n",
       "            background-color:  #3ba13b;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row4_col0 {\n",
       "            background-color:  #80c780;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row4_col1 {\n",
       "            background-color:  #108910;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row4_col2 {\n",
       "            background-color:  #0d870d;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row4_col3 {\n",
       "            background-color:  #90d090;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row4_col4 {\n",
       "            background-color:  #4fac4f;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row5_col0 {\n",
       "            background-color:  #66b866;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row5_col1 {\n",
       "            background-color:  #d2f4d2;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row5_col2 {\n",
       "            background-color:  #389f38;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row5_col3 {\n",
       "            background-color:  #048204;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row5_col4 {\n",
       "            background-color:  #70be70;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row6_col0 {\n",
       "            background-color:  #4daa4d;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row6_col1 {\n",
       "            background-color:  #6cbc6c;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row6_col2 {\n",
       "            background-color:  #008000;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row6_col3 {\n",
       "            background-color:  #a3daa3;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row6_col4 {\n",
       "            background-color:  #0e880e;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row7_col0 {\n",
       "            background-color:  #329c32;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row7_col1 {\n",
       "            background-color:  #5cb35c;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row7_col2 {\n",
       "            background-color:  #0e880e;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row7_col3 {\n",
       "            background-color:  #cff3cf;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row7_col4 {\n",
       "            background-color:  #4fac4f;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row8_col0 {\n",
       "            background-color:  #198e19;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row8_col1 {\n",
       "            background-color:  #008000;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row8_col2 {\n",
       "            background-color:  #dcfadc;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row8_col3 {\n",
       "            background-color:  #008000;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row8_col4 {\n",
       "            background-color:  #e5ffe5;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row9_col0 {\n",
       "            background-color:  #008000;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row9_col1 {\n",
       "            background-color:  #7ec67e;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row9_col2 {\n",
       "            background-color:  #319b31;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row9_col3 {\n",
       "            background-color:  #e5ffe5;\n",
       "        }    #T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row9_col4 {\n",
       "            background-color:  #5cb35c;\n",
       "        }</style>  \n",
       "<table id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6\" > \n",
       "<thead>    <tr> \n",
       "        <th class=\"blank level0\" ></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></thead> \n",
       "<tbody>    <tr> \n",
       "        <th id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6level0_row0\" class=\"row_heading level0 row0\" >0</th> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row0_col0\" class=\"data row0 col0\" >1</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row0_col1\" class=\"data row0 col1\" >1.32921</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row0_col2\" class=\"data row0 col2\" >nan</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row0_col3\" class=\"data row0 col3\" >-0.31628</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row0_col4\" class=\"data row0 col4\" >-0.99081</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6level0_row1\" class=\"row_heading level0 row1\" >1</th> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row1_col0\" class=\"data row1 col0\" >2</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row1_col1\" class=\"data row1 col1\" >-1.07082</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row1_col2\" class=\"data row1 col2\" >-1.43871</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row1_col3\" class=\"data row1 col3\" >0.564417</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row1_col4\" class=\"data row1 col4\" >0.295722</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6level0_row2\" class=\"row_heading level0 row2\" >2</th> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row2_col0\" class=\"data row2 col0\" >3</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row2_col1\" class=\"data row2 col1\" >-1.6264</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row2_col2\" class=\"data row2 col2\" >0.219565</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row2_col3\" class=\"data row2 col3\" >0.678805</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row2_col4\" class=\"data row2 col4\" >1.88927</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6level0_row3\" class=\"row_heading level0 row3\" >3</th> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row3_col0\" class=\"data row3 col0\" >4</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row3_col1\" class=\"data row3 col1\" >0.961538</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row3_col2\" class=\"data row3 col2\" >0.104011</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row3_col3\" class=\"data row3 col3\" >-0.481165</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row3_col4\" class=\"data row3 col4\" >0.850229</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6level0_row4\" class=\"row_heading level0 row4\" >4</th> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row4_col0\" class=\"data row4 col0\" >5</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row4_col1\" class=\"data row4 col1\" >1.45342</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row4_col2\" class=\"data row4 col2\" >1.05774</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row4_col3\" class=\"data row4 col3\" >0.165562</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row4_col4\" class=\"data row4 col4\" >0.515018</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6level0_row5\" class=\"row_heading level0 row5\" >5</th> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row5_col0\" class=\"data row5 col0\" >6</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row5_col1\" class=\"data row5 col1\" >-1.33694</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row5_col2\" class=\"data row5 col2\" >0.562861</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row5_col3\" class=\"data row5 col3\" >1.39285</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row5_col4\" class=\"data row5 col4\" >-0.063328</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6level0_row6\" class=\"row_heading level0 row6\" >6</th> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row6_col0\" class=\"data row6 col0\" >7</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row6_col1\" class=\"data row6 col1\" >0.121668</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row6_col2\" class=\"data row6 col2\" >1.2076</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row6_col3\" class=\"data row6 col3\" >-0.00204021</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row6_col4\" class=\"data row6 col4\" >1.6278</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6level0_row7\" class=\"row_heading level0 row7\" >7</th> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row7_col0\" class=\"data row7 col0\" >8</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row7_col1\" class=\"data row7 col1\" >0.354493</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row7_col2\" class=\"data row7 col2\" >1.03753</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row7_col3\" class=\"data row7 col3\" >-0.385684</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row7_col4\" class=\"data row7 col4\" >0.519818</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6level0_row8\" class=\"row_heading level0 row8\" >8</th> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row8_col0\" class=\"data row8 col0\" >9</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row8_col1\" class=\"data row8 col1\" >1.68658</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row8_col2\" class=\"data row8 col2\" >-1.32596</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row8_col3\" class=\"data row8 col3\" >1.42898</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row8_col4\" class=\"data row8 col4\" >-2.08935</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6level0_row9\" class=\"row_heading level0 row9\" >9</th> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row9_col0\" class=\"data row9 col0\" >10</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row9_col1\" class=\"data row9 col1\" >-0.12982</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row9_col2\" class=\"data row9 col2\" >0.631523</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row9_col3\" class=\"data row9 col3\" >-0.586538</td> \n",
       "        <td id=\"T_bc4e943e_3ebc_11e9_ba53_8c85902f5dd6row9_col4\" class=\"data row9 col4\" >0.29072</td> \n",
       "    </tr></tbody> \n",
       "</table> "
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x1a1ce84ac8>"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cm = sns.light_palette(\"green\", as_cmap=True)\n",
    "\n",
    "s = df.style.background_gradient(cmap=cm)\n",
    "s"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Many other possibilities are available. Check out Pandas' User Documentation for more (https://pandas.pydata.org/pandas-docs/stable/user_guide/style.html)"
   ]
  },
  {
   "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.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}