yf_piotroski_score.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "12eb3879-88e6-4d0d-82c6-d8617d9e9886",
   "metadata": {},
   "source": [
    "## Imports"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "f8ab961b-4341-4874-a804-a9a5ed3272ae",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Read stocks\n",
    "import yfinance as yf\n",
    "# Dataframe\n",
    "import pandas as pd\n",
    "# To access NaN\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6dcd51e9-f0bf-474b-a679-2dc971c90af9",
   "metadata": {},
   "source": [
    "## Constants"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "9c5ca578-e279-4123-b62f-0572bf24a4fc",
   "metadata": {},
   "outputs": [],
   "source": [
    "SECTOR = 'Technology'\n",
    "INDUSTRY = 'Semiconductors'\n",
    "# Stock symbols\n",
    "SYMBOLS = 'NVDA,TSM,AVGO,AMD,INTC,QCOM,TXN,ADI,MU,ARM,MRVL,MPWR,MCHP,ON,STM'.split(',')\n",
    "# Criteria + Score (computed)\n",
    "CRITERIA = 'CR1,CR2,CR3,CR4,CR5,CR6,CR7,CR8,CR9,Score'.split(',')\n",
    "\n",
    "# Human readable column names mapping for raw data\n",
    "COLUMN_MAPPING_RAW={'Symbol': 'Symbol', 'Name': 'Name', 'CR1': 'Net Income', 'CR2': 'Return on Assets',\n",
    "                'CR3': 'Op. Cash Flow', 'CR4': 'Quality of Earn', 'CR5': 'Long Term Debt',\n",
    "                'CR6': 'Current Ratio', 'CR7': 'New Shares', 'CR8': 'Gross Margin', 'CR9': 'Asset TR'}\n",
    "\n",
    "# Human readable column names mapping for score data - append Score dictionary item\n",
    "COLUMN_MAPPING_SCORE = COLUMN_MAPPING_RAW | {'Score':'Score'}"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "538dccca-0954-4531-bec8-621483cd7800",
   "metadata": {},
   "source": [
    "## Utility functions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "279c37f1-e538-4d24-a085-1820c2f9e08a",
   "metadata": {},
   "outputs": [],
   "source": [
    "def net_income(ticker):\n",
    "    df = ticker.income_stmt\n",
    "    return df.loc['Net Income'].iloc[0]\n",
    "\n",
    "def roa(ticker):\n",
    "    df = ticker.balance_sheet\n",
    "    avg_assets = (df.loc['Total Assets'].iloc[0] + df.loc['Total Assets'].iloc[1])/2\n",
    "    return round(net_income(ticker)/avg_assets, 2)\n",
    "\n",
    "def ocf(ticker):\n",
    "    df = ticker.cash_flow\n",
    "    if 'Operating Cash Flow' in df.index:\n",
    "        return df.loc['Operating Cash Flow'].iloc[0]\n",
    "    else:\n",
    "        # Calculate Operating Cash Flow using Free Cash Flow and Captial Expenditure\n",
    "        # Take the absolute value for Captial Expenditure as yf returns as a negative number\n",
    "        return df.loc['Free Cash Flow'].iloc[0] + abs(df.loc['Capital Expenditure']).iloc[0]\n",
    "\n",
    "def ltdebt(ticker):\n",
    "    df = ticker.balance_sheet\n",
    "    return (df.loc['Long Term Debt'].iloc[1] - df.loc['Long Term Debt'].iloc[0])\n",
    "\n",
    "def current_ratio(ticker):\n",
    "    df = ticker.balance_sheet\n",
    "    current_ratio_current = df.loc['Total Assets'].iloc[0]/df.loc['Total Liabilities Net Minority Interest'].iloc[0]\n",
    "    current_ratio_prev = df.loc['Total Assets'].iloc[1]/df.loc['Total Liabilities Net Minority Interest'].iloc[1]\n",
    "    return round((current_ratio_current - current_ratio_prev), 2)\n",
    "\n",
    "def new_shares(ticker):\n",
    "    df = ticker.balance_sheet\n",
    "    return (df.loc['Common Stock'].iloc[1] - df.loc['Common Stock'].iloc[0])\n",
    "\n",
    "def gross_margin(ticker):\n",
    "    df = ticker.income_stmt\n",
    "    gross_margin_current = df.loc['Gross Profit'].iloc[0]/ df.loc['Total Revenue'].iloc[0]\n",
    "    gross_margin_prev = df.loc['Gross Profit'].iloc[1]/ df.loc['Total Revenue'].iloc[1]\n",
    "    return (gross_margin_current - gross_margin_prev)\n",
    "\n",
    "def asset_turnover_ratio(ticker):\n",
    "    df_bs = ticker.balance_sheet\n",
    "    y0, y1, y2 = df_bs.loc['Total Assets'].iloc[0], df_bs.loc['Total Assets'].iloc[1], df_bs.loc['Total Assets'].iloc[2]\n",
    "    avg_asset_y0 = (y0 + y1)/2\n",
    "    avg_asset_y1 = (y1 + y2)/2\n",
    "    \n",
    "    df_is = ticker.income_stmt\n",
    "    tot_rvn_y0 = df_is.loc['Total Revenue'].iloc[0]/avg_asset_y0\n",
    "    tot_rvn_y1 = df_is.loc['Total Revenue'].iloc[1]/avg_asset_y1\n",
    "\n",
    "    return round((tot_rvn_y0 - tot_rvn_y1), 2)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "671bda4c-23b2-4181-8522-f1bc80656fa9",
   "metadata": {},
   "source": [
    "## Maps Criteria to Function"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "d4dc2c81-1a3c-4f19-9d8f-b6d0dcbc54c2",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Criteria name -> method\n",
    "criteria_dict = {\n",
    "    'CR1':net_income,\n",
    "    'CR2':roa,\n",
    "    'CR3':ocf,\n",
    "    'CR5':ltdebt,\n",
    "    'CR6':current_ratio,\n",
    "    'CR7':new_shares,\n",
    "    'CR8':gross_margin,\n",
    "    'CR9':asset_turnover_ratio\n",
    "}"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8037cfaf-2e41-4794-afc9-796bcce95f52",
   "metadata": {},
   "source": [
    "## Calculate Piotroski Score"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "80bf8180-5bcd-4a3a-b385-3b4800e05ea8",
   "metadata": {},
   "outputs": [],
   "source": [
    "def calculate_piotroski_score():\n",
    "    # Dictionary to collect 9 criteria\n",
    "    ps_criteria = {\n",
    "        'Symbol':[],'Name':[],'CR1':[],'CR2':[],'CR3':[],'CR4':[],'CR5':[],\n",
    "        'CR6':[],'CR7':[],'CR8':[],'CR9':[]\n",
    "    }\n",
    "    \n",
    "    # Dictionary to collect raw data\n",
    "    ps_criteria_data = {\n",
    "        'Symbol':[],'Name':[],'CR1':[],'CR2':[],'CR3':[],'CR4':[],'CR5':[],\n",
    "        'CR6':[],'CR7':[],'CR8':[],'CR9':[]\n",
    "    }\n",
    "\n",
    "    # Loop through symbol list\n",
    "    for symbol in SYMBOLS:\n",
    "        ticker = yf.Ticker(symbol)\n",
    "\n",
    "        # Set symbol and name\n",
    "        ps_criteria['Symbol'].append(ticker.info['symbol'])\n",
    "        ps_criteria['Name'].append(ticker.info['longName'])\n",
    "        \n",
    "        ps_criteria_data['Symbol'].append(ticker.info['symbol'])\n",
    "        ps_criteria_data['Name'].append(ticker.info['longName'])\n",
    "\n",
    "        # Set criteria\n",
    "        for key, value in criteria_dict.items():\n",
    "            try:\n",
    "                # Uses the command pattern to call the appropriate method\n",
    "                result = value(ticker)\n",
    "                ps_criteria_data[key].append(result)\n",
    "                # Special adjustment for CR7 - if there re no new shares, i.e, difference between current and previous is 0 then add 1 as well\n",
    "                if key == 'CR7':\n",
    "                    ps_criteria[key].append(1 if result >= 0 else 0)\n",
    "                else:\n",
    "                    # Process with other CRs\n",
    "                    ps_criteria[key].append(1 if result > 0 else 0)\n",
    "            except (KeyError, IndexError) as err:\n",
    "                # Error encountered, due to missing data\"\n",
    "                print(err)\n",
    "                ps_criteria[key].append(0)\n",
    "                ps_criteria_data[key].append(np.nan)\n",
    "\n",
    "        # CR4 - handle it differently as it doesn't invoke a method\n",
    "        # CR4 - Cash flow from operations being greater than net income (quality of earnings)\n",
    "        if ps_criteria_data['CR3'][-1] > ps_criteria_data['CR1'][-1]:\n",
    "            ps_criteria['CR4'].append(1)\n",
    "            ps_criteria_data['CR4'].append(1)\n",
    "        else:\n",
    "            # Set criteria and raw data to false (0)\n",
    "            ps_criteria['CR4'].append(0)\n",
    "            ps_criteria_data['CR4'].append(0)\n",
    "    return ps_criteria, ps_criteria_data"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "76bff941-6231-422f-ae1e-7637a62ce579",
   "metadata": {},
   "source": [
    "## Data Frames for Score and Raw data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "a4818009-c417-4ec7-9372-c6edfaa66196",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "'Long Term Debt'\n",
      "single positional indexer is out-of-bounds\n",
      "'Long Term Debt'\n"
     ]
    },
    {
     "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>Symbol</th>\n",
       "      <th>Name</th>\n",
       "      <th>CR1</th>\n",
       "      <th>CR2</th>\n",
       "      <th>CR3</th>\n",
       "      <th>CR4</th>\n",
       "      <th>CR5</th>\n",
       "      <th>CR6</th>\n",
       "      <th>CR7</th>\n",
       "      <th>CR8</th>\n",
       "      <th>CR9</th>\n",
       "      <th>Score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NVDA</td>\n",
       "      <td>NVIDIA Corporation</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TSM</td>\n",
       "      <td>Taiwan Semiconductor Manufacturing Company Lim...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AVGO</td>\n",
       "      <td>Broadcom Inc.</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AMD</td>\n",
       "      <td>Advanced Micro Devices, Inc.</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>INTC</td>\n",
       "      <td>Intel Corporation</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>QCOM</td>\n",
       "      <td>QUALCOMM Incorporated</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>TXN</td>\n",
       "      <td>Texas Instruments Incorporated</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>ADI</td>\n",
       "      <td>Analog Devices, Inc.</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>MU</td>\n",
       "      <td>Micron Technology, Inc.</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>ARM</td>\n",
       "      <td>Arm Holdings plc</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>MRVL</td>\n",
       "      <td>Marvell Technology, Inc.</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>MPWR</td>\n",
       "      <td>Monolithic Power Systems, Inc.</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>MCHP</td>\n",
       "      <td>Microchip Technology Incorporated</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>ON</td>\n",
       "      <td>ON Semiconductor Corporation</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>STM</td>\n",
       "      <td>STMicroelectronics N.V.</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Symbol                                               Name  CR1  CR2  CR3  \\\n",
       "0    NVDA                                 NVIDIA Corporation    1    1    1   \n",
       "1     TSM  Taiwan Semiconductor Manufacturing Company Lim...    1    1    1   \n",
       "2    AVGO                                      Broadcom Inc.    1    1    1   \n",
       "3     AMD                       Advanced Micro Devices, Inc.    1    1    1   \n",
       "4    INTC                                  Intel Corporation    1    1    1   \n",
       "5    QCOM                              QUALCOMM Incorporated    1    1    1   \n",
       "6     TXN                     Texas Instruments Incorporated    1    1    1   \n",
       "7     ADI                               Analog Devices, Inc.    1    1    1   \n",
       "8      MU                            Micron Technology, Inc.    0    0    1   \n",
       "9     ARM                                   Arm Holdings plc    1    1    1   \n",
       "10   MRVL                           Marvell Technology, Inc.    0    0    1   \n",
       "11   MPWR                     Monolithic Power Systems, Inc.    1    1    1   \n",
       "12   MCHP                  Microchip Technology Incorporated    1    1    1   \n",
       "13     ON                       ON Semiconductor Corporation    1    1    1   \n",
       "14    STM                            STMicroelectronics N.V.    1    1    1   \n",
       "\n",
       "    CR4  CR5  CR6  CR7  CR8  CR9  Score  \n",
       "0     1    1    0    1    0    0      6  \n",
       "1     1    0    1    1    1    1      8  \n",
       "2     1    1    1    1    1    1      9  \n",
       "3     1    1    1    0    1    0      7  \n",
       "4     1    0    1    0    0    0      5  \n",
       "5     1    0    1    0    0    0      5  \n",
       "6     0    0    0    1    0    0      4  \n",
       "7     1    1    1    1    1    1      9  \n",
       "8     1    0    0    0    0    0      2  \n",
       "9     1    0    1    1    1    0      7  \n",
       "10    1    1    0    1    1    0      5  \n",
       "11    0    0    1    0    1    1      6  \n",
       "12    1    1    1    1    1    1      9  \n",
       "13    1    0    1    0    1    1      7  \n",
       "14    1    0    1    1    1    1      8  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ps_criteria, ps_criteria_data = calculate_piotroski_score()\n",
    "ps_criteria_df = pd.DataFrame(ps_criteria)\n",
    "# Add ranking scores to get the total score\n",
    "ps_criteria_df['Score'] = ps_criteria_df[CRITERIA[:-1]].sum(axis=1)\n",
    "ps_criteria_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "30d84f9e-fc47-4add-98e6-5180c24559fb",
   "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>Symbol</th>\n",
       "      <th>Name</th>\n",
       "      <th>CR1</th>\n",
       "      <th>CR2</th>\n",
       "      <th>CR3</th>\n",
       "      <th>CR4</th>\n",
       "      <th>CR5</th>\n",
       "      <th>CR6</th>\n",
       "      <th>CR7</th>\n",
       "      <th>CR8</th>\n",
       "      <th>CR9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NVDA</td>\n",
       "      <td>NVIDIA Corporation</td>\n",
       "      <td>4.368000e+09</td>\n",
       "      <td>0.10</td>\n",
       "      <td>5.641000e+09</td>\n",
       "      <td>1</td>\n",
       "      <td>1.243000e+09</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>1.000000e+06</td>\n",
       "      <td>-0.080001</td>\n",
       "      <td>-0.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TSM</td>\n",
       "      <td>Taiwan Semiconductor Manufacturing Company Lim...</td>\n",
       "      <td>9.929234e+11</td>\n",
       "      <td>0.23</td>\n",
       "      <td>1.610599e+12</td>\n",
       "      <td>1</td>\n",
       "      <td>-2.257167e+11</td>\n",
       "      <td>0.06</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.079320</td>\n",
       "      <td>0.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AVGO</td>\n",
       "      <td>Broadcom Inc.</td>\n",
       "      <td>1.408200e+10</td>\n",
       "      <td>0.19</td>\n",
       "      <td>1.808500e+10</td>\n",
       "      <td>1</td>\n",
       "      <td>1.436000e+09</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.023847</td>\n",
       "      <td>0.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AMD</td>\n",
       "      <td>Advanced Micro Devices, Inc.</td>\n",
       "      <td>8.540000e+08</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1.667000e+09</td>\n",
       "      <td>1</td>\n",
       "      <td>7.500000e+08</td>\n",
       "      <td>0.39</td>\n",
       "      <td>-1.000000e+06</td>\n",
       "      <td>0.011939</td>\n",
       "      <td>-0.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>INTC</td>\n",
       "      <td>Intel Corporation</td>\n",
       "      <td>1.689000e+09</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1.147100e+10</td>\n",
       "      <td>1</td>\n",
       "      <td>-9.294000e+09</td>\n",
       "      <td>0.04</td>\n",
       "      <td>-5.069000e+09</td>\n",
       "      <td>-0.025714</td>\n",
       "      <td>-0.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>QCOM</td>\n",
       "      <td>QUALCOMM Incorporated</td>\n",
       "      <td>7.232000e+09</td>\n",
       "      <td>0.14</td>\n",
       "      <td>1.129900e+10</td>\n",
       "      <td>1</td>\n",
       "      <td>-9.470000e+08</td>\n",
       "      <td>0.15</td>\n",
       "      <td>-2.950000e+08</td>\n",
       "      <td>-0.021414</td>\n",
       "      <td>-0.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>TXN</td>\n",
       "      <td>Texas Instruments Incorporated</td>\n",
       "      <td>6.510000e+09</td>\n",
       "      <td>0.22</td>\n",
       "      <td>6.420000e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>-2.389000e+09</td>\n",
       "      <td>-0.06</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>-0.058613</td>\n",
       "      <td>-0.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>ADI</td>\n",
       "      <td>Analog Devices, Inc.</td>\n",
       "      <td>3.314579e+09</td>\n",
       "      <td>0.07</td>\n",
       "      <td>4.817634e+09</td>\n",
       "      <td>1</td>\n",
       "      <td>6.461680e+08</td>\n",
       "      <td>0.05</td>\n",
       "      <td>2.168000e+06</td>\n",
       "      <td>0.013159</td>\n",
       "      <td>0.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>MU</td>\n",
       "      <td>Micron Technology, Inc.</td>\n",
       "      <td>-5.833000e+09</td>\n",
       "      <td>-0.09</td>\n",
       "      <td>1.559000e+09</td>\n",
       "      <td>1</td>\n",
       "      <td>-5.923000e+09</td>\n",
       "      <td>-0.86</td>\n",
       "      <td>-1.000000e+06</td>\n",
       "      <td>-0.542970</td>\n",
       "      <td>-0.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>ARM</td>\n",
       "      <td>Arm Holdings plc</td>\n",
       "      <td>5.240000e+08</td>\n",
       "      <td>0.08</td>\n",
       "      <td>7.390000e+08</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.24</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.008898</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>MRVL</td>\n",
       "      <td>Marvell Technology, Inc.</td>\n",
       "      <td>-1.635000e+08</td>\n",
       "      <td>-0.01</td>\n",
       "      <td>1.288800e+09</td>\n",
       "      <td>1</td>\n",
       "      <td>5.771000e+08</td>\n",
       "      <td>-0.18</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.042103</td>\n",
       "      <td>-0.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>MPWR</td>\n",
       "      <td>Monolithic Power Systems, Inc.</td>\n",
       "      <td>4.376720e+08</td>\n",
       "      <td>0.24</td>\n",
       "      <td>2.466740e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.64</td>\n",
       "      <td>-1.720500e+08</td>\n",
       "      <td>0.016901</td>\n",
       "      <td>0.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>MCHP</td>\n",
       "      <td>Microchip Technology Incorporated</td>\n",
       "      <td>2.237700e+09</td>\n",
       "      <td>0.14</td>\n",
       "      <td>3.621000e+09</td>\n",
       "      <td>1</td>\n",
       "      <td>2.645700e+09</td>\n",
       "      <td>0.09</td>\n",
       "      <td>1.000000e+05</td>\n",
       "      <td>0.022863</td>\n",
       "      <td>0.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>ON</td>\n",
       "      <td>ON Semiconductor Corporation</td>\n",
       "      <td>1.902200e+09</td>\n",
       "      <td>0.18</td>\n",
       "      <td>2.633100e+09</td>\n",
       "      <td>1</td>\n",
       "      <td>-1.318000e+08</td>\n",
       "      <td>0.16</td>\n",
       "      <td>-1.000000e+05</td>\n",
       "      <td>0.086956</td>\n",
       "      <td>0.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>STM</td>\n",
       "      <td>STMicroelectronics N.V.</td>\n",
       "      <td>3.960000e+09</td>\n",
       "      <td>0.22</td>\n",
       "      <td>5.202000e+09</td>\n",
       "      <td>1</td>\n",
       "      <td>-1.460000e+08</td>\n",
       "      <td>0.29</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.056035</td>\n",
       "      <td>0.06</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Symbol                                               Name           CR1  \\\n",
       "0    NVDA                                 NVIDIA Corporation  4.368000e+09   \n",
       "1     TSM  Taiwan Semiconductor Manufacturing Company Lim...  9.929234e+11   \n",
       "2    AVGO                                      Broadcom Inc.  1.408200e+10   \n",
       "3     AMD                       Advanced Micro Devices, Inc.  8.540000e+08   \n",
       "4    INTC                                  Intel Corporation  1.689000e+09   \n",
       "5    QCOM                              QUALCOMM Incorporated  7.232000e+09   \n",
       "6     TXN                     Texas Instruments Incorporated  6.510000e+09   \n",
       "7     ADI                               Analog Devices, Inc.  3.314579e+09   \n",
       "8      MU                            Micron Technology, Inc. -5.833000e+09   \n",
       "9     ARM                                   Arm Holdings plc  5.240000e+08   \n",
       "10   MRVL                           Marvell Technology, Inc. -1.635000e+08   \n",
       "11   MPWR                     Monolithic Power Systems, Inc.  4.376720e+08   \n",
       "12   MCHP                  Microchip Technology Incorporated  2.237700e+09   \n",
       "13     ON                       ON Semiconductor Corporation  1.902200e+09   \n",
       "14    STM                            STMicroelectronics N.V.  3.960000e+09   \n",
       "\n",
       "     CR2           CR3  CR4           CR5   CR6           CR7       CR8   CR9  \n",
       "0   0.10  5.641000e+09    1  1.243000e+09 -0.36  1.000000e+06 -0.080001 -0.11  \n",
       "1   0.23  1.610599e+12    1 -2.257167e+11  0.06  0.000000e+00  0.079320  0.03  \n",
       "2   0.19  1.808500e+10    1  1.436000e+09  0.04  0.000000e+00  0.023847  0.04  \n",
       "3   0.01  1.667000e+09    1  7.500000e+08  0.39 -1.000000e+06  0.011939 -0.26  \n",
       "4   0.01  1.147100e+10    1 -9.294000e+09  0.04 -5.069000e+09 -0.025714 -0.07  \n",
       "5   0.14  1.129900e+10    1 -9.470000e+08  0.15 -2.950000e+08 -0.021414 -0.26  \n",
       "6   0.22  6.420000e+09    0 -2.389000e+09 -0.06  0.000000e+00 -0.058613 -0.18  \n",
       "7   0.07  4.817634e+09    1  6.461680e+08  0.05  2.168000e+06  0.013159  0.01  \n",
       "8  -0.09  1.559000e+09    1 -5.923000e+09 -0.86 -1.000000e+06 -0.542970 -0.25  \n",
       "9   0.08  7.390000e+08    1           NaN  0.24  0.000000e+00  0.008898   NaN  \n",
       "10 -0.01  1.288800e+09    1  5.771000e+08 -0.18  0.000000e+00  0.042103 -0.01  \n",
       "11  0.24  2.466740e+08    0           NaN  0.64 -1.720500e+08  0.016901  0.12  \n",
       "12  0.14  3.621000e+09    1  2.645700e+09  0.09  1.000000e+05  0.022863  0.10  \n",
       "13  0.18  2.633100e+09    1 -1.318000e+08  0.16 -1.000000e+05  0.086956  0.03  \n",
       "14  0.22  5.202000e+09    1 -1.460000e+08  0.29  0.000000e+00  0.056035  0.06  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ps_criteria_data_df = pd.DataFrame(ps_criteria_data)\n",
    "ps_criteria_data_df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9c73f5aa-34f9-4ac3-bfd6-3dc7d50f5c52",
   "metadata": {},
   "source": [
    "## Utility method to convert a number to human readable format\n",
    "#### https://stackoverflow.com/questions/579310/formatting-long-numbers-as-strings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "4eed403a-38ca-4512-9353-cc2724916e9f",
   "metadata": {},
   "outputs": [],
   "source": [
    "def human_format(num):\n",
    "    if np.isnan(num):\n",
    "        return 'nan'\n",
    "    # Check for zero or else it will return an empty string\n",
    "    elif num == 0:\n",
    "        return '0'\n",
    "    num = float('{:.3g}'.format(num))\n",
    "    magnitude = 0\n",
    "    while abs(num) >= 1000:\n",
    "        magnitude += 1\n",
    "        num /= 1000.0\n",
    "    return '{}{}'.format('{:f}'.format(num).rstrip('0.'), ['', 'K', 'M', 'B', 'T'][magnitude])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b1495cf2-a2fc-47d8-a20b-6b1e2687a04c",
   "metadata": {},
   "source": [
    "## Add Styles to Score DF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "aa736077-e17b-4946-89c3-3e7b7ea295bd",
   "metadata": {},
   "outputs": [],
   "source": [
    "def make_pretty_score(styler):\n",
    "    # Columns with 0 decimal points\n",
    "    zero_formats = {}\n",
    "    for idx in range(1,10):\n",
    "        zero_formats[f'CR{idx}']='{:.0f}'        \n",
    "    styler.format(zero_formats)\n",
    "    \n",
    "    # Hide index\n",
    "    styler.hide(axis='index')\n",
    "\n",
    "    # Left text alignment for Symbol and Name columns\n",
    "    styler.set_properties(subset=['Symbol', 'Name'], **{'text-align': 'left'})\n",
    "    # Center alignment for the rest\n",
    "    styler.set_properties(subset=CRITERIA, **{'text-align': 'center'})\n",
    "\n",
    "    # Set background gradients\n",
    "    styler.background_gradient(subset=['Score'], cmap='PiYG')\n",
    "    \n",
    "    # Borders\n",
    "    styler.set_properties(**{'border': '1px solid grey'})\n",
    "    return styler\n",
    "\n",
    "def column_formatter_score(name):\n",
    "    return COLUMN_MAPPING_SCORE[name]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a581c2b1-52fd-46f3-92a1-5560d08a8de6",
   "metadata": {},
   "source": [
    "## Apply styles to Score DF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "60c09f73-6cd7-4fc5-b0e7-839bddb6c292",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_7db8a th.col_heading {\n",
       "  text-align: center;\n",
       "  color: bisque;\n",
       "  font-size: 10pt;\n",
       "}\n",
       "#T_7db8a td {\n",
       "  font-size: 10pt;\n",
       "}\n",
       "#T_7db8a caption {\n",
       "  text-align: center;\n",
       "  color: goldenrod;\n",
       "  font-size: 14pt;\n",
       "  font-weight: bold;\n",
       "}\n",
       "#T_7db8a_row0_col0, #T_7db8a_row0_col1, #T_7db8a_row1_col0, #T_7db8a_row1_col1, #T_7db8a_row2_col0, #T_7db8a_row2_col1, #T_7db8a_row3_col0, #T_7db8a_row3_col1, #T_7db8a_row4_col0, #T_7db8a_row4_col1, #T_7db8a_row5_col0, #T_7db8a_row5_col1, #T_7db8a_row6_col0, #T_7db8a_row6_col1, #T_7db8a_row7_col0, #T_7db8a_row7_col1, #T_7db8a_row8_col0, #T_7db8a_row8_col1, #T_7db8a_row9_col0, #T_7db8a_row9_col1, #T_7db8a_row10_col0, #T_7db8a_row10_col1, #T_7db8a_row11_col0, #T_7db8a_row11_col1, #T_7db8a_row12_col0, #T_7db8a_row12_col1, #T_7db8a_row13_col0, #T_7db8a_row13_col1, #T_7db8a_row14_col0, #T_7db8a_row14_col1 {\n",
       "  text-align: left;\n",
       "  border: 1px solid grey;\n",
       "}\n",
       "#T_7db8a_row0_col2, #T_7db8a_row0_col3, #T_7db8a_row0_col4, #T_7db8a_row0_col5, #T_7db8a_row0_col6, #T_7db8a_row0_col7, #T_7db8a_row0_col8, #T_7db8a_row0_col9, #T_7db8a_row0_col10, #T_7db8a_row1_col2, #T_7db8a_row1_col3, #T_7db8a_row1_col4, #T_7db8a_row1_col5, #T_7db8a_row1_col6, #T_7db8a_row1_col7, #T_7db8a_row1_col8, #T_7db8a_row1_col9, #T_7db8a_row1_col10, #T_7db8a_row2_col2, #T_7db8a_row2_col3, #T_7db8a_row2_col4, #T_7db8a_row2_col5, #T_7db8a_row2_col6, #T_7db8a_row2_col7, #T_7db8a_row2_col8, #T_7db8a_row2_col9, #T_7db8a_row2_col10, #T_7db8a_row3_col2, #T_7db8a_row3_col3, #T_7db8a_row3_col4, #T_7db8a_row3_col5, #T_7db8a_row3_col6, #T_7db8a_row3_col7, #T_7db8a_row3_col8, #T_7db8a_row3_col9, #T_7db8a_row3_col10, #T_7db8a_row4_col2, #T_7db8a_row4_col3, #T_7db8a_row4_col4, #T_7db8a_row4_col5, #T_7db8a_row4_col6, #T_7db8a_row4_col7, #T_7db8a_row4_col8, #T_7db8a_row4_col9, #T_7db8a_row4_col10, #T_7db8a_row5_col2, #T_7db8a_row5_col3, #T_7db8a_row5_col4, #T_7db8a_row5_col5, #T_7db8a_row5_col6, #T_7db8a_row5_col7, #T_7db8a_row5_col8, #T_7db8a_row5_col9, #T_7db8a_row5_col10, #T_7db8a_row6_col2, #T_7db8a_row6_col3, #T_7db8a_row6_col4, #T_7db8a_row6_col5, #T_7db8a_row6_col6, #T_7db8a_row6_col7, #T_7db8a_row6_col8, #T_7db8a_row6_col9, #T_7db8a_row6_col10, #T_7db8a_row7_col2, #T_7db8a_row7_col3, #T_7db8a_row7_col4, #T_7db8a_row7_col5, #T_7db8a_row7_col6, #T_7db8a_row7_col7, #T_7db8a_row7_col8, #T_7db8a_row7_col9, #T_7db8a_row7_col10, #T_7db8a_row8_col2, #T_7db8a_row8_col3, #T_7db8a_row8_col4, #T_7db8a_row8_col5, #T_7db8a_row8_col6, #T_7db8a_row8_col7, #T_7db8a_row8_col8, #T_7db8a_row8_col9, #T_7db8a_row8_col10, #T_7db8a_row9_col2, #T_7db8a_row9_col3, #T_7db8a_row9_col4, #T_7db8a_row9_col5, #T_7db8a_row9_col6, #T_7db8a_row9_col7, #T_7db8a_row9_col8, #T_7db8a_row9_col9, #T_7db8a_row9_col10, #T_7db8a_row10_col2, #T_7db8a_row10_col3, #T_7db8a_row10_col4, #T_7db8a_row10_col5, #T_7db8a_row10_col6, #T_7db8a_row10_col7, #T_7db8a_row10_col8, #T_7db8a_row10_col9, #T_7db8a_row10_col10, #T_7db8a_row11_col2, #T_7db8a_row11_col3, #T_7db8a_row11_col4, #T_7db8a_row11_col5, #T_7db8a_row11_col6, #T_7db8a_row11_col7, #T_7db8a_row11_col8, #T_7db8a_row11_col9, #T_7db8a_row11_col10, #T_7db8a_row12_col2, #T_7db8a_row12_col3, #T_7db8a_row12_col4, #T_7db8a_row12_col5, #T_7db8a_row12_col6, #T_7db8a_row12_col7, #T_7db8a_row12_col8, #T_7db8a_row12_col9, #T_7db8a_row12_col10, #T_7db8a_row13_col2, #T_7db8a_row13_col3, #T_7db8a_row13_col4, #T_7db8a_row13_col5, #T_7db8a_row13_col6, #T_7db8a_row13_col7, #T_7db8a_row13_col8, #T_7db8a_row13_col9, #T_7db8a_row13_col10, #T_7db8a_row14_col2, #T_7db8a_row14_col3, #T_7db8a_row14_col4, #T_7db8a_row14_col5, #T_7db8a_row14_col6, #T_7db8a_row14_col7, #T_7db8a_row14_col8, #T_7db8a_row14_col9, #T_7db8a_row14_col10 {\n",
       "  text-align: center;\n",
       "  border: 1px solid grey;\n",
       "}\n",
       "#T_7db8a_row0_col11, #T_7db8a_row11_col11 {\n",
       "  text-align: center;\n",
       "  background-color: #ebf6db;\n",
       "  color: #000000;\n",
       "  border: 1px solid grey;\n",
       "}\n",
       "#T_7db8a_row1_col11, #T_7db8a_row14_col11 {\n",
       "  text-align: center;\n",
       "  background-color: #62a32e;\n",
       "  color: #f1f1f1;\n",
       "  border: 1px solid grey;\n",
       "}\n",
       "#T_7db8a_row2_col11, #T_7db8a_row7_col11, #T_7db8a_row12_col11 {\n",
       "  text-align: center;\n",
       "  background-color: #276419;\n",
       "  color: #f1f1f1;\n",
       "  border: 1px solid grey;\n",
       "}\n",
       "#T_7db8a_row3_col11, #T_7db8a_row9_col11, #T_7db8a_row13_col11 {\n",
       "  text-align: center;\n",
       "  background-color: #b0dc7d;\n",
       "  color: #000000;\n",
       "  border: 1px solid grey;\n",
       "}\n",
       "#T_7db8a_row4_col11, #T_7db8a_row5_col11, #T_7db8a_row10_col11 {\n",
       "  text-align: center;\n",
       "  background-color: #fbe6f1;\n",
       "  color: #000000;\n",
       "  border: 1px solid grey;\n",
       "}\n",
       "#T_7db8a_row6_col11 {\n",
       "  text-align: center;\n",
       "  background-color: #eeadd4;\n",
       "  color: #000000;\n",
       "  border: 1px solid grey;\n",
       "}\n",
       "#T_7db8a_row8_col11 {\n",
       "  text-align: center;\n",
       "  background-color: #8e0152;\n",
       "  color: #f1f1f1;\n",
       "  border: 1px solid grey;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_7db8a\">\n",
       "  <caption>Piotroski Score Technology - Semiconductors</caption>\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th id=\"T_7db8a_level0_col0\" class=\"col_heading level0 col0\" >Symbol</th>\n",
       "      <th id=\"T_7db8a_level0_col1\" class=\"col_heading level0 col1\" >Name</th>\n",
       "      <th id=\"T_7db8a_level0_col2\" class=\"col_heading level0 col2\" >Net Income</th>\n",
       "      <th id=\"T_7db8a_level0_col3\" class=\"col_heading level0 col3\" >Return on Assets</th>\n",
       "      <th id=\"T_7db8a_level0_col4\" class=\"col_heading level0 col4\" >Op. Cash Flow</th>\n",
       "      <th id=\"T_7db8a_level0_col5\" class=\"col_heading level0 col5\" >Quality of Earn</th>\n",
       "      <th id=\"T_7db8a_level0_col6\" class=\"col_heading level0 col6\" >Long Term Debt</th>\n",
       "      <th id=\"T_7db8a_level0_col7\" class=\"col_heading level0 col7\" >Current Ratio</th>\n",
       "      <th id=\"T_7db8a_level0_col8\" class=\"col_heading level0 col8\" >New Shares</th>\n",
       "      <th id=\"T_7db8a_level0_col9\" class=\"col_heading level0 col9\" >Gross Margin</th>\n",
       "      <th id=\"T_7db8a_level0_col10\" class=\"col_heading level0 col10\" >Asset TR</th>\n",
       "      <th id=\"T_7db8a_level0_col11\" class=\"col_heading level0 col11\" >Score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td id=\"T_7db8a_row0_col0\" class=\"data row0 col0\" >NVDA</td>\n",
       "      <td id=\"T_7db8a_row0_col1\" class=\"data row0 col1\" >NVIDIA Corporation</td>\n",
       "      <td id=\"T_7db8a_row0_col2\" class=\"data row0 col2\" >1</td>\n",
       "      <td id=\"T_7db8a_row0_col3\" class=\"data row0 col3\" >1</td>\n",
       "      <td id=\"T_7db8a_row0_col4\" class=\"data row0 col4\" >1</td>\n",
       "      <td id=\"T_7db8a_row0_col5\" class=\"data row0 col5\" >1</td>\n",
       "      <td id=\"T_7db8a_row0_col6\" class=\"data row0 col6\" >1</td>\n",
       "      <td id=\"T_7db8a_row0_col7\" class=\"data row0 col7\" >0</td>\n",
       "      <td id=\"T_7db8a_row0_col8\" class=\"data row0 col8\" >1</td>\n",
       "      <td id=\"T_7db8a_row0_col9\" class=\"data row0 col9\" >0</td>\n",
       "      <td id=\"T_7db8a_row0_col10\" class=\"data row0 col10\" >0</td>\n",
       "      <td id=\"T_7db8a_row0_col11\" class=\"data row0 col11\" >6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7db8a_row1_col0\" class=\"data row1 col0\" >TSM</td>\n",
       "      <td id=\"T_7db8a_row1_col1\" class=\"data row1 col1\" >Taiwan Semiconductor Manufacturing Company Limited</td>\n",
       "      <td id=\"T_7db8a_row1_col2\" class=\"data row1 col2\" >1</td>\n",
       "      <td id=\"T_7db8a_row1_col3\" class=\"data row1 col3\" >1</td>\n",
       "      <td id=\"T_7db8a_row1_col4\" class=\"data row1 col4\" >1</td>\n",
       "      <td id=\"T_7db8a_row1_col5\" class=\"data row1 col5\" >1</td>\n",
       "      <td id=\"T_7db8a_row1_col6\" class=\"data row1 col6\" >0</td>\n",
       "      <td id=\"T_7db8a_row1_col7\" class=\"data row1 col7\" >1</td>\n",
       "      <td id=\"T_7db8a_row1_col8\" class=\"data row1 col8\" >1</td>\n",
       "      <td id=\"T_7db8a_row1_col9\" class=\"data row1 col9\" >1</td>\n",
       "      <td id=\"T_7db8a_row1_col10\" class=\"data row1 col10\" >1</td>\n",
       "      <td id=\"T_7db8a_row1_col11\" class=\"data row1 col11\" >8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7db8a_row2_col0\" class=\"data row2 col0\" >AVGO</td>\n",
       "      <td id=\"T_7db8a_row2_col1\" class=\"data row2 col1\" >Broadcom Inc.</td>\n",
       "      <td id=\"T_7db8a_row2_col2\" class=\"data row2 col2\" >1</td>\n",
       "      <td id=\"T_7db8a_row2_col3\" class=\"data row2 col3\" >1</td>\n",
       "      <td id=\"T_7db8a_row2_col4\" class=\"data row2 col4\" >1</td>\n",
       "      <td id=\"T_7db8a_row2_col5\" class=\"data row2 col5\" >1</td>\n",
       "      <td id=\"T_7db8a_row2_col6\" class=\"data row2 col6\" >1</td>\n",
       "      <td id=\"T_7db8a_row2_col7\" class=\"data row2 col7\" >1</td>\n",
       "      <td id=\"T_7db8a_row2_col8\" class=\"data row2 col8\" >1</td>\n",
       "      <td id=\"T_7db8a_row2_col9\" class=\"data row2 col9\" >1</td>\n",
       "      <td id=\"T_7db8a_row2_col10\" class=\"data row2 col10\" >1</td>\n",
       "      <td id=\"T_7db8a_row2_col11\" class=\"data row2 col11\" >9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7db8a_row3_col0\" class=\"data row3 col0\" >AMD</td>\n",
       "      <td id=\"T_7db8a_row3_col1\" class=\"data row3 col1\" >Advanced Micro Devices, Inc.</td>\n",
       "      <td id=\"T_7db8a_row3_col2\" class=\"data row3 col2\" >1</td>\n",
       "      <td id=\"T_7db8a_row3_col3\" class=\"data row3 col3\" >1</td>\n",
       "      <td id=\"T_7db8a_row3_col4\" class=\"data row3 col4\" >1</td>\n",
       "      <td id=\"T_7db8a_row3_col5\" class=\"data row3 col5\" >1</td>\n",
       "      <td id=\"T_7db8a_row3_col6\" class=\"data row3 col6\" >1</td>\n",
       "      <td id=\"T_7db8a_row3_col7\" class=\"data row3 col7\" >1</td>\n",
       "      <td id=\"T_7db8a_row3_col8\" class=\"data row3 col8\" >0</td>\n",
       "      <td id=\"T_7db8a_row3_col9\" class=\"data row3 col9\" >1</td>\n",
       "      <td id=\"T_7db8a_row3_col10\" class=\"data row3 col10\" >0</td>\n",
       "      <td id=\"T_7db8a_row3_col11\" class=\"data row3 col11\" >7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7db8a_row4_col0\" class=\"data row4 col0\" >INTC</td>\n",
       "      <td id=\"T_7db8a_row4_col1\" class=\"data row4 col1\" >Intel Corporation</td>\n",
       "      <td id=\"T_7db8a_row4_col2\" class=\"data row4 col2\" >1</td>\n",
       "      <td id=\"T_7db8a_row4_col3\" class=\"data row4 col3\" >1</td>\n",
       "      <td id=\"T_7db8a_row4_col4\" class=\"data row4 col4\" >1</td>\n",
       "      <td id=\"T_7db8a_row4_col5\" class=\"data row4 col5\" >1</td>\n",
       "      <td id=\"T_7db8a_row4_col6\" class=\"data row4 col6\" >0</td>\n",
       "      <td id=\"T_7db8a_row4_col7\" class=\"data row4 col7\" >1</td>\n",
       "      <td id=\"T_7db8a_row4_col8\" class=\"data row4 col8\" >0</td>\n",
       "      <td id=\"T_7db8a_row4_col9\" class=\"data row4 col9\" >0</td>\n",
       "      <td id=\"T_7db8a_row4_col10\" class=\"data row4 col10\" >0</td>\n",
       "      <td id=\"T_7db8a_row4_col11\" class=\"data row4 col11\" >5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7db8a_row5_col0\" class=\"data row5 col0\" >QCOM</td>\n",
       "      <td id=\"T_7db8a_row5_col1\" class=\"data row5 col1\" >QUALCOMM Incorporated</td>\n",
       "      <td id=\"T_7db8a_row5_col2\" class=\"data row5 col2\" >1</td>\n",
       "      <td id=\"T_7db8a_row5_col3\" class=\"data row5 col3\" >1</td>\n",
       "      <td id=\"T_7db8a_row5_col4\" class=\"data row5 col4\" >1</td>\n",
       "      <td id=\"T_7db8a_row5_col5\" class=\"data row5 col5\" >1</td>\n",
       "      <td id=\"T_7db8a_row5_col6\" class=\"data row5 col6\" >0</td>\n",
       "      <td id=\"T_7db8a_row5_col7\" class=\"data row5 col7\" >1</td>\n",
       "      <td id=\"T_7db8a_row5_col8\" class=\"data row5 col8\" >0</td>\n",
       "      <td id=\"T_7db8a_row5_col9\" class=\"data row5 col9\" >0</td>\n",
       "      <td id=\"T_7db8a_row5_col10\" class=\"data row5 col10\" >0</td>\n",
       "      <td id=\"T_7db8a_row5_col11\" class=\"data row5 col11\" >5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7db8a_row6_col0\" class=\"data row6 col0\" >TXN</td>\n",
       "      <td id=\"T_7db8a_row6_col1\" class=\"data row6 col1\" >Texas Instruments Incorporated</td>\n",
       "      <td id=\"T_7db8a_row6_col2\" class=\"data row6 col2\" >1</td>\n",
       "      <td id=\"T_7db8a_row6_col3\" class=\"data row6 col3\" >1</td>\n",
       "      <td id=\"T_7db8a_row6_col4\" class=\"data row6 col4\" >1</td>\n",
       "      <td id=\"T_7db8a_row6_col5\" class=\"data row6 col5\" >0</td>\n",
       "      <td id=\"T_7db8a_row6_col6\" class=\"data row6 col6\" >0</td>\n",
       "      <td id=\"T_7db8a_row6_col7\" class=\"data row6 col7\" >0</td>\n",
       "      <td id=\"T_7db8a_row6_col8\" class=\"data row6 col8\" >1</td>\n",
       "      <td id=\"T_7db8a_row6_col9\" class=\"data row6 col9\" >0</td>\n",
       "      <td id=\"T_7db8a_row6_col10\" class=\"data row6 col10\" >0</td>\n",
       "      <td id=\"T_7db8a_row6_col11\" class=\"data row6 col11\" >4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7db8a_row7_col0\" class=\"data row7 col0\" >ADI</td>\n",
       "      <td id=\"T_7db8a_row7_col1\" class=\"data row7 col1\" >Analog Devices, Inc.</td>\n",
       "      <td id=\"T_7db8a_row7_col2\" class=\"data row7 col2\" >1</td>\n",
       "      <td id=\"T_7db8a_row7_col3\" class=\"data row7 col3\" >1</td>\n",
       "      <td id=\"T_7db8a_row7_col4\" class=\"data row7 col4\" >1</td>\n",
       "      <td id=\"T_7db8a_row7_col5\" class=\"data row7 col5\" >1</td>\n",
       "      <td id=\"T_7db8a_row7_col6\" class=\"data row7 col6\" >1</td>\n",
       "      <td id=\"T_7db8a_row7_col7\" class=\"data row7 col7\" >1</td>\n",
       "      <td id=\"T_7db8a_row7_col8\" class=\"data row7 col8\" >1</td>\n",
       "      <td id=\"T_7db8a_row7_col9\" class=\"data row7 col9\" >1</td>\n",
       "      <td id=\"T_7db8a_row7_col10\" class=\"data row7 col10\" >1</td>\n",
       "      <td id=\"T_7db8a_row7_col11\" class=\"data row7 col11\" >9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7db8a_row8_col0\" class=\"data row8 col0\" >MU</td>\n",
       "      <td id=\"T_7db8a_row8_col1\" class=\"data row8 col1\" >Micron Technology, Inc.</td>\n",
       "      <td id=\"T_7db8a_row8_col2\" class=\"data row8 col2\" >0</td>\n",
       "      <td id=\"T_7db8a_row8_col3\" class=\"data row8 col3\" >0</td>\n",
       "      <td id=\"T_7db8a_row8_col4\" class=\"data row8 col4\" >1</td>\n",
       "      <td id=\"T_7db8a_row8_col5\" class=\"data row8 col5\" >1</td>\n",
       "      <td id=\"T_7db8a_row8_col6\" class=\"data row8 col6\" >0</td>\n",
       "      <td id=\"T_7db8a_row8_col7\" class=\"data row8 col7\" >0</td>\n",
       "      <td id=\"T_7db8a_row8_col8\" class=\"data row8 col8\" >0</td>\n",
       "      <td id=\"T_7db8a_row8_col9\" class=\"data row8 col9\" >0</td>\n",
       "      <td id=\"T_7db8a_row8_col10\" class=\"data row8 col10\" >0</td>\n",
       "      <td id=\"T_7db8a_row8_col11\" class=\"data row8 col11\" >2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7db8a_row9_col0\" class=\"data row9 col0\" >ARM</td>\n",
       "      <td id=\"T_7db8a_row9_col1\" class=\"data row9 col1\" >Arm Holdings plc</td>\n",
       "      <td id=\"T_7db8a_row9_col2\" class=\"data row9 col2\" >1</td>\n",
       "      <td id=\"T_7db8a_row9_col3\" class=\"data row9 col3\" >1</td>\n",
       "      <td id=\"T_7db8a_row9_col4\" class=\"data row9 col4\" >1</td>\n",
       "      <td id=\"T_7db8a_row9_col5\" class=\"data row9 col5\" >1</td>\n",
       "      <td id=\"T_7db8a_row9_col6\" class=\"data row9 col6\" >0</td>\n",
       "      <td id=\"T_7db8a_row9_col7\" class=\"data row9 col7\" >1</td>\n",
       "      <td id=\"T_7db8a_row9_col8\" class=\"data row9 col8\" >1</td>\n",
       "      <td id=\"T_7db8a_row9_col9\" class=\"data row9 col9\" >1</td>\n",
       "      <td id=\"T_7db8a_row9_col10\" class=\"data row9 col10\" >0</td>\n",
       "      <td id=\"T_7db8a_row9_col11\" class=\"data row9 col11\" >7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7db8a_row10_col0\" class=\"data row10 col0\" >MRVL</td>\n",
       "      <td id=\"T_7db8a_row10_col1\" class=\"data row10 col1\" >Marvell Technology, Inc.</td>\n",
       "      <td id=\"T_7db8a_row10_col2\" class=\"data row10 col2\" >0</td>\n",
       "      <td id=\"T_7db8a_row10_col3\" class=\"data row10 col3\" >0</td>\n",
       "      <td id=\"T_7db8a_row10_col4\" class=\"data row10 col4\" >1</td>\n",
       "      <td id=\"T_7db8a_row10_col5\" class=\"data row10 col5\" >1</td>\n",
       "      <td id=\"T_7db8a_row10_col6\" class=\"data row10 col6\" >1</td>\n",
       "      <td id=\"T_7db8a_row10_col7\" class=\"data row10 col7\" >0</td>\n",
       "      <td id=\"T_7db8a_row10_col8\" class=\"data row10 col8\" >1</td>\n",
       "      <td id=\"T_7db8a_row10_col9\" class=\"data row10 col9\" >1</td>\n",
       "      <td id=\"T_7db8a_row10_col10\" class=\"data row10 col10\" >0</td>\n",
       "      <td id=\"T_7db8a_row10_col11\" class=\"data row10 col11\" >5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7db8a_row11_col0\" class=\"data row11 col0\" >MPWR</td>\n",
       "      <td id=\"T_7db8a_row11_col1\" class=\"data row11 col1\" >Monolithic Power Systems, Inc.</td>\n",
       "      <td id=\"T_7db8a_row11_col2\" class=\"data row11 col2\" >1</td>\n",
       "      <td id=\"T_7db8a_row11_col3\" class=\"data row11 col3\" >1</td>\n",
       "      <td id=\"T_7db8a_row11_col4\" class=\"data row11 col4\" >1</td>\n",
       "      <td id=\"T_7db8a_row11_col5\" class=\"data row11 col5\" >0</td>\n",
       "      <td id=\"T_7db8a_row11_col6\" class=\"data row11 col6\" >0</td>\n",
       "      <td id=\"T_7db8a_row11_col7\" class=\"data row11 col7\" >1</td>\n",
       "      <td id=\"T_7db8a_row11_col8\" class=\"data row11 col8\" >0</td>\n",
       "      <td id=\"T_7db8a_row11_col9\" class=\"data row11 col9\" >1</td>\n",
       "      <td id=\"T_7db8a_row11_col10\" class=\"data row11 col10\" >1</td>\n",
       "      <td id=\"T_7db8a_row11_col11\" class=\"data row11 col11\" >6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7db8a_row12_col0\" class=\"data row12 col0\" >MCHP</td>\n",
       "      <td id=\"T_7db8a_row12_col1\" class=\"data row12 col1\" >Microchip Technology Incorporated</td>\n",
       "      <td id=\"T_7db8a_row12_col2\" class=\"data row12 col2\" >1</td>\n",
       "      <td id=\"T_7db8a_row12_col3\" class=\"data row12 col3\" >1</td>\n",
       "      <td id=\"T_7db8a_row12_col4\" class=\"data row12 col4\" >1</td>\n",
       "      <td id=\"T_7db8a_row12_col5\" class=\"data row12 col5\" >1</td>\n",
       "      <td id=\"T_7db8a_row12_col6\" class=\"data row12 col6\" >1</td>\n",
       "      <td id=\"T_7db8a_row12_col7\" class=\"data row12 col7\" >1</td>\n",
       "      <td id=\"T_7db8a_row12_col8\" class=\"data row12 col8\" >1</td>\n",
       "      <td id=\"T_7db8a_row12_col9\" class=\"data row12 col9\" >1</td>\n",
       "      <td id=\"T_7db8a_row12_col10\" class=\"data row12 col10\" >1</td>\n",
       "      <td id=\"T_7db8a_row12_col11\" class=\"data row12 col11\" >9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7db8a_row13_col0\" class=\"data row13 col0\" >ON</td>\n",
       "      <td id=\"T_7db8a_row13_col1\" class=\"data row13 col1\" >ON Semiconductor Corporation</td>\n",
       "      <td id=\"T_7db8a_row13_col2\" class=\"data row13 col2\" >1</td>\n",
       "      <td id=\"T_7db8a_row13_col3\" class=\"data row13 col3\" >1</td>\n",
       "      <td id=\"T_7db8a_row13_col4\" class=\"data row13 col4\" >1</td>\n",
       "      <td id=\"T_7db8a_row13_col5\" class=\"data row13 col5\" >1</td>\n",
       "      <td id=\"T_7db8a_row13_col6\" class=\"data row13 col6\" >0</td>\n",
       "      <td id=\"T_7db8a_row13_col7\" class=\"data row13 col7\" >1</td>\n",
       "      <td id=\"T_7db8a_row13_col8\" class=\"data row13 col8\" >0</td>\n",
       "      <td id=\"T_7db8a_row13_col9\" class=\"data row13 col9\" >1</td>\n",
       "      <td id=\"T_7db8a_row13_col10\" class=\"data row13 col10\" >1</td>\n",
       "      <td id=\"T_7db8a_row13_col11\" class=\"data row13 col11\" >7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7db8a_row14_col0\" class=\"data row14 col0\" >STM</td>\n",
       "      <td id=\"T_7db8a_row14_col1\" class=\"data row14 col1\" >STMicroelectronics N.V.</td>\n",
       "      <td id=\"T_7db8a_row14_col2\" class=\"data row14 col2\" >1</td>\n",
       "      <td id=\"T_7db8a_row14_col3\" class=\"data row14 col3\" >1</td>\n",
       "      <td id=\"T_7db8a_row14_col4\" class=\"data row14 col4\" >1</td>\n",
       "      <td id=\"T_7db8a_row14_col5\" class=\"data row14 col5\" >1</td>\n",
       "      <td id=\"T_7db8a_row14_col6\" class=\"data row14 col6\" >0</td>\n",
       "      <td id=\"T_7db8a_row14_col7\" class=\"data row14 col7\" >1</td>\n",
       "      <td id=\"T_7db8a_row14_col8\" class=\"data row14 col8\" >1</td>\n",
       "      <td id=\"T_7db8a_row14_col9\" class=\"data row14 col9\" >1</td>\n",
       "      <td id=\"T_7db8a_row14_col10\" class=\"data row14 col10\" >1</td>\n",
       "      <td id=\"T_7db8a_row14_col11\" class=\"data row14 col11\" >8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7f0e2ff40450>"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Add table caption and styles to DF\n",
    "ps_criteria_df.style.pipe(make_pretty_score).set_caption(f'Piotroski Score {SECTOR} - {INDUSTRY}').set_table_styles(\n",
    "    [{'selector': 'th.col_heading', 'props': [('text-align', 'center'),\n",
    "                                              ('color', 'bisque'), ('font-size', '10pt')]},\n",
    "     {'selector': 'td', 'props': [('font-size', '10pt')]},\n",
    "     {'selector': 'caption', 'props': [('text-align', 'center'), ('color', 'goldenrod'),\n",
    "                                       ('font-size', '14pt'), ('font-weight', 'bold')]}]).format_index(column_formatter_score, axis=1) "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "802750d8-6919-4d9c-bfd1-3ba9cef6979a",
   "metadata": {},
   "source": [
    "## Add Styles to Raw DF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "a194a3e4-9a1e-4ea4-a170-110a54e2d96d",
   "metadata": {},
   "outputs": [],
   "source": [
    "def make_pretty_raw(styler):\n",
    "    # Columns with 2 decimal points\n",
    "    styler.format({'CR2':'{:.2f}','CR6':'{:.2f}','CR8':'{:.2f}','CR9':'{:.2f}'})\n",
    "    \n",
    "    # Apply human_fomrat for cols\n",
    "    styler.format(human_format, subset=['CR1','CR3','CR5','CR7'])\n",
    "    \n",
    "    # Hide index\n",
    "    styler.hide(axis='index')\n",
    "\n",
    "    # Left text alignment for some columns\n",
    "    styler.set_properties(subset=['Symbol', 'Name'], **{'text-align': 'left'})\n",
    "\n",
    "    # Borders\n",
    "    styler.set_properties(**{'border': '1px solid grey'})\n",
    "    return styler\n",
    "\n",
    "def column_formatter_raw(name):\n",
    "    return COLUMN_MAPPING_RAW[name]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5dd681cb-bd32-45d6-b7e9-e7852962b95e",
   "metadata": {},
   "source": [
    "## Apply styles to Raw DF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "7d0ad194-ab75-45f6-9c46-d03497de0446",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_ea852 th.col_heading {\n",
       "  text-align: center;\n",
       "  color: bisque;\n",
       "  font-size: 10pt;\n",
       "}\n",
       "#T_ea852 td {\n",
       "  font-size: 10pt;\n",
       "}\n",
       "#T_ea852 caption {\n",
       "  text-align: center;\n",
       "  color: goldenrod;\n",
       "  font-size: 14pt;\n",
       "  font-weight: bold;\n",
       "}\n",
       "#T_ea852_row0_col0, #T_ea852_row0_col1, #T_ea852_row1_col0, #T_ea852_row1_col1, #T_ea852_row2_col0, #T_ea852_row2_col1, #T_ea852_row3_col0, #T_ea852_row3_col1, #T_ea852_row4_col0, #T_ea852_row4_col1, #T_ea852_row5_col0, #T_ea852_row5_col1, #T_ea852_row6_col0, #T_ea852_row6_col1, #T_ea852_row7_col0, #T_ea852_row7_col1, #T_ea852_row8_col0, #T_ea852_row8_col1, #T_ea852_row9_col0, #T_ea852_row9_col1, #T_ea852_row10_col0, #T_ea852_row10_col1, #T_ea852_row11_col0, #T_ea852_row11_col1, #T_ea852_row12_col0, #T_ea852_row12_col1, #T_ea852_row13_col0, #T_ea852_row13_col1, #T_ea852_row14_col0, #T_ea852_row14_col1 {\n",
       "  text-align: left;\n",
       "  border: 1px solid grey;\n",
       "}\n",
       "#T_ea852_row0_col2, #T_ea852_row0_col3, #T_ea852_row0_col4, #T_ea852_row0_col5, #T_ea852_row0_col6, #T_ea852_row0_col7, #T_ea852_row0_col8, #T_ea852_row0_col9, #T_ea852_row0_col10, #T_ea852_row1_col2, #T_ea852_row1_col3, #T_ea852_row1_col4, #T_ea852_row1_col5, #T_ea852_row1_col6, #T_ea852_row1_col7, #T_ea852_row1_col8, #T_ea852_row1_col9, #T_ea852_row1_col10, #T_ea852_row2_col2, #T_ea852_row2_col3, #T_ea852_row2_col4, #T_ea852_row2_col5, #T_ea852_row2_col6, #T_ea852_row2_col7, #T_ea852_row2_col8, #T_ea852_row2_col9, #T_ea852_row2_col10, #T_ea852_row3_col2, #T_ea852_row3_col3, #T_ea852_row3_col4, #T_ea852_row3_col5, #T_ea852_row3_col6, #T_ea852_row3_col7, #T_ea852_row3_col8, #T_ea852_row3_col9, #T_ea852_row3_col10, #T_ea852_row4_col2, #T_ea852_row4_col3, #T_ea852_row4_col4, #T_ea852_row4_col5, #T_ea852_row4_col6, #T_ea852_row4_col7, #T_ea852_row4_col8, #T_ea852_row4_col9, #T_ea852_row4_col10, #T_ea852_row5_col2, #T_ea852_row5_col3, #T_ea852_row5_col4, #T_ea852_row5_col5, #T_ea852_row5_col6, #T_ea852_row5_col7, #T_ea852_row5_col8, #T_ea852_row5_col9, #T_ea852_row5_col10, #T_ea852_row6_col2, #T_ea852_row6_col3, #T_ea852_row6_col4, #T_ea852_row6_col5, #T_ea852_row6_col6, #T_ea852_row6_col7, #T_ea852_row6_col8, #T_ea852_row6_col9, #T_ea852_row6_col10, #T_ea852_row7_col2, #T_ea852_row7_col3, #T_ea852_row7_col4, #T_ea852_row7_col5, #T_ea852_row7_col6, #T_ea852_row7_col7, #T_ea852_row7_col8, #T_ea852_row7_col9, #T_ea852_row7_col10, #T_ea852_row8_col2, #T_ea852_row8_col3, #T_ea852_row8_col4, #T_ea852_row8_col5, #T_ea852_row8_col6, #T_ea852_row8_col7, #T_ea852_row8_col8, #T_ea852_row8_col9, #T_ea852_row8_col10, #T_ea852_row9_col2, #T_ea852_row9_col3, #T_ea852_row9_col4, #T_ea852_row9_col5, #T_ea852_row9_col6, #T_ea852_row9_col7, #T_ea852_row9_col8, #T_ea852_row9_col9, #T_ea852_row9_col10, #T_ea852_row10_col2, #T_ea852_row10_col3, #T_ea852_row10_col4, #T_ea852_row10_col5, #T_ea852_row10_col6, #T_ea852_row10_col7, #T_ea852_row10_col8, #T_ea852_row10_col9, #T_ea852_row10_col10, #T_ea852_row11_col2, #T_ea852_row11_col3, #T_ea852_row11_col4, #T_ea852_row11_col5, #T_ea852_row11_col6, #T_ea852_row11_col7, #T_ea852_row11_col8, #T_ea852_row11_col9, #T_ea852_row11_col10, #T_ea852_row12_col2, #T_ea852_row12_col3, #T_ea852_row12_col4, #T_ea852_row12_col5, #T_ea852_row12_col6, #T_ea852_row12_col7, #T_ea852_row12_col8, #T_ea852_row12_col9, #T_ea852_row12_col10, #T_ea852_row13_col2, #T_ea852_row13_col3, #T_ea852_row13_col4, #T_ea852_row13_col5, #T_ea852_row13_col6, #T_ea852_row13_col7, #T_ea852_row13_col8, #T_ea852_row13_col9, #T_ea852_row13_col10, #T_ea852_row14_col2, #T_ea852_row14_col3, #T_ea852_row14_col4, #T_ea852_row14_col5, #T_ea852_row14_col6, #T_ea852_row14_col7, #T_ea852_row14_col8, #T_ea852_row14_col9, #T_ea852_row14_col10 {\n",
       "  border: 1px solid grey;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_ea852\">\n",
       "  <caption>Data for Piotroski Score Technology - Semiconductors</caption>\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th id=\"T_ea852_level0_col0\" class=\"col_heading level0 col0\" >Symbol</th>\n",
       "      <th id=\"T_ea852_level0_col1\" class=\"col_heading level0 col1\" >Name</th>\n",
       "      <th id=\"T_ea852_level0_col2\" class=\"col_heading level0 col2\" >Net Income</th>\n",
       "      <th id=\"T_ea852_level0_col3\" class=\"col_heading level0 col3\" >Return on Assets</th>\n",
       "      <th id=\"T_ea852_level0_col4\" class=\"col_heading level0 col4\" >Op. Cash Flow</th>\n",
       "      <th id=\"T_ea852_level0_col5\" class=\"col_heading level0 col5\" >Quality of Earn</th>\n",
       "      <th id=\"T_ea852_level0_col6\" class=\"col_heading level0 col6\" >Long Term Debt</th>\n",
       "      <th id=\"T_ea852_level0_col7\" class=\"col_heading level0 col7\" >Current Ratio</th>\n",
       "      <th id=\"T_ea852_level0_col8\" class=\"col_heading level0 col8\" >New Shares</th>\n",
       "      <th id=\"T_ea852_level0_col9\" class=\"col_heading level0 col9\" >Gross Margin</th>\n",
       "      <th id=\"T_ea852_level0_col10\" class=\"col_heading level0 col10\" >Asset TR</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td id=\"T_ea852_row0_col0\" class=\"data row0 col0\" >NVDA</td>\n",
       "      <td id=\"T_ea852_row0_col1\" class=\"data row0 col1\" >NVIDIA Corporation</td>\n",
       "      <td id=\"T_ea852_row0_col2\" class=\"data row0 col2\" >4.37B</td>\n",
       "      <td id=\"T_ea852_row0_col3\" class=\"data row0 col3\" >0.10</td>\n",
       "      <td id=\"T_ea852_row0_col4\" class=\"data row0 col4\" >5.64B</td>\n",
       "      <td id=\"T_ea852_row0_col5\" class=\"data row0 col5\" >1</td>\n",
       "      <td id=\"T_ea852_row0_col6\" class=\"data row0 col6\" >1.24B</td>\n",
       "      <td id=\"T_ea852_row0_col7\" class=\"data row0 col7\" >-0.36</td>\n",
       "      <td id=\"T_ea852_row0_col8\" class=\"data row0 col8\" >1M</td>\n",
       "      <td id=\"T_ea852_row0_col9\" class=\"data row0 col9\" >-0.08</td>\n",
       "      <td id=\"T_ea852_row0_col10\" class=\"data row0 col10\" >-0.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ea852_row1_col0\" class=\"data row1 col0\" >TSM</td>\n",
       "      <td id=\"T_ea852_row1_col1\" class=\"data row1 col1\" >Taiwan Semiconductor Manufacturing Company Limited</td>\n",
       "      <td id=\"T_ea852_row1_col2\" class=\"data row1 col2\" >993B</td>\n",
       "      <td id=\"T_ea852_row1_col3\" class=\"data row1 col3\" >0.23</td>\n",
       "      <td id=\"T_ea852_row1_col4\" class=\"data row1 col4\" >1.61T</td>\n",
       "      <td id=\"T_ea852_row1_col5\" class=\"data row1 col5\" >1</td>\n",
       "      <td id=\"T_ea852_row1_col6\" class=\"data row1 col6\" >-226B</td>\n",
       "      <td id=\"T_ea852_row1_col7\" class=\"data row1 col7\" >0.06</td>\n",
       "      <td id=\"T_ea852_row1_col8\" class=\"data row1 col8\" >0</td>\n",
       "      <td id=\"T_ea852_row1_col9\" class=\"data row1 col9\" >0.08</td>\n",
       "      <td id=\"T_ea852_row1_col10\" class=\"data row1 col10\" >0.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ea852_row2_col0\" class=\"data row2 col0\" >AVGO</td>\n",
       "      <td id=\"T_ea852_row2_col1\" class=\"data row2 col1\" >Broadcom Inc.</td>\n",
       "      <td id=\"T_ea852_row2_col2\" class=\"data row2 col2\" >14.1B</td>\n",
       "      <td id=\"T_ea852_row2_col3\" class=\"data row2 col3\" >0.19</td>\n",
       "      <td id=\"T_ea852_row2_col4\" class=\"data row2 col4\" >18.1B</td>\n",
       "      <td id=\"T_ea852_row2_col5\" class=\"data row2 col5\" >1</td>\n",
       "      <td id=\"T_ea852_row2_col6\" class=\"data row2 col6\" >1.44B</td>\n",
       "      <td id=\"T_ea852_row2_col7\" class=\"data row2 col7\" >0.04</td>\n",
       "      <td id=\"T_ea852_row2_col8\" class=\"data row2 col8\" >0</td>\n",
       "      <td id=\"T_ea852_row2_col9\" class=\"data row2 col9\" >0.02</td>\n",
       "      <td id=\"T_ea852_row2_col10\" class=\"data row2 col10\" >0.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ea852_row3_col0\" class=\"data row3 col0\" >AMD</td>\n",
       "      <td id=\"T_ea852_row3_col1\" class=\"data row3 col1\" >Advanced Micro Devices, Inc.</td>\n",
       "      <td id=\"T_ea852_row3_col2\" class=\"data row3 col2\" >854M</td>\n",
       "      <td id=\"T_ea852_row3_col3\" class=\"data row3 col3\" >0.01</td>\n",
       "      <td id=\"T_ea852_row3_col4\" class=\"data row3 col4\" >1.67B</td>\n",
       "      <td id=\"T_ea852_row3_col5\" class=\"data row3 col5\" >1</td>\n",
       "      <td id=\"T_ea852_row3_col6\" class=\"data row3 col6\" >75M</td>\n",
       "      <td id=\"T_ea852_row3_col7\" class=\"data row3 col7\" >0.39</td>\n",
       "      <td id=\"T_ea852_row3_col8\" class=\"data row3 col8\" >-1M</td>\n",
       "      <td id=\"T_ea852_row3_col9\" class=\"data row3 col9\" >0.01</td>\n",
       "      <td id=\"T_ea852_row3_col10\" class=\"data row3 col10\" >-0.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ea852_row4_col0\" class=\"data row4 col0\" >INTC</td>\n",
       "      <td id=\"T_ea852_row4_col1\" class=\"data row4 col1\" >Intel Corporation</td>\n",
       "      <td id=\"T_ea852_row4_col2\" class=\"data row4 col2\" >1.69B</td>\n",
       "      <td id=\"T_ea852_row4_col3\" class=\"data row4 col3\" >0.01</td>\n",
       "      <td id=\"T_ea852_row4_col4\" class=\"data row4 col4\" >11.5B</td>\n",
       "      <td id=\"T_ea852_row4_col5\" class=\"data row4 col5\" >1</td>\n",
       "      <td id=\"T_ea852_row4_col6\" class=\"data row4 col6\" >-9.29B</td>\n",
       "      <td id=\"T_ea852_row4_col7\" class=\"data row4 col7\" >0.04</td>\n",
       "      <td id=\"T_ea852_row4_col8\" class=\"data row4 col8\" >-5.07B</td>\n",
       "      <td id=\"T_ea852_row4_col9\" class=\"data row4 col9\" >-0.03</td>\n",
       "      <td id=\"T_ea852_row4_col10\" class=\"data row4 col10\" >-0.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ea852_row5_col0\" class=\"data row5 col0\" >QCOM</td>\n",
       "      <td id=\"T_ea852_row5_col1\" class=\"data row5 col1\" >QUALCOMM Incorporated</td>\n",
       "      <td id=\"T_ea852_row5_col2\" class=\"data row5 col2\" >7.23B</td>\n",
       "      <td id=\"T_ea852_row5_col3\" class=\"data row5 col3\" >0.14</td>\n",
       "      <td id=\"T_ea852_row5_col4\" class=\"data row5 col4\" >11.3B</td>\n",
       "      <td id=\"T_ea852_row5_col5\" class=\"data row5 col5\" >1</td>\n",
       "      <td id=\"T_ea852_row5_col6\" class=\"data row5 col6\" >-947M</td>\n",
       "      <td id=\"T_ea852_row5_col7\" class=\"data row5 col7\" >0.15</td>\n",
       "      <td id=\"T_ea852_row5_col8\" class=\"data row5 col8\" >-295M</td>\n",
       "      <td id=\"T_ea852_row5_col9\" class=\"data row5 col9\" >-0.02</td>\n",
       "      <td id=\"T_ea852_row5_col10\" class=\"data row5 col10\" >-0.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ea852_row6_col0\" class=\"data row6 col0\" >TXN</td>\n",
       "      <td id=\"T_ea852_row6_col1\" class=\"data row6 col1\" >Texas Instruments Incorporated</td>\n",
       "      <td id=\"T_ea852_row6_col2\" class=\"data row6 col2\" >6.51B</td>\n",
       "      <td id=\"T_ea852_row6_col3\" class=\"data row6 col3\" >0.22</td>\n",
       "      <td id=\"T_ea852_row6_col4\" class=\"data row6 col4\" >6.42B</td>\n",
       "      <td id=\"T_ea852_row6_col5\" class=\"data row6 col5\" >0</td>\n",
       "      <td id=\"T_ea852_row6_col6\" class=\"data row6 col6\" >-2.39B</td>\n",
       "      <td id=\"T_ea852_row6_col7\" class=\"data row6 col7\" >-0.06</td>\n",
       "      <td id=\"T_ea852_row6_col8\" class=\"data row6 col8\" >0</td>\n",
       "      <td id=\"T_ea852_row6_col9\" class=\"data row6 col9\" >-0.06</td>\n",
       "      <td id=\"T_ea852_row6_col10\" class=\"data row6 col10\" >-0.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ea852_row7_col0\" class=\"data row7 col0\" >ADI</td>\n",
       "      <td id=\"T_ea852_row7_col1\" class=\"data row7 col1\" >Analog Devices, Inc.</td>\n",
       "      <td id=\"T_ea852_row7_col2\" class=\"data row7 col2\" >3.31B</td>\n",
       "      <td id=\"T_ea852_row7_col3\" class=\"data row7 col3\" >0.07</td>\n",
       "      <td id=\"T_ea852_row7_col4\" class=\"data row7 col4\" >4.82B</td>\n",
       "      <td id=\"T_ea852_row7_col5\" class=\"data row7 col5\" >1</td>\n",
       "      <td id=\"T_ea852_row7_col6\" class=\"data row7 col6\" >646M</td>\n",
       "      <td id=\"T_ea852_row7_col7\" class=\"data row7 col7\" >0.05</td>\n",
       "      <td id=\"T_ea852_row7_col8\" class=\"data row7 col8\" >2.17M</td>\n",
       "      <td id=\"T_ea852_row7_col9\" class=\"data row7 col9\" >0.01</td>\n",
       "      <td id=\"T_ea852_row7_col10\" class=\"data row7 col10\" >0.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ea852_row8_col0\" class=\"data row8 col0\" >MU</td>\n",
       "      <td id=\"T_ea852_row8_col1\" class=\"data row8 col1\" >Micron Technology, Inc.</td>\n",
       "      <td id=\"T_ea852_row8_col2\" class=\"data row8 col2\" >-5.83B</td>\n",
       "      <td id=\"T_ea852_row8_col3\" class=\"data row8 col3\" >-0.09</td>\n",
       "      <td id=\"T_ea852_row8_col4\" class=\"data row8 col4\" >1.56B</td>\n",
       "      <td id=\"T_ea852_row8_col5\" class=\"data row8 col5\" >1</td>\n",
       "      <td id=\"T_ea852_row8_col6\" class=\"data row8 col6\" >-5.92B</td>\n",
       "      <td id=\"T_ea852_row8_col7\" class=\"data row8 col7\" >-0.86</td>\n",
       "      <td id=\"T_ea852_row8_col8\" class=\"data row8 col8\" >-1M</td>\n",
       "      <td id=\"T_ea852_row8_col9\" class=\"data row8 col9\" >-0.54</td>\n",
       "      <td id=\"T_ea852_row8_col10\" class=\"data row8 col10\" >-0.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ea852_row9_col0\" class=\"data row9 col0\" >ARM</td>\n",
       "      <td id=\"T_ea852_row9_col1\" class=\"data row9 col1\" >Arm Holdings plc</td>\n",
       "      <td id=\"T_ea852_row9_col2\" class=\"data row9 col2\" >524M</td>\n",
       "      <td id=\"T_ea852_row9_col3\" class=\"data row9 col3\" >0.08</td>\n",
       "      <td id=\"T_ea852_row9_col4\" class=\"data row9 col4\" >739M</td>\n",
       "      <td id=\"T_ea852_row9_col5\" class=\"data row9 col5\" >1</td>\n",
       "      <td id=\"T_ea852_row9_col6\" class=\"data row9 col6\" >nan</td>\n",
       "      <td id=\"T_ea852_row9_col7\" class=\"data row9 col7\" >0.24</td>\n",
       "      <td id=\"T_ea852_row9_col8\" class=\"data row9 col8\" >0</td>\n",
       "      <td id=\"T_ea852_row9_col9\" class=\"data row9 col9\" >0.01</td>\n",
       "      <td id=\"T_ea852_row9_col10\" class=\"data row9 col10\" >nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ea852_row10_col0\" class=\"data row10 col0\" >MRVL</td>\n",
       "      <td id=\"T_ea852_row10_col1\" class=\"data row10 col1\" >Marvell Technology, Inc.</td>\n",
       "      <td id=\"T_ea852_row10_col2\" class=\"data row10 col2\" >-164M</td>\n",
       "      <td id=\"T_ea852_row10_col3\" class=\"data row10 col3\" >-0.01</td>\n",
       "      <td id=\"T_ea852_row10_col4\" class=\"data row10 col4\" >1.29B</td>\n",
       "      <td id=\"T_ea852_row10_col5\" class=\"data row10 col5\" >1</td>\n",
       "      <td id=\"T_ea852_row10_col6\" class=\"data row10 col6\" >577M</td>\n",
       "      <td id=\"T_ea852_row10_col7\" class=\"data row10 col7\" >-0.18</td>\n",
       "      <td id=\"T_ea852_row10_col8\" class=\"data row10 col8\" >0</td>\n",
       "      <td id=\"T_ea852_row10_col9\" class=\"data row10 col9\" >0.04</td>\n",
       "      <td id=\"T_ea852_row10_col10\" class=\"data row10 col10\" >-0.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ea852_row11_col0\" class=\"data row11 col0\" >MPWR</td>\n",
       "      <td id=\"T_ea852_row11_col1\" class=\"data row11 col1\" >Monolithic Power Systems, Inc.</td>\n",
       "      <td id=\"T_ea852_row11_col2\" class=\"data row11 col2\" >438M</td>\n",
       "      <td id=\"T_ea852_row11_col3\" class=\"data row11 col3\" >0.24</td>\n",
       "      <td id=\"T_ea852_row11_col4\" class=\"data row11 col4\" >247M</td>\n",
       "      <td id=\"T_ea852_row11_col5\" class=\"data row11 col5\" >0</td>\n",
       "      <td id=\"T_ea852_row11_col6\" class=\"data row11 col6\" >nan</td>\n",
       "      <td id=\"T_ea852_row11_col7\" class=\"data row11 col7\" >0.64</td>\n",
       "      <td id=\"T_ea852_row11_col8\" class=\"data row11 col8\" >-172M</td>\n",
       "      <td id=\"T_ea852_row11_col9\" class=\"data row11 col9\" >0.02</td>\n",
       "      <td id=\"T_ea852_row11_col10\" class=\"data row11 col10\" >0.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ea852_row12_col0\" class=\"data row12 col0\" >MCHP</td>\n",
       "      <td id=\"T_ea852_row12_col1\" class=\"data row12 col1\" >Microchip Technology Incorporated</td>\n",
       "      <td id=\"T_ea852_row12_col2\" class=\"data row12 col2\" >2.24B</td>\n",
       "      <td id=\"T_ea852_row12_col3\" class=\"data row12 col3\" >0.14</td>\n",
       "      <td id=\"T_ea852_row12_col4\" class=\"data row12 col4\" >3.62B</td>\n",
       "      <td id=\"T_ea852_row12_col5\" class=\"data row12 col5\" >1</td>\n",
       "      <td id=\"T_ea852_row12_col6\" class=\"data row12 col6\" >2.65B</td>\n",
       "      <td id=\"T_ea852_row12_col7\" class=\"data row12 col7\" >0.09</td>\n",
       "      <td id=\"T_ea852_row12_col8\" class=\"data row12 col8\" >1K</td>\n",
       "      <td id=\"T_ea852_row12_col9\" class=\"data row12 col9\" >0.02</td>\n",
       "      <td id=\"T_ea852_row12_col10\" class=\"data row12 col10\" >0.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ea852_row13_col0\" class=\"data row13 col0\" >ON</td>\n",
       "      <td id=\"T_ea852_row13_col1\" class=\"data row13 col1\" >ON Semiconductor Corporation</td>\n",
       "      <td id=\"T_ea852_row13_col2\" class=\"data row13 col2\" >1.9B</td>\n",
       "      <td id=\"T_ea852_row13_col3\" class=\"data row13 col3\" >0.18</td>\n",
       "      <td id=\"T_ea852_row13_col4\" class=\"data row13 col4\" >2.63B</td>\n",
       "      <td id=\"T_ea852_row13_col5\" class=\"data row13 col5\" >1</td>\n",
       "      <td id=\"T_ea852_row13_col6\" class=\"data row13 col6\" >-132M</td>\n",
       "      <td id=\"T_ea852_row13_col7\" class=\"data row13 col7\" >0.16</td>\n",
       "      <td id=\"T_ea852_row13_col8\" class=\"data row13 col8\" >-1K</td>\n",
       "      <td id=\"T_ea852_row13_col9\" class=\"data row13 col9\" >0.09</td>\n",
       "      <td id=\"T_ea852_row13_col10\" class=\"data row13 col10\" >0.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ea852_row14_col0\" class=\"data row14 col0\" >STM</td>\n",
       "      <td id=\"T_ea852_row14_col1\" class=\"data row14 col1\" >STMicroelectronics N.V.</td>\n",
       "      <td id=\"T_ea852_row14_col2\" class=\"data row14 col2\" >3.96B</td>\n",
       "      <td id=\"T_ea852_row14_col3\" class=\"data row14 col3\" >0.22</td>\n",
       "      <td id=\"T_ea852_row14_col4\" class=\"data row14 col4\" >5.2B</td>\n",
       "      <td id=\"T_ea852_row14_col5\" class=\"data row14 col5\" >1</td>\n",
       "      <td id=\"T_ea852_row14_col6\" class=\"data row14 col6\" >-146M</td>\n",
       "      <td id=\"T_ea852_row14_col7\" class=\"data row14 col7\" >0.29</td>\n",
       "      <td id=\"T_ea852_row14_col8\" class=\"data row14 col8\" >0</td>\n",
       "      <td id=\"T_ea852_row14_col9\" class=\"data row14 col9\" >0.06</td>\n",
       "      <td id=\"T_ea852_row14_col10\" class=\"data row14 col10\" >0.06</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7f0e303d7a50>"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Add table caption and styles to DF\n",
    "ps_criteria_data_df.style.pipe(make_pretty_raw).set_caption(f'Data for Piotroski Score {SECTOR} - {INDUSTRY}').set_table_styles(\n",
    "    [{'selector': 'th.col_heading', 'props': [('text-align', 'center'),\n",
    "                                              ('color', 'bisque'), ('font-size', '10pt')]},\n",
    "     {'selector': 'td', 'props': [('font-size', '10pt')]},\n",
    "     {'selector': 'caption', 'props': [('text-align', 'center'), ('color', 'goldenrod'),\n",
    "                                       ('font-size', '14pt'), ('font-weight', 'bold')]}]).format_index(column_formatter_raw, axis=1) "
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}