Analyze_my_grade.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Analyze_my_grade.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "authorship_tag": "ABX9TyM5XlnsBFSLUQTn9m+TYmsh",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/wjdqlsdlsp/My-Visualization/blob/main/Analyze_my_grade.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "vG6YJuMRJWk5"
      },
      "source": [
        "import pandas as pd\n",
        "import matplotlib.pyplot  as plt"
      ],
      "execution_count": 176,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "CGlrNT2PNVXw"
      },
      "source": [
        "### 이곳에 파일 이름 입력해주세요"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "KgvAX63oKXLr"
      },
      "source": [
        "file_name = \"/content/기이수성적조회_20210804 (1).xlsx\""
      ],
      "execution_count": 177,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "bzMc1OCqKMrP"
      },
      "source": [
        "data = pd.read_excel(file_name)\n",
        "columns = list(data.iloc[1])\n",
        "data = data[3:]\n",
        "data.columns = columns\n",
        "data = data.fillna('')"
      ],
      "execution_count": 178,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "-CtFlrXbLQEI"
      },
      "source": [
        "필수_졸업학점_지능기전 = {\"전필\": 37, \"전선\" : 35, \"총합\" : 130}"
      ],
      "execution_count": 179,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "1vzthrP4L7d_"
      },
      "source": [
        "data['학점'] = pd.to_numeric(data['학점'])\n",
        "data['평점'] = pd.to_numeric(data['평점'])"
      ],
      "execution_count": 180,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "ByOy7YkMNTHH"
      },
      "source": [
        "### 이수하지 못한 과목"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 78
        },
        "id": "ZiAfKJoJL0h8",
        "outputId": "23431d78-f0a0-4c7b-a288-9e4211d2288f"
      },
      "source": [
        "data[(data['등급'] == 'NP') | (data['등급'] == 'F') | (data['등급'] == 'FA')]"
      ],
      "execution_count": 181,
      "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>교과목명</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>35</th>\n",
              "      <td>33</td>\n",
              "      <td>2017</td>\n",
              "      <td>1학기</td>\n",
              "      <td>008364</td>\n",
              "      <td>세종사회봉사1</td>\n",
              "      <td>교필</td>\n",
              "      <td></td>\n",
              "      <td>인성과창의력</td>\n",
              "      <td>1</td>\n",
              "      <td>P/NP</td>\n",
              "      <td>NP</td>\n",
              "      <td>0.0</td>\n",
              "      <td>9001</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "    순번    년도   학기    학수번호     교과목명 이수구분 교직영역    선택영역  학점  평가방식  등급   평점 개설학과코드\n",
              "35  33  2017  1학기  008364  세종사회봉사1   교필       인성과창의력   1  P/NP  NP  0.0   9001"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 181
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "JGmfc9-dVL6_"
      },
      "source": [
        "drop_index = data[(data['등급'] == 'NP') | (data['등급'] == 'F') | (data['등급'] == 'FA')].index"
      ],
      "execution_count": 182,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "btZT-bS5VI0K"
      },
      "source": [
        "data = data.drop(drop_index)"
      ],
      "execution_count": 183,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "XP0zNm8mNGss",
        "outputId": "766103f7-62bc-4537-9a16-6c30dfa73bd2"
      },
      "source": [
        "data"
      ],
      "execution_count": 184,
      "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>교과목명</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>3</th>\n",
              "      <td>1</td>\n",
              "      <td>2021</td>\n",
              "      <td>1학기</td>\n",
              "      <td>003284</td>\n",
              "      <td>컴퓨터네트워크</td>\n",
              "      <td>전필</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>3</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>A0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3232</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2</td>\n",
              "      <td>2021</td>\n",
              "      <td>1학기</td>\n",
              "      <td>004599</td>\n",
              "      <td>통신시스템</td>\n",
              "      <td>전선</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>3</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>A+</td>\n",
              "      <td>4.5</td>\n",
              "      <td>3232</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>3</td>\n",
              "      <td>2021</td>\n",
              "      <td>1학기</td>\n",
              "      <td>004763</td>\n",
              "      <td>과학사</td>\n",
              "      <td>교선1</td>\n",
              "      <td></td>\n",
              "      <td>자연과과학기술</td>\n",
              "      <td>3</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>B0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>9005</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>4</td>\n",
              "      <td>2021</td>\n",
              "      <td>1학기</td>\n",
              "      <td>010000</td>\n",
              "      <td>기계학습</td>\n",
              "      <td>전필</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>3</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>A+</td>\n",
              "      <td>4.5</td>\n",
              "      <td>3232</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>5</td>\n",
              "      <td>2021</td>\n",
              "      <td>1학기</td>\n",
              "      <td>010132</td>\n",
              "      <td>유니스토리</td>\n",
              "      <td>교선1</td>\n",
              "      <td></td>\n",
              "      <td>자연과과학기술</td>\n",
              "      <td>3</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>B+</td>\n",
              "      <td>3.5</td>\n",
              "      <td>9005</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>6</td>\n",
              "      <td>2021</td>\n",
              "      <td>1학기</td>\n",
              "      <td>010227</td>\n",
              "      <td>컴퓨터구조및운영체제</td>\n",
              "      <td>전필</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>3</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>A+</td>\n",
              "      <td>4.5</td>\n",
              "      <td>3231</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>7</td>\n",
              "      <td>2020</td>\n",
              "      <td>2학기</td>\n",
              "      <td>005246</td>\n",
              "      <td>신호및시스템</td>\n",
              "      <td>전선</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>3</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>A+</td>\n",
              "      <td>4.5</td>\n",
              "      <td>3232</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>8</td>\n",
              "      <td>2020</td>\n",
              "      <td>2학기</td>\n",
              "      <td>006237</td>\n",
              "      <td>웹프로그래밍</td>\n",
              "      <td>전선</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>3</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>A+</td>\n",
              "      <td>4.5</td>\n",
              "      <td>3232</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>9</td>\n",
              "      <td>2020</td>\n",
              "      <td>2학기</td>\n",
              "      <td>008932</td>\n",
              "      <td>동양고전강독2</td>\n",
              "      <td>교선1</td>\n",
              "      <td></td>\n",
              "      <td>사상과역사</td>\n",
              "      <td>1</td>\n",
              "      <td>P/NP</td>\n",
              "      <td>P</td>\n",
              "      <td>0.0</td>\n",
              "      <td>9005</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>10</td>\n",
              "      <td>2020</td>\n",
              "      <td>2학기</td>\n",
              "      <td>009489</td>\n",
              "      <td>세계사:인간과문명</td>\n",
              "      <td>교선1</td>\n",
              "      <td></td>\n",
              "      <td>사상과역사</td>\n",
              "      <td>3</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>B+</td>\n",
              "      <td>3.5</td>\n",
              "      <td>9005</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>11</td>\n",
              "      <td>2020</td>\n",
              "      <td>2학기</td>\n",
              "      <td>009938</td>\n",
              "      <td>동서양고전문학강독</td>\n",
              "      <td>교선1</td>\n",
              "      <td></td>\n",
              "      <td>사상과역사</td>\n",
              "      <td>1</td>\n",
              "      <td>P/NP</td>\n",
              "      <td>P</td>\n",
              "      <td>0.0</td>\n",
              "      <td>9005</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>12</td>\n",
              "      <td>2020</td>\n",
              "      <td>2학기</td>\n",
              "      <td>009954</td>\n",
              "      <td>알고리즘및실습</td>\n",
              "      <td>전필</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>4</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>A+</td>\n",
              "      <td>4.5</td>\n",
              "      <td>3232</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>13</td>\n",
              "      <td>2020</td>\n",
              "      <td>2학기</td>\n",
              "      <td>009959</td>\n",
              "      <td>확률통계및프로그래밍</td>\n",
              "      <td>전필</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>3</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>A0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3232</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>14</td>\n",
              "      <td>2020</td>\n",
              "      <td>2학기</td>\n",
              "      <td>010354</td>\n",
              "      <td>English Reading Practice 1</td>\n",
              "      <td>교필</td>\n",
              "      <td></td>\n",
              "      <td>학문기초</td>\n",
              "      <td>2</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>B0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>9005</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>15</td>\n",
              "      <td>2020</td>\n",
              "      <td>2학기</td>\n",
              "      <td>010542</td>\n",
              "      <td>K-MOOC:일반인을위한물리코딩</td>\n",
              "      <td>교선2</td>\n",
              "      <td></td>\n",
              "      <td>생명과 과학</td>\n",
              "      <td>1</td>\n",
              "      <td>P/NP</td>\n",
              "      <td>P</td>\n",
              "      <td>0.0</td>\n",
              "      <td>9005</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>16</td>\n",
              "      <td>2020</td>\n",
              "      <td>1학기</td>\n",
              "      <td>004118</td>\n",
              "      <td>디지털시스템</td>\n",
              "      <td>전필</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>3</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>A0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3232</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>17</td>\n",
              "      <td>2020</td>\n",
              "      <td>1학기</td>\n",
              "      <td>005130</td>\n",
              "      <td>JAVA프로그래밍</td>\n",
              "      <td>전선</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>3</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>A+</td>\n",
              "      <td>4.5</td>\n",
              "      <td>3232</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>18</td>\n",
              "      <td>2020</td>\n",
              "      <td>1학기</td>\n",
              "      <td>008914</td>\n",
              "      <td>서양고전강독1</td>\n",
              "      <td>교선1</td>\n",
              "      <td></td>\n",
              "      <td>사상과역사</td>\n",
              "      <td>1</td>\n",
              "      <td>P/NP</td>\n",
              "      <td>P</td>\n",
              "      <td>0.0</td>\n",
              "      <td>9005</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>19</td>\n",
              "      <td>2020</td>\n",
              "      <td>1학기</td>\n",
              "      <td>009952</td>\n",
              "      <td>자료구조및실습</td>\n",
              "      <td>전필</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>4</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>A0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3232</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>20</td>\n",
              "      <td>2020</td>\n",
              "      <td>1학기</td>\n",
              "      <td>009961</td>\n",
              "      <td>선형대수및프로그래밍</td>\n",
              "      <td>전필</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>3</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>A+</td>\n",
              "      <td>4.5</td>\n",
              "      <td>3232</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>21</td>\n",
              "      <td>2020</td>\n",
              "      <td>1학기</td>\n",
              "      <td>010224</td>\n",
              "      <td>창의SW기초설계</td>\n",
              "      <td>전필</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>3</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>A0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3232</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>22</td>\n",
              "      <td>2020</td>\n",
              "      <td>1학기</td>\n",
              "      <td>010410</td>\n",
              "      <td>K-MOOC:웨어러블컴퓨터디자인</td>\n",
              "      <td>교선1</td>\n",
              "      <td></td>\n",
              "      <td>융합과창업</td>\n",
              "      <td>1</td>\n",
              "      <td>P/NP</td>\n",
              "      <td>P</td>\n",
              "      <td>0.0</td>\n",
              "      <td>9005</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>23</td>\n",
              "      <td>2020</td>\n",
              "      <td>1학기</td>\n",
              "      <td>010543</td>\n",
              "      <td>K-MOOC:코딩과스토리텔링</td>\n",
              "      <td>교선1</td>\n",
              "      <td></td>\n",
              "      <td>자연과과학기술</td>\n",
              "      <td>1</td>\n",
              "      <td>P/NP</td>\n",
              "      <td>P</td>\n",
              "      <td>0.0</td>\n",
              "      <td>9005</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>24</td>\n",
              "      <td>2017</td>\n",
              "      <td>2학기</td>\n",
              "      <td>000304</td>\n",
              "      <td>공업수학1</td>\n",
              "      <td>기교</td>\n",
              "      <td></td>\n",
              "      <td>생명과자연</td>\n",
              "      <td>3</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>B+</td>\n",
              "      <td>3.5</td>\n",
              "      <td>9005</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>25</td>\n",
              "      <td>2017</td>\n",
              "      <td>2학기</td>\n",
              "      <td>008379</td>\n",
              "      <td>전산개론-C</td>\n",
              "      <td>교선2</td>\n",
              "      <td></td>\n",
              "      <td>생명과자연</td>\n",
              "      <td>3</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>A+</td>\n",
              "      <td>4.5</td>\n",
              "      <td>9005</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>26</td>\n",
              "      <td>2017</td>\n",
              "      <td>2학기</td>\n",
              "      <td>009068</td>\n",
              "      <td>서양철학:쟁점과토론</td>\n",
              "      <td>교필</td>\n",
              "      <td></td>\n",
              "      <td>인성과창의력</td>\n",
              "      <td>2</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>B+</td>\n",
              "      <td>3.5</td>\n",
              "      <td>9005</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>27</td>\n",
              "      <td>2017</td>\n",
              "      <td>2학기</td>\n",
              "      <td>009913</td>\n",
              "      <td>고급C프로그래밍및실습</td>\n",
              "      <td>전필</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>4</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>A+</td>\n",
              "      <td>4.5</td>\n",
              "      <td>3230</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>28</td>\n",
              "      <td>2017</td>\n",
              "      <td>2학기</td>\n",
              "      <td>009955</td>\n",
              "      <td>이산수학및프로그래밍</td>\n",
              "      <td>전선</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>3</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>B+</td>\n",
              "      <td>3.5</td>\n",
              "      <td>3230</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>29</td>\n",
              "      <td>2017</td>\n",
              "      <td>2학기</td>\n",
              "      <td>010223</td>\n",
              "      <td>창의융합노마드</td>\n",
              "      <td>전선</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>3</td>\n",
              "      <td>P/NP</td>\n",
              "      <td>P</td>\n",
              "      <td>0.0</td>\n",
              "      <td>3230</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>30</td>\n",
              "      <td>2017</td>\n",
              "      <td>2학기</td>\n",
              "      <td>010353</td>\n",
              "      <td>English Listening Practice 2</td>\n",
              "      <td>교필</td>\n",
              "      <td></td>\n",
              "      <td>학문기초</td>\n",
              "      <td>2</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>B+</td>\n",
              "      <td>3.5</td>\n",
              "      <td>9005</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>31</td>\n",
              "      <td>2017</td>\n",
              "      <td>2학기</td>\n",
              "      <td>010409</td>\n",
              "      <td>K-MOOC:게임인공지능</td>\n",
              "      <td>교선1</td>\n",
              "      <td></td>\n",
              "      <td>생명과자연</td>\n",
              "      <td>1</td>\n",
              "      <td>P/NP</td>\n",
              "      <td>P</td>\n",
              "      <td>0.0</td>\n",
              "      <td>9005</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>32</td>\n",
              "      <td>2017</td>\n",
              "      <td>1학기</td>\n",
              "      <td>002647</td>\n",
              "      <td>일반물리학및실험1</td>\n",
              "      <td>기교</td>\n",
              "      <td></td>\n",
              "      <td>생명과자연</td>\n",
              "      <td>3</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>B0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>9001</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>34</td>\n",
              "      <td>2017</td>\n",
              "      <td>1학기</td>\n",
              "      <td>009067</td>\n",
              "      <td>문제해결을위한글쓰기와발표</td>\n",
              "      <td>교필</td>\n",
              "      <td></td>\n",
              "      <td>학문기초</td>\n",
              "      <td>2</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>B+</td>\n",
              "      <td>3.5</td>\n",
              "      <td>9001</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>35</td>\n",
              "      <td>2017</td>\n",
              "      <td>1학기</td>\n",
              "      <td>009790</td>\n",
              "      <td>고급프로그래밍입문-P</td>\n",
              "      <td>교선1</td>\n",
              "      <td></td>\n",
              "      <td>자연과과학기술</td>\n",
              "      <td>3</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>A0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>9001</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>36</td>\n",
              "      <td>2017</td>\n",
              "      <td>1학기</td>\n",
              "      <td>009912</td>\n",
              "      <td>C프로그래밍및실습</td>\n",
              "      <td>전필</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>4</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>A+</td>\n",
              "      <td>4.5</td>\n",
              "      <td>3230</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>37</td>\n",
              "      <td>2017</td>\n",
              "      <td>1학기</td>\n",
              "      <td>010140</td>\n",
              "      <td>일변수미적분학</td>\n",
              "      <td>기교</td>\n",
              "      <td></td>\n",
              "      <td>생명과자연</td>\n",
              "      <td>3</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>B+</td>\n",
              "      <td>3.5</td>\n",
              "      <td>9001</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>38</td>\n",
              "      <td>2017</td>\n",
              "      <td>1학기</td>\n",
              "      <td>010351</td>\n",
              "      <td>대학생활과진로설계</td>\n",
              "      <td>교필</td>\n",
              "      <td></td>\n",
              "      <td>역량강화</td>\n",
              "      <td>1</td>\n",
              "      <td>P/NP</td>\n",
              "      <td>P</td>\n",
              "      <td>0.0</td>\n",
              "      <td>3230</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>39</td>\n",
              "      <td>2017</td>\n",
              "      <td>1학기</td>\n",
              "      <td>010352</td>\n",
              "      <td>English Listening Practice 1</td>\n",
              "      <td>교필</td>\n",
              "      <td></td>\n",
              "      <td>학문기초</td>\n",
              "      <td>2</td>\n",
              "      <td>GRADE</td>\n",
              "      <td>B+</td>\n",
              "      <td>3.5</td>\n",
              "      <td>9001</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "    순번    년도   학기    학수번호  ...   평가방식  등급   평점 개설학과코드\n",
              "3    1  2021  1학기  003284  ...  GRADE  A0  4.0   3232\n",
              "4    2  2021  1학기  004599  ...  GRADE  A+  4.5   3232\n",
              "5    3  2021  1학기  004763  ...  GRADE  B0  3.0   9005\n",
              "6    4  2021  1학기  010000  ...  GRADE  A+  4.5   3232\n",
              "7    5  2021  1학기  010132  ...  GRADE  B+  3.5   9005\n",
              "8    6  2021  1학기  010227  ...  GRADE  A+  4.5   3231\n",
              "9    7  2020  2학기  005246  ...  GRADE  A+  4.5   3232\n",
              "10   8  2020  2학기  006237  ...  GRADE  A+  4.5   3232\n",
              "11   9  2020  2학기  008932  ...   P/NP   P  0.0   9005\n",
              "12  10  2020  2학기  009489  ...  GRADE  B+  3.5   9005\n",
              "13  11  2020  2학기  009938  ...   P/NP   P  0.0   9005\n",
              "14  12  2020  2학기  009954  ...  GRADE  A+  4.5   3232\n",
              "15  13  2020  2학기  009959  ...  GRADE  A0  4.0   3232\n",
              "16  14  2020  2학기  010354  ...  GRADE  B0  3.0   9005\n",
              "17  15  2020  2학기  010542  ...   P/NP   P  0.0   9005\n",
              "18  16  2020  1학기  004118  ...  GRADE  A0  4.0   3232\n",
              "19  17  2020  1학기  005130  ...  GRADE  A+  4.5   3232\n",
              "20  18  2020  1학기  008914  ...   P/NP   P  0.0   9005\n",
              "21  19  2020  1학기  009952  ...  GRADE  A0  4.0   3232\n",
              "22  20  2020  1학기  009961  ...  GRADE  A+  4.5   3232\n",
              "23  21  2020  1학기  010224  ...  GRADE  A0  4.0   3232\n",
              "24  22  2020  1학기  010410  ...   P/NP   P  0.0   9005\n",
              "25  23  2020  1학기  010543  ...   P/NP   P  0.0   9005\n",
              "26  24  2017  2학기  000304  ...  GRADE  B+  3.5   9005\n",
              "27  25  2017  2학기  008379  ...  GRADE  A+  4.5   9005\n",
              "28  26  2017  2학기  009068  ...  GRADE  B+  3.5   9005\n",
              "29  27  2017  2학기  009913  ...  GRADE  A+  4.5   3230\n",
              "30  28  2017  2학기  009955  ...  GRADE  B+  3.5   3230\n",
              "31  29  2017  2학기  010223  ...   P/NP   P  0.0   3230\n",
              "32  30  2017  2학기  010353  ...  GRADE  B+  3.5   9005\n",
              "33  31  2017  2학기  010409  ...   P/NP   P  0.0   9005\n",
              "34  32  2017  1학기  002647  ...  GRADE  B0  3.0   9001\n",
              "36  34  2017  1학기  009067  ...  GRADE  B+  3.5   9001\n",
              "37  35  2017  1학기  009790  ...  GRADE  A0  4.0   9001\n",
              "38  36  2017  1학기  009912  ...  GRADE  A+  4.5   3230\n",
              "39  37  2017  1학기  010140  ...  GRADE  B+  3.5   9001\n",
              "40  38  2017  1학기  010351  ...   P/NP   P  0.0   3230\n",
              "41  39  2017  1학기  010352  ...  GRADE  B+  3.5   9001\n",
              "\n",
              "[38 rows x 13 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 184
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "elsnvXJsLBnY",
        "outputId": "b2fce8fe-6e5f-4a83-ec32-37aff96cdeaf"
      },
      "source": [
        "groupby_score = data.groupby('이수구분')['학점'].sum()\n",
        "groupby_score"
      ],
      "execution_count": 185,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "이수구분\n",
              "교선1    18\n",
              "교선2     4\n",
              "교필     11\n",
              "기교      9\n",
              "전선     18\n",
              "전필     37\n",
              "Name: 학점, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 185
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Xc6YAO0zV4_c"
      },
      "source": [
        "교양 = ['교선1', '교선2', '교필', '기교']"
      ],
      "execution_count": 186,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "PRd1oSzNV--Y"
      },
      "source": [
        "교양_학점 = sum(groupby_score[교양])\n",
        "전선_학점 = groupby_score['전선']\n",
        "전필_학점 = groupby_score['전필']\n",
        "총이수학점 = 교양_학점 + 전선_학점 + 전필_학점"
      ],
      "execution_count": 187,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "mvY3qd0pZMOn",
        "outputId": "ea07eaaf-0910-4d39-d317-aca6c0331430"
      },
      "source": [
        "필수_졸업학점_지능기전['전선']"
      ],
      "execution_count": 188,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "35"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 188
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "5gc0RmMYaIK0"
      },
      "source": [
        "import matplotlib.gridspec as gridspec"
      ],
      "execution_count": 189,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 601
        },
        "id": "U1qDevr-aKt3",
        "outputId": "c7173640-8768-453c-97d6-b5c240c47a5e"
      },
      "source": [
        "fig2 = plt.figure(figsize=(13,8),constrained_layout=True)\n",
        "spec2 = gridspec.GridSpec(ncols=1, nrows=4, figure=fig2)\n",
        "f2_ax1 = fig2.add_subplot(spec2[:3, 0])\n",
        "f2_ax2 = fig2.add_subplot(spec2[3, 0])\n",
        "\n",
        "f2_ax1.bar(x=['refinement', 'select', 'essential'], height= [교양_학점, 전선_학점, 전필_학점],width =0.4 ,color = 'tan' )\n",
        "f2_ax1.spines['right'].set_visible(False)\n",
        "f2_ax1.spines['top'].set_visible(False)\n",
        "f2_ax1.hlines(필수_졸업학점_지능기전['전선'], 0.8,1.2)\n",
        "f2_ax1.hlines(필수_졸업학점_지능기전['전필'], 1.8,2.2)\n",
        "\n",
        "if 필수_졸업학점_지능기전['전선']> 전선_학점:\n",
        "    value = f\"{필수_졸업학점_지능기전['전선'] - 전선_학점} need\"\n",
        "    f2_ax1.text(s=value, x='select',y=필수_졸업학점_지능기전['전선']+1,va='center', ha='center',fontsize=20)\n",
        "\n",
        "if 필수_졸업학점_지능기전['전필']> 전필_학점:\n",
        "    value = f\"{필수_졸업학점_지능기전['전필'] - 전필_학점} need\"\n",
        "    f2_ax1.text(s=value, x='select',y=필수_졸업학점_지능기전['전필']+1,va='center', ha='center',fontsize=20)\n",
        "\n",
        "f2_ax2.barh(y='total', width=총이수학점, color = 'khaki')\n",
        "f2_ax2.spines['top'].set_visible(False)\n",
        "f2_ax2.spines['right'].set_visible(False)\n",
        "f2_ax2.spines['bottom'].set_visible(False)\n",
        "f2_ax2.vlines(필수_졸업학점_지능기전['총합'],-0.5,0.5)\n",
        "\n",
        "if 필수_졸업학점_지능기전['총합']> 총이수학점:\n",
        "    value = f\"{필수_졸업학점_지능기전['총합'] - 총이수학점} need\"\n",
        "    f2_ax2.text(s=value, x=필수_졸업학점_지능기전['총합'],y=0,va='center', ha='right',fontsize=20)"
      ],
      "execution_count": 190,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAA7AAAAJICAYAAABYCwgCAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nOzde7xcZZ3n+++vc1FAIaI5AQGFaUAbu0UwR2lA5SJ2GFBQGW/o6KHbyGlBYOgZcTg60F76ogzSzaCiIowwrb5swQYEVJpEbqIRgyCXcNEGEUlQQFHUkDznj12hE5JAgNp759n7/X698kqtVc+q9RSWRX1Yq1ZVay0AAACwvvuD8Z4AAAAArAsBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXpo73BNZkzpw57cILLxzvaQAAADD2am13rJdHYO+5557xngIAAADrmfUyYAEAAOCRBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAF6aO9wR6de35J4z3FFiP/cl+R4/3FAAAYMJxBBYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuDD1gq2pKVX2/qs4bLG9TVVdV1S1V9cWqmj7sfQIAADDxjcYR2COS3LDS8t8lObG1tm2Se5P8+SjsEwAAgAluqAFbVVsm2S/JZwbLlWSvJF8eDDkjyYHD3CcAAACTw7CPwH48yX9Lsnyw/Mwk97XWHhos/yTJFkPeJwAAAJPA0AK2qvZPsri19r0nuP3cqlpQVQuWLFkyrGkBAAAwQQzzCOxuSV5TVT9O8oWMnDp8UpIZVTV1MGbLJHeuaePW2qmttdmttdkzZ84c4rQAAACYCIYWsK2197XWtmytbZ3kTUn+tbV2cJJLkhw0GPb2JF8d1j4BAACYPMbid2Dfm+S/VNUtGflO7GfHYJ8AAABMMFMfe8jj11qbl2Te4PZtSV4yGvsBAABg8hiLI7AAAADwpAlYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALU8d7AgAAwPDsscce4z0F1mPz5s0b7yk8KQIWAHhMxx13XI4//vhccsklPhzDeu7XP79jvKcAo0bAAjApffnLX878+fOzcOHCXHPNNfnVr36Vgw8+OGeeeeYax7/jHe/IGWec8aiPuddee+Xiiy8ejekCrLPT/vYvx3sKMGoELACT0oc+9KFcc801edrTnpYtt9wyN95446OOP/DAA7P11luv8b7Pf/7zue2227LvvvuOwkwBgBUELACT0oknnpgtt9wy2267bebPn58999zzUccfeOCBOfDAA1dbf9999+Xv//7vM3369LzjHe8YpdkCAImrEAMwSe25557ZbrvtUlVP6nE+//nP58EHH8zrXve6POtZz1qnbebNm5eqynHHHZeFCxdmv/32y4wZM7LhhhvmFa94Ra644oo1bvfQQw/llFNOyS677JKNN944G264YXbaaaecfPLJWb58+Rq3ueqqq3LQQQdls802y/Tp07PVVlvlXe96V37605+ucfz3vve9zJkzJ09/+tOz8cYb55WvfGWuvPLKdfuHAQCjTMACwJPw6U9/Okkyd+7cx73tggULsuuuu+a3v/1t/uIv/iL7779/Lrvssuy999656aabVhm7dOnS7L///nn3u9+d++67L295y1syd+7cLF++PIcffnje/va3r/b4p512WnbbbbdccMEF2XPPPXPkkUdm9uzZ+cxnPpPZs2fn9ttvX2X8FVdckZe97GX55je/mX333TeHHXZYpk+fnj322CNXXXXV435+ADBsTiEGgCfoyiuvzLXXXpvtt9/+MU9BXpPzzz8/n/vc51Y59fhTn/pUDj300Jx00kk55ZRTHl7/4Q9/OBdddFEOO+ywfPzjH8+UKVOSJMuWLcvcuXNz2mmn5aCDDsoBBxyQJFm0aFEOPfTQbL311pk/f3622GKLhx/r4osvzqte9aocccQROfvss5MkrbUccsghefDBB3POOec8/DhJctJJJ+XII4983M8PAIbNEVgAeIJOPfXUJMk73/nOJ7T9brvtttr3Zg855JBMnTo13/nOdx5et3z58vzjP/5jNttss5x44okPx2uSTJkyJSeccEKqKmedddbD6z/xiU9k6dKlOemkk1aJ1yTZe++985rXvCbnnntufvWrXyUZOfp600035eUvf/kq8Zokhx12WP7wD//wCT1HABgmR2AB4Am4//7786UvfelJXbxp9uzZq62bNm1aZs2alXvvvffhdYsWLcovfvGLbLfddvnQhz60xsfaYIMNcsMNNzy8vOJ7q/Pnz893v/vd1cYvXrw4y5Yty6JFi/LiF784V199dZLkFa94xWpjp0yZkt133z233nrr43uCADBkAhYAnoAzzzwzv/nNb/KmN71pnS/e9EgzZsxY4/qpU6dm2bJlDy///Oc/T5LcfPPNOf7449f6eA888MBq23z0ox991Dms2Ob+++9PksyaNWuN4zbbbLNHfRwAGAsCFgCegBUXb3rXu9416vvaZJNNkiSvfe1r85WvfOVxbXP//fdn4403Xufxd9999xrv/9nPfrZO+wWA0eQ7sADwOF111VW55pprsv3222ePPfYY9f09//nPz4wZM/Ltb387S5cuXadtdtlllyTJpZdeuk7jd9555yQjpxw/0rJly3LZZZet42wBYPQIWAB4nFZcvOmJ/HTOEzF16tQcfvjhueuuu/Ke97wnDz744Gpj7rrrrlx//fUPLx922GGZNm1ajjrqqCxatGi18b///e9Xidtdd901z3ve8/Ktb30rX/3qV1cZe/LJJ/v+KwDrBacQAzApnXPOOTnnnHOS/PvpsVdeeeXDF2R61rOelY997GOrbffLX/4yX/ziF/OUpzxljb+9Olre//7355prrsknP/nJnHvuudlrr72yxRZbZPHixbn55ptz+eWX58Mf/nB22GGHJCNHbU877bQccsghecELXpA5c+Zk++23z9KlS3P77bfn0ksvzcyZM3PjjTcmSaoqn/3sZ7PPPvvk9a9/fV73utdl2223zcKFC3PxxRdnzpw5ufDCC8fs+QLAmghYACalhQsX5owzzlhl3W233ZbbbrstSfLc5z53jQF71lln5de//vWTunjTEzFt2rScc845OfPMM3P66afnvPPOywMPPJCZM2dmm222yQc/+MEcfPDBq2zz1re+NTvuuGNOOOGEXHLJJfn617+ejTbaKM9+9rNz0EEH5Y1vfOMq43fbbbdceumlOfbYY3PBBRckSV760pdm3rx5ueiiiwQsAOOuWmvDeaCqpyb5VpKnZCSMv9xa+x9VdXqSVyS5fzD0Ha21hY/2WLNnz24LFiwYyrxGy7XnnzDeU2A99if7HT3eUwAAJimfU3k0nXxOrbXdMcwjsL9Lsldr7YGqmpbksqq6YHDff22tfXmI+wIAAGCSGVrAtpFDuSt+gG7a4M9wDu8CMKGNxZV86de8efPGewoArCeGehXiqppSVQuTLE7yjdbaVYO7PlxVP6iqE6vqKWvZdm5VLaiqBUuWLBnmtAAAAJgAhnoRp9basiQvqqoZSc6uqj9O8r4kP0syPcmpSd6b5K/XsO2pg/sze/ZsR24BJhFH2ACAdTEqvwPbWrsvySVJ5rTW7mojfpfkc0leMhr7BAAAYGIbWsBW1czBkddU1QZJ9klyY1VtPlhXSQ5Mct2w9gkAAMDkMcxTiDdPckZVTclIGH+ptXZeVf1rVc3MyKWQFyY5dIj7BAAAYJIY5lWIf5BkpzWs32tY+wAAAGDyGpXvwAIAAMCwCVgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALQwvYqnpqVX2nqq6pqh9W1fGD9dtU1VVVdUtVfbGqpg9rnwAAAEwewzwC+7ske7XWdkzyoiRzqmqXJH+X5MTW2rZJ7k3y50PcJwAAAJPE0AK2jXhgsDht8Kcl2SvJlwfrz0hy4LD2CQAAwOQx1O/AVtWUqlqYZHGSbyS5Ncl9rbWHBkN+kmSLtWw7t6oWVNWCJUuWDHNaAAAATABDDdjW2rLW2ouSbJnkJUme/zi2PbW1Nru1NnvmzJnDnBYAAAATwKhchbi1dl+SS5L8aZIZVTV1cNeWSe4cjX0CAAAwsQ3zKsQzq2rG4PYGSfZJckNGQvagwbC3J/nqsPYJAADA5DH1sYess82TnFFVUzISxl9qrZ1XVdcn+UJVfSjJ95N8doj7BAAAYJIYWsC21n6QZKc1rL8tI9+HBQAAgCdsVL4DCwAAAMMmYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAtDC9iq2qqqLqmq66vqh1V1xGD9cVV1Z1UtHPz5j8PaJwAAAJPH1CE+1kNJjm6tXV1VT0/yvar6xuC+E1trHxvivgAAAJhkhhawrbW7ktw1uP2rqrohyRbDenwAAAAmt1H5DmxVbZ1kpyRXDVYdVlU/qKrTquoZo7FPAAAAJrahB2xVPS3JPyc5srX2yySfSPKHSV6UkSO0J6xlu7lVtaCqFixZsmTY0wIAAKBzQw3YqpqWkXg9q7X2lSRprd3dWlvWWlue5NNJXrKmbVtrp7bWZrfWZs+cOXOY0wIAAGACGOZViCvJZ5Pc0Fr7nyut33ylYa9Nct2w9gkAAMDkMcyrEO+W5G1Jrq2qhYN1/z3Jm6vqRUlakh8nedcQ9wkAAMAkMcyrEF+WpNZw19eGtQ8AAAAmr1G5CjEAAAAMm4AFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6MLSAraqtquqSqrq+qn5YVUcM1m9aVd+oqpsHfz9jWPsEAABg8hjmEdiHkhzdWtshyS5J3l1VOyQ5JsnFrbXtklw8WAYAAIDHZWgB21q7q7V29eD2r5LckGSLJAckOWMw7IwkBw5rnwAAAEweo/Id2KraOslOSa5KMqu1dtfgrp8lmTUa+wQAAGBiG3rAVtXTkvxzkiNba79c+b7WWkvS1rLd3KpaUFULlixZMuxpAQAA0LmhBmxVTctIvJ7VWvvKYPXdVbX54P7Nkyxe07attVNba7Nba7Nnzpw5zGkBAAAwAQzzKsSV5LNJbmit/c+V7vqXJG8f3H57kq8Oa58AAABMHlOH+Fi7JXlbkmurauFg3X9P8rdJvlRVf57k35K8YYj7BAAAYJIYWsC21i5LUmu5e+9h7QcAAIDJaVSuQgwAAADDJmABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6MHW8JwAA155/wnhPgfXYn+x39HhPAYD1hCOwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQhaEFbFWdVlWLq+q6ldYdV1V3VtXCwZ//OKz9AQAAMLkM8wjs6UnmrGH9ia21Fw3+fG2I+wMAAGASGVrAtta+leQXw3o8AAAAWNlYfAf2sKr6weAU42eMwf4AAACYgEY7YD+R5A+TvCjJXUlOWNvAqppbVQuqasGSJUtGeVoAAAD0ZlQDtrV2d2ttWWtteZJPJ3nJo4w9tbU2u7U2e+bMmaM5LQAAADo0qgFbVZuvtPjaJNetbSwAAAA8mqnDeqCq+qckeyR5VlX9JMn/SLJHVb0oSUvy4yTvGtb+AAAAmFyGFrCttTevYfVnh/X4AAAATG5jcRViAAAAeNIELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0IWhBWxVnVZVi6vqupXWbVpV36iqmwd/P2NY+wMAAGByGeYR2NOTzHnEumOSXNxa2y7JxYNlAAAAeNyGFrCttW8l+cUjVh+Q5IzB7TOSHDis/QEAADC5jPZ3YGe11u4a3P5ZkllrG1hVc6tqQVUtWLJkyShPCwAAgN6M2UWcWmstSXuU+09trc1urc2eOXPmWE0LAACATox2wN5dVZsnyeDvxaO8PwAAACao0Q7Yf0ny9sHttyf56ijvDwAAgAlqmD+j809JrkzyvKr6SVX9eZK/TbJPVd2c5JWDZQAAAHjcpg7rgVprb17LXXsPax8AAABMXmN2EScAAAB4MgQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQhaljsZOq+nGSXyVZluSh1trssdgvAAAAE8eYBOzAnq21e8ZwfwAAAEwgTiEGAACgC2MVsC3J16vqe1U1d00DqmpuVS2oqgVLliwZo2kBAADQi7EK2N1bazsn2TfJu6vq5Y8c0Fo7tbU2u7U2e+bMmWM0LQAAAHoxJgHbWrtz8PfiJGcneclY7BcAAICJY9QDtqo2qqqnr7id5FVJrhvt/QIAADCxjMVViGclObuqVuzv/7TWLhyD/QIAADCBjHrAttZuS7LjaO8HAACAic3P6AAAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRhTAK2quZU1U1VdUtVHTMW+wQAAGBiGfWAraopSf5Xkn2T7JDkzVW1w2jvFwAAgIllLI7AviTJLa2121prv0/yhSQHjMF+AQAAmECmjsE+tkhyx0rLP0ny0kcOqqq5SeYOFh+oqpvGYG4Mz7OS3DPek1h//NV4TwDom/fUVXhPBZ4U76mr6OI99cLW2pw13TEWAbtOWmunJjl1vOfBE1NVC1prs8d7HgATgfdUgOHxnjqxjMUpxHcm2Wql5S0H6wAAAGCdjUXAfjfJdlW1TVVNT/KmJP8yBvsFAABgAhn1U4hbaw9V1WFJLkoyJclprbUfjvZ+GXNO/wYYHu+pAMPjPXUCqdbaeM8BAAAAHtNYnEIMAAAAT5qABQAAoAsCllTVe6rqhqo6q6peU1XHjPecHqmq/vt4zwFgNFXV6VV10BPYbuuqestozAlgonvkZ8yqumIdtnlg9GbEY/Ed2Emiqioj/3svX8N9NyZ5ZWvtJ2M/s3VTVQ+01p423vMAGC1VdXqS81prX36c2+2R5K9aa/uPxrwAJrIn8hnT59Lx5QjsBDb4r/I3VdX/TnJdkvdX1Xer6gdVdfxgzCeT/IckF1TVUVX1jqo6eXDf6VX1D1V1RVXdtvKRgar6r2t4rK2r6sbBdosGR3RfWVWXV9XNVfWSwbiNquq0qvpOVX2/qg4YrH9HVX2lqi4cjP/7wfq/TbJBVS2sqrPG8B8hwJMyeL87v6quqarrquqNVfXiqppfVd+rqouqavM1bLfGMVW1bVV9c/B4V1fVHyb52yQvG7xHHjXWzxFgmKrqrYPPiAur6lNVNWXw2fK6qrp2xfvc4AzC6wefRb8wWPekP2OuOLpaVU+rqosH77XXrngsxp8jsBNYVW2d5LYkuybZOMlBSd6VpDLyW7x/31r7VlX9OMns1to9VfWOwe3DBkcDNkryxiTPT/IvrbVtq+pVa3qsJLcnuSXJTkl+mJHfAL4myZ8neU2S/6e1dmBVfSTJ9a21M6tqRpLvDLb5T0k+MLj9uyQ3Jdm9tXaH/9IF9KiqXp9kTmvtnYPlTZJckOSA1tqSqnpjkj9rrR2y4ghskq8mmb+WMVcl+dvW2tlV9dSM/Ifol8QRWGACqKo/yshnyte11pZW1SlJ7s7I58F9BmNmtNbuq6qfJtmmtfa7ldY96c+YK5aramqSDVtrv6yqZyX5dpLtWmvN59LxNeq/A8u4+7fW2rer6mNJXpXk+4P1T0uyXZJvPcb25wxOO76+qmYN1r1qLY91e5IftdauTZKq+mGSiwf/R782ydYrbf+aqvqrwfJTkzxncPvi1tr9g+2vT/LcJHc8/qcNsF64NskJVfV3GYnTe5P8cZJvVFUy8vvodz1im+etaUxVPT3JFq21s5OktfbbJBmMAZgI9k7y4iTfHby3bZDkwiT/oar+Mcn5Sb4+GPuDJGdV1TlJzhmsG+ZnzErykap6eZLlSbZIMivJz57sk+TJEbAT368Hf1eSv2mtfepxbv+7lW7XSn+v9liDI74rj1++0vLy/PvrrZK8vrV20yO2f+kjtl8Wr1GgY621RVW1c5L/mORDSf41yQ9ba3/6KJvVmsYMAhZgIqskZ7TW3rfKyqpjk/xZkkOTvCHJIUn2S/LyJK9OcmxV/UmG+xnz4CQzk7x4cDT4xxkJYsaZ78BOHhclOaSqnpYkVbVFVf1f4/RYFyU5vAb/aa2qdlqHbZZW1bTHP1WA8VNVz07ym9bamUk+muSlSWZW1Z8O7p9WVS94xGY3rWlMa+1XSX5SVQcO1j+lqjZM8qsk4haYCC5OctCKz5VVtWlVPTfJH7TW/jnJ/5dk56r6gyRbtdYuSfLeJJtk5IzAYX7G3CTJ4kG87pmRI7asBxzdmiRaa18ffK/gysH/px9I8tYki4f4WMvW8SE+mOTjSX4weAP6UZLH+u7WqYPxV7fWDn68cwYYJ3+S5KNVtTzJ0iT/b5KHkvzD4PuwUzPyfvjDFRu01n5fIxfNW9OYtyX5VFX99eDx/lNGTqNbVlXXJDm9tXbimD07gCFqrV1fVf9fkq8PPiMuTfJfkpw9WE6S92XkqxVnDt4jK8k/DL4DO8zPmGclOXfwNbgFSW4c0tPkSXIRJwAAALrgFGIAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALowdbwnsCZz5sxpF1544XhPAwAAgLFXa7tjvTwCe88994z3FAAAAFjPrJcBCwAAAI8kYAEAAOiCgAUAAKALAhYAAIAuCFgAAIAJbI899sgee+wx3tMYCgELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0Yep4T2BNli29O/ffdcJ4TwMAgDGyyeZHj/cUgA44AgsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAon5nVgAABElSURBVAAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAATzHHHHZeqyrx588Z7KkMlYAEAgPXee9/73uy9997ZaqutssEGG2TTTTfNTjvtlOOPPz4///nPVxt/xx135C//8i/z0pe+NJtttlme8pSn5NnPfnZe9rKX5XOf+1yWLl06Ds+CJ0vAAgAA670TTzwxv/71r7PPPvvkiCOOyMEHH5ypU6fmuOOOywtf+MLccccdq4y/9dZbc9ZZZ2WTTTbJgQcemKOPPjqvfvWr82//9m855JBD8md/9md56KGHxunZ8ERNHe8JAAAAPJZf/vKXeepTn7ra+mOPPTYf+chH8jd/8zc55ZRTHl6/66675t57780f/MGqx+yWLl2aV73qVbnkkkvyla98JW94wxtGfe4MjyOwAADAem9N8Zrk4QC9+eabV1k/ffr01eI1SaZNm5YDDzxwjduszbx581JVOe6447Jw4cLst99+mTFjRjbccMO84hWvyBVXXLHG7R566KGccsop2WWXXbLxxhtnww03zE477ZSTTz45y5cvX+M2V111VQ466KBsttlmmT59erbaaqu8613vyk9/+tM1jv/e976XOXPm5OlPf3o23njjvPKVr8yVV165Ts+rR48asFU1o6r+8jHGbF1Vb3msHQ3GXfd4JwgAALA25557bpLkhS984TqNX7ZsWb72ta89rm1WWLBgQXbdddf89re/zV/8xV9k//33z2WXXZa99947N9100ypjly5dmv333z/vfve7c9999+Utb3lL5s6dm+XLl+fwww/P29/+9tUe/7TTTstuu+2WCy64IHvuuWeOPPLIzJ49O5/5zGcye/bs3H777auMv+KKK/Kyl70s3/zmN7PvvvvmsMMOy/Tp07PHHnvkqquuelzPrRePdQrxjCR/meSURxmzdZK3JPk/Q5oTAADAGn3sYx/LAw88kPvvvz8LFizIZZddlhe+8IU55phj1jj+nnvuycknn5zWWpYsWZJvfOMbueWWW/KWt7wlr371qx/Xvs8///x87nOfyzve8Y6H133qU5/KoYcempNOOmmVU5g//OEP56KLLsphhx2Wj3/845kyZUqSkYCeO3duTjvttBx00EE54IADkiSLFi3KoYcemq233jrz58/PFlts8fBjXXzxxXnVq16VI444ImeffXaSpLWWQw45JA8++GDOOeechx8nSU466aQceeSRj+u59aJaa2u/s+oLSQ5IclOSbwxW75ukJflQa+2LVfXtJH+U5EdJzkhydpLPJ9loMP6w1toVVbV1kvNaa3/8WJPaacet2rwLJ+Y/cAAAVrfJ5keP9xToxGabbZa777774eU5c+bk9NNPz6xZs9Y4/sYbb8wf/dEfPbxcVTn66KPzkY98JNOmTVunfc6bNy977rlndtttt1x22WWr3Ld06dJsuOGG2XHHHbNgwYIkyfLlyzNz5sxMnz49d9xxR6ZOXfW44X333ZdNN900Bx10UL70pS8lSY466qh8/OMfz3nnnZf99ttvtTm89rWvzbnnnpt77703T3/603P55Zdn9913z8tf/vLMnz9/lbHLli3L8573vNx666255JJLctxxxz38PDpRa7vjsY7AHpPkj1trL6qq1yc5NMmOSZ6V5LtV9a3BmL9qre2fJFW1YZJ9Wmu/rartkvxTktlDeBIAAMAk97Of/SxJcvfdd+eKK67IMccck5122innnXdedt5559XGP//5z09rLcuWLcudd96Zs88+Ox/4wAdy2WWX5fzzz8+mm266zvuePXv1rJk2bVpmzZqVe++99+F1ixYtyi9+8Ytst912+dCHPrTGx9pggw1yww03PLy84nur8+fPz3e/+93Vxi9evDjLli3LokWL8uIXvzhXX311kuQVr3jFamOnTJmS3XffPbfeeus6P7dePJ6rEO+e5J9aa8uS3F1V85P830l++Yhx05KcXFUvSrIsyfbr8uBVNTfJ3CTZaotnPI5pAQAAk82sWbPy2te+NjvvvHO23377/Of//J9z3XVrv+TOlClT8pznPCdHHHFEZs2alTe/+c35wAc+kJNPPnmd9zljxow1rp86dWqWLVv28PKK36W9+eabc/zxx6/18R544IHVtvnoRz/6qHNYsc3999+fJGs98rzZZps96uP0ajSuQnxUkrszcqR2dpLp67JRa+3U1trs1trsZz5zo8feAAAAmPSe+9znZocddsgPf/jD3HPPPeu0zb777ptk9E6p3WSTTZKMnPbbWlvrnx/96EerbXP//fc/6jYrjriuGL/y6dQrW3GkeqJ5rID9VZKnD25fmuSNVTWlqmYmeXmS7zxiTJJskuSu1tryJG9LMmW4UwYAAPh3K35iZsWFkh7LnXfemSSrfTd1WJ7//OdnxowZ+fa3v52lS5eu0za77LJLkuTSSy9dp/ErTpd+5Pdfk5HvwD7yu7oTxaMGbGvt50kuH/z8zZ8m+UGSa5L8a5L/1lr72WDdsqq6pqqOysgVi99eVdckeX6SX4/mEwAAACa2RYsWPXzK7MqWL1+eY489NosXL86uu+6aZzzj37+KePXVV69yWu8KDzzwQI444ogkWePFkoZh6tSpOfzww3PXXXflPe95Tx588MHVxtx11125/vrrH14+7LDDMm3atBx11FFZtGjRauN///vfrxK3u+66a573vOflW9/6Vr761a+uMvbkk0+ekN9/TdbhO7CttUf+xut/fcT9S5Ps9YgxK/+g0nsH436c5DGvQAwAALCyr33ta3nf+96X3XffPdtss02e+cxn5u677878+fNz2223ZbPNNsunP/3pVbb567/+61x++eXZdddd85znPCcbbrhh7rjjjlxwwQW57777suuuu+Z973vfqM35/e9/f6655pp88pOfzLnnnpu99torW2yxRRYvXpybb745l19+eT784Q9nhx12SDJy1Pa0007LIYcckhe84AWZM2dOtt9++yxdujS33357Lr300sycOTM33nhjkpGrKX/2s5/NPvvsk9e//vV53etel2233TYLFy7MxRdfnDlz5uTCCy8ctec3XkbnmDkAAMCQvPKVr8wtt9ySyy67LN///vdz3333ZaONNsr222+ft73tbXnPe96z2tWE3/nOd+ZpT3tavvOd72TevHn5zW9+k2c84xl58YtfnDe84Q055JBDRu0U4mTk6sTnnHNOzjzzzJx++uk577zz8sADD2TmzJnZZptt8sEPfjAHH3zwKtu89a1vzY477pgTTjghl1xySb7+9a9no402yrOf/ewcdNBBeeMb37jK+N122y2XXnppjj322FxwwQVJkpe+9KWZN29eLrroogkZsI/6O7Djxe/AAgBMLn4HFkbPHnvskWRi/A7saFyFGAAAAIZOwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0Yep4T2BNpkyblU02P3q8pwEAAMB6xBFYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgC1PHewIAAACMnnnz5o33FIbGEVgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAulCttfGew2qq6rrW2h+P9zxYP1TV3NbaqeM9D9YPXg+szOuBlXk9sILXAivzephY1tcjsL8d7wmwXpk73hNgveL1wMq8HliZ1wMreC2wMq+HCWR9DVgAAABYhYAFAACgC+trwDpHnZV5PbAyrwdW5vXAyrweWMFrgZV5PUwg6+VFnAAAAOCR1tcjsAAAALCK9Spgq2pOVd1UVbdU1THjPR/GVlVtVVWXVNX1VfXDqjpisH7TqvpGVd08+PsZ4z1Xxk5VTamq71fVeYPlbarqqsH7xBeravp4z5GxUVUzqurLVXVjVd1QVX/q/WHyqqqjBv+uuK6q/qmqnur9YfKoqtOqanFVXbfSujW+H9SIfxi8Ln5QVTuP38wZDWt5PXx08O+LH1TV2VU1Y6X73jd4PdxUVX82PrPmiVpvAraqpiT5X0n2TbJDkjdX1Q7jOyvG2ENJjm6t7ZBklyTvHrwGjklycWttuyQXD5aZPI5IcsNKy3+X5MTW2rZJ7k3y5+MyK8bDSUkubK09P8mOGXldeH+YhKpqiyTvSTJ78LvxU5K8Kd4fJpPTk8x5xLq1vR/sm2S7wZ+5ST4xRnNk7Jye1V8P30jyx621FyZZlOR9STL4bPmmJC8YbHPKoEPoxHoTsElekuSW1tptrbXfJ/lCkgPGeU6ModbaXa21qwe3f5WRD6dbZOR1cMZg2BlJDhyfGTLWqmrLJPsl+cxguZLsleTLgyFeD5NEVW2S5OVJPpskrbXft9bui/eHyWxqkg2qamqSDZPcFe8Pk0Zr7VtJfvGI1Wt7Pzggyf9uI76dZEZVbT42M2UsrOn10Fr7emvtocHit5NsObh9QJIvtNZ+11r7UZJbMtIhdGJ9Ctgtktyx0vJPBuuYhKpq6yQ7JbkqyazW2l2Du36WZNY4TYux9/Ek/y3J8sHyM5Pct9K/kLxPTB7bJFmS5HODU8o/U1UbxfvDpNRauzPJx5LcnpFwvT/J9+L9YbJb2/uBz5gckuSCwW2vh86tTwELSZKqelqSf05yZGvtlyvf10Yum+3S2ZNAVe2fZHFr7XvjPRfWC1OT7JzkE621nZL8Oo84Xdj7w+Qx+G7jARn5DxvPTrJRVj99kEnM+wErVNWxGfma2lnjPReGY30K2DuTbLXS8paDdUwiVTUtI/F6VmvtK4PVd6841Wfw9+Lxmh9jarckr6mqH2fkKwV7ZeQ7kDMGpwwm3icmk58k+Ulr7arB8pczErTeHyanVyb50f/f3h26SBVFcRz/HoRdMIpRRAWxGjcYFiwii0lUWHFdMPgHWFaDGKwmq1bBIDrFpsEiKmwQ1iaoRRGDZUEUfob7ZJfFKYIz8/Z9P2mYdxlOuJz3zp177kvyNclP4BEtZ5gfhm1cPvAZc6Cq6jKwBCxn692hzoeem6UC9jVwtDtBcI7WXD2ackyaoK6/8R7wLsmdbZdGwEr3eQV4MunYNHlJ1pIcSHKIlg+eJVkGngNnu2HOh4FI8hn4VFXHuq9OAhuYH4bqI7BQVXu7e8ef+WB+GLZx+WAEXOpOI14Avm/baqxdqqpO0dqQziTZ3HZpBFyoqvmqOkw73OvVNGLUv6mtxYjpq6rTtJ63PcD9JLenHJImqKpOAC+At2z1PF6n9cE+BA4CH4BzSXYe3KBdrKoWgWtJlqrqCO0f2X3AOnAxyY9pxqfJqKrjtAO95oD3wCptIdb8MEBVdQs4T9sauA5cofWxmR8GoKoeAIvAfuALcBN4zF/yQbfIcZe2zXwTWE3yZhpx6/8YMx/WgHngWzfsZZKr3fgbtL7YX7SWtac7f1Oza6YKWEmSJEmSxpmlLcSSJEmSJI1lAStJkiRJ6gULWEmSJElSL1jASpIkSZJ6wQJWkiRJktQLFrCSJEmSpF6wgJUkSZIk9YIFrCRJkiSpF34DLePCGfcXFDQAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 936x576 with 2 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "5Uzt7ZDpgETm"
      },
      "source": [
        "### 이번학기 듣는거 더하면?"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "LnW_Z2iWWiwQ"
      },
      "source": [
        "# 4전공 듣는게 맞냐...?\n",
        "교양_학점 = sum(groupby_score[교양]) + 2\n",
        "전선_학점 = groupby_score['전선'] + 6 + 3 + 3 + 3\n",
        "전필_학점 = groupby_score['전필'] + 3\n",
        "총이수학점 = 교양_학점 + 전선_학점 + 전필_학점"
      ],
      "execution_count": 191,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 601
        },
        "id": "6Lc9_6Sfgmod",
        "outputId": "6f980d57-629f-49b4-ce8c-03820fc1749f"
      },
      "source": [
        "fig2 = plt.figure(figsize=(13,8),constrained_layout=True)\n",
        "spec2 = gridspec.GridSpec(ncols=1, nrows=4, figure=fig2)\n",
        "f2_ax1 = fig2.add_subplot(spec2[:3, 0])\n",
        "f2_ax2 = fig2.add_subplot(spec2[3, 0])\n",
        "\n",
        "f2_ax1.bar(x=['refinement', 'select', 'essential'], height= [교양_학점, 전선_학점, 전필_학점],width =0.4 ,color = 'tan' )\n",
        "f2_ax1.spines['right'].set_visible(False)\n",
        "f2_ax1.spines['top'].set_visible(False)\n",
        "f2_ax1.hlines(필수_졸업학점_지능기전['전선'], 0.8,1.2)\n",
        "f2_ax1.hlines(필수_졸업학점_지능기전['전필'], 1.8,2.2)\n",
        "\n",
        "if 필수_졸업학점_지능기전['전선']> 전선_학점:\n",
        "    value = f\"{필수_졸업학점_지능기전['전선'] - 전선_학점} need\"\n",
        "    f2_ax1.text(s=value, x='select',y=필수_졸업학점_지능기전['전선']+1,va='center', ha='center',fontsize=20)\n",
        "\n",
        "if 필수_졸업학점_지능기전['전필']> 전필_학점:\n",
        "    value = f\"{필수_졸업학점_지능기전['전필'] - 전필_학점} need\"\n",
        "    f2_ax1.text(s=value, x='select',y=필수_졸업학점_지능기전['전필']+1,va='center', ha='center',fontsize=20)\n",
        "\n",
        "f2_ax2.barh(y='total', width=총이수학점, color = 'khaki')\n",
        "f2_ax2.spines['top'].set_visible(False)\n",
        "f2_ax2.spines['right'].set_visible(False)\n",
        "f2_ax2.spines['bottom'].set_visible(False)\n",
        "f2_ax2.vlines(필수_졸업학점_지능기전['총합'],-0.5,0.5)\n",
        "\n",
        "if 필수_졸업학점_지능기전['총합']> 총이수학점:\n",
        "    value = f\"{필수_졸업학점_지능기전['총합'] - 총이수학점} need\"\n",
        "    f2_ax2.text(s=value, x=필수_졸업학점_지능기전['총합'],y=0,va='center', ha='right',fontsize=20)"
      ],
      "execution_count": 192,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAA7AAAAJICAYAAABYCwgCAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3debxddX3v//eHJFAiAiIYkKGgoPxwAkkFGSSAQgQEVC5W8P5AUEotFLhaBb1VcPrpVQQp1WqVocqvWpRJmbQpICgiEUGQGRxAmQVqxCGE7/3jbGISEkjknJzzzXk+H488svfa37XX94TNyn5lrbV3tdYCAAAAY91yoz0BAAAAWBwCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuTBztCSzM9OnT2wUXXDDa0wAAAGDpq0U9MCaPwN5///2jPQUAAADGmDEZsAAAALAgAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQhYmjPYFeXXvusaM9Bcawl+z6ztGeAgAALHMcgQUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgC8MesFU1oap+VFXfHNzfoKquqKpbq+qrVbX8cG8TAACAZd9IHIE9LMkN89z/eJLjWmsbJnkwyYEjsE0AAACWccMasFW1TpJdk3xhcL+S7JDka4MhpybZczi3CQAAwPgw3Edgj0/y7iSPDe4/O8lDrbVHB/fvTLL2MG8TAACAcWDicD1RVe2W5N7W2g+ratqfsf5BSQ5KkvXWW2+4pgUAAOPKteceO9pTYAx7ya7vHO0pPC3DeQR26yS7V9XPknwlQ6cOfzrJqlX1eCivk+SXC1u5tfb51trU1trUNdZYYxinBQAAwLJg2AK2tXZUa22d1tr6Sf46yX+11vZNclGSvQbD9kty9nBtEwAAgPFjaXwP7HuS/K+qujVD18R+cSlsEwAAgGXMsF0DO6/W2sVJLh7cvj3JK0ZiOwAAAIwfS+MILAAAADxtAhYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6MLE0Z4AADA2XHzxxdl+++3zgQ98IEcfffRoTwf4Mx1w5GdGewqMYVfu+s7RnsLT4ggsAAw88MAD+cIXvpDXv/712XDDDbPiiitmlVVWyTbbbJMvfvGLeeyxx0Z7igAwrjkCCwADp59+ev72b/82a621Vrbffvust956ueeee3LGGWfkbW97W84///ycfvrpqarRnirAIp30sXeM9hRgxAhYABh4wQtekHPOOSe77rprllvuTycpffSjH80rXvGKfP3rX88ZZ5yRN77xjaM4SwAYv5xCDAADO+ywQ173utfNF69Jsuaaa+bggw9OMnSd6OKqqkybNi33339/DjrooKy11lpZYYUV8qIXvSgnn3zyIte78MILs8suu2T11VfPCiuskOc///n5h3/4hzz00EMLHX/nnXfmkEMOyfOe97yssMIKefazn53dd989V1555ULH33PPPTnwwAMzZcqUrLjiitl0001z6qmnLvbPBQCjxRFYAFgMkyZNSpJMnLhkf3U+9NBD2XrrrbP88stnr732yh/+8IecfvrpOeCAA7Lccstlv/32m2/8Mccck6OPPjqrrbZadttttzznOc/Jj3/843zyk5/Meeedl8svvzwrr7zy3PFXXXVVdtppp/z617/OzjvvnDe84Q25//77c9ZZZ2WbbbbJmWeemV122WXu+Pvvvz9bbbVVbr/99myzzTbZZpttctddd+Xggw/OTjvt9DT+hABg5AlYAHgKjz76aP7t3/4tSTJ9+vQlWveaa67JgQcemM997nOZMGFCkuTwww/PS1/60nz84x+fL2AvuuiiHH300XnlK1+Z8847L6uuuurcx0455ZS89a1vzQc+8IEcd9xxc+e19957Z9asWbnooouy3XbbzR3/q1/9Kn/1V3+VAw88MD/72c+ywgorJEne+9735vbbb8/hhx8+93mS5JBDDskrX/nKJfyTAYClyynEAPAUjjzyyFx33XXZZZddsvPOOy/RupMnT86nPvWpufGaJJtsskm23nrr3HDDDZk1a9bc5SeccEKS5F//9V/ni9ck2X///bPpppvmtNNOm7vs3HPPzW233ZZDDz10vnhNkuc+97l597vfnbvvvjszZsxIksyePTunnXZanvnMZz7ha3KmTp2afffdd4l+NgBY2hyBBYAnccIJJ+TYY4/NxhtvnC996UtLvP5GG2003ym/j1t33XWTJA8++GBWWmmlJMnll1+eSZMm5fTTT8/pp5/+hHX++Mc/5r777ssDDzyQZz/72bn88suTJD//+c8X+r2tt9xyS5LkhhtuyC677JIbb7wxjzzySLbddtusssoqTxg/bdo018ICMKYJWABYhBNPPDGHHXZYNtlkk8yYMSOrrbbaEj/HgkdSH/f4tbRz5syZu+yBBx7Io48+mmOOOeZJn3PWrFl59rOfnQceeCBJFhq7C45PkocffjhJMmXKlIWOW3PNNZ/0eQBgtAlYAFiI448/PkcccURe/OIXZ8aMGXnOc54z4ttcZZVV8thjj+XXv/71Yo9PkrPPPju77777Yo+/5557Fvr43XffvZgzBYDR4RpYAFjAxz/+8RxxxBHZdNNNc9FFFy2VeE2SLbfcMg8++GB+8pOfLPb4JLn00ksXa/zGG2+cyZMn5+qrr557NHZeS/IVQQAwGgQsAMzjQx/6UI488shsvvnmmTFjRlZfffWltu0jjjgiSfL2t789v/rVr57w+G9/+9t8//vfn3t/jz32yPOf//z88z//c84777yFPufll1+eRx55JMnQVwHtu++++c1vfvOEa2Znzpw53wdEAcBY5BRiABg49dRT8/73vz8TJkzItttuO/dTgee1/vrrZ//99x+R7e+444752Mc+lqOOOiobbbRRdtlll2ywwQaZNWtWfv7zn+eSSy7JNttskwsuuCDJUJCeccYZ2XnnnbPrrrtmq622yqabbprJkyfnjjvuyJVXXpnbb789d911VyZPnpwk+ehHP5oZM2bk+OOPz8yZM+d+D+xXv/rV7LLLLjnnnHNG5GcDgOEgYAFg4Kc//WmSoQ9WOv744xc6ZrvtthuxgE2S97znPdl6661zwgkn5LLLLsvZZ5+dVVZZJWuvvXYOOuig7LPPPvONf+lLX5prrrkmn/rUp/LNb34zJ598cpZbbrmstdZa2WyzzXLMMcfMdxR59dVXz3e/+928973vzTe+8Y3MnDkzL3zhC/PZz34266+/voAFYEyr1tpoz+EJpk6d2mbOnDna03hS15577GhPgTHsJbu+c7SnAACMU96n8mQ6eZ9ai3rANbAAAAB0wSnEAIy6adOmjfYUGMN8OjIAj3MEFgAAgC44AgvAqHOEDQBYHI7AAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF2YONoTAIBrzz12tKfAGPaSXd852lMAYIxwBBYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4MW8BW1V9U1Q+q6pqq+klVHTNYvkFVXVFVt1bVV6tq+eHaJgAAAOPHcB6B/UOSHVprL0uyaZLpVbVlko8nOa61tmGSB5McOIzbBAAAYJwYtoBtQ2YN7k4a/GpJdkjytcHyU5PsOVzbBAAAYPwY1mtgq2pCVV2d5N4k305yW5KHWmuPDobcmWTtRax7UFXNrKqZ991333BOCwAAgGXAsAZsa21Oa23TJOskeUWSjZdg3c+31qa21qauscYawzktAAAAlgEj8inErbWHklyU5JVJVq2qiYOH1knyy5HYJgAAAMu24fwU4jWqatXB7RWTvCbJDRkK2b0Gw/ZLcvZwbRMAAIDxY+JTD1lsayU5taomZCiM/6O19s2quj7JV6rqw0l+lOSLw7hNAAAAxolhC9jW2o+TbLaQ5bdn6HpYAAAA+LONyDWwAAAAMNwELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANCFYQvYqlq3qi6qquur6idVddhg+WpV9e2qumXw+7OGa5sAAACMH8N5BPbRJO9srW2SZMskf1dVmyQ5MsmM1tpGSWYM7gMAAMASGbaAba3d1Vq7anD7N0luSLJ2kj2SnDoYdmqSPYdrmwAAAIwfI3INbFWtn2SzJFckmdJau2vw0N1JpozENgEAAFi2DXvAVtVKSb6e5PDW2n/P+1hrrSVpi1jvoKqaWVUz77vvvuGeFgAAAJ0b1oCtqkkZitfTWmtnDBbfU1VrDR5fK8m9C1u3tfb51trU1trUNdZYYzinBQAAwDJgOD+FuJJ8MckNrbVPzfPQOUn2G9zeL8nZw7VNAAAAxo+Jw/hcWyf5n0muraqrB8vem+RjSf6jqg5M8vMkew/jNgEAABgnhi1gW2uXJalFPLzjcG0HAACA8WlEPoUYAAAAhpuABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOjCsAVsVZ1UVfdW1XXzLFutqr5dVbcMfn/WcG0PAACA8WU4j8CekmT6AsuOTDKjtbZRkhmD+wAAALDEhi1gW2vfSfLrBRbvkeTUwe1Tk+w5XNsDAABgfBnpa2CntNbuGty+O8mUEd4eAAAAy6il9iFOrbWWpC3q8ao6qKpmVtXM++67b2lNCwAAgE6MdMDeU1VrJcng93sXNbC19vnW2tTW2tQ11lhjhKcFAABAb0Y6YM9Jst/g9n5Jzh7h7QEAALCMGs6v0fn3JJcneWFV3VlVByb5WJLXVNUtSV49uA8AAABLbOJwPVFr7c2LeGjH4doGAAAA49dS+xAnAAAAeDoELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXlkrAVtX0qrqpqm6tqiOXxjYBAABYtox4wFbVhCT/nOS1STZJ8uaq2mSktwsAAMCyZWkcgX1Fkltba7e31v6Y5CtJ9lgK2wUAAGAZMnEpbGPtJHfMc//OJFssOKiqDkpy0ODurKq6aSnMjeGzepL7R3sSY8e7RnsCQN/sU+djnwo8Lfap8+lin3pBa236wh5YGgG7WFprn0/y+dGeB3+eqprZWps62vMAWBbYpwIMH/vUZcvSOIX4l0nWnef+OoNlAAAAsNiWRsBemWSjqtqgqpZP8tdJzlkK2wUAAGAZMuKnELfWHq2qQ5JcmGRCkpNaaz8Z6e2y1Dn9G2D42KcCDB/71GVItdZGew4AAADwlJbGKcQAAADwtAlYAAAAuiBgSVX9fVXdUFWnVdXuVXXkaM9pQVX13tGeA8BIqqpTqmqvP2O99atqn5GYE8CybsH3mFX1vcVYZ9bIzYin4hrYcaKqKkP/vR9byGM3Jnl1a+3OpT+zxVNVs1prK432PABGSlWdkuSbrbWvLeF605K8q7W220jMC2BZ9ue8x/S+dHQ5ArsMG/yr/E1V9W9Jrkvyj1V1ZVX9uKqOGYz5lyTPS3J+VR1RVftX1YmDx06pqhOq6ntVdfu8Rwaq6h8W8lzrV9WNg/VuHhzRfXVVfbeqbqmqVwzGPaOqTqqqH1TVj6pqj8Hy/avqjKq6YDD+/wyWfyzJilV1dVWdthT/CAGelsH+7tyquqaqrquqN1XV5lV1SVX9sKourKq1FrLeQsdU1YZV9Z+D57uqqp6f5GNJth3sI49Y2j8jwHCqqrcM3iNeXVWfq6oJg/eW11XVtY/v5wZnEF4/eC/6lcGyp/0e8/Gjq1W1UlXNGOxrr338uRh9jsAuw6pq/SS3J9kqycpJ9kryN0kqQ9/F+39aa9+pqp8lmdpau7+q9h/cPmRwNOAZSd6UZOMk57TWNqyqnRb2XEl+keTWJJsl+UmGvgP4miQHJtk9yVtba3tW1UeTXN9a+3JVrZrkB4N1/keS9w9u/yHJTUm2aa3d4V+6gB5V1RuTTG+tvX1wf5Uk5yfZo7V2X1W9KcnOrbUDHj8Cm+TsJJcsYswVST7WWjuzqv4iQ/8Q/Yo4AgssA6rq/8nQe8o3tNZmV9VnktyTofeDrxmMWbW19lBV/SrJBq21P8yz7Gm/x3z8flVNTDK5tfbfVbV6ku8n2ai11rwvHV0j/j2wjLqft9a+X1WfTLJTkh8Nlq+UZKMk33mK9c8anHZ8fVVNGSzbaRHP9YskP22tXZskVfWTJDMG/6Nfm2T9edbfvareNbj/F0nWG9ye0Vp7eLD+9Un+MskdS/5jA4wJ1yY5tqo+nqE4fTDJi5N8u6qSoe9Hv2uBdV64sDFV9cwka7fWzkyS1trvk2QwBmBZsGOSzZNcOdi3rZjkgiTPq6p/SnJukm8Nxv44yWlVdVaSswbLhvM9ZiX5aFW9KsljSdZOMiXJ3U/3h+TpEbDLvt8Ofq8k/19r7XNLuP4f5rld8/z+hOcaHPGdd/xj89x/LH96vVWSN7bWblpg/S0WWH9OvEaBjrXWbq6qlyfZJcmHk/xXkp+01l75JKvVwsYMAhZgWVZJTm2tHTXfwqr3Jdk5ycFJ9k5yQJJdk7wqyeuSvK+qXpLhfY+5b5I1kmw+OBr8swwFMaPMNbDjx4VJDqiqlZKkqtauqueM0nNdmOTQGvzTWlVtthjrzK6qSUs+VYDRU1XPTfJIa+3LST6RZIska1TVKwePT6qqFy2w2k0LG9Na+02SO6tqz8HyFapqcpLfJBG3wLJgRpK9Hn9fWVWrVdVfJlmutfb1JP87ycurarkk67bWLkryniSrZOiMwOF8j7lKknsH8bp9ho7YMgY4ujVOtNa+Nbiu4PLB/9Ozkrwlyb3D+FxzFvMpPpTk+CQ/HuyAfprkqa7d+vxg/FWttX2XdM4Ao+QlST5RVY8lmZ3kb5M8muSEwfWwEzO0P/zJ4yu01v5YQx+at7Ax/zPJ56rqg4Pn+x8ZOo1uTlVdk+SU1tpxS+2nAxhGrbXrq+p/J/nW4D3i7CT/K8mZg/tJclSGLq348mAfWUlOGFwDO5zvMU9L8o3BZXAzk9w4TD8mT5MPcQIAAKALTiEGAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALE0d7Agszffr0dsEFF4z2NAAAAFj6alEPjMkjsPfff/9oTwEAAIAxZkwGLAAAACxIwAIAANAFAQsAAEAXBCwAAABdELAAAADLsGnTpmXatGmjPY1hIWABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuTBztCSzMnNn35OG7jh3taQAAAKNglbXeOdpTYIxyBBYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAACWMUcffXSqKhdffPFoT2VYCVgAAGDM+9rXvpZDDz002267bVZeeeVUVd7ylrcscvwdd9yRd7zjHdliiy2y5pprZoUVVshzn/vcbLvttjn55JMze/bspTh7hsvE0Z4AAADAU/nwhz+ca665JiuttFLWWWed3HjjjU86/rbbbstpp52WLbbYInvuuWdWW221PPDAAzn//PNzwAEH5Etf+lK+9a1vZeJESdQT/7UAAIAx77jjjss666yTDTfcMJdcckm23377Jx2/1VZb5cEHH8xyy81/0uns2bOz00475aKLLsoZZ5yRvffeeySnzTBzCjEAADDmbb/99tloo41SVYs1fvnll39CvCbJpEmTsueeeyZJbrnllsV6rosvvjhVlaOPPjpXX311dt1116y66qqZPHlytttuu3zve99b6HqPPvpoPvOZz2TLLbfMyiuvnMmTJ2ezzTbLiSeemMcee2yh61xxxRXZa6+9suaaa2b55ZfPuuuum7/5m7/Jr371q4WO/+EPf5jp06fnmc98ZlZeeeW8+tWvzuWXX75YP1ePnjRgq2rVqnrHU4xZv6r2eaoNDcZdt6QTBAAAGC5z5szJeeedlyR56UtfukTrzpw5M1tttVV+//vf521ve1t22223XHbZZdlxxx1z0003zTd29uzZ2W233fJ3f/d3eeihh7LPPvvkoIMOymOPPZZDDz00++233xOe/6STTsrWW2+d888/P9tvv30OP/zwTJ06NV/4whcyderU/OIXv5hv/Pe+971su+22+c///M+89rWvzSGHHJLll18+06ZNyxVXXLGEfzJ9eKpTiFdN8o4kn3mSMesn2SfJ/z9McwIAABgW999/f0488cS01nLffffl29/+dm699dbss88+ed3rXrdEz3Xuuefm5JNPzv777z932ec+97kcfPDB+fSnP53PfOZP2fSRj3wkF154YQ455JAcf/zxmTBhQpKhgD7ooINy0kknZa+99soee+yRJLn55ptz8MEHZ/31188ll1yStddee+5zzZgxIzvttFMOO+ywnHnmmUmS1loOOOCA/O53v8tZZ50190rIVZUAAAyWSURBVHmS5NOf/nQOP/zwJf6z6sFTnUL8sSTPr6qrq+oTg1/XVdW1VfWmecZsOxhzxOBI66VVddXg11Yj+yMAAAAs3P33359jjjkmH/zgB/PZz342t912W971rnfllFNOWeLn2nrrreeL1yQ54IADMnHixPzgBz+Yu+yxxx7LP/3TP2XNNdfMcccdNzdek2TChAk59thjU1U57bTT5i7/7Gc/m9mzZ+fTn/70fPGaJDvuuGN23333fOMb38hvfvObJENHX2+66aa86lWvmi9ek+SQQw7J85///CX++XrwVEdgj0zy4tbaplX1xiQHJ3lZktWTXFlV3xmMeVdrbbckqarJSV7TWvt9VW2U5N+TTB2xnwAAAGARNt5447TWMmfOnPzyl7/MmWeemfe///257LLLcu6552a11VZb7OeaOvWJWTNp0qRMmTIlDz744NxlN998c379619no402yoc//OGFPteKK66YG264Ye79x69bveSSS3LllVc+Yfy9996bOXPm5Oabb87mm2+eq666Kkmy3XbbPWHshAkTss022+S2225b7J+tF0vyKcTbJPn31tqcJPdU1SVJ/irJfy8wblKSE6tq0yRzkrxgcZ68qg5KclCSrLv2s5ZgWgAAAE9uwoQJWW+99XLYYYdlypQpefOb35z3v//9OfHEExf7OVZdddWFLp84cWLmzJkz9/4DDzyQZOhDoo455phFPt+sWbOesM4nPvGJJ53D4+s8/PDDSZIpU6YsdNyaa675pM/Tq5H4Gp0jktyToSO1yyX5/eKs1Fr7fJLPJ8lmL1u3jcC8AAAA8trXvjbJ0KcLj4RVVlklSfL6178+Z5xxxhKt8/DDD2fllVde7PH33HPPQh+/++67F2u7vXmqa2B/k+SZg9uXJnlTVU2oqjWSvCrJDxYYkySrJLmrtfZYkv+ZZEIAAADGiF/+8pdJho6cjoSNN944q666ar7//e9n9uzZi7XOlltumSS59NJLF2v8y1/+8iRDpxwvaM6cObnssssWc7Z9edKAba09kOS7g6+/eWWSHye5Jsl/JXl3a+3uwbI5VXVNVR2RoU8s3q+qrkmycZLfjuQPAAAAsKCrrrpqvtN6Hzdr1qwcdthhSZJdd911RLY9ceLEHHroobnrrrvy93//9/nd7373hDF33XVXrr/++rn3DznkkEyaNClHHHFEbr755ieM/+Mf/zhf3G611VZ54QtfmO985zs5++yz5xt74oknLpPXvyaLcQpxa23B73j9hwUen51khwXGzPuFSu8ZjPtZkhcv+RQBAIDx7qyzzspZZ52V5E+nx15++eVzPxV49dVXzyc/+cm54z/4wQ/mu9/9brbaaqust956mTx5cu64446cf/75eeihh7LVVlvlqKOOGrH5/uM//mOuueaa/Mu//Eu+8Y1vZIcddsjaa6+de++9N7fccku++93v5iMf+Ug22WSTJENHbU866aQccMABedGLXpTp06fnBS94QWbPnp1f/OIXufTSS7PGGmvkxhtvTJJUVb74xS/mNa95Td74xjfmDW94QzbccMNcffXVmTFjRqZPn54LLrhgxH6+0TIyx8wBAACG0dVXX51TTz11vmW33357br/99iTJX/7lX84XsG9/+9uz0kor5Qc/+EEuvvjiPPLII3nWs56VzTffPHvvvffcr78ZKZMmTcpZZ52VL3/5yznllFPyzW9+M7Nmzcoaa6yRDTbYIB/60Iey7777zrfOW97ylrzsZS/Lsccem4suuijf+ta38oxnPCPPfe5zs9dee+VNb3rTfOO33nrrXHrppXnf+96X888/P0myxRZb5OKLL86FF164TAZstTb2Pi9ps5et2y6+YNn84l0AAODJrbLWO0d7CsuUadOmJRm5D60aAbWoB57qQ5wAAABgTBCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQBQELAABAFwQsAAAAXRCwAAAAdEHAAgAA0AUBCwAAQBcELAAAAF2YONoTWJgJk6ZklbXeOdrTAAAAYAxxBBYAAIAuCFgAAAC6IGABAADogoAFAACgCwIWAACALghYAAAAuiBgAQAA6IKABQAAoAsCFgAAgC4IWAAAALogYAEAAOjCxNGeAAAAACPn4osvHu0pDBtHYAEAAOiCgAUAAKALAhYAAIAuCFgAAAC6IGABAADoQrXWRnsOT1BV17XWXjza82BsqKqDWmufH+15MDZ4PTAvrwfm5fXA47wWmJfXw7JlrB6B/f1oT4Ax5aDRngBjitcD8/J6YF5eDzzOa4F5eT0sQ8ZqwAIAAMB8BCwAAABdGKsB6xx15uX1wLy8HpiX1wPz8nrgcV4LzMvrYRkyJj/ECQAAABY0Vo/AAgAAwHzGVMBW1fSquqmqbq2qI0d7PixdVbVuVV1UVddX1U+q6rDB8tWq6ttVdcvg92eN9lxZeqpqQlX9qKq+Obi/QVVdMdhPfLWqlh/tObJ0VNWqVfW1qrqxqm6oqlfaP4xfVXXE4O+K66rq36vqL+wfxo+qOqmq7q2q6+ZZttD9QQ05YfC6+HFVvXz0Zs5IWMTr4RODvy9+XFVnVtWq8zx21OD1cFNV7Tw6s+bPNWYCtqomJPnnJK9NskmSN1fVJqM7K5ayR5O8s7W2SZItk/zd4DVwZJIZrbWNkswY3Gf8OCzJDfPc/3iS41prGyZ5MMmBozIrRsOnk1zQWts4ycsy9LqwfxiHqmrtJH+fZOrge+MnJPnr2D+MJ6ckmb7AskXtD16bZKPBr4OSfHYpzZGl55Q88fXw7SQvbq29NMnNSY5KksF7y79O8qLBOp8ZdAidGDMBm+QVSW5trd3eWvtjkq8k2WOU58RS1Fq7q7V21eD2bzL05nTtDL0OTh0MOzXJnqMzQ5a2qlonya5JvjC4X0l2SPK1wRCvh3GiqlZJ8qokX0yS1tofW2sPxf5hPJuYZMWqmphkcpK7Yv8wbrTWvpPk1wssXtT+YI8k/9aGfD/JqlW11tKZKUvDwl4PrbVvtdYeHdz9fpJ1Brf3SPKV1tofWms/TXJrhjqEToylgF07yR3z3L9zsIxxqKrWT7JZkiuSTGmt3TV46O4kU0ZpWix9xyd5d5LHBvefneShef5Csp8YPzZIcl+SkwenlH+hqp4R+4dxqbX2yySfTPKLDIXrw0l+GPuH8W5R+wPvMTkgyfmD214PnRtLAQtJkqpaKcnXkxzeWvvveR9rQx+b7aOzx4Gq2i3Jva21H472XBgTJiZ5eZLPttY2S/LbLHC6sP3D+DG4tnGPDP3DxnOTPCNPPH2Qccz+gMdV1fsydJnaaaM9F4bHWArYXyZZd5776wyWMY5U1aQMxetprbUzBovvefxUn8Hv947W/Fiqtk6ye1X9LEOXFOyQoWsgVx2cMpjYT4wndya5s7V2xeD+1zIUtPYP49Ork/y0tXZfa212kjMytM+wfxjfFrU/8B5znKqq/ZPslmTf9qfvDvV66NxYCtgrk2w0+ATB5TN0cfU5ozwnlqLB9Y1fTHJDa+1T8zx0TpL9Brf3S3L20p4bS19r7ajW2jqttfUztD/4r9bavkkuSrLXYJjXwzjRWrs7yR1V9cLBoh2TXB/7h/HqF0m2rKrJg787Hn892D+Mb4vaH5yT5P8dfBrxlkkenudUY5ZRVTU9Q5ch7d5ae2Seh85J8tdVtUJVbZChD/f6wWjMkT9P/ekfI0ZfVe2SoWveJiQ5qbX2kVGeEktRVW2T5NIk1+ZP1zy+N0PXwf5HkvWS/DzJ3q21BT+4gWVYVU1L8q7W2m5V9bwMHZFdLcmPkryltfaH0ZwfS0dVbZqhD/RaPsntSd6aoX+ItX8Yh6rqmCRvytCpgT9K8rYMXcdm/zAOVNW/J5mWZPUk9yT5QJKzspD9weAfOU7M0GnmjyR5a2tt5mjMm5GxiNfDUUlWSPLAYNj3W2sHD8a/L0PXxT6aoUvWzl/wORm7xlTAAgAAwKKMpVOIAQAAYJEELAAAAF0QsAAAAHRBwAIAANAFAQsAAEAXBCwAAABdELAAAAB0QcACAADQhf8LVg7fgqkt+o8AAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 936x576 with 2 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Vy_Ddl_cgTGe"
      },
      "source": [
        "### 4학년 예상"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "X196aVh1Y2Pf"
      },
      "source": [
        "교양_학점 = sum(groupby_score[교양]) + 2 + 4 # 교양 2개\n",
        "전선_학점 = groupby_score['전선'] + 6 + 3 + 3 + 3 + 3 #전선하나\n",
        "전필_학점 = groupby_score['전필'] + 3 +6 # 캡스톤\n",
        "총이수학점 = 교양_학점 + 전선_학점 + 전필_학점"
      ],
      "execution_count": 193,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 601
        },
        "id": "RnDrxrDygx5p",
        "outputId": "a9721cd6-708a-49f2-bfbc-a1a45dd1b406"
      },
      "source": [
        "fig2 = plt.figure(figsize=(13,8),constrained_layout=True)\n",
        "spec2 = gridspec.GridSpec(ncols=1, nrows=4, figure=fig2)\n",
        "f2_ax1 = fig2.add_subplot(spec2[:3, 0])\n",
        "f2_ax2 = fig2.add_subplot(spec2[3, 0])\n",
        "\n",
        "f2_ax1.bar(x=['refinement', 'select', 'essential'], height= [교양_학점, 전선_학점, 전필_학점],width =0.4 ,color = 'tan' )\n",
        "f2_ax1.spines['right'].set_visible(False)\n",
        "f2_ax1.spines['top'].set_visible(False)\n",
        "f2_ax1.hlines(필수_졸업학점_지능기전['전선'], 0.8,1.2)\n",
        "f2_ax1.hlines(필수_졸업학점_지능기전['전필'], 1.8,2.2)\n",
        "\n",
        "if 필수_졸업학점_지능기전['전선']> 전선_학점:\n",
        "    value = f\"{필수_졸업학점_지능기전['전선'] - 전선_학점} need\"\n",
        "    f2_ax1.text(s=value, x='select',y=필수_졸업학점_지능기전['전선']+1,va='center', ha='center',fontsize=20)\n",
        "\n",
        "if 필수_졸업학점_지능기전['전필']> 전필_학점:\n",
        "    value = f\"{필수_졸업학점_지능기전['전필'] - 전필_학점} need\"\n",
        "    f2_ax1.text(s=value, x='select',y=필수_졸업학점_지능기전['전필']+1,va='center', ha='center',fontsize=20)\n",
        "\n",
        "f2_ax2.barh(y='total', width=총이수학점, color = 'khaki')\n",
        "f2_ax2.spines['top'].set_visible(False)\n",
        "f2_ax2.spines['right'].set_visible(False)\n",
        "f2_ax2.spines['bottom'].set_visible(False)\n",
        "f2_ax2.vlines(필수_졸업학점_지능기전['총합'],-0.5,0.5)\n",
        "\n",
        "if 필수_졸업학점_지능기전['총합']> 총이수학점:\n",
        "    value = f\"{필수_졸업학점_지능기전['총합'] - 총이수학점} need\"\n",
        "    f2_ax2.text(s=value, x=필수_졸업학점_지능기전['총합'],y=0,va='center', ha='right',fontsize=20)"
      ],
      "execution_count": 194,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAA7AAAAJICAYAAABYCwgCAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3debRud13f8c/XXCKTEoZrVkzAoKQqggzeIlTKSpkMQklWRUBRg9CmVq2IoASx7bK1NqiIUsWaJTSxUobFGGERoBHEqgxhTAhE0jCFhgzIqEsgybd/nJ16uNzLTchzznO/57xea2WdZ+9n72f/DuzsPO+z936e6u4AAADA4e7r1j0AAAAAuCEELAAAACMIWAAAAEYQsAAAAIwgYAEAABhBwAIAADDCnlW+WFV9OMnnklyb5Jru3ldVt0vy4iTHJ/lwkkd396dWuV0AAAB2vlrl98AuAbuvu6/eNO/Xk/xNd59RVacnuW13P+2rvc5JJ53U55577srGBQAAwBh1sCe24xLik5OcvTw+O8kph1rh6quvPtQiAAAA7DKrDthO8vqqekdVnbbMO7q7L18efyLJ0SveJgAAALvASu+BTXL/7v54VX1TkjdU1Qc2P9ndXVUHvGZ5Cd7TkuROd7rTiocFAADAdCs9A9vdH19+XpnkFUnuk+SKqjomSZafVx5k3TO7e19379u7d+8qhwUAAMAOsLKArapbVdU3XP84yUOTXJjknCSnLoudmuRVq9omAAAAu8cqLyE+Oskrqur61/2f3X1uVb09yUuq6olJPpLk0SvcJgAAALvEygK2uy9Nco8DzP9kkgetajsAAADsTtvxNToAAABwkwlYAAAARhCwAAAAjCBgAQAAGEHAAgAAMIKABQAAYAQBCwAAwAgCFgAAgBEELAAAACMIWAAAAEbYs+4BTHXBa5617iFwGLv7w5+y7iEAAMCO4wwsAAAAIwhYAAAARhCwAAAAjCBgAQAAGEHAAgAAMIKABQAAYAQBCwAAwAgCFgAAgBEELAAAACMIWAAAAEYQsAAAAIwgYAEAABhBwAIAADCCgAUAAGAEAQsAAMAIe9Y9AAAAYHUueM2z1j0EDmN3f/hT1j2Em8QZWAAAAEYQsAAAAIwgYAEAABhBwAIAADCCgAUAAGAEAQsAAMAIAhYAAIARBCwAAAAjCFgAAABGELAAAACMIGABAAAYQcACAAAwgoAFAABgBAELAADACAIWAACAEQQsAAAAIwhYAAAARhCwAAAAjCBgAQAAGEHAAgAAMIKABQAAYAQBCwAAwAgCFgAAgBEELAAAACMIWAAAAEYQsAAAAIwgYAEAABhBwAIAADCCgAUAAGAEAQsAAMAIAhYAAIARBCwAAAAjCFgAAABGELAAAACMIGABAAAYQcACAAAwgoAFAABgBAELAADACAIWAACAEQQsAAAAIwhYAAAARhCwAAAAjCBgAQAAGGHlAVtVR1TVu6rq1cv0navqrVV1SVW9uKqOXPU2AQAA2Pm24gzsk5K8f9P0M5M8u7vvkuRTSZ64BdsEAABgh1tpwFbVcUkenuQPl+lK8sAkL10WOTvJKavcJgAAALvDqs/A/naSX0xy3TJ9+ySf7u5rlunLkhx7oBWr6rSqOr+qzr/qqqtWPCwAAACmW1nAVtUjklzZ3e/4Wtbv7jO7e19379u7d++qhgUAAMAOsWeFr/V9SR5ZVT+Q5OZJvjHJ7yQ5qqr2LGdhj0vy8RVuEwAAgF1iZWdgu/vp3X1cdx+f5LFJ/rS7H5fkjUketSx2apJXrWqbAAAA7B7b8T2wT0vy81V1STbuiX3eNmwTAACAHWaVlxD/f939piRvWh5fmuQ+W7EdAAAAdo/tOAMLAAAAN5mABQAAYAQBCwAAwAgCFgAAgBEELAAAACMIWAAAAEYQsAAAAIwgYAEAABhBwAIAADCCgAUAAGAEAQsAAMAIAhYAAIARBCwAAAAjCFgAAABGELAAAACMIGABAAAYQcACAAAwwp51DwAAAFidJ5z+3HUPgcPY2x/+lHUP4SZxBhYAAIARnIEFAIAd5Pln/NS6hwBbxhlYAAAARhCwAAAAjCBgAQAAGEHAAgAAMIKABQAAYASfQgzA2l3wmmetewgcxu4+/DsLAVgdZ2ABAAAYQcACAAAwgoAFAABgBAELAADACAIWAACAEQQsAAAAI/gaHQDW7gmnP3fdQ+Aw9nZfowPAwhlYAAAARnAGFoC1e/4ZP7XuIQAAAzgDCwAAwAgCFgAAgBEELAAAACMIWAAAAEYQsAAAAIwgYAEAABhBwAIAADCCgAUAAGAEAQsAAMAIAhYAAIARBCwAAAAjCFgAAABGELAAAACMIGABAAAYQcACAAAwgoAFAABgBAELAADACAIWAACAEQQsAAAAIwhYAAAARhCwAAAAjCBgAQAAGEHAAgAAMIKABQAAYAQBCwAAwAgCFgAAgBEELAAAACMIWAAAAEYQsAAAAIwgYAEAABhBwAIAADCCgAUAAGAEAQsAAMAIAhYAAIARVhawVXXzqnpbVb2nqt5XVb+yzL9zVb21qi6pqhdX1ZGr2iYAAAC7xyrPwH4hyQO7+x5J7pnkpKq6b5JnJnl2d98lyaeSPHGF2wQAAGCXWFnA9obPL5M3W/7pJA9M8tJl/tlJTlnVNgEAANg9VnoPbFUdUVXvTnJlkjck+T9JPt3d1yyLXJbk2IOse1pVnV9V51911VWrHBYAAAA7wEoDtruv7e57JjkuyX2SfMeNWPfM7t7X3fv27t27ymEBAACwA2zJpxB396eTvDHJ/ZIcVVV7lqeOS/LxrdgmAAAAO9sqP4V4b1UdtTy+RZKHJHl/NkL2UctipyZ51aq2CQAAwO6x59CL3GDHJDm7qo7IRhi/pLtfXVUXJXlRVf1qkncled4KtwkAAMAusbKA7e73JrnXAeZfmo37YQEAAOBrtiX3wAIAAMCqCVgAAABGELAAAACMIGABAAAYQcACAAAwgoAFAABgBAELAADACAIWAACAEQQsAAAAIwhYAAAARhCwAAAAjCBgAQAAGEHAAgAAMIKABQAAYAQBCwAAwAgCFgAAgBEELAAAACMIWAAAAEYQsAAAAIwgYAEAABhBwAIAADCCgAUAAGAEAQsAAMAIAhYAAIARBCwAAAAjCFgAAABGELAAAACMIGABAAAYQcACAAAwgoAFAABgBAELAADACAIWAACAEQQsAAAAIwhYAAAARhCwAAAAjCBgAQAAGEHAAgAAMIKABQAAYAQBCwAAwAgCFgAAgBEELAAAACMIWAAAAEYQsAAAAIwgYAEAABhBwAIAADCCgAUAAGAEAQsAAMAIAhYAAIARBCwAAAAjCFgAAABGELAAAACMIGABAAAYQcACAAAwgoAFAABgBAELAADACAIWAACAEQQsAAAAIwhYAAAARhCwAAAAjCBgAQAAGEHAAgAAMIKABQAAYAQBCwAAwAgCFgAAgBEELAAAACMIWAAAAEYQsAAAAIwgYAEAABhBwAIAADDCygK2qu5YVW+sqouq6n1V9aRl/u2q6g1V9cHl521XtU0AAAB2j1Wegb0myVO6+65J7pvkp6vqrklOT3Jed5+Q5LxlGgAAAG6UlQVsd1/e3e9cHn8uyfuTHJvk5CRnL4udneSUVW0TAACA3WNL7oGtquOT3CvJW5Mc3d2XL099IsnRW7FNAAAAdraVB2xV3TrJy5L8XHd/dvNz3d1J+iDrnVZV51fV+VddddWqhwUAAMBwKw3YqrpZNuL1Bd398mX2FVV1zPL8MUmuPNC63X1md+/r7n179+5d5bAAAADYAVb5KcSV5HlJ3t/dv7XpqXOSnLo8PjXJq1a1TQAAAHaPPSt8re9L8mNJLqiqdy/zfinJGUleUlVPTPKRJI9e4TYBAADYJVYWsN39v5PUQZ5+0Kq2AwAAwO60JZ9CDAAAAKsmYAEAABhBwAIAADCCgAUAAGAEAQsAAMAIAhYAAIARBCwAAAAjCFgAAABGELAAAACMIGABAAAYQcACAAAwgoAFAABgBAELAADACAIWAACAEQQsAAAAIwhYAAAARhCwAAAAjCBgAQAAGEHAAgAAMIKABQAAYAQBCwAAwAgCFgAAgBEELAAAACMIWAAAAEYQsAAAAIwgYAEAABhBwAIAADCCgAUAAGAEAQsAAMAIAhYAAIARBCwAAAAjCFgAAABGELAAAACMIGABAAAYQcACAAAwgoAFAABgBAELAADACAIWAACAEQQsAAAAIwhYAAAARhCwAAAAjCBgAQAAGEHAAgAAMIKABQAAYAQBCwAAwAgCFgAAgBEELAAAACMIWAAAAEYQsAAAAIwgYAEAABhBwAIAADCCgAUAAGAEAQsAAMAIAhYAAIARBCwAAAAjCFgAAABGELAAAACMIGABAAAYQcACAAAwgoAFAABgBAELAADACAIWAACAEQQsAAAAIwhYAAAARhCwAAAAjCBgAQAAGEHAAgAAMIKABQAAYAQBCwAAwAgrC9iqen5VXVlVF26ad7uqekNVfXD5edtVbQ8AAIDdZZVnYM9KctJ+805Pcl53n5DkvGUaAAAAbrSVBWx3vznJ3+w3++QkZy+Pz05yyqq2BwAAwO6y1ffAHt3dly+PP5Hk6C3eHgAAADvUtn2IU3d3kj7Y81V1WlWdX1XnX3XVVds1LAAAAIbY6oC9oqqOSZLl55UHW7C7z+zufd29b+/evVs8LAAAAKbZ6oA9J8mpy+NTk7xqi7cHAADADrXKr9F5YZK/SvLtVXVZVT0xyRlJHlJVH0zy4GUaAAAAbrQ9q3qh7v7hgzz1oFVtAwAAgN1r2z7ECQAAAG4KAQsAAMAIAhYAAIARBCwAAAAjCFgAAABGELAAAACMIGABAAAYQcACAAAwgoAFAABgBAELAADACAIWAACAEQQsAAAAIwhYAAAARhCwAAAAjCBgAQAAGEHAAgAAMIKABQAAYAQBCwAAwAgCFgAAgBEELAAAACMIWAAAAEYQsAAAAIwgYAEAABhBwAIAADCCgAUAAGAEAQsAAMAIAhYAAIARBCwAAAAjCFgAAABGELAAAACMIGABAAAYQcACAAAwgoAFAABgBAELAADACAIWAACAEQQsAAAAIwhYAAAARhCwAAAAjCBgAQAAGEHAAgAAMIKABQAAYAQBCwAAwAgCFgAAgBEELAAAACMIWAAAAEYQsAAAAIwgYAEAABhBwAIAADCCgAUAAGAEAQsAAMAIAhYAAIARBCwAAAAjCFgAAABGELAAAACMIGABAAAYQcACAAAwgoAFAABgBAELAADACAIWAACAEQQsAAAAIwhYAAAARhCwAAAAjCBgAQAAGEHAAgAAMIKABQAAYAQBCwAAwAgCFgAAgBEELAAAACMIWAAAAEYQsAAAAIywLQFbVSdV1cVVdUlVnb4d2wQAAGBn2fKAraojkvxekocluWuSH66qu271dgEAANhZtuMM7H2SXNLdl3b3F5O8KMnJ27BdAAAAdpA927CNY5N8bNP0ZUm+d/+Fquq0JKctk5+vqou3YWyszh2SXL3uQRw+nrruAQCzOaZ+GcdU4CZxTP0yI46p53b3SQd6YjsC9gbp7jOTnLnucfC1qarzu3vfuscBsBM4pgKsjmPqzrIdlxB/PMkdN00ft8wDAACAG2w7AvbtSU6oqjtX1ZFJHpvknG3YLgAAADvIll9C3N3XVNXPJHldkiOSPL+737fV22XbufwbYHUcUwFWxzF1B6nuXvcYAAAA4JC24xJiAAAAuMkELAAAACMIWFJVP1tV76+qF1TVI6vq9HWPaX9V9UvrHgPAVqqqs6rqUV/DesdX1Y9sxZgAdrr932NW1V/egHU+v3Uj4lDcA7tLVFVl4//v6w7w3AeSPLi7L9v+kd0wVfX57r71uscBsFWq6qwkr+7ul97I9U5M8tTufsRWjAtgJ/ta3mN6X7pezsDuYMtf5S+uqj9KcmGSf1dVb6+q91bVryzL/Lck35rktVX15Kp6fFX97vLcWVX1nKr6y6q6dPOZgar6hQO81vFV9YFlvb9ezug+uKr+oqo+WFX3WZa7VVU9v6reVlXvqqqTl/mPr6qXV9W5y/K/vsw/I8ktqurdVfWCbfyfEOAmWY53r6mq91TVhVX1mKr6nqr6s6p6R1W9rqqOOcB6B1ymqu5SVf9reb13VtW3JTkjyT9djpFP3u7fEWCVqupHl/eI766qP6iqI5b3lhdW1QXXH+eWKwgvWt6LvmiZd5PfY15/drWqbl1V5y3H2guufy3WzxnYHayqjk9yaZJ/kuQbkzwqyb9OUtn4Lt5f7+43V9WHk+zr7qur6vHL459ZzgbcKsljknxHknO6+y5V9dADvVaSjya5JMm9krwvG98B/J4kT0zyyCQ/0d2nVNWvJbmou/+4qo5K8rZlnR9K8u+Xx19IcnGS+3f3x/ylC5ioqn4wyUnd/a+W6dskeW2Sk7v7qqp6TJLv7+4nXH8GNsmrkvzZQZZ5a5IzuvsVVXXzbPwh+j5xBhbYAarqO7PxnvJfdPeXquq5Sa7IxvvBhyzLHNXdn66q/5vkzt39hU3zbvJ7zOunq2pPklt292er6g5J3pLkhO5u70vXa8u/B5a1+0h3v6WqfjPJQ5O8a5l/6yQnJHnzIdZ/5XLZ8UVVdfQy76EHea2PJvlQd1+QJFX1viTnLf+iX5Dk+E3rP7KqnrpM3zzJnZbH53X3Z5b1L0ryLUk+duN/bYDDwgVJnlVVz8xGnH4qyd2SvKGqko3vR798v3W+/UDLVNU3JDm2u1+RJN3990myLAOwEzwoyfckeftybLtFknOTfGtV/dckr0ny+mXZ9yZ5QVW9Mskrl3mrfI9ZSX6tqh6Q5LokxyY5OsknbuovyU0jYHe+v11+VpL/0t1/cCPX/8Kmx7Xp51e81nLGd/Py122avi7/sL9Vkh/s7ov3W/9791v/2thHgcG6+6+r6t5JfiDJryb50yTv6+77fZXV6kDLLAELsJNVkrO7++lfNrPqGUm+P8lPJnl0kickeXiSByT550meUVV3z2rfYz4uyd4k37OcDf5wNoKYNXMP7O7xuiRPqKpbJ0lVHVtV37Sm13pdkn9by5/WqupeN2CdL1XVzW78UAHWp6q+OcnfdfcfJ/mNJN+bZG9V3W95/mZV9V37rXbxgZbp7s8luayqTlnmf31V3TLJ55KIW2AnOC/Jo65/X1lVt6uqb0nydd39siS/nOTeVfV1Se7Y3W9M8rQkt8nGFYGrfI95myRXLvH6z7JxxpbDgLNbu0R3v365r+Cvln+nP5/kR5NcucLXuvYGvsR/SvLbSd67HIA+lORQ926duSz/zu5+3I0dM8Ca3D3Jb1TVdUm+lOTfJLkmyXOW+2H3ZON4+L7rV+juL9bGh+YdaJkfS/IHVfUfl9f7oWxcRndtVb0nyVnd/ext++0AVqi7L6qqX07y+uU94peS/HySVyzTSfL0bNxa8cfLMbKSPGe5B3aV7zFfkORPltvgzk/ygRX9mtxEPsQJAACAEVxCDAAAwAgCFgAAgBEELAAAACMIWAAAAEYQsAAAAIwgYAEAABhBwAIAADCCgAUAAGAEAQsAAMAIe9Y9gAM56aST+txzz133MAAAANh+dbAnDsszsFdfffW6hwAAAMBh5rAMWAAAANifgAUAAGAEAQsAAMAIAhYAAIARBCwAAMAOduKJJ+bEE09c9zBWQsACAAAwgoAFAABgBAELAADACAIWAACAEQQsAAAAIwhYAAAARhCwAAAAjCBgAQAAGEHAAgAAMIKABQAAYAQBCwAAwAh71j2AA7n2S1fkM5c/a93DAAAAGO+aL34se46847qHsRLOwAIAADCCgAUAAGAEAQsAAMAIAhYAAIARBCwAAAAjCFgAAABGELAAAACMIGABAAAYQcACAAAwgoAFAABgBAELAADACAIWAACAEQQsAAAAIwhYAAAARhCwAAAAjCBgAQAAGEHAAgAAMIKABQAAYAQBCwAAwAgCFgAAgBEELAAAACMIWAAAAEYQsAAAAIwgYAEAABhBwAIAADCCgAUAAGAEAQsAAMAIAhYAAIARBCwAAAAjCFgAAABGELAAAACMIGABAAAYQcACAAAwgoAFAABgBAELAADACAIWAACAEQQsAAAAIwhYAAAARhCwAAAAjCBgAQAAGEHAAgAAMIKABQAAYAQBCwAAwAhfNWCr6qiq+qlDLHN8Vf3IoTa0LHfhjR0gAAAAJIc+A3tUkq8asEmOT3LIgAUAAICbYs8hnj8jybdV1buTvGGZ97AkneRXu/vFyzLfuSxzdpJXJPkfSW61LP8z3f2XKx85AAAAu8qhAvb0JHfr7ntW1Q8m+ckk90hyhyRvr6o3L8s8tbsfkSRVdcskD+nuv6+qE5K8MMm+LfsNAAAA2BUOFbCb3T/JC7v72iRXVNWfJfnHST6733I3S/K7VXXPJNcm+Uc35MWr6rQkpyXJHY+97Y0YFgAAALvBVnwK8ZOTXJGNM7X7khx5Q1bq7jO7e19377v97W916BUAAADYVQ4VsJ9L8g3L4z9P8piqOqKq9iZ5QJK37bdMktwmyeXdfV2SH0tyxGqHDAAAwG70VS8h7u5PVtVfLF9/89ok703ynmx8iNMvdvcnquqTSa6tqvckOSvJc5O8rKp+PMm5Sf52K38BAAAAdodD3gPb3ft/Rc4v7Pf8l5I8cL9lvnvT46cty304yd1u/BABAABga+6BBQAAgJUTsAAAAIwgYAEAABhBwAIAADCCgAUAAGAEAQsAAMAIAhYAAIARBCwAAAAjCFgAAABGELAAAACMIGABAAAYQcACAAAwgoAFAABgBAELAADACAIWAACAEQQsAAAAIwhYAAAARhCwAAAAjCBgAQAAGEHAAgAAMIKABQAAYAQBCwAAwAgCFgAAgBEELAAAACMIWAAAAEYQsAAAAIwgYAEAABhBwAIAADCCgAUAAGAEAQsAAMAIAhYAAIARBCwAAAAjCFgAAABGELAAAACMIGABAAAYQcACAAAwgoAFAABgBAELAADACAIWAACAEQQsAAAAIwhYAAAARhCwAAAAjCBgAQAAGGHPugdwIEfc7Ojc5pinrHsYAAAA4+058k/WPYSVcQYWAACAEQQsAAAAIwhYAAAARhCwAAAAjCBgAQAAGEHAAgAAMIKABQAAYAQBCwAAwAgCFgAAgBEELAAAACMIWAAAAEbYs+4BAAAAsHXe9KY3rXsIK+MMLAAAACMIWAAAAEYQsAAAAIwgYAEAABhBwAIAADBCdfe6x/AVqurC7r7busfB4aGqTuvuM9c9Dg4P9gc2sz+wmf2B69kX2Mz+sLMcrmdg/37dA+Cwctq6B8Bhxf7AZvYHNrM/cD37ApvZH3aQwzVgAQAA4MsIWAAAAEY4XAPWNepsZn9gM/sDm9kf2Mz+wPXsC2xmf9hBDssPcQIAAID9Ha5nYAEAAODLHFYBW1UnVdXFVXVJVZ2+7vGwvarqjlX1xqq6qKreV1VPWubfrqreUFUfXH7edt1jZftU1RFV9a6qevUyfeeqeutynHhxVR257jGyParqqKp6aVV9oKreX1X3c3zYvarqyct/Ky6sqhdW1c0dH3aPqnp+VV1ZVRdumnfA40FteM6yX7y3qu69vpGzFQ6yP/zG8t+L91bVK6rqqE3PPX3ZHy6uqu9fz6j5Wh02AVtVRyT5vSQPS3LXJD9cVXdd76jYZtckeUp33zXJfZP89LIPnJ7kvO4+Icl5yzS7x5OSvH/T9DOTPLu775LkU0meuJZRsQ6/k+Tc7v6OJPfIxn7h+LALVdWxSX42yb7le+OPSPLYOD7sJmclOWm/eQc7HjwsyQnLP6cl+f1tGiPb56x85f7whiR36+7vTvLXSZ6eJMt7y8cm+a5lnecuHcIQh03AJrlPkku6+9Lu/mKSFyU5ec1jYht19+Xd/c7l8eey8eb02GzsB2cvi52d5JT1jJDtVlXHJXl4kj9cpivJA5O8dFnE/rBLVNVtkjwgyfOSpLu/2N2fjuPDbrYnyS2qak+SWya5PI4Pu0Z3vznJ3+w3+2DHg5OT/FFveEuSo6rqmO0ZKdvhQPtDd7++u69ZJt+S5Ljl8clJXtTdX+juDyW5JBsdwhCHU8Aem+Rjm6YvW+axC1XV8UnuleStSY7u7suXpz6R5Og1DYvt99tJfjHJdcv07ZN8etN/kBwndo87J7kqyX9fLin/w6q6VRwfdqXu/niS30zy0WyE62eSvCOOD7vdwY4H3mPyhCSvXR7bH4Y7nAIWkiRVdeskL0vyc9392c3P9cbHZvvo7F2gqh6R5Mrufse6x8JhYU+Seyf5/e6+V5K/zX6XCzs+7B7LvY0nZ+MPG9+c5Fb5yssH2cUcD7heVT0jG7epvWDdY2E1DqeA/XiSO26aPm6Zxy5SVTfLRry+oLtfvsy+4vpLfZafV65rfGyr70vyyKr6cDZuKXhgNu6BPGq5ZDBxnNhNLktyWXe/dZl+aTaC1vFhd3pwkg9191Xd/aUkL8/GMcPxYXc72PHAe8xdqqoen+QRSR7X//DdofaH4Q6ngH17khOWTxA8Mhs3V5+z5jGxjZb7G5+X5P3d/VubnjonyanL41OTvGq7x8b26+6nd/dx3X18No4Hf9rdj0vyxiSPWhazP+wS3f2JJB+rqm9fZj0oyUVxfNitPprkvlV1y+W/HdfvD44Pu9vBjgfnJPnx5dOI75vkM5suNWaHqqqTsnEb0iO7++82PXVOksdW1ddX1Z2z8eFeb1vHGPna1D/8MWL9quoHsnHP2xFJnt/d/3nNQ2IbVdX9k/x5kgvyD/c8/lI27oN9SZI7JflIkkd39/4f3MAOVlUnJnlqdz+iqr41G2dkb5fkXUl+tLu/sM7xsT2q6p7Z+ECvI5NcmuQnsvGHWMeHXaiqfiXJY7JxaeC7kvzLbNzH5viwC1TVC5OcmOQOSa5I8h+SvDIHOB4sf+T43WxcZv53SX6iu89fx7jZGgfZH56e5OuTfHJZ7C3d/ZPL8s/Ixn2x12TjlrXX7v+aHL4Oq4AFAACAgzmcLiEGAACAgxKwAAAAjCBgAQAAGEHAAgAAMIKABQAAYAQBCwAAwAgCFmZza6YAAAAQSURBVAAAgBEELAAAACP8P4ODD656TmeoAAAAAElFTkSuQmCC\n",
            "text/plain": [
              "<Figure size 936x576 with 2 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    }
  ]
}