marks.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Ee-fRanfr3Tb"
      },
      "source": [
        "**<h1>Додатки до дипломів (оцінки)</h1>**"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "waj1cYo7rC1e"
      },
      "source": [
        "**<h3><i>Dependencies</i></h3>**"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "id": "wylh60lvr2sd"
      },
      "outputs": [],
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n",
        "import re"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "**<h3><i>Settings</i></h3>**"
      ],
      "metadata": {
        "id": "k8XBsVZhWhQh"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# turn off chained assignment warning\n",
        "pd.options.mode.chained_assignment = None"
      ],
      "metadata": {
        "id": "9QU_RGDheA23"
      },
      "execution_count": 2,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "<h3><b><i>Constants</i></b></h3>"
      ],
      "metadata": {
        "id": "0U8x2Umm4SRW"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "<h3><font color=\"purple\"><b>Увага! Код коректно збирає дані лише з тих рейтингів, які були попередньо перевірені на відсутність одруків та співпадіння з навчальним планом</b></font></h3>"
      ],
      "metadata": {
        "id": "e5q0A8-w4tEa"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# ІНФОРМАЦІЯ ПРО ДИСЦИПЛІНИ\n",
        "ALL_RATING_FILES = [\n",
        "    [\"reiting_20 - 21 (prepared).xlsx\", 2020, 2021],\n",
        "    [\"reiting_21 - 22 (prepared).xlsm\", 2021, 2022],\n",
        "    [\"reiting_22 - 23 (prepared).xlsx\", 2022, 2023],\n",
        "    [\"reiting_23 - 24 (prepared).xlsx\", 2023, 2024]\n",
        "]\n",
        "\n",
        "SUBJECT_TRANSLATE = \"subject_translate.xlsx\"\n",
        "GRADUATES_CODES = \"graduates_codes.xlsx\""
      ],
      "metadata": {
        "id": "tjdyM5u-WgYf"
      },
      "execution_count": 3,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "**<h2>1. Збір даних</h2>**"
      ],
      "metadata": {
        "id": "ZU9OdpxmWH5X"
      }
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "6Ix_tiSurC1g"
      },
      "source": [
        "**<h3>1.1 Читання метаданих про дисципліни</h3>**"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 4,
      "metadata": {
        "id": "lD3ttYIVrC1g"
      },
      "outputs": [],
      "source": [
        "def collect_subject_metadata(df):\n",
        "    # Detect the cut points\n",
        "    mask = df == \"Прізвище, ім'я студента\"\n",
        "    semester_data_start  = np.where(mask.any())[0]\n",
        "\n",
        "    mask = df == \"Сер.зважений бал за навчання\"\n",
        "    semester_data_end  = np.where(mask.any())[0]\n",
        "\n",
        "    metadata_all = list()\n",
        "    for i in range(0, len(semester_data_start)): # для 2-х семестрів\n",
        "\n",
        "        if len(semester_data_start) != len(semester_data_end):\n",
        "            continue\n",
        "\n",
        "        semester = df.iloc[:, semester_data_start[i]:semester_data_end[i]]\n",
        "\n",
        "        # Detect rows with subject metadata\n",
        "        credits_row_index = semester[semester.eq(\"Кредити\").any(axis=1)].index.tolist()[0]\n",
        "        teachers_row_index = credits_row_index + 5\n",
        "\n",
        "        # Drop extra rows\n",
        "        metadata = semester.loc[credits_row_index:teachers_row_index].dropna(axis=1)\n",
        "        #metadata = metadata.iloc[:, 1:]\n",
        "        metadata = metadata[:-1]\n",
        "\n",
        "        # Rename row indexes\n",
        "        new_index_names = [\"credits\", \"hours\", \"type\", \"subject\", \"teacher_name\"]\n",
        "        metadata = metadata.rename(index=dict(zip(metadata.index, new_index_names)))\n",
        "\n",
        "        metadata_all.append(metadata)\n",
        "\n",
        "    return metadata_all"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "CddYsruZrC1g"
      },
      "source": [
        "**<h3>1.2 Читання даних про оцінки за дисципліни</h3>**"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 5,
      "metadata": {
        "id": "ZC-LQ8fWrC1h"
      },
      "outputs": [],
      "source": [
        "def collect_student_data(df):\n",
        "    # Detect the cut points\n",
        "    mask = df == \"Прізвище, ім'я студента\"\n",
        "    semester_data_start  = np.where(mask.any())[0]\n",
        "\n",
        "    mask = df == \"Сер.зважений бал за навчання\"\n",
        "    semester_data_end  = np.where(mask.any())[0]\n",
        "\n",
        "    student_data_all = list()\n",
        "    for i in range(0, len(semester_data_start)): # для 2-х семестрів\n",
        "\n",
        "        if len(semester_data_start) != len(semester_data_end):\n",
        "            continue\n",
        "\n",
        "        semester = df.iloc[:, semester_data_start[i]:semester_data_end[i]]\n",
        "\n",
        "        # If some row is not about student it has NaN in \"Номер заліковки\"\n",
        "        semester = semester.dropna(subset=[semester.columns[1]])\n",
        "\n",
        "        # Індекс на основі першого рядка\n",
        "        semester.columns = semester.iloc[0]\n",
        "\n",
        "        semester = semester[1:]\n",
        "\n",
        "        student_data = semester.melt(id_vars = semester.columns[0:4])\n",
        "\n",
        "        student_data.columns = [\"student_name\", \"code\", \"payment\", \"group\", \"subject\", \"grade\"]\n",
        "\n",
        "        student_data_all.append(student_data)\n",
        "\n",
        "    return student_data_all"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "**<h3>1.3 Функція для трансформації оцінки в ECTS</h3>**"
      ],
      "metadata": {
        "id": "dAELaXzZ7eBu"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "def score_to_ects(score):\n",
        "    if 90 <= score <= 100:\n",
        "        return \"A\"\n",
        "    elif 82 <= score < 90:\n",
        "        return \"B\"\n",
        "    elif 75 <= score < 82:\n",
        "        return \"C\"\n",
        "    elif 64 <= score < 75:\n",
        "        return \"D\"\n",
        "    elif 60 <= score < 64:\n",
        "        return \"E\"\n",
        "    elif 35 <= score < 60:\n",
        "        return \"FX\"\n",
        "    elif score < 35:\n",
        "        return \"F\"\n",
        "    else:\n",
        "        return None"
      ],
      "metadata": {
        "id": "3QExuuds3FMI"
      },
      "execution_count": 6,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "**<h3>1.4 Функція для трансформації оцінки в національну шкалу</h3>**"
      ],
      "metadata": {
        "id": "QWqB6Ljv7mhO"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "def score_to_national_grade(ects, type):\n",
        "    if type == \"з\":\n",
        "      return \"Зараховано/Passed\"\n",
        "\n",
        "    if ects == \"A\":\n",
        "        return \"Відмінно/Excellent\"\n",
        "    elif ects == \"B\" or ects == \"C\":\n",
        "        return \"Добре/Good\"\n",
        "    elif ects == \"D\" or ects == \"E\":\n",
        "        return \"Задовільно/Satisfactory\"\n",
        "    else:\n",
        "        return None"
      ],
      "metadata": {
        "id": "x74Gsi9W30-w"
      },
      "execution_count": 7,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "**<h3>1.5 Скорочення ПІБ до ПІ</h3>**"
      ],
      "metadata": {
        "id": "xcU-RroqARWc"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "def short_student_name(name):\n",
        "  parts = name.split()\n",
        "  return ' '.join(parts[:2]).strip()"
      ],
      "metadata": {
        "id": "E6e7ThK3ARw8"
      },
      "execution_count": 8,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "**<h3>1.6 Розрахунок семестру</h3>**"
      ],
      "metadata": {
        "id": "j14BJvq3DbNi"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "def get_semester(group, semester):\n",
        "  course = int(str(group)[0])\n",
        "  return 2 * (course - 1) + (semester + 1)"
      ],
      "metadata": {
        "id": "MyTQv4FODgc9"
      },
      "execution_count": 9,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "<h3><b>1.7 Логіка для вибору оцінки та визначення суми годин та кредитів у випадку дублювання дисципліни</b></h3>"
      ],
      "metadata": {
        "id": "blnaEWtmBhg9"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "def get_priority(type):\n",
        "  if type == \"і\":\n",
        "    return 1\n",
        "  elif type == \"з\":\n",
        "    return 2\n",
        "  elif type == \"а\":\n",
        "    return 3\n",
        "\n",
        "  return None"
      ],
      "metadata": {
        "id": "Nem2CZd-GGA7"
      },
      "execution_count": 10,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "<h2><b>2. Читання даних</b></h2>"
      ],
      "metadata": {
        "id": "g1wVte3YCogM"
      }
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "dCdfI1q7rC1i"
      },
      "source": [
        "**<h3>2.1 Читання кожного аркуша (номер групи) з Excel-файла</h3>**"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 11,
      "metadata": {
        "id": "KHfBqXsLrC1i"
      },
      "outputs": [],
      "source": [
        "def xls_to_dataframe(file, study_year_start, study_year_end):\n",
        "    groups = [sheet_name for sheet_name in file.sheet_names if re.match(r'^\\d+м?$', sheet_name) ]\n",
        "\n",
        "    data = list()\n",
        "    for group in groups:\n",
        "        df = file.parse(group)\n",
        "\n",
        "        metadata_all = collect_subject_metadata(df)\n",
        "        student_data_all = collect_student_data(df)\n",
        "\n",
        "        for semester in range(0, len(metadata_all)):\n",
        "            metadata = metadata_all[semester]\n",
        "            student_data = student_data_all[semester]\n",
        "\n",
        "            merged_dataset = pd.merge(student_data, metadata.transpose(), on='subject')\n",
        "            merged_dataset[\"semester\"] = semester\n",
        "\n",
        "            data.append(merged_dataset)\n",
        "\n",
        "    return pd.concat(data, axis=0)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "fXGIasstrC1j"
      },
      "source": [
        "**<h3>2.2 Читання та збереження даних з файлів</h3>**"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 12,
      "metadata": {
        "id": "9S56hEuTrC1j"
      },
      "outputs": [],
      "source": [
        "# ДАНІ ПРО ОЦІНКИ\n",
        "content = list()\n",
        "for file_data in ALL_RATING_FILES:\n",
        "  file = pd.ExcelFile(file_data[0])\n",
        "  content.append(xls_to_dataframe(file, study_year_start=file_data[1], study_year_end=file_data[2]))\n",
        "\n",
        "data = pd.concat(content, ignore_index=True, axis=0)\n",
        "\n",
        "# Вважати що рядок містить дані про студента лише тоді коли вказано номер групи та спосіб фінансування\n",
        "data = data[data[\"group\"].notna() & data[\"payment\"].notna()]\n",
        "\n",
        "# Не враховувати пусті комірки (предмети з яких ще не було іспитів / заліків / курсових тощо)\n",
        "data = data[data[\"grade\"].notna() & (data[\"grade\"] != \"#ЗНАЧ!\")]\n",
        "\n",
        "subject_translate = pd.read_excel(SUBJECT_TRANSLATE)"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "**<h2>3. Обробка даних</h2>**"
      ],
      "metadata": {
        "id": "pngPHA81X-or"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "<h3><b>3.1 Змінити тип даних для оцінки</b></h3>"
      ],
      "metadata": {
        "id": "QwaTvQmL57zH"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "data[\"grade\"] = data[\"grade\"].replace(r\".*н.*\", 0, regex=True).astype(int)"
      ],
      "metadata": {
        "id": "-A3LtJbI56kQ"
      },
      "execution_count": 13,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "<h3><b>3.2 Додати бал ECTS</b></h3>"
      ],
      "metadata": {
        "id": "7jVfgHAd6CT-"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "data['grade_ects'] = data.apply(lambda row: score_to_ects(row['grade']), axis=1)"
      ],
      "metadata": {
        "id": "dFKYBDy33JlW"
      },
      "execution_count": 14,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "<h3><b>3.3 Додати бал за національною шкалою</b></h3>"
      ],
      "metadata": {
        "id": "IqoyBqgu6Kgu"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "data['national_grade'] = data.apply(lambda row: score_to_national_grade(row['grade_ects'], row['type']), axis=1)"
      ],
      "metadata": {
        "id": "TDrzYoPG5nwm"
      },
      "execution_count": 15,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "<h3><b>3.4 ПІБ скоротити до ПІ</b></h3>"
      ],
      "metadata": {
        "id": "3YJ7Jzjd_7vX"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "data['student_name'] = data.apply(lambda row: short_student_name(row['student_name']), axis=1)"
      ],
      "metadata": {
        "id": "F97SytNfACWo"
      },
      "execution_count": 16,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "<h3><b>3.5 Визначення номеру семестру (наскрізна нумерація)</b></h3>"
      ],
      "metadata": {
        "id": "WVtHHknJClcR"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "data[\"semester\"] = data.apply(lambda row: get_semester(row['group'], row['semester']), axis=1)"
      ],
      "metadata": {
        "id": "hthuButDBwKd"
      },
      "execution_count": 17,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "<h3><b>3.6 Форматування номеру групи</b></h3>"
      ],
      "metadata": {
        "id": "79SbuJU79K39"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "data[\"group\"] = data[\"group\"].astype(int).astype(str)"
      ],
      "metadata": {
        "id": "ueiTgdA15mpL"
      },
      "execution_count": 18,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "<h3><b>3.7 Встановлення пріоритету оцінки в залежності від типу підсумкового контролю</b></h3>"
      ],
      "metadata": {
        "id": "tl8LGIGQGvje"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "data[\"priority\"] = data.apply(lambda row: get_priority(row['type']), axis=1)"
      ],
      "metadata": {
        "id": "2Lp-DcyuG2z5"
      },
      "execution_count": 19,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "<h3><b>3.8 Попередня фільтрація даних (залишити лише випускників)</b></h3>"
      ],
      "metadata": {
        "id": "LjSv48299WTH"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "graduates = set(pd.read_excel(GRADUATES_CODES)[\"student_code\"])\n",
        "data = data[data[\"code\"].isin(graduates)]"
      ],
      "metadata": {
        "id": "1mZPWfiiV-pi"
      },
      "execution_count": 20,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "<h3><b><font color=\"red\">3.9 Важливо! Відсортувати перед групуванням для вибору оцінки згідно з пріоритетом іспиту, заліку та атестації</font></b></h3>"
      ],
      "metadata": {
        "id": "oufyfgd6fFQv"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "data = data.sort_values(by=[\"subject\", \"priority\", \"semester\"], ascending=[True, True, False])"
      ],
      "metadata": {
        "id": "Ggyi4QDV9U4t"
      },
      "execution_count": 21,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "<h2><b>4. Формування та збереження таблиці оцінок</b></h2>"
      ],
      "metadata": {
        "id": "Y1Rl1Cw-DoKj"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "<h3><b>4.1 Агрегація</b></h3>"
      ],
      "metadata": {
        "id": "HzdNbi9Tghjq"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "result = data.groupby(['code', 'subject']).agg({\n",
        "    'student_name': 'first',\n",
        "    'semester': 'first',\n",
        "    'credits': 'sum',\n",
        "    'hours': 'sum',\n",
        "    'type': 'first',\n",
        "    'grade_ects': 'first',\n",
        "    'national_grade': 'first',\n",
        "    'grade': 'first'\n",
        "}).reset_index()"
      ],
      "metadata": {
        "id": "GqBFb3ctEdl0"
      },
      "execution_count": 22,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "<h3><b>4.2 Розрахунок кількості годин на основі кількості кредитів (1 кредит = 30 годин)</b></h3>"
      ],
      "metadata": {
        "id": "O03MCLCbgo6O"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "result[\"hours\"] = result[\"credits\"] * 30"
      ],
      "metadata": {
        "id": "v7sCNOeDoSko"
      },
      "execution_count": 23,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "<h3><b>4.3 Форматований запис даних про кредити та години та назву дисципліни</b></h3>"
      ],
      "metadata": {
        "id": "LCiyM6zymVFl"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "result = pd.merge(result, subject_translate, on='subject', how='left').drop_duplicates().sort_values(by=[\"semester\", \"subject\"])\n",
        "result[\"credits_hours\"] = result.apply(lambda row: f\"{row['credits']:.1f} ({row['hours']:.0f})\", axis=1)\n",
        "result[\"subject\"] = result.apply(lambda row: f\"{row['subject']} / {row['subject_eng']}\", axis=1)"
      ],
      "metadata": {
        "id": "9SzzTHwNmbkg"
      },
      "execution_count": 24,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "<h3><b>4.4 Запис файлу</b></h3>"
      ],
      "metadata": {
        "id": "QFl58hWug29K"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "result.to_csv('marks.csv')"
      ],
      "metadata": {
        "id": "lAAdL4X-1wxa"
      },
      "execution_count": 25,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "<h2><b>5. Виписка оцінок на одного студента (для перевірки)</b></h2>"
      ],
      "metadata": {
        "id": "mEzrALRoQ3p8"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "code = 22010917"
      ],
      "metadata": {
        "id": "youNIbGLRF-G"
      },
      "execution_count": 26,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "student_data = result[result['code'] == code]\n",
        "student_data"
      ],
      "metadata": {
        "id": "D3K6VVxqKKzF",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "4c0c4589-1aaf-48e6-d8db-e55b38382a46"
      },
      "execution_count": 27,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "           code                                            subject  \\\n",
              "10325  22010917  Історія та культура України / History and cult...   \n",
              "10381  22010917  Основи програмної інженерії / Fundamentals of ...   \n",
              "10405  22010917  Українська мова (за професійним спрямуванням) ...   \n",
              "10415  22010917                             Філософія / Philosophy   \n",
              "10321  22010917  Іноземна мова (англійська) (додатково) (ДОП) /...   \n",
              "10323  22010917  Інформаційні технології (ДОП) / Information te...   \n",
              "10331  22010917    Архітектура комп'ютерів / Computer architecture   \n",
              "10339  22010917               Вища математика / Higher mathematics   \n",
              "10343  22010917  Дискретні структури та дискретна математика / ...   \n",
              "10382  22010917  Основи програмування / Fundamentals of program...   \n",
              "10387  22010917    Програмування в Інтернет / Internet programming   \n",
              "10409  22010917  Фізика (вибрані розділи) / Physics (selected s...   \n",
              "10316  22010917                Web-програмування / Web programming   \n",
              "10330  22010917  Алгоритми та структури даних / Algorithms and ...   \n",
              "10344  22010917  Дисципліна за вибиром студента 1 / Discipline ...   \n",
              "10360  22010917  Комп'ютерна графіка та обробка зображень / Com...   \n",
              "10370  22010917          Навчальна практика / Educational practice   \n",
              "10396  22010917  Теорія ймовірностей та математична статистика ...   \n",
              "10403  22010917  Технології комп'ютерного проєктування / Techno...   \n",
              "10404  22010917  Технології комп'ютерного проєктування (КР) / C...   \n",
              "10359  22010917  Емпіричні методи програмної інженерії / Empiri...   \n",
              "10365  22010917  Людино-машинна взаємодія / Human-machine inter...   \n",
              "10366  22010917  Мова програмування Python / Python programming...   \n",
              "10372  22010917  Об'єктно-орієнтоване програмування / Object-or...   \n",
              "10374  22010917  Об'єктно-орієнтоване програмування (КР) / Obje...   \n",
              "10376  22010917             Операційні системи / Operating Systems   \n",
              "10378  22010917  Організація баз даних / Organization of databases   \n",
              "10411  22010917             Фізичне виховання / Physical Education   \n",
              "10418  22010917                Чисельні методи / Numerical Methods   \n",
              "10310  22010917             Backend розробка / Backend development   \n",
              "10314  22010917                  Web development / Web development   \n",
              "10315  22010917        Web development (КР) / Web development (КР)   \n",
              "10355  22010917   Дисципліна за вибором 1 / Discipline of choice 1   \n",
              "10368  22010917  Мова програмування Ruby / Ruby programming lan...   \n",
              "10391  22010917  Розробка адаптивних web-інтерфейсів / Developm...   \n",
              "10399  22010917     Технологічна практика / Technological practice   \n",
              "10311  22010917  Database developement та трьохланкові застосун...   \n",
              "10312  22010917  Database developement та трьохланкові застосун...   \n",
              "10318  22010917  Іноземна мова (англійська) / Foreign language ...   \n",
              "10336  22010917                    Виробнича практика / Internship   \n",
              "10348  22010917       Дисципліна за вибором / Discipline of choice   \n",
              "10361  22010917             Комп'ютерні мережі / Computer networks   \n",
              "10388  22010917  Професійна практика програмної інженерії / Pro...   \n",
              "10392  22010917  Розробка програмного забезпечення для ОС Andro...   \n",
              "10420  22010917  Якість програмного забезпечення та тестування ...   \n",
              "10313  22010917  FullStack web-розробка / FullStack web develop...   \n",
              "10329  22010917  Адміністрування обчислювальних комплексів / Ad...   \n",
              "10334  22010917  Безпека життєдіяльності (безпека життєдіяльнос...   \n",
              "10352  22010917  Дисципліна за вибором (загал) / Discipline of ...   \n",
              "10369  22010917  Моделювання та аналіз програмного забезпечення...   \n",
              "10390  22010917  Розробка web-застосунків на базі Java EE / Dev...   \n",
              "10402  22010917  Технологія захисту програм та даних / Program ...   \n",
              "10322  22010917  Іноземна мова (за професійним спрямуванням) / ...   \n",
              "10333  22010917  Архітектура та проєктування програмного забезп...   \n",
              "10342  22010917  Групова динаміка і комунікації / Group dynamic...   \n",
              "10364  22010917  Конструювання програмного забезпечення / Softw...   \n",
              "10384  22010917      Переддипломна практика / Pre-diploma practice   \n",
              "10389  22010917  Реінжиніринг програмного забезпечення / Softwa...   \n",
              "10394  22010917  Розробка ігрових застосунків / Development of ...   \n",
              "\n",
              "               student_name  semester credits  hours type grade_ects  \\\n",
              "10325  Олексієнко Володимир         1       6    180    з          A   \n",
              "10381  Олексієнко Володимир         1       5    150    і          A   \n",
              "10405  Олексієнко Володимир         1       3     90    і          A   \n",
              "10415  Олексієнко Володимир         1       3     90    з          A   \n",
              "10321  Олексієнко Володимир         2     5.5  165.0    а          A   \n",
              "10323  Олексієнко Володимир         2     8.0  240.0    з          A   \n",
              "10331  Олексієнко Володимир         2       4    120    з          A   \n",
              "10339  Олексієнко Володимир         2     8.0  240.0    і          A   \n",
              "10343  Олексієнко Володимир         2     7.0  210.0    і          A   \n",
              "10382  Олексієнко Володимир         2       8    240    і          A   \n",
              "10387  Олексієнко Володимир         2       4    120    з          A   \n",
              "10409  Олексієнко Володимир         2       5    150    і          A   \n",
              "10316  Олексієнко Володимир         3       3     90    з          C   \n",
              "10330  Олексієнко Володимир         3       4    120    і          C   \n",
              "10344  Олексієнко Володимир         3       3     90    з          A   \n",
              "10360  Олексієнко Володимир         3       3     90    з          D   \n",
              "10370  Олексієнко Володимир         3       3     90   ПР          A   \n",
              "10396  Олексієнко Володимир         3       4    120    і          C   \n",
              "10403  Олексієнко Володимир         3       2     60    і          B   \n",
              "10404  Олексієнко Володимир         3       1     30   КР          A   \n",
              "10359  Олексієнко Володимир         4       4    120    і          D   \n",
              "10365  Олексієнко Володимир         4       4    120    з          D   \n",
              "10366  Олексієнко Володимир         4       4    120    з          D   \n",
              "10372  Олексієнко Володимир         4       8    240    з          C   \n",
              "10374  Олексієнко Володимир         4       1     30   КР          A   \n",
              "10376  Олексієнко Володимир         4       4    120    і          B   \n",
              "10378  Олексієнко Володимир         4       4    120    і          D   \n",
              "10411  Олексієнко Володимир         4       0      0    з          D   \n",
              "10418  Олексієнко Володимир         4       4    120    і          D   \n",
              "10310  Олексієнко Володимир         5       5    150    і          C   \n",
              "10314  Олексієнко Володимир         5       4    120    і          B   \n",
              "10315  Олексієнко Володимир         5       1     30   КР          B   \n",
              "10355  Олексієнко Володимир         5       3     90    з          A   \n",
              "10368  Олексієнко Володимир         5       5    150    з          D   \n",
              "10391  Олексієнко Володимир         5       5    150    з          A   \n",
              "10399  Олексієнко Володимир         5       3     90   ПР          A   \n",
              "10311  Олексієнко Володимир         6       4    120    і          B   \n",
              "10312  Олексієнко Володимир         6       1     30   КР          A   \n",
              "10318  Олексієнко Володимир         6    14.0  420.0    з          C   \n",
              "10336  Олексієнко Володимир         6       3     90   ПР          A   \n",
              "10348  Олексієнко Володимир         6       3     90    з          A   \n",
              "10361  Олексієнко Володимир         6       5    150    і          B   \n",
              "10388  Олексієнко Володимир         6       5    150    з          C   \n",
              "10392  Олексієнко Володимир         6       5    150    з          D   \n",
              "10420  Олексієнко Володимир         6       5    150    і          C   \n",
              "10313  Олексієнко Володимир         7       4    120    і          B   \n",
              "10329  Олексієнко Володимир         7       4    120    і          C   \n",
              "10334  Олексієнко Володимир         7       3     90  диф          C   \n",
              "10352  Олексієнко Володимир         7       3     90    з          E   \n",
              "10369  Олексієнко Володимир         7       3     90    і          A   \n",
              "10390  Олексієнко Володимир         7       4    120    з          C   \n",
              "10402  Олексієнко Володимир         7       3     90    і          B   \n",
              "10322  Олексієнко Володимир         8       4    120    з          C   \n",
              "10333  Олексієнко Володимир         8       4    120    і          C   \n",
              "10342  Олексієнко Володимир         8       4    120    і          A   \n",
              "10364  Олексієнко Володимир         8       3     90    і          B   \n",
              "10384  Олексієнко Володимир         8       3     90   ПР          A   \n",
              "10389  Олексієнко Володимир         8       4    120    з          D   \n",
              "10394  Олексієнко Володимир         8       5    150    з          E   \n",
              "\n",
              "                national_grade  grade  \\\n",
              "10325        Зараховано/Passed     90   \n",
              "10381       Відмінно/Excellent    100   \n",
              "10405       Відмінно/Excellent     90   \n",
              "10415        Зараховано/Passed     95   \n",
              "10321       Відмінно/Excellent     96   \n",
              "10323        Зараховано/Passed    100   \n",
              "10331        Зараховано/Passed    100   \n",
              "10339       Відмінно/Excellent     91   \n",
              "10343       Відмінно/Excellent    100   \n",
              "10382       Відмінно/Excellent    100   \n",
              "10387        Зараховано/Passed    100   \n",
              "10409       Відмінно/Excellent     95   \n",
              "10316        Зараховано/Passed     80   \n",
              "10330               Добре/Good     77   \n",
              "10344        Зараховано/Passed     96   \n",
              "10360        Зараховано/Passed     70   \n",
              "10370       Відмінно/Excellent     98   \n",
              "10396               Добре/Good     77   \n",
              "10403               Добре/Good     82   \n",
              "10404       Відмінно/Excellent     94   \n",
              "10359  Задовільно/Satisfactory     71   \n",
              "10365        Зараховано/Passed     70   \n",
              "10366        Зараховано/Passed     74   \n",
              "10372        Зараховано/Passed     75   \n",
              "10374       Відмінно/Excellent    100   \n",
              "10376               Добре/Good     82   \n",
              "10378  Задовільно/Satisfactory     69   \n",
              "10411        Зараховано/Passed     66   \n",
              "10418  Задовільно/Satisfactory     68   \n",
              "10310               Добре/Good     75   \n",
              "10314               Добре/Good     83   \n",
              "10315               Добре/Good     84   \n",
              "10355        Зараховано/Passed     99   \n",
              "10368        Зараховано/Passed     72   \n",
              "10391        Зараховано/Passed     95   \n",
              "10399       Відмінно/Excellent    100   \n",
              "10311               Добре/Good     82   \n",
              "10312       Відмінно/Excellent    100   \n",
              "10318        Зараховано/Passed     77   \n",
              "10336       Відмінно/Excellent    100   \n",
              "10348        Зараховано/Passed     95   \n",
              "10361               Добре/Good     82   \n",
              "10388        Зараховано/Passed     77   \n",
              "10392        Зараховано/Passed     73   \n",
              "10420               Добре/Good     79   \n",
              "10313               Добре/Good     84   \n",
              "10329               Добре/Good     79   \n",
              "10334               Добре/Good     75   \n",
              "10352        Зараховано/Passed     60   \n",
              "10369       Відмінно/Excellent     90   \n",
              "10390        Зараховано/Passed     81   \n",
              "10402               Добре/Good     85   \n",
              "10322        Зараховано/Passed     75   \n",
              "10333               Добре/Good     75   \n",
              "10342       Відмінно/Excellent     94   \n",
              "10364               Добре/Good     83   \n",
              "10384       Відмінно/Excellent     90   \n",
              "10389        Зараховано/Passed     69   \n",
              "10394        Зараховано/Passed     63   \n",
              "\n",
              "                                             subject_eng credits_hours  \n",
              "10325                     History and culture of Ukraine     6.0 (180)  \n",
              "10381               Fundamentals of software engineering     5.0 (150)  \n",
              "10405     Ukrainian language (by professional direction)      3.0 (90)  \n",
              "10415                                         Philosophy      3.0 (90)  \n",
              "10321      Foreign language (English) (additional) (DOP)     5.5 (165)  \n",
              "10323                        Information technology (IT)     8.0 (240)  \n",
              "10331                              Computer architecture     4.0 (120)  \n",
              "10339                                 Higher mathematics     8.0 (240)  \n",
              "10343       Discrete structures and discrete mathematics     7.0 (210)  \n",
              "10382                        Fundamentals of programming     8.0 (240)  \n",
              "10387                               Internet programming     4.0 (120)  \n",
              "10409                        Physics (selected sections)     5.0 (150)  \n",
              "10316                                    Web programming      3.0 (90)  \n",
              "10330                     Algorithms and data structures     4.0 (120)  \n",
              "10344               Discipline of the student's choice 1      3.0 (90)  \n",
              "10360             Computer graphics and image processing      3.0 (90)  \n",
              "10370                               Educational practice      3.0 (90)  \n",
              "10396     Probability theory and mathematical statistics     4.0 (120)  \n",
              "10403                    Technologies of computer design      2.0 (60)  \n",
              "10404                  Computer design technologies (CR)      1.0 (30)  \n",
              "10359          Empirical methods of software engineering     4.0 (120)  \n",
              "10365                          Human-machine interaction     4.0 (120)  \n",
              "10366                        Python programming language     4.0 (120)  \n",
              "10372                        Object-oriented programming     8.0 (240)  \n",
              "10374                  Object-oriented programming (OOP)      1.0 (30)  \n",
              "10376                                  Operating Systems     4.0 (120)  \n",
              "10378                          Organization of databases     4.0 (120)  \n",
              "10411                                 Physical Education       0.0 (0)  \n",
              "10418                                  Numerical Methods     4.0 (120)  \n",
              "10310                                Backend development     5.0 (150)  \n",
              "10314                                    Web development     4.0 (120)  \n",
              "10315                               Web development (КР)      1.0 (30)  \n",
              "10355                             Discipline of choice 1      3.0 (90)  \n",
              "10368                          Ruby programming language     5.0 (150)  \n",
              "10391             Development of adaptive web interfaces     5.0 (150)  \n",
              "10399                             Technological practice      3.0 (90)  \n",
              "10311  Database development and three-threaded applic...     4.0 (120)  \n",
              "10312  Database development and three-link applicatio...      1.0 (30)  \n",
              "10318                         Foreign language (English)    14.0 (420)  \n",
              "10336                                         Internship      3.0 (90)  \n",
              "10348                               Discipline of choice      3.0 (90)  \n",
              "10361                                  Computer networks     5.0 (150)  \n",
              "10388      Professional practice of software engineering     5.0 (150)  \n",
              "10392                Software development for Android OS     5.0 (150)  \n",
              "10420                       Software quality and testing     5.0 (150)  \n",
              "10313                          FullStack web development     4.0 (120)  \n",
              "10329              Administration of computing complexes     4.0 (120)  \n",
              "10334  Life safety (life safety, basics of labor prot...      3.0 (90)  \n",
              "10352                       Discipline of choice (total)      3.0 (90)  \n",
              "10369                     Software modeling and analysis      3.0 (90)  \n",
              "10390   Development of web applications based on Java EE     4.0 (120)  \n",
              "10402             Program and data protection technology      3.0 (90)  \n",
              "10322       Foreign language (by professional direction)     4.0 (120)  \n",
              "10333                   Software architecture and design     4.0 (120)  \n",
              "10342                  Group dynamics and communications     4.0 (120)  \n",
              "10364                                    Software design      3.0 (90)  \n",
              "10384                               Pre-diploma practice      3.0 (90)  \n",
              "10389                             Software reengineering     4.0 (120)  \n",
              "10394                   Development of game applications     5.0 (150)  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-0a861a80-c0ac-4668-a6e0-708d5a9640b0\" class=\"colab-df-container\">\n",
              "    <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>code</th>\n",
              "      <th>subject</th>\n",
              "      <th>student_name</th>\n",
              "      <th>semester</th>\n",
              "      <th>credits</th>\n",
              "      <th>hours</th>\n",
              "      <th>type</th>\n",
              "      <th>grade_ects</th>\n",
              "      <th>national_grade</th>\n",
              "      <th>grade</th>\n",
              "      <th>subject_eng</th>\n",
              "      <th>credits_hours</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>10325</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Історія та культура України / History and cult...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>1</td>\n",
              "      <td>6</td>\n",
              "      <td>180</td>\n",
              "      <td>з</td>\n",
              "      <td>A</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>90</td>\n",
              "      <td>History and culture of Ukraine</td>\n",
              "      <td>6.0 (180)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10381</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Основи програмної інженерії / Fundamentals of ...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>150</td>\n",
              "      <td>і</td>\n",
              "      <td>A</td>\n",
              "      <td>Відмінно/Excellent</td>\n",
              "      <td>100</td>\n",
              "      <td>Fundamentals of software engineering</td>\n",
              "      <td>5.0 (150)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10405</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Українська мова (за професійним спрямуванням) ...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>90</td>\n",
              "      <td>і</td>\n",
              "      <td>A</td>\n",
              "      <td>Відмінно/Excellent</td>\n",
              "      <td>90</td>\n",
              "      <td>Ukrainian language (by professional direction)</td>\n",
              "      <td>3.0 (90)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10415</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Філософія / Philosophy</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>90</td>\n",
              "      <td>з</td>\n",
              "      <td>A</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>95</td>\n",
              "      <td>Philosophy</td>\n",
              "      <td>3.0 (90)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10321</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Іноземна мова (англійська) (додатково) (ДОП) /...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>2</td>\n",
              "      <td>5.5</td>\n",
              "      <td>165.0</td>\n",
              "      <td>а</td>\n",
              "      <td>A</td>\n",
              "      <td>Відмінно/Excellent</td>\n",
              "      <td>96</td>\n",
              "      <td>Foreign language (English) (additional) (DOP)</td>\n",
              "      <td>5.5 (165)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10323</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Інформаційні технології (ДОП) / Information te...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>2</td>\n",
              "      <td>8.0</td>\n",
              "      <td>240.0</td>\n",
              "      <td>з</td>\n",
              "      <td>A</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>100</td>\n",
              "      <td>Information technology (IT)</td>\n",
              "      <td>8.0 (240)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10331</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Архітектура комп'ютерів / Computer architecture</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>120</td>\n",
              "      <td>з</td>\n",
              "      <td>A</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>100</td>\n",
              "      <td>Computer architecture</td>\n",
              "      <td>4.0 (120)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10339</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Вища математика / Higher mathematics</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>2</td>\n",
              "      <td>8.0</td>\n",
              "      <td>240.0</td>\n",
              "      <td>і</td>\n",
              "      <td>A</td>\n",
              "      <td>Відмінно/Excellent</td>\n",
              "      <td>91</td>\n",
              "      <td>Higher mathematics</td>\n",
              "      <td>8.0 (240)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10343</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Дискретні структури та дискретна математика / ...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>2</td>\n",
              "      <td>7.0</td>\n",
              "      <td>210.0</td>\n",
              "      <td>і</td>\n",
              "      <td>A</td>\n",
              "      <td>Відмінно/Excellent</td>\n",
              "      <td>100</td>\n",
              "      <td>Discrete structures and discrete mathematics</td>\n",
              "      <td>7.0 (210)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10382</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Основи програмування / Fundamentals of program...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>2</td>\n",
              "      <td>8</td>\n",
              "      <td>240</td>\n",
              "      <td>і</td>\n",
              "      <td>A</td>\n",
              "      <td>Відмінно/Excellent</td>\n",
              "      <td>100</td>\n",
              "      <td>Fundamentals of programming</td>\n",
              "      <td>8.0 (240)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10387</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Програмування в Інтернет / Internet programming</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>120</td>\n",
              "      <td>з</td>\n",
              "      <td>A</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>100</td>\n",
              "      <td>Internet programming</td>\n",
              "      <td>4.0 (120)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10409</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Фізика (вибрані розділи) / Physics (selected s...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>2</td>\n",
              "      <td>5</td>\n",
              "      <td>150</td>\n",
              "      <td>і</td>\n",
              "      <td>A</td>\n",
              "      <td>Відмінно/Excellent</td>\n",
              "      <td>95</td>\n",
              "      <td>Physics (selected sections)</td>\n",
              "      <td>5.0 (150)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10316</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Web-програмування / Web programming</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "      <td>90</td>\n",
              "      <td>з</td>\n",
              "      <td>C</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>80</td>\n",
              "      <td>Web programming</td>\n",
              "      <td>3.0 (90)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10330</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Алгоритми та структури даних / Algorithms and ...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>3</td>\n",
              "      <td>4</td>\n",
              "      <td>120</td>\n",
              "      <td>і</td>\n",
              "      <td>C</td>\n",
              "      <td>Добре/Good</td>\n",
              "      <td>77</td>\n",
              "      <td>Algorithms and data structures</td>\n",
              "      <td>4.0 (120)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10344</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Дисципліна за вибиром студента 1 / Discipline ...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "      <td>90</td>\n",
              "      <td>з</td>\n",
              "      <td>A</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>96</td>\n",
              "      <td>Discipline of the student's choice 1</td>\n",
              "      <td>3.0 (90)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10360</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Комп'ютерна графіка та обробка зображень / Com...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "      <td>90</td>\n",
              "      <td>з</td>\n",
              "      <td>D</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>70</td>\n",
              "      <td>Computer graphics and image processing</td>\n",
              "      <td>3.0 (90)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10370</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Навчальна практика / Educational practice</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "      <td>90</td>\n",
              "      <td>ПР</td>\n",
              "      <td>A</td>\n",
              "      <td>Відмінно/Excellent</td>\n",
              "      <td>98</td>\n",
              "      <td>Educational practice</td>\n",
              "      <td>3.0 (90)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10396</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Теорія ймовірностей та математична статистика ...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>3</td>\n",
              "      <td>4</td>\n",
              "      <td>120</td>\n",
              "      <td>і</td>\n",
              "      <td>C</td>\n",
              "      <td>Добре/Good</td>\n",
              "      <td>77</td>\n",
              "      <td>Probability theory and mathematical statistics</td>\n",
              "      <td>4.0 (120)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10403</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Технології комп'ютерного проєктування / Techno...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>3</td>\n",
              "      <td>2</td>\n",
              "      <td>60</td>\n",
              "      <td>і</td>\n",
              "      <td>B</td>\n",
              "      <td>Добре/Good</td>\n",
              "      <td>82</td>\n",
              "      <td>Technologies of computer design</td>\n",
              "      <td>2.0 (60)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10404</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Технології комп'ютерного проєктування (КР) / C...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>30</td>\n",
              "      <td>КР</td>\n",
              "      <td>A</td>\n",
              "      <td>Відмінно/Excellent</td>\n",
              "      <td>94</td>\n",
              "      <td>Computer design technologies (CR)</td>\n",
              "      <td>1.0 (30)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10359</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Емпіричні методи програмної інженерії / Empiri...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>120</td>\n",
              "      <td>і</td>\n",
              "      <td>D</td>\n",
              "      <td>Задовільно/Satisfactory</td>\n",
              "      <td>71</td>\n",
              "      <td>Empirical methods of software engineering</td>\n",
              "      <td>4.0 (120)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10365</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Людино-машинна взаємодія / Human-machine inter...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>120</td>\n",
              "      <td>з</td>\n",
              "      <td>D</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>70</td>\n",
              "      <td>Human-machine interaction</td>\n",
              "      <td>4.0 (120)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10366</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Мова програмування Python / Python programming...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>120</td>\n",
              "      <td>з</td>\n",
              "      <td>D</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>74</td>\n",
              "      <td>Python programming language</td>\n",
              "      <td>4.0 (120)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10372</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Об'єктно-орієнтоване програмування / Object-or...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>4</td>\n",
              "      <td>8</td>\n",
              "      <td>240</td>\n",
              "      <td>з</td>\n",
              "      <td>C</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>75</td>\n",
              "      <td>Object-oriented programming</td>\n",
              "      <td>8.0 (240)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10374</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Об'єктно-орієнтоване програмування (КР) / Obje...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>4</td>\n",
              "      <td>1</td>\n",
              "      <td>30</td>\n",
              "      <td>КР</td>\n",
              "      <td>A</td>\n",
              "      <td>Відмінно/Excellent</td>\n",
              "      <td>100</td>\n",
              "      <td>Object-oriented programming (OOP)</td>\n",
              "      <td>1.0 (30)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10376</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Операційні системи / Operating Systems</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>120</td>\n",
              "      <td>і</td>\n",
              "      <td>B</td>\n",
              "      <td>Добре/Good</td>\n",
              "      <td>82</td>\n",
              "      <td>Operating Systems</td>\n",
              "      <td>4.0 (120)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10378</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Організація баз даних / Organization of databases</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>120</td>\n",
              "      <td>і</td>\n",
              "      <td>D</td>\n",
              "      <td>Задовільно/Satisfactory</td>\n",
              "      <td>69</td>\n",
              "      <td>Organization of databases</td>\n",
              "      <td>4.0 (120)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10411</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Фізичне виховання / Physical Education</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>4</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>з</td>\n",
              "      <td>D</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>66</td>\n",
              "      <td>Physical Education</td>\n",
              "      <td>0.0 (0)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10418</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Чисельні методи / Numerical Methods</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>120</td>\n",
              "      <td>і</td>\n",
              "      <td>D</td>\n",
              "      <td>Задовільно/Satisfactory</td>\n",
              "      <td>68</td>\n",
              "      <td>Numerical Methods</td>\n",
              "      <td>4.0 (120)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10310</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Backend розробка / Backend development</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "      <td>150</td>\n",
              "      <td>і</td>\n",
              "      <td>C</td>\n",
              "      <td>Добре/Good</td>\n",
              "      <td>75</td>\n",
              "      <td>Backend development</td>\n",
              "      <td>5.0 (150)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10314</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Web development / Web development</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>5</td>\n",
              "      <td>4</td>\n",
              "      <td>120</td>\n",
              "      <td>і</td>\n",
              "      <td>B</td>\n",
              "      <td>Добре/Good</td>\n",
              "      <td>83</td>\n",
              "      <td>Web development</td>\n",
              "      <td>4.0 (120)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10315</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Web development (КР) / Web development (КР)</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>5</td>\n",
              "      <td>1</td>\n",
              "      <td>30</td>\n",
              "      <td>КР</td>\n",
              "      <td>B</td>\n",
              "      <td>Добре/Good</td>\n",
              "      <td>84</td>\n",
              "      <td>Web development (КР)</td>\n",
              "      <td>1.0 (30)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10355</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Дисципліна за вибором 1 / Discipline of choice 1</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>5</td>\n",
              "      <td>3</td>\n",
              "      <td>90</td>\n",
              "      <td>з</td>\n",
              "      <td>A</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>99</td>\n",
              "      <td>Discipline of choice 1</td>\n",
              "      <td>3.0 (90)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10368</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Мова програмування Ruby / Ruby programming lan...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "      <td>150</td>\n",
              "      <td>з</td>\n",
              "      <td>D</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>72</td>\n",
              "      <td>Ruby programming language</td>\n",
              "      <td>5.0 (150)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10391</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Розробка адаптивних web-інтерфейсів / Developm...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "      <td>150</td>\n",
              "      <td>з</td>\n",
              "      <td>A</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>95</td>\n",
              "      <td>Development of adaptive web interfaces</td>\n",
              "      <td>5.0 (150)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10399</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Технологічна практика / Technological practice</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>5</td>\n",
              "      <td>3</td>\n",
              "      <td>90</td>\n",
              "      <td>ПР</td>\n",
              "      <td>A</td>\n",
              "      <td>Відмінно/Excellent</td>\n",
              "      <td>100</td>\n",
              "      <td>Technological practice</td>\n",
              "      <td>3.0 (90)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10311</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Database developement та трьохланкові застосун...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>6</td>\n",
              "      <td>4</td>\n",
              "      <td>120</td>\n",
              "      <td>і</td>\n",
              "      <td>B</td>\n",
              "      <td>Добре/Good</td>\n",
              "      <td>82</td>\n",
              "      <td>Database development and three-threaded applic...</td>\n",
              "      <td>4.0 (120)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10312</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Database developement та трьохланкові застосун...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>6</td>\n",
              "      <td>1</td>\n",
              "      <td>30</td>\n",
              "      <td>КР</td>\n",
              "      <td>A</td>\n",
              "      <td>Відмінно/Excellent</td>\n",
              "      <td>100</td>\n",
              "      <td>Database development and three-link applicatio...</td>\n",
              "      <td>1.0 (30)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10318</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Іноземна мова (англійська) / Foreign language ...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>6</td>\n",
              "      <td>14.0</td>\n",
              "      <td>420.0</td>\n",
              "      <td>з</td>\n",
              "      <td>C</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>77</td>\n",
              "      <td>Foreign language (English)</td>\n",
              "      <td>14.0 (420)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10336</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Виробнича практика / Internship</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>6</td>\n",
              "      <td>3</td>\n",
              "      <td>90</td>\n",
              "      <td>ПР</td>\n",
              "      <td>A</td>\n",
              "      <td>Відмінно/Excellent</td>\n",
              "      <td>100</td>\n",
              "      <td>Internship</td>\n",
              "      <td>3.0 (90)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10348</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Дисципліна за вибором / Discipline of choice</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>6</td>\n",
              "      <td>3</td>\n",
              "      <td>90</td>\n",
              "      <td>з</td>\n",
              "      <td>A</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>95</td>\n",
              "      <td>Discipline of choice</td>\n",
              "      <td>3.0 (90)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10361</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Комп'ютерні мережі / Computer networks</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>6</td>\n",
              "      <td>5</td>\n",
              "      <td>150</td>\n",
              "      <td>і</td>\n",
              "      <td>B</td>\n",
              "      <td>Добре/Good</td>\n",
              "      <td>82</td>\n",
              "      <td>Computer networks</td>\n",
              "      <td>5.0 (150)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10388</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Професійна практика програмної інженерії / Pro...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>6</td>\n",
              "      <td>5</td>\n",
              "      <td>150</td>\n",
              "      <td>з</td>\n",
              "      <td>C</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>77</td>\n",
              "      <td>Professional practice of software engineering</td>\n",
              "      <td>5.0 (150)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10392</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Розробка програмного забезпечення для ОС Andro...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>6</td>\n",
              "      <td>5</td>\n",
              "      <td>150</td>\n",
              "      <td>з</td>\n",
              "      <td>D</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>73</td>\n",
              "      <td>Software development for Android OS</td>\n",
              "      <td>5.0 (150)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10420</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Якість програмного забезпечення та тестування ...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>6</td>\n",
              "      <td>5</td>\n",
              "      <td>150</td>\n",
              "      <td>і</td>\n",
              "      <td>C</td>\n",
              "      <td>Добре/Good</td>\n",
              "      <td>79</td>\n",
              "      <td>Software quality and testing</td>\n",
              "      <td>5.0 (150)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10313</th>\n",
              "      <td>22010917</td>\n",
              "      <td>FullStack web-розробка / FullStack web develop...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>7</td>\n",
              "      <td>4</td>\n",
              "      <td>120</td>\n",
              "      <td>і</td>\n",
              "      <td>B</td>\n",
              "      <td>Добре/Good</td>\n",
              "      <td>84</td>\n",
              "      <td>FullStack web development</td>\n",
              "      <td>4.0 (120)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10329</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Адміністрування обчислювальних комплексів / Ad...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>7</td>\n",
              "      <td>4</td>\n",
              "      <td>120</td>\n",
              "      <td>і</td>\n",
              "      <td>C</td>\n",
              "      <td>Добре/Good</td>\n",
              "      <td>79</td>\n",
              "      <td>Administration of computing complexes</td>\n",
              "      <td>4.0 (120)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10334</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Безпека життєдіяльності (безпека життєдіяльнос...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>7</td>\n",
              "      <td>3</td>\n",
              "      <td>90</td>\n",
              "      <td>диф</td>\n",
              "      <td>C</td>\n",
              "      <td>Добре/Good</td>\n",
              "      <td>75</td>\n",
              "      <td>Life safety (life safety, basics of labor prot...</td>\n",
              "      <td>3.0 (90)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10352</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Дисципліна за вибором (загал) / Discipline of ...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>7</td>\n",
              "      <td>3</td>\n",
              "      <td>90</td>\n",
              "      <td>з</td>\n",
              "      <td>E</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>60</td>\n",
              "      <td>Discipline of choice (total)</td>\n",
              "      <td>3.0 (90)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10369</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Моделювання та аналіз програмного забезпечення...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>7</td>\n",
              "      <td>3</td>\n",
              "      <td>90</td>\n",
              "      <td>і</td>\n",
              "      <td>A</td>\n",
              "      <td>Відмінно/Excellent</td>\n",
              "      <td>90</td>\n",
              "      <td>Software modeling and analysis</td>\n",
              "      <td>3.0 (90)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10390</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Розробка web-застосунків на базі Java EE / Dev...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>7</td>\n",
              "      <td>4</td>\n",
              "      <td>120</td>\n",
              "      <td>з</td>\n",
              "      <td>C</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>81</td>\n",
              "      <td>Development of web applications based on Java EE</td>\n",
              "      <td>4.0 (120)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10402</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Технологія захисту програм та даних / Program ...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>7</td>\n",
              "      <td>3</td>\n",
              "      <td>90</td>\n",
              "      <td>і</td>\n",
              "      <td>B</td>\n",
              "      <td>Добре/Good</td>\n",
              "      <td>85</td>\n",
              "      <td>Program and data protection technology</td>\n",
              "      <td>3.0 (90)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10322</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Іноземна мова (за професійним спрямуванням) / ...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>8</td>\n",
              "      <td>4</td>\n",
              "      <td>120</td>\n",
              "      <td>з</td>\n",
              "      <td>C</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>75</td>\n",
              "      <td>Foreign language (by professional direction)</td>\n",
              "      <td>4.0 (120)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10333</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Архітектура та проєктування програмного забезп...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>8</td>\n",
              "      <td>4</td>\n",
              "      <td>120</td>\n",
              "      <td>і</td>\n",
              "      <td>C</td>\n",
              "      <td>Добре/Good</td>\n",
              "      <td>75</td>\n",
              "      <td>Software architecture and design</td>\n",
              "      <td>4.0 (120)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10342</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Групова динаміка і комунікації / Group dynamic...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>8</td>\n",
              "      <td>4</td>\n",
              "      <td>120</td>\n",
              "      <td>і</td>\n",
              "      <td>A</td>\n",
              "      <td>Відмінно/Excellent</td>\n",
              "      <td>94</td>\n",
              "      <td>Group dynamics and communications</td>\n",
              "      <td>4.0 (120)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10364</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Конструювання програмного забезпечення / Softw...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>8</td>\n",
              "      <td>3</td>\n",
              "      <td>90</td>\n",
              "      <td>і</td>\n",
              "      <td>B</td>\n",
              "      <td>Добре/Good</td>\n",
              "      <td>83</td>\n",
              "      <td>Software design</td>\n",
              "      <td>3.0 (90)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10384</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Переддипломна практика / Pre-diploma practice</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>8</td>\n",
              "      <td>3</td>\n",
              "      <td>90</td>\n",
              "      <td>ПР</td>\n",
              "      <td>A</td>\n",
              "      <td>Відмінно/Excellent</td>\n",
              "      <td>90</td>\n",
              "      <td>Pre-diploma practice</td>\n",
              "      <td>3.0 (90)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10389</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Реінжиніринг програмного забезпечення / Softwa...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>8</td>\n",
              "      <td>4</td>\n",
              "      <td>120</td>\n",
              "      <td>з</td>\n",
              "      <td>D</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>69</td>\n",
              "      <td>Software reengineering</td>\n",
              "      <td>4.0 (120)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10394</th>\n",
              "      <td>22010917</td>\n",
              "      <td>Розробка ігрових застосунків / Development of ...</td>\n",
              "      <td>Олексієнко Володимир</td>\n",
              "      <td>8</td>\n",
              "      <td>5</td>\n",
              "      <td>150</td>\n",
              "      <td>з</td>\n",
              "      <td>E</td>\n",
              "      <td>Зараховано/Passed</td>\n",
              "      <td>63</td>\n",
              "      <td>Development of game applications</td>\n",
              "      <td>5.0 (150)</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-0a861a80-c0ac-4668-a6e0-708d5a9640b0')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-0a861a80-c0ac-4668-a6e0-708d5a9640b0 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-0a861a80-c0ac-4668-a6e0-708d5a9640b0');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-4c9df11b-e6d7-49e7-a8a2-bf98f331367a\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-4c9df11b-e6d7-49e7-a8a2-bf98f331367a')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-4c9df11b-e6d7-49e7-a8a2-bf98f331367a button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "student_data",
              "repr_error": "0"
            }
          },
          "metadata": {},
          "execution_count": 27
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "<h3><b><i>P. S. Перевірка суми кредитів та годин (ДОПи не рахувати в загальну суму!!!)</b></i></h3>"
      ],
      "metadata": {
        "id": "jpEeW691RqSW"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "<b>Кредити:</b>"
      ],
      "metadata": {
        "id": "bf69ykNehM3L"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "student_data = student_data[~student_data['subject'].str.contains(\"ДОП\")]\n",
        "student_data[\"credits\"].sum()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "GBQx60Q0H_Dy",
        "outputId": "955400cc-b215-4c09-ce7a-85b304d49421"
      },
      "execution_count": 28,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "231.0"
            ]
          },
          "metadata": {},
          "execution_count": 28
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "<b>Години:</b>"
      ],
      "metadata": {
        "id": "GW-St3lHhOLU"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "student_data[\"hours\"].sum()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "EWXb3J9OnNKU",
        "outputId": "077cdb1f-9fa3-476e-cbc4-b3ecf7214263"
      },
      "execution_count": 29,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "6930.0"
            ]
          },
          "metadata": {},
          "execution_count": 29
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "<h3><b><font color=\"red\">6. Здобувачі які не набрали необхідну кількість кредитів (поновлені, коледж, перейшли з заочки тощо):</font></b></h3>"
      ],
      "metadata": {
        "id": "EMWptrW5hRUs"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "exceptions = result[~result['subject'].str.contains(\"ДОП\")]\n",
        "exceptions = exceptions.groupby(\"code\").agg({\n",
        "    'student_name': 'first',\n",
        "    'credits': 'sum'\n",
        "}).reset_index()\n",
        "\n",
        "exceptions[~exceptions[\"credits\"].isin({108, 231})]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 582
        },
        "id": "avIqvOyKObuQ",
        "outputId": "a075b9fd-428a-4717-f9c7-2a74c157ecd1"
      },
      "execution_count": 30,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         code        student_name credits\n",
              "0    21610307        Косолап Ілля   121.5\n",
              "1    21610902        Гудзь Дмитро    48.0\n",
              "2    21617108       Мальцев Євген    48.0\n",
              "3    21810209   Дмитрук Владислав    56.5\n",
              "9    21910101     Артим Владислав   121.5\n",
              "10   21910527       Фалько Дмитро   172.5\n",
              "11   21910532    Шкромида Віталій    25.5\n",
              "12   21910804        Біба Євгеній      25\n",
              "15   22010106         Дзина Βлада   226.0\n",
              "133  22017113       Шерстюк Олена   221.5\n",
              "135  22120801   Димитрієв Валерій   173.0\n",
              "136  22120802      Дзундза Дмитро   173.0\n",
              "137  22120803      Хоменко Дмитро   173.0\n",
              "138  22121001    Коваленко Мілана   173.0\n",
              "139  22230101        Бєлік Богдан   121.5\n",
              "140  22230501  Охотський Валентин   117.0\n",
              "141  22230502      Беспалько Ігор   117.0"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-cea8002a-b88a-4199-94df-63ab9099b7ec\" class=\"colab-df-container\">\n",
              "    <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>code</th>\n",
              "      <th>student_name</th>\n",
              "      <th>credits</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>21610307</td>\n",
              "      <td>Косолап Ілля</td>\n",
              "      <td>121.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>21610902</td>\n",
              "      <td>Гудзь Дмитро</td>\n",
              "      <td>48.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>21617108</td>\n",
              "      <td>Мальцев Євген</td>\n",
              "      <td>48.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>21810209</td>\n",
              "      <td>Дмитрук Владислав</td>\n",
              "      <td>56.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>21910101</td>\n",
              "      <td>Артим Владислав</td>\n",
              "      <td>121.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>21910527</td>\n",
              "      <td>Фалько Дмитро</td>\n",
              "      <td>172.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>21910532</td>\n",
              "      <td>Шкромида Віталій</td>\n",
              "      <td>25.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>21910804</td>\n",
              "      <td>Біба Євгеній</td>\n",
              "      <td>25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>22010106</td>\n",
              "      <td>Дзина Βлада</td>\n",
              "      <td>226.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>133</th>\n",
              "      <td>22017113</td>\n",
              "      <td>Шерстюк Олена</td>\n",
              "      <td>221.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>135</th>\n",
              "      <td>22120801</td>\n",
              "      <td>Димитрієв Валерій</td>\n",
              "      <td>173.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>136</th>\n",
              "      <td>22120802</td>\n",
              "      <td>Дзундза Дмитро</td>\n",
              "      <td>173.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>137</th>\n",
              "      <td>22120803</td>\n",
              "      <td>Хоменко Дмитро</td>\n",
              "      <td>173.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>138</th>\n",
              "      <td>22121001</td>\n",
              "      <td>Коваленко Мілана</td>\n",
              "      <td>173.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>139</th>\n",
              "      <td>22230101</td>\n",
              "      <td>Бєлік Богдан</td>\n",
              "      <td>121.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>140</th>\n",
              "      <td>22230501</td>\n",
              "      <td>Охотський Валентин</td>\n",
              "      <td>117.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>141</th>\n",
              "      <td>22230502</td>\n",
              "      <td>Беспалько Ігор</td>\n",
              "      <td>117.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-cea8002a-b88a-4199-94df-63ab9099b7ec')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-cea8002a-b88a-4199-94df-63ab9099b7ec button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-cea8002a-b88a-4199-94df-63ab9099b7ec');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-e880605d-a205-4fc9-80ab-3a219468fcc4\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-e880605d-a205-4fc9-80ab-3a219468fcc4')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-e880605d-a205-4fc9-80ab-3a219468fcc4 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "summary": "{\n  \"name\": \"exceptions[~exceptions[\\\"credits\\\"]\",\n  \"rows\": 17,\n  \"fields\": [\n    {\n      \"column\": \"code\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 212248,\n        \"min\": 21610307,\n        \"max\": 22230502,\n        \"num_unique_values\": 17,\n        \"samples\": [\n          21610307,\n          21610902,\n          21910527\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"student_name\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 17,\n        \"samples\": [\n          \"\\u041a\\u043e\\u0441\\u043e\\u043b\\u0430\\u043f \\u0406\\u043b\\u043b\\u044f\",\n          \"\\u0413\\u0443\\u0434\\u0437\\u044c \\u0414\\u043c\\u0438\\u0442\\u0440\\u043e\",\n          \"\\u0424\\u0430\\u043b\\u044c\\u043a\\u043e \\u0414\\u043c\\u0438\\u0442\\u0440\\u043e\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"credits\",\n      \"properties\": {\n        \"dtype\": \"date\",\n        \"min\": 25,\n        \"max\": 226.0,\n        \"num_unique_values\": 10,\n        \"samples\": [\n          173.0,\n          48.0,\n          25\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 30
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "\n",
        "<h3><b><font color=\"red\">7. Здобувачі які мали борги на момент завантаження та обробки локальної копії рейтингів (УВАЖНО ПЕРЕДИВИТИСЯ ДОДАТКИ):</font></b></h3>"
      ],
      "metadata": {
        "id": "pW1e_7Kd3XXy"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Перелік боргів:"
      ],
      "metadata": {
        "id": "1bn0sCqY9Wum"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "academic_debts = result[result[\"grade\"] < 60].sort_values(by=\"student_name\")\n",
        "academic_debts = academic_debts[[\"student_name\", \"subject\", \"semester\"]]\n",
        "academic_debts.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "KqmW7oxq3mz8",
        "outputId": "d7681ed7-e771-4925-c9f1-d50c0394ed04"
      },
      "execution_count": 31,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       student_name                                            subject  \\\n",
              "7104  Гοлубев Денис  Алгоритми та методи обчислень / Algorithms and...   \n",
              "7153  Гοлубев Денис  Передатестаційна практика / Pre-certification ...   \n",
              "54     Гудзь Дмитро         Дослідження операцій / Operations Research   \n",
              "57     Гудзь Дмитро  Контрольно-вимірювальні прилади та датчики сис...   \n",
              "60     Гудзь Дмитро  Моделі, алгоритмізація і САК / Models, algorit...   \n",
              "\n",
              "      semester  \n",
              "7104         5  \n",
              "7153         8  \n",
              "54          11  \n",
              "57          11  \n",
              "60          12  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-15a6fe9b-9751-4433-994e-b9fe05da4e5b\" class=\"colab-df-container\">\n",
              "    <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>student_name</th>\n",
              "      <th>subject</th>\n",
              "      <th>semester</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>7104</th>\n",
              "      <td>Гοлубев Денис</td>\n",
              "      <td>Алгоритми та методи обчислень / Algorithms and...</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7153</th>\n",
              "      <td>Гοлубев Денис</td>\n",
              "      <td>Передатестаційна практика / Pre-certification ...</td>\n",
              "      <td>8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>54</th>\n",
              "      <td>Гудзь Дмитро</td>\n",
              "      <td>Дослідження операцій / Operations Research</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>57</th>\n",
              "      <td>Гудзь Дмитро</td>\n",
              "      <td>Контрольно-вимірювальні прилади та датчики сис...</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>60</th>\n",
              "      <td>Гудзь Дмитро</td>\n",
              "      <td>Моделі, алгоритмізація і САК / Models, algorit...</td>\n",
              "      <td>12</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-15a6fe9b-9751-4433-994e-b9fe05da4e5b')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-15a6fe9b-9751-4433-994e-b9fe05da4e5b button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-15a6fe9b-9751-4433-994e-b9fe05da4e5b');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-bef389ce-297f-468d-afc4-e7f8cb56fec2\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-bef389ce-297f-468d-afc4-e7f8cb56fec2')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-bef389ce-297f-468d-afc4-e7f8cb56fec2 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "academic_debts",
              "summary": "{\n  \"name\": \"academic_debts\",\n  \"rows\": 73,\n  \"fields\": [\n    {\n      \"column\": \"student_name\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 20,\n        \"samples\": [\n          \"\\u0413\\u03bf\\u043b\\u0443\\u0431\\u0435\\u0432 \\u0414\\u0435\\u043d\\u0438\\u0441\",\n          \"\\u0427\\u0443\\u0431\\u0438\\u043a \\u041e\\u043b\\u0435\\u043a\\u0441\\u0430\\u043d\\u0434\\u0440\",\n          \"\\u0425\\u0430\\u043c\\u043c\\u0443\\u0434 \\u0414\\u0430\\u043d\\u0456\\u0435\\u043b\\u044c\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"subject\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 55,\n        \"samples\": [\n          \"\\u0406\\u043d\\u0442\\u0435\\u043b\\u0435\\u043a\\u0442\\u0443\\u0430\\u043b\\u044c\\u043d\\u0438\\u0439 \\u0430\\u043d\\u0430\\u043b\\u0456\\u0437 \\u0434\\u0430\\u043d\\u0438\\u0445 (\\u041a\\u0420) / Intelligent data analysis (DI)\",\n          \"\\u0414\\u043e\\u0441\\u043b\\u0456\\u0434\\u043d\\u0438\\u0446\\u044c\\u043a\\u0430 \\u043f\\u0440\\u0430\\u043a\\u0442\\u0438\\u043a\\u0430 / Research practice\",\n          \"\\u041a\\u0456\\u0431\\u0435\\u0440\\u0431\\u0435\\u0437\\u043f\\u0435\\u043a\\u0430 / Cyber \\u200b\\u200bsecurity\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"semester\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 3,\n        \"min\": 1,\n        \"max\": 12,\n        \"num_unique_values\": 9,\n        \"samples\": [\n          7,\n          8,\n          1\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 31
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Кількість боргів:"
      ],
      "metadata": {
        "id": "lgxcOGLr9UEp"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "academic_debts.groupby(\"student_name\").agg({\n",
        "    'subject': 'count',\n",
        "}).reset_index()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 677
        },
        "id": "gq3SMGwe8aKu",
        "outputId": "33e55278-ae77-4d13-f821-773c4ff5be18"
      },
      "execution_count": 32,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "            student_name  subject\n",
              "0          Гοлубев Денис        2\n",
              "1           Гудзь Дмитро        6\n",
              "2            Дзина Βлада       10\n",
              "3   Жердецький Владислав        1\n",
              "4        Кляцький Нікіта        6\n",
              "5       Коваленко Мілана        1\n",
              "6        Козій Олександр        7\n",
              "7           Косолап Ілля        2\n",
              "8        Лялюк Βοлοдимир        1\n",
              "9          Мальцев Євген        1\n",
              "10    Негοвοра Βοлοдимир        3\n",
              "11       Нищоцький Артур        2\n",
              "12        Парфьонов Ілля        1\n",
              "13          Сагіян Ηеллі        2\n",
              "14         Фалько Дмитро        2\n",
              "15        Хаммуд Даніель        1\n",
              "16        Чернега Данило        8\n",
              "17       Чубик Олександр        1\n",
              "18        Чупина Валерій        1\n",
              "19         Шерстюк Олена       15"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-8e2c54dd-d5ac-465d-a3bc-6567f09d8b5e\" class=\"colab-df-container\">\n",
              "    <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>student_name</th>\n",
              "      <th>subject</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Гοлубев Денис</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Гудзь Дмитро</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Дзина Βлада</td>\n",
              "      <td>10</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Жердецький Владислав</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Кляцький Нікіта</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Коваленко Мілана</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Козій Олександр</td>\n",
              "      <td>7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Косолап Ілля</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Лялюк Βοлοдимир</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Мальцев Євген</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Негοвοра Βοлοдимир</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Нищоцький Артур</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Парфьонов Ілля</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Сагіян Ηеллі</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Фалько Дмитро</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Хаммуд Даніель</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Чернега Данило</td>\n",
              "      <td>8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Чубик Олександр</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Чупина Валерій</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Шерстюк Олена</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-8e2c54dd-d5ac-465d-a3bc-6567f09d8b5e')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-8e2c54dd-d5ac-465d-a3bc-6567f09d8b5e button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-8e2c54dd-d5ac-465d-a3bc-6567f09d8b5e');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-5e81e292-d21e-4174-9d95-64b53ac29d01\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-5e81e292-d21e-4174-9d95-64b53ac29d01')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-5e81e292-d21e-4174-9d95-64b53ac29d01 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "summary": "{\n  \"name\": \"})\",\n  \"rows\": 20,\n  \"fields\": [\n    {\n      \"column\": \"student_name\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 20,\n        \"samples\": [\n          \"\\u0413\\u03bf\\u043b\\u0443\\u0431\\u0435\\u0432 \\u0414\\u0435\\u043d\\u0438\\u0441\",\n          \"\\u0427\\u0443\\u0431\\u0438\\u043a \\u041e\\u043b\\u0435\\u043a\\u0441\\u0430\\u043d\\u0434\\u0440\",\n          \"\\u0425\\u0430\\u043c\\u043c\\u0443\\u0434 \\u0414\\u0430\\u043d\\u0456\\u0435\\u043b\\u044c\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"subject\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 3,\n        \"min\": 1,\n        \"max\": 15,\n        \"num_unique_values\": 8,\n        \"samples\": [\n          6,\n          3,\n          2\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 32
        }
      ]
    }
  ],
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "display_name": "Python 3",
      "name": "python3"
    },
    "language_info": {
      "codemirror_mode": {
        "name": "ipython",
        "version": 3
      },
      "file_extension": ".py",
      "mimetype": "text/x-python",
      "name": "python",
      "nbconvert_exporter": "python",
      "pygments_lexer": "ipython3",
      "version": "3.12.0"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}