量化分析/市场研究/applicant-sponsor-stats.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "import akshare as ak\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import calendar\n",
    "%matplotlib inline\n",
    "\n",
    "#设置完整显示数据\n",
    "pd.set_option('display.max_rows', 500)\n",
    "pd.set_option('display.max_columns', \n",
    "              500)\n",
    "pd.set_option('display.width', 1000)\n",
    "pd.set_option('display.float_format', '{:,.2f}'.format)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [],
   "source": [
    "stock_register_kcb_df = ak.stock_register_kcb()\n",
    "stock_register_cyb_df = ak.stock_register_cyb()\n",
    "stock_register_kcb_df = stock_register_kcb_df.append(stock_register_cyb_df, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "       序号              发行人全称     审核状态 注册地             证监会行业              保荐机构        律师事务所              会计师事务所                 更新日期                 受理日期 拟上市地点\n",
      "0       1    上海芯龙半导体技术股份有限公司      已问询  上海        软件和信息技术服务业        海通证券股份有限公司   上海市广发律师事务所    大华会计师事务所(特殊普通合伙)  2022-01-12 00:00:00  2021-06-22 00:00:00   科创板\n",
      "1       2    深圳市紫光照明技术股份有限公司     终止注册  广东        电气机械和器材制造业        华安证券股份有限公司   北京市君合律师事务所    天健会计师事务所(特殊普通合伙)  2022-01-12 00:00:00  2020-06-30 00:00:00   科创板\n",
      "2       3      武汉新华扬生物股份有限公司      已问询  湖北             食品制造业      中信建投证券股份有限公司  上海市锦天城律师事务所    天健会计师事务所(特殊普通合伙)  2022-01-12 00:00:00  2021-09-28 00:00:00   科创板\n",
      "3       4     成都思科瑞微电子股份有限公司  上市委会议通过  四川           专业技术服务业      中国银河证券股份有限公司   北京市君合律师事务所    中汇会计师事务所(特殊普通合伙)  2022-01-11 00:00:00  2021-05-27 00:00:00   科创板\n",
      "4       5       杭州萤石网络股份有限公司      已问询  浙江  计算机、通信和其他电子设备制造业      中国国际金融股份有限公司  国浩律师(杭州)事务所  德勤华永会计师事务所(特殊普通合伙)  2022-01-11 00:00:00  2021-12-13 00:00:00   科创板\n",
      "...   ...                ...      ...  ..               ...               ...          ...                 ...                  ...                  ...   ...\n",
      "1511  827      成都大宏立机器股份有限公司     注册生效  四川           专用设备制造业        国都证券股份有限公司  北京金诚同达律师事务所    大信会计师事务所(特殊普通合伙)  2020-07-29 00:00:00  2020-06-28 00:00:00   创业板\n",
      "1512  828   北京锋尚世纪文化传媒股份有限公司     注册生效  北京             文化艺术业      中信建投证券股份有限公司   北京市中伦律师事务所  信永中和会计师事务所(特殊普通合伙)  2020-07-24 00:00:00  2020-06-22 00:00:00   创业板\n",
      "1513  829      安徽蓝盾光电子股份有限公司     注册生效  安徽           仪器仪表制造业        华龙证券股份有限公司    安徽承义律师事务所    容诚会计师事务所(特殊普通合伙)  2020-07-24 00:00:00  2020-06-30 00:00:00   创业板\n",
      "1514  830  康泰医学系统(秦皇岛)股份有限公司     注册生效  河北           专用设备制造业  申万宏源证券承销保荐有限责任公司   北京市中伦律师事务所  德勤华永会计师事务所(特殊普通合伙)  2020-07-24 00:00:00  2020-07-02 00:00:00   创业板\n",
      "1515  831      杨凌美畅新材料股份有限公司     注册生效  陕西          非金属矿物制品业      中信建投证券股份有限公司    北京国枫律师事务所  立信中联会计师事务所(特殊普通合伙)  2020-07-24 00:00:00  2020-06-24 00:00:00   创业板\n",
      "\n",
      "[1516 rows x 11 columns]\n"
     ]
    }
   ],
   "source": [
    "print(stock_register_kcb_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Jan     15\n",
       "Feb      6\n",
       "Mar     59\n",
       "Apr    120\n",
       "May     98\n",
       "Jun    446\n",
       "Jul    257\n",
       "Aug     24\n",
       "Sep     97\n",
       "Oct     54\n",
       "Nov     76\n",
       "Dec    264\n",
       "Name: 受理日期, dtype: int64"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stats = pd.to_datetime(stock_register_kcb_df[\"受理日期\"]).dt.strftime(\"%b\").value_counts()\n",
    "month_names = calendar.month_abbr[1:]\n",
    "stats_by_month = stats.reindex(month_names, fill_value=0)\n",
    "stats_by_month"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Jan    0.99\n",
       "Feb    0.40\n",
       "Mar    3.89\n",
       "Apr    7.92\n",
       "May    6.46\n",
       "Jun   29.42\n",
       "Jul   16.95\n",
       "Aug    1.58\n",
       "Sep    6.40\n",
       "Oct    3.56\n",
       "Nov    5.01\n",
       "Dec   17.41\n",
       "Name: 受理日期, dtype: float64"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(stats_by_month/stats_by_month.sum())*100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><div id=73d2e951-c25b-484f-a712-a606bf8264bc style=\"display:none; background-color:#9D6CFF; color:white; width:200px; height:30px; padding-left:5px; border-radius:4px; flex-direction:row; justify-content:space-around; align-items:center;\" onmouseover=\"this.style.backgroundColor='#BA9BF8'\" onmouseout=\"this.style.backgroundColor='#9D6CFF'\" onclick=\"window.commands?.execute('create-mitosheet-from-dataframe-output');\">See Full Dataframe in Mito</div> <script> if (window.commands.hasCommand('create-mitosheet-from-dataframe-output')) document.getElementById('73d2e951-c25b-484f-a712-a606bf8264bc').style.display = 'flex' </script> <table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>受理申报数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>保荐机构</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>中信证券股份有限公司</th>\n",
       "      <td>159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中信建投证券股份有限公司</th>\n",
       "      <td>114</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华泰联合证券有限责任公司</th>\n",
       "      <td>101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>海通证券股份有限公司</th>\n",
       "      <td>95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国国际金融股份有限公司</th>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>民生证券股份有限公司</th>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国泰君安证券股份有限公司</th>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国金证券股份有限公司</th>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国信证券股份有限公司</th>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>招商证券股份有限公司</th>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>安信证券股份有限公司</th>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>长江证券承销保荐有限公司</th>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>申万宏源证券承销保荐有限责任公司</th>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东兴证券股份有限公司</th>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>兴业证券股份有限公司</th>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东吴证券股份有限公司</th>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东方证券承销保荐有限公司</th>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>光大证券股份有限公司</th>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中泰证券股份有限公司</th>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国元证券股份有限公司</th>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>西部证券股份有限公司</th>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东莞证券股份有限公司</th>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>浙商证券股份有限公司</th>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中天国富证券有限公司</th>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中原证券股份有限公司</th>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广发证券股份有限公司</th>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>平安证券股份有限公司</th>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>长城证券股份有限公司</th>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国银河证券股份有限公司</th>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华安证券股份有限公司</th>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>申港证券股份有限公司</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>财通证券股份有限公司</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华西证券股份有限公司</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华创证券有限责任公司</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>天风证券股份有限公司</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>第一创业证券承销保荐有限责任公司</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东北证券股份有限公司</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>五矿证券有限公司</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>万和证券股份有限公司</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华林证券股份有限公司</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东海证券股份有限公司</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中德证券有限责任公司</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>德邦证券股份有限公司</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>信达证券股份有限公司</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>方正证券承销保荐有限责任公司</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华英证券有限责任公司</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华金证券股份有限公司</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>南京证券股份有限公司</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>开源证券股份有限公司</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华龙证券股份有限公司</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国融证券股份有限公司</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华兴证券有限公司</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>瑞信方正证券有限责任公司</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>渤海证券股份有限公司</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>瑞银证券有限责任公司</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国海证券股份有限公司</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>英大证券有限责任公司</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中银国际证券股份有限公司</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华福证券有限责任公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东方花旗证券有限公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>金元证券股份有限公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>西南证券股份有限公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>太平洋证券股份有限公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>湘财证券股份有限公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国民族证券有限责任公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华融证券股份有限公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国都证券股份有限公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国信证券股份有限公司,华英证券有限责任公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>光大证券股份有限公司,华泰联合证券有限责任公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>首创证券有限责任公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>海通证券股份有限公司,中国国际金融股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国国际金融股份有限公司,中信证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>长城证券股份有限公司,中信建投证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>五矿证券有限公司,国泰君安证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华泰联合证券有限责任公司,中信建投证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>海通证券股份有限公司,中航证券有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华泰联合证券有限责任公司,中国国际金融股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>爱建证券有限责任公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>五矿证券有限公司,中信证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国国际金融股份有限公司,中信建投证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中航证券有限公司,中信建投证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国泰君安证券股份有限公司,海通证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华菁证券有限公司,国泰君安证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中泰证券股份有限公司,红塔证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中山证券有限责任公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中银国际证券股份有限公司,中国国际金融股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国盛证券有限责任公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>长城国瑞证券有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中航证券有限公司,中信证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>九州证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国开证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>联储证券有限责任公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中航证券有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华泰联合证券有限责任公司,安信证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>高盛高华证券有限责任公司,中国国际金融股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国国际金融股份有限公司,民生证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>红塔证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table></div>"
      ],
      "text/plain": [
       "                           受理申报数\n",
       "保荐机构                            \n",
       "中信证券股份有限公司                   159\n",
       "中信建投证券股份有限公司                 114\n",
       "华泰联合证券有限责任公司                 101\n",
       "海通证券股份有限公司                    95\n",
       "中国国际金融股份有限公司                  85\n",
       "民生证券股份有限公司                    82\n",
       "国泰君安证券股份有限公司                  79\n",
       "国金证券股份有限公司                    61\n",
       "国信证券股份有限公司                    58\n",
       "招商证券股份有限公司                    49\n",
       "安信证券股份有限公司                    46\n",
       "长江证券承销保荐有限公司                  41\n",
       "申万宏源证券承销保荐有限责任公司              34\n",
       "东兴证券股份有限公司                    34\n",
       "兴业证券股份有限公司                    29\n",
       "东吴证券股份有限公司                    28\n",
       "东方证券承销保荐有限公司                  27\n",
       "光大证券股份有限公司                    26\n",
       "中泰证券股份有限公司                    25\n",
       "国元证券股份有限公司                    22\n",
       "西部证券股份有限公司                    22\n",
       "东莞证券股份有限公司                    21\n",
       "浙商证券股份有限公司                    17\n",
       "中天国富证券有限公司                    16\n",
       "中原证券股份有限公司                    14\n",
       "广发证券股份有限公司                    13\n",
       "平安证券股份有限公司                    13\n",
       "长城证券股份有限公司                    12\n",
       "中国银河证券股份有限公司                   9\n",
       "华安证券股份有限公司                     9\n",
       "申港证券股份有限公司                     8\n",
       "财通证券股份有限公司                     7\n",
       "华西证券股份有限公司                     7\n",
       "华创证券有限责任公司                     7\n",
       "天风证券股份有限公司                     6\n",
       "第一创业证券承销保荐有限责任公司               6\n",
       "东北证券股份有限公司                     6\n",
       "五矿证券有限公司                       5\n",
       "万和证券股份有限公司                     5\n",
       "华林证券股份有限公司                     5\n",
       "东海证券股份有限公司                     5\n",
       "中德证券有限责任公司                     5\n",
       "德邦证券股份有限公司                     4\n",
       "信达证券股份有限公司                     4\n",
       "方正证券承销保荐有限责任公司                 4\n",
       "华英证券有限责任公司                     4\n",
       "华金证券股份有限公司                     4\n",
       "南京证券股份有限公司                     4\n",
       "开源证券股份有限公司                     4\n",
       "华龙证券股份有限公司                     3\n",
       "国融证券股份有限公司                     3\n",
       "华兴证券有限公司                       3\n",
       "瑞信方正证券有限责任公司                   3\n",
       "渤海证券股份有限公司                     3\n",
       "瑞银证券有限责任公司                     3\n",
       "国海证券股份有限公司                     3\n",
       "英大证券有限责任公司                     3\n",
       "中银国际证券股份有限公司                   3\n",
       "华福证券有限责任公司                     2\n",
       "东方花旗证券有限公司                     2\n",
       "金元证券股份有限公司                     2\n",
       "西南证券股份有限公司                     2\n",
       "太平洋证券股份有限公司                    2\n",
       "湘财证券股份有限公司                     2\n",
       "中国民族证券有限责任公司                   2\n",
       "华融证券股份有限公司                     2\n",
       "国都证券股份有限公司                     2\n",
       "国信证券股份有限公司,华英证券有限责任公司          1\n",
       "光大证券股份有限公司,华泰联合证券有限责任公司        1\n",
       "首创证券有限责任公司                     1\n",
       "海通证券股份有限公司,中国国际金融股份有限公司        1\n",
       "中国国际金融股份有限公司,中信证券股份有限公司        1\n",
       "长城证券股份有限公司,中信建投证券股份有限公司        1\n",
       "五矿证券有限公司,国泰君安证券股份有限公司          1\n",
       "华泰联合证券有限责任公司,中信建投证券股份有限公司      1\n",
       "海通证券股份有限公司,中航证券有限公司            1\n",
       "华泰联合证券有限责任公司,中国国际金融股份有限公司      1\n",
       "爱建证券有限责任公司                     1\n",
       "五矿证券有限公司,中信证券股份有限公司            1\n",
       "中国国际金融股份有限公司,中信建投证券股份有限公司      1\n",
       "中航证券有限公司,中信建投证券股份有限公司          1\n",
       "国泰君安证券股份有限公司,海通证券股份有限公司        1\n",
       "华菁证券有限公司,国泰君安证券股份有限公司          1\n",
       "中泰证券股份有限公司,红塔证券股份有限公司          1\n",
       "中山证券有限责任公司                     1\n",
       "中银国际证券股份有限公司,中国国际金融股份有限公司      1\n",
       "国盛证券有限责任公司                     1\n",
       "长城国瑞证券有限公司                     1\n",
       "中航证券有限公司,中信证券股份有限公司            1\n",
       "九州证券股份有限公司                     1\n",
       "国开证券股份有限公司                     1\n",
       "联储证券有限责任公司                     1\n",
       "中航证券有限公司                       1\n",
       "华泰联合证券有限责任公司,安信证券股份有限公司        1\n",
       "高盛高华证券有限责任公司,中国国际金融股份有限公司      1\n",
       "中国国际金融股份有限公司,民生证券股份有限公司        1\n",
       "红塔证券股份有限公司                     1"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stats_brokerage = stock_register_kcb_df[\"保荐机构\"].value_counts().rename_axis('保荐机构').to_frame('受理申报数')\n",
    "stats_brokerage"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "保荐机构\n",
       "中信证券股份有限公司                  10.49\n",
       "中信建投证券股份有限公司                 7.52\n",
       "华泰联合证券有限责任公司                 6.66\n",
       "海通证券股份有限公司                   6.27\n",
       "中国国际金融股份有限公司                 5.61\n",
       "民生证券股份有限公司                   5.41\n",
       "国泰君安证券股份有限公司                 5.21\n",
       "国金证券股份有限公司                   4.02\n",
       "国信证券股份有限公司                   3.83\n",
       "招商证券股份有限公司                   3.23\n",
       "安信证券股份有限公司                   3.03\n",
       "长江证券承销保荐有限公司                 2.70\n",
       "申万宏源证券承销保荐有限责任公司             2.24\n",
       "东兴证券股份有限公司                   2.24\n",
       "兴业证券股份有限公司                   1.91\n",
       "东吴证券股份有限公司                   1.85\n",
       "东方证券承销保荐有限公司                 1.78\n",
       "光大证券股份有限公司                   1.72\n",
       "中泰证券股份有限公司                   1.65\n",
       "国元证券股份有限公司                   1.45\n",
       "西部证券股份有限公司                   1.45\n",
       "东莞证券股份有限公司                   1.39\n",
       "浙商证券股份有限公司                   1.12\n",
       "中天国富证券有限公司                   1.06\n",
       "中原证券股份有限公司                   0.92\n",
       "广发证券股份有限公司                   0.86\n",
       "平安证券股份有限公司                   0.86\n",
       "长城证券股份有限公司                   0.79\n",
       "中国银河证券股份有限公司                 0.59\n",
       "华安证券股份有限公司                   0.59\n",
       "申港证券股份有限公司                   0.53\n",
       "财通证券股份有限公司                   0.46\n",
       "华西证券股份有限公司                   0.46\n",
       "华创证券有限责任公司                   0.46\n",
       "天风证券股份有限公司                   0.40\n",
       "第一创业证券承销保荐有限责任公司             0.40\n",
       "东北证券股份有限公司                   0.40\n",
       "五矿证券有限公司                     0.33\n",
       "万和证券股份有限公司                   0.33\n",
       "华林证券股份有限公司                   0.33\n",
       "东海证券股份有限公司                   0.33\n",
       "中德证券有限责任公司                   0.33\n",
       "德邦证券股份有限公司                   0.26\n",
       "信达证券股份有限公司                   0.26\n",
       "方正证券承销保荐有限责任公司               0.26\n",
       "华英证券有限责任公司                   0.26\n",
       "华金证券股份有限公司                   0.26\n",
       "南京证券股份有限公司                   0.26\n",
       "开源证券股份有限公司                   0.26\n",
       "华龙证券股份有限公司                   0.20\n",
       "国融证券股份有限公司                   0.20\n",
       "华兴证券有限公司                     0.20\n",
       "瑞信方正证券有限责任公司                 0.20\n",
       "渤海证券股份有限公司                   0.20\n",
       "瑞银证券有限责任公司                   0.20\n",
       "国海证券股份有限公司                   0.20\n",
       "英大证券有限责任公司                   0.20\n",
       "中银国际证券股份有限公司                 0.20\n",
       "华福证券有限责任公司                   0.13\n",
       "东方花旗证券有限公司                   0.13\n",
       "金元证券股份有限公司                   0.13\n",
       "西南证券股份有限公司                   0.13\n",
       "太平洋证券股份有限公司                  0.13\n",
       "湘财证券股份有限公司                   0.13\n",
       "中国民族证券有限责任公司                 0.13\n",
       "华融证券股份有限公司                   0.13\n",
       "国都证券股份有限公司                   0.13\n",
       "国信证券股份有限公司,华英证券有限责任公司        0.07\n",
       "光大证券股份有限公司,华泰联合证券有限责任公司      0.07\n",
       "首创证券有限责任公司                   0.07\n",
       "海通证券股份有限公司,中国国际金融股份有限公司      0.07\n",
       "中国国际金融股份有限公司,中信证券股份有限公司      0.07\n",
       "长城证券股份有限公司,中信建投证券股份有限公司      0.07\n",
       "五矿证券有限公司,国泰君安证券股份有限公司        0.07\n",
       "华泰联合证券有限责任公司,中信建投证券股份有限公司    0.07\n",
       "海通证券股份有限公司,中航证券有限公司          0.07\n",
       "华泰联合证券有限责任公司,中国国际金融股份有限公司    0.07\n",
       "爱建证券有限责任公司                   0.07\n",
       "五矿证券有限公司,中信证券股份有限公司          0.07\n",
       "中国国际金融股份有限公司,中信建投证券股份有限公司    0.07\n",
       "中航证券有限公司,中信建投证券股份有限公司        0.07\n",
       "国泰君安证券股份有限公司,海通证券股份有限公司      0.07\n",
       "华菁证券有限公司,国泰君安证券股份有限公司        0.07\n",
       "中泰证券股份有限公司,红塔证券股份有限公司        0.07\n",
       "中山证券有限责任公司                   0.07\n",
       "中银国际证券股份有限公司,中国国际金融股份有限公司    0.07\n",
       "国盛证券有限责任公司                   0.07\n",
       "长城国瑞证券有限公司                   0.07\n",
       "中航证券有限公司,中信证券股份有限公司          0.07\n",
       "九州证券股份有限公司                   0.07\n",
       "国开证券股份有限公司                   0.07\n",
       "联储证券有限责任公司                   0.07\n",
       "中航证券有限公司                     0.07\n",
       "华泰联合证券有限责任公司,安信证券股份有限公司      0.07\n",
       "高盛高华证券有限责任公司,中国国际金融股份有限公司    0.07\n",
       "中国国际金融股份有限公司,民生证券股份有限公司      0.07\n",
       "红塔证券股份有限公司                   0.07\n",
       "Name: 受理申报数, dtype: float64"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(stats_brokerage['受理申报数']/stats_brokerage['受理申报数'].sum())*100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "科创板    394\n",
       "创业板    284\n",
       "Name: 拟上市地点, dtype: int64"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stock_registered = stock_register_kcb_df[stock_register_kcb_df['审核状态'] == '注册生效']\n",
    "stock_registered['拟上市地点'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><div id=6d902676-b9db-484e-ae0c-73dee9df1080 style=\"display:none; background-color:#9D6CFF; color:white; width:200px; height:30px; padding-left:5px; border-radius:4px; flex-direction:row; justify-content:space-around; align-items:center;\" onmouseover=\"this.style.backgroundColor='#BA9BF8'\" onmouseout=\"this.style.backgroundColor='#9D6CFF'\" onclick=\"window.commands?.execute('create-mitosheet-from-dataframe-output');\">See Full Dataframe in Mito</div> <script> if (window.commands.hasCommand('create-mitosheet-from-dataframe-output')) document.getElementById('6d902676-b9db-484e-ae0c-73dee9df1080').style.display = 'flex' </script> <table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>注册生效数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>保荐机构</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>中信证券股份有限公司</th>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中信建投证券股份有限公司</th>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>海通证券股份有限公司</th>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华泰联合证券有限责任公司</th>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>民生证券股份有限公司</th>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国国际金融股份有限公司</th>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国泰君安证券股份有限公司</th>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国信证券股份有限公司</th>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国金证券股份有限公司</th>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>招商证券股份有限公司</th>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东兴证券股份有限公司</th>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>长江证券承销保荐有限公司</th>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>安信证券股份有限公司</th>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>兴业证券股份有限公司</th>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>申万宏源证券承销保荐有限责任公司</th>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国元证券股份有限公司</th>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东吴证券股份有限公司</th>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>光大证券股份有限公司</th>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东方证券承销保荐有限公司</th>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>西部证券股份有限公司</th>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>浙商证券股份有限公司</th>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东莞证券股份有限公司</th>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中泰证券股份有限公司</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中原证券股份有限公司</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广发证券股份有限公司</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>申港证券股份有限公司</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中天国富证券有限公司</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国银河证券股份有限公司</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华创证券有限责任公司</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>天风证券股份有限公司</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华林证券股份有限公司</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>长城证券股份有限公司</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>南京证券股份有限公司</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华安证券股份有限公司</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>平安证券股份有限公司</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国海证券股份有限公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华英证券有限责任公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东北证券股份有限公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>英大证券有限责任公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>五矿证券有限公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>信达证券股份有限公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华西证券股份有限公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>瑞银证券有限责任公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中德证券有限责任公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东方花旗证券有限公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>第一创业证券承销保荐有限责任公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国民族证券有限责任公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>太平洋证券股份有限公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>财通证券股份有限公司</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国国际金融股份有限公司,民生证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华龙证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>海通证券股份有限公司,中国国际金融股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>爱建证券有限责任公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中航证券有限公司,中信证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中山证券有限责任公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国国际金融股份有限公司,中信建投证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>高盛高华证券有限责任公司,中国国际金融股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华菁证券有限公司,国泰君安证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>五矿证券有限公司,中信证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华兴证券有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国融证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中航证券有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华泰联合证券有限责任公司,安信证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国泰君安证券股份有限公司,海通证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国都证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中泰证券股份有限公司,红塔证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>光大证券股份有限公司,华泰联合证券有限责任公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>首创证券有限责任公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>德邦证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华融证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>西南证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华泰联合证券有限责任公司,中信建投证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中银国际证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>渤海证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table></div>"
      ],
      "text/plain": [
       "                           注册生效数\n",
       "保荐机构                            \n",
       "中信证券股份有限公司                    73\n",
       "中信建投证券股份有限公司                  54\n",
       "海通证券股份有限公司                    47\n",
       "华泰联合证券有限责任公司                  43\n",
       "民生证券股份有限公司                    39\n",
       "中国国际金融股份有限公司                  37\n",
       "国泰君安证券股份有限公司                  29\n",
       "国信证券股份有限公司                    27\n",
       "国金证券股份有限公司                    26\n",
       "招商证券股份有限公司                    26\n",
       "东兴证券股份有限公司                    19\n",
       "长江证券承销保荐有限公司                  19\n",
       "安信证券股份有限公司                    19\n",
       "兴业证券股份有限公司                    15\n",
       "申万宏源证券承销保荐有限责任公司              13\n",
       "国元证券股份有限公司                    13\n",
       "东吴证券股份有限公司                    13\n",
       "光大证券股份有限公司                    12\n",
       "东方证券承销保荐有限公司                  12\n",
       "西部证券股份有限公司                    10\n",
       "浙商证券股份有限公司                    10\n",
       "东莞证券股份有限公司                    10\n",
       "中泰证券股份有限公司                     8\n",
       "中原证券股份有限公司                     7\n",
       "广发证券股份有限公司                     6\n",
       "申港证券股份有限公司                     6\n",
       "中天国富证券有限公司                     5\n",
       "中国银河证券股份有限公司                   5\n",
       "华创证券有限责任公司                     4\n",
       "天风证券股份有限公司                     3\n",
       "华林证券股份有限公司                     3\n",
       "长城证券股份有限公司                     3\n",
       "南京证券股份有限公司                     3\n",
       "华安证券股份有限公司                     3\n",
       "平安证券股份有限公司                     3\n",
       "国海证券股份有限公司                     2\n",
       "华英证券有限责任公司                     2\n",
       "东北证券股份有限公司                     2\n",
       "英大证券有限责任公司                     2\n",
       "五矿证券有限公司                       2\n",
       "信达证券股份有限公司                     2\n",
       "华西证券股份有限公司                     2\n",
       "瑞银证券有限责任公司                     2\n",
       "中德证券有限责任公司                     2\n",
       "东方花旗证券有限公司                     2\n",
       "第一创业证券承销保荐有限责任公司               2\n",
       "中国民族证券有限责任公司                   2\n",
       "太平洋证券股份有限公司                    2\n",
       "财通证券股份有限公司                     2\n",
       "中国国际金融股份有限公司,民生证券股份有限公司        1\n",
       "华龙证券股份有限公司                     1\n",
       "海通证券股份有限公司,中国国际金融股份有限公司        1\n",
       "爱建证券有限责任公司                     1\n",
       "中航证券有限公司,中信证券股份有限公司            1\n",
       "中山证券有限责任公司                     1\n",
       "中国国际金融股份有限公司,中信建投证券股份有限公司      1\n",
       "高盛高华证券有限责任公司,中国国际金融股份有限公司      1\n",
       "华菁证券有限公司,国泰君安证券股份有限公司          1\n",
       "五矿证券有限公司,中信证券股份有限公司            1\n",
       "华兴证券有限公司                       1\n",
       "国融证券股份有限公司                     1\n",
       "中航证券有限公司                       1\n",
       "华泰联合证券有限责任公司,安信证券股份有限公司        1\n",
       "国泰君安证券股份有限公司,海通证券股份有限公司        1\n",
       "国都证券股份有限公司                     1\n",
       "中泰证券股份有限公司,红塔证券股份有限公司          1\n",
       "光大证券股份有限公司,华泰联合证券有限责任公司        1\n",
       "首创证券有限责任公司                     1\n",
       "德邦证券股份有限公司                     1\n",
       "华融证券股份有限公司                     1\n",
       "西南证券股份有限公司                     1\n",
       "华泰联合证券有限责任公司,中信建投证券股份有限公司      1\n",
       "中银国际证券股份有限公司                   1\n",
       "渤海证券股份有限公司                     1"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stock_registered = stock_registered[\"保荐机构\"].value_counts().rename_axis('保荐机构').to_frame('注册生效数')\n",
    "stock_registered"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><div id=81627f36-a613-48b8-8f9d-25575a7b7035 style=\"display:none; background-color:#9D6CFF; color:white; width:200px; height:30px; padding-left:5px; border-radius:4px; flex-direction:row; justify-content:space-around; align-items:center;\" onmouseover=\"this.style.backgroundColor='#BA9BF8'\" onmouseout=\"this.style.backgroundColor='#9D6CFF'\" onclick=\"window.commands?.execute('create-mitosheet-from-dataframe-output');\">See Full Dataframe in Mito</div> <script> if (window.commands.hasCommand('create-mitosheet-from-dataframe-output')) document.getElementById('81627f36-a613-48b8-8f9d-25575a7b7035').style.display = 'flex' </script> <table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>受理申报数</th>\n",
       "      <th>注册生效数</th>\n",
       "      <th>通过率</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>保荐机构</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>中信证券股份有限公司</th>\n",
       "      <td>159</td>\n",
       "      <td>73.00</td>\n",
       "      <td>45.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中信建投证券股份有限公司</th>\n",
       "      <td>114</td>\n",
       "      <td>54.00</td>\n",
       "      <td>47.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华泰联合证券有限责任公司</th>\n",
       "      <td>101</td>\n",
       "      <td>43.00</td>\n",
       "      <td>42.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>海通证券股份有限公司</th>\n",
       "      <td>95</td>\n",
       "      <td>47.00</td>\n",
       "      <td>49.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国国际金融股份有限公司</th>\n",
       "      <td>85</td>\n",
       "      <td>37.00</td>\n",
       "      <td>43.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>民生证券股份有限公司</th>\n",
       "      <td>82</td>\n",
       "      <td>39.00</td>\n",
       "      <td>47.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国泰君安证券股份有限公司</th>\n",
       "      <td>79</td>\n",
       "      <td>29.00</td>\n",
       "      <td>36.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国金证券股份有限公司</th>\n",
       "      <td>61</td>\n",
       "      <td>26.00</td>\n",
       "      <td>42.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国信证券股份有限公司</th>\n",
       "      <td>58</td>\n",
       "      <td>27.00</td>\n",
       "      <td>46.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>招商证券股份有限公司</th>\n",
       "      <td>49</td>\n",
       "      <td>26.00</td>\n",
       "      <td>53.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>安信证券股份有限公司</th>\n",
       "      <td>46</td>\n",
       "      <td>19.00</td>\n",
       "      <td>41.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>长江证券承销保荐有限公司</th>\n",
       "      <td>41</td>\n",
       "      <td>19.00</td>\n",
       "      <td>46.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>申万宏源证券承销保荐有限责任公司</th>\n",
       "      <td>34</td>\n",
       "      <td>13.00</td>\n",
       "      <td>38.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东兴证券股份有限公司</th>\n",
       "      <td>34</td>\n",
       "      <td>19.00</td>\n",
       "      <td>55.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>兴业证券股份有限公司</th>\n",
       "      <td>29</td>\n",
       "      <td>15.00</td>\n",
       "      <td>51.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东吴证券股份有限公司</th>\n",
       "      <td>28</td>\n",
       "      <td>13.00</td>\n",
       "      <td>46.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东方证券承销保荐有限公司</th>\n",
       "      <td>27</td>\n",
       "      <td>12.00</td>\n",
       "      <td>44.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>光大证券股份有限公司</th>\n",
       "      <td>26</td>\n",
       "      <td>12.00</td>\n",
       "      <td>46.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中泰证券股份有限公司</th>\n",
       "      <td>25</td>\n",
       "      <td>8.00</td>\n",
       "      <td>32.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国元证券股份有限公司</th>\n",
       "      <td>22</td>\n",
       "      <td>13.00</td>\n",
       "      <td>59.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>西部证券股份有限公司</th>\n",
       "      <td>22</td>\n",
       "      <td>10.00</td>\n",
       "      <td>45.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东莞证券股份有限公司</th>\n",
       "      <td>21</td>\n",
       "      <td>10.00</td>\n",
       "      <td>47.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>浙商证券股份有限公司</th>\n",
       "      <td>17</td>\n",
       "      <td>10.00</td>\n",
       "      <td>58.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中天国富证券有限公司</th>\n",
       "      <td>16</td>\n",
       "      <td>5.00</td>\n",
       "      <td>31.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中原证券股份有限公司</th>\n",
       "      <td>14</td>\n",
       "      <td>7.00</td>\n",
       "      <td>50.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广发证券股份有限公司</th>\n",
       "      <td>13</td>\n",
       "      <td>6.00</td>\n",
       "      <td>46.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>平安证券股份有限公司</th>\n",
       "      <td>13</td>\n",
       "      <td>3.00</td>\n",
       "      <td>23.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>长城证券股份有限公司</th>\n",
       "      <td>12</td>\n",
       "      <td>3.00</td>\n",
       "      <td>25.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国银河证券股份有限公司</th>\n",
       "      <td>9</td>\n",
       "      <td>5.00</td>\n",
       "      <td>55.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华安证券股份有限公司</th>\n",
       "      <td>9</td>\n",
       "      <td>3.00</td>\n",
       "      <td>33.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>申港证券股份有限公司</th>\n",
       "      <td>8</td>\n",
       "      <td>6.00</td>\n",
       "      <td>75.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>财通证券股份有限公司</th>\n",
       "      <td>7</td>\n",
       "      <td>2.00</td>\n",
       "      <td>28.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华西证券股份有限公司</th>\n",
       "      <td>7</td>\n",
       "      <td>2.00</td>\n",
       "      <td>28.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华创证券有限责任公司</th>\n",
       "      <td>7</td>\n",
       "      <td>4.00</td>\n",
       "      <td>57.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>天风证券股份有限公司</th>\n",
       "      <td>6</td>\n",
       "      <td>3.00</td>\n",
       "      <td>50.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>第一创业证券承销保荐有限责任公司</th>\n",
       "      <td>6</td>\n",
       "      <td>2.00</td>\n",
       "      <td>33.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东北证券股份有限公司</th>\n",
       "      <td>6</td>\n",
       "      <td>2.00</td>\n",
       "      <td>33.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>五矿证券有限公司</th>\n",
       "      <td>5</td>\n",
       "      <td>2.00</td>\n",
       "      <td>40.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>万和证券股份有限公司</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华林证券股份有限公司</th>\n",
       "      <td>5</td>\n",
       "      <td>3.00</td>\n",
       "      <td>60.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东海证券股份有限公司</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中德证券有限责任公司</th>\n",
       "      <td>5</td>\n",
       "      <td>2.00</td>\n",
       "      <td>40.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>德邦证券股份有限公司</th>\n",
       "      <td>4</td>\n",
       "      <td>1.00</td>\n",
       "      <td>25.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>信达证券股份有限公司</th>\n",
       "      <td>4</td>\n",
       "      <td>2.00</td>\n",
       "      <td>50.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>方正证券承销保荐有限责任公司</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华英证券有限责任公司</th>\n",
       "      <td>4</td>\n",
       "      <td>2.00</td>\n",
       "      <td>50.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华金证券股份有限公司</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>南京证券股份有限公司</th>\n",
       "      <td>4</td>\n",
       "      <td>3.00</td>\n",
       "      <td>75.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>开源证券股份有限公司</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华龙证券股份有限公司</th>\n",
       "      <td>3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>33.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国融证券股份有限公司</th>\n",
       "      <td>3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>33.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华兴证券有限公司</th>\n",
       "      <td>3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>33.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>瑞信方正证券有限责任公司</th>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>渤海证券股份有限公司</th>\n",
       "      <td>3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>33.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>瑞银证券有限责任公司</th>\n",
       "      <td>3</td>\n",
       "      <td>2.00</td>\n",
       "      <td>66.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国海证券股份有限公司</th>\n",
       "      <td>3</td>\n",
       "      <td>2.00</td>\n",
       "      <td>66.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>英大证券有限责任公司</th>\n",
       "      <td>3</td>\n",
       "      <td>2.00</td>\n",
       "      <td>66.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中银国际证券股份有限公司</th>\n",
       "      <td>3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>33.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华福证券有限责任公司</th>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东方花旗证券有限公司</th>\n",
       "      <td>2</td>\n",
       "      <td>2.00</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>金元证券股份有限公司</th>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>西南证券股份有限公司</th>\n",
       "      <td>2</td>\n",
       "      <td>1.00</td>\n",
       "      <td>50.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>太平洋证券股份有限公司</th>\n",
       "      <td>2</td>\n",
       "      <td>2.00</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>湘财证券股份有限公司</th>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国民族证券有限责任公司</th>\n",
       "      <td>2</td>\n",
       "      <td>2.00</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华融证券股份有限公司</th>\n",
       "      <td>2</td>\n",
       "      <td>1.00</td>\n",
       "      <td>50.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国都证券股份有限公司</th>\n",
       "      <td>2</td>\n",
       "      <td>1.00</td>\n",
       "      <td>50.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国信证券股份有限公司,华英证券有限责任公司</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>光大证券股份有限公司,华泰联合证券有限责任公司</th>\n",
       "      <td>1</td>\n",
       "      <td>1.00</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>首创证券有限责任公司</th>\n",
       "      <td>1</td>\n",
       "      <td>1.00</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>海通证券股份有限公司,中国国际金融股份有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>1.00</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国国际金融股份有限公司,中信证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>长城证券股份有限公司,中信建投证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>五矿证券有限公司,国泰君安证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华泰联合证券有限责任公司,中信建投证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>1.00</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>海通证券股份有限公司,中航证券有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华泰联合证券有限责任公司,中国国际金融股份有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>爱建证券有限责任公司</th>\n",
       "      <td>1</td>\n",
       "      <td>1.00</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>五矿证券有限公司,中信证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>1.00</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国国际金融股份有限公司,中信建投证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>1.00</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中航证券有限公司,中信建投证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国泰君安证券股份有限公司,海通证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>1.00</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华菁证券有限公司,国泰君安证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>1.00</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中泰证券股份有限公司,红塔证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>1.00</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中山证券有限责任公司</th>\n",
       "      <td>1</td>\n",
       "      <td>1.00</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中银国际证券股份有限公司,中国国际金融股份有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国盛证券有限责任公司</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>长城国瑞证券有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中航证券有限公司,中信证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>1.00</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>九州证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国开证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>联储证券有限责任公司</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中航证券有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>1.00</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华泰联合证券有限责任公司,安信证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>1.00</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>高盛高华证券有限责任公司,中国国际金融股份有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>1.00</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国国际金融股份有限公司,民生证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>1.00</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>红塔证券股份有限公司</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table></div>"
      ],
      "text/plain": [
       "                           受理申报数  注册生效数    通过率\n",
       "保荐机构                                          \n",
       "中信证券股份有限公司                   159  73.00  45.91\n",
       "中信建投证券股份有限公司                 114  54.00  47.37\n",
       "华泰联合证券有限责任公司                 101  43.00  42.57\n",
       "海通证券股份有限公司                    95  47.00  49.47\n",
       "中国国际金融股份有限公司                  85  37.00  43.53\n",
       "民生证券股份有限公司                    82  39.00  47.56\n",
       "国泰君安证券股份有限公司                  79  29.00  36.71\n",
       "国金证券股份有限公司                    61  26.00  42.62\n",
       "国信证券股份有限公司                    58  27.00  46.55\n",
       "招商证券股份有限公司                    49  26.00  53.06\n",
       "安信证券股份有限公司                    46  19.00  41.30\n",
       "长江证券承销保荐有限公司                  41  19.00  46.34\n",
       "申万宏源证券承销保荐有限责任公司              34  13.00  38.24\n",
       "东兴证券股份有限公司                    34  19.00  55.88\n",
       "兴业证券股份有限公司                    29  15.00  51.72\n",
       "东吴证券股份有限公司                    28  13.00  46.43\n",
       "东方证券承销保荐有限公司                  27  12.00  44.44\n",
       "光大证券股份有限公司                    26  12.00  46.15\n",
       "中泰证券股份有限公司                    25   8.00  32.00\n",
       "国元证券股份有限公司                    22  13.00  59.09\n",
       "西部证券股份有限公司                    22  10.00  45.45\n",
       "东莞证券股份有限公司                    21  10.00  47.62\n",
       "浙商证券股份有限公司                    17  10.00  58.82\n",
       "中天国富证券有限公司                    16   5.00  31.25\n",
       "中原证券股份有限公司                    14   7.00  50.00\n",
       "广发证券股份有限公司                    13   6.00  46.15\n",
       "平安证券股份有限公司                    13   3.00  23.08\n",
       "长城证券股份有限公司                    12   3.00  25.00\n",
       "中国银河证券股份有限公司                   9   5.00  55.56\n",
       "华安证券股份有限公司                     9   3.00  33.33\n",
       "申港证券股份有限公司                     8   6.00  75.00\n",
       "财通证券股份有限公司                     7   2.00  28.57\n",
       "华西证券股份有限公司                     7   2.00  28.57\n",
       "华创证券有限责任公司                     7   4.00  57.14\n",
       "天风证券股份有限公司                     6   3.00  50.00\n",
       "第一创业证券承销保荐有限责任公司               6   2.00  33.33\n",
       "东北证券股份有限公司                     6   2.00  33.33\n",
       "五矿证券有限公司                       5   2.00  40.00\n",
       "万和证券股份有限公司                     5    NaN    NaN\n",
       "华林证券股份有限公司                     5   3.00  60.00\n",
       "东海证券股份有限公司                     5    NaN    NaN\n",
       "中德证券有限责任公司                     5   2.00  40.00\n",
       "德邦证券股份有限公司                     4   1.00  25.00\n",
       "信达证券股份有限公司                     4   2.00  50.00\n",
       "方正证券承销保荐有限责任公司                 4    NaN    NaN\n",
       "华英证券有限责任公司                     4   2.00  50.00\n",
       "华金证券股份有限公司                     4    NaN    NaN\n",
       "南京证券股份有限公司                     4   3.00  75.00\n",
       "开源证券股份有限公司                     4    NaN    NaN\n",
       "华龙证券股份有限公司                     3   1.00  33.33\n",
       "国融证券股份有限公司                     3   1.00  33.33\n",
       "华兴证券有限公司                       3   1.00  33.33\n",
       "瑞信方正证券有限责任公司                   3    NaN    NaN\n",
       "渤海证券股份有限公司                     3   1.00  33.33\n",
       "瑞银证券有限责任公司                     3   2.00  66.67\n",
       "国海证券股份有限公司                     3   2.00  66.67\n",
       "英大证券有限责任公司                     3   2.00  66.67\n",
       "中银国际证券股份有限公司                   3   1.00  33.33\n",
       "华福证券有限责任公司                     2    NaN    NaN\n",
       "东方花旗证券有限公司                     2   2.00 100.00\n",
       "金元证券股份有限公司                     2    NaN    NaN\n",
       "西南证券股份有限公司                     2   1.00  50.00\n",
       "太平洋证券股份有限公司                    2   2.00 100.00\n",
       "湘财证券股份有限公司                     2    NaN    NaN\n",
       "中国民族证券有限责任公司                   2   2.00 100.00\n",
       "华融证券股份有限公司                     2   1.00  50.00\n",
       "国都证券股份有限公司                     2   1.00  50.00\n",
       "国信证券股份有限公司,华英证券有限责任公司          1    NaN    NaN\n",
       "光大证券股份有限公司,华泰联合证券有限责任公司        1   1.00 100.00\n",
       "首创证券有限责任公司                     1   1.00 100.00\n",
       "海通证券股份有限公司,中国国际金融股份有限公司        1   1.00 100.00\n",
       "中国国际金融股份有限公司,中信证券股份有限公司        1    NaN    NaN\n",
       "长城证券股份有限公司,中信建投证券股份有限公司        1    NaN    NaN\n",
       "五矿证券有限公司,国泰君安证券股份有限公司          1    NaN    NaN\n",
       "华泰联合证券有限责任公司,中信建投证券股份有限公司      1   1.00 100.00\n",
       "海通证券股份有限公司,中航证券有限公司            1    NaN    NaN\n",
       "华泰联合证券有限责任公司,中国国际金融股份有限公司      1    NaN    NaN\n",
       "爱建证券有限责任公司                     1   1.00 100.00\n",
       "五矿证券有限公司,中信证券股份有限公司            1   1.00 100.00\n",
       "中国国际金融股份有限公司,中信建投证券股份有限公司      1   1.00 100.00\n",
       "中航证券有限公司,中信建投证券股份有限公司          1    NaN    NaN\n",
       "国泰君安证券股份有限公司,海通证券股份有限公司        1   1.00 100.00\n",
       "华菁证券有限公司,国泰君安证券股份有限公司          1   1.00 100.00\n",
       "中泰证券股份有限公司,红塔证券股份有限公司          1   1.00 100.00\n",
       "中山证券有限责任公司                     1   1.00 100.00\n",
       "中银国际证券股份有限公司,中国国际金融股份有限公司      1    NaN    NaN\n",
       "国盛证券有限责任公司                     1    NaN    NaN\n",
       "长城国瑞证券有限公司                     1    NaN    NaN\n",
       "中航证券有限公司,中信证券股份有限公司            1   1.00 100.00\n",
       "九州证券股份有限公司                     1    NaN    NaN\n",
       "国开证券股份有限公司                     1    NaN    NaN\n",
       "联储证券有限责任公司                     1    NaN    NaN\n",
       "中航证券有限公司                       1   1.00 100.00\n",
       "华泰联合证券有限责任公司,安信证券股份有限公司        1   1.00 100.00\n",
       "高盛高华证券有限责任公司,中国国际金融股份有限公司      1   1.00 100.00\n",
       "中国国际金融股份有限公司,民生证券股份有限公司        1   1.00 100.00\n",
       "红塔证券股份有限公司                     1    NaN    NaN"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "applied_to_registered = pd.concat([stats_brokerage,stock_registered], axis=1)\n",
    "applied_to_registered['通过率'] = applied_to_registered['注册生效数'].div(applied_to_registered['受理申报数']) * 100\n",
    "applied_to_registered"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 国泰君安证券股份有限公司"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><div id=ce3ecdef-b363-4410-85c1-f0c722260b69 style=\"display:none; background-color:#9D6CFF; color:white; width:200px; height:30px; padding-left:5px; border-radius:4px; flex-direction:row; justify-content:space-around; align-items:center;\" onmouseover=\"this.style.backgroundColor='#BA9BF8'\" onmouseout=\"this.style.backgroundColor='#9D6CFF'\" onclick=\"window.commands?.execute('create-mitosheet-from-dataframe-output');\">See Full Dataframe in Mito</div> <script> if (window.commands.hasCommand('create-mitosheet-from-dataframe-output')) document.getElementById('ce3ecdef-b363-4410-85c1-f0c722260b69').style.display = 'flex' </script> <table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>序号</th>\n",
       "      <th>发行人全称</th>\n",
       "      <th>审核状态</th>\n",
       "      <th>注册地</th>\n",
       "      <th>证监会行业</th>\n",
       "      <th>保荐机构</th>\n",
       "      <th>律师事务所</th>\n",
       "      <th>会计师事务所</th>\n",
       "      <th>更新日期</th>\n",
       "      <th>受理日期</th>\n",
       "      <th>拟上市地点</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>196</td>\n",
       "      <td>上海仁会生物制药股份有限公司</td>\n",
       "      <td>终止注册</td>\n",
       "      <td>上海</td>\n",
       "      <td>医药制造业</td>\n",
       "      <td>国泰君安证券股份有限公司</td>\n",
       "      <td>国浩律师(上海)事务所</td>\n",
       "      <td>天健会计师事务所(特殊普通合伙)</td>\n",
       "      <td>2021-10-14 00:00:00</td>\n",
       "      <td>2020-02-14 00:00:00</td>\n",
       "      <td>科创板</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>213</td>\n",
       "      <td>上海海和药物研究开发股份有限公司</td>\n",
       "      <td>终止</td>\n",
       "      <td>上海</td>\n",
       "      <td>医药制造业</td>\n",
       "      <td>国泰君安证券股份有限公司</td>\n",
       "      <td>北京市君合律师事务所</td>\n",
       "      <td>安永华明会计师事务所(特殊普通合伙)</td>\n",
       "      <td>2021-09-22 00:00:00</td>\n",
       "      <td>2021-02-03 00:00:00</td>\n",
       "      <td>科创板</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>268</th>\n",
       "      <td>269</td>\n",
       "      <td>依图科技有限公司</td>\n",
       "      <td>终止</td>\n",
       "      <td>境外</td>\n",
       "      <td>软件和信息技术服务业</td>\n",
       "      <td>国泰君安证券股份有限公司</td>\n",
       "      <td>北京市金杜律师事务所</td>\n",
       "      <td>天健会计师事务所(特殊普通合伙)</td>\n",
       "      <td>2021-06-30 00:00:00</td>\n",
       "      <td>2020-11-04 00:00:00</td>\n",
       "      <td>科创板</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269</th>\n",
       "      <td>270</td>\n",
       "      <td>北京乐普诊断科技股份有限公司</td>\n",
       "      <td>终止</td>\n",
       "      <td>北京</td>\n",
       "      <td>医药制造业</td>\n",
       "      <td>国泰君安证券股份有限公司</td>\n",
       "      <td>北京市中伦律师事务所</td>\n",
       "      <td>立信会计师事务所(特殊普通合伙)</td>\n",
       "      <td>2021-06-25 00:00:00</td>\n",
       "      <td>2020-12-01 00:00:00</td>\n",
       "      <td>科创板</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>295</td>\n",
       "      <td>苏州瑞博生物技术股份有限公司</td>\n",
       "      <td>终止</td>\n",
       "      <td>江苏</td>\n",
       "      <td>医药制造业</td>\n",
       "      <td>国泰君安证券股份有限公司</td>\n",
       "      <td>北京市中伦律师事务所</td>\n",
       "      <td>安永华明会计师事务所(特殊普通合伙)</td>\n",
       "      <td>2021-05-21 00:00:00</td>\n",
       "      <td>2020-12-29 00:00:00</td>\n",
       "      <td>科创板</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>345</th>\n",
       "      <td>346</td>\n",
       "      <td>福建汇川物联网技术科技股份有限公司</td>\n",
       "      <td>终止</td>\n",
       "      <td>福建</td>\n",
       "      <td>软件和信息技术服务业</td>\n",
       "      <td>国泰君安证券股份有限公司</td>\n",
       "      <td>北京市金杜律师事务所</td>\n",
       "      <td>容诚会计师事务所(特殊普通合伙)</td>\n",
       "      <td>2021-03-18 00:00:00</td>\n",
       "      <td>2020-06-24 00:00:00</td>\n",
       "      <td>科创板</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>394</th>\n",
       "      <td>395</td>\n",
       "      <td>浙江光华科技股份有限公司</td>\n",
       "      <td>终止</td>\n",
       "      <td>浙江</td>\n",
       "      <td>化学原料和化学制品制造业</td>\n",
       "      <td>国泰君安证券股份有限公司</td>\n",
       "      <td>国浩律师(杭州)事务所</td>\n",
       "      <td>天健会计师事务所(特殊普通合伙)</td>\n",
       "      <td>2021-01-25 00:00:00</td>\n",
       "      <td>2020-05-26 00:00:00</td>\n",
       "      <td>科创板</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>409</th>\n",
       "      <td>410</td>\n",
       "      <td>苏州康代智能科技股份有限公司</td>\n",
       "      <td>终止</td>\n",
       "      <td>江苏</td>\n",
       "      <td>仪器仪表制造业</td>\n",
       "      <td>国泰君安证券股份有限公司</td>\n",
       "      <td>上海市锦天城律师事务所</td>\n",
       "      <td>毕马威华振会计师事务所(特殊普通合伙)</td>\n",
       "      <td>2020-12-30 00:00:00</td>\n",
       "      <td>2020-06-29 00:00:00</td>\n",
       "      <td>科创板</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419</th>\n",
       "      <td>420</td>\n",
       "      <td>云南北方奥雷德光电科技股份有限公司</td>\n",
       "      <td>终止</td>\n",
       "      <td>云南</td>\n",
       "      <td>计算机、通信和其他电子设备制造业</td>\n",
       "      <td>国泰君安证券股份有限公司</td>\n",
       "      <td>北京市嘉源律师事务所</td>\n",
       "      <td>信永中和会计师事务所(特殊普通合伙)</td>\n",
       "      <td>2020-12-23 00:00:00</td>\n",
       "      <td>2020-03-30 00:00:00</td>\n",
       "      <td>科创板</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>432</th>\n",
       "      <td>433</td>\n",
       "      <td>泰州亿腾景昂药业股份有限公司</td>\n",
       "      <td>终止</td>\n",
       "      <td>江苏</td>\n",
       "      <td>医药制造业</td>\n",
       "      <td>国泰君安证券股份有限公司</td>\n",
       "      <td>北京市君合律师事务所</td>\n",
       "      <td>立信会计师事务所(特殊普通合伙)</td>\n",
       "      <td>2020-12-03 00:00:00</td>\n",
       "      <td>2020-06-23 00:00:00</td>\n",
       "      <td>科创板</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>720</th>\n",
       "      <td>36</td>\n",
       "      <td>力同科技股份有限公司</td>\n",
       "      <td>终止注册</td>\n",
       "      <td>广东</td>\n",
       "      <td>计算机、通信和其他电子设备制造业</td>\n",
       "      <td>国泰君安证券股份有限公司</td>\n",
       "      <td>北京德恒律师事务所</td>\n",
       "      <td>大信会计师事务所(特殊普通合伙)</td>\n",
       "      <td>2022-01-07 00:00:00</td>\n",
       "      <td>2020-07-06 00:00:00</td>\n",
       "      <td>创业板</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1399</th>\n",
       "      <td>715</td>\n",
       "      <td>深圳市澳华集团股份有限公司</td>\n",
       "      <td>撤回</td>\n",
       "      <td>广东</td>\n",
       "      <td>农副食品加工业</td>\n",
       "      <td>国泰君安证券股份有限公司</td>\n",
       "      <td>广东华商律师事务所</td>\n",
       "      <td>华兴会计师事务所(特殊普通合伙)</td>\n",
       "      <td>2021-02-01 00:00:00</td>\n",
       "      <td>2020-07-29 00:00:00</td>\n",
       "      <td>创业板</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1401</th>\n",
       "      <td>717</td>\n",
       "      <td>徐辉设计股份有限公司</td>\n",
       "      <td>撤回</td>\n",
       "      <td>河南</td>\n",
       "      <td>专业技术服务业</td>\n",
       "      <td>国泰君安证券股份有限公司</td>\n",
       "      <td>上海澄明则正律师事务所</td>\n",
       "      <td>立信会计师事务所(特殊普通合伙)</td>\n",
       "      <td>2021-01-27 00:00:00</td>\n",
       "      <td>2020-07-06 00:00:00</td>\n",
       "      <td>创业板</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1456</th>\n",
       "      <td>772</td>\n",
       "      <td>成都武侯高新技术产业发展股份有限公司</td>\n",
       "      <td>撤回</td>\n",
       "      <td>四川</td>\n",
       "      <td>商务服务业</td>\n",
       "      <td>国泰君安证券股份有限公司</td>\n",
       "      <td>北京市重光律师事务所</td>\n",
       "      <td>天健会计师事务所(特殊普通合伙)</td>\n",
       "      <td>2020-11-12 00:00:00</td>\n",
       "      <td>2020-07-06 00:00:00</td>\n",
       "      <td>创业板</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table></div>"
      ],
      "text/plain": [
       "       序号               发行人全称  审核状态 注册地             证监会行业          保荐机构        律师事务所               会计师事务所                 更新日期                 受理日期 拟上市地点\n",
       "195   196      上海仁会生物制药股份有限公司  终止注册  上海             医药制造业  国泰君安证券股份有限公司  国浩律师(上海)事务所     天健会计师事务所(特殊普通合伙)  2021-10-14 00:00:00  2020-02-14 00:00:00   科创板\n",
       "212   213    上海海和药物研究开发股份有限公司    终止  上海             医药制造业  国泰君安证券股份有限公司   北京市君合律师事务所   安永华明会计师事务所(特殊普通合伙)  2021-09-22 00:00:00  2021-02-03 00:00:00   科创板\n",
       "268   269            依图科技有限公司    终止  境外        软件和信息技术服务业  国泰君安证券股份有限公司   北京市金杜律师事务所     天健会计师事务所(特殊普通合伙)  2021-06-30 00:00:00  2020-11-04 00:00:00   科创板\n",
       "269   270      北京乐普诊断科技股份有限公司    终止  北京             医药制造业  国泰君安证券股份有限公司   北京市中伦律师事务所     立信会计师事务所(特殊普通合伙)  2021-06-25 00:00:00  2020-12-01 00:00:00   科创板\n",
       "294   295      苏州瑞博生物技术股份有限公司    终止  江苏             医药制造业  国泰君安证券股份有限公司   北京市中伦律师事务所   安永华明会计师事务所(特殊普通合伙)  2021-05-21 00:00:00  2020-12-29 00:00:00   科创板\n",
       "345   346   福建汇川物联网技术科技股份有限公司    终止  福建        软件和信息技术服务业  国泰君安证券股份有限公司   北京市金杜律师事务所     容诚会计师事务所(特殊普通合伙)  2021-03-18 00:00:00  2020-06-24 00:00:00   科创板\n",
       "394   395        浙江光华科技股份有限公司    终止  浙江      化学原料和化学制品制造业  国泰君安证券股份有限公司  国浩律师(杭州)事务所     天健会计师事务所(特殊普通合伙)  2021-01-25 00:00:00  2020-05-26 00:00:00   科创板\n",
       "409   410      苏州康代智能科技股份有限公司    终止  江苏           仪器仪表制造业  国泰君安证券股份有限公司  上海市锦天城律师事务所  毕马威华振会计师事务所(特殊普通合伙)  2020-12-30 00:00:00  2020-06-29 00:00:00   科创板\n",
       "419   420   云南北方奥雷德光电科技股份有限公司    终止  云南  计算机、通信和其他电子设备制造业  国泰君安证券股份有限公司   北京市嘉源律师事务所   信永中和会计师事务所(特殊普通合伙)  2020-12-23 00:00:00  2020-03-30 00:00:00   科创板\n",
       "432   433      泰州亿腾景昂药业股份有限公司    终止  江苏             医药制造业  国泰君安证券股份有限公司   北京市君合律师事务所     立信会计师事务所(特殊普通合伙)  2020-12-03 00:00:00  2020-06-23 00:00:00   科创板\n",
       "720    36          力同科技股份有限公司  终止注册  广东  计算机、通信和其他电子设备制造业  国泰君安证券股份有限公司    北京德恒律师事务所     大信会计师事务所(特殊普通合伙)  2022-01-07 00:00:00  2020-07-06 00:00:00   创业板\n",
       "1399  715       深圳市澳华集团股份有限公司    撤回  广东           农副食品加工业  国泰君安证券股份有限公司    广东华商律师事务所     华兴会计师事务所(特殊普通合伙)  2021-02-01 00:00:00  2020-07-29 00:00:00   创业板\n",
       "1401  717          徐辉设计股份有限公司    撤回  河南           专业技术服务业  国泰君安证券股份有限公司  上海澄明则正律师事务所     立信会计师事务所(特殊普通合伙)  2021-01-27 00:00:00  2020-07-06 00:00:00   创业板\n",
       "1456  772  成都武侯高新技术产业发展股份有限公司    撤回  四川             商务服务业  国泰君安证券股份有限公司   北京市重光律师事务所     天健会计师事务所(特殊普通合伙)  2020-11-12 00:00:00  2020-07-06 00:00:00   创业板"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "specific_stock = stock_register_kcb_df[(stock_register_kcb_df['保荐机构'] =='国泰君安证券股份有限公司')]\n",
    "specific_stock_terminated = specific_stock[(specific_stock['审核状态'].str.contains('终止')) | (specific_stock['审核状态'] =='撤回')]\n",
    "specific_stock_terminated"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "国泰君安证券股份有限公司    14\n",
       "Name: 保荐机构, dtype: int64"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 终止注册或撤回数量\n",
    "term_counts = specific_stock_terminated[\"保荐机构\"].value_counts()\n",
    "term_counts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "国泰君安证券股份有限公司    79\n",
       "Name: 保荐机构, dtype: int64"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#总承销数量\n",
    "total_counts = specific_stock[\"保荐机构\"].value_counts()\n",
    "total_counts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "国泰君安证券股份有限公司   0.18\n",
       "Name: 保荐机构, dtype: float64"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "term_counts / total_counts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}