从零开始卷量化(26).ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 277,
   "id": "f215b0ce",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-10T04:46:59.253187Z",
     "start_time": "2022-04-10T04:46:59.133164Z"
    }
   },
   "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>ts_code</th>\n",
       "      <th>ann_date</th>\n",
       "      <th>f_ann_date</th>\n",
       "      <th>end_date</th>\n",
       "      <th>report_type</th>\n",
       "      <th>comp_type</th>\n",
       "      <th>end_type</th>\n",
       "      <th>total_share</th>\n",
       "      <th>cap_rese</th>\n",
       "      <th>undistr_porfit</th>\n",
       "      <th>surplus_rese</th>\n",
       "      <th>special_rese</th>\n",
       "      <th>money_cap</th>\n",
       "      <th>trad_asset</th>\n",
       "      <th>notes_receiv</th>\n",
       "      <th>accounts_receiv</th>\n",
       "      <th>oth_receiv</th>\n",
       "      <th>prepayment</th>\n",
       "      <th>div_receiv</th>\n",
       "      <th>int_receiv</th>\n",
       "      <th>inventories</th>\n",
       "      <th>amor_exp</th>\n",
       "      <th>nca_within_1y</th>\n",
       "      <th>sett_rsrv</th>\n",
       "      <th>loanto_oth_bank_fi</th>\n",
       "      <th>premium_receiv</th>\n",
       "      <th>reinsur_receiv</th>\n",
       "      <th>reinsur_res_receiv</th>\n",
       "      <th>pur_resale_fa</th>\n",
       "      <th>oth_cur_assets</th>\n",
       "      <th>total_cur_assets</th>\n",
       "      <th>fa_avail_for_sale</th>\n",
       "      <th>htm_invest</th>\n",
       "      <th>lt_eqt_invest</th>\n",
       "      <th>invest_real_estate</th>\n",
       "      <th>time_deposits</th>\n",
       "      <th>oth_assets</th>\n",
       "      <th>lt_rec</th>\n",
       "      <th>fix_assets</th>\n",
       "      <th>cip</th>\n",
       "      <th>const_materials</th>\n",
       "      <th>fixed_assets_disp</th>\n",
       "      <th>produc_bio_assets</th>\n",
       "      <th>oil_and_gas_assets</th>\n",
       "      <th>intan_assets</th>\n",
       "      <th>r_and_d</th>\n",
       "      <th>goodwill</th>\n",
       "      <th>lt_amor_exp</th>\n",
       "      <th>defer_tax_assets</th>\n",
       "      <th>decr_in_disbur</th>\n",
       "      <th>oth_nca</th>\n",
       "      <th>total_nca</th>\n",
       "      <th>cash_reser_cb</th>\n",
       "      <th>depos_in_oth_bfi</th>\n",
       "      <th>prec_metals</th>\n",
       "      <th>deriv_assets</th>\n",
       "      <th>rr_reins_une_prem</th>\n",
       "      <th>rr_reins_outstd_cla</th>\n",
       "      <th>rr_reins_lins_liab</th>\n",
       "      <th>rr_reins_lthins_liab</th>\n",
       "      <th>refund_depos</th>\n",
       "      <th>ph_pledge_loans</th>\n",
       "      <th>refund_cap_depos</th>\n",
       "      <th>indep_acct_assets</th>\n",
       "      <th>client_depos</th>\n",
       "      <th>client_prov</th>\n",
       "      <th>transac_seat_fee</th>\n",
       "      <th>invest_as_receiv</th>\n",
       "      <th>total_assets</th>\n",
       "      <th>lt_borr</th>\n",
       "      <th>st_borr</th>\n",
       "      <th>cb_borr</th>\n",
       "      <th>depos_ib_deposits</th>\n",
       "      <th>loan_oth_bank</th>\n",
       "      <th>trading_fl</th>\n",
       "      <th>notes_payable</th>\n",
       "      <th>acct_payable</th>\n",
       "      <th>adv_receipts</th>\n",
       "      <th>sold_for_repur_fa</th>\n",
       "      <th>comm_payable</th>\n",
       "      <th>payroll_payable</th>\n",
       "      <th>taxes_payable</th>\n",
       "      <th>int_payable</th>\n",
       "      <th>div_payable</th>\n",
       "      <th>oth_payable</th>\n",
       "      <th>acc_exp</th>\n",
       "      <th>deferred_inc</th>\n",
       "      <th>st_bonds_payable</th>\n",
       "      <th>payable_to_reinsurer</th>\n",
       "      <th>rsrv_insur_cont</th>\n",
       "      <th>acting_trading_sec</th>\n",
       "      <th>acting_uw_sec</th>\n",
       "      <th>non_cur_liab_due_1y</th>\n",
       "      <th>oth_cur_liab</th>\n",
       "      <th>total_cur_liab</th>\n",
       "      <th>bond_payable</th>\n",
       "      <th>lt_payable</th>\n",
       "      <th>specific_payables</th>\n",
       "      <th>estimated_liab</th>\n",
       "      <th>defer_tax_liab</th>\n",
       "      <th>defer_inc_non_cur_liab</th>\n",
       "      <th>oth_ncl</th>\n",
       "      <th>total_ncl</th>\n",
       "      <th>depos_oth_bfi</th>\n",
       "      <th>deriv_liab</th>\n",
       "      <th>depos</th>\n",
       "      <th>agency_bus_liab</th>\n",
       "      <th>oth_liab</th>\n",
       "      <th>prem_receiv_adva</th>\n",
       "      <th>depos_received</th>\n",
       "      <th>ph_invest</th>\n",
       "      <th>reser_une_prem</th>\n",
       "      <th>reser_outstd_claims</th>\n",
       "      <th>reser_lins_liab</th>\n",
       "      <th>reser_lthins_liab</th>\n",
       "      <th>indept_acc_liab</th>\n",
       "      <th>pledge_borr</th>\n",
       "      <th>indem_payable</th>\n",
       "      <th>policy_div_payable</th>\n",
       "      <th>total_liab</th>\n",
       "      <th>treasury_share</th>\n",
       "      <th>ordin_risk_reser</th>\n",
       "      <th>forex_differ</th>\n",
       "      <th>invest_loss_unconf</th>\n",
       "      <th>minority_int</th>\n",
       "      <th>total_hldr_eqy_exc_min_int</th>\n",
       "      <th>total_hldr_eqy_inc_min_int</th>\n",
       "      <th>total_liab_hldr_eqy</th>\n",
       "      <th>lt_payroll_payable</th>\n",
       "      <th>oth_comp_income</th>\n",
       "      <th>oth_eqt_tools</th>\n",
       "      <th>oth_eqt_tools_p_shr</th>\n",
       "      <th>lending_funds</th>\n",
       "      <th>acc_receivable</th>\n",
       "      <th>st_fin_payable</th>\n",
       "      <th>payables</th>\n",
       "      <th>hfs_assets</th>\n",
       "      <th>hfs_sales</th>\n",
       "      <th>cost_fin_assets</th>\n",
       "      <th>fair_value_fin_assets</th>\n",
       "      <th>contract_assets</th>\n",
       "      <th>contract_liab</th>\n",
       "      <th>accounts_receiv_bill</th>\n",
       "      <th>accounts_pay</th>\n",
       "      <th>oth_rcv_total</th>\n",
       "      <th>fix_assets_total</th>\n",
       "      <th>cip_total</th>\n",
       "      <th>oth_pay_total</th>\n",
       "      <th>long_pay_total</th>\n",
       "      <th>debt_invest</th>\n",
       "      <th>oth_debt_invest</th>\n",
       "      <th>update_flag</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>002624.SZ</td>\n",
       "      <td>20190430</td>\n",
       "      <td>20190430</td>\n",
       "      <td>20181231</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1.314800e+09</td>\n",
       "      <td>2.908169e+09</td>\n",
       "      <td>4.437586e+09</td>\n",
       "      <td>1.513168e+08</td>\n",
       "      <td>None</td>\n",
       "      <td>4.228910e+09</td>\n",
       "      <td>None</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.964387e+09</td>\n",
       "      <td>1.144146e+08</td>\n",
       "      <td>789742189.0</td>\n",
       "      <td>None</td>\n",
       "      <td>6503929.72</td>\n",
       "      <td>2.141800e+09</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>1.537520e+09</td>\n",
       "      <td>1.078328e+10</td>\n",
       "      <td>1.893011e+09</td>\n",
       "      <td>None</td>\n",
       "      <td>1.559233e+09</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>3.623354e+08</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>86835458.71</td>\n",
       "      <td>None</td>\n",
       "      <td>932154566.3</td>\n",
       "      <td>45976890.53</td>\n",
       "      <td>2.804328e+08</td>\n",
       "      <td>None</td>\n",
       "      <td>35021457.48</td>\n",
       "      <td>5.195000e+09</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",
       "      <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>1.597828e+10</td>\n",
       "      <td>7.937472e+08</td>\n",
       "      <td>1.270023e+09</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>3.930932e+08</td>\n",
       "      <td>4.094157e+08</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>3.316314e+08</td>\n",
       "      <td>3.318715e+08</td>\n",
       "      <td>2177870.94</td>\n",
       "      <td>175.64</td>\n",
       "      <td>2.522880e+08</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>9.307976e+08</td>\n",
       "      <td>3.921299e+09</td>\n",
       "      <td>None</td>\n",
       "      <td>893288.21</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>22817315.92</td>\n",
       "      <td>13570000.0</td>\n",
       "      <td>1.917049e+09</td>\n",
       "      <td>2.748077e+09</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",
       "      <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>6.669375e+09</td>\n",
       "      <td>4.167612e+08</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>8.697668e+08</td>\n",
       "      <td>8.439136e+09</td>\n",
       "      <td>9.308902e+09</td>\n",
       "      <td>1.597828e+10</td>\n",
       "      <td>None</td>\n",
       "      <td>-27667579.0</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",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1.964387e+09</td>\n",
       "      <td>3.930932e+08</td>\n",
       "      <td>1.209185e+08</td>\n",
       "      <td>3.623354e+08</td>\n",
       "      <td>None</td>\n",
       "      <td>2.544660e+08</td>\n",
       "      <td>893288.21</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     ts_code  ann_date f_ann_date  end_date report_type comp_type end_type  \\\n",
       "0  002624.SZ  20190430   20190430  20181231           1         1        4   \n",
       "\n",
       "    total_share      cap_rese  undistr_porfit  surplus_rese special_rese  \\\n",
       "0  1.314800e+09  2.908169e+09    4.437586e+09  1.513168e+08         None   \n",
       "\n",
       "      money_cap trad_asset  notes_receiv  accounts_receiv    oth_receiv  \\\n",
       "0  4.228910e+09       None           0.0     1.964387e+09  1.144146e+08   \n",
       "\n",
       "    prepayment div_receiv  int_receiv   inventories amor_exp nca_within_1y  \\\n",
       "0  789742189.0       None  6503929.72  2.141800e+09     None          None   \n",
       "\n",
       "  sett_rsrv loanto_oth_bank_fi premium_receiv reinsur_receiv  \\\n",
       "0      None               None           None           None   \n",
       "\n",
       "  reinsur_res_receiv pur_resale_fa  oth_cur_assets  total_cur_assets  \\\n",
       "0               None          None    1.537520e+09      1.078328e+10   \n",
       "\n",
       "   fa_avail_for_sale htm_invest  lt_eqt_invest invest_real_estate  \\\n",
       "0       1.893011e+09       None   1.559233e+09               None   \n",
       "\n",
       "  time_deposits oth_assets lt_rec    fix_assets   cip const_materials  \\\n",
       "0          None       None   None  3.623354e+08  None            None   \n",
       "\n",
       "  fixed_assets_disp produc_bio_assets oil_and_gas_assets  intan_assets  \\\n",
       "0              None              None               None   86835458.71   \n",
       "\n",
       "  r_and_d     goodwill  lt_amor_exp  defer_tax_assets decr_in_disbur  \\\n",
       "0    None  932154566.3  45976890.53      2.804328e+08           None   \n",
       "\n",
       "       oth_nca     total_nca cash_reser_cb depos_in_oth_bfi prec_metals  \\\n",
       "0  35021457.48  5.195000e+09          None             None        None   \n",
       "\n",
       "  deriv_assets rr_reins_une_prem rr_reins_outstd_cla rr_reins_lins_liab  \\\n",
       "0         None              None                None               None   \n",
       "\n",
       "  rr_reins_lthins_liab refund_depos ph_pledge_loans refund_cap_depos  \\\n",
       "0                 None         None            None             None   \n",
       "\n",
       "  indep_acct_assets client_depos client_prov transac_seat_fee  \\\n",
       "0              None         None        None             None   \n",
       "\n",
       "  invest_as_receiv  total_assets       lt_borr       st_borr cb_borr  \\\n",
       "0             None  1.597828e+10  7.937472e+08  1.270023e+09    None   \n",
       "\n",
       "  depos_ib_deposits loan_oth_bank trading_fl notes_payable  acct_payable  \\\n",
       "0              None          None       None          None  3.930932e+08   \n",
       "\n",
       "   adv_receipts sold_for_repur_fa comm_payable  payroll_payable  \\\n",
       "0  4.094157e+08              None         None     3.316314e+08   \n",
       "\n",
       "   taxes_payable  int_payable  div_payable   oth_payable acc_exp deferred_inc  \\\n",
       "0   3.318715e+08   2177870.94       175.64  2.522880e+08    None         None   \n",
       "\n",
       "  st_bonds_payable payable_to_reinsurer rsrv_insur_cont acting_trading_sec  \\\n",
       "0             None                 None            None               None   \n",
       "\n",
       "  acting_uw_sec non_cur_liab_due_1y  oth_cur_liab  total_cur_liab  \\\n",
       "0          None                None  9.307976e+08    3.921299e+09   \n",
       "\n",
       "  bond_payable  lt_payable specific_payables estimated_liab  defer_tax_liab  \\\n",
       "0         None   893288.21              None           None     22817315.92   \n",
       "\n",
       "   defer_inc_non_cur_liab       oth_ncl     total_ncl depos_oth_bfi  \\\n",
       "0              13570000.0  1.917049e+09  2.748077e+09          None   \n",
       "\n",
       "  deriv_liab depos agency_bus_liab oth_liab prem_receiv_adva depos_received  \\\n",
       "0       None  None            None     None             None           None   \n",
       "\n",
       "  ph_invest reser_une_prem reser_outstd_claims reser_lins_liab  \\\n",
       "0      None           None                None            None   \n",
       "\n",
       "  reser_lthins_liab indept_acc_liab pledge_borr indem_payable  \\\n",
       "0              None            None        None          None   \n",
       "\n",
       "  policy_div_payable    total_liab  treasury_share ordin_risk_reser  \\\n",
       "0               None  6.669375e+09    4.167612e+08             None   \n",
       "\n",
       "  forex_differ invest_loss_unconf  minority_int  total_hldr_eqy_exc_min_int  \\\n",
       "0         None               None  8.697668e+08                8.439136e+09   \n",
       "\n",
       "   total_hldr_eqy_inc_min_int  total_liab_hldr_eqy lt_payroll_payable  \\\n",
       "0                9.308902e+09         1.597828e+10               None   \n",
       "\n",
       "   oth_comp_income oth_eqt_tools oth_eqt_tools_p_shr lending_funds  \\\n",
       "0      -27667579.0          None                None          None   \n",
       "\n",
       "  acc_receivable st_fin_payable payables hfs_assets hfs_sales cost_fin_assets  \\\n",
       "0           None           None     None       None      None            None   \n",
       "\n",
       "  fair_value_fin_assets contract_assets contract_liab  accounts_receiv_bill  \\\n",
       "0                  None            None          None          1.964387e+09   \n",
       "\n",
       "   accounts_pay  oth_rcv_total  fix_assets_total cip_total  oth_pay_total  \\\n",
       "0  3.930932e+08   1.209185e+08      3.623354e+08      None   2.544660e+08   \n",
       "\n",
       "   long_pay_total debt_invest oth_debt_invest update_flag  \n",
       "0       893288.21        None            None           0  "
      ]
     },
     "execution_count": 277,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import tushare as ts\n",
    "import pandas as pd\n",
    "pro = ts.pro_api()\n",
    "df = pro.balancesheet(ts_code='002624.sz',period='20181231')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 278,
   "id": "2d8aa5c3",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-10T04:47:00.792880Z",
     "start_time": "2022-04-10T04:47:00.784540Z"
    },
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0  ts_code                            002624.SZ\n",
       "   ann_date                            20190430\n",
       "   f_ann_date                          20190430\n",
       "   end_date                            20181231\n",
       "   report_type                                1\n",
       "   comp_type                                  1\n",
       "   end_type                                   4\n",
       "   total_share                     1314799692.0\n",
       "   cap_rese                       2908169097.34\n",
       "   undistr_porfit                 4437585754.41\n",
       "   surplus_rese                    151316775.25\n",
       "   money_cap                      4228909530.42\n",
       "   notes_receiv                             0.0\n",
       "   accounts_receiv                1964387314.46\n",
       "   oth_receiv                      114414572.83\n",
       "   prepayment                       789742189.0\n",
       "   int_receiv                        6503929.72\n",
       "   inventories                    2141799939.49\n",
       "   oth_cur_assets                 1537519710.67\n",
       "   total_cur_assets              10783277186.59\n",
       "   fa_avail_for_sale              1893010554.88\n",
       "   lt_eqt_invest                  1559233335.11\n",
       "   fix_assets                      362335427.27\n",
       "   intan_assets                     86835458.71\n",
       "   goodwill                         932154566.3\n",
       "   lt_amor_exp                      45976890.53\n",
       "   defer_tax_assets                280432795.13\n",
       "   oth_nca                          35021457.48\n",
       "   total_nca                      5195000485.41\n",
       "   total_assets                   15978277672.0\n",
       "   lt_borr                         793747161.92\n",
       "   st_borr                         1270023200.0\n",
       "   acct_payable                    393093209.69\n",
       "   adv_receipts                    409415742.22\n",
       "   payroll_payable                 331631357.07\n",
       "   taxes_payable                   331871477.67\n",
       "   int_payable                       2177870.94\n",
       "   div_payable                           175.64\n",
       "   oth_payable                     252287953.39\n",
       "   oth_cur_liab                    930797610.77\n",
       "   total_cur_liab                 3921298597.39\n",
       "   lt_payable                         893288.21\n",
       "   defer_tax_liab                   22817315.92\n",
       "   defer_inc_non_cur_liab            13570000.0\n",
       "   oth_ncl                        1917048912.64\n",
       "   total_ncl                      2748076678.69\n",
       "   total_liab                     6669375276.08\n",
       "   treasury_share                  416761246.87\n",
       "   minority_int                    869766845.79\n",
       "   total_hldr_eqy_exc_min_int     8439135550.13\n",
       "   total_hldr_eqy_inc_min_int     9308902395.92\n",
       "   total_liab_hldr_eqy            15978277672.0\n",
       "   oth_comp_income                  -27667579.0\n",
       "   accounts_receiv_bill           1964387314.46\n",
       "   accounts_pay                    393093209.69\n",
       "   oth_rcv_total                   120918502.55\n",
       "   fix_assets_total                362335427.27\n",
       "   oth_pay_total                   254465999.97\n",
       "   long_pay_total                     893288.21\n",
       "   update_flag                                0\n",
       "dtype: object"
      ]
     },
     "execution_count": 278,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df.stack()\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 281,
   "id": "35110c4d",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-10T04:55:19.692246Z",
     "start_time": "2022-04-10T04:55:19.678949Z"
    }
   },
   "outputs": [],
   "source": [
    "balance_kv={\n",
    "    'ts_code':'TS股票代码',\n",
    "    'ann_date':'公告日期',\n",
    "    'f_ann_date':'实际公告日期',\n",
    "    'end_date':'报告期',\n",
    "    'report_type':'报表类型',\n",
    "    'comp_type':'公司类型',\n",
    "    'end_type':'报告期类型',\n",
    "    'total_share':'期末总股本',\n",
    "    'cap_rese':'资本公积金',\n",
    "    'undistr_porfit':'未分配利润',\n",
    "    'surplus_rese':'盈余公积金',\n",
    "    'special_rese':'专项储备',\n",
    "    'money_cap':'货币资金',\n",
    "    'trad_asset':'交易性金融资产',\n",
    "    'notes_receiv':'应收票据',\n",
    "    'accounts_receiv':'应收账款',\n",
    "    'oth_receiv':'其他应收款',\n",
    "    'prepayment':'预付款项',\n",
    "    'div_receiv':'应收股利',\n",
    "    'int_receiv':'应收利息',\n",
    "    'inventories':'存货',\n",
    "    'amor_exp':'长期待摊费用',\n",
    "    'nca_within_1y':'一年内到期的非流动资产',\n",
    "    'sett_rsrv':'结算备付金',\n",
    "    'loanto_oth_bank_fi':'拆出资金',\n",
    "    'premium_receiv':'应收保费',\n",
    "    'reinsur_receiv':'应收分保账款',\n",
    "    'reinsur_res_receiv':'应收分保合同准备金',\n",
    "    'pur_resale_fa':'买入返售金融资产',\n",
    "    'oth_cur_assets':'其他流动资产',\n",
    "    'total_cur_assets':'流动资产合计',\n",
    "    'fa_avail_for_sale':'可供出售金融资产',\n",
    "    'htm_invest':'持有至到期投资',\n",
    "    'lt_eqt_invest':'长期股权投资',\n",
    "    'invest_real_estate':'投资性房地产',\n",
    "    'time_deposits':'定期存款',\n",
    "    'oth_assets':'其他资产',\n",
    "    'lt_rec':'长期应收款',\n",
    "    'fix_assets':'固定资产',\n",
    "    'cip':'在建工程',\n",
    "    'const_materials':'工程物资',\n",
    "    'fixed_assets_disp':'固定资产清理',\n",
    "    'produc_bio_assets':'生产性生物资产',\n",
    "    'oil_and_gas_assets':'油气资产',\n",
    "    'intan_assets':'无形资产',\n",
    "    'r_and_d':'研发支出',\n",
    "    'goodwill':'商誉',\n",
    "    'lt_amor_exp':'长期待摊费用',\n",
    "    'defer_tax_assets':'递延所得税资产',\n",
    "    'decr_in_disbur':'发放贷款及垫款',\n",
    "    'oth_nca':'其他非流动资产',\n",
    "    'total_nca':'非流动资产合计',\n",
    "    'cash_reser_cb':'现金及存放中央银行款项',\n",
    "    'depos_in_oth_bfi':'存放同业和其它金融机构款项',\n",
    "    'prec_metals':'贵金属',\n",
    "    'deriv_assets':'衍生金融资产',\n",
    "    'rr_reins_une_prem':'应收分保未到期责任准备金',\n",
    "    'rr_reins_outstd_cla':'应收分保未决赔款准备金',\n",
    "    'rr_reins_lins_liab':'应收分保寿险责任准备金',\n",
    "    'rr_reins_lthins_liab':'应收分保长期健康险责任准备金',\n",
    "    'refund_depos':'存出保证金',\n",
    "    'ph_pledge_loans':'保户质押贷款',\n",
    "    'refund_cap_depos':'存出资本保证金',\n",
    "    'indep_acct_assets':'独立账户资产',\n",
    "    'client_depos':'其中：客户资金存款',\n",
    "    'client_prov':'其中：客户备付金',\n",
    "    'transac_seat_fee':'其中:交易席位费',\n",
    "    'invest_as_receiv':'应收款项类投资',\n",
    "    'total_assets':'资产总计',\n",
    "    'lt_borr':'长期借款',\n",
    "    'st_borr':'短期借款',\n",
    "    'cb_borr':'向中央银行借款',\n",
    "    'depos_ib_deposits':'吸收存款及同业存放',\n",
    "    'loan_oth_bank':'拆入资金',\n",
    "    'trading_fl':'交易性金融负债',\n",
    "    'notes_payable':'应付票据',\n",
    "    'acct_payable':'应付账款',\n",
    "    'adv_receipts':'预收款项',\n",
    "    'sold_for_repur_fa':'卖出回购金融资产款',\n",
    "    'comm_payable':'应付手续费及佣金',\n",
    "    'payroll_payable':'应付职工薪酬',\n",
    "    'taxes_payable':'应交税费',\n",
    "    'int_payable':'应付利息',\n",
    "    'div_payable':'应付股利',\n",
    "    'oth_payable':'其他应付款',\n",
    "    'acc_exp':'预提费用',\n",
    "    'deferred_inc':'递延收益',\n",
    "    'st_bonds_payable':'应付短期债券',\n",
    "    'payable_to_reinsurer':'应付分保账款',\n",
    "    'rsrv_insur_cont':'保险合同准备金',\n",
    "    'acting_trading_sec':'代理买卖证券款',\n",
    "    'acting_uw_sec':'代理承销证券款',\n",
    "    'non_cur_liab_due_1y':'一年内到期的非流动负债',\n",
    "    'oth_cur_liab':'其他流动负债',\n",
    "    'total_cur_liab':'流动负债合计',\n",
    "    'bond_payable':'应付债券',\n",
    "    'lt_payable':'长期应付款',\n",
    "    'specific_payables':'专项应付款',\n",
    "    'estimated_liab':'预计负债',\n",
    "    'defer_tax_liab':'递延所得税负债',\n",
    "    'defer_inc_non_cur_liab':'递延收益-非流动负债',\n",
    "    'oth_ncl':'其他非流动负债',\n",
    "    'total_ncl':'非流动负债合计',\n",
    "    'depos_oth_bfi':'同业和其它金融机构存放款项',\n",
    "    'deriv_liab':'衍生金融负债',\n",
    "    'depos':'吸收存款',\n",
    "    'agency_bus_liab':'代理业务负债',\n",
    "    'oth_liab':'其他负债',\n",
    "    'prem_receiv_adva':'预收保费',\n",
    "    'depos_received':'存入保证金',\n",
    "    'ph_invest':'保户储金及投资款',\n",
    "    'reser_une_prem':'未到期责任准备金',\n",
    "    'reser_outstd_claims':'未决赔款准备金',\n",
    "    'reser_lins_liab':'寿险责任准备金',\n",
    "    'reser_lthins_liab':'长期健康险责任准备金',\n",
    "    'indept_acc_liab':'独立账户负债',\n",
    "    'pledge_borr':'其中:质押借款',\n",
    "    'indem_payable':'应付赔付款',\n",
    "    'policy_div_payable':'应付保单红利',\n",
    "    'total_liab':'负债合计',\n",
    "    'treasury_share':'减:库存股',\n",
    "    'ordin_risk_reser':'一般风险准备',\n",
    "    'forex_differ':'外币报表折算差额',\n",
    "    'invest_loss_unconf':'未确认的投资损失',\n",
    "    'minority_int':'少数股东权益',\n",
    "    'total_hldr_eqy_exc_min_int':'股东权益合计(不含少数股东权益)',\n",
    "    'total_hldr_eqy_inc_min_int':'股东权益合计(含少数股东权益)',\n",
    "    'total_liab_hldr_eqy':'负债及股东权益总计',\n",
    "    'lt_payroll_payable':'长期应付职工薪酬',\n",
    "    'oth_comp_income':'其他综合收益',\n",
    "    'oth_eqt_tools':'其他权益工具',\n",
    "    'oth_eqt_tools_p_shr':'其他权益工具(优先股)',\n",
    "    'lending_funds':'融出资金',\n",
    "    'acc_receivable':'应收款项',\n",
    "    'st_fin_payable':'应付短期融资款',\n",
    "    'payables':'应付款项',\n",
    "    'hfs_assets':'持有待售的资产',\n",
    "    'hfs_sales':'持有待售的负债',\n",
    "    'cost_fin_assets':'以摊余成本计量的金融资产',\n",
    "    'fair_value_fin_assets':'以公允价值计量且其变动计入其他综合收益的金融资产',\n",
    "    'cip_total':'在建工程(合计)(元)',\n",
    "    'oth_pay_total':'其他应付款(合计)(元)',\n",
    "    'long_pay_total':'长期应付款(合计)(元)',\n",
    "    'debt_invest':'债权投资(元)',\n",
    "    'oth_debt_invest':'其他债权投资(元)',\n",
    "    'oth_eq_invest':'其他权益工具投资(元)',\n",
    "    'oth_illiq_fin_assets':'其他非流动金融资产(元)',\n",
    "    'oth_eq_ppbond':'其他权益工具:永续债(元)',\n",
    "    'receiv_financing':'应收款项融资',\n",
    "    'use_right_assets':'使用权资产',\n",
    "    'lease_liab':'租赁负债',\n",
    "    'contract_assets':'合同资产',\n",
    "    'contract_liab':'合同负债',\n",
    "    'accounts_receiv_bill':'应收票据及应收账款',\n",
    "    'accounts_pay':'应付票据及应付账款',\n",
    "    'oth_rcv_total':'其他应收款(合计)（元）',\n",
    "    'fix_assets_total':'固定资产(合计)(元)',\n",
    "    'update_flag':'更新标识'\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 280,
   "id": "14921948",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-10T04:53:50.421539Z",
     "start_time": "2022-04-10T04:53:50.405275Z"
    }
   },
   "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>key</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ts_code</th>\n",
       "      <td>TS股票代码</td>\n",
       "      <td>002624.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ann_date</th>\n",
       "      <td>公告日期</td>\n",
       "      <td>20190430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>f_ann_date</th>\n",
       "      <td>实际公告日期</td>\n",
       "      <td>20190430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>end_date</th>\n",
       "      <td>报告期</td>\n",
       "      <td>20181231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>report_type</th>\n",
       "      <td>报表类型</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>comp_type</th>\n",
       "      <td>公司类型</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>end_type</th>\n",
       "      <td>报告期类型</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>total_share</th>\n",
       "      <td>期末总股本</td>\n",
       "      <td>1314799692.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cap_rese</th>\n",
       "      <td>资本公积金</td>\n",
       "      <td>2908169097.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>undistr_porfit</th>\n",
       "      <td>未分配利润</td>\n",
       "      <td>4437585754.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>surplus_rese</th>\n",
       "      <td>盈余公积金</td>\n",
       "      <td>151316775.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>money_cap</th>\n",
       "      <td>货币资金</td>\n",
       "      <td>4228909530.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>notes_receiv</th>\n",
       "      <td>应收票据</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>accounts_receiv</th>\n",
       "      <td>应收账款</td>\n",
       "      <td>1964387314.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oth_receiv</th>\n",
       "      <td>其他应收款</td>\n",
       "      <td>114414572.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>prepayment</th>\n",
       "      <td>预付款项</td>\n",
       "      <td>789742189.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>int_receiv</th>\n",
       "      <td>应收利息</td>\n",
       "      <td>6503929.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>inventories</th>\n",
       "      <td>存货</td>\n",
       "      <td>2141799939.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oth_cur_assets</th>\n",
       "      <td>其他流动资产</td>\n",
       "      <td>1537519710.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>total_cur_assets</th>\n",
       "      <td>流动资产合计</td>\n",
       "      <td>10783277186.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fa_avail_for_sale</th>\n",
       "      <td>可供出售金融资产</td>\n",
       "      <td>1893010554.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>lt_eqt_invest</th>\n",
       "      <td>长期股权投资</td>\n",
       "      <td>1559233335.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fix_assets</th>\n",
       "      <td>固定资产</td>\n",
       "      <td>362335427.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>intan_assets</th>\n",
       "      <td>无形资产</td>\n",
       "      <td>86835458.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>goodwill</th>\n",
       "      <td>商誉</td>\n",
       "      <td>932154566.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>lt_amor_exp</th>\n",
       "      <td>长期待摊费用</td>\n",
       "      <td>45976890.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>defer_tax_assets</th>\n",
       "      <td>递延所得税资产</td>\n",
       "      <td>280432795.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oth_nca</th>\n",
       "      <td>其他非流动资产</td>\n",
       "      <td>35021457.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>total_nca</th>\n",
       "      <td>非流动资产合计</td>\n",
       "      <td>5195000485.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>total_assets</th>\n",
       "      <td>资产总计</td>\n",
       "      <td>15978277672.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>lt_borr</th>\n",
       "      <td>长期借款</td>\n",
       "      <td>793747161.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>st_borr</th>\n",
       "      <td>短期借款</td>\n",
       "      <td>1270023200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>acct_payable</th>\n",
       "      <td>应付账款</td>\n",
       "      <td>393093209.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>adv_receipts</th>\n",
       "      <td>预收款项</td>\n",
       "      <td>409415742.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>payroll_payable</th>\n",
       "      <td>应付职工薪酬</td>\n",
       "      <td>331631357.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>taxes_payable</th>\n",
       "      <td>应交税费</td>\n",
       "      <td>331871477.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>int_payable</th>\n",
       "      <td>应付利息</td>\n",
       "      <td>2177870.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>div_payable</th>\n",
       "      <td>应付股利</td>\n",
       "      <td>175.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oth_payable</th>\n",
       "      <td>其他应付款</td>\n",
       "      <td>252287953.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oth_cur_liab</th>\n",
       "      <td>其他流动负债</td>\n",
       "      <td>930797610.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>total_cur_liab</th>\n",
       "      <td>流动负债合计</td>\n",
       "      <td>3921298597.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>lt_payable</th>\n",
       "      <td>长期应付款</td>\n",
       "      <td>893288.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>defer_tax_liab</th>\n",
       "      <td>递延所得税负债</td>\n",
       "      <td>22817315.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>defer_inc_non_cur_liab</th>\n",
       "      <td>递延收益-非流动负债</td>\n",
       "      <td>13570000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oth_ncl</th>\n",
       "      <td>其他非流动负债</td>\n",
       "      <td>1917048912.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>total_ncl</th>\n",
       "      <td>非流动负债合计</td>\n",
       "      <td>2748076678.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>total_liab</th>\n",
       "      <td>负债合计</td>\n",
       "      <td>6669375276.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>treasury_share</th>\n",
       "      <td>减:库存股</td>\n",
       "      <td>416761246.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>minority_int</th>\n",
       "      <td>少数股东权益</td>\n",
       "      <td>869766845.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>total_hldr_eqy_exc_min_int</th>\n",
       "      <td>股东权益合计(不含少数股东权益)</td>\n",
       "      <td>8439135550.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>total_hldr_eqy_inc_min_int</th>\n",
       "      <td>股东权益合计(含少数股东权益)</td>\n",
       "      <td>9308902395.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>total_liab_hldr_eqy</th>\n",
       "      <td>负债及股东权益总计</td>\n",
       "      <td>15978277672.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oth_comp_income</th>\n",
       "      <td>其他综合收益</td>\n",
       "      <td>-27667579.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>accounts_receiv_bill</th>\n",
       "      <td>应收票据及应收账款</td>\n",
       "      <td>1964387314.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>accounts_pay</th>\n",
       "      <td>应付票据及应付账款</td>\n",
       "      <td>393093209.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oth_rcv_total</th>\n",
       "      <td>其他应收款(合计)（元）</td>\n",
       "      <td>120918502.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fix_assets_total</th>\n",
       "      <td>固定资产(合计)(元)</td>\n",
       "      <td>362335427.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oth_pay_total</th>\n",
       "      <td>其他应付款(合计)(元)</td>\n",
       "      <td>254465999.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>long_pay_total</th>\n",
       "      <td>长期应付款(合计)(元)</td>\n",
       "      <td>893288.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>update_flag</th>\n",
       "      <td>更新标识</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         key           value\n",
       "ts_code                               TS股票代码       002624.SZ\n",
       "ann_date                                公告日期        20190430\n",
       "f_ann_date                            实际公告日期        20190430\n",
       "end_date                                 报告期        20181231\n",
       "report_type                             报表类型               1\n",
       "comp_type                               公司类型               1\n",
       "end_type                               报告期类型               4\n",
       "total_share                            期末总股本    1314799692.0\n",
       "cap_rese                               资本公积金   2908169097.34\n",
       "undistr_porfit                         未分配利润   4437585754.41\n",
       "surplus_rese                           盈余公积金    151316775.25\n",
       "money_cap                               货币资金   4228909530.42\n",
       "notes_receiv                            应收票据             0.0\n",
       "accounts_receiv                         应收账款   1964387314.46\n",
       "oth_receiv                             其他应收款    114414572.83\n",
       "prepayment                              预付款项     789742189.0\n",
       "int_receiv                              应收利息      6503929.72\n",
       "inventories                               存货   2141799939.49\n",
       "oth_cur_assets                        其他流动资产   1537519710.67\n",
       "total_cur_assets                      流动资产合计  10783277186.59\n",
       "fa_avail_for_sale                   可供出售金融资产   1893010554.88\n",
       "lt_eqt_invest                         长期股权投资   1559233335.11\n",
       "fix_assets                              固定资产    362335427.27\n",
       "intan_assets                            无形资产     86835458.71\n",
       "goodwill                                  商誉     932154566.3\n",
       "lt_amor_exp                           长期待摊费用     45976890.53\n",
       "defer_tax_assets                     递延所得税资产    280432795.13\n",
       "oth_nca                              其他非流动资产     35021457.48\n",
       "total_nca                            非流动资产合计   5195000485.41\n",
       "total_assets                            资产总计   15978277672.0\n",
       "lt_borr                                 长期借款    793747161.92\n",
       "st_borr                                 短期借款    1270023200.0\n",
       "acct_payable                            应付账款    393093209.69\n",
       "adv_receipts                            预收款项    409415742.22\n",
       "payroll_payable                       应付职工薪酬    331631357.07\n",
       "taxes_payable                           应交税费    331871477.67\n",
       "int_payable                             应付利息      2177870.94\n",
       "div_payable                             应付股利          175.64\n",
       "oth_payable                            其他应付款    252287953.39\n",
       "oth_cur_liab                          其他流动负债    930797610.77\n",
       "total_cur_liab                        流动负债合计   3921298597.39\n",
       "lt_payable                             长期应付款       893288.21\n",
       "defer_tax_liab                       递延所得税负债     22817315.92\n",
       "defer_inc_non_cur_liab            递延收益-非流动负债      13570000.0\n",
       "oth_ncl                              其他非流动负债   1917048912.64\n",
       "total_ncl                            非流动负债合计   2748076678.69\n",
       "total_liab                              负债合计   6669375276.08\n",
       "treasury_share                         减:库存股    416761246.87\n",
       "minority_int                          少数股东权益    869766845.79\n",
       "total_hldr_eqy_exc_min_int  股东权益合计(不含少数股东权益)   8439135550.13\n",
       "total_hldr_eqy_inc_min_int   股东权益合计(含少数股东权益)   9308902395.92\n",
       "total_liab_hldr_eqy                负债及股东权益总计   15978277672.0\n",
       "oth_comp_income                       其他综合收益     -27667579.0\n",
       "accounts_receiv_bill               应收票据及应收账款   1964387314.46\n",
       "accounts_pay                       应付票据及应付账款    393093209.69\n",
       "oth_rcv_total                   其他应收款(合计)（元）    120918502.55\n",
       "fix_assets_total                 固定资产(合计)(元)    362335427.27\n",
       "oth_pay_total                   其他应付款(合计)(元)    254465999.97\n",
       "long_pay_total                  长期应付款(合计)(元)       893288.21\n",
       "update_flag                             更新标识               0"
      ]
     },
     "execution_count": 280,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=pd.DataFrame(df[0])\n",
    "df['v']=df[0]\n",
    "df.columns=[\"key\",\"value\"]\n",
    "df['key']=df.index\n",
    "df['key']=df.apply(lambda x:balance_kv[x.key] if x.key in balance_kv else x.key ,axis = 1)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 269,
   "id": "d46a8953",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-10T04:46:24.103078Z",
     "start_time": "2022-04-10T04:46:24.089392Z"
    }
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 282,
   "id": "93bd6b94",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-10T04:55:53.041407Z",
     "start_time": "2022-04-10T04:55:53.027930Z"
    },
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_ed8df_row10_col0, #T_ed8df_row19_col0, #T_ed8df_row28_col0, #T_ed8df_row40_col0, #T_ed8df_row46_col0, #T_ed8df_row51_col0, #T_ed8df_row53_col0, #T_ed8df_row54_col0, #T_ed8df_row56_col0 {\n",
       "  color: red;\n",
       "  font-weight: 700;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_ed8df\">\n",
       "  <caption><h1>资产负债表</h1></caption>\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th id=\"T_ed8df_level0_col0\" class=\"col_heading level0 col0\" >key</th>\n",
       "      <th id=\"T_ed8df_level0_col1\" class=\"col_heading level0 col1\" >value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row0_col0\" class=\"data row0 col0\" >TS股票代码</td>\n",
       "      <td id=\"T_ed8df_row0_col1\" class=\"data row0 col1\" >002624.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row1_col0\" class=\"data row1 col0\" >公告日期</td>\n",
       "      <td id=\"T_ed8df_row1_col1\" class=\"data row1 col1\" >20190430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row2_col0\" class=\"data row2 col0\" >实际公告日期</td>\n",
       "      <td id=\"T_ed8df_row2_col1\" class=\"data row2 col1\" >20190430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row3_col0\" class=\"data row3 col0\" >报告期</td>\n",
       "      <td id=\"T_ed8df_row3_col1\" class=\"data row3 col1\" >20181231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row4_col0\" class=\"data row4 col0\" >报表类型</td>\n",
       "      <td id=\"T_ed8df_row4_col1\" class=\"data row4 col1\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row5_col0\" class=\"data row5 col0\" >公司类型</td>\n",
       "      <td id=\"T_ed8df_row5_col1\" class=\"data row5 col1\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row6_col0\" class=\"data row6 col0\" >报告期类型</td>\n",
       "      <td id=\"T_ed8df_row6_col1\" class=\"data row6 col1\" >4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row7_col0\" class=\"data row7 col0\" >期末总股本</td>\n",
       "      <td id=\"T_ed8df_row7_col1\" class=\"data row7 col1\" >13.15亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row8_col0\" class=\"data row8 col0\" >资本公积金</td>\n",
       "      <td id=\"T_ed8df_row8_col1\" class=\"data row8 col1\" >29.08亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row9_col0\" class=\"data row9 col0\" >未分配利润</td>\n",
       "      <td id=\"T_ed8df_row9_col1\" class=\"data row9 col1\" >44.38亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row10_col0\" class=\"data row10 col0\" >盈余公积金</td>\n",
       "      <td id=\"T_ed8df_row10_col1\" class=\"data row10 col1\" >1.51亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row11_col0\" class=\"data row11 col0\" >货币资金</td>\n",
       "      <td id=\"T_ed8df_row11_col1\" class=\"data row11 col1\" >42.29亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row12_col0\" class=\"data row12 col0\" >应收票据</td>\n",
       "      <td id=\"T_ed8df_row12_col1\" class=\"data row12 col1\" >0.0亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row13_col0\" class=\"data row13 col0\" >应收账款</td>\n",
       "      <td id=\"T_ed8df_row13_col1\" class=\"data row13 col1\" >19.64亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row14_col0\" class=\"data row14 col0\" >其他应收款</td>\n",
       "      <td id=\"T_ed8df_row14_col1\" class=\"data row14 col1\" >1.14亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row15_col0\" class=\"data row15 col0\" >预付款项</td>\n",
       "      <td id=\"T_ed8df_row15_col1\" class=\"data row15 col1\" >7.9亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row16_col0\" class=\"data row16 col0\" >应收利息</td>\n",
       "      <td id=\"T_ed8df_row16_col1\" class=\"data row16 col1\" >0.07亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row17_col0\" class=\"data row17 col0\" >存货</td>\n",
       "      <td id=\"T_ed8df_row17_col1\" class=\"data row17 col1\" >21.42亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row18_col0\" class=\"data row18 col0\" >其他流动资产</td>\n",
       "      <td id=\"T_ed8df_row18_col1\" class=\"data row18 col1\" >15.38亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row19_col0\" class=\"data row19 col0\" >流动资产合计</td>\n",
       "      <td id=\"T_ed8df_row19_col1\" class=\"data row19 col1\" >107.83亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row20_col0\" class=\"data row20 col0\" >可供出售金融资产</td>\n",
       "      <td id=\"T_ed8df_row20_col1\" class=\"data row20 col1\" >18.93亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row21_col0\" class=\"data row21 col0\" >长期股权投资</td>\n",
       "      <td id=\"T_ed8df_row21_col1\" class=\"data row21 col1\" >15.59亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row22_col0\" class=\"data row22 col0\" >固定资产</td>\n",
       "      <td id=\"T_ed8df_row22_col1\" class=\"data row22 col1\" >3.62亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row23_col0\" class=\"data row23 col0\" >无形资产</td>\n",
       "      <td id=\"T_ed8df_row23_col1\" class=\"data row23 col1\" >0.87亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row24_col0\" class=\"data row24 col0\" >商誉</td>\n",
       "      <td id=\"T_ed8df_row24_col1\" class=\"data row24 col1\" >9.32亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row25_col0\" class=\"data row25 col0\" >长期待摊费用</td>\n",
       "      <td id=\"T_ed8df_row25_col1\" class=\"data row25 col1\" >0.46亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row26_col0\" class=\"data row26 col0\" >递延所得税资产</td>\n",
       "      <td id=\"T_ed8df_row26_col1\" class=\"data row26 col1\" >2.8亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row27_col0\" class=\"data row27 col0\" >其他非流动资产</td>\n",
       "      <td id=\"T_ed8df_row27_col1\" class=\"data row27 col1\" >0.35亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row28_col0\" class=\"data row28 col0\" >非流动资产合计</td>\n",
       "      <td id=\"T_ed8df_row28_col1\" class=\"data row28 col1\" >51.95亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row29_col0\" class=\"data row29 col0\" >资产总计</td>\n",
       "      <td id=\"T_ed8df_row29_col1\" class=\"data row29 col1\" >159.78亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row30_col0\" class=\"data row30 col0\" >长期借款</td>\n",
       "      <td id=\"T_ed8df_row30_col1\" class=\"data row30 col1\" >7.94亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row31_col0\" class=\"data row31 col0\" >短期借款</td>\n",
       "      <td id=\"T_ed8df_row31_col1\" class=\"data row31 col1\" >12.7亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row32_col0\" class=\"data row32 col0\" >应付账款</td>\n",
       "      <td id=\"T_ed8df_row32_col1\" class=\"data row32 col1\" >3.93亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row33_col0\" class=\"data row33 col0\" >预收款项</td>\n",
       "      <td id=\"T_ed8df_row33_col1\" class=\"data row33 col1\" >4.09亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row34_col0\" class=\"data row34 col0\" >应付职工薪酬</td>\n",
       "      <td id=\"T_ed8df_row34_col1\" class=\"data row34 col1\" >3.32亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row35_col0\" class=\"data row35 col0\" >应交税费</td>\n",
       "      <td id=\"T_ed8df_row35_col1\" class=\"data row35 col1\" >3.32亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row36_col0\" class=\"data row36 col0\" >应付利息</td>\n",
       "      <td id=\"T_ed8df_row36_col1\" class=\"data row36 col1\" >0.02亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row37_col0\" class=\"data row37 col0\" >应付股利</td>\n",
       "      <td id=\"T_ed8df_row37_col1\" class=\"data row37 col1\" >0.0亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row38_col0\" class=\"data row38 col0\" >其他应付款</td>\n",
       "      <td id=\"T_ed8df_row38_col1\" class=\"data row38 col1\" >2.52亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row39_col0\" class=\"data row39 col0\" >其他流动负债</td>\n",
       "      <td id=\"T_ed8df_row39_col1\" class=\"data row39 col1\" >9.31亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row40_col0\" class=\"data row40 col0\" >流动负债合计</td>\n",
       "      <td id=\"T_ed8df_row40_col1\" class=\"data row40 col1\" >39.21亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row41_col0\" class=\"data row41 col0\" >长期应付款</td>\n",
       "      <td id=\"T_ed8df_row41_col1\" class=\"data row41 col1\" >0.01亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row42_col0\" class=\"data row42 col0\" >递延所得税负债</td>\n",
       "      <td id=\"T_ed8df_row42_col1\" class=\"data row42 col1\" >0.23亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row43_col0\" class=\"data row43 col0\" >递延收益-非流动负债</td>\n",
       "      <td id=\"T_ed8df_row43_col1\" class=\"data row43 col1\" >0.14亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row44_col0\" class=\"data row44 col0\" >其他非流动负债</td>\n",
       "      <td id=\"T_ed8df_row44_col1\" class=\"data row44 col1\" >19.17亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row45_col0\" class=\"data row45 col0\" >非流动负债合计</td>\n",
       "      <td id=\"T_ed8df_row45_col1\" class=\"data row45 col1\" >27.48亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row46_col0\" class=\"data row46 col0\" >负债合计</td>\n",
       "      <td id=\"T_ed8df_row46_col1\" class=\"data row46 col1\" >66.69亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row47_col0\" class=\"data row47 col0\" >减:库存股</td>\n",
       "      <td id=\"T_ed8df_row47_col1\" class=\"data row47 col1\" >4.17亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row48_col0\" class=\"data row48 col0\" >少数股东权益</td>\n",
       "      <td id=\"T_ed8df_row48_col1\" class=\"data row48 col1\" >8.7亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row49_col0\" class=\"data row49 col0\" >股东权益合计(不含少数股东权益)</td>\n",
       "      <td id=\"T_ed8df_row49_col1\" class=\"data row49 col1\" >84.39亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row50_col0\" class=\"data row50 col0\" >股东权益合计(含少数股东权益)</td>\n",
       "      <td id=\"T_ed8df_row50_col1\" class=\"data row50 col1\" >93.09亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row51_col0\" class=\"data row51 col0\" >负债及股东权益总计</td>\n",
       "      <td id=\"T_ed8df_row51_col1\" class=\"data row51 col1\" >159.78亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row52_col0\" class=\"data row52 col0\" >其他综合收益</td>\n",
       "      <td id=\"T_ed8df_row52_col1\" class=\"data row52 col1\" >-0.28亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row53_col0\" class=\"data row53 col0\" >应收票据及应收账款</td>\n",
       "      <td id=\"T_ed8df_row53_col1\" class=\"data row53 col1\" >19.64亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row54_col0\" class=\"data row54 col0\" >应付票据及应付账款</td>\n",
       "      <td id=\"T_ed8df_row54_col1\" class=\"data row54 col1\" >3.93亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row55_col0\" class=\"data row55 col0\" >其他应收款(合计)（元）</td>\n",
       "      <td id=\"T_ed8df_row55_col1\" class=\"data row55 col1\" >1.21亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row56_col0\" class=\"data row56 col0\" >固定资产(合计)(元)</td>\n",
       "      <td id=\"T_ed8df_row56_col1\" class=\"data row56 col1\" >3.62亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row57_col0\" class=\"data row57 col0\" >其他应付款(合计)(元)</td>\n",
       "      <td id=\"T_ed8df_row57_col1\" class=\"data row57 col1\" >2.54亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row58_col0\" class=\"data row58 col0\" >长期应付款(合计)(元)</td>\n",
       "      <td id=\"T_ed8df_row58_col1\" class=\"data row58 col1\" >0.01亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_ed8df_row59_col0\" class=\"data row59 col0\" >更新标识</td>\n",
       "      <td id=\"T_ed8df_row59_col1\" class=\"data row59 col1\" >0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7fd15af0c4f0>"
      ]
     },
     "execution_count": 282,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['value']=df.apply(lambda x:str(round(int(x.value)/100000000,2))+\"亿\" if isinstance(x.value,float) else x.value,axis = 1)\n",
    "\n",
    "\n",
    "def markblod(x):\n",
    "    blod_key=['盈余公积金','流动资产合计','非流动资产合计','流动负债合计','负债合计','负债及股东权益总计','固定资产(合计)(元)','应收票据及应收账款','应付票据及应付账款']     \n",
    "    return 'color : red;font-weight:700' if x in blod_key else ''\n",
    "\n",
    "df=df.style.applymap(markblod).set_caption('<h1>资产负债表</h1>').hide()\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 271,
   "id": "cc18a8b9",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-10T04:46:24.190972Z",
     "start_time": "2022-04-10T04:46:24.180841Z"
    }
   },
   "outputs": [],
   "source": [
    "cashflow_kv={  \n",
    "    'ts_code':'TS股票代码',\n",
    "    'ann_date':'公告日期',\n",
    "    'f_ann_date':'实际公告日期',\n",
    "    'end_date':'报告期',\n",
    "    'comp_type':'公司类型(1一般工商业2银行3保险4证券)',\n",
    "    'report_type':'报表类型',\n",
    "    'end_type':'报告期类型',\n",
    "    'net_profit':'净利润',\n",
    "    'finan_exp':'财务费用',\n",
    "    'c_fr_sale_sg':'销售商品、提供劳务收到的现金',\n",
    "    'recp_tax_rends':'收到的税费返还',\n",
    "    'n_depos_incr_fi':'客户存款和同业存放款项净增加额',\n",
    "    'n_incr_loans_cb':'向中央银行借款净增加额',\n",
    "    'n_inc_borr_oth_fi':'向其他金融机构拆入资金净增加额',\n",
    "    'prem_fr_orig_contr':'收到原保险合同保费取得的现金',\n",
    "    'n_incr_insured_dep':'保户储金净增加额',\n",
    "    'n_reinsur_prem':'收到再保业务现金净额',\n",
    "    'n_incr_disp_tfa':'处置交易性金融资产净增加额',\n",
    "    'ifc_cash_incr':'收取利息和手续费净增加额',\n",
    "    'n_incr_disp_faas':'处置可供出售金融资产净增加额',\n",
    "    'n_incr_loans_oth_bank':'拆入资金净增加额',\n",
    "    'n_cap_incr_repur':'回购业务资金净增加额',\n",
    "    'c_fr_oth_operate_a':'收到其他与经营活动有关的现金',\n",
    "    'c_inf_fr_operate_a':'经营活动现金流入小计',\n",
    "    'c_paid_goods_s':'购买商品、接受劳务支付的现金',\n",
    "    'c_paid_to_for_empl':'支付给职工以及为职工支付的现金',\n",
    "    'c_paid_for_taxes':'支付的各项税费',\n",
    "    'n_incr_clt_loan_adv':'客户贷款及垫款净增加额',\n",
    "    'n_incr_dep_cbob':'存放央行和同业款项净增加额',\n",
    "    'c_pay_claims_orig_inco':'支付原保险合同赔付款项的现金',\n",
    "    'pay_handling_chrg':'支付手续费的现金',\n",
    "    'pay_comm_insur_plcy':'支付保单红利的现金',\n",
    "    'oth_cash_pay_oper_act':'支付其他与经营活动有关的现金',\n",
    "    'st_cash_out_act':'经营活动现金流出小计',\n",
    "    'n_cashflow_act':'经营活动产生的现金流量净额',\n",
    "    'oth_recp_ral_inv_act':'收到其他与投资活动有关的现金',\n",
    "    'c_disp_withdrwl_invest':'收回投资收到的现金',\n",
    "    'c_recp_return_invest':'取得投资收益收到的现金',\n",
    "    'n_recp_disp_fiolta':'处置固定资产、无形资产和其他长期资产收回的现金净额',\n",
    "    'n_recp_disp_sobu':'处置子公司及其他营业单位收到的现金净额',\n",
    "    'stot_inflows_inv_act':'投资活动现金流入小计',\n",
    "    'c_pay_acq_const_fiolta':'购建固定资产、无形资产和其他长期资产支付的现金',\n",
    "    'c_paid_invest':'投资支付的现金',\n",
    "    'n_disp_subs_oth_biz':'取得子公司及其他营业单位支付的现金净额',\n",
    "    'oth_pay_ral_inv_act':'支付其他与投资活动有关的现金',\n",
    "    'n_incr_pledge_loan':'质押贷款净增加额',\n",
    "    'stot_out_inv_act':'投资活动现金流出小计',\n",
    "    'n_cashflow_inv_act':'投资活动产生的现金流量净额',\n",
    "    'c_recp_borrow':'取得借款收到的现金',\n",
    "    'proc_issue_bonds':'发行债券收到的现金',\n",
    "    'oth_cash_recp_ral_fnc_act':'收到其他与筹资活动有关的现金',\n",
    "    'stot_cash_in_fnc_act':'筹资活动现金流入小计',\n",
    "    'free_cashflow':'企业自由现金流量',\n",
    "    'c_prepay_amt_borr':'偿还债务支付的现金',\n",
    "    'c_pay_dist_dpcp_int_exp':'分配股利、利润或偿付利息支付的现金',\n",
    "    'incl_dvd_profit_paid_sc_ms':'其中:子公司支付给少数股东的股利、利润',\n",
    "    'oth_cashpay_ral_fnc_act':'支付其他与筹资活动有关的现金',\n",
    "    'stot_cashout_fnc_act':'筹资活动现金流出小计',\n",
    "    'n_cash_flows_fnc_act':'筹资活动产生的现金流量净额',\n",
    "    'eff_fx_flu_cash':'汇率变动对现金的影响',\n",
    "    'n_incr_cash_cash_equ':'现金及现金等价物净增加额',\n",
    "    'c_cash_equ_beg_period':'期初现金及现金等价物余额',\n",
    "    'c_cash_equ_end_period':'期末现金及现金等价物余额',\n",
    "    'c_recp_cap_contrib':'吸收投资收到的现金',\n",
    "    'incl_cash_rec_saims':'其中:子公司吸收少数股东投资收到的现金',\n",
    "    'uncon_invest_loss':'未确认投资损失',\n",
    "    'prov_depr_assets':'加:资产减值准备',\n",
    "    'depr_fa_coga_dpba':'固定资产折旧、油气资产折耗、生产性生物资产折旧',\n",
    "    'amort_intang_assets':'无形资产摊销',\n",
    "    'lt_amort_deferred_exp':'长期待摊费用摊销',\n",
    "    'decr_deferred_exp':'待摊费用减少',\n",
    "    'incr_acc_exp':'预提费用增加',\n",
    "    'loss_disp_fiolta':'处置固定、无形资产和其他长期资产的损失',\n",
    "    'loss_scr_fa':'固定资产报废损失',\n",
    "    'loss_fv_chg':'公允价值变动损失',\n",
    "    'invest_loss':'投资损失',\n",
    "    'decr_def_inc_tax_assets':'递延所得税资产减少',\n",
    "    'incr_def_inc_tax_liab':'递延所得税负债增加',\n",
    "    'decr_inventories':'存货的减少',\n",
    "    'decr_oper_payable':'经营性应收项目的减少',\n",
    "    'incr_oper_payable':'经营性应付项目的增加',\n",
    "    'others':'其他',\n",
    "    'im_net_cashflow_oper_act':'经营活动产生的现金流量净额(间接法)',\n",
    "    'conv_debt_into_cap':'债务转为资本',\n",
    "    'conv_copbonds_due_within_1y':'一年内到期的可转换公司债券',\n",
    "    'fa_fnc_leases':'融资租入固定资产',\n",
    "    'im_n_incr_cash_equ':'现金及现金等价物净增加额(间接法)',\n",
    "    'net_dism_capital_add':'拆出资金净增加额',\n",
    "    'net_cash_rece_sec':'代理买卖证券收到的现金净额(元)',\n",
    "    'credit_impa_loss':'信用减值损失',\n",
    "    'use_right_asset_dep':'使用权资产折旧',\n",
    "    'oth_loss_asset':'其他资产减值损失',\n",
    "    'end_bal_cash':'现金的期末余额',\n",
    "    'beg_bal_cash':'减:现金的期初余额',\n",
    "    'end_bal_cash_equ':'加:现金等价物的期末余额',\n",
    "    'beg_bal_cash_equ':'减:现金等价物的期初余额',\n",
    "    'update_flag':'更新标志(1最新）'\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 272,
   "id": "ceb4318f",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-10T04:46:24.215960Z",
     "start_time": "2022-04-10T04:46:24.192552Z"
    }
   },
   "outputs": [],
   "source": [
    "income_kv={\n",
    "    'ts_code':'TS代码',\n",
    "    'ann_date':'公告日期',\n",
    "    'f_ann_date':'实际公告日期',\n",
    "    'end_date':'报告期',\n",
    "    'report_type':'报告类型 见底部表',\n",
    "    'comp_type':'公司类型(1一般工商业2银行3保险4证券)',\n",
    "    'end_type':'报告期类型',\n",
    "    'basic_eps':'基本每股收益',\n",
    "    'diluted_eps':'稀释每股收益',\n",
    "    'total_revenue':'营业总收入',\n",
    "    'revenue':'营业收入',\n",
    "    'int_income':'利息收入',\n",
    "    'prem_earned':'已赚保费',\n",
    "    'comm_income':'手续费及佣金收入',\n",
    "    'n_commis_income':'手续费及佣金净收入',\n",
    "    'n_oth_income':'其他经营净收益',\n",
    "    'n_oth_b_income':'加:其他业务净收益',\n",
    "    'prem_income':'保险业务收入',\n",
    "    'out_prem':'减:分出保费',\n",
    "    'une_prem_reser':'提取未到期责任准备金',\n",
    "    'reins_income':'其中:分保费收入',\n",
    "    'n_sec_tb_income':'代理买卖证券业务净收入',\n",
    "    'n_sec_uw_income':'证券承销业务净收入',\n",
    "    'n_asset_mg_income':'受托客户资产管理业务净收入',\n",
    "    'oth_b_income':'其他业务收入',\n",
    "    'fv_value_chg_gain':'加:公允价值变动净收益',\n",
    "    'invest_income':'加:投资净收益',\n",
    "    'ass_invest_income':'其中:对联营企业和合营企业的投资收益',\n",
    "    'forex_gain':'加:汇兑净收益',\n",
    "    'total_cogs':'营业总成本',\n",
    "    'oper_cost':'减:营业成本',\n",
    "    'int_exp':'减:利息支出',\n",
    "    'comm_exp':'减:手续费及佣金支出',\n",
    "    'biz_tax_surchg':'减:营业税金及附加',\n",
    "    'sell_exp':'减:销售费用',\n",
    "    'admin_exp':'减:管理费用',\n",
    "    'fin_exp':'减:财务费用',\n",
    "    'assets_impair_loss':'减:资产减值损失',\n",
    "    'prem_refund':'退保金',\n",
    "    'compens_payout':'赔付总支出',\n",
    "    'reser_insur_liab':'提取保险责任准备金',\n",
    "    'div_payt':'保户红利支出',\n",
    "    'reins_exp':'分保费用',\n",
    "    'oper_exp':'营业支出',\n",
    "    'compens_payout_refu':'减:摊回赔付支出',\n",
    "    'insur_reser_refu':'减:摊回保险责任准备金',\n",
    "    'reins_cost_refund':'减:摊回分保费用',\n",
    "    'other_bus_cost':'其他业务成本',\n",
    "    'operate_profit':'营业利润',\n",
    "    'non_oper_income':'加:营业外收入',\n",
    "    'non_oper_exp':'减:营业外支出',\n",
    "    'nca_disploss':'其中:减:非流动资产处置净损失',\n",
    "    'total_profit':'利润总额',\n",
    "    'income_tax':'所得税费用',\n",
    "    'n_income':'净利润(含少数股东损益)',\n",
    "    'n_income_attr_p':'净利润(不含少数股东损益)',\n",
    "    'minority_gain':'少数股东损益',\n",
    "    'oth_compr_income':'其他综合收益',\n",
    "    't_compr_income':'综合收益总额',\n",
    "    'compr_inc_attr_p':'归属于母公司(或股东)的综合收益总额',\n",
    "    'compr_inc_attr_m_s':'归属于少数股东的综合收益总额',\n",
    "    'ebit':'息税前利润',\n",
    "    'ebitda':'息税折旧摊销前利润',\n",
    "    'insurance_exp':'保险业务支出',\n",
    "    'undist_profit':'年初未分配利润',\n",
    "    'distable_profit':'可分配利润',\n",
    "    'rd_exp':'研发费用',\n",
    "    'fin_exp_int_exp':'财务费用:利息费用',\n",
    "    'fin_exp_int_inc':'财务费用:利息收入',\n",
    "    'transfer_surplus_rese':'盈余公积转入',\n",
    "    'transfer_housing_imprest':'住房周转金转入',\n",
    "    'transfer_oth':'其他转入',\n",
    "    'adj_lossgain':'调整以前年度损益',\n",
    "    'withdra_legal_surplus':'提取法定盈余公积',\n",
    "    'withdra_legal_pubfund':'提取法定公益金',\n",
    "    'withdra_biz_devfund':'提取企业发展基金',\n",
    "    'withdra_rese_fund':'提取储备基金',\n",
    "    'withdra_oth_ersu':'提取任意盈余公积金',\n",
    "    'workers_welfare':'职工奖金福利',\n",
    "    'distr_profit_shrhder':'可供股东分配的利润',\n",
    "    'prfshare_payable_dvd':'应付优先股股利',\n",
    "    'comshare_payable_dvd':'应付普通股股利',\n",
    "    'capit_comstock_div':'转作股本的普通股股利',\n",
    "    'net_after_nr_lp_correct':'扣除非经常性损益后的净利润（更正前）',\n",
    "    'credit_impa_loss':'信用减值损失',\n",
    "    'net_expo_hedging_benefits':'净敞口套期收益',\n",
    "    'oth_impair_loss_assets':'其他资产减值损失',\n",
    "    'total_opcost':'营业总成本（二）',\n",
    "    'amodcost_fin_assets':'以摊余成本计量的金融资产终止确认收益',\n",
    "    'oth_income':'其他收益',\n",
    "    'asset_disp_income':'资产处置收益',\n",
    "    'continued_net_profit':'持续经营净利润',\n",
    "    'end_net_profit':'终止经营净利润',\n",
    "    'update_flag':'更新标识'\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 273,
   "id": "6b85f7bd",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-10T04:46:24.302695Z",
     "start_time": "2022-04-10T04:46:24.217971Z"
    },
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_e7175_row7_col0, #T_e7175_row12_col0, #T_e7175_row17_col0, #T_e7175_row23_col0, #T_e7175_row26_col0, #T_e7175_row30_col0, #T_e7175_row35_col0, #T_e7175_row58_col0 {\n",
       "  color: red;\n",
       "  font-weight: 700;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_e7175\">\n",
       "  <caption><h1>现金流量表</h1></caption>\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th id=\"T_e7175_level0_col0\" class=\"col_heading level0 col0\" >key</th>\n",
       "      <th id=\"T_e7175_level0_col1\" class=\"col_heading level0 col1\" >value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row0_col0\" class=\"data row0 col0\" >TS股票代码</td>\n",
       "      <td id=\"T_e7175_row0_col1\" class=\"data row0 col1\" >002624.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row1_col0\" class=\"data row1 col0\" >公告日期</td>\n",
       "      <td id=\"T_e7175_row1_col1\" class=\"data row1 col1\" >20210427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row2_col0\" class=\"data row2 col0\" >实际公告日期</td>\n",
       "      <td id=\"T_e7175_row2_col1\" class=\"data row2 col1\" >20210427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row3_col0\" class=\"data row3 col0\" >报告期</td>\n",
       "      <td id=\"T_e7175_row3_col1\" class=\"data row3 col1\" >20201231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row4_col0\" class=\"data row4 col0\" >公司类型(1一般工商业2银行3保险4证券)</td>\n",
       "      <td id=\"T_e7175_row4_col1\" class=\"data row4 col1\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row5_col0\" class=\"data row5 col0\" >报表类型</td>\n",
       "      <td id=\"T_e7175_row5_col1\" class=\"data row5 col1\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row6_col0\" class=\"data row6 col0\" >报告期类型</td>\n",
       "      <td id=\"T_e7175_row6_col1\" class=\"data row6 col1\" >4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row7_col0\" class=\"data row7 col0\" >净利润</td>\n",
       "      <td id=\"T_e7175_row7_col1\" class=\"data row7 col1\" >15.04亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row8_col0\" class=\"data row8 col0\" >财务费用</td>\n",
       "      <td id=\"T_e7175_row8_col1\" class=\"data row8 col1\" >1.34亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row9_col0\" class=\"data row9 col0\" >销售商品、提供劳务收到的现金</td>\n",
       "      <td id=\"T_e7175_row9_col1\" class=\"data row9 col1\" >111.66亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row10_col0\" class=\"data row10 col0\" >收到的税费返还</td>\n",
       "      <td id=\"T_e7175_row10_col1\" class=\"data row10 col1\" >0.73亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row11_col0\" class=\"data row11 col0\" >收到其他与经营活动有关的现金</td>\n",
       "      <td id=\"T_e7175_row11_col1\" class=\"data row11 col1\" >3.07亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row12_col0\" class=\"data row12 col0\" >经营活动现金流入小计</td>\n",
       "      <td id=\"T_e7175_row12_col1\" class=\"data row12 col1\" >115.46亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row13_col0\" class=\"data row13 col0\" >购买商品、接受劳务支付的现金</td>\n",
       "      <td id=\"T_e7175_row13_col1\" class=\"data row13 col1\" >47.9亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row14_col0\" class=\"data row14 col0\" >支付给职工以及为职工支付的现金</td>\n",
       "      <td id=\"T_e7175_row14_col1\" class=\"data row14 col1\" >21.28亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row15_col0\" class=\"data row15 col0\" >支付的各项税费</td>\n",
       "      <td id=\"T_e7175_row15_col1\" class=\"data row15 col1\" >4.77亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row16_col0\" class=\"data row16 col0\" >支付其他与经营活动有关的现金</td>\n",
       "      <td id=\"T_e7175_row16_col1\" class=\"data row16 col1\" >4.59亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row17_col0\" class=\"data row17 col0\" >经营活动现金流出小计</td>\n",
       "      <td id=\"T_e7175_row17_col1\" class=\"data row17 col1\" >78.54亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row18_col0\" class=\"data row18 col0\" >经营活动产生的现金流量净额</td>\n",
       "      <td id=\"T_e7175_row18_col1\" class=\"data row18 col1\" >36.93亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row19_col0\" class=\"data row19 col0\" >收回投资收到的现金</td>\n",
       "      <td id=\"T_e7175_row19_col1\" class=\"data row19 col1\" >82.14亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row20_col0\" class=\"data row20 col0\" >取得投资收益收到的现金</td>\n",
       "      <td id=\"T_e7175_row20_col1\" class=\"data row20 col1\" >1.46亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row21_col0\" class=\"data row21 col0\" >处置固定资产、无形资产和其他长期资产收回的现金净额</td>\n",
       "      <td id=\"T_e7175_row21_col1\" class=\"data row21 col1\" >0.01亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row22_col0\" class=\"data row22 col0\" >处置子公司及其他营业单位收到的现金净额</td>\n",
       "      <td id=\"T_e7175_row22_col1\" class=\"data row22 col1\" >0.12亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row23_col0\" class=\"data row23 col0\" >投资活动现金流入小计</td>\n",
       "      <td id=\"T_e7175_row23_col1\" class=\"data row23 col1\" >83.73亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row24_col0\" class=\"data row24 col0\" >购建固定资产、无形资产和其他长期资产支付的现金</td>\n",
       "      <td id=\"T_e7175_row24_col1\" class=\"data row24 col1\" >5.72亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row25_col0\" class=\"data row25 col0\" >投资支付的现金</td>\n",
       "      <td id=\"T_e7175_row25_col1\" class=\"data row25 col1\" >82.55亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row26_col0\" class=\"data row26 col0\" >投资活动现金流出小计</td>\n",
       "      <td id=\"T_e7175_row26_col1\" class=\"data row26 col1\" >88.27亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row27_col0\" class=\"data row27 col0\" >投资活动产生的现金流量净额</td>\n",
       "      <td id=\"T_e7175_row27_col1\" class=\"data row27 col1\" >-4.53亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row28_col0\" class=\"data row28 col0\" >取得借款收到的现金</td>\n",
       "      <td id=\"T_e7175_row28_col1\" class=\"data row28 col1\" >11.21亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row29_col0\" class=\"data row29 col0\" >收到其他与筹资活动有关的现金</td>\n",
       "      <td id=\"T_e7175_row29_col1\" class=\"data row29 col1\" >1.33亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row30_col0\" class=\"data row30 col0\" >筹资活动现金流入小计</td>\n",
       "      <td id=\"T_e7175_row30_col1\" class=\"data row30 col1\" >12.71亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row31_col0\" class=\"data row31 col0\" >企业自由现金流量</td>\n",
       "      <td id=\"T_e7175_row31_col1\" class=\"data row31 col1\" >38.48亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row32_col0\" class=\"data row32 col0\" >偿还债务支付的现金</td>\n",
       "      <td id=\"T_e7175_row32_col1\" class=\"data row32 col1\" >20.52亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row33_col0\" class=\"data row33 col0\" >分配股利、利润或偿付利息支付的现金</td>\n",
       "      <td id=\"T_e7175_row33_col1\" class=\"data row33 col1\" >4.05亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row34_col0\" class=\"data row34 col0\" >支付其他与筹资活动有关的现金</td>\n",
       "      <td id=\"T_e7175_row34_col1\" class=\"data row34 col1\" >16.09亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row35_col0\" class=\"data row35 col0\" >筹资活动现金流出小计</td>\n",
       "      <td id=\"T_e7175_row35_col1\" class=\"data row35 col1\" >40.65亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row36_col0\" class=\"data row36 col0\" >筹资活动产生的现金流量净额</td>\n",
       "      <td id=\"T_e7175_row36_col1\" class=\"data row36 col1\" >-27.94亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row37_col0\" class=\"data row37 col0\" >汇率变动对现金的影响</td>\n",
       "      <td id=\"T_e7175_row37_col1\" class=\"data row37 col1\" >-0.61亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row38_col0\" class=\"data row38 col0\" >现金及现金等价物净增加额</td>\n",
       "      <td id=\"T_e7175_row38_col1\" class=\"data row38 col1\" >3.84亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row39_col0\" class=\"data row39 col0\" >期初现金及现金等价物余额</td>\n",
       "      <td id=\"T_e7175_row39_col1\" class=\"data row39 col1\" >24.68亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row40_col0\" class=\"data row40 col0\" >期末现金及现金等价物余额</td>\n",
       "      <td id=\"T_e7175_row40_col1\" class=\"data row40 col1\" >28.52亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row41_col0\" class=\"data row41 col0\" >吸收投资收到的现金</td>\n",
       "      <td id=\"T_e7175_row41_col1\" class=\"data row41 col1\" >0.17亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row42_col0\" class=\"data row42 col0\" >加:资产减值准备</td>\n",
       "      <td id=\"T_e7175_row42_col1\" class=\"data row42 col1\" >9.69亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row43_col0\" class=\"data row43 col0\" >固定资产折旧、油气资产折耗、生产性生物资产折旧</td>\n",
       "      <td id=\"T_e7175_row43_col1\" class=\"data row43 col1\" >0.69亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row44_col0\" class=\"data row44 col0\" >无形资产摊销</td>\n",
       "      <td id=\"T_e7175_row44_col1\" class=\"data row44 col1\" >1.07亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row45_col0\" class=\"data row45 col0\" >长期待摊费用摊销</td>\n",
       "      <td id=\"T_e7175_row45_col1\" class=\"data row45 col1\" >0.21亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row46_col0\" class=\"data row46 col0\" >处置固定、无形资产和其他长期资产的损失</td>\n",
       "      <td id=\"T_e7175_row46_col1\" class=\"data row46 col1\" >0.01亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row47_col0\" class=\"data row47 col0\" >固定资产报废损失</td>\n",
       "      <td id=\"T_e7175_row47_col1\" class=\"data row47 col1\" >0.01亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row48_col0\" class=\"data row48 col0\" >公允价值变动损失</td>\n",
       "      <td id=\"T_e7175_row48_col1\" class=\"data row48 col1\" >-4.13亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row49_col0\" class=\"data row49 col0\" >投资损失</td>\n",
       "      <td id=\"T_e7175_row49_col1\" class=\"data row49 col1\" >-1.96亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row50_col0\" class=\"data row50 col0\" >递延所得税资产减少</td>\n",
       "      <td id=\"T_e7175_row50_col1\" class=\"data row50 col1\" >-1.34亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row51_col0\" class=\"data row51 col0\" >递延所得税负债增加</td>\n",
       "      <td id=\"T_e7175_row51_col1\" class=\"data row51 col1\" >0.15亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row52_col0\" class=\"data row52 col0\" >存货的减少</td>\n",
       "      <td id=\"T_e7175_row52_col1\" class=\"data row52 col1\" >5.61亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row53_col0\" class=\"data row53 col0\" >经营性应收项目的减少</td>\n",
       "      <td id=\"T_e7175_row53_col1\" class=\"data row53 col1\" >13.03亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row54_col0\" class=\"data row54 col0\" >经营性应付项目的增加</td>\n",
       "      <td id=\"T_e7175_row54_col1\" class=\"data row54 col1\" >-2.4亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row55_col0\" class=\"data row55 col0\" >经营活动产生的现金流量净额(间接法)</td>\n",
       "      <td id=\"T_e7175_row55_col1\" class=\"data row55 col1\" >36.93亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row56_col0\" class=\"data row56 col0\" >现金及现金等价物净增加额(间接法)</td>\n",
       "      <td id=\"T_e7175_row56_col1\" class=\"data row56 col1\" >3.84亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row57_col0\" class=\"data row57 col0\" >信用减值损失</td>\n",
       "      <td id=\"T_e7175_row57_col1\" class=\"data row57 col1\" >-0.13亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row58_col0\" class=\"data row58 col0\" >现金的期末余额</td>\n",
       "      <td id=\"T_e7175_row58_col1\" class=\"data row58 col1\" >28.52亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row59_col0\" class=\"data row59 col0\" >减:现金的期初余额</td>\n",
       "      <td id=\"T_e7175_row59_col1\" class=\"data row59 col1\" >24.68亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e7175_row60_col0\" class=\"data row60 col0\" >更新标志(1最新）</td>\n",
       "      <td id=\"T_e7175_row60_col1\" class=\"data row60 col1\" >1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7fd15acb9eb0>"
      ]
     },
     "execution_count": 273,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import tushare as ts\n",
    "import pandas as pd\n",
    "pro = ts.pro_api()\n",
    "df2 = pro.cashflow(ts_code='002624.sz',period='20201231')\n",
    "df2 = df2.stack()\n",
    "df2=pd.DataFrame(df2[0])\n",
    "df2['v']=df2[0]\n",
    "df2.columns=[\"key\",\"value\"]\n",
    "df2['key']=df2.index\n",
    "# df2['key']=df2.apply(lambda x:cashflow_kv[x.key],axis = 1)\n",
    "df2['key']=df2.apply(lambda x:cashflow_kv[x.key] if x.key in cashflow_kv else x.key ,axis = 1)\n",
    "df2['value']=df2.apply(lambda x:str(round(int(x.value)/100000000,2))+\"亿\" if isinstance(x.value,float) else x.value,axis = 1)\n",
    "\n",
    "\n",
    "def markblod(x):\n",
    "    blod_key=['净利润','经营活动现金流入小计','经营活动现金流出小计','投资活动现金流入小计','筹资活动现金流入小计','投资活动现金流出小计','筹资活动现金流出小计','现金的期末余额']     \n",
    "    return 'color : red;font-weight:700' if x in blod_key else ''\n",
    "\n",
    "df2=df2.style.applymap(markblod).set_caption('<h1>现金流量表</h1>').hide()\n",
    "df2 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 274,
   "id": "a3e4d2e8",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-10T04:46:24.367381Z",
     "start_time": "2022-04-10T04:46:24.304780Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_e3e64_row10_col0, #T_e3e64_row24_col0, #T_e3e64_row35_col0 {\n",
       "  color: red;\n",
       "  font-weight: 700;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_e3e64\">\n",
       "  <caption><h1>利润表</h1></caption>\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th id=\"T_e3e64_level0_col0\" class=\"col_heading level0 col0\" >key</th>\n",
       "      <th id=\"T_e3e64_level0_col1\" class=\"col_heading level0 col1\" >value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row0_col0\" class=\"data row0 col0\" >TS代码</td>\n",
       "      <td id=\"T_e3e64_row0_col1\" class=\"data row0 col1\" >002624.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row1_col0\" class=\"data row1 col0\" >公告日期</td>\n",
       "      <td id=\"T_e3e64_row1_col1\" class=\"data row1 col1\" >20210427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row2_col0\" class=\"data row2 col0\" >实际公告日期</td>\n",
       "      <td id=\"T_e3e64_row2_col1\" class=\"data row2 col1\" >20210427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row3_col0\" class=\"data row3 col0\" >报告期</td>\n",
       "      <td id=\"T_e3e64_row3_col1\" class=\"data row3 col1\" >20201231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row4_col0\" class=\"data row4 col0\" >报告类型 见底部表</td>\n",
       "      <td id=\"T_e3e64_row4_col1\" class=\"data row4 col1\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row5_col0\" class=\"data row5 col0\" >公司类型(1一般工商业2银行3保险4证券)</td>\n",
       "      <td id=\"T_e3e64_row5_col1\" class=\"data row5 col1\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row6_col0\" class=\"data row6 col0\" >报告期类型</td>\n",
       "      <td id=\"T_e3e64_row6_col1\" class=\"data row6 col1\" >4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row7_col0\" class=\"data row7 col0\" >基本每股收益</td>\n",
       "      <td id=\"T_e3e64_row7_col1\" class=\"data row7 col1\" >0.0亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row8_col0\" class=\"data row8 col0\" >稀释每股收益</td>\n",
       "      <td id=\"T_e3e64_row8_col1\" class=\"data row8 col1\" >0.0亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row9_col0\" class=\"data row9 col0\" >营业总收入</td>\n",
       "      <td id=\"T_e3e64_row9_col1\" class=\"data row9 col1\" >102.25亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row10_col0\" class=\"data row10 col0\" >营业收入</td>\n",
       "      <td id=\"T_e3e64_row10_col1\" class=\"data row10 col1\" >102.25亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row11_col0\" class=\"data row11 col0\" >加:公允价值变动净收益</td>\n",
       "      <td id=\"T_e3e64_row11_col1\" class=\"data row11 col1\" >4.13亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row12_col0\" class=\"data row12 col0\" >加:投资净收益</td>\n",
       "      <td id=\"T_e3e64_row12_col1\" class=\"data row12 col1\" >1.96亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row13_col0\" class=\"data row13 col0\" >其中:对联营企业和合营企业的投资收益</td>\n",
       "      <td id=\"T_e3e64_row13_col1\" class=\"data row13 col1\" >0.37亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row14_col0\" class=\"data row14 col0\" >营业总成本</td>\n",
       "      <td id=\"T_e3e64_row14_col1\" class=\"data row14 col1\" >93.35亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row15_col0\" class=\"data row15 col0\" >减:营业成本</td>\n",
       "      <td id=\"T_e3e64_row15_col1\" class=\"data row15 col1\" >40.57亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row16_col0\" class=\"data row16 col0\" >减:营业税金及附加</td>\n",
       "      <td id=\"T_e3e64_row16_col1\" class=\"data row16 col1\" >0.32亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row17_col0\" class=\"data row17 col0\" >减:销售费用</td>\n",
       "      <td id=\"T_e3e64_row17_col1\" class=\"data row17 col1\" >18.31亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row18_col0\" class=\"data row18 col0\" >减:管理费用</td>\n",
       "      <td id=\"T_e3e64_row18_col1\" class=\"data row18 col1\" >7.57亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row19_col0\" class=\"data row19 col0\" >减:财务费用</td>\n",
       "      <td id=\"T_e3e64_row19_col1\" class=\"data row19 col1\" >1.13亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row20_col0\" class=\"data row20 col0\" >减:资产减值损失</td>\n",
       "      <td id=\"T_e3e64_row20_col1\" class=\"data row20 col1\" >-9.69亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row21_col0\" class=\"data row21 col0\" >营业利润</td>\n",
       "      <td id=\"T_e3e64_row21_col1\" class=\"data row21 col1\" >16.28亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row22_col0\" class=\"data row22 col0\" >加:营业外收入</td>\n",
       "      <td id=\"T_e3e64_row22_col1\" class=\"data row22 col1\" >0.4亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row23_col0\" class=\"data row23 col0\" >减:营业外支出</td>\n",
       "      <td id=\"T_e3e64_row23_col1\" class=\"data row23 col1\" >0.12亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row24_col0\" class=\"data row24 col0\" >利润总额</td>\n",
       "      <td id=\"T_e3e64_row24_col1\" class=\"data row24 col1\" >16.57亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row25_col0\" class=\"data row25 col0\" >所得税费用</td>\n",
       "      <td id=\"T_e3e64_row25_col1\" class=\"data row25 col1\" >1.52亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row26_col0\" class=\"data row26 col0\" >净利润(含少数股东损益)</td>\n",
       "      <td id=\"T_e3e64_row26_col1\" class=\"data row26 col1\" >15.04亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row27_col0\" class=\"data row27 col0\" >净利润(不含少数股东损益)</td>\n",
       "      <td id=\"T_e3e64_row27_col1\" class=\"data row27 col1\" >15.49亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row28_col0\" class=\"data row28 col0\" >少数股东损益</td>\n",
       "      <td id=\"T_e3e64_row28_col1\" class=\"data row28 col1\" >-0.44亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row29_col0\" class=\"data row29 col0\" >其他综合收益</td>\n",
       "      <td id=\"T_e3e64_row29_col1\" class=\"data row29 col1\" >-1.78亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row30_col0\" class=\"data row30 col0\" >综合收益总额</td>\n",
       "      <td id=\"T_e3e64_row30_col1\" class=\"data row30 col1\" >13.27亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row31_col0\" class=\"data row31 col0\" >归属于母公司(或股东)的综合收益总额</td>\n",
       "      <td id=\"T_e3e64_row31_col1\" class=\"data row31 col1\" >13.99亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row32_col0\" class=\"data row32 col0\" >归属于少数股东的综合收益总额</td>\n",
       "      <td id=\"T_e3e64_row32_col1\" class=\"data row32 col1\" >-0.73亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row33_col0\" class=\"data row33 col0\" >息税前利润</td>\n",
       "      <td id=\"T_e3e64_row33_col1\" class=\"data row33 col1\" >15.13亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row34_col0\" class=\"data row34 col0\" >息税折旧摊销前利润</td>\n",
       "      <td id=\"T_e3e64_row34_col1\" class=\"data row34 col1\" >17.1亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row35_col0\" class=\"data row35 col0\" >研发费用</td>\n",
       "      <td id=\"T_e3e64_row35_col1\" class=\"data row35 col1\" >15.89亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row36_col0\" class=\"data row36 col0\" >财务费用:利息费用</td>\n",
       "      <td id=\"T_e3e64_row36_col1\" class=\"data row36 col1\" >0.91亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row37_col0\" class=\"data row37 col0\" >财务费用:利息收入</td>\n",
       "      <td id=\"T_e3e64_row37_col1\" class=\"data row37 col1\" >0.25亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row38_col0\" class=\"data row38 col0\" >持续经营净利润</td>\n",
       "      <td id=\"T_e3e64_row38_col1\" class=\"data row38 col1\" >15.04亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_e3e64_row39_col0\" class=\"data row39 col0\" >更新标识</td>\n",
       "      <td id=\"T_e3e64_row39_col1\" class=\"data row39 col1\" >1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7fd15b6ff3a0>"
      ]
     },
     "execution_count": 274,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import tushare as ts\n",
    "import pandas as pd\n",
    "pro = ts.pro_api()\n",
    "df2 = pro.income(ts_code='002624.sz',period='20201231')\n",
    "df2 = df2.stack()\n",
    "df2=pd.DataFrame(df2[0])\n",
    "df2['v']=df2[0]\n",
    "df2.columns=[\"key\",\"value\"]\n",
    "df2['key']=df2.index\n",
    "df2['key']=df2.apply(lambda x:income_kv[x.key] if x.key in income_kv else x.key ,axis = 1)\n",
    "df2['value']=df2.apply(lambda x:str(round(int(x.value)/100000000,2))+\"亿\" if isinstance(x.value,float) else x.value,axis = 1)\n",
    "\n",
    "\n",
    "def markblod(x):\n",
    "    blod_key=['营业收入','利润总额','研发费用']     \n",
    "    return 'color : red;font-weight:700' if x in blod_key else ''\n",
    "\n",
    "df2=df2.style.applymap(markblod).set_caption('<h1>利润表</h1>').hide()\n",
    "df2 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 286,
   "id": "c9665e89",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-11T13:33:17.351104Z",
     "start_time": "2022-04-11T13:33:15.740147Z"
    },
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_6324b_row11_col0, #T_6324b_row19_col0, #T_6324b_row29_col0, #T_6324b_row41_col0, #T_6324b_row48_col0, #T_6324b_row53_col0, #T_6324b_row56_col0, #T_6324b_row57_col0, #T_6324b_row59_col0 {\n",
       "  color: red;\n",
       "  font-weight: 700;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_6324b\">\n",
       "  <caption><h3>完美世界(002624.sz)-资产负债表</h3></caption>\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th id=\"T_6324b_level0_col0\" class=\"col_heading level0 col0\" >key</th>\n",
       "      <th id=\"T_6324b_level0_col1\" class=\"col_heading level0 col1\" >Y2020</th>\n",
       "      <th id=\"T_6324b_level0_col2\" class=\"col_heading level0 col2\" >Y2019</th>\n",
       "      <th id=\"T_6324b_level0_col3\" class=\"col_heading level0 col3\" >Y2018</th>\n",
       "      <th id=\"T_6324b_level0_col4\" class=\"col_heading level0 col4\" >Y2017</th>\n",
       "      <th id=\"T_6324b_level0_col5\" class=\"col_heading level0 col5\" >Y2016</th>\n",
       "      <th id=\"T_6324b_level0_col6\" class=\"col_heading level0 col6\" >Y2015</th>\n",
       "      <th id=\"T_6324b_level0_col7\" class=\"col_heading level0 col7\" >Y2014</th>\n",
       "      <th id=\"T_6324b_level0_col8\" class=\"col_heading level0 col8\" >Y2013</th>\n",
       "      <th id=\"T_6324b_level0_col9\" class=\"col_heading level0 col9\" >Y2012</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row0_col0\" class=\"data row0 col0\" >TS股票代码</td>\n",
       "      <td id=\"T_6324b_row0_col1\" class=\"data row0 col1\" >002624.SZ</td>\n",
       "      <td id=\"T_6324b_row0_col2\" class=\"data row0 col2\" >002624.SZ</td>\n",
       "      <td id=\"T_6324b_row0_col3\" class=\"data row0 col3\" >002624.SZ</td>\n",
       "      <td id=\"T_6324b_row0_col4\" class=\"data row0 col4\" >002624.SZ</td>\n",
       "      <td id=\"T_6324b_row0_col5\" class=\"data row0 col5\" >002624.SZ</td>\n",
       "      <td id=\"T_6324b_row0_col6\" class=\"data row0 col6\" >002624.SZ</td>\n",
       "      <td id=\"T_6324b_row0_col7\" class=\"data row0 col7\" >002624.SZ</td>\n",
       "      <td id=\"T_6324b_row0_col8\" class=\"data row0 col8\" >002624.SZ</td>\n",
       "      <td id=\"T_6324b_row0_col9\" class=\"data row0 col9\" >002624.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row1_col0\" class=\"data row1 col0\" >公告日期</td>\n",
       "      <td id=\"T_6324b_row1_col1\" class=\"data row1 col1\" >20210427</td>\n",
       "      <td id=\"T_6324b_row1_col2\" class=\"data row1 col2\" >20200424</td>\n",
       "      <td id=\"T_6324b_row1_col3\" class=\"data row1 col3\" >20190430</td>\n",
       "      <td id=\"T_6324b_row1_col4\" class=\"data row1 col4\" >20180330</td>\n",
       "      <td id=\"T_6324b_row1_col5\" class=\"data row1 col5\" >20170317</td>\n",
       "      <td id=\"T_6324b_row1_col6\" class=\"data row1 col6\" >20160429</td>\n",
       "      <td id=\"T_6324b_row1_col7\" class=\"data row1 col7\" >20150331</td>\n",
       "      <td id=\"T_6324b_row1_col8\" class=\"data row1 col8\" >20140305</td>\n",
       "      <td id=\"T_6324b_row1_col9\" class=\"data row1 col9\" >20130422</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row2_col0\" class=\"data row2 col0\" >实际公告日期</td>\n",
       "      <td id=\"T_6324b_row2_col1\" class=\"data row2 col1\" >20210427</td>\n",
       "      <td id=\"T_6324b_row2_col2\" class=\"data row2 col2\" >20200424</td>\n",
       "      <td id=\"T_6324b_row2_col3\" class=\"data row2 col3\" >20190430</td>\n",
       "      <td id=\"T_6324b_row2_col4\" class=\"data row2 col4\" >20180330</td>\n",
       "      <td id=\"T_6324b_row2_col5\" class=\"data row2 col5\" >20170317</td>\n",
       "      <td id=\"T_6324b_row2_col6\" class=\"data row2 col6\" >20160429</td>\n",
       "      <td id=\"T_6324b_row2_col7\" class=\"data row2 col7\" >20150331</td>\n",
       "      <td id=\"T_6324b_row2_col8\" class=\"data row2 col8\" >20140305</td>\n",
       "      <td id=\"T_6324b_row2_col9\" class=\"data row2 col9\" >20130422</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row3_col0\" class=\"data row3 col0\" >报告期</td>\n",
       "      <td id=\"T_6324b_row3_col1\" class=\"data row3 col1\" >20201231</td>\n",
       "      <td id=\"T_6324b_row3_col2\" class=\"data row3 col2\" >20191231</td>\n",
       "      <td id=\"T_6324b_row3_col3\" class=\"data row3 col3\" >20181231</td>\n",
       "      <td id=\"T_6324b_row3_col4\" class=\"data row3 col4\" >20171231</td>\n",
       "      <td id=\"T_6324b_row3_col5\" class=\"data row3 col5\" >20161231</td>\n",
       "      <td id=\"T_6324b_row3_col6\" class=\"data row3 col6\" >20151231</td>\n",
       "      <td id=\"T_6324b_row3_col7\" class=\"data row3 col7\" >20141231</td>\n",
       "      <td id=\"T_6324b_row3_col8\" class=\"data row3 col8\" >20131231</td>\n",
       "      <td id=\"T_6324b_row3_col9\" class=\"data row3 col9\" >20121231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row4_col0\" class=\"data row4 col0\" >报表类型</td>\n",
       "      <td id=\"T_6324b_row4_col1\" class=\"data row4 col1\" >1</td>\n",
       "      <td id=\"T_6324b_row4_col2\" class=\"data row4 col2\" >1</td>\n",
       "      <td id=\"T_6324b_row4_col3\" class=\"data row4 col3\" >1</td>\n",
       "      <td id=\"T_6324b_row4_col4\" class=\"data row4 col4\" >1</td>\n",
       "      <td id=\"T_6324b_row4_col5\" class=\"data row4 col5\" >1</td>\n",
       "      <td id=\"T_6324b_row4_col6\" class=\"data row4 col6\" >1</td>\n",
       "      <td id=\"T_6324b_row4_col7\" class=\"data row4 col7\" >1</td>\n",
       "      <td id=\"T_6324b_row4_col8\" class=\"data row4 col8\" >1</td>\n",
       "      <td id=\"T_6324b_row4_col9\" class=\"data row4 col9\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row5_col0\" class=\"data row5 col0\" >公司类型</td>\n",
       "      <td id=\"T_6324b_row5_col1\" class=\"data row5 col1\" >1</td>\n",
       "      <td id=\"T_6324b_row5_col2\" class=\"data row5 col2\" >1</td>\n",
       "      <td id=\"T_6324b_row5_col3\" class=\"data row5 col3\" >1</td>\n",
       "      <td id=\"T_6324b_row5_col4\" class=\"data row5 col4\" >1</td>\n",
       "      <td id=\"T_6324b_row5_col5\" class=\"data row5 col5\" >1</td>\n",
       "      <td id=\"T_6324b_row5_col6\" class=\"data row5 col6\" >1</td>\n",
       "      <td id=\"T_6324b_row5_col7\" class=\"data row5 col7\" >1</td>\n",
       "      <td id=\"T_6324b_row5_col8\" class=\"data row5 col8\" >1</td>\n",
       "      <td id=\"T_6324b_row5_col9\" class=\"data row5 col9\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row6_col0\" class=\"data row6 col0\" >报告期类型</td>\n",
       "      <td id=\"T_6324b_row6_col1\" class=\"data row6 col1\" >4</td>\n",
       "      <td id=\"T_6324b_row6_col2\" class=\"data row6 col2\" >4</td>\n",
       "      <td id=\"T_6324b_row6_col3\" class=\"data row6 col3\" >4</td>\n",
       "      <td id=\"T_6324b_row6_col4\" class=\"data row6 col4\" >4</td>\n",
       "      <td id=\"T_6324b_row6_col5\" class=\"data row6 col5\" >4</td>\n",
       "      <td id=\"T_6324b_row6_col6\" class=\"data row6 col6\" >4</td>\n",
       "      <td id=\"T_6324b_row6_col7\" class=\"data row6 col7\" >4</td>\n",
       "      <td id=\"T_6324b_row6_col8\" class=\"data row6 col8\" >4</td>\n",
       "      <td id=\"T_6324b_row6_col9\" class=\"data row6 col9\" >4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row7_col0\" class=\"data row7 col0\" >期末总股本</td>\n",
       "      <td id=\"T_6324b_row7_col1\" class=\"data row7 col1\" >19.4亿</td>\n",
       "      <td id=\"T_6324b_row7_col2\" class=\"data row7 col2\" >12.93亿</td>\n",
       "      <td id=\"T_6324b_row7_col3\" class=\"data row7 col3\" >13.15亿</td>\n",
       "      <td id=\"T_6324b_row7_col4\" class=\"data row7 col4\" >13.15亿</td>\n",
       "      <td id=\"T_6324b_row7_col5\" class=\"data row7 col5\" >13.86亿</td>\n",
       "      <td id=\"T_6324b_row7_col6\" class=\"data row7 col6\" >5.59亿</td>\n",
       "      <td id=\"T_6324b_row7_col7\" class=\"data row7 col7\" >4.88亿</td>\n",
       "      <td id=\"T_6324b_row7_col8\" class=\"data row7 col8\" >2.0亿</td>\n",
       "      <td id=\"T_6324b_row7_col9\" class=\"data row7 col9\" >2.0亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row8_col0\" class=\"data row8 col0\" >资本公积金</td>\n",
       "      <td id=\"T_6324b_row8_col1\" class=\"data row8 col1\" >19.62亿</td>\n",
       "      <td id=\"T_6324b_row8_col2\" class=\"data row8 col2\" >23.25亿</td>\n",
       "      <td id=\"T_6324b_row8_col3\" class=\"data row8 col3\" >29.08亿</td>\n",
       "      <td id=\"T_6324b_row8_col4\" class=\"data row8 col4\" >35.57亿</td>\n",
       "      <td id=\"T_6324b_row8_col5\" class=\"data row8 col5\" >41.62亿</td>\n",
       "      <td id=\"T_6324b_row8_col6\" class=\"data row8 col6\" >0.23亿</td>\n",
       "      <td id=\"T_6324b_row8_col7\" class=\"data row8 col7\" >0.23亿</td>\n",
       "      <td id=\"T_6324b_row8_col8\" class=\"data row8 col8\" >1.81亿</td>\n",
       "      <td id=\"T_6324b_row8_col9\" class=\"data row8 col9\" >1.81亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row9_col0\" class=\"data row9 col0\" >未分配利润</td>\n",
       "      <td id=\"T_6324b_row9_col1\" class=\"data row9 col1\" >67.82亿</td>\n",
       "      <td id=\"T_6324b_row9_col2\" class=\"data row9 col2\" >56.78亿</td>\n",
       "      <td id=\"T_6324b_row9_col3\" class=\"data row9 col3\" >44.38亿</td>\n",
       "      <td id=\"T_6324b_row9_col4\" class=\"data row9 col4\" >29.79亿</td>\n",
       "      <td id=\"T_6324b_row9_col5\" class=\"data row9 col5\" >16.12亿</td>\n",
       "      <td id=\"T_6324b_row9_col6\" class=\"data row9 col6\" >4.31亿</td>\n",
       "      <td id=\"T_6324b_row9_col7\" class=\"data row9 col7\" >1.67亿</td>\n",
       "      <td id=\"T_6324b_row9_col8\" class=\"data row9 col8\" >1.11亿</td>\n",
       "      <td id=\"T_6324b_row9_col9\" class=\"data row9 col9\" >0.96亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row10_col0\" class=\"data row10 col0\" >盈余公积金</td>\n",
       "      <td id=\"T_6324b_row10_col1\" class=\"data row10 col1\" >2.63亿</td>\n",
       "      <td id=\"T_6324b_row10_col2\" class=\"data row10 col2\" >1.81亿</td>\n",
       "      <td id=\"T_6324b_row10_col3\" class=\"data row10 col3\" >1.51亿</td>\n",
       "      <td id=\"T_6324b_row10_col4\" class=\"data row10 col4\" >1.28亿</td>\n",
       "      <td id=\"T_6324b_row10_col5\" class=\"data row10 col5\" >1.06亿</td>\n",
       "      <td id=\"T_6324b_row10_col6\" class=\"data row10 col6\" >0.12亿</td>\n",
       "      <td id=\"T_6324b_row10_col7\" class=\"data row10 col7\" >0.06亿</td>\n",
       "      <td id=\"T_6324b_row10_col8\" class=\"data row10 col8\" >0.15亿</td>\n",
       "      <td id=\"T_6324b_row10_col9\" class=\"data row10 col9\" >0.13亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row11_col0\" class=\"data row11 col0\" >货币资金</td>\n",
       "      <td id=\"T_6324b_row11_col1\" class=\"data row11 col1\" >29.43亿</td>\n",
       "      <td id=\"T_6324b_row11_col2\" class=\"data row11 col2\" >25.26亿</td>\n",
       "      <td id=\"T_6324b_row11_col3\" class=\"data row11 col3\" >42.29亿</td>\n",
       "      <td id=\"T_6324b_row11_col4\" class=\"data row11 col4\" >32.36亿</td>\n",
       "      <td id=\"T_6324b_row11_col5\" class=\"data row11 col5\" >20.97亿</td>\n",
       "      <td id=\"T_6324b_row11_col6\" class=\"data row11 col6\" >10.98亿</td>\n",
       "      <td id=\"T_6324b_row11_col7\" class=\"data row11 col7\" >2.51亿</td>\n",
       "      <td id=\"T_6324b_row11_col8\" class=\"data row11 col8\" >0.21亿</td>\n",
       "      <td id=\"T_6324b_row11_col9\" class=\"data row11 col9\" >1.02亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row12_col0\" class=\"data row12 col0\" >交易性金融资产</td>\n",
       "      <td id=\"T_6324b_row12_col1\" class=\"data row12 col1\" >17.53亿</td>\n",
       "      <td id=\"T_6324b_row12_col2\" class=\"data row12 col2\" >22.49亿</td>\n",
       "      <td id=\"T_6324b_row12_col3\" class=\"data row12 col3\" >nan</td>\n",
       "      <td id=\"T_6324b_row12_col4\" class=\"data row12 col4\" >nan</td>\n",
       "      <td id=\"T_6324b_row12_col5\" class=\"data row12 col5\" >nan</td>\n",
       "      <td id=\"T_6324b_row12_col6\" class=\"data row12 col6\" >nan</td>\n",
       "      <td id=\"T_6324b_row12_col7\" class=\"data row12 col7\" >nan</td>\n",
       "      <td id=\"T_6324b_row12_col8\" class=\"data row12 col8\" >nan</td>\n",
       "      <td id=\"T_6324b_row12_col9\" class=\"data row12 col9\" >nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row13_col0\" class=\"data row13 col0\" >应收票据</td>\n",
       "      <td id=\"T_6324b_row13_col1\" class=\"data row13 col1\" >1.12亿</td>\n",
       "      <td id=\"T_6324b_row13_col2\" class=\"data row13 col2\" >0.85亿</td>\n",
       "      <td id=\"T_6324b_row13_col3\" class=\"data row13 col3\" >0.0亿</td>\n",
       "      <td id=\"T_6324b_row13_col4\" class=\"data row13 col4\" >0.67亿</td>\n",
       "      <td id=\"T_6324b_row13_col5\" class=\"data row13 col5\" >nan</td>\n",
       "      <td id=\"T_6324b_row13_col6\" class=\"data row13 col6\" >0.02亿</td>\n",
       "      <td id=\"T_6324b_row13_col7\" class=\"data row13 col7\" >0.23亿</td>\n",
       "      <td id=\"T_6324b_row13_col8\" class=\"data row13 col8\" >0.48亿</td>\n",
       "      <td id=\"T_6324b_row13_col9\" class=\"data row13 col9\" >0.43亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row14_col0\" class=\"data row14 col0\" >应收账款</td>\n",
       "      <td id=\"T_6324b_row14_col1\" class=\"data row14 col1\" >12.99亿</td>\n",
       "      <td id=\"T_6324b_row14_col2\" class=\"data row14 col2\" >22.7亿</td>\n",
       "      <td id=\"T_6324b_row14_col3\" class=\"data row14 col3\" >19.64亿</td>\n",
       "      <td id=\"T_6324b_row14_col4\" class=\"data row14 col4\" >15.94亿</td>\n",
       "      <td id=\"T_6324b_row14_col5\" class=\"data row14 col5\" >19.32亿</td>\n",
       "      <td id=\"T_6324b_row14_col6\" class=\"data row14 col6\" >6.78亿</td>\n",
       "      <td id=\"T_6324b_row14_col7\" class=\"data row14 col7\" >6.94亿</td>\n",
       "      <td id=\"T_6324b_row14_col8\" class=\"data row14 col8\" >1.6亿</td>\n",
       "      <td id=\"T_6324b_row14_col9\" class=\"data row14 col9\" >1.5亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row15_col0\" class=\"data row15 col0\" >其他应收款</td>\n",
       "      <td id=\"T_6324b_row15_col1\" class=\"data row15 col1\" >0.72亿</td>\n",
       "      <td id=\"T_6324b_row15_col2\" class=\"data row15 col2\" >1.76亿</td>\n",
       "      <td id=\"T_6324b_row15_col3\" class=\"data row15 col3\" >1.14亿</td>\n",
       "      <td id=\"T_6324b_row15_col4\" class=\"data row15 col4\" >1.57亿</td>\n",
       "      <td id=\"T_6324b_row15_col5\" class=\"data row15 col5\" >0.88亿</td>\n",
       "      <td id=\"T_6324b_row15_col6\" class=\"data row15 col6\" >1.1亿</td>\n",
       "      <td id=\"T_6324b_row15_col7\" class=\"data row15 col7\" >0.12亿</td>\n",
       "      <td id=\"T_6324b_row15_col8\" class=\"data row15 col8\" >0.03亿</td>\n",
       "      <td id=\"T_6324b_row15_col9\" class=\"data row15 col9\" >0.03亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row16_col0\" class=\"data row16 col0\" >预付款项</td>\n",
       "      <td id=\"T_6324b_row16_col1\" class=\"data row16 col1\" >3.31亿</td>\n",
       "      <td id=\"T_6324b_row16_col2\" class=\"data row16 col2\" >5.42亿</td>\n",
       "      <td id=\"T_6324b_row16_col3\" class=\"data row16 col3\" >7.9亿</td>\n",
       "      <td id=\"T_6324b_row16_col4\" class=\"data row16 col4\" >8.52亿</td>\n",
       "      <td id=\"T_6324b_row16_col5\" class=\"data row16 col5\" >4.83亿</td>\n",
       "      <td id=\"T_6324b_row16_col6\" class=\"data row16 col6\" >0.93亿</td>\n",
       "      <td id=\"T_6324b_row16_col7\" class=\"data row16 col7\" >0.49亿</td>\n",
       "      <td id=\"T_6324b_row16_col8\" class=\"data row16 col8\" >0.02亿</td>\n",
       "      <td id=\"T_6324b_row16_col9\" class=\"data row16 col9\" >0.1亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row17_col0\" class=\"data row17 col0\" >存货</td>\n",
       "      <td id=\"T_6324b_row17_col1\" class=\"data row17 col1\" >10.27亿</td>\n",
       "      <td id=\"T_6324b_row17_col2\" class=\"data row17 col2\" >17.6亿</td>\n",
       "      <td id=\"T_6324b_row17_col3\" class=\"data row17 col3\" >21.42亿</td>\n",
       "      <td id=\"T_6324b_row17_col4\" class=\"data row17 col4\" >15.76亿</td>\n",
       "      <td id=\"T_6324b_row17_col5\" class=\"data row17 col5\" >4.96亿</td>\n",
       "      <td id=\"T_6324b_row17_col6\" class=\"data row17 col6\" >3.44亿</td>\n",
       "      <td id=\"T_6324b_row17_col7\" class=\"data row17 col7\" >4.52亿</td>\n",
       "      <td id=\"T_6324b_row17_col8\" class=\"data row17 col8\" >1.14亿</td>\n",
       "      <td id=\"T_6324b_row17_col9\" class=\"data row17 col9\" >0.84亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row18_col0\" class=\"data row18 col0\" >其他流动资产</td>\n",
       "      <td id=\"T_6324b_row18_col1\" class=\"data row18 col1\" >3.46亿</td>\n",
       "      <td id=\"T_6324b_row18_col2\" class=\"data row18 col2\" >5.17亿</td>\n",
       "      <td id=\"T_6324b_row18_col3\" class=\"data row18 col3\" >15.38亿</td>\n",
       "      <td id=\"T_6324b_row18_col4\" class=\"data row18 col4\" >27.54亿</td>\n",
       "      <td id=\"T_6324b_row18_col5\" class=\"data row18 col5\" >60.5亿</td>\n",
       "      <td id=\"T_6324b_row18_col6\" class=\"data row18 col6\" >1.69亿</td>\n",
       "      <td id=\"T_6324b_row18_col7\" class=\"data row18 col7\" >0.62亿</td>\n",
       "      <td id=\"T_6324b_row18_col8\" class=\"data row18 col8\" >0.0亿</td>\n",
       "      <td id=\"T_6324b_row18_col9\" class=\"data row18 col9\" >0.04亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row19_col0\" class=\"data row19 col0\" >流动资产合计</td>\n",
       "      <td id=\"T_6324b_row19_col1\" class=\"data row19 col1\" >78.85亿</td>\n",
       "      <td id=\"T_6324b_row19_col2\" class=\"data row19 col2\" >101.32亿</td>\n",
       "      <td id=\"T_6324b_row19_col3\" class=\"data row19 col3\" >107.83亿</td>\n",
       "      <td id=\"T_6324b_row19_col4\" class=\"data row19 col4\" >102.46亿</td>\n",
       "      <td id=\"T_6324b_row19_col5\" class=\"data row19 col5\" >112.08亿</td>\n",
       "      <td id=\"T_6324b_row19_col6\" class=\"data row19 col6\" >24.98亿</td>\n",
       "      <td id=\"T_6324b_row19_col7\" class=\"data row19 col7\" >15.49亿</td>\n",
       "      <td id=\"T_6324b_row19_col8\" class=\"data row19 col8\" >3.48亿</td>\n",
       "      <td id=\"T_6324b_row19_col9\" class=\"data row19 col9\" >3.95亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row20_col0\" class=\"data row20 col0\" >长期股权投资</td>\n",
       "      <td id=\"T_6324b_row20_col1\" class=\"data row20 col1\" >27.68亿</td>\n",
       "      <td id=\"T_6324b_row20_col2\" class=\"data row20 col2\" >19.14亿</td>\n",
       "      <td id=\"T_6324b_row20_col3\" class=\"data row20 col3\" >15.59亿</td>\n",
       "      <td id=\"T_6324b_row20_col4\" class=\"data row20 col4\" >14.82亿</td>\n",
       "      <td id=\"T_6324b_row20_col5\" class=\"data row20 col5\" >8.68亿</td>\n",
       "      <td id=\"T_6324b_row20_col6\" class=\"data row20 col6\" >4.16亿</td>\n",
       "      <td id=\"T_6324b_row20_col7\" class=\"data row20 col7\" >nan</td>\n",
       "      <td id=\"T_6324b_row20_col8\" class=\"data row20 col8\" >0.33亿</td>\n",
       "      <td id=\"T_6324b_row20_col9\" class=\"data row20 col9\" >0.19亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row21_col0\" class=\"data row21 col0\" >固定资产</td>\n",
       "      <td id=\"T_6324b_row21_col1\" class=\"data row21 col1\" >3.54亿</td>\n",
       "      <td id=\"T_6324b_row21_col2\" class=\"data row21 col2\" >3.64亿</td>\n",
       "      <td id=\"T_6324b_row21_col3\" class=\"data row21 col3\" >3.62亿</td>\n",
       "      <td id=\"T_6324b_row21_col4\" class=\"data row21 col4\" >4.79亿</td>\n",
       "      <td id=\"T_6324b_row21_col5\" class=\"data row21 col5\" >5.26亿</td>\n",
       "      <td id=\"T_6324b_row21_col6\" class=\"data row21 col6\" >0.08亿</td>\n",
       "      <td id=\"T_6324b_row21_col7\" class=\"data row21 col7\" >0.16亿</td>\n",
       "      <td id=\"T_6324b_row21_col8\" class=\"data row21 col8\" >3.05亿</td>\n",
       "      <td id=\"T_6324b_row21_col9\" class=\"data row21 col9\" >1.27亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row22_col0\" class=\"data row22 col0\" >在建工程</td>\n",
       "      <td id=\"T_6324b_row22_col1\" class=\"data row22 col1\" >2.75亿</td>\n",
       "      <td id=\"T_6324b_row22_col2\" class=\"data row22 col2\" >0.48亿</td>\n",
       "      <td id=\"T_6324b_row22_col3\" class=\"data row22 col3\" >nan</td>\n",
       "      <td id=\"T_6324b_row22_col4\" class=\"data row22 col4\" >0.12亿</td>\n",
       "      <td id=\"T_6324b_row22_col5\" class=\"data row22 col5\" >0.01亿</td>\n",
       "      <td id=\"T_6324b_row22_col6\" class=\"data row22 col6\" >nan</td>\n",
       "      <td id=\"T_6324b_row22_col7\" class=\"data row22 col7\" >0.0亿</td>\n",
       "      <td id=\"T_6324b_row22_col8\" class=\"data row22 col8\" >0.07亿</td>\n",
       "      <td id=\"T_6324b_row22_col9\" class=\"data row22 col9\" >1.14亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row23_col0\" class=\"data row23 col0\" >无形资产</td>\n",
       "      <td id=\"T_6324b_row23_col1\" class=\"data row23 col1\" >1.9亿</td>\n",
       "      <td id=\"T_6324b_row23_col2\" class=\"data row23 col2\" >2.14亿</td>\n",
       "      <td id=\"T_6324b_row23_col3\" class=\"data row23 col3\" >0.87亿</td>\n",
       "      <td id=\"T_6324b_row23_col4\" class=\"data row23 col4\" >1.14亿</td>\n",
       "      <td id=\"T_6324b_row23_col5\" class=\"data row23 col5\" >1.32亿</td>\n",
       "      <td id=\"T_6324b_row23_col6\" class=\"data row23 col6\" >0.03亿</td>\n",
       "      <td id=\"T_6324b_row23_col7\" class=\"data row23 col7\" >0.04亿</td>\n",
       "      <td id=\"T_6324b_row23_col8\" class=\"data row23 col8\" >0.62亿</td>\n",
       "      <td id=\"T_6324b_row23_col9\" class=\"data row23 col9\" >0.64亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row24_col0\" class=\"data row24 col0\" >研发支出</td>\n",
       "      <td id=\"T_6324b_row24_col1\" class=\"data row24 col1\" >2.29亿</td>\n",
       "      <td id=\"T_6324b_row24_col2\" class=\"data row24 col2\" >1.54亿</td>\n",
       "      <td id=\"T_6324b_row24_col3\" class=\"data row24 col3\" >nan</td>\n",
       "      <td id=\"T_6324b_row24_col4\" class=\"data row24 col4\" >nan</td>\n",
       "      <td id=\"T_6324b_row24_col5\" class=\"data row24 col5\" >nan</td>\n",
       "      <td id=\"T_6324b_row24_col6\" class=\"data row24 col6\" >nan</td>\n",
       "      <td id=\"T_6324b_row24_col7\" class=\"data row24 col7\" >nan</td>\n",
       "      <td id=\"T_6324b_row24_col8\" class=\"data row24 col8\" >nan</td>\n",
       "      <td id=\"T_6324b_row24_col9\" class=\"data row24 col9\" >nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row25_col0\" class=\"data row25 col0\" >商誉</td>\n",
       "      <td id=\"T_6324b_row25_col1\" class=\"data row25 col1\" >2.72亿</td>\n",
       "      <td id=\"T_6324b_row25_col2\" class=\"data row25 col2\" >6.2亿</td>\n",
       "      <td id=\"T_6324b_row25_col3\" class=\"data row25 col3\" >9.32亿</td>\n",
       "      <td id=\"T_6324b_row25_col4\" class=\"data row25 col4\" >20.4亿</td>\n",
       "      <td id=\"T_6324b_row25_col5\" class=\"data row25 col5\" >13.96亿</td>\n",
       "      <td id=\"T_6324b_row25_col6\" class=\"data row25 col6\" >0.54亿</td>\n",
       "      <td id=\"T_6324b_row25_col7\" class=\"data row25 col7\" >0.54亿</td>\n",
       "      <td id=\"T_6324b_row25_col8\" class=\"data row25 col8\" >nan</td>\n",
       "      <td id=\"T_6324b_row25_col9\" class=\"data row25 col9\" >nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row26_col0\" class=\"data row26 col0\" >长期待摊费用</td>\n",
       "      <td id=\"T_6324b_row26_col1\" class=\"data row26 col1\" >0.19亿</td>\n",
       "      <td id=\"T_6324b_row26_col2\" class=\"data row26 col2\" >0.26亿</td>\n",
       "      <td id=\"T_6324b_row26_col3\" class=\"data row26 col3\" >0.46亿</td>\n",
       "      <td id=\"T_6324b_row26_col4\" class=\"data row26 col4\" >2.29亿</td>\n",
       "      <td id=\"T_6324b_row26_col5\" class=\"data row26 col5\" >1.61亿</td>\n",
       "      <td id=\"T_6324b_row26_col6\" class=\"data row26 col6\" >0.01亿</td>\n",
       "      <td id=\"T_6324b_row26_col7\" class=\"data row26 col7\" >0.14亿</td>\n",
       "      <td id=\"T_6324b_row26_col8\" class=\"data row26 col8\" >nan</td>\n",
       "      <td id=\"T_6324b_row26_col9\" class=\"data row26 col9\" >nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row27_col0\" class=\"data row27 col0\" >递延所得税资产</td>\n",
       "      <td id=\"T_6324b_row27_col1\" class=\"data row27 col1\" >7.1亿</td>\n",
       "      <td id=\"T_6324b_row27_col2\" class=\"data row27 col2\" >5.85亿</td>\n",
       "      <td id=\"T_6324b_row27_col3\" class=\"data row27 col3\" >2.8亿</td>\n",
       "      <td id=\"T_6324b_row27_col4\" class=\"data row27 col4\" >2.11亿</td>\n",
       "      <td id=\"T_6324b_row27_col5\" class=\"data row27 col5\" >1.48亿</td>\n",
       "      <td id=\"T_6324b_row27_col6\" class=\"data row27 col6\" >0.35亿</td>\n",
       "      <td id=\"T_6324b_row27_col7\" class=\"data row27 col7\" >0.09亿</td>\n",
       "      <td id=\"T_6324b_row27_col8\" class=\"data row27 col8\" >0.04亿</td>\n",
       "      <td id=\"T_6324b_row27_col9\" class=\"data row27 col9\" >0.03亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row28_col0\" class=\"data row28 col0\" >其他非流动资产</td>\n",
       "      <td id=\"T_6324b_row28_col1\" class=\"data row28 col1\" >4.3亿</td>\n",
       "      <td id=\"T_6324b_row28_col2\" class=\"data row28 col2\" >1.35亿</td>\n",
       "      <td id=\"T_6324b_row28_col3\" class=\"data row28 col3\" >0.35亿</td>\n",
       "      <td id=\"T_6324b_row28_col4\" class=\"data row28 col4\" >0.16亿</td>\n",
       "      <td id=\"T_6324b_row28_col5\" class=\"data row28 col5\" >0.27亿</td>\n",
       "      <td id=\"T_6324b_row28_col6\" class=\"data row28 col6\" >0.16亿</td>\n",
       "      <td id=\"T_6324b_row28_col7\" class=\"data row28 col7\" >nan</td>\n",
       "      <td id=\"T_6324b_row28_col8\" class=\"data row28 col8\" >nan</td>\n",
       "      <td id=\"T_6324b_row28_col9\" class=\"data row28 col9\" >nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row29_col0\" class=\"data row29 col0\" >非流动资产合计</td>\n",
       "      <td id=\"T_6324b_row29_col1\" class=\"data row29 col1\" >76.22亿</td>\n",
       "      <td id=\"T_6324b_row29_col2\" class=\"data row29 col2\" >64.97亿</td>\n",
       "      <td id=\"T_6324b_row29_col3\" class=\"data row29 col3\" >51.95亿</td>\n",
       "      <td id=\"T_6324b_row29_col4\" class=\"data row29 col4\" >63.39亿</td>\n",
       "      <td id=\"T_6324b_row29_col5\" class=\"data row29 col5\" >50.89亿</td>\n",
       "      <td id=\"T_6324b_row29_col6\" class=\"data row29 col6\" >5.33亿</td>\n",
       "      <td id=\"T_6324b_row29_col7\" class=\"data row29 col7\" >0.97亿</td>\n",
       "      <td id=\"T_6324b_row29_col8\" class=\"data row29 col8\" >4.11亿</td>\n",
       "      <td id=\"T_6324b_row29_col9\" class=\"data row29 col9\" >3.27亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row30_col0\" class=\"data row30 col0\" >资产总计</td>\n",
       "      <td id=\"T_6324b_row30_col1\" class=\"data row30 col1\" >155.07亿</td>\n",
       "      <td id=\"T_6324b_row30_col2\" class=\"data row30 col2\" >166.29亿</td>\n",
       "      <td id=\"T_6324b_row30_col3\" class=\"data row30 col3\" >159.78亿</td>\n",
       "      <td id=\"T_6324b_row30_col4\" class=\"data row30 col4\" >165.85亿</td>\n",
       "      <td id=\"T_6324b_row30_col5\" class=\"data row30 col5\" >162.97亿</td>\n",
       "      <td id=\"T_6324b_row30_col6\" class=\"data row30 col6\" >30.31亿</td>\n",
       "      <td id=\"T_6324b_row30_col7\" class=\"data row30 col7\" >16.46亿</td>\n",
       "      <td id=\"T_6324b_row30_col8\" class=\"data row30 col8\" >7.59亿</td>\n",
       "      <td id=\"T_6324b_row30_col9\" class=\"data row30 col9\" >7.22亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row31_col0\" class=\"data row31 col0\" >长期借款</td>\n",
       "      <td id=\"T_6324b_row31_col1\" class=\"data row31 col1\" >0.23亿</td>\n",
       "      <td id=\"T_6324b_row31_col2\" class=\"data row31 col2\" >2.25亿</td>\n",
       "      <td id=\"T_6324b_row31_col3\" class=\"data row31 col3\" >7.94亿</td>\n",
       "      <td id=\"T_6324b_row31_col4\" class=\"data row31 col4\" >5.0亿</td>\n",
       "      <td id=\"T_6324b_row31_col5\" class=\"data row31 col5\" >20.33亿</td>\n",
       "      <td id=\"T_6324b_row31_col6\" class=\"data row31 col6\" >6.43亿</td>\n",
       "      <td id=\"T_6324b_row31_col7\" class=\"data row31 col7\" >2.67亿</td>\n",
       "      <td id=\"T_6324b_row31_col8\" class=\"data row31 col8\" >nan</td>\n",
       "      <td id=\"T_6324b_row31_col9\" class=\"data row31 col9\" >nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row32_col0\" class=\"data row32 col0\" >短期借款</td>\n",
       "      <td id=\"T_6324b_row32_col1\" class=\"data row32 col1\" >7.84亿</td>\n",
       "      <td id=\"T_6324b_row32_col2\" class=\"data row32 col2\" >11.39亿</td>\n",
       "      <td id=\"T_6324b_row32_col3\" class=\"data row32 col3\" >12.7亿</td>\n",
       "      <td id=\"T_6324b_row32_col4\" class=\"data row32 col4\" >6.18亿</td>\n",
       "      <td id=\"T_6324b_row32_col5\" class=\"data row32 col5\" >4.41亿</td>\n",
       "      <td id=\"T_6324b_row32_col6\" class=\"data row32 col6\" >3.09亿</td>\n",
       "      <td id=\"T_6324b_row32_col7\" class=\"data row32 col7\" >0.88亿</td>\n",
       "      <td id=\"T_6324b_row32_col8\" class=\"data row32 col8\" >0.95亿</td>\n",
       "      <td id=\"T_6324b_row32_col9\" class=\"data row32 col9\" >0.84亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row33_col0\" class=\"data row33 col0\" >应付账款</td>\n",
       "      <td id=\"T_6324b_row33_col1\" class=\"data row33 col1\" >7.33亿</td>\n",
       "      <td id=\"T_6324b_row33_col2\" class=\"data row33 col2\" >4.86亿</td>\n",
       "      <td id=\"T_6324b_row33_col3\" class=\"data row33 col3\" >3.93亿</td>\n",
       "      <td id=\"T_6324b_row33_col4\" class=\"data row33 col4\" >4.89亿</td>\n",
       "      <td id=\"T_6324b_row33_col5\" class=\"data row33 col5\" >7.27亿</td>\n",
       "      <td id=\"T_6324b_row33_col6\" class=\"data row33 col6\" >0.18亿</td>\n",
       "      <td id=\"T_6324b_row33_col7\" class=\"data row33 col7\" >0.42亿</td>\n",
       "      <td id=\"T_6324b_row33_col8\" class=\"data row33 col8\" >1.2亿</td>\n",
       "      <td id=\"T_6324b_row33_col9\" class=\"data row33 col9\" >1.23亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row34_col0\" class=\"data row34 col0\" >预收款项</td>\n",
       "      <td id=\"T_6324b_row34_col1\" class=\"data row34 col1\" >0.24亿</td>\n",
       "      <td id=\"T_6324b_row34_col2\" class=\"data row34 col2\" >6.06亿</td>\n",
       "      <td id=\"T_6324b_row34_col3\" class=\"data row34 col3\" >4.09亿</td>\n",
       "      <td id=\"T_6324b_row34_col4\" class=\"data row34 col4\" >5.29亿</td>\n",
       "      <td id=\"T_6324b_row34_col5\" class=\"data row34 col5\" >1.63亿</td>\n",
       "      <td id=\"T_6324b_row34_col6\" class=\"data row34 col6\" >0.51亿</td>\n",
       "      <td id=\"T_6324b_row34_col7\" class=\"data row34 col7\" >0.8亿</td>\n",
       "      <td id=\"T_6324b_row34_col8\" class=\"data row34 col8\" >0.01亿</td>\n",
       "      <td id=\"T_6324b_row34_col9\" class=\"data row34 col9\" >0.0亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row35_col0\" class=\"data row35 col0\" >应付职工薪酬</td>\n",
       "      <td id=\"T_6324b_row35_col1\" class=\"data row35 col1\" >4.37亿</td>\n",
       "      <td id=\"T_6324b_row35_col2\" class=\"data row35 col2\" >5.16亿</td>\n",
       "      <td id=\"T_6324b_row35_col3\" class=\"data row35 col3\" >3.32亿</td>\n",
       "      <td id=\"T_6324b_row35_col4\" class=\"data row35 col4\" >4.72亿</td>\n",
       "      <td id=\"T_6324b_row35_col5\" class=\"data row35 col5\" >4.05亿</td>\n",
       "      <td id=\"T_6324b_row35_col6\" class=\"data row35 col6\" >0.09亿</td>\n",
       "      <td id=\"T_6324b_row35_col7\" class=\"data row35 col7\" >0.09亿</td>\n",
       "      <td id=\"T_6324b_row35_col8\" class=\"data row35 col8\" >0.14亿</td>\n",
       "      <td id=\"T_6324b_row35_col9\" class=\"data row35 col9\" >0.12亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row36_col0\" class=\"data row36 col0\" >应交税费</td>\n",
       "      <td id=\"T_6324b_row36_col1\" class=\"data row36 col1\" >3.4亿</td>\n",
       "      <td id=\"T_6324b_row36_col2\" class=\"data row36 col2\" >2.89亿</td>\n",
       "      <td id=\"T_6324b_row36_col3\" class=\"data row36 col3\" >3.32亿</td>\n",
       "      <td id=\"T_6324b_row36_col4\" class=\"data row36 col4\" >3.71亿</td>\n",
       "      <td id=\"T_6324b_row36_col5\" class=\"data row36 col5\" >3.26亿</td>\n",
       "      <td id=\"T_6324b_row36_col6\" class=\"data row36 col6\" >1.41亿</td>\n",
       "      <td id=\"T_6324b_row36_col7\" class=\"data row36 col7\" >0.86亿</td>\n",
       "      <td id=\"T_6324b_row36_col8\" class=\"data row36 col8\" >0.01亿</td>\n",
       "      <td id=\"T_6324b_row36_col9\" class=\"data row36 col9\" >0.0亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row37_col0\" class=\"data row37 col0\" >应付利息</td>\n",
       "      <td id=\"T_6324b_row37_col1\" class=\"data row37 col1\" >0.0亿</td>\n",
       "      <td id=\"T_6324b_row37_col2\" class=\"data row37 col2\" >0.03亿</td>\n",
       "      <td id=\"T_6324b_row37_col3\" class=\"data row37 col3\" >0.02亿</td>\n",
       "      <td id=\"T_6324b_row37_col4\" class=\"data row37 col4\" >0.03亿</td>\n",
       "      <td id=\"T_6324b_row37_col5\" class=\"data row37 col5\" >0.05亿</td>\n",
       "      <td id=\"T_6324b_row37_col6\" class=\"data row37 col6\" >0.02亿</td>\n",
       "      <td id=\"T_6324b_row37_col7\" class=\"data row37 col7\" >0.01亿</td>\n",
       "      <td id=\"T_6324b_row37_col8\" class=\"data row37 col8\" >0.0亿</td>\n",
       "      <td id=\"T_6324b_row37_col9\" class=\"data row37 col9\" >0.0亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row38_col0\" class=\"data row38 col0\" >应付股利</td>\n",
       "      <td id=\"T_6324b_row38_col1\" class=\"data row38 col1\" >0.0亿</td>\n",
       "      <td id=\"T_6324b_row38_col2\" class=\"data row38 col2\" >0.0亿</td>\n",
       "      <td id=\"T_6324b_row38_col3\" class=\"data row38 col3\" >0.0亿</td>\n",
       "      <td id=\"T_6324b_row38_col4\" class=\"data row38 col4\" >0.0亿</td>\n",
       "      <td id=\"T_6324b_row38_col5\" class=\"data row38 col5\" >0.0亿</td>\n",
       "      <td id=\"T_6324b_row38_col6\" class=\"data row38 col6\" >0.0亿</td>\n",
       "      <td id=\"T_6324b_row38_col7\" class=\"data row38 col7\" >0.44亿</td>\n",
       "      <td id=\"T_6324b_row38_col8\" class=\"data row38 col8\" >nan</td>\n",
       "      <td id=\"T_6324b_row38_col9\" class=\"data row38 col9\" >nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row39_col0\" class=\"data row39 col0\" >其他应付款</td>\n",
       "      <td id=\"T_6324b_row39_col1\" class=\"data row39 col1\" >4.42亿</td>\n",
       "      <td id=\"T_6324b_row39_col2\" class=\"data row39 col2\" >2.87亿</td>\n",
       "      <td id=\"T_6324b_row39_col3\" class=\"data row39 col3\" >2.52亿</td>\n",
       "      <td id=\"T_6324b_row39_col4\" class=\"data row39 col4\" >3.5亿</td>\n",
       "      <td id=\"T_6324b_row39_col5\" class=\"data row39 col5\" >4.14亿</td>\n",
       "      <td id=\"T_6324b_row39_col6\" class=\"data row39 col6\" >4.95亿</td>\n",
       "      <td id=\"T_6324b_row39_col7\" class=\"data row39 col7\" >2.09亿</td>\n",
       "      <td id=\"T_6324b_row39_col8\" class=\"data row39 col8\" >0.07亿</td>\n",
       "      <td id=\"T_6324b_row39_col9\" class=\"data row39 col9\" >0.05亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row40_col0\" class=\"data row40 col0\" >其他流动负债</td>\n",
       "      <td id=\"T_6324b_row40_col1\" class=\"data row40 col1\" >0.57亿</td>\n",
       "      <td id=\"T_6324b_row40_col2\" class=\"data row40 col2\" >10.48亿</td>\n",
       "      <td id=\"T_6324b_row40_col3\" class=\"data row40 col3\" >9.31亿</td>\n",
       "      <td id=\"T_6324b_row40_col4\" class=\"data row40 col4\" >12.78亿</td>\n",
       "      <td id=\"T_6324b_row40_col5\" class=\"data row40 col5\" >16.33亿</td>\n",
       "      <td id=\"T_6324b_row40_col6\" class=\"data row40 col6\" >nan</td>\n",
       "      <td id=\"T_6324b_row40_col7\" class=\"data row40 col7\" >nan</td>\n",
       "      <td id=\"T_6324b_row40_col8\" class=\"data row40 col8\" >nan</td>\n",
       "      <td id=\"T_6324b_row40_col9\" class=\"data row40 col9\" >nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row41_col0\" class=\"data row41 col0\" >流动负债合计</td>\n",
       "      <td id=\"T_6324b_row41_col1\" class=\"data row41 col1\" >42.04亿</td>\n",
       "      <td id=\"T_6324b_row41_col2\" class=\"data row41 col2\" >48.0亿</td>\n",
       "      <td id=\"T_6324b_row41_col3\" class=\"data row41 col3\" >39.21亿</td>\n",
       "      <td id=\"T_6324b_row41_col4\" class=\"data row41 col4\" >52.15亿</td>\n",
       "      <td id=\"T_6324b_row41_col5\" class=\"data row41 col5\" >42.23亿</td>\n",
       "      <td id=\"T_6324b_row41_col6\" class=\"data row41 col6\" >12.39亿</td>\n",
       "      <td id=\"T_6324b_row41_col7\" class=\"data row41 col7\" >5.69亿</td>\n",
       "      <td id=\"T_6324b_row41_col8\" class=\"data row41 col8\" >2.38亿</td>\n",
       "      <td id=\"T_6324b_row41_col9\" class=\"data row41 col9\" >2.25亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row42_col0\" class=\"data row42 col0\" >长期应付款</td>\n",
       "      <td id=\"T_6324b_row42_col1\" class=\"data row42 col1\" >0.01亿</td>\n",
       "      <td id=\"T_6324b_row42_col2\" class=\"data row42 col2\" >0.01亿</td>\n",
       "      <td id=\"T_6324b_row42_col3\" class=\"data row42 col3\" >0.01亿</td>\n",
       "      <td id=\"T_6324b_row42_col4\" class=\"data row42 col4\" >nan</td>\n",
       "      <td id=\"T_6324b_row42_col5\" class=\"data row42 col5\" >0.01亿</td>\n",
       "      <td id=\"T_6324b_row42_col6\" class=\"data row42 col6\" >nan</td>\n",
       "      <td id=\"T_6324b_row42_col7\" class=\"data row42 col7\" >nan</td>\n",
       "      <td id=\"T_6324b_row42_col8\" class=\"data row42 col8\" >nan</td>\n",
       "      <td id=\"T_6324b_row42_col9\" class=\"data row42 col9\" >nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row43_col0\" class=\"data row43 col0\" >专项应付款</td>\n",
       "      <td id=\"T_6324b_row43_col1\" class=\"data row43 col1\" >0.0亿</td>\n",
       "      <td id=\"T_6324b_row43_col2\" class=\"data row43 col2\" >nan</td>\n",
       "      <td id=\"T_6324b_row43_col3\" class=\"data row43 col3\" >nan</td>\n",
       "      <td id=\"T_6324b_row43_col4\" class=\"data row43 col4\" >nan</td>\n",
       "      <td id=\"T_6324b_row43_col5\" class=\"data row43 col5\" >nan</td>\n",
       "      <td id=\"T_6324b_row43_col6\" class=\"data row43 col6\" >nan</td>\n",
       "      <td id=\"T_6324b_row43_col7\" class=\"data row43 col7\" >nan</td>\n",
       "      <td id=\"T_6324b_row43_col8\" class=\"data row43 col8\" >nan</td>\n",
       "      <td id=\"T_6324b_row43_col9\" class=\"data row43 col9\" >nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row44_col0\" class=\"data row44 col0\" >递延所得税负债</td>\n",
       "      <td id=\"T_6324b_row44_col1\" class=\"data row44 col1\" >0.6亿</td>\n",
       "      <td id=\"T_6324b_row44_col2\" class=\"data row44 col2\" >0.46亿</td>\n",
       "      <td id=\"T_6324b_row44_col3\" class=\"data row44 col3\" >0.23亿</td>\n",
       "      <td id=\"T_6324b_row44_col4\" class=\"data row44 col4\" >0.31亿</td>\n",
       "      <td id=\"T_6324b_row44_col5\" class=\"data row44 col5\" >0.37亿</td>\n",
       "      <td id=\"T_6324b_row44_col6\" class=\"data row44 col6\" >0.0亿</td>\n",
       "      <td id=\"T_6324b_row44_col7\" class=\"data row44 col7\" >0.01亿</td>\n",
       "      <td id=\"T_6324b_row44_col8\" class=\"data row44 col8\" >nan</td>\n",
       "      <td id=\"T_6324b_row44_col9\" class=\"data row44 col9\" >nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row45_col0\" class=\"data row45 col0\" >递延收益-非流动负债</td>\n",
       "      <td id=\"T_6324b_row45_col1\" class=\"data row45 col1\" >0.03亿</td>\n",
       "      <td id=\"T_6324b_row45_col2\" class=\"data row45 col2\" >0.1亿</td>\n",
       "      <td id=\"T_6324b_row45_col3\" class=\"data row45 col3\" >0.14亿</td>\n",
       "      <td id=\"T_6324b_row45_col4\" class=\"data row45 col4\" >0.17亿</td>\n",
       "      <td id=\"T_6324b_row45_col5\" class=\"data row45 col5\" >nan</td>\n",
       "      <td id=\"T_6324b_row45_col6\" class=\"data row45 col6\" >nan</td>\n",
       "      <td id=\"T_6324b_row45_col7\" class=\"data row45 col7\" >nan</td>\n",
       "      <td id=\"T_6324b_row45_col8\" class=\"data row45 col8\" >nan</td>\n",
       "      <td id=\"T_6324b_row45_col9\" class=\"data row45 col9\" >nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row46_col0\" class=\"data row46 col0\" >其他非流动负债</td>\n",
       "      <td id=\"T_6324b_row46_col1\" class=\"data row46 col1\" >0.35亿</td>\n",
       "      <td id=\"T_6324b_row46_col2\" class=\"data row46 col2\" >14.19亿</td>\n",
       "      <td id=\"T_6324b_row46_col3\" class=\"data row46 col3\" >19.17亿</td>\n",
       "      <td id=\"T_6324b_row46_col4\" class=\"data row46 col4\" >20.35亿</td>\n",
       "      <td id=\"T_6324b_row46_col5\" class=\"data row46 col5\" >15.52亿</td>\n",
       "      <td id=\"T_6324b_row46_col6\" class=\"data row46 col6\" >nan</td>\n",
       "      <td id=\"T_6324b_row46_col7\" class=\"data row46 col7\" >nan</td>\n",
       "      <td id=\"T_6324b_row46_col8\" class=\"data row46 col8\" >0.13亿</td>\n",
       "      <td id=\"T_6324b_row46_col9\" class=\"data row46 col9\" >0.06亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row47_col0\" class=\"data row47 col0\" >非流动负债合计</td>\n",
       "      <td id=\"T_6324b_row47_col1\" class=\"data row47 col1\" >1.21亿</td>\n",
       "      <td id=\"T_6324b_row47_col2\" class=\"data row47 col2\" >17.01亿</td>\n",
       "      <td id=\"T_6324b_row47_col3\" class=\"data row47 col3\" >27.48亿</td>\n",
       "      <td id=\"T_6324b_row47_col4\" class=\"data row47 col4\" >25.83亿</td>\n",
       "      <td id=\"T_6324b_row47_col5\" class=\"data row47 col5\" >36.22亿</td>\n",
       "      <td id=\"T_6324b_row47_col6\" class=\"data row47 col6\" >6.43亿</td>\n",
       "      <td id=\"T_6324b_row47_col7\" class=\"data row47 col7\" >2.68亿</td>\n",
       "      <td id=\"T_6324b_row47_col8\" class=\"data row47 col8\" >0.13亿</td>\n",
       "      <td id=\"T_6324b_row47_col9\" class=\"data row47 col9\" >0.06亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row48_col0\" class=\"data row48 col0\" >负债合计</td>\n",
       "      <td id=\"T_6324b_row48_col1\" class=\"data row48 col1\" >43.25亿</td>\n",
       "      <td id=\"T_6324b_row48_col2\" class=\"data row48 col2\" >65.01亿</td>\n",
       "      <td id=\"T_6324b_row48_col3\" class=\"data row48 col3\" >66.69亿</td>\n",
       "      <td id=\"T_6324b_row48_col4\" class=\"data row48 col4\" >77.98亿</td>\n",
       "      <td id=\"T_6324b_row48_col5\" class=\"data row48 col5\" >78.45亿</td>\n",
       "      <td id=\"T_6324b_row48_col6\" class=\"data row48 col6\" >18.82亿</td>\n",
       "      <td id=\"T_6324b_row48_col7\" class=\"data row48 col7\" >8.37亿</td>\n",
       "      <td id=\"T_6324b_row48_col8\" class=\"data row48 col8\" >2.51亿</td>\n",
       "      <td id=\"T_6324b_row48_col9\" class=\"data row48 col9\" >2.31亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row49_col0\" class=\"data row49 col0\" >减:库存股</td>\n",
       "      <td id=\"T_6324b_row49_col1\" class=\"data row49 col1\" >0.16亿</td>\n",
       "      <td id=\"T_6324b_row49_col2\" class=\"data row49 col2\" >0.16亿</td>\n",
       "      <td id=\"T_6324b_row49_col3\" class=\"data row49 col3\" >4.17亿</td>\n",
       "      <td id=\"T_6324b_row49_col4\" class=\"data row49 col4\" >nan</td>\n",
       "      <td id=\"T_6324b_row49_col5\" class=\"data row49 col5\" >nan</td>\n",
       "      <td id=\"T_6324b_row49_col6\" class=\"data row49 col6\" >nan</td>\n",
       "      <td id=\"T_6324b_row49_col7\" class=\"data row49 col7\" >nan</td>\n",
       "      <td id=\"T_6324b_row49_col8\" class=\"data row49 col8\" >nan</td>\n",
       "      <td id=\"T_6324b_row49_col9\" class=\"data row49 col9\" >nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row50_col0\" class=\"data row50 col0\" >少数股东权益</td>\n",
       "      <td id=\"T_6324b_row50_col1\" class=\"data row50 col1\" >3.47亿</td>\n",
       "      <td id=\"T_6324b_row50_col2\" class=\"data row50 col2\" >6.14亿</td>\n",
       "      <td id=\"T_6324b_row50_col3\" class=\"data row50 col3\" >8.7亿</td>\n",
       "      <td id=\"T_6324b_row50_col4\" class=\"data row50 col4\" >8.23亿</td>\n",
       "      <td id=\"T_6324b_row50_col5\" class=\"data row50 col5\" >12.38亿</td>\n",
       "      <td id=\"T_6324b_row50_col6\" class=\"data row50 col6\" >1.23亿</td>\n",
       "      <td id=\"T_6324b_row50_col7\" class=\"data row50 col7\" >0.53亿</td>\n",
       "      <td id=\"T_6324b_row50_col8\" class=\"data row50 col8\" >nan</td>\n",
       "      <td id=\"T_6324b_row50_col9\" class=\"data row50 col9\" >nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row51_col0\" class=\"data row51 col0\" >股东权益合计(不含少数股东权益)</td>\n",
       "      <td id=\"T_6324b_row51_col1\" class=\"data row51 col1\" >108.35亿</td>\n",
       "      <td id=\"T_6324b_row51_col2\" class=\"data row51 col2\" >95.15亿</td>\n",
       "      <td id=\"T_6324b_row51_col3\" class=\"data row51 col3\" >84.39亿</td>\n",
       "      <td id=\"T_6324b_row51_col4\" class=\"data row51 col4\" >79.64亿</td>\n",
       "      <td id=\"T_6324b_row51_col5\" class=\"data row51 col5\" >72.14亿</td>\n",
       "      <td id=\"T_6324b_row51_col6\" class=\"data row51 col6\" >10.26亿</td>\n",
       "      <td id=\"T_6324b_row51_col7\" class=\"data row51 col7\" >7.56亿</td>\n",
       "      <td id=\"T_6324b_row51_col8\" class=\"data row51 col8\" >5.08亿</td>\n",
       "      <td id=\"T_6324b_row51_col9\" class=\"data row51 col9\" >4.91亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row52_col0\" class=\"data row52 col0\" >股东权益合计(含少数股东权益)</td>\n",
       "      <td id=\"T_6324b_row52_col1\" class=\"data row52 col1\" >111.82亿</td>\n",
       "      <td id=\"T_6324b_row52_col2\" class=\"data row52 col2\" >101.29亿</td>\n",
       "      <td id=\"T_6324b_row52_col3\" class=\"data row52 col3\" >93.09亿</td>\n",
       "      <td id=\"T_6324b_row52_col4\" class=\"data row52 col4\" >87.87亿</td>\n",
       "      <td id=\"T_6324b_row52_col5\" class=\"data row52 col5\" >84.53亿</td>\n",
       "      <td id=\"T_6324b_row52_col6\" class=\"data row52 col6\" >11.49亿</td>\n",
       "      <td id=\"T_6324b_row52_col7\" class=\"data row52 col7\" >8.09亿</td>\n",
       "      <td id=\"T_6324b_row52_col8\" class=\"data row52 col8\" >5.08亿</td>\n",
       "      <td id=\"T_6324b_row52_col9\" class=\"data row52 col9\" >4.91亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row53_col0\" class=\"data row53 col0\" >负债及股东权益总计</td>\n",
       "      <td id=\"T_6324b_row53_col1\" class=\"data row53 col1\" >155.07亿</td>\n",
       "      <td id=\"T_6324b_row53_col2\" class=\"data row53 col2\" >166.29亿</td>\n",
       "      <td id=\"T_6324b_row53_col3\" class=\"data row53 col3\" >159.78亿</td>\n",
       "      <td id=\"T_6324b_row53_col4\" class=\"data row53 col4\" >165.85亿</td>\n",
       "      <td id=\"T_6324b_row53_col5\" class=\"data row53 col5\" >162.97亿</td>\n",
       "      <td id=\"T_6324b_row53_col6\" class=\"data row53 col6\" >30.31亿</td>\n",
       "      <td id=\"T_6324b_row53_col7\" class=\"data row53 col7\" >16.46亿</td>\n",
       "      <td id=\"T_6324b_row53_col8\" class=\"data row53 col8\" >7.59亿</td>\n",
       "      <td id=\"T_6324b_row53_col9\" class=\"data row53 col9\" >7.22亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row54_col0\" class=\"data row54 col0\" >其他综合收益</td>\n",
       "      <td id=\"T_6324b_row54_col1\" class=\"data row54 col1\" >-1.67亿</td>\n",
       "      <td id=\"T_6324b_row54_col2\" class=\"data row54 col2\" >-0.18亿</td>\n",
       "      <td id=\"T_6324b_row54_col3\" class=\"data row54 col3\" >-0.28亿</td>\n",
       "      <td id=\"T_6324b_row54_col4\" class=\"data row54 col4\" >-0.86亿</td>\n",
       "      <td id=\"T_6324b_row54_col5\" class=\"data row54 col5\" >-0.53亿</td>\n",
       "      <td id=\"T_6324b_row54_col6\" class=\"data row54 col6\" >0.01亿</td>\n",
       "      <td id=\"T_6324b_row54_col7\" class=\"data row54 col7\" >0.0亿</td>\n",
       "      <td id=\"T_6324b_row54_col8\" class=\"data row54 col8\" >nan</td>\n",
       "      <td id=\"T_6324b_row54_col9\" class=\"data row54 col9\" >nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row55_col0\" class=\"data row55 col0\" >合同负债</td>\n",
       "      <td id=\"T_6324b_row55_col1\" class=\"data row55 col1\" >13.87亿</td>\n",
       "      <td id=\"T_6324b_row55_col2\" class=\"data row55 col2\" >nan</td>\n",
       "      <td id=\"T_6324b_row55_col3\" class=\"data row55 col3\" >nan</td>\n",
       "      <td id=\"T_6324b_row55_col4\" class=\"data row55 col4\" >nan</td>\n",
       "      <td id=\"T_6324b_row55_col5\" class=\"data row55 col5\" >nan</td>\n",
       "      <td id=\"T_6324b_row55_col6\" class=\"data row55 col6\" >nan</td>\n",
       "      <td id=\"T_6324b_row55_col7\" class=\"data row55 col7\" >nan</td>\n",
       "      <td id=\"T_6324b_row55_col8\" class=\"data row55 col8\" >nan</td>\n",
       "      <td id=\"T_6324b_row55_col9\" class=\"data row55 col9\" >nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row56_col0\" class=\"data row56 col0\" >应收票据及应收账款</td>\n",
       "      <td id=\"T_6324b_row56_col1\" class=\"data row56 col1\" >14.11亿</td>\n",
       "      <td id=\"T_6324b_row56_col2\" class=\"data row56 col2\" >23.55亿</td>\n",
       "      <td id=\"T_6324b_row56_col3\" class=\"data row56 col3\" >19.64亿</td>\n",
       "      <td id=\"T_6324b_row56_col4\" class=\"data row56 col4\" >16.62亿</td>\n",
       "      <td id=\"T_6324b_row56_col5\" class=\"data row56 col5\" >19.32亿</td>\n",
       "      <td id=\"T_6324b_row56_col6\" class=\"data row56 col6\" >6.79亿</td>\n",
       "      <td id=\"T_6324b_row56_col7\" class=\"data row56 col7\" >7.18亿</td>\n",
       "      <td id=\"T_6324b_row56_col8\" class=\"data row56 col8\" >2.08亿</td>\n",
       "      <td id=\"T_6324b_row56_col9\" class=\"data row56 col9\" >1.93亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row57_col0\" class=\"data row57 col0\" >应付票据及应付账款</td>\n",
       "      <td id=\"T_6324b_row57_col1\" class=\"data row57 col1\" >7.33亿</td>\n",
       "      <td id=\"T_6324b_row57_col2\" class=\"data row57 col2\" >4.86亿</td>\n",
       "      <td id=\"T_6324b_row57_col3\" class=\"data row57 col3\" >3.93亿</td>\n",
       "      <td id=\"T_6324b_row57_col4\" class=\"data row57 col4\" >4.89亿</td>\n",
       "      <td id=\"T_6324b_row57_col5\" class=\"data row57 col5\" >7.27亿</td>\n",
       "      <td id=\"T_6324b_row57_col6\" class=\"data row57 col6\" >0.18亿</td>\n",
       "      <td id=\"T_6324b_row57_col7\" class=\"data row57 col7\" >0.42亿</td>\n",
       "      <td id=\"T_6324b_row57_col8\" class=\"data row57 col8\" >1.2亿</td>\n",
       "      <td id=\"T_6324b_row57_col9\" class=\"data row57 col9\" >1.23亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row58_col0\" class=\"data row58 col0\" >其他应收款(合计)（元）</td>\n",
       "      <td id=\"T_6324b_row58_col1\" class=\"data row58 col1\" >0.72亿</td>\n",
       "      <td id=\"T_6324b_row58_col2\" class=\"data row58 col2\" >1.83亿</td>\n",
       "      <td id=\"T_6324b_row58_col3\" class=\"data row58 col3\" >1.21亿</td>\n",
       "      <td id=\"T_6324b_row58_col4\" class=\"data row58 col4\" >1.67亿</td>\n",
       "      <td id=\"T_6324b_row58_col5\" class=\"data row58 col5\" >0.96亿</td>\n",
       "      <td id=\"T_6324b_row58_col6\" class=\"data row58 col6\" >1.14亿</td>\n",
       "      <td id=\"T_6324b_row58_col7\" class=\"data row58 col7\" >0.12亿</td>\n",
       "      <td id=\"T_6324b_row58_col8\" class=\"data row58 col8\" >0.03亿</td>\n",
       "      <td id=\"T_6324b_row58_col9\" class=\"data row58 col9\" >0.03亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row59_col0\" class=\"data row59 col0\" >固定资产(合计)(元)</td>\n",
       "      <td id=\"T_6324b_row59_col1\" class=\"data row59 col1\" >3.54亿</td>\n",
       "      <td id=\"T_6324b_row59_col2\" class=\"data row59 col2\" >3.64亿</td>\n",
       "      <td id=\"T_6324b_row59_col3\" class=\"data row59 col3\" >3.62亿</td>\n",
       "      <td id=\"T_6324b_row59_col4\" class=\"data row59 col4\" >4.79亿</td>\n",
       "      <td id=\"T_6324b_row59_col5\" class=\"data row59 col5\" >5.26亿</td>\n",
       "      <td id=\"T_6324b_row59_col6\" class=\"data row59 col6\" >0.08亿</td>\n",
       "      <td id=\"T_6324b_row59_col7\" class=\"data row59 col7\" >0.16亿</td>\n",
       "      <td id=\"T_6324b_row59_col8\" class=\"data row59 col8\" >3.05亿</td>\n",
       "      <td id=\"T_6324b_row59_col9\" class=\"data row59 col9\" >1.27亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row60_col0\" class=\"data row60 col0\" >在建工程(合计)(元)</td>\n",
       "      <td id=\"T_6324b_row60_col1\" class=\"data row60 col1\" >2.75亿</td>\n",
       "      <td id=\"T_6324b_row60_col2\" class=\"data row60 col2\" >0.48亿</td>\n",
       "      <td id=\"T_6324b_row60_col3\" class=\"data row60 col3\" >nan</td>\n",
       "      <td id=\"T_6324b_row60_col4\" class=\"data row60 col4\" >0.12亿</td>\n",
       "      <td id=\"T_6324b_row60_col5\" class=\"data row60 col5\" >0.01亿</td>\n",
       "      <td id=\"T_6324b_row60_col6\" class=\"data row60 col6\" >nan</td>\n",
       "      <td id=\"T_6324b_row60_col7\" class=\"data row60 col7\" >0.0亿</td>\n",
       "      <td id=\"T_6324b_row60_col8\" class=\"data row60 col8\" >0.07亿</td>\n",
       "      <td id=\"T_6324b_row60_col9\" class=\"data row60 col9\" >1.14亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row61_col0\" class=\"data row61 col0\" >其他应付款(合计)(元)</td>\n",
       "      <td id=\"T_6324b_row61_col1\" class=\"data row61 col1\" >4.42亿</td>\n",
       "      <td id=\"T_6324b_row61_col2\" class=\"data row61 col2\" >2.9亿</td>\n",
       "      <td id=\"T_6324b_row61_col3\" class=\"data row61 col3\" >2.54亿</td>\n",
       "      <td id=\"T_6324b_row61_col4\" class=\"data row61 col4\" >3.53亿</td>\n",
       "      <td id=\"T_6324b_row61_col5\" class=\"data row61 col5\" >4.19亿</td>\n",
       "      <td id=\"T_6324b_row61_col6\" class=\"data row61 col6\" >4.97亿</td>\n",
       "      <td id=\"T_6324b_row61_col7\" class=\"data row61 col7\" >2.54亿</td>\n",
       "      <td id=\"T_6324b_row61_col8\" class=\"data row61 col8\" >0.07亿</td>\n",
       "      <td id=\"T_6324b_row61_col9\" class=\"data row61 col9\" >0.06亿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row62_col0\" class=\"data row62 col0\" >长期应付款(合计)(元)</td>\n",
       "      <td id=\"T_6324b_row62_col1\" class=\"data row62 col1\" >0.01亿</td>\n",
       "      <td id=\"T_6324b_row62_col2\" class=\"data row62 col2\" >0.01亿</td>\n",
       "      <td id=\"T_6324b_row62_col3\" class=\"data row62 col3\" >0.01亿</td>\n",
       "      <td id=\"T_6324b_row62_col4\" class=\"data row62 col4\" >nan</td>\n",
       "      <td id=\"T_6324b_row62_col5\" class=\"data row62 col5\" >0.01亿</td>\n",
       "      <td id=\"T_6324b_row62_col6\" class=\"data row62 col6\" >nan</td>\n",
       "      <td id=\"T_6324b_row62_col7\" class=\"data row62 col7\" >nan</td>\n",
       "      <td id=\"T_6324b_row62_col8\" class=\"data row62 col8\" >nan</td>\n",
       "      <td id=\"T_6324b_row62_col9\" class=\"data row62 col9\" >nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_6324b_row63_col0\" class=\"data row63 col0\" >更新标识</td>\n",
       "      <td id=\"T_6324b_row63_col1\" class=\"data row63 col1\" >0</td>\n",
       "      <td id=\"T_6324b_row63_col2\" class=\"data row63 col2\" >1</td>\n",
       "      <td id=\"T_6324b_row63_col3\" class=\"data row63 col3\" >0</td>\n",
       "      <td id=\"T_6324b_row63_col4\" class=\"data row63 col4\" >0</td>\n",
       "      <td id=\"T_6324b_row63_col5\" class=\"data row63 col5\" >0</td>\n",
       "      <td id=\"T_6324b_row63_col6\" class=\"data row63 col6\" >0</td>\n",
       "      <td id=\"T_6324b_row63_col7\" class=\"data row63 col7\" >0</td>\n",
       "      <td id=\"T_6324b_row63_col8\" class=\"data row63 col8\" >0</td>\n",
       "      <td id=\"T_6324b_row63_col9\" class=\"data row63 col9\" >0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7fd15acb91f0>"
      ]
     },
     "execution_count": 286,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import tushare as ts\n",
    "import pandas as pd\n",
    "from datetime import datetime \n",
    "pro = ts.pro_api()\n",
    "pd.set_option('display.max_columns', None)\n",
    "pd.set_option('display.max_rows', None)\n",
    "def getbalance_yearly(ts_code='002624.sz',priod=5):\n",
    "    df_all=pd.DataFrame()\n",
    "    for i in range(0,priod+1):\n",
    "        year=datetime.now().year-i\n",
    "        key='Y'+str(year)\n",
    "        df = pro.balancesheet(ts_code='002624.sz',period=str(year)+'1231')\n",
    "        \n",
    "        if(df.empty):\n",
    "            continue\n",
    "            \n",
    "        df = df.stack()\n",
    "        df=pd.DataFrame(df[0])\n",
    "        df['v']=df[0]\n",
    "        df.columns=[\"key\",key]\n",
    "        df['key']=df.index\n",
    "        df['key']=df.apply(lambda x:balance_kv[x.key] if x.key in balance_kv else x.key ,axis = 1)\n",
    "        df[key]=df.apply(lambda x:str(round(int(x[key])/100000000,2))+\"亿\" if isinstance(x[key],float) else x[key],axis = 1)\n",
    "    \n",
    "        if df_all.empty:\n",
    "            df_all=df\n",
    "        else:\n",
    "            df_all['Y'+str(year)]=df['Y'+str(year)]\n",
    "        \n",
    "    return df_all\n",
    "\n",
    "df=getbalance_yearly(ts_code='002624.sz',priod=10)\n",
    "\n",
    "def markblod(x):\n",
    "    blod_key=['货币资金','流动资产合计','非流动资产合计','流动负债合计','负债合计','负债及股东权益总计','固定资产(合计)(元)','应收票据及应收账款','应付票据及应付账款']     \n",
    "    return 'color : red;font-weight:700' if x in blod_key else ''\n",
    "\n",
    "df=df.style.applymap(markblod).set_caption('<h3>完美世界(002624.sz)-资产负债表</h3>').hide()\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "973e1d3a",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}