투자자별 매매동향.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "fdc397d1",
   "metadata": {},
   "outputs": [],
   "source": [
    "from selenium import webdriver\n",
    "from selenium.webdriver.support import expected_conditions as EC\n",
    "from selenium.webdriver.common.by import By\n",
    "from selenium.webdriver.support.ui import WebDriverWait\n",
    "from selenium.webdriver.chrome.service import Service\n",
    "from bs4 import BeautifulSoup\n",
    "from html_table_parser import parser_functions\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "04dd484c",
   "metadata": {},
   "outputs": [],
   "source": [
    "import collections\n",
    "collections.Callable = collections.abc.Callable"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "e13aff4c",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 드라이버 초기화\n",
    "driver = webdriver.Chrome()\n",
    "\n",
    "\n",
    "try:\n",
    "    columns = pd.MultiIndex.from_tuples([\n",
    "    ('', '날짜'),\n",
    "    ('', '종가'),\n",
    "    ('', '전일비'),\n",
    "    ('', '등락률'),\n",
    "    ('', '거래량'),\n",
    "    ('기관', '순매매량'),\n",
    "    ('외국인', '순매매량'),\n",
    "    ('외국인', '보유주수'),\n",
    "    ('외국인', '보유율')\n",
    "    ])\n",
    "    df = pd.DataFrame(columns=columns)\n",
    "    for i in range(1,244):\n",
    "        req_url = 'https://finance.naver.com/item/frgn.naver?code=005930&page='+str(i)\n",
    "        driver.get(req_url)\n",
    "        # 페이지의 HTML 소스를 가져와서 파싱\n",
    "        html = driver.page_source\n",
    "        soup = BeautifulSoup(html, 'html.parser')\n",
    "        table = soup.find(\"table\", {\"summary\": \"외국인 기관 순매매 거래량에 관한표이며 날짜별로 정보를 제공합니다.\"})\n",
    "        table = parser_functions.make2d(table)\n",
    "        frame = pd.DataFrame(data = table[1:], columns = table[0])\n",
    "        frame = pd.DataFrame(data=table[1:], columns=table[0])\n",
    "        frame.columns = pd.MultiIndex.from_tuples([('', '날짜'),\n",
    "                                                   ('', '종가'),\n",
    "                                                   ('', '전일비'),\n",
    "                                                   ('', '등락률'),\n",
    "                                                   ('', '거래량'),\n",
    "                                                   ('기관', '순매매량'),\n",
    "                                                   ('외국인', '순매매량'),\n",
    "                                                   ('외국인', '보유주수'),\n",
    "                                                   ('외국인', '보유율')\n",
    "                                                    ])\n",
    "\n",
    "        # 만약 '외국인 보유율' 컬럼이 table 데이터에 없다면 이를 추가\n",
    "        if ('외국인', '보유율') not in frame.columns:\n",
    "            frame[('', '외국인 보유율')] = None\n",
    "\n",
    "        # 기존 df와 새로운 frame 데이터프레임을 병합\n",
    "        df = pd.concat([df, frame], axis=0, ignore_index=True)\n",
    "\n",
    "finally:\n",
    "    driver.quit()  # 드라이버 종료"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "713030f1",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.iloc[2:,:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "26873c9e",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "d99679fe",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 인덱스가 7, 32, 33이 아닌 행만 필터링\n",
    "filtered_df = df[~df.index.isin([7, 32, 33])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "28057465",
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"5\" halign=\"left\"></th>\n",
       "      <th>기관</th>\n",
       "      <th colspan=\"3\" halign=\"left\">외국인</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>날짜</th>\n",
       "      <th>종가</th>\n",
       "      <th>전일비</th>\n",
       "      <th>등락률</th>\n",
       "      <th>거래량</th>\n",
       "      <th>순매매량</th>\n",
       "      <th>순매매량</th>\n",
       "      <th>보유주수</th>\n",
       "      <th>보유율</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2024.08.21</td>\n",
       "      <td>78,300</td>\n",
       "      <td>하락\\n\\t\\t\\t\\t600</td>\n",
       "      <td>-0.76%</td>\n",
       "      <td>7,734,771</td>\n",
       "      <td>+177,643</td>\n",
       "      <td>+82,341</td>\n",
       "      <td>3,357,989,044</td>\n",
       "      <td>56.25%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2024.08.20</td>\n",
       "      <td>78,900</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t600</td>\n",
       "      <td>+0.77%</td>\n",
       "      <td>10,683,836</td>\n",
       "      <td>-141,999</td>\n",
       "      <td>+924,485</td>\n",
       "      <td>3,357,906,703</td>\n",
       "      <td>56.25%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2024.08.19</td>\n",
       "      <td>78,300</td>\n",
       "      <td>하락\\n\\t\\t\\t\\t1,900</td>\n",
       "      <td>-2.37%</td>\n",
       "      <td>14,146,565</td>\n",
       "      <td>-339,031</td>\n",
       "      <td>-1,468,641</td>\n",
       "      <td>3,356,978,020</td>\n",
       "      <td>56.23%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2024.08.16</td>\n",
       "      <td>80,200</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t3,000</td>\n",
       "      <td>+3.89%</td>\n",
       "      <td>22,061,478</td>\n",
       "      <td>+918,078</td>\n",
       "      <td>+6,540,655</td>\n",
       "      <td>3,358,563,961</td>\n",
       "      <td>56.26%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2024.08.14</td>\n",
       "      <td>77,200</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t1,100</td>\n",
       "      <td>+1.45%</td>\n",
       "      <td>13,246,168</td>\n",
       "      <td>-230,603</td>\n",
       "      <td>+2,054,899</td>\n",
       "      <td>3,352,025,208</td>\n",
       "      <td>56.15%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2024.08.13</td>\n",
       "      <td>76,100</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t600</td>\n",
       "      <td>+0.79%</td>\n",
       "      <td>10,716,261</td>\n",
       "      <td>-202,595</td>\n",
       "      <td>+1,857,644</td>\n",
       "      <td>3,349,911,209</td>\n",
       "      <td>56.11%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2024.08.12</td>\n",
       "      <td>75,500</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t800</td>\n",
       "      <td>+1.07%</td>\n",
       "      <td>9,839,259</td>\n",
       "      <td>+112,759</td>\n",
       "      <td>+473,898</td>\n",
       "      <td>3,347,828,165</td>\n",
       "      <td>56.08%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2024.08.09</td>\n",
       "      <td>74,700</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t1,300</td>\n",
       "      <td>+1.77%</td>\n",
       "      <td>16,388,222</td>\n",
       "      <td>-21,816</td>\n",
       "      <td>+556,506</td>\n",
       "      <td>3,347,500,307</td>\n",
       "      <td>56.07%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2024.08.08</td>\n",
       "      <td>73,400</td>\n",
       "      <td>하락\\n\\t\\t\\t\\t1,300</td>\n",
       "      <td>-1.74%</td>\n",
       "      <td>28,414,729</td>\n",
       "      <td>-3,828,398</td>\n",
       "      <td>-3,296,483</td>\n",
       "      <td>3,346,950,301</td>\n",
       "      <td>56.06%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2024.08.07</td>\n",
       "      <td>74,700</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t2,200</td>\n",
       "      <td>+3.03%</td>\n",
       "      <td>32,710,428</td>\n",
       "      <td>-2,123,457</td>\n",
       "      <td>+1,071,074</td>\n",
       "      <td>3,350,207,687</td>\n",
       "      <td>56.12%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2024.08.06</td>\n",
       "      <td>72,500</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t1,100</td>\n",
       "      <td>+1.54%</td>\n",
       "      <td>47,295,226</td>\n",
       "      <td>-7,018,788</td>\n",
       "      <td>-2,581,926</td>\n",
       "      <td>3,349,242,765</td>\n",
       "      <td>56.10%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2024.08.05</td>\n",
       "      <td>71,400</td>\n",
       "      <td>하락\\n\\t\\t\\t\\t8,200</td>\n",
       "      <td>-10.30%</td>\n",
       "      <td>54,608,790</td>\n",
       "      <td>-2,439,089</td>\n",
       "      <td>-16,584,000</td>\n",
       "      <td>3,351,340,541</td>\n",
       "      <td>56.14%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2024.08.02</td>\n",
       "      <td>79,600</td>\n",
       "      <td>하락\\n\\t\\t\\t\\t3,500</td>\n",
       "      <td>-4.21%</td>\n",
       "      <td>25,800,275</td>\n",
       "      <td>-3,138,554</td>\n",
       "      <td>-3,630,476</td>\n",
       "      <td>3,367,986,900</td>\n",
       "      <td>56.42%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2024.08.01</td>\n",
       "      <td>83,100</td>\n",
       "      <td>하락\\n\\t\\t\\t\\t800</td>\n",
       "      <td>-0.95%</td>\n",
       "      <td>20,900,338</td>\n",
       "      <td>-1,061,536</td>\n",
       "      <td>+329,840</td>\n",
       "      <td>3,371,460,876</td>\n",
       "      <td>56.48%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2024.07.31</td>\n",
       "      <td>83,900</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t2,900</td>\n",
       "      <td>+3.58%</td>\n",
       "      <td>20,744,323</td>\n",
       "      <td>+958,338</td>\n",
       "      <td>+1,683,299</td>\n",
       "      <td>3,370,329,076</td>\n",
       "      <td>56.46%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2024.07.30</td>\n",
       "      <td>81,000</td>\n",
       "      <td>하락\\n\\t\\t\\t\\t200</td>\n",
       "      <td>-0.25%</td>\n",
       "      <td>13,169,636</td>\n",
       "      <td>-1,379,203</td>\n",
       "      <td>-318,329</td>\n",
       "      <td>3,368,633,203</td>\n",
       "      <td>56.43%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2024.07.29</td>\n",
       "      <td>81,200</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t300</td>\n",
       "      <td>+0.37%</td>\n",
       "      <td>12,797,136</td>\n",
       "      <td>-554,806</td>\n",
       "      <td>+52,996</td>\n",
       "      <td>3,368,959,775</td>\n",
       "      <td>56.43%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2024.07.26</td>\n",
       "      <td>80,900</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t500</td>\n",
       "      <td>+0.62%</td>\n",
       "      <td>14,508,334</td>\n",
       "      <td>+719,026</td>\n",
       "      <td>-1,793,928</td>\n",
       "      <td>3,368,888,879</td>\n",
       "      <td>56.43%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2024.07.25</td>\n",
       "      <td>80,400</td>\n",
       "      <td>하락\\n\\t\\t\\t\\t1,600</td>\n",
       "      <td>-1.95%</td>\n",
       "      <td>20,323,811</td>\n",
       "      <td>-1,877,734</td>\n",
       "      <td>+189,842</td>\n",
       "      <td>3,370,673,007</td>\n",
       "      <td>56.46%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2024.07.24</td>\n",
       "      <td>82,000</td>\n",
       "      <td>하락\\n\\t\\t\\t\\t1,900</td>\n",
       "      <td>-2.26%</td>\n",
       "      <td>16,939,083</td>\n",
       "      <td>-492,483</td>\n",
       "      <td>-2,625,120</td>\n",
       "      <td>3,370,351,551</td>\n",
       "      <td>56.46%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2024.07.23</td>\n",
       "      <td>83,900</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t900</td>\n",
       "      <td>+1.08%</td>\n",
       "      <td>15,766,389</td>\n",
       "      <td>-1,694,295</td>\n",
       "      <td>+2,466,383</td>\n",
       "      <td>3,372,806,771</td>\n",
       "      <td>56.50%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2024.07.22</td>\n",
       "      <td>83,000</td>\n",
       "      <td>하락\\n\\t\\t\\t\\t1,400</td>\n",
       "      <td>-1.66%</td>\n",
       "      <td>18,987,560</td>\n",
       "      <td>-242,867</td>\n",
       "      <td>-375,164</td>\n",
       "      <td>3,370,335,790</td>\n",
       "      <td>56.46%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2024.07.19</td>\n",
       "      <td>84,400</td>\n",
       "      <td>하락\\n\\t\\t\\t\\t2,500</td>\n",
       "      <td>-2.88%</td>\n",
       "      <td>18,569,122</td>\n",
       "      <td>-1,750,534</td>\n",
       "      <td>-2,940,842</td>\n",
       "      <td>3,370,705,576</td>\n",
       "      <td>56.46%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2024.07.18</td>\n",
       "      <td>86,900</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t200</td>\n",
       "      <td>+0.23%</td>\n",
       "      <td>24,721,790</td>\n",
       "      <td>+1,853,095</td>\n",
       "      <td>-924,810</td>\n",
       "      <td>3,373,402,418</td>\n",
       "      <td>56.51%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2024.07.17</td>\n",
       "      <td>86,700</td>\n",
       "      <td>하락\\n\\t\\t\\t\\t1,000</td>\n",
       "      <td>-1.14%</td>\n",
       "      <td>18,186,490</td>\n",
       "      <td>-306,635</td>\n",
       "      <td>+409,230</td>\n",
       "      <td>3,374,439,793</td>\n",
       "      <td>56.53%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>2024.07.16</td>\n",
       "      <td>87,700</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t1,000</td>\n",
       "      <td>+1.15%</td>\n",
       "      <td>16,166,688</td>\n",
       "      <td>+645,166</td>\n",
       "      <td>+2,036,914</td>\n",
       "      <td>3,373,985,539</td>\n",
       "      <td>56.52%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>2024.07.15</td>\n",
       "      <td>86,700</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t2,300</td>\n",
       "      <td>+2.73%</td>\n",
       "      <td>25,193,080</td>\n",
       "      <td>+4,178,194</td>\n",
       "      <td>-720,308</td>\n",
       "      <td>3,371,438,352</td>\n",
       "      <td>56.48%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>2024.07.12</td>\n",
       "      <td>84,400</td>\n",
       "      <td>하락\\n\\t\\t\\t\\t3,200</td>\n",
       "      <td>-3.65%</td>\n",
       "      <td>26,344,386</td>\n",
       "      <td>+154,761</td>\n",
       "      <td>-3,640,216</td>\n",
       "      <td>3,372,206,489</td>\n",
       "      <td>56.49%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>2024.07.11</td>\n",
       "      <td>87,600</td>\n",
       "      <td>하락\\n\\t\\t\\t\\t200</td>\n",
       "      <td>-0.23%</td>\n",
       "      <td>24,677,608</td>\n",
       "      <td>-1,171,760</td>\n",
       "      <td>+2,337,048</td>\n",
       "      <td>3,375,759,305</td>\n",
       "      <td>56.55%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>2024.07.10</td>\n",
       "      <td>87,800</td>\n",
       "      <td>보합0</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>17,813,847</td>\n",
       "      <td>-1,447,489</td>\n",
       "      <td>+3,475,799</td>\n",
       "      <td>3,373,424,267</td>\n",
       "      <td>56.51%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>2024.07.09</td>\n",
       "      <td>87,800</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t400</td>\n",
       "      <td>+0.46%</td>\n",
       "      <td>21,336,201</td>\n",
       "      <td>-3,751</td>\n",
       "      <td>+3,775,043</td>\n",
       "      <td>3,369,964,762</td>\n",
       "      <td>56.45%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>2024.07.08</td>\n",
       "      <td>87,400</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t300</td>\n",
       "      <td>+0.34%</td>\n",
       "      <td>24,035,809</td>\n",
       "      <td>-1,128,290</td>\n",
       "      <td>+3,910,224</td>\n",
       "      <td>3,366,066,887</td>\n",
       "      <td>56.39%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>2024.07.05</td>\n",
       "      <td>87,100</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t2,500</td>\n",
       "      <td>+2.96%</td>\n",
       "      <td>45,791,193</td>\n",
       "      <td>+6,809,451</td>\n",
       "      <td>+13,730,052</td>\n",
       "      <td>3,362,156,754</td>\n",
       "      <td>56.32%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>2024.07.04</td>\n",
       "      <td>84,600</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t2,800</td>\n",
       "      <td>+3.42%</td>\n",
       "      <td>43,857,229</td>\n",
       "      <td>+6,993,695</td>\n",
       "      <td>+7,941,412</td>\n",
       "      <td>3,348,156,758</td>\n",
       "      <td>56.09%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>2024.07.03</td>\n",
       "      <td>81,800</td>\n",
       "      <td>보합0</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>11,440,328</td>\n",
       "      <td>+366,480</td>\n",
       "      <td>-44,152</td>\n",
       "      <td>3,339,415,820</td>\n",
       "      <td>55.94%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>2024.07.02</td>\n",
       "      <td>81,800</td>\n",
       "      <td>보합0</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>14,471,904</td>\n",
       "      <td>-1,172,626</td>\n",
       "      <td>+2,179,019</td>\n",
       "      <td>3,339,441,604</td>\n",
       "      <td>55.94%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>2024.07.01</td>\n",
       "      <td>81,800</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t300</td>\n",
       "      <td>+0.37%</td>\n",
       "      <td>11,317,202</td>\n",
       "      <td>+442,996</td>\n",
       "      <td>+1,026,322</td>\n",
       "      <td>3,336,890,385</td>\n",
       "      <td>55.90%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>2024.06.28</td>\n",
       "      <td>81,500</td>\n",
       "      <td>하락\\n\\t\\t\\t\\t100</td>\n",
       "      <td>-0.12%</td>\n",
       "      <td>9,455,929</td>\n",
       "      <td>+207,314</td>\n",
       "      <td>-965,053</td>\n",
       "      <td>3,335,943,684</td>\n",
       "      <td>55.88%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>2024.06.27</td>\n",
       "      <td>81,600</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t300</td>\n",
       "      <td>+0.37%</td>\n",
       "      <td>11,739,720</td>\n",
       "      <td>-3,472,885</td>\n",
       "      <td>+4,855,358</td>\n",
       "      <td>3,336,873,737</td>\n",
       "      <td>55.90%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>2024.06.26</td>\n",
       "      <td>81,300</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t500</td>\n",
       "      <td>+0.62%</td>\n",
       "      <td>17,783,242</td>\n",
       "      <td>-793,488</td>\n",
       "      <td>+1,306,886</td>\n",
       "      <td>3,332,957,432</td>\n",
       "      <td>55.83%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>2024.06.25</td>\n",
       "      <td>80,800</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t200</td>\n",
       "      <td>+0.25%</td>\n",
       "      <td>19,088,458</td>\n",
       "      <td>-476,258</td>\n",
       "      <td>+2,826,498</td>\n",
       "      <td>3,331,638,548</td>\n",
       "      <td>55.81%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>2024.06.24</td>\n",
       "      <td>80,600</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t600</td>\n",
       "      <td>+0.75%</td>\n",
       "      <td>15,454,227</td>\n",
       "      <td>+281,038</td>\n",
       "      <td>+272,035</td>\n",
       "      <td>3,329,628,495</td>\n",
       "      <td>55.77%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>2024.06.21</td>\n",
       "      <td>80,000</td>\n",
       "      <td>하락\\n\\t\\t\\t\\t1,600</td>\n",
       "      <td>-1.96%</td>\n",
       "      <td>17,907,523</td>\n",
       "      <td>-392,128</td>\n",
       "      <td>-1,551,706</td>\n",
       "      <td>3,329,259,128</td>\n",
       "      <td>55.77%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>2024.06.20</td>\n",
       "      <td>81,600</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t400</td>\n",
       "      <td>+0.49%</td>\n",
       "      <td>20,288,913</td>\n",
       "      <td>+1,958,303</td>\n",
       "      <td>+4,035,075</td>\n",
       "      <td>3,331,019,004</td>\n",
       "      <td>55.80%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>2024.06.19</td>\n",
       "      <td>81,200</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t1,400</td>\n",
       "      <td>+1.75%</td>\n",
       "      <td>24,168,863</td>\n",
       "      <td>+3,843,571</td>\n",
       "      <td>+2,984,670</td>\n",
       "      <td>3,327,183,304</td>\n",
       "      <td>55.73%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>2024.06.18</td>\n",
       "      <td>79,800</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t1,700</td>\n",
       "      <td>+2.18%</td>\n",
       "      <td>18,207,598</td>\n",
       "      <td>+401,243</td>\n",
       "      <td>+5,599,290</td>\n",
       "      <td>3,324,149,834</td>\n",
       "      <td>55.68%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>2024.06.17</td>\n",
       "      <td>78,100</td>\n",
       "      <td>하락\\n\\t\\t\\t\\t1,500</td>\n",
       "      <td>-1.88%</td>\n",
       "      <td>16,123,051</td>\n",
       "      <td>-947,913</td>\n",
       "      <td>-540,863</td>\n",
       "      <td>3,318,542,747</td>\n",
       "      <td>55.59%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>2024.06.14</td>\n",
       "      <td>79,600</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t1,000</td>\n",
       "      <td>+1.27%</td>\n",
       "      <td>22,926,612</td>\n",
       "      <td>-1,159,458</td>\n",
       "      <td>+6,641,964</td>\n",
       "      <td>3,319,087,853</td>\n",
       "      <td>55.60%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>2024.06.13</td>\n",
       "      <td>78,600</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t2,100</td>\n",
       "      <td>+2.75%</td>\n",
       "      <td>33,763,804</td>\n",
       "      <td>-350,325</td>\n",
       "      <td>+12,050,709</td>\n",
       "      <td>3,313,137,289</td>\n",
       "      <td>55.50%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>2024.06.12</td>\n",
       "      <td>76,500</td>\n",
       "      <td>상승\\n\\t\\t\\t\\t1,300</td>\n",
       "      <td>+1.73%</td>\n",
       "      <td>19,246,725</td>\n",
       "      <td>-75,724</td>\n",
       "      <td>-431,060</td>\n",
       "      <td>3,300,778,905</td>\n",
       "      <td>55.29%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                        기관  \\\n",
       "            날짜      종가                전일비      등락률         거래량        순매매량   \n",
       "2   2024.08.21  78,300    하락\\n\\t\\t\\t\\t600   -0.76%   7,734,771    +177,643   \n",
       "3   2024.08.20  78,900    상승\\n\\t\\t\\t\\t600   +0.77%  10,683,836    -141,999   \n",
       "4   2024.08.19  78,300  하락\\n\\t\\t\\t\\t1,900   -2.37%  14,146,565    -339,031   \n",
       "5   2024.08.16  80,200  상승\\n\\t\\t\\t\\t3,000   +3.89%  22,061,478    +918,078   \n",
       "6   2024.08.14  77,200  상승\\n\\t\\t\\t\\t1,100   +1.45%  13,246,168    -230,603   \n",
       "10  2024.08.13  76,100    상승\\n\\t\\t\\t\\t600   +0.79%  10,716,261    -202,595   \n",
       "11  2024.08.12  75,500    상승\\n\\t\\t\\t\\t800   +1.07%   9,839,259    +112,759   \n",
       "12  2024.08.09  74,700  상승\\n\\t\\t\\t\\t1,300   +1.77%  16,388,222     -21,816   \n",
       "13  2024.08.08  73,400  하락\\n\\t\\t\\t\\t1,300   -1.74%  28,414,729  -3,828,398   \n",
       "14  2024.08.07  74,700  상승\\n\\t\\t\\t\\t2,200   +3.03%  32,710,428  -2,123,457   \n",
       "18  2024.08.06  72,500  상승\\n\\t\\t\\t\\t1,100   +1.54%  47,295,226  -7,018,788   \n",
       "19  2024.08.05  71,400  하락\\n\\t\\t\\t\\t8,200  -10.30%  54,608,790  -2,439,089   \n",
       "20  2024.08.02  79,600  하락\\n\\t\\t\\t\\t3,500   -4.21%  25,800,275  -3,138,554   \n",
       "21  2024.08.01  83,100    하락\\n\\t\\t\\t\\t800   -0.95%  20,900,338  -1,061,536   \n",
       "22  2024.07.31  83,900  상승\\n\\t\\t\\t\\t2,900   +3.58%  20,744,323    +958,338   \n",
       "26  2024.07.30  81,000    하락\\n\\t\\t\\t\\t200   -0.25%  13,169,636  -1,379,203   \n",
       "27  2024.07.29  81,200    상승\\n\\t\\t\\t\\t300   +0.37%  12,797,136    -554,806   \n",
       "28  2024.07.26  80,900    상승\\n\\t\\t\\t\\t500   +0.62%  14,508,334    +719,026   \n",
       "29  2024.07.25  80,400  하락\\n\\t\\t\\t\\t1,600   -1.95%  20,323,811  -1,877,734   \n",
       "30  2024.07.24  82,000  하락\\n\\t\\t\\t\\t1,900   -2.26%  16,939,083    -492,483   \n",
       "34  2024.07.23  83,900    상승\\n\\t\\t\\t\\t900   +1.08%  15,766,389  -1,694,295   \n",
       "35  2024.07.22  83,000  하락\\n\\t\\t\\t\\t1,400   -1.66%  18,987,560    -242,867   \n",
       "36  2024.07.19  84,400  하락\\n\\t\\t\\t\\t2,500   -2.88%  18,569,122  -1,750,534   \n",
       "37  2024.07.18  86,900    상승\\n\\t\\t\\t\\t200   +0.23%  24,721,790  +1,853,095   \n",
       "38  2024.07.17  86,700  하락\\n\\t\\t\\t\\t1,000   -1.14%  18,186,490    -306,635   \n",
       "42  2024.07.16  87,700  상승\\n\\t\\t\\t\\t1,000   +1.15%  16,166,688    +645,166   \n",
       "43  2024.07.15  86,700  상승\\n\\t\\t\\t\\t2,300   +2.73%  25,193,080  +4,178,194   \n",
       "44  2024.07.12  84,400  하락\\n\\t\\t\\t\\t3,200   -3.65%  26,344,386    +154,761   \n",
       "45  2024.07.11  87,600    하락\\n\\t\\t\\t\\t200   -0.23%  24,677,608  -1,171,760   \n",
       "46  2024.07.10  87,800                보합0    0.00%  17,813,847  -1,447,489   \n",
       "50  2024.07.09  87,800    상승\\n\\t\\t\\t\\t400   +0.46%  21,336,201      -3,751   \n",
       "51  2024.07.08  87,400    상승\\n\\t\\t\\t\\t300   +0.34%  24,035,809  -1,128,290   \n",
       "52  2024.07.05  87,100  상승\\n\\t\\t\\t\\t2,500   +2.96%  45,791,193  +6,809,451   \n",
       "53  2024.07.04  84,600  상승\\n\\t\\t\\t\\t2,800   +3.42%  43,857,229  +6,993,695   \n",
       "54  2024.07.03  81,800                보합0    0.00%  11,440,328    +366,480   \n",
       "58  2024.07.02  81,800                보합0    0.00%  14,471,904  -1,172,626   \n",
       "59  2024.07.01  81,800    상승\\n\\t\\t\\t\\t300   +0.37%  11,317,202    +442,996   \n",
       "60  2024.06.28  81,500    하락\\n\\t\\t\\t\\t100   -0.12%   9,455,929    +207,314   \n",
       "61  2024.06.27  81,600    상승\\n\\t\\t\\t\\t300   +0.37%  11,739,720  -3,472,885   \n",
       "62  2024.06.26  81,300    상승\\n\\t\\t\\t\\t500   +0.62%  17,783,242    -793,488   \n",
       "66  2024.06.25  80,800    상승\\n\\t\\t\\t\\t200   +0.25%  19,088,458    -476,258   \n",
       "67  2024.06.24  80,600    상승\\n\\t\\t\\t\\t600   +0.75%  15,454,227    +281,038   \n",
       "68  2024.06.21  80,000  하락\\n\\t\\t\\t\\t1,600   -1.96%  17,907,523    -392,128   \n",
       "69  2024.06.20  81,600    상승\\n\\t\\t\\t\\t400   +0.49%  20,288,913  +1,958,303   \n",
       "70  2024.06.19  81,200  상승\\n\\t\\t\\t\\t1,400   +1.75%  24,168,863  +3,843,571   \n",
       "74  2024.06.18  79,800  상승\\n\\t\\t\\t\\t1,700   +2.18%  18,207,598    +401,243   \n",
       "75  2024.06.17  78,100  하락\\n\\t\\t\\t\\t1,500   -1.88%  16,123,051    -947,913   \n",
       "76  2024.06.14  79,600  상승\\n\\t\\t\\t\\t1,000   +1.27%  22,926,612  -1,159,458   \n",
       "77  2024.06.13  78,600  상승\\n\\t\\t\\t\\t2,100   +2.75%  33,763,804    -350,325   \n",
       "78  2024.06.12  76,500  상승\\n\\t\\t\\t\\t1,300   +1.73%  19,246,725     -75,724   \n",
       "\n",
       "            외국인                         \n",
       "           순매매량           보유주수     보유율  \n",
       "2       +82,341  3,357,989,044  56.25%  \n",
       "3      +924,485  3,357,906,703  56.25%  \n",
       "4    -1,468,641  3,356,978,020  56.23%  \n",
       "5    +6,540,655  3,358,563,961  56.26%  \n",
       "6    +2,054,899  3,352,025,208  56.15%  \n",
       "10   +1,857,644  3,349,911,209  56.11%  \n",
       "11     +473,898  3,347,828,165  56.08%  \n",
       "12     +556,506  3,347,500,307  56.07%  \n",
       "13   -3,296,483  3,346,950,301  56.06%  \n",
       "14   +1,071,074  3,350,207,687  56.12%  \n",
       "18   -2,581,926  3,349,242,765  56.10%  \n",
       "19  -16,584,000  3,351,340,541  56.14%  \n",
       "20   -3,630,476  3,367,986,900  56.42%  \n",
       "21     +329,840  3,371,460,876  56.48%  \n",
       "22   +1,683,299  3,370,329,076  56.46%  \n",
       "26     -318,329  3,368,633,203  56.43%  \n",
       "27      +52,996  3,368,959,775  56.43%  \n",
       "28   -1,793,928  3,368,888,879  56.43%  \n",
       "29     +189,842  3,370,673,007  56.46%  \n",
       "30   -2,625,120  3,370,351,551  56.46%  \n",
       "34   +2,466,383  3,372,806,771  56.50%  \n",
       "35     -375,164  3,370,335,790  56.46%  \n",
       "36   -2,940,842  3,370,705,576  56.46%  \n",
       "37     -924,810  3,373,402,418  56.51%  \n",
       "38     +409,230  3,374,439,793  56.53%  \n",
       "42   +2,036,914  3,373,985,539  56.52%  \n",
       "43     -720,308  3,371,438,352  56.48%  \n",
       "44   -3,640,216  3,372,206,489  56.49%  \n",
       "45   +2,337,048  3,375,759,305  56.55%  \n",
       "46   +3,475,799  3,373,424,267  56.51%  \n",
       "50   +3,775,043  3,369,964,762  56.45%  \n",
       "51   +3,910,224  3,366,066,887  56.39%  \n",
       "52  +13,730,052  3,362,156,754  56.32%  \n",
       "53   +7,941,412  3,348,156,758  56.09%  \n",
       "54      -44,152  3,339,415,820  55.94%  \n",
       "58   +2,179,019  3,339,441,604  55.94%  \n",
       "59   +1,026,322  3,336,890,385  55.90%  \n",
       "60     -965,053  3,335,943,684  55.88%  \n",
       "61   +4,855,358  3,336,873,737  55.90%  \n",
       "62   +1,306,886  3,332,957,432  55.83%  \n",
       "66   +2,826,498  3,331,638,548  55.81%  \n",
       "67     +272,035  3,329,628,495  55.77%  \n",
       "68   -1,551,706  3,329,259,128  55.77%  \n",
       "69   +4,035,075  3,331,019,004  55.80%  \n",
       "70   +2,984,670  3,327,183,304  55.73%  \n",
       "74   +5,599,290  3,324,149,834  55.68%  \n",
       "75     -540,863  3,318,542,747  55.59%  \n",
       "76   +6,641,964  3,319,087,853  55.60%  \n",
       "77  +12,050,709  3,313,137,289  55.50%  \n",
       "78     -431,060  3,300,778,905  55.29%  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filtered_df.head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "1f4dab0b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "-600\n"
     ]
    }
   ],
   "source": [
    "import re\n",
    "\n",
    "def convert_to_number(value):\n",
    "    # 문자열에서 '하락' 또는 '상승'을 찾아서 부호 결정\n",
    "    if '하락' in value:\n",
    "        sign = -1\n",
    "    elif '상승' in value:\n",
    "        sign = 1\n",
    "    elif '보합' in value:\n",
    "        sign = 0\n",
    "    else:\n",
    "        raise ValueError(\"Unrecognized pattern in value\")\n",
    "    \n",
    "    # 숫자 부분만 추출하기 위해 정규표현식을 사용\n",
    "    number_str = re.search(r'[\\d,]+', value).group()\n",
    "    \n",
    "    # 쉼표 제거 후 정수로 변환\n",
    "    number = int(number_str.replace(',', ''))\n",
    "    \n",
    "    # 부호를 적용한 값 반환\n",
    "    return sign * number\n",
    "\n",
    "# 예제 사용\n",
    "example_str = '하락\\n\\t\\t\\t\\t600'\n",
    "converted_value = convert_to_number(example_str)\n",
    "print(converted_value)  # 출력: -600"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "b8c2c048",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\wodnj\\AppData\\Local\\Temp\\ipykernel_63288\\3424287303.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  filtered_df[('', '전일비')] = filtered_df[('', '전일비')].apply(lambda x : convert_to_number(x))\n"
     ]
    }
   ],
   "source": [
    "filtered_df[('', '전일비')] = filtered_df[('', '전일비')].apply(lambda x : convert_to_number(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "b787713c",
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"5\" halign=\"left\"></th>\n",
       "      <th>기관</th>\n",
       "      <th colspan=\"3\" halign=\"left\">외국인</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>날짜</th>\n",
       "      <th>종가</th>\n",
       "      <th>전일비</th>\n",
       "      <th>등락률</th>\n",
       "      <th>거래량</th>\n",
       "      <th>순매매량</th>\n",
       "      <th>순매매량</th>\n",
       "      <th>보유주수</th>\n",
       "      <th>보유율</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2024.08.21</td>\n",
       "      <td>78,300</td>\n",
       "      <td>-600</td>\n",
       "      <td>-0.76%</td>\n",
       "      <td>7,734,771</td>\n",
       "      <td>+177,643</td>\n",
       "      <td>+82,341</td>\n",
       "      <td>3,357,989,044</td>\n",
       "      <td>56.25%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2024.08.20</td>\n",
       "      <td>78,900</td>\n",
       "      <td>600</td>\n",
       "      <td>+0.77%</td>\n",
       "      <td>10,683,836</td>\n",
       "      <td>-141,999</td>\n",
       "      <td>+924,485</td>\n",
       "      <td>3,357,906,703</td>\n",
       "      <td>56.25%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2024.08.19</td>\n",
       "      <td>78,300</td>\n",
       "      <td>-1900</td>\n",
       "      <td>-2.37%</td>\n",
       "      <td>14,146,565</td>\n",
       "      <td>-339,031</td>\n",
       "      <td>-1,468,641</td>\n",
       "      <td>3,356,978,020</td>\n",
       "      <td>56.23%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2024.08.16</td>\n",
       "      <td>80,200</td>\n",
       "      <td>3000</td>\n",
       "      <td>+3.89%</td>\n",
       "      <td>22,061,478</td>\n",
       "      <td>+918,078</td>\n",
       "      <td>+6,540,655</td>\n",
       "      <td>3,358,563,961</td>\n",
       "      <td>56.26%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2024.08.14</td>\n",
       "      <td>77,200</td>\n",
       "      <td>1100</td>\n",
       "      <td>+1.45%</td>\n",
       "      <td>13,246,168</td>\n",
       "      <td>-230,603</td>\n",
       "      <td>+2,054,899</td>\n",
       "      <td>3,352,025,208</td>\n",
       "      <td>56.15%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7758</th>\n",
       "      <td>2005.01.07</td>\n",
       "      <td>440,500</td>\n",
       "      <td>5500</td>\n",
       "      <td>+1.26%</td>\n",
       "      <td>272,369</td>\n",
       "      <td>-73,660</td>\n",
       "      <td>+71,587</td>\n",
       "      <td>79,831,619</td>\n",
       "      <td>54.20%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7762</th>\n",
       "      <td>2005.01.06</td>\n",
       "      <td>435,000</td>\n",
       "      <td>-8000</td>\n",
       "      <td>-1.81%</td>\n",
       "      <td>343,063</td>\n",
       "      <td>-56,059</td>\n",
       "      <td>+3,706</td>\n",
       "      <td>79,760,032</td>\n",
       "      <td>54.15%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7763</th>\n",
       "      <td>2005.01.05</td>\n",
       "      <td>443,000</td>\n",
       "      <td>-4000</td>\n",
       "      <td>-0.89%</td>\n",
       "      <td>467,322</td>\n",
       "      <td>-9,961</td>\n",
       "      <td>+1,683</td>\n",
       "      <td>79,752,966</td>\n",
       "      <td>54.14%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7764</th>\n",
       "      <td>2005.01.04</td>\n",
       "      <td>447,000</td>\n",
       "      <td>-4000</td>\n",
       "      <td>-0.89%</td>\n",
       "      <td>280,347</td>\n",
       "      <td>-31,824</td>\n",
       "      <td>+18,352</td>\n",
       "      <td>79,751,333</td>\n",
       "      <td>54.14%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7765</th>\n",
       "      <td>2005.01.03</td>\n",
       "      <td>451,000</td>\n",
       "      <td>500</td>\n",
       "      <td>+0.11%</td>\n",
       "      <td>218,558</td>\n",
       "      <td>+32,006</td>\n",
       "      <td>-6,036</td>\n",
       "      <td>79,732,931</td>\n",
       "      <td>54.13%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4854 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                           기관         외국인  \\\n",
       "              날짜       종가   전일비     등락률         거래량      순매매량        순매매량   \n",
       "2     2024.08.21   78,300  -600  -0.76%   7,734,771  +177,643     +82,341   \n",
       "3     2024.08.20   78,900   600  +0.77%  10,683,836  -141,999    +924,485   \n",
       "4     2024.08.19   78,300 -1900  -2.37%  14,146,565  -339,031  -1,468,641   \n",
       "5     2024.08.16   80,200  3000  +3.89%  22,061,478  +918,078  +6,540,655   \n",
       "6     2024.08.14   77,200  1100  +1.45%  13,246,168  -230,603  +2,054,899   \n",
       "...          ...      ...   ...     ...         ...       ...         ...   \n",
       "7758  2005.01.07  440,500  5500  +1.26%     272,369   -73,660     +71,587   \n",
       "7762  2005.01.06  435,000 -8000  -1.81%     343,063   -56,059      +3,706   \n",
       "7763  2005.01.05  443,000 -4000  -0.89%     467,322    -9,961      +1,683   \n",
       "7764  2005.01.04  447,000 -4000  -0.89%     280,347   -31,824     +18,352   \n",
       "7765  2005.01.03  451,000   500  +0.11%     218,558   +32,006      -6,036   \n",
       "\n",
       "                             \n",
       "               보유주수     보유율  \n",
       "2     3,357,989,044  56.25%  \n",
       "3     3,357,906,703  56.25%  \n",
       "4     3,356,978,020  56.23%  \n",
       "5     3,358,563,961  56.26%  \n",
       "6     3,352,025,208  56.15%  \n",
       "...             ...     ...  \n",
       "7758     79,831,619  54.20%  \n",
       "7762     79,760,032  54.15%  \n",
       "7763     79,752,966  54.14%  \n",
       "7764     79,751,333  54.14%  \n",
       "7765     79,732,931  54.13%  \n",
       "\n",
       "[4854 rows x 9 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filtered_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "7842465f",
   "metadata": {},
   "outputs": [],
   "source": [
    "filtered_df.to_csv('투자자별 매매동향.csv', index = False , encoding = 'utf-8-sig')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.11.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}