test.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "ShjMFjLjgihY"
   },
   "outputs": [],
   "source": [
    "import argparse\n",
    "import datetime\n",
    "import hashlib\n",
    "import os\n",
    "import os.path\n",
    "import shutil\n",
    "import smtplib\n",
    "import subprocess\n",
    "import sys\n",
    "import time\n",
    "import urllib.request\n",
    "from contextlib import suppress\n",
    "from datetime import datetime\n",
    "from io import StringIO\n",
    "\n",
    "import natsort\n",
    "import pandas as pd\n",
    "import requests\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.chrome.options import Options\n",
    "from selenium.webdriver.common.keys import Keys\n",
    "\n",
    "\n",
    "def ishtml(filename):\n",
    "    if not \".\" in filename:\n",
    "        return False\n",
    "    exts = [\"html\"]\n",
    "    ext = filename.split(\".\")[-1]\n",
    "    if ext in exts:\n",
    "        return True\n",
    "    return False\n",
    "\n",
    "def listhtmlonly(dir):\n",
    "    return natsort.natsorted([name for name in next(os.walk(os.path.join(dir, '.')))[2] if ishtml(name)])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "dFeyYwm1g7yD"
   },
   "outputs": [],
   "source": [
    "options = webdriver.ChromeOptions()\n",
    "#options.add_argument(\"user-data-dir=C:\\\\Users\\\\user\\\\AppData\\\\Local\\\\chrome\\\\User Data\")\n",
    "#options.binary_location = \"C:\\\\Program Files (x86)\\\\google\\\\Application\\\\chrome.exe\"\n",
    "driver = webdriver.Chrome(options=options)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.get(\"https://goodinfo.tw/\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2098"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 取得所有四位數的一般股票代碼\n",
    "option_selenium = driver.find_elements(\"css selector\", \"#dlSTOCK_ID_NM > option\")\n",
    "option_value = [i.get_attribute('value') for i in option_selenium]\n",
    "code = [i.split(\" \")[0] for i in option_value]\n",
    "filtered_code = [i for i in code if len(i) == 4]\n",
    "len(filtered_code)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2094"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 已經下載完成的股票代碼\n",
    "html_filename = listhtmlonly(\"\")\n",
    "finished = [i.split(\".\")[0] for i in html_filename]\n",
    "len(finished)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "6917 Fail\n",
      "6937 Fail\n"
     ]
    }
   ],
   "source": [
    "# 爬蟲前記得先更改瀏覽器下載位置和是否跳出下載確認對話框\n",
    "\n",
    "unfinished = list(set(filtered_code) - set(finished))\n",
    "unfinished.sort()\n",
    "unfinished.remove('0000')\n",
    "unfinished.remove('0001')\n",
    "\n",
    "for i in unfinished:\n",
    "    try:\n",
    "        driver.get(\"https://goodinfo.tw/tw/StockDividendPolicy.asp?STOCK_ID={}\".format(i))\n",
    "\n",
    "        # 按下匯出HTML按鈕的js\n",
    "        js = \"export2html(divDetail.innerHTML,'{}.html');\".format(i)\n",
    "        driver.execute_script(js)\n",
    "    except:\n",
    "        print(i + ' Fail')\n",
    "    \n",
    "    # 間隔不能太短 一定時間內又不能太多 需要多爬幾次\n",
    "    time.sleep(4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"10\" halign=\"left\">股 利 政 策</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"5\" halign=\"left\">殖 利 率 統 計</th>\n",
       "      <th colspan=\"5\" halign=\"left\">盈餘分配率統計</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>股利 發放 年度</th>\n",
       "      <th colspan=\"7\" halign=\"left\">股東股利 (元/股)</th>\n",
       "      <th colspan=\"2\" halign=\"left\">股利總計</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"5\" halign=\"left\">殖 利 率 統 計</th>\n",
       "      <th colspan=\"5\" halign=\"left\">盈餘分配率統計</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>股利 發放 年度</th>\n",
       "      <th colspan=\"3\" halign=\"left\">現金股利</th>\n",
       "      <th colspan=\"3\" halign=\"left\">股票股利</th>\n",
       "      <th>股利 合計</th>\n",
       "      <th>現金 (億)</th>\n",
       "      <th>股票 (千張)</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"2\" halign=\"left\">股價統計(元)</th>\n",
       "      <th colspan=\"3\" halign=\"left\">年均殖利率(%)</th>\n",
       "      <th>股利 所屬 期間</th>\n",
       "      <th>EPS (元)</th>\n",
       "      <th colspan=\"3\" halign=\"left\">盈餘分配率(%)</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>股利 發放 年度</th>\n",
       "      <th>盈餘</th>\n",
       "      <th>公積</th>\n",
       "      <th>合計</th>\n",
       "      <th>盈餘</th>\n",
       "      <th>公積</th>\n",
       "      <th>合計</th>\n",
       "      <th>股利 合計</th>\n",
       "      <th>現金 (億)</th>\n",
       "      <th>股票 (千張)</th>\n",
       "      <th>...</th>\n",
       "      <th>最低</th>\n",
       "      <th>年均</th>\n",
       "      <th>現金</th>\n",
       "      <th>股票</th>\n",
       "      <th>合計</th>\n",
       "      <th>股利 所屬 期間</th>\n",
       "      <th>EPS (元)</th>\n",
       "      <th>配息</th>\n",
       "      <th>配股</th>\n",
       "      <th>合計</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2023</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>...</td>\n",
       "      <td>108.45</td>\n",
       "      <td>113</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>96.5</td>\n",
       "      <td>122</td>\n",
       "      <td>4.09</td>\n",
       "      <td>0</td>\n",
       "      <td>4.09</td>\n",
       "      <td>2022</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>∟</td>\n",
       "      <td>1.8</td>\n",
       "      <td>0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1.47</td>\n",
       "      <td>0</td>\n",
       "      <td>1.47</td>\n",
       "      <td>22H2</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>∟</td>\n",
       "      <td>3.2</td>\n",
       "      <td>0</td>\n",
       "      <td>3.2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>2.62</td>\n",
       "      <td>0</td>\n",
       "      <td>2.62</td>\n",
       "      <td>22H1</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021</td>\n",
       "      <td>3.4</td>\n",
       "      <td>0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>121.2</td>\n",
       "      <td>137</td>\n",
       "      <td>2.48</td>\n",
       "      <td>0</td>\n",
       "      <td>2.48</td>\n",
       "      <td>2021</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>∟</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>0.26</td>\n",
       "      <td>0</td>\n",
       "      <td>0.26</td>\n",
       "      <td>21H2</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>∟</td>\n",
       "      <td>3.05</td>\n",
       "      <td>0</td>\n",
       "      <td>3.05</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.05</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>2.23</td>\n",
       "      <td>0</td>\n",
       "      <td>2.23</td>\n",
       "      <td>21H1</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2020</td>\n",
       "      <td>3.6</td>\n",
       "      <td>0</td>\n",
       "      <td>3.6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>67.25</td>\n",
       "      <td>96.9</td>\n",
       "      <td>3.71</td>\n",
       "      <td>0</td>\n",
       "      <td>3.71</td>\n",
       "      <td>2020</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>∟</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>0.72</td>\n",
       "      <td>0</td>\n",
       "      <td>0.72</td>\n",
       "      <td>20H2</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>∟</td>\n",
       "      <td>2.9</td>\n",
       "      <td>0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>2.99</td>\n",
       "      <td>0</td>\n",
       "      <td>2.99</td>\n",
       "      <td>20H1</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2019</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>72</td>\n",
       "      <td>83</td>\n",
       "      <td>3.61</td>\n",
       "      <td>0</td>\n",
       "      <td>3.61</td>\n",
       "      <td>2019</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>∟</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>0.84</td>\n",
       "      <td>0</td>\n",
       "      <td>0.84</td>\n",
       "      <td>19H2</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>∟</td>\n",
       "      <td>2.3</td>\n",
       "      <td>0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>2.77</td>\n",
       "      <td>0</td>\n",
       "      <td>2.77</td>\n",
       "      <td>19H1</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2018</td>\n",
       "      <td>2.9</td>\n",
       "      <td>0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>73.3</td>\n",
       "      <td>81.8</td>\n",
       "      <td>3.55</td>\n",
       "      <td>0</td>\n",
       "      <td>3.55</td>\n",
       "      <td>2018</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>∟</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>0.86</td>\n",
       "      <td>0</td>\n",
       "      <td>0.86</td>\n",
       "      <td>18H2</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>∟</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>2.69</td>\n",
       "      <td>0</td>\n",
       "      <td>2.69</td>\n",
       "      <td>18H1</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2017</td>\n",
       "      <td>2.4</td>\n",
       "      <td>0</td>\n",
       "      <td>2.4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>71.35</td>\n",
       "      <td>78.8</td>\n",
       "      <td>3.05</td>\n",
       "      <td>0</td>\n",
       "      <td>3.05</td>\n",
       "      <td>2017</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>∟</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>0.89</td>\n",
       "      <td>0</td>\n",
       "      <td>0.89</td>\n",
       "      <td>17H2</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>∟</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>2.16</td>\n",
       "      <td>0</td>\n",
       "      <td>2.16</td>\n",
       "      <td>17H1</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2016</td>\n",
       "      <td>0.85</td>\n",
       "      <td>0</td>\n",
       "      <td>0.85</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.85</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>55.6</td>\n",
       "      <td>66.3</td>\n",
       "      <td>1.28</td>\n",
       "      <td>0</td>\n",
       "      <td>1.28</td>\n",
       "      <td>16H2</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2015</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>55.4</td>\n",
       "      <td>66.3</td>\n",
       "      <td>3.01</td>\n",
       "      <td>0</td>\n",
       "      <td>3.01</td>\n",
       "      <td>2015</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2014</td>\n",
       "      <td>1.55</td>\n",
       "      <td>0</td>\n",
       "      <td>1.55</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.55</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>55.6</td>\n",
       "      <td>63.7</td>\n",
       "      <td>2.43</td>\n",
       "      <td>0</td>\n",
       "      <td>2.43</td>\n",
       "      <td>2014</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2013</td>\n",
       "      <td>1.35</td>\n",
       "      <td>0</td>\n",
       "      <td>1.35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>52.95</td>\n",
       "      <td>56.2</td>\n",
       "      <td>2.4</td>\n",
       "      <td>0</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2013</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2012</td>\n",
       "      <td>1.85</td>\n",
       "      <td>0</td>\n",
       "      <td>1.85</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.85</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>47.45</td>\n",
       "      <td>52.3</td>\n",
       "      <td>3.54</td>\n",
       "      <td>0</td>\n",
       "      <td>3.54</td>\n",
       "      <td>2012</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2011</td>\n",
       "      <td>1.95</td>\n",
       "      <td>0</td>\n",
       "      <td>1.95</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.95</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>46.61</td>\n",
       "      <td>56.6</td>\n",
       "      <td>3.45</td>\n",
       "      <td>0</td>\n",
       "      <td>3.45</td>\n",
       "      <td>2011</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2010</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>47.95</td>\n",
       "      <td>54.7</td>\n",
       "      <td>4.02</td>\n",
       "      <td>0</td>\n",
       "      <td>4.02</td>\n",
       "      <td>2010</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2009</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>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>30.01</td>\n",
       "      <td>45.3</td>\n",
       "      <td>2.21</td>\n",
       "      <td>0</td>\n",
       "      <td>2.21</td>\n",
       "      <td>2009</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>28.53</td>\n",
       "      <td>51.3</td>\n",
       "      <td>3.9</td>\n",
       "      <td>0</td>\n",
       "      <td>3.9</td>\n",
       "      <td>2008</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2007</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>53.05</td>\n",
       "      <td>62</td>\n",
       "      <td>4.03</td>\n",
       "      <td>0</td>\n",
       "      <td>4.03</td>\n",
       "      <td>2007</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2006</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>49.3</td>\n",
       "      <td>53.9</td>\n",
       "      <td>7.43</td>\n",
       "      <td>0</td>\n",
       "      <td>7.43</td>\n",
       "      <td>2006</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2005</td>\n",
       "      <td>1.85</td>\n",
       "      <td>0</td>\n",
       "      <td>1.85</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.85</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>43.9</td>\n",
       "      <td>47.3</td>\n",
       "      <td>3.91</td>\n",
       "      <td>0</td>\n",
       "      <td>3.91</td>\n",
       "      <td>2005</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2004</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>40.9</td>\n",
       "      <td>46.4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2003</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>...</td>\n",
       "      <td>36.92</td>\n",
       "      <td>44.5</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>累計</td>\n",
       "      <td>43.4</td>\n",
       "      <td>0</td>\n",
       "      <td>43.4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>43.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>累計</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>34 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    股 利 政 策                                                      ...  \\\n",
       "   股利 發放 年度 股東股利 (元/股)                             股利總計          ...   \n",
       "   股利 發放 年度       現金股利          股票股利       股利 合計 現金 (億) 股票 (千張)  ...   \n",
       "   股利 發放 年度         盈餘 公積    合計   盈餘 公積 合計 股利 合計 現金 (億) 股票 (千張)  ...   \n",
       "0      2023          -  -     -    -  -  -     -      -       -  ...   \n",
       "1      2022          5  0     5    0  0  0     5      0       0  ...   \n",
       "2         ∟        1.8  0   1.8    0  0  0   1.8      0       0  ...   \n",
       "3         ∟        3.2  0   3.2    0  0  0   3.2      0       0  ...   \n",
       "4      2021        3.4  0   3.4    0  0  0   3.4      0       0  ...   \n",
       "5         ∟       0.35  0  0.35    0  0  0  0.35      0       0  ...   \n",
       "6         ∟       3.05  0  3.05    0  0  0  3.05      0       0  ...   \n",
       "7      2020        3.6  0   3.6    0  0  0   3.6      0       0  ...   \n",
       "8         ∟        0.7  0   0.7    0  0  0   0.7      0       0  ...   \n",
       "9         ∟        2.9  0   2.9    0  0  0   2.9      0       0  ...   \n",
       "10     2019          3  0     3    0  0  0     3      0       0  ...   \n",
       "11        ∟        0.7  0   0.7    0  0  0   0.7      0       0  ...   \n",
       "12        ∟        2.3  0   2.3    0  0  0   2.3      0       0  ...   \n",
       "13     2018        2.9  0   2.9    0  0  0   2.9      0       0  ...   \n",
       "14        ∟        0.7  0   0.7    0  0  0   0.7      0       0  ...   \n",
       "15        ∟        2.2  0   2.2    0  0  0   2.2      0       0  ...   \n",
       "16     2017        2.4  0   2.4    0  0  0   2.4      0       0  ...   \n",
       "17        ∟        0.7  0   0.7    0  0  0   0.7      0       0  ...   \n",
       "18        ∟        1.7  0   1.7    0  0  0   1.7      0       0  ...   \n",
       "19     2016       0.85  0  0.85    0  0  0  0.85      0       0  ...   \n",
       "20     2015          2  0     2    0  0  0     2      0       0  ...   \n",
       "21     2014       1.55  0  1.55    0  0  0  1.55      0       0  ...   \n",
       "22     2013       1.35  0  1.35    0  0  0  1.35      0       0  ...   \n",
       "23     2012       1.85  0  1.85    0  0  0  1.85      0       0  ...   \n",
       "24     2011       1.95  0  1.95    0  0  0  1.95      0       0  ...   \n",
       "25     2010        2.2  0   2.2    0  0  0   2.2      0       0  ...   \n",
       "26     2009          1  0     1    0  0  0     1      0       0  ...   \n",
       "27     2008          2  0     2    0  0  0     2      0       0  ...   \n",
       "28     2007        2.5  0   2.5    0  0  0   2.5      0       0  ...   \n",
       "29     2006          4  0     4    0  0  0     4      0       0  ...   \n",
       "30     2005       1.85  0  1.85    0  0  0  1.85      0       0  ...   \n",
       "31     2004          0  0     0    0  0  0     0      0       0  ...   \n",
       "32     2003          -  -     -    -  -  -     -      -       -  ...   \n",
       "33       累計       43.4  0  43.4    0  0  0  43.4    NaN     NaN  ...   \n",
       "\n",
       "   殖 利 率 統 計                            盈餘分配率統計                             \n",
       "   殖 利 率 統 計                            盈餘分配率統計                             \n",
       "     股價統計(元)       年均殖利率(%)            股利 所屬 期間 EPS (元) 盈餘分配率(%)            \n",
       "          最低    年均       現金   股票    合計 股利 所屬 期間 EPS (元)       配息   配股   合計  \n",
       "0     108.45   113        -    -     -        -       -        -    -    -  \n",
       "1       96.5   122     4.09    0  4.09     2022       -        -    -    -  \n",
       "2          -     -     1.47    0  1.47     22H2       -        -    -    -  \n",
       "3          -     -     2.62    0  2.62     22H1       -        -    -    -  \n",
       "4      121.2   137     2.48    0  2.48     2021       -        -    -    -  \n",
       "5          -     -     0.26    0  0.26     21H2       -        -    -    -  \n",
       "6          -     -     2.23    0  2.23     21H1       -        -    -    -  \n",
       "7      67.25  96.9     3.71    0  3.71     2020       -        -    -    -  \n",
       "8          -     -     0.72    0  0.72     20H2       -        -    -    -  \n",
       "9          -     -     2.99    0  2.99     20H1       -        -    -    -  \n",
       "10        72    83     3.61    0  3.61     2019       -        -    -    -  \n",
       "11         -     -     0.84    0  0.84     19H2       -        -    -    -  \n",
       "12         -     -     2.77    0  2.77     19H1       -        -    -    -  \n",
       "13      73.3  81.8     3.55    0  3.55     2018       -        -    -    -  \n",
       "14         -     -     0.86    0  0.86     18H2       -        -    -    -  \n",
       "15         -     -     2.69    0  2.69     18H1       -        -    -    -  \n",
       "16     71.35  78.8     3.05    0  3.05     2017       -        -    -    -  \n",
       "17         -     -     0.89    0  0.89     17H2       -        -    -    -  \n",
       "18         -     -     2.16    0  2.16     17H1       -        -    -    -  \n",
       "19      55.6  66.3     1.28    0  1.28     16H2       -        -    -    -  \n",
       "20      55.4  66.3     3.01    0  3.01     2015       -        -    -    -  \n",
       "21      55.6  63.7     2.43    0  2.43     2014       -        -    -    -  \n",
       "22     52.95  56.2      2.4    0   2.4     2013       -        -    -    -  \n",
       "23     47.45  52.3     3.54    0  3.54     2012       -        -    -    -  \n",
       "24     46.61  56.6     3.45    0  3.45     2011       -        -    -    -  \n",
       "25     47.95  54.7     4.02    0  4.02     2010       -        -    -    -  \n",
       "26     30.01  45.3     2.21    0  2.21     2009       -        -    -    -  \n",
       "27     28.53  51.3      3.9    0   3.9     2008       -        -    -    -  \n",
       "28     53.05    62     4.03    0  4.03     2007       -        -    -    -  \n",
       "29      49.3  53.9     7.43    0  7.43     2006       -        -    -    -  \n",
       "30      43.9  47.3     3.91    0  3.91     2005       -        -    -    -  \n",
       "31      40.9  46.4        0    0     0        -       -        -    -    -  \n",
       "32     36.92  44.5        -    -     -        -       -        -    -    -  \n",
       "33       NaN   NaN      NaN  NaN   NaN       累計     NaN      NaN  NaN  NaN  \n",
       "\n",
       "[34 rows x 24 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "html_filename = listhtmlonly(\"\")\n",
    "dfs = [pd.read_html(i)[0] for i in html_filename]\n",
    "dfs[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": false
   },
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>股 利 政 策</th>\n",
       "      <th>殖 利 率 統 計</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>股利 發放 年度</th>\n",
       "      <th>殖 利 率 統 計</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>股利 發放 年度</th>\n",
       "      <th>年均殖利率(%)</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>股利 發放 年度</th>\n",
       "      <th>合計</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2023</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022</td>\n",
       "      <td>4.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>∟</td>\n",
       "      <td>1.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>∟</td>\n",
       "      <td>2.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021</td>\n",
       "      <td>2.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>∟</td>\n",
       "      <td>0.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>∟</td>\n",
       "      <td>2.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2020</td>\n",
       "      <td>3.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>∟</td>\n",
       "      <td>0.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>∟</td>\n",
       "      <td>2.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2019</td>\n",
       "      <td>3.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>∟</td>\n",
       "      <td>0.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>∟</td>\n",
       "      <td>2.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2018</td>\n",
       "      <td>3.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>∟</td>\n",
       "      <td>0.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>∟</td>\n",
       "      <td>2.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2017</td>\n",
       "      <td>3.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>∟</td>\n",
       "      <td>0.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>∟</td>\n",
       "      <td>2.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2016</td>\n",
       "      <td>1.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2015</td>\n",
       "      <td>3.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2014</td>\n",
       "      <td>2.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2013</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2012</td>\n",
       "      <td>3.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2011</td>\n",
       "      <td>3.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2010</td>\n",
       "      <td>4.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2009</td>\n",
       "      <td>2.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2008</td>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2007</td>\n",
       "      <td>4.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2006</td>\n",
       "      <td>7.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2005</td>\n",
       "      <td>3.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2004</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2003</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>累計</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    股 利 政 策 殖 利 率 統 計\n",
       "   股利 發放 年度 殖 利 率 統 計\n",
       "   股利 發放 年度  年均殖利率(%)\n",
       "   股利 發放 年度        合計\n",
       "0      2023         -\n",
       "1      2022      4.09\n",
       "2         ∟      1.47\n",
       "3         ∟      2.62\n",
       "4      2021      2.48\n",
       "5         ∟      0.26\n",
       "6         ∟      2.23\n",
       "7      2020      3.71\n",
       "8         ∟      0.72\n",
       "9         ∟      2.99\n",
       "10     2019      3.61\n",
       "11        ∟      0.84\n",
       "12        ∟      2.77\n",
       "13     2018      3.55\n",
       "14        ∟      0.86\n",
       "15        ∟      2.69\n",
       "16     2017      3.05\n",
       "17        ∟      0.89\n",
       "18        ∟      2.16\n",
       "19     2016      1.28\n",
       "20     2015      3.01\n",
       "21     2014      2.43\n",
       "22     2013       2.4\n",
       "23     2012      3.54\n",
       "24     2011      3.45\n",
       "25     2010      4.02\n",
       "26     2009      2.21\n",
       "27     2008       3.9\n",
       "28     2007      4.03\n",
       "29     2006      7.43\n",
       "30     2005      3.91\n",
       "31     2004         0\n",
       "32     2003         -\n",
       "33       累計       NaN"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfs[0].iloc[:, [0,18]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>年度</th>\n",
       "      <th>殖利率</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2023</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022</td>\n",
       "      <td>4.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021</td>\n",
       "      <td>2.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2020</td>\n",
       "      <td>3.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2019</td>\n",
       "      <td>3.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2018</td>\n",
       "      <td>3.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2017</td>\n",
       "      <td>3.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2016</td>\n",
       "      <td>1.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2015</td>\n",
       "      <td>3.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2014</td>\n",
       "      <td>2.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2013</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2012</td>\n",
       "      <td>3.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2011</td>\n",
       "      <td>3.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2010</td>\n",
       "      <td>4.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2009</td>\n",
       "      <td>2.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2008</td>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2007</td>\n",
       "      <td>4.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2006</td>\n",
       "      <td>7.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2005</td>\n",
       "      <td>3.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2004</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2003</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>累計</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      年度   殖利率\n",
       "0   2023     -\n",
       "1   2022  4.09\n",
       "4   2021  2.48\n",
       "7   2020  3.71\n",
       "10  2019  3.61\n",
       "13  2018  3.55\n",
       "16  2017  3.05\n",
       "19  2016  1.28\n",
       "20  2015  3.01\n",
       "21  2014  2.43\n",
       "22  2013   2.4\n",
       "23  2012  3.54\n",
       "24  2011  3.45\n",
       "25  2010  4.02\n",
       "26  2009  2.21\n",
       "27  2008   3.9\n",
       "28  2007  4.03\n",
       "29  2006  7.43\n",
       "30  2005  3.91\n",
       "31  2004     0\n",
       "32  2003     -\n",
       "33    累計   NaN"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = dfs[0].iloc[:, [0,18]]\n",
    "df.columns = ['年度', '殖利率']\n",
    "df[df.年度 != '∟']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>年度</th>\n",
       "      <th>0050</th>\n",
       "      <th>0051</th>\n",
       "      <th>0052</th>\n",
       "      <th>0053</th>\n",
       "      <th>0055</th>\n",
       "      <th>0056</th>\n",
       "      <th>0057</th>\n",
       "      <th>0061</th>\n",
       "      <th>1101</th>\n",
       "      <th>...</th>\n",
       "      <th>9945</th>\n",
       "      <th>9946</th>\n",
       "      <th>9949</th>\n",
       "      <th>9950</th>\n",
       "      <th>9951</th>\n",
       "      <th>9955</th>\n",
       "      <th>9957</th>\n",
       "      <th>9958</th>\n",
       "      <th>9960</th>\n",
       "      <th>9962</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022</td>\n",
       "      <td>4.09</td>\n",
       "      <td>4.35</td>\n",
       "      <td>9.63</td>\n",
       "      <td>2.91</td>\n",
       "      <td>3.7</td>\n",
       "      <td>7.17</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4.93</td>\n",
       "      <td>...</td>\n",
       "      <td>11.1</td>\n",
       "      <td>5.24</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4.89</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.02</td>\n",
       "      <td>6.57</td>\n",
       "      <td>6.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021</td>\n",
       "      <td>2.48</td>\n",
       "      <td>3.22</td>\n",
       "      <td>0.82</td>\n",
       "      <td>2.56</td>\n",
       "      <td>3.48</td>\n",
       "      <td>5.42</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>8.83</td>\n",
       "      <td>5.14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.64</td>\n",
       "      <td>3.53</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020</td>\n",
       "      <td>3.71</td>\n",
       "      <td>2.97</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.88</td>\n",
       "      <td>3.68</td>\n",
       "      <td>5.61</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7.05</td>\n",
       "      <td>...</td>\n",
       "      <td>13.8</td>\n",
       "      <td>9.4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.01</td>\n",
       "      <td>2.81</td>\n",
       "      <td>2.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2019</td>\n",
       "      <td>3.61</td>\n",
       "      <td>3.68</td>\n",
       "      <td>1.83</td>\n",
       "      <td>4.18</td>\n",
       "      <td>3.88</td>\n",
       "      <td>6.7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9.77</td>\n",
       "      <td>...</td>\n",
       "      <td>4.52</td>\n",
       "      <td>4.87</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4.68</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.43</td>\n",
       "      <td>1.46</td>\n",
       "      <td>8.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2018</td>\n",
       "      <td>3.55</td>\n",
       "      <td>3.13</td>\n",
       "      <td>3.24</td>\n",
       "      <td>3.14</td>\n",
       "      <td>3.75</td>\n",
       "      <td>5.62</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6.37</td>\n",
       "      <td>...</td>\n",
       "      <td>5.37</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4.74</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.46</td>\n",
       "      <td>0</td>\n",
       "      <td>5.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2017</td>\n",
       "      <td>3.05</td>\n",
       "      <td>2.89</td>\n",
       "      <td>2.88</td>\n",
       "      <td>3.34</td>\n",
       "      <td>3.23</td>\n",
       "      <td>3.78</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4.13</td>\n",
       "      <td>...</td>\n",
       "      <td>5.91</td>\n",
       "      <td>4.34</td>\n",
       "      <td>0</td>\n",
       "      <td>2.14</td>\n",
       "      <td>3.27</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.62</td>\n",
       "      <td>1.23</td>\n",
       "      <td>5.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2016</td>\n",
       "      <td>1.28</td>\n",
       "      <td>2.78</td>\n",
       "      <td>5.99</td>\n",
       "      <td>3.53</td>\n",
       "      <td>3.42</td>\n",
       "      <td>5.67</td>\n",
       "      <td>4.22</td>\n",
       "      <td>0</td>\n",
       "      <td>4.03</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>7.86</td>\n",
       "      <td>0</td>\n",
       "      <td>4.63</td>\n",
       "      <td>3.08</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>1.86</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2015</td>\n",
       "      <td>3.01</td>\n",
       "      <td>3.06</td>\n",
       "      <td>0</td>\n",
       "      <td>3.22</td>\n",
       "      <td>3.01</td>\n",
       "      <td>4.33</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6.58</td>\n",
       "      <td>...</td>\n",
       "      <td>9.04</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1.92</td>\n",
       "      <td>5.15</td>\n",
       "      <td>3.94</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.12</td>\n",
       "      <td>3.82</td>\n",
       "      <td>2.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2014</td>\n",
       "      <td>2.43</td>\n",
       "      <td>2.5</td>\n",
       "      <td>6.38</td>\n",
       "      <td>3.24</td>\n",
       "      <td>2.8</td>\n",
       "      <td>4.12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.03</td>\n",
       "      <td>...</td>\n",
       "      <td>8.47</td>\n",
       "      <td>10.6</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.7</td>\n",
       "      <td>4.03</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6.44</td>\n",
       "      <td>5.04</td>\n",
       "      <td>5.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2013</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.85</td>\n",
       "      <td>0</td>\n",
       "      <td>3.16</td>\n",
       "      <td>2.7</td>\n",
       "      <td>3.61</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4.77</td>\n",
       "      <td>...</td>\n",
       "      <td>4.83</td>\n",
       "      <td>7.95</td>\n",
       "      <td>3.63</td>\n",
       "      <td>3.99</td>\n",
       "      <td>2.74</td>\n",
       "      <td>1.31</td>\n",
       "      <td>0</td>\n",
       "      <td>5.14</td>\n",
       "      <td>6.28</td>\n",
       "      <td>8.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2012</td>\n",
       "      <td>3.54</td>\n",
       "      <td>2.91</td>\n",
       "      <td>7.72</td>\n",
       "      <td>2.46</td>\n",
       "      <td>2.28</td>\n",
       "      <td>5.49</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.31</td>\n",
       "      <td>...</td>\n",
       "      <td>3.84</td>\n",
       "      <td>0</td>\n",
       "      <td>4.89</td>\n",
       "      <td>6.26</td>\n",
       "      <td>7.42</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7.44</td>\n",
       "      <td>7.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2011</td>\n",
       "      <td>3.45</td>\n",
       "      <td>3.09</td>\n",
       "      <td>0</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2.32</td>\n",
       "      <td>8.54</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.43</td>\n",
       "      <td>...</td>\n",
       "      <td>2.51</td>\n",
       "      <td>0</td>\n",
       "      <td>4.08</td>\n",
       "      <td>6.82</td>\n",
       "      <td>7.16</td>\n",
       "      <td>5.62</td>\n",
       "      <td>10.5</td>\n",
       "      <td>2.05</td>\n",
       "      <td>3.92</td>\n",
       "      <td>11.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2010</td>\n",
       "      <td>4.02</td>\n",
       "      <td>3.15</td>\n",
       "      <td>4.17</td>\n",
       "      <td>3.88</td>\n",
       "      <td>3.31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.91</td>\n",
       "      <td>...</td>\n",
       "      <td>1.91</td>\n",
       "      <td>0</td>\n",
       "      <td>2.6</td>\n",
       "      <td>8.59</td>\n",
       "      <td>1</td>\n",
       "      <td>3.72</td>\n",
       "      <td>19.6</td>\n",
       "      <td>5.45</td>\n",
       "      <td>9.09</td>\n",
       "      <td>4.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2009</td>\n",
       "      <td>2.21</td>\n",
       "      <td>7.15</td>\n",
       "      <td>5.07</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10.3</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>4.07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.41</td>\n",
       "      <td>0</td>\n",
       "      <td>1.68</td>\n",
       "      <td>5.64</td>\n",
       "      <td>0</td>\n",
       "      <td>2.66</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7.01</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2008</td>\n",
       "      <td>3.9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.2</td>\n",
       "      <td>...</td>\n",
       "      <td>5.04</td>\n",
       "      <td>0</td>\n",
       "      <td>3.96</td>\n",
       "      <td>7.31</td>\n",
       "      <td>10.1</td>\n",
       "      <td>3.44</td>\n",
       "      <td>8.46</td>\n",
       "      <td>4.22</td>\n",
       "      <td>10.8</td>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2007</td>\n",
       "      <td>4.03</td>\n",
       "      <td>2.19</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.77</td>\n",
       "      <td>...</td>\n",
       "      <td>6.38</td>\n",
       "      <td>3.78</td>\n",
       "      <td>2.96</td>\n",
       "      <td>4.81</td>\n",
       "      <td>4.84</td>\n",
       "      <td>1.88</td>\n",
       "      <td>17.5</td>\n",
       "      <td>-</td>\n",
       "      <td>4.15</td>\n",
       "      <td>7.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2006</td>\n",
       "      <td>7.43</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.22</td>\n",
       "      <td>...</td>\n",
       "      <td>4.74</td>\n",
       "      <td>0</td>\n",
       "      <td>5.8</td>\n",
       "      <td>8.25</td>\n",
       "      <td>7.62</td>\n",
       "      <td>3.14</td>\n",
       "      <td>2.74</td>\n",
       "      <td>-</td>\n",
       "      <td>7.75</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2005</td>\n",
       "      <td>3.91</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>6.8</td>\n",
       "      <td>6.95</td>\n",
       "      <td>8.67</td>\n",
       "      <td>6.62</td>\n",
       "      <td>7.88</td>\n",
       "      <td>-</td>\n",
       "      <td>9.14</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2004</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.99</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>3.21</td>\n",
       "      <td>4.36</td>\n",
       "      <td>7.75</td>\n",
       "      <td>5.3</td>\n",
       "      <td>6.19</td>\n",
       "      <td>-</td>\n",
       "      <td>4.49</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2003</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.24</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>1.47</td>\n",
       "      <td>-</td>\n",
       "      <td>2.71</td>\n",
       "      <td>4.65</td>\n",
       "      <td>6.19</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.77</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.83</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1999</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.08</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1998</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.7</td>\n",
       "      <td>...</td>\n",
       "      <td>6.89</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.54</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1996</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.89</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1995</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.06</td>\n",
       "      <td>...</td>\n",
       "      <td>6.41</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1994</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.62</td>\n",
       "      <td>...</td>\n",
       "      <td>6.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1993</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.27</td>\n",
       "      <td>...</td>\n",
       "      <td>9.15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.04</td>\n",
       "      <td>...</td>\n",
       "      <td>5.86</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>1991</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.57</td>\n",
       "      <td>...</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1990</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-</td>\n",
       "      <td>...</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>1989</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-</td>\n",
       "      <td>...</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>1988</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>1987</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>1986</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>1985</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>1984</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>1982</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>1983</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>1981</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>1980</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>1979</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>1978</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>1977</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>1976</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>1975</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>1974</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>1973</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>1972</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>1971</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>1970</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>53 rows × 2095 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      年度  0050  0051  0052  0053  0055  0056  0057 0061  1101  ...  9945  \\\n",
       "0   2022  4.09  4.35  9.63  2.91   3.7  7.17     0    0  4.93  ...  11.1   \n",
       "1   2021  2.48  3.22  0.82  2.56  3.48  5.42     0    0     7  ...  8.83   \n",
       "2   2020  3.71  2.97   2.4  2.88  3.68  5.61     0    0  7.05  ...  13.8   \n",
       "3   2019  3.61  3.68  1.83  4.18  3.88   6.7     0    0  9.77  ...  4.52   \n",
       "4   2018  3.55  3.13  3.24  3.14  3.75  5.62     0    0  6.37  ...  5.37   \n",
       "5   2017  3.05  2.89  2.88  3.34  3.23  3.78     0    0  4.13  ...  5.91   \n",
       "6   2016  1.28  2.78  5.99  3.53  3.42  5.67  4.22    0  4.03  ...     0   \n",
       "7   2015  3.01  3.06     0  3.22  3.01  4.33     0    0  6.58  ...  9.04   \n",
       "8   2014  2.43   2.5  6.38  3.24   2.8  4.12     0    0  5.03  ...  8.47   \n",
       "9   2013   2.4  2.85     0  3.16   2.7  3.61     0    0  4.77  ...  4.83   \n",
       "10  2012  3.54  2.91  7.72  2.46  2.28  5.49     0    0  5.31  ...  3.84   \n",
       "11  2011  3.45  3.09     0   4.1  2.32  8.54     0    0  5.43  ...  2.51   \n",
       "12  2010  4.02  3.15  4.17  3.88  3.31     0     0    0  5.91  ...  1.91   \n",
       "13  2009  2.21  7.15  5.07     0     0  10.3     0    -  4.07  ...  1.41   \n",
       "14  2008   3.9     0     0     0     0     0     -  NaN   5.2  ...  5.04   \n",
       "15  2007  4.03  2.19     0     -     -     -   NaN  NaN  4.77  ...  6.38   \n",
       "16  2006  7.43     -     -   NaN   NaN   NaN   NaN  NaN  6.22  ...  4.74   \n",
       "17  2005  3.91   NaN   NaN   NaN   NaN   NaN   NaN  NaN     6  ...     0   \n",
       "18  2004     0   NaN   NaN   NaN   NaN   NaN   NaN  NaN  3.99  ...     0   \n",
       "19  2003     -   NaN   NaN   NaN   NaN   NaN   NaN  NaN  2.24  ...     0   \n",
       "20  2002   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN     2  ...     0   \n",
       "21  2001   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN  2.77  ...     0   \n",
       "22  2000   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN  3.83  ...     0   \n",
       "23  1999   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN  5.08  ...     0   \n",
       "24  1998   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN   4.7  ...  6.89   \n",
       "25  1997   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN  2.54  ...     0   \n",
       "26  1996   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN  2.89  ...     0   \n",
       "27  1995   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN  5.06  ...  6.41   \n",
       "28  1994   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN  5.62  ...  6.29   \n",
       "29  1993   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN  5.27  ...  9.15   \n",
       "30  1992   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN  5.04  ...  5.86   \n",
       "31  1991   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN  3.57  ...     -   \n",
       "32  1990   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN     -  ...     -   \n",
       "33  1989   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN     -  ...     -   \n",
       "34  1988   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN     -  ...   NaN   \n",
       "35  1987   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN     -  ...   NaN   \n",
       "36  1986   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN     -  ...   NaN   \n",
       "37  1985   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN     -  ...   NaN   \n",
       "38  1984   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN     -  ...   NaN   \n",
       "39  1982   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN     -  ...   NaN   \n",
       "40  1983   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN   NaN  ...   NaN   \n",
       "41  1981   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN   NaN  ...   NaN   \n",
       "42  1980   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN   NaN  ...   NaN   \n",
       "43  1979   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN   NaN  ...   NaN   \n",
       "44  1978   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN   NaN  ...   NaN   \n",
       "45  1977   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN   NaN  ...   NaN   \n",
       "46  1976   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN   NaN  ...   NaN   \n",
       "47  1975   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN   NaN  ...   NaN   \n",
       "48  1974   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN   NaN  ...   NaN   \n",
       "49  1973   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN   NaN  ...   NaN   \n",
       "50  1972   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN   NaN  ...   NaN   \n",
       "51  1971   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN   NaN  ...   NaN   \n",
       "52  1970   NaN   NaN   NaN   NaN   NaN   NaN   NaN  NaN   NaN  ...   NaN   \n",
       "\n",
       "    9946  9949  9950  9951  9955  9957  9958  9960  9962  \n",
       "0   5.24     0     0  4.89     0     0  3.02  6.57  6.69  \n",
       "1   5.14     0     0  5.31     0     0  2.64  3.53     0  \n",
       "2    9.4     0     0   4.5     0     0  1.01  2.81  2.22  \n",
       "3   4.87     0     0  4.68     0     0  0.43  1.46  8.15  \n",
       "4     10     0     0  4.74     0     0  0.46     0  5.74  \n",
       "5   4.34     0  2.14  3.27     0     0  2.62  1.23  5.67  \n",
       "6   7.86     0  4.63  3.08     0     0     4  1.86     0  \n",
       "7    2.2  1.92  5.15  3.94     0     0  3.12  3.82  2.15  \n",
       "8   10.6   3.1   3.7  4.03     0     0  6.44  5.04  5.63  \n",
       "9   7.95  3.63  3.99  2.74  1.31     0  5.14  6.28  8.86  \n",
       "10     0  4.89  6.26  7.42     0     0     0  7.44  7.08  \n",
       "11     0  4.08  6.82  7.16  5.62  10.5  2.05  3.92  11.2  \n",
       "12     0   2.6  8.59     1  3.72  19.6  5.45  9.09  4.33  \n",
       "13     0  1.68  5.64     0  2.66     0     0  7.01     0  \n",
       "14     0  3.96  7.31  10.1  3.44  8.46  4.22  10.8   4.6  \n",
       "15  3.78  2.96  4.81  4.84  1.88  17.5     -  4.15  7.82  \n",
       "16     0   5.8  8.25  7.62  3.14  2.74     -  7.75   2.4  \n",
       "17    12   6.8  6.95  8.67  6.62  7.88     -  9.14     -  \n",
       "18     -  3.21  4.36  7.75   5.3  6.19     -  4.49     -  \n",
       "19     -  1.47     -  2.71  4.65  6.19     -     -     -  \n",
       "20     -     -     -     -     -   NaN   NaN   NaN   NaN  \n",
       "21     -     -   NaN     -     -   NaN     -   NaN     -  \n",
       "22     -     -     -   NaN   NaN   NaN     -   NaN     -  \n",
       "23     -   NaN   NaN   NaN   NaN   NaN     -   NaN   NaN  \n",
       "24   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "25   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "26   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "27   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "28   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "29   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "30   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "31   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "32   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "33   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "34   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "35   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "36   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "37   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "38   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "39   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "40   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "41   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "42   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "43   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "44   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "45   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "46   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "47   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "48   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "49   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "50   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "51   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "52   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "\n",
       "[53 rows x 2095 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for i in html_filename:\n",
    "    df_tmp = pd.read_html(i)[0]\n",
    "    df_tmp = df_tmp.iloc[1:, [0,18]]\n",
    "    df_tmp.columns = ['年度', i.split(\".\")[0]]\n",
    "    df_tmp = df_tmp[df_tmp.年度 != '∟']\n",
    "    df_tmp = df_tmp[df_tmp.年度 != '累計']\n",
    "    df = df_tmp.copy()\n",
    "    break\n",
    "for i in html_filename[1:]:\n",
    "    df_tmp = pd.read_html(i)[0]\n",
    "    df_tmp = df_tmp.iloc[1:, [0,18]]\n",
    "    df_tmp.columns = ['年度', i.split(\".\")[0]]\n",
    "    df_tmp = df_tmp[df_tmp.年度 != '∟']\n",
    "    df_tmp = df_tmp[df_tmp.年度 != '累計']\n",
    "    df = df.merge(df_tmp, on='年度', how='outer')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>43</th>\n",
       "      <th>44</th>\n",
       "      <th>45</th>\n",
       "      <th>46</th>\n",
       "      <th>47</th>\n",
       "      <th>48</th>\n",
       "      <th>49</th>\n",
       "      <th>50</th>\n",
       "      <th>51</th>\n",
       "      <th>52</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>股票代號╲年度</th>\n",
       "      <td>2022</td>\n",
       "      <td>2021</td>\n",
       "      <td>2020</td>\n",
       "      <td>2019</td>\n",
       "      <td>2018</td>\n",
       "      <td>2017</td>\n",
       "      <td>2016</td>\n",
       "      <td>2015</td>\n",
       "      <td>2014</td>\n",
       "      <td>2013</td>\n",
       "      <td>...</td>\n",
       "      <td>1979</td>\n",
       "      <td>1978</td>\n",
       "      <td>1977</td>\n",
       "      <td>1976</td>\n",
       "      <td>1975</td>\n",
       "      <td>1974</td>\n",
       "      <td>1973</td>\n",
       "      <td>1972</td>\n",
       "      <td>1971</td>\n",
       "      <td>1970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0050</th>\n",
       "      <td>4.09</td>\n",
       "      <td>2.48</td>\n",
       "      <td>3.71</td>\n",
       "      <td>3.61</td>\n",
       "      <td>3.55</td>\n",
       "      <td>3.05</td>\n",
       "      <td>1.28</td>\n",
       "      <td>3.01</td>\n",
       "      <td>2.43</td>\n",
       "      <td>2.4</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0051</th>\n",
       "      <td>4.35</td>\n",
       "      <td>3.22</td>\n",
       "      <td>2.97</td>\n",
       "      <td>3.68</td>\n",
       "      <td>3.13</td>\n",
       "      <td>2.89</td>\n",
       "      <td>2.78</td>\n",
       "      <td>3.06</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.85</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0052</th>\n",
       "      <td>9.63</td>\n",
       "      <td>0.82</td>\n",
       "      <td>2.4</td>\n",
       "      <td>1.83</td>\n",
       "      <td>3.24</td>\n",
       "      <td>2.88</td>\n",
       "      <td>5.99</td>\n",
       "      <td>0</td>\n",
       "      <td>6.38</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0053</th>\n",
       "      <td>2.91</td>\n",
       "      <td>2.56</td>\n",
       "      <td>2.88</td>\n",
       "      <td>4.18</td>\n",
       "      <td>3.14</td>\n",
       "      <td>3.34</td>\n",
       "      <td>3.53</td>\n",
       "      <td>3.22</td>\n",
       "      <td>3.24</td>\n",
       "      <td>3.16</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9955</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.31</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9957</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9958</th>\n",
       "      <td>3.02</td>\n",
       "      <td>2.64</td>\n",
       "      <td>1.01</td>\n",
       "      <td>0.43</td>\n",
       "      <td>0.46</td>\n",
       "      <td>2.62</td>\n",
       "      <td>4</td>\n",
       "      <td>3.12</td>\n",
       "      <td>6.44</td>\n",
       "      <td>5.14</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9960</th>\n",
       "      <td>6.57</td>\n",
       "      <td>3.53</td>\n",
       "      <td>2.81</td>\n",
       "      <td>1.46</td>\n",
       "      <td>0</td>\n",
       "      <td>1.23</td>\n",
       "      <td>1.86</td>\n",
       "      <td>3.82</td>\n",
       "      <td>5.04</td>\n",
       "      <td>6.28</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9962</th>\n",
       "      <td>6.69</td>\n",
       "      <td>0</td>\n",
       "      <td>2.22</td>\n",
       "      <td>8.15</td>\n",
       "      <td>5.74</td>\n",
       "      <td>5.67</td>\n",
       "      <td>0</td>\n",
       "      <td>2.15</td>\n",
       "      <td>5.63</td>\n",
       "      <td>8.86</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2095 rows × 53 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           0     1     2     3     4     5     6     7     8     9   ...  \\\n",
       "股票代號╲年度  2022  2021  2020  2019  2018  2017  2016  2015  2014  2013  ...   \n",
       "0050     4.09  2.48  3.71  3.61  3.55  3.05  1.28  3.01  2.43   2.4  ...   \n",
       "0051     4.35  3.22  2.97  3.68  3.13  2.89  2.78  3.06   2.5  2.85  ...   \n",
       "0052     9.63  0.82   2.4  1.83  3.24  2.88  5.99     0  6.38     0  ...   \n",
       "0053     2.91  2.56  2.88  4.18  3.14  3.34  3.53  3.22  3.24  3.16  ...   \n",
       "...       ...   ...   ...   ...   ...   ...   ...   ...   ...   ...  ...   \n",
       "9955        0     0     0     0     0     0     0     0     0  1.31  ...   \n",
       "9957        0     0     0     0     0     0     0     0     0     0  ...   \n",
       "9958     3.02  2.64  1.01  0.43  0.46  2.62     4  3.12  6.44  5.14  ...   \n",
       "9960     6.57  3.53  2.81  1.46     0  1.23  1.86  3.82  5.04  6.28  ...   \n",
       "9962     6.69     0  2.22  8.15  5.74  5.67     0  2.15  5.63  8.86  ...   \n",
       "\n",
       "           43    44    45    46    47    48    49    50    51    52  \n",
       "股票代號╲年度  1979  1978  1977  1976  1975  1974  1973  1972  1971  1970  \n",
       "0050      NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "0051      NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "0052      NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "0053      NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "...       ...   ...   ...   ...   ...   ...   ...   ...   ...   ...  \n",
       "9955      NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "9957      NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "9958      NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "9960      NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "9962      NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "\n",
       "[2095 rows x 53 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 = df.T.rename({'年度': '股票代號╲年度'}, axis='rows')\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2.to_csv('test.csv', encoding='cp950', header=False, index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "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>股票代號╲年度</th>\n",
       "      <th>2022</th>\n",
       "      <th>2021</th>\n",
       "      <th>2020</th>\n",
       "      <th>2019</th>\n",
       "      <th>2018</th>\n",
       "      <th>2017</th>\n",
       "      <th>2016</th>\n",
       "      <th>2015</th>\n",
       "      <th>2014</th>\n",
       "      <th>...</th>\n",
       "      <th>1979</th>\n",
       "      <th>1978</th>\n",
       "      <th>1977</th>\n",
       "      <th>1976</th>\n",
       "      <th>1975</th>\n",
       "      <th>1974</th>\n",
       "      <th>1973</th>\n",
       "      <th>1972</th>\n",
       "      <th>1971</th>\n",
       "      <th>1970</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>50</td>\n",
       "      <td>4.09</td>\n",
       "      <td>2.48</td>\n",
       "      <td>3.71</td>\n",
       "      <td>3.61</td>\n",
       "      <td>3.55</td>\n",
       "      <td>3.05</td>\n",
       "      <td>1.28</td>\n",
       "      <td>3.01</td>\n",
       "      <td>2.43</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>51</td>\n",
       "      <td>4.35</td>\n",
       "      <td>3.22</td>\n",
       "      <td>2.97</td>\n",
       "      <td>3.68</td>\n",
       "      <td>3.13</td>\n",
       "      <td>2.89</td>\n",
       "      <td>2.78</td>\n",
       "      <td>3.06</td>\n",
       "      <td>2.5</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>52</td>\n",
       "      <td>9.63</td>\n",
       "      <td>0.82</td>\n",
       "      <td>2.4</td>\n",
       "      <td>1.83</td>\n",
       "      <td>3.24</td>\n",
       "      <td>2.88</td>\n",
       "      <td>5.99</td>\n",
       "      <td>0</td>\n",
       "      <td>6.38</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>53</td>\n",
       "      <td>2.91</td>\n",
       "      <td>2.56</td>\n",
       "      <td>2.88</td>\n",
       "      <td>4.18</td>\n",
       "      <td>3.14</td>\n",
       "      <td>3.34</td>\n",
       "      <td>3.53</td>\n",
       "      <td>3.22</td>\n",
       "      <td>3.24</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>55</td>\n",
       "      <td>3.7</td>\n",
       "      <td>3.48</td>\n",
       "      <td>3.68</td>\n",
       "      <td>3.88</td>\n",
       "      <td>3.75</td>\n",
       "      <td>3.23</td>\n",
       "      <td>3.42</td>\n",
       "      <td>3.01</td>\n",
       "      <td>2.8</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2089</th>\n",
       "      <td>9955</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2090</th>\n",
       "      <td>9957</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2091</th>\n",
       "      <td>9958</td>\n",
       "      <td>3.02</td>\n",
       "      <td>2.64</td>\n",
       "      <td>1.01</td>\n",
       "      <td>0.43</td>\n",
       "      <td>0.46</td>\n",
       "      <td>2.62</td>\n",
       "      <td>4</td>\n",
       "      <td>3.12</td>\n",
       "      <td>6.44</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2092</th>\n",
       "      <td>9960</td>\n",
       "      <td>6.57</td>\n",
       "      <td>3.53</td>\n",
       "      <td>2.81</td>\n",
       "      <td>1.46</td>\n",
       "      <td>0</td>\n",
       "      <td>1.23</td>\n",
       "      <td>1.86</td>\n",
       "      <td>3.82</td>\n",
       "      <td>5.04</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2093</th>\n",
       "      <td>9962</td>\n",
       "      <td>6.69</td>\n",
       "      <td>0</td>\n",
       "      <td>2.22</td>\n",
       "      <td>8.15</td>\n",
       "      <td>5.74</td>\n",
       "      <td>5.67</td>\n",
       "      <td>0</td>\n",
       "      <td>2.15</td>\n",
       "      <td>5.63</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2094 rows × 54 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      股票代號╲年度  2022  2021  2020  2019  2018  2017  2016  2015  2014  ... 1979  \\\n",
       "0          50  4.09  2.48  3.71  3.61  3.55  3.05  1.28  3.01  2.43  ...  NaN   \n",
       "1          51  4.35  3.22  2.97  3.68  3.13  2.89  2.78  3.06   2.5  ...  NaN   \n",
       "2          52  9.63  0.82   2.4  1.83  3.24  2.88  5.99     0  6.38  ...  NaN   \n",
       "3          53  2.91  2.56  2.88  4.18  3.14  3.34  3.53  3.22  3.24  ...  NaN   \n",
       "4          55   3.7  3.48  3.68  3.88  3.75  3.23  3.42  3.01   2.8  ...  NaN   \n",
       "...       ...   ...   ...   ...   ...   ...   ...   ...   ...   ...  ...  ...   \n",
       "2089     9955     0     0     0     0     0     0     0     0     0  ...  NaN   \n",
       "2090     9957     0     0     0     0     0     0     0     0     0  ...  NaN   \n",
       "2091     9958  3.02  2.64  1.01  0.43  0.46  2.62     4  3.12  6.44  ...  NaN   \n",
       "2092     9960  6.57  3.53  2.81  1.46     0  1.23  1.86  3.82  5.04  ...  NaN   \n",
       "2093     9962  6.69     0  2.22  8.15  5.74  5.67     0  2.15  5.63  ...  NaN   \n",
       "\n",
       "     1978 1977 1976 1975 1974 1973 1972 1971 1970  \n",
       "0     NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "1     NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "2     NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "3     NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "4     NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "...   ...  ...  ...  ...  ...  ...  ...  ...  ...  \n",
       "2089  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "2090  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "2091  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "2092  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "2093  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "\n",
       "[2094 rows x 54 columns]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_csv('test.csv', encoding='cp950')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "accelerator": "GPU",
  "colab": {
   "collapsed_sections": [],
   "name": "03.ipynb",
   "provenance": []
  },
  "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.10.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}