Resaltar_filas,_columnas_y_celdas_del_DataFrame.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 5,
  "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.8.3"
    },
    "colab": {
      "name": "Resaltar filas, columnas y celdas del DataFrame.ipynb",
      "provenance": [],
      "include_colab_link": true
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/Naren8520/Python/blob/main/Resaltar_filas%2C_columnas_y_celdas_del_DataFrame.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "hungarian-alexandria"
      },
      "source": [
        "Nombre: Naren Castellon\n",
        "\n",
        "Fecha: 04/14/2021\n",
        "\n",
        "# **Resaltar filas, columnas y celdas del DataFrame**\n",
        "\n",
        "Muchas veces hemos querido resaltar las filas, celdas y columnas que contiene algún tipo de dato para un análisis de datos en específico. Deseamos saber que celdas contienen el valor máximo en una fila o resaltar todas las `NaN` en mis datos, Pandas tiene un característica que aún está en desarrollo según la documentación de Pandas, de la cual me gustaría compartir con usted, quizás para algunos se de mucha importancia.\n",
        "\n",
        "Se puede aplicar en forma condicional, el estilo visual de un DataFrame en función de los datos que contiene, mediante el uso de la función `DataFrame.style`. Esta es una función que devueleve un objeto `Styler`, que tiene métodos muy útiles para mostrar y formatear DataFrame.\n",
        "\n",
        "El estilo se logra mediante `CSS`. Escribrimos \"funciones de estilo\" que toman escalares, DataFrame o Series, y devuelve como DataFrame indexados o series con pares CSS \"atributo:valor\" para los valores. Estas funciones pueden ir manera incremental al `Styler` que recopila muchos estilos antes de renderizar."
      ],
      "id": "hungarian-alexandria"
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "technological-torture"
      },
      "source": [
        "Iniciaremos con el siguiente ejemplo, en donde \n",
        "\n",
        "##  **Resaltaremos todas las filas en amarillo donde el valor de la columna B es mayor que 1**"
      ],
      "id": "technological-torture"
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "distinct-bhutan",
        "outputId": "c3dd9073-5e03-4617-f598-33d29492f6a4"
      },
      "source": [
        "import pandas as pd\n",
        "import numpy as np\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'))],axis=1)\n",
        "df.iloc[0, 2] = np.nan\n",
        "\n",
        "def highlight_greaterthan(s,column):\n",
        "    is_max = pd.Series(data=False, index=s.index)\n",
        "    is_max[column] = s.loc[column] >= 1\n",
        "    return ['background-color: red' if is_max.any() else '' for v in is_max]\n",
        "\n",
        "def highlight_greaterthan_1(s):\n",
        "    if s.B > 1.0:\n",
        "        return ['background-color: yellow']*5\n",
        "    else:\n",
        "        return ['background-color: white']*5\n",
        "    \n",
        "df.style.apply(highlight_greaterthan_1, axis=1)"
      ],
      "id": "distinct-bhutan",
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<style  type=\"text/css\" >\n",
              "#T_d9d07_row0_col0,#T_d9d07_row0_col1,#T_d9d07_row0_col2,#T_d9d07_row0_col3,#T_d9d07_row0_col4,#T_d9d07_row4_col0,#T_d9d07_row4_col1,#T_d9d07_row4_col2,#T_d9d07_row4_col3,#T_d9d07_row4_col4,#T_d9d07_row8_col0,#T_d9d07_row8_col1,#T_d9d07_row8_col2,#T_d9d07_row8_col3,#T_d9d07_row8_col4{\n",
              "            background-color:  yellow;\n",
              "        }#T_d9d07_row1_col0,#T_d9d07_row1_col1,#T_d9d07_row1_col2,#T_d9d07_row1_col3,#T_d9d07_row1_col4,#T_d9d07_row2_col0,#T_d9d07_row2_col1,#T_d9d07_row2_col2,#T_d9d07_row2_col3,#T_d9d07_row2_col4,#T_d9d07_row3_col0,#T_d9d07_row3_col1,#T_d9d07_row3_col2,#T_d9d07_row3_col3,#T_d9d07_row3_col4,#T_d9d07_row5_col0,#T_d9d07_row5_col1,#T_d9d07_row5_col2,#T_d9d07_row5_col3,#T_d9d07_row5_col4,#T_d9d07_row6_col0,#T_d9d07_row6_col1,#T_d9d07_row6_col2,#T_d9d07_row6_col3,#T_d9d07_row6_col4,#T_d9d07_row7_col0,#T_d9d07_row7_col1,#T_d9d07_row7_col2,#T_d9d07_row7_col3,#T_d9d07_row7_col4,#T_d9d07_row9_col0,#T_d9d07_row9_col1,#T_d9d07_row9_col2,#T_d9d07_row9_col3,#T_d9d07_row9_col4{\n",
              "            background-color:  white;\n",
              "        }</style><table id=\"T_d9d07_\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >A</th>        <th class=\"col_heading level0 col1\" >B</th>        <th class=\"col_heading level0 col2\" >C</th>        <th class=\"col_heading level0 col3\" >D</th>        <th class=\"col_heading level0 col4\" >E</th>    </tr></thead><tbody>\n",
              "                <tr>\n",
              "                        <th id=\"T_d9d07_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
              "                        <td id=\"T_d9d07_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
              "                        <td id=\"T_d9d07_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
              "                        <td id=\"T_d9d07_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
              "                        <td id=\"T_d9d07_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
              "                        <td id=\"T_d9d07_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_d9d07_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
              "                        <td id=\"T_d9d07_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
              "                        <td id=\"T_d9d07_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
              "                        <td id=\"T_d9d07_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
              "                        <td id=\"T_d9d07_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
              "                        <td id=\"T_d9d07_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_d9d07_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
              "                        <td id=\"T_d9d07_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
              "                        <td id=\"T_d9d07_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
              "                        <td id=\"T_d9d07_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
              "                        <td id=\"T_d9d07_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
              "                        <td id=\"T_d9d07_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_d9d07_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
              "                        <td id=\"T_d9d07_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
              "                        <td id=\"T_d9d07_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
              "                        <td id=\"T_d9d07_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
              "                        <td id=\"T_d9d07_row3_col3\" class=\"data row3 col3\" >-0.481165</td>\n",
              "                        <td id=\"T_d9d07_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_d9d07_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
              "                        <td id=\"T_d9d07_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
              "                        <td id=\"T_d9d07_row4_col1\" class=\"data row4 col1\" >1.453425</td>\n",
              "                        <td id=\"T_d9d07_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
              "                        <td id=\"T_d9d07_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
              "                        <td id=\"T_d9d07_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_d9d07_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
              "                        <td id=\"T_d9d07_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
              "                        <td id=\"T_d9d07_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
              "                        <td id=\"T_d9d07_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
              "                        <td id=\"T_d9d07_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
              "                        <td id=\"T_d9d07_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_d9d07_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
              "                        <td id=\"T_d9d07_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
              "                        <td id=\"T_d9d07_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
              "                        <td id=\"T_d9d07_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
              "                        <td id=\"T_d9d07_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
              "                        <td id=\"T_d9d07_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_d9d07_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
              "                        <td id=\"T_d9d07_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
              "                        <td id=\"T_d9d07_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
              "                        <td id=\"T_d9d07_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
              "                        <td id=\"T_d9d07_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
              "                        <td id=\"T_d9d07_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_d9d07_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
              "                        <td id=\"T_d9d07_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
              "                        <td id=\"T_d9d07_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
              "                        <td id=\"T_d9d07_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
              "                        <td id=\"T_d9d07_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
              "                        <td id=\"T_d9d07_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_d9d07_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
              "                        <td id=\"T_d9d07_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
              "                        <td id=\"T_d9d07_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
              "                        <td id=\"T_d9d07_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
              "                        <td id=\"T_d9d07_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
              "                        <td id=\"T_d9d07_row9_col4\" class=\"data row9 col4\" >0.290720</td>\n",
              "            </tr>\n",
              "    </tbody></table>"
            ],
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x27a76ada820>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "expensive-donor"
      },
      "source": [
        "## **Codifiquemos con color el texto que tenga valores inferiores a cero en una fila**"
      ],
      "id": "expensive-donor"
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "comparable-manor",
        "outputId": "dd45e423-eef8-442e-97a1-6f15355880e6"
      },
      "source": [
        "def color_negative_red(val):\n",
        "    color = 'red' if val < 0 else 'black'\n",
        "    return 'color: %s' % color\n",
        "\n",
        "df.style.applymap(color_negative_red)"
      ],
      "id": "comparable-manor",
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<style  type=\"text/css\" >\n",
              "#T_7f7dc_row0_col0,#T_7f7dc_row0_col1,#T_7f7dc_row0_col2,#T_7f7dc_row1_col0,#T_7f7dc_row1_col3,#T_7f7dc_row1_col4,#T_7f7dc_row2_col0,#T_7f7dc_row2_col2,#T_7f7dc_row2_col3,#T_7f7dc_row2_col4,#T_7f7dc_row3_col0,#T_7f7dc_row3_col1,#T_7f7dc_row3_col2,#T_7f7dc_row3_col4,#T_7f7dc_row4_col0,#T_7f7dc_row4_col1,#T_7f7dc_row4_col2,#T_7f7dc_row4_col3,#T_7f7dc_row4_col4,#T_7f7dc_row5_col0,#T_7f7dc_row5_col2,#T_7f7dc_row5_col3,#T_7f7dc_row6_col0,#T_7f7dc_row6_col1,#T_7f7dc_row6_col2,#T_7f7dc_row6_col4,#T_7f7dc_row7_col0,#T_7f7dc_row7_col1,#T_7f7dc_row7_col2,#T_7f7dc_row7_col4,#T_7f7dc_row8_col0,#T_7f7dc_row8_col1,#T_7f7dc_row8_col3,#T_7f7dc_row9_col0,#T_7f7dc_row9_col2,#T_7f7dc_row9_col4{\n",
              "            color:  black;\n",
              "        }#T_7f7dc_row0_col3,#T_7f7dc_row0_col4,#T_7f7dc_row1_col1,#T_7f7dc_row1_col2,#T_7f7dc_row2_col1,#T_7f7dc_row3_col3,#T_7f7dc_row5_col1,#T_7f7dc_row5_col4,#T_7f7dc_row6_col3,#T_7f7dc_row7_col3,#T_7f7dc_row8_col2,#T_7f7dc_row8_col4,#T_7f7dc_row9_col1,#T_7f7dc_row9_col3{\n",
              "            color:  red;\n",
              "        }</style><table id=\"T_7f7dc_\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >A</th>        <th class=\"col_heading level0 col1\" >B</th>        <th class=\"col_heading level0 col2\" >C</th>        <th class=\"col_heading level0 col3\" >D</th>        <th class=\"col_heading level0 col4\" >E</th>    </tr></thead><tbody>\n",
              "                <tr>\n",
              "                        <th id=\"T_7f7dc_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
              "                        <td id=\"T_7f7dc_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
              "                        <td id=\"T_7f7dc_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
              "                        <td id=\"T_7f7dc_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
              "                        <td id=\"T_7f7dc_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
              "                        <td id=\"T_7f7dc_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_7f7dc_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
              "                        <td id=\"T_7f7dc_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
              "                        <td id=\"T_7f7dc_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
              "                        <td id=\"T_7f7dc_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
              "                        <td id=\"T_7f7dc_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
              "                        <td id=\"T_7f7dc_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_7f7dc_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
              "                        <td id=\"T_7f7dc_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
              "                        <td id=\"T_7f7dc_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
              "                        <td id=\"T_7f7dc_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
              "                        <td id=\"T_7f7dc_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
              "                        <td id=\"T_7f7dc_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_7f7dc_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
              "                        <td id=\"T_7f7dc_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
              "                        <td id=\"T_7f7dc_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
              "                        <td id=\"T_7f7dc_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
              "                        <td id=\"T_7f7dc_row3_col3\" class=\"data row3 col3\" >-0.481165</td>\n",
              "                        <td id=\"T_7f7dc_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_7f7dc_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
              "                        <td id=\"T_7f7dc_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
              "                        <td id=\"T_7f7dc_row4_col1\" class=\"data row4 col1\" >1.453425</td>\n",
              "                        <td id=\"T_7f7dc_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
              "                        <td id=\"T_7f7dc_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
              "                        <td id=\"T_7f7dc_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_7f7dc_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
              "                        <td id=\"T_7f7dc_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
              "                        <td id=\"T_7f7dc_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
              "                        <td id=\"T_7f7dc_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
              "                        <td id=\"T_7f7dc_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
              "                        <td id=\"T_7f7dc_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_7f7dc_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
              "                        <td id=\"T_7f7dc_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
              "                        <td id=\"T_7f7dc_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
              "                        <td id=\"T_7f7dc_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
              "                        <td id=\"T_7f7dc_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
              "                        <td id=\"T_7f7dc_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_7f7dc_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
              "                        <td id=\"T_7f7dc_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
              "                        <td id=\"T_7f7dc_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
              "                        <td id=\"T_7f7dc_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
              "                        <td id=\"T_7f7dc_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
              "                        <td id=\"T_7f7dc_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_7f7dc_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
              "                        <td id=\"T_7f7dc_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
              "                        <td id=\"T_7f7dc_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
              "                        <td id=\"T_7f7dc_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
              "                        <td id=\"T_7f7dc_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
              "                        <td id=\"T_7f7dc_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_7f7dc_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
              "                        <td id=\"T_7f7dc_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
              "                        <td id=\"T_7f7dc_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
              "                        <td id=\"T_7f7dc_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
              "                        <td id=\"T_7f7dc_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
              "                        <td id=\"T_7f7dc_row9_col4\" class=\"data row9 col4\" >0.290720</td>\n",
              "            </tr>\n",
              "    </tbody></table>"
            ],
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x27a666b1250>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "disabled-edwards"
      },
      "source": [
        "## **Resaltemos algunos valores o celdas en específicos**\n",
        "\n",
        "En este caso ya no podemos usar la función `.applymap` que operaba con elementos. En su lugar, pasaremos a `.apply` que funciona en columna (o filas usando palabra clave del eje)."
      ],
      "id": "disabled-edwards"
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "typical-stuart",
        "outputId": "52ba508d-f0f8-45f1-92c6-3dff5c4b8ff2"
      },
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n",
        "\n",
        "def highlight_max(s):\n",
        "    is_max = s == s.max()\n",
        "    return ['background-color: pink' if v else '' for v in is_max]\n",
        "\n",
        "df.style.apply(highlight_max, axis=0)"
      ],
      "id": "typical-stuart",
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<style  type=\"text/css\" >\n",
              "#T_9b6b6_row2_col4,#T_9b6b6_row6_col2,#T_9b6b6_row8_col1,#T_9b6b6_row8_col3,#T_9b6b6_row9_col0{\n",
              "            background-color:  pink;\n",
              "        }</style><table id=\"T_9b6b6_\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >A</th>        <th class=\"col_heading level0 col1\" >B</th>        <th class=\"col_heading level0 col2\" >C</th>        <th class=\"col_heading level0 col3\" >D</th>        <th class=\"col_heading level0 col4\" >E</th>    </tr></thead><tbody>\n",
              "                <tr>\n",
              "                        <th id=\"T_9b6b6_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
              "                        <td id=\"T_9b6b6_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
              "                        <td id=\"T_9b6b6_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
              "                        <td id=\"T_9b6b6_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
              "                        <td id=\"T_9b6b6_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
              "                        <td id=\"T_9b6b6_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_9b6b6_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
              "                        <td id=\"T_9b6b6_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
              "                        <td id=\"T_9b6b6_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
              "                        <td id=\"T_9b6b6_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
              "                        <td id=\"T_9b6b6_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
              "                        <td id=\"T_9b6b6_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_9b6b6_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
              "                        <td id=\"T_9b6b6_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
              "                        <td id=\"T_9b6b6_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
              "                        <td id=\"T_9b6b6_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
              "                        <td id=\"T_9b6b6_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
              "                        <td id=\"T_9b6b6_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_9b6b6_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
              "                        <td id=\"T_9b6b6_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
              "                        <td id=\"T_9b6b6_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
              "                        <td id=\"T_9b6b6_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
              "                        <td id=\"T_9b6b6_row3_col3\" class=\"data row3 col3\" >-0.481165</td>\n",
              "                        <td id=\"T_9b6b6_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_9b6b6_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
              "                        <td id=\"T_9b6b6_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
              "                        <td id=\"T_9b6b6_row4_col1\" class=\"data row4 col1\" >1.453425</td>\n",
              "                        <td id=\"T_9b6b6_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
              "                        <td id=\"T_9b6b6_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
              "                        <td id=\"T_9b6b6_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_9b6b6_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
              "                        <td id=\"T_9b6b6_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
              "                        <td id=\"T_9b6b6_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
              "                        <td id=\"T_9b6b6_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
              "                        <td id=\"T_9b6b6_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
              "                        <td id=\"T_9b6b6_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_9b6b6_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
              "                        <td id=\"T_9b6b6_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
              "                        <td id=\"T_9b6b6_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
              "                        <td id=\"T_9b6b6_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
              "                        <td id=\"T_9b6b6_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
              "                        <td id=\"T_9b6b6_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_9b6b6_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
              "                        <td id=\"T_9b6b6_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
              "                        <td id=\"T_9b6b6_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
              "                        <td id=\"T_9b6b6_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
              "                        <td id=\"T_9b6b6_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
              "                        <td id=\"T_9b6b6_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_9b6b6_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
              "                        <td id=\"T_9b6b6_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
              "                        <td id=\"T_9b6b6_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
              "                        <td id=\"T_9b6b6_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
              "                        <td id=\"T_9b6b6_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
              "                        <td id=\"T_9b6b6_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_9b6b6_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
              "                        <td id=\"T_9b6b6_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
              "                        <td id=\"T_9b6b6_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
              "                        <td id=\"T_9b6b6_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
              "                        <td id=\"T_9b6b6_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
              "                        <td id=\"T_9b6b6_row9_col4\" class=\"data row9 col4\" >0.290720</td>\n",
              "            </tr>\n",
              "    </tbody></table>"
            ],
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x27a7d68e700>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 23
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "intimate-table"
      },
      "source": [
        "## **Resaltando todos los valores nulos (NaN) en mis datos**"
      ],
      "id": "intimate-table"
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "valued-venezuela",
        "outputId": "c0aa60db-5e8f-48c6-855e-856e418e0321"
      },
      "source": [
        "df.style.highlight_null(null_color='green')"
      ],
      "id": "valued-venezuela",
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<style  type=\"text/css\" >\n",
              "#T_ebe6e_row0_col2{\n",
              "            background-color:  green;\n",
              "        }</style><table id=\"T_ebe6e_\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >A</th>        <th class=\"col_heading level0 col1\" >B</th>        <th class=\"col_heading level0 col2\" >C</th>        <th class=\"col_heading level0 col3\" >D</th>        <th class=\"col_heading level0 col4\" >E</th>    </tr></thead><tbody>\n",
              "                <tr>\n",
              "                        <th id=\"T_ebe6e_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
              "                        <td id=\"T_ebe6e_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
              "                        <td id=\"T_ebe6e_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
              "                        <td id=\"T_ebe6e_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
              "                        <td id=\"T_ebe6e_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
              "                        <td id=\"T_ebe6e_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_ebe6e_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
              "                        <td id=\"T_ebe6e_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
              "                        <td id=\"T_ebe6e_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
              "                        <td id=\"T_ebe6e_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
              "                        <td id=\"T_ebe6e_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
              "                        <td id=\"T_ebe6e_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_ebe6e_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
              "                        <td id=\"T_ebe6e_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
              "                        <td id=\"T_ebe6e_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
              "                        <td id=\"T_ebe6e_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
              "                        <td id=\"T_ebe6e_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
              "                        <td id=\"T_ebe6e_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_ebe6e_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
              "                        <td id=\"T_ebe6e_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
              "                        <td id=\"T_ebe6e_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
              "                        <td id=\"T_ebe6e_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
              "                        <td id=\"T_ebe6e_row3_col3\" class=\"data row3 col3\" >-0.481165</td>\n",
              "                        <td id=\"T_ebe6e_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_ebe6e_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
              "                        <td id=\"T_ebe6e_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
              "                        <td id=\"T_ebe6e_row4_col1\" class=\"data row4 col1\" >1.453425</td>\n",
              "                        <td id=\"T_ebe6e_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
              "                        <td id=\"T_ebe6e_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
              "                        <td id=\"T_ebe6e_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_ebe6e_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
              "                        <td id=\"T_ebe6e_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
              "                        <td id=\"T_ebe6e_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
              "                        <td id=\"T_ebe6e_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
              "                        <td id=\"T_ebe6e_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
              "                        <td id=\"T_ebe6e_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_ebe6e_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
              "                        <td id=\"T_ebe6e_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
              "                        <td id=\"T_ebe6e_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
              "                        <td id=\"T_ebe6e_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
              "                        <td id=\"T_ebe6e_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
              "                        <td id=\"T_ebe6e_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_ebe6e_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
              "                        <td id=\"T_ebe6e_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
              "                        <td id=\"T_ebe6e_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
              "                        <td id=\"T_ebe6e_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
              "                        <td id=\"T_ebe6e_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
              "                        <td id=\"T_ebe6e_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_ebe6e_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
              "                        <td id=\"T_ebe6e_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
              "                        <td id=\"T_ebe6e_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
              "                        <td id=\"T_ebe6e_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
              "                        <td id=\"T_ebe6e_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
              "                        <td id=\"T_ebe6e_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_ebe6e_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
              "                        <td id=\"T_ebe6e_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
              "                        <td id=\"T_ebe6e_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
              "                        <td id=\"T_ebe6e_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
              "                        <td id=\"T_ebe6e_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
              "                        <td id=\"T_ebe6e_row9_col4\" class=\"data row9 col4\" >0.290720</td>\n",
              "            </tr>\n",
              "    </tbody></table>"
            ],
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x27a6666ac10>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "sudden-animation"
      },
      "source": [
        "## **Estilo de mapa de color**\n",
        "\n",
        "La función `Styler.background_gradient` toma lo argumentos de la palabra clave bajo y altos. En términos generales, estos amplían el rango de sus datos en un porcentaje bajo y alto, de modo que cuando convertimos los colores, no se utiliza todo el rango del mapa de colores. Esto es muy útil para leer el texto aún."
      ],
      "id": "sudden-animation"
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "digital-theta",
        "outputId": "224fb32c-9364-4d62-bfc2-31578d101606"
      },
      "source": [
        "import seaborn as sns\n",
        "cm = sns.light_palette(\"red\", as_cmap=True)\n",
        "df.style.background_gradient(cmap=\"viridis\")"
      ],
      "id": "digital-theta",
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<style  type=\"text/css\" >\n",
              "#T_a5b59_row0_col0,#T_a5b59_row1_col2,#T_a5b59_row2_col1,#T_a5b59_row8_col4,#T_a5b59_row9_col3{\n",
              "            background-color:  #440154;\n",
              "            color:  #f1f1f1;\n",
              "        }#T_a5b59_row0_col1{\n",
              "            background-color:  #b8de29;\n",
              "            color:  #000000;\n",
              "        }#T_a5b59_row0_col2{\n",
              "            background-color:  #000000;\n",
              "            color:  #f1f1f1;\n",
              "        }#T_a5b59_row0_col3{\n",
              "            background-color:  #472f7d;\n",
              "            color:  #f1f1f1;\n",
              "        }#T_a5b59_row0_col4{\n",
              "            background-color:  #38598c;\n",
              "            color:  #f1f1f1;\n",
              "        }#T_a5b59_row1_col0{\n",
              "            background-color:  #482878;\n",
              "            color:  #f1f1f1;\n",
              "        }#T_a5b59_row1_col1{\n",
              "            background-color:  #443983;\n",
              "            color:  #f1f1f1;\n",
              "        }#T_a5b59_row1_col3{\n",
              "            background-color:  #1fa187;\n",
              "            color:  #000000;\n",
              "        }#T_a5b59_row1_col4,#T_a5b59_row7_col1,#T_a5b59_row9_col4{\n",
              "            background-color:  #22a884;\n",
              "            color:  #000000;\n",
              "        }#T_a5b59_row2_col0{\n",
              "            background-color:  #3e4989;\n",
              "            color:  #f1f1f1;\n",
              "        }#T_a5b59_row2_col2,#T_a5b59_row2_col3{\n",
              "            background-color:  #28ae80;\n",
              "            color:  #000000;\n",
              "        }#T_a5b59_row2_col4,#T_a5b59_row6_col2,#T_a5b59_row8_col1,#T_a5b59_row8_col3,#T_a5b59_row9_col0{\n",
              "            background-color:  #fde725;\n",
              "            color:  #000000;\n",
              "        }#T_a5b59_row3_col0{\n",
              "            background-color:  #31688e;\n",
              "            color:  #f1f1f1;\n",
              "        }#T_a5b59_row3_col1,#T_a5b59_row7_col0{\n",
              "            background-color:  #6ece58;\n",
              "            color:  #000000;\n",
              "        }#T_a5b59_row3_col2{\n",
              "            background-color:  #20a486;\n",
              "            color:  #000000;\n",
              "        }#T_a5b59_row3_col3{\n",
              "            background-color:  #481467;\n",
              "            color:  #f1f1f1;\n",
              "        }#T_a5b59_row3_col4{\n",
              "            background-color:  #58c765;\n",
              "            color:  #000000;\n",
              "        }#T_a5b59_row4_col0{\n",
              "            background-color:  #26828e;\n",
              "            color:  #000000;\n",
              "        }#T_a5b59_row4_col1{\n",
              "            background-color:  #d0e11c;\n",
              "            color:  #000000;\n",
              "        }#T_a5b59_row4_col2{\n",
              "            background-color:  #dae319;\n",
              "            color:  #000000;\n",
              "        }#T_a5b59_row4_col3{\n",
              "            background-color:  #2c718e;\n",
              "            color:  #f1f1f1;\n",
              "        }#T_a5b59_row4_col4,#T_a5b59_row7_col4{\n",
              "            background-color:  #31b57b;\n",
              "            color:  #000000;\n",
              "        }#T_a5b59_row5_col0{\n",
              "            background-color:  #1f9e89;\n",
              "            color:  #000000;\n",
              "        }#T_a5b59_row5_col1{\n",
              "            background-color:  #482071;\n",
              "            color:  #f1f1f1;\n",
              "        }#T_a5b59_row5_col2{\n",
              "            background-color:  #60ca60;\n",
              "            color:  #000000;\n",
              "        }#T_a5b59_row5_col3{\n",
              "            background-color:  #f4e61e;\n",
              "            color:  #000000;\n",
              "        }#T_a5b59_row5_col4{\n",
              "            background-color:  #20928c;\n",
              "            color:  #000000;\n",
              "        }#T_a5b59_row6_col0{\n",
              "            background-color:  #35b779;\n",
              "            color:  #000000;\n",
              "        }#T_a5b59_row6_col1{\n",
              "            background-color:  #1f978b;\n",
              "            color:  #000000;\n",
              "        }#T_a5b59_row6_col3{\n",
              "            background-color:  #365d8d;\n",
              "            color:  #f1f1f1;\n",
              "        }#T_a5b59_row6_col4,#T_a5b59_row7_col2{\n",
              "            background-color:  #d5e21a;\n",
              "            color:  #000000;\n",
              "        }#T_a5b59_row7_col3{\n",
              "            background-color:  #482475;\n",
              "            color:  #f1f1f1;\n",
              "        }#T_a5b59_row8_col0{\n",
              "            background-color:  #b5de2b;\n",
              "            color:  #000000;\n",
              "        }#T_a5b59_row8_col2{\n",
              "            background-color:  #471063;\n",
              "            color:  #f1f1f1;\n",
              "        }#T_a5b59_row9_col1{\n",
              "            background-color:  #25848e;\n",
              "            color:  #000000;\n",
              "        }#T_a5b59_row9_col2{\n",
              "            background-color:  #70cf57;\n",
              "            color:  #000000;\n",
              "        }</style><table id=\"T_a5b59_\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >A</th>        <th class=\"col_heading level0 col1\" >B</th>        <th class=\"col_heading level0 col2\" >C</th>        <th class=\"col_heading level0 col3\" >D</th>        <th class=\"col_heading level0 col4\" >E</th>    </tr></thead><tbody>\n",
              "                <tr>\n",
              "                        <th id=\"T_a5b59_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
              "                        <td id=\"T_a5b59_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
              "                        <td id=\"T_a5b59_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
              "                        <td id=\"T_a5b59_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
              "                        <td id=\"T_a5b59_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
              "                        <td id=\"T_a5b59_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a5b59_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
              "                        <td id=\"T_a5b59_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
              "                        <td id=\"T_a5b59_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
              "                        <td id=\"T_a5b59_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
              "                        <td id=\"T_a5b59_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
              "                        <td id=\"T_a5b59_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a5b59_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
              "                        <td id=\"T_a5b59_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
              "                        <td id=\"T_a5b59_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
              "                        <td id=\"T_a5b59_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
              "                        <td id=\"T_a5b59_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
              "                        <td id=\"T_a5b59_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a5b59_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
              "                        <td id=\"T_a5b59_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
              "                        <td id=\"T_a5b59_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
              "                        <td id=\"T_a5b59_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
              "                        <td id=\"T_a5b59_row3_col3\" class=\"data row3 col3\" >-0.481165</td>\n",
              "                        <td id=\"T_a5b59_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a5b59_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
              "                        <td id=\"T_a5b59_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
              "                        <td id=\"T_a5b59_row4_col1\" class=\"data row4 col1\" >1.453425</td>\n",
              "                        <td id=\"T_a5b59_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
              "                        <td id=\"T_a5b59_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
              "                        <td id=\"T_a5b59_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a5b59_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
              "                        <td id=\"T_a5b59_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
              "                        <td id=\"T_a5b59_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
              "                        <td id=\"T_a5b59_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
              "                        <td id=\"T_a5b59_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
              "                        <td id=\"T_a5b59_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a5b59_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
              "                        <td id=\"T_a5b59_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
              "                        <td id=\"T_a5b59_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
              "                        <td id=\"T_a5b59_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
              "                        <td id=\"T_a5b59_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
              "                        <td id=\"T_a5b59_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a5b59_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
              "                        <td id=\"T_a5b59_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
              "                        <td id=\"T_a5b59_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
              "                        <td id=\"T_a5b59_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
              "                        <td id=\"T_a5b59_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
              "                        <td id=\"T_a5b59_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a5b59_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
              "                        <td id=\"T_a5b59_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
              "                        <td id=\"T_a5b59_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
              "                        <td id=\"T_a5b59_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
              "                        <td id=\"T_a5b59_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
              "                        <td id=\"T_a5b59_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a5b59_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
              "                        <td id=\"T_a5b59_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
              "                        <td id=\"T_a5b59_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
              "                        <td id=\"T_a5b59_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
              "                        <td id=\"T_a5b59_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
              "                        <td id=\"T_a5b59_row9_col4\" class=\"data row9 col4\" >0.290720</td>\n",
              "            </tr>\n",
              "    </tbody></table>"
            ],
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x27a7d64ebe0>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "premier-harvey"
      },
      "source": [
        "## **Styler.set_properties**"
      ],
      "id": "premier-harvey"
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "negative-bubble",
        "outputId": "12e77561-2818-484b-c52d-3caa5ac55c91"
      },
      "source": [
        "df.style.set_properties(**{'background-color': 'black','color': 'lawngreen','border-color': 'white'})"
      ],
      "id": "negative-bubble",
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<style  type=\"text/css\" >\n",
              "#T_f3047_row0_col0,#T_f3047_row0_col1,#T_f3047_row0_col2,#T_f3047_row0_col3,#T_f3047_row0_col4,#T_f3047_row1_col0,#T_f3047_row1_col1,#T_f3047_row1_col2,#T_f3047_row1_col3,#T_f3047_row1_col4,#T_f3047_row2_col0,#T_f3047_row2_col1,#T_f3047_row2_col2,#T_f3047_row2_col3,#T_f3047_row2_col4,#T_f3047_row3_col0,#T_f3047_row3_col1,#T_f3047_row3_col2,#T_f3047_row3_col3,#T_f3047_row3_col4,#T_f3047_row4_col0,#T_f3047_row4_col1,#T_f3047_row4_col2,#T_f3047_row4_col3,#T_f3047_row4_col4,#T_f3047_row5_col0,#T_f3047_row5_col1,#T_f3047_row5_col2,#T_f3047_row5_col3,#T_f3047_row5_col4,#T_f3047_row6_col0,#T_f3047_row6_col1,#T_f3047_row6_col2,#T_f3047_row6_col3,#T_f3047_row6_col4,#T_f3047_row7_col0,#T_f3047_row7_col1,#T_f3047_row7_col2,#T_f3047_row7_col3,#T_f3047_row7_col4,#T_f3047_row8_col0,#T_f3047_row8_col1,#T_f3047_row8_col2,#T_f3047_row8_col3,#T_f3047_row8_col4,#T_f3047_row9_col0,#T_f3047_row9_col1,#T_f3047_row9_col2,#T_f3047_row9_col3,#T_f3047_row9_col4{\n",
              "            background-color:  black;\n",
              "            color:  lawngreen;\n",
              "            border-color:  white;\n",
              "        }</style><table id=\"T_f3047_\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >A</th>        <th class=\"col_heading level0 col1\" >B</th>        <th class=\"col_heading level0 col2\" >C</th>        <th class=\"col_heading level0 col3\" >D</th>        <th class=\"col_heading level0 col4\" >E</th>    </tr></thead><tbody>\n",
              "                <tr>\n",
              "                        <th id=\"T_f3047_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
              "                        <td id=\"T_f3047_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
              "                        <td id=\"T_f3047_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
              "                        <td id=\"T_f3047_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
              "                        <td id=\"T_f3047_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
              "                        <td id=\"T_f3047_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_f3047_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
              "                        <td id=\"T_f3047_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
              "                        <td id=\"T_f3047_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
              "                        <td id=\"T_f3047_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
              "                        <td id=\"T_f3047_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
              "                        <td id=\"T_f3047_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_f3047_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
              "                        <td id=\"T_f3047_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
              "                        <td id=\"T_f3047_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
              "                        <td id=\"T_f3047_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
              "                        <td id=\"T_f3047_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
              "                        <td id=\"T_f3047_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_f3047_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
              "                        <td id=\"T_f3047_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
              "                        <td id=\"T_f3047_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
              "                        <td id=\"T_f3047_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
              "                        <td id=\"T_f3047_row3_col3\" class=\"data row3 col3\" >-0.481165</td>\n",
              "                        <td id=\"T_f3047_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_f3047_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
              "                        <td id=\"T_f3047_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
              "                        <td id=\"T_f3047_row4_col1\" class=\"data row4 col1\" >1.453425</td>\n",
              "                        <td id=\"T_f3047_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
              "                        <td id=\"T_f3047_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
              "                        <td id=\"T_f3047_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_f3047_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
              "                        <td id=\"T_f3047_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
              "                        <td id=\"T_f3047_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
              "                        <td id=\"T_f3047_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
              "                        <td id=\"T_f3047_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
              "                        <td id=\"T_f3047_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_f3047_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
              "                        <td id=\"T_f3047_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
              "                        <td id=\"T_f3047_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
              "                        <td id=\"T_f3047_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
              "                        <td id=\"T_f3047_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
              "                        <td id=\"T_f3047_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_f3047_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
              "                        <td id=\"T_f3047_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
              "                        <td id=\"T_f3047_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
              "                        <td id=\"T_f3047_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
              "                        <td id=\"T_f3047_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
              "                        <td id=\"T_f3047_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_f3047_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
              "                        <td id=\"T_f3047_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
              "                        <td id=\"T_f3047_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
              "                        <td id=\"T_f3047_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
              "                        <td id=\"T_f3047_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
              "                        <td id=\"T_f3047_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_f3047_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
              "                        <td id=\"T_f3047_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
              "                        <td id=\"T_f3047_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
              "                        <td id=\"T_f3047_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
              "                        <td id=\"T_f3047_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
              "                        <td id=\"T_f3047_row9_col4\" class=\"data row9 col4\" >0.290720</td>\n",
              "            </tr>\n",
              "    </tbody></table>"
            ],
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x27a7d64e790>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "sustainable-disease"
      },
      "source": [
        "## **Gráfico de barra en DataFrame**"
      ],
      "id": "sustainable-disease"
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "fallen-regression",
        "outputId": "f02b4c28-be1f-498b-91c7-55daae262efc"
      },
      "source": [
        "df.style.bar(subset=['A', 'B'], color='green')"
      ],
      "id": "fallen-regression",
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<style  type=\"text/css\" >\n",
              "#T_b8f4d_row0_col0,#T_b8f4d_row2_col1{\n",
              "            width:  10em;\n",
              "             height:  80%;\n",
              "        }#T_b8f4d_row0_col1{\n",
              "            width:  10em;\n",
              "             height:  80%;\n",
              "            background:  linear-gradient(90deg,green 89.2%, transparent 89.2%);\n",
              "        }#T_b8f4d_row1_col0{\n",
              "            width:  10em;\n",
              "             height:  80%;\n",
              "            background:  linear-gradient(90deg,green 11.1%, transparent 11.1%);\n",
              "        }#T_b8f4d_row1_col1{\n",
              "            width:  10em;\n",
              "             height:  80%;\n",
              "            background:  linear-gradient(90deg,green 16.8%, transparent 16.8%);\n",
              "        }#T_b8f4d_row2_col0{\n",
              "            width:  10em;\n",
              "             height:  80%;\n",
              "            background:  linear-gradient(90deg,green 22.2%, transparent 22.2%);\n",
              "        }#T_b8f4d_row3_col0{\n",
              "            width:  10em;\n",
              "             height:  80%;\n",
              "            background:  linear-gradient(90deg,green 33.3%, transparent 33.3%);\n",
              "        }#T_b8f4d_row3_col1{\n",
              "            width:  10em;\n",
              "             height:  80%;\n",
              "            background:  linear-gradient(90deg,green 78.1%, transparent 78.1%);\n",
              "        }#T_b8f4d_row4_col0{\n",
              "            width:  10em;\n",
              "             height:  80%;\n",
              "            background:  linear-gradient(90deg,green 44.4%, transparent 44.4%);\n",
              "        }#T_b8f4d_row4_col1{\n",
              "            width:  10em;\n",
              "             height:  80%;\n",
              "            background:  linear-gradient(90deg,green 93.0%, transparent 93.0%);\n",
              "        }#T_b8f4d_row5_col0{\n",
              "            width:  10em;\n",
              "             height:  80%;\n",
              "            background:  linear-gradient(90deg,green 55.6%, transparent 55.6%);\n",
              "        }#T_b8f4d_row5_col1{\n",
              "            width:  10em;\n",
              "             height:  80%;\n",
              "            background:  linear-gradient(90deg,green 8.7%, transparent 8.7%);\n",
              "        }#T_b8f4d_row6_col0{\n",
              "            width:  10em;\n",
              "             height:  80%;\n",
              "            background:  linear-gradient(90deg,green 66.7%, transparent 66.7%);\n",
              "        }#T_b8f4d_row6_col1{\n",
              "            width:  10em;\n",
              "             height:  80%;\n",
              "            background:  linear-gradient(90deg,green 52.8%, transparent 52.8%);\n",
              "        }#T_b8f4d_row7_col0{\n",
              "            width:  10em;\n",
              "             height:  80%;\n",
              "            background:  linear-gradient(90deg,green 77.8%, transparent 77.8%);\n",
              "        }#T_b8f4d_row7_col1{\n",
              "            width:  10em;\n",
              "             height:  80%;\n",
              "            background:  linear-gradient(90deg,green 59.8%, transparent 59.8%);\n",
              "        }#T_b8f4d_row8_col0{\n",
              "            width:  10em;\n",
              "             height:  80%;\n",
              "            background:  linear-gradient(90deg,green 88.9%, transparent 88.9%);\n",
              "        }#T_b8f4d_row8_col1,#T_b8f4d_row9_col0{\n",
              "            width:  10em;\n",
              "             height:  80%;\n",
              "            background:  linear-gradient(90deg,green 100.0%, transparent 100.0%);\n",
              "        }#T_b8f4d_row9_col1{\n",
              "            width:  10em;\n",
              "             height:  80%;\n",
              "            background:  linear-gradient(90deg,green 45.2%, transparent 45.2%);\n",
              "        }</style><table id=\"T_b8f4d_\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >A</th>        <th class=\"col_heading level0 col1\" >B</th>        <th class=\"col_heading level0 col2\" >C</th>        <th class=\"col_heading level0 col3\" >D</th>        <th class=\"col_heading level0 col4\" >E</th>    </tr></thead><tbody>\n",
              "                <tr>\n",
              "                        <th id=\"T_b8f4d_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
              "                        <td id=\"T_b8f4d_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
              "                        <td id=\"T_b8f4d_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
              "                        <td id=\"T_b8f4d_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
              "                        <td id=\"T_b8f4d_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
              "                        <td id=\"T_b8f4d_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_b8f4d_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
              "                        <td id=\"T_b8f4d_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
              "                        <td id=\"T_b8f4d_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
              "                        <td id=\"T_b8f4d_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
              "                        <td id=\"T_b8f4d_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
              "                        <td id=\"T_b8f4d_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_b8f4d_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
              "                        <td id=\"T_b8f4d_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
              "                        <td id=\"T_b8f4d_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
              "                        <td id=\"T_b8f4d_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
              "                        <td id=\"T_b8f4d_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
              "                        <td id=\"T_b8f4d_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_b8f4d_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
              "                        <td id=\"T_b8f4d_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
              "                        <td id=\"T_b8f4d_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
              "                        <td id=\"T_b8f4d_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
              "                        <td id=\"T_b8f4d_row3_col3\" class=\"data row3 col3\" >-0.481165</td>\n",
              "                        <td id=\"T_b8f4d_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_b8f4d_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
              "                        <td id=\"T_b8f4d_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
              "                        <td id=\"T_b8f4d_row4_col1\" class=\"data row4 col1\" >1.453425</td>\n",
              "                        <td id=\"T_b8f4d_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
              "                        <td id=\"T_b8f4d_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
              "                        <td id=\"T_b8f4d_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_b8f4d_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
              "                        <td id=\"T_b8f4d_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
              "                        <td id=\"T_b8f4d_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
              "                        <td id=\"T_b8f4d_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
              "                        <td id=\"T_b8f4d_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
              "                        <td id=\"T_b8f4d_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_b8f4d_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
              "                        <td id=\"T_b8f4d_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
              "                        <td id=\"T_b8f4d_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
              "                        <td id=\"T_b8f4d_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
              "                        <td id=\"T_b8f4d_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
              "                        <td id=\"T_b8f4d_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_b8f4d_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
              "                        <td id=\"T_b8f4d_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
              "                        <td id=\"T_b8f4d_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
              "                        <td id=\"T_b8f4d_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
              "                        <td id=\"T_b8f4d_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
              "                        <td id=\"T_b8f4d_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_b8f4d_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
              "                        <td id=\"T_b8f4d_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
              "                        <td id=\"T_b8f4d_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
              "                        <td id=\"T_b8f4d_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
              "                        <td id=\"T_b8f4d_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
              "                        <td id=\"T_b8f4d_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_b8f4d_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
              "                        <td id=\"T_b8f4d_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
              "                        <td id=\"T_b8f4d_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
              "                        <td id=\"T_b8f4d_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
              "                        <td id=\"T_b8f4d_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
              "                        <td id=\"T_b8f4d_row9_col4\" class=\"data row9 col4\" >0.290720</td>\n",
              "            </tr>\n",
              "    </tbody></table>"
            ],
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x27a7d68e340>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 24
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "engaging-asthma"
      },
      "source": [
        "## **Estilo de mesa**"
      ],
      "id": "engaging-asthma"
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "quality-fountain",
        "outputId": "d003d09d-10b5-49ae-cd6c-531677b08625"
      },
      "source": [
        "from IPython.display import HTML\n",
        "\n",
        "def hover(hover_color=\"pink\"):\n",
        "    return dict(selector=\"tr:hover\",\n",
        "                props=[(\"background-color\", \"%s\" % hover_color)])\n",
        "\n",
        "styles = [\n",
        "    hover(),\n",
        "    dict(selector=\"th\", props=[(\"font-size\", \"150%\"),\n",
        "                               (\"text-align\", \"center\")]),\n",
        "    dict(selector=\"caption\", props=[(\"caption-side\", \"bottom\")])]\n",
        "\n",
        "html = (df.style.set_table_styles(styles)\n",
        "        .set_caption(\"Hover to highlight.\"))\n",
        "html"
      ],
      "id": "quality-fountain",
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<style  type=\"text/css\" >\n",
              "    #T_8e2bc_ tr:hover {\n",
              "          background-color: pink;\n",
              "    }    #T_8e2bc_ th {\n",
              "          font-size: 150%;\n",
              "          text-align: center;\n",
              "    }    #T_8e2bc_ caption {\n",
              "          caption-side: bottom;\n",
              "    }</style><table id=\"T_8e2bc_\" ><caption>Hover to highlight.</caption><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >A</th>        <th class=\"col_heading level0 col1\" >B</th>        <th class=\"col_heading level0 col2\" >C</th>        <th class=\"col_heading level0 col3\" >D</th>        <th class=\"col_heading level0 col4\" >E</th>    </tr></thead><tbody>\n",
              "                <tr>\n",
              "                        <th id=\"T_8e2bc_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
              "                        <td id=\"T_8e2bc_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
              "                        <td id=\"T_8e2bc_row0_col1\" class=\"data row0 col1\" >1.329212</td>\n",
              "                        <td id=\"T_8e2bc_row0_col2\" class=\"data row0 col2\" >nan</td>\n",
              "                        <td id=\"T_8e2bc_row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n",
              "                        <td id=\"T_8e2bc_row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_8e2bc_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
              "                        <td id=\"T_8e2bc_row1_col0\" class=\"data row1 col0\" >2.000000</td>\n",
              "                        <td id=\"T_8e2bc_row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n",
              "                        <td id=\"T_8e2bc_row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n",
              "                        <td id=\"T_8e2bc_row1_col3\" class=\"data row1 col3\" >0.564417</td>\n",
              "                        <td id=\"T_8e2bc_row1_col4\" class=\"data row1 col4\" >0.295722</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_8e2bc_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
              "                        <td id=\"T_8e2bc_row2_col0\" class=\"data row2 col0\" >3.000000</td>\n",
              "                        <td id=\"T_8e2bc_row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n",
              "                        <td id=\"T_8e2bc_row2_col2\" class=\"data row2 col2\" >0.219565</td>\n",
              "                        <td id=\"T_8e2bc_row2_col3\" class=\"data row2 col3\" >0.678805</td>\n",
              "                        <td id=\"T_8e2bc_row2_col4\" class=\"data row2 col4\" >1.889273</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_8e2bc_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
              "                        <td id=\"T_8e2bc_row3_col0\" class=\"data row3 col0\" >4.000000</td>\n",
              "                        <td id=\"T_8e2bc_row3_col1\" class=\"data row3 col1\" >0.961538</td>\n",
              "                        <td id=\"T_8e2bc_row3_col2\" class=\"data row3 col2\" >0.104011</td>\n",
              "                        <td id=\"T_8e2bc_row3_col3\" class=\"data row3 col3\" >-0.481165</td>\n",
              "                        <td id=\"T_8e2bc_row3_col4\" class=\"data row3 col4\" >0.850229</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_8e2bc_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
              "                        <td id=\"T_8e2bc_row4_col0\" class=\"data row4 col0\" >5.000000</td>\n",
              "                        <td id=\"T_8e2bc_row4_col1\" class=\"data row4 col1\" >1.453425</td>\n",
              "                        <td id=\"T_8e2bc_row4_col2\" class=\"data row4 col2\" >1.057737</td>\n",
              "                        <td id=\"T_8e2bc_row4_col3\" class=\"data row4 col3\" >0.165562</td>\n",
              "                        <td id=\"T_8e2bc_row4_col4\" class=\"data row4 col4\" >0.515018</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_8e2bc_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
              "                        <td id=\"T_8e2bc_row5_col0\" class=\"data row5 col0\" >6.000000</td>\n",
              "                        <td id=\"T_8e2bc_row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n",
              "                        <td id=\"T_8e2bc_row5_col2\" class=\"data row5 col2\" >0.562861</td>\n",
              "                        <td id=\"T_8e2bc_row5_col3\" class=\"data row5 col3\" >1.392855</td>\n",
              "                        <td id=\"T_8e2bc_row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_8e2bc_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
              "                        <td id=\"T_8e2bc_row6_col0\" class=\"data row6 col0\" >7.000000</td>\n",
              "                        <td id=\"T_8e2bc_row6_col1\" class=\"data row6 col1\" >0.121668</td>\n",
              "                        <td id=\"T_8e2bc_row6_col2\" class=\"data row6 col2\" >1.207603</td>\n",
              "                        <td id=\"T_8e2bc_row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n",
              "                        <td id=\"T_8e2bc_row6_col4\" class=\"data row6 col4\" >1.627796</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_8e2bc_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
              "                        <td id=\"T_8e2bc_row7_col0\" class=\"data row7 col0\" >8.000000</td>\n",
              "                        <td id=\"T_8e2bc_row7_col1\" class=\"data row7 col1\" >0.354493</td>\n",
              "                        <td id=\"T_8e2bc_row7_col2\" class=\"data row7 col2\" >1.037528</td>\n",
              "                        <td id=\"T_8e2bc_row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n",
              "                        <td id=\"T_8e2bc_row7_col4\" class=\"data row7 col4\" >0.519818</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_8e2bc_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
              "                        <td id=\"T_8e2bc_row8_col0\" class=\"data row8 col0\" >9.000000</td>\n",
              "                        <td id=\"T_8e2bc_row8_col1\" class=\"data row8 col1\" >1.686583</td>\n",
              "                        <td id=\"T_8e2bc_row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n",
              "                        <td id=\"T_8e2bc_row8_col3\" class=\"data row8 col3\" >1.428984</td>\n",
              "                        <td id=\"T_8e2bc_row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_8e2bc_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
              "                        <td id=\"T_8e2bc_row9_col0\" class=\"data row9 col0\" >10.000000</td>\n",
              "                        <td id=\"T_8e2bc_row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n",
              "                        <td id=\"T_8e2bc_row9_col2\" class=\"data row9 col2\" >0.631523</td>\n",
              "                        <td id=\"T_8e2bc_row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n",
              "                        <td id=\"T_8e2bc_row9_col4\" class=\"data row9 col4\" >0.290720</td>\n",
              "            </tr>\n",
              "    </tbody></table>"
            ],
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x27a7d68e7c0>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 27
        }
      ]
    }
  ]
}