collect_report.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [],
   "source": [
    "from selenium import webdriver\n",
    "from selenium.webdriver.common.by import By\n",
    "from selenium.webdriver.support.ui import WebDriverWait\n",
    "from selenium.webdriver.support import expected_conditions as EC\n",
    "from selenium.common.exceptions import NoSuchElementException\n",
    "from bs4 import BeautifulSoup\n",
    "from urllib.request import urlopen\n",
    "import re\n",
    "from collections import OrderedDict\n",
    "import json\n",
    "import pandas as pd\n",
    "from pandas.io.json import json_normalize"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\ProgramData\\Anaconda3\\lib\\site-packages\\selenium\\webdriver\\phantomjs\\webdriver.py:49: UserWarning: Selenium support for PhantomJS has been deprecated, please use headless versions of Chrome or Firefox instead\n",
      "  warnings.warn('Selenium support for PhantomJS has been deprecated, please use headless '\n",
      "C:\\ProgramData\\Anaconda3\\lib\\site-packages\\bs4\\__init__.py:181: UserWarning: No parser was explicitly specified, so I'm using the best available HTML parser for this system (\"lxml\"). This usually isn't a problem, but if you run this code on another system, or in a different virtual environment, it may use a different parser and behave differently.\n",
      "\n",
      "The code that caused this warning is on line 193 of the file C:\\ProgramData\\Anaconda3\\lib\\runpy.py. To get rid of this warning, change code that looks like this:\n",
      "\n",
      " BeautifulSoup(YOUR_MARKUP})\n",
      "\n",
      "to this:\n",
      "\n",
      " BeautifulSoup(YOUR_MARKUP, \"lxml\")\n",
      "\n",
      "  markup_type=markup_type))\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "checkpoint 1 >> [<a class=\"x-tree-node-anchor\" hidefocus=\"on\" href=\"#\" tabindex=\"1\"><span unselectable=\"on\">감   사   보   고   서</span></a>, <a class=\"x-tree-node-anchor\" hidefocus=\"on\" href=\"#\" tabindex=\"1\"><span unselectable=\"on\">외부감사인의 감사보고서</span></a>, <a class=\"x-tree-node-anchor\" hidefocus=\"on\" href=\"#\" tabindex=\"1\"><span unselectable=\"on\">재 무 제 표</span></a>, <a class=\"x-tree-node-anchor\" hidefocus=\"on\" href=\"#\" tabindex=\"1\"><span unselectable=\"on\">재 무 상 태 표</span></a>, <a class=\"x-tree-node-anchor\" hidefocus=\"on\" href=\"#\" tabindex=\"1\"><span unselectable=\"on\">손 익 계 산 서</span></a>, <a class=\"x-tree-node-anchor\" hidefocus=\"on\" href=\"#\" tabindex=\"1\"><span unselectable=\"on\">자 본 변 동 표</span></a>, <a class=\"x-tree-node-anchor\" hidefocus=\"on\" href=\"#\" tabindex=\"1\"><span unselectable=\"on\">현 금 흐 름 표</span></a>, <a class=\"x-tree-node-anchor\" hidefocus=\"on\" href=\"#\" tabindex=\"1\"><span unselectable=\"on\">재무제표에 대한 주석</span></a>]\n",
      "checkpoint 2 >> 3번째 <a href=\"#\">: 재무상태표\n",
      "checkpoint 2 >> 4번째 <a href=\"#\">: 손익계산서\n",
      "checkpoint 2 >> 6번째 <a href=\"#\">: 현금흐름표\n"
     ]
    }
   ],
   "source": [
    "# 레포트 html문서로 부터, 필요한 세부 레포트 url을 저장할 딕셔너리 생성\n",
    "report_dict = {'재무상태표': None, '대차대조표': None, '손익계산서': None, '현금흐름표': None}\n",
    "# 보고서 접수번호\n",
    "rcpNo = '20120404001355'\n",
    "# 보고서 url\n",
    "report_url = 'http://dart.fss.or.kr/dsaf001/main.do?rcpNo=' + rcpNo\n",
    "'''\n",
    "# geckodriver(파이어폭스 버전) 설치경로를 할당하여, 웹드라이버 실행\n",
    "executable_path = \"C:\\itStudy\\Web\\geckodriver-v0.21.0-win64\\geckodriver.exe\"\n",
    "driver = webdriver.Firefox(executable_path = executable_path)\n",
    "'''\n",
    "# PhantomJS 설치경로를 할당하여, 웹 드라이버 실행\n",
    "executable_path = \"C:\\itStudy\\Web\\phantomjs-2.1.1-windows\\\\bin\\phantomjs.exe\"\n",
    "driver = webdriver.PhantomJS(executable_path)\n",
    "\n",
    "# 웹 드라이버를 통해, 보고서 url로 html 요청\n",
    "driver.get(report_url)\n",
    "try:\n",
    "    # 서버 응답 대기(타임아웃 10초)\n",
    "    element = WebDriverWait(driver, 10).until(\n",
    "        EC.presence_of_element_located( (By.ID, 'ifrm') )\n",
    "    )\n",
    "    # 웹 드라이버의 현재 페이지 html 문서로 BeatifulSoup 객체 생성\n",
    "    main_bsObj = BeautifulSoup(driver.page_source)\n",
    "    # 첫 페이지에서 필요한 보고서로 이동하는 <a href=\"#\"> 태그 리스트 저장\n",
    "    # *주의: geckodriver(파이어폭스 버전)을 사용하는 경우, <a> 태그 의 href 속성값을 \"\"로 설정\n",
    "    anchorList = main_bsObj.find_all( 'a', {'href': '#'} )\n",
    "    # checkpoint 1\n",
    "    print( 'checkpoint 1 >>', anchorList )\n",
    "    # 필요한 <a> 태그 index, text 저장 리스트(타겟 리스트) 생성\n",
    "    targetAList = []\n",
    "    # 목적에 적합한 <a> 태그 탐색\n",
    "    for anchor in anchorList:\n",
    "        # a 태그의 text를 공백 제거 후 저장\n",
    "        anchorText = anchor.get_text().replace(' ', '')\n",
    "        # a 태그의 text가 재무제표 유형 리스트에 포함되면 해당 <a> 태그의 index 저장\n",
    "        if anchorText in report_dict.keys():\n",
    "            # checkpoint 2\n",
    "            print( 'checkpoint 2 >> %d번째 <a href=\"#\">: %s' % (anchorList.index(anchor), anchorText) )\n",
    "            # 적합한 <a> 태그 메타 데이터(보고서 유형)를 타겟 리스트에 저장\n",
    "            targetAList.append([anchorList.index(anchor), anchorText])\n",
    "    # 타겟 리스트를 순회하여, 각 보고서 url 저장\n",
    "    for index, reportName in targetAList:\n",
    "        # 보고서에서 각 항목 데이터에 접근하는 <a> 태그에서 필요한 항목이 저장된  index만 접근 \n",
    "        driver.find_elements_by_xpath('//a[@href=\"#\"]')[index].click()\n",
    "        # 로딩 대기(2초)\n",
    "        driver.implicitly_wait(2)\n",
    "        # 각 보고서 화면으로 부터 재무 데이터 url을 포함한 <iframe> 태그에서 scr 속성값 획득\n",
    "        target_url = BeautifulSoup(driver.page_source).find('iframe')['src']\n",
    "        # 속성값에서 불필요한 부분 문자열 제거\n",
    "        report_dict[reportName] = target_url.replace('amp;', '')\n",
    "finally:\n",
    "    # 웹 드라이버 종료\n",
    "    driver.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 세부 제무 보고서 BeautifulSoup 객체를 저장하는 변수 선언\n",
    "finance_position_bsObj = None  # 재무상태표(구 대차대조표)\n",
    "income_statement_bsObj = None  # 손익계산서\n",
    "cash_flow_bsObj = None  # 현금흐름표\n",
    "# 각 세부 보고서 url에서 재무 데이터 추출\n",
    "for reportName, reportURL in report_dict.items():\n",
    "    # 세부 보고서 url을 수집하지 못했다면 데이터 추출 skip\n",
    "    if reportURL == None:\n",
    "        continue\n",
    "    # checkpoint 3\n",
    "    #print('checkpoint 3 >>', reportName, reportURL)\n",
    "    # DART domain url\n",
    "    domain = 'https://dart.fss.or.kr/'\n",
    "    # 재무상태표(대차대조표)에서 재무 데이터 추출\n",
    "    if reportName in ('재무상태표', '대차대조표'):\n",
    "        reportHTML = urlopen(domain + reportURL)\n",
    "        finance_position_bsObj = BeautifulSoup(reportHTML, 'html.parser')\n",
    "    elif reportName == '손익계산서':\n",
    "        reportHTML = urlopen(domain + reportURL)\n",
    "        income_statement_bsObj = BeautifulSoup(reportHTML, 'html.parser')\n",
    "    elif reportName == '현금흐름표':\n",
    "        reportHTML = urlopen(domain + reportURL)\n",
    "        cash_flow_bsObj = BeautifulSoup(reportHTML, 'html.parser')\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "테스트 url 목록\n",
    "재무상태표: https://dart.fss.or.kr/report/viewer.do?rcpNo=20120404001355&dcmNo=3350848&eleId=4&offset=8479&length=35728&dtd=dart3.xsd\n",
    "손익계산서: https://dart.fss.or.kr/report/viewer.do?rcpNo=20120404001355&dcmNo=3350848&eleId=5&offset=44207&length=25851&dtd=dart3.xsd\n",
    "현금흐름표: https://dart.fss.or.kr/report/viewer.do?rcpNo=20120404001355&dcmNo=3350848&eleId=7&offset=77198&length=35071&dtd=dart3.xsd\n",
    "\n",
    "수집 대상 컬럼 명\n",
    "매출채권 : ifrs_TradeAndOtherCurrentReceivables\n",
    "재고자산 : ifrs_Inventories\n",
    "단기차입금 : dart_ShortTermBorrowings\n",
    "장기차입금 : dart_LongTermBorrowingsGross\n",
    "자산총계 : ifrs_Assets\n",
    "부채총계 : ifrs_Liabilities\n",
    "자본총계 : ifrs_Equity\n",
    "매출액 : ifrs_Revenue\n",
    "영업이익 : dart_OperatingIncomeLoss\n",
    "당기순이익 : ifrs_ProfitLoss\n",
    "매출원가 : ifrs_CostOfSales\n",
    "금융비용(손익) : ifrs_FinanceCosts\n",
    "영업활동현금흐름 : ifrs_CashFlowsFromUsedInOperatingActivities\n",
    "투자활동현금흐름 : ifrs_CashFlowsFromUsedInInvestingActivities\n",
    "재무활동현금흐름 : ifrs_CashFlowsFromUsedInFinancingActivities"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "checkpoint 4-2 >> {\n",
      "\t\"\\uc790\\uc0b0\": \"\",\n",
      "\t\"\\uc720\\ub3d9\\uc790\\uc0b0\": \"8738672749\",\n",
      "\t\"\\ub2f9\\uc88c\\uc790\\uc0b0\": \"8378942749\",\n",
      "\t\"\\ud604\\uae08\\ubc0f\\ud604\\uae08\\uc131\\uc790\\uc0b0\": \"26566431\",\n",
      "\t\"\\ub2e8\\uae30\\uae08\\uc735\\uc0c1\\ud488\": \"-\",\n",
      "\t\"\\ub2e8\\uae30\\ud22c\\uc790\\uc790\\uc0b0\": \"5278873\",\n",
      "\t\"\\ub9e4\\ucd9c\\ucc44\\uad8c\": \"7990595613\",\n",
      "\t\"\\ub300\\uc190\\ucda9\\ub2f9\\uae08\": \"(100320)\",\n",
      "\t\"\\ubbf8\\uc218\\uae08\": \"16489845\",\n",
      "\t\"\\ubbf8\\uc218\\uc218\\uc775\": \"18347709\",\n",
      "\t\"\\uc120\\uae09\\ube44\\uc6a9\": \"29371253\",\n",
      "\t\"\\uc120\\uae09\\uae08\": \"298945900\",\n",
      "\t\"\\uc885\\uc5c5\\uc6d0\\ub2e8\\uae30\\ub300\\uc5ec\\uae08\": \"20000000\",\n",
      "\t\"\\uc7ac\\uace0\\uc790\\uc0b0\": \"359730000\",\n",
      "\t\"\\uc120\\uae09\\uacf5\\uc0ac\\uc6d0\\uac00\": \"-\",\n",
      "\t\"\\uc6d0\\uc7ac\\ub8cc\": \"359730000\",\n",
      "\t\"\\ube44\\uc720\\ub3d9\\uc790\\uc0b0\": \"6718441332\",\n",
      "\t\"\\ud22c\\uc790\\uc790\\uc0b0\": \"1375399161\",\n",
      "\t\"\\uc7a5\\uae30\\uae08\\uc735\\uc0c1\\ud488\": \"728650481\",\n",
      "\t\"\\uc7a5\\uae30\\ud22c\\uc790\\uc99d\\uad8c\": \"646748680\",\n",
      "\t\"\\uc720\\ud615\\uc790\\uc0b0\": \"5134174374\",\n",
      "\t\"\\ud1a0\\uc9c0\": \"4165600000\",\n",
      "\t\"\\uac74\\ubb3c\": \"1103424410\",\n",
      "\t\"\\uac10\\uac00\\uc0c1\\uac01\\ub204\\uacc4\\uc561\": \"(4613000)\",\n",
      "\t\"\\ucc28\\ub7c9\\uc6b4\\ubc18\\uad6c\": \"62173694\",\n",
      "\t\"\\ube44\\ud488\": \"154615189\",\n",
      "\t\"\\uacf5\\uad6c\\uc640\\uae30\\uad6c\": \"4615000\",\n",
      "\t\"\\ubb34\\ud615\\uc790\\uc0b0\": \"9451607\",\n",
      "\t\"\\uc18c\\ud504\\ud2b8\\uc6e8\\uc5b4\": \"9451607\",\n",
      "\t\"\\uae30\\ud0c0\\ube44\\uc720\\ub3d9\\uc790\\uc0b0\": \"199416190\",\n",
      "\t\"\\ubcf4\\uc99d\\uae08\": \"62850000\",\n",
      "\t\"\\uc2dc\\uc124\\uc774\\uc6a9\\uad8c\": \"136566190\",\n",
      "\t\"\\uc790\\uc0b0\\ucd1d\\uacc4\": \"15457114081\",\n",
      "\t\"\\ubd80\\ucc44\": \"\",\n",
      "\t\"\\uc720\\ub3d9\\ubd80\\ucc44\": \"9092665284\",\n",
      "\t\"\\ub2e8\\uae30\\ucc28\\uc785\\uae08\": \"5537724209\",\n",
      "\t\"\\uc720\\ub3d9\\uc131\\uc7a5\\uae30\\ubd80\\ucc44\": \"107480000\",\n",
      "\t\"\\ub9e4\\uc785\\ucc44\\ubb34\": \"2404029259\",\n",
      "\t\"\\ubbf8\\uc9c0\\uae09\\uae08\": \"751246817\",\n",
      "\t\"\\uc608\\uc218\\uae08\": \"14685528\",\n",
      "\t\"\\ubd80\\uac00\\uc138\\uc608\\uc218\\uae08\": \"154716433\",\n",
      "\t\"\\ubbf8\\uc9c0\\uae09\\ube44\\uc6a9\": \"12838981\",\n",
      "\t\"\\ubbf8\\uc9c0\\uae09\\ubc95\\uc778\\uc138\": \"76380563\",\n",
      "\t\"\\uacf5\\uc0ac\\uc120\\uc218\\uae08\": \"29522820\",\n",
      "\t\"\\ub2e8\\uae30\\uc774\\uc5f0\\ubc95\\uc778\\uc138\\ubd80\\ucc44\": \"4040674\",\n",
      "\t\"\\ube44\\uc720\\ub3d9\\ubd80\\ucc44\": \"977748285\",\n",
      "\t\"\\uc7a5\\uae30\\ucc28\\uc785\\uae08\": \"268780000\",\n",
      "\t\"\\ud1f4\\uc9c1\\uae09\\uc5ec\\ucda9\\ub2f9\\ubd80\\ucc44\": \"279024714\",\n",
      "\t\"\\ud1f4\\uc9c1\\uc5f0\\uae08\\uc6b4\\uc6a9\\uc790\\uc0b0\": \"(101125147)\",\n",
      "\t\"\\uc784\\ub300\\ubcf4\\uc99d\\uae08\": \"142000000\",\n",
      "\t\"\\uc7a5\\uae30\\uc774\\uc5f0\\ubc95\\uc778\\uc138\\ubd80\\ucc44\": \"389068718\",\n",
      "\t\"\\ubd80\\ucc44\\ucd1d\\uacc4\": \"10070413569\",\n",
      "\t\"\\uc790\\ubcf8\": \"\",\n",
      "\t\"\\uc790\\ubcf8\\uae08\": \"1000000000\",\n",
      "\t\"\\ubcf4\\ud1b5\\uc8fc\\uc790\\ubcf8\\uae08\": \"1000000000\",\n",
      "\t\"\\uc790\\ubcf8\\uc789\\uc5ec\\uae08\": \"-\",\n",
      "\t\"\\uae30\\ud0c0\\ud3ec\\uad04\\uc190\\uc775\\ub204\\uacc4\\uc561\": \"1482017485\",\n",
      "\t\"\\uc790\\uc0b0\\uc7ac\\ud3c9\\uac00\\ucc28\\uc775\": \"1481998492\",\n",
      "\t\"\\ub2e8\\uae30\\ud22c\\uc790\\uc790\\uc0b0\\ud3c9\\uac00\\uc774\\uc775\": \"18993\",\n",
      "\t\"\\uc774\\uc775\\uc789\\uc5ec\\uae08\": \"2904683027\",\n",
      "\t\"\\ubc95\\uc815\\uc801\\ub9bd\\uae08\": \"45000000\",\n",
      "\t\"\\ubbf8\\ucc98\\ubd84\\uc774\\uc775\\uc789\\uc5ec\\uae08\": \"2859683027\",\n",
      "\t\"\\uc790\\ubcf8\\ucd1d\\uacc4\": \"5386700512\",\n",
      "\t\"\\ubd80\\ucc44\\uc640\\uc790\\ubcf8\\ucd1d\\uacc4\": \"15457114081\"\n",
      "} {'자산': '', '유동자산': '8738672749', '당좌자산': '8378942749', '현금및현금성자산': '26566431', '단기금융상품': '-', '단기투자자산': '5278873', '매출채권': '7990595613', '대손충당금': '(100320)', '미수금': '16489845', '미수수익': '18347709', '선급비용': '29371253', '선급금': '298945900', '종업원단기대여금': '20000000', '재고자산': '359730000', '선급공사원가': '-', '원재료': '359730000', '비유동자산': '6718441332', '투자자산': '1375399161', '장기금융상품': '728650481', '장기투자증권': '646748680', '유형자산': '5134174374', '토지': '4165600000', '건물': '1103424410', '감가상각누계액': '(4613000)', '차량운반구': '62173694', '비품': '154615189', '공구와기구': '4615000', '무형자산': '9451607', '소프트웨어': '9451607', '기타비유동자산': '199416190', '보증금': '62850000', '시설이용권': '136566190', '자산총계': '15457114081', '부채': '', '유동부채': '9092665284', '단기차입금': '5537724209', '유동성장기부채': '107480000', '매입채무': '2404029259', '미지급금': '751246817', '예수금': '14685528', '부가세예수금': '154716433', '미지급비용': '12838981', '미지급법인세': '76380563', '공사선수금': '29522820', '단기이연법인세부채': '4040674', '비유동부채': '977748285', '장기차입금': '268780000', '퇴직급여충당부채': '279024714', '퇴직연금운용자산': '(101125147)', '임대보증금': '142000000', '장기이연법인세부채': '389068718', '부채총계': '10070413569', '자본': '', '자본금': '1000000000', '보통주자본금': '1000000000', '자본잉여금': '-', '기타포괄손익누계액': '1482017485', '자산재평가차익': '1481998492', '단기투자자산평가이익': '18993', '이익잉여금': '2904683027', '법정적립금': '45000000', '미처분이익잉여금': '2859683027', '자본총계': '5386700512', '부채와자본총계': '15457114081'}\n"
     ]
    }
   ],
   "source": [
    "# 재무상태표(대차대조표) 재무 데이터를 저장하는 JSON(파이썬 딕셔너리) 변수 생성\n",
    "finance_position_json = OrderedDict()\n",
    "# checkpoint 4\n",
    "#print('checkpoint 4 >>', finance_position_bsObj)\n",
    "# 재무상태표(대차대조표)에서 재무 데이터가 포함된 <tr> 태그 리스트 추출\n",
    "finance_position_trObjList = finance_position_bsObj.find_all('tbody')[1].find_all('tr')\n",
    "# 컬럼 명을 확인해서, 수집 대상이면 수집 리스트에 저장\n",
    "for trObj in finance_position_trObjList:\n",
    "    # 컬럼 명 수집 및 전처리\n",
    "    column = trObj.find('td').get_text()\n",
    "    column = re.sub('[' + chr(32) + chr(160) + ']', '', column)  # 유령문자 제거\n",
    "    column = re.sub('[\\t\\n\\r\\f\\v-=.,#/?:$\\{\\}a-zA-Z0-9Ⅰ-Ↄ]', '', column)\n",
    "    column = re.sub('주석', '', column)\n",
    "    # 컬럼 값 수집 및 전처리\n",
    "    value = \"\"\n",
    "    for td in trObj.find_all('td')[1:]:\n",
    "        td_text = td.get_text()\n",
    "        td_text = re.sub('[' + chr(32) + chr(160) + ']', '', td_text)  # 유령문자 제거\n",
    "        td_text = re.sub('[\\t\\n\\r\\f\\v,]', '', td_text)  # 공백 및 쉼표(,) 제거\n",
    "        if td_text != \"\":\n",
    "            value = td_text\n",
    "            break\n",
    "    # checkpoint 4-1\n",
    "    #print('checkpoint 4-1 >>', column, '|', value)\n",
    "    # 재무상태표(대차대조표) JSON에 데이터 저장\n",
    "    finance_position_json[column] = value\n",
    "# checkpoint 4-2\n",
    "jsonString_4_2 = json.dumps(finance_position_json, indent='\\t')  # JSON 문자열 생성\n",
    "print('checkpoint 4-2 >>', jsonString_4_2, json.loads(jsonString_4_2))  # JSON 문자열로 생성산 JSON 객체 출력"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "checkpoint 5-2 >> {\n",
      "\t\"\\ub9e4\\ucd9c\\uc561\": \"32849969869\",\n",
      "\t\"\\uacf5\\uc0ac\\uc218\\uc775\": \"32732729595\",\n",
      "\t\"\\uc784\\ub300\\uc218\\uc775\": \"117240274\",\n",
      "\t\"\\ub9e4\\ucd9c\\uc6d0\\uac00\": \"30839010989\",\n",
      "\t\"\\uacf5\\uc0ac\\uc6d0\\uac00\": \"30839010989\",\n",
      "\t\"\\ub9e4\\ucd9c\\ucd1d\\uc774\\uc775\": \"2010958880\",\n",
      "\t\"\\ud310\\ub9e4\\ube44\\uc640\\uad00\\ub9ac\\ube44\": \"1028455053\",\n",
      "\t\"\\uae09\\uc5ec\": \"563614950\",\n",
      "\t\"\\ud1f4\\uc9c1\\uae09\\uc5ec\": \"44520602\",\n",
      "\t\"\\ubcf5\\ub9ac\\ud6c4\\uc0dd\\ube44\": \"88082710\",\n",
      "\t\"\\uc5ec\\ube44\\uad50\\ud1b5\\ube44\": \"5071450\",\n",
      "\t\"\\uc811\\ub300\\ube44\": \"25624460\",\n",
      "\t\"\\ud1b5\\uc2e0\\ube44\": \"8956164\",\n",
      "\t\"\\uc138\\uae08\\uacfc\\uacf5\\uacfc\": \"43623077\",\n",
      "\t\"\\uac10\\uac00\\uc0c1\\uac01\\ube44\": \"36534690\",\n",
      "\t\"\\uc218\\ub3c4\\uad11\\uc5f4\\ube44\": \"4049427\",\n",
      "\t\"\\uc804\\ub825\\ube44\": \"2319073\",\n",
      "\t\"\\uc218\\uc120\\ube44\": \"820000\",\n",
      "\t\"\\ubcf4\\ud5d8\\ub8cc\": \"19801308\",\n",
      "\t\"\\ucc28\\ub7c9\\uc720\\uc9c0\\ube44\": \"38801669\",\n",
      "\t\"\\uc6b4\\ubc18\\ube44\": \"706949\",\n",
      "\t\"\\uad50\\uc721\\ud6c8\\ub828\\ube44\": \"-\",\n",
      "\t\"\\ub3c4\\uc11c\\uc778\\uc1c4\\ube44\": \"764500\",\n",
      "\t\"\\uc0ac\\ubb34\\uc6a9\\ud488\\ube44\": \"5862317\",\n",
      "\t\"\\uc18c\\ubaa8\\ud488\\ube44\": \"7374661\",\n",
      "\t\"\\uc9c0\\uae09\\uc218\\uc218\\ub8cc\": \"87765861\",\n",
      "\t\"\\ub9ac\\uc2a4\\ub8cc\": \"42912792\",\n",
      "\t\"\\ubb34\\ud615\\uc790\\uc0b0\\uc0c1\\uac01\\ube44\": \"1248393\",\n",
      "\t\"\\uc7a1\\ube44\": \"-\",\n",
      "\t\"\\uc601\\uc5c5\\uc774\\uc775\": \"982503827\",\n",
      "\t\"\\uc601\\uc5c5\\uc678\\uc218\\uc775\": \"32879673\",\n",
      "\t\"\\uc774\\uc790\\uc218\\uc775\": \"7043426\",\n",
      "\t\"\\ub2e8\\uae30\\ud22c\\uc790\\uc790\\uc0b0\\ucc98\\ubd84\\uc774\\uc775\": \"-\",\n",
      "\t\"\\ub300\\uc190\\ucda9\\ub2f9\\uae08\\ud658\\uc785\": \"10364190\",\n",
      "\t\"\\uc720\\ud615\\uc790\\uc0b0\\ucc98\\ubd84\\uc774\\uc775\": \"6104427\",\n",
      "\t\"\\uc7a1\\uc774\\uc775\": \"9367630\",\n",
      "\t\"\\uc601\\uc5c5\\uc678\\ube44\\uc6a9\": \"452611094\",\n",
      "\t\"\\uc774\\uc790\\ube44\\uc6a9\": \"343033803\",\n",
      "\t\"\\ub9e4\\ucd9c\\ucc44\\uad8c\\ucc98\\ubd84\\uc190\\uc2e4\": \"84794334\",\n",
      "\t\"\\ub2e8\\uae30\\ud22c\\uc790\\uc790\\uc0b0\\ucc98\\ubd84\\uc190\\uc2e4\": \"-\",\n",
      "\t\"\\uae30\\ubd80\\uae08\": \"100000\",\n",
      "\t\"\\uae30\\ud0c0\\ube44\\uc720\\ub3d9\\uc790\\uc0b0\\ucc98\\ubd84\\uc190\\uc2e4\": \"22660000\",\n",
      "\t\"\\uc7a1\\uc190\\uc2e4\": \"2022957\",\n",
      "\t\"\\ubc95\\uc778\\uc138\\ube44\\uc6a9\\ucc28\\uac10\\uc804\\uc21c\\uc774\\uc775\": \"562772406\",\n",
      "\t\"\\ubc95\\uc778\\uc138\\ube44\\uc6a9\": \"93998530\",\n",
      "\t\"\\ub2f9\\uae30\\uc21c\\uc774\\uc775\": \"468773876\",\n",
      "\t\"\\uc8fc\\ub2f9\\uc190\\uc775\": \"\",\n",
      "\t\"\\uae30\\ubcf8\\uc8fc\\ub2f9\\uc21c\\uc774\\uc775\": \"4688\"\n",
      "} {'매출액': '32849969869', '공사수익': '32732729595', '임대수익': '117240274', '매출원가': '30839010989', '공사원가': '30839010989', '매출총이익': '2010958880', '판매비와관리비': '1028455053', '급여': '563614950', '퇴직급여': '44520602', '복리후생비': '88082710', '여비교통비': '5071450', '접대비': '25624460', '통신비': '8956164', '세금과공과': '43623077', '감가상각비': '36534690', '수도광열비': '4049427', '전력비': '2319073', '수선비': '820000', '보험료': '19801308', '차량유지비': '38801669', '운반비': '706949', '교육훈련비': '-', '도서인쇄비': '764500', '사무용품비': '5862317', '소모품비': '7374661', '지급수수료': '87765861', '리스료': '42912792', '무형자산상각비': '1248393', '잡비': '-', '영업이익': '982503827', '영업외수익': '32879673', '이자수익': '7043426', '단기투자자산처분이익': '-', '대손충당금환입': '10364190', '유형자산처분이익': '6104427', '잡이익': '9367630', '영업외비용': '452611094', '이자비용': '343033803', '매출채권처분손실': '84794334', '단기투자자산처분손실': '-', '기부금': '100000', '기타비유동자산처분손실': '22660000', '잡손실': '2022957', '법인세비용차감전순이익': '562772406', '법인세비용': '93998530', '당기순이익': '468773876', '주당손익': '', '기본주당순이익': '4688'}\n"
     ]
    }
   ],
   "source": [
    "# 손익계산서 재무 데이터를 저장하는 JSON(파이썬 딕셔너리) 변수 생성\n",
    "income_statement_json = OrderedDict()\n",
    "# checkpoint 5\n",
    "#print('checkpoint 5 >>', income_statement_bsObj)\n",
    "# 손익계산서에서 재무 데이터가 포함된 <tr> 태그 리스트 추출\n",
    "income_statement_trObjList = income_statement_bsObj.find_all('tbody')[1].find_all('tr')\n",
    "# 컬럼 명을 확인해서, 수집 대상이면 수집 리스트에 저장\n",
    "for trObj in income_statement_trObjList:\n",
    "    # 컬럼 명 수집 및 전처리\n",
    "    column = trObj.find('td').get_text()\n",
    "    column = re.sub(chr(160), '', column)  # 유령문자 제거\n",
    "    column = re.sub('[\\t\\n\\r\\f\\v-=.,#/?:$\\{\\}a-zA-Z0-9Ⅰ-Ↄ]', '', column)\n",
    "    column = re.sub('주석', '', column)\n",
    "    # 컬럼 값 수집 및 전처리\n",
    "    value = \"\"\n",
    "    for td in trObj.find_all('td')[1:]:\n",
    "        td_text = td.get_text()\n",
    "        td_text = re.sub('[' + chr(32) + chr(160) + ']', '', td_text)  # 유령문자 제거\n",
    "        td_text = re.sub('[\\t\\n\\r\\f\\v,]', '', td_text)  # 공백 및 쉼표(,) 제거\n",
    "        if td_text != \"\":\n",
    "            value = td_text\n",
    "            break\n",
    "    # checkpoint 5-1\n",
    "    #print('checkpoint 5-1 >>', column, '|', value)\n",
    "    income_statement_json[column] = value\n",
    "# checkpoint 5-2\n",
    "jsonString_5_2 = json.dumps(income_statement_json, indent='\\t')  # JSON 문자열 생성\n",
    "print('checkpoint 5-2 >>', jsonString_5_2, json.loads(jsonString_5_2))  # JSON 문자열로 생성산 JSON 객체 출력"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "checkpoint 6-2 >> {\n",
      "\t\"\\uc601\\uc5c5\\ud65c\\ub3d9\\uc73c\\ub85c\\uc778\\ud55c\\ud604\\uae08\\ud750\\ub984\": \"(767640486)\",\n",
      "\t\"\\ub2f9\\uae30\\uc21c\\uc774\\uc775\": \"468773876\",\n",
      "\t\"\\ud604\\uae08\\uc758\\uc720\\ucd9c\\uc774\\uc5c6\\ub294\\ube44\\uc6a9\\ub4f1\\uc758\\uac00\\uc0b0\": \"156600984\",\n",
      "\t\"\\ud1f4\\uc9c1\\uae09\\uc5ec\": \"94046393\",\n",
      "\t\"\\uac10\\uac00\\uc0c1\\uac01\\ube44\": \"38646198\",\n",
      "\t\"\\ub2e8\\uae30\\ud22c\\uc790\\uc790\\uc0b0\\ucc98\\ubd84\\uc190\\uc2e4\": \"-\",\n",
      "\t\"\\ubb34\\ud615\\uc790\\uc0b0\\uc0c1\\uac01\\ube44\": \"1248393\",\n",
      "\t\"\\uae30\\ud0c0\\uc758\\ube44\\uc720\\ub3d9\\uc790\\uc0b0\\ucc98\\ubd84\\uc190\\uc2e4\": \"22660000\",\n",
      "\t\"\\ud604\\uae08\\uc758\\uc720\\uc785\\uc774\\uc5c6\\ub294\\uc218\\uc775\\ub4f1\\uc758\\ucc28\\uac10\": \"(16468617)\",\n",
      "\t\"\\ub2e8\\uae30\\ud22c\\uc790\\uc790\\uc0b0\\ucc98\\ubd84\\uc774\\uc775\": \"-\",\n",
      "\t\"\\uc720\\ud615\\uc790\\uc0b0\\ucc98\\ubd84\\uc774\\uc775\": \"6104427\",\n",
      "\t\"\\ub300\\uc190\\ucda9\\ub2f9\\uae08\\ud658\\uc785\": \"10364190\",\n",
      "\t\"\\uc601\\uc5c5\\ud65c\\ub3d9\\uc73c\\ub85c\\uc778\\ud55c\\uc790\\uc0b0\\ubd80\\ucc44\\uc758\\ubcc0\\ub3d9\": \"(1376546729)\",\n",
      "\t\"\\ub9e4\\ucd9c\\ucc44\\uad8c\\uc758\\uac10\\uc18c\\uc99d\\uac00\": \"(1018887732)\",\n",
      "\t\"\\ubbf8\\uc218\\uae08\\uc758\\uac10\\uc18c\\uc99d\\uac00\": \"(2549735)\",\n",
      "\t\"\\ubbf8\\uc218\\uc218\\uc775\\uc758\\uac10\\uc18c\\uc99d\\uac00\": \"(559053)\",\n",
      "\t\"\\uc120\\uae09\\uae08\\uc758\\uac10\\uc18c\\uc99d\\uac00\": \"(298945900)\",\n",
      "\t\"\\uc120\\uae09\\ube44\\uc6a9\\uc758\\uac10\\uc18c\\uc99d\\uac00\": \"550024295\",\n",
      "\t\"\\ubbf8\\uc218\\ubc95\\uc778\\uc138\\ud658\\uae09\\uc561\\uc758\\uac10\\uc18c\\uc99d\\uac00\": \"-\",\n",
      "\t\"\\uc7ac\\uace0\\uc790\\uc0b0\\uc758\\uac10\\uc18c\\uc99d\\uac00\": \"181883518\",\n",
      "\t\"\\uc774\\uc5f0\\ubc95\\uc778\\uc138\\uc790\\uc0b0\\uc758\\uac10\\uc18c\\uc99d\\uac00\": \"-\",\n",
      "\t\"\\ud1f4\\uc9c1\\uc5f0\\uae08\\uc6b4\\uc6a9\\uc790\\uc0b0\\uc758\\uac10\\uc18c\\uc99d\\uac00\": \"(32405655)\",\n",
      "\t\"\\ub9e4\\uc785\\ucc44\\ubb34\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"(1171827501)\",\n",
      "\t\"\\ubbf8\\uc9c0\\uae09\\uae08\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"531868047\",\n",
      "\t\"\\uc608\\uc218\\uae08\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"(2531456)\",\n",
      "\t\"\\ubd80\\uac00\\uc138\\uc608\\uc218\\uae08\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"(77661796)\",\n",
      "\t\"\\uacf5\\uc0ac\\uc120\\uc218\\uae08\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"29522820\",\n",
      "\t\"\\ubbf8\\uc9c0\\uae09\\ube44\\uc6a9\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"(10817016)\",\n",
      "\t\"\\ubbf8\\uc9c0\\uae09\\ubc95\\uc778\\uc138\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"65698716\",\n",
      "\t\"\\uacf5\\uc0ac\\uc190\\uc2e4\\ucda9\\ub2f9\\ubd80\\ucc44\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"-\",\n",
      "\t\"\\ub2e8\\uae30\\uc774\\uc5f0\\ubc95\\uc778\\uc138\\ubd80\\ucc44\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"(264181)\",\n",
      "\t\"\\uc7a5\\uae30\\uc774\\uc5f0\\ubc95\\uc778\\uc138\\ubd80\\ucc44\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"12827638\",\n",
      "\t\"\\ud1f4\\uc9c1\\uae08\\uc758\\uc9c0\\uae09\": \"(131921738)\",\n",
      "\t\"\\ud22c\\uc790\\ud65c\\ub3d9\\uc73c\\ub85c\\uc778\\ud55c\\ud604\\uae08\\ud750\\ub984\": \"(294522024)\",\n",
      "\t\"\\ud22c\\uc790\\ud65c\\ub3d9\\uc73c\\ub85c\\uc778\\ud55c\\ud604\\uae08\\uc720\\uc785\\uc561\": \"219209233\",\n",
      "\t\"\\ub2e8\\uae30\\uae08\\uc735\\uc0c1\\ud488\\uc758\\uac10\\uc18c\": \"103091770\",\n",
      "\t\"\\ub2e8\\uae30\\ud22c\\uc790\\uc790\\uc0b0\\uc758\\uac10\\uc18c\": \"-\",\n",
      "\t\"\\uc7a5\\uae30\\uae08\\uc735\\uc0c1\\ud488\\uc758\\uac10\\uc18c\": \"8990190\",\n",
      "\t\"\\ucc28\\ub7c9\\uc6b4\\ubc18\\uad6c\\uc758\\ucc98\\ubd84\": \"5272728\",\n",
      "\t\"\\ube44\\ud488\\uc758\\ucc98\\ubd84\": \"1200000\",\n",
      "\t\"\\uc2dc\\uc124\\uc774\\uc6a9\\uad8c\\uc758\\ucc98\\ubd84\": \"75454545\",\n",
      "\t\"\\uc784\\ub300\\ubcf4\\uc99d\\uae08\\uc758\\uc99d\\uac00\": \"14000000\",\n",
      "\t\"\\ubcf4\\uc99d\\uae08\\uc758\\uac10\\uc18c\": \"11200000\",\n",
      "\t\"\\ud22c\\uc790\\ud65c\\ub3d9\\uc73c\\ub85c\\uc778\\ud55c\\ud604\\uae08\\uc720\\ucd9c\\uc561\": \"(513731257)\",\n",
      "\t\"\\ub2e8\\uae30\\uae08\\uc735\\uc0c1\\ud488\\uc758\\ucde8\\ub4dd\": \"-\",\n",
      "\t\"\\ub2e8\\uae30\\ud22c\\uc790\\uc790\\uc0b0\\uc758\\uc99d\\uac00\": \"-\",\n",
      "\t\"\\uc7a5\\uae30\\uae08\\uc735\\uc0c1\\ud488\\uc758\\ucde8\\ub4dd\": \"291474108\",\n",
      "\t\"\\ucc28\\ub7c9\\uc6b4\\ubc18\\uad6c\\uc758\\ucde8\\ub4dd\": \"14836414\",\n",
      "\t\"\\ube44\\ud488\\uc758\\ucde8\\ub4dd\": \"2454545\",\n",
      "\t\"\\uc18c\\ud504\\ud2b8\\uc6e8\\uc5b4\\uc758\\ucde8\\ub4dd\": \"10700000\",\n",
      "\t\"\\uc885\\uc5c5\\uc6d0\\ub2e8\\uae30\\ub300\\uc5ec\\uae08\\uc758\\ub300\\uc5ec\": \"20000000\",\n",
      "\t\"\\uc784\\ub300\\ubcf4\\uc99d\\uae08\\uc758\\uac10\\uc18c\": \"10000000\",\n",
      "\t\"\\ubcf4\\uc99d\\uae08\\uc758\\uc99d\\uac00\": \"27700000\",\n",
      "\t\"\\uae30\\ud0c0\\uc758\\uc720\\ud615\\uc790\\uc0b0\\uc758\\ucde8\\ub4dd\": \"-\",\n",
      "\t\"\\uc2dc\\uc124\\uc774\\uc6a9\\uad8c\\uc758\\ucde8\\ub4dd\": \"136566190\",\n",
      "\t\"\\uc7ac\\ubb34\\ud65c\\ub3d9\\uc73c\\ub85c\\uc778\\ud55c\\ud604\\uae08\\ud750\\ub984\": \"642755715\",\n",
      "\t\"\\uc7ac\\ubb34\\ud65c\\ub3d9\\uc73c\\ub85c\\uc778\\ud55c\\ud604\\uae08\\uc720\\uc785\\uc561\": \"6296275364\",\n",
      "\t\"\\ub2e8\\uae30\\ucc28\\uc785\\uae08\\uc758\\ucc28\\uc785\": \"6296275364\",\n",
      "\t\"\\uc7a5\\uae30\\ucc28\\uc785\\uae08\\uc758\\ucc28\\uc785\": \"-\",\n",
      "\t\"\\uc7ac\\ubb34\\ud65c\\ub3d9\\uc73c\\ub85c\\uc778\\ud55c\\ud604\\uae08\\uc720\\ucd9c\\uc561\": \"(5653519649)\",\n",
      "\t\"\\ub2e8\\uae30\\ucc28\\uc785\\uae08\\uc758\\uc0c1\\ud658\": \"5529159649\",\n",
      "\t\"\\uc720\\ub3d9\\uc131\\uc7a5\\uae30\\ubd80\\ucc44\\uc758\\uc0c1\\ud658\": \"70620000\",\n",
      "\t\"\\uc7a5\\uae30\\ucc28\\uc785\\uae08\\uc758\\uc0c1\\ud658\": \"53740000\",\n",
      "\t\"\\ud604\\uae08\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"(419406795)\",\n",
      "\t\"\\uae30\\ucd08\\uc758\\ud604\\uae08\": \"445973226\",\n",
      "\t\"\\uae30\\ub9d0\\uc758\\ud604\\uae08\": \"26566431\"\n",
      "} {'영업활동으로인한현금흐름': '(767640486)', '당기순이익': '468773876', '현금의유출이없는비용등의가산': '156600984', '퇴직급여': '94046393', '감가상각비': '38646198', '단기투자자산처분손실': '-', '무형자산상각비': '1248393', '기타의비유동자산처분손실': '22660000', '현금의유입이없는수익등의차감': '(16468617)', '단기투자자산처분이익': '-', '유형자산처분이익': '6104427', '대손충당금환입': '10364190', '영업활동으로인한자산부채의변동': '(1376546729)', '매출채권의감소증가': '(1018887732)', '미수금의감소증가': '(2549735)', '미수수익의감소증가': '(559053)', '선급금의감소증가': '(298945900)', '선급비용의감소증가': '550024295', '미수법인세환급액의감소증가': '-', '재고자산의감소증가': '181883518', '이연법인세자산의감소증가': '-', '퇴직연금운용자산의감소증가': '(32405655)', '매입채무의증가감소': '(1171827501)', '미지급금의증가감소': '531868047', '예수금의증가감소': '(2531456)', '부가세예수금의증가감소': '(77661796)', '공사선수금의증가감소': '29522820', '미지급비용의증가감소': '(10817016)', '미지급법인세의증가감소': '65698716', '공사손실충당부채의증가감소': '-', '단기이연법인세부채의증가감소': '(264181)', '장기이연법인세부채의증가감소': '12827638', '퇴직금의지급': '(131921738)', '투자활동으로인한현금흐름': '(294522024)', '투자활동으로인한현금유입액': '219209233', '단기금융상품의감소': '103091770', '단기투자자산의감소': '-', '장기금융상품의감소': '8990190', '차량운반구의처분': '5272728', '비품의처분': '1200000', '시설이용권의처분': '75454545', '임대보증금의증가': '14000000', '보증금의감소': '11200000', '투자활동으로인한현금유출액': '(513731257)', '단기금융상품의취득': '-', '단기투자자산의증가': '-', '장기금융상품의취득': '291474108', '차량운반구의취득': '14836414', '비품의취득': '2454545', '소프트웨어의취득': '10700000', '종업원단기대여금의대여': '20000000', '임대보증금의감소': '10000000', '보증금의증가': '27700000', '기타의유형자산의취득': '-', '시설이용권의취득': '136566190', '재무활동으로인한현금흐름': '642755715', '재무활동으로인한현금유입액': '6296275364', '단기차입금의차입': '6296275364', '장기차입금의차입': '-', '재무활동으로인한현금유출액': '(5653519649)', '단기차입금의상환': '5529159649', '유동성장기부채의상환': '70620000', '장기차입금의상환': '53740000', '현금의증가감소': '(419406795)', '기초의현금': '445973226', '기말의현금': '26566431'}\n"
     ]
    }
   ],
   "source": [
    "# 현금흐름표 재무 데이터를 저장하는 JSON(파이썬 딕셔너리) 변수 생성\n",
    "cash_flow_json = OrderedDict()\n",
    "# checkpoint 6\n",
    "#print('checkpoint 6 >>', cash_flow_bsObj)\n",
    "# 현금흐름표에서 재무 데이터가 포함된 <tr> 태그 리스트 추출\n",
    "cash_flow_trObjList = cash_flow_bsObj.find_all('tbody')[1].find_all('tr')\n",
    "# 컬럼 명을 확인해서, 수집 대상이면 수집 리스트에 저장\n",
    "for trObj in cash_flow_trObjList:\n",
    "    # 컬럼 명 수집 및 전처리\n",
    "    column = trObj.find('td').get_text()\n",
    "    column = re.sub('[' + chr(32) + chr(160) + ']', '', column)  # 유령문자 제거\n",
    "    column = re.sub('[가-힣]\\.', '', column)\n",
    "    column = re.sub('[\\t\\n\\r\\f\\v-=.,#/?:$\\{\\}a-zA-Z0-9Ⅰ-Ↄ]', '', column)\n",
    "    column = re.sub('주석', '', column)\n",
    "    # 컬럼 값 수집 및 전처리\n",
    "    value = \"\"\n",
    "    for td in trObj.find_all('td')[1:]:\n",
    "        td_text = td.get_text()\n",
    "        td_text = re.sub('[' + chr(32) + chr(160) + ']', '', td_text)  # 유령문자 제거\n",
    "        td_text = re.sub('[\\t\\n\\r\\f\\v,]', '', td_text)  # 공백 및 쉼표(,) 제거\n",
    "        if td_text != \"\":\n",
    "            value = td_text\n",
    "            break\n",
    "    # checkpoint 6-1\n",
    "    #print('checkpoint 6-1 >>', column, '|', value)\n",
    "    cash_flow_json[column] = value\n",
    "# checkpoint 6-2\n",
    "jsonString_6_2 = json.dumps(cash_flow_json, indent='\\t')  # JSON 문자열 생성\n",
    "print('checkpoint 6-2 >>', jsonString_6_2, json.loads(jsonString_6_2))  # JSON 문자열로 생성산 JSON 객체 출력"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "checkpoint 7 >> {\n",
      "\t\"\\uc7ac\\ubb34\\uc0c1\\ud0dc\\ud45c(\\ub300\\ucc28\\ub300\\uc870\\ud45c)\": {\n",
      "\t\t\"\\uc790\\uc0b0\": \"\",\n",
      "\t\t\"\\uc720\\ub3d9\\uc790\\uc0b0\": \"8738672749\",\n",
      "\t\t\"\\ub2f9\\uc88c\\uc790\\uc0b0\": \"8378942749\",\n",
      "\t\t\"\\ud604\\uae08\\ubc0f\\ud604\\uae08\\uc131\\uc790\\uc0b0\": \"26566431\",\n",
      "\t\t\"\\ub2e8\\uae30\\uae08\\uc735\\uc0c1\\ud488\": \"-\",\n",
      "\t\t\"\\ub2e8\\uae30\\ud22c\\uc790\\uc790\\uc0b0\": \"5278873\",\n",
      "\t\t\"\\ub9e4\\ucd9c\\ucc44\\uad8c\": \"7990595613\",\n",
      "\t\t\"\\ub300\\uc190\\ucda9\\ub2f9\\uae08\": \"(100320)\",\n",
      "\t\t\"\\ubbf8\\uc218\\uae08\": \"16489845\",\n",
      "\t\t\"\\ubbf8\\uc218\\uc218\\uc775\": \"18347709\",\n",
      "\t\t\"\\uc120\\uae09\\ube44\\uc6a9\": \"29371253\",\n",
      "\t\t\"\\uc120\\uae09\\uae08\": \"298945900\",\n",
      "\t\t\"\\uc885\\uc5c5\\uc6d0\\ub2e8\\uae30\\ub300\\uc5ec\\uae08\": \"20000000\",\n",
      "\t\t\"\\uc7ac\\uace0\\uc790\\uc0b0\": \"359730000\",\n",
      "\t\t\"\\uc120\\uae09\\uacf5\\uc0ac\\uc6d0\\uac00\": \"-\",\n",
      "\t\t\"\\uc6d0\\uc7ac\\ub8cc\": \"359730000\",\n",
      "\t\t\"\\ube44\\uc720\\ub3d9\\uc790\\uc0b0\": \"6718441332\",\n",
      "\t\t\"\\ud22c\\uc790\\uc790\\uc0b0\": \"1375399161\",\n",
      "\t\t\"\\uc7a5\\uae30\\uae08\\uc735\\uc0c1\\ud488\": \"728650481\",\n",
      "\t\t\"\\uc7a5\\uae30\\ud22c\\uc790\\uc99d\\uad8c\": \"646748680\",\n",
      "\t\t\"\\uc720\\ud615\\uc790\\uc0b0\": \"5134174374\",\n",
      "\t\t\"\\ud1a0\\uc9c0\": \"4165600000\",\n",
      "\t\t\"\\uac74\\ubb3c\": \"1103424410\",\n",
      "\t\t\"\\uac10\\uac00\\uc0c1\\uac01\\ub204\\uacc4\\uc561\": \"(4613000)\",\n",
      "\t\t\"\\ucc28\\ub7c9\\uc6b4\\ubc18\\uad6c\": \"62173694\",\n",
      "\t\t\"\\ube44\\ud488\": \"154615189\",\n",
      "\t\t\"\\uacf5\\uad6c\\uc640\\uae30\\uad6c\": \"4615000\",\n",
      "\t\t\"\\ubb34\\ud615\\uc790\\uc0b0\": \"9451607\",\n",
      "\t\t\"\\uc18c\\ud504\\ud2b8\\uc6e8\\uc5b4\": \"9451607\",\n",
      "\t\t\"\\uae30\\ud0c0\\ube44\\uc720\\ub3d9\\uc790\\uc0b0\": \"199416190\",\n",
      "\t\t\"\\ubcf4\\uc99d\\uae08\": \"62850000\",\n",
      "\t\t\"\\uc2dc\\uc124\\uc774\\uc6a9\\uad8c\": \"136566190\",\n",
      "\t\t\"\\uc790\\uc0b0\\ucd1d\\uacc4\": \"15457114081\",\n",
      "\t\t\"\\ubd80\\ucc44\": \"\",\n",
      "\t\t\"\\uc720\\ub3d9\\ubd80\\ucc44\": \"9092665284\",\n",
      "\t\t\"\\ub2e8\\uae30\\ucc28\\uc785\\uae08\": \"5537724209\",\n",
      "\t\t\"\\uc720\\ub3d9\\uc131\\uc7a5\\uae30\\ubd80\\ucc44\": \"107480000\",\n",
      "\t\t\"\\ub9e4\\uc785\\ucc44\\ubb34\": \"2404029259\",\n",
      "\t\t\"\\ubbf8\\uc9c0\\uae09\\uae08\": \"751246817\",\n",
      "\t\t\"\\uc608\\uc218\\uae08\": \"14685528\",\n",
      "\t\t\"\\ubd80\\uac00\\uc138\\uc608\\uc218\\uae08\": \"154716433\",\n",
      "\t\t\"\\ubbf8\\uc9c0\\uae09\\ube44\\uc6a9\": \"12838981\",\n",
      "\t\t\"\\ubbf8\\uc9c0\\uae09\\ubc95\\uc778\\uc138\": \"76380563\",\n",
      "\t\t\"\\uacf5\\uc0ac\\uc120\\uc218\\uae08\": \"29522820\",\n",
      "\t\t\"\\ub2e8\\uae30\\uc774\\uc5f0\\ubc95\\uc778\\uc138\\ubd80\\ucc44\": \"4040674\",\n",
      "\t\t\"\\ube44\\uc720\\ub3d9\\ubd80\\ucc44\": \"977748285\",\n",
      "\t\t\"\\uc7a5\\uae30\\ucc28\\uc785\\uae08\": \"268780000\",\n",
      "\t\t\"\\ud1f4\\uc9c1\\uae09\\uc5ec\\ucda9\\ub2f9\\ubd80\\ucc44\": \"279024714\",\n",
      "\t\t\"\\ud1f4\\uc9c1\\uc5f0\\uae08\\uc6b4\\uc6a9\\uc790\\uc0b0\": \"(101125147)\",\n",
      "\t\t\"\\uc784\\ub300\\ubcf4\\uc99d\\uae08\": \"142000000\",\n",
      "\t\t\"\\uc7a5\\uae30\\uc774\\uc5f0\\ubc95\\uc778\\uc138\\ubd80\\ucc44\": \"389068718\",\n",
      "\t\t\"\\ubd80\\ucc44\\ucd1d\\uacc4\": \"10070413569\",\n",
      "\t\t\"\\uc790\\ubcf8\": \"\",\n",
      "\t\t\"\\uc790\\ubcf8\\uae08\": \"1000000000\",\n",
      "\t\t\"\\ubcf4\\ud1b5\\uc8fc\\uc790\\ubcf8\\uae08\": \"1000000000\",\n",
      "\t\t\"\\uc790\\ubcf8\\uc789\\uc5ec\\uae08\": \"-\",\n",
      "\t\t\"\\uae30\\ud0c0\\ud3ec\\uad04\\uc190\\uc775\\ub204\\uacc4\\uc561\": \"1482017485\",\n",
      "\t\t\"\\uc790\\uc0b0\\uc7ac\\ud3c9\\uac00\\ucc28\\uc775\": \"1481998492\",\n",
      "\t\t\"\\ub2e8\\uae30\\ud22c\\uc790\\uc790\\uc0b0\\ud3c9\\uac00\\uc774\\uc775\": \"18993\",\n",
      "\t\t\"\\uc774\\uc775\\uc789\\uc5ec\\uae08\": \"2904683027\",\n",
      "\t\t\"\\ubc95\\uc815\\uc801\\ub9bd\\uae08\": \"45000000\",\n",
      "\t\t\"\\ubbf8\\ucc98\\ubd84\\uc774\\uc775\\uc789\\uc5ec\\uae08\": \"2859683027\",\n",
      "\t\t\"\\uc790\\ubcf8\\ucd1d\\uacc4\": \"5386700512\",\n",
      "\t\t\"\\ubd80\\ucc44\\uc640\\uc790\\ubcf8\\ucd1d\\uacc4\": \"15457114081\"\n",
      "\t},\n",
      "\t\"\\uc190\\uc775\\uacc4\\uc0b0\\uc11c\": {\n",
      "\t\t\"\\ub9e4\\ucd9c\\uc561\": \"32849969869\",\n",
      "\t\t\"\\uacf5\\uc0ac\\uc218\\uc775\": \"32732729595\",\n",
      "\t\t\"\\uc784\\ub300\\uc218\\uc775\": \"117240274\",\n",
      "\t\t\"\\ub9e4\\ucd9c\\uc6d0\\uac00\": \"30839010989\",\n",
      "\t\t\"\\uacf5\\uc0ac\\uc6d0\\uac00\": \"30839010989\",\n",
      "\t\t\"\\ub9e4\\ucd9c\\ucd1d\\uc774\\uc775\": \"2010958880\",\n",
      "\t\t\"\\ud310\\ub9e4\\ube44\\uc640\\uad00\\ub9ac\\ube44\": \"1028455053\",\n",
      "\t\t\"\\uae09\\uc5ec\": \"563614950\",\n",
      "\t\t\"\\ud1f4\\uc9c1\\uae09\\uc5ec\": \"44520602\",\n",
      "\t\t\"\\ubcf5\\ub9ac\\ud6c4\\uc0dd\\ube44\": \"88082710\",\n",
      "\t\t\"\\uc5ec\\ube44\\uad50\\ud1b5\\ube44\": \"5071450\",\n",
      "\t\t\"\\uc811\\ub300\\ube44\": \"25624460\",\n",
      "\t\t\"\\ud1b5\\uc2e0\\ube44\": \"8956164\",\n",
      "\t\t\"\\uc138\\uae08\\uacfc\\uacf5\\uacfc\": \"43623077\",\n",
      "\t\t\"\\uac10\\uac00\\uc0c1\\uac01\\ube44\": \"36534690\",\n",
      "\t\t\"\\uc218\\ub3c4\\uad11\\uc5f4\\ube44\": \"4049427\",\n",
      "\t\t\"\\uc804\\ub825\\ube44\": \"2319073\",\n",
      "\t\t\"\\uc218\\uc120\\ube44\": \"820000\",\n",
      "\t\t\"\\ubcf4\\ud5d8\\ub8cc\": \"19801308\",\n",
      "\t\t\"\\ucc28\\ub7c9\\uc720\\uc9c0\\ube44\": \"38801669\",\n",
      "\t\t\"\\uc6b4\\ubc18\\ube44\": \"706949\",\n",
      "\t\t\"\\uad50\\uc721\\ud6c8\\ub828\\ube44\": \"-\",\n",
      "\t\t\"\\ub3c4\\uc11c\\uc778\\uc1c4\\ube44\": \"764500\",\n",
      "\t\t\"\\uc0ac\\ubb34\\uc6a9\\ud488\\ube44\": \"5862317\",\n",
      "\t\t\"\\uc18c\\ubaa8\\ud488\\ube44\": \"7374661\",\n",
      "\t\t\"\\uc9c0\\uae09\\uc218\\uc218\\ub8cc\": \"87765861\",\n",
      "\t\t\"\\ub9ac\\uc2a4\\ub8cc\": \"42912792\",\n",
      "\t\t\"\\ubb34\\ud615\\uc790\\uc0b0\\uc0c1\\uac01\\ube44\": \"1248393\",\n",
      "\t\t\"\\uc7a1\\ube44\": \"-\",\n",
      "\t\t\"\\uc601\\uc5c5\\uc774\\uc775\": \"982503827\",\n",
      "\t\t\"\\uc601\\uc5c5\\uc678\\uc218\\uc775\": \"32879673\",\n",
      "\t\t\"\\uc774\\uc790\\uc218\\uc775\": \"7043426\",\n",
      "\t\t\"\\ub2e8\\uae30\\ud22c\\uc790\\uc790\\uc0b0\\ucc98\\ubd84\\uc774\\uc775\": \"-\",\n",
      "\t\t\"\\ub300\\uc190\\ucda9\\ub2f9\\uae08\\ud658\\uc785\": \"10364190\",\n",
      "\t\t\"\\uc720\\ud615\\uc790\\uc0b0\\ucc98\\ubd84\\uc774\\uc775\": \"6104427\",\n",
      "\t\t\"\\uc7a1\\uc774\\uc775\": \"9367630\",\n",
      "\t\t\"\\uc601\\uc5c5\\uc678\\ube44\\uc6a9\": \"452611094\",\n",
      "\t\t\"\\uc774\\uc790\\ube44\\uc6a9\": \"343033803\",\n",
      "\t\t\"\\ub9e4\\ucd9c\\ucc44\\uad8c\\ucc98\\ubd84\\uc190\\uc2e4\": \"84794334\",\n",
      "\t\t\"\\ub2e8\\uae30\\ud22c\\uc790\\uc790\\uc0b0\\ucc98\\ubd84\\uc190\\uc2e4\": \"-\",\n",
      "\t\t\"\\uae30\\ubd80\\uae08\": \"100000\",\n",
      "\t\t\"\\uae30\\ud0c0\\ube44\\uc720\\ub3d9\\uc790\\uc0b0\\ucc98\\ubd84\\uc190\\uc2e4\": \"22660000\",\n",
      "\t\t\"\\uc7a1\\uc190\\uc2e4\": \"2022957\",\n",
      "\t\t\"\\ubc95\\uc778\\uc138\\ube44\\uc6a9\\ucc28\\uac10\\uc804\\uc21c\\uc774\\uc775\": \"562772406\",\n",
      "\t\t\"\\ubc95\\uc778\\uc138\\ube44\\uc6a9\": \"93998530\",\n",
      "\t\t\"\\ub2f9\\uae30\\uc21c\\uc774\\uc775\": \"468773876\",\n",
      "\t\t\"\\uc8fc\\ub2f9\\uc190\\uc775\": \"\",\n",
      "\t\t\"\\uae30\\ubcf8\\uc8fc\\ub2f9\\uc21c\\uc774\\uc775\": \"4688\"\n",
      "\t},\n",
      "\t\"\\ud604\\uae08\\ud750\\ub984\\ud45c\": {\n",
      "\t\t\"\\uc601\\uc5c5\\ud65c\\ub3d9\\uc73c\\ub85c\\uc778\\ud55c\\ud604\\uae08\\ud750\\ub984\": \"(767640486)\",\n",
      "\t\t\"\\ub2f9\\uae30\\uc21c\\uc774\\uc775\": \"468773876\",\n",
      "\t\t\"\\ud604\\uae08\\uc758\\uc720\\ucd9c\\uc774\\uc5c6\\ub294\\ube44\\uc6a9\\ub4f1\\uc758\\uac00\\uc0b0\": \"156600984\",\n",
      "\t\t\"\\ud1f4\\uc9c1\\uae09\\uc5ec\": \"94046393\",\n",
      "\t\t\"\\uac10\\uac00\\uc0c1\\uac01\\ube44\": \"38646198\",\n",
      "\t\t\"\\ub2e8\\uae30\\ud22c\\uc790\\uc790\\uc0b0\\ucc98\\ubd84\\uc190\\uc2e4\": \"-\",\n",
      "\t\t\"\\ubb34\\ud615\\uc790\\uc0b0\\uc0c1\\uac01\\ube44\": \"1248393\",\n",
      "\t\t\"\\uae30\\ud0c0\\uc758\\ube44\\uc720\\ub3d9\\uc790\\uc0b0\\ucc98\\ubd84\\uc190\\uc2e4\": \"22660000\",\n",
      "\t\t\"\\ud604\\uae08\\uc758\\uc720\\uc785\\uc774\\uc5c6\\ub294\\uc218\\uc775\\ub4f1\\uc758\\ucc28\\uac10\": \"(16468617)\",\n",
      "\t\t\"\\ub2e8\\uae30\\ud22c\\uc790\\uc790\\uc0b0\\ucc98\\ubd84\\uc774\\uc775\": \"-\",\n",
      "\t\t\"\\uc720\\ud615\\uc790\\uc0b0\\ucc98\\ubd84\\uc774\\uc775\": \"6104427\",\n",
      "\t\t\"\\ub300\\uc190\\ucda9\\ub2f9\\uae08\\ud658\\uc785\": \"10364190\",\n",
      "\t\t\"\\uc601\\uc5c5\\ud65c\\ub3d9\\uc73c\\ub85c\\uc778\\ud55c\\uc790\\uc0b0\\ubd80\\ucc44\\uc758\\ubcc0\\ub3d9\": \"(1376546729)\",\n",
      "\t\t\"\\ub9e4\\ucd9c\\ucc44\\uad8c\\uc758\\uac10\\uc18c\\uc99d\\uac00\": \"(1018887732)\",\n",
      "\t\t\"\\ubbf8\\uc218\\uae08\\uc758\\uac10\\uc18c\\uc99d\\uac00\": \"(2549735)\",\n",
      "\t\t\"\\ubbf8\\uc218\\uc218\\uc775\\uc758\\uac10\\uc18c\\uc99d\\uac00\": \"(559053)\",\n",
      "\t\t\"\\uc120\\uae09\\uae08\\uc758\\uac10\\uc18c\\uc99d\\uac00\": \"(298945900)\",\n",
      "\t\t\"\\uc120\\uae09\\ube44\\uc6a9\\uc758\\uac10\\uc18c\\uc99d\\uac00\": \"550024295\",\n",
      "\t\t\"\\ubbf8\\uc218\\ubc95\\uc778\\uc138\\ud658\\uae09\\uc561\\uc758\\uac10\\uc18c\\uc99d\\uac00\": \"-\",\n",
      "\t\t\"\\uc7ac\\uace0\\uc790\\uc0b0\\uc758\\uac10\\uc18c\\uc99d\\uac00\": \"181883518\",\n",
      "\t\t\"\\uc774\\uc5f0\\ubc95\\uc778\\uc138\\uc790\\uc0b0\\uc758\\uac10\\uc18c\\uc99d\\uac00\": \"-\",\n",
      "\t\t\"\\ud1f4\\uc9c1\\uc5f0\\uae08\\uc6b4\\uc6a9\\uc790\\uc0b0\\uc758\\uac10\\uc18c\\uc99d\\uac00\": \"(32405655)\",\n",
      "\t\t\"\\ub9e4\\uc785\\ucc44\\ubb34\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"(1171827501)\",\n",
      "\t\t\"\\ubbf8\\uc9c0\\uae09\\uae08\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"531868047\",\n",
      "\t\t\"\\uc608\\uc218\\uae08\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"(2531456)\",\n",
      "\t\t\"\\ubd80\\uac00\\uc138\\uc608\\uc218\\uae08\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"(77661796)\",\n",
      "\t\t\"\\uacf5\\uc0ac\\uc120\\uc218\\uae08\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"29522820\",\n",
      "\t\t\"\\ubbf8\\uc9c0\\uae09\\ube44\\uc6a9\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"(10817016)\",\n",
      "\t\t\"\\ubbf8\\uc9c0\\uae09\\ubc95\\uc778\\uc138\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"65698716\",\n",
      "\t\t\"\\uacf5\\uc0ac\\uc190\\uc2e4\\ucda9\\ub2f9\\ubd80\\ucc44\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"-\",\n",
      "\t\t\"\\ub2e8\\uae30\\uc774\\uc5f0\\ubc95\\uc778\\uc138\\ubd80\\ucc44\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"(264181)\",\n",
      "\t\t\"\\uc7a5\\uae30\\uc774\\uc5f0\\ubc95\\uc778\\uc138\\ubd80\\ucc44\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"12827638\",\n",
      "\t\t\"\\ud1f4\\uc9c1\\uae08\\uc758\\uc9c0\\uae09\": \"(131921738)\",\n",
      "\t\t\"\\ud22c\\uc790\\ud65c\\ub3d9\\uc73c\\ub85c\\uc778\\ud55c\\ud604\\uae08\\ud750\\ub984\": \"(294522024)\",\n",
      "\t\t\"\\ud22c\\uc790\\ud65c\\ub3d9\\uc73c\\ub85c\\uc778\\ud55c\\ud604\\uae08\\uc720\\uc785\\uc561\": \"219209233\",\n",
      "\t\t\"\\ub2e8\\uae30\\uae08\\uc735\\uc0c1\\ud488\\uc758\\uac10\\uc18c\": \"103091770\",\n",
      "\t\t\"\\ub2e8\\uae30\\ud22c\\uc790\\uc790\\uc0b0\\uc758\\uac10\\uc18c\": \"-\",\n",
      "\t\t\"\\uc7a5\\uae30\\uae08\\uc735\\uc0c1\\ud488\\uc758\\uac10\\uc18c\": \"8990190\",\n",
      "\t\t\"\\ucc28\\ub7c9\\uc6b4\\ubc18\\uad6c\\uc758\\ucc98\\ubd84\": \"5272728\",\n",
      "\t\t\"\\ube44\\ud488\\uc758\\ucc98\\ubd84\": \"1200000\",\n",
      "\t\t\"\\uc2dc\\uc124\\uc774\\uc6a9\\uad8c\\uc758\\ucc98\\ubd84\": \"75454545\",\n",
      "\t\t\"\\uc784\\ub300\\ubcf4\\uc99d\\uae08\\uc758\\uc99d\\uac00\": \"14000000\",\n",
      "\t\t\"\\ubcf4\\uc99d\\uae08\\uc758\\uac10\\uc18c\": \"11200000\",\n",
      "\t\t\"\\ud22c\\uc790\\ud65c\\ub3d9\\uc73c\\ub85c\\uc778\\ud55c\\ud604\\uae08\\uc720\\ucd9c\\uc561\": \"(513731257)\",\n",
      "\t\t\"\\ub2e8\\uae30\\uae08\\uc735\\uc0c1\\ud488\\uc758\\ucde8\\ub4dd\": \"-\",\n",
      "\t\t\"\\ub2e8\\uae30\\ud22c\\uc790\\uc790\\uc0b0\\uc758\\uc99d\\uac00\": \"-\",\n",
      "\t\t\"\\uc7a5\\uae30\\uae08\\uc735\\uc0c1\\ud488\\uc758\\ucde8\\ub4dd\": \"291474108\",\n",
      "\t\t\"\\ucc28\\ub7c9\\uc6b4\\ubc18\\uad6c\\uc758\\ucde8\\ub4dd\": \"14836414\",\n",
      "\t\t\"\\ube44\\ud488\\uc758\\ucde8\\ub4dd\": \"2454545\",\n",
      "\t\t\"\\uc18c\\ud504\\ud2b8\\uc6e8\\uc5b4\\uc758\\ucde8\\ub4dd\": \"10700000\",\n",
      "\t\t\"\\uc885\\uc5c5\\uc6d0\\ub2e8\\uae30\\ub300\\uc5ec\\uae08\\uc758\\ub300\\uc5ec\": \"20000000\",\n",
      "\t\t\"\\uc784\\ub300\\ubcf4\\uc99d\\uae08\\uc758\\uac10\\uc18c\": \"10000000\",\n",
      "\t\t\"\\ubcf4\\uc99d\\uae08\\uc758\\uc99d\\uac00\": \"27700000\",\n",
      "\t\t\"\\uae30\\ud0c0\\uc758\\uc720\\ud615\\uc790\\uc0b0\\uc758\\ucde8\\ub4dd\": \"-\",\n",
      "\t\t\"\\uc2dc\\uc124\\uc774\\uc6a9\\uad8c\\uc758\\ucde8\\ub4dd\": \"136566190\",\n",
      "\t\t\"\\uc7ac\\ubb34\\ud65c\\ub3d9\\uc73c\\ub85c\\uc778\\ud55c\\ud604\\uae08\\ud750\\ub984\": \"642755715\",\n",
      "\t\t\"\\uc7ac\\ubb34\\ud65c\\ub3d9\\uc73c\\ub85c\\uc778\\ud55c\\ud604\\uae08\\uc720\\uc785\\uc561\": \"6296275364\",\n",
      "\t\t\"\\ub2e8\\uae30\\ucc28\\uc785\\uae08\\uc758\\ucc28\\uc785\": \"6296275364\",\n",
      "\t\t\"\\uc7a5\\uae30\\ucc28\\uc785\\uae08\\uc758\\ucc28\\uc785\": \"-\",\n",
      "\t\t\"\\uc7ac\\ubb34\\ud65c\\ub3d9\\uc73c\\ub85c\\uc778\\ud55c\\ud604\\uae08\\uc720\\ucd9c\\uc561\": \"(5653519649)\",\n",
      "\t\t\"\\ub2e8\\uae30\\ucc28\\uc785\\uae08\\uc758\\uc0c1\\ud658\": \"5529159649\",\n",
      "\t\t\"\\uc720\\ub3d9\\uc131\\uc7a5\\uae30\\ubd80\\ucc44\\uc758\\uc0c1\\ud658\": \"70620000\",\n",
      "\t\t\"\\uc7a5\\uae30\\ucc28\\uc785\\uae08\\uc758\\uc0c1\\ud658\": \"53740000\",\n",
      "\t\t\"\\ud604\\uae08\\uc758\\uc99d\\uac00\\uac10\\uc18c\": \"(419406795)\",\n",
      "\t\t\"\\uae30\\ucd08\\uc758\\ud604\\uae08\": \"445973226\",\n",
      "\t\t\"\\uae30\\ub9d0\\uc758\\ud604\\uae08\": \"26566431\"\n",
      "\t}\n",
      "} {'재무상태표(대차대조표)': {'자산': '', '유동자산': '8738672749', '당좌자산': '8378942749', '현금및현금성자산': '26566431', '단기금융상품': '-', '단기투자자산': '5278873', '매출채권': '7990595613', '대손충당금': '(100320)', '미수금': '16489845', '미수수익': '18347709', '선급비용': '29371253', '선급금': '298945900', '종업원단기대여금': '20000000', '재고자산': '359730000', '선급공사원가': '-', '원재료': '359730000', '비유동자산': '6718441332', '투자자산': '1375399161', '장기금융상품': '728650481', '장기투자증권': '646748680', '유형자산': '5134174374', '토지': '4165600000', '건물': '1103424410', '감가상각누계액': '(4613000)', '차량운반구': '62173694', '비품': '154615189', '공구와기구': '4615000', '무형자산': '9451607', '소프트웨어': '9451607', '기타비유동자산': '199416190', '보증금': '62850000', '시설이용권': '136566190', '자산총계': '15457114081', '부채': '', '유동부채': '9092665284', '단기차입금': '5537724209', '유동성장기부채': '107480000', '매입채무': '2404029259', '미지급금': '751246817', '예수금': '14685528', '부가세예수금': '154716433', '미지급비용': '12838981', '미지급법인세': '76380563', '공사선수금': '29522820', '단기이연법인세부채': '4040674', '비유동부채': '977748285', '장기차입금': '268780000', '퇴직급여충당부채': '279024714', '퇴직연금운용자산': '(101125147)', '임대보증금': '142000000', '장기이연법인세부채': '389068718', '부채총계': '10070413569', '자본': '', '자본금': '1000000000', '보통주자본금': '1000000000', '자본잉여금': '-', '기타포괄손익누계액': '1482017485', '자산재평가차익': '1481998492', '단기투자자산평가이익': '18993', '이익잉여금': '2904683027', '법정적립금': '45000000', '미처분이익잉여금': '2859683027', '자본총계': '5386700512', '부채와자본총계': '15457114081'}, '손익계산서': {'매출액': '32849969869', '공사수익': '32732729595', '임대수익': '117240274', '매출원가': '30839010989', '공사원가': '30839010989', '매출총이익': '2010958880', '판매비와관리비': '1028455053', '급여': '563614950', '퇴직급여': '44520602', '복리후생비': '88082710', '여비교통비': '5071450', '접대비': '25624460', '통신비': '8956164', '세금과공과': '43623077', '감가상각비': '36534690', '수도광열비': '4049427', '전력비': '2319073', '수선비': '820000', '보험료': '19801308', '차량유지비': '38801669', '운반비': '706949', '교육훈련비': '-', '도서인쇄비': '764500', '사무용품비': '5862317', '소모품비': '7374661', '지급수수료': '87765861', '리스료': '42912792', '무형자산상각비': '1248393', '잡비': '-', '영업이익': '982503827', '영업외수익': '32879673', '이자수익': '7043426', '단기투자자산처분이익': '-', '대손충당금환입': '10364190', '유형자산처분이익': '6104427', '잡이익': '9367630', '영업외비용': '452611094', '이자비용': '343033803', '매출채권처분손실': '84794334', '단기투자자산처분손실': '-', '기부금': '100000', '기타비유동자산처분손실': '22660000', '잡손실': '2022957', '법인세비용차감전순이익': '562772406', '법인세비용': '93998530', '당기순이익': '468773876', '주당손익': '', '기본주당순이익': '4688'}, '현금흐름표': {'영업활동으로인한현금흐름': '(767640486)', '당기순이익': '468773876', '현금의유출이없는비용등의가산': '156600984', '퇴직급여': '94046393', '감가상각비': '38646198', '단기투자자산처분손실': '-', '무형자산상각비': '1248393', '기타의비유동자산처분손실': '22660000', '현금의유입이없는수익등의차감': '(16468617)', '단기투자자산처분이익': '-', '유형자산처분이익': '6104427', '대손충당금환입': '10364190', '영업활동으로인한자산부채의변동': '(1376546729)', '매출채권의감소증가': '(1018887732)', '미수금의감소증가': '(2549735)', '미수수익의감소증가': '(559053)', '선급금의감소증가': '(298945900)', '선급비용의감소증가': '550024295', '미수법인세환급액의감소증가': '-', '재고자산의감소증가': '181883518', '이연법인세자산의감소증가': '-', '퇴직연금운용자산의감소증가': '(32405655)', '매입채무의증가감소': '(1171827501)', '미지급금의증가감소': '531868047', '예수금의증가감소': '(2531456)', '부가세예수금의증가감소': '(77661796)', '공사선수금의증가감소': '29522820', '미지급비용의증가감소': '(10817016)', '미지급법인세의증가감소': '65698716', '공사손실충당부채의증가감소': '-', '단기이연법인세부채의증가감소': '(264181)', '장기이연법인세부채의증가감소': '12827638', '퇴직금의지급': '(131921738)', '투자활동으로인한현금흐름': '(294522024)', '투자활동으로인한현금유입액': '219209233', '단기금융상품의감소': '103091770', '단기투자자산의감소': '-', '장기금융상품의감소': '8990190', '차량운반구의처분': '5272728', '비품의처분': '1200000', '시설이용권의처분': '75454545', '임대보증금의증가': '14000000', '보증금의감소': '11200000', '투자활동으로인한현금유출액': '(513731257)', '단기금융상품의취득': '-', '단기투자자산의증가': '-', '장기금융상품의취득': '291474108', '차량운반구의취득': '14836414', '비품의취득': '2454545', '소프트웨어의취득': '10700000', '종업원단기대여금의대여': '20000000', '임대보증금의감소': '10000000', '보증금의증가': '27700000', '기타의유형자산의취득': '-', '시설이용권의취득': '136566190', '재무활동으로인한현금흐름': '642755715', '재무활동으로인한현금유입액': '6296275364', '단기차입금의차입': '6296275364', '장기차입금의차입': '-', '재무활동으로인한현금유출액': '(5653519649)', '단기차입금의상환': '5529159649', '유동성장기부채의상환': '70620000', '장기차입금의상환': '53740000', '현금의증가감소': '(419406795)', '기초의현금': '445973226', '기말의현금': '26566431'}}\n"
     ]
    }
   ],
   "source": [
    "# 재무제표 재무 데이터를 저장하는 JSON(파이썬 딕셔너리) 변수 생성\n",
    "report_json = OrderedDict()\n",
    "# 세부 제무 보고서를 재무제표 재무 데이터를 저장하는 JSON(파이썬 딕셔너리)에 저장\n",
    "report_json['재무상태표(대차대조표)'] = finance_position_json\n",
    "report_json['손익계산서'] = income_statement_json\n",
    "report_json['현금흐름표'] = cash_flow_json\n",
    "# checkpoint 7\n",
    "jsonString_7 = json.dumps(report_json, indent='\\t')  # JSON 문자열 생성\n",
    "print('checkpoint 7 >>', jsonString_7, json.loads(jsonString_7))  # JSON 문자열로 생성산 JSON 객체 출력"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>감가상각누계액</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",
       "      <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>(4613000)</td>\n",
       "      <td>1103424410</td>\n",
       "      <td>4615000</td>\n",
       "      <td>29522820</td>\n",
       "      <td>199416190</td>\n",
       "      <td>1482017485</td>\n",
       "      <td>-</td>\n",
       "      <td>4040674</td>\n",
       "      <td>5537724209</td>\n",
       "      <td>5278873</td>\n",
       "      <td>...</td>\n",
       "      <td>268780000</td>\n",
       "      <td>646748680</td>\n",
       "      <td>359730000</td>\n",
       "      <td>20000000</td>\n",
       "      <td>62173694</td>\n",
       "      <td>4165600000</td>\n",
       "      <td>279024714</td>\n",
       "      <td>(101125147)</td>\n",
       "      <td>1375399161</td>\n",
       "      <td>26566431</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 64 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     감가상각누계액          건물    공구와기구     공사선수금    기타비유동자산   기타포괄손익누계액 단기금융상품  \\\n",
       "0  (4613000)  1103424410  4615000  29522820  199416190  1482017485      -   \n",
       "\n",
       "  단기이연법인세부채       단기차입금   단기투자자산    ...         장기차입금     장기투자증권       재고자산  \\\n",
       "0   4040674  5537724209  5278873    ...     268780000  646748680  359730000   \n",
       "\n",
       "   종업원단기대여금     차량운반구          토지   퇴직급여충당부채     퇴직연금운용자산        투자자산  \\\n",
       "0  20000000  62173694  4165600000  279024714  (101125147)  1375399161   \n",
       "\n",
       "   현금및현금성자산  \n",
       "0  26566431  \n",
       "\n",
       "[1 rows x 64 columns]"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = json.loads(jsonString_7)\n",
    "json_normalize(data['재무상태표(대차대조표)'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>감가상각비</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",
       "      <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>36534690</td>\n",
       "      <td>32732729595</td>\n",
       "      <td>30839010989</td>\n",
       "      <td>-</td>\n",
       "      <td>563614950</td>\n",
       "      <td>4688</td>\n",
       "      <td>100000</td>\n",
       "      <td>22660000</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>...</td>\n",
       "      <td>2022957</td>\n",
       "      <td>9367630</td>\n",
       "      <td>2319073</td>\n",
       "      <td>25624460</td>\n",
       "      <td></td>\n",
       "      <td>87765861</td>\n",
       "      <td>38801669</td>\n",
       "      <td>8956164</td>\n",
       "      <td>44520602</td>\n",
       "      <td>1028455053</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 48 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      감가상각비         공사수익         공사원가 교육훈련비         급여 기본주당순이익     기부금  \\\n",
       "0  36534690  32732729595  30839010989     -  563614950    4688  100000   \n",
       "\n",
       "  기타비유동자산처분손실 단기투자자산처분손실 단기투자자산처분이익     ...          잡손실      잡이익      전력비  \\\n",
       "0    22660000          -          -     ...      2022957  9367630  2319073   \n",
       "\n",
       "        접대비 주당손익     지급수수료     차량유지비      통신비      퇴직급여     판매비와관리비  \n",
       "0  25624460       87765861  38801669  8956164  44520602  1028455053  \n",
       "\n",
       "[1 rows x 48 columns]"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "json_normalize(data['손익계산서'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>감가상각비</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",
       "      <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>38646198</td>\n",
       "      <td>29522820</td>\n",
       "      <td>-</td>\n",
       "      <td>26566431</td>\n",
       "      <td>445973226</td>\n",
       "      <td>22660000</td>\n",
       "      <td>-</td>\n",
       "      <td>103091770</td>\n",
       "      <td>-</td>\n",
       "      <td>(264181)</td>\n",
       "      <td>...</td>\n",
       "      <td>14836414</td>\n",
       "      <td>(131921738)</td>\n",
       "      <td>94046393</td>\n",
       "      <td>(32405655)</td>\n",
       "      <td>219209233</td>\n",
       "      <td>(513731257)</td>\n",
       "      <td>(294522024)</td>\n",
       "      <td>(16468617)</td>\n",
       "      <td>156600984</td>\n",
       "      <td>(419406795)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 66 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      감가상각비 공사선수금의증가감소 공사손실충당부채의증가감소     기말의현금      기초의현금 기타의비유동자산처분손실  \\\n",
       "0  38646198   29522820             -  26566431  445973226     22660000   \n",
       "\n",
       "  기타의유형자산의취득  단기금융상품의감소 단기금융상품의취득 단기이연법인세부채의증가감소     ...       차량운반구의취득  \\\n",
       "0          -  103091770         -       (264181)     ...       14836414   \n",
       "\n",
       "        퇴직금의지급      퇴직급여 퇴직연금운용자산의감소증가 투자활동으로인한현금유입액 투자활동으로인한현금유출액  \\\n",
       "0  (131921738)  94046393    (32405655)     219209233   (513731257)   \n",
       "\n",
       "  투자활동으로인한현금흐름 현금의유입이없는수익등의차감 현금의유출이없는비용등의가산      현금의증가감소  \n",
       "0  (294522024)     (16468617)      156600984  (419406795)  \n",
       "\n",
       "[1 rows x 66 columns]"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "json_normalize(data['현금흐름표'])"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}