stock_crawling.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "from bs4 import BeautifulSoup\n",
    "import re\n",
    "import csv\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib as mpl\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 주식 종목"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [],
   "source": [
    "code = {\"삼성전자\": [\"005930\",1],\n",
    "        \"LG\": [\"003550\",1],\n",
    "        \"SK하이닉스\": [\"000660\",1],\n",
    "        \"LG전자\": [\"066570\",1],\n",
    "        \"삼성전기\": [\"009150\",1],\n",
    "        \"LG이노텍\": [\"011070\",1],\n",
    "        \"삼성SDI\": [\"006400\",2],\n",
    "        \"LG디스플레이\": [\"034220\",2],\n",
    "        \"SK머티리얼즈\": [\"036490\",3],\n",
    "        \"SK이노베이션\": [\"096770\",4],\n",
    "        \"LG화학\": [\"051910\",4],\n",
    "        \"에코프로비엠\": [\"247540\",4],\n",
    "        \"Naver\": [\"035420\", 5],\n",
    "        \"카카오\": [\"035720\", 5],\n",
    "        \"이마트\": [\"139480\",6],\n",
    "        \"신세계\": [\"004170\", 6],\n",
    "        \"롯데푸드\": [\"002270\", 7],\n",
    "        \"신세계푸드\": [\"031440\", 7],\n",
    "        \"CJ제일제당\": [\"097950\",7],\n",
    "        \"효성\": [\"004800\",8],\n",
    "        \"효성티앤씨\": [\"298020\",8],\n",
    "        \"효성첨단소재\" : [\"298050\",8],\n",
    "        \"효성화학\": [\"298000\",8],\n",
    "        \"셀트리온\":[\"068270\",9],\n",
    "        \"셀트리온헬스케어\":[\"091990\",9],\n",
    "        \"셀트리온제약\":[\"068760\",9],\n",
    "        \"셀리버리\":[\"268600\",9],\n",
    "        \"SK바이오사이언스\":[\"302440\",9],\n",
    "        \"SK바이오팜\":[\"326030\",9],\n",
    "        \"삼성바이오로직스\":[\"207940\",9],\n",
    "        \"현대차\":[\"005380\",10],\n",
    "        \"현대모비스\":[\"012330\",10],\n",
    "        \"기아\":[\"000270\",10],\n",
    "        \"POSCO\":[\"005490\",11],\n",
    "        \"포스코강판\":[\"058430\",11],\n",
    "        \"포스코인터내셔널\":[\"047050\",11,\"A\"],\n",
    "        \"포스코케미칼\":[\"003670\",11],\n",
    "        \"포스코ICT\":[\"022100\",11],\n",
    "        \"삼성물산\":[\"028260\",1,\"A\"],\n",
    "        \"LX인터내서널\":[\"001120\",1,\"A\"],\n",
    "        }"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## url"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "metadata": {},
   "outputs": [],
   "source": [
    "urls = []\n",
    "for i in code.values():\n",
    "    urls.append(\"https://finance.naver.com/item/main.nhn?code=\" + i[0])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 웹 접속, soup객체 생성"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [],
   "source": [
    "soups = []\n",
    "for u in urls:\n",
    "    res = requests.get(u)\n",
    "    if res.status_code == 200:\n",
    "        soup = BeautifulSoup(res.text, \"lxml\")\n",
    "        soups.append(soup)\n",
    "    else:\n",
    "        print(\"error\",u[-6:])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 크롤링 - 현재가"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2021년 08월 02일 16시 11분'"
      ]
     },
     "execution_count": 87,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_code = []\n",
    "data_price = []\n",
    "for soup in soups:\n",
    "    data_rows = soup.find(\"div\", attrs={\"id\":\"wrap\"}).find(\"div\", attrs={\"class\":\"new_totalinfo\"}).find_all(\"dd\")\n",
    "    c = 0\n",
    "    data_category = []\n",
    "    for i in data_rows:\n",
    "        data_category.append(i.get_text())\n",
    "    data_code.append(data_category[1][4:])\n",
    "    data_price.append(data_category[3][3:11])\n",
    "time = data_category[0][:-7]\n",
    "time"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(40, 40, 40)"
      ]
     },
     "execution_count": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 주식종목과 크롤링 갯수 일치\n",
    "len(data_code), len(data_price), len(code)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 현재가 Data Frame "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "metadata": {},
   "outputs": [],
   "source": [
    "t = time.split(\" \")\n",
    "t = \"{}/{}/{}, {}:{}\".format(t[0][2:4],t[1][:-1],t[2][:-1],t[3][:-1],t[4])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_price_ = []\n",
    "for i in data_price:\n",
    "    i = i.replace(\"전\",\"\")\n",
    "    j = i.replace(\",\",\"\")\n",
    "    data_price_.append(j)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "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>현재가 (21/08/02, 16:11분)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>삼성전자</th>\n",
       "      <td>79300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LG</th>\n",
       "      <td>94800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SK하이닉스</th>\n",
       "      <td>116000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LG전자</th>\n",
       "      <td>156500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>삼성전기</th>\n",
       "      <td>190500</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       현재가 (21/08/02, 16:11분)\n",
       "삼성전자                   79300 \n",
       "LG                     94800 \n",
       "SK하이닉스                 116000\n",
       "LG전자                   156500\n",
       "삼성전기                   190500"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_summary = pd.DataFrame(data_price_, index=data_code)\n",
    "df_summary.astype('float')\n",
    "df_summary.columns = [\"현재가 (\"+t+\")\"]\n",
    "df_summary.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 크롤링 - 주식지표 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = []\n",
    "for soup in soups:\n",
    "    data_rows = soup.find(\"div\", attrs={\"id\":\"aside\"}).find_all(\"em\", {\"class\" : None})\n",
    "    for i in data_rows:\n",
    "        j = i.get_text().strip()\n",
    "        data.append(j)\n",
    "        \n",
    "#em, f_down down, f_up up"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 주식지표 데이터 정리 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 전체 주식지표 - 21개씩 38개 종목 \n",
    "data_value = []  \n",
    "for i in data:\n",
    "    j = re.sub('\\n+', '', i)\n",
    "    r = re.sub('\\t+', '', j)\n",
    "    data_value.append(r)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(840, 798)"
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(data_value), 21*38"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "473조4,038\n",
      "1\n",
      "101,810\n",
      "19.04\n",
      "4,165\n",
      "14.00\n",
      "5,847\n",
      "2.03\n",
      "39,126\n",
      "3.78\n"
     ]
    }
   ],
   "source": [
    "#10개만 추출\n",
    "#0- 시가총액, #1- 순위, #9- 목표주가, #12 - PER, #13 - EPS, #14 - 추정PER #15 - 추정EPS, #16 - PBR, #17 - BPS, #18 - 배당수익율\n",
    "nums = [0,1,9,12,13,14,15,16,17,18]\n",
    "#nums2 = [38,39,47,....]\n",
    "\n",
    "#삼성전자만 확인\n",
    "for i in nums:\n",
    "    print(data_value[i])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 38개 항목에 대해 경제지표 21개중 10개씩 파싱\n",
    "data_value_div = []\n",
    "for i in range(len(data_code)):\n",
    "    for j in nums:\n",
    "        data_value_div.append(data_value[i*21+j])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "400"
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(data_value_div)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['473조4038',\n",
       " '1',\n",
       " '101810',\n",
       " '19.04',\n",
       " '4165',\n",
       " '14.00',\n",
       " '5847',\n",
       " '2.03',\n",
       " '39126',\n",
       " '3.78',\n",
       " '14조9121',\n",
       " '28',\n",
       " '144200',\n",
       " '8.70',\n",
       " '10896',\n",
       " '7.00',\n",
       " '13350',\n",
       " '0.86',\n",
       " '110071',\n",
       " '2.64',\n",
       " '84조4483',\n",
       " '2',\n",
       " '159286',\n",
       " '16.57',\n",
       " '7002',\n",
       " '9.00',\n",
       " '13263',\n",
       " '1.52',\n",
       " '76542',\n",
       " '1.01',\n",
       " '25조6109',\n",
       " '15',\n",
       " '219412',\n",
       " '14.58',\n",
       " '10735',\n",
       " '12.00',\n",
       " '13472',\n",
       " '1.70',\n",
       " '91952',\n",
       " '0.77',\n",
       " '14조2291',\n",
       " '30',\n",
       " '250938',\n",
       " '20.96',\n",
       " '9087',\n",
       " '15.00',\n",
       " '12757',\n",
       " '2.40',\n",
       " '79474',\n",
       " '0.74',\n",
       " '5조3133',\n",
       " '65',\n",
       " '281421',\n",
       " '13.06',\n",
       " '17195',\n",
       " '7.00',\n",
       " '30239',\n",
       " '1.97',\n",
       " '113759',\n",
       " '0.31',\n",
       " '51조3671',\n",
       " '8',\n",
       " '968333',\n",
       " '73.17',\n",
       " '10209',\n",
       " '47.00',\n",
       " '15949',\n",
       " '3.77',\n",
       " '198153',\n",
       " '0.13',\n",
       " '7조8719',\n",
       " '47',\n",
       " '32063',\n",
       " '23.31',\n",
       " '944',\n",
       " '5.00',\n",
       " '4038',\n",
       " '0.67',\n",
       " '33039',\n",
       " '0',\n",
       " '4조3762',\n",
       " '6',\n",
       " '470833',\n",
       " '33.15',\n",
       " '12517',\n",
       " '22.00',\n",
       " '19166',\n",
       " '8.34',\n",
       " '49752',\n",
       " '0.96',\n",
       " '23조6712',\n",
       " '16',\n",
       " '360100',\n",
       " '0',\n",
       " '-10575',\n",
       " '23.00',\n",
       " '11368',\n",
       " '1.49',\n",
       " '172344',\n",
       " '0',\n",
       " '60조9918',\n",
       " '5',\n",
       " '1151118',\n",
       " '37.61',\n",
       " '22972',\n",
       " '16.00',\n",
       " '53841',\n",
       " '3.58',\n",
       " '241285',\n",
       " '1.16',\n",
       " '6조2799',\n",
       " '3',\n",
       " '298875',\n",
       " '114.19',\n",
       " '2509',\n",
       " '79.00',\n",
       " '3611',\n",
       " '13.39',\n",
       " '21399',\n",
       " '0.16',\n",
       " '71조2082',\n",
       " '3',\n",
       " '539130',\n",
       " '4.42',\n",
       " '98182',\n",
       " '4.00',\n",
       " '98390',\n",
       " '2.91',\n",
       " '149109',\n",
       " '0.09',\n",
       " '64조8912',\n",
       " '4',\n",
       " '155364',\n",
       " '212.52',\n",
       " '687',\n",
       " '81.00',\n",
       " '1795',\n",
       " '9.46',\n",
       " '15428',\n",
       " '0.02',\n",
       " '4조7807',\n",
       " '68',\n",
       " '217588',\n",
       " '11.83',\n",
       " '14500',\n",
       " '11.00',\n",
       " '15822',\n",
       " '0.51',\n",
       " '333019',\n",
       " '1.17',\n",
       " '2조6287',\n",
       " '130',\n",
       " '393050',\n",
       " '0',\n",
       " '-3247',\n",
       " '11.00',\n",
       " '25386',\n",
       " '0.74',\n",
       " '361115',\n",
       " '0.56',\n",
       " '5344',\n",
       " '342',\n",
       " '553333',\n",
       " '7.09',\n",
       " '62303',\n",
       " '13.00',\n",
       " '34165',\n",
       " '0.53',\n",
       " '832397',\n",
       " '2.71',\n",
       " '3795',\n",
       " '428',\n",
       " '133250',\n",
       " '0',\n",
       " '-3754',\n",
       " '22.00',\n",
       " '4405',\n",
       " '1.33',\n",
       " '73430',\n",
       " '0.76',\n",
       " '7조2034',\n",
       " '52',\n",
       " '616875',\n",
       " '19.25',\n",
       " '24858',\n",
       " '12.00',\n",
       " '39221',\n",
       " '1.38',\n",
       " '345805',\n",
       " '0.84',\n",
       " '2조4864',\n",
       " '135',\n",
       " '143333',\n",
       " '88.19',\n",
       " '1338',\n",
       " '7.00',\n",
       " '17544',\n",
       " '1.05',\n",
       " '112207',\n",
       " '4.24',\n",
       " '3조7478',\n",
       " '89',\n",
       " '1138556',\n",
       " '14.62',\n",
       " '59220',\n",
       " '5.00',\n",
       " '159169',\n",
       " '5.11',\n",
       " '169511',\n",
       " '0.58',\n",
       " '2조6342',\n",
       " '129',\n",
       " '845400',\n",
       " '72.57',\n",
       " '8102',\n",
       " '9.00',\n",
       " '62831',\n",
       " '7.09',\n",
       " '82951',\n",
       " '0',\n",
       " '1조1947',\n",
       " '205',\n",
       " '560000',\n",
       " '40.89',\n",
       " '9159',\n",
       " '7.00',\n",
       " '56568',\n",
       " '2.60',\n",
       " '144055',\n",
       " '0',\n",
       " '36조3410',\n",
       " '10',\n",
       " '373333',\n",
       " '60.45',\n",
       " '4359',\n",
       " '46.00',\n",
       " '5670',\n",
       " '10.24',\n",
       " '25720',\n",
       " '0',\n",
       " '17조4675',\n",
       " '1',\n",
       " '145556',\n",
       " '89.09',\n",
       " '1265',\n",
       " '54.00',\n",
       " '2096',\n",
       " '8.76',\n",
       " '12865',\n",
       " '0',\n",
       " '5조3248',\n",
       " '4',\n",
       " '0',\n",
       " '204.35',\n",
       " '713',\n",
       " '0',\n",
       " '0',\n",
       " '17.56',\n",
       " '8298',\n",
       " '0',\n",
       " '1조3768',\n",
       " '42',\n",
       " '0',\n",
       " '0',\n",
       " '-1104',\n",
       " '0',\n",
       " '0',\n",
       " '40.07',\n",
       " '2059',\n",
       " '0',\n",
       " '15조705',\n",
       " '27',\n",
       " '0',\n",
       " '153.07',\n",
       " '1287',\n",
       " '0',\n",
       " '0',\n",
       " '11.68',\n",
       " '16870',\n",
       " '0',\n",
       " '9조7108',\n",
       " '42',\n",
       " '140000',\n",
       " '0',\n",
       " '-689',\n",
       " '-357.00',\n",
       " '-347',\n",
       " '19.12',\n",
       " '6486',\n",
       " '0',\n",
       " '60조4086',\n",
       " '6',\n",
       " '1019231',\n",
       " '227.68',\n",
       " '4010',\n",
       " '169.00',\n",
       " '5403',\n",
       " '12.96',\n",
       " '70428',\n",
       " '0',\n",
       " '47조70',\n",
       " '9',\n",
       " '313864',\n",
       " '26.62',\n",
       " '8263',\n",
       " '10.00',\n",
       " '22290',\n",
       " '0.81',\n",
       " '271275',\n",
       " '1.36',\n",
       " '25조6889',\n",
       " '14',\n",
       " '382750',\n",
       " '14.46',\n",
       " '18739',\n",
       " '10.00',\n",
       " '28111',\n",
       " '0.75',\n",
       " '363505',\n",
       " '1.48',\n",
       " '34조3343',\n",
       " '11',\n",
       " '121591',\n",
       " '15.21',\n",
       " '5567',\n",
       " '7.00',\n",
       " '11660',\n",
       " '1.10',\n",
       " '76884',\n",
       " '1.18',\n",
       " '31조3873',\n",
       " '12',\n",
       " '471765',\n",
       " '14.07',\n",
       " '25594',\n",
       " '6.00',\n",
       " '60777',\n",
       " '0.60',\n",
       " '598503',\n",
       " '2.22',\n",
       " '4098',\n",
       " '403',\n",
       " '0',\n",
       " '26.22',\n",
       " '2605',\n",
       " '0',\n",
       " '0',\n",
       " '1.77',\n",
       " '38525',\n",
       " '0.73',\n",
       " '3조1522',\n",
       " '107',\n",
       " '29429',\n",
       " '12.19',\n",
       " '2096',\n",
       " '9.00',\n",
       " '2955',\n",
       " '0.99',\n",
       " '25723',\n",
       " '2.74',\n",
       " '11조9293',\n",
       " '33',\n",
       " '190357',\n",
       " '185.10',\n",
       " '832',\n",
       " '84.00',\n",
       " '1829',\n",
       " '5.20',\n",
       " '29588',\n",
       " '0.19',\n",
       " '1조2117',\n",
       " '51',\n",
       " '9800',\n",
       " '0',\n",
       " '-92',\n",
       " '-111.00',\n",
       " '-72',\n",
       " '3.51',\n",
       " '2273',\n",
       " '0.63',\n",
       " '26조8183',\n",
       " '13',\n",
       " '192778',\n",
       " '17.09',\n",
       " '8395',\n",
       " '15.00',\n",
       " '9349',\n",
       " '0.77',\n",
       " '187566',\n",
       " '1.60',\n",
       " '1조1415',\n",
       " '208',\n",
       " '41333',\n",
       " '11.21',\n",
       " '2626',\n",
       " '6.00',\n",
       " '5013',\n",
       " '0.75',\n",
       " '39451',\n",
       " '1.36']"
      ]
     },
     "execution_count": 98,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 데이터 변환시 용이하게 ,  N/A값 변환\n",
    "data_value_div_ = []\n",
    "for i in data_value_div:\n",
    "    j = i.replace(\",\",\"\")\n",
    "    k = j.replace(\"N/A\", \"0\")\n",
    "    data_value_div_.append(k)\n",
    "data_value_div_"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "40"
      ]
     },
     "execution_count": 99,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#각 항목별 리스트로 묶음, 2차원 리스트\n",
    "data_info = []\n",
    "for i in range(len(data_code)):\n",
    "    data_info.append(data_value_div_[0+(i*10):10+(i*10)])\n",
    "len(data_info)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['473조4038', '1', '101810', '19.04', '4165', '14.00', '5847', '2.03', '39126', '3.78']\n",
      "['14조9121', '28', '144200', '8.70', '10896', '7.00', '13350', '0.86', '110071', '2.64']\n",
      "['84조4483', '2', '159286', '16.57', '7002', '9.00', '13263', '1.52', '76542', '1.01']\n",
      "['25조6109', '15', '219412', '14.58', '10735', '12.00', '13472', '1.70', '91952', '0.77']\n",
      "['14조2291', '30', '250938', '20.96', '9087', '15.00', '12757', '2.40', '79474', '0.74']\n",
      "['5조3133', '65', '281421', '13.06', '17195', '7.00', '30239', '1.97', '113759', '0.31']\n",
      "['51조3671', '8', '968333', '73.17', '10209', '47.00', '15949', '3.77', '198153', '0.13']\n",
      "['7조8719', '47', '32063', '23.31', '944', '5.00', '4038', '0.67', '33039', '0']\n",
      "['4조3762', '6', '470833', '33.15', '12517', '22.00', '19166', '8.34', '49752', '0.96']\n",
      "['23조6712', '16', '360100', '0', '-10575', '23.00', '11368', '1.49', '172344', '0']\n",
      "['60조9918', '5', '1151118', '37.61', '22972', '16.00', '53841', '3.58', '241285', '1.16']\n",
      "['6조2799', '3', '298875', '114.19', '2509', '79.00', '3611', '13.39', '21399', '0.16']\n",
      "['71조2082', '3', '539130', '4.42', '98182', '4.00', '98390', '2.91', '149109', '0.09']\n",
      "['64조8912', '4', '155364', '212.52', '687', '81.00', '1795', '9.46', '15428', '0.02']\n",
      "['4조7807', '68', '217588', '11.83', '14500', '11.00', '15822', '0.51', '333019', '1.17']\n",
      "['2조6287', '130', '393050', '0', '-3247', '11.00', '25386', '0.74', '361115', '0.56']\n",
      "['5344', '342', '553333', '7.09', '62303', '13.00', '34165', '0.53', '832397', '2.71']\n",
      "['3795', '428', '133250', '0', '-3754', '22.00', '4405', '1.33', '73430', '0.76']\n",
      "['7조2034', '52', '616875', '19.25', '24858', '12.00', '39221', '1.38', '345805', '0.84']\n",
      "['2조4864', '135', '143333', '88.19', '1338', '7.00', '17544', '1.05', '112207', '4.24']\n",
      "['3조7478', '89', '1138556', '14.62', '59220', '5.00', '159169', '5.11', '169511', '0.58']\n",
      "['2조6342', '129', '845400', '72.57', '8102', '9.00', '62831', '7.09', '82951', '0']\n",
      "['1조1947', '205', '560000', '40.89', '9159', '7.00', '56568', '2.60', '144055', '0']\n",
      "['36조3410', '10', '373333', '60.45', '4359', '46.00', '5670', '10.24', '25720', '0']\n",
      "['17조4675', '1', '145556', '89.09', '1265', '54.00', '2096', '8.76', '12865', '0']\n",
      "['5조3248', '4', '0', '204.35', '713', '0', '0', '17.56', '8298', '0']\n",
      "['1조3768', '42', '0', '0', '-1104', '0', '0', '40.07', '2059', '0']\n",
      "['15조705', '27', '0', '153.07', '1287', '0', '0', '11.68', '16870', '0']\n",
      "['9조7108', '42', '140000', '0', '-689', '-357.00', '-347', '19.12', '6486', '0']\n",
      "['60조4086', '6', '1019231', '227.68', '4010', '169.00', '5403', '12.96', '70428', '0']\n",
      "['47조70', '9', '313864', '26.62', '8263', '10.00', '22290', '0.81', '271275', '1.36']\n",
      "['25조6889', '14', '382750', '14.46', '18739', '10.00', '28111', '0.75', '363505', '1.48']\n",
      "['34조3343', '11', '121591', '15.21', '5567', '7.00', '11660', '1.10', '76884', '1.18']\n",
      "['31조3873', '12', '471765', '14.07', '25594', '6.00', '60777', '0.60', '598503', '2.22']\n",
      "['4098', '403', '0', '26.22', '2605', '0', '0', '1.77', '38525', '0.73']\n",
      "['3조1522', '107', '29429', '12.19', '2096', '9.00', '2955', '0.99', '25723', '2.74']\n",
      "['11조9293', '33', '190357', '185.10', '832', '84.00', '1829', '5.20', '29588', '0.19']\n",
      "['1조2117', '51', '9800', '0', '-92', '-111.00', '-72', '3.51', '2273', '0.63']\n",
      "['26조8183', '13', '192778', '17.09', '8395', '15.00', '9349', '0.77', '187566', '1.60']\n",
      "['1조1415', '208', '41333', '11.21', '2626', '6.00', '5013', '0.75', '39451', '1.36']\n"
     ]
    }
   ],
   "source": [
    "for i in data_info:\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 주식지표 데이터 프레임"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "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>LG</th>\n",
       "      <th>SK하이닉스</th>\n",
       "      <th>LG전자</th>\n",
       "      <th>삼성전기</th>\n",
       "      <th>LG이노텍</th>\n",
       "      <th>삼성SDI</th>\n",
       "      <th>LG디스플레이</th>\n",
       "      <th>SK머티리얼즈</th>\n",
       "      <th>SK이노베이션</th>\n",
       "      <th>...</th>\n",
       "      <th>현대차</th>\n",
       "      <th>현대모비스</th>\n",
       "      <th>기아</th>\n",
       "      <th>POSCO</th>\n",
       "      <th>포스코강판</th>\n",
       "      <th>포스코인터내셔널</th>\n",
       "      <th>포스코케미칼</th>\n",
       "      <th>포스코 ICT</th>\n",
       "      <th>삼성물산</th>\n",
       "      <th>LX인터내셔널</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>시가총액</th>\n",
       "      <td>473조4038</td>\n",
       "      <td>14조9121</td>\n",
       "      <td>84조4483</td>\n",
       "      <td>25조6109</td>\n",
       "      <td>14조2291</td>\n",
       "      <td>5조3133</td>\n",
       "      <td>51조3671</td>\n",
       "      <td>7조8719</td>\n",
       "      <td>4조3762</td>\n",
       "      <td>23조6712</td>\n",
       "      <td>...</td>\n",
       "      <td>47조70</td>\n",
       "      <td>25조6889</td>\n",
       "      <td>34조3343</td>\n",
       "      <td>31조3873</td>\n",
       "      <td>4098</td>\n",
       "      <td>3조1522</td>\n",
       "      <td>11조9293</td>\n",
       "      <td>1조2117</td>\n",
       "      <td>26조8183</td>\n",
       "      <td>1조1415</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>시가총액순위</th>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>30</td>\n",
       "      <td>65</td>\n",
       "      <td>8</td>\n",
       "      <td>47</td>\n",
       "      <td>6</td>\n",
       "      <td>16</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>14</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "      <td>403</td>\n",
       "      <td>107</td>\n",
       "      <td>33</td>\n",
       "      <td>51</td>\n",
       "      <td>13</td>\n",
       "      <td>208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>목표가</th>\n",
       "      <td>101810</td>\n",
       "      <td>144200</td>\n",
       "      <td>159286</td>\n",
       "      <td>219412</td>\n",
       "      <td>250938</td>\n",
       "      <td>281421</td>\n",
       "      <td>968333</td>\n",
       "      <td>32063</td>\n",
       "      <td>470833</td>\n",
       "      <td>360100</td>\n",
       "      <td>...</td>\n",
       "      <td>313864</td>\n",
       "      <td>382750</td>\n",
       "      <td>121591</td>\n",
       "      <td>471765</td>\n",
       "      <td>0</td>\n",
       "      <td>29429</td>\n",
       "      <td>190357</td>\n",
       "      <td>9800</td>\n",
       "      <td>192778</td>\n",
       "      <td>41333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PER</th>\n",
       "      <td>19.04</td>\n",
       "      <td>8.70</td>\n",
       "      <td>16.57</td>\n",
       "      <td>14.58</td>\n",
       "      <td>20.96</td>\n",
       "      <td>13.06</td>\n",
       "      <td>73.17</td>\n",
       "      <td>23.31</td>\n",
       "      <td>33.15</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>26.62</td>\n",
       "      <td>14.46</td>\n",
       "      <td>15.21</td>\n",
       "      <td>14.07</td>\n",
       "      <td>26.22</td>\n",
       "      <td>12.19</td>\n",
       "      <td>185.10</td>\n",
       "      <td>0</td>\n",
       "      <td>17.09</td>\n",
       "      <td>11.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EPS</th>\n",
       "      <td>4165</td>\n",
       "      <td>10896</td>\n",
       "      <td>7002</td>\n",
       "      <td>10735</td>\n",
       "      <td>9087</td>\n",
       "      <td>17195</td>\n",
       "      <td>10209</td>\n",
       "      <td>944</td>\n",
       "      <td>12517</td>\n",
       "      <td>-10575</td>\n",
       "      <td>...</td>\n",
       "      <td>8263</td>\n",
       "      <td>18739</td>\n",
       "      <td>5567</td>\n",
       "      <td>25594</td>\n",
       "      <td>2605</td>\n",
       "      <td>2096</td>\n",
       "      <td>832</td>\n",
       "      <td>-92</td>\n",
       "      <td>8395</td>\n",
       "      <td>2626</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>추정PER</th>\n",
       "      <td>14.00</td>\n",
       "      <td>7.00</td>\n",
       "      <td>9.00</td>\n",
       "      <td>12.00</td>\n",
       "      <td>15.00</td>\n",
       "      <td>7.00</td>\n",
       "      <td>47.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>22.00</td>\n",
       "      <td>23.00</td>\n",
       "      <td>...</td>\n",
       "      <td>10.00</td>\n",
       "      <td>10.00</td>\n",
       "      <td>7.00</td>\n",
       "      <td>6.00</td>\n",
       "      <td>0</td>\n",
       "      <td>9.00</td>\n",
       "      <td>84.00</td>\n",
       "      <td>-111.00</td>\n",
       "      <td>15.00</td>\n",
       "      <td>6.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>추정EPS</th>\n",
       "      <td>5847</td>\n",
       "      <td>13350</td>\n",
       "      <td>13263</td>\n",
       "      <td>13472</td>\n",
       "      <td>12757</td>\n",
       "      <td>30239</td>\n",
       "      <td>15949</td>\n",
       "      <td>4038</td>\n",
       "      <td>19166</td>\n",
       "      <td>11368</td>\n",
       "      <td>...</td>\n",
       "      <td>22290</td>\n",
       "      <td>28111</td>\n",
       "      <td>11660</td>\n",
       "      <td>60777</td>\n",
       "      <td>0</td>\n",
       "      <td>2955</td>\n",
       "      <td>1829</td>\n",
       "      <td>-72</td>\n",
       "      <td>9349</td>\n",
       "      <td>5013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PBR</th>\n",
       "      <td>2.03</td>\n",
       "      <td>0.86</td>\n",
       "      <td>1.52</td>\n",
       "      <td>1.70</td>\n",
       "      <td>2.40</td>\n",
       "      <td>1.97</td>\n",
       "      <td>3.77</td>\n",
       "      <td>0.67</td>\n",
       "      <td>8.34</td>\n",
       "      <td>1.49</td>\n",
       "      <td>...</td>\n",
       "      <td>0.81</td>\n",
       "      <td>0.75</td>\n",
       "      <td>1.10</td>\n",
       "      <td>0.60</td>\n",
       "      <td>1.77</td>\n",
       "      <td>0.99</td>\n",
       "      <td>5.20</td>\n",
       "      <td>3.51</td>\n",
       "      <td>0.77</td>\n",
       "      <td>0.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BPS</th>\n",
       "      <td>39126</td>\n",
       "      <td>110071</td>\n",
       "      <td>76542</td>\n",
       "      <td>91952</td>\n",
       "      <td>79474</td>\n",
       "      <td>113759</td>\n",
       "      <td>198153</td>\n",
       "      <td>33039</td>\n",
       "      <td>49752</td>\n",
       "      <td>172344</td>\n",
       "      <td>...</td>\n",
       "      <td>271275</td>\n",
       "      <td>363505</td>\n",
       "      <td>76884</td>\n",
       "      <td>598503</td>\n",
       "      <td>38525</td>\n",
       "      <td>25723</td>\n",
       "      <td>29588</td>\n",
       "      <td>2273</td>\n",
       "      <td>187566</td>\n",
       "      <td>39451</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>배당수익율</th>\n",
       "      <td>3.78</td>\n",
       "      <td>2.64</td>\n",
       "      <td>1.01</td>\n",
       "      <td>0.77</td>\n",
       "      <td>0.74</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0</td>\n",
       "      <td>0.96</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.36</td>\n",
       "      <td>1.48</td>\n",
       "      <td>1.18</td>\n",
       "      <td>2.22</td>\n",
       "      <td>0.73</td>\n",
       "      <td>2.74</td>\n",
       "      <td>0.19</td>\n",
       "      <td>0.63</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>현재가21/08/02, 16:11분</th>\n",
       "      <td>79300</td>\n",
       "      <td>94800</td>\n",
       "      <td>116000</td>\n",
       "      <td>156500</td>\n",
       "      <td>190500</td>\n",
       "      <td>224500</td>\n",
       "      <td>747000</td>\n",
       "      <td>22000</td>\n",
       "      <td>414900</td>\n",
       "      <td>256000</td>\n",
       "      <td>...</td>\n",
       "      <td>220000</td>\n",
       "      <td>271000</td>\n",
       "      <td>84700</td>\n",
       "      <td>360000</td>\n",
       "      <td>68300</td>\n",
       "      <td>25550</td>\n",
       "      <td>154000</td>\n",
       "      <td>7970</td>\n",
       "      <td>143500</td>\n",
       "      <td>29450</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11 rows × 40 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         삼성전자       LG   SK하이닉스     LG전자     삼성전기    LG이노텍  \\\n",
       "시가총액                 473조4038  14조9121  84조4483  25조6109  14조2291   5조3133   \n",
       "시가총액순위                      1       28        2       15       30       65   \n",
       "목표가                    101810   144200   159286   219412   250938   281421   \n",
       "PER                     19.04     8.70    16.57    14.58    20.96    13.06   \n",
       "EPS                      4165    10896     7002    10735     9087    17195   \n",
       "추정PER                   14.00     7.00     9.00    12.00    15.00     7.00   \n",
       "추정EPS                    5847    13350    13263    13472    12757    30239   \n",
       "PBR                      2.03     0.86     1.52     1.70     2.40     1.97   \n",
       "BPS                     39126   110071    76542    91952    79474   113759   \n",
       "배당수익율                    3.78     2.64     1.01     0.77     0.74     0.31   \n",
       "현재가21/08/02, 16:11분    79300    94800    116000   156500   190500   224500   \n",
       "\n",
       "                       삼성SDI  LG디스플레이  SK머티리얼즈  SK이노베이션  ...      현대차  \\\n",
       "시가총액                 51조3671   7조8719   4조3762  23조6712  ...    47조70   \n",
       "시가총액순위                     8       47        6       16  ...        9   \n",
       "목표가                   968333    32063   470833   360100  ...   313864   \n",
       "PER                    73.17    23.31    33.15        0  ...    26.62   \n",
       "EPS                    10209      944    12517   -10575  ...     8263   \n",
       "추정PER                  47.00     5.00    22.00    23.00  ...    10.00   \n",
       "추정EPS                  15949     4038    19166    11368  ...    22290   \n",
       "PBR                     3.77     0.67     8.34     1.49  ...     0.81   \n",
       "BPS                   198153    33039    49752   172344  ...   271275   \n",
       "배당수익율                   0.13        0     0.96        0  ...     1.36   \n",
       "현재가21/08/02, 16:11분   747000   22000    414900   256000  ...   220000   \n",
       "\n",
       "                       현대모비스       기아    POSCO    포스코강판 포스코인터내셔널   포스코케미칼  \\\n",
       "시가총액                 25조6889  34조3343  31조3873     4098   3조1522  11조9293   \n",
       "시가총액순위                    14       11       12      403      107       33   \n",
       "목표가                   382750   121591   471765        0    29429   190357   \n",
       "PER                    14.46    15.21    14.07    26.22    12.19   185.10   \n",
       "EPS                    18739     5567    25594     2605     2096      832   \n",
       "추정PER                  10.00     7.00     6.00        0     9.00    84.00   \n",
       "추정EPS                  28111    11660    60777        0     2955     1829   \n",
       "PBR                     0.75     1.10     0.60     1.77     0.99     5.20   \n",
       "BPS                   363505    76884   598503    38525    25723    29588   \n",
       "배당수익율                   1.48     1.18     2.22     0.73     2.74     0.19   \n",
       "현재가21/08/02, 16:11분   271000   84700    360000   68300    25550    154000   \n",
       "\n",
       "                     포스코 ICT     삼성물산  LX인터내셔널  \n",
       "시가총액                  1조2117  26조8183   1조1415  \n",
       "시가총액순위                    51       13      208  \n",
       "목표가                     9800   192778    41333  \n",
       "PER                        0    17.09    11.21  \n",
       "EPS                      -92     8395     2626  \n",
       "추정PER                -111.00    15.00     6.00  \n",
       "추정EPS                    -72     9349     5013  \n",
       "PBR                     3.51     0.77     0.75  \n",
       "BPS                     2273   187566    39451  \n",
       "배당수익율                   0.63     1.60     1.36  \n",
       "현재가21/08/02, 16:11분    7970    143500   29450   \n",
       "\n",
       "[11 rows x 40 columns]"
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_dict = {}\n",
    "for i in range(len(data_code)):\n",
    "    data_dict[data_code[i]] = data_info[i] + [data_price_[i]]\n",
    "\n",
    "df = pd.DataFrame(data_dict, \n",
    "                  index=['시가총액','시가총액순위','목표가','PER', 'EPS', '추정PER', \n",
    "                         '추정EPS', 'PBR', 'BPS', '배당수익율','현재가'+t])\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"output.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "metadata": {},
   "outputs": [],
   "source": [
    "DF = df.transpose()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "21/08/02, 16:11분\n"
     ]
    }
   ],
   "source": [
    "print(t)\n",
    "DF[\"현재가\"+t] = DF[\"현재가\"+t].astype('int')\n",
    "DF[\"목표가\"] = DF[\"목표가\"].astype('int')\n",
    "DF[\"시가총액순위\"] = DF[\"시가총액순위\"].astype('int')\n",
    "DF[\"PER\"] = DF[\"PER\"].astype('float')\n",
    "DF[\"EPS\"] = DF[\"EPS\"].astype('float')\n",
    "DF[\"추정PER\"] = DF[\"추정PER\"].astype('float')\n",
    "DF[\"추정EPS\"] = DF[\"추정EPS\"].astype('float')\n",
    "DF[\"PBR\"] = DF[\"PBR\"].astype('float')\n",
    "DF[\"PBR\"] = DF[\"PBR\"].astype('float')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "metadata": {},
   "outputs": [],
   "source": [
    "DF[\"예상수익율\"] = round((DF[\"목표가\"]/DF[\"현재가\"+t] - 1) *100, 2)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 최종 DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "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>PER</th>\n",
       "      <th>EPS</th>\n",
       "      <th>추정PER</th>\n",
       "      <th>추정EPS</th>\n",
       "      <th>PBR</th>\n",
       "      <th>BPS</th>\n",
       "      <th>배당수익율</th>\n",
       "      <th>현재가21/08/02, 16:11분</th>\n",
       "      <th>예상수익율</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>삼성전자</th>\n",
       "      <td>473조4038</td>\n",
       "      <td>1</td>\n",
       "      <td>101810</td>\n",
       "      <td>19.04</td>\n",
       "      <td>4165.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>5847.0</td>\n",
       "      <td>2.03</td>\n",
       "      <td>39126</td>\n",
       "      <td>3.78</td>\n",
       "      <td>79300</td>\n",
       "      <td>28.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LG</th>\n",
       "      <td>14조9121</td>\n",
       "      <td>28</td>\n",
       "      <td>144200</td>\n",
       "      <td>8.70</td>\n",
       "      <td>10896.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>13350.0</td>\n",
       "      <td>0.86</td>\n",
       "      <td>110071</td>\n",
       "      <td>2.64</td>\n",
       "      <td>94800</td>\n",
       "      <td>52.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SK하이닉스</th>\n",
       "      <td>84조4483</td>\n",
       "      <td>2</td>\n",
       "      <td>159286</td>\n",
       "      <td>16.57</td>\n",
       "      <td>7002.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>13263.0</td>\n",
       "      <td>1.52</td>\n",
       "      <td>76542</td>\n",
       "      <td>1.01</td>\n",
       "      <td>116000</td>\n",
       "      <td>37.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LG전자</th>\n",
       "      <td>25조6109</td>\n",
       "      <td>15</td>\n",
       "      <td>219412</td>\n",
       "      <td>14.58</td>\n",
       "      <td>10735.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>13472.0</td>\n",
       "      <td>1.70</td>\n",
       "      <td>91952</td>\n",
       "      <td>0.77</td>\n",
       "      <td>156500</td>\n",
       "      <td>40.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>삼성전기</th>\n",
       "      <td>14조2291</td>\n",
       "      <td>30</td>\n",
       "      <td>250938</td>\n",
       "      <td>20.96</td>\n",
       "      <td>9087.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>12757.0</td>\n",
       "      <td>2.40</td>\n",
       "      <td>79474</td>\n",
       "      <td>0.74</td>\n",
       "      <td>190500</td>\n",
       "      <td>31.73</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            시가총액  시가총액순위     목표가    PER      EPS  추정PER    추정EPS   PBR  \\\n",
       "삼성전자    473조4038       1  101810  19.04   4165.0   14.0   5847.0  2.03   \n",
       "LG       14조9121      28  144200   8.70  10896.0    7.0  13350.0  0.86   \n",
       "SK하이닉스   84조4483       2  159286  16.57   7002.0    9.0  13263.0  1.52   \n",
       "LG전자     25조6109      15  219412  14.58  10735.0   12.0  13472.0  1.70   \n",
       "삼성전기     14조2291      30  250938  20.96   9087.0   15.0  12757.0  2.40   \n",
       "\n",
       "           BPS 배당수익율  현재가21/08/02, 16:11분  예상수익율  \n",
       "삼성전자     39126  3.78                79300  28.39  \n",
       "LG      110071  2.64                94800  52.11  \n",
       "SK하이닉스   76542  1.01               116000  37.32  \n",
       "LG전자     91952  0.77               156500  40.20  \n",
       "삼성전기     79474  0.74               190500  31.73  "
      ]
     },
     "execution_count": 106,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "DF.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['삼성전자', 'LG', 'SK하이닉스', 'LG전자', '삼성전기', 'LG이노텍', '삼성SDI', 'LG디스플레이',\n",
       "       'SK머티리얼즈', 'SK이노베이션', 'LG화학', '에코프로비엠', 'NAVER', '카카오', '이마트', '신세계',\n",
       "       '롯데푸드', '신세계푸드', 'CJ제일제당', '효성', '효성티앤씨', '효성첨단소재', '효성화학', '셀트리온',\n",
       "       '셀트리온헬스케어', '셀트리온제약', '셀리버리', 'SK바이오사이언스', 'SK바이오팜', '삼성바이오로직스', '현대차',\n",
       "       '현대모비스', '기아', 'POSCO', '포스코강판', '포스코인터내셔널', '포스코케미칼', '포스코 ICT',\n",
       "       '삼성물산', 'LX인터내셔널'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 107,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "DF.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['시가총액', '시가총액순위', '목표가', 'PER', 'EPS', '추정PER', '추정EPS', 'PBR', 'BPS',\n",
       "       '배당수익율', '현재가21/08/02, 16:11분', '예상수익율'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 108,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "DF.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 반도체/전자"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "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>PER</th>\n",
       "      <th>EPS</th>\n",
       "      <th>추정PER</th>\n",
       "      <th>추정EPS</th>\n",
       "      <th>PBR</th>\n",
       "      <th>BPS</th>\n",
       "      <th>배당수익율</th>\n",
       "      <th>현재가21/08/02, 16:11분</th>\n",
       "      <th>예상수익율</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>LG이노텍</th>\n",
       "      <td>5조3133</td>\n",
       "      <td>65</td>\n",
       "      <td>281421</td>\n",
       "      <td>13.06</td>\n",
       "      <td>17195.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>30239.0</td>\n",
       "      <td>1.97</td>\n",
       "      <td>113759</td>\n",
       "      <td>0.31</td>\n",
       "      <td>224500</td>\n",
       "      <td>25.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LG</th>\n",
       "      <td>14조9121</td>\n",
       "      <td>28</td>\n",
       "      <td>144200</td>\n",
       "      <td>8.70</td>\n",
       "      <td>10896.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>13350.0</td>\n",
       "      <td>0.86</td>\n",
       "      <td>110071</td>\n",
       "      <td>2.64</td>\n",
       "      <td>94800</td>\n",
       "      <td>52.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LG전자</th>\n",
       "      <td>25조6109</td>\n",
       "      <td>15</td>\n",
       "      <td>219412</td>\n",
       "      <td>14.58</td>\n",
       "      <td>10735.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>13472.0</td>\n",
       "      <td>1.70</td>\n",
       "      <td>91952</td>\n",
       "      <td>0.77</td>\n",
       "      <td>156500</td>\n",
       "      <td>40.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>삼성전기</th>\n",
       "      <td>14조2291</td>\n",
       "      <td>30</td>\n",
       "      <td>250938</td>\n",
       "      <td>20.96</td>\n",
       "      <td>9087.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>12757.0</td>\n",
       "      <td>2.40</td>\n",
       "      <td>79474</td>\n",
       "      <td>0.74</td>\n",
       "      <td>190500</td>\n",
       "      <td>31.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SK하이닉스</th>\n",
       "      <td>84조4483</td>\n",
       "      <td>2</td>\n",
       "      <td>159286</td>\n",
       "      <td>16.57</td>\n",
       "      <td>7002.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>13263.0</td>\n",
       "      <td>1.52</td>\n",
       "      <td>76542</td>\n",
       "      <td>1.01</td>\n",
       "      <td>116000</td>\n",
       "      <td>37.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>삼성전자</th>\n",
       "      <td>473조4038</td>\n",
       "      <td>1</td>\n",
       "      <td>101810</td>\n",
       "      <td>19.04</td>\n",
       "      <td>4165.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>5847.0</td>\n",
       "      <td>2.03</td>\n",
       "      <td>39126</td>\n",
       "      <td>3.78</td>\n",
       "      <td>79300</td>\n",
       "      <td>28.39</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            시가총액  시가총액순위     목표가    PER      EPS  추정PER    추정EPS   PBR  \\\n",
       "LG이노텍     5조3133      65  281421  13.06  17195.0    7.0  30239.0  1.97   \n",
       "LG       14조9121      28  144200   8.70  10896.0    7.0  13350.0  0.86   \n",
       "LG전자     25조6109      15  219412  14.58  10735.0   12.0  13472.0  1.70   \n",
       "삼성전기     14조2291      30  250938  20.96   9087.0   15.0  12757.0  2.40   \n",
       "SK하이닉스   84조4483       2  159286  16.57   7002.0    9.0  13263.0  1.52   \n",
       "삼성전자    473조4038       1  101810  19.04   4165.0   14.0   5847.0  2.03   \n",
       "\n",
       "           BPS 배당수익율  현재가21/08/02, 16:11분  예상수익율  \n",
       "LG이노텍   113759  0.31               224500  25.35  \n",
       "LG      110071  2.64                94800  52.11  \n",
       "LG전자     91952  0.77               156500  40.20  \n",
       "삼성전기     79474  0.74               190500  31.73  \n",
       "SK하이닉스   76542  1.01               116000  37.32  \n",
       "삼성전자     39126  3.78                79300  28.39  "
      ]
     },
     "execution_count": 109,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "semi_elec = DF.loc[['삼성전자', 'LG', 'SK하이닉스', 'LG전자', '삼성전기', 'LG이노텍']]\n",
    "semi_elec.sort_values(by=\"EPS\", ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 반도체/소자, 디스플레이"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "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>PER</th>\n",
       "      <th>EPS</th>\n",
       "      <th>추정PER</th>\n",
       "      <th>추정EPS</th>\n",
       "      <th>PBR</th>\n",
       "      <th>BPS</th>\n",
       "      <th>배당수익율</th>\n",
       "      <th>현재가21/08/02, 16:11분</th>\n",
       "      <th>예상수익율</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>SK머티리얼즈</th>\n",
       "      <td>4조3762</td>\n",
       "      <td>6</td>\n",
       "      <td>470833</td>\n",
       "      <td>33.15</td>\n",
       "      <td>12517.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>19166.0</td>\n",
       "      <td>8.34</td>\n",
       "      <td>49752</td>\n",
       "      <td>0.96</td>\n",
       "      <td>414900</td>\n",
       "      <td>13.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>삼성SDI</th>\n",
       "      <td>51조3671</td>\n",
       "      <td>8</td>\n",
       "      <td>968333</td>\n",
       "      <td>73.17</td>\n",
       "      <td>10209.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>15949.0</td>\n",
       "      <td>3.77</td>\n",
       "      <td>198153</td>\n",
       "      <td>0.13</td>\n",
       "      <td>747000</td>\n",
       "      <td>29.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LG디스플레이</th>\n",
       "      <td>7조8719</td>\n",
       "      <td>47</td>\n",
       "      <td>32063</td>\n",
       "      <td>23.31</td>\n",
       "      <td>944.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4038.0</td>\n",
       "      <td>0.67</td>\n",
       "      <td>33039</td>\n",
       "      <td>0</td>\n",
       "      <td>22000</td>\n",
       "      <td>45.74</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            시가총액  시가총액순위     목표가    PER      EPS  추정PER    추정EPS   PBR  \\\n",
       "SK머티리얼즈   4조3762       6  470833  33.15  12517.0   22.0  19166.0  8.34   \n",
       "삼성SDI    51조3671       8  968333  73.17  10209.0   47.0  15949.0  3.77   \n",
       "LG디스플레이   7조8719      47   32063  23.31    944.0    5.0   4038.0  0.67   \n",
       "\n",
       "            BPS 배당수익율  현재가21/08/02, 16:11분  예상수익율  \n",
       "SK머티리얼즈   49752  0.96               414900  13.48  \n",
       "삼성SDI    198153  0.13               747000  29.63  \n",
       "LG디스플레이   33039     0                22000  45.74  "
      ]
     },
     "execution_count": 110,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "semi_material = DF.loc[['삼성SDI', 'LG디스플레이', 'SK머티리얼즈']]\n",
    "semi_material.sort_values(by=\"EPS\", ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 2차전지(전기차배터리), 화학"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "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>PER</th>\n",
       "      <th>EPS</th>\n",
       "      <th>추정PER</th>\n",
       "      <th>추정EPS</th>\n",
       "      <th>PBR</th>\n",
       "      <th>BPS</th>\n",
       "      <th>배당수익율</th>\n",
       "      <th>현재가21/08/02, 16:11분</th>\n",
       "      <th>예상수익율</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>LG화학</th>\n",
       "      <td>60조9918</td>\n",
       "      <td>5</td>\n",
       "      <td>1151118</td>\n",
       "      <td>37.61</td>\n",
       "      <td>22972.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>53841.0</td>\n",
       "      <td>3.58</td>\n",
       "      <td>241285</td>\n",
       "      <td>1.16</td>\n",
       "      <td>864000</td>\n",
       "      <td>33.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>에코프로비엠</th>\n",
       "      <td>6조2799</td>\n",
       "      <td>3</td>\n",
       "      <td>298875</td>\n",
       "      <td>114.19</td>\n",
       "      <td>2509.0</td>\n",
       "      <td>79.0</td>\n",
       "      <td>3611.0</td>\n",
       "      <td>13.39</td>\n",
       "      <td>21399</td>\n",
       "      <td>0.16</td>\n",
       "      <td>286500</td>\n",
       "      <td>4.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>포스코케미칼</th>\n",
       "      <td>11조9293</td>\n",
       "      <td>33</td>\n",
       "      <td>190357</td>\n",
       "      <td>185.10</td>\n",
       "      <td>832.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>1829.0</td>\n",
       "      <td>5.20</td>\n",
       "      <td>29588</td>\n",
       "      <td>0.19</td>\n",
       "      <td>154000</td>\n",
       "      <td>23.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SK이노베이션</th>\n",
       "      <td>23조6712</td>\n",
       "      <td>16</td>\n",
       "      <td>360100</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-10575.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>11368.0</td>\n",
       "      <td>1.49</td>\n",
       "      <td>172344</td>\n",
       "      <td>0</td>\n",
       "      <td>256000</td>\n",
       "      <td>40.66</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            시가총액  시가총액순위      목표가     PER      EPS  추정PER    추정EPS    PBR  \\\n",
       "LG화학     60조9918       5  1151118   37.61  22972.0   16.0  53841.0   3.58   \n",
       "에코프로비엠    6조2799       3   298875  114.19   2509.0   79.0   3611.0  13.39   \n",
       "포스코케미칼   11조9293      33   190357  185.10    832.0   84.0   1829.0   5.20   \n",
       "SK이노베이션  23조6712      16   360100    0.00 -10575.0   23.0  11368.0   1.49   \n",
       "\n",
       "            BPS 배당수익율  현재가21/08/02, 16:11분  예상수익율  \n",
       "LG화학     241285  1.16               864000  33.23  \n",
       "에코프로비엠    21399  0.16               286500   4.32  \n",
       "포스코케미칼    29588  0.19               154000  23.61  \n",
       "SK이노베이션  172344     0               256000  40.66  "
      ]
     },
     "execution_count": 111,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "semi_material = DF.loc[['SK이노베이션', 'LG화학', '에코프로비엠','포스코케미칼']]\n",
    "semi_material.sort_values(by=\"EPS\", ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## IT/Platform"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "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>PER</th>\n",
       "      <th>EPS</th>\n",
       "      <th>추정PER</th>\n",
       "      <th>추정EPS</th>\n",
       "      <th>PBR</th>\n",
       "      <th>BPS</th>\n",
       "      <th>배당수익율</th>\n",
       "      <th>현재가21/08/02, 16:11분</th>\n",
       "      <th>예상수익율</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>NAVER</th>\n",
       "      <td>71조2082</td>\n",
       "      <td>3</td>\n",
       "      <td>539130</td>\n",
       "      <td>4.42</td>\n",
       "      <td>98182.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>98390.0</td>\n",
       "      <td>2.91</td>\n",
       "      <td>149109</td>\n",
       "      <td>0.09</td>\n",
       "      <td>433500</td>\n",
       "      <td>24.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>카카오</th>\n",
       "      <td>64조8912</td>\n",
       "      <td>4</td>\n",
       "      <td>155364</td>\n",
       "      <td>212.52</td>\n",
       "      <td>687.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>1795.0</td>\n",
       "      <td>9.46</td>\n",
       "      <td>15428</td>\n",
       "      <td>0.02</td>\n",
       "      <td>146000</td>\n",
       "      <td>6.41</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          시가총액  시가총액순위     목표가     PER      EPS  추정PER    추정EPS   PBR     BPS  \\\n",
       "NAVER  71조2082       3  539130    4.42  98182.0    4.0  98390.0  2.91  149109   \n",
       "카카오    64조8912       4  155364  212.52    687.0   81.0   1795.0  9.46   15428   \n",
       "\n",
       "      배당수익율  현재가21/08/02, 16:11분  예상수익율  \n",
       "NAVER  0.09               433500  24.37  \n",
       "카카오    0.02               146000   6.41  "
      ]
     },
     "execution_count": 112,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "semi_material = DF.loc[['NAVER', '카카오']]\n",
    "semi_material.sort_values(by=\"EPS\", ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 마트/식품"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "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>PER</th>\n",
       "      <th>EPS</th>\n",
       "      <th>추정PER</th>\n",
       "      <th>추정EPS</th>\n",
       "      <th>PBR</th>\n",
       "      <th>BPS</th>\n",
       "      <th>배당수익율</th>\n",
       "      <th>현재가21/08/02, 16:11분</th>\n",
       "      <th>예상수익율</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>롯데푸드</th>\n",
       "      <td>5344</td>\n",
       "      <td>342</td>\n",
       "      <td>553333</td>\n",
       "      <td>7.09</td>\n",
       "      <td>62303.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>34165.0</td>\n",
       "      <td>0.53</td>\n",
       "      <td>832397</td>\n",
       "      <td>2.71</td>\n",
       "      <td>442000</td>\n",
       "      <td>25.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CJ제일제당</th>\n",
       "      <td>7조2034</td>\n",
       "      <td>52</td>\n",
       "      <td>616875</td>\n",
       "      <td>19.25</td>\n",
       "      <td>24858.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>39221.0</td>\n",
       "      <td>1.38</td>\n",
       "      <td>345805</td>\n",
       "      <td>0.84</td>\n",
       "      <td>478500</td>\n",
       "      <td>28.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>이마트</th>\n",
       "      <td>4조7807</td>\n",
       "      <td>68</td>\n",
       "      <td>217588</td>\n",
       "      <td>11.83</td>\n",
       "      <td>14500.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>15822.0</td>\n",
       "      <td>0.51</td>\n",
       "      <td>333019</td>\n",
       "      <td>1.17</td>\n",
       "      <td>171500</td>\n",
       "      <td>26.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>신세계</th>\n",
       "      <td>2조6287</td>\n",
       "      <td>130</td>\n",
       "      <td>393050</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-3247.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>25386.0</td>\n",
       "      <td>0.74</td>\n",
       "      <td>361115</td>\n",
       "      <td>0.56</td>\n",
       "      <td>267000</td>\n",
       "      <td>47.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>신세계푸드</th>\n",
       "      <td>3795</td>\n",
       "      <td>428</td>\n",
       "      <td>133250</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-3754.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>4405.0</td>\n",
       "      <td>1.33</td>\n",
       "      <td>73430</td>\n",
       "      <td>0.76</td>\n",
       "      <td>98000</td>\n",
       "      <td>35.97</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          시가총액  시가총액순위     목표가    PER      EPS  추정PER    추정EPS   PBR     BPS  \\\n",
       "롯데푸드      5344     342  553333   7.09  62303.0   13.0  34165.0  0.53  832397   \n",
       "CJ제일제당  7조2034      52  616875  19.25  24858.0   12.0  39221.0  1.38  345805   \n",
       "이마트     4조7807      68  217588  11.83  14500.0   11.0  15822.0  0.51  333019   \n",
       "신세계     2조6287     130  393050   0.00  -3247.0   11.0  25386.0  0.74  361115   \n",
       "신세계푸드     3795     428  133250   0.00  -3754.0   22.0   4405.0  1.33   73430   \n",
       "\n",
       "       배당수익율  현재가21/08/02, 16:11분  예상수익율  \n",
       "롯데푸드    2.71               442000  25.19  \n",
       "CJ제일제당  0.84               478500  28.92  \n",
       "이마트     1.17               171500  26.87  \n",
       "신세계     0.56               267000  47.21  \n",
       "신세계푸드   0.76                98000  35.97  "
      ]
     },
     "execution_count": 113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mart_food = DF.loc[['이마트', '신세계', '롯데푸드', '신세계푸드', 'CJ제일제당']]\n",
    "mart_food.sort_values(by=\"EPS\", ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 효성"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "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>PER</th>\n",
       "      <th>EPS</th>\n",
       "      <th>추정PER</th>\n",
       "      <th>추정EPS</th>\n",
       "      <th>PBR</th>\n",
       "      <th>BPS</th>\n",
       "      <th>배당수익율</th>\n",
       "      <th>현재가21/08/02, 16:11분</th>\n",
       "      <th>예상수익율</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>효성티앤씨</th>\n",
       "      <td>3조7478</td>\n",
       "      <td>89</td>\n",
       "      <td>1138556</td>\n",
       "      <td>14.62</td>\n",
       "      <td>59220.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>159169.0</td>\n",
       "      <td>5.11</td>\n",
       "      <td>169511</td>\n",
       "      <td>0.58</td>\n",
       "      <td>866000</td>\n",
       "      <td>31.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>효성화학</th>\n",
       "      <td>1조1947</td>\n",
       "      <td>205</td>\n",
       "      <td>560000</td>\n",
       "      <td>40.89</td>\n",
       "      <td>9159.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>56568.0</td>\n",
       "      <td>2.60</td>\n",
       "      <td>144055</td>\n",
       "      <td>0</td>\n",
       "      <td>374500</td>\n",
       "      <td>49.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>효성첨단소재</th>\n",
       "      <td>2조6342</td>\n",
       "      <td>129</td>\n",
       "      <td>845400</td>\n",
       "      <td>72.57</td>\n",
       "      <td>8102.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>62831.0</td>\n",
       "      <td>7.09</td>\n",
       "      <td>82951</td>\n",
       "      <td>0</td>\n",
       "      <td>588000</td>\n",
       "      <td>43.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>효성</th>\n",
       "      <td>2조4864</td>\n",
       "      <td>135</td>\n",
       "      <td>143333</td>\n",
       "      <td>88.19</td>\n",
       "      <td>1338.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>17544.0</td>\n",
       "      <td>1.05</td>\n",
       "      <td>112207</td>\n",
       "      <td>4.24</td>\n",
       "      <td>118000</td>\n",
       "      <td>21.47</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          시가총액  시가총액순위      목표가    PER      EPS  추정PER     추정EPS   PBR  \\\n",
       "효성티앤씨   3조7478      89  1138556  14.62  59220.0    5.0  159169.0  5.11   \n",
       "효성화학    1조1947     205   560000  40.89   9159.0    7.0   56568.0  2.60   \n",
       "효성첨단소재  2조6342     129   845400  72.57   8102.0    9.0   62831.0  7.09   \n",
       "효성      2조4864     135   143333  88.19   1338.0    7.0   17544.0  1.05   \n",
       "\n",
       "           BPS 배당수익율  현재가21/08/02, 16:11분  예상수익율  \n",
       "효성티앤씨   169511  0.58               866000  31.47  \n",
       "효성화학    144055     0               374500  49.53  \n",
       "효성첨단소재   82951     0               588000  43.78  \n",
       "효성      112207  4.24               118000  21.47  "
      ]
     },
     "execution_count": 114,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hyo = DF.loc[['효성', '효성티앤씨', '효성첨단소재', '효성화학']]\n",
    "hyo.sort_values(by=\"EPS\", ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 제약회사"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "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>PER</th>\n",
       "      <th>EPS</th>\n",
       "      <th>추정PER</th>\n",
       "      <th>추정EPS</th>\n",
       "      <th>PBR</th>\n",
       "      <th>BPS</th>\n",
       "      <th>배당수익율</th>\n",
       "      <th>현재가21/08/02, 16:11분</th>\n",
       "      <th>예상수익율</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>셀트리온</th>\n",
       "      <td>36조3410</td>\n",
       "      <td>10</td>\n",
       "      <td>373333</td>\n",
       "      <td>60.45</td>\n",
       "      <td>4359.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>5670.0</td>\n",
       "      <td>10.24</td>\n",
       "      <td>25720</td>\n",
       "      <td>0</td>\n",
       "      <td>263500</td>\n",
       "      <td>41.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>삼성바이오로직스</th>\n",
       "      <td>60조4086</td>\n",
       "      <td>6</td>\n",
       "      <td>1019231</td>\n",
       "      <td>227.68</td>\n",
       "      <td>4010.0</td>\n",
       "      <td>169.0</td>\n",
       "      <td>5403.0</td>\n",
       "      <td>12.96</td>\n",
       "      <td>70428</td>\n",
       "      <td>0</td>\n",
       "      <td>913000</td>\n",
       "      <td>11.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SK바이오사이언스</th>\n",
       "      <td>15조705</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>153.07</td>\n",
       "      <td>1287.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.68</td>\n",
       "      <td>16870</td>\n",
       "      <td>0</td>\n",
       "      <td>197000</td>\n",
       "      <td>-100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>셀트리온헬스케어</th>\n",
       "      <td>17조4675</td>\n",
       "      <td>1</td>\n",
       "      <td>145556</td>\n",
       "      <td>89.09</td>\n",
       "      <td>1265.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>2096.0</td>\n",
       "      <td>8.76</td>\n",
       "      <td>12865</td>\n",
       "      <td>0</td>\n",
       "      <td>112700</td>\n",
       "      <td>29.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>셀트리온제약</th>\n",
       "      <td>5조3248</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>204.35</td>\n",
       "      <td>713.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.56</td>\n",
       "      <td>8298</td>\n",
       "      <td>0</td>\n",
       "      <td>145700</td>\n",
       "      <td>-100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SK바이오팜</th>\n",
       "      <td>9조7108</td>\n",
       "      <td>42</td>\n",
       "      <td>140000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-689.0</td>\n",
       "      <td>-357.0</td>\n",
       "      <td>-347.0</td>\n",
       "      <td>19.12</td>\n",
       "      <td>6486</td>\n",
       "      <td>0</td>\n",
       "      <td>124000</td>\n",
       "      <td>12.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>셀리버리</th>\n",
       "      <td>1조3768</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-1104.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>40.07</td>\n",
       "      <td>2059</td>\n",
       "      <td>0</td>\n",
       "      <td>82500</td>\n",
       "      <td>-100.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              시가총액  시가총액순위      목표가     PER     EPS  추정PER   추정EPS    PBR  \\\n",
       "셀트리온       36조3410      10   373333   60.45  4359.0   46.0  5670.0  10.24   \n",
       "삼성바이오로직스   60조4086       6  1019231  227.68  4010.0  169.0  5403.0  12.96   \n",
       "SK바이오사이언스   15조705      27        0  153.07  1287.0    0.0     0.0  11.68   \n",
       "셀트리온헬스케어   17조4675       1   145556   89.09  1265.0   54.0  2096.0   8.76   \n",
       "셀트리온제약      5조3248       4        0  204.35   713.0    0.0     0.0  17.56   \n",
       "SK바이오팜      9조7108      42   140000    0.00  -689.0 -357.0  -347.0  19.12   \n",
       "셀리버리        1조3768      42        0    0.00 -1104.0    0.0     0.0  40.07   \n",
       "\n",
       "             BPS 배당수익율  현재가21/08/02, 16:11분   예상수익율  \n",
       "셀트리온       25720     0               263500   41.68  \n",
       "삼성바이오로직스   70428     0               913000   11.64  \n",
       "SK바이오사이언스  16870     0               197000 -100.00  \n",
       "셀트리온헬스케어   12865     0               112700   29.15  \n",
       "셀트리온제약      8298     0               145700 -100.00  \n",
       "SK바이오팜      6486     0               124000   12.90  \n",
       "셀리버리        2059     0                82500 -100.00  "
      ]
     },
     "execution_count": 116,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pharm = DF.loc[['셀트리온','셀트리온헬스케어', '셀트리온제약', '셀리버리', 'SK바이오사이언스', 'SK바이오팜', '삼성바이오로직스']]\n",
    "pharm.sort_values(by=\"EPS\", ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 자동차"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "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>PER</th>\n",
       "      <th>EPS</th>\n",
       "      <th>추정PER</th>\n",
       "      <th>추정EPS</th>\n",
       "      <th>PBR</th>\n",
       "      <th>BPS</th>\n",
       "      <th>배당수익율</th>\n",
       "      <th>현재가21/08/02, 16:11분</th>\n",
       "      <th>예상수익율</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>현대모비스</th>\n",
       "      <td>25조6889</td>\n",
       "      <td>14</td>\n",
       "      <td>382750</td>\n",
       "      <td>14.46</td>\n",
       "      <td>18739.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>28111.0</td>\n",
       "      <td>0.75</td>\n",
       "      <td>363505</td>\n",
       "      <td>1.48</td>\n",
       "      <td>271000</td>\n",
       "      <td>41.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>현대차</th>\n",
       "      <td>47조70</td>\n",
       "      <td>9</td>\n",
       "      <td>313864</td>\n",
       "      <td>26.62</td>\n",
       "      <td>8263.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>22290.0</td>\n",
       "      <td>0.81</td>\n",
       "      <td>271275</td>\n",
       "      <td>1.36</td>\n",
       "      <td>220000</td>\n",
       "      <td>42.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>기아</th>\n",
       "      <td>34조3343</td>\n",
       "      <td>11</td>\n",
       "      <td>121591</td>\n",
       "      <td>15.21</td>\n",
       "      <td>5567.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>11660.0</td>\n",
       "      <td>1.10</td>\n",
       "      <td>76884</td>\n",
       "      <td>1.18</td>\n",
       "      <td>84700</td>\n",
       "      <td>43.55</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          시가총액  시가총액순위     목표가    PER      EPS  추정PER    추정EPS   PBR     BPS  \\\n",
       "현대모비스  25조6889      14  382750  14.46  18739.0   10.0  28111.0  0.75  363505   \n",
       "현대차      47조70       9  313864  26.62   8263.0   10.0  22290.0  0.81  271275   \n",
       "기아     34조3343      11  121591  15.21   5567.0    7.0  11660.0  1.10   76884   \n",
       "\n",
       "      배당수익율  현재가21/08/02, 16:11분  예상수익율  \n",
       "현대모비스  1.48               271000  41.24  \n",
       "현대차    1.36               220000  42.67  \n",
       "기아     1.18                84700  43.55  "
      ]
     },
     "execution_count": 117,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "automotive = DF.loc[['현대차', '현대모비스', '기아']]\n",
    "automotive.sort_values(by=\"EPS\", ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 포스코"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "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>PER</th>\n",
       "      <th>EPS</th>\n",
       "      <th>추정PER</th>\n",
       "      <th>추정EPS</th>\n",
       "      <th>PBR</th>\n",
       "      <th>BPS</th>\n",
       "      <th>배당수익율</th>\n",
       "      <th>현재가21/08/02, 16:11분</th>\n",
       "      <th>예상수익율</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>POSCO</th>\n",
       "      <td>31조3873</td>\n",
       "      <td>12</td>\n",
       "      <td>471765</td>\n",
       "      <td>14.07</td>\n",
       "      <td>25594.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>60777.0</td>\n",
       "      <td>0.60</td>\n",
       "      <td>598503</td>\n",
       "      <td>2.22</td>\n",
       "      <td>360000</td>\n",
       "      <td>31.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>포스코강판</th>\n",
       "      <td>4098</td>\n",
       "      <td>403</td>\n",
       "      <td>0</td>\n",
       "      <td>26.22</td>\n",
       "      <td>2605.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.77</td>\n",
       "      <td>38525</td>\n",
       "      <td>0.73</td>\n",
       "      <td>68300</td>\n",
       "      <td>-100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>포스코인터내셔널</th>\n",
       "      <td>3조1522</td>\n",
       "      <td>107</td>\n",
       "      <td>29429</td>\n",
       "      <td>12.19</td>\n",
       "      <td>2096.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2955.0</td>\n",
       "      <td>0.99</td>\n",
       "      <td>25723</td>\n",
       "      <td>2.74</td>\n",
       "      <td>25550</td>\n",
       "      <td>15.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>포스코케미칼</th>\n",
       "      <td>11조9293</td>\n",
       "      <td>33</td>\n",
       "      <td>190357</td>\n",
       "      <td>185.10</td>\n",
       "      <td>832.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>1829.0</td>\n",
       "      <td>5.20</td>\n",
       "      <td>29588</td>\n",
       "      <td>0.19</td>\n",
       "      <td>154000</td>\n",
       "      <td>23.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>포스코 ICT</th>\n",
       "      <td>1조2117</td>\n",
       "      <td>51</td>\n",
       "      <td>9800</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-92.0</td>\n",
       "      <td>-111.0</td>\n",
       "      <td>-72.0</td>\n",
       "      <td>3.51</td>\n",
       "      <td>2273</td>\n",
       "      <td>0.63</td>\n",
       "      <td>7970</td>\n",
       "      <td>22.96</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             시가총액  시가총액순위     목표가     PER      EPS  추정PER    추정EPS   PBR  \\\n",
       "POSCO     31조3873      12  471765   14.07  25594.0    6.0  60777.0  0.60   \n",
       "포스코강판        4098     403       0   26.22   2605.0    0.0      0.0  1.77   \n",
       "포스코인터내셔널   3조1522     107   29429   12.19   2096.0    9.0   2955.0  0.99   \n",
       "포스코케미칼    11조9293      33  190357  185.10    832.0   84.0   1829.0  5.20   \n",
       "포스코 ICT    1조2117      51    9800    0.00    -92.0 -111.0    -72.0  3.51   \n",
       "\n",
       "             BPS 배당수익율  현재가21/08/02, 16:11분   예상수익율  \n",
       "POSCO     598503  2.22               360000   31.05  \n",
       "포스코강판      38525  0.73                68300 -100.00  \n",
       "포스코인터내셔널   25723  2.74                25550   15.18  \n",
       "포스코케미칼     29588  0.19               154000   23.61  \n",
       "포스코 ICT     2273  0.63                 7970   22.96  "
      ]
     },
     "execution_count": 118,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "posco = DF.loc[['POSCO', '포스코강판', '포스코인터내셔널', '포스코케미칼', '포스코 ICT',]]\n",
    "posco.sort_values(by=\"EPS\", ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 물류"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "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>PER</th>\n",
       "      <th>EPS</th>\n",
       "      <th>추정PER</th>\n",
       "      <th>추정EPS</th>\n",
       "      <th>PBR</th>\n",
       "      <th>BPS</th>\n",
       "      <th>배당수익율</th>\n",
       "      <th>현재가21/08/02, 16:11분</th>\n",
       "      <th>예상수익율</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>삼성물산</th>\n",
       "      <td>26조8183</td>\n",
       "      <td>13</td>\n",
       "      <td>192778</td>\n",
       "      <td>17.09</td>\n",
       "      <td>8395.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>9349.0</td>\n",
       "      <td>0.77</td>\n",
       "      <td>187566</td>\n",
       "      <td>1.60</td>\n",
       "      <td>143500</td>\n",
       "      <td>34.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LX인터내셔널</th>\n",
       "      <td>1조1415</td>\n",
       "      <td>208</td>\n",
       "      <td>41333</td>\n",
       "      <td>11.21</td>\n",
       "      <td>2626.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5013.0</td>\n",
       "      <td>0.75</td>\n",
       "      <td>39451</td>\n",
       "      <td>1.36</td>\n",
       "      <td>29450</td>\n",
       "      <td>40.35</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            시가총액  시가총액순위     목표가    PER     EPS  추정PER   추정EPS   PBR     BPS  \\\n",
       "삼성물산     26조8183      13  192778  17.09  8395.0   15.0  9349.0  0.77  187566   \n",
       "LX인터내셔널   1조1415     208   41333  11.21  2626.0    6.0  5013.0  0.75   39451   \n",
       "\n",
       "        배당수익율  현재가21/08/02, 16:11분  예상수익율  \n",
       "삼성물산     1.60               143500  34.34  \n",
       "LX인터내셔널  1.36                29450  40.35  "
      ]
     },
     "execution_count": 119,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "international = DF.loc[[ '삼성물산', 'LX인터내셔널']]\n",
    "international.sort_values(by=\"EPS\", ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "DF.to_csv(\"stock.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame({'grp': [\"a\", \"a\", \"a\", \"a\", \"a\", \"b\", \"b\", \"b\", \"b\", \"b\"], \n",
    "                   'val': np.random.uniform(0, 10, 10)})\n",
    "\n",
    "df_sort_group_top3 = df.sort_values(by=\"val\", ascending=False).groupby(\"grp\").head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "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>grp</th>\n",
       "      <th>val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>a</td>\n",
       "      <td>9.903477</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>a</td>\n",
       "      <td>8.799277</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>b</td>\n",
       "      <td>7.846610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>b</td>\n",
       "      <td>7.815600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>b</td>\n",
       "      <td>4.185375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>a</td>\n",
       "      <td>4.158718</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  grp       val\n",
       "0   a  9.903477\n",
       "3   a  8.799277\n",
       "8   b  7.846610\n",
       "6   b  7.815600\n",
       "9   b  4.185375\n",
       "2   a  4.158718"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_sort_group_top3"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 시각화"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 한글폰트"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 297,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Malgun Gothic\n"
     ]
    }
   ],
   "source": [
    "font_name = mpl.font_manager.FontProperties(fname=\"/Users/jooyoungson/font_korea/malgun.ttf\").get_name()\n",
    "mpl.rc('font', family=font_name)\n",
    "print(font_name)\n",
    "plt.rc('font', family=font_name)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 247,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "200\n"
     ]
    }
   ],
   "source": [
    "url = \"https://finance.naver.com/\"\n",
    "res = requests.get(url)\n",
    "print(res.status_code)\n",
    "res.raise_for_status()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# f = open('stock.csv', 'w', newline='')\n",
    "# write = csv.DictWriter(f, fieldnames= [\"종목\", \"가격\", \"시가총액\", \"시가총액순위\", \"목표주가\", \n",
    "#                                        \"PER\", \"EPS\", \"추정PER\", \"추정EPS\", \"PBR\",\"BPS\" \"배당수익률\"])\n",
    "# write.writeheader()\n",
    "# write = csv.writer(f)\n",
    "data_code = []\n",
    "data_price = []\n",
    "for soup in soups:\n",
    "    data_rows = soup.find(\"div\", attrs={\"id\":\"wrap\"}).find(\"div\", attrs={\"class\":\"new_totalinfo\"}).find_all(\"dd\")\n",
    "    c = 0\n",
    "    data_category = []\n",
    "    for i in data_rows:\n",
    "        data_category.append(i.get_text())\n",
    "#    print(data_category[0][:21],data_category[1],data_category[3])\n",
    "#    write.writerow([data_category[1][3:], data_category[3][3:10]])\n",
    "    data_code.append(data_category[1][4:])\n",
    "    data_price.append(data_category[3][3:11])\n",
    "time = data_category[0][:-7]\n",
    "#f.close()\n",
    "time"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# res = requests.get(urls[0])\n",
    "# soup = BeautifulSoup(res.text, \"lxml\")\n",
    "\n",
    "# data_rows = soup.find(\"div\", attrs={\"id\":\"wrap\"}).find(\"div\", attrs={\"class\":\"new_totalinfo\"}).find_all(\"dd\")\n",
    "\n",
    "# data = []\n",
    "# for i in data_rows:\n",
    "#     data.append(i.get_text())\n",
    "# data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_index = []\n",
    "for soup in soups:\n",
    "    data_rows = soup.find(\"div\", attrs={\"id\":\"aside\"}).find_all(\"th\")\n",
    "    for i in data_rows:\n",
    "        data_index.append(i.get_text())\n",
    "#     print(data_index[0], data_index[1], data_index[7][5:]+'\\n', data_index[9][11:14]+'\\n', data_index[9][15:18]+'\\n', \n",
    "#           data_index[10][0:5]+'\\n', data_index[10][6:9]+'\\n', data_index[11][:3]+'\\n', data_index[12][:5], end=\"\\n\"*2)"
   ]
  }
 ],
 "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.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}