notebooks/wrap_column_headers.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "765b0864-68ea-45c2-a4fe-e32bb7ba0cbe",
   "metadata": {},
   "source": [
    "# Wrap column headers\n",
    "\n",
    "The [Table Visualization](https://pandas.pydata.org/pandas-docs/stable/user_guide/style.html) section of the Pandas docs is a good starting place for fine-grained control of table styles."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "f1f89daf-2097-45d5-a653-67ed0132adcb",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Setup\n",
    "\n",
    "import numpy as np\n",
    "import pandas as pd\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "82947cb2-9711-4f8a-9b8e-39c0245136e8",
   "metadata": {},
   "source": [
    "In an attempt to have clear, nicely-formatted column names, I often end up displaying DataFrames that will be too wide for the default display."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "b6e7429e-a285-482c-8613-266575ca93c2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>very_long_column_title_0</th>\n",
       "      <th>very_long_column_title_1</th>\n",
       "      <th>very_long_column_title_2</th>\n",
       "      <th>very_long_column_title_3</th>\n",
       "      <th>very_long_column_title_4</th>\n",
       "      <th>very_long_column_title_5</th>\n",
       "      <th>very_long_column_title_6</th>\n",
       "      <th>very_long_column_title_7</th>\n",
       "      <th>very_long_column_title_8</th>\n",
       "      <th>very_long_column_title_9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.043290</td>\n",
       "      <td>-1.315625</td>\n",
       "      <td>1.679559</td>\n",
       "      <td>-0.767990</td>\n",
       "      <td>-1.959854</td>\n",
       "      <td>-0.256702</td>\n",
       "      <td>-1.627739</td>\n",
       "      <td>1.534654</td>\n",
       "      <td>0.292217</td>\n",
       "      <td>1.895300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.206529</td>\n",
       "      <td>1.208066</td>\n",
       "      <td>-1.372959</td>\n",
       "      <td>-1.457235</td>\n",
       "      <td>0.321962</td>\n",
       "      <td>0.753179</td>\n",
       "      <td>-0.911225</td>\n",
       "      <td>-0.227549</td>\n",
       "      <td>-0.768242</td>\n",
       "      <td>-1.197723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-0.522150</td>\n",
       "      <td>1.043822</td>\n",
       "      <td>0.896114</td>\n",
       "      <td>-1.448112</td>\n",
       "      <td>0.930213</td>\n",
       "      <td>-0.965441</td>\n",
       "      <td>0.824094</td>\n",
       "      <td>-2.150565</td>\n",
       "      <td>-0.169550</td>\n",
       "      <td>0.902912</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-1.189784</td>\n",
       "      <td>0.554363</td>\n",
       "      <td>-1.008590</td>\n",
       "      <td>-1.610045</td>\n",
       "      <td>-0.737654</td>\n",
       "      <td>0.275849</td>\n",
       "      <td>-1.247350</td>\n",
       "      <td>-0.219940</td>\n",
       "      <td>-1.479569</td>\n",
       "      <td>-1.683375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-1.030102</td>\n",
       "      <td>-1.868196</td>\n",
       "      <td>0.776102</td>\n",
       "      <td>2.247438</td>\n",
       "      <td>0.482620</td>\n",
       "      <td>1.242679</td>\n",
       "      <td>-0.119027</td>\n",
       "      <td>0.116502</td>\n",
       "      <td>0.767433</td>\n",
       "      <td>-1.360527</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0.145369</td>\n",
       "      <td>0.655229</td>\n",
       "      <td>0.201489</td>\n",
       "      <td>-2.010886</td>\n",
       "      <td>-0.916654</td>\n",
       "      <td>-0.016746</td>\n",
       "      <td>0.136143</td>\n",
       "      <td>-0.707137</td>\n",
       "      <td>-0.780618</td>\n",
       "      <td>1.198652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0.245422</td>\n",
       "      <td>0.090801</td>\n",
       "      <td>-1.722201</td>\n",
       "      <td>0.997657</td>\n",
       "      <td>0.925049</td>\n",
       "      <td>-0.834475</td>\n",
       "      <td>1.861780</td>\n",
       "      <td>0.358015</td>\n",
       "      <td>0.871486</td>\n",
       "      <td>0.384704</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.626758</td>\n",
       "      <td>1.497500</td>\n",
       "      <td>1.418559</td>\n",
       "      <td>-0.650648</td>\n",
       "      <td>-0.308281</td>\n",
       "      <td>-0.570179</td>\n",
       "      <td>-0.788249</td>\n",
       "      <td>0.092388</td>\n",
       "      <td>0.622280</td>\n",
       "      <td>0.445002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.717521</td>\n",
       "      <td>1.560096</td>\n",
       "      <td>-0.311071</td>\n",
       "      <td>0.905100</td>\n",
       "      <td>0.522118</td>\n",
       "      <td>-1.083400</td>\n",
       "      <td>0.051064</td>\n",
       "      <td>0.222673</td>\n",
       "      <td>0.618345</td>\n",
       "      <td>0.946164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0.244059</td>\n",
       "      <td>-0.126309</td>\n",
       "      <td>-0.603847</td>\n",
       "      <td>0.352051</td>\n",
       "      <td>-1.255572</td>\n",
       "      <td>-0.476173</td>\n",
       "      <td>-0.807395</td>\n",
       "      <td>-0.806032</td>\n",
       "      <td>-0.747203</td>\n",
       "      <td>-0.642893</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   very_long_column_title_0  very_long_column_title_1  \\\n",
       "0                  0.043290                 -1.315625   \n",
       "1                  0.206529                  1.208066   \n",
       "2                 -0.522150                  1.043822   \n",
       "3                 -1.189784                  0.554363   \n",
       "4                 -1.030102                 -1.868196   \n",
       "5                  0.145369                  0.655229   \n",
       "6                  0.245422                  0.090801   \n",
       "7                  0.626758                  1.497500   \n",
       "8                  0.717521                  1.560096   \n",
       "9                  0.244059                 -0.126309   \n",
       "\n",
       "   very_long_column_title_2  very_long_column_title_3  \\\n",
       "0                  1.679559                 -0.767990   \n",
       "1                 -1.372959                 -1.457235   \n",
       "2                  0.896114                 -1.448112   \n",
       "3                 -1.008590                 -1.610045   \n",
       "4                  0.776102                  2.247438   \n",
       "5                  0.201489                 -2.010886   \n",
       "6                 -1.722201                  0.997657   \n",
       "7                  1.418559                 -0.650648   \n",
       "8                 -0.311071                  0.905100   \n",
       "9                 -0.603847                  0.352051   \n",
       "\n",
       "   very_long_column_title_4  very_long_column_title_5  \\\n",
       "0                 -1.959854                 -0.256702   \n",
       "1                  0.321962                  0.753179   \n",
       "2                  0.930213                 -0.965441   \n",
       "3                 -0.737654                  0.275849   \n",
       "4                  0.482620                  1.242679   \n",
       "5                 -0.916654                 -0.016746   \n",
       "6                  0.925049                 -0.834475   \n",
       "7                 -0.308281                 -0.570179   \n",
       "8                  0.522118                 -1.083400   \n",
       "9                 -1.255572                 -0.476173   \n",
       "\n",
       "   very_long_column_title_6  very_long_column_title_7  \\\n",
       "0                 -1.627739                  1.534654   \n",
       "1                 -0.911225                 -0.227549   \n",
       "2                  0.824094                 -2.150565   \n",
       "3                 -1.247350                 -0.219940   \n",
       "4                 -0.119027                  0.116502   \n",
       "5                  0.136143                 -0.707137   \n",
       "6                  1.861780                  0.358015   \n",
       "7                 -0.788249                  0.092388   \n",
       "8                  0.051064                  0.222673   \n",
       "9                 -0.807395                 -0.806032   \n",
       "\n",
       "   very_long_column_title_8  very_long_column_title_9  \n",
       "0                  0.292217                  1.895300  \n",
       "1                 -0.768242                 -1.197723  \n",
       "2                 -0.169550                  0.902912  \n",
       "3                 -1.479569                 -1.683375  \n",
       "4                  0.767433                 -1.360527  \n",
       "5                 -0.780618                  1.198652  \n",
       "6                  0.871486                  0.384704  \n",
       "7                  0.622280                  0.445002  \n",
       "8                  0.618345                  0.946164  \n",
       "9                 -0.747203                 -0.642893  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Show a dataframe with many columns and long column names\n",
    "\n",
    "df = pd.DataFrame(\n",
    "    np.random.randn(10, 10), \n",
    "    columns=[f'very_long_column_title_{i}' for i in range(10)]\n",
    ")\n",
    "\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7211d5de-29ec-4cf6-bc33-d42804eb599a",
   "metadata": {},
   "source": [
    "Using [`set_table_styles()`](https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.io.formats.style.Styler.set_table_styles.html) to set the `word-break` CSS property to `break-all` on the `th` elements that surround the column headings cause the column names to wrap.\n",
    "\n",
    "Note that I include `thead` in the CSS selector because otherwise the index in each row will be wrapped because it is rendered inside a `th` element."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "eadb9f08-070a-4700-8dcb-9022026a1653",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_76247_ thead th {\n",
       "  word-break: break-all;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_76247_\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th class=\"col_heading level0 col0\" >very_long_column_title_0</th>\n",
       "      <th class=\"col_heading level0 col1\" >very_long_column_title_1</th>\n",
       "      <th class=\"col_heading level0 col2\" >very_long_column_title_2</th>\n",
       "      <th class=\"col_heading level0 col3\" >very_long_column_title_3</th>\n",
       "      <th class=\"col_heading level0 col4\" >very_long_column_title_4</th>\n",
       "      <th class=\"col_heading level0 col5\" >very_long_column_title_5</th>\n",
       "      <th class=\"col_heading level0 col6\" >very_long_column_title_6</th>\n",
       "      <th class=\"col_heading level0 col7\" >very_long_column_title_7</th>\n",
       "      <th class=\"col_heading level0 col8\" >very_long_column_title_8</th>\n",
       "      <th class=\"col_heading level0 col9\" >very_long_column_title_9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_76247_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "      <td id=\"T_76247_row0_col0\" class=\"data row0 col0\" >0.043290</td>\n",
       "      <td id=\"T_76247_row0_col1\" class=\"data row0 col1\" >-1.315625</td>\n",
       "      <td id=\"T_76247_row0_col2\" class=\"data row0 col2\" >1.679559</td>\n",
       "      <td id=\"T_76247_row0_col3\" class=\"data row0 col3\" >-0.767990</td>\n",
       "      <td id=\"T_76247_row0_col4\" class=\"data row0 col4\" >-1.959854</td>\n",
       "      <td id=\"T_76247_row0_col5\" class=\"data row0 col5\" >-0.256702</td>\n",
       "      <td id=\"T_76247_row0_col6\" class=\"data row0 col6\" >-1.627739</td>\n",
       "      <td id=\"T_76247_row0_col7\" class=\"data row0 col7\" >1.534654</td>\n",
       "      <td id=\"T_76247_row0_col8\" class=\"data row0 col8\" >0.292217</td>\n",
       "      <td id=\"T_76247_row0_col9\" class=\"data row0 col9\" >1.895300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_76247_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "      <td id=\"T_76247_row1_col0\" class=\"data row1 col0\" >0.206529</td>\n",
       "      <td id=\"T_76247_row1_col1\" class=\"data row1 col1\" >1.208066</td>\n",
       "      <td id=\"T_76247_row1_col2\" class=\"data row1 col2\" >-1.372959</td>\n",
       "      <td id=\"T_76247_row1_col3\" class=\"data row1 col3\" >-1.457235</td>\n",
       "      <td id=\"T_76247_row1_col4\" class=\"data row1 col4\" >0.321962</td>\n",
       "      <td id=\"T_76247_row1_col5\" class=\"data row1 col5\" >0.753179</td>\n",
       "      <td id=\"T_76247_row1_col6\" class=\"data row1 col6\" >-0.911225</td>\n",
       "      <td id=\"T_76247_row1_col7\" class=\"data row1 col7\" >-0.227549</td>\n",
       "      <td id=\"T_76247_row1_col8\" class=\"data row1 col8\" >-0.768242</td>\n",
       "      <td id=\"T_76247_row1_col9\" class=\"data row1 col9\" >-1.197723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_76247_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "      <td id=\"T_76247_row2_col0\" class=\"data row2 col0\" >-0.522150</td>\n",
       "      <td id=\"T_76247_row2_col1\" class=\"data row2 col1\" >1.043822</td>\n",
       "      <td id=\"T_76247_row2_col2\" class=\"data row2 col2\" >0.896114</td>\n",
       "      <td id=\"T_76247_row2_col3\" class=\"data row2 col3\" >-1.448112</td>\n",
       "      <td id=\"T_76247_row2_col4\" class=\"data row2 col4\" >0.930213</td>\n",
       "      <td id=\"T_76247_row2_col5\" class=\"data row2 col5\" >-0.965441</td>\n",
       "      <td id=\"T_76247_row2_col6\" class=\"data row2 col6\" >0.824094</td>\n",
       "      <td id=\"T_76247_row2_col7\" class=\"data row2 col7\" >-2.150565</td>\n",
       "      <td id=\"T_76247_row2_col8\" class=\"data row2 col8\" >-0.169550</td>\n",
       "      <td id=\"T_76247_row2_col9\" class=\"data row2 col9\" >0.902912</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_76247_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "      <td id=\"T_76247_row3_col0\" class=\"data row3 col0\" >-1.189784</td>\n",
       "      <td id=\"T_76247_row3_col1\" class=\"data row3 col1\" >0.554363</td>\n",
       "      <td id=\"T_76247_row3_col2\" class=\"data row3 col2\" >-1.008590</td>\n",
       "      <td id=\"T_76247_row3_col3\" class=\"data row3 col3\" >-1.610045</td>\n",
       "      <td id=\"T_76247_row3_col4\" class=\"data row3 col4\" >-0.737654</td>\n",
       "      <td id=\"T_76247_row3_col5\" class=\"data row3 col5\" >0.275849</td>\n",
       "      <td id=\"T_76247_row3_col6\" class=\"data row3 col6\" >-1.247350</td>\n",
       "      <td id=\"T_76247_row3_col7\" class=\"data row3 col7\" >-0.219940</td>\n",
       "      <td id=\"T_76247_row3_col8\" class=\"data row3 col8\" >-1.479569</td>\n",
       "      <td id=\"T_76247_row3_col9\" class=\"data row3 col9\" >-1.683375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_76247_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "      <td id=\"T_76247_row4_col0\" class=\"data row4 col0\" >-1.030102</td>\n",
       "      <td id=\"T_76247_row4_col1\" class=\"data row4 col1\" >-1.868196</td>\n",
       "      <td id=\"T_76247_row4_col2\" class=\"data row4 col2\" >0.776102</td>\n",
       "      <td id=\"T_76247_row4_col3\" class=\"data row4 col3\" >2.247438</td>\n",
       "      <td id=\"T_76247_row4_col4\" class=\"data row4 col4\" >0.482620</td>\n",
       "      <td id=\"T_76247_row4_col5\" class=\"data row4 col5\" >1.242679</td>\n",
       "      <td id=\"T_76247_row4_col6\" class=\"data row4 col6\" >-0.119027</td>\n",
       "      <td id=\"T_76247_row4_col7\" class=\"data row4 col7\" >0.116502</td>\n",
       "      <td id=\"T_76247_row4_col8\" class=\"data row4 col8\" >0.767433</td>\n",
       "      <td id=\"T_76247_row4_col9\" class=\"data row4 col9\" >-1.360527</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_76247_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "      <td id=\"T_76247_row5_col0\" class=\"data row5 col0\" >0.145369</td>\n",
       "      <td id=\"T_76247_row5_col1\" class=\"data row5 col1\" >0.655229</td>\n",
       "      <td id=\"T_76247_row5_col2\" class=\"data row5 col2\" >0.201489</td>\n",
       "      <td id=\"T_76247_row5_col3\" class=\"data row5 col3\" >-2.010886</td>\n",
       "      <td id=\"T_76247_row5_col4\" class=\"data row5 col4\" >-0.916654</td>\n",
       "      <td id=\"T_76247_row5_col5\" class=\"data row5 col5\" >-0.016746</td>\n",
       "      <td id=\"T_76247_row5_col6\" class=\"data row5 col6\" >0.136143</td>\n",
       "      <td id=\"T_76247_row5_col7\" class=\"data row5 col7\" >-0.707137</td>\n",
       "      <td id=\"T_76247_row5_col8\" class=\"data row5 col8\" >-0.780618</td>\n",
       "      <td id=\"T_76247_row5_col9\" class=\"data row5 col9\" >1.198652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_76247_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "      <td id=\"T_76247_row6_col0\" class=\"data row6 col0\" >0.245422</td>\n",
       "      <td id=\"T_76247_row6_col1\" class=\"data row6 col1\" >0.090801</td>\n",
       "      <td id=\"T_76247_row6_col2\" class=\"data row6 col2\" >-1.722201</td>\n",
       "      <td id=\"T_76247_row6_col3\" class=\"data row6 col3\" >0.997657</td>\n",
       "      <td id=\"T_76247_row6_col4\" class=\"data row6 col4\" >0.925049</td>\n",
       "      <td id=\"T_76247_row6_col5\" class=\"data row6 col5\" >-0.834475</td>\n",
       "      <td id=\"T_76247_row6_col6\" class=\"data row6 col6\" >1.861780</td>\n",
       "      <td id=\"T_76247_row6_col7\" class=\"data row6 col7\" >0.358015</td>\n",
       "      <td id=\"T_76247_row6_col8\" class=\"data row6 col8\" >0.871486</td>\n",
       "      <td id=\"T_76247_row6_col9\" class=\"data row6 col9\" >0.384704</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_76247_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "      <td id=\"T_76247_row7_col0\" class=\"data row7 col0\" >0.626758</td>\n",
       "      <td id=\"T_76247_row7_col1\" class=\"data row7 col1\" >1.497500</td>\n",
       "      <td id=\"T_76247_row7_col2\" class=\"data row7 col2\" >1.418559</td>\n",
       "      <td id=\"T_76247_row7_col3\" class=\"data row7 col3\" >-0.650648</td>\n",
       "      <td id=\"T_76247_row7_col4\" class=\"data row7 col4\" >-0.308281</td>\n",
       "      <td id=\"T_76247_row7_col5\" class=\"data row7 col5\" >-0.570179</td>\n",
       "      <td id=\"T_76247_row7_col6\" class=\"data row7 col6\" >-0.788249</td>\n",
       "      <td id=\"T_76247_row7_col7\" class=\"data row7 col7\" >0.092388</td>\n",
       "      <td id=\"T_76247_row7_col8\" class=\"data row7 col8\" >0.622280</td>\n",
       "      <td id=\"T_76247_row7_col9\" class=\"data row7 col9\" >0.445002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_76247_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "      <td id=\"T_76247_row8_col0\" class=\"data row8 col0\" >0.717521</td>\n",
       "      <td id=\"T_76247_row8_col1\" class=\"data row8 col1\" >1.560096</td>\n",
       "      <td id=\"T_76247_row8_col2\" class=\"data row8 col2\" >-0.311071</td>\n",
       "      <td id=\"T_76247_row8_col3\" class=\"data row8 col3\" >0.905100</td>\n",
       "      <td id=\"T_76247_row8_col4\" class=\"data row8 col4\" >0.522118</td>\n",
       "      <td id=\"T_76247_row8_col5\" class=\"data row8 col5\" >-1.083400</td>\n",
       "      <td id=\"T_76247_row8_col6\" class=\"data row8 col6\" >0.051064</td>\n",
       "      <td id=\"T_76247_row8_col7\" class=\"data row8 col7\" >0.222673</td>\n",
       "      <td id=\"T_76247_row8_col8\" class=\"data row8 col8\" >0.618345</td>\n",
       "      <td id=\"T_76247_row8_col9\" class=\"data row8 col9\" >0.946164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_76247_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "      <td id=\"T_76247_row9_col0\" class=\"data row9 col0\" >0.244059</td>\n",
       "      <td id=\"T_76247_row9_col1\" class=\"data row9 col1\" >-0.126309</td>\n",
       "      <td id=\"T_76247_row9_col2\" class=\"data row9 col2\" >-0.603847</td>\n",
       "      <td id=\"T_76247_row9_col3\" class=\"data row9 col3\" >0.352051</td>\n",
       "      <td id=\"T_76247_row9_col4\" class=\"data row9 col4\" >-1.255572</td>\n",
       "      <td id=\"T_76247_row9_col5\" class=\"data row9 col5\" >-0.476173</td>\n",
       "      <td id=\"T_76247_row9_col6\" class=\"data row9 col6\" >-0.807395</td>\n",
       "      <td id=\"T_76247_row9_col7\" class=\"data row9 col7\" >-0.806032</td>\n",
       "      <td id=\"T_76247_row9_col8\" class=\"data row9 col8\" >-0.747203</td>\n",
       "      <td id=\"T_76247_row9_col9\" class=\"data row9 col9\" >-0.642893</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x12a32adc0>"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Set the word-break CSS property to make headers wrap\n",
    "\n",
    "df.style.set_table_styles([\n",
    "    {\n",
    "        \"selector\": \"thead th\",\n",
    "        \"props\": [\n",
    "            (\"word-break\", \"break-all\",),\n",
    "        ],\n",
    "    },\n",
    "])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c1a88f2b-7878-428d-a296-5f1dd5976e3b",
   "metadata": {},
   "source": [
    "When you want to force wrapping of column names with spaces in them (which automatically wrap when space becomes tight) ..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "e8c2ebfd-7f2b-40f4-8857-687928c372a1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Very Long Column Title 0</th>\n",
       "      <th>Very Long Column Title 1</th>\n",
       "      <th>Very Long Column Title 2</th>\n",
       "      <th>Very Long Column Title 3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-0.251355</td>\n",
       "      <td>-0.637744</td>\n",
       "      <td>0.965959</td>\n",
       "      <td>2.096560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.268306</td>\n",
       "      <td>2.142465</td>\n",
       "      <td>0.341034</td>\n",
       "      <td>0.450563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.732993</td>\n",
       "      <td>0.963850</td>\n",
       "      <td>2.050105</td>\n",
       "      <td>2.204934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3.820257</td>\n",
       "      <td>-1.434039</td>\n",
       "      <td>1.161899</td>\n",
       "      <td>-0.629077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-0.179829</td>\n",
       "      <td>-0.095419</td>\n",
       "      <td>0.687000</td>\n",
       "      <td>0.532283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>-0.865124</td>\n",
       "      <td>-0.086551</td>\n",
       "      <td>0.112480</td>\n",
       "      <td>-0.437840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-0.082468</td>\n",
       "      <td>0.918170</td>\n",
       "      <td>-0.037149</td>\n",
       "      <td>0.283304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.393284</td>\n",
       "      <td>2.944178</td>\n",
       "      <td>-0.288044</td>\n",
       "      <td>0.096290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>-1.639113</td>\n",
       "      <td>-0.072588</td>\n",
       "      <td>0.778677</td>\n",
       "      <td>-0.905295</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>-0.432452</td>\n",
       "      <td>-0.222728</td>\n",
       "      <td>0.577524</td>\n",
       "      <td>-0.248720</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Very Long Column Title 0  Very Long Column Title 1  \\\n",
       "0                 -0.251355                 -0.637744   \n",
       "1                  0.268306                  2.142465   \n",
       "2                  0.732993                  0.963850   \n",
       "3                  3.820257                 -1.434039   \n",
       "4                 -0.179829                 -0.095419   \n",
       "5                 -0.865124                 -0.086551   \n",
       "6                 -0.082468                  0.918170   \n",
       "7                  0.393284                  2.944178   \n",
       "8                 -1.639113                 -0.072588   \n",
       "9                 -0.432452                 -0.222728   \n",
       "\n",
       "   Very Long Column Title 2  Very Long Column Title 3  \n",
       "0                  0.965959                  2.096560  \n",
       "1                  0.341034                  0.450563  \n",
       "2                  2.050105                  2.204934  \n",
       "3                  1.161899                 -0.629077  \n",
       "4                  0.687000                  0.532283  \n",
       "5                  0.112480                 -0.437840  \n",
       "6                 -0.037149                  0.283304  \n",
       "7                 -0.288044                  0.096290  \n",
       "8                  0.778677                 -0.905295  \n",
       "9                  0.577524                 -0.248720  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Show example DataFrame with long titles with spaces in them\n",
    "\n",
    "df2 = pd.DataFrame(\n",
    "    np.random.randn(10, 4), \n",
    "    columns=[f'Very Long Column Title {i}' for i in range(4)]\n",
    ")\n",
    "\n",
    "df2"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cbacf133-40c2-4dd7-8a78-bc9098fa1669",
   "metadata": {},
   "source": [
    "... you can set the `max-width` CSS property to force skinnier columns."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "3b86d0ba-0e22-443e-a19c-1916e63ba866",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_d712e_ thead th {\n",
       "  max-width: 100px;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_d712e_\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th class=\"col_heading level0 col0\" >Very Long Column Title 0</th>\n",
       "      <th class=\"col_heading level0 col1\" >Very Long Column Title 1</th>\n",
       "      <th class=\"col_heading level0 col2\" >Very Long Column Title 2</th>\n",
       "      <th class=\"col_heading level0 col3\" >Very Long Column Title 3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_d712e_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "      <td id=\"T_d712e_row0_col0\" class=\"data row0 col0\" >-0.251355</td>\n",
       "      <td id=\"T_d712e_row0_col1\" class=\"data row0 col1\" >-0.637744</td>\n",
       "      <td id=\"T_d712e_row0_col2\" class=\"data row0 col2\" >0.965959</td>\n",
       "      <td id=\"T_d712e_row0_col3\" class=\"data row0 col3\" >2.096560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_d712e_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "      <td id=\"T_d712e_row1_col0\" class=\"data row1 col0\" >0.268306</td>\n",
       "      <td id=\"T_d712e_row1_col1\" class=\"data row1 col1\" >2.142465</td>\n",
       "      <td id=\"T_d712e_row1_col2\" class=\"data row1 col2\" >0.341034</td>\n",
       "      <td id=\"T_d712e_row1_col3\" class=\"data row1 col3\" >0.450563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_d712e_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "      <td id=\"T_d712e_row2_col0\" class=\"data row2 col0\" >0.732993</td>\n",
       "      <td id=\"T_d712e_row2_col1\" class=\"data row2 col1\" >0.963850</td>\n",
       "      <td id=\"T_d712e_row2_col2\" class=\"data row2 col2\" >2.050105</td>\n",
       "      <td id=\"T_d712e_row2_col3\" class=\"data row2 col3\" >2.204934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_d712e_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "      <td id=\"T_d712e_row3_col0\" class=\"data row3 col0\" >3.820257</td>\n",
       "      <td id=\"T_d712e_row3_col1\" class=\"data row3 col1\" >-1.434039</td>\n",
       "      <td id=\"T_d712e_row3_col2\" class=\"data row3 col2\" >1.161899</td>\n",
       "      <td id=\"T_d712e_row3_col3\" class=\"data row3 col3\" >-0.629077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_d712e_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "      <td id=\"T_d712e_row4_col0\" class=\"data row4 col0\" >-0.179829</td>\n",
       "      <td id=\"T_d712e_row4_col1\" class=\"data row4 col1\" >-0.095419</td>\n",
       "      <td id=\"T_d712e_row4_col2\" class=\"data row4 col2\" >0.687000</td>\n",
       "      <td id=\"T_d712e_row4_col3\" class=\"data row4 col3\" >0.532283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_d712e_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "      <td id=\"T_d712e_row5_col0\" class=\"data row5 col0\" >-0.865124</td>\n",
       "      <td id=\"T_d712e_row5_col1\" class=\"data row5 col1\" >-0.086551</td>\n",
       "      <td id=\"T_d712e_row5_col2\" class=\"data row5 col2\" >0.112480</td>\n",
       "      <td id=\"T_d712e_row5_col3\" class=\"data row5 col3\" >-0.437840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_d712e_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "      <td id=\"T_d712e_row6_col0\" class=\"data row6 col0\" >-0.082468</td>\n",
       "      <td id=\"T_d712e_row6_col1\" class=\"data row6 col1\" >0.918170</td>\n",
       "      <td id=\"T_d712e_row6_col2\" class=\"data row6 col2\" >-0.037149</td>\n",
       "      <td id=\"T_d712e_row6_col3\" class=\"data row6 col3\" >0.283304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_d712e_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "      <td id=\"T_d712e_row7_col0\" class=\"data row7 col0\" >0.393284</td>\n",
       "      <td id=\"T_d712e_row7_col1\" class=\"data row7 col1\" >2.944178</td>\n",
       "      <td id=\"T_d712e_row7_col2\" class=\"data row7 col2\" >-0.288044</td>\n",
       "      <td id=\"T_d712e_row7_col3\" class=\"data row7 col3\" >0.096290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_d712e_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "      <td id=\"T_d712e_row8_col0\" class=\"data row8 col0\" >-1.639113</td>\n",
       "      <td id=\"T_d712e_row8_col1\" class=\"data row8 col1\" >-0.072588</td>\n",
       "      <td id=\"T_d712e_row8_col2\" class=\"data row8 col2\" >0.778677</td>\n",
       "      <td id=\"T_d712e_row8_col3\" class=\"data row8 col3\" >-0.905295</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_d712e_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "      <td id=\"T_d712e_row9_col0\" class=\"data row9 col0\" >-0.432452</td>\n",
       "      <td id=\"T_d712e_row9_col1\" class=\"data row9 col1\" >-0.222728</td>\n",
       "      <td id=\"T_d712e_row9_col2\" class=\"data row9 col2\" >0.577524</td>\n",
       "      <td id=\"T_d712e_row9_col3\" class=\"data row9 col3\" >-0.248720</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x12a5ff8e0>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Set the `max-width` CSS property to force column width and wrap text\n",
    "\n",
    "df2.style.set_table_styles([\n",
    "    {\n",
    "        \"selector\": \"thead th\",\n",
    "        \"props\": [\n",
    "            (\"max-width\", \"100px\",),\n",
    "        ],\n",
    "    },\n",
    "])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "bd251e25-86c5-4e36-8eda-09f652f3963d",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "python-data-cheatsheet",
   "language": "python",
   "name": "python-data-cheatsheet"
  },
  "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.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}