naver_stock_html_to_csv.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "naver_stock_html_to_csv",
      "provenance": [],
      "collapsed_sections": []
    },
    "kernelspec": {
      "display_name": "Python 3",
      "name": "python3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Kw6X9EYjEjbE"
      },
      "source": [
        "## 네이버금융_업종별시세 : https://finance.naver.com/sise/sise_group.nhn?type=upjong\n",
        "## 네이버금융_테마별시세 : https://finance.naver.com/sise/theme.nhn"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "lIYdn1woOS1n"
      },
      "source": [
        "import pandas as pd\n",
        "import requests\n",
        "import urllib\n",
        "from bs4 import BeautifulSoup\n",
        "from glob import glob\n",
        "import datetime\n",
        "\n",
        "pd.options.display.max_rows=None"
      ],
      "execution_count": 1,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "d8NlJLJcUDVo",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "e220bb96-c543-424d-c751-4598cc25c5f1"
      },
      "source": [
        "# 실행 전 html 파일들 업로드 필요\n",
        "## 네이버 금융 > 업종/테마별 시세 > 원하는 업종/테마 선택 > html 파일 다운로드\n",
        "\n",
        "today = str(datetime.datetime.now().date()).replace('-', '')\n",
        "print(today)\n",
        "\n",
        "df_list = []\n",
        "for fname in glob('*.html'):\n",
        "    tmp_df = pd.read_html(fname)[2].dropna(how='all').reset_index(drop=True)\n",
        "    tmp_df = tmp_df[['종목명', '현재가', '전일비', '등락률', '시가총액', '보통주배당금', '외국인비율', 'PER', 'ROE', 'PBR']]  # html 다운로드 시 선택했던 지표명들\n",
        "    tmp_df['PER_abs'] = tmp_df['PER'].abs()\n",
        "    tmp_df['분야'] = fname.split('_ 네이버 금융.html')[0].strip()\n",
        "    tmp_df.to_csv(fname.replace('.html', f' ({today}).csv'), encoding='cp949', index=False)\n",
        "    df_list.append(tmp_df)\n",
        "\n",
        "total_df = pd.concat(df_list, ignore_index=True)\n",
        "total_df.to_csv(f'stocks_total ({today}).csv', encoding='cp949', index=False)\n",
        "\n",
        "!zip -r stocks_csv.zip *.csv"
      ],
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "20210827\n",
            "updating: 수소차(연료전지_부품_충전소 등) _ 네이버 금융 (20210827).csv (deflated 63%)\n",
            "updating: 풍력에너지 _ 네이버 금융 (20210827).csv (deflated 52%)\n",
            "updating: 에너지장비및서비스 _ 네이버 금융 (20210827).csv (deflated 50%)\n",
            "updating: 전력저장장치(ESS) _ 네이버 금융 (20210827).csv (deflated 53%)\n",
            "updating: stocks_total (20210827).csv (deflated 64%)\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Rs5SFy0GTFQH",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "3576592f-ad75-49ba-9650-50a8ae6f1f17"
      },
      "source": [
        "print(fname)\n",
        "tmp_df.sort_values('PER_abs').reset_index(drop=True)"
      ],
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "수소차(연료전지_부품_충전소 등) _ 네이버 금융.html\n"
          ],
          "name": "stdout"
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>종목명</th>\n",
              "      <th>현재가</th>\n",
              "      <th>전일비</th>\n",
              "      <th>등락률</th>\n",
              "      <th>시가총액</th>\n",
              "      <th>보통주배당금</th>\n",
              "      <th>외국인비율</th>\n",
              "      <th>PER</th>\n",
              "      <th>ROE</th>\n",
              "      <th>PBR</th>\n",
              "      <th>PER_abs</th>\n",
              "      <th>분야</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>뉴로스 *</td>\n",
              "      <td>2230.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.00%</td>\n",
              "      <td>795.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>3.61</td>\n",
              "      <td>-0.89</td>\n",
              "      <td>-96.76</td>\n",
              "      <td>1.63</td>\n",
              "      <td>0.89</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>UCI *</td>\n",
              "      <td>445.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.00%</td>\n",
              "      <td>166.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.83</td>\n",
              "      <td>-1.14</td>\n",
              "      <td>-55.57</td>\n",
              "      <td>0.78</td>\n",
              "      <td>1.14</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>에스에너지 *</td>\n",
              "      <td>4215.0</td>\n",
              "      <td>65.0</td>\n",
              "      <td>+1.57%</td>\n",
              "      <td>818.0</td>\n",
              "      <td>47.0</td>\n",
              "      <td>2.19</td>\n",
              "      <td>-3.14</td>\n",
              "      <td>-20.55</td>\n",
              "      <td>0.67</td>\n",
              "      <td>3.14</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>에스코넥 *</td>\n",
              "      <td>2055.0</td>\n",
              "      <td>75.0</td>\n",
              "      <td>+3.79%</td>\n",
              "      <td>1360.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.41</td>\n",
              "      <td>-4.40</td>\n",
              "      <td>-59.88</td>\n",
              "      <td>2.70</td>\n",
              "      <td>4.40</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>평화홀딩스</td>\n",
              "      <td>5240.0</td>\n",
              "      <td>600.0</td>\n",
              "      <td>+12.93%</td>\n",
              "      <td>766.0</td>\n",
              "      <td>150.0</td>\n",
              "      <td>16.10</td>\n",
              "      <td>7.01</td>\n",
              "      <td>-2.68</td>\n",
              "      <td>0.63</td>\n",
              "      <td>7.01</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>세원 *</td>\n",
              "      <td>4650.0</td>\n",
              "      <td>135.0</td>\n",
              "      <td>+2.99%</td>\n",
              "      <td>1557.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.96</td>\n",
              "      <td>7.94</td>\n",
              "      <td>18.70</td>\n",
              "      <td>1.95</td>\n",
              "      <td>7.94</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>엘티씨 *</td>\n",
              "      <td>11000.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>+2.80%</td>\n",
              "      <td>882.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>1.28</td>\n",
              "      <td>-8.91</td>\n",
              "      <td>-4.72</td>\n",
              "      <td>1.00</td>\n",
              "      <td>8.91</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>일지테크 *</td>\n",
              "      <td>4340.0</td>\n",
              "      <td>155.0</td>\n",
              "      <td>+3.70%</td>\n",
              "      <td>586.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4.70</td>\n",
              "      <td>-9.25</td>\n",
              "      <td>-11.16</td>\n",
              "      <td>0.53</td>\n",
              "      <td>9.25</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>기아</td>\n",
              "      <td>82100.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>+0.12%</td>\n",
              "      <td>332803.0</td>\n",
              "      <td>1000.0</td>\n",
              "      <td>33.61</td>\n",
              "      <td>9.58</td>\n",
              "      <td>5.05</td>\n",
              "      <td>1.02</td>\n",
              "      <td>9.58</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>한화솔루션</td>\n",
              "      <td>40800.0</td>\n",
              "      <td>1100.0</td>\n",
              "      <td>+2.77%</td>\n",
              "      <td>78042.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>16.84</td>\n",
              "      <td>10.12</td>\n",
              "      <td>5.30</td>\n",
              "      <td>0.97</td>\n",
              "      <td>10.12</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>STX중공업</td>\n",
              "      <td>5800.0</td>\n",
              "      <td>50.0</td>\n",
              "      <td>+0.87%</td>\n",
              "      <td>1645.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.49</td>\n",
              "      <td>-10.18</td>\n",
              "      <td>0.73</td>\n",
              "      <td>1.05</td>\n",
              "      <td>10.18</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>코웰패션 *</td>\n",
              "      <td>8030.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>-0.12%</td>\n",
              "      <td>7107.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>7.22</td>\n",
              "      <td>11.06</td>\n",
              "      <td>22.98</td>\n",
              "      <td>1.66</td>\n",
              "      <td>11.06</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>삼양사</td>\n",
              "      <td>62800.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.00%</td>\n",
              "      <td>6477.0</td>\n",
              "      <td>1250.0</td>\n",
              "      <td>5.85</td>\n",
              "      <td>11.20</td>\n",
              "      <td>5.06</td>\n",
              "      <td>0.51</td>\n",
              "      <td>11.20</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>현대모비스</td>\n",
              "      <td>269500.0</td>\n",
              "      <td>2500.0</td>\n",
              "      <td>+0.94%</td>\n",
              "      <td>255467.0</td>\n",
              "      <td>4000.0</td>\n",
              "      <td>35.49</td>\n",
              "      <td>11.56</td>\n",
              "      <td>4.66</td>\n",
              "      <td>0.72</td>\n",
              "      <td>11.56</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>원익머트리얼즈 *</td>\n",
              "      <td>34850.0</td>\n",
              "      <td>1150.0</td>\n",
              "      <td>+3.41%</td>\n",
              "      <td>4394.0</td>\n",
              "      <td>200.0</td>\n",
              "      <td>17.15</td>\n",
              "      <td>12.20</td>\n",
              "      <td>10.26</td>\n",
              "      <td>1.26</td>\n",
              "      <td>12.20</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>삼보모터스 *</td>\n",
              "      <td>6720.0</td>\n",
              "      <td>310.0</td>\n",
              "      <td>+4.84%</td>\n",
              "      <td>1265.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.00</td>\n",
              "      <td>12.29</td>\n",
              "      <td>-3.12</td>\n",
              "      <td>0.55</td>\n",
              "      <td>12.29</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>SNT모티브</td>\n",
              "      <td>54200.0</td>\n",
              "      <td>700.0</td>\n",
              "      <td>+1.31%</td>\n",
              "      <td>7926.0</td>\n",
              "      <td>1600.0</td>\n",
              "      <td>21.30</td>\n",
              "      <td>12.41</td>\n",
              "      <td>7.28</td>\n",
              "      <td>0.92</td>\n",
              "      <td>12.41</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>효성화학</td>\n",
              "      <td>402000.0</td>\n",
              "      <td>4000.0</td>\n",
              "      <td>+1.01%</td>\n",
              "      <td>12824.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>10.26</td>\n",
              "      <td>14.41</td>\n",
              "      <td>-2.71</td>\n",
              "      <td>2.54</td>\n",
              "      <td>14.41</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>삼기 *</td>\n",
              "      <td>5330.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>-5.33%</td>\n",
              "      <td>2043.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.83</td>\n",
              "      <td>-14.44</td>\n",
              "      <td>-5.61</td>\n",
              "      <td>1.62</td>\n",
              "      <td>14.44</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>현대차</td>\n",
              "      <td>207500.0</td>\n",
              "      <td>2500.0</td>\n",
              "      <td>-1.19%</td>\n",
              "      <td>443361.0</td>\n",
              "      <td>3000.0</td>\n",
              "      <td>28.54</td>\n",
              "      <td>15.03</td>\n",
              "      <td>2.04</td>\n",
              "      <td>0.74</td>\n",
              "      <td>15.03</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>코오롱머티리얼</td>\n",
              "      <td>3075.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.00%</td>\n",
              "      <td>2111.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.90</td>\n",
              "      <td>-15.22</td>\n",
              "      <td>-21.40</td>\n",
              "      <td>3.81</td>\n",
              "      <td>15.22</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>코오롱인더</td>\n",
              "      <td>81800.0</td>\n",
              "      <td>5300.0</td>\n",
              "      <td>+6.93%</td>\n",
              "      <td>22069.0</td>\n",
              "      <td>1000.0</td>\n",
              "      <td>21.30</td>\n",
              "      <td>16.38</td>\n",
              "      <td>9.70</td>\n",
              "      <td>1.04</td>\n",
              "      <td>16.38</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>에코바이오 *</td>\n",
              "      <td>9160.0</td>\n",
              "      <td>440.0</td>\n",
              "      <td>+5.05%</td>\n",
              "      <td>1064.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.31</td>\n",
              "      <td>16.53</td>\n",
              "      <td>8.42</td>\n",
              "      <td>1.54</td>\n",
              "      <td>16.53</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>SK</td>\n",
              "      <td>261000.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>-0.19%</td>\n",
              "      <td>183640.0</td>\n",
              "      <td>7000.0</td>\n",
              "      <td>19.54</td>\n",
              "      <td>16.85</td>\n",
              "      <td>1.11</td>\n",
              "      <td>0.69</td>\n",
              "      <td>16.85</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>효성중공업</td>\n",
              "      <td>74700.0</td>\n",
              "      <td>3700.0</td>\n",
              "      <td>+5.21%</td>\n",
              "      <td>6965.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6.99</td>\n",
              "      <td>17.97</td>\n",
              "      <td>-2.48</td>\n",
              "      <td>0.76</td>\n",
              "      <td>17.97</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>효성첨단소재</td>\n",
              "      <td>598000.0</td>\n",
              "      <td>21000.0</td>\n",
              "      <td>+3.64%</td>\n",
              "      <td>26790.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>11.58</td>\n",
              "      <td>18.22</td>\n",
              "      <td>0.03</td>\n",
              "      <td>5.96</td>\n",
              "      <td>18.22</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>성창오토텍 *</td>\n",
              "      <td>10150.0</td>\n",
              "      <td>310.0</td>\n",
              "      <td>+3.15%</td>\n",
              "      <td>741.0</td>\n",
              "      <td>50.0</td>\n",
              "      <td>2.81</td>\n",
              "      <td>18.97</td>\n",
              "      <td>2.18</td>\n",
              "      <td>1.83</td>\n",
              "      <td>18.97</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>진성티이씨 *</td>\n",
              "      <td>14100.0</td>\n",
              "      <td>450.0</td>\n",
              "      <td>+3.30%</td>\n",
              "      <td>3170.0</td>\n",
              "      <td>200.0</td>\n",
              "      <td>4.39</td>\n",
              "      <td>19.29</td>\n",
              "      <td>10.48</td>\n",
              "      <td>1.80</td>\n",
              "      <td>19.29</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>조광ILI *</td>\n",
              "      <td>8670.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>-0.12%</td>\n",
              "      <td>1201.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.71</td>\n",
              "      <td>-20.35</td>\n",
              "      <td>-5.64</td>\n",
              "      <td>1.34</td>\n",
              "      <td>20.35</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>동아화성 *</td>\n",
              "      <td>16000.0</td>\n",
              "      <td>550.0</td>\n",
              "      <td>+3.56%</td>\n",
              "      <td>2528.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>0.95</td>\n",
              "      <td>20.36</td>\n",
              "      <td>2.28</td>\n",
              "      <td>1.91</td>\n",
              "      <td>20.36</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>우리산업 *</td>\n",
              "      <td>21950.0</td>\n",
              "      <td>850.0</td>\n",
              "      <td>+4.03%</td>\n",
              "      <td>2004.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>3.95</td>\n",
              "      <td>20.53</td>\n",
              "      <td>4.53</td>\n",
              "      <td>1.63</td>\n",
              "      <td>20.53</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>신도기연 *</td>\n",
              "      <td>15300.0</td>\n",
              "      <td>200.0</td>\n",
              "      <td>+1.32%</td>\n",
              "      <td>1233.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.16</td>\n",
              "      <td>-20.84</td>\n",
              "      <td>-8.05</td>\n",
              "      <td>1.88</td>\n",
              "      <td>20.84</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>LS ELECTRIC</td>\n",
              "      <td>66400.0</td>\n",
              "      <td>1800.0</td>\n",
              "      <td>+2.79%</td>\n",
              "      <td>19920.0</td>\n",
              "      <td>1100.0</td>\n",
              "      <td>17.06</td>\n",
              "      <td>21.71</td>\n",
              "      <td>6.15</td>\n",
              "      <td>1.36</td>\n",
              "      <td>21.71</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>모토닉</td>\n",
              "      <td>11150.0</td>\n",
              "      <td>650.0</td>\n",
              "      <td>+6.19%</td>\n",
              "      <td>3680.0</td>\n",
              "      <td>400.0</td>\n",
              "      <td>10.93</td>\n",
              "      <td>22.85</td>\n",
              "      <td>3.61</td>\n",
              "      <td>0.59</td>\n",
              "      <td>22.85</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>유니크 *</td>\n",
              "      <td>8150.0</td>\n",
              "      <td>490.0</td>\n",
              "      <td>+6.40%</td>\n",
              "      <td>1575.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.69</td>\n",
              "      <td>23.49</td>\n",
              "      <td>-3.92</td>\n",
              "      <td>1.48</td>\n",
              "      <td>23.49</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>풍국주정 *</td>\n",
              "      <td>18500.0</td>\n",
              "      <td>1050.0</td>\n",
              "      <td>+6.02%</td>\n",
              "      <td>2331.0</td>\n",
              "      <td>180.0</td>\n",
              "      <td>1.18</td>\n",
              "      <td>25.07</td>\n",
              "      <td>5.98</td>\n",
              "      <td>1.63</td>\n",
              "      <td>25.07</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>세종공업</td>\n",
              "      <td>11050.0</td>\n",
              "      <td>600.0</td>\n",
              "      <td>+5.74%</td>\n",
              "      <td>3074.0</td>\n",
              "      <td>50.0</td>\n",
              "      <td>1.90</td>\n",
              "      <td>25.40</td>\n",
              "      <td>-4.69</td>\n",
              "      <td>0.72</td>\n",
              "      <td>25.40</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>삼화전자</td>\n",
              "      <td>3915.0</td>\n",
              "      <td>145.0</td>\n",
              "      <td>+3.85%</td>\n",
              "      <td>409.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6.81</td>\n",
              "      <td>-25.59</td>\n",
              "      <td>-19.35</td>\n",
              "      <td>4.74</td>\n",
              "      <td>25.59</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>미코 *</td>\n",
              "      <td>15000.0</td>\n",
              "      <td>200.0</td>\n",
              "      <td>+1.35%</td>\n",
              "      <td>4918.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>5.41</td>\n",
              "      <td>26.32</td>\n",
              "      <td>11.34</td>\n",
              "      <td>2.73</td>\n",
              "      <td>26.32</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>아이에이 *</td>\n",
              "      <td>1110.0</td>\n",
              "      <td>20.0</td>\n",
              "      <td>+1.83%</td>\n",
              "      <td>3272.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.61</td>\n",
              "      <td>26.43</td>\n",
              "      <td>17.35</td>\n",
              "      <td>3.17</td>\n",
              "      <td>26.43</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>현대제철</td>\n",
              "      <td>48250.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>-0.21%</td>\n",
              "      <td>64388.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>20.60</td>\n",
              "      <td>26.66</td>\n",
              "      <td>-2.59</td>\n",
              "      <td>0.37</td>\n",
              "      <td>26.66</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>글로벌에스엠 *</td>\n",
              "      <td>1200.0</td>\n",
              "      <td>50.0</td>\n",
              "      <td>+4.35%</td>\n",
              "      <td>645.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4.93</td>\n",
              "      <td>26.67</td>\n",
              "      <td>1.75</td>\n",
              "      <td>0.74</td>\n",
              "      <td>26.67</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>시노펙스 *</td>\n",
              "      <td>3630.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>-0.82%</td>\n",
              "      <td>2659.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.89</td>\n",
              "      <td>-27.09</td>\n",
              "      <td>-11.27</td>\n",
              "      <td>3.51</td>\n",
              "      <td>27.09</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>디와이</td>\n",
              "      <td>5720.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>+1.78%</td>\n",
              "      <td>1505.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>10.76</td>\n",
              "      <td>-31.60</td>\n",
              "      <td>-3.39</td>\n",
              "      <td>0.40</td>\n",
              "      <td>31.60</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>평화산업</td>\n",
              "      <td>1945.0</td>\n",
              "      <td>350.0</td>\n",
              "      <td>+21.94%</td>\n",
              "      <td>1068.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.41</td>\n",
              "      <td>38.90</td>\n",
              "      <td>-26.40</td>\n",
              "      <td>3.42</td>\n",
              "      <td>38.90</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>대원강업</td>\n",
              "      <td>4330.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>+0.70%</td>\n",
              "      <td>2685.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>2.24</td>\n",
              "      <td>39.36</td>\n",
              "      <td>-1.36</td>\n",
              "      <td>0.57</td>\n",
              "      <td>39.36</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>인지컨트롤스</td>\n",
              "      <td>15100.0</td>\n",
              "      <td>850.0</td>\n",
              "      <td>+5.96%</td>\n",
              "      <td>2289.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>2.57</td>\n",
              "      <td>41.94</td>\n",
              "      <td>-1.77</td>\n",
              "      <td>1.18</td>\n",
              "      <td>41.94</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>지엠비코리아</td>\n",
              "      <td>7020.0</td>\n",
              "      <td>560.0</td>\n",
              "      <td>+8.67%</td>\n",
              "      <td>1339.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>55.80</td>\n",
              "      <td>50.14</td>\n",
              "      <td>-3.69</td>\n",
              "      <td>0.59</td>\n",
              "      <td>50.14</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>비나텍 *</td>\n",
              "      <td>54000.0</td>\n",
              "      <td>2000.0</td>\n",
              "      <td>+3.85%</td>\n",
              "      <td>2777.0</td>\n",
              "      <td>24.0</td>\n",
              "      <td>1.10</td>\n",
              "      <td>54.44</td>\n",
              "      <td>14.83</td>\n",
              "      <td>5.95</td>\n",
              "      <td>54.44</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>동양피스톤</td>\n",
              "      <td>7320.0</td>\n",
              "      <td>240.0</td>\n",
              "      <td>+3.39%</td>\n",
              "      <td>964.0</td>\n",
              "      <td>60.0</td>\n",
              "      <td>0.63</td>\n",
              "      <td>54.63</td>\n",
              "      <td>-7.29</td>\n",
              "      <td>0.90</td>\n",
              "      <td>54.63</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50</th>\n",
              "      <td>대우부품</td>\n",
              "      <td>2555.0</td>\n",
              "      <td>125.0</td>\n",
              "      <td>+5.14%</td>\n",
              "      <td>1217.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.84</td>\n",
              "      <td>-58.07</td>\n",
              "      <td>-10.09</td>\n",
              "      <td>3.34</td>\n",
              "      <td>58.07</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>51</th>\n",
              "      <td>제이엔케이히터 *</td>\n",
              "      <td>6920.0</td>\n",
              "      <td>580.0</td>\n",
              "      <td>+9.15%</td>\n",
              "      <td>1606.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.48</td>\n",
              "      <td>63.49</td>\n",
              "      <td>2.27</td>\n",
              "      <td>1.53</td>\n",
              "      <td>63.49</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>52</th>\n",
              "      <td>한온시스템</td>\n",
              "      <td>16200.0</td>\n",
              "      <td>50.0</td>\n",
              "      <td>-0.31%</td>\n",
              "      <td>86476.0</td>\n",
              "      <td>320.0</td>\n",
              "      <td>17.91</td>\n",
              "      <td>64.03</td>\n",
              "      <td>5.09</td>\n",
              "      <td>4.01</td>\n",
              "      <td>64.03</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>53</th>\n",
              "      <td>성문전자</td>\n",
              "      <td>2535.0</td>\n",
              "      <td>55.0</td>\n",
              "      <td>+2.22%</td>\n",
              "      <td>494.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4.95</td>\n",
              "      <td>79.22</td>\n",
              "      <td>-3.63</td>\n",
              "      <td>1.68</td>\n",
              "      <td>79.22</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>54</th>\n",
              "      <td>현대로템</td>\n",
              "      <td>25950.0</td>\n",
              "      <td>250.0</td>\n",
              "      <td>+0.97%</td>\n",
              "      <td>28322.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.50</td>\n",
              "      <td>83.44</td>\n",
              "      <td>2.84</td>\n",
              "      <td>2.04</td>\n",
              "      <td>83.44</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>55</th>\n",
              "      <td>이엠코리아 *</td>\n",
              "      <td>4895.0</td>\n",
              "      <td>210.0</td>\n",
              "      <td>+4.48%</td>\n",
              "      <td>2084.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.84</td>\n",
              "      <td>-94.13</td>\n",
              "      <td>-3.05</td>\n",
              "      <td>2.36</td>\n",
              "      <td>94.13</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>56</th>\n",
              "      <td>디아이티 *</td>\n",
              "      <td>11000.0</td>\n",
              "      <td>200.0</td>\n",
              "      <td>-1.79%</td>\n",
              "      <td>2079.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.03</td>\n",
              "      <td>96.49</td>\n",
              "      <td>0.87</td>\n",
              "      <td>1.17</td>\n",
              "      <td>96.49</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>57</th>\n",
              "      <td>일진다이아</td>\n",
              "      <td>49800.0</td>\n",
              "      <td>700.0</td>\n",
              "      <td>+1.43%</td>\n",
              "      <td>7073.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>2.07</td>\n",
              "      <td>102.05</td>\n",
              "      <td>2.88</td>\n",
              "      <td>3.85</td>\n",
              "      <td>102.05</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>58</th>\n",
              "      <td>EG *</td>\n",
              "      <td>11650.0</td>\n",
              "      <td>200.0</td>\n",
              "      <td>+1.75%</td>\n",
              "      <td>874.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2.00</td>\n",
              "      <td>-106.88</td>\n",
              "      <td>-10.36</td>\n",
              "      <td>1.82</td>\n",
              "      <td>106.88</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>59</th>\n",
              "      <td>국일제지 *</td>\n",
              "      <td>5250.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>+0.57%</td>\n",
              "      <td>6700.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2.75</td>\n",
              "      <td>-128.05</td>\n",
              "      <td>-0.84</td>\n",
              "      <td>9.89</td>\n",
              "      <td>128.05</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>60</th>\n",
              "      <td>우수AMS *</td>\n",
              "      <td>5400.0</td>\n",
              "      <td>280.0</td>\n",
              "      <td>+5.47%</td>\n",
              "      <td>1923.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.43</td>\n",
              "      <td>-131.71</td>\n",
              "      <td>-10.33</td>\n",
              "      <td>2.19</td>\n",
              "      <td>131.71</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>61</th>\n",
              "      <td>뉴인텍 *</td>\n",
              "      <td>3975.0</td>\n",
              "      <td>135.0</td>\n",
              "      <td>+3.52%</td>\n",
              "      <td>1194.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.79</td>\n",
              "      <td>132.50</td>\n",
              "      <td>1.46</td>\n",
              "      <td>4.20</td>\n",
              "      <td>132.50</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>62</th>\n",
              "      <td>엔케이</td>\n",
              "      <td>1165.0</td>\n",
              "      <td>45.0</td>\n",
              "      <td>+4.02%</td>\n",
              "      <td>932.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.56</td>\n",
              "      <td>145.62</td>\n",
              "      <td>-0.03</td>\n",
              "      <td>1.03</td>\n",
              "      <td>145.62</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>63</th>\n",
              "      <td>영화테크 *</td>\n",
              "      <td>18350.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>-1.61%</td>\n",
              "      <td>1962.0</td>\n",
              "      <td>25.0</td>\n",
              "      <td>0.00</td>\n",
              "      <td>152.92</td>\n",
              "      <td>0.90</td>\n",
              "      <td>3.93</td>\n",
              "      <td>152.92</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>64</th>\n",
              "      <td>에스퓨얼셀 *</td>\n",
              "      <td>35900.0</td>\n",
              "      <td>2150.0</td>\n",
              "      <td>+6.37%</td>\n",
              "      <td>2468.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>4.81</td>\n",
              "      <td>161.71</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.77</td>\n",
              "      <td>161.71</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>65</th>\n",
              "      <td>디케이락 *</td>\n",
              "      <td>12450.0</td>\n",
              "      <td>950.0</td>\n",
              "      <td>+8.26%</td>\n",
              "      <td>1052.0</td>\n",
              "      <td>150.0</td>\n",
              "      <td>1.91</td>\n",
              "      <td>214.66</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.12</td>\n",
              "      <td>214.66</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>66</th>\n",
              "      <td>유일에너테크 *</td>\n",
              "      <td>18900.0</td>\n",
              "      <td>650.0</td>\n",
              "      <td>+3.56%</td>\n",
              "      <td>2002.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.13</td>\n",
              "      <td>248.68</td>\n",
              "      <td>30.63</td>\n",
              "      <td>4.13</td>\n",
              "      <td>248.68</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>67</th>\n",
              "      <td>상아프론테크 *</td>\n",
              "      <td>69800.0</td>\n",
              "      <td>2400.0</td>\n",
              "      <td>+3.56%</td>\n",
              "      <td>10976.0</td>\n",
              "      <td>160.0</td>\n",
              "      <td>3.43</td>\n",
              "      <td>396.59</td>\n",
              "      <td>1.58</td>\n",
              "      <td>6.73</td>\n",
              "      <td>396.59</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>68</th>\n",
              "      <td>두산퓨얼셀</td>\n",
              "      <td>51700.0</td>\n",
              "      <td>2300.0</td>\n",
              "      <td>+4.66%</td>\n",
              "      <td>33860.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12.23</td>\n",
              "      <td>861.67</td>\n",
              "      <td>4.18</td>\n",
              "      <td>8.32</td>\n",
              "      <td>861.67</td>\n",
              "      <td>수소차(연료전지_부품_충전소 등)</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "            종목명       현재가      전일비  ...   PBR  PER_abs                  분야\n",
              "0         뉴로스 *    2230.0      0.0  ...  1.63     0.89  수소차(연료전지_부품_충전소 등)\n",
              "1         UCI *     445.0      0.0  ...  0.78     1.14  수소차(연료전지_부품_충전소 등)\n",
              "2       에스에너지 *    4215.0     65.0  ...  0.67     3.14  수소차(연료전지_부품_충전소 등)\n",
              "3        에스코넥 *    2055.0     75.0  ...  2.70     4.40  수소차(연료전지_부품_충전소 등)\n",
              "4         평화홀딩스    5240.0    600.0  ...  0.63     7.01  수소차(연료전지_부품_충전소 등)\n",
              "5          세원 *    4650.0    135.0  ...  1.95     7.94  수소차(연료전지_부품_충전소 등)\n",
              "6         엘티씨 *   11000.0    300.0  ...  1.00     8.91  수소차(연료전지_부품_충전소 등)\n",
              "7        일지테크 *    4340.0    155.0  ...  0.53     9.25  수소차(연료전지_부품_충전소 등)\n",
              "8            기아   82100.0    100.0  ...  1.02     9.58  수소차(연료전지_부품_충전소 등)\n",
              "9         한화솔루션   40800.0   1100.0  ...  0.97    10.12  수소차(연료전지_부품_충전소 등)\n",
              "10       STX중공업    5800.0     50.0  ...  1.05    10.18  수소차(연료전지_부품_충전소 등)\n",
              "11       코웰패션 *    8030.0     10.0  ...  1.66    11.06  수소차(연료전지_부품_충전소 등)\n",
              "12          삼양사   62800.0      0.0  ...  0.51    11.20  수소차(연료전지_부품_충전소 등)\n",
              "13        현대모비스  269500.0   2500.0  ...  0.72    11.56  수소차(연료전지_부품_충전소 등)\n",
              "14    원익머트리얼즈 *   34850.0   1150.0  ...  1.26    12.20  수소차(연료전지_부품_충전소 등)\n",
              "15      삼보모터스 *    6720.0    310.0  ...  0.55    12.29  수소차(연료전지_부품_충전소 등)\n",
              "16       SNT모티브   54200.0    700.0  ...  0.92    12.41  수소차(연료전지_부품_충전소 등)\n",
              "17         효성화학  402000.0   4000.0  ...  2.54    14.41  수소차(연료전지_부품_충전소 등)\n",
              "18         삼기 *    5330.0    300.0  ...  1.62    14.44  수소차(연료전지_부품_충전소 등)\n",
              "19          현대차  207500.0   2500.0  ...  0.74    15.03  수소차(연료전지_부품_충전소 등)\n",
              "20      코오롱머티리얼    3075.0      0.0  ...  3.81    15.22  수소차(연료전지_부품_충전소 등)\n",
              "21        코오롱인더   81800.0   5300.0  ...  1.04    16.38  수소차(연료전지_부품_충전소 등)\n",
              "22      에코바이오 *    9160.0    440.0  ...  1.54    16.53  수소차(연료전지_부품_충전소 등)\n",
              "23           SK  261000.0    500.0  ...  0.69    16.85  수소차(연료전지_부품_충전소 등)\n",
              "24        효성중공업   74700.0   3700.0  ...  0.76    17.97  수소차(연료전지_부품_충전소 등)\n",
              "25       효성첨단소재  598000.0  21000.0  ...  5.96    18.22  수소차(연료전지_부품_충전소 등)\n",
              "26      성창오토텍 *   10150.0    310.0  ...  1.83    18.97  수소차(연료전지_부품_충전소 등)\n",
              "27      진성티이씨 *   14100.0    450.0  ...  1.80    19.29  수소차(연료전지_부품_충전소 등)\n",
              "28      조광ILI *    8670.0     10.0  ...  1.34    20.35  수소차(연료전지_부품_충전소 등)\n",
              "29       동아화성 *   16000.0    550.0  ...  1.91    20.36  수소차(연료전지_부품_충전소 등)\n",
              "30       우리산업 *   21950.0    850.0  ...  1.63    20.53  수소차(연료전지_부품_충전소 등)\n",
              "31       신도기연 *   15300.0    200.0  ...  1.88    20.84  수소차(연료전지_부품_충전소 등)\n",
              "32  LS ELECTRIC   66400.0   1800.0  ...  1.36    21.71  수소차(연료전지_부품_충전소 등)\n",
              "33          모토닉   11150.0    650.0  ...  0.59    22.85  수소차(연료전지_부품_충전소 등)\n",
              "34        유니크 *    8150.0    490.0  ...  1.48    23.49  수소차(연료전지_부품_충전소 등)\n",
              "35       풍국주정 *   18500.0   1050.0  ...  1.63    25.07  수소차(연료전지_부품_충전소 등)\n",
              "36         세종공업   11050.0    600.0  ...  0.72    25.40  수소차(연료전지_부품_충전소 등)\n",
              "37         삼화전자    3915.0    145.0  ...  4.74    25.59  수소차(연료전지_부품_충전소 등)\n",
              "38         미코 *   15000.0    200.0  ...  2.73    26.32  수소차(연료전지_부품_충전소 등)\n",
              "39       아이에이 *    1110.0     20.0  ...  3.17    26.43  수소차(연료전지_부품_충전소 등)\n",
              "40         현대제철   48250.0    100.0  ...  0.37    26.66  수소차(연료전지_부품_충전소 등)\n",
              "41     글로벌에스엠 *    1200.0     50.0  ...  0.74    26.67  수소차(연료전지_부품_충전소 등)\n",
              "42       시노펙스 *    3630.0     30.0  ...  3.51    27.09  수소차(연료전지_부품_충전소 등)\n",
              "43          디와이    5720.0    100.0  ...  0.40    31.60  수소차(연료전지_부품_충전소 등)\n",
              "44         평화산업    1945.0    350.0  ...  3.42    38.90  수소차(연료전지_부품_충전소 등)\n",
              "45         대원강업    4330.0     30.0  ...  0.57    39.36  수소차(연료전지_부품_충전소 등)\n",
              "46       인지컨트롤스   15100.0    850.0  ...  1.18    41.94  수소차(연료전지_부품_충전소 등)\n",
              "47       지엠비코리아    7020.0    560.0  ...  0.59    50.14  수소차(연료전지_부품_충전소 등)\n",
              "48        비나텍 *   54000.0   2000.0  ...  5.95    54.44  수소차(연료전지_부품_충전소 등)\n",
              "49        동양피스톤    7320.0    240.0  ...  0.90    54.63  수소차(연료전지_부품_충전소 등)\n",
              "50         대우부품    2555.0    125.0  ...  3.34    58.07  수소차(연료전지_부품_충전소 등)\n",
              "51    제이엔케이히터 *    6920.0    580.0  ...  1.53    63.49  수소차(연료전지_부품_충전소 등)\n",
              "52        한온시스템   16200.0     50.0  ...  4.01    64.03  수소차(연료전지_부품_충전소 등)\n",
              "53         성문전자    2535.0     55.0  ...  1.68    79.22  수소차(연료전지_부품_충전소 등)\n",
              "54         현대로템   25950.0    250.0  ...  2.04    83.44  수소차(연료전지_부품_충전소 등)\n",
              "55      이엠코리아 *    4895.0    210.0  ...  2.36    94.13  수소차(연료전지_부품_충전소 등)\n",
              "56       디아이티 *   11000.0    200.0  ...  1.17    96.49  수소차(연료전지_부품_충전소 등)\n",
              "57        일진다이아   49800.0    700.0  ...  3.85   102.05  수소차(연료전지_부품_충전소 등)\n",
              "58         EG *   11650.0    200.0  ...  1.82   106.88  수소차(연료전지_부품_충전소 등)\n",
              "59       국일제지 *    5250.0     30.0  ...  9.89   128.05  수소차(연료전지_부품_충전소 등)\n",
              "60      우수AMS *    5400.0    280.0  ...  2.19   131.71  수소차(연료전지_부품_충전소 등)\n",
              "61        뉴인텍 *    3975.0    135.0  ...  4.20   132.50  수소차(연료전지_부품_충전소 등)\n",
              "62          엔케이    1165.0     45.0  ...  1.03   145.62  수소차(연료전지_부품_충전소 등)\n",
              "63       영화테크 *   18350.0    300.0  ...  3.93   152.92  수소차(연료전지_부품_충전소 등)\n",
              "64      에스퓨얼셀 *   35900.0   2150.0  ...  3.77   161.71  수소차(연료전지_부품_충전소 등)\n",
              "65       디케이락 *   12450.0    950.0  ...  1.12   214.66  수소차(연료전지_부품_충전소 등)\n",
              "66     유일에너테크 *   18900.0    650.0  ...  4.13   248.68  수소차(연료전지_부품_충전소 등)\n",
              "67     상아프론테크 *   69800.0   2400.0  ...  6.73   396.59  수소차(연료전지_부품_충전소 등)\n",
              "68        두산퓨얼셀   51700.0   2300.0  ...  8.32   861.67  수소차(연료전지_부품_충전소 등)\n",
              "\n",
              "[69 rows x 12 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "IneaIMwwM5Yk"
      },
      "source": [
        "# res = requests.get('https://finance.naver.com/sise/sise_group_detail.nhn?type=theme&no=188')\n",
        "# soup = BeautifulSoup(res.text, 'html.parser')\n",
        "# table_tag = soup.find_all('table')[2]\n",
        "\n",
        "# stock_df = pd.read_html(table_tag.prettify())[0].iloc[1:, :-2]\n",
        "# stock_df"
      ],
      "execution_count": 4,
      "outputs": []
    }
  ]
}