量化分析/选股策略/EV-EBITDA-stocks.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "![](https://fenc.wang/imgs/2020/08/3565654bfbe9ffa0.png)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts\n",
    "import pandas as pd\n",
    "\n",
    "#设置完整显示数据\n",
    "pd.set_option('display.max_rows', 500)\n",
    "pd.set_option('display.max_columns', 500)\n",
    "pd.set_option('display.width', 1000)\n",
    "pd.set_option('display.float_format', '{:,.2f}'.format)\n",
    "\n",
    "pro = ts.pro_api('xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx')\n",
    "cn_en={\n",
    "    'end_date':'报告期',\n",
    "    'total_mv':'总市值 （万元）',\n",
    "    'ebitda':'息税折旧摊销前利润',\n",
    "    'lt_borr':'长期借款',\n",
    "    'st_borr':'短期借款',\n",
    "    'money_cap':'货币资金',\n",
    "    'trad_asset':'交易性金融资产'\n",
    "}\n",
    "\n",
    "#股票池\n",
    "stock_list = ['爱旭股份', '晶澳科技', '协鑫集成', '中环股份', '东方日升', '中来股份', '亿晶光电', '天合光能', '向日葵', '隆基股份', '通威股份', '正泰电器', '航天机电', '拓日新能']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 主要用于获取代码对应的中文名称"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ts_code</th>\n",
       "      <th>name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>587</th>\n",
       "      <td>002129.SZ</td>\n",
       "      <td>中环股份</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>675</th>\n",
       "      <td>002218.SZ</td>\n",
       "      <td>拓日新能</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>911</th>\n",
       "      <td>002459.SZ</td>\n",
       "      <td>晶澳科技</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>957</th>\n",
       "      <td>002506.SZ</td>\n",
       "      <td>协鑫集成</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1570</th>\n",
       "      <td>300111.SZ</td>\n",
       "      <td>向日葵</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1577</th>\n",
       "      <td>300118.SZ</td>\n",
       "      <td>东方日升</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1846</th>\n",
       "      <td>300393.SZ</td>\n",
       "      <td>中来股份</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2571</th>\n",
       "      <td>600151.SH</td>\n",
       "      <td>航天机电</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2804</th>\n",
       "      <td>600438.SH</td>\n",
       "      <td>通威股份</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2878</th>\n",
       "      <td>600537.SH</td>\n",
       "      <td>亿晶光电</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3047</th>\n",
       "      <td>600732.SH</td>\n",
       "      <td>爱旭股份</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3263</th>\n",
       "      <td>601012.SH</td>\n",
       "      <td>隆基股份</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3422</th>\n",
       "      <td>601877.SH</td>\n",
       "      <td>正泰电器</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4331</th>\n",
       "      <td>688599.SH</td>\n",
       "      <td>天合光能</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        ts_code  name\n",
       "587   002129.SZ  中环股份\n",
       "675   002218.SZ  拓日新能\n",
       "911   002459.SZ  晶澳科技\n",
       "957   002506.SZ  协鑫集成\n",
       "1570  300111.SZ   向日葵\n",
       "1577  300118.SZ  东方日升\n",
       "1846  300393.SZ  中来股份\n",
       "2571  600151.SH  航天机电\n",
       "2804  600438.SH  通威股份\n",
       "2878  600537.SH  亿晶光电\n",
       "3047  600732.SH  爱旭股份\n",
       "3263  601012.SH  隆基股份\n",
       "3422  601877.SH  正泰电器\n",
       "4331  688599.SH  天合光能"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stock_basic = pro.stock_basic(exchange='', list_status='L', fields='ts_code,name')\n",
    "stock_selections = stock_basic[stock_basic['name'].isin(stock_list)]\n",
    "stock_selections"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 公式：EV=MC+Total Debt−C\n",
    "### 下面要注意的是：财务数据为2020年的，有滞后性； 市值`total_mv`截至到2021年07月15日；"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame()\n",
    "gf = pd.DataFrame()\n",
    "for code in stock_selections['ts_code']:\n",
    "    ebitda = pro.fina_indicator(ts_code=code,period='20201231',fields='ts_code,end_date,ebitda')\n",
    "    debt_c = pro.balancesheet(ts_code=code,period='20201231',fields='ts_code,end_date,lt_borr,st_borr,money_cap,trad_asset')\n",
    "    gf=pd.merge(ebitda,debt_c,on=['ts_code','end_date'])\n",
    "    mv = pro.daily_basic(trade_date='20210715', fields='ts_code,total_mv')\n",
    "    mv['total_mv'] = mv['total_mv']*10000\n",
    "    gf=gf.merge(mv)\n",
    "    df= df.append(gf)\n",
    "df.drop_duplicates(subset=['ts_code','end_date'],keep='last',inplace=True)\n",
    "df.set_index('end_date', inplace=True)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ts_code</th>\n",
       "      <th>ebitda</th>\n",
       "      <th>money_cap</th>\n",
       "      <th>trad_asset</th>\n",
       "      <th>lt_borr</th>\n",
       "      <th>st_borr</th>\n",
       "      <th>total_mv</th>\n",
       "      <th>name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>002129.SZ</td>\n",
       "      <td>4,830,394,685.03</td>\n",
       "      <td>7,515,854,433.95</td>\n",
       "      <td>374,535,025.80</td>\n",
       "      <td>9,225,755,188.49</td>\n",
       "      <td>1,692,000,000.00</td>\n",
       "      <td>136,360,377,328.00</td>\n",
       "      <td>中环股份</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>002218.SZ</td>\n",
       "      <td>614,376,132.35</td>\n",
       "      <td>510,638,337.64</td>\n",
       "      <td>None</td>\n",
       "      <td>208,969,421.34</td>\n",
       "      <td>1,123,000,000.00</td>\n",
       "      <td>7,010,059,730.00</td>\n",
       "      <td>拓日新能</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>002459.SZ</td>\n",
       "      <td>4,102,899,731.25</td>\n",
       "      <td>9,492,867,871.01</td>\n",
       "      <td>None</td>\n",
       "      <td>777,574,540.32</td>\n",
       "      <td>4,631,170,200.95</td>\n",
       "      <td>84,658,226,679.00</td>\n",
       "      <td>晶澳科技</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>002506.SZ</td>\n",
       "      <td>-1,813,653,560.32</td>\n",
       "      <td>3,447,321,015.12</td>\n",
       "      <td>0.0</td>\n",
       "      <td>None</td>\n",
       "      <td>2,171,868,774.35</td>\n",
       "      <td>22,309,465,161.00</td>\n",
       "      <td>协鑫集成</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>300111.SZ</td>\n",
       "      <td>90,263,312.66</td>\n",
       "      <td>225,642,535.14</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>3,471,380,000.00</td>\n",
       "      <td>向日葵</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     ts_code            ebitda        money_cap     trad_asset          lt_borr          st_borr           total_mv  name\n",
       "0  002129.SZ  4,830,394,685.03 7,515,854,433.95 374,535,025.80 9,225,755,188.49 1,692,000,000.00 136,360,377,328.00  中环股份\n",
       "1  002218.SZ    614,376,132.35   510,638,337.64           None   208,969,421.34 1,123,000,000.00   7,010,059,730.00  拓日新能\n",
       "2  002459.SZ  4,102,899,731.25 9,492,867,871.01           None   777,574,540.32 4,631,170,200.95  84,658,226,679.00  晶澳科技\n",
       "3  002506.SZ -1,813,653,560.32 3,447,321,015.12            0.0             None 2,171,868,774.35  22,309,465,161.00  协鑫集成\n",
       "4  300111.SZ     90,263,312.66   225,642,535.14           None             None             None   3,471,380,000.00   向日葵"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#获取股票代码对应的中文名称\n",
    "df=df.merge(stock_selections, on=['ts_code'])\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 这里是计算EV和EV/EBITDA"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.fillna(0)\n",
    "df['ev'] = df['total_mv']+df['lt_borr']+df['st_borr']-df['money_cap']-df['trad_asset']\n",
    "df['ev/ebitda'] = df['ev'] / df['ebitda']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 筛选EV和EV/EBITDA 大于0的股票（可选项）"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ts_code</th>\n",
       "      <th>息税折旧摊销前利润</th>\n",
       "      <th>货币资金</th>\n",
       "      <th>交易性金融资产</th>\n",
       "      <th>长期借款</th>\n",
       "      <th>短期借款</th>\n",
       "      <th>总市值 （万元）</th>\n",
       "      <th>name</th>\n",
       "      <th>ev</th>\n",
       "      <th>ev/ebitda</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>002506.SZ</td>\n",
       "      <td>-1,813,653,560.32</td>\n",
       "      <td>3,447,321,015.12</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2,171,868,774.35</td>\n",
       "      <td>22,309,465,161.00</td>\n",
       "      <td>协鑫集成</td>\n",
       "      <td>21,034,012,920.23</td>\n",
       "      <td>-11.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>600537.SH</td>\n",
       "      <td>-322,958,950.10</td>\n",
       "      <td>1,993,500,182.34</td>\n",
       "      <td>0.00</td>\n",
       "      <td>24,000,000.00</td>\n",
       "      <td>60,000,000.00</td>\n",
       "      <td>5,328,907,484.00</td>\n",
       "      <td>亿晶光电</td>\n",
       "      <td>3,419,407,301.66</td>\n",
       "      <td>-10.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>601877.SH</td>\n",
       "      <td>10,334,268,531.29</td>\n",
       "      <td>5,976,128,282.81</td>\n",
       "      <td>15,811,063.20</td>\n",
       "      <td>12,327,584,249.86</td>\n",
       "      <td>837,723,601.34</td>\n",
       "      <td>69,293,647,549.00</td>\n",
       "      <td>正泰电器</td>\n",
       "      <td>76,467,016,054.19</td>\n",
       "      <td>7.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>300118.SZ</td>\n",
       "      <td>1,491,318,404.43</td>\n",
       "      <td>5,167,824,832.94</td>\n",
       "      <td>638,412,772.27</td>\n",
       "      <td>1,715,991,806.77</td>\n",
       "      <td>3,547,361,295.59</td>\n",
       "      <td>17,486,382,855.00</td>\n",
       "      <td>东方日升</td>\n",
       "      <td>16,943,498,352.15</td>\n",
       "      <td>11.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>002218.SZ</td>\n",
       "      <td>614,376,132.35</td>\n",
       "      <td>510,638,337.64</td>\n",
       "      <td>0.00</td>\n",
       "      <td>208,969,421.34</td>\n",
       "      <td>1,123,000,000.00</td>\n",
       "      <td>7,010,059,730.00</td>\n",
       "      <td>拓日新能</td>\n",
       "      <td>7,831,390,813.70</td>\n",
       "      <td>12.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>002459.SZ</td>\n",
       "      <td>4,102,899,731.25</td>\n",
       "      <td>9,492,867,871.01</td>\n",
       "      <td>0.00</td>\n",
       "      <td>777,574,540.32</td>\n",
       "      <td>4,631,170,200.95</td>\n",
       "      <td>84,658,226,679.00</td>\n",
       "      <td>晶澳科技</td>\n",
       "      <td>80,574,103,549.26</td>\n",
       "      <td>19.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>600732.SH</td>\n",
       "      <td>1,580,387,795.81</td>\n",
       "      <td>1,254,711,684.25</td>\n",
       "      <td>5,184,124.05</td>\n",
       "      <td>978,811,167.04</td>\n",
       "      <td>1,152,595,500.00</td>\n",
       "      <td>30,198,761,843.00</td>\n",
       "      <td>爱旭股份</td>\n",
       "      <td>31,070,272,701.74</td>\n",
       "      <td>19.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>600151.SH</td>\n",
       "      <td>616,020,105.08</td>\n",
       "      <td>999,519,108.76</td>\n",
       "      <td>4,198,324.20</td>\n",
       "      <td>617,365,296.88</td>\n",
       "      <td>1,178,053,558.47</td>\n",
       "      <td>13,051,695,812.00</td>\n",
       "      <td>航天机电</td>\n",
       "      <td>13,843,397,234.39</td>\n",
       "      <td>22.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>600438.SH</td>\n",
       "      <td>7,377,596,387.66</td>\n",
       "      <td>6,264,168,242.03</td>\n",
       "      <td>1,531,863,068.12</td>\n",
       "      <td>6,296,585,539.34</td>\n",
       "      <td>2,349,154,525.77</td>\n",
       "      <td>181,997,593,079.00</td>\n",
       "      <td>通威股份</td>\n",
       "      <td>182,847,301,833.96</td>\n",
       "      <td>24.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>688599.SH</td>\n",
       "      <td>2,907,855,950.42</td>\n",
       "      <td>9,429,357,046.49</td>\n",
       "      <td>914,709,238.85</td>\n",
       "      <td>4,108,253,652.66</td>\n",
       "      <td>5,067,682,762.45</td>\n",
       "      <td>73,414,936,313.00</td>\n",
       "      <td>天合光能</td>\n",
       "      <td>72,246,806,442.77</td>\n",
       "      <td>24.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>002129.SZ</td>\n",
       "      <td>4,830,394,685.03</td>\n",
       "      <td>7,515,854,433.95</td>\n",
       "      <td>374,535,025.80</td>\n",
       "      <td>9,225,755,188.49</td>\n",
       "      <td>1,692,000,000.00</td>\n",
       "      <td>136,360,377,328.00</td>\n",
       "      <td>中环股份</td>\n",
       "      <td>139,387,743,056.74</td>\n",
       "      <td>28.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>300393.SZ</td>\n",
       "      <td>452,875,072.14</td>\n",
       "      <td>1,470,152,756.89</td>\n",
       "      <td>21,890,059.87</td>\n",
       "      <td>188,890,715.36</td>\n",
       "      <td>1,358,416,092.51</td>\n",
       "      <td>13,151,802,211.00</td>\n",
       "      <td>中来股份</td>\n",
       "      <td>13,207,066,202.11</td>\n",
       "      <td>29.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>300111.SZ</td>\n",
       "      <td>90,263,312.66</td>\n",
       "      <td>225,642,535.14</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3,471,380,000.00</td>\n",
       "      <td>向日葵</td>\n",
       "      <td>3,245,737,464.86</td>\n",
       "      <td>35.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>601012.SH</td>\n",
       "      <td>12,212,647,317.34</td>\n",
       "      <td>26,963,388,535.78</td>\n",
       "      <td>4,000,971.20</td>\n",
       "      <td>1,125,286,240.29</td>\n",
       "      <td>2,415,965,626.06</td>\n",
       "      <td>504,108,285,696.00</td>\n",
       "      <td>隆基股份</td>\n",
       "      <td>480,682,148,055.37</td>\n",
       "      <td>39.36</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      ts_code         息税折旧摊销前利润              货币资金          交易性金融资产              长期借款             短期借款           总市值 （万元）  name                 ev  ev/ebitda\n",
       "3   002506.SZ -1,813,653,560.32  3,447,321,015.12             0.00              0.00 2,171,868,774.35  22,309,465,161.00  协鑫集成  21,034,012,920.23     -11.60\n",
       "9   600537.SH   -322,958,950.10  1,993,500,182.34             0.00     24,000,000.00    60,000,000.00   5,328,907,484.00  亿晶光电   3,419,407,301.66     -10.59\n",
       "12  601877.SH 10,334,268,531.29  5,976,128,282.81    15,811,063.20 12,327,584,249.86   837,723,601.34  69,293,647,549.00  正泰电器  76,467,016,054.19       7.40\n",
       "5   300118.SZ  1,491,318,404.43  5,167,824,832.94   638,412,772.27  1,715,991,806.77 3,547,361,295.59  17,486,382,855.00  东方日升  16,943,498,352.15      11.36\n",
       "1   002218.SZ    614,376,132.35    510,638,337.64             0.00    208,969,421.34 1,123,000,000.00   7,010,059,730.00  拓日新能   7,831,390,813.70      12.75\n",
       "2   002459.SZ  4,102,899,731.25  9,492,867,871.01             0.00    777,574,540.32 4,631,170,200.95  84,658,226,679.00  晶澳科技  80,574,103,549.26      19.64\n",
       "10  600732.SH  1,580,387,795.81  1,254,711,684.25     5,184,124.05    978,811,167.04 1,152,595,500.00  30,198,761,843.00  爱旭股份  31,070,272,701.74      19.66\n",
       "7   600151.SH    616,020,105.08    999,519,108.76     4,198,324.20    617,365,296.88 1,178,053,558.47  13,051,695,812.00  航天机电  13,843,397,234.39      22.47\n",
       "8   600438.SH  7,377,596,387.66  6,264,168,242.03 1,531,863,068.12  6,296,585,539.34 2,349,154,525.77 181,997,593,079.00  通威股份 182,847,301,833.96      24.78\n",
       "13  688599.SH  2,907,855,950.42  9,429,357,046.49   914,709,238.85  4,108,253,652.66 5,067,682,762.45  73,414,936,313.00  天合光能  72,246,806,442.77      24.85\n",
       "0   002129.SZ  4,830,394,685.03  7,515,854,433.95   374,535,025.80  9,225,755,188.49 1,692,000,000.00 136,360,377,328.00  中环股份 139,387,743,056.74      28.86\n",
       "6   300393.SZ    452,875,072.14  1,470,152,756.89    21,890,059.87    188,890,715.36 1,358,416,092.51  13,151,802,211.00  中来股份  13,207,066,202.11      29.16\n",
       "4   300111.SZ     90,263,312.66    225,642,535.14             0.00              0.00             0.00   3,471,380,000.00   向日葵   3,245,737,464.86      35.96\n",
       "11  601012.SH 12,212,647,317.34 26,963,388,535.78     4,000,971.20  1,125,286,240.29 2,415,965,626.06 504,108,285,696.00  隆基股份 480,682,148,055.37      39.36"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#df_filter = df[(df[['ev', 'ev/ebitda']] > 0).all(1)]\n",
    "df.sort_values(by=['ev/ebitda'],inplace=True)\n",
    "df = df.rename(columns=cn_en)\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "作者：柯西君_BingWong\n",
    "\n",
    "网站：cnVar.cn"
   ]
  }
 ],
 "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
}