누락찾기V3.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/wkd-woo/finance-statements/blob/main/%EB%88%84%EB%9D%BD%EC%B0%BE%EA%B8%B0V3.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "w0DqBUtZeVkw",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "49d80c80-a722-4e46-f957-e3370e1db1a1"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Requirement already satisfied: finance-datareader in /usr/local/lib/python3.7/dist-packages (0.9.33)\n",
            "Requirement already satisfied: pandas>=0.19.2 in /usr/local/lib/python3.7/dist-packages (from finance-datareader) (1.3.5)\n",
            "Requirement already satisfied: requests>=2.3.0 in /usr/local/lib/python3.7/dist-packages (from finance-datareader) (2.23.0)\n",
            "Requirement already satisfied: lxml in /usr/local/lib/python3.7/dist-packages (from finance-datareader) (4.2.6)\n",
            "Requirement already satisfied: tqdm in /usr/local/lib/python3.7/dist-packages (from finance-datareader) (4.64.0)\n",
            "Requirement already satisfied: requests-file in /usr/local/lib/python3.7/dist-packages (from finance-datareader) (1.5.1)\n",
            "Requirement already satisfied: python-dateutil>=2.7.3 in /usr/local/lib/python3.7/dist-packages (from pandas>=0.19.2->finance-datareader) (2.8.2)\n",
            "Requirement already satisfied: pytz>=2017.3 in /usr/local/lib/python3.7/dist-packages (from pandas>=0.19.2->finance-datareader) (2022.1)\n",
            "Requirement already satisfied: numpy>=1.17.3 in /usr/local/lib/python3.7/dist-packages (from pandas>=0.19.2->finance-datareader) (1.21.6)\n",
            "Requirement already satisfied: six>=1.5 in /usr/local/lib/python3.7/dist-packages (from python-dateutil>=2.7.3->pandas>=0.19.2->finance-datareader) (1.15.0)\n",
            "Requirement already satisfied: idna<3,>=2.5 in /usr/local/lib/python3.7/dist-packages (from requests>=2.3.0->finance-datareader) (2.10)\n",
            "Requirement already satisfied: urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1 in /usr/local/lib/python3.7/dist-packages (from requests>=2.3.0->finance-datareader) (1.24.3)\n",
            "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.7/dist-packages (from requests>=2.3.0->finance-datareader) (2021.10.8)\n",
            "Requirement already satisfied: chardet<4,>=3.0.2 in /usr/local/lib/python3.7/dist-packages (from requests>=2.3.0->finance-datareader) (3.0.4)\n"
          ]
        }
      ],
      "source": [
        "!pip install -U finance-datareader\n",
        "import pandas as pd\n",
        "import numpy as np\n",
        "import os\n",
        "from tqdm import tqdm\n",
        "import FinanceDataReader as fdr"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "DoZj5O_E-oW2"
      },
      "outputs": [],
      "source": [
        "통합재무정보 = pd.read_csv('/content/drive/MyDrive/22캡스톤디자인/재무일괄/일괄/statements.csv', index_col = 0,  dtype={'종목코드':'str'})"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "통합재무정보"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "dHcMjN5KrS32",
        "outputId": "2e4d4315-b056-4122-ecb7-45ce6c128ec1"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         종목코드  사업연도   보고서종류             자산총계             자본총계       자본총계(비지배)  \\\n",
              "0      060310  2021  3분기보고서   65,694,406,823   39,604,250,285     346,899,422   \n",
              "1      060310  2021  1분기보고서   57,532,354,433   37,025,096,733     160,552,033   \n",
              "2      060310  2021   반기보고서   60,945,473,913   38,562,631,695     376,862,566   \n",
              "3      060310  2015   사업보고서   67,359,971,696   37,939,808,456               0   \n",
              "4      060310  2016  3분기보고서   59,740,105,216   35,061,777,226               0   \n",
              "...       ...   ...     ...              ...              ...             ...   \n",
              "38264  065650  2020   사업보고서   47,217,129,660   27,856,442,820               0   \n",
              "38265  262840  2020   사업보고서   29,801,051,915   20,070,268,768               0   \n",
              "38266  377190  2021   반기보고서  757,741,121,157  325,909,527,744  14,329,183,694   \n",
              "38267  334890  2021   반기보고서  228,778,760,058  214,552,741,756               0   \n",
              "38268  104120  2016  3분기보고서  255,486,354,454   59,431,048,872               0   \n",
              "\n",
              "                  부채총계             유동자산           당기순이익   당기순이익(비지배)  \\\n",
              "0       26,090,156,538   28,475,453,922   2,141,910,533  168,854,904   \n",
              "1       20,507,257,700   19,475,037,181    -362,882,021   13,036,456   \n",
              "2       22,382,842,218   23,161,861,807   1,119,822,996  200,255,460   \n",
              "3       29,420,163,240   16,069,077,218  -5,599,032,927            0   \n",
              "4       24,678,327,990   17,985,342,311  -2,606,151,383            0   \n",
              "...                ...              ...             ...          ...   \n",
              "38264   19,360,686,840   22,416,360,010  -3,521,169,069            0   \n",
              "38265    9,730,783,147   22,896,651,019   5,137,807,654            0   \n",
              "38266  431,831,593,413   21,431,619,143   2,150,044,521  154,836,078   \n",
              "38267   14,226,018,302   44,761,246,058               0            0   \n",
              "38268  196,055,305,582  205,728,877,349     954,976,851            0   \n",
              "\n",
              "                   매출액        현금및현금성자산 감가상각비            영업이익           매출총이익  \n",
              "0       18,062,116,780   6,020,012,116     0   2,022,128,462   4,340,642,679  \n",
              "1        3,775,878,119   5,475,587,054     0    -281,517,202     509,620,804  \n",
              "2       11,420,086,693   4,980,950,161     0   1,056,624,172   2,578,306,966  \n",
              "3       23,210,541,648   7,018,117,223     0  -4,157,989,321   1,635,010,587  \n",
              "4       21,181,410,272   5,527,274,547     0  -1,932,287,661   1,334,171,193  \n",
              "...                ...             ...   ...             ...             ...  \n",
              "38264   31,414,836,428  13,398,903,686     0  -2,164,891,445   4,268,763,353  \n",
              "38265   15,270,479,176     903,083,315     0   4,875,659,090  10,171,194,384  \n",
              "38266                0  16,735,028,669     0   4,865,784,111   9,201,108,120  \n",
              "38267    4,461,311,000  29,757,021,097     0   4,160,253,012               0  \n",
              "38268  236,677,115,740  13,315,775,028     0  10,545,813,943  29,853,342,376  \n",
              "\n",
              "[38269 rows x 15 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-e82ab2ff-9a38-4035-97b5-7724bc8dce3d\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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",
              "      <th>영업이익</th>\n",
              "      <th>매출총이익</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>060310</td>\n",
              "      <td>2021</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>65,694,406,823</td>\n",
              "      <td>39,604,250,285</td>\n",
              "      <td>346,899,422</td>\n",
              "      <td>26,090,156,538</td>\n",
              "      <td>28,475,453,922</td>\n",
              "      <td>2,141,910,533</td>\n",
              "      <td>168,854,904</td>\n",
              "      <td>18,062,116,780</td>\n",
              "      <td>6,020,012,116</td>\n",
              "      <td>0</td>\n",
              "      <td>2,022,128,462</td>\n",
              "      <td>4,340,642,679</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>060310</td>\n",
              "      <td>2021</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>57,532,354,433</td>\n",
              "      <td>37,025,096,733</td>\n",
              "      <td>160,552,033</td>\n",
              "      <td>20,507,257,700</td>\n",
              "      <td>19,475,037,181</td>\n",
              "      <td>-362,882,021</td>\n",
              "      <td>13,036,456</td>\n",
              "      <td>3,775,878,119</td>\n",
              "      <td>5,475,587,054</td>\n",
              "      <td>0</td>\n",
              "      <td>-281,517,202</td>\n",
              "      <td>509,620,804</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>060310</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>60,945,473,913</td>\n",
              "      <td>38,562,631,695</td>\n",
              "      <td>376,862,566</td>\n",
              "      <td>22,382,842,218</td>\n",
              "      <td>23,161,861,807</td>\n",
              "      <td>1,119,822,996</td>\n",
              "      <td>200,255,460</td>\n",
              "      <td>11,420,086,693</td>\n",
              "      <td>4,980,950,161</td>\n",
              "      <td>0</td>\n",
              "      <td>1,056,624,172</td>\n",
              "      <td>2,578,306,966</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>060310</td>\n",
              "      <td>2015</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>67,359,971,696</td>\n",
              "      <td>37,939,808,456</td>\n",
              "      <td>0</td>\n",
              "      <td>29,420,163,240</td>\n",
              "      <td>16,069,077,218</td>\n",
              "      <td>-5,599,032,927</td>\n",
              "      <td>0</td>\n",
              "      <td>23,210,541,648</td>\n",
              "      <td>7,018,117,223</td>\n",
              "      <td>0</td>\n",
              "      <td>-4,157,989,321</td>\n",
              "      <td>1,635,010,587</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>060310</td>\n",
              "      <td>2016</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>59,740,105,216</td>\n",
              "      <td>35,061,777,226</td>\n",
              "      <td>0</td>\n",
              "      <td>24,678,327,990</td>\n",
              "      <td>17,985,342,311</td>\n",
              "      <td>-2,606,151,383</td>\n",
              "      <td>0</td>\n",
              "      <td>21,181,410,272</td>\n",
              "      <td>5,527,274,547</td>\n",
              "      <td>0</td>\n",
              "      <td>-1,932,287,661</td>\n",
              "      <td>1,334,171,193</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",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38264</th>\n",
              "      <td>065650</td>\n",
              "      <td>2020</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>47,217,129,660</td>\n",
              "      <td>27,856,442,820</td>\n",
              "      <td>0</td>\n",
              "      <td>19,360,686,840</td>\n",
              "      <td>22,416,360,010</td>\n",
              "      <td>-3,521,169,069</td>\n",
              "      <td>0</td>\n",
              "      <td>31,414,836,428</td>\n",
              "      <td>13,398,903,686</td>\n",
              "      <td>0</td>\n",
              "      <td>-2,164,891,445</td>\n",
              "      <td>4,268,763,353</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38265</th>\n",
              "      <td>262840</td>\n",
              "      <td>2020</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>29,801,051,915</td>\n",
              "      <td>20,070,268,768</td>\n",
              "      <td>0</td>\n",
              "      <td>9,730,783,147</td>\n",
              "      <td>22,896,651,019</td>\n",
              "      <td>5,137,807,654</td>\n",
              "      <td>0</td>\n",
              "      <td>15,270,479,176</td>\n",
              "      <td>903,083,315</td>\n",
              "      <td>0</td>\n",
              "      <td>4,875,659,090</td>\n",
              "      <td>10,171,194,384</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38266</th>\n",
              "      <td>377190</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>757,741,121,157</td>\n",
              "      <td>325,909,527,744</td>\n",
              "      <td>14,329,183,694</td>\n",
              "      <td>431,831,593,413</td>\n",
              "      <td>21,431,619,143</td>\n",
              "      <td>2,150,044,521</td>\n",
              "      <td>154,836,078</td>\n",
              "      <td>0</td>\n",
              "      <td>16,735,028,669</td>\n",
              "      <td>0</td>\n",
              "      <td>4,865,784,111</td>\n",
              "      <td>9,201,108,120</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38267</th>\n",
              "      <td>334890</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>228,778,760,058</td>\n",
              "      <td>214,552,741,756</td>\n",
              "      <td>0</td>\n",
              "      <td>14,226,018,302</td>\n",
              "      <td>44,761,246,058</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>4,461,311,000</td>\n",
              "      <td>29,757,021,097</td>\n",
              "      <td>0</td>\n",
              "      <td>4,160,253,012</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38268</th>\n",
              "      <td>104120</td>\n",
              "      <td>2016</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>255,486,354,454</td>\n",
              "      <td>59,431,048,872</td>\n",
              "      <td>0</td>\n",
              "      <td>196,055,305,582</td>\n",
              "      <td>205,728,877,349</td>\n",
              "      <td>954,976,851</td>\n",
              "      <td>0</td>\n",
              "      <td>236,677,115,740</td>\n",
              "      <td>13,315,775,028</td>\n",
              "      <td>0</td>\n",
              "      <td>10,545,813,943</td>\n",
              "      <td>29,853,342,376</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>38269 rows × 15 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-e82ab2ff-9a38-4035-97b5-7724bc8dce3d')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-e82ab2ff-9a38-4035-97b5-7724bc8dce3d button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-e82ab2ff-9a38-4035-97b5-7724bc8dce3d');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "자산총계누락 = 통합재무정보[(통합재무정보['자산총계'] == '0')|(통합재무정보['자산총계'] == 0)]['종목코드'].unique().tolist()\n",
        "부채총계누락 = 통합재무정보[(통합재무정보['부채총계'] == '0')|(통합재무정보['부채총계'] == 0)]['종목코드'].unique().tolist()\n",
        "자본총계누락 = 통합재무정보[(통합재무정보['자본총계'] == '0')|(통합재무정보['자본총계'] == 0)]['종목코드'].unique().tolist()\n",
        "\n",
        "매출액누락 = 통합재무정보[(통합재무정보['매출액'] == '0')|(통합재무정보['매출액'] == 0)]['종목코드'].unique().tolist()\n",
        "영업이익누락 = 통합재무정보[(통합재무정보['영업이익'] == '0')|(통합재무정보['영업이익'] == 0)]['종목코드'].unique().tolist()\n",
        "매출총이익누락 = 통합재무정보[(통합재무정보['매출총이익'] == '0')|(통합재무정보['매출총이익'] == 0)]['종목코드'].unique().tolist()\n",
        "당기순이익누락 = 통합재무정보[(통합재무정보['당기순이익'] == '0')|(통합재무정보['당기순이익'] == 0)]['종목코드'].unique().tolist()\n",
        "\n",
        "\n",
        "전체누락 = 자산총계누락 + 부채총계누락 + 자본총계누락 + 매출액누락 + 영업이익누락 + 매출총이익누락 + 당기순이익누락"
      ],
      "metadata": {
        "id": "c8yv72nzx_fw"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "1zpWpk5fERHl"
      },
      "source": [
        "# 데이터 가져옴"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "매출액누락추정 = pd.read_csv('/content/drive/MyDrive/22캡스톤디자인/재무일괄/일괄/매출액누락추정.csv', index_col = 0,  dtype={'종목코드':'str'})\n",
        "영업이익누락추정 = pd.read_csv('/content/drive/MyDrive/22캡스톤디자인/재무일괄/일괄/영업이익누락추정.csv', index_col = 0,  dtype={'종목코드':'str'})\n",
        "당기순이익누락추정 = pd.read_csv('/content/drive/MyDrive/22캡스톤디자인/재무일괄/일괄/당기순이익누락추정.csv', index_col = 0,  dtype={'종목코드':'str'})\n",
        "매출총이익누락추정 = pd.read_csv('/content/drive/MyDrive/22캡스톤디자인/재무일괄/일괄/매출총이익누락추정.csv', index_col = 0,  dtype={'종목코드':'str'})"
      ],
      "metadata": {
        "id": "-ALG2OKxvAOd"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "import glob\n",
        "\n",
        "재무상태표 = [] # _01_\n",
        "손익계산서 = [] # _02_\n",
        "포괄손익계산서 = [] # _03_\n",
        "현금흐름표 = [] # _04_\n",
        "자본변동표 = [] #_05_\n",
        "\n",
        "\n",
        "for name in glob.glob('/content/drive/MyDrive/22캡스톤디자인/재무일괄/*.txt'):\n",
        "  if '_01_' in name:\n",
        "    재무상태표.append(name)\n",
        "  elif '_02_' in name:\n",
        "    손익계산서.append(name)\n",
        "  elif '_03_' in name:\n",
        "    포괄손익계산서.append(name)\n",
        "  elif '_04_' in name:\n",
        "    현금흐름표.append(name)\n",
        "  elif '_05_' in name:\n",
        "    자본변동표.append(name)"
      ],
      "metadata": {
        "id": "OxO2MfjlhT6i"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "포괄손익계산샘플 = pd.DataFrame(columns=['종목코드','사업연도', '보고서종류', '회사명', '업종', '항목코드','항목명', '당기'])\n",
        "\n",
        "for path in tqdm(포괄손익계산서):\n",
        "  temp = pd.read_csv(path, delimiter = '\\t', encoding='cp949')  \n",
        "\n",
        "  당기 = ''\n",
        "  if temp['보고서종류'][0] == '1분기보고서':\n",
        "    당기 = '당기 1분기 누적' \n",
        "  elif temp['보고서종류'][0] == '반기보고서':\n",
        "    당기 = '당기 반기 누적' \n",
        "  elif temp['보고서종류'][0] == '3분기보고서':\n",
        "    당기 = '당기 3분기 누적' \n",
        "  elif temp['보고서종류'][0] == '사업보고서':\n",
        "    당기 = '당기' \n",
        "\n",
        "  temp['사업연도'] = path[52:56] # 사업연도 컬럼 설정 - 파일명에서 가져온다\n",
        "  temp['항목명'] = temp['항목명'].str.strip() # 항목명 컬럼 문자열 전처리\n",
        "  temp['항목코드'] = temp['항목코드'].str.strip() # 항목코드 컬럼 문자열 전처리\n",
        "\n",
        "  temp = temp[['종목코드','사업연도', '보고서종류', '회사명', '업종', '항목코드','항목명', 당기]]\n",
        "  temp.rename(columns={당기:\"당기\"}, inplace=True)\n",
        "\n",
        "  포괄손익계산샘플 = 포괄손익계산샘플.append(temp)\n",
        "\n",
        "포괄손익계산샘플['종목코드'] = 포괄손익계산샘플['종목코드'].apply(lambda x:x[1:-1])\n",
        "\n",
        "손익계산샘플 = pd.DataFrame(columns=['종목코드','사업연도', '보고서종류', '회사명', '업종', '항목코드','항목명', '당기'])\n",
        "\n",
        "for path in tqdm(손익계산서):\n",
        "  temp = pd.read_csv(path, delimiter = '\\t', encoding='cp949')  \n",
        "\n",
        "  당기 = ''\n",
        "  if temp['보고서종류'][0] == '1분기보고서':\n",
        "    당기 = '당기 1분기 누적' \n",
        "  elif temp['보고서종류'][0] == '반기보고서':\n",
        "    당기 = '당기 반기 누적' \n",
        "  elif temp['보고서종류'][0] == '3분기보고서':\n",
        "    당기 = '당기 3분기 누적' \n",
        "  elif temp['보고서종류'][0] == '사업보고서':\n",
        "    당기 = '당기' \n",
        "\n",
        "  temp['사업연도'] = path[52:56] # 사업연도 컬럼 설정 - 파일명에서 가져온다\n",
        "  temp['항목명'] = temp['항목명'].str.strip() # 항목명 컬럼 문자열 전처리\n",
        "  temp['항목코드'] = temp['항목코드'].str.strip() # 항목코드 컬럼 문자열 전처리\n",
        "\n",
        "  temp = temp[['종목코드','사업연도', '보고서종류', '회사명', '업종', '항목코드','항목명', 당기]]\n",
        "  temp.rename(columns={당기:\"당기\"}, inplace=True)\n",
        "\n",
        "  손익계산샘플 = 손익계산샘플.append(temp)\n",
        "\n",
        "손익계산샘플['종목코드'] = 손익계산샘플['종목코드'].apply(lambda x:x[1:-1])\n",
        "\n",
        "재무상태표샘플 = pd.DataFrame(columns=['종목코드','사업연도', '보고서종류', '회사명', '업종', '항목코드','항목명', '당기'])\n",
        "\n",
        "for path in tqdm(재무상태표):\n",
        "  temp = pd.read_csv(path, delimiter = '\\t', encoding='cp949')  \n",
        "\n",
        "  당기 = ''\n",
        "  if temp['보고서종류'][0] == '1분기보고서':\n",
        "    당기 = '당기 1분기말' \n",
        "  elif temp['보고서종류'][0] == '반기보고서':\n",
        "    당기 = '당기 반기말' \n",
        "  elif temp['보고서종류'][0] == '3분기보고서':\n",
        "    당기 = '당기 3분기말' \n",
        "  elif temp['보고서종류'][0] == '사업보고서':\n",
        "    당기 = '당기' \n",
        "\n",
        "  temp['사업연도'] = path[52:56] # 사업연도 컬럼 설정 - 파일명에서 가져온다\n",
        "  temp['항목명'] = temp['항목명'].str.strip() # 항목명 컬럼 문자열 전처리\n",
        "  temp['항목코드'] = temp['항목코드'].str.strip() # 항목코드 컬럼 문자열 전처리\n",
        "\n",
        "  temp = temp[['종목코드','사업연도', '보고서종류', '회사명', '업종', '항목코드','항목명', 당기]]\n",
        "  temp.rename(columns={당기:\"당기\"}, inplace=True)\n",
        "\n",
        "  재무상태표샘플 = 재무상태표샘플.append(temp)\n",
        "\n",
        "재무상태표샘플['종목코드'] = 재무상태표샘플['종목코드'].apply(lambda x:x[1:-1])"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "0jddWPMwFN9w",
        "outputId": "d427cd5a-f431-4d65-fdfc-db70e8d0dd4e"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            " 17%|█▋        | 4/24 [00:02<00:12,  1.60it/s]/usr/local/lib/python3.7/dist-packages/pandas/core/frame.py:5047: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "  errors=errors,\n",
            "100%|██████████| 24/24 [00:25<00:00,  1.07s/it]\n",
            "100%|██████████| 24/24 [00:04<00:00,  5.93it/s]\n",
            " 21%|██        | 5/24 [00:07<00:28,  1.48s/it]/usr/local/lib/python3.7/dist-packages/IPython/core/interactiveshell.py:2882: DtypeWarning: Columns (14) have mixed types.Specify dtype option on import or set low_memory=False.\n",
            "  exec(code_obj, self.user_global_ns, self.user_ns)\n",
            "100%|██████████| 24/24 [00:25<00:00,  1.08s/it]\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "당기순이익조건 = 포괄손익계산샘플[포괄손익계산샘플['항목코드'].isin(['ifrs_ProfitLoss', 'ifrs-full_ProfitLoss'])]['항목명'].unique().tolist() + 손익계산샘플[손익계산샘플['항목코드'].isin(['ifrs_ProfitLoss', 'ifrs-full_ProfitLoss'])]['항목명'].unique().tolist()\n",
        "당기순이익조건 = list(set(당기순이익조건))\n",
        "len(당기순이익조건)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "8dWPPBUypSgQ",
        "outputId": "e0699fab-c40d-49ff-f5a6-03d0aca98935"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "129"
            ]
          },
          "metadata": {},
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "매출액조건 = 포괄손익계산샘플[포괄손익계산샘플['항목코드'].isin(['ifrs_Revenue', 'ifrs-full_Revenue'])]['항목명'].unique().tolist() + 손익계산샘플[손익계산샘플['항목코드'].isin(['ifrs_Revenue', 'ifrs-full_Revenue'])]['항목명'].unique().tolist()  + 재무상태표샘플[재무상태표샘플['항목코드'].isin(['ifrs_Revenue', 'ifrs-full_Revenue'])]['항목명'].unique().tolist() + 매출액누락추정[매출액누락추정['항목코드'].isin(['ifrs_Revenue', 'ifrs-full_Revenue'])]['항목명'].unique().tolist() \n",
        "매출액조건 = list(set(매출액조건))\n",
        "len(매출액조건)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Bpbtp5YJxl1w",
        "outputId": "551c5afb-c432-46a7-ae39-c56b1d17dc92"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "39"
            ]
          },
          "metadata": {},
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "영업이익조건 = 포괄손익계산샘플[포괄손익계산샘플['항목코드'].isin(['dart_OperatingIncomeLoss', 'dart_OperatingIncomeLoss'])]['항목명'].unique().tolist() + 손익계산샘플[손익계산샘플['항목코드'].isin(['dart_OperatingIncomeLoss', 'dart_OperatingIncomeLoss'])]['항목명'].unique().tolist()\n",
        "영업이익조건 = list(set(영업이익조건))\n",
        "영업이익조건.remove('영업수익')\n",
        "len(영업이익조건)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "rJNvKBz20NcY",
        "outputId": "189b3de4-7f93-4ba6-82f4-166365212e1f"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "35"
            ]
          },
          "metadata": {},
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "매출총이익조건 = 포괄손익계산샘플[포괄손익계산샘플['항목코드'].isin(['ifrs_GrossProfit', 'ifrs-full_GrossProfit'])]['항목명'].unique().tolist() + 손익계산샘플[손익계산샘플['항목코드'].isin(['ifrs_GrossProfit', 'ifrs-full_GrossProfit'])]['항목명'].unique().tolist()\n",
        "매출총이익조건 = list(set(매출총이익조건))\n",
        "len(매출총이익조건)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Ot5gxpRT0bBW",
        "outputId": "6b218e64-31ac-4740-a2c7-19a037cf29e9"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "17"
            ]
          },
          "metadata": {},
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "---\n",
        "<br>\n",
        "\n",
        "1. 항목코드 기준으로 항목명 전처리\n",
        "2. 항목명 기준으로 항목코드 전처리\n",
        "3. 다시 항목코드 기준으로 항목명 전처리"
      ],
      "metadata": {
        "id": "GXMQBWcxEQy6"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "누락데이터 = pd.DataFrame(columns=['종목코드','사업연도', '보고서종류', '회사명', '업종', '항목코드','항목명', '당기'])"
      ],
      "metadata": {
        "id": "OplwQzzIZJgV"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "---\n",
        "\n",
        "# 매출액(ifrs_Revenue)\n"
      ],
      "metadata": {
        "id": "Dx5QdGdIxUTt"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "매출액누락추정"
      ],
      "metadata": {
        "id": "eylnOjVntauw",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "outputId": "f6ca8098-ca37-4224-d2ab-50b4d25e02a1"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         종목코드  사업연도   보고서종류         회사명   업종  \\\n",
              "37637  000240  2016  1분기보고서  한국타이어월드와이드  715   \n",
              "37638  000240  2016  1분기보고서  한국타이어월드와이드  715   \n",
              "37639  000240  2016  1분기보고서  한국타이어월드와이드  715   \n",
              "37640  000240  2016  1분기보고서  한국타이어월드와이드  715   \n",
              "37641  000240  2016  1분기보고서  한국타이어월드와이드  715   \n",
              "...       ...   ...     ...         ...  ...   \n",
              "12697  950220  2021   반기보고서       네오이뮨텍  701   \n",
              "12698  950220  2021   반기보고서       네오이뮨텍  701   \n",
              "12699  950220  2021   반기보고서       네오이뮨텍  701   \n",
              "12700  950220  2021   반기보고서       네오이뮨텍  701   \n",
              "12701  950220  2021   반기보고서       네오이뮨텍  701   \n",
              "\n",
              "                                                    항목코드         항목명  \\\n",
              "37637  entity00160047_udf_IS_2016515164639527_Stateme...        영업수익   \n",
              "37638     dart_TotalSellingGeneralAdministrativeExpenses        영업비용   \n",
              "37639                           dart_OperatingIncomeLoss    영업이익(손실)   \n",
              "37640                                 ifrs_FinanceIncome        금융수익   \n",
              "37641                                  ifrs_FinanceCosts        금융원가   \n",
              "...                                                  ...         ...   \n",
              "12697             dart_ElementsOfOtherStockholdersEquity    기타자본구성요소   \n",
              "12698  dart_OtherComprehensiveIncomeLossAccumulatedAm...   기타포괄손익누계액   \n",
              "12699                         ifrs-full_RetainedEarnings  이익잉여금(결손금)   \n",
              "12700                                   ifrs-full_Equity        자본총계   \n",
              "12701                     ifrs-full_EquityAndLiabilities     자본과부채총계   \n",
              "\n",
              "                   당기  \n",
              "37637  63,692,032,878  \n",
              "37638   9,462,501,282  \n",
              "37639  54,229,531,596  \n",
              "37640   2,592,826,093  \n",
              "37641      84,855,022  \n",
              "...               ...  \n",
              "12697       7,722,041  \n",
              "12698          -1,649  \n",
              "12699     -79,685,967  \n",
              "12700     156,076,173  \n",
              "12701     169,788,099  \n",
              "\n",
              "[57370 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-0a77c1f9-6fe6-4730-b907-2a1f0c952342\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>37637</th>\n",
              "      <td>000240</td>\n",
              "      <td>2016</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>한국타이어월드와이드</td>\n",
              "      <td>715</td>\n",
              "      <td>entity00160047_udf_IS_2016515164639527_Stateme...</td>\n",
              "      <td>영업수익</td>\n",
              "      <td>63,692,032,878</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37638</th>\n",
              "      <td>000240</td>\n",
              "      <td>2016</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>한국타이어월드와이드</td>\n",
              "      <td>715</td>\n",
              "      <td>dart_TotalSellingGeneralAdministrativeExpenses</td>\n",
              "      <td>영업비용</td>\n",
              "      <td>9,462,501,282</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37639</th>\n",
              "      <td>000240</td>\n",
              "      <td>2016</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>한국타이어월드와이드</td>\n",
              "      <td>715</td>\n",
              "      <td>dart_OperatingIncomeLoss</td>\n",
              "      <td>영업이익(손실)</td>\n",
              "      <td>54,229,531,596</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37640</th>\n",
              "      <td>000240</td>\n",
              "      <td>2016</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>한국타이어월드와이드</td>\n",
              "      <td>715</td>\n",
              "      <td>ifrs_FinanceIncome</td>\n",
              "      <td>금융수익</td>\n",
              "      <td>2,592,826,093</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37641</th>\n",
              "      <td>000240</td>\n",
              "      <td>2016</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>한국타이어월드와이드</td>\n",
              "      <td>715</td>\n",
              "      <td>ifrs_FinanceCosts</td>\n",
              "      <td>금융원가</td>\n",
              "      <td>84,855,022</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12697</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>dart_ElementsOfOtherStockholdersEquity</td>\n",
              "      <td>기타자본구성요소</td>\n",
              "      <td>7,722,041</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12698</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>dart_OtherComprehensiveIncomeLossAccumulatedAm...</td>\n",
              "      <td>기타포괄손익누계액</td>\n",
              "      <td>-1,649</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12699</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_RetainedEarnings</td>\n",
              "      <td>이익잉여금(결손금)</td>\n",
              "      <td>-79,685,967</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12700</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_Equity</td>\n",
              "      <td>자본총계</td>\n",
              "      <td>156,076,173</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12701</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_EquityAndLiabilities</td>\n",
              "      <td>자본과부채총계</td>\n",
              "      <td>169,788,099</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>57370 rows × 8 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-0a77c1f9-6fe6-4730-b907-2a1f0c952342')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-0a77c1f9-6fe6-4730-b907-2a1f0c952342 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-0a77c1f9-6fe6-4730-b907-2a1f0c952342');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "len(매출액누락추정['종목코드'].unique())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "zqHIm1-JxT88",
        "outputId": "3a1df16a-1ea2-4849-be7d-f7f6f618e7de"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "132"
            ]
          },
          "metadata": {},
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "mask = 매출액누락추정['항목코드'].str.contains('ifrs_GrossProfit|ifrs-full_GrossProfit|dart_OperatingIncomeLoss|ifrs_ProfitLoss|ifrs-full_ProfitLoss')\n",
        "df = 매출액누락추정[~mask]\n",
        "df = df[(df['항목명'].isin(['매출액', '매출','I.매출액', 'Ⅰ.매출액', 'I.매출액', '계속영업 매출액', '재화의 판매로 인한 수익(매출액)', '매출액 및 지분법손익', '매출및지분법손익', '매출및 지분법손익', 'I. 영업수익', 'I.매출액', '매출액', '영업수익(매출액)', '수익(매출액)', '수익 (매출액)', '매출', '영업수익','수익', 'I.  매출액','I. 매출액', '매출액.', 'Ⅰ. 매출액'] + 매출액조건)|(df['항목코드'].isin(['ifrs_Revenue', 'ifrs-full_Revenue'])))]\n",
        "df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "SxKwIjBlyX2A",
        "outputId": "0847f150-5ccf-4997-9500-16eb75a51332"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         종목코드  사업연도   보고서종류         회사명   업종  \\\n",
              "37637  000240  2016  1분기보고서  한국타이어월드와이드  715   \n",
              "29682  000700  2019  1분기보고서       유수홀딩스  715   \n",
              "30704  000700  2019  3분기보고서       유수홀딩스  715   \n",
              "30012  000700  2019   반기보고서       유수홀딩스  715   \n",
              "33010  000700  2019   사업보고서       유수홀딩스  715   \n",
              "...       ...   ...     ...         ...  ...   \n",
              "32795  900140  2016  3분기보고서      코라오홀딩스  715   \n",
              "32580  900140  2016   반기보고서      코라오홀딩스  715   \n",
              "34189  900140  2016   사업보고서      코라오홀딩스  715   \n",
              "33626  900140  2017  1분기보고서      코라오홀딩스  715   \n",
              "33270  900140  2017   반기보고서      코라오홀딩스  649   \n",
              "\n",
              "                                                    항목코드   항목명  \\\n",
              "37637  entity00160047_udf_IS_2016515164639527_Stateme...  영업수익   \n",
              "29682  entity00163691_udf_IS_20195149831645_Statement...   매출액   \n",
              "30704  entity00163691_udf_IS_20195149831645_Statement...   매출액   \n",
              "30012  entity00163691_udf_IS_20195149831645_Statement...   매출액   \n",
              "33010  entity00163691_udf_IS_20195149831645_Statement...   매출액   \n",
              "...                                                  ...   ...   \n",
              "32795  entity00838500_udf_IS_2015525214515894_Stateme...   매출액   \n",
              "32580  entity00838500_udf_IS_2015525214515894_Stateme...   매출액   \n",
              "34189  entity00838500_udf_IS_2015525214515894_Stateme...   매출액   \n",
              "33626  entity00838500_udf_IS_2015525214515894_Stateme...   매출액   \n",
              "33270  entity00838500_udf_IS_2015525214515894_Stateme...   매출액   \n",
              "\n",
              "                    당기  \n",
              "37637   63,692,032,878  \n",
              "29682   91,329,697,403  \n",
              "30704  279,266,501,315  \n",
              "30012  191,258,277,055  \n",
              "33010  366,111,471,934  \n",
              "...                ...  \n",
              "32795      252,823,370  \n",
              "32580      171,217,063  \n",
              "34189      338,068,515  \n",
              "33626       77,227,985  \n",
              "33270      147,365,956  \n",
              "\n",
              "[579 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-b64eb389-af4e-474e-8614-30535a211bc1\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>37637</th>\n",
              "      <td>000240</td>\n",
              "      <td>2016</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>한국타이어월드와이드</td>\n",
              "      <td>715</td>\n",
              "      <td>entity00160047_udf_IS_2016515164639527_Stateme...</td>\n",
              "      <td>영업수익</td>\n",
              "      <td>63,692,032,878</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29682</th>\n",
              "      <td>000700</td>\n",
              "      <td>2019</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>유수홀딩스</td>\n",
              "      <td>715</td>\n",
              "      <td>entity00163691_udf_IS_20195149831645_Statement...</td>\n",
              "      <td>매출액</td>\n",
              "      <td>91,329,697,403</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30704</th>\n",
              "      <td>000700</td>\n",
              "      <td>2019</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>유수홀딩스</td>\n",
              "      <td>715</td>\n",
              "      <td>entity00163691_udf_IS_20195149831645_Statement...</td>\n",
              "      <td>매출액</td>\n",
              "      <td>279,266,501,315</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30012</th>\n",
              "      <td>000700</td>\n",
              "      <td>2019</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>유수홀딩스</td>\n",
              "      <td>715</td>\n",
              "      <td>entity00163691_udf_IS_20195149831645_Statement...</td>\n",
              "      <td>매출액</td>\n",
              "      <td>191,258,277,055</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33010</th>\n",
              "      <td>000700</td>\n",
              "      <td>2019</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>유수홀딩스</td>\n",
              "      <td>715</td>\n",
              "      <td>entity00163691_udf_IS_20195149831645_Statement...</td>\n",
              "      <td>매출액</td>\n",
              "      <td>366,111,471,934</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32795</th>\n",
              "      <td>900140</td>\n",
              "      <td>2016</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>코라오홀딩스</td>\n",
              "      <td>715</td>\n",
              "      <td>entity00838500_udf_IS_2015525214515894_Stateme...</td>\n",
              "      <td>매출액</td>\n",
              "      <td>252,823,370</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32580</th>\n",
              "      <td>900140</td>\n",
              "      <td>2016</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>코라오홀딩스</td>\n",
              "      <td>715</td>\n",
              "      <td>entity00838500_udf_IS_2015525214515894_Stateme...</td>\n",
              "      <td>매출액</td>\n",
              "      <td>171,217,063</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34189</th>\n",
              "      <td>900140</td>\n",
              "      <td>2016</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>코라오홀딩스</td>\n",
              "      <td>715</td>\n",
              "      <td>entity00838500_udf_IS_2015525214515894_Stateme...</td>\n",
              "      <td>매출액</td>\n",
              "      <td>338,068,515</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33626</th>\n",
              "      <td>900140</td>\n",
              "      <td>2017</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>코라오홀딩스</td>\n",
              "      <td>715</td>\n",
              "      <td>entity00838500_udf_IS_2015525214515894_Stateme...</td>\n",
              "      <td>매출액</td>\n",
              "      <td>77,227,985</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33270</th>\n",
              "      <td>900140</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>코라오홀딩스</td>\n",
              "      <td>649</td>\n",
              "      <td>entity00838500_udf_IS_2015525214515894_Stateme...</td>\n",
              "      <td>매출액</td>\n",
              "      <td>147,365,956</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>579 rows × 8 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b64eb389-af4e-474e-8614-30535a211bc1')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-b64eb389-af4e-474e-8614-30535a211bc1 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-b64eb389-af4e-474e-8614-30535a211bc1');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "len(df['종목코드'].unique())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "zQqAZXVjiB1c",
        "outputId": "5cd2c1e9-e9ec-4530-f4f0-4de87523ca21"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "95"
            ]
          },
          "metadata": {},
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df['항목명'] = df.apply(lambda x: '매출액', axis=1)\n",
        "df['항목코드'] = df.apply(lambda x: 'ifrs_Revenue', axis=1)\n",
        "\n",
        "df =  df.drop_duplicates(subset = ['종목코드', '사업연도', '보고서종류', '회사명', '업종', '항목코드', '항목명'],keep = 'first')\n",
        "df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "L_XjRYS3ZpOg",
        "outputId": "c88102c1-a7cf-427f-a0c0-7cc281c8113e"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         종목코드  사업연도   보고서종류         회사명   업종          항목코드  항목명  \\\n",
              "37637  000240  2016  1분기보고서  한국타이어월드와이드  715  ifrs_Revenue  매출액   \n",
              "29682  000700  2019  1분기보고서       유수홀딩스  715  ifrs_Revenue  매출액   \n",
              "30704  000700  2019  3분기보고서       유수홀딩스  715  ifrs_Revenue  매출액   \n",
              "30012  000700  2019   반기보고서       유수홀딩스  715  ifrs_Revenue  매출액   \n",
              "33010  000700  2019   사업보고서       유수홀딩스  715  ifrs_Revenue  매출액   \n",
              "...       ...   ...     ...         ...  ...           ...  ...   \n",
              "32795  900140  2016  3분기보고서      코라오홀딩스  715  ifrs_Revenue  매출액   \n",
              "32580  900140  2016   반기보고서      코라오홀딩스  715  ifrs_Revenue  매출액   \n",
              "34189  900140  2016   사업보고서      코라오홀딩스  715  ifrs_Revenue  매출액   \n",
              "33626  900140  2017  1분기보고서      코라오홀딩스  715  ifrs_Revenue  매출액   \n",
              "33270  900140  2017   반기보고서      코라오홀딩스  649  ifrs_Revenue  매출액   \n",
              "\n",
              "                    당기  \n",
              "37637   63,692,032,878  \n",
              "29682   91,329,697,403  \n",
              "30704  279,266,501,315  \n",
              "30012  191,258,277,055  \n",
              "33010  366,111,471,934  \n",
              "...                ...  \n",
              "32795      252,823,370  \n",
              "32580      171,217,063  \n",
              "34189      338,068,515  \n",
              "33626       77,227,985  \n",
              "33270      147,365,956  \n",
              "\n",
              "[558 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-9122ba68-0773-453e-b80c-4f067a479c71\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>37637</th>\n",
              "      <td>000240</td>\n",
              "      <td>2016</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>한국타이어월드와이드</td>\n",
              "      <td>715</td>\n",
              "      <td>ifrs_Revenue</td>\n",
              "      <td>매출액</td>\n",
              "      <td>63,692,032,878</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29682</th>\n",
              "      <td>000700</td>\n",
              "      <td>2019</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>유수홀딩스</td>\n",
              "      <td>715</td>\n",
              "      <td>ifrs_Revenue</td>\n",
              "      <td>매출액</td>\n",
              "      <td>91,329,697,403</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30704</th>\n",
              "      <td>000700</td>\n",
              "      <td>2019</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>유수홀딩스</td>\n",
              "      <td>715</td>\n",
              "      <td>ifrs_Revenue</td>\n",
              "      <td>매출액</td>\n",
              "      <td>279,266,501,315</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30012</th>\n",
              "      <td>000700</td>\n",
              "      <td>2019</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>유수홀딩스</td>\n",
              "      <td>715</td>\n",
              "      <td>ifrs_Revenue</td>\n",
              "      <td>매출액</td>\n",
              "      <td>191,258,277,055</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33010</th>\n",
              "      <td>000700</td>\n",
              "      <td>2019</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>유수홀딩스</td>\n",
              "      <td>715</td>\n",
              "      <td>ifrs_Revenue</td>\n",
              "      <td>매출액</td>\n",
              "      <td>366,111,471,934</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32795</th>\n",
              "      <td>900140</td>\n",
              "      <td>2016</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>코라오홀딩스</td>\n",
              "      <td>715</td>\n",
              "      <td>ifrs_Revenue</td>\n",
              "      <td>매출액</td>\n",
              "      <td>252,823,370</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32580</th>\n",
              "      <td>900140</td>\n",
              "      <td>2016</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>코라오홀딩스</td>\n",
              "      <td>715</td>\n",
              "      <td>ifrs_Revenue</td>\n",
              "      <td>매출액</td>\n",
              "      <td>171,217,063</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34189</th>\n",
              "      <td>900140</td>\n",
              "      <td>2016</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>코라오홀딩스</td>\n",
              "      <td>715</td>\n",
              "      <td>ifrs_Revenue</td>\n",
              "      <td>매출액</td>\n",
              "      <td>338,068,515</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33626</th>\n",
              "      <td>900140</td>\n",
              "      <td>2017</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>코라오홀딩스</td>\n",
              "      <td>715</td>\n",
              "      <td>ifrs_Revenue</td>\n",
              "      <td>매출액</td>\n",
              "      <td>77,227,985</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33270</th>\n",
              "      <td>900140</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>코라오홀딩스</td>\n",
              "      <td>649</td>\n",
              "      <td>ifrs_Revenue</td>\n",
              "      <td>매출액</td>\n",
              "      <td>147,365,956</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>558 rows × 8 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-9122ba68-0773-453e-b80c-4f067a479c71')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-9122ba68-0773-453e-b80c-4f067a479c71 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-9122ba68-0773-453e-b80c-4f067a479c71');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "누락데이터 = 누락데이터.append(df)"
      ],
      "metadata": {
        "id": "6kqNB6XcZNI1"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "# 영업이익(dart_OperatingIncomeLoss)"
      ],
      "metadata": {
        "id": "ppLnb1wYytym"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "영업이익누락추정"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "ALvDzgg-xT6-",
        "outputId": "08c3e503-cb15-4ca2-ed17-12e3e141dc1e"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         종목코드  사업연도  보고서종류     회사명   업종  \\\n",
              "31442  000440  2017  반기보고서  중앙에너비스  467   \n",
              "31443  000440  2017  반기보고서  중앙에너비스  467   \n",
              "31444  000440  2017  반기보고서  중앙에너비스  467   \n",
              "31445  000440  2017  반기보고서  중앙에너비스  467   \n",
              "31446  000440  2017  반기보고서  중앙에너비스  467   \n",
              "...       ...   ...    ...     ...  ...   \n",
              "48244  950140  2017  반기보고서   잉글우드랩  649   \n",
              "48245  950140  2017  반기보고서   잉글우드랩  649   \n",
              "48246  950140  2017  반기보고서   잉글우드랩  649   \n",
              "48247  950140  2017  반기보고서   잉글우드랩  649   \n",
              "48248  950140  2017  반기보고서   잉글우드랩  649   \n",
              "\n",
              "                                                    항목코드           항목명  \\\n",
              "31442                                       ifrs_Revenue           매출액   \n",
              "31443                                   ifrs_CostOfSales          매출원가   \n",
              "31444                                   ifrs_GrossProfit         매출총이익   \n",
              "31445     dart_TotalSellingGeneralAdministrativeExpenses       판매비와관리비   \n",
              "31446  entity00149770_udf_IS_201781121644519_Statemen...  계속영업이익( 손실 )   \n",
              "...                                                  ...           ...   \n",
              "48244  entity01165739_udf_BS_201742620213518_EquityAb...         자본잉여금   \n",
              "48245  entity01165739_udf_BS_201742611184879_EquityAb...     기타포괄손익누계액   \n",
              "48246  entity01165739_udf_BS_2017426111859521_EquityA...         이익잉여금   \n",
              "48247                                        ifrs_Equity          자본총계   \n",
              "48248                          ifrs_EquityAndLiabilities       자본과부채총계   \n",
              "\n",
              "                   당기  \n",
              "31442  33,366,681,275  \n",
              "31443  27,460,213,806  \n",
              "31444   5,906,467,469  \n",
              "31445   5,586,515,819  \n",
              "31446     319,951,650  \n",
              "...               ...  \n",
              "48244      63,070,087  \n",
              "48245        -417,401  \n",
              "48246      -4,256,051  \n",
              "48247      63,363,602  \n",
              "48248      89,249,925  \n",
              "\n",
              "[16352 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-091ce8f3-5e86-4a65-be57-ca19ebccc82f\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>31442</th>\n",
              "      <td>000440</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>중앙에너비스</td>\n",
              "      <td>467</td>\n",
              "      <td>ifrs_Revenue</td>\n",
              "      <td>매출액</td>\n",
              "      <td>33,366,681,275</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31443</th>\n",
              "      <td>000440</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>중앙에너비스</td>\n",
              "      <td>467</td>\n",
              "      <td>ifrs_CostOfSales</td>\n",
              "      <td>매출원가</td>\n",
              "      <td>27,460,213,806</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31444</th>\n",
              "      <td>000440</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>중앙에너비스</td>\n",
              "      <td>467</td>\n",
              "      <td>ifrs_GrossProfit</td>\n",
              "      <td>매출총이익</td>\n",
              "      <td>5,906,467,469</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31445</th>\n",
              "      <td>000440</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>중앙에너비스</td>\n",
              "      <td>467</td>\n",
              "      <td>dart_TotalSellingGeneralAdministrativeExpenses</td>\n",
              "      <td>판매비와관리비</td>\n",
              "      <td>5,586,515,819</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31446</th>\n",
              "      <td>000440</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>중앙에너비스</td>\n",
              "      <td>467</td>\n",
              "      <td>entity00149770_udf_IS_201781121644519_Statemen...</td>\n",
              "      <td>계속영업이익( 손실 )</td>\n",
              "      <td>319,951,650</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48244</th>\n",
              "      <td>950140</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>잉글우드랩</td>\n",
              "      <td>649</td>\n",
              "      <td>entity01165739_udf_BS_201742620213518_EquityAb...</td>\n",
              "      <td>자본잉여금</td>\n",
              "      <td>63,070,087</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48245</th>\n",
              "      <td>950140</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>잉글우드랩</td>\n",
              "      <td>649</td>\n",
              "      <td>entity01165739_udf_BS_201742611184879_EquityAb...</td>\n",
              "      <td>기타포괄손익누계액</td>\n",
              "      <td>-417,401</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48246</th>\n",
              "      <td>950140</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>잉글우드랩</td>\n",
              "      <td>649</td>\n",
              "      <td>entity01165739_udf_BS_2017426111859521_EquityA...</td>\n",
              "      <td>이익잉여금</td>\n",
              "      <td>-4,256,051</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48247</th>\n",
              "      <td>950140</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>잉글우드랩</td>\n",
              "      <td>649</td>\n",
              "      <td>ifrs_Equity</td>\n",
              "      <td>자본총계</td>\n",
              "      <td>63,363,602</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48248</th>\n",
              "      <td>950140</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>잉글우드랩</td>\n",
              "      <td>649</td>\n",
              "      <td>ifrs_EquityAndLiabilities</td>\n",
              "      <td>자본과부채총계</td>\n",
              "      <td>89,249,925</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>16352 rows × 8 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-091ce8f3-5e86-4a65-be57-ca19ebccc82f')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-091ce8f3-5e86-4a65-be57-ca19ebccc82f button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-091ce8f3-5e86-4a65-be57-ca19ebccc82f');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "len(영업이익누락추정['종목코드'].unique())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "OB6a5pMdxe9i",
        "outputId": "b2f22bcd-bf7d-4beb-e268-73bc3c5463b5"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "57"
            ]
          },
          "metadata": {},
          "execution_count": 20
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "mask = 영업이익누락추정['항목코드'].str.contains('ifrs_GrossProfit|ifrs-full_GrossProfit|ifrs_ProfitLoss|ifrs-full_ProfitLoss|ifrs_Revenue|ifrs-full_Revenue')\n",
        "df2 = 영업이익누락추정[~mask]\n",
        "df2 = df2[(df2['항목명'].isin(['영업이익', '영업이익 (손실)', '영업이익(손실)', 'Ⅲ. 영업이익', 'IV.영업이익(손실)', 'Ⅴ.영업이익', 'Ⅴ.영업이익(손실)', '영업손익', '영업 손익'] + 영업이익조건))|(df2['항목코드'].isin(['dart_OperatingIncomeLoss']))]\n",
        "df2"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "ED6WIlUcBovI",
        "outputId": "31db3ca3-54f6-4d64-8fce-cc1245bad93e"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         종목코드  사업연도   보고서종류     회사명   업종  \\\n",
              "3736   000500  2015   사업보고서    가온전선  283   \n",
              "3849   000500  2016  1분기보고서    가온전선  283   \n",
              "3904   000500  2016  3분기보고서    가온전선  283   \n",
              "3927   000500  2016   반기보고서    가온전선  283   \n",
              "4053   000500  2016   사업보고서    가온전선  283   \n",
              "...       ...   ...     ...     ...  ...   \n",
              "37414  289220  2020   사업보고서  자이언트스텝  591   \n",
              "47873  307950  2018   사업보고서  현대오토에버  582   \n",
              "31102  950140  2016   사업보고서   잉글우드랩  715   \n",
              "30542  950140  2017  1분기보고서   잉글우드랩  715   \n",
              "30163  950140  2017   반기보고서   잉글우드랩  649   \n",
              "\n",
              "                                                    항목코드   항목명              당기  \n",
              "3736   entity00104768_udf_IS_2013322155917953_Stateme...  영업이익   9,877,553,145  \n",
              "3849   entity00104768_udf_IS_2013322155917953_Stateme...  영업이익   6,731,229,275  \n",
              "3904   entity00104768_udf_IS_2013322155917953_Stateme...  영업이익  13,334,069,820  \n",
              "3927   entity00104768_udf_IS_2013322155917953_Stateme...  영업이익   9,859,825,214  \n",
              "4053   entity00104768_udf_IS_2013322155917953_Stateme...  영업이익  16,800,018,902  \n",
              "...                                                  ...   ...             ...  \n",
              "37414  entity01264438_udf_IS_20213261033887_Statement...  영업손실  -1,503,025,319  \n",
              "47873  entity00362441_udf_IS_2019412331963_StatementO...  영업이익  70,178,422,437  \n",
              "31102  entity01165739_udf_IS_2017426202546769_Stateme...  영업이익       6,053,262  \n",
              "30542  entity01165739_udf_IS_2017426202546769_Stateme...  영업이익       1,375,331  \n",
              "30163  entity01165739_udf_IS_2017426202546769_Stateme...  영업이익      -1,373,608  \n",
              "\n",
              "[225 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-87eb058c-791e-426a-8630-330975150e3d\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>3736</th>\n",
              "      <td>000500</td>\n",
              "      <td>2015</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>가온전선</td>\n",
              "      <td>283</td>\n",
              "      <td>entity00104768_udf_IS_2013322155917953_Stateme...</td>\n",
              "      <td>영업이익</td>\n",
              "      <td>9,877,553,145</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3849</th>\n",
              "      <td>000500</td>\n",
              "      <td>2016</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>가온전선</td>\n",
              "      <td>283</td>\n",
              "      <td>entity00104768_udf_IS_2013322155917953_Stateme...</td>\n",
              "      <td>영업이익</td>\n",
              "      <td>6,731,229,275</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3904</th>\n",
              "      <td>000500</td>\n",
              "      <td>2016</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>가온전선</td>\n",
              "      <td>283</td>\n",
              "      <td>entity00104768_udf_IS_2013322155917953_Stateme...</td>\n",
              "      <td>영업이익</td>\n",
              "      <td>13,334,069,820</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3927</th>\n",
              "      <td>000500</td>\n",
              "      <td>2016</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>가온전선</td>\n",
              "      <td>283</td>\n",
              "      <td>entity00104768_udf_IS_2013322155917953_Stateme...</td>\n",
              "      <td>영업이익</td>\n",
              "      <td>9,859,825,214</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4053</th>\n",
              "      <td>000500</td>\n",
              "      <td>2016</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>가온전선</td>\n",
              "      <td>283</td>\n",
              "      <td>entity00104768_udf_IS_2013322155917953_Stateme...</td>\n",
              "      <td>영업이익</td>\n",
              "      <td>16,800,018,902</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37414</th>\n",
              "      <td>289220</td>\n",
              "      <td>2020</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>자이언트스텝</td>\n",
              "      <td>591</td>\n",
              "      <td>entity01264438_udf_IS_20213261033887_Statement...</td>\n",
              "      <td>영업손실</td>\n",
              "      <td>-1,503,025,319</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47873</th>\n",
              "      <td>307950</td>\n",
              "      <td>2018</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>현대오토에버</td>\n",
              "      <td>582</td>\n",
              "      <td>entity00362441_udf_IS_2019412331963_StatementO...</td>\n",
              "      <td>영업이익</td>\n",
              "      <td>70,178,422,437</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31102</th>\n",
              "      <td>950140</td>\n",
              "      <td>2016</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>잉글우드랩</td>\n",
              "      <td>715</td>\n",
              "      <td>entity01165739_udf_IS_2017426202546769_Stateme...</td>\n",
              "      <td>영업이익</td>\n",
              "      <td>6,053,262</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30542</th>\n",
              "      <td>950140</td>\n",
              "      <td>2017</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>잉글우드랩</td>\n",
              "      <td>715</td>\n",
              "      <td>entity01165739_udf_IS_2017426202546769_Stateme...</td>\n",
              "      <td>영업이익</td>\n",
              "      <td>1,375,331</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30163</th>\n",
              "      <td>950140</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>잉글우드랩</td>\n",
              "      <td>649</td>\n",
              "      <td>entity01165739_udf_IS_2017426202546769_Stateme...</td>\n",
              "      <td>영업이익</td>\n",
              "      <td>-1,373,608</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>225 rows × 8 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-87eb058c-791e-426a-8630-330975150e3d')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-87eb058c-791e-426a-8630-330975150e3d button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-87eb058c-791e-426a-8630-330975150e3d');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 21
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "len(df2['종목코드'].unique())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "uvDqw8qeBotG",
        "outputId": "003f267e-efe3-47c9-e4d4-c90fa1b6b34e"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "45"
            ]
          },
          "metadata": {},
          "execution_count": 22
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df2['항목명'] = df2.apply(lambda x: '영업이익', axis=1)\n",
        "df2['항목코드'] = df2.apply(lambda x: 'dart_OperatingIncomeLoss', axis=1)\n",
        "\n",
        "df2 =  df2.drop_duplicates(subset = ['종목코드', '사업연도', '보고서종류', '회사명', '업종', '항목코드', '항목명'],keep = 'first')\n",
        "df2"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "6VTZWRNDZvRf",
        "outputId": "97e99810-3baa-44aa-8219-0b9f3789eb1f"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         종목코드  사업연도   보고서종류     회사명   업종                      항목코드   항목명  \\\n",
              "3736   000500  2015   사업보고서    가온전선  283  dart_OperatingIncomeLoss  영업이익   \n",
              "3849   000500  2016  1분기보고서    가온전선  283  dart_OperatingIncomeLoss  영업이익   \n",
              "3904   000500  2016  3분기보고서    가온전선  283  dart_OperatingIncomeLoss  영업이익   \n",
              "3927   000500  2016   반기보고서    가온전선  283  dart_OperatingIncomeLoss  영업이익   \n",
              "4053   000500  2016   사업보고서    가온전선  283  dart_OperatingIncomeLoss  영업이익   \n",
              "...       ...   ...     ...     ...  ...                       ...   ...   \n",
              "37414  289220  2020   사업보고서  자이언트스텝  591  dart_OperatingIncomeLoss  영업이익   \n",
              "47873  307950  2018   사업보고서  현대오토에버  582  dart_OperatingIncomeLoss  영업이익   \n",
              "31102  950140  2016   사업보고서   잉글우드랩  715  dart_OperatingIncomeLoss  영업이익   \n",
              "30542  950140  2017  1분기보고서   잉글우드랩  715  dart_OperatingIncomeLoss  영업이익   \n",
              "30163  950140  2017   반기보고서   잉글우드랩  649  dart_OperatingIncomeLoss  영업이익   \n",
              "\n",
              "                   당기  \n",
              "3736    9,877,553,145  \n",
              "3849    6,731,229,275  \n",
              "3904   13,334,069,820  \n",
              "3927    9,859,825,214  \n",
              "4053   16,800,018,902  \n",
              "...               ...  \n",
              "37414  -1,503,025,319  \n",
              "47873  70,178,422,437  \n",
              "31102       6,053,262  \n",
              "30542       1,375,331  \n",
              "30163      -1,373,608  \n",
              "\n",
              "[215 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-56588fb2-b8a0-4300-b2e9-11df69636e54\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>3736</th>\n",
              "      <td>000500</td>\n",
              "      <td>2015</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>가온전선</td>\n",
              "      <td>283</td>\n",
              "      <td>dart_OperatingIncomeLoss</td>\n",
              "      <td>영업이익</td>\n",
              "      <td>9,877,553,145</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3849</th>\n",
              "      <td>000500</td>\n",
              "      <td>2016</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>가온전선</td>\n",
              "      <td>283</td>\n",
              "      <td>dart_OperatingIncomeLoss</td>\n",
              "      <td>영업이익</td>\n",
              "      <td>6,731,229,275</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3904</th>\n",
              "      <td>000500</td>\n",
              "      <td>2016</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>가온전선</td>\n",
              "      <td>283</td>\n",
              "      <td>dart_OperatingIncomeLoss</td>\n",
              "      <td>영업이익</td>\n",
              "      <td>13,334,069,820</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3927</th>\n",
              "      <td>000500</td>\n",
              "      <td>2016</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>가온전선</td>\n",
              "      <td>283</td>\n",
              "      <td>dart_OperatingIncomeLoss</td>\n",
              "      <td>영업이익</td>\n",
              "      <td>9,859,825,214</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4053</th>\n",
              "      <td>000500</td>\n",
              "      <td>2016</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>가온전선</td>\n",
              "      <td>283</td>\n",
              "      <td>dart_OperatingIncomeLoss</td>\n",
              "      <td>영업이익</td>\n",
              "      <td>16,800,018,902</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37414</th>\n",
              "      <td>289220</td>\n",
              "      <td>2020</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>자이언트스텝</td>\n",
              "      <td>591</td>\n",
              "      <td>dart_OperatingIncomeLoss</td>\n",
              "      <td>영업이익</td>\n",
              "      <td>-1,503,025,319</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47873</th>\n",
              "      <td>307950</td>\n",
              "      <td>2018</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>현대오토에버</td>\n",
              "      <td>582</td>\n",
              "      <td>dart_OperatingIncomeLoss</td>\n",
              "      <td>영업이익</td>\n",
              "      <td>70,178,422,437</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31102</th>\n",
              "      <td>950140</td>\n",
              "      <td>2016</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>잉글우드랩</td>\n",
              "      <td>715</td>\n",
              "      <td>dart_OperatingIncomeLoss</td>\n",
              "      <td>영업이익</td>\n",
              "      <td>6,053,262</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30542</th>\n",
              "      <td>950140</td>\n",
              "      <td>2017</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>잉글우드랩</td>\n",
              "      <td>715</td>\n",
              "      <td>dart_OperatingIncomeLoss</td>\n",
              "      <td>영업이익</td>\n",
              "      <td>1,375,331</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30163</th>\n",
              "      <td>950140</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>잉글우드랩</td>\n",
              "      <td>649</td>\n",
              "      <td>dart_OperatingIncomeLoss</td>\n",
              "      <td>영업이익</td>\n",
              "      <td>-1,373,608</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>215 rows × 8 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-56588fb2-b8a0-4300-b2e9-11df69636e54')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-56588fb2-b8a0-4300-b2e9-11df69636e54 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-56588fb2-b8a0-4300-b2e9-11df69636e54');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 23
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "누락데이터 = 누락데이터.append(df2)"
      ],
      "metadata": {
        "id": "2tSJmGwMZdV5"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "# 당기순이익(ifrs_ProfitLoss)"
      ],
      "metadata": {
        "id": "Kz03lezNyyI2"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "당기순이익누락추정"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "U-RzeamexT4-",
        "outputId": "468b18e8-d755-4164-c4a7-a57d8a7171cb"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         종목코드  사업연도   보고서종류     회사명   업종  \\\n",
              "31442  000440  2017   반기보고서  중앙에너비스  467   \n",
              "31443  000440  2017   반기보고서  중앙에너비스  467   \n",
              "31444  000440  2017   반기보고서  중앙에너비스  467   \n",
              "31445  000440  2017   반기보고서  중앙에너비스  467   \n",
              "31446  000440  2017   반기보고서  중앙에너비스  467   \n",
              "...       ...   ...     ...     ...  ...   \n",
              "2143   950170  2018  1분기보고서     JTC  471   \n",
              "2144   950170  2018  1분기보고서     JTC  471   \n",
              "2145   950170  2018  1분기보고서     JTC  471   \n",
              "2146   950170  2018  1분기보고서     JTC  471   \n",
              "2147   950170  2018  1분기보고서     JTC  471   \n",
              "\n",
              "                                                    항목코드           항목명  \\\n",
              "31442                                       ifrs_Revenue           매출액   \n",
              "31443                                   ifrs_CostOfSales          매출원가   \n",
              "31444                                   ifrs_GrossProfit         매출총이익   \n",
              "31445     dart_TotalSellingGeneralAdministrativeExpenses       판매비와관리비   \n",
              "31446  entity00149770_udf_IS_201781121644519_Statemen...  계속영업이익( 손실 )   \n",
              "...                                                  ...           ...   \n",
              "2143              dart_ElementsOfOtherStockholdersEquity      기타자본구성요소   \n",
              "2144                               ifrs_RetainedEarnings    이익잉여금(결손금)   \n",
              "2145   dart_OtherComprehensiveIncomeLossAccumulatedAm...     기타포괄손익누계액   \n",
              "2146                                         ifrs_Equity          자본총계   \n",
              "2147                           ifrs_EquityAndLiabilities       자본과부채총계   \n",
              "\n",
              "                   당기  \n",
              "31442  33,366,681,275  \n",
              "31443  27,460,213,806  \n",
              "31444   5,906,467,469  \n",
              "31445   5,586,515,819  \n",
              "31446     319,951,650  \n",
              "...               ...  \n",
              "2143      266,152,611  \n",
              "2144   12,783,380,050  \n",
              "2145       24,883,013  \n",
              "2146   22,706,415,472  \n",
              "2147   32,205,528,508  \n",
              "\n",
              "[48325 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-bcc412c9-49e1-491b-8640-dcd4745f2f16\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>31442</th>\n",
              "      <td>000440</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>중앙에너비스</td>\n",
              "      <td>467</td>\n",
              "      <td>ifrs_Revenue</td>\n",
              "      <td>매출액</td>\n",
              "      <td>33,366,681,275</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31443</th>\n",
              "      <td>000440</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>중앙에너비스</td>\n",
              "      <td>467</td>\n",
              "      <td>ifrs_CostOfSales</td>\n",
              "      <td>매출원가</td>\n",
              "      <td>27,460,213,806</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31444</th>\n",
              "      <td>000440</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>중앙에너비스</td>\n",
              "      <td>467</td>\n",
              "      <td>ifrs_GrossProfit</td>\n",
              "      <td>매출총이익</td>\n",
              "      <td>5,906,467,469</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31445</th>\n",
              "      <td>000440</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>중앙에너비스</td>\n",
              "      <td>467</td>\n",
              "      <td>dart_TotalSellingGeneralAdministrativeExpenses</td>\n",
              "      <td>판매비와관리비</td>\n",
              "      <td>5,586,515,819</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31446</th>\n",
              "      <td>000440</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>중앙에너비스</td>\n",
              "      <td>467</td>\n",
              "      <td>entity00149770_udf_IS_201781121644519_Statemen...</td>\n",
              "      <td>계속영업이익( 손실 )</td>\n",
              "      <td>319,951,650</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2143</th>\n",
              "      <td>950170</td>\n",
              "      <td>2018</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>JTC</td>\n",
              "      <td>471</td>\n",
              "      <td>dart_ElementsOfOtherStockholdersEquity</td>\n",
              "      <td>기타자본구성요소</td>\n",
              "      <td>266,152,611</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2144</th>\n",
              "      <td>950170</td>\n",
              "      <td>2018</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>JTC</td>\n",
              "      <td>471</td>\n",
              "      <td>ifrs_RetainedEarnings</td>\n",
              "      <td>이익잉여금(결손금)</td>\n",
              "      <td>12,783,380,050</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2145</th>\n",
              "      <td>950170</td>\n",
              "      <td>2018</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>JTC</td>\n",
              "      <td>471</td>\n",
              "      <td>dart_OtherComprehensiveIncomeLossAccumulatedAm...</td>\n",
              "      <td>기타포괄손익누계액</td>\n",
              "      <td>24,883,013</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2146</th>\n",
              "      <td>950170</td>\n",
              "      <td>2018</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>JTC</td>\n",
              "      <td>471</td>\n",
              "      <td>ifrs_Equity</td>\n",
              "      <td>자본총계</td>\n",
              "      <td>22,706,415,472</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2147</th>\n",
              "      <td>950170</td>\n",
              "      <td>2018</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>JTC</td>\n",
              "      <td>471</td>\n",
              "      <td>ifrs_EquityAndLiabilities</td>\n",
              "      <td>자본과부채총계</td>\n",
              "      <td>32,205,528,508</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>48325 rows × 8 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-bcc412c9-49e1-491b-8640-dcd4745f2f16')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-bcc412c9-49e1-491b-8640-dcd4745f2f16 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-bcc412c9-49e1-491b-8640-dcd4745f2f16');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 25
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "len(당기순이익누락추정['종목코드'].unique())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "jsQYiEIkxfNz",
        "outputId": "a05b8521-8e53-45ed-edd0-79240884aada"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "171"
            ]
          },
          "metadata": {},
          "execution_count": 26
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "mask = 당기순이익누락추정['항목코드'].str.contains('ifrs_GrossProfit|ifrs-full_GrossProfit|ifrs_Revenue|ifrs-full_Revenue|dart_OperatingIncomeLoss|ifrs_ComprehensiveIncome|ifrs-full_ComprehensiveIncome')\n",
        "df3 = 당기순이익누락추정[~mask]\n",
        "df3 = df3[(df3['항목명'].isin(당기순이익조건))|(df3['항목코드'].isin(['ifrs_ProfitLoss', 'ifrs-full_ProfitLoss']))]\n",
        "df3"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "LEzyRpjaDEr4",
        "outputId": "f4e65927-937d-4cb1-f204-d3e0c8a65a91"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         종목코드  사업연도   보고서종류       회사명   업종  \\\n",
              "31454  000440  2017   반기보고서    중앙에너비스  467   \n",
              "4952   001140  2016  1분기보고서        국보  493   \n",
              "15094  001360  2017   반기보고서      삼성제약  212   \n",
              "17318  001430  2015   사업보고서     세아베스틸  241   \n",
              "17378  001430  2016  1분기보고서     세아베스틸  241   \n",
              "...       ...   ...     ...       ...  ...   \n",
              "30628  900300  2020   사업보고서  오가닉티코스메틱  649   \n",
              "28939  900300  2021  1분기보고서  오가닉티코스메틱  649   \n",
              "29815  900300  2021  3분기보고서  오가닉티코스메틱  649   \n",
              "29643  900300  2021   반기보고서  오가닉티코스메틱  649   \n",
              "32382  900310  2017   반기보고서      컬러레이  715   \n",
              "\n",
              "                                                    항목코드  \\\n",
              "31454  entity00149770_udf_IS_201781119916571_Statemen...   \n",
              "4952   dart_OtherComprehensiveIncomeThatWillNotBeRecl...   \n",
              "15094                                    ifrs_ProfitLoss   \n",
              "17318  entity00106669_udf_IS_20155292156891_Statement...   \n",
              "17378  entity00106669_udf_IS_20155292156891_Statement...   \n",
              "...                                                  ...   \n",
              "30628                               ifrs-full_ProfitLoss   \n",
              "28939                               ifrs-full_ProfitLoss   \n",
              "29815                               ifrs-full_ProfitLoss   \n",
              "29643                               ifrs-full_ProfitLoss   \n",
              "32382  entity01236286_udf_IS_201782410187124_Statemen...   \n",
              "\n",
              "                          항목명               당기  \n",
              "31454           계속영업당기순이익(손실)      960,203,538  \n",
              "4952   당기손익으로 재분류되지 않는 기타포괄손익      -18,591,074  \n",
              "15094           계속영업당기순이익(손실)   -4,287,990,068  \n",
              "17318               당기순이익(손실)  165,047,731,489  \n",
              "17378               당기순이익(손실)   28,834,278,944  \n",
              "...                       ...              ...  \n",
              "30628         연결당기순이익 및 총포괄이익       46,082,441  \n",
              "28939                   총포괄이익       26,755,208  \n",
              "29815                   총포괄이익       26,653,186  \n",
              "29643                   총포괄이익       56,682,380  \n",
              "32382                   반기순이익       69,885,510  \n",
              "\n",
              "[555 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-2b59a236-5412-463b-b768-fe095a917c3d\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>31454</th>\n",
              "      <td>000440</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>중앙에너비스</td>\n",
              "      <td>467</td>\n",
              "      <td>entity00149770_udf_IS_201781119916571_Statemen...</td>\n",
              "      <td>계속영업당기순이익(손실)</td>\n",
              "      <td>960,203,538</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4952</th>\n",
              "      <td>001140</td>\n",
              "      <td>2016</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>국보</td>\n",
              "      <td>493</td>\n",
              "      <td>dart_OtherComprehensiveIncomeThatWillNotBeRecl...</td>\n",
              "      <td>당기손익으로 재분류되지 않는 기타포괄손익</td>\n",
              "      <td>-18,591,074</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15094</th>\n",
              "      <td>001360</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>삼성제약</td>\n",
              "      <td>212</td>\n",
              "      <td>ifrs_ProfitLoss</td>\n",
              "      <td>계속영업당기순이익(손실)</td>\n",
              "      <td>-4,287,990,068</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17318</th>\n",
              "      <td>001430</td>\n",
              "      <td>2015</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>세아베스틸</td>\n",
              "      <td>241</td>\n",
              "      <td>entity00106669_udf_IS_20155292156891_Statement...</td>\n",
              "      <td>당기순이익(손실)</td>\n",
              "      <td>165,047,731,489</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17378</th>\n",
              "      <td>001430</td>\n",
              "      <td>2016</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>세아베스틸</td>\n",
              "      <td>241</td>\n",
              "      <td>entity00106669_udf_IS_20155292156891_Statement...</td>\n",
              "      <td>당기순이익(손실)</td>\n",
              "      <td>28,834,278,944</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30628</th>\n",
              "      <td>900300</td>\n",
              "      <td>2020</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>오가닉티코스메틱</td>\n",
              "      <td>649</td>\n",
              "      <td>ifrs-full_ProfitLoss</td>\n",
              "      <td>연결당기순이익 및 총포괄이익</td>\n",
              "      <td>46,082,441</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28939</th>\n",
              "      <td>900300</td>\n",
              "      <td>2021</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>오가닉티코스메틱</td>\n",
              "      <td>649</td>\n",
              "      <td>ifrs-full_ProfitLoss</td>\n",
              "      <td>총포괄이익</td>\n",
              "      <td>26,755,208</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29815</th>\n",
              "      <td>900300</td>\n",
              "      <td>2021</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>오가닉티코스메틱</td>\n",
              "      <td>649</td>\n",
              "      <td>ifrs-full_ProfitLoss</td>\n",
              "      <td>총포괄이익</td>\n",
              "      <td>26,653,186</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29643</th>\n",
              "      <td>900300</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>오가닉티코스메틱</td>\n",
              "      <td>649</td>\n",
              "      <td>ifrs-full_ProfitLoss</td>\n",
              "      <td>총포괄이익</td>\n",
              "      <td>56,682,380</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32382</th>\n",
              "      <td>900310</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>컬러레이</td>\n",
              "      <td>715</td>\n",
              "      <td>entity01236286_udf_IS_201782410187124_Statemen...</td>\n",
              "      <td>반기순이익</td>\n",
              "      <td>69,885,510</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>555 rows × 8 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-2b59a236-5412-463b-b768-fe095a917c3d')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-2b59a236-5412-463b-b768-fe095a917c3d button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-2b59a236-5412-463b-b768-fe095a917c3d');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 27
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "len(df3['종목코드'].unique())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "t3d211v_Cx1i",
        "outputId": "6b62977c-3c3e-4b7a-9a46-052f6d805d52"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "103"
            ]
          },
          "metadata": {},
          "execution_count": 28
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df3['항목명'] = df3.apply(lambda x: '당기순이익', axis=1)\n",
        "df3['항목코드'] = df3.apply(lambda x: 'ifrs_ProfitLoss', axis=1)\n",
        "df3['당기'] = df3['당기'].str.replace(',','').astype(int)\n",
        "\n",
        "df3 = df3.groupby(['종목코드', '사업연도', '보고서종류', '회사명', '업종', '항목코드', '항목명']).min().reset_index()\n",
        "df3"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "Wa97Ay-aZ3PX",
        "outputId": "a1d5192c-a305-470c-af9d-a1847011ceab"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       종목코드  사업연도   보고서종류       회사명   업종             항목코드    항목명            당기\n",
              "0    000440  2017   반기보고서    중앙에너비스  467  ifrs_ProfitLoss  당기순이익     960203538\n",
              "1    001140  2016  1분기보고서        국보  493  ifrs_ProfitLoss  당기순이익     -18591074\n",
              "2    001360  2017   반기보고서      삼성제약  212  ifrs_ProfitLoss  당기순이익   -4287990068\n",
              "3    001430  2015   사업보고서     세아베스틸  241  ifrs_ProfitLoss  당기순이익  165047731489\n",
              "4    001430  2016  1분기보고서     세아베스틸  241  ifrs_ProfitLoss  당기순이익   28834278944\n",
              "..      ...   ...     ...       ...  ...              ...    ...           ...\n",
              "437  900300  2020   사업보고서  오가닉티코스메틱  649  ifrs_ProfitLoss  당기순이익      46082441\n",
              "438  900300  2021  1분기보고서  오가닉티코스메틱  649  ifrs_ProfitLoss  당기순이익      26755208\n",
              "439  900300  2021  3분기보고서  오가닉티코스메틱  649  ifrs_ProfitLoss  당기순이익      26653186\n",
              "440  900300  2021   반기보고서  오가닉티코스메틱  649  ifrs_ProfitLoss  당기순이익      56682380\n",
              "441  900310  2017   반기보고서      컬러레이  715  ifrs_ProfitLoss  당기순이익      69885510\n",
              "\n",
              "[442 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-e1b6251b-73d1-4f0b-81ed-bc121e60b2f3\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>000440</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>중앙에너비스</td>\n",
              "      <td>467</td>\n",
              "      <td>ifrs_ProfitLoss</td>\n",
              "      <td>당기순이익</td>\n",
              "      <td>960203538</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>001140</td>\n",
              "      <td>2016</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>국보</td>\n",
              "      <td>493</td>\n",
              "      <td>ifrs_ProfitLoss</td>\n",
              "      <td>당기순이익</td>\n",
              "      <td>-18591074</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>001360</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>삼성제약</td>\n",
              "      <td>212</td>\n",
              "      <td>ifrs_ProfitLoss</td>\n",
              "      <td>당기순이익</td>\n",
              "      <td>-4287990068</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>001430</td>\n",
              "      <td>2015</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>세아베스틸</td>\n",
              "      <td>241</td>\n",
              "      <td>ifrs_ProfitLoss</td>\n",
              "      <td>당기순이익</td>\n",
              "      <td>165047731489</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>001430</td>\n",
              "      <td>2016</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>세아베스틸</td>\n",
              "      <td>241</td>\n",
              "      <td>ifrs_ProfitLoss</td>\n",
              "      <td>당기순이익</td>\n",
              "      <td>28834278944</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>437</th>\n",
              "      <td>900300</td>\n",
              "      <td>2020</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>오가닉티코스메틱</td>\n",
              "      <td>649</td>\n",
              "      <td>ifrs_ProfitLoss</td>\n",
              "      <td>당기순이익</td>\n",
              "      <td>46082441</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>438</th>\n",
              "      <td>900300</td>\n",
              "      <td>2021</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>오가닉티코스메틱</td>\n",
              "      <td>649</td>\n",
              "      <td>ifrs_ProfitLoss</td>\n",
              "      <td>당기순이익</td>\n",
              "      <td>26755208</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>439</th>\n",
              "      <td>900300</td>\n",
              "      <td>2021</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>오가닉티코스메틱</td>\n",
              "      <td>649</td>\n",
              "      <td>ifrs_ProfitLoss</td>\n",
              "      <td>당기순이익</td>\n",
              "      <td>26653186</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>440</th>\n",
              "      <td>900300</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>오가닉티코스메틱</td>\n",
              "      <td>649</td>\n",
              "      <td>ifrs_ProfitLoss</td>\n",
              "      <td>당기순이익</td>\n",
              "      <td>56682380</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>441</th>\n",
              "      <td>900310</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>컬러레이</td>\n",
              "      <td>715</td>\n",
              "      <td>ifrs_ProfitLoss</td>\n",
              "      <td>당기순이익</td>\n",
              "      <td>69885510</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>442 rows × 8 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-e1b6251b-73d1-4f0b-81ed-bc121e60b2f3')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-e1b6251b-73d1-4f0b-81ed-bc121e60b2f3 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-e1b6251b-73d1-4f0b-81ed-bc121e60b2f3');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 29
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "누락데이터 = 누락데이터.append(df3)"
      ],
      "metadata": {
        "id": "z3azg9JepCZN"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "# 매출총이익(ifrs_GrossProfit)\n",
        "\n",
        "영업손익 영업손실 매출총이익\n"
      ],
      "metadata": {
        "id": "2HfyGtl_y4oh"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "매출총이익누락추정"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "p1h7ZdMexT3H",
        "outputId": "8714d45e-d77c-4bac-f8fe-b2c3c19156c1"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         종목코드  사업연도   보고서종류    회사명   업종  \\\n",
              "29480  000230  2016  3분기보고서  일동홀딩스  212   \n",
              "29481  000230  2016  3분기보고서  일동홀딩스  212   \n",
              "29482  000230  2016  3분기보고서  일동홀딩스  212   \n",
              "29483  000230  2016  3분기보고서  일동홀딩스  212   \n",
              "29484  000230  2016  3분기보고서  일동홀딩스  212   \n",
              "...       ...   ...     ...    ...  ...   \n",
              "12697  950220  2021   반기보고서  네오이뮨텍  701   \n",
              "12698  950220  2021   반기보고서  네오이뮨텍  701   \n",
              "12699  950220  2021   반기보고서  네오이뮨텍  701   \n",
              "12700  950220  2021   반기보고서  네오이뮨텍  701   \n",
              "12701  950220  2021   반기보고서  네오이뮨텍  701   \n",
              "\n",
              "                                                    항목코드         항목명  \\\n",
              "29480                                       ifrs_Revenue        영업수익   \n",
              "29481                                   ifrs_CostOfSales        영업비용   \n",
              "29482                    dart_CostOfSalesFromSaleOfGoods        매출원가   \n",
              "29483  entity00146083_udf_IS_2016119182524679_CostOfS...     판매비와관리비   \n",
              "29484  entity00146083_udf_IS_2016119182527838_CostOfS...       연구개발비   \n",
              "...                                                  ...         ...   \n",
              "12697             dart_ElementsOfOtherStockholdersEquity    기타자본구성요소   \n",
              "12698  dart_OtherComprehensiveIncomeLossAccumulatedAm...   기타포괄손익누계액   \n",
              "12699                         ifrs-full_RetainedEarnings  이익잉여금(결손금)   \n",
              "12700                                   ifrs-full_Equity        자본총계   \n",
              "12701                     ifrs-full_EquityAndLiabilities     자본과부채총계   \n",
              "\n",
              "                   당기  \n",
              "29480  33,158,126,975  \n",
              "29481  34,704,413,632  \n",
              "29482  18,522,547,868  \n",
              "29483  15,048,622,960  \n",
              "29484   1,133,242,804  \n",
              "...               ...  \n",
              "12697       7,722,041  \n",
              "12698          -1,649  \n",
              "12699     -79,685,967  \n",
              "12700     156,076,173  \n",
              "12701     169,788,099  \n",
              "\n",
              "[141935 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-dce4b3b9-e1fc-4dea-9184-262e7ffdce65\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>29480</th>\n",
              "      <td>000230</td>\n",
              "      <td>2016</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>일동홀딩스</td>\n",
              "      <td>212</td>\n",
              "      <td>ifrs_Revenue</td>\n",
              "      <td>영업수익</td>\n",
              "      <td>33,158,126,975</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29481</th>\n",
              "      <td>000230</td>\n",
              "      <td>2016</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>일동홀딩스</td>\n",
              "      <td>212</td>\n",
              "      <td>ifrs_CostOfSales</td>\n",
              "      <td>영업비용</td>\n",
              "      <td>34,704,413,632</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29482</th>\n",
              "      <td>000230</td>\n",
              "      <td>2016</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>일동홀딩스</td>\n",
              "      <td>212</td>\n",
              "      <td>dart_CostOfSalesFromSaleOfGoods</td>\n",
              "      <td>매출원가</td>\n",
              "      <td>18,522,547,868</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29483</th>\n",
              "      <td>000230</td>\n",
              "      <td>2016</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>일동홀딩스</td>\n",
              "      <td>212</td>\n",
              "      <td>entity00146083_udf_IS_2016119182524679_CostOfS...</td>\n",
              "      <td>판매비와관리비</td>\n",
              "      <td>15,048,622,960</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29484</th>\n",
              "      <td>000230</td>\n",
              "      <td>2016</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>일동홀딩스</td>\n",
              "      <td>212</td>\n",
              "      <td>entity00146083_udf_IS_2016119182527838_CostOfS...</td>\n",
              "      <td>연구개발비</td>\n",
              "      <td>1,133,242,804</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12697</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>dart_ElementsOfOtherStockholdersEquity</td>\n",
              "      <td>기타자본구성요소</td>\n",
              "      <td>7,722,041</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12698</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>dart_OtherComprehensiveIncomeLossAccumulatedAm...</td>\n",
              "      <td>기타포괄손익누계액</td>\n",
              "      <td>-1,649</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12699</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_RetainedEarnings</td>\n",
              "      <td>이익잉여금(결손금)</td>\n",
              "      <td>-79,685,967</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12700</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_Equity</td>\n",
              "      <td>자본총계</td>\n",
              "      <td>156,076,173</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12701</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_EquityAndLiabilities</td>\n",
              "      <td>자본과부채총계</td>\n",
              "      <td>169,788,099</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>141935 rows × 8 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-dce4b3b9-e1fc-4dea-9184-262e7ffdce65')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-dce4b3b9-e1fc-4dea-9184-262e7ffdce65 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-dce4b3b9-e1fc-4dea-9184-262e7ffdce65');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 31
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "len(매출총이익누락추정['종목코드'].unique())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "qd4jNgXtxT1X",
        "outputId": "ebfca176-ee1e-42e5-d9f2-c18a943644a4"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "183"
            ]
          },
          "metadata": {},
          "execution_count": 32
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "mask = 매출총이익누락추정['항목코드'].str.contains('ifrs_Revenue|ifrs-full_Revenue|dart_OperatingIncomeLoss|ifrs_ProfitLoss|ifrs-full_ProfitLoss')\n",
        "#매출총이익누락추정 = 매출총이익누락추정[~mask]"
      ],
      "metadata": {
        "id": "OWFV2qsOIaNM"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df4 = 매출총이익누락추정[~mask]\n",
        "df4 = df4[(df4['항목명'].isin(['매출총이익', 'Ⅲ.매출총이익', 'III. 매출총이익', '매출총이익(손실)', 'III.매출총이익',\n",
        "       '영업총이익', 'Ⅲ. 매출총이익(금융업영업이익)', '매출총손익', 'Ⅲ. 매출총이익',\n",
        "       '매출 총이익(손실)', '매출총이익(영업수익)', 'Ⅲ. 매출총이익(손실)',  '매출총손실',\n",
        "       'III. 매출총이익(손실)'] + 매출총이익조건))|(df4['항목코드'].isin(['ifrs_GrossProfit', 'ifrs-full_GrossProfit']))]\n",
        "df4"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "lQTDdxkbzhIh",
        "outputId": "bdbb2248-72d5-49ad-b96b-ee765658d19e"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         종목코드  사업연도   보고서종류         회사명   업종  \\\n",
              "37637  000240  2016  1분기보고서  한국타이어월드와이드  715   \n",
              "7565   003090  2015   사업보고서          대웅  715   \n",
              "7729   003090  2016  1분기보고서          대웅  715   \n",
              "7756   003090  2016  3분기보고서          대웅  715   \n",
              "7766   003090  2016   반기보고서          대웅  715   \n",
              "...       ...   ...     ...         ...  ...   \n",
              "30120  352910  2021  3분기보고서         오비고  620   \n",
              "44446  356860  2020   사업보고서         티엘비  262   \n",
              "41746  356860  2021  1분기보고서         티엘비  262   \n",
              "42927  356860  2021  3분기보고서         티엘비  262   \n",
              "42756  356860  2021   반기보고서         티엘비  262   \n",
              "\n",
              "                                                    항목코드    항목명  \\\n",
              "37637  entity00160047_udf_IS_2016515164639527_Stateme...   영업수익   \n",
              "7565   entity00111810_udf_IS_2012320145838359_Stateme...   영업수익   \n",
              "7729   entity00111810_udf_IS_2012320145838359_Stateme...   영업수익   \n",
              "7756   entity00111810_udf_IS_2012320145838359_Stateme...   영업수익   \n",
              "7766   entity00111810_udf_IS_2012320145838359_Stateme...   영업수익   \n",
              "...                                                  ...    ...   \n",
              "30120  entity00494546_udf_IS_20211112204740266_udf_IS...   영업수익   \n",
              "44446  entity00920379_udf_IS_202134104321223_Statemen...  매출총이익   \n",
              "41746  entity00920379_udf_IS_202134104321223_Statemen...  매출총이익   \n",
              "42927  entity00920379_udf_IS_202134104321223_Statemen...  매출총이익   \n",
              "42756  entity00920379_udf_IS_202134104321223_Statemen...  매출총이익   \n",
              "\n",
              "                    당기  \n",
              "37637   63,692,032,878  \n",
              "7565   996,816,139,653  \n",
              "7729   241,646,677,905  \n",
              "7756   744,339,184,958  \n",
              "7766   487,844,712,368  \n",
              "...                ...  \n",
              "30120    6,310,522,806  \n",
              "44446   23,902,992,113  \n",
              "41746    3,645,876,756  \n",
              "42927   15,465,194,146  \n",
              "42756    8,319,727,163  \n",
              "\n",
              "[476 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-09309d7a-199d-4d2a-85ed-6298efda4a12\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>37637</th>\n",
              "      <td>000240</td>\n",
              "      <td>2016</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>한국타이어월드와이드</td>\n",
              "      <td>715</td>\n",
              "      <td>entity00160047_udf_IS_2016515164639527_Stateme...</td>\n",
              "      <td>영업수익</td>\n",
              "      <td>63,692,032,878</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7565</th>\n",
              "      <td>003090</td>\n",
              "      <td>2015</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>대웅</td>\n",
              "      <td>715</td>\n",
              "      <td>entity00111810_udf_IS_2012320145838359_Stateme...</td>\n",
              "      <td>영업수익</td>\n",
              "      <td>996,816,139,653</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7729</th>\n",
              "      <td>003090</td>\n",
              "      <td>2016</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>대웅</td>\n",
              "      <td>715</td>\n",
              "      <td>entity00111810_udf_IS_2012320145838359_Stateme...</td>\n",
              "      <td>영업수익</td>\n",
              "      <td>241,646,677,905</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7756</th>\n",
              "      <td>003090</td>\n",
              "      <td>2016</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>대웅</td>\n",
              "      <td>715</td>\n",
              "      <td>entity00111810_udf_IS_2012320145838359_Stateme...</td>\n",
              "      <td>영업수익</td>\n",
              "      <td>744,339,184,958</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7766</th>\n",
              "      <td>003090</td>\n",
              "      <td>2016</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>대웅</td>\n",
              "      <td>715</td>\n",
              "      <td>entity00111810_udf_IS_2012320145838359_Stateme...</td>\n",
              "      <td>영업수익</td>\n",
              "      <td>487,844,712,368</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30120</th>\n",
              "      <td>352910</td>\n",
              "      <td>2021</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>오비고</td>\n",
              "      <td>620</td>\n",
              "      <td>entity00494546_udf_IS_20211112204740266_udf_IS...</td>\n",
              "      <td>영업수익</td>\n",
              "      <td>6,310,522,806</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44446</th>\n",
              "      <td>356860</td>\n",
              "      <td>2020</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>티엘비</td>\n",
              "      <td>262</td>\n",
              "      <td>entity00920379_udf_IS_202134104321223_Statemen...</td>\n",
              "      <td>매출총이익</td>\n",
              "      <td>23,902,992,113</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41746</th>\n",
              "      <td>356860</td>\n",
              "      <td>2021</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>티엘비</td>\n",
              "      <td>262</td>\n",
              "      <td>entity00920379_udf_IS_202134104321223_Statemen...</td>\n",
              "      <td>매출총이익</td>\n",
              "      <td>3,645,876,756</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42927</th>\n",
              "      <td>356860</td>\n",
              "      <td>2021</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>티엘비</td>\n",
              "      <td>262</td>\n",
              "      <td>entity00920379_udf_IS_202134104321223_Statemen...</td>\n",
              "      <td>매출총이익</td>\n",
              "      <td>15,465,194,146</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42756</th>\n",
              "      <td>356860</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>티엘비</td>\n",
              "      <td>262</td>\n",
              "      <td>entity00920379_udf_IS_202134104321223_Statemen...</td>\n",
              "      <td>매출총이익</td>\n",
              "      <td>8,319,727,163</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>476 rows × 8 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-09309d7a-199d-4d2a-85ed-6298efda4a12')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-09309d7a-199d-4d2a-85ed-6298efda4a12 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-09309d7a-199d-4d2a-85ed-6298efda4a12');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 34
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "len(df4['종목코드'].unique())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "t0IjlAAKzhGs",
        "outputId": "3bde0331-51f6-475f-e72e-95ec3f3de630"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "71"
            ]
          },
          "metadata": {},
          "execution_count": 35
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df4['항목명'] = df4.apply(lambda x: '매출총이익', axis=1)\n",
        "df4['항목코드'] = df4.apply(lambda x: 'ifrs_GrossProfit', axis=1)\n",
        "df4['당기'] = df4['당기'].str.replace(',','').astype(int)\n",
        "df4 = df4.groupby(['종목코드', '사업연도', '보고서종류', '회사명', '업종', '항목코드', '항목명']).max().reset_index()\n",
        "df4"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "J36x9mePZ-en",
        "outputId": "a08b7e36-db48-4884-ada0-72806dc38467"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       종목코드  사업연도   보고서종류         회사명   업종              항목코드    항목명  \\\n",
              "0    000240  2016  1분기보고서  한국타이어월드와이드  715  ifrs_GrossProfit  매출총이익   \n",
              "1    003090  2015   사업보고서          대웅  715  ifrs_GrossProfit  매출총이익   \n",
              "2    003090  2016  1분기보고서          대웅  715  ifrs_GrossProfit  매출총이익   \n",
              "3    003090  2016  3분기보고서          대웅  715  ifrs_GrossProfit  매출총이익   \n",
              "4    003090  2016   반기보고서          대웅  715  ifrs_GrossProfit  매출총이익   \n",
              "..      ...   ...     ...         ...  ...               ...    ...   \n",
              "464  352910  2021  3분기보고서         오비고  620  ifrs_GrossProfit  매출총이익   \n",
              "465  356860  2020   사업보고서         티엘비  262  ifrs_GrossProfit  매출총이익   \n",
              "466  356860  2021  1분기보고서         티엘비  262  ifrs_GrossProfit  매출총이익   \n",
              "467  356860  2021  3분기보고서         티엘비  262  ifrs_GrossProfit  매출총이익   \n",
              "468  356860  2021   반기보고서         티엘비  262  ifrs_GrossProfit  매출총이익   \n",
              "\n",
              "               당기  \n",
              "0     63692032878  \n",
              "1    996816139653  \n",
              "2    241646677905  \n",
              "3    744339184958  \n",
              "4    487844712368  \n",
              "..            ...  \n",
              "464    6310522806  \n",
              "465   23902992113  \n",
              "466    3645876756  \n",
              "467   15465194146  \n",
              "468    8319727163  \n",
              "\n",
              "[469 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-9a25d0f9-2338-43b3-a315-4102198d4464\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>000240</td>\n",
              "      <td>2016</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>한국타이어월드와이드</td>\n",
              "      <td>715</td>\n",
              "      <td>ifrs_GrossProfit</td>\n",
              "      <td>매출총이익</td>\n",
              "      <td>63692032878</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>003090</td>\n",
              "      <td>2015</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>대웅</td>\n",
              "      <td>715</td>\n",
              "      <td>ifrs_GrossProfit</td>\n",
              "      <td>매출총이익</td>\n",
              "      <td>996816139653</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>003090</td>\n",
              "      <td>2016</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>대웅</td>\n",
              "      <td>715</td>\n",
              "      <td>ifrs_GrossProfit</td>\n",
              "      <td>매출총이익</td>\n",
              "      <td>241646677905</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>003090</td>\n",
              "      <td>2016</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>대웅</td>\n",
              "      <td>715</td>\n",
              "      <td>ifrs_GrossProfit</td>\n",
              "      <td>매출총이익</td>\n",
              "      <td>744339184958</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>003090</td>\n",
              "      <td>2016</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>대웅</td>\n",
              "      <td>715</td>\n",
              "      <td>ifrs_GrossProfit</td>\n",
              "      <td>매출총이익</td>\n",
              "      <td>487844712368</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>464</th>\n",
              "      <td>352910</td>\n",
              "      <td>2021</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>오비고</td>\n",
              "      <td>620</td>\n",
              "      <td>ifrs_GrossProfit</td>\n",
              "      <td>매출총이익</td>\n",
              "      <td>6310522806</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>465</th>\n",
              "      <td>356860</td>\n",
              "      <td>2020</td>\n",
              "      <td>사업보고서</td>\n",
              "      <td>티엘비</td>\n",
              "      <td>262</td>\n",
              "      <td>ifrs_GrossProfit</td>\n",
              "      <td>매출총이익</td>\n",
              "      <td>23902992113</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>466</th>\n",
              "      <td>356860</td>\n",
              "      <td>2021</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>티엘비</td>\n",
              "      <td>262</td>\n",
              "      <td>ifrs_GrossProfit</td>\n",
              "      <td>매출총이익</td>\n",
              "      <td>3645876756</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>467</th>\n",
              "      <td>356860</td>\n",
              "      <td>2021</td>\n",
              "      <td>3분기보고서</td>\n",
              "      <td>티엘비</td>\n",
              "      <td>262</td>\n",
              "      <td>ifrs_GrossProfit</td>\n",
              "      <td>매출총이익</td>\n",
              "      <td>15465194146</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>468</th>\n",
              "      <td>356860</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>티엘비</td>\n",
              "      <td>262</td>\n",
              "      <td>ifrs_GrossProfit</td>\n",
              "      <td>매출총이익</td>\n",
              "      <td>8319727163</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>469 rows × 8 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-9a25d0f9-2338-43b3-a315-4102198d4464')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-9a25d0f9-2338-43b3-a315-4102198d4464 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-9a25d0f9-2338-43b3-a315-4102198d4464');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 36
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "누락데이터 = 누락데이터.append(df4)"
      ],
      "metadata": {
        "id": "98-TxzkspE2A"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "# 출력"
      ],
      "metadata": {
        "id": "MnZlXkDh0qMh"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "누락데이터.to_csv('/content/drive/MyDrive/22캡스톤디자인/재무일괄/일괄/누락데이터.csv', mode='a', header=False)"
      ],
      "metadata": {
        "id": "kClIrMpE0rCL"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        ""
      ],
      "metadata": {
        "id": "3KZgEKBSzg3E"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "\n",
        "\n",
        "```javascript\n",
        "function ClickConnect(){\n",
        "    console.log(\"코랩 연결 끊김 방지\"); \n",
        "    document.querySelector(\"colab-toolbar-button#connect\").click() \n",
        "}\n",
        "setInterval(ClickConnect, 60 * 1000)\n",
        "\n",
        "```\n",
        "\n"
      ],
      "metadata": {
        "id": "Mrb45Sx6Xii4"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "누락데이터.describe()"
      ],
      "metadata": {
        "id": "jGLDhJD2XoW6",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 175
        },
        "outputId": "ebb22fa1-4ed6-4c0d-ee9b-5994c74de49f"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "          종목코드  사업연도  보고서종류   회사명    업종          항목코드   항목명              당기\n",
              "count     1684  1684   1684  1684  1684          1684  1684            1684\n",
              "unique     202     7      4   207    69             4     4            1684\n",
              "top     003090  2016  반기보고서    대웅   582  ifrs_Revenue   매출액  63,692,032,878\n",
              "freq        48   503    461    48   384           558   558               1"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-076f15cd-7511-479c-8ee5-158b5ceedd50\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>1684</td>\n",
              "      <td>1684</td>\n",
              "      <td>1684</td>\n",
              "      <td>1684</td>\n",
              "      <td>1684</td>\n",
              "      <td>1684</td>\n",
              "      <td>1684</td>\n",
              "      <td>1684</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>unique</th>\n",
              "      <td>202</td>\n",
              "      <td>7</td>\n",
              "      <td>4</td>\n",
              "      <td>207</td>\n",
              "      <td>69</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>1684</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>top</th>\n",
              "      <td>003090</td>\n",
              "      <td>2016</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>대웅</td>\n",
              "      <td>582</td>\n",
              "      <td>ifrs_Revenue</td>\n",
              "      <td>매출액</td>\n",
              "      <td>63,692,032,878</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>freq</th>\n",
              "      <td>48</td>\n",
              "      <td>503</td>\n",
              "      <td>461</td>\n",
              "      <td>48</td>\n",
              "      <td>384</td>\n",
              "      <td>558</td>\n",
              "      <td>558</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-076f15cd-7511-479c-8ee5-158b5ceedd50')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-076f15cd-7511-479c-8ee5-158b5ceedd50 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-076f15cd-7511-479c-8ee5-158b5ceedd50');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 40
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        ""
      ],
      "metadata": {
        "id": "klWbshYYpkD3"
      },
      "execution_count": null,
      "outputs": []
    }
  ],
  "metadata": {
    "colab": {
      "collapsed_sections": [],
      "name": "누락찾기V3.ipynb",
      "provenance": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "display_name": "Python 3",
      "name": "python3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}