SectorCrawler.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "SectorCrawler.ipynb",
      "version": "0.3.2",
      "provenance": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/tylee33/DLforFinance/blob/master/SectorCrawler.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "metadata": {
        "id": "48-2FKsn3e5y",
        "colab_type": "text"
      },
      "cell_type": "markdown",
      "source": [
        "**네이버 증권에서 펀드 섹터별 수익률 정보 크롤링**"
      ]
    },
    {
      "metadata": {
        "id": "MwjGmsLx3oz4",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 607
        },
        "outputId": "1707bc41-e954-49e1-d8d6-3e105f14b0fb"
      },
      "cell_type": "code",
      "source": [
        "import requests\n",
        "import bs4\n",
        "import pandas as pd\n",
        "import numpy as np\n",
        "\n",
        "def __init__():\n",
        "    df=[]\n",
        "    url=[]\n",
        "\n",
        "def GetDf(url):\n",
        "    r = requests.get(url)\n",
        "    html = r.text\n",
        "\n",
        "    soup = bs4.BeautifulSoup(html, 'html.parser')\n",
        "    allRows = soup.find('tbody').find_all('tr')\n",
        "\n",
        "    results = [[data.text.split('?')[0].replace('\\n','').replace('\\t','') for data in td.find_all('td')]\\\n",
        "               for td in allRows]\n",
        "\n",
        "    rowspan = [] #row\n",
        "\n",
        "    for tr_no, tr in enumerate(allRows): #enumerate returns index, data \n",
        "        tmp = []\n",
        "        for td_no, data in enumerate(tr.find_all('td')):\n",
        "            if data.has_attr(\"rowspan\"):\n",
        "                rowspan.append((tr_no, td_no, int(data[\"rowspan\"]), data.get_text().split('?')[0].replace('\\n','').replace('\\t','')))\n",
        "\n",
        "    if rowspan:\n",
        "        for i in rowspan:\n",
        "            for j in range(1, i[2]):\n",
        "                results[i[0]+j].insert(i[1],i[3])\n",
        "\n",
        "    headers=[]\n",
        "\n",
        "    for i in range(1,11):\n",
        "        if i==6:\n",
        "            continue\n",
        "        if i==9:\n",
        "            headers.append(soup.find('thead').find('th',{'class':'th_result'+str(i)+'_on'}).text)\n",
        "        else:\n",
        "            headers.append(soup.find('thead').find('th',{'class':'th_result'+str(i)}).text)    \n",
        "    \n",
        "    df = pd.DataFrame(data=results)\n",
        "    \n",
        "    df.columns = headers\n",
        "    \n",
        "    df['설정액'] = df['설정액'].str.replace(',','').astype(float)\n",
        "    df['1개월 증감액'] = df['1개월 증감액'].str.replace(',','').astype(float)\n",
        "    df = df.replace('N/A',np.nan)\n",
        "    df.dropna(inplace=True)\n",
        "    \n",
        "    df = df.apply(pd.to_numeric, args =('ignore',))\n",
        "    \n",
        "    df.reset_index(inplace=True, drop=True)\n",
        "    return df\n",
        "\n",
        "GetDf('http://finance.naver.com/fund/fundTypeEarningRate.nhn?ivstAreaWorldYn=N')"
      ],
      "execution_count": 1,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>대유형</th>\n",
              "      <th>소유형</th>\n",
              "      <th>펀드수</th>\n",
              "      <th>설정액</th>\n",
              "      <th>1개월 증감액</th>\n",
              "      <th>올해</th>\n",
              "      <th>1개월</th>\n",
              "      <th>3개월</th>\n",
              "      <th>1년</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>주식형</td>\n",
              "      <td>배당주식</td>\n",
              "      <td>55</td>\n",
              "      <td>28250.0</td>\n",
              "      <td>127.0</td>\n",
              "      <td>3.50</td>\n",
              "      <td>4.00</td>\n",
              "      <td>1.96</td>\n",
              "      <td>-13.91</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>주식형</td>\n",
              "      <td>K200인덱스</td>\n",
              "      <td>78</td>\n",
              "      <td>118581.0</td>\n",
              "      <td>5997.0</td>\n",
              "      <td>4.48</td>\n",
              "      <td>5.11</td>\n",
              "      <td>-0.08</td>\n",
              "      <td>-14.86</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>주식형</td>\n",
              "      <td>일반주식</td>\n",
              "      <td>322</td>\n",
              "      <td>114256.0</td>\n",
              "      <td>264.0</td>\n",
              "      <td>2.90</td>\n",
              "      <td>3.80</td>\n",
              "      <td>-1.32</td>\n",
              "      <td>-16.87</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>주식형</td>\n",
              "      <td>중소형주식</td>\n",
              "      <td>53</td>\n",
              "      <td>17932.0</td>\n",
              "      <td>-123.0</td>\n",
              "      <td>1.15</td>\n",
              "      <td>2.84</td>\n",
              "      <td>-3.67</td>\n",
              "      <td>-18.23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>주식혼합형</td>\n",
              "      <td>일반주식혼합</td>\n",
              "      <td>92</td>\n",
              "      <td>35951.0</td>\n",
              "      <td>-107.0</td>\n",
              "      <td>2.70</td>\n",
              "      <td>3.45</td>\n",
              "      <td>0.70</td>\n",
              "      <td>-8.31</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>주식혼합형</td>\n",
              "      <td>공격적자산배분</td>\n",
              "      <td>32</td>\n",
              "      <td>6695.0</td>\n",
              "      <td>-62.0</td>\n",
              "      <td>3.05</td>\n",
              "      <td>4.63</td>\n",
              "      <td>-1.63</td>\n",
              "      <td>-11.03</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>채권혼합형</td>\n",
              "      <td>일반채권혼합</td>\n",
              "      <td>229</td>\n",
              "      <td>69375.0</td>\n",
              "      <td>834.0</td>\n",
              "      <td>0.70</td>\n",
              "      <td>1.05</td>\n",
              "      <td>0.29</td>\n",
              "      <td>-3.49</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>채권혼합형</td>\n",
              "      <td>보수적자산배분</td>\n",
              "      <td>38</td>\n",
              "      <td>3706.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>0.78</td>\n",
              "      <td>0.79</td>\n",
              "      <td>-0.18</td>\n",
              "      <td>-2.96</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>채권형</td>\n",
              "      <td>중기채권</td>\n",
              "      <td>61</td>\n",
              "      <td>32315.0</td>\n",
              "      <td>1127.0</td>\n",
              "      <td>-0.02</td>\n",
              "      <td>-0.14</td>\n",
              "      <td>1.61</td>\n",
              "      <td>4.95</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>채권형</td>\n",
              "      <td>우량채권</td>\n",
              "      <td>29</td>\n",
              "      <td>13637.0</td>\n",
              "      <td>1511.0</td>\n",
              "      <td>0.00</td>\n",
              "      <td>-0.08</td>\n",
              "      <td>1.19</td>\n",
              "      <td>3.70</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>채권형</td>\n",
              "      <td>일반채권</td>\n",
              "      <td>85</td>\n",
              "      <td>65125.0</td>\n",
              "      <td>3227.0</td>\n",
              "      <td>0.13</td>\n",
              "      <td>0.16</td>\n",
              "      <td>0.72</td>\n",
              "      <td>2.70</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>채권형</td>\n",
              "      <td>초단기채권</td>\n",
              "      <td>29</td>\n",
              "      <td>72513.0</td>\n",
              "      <td>299.0</td>\n",
              "      <td>0.14</td>\n",
              "      <td>0.20</td>\n",
              "      <td>0.54</td>\n",
              "      <td>1.86</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>MMF</td>\n",
              "      <td>MMF</td>\n",
              "      <td>134</td>\n",
              "      <td>877123.0</td>\n",
              "      <td>119836.0</td>\n",
              "      <td>0.09</td>\n",
              "      <td>0.15</td>\n",
              "      <td>0.43</td>\n",
              "      <td>1.63</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>부동산형</td>\n",
              "      <td>부동산대출채권</td>\n",
              "      <td>11</td>\n",
              "      <td>7050.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.43</td>\n",
              "      <td>0.58</td>\n",
              "      <td>4.94</td>\n",
              "      <td>14.20</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>부동산형</td>\n",
              "      <td>부동산임대</td>\n",
              "      <td>7</td>\n",
              "      <td>3392.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.34</td>\n",
              "      <td>0.54</td>\n",
              "      <td>1.29</td>\n",
              "      <td>6.91</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>절대수익추구형</td>\n",
              "      <td>채권알파</td>\n",
              "      <td>58</td>\n",
              "      <td>7835.0</td>\n",
              "      <td>185.0</td>\n",
              "      <td>0.20</td>\n",
              "      <td>0.49</td>\n",
              "      <td>0.36</td>\n",
              "      <td>1.19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>절대수익추구형</td>\n",
              "      <td>공모주하이일드</td>\n",
              "      <td>6</td>\n",
              "      <td>2742.0</td>\n",
              "      <td>-83.0</td>\n",
              "      <td>0.21</td>\n",
              "      <td>0.56</td>\n",
              "      <td>0.27</td>\n",
              "      <td>3.01</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>절대수익추구형</td>\n",
              "      <td>시장중립</td>\n",
              "      <td>21</td>\n",
              "      <td>1220.0</td>\n",
              "      <td>-47.0</td>\n",
              "      <td>1.11</td>\n",
              "      <td>1.25</td>\n",
              "      <td>0.12</td>\n",
              "      <td>-1.71</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        대유형      소유형  펀드수       설정액   1개월 증감액    올해   1개월   3개월     1년\n",
              "0       주식형     배당주식   55   28250.0     127.0  3.50  4.00  1.96 -13.91\n",
              "1       주식형  K200인덱스   78  118581.0    5997.0  4.48  5.11 -0.08 -14.86\n",
              "2       주식형     일반주식  322  114256.0     264.0  2.90  3.80 -1.32 -16.87\n",
              "3       주식형    중소형주식   53   17932.0    -123.0  1.15  2.84 -3.67 -18.23\n",
              "4     주식혼합형   일반주식혼합   92   35951.0    -107.0  2.70  3.45  0.70  -8.31\n",
              "5     주식혼합형  공격적자산배분   32    6695.0     -62.0  3.05  4.63 -1.63 -11.03\n",
              "6     채권혼합형   일반채권혼합  229   69375.0     834.0  0.70  1.05  0.29  -3.49\n",
              "7     채권혼합형  보수적자산배분   38    3706.0       9.0  0.78  0.79 -0.18  -2.96\n",
              "8       채권형     중기채권   61   32315.0    1127.0 -0.02 -0.14  1.61   4.95\n",
              "9       채권형     우량채권   29   13637.0    1511.0  0.00 -0.08  1.19   3.70\n",
              "10      채권형     일반채권   85   65125.0    3227.0  0.13  0.16  0.72   2.70\n",
              "11      채권형    초단기채권   29   72513.0     299.0  0.14  0.20  0.54   1.86\n",
              "12      MMF      MMF  134  877123.0  119836.0  0.09  0.15  0.43   1.63\n",
              "13     부동산형  부동산대출채권   11    7050.0       0.0  0.43  0.58  4.94  14.20\n",
              "14     부동산형    부동산임대    7    3392.0       0.0  0.34  0.54  1.29   6.91\n",
              "15  절대수익추구형     채권알파   58    7835.0     185.0  0.20  0.49  0.36   1.19\n",
              "16  절대수익추구형  공모주하이일드    6    2742.0     -83.0  0.21  0.56  0.27   3.01\n",
              "17  절대수익추구형     시장중립   21    1220.0     -47.0  1.11  1.25  0.12  -1.71"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 1
        }
      ]
    },
    {
      "metadata": {
        "id": "ia6VHEWs3zc6",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1723
        },
        "outputId": "6e2328da-c43e-498a-d10c-5ee8f4ee4759"
      },
      "cell_type": "code",
      "source": [
        "GetDf('http://finance.naver.com/fund/fundTypeEarningRate.nhn?ivstAreaWorldYn=Y')"
      ],
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>대유형</th>\n",
              "      <th>소유형</th>\n",
              "      <th>펀드수</th>\n",
              "      <th>설정액</th>\n",
              "      <th>1개월 증감액</th>\n",
              "      <th>올해</th>\n",
              "      <th>1개월</th>\n",
              "      <th>3개월</th>\n",
              "      <th>1년</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>브라질주식</td>\n",
              "      <td>8</td>\n",
              "      <td>745.0</td>\n",
              "      <td>-36.0</td>\n",
              "      <td>9.92</td>\n",
              "      <td>12.50</td>\n",
              "      <td>12.23</td>\n",
              "      <td>6.11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>기타국가주식</td>\n",
              "      <td>5</td>\n",
              "      <td>554.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>6.87</td>\n",
              "      <td>5.36</td>\n",
              "      <td>10.76</td>\n",
              "      <td>-7.55</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>인도주식</td>\n",
              "      <td>26</td>\n",
              "      <td>3153.0</td>\n",
              "      <td>96.0</td>\n",
              "      <td>-0.64</td>\n",
              "      <td>-2.01</td>\n",
              "      <td>7.35</td>\n",
              "      <td>-13.51</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>아시아신흥국주식</td>\n",
              "      <td>17</td>\n",
              "      <td>2863.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>3.24</td>\n",
              "      <td>2.85</td>\n",
              "      <td>5.01</td>\n",
              "      <td>-17.15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>남미신흥국주식</td>\n",
              "      <td>5</td>\n",
              "      <td>939.0</td>\n",
              "      <td>-5.0</td>\n",
              "      <td>10.18</td>\n",
              "      <td>11.69</td>\n",
              "      <td>4.53</td>\n",
              "      <td>-6.38</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>아시아태평양주식(ex J)</td>\n",
              "      <td>24</td>\n",
              "      <td>7192.0</td>\n",
              "      <td>94.0</td>\n",
              "      <td>4.67</td>\n",
              "      <td>4.08</td>\n",
              "      <td>4.10</td>\n",
              "      <td>-11.52</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>글로벌신흥국주식</td>\n",
              "      <td>47</td>\n",
              "      <td>8433.0</td>\n",
              "      <td>-45.0</td>\n",
              "      <td>6.00</td>\n",
              "      <td>5.48</td>\n",
              "      <td>3.42</td>\n",
              "      <td>-14.81</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>동남아주식</td>\n",
              "      <td>16</td>\n",
              "      <td>2177.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>5.64</td>\n",
              "      <td>4.22</td>\n",
              "      <td>2.39</td>\n",
              "      <td>-11.13</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>프론티어마켓주식</td>\n",
              "      <td>1</td>\n",
              "      <td>21.0</td>\n",
              "      <td>-0.0</td>\n",
              "      <td>2.52</td>\n",
              "      <td>1.44</td>\n",
              "      <td>2.15</td>\n",
              "      <td>-6.04</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>중국주식</td>\n",
              "      <td>160</td>\n",
              "      <td>56075.0</td>\n",
              "      <td>181.0</td>\n",
              "      <td>6.33</td>\n",
              "      <td>5.43</td>\n",
              "      <td>2.03</td>\n",
              "      <td>-25.09</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>유럽신흥국주식</td>\n",
              "      <td>8</td>\n",
              "      <td>992.0</td>\n",
              "      <td>-5.0</td>\n",
              "      <td>5.92</td>\n",
              "      <td>3.59</td>\n",
              "      <td>1.10</td>\n",
              "      <td>-14.29</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>공공서비스섹터</td>\n",
              "      <td>1</td>\n",
              "      <td>12.0</td>\n",
              "      <td>-0.0</td>\n",
              "      <td>6.00</td>\n",
              "      <td>3.77</td>\n",
              "      <td>0.32</td>\n",
              "      <td>-6.29</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>멀티섹터</td>\n",
              "      <td>6</td>\n",
              "      <td>572.0</td>\n",
              "      <td>-26.0</td>\n",
              "      <td>5.53</td>\n",
              "      <td>2.93</td>\n",
              "      <td>0.28</td>\n",
              "      <td>-2.99</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>러시아주식</td>\n",
              "      <td>9</td>\n",
              "      <td>3013.0</td>\n",
              "      <td>-23.0</td>\n",
              "      <td>7.25</td>\n",
              "      <td>5.16</td>\n",
              "      <td>0.13</td>\n",
              "      <td>-6.71</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>금융섹터</td>\n",
              "      <td>5</td>\n",
              "      <td>1955.0</td>\n",
              "      <td>-35.0</td>\n",
              "      <td>5.61</td>\n",
              "      <td>4.56</td>\n",
              "      <td>-1.29</td>\n",
              "      <td>-8.67</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>아시아태평양주식</td>\n",
              "      <td>13</td>\n",
              "      <td>400.0</td>\n",
              "      <td>-0.0</td>\n",
              "      <td>2.74</td>\n",
              "      <td>2.03</td>\n",
              "      <td>-1.39</td>\n",
              "      <td>-15.14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>기초소재섹터</td>\n",
              "      <td>8</td>\n",
              "      <td>3918.0</td>\n",
              "      <td>-6.0</td>\n",
              "      <td>2.28</td>\n",
              "      <td>1.97</td>\n",
              "      <td>-1.96</td>\n",
              "      <td>-16.03</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>정보기술섹터</td>\n",
              "      <td>38</td>\n",
              "      <td>8727.0</td>\n",
              "      <td>19.0</td>\n",
              "      <td>6.13</td>\n",
              "      <td>4.14</td>\n",
              "      <td>-3.05</td>\n",
              "      <td>-9.43</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>북미주식</td>\n",
              "      <td>38</td>\n",
              "      <td>6060.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>6.20</td>\n",
              "      <td>5.29</td>\n",
              "      <td>-4.10</td>\n",
              "      <td>-4.10</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>글로벌주식</td>\n",
              "      <td>74</td>\n",
              "      <td>25670.0</td>\n",
              "      <td>28.0</td>\n",
              "      <td>5.05</td>\n",
              "      <td>3.85</td>\n",
              "      <td>-4.13</td>\n",
              "      <td>-8.76</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>소비재섹터</td>\n",
              "      <td>2</td>\n",
              "      <td>115.0</td>\n",
              "      <td>-1.0</td>\n",
              "      <td>1.96</td>\n",
              "      <td>1.52</td>\n",
              "      <td>-4.62</td>\n",
              "      <td>-13.42</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>헬스케어섹터</td>\n",
              "      <td>12</td>\n",
              "      <td>1946.0</td>\n",
              "      <td>-2.0</td>\n",
              "      <td>8.17</td>\n",
              "      <td>6.54</td>\n",
              "      <td>-5.17</td>\n",
              "      <td>-0.77</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>유럽주식</td>\n",
              "      <td>32</td>\n",
              "      <td>3516.0</td>\n",
              "      <td>-20.0</td>\n",
              "      <td>3.69</td>\n",
              "      <td>1.31</td>\n",
              "      <td>-5.42</td>\n",
              "      <td>-12.82</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>일반산업섹터</td>\n",
              "      <td>1</td>\n",
              "      <td>65.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>7.94</td>\n",
              "      <td>5.73</td>\n",
              "      <td>-6.89</td>\n",
              "      <td>-8.86</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>독일주식</td>\n",
              "      <td>1</td>\n",
              "      <td>39.0</td>\n",
              "      <td>-0.0</td>\n",
              "      <td>4.54</td>\n",
              "      <td>2.35</td>\n",
              "      <td>-7.94</td>\n",
              "      <td>-21.40</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>베트남주식</td>\n",
              "      <td>16</td>\n",
              "      <td>6567.0</td>\n",
              "      <td>29.0</td>\n",
              "      <td>0.16</td>\n",
              "      <td>-1.95</td>\n",
              "      <td>-8.19</td>\n",
              "      <td>-17.74</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>에너지섹터</td>\n",
              "      <td>9</td>\n",
              "      <td>654.0</td>\n",
              "      <td>-3.0</td>\n",
              "      <td>7.13</td>\n",
              "      <td>4.98</td>\n",
              "      <td>-9.39</td>\n",
              "      <td>-16.75</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>해외주식형</td>\n",
              "      <td>일본주식</td>\n",
              "      <td>35</td>\n",
              "      <td>2243.0</td>\n",
              "      <td>-18.0</td>\n",
              "      <td>3.91</td>\n",
              "      <td>2.54</td>\n",
              "      <td>-9.91</td>\n",
              "      <td>-17.42</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>해외주식혼합형</td>\n",
              "      <td>아태주식혼합(ex J)</td>\n",
              "      <td>5</td>\n",
              "      <td>510.0</td>\n",
              "      <td>-11.0</td>\n",
              "      <td>2.68</td>\n",
              "      <td>1.95</td>\n",
              "      <td>2.08</td>\n",
              "      <td>-6.23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>해외주식혼합형</td>\n",
              "      <td>글로벌주식혼합</td>\n",
              "      <td>19</td>\n",
              "      <td>3927.0</td>\n",
              "      <td>-61.0</td>\n",
              "      <td>2.57</td>\n",
              "      <td>1.65</td>\n",
              "      <td>-1.11</td>\n",
              "      <td>-9.57</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td></td>\n",
              "      <td>북미주식혼합</td>\n",
              "      <td>7</td>\n",
              "      <td>1685.0</td>\n",
              "      <td>-81.0</td>\n",
              "      <td>3.76</td>\n",
              "      <td>2.85</td>\n",
              "      <td>-1.25</td>\n",
              "      <td>-2.96</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>해외주식혼합형</td>\n",
              "      <td>유럽주식혼합</td>\n",
              "      <td>6</td>\n",
              "      <td>951.0</td>\n",
              "      <td>-9.0</td>\n",
              "      <td>2.23</td>\n",
              "      <td>0.14</td>\n",
              "      <td>-2.13</td>\n",
              "      <td>-7.48</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>해외주식혼합형</td>\n",
              "      <td>글로벌 공격적자산배분</td>\n",
              "      <td>36</td>\n",
              "      <td>4511.0</td>\n",
              "      <td>-229.0</td>\n",
              "      <td>3.07</td>\n",
              "      <td>2.18</td>\n",
              "      <td>-3.41</td>\n",
              "      <td>-7.67</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>해외주식혼합형</td>\n",
              "      <td>아시아신흥국주식혼합</td>\n",
              "      <td>11</td>\n",
              "      <td>3157.0</td>\n",
              "      <td>-36.0</td>\n",
              "      <td>0.00</td>\n",
              "      <td>-1.01</td>\n",
              "      <td>-6.63</td>\n",
              "      <td>-15.53</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>해외채권혼합형</td>\n",
              "      <td>신흥국채권혼합</td>\n",
              "      <td>5</td>\n",
              "      <td>632.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>2.65</td>\n",
              "      <td>2.78</td>\n",
              "      <td>2.70</td>\n",
              "      <td>-1.98</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>해외채권혼합형</td>\n",
              "      <td>아태채권혼합(ex J)</td>\n",
              "      <td>8</td>\n",
              "      <td>1259.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2.06</td>\n",
              "      <td>1.66</td>\n",
              "      <td>1.99</td>\n",
              "      <td>-3.14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>해외채권혼합형</td>\n",
              "      <td>아시아신흥국채권혼합</td>\n",
              "      <td>19</td>\n",
              "      <td>2510.0</td>\n",
              "      <td>-0.0</td>\n",
              "      <td>1.26</td>\n",
              "      <td>0.91</td>\n",
              "      <td>0.71</td>\n",
              "      <td>-6.19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td></td>\n",
              "      <td>북미채권혼합</td>\n",
              "      <td>3</td>\n",
              "      <td>178.0</td>\n",
              "      <td>-10.0</td>\n",
              "      <td>2.28</td>\n",
              "      <td>1.80</td>\n",
              "      <td>-0.01</td>\n",
              "      <td>-2.03</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>해외채권혼합형</td>\n",
              "      <td>아태채권혼합</td>\n",
              "      <td>2</td>\n",
              "      <td>134.0</td>\n",
              "      <td>-2.0</td>\n",
              "      <td>2.31</td>\n",
              "      <td>1.75</td>\n",
              "      <td>-0.27</td>\n",
              "      <td>-7.18</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>해외채권혼합형</td>\n",
              "      <td>글로벌 보수적자산배분</td>\n",
              "      <td>40</td>\n",
              "      <td>3040.0</td>\n",
              "      <td>-82.0</td>\n",
              "      <td>2.03</td>\n",
              "      <td>1.73</td>\n",
              "      <td>-0.43</td>\n",
              "      <td>-3.21</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>해외채권혼합형</td>\n",
              "      <td>글로벌채권혼합</td>\n",
              "      <td>30</td>\n",
              "      <td>3802.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>2.01</td>\n",
              "      <td>1.47</td>\n",
              "      <td>-0.80</td>\n",
              "      <td>-2.98</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td></td>\n",
              "      <td>유럽채권혼합</td>\n",
              "      <td>2</td>\n",
              "      <td>322.0</td>\n",
              "      <td>-9.0</td>\n",
              "      <td>1.30</td>\n",
              "      <td>0.46</td>\n",
              "      <td>-2.32</td>\n",
              "      <td>-4.61</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>해외채권혼합형</td>\n",
              "      <td>일본채권혼합</td>\n",
              "      <td>1</td>\n",
              "      <td>40.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.54</td>\n",
              "      <td>1.08</td>\n",
              "      <td>-2.68</td>\n",
              "      <td>-6.26</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>해외채권형</td>\n",
              "      <td>아시아채권(ex J)</td>\n",
              "      <td>10</td>\n",
              "      <td>1702.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>-0.52</td>\n",
              "      <td>-0.77</td>\n",
              "      <td>4.11</td>\n",
              "      <td>-2.08</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>해외채권형</td>\n",
              "      <td>남미신흥국채권</td>\n",
              "      <td>2</td>\n",
              "      <td>145.0</td>\n",
              "      <td>-1.0</td>\n",
              "      <td>3.23</td>\n",
              "      <td>3.27</td>\n",
              "      <td>2.67</td>\n",
              "      <td>-0.62</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>해외채권형</td>\n",
              "      <td>신흥국채권</td>\n",
              "      <td>19</td>\n",
              "      <td>1952.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.88</td>\n",
              "      <td>1.74</td>\n",
              "      <td>2.12</td>\n",
              "      <td>-4.17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>해외채권형</td>\n",
              "      <td>글로벌채권</td>\n",
              "      <td>43</td>\n",
              "      <td>14747.0</td>\n",
              "      <td>196.0</td>\n",
              "      <td>0.55</td>\n",
              "      <td>0.41</td>\n",
              "      <td>1.11</td>\n",
              "      <td>-0.34</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>해외채권형</td>\n",
              "      <td>북미채권</td>\n",
              "      <td>11</td>\n",
              "      <td>3728.0</td>\n",
              "      <td>-0.0</td>\n",
              "      <td>0.62</td>\n",
              "      <td>-0.12</td>\n",
              "      <td>1.05</td>\n",
              "      <td>-2.07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>해외채권형</td>\n",
              "      <td>글로벌하이일드채권</td>\n",
              "      <td>27</td>\n",
              "      <td>5686.0</td>\n",
              "      <td>-282.0</td>\n",
              "      <td>2.75</td>\n",
              "      <td>1.80</td>\n",
              "      <td>-1.17</td>\n",
              "      <td>-4.10</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>해외부동산형</td>\n",
              "      <td>아-태 리츠재간접</td>\n",
              "      <td>2</td>\n",
              "      <td>93.0</td>\n",
              "      <td>-1.0</td>\n",
              "      <td>4.13</td>\n",
              "      <td>2.44</td>\n",
              "      <td>6.00</td>\n",
              "      <td>0.92</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50</th>\n",
              "      <td>해외부동산형</td>\n",
              "      <td>일본리츠재간접</td>\n",
              "      <td>3</td>\n",
              "      <td>207.0</td>\n",
              "      <td>-3.0</td>\n",
              "      <td>2.08</td>\n",
              "      <td>2.17</td>\n",
              "      <td>3.78</td>\n",
              "      <td>7.98</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>51</th>\n",
              "      <td>해외부동산형</td>\n",
              "      <td>글로벌리츠재간접</td>\n",
              "      <td>8</td>\n",
              "      <td>543.0</td>\n",
              "      <td>-2.0</td>\n",
              "      <td>5.45</td>\n",
              "      <td>2.57</td>\n",
              "      <td>2.81</td>\n",
              "      <td>4.14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>52</th>\n",
              "      <td>해외부동산형</td>\n",
              "      <td>글로벌부동산</td>\n",
              "      <td>17</td>\n",
              "      <td>19594.0</td>\n",
              "      <td>-0.0</td>\n",
              "      <td>0.50</td>\n",
              "      <td>1.30</td>\n",
              "      <td>2.06</td>\n",
              "      <td>6.59</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>53</th>\n",
              "      <td></td>\n",
              "      <td>커머더티</td>\n",
              "      <td>49</td>\n",
              "      <td>9740.0</td>\n",
              "      <td>66.0</td>\n",
              "      <td>2.68</td>\n",
              "      <td>1.79</td>\n",
              "      <td>-2.42</td>\n",
              "      <td>-0.39</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        대유형             소유형  펀드수      설정액  1개월 증감액     올해    1개월    3개월     1년\n",
              "0     해외주식형           브라질주식    8    745.0    -36.0   9.92  12.50  12.23   6.11\n",
              "1     해외주식형          기타국가주식    5    554.0      2.0   6.87   5.36  10.76  -7.55\n",
              "2     해외주식형            인도주식   26   3153.0     96.0  -0.64  -2.01   7.35 -13.51\n",
              "3     해외주식형        아시아신흥국주식   17   2863.0     18.0   3.24   2.85   5.01 -17.15\n",
              "4     해외주식형         남미신흥국주식    5    939.0     -5.0  10.18  11.69   4.53  -6.38\n",
              "5     해외주식형  아시아태평양주식(ex J)   24   7192.0     94.0   4.67   4.08   4.10 -11.52\n",
              "6     해외주식형        글로벌신흥국주식   47   8433.0    -45.0   6.00   5.48   3.42 -14.81\n",
              "7     해외주식형           동남아주식   16   2177.0      1.0   5.64   4.22   2.39 -11.13\n",
              "8     해외주식형        프론티어마켓주식    1     21.0     -0.0   2.52   1.44   2.15  -6.04\n",
              "9     해외주식형            중국주식  160  56075.0    181.0   6.33   5.43   2.03 -25.09\n",
              "10    해외주식형         유럽신흥국주식    8    992.0     -5.0   5.92   3.59   1.10 -14.29\n",
              "11    해외주식형         공공서비스섹터    1     12.0     -0.0   6.00   3.77   0.32  -6.29\n",
              "12    해외주식형            멀티섹터    6    572.0    -26.0   5.53   2.93   0.28  -2.99\n",
              "13    해외주식형           러시아주식    9   3013.0    -23.0   7.25   5.16   0.13  -6.71\n",
              "14    해외주식형            금융섹터    5   1955.0    -35.0   5.61   4.56  -1.29  -8.67\n",
              "15    해외주식형        아시아태평양주식   13    400.0     -0.0   2.74   2.03  -1.39 -15.14\n",
              "16    해외주식형          기초소재섹터    8   3918.0     -6.0   2.28   1.97  -1.96 -16.03\n",
              "17    해외주식형          정보기술섹터   38   8727.0     19.0   6.13   4.14  -3.05  -9.43\n",
              "18    해외주식형            북미주식   38   6060.0      6.0   6.20   5.29  -4.10  -4.10\n",
              "19    해외주식형           글로벌주식   74  25670.0     28.0   5.05   3.85  -4.13  -8.76\n",
              "20    해외주식형           소비재섹터    2    115.0     -1.0   1.96   1.52  -4.62 -13.42\n",
              "21    해외주식형          헬스케어섹터   12   1946.0     -2.0   8.17   6.54  -5.17  -0.77\n",
              "22    해외주식형            유럽주식   32   3516.0    -20.0   3.69   1.31  -5.42 -12.82\n",
              "23    해외주식형          일반산업섹터    1     65.0      0.0   7.94   5.73  -6.89  -8.86\n",
              "24    해외주식형            독일주식    1     39.0     -0.0   4.54   2.35  -7.94 -21.40\n",
              "25    해외주식형           베트남주식   16   6567.0     29.0   0.16  -1.95  -8.19 -17.74\n",
              "26    해외주식형           에너지섹터    9    654.0     -3.0   7.13   4.98  -9.39 -16.75\n",
              "27    해외주식형            일본주식   35   2243.0    -18.0   3.91   2.54  -9.91 -17.42\n",
              "28  해외주식혼합형    아태주식혼합(ex J)    5    510.0    -11.0   2.68   1.95   2.08  -6.23\n",
              "29  해외주식혼합형         글로벌주식혼합   19   3927.0    -61.0   2.57   1.65  -1.11  -9.57\n",
              "30                   북미주식혼합    7   1685.0    -81.0   3.76   2.85  -1.25  -2.96\n",
              "31  해외주식혼합형          유럽주식혼합    6    951.0     -9.0   2.23   0.14  -2.13  -7.48\n",
              "32  해외주식혼합형     글로벌 공격적자산배분   36   4511.0   -229.0   3.07   2.18  -3.41  -7.67\n",
              "33  해외주식혼합형      아시아신흥국주식혼합   11   3157.0    -36.0   0.00  -1.01  -6.63 -15.53\n",
              "34  해외채권혼합형         신흥국채권혼합    5    632.0      5.0   2.65   2.78   2.70  -1.98\n",
              "35  해외채권혼합형    아태채권혼합(ex J)    8   1259.0      0.0   2.06   1.66   1.99  -3.14\n",
              "36  해외채권혼합형      아시아신흥국채권혼합   19   2510.0     -0.0   1.26   0.91   0.71  -6.19\n",
              "37                   북미채권혼합    3    178.0    -10.0   2.28   1.80  -0.01  -2.03\n",
              "38  해외채권혼합형          아태채권혼합    2    134.0     -2.0   2.31   1.75  -0.27  -7.18\n",
              "39  해외채권혼합형     글로벌 보수적자산배분   40   3040.0    -82.0   2.03   1.73  -0.43  -3.21\n",
              "40  해외채권혼합형         글로벌채권혼합   30   3802.0     12.0   2.01   1.47  -0.80  -2.98\n",
              "41                   유럽채권혼합    2    322.0     -9.0   1.30   0.46  -2.32  -4.61\n",
              "42  해외채권혼합형          일본채권혼합    1     40.0      0.0   1.54   1.08  -2.68  -6.26\n",
              "43    해외채권형     아시아채권(ex J)   10   1702.0      1.0  -0.52  -0.77   4.11  -2.08\n",
              "44    해외채권형         남미신흥국채권    2    145.0     -1.0   3.23   3.27   2.67  -0.62\n",
              "45    해외채권형           신흥국채권   19   1952.0      1.0   1.88   1.74   2.12  -4.17\n",
              "46    해외채권형           글로벌채권   43  14747.0    196.0   0.55   0.41   1.11  -0.34\n",
              "47    해외채권형            북미채권   11   3728.0     -0.0   0.62  -0.12   1.05  -2.07\n",
              "48    해외채권형       글로벌하이일드채권   27   5686.0   -282.0   2.75   1.80  -1.17  -4.10\n",
              "49   해외부동산형       아-태 리츠재간접    2     93.0     -1.0   4.13   2.44   6.00   0.92\n",
              "50   해외부동산형         일본리츠재간접    3    207.0     -3.0   2.08   2.17   3.78   7.98\n",
              "51   해외부동산형        글로벌리츠재간접    8    543.0     -2.0   5.45   2.57   2.81   4.14\n",
              "52   해외부동산형          글로벌부동산   17  19594.0     -0.0   0.50   1.30   2.06   6.59\n",
              "53                     커머더티   49   9740.0     66.0   2.68   1.79  -2.42  -0.39"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 2
        }
      ]
    },
    {
      "metadata": {
        "id": "xe4yAqoZ33vH",
        "colab_type": "text"
      },
      "cell_type": "markdown",
      "source": [
        "**펀드 섹터별 수익률 계산**"
      ]
    },
    {
      "metadata": {
        "id": "VN-7Mdhp38e5",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 266
        },
        "outputId": "bc0b309f-2443-4e58-9dc8-551bfbab2116"
      },
      "cell_type": "code",
      "source": [
        "def __init__(self):\n",
        "    df\n",
        "    \n",
        "def GetCalc(df):\n",
        "    ###########################################################\n",
        "    # drop 조건\n",
        "    # 1. 설정액이 1000억이하 섹터 drop.\n",
        "    # 2. 한번이라도 수익률이 마이너스를 기록했던 섹터 drop.\n",
        "    # 3. 국내채권,국내주식,해외채권,해외주식,부동산,현금으로 나누고 이 6개의 비중을 퍼지이론으로 조절하는 방식.\n",
        "    ###########################################################\n",
        "    \n",
        "    df = df.drop(df[(df['설정액']<1000)].index) # 1번 조건 drop.\n",
        "    \n",
        "    df['MoMofQoQ'] = ((((100+df['3개월'])/100)**(1/3))-1)*100\n",
        "    df['MoMofYoY'] = ((((100+df['1년'])/100)**(1/12))-1)*100    \n",
        "    df = df.drop(df[(df.MoMofYoY<0)|(df.MoMofQoQ<0)|(df['1개월']<0)].index) # 2번 조건 drop.\n",
        "    \n",
        "    dfStd = df[['1개월','MoMofYoY','MoMofQoQ']].std(axis=1)\n",
        "    df['Safety'] = (100-((dfStd - dfStd.min())/(dfStd.max()-dfStd.min()))*100)\n",
        "    \n",
        "    ReturnAdjValue = 1 # 수익성향보정치\n",
        "    SafetyAdjValue = 1 # 안전성향보정치\n",
        "    \n",
        "    # 기대수익률 = (1개월, MoMofYoY, MoMofQoQ의 평균 수익률 * 수익성향보정치) * (안전도*안전성향보정치)\n",
        "    df['기대수익률'] = (((df[['1개월','MoMofYoY','MoMofQoQ']].mean(axis=1)*ReturnAdjValue) * (df['Safety']*SafetyAdjValue) / 10000 + 1)**12-1)*100\n",
        "    df = df.drop(['3개월','1년'],axis=1)\n",
        "    \n",
        "    df = df.sort_values(by=['기대수익률'], ascending=False)\n",
        "    #df.reset_index(inplace=True, drop=True)\n",
        "    return df\n",
        "\n",
        "GetCalc(GetDf('http://finance.naver.com/fund/fundTypeEarningRate.nhn?ivstAreaWorldYn=N'))"
      ],
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>대유형</th>\n",
              "      <th>소유형</th>\n",
              "      <th>펀드수</th>\n",
              "      <th>설정액</th>\n",
              "      <th>1개월 증감액</th>\n",
              "      <th>올해</th>\n",
              "      <th>1개월</th>\n",
              "      <th>MoMofQoQ</th>\n",
              "      <th>MoMofYoY</th>\n",
              "      <th>Safety</th>\n",
              "      <th>기대수익률</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>부동산형</td>\n",
              "      <td>부동산임대</td>\n",
              "      <td>7</td>\n",
              "      <td>3392.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.34</td>\n",
              "      <td>0.54</td>\n",
              "      <td>0.428164</td>\n",
              "      <td>0.558363</td>\n",
              "      <td>87.734174</td>\n",
              "      <td>5.490658</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>채권형</td>\n",
              "      <td>일반채권</td>\n",
              "      <td>85</td>\n",
              "      <td>65125.0</td>\n",
              "      <td>3227.0</td>\n",
              "      <td>0.13</td>\n",
              "      <td>0.16</td>\n",
              "      <td>0.239426</td>\n",
              "      <td>0.222263</td>\n",
              "      <td>93.328777</td>\n",
              "      <td>2.345707</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>채권형</td>\n",
              "      <td>초단기채권</td>\n",
              "      <td>29</td>\n",
              "      <td>72513.0</td>\n",
              "      <td>299.0</td>\n",
              "      <td>0.14</td>\n",
              "      <td>0.20</td>\n",
              "      <td>0.179677</td>\n",
              "      <td>0.153694</td>\n",
              "      <td>96.953933</td>\n",
              "      <td>2.088221</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>절대수익추구형</td>\n",
              "      <td>공모주하이일드</td>\n",
              "      <td>6</td>\n",
              "      <td>2742.0</td>\n",
              "      <td>-83.0</td>\n",
              "      <td>0.21</td>\n",
              "      <td>0.56</td>\n",
              "      <td>0.089919</td>\n",
              "      <td>0.247438</td>\n",
              "      <td>54.804543</td>\n",
              "      <td>1.985004</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>MMF</td>\n",
              "      <td>MMF</td>\n",
              "      <td>134</td>\n",
              "      <td>877123.0</td>\n",
              "      <td>119836.0</td>\n",
              "      <td>0.09</td>\n",
              "      <td>0.15</td>\n",
              "      <td>0.143128</td>\n",
              "      <td>0.134829</td>\n",
              "      <td>100.000000</td>\n",
              "      <td>1.725324</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>절대수익추구형</td>\n",
              "      <td>채권알파</td>\n",
              "      <td>58</td>\n",
              "      <td>7835.0</td>\n",
              "      <td>185.0</td>\n",
              "      <td>0.20</td>\n",
              "      <td>0.49</td>\n",
              "      <td>0.119856</td>\n",
              "      <td>0.098630</td>\n",
              "      <td>58.545884</td>\n",
              "      <td>1.671833</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>부동산형</td>\n",
              "      <td>부동산대출채권</td>\n",
              "      <td>11</td>\n",
              "      <td>7050.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.43</td>\n",
              "      <td>0.58</td>\n",
              "      <td>1.620272</td>\n",
              "      <td>1.112654</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        대유형      소유형  펀드수       설정액   1개월 증감액    올해   1개월  MoMofQoQ  MoMofYoY  \\\n",
              "14     부동산형    부동산임대    7    3392.0       0.0  0.34  0.54  0.428164  0.558363   \n",
              "10      채권형     일반채권   85   65125.0    3227.0  0.13  0.16  0.239426  0.222263   \n",
              "11      채권형    초단기채권   29   72513.0     299.0  0.14  0.20  0.179677  0.153694   \n",
              "16  절대수익추구형  공모주하이일드    6    2742.0     -83.0  0.21  0.56  0.089919  0.247438   \n",
              "12      MMF      MMF  134  877123.0  119836.0  0.09  0.15  0.143128  0.134829   \n",
              "15  절대수익추구형     채권알파   58    7835.0     185.0  0.20  0.49  0.119856  0.098630   \n",
              "13     부동산형  부동산대출채권   11    7050.0       0.0  0.43  0.58  1.620272  1.112654   \n",
              "\n",
              "        Safety     기대수익률  \n",
              "14   87.734174  5.490658  \n",
              "10   93.328777  2.345707  \n",
              "11   96.953933  2.088221  \n",
              "16   54.804543  1.985004  \n",
              "12  100.000000  1.725324  \n",
              "15   58.545884  1.671833  \n",
              "13    0.000000  0.000000  "
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 3
        }
      ]
    },
    {
      "metadata": {
        "id": "FT2S8McA4AgO",
        "colab_type": "text"
      },
      "cell_type": "markdown",
      "source": [
        "**계산된 수익률을 바탕으로 퍼지이론 적용**"
      ]
    },
    {
      "metadata": {
        "id": "VtNYVjMQ4D-i",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 102
        },
        "outputId": "c3d4ef74-d47d-4d6f-8480-cab03c870563"
      },
      "cell_type": "code",
      "source": [
        "def RuleCalc(propensity):\n",
        "    ########################################\n",
        "    # Rule evaluation - The rules are different according to user's propensity\n",
        "    # propensity 1 - conservative propensity\n",
        "    # rule1\n",
        "    # IF safety / low\n",
        "    # and returns / high\n",
        "    # then importance / low\n",
        "    #\n",
        "    # rule2\n",
        "    # IF safety / high\n",
        "    # and returns / low\n",
        "    # then importance / high\n",
        "    #\n",
        "    # rule3\n",
        "    # IF safety / middle\n",
        "    # and returns / high\n",
        "    # then importance / middle\n",
        "    #########################################\n",
        "    if propensity=='conservative':\n",
        "        setHigh=[]\n",
        "        for index, x in fuzzyDf.iterrows():\n",
        "            setHigh.append(x['SafetyHigh']*x['returnLow'])\n",
        "        fuzzyDf['setHigh']=setHigh\n",
        "\n",
        "        setMid=[]\n",
        "        for index, x in fuzzyDf.iterrows():\n",
        "            setMid.append(x['SafetyMid']*x['returnHigh'])\n",
        "        fuzzyDf['setMid']=setMid\n",
        "\n",
        "        setLow=[]\n",
        "        for index, x in fuzzyDf.iterrows():\n",
        "            setLow.append(x['SafetyLow']*x['returnHigh'])\n",
        "        fuzzyDf['setLow']=setLow\n",
        "        return fuzzyDf['setHigh'],fuzzyDf['setMid'],fuzzyDf['setLow']\n",
        "    ########################################\n",
        "    # propensity 2 - moderate propensity\n",
        "    # rule1\n",
        "    # IF safety / low\n",
        "    # and returns / high\n",
        "    # then importance / middle\n",
        "    #\n",
        "    # rule2\n",
        "    # IF safety / high\n",
        "    # and returns / low\n",
        "    # then importance / low\n",
        "    #\n",
        "    # rule3\n",
        "    # IF safety / middle\n",
        "    # and returns / high\n",
        "    # then importance / high\n",
        "    #########################################\n",
        "    elif propensity=='moderate':\n",
        "        setHigh=[]\n",
        "        for index, x in fuzzyDf.iterrows():\n",
        "            setHigh.append(x['SafetyMid']*x['returnHigh'])\n",
        "        fuzzyDf['setHigh']=setHigh\n",
        "\n",
        "        setMid=[]\n",
        "        for index, x in fuzzyDf.iterrows():\n",
        "            setMid.append(x['SafetyHigh']*x['returnLow'])\n",
        "        fuzzyDf['setMid']=setMid\n",
        "\n",
        "        setLow=[]\n",
        "        for index, x in fuzzyDf.iterrows():\n",
        "            setLow.append(x['SafetyLow']*x['returnHigh'])\n",
        "        fuzzyDf['setLow']=setLow\n",
        "        return fuzzyDf['setHigh'],fuzzyDf['setMid'],fuzzyDf['setLow']\n",
        "    \n",
        "    ########################################\n",
        "    # propensity 3 - aggresive propensity\n",
        "    # rule1\n",
        "    # IF safety / low\n",
        "    # and returns / high\n",
        "    # then importance / high\n",
        "    #\n",
        "    # rule2\n",
        "    # IF safety / high\n",
        "    # and returns / low\n",
        "    # then importance / low\n",
        "    #\n",
        "    # rule3\n",
        "    # IF safety / middle\n",
        "    # and returns / high\n",
        "    # then importance / middle\n",
        "    #########################################\n",
        "    elif propensity=='aggressive':\n",
        "        setHigh=[]\n",
        "        for index, x in fuzzyDf.iterrows():\n",
        "            setHigh.append(x['SafetyLow']*x['returnHigh'])\n",
        "        fuzzyDf['setHigh']=setHigh\n",
        "\n",
        "        setMid=[]\n",
        "        for index, x in fuzzyDf.iterrows():\n",
        "            setMid.append(x['SafetyMid']*x['returnHigh'])\n",
        "        fuzzyDf['setMid']=setMid\n",
        "\n",
        "        setLow=[]\n",
        "        for index, x in fuzzyDf.iterrows():\n",
        "            setLow.append(x['SafetyHigh']*x['returnLow'])\n",
        "        fuzzyDf['setLow']=setLow\n",
        "        return fuzzyDf['setHigh'],fuzzyDf['setMid'],fuzzyDf['setLow']\n",
        "\n",
        "domesticDf=GetDf('http://finance.naver.com/fund/fundTypeEarningRate.nhn?ivstAreaWorldYn=N')\n",
        "overseasDf=GetDf('http://finance.naver.com/fund/fundTypeEarningRate.nhn?ivstAreaWorldYn=Y')\n",
        "\n",
        "earningRateDf = domesticDf.append(overseasDf, ignore_index=True)\n",
        "earningRateDf = GetCalc(earningRateDf)\n",
        "\n",
        "domesticDf=GetCalc(domesticDf)\n",
        "overseasDf=GetCalc(overseasDf)\n",
        "\n",
        "domesticStockDf = domesticDf[domesticDf['대유형'].str.contains(\"주식\")].reset_index(drop=True)\n",
        "domesticBondDf= domesticDf[domesticDf['대유형'].str.contains(\"채권\")].reset_index(drop=True)\n",
        "\n",
        "overseaStockDf = overseasDf[overseasDf['대유형'].str.contains(\"주식\")].reset_index(drop=True)\n",
        "overseaBondDf = overseasDf[overseasDf['대유형'].str.contains(\"채권\")].reset_index(drop=True)\n",
        "\n",
        "realestateDf =  earningRateDf[earningRateDf['대유형'].str.contains(\"부동산\")].reset_index(drop=True)\n",
        "cashDf =  earningRateDf[earningRateDf['대유형'].str.contains(\"MMF\")].reset_index(drop=True)\n",
        "\n",
        "resultDf = pd.DataFrame(columns=earningRateDf.columns)\n",
        "dfList = [domesticStockDf,domesticBondDf,overseaStockDf,overseaBondDf,realestateDf,cashDf]\n",
        "\n",
        "for x in dfList:\n",
        "    if x.empty==False:\n",
        "        resultDf = resultDf.append(x.iloc[0])\n",
        "\n",
        "fuzzyDf=pd.DataFrame()\n",
        "fuzzyDf['대유형']=resultDf['대유형']\n",
        "\n",
        "###############################################\n",
        "# Fuzzyfication\n",
        "# x를 계산하는 함수는 설문조사 혹은 인공지능에 따라 함수 변경 가능\n",
        "# x/15-(16/3)같은 부분을 함수화 시켜 차후 DB와 연동.\n",
        "##############################################\n",
        "safetyHigh=[]\n",
        "for x in resultDf.Safety:\n",
        "    if x>80 and x<95:\n",
        "        safetyHigh.append(x/15-(16/3))\n",
        "    elif x>=95:\n",
        "        safetyHigh.append(1)\n",
        "    else:\n",
        "        safetyHigh.append(0)\n",
        "fuzzyDf['SafetyHigh']=safetyHigh\n",
        "\n",
        "safetyMid=[]\n",
        "for x in resultDf.Safety:\n",
        "    if x>50 and x<=75:\n",
        "        safetyMid.append(x/25-2) \n",
        "    elif x>75:\n",
        "        safetyMid.append(-(x/25)+4)\n",
        "    else:\n",
        "        safetyMid.append(0)\n",
        "fuzzyDf['SafetyMid']=safetyMid\n",
        "\n",
        "safetyLow=[]\n",
        "for x in resultDf.Safety:\n",
        "    if x>=20 and x<=(160/3):\n",
        "        safetyLow.append(-(x*3/100)+(8/5)) \n",
        "    elif x<20:\n",
        "        safetyLow.append(1)\n",
        "    else:\n",
        "        safetyLow.append(0)\n",
        "fuzzyDf['SafetyLow']=safetyLow\n",
        "\n",
        "returnHigh=[]\n",
        "for x in resultDf['기대수익률']:\n",
        "    if x>=2 and x<8:\n",
        "        returnHigh.append(x/6-(1/3)) \n",
        "    elif x>=8:\n",
        "        returnHigh.append(1)\n",
        "    else:\n",
        "        returnHigh.append(0)\n",
        "fuzzyDf['returnHigh']=returnHigh\n",
        "\n",
        "returnLow=[]\n",
        "for x in resultDf['기대수익률']:\n",
        "    if x>=2 and x<4:\n",
        "        returnLow.append(-(x/4)+1) \n",
        "    elif x<2:\n",
        "        returnLow.append(1)\n",
        "    else:\n",
        "        returnLow.append(0)\n",
        "fuzzyDf['returnLow']=returnLow\n",
        "\n",
        "propensity = 'conservative'\n",
        "fuzzyDf['setHigh'],fuzzyDf['setMid'],fuzzyDf['setLow'] = RuleCalc(propensity)\n",
        "\n",
        "##############################################\n",
        "# Defuzzification uses COG\n",
        "##############################################\n",
        "fuzzyDf['COG']=\\\n",
        "fuzzyDf['setLow']*(10+20)+fuzzyDf[['setMid','setLow']].max(axis=1)*(30+40)\\\n",
        "+fuzzyDf['setMid']*50+fuzzyDf[['setHigh','setMid']].max(axis=1)*(60+70)+fuzzyDf['setHigh']*(80+90+100)\n",
        "\n",
        "resultDf['percentage']=(fuzzyDf['COG']/fuzzyDf['COG'].sum()).round(2)\n",
        "resultReturn = resultDf['기대수익률']*resultDf['percentage']\n",
        "print (pd.DataFrame(resultDf[['소유형','기대수익률','percentage']]))\n",
        "\n",
        "print (propensity, 'expected return:',resultReturn.sum()) # expected return"
      ],
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "     소유형     기대수익률  percentage\n",
            "0   일반채권  2.345707        0.24\n",
            "0  부동산임대  5.490658        0.12\n",
            "0    MMF  1.725324        0.64\n",
            "conservative expected return: 2.3260560559819057\n"
          ],
          "name": "stdout"
        }
      ]
    }
  ]
}