Pandas-Styling2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "3089013d",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "np.random.seed(24)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "18824ab2",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Original array:\n",
      "      A         B         C         D         E\n",
      "0   1.0  1.329212       NaN -0.316280 -0.990810\n",
      "1   2.0 -1.070816 -1.438713  0.564417  0.295722\n",
      "2   3.0 -1.626404  0.219565  0.678805  1.889273\n",
      "3   4.0  0.961538  0.104011       NaN  0.850229\n",
      "4   5.0       NaN  1.057737  0.165562  0.515018\n",
      "5   6.0 -1.336936  0.562861  1.392855 -0.063328\n",
      "6   7.0  0.121668  1.207603 -0.002040  1.627796\n",
      "7   8.0  0.354493  1.037528 -0.385684  0.519818\n",
      "8   9.0  1.686583 -1.325963  1.428984 -2.089354\n",
      "9  10.0 -0.129820  0.631523 -0.586538       NaN\n",
      "\n",
      "Background:black - fontcolor:yelow\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_aede4_row0_col0, #T_aede4_row0_col1, #T_aede4_row0_col2, #T_aede4_row0_col3, #T_aede4_row0_col4, #T_aede4_row1_col0, #T_aede4_row1_col1, #T_aede4_row1_col2, #T_aede4_row1_col3, #T_aede4_row1_col4, #T_aede4_row2_col0, #T_aede4_row2_col1, #T_aede4_row2_col2, #T_aede4_row2_col3, #T_aede4_row2_col4, #T_aede4_row3_col0, #T_aede4_row3_col1, #T_aede4_row3_col2, #T_aede4_row3_col3, #T_aede4_row3_col4, #T_aede4_row4_col0, #T_aede4_row4_col1, #T_aede4_row4_col2, #T_aede4_row4_col3, #T_aede4_row4_col4, #T_aede4_row5_col0, #T_aede4_row5_col1, #T_aede4_row5_col2, #T_aede4_row5_col3, #T_aede4_row5_col4, #T_aede4_row6_col0, #T_aede4_row6_col1, #T_aede4_row6_col2, #T_aede4_row6_col3, #T_aede4_row6_col4, #T_aede4_row7_col0, #T_aede4_row7_col1, #T_aede4_row7_col2, #T_aede4_row7_col3, #T_aede4_row7_col4, #T_aede4_row8_col0, #T_aede4_row8_col1, #T_aede4_row8_col2, #T_aede4_row8_col3, #T_aede4_row8_col4, #T_aede4_row9_col0, #T_aede4_row9_col1, #T_aede4_row9_col2, #T_aede4_row9_col3, #T_aede4_row9_col4 {\n",
       "  background-color: black;\n",
       "  color: yellow;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_aede4_\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th class=\"col_heading level0 col0\" >A</th>\n",
       "      <th class=\"col_heading level0 col1\" >B</th>\n",
       "      <th class=\"col_heading level0 col2\" >C</th>\n",
       "      <th class=\"col_heading level0 col3\" >D</th>\n",
       "      <th class=\"col_heading level0 col4\" >E</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_aede4_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "      <td id=\"T_aede4_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
       "      <td id=\"T_aede4_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
       "      <td id=\"T_aede4_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
       "      <td id=\"T_aede4_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
       "      <td id=\"T_aede4_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_aede4_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "      <td id=\"T_aede4_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
       "      <td id=\"T_aede4_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
       "      <td id=\"T_aede4_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
       "      <td id=\"T_aede4_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
       "      <td id=\"T_aede4_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_aede4_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "      <td id=\"T_aede4_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
       "      <td id=\"T_aede4_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
       "      <td id=\"T_aede4_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
       "      <td id=\"T_aede4_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
       "      <td id=\"T_aede4_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_aede4_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "      <td id=\"T_aede4_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
       "      <td id=\"T_aede4_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
       "      <td id=\"T_aede4_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
       "      <td id=\"T_aede4_row3_col3\" class=\"data row3 col3\" >nan</td>\n",
       "      <td id=\"T_aede4_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_aede4_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "      <td id=\"T_aede4_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
       "      <td id=\"T_aede4_row4_col1\" class=\"data row4 col1\" >nan</td>\n",
       "      <td id=\"T_aede4_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
       "      <td id=\"T_aede4_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
       "      <td id=\"T_aede4_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_aede4_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "      <td id=\"T_aede4_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
       "      <td id=\"T_aede4_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
       "      <td id=\"T_aede4_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
       "      <td id=\"T_aede4_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
       "      <td id=\"T_aede4_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_aede4_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "      <td id=\"T_aede4_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
       "      <td id=\"T_aede4_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
       "      <td id=\"T_aede4_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
       "      <td id=\"T_aede4_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
       "      <td id=\"T_aede4_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_aede4_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "      <td id=\"T_aede4_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
       "      <td id=\"T_aede4_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
       "      <td id=\"T_aede4_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
       "      <td id=\"T_aede4_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
       "      <td id=\"T_aede4_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_aede4_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "      <td id=\"T_aede4_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
       "      <td id=\"T_aede4_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
       "      <td id=\"T_aede4_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
       "      <td id=\"T_aede4_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
       "      <td id=\"T_aede4_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_aede4_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "      <td id=\"T_aede4_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
       "      <td id=\"T_aede4_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
       "      <td id=\"T_aede4_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
       "      <td id=\"T_aede4_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
       "      <td id=\"T_aede4_row9_col4\" class=\"data row9 col4\" >nan</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x1b1a46564f0>"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Q6\n",
    "df = pd.DataFrame({'A': np.linspace(1,10,10)})\n",
    "df = pd.concat([df, pd.DataFrame(np.random.randn(10, 4), columns=list('BCDE'))], axis=1)\n",
    "\n",
    "df.iloc[0, 2] = np.nan\n",
    "df.iloc[3, 3] = np.nan\n",
    "df.iloc[4, 1] = np.nan\n",
    "df.iloc[9, 4] = np.nan\n",
    "print(\"Original array:\")\n",
    "print(df)\n",
    "print(\"\\nBackground:black - fontcolor:yelow\")\n",
    "df.style.set_properties(**{'background-color': 'black',\n",
    "                           'color': 'yellow'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "8d95aacf",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Original array:\n",
      "      A         B         C         D         E\n",
      "0   1.0  1.264103       NaN -1.970288  0.803906\n",
      "1   2.0  1.030550  0.118098 -0.021853  0.046841\n",
      "2   3.0 -1.628753 -0.392361  1.700973  1.061330\n",
      "3   4.0  0.695804 -0.435989       NaN  0.602135\n",
      "4   5.0       NaN  0.036767 -0.538963  0.499178\n",
      "5   6.0 -0.711952 -0.237001  0.857119 -1.882352\n",
      "6   7.0  0.420705 -1.069175 -2.576859 -1.224923\n",
      "7   8.0 -1.156752  0.931304  0.984257  2.226159\n",
      "8   9.0 -0.418504 -0.333778 -0.147427  1.561308\n",
      "9  10.0  0.684710  0.029462 -0.852475       NaN\n",
      "\n",
      "Highlight specific columns:\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_fd578_row0_col1, #T_fd578_row0_col2, #T_fd578_row1_col1, #T_fd578_row1_col2, #T_fd578_row2_col1, #T_fd578_row2_col2, #T_fd578_row3_col1, #T_fd578_row3_col2, #T_fd578_row4_col1, #T_fd578_row4_col2, #T_fd578_row5_col1, #T_fd578_row5_col2, #T_fd578_row6_col1, #T_fd578_row6_col2, #T_fd578_row7_col1, #T_fd578_row7_col2, #T_fd578_row8_col1, #T_fd578_row8_col2, #T_fd578_row9_col1, #T_fd578_row9_col2 {\n",
       "  background-color: grey;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_fd578_\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th class=\"col_heading level0 col0\" >A</th>\n",
       "      <th class=\"col_heading level0 col1\" >B</th>\n",
       "      <th class=\"col_heading level0 col2\" >C</th>\n",
       "      <th class=\"col_heading level0 col3\" >D</th>\n",
       "      <th class=\"col_heading level0 col4\" >E</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_fd578_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "      <td id=\"T_fd578_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
       "      <td id=\"T_fd578_row0_col1\" class=\"data row0 col1\" >1.264103</td>\n",
       "      <td id=\"T_fd578_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
       "      <td id=\"T_fd578_row0_col3\" class=\"data row0 col3\" >-1.970288</td>\n",
       "      <td id=\"T_fd578_row0_col4\" class=\"data row0 col4\" >0.803906</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_fd578_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "      <td id=\"T_fd578_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
       "      <td id=\"T_fd578_row1_col1\" class=\"data row1 col1\" >1.030550</td>\n",
       "      <td id=\"T_fd578_row1_col2\" class=\"data row1 col2\" >0.118098</td>\n",
       "      <td id=\"T_fd578_row1_col3\" class=\"data row1 col3\" >-0.021853</td>\n",
       "      <td id=\"T_fd578_row1_col4\" class=\"data row1 col4\" >0.046841</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_fd578_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "      <td id=\"T_fd578_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
       "      <td id=\"T_fd578_row2_col1\" class=\"data row2 col1\" >-1.628753</td>\n",
       "      <td id=\"T_fd578_row2_col2\" class=\"data row2 col2\" >-0.392361</td>\n",
       "      <td id=\"T_fd578_row2_col3\" class=\"data row2 col3\" >1.700973</td>\n",
       "      <td id=\"T_fd578_row2_col4\" class=\"data row2 col4\" >1.061330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_fd578_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "      <td id=\"T_fd578_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
       "      <td id=\"T_fd578_row3_col1\" class=\"data row3 col1\" >0.695804</td>\n",
       "      <td id=\"T_fd578_row3_col2\" class=\"data row3 col2\" >-0.435989</td>\n",
       "      <td id=\"T_fd578_row3_col3\" class=\"data row3 col3\" >nan</td>\n",
       "      <td id=\"T_fd578_row3_col4\" class=\"data row3 col4\" >0.602135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_fd578_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "      <td id=\"T_fd578_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
       "      <td id=\"T_fd578_row4_col1\" class=\"data row4 col1\" >nan</td>\n",
       "      <td id=\"T_fd578_row4_col2\" class=\"data row4 col2\" >0.036767</td>\n",
       "      <td id=\"T_fd578_row4_col3\" class=\"data row4 col3\" >-0.538963</td>\n",
       "      <td id=\"T_fd578_row4_col4\" class=\"data row4 col4\" >0.499178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_fd578_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "      <td id=\"T_fd578_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
       "      <td id=\"T_fd578_row5_col1\" class=\"data row5 col1\" >-0.711952</td>\n",
       "      <td id=\"T_fd578_row5_col2\" class=\"data row5 col2\" >-0.237001</td>\n",
       "      <td id=\"T_fd578_row5_col3\" class=\"data row5 col3\" >0.857119</td>\n",
       "      <td id=\"T_fd578_row5_col4\" class=\"data row5 col4\" >-1.882352</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_fd578_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "      <td id=\"T_fd578_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
       "      <td id=\"T_fd578_row6_col1\" class=\"data row6 col1\" >0.420705</td>\n",
       "      <td id=\"T_fd578_row6_col2\" class=\"data row6 col2\" >-1.069175</td>\n",
       "      <td id=\"T_fd578_row6_col3\" class=\"data row6 col3\" >-2.576859</td>\n",
       "      <td id=\"T_fd578_row6_col4\" class=\"data row6 col4\" >-1.224923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_fd578_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "      <td id=\"T_fd578_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
       "      <td id=\"T_fd578_row7_col1\" class=\"data row7 col1\" >-1.156752</td>\n",
       "      <td id=\"T_fd578_row7_col2\" class=\"data row7 col2\" >0.931304</td>\n",
       "      <td id=\"T_fd578_row7_col3\" class=\"data row7 col3\" >0.984257</td>\n",
       "      <td id=\"T_fd578_row7_col4\" class=\"data row7 col4\" >2.226159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_fd578_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "      <td id=\"T_fd578_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
       "      <td id=\"T_fd578_row8_col1\" class=\"data row8 col1\" >-0.418504</td>\n",
       "      <td id=\"T_fd578_row8_col2\" class=\"data row8 col2\" >-0.333778</td>\n",
       "      <td id=\"T_fd578_row8_col3\" class=\"data row8 col3\" >-0.147427</td>\n",
       "      <td id=\"T_fd578_row8_col4\" class=\"data row8 col4\" >1.561308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_fd578_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "      <td id=\"T_fd578_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
       "      <td id=\"T_fd578_row9_col1\" class=\"data row9 col1\" >0.684710</td>\n",
       "      <td id=\"T_fd578_row9_col2\" class=\"data row9 col2\" >0.029462</td>\n",
       "      <td id=\"T_fd578_row9_col3\" class=\"data row9 col3\" >-0.852475</td>\n",
       "      <td id=\"T_fd578_row9_col4\" class=\"data row9 col4\" >nan</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x1b1a2368c40>"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Q7\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.iloc[3, 3] = np.nan\n",
    "df.iloc[4, 1] = np.nan\n",
    "df.iloc[9, 4] = np.nan\n",
    "print(\"Original array:\")\n",
    "print(df)\n",
    "def highlight_cols(s):\n",
    "    color = 'grey'\n",
    "    return 'background-color: %s' % color\n",
    "print(\"\\nHighlight specific columns:\")\n",
    "df.style.applymap(highlight_cols, subset=pd.IndexSlice[:, ['B', 'C']])"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}