누락찾기V2.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%B0V2.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "id": "w0DqBUtZeVkw",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "a97e667c-c6f5-4e4e-8b1a-d69c540868d6"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "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: 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",
            "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",
            "Installing collected packages: requests-file, finance-datareader\n",
            "Successfully installed finance-datareader-0.9.33 requests-file-1.5.1\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": 4,
      "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": "1cb45734-44ab-4f35-d1f7-c1b51525333e"
      },
      "execution_count": 7,
      "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-35eb1d5d-0b18-417e-bb69-b5202891c8ae\">\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-35eb1d5d-0b18-417e-bb69-b5202891c8ae')\"\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-35eb1d5d-0b18-417e-bb69-b5202891c8ae 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-35eb1d5d-0b18-417e-bb69-b5202891c8ae');\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": 7
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "1zpWpk5fERHl"
      },
      "source": [
        "# 데이터 가져옴"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 8,
      "metadata": {
        "id": "tQ8UoqOBxYmS"
      },
      "outputs": [],
      "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",
        "전체누락 = 자산총계누락 + 부채총계누락 + 자본총계누락 + 매출액누락 + 영업이익누락 + 매출총이익누락 + 당기순이익누락"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 9,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "eGu2g_9tx6pa",
        "outputId": "b4a16b67-93e5-4b2e-ec02-82590913cb8b"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "자산총계누락: 15\n",
            "부채총계누락: 3\n",
            "자본총계누락: 5\n",
            "매출액누락: 133\n",
            "영업이익누락: 58\n",
            "매출총이익누락: 184\n",
            "당기순이익누락: 172\n",
            "\n",
            "=========================\n",
            "전체누락: 570\n"
          ]
        }
      ],
      "source": [
        "print(f\"자산총계누락: {len(자산총계누락)}\")\n",
        "print(f\"부채총계누락: {len(부채총계누락)}\")\n",
        "print(f\"자본총계누락: {len(자본총계누락)}\")\n",
        "print(f\"매출액누락: {len(매출액누락)}\")\n",
        "print(f\"영업이익누락: {len(영업이익누락)}\")\n",
        "print(f\"매출총이익누락: {len(매출총이익누락)}\")\n",
        "print(f\"당기순이익누락: {len(당기순이익누락)}\")\n",
        "\n",
        "print()\n",
        "print('=========================')\n",
        "print(f\"전체누락: {len(전체누락)}\")"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "전체누락_unq = list(set(전체누락))\n",
        "print(f\"전체누락 unique: {len(전체누락_unq)}\")"
      ],
      "metadata": {
        "id": "Dpcw3gceg-6G",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "76d838a7-7a3a-458b-b753-82b73024fb7b"
      },
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "전체누락 unique: 381\n"
          ]
        }
      ]
    },
    {
      "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": 11,
      "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])"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "0jddWPMwFN9w",
        "outputId": "a624a4ae-5e63-44d3-dbca-b299fdb399ba"
      },
      "execution_count": 12,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            " 21%|██        | 5/24 [00:16<00:41,  2.17s/it]/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:01<00:00, 19.57it/s]\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "매출액누락_정보 = 통합재무정보[(통합재무정보['종목코드'].isin(매출액누락)*통합재무정보['매출액'] == '0')][['종목코드','사업연도','보고서종류','매출액']]\n",
        "매출액누락_정보 = 매출액누락_정보.sort_values(by=['종목코드', '사업연도', '보고서종류'])\n",
        "영업이익누락_정보 = 통합재무정보[(통합재무정보['종목코드'].isin(영업이익누락))&(통합재무정보['영업이익'] == '0')][['종목코드','사업연도','보고서종류','영업이익']]\n",
        "영업이익누락_정보 = 영업이익누락_정보.sort_values(by=['종목코드', '사업연도', '보고서종류'])\n",
        "매출총이익누락_정보 = 통합재무정보[(통합재무정보['종목코드'].isin(매출총이익누락))&(통합재무정보['매출총이익'] == '0')][['종목코드','사업연도','보고서종류','매출총이익']]\n",
        "매출총이익누락_정보 = 매출총이익누락_정보.sort_values(by=['종목코드', '사업연도', '보고서종류'])\n",
        "당기순이익누락_정보 = 통합재무정보[(통합재무정보['종목코드'].isin(당기순이익누락))&(통합재무정보['당기순이익'] == '0')][['종목코드','사업연도','보고서종류', '당기순이익']]\n",
        "당기순이익누락_정보 = 당기순이익누락_정보.sort_values(by=['종목코드', '사업연도', '보고서종류'])"
      ],
      "metadata": {
        "id": "aZlc-d63k1Cv"
      },
      "execution_count": 13,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "# 당기순이익 누락"
      ],
      "metadata": {
        "id": "yrwpRoqqwy_F"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df = pd.DataFrame(columns=['종목코드','사업연도', '보고서종류', '회사명', '업종', '항목코드','항목명', '당기'])\n",
        "for row_tuple in tqdm(당기순이익누락_정보.iterrows()):\n",
        "  row_종목코드 = row_tuple[1]['종목코드']\n",
        "  row_사업연도 = row_tuple[1]['사업연도']\n",
        "  row_보고서종류 = row_tuple[1]['보고서종류']\n",
        "\n",
        "  df = df.append(손익계산샘플[(손익계산샘플['종목코드'] == row_종목코드)&(손익계산샘플['사업연도'] == str(row_사업연도))&(손익계산샘플['보고서종류'] == row_보고서종류)])\n",
        "  df = df.append(포괄손익계산샘플[(포괄손익계산샘플['종목코드'] == row_종목코드)&(포괄손익계산샘플['사업연도'] == str(row_사업연도))&(포괄손익계산샘플['보고서종류'] == row_보고서종류)])\n",
        "\n",
        "df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 442
        },
        "id": "vLO39bWNmDhL",
        "outputId": "5b5c1c33-7ab3-4d91-fe36-c9d7bb067383"
      },
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "747it [02:58,  4.19it/s]\n"
          ]
        },
        {
          "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",
              "1238   950170  2018  1분기보고서     JTC  471   \n",
              "1239   950170  2018  1분기보고서     JTC  471   \n",
              "1240   950170  2018  1분기보고서     JTC  471   \n",
              "1241   950170  2018  1분기보고서     JTC  471   \n",
              "1242   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",
              "1238                            ifrs_ComprehensiveIncome            총포괄손익   \n",
              "1239   entity01041828_udf_IS_20187231720157_Comprehen...   지배기업의 소유주지분순이익   \n",
              "1240                       ifrs_EarningsPerShareAbstract  주당이익 [abstract]   \n",
              "1241                      ifrs_BasicEarningsLossPerShare   기본주당이익(손실) (엔)   \n",
              "1242                    ifrs_DilutedEarningsLossPerShare   희석주당이익(손실) (엔)   \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",
              "1238              NaN  \n",
              "1239      486,129,255  \n",
              "1240              NaN  \n",
              "1241               14  \n",
              "1242               14  \n",
              "\n",
              "[21991 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-4479bf13-4d4b-4a7e-8d89-dc2f22ffa5cf\">\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>1238</th>\n",
              "      <td>950170</td>\n",
              "      <td>2018</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>JTC</td>\n",
              "      <td>471</td>\n",
              "      <td>ifrs_ComprehensiveIncome</td>\n",
              "      <td>총포괄손익</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1239</th>\n",
              "      <td>950170</td>\n",
              "      <td>2018</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>JTC</td>\n",
              "      <td>471</td>\n",
              "      <td>entity01041828_udf_IS_20187231720157_Comprehen...</td>\n",
              "      <td>지배기업의 소유주지분순이익</td>\n",
              "      <td>486,129,255</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1240</th>\n",
              "      <td>950170</td>\n",
              "      <td>2018</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>JTC</td>\n",
              "      <td>471</td>\n",
              "      <td>ifrs_EarningsPerShareAbstract</td>\n",
              "      <td>주당이익 [abstract]</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1241</th>\n",
              "      <td>950170</td>\n",
              "      <td>2018</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>JTC</td>\n",
              "      <td>471</td>\n",
              "      <td>ifrs_BasicEarningsLossPerShare</td>\n",
              "      <td>기본주당이익(손실) (엔)</td>\n",
              "      <td>14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1242</th>\n",
              "      <td>950170</td>\n",
              "      <td>2018</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>JTC</td>\n",
              "      <td>471</td>\n",
              "      <td>ifrs_DilutedEarningsLossPerShare</td>\n",
              "      <td>희석주당이익(손실) (엔)</td>\n",
              "      <td>14</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>21991 rows × 8 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-4479bf13-4d4b-4a7e-8d89-dc2f22ffa5cf')\"\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-4479bf13-4d4b-4a7e-8d89-dc2f22ffa5cf 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-4479bf13-4d4b-4a7e-8d89-dc2f22ffa5cf');\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": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df = df.replace(0, np.NaN)\n",
        "df = df.replace('0', np.NaN)\n",
        "df.dropna(axis=0, inplace=True)\n",
        "df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "PL5Y9fnEPrIX",
        "outputId": "3a4c1b1d-0a3e-49a2-8ce1-3bbdf07c7312"
      },
      "execution_count": 15,
      "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",
              "1236   950170  2018  1분기보고서     JTC  471   \n",
              "1237   950170  2018  1분기보고서     JTC  471   \n",
              "1239   950170  2018  1분기보고서     JTC  471   \n",
              "1241   950170  2018  1분기보고서     JTC  471   \n",
              "1242   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",
              "1236   dart_OtherComprehensiveIncomeThatWillBeReclass...   \n",
              "1237   ifrs_GainsLossesOnExchangeDifferencesOnTransla...   \n",
              "1239   entity01041828_udf_IS_20187231720157_Comprehen...   \n",
              "1241                      ifrs_BasicEarningsLossPerShare   \n",
              "1242                    ifrs_DilutedEarningsLossPerShare   \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",
              "1236   당기손익으로 재분류될 수 있는 항목(세후기타포괄손익)      24,883,013  \n",
              "1237           해외사업장환산외환차이(세후기타포괄손익)      24,883,013  \n",
              "1239                  지배기업의 소유주지분순이익     486,129,255  \n",
              "1241                  기본주당이익(손실) (엔)              14  \n",
              "1242                  희석주당이익(손실) (엔)              14  \n",
              "\n",
              "[18173 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-7280b9ed-e65d-4cb8-bf9f-7509749e65a9\">\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>1236</th>\n",
              "      <td>950170</td>\n",
              "      <td>2018</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>JTC</td>\n",
              "      <td>471</td>\n",
              "      <td>dart_OtherComprehensiveIncomeThatWillBeReclass...</td>\n",
              "      <td>당기손익으로 재분류될 수 있는 항목(세후기타포괄손익)</td>\n",
              "      <td>24,883,013</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1237</th>\n",
              "      <td>950170</td>\n",
              "      <td>2018</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>JTC</td>\n",
              "      <td>471</td>\n",
              "      <td>ifrs_GainsLossesOnExchangeDifferencesOnTransla...</td>\n",
              "      <td>해외사업장환산외환차이(세후기타포괄손익)</td>\n",
              "      <td>24,883,013</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1239</th>\n",
              "      <td>950170</td>\n",
              "      <td>2018</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>JTC</td>\n",
              "      <td>471</td>\n",
              "      <td>entity01041828_udf_IS_20187231720157_Comprehen...</td>\n",
              "      <td>지배기업의 소유주지분순이익</td>\n",
              "      <td>486,129,255</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1241</th>\n",
              "      <td>950170</td>\n",
              "      <td>2018</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>JTC</td>\n",
              "      <td>471</td>\n",
              "      <td>ifrs_BasicEarningsLossPerShare</td>\n",
              "      <td>기본주당이익(손실) (엔)</td>\n",
              "      <td>14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1242</th>\n",
              "      <td>950170</td>\n",
              "      <td>2018</td>\n",
              "      <td>1분기보고서</td>\n",
              "      <td>JTC</td>\n",
              "      <td>471</td>\n",
              "      <td>ifrs_DilutedEarningsLossPerShare</td>\n",
              "      <td>희석주당이익(손실) (엔)</td>\n",
              "      <td>14</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>18173 rows × 8 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-7280b9ed-e65d-4cb8-bf9f-7509749e65a9')\"\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-7280b9ed-e65d-4cb8-bf9f-7509749e65a9 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-7280b9ed-e65d-4cb8-bf9f-7509749e65a9');\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": [
        "df.to_csv('/content/drive/MyDrive/22캡스톤디자인/재무일괄/일괄/당기순이익누락추정.csv')"
      ],
      "metadata": {
        "id": "3cyoiDfMssU1"
      },
      "execution_count": 16,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "# 매출액누락"
      ],
      "metadata": {
        "id": "wYHhTXd5w5Eh"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df2 = pd.DataFrame(columns=['종목코드','사업연도', '보고서종류', '회사명', '업종', '항목코드','항목명', '당기'])\n",
        "for row_tuple in tqdm(매출액누락_정보.iterrows()):\n",
        "  row_종목코드 = row_tuple[1]['종목코드']\n",
        "  row_사업연도 = row_tuple[1]['사업연도']\n",
        "  row_보고서종류 = row_tuple[1]['보고서종류']\n",
        "\n",
        "  df2 = df2.append(손익계산샘플[(손익계산샘플['종목코드'] == row_종목코드)&(손익계산샘플['사업연도'] == str(row_사업연도))&(손익계산샘플['보고서종류'] == row_보고서종류)])\n",
        "  df2 = df2.append(포괄손익계산샘플[(포괄손익계산샘플['종목코드'] == row_종목코드)&(포괄손익계산샘플['사업연도'] == str(row_사업연도))&(포괄손익계산샘플['보고서종류'] == row_보고서종류)])\n",
        "\n",
        "df2"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 442
        },
        "id": "WHEL98jLN6M0",
        "outputId": "d03d9fac-9189-42b4-aea0-b4fe39aa03d4"
      },
      "execution_count": 17,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "910it [04:46,  3.18it/s]\n"
          ]
        },
        {
          "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",
              "7495   950220  2021   반기보고서       네오이뮨텍  701   \n",
              "7496   950220  2021   반기보고서       네오이뮨텍  701   \n",
              "7497   950220  2021   반기보고서       네오이뮨텍  701   \n",
              "7498   950220  2021   반기보고서       네오이뮨텍  701   \n",
              "7499   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",
              "7495   ifrs-full_GainsLossesOnExchangeDifferencesOnTr...         해외사업환산손익   \n",
              "7496                       ifrs-full_ComprehensiveIncome            총포괄손익   \n",
              "7497                  ifrs-full_EarningsPerShareAbstract  주당이익 [abstract]   \n",
              "7498                 ifrs-full_BasicEarningsLossPerShare       기본주당이익(손실)   \n",
              "7499               ifrs-full_DilutedEarningsLossPerShare       희석주당이익(손실)   \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",
              "7495         -114,974  \n",
              "7496      -22,107,118  \n",
              "7497              NaN  \n",
              "7498               -1  \n",
              "7499               -1  \n",
              "\n",
              "[26996 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-d480737c-2028-4834-991b-de535bb0ed6c\">\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>7495</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_GainsLossesOnExchangeDifferencesOnTr...</td>\n",
              "      <td>해외사업환산손익</td>\n",
              "      <td>-114,974</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7496</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_ComprehensiveIncome</td>\n",
              "      <td>총포괄손익</td>\n",
              "      <td>-22,107,118</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7497</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_EarningsPerShareAbstract</td>\n",
              "      <td>주당이익 [abstract]</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7498</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_BasicEarningsLossPerShare</td>\n",
              "      <td>기본주당이익(손실)</td>\n",
              "      <td>-1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7499</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_DilutedEarningsLossPerShare</td>\n",
              "      <td>희석주당이익(손실)</td>\n",
              "      <td>-1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>26996 rows × 8 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-d480737c-2028-4834-991b-de535bb0ed6c')\"\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-d480737c-2028-4834-991b-de535bb0ed6c 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-d480737c-2028-4834-991b-de535bb0ed6c');\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": [
        "df2 = df2.replace(0, np.NaN)\n",
        "df2 = df2.replace('0', np.NaN)\n",
        "df2.dropna(axis=0, inplace=True)\n",
        "df2"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "nBeAhqUpkgB-",
        "outputId": "bdf4f29b-47fa-487c-b8d8-4fbeb88ec052"
      },
      "execution_count": 18,
      "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",
              "7493   950220  2021   반기보고서       네오이뮨텍  701   \n",
              "7495   950220  2021   반기보고서       네오이뮨텍  701   \n",
              "7496   950220  2021   반기보고서       네오이뮨텍  701   \n",
              "7498   950220  2021   반기보고서       네오이뮨텍  701   \n",
              "7499   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",
              "7493   dart_OtherComprehensiveIncomeNetOfTaxGainsLoss...   \n",
              "7495   ifrs-full_GainsLossesOnExchangeDifferencesOnTr...   \n",
              "7496                       ifrs-full_ComprehensiveIncome   \n",
              "7498                 ifrs-full_BasicEarningsLossPerShare   \n",
              "7499               ifrs-full_DilutedEarningsLossPerShare   \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",
              "7493   순확정부채의 재측정손익(세후기타포괄손익)           3,584  \n",
              "7495                 해외사업환산손익        -114,974  \n",
              "7496                    총포괄손익     -22,107,118  \n",
              "7498               기본주당이익(손실)              -1  \n",
              "7499               희석주당이익(손실)              -1  \n",
              "\n",
              "[22296 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-f6155481-a449-49f8-b057-8eb3abd3a409\">\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>7493</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>dart_OtherComprehensiveIncomeNetOfTaxGainsLoss...</td>\n",
              "      <td>순확정부채의 재측정손익(세후기타포괄손익)</td>\n",
              "      <td>3,584</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7495</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_GainsLossesOnExchangeDifferencesOnTr...</td>\n",
              "      <td>해외사업환산손익</td>\n",
              "      <td>-114,974</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7496</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_ComprehensiveIncome</td>\n",
              "      <td>총포괄손익</td>\n",
              "      <td>-22,107,118</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7498</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_BasicEarningsLossPerShare</td>\n",
              "      <td>기본주당이익(손실)</td>\n",
              "      <td>-1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7499</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_DilutedEarningsLossPerShare</td>\n",
              "      <td>희석주당이익(손실)</td>\n",
              "      <td>-1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>22296 rows × 8 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f6155481-a449-49f8-b057-8eb3abd3a409')\"\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-f6155481-a449-49f8-b057-8eb3abd3a409 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-f6155481-a449-49f8-b057-8eb3abd3a409');\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": 18
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df2.to_csv('/content/drive/MyDrive/22캡스톤디자인/재무일괄/일괄/매출액누락추정.csv')"
      ],
      "metadata": {
        "id": "Atu6bqMAs2y7"
      },
      "execution_count": 19,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "# 영업이익누락"
      ],
      "metadata": {
        "id": "qm-1ESbqw6fU"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df3 = pd.DataFrame(columns=['종목코드','사업연도', '보고서종류', '회사명', '업종', '항목코드','항목명', '당기'])\n",
        "for row_tuple in tqdm(영업이익누락_정보.iterrows()):\n",
        "  row_종목코드 = row_tuple[1]['종목코드']\n",
        "  row_사업연도 = row_tuple[1]['사업연도']\n",
        "  row_보고서종류 = row_tuple[1]['보고서종류']\n",
        "\n",
        "  df3 = df3.append(손익계산샘플[(손익계산샘플['종목코드'] == row_종목코드)&(손익계산샘플['사업연도'] == str(row_사업연도))&(손익계산샘플['보고서종류'] == row_보고서종류)])\n",
        "  df3 = df3.append(포괄손익계산샘플[(포괄손익계산샘플['종목코드'] == row_종목코드)&(포괄손익계산샘플['사업연도'] == str(row_사업연도))&(포괄손익계산샘플['보고서종류'] == row_보고서종류)])\n",
        "\n",
        "df3"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 442
        },
        "id": "hL7TI8-StGo1",
        "outputId": "a8640a88-3a86-46ba-d76e-72d031ef1519"
      },
      "execution_count": 20,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "254it [00:59,  4.24it/s]\n"
          ]
        },
        {
          "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",
              "30177  950140  2017  반기보고서   잉글우드랩  649   \n",
              "30178  950140  2017  반기보고서   잉글우드랩  649   \n",
              "30179  950140  2017  반기보고서   잉글우드랩  649   \n",
              "30180  950140  2017  반기보고서   잉글우드랩  649   \n",
              "30181  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",
              "30177  entity01165739_udf_IS_2017426122125948_udf_IS_...  매도가능금융자산평가손실의 대체   \n",
              "30178  entity01165739_udf_IS_2017426122141765_udf_IS_...          해외사업환산손익   \n",
              "30179                           ifrs_ComprehensiveIncome             총포괄이익   \n",
              "30180                      ifrs_EarningsPerShareAbstract   주당이익 [abstract]   \n",
              "30181                     ifrs_BasicEarningsLossPerShare        기본주당이익(손실)   \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",
              "30177       2,518,898  \n",
              "30178        -323,658  \n",
              "30179      -2,636,394  \n",
              "30180             NaN  \n",
              "30181              -0  \n",
              "\n",
              "[7725 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-aa666aed-474a-4d7e-9182-8d9f2e82bebd\">\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>30177</th>\n",
              "      <td>950140</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>잉글우드랩</td>\n",
              "      <td>649</td>\n",
              "      <td>entity01165739_udf_IS_2017426122125948_udf_IS_...</td>\n",
              "      <td>매도가능금융자산평가손실의 대체</td>\n",
              "      <td>2,518,898</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30178</th>\n",
              "      <td>950140</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>잉글우드랩</td>\n",
              "      <td>649</td>\n",
              "      <td>entity01165739_udf_IS_2017426122141765_udf_IS_...</td>\n",
              "      <td>해외사업환산손익</td>\n",
              "      <td>-323,658</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30179</th>\n",
              "      <td>950140</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>잉글우드랩</td>\n",
              "      <td>649</td>\n",
              "      <td>ifrs_ComprehensiveIncome</td>\n",
              "      <td>총포괄이익</td>\n",
              "      <td>-2,636,394</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30180</th>\n",
              "      <td>950140</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>잉글우드랩</td>\n",
              "      <td>649</td>\n",
              "      <td>ifrs_EarningsPerShareAbstract</td>\n",
              "      <td>주당이익 [abstract]</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30181</th>\n",
              "      <td>950140</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>잉글우드랩</td>\n",
              "      <td>649</td>\n",
              "      <td>ifrs_BasicEarningsLossPerShare</td>\n",
              "      <td>기본주당이익(손실)</td>\n",
              "      <td>-0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>7725 rows × 8 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-aa666aed-474a-4d7e-9182-8d9f2e82bebd')\"\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-aa666aed-474a-4d7e-9182-8d9f2e82bebd 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-aa666aed-474a-4d7e-9182-8d9f2e82bebd');\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": 20
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df3 = df3.replace(0, np.NaN)\n",
        "df3 = df3.replace('0', np.NaN)\n",
        "df3.dropna(axis=0, inplace=True)\n",
        "df3"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "egnnXy3xtGnV",
        "outputId": "04b9c4cd-1d51-4071-f6a4-920ca9227def"
      },
      "execution_count": 21,
      "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",
              "30174  950140  2017  반기보고서   잉글우드랩  649   \n",
              "30177  950140  2017  반기보고서   잉글우드랩  649   \n",
              "30178  950140  2017  반기보고서   잉글우드랩  649   \n",
              "30179  950140  2017  반기보고서   잉글우드랩  649   \n",
              "30181  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",
              "30174  entity01165739_udf_IS_201782495255736_udf_IS_2...      순확정급여부채재측정요소   \n",
              "30177  entity01165739_udf_IS_2017426122125948_udf_IS_...  매도가능금융자산평가손실의 대체   \n",
              "30178  entity01165739_udf_IS_2017426122141765_udf_IS_...          해외사업환산손익   \n",
              "30179                           ifrs_ComprehensiveIncome             총포괄이익   \n",
              "30181                     ifrs_BasicEarningsLossPerShare        기본주당이익(손실)   \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",
              "30174         -52,992  \n",
              "30177       2,518,898  \n",
              "30178        -323,658  \n",
              "30179      -2,636,394  \n",
              "30181              -0  \n",
              "\n",
              "[6359 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-e065f406-0694-478b-a894-f84221be8530\">\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>30174</th>\n",
              "      <td>950140</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>잉글우드랩</td>\n",
              "      <td>649</td>\n",
              "      <td>entity01165739_udf_IS_201782495255736_udf_IS_2...</td>\n",
              "      <td>순확정급여부채재측정요소</td>\n",
              "      <td>-52,992</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30177</th>\n",
              "      <td>950140</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>잉글우드랩</td>\n",
              "      <td>649</td>\n",
              "      <td>entity01165739_udf_IS_2017426122125948_udf_IS_...</td>\n",
              "      <td>매도가능금융자산평가손실의 대체</td>\n",
              "      <td>2,518,898</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30178</th>\n",
              "      <td>950140</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>잉글우드랩</td>\n",
              "      <td>649</td>\n",
              "      <td>entity01165739_udf_IS_2017426122141765_udf_IS_...</td>\n",
              "      <td>해외사업환산손익</td>\n",
              "      <td>-323,658</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30179</th>\n",
              "      <td>950140</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>잉글우드랩</td>\n",
              "      <td>649</td>\n",
              "      <td>ifrs_ComprehensiveIncome</td>\n",
              "      <td>총포괄이익</td>\n",
              "      <td>-2,636,394</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30181</th>\n",
              "      <td>950140</td>\n",
              "      <td>2017</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>잉글우드랩</td>\n",
              "      <td>649</td>\n",
              "      <td>ifrs_BasicEarningsLossPerShare</td>\n",
              "      <td>기본주당이익(손실)</td>\n",
              "      <td>-0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>6359 rows × 8 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-e065f406-0694-478b-a894-f84221be8530')\"\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-e065f406-0694-478b-a894-f84221be8530 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-e065f406-0694-478b-a894-f84221be8530');\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": [
        "df3.to_csv('/content/drive/MyDrive/22캡스톤디자인/재무일괄/일괄/영업이익누락추정.csv')"
      ],
      "metadata": {
        "id": "jrw8PAoJtGlM"
      },
      "execution_count": 22,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "# 매출총이익누락"
      ],
      "metadata": {
        "id": "cK-R8q7Fw8p4"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df4 = pd.DataFrame(columns=['종목코드','사업연도', '보고서종류', '회사명', '업종', '항목코드','항목명', '당기'])\n",
        "for row_tuple in tqdm(매출총이익누락_정보.iterrows()):\n",
        "  row_종목코드 = row_tuple[1]['종목코드']\n",
        "  row_사업연도 = row_tuple[1]['사업연도']\n",
        "  row_보고서종류 = row_tuple[1]['보고서종류']\n",
        "\n",
        "  df4 = df4.append(손익계산샘플[(손익계산샘플['종목코드'] == row_종목코드)&(손익계산샘플['사업연도'] == str(row_사업연도))&(손익계산샘플['보고서종류'] == row_보고서종류)])\n",
        "  df4 = df4.append(포괄손익계산샘플[(포괄손익계산샘플['종목코드'] == row_종목코드)&(포괄손익계산샘플['사업연도'] == str(row_사업연도))&(포괄손익계산샘플['보고서종류'] == row_보고서종류)])\n",
        "\n",
        "df4"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 442
        },
        "id": "T2c4gCVetGhJ",
        "outputId": "4272f190-de45-4cb2-ed24-9b8717cb4a6f"
      },
      "execution_count": 23,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "2180it [09:08,  3.97it/s]\n"
          ]
        },
        {
          "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",
              "7495   950220  2021   반기보고서  네오이뮨텍  701   \n",
              "7496   950220  2021   반기보고서  네오이뮨텍  701   \n",
              "7497   950220  2021   반기보고서  네오이뮨텍  701   \n",
              "7498   950220  2021   반기보고서  네오이뮨텍  701   \n",
              "7499   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",
              "7495   ifrs-full_GainsLossesOnExchangeDifferencesOnTr...         해외사업환산손익   \n",
              "7496                       ifrs-full_ComprehensiveIncome            총포괄손익   \n",
              "7497                  ifrs-full_EarningsPerShareAbstract  주당이익 [abstract]   \n",
              "7498                 ifrs-full_BasicEarningsLossPerShare       기본주당이익(손실)   \n",
              "7499               ifrs-full_DilutedEarningsLossPerShare       희석주당이익(손실)   \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",
              "7495         -114,974  \n",
              "7496      -22,107,118  \n",
              "7497              NaN  \n",
              "7498               -1  \n",
              "7499               -1  \n",
              "\n",
              "[65659 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-ac4be547-9723-492d-aec6-90090fd8c0e2\">\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>7495</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_GainsLossesOnExchangeDifferencesOnTr...</td>\n",
              "      <td>해외사업환산손익</td>\n",
              "      <td>-114,974</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7496</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_ComprehensiveIncome</td>\n",
              "      <td>총포괄손익</td>\n",
              "      <td>-22,107,118</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7497</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_EarningsPerShareAbstract</td>\n",
              "      <td>주당이익 [abstract]</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7498</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_BasicEarningsLossPerShare</td>\n",
              "      <td>기본주당이익(손실)</td>\n",
              "      <td>-1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7499</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_DilutedEarningsLossPerShare</td>\n",
              "      <td>희석주당이익(손실)</td>\n",
              "      <td>-1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>65659 rows × 8 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-ac4be547-9723-492d-aec6-90090fd8c0e2')\"\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-ac4be547-9723-492d-aec6-90090fd8c0e2 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-ac4be547-9723-492d-aec6-90090fd8c0e2');\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": [
        "df4 = df4.replace(0, np.NaN)\n",
        "df4 = df4.replace('0', np.NaN)\n",
        "df4.dropna(axis=0, inplace=True)\n",
        "df4"
      ],
      "metadata": {
        "id": "yIntSBjHkf7Y",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "outputId": "22a1b5d7-8b41-450a-a01d-16c97ec64750"
      },
      "execution_count": 24,
      "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",
              "7493   950220  2021   반기보고서  네오이뮨텍  701   \n",
              "7495   950220  2021   반기보고서  네오이뮨텍  701   \n",
              "7496   950220  2021   반기보고서  네오이뮨텍  701   \n",
              "7498   950220  2021   반기보고서  네오이뮨텍  701   \n",
              "7499   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",
              "7493   dart_OtherComprehensiveIncomeNetOfTaxGainsLoss...   \n",
              "7495   ifrs-full_GainsLossesOnExchangeDifferencesOnTr...   \n",
              "7496                       ifrs-full_ComprehensiveIncome   \n",
              "7498                 ifrs-full_BasicEarningsLossPerShare   \n",
              "7499               ifrs-full_DilutedEarningsLossPerShare   \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",
              "7493   순확정부채의 재측정손익(세후기타포괄손익)           3,584  \n",
              "7495                 해외사업환산손익        -114,974  \n",
              "7496                    총포괄손익     -22,107,118  \n",
              "7498               기본주당이익(손실)              -1  \n",
              "7499               희석주당이익(손실)              -1  \n",
              "\n",
              "[54840 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-eced5512-2be8-4618-bd87-6d7b1f0e12d9\">\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>7493</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>dart_OtherComprehensiveIncomeNetOfTaxGainsLoss...</td>\n",
              "      <td>순확정부채의 재측정손익(세후기타포괄손익)</td>\n",
              "      <td>3,584</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7495</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_GainsLossesOnExchangeDifferencesOnTr...</td>\n",
              "      <td>해외사업환산손익</td>\n",
              "      <td>-114,974</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7496</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_ComprehensiveIncome</td>\n",
              "      <td>총포괄손익</td>\n",
              "      <td>-22,107,118</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7498</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_BasicEarningsLossPerShare</td>\n",
              "      <td>기본주당이익(손실)</td>\n",
              "      <td>-1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7499</th>\n",
              "      <td>950220</td>\n",
              "      <td>2021</td>\n",
              "      <td>반기보고서</td>\n",
              "      <td>네오이뮨텍</td>\n",
              "      <td>701</td>\n",
              "      <td>ifrs-full_DilutedEarningsLossPerShare</td>\n",
              "      <td>희석주당이익(손실)</td>\n",
              "      <td>-1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>54840 rows × 8 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-eced5512-2be8-4618-bd87-6d7b1f0e12d9')\"\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-eced5512-2be8-4618-bd87-6d7b1f0e12d9 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-eced5512-2be8-4618-bd87-6d7b1f0e12d9');\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": 24
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df4.to_csv('/content/drive/MyDrive/22캡스톤디자인/재무일괄/일괄/매출총이익누락추정.csv')"
      ],
      "metadata": {
        "id": "Eq2x81SCtaw5"
      },
      "execution_count": 25,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "---"
      ],
      "metadata": {
        "id": "eylnOjVntauw"
      }
    },
    {
      "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": [
        ""
      ],
      "metadata": {
        "id": "jGLDhJD2XoW6"
      },
      "execution_count": null,
      "outputs": []
    }
  ],
  "metadata": {
    "colab": {
      "collapsed_sections": [],
      "name": "누락찾기V2.ipynb",
      "provenance": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "display_name": "Python 3",
      "name": "python3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}