analysis/退市转债分析.ipynb

{
 "metadata": {
  "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.3-final"
  },
  "orig_nbformat": 2,
  "kernelspec": {
   "name": "python3",
   "display_name": "Python 3.8.3 64-bit (conda)",
   "metadata": {
    "interpreter": {
     "hash": "513dc2e41d739bb2c947903f3c0bbf636d03aa53ab50e61c694a27481c81805e"
    }
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2,
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "file=r'C:\\OneDrive\\Stock\\截止2021-04-02日为止的退市转债.xlsx'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_excel(file)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "167"
      ]
     },
     "metadata": {},
     "execution_count": 4
    }
   ],
   "source": [
    "len(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "     转债代码   转债名称   最后交易价格    正股代码   正股名称  发行规模(亿元)  回售规模(亿元)  剩余规模(亿元)  \\\n",
       "0  128012   辉丰转债   99.999    2496  *ST辉丰     8.450     8.203     0.240   \n",
       "1  113038  隆20转债  166.130  601012   隆基股份    50.000     0.000     0.235   \n",
       "2  128052   凯龙转债  148.295    2783   凯龙股份     3.289     0.000     0.311   \n",
       "3  113029   明阳转债  141.360  601615   明阳智能    17.000     0.000     0.051   \n",
       "4  113590   海容转债  156.190  603187   海容冷链     5.000     0.000     0.029   \n",
       "\n",
       "        发行日期      最后交易日       到期日期  存续年限   退市原因  \n",
       "0 2016-04-21 2022-04-21 2022-04-21   6.0  低于3千万  \n",
       "1 2020-07-31 2021-03-30 2026-07-30   0.7     强赎  \n",
       "2 2018-12-21 2021-03-23 2024-12-21   2.3     强赎  \n",
       "3 2019-12-16 2021-03-18 2025-12-15   1.3     强赎  \n",
       "4 2020-06-29 2021-03-05 2026-06-29   0.7     强赎  "
      ],
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>转债代码</th>\n      <th>转债名称</th>\n      <th>最后交易价格</th>\n      <th>正股代码</th>\n      <th>正股名称</th>\n      <th>发行规模(亿元)</th>\n      <th>回售规模(亿元)</th>\n      <th>剩余规模(亿元)</th>\n      <th>发行日期</th>\n      <th>最后交易日</th>\n      <th>到期日期</th>\n      <th>存续年限</th>\n      <th>退市原因</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>128012</td>\n      <td>辉丰转债</td>\n      <td>99.999</td>\n      <td>2496</td>\n      <td>*ST辉丰</td>\n      <td>8.450</td>\n      <td>8.203</td>\n      <td>0.240</td>\n      <td>2016-04-21</td>\n      <td>2022-04-21</td>\n      <td>2022-04-21</td>\n      <td>6.0</td>\n      <td>低于3千万</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>113038</td>\n      <td>隆20转债</td>\n      <td>166.130</td>\n      <td>601012</td>\n      <td>隆基股份</td>\n      <td>50.000</td>\n      <td>0.000</td>\n      <td>0.235</td>\n      <td>2020-07-31</td>\n      <td>2021-03-30</td>\n      <td>2026-07-30</td>\n      <td>0.7</td>\n      <td>强赎</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>128052</td>\n      <td>凯龙转债</td>\n      <td>148.295</td>\n      <td>2783</td>\n      <td>凯龙股份</td>\n      <td>3.289</td>\n      <td>0.000</td>\n      <td>0.311</td>\n      <td>2018-12-21</td>\n      <td>2021-03-23</td>\n      <td>2024-12-21</td>\n      <td>2.3</td>\n      <td>强赎</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>113029</td>\n      <td>明阳转债</td>\n      <td>141.360</td>\n      <td>601615</td>\n      <td>明阳智能</td>\n      <td>17.000</td>\n      <td>0.000</td>\n      <td>0.051</td>\n      <td>2019-12-16</td>\n      <td>2021-03-18</td>\n      <td>2025-12-15</td>\n      <td>1.3</td>\n      <td>强赎</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>113590</td>\n      <td>海容转债</td>\n      <td>156.190</td>\n      <td>603187</td>\n      <td>海容冷链</td>\n      <td>5.000</td>\n      <td>0.000</td>\n      <td>0.029</td>\n      <td>2020-06-29</td>\n      <td>2021-03-05</td>\n      <td>2026-06-29</td>\n      <td>0.7</td>\n      <td>强赎</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "metadata": {},
     "execution_count": 5
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\nRangeIndex: 167 entries, 0 to 166\nData columns (total 13 columns):\n #   Column    Non-Null Count  Dtype         \n---  ------    --------------  -----         \n 0   转债代码      167 non-null    int64         \n 1   转债名称      167 non-null    object        \n 2   最后交易价格    167 non-null    float64       \n 3   正股代码      167 non-null    int64         \n 4   正股名称      167 non-null    object        \n 5   发行规模(亿元)  167 non-null    float64       \n 6   回售规模(亿元)  167 non-null    float64       \n 7   剩余规模(亿元)  167 non-null    float64       \n 8   发行日期      167 non-null    datetime64[ns]\n 9   最后交易日     167 non-null    datetime64[ns]\n 10  到期日期      167 non-null    datetime64[ns]\n 11  存续年限      167 non-null    float64       \n 12  退市原因      167 non-null    object        \ndtypes: datetime64[ns](3), float64(5), int64(2), object(3)\nmemory usage: 17.1+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "强赎         151\n",
       "到期           9\n",
       "不足3000万      4\n",
       "不足2000万      2\n",
       "低于3千万        1\n",
       "Name: 退市原因, dtype: int64"
      ]
     },
     "metadata": {},
     "execution_count": 7
    }
   ],
   "source": [
    "df['退市原因'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "df=df[~df['转债名称'].str.endswith('EB')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "159"
      ]
     },
     "metadata": {},
     "execution_count": 11
    }
   ],
   "source": [
    "len(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "强赎         150\n",
       "不足3000万      4\n",
       "到期           4\n",
       "低于3千万        1\n",
       "Name: 退市原因, dtype: int64"
      ]
     },
     "metadata": {},
     "execution_count": 12
    }
   ],
   "source": [
    "df['退市原因'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "count    159.000000\n",
       "mean       1.672956\n",
       "std        1.221365\n",
       "min        0.600000\n",
       "25%        0.700000\n",
       "50%        1.300000\n",
       "75%        2.150000\n",
       "max        6.000000\n",
       "Name: 存续年限, dtype: float64"
      ]
     },
     "metadata": {},
     "execution_count": 14
    }
   ],
   "source": [
    "df['存续年限'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "      转债代码  转债名称   最后交易价格    正股代码   正股名称  发行规模(亿元)  回售规模(亿元)  剩余规模(亿元)  \\\n",
       "0   128012  辉丰转债   99.999    2496  *ST辉丰      8.45     8.203     0.240   \n",
       "20  113008  电气转债  106.480  601727   上海电气     60.00     0.000    13.422   \n",
       "\n",
       "         发行日期      最后交易日       到期日期  存续年限   退市原因  \n",
       "0  2016-04-21 2022-04-21 2022-04-21   6.0  低于3千万  \n",
       "20 2015-02-02 2021-01-18 2021-02-02   6.0     到期  "
      ],
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>转债代码</th>\n      <th>转债名称</th>\n      <th>最后交易价格</th>\n      <th>正股代码</th>\n      <th>正股名称</th>\n      <th>发行规模(亿元)</th>\n      <th>回售规模(亿元)</th>\n      <th>剩余规模(亿元)</th>\n      <th>发行日期</th>\n      <th>最后交易日</th>\n      <th>到期日期</th>\n      <th>存续年限</th>\n      <th>退市原因</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>128012</td>\n      <td>辉丰转债</td>\n      <td>99.999</td>\n      <td>2496</td>\n      <td>*ST辉丰</td>\n      <td>8.45</td>\n      <td>8.203</td>\n      <td>0.240</td>\n      <td>2016-04-21</td>\n      <td>2022-04-21</td>\n      <td>2022-04-21</td>\n      <td>6.0</td>\n      <td>低于3千万</td>\n    </tr>\n    <tr>\n      <th>20</th>\n      <td>113008</td>\n      <td>电气转债</td>\n      <td>106.480</td>\n      <td>601727</td>\n      <td>上海电气</td>\n      <td>60.00</td>\n      <td>0.000</td>\n      <td>13.422</td>\n      <td>2015-02-02</td>\n      <td>2021-01-18</td>\n      <td>2021-02-02</td>\n      <td>6.0</td>\n      <td>到期</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "metadata": {},
     "execution_count": 15
    }
   ],
   "source": [
    "df[df['存续年限']==6]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "0.9433962264150944"
      ]
     },
     "metadata": {},
     "execution_count": 16
    }
   ],
   "source": [
    "150/159"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "0.031446540880503145"
      ]
     },
     "metadata": {},
     "execution_count": 17
    }
   ],
   "source": [
    "5/159"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "0.025157232704402517"
      ]
     },
     "metadata": {},
     "execution_count": 18
    }
   ],
   "source": [
    "4/159"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "       转债代码  转债名称   最后交易价格    正股代码   正股名称  发行规模(亿元)  回售规模(亿元)  剩余规模(亿元)  \\\n",
       "0    128012  辉丰转债   99.999    2496  *ST辉丰      8.45     8.203     0.240   \n",
       "92   128060  中装转债  166.600    2822   中装建设      5.25     0.000     0.037   \n",
       "101  113507  天马转债  123.290  603668   天马科技      3.05     0.000     0.030   \n",
       "119  113010  江南转债  100.590  601199   江南水务      7.60     7.359     0.241   \n",
       "166  110009  双良转债   93.820  600481   双良节能      7.20     6.938     0.261   \n",
       "\n",
       "          发行日期      最后交易日       到期日期  存续年限     退市原因  \n",
       "0   2016-04-21 2022-04-21 2022-04-21   6.0    低于3千万  \n",
       "92  2019-03-26 2020-02-12 2025-03-26   0.9  不足3000万  \n",
       "101 2018-04-17 2019-11-04 2024-04-17   1.6  不足3000万  \n",
       "119 2016-03-18 2019-01-29 2022-03-18   2.9  不足3000万  \n",
       "166 2010-05-04 2011-12-14 2015-05-04   1.6  不足3000万  "
      ],
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>转债代码</th>\n      <th>转债名称</th>\n      <th>最后交易价格</th>\n      <th>正股代码</th>\n      <th>正股名称</th>\n      <th>发行规模(亿元)</th>\n      <th>回售规模(亿元)</th>\n      <th>剩余规模(亿元)</th>\n      <th>发行日期</th>\n      <th>最后交易日</th>\n      <th>到期日期</th>\n      <th>存续年限</th>\n      <th>退市原因</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>128012</td>\n      <td>辉丰转债</td>\n      <td>99.999</td>\n      <td>2496</td>\n      <td>*ST辉丰</td>\n      <td>8.45</td>\n      <td>8.203</td>\n      <td>0.240</td>\n      <td>2016-04-21</td>\n      <td>2022-04-21</td>\n      <td>2022-04-21</td>\n      <td>6.0</td>\n      <td>低于3千万</td>\n    </tr>\n    <tr>\n      <th>92</th>\n      <td>128060</td>\n      <td>中装转债</td>\n      <td>166.600</td>\n      <td>2822</td>\n      <td>中装建设</td>\n      <td>5.25</td>\n      <td>0.000</td>\n      <td>0.037</td>\n      <td>2019-03-26</td>\n      <td>2020-02-12</td>\n      <td>2025-03-26</td>\n      <td>0.9</td>\n      <td>不足3000万</td>\n    </tr>\n    <tr>\n      <th>101</th>\n      <td>113507</td>\n      <td>天马转债</td>\n      <td>123.290</td>\n      <td>603668</td>\n      <td>天马科技</td>\n      <td>3.05</td>\n      <td>0.000</td>\n      <td>0.030</td>\n      <td>2018-04-17</td>\n      <td>2019-11-04</td>\n      <td>2024-04-17</td>\n      <td>1.6</td>\n      <td>不足3000万</td>\n    </tr>\n    <tr>\n      <th>119</th>\n      <td>113010</td>\n      <td>江南转债</td>\n      <td>100.590</td>\n      <td>601199</td>\n      <td>江南水务</td>\n      <td>7.60</td>\n      <td>7.359</td>\n      <td>0.241</td>\n      <td>2016-03-18</td>\n      <td>2019-01-29</td>\n      <td>2022-03-18</td>\n      <td>2.9</td>\n      <td>不足3000万</td>\n    </tr>\n    <tr>\n      <th>166</th>\n      <td>110009</td>\n      <td>双良转债</td>\n      <td>93.820</td>\n      <td>600481</td>\n      <td>双良节能</td>\n      <td>7.20</td>\n      <td>6.938</td>\n      <td>0.261</td>\n      <td>2010-05-04</td>\n      <td>2011-12-14</td>\n      <td>2015-05-04</td>\n      <td>1.6</td>\n      <td>不足3000万</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "metadata": {},
     "execution_count": 20
    }
   ],
   "source": [
    "df[(df['退市原因']=='不足3000万') | (df['退市原因']=='低于3千万')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "       转债代码  转债名称  最后交易价格    正股代码  正股名称  发行规模(亿元)  回售规模(亿元)  剩余规模(亿元)  \\\n",
       "20   113008  电气转债  106.48  601727  上海电气     60.00     0.000    13.422   \n",
       "99   110030  格力转债  105.69  600185  格力地产      9.80     0.000     4.251   \n",
       "160  110007  博汇转债  108.61  600966  博汇纸业      9.75     0.000     0.145   \n",
       "163  110003  新钢转债  106.55  600782  新钢股份     27.60     0.024    27.576   \n",
       "\n",
       "          发行日期      最后交易日       到期日期  存续年限 退市原因  \n",
       "20  2015-02-02 2021-01-18 2021-02-02   6.0   到期  \n",
       "99  2014-12-25 2019-12-10 2019-12-25   5.0   到期  \n",
       "160 2009-09-23 2014-09-05 2014-09-23   5.0   到期  \n",
       "163 2008-08-21 2013-08-06 2013-08-20   5.0   到期  "
      ],
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>转债代码</th>\n      <th>转债名称</th>\n      <th>最后交易价格</th>\n      <th>正股代码</th>\n      <th>正股名称</th>\n      <th>发行规模(亿元)</th>\n      <th>回售规模(亿元)</th>\n      <th>剩余规模(亿元)</th>\n      <th>发行日期</th>\n      <th>最后交易日</th>\n      <th>到期日期</th>\n      <th>存续年限</th>\n      <th>退市原因</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>20</th>\n      <td>113008</td>\n      <td>电气转债</td>\n      <td>106.48</td>\n      <td>601727</td>\n      <td>上海电气</td>\n      <td>60.00</td>\n      <td>0.000</td>\n      <td>13.422</td>\n      <td>2015-02-02</td>\n      <td>2021-01-18</td>\n      <td>2021-02-02</td>\n      <td>6.0</td>\n      <td>到期</td>\n    </tr>\n    <tr>\n      <th>99</th>\n      <td>110030</td>\n      <td>格力转债</td>\n      <td>105.69</td>\n      <td>600185</td>\n      <td>格力地产</td>\n      <td>9.80</td>\n      <td>0.000</td>\n      <td>4.251</td>\n      <td>2014-12-25</td>\n      <td>2019-12-10</td>\n      <td>2019-12-25</td>\n      <td>5.0</td>\n      <td>到期</td>\n    </tr>\n    <tr>\n      <th>160</th>\n      <td>110007</td>\n      <td>博汇转债</td>\n      <td>108.61</td>\n      <td>600966</td>\n      <td>博汇纸业</td>\n      <td>9.75</td>\n      <td>0.000</td>\n      <td>0.145</td>\n      <td>2009-09-23</td>\n      <td>2014-09-05</td>\n      <td>2014-09-23</td>\n      <td>5.0</td>\n      <td>到期</td>\n    </tr>\n    <tr>\n      <th>163</th>\n      <td>110003</td>\n      <td>新钢转债</td>\n      <td>106.55</td>\n      <td>600782</td>\n      <td>新钢股份</td>\n      <td>27.60</td>\n      <td>0.024</td>\n      <td>27.576</td>\n      <td>2008-08-21</td>\n      <td>2013-08-06</td>\n      <td>2013-08-20</td>\n      <td>5.0</td>\n      <td>到期</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "metadata": {},
     "execution_count": 21
    }
   ],
   "source": [
    "df[df['退市原因']=='到期']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "       转债代码   转债名称   最后交易价格    正股代码  正股名称  发行规模(亿元)  回售规模(亿元)  剩余规模(亿元)  \\\n",
       "1    113038  隆20转债  166.130  601012  隆基股份    50.000       0.0     0.235   \n",
       "4    113590   海容转债  156.190  603187  海容冷链     5.000       0.0     0.029   \n",
       "5    113592  安20转债  176.530  603345  安井食品     9.000       0.0     0.018   \n",
       "7    113583   益丰转债  111.900  603939  益丰药房    15.810       0.0     0.079   \n",
       "9    128112   歌尔转2  144.988    2241  歌尔股份    40.000       0.0     0.599   \n",
       "..      ...    ...      ...     ...   ...       ...       ...       ...   \n",
       "142  110028   冠城转债  177.490  600067  冠城大通    18.000       0.0     0.047   \n",
       "143  128006   长青转债  145.999    2391  长青股份     6.318       0.0     0.000   \n",
       "148  110027   东方转债  159.570  600875  东方电气    40.000       0.0     0.036   \n",
       "154  110025   国金转债  194.970  600109  国金证券    25.000       0.0     0.152   \n",
       "155  128004   久立转债  143.000    2318  久立特材     4.870       0.0     0.009   \n",
       "\n",
       "          发行日期      最后交易日       到期日期  存续年限 退市原因  \n",
       "1   2020-07-31 2021-03-30 2026-07-30   0.7   强赎  \n",
       "4   2020-06-29 2021-03-05 2026-06-29   0.7   强赎  \n",
       "5   2020-07-08 2021-03-05 2026-07-07   0.7   强赎  \n",
       "7   2020-06-01 2021-03-04 2026-05-31   0.8   强赎  \n",
       "9   2020-06-12 2021-03-02 2026-06-11   0.7   强赎  \n",
       "..         ...        ...        ...   ...  ...  \n",
       "142 2014-07-18 2015-04-23 2020-07-18   0.8   强赎  \n",
       "143 2014-07-09 2015-04-15 2020-06-19   0.8   强赎  \n",
       "148 2014-07-10 2015-02-16 2020-07-10   0.6   强赎  \n",
       "154 2014-05-14 2014-12-29 2020-05-13   0.6   强赎  \n",
       "155 2014-02-25 2014-12-23 2020-02-24   0.8   强赎  \n",
       "\n",
       "[67 rows x 13 columns]"
      ],
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>转债代码</th>\n      <th>转债名称</th>\n      <th>最后交易价格</th>\n      <th>正股代码</th>\n      <th>正股名称</th>\n      <th>发行规模(亿元)</th>\n      <th>回售规模(亿元)</th>\n      <th>剩余规模(亿元)</th>\n      <th>发行日期</th>\n      <th>最后交易日</th>\n      <th>到期日期</th>\n      <th>存续年限</th>\n      <th>退市原因</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>1</th>\n      <td>113038</td>\n      <td>隆20转债</td>\n      <td>166.130</td>\n      <td>601012</td>\n      <td>隆基股份</td>\n      <td>50.000</td>\n      <td>0.0</td>\n      <td>0.235</td>\n      <td>2020-07-31</td>\n      <td>2021-03-30</td>\n      <td>2026-07-30</td>\n      <td>0.7</td>\n      <td>强赎</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>113590</td>\n      <td>海容转债</td>\n      <td>156.190</td>\n      <td>603187</td>\n      <td>海容冷链</td>\n      <td>5.000</td>\n      <td>0.0</td>\n      <td>0.029</td>\n      <td>2020-06-29</td>\n      <td>2021-03-05</td>\n      <td>2026-06-29</td>\n      <td>0.7</td>\n      <td>强赎</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>113592</td>\n      <td>安20转债</td>\n      <td>176.530</td>\n      <td>603345</td>\n      <td>安井食品</td>\n      <td>9.000</td>\n      <td>0.0</td>\n      <td>0.018</td>\n      <td>2020-07-08</td>\n      <td>2021-03-05</td>\n      <td>2026-07-07</td>\n      <td>0.7</td>\n      <td>强赎</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td>113583</td>\n      <td>益丰转债</td>\n      <td>111.900</td>\n      <td>603939</td>\n      <td>益丰药房</td>\n      <td>15.810</td>\n      <td>0.0</td>\n      <td>0.079</td>\n      <td>2020-06-01</td>\n      <td>2021-03-04</td>\n      <td>2026-05-31</td>\n      <td>0.8</td>\n      <td>强赎</td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>128112</td>\n      <td>歌尔转2</td>\n      <td>144.988</td>\n      <td>2241</td>\n      <td>歌尔股份</td>\n      <td>40.000</td>\n      <td>0.0</td>\n      <td>0.599</td>\n      <td>2020-06-12</td>\n      <td>2021-03-02</td>\n      <td>2026-06-11</td>\n      <td>0.7</td>\n      <td>强赎</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>142</th>\n      <td>110028</td>\n      <td>冠城转债</td>\n      <td>177.490</td>\n      <td>600067</td>\n      <td>冠城大通</td>\n      <td>18.000</td>\n      <td>0.0</td>\n      <td>0.047</td>\n      <td>2014-07-18</td>\n      <td>2015-04-23</td>\n      <td>2020-07-18</td>\n      <td>0.8</td>\n      <td>强赎</td>\n    </tr>\n    <tr>\n      <th>143</th>\n      <td>128006</td>\n      <td>长青转债</td>\n      <td>145.999</td>\n      <td>2391</td>\n      <td>长青股份</td>\n      <td>6.318</td>\n      <td>0.0</td>\n      <td>0.000</td>\n      <td>2014-07-09</td>\n      <td>2015-04-15</td>\n      <td>2020-06-19</td>\n      <td>0.8</td>\n      <td>强赎</td>\n    </tr>\n    <tr>\n      <th>148</th>\n      <td>110027</td>\n      <td>东方转债</td>\n      <td>159.570</td>\n      <td>600875</td>\n      <td>东方电气</td>\n      <td>40.000</td>\n      <td>0.0</td>\n      <td>0.036</td>\n      <td>2014-07-10</td>\n      <td>2015-02-16</td>\n      <td>2020-07-10</td>\n      <td>0.6</td>\n      <td>强赎</td>\n    </tr>\n    <tr>\n      <th>154</th>\n      <td>110025</td>\n      <td>国金转债</td>\n      <td>194.970</td>\n      <td>600109</td>\n      <td>国金证券</td>\n      <td>25.000</td>\n      <td>0.0</td>\n      <td>0.152</td>\n      <td>2014-05-14</td>\n      <td>2014-12-29</td>\n      <td>2020-05-13</td>\n      <td>0.6</td>\n      <td>强赎</td>\n    </tr>\n    <tr>\n      <th>155</th>\n      <td>128004</td>\n      <td>久立转债</td>\n      <td>143.000</td>\n      <td>2318</td>\n      <td>久立特材</td>\n      <td>4.870</td>\n      <td>0.0</td>\n      <td>0.009</td>\n      <td>2014-02-25</td>\n      <td>2014-12-23</td>\n      <td>2020-02-24</td>\n      <td>0.8</td>\n      <td>强赎</td>\n    </tr>\n  </tbody>\n</table>\n<p>67 rows × 13 columns</p>\n</div>"
     },
     "metadata": {},
     "execution_count": 53
    }
   ],
   "source": [
    "df[df['存续年限']<=1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "转债代码        22\n",
       "转债名称        22\n",
       "最后交易价格      22\n",
       "正股代码        22\n",
       "正股名称        22\n",
       "发行规模(亿元)    22\n",
       "回售规模(亿元)    22\n",
       "剩余规模(亿元)    22\n",
       "发行日期        22\n",
       "最后交易日       22\n",
       "到期日期        22\n",
       "存续年限        22\n",
       "退市原因        22\n",
       "dtype: int64"
      ]
     },
     "metadata": {},
     "execution_count": 25
    }
   ],
   "source": [
    "df[df['存续年限']>3].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "-0.8616352201257862"
      ]
     },
     "metadata": {},
     "execution_count": 27
    }
   ],
   "source": [
    "22/159-1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "import matplotlib\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x167e7910>"
      ]
     },
     "metadata": {},
     "execution_count": 40
    },
    {
     "output_type": "display_data",
     "data": {
      "text/plain": "<Figure size 432x288 with 1 Axes>",
      "image/svg+xml": "<?xml version=\"1.0\" encoding=\"utf-8\" standalone=\"no\"?>\r\n<!DOCTYPE svg PUBLIC \"-//W3C//DTD SVG 1.1//EN\"\r\n  \"http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd\">\r\n<!-- Created with matplotlib (https://matplotlib.org/) -->\r\n<svg height=\"248.518125pt\" version=\"1.1\" viewBox=\"0 0 385.78125 248.518125\" width=\"385.78125pt\" xmlns=\"http://www.w3.org/2000/svg\" xmlns:xlink=\"http://www.w3.org/1999/xlink\">\r\n <defs>\r\n  <style type=\"text/css\">\r\n*{stroke-linecap:butt;stroke-linejoin:round;}\r\n  </style>\r\n </defs>\r\n <g id=\"figure_1\">\r\n  <g id=\"patch_1\">\r\n   <path d=\"M 0 248.518125 \r\nL 385.78125 248.518125 \r\nL 385.78125 0 \r\nL 0 0 \r\nz\r\n\" style=\"fill:none;\"/>\r\n  </g>\r\n  <g id=\"axes_1\">\r\n   <g id=\"patch_2\">\r\n    <path d=\"M 43.78125 224.64 \r\nL 378.58125 224.64 \r\nL 378.58125 7.2 \r\nL 43.78125 7.2 \r\nz\r\n\" style=\"fill:#ffffff;\"/>\r\n   </g>\r\n   <g id=\"patch_3\">\r\n    <path clip-path=\"url(#p1bc32fa387)\" d=\"M 58.999432 224.64 \r\nL 58.999432 17.554286 \r\nL 109.726705 17.554286 \r\nL 109.726705 146.704516 \r\nL 160.453977 146.704516 \r\nL 160.453977 195.692535 \r\nL 211.18125 195.692535 \r\nL 211.18125 209.052903 \r\nL 261.908523 209.052903 \r\nL 261.908523 206.826175 \r\nL 312.635795 206.826175 \r\nL 312.635795 217.959816 \r\nL 363.363068 217.959816 \r\nL 363.363068 224.64 \r\nL 312.635795 224.64 \r\nL 312.635795 224.64 \r\nL 261.908523 224.64 \r\nL 261.908523 224.64 \r\nL 211.18125 224.64 \r\nL 211.18125 224.64 \r\nL 160.453977 224.64 \r\nL 160.453977 224.64 \r\nL 109.726705 224.64 \r\nL 109.726705 224.64 \r\nz\r\n\" style=\"fill:#0504aa;\"/>\r\n   </g>\r\n   <g id=\"matplotlib.axis_1\">\r\n    <g id=\"xtick_1\">\r\n     <g id=\"line2d_1\">\r\n      <defs>\r\n       <path d=\"M 0 0 \r\nL 0 3.5 \r\n\" id=\"m516c5b04f1\" style=\"stroke:#000000;stroke-width:0.8;\"/>\r\n      </defs>\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"81.544886\" xlink:href=\"#m516c5b04f1\" y=\"224.64\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_1\">\r\n      <!-- 1 -->\r\n      <defs>\r\n       <path d=\"M 12.40625 8.296875 \r\nL 28.515625 8.296875 \r\nL 28.515625 63.921875 \r\nL 10.984375 60.40625 \r\nL 10.984375 69.390625 \r\nL 28.421875 72.90625 \r\nL 38.28125 72.90625 \r\nL 38.28125 8.296875 \r\nL 54.390625 8.296875 \r\nL 54.390625 0 \r\nL 12.40625 0 \r\nz\r\n\" id=\"DejaVuSans-49\"/>\r\n      </defs>\r\n      <g transform=\"translate(78.363636 239.238437)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-49\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"xtick_2\">\r\n     <g id=\"line2d_2\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"137.908523\" xlink:href=\"#m516c5b04f1\" y=\"224.64\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_2\">\r\n      <!-- 2 -->\r\n      <defs>\r\n       <path d=\"M 19.1875 8.296875 \r\nL 53.609375 8.296875 \r\nL 53.609375 0 \r\nL 7.328125 0 \r\nL 7.328125 8.296875 \r\nQ 12.9375 14.109375 22.625 23.890625 \r\nQ 32.328125 33.6875 34.8125 36.53125 \r\nQ 39.546875 41.84375 41.421875 45.53125 \r\nQ 43.3125 49.21875 43.3125 52.78125 \r\nQ 43.3125 58.59375 39.234375 62.25 \r\nQ 35.15625 65.921875 28.609375 65.921875 \r\nQ 23.96875 65.921875 18.8125 64.3125 \r\nQ 13.671875 62.703125 7.8125 59.421875 \r\nL 7.8125 69.390625 \r\nQ 13.765625 71.78125 18.9375 73 \r\nQ 24.125 74.21875 28.421875 74.21875 \r\nQ 39.75 74.21875 46.484375 68.546875 \r\nQ 53.21875 62.890625 53.21875 53.421875 \r\nQ 53.21875 48.921875 51.53125 44.890625 \r\nQ 49.859375 40.875 45.40625 35.40625 \r\nQ 44.1875 33.984375 37.640625 27.21875 \r\nQ 31.109375 20.453125 19.1875 8.296875 \r\nz\r\n\" id=\"DejaVuSans-50\"/>\r\n      </defs>\r\n      <g transform=\"translate(134.727273 239.238437)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-50\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"xtick_3\">\r\n     <g id=\"line2d_3\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"194.272159\" xlink:href=\"#m516c5b04f1\" y=\"224.64\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_3\">\r\n      <!-- 3 -->\r\n      <defs>\r\n       <path d=\"M 40.578125 39.3125 \r\nQ 47.65625 37.796875 51.625 33 \r\nQ 55.609375 28.21875 55.609375 21.1875 \r\nQ 55.609375 10.40625 48.1875 4.484375 \r\nQ 40.765625 -1.421875 27.09375 -1.421875 \r\nQ 22.515625 -1.421875 17.65625 -0.515625 \r\nQ 12.796875 0.390625 7.625 2.203125 \r\nL 7.625 11.71875 \r\nQ 11.71875 9.328125 16.59375 8.109375 \r\nQ 21.484375 6.890625 26.8125 6.890625 \r\nQ 36.078125 6.890625 40.9375 10.546875 \r\nQ 45.796875 14.203125 45.796875 21.1875 \r\nQ 45.796875 27.640625 41.28125 31.265625 \r\nQ 36.765625 34.90625 28.71875 34.90625 \r\nL 20.21875 34.90625 \r\nL 20.21875 43.015625 \r\nL 29.109375 43.015625 \r\nQ 36.375 43.015625 40.234375 45.921875 \r\nQ 44.09375 48.828125 44.09375 54.296875 \r\nQ 44.09375 59.90625 40.109375 62.90625 \r\nQ 36.140625 65.921875 28.71875 65.921875 \r\nQ 24.65625 65.921875 20.015625 65.03125 \r\nQ 15.375 64.15625 9.8125 62.3125 \r\nL 9.8125 71.09375 \r\nQ 15.4375 72.65625 20.34375 73.4375 \r\nQ 25.25 74.21875 29.59375 74.21875 \r\nQ 40.828125 74.21875 47.359375 69.109375 \r\nQ 53.90625 64.015625 53.90625 55.328125 \r\nQ 53.90625 49.265625 50.4375 45.09375 \r\nQ 46.96875 40.921875 40.578125 39.3125 \r\nz\r\n\" id=\"DejaVuSans-51\"/>\r\n      </defs>\r\n      <g transform=\"translate(191.090909 239.238437)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-51\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"xtick_4\">\r\n     <g id=\"line2d_4\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"250.635795\" xlink:href=\"#m516c5b04f1\" y=\"224.64\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_4\">\r\n      <!-- 4 -->\r\n      <defs>\r\n       <path d=\"M 37.796875 64.3125 \r\nL 12.890625 25.390625 \r\nL 37.796875 25.390625 \r\nz\r\nM 35.203125 72.90625 \r\nL 47.609375 72.90625 \r\nL 47.609375 25.390625 \r\nL 58.015625 25.390625 \r\nL 58.015625 17.1875 \r\nL 47.609375 17.1875 \r\nL 47.609375 0 \r\nL 37.796875 0 \r\nL 37.796875 17.1875 \r\nL 4.890625 17.1875 \r\nL 4.890625 26.703125 \r\nz\r\n\" id=\"DejaVuSans-52\"/>\r\n      </defs>\r\n      <g transform=\"translate(247.454545 239.238437)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-52\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"xtick_5\">\r\n     <g id=\"line2d_5\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"306.999432\" xlink:href=\"#m516c5b04f1\" y=\"224.64\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_5\">\r\n      <!-- 5 -->\r\n      <defs>\r\n       <path d=\"M 10.796875 72.90625 \r\nL 49.515625 72.90625 \r\nL 49.515625 64.59375 \r\nL 19.828125 64.59375 \r\nL 19.828125 46.734375 \r\nQ 21.96875 47.46875 24.109375 47.828125 \r\nQ 26.265625 48.1875 28.421875 48.1875 \r\nQ 40.625 48.1875 47.75 41.5 \r\nQ 54.890625 34.8125 54.890625 23.390625 \r\nQ 54.890625 11.625 47.5625 5.09375 \r\nQ 40.234375 -1.421875 26.90625 -1.421875 \r\nQ 22.3125 -1.421875 17.546875 -0.640625 \r\nQ 12.796875 0.140625 7.71875 1.703125 \r\nL 7.71875 11.625 \r\nQ 12.109375 9.234375 16.796875 8.0625 \r\nQ 21.484375 6.890625 26.703125 6.890625 \r\nQ 35.15625 6.890625 40.078125 11.328125 \r\nQ 45.015625 15.765625 45.015625 23.390625 \r\nQ 45.015625 31 40.078125 35.4375 \r\nQ 35.15625 39.890625 26.703125 39.890625 \r\nQ 22.75 39.890625 18.8125 39.015625 \r\nQ 14.890625 38.140625 10.796875 36.28125 \r\nz\r\n\" id=\"DejaVuSans-53\"/>\r\n      </defs>\r\n      <g transform=\"translate(303.818182 239.238437)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-53\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"xtick_6\">\r\n     <g id=\"line2d_6\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"363.363068\" xlink:href=\"#m516c5b04f1\" y=\"224.64\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_6\">\r\n      <!-- 6 -->\r\n      <defs>\r\n       <path d=\"M 33.015625 40.375 \r\nQ 26.375 40.375 22.484375 35.828125 \r\nQ 18.609375 31.296875 18.609375 23.390625 \r\nQ 18.609375 15.53125 22.484375 10.953125 \r\nQ 26.375 6.390625 33.015625 6.390625 \r\nQ 39.65625 6.390625 43.53125 10.953125 \r\nQ 47.40625 15.53125 47.40625 23.390625 \r\nQ 47.40625 31.296875 43.53125 35.828125 \r\nQ 39.65625 40.375 33.015625 40.375 \r\nz\r\nM 52.59375 71.296875 \r\nL 52.59375 62.3125 \r\nQ 48.875 64.0625 45.09375 64.984375 \r\nQ 41.3125 65.921875 37.59375 65.921875 \r\nQ 27.828125 65.921875 22.671875 59.328125 \r\nQ 17.53125 52.734375 16.796875 39.40625 \r\nQ 19.671875 43.65625 24.015625 45.921875 \r\nQ 28.375 48.1875 33.59375 48.1875 \r\nQ 44.578125 48.1875 50.953125 41.515625 \r\nQ 57.328125 34.859375 57.328125 23.390625 \r\nQ 57.328125 12.15625 50.6875 5.359375 \r\nQ 44.046875 -1.421875 33.015625 -1.421875 \r\nQ 20.359375 -1.421875 13.671875 8.265625 \r\nQ 6.984375 17.96875 6.984375 36.375 \r\nQ 6.984375 53.65625 15.1875 63.9375 \r\nQ 23.390625 74.21875 37.203125 74.21875 \r\nQ 40.921875 74.21875 44.703125 73.484375 \r\nQ 48.484375 72.75 52.59375 71.296875 \r\nz\r\n\" id=\"DejaVuSans-54\"/>\r\n      </defs>\r\n      <g transform=\"translate(360.181818 239.238437)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-54\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n   </g>\r\n   <g id=\"matplotlib.axis_2\">\r\n    <g id=\"ytick_1\">\r\n     <g id=\"line2d_7\">\r\n      <defs>\r\n       <path d=\"M 0 0 \r\nL -3.5 0 \r\n\" id=\"mde70d2ad5d\" style=\"stroke:#000000;stroke-width:0.8;\"/>\r\n      </defs>\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"43.78125\" xlink:href=\"#mde70d2ad5d\" y=\"224.64\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_7\">\r\n      <!-- 0.0 -->\r\n      <defs>\r\n       <path d=\"M 31.78125 66.40625 \r\nQ 24.171875 66.40625 20.328125 58.90625 \r\nQ 16.5 51.421875 16.5 36.375 \r\nQ 16.5 21.390625 20.328125 13.890625 \r\nQ 24.171875 6.390625 31.78125 6.390625 \r\nQ 39.453125 6.390625 43.28125 13.890625 \r\nQ 47.125 21.390625 47.125 36.375 \r\nQ 47.125 51.421875 43.28125 58.90625 \r\nQ 39.453125 66.40625 31.78125 66.40625 \r\nz\r\nM 31.78125 74.21875 \r\nQ 44.046875 74.21875 50.515625 64.515625 \r\nQ 56.984375 54.828125 56.984375 36.375 \r\nQ 56.984375 17.96875 50.515625 8.265625 \r\nQ 44.046875 -1.421875 31.78125 -1.421875 \r\nQ 19.53125 -1.421875 13.0625 8.265625 \r\nQ 6.59375 17.96875 6.59375 36.375 \r\nQ 6.59375 54.828125 13.0625 64.515625 \r\nQ 19.53125 74.21875 31.78125 74.21875 \r\nz\r\n\" id=\"DejaVuSans-48\"/>\r\n       <path d=\"M 10.6875 12.40625 \r\nL 21 12.40625 \r\nL 21 0 \r\nL 10.6875 0 \r\nz\r\n\" id=\"DejaVuSans-46\"/>\r\n      </defs>\r\n      <g transform=\"translate(20.878125 228.439219)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-48\"/>\r\n       <use x=\"63.623047\" xlink:href=\"#DejaVuSans-46\"/>\r\n       <use x=\"95.410156\" xlink:href=\"#DejaVuSans-48\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"ytick_2\">\r\n     <g id=\"line2d_8\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"43.78125\" xlink:href=\"#mde70d2ad5d\" y=\"192.775521\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_8\">\r\n      <!-- 0.1 -->\r\n      <g transform=\"translate(20.878125 196.574739)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-48\"/>\r\n       <use x=\"63.623047\" xlink:href=\"#DejaVuSans-46\"/>\r\n       <use x=\"95.410156\" xlink:href=\"#DejaVuSans-49\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"ytick_3\">\r\n     <g id=\"line2d_9\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"43.78125\" xlink:href=\"#mde70d2ad5d\" y=\"160.911041\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_9\">\r\n      <!-- 0.2 -->\r\n      <g transform=\"translate(20.878125 164.71026)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-48\"/>\r\n       <use x=\"63.623047\" xlink:href=\"#DejaVuSans-46\"/>\r\n       <use x=\"95.410156\" xlink:href=\"#DejaVuSans-50\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"ytick_4\">\r\n     <g id=\"line2d_10\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"43.78125\" xlink:href=\"#mde70d2ad5d\" y=\"129.046562\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_10\">\r\n      <!-- 0.3 -->\r\n      <g transform=\"translate(20.878125 132.845781)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-48\"/>\r\n       <use x=\"63.623047\" xlink:href=\"#DejaVuSans-46\"/>\r\n       <use x=\"95.410156\" xlink:href=\"#DejaVuSans-51\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"ytick_5\">\r\n     <g id=\"line2d_11\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"43.78125\" xlink:href=\"#mde70d2ad5d\" y=\"97.182083\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_11\">\r\n      <!-- 0.4 -->\r\n      <g transform=\"translate(20.878125 100.981302)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-48\"/>\r\n       <use x=\"63.623047\" xlink:href=\"#DejaVuSans-46\"/>\r\n       <use x=\"95.410156\" xlink:href=\"#DejaVuSans-52\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"ytick_6\">\r\n     <g id=\"line2d_12\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"43.78125\" xlink:href=\"#mde70d2ad5d\" y=\"65.317604\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_12\">\r\n      <!-- 0.5 -->\r\n      <g transform=\"translate(20.878125 69.116822)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-48\"/>\r\n       <use x=\"63.623047\" xlink:href=\"#DejaVuSans-46\"/>\r\n       <use x=\"95.410156\" xlink:href=\"#DejaVuSans-53\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"ytick_7\">\r\n     <g id=\"line2d_13\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"43.78125\" xlink:href=\"#mde70d2ad5d\" y=\"33.453124\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_13\">\r\n      <!-- 0.6 -->\r\n      <g transform=\"translate(20.878125 37.252343)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-48\"/>\r\n       <use x=\"63.623047\" xlink:href=\"#DejaVuSans-46\"/>\r\n       <use x=\"95.410156\" xlink:href=\"#DejaVuSans-54\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"text_14\">\r\n     <!-- Frequency -->\r\n     <defs>\r\n      <path d=\"M 9.8125 72.90625 \r\nL 51.703125 72.90625 \r\nL 51.703125 64.59375 \r\nL 19.671875 64.59375 \r\nL 19.671875 43.109375 \r\nL 48.578125 43.109375 \r\nL 48.578125 34.8125 \r\nL 19.671875 34.8125 \r\nL 19.671875 0 \r\nL 9.8125 0 \r\nz\r\n\" id=\"DejaVuSans-70\"/>\r\n      <path d=\"M 41.109375 46.296875 \r\nQ 39.59375 47.171875 37.8125 47.578125 \r\nQ 36.03125 48 33.890625 48 \r\nQ 26.265625 48 22.1875 43.046875 \r\nQ 18.109375 38.09375 18.109375 28.8125 \r\nL 18.109375 0 \r\nL 9.078125 0 \r\nL 9.078125 54.6875 \r\nL 18.109375 54.6875 \r\nL 18.109375 46.1875 \r\nQ 20.953125 51.171875 25.484375 53.578125 \r\nQ 30.03125 56 36.53125 56 \r\nQ 37.453125 56 38.578125 55.875 \r\nQ 39.703125 55.765625 41.0625 55.515625 \r\nz\r\n\" id=\"DejaVuSans-114\"/>\r\n      <path d=\"M 56.203125 29.59375 \r\nL 56.203125 25.203125 \r\nL 14.890625 25.203125 \r\nQ 15.484375 15.921875 20.484375 11.0625 \r\nQ 25.484375 6.203125 34.421875 6.203125 \r\nQ 39.59375 6.203125 44.453125 7.46875 \r\nQ 49.3125 8.734375 54.109375 11.28125 \r\nL 54.109375 2.78125 \r\nQ 49.265625 0.734375 44.1875 -0.34375 \r\nQ 39.109375 -1.421875 33.890625 -1.421875 \r\nQ 20.796875 -1.421875 13.15625 6.1875 \r\nQ 5.515625 13.8125 5.515625 26.8125 \r\nQ 5.515625 40.234375 12.765625 48.109375 \r\nQ 20.015625 56 32.328125 56 \r\nQ 43.359375 56 49.78125 48.890625 \r\nQ 56.203125 41.796875 56.203125 29.59375 \r\nz\r\nM 47.21875 32.234375 \r\nQ 47.125 39.59375 43.09375 43.984375 \r\nQ 39.0625 48.390625 32.421875 48.390625 \r\nQ 24.90625 48.390625 20.390625 44.140625 \r\nQ 15.875 39.890625 15.1875 32.171875 \r\nz\r\n\" id=\"DejaVuSans-101\"/>\r\n      <path d=\"M 14.796875 27.296875 \r\nQ 14.796875 17.390625 18.875 11.75 \r\nQ 22.953125 6.109375 30.078125 6.109375 \r\nQ 37.203125 6.109375 41.296875 11.75 \r\nQ 45.40625 17.390625 45.40625 27.296875 \r\nQ 45.40625 37.203125 41.296875 42.84375 \r\nQ 37.203125 48.484375 30.078125 48.484375 \r\nQ 22.953125 48.484375 18.875 42.84375 \r\nQ 14.796875 37.203125 14.796875 27.296875 \r\nz\r\nM 45.40625 8.203125 \r\nQ 42.578125 3.328125 38.25 0.953125 \r\nQ 33.9375 -1.421875 27.875 -1.421875 \r\nQ 17.96875 -1.421875 11.734375 6.484375 \r\nQ 5.515625 14.40625 5.515625 27.296875 \r\nQ 5.515625 40.1875 11.734375 48.09375 \r\nQ 17.96875 56 27.875 56 \r\nQ 33.9375 56 38.25 53.625 \r\nQ 42.578125 51.265625 45.40625 46.390625 \r\nL 45.40625 54.6875 \r\nL 54.390625 54.6875 \r\nL 54.390625 -20.796875 \r\nL 45.40625 -20.796875 \r\nz\r\n\" id=\"DejaVuSans-113\"/>\r\n      <path d=\"M 8.5 21.578125 \r\nL 8.5 54.6875 \r\nL 17.484375 54.6875 \r\nL 17.484375 21.921875 \r\nQ 17.484375 14.15625 20.5 10.265625 \r\nQ 23.53125 6.390625 29.59375 6.390625 \r\nQ 36.859375 6.390625 41.078125 11.03125 \r\nQ 45.3125 15.671875 45.3125 23.6875 \r\nL 45.3125 54.6875 \r\nL 54.296875 54.6875 \r\nL 54.296875 0 \r\nL 45.3125 0 \r\nL 45.3125 8.40625 \r\nQ 42.046875 3.421875 37.71875 1 \r\nQ 33.40625 -1.421875 27.6875 -1.421875 \r\nQ 18.265625 -1.421875 13.375 4.4375 \r\nQ 8.5 10.296875 8.5 21.578125 \r\nz\r\nM 31.109375 56 \r\nz\r\n\" id=\"DejaVuSans-117\"/>\r\n      <path d=\"M 54.890625 33.015625 \r\nL 54.890625 0 \r\nL 45.90625 0 \r\nL 45.90625 32.71875 \r\nQ 45.90625 40.484375 42.875 44.328125 \r\nQ 39.84375 48.1875 33.796875 48.1875 \r\nQ 26.515625 48.1875 22.3125 43.546875 \r\nQ 18.109375 38.921875 18.109375 30.90625 \r\nL 18.109375 0 \r\nL 9.078125 0 \r\nL 9.078125 54.6875 \r\nL 18.109375 54.6875 \r\nL 18.109375 46.1875 \r\nQ 21.34375 51.125 25.703125 53.5625 \r\nQ 30.078125 56 35.796875 56 \r\nQ 45.21875 56 50.046875 50.171875 \r\nQ 54.890625 44.34375 54.890625 33.015625 \r\nz\r\n\" id=\"DejaVuSans-110\"/>\r\n      <path d=\"M 48.78125 52.59375 \r\nL 48.78125 44.1875 \r\nQ 44.96875 46.296875 41.140625 47.34375 \r\nQ 37.3125 48.390625 33.40625 48.390625 \r\nQ 24.65625 48.390625 19.8125 42.84375 \r\nQ 14.984375 37.3125 14.984375 27.296875 \r\nQ 14.984375 17.28125 19.8125 11.734375 \r\nQ 24.65625 6.203125 33.40625 6.203125 \r\nQ 37.3125 6.203125 41.140625 7.25 \r\nQ 44.96875 8.296875 48.78125 10.40625 \r\nL 48.78125 2.09375 \r\nQ 45.015625 0.34375 40.984375 -0.53125 \r\nQ 36.96875 -1.421875 32.421875 -1.421875 \r\nQ 20.0625 -1.421875 12.78125 6.34375 \r\nQ 5.515625 14.109375 5.515625 27.296875 \r\nQ 5.515625 40.671875 12.859375 48.328125 \r\nQ 20.21875 56 33.015625 56 \r\nQ 37.15625 56 41.109375 55.140625 \r\nQ 45.0625 54.296875 48.78125 52.59375 \r\nz\r\n\" id=\"DejaVuSans-99\"/>\r\n      <path d=\"M 32.171875 -5.078125 \r\nQ 28.375 -14.84375 24.75 -17.8125 \r\nQ 21.140625 -20.796875 15.09375 -20.796875 \r\nL 7.90625 -20.796875 \r\nL 7.90625 -13.28125 \r\nL 13.1875 -13.28125 \r\nQ 16.890625 -13.28125 18.9375 -11.515625 \r\nQ 21 -9.765625 23.484375 -3.21875 \r\nL 25.09375 0.875 \r\nL 2.984375 54.6875 \r\nL 12.5 54.6875 \r\nL 29.59375 11.921875 \r\nL 46.6875 54.6875 \r\nL 56.203125 54.6875 \r\nz\r\n\" id=\"DejaVuSans-121\"/>\r\n     </defs>\r\n     <g transform=\"translate(14.798438 141.749687)rotate(-90)scale(0.1 -0.1)\">\r\n      <use xlink:href=\"#DejaVuSans-70\"/>\r\n      <use x=\"50.269531\" xlink:href=\"#DejaVuSans-114\"/>\r\n      <use x=\"89.132812\" xlink:href=\"#DejaVuSans-101\"/>\r\n      <use x=\"150.65625\" xlink:href=\"#DejaVuSans-113\"/>\r\n      <use x=\"214.132812\" xlink:href=\"#DejaVuSans-117\"/>\r\n      <use x=\"277.511719\" xlink:href=\"#DejaVuSans-101\"/>\r\n      <use x=\"339.035156\" xlink:href=\"#DejaVuSans-110\"/>\r\n      <use x=\"402.414062\" xlink:href=\"#DejaVuSans-99\"/>\r\n      <use x=\"457.394531\" xlink:href=\"#DejaVuSans-121\"/>\r\n     </g>\r\n    </g>\r\n   </g>\r\n   <g id=\"patch_4\">\r\n    <path d=\"M 43.78125 224.64 \r\nL 43.78125 7.2 \r\n\" style=\"fill:none;stroke:#000000;stroke-linecap:square;stroke-linejoin:miter;stroke-width:0.8;\"/>\r\n   </g>\r\n   <g id=\"patch_5\">\r\n    <path d=\"M 378.58125 224.64 \r\nL 378.58125 7.2 \r\n\" style=\"fill:none;stroke:#000000;stroke-linecap:square;stroke-linejoin:miter;stroke-width:0.8;\"/>\r\n   </g>\r\n   <g id=\"patch_6\">\r\n    <path d=\"M 43.78125 224.64 \r\nL 378.58125 224.64 \r\n\" style=\"fill:none;stroke:#000000;stroke-linecap:square;stroke-linejoin:miter;stroke-width:0.8;\"/>\r\n   </g>\r\n   <g id=\"patch_7\">\r\n    <path d=\"M 43.78125 7.2 \r\nL 378.58125 7.2 \r\n\" style=\"fill:none;stroke:#000000;stroke-linecap:square;stroke-linejoin:miter;stroke-width:0.8;\"/>\r\n   </g>\r\n  </g>\r\n </g>\r\n <defs>\r\n  <clipPath id=\"p1bc32fa387\">\r\n   <rect height=\"217.44\" width=\"334.8\" x=\"43.78125\" y=\"7.2\"/>\r\n  </clipPath>\r\n </defs>\r\n</svg>\r\n",
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYIAAAD4CAYAAADhNOGaAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAARO0lEQVR4nO3de7CcdX3H8ffHQIZLZWibY2USYqJNpakDFQ+xDvVeOsFbpEqNWp3aapoqVsbpFHQ6asfptI5TbxWNKdLx2lREaNqJUm2r6CglAfESLjaDKMfoELEVQcYQ+faPXXQ92ZxsyD5nzfm9XzNn2Od5frvns3+Qz/k911QVkqR2PWjSASRJk2URSFLjLAJJapxFIEmNswgkqXFHTTrAoVqyZEmtWLFi0jEk6Yhy7bXXfreqpoZtO+KKYMWKFezYsWPSMSTpiJLkGwfa5q4hSWqcRSBJjbMIJKlxFoEkNc4ikKTGWQSS1DiLQJIaZxFIUuMsAklq3BF3ZfHhWHz0pZOOMDZ77z130hEkLRDOCCSpcRaBJDXOIpCkxlkEktQ4i0CSGmcRSFLjLAJJapxFIEmNswgkqXEWgSQ1ziKQpMZ1WgRJ1ia5OcmuJBceYMyTklyfZGeSz3SZR5K0v85uOpdkEXARcBYwA2xPsrWqbhgYcyLwLmBtVX0zyUO6yiNJGq7LGcEaYFdV3VJVe4EtwLpZY14AfKyqvglQVbd3mEeSNESXRbAUuG1geaa/btCvAb+Y5NNJrk3y4g7zSJKG6PJ5BBmyrob8/scATwWOBb6Q5Oqq+trPfFCyAdgAsHz58g6iSlK7upwRzAAnDywvA3YPGfOJqrq7qr4LXAWcNvuDqmpzVU1X1fTU1FRngSWpRV0WwXZgVZKVSRYD64Gts8b8C/D4JEclOQ54LHBjh5kkSbN0tmuoqvYlOQ+4ElgEXFJVO5Ns7G/fVFU3JvkE8GXgPuDiqvpqV5kkSfvr9JnFVbUN2DZr3aZZy28G3txlDknSgXllsSQ1ziKQpMZZBJLUOItAkhpnEUhS4ywCSWqcRSBJjbMIJKlxFoEkNc4ikKTGWQSS1DiLQJIaZxFIUuMsAklqnEUgSY2zCCSpcRaBJDXOIpCkxlkEktQ4i0CSGmcRSFLjLAJJapxFIEmN67QIkqxNcnOSXUkuHLL9SUm+n+T6/s/ruswjSdrfUV19cJJFwEXAWcAMsD3J1qq6YdbQz1bVM7rKIUmaW5czgjXArqq6par2AluAdR3+PknSA9BlESwFbhtYnumvm+1xSb6U5ONJfmPYByXZkGRHkh179uzpIqskNavLIsiQdTVr+TrgYVV1GvD3wBXDPqiqNlfVdFVNT01NjTmmJLWtyyKYAU4eWF4G7B4cUFV3VtVd/dfbgKOTLOkwkyRpli6LYDuwKsnKJIuB9cDWwQFJHpok/ddr+nnu6DCTJGmWzs4aqqp9Sc4DrgQWAZdU1c4kG/vbNwHPBf40yT7gHmB9Vc3efSRJ6lBnRQA/2d2zbda6TQOv3wm8s8sMkqS5eWWxJDXOIpCkxlkEktQ4i0CSGmcRSFLjLAJJapxFIEmNswgkqXEWgSQ1ziKQpMZZBJLUOItAkhpnEUhS4ywCSWqcRSBJjbMIJKlxFoEkNc4ikKTGWQSS1DiLQJIaZxFIUuMsAklq3EhFkORRXQeRJE3GqDOCTUmuSfLyJCeO+uFJ1ia5OcmuJBfOMe6MJD9O8txRP1uSNB4jFUFV/TbwQuBkYEeSDyc5a673JFkEXAScDawGnp9k9QHGvQm48hCzS5LGYORjBFX1P8BfAhcATwTekeSmJL93gLesAXZV1S1VtRfYAqwbMu6VwGXA7YeUXJI0FqMeIzg1yVuBG4GnAM+sql/vv37rAd62FLhtYHmmv27wc5cC5wCbDvL7NyTZkWTHnj17RoksSRrRqDOCdwLXAadV1Suq6jqAqtpNb5YwTIasq1nLbwMuqKofz/XLq2pzVU1X1fTU1NSIkSVJozhqxHFPA+65/x/sJA8CjqmqH1bVBw7wnhl6xxTutwzYPWvMNLAlCcAS4GlJ9lXVFaN+AUnS4Rl1RvAp4NiB5eP66+ayHViVZGWSxcB6YOvggKpaWVUrqmoF8FHg5ZaAJM2vUWcEx1TVXfcvVNVdSY6b6w1VtS/JefTOBloEXFJVO5Ns7G+f87iAJGl+jFoEdyc5/f5jA0keA9xzsDdV1TZg26x1Qwugqv5wxCySpDEatQjOBy5Ncv8+/pOA53UTSZI0n0YqgqranuQU4JH0zga6qaru7TSZJGlejDojADgDWNF/z6OTUFXv7ySVJGnejFQEST4APAK4Hrj/nP8CLAJJOsKNOiOYBlZX1ewLwiRJR7hRryP4KvDQLoNIkiZj1BnBEuCGJNcAP7p/ZVU9q5NUkqR5M2oRvKHLEJKkyRn19NHPJHkYsKqqPtW/qnhRt9EkSfNh1NtQv4zevYDe01+1FPCeQJK0AIx6sPgVwJnAnfCTh9Q8pKtQkqT5M2oR/Kj/lDEAkhzF/s8WkCQdgUYtgs8keS1wbP9ZxZcC/9pdLEnSfBm1CC4E9gBfAf6E3h1FD/RkMknSEWTUs4buA/6h/yNJWkBGvdfQ1xlyTKCqHj72RJKkeXUo9xq63zHAucAvjT+OJGm+jXSMoKruGPj5VlW9DXhKx9kkSfNg1F1Dpw8sPojeDOHBnSSSJM2rUXcN/d3A633ArcDvjz2NJGnejXrW0JO7DiJJmoxRdw29eq7tVfWW8cSRJM23Qzlr6Axga3/5mcBVwG1dhJIkzZ9DeTDN6VX1A4AkbwAuraqXzvWmJGuBt9O7ZfXFVfW3s7avA94I3Efv2MP5VfW5Q/oGkqTDMmoRLAf2DizvBVbM9YYki4CLgLOAGWB7kq1VdcPAsP8AtlZVJTkV+AhwyoiZJEljMGoRfAC4Jsnl9K4wPgd4/0HeswbYVVW3ACTZAqwDflIEVXXXwPjj8Y6mkjTvRj1r6K+TfBx4fH/VS6rqiwd521J+9hjCDPDY2YOSnAP8Db3nGzx92Acl2QBsAFi+fPkokSVJIxr17qMAxwF3VtXbgZkkKw8yPkPWDbtf0eVVdQrwbHrHC/Z/U9XmqpququmpqalDiCxJOphRH1X5euAC4DX9VUcDHzzI22aAkweWlwG7DzS4qq4CHpFkySiZJEnjMeqM4BzgWcDdAFW1m4PfYmI7sCrJyiSLgfX89PRTAJL8apL0X58OLAbuGD2+JOlwjXqweG//zJ4CSHL8wd5QVfuSnAdcSe/00UuqameSjf3tm4DnAC9Oci9wD/C8qvKAsSTNo1GL4CNJ3gOcmORlwB8xwkNqqmobvaeZDa7bNPD6TcCbRo8rSRq3gxZBf9fNP9M7v/9O4JHA66rqkx1nkyTNg4MWQX+X0BVV9RjAf/wlaYEZ9WDx1UnO6DSJJGkiRj1G8GRgY5Jb6Z05FHqThVO7CiZJmh9zFkGS5VX1TeDsecojSZpnB5sRXEHvrqPfSHJZVT1nPkJJkubPwY4RDN4m4uFdBpEkTcbBiqAO8FqStEAcbNfQaUnupDczOLb/Gn56sPiETtNJkjo3ZxFU1aL5CiJJmoxDuQ21JGkBsggkqXGjXlCmnzOLj7500hHGZu+95046gtQ0ZwSS1DiLQJIaZxFIUuMsAklqnEUgSY2zCCSpcRaBJDXOIpCkxlkEktQ4i0CSGtdpESRZm+TmJLuSXDhk+wuTfLn/8/kkp3WZR5K0v86KIMki4CJ6zzteDTw/yepZw74OPLGqTgXeCGzuKo8kabguZwRrgF1VdUtV7QW2AOsGB1TV56vqf/uLVwPLOswjSRqiyyJYCtw2sDzTX3cgfwx8fNiGJBuS7EiyY8+ePWOMKEnqsggyZN3Q5x4neTK9Irhg2Paq2lxV01U1PTU1NcaIkqQun0cwA5w8sLwM2D17UJJTgYuBs6vqjg7zSJKG6HJGsB1YlWRlksXAemDr4IAky4GPAS+qqq91mEWSdACdzQiqal+S84ArgUXAJVW1M8nG/vZNwOuAXwbelQRgX1VNd5VJkrS/Th9VWVXbgG2z1m0aeP1S4KVdZpAkzc0riyWpcRaBJDXOIpCkxlkEktQ4i0CSGmcRSFLjLAJJapxFIEmNswgkqXEWgSQ1ziKQpMZZBJLUOItAkhpnEUhS4ywCSWqcRSBJjbMIJKlxFoEkNc4ikKTGWQSS1DiLQJIaZxFIUuMsAklqXKdFkGRtkpuT7Epy4ZDtpyT5QpIfJfnzLrNIkoY7qqsPTrIIuAg4C5gBtifZWlU3DAz7HvBnwLO7yiFJmluXM4I1wK6quqWq9gJbgHWDA6rq9qraDtzbYQ5J0hy6LIKlwG0DyzP9dYcsyYYkO5Ls2LNnz1jCSZJ6uiyCDFlXD+SDqmpzVU1X1fTU1NRhxpIkDeqyCGaAkweWlwG7O/x9kqQHoLODxcB2YFWSlcC3gPXACzr8fTpCLT760klHGJu995476QjSIeusCKpqX5LzgCuBRcAlVbUzycb+9k1JHgrsAE4A7ktyPrC6qu7sKpck6Wd1OSOgqrYB22at2zTw+jv0dhlJkibEK4slqXEWgSQ1ziKQpMZZBJLUOItAkhpnEUhS4ywCSWqcRSBJjev0gjJJRyZv+9EWZwSS1DhnBNIYLaS/pNUOZwSS1DiLQJIaZxFIUuMsAklqnEUgSY2zCCSpcRaBJDXOIpCkxnlBmaQFbSFd5NfV7TKcEUhS4ywCSWqcRSBJjeu0CJKsTXJzkl1JLhyyPUne0d/+5SSnd5lHkrS/zoogySLgIuBsYDXw/CSrZw07G1jV/9kAvLurPJKk4bqcEawBdlXVLVW1F9gCrJs1Zh3w/uq5GjgxyUkdZpIkzdLl6aNLgdsGlmeAx44wZinw7cFBSTbQmzEA3JXk5vFGHYslwHcnHaJDC/37wcL/jn6/I1xyWN/xYQfa0GURZMi6egBjqKrNwOZxhOpKkh1VNT3pHF1Z6N8PFv539Psd+br6jl3uGpoBTh5YXgbsfgBjJEkd6rIItgOrkqxMshhYD2ydNWYr8OL+2UO/BXy/qr49+4MkSd3pbNdQVe1Lch5wJbAIuKSqdibZ2N++CdgGPA3YBfwQeElXeebBz/WuqzFY6N8PFv539Psd+Tr5jqnab5e8JKkhXlksSY2zCCSpcRbBYUpySZLbk3x10lm6kOTkJP+V5MYkO5O8atKZxinJMUmuSfKl/vf7q0ln6kKSRUm+mOTfJp2lC0luTfKVJNcn2THpPOOW5MQkH01yU///xceN9fM9RnB4kjwBuIveFdKPmnSecetf6X1SVV2X5MHAtcCzq+qGCUcbiyQBjq+qu5IcDXwOeFX/SvcFI8mrgWnghKp6xqTzjFuSW4HpqlqQF5QleR/w2aq6uH8W5nFV9X/j+nxnBIepqq4CvjfpHF2pqm9X1XX91z8AbqR39feC0L+9yV39xaP7Pwvqr6Mky4CnAxdPOosOXZITgCcA7wWoqr3jLAGwCHQIkqwAHg3892STjFd/t8n1wO3AJ6tqQX0/4G3AXwD3TTpIhwr49yTX9m9Js5A8HNgD/GN/997FSY4f5y+wCDSSJL8AXAacX1V3TjrPOFXVj6vqN+ld2b4myYLZxZfkGcDtVXXtpLN07MyqOp3eHY1f0d9lu1AcBZwOvLuqHg3cDex3W//DYRHooPr7zi8DPlRVH5t0nq70p9ufBtZOOMo4nQk8q78PfQvwlCQfnGyk8auq3f3/3g5cTu/uxwvFDDAzMFP9KL1iGBuLQHPqH0x9L3BjVb1l0nnGLclUkhP7r48Ffge4abKpxqeqXlNVy6pqBb3bvPxnVf3BhGONVZLj+ycy0N9l8rvAgjmLr6q+A9yW5JH9VU8FxnqyRpd3H21Ckn8CngQsSTIDvL6q3jvZVGN1JvAi4Cv9/egAr62qbRPMNE4nAe/rP0jpQcBHqmpBnmK5gP0KcHnvbxaOAj5cVZ+YbKSxeyXwof4ZQ7cw5tvxePqoJDXOXUOS1DiLQJIaZxFIUuMsAklqnEUgSY2zCCSpcRaBJDXu/wF0J7uXfCkzngAAAABJRU5ErkJggg==\n"
     },
     "metadata": {
      "needs_background": "light"
     }
    }
   ],
   "source": [
    "df['存续年限'].plot(kind='hist',bins=6,histtype='stepfilled', density=True,color='#0504aa')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "(array([58., 54., 25., 10.,  6.,  6.]),\n",
       " array([0., 1., 2., 3., 4., 5., 6.]),\n",
       " <a list of 6 Patch objects>)"
      ]
     },
     "metadata": {},
     "execution_count": 63
    },
    {
     "output_type": "display_data",
     "data": {
      "text/plain": "<Figure size 432x504 with 1 Axes>",
      "image/svg+xml": "<?xml version=\"1.0\" encoding=\"utf-8\" standalone=\"no\"?>\r\n<!DOCTYPE svg PUBLIC \"-//W3C//DTD SVG 1.1//EN\"\r\n  \"http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd\">\r\n<!-- Created with matplotlib (https://matplotlib.org/) -->\r\n<svg height=\"411.598125pt\" version=\"1.1\" viewBox=\"0 0 368.925 411.598125\" width=\"368.925pt\" xmlns=\"http://www.w3.org/2000/svg\" xmlns:xlink=\"http://www.w3.org/1999/xlink\">\r\n <defs>\r\n  <style type=\"text/css\">\r\n*{stroke-linecap:butt;stroke-linejoin:round;}\r\n  </style>\r\n </defs>\r\n <g id=\"figure_1\">\r\n  <g id=\"patch_1\">\r\n   <path d=\"M -0 411.598125 \r\nL 368.925 411.598125 \r\nL 368.925 0 \r\nL -0 0 \r\nz\r\n\" style=\"fill:none;\"/>\r\n  </g>\r\n  <g id=\"axes_1\">\r\n   <g id=\"patch_2\">\r\n    <path d=\"M 26.925 387.72 \r\nL 361.725 387.72 \r\nL 361.725 7.2 \r\nL 26.925 7.2 \r\nz\r\n\" style=\"fill:#ffffff;\"/>\r\n   </g>\r\n   <g id=\"patch_3\">\r\n    <path clip-path=\"url(#p83f9cf8e30)\" d=\"M 42.143182 387.72 \r\nL 87.797727 387.72 \r\nL 87.797727 25.32 \r\nL 42.143182 25.32 \r\nz\r\n\" style=\"fill:#008000;opacity:0.8;\"/>\r\n   </g>\r\n   <g id=\"patch_4\">\r\n    <path clip-path=\"url(#p83f9cf8e30)\" d=\"M 92.870455 387.72 \r\nL 138.525 387.72 \r\nL 138.525 50.313103 \r\nL 92.870455 50.313103 \r\nz\r\n\" style=\"fill:#008000;opacity:0.8;\"/>\r\n   </g>\r\n   <g id=\"patch_5\">\r\n    <path clip-path=\"url(#p83f9cf8e30)\" d=\"M 143.597727 387.72 \r\nL 189.252273 387.72 \r\nL 189.252273 231.513103 \r\nL 143.597727 231.513103 \r\nz\r\n\" style=\"fill:#008000;opacity:0.8;\"/>\r\n   </g>\r\n   <g id=\"patch_6\">\r\n    <path clip-path=\"url(#p83f9cf8e30)\" d=\"M 194.325 387.72 \r\nL 239.979545 387.72 \r\nL 239.979545 325.237241 \r\nL 194.325 325.237241 \r\nz\r\n\" style=\"fill:#008000;opacity:0.8;\"/>\r\n   </g>\r\n   <g id=\"patch_7\">\r\n    <path clip-path=\"url(#p83f9cf8e30)\" d=\"M 245.052273 387.72 \r\nL 290.706818 387.72 \r\nL 290.706818 350.230345 \r\nL 245.052273 350.230345 \r\nz\r\n\" style=\"fill:#008000;opacity:0.8;\"/>\r\n   </g>\r\n   <g id=\"patch_8\">\r\n    <path clip-path=\"url(#p83f9cf8e30)\" d=\"M 295.779545 387.72 \r\nL 341.434091 387.72 \r\nL 341.434091 350.230345 \r\nL 295.779545 350.230345 \r\nz\r\n\" style=\"fill:#008000;opacity:0.8;\"/>\r\n   </g>\r\n   <g id=\"matplotlib.axis_1\">\r\n    <g id=\"xtick_1\">\r\n     <g id=\"line2d_1\">\r\n      <defs>\r\n       <path d=\"M 0 0 \r\nL 0 3.5 \r\n\" id=\"m370df35534\" style=\"stroke:#000000;stroke-width:0.8;\"/>\r\n      </defs>\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"42.143182\" xlink:href=\"#m370df35534\" y=\"387.72\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_1\">\r\n      <!-- 0 -->\r\n      <defs>\r\n       <path d=\"M 31.78125 66.40625 \r\nQ 24.171875 66.40625 20.328125 58.90625 \r\nQ 16.5 51.421875 16.5 36.375 \r\nQ 16.5 21.390625 20.328125 13.890625 \r\nQ 24.171875 6.390625 31.78125 6.390625 \r\nQ 39.453125 6.390625 43.28125 13.890625 \r\nQ 47.125 21.390625 47.125 36.375 \r\nQ 47.125 51.421875 43.28125 58.90625 \r\nQ 39.453125 66.40625 31.78125 66.40625 \r\nz\r\nM 31.78125 74.21875 \r\nQ 44.046875 74.21875 50.515625 64.515625 \r\nQ 56.984375 54.828125 56.984375 36.375 \r\nQ 56.984375 17.96875 50.515625 8.265625 \r\nQ 44.046875 -1.421875 31.78125 -1.421875 \r\nQ 19.53125 -1.421875 13.0625 8.265625 \r\nQ 6.59375 17.96875 6.59375 36.375 \r\nQ 6.59375 54.828125 13.0625 64.515625 \r\nQ 19.53125 74.21875 31.78125 74.21875 \r\nz\r\n\" id=\"DejaVuSans-48\"/>\r\n      </defs>\r\n      <g transform=\"translate(38.961932 402.318437)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-48\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"xtick_2\">\r\n     <g id=\"line2d_2\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"92.870455\" xlink:href=\"#m370df35534\" y=\"387.72\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_2\">\r\n      <!-- 1 -->\r\n      <defs>\r\n       <path d=\"M 12.40625 8.296875 \r\nL 28.515625 8.296875 \r\nL 28.515625 63.921875 \r\nL 10.984375 60.40625 \r\nL 10.984375 69.390625 \r\nL 28.421875 72.90625 \r\nL 38.28125 72.90625 \r\nL 38.28125 8.296875 \r\nL 54.390625 8.296875 \r\nL 54.390625 0 \r\nL 12.40625 0 \r\nz\r\n\" id=\"DejaVuSans-49\"/>\r\n      </defs>\r\n      <g transform=\"translate(89.689205 402.318437)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-49\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"xtick_3\">\r\n     <g id=\"line2d_3\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"143.597727\" xlink:href=\"#m370df35534\" y=\"387.72\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_3\">\r\n      <!-- 2 -->\r\n      <defs>\r\n       <path d=\"M 19.1875 8.296875 \r\nL 53.609375 8.296875 \r\nL 53.609375 0 \r\nL 7.328125 0 \r\nL 7.328125 8.296875 \r\nQ 12.9375 14.109375 22.625 23.890625 \r\nQ 32.328125 33.6875 34.8125 36.53125 \r\nQ 39.546875 41.84375 41.421875 45.53125 \r\nQ 43.3125 49.21875 43.3125 52.78125 \r\nQ 43.3125 58.59375 39.234375 62.25 \r\nQ 35.15625 65.921875 28.609375 65.921875 \r\nQ 23.96875 65.921875 18.8125 64.3125 \r\nQ 13.671875 62.703125 7.8125 59.421875 \r\nL 7.8125 69.390625 \r\nQ 13.765625 71.78125 18.9375 73 \r\nQ 24.125 74.21875 28.421875 74.21875 \r\nQ 39.75 74.21875 46.484375 68.546875 \r\nQ 53.21875 62.890625 53.21875 53.421875 \r\nQ 53.21875 48.921875 51.53125 44.890625 \r\nQ 49.859375 40.875 45.40625 35.40625 \r\nQ 44.1875 33.984375 37.640625 27.21875 \r\nQ 31.109375 20.453125 19.1875 8.296875 \r\nz\r\n\" id=\"DejaVuSans-50\"/>\r\n      </defs>\r\n      <g transform=\"translate(140.416477 402.318437)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-50\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"xtick_4\">\r\n     <g id=\"line2d_4\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"194.325\" xlink:href=\"#m370df35534\" y=\"387.72\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_4\">\r\n      <!-- 3 -->\r\n      <defs>\r\n       <path d=\"M 40.578125 39.3125 \r\nQ 47.65625 37.796875 51.625 33 \r\nQ 55.609375 28.21875 55.609375 21.1875 \r\nQ 55.609375 10.40625 48.1875 4.484375 \r\nQ 40.765625 -1.421875 27.09375 -1.421875 \r\nQ 22.515625 -1.421875 17.65625 -0.515625 \r\nQ 12.796875 0.390625 7.625 2.203125 \r\nL 7.625 11.71875 \r\nQ 11.71875 9.328125 16.59375 8.109375 \r\nQ 21.484375 6.890625 26.8125 6.890625 \r\nQ 36.078125 6.890625 40.9375 10.546875 \r\nQ 45.796875 14.203125 45.796875 21.1875 \r\nQ 45.796875 27.640625 41.28125 31.265625 \r\nQ 36.765625 34.90625 28.71875 34.90625 \r\nL 20.21875 34.90625 \r\nL 20.21875 43.015625 \r\nL 29.109375 43.015625 \r\nQ 36.375 43.015625 40.234375 45.921875 \r\nQ 44.09375 48.828125 44.09375 54.296875 \r\nQ 44.09375 59.90625 40.109375 62.90625 \r\nQ 36.140625 65.921875 28.71875 65.921875 \r\nQ 24.65625 65.921875 20.015625 65.03125 \r\nQ 15.375 64.15625 9.8125 62.3125 \r\nL 9.8125 71.09375 \r\nQ 15.4375 72.65625 20.34375 73.4375 \r\nQ 25.25 74.21875 29.59375 74.21875 \r\nQ 40.828125 74.21875 47.359375 69.109375 \r\nQ 53.90625 64.015625 53.90625 55.328125 \r\nQ 53.90625 49.265625 50.4375 45.09375 \r\nQ 46.96875 40.921875 40.578125 39.3125 \r\nz\r\n\" id=\"DejaVuSans-51\"/>\r\n      </defs>\r\n      <g transform=\"translate(191.14375 402.318437)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-51\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"xtick_5\">\r\n     <g id=\"line2d_5\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"245.052273\" xlink:href=\"#m370df35534\" y=\"387.72\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_5\">\r\n      <!-- 4 -->\r\n      <defs>\r\n       <path d=\"M 37.796875 64.3125 \r\nL 12.890625 25.390625 \r\nL 37.796875 25.390625 \r\nz\r\nM 35.203125 72.90625 \r\nL 47.609375 72.90625 \r\nL 47.609375 25.390625 \r\nL 58.015625 25.390625 \r\nL 58.015625 17.1875 \r\nL 47.609375 17.1875 \r\nL 47.609375 0 \r\nL 37.796875 0 \r\nL 37.796875 17.1875 \r\nL 4.890625 17.1875 \r\nL 4.890625 26.703125 \r\nz\r\n\" id=\"DejaVuSans-52\"/>\r\n      </defs>\r\n      <g transform=\"translate(241.871023 402.318437)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-52\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"xtick_6\">\r\n     <g id=\"line2d_6\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"295.779545\" xlink:href=\"#m370df35534\" y=\"387.72\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_6\">\r\n      <!-- 5 -->\r\n      <defs>\r\n       <path d=\"M 10.796875 72.90625 \r\nL 49.515625 72.90625 \r\nL 49.515625 64.59375 \r\nL 19.828125 64.59375 \r\nL 19.828125 46.734375 \r\nQ 21.96875 47.46875 24.109375 47.828125 \r\nQ 26.265625 48.1875 28.421875 48.1875 \r\nQ 40.625 48.1875 47.75 41.5 \r\nQ 54.890625 34.8125 54.890625 23.390625 \r\nQ 54.890625 11.625 47.5625 5.09375 \r\nQ 40.234375 -1.421875 26.90625 -1.421875 \r\nQ 22.3125 -1.421875 17.546875 -0.640625 \r\nQ 12.796875 0.140625 7.71875 1.703125 \r\nL 7.71875 11.625 \r\nQ 12.109375 9.234375 16.796875 8.0625 \r\nQ 21.484375 6.890625 26.703125 6.890625 \r\nQ 35.15625 6.890625 40.078125 11.328125 \r\nQ 45.015625 15.765625 45.015625 23.390625 \r\nQ 45.015625 31 40.078125 35.4375 \r\nQ 35.15625 39.890625 26.703125 39.890625 \r\nQ 22.75 39.890625 18.8125 39.015625 \r\nQ 14.890625 38.140625 10.796875 36.28125 \r\nz\r\n\" id=\"DejaVuSans-53\"/>\r\n      </defs>\r\n      <g transform=\"translate(292.598295 402.318437)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-53\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"xtick_7\">\r\n     <g id=\"line2d_7\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"346.506818\" xlink:href=\"#m370df35534\" y=\"387.72\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_7\">\r\n      <!-- 6 -->\r\n      <defs>\r\n       <path d=\"M 33.015625 40.375 \r\nQ 26.375 40.375 22.484375 35.828125 \r\nQ 18.609375 31.296875 18.609375 23.390625 \r\nQ 18.609375 15.53125 22.484375 10.953125 \r\nQ 26.375 6.390625 33.015625 6.390625 \r\nQ 39.65625 6.390625 43.53125 10.953125 \r\nQ 47.40625 15.53125 47.40625 23.390625 \r\nQ 47.40625 31.296875 43.53125 35.828125 \r\nQ 39.65625 40.375 33.015625 40.375 \r\nz\r\nM 52.59375 71.296875 \r\nL 52.59375 62.3125 \r\nQ 48.875 64.0625 45.09375 64.984375 \r\nQ 41.3125 65.921875 37.59375 65.921875 \r\nQ 27.828125 65.921875 22.671875 59.328125 \r\nQ 17.53125 52.734375 16.796875 39.40625 \r\nQ 19.671875 43.65625 24.015625 45.921875 \r\nQ 28.375 48.1875 33.59375 48.1875 \r\nQ 44.578125 48.1875 50.953125 41.515625 \r\nQ 57.328125 34.859375 57.328125 23.390625 \r\nQ 57.328125 12.15625 50.6875 5.359375 \r\nQ 44.046875 -1.421875 33.015625 -1.421875 \r\nQ 20.359375 -1.421875 13.671875 8.265625 \r\nQ 6.984375 17.96875 6.984375 36.375 \r\nQ 6.984375 53.65625 15.1875 63.9375 \r\nQ 23.390625 74.21875 37.203125 74.21875 \r\nQ 40.921875 74.21875 44.703125 73.484375 \r\nQ 48.484375 72.75 52.59375 71.296875 \r\nz\r\n\" id=\"DejaVuSans-54\"/>\r\n      </defs>\r\n      <g transform=\"translate(343.325568 402.318437)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-54\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n   </g>\r\n   <g id=\"matplotlib.axis_2\">\r\n    <g id=\"ytick_1\">\r\n     <g id=\"line2d_8\">\r\n      <defs>\r\n       <path d=\"M 0 0 \r\nL -3.5 0 \r\n\" id=\"m73cd26155e\" style=\"stroke:#000000;stroke-width:0.8;\"/>\r\n      </defs>\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"26.925\" xlink:href=\"#m73cd26155e\" y=\"387.72\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_8\">\r\n      <!-- 0 -->\r\n      <g transform=\"translate(13.5625 391.519219)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-48\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"ytick_2\">\r\n     <g id=\"line2d_9\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"26.925\" xlink:href=\"#m73cd26155e\" y=\"325.237241\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_9\">\r\n      <!-- 10 -->\r\n      <g transform=\"translate(7.2 329.03646)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-49\"/>\r\n       <use x=\"63.623047\" xlink:href=\"#DejaVuSans-48\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"ytick_3\">\r\n     <g id=\"line2d_10\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"26.925\" xlink:href=\"#m73cd26155e\" y=\"262.754483\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_10\">\r\n      <!-- 20 -->\r\n      <g transform=\"translate(7.2 266.553702)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-50\"/>\r\n       <use x=\"63.623047\" xlink:href=\"#DejaVuSans-48\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"ytick_4\">\r\n     <g id=\"line2d_11\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"26.925\" xlink:href=\"#m73cd26155e\" y=\"200.271724\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_11\">\r\n      <!-- 30 -->\r\n      <g transform=\"translate(7.2 204.070943)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-51\"/>\r\n       <use x=\"63.623047\" xlink:href=\"#DejaVuSans-48\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"ytick_5\">\r\n     <g id=\"line2d_12\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"26.925\" xlink:href=\"#m73cd26155e\" y=\"137.788966\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_12\">\r\n      <!-- 40 -->\r\n      <g transform=\"translate(7.2 141.588184)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-52\"/>\r\n       <use x=\"63.623047\" xlink:href=\"#DejaVuSans-48\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"ytick_6\">\r\n     <g id=\"line2d_13\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"26.925\" xlink:href=\"#m73cd26155e\" y=\"75.306207\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_13\">\r\n      <!-- 50 -->\r\n      <g transform=\"translate(7.2 79.105426)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-53\"/>\r\n       <use x=\"63.623047\" xlink:href=\"#DejaVuSans-48\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"ytick_7\">\r\n     <g id=\"line2d_14\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"26.925\" xlink:href=\"#m73cd26155e\" y=\"12.823448\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_14\">\r\n      <!-- 60 -->\r\n      <g transform=\"translate(7.2 16.622667)scale(0.1 -0.1)\">\r\n       <use xlink:href=\"#DejaVuSans-54\"/>\r\n       <use x=\"63.623047\" xlink:href=\"#DejaVuSans-48\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n   </g>\r\n   <g id=\"patch_9\">\r\n    <path d=\"M 26.925 387.72 \r\nL 26.925 7.2 \r\n\" style=\"fill:none;stroke:#000000;stroke-linecap:square;stroke-linejoin:miter;stroke-width:0.8;\"/>\r\n   </g>\r\n   <g id=\"patch_10\">\r\n    <path d=\"M 361.725 387.72 \r\nL 361.725 7.2 \r\n\" style=\"fill:none;stroke:#000000;stroke-linecap:square;stroke-linejoin:miter;stroke-width:0.8;\"/>\r\n   </g>\r\n   <g id=\"patch_11\">\r\n    <path d=\"M 26.925 387.72 \r\nL 361.725 387.72 \r\n\" style=\"fill:none;stroke:#000000;stroke-linecap:square;stroke-linejoin:miter;stroke-width:0.8;\"/>\r\n   </g>\r\n   <g id=\"patch_12\">\r\n    <path d=\"M 26.925 7.2 \r\nL 361.725 7.2 \r\n\" style=\"fill:none;stroke:#000000;stroke-linecap:square;stroke-linejoin:miter;stroke-width:0.8;\"/>\r\n   </g>\r\n  </g>\r\n </g>\r\n <defs>\r\n  <clipPath id=\"p83f9cf8e30\">\r\n   <rect height=\"380.52\" width=\"334.8\" x=\"26.925\" y=\"7.2\"/>\r\n  </clipPath>\r\n </defs>\r\n</svg>\r\n",
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXAAAAGbCAYAAADdmst+AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAQFUlEQVR4nO3dUYxlB13H8d/fLgYsEtp02mwouJo0KDGBkglimhC11lQltg9iJJFsTM2+KIFoQqovhjeeDD4Yk02LrhHUBiRtiEGbVaImikyhCrjVGoLQsHRHlAA+SMC/D3uQdXfq3N6Z2bv/8vkkm3PPmXvn/k+a/fbsuefMVHcHgHm+bdMDALAeAQcYSsABhhJwgKEEHGCoY1fzzW666aY+ceLE1XxLgPEee+yxf+vurcu3X9WAnzhxIjs7O1fzLQHGq6p/3Wu7UygAQ60U8Kp6cVW9t6qeqKpzVfWDVXVjVT1aVU8uyxuOelgAvmnVI/DfTPLB7v7eJK9Mci7J/UnOdvdtSc4u6wBcJfsGvKpelOR1SR5Mku7+and/Mck9Sc4sTzuT5N6jGhKAK61yBP49SXaT/E5VfayqHqiq65Pc0t3nk2RZ3rzXi6vqVFXtVNXO7u7uoQ0O8K1ulYAfS/LqJL/d3bcn+c88i9Ml3X26u7e7e3tr64qrYABY0yoBfyrJU9394WX9vbkY9Ker6niSLMsLRzMiAHvZN+Dd/fkkn62qly+b7kzyj0keSXJy2XYyycNHMiEAe1r1Rp43J3l3VX17kk8l+flcjP9DVXVfks8kecPRjAjAXlYKeHc/nmR7jy/debjjALAqd2ICDCXgAEMJOMBQAg4wlIADDCXgAENd1V/ocBDbp/e6ivHat3PKL7AAjoYjcIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYY6tukBvhVtn97e9Ahr2Tm1s+kRgEs4AgcYSsABhhJwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYaqXfSl9Vn07y5SRfT/K17t6uqhuT/FGSE0k+neRnuvs/jmZMAC73bI7Af7i7X9Xd28v6/UnOdvdtSc4u6wBcJQc5hXJPkjPL4zNJ7j34OACsatWAd5I/q6rHqurUsu2W7j6fJMvy5r1eWFWnqmqnqnZ2d3cPPjEASVY8B57kju7+XFXdnOTRqnpi1Tfo7tNJTifJ9vZ2rzEjAHtY6Qi8uz+3LC8keX+S1yR5uqqOJ8myvHBUQwJwpX0DXlXXV9V3fuNxkh9L8okkjyQ5uTztZJKHj2pIAK60yimUW5K8v6q+8fz3dPcHq+ojSR6qqvuSfCbJG45uTAAut2/Au/tTSV65x/YvJLnzKIYCYH/uxAQYSsABhhJwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYSsABhlo54FV1XVV9rKo+sKzfWFWPVtWTy/KGoxsTgMs9myPwtyQ5d8n6/UnOdvdtSc4u6wBcJSsFvKpuTfKTSR64ZPM9Sc4sj88kufdwRwPg/7PqEfg7k7wtyX9fsu2W7j6fJMvy5r1eWFWnqmqnqnZ2d3cPNCwA37RvwKvq9UkudPdj67xBd5/u7u3u3t7a2lrnWwCwh2MrPOeOJD9VVT+R5PlJXlRVv5/k6ao63t3nq+p4kgtHOSgA/9e+R+Dd/avdfWt3n0jys0n+vLt/LskjSU4uTzuZ5OEjmxKAKxzkOvB3JLmrqp5McteyDsBVssoplP/V3R9K8qHl8ReS3Hn4IwGwCndiAgwl4ABDCTjAUAIOMJSAAwwl4ABDCTjAUAIOMJSAAwwl4ABDCTjAUAIOMJSAAwwl4ABDCTjAUAIOMJSAAwwl4ABDCTjAUAIOMJSAAwwl4ABDCTjAUAIOMJSAAwwl4ABDCTjAUAIOMJSAAwwl4ABDCTjAUAIOMJSAAwwl4ABDCTjAUAIOMJSAAwwl4ABDCTjAUAIOMJSAAwwl4ABDCTjAUAIOMJSAAwwl4ABDCTjAUAIOMJSAAwwl4ABDCTjAUAIOMJSAAwy1b8Cr6vlV9XdV9fdV9cmqevuy/caqerSqnlyWNxz9uAB8wypH4P+V5Ee6+5VJXpXk7qp6bZL7k5zt7tuSnF3WAbhK9g14X/SVZfV5y59Ock+SM8v2M0nuPZIJAdjTSufAq+q6qno8yYUkj3b3h5Pc0t3nk2RZ3vwMrz1VVTtVtbO7u3tYcwN8y1sp4N399e5+VZJbk7ymqr5/1Tfo7tPdvd3d21tbW+vOCcBlntVVKN39xSQfSnJ3kqer6niSLMsLhz4dAM9olatQtqrqxcvjFyT50SRPJHkkycnlaSeTPHxUQwJwpWMrPOd4kjNVdV0uBv+h7v5AVf1Nkoeq6r4kn0nyhiOcE4DL7Bvw7v6HJLfvsf0LSe48iqEA2J87MQGGEnCAoQQcYCgBBxhKwAGGEnCAoQQcYCgBBxhKwAGGEnCAoQQcYCgBBxhKwAGGEnCAoQQcYCgBBxhKwAGGEnCAoQQcYCgBBxhKwAGGEnCAoQQcYCgBBxhKwAGGEnCAoY5tegBm2z69vekRnrWdUzubHgEOhSNwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYSsABhhJwgKEEHGAoAQcYat+AV9VLq+ovqupcVX2yqt6ybL+xqh6tqieX5Q1HPy4A37DKEfjXkvxKd39fktcm+cWqekWS+5Oc7e7bkpxd1gG4SvYNeHef7+6PLo+/nORckpckuSfJmeVpZ5Lce1RDAnClZ3UOvKpOJLk9yYeT3NLd55OLkU9y8zO85lRV7VTVzu7u7sGmBeB/rRzwqnphkvcleWt3f2nV13X36e7e7u7tra2tdWYEYA8rBbyqnpeL8X53d//xsvnpqjq+fP14kgtHMyIAe1nlKpRK8mCSc939G5d86ZEkJ5fHJ5M8fPjjAfBMjq3wnDuSvCnJx6vq8WXbryV5R5KHquq+JJ9J8oajGRGAvewb8O7+6yT1DF++83DHAWBV7sQEGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGGrfgFfVu6rqQlV94pJtN1bVo1X15LK84WjHBOByqxyB/26Suy/bdn+Ss919W5KzyzoAV9G+Ae/uv0zy75dtvifJmeXxmST3HvJcAOzj2Jqvu6W7zydJd5+vqpuf6YlVdSrJqSR52ctetubbwdHaPr296RHWsnNqZ9MjsEFH/iFmd5/u7u3u3t7a2jrqtwP4lrFuwJ+uquNJsiwvHN5IAKxi3YA/kuTk8vhkkocPZxwAVrXKZYR/kORvkry8qp6qqvuSvCPJXVX1ZJK7lnUArqJ9P8Ts7jc+w5fuPORZAHgW3IkJMJSAAwwl4ABDCTjAUAIOMJSAAwwl4ABDCTjAUAIOMJSAAwwl4ABDCTjAUAIOMJSAAwwl4ABDCTjAUAIOMJSAAwwl4ABD7fs7MYFZtk9vb3qEteyc2rli28R92Ws/joojcIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgKAEHGErAAYYScIChBBxgqAMFvKrurqp/qqp/qar7D2soAPa3dsCr6rokv5Xkx5O8Iskbq+oVhzUYAP+/gxyBvybJv3T3p7r7q0n+MMk9hzMWAPup7l7vhVU/neTu7v6FZf1NSX6gu3/psuedSnJqWX15kn9ac9abkvzbmq+91tiXa89zZT8S+3KtOsi+fFd3b12+8dgBhqk9tl3xf4PuPp3k9AHe5+KbVe109/ZBv8+1wL5ce54r+5HYl2vVUezLQU6hPJXkpZes35rkcwcbB4BVHSTgH0lyW1V9d1V9e5KfTfLI4YwFwH7WPoXS3V+rql9K8qdJrkvyru7+5KFNdqUDn4a5htiXa89zZT8S+3KtOvR9WftDTAA2y52YAEMJOMBQIwL+XLllv6reVVUXquoTm57lIKrqpVX1F1V1rqo+WVVv2fRM66qq51fV31XV3y/78vZNz3QQVXVdVX2sqj6w6VkOoqo+XVUfr6rHq2pn0/McRFW9uKreW1VPLH9nfvDQvve1fg58uWX/n5PclYuXLn4kyRu7+x83Otgaqup1Sb6S5Pe6+/s3Pc+6qup4kuPd/dGq+s4kjyW5d+h/k0pyfXd/paqel+Svk7ylu/92w6Otpap+Ocl2khd19+s3Pc+6qurTSba7e/xNPFV1JslfdfcDyxV739HdXzyM7z3hCPw5c8t+d/9lkn/f9BwH1d3nu/ujy+MvJzmX5CWbnWo9fdFXltXnLX+u7aOaZ1BVtyb5ySQPbHoWLqqqFyV5XZIHk6S7v3pY8U5mBPwlST57yfpTGRqL56KqOpHk9iQf3uwk61tOOzye5EKSR7t76r68M8nbkvz3pgc5BJ3kz6rqseXHcUz1PUl2k/zOcmrrgaq6/rC++YSAr3TLPldfVb0wyfuSvLW7v7TpedbV3V/v7lfl4t3Er6mqcae3qur1SS5092ObnuWQ3NHdr87Fn3b6i8vpx4mOJXl1kt/u7tuT/GeSQ/scb0LA3bJ/DVrOF78vybu7+483Pc9hWP5p+6Ekd294lHXckeSnlnPHf5jkR6rq9zc70vq6+3PL8kKS9+fiqdSJnkry1CX/qntvLgb9UEwIuFv2rzHLB38PJjnX3b+x6XkOoqq2qurFy+MXJPnRJE9sdqpnr7t/tbtv7e4Tufh35M+7++c2PNZaqur65cPxLKcbfizJyCu3uvvzST5bVS9fNt2Z5NA+7D/ITyO8KjZwy/6Rqao/SPJDSW6qqqeS/Hp3P7jZqdZyR5I3Jfn4cu44SX6tu/9kgzOt63iSM8vVTt+W5KHuHn0J3nPALUnef/E4IceSvKe7P7jZkQ7kzUnevRyAfirJzx/WN77mLyMEYG8TTqEAsAcBBxhKwAGGEnCAoQQcYCgBBxhKwAGG+h/TRlrWDa4f9wAAAABJRU5ErkJggg==\n"
     },
     "metadata": {
      "needs_background": "light"
     }
    }
   ],
   "source": [
    "plt.figure(figsize=(6,7))\n",
    "plt.hist(df['存续年限'].tolist(),bins =np.arange(0,6.5,1),width=0.9,alpha=0.8,color='green')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "转债代码        112\n",
       "转债名称        112\n",
       "最后交易价格      112\n",
       "正股代码        112\n",
       "正股名称        112\n",
       "发行规模(亿元)    112\n",
       "回售规模(亿元)    112\n",
       "剩余规模(亿元)    112\n",
       "发行日期        112\n",
       "最后交易日       112\n",
       "到期日期        112\n",
       "存续年限        112\n",
       "退市原因        112\n",
       "dtype: int64"
      ]
     },
     "metadata": {},
     "execution_count": 69
    }
   ],
   "source": [
    "df[df['存续年限']<2].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "0.36477987421383645"
      ]
     },
     "metadata": {},
     "execution_count": 68
    }
   ],
   "source": [
    "58/159"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "0.7044025157232704"
      ]
     },
     "metadata": {},
     "execution_count": 70
    }
   ],
   "source": [
    "112/159"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ]
}