財務數據撈取.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tejapi\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "tejapi.ApiConfig.api_key = 'Your Key'\n",
    "tejapi.ApiConfig.ignoretz = True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "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",
       "      <th>會計科目</th>\n",
       "      <th>數值</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>None</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2409</td>\n",
       "      <td>2000-12-01</td>\n",
       "      <td>0010</td>\n",
       "      <td>45033252.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2409</td>\n",
       "      <td>2000-12-01</td>\n",
       "      <td>0020</td>\n",
       "      <td>45033252.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2409</td>\n",
       "      <td>2000-12-01</td>\n",
       "      <td>0100</td>\n",
       "      <td>8177473.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2409</td>\n",
       "      <td>2000-12-01</td>\n",
       "      <td>0112</td>\n",
       "      <td>1036666.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2409</td>\n",
       "      <td>2000-12-01</td>\n",
       "      <td>012C</td>\n",
       "      <td>1566289.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13017</th>\n",
       "      <td>2409</td>\n",
       "      <td>2021-03-01</td>\n",
       "      <td>R699</td>\n",
       "      <td>11755126.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13018</th>\n",
       "      <td>2409</td>\n",
       "      <td>2021-03-01</td>\n",
       "      <td>R69B</td>\n",
       "      <td>4669191.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13019</th>\n",
       "      <td>2409</td>\n",
       "      <td>2021-03-01</td>\n",
       "      <td>R834</td>\n",
       "      <td>1835.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13020</th>\n",
       "      <td>2409</td>\n",
       "      <td>2021-03-01</td>\n",
       "      <td>R835</td>\n",
       "      <td>265.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13021</th>\n",
       "      <td>2409</td>\n",
       "      <td>2021-03-01</td>\n",
       "      <td>R836</td>\n",
       "      <td>4012.58</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>13022 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       公司代碼       財報年月  會計科目           數值\n",
       "None                                     \n",
       "0      2409 2000-12-01  0010  45033252.00\n",
       "1      2409 2000-12-01  0020  45033252.00\n",
       "2      2409 2000-12-01  0100   8177473.00\n",
       "3      2409 2000-12-01  0112   1036666.00\n",
       "4      2409 2000-12-01  012C   1566289.00\n",
       "...     ...        ...   ...          ...\n",
       "13017  2409 2021-03-01  R699  11755126.00\n",
       "13018  2409 2021-03-01  R69B   4669191.00\n",
       "13019  2409 2021-03-01  R834      1835.05\n",
       "13020  2409 2021-03-01  R835       265.90\n",
       "13021  2409 2021-03-01  R836      4012.58\n",
       "\n",
       "[13022 rows x 4 columns]"
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#撈取友達，所有會計科目，不使用pivot()\n",
    "au_no_pivot = tejapi.get('TWN/AIM1A',\n",
    "                    coid = '2409',\n",
    "                    paginate = True,\n",
    "                    chinese_column_name = True)\n",
    "au_no_pivot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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",
       "      <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>財報類別（1個別2個體3合併）</th>\n",
       "      <th>財報年月起日</th>\n",
       "      <th>財報年月迄日</th>\n",
       "      <th>市場別</th>\n",
       "      <th>交易所主產業代碼</th>\n",
       "      <th>交易所子產業代碼</th>\n",
       "      <th>TEJ主產業代碼</th>\n",
       "      <th>TEJ子產業代碼</th>\n",
       "      <th>財報附註TEJ是否完成Y/N</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>None</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></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2409</td>\n",
       "      <td>2000-12-01</td>\n",
       "      <td>1036666.0</td>\n",
       "      <td>1566289.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1766939.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2409</td>\n",
       "      <td>2001-12-01</td>\n",
       "      <td>6496268.0</td>\n",
       "      <td>5026543.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8998004.0</td>\n",
       "      <td>23653.0</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2409</td>\n",
       "      <td>2002-12-01</td>\n",
       "      <td>25957194.0</td>\n",
       "      <td>3231835.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10047124.0</td>\n",
       "      <td>14340.0</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2409</td>\n",
       "      <td>2003-12-01</td>\n",
       "      <td>17962082.0</td>\n",
       "      <td>2286504.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16946559.0</td>\n",
       "      <td>14420.0</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2409</td>\n",
       "      <td>2004-12-01</td>\n",
       "      <td>17797663.0</td>\n",
       "      <td>1586504.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20715617.0</td>\n",
       "      <td>2358.0</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</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>59</th>\n",
       "      <td>2409</td>\n",
       "      <td>2020-03-01</td>\n",
       "      <td>76788669.0</td>\n",
       "      <td>1604981.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>94440.0</td>\n",
       "      <td>27884039.0</td>\n",
       "      <td>42761.0</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>2409</td>\n",
       "      <td>2020-06-01</td>\n",
       "      <td>72155424.0</td>\n",
       "      <td>976939.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>36970692.0</td>\n",
       "      <td>332248.0</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>2409</td>\n",
       "      <td>2020-09-01</td>\n",
       "      <td>78300196.0</td>\n",
       "      <td>1485597.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>44752956.0</td>\n",
       "      <td>49384.0</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>2409</td>\n",
       "      <td>2020-12-01</td>\n",
       "      <td>90274687.0</td>\n",
       "      <td>668058.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>46794956.0</td>\n",
       "      <td>21929.0</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>2409</td>\n",
       "      <td>2021-03-01</td>\n",
       "      <td>103783772.0</td>\n",
       "      <td>53246.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>506651.0</td>\n",
       "      <td>53382876.0</td>\n",
       "      <td>1609.0</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>64 rows × 277 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      公司代碼       財報年月      現金及約當現金  透過損益按公允價值衡量之金融資產－流動  \\\n",
       "None                                                      \n",
       "0     2409 2000-12-01    1036666.0            1566289.0   \n",
       "1     2409 2001-12-01    6496268.0            5026543.0   \n",
       "2     2409 2002-12-01   25957194.0            3231835.0   \n",
       "3     2409 2003-12-01   17962082.0            2286504.0   \n",
       "4     2409 2004-12-01   17797663.0            1586504.0   \n",
       "...    ...        ...          ...                  ...   \n",
       "59    2409 2020-03-01   76788669.0            1604981.0   \n",
       "60    2409 2020-06-01   72155424.0             976939.0   \n",
       "61    2409 2020-09-01   78300196.0            1485597.0   \n",
       "62    2409 2020-12-01   90274687.0             668058.0   \n",
       "63    2409 2021-03-01  103783772.0              53246.0   \n",
       "\n",
       "      透過其他綜合損益按公允價值衡量之金融資產－流動  按攤銷後成本衡量之金融資產－流動  避險之金融資產－流動   合約資產－流動  \\\n",
       "None                                                                    \n",
       "0                         NaN               NaN         NaN       NaN   \n",
       "1                         NaN               NaN         NaN       NaN   \n",
       "2                         NaN               NaN         NaN       NaN   \n",
       "3                         NaN               NaN         NaN       NaN   \n",
       "4                         NaN               NaN         NaN       NaN   \n",
       "...                       ...               ...         ...       ...   \n",
       "59                        0.0               0.0         0.0   94440.0   \n",
       "60                        0.0               0.0         0.0       0.0   \n",
       "61                        0.0               0.0         0.0       0.0   \n",
       "62                        0.0               0.0         0.0       0.0   \n",
       "63                        0.0               0.0         0.0  506651.0   \n",
       "\n",
       "         應收帳款及票據     其他應收款  ...  財報發布日  財報類別（1個別2個體3合併）  財報年月起日  財報年月迄日   市場別  \\\n",
       "None                        ...                                                 \n",
       "0      1766939.0       0.0  ...   None             None    None    None  None   \n",
       "1      8998004.0   23653.0  ...   None             None    None    None  None   \n",
       "2     10047124.0   14340.0  ...   None             None    None    None  None   \n",
       "3     16946559.0   14420.0  ...   None             None    None    None  None   \n",
       "4     20715617.0    2358.0  ...   None             None    None    None  None   \n",
       "...          ...       ...  ...    ...              ...     ...     ...   ...   \n",
       "59    27884039.0   42761.0  ...   None             None    None    None  None   \n",
       "60    36970692.0  332248.0  ...   None             None    None    None  None   \n",
       "61    44752956.0   49384.0  ...   None             None    None    None  None   \n",
       "62    46794956.0   21929.0  ...   None             None    None    None  None   \n",
       "63    53382876.0    1609.0  ...   None             None    None    None  None   \n",
       "\n",
       "      交易所主產業代碼  交易所子產業代碼  TEJ主產業代碼  TEJ子產業代碼  財報附註TEJ是否完成Y/N  \n",
       "None                                                          \n",
       "0         None      None      None      None            None  \n",
       "1         None      None      None      None            None  \n",
       "2         None      None      None      None            None  \n",
       "3         None      None      None      None            None  \n",
       "4         None      None      None      None            None  \n",
       "...        ...       ...       ...       ...             ...  \n",
       "59        None      None      None      None            None  \n",
       "60        None      None      None      None            None  \n",
       "61        None      None      None      None            None  \n",
       "62        None      None      None      None            None  \n",
       "63        None      None      None      None            None  \n",
       "\n",
       "[64 rows x 277 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#撈取一家公司，所有會計科目，使用pivot()\n",
    "au_pivot = tejapi.get('TWN/AIM1A',\n",
    "                    coid = '2409',\n",
    "                    paginate = True,\n",
    "                    opts = {'pivot':True},\n",
    "                    chinese_column_name = True)\n",
    "au_pivot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "#空dataframe\n",
    "panel = ['2409','3481','6116']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "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",
       "      <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>財報類別（1個別2個體3合併）</th>\n",
       "      <th>財報年月起日</th>\n",
       "      <th>財報年月迄日</th>\n",
       "      <th>市場別</th>\n",
       "      <th>交易所主產業代碼</th>\n",
       "      <th>交易所子產業代碼</th>\n",
       "      <th>TEJ主產業代碼</th>\n",
       "      <th>TEJ子產業代碼</th>\n",
       "      <th>財報附註TEJ是否完成Y/N</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>None</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></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2409</td>\n",
       "      <td>2000-12-01</td>\n",
       "      <td>1036666.0</td>\n",
       "      <td>1566289.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1766939.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2409</td>\n",
       "      <td>2001-12-01</td>\n",
       "      <td>6496268.0</td>\n",
       "      <td>5026543.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8998004.0</td>\n",
       "      <td>23653.0</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2409</td>\n",
       "      <td>2002-12-01</td>\n",
       "      <td>25957194.0</td>\n",
       "      <td>3231835.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10047124.0</td>\n",
       "      <td>14340.0</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2409</td>\n",
       "      <td>2003-12-01</td>\n",
       "      <td>17962082.0</td>\n",
       "      <td>2286504.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16946559.0</td>\n",
       "      <td>14420.0</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2409</td>\n",
       "      <td>2004-12-01</td>\n",
       "      <td>17797663.0</td>\n",
       "      <td>1586504.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20715617.0</td>\n",
       "      <td>2358.0</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</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>59</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-03-01</td>\n",
       "      <td>4026167.0</td>\n",
       "      <td>157362.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10704344.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1800488.0</td>\n",
       "      <td>163320.0</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-06-01</td>\n",
       "      <td>3420442.0</td>\n",
       "      <td>161798.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10578239.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1809163.0</td>\n",
       "      <td>117998.0</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-09-01</td>\n",
       "      <td>4138213.0</td>\n",
       "      <td>167239.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11809023.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1650496.0</td>\n",
       "      <td>123459.0</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-12-01</td>\n",
       "      <td>4159293.0</td>\n",
       "      <td>31434.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16569180.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1786461.0</td>\n",
       "      <td>92548.0</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>6116</td>\n",
       "      <td>2021-03-01</td>\n",
       "      <td>6690554.0</td>\n",
       "      <td>441655.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17203133.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2539352.0</td>\n",
       "      <td>112747.0</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>189 rows × 277 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      公司代碼       財報年月     現金及約當現金  透過損益按公允價值衡量之金融資產－流動  \\\n",
       "None                                                     \n",
       "0     2409 2000-12-01   1036666.0            1566289.0   \n",
       "1     2409 2001-12-01   6496268.0            5026543.0   \n",
       "2     2409 2002-12-01  25957194.0            3231835.0   \n",
       "3     2409 2003-12-01  17962082.0            2286504.0   \n",
       "4     2409 2004-12-01  17797663.0            1586504.0   \n",
       "...    ...        ...         ...                  ...   \n",
       "59    6116 2020-03-01   4026167.0             157362.0   \n",
       "60    6116 2020-06-01   3420442.0             161798.0   \n",
       "61    6116 2020-09-01   4138213.0             167239.0   \n",
       "62    6116 2020-12-01   4159293.0              31434.0   \n",
       "63    6116 2021-03-01   6690554.0             441655.0   \n",
       "\n",
       "      透過其他綜合損益按公允價值衡量之金融資產－流動  按攤銷後成本衡量之金融資產－流動  避險之金融資產－流動  合約資產－流動  \\\n",
       "None                                                                   \n",
       "0                         NaN               NaN         NaN      NaN   \n",
       "1                         NaN               NaN         NaN      NaN   \n",
       "2                         NaN               NaN         NaN      NaN   \n",
       "3                         NaN               NaN         NaN      NaN   \n",
       "4                         NaN               NaN         NaN      NaN   \n",
       "...                       ...               ...         ...      ...   \n",
       "59                        0.0        10704344.0         0.0      0.0   \n",
       "60                        0.0        10578239.0         0.0      0.0   \n",
       "61                        0.0        11809023.0         0.0      0.0   \n",
       "62                        0.0        16569180.0         0.0      0.0   \n",
       "63                        0.0        17203133.0         0.0      0.0   \n",
       "\n",
       "         應收帳款及票據     其他應收款  ...  財報發布日  財報類別（1個別2個體3合併）  財報年月起日  財報年月迄日   市場別  \\\n",
       "None                        ...                                                 \n",
       "0      1766939.0       0.0  ...   None             None    None    None  None   \n",
       "1      8998004.0   23653.0  ...   None             None    None    None  None   \n",
       "2     10047124.0   14340.0  ...   None             None    None    None  None   \n",
       "3     16946559.0   14420.0  ...   None             None    None    None  None   \n",
       "4     20715617.0    2358.0  ...   None             None    None    None  None   \n",
       "...          ...       ...  ...    ...              ...     ...     ...   ...   \n",
       "59     1800488.0  163320.0  ...   None             None    None    None  None   \n",
       "60     1809163.0  117998.0  ...   None             None    None    None  None   \n",
       "61     1650496.0  123459.0  ...   None             None    None    None  None   \n",
       "62     1786461.0   92548.0  ...   None             None    None    None  None   \n",
       "63     2539352.0  112747.0  ...   None             None    None    None  None   \n",
       "\n",
       "      交易所主產業代碼  交易所子產業代碼  TEJ主產業代碼  TEJ子產業代碼  財報附註TEJ是否完成Y/N  \n",
       "None                                                          \n",
       "0         None      None      None      None            None  \n",
       "1         None      None      None      None            None  \n",
       "2         None      None      None      None            None  \n",
       "3         None      None      None      None            None  \n",
       "4         None      None      None      None            None  \n",
       "...        ...       ...       ...       ...             ...  \n",
       "59        None      None      None      None            None  \n",
       "60        None      None      None      None            None  \n",
       "61        None      None      None      None            None  \n",
       "62        None      None      None      None            None  \n",
       "63        None      None      None      None            None  \n",
       "\n",
       "[189 rows x 277 columns]"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#三家公司、所有科目示範\n",
    "finance = pd.DataFrame()\n",
    "for firm in panel:\n",
    "    finance = finance.append(tejapi.get('TWN/AIM1A',\n",
    "                    coid = firm,\n",
    "                    paginate = True,\n",
    "                    opts = {'pivot':True},\n",
    "                    chinese_column_name = True))\n",
    "finance"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "#會計科目欄位查詢\n",
    "accounting = tejapi.get('TWN/AIACC',\n",
    "                       id = 'AIM1A',  #這邊要注意一下，因為要挑選簡表欄位\n",
    "                       paginate = True,\n",
    "                       chinese_column_name = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "scrolled": true
   },
   "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>分類ID</th>\n",
       "      <th>會計科目</th>\n",
       "      <th>順序</th>\n",
       "      <th>中文全稱</th>\n",
       "      <th>英文全稱</th>\n",
       "      <th>單位</th>\n",
       "      <th>中文表次</th>\n",
       "      <th>英文表次</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>None</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>0000</td>\n",
       "      <td>270</td>\n",
       "      <td>市場別</td>\n",
       "      <td>Market</td>\n",
       "      <td>-</td>\n",
       "      <td>其他</td>\n",
       "      <td>Other</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>0002</td>\n",
       "      <td>267</td>\n",
       "      <td>財報類別（1個別2個體3合併）</td>\n",
       "      <td>Financial Report Type (1.Individual 2. Parent ...</td>\n",
       "      <td>T</td>\n",
       "      <td>其他</td>\n",
       "      <td>Other</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>0003</td>\n",
       "      <td>266</td>\n",
       "      <td>財報發布日</td>\n",
       "      <td>Date of preparation of financial statements</td>\n",
       "      <td>-</td>\n",
       "      <td>其他</td>\n",
       "      <td>Other</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>0004</td>\n",
       "      <td>268</td>\n",
       "      <td>財報年月起日</td>\n",
       "      <td>Fiscal Year Start Date</td>\n",
       "      <td>-</td>\n",
       "      <td>其他</td>\n",
       "      <td>Other</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>0005</td>\n",
       "      <td>269</td>\n",
       "      <td>財報年月迄日</td>\n",
       "      <td>Fiscal Year End Date</td>\n",
       "      <td>-</td>\n",
       "      <td>其他</td>\n",
       "      <td>Other</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>R699</td>\n",
       "      <td>229</td>\n",
       "      <td>淨負債</td>\n",
       "      <td>Net DEBT</td>\n",
       "      <td>T</td>\n",
       "      <td>償債能力指標</td>\n",
       "      <td>Liquidity Analysis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>R69B</td>\n",
       "      <td>250</td>\n",
       "      <td>自由現金流量(D)</td>\n",
       "      <td>Free Cash Flow (D)</td>\n",
       "      <td>T</td>\n",
       "      <td>經營能力指標</td>\n",
       "      <td>Operating Performance Analysis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>R834</td>\n",
       "      <td>255</td>\n",
       "      <td>每人營收</td>\n",
       "      <td>Revenue Per Employee</td>\n",
       "      <td>T</td>\n",
       "      <td>其他</td>\n",
       "      <td>Other</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>R835</td>\n",
       "      <td>256</td>\n",
       "      <td>每人營業利益</td>\n",
       "      <td>Operation Income Per Employee</td>\n",
       "      <td>T</td>\n",
       "      <td>其他</td>\n",
       "      <td>Other</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>R836</td>\n",
       "      <td>257</td>\n",
       "      <td>每人配備率</td>\n",
       "      <td>Fixed Assets Per Employee</td>\n",
       "      <td>T</td>\n",
       "      <td>其他</td>\n",
       "      <td>Other</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>275 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       分類ID  會計科目   順序             中文全稱  \\\n",
       "None                                      \n",
       "0     AIM1A  0000  270              市場別   \n",
       "1     AIM1A  0002  267  財報類別（1個別2個體3合併）   \n",
       "2     AIM1A  0003  266            財報發布日   \n",
       "3     AIM1A  0004  268           財報年月起日   \n",
       "4     AIM1A  0005  269           財報年月迄日   \n",
       "...     ...   ...  ...              ...   \n",
       "270   AIM1A  R699  229              淨負債   \n",
       "271   AIM1A  R69B  250        自由現金流量(D)   \n",
       "272   AIM1A  R834  255             每人營收   \n",
       "273   AIM1A  R835  256           每人營業利益   \n",
       "274   AIM1A  R836  257            每人配備率   \n",
       "\n",
       "                                                   英文全稱 單位    中文表次  \\\n",
       "None                                                                 \n",
       "0                                                Market  -      其他   \n",
       "1     Financial Report Type (1.Individual 2. Parent ...  T      其他   \n",
       "2           Date of preparation of financial statements  -      其他   \n",
       "3                                Fiscal Year Start Date  -      其他   \n",
       "4                                  Fiscal Year End Date  -      其他   \n",
       "...                                                 ... ..     ...   \n",
       "270                                            Net DEBT  T  償債能力指標   \n",
       "271                                  Free Cash Flow (D)  T  經營能力指標   \n",
       "272                                Revenue Per Employee  T      其他   \n",
       "273                       Operation Income Per Employee  T      其他   \n",
       "274                           Fixed Assets Per Employee  T      其他   \n",
       "\n",
       "                                英文表次  \n",
       "None                                  \n",
       "0                              Other  \n",
       "1                              Other  \n",
       "2                              Other  \n",
       "3                              Other  \n",
       "4                              Other  \n",
       "...                              ...  \n",
       "270               Liquidity Analysis  \n",
       "271   Operating Performance Analysis  \n",
       "272                            Other  \n",
       "273                            Other  \n",
       "274                            Other  \n",
       "\n",
       "[275 rows x 8 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "accounting"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "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>分類ID</th>\n",
       "      <th>會計科目</th>\n",
       "      <th>順序</th>\n",
       "      <th>中文全稱</th>\n",
       "      <th>英文全稱</th>\n",
       "      <th>單位</th>\n",
       "      <th>中文表次</th>\n",
       "      <th>英文表次</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>None</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>2403</td>\n",
       "      <td>124</td>\n",
       "      <td>稅前息前折舊前淨利</td>\n",
       "      <td>Earnings before interest, tax, depreciation an...</td>\n",
       "      <td>T</td>\n",
       "      <td>損益表</td>\n",
       "      <td>Income Statement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>7211</td>\n",
       "      <td>142</td>\n",
       "      <td>折舊－CFO</td>\n",
       "      <td>Depreciation expense</td>\n",
       "      <td>T</td>\n",
       "      <td>現金流量表</td>\n",
       "      <td>Cash Flow Statement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>R100</td>\n",
       "      <td>164</td>\n",
       "      <td>ROA(C)稅前息前折舊前</td>\n",
       "      <td>Return on Assets Ratio (C) - Recurring Income ...</td>\n",
       "      <td>-</td>\n",
       "      <td>獲利能力指標</td>\n",
       "      <td>Profitability Analysis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>R102</td>\n",
       "      <td>166</td>\n",
       "      <td>ROA(B)稅後息前折舊前</td>\n",
       "      <td>Return on Assets Ratio (B) - Recurring Income ...</td>\n",
       "      <td>-</td>\n",
       "      <td>獲利能力指標</td>\n",
       "      <td>Profitability Analysis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>R145</td>\n",
       "      <td>169</td>\n",
       "      <td>稅前息前折舊前淨利率</td>\n",
       "      <td>Net Profit Margin - Before Interest, Taxes, De...</td>\n",
       "      <td>-</td>\n",
       "      <td>獲利能力指標</td>\n",
       "      <td>Profitability Analysis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>R410</td>\n",
       "      <td>212</td>\n",
       "      <td>折舊性FA成長率</td>\n",
       "      <td>Depreciable Fixed Assets Growth Rate - YOY</td>\n",
       "      <td>-</td>\n",
       "      <td>成長率指標</td>\n",
       "      <td>Growth Analysis</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       分類ID  會計科目   順序           中文全稱  \\\n",
       "None                                    \n",
       "98    AIM1A  2403  124      稅前息前折舊前淨利   \n",
       "161   AIM1A  7211  142         折舊－CFO   \n",
       "179   AIM1A  R100  164  ROA(C)稅前息前折舊前   \n",
       "181   AIM1A  R102  166  ROA(B)稅後息前折舊前   \n",
       "191   AIM1A  R145  169     稅前息前折舊前淨利率   \n",
       "226   AIM1A  R410  212       折舊性FA成長率   \n",
       "\n",
       "                                                   英文全稱 單位    中文表次  \\\n",
       "None                                                                 \n",
       "98    Earnings before interest, tax, depreciation an...  T     損益表   \n",
       "161                                Depreciation expense  T   現金流量表   \n",
       "179   Return on Assets Ratio (C) - Recurring Income ...  -  獲利能力指標   \n",
       "181   Return on Assets Ratio (B) - Recurring Income ...  -  獲利能力指標   \n",
       "191   Net Profit Margin - Before Interest, Taxes, De...  -  獲利能力指標   \n",
       "226          Depreciable Fixed Assets Growth Rate - YOY  -   成長率指標   \n",
       "\n",
       "                        英文表次  \n",
       "None                          \n",
       "98          Income Statement  \n",
       "161      Cash Flow Statement  \n",
       "179   Profitability Analysis  \n",
       "181   Profitability Analysis  \n",
       "191   Profitability Analysis  \n",
       "226          Growth Analysis  "
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#查詢對應科目的方式(用中文全稱or英文全稱)，可順便留意單位\n",
    "#折舊\n",
    "depreciation = accounting[accounting['中文全稱'].str.contains('折舊')]\n",
    "depreciation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "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>分類ID</th>\n",
       "      <th>會計科目</th>\n",
       "      <th>順序</th>\n",
       "      <th>中文全稱</th>\n",
       "      <th>英文全稱</th>\n",
       "      <th>單位</th>\n",
       "      <th>中文表次</th>\n",
       "      <th>英文表次</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>None</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>7211</td>\n",
       "      <td>142</td>\n",
       "      <td>折舊－CFO</td>\n",
       "      <td>Depreciation expense</td>\n",
       "      <td>T</td>\n",
       "      <td>現金流量表</td>\n",
       "      <td>Cash Flow Statement</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       分類ID  會計科目   順序    中文全稱                  英文全稱 單位   中文表次  \\\n",
       "None                                                             \n",
       "161   AIM1A  7211  142  折舊－CFO  Depreciation expense  T  現金流量表   \n",
       "\n",
       "                     英文表次  \n",
       "None                       \n",
       "161   Cash Flow Statement  "
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#折舊\n",
    "depreciation[depreciation['中文表次'].str.contains('現金流量')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "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 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>分類ID</th>\n",
       "      <th>會計科目</th>\n",
       "      <th>順序</th>\n",
       "      <th>中文全稱</th>\n",
       "      <th>英文全稱</th>\n",
       "      <th>單位</th>\n",
       "      <th>中文表次</th>\n",
       "      <th>英文表次</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>None</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>0010</td>\n",
       "      <td>29</td>\n",
       "      <td>資產總額</td>\n",
       "      <td>Total assets</td>\n",
       "      <td>T</td>\n",
       "      <td>資產負債表</td>\n",
       "      <td>Balance Sheet</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>0020</td>\n",
       "      <td>78</td>\n",
       "      <td>負債及股東權益總額</td>\n",
       "      <td>Total liabilities &amp; equity</td>\n",
       "      <td>T</td>\n",
       "      <td>資產負債表</td>\n",
       "      <td>Balance Sheet</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>0100</td>\n",
       "      <td>13</td>\n",
       "      <td>流動資產</td>\n",
       "      <td>Total current assets</td>\n",
       "      <td>T</td>\n",
       "      <td>資產負債表</td>\n",
       "      <td>Balance Sheet</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>0112</td>\n",
       "      <td>1</td>\n",
       "      <td>現金及約當現金</td>\n",
       "      <td>Total cash and cash equivalents</td>\n",
       "      <td>T</td>\n",
       "      <td>資產負債表</td>\n",
       "      <td>Balance Sheet</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>012H</td>\n",
       "      <td>3</td>\n",
       "      <td>透過其他綜合損益按公允價值衡量之金融資產－流動</td>\n",
       "      <td>Financial assets at fair value through other c...</td>\n",
       "      <td>T</td>\n",
       "      <td>資產負債表</td>\n",
       "      <td>Balance Sheet</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>2400</td>\n",
       "      <td>72</td>\n",
       "      <td>庫藏股票帳面值</td>\n",
       "      <td>Treasury shares</td>\n",
       "      <td>T</td>\n",
       "      <td>資產負債表</td>\n",
       "      <td>Balance Sheet</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>2480</td>\n",
       "      <td>71</td>\n",
       "      <td>其他權益</td>\n",
       "      <td>Total other equity interest</td>\n",
       "      <td>T</td>\n",
       "      <td>資產負債表</td>\n",
       "      <td>Balance Sheet</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>2801</td>\n",
       "      <td>74</td>\n",
       "      <td>共同控制下前手權益</td>\n",
       "      <td>Interests in the former associate or jointly c...</td>\n",
       "      <td>T</td>\n",
       "      <td>資產負債表</td>\n",
       "      <td>Balance Sheet</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>2802</td>\n",
       "      <td>75</td>\n",
       "      <td>合併前非屬共同控制股權</td>\n",
       "      <td>Non-controlling interest in pre-acquisition sh...</td>\n",
       "      <td>T</td>\n",
       "      <td>資產負債表</td>\n",
       "      <td>Balance Sheet</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>AIM1A</td>\n",
       "      <td>2900</td>\n",
       "      <td>76</td>\n",
       "      <td>非控制權益</td>\n",
       "      <td>Non-controlling interests</td>\n",
       "      <td>T</td>\n",
       "      <td>資產負債表</td>\n",
       "      <td>Balance Sheet</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>78 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       分類ID  會計科目  順序                     中文全稱  \\\n",
       "None                                             \n",
       "9     AIM1A  0010  29                     資產總額   \n",
       "10    AIM1A  0020  78                負債及股東權益總額   \n",
       "11    AIM1A  0100  13                     流動資產   \n",
       "12    AIM1A  0112   1                  現金及約當現金   \n",
       "14    AIM1A  012H   3  透過其他綜合損益按公允價值衡量之金融資產－流動   \n",
       "...     ...   ...  ..                      ...   \n",
       "96    AIM1A  2400  72                  庫藏股票帳面值   \n",
       "99    AIM1A  2480  71                     其他權益   \n",
       "100   AIM1A  2801  74                共同控制下前手權益   \n",
       "101   AIM1A  2802  75              合併前非屬共同控制股權   \n",
       "102   AIM1A  2900  76                    非控制權益   \n",
       "\n",
       "                                                   英文全稱 單位   中文表次  \\\n",
       "None                                                                \n",
       "9                                          Total assets  T  資產負債表   \n",
       "10                           Total liabilities & equity  T  資產負債表   \n",
       "11                                 Total current assets  T  資產負債表   \n",
       "12                      Total cash and cash equivalents  T  資產負債表   \n",
       "14    Financial assets at fair value through other c...  T  資產負債表   \n",
       "...                                                 ... ..    ...   \n",
       "96                                      Treasury shares  T  資產負債表   \n",
       "99                          Total other equity interest  T  資產負債表   \n",
       "100   Interests in the former associate or jointly c...  T  資產負債表   \n",
       "101   Non-controlling interest in pre-acquisition sh...  T  資產負債表   \n",
       "102                           Non-controlling interests  T  資產負債表   \n",
       "\n",
       "               英文表次  \n",
       "None                 \n",
       "9     Balance Sheet  \n",
       "10    Balance Sheet  \n",
       "11    Balance Sheet  \n",
       "12    Balance Sheet  \n",
       "14    Balance Sheet  \n",
       "...             ...  \n",
       "96    Balance Sheet  \n",
       "99    Balance Sheet  \n",
       "100   Balance Sheet  \n",
       "101   Balance Sheet  \n",
       "102   Balance Sheet  \n",
       "\n",
       "[78 rows x 8 columns]"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#找出資產負債表所有科目\n",
    "#balance_sheet \n",
    "balance_sheet = accounting[accounting['中文表次'].str.contains('資產負債')]\n",
    "balance_sheet"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['0010',\n",
       " '0020',\n",
       " '0100',\n",
       " '0112',\n",
       " '012H',\n",
       " '012M',\n",
       " '0130',\n",
       " '0160',\n",
       " '0165',\n",
       " '0170',\n",
       " '017Z',\n",
       " '0182',\n",
       " '0197',\n",
       " '01BA',\n",
       " '01BB',\n",
       " '0314',\n",
       " '0315',\n",
       " '032A',\n",
       " '034A',\n",
       " '0350',\n",
       " '0361',\n",
       " '0370',\n",
       " '0391',\n",
       " '0400',\n",
       " '0810',\n",
       " '0813',\n",
       " '0820',\n",
       " '0890',\n",
       " '0960',\n",
       " '0966',\n",
       " '1000',\n",
       " '1100',\n",
       " '1110',\n",
       " '1120',\n",
       " '1128',\n",
       " '112A',\n",
       " '112M',\n",
       " '112N',\n",
       " '1130',\n",
       " '1181',\n",
       " '118E',\n",
       " '1190',\n",
       " '1199',\n",
       " '1220',\n",
       " '1226',\n",
       " '123A',\n",
       " '1411',\n",
       " '1421',\n",
       " '1441',\n",
       " '1446',\n",
       " '1485',\n",
       " '1490',\n",
       " '1510',\n",
       " '1515',\n",
       " '1560',\n",
       " '156P',\n",
       " '1583',\n",
       " '1587',\n",
       " '1588',\n",
       " '1800',\n",
       " '2000',\n",
       " '200E',\n",
       " '2110',\n",
       " '211E',\n",
       " '2120',\n",
       " '2200',\n",
       " '2300',\n",
       " '2302',\n",
       " '2310',\n",
       " '2320',\n",
       " '2330',\n",
       " '2340',\n",
       " '2341',\n",
       " '2400',\n",
       " '2480',\n",
       " '2801',\n",
       " '2802',\n",
       " '2900']"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "BS_list = balance_sheet['會計科目'].tolist()\n",
    "BS_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "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",
       "      <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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>None</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2409</td>\n",
       "      <td>2000-12-01</td>\n",
       "      <td>45033252.0</td>\n",
       "      <td>45033252.0</td>\n",
       "      <td>8177473.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1215.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2409</td>\n",
       "      <td>2001-12-01</td>\n",
       "      <td>103400395.0</td>\n",
       "      <td>103400395.0</td>\n",
       "      <td>30515701.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8902.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2409</td>\n",
       "      <td>2002-12-01</td>\n",
       "      <td>129171402.0</td>\n",
       "      <td>129171402.0</td>\n",
       "      <td>49830012.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-182849.0</td>\n",
       "      <td>27151.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2409</td>\n",
       "      <td>2003-12-01</td>\n",
       "      <td>158070841.0</td>\n",
       "      <td>158070841.0</td>\n",
       "      <td>50682344.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-250981.0</td>\n",
       "      <td>4419.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2409</td>\n",
       "      <td>2004-12-01</td>\n",
       "      <td>230694425.0</td>\n",
       "      <td>230694425.0</td>\n",
       "      <td>59747303.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-250981.0</td>\n",
       "      <td>-201809.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-03-01</td>\n",
       "      <td>47262792.0</td>\n",
       "      <td>47262792.0</td>\n",
       "      <td>18418025.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1201239.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24188.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-06-01</td>\n",
       "      <td>47106510.0</td>\n",
       "      <td>47106510.0</td>\n",
       "      <td>17905662.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-922282.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12928.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-09-01</td>\n",
       "      <td>49257354.0</td>\n",
       "      <td>49257354.0</td>\n",
       "      <td>23614991.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1279302.0</td>\n",
       "      <td>-770864.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>107072.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-12-01</td>\n",
       "      <td>52023356.0</td>\n",
       "      <td>52023356.0</td>\n",
       "      <td>24151050.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-223193.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>105608.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>6116</td>\n",
       "      <td>2021-03-01</td>\n",
       "      <td>57099499.0</td>\n",
       "      <td>57099499.0</td>\n",
       "      <td>28729119.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-110471.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>105615.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>189 rows × 80 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      公司代碼       財報年月         資產總額    負債及股東權益總額        流動資產  ...    庫藏股票帳面值  \\\n",
       "None                                                         ...              \n",
       "0     2409 2000-12-01   45033252.0   45033252.0   8177473.0  ...        0.0   \n",
       "1     2409 2001-12-01  103400395.0  103400395.0  30515701.0  ...        0.0   \n",
       "2     2409 2002-12-01  129171402.0  129171402.0  49830012.0  ...  -182849.0   \n",
       "3     2409 2003-12-01  158070841.0  158070841.0  50682344.0  ...  -250981.0   \n",
       "4     2409 2004-12-01  230694425.0  230694425.0  59747303.0  ...  -250981.0   \n",
       "...    ...        ...          ...          ...         ...  ...        ...   \n",
       "59    6116 2020-03-01   47262792.0   47262792.0  18418025.0  ...        0.0   \n",
       "60    6116 2020-06-01   47106510.0   47106510.0  17905662.0  ...        0.0   \n",
       "61    6116 2020-09-01   49257354.0   49257354.0  23614991.0  ... -1279302.0   \n",
       "62    6116 2020-12-01   52023356.0   52023356.0  24151050.0  ...        0.0   \n",
       "63    6116 2021-03-01   57099499.0   57099499.0  28729119.0  ...        0.0   \n",
       "\n",
       "           其他權益  共同控制下前手權益  合併前非屬共同控制股權     非控制權益  \n",
       "None                                               \n",
       "0        1215.0        NaN          NaN       0.0  \n",
       "1        8902.0        NaN          NaN       0.0  \n",
       "2       27151.0        NaN          NaN       0.0  \n",
       "3        4419.0        NaN          NaN       0.0  \n",
       "4     -201809.0        NaN          NaN       0.0  \n",
       "...         ...        ...          ...       ...  \n",
       "59   -1201239.0        0.0          0.0   24188.0  \n",
       "60    -922282.0        0.0          0.0   12928.0  \n",
       "61    -770864.0        0.0          0.0  107072.0  \n",
       "62    -223193.0        0.0          0.0  105608.0  \n",
       "63    -110471.0        0.0          0.0  105615.0  \n",
       "\n",
       "[189 rows x 80 columns]"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "finance = pd.DataFrame()\n",
    "for firm in panel:\n",
    "    finance = finance.append(tejapi.get('TWN/AIM1A',\n",
    "                    coid = firm,\n",
    "                    paginate = True,\n",
    "                    opts = {'pivot':True, 'columns': ['coid','mdate'] + BS_list},\n",
    "                    chinese_column_name = True))\n",
    "finance"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "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 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",
       "      <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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2409</td>\n",
       "      <td>2000-12-01</td>\n",
       "      <td>45033252.0</td>\n",
       "      <td>45033252.0</td>\n",
       "      <td>8177473.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1215.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2409</td>\n",
       "      <td>2001-12-01</td>\n",
       "      <td>103400395.0</td>\n",
       "      <td>103400395.0</td>\n",
       "      <td>30515701.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8902.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2409</td>\n",
       "      <td>2002-12-01</td>\n",
       "      <td>129171402.0</td>\n",
       "      <td>129171402.0</td>\n",
       "      <td>49830012.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-182849.0</td>\n",
       "      <td>27151.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2409</td>\n",
       "      <td>2003-12-01</td>\n",
       "      <td>158070841.0</td>\n",
       "      <td>158070841.0</td>\n",
       "      <td>50682344.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-250981.0</td>\n",
       "      <td>4419.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2409</td>\n",
       "      <td>2004-12-01</td>\n",
       "      <td>230694425.0</td>\n",
       "      <td>230694425.0</td>\n",
       "      <td>59747303.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-250981.0</td>\n",
       "      <td>-201809.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-03-01</td>\n",
       "      <td>47262792.0</td>\n",
       "      <td>47262792.0</td>\n",
       "      <td>18418025.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1201239.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24188.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-06-01</td>\n",
       "      <td>47106510.0</td>\n",
       "      <td>47106510.0</td>\n",
       "      <td>17905662.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-922282.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12928.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-09-01</td>\n",
       "      <td>49257354.0</td>\n",
       "      <td>49257354.0</td>\n",
       "      <td>23614991.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1279302.0</td>\n",
       "      <td>-770864.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>107072.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-12-01</td>\n",
       "      <td>52023356.0</td>\n",
       "      <td>52023356.0</td>\n",
       "      <td>24151050.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-223193.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>105608.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>6116</td>\n",
       "      <td>2021-03-01</td>\n",
       "      <td>57099499.0</td>\n",
       "      <td>57099499.0</td>\n",
       "      <td>28729119.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-110471.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>105615.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>189 rows × 80 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     公司代碼       財報年月         資產總額    負債及股東權益總額        流動資產  ...    庫藏股票帳面值  \\\n",
       "0    2409 2000-12-01   45033252.0   45033252.0   8177473.0  ...        0.0   \n",
       "1    2409 2001-12-01  103400395.0  103400395.0  30515701.0  ...        0.0   \n",
       "2    2409 2002-12-01  129171402.0  129171402.0  49830012.0  ...  -182849.0   \n",
       "3    2409 2003-12-01  158070841.0  158070841.0  50682344.0  ...  -250981.0   \n",
       "4    2409 2004-12-01  230694425.0  230694425.0  59747303.0  ...  -250981.0   \n",
       "..    ...        ...          ...          ...         ...  ...        ...   \n",
       "184  6116 2020-03-01   47262792.0   47262792.0  18418025.0  ...        0.0   \n",
       "185  6116 2020-06-01   47106510.0   47106510.0  17905662.0  ...        0.0   \n",
       "186  6116 2020-09-01   49257354.0   49257354.0  23614991.0  ... -1279302.0   \n",
       "187  6116 2020-12-01   52023356.0   52023356.0  24151050.0  ...        0.0   \n",
       "188  6116 2021-03-01   57099499.0   57099499.0  28729119.0  ...        0.0   \n",
       "\n",
       "          其他權益  共同控制下前手權益  合併前非屬共同控制股權     非控制權益  \n",
       "0       1215.0        NaN          NaN       0.0  \n",
       "1       8902.0        NaN          NaN       0.0  \n",
       "2      27151.0        NaN          NaN       0.0  \n",
       "3       4419.0        NaN          NaN       0.0  \n",
       "4    -201809.0        NaN          NaN       0.0  \n",
       "..         ...        ...          ...       ...  \n",
       "184 -1201239.0        0.0          0.0   24188.0  \n",
       "185  -922282.0        0.0          0.0   12928.0  \n",
       "186  -770864.0        0.0          0.0  107072.0  \n",
       "187  -223193.0        0.0          0.0  105608.0  \n",
       "188  -110471.0        0.0          0.0  105615.0  \n",
       "\n",
       "[189 rows x 80 columns]"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "finance = finance.reset_index(drop = True)\n",
    "finance"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {
    "scrolled": true
   },
   "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",
       "      <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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2409</td>\n",
       "      <td>2000-12-01</td>\n",
       "      <td>45033252.0</td>\n",
       "      <td>45033252.0</td>\n",
       "      <td>8177473.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1215.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2409</td>\n",
       "      <td>2001-12-01</td>\n",
       "      <td>103400395.0</td>\n",
       "      <td>103400395.0</td>\n",
       "      <td>30515701.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8902.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2409</td>\n",
       "      <td>2002-12-01</td>\n",
       "      <td>129171402.0</td>\n",
       "      <td>129171402.0</td>\n",
       "      <td>49830012.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-182849.0</td>\n",
       "      <td>27151.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2409</td>\n",
       "      <td>2003-12-01</td>\n",
       "      <td>158070841.0</td>\n",
       "      <td>158070841.0</td>\n",
       "      <td>50682344.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-250981.0</td>\n",
       "      <td>4419.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2409</td>\n",
       "      <td>2004-12-01</td>\n",
       "      <td>230694425.0</td>\n",
       "      <td>230694425.0</td>\n",
       "      <td>59747303.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-250981.0</td>\n",
       "      <td>-201809.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-03-01</td>\n",
       "      <td>47262792.0</td>\n",
       "      <td>47262792.0</td>\n",
       "      <td>18418025.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1201239.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24188.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-06-01</td>\n",
       "      <td>47106510.0</td>\n",
       "      <td>47106510.0</td>\n",
       "      <td>17905662.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-922282.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12928.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-09-01</td>\n",
       "      <td>49257354.0</td>\n",
       "      <td>49257354.0</td>\n",
       "      <td>23614991.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1279302.0</td>\n",
       "      <td>-770864.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>107072.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-12-01</td>\n",
       "      <td>52023356.0</td>\n",
       "      <td>52023356.0</td>\n",
       "      <td>24151050.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-223193.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>105608.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>6116</td>\n",
       "      <td>2021-03-01</td>\n",
       "      <td>57099499.0</td>\n",
       "      <td>57099499.0</td>\n",
       "      <td>28729119.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-110471.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>105615.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>189 rows × 80 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     公司代碼       財報年月         資產總額    負債及股東權益總額        流動資產  ...    庫藏股票帳面值  \\\n",
       "0    2409 2000-12-01   45033252.0   45033252.0   8177473.0  ...        0.0   \n",
       "1    2409 2001-12-01  103400395.0  103400395.0  30515701.0  ...        0.0   \n",
       "2    2409 2002-12-01  129171402.0  129171402.0  49830012.0  ...  -182849.0   \n",
       "3    2409 2003-12-01  158070841.0  158070841.0  50682344.0  ...  -250981.0   \n",
       "4    2409 2004-12-01  230694425.0  230694425.0  59747303.0  ...  -250981.0   \n",
       "..    ...        ...          ...          ...         ...  ...        ...   \n",
       "184  6116 2020-03-01   47262792.0   47262792.0  18418025.0  ...        0.0   \n",
       "185  6116 2020-06-01   47106510.0   47106510.0  17905662.0  ...        0.0   \n",
       "186  6116 2020-09-01   49257354.0   49257354.0  23614991.0  ... -1279302.0   \n",
       "187  6116 2020-12-01   52023356.0   52023356.0  24151050.0  ...        0.0   \n",
       "188  6116 2021-03-01   57099499.0   57099499.0  28729119.0  ...        0.0   \n",
       "\n",
       "          其他權益  共同控制下前手權益  合併前非屬共同控制股權     非控制權益  \n",
       "0       1215.0        NaN          NaN       0.0  \n",
       "1       8902.0        NaN          NaN       0.0  \n",
       "2      27151.0        NaN          NaN       0.0  \n",
       "3       4419.0        NaN          NaN       0.0  \n",
       "4    -201809.0        NaN          NaN       0.0  \n",
       "..         ...        ...          ...       ...  \n",
       "184 -1201239.0        0.0          0.0   24188.0  \n",
       "185  -922282.0        0.0          0.0   12928.0  \n",
       "186  -770864.0        0.0          0.0  107072.0  \n",
       "187  -223193.0        0.0          0.0  105608.0  \n",
       "188  -110471.0        0.0          0.0  105615.0  \n",
       "\n",
       "[189 rows x 80 columns]"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#備份\n",
    "fin = finance.copy()\n",
    "fin"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "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 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",
       "      <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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2409</td>\n",
       "      <td>2000-12-01</td>\n",
       "      <td>45033252.0</td>\n",
       "      <td>45033252.0</td>\n",
       "      <td>8177473.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1215.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2409</td>\n",
       "      <td>2001-12-01</td>\n",
       "      <td>103400395.0</td>\n",
       "      <td>103400395.0</td>\n",
       "      <td>30515701.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8902.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2409</td>\n",
       "      <td>2002-12-01</td>\n",
       "      <td>129171402.0</td>\n",
       "      <td>129171402.0</td>\n",
       "      <td>49830012.0</td>\n",
       "      <td>...</td>\n",
       "      <td>27151.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2409</td>\n",
       "      <td>2003-12-01</td>\n",
       "      <td>158070841.0</td>\n",
       "      <td>158070841.0</td>\n",
       "      <td>50682344.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4419.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2409</td>\n",
       "      <td>2004-12-01</td>\n",
       "      <td>230694425.0</td>\n",
       "      <td>230694425.0</td>\n",
       "      <td>59747303.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-201809.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-03-01</td>\n",
       "      <td>47262792.0</td>\n",
       "      <td>47262792.0</td>\n",
       "      <td>18418025.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1201239.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24188.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-06-01</td>\n",
       "      <td>47106510.0</td>\n",
       "      <td>47106510.0</td>\n",
       "      <td>17905662.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-922282.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12928.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-09-01</td>\n",
       "      <td>49257354.0</td>\n",
       "      <td>49257354.0</td>\n",
       "      <td>23614991.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-770864.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>107072.0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-12-01</td>\n",
       "      <td>52023356.0</td>\n",
       "      <td>52023356.0</td>\n",
       "      <td>24151050.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-223193.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>105608.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>6116</td>\n",
       "      <td>2021-03-01</td>\n",
       "      <td>57099499.0</td>\n",
       "      <td>57099499.0</td>\n",
       "      <td>28729119.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-110471.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>105615.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>189 rows × 81 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     公司代碼       財報年月         資產總額    負債及股東權益總額        流動資產  ...       其他權益  \\\n",
       "0    2409 2000-12-01   45033252.0   45033252.0   8177473.0  ...     1215.0   \n",
       "1    2409 2001-12-01  103400395.0  103400395.0  30515701.0  ...     8902.0   \n",
       "2    2409 2002-12-01  129171402.0  129171402.0  49830012.0  ...    27151.0   \n",
       "3    2409 2003-12-01  158070841.0  158070841.0  50682344.0  ...     4419.0   \n",
       "4    2409 2004-12-01  230694425.0  230694425.0  59747303.0  ...  -201809.0   \n",
       "..    ...        ...          ...          ...         ...  ...        ...   \n",
       "184  6116 2020-03-01   47262792.0   47262792.0  18418025.0  ... -1201239.0   \n",
       "185  6116 2020-06-01   47106510.0   47106510.0  17905662.0  ...  -922282.0   \n",
       "186  6116 2020-09-01   49257354.0   49257354.0  23614991.0  ...  -770864.0   \n",
       "187  6116 2020-12-01   52023356.0   52023356.0  24151050.0  ...  -223193.0   \n",
       "188  6116 2021-03-01   57099499.0   57099499.0  28729119.0  ...  -110471.0   \n",
       "\n",
       "     共同控制下前手權益  合併前非屬共同控制股權     非控制權益   月  \n",
       "0          NaN          NaN       0.0  12  \n",
       "1          NaN          NaN       0.0  12  \n",
       "2          NaN          NaN       0.0  12  \n",
       "3          NaN          NaN       0.0  12  \n",
       "4          NaN          NaN       0.0  12  \n",
       "..         ...          ...       ...  ..  \n",
       "184        0.0          0.0   24188.0   3  \n",
       "185        0.0          0.0   12928.0   6  \n",
       "186        0.0          0.0  107072.0   9  \n",
       "187        0.0          0.0  105608.0  12  \n",
       "188        0.0          0.0  105615.0   3  \n",
       "\n",
       "[189 rows x 81 columns]"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#建立月份欄位S\n",
    "fin['月'] = fin['財報年月'].dt.month\n",
    "fin"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [],
   "source": [
    "pd.set_option('display.max_rows', 10)\n",
    "pd.set_option('display.max_columns', 10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "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 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",
       "      <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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2409</td>\n",
       "      <td>2000-12-01</td>\n",
       "      <td>45033252.0</td>\n",
       "      <td>45033252.0</td>\n",
       "      <td>8177473.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1215.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2409</td>\n",
       "      <td>2001-12-01</td>\n",
       "      <td>103400395.0</td>\n",
       "      <td>103400395.0</td>\n",
       "      <td>30515701.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8902.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2409</td>\n",
       "      <td>2002-12-01</td>\n",
       "      <td>129171402.0</td>\n",
       "      <td>129171402.0</td>\n",
       "      <td>49830012.0</td>\n",
       "      <td>...</td>\n",
       "      <td>27151.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2409</td>\n",
       "      <td>2003-12-01</td>\n",
       "      <td>158070841.0</td>\n",
       "      <td>158070841.0</td>\n",
       "      <td>50682344.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4419.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2409</td>\n",
       "      <td>2004-12-01</td>\n",
       "      <td>230694425.0</td>\n",
       "      <td>230694425.0</td>\n",
       "      <td>59747303.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-201809.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>6116</td>\n",
       "      <td>2016-12-01</td>\n",
       "      <td>44541084.0</td>\n",
       "      <td>44541084.0</td>\n",
       "      <td>17944565.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-147053.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>6116</td>\n",
       "      <td>2017-12-01</td>\n",
       "      <td>49916929.0</td>\n",
       "      <td>49916929.0</td>\n",
       "      <td>23724271.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-72442.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>6116</td>\n",
       "      <td>2018-12-01</td>\n",
       "      <td>48623899.0</td>\n",
       "      <td>48623899.0</td>\n",
       "      <td>19963937.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-736271.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30394.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>6116</td>\n",
       "      <td>2019-12-01</td>\n",
       "      <td>47903368.0</td>\n",
       "      <td>47903368.0</td>\n",
       "      <td>19296712.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-735044.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26054.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-12-01</td>\n",
       "      <td>52023356.0</td>\n",
       "      <td>52023356.0</td>\n",
       "      <td>24151050.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-223193.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>105608.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>60 rows × 81 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     公司代碼       財報年月         資產總額    負債及股東權益總額        流動資產  ...      其他權益  \\\n",
       "0    2409 2000-12-01   45033252.0   45033252.0   8177473.0  ...    1215.0   \n",
       "1    2409 2001-12-01  103400395.0  103400395.0  30515701.0  ...    8902.0   \n",
       "2    2409 2002-12-01  129171402.0  129171402.0  49830012.0  ...   27151.0   \n",
       "3    2409 2003-12-01  158070841.0  158070841.0  50682344.0  ...    4419.0   \n",
       "4    2409 2004-12-01  230694425.0  230694425.0  59747303.0  ... -201809.0   \n",
       "..    ...        ...          ...          ...         ...  ...       ...   \n",
       "171  6116 2016-12-01   44541084.0   44541084.0  17944565.0  ... -147053.0   \n",
       "175  6116 2017-12-01   49916929.0   49916929.0  23724271.0  ...  -72442.0   \n",
       "179  6116 2018-12-01   48623899.0   48623899.0  19963937.0  ... -736271.0   \n",
       "183  6116 2019-12-01   47903368.0   47903368.0  19296712.0  ... -735044.0   \n",
       "187  6116 2020-12-01   52023356.0   52023356.0  24151050.0  ... -223193.0   \n",
       "\n",
       "     共同控制下前手權益  合併前非屬共同控制股權     非控制權益   月  \n",
       "0          NaN          NaN       0.0  12  \n",
       "1          NaN          NaN       0.0  12  \n",
       "2          NaN          NaN       0.0  12  \n",
       "3          NaN          NaN       0.0  12  \n",
       "4          NaN          NaN       0.0  12  \n",
       "..         ...          ...       ...  ..  \n",
       "171        0.0          0.0       0.0  12  \n",
       "175        0.0          0.0       0.0  12  \n",
       "179        0.0          0.0   30394.0  12  \n",
       "183        0.0          0.0   26054.0  12  \n",
       "187        0.0          0.0  105608.0  12  \n",
       "\n",
       "[60 rows x 81 columns]"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fin = fin[fin['月'] == 12]\n",
    "fin"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "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",
       "      <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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2409</td>\n",
       "      <td>2000-12-01</td>\n",
       "      <td>45033252.0</td>\n",
       "      <td>45033252.0</td>\n",
       "      <td>8177473.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1215.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>6116</td>\n",
       "      <td>2000-12-01</td>\n",
       "      <td>41287810.0</td>\n",
       "      <td>41287810.0</td>\n",
       "      <td>6851193.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2409</td>\n",
       "      <td>2001-12-01</td>\n",
       "      <td>103400395.0</td>\n",
       "      <td>103400395.0</td>\n",
       "      <td>30515701.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8902.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>6116</td>\n",
       "      <td>2001-12-01</td>\n",
       "      <td>42806738.0</td>\n",
       "      <td>42806738.0</td>\n",
       "      <td>9549751.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2409</td>\n",
       "      <td>2002-12-01</td>\n",
       "      <td>129171402.0</td>\n",
       "      <td>129171402.0</td>\n",
       "      <td>49830012.0</td>\n",
       "      <td>...</td>\n",
       "      <td>27151.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>6116</td>\n",
       "      <td>2019-12-01</td>\n",
       "      <td>47903368.0</td>\n",
       "      <td>47903368.0</td>\n",
       "      <td>19296712.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-735044.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26054.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>3481</td>\n",
       "      <td>2019-12-01</td>\n",
       "      <td>369764346.0</td>\n",
       "      <td>369764346.0</td>\n",
       "      <td>133118249.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-7325437.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>182325.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>2409</td>\n",
       "      <td>2020-12-01</td>\n",
       "      <td>407270295.0</td>\n",
       "      <td>407270295.0</td>\n",
       "      <td>168317673.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-3270303.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10985674.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>3481</td>\n",
       "      <td>2020-12-01</td>\n",
       "      <td>379559837.0</td>\n",
       "      <td>379559837.0</td>\n",
       "      <td>159162307.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-6059671.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>197386.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-12-01</td>\n",
       "      <td>52023356.0</td>\n",
       "      <td>52023356.0</td>\n",
       "      <td>24151050.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-223193.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>105608.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>60 rows × 81 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     公司代碼       財報年月         資產總額    負債及股東權益總額         流動資產  ...       其他權益  \\\n",
       "0    2409 2000-12-01   45033252.0   45033252.0    8177473.0  ...     1215.0   \n",
       "125  6116 2000-12-01   41287810.0   41287810.0    6851193.0  ...        0.0   \n",
       "1    2409 2001-12-01  103400395.0  103400395.0   30515701.0  ...     8902.0   \n",
       "126  6116 2001-12-01   42806738.0   42806738.0    9549751.0  ...        0.0   \n",
       "2    2409 2002-12-01  129171402.0  129171402.0   49830012.0  ...    27151.0   \n",
       "..    ...        ...          ...          ...          ...  ...        ...   \n",
       "183  6116 2019-12-01   47903368.0   47903368.0   19296712.0  ...  -735044.0   \n",
       "119  3481 2019-12-01  369764346.0  369764346.0  133118249.0  ... -7325437.0   \n",
       "62   2409 2020-12-01  407270295.0  407270295.0  168317673.0  ... -3270303.0   \n",
       "123  3481 2020-12-01  379559837.0  379559837.0  159162307.0  ... -6059671.0   \n",
       "187  6116 2020-12-01   52023356.0   52023356.0   24151050.0  ...  -223193.0   \n",
       "\n",
       "     共同控制下前手權益  合併前非屬共同控制股權       非控制權益   月  \n",
       "0          NaN          NaN         0.0  12  \n",
       "125        NaN          NaN         0.0  12  \n",
       "1          NaN          NaN         0.0  12  \n",
       "126        NaN          NaN         0.0  12  \n",
       "2          NaN          NaN         0.0  12  \n",
       "..         ...          ...         ...  ..  \n",
       "183        0.0          0.0     26054.0  12  \n",
       "119        0.0          0.0    182325.0  12  \n",
       "62         0.0          0.0  10985674.0  12  \n",
       "123        0.0          0.0    197386.0  12  \n",
       "187        0.0          0.0    105608.0  12  \n",
       "\n",
       "[60 rows x 81 columns]"
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#排序1\n",
    "fin = fin.sort_values(by = ['財報年月'], ascending = True)\n",
    "fin"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "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",
       "      <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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2409</td>\n",
       "      <td>2000-12-01</td>\n",
       "      <td>45033252.0</td>\n",
       "      <td>45033252.0</td>\n",
       "      <td>8177473.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1215.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>6116</td>\n",
       "      <td>2000-12-01</td>\n",
       "      <td>41287810.0</td>\n",
       "      <td>41287810.0</td>\n",
       "      <td>6851193.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2409</td>\n",
       "      <td>2001-12-01</td>\n",
       "      <td>103400395.0</td>\n",
       "      <td>103400395.0</td>\n",
       "      <td>30515701.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8902.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>6116</td>\n",
       "      <td>2001-12-01</td>\n",
       "      <td>42806738.0</td>\n",
       "      <td>42806738.0</td>\n",
       "      <td>9549751.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2409</td>\n",
       "      <td>2002-12-01</td>\n",
       "      <td>129171402.0</td>\n",
       "      <td>129171402.0</td>\n",
       "      <td>49830012.0</td>\n",
       "      <td>...</td>\n",
       "      <td>27151.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>3481</td>\n",
       "      <td>2019-12-01</td>\n",
       "      <td>369764346.0</td>\n",
       "      <td>369764346.0</td>\n",
       "      <td>133118249.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-7325437.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>182325.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>6116</td>\n",
       "      <td>2019-12-01</td>\n",
       "      <td>47903368.0</td>\n",
       "      <td>47903368.0</td>\n",
       "      <td>19296712.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-735044.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26054.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>2409</td>\n",
       "      <td>2020-12-01</td>\n",
       "      <td>407270295.0</td>\n",
       "      <td>407270295.0</td>\n",
       "      <td>168317673.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-3270303.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10985674.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>3481</td>\n",
       "      <td>2020-12-01</td>\n",
       "      <td>379559837.0</td>\n",
       "      <td>379559837.0</td>\n",
       "      <td>159162307.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-6059671.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>197386.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-12-01</td>\n",
       "      <td>52023356.0</td>\n",
       "      <td>52023356.0</td>\n",
       "      <td>24151050.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-223193.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>105608.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>60 rows × 81 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     公司代碼       財報年月         資產總額    負債及股東權益總額         流動資產  ...       其他權益  \\\n",
       "0    2409 2000-12-01   45033252.0   45033252.0    8177473.0  ...     1215.0   \n",
       "125  6116 2000-12-01   41287810.0   41287810.0    6851193.0  ...        0.0   \n",
       "1    2409 2001-12-01  103400395.0  103400395.0   30515701.0  ...     8902.0   \n",
       "126  6116 2001-12-01   42806738.0   42806738.0    9549751.0  ...        0.0   \n",
       "2    2409 2002-12-01  129171402.0  129171402.0   49830012.0  ...    27151.0   \n",
       "..    ...        ...          ...          ...          ...  ...        ...   \n",
       "119  3481 2019-12-01  369764346.0  369764346.0  133118249.0  ... -7325437.0   \n",
       "183  6116 2019-12-01   47903368.0   47903368.0   19296712.0  ...  -735044.0   \n",
       "62   2409 2020-12-01  407270295.0  407270295.0  168317673.0  ... -3270303.0   \n",
       "123  3481 2020-12-01  379559837.0  379559837.0  159162307.0  ... -6059671.0   \n",
       "187  6116 2020-12-01   52023356.0   52023356.0   24151050.0  ...  -223193.0   \n",
       "\n",
       "     共同控制下前手權益  合併前非屬共同控制股權       非控制權益   月  \n",
       "0          NaN          NaN         0.0  12  \n",
       "125        NaN          NaN         0.0  12  \n",
       "1          NaN          NaN         0.0  12  \n",
       "126        NaN          NaN         0.0  12  \n",
       "2          NaN          NaN         0.0  12  \n",
       "..         ...          ...         ...  ..  \n",
       "119        0.0          0.0    182325.0  12  \n",
       "183        0.0          0.0     26054.0  12  \n",
       "62         0.0          0.0  10985674.0  12  \n",
       "123        0.0          0.0    197386.0  12  \n",
       "187        0.0          0.0    105608.0  12  \n",
       "\n",
       "[60 rows x 81 columns]"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#排序2\n",
    "fin = fin.sort_values(by = ['財報年月','資產總額'], ascending = [True, False])\n",
    "fin\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "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",
       "      <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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2409</td>\n",
       "      <td>2000-12-01</td>\n",
       "      <td>45033252.0</td>\n",
       "      <td>45033252.0</td>\n",
       "      <td>8177473.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1215.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>6116</td>\n",
       "      <td>2000-12-01</td>\n",
       "      <td>41287810.0</td>\n",
       "      <td>41287810.0</td>\n",
       "      <td>6851193.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2409</td>\n",
       "      <td>2001-12-01</td>\n",
       "      <td>103400395.0</td>\n",
       "      <td>103400395.0</td>\n",
       "      <td>30515701.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8902.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>6116</td>\n",
       "      <td>2001-12-01</td>\n",
       "      <td>42806738.0</td>\n",
       "      <td>42806738.0</td>\n",
       "      <td>9549751.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2409</td>\n",
       "      <td>2002-12-01</td>\n",
       "      <td>129171402.0</td>\n",
       "      <td>129171402.0</td>\n",
       "      <td>49830012.0</td>\n",
       "      <td>...</td>\n",
       "      <td>27151.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>3481</td>\n",
       "      <td>2019-12-01</td>\n",
       "      <td>369764346.0</td>\n",
       "      <td>369764346.0</td>\n",
       "      <td>133118249.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-7325437.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>182325.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>6116</td>\n",
       "      <td>2019-12-01</td>\n",
       "      <td>47903368.0</td>\n",
       "      <td>47903368.0</td>\n",
       "      <td>19296712.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-735044.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26054.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>2409</td>\n",
       "      <td>2020-12-01</td>\n",
       "      <td>407270295.0</td>\n",
       "      <td>407270295.0</td>\n",
       "      <td>168317673.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-3270303.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10985674.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>3481</td>\n",
       "      <td>2020-12-01</td>\n",
       "      <td>379559837.0</td>\n",
       "      <td>379559837.0</td>\n",
       "      <td>159162307.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-6059671.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>197386.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>6116</td>\n",
       "      <td>2020-12-01</td>\n",
       "      <td>52023356.0</td>\n",
       "      <td>52023356.0</td>\n",
       "      <td>24151050.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-223193.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>105608.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>60 rows × 81 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    公司代碼       財報年月         資產總額    負債及股東權益總額         流動資產  ...       其他權益  \\\n",
       "0   2409 2000-12-01   45033252.0   45033252.0    8177473.0  ...     1215.0   \n",
       "1   6116 2000-12-01   41287810.0   41287810.0    6851193.0  ...        0.0   \n",
       "2   2409 2001-12-01  103400395.0  103400395.0   30515701.0  ...     8902.0   \n",
       "3   6116 2001-12-01   42806738.0   42806738.0    9549751.0  ...        0.0   \n",
       "4   2409 2002-12-01  129171402.0  129171402.0   49830012.0  ...    27151.0   \n",
       "..   ...        ...          ...          ...          ...  ...        ...   \n",
       "55  3481 2019-12-01  369764346.0  369764346.0  133118249.0  ... -7325437.0   \n",
       "56  6116 2019-12-01   47903368.0   47903368.0   19296712.0  ...  -735044.0   \n",
       "57  2409 2020-12-01  407270295.0  407270295.0  168317673.0  ... -3270303.0   \n",
       "58  3481 2020-12-01  379559837.0  379559837.0  159162307.0  ... -6059671.0   \n",
       "59  6116 2020-12-01   52023356.0   52023356.0   24151050.0  ...  -223193.0   \n",
       "\n",
       "    共同控制下前手權益  合併前非屬共同控制股權       非控制權益   月  \n",
       "0         NaN          NaN         0.0  12  \n",
       "1         NaN          NaN         0.0  12  \n",
       "2         NaN          NaN         0.0  12  \n",
       "3         NaN          NaN         0.0  12  \n",
       "4         NaN          NaN         0.0  12  \n",
       "..        ...          ...         ...  ..  \n",
       "55        0.0          0.0    182325.0  12  \n",
       "56        0.0          0.0     26054.0  12  \n",
       "57        0.0          0.0  10985674.0  12  \n",
       "58        0.0          0.0    197386.0  12  \n",
       "59        0.0          0.0    105608.0  12  \n",
       "\n",
       "[60 rows x 81 columns]"
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fin = fin.reset_index(drop=True)\n",
    "fin"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}