0_EDA_first_look.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "\n",
    "import matplotlib.pyplot as plt\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Import data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "stu_vle = pd.read_csv('data/studentVle.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "stu_as = pd.read_csv('data/studentAssessment.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "vle = pd.read_csv('data/vle.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "ass = pd.read_csv('data/assessments.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "cou = pd.read_csv('data/courses.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "stu_reg = pd.read_csv('data/studentRegistration.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "stu_info = pd.read_csv('data/studentInfo.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Load data - first look"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code_module</th>\n",
       "      <th>code_presentation</th>\n",
       "      <th>module_presentation_length</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2014J</td>\n",
       "      <td>269</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BBB</td>\n",
       "      <td>2013J</td>\n",
       "      <td>268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BBB</td>\n",
       "      <td>2014J</td>\n",
       "      <td>262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BBB</td>\n",
       "      <td>2013B</td>\n",
       "      <td>240</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  code_module code_presentation  module_presentation_length\n",
       "0         AAA             2013J                         268\n",
       "1         AAA             2014J                         269\n",
       "2         BBB             2013J                         268\n",
       "3         BBB             2014J                         262\n",
       "4         BBB             2013B                         240"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cou.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code_module</th>\n",
       "      <th>code_presentation</th>\n",
       "      <th>id_assessment</th>\n",
       "      <th>assessment_type</th>\n",
       "      <th>date</th>\n",
       "      <th>weight</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>1752</td>\n",
       "      <td>TMA</td>\n",
       "      <td>19.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>1753</td>\n",
       "      <td>TMA</td>\n",
       "      <td>54.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>1754</td>\n",
       "      <td>TMA</td>\n",
       "      <td>117.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>1755</td>\n",
       "      <td>TMA</td>\n",
       "      <td>166.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>1756</td>\n",
       "      <td>TMA</td>\n",
       "      <td>215.0</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  code_module code_presentation  id_assessment assessment_type   date  weight\n",
       "0         AAA             2013J           1752             TMA   19.0    10.0\n",
       "1         AAA             2013J           1753             TMA   54.0    20.0\n",
       "2         AAA             2013J           1754             TMA  117.0    20.0\n",
       "3         AAA             2013J           1755             TMA  166.0    20.0\n",
       "4         AAA             2013J           1756             TMA  215.0    30.0"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ass.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "206"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ass['id_assessment'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['TMA', 'Exam', 'CMA'], dtype=object)"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ass['assessment_type'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([ 10. ,  20. ,  30. , 100. ,   1. ,   5. ,  18. ,   0. ,  35. ,\n",
       "         2. ,   7. ,   8. ,   9. ,  22. ,   3. ,   4. ,   6. ,   7.5,\n",
       "        12.5,  15. ,  17.5,  25. ,  16. ,  28. ])"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ass['weight'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "code_module  code_presentation\n",
       "AAA          2013J                 6\n",
       "             2014J                 6\n",
       "BBB          2013B                12\n",
       "             2013J                12\n",
       "             2014B                12\n",
       "             2014J                 6\n",
       "CCC          2014B                10\n",
       "             2014J                10\n",
       "DDD          2013B                14\n",
       "             2013J                 7\n",
       "             2014B                 7\n",
       "             2014J                 7\n",
       "EEE          2013J                 5\n",
       "             2014B                 5\n",
       "             2014J                 5\n",
       "FFF          2013B                13\n",
       "             2013J                13\n",
       "             2014B                13\n",
       "             2014J                13\n",
       "GGG          2013J                10\n",
       "             2014B                10\n",
       "             2014J                10\n",
       "dtype: int64"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ass.groupby(['code_module','code_presentation']).size()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "exams = ass[ass['assessment_type'] == 'Exam']['id_assessment'].tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "taken_exams = stu_as[stu_as.id_assessment.isin(exams)]['id_assessment'].unique().tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code_module</th>\n",
       "      <th>code_presentation</th>\n",
       "      <th>id_assessment</th>\n",
       "      <th>assessment_type</th>\n",
       "      <th>date</th>\n",
       "      <th>weight</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>CCC</td>\n",
       "      <td>2014B</td>\n",
       "      <td>24290</td>\n",
       "      <td>Exam</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>CCC</td>\n",
       "      <td>2014J</td>\n",
       "      <td>24299</td>\n",
       "      <td>Exam</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>DDD</td>\n",
       "      <td>2013B</td>\n",
       "      <td>25340</td>\n",
       "      <td>Exam</td>\n",
       "      <td>240.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>DDD</td>\n",
       "      <td>2013J</td>\n",
       "      <td>25354</td>\n",
       "      <td>Exam</td>\n",
       "      <td>261.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>DDD</td>\n",
       "      <td>2014B</td>\n",
       "      <td>25361</td>\n",
       "      <td>Exam</td>\n",
       "      <td>241.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>DDD</td>\n",
       "      <td>2014J</td>\n",
       "      <td>25368</td>\n",
       "      <td>Exam</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    code_module code_presentation  id_assessment assessment_type   date  \\\n",
       "62          CCC             2014B          24290            Exam    NaN   \n",
       "72          CCC             2014J          24299            Exam    NaN   \n",
       "87          DDD             2013B          25340            Exam  240.0   \n",
       "94          DDD             2013J          25354            Exam  261.0   \n",
       "101         DDD             2014B          25361            Exam  241.0   \n",
       "108         DDD             2014J          25368            Exam    NaN   \n",
       "\n",
       "     weight  \n",
       "62    100.0  \n",
       "72    100.0  \n",
       "87    100.0  \n",
       "94    100.0  \n",
       "101   100.0  \n",
       "108   100.0  "
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ass[ass.id_assessment.isin(taken_exams)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id_site</th>\n",
       "      <th>code_module</th>\n",
       "      <th>code_presentation</th>\n",
       "      <th>activity_type</th>\n",
       "      <th>week_from</th>\n",
       "      <th>week_to</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>546943</td>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>resource</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>546712</td>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>oucontent</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>546998</td>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>resource</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>546888</td>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>url</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>547035</td>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>resource</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id_site code_module code_presentation activity_type  week_from  week_to\n",
       "0   546943         AAA             2013J      resource        NaN      NaN\n",
       "1   546712         AAA             2013J     oucontent        NaN      NaN\n",
       "2   546998         AAA             2013J      resource        NaN      NaN\n",
       "3   546888         AAA             2013J           url        NaN      NaN\n",
       "4   547035         AAA             2013J      resource        NaN      NaN"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vle.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "6364"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vle['id_site'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['resource', 'oucontent', 'url', 'homepage', 'subpage', 'glossary',\n",
       "       'forumng', 'oucollaborate', 'dataplus', 'quiz', 'ouelluminate',\n",
       "       'sharedsubpage', 'questionnaire', 'page', 'externalquiz', 'ouwiki',\n",
       "       'dualpane', 'repeatactivity', 'folder', 'htmlactivity'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vle['activity_type'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "resource          2660\n",
       "subpage           1055\n",
       "oucontent          996\n",
       "url                886\n",
       "forumng            194\n",
       "quiz               127\n",
       "page               102\n",
       "oucollaborate       82\n",
       "questionnaire       61\n",
       "ouwiki              49\n",
       "dataplus            28\n",
       "externalquiz        26\n",
       "homepage            22\n",
       "glossary            21\n",
       "ouelluminate        21\n",
       "dualpane            20\n",
       "repeatactivity       5\n",
       "htmlactivity         4\n",
       "sharedsubpage        3\n",
       "folder               2\n",
       "Name: activity_type, dtype: int64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vle['activity_type'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id_assessment</th>\n",
       "      <th>id_student</th>\n",
       "      <th>date_submitted</th>\n",
       "      <th>is_banked</th>\n",
       "      <th>score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1752</td>\n",
       "      <td>11391</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>78.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1752</td>\n",
       "      <td>28400</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>70.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1752</td>\n",
       "      <td>31604</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>72.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1752</td>\n",
       "      <td>32885</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>69.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1752</td>\n",
       "      <td>38053</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>79.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id_assessment  id_student  date_submitted  is_banked  score\n",
       "0           1752       11391              18          0   78.0\n",
       "1           1752       28400              22          0   70.0\n",
       "2           1752       31604              17          0   72.0\n",
       "3           1752       32885              26          0   69.0\n",
       "4           1752       38053              19          0   79.0"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stu_as.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "23369"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stu_as['id_student'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "173912"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(stu_as.groupby(['id_assessment','id_student']).size())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code_module</th>\n",
       "      <th>code_presentation</th>\n",
       "      <th>id_student</th>\n",
       "      <th>id_site</th>\n",
       "      <th>date</th>\n",
       "      <th>sum_click</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>28400</td>\n",
       "      <td>546652</td>\n",
       "      <td>-10</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>28400</td>\n",
       "      <td>546652</td>\n",
       "      <td>-10</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>28400</td>\n",
       "      <td>546652</td>\n",
       "      <td>-10</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>28400</td>\n",
       "      <td>546614</td>\n",
       "      <td>-10</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>28400</td>\n",
       "      <td>546714</td>\n",
       "      <td>-10</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  code_module code_presentation  id_student  id_site  date  sum_click\n",
       "0         AAA             2013J       28400   546652   -10          4\n",
       "1         AAA             2013J       28400   546652   -10          1\n",
       "2         AAA             2013J       28400   546652   -10          1\n",
       "3         AAA             2013J       28400   546614   -10         11\n",
       "4         AAA             2013J       28400   546714   -10          1"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stu_vle.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "10655280"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(stu_vle)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "26074"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stu_vle['id_student'].nunique()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Checking for nulls"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code_module</th>\n",
       "      <th>code_presentation</th>\n",
       "      <th>id_student</th>\n",
       "      <th>id_site</th>\n",
       "      <th>date</th>\n",
       "      <th>sum_click</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [code_module, code_presentation, id_student, id_site, date, sum_click]\n",
       "Index: []"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stu_vle[stu_vle.isna().any(axis=1)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1960496"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(stu_vle.groupby(['id_student','id_site']).size())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "code_module  code_presentation\n",
       "AAA          2013J                 180982\n",
       "             2014J                 169316\n",
       "BBB          2013B                 403266\n",
       "             2013J                 452638\n",
       "             2014B                 273236\n",
       "             2014J                 438424\n",
       "CCC          2014B                 496181\n",
       "             2014J                 711646\n",
       "DDD          2013B                 536837\n",
       "             2013J                 680806\n",
       "             2014B                 379942\n",
       "             2014J                 568901\n",
       "EEE          2013J                 356262\n",
       "             2014B                 202224\n",
       "             2014J                 402947\n",
       "FFF          2013B                 946765\n",
       "             2013J                1172101\n",
       "             2014B                 685274\n",
       "             2014J                1210359\n",
       "GGG          2013J                 145995\n",
       "             2014B                 123319\n",
       "             2014J                 117859\n",
       "dtype: int64"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stu_vle.groupby(['code_module','code_presentation']).size()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Student "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code_module</th>\n",
       "      <th>code_presentation</th>\n",
       "      <th>id_student</th>\n",
       "      <th>gender</th>\n",
       "      <th>region</th>\n",
       "      <th>highest_education</th>\n",
       "      <th>imd_band</th>\n",
       "      <th>age_band</th>\n",
       "      <th>num_of_prev_attempts</th>\n",
       "      <th>studied_credits</th>\n",
       "      <th>disability</th>\n",
       "      <th>final_result</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>11391</td>\n",
       "      <td>M</td>\n",
       "      <td>East Anglian Region</td>\n",
       "      <td>HE Qualification</td>\n",
       "      <td>90-100%</td>\n",
       "      <td>55&lt;=</td>\n",
       "      <td>0</td>\n",
       "      <td>240</td>\n",
       "      <td>N</td>\n",
       "      <td>Pass</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>28400</td>\n",
       "      <td>F</td>\n",
       "      <td>Scotland</td>\n",
       "      <td>HE Qualification</td>\n",
       "      <td>20-30%</td>\n",
       "      <td>35-55</td>\n",
       "      <td>0</td>\n",
       "      <td>60</td>\n",
       "      <td>N</td>\n",
       "      <td>Pass</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>30268</td>\n",
       "      <td>F</td>\n",
       "      <td>North Western Region</td>\n",
       "      <td>A Level or Equivalent</td>\n",
       "      <td>30-40%</td>\n",
       "      <td>35-55</td>\n",
       "      <td>0</td>\n",
       "      <td>60</td>\n",
       "      <td>Y</td>\n",
       "      <td>Withdrawn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>31604</td>\n",
       "      <td>F</td>\n",
       "      <td>South East Region</td>\n",
       "      <td>A Level or Equivalent</td>\n",
       "      <td>50-60%</td>\n",
       "      <td>35-55</td>\n",
       "      <td>0</td>\n",
       "      <td>60</td>\n",
       "      <td>N</td>\n",
       "      <td>Pass</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>32885</td>\n",
       "      <td>F</td>\n",
       "      <td>West Midlands Region</td>\n",
       "      <td>Lower Than A Level</td>\n",
       "      <td>50-60%</td>\n",
       "      <td>0-35</td>\n",
       "      <td>0</td>\n",
       "      <td>60</td>\n",
       "      <td>N</td>\n",
       "      <td>Pass</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  code_module code_presentation  id_student gender                region  \\\n",
       "0         AAA             2013J       11391      M   East Anglian Region   \n",
       "1         AAA             2013J       28400      F              Scotland   \n",
       "2         AAA             2013J       30268      F  North Western Region   \n",
       "3         AAA             2013J       31604      F     South East Region   \n",
       "4         AAA             2013J       32885      F  West Midlands Region   \n",
       "\n",
       "       highest_education imd_band age_band  num_of_prev_attempts  \\\n",
       "0       HE Qualification  90-100%     55<=                     0   \n",
       "1       HE Qualification   20-30%    35-55                     0   \n",
       "2  A Level or Equivalent   30-40%    35-55                     0   \n",
       "3  A Level or Equivalent   50-60%    35-55                     0   \n",
       "4     Lower Than A Level   50-60%     0-35                     0   \n",
       "\n",
       "   studied_credits disability final_result  \n",
       "0              240          N         Pass  \n",
       "1               60          N         Pass  \n",
       "2               60          Y    Withdrawn  \n",
       "3               60          N         Pass  \n",
       "4               60          N         Pass  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stu_info.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Here we see that **53% of students did not succeed. (failed or withdrew)**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Pass           12361\n",
       "Withdrawn      10156\n",
       "Fail            7052\n",
       "Distinction     3024\n",
       "Name: final_result, dtype: int64"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stu_info['final_result'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.527966127696131"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(10156+7052) / (12361+10156+7052+3024)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# EDA"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Total number of clicks per course"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "course_clicks = stu_vle.groupby(['code_module', 'code_presentation'])['sum_click'].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "code_module  code_presentation\n",
       "AAA          2013J                 648494\n",
       "             2014J                 598158\n",
       "BBB          2013B                1347911\n",
       "             2013J                1378656\n",
       "             2014B                 833865\n",
       "             2014J                1673744\n",
       "CCC          2014B                1889177\n",
       "             2014J                2792972\n",
       "DDD          2013B                1387467\n",
       "             2013J                1757214\n",
       "             2014B                 947657\n",
       "             2014J                1437751\n",
       "EEE          2013J                1535953\n",
       "             2014B                 832038\n",
       "             2014J                1616236\n",
       "FFF          2013B                4220055\n",
       "             2013J                5116439\n",
       "             2014B                2975619\n",
       "             2014J                5281809\n",
       "GGG          2013J                 509091\n",
       "             2014B                 425165\n",
       "             2014J                 399628\n",
       "Name: sum_click, dtype: int64"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "course_clicks"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x12600cfd0>"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZAAAAFDCAYAAAAUFVhNAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjAsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+17YcXAAAgAElEQVR4nO3de9xcVX3v8c+XcJU7EpASNChRC1pQYsSj9RT0cLUFUSrWSlDOKy1FxWO9ILZSqla0HvWglZYqDXgpImpBLmIaxDtCuCcgJAWECEokiChVufzOH2s9sJnMde2Z2c+T+b5fr3k9e9bea//W7JlnfrPX2hdFBGZmZoPaoOkGmJnZzOQEYmZmRZxAzMysiBOImZkVcQIxM7MiTiBmZlZkw6YbMC7bb799zJ07t+lmmJnNKFddddXPI2J2u3kTk0Dmzp3LsmXLmm6GmdmMIunHnea5C8vMzIo4gZiZWREnEDMzK+IEYmZmRZxAzMysiBOImZkVcQIxM7MiTiBmZlZkYk4kNDMbtrknXNhx3u2nHDLGljTDeyBmZlbECcTMzIo4gZiZWREnEDMzK+IEYmZmRZxAzMysiA/jNbMZrduhtDAZh9M2pa89EEm3S7pB0rWSluWy7SQtkbQy/902l0vSqZJWSbpe0vMr61mYl18paWGlfO+8/lW5rkpjmJnZeAzShbVvROwVEfPz8xOApRExD1ianwMcBMzLj0XAaZCSAXAS8EJgAXDSVELIyyyq1DuwJIaZmY1PnTGQQ4Ez8/SZwGGV8rMiuRzYRtJOwAHAkohYGxH3AUuAA/O8rSLiBxERwFkt6xokhpmZjUm/CSSAb0i6StKiXLZjRNwNkP/ukMt3Bu6s1F2dy7qVr25TXhLjCSQtkrRM0rI1a9b0+VLNzKwf/Q6ivzgi7pK0A7BE0o+6LKs2ZVFQ3k1fdSLidOB0gPnz5/dap5mZDaCvPZCIuCv/vQf4KmkM42dT3Ub57z158dXALpXqc4C7epTPaVNOQQwzMxuTnglE0uaStpyaBvYHlgPnA1NHUi0EzsvT5wNH5SOl9gHuz91PlwD7S9o2D57vD1yS5z0gaZ989NVRLesaJIaZmY1JP11YOwJfzUfWbgh8ISK+LulK4BxJxwB3AEfk5S8CDgZWAQ8CbwCIiLWS3gdcmZf7+4hYm6ePBRYDmwEX5wfAKYPEMDOz8emZQCLiVmDPNuX3Ai9rUx7AcR3WdQZwRpvyZcBzhhHDzMzGw5cyMTOzIk4gZmZWxAnEzMyKOIGYmVkRJxAzMyviBGJmZkWcQMzMrIgTiJmZFXECMTOzIk4gZmZWxAnEzMyKOIGYmVkRJxAzMyviBGJmZkWcQMzMrIgTiJmZFXECMTOzIk4gZmZWxAnEzMyKOIGYmVkRJxAzMyviBGJmZkWcQMzMrIgTiJmZFXECMTOzIhs23QAzs7knXNh1/u2nHDKmltggvAdiZmZFnEDMzKyIE4iZmRVxAjEzsyJ9JxBJsyRdI+mC/HxXST+UtFLSFyVtnMs3yc9X5flzK+t4dy6/WdIBlfIDc9kqSSdUygeOYWZm4zHIHsjxwE2V5x8CPhYR84D7gGNy+THAfRGxG/CxvBySdgeOBPYADgQ+lZPSLOCfgIOA3YHX5mUHjmFmZuPTVwKRNAc4BPh0fi5gP+DcvMiZwGF5+tD8nDz/ZXn5Q4GzI+K3EXEbsApYkB+rIuLWiPgdcDZwaGEMMzMbk373QD4OvBN4ND9/MvCLiHg4P18N7JyndwbuBMjz78/LP1beUqdTeUkMMzMbk54JRNIrgHsi4qpqcZtFo8e8YZX3iv8YSYskLZO0bM2aNW2qmJlZqX72QF4M/Imk20ndS/uR9ki2kTR1Jvsc4K48vRrYBSDP3xpYWy1vqdOp/OcFMZ4gIk6PiPkRMX/27Nl9vFQzM+tXzwQSEe+OiDkRMZc0CH5pRLwO+Cbw6rzYQuC8PH1+fk6ef2lERC4/Mh9BtSswD7gCuBKYl4+42jjHOD/XGTSGmZmNSZ1rYb0LOFvS+4FrgM/k8s8An5W0irRXcCRARKyQdA5wI/AwcFxEPAIg6U3AJcAs4IyIWFESw8zMxmegBBIRlwGX5elbSUdQtS7zG+CIDvU/AHygTflFwEVtygeOYWZm4+Ez0c3MrIgTiJmZFXECMTOzIk4gZmZWxAnEzMyKOIGYmVkRJxAzMyviBGJmZkWcQMzMrIgTiJmZFXECMTOzIk4gZmZWxAnEzMyKOIGYmVkRJxAzMyviBGJmZkWcQMzMrIgTiJmZFXECMTOzIk4gZmZWxAnEzMyKOIGYmVkRJxAzMyviBGJmZkWcQMzMrIgTiJmZFXECMTOzIk4gZmZWxAnEzMyKOIGYmVmRnglE0qaSrpB0naQVkk7O5btK+qGklZK+KGnjXL5Jfr4qz59bWde7c/nNkg6olB+Yy1ZJOqFSPnAMMzMbj372QH4L7BcRewJ7AQdK2gf4EPCxiJgH3Acck5c/BrgvInYDPpaXQ9LuwJHAHsCBwKckzZI0C/gn4CBgd+C1eVkGjWFmZuPTM4FE8qv8dKP8CGA/4NxcfiZwWJ4+ND8nz3+ZJOXysyPitxFxG7AKWJAfqyLi1oj4HXA2cGiuM2gMMzMbk77GQPKewrXAPcAS4L+AX0TEw3mR1cDOeXpn4E6APP9+4MnV8pY6ncqfXBDDzMzGpK8EEhGPRMRewBzSHsPvt1ss/223JxBDLO8W4wkkLZK0TNKyNWvWtKliZmalNhxk4Yj4haTLgH2AbSRtmPcA5gB35cVWA7sAqyVtCGwNrK2UT6nWaVf+84IYre09HTgdYP78+eskGDOzuSdc2HHe7accMsaWzDz9HIU1W9I2eXoz4OXATcA3gVfnxRYC5+Xp8/Nz8vxLIyJy+ZH5CKpdgXnAFcCVwLx8xNXGpIH283OdQWOYmdmY9LMHshNwZj5aagPgnIi4QNKNwNmS3g9cA3wmL/8Z4LOSVpH2Co4EiIgVks4BbgQeBo6LiEcAJL0JuASYBZwRESvyut41SAwzMxufngkkIq4Hntem/FbSeEhr+W+AIzqs6wPAB9qUXwRcNIwYZmY2Hj4T3czMijiBmJlZEScQMzMrMtBhvGbj1u0QS/BhlmZN8h6ImZkVcQIxM7MiTiBmZlbECcTMzIo4gZiZWREnEDMzK+IEYmZmRZxAzMysiBOImZkVcQIxM7MiTiBmZlbECcTMzIo4gZiZWREnEDMzK+IEYmZmRZxAzMysiBOImZkVcQIxM7MiTiBmZlbECcTMzIo4gZiZWREnEDMzK+IEYmZmRZxAzMysiBOImZkVcQIxM7MiPROIpF0kfVPSTZJWSDo+l28naYmklfnvtrlckk6VtErS9ZKeX1nXwrz8SkkLK+V7S7oh1zlVkkpjmJnZePSzB/Iw8NcR8fvAPsBxknYHTgCWRsQ8YGl+DnAQMC8/FgGnQUoGwEnAC4EFwElTCSEvs6hS78BcPlAMMzMbn54JJCLujoir8/QDwE3AzsChwJl5sTOBw/L0ocBZkVwObCNpJ+AAYElErI2I+4AlwIF53lYR8YOICOCslnUNEsPMzMZkoDEQSXOB5wE/BHaMiLshJRlgh7zYzsCdlWqrc1m38tVtyimIYWZmY9J3ApG0BfBl4K0R8ctui7Ypi4Lyrs3pp46kRZKWSVq2Zs2aHqs0M7NB9JVAJG1ESh6fj4iv5OKfTXUb5b/35PLVwC6V6nOAu3qUz2lTXhLjCSLi9IiYHxHzZ8+e3c9LNTOzPvVzFJaAzwA3RcRHK7POB6aOpFoInFcpPyofKbUPcH/ufroE2F/StnnwfH/gkjzvAUn75FhHtaxrkBhmZjYmG/axzIuB1wM3SLo2l50InAKcI+kY4A7giDzvIuBgYBXwIPAGgIhYK+l9wJV5ub+PiLV5+lhgMbAZcHF+MGgMMzMbn54JJCK+S/sxB4CXtVk+gOM6rOsM4Iw25cuA57Qpv3fQGDb9zD3hwq7zbz/lkDG1xMyGyWeim5lZEScQMzMr4gRiZmZFnEDMzKyIE4iZmRXp5zBes4nU7egxHzlm5j0QMzMr5ARiZmZF3IVlffHJgGbWynsgZmZWxHsgZjYU3kudPN4DMTOzIk4gZmZWxF1YZusRdyPZOHkPxMzMijiBmJlZEScQMzMr4jEQs2nG4xg2U3gPxMzMingPZIbxFWIH4+1lNjreAzEzsyLeAxkz92+b2frCeyBmZlbECcTMzIo4gZiZWREnEDMzK+IEYmZmRZxAzMysiBOImZkVcQIxM7MiPROIpDMk3SNpeaVsO0lLJK3Mf7fN5ZJ0qqRVkq6X9PxKnYV5+ZWSFlbK95Z0Q65zqiSVxjAzs/HpZw9kMXBgS9kJwNKImAcszc8BDgLm5cci4DRIyQA4CXghsAA4aSoh5GUWVeodWBLDzMzGq2cCiYhvA2tbig8FzszTZwKHVcrPiuRyYBtJOwEHAEsiYm1E3AcsAQ7M87aKiB9ERABntaxrkBhmZjZGpWMgO0bE3QD57w65fGfgzspyq3NZt/LVbcpLYpiZ2RgNexBdbcqioLwkxroLSoskLZO0bM2aNT1Wa2ZmgyhNID+b6jbKf+/J5auBXSrLzQHu6lE+p015SYx1RMTpETE/IubPnj17oBdoZmbdlV7O/XxgIXBK/ntepfxNks4mDZjfHxF3S7oE+IfKwPn+wLsjYq2kByTtA/wQOAr4REmMwtdhNhK+bL9Ngp4JRNK/A38EbC9pNeloqlOAcyQdA9wBHJEXvwg4GFgFPAi8ASAnivcBV+bl/j4ipgbmjyUd6bUZcHF+MGgMMzMbr54JJCJe22HWy9osG8BxHdZzBnBGm/JlwHPalN87aAwzMxsfn4luZmZFnEDMzKyI74k+QboN7HpQ18CfERuM90DMzKyIE4iZmRVxAjEzsyJOIGZmVsQJxMzMijiBmJlZkYk9jNeHK5qZ1eM9EDMzKzKxeyB1+EqrZmbeAzEzs0JOIGZmVsQJxMzMingMxMysAevDWKr3QMzMrIgTiJmZFXEXlpnZDDNdur+cQMzMJsgwk4+7sMzMrIgTiJmZFXECMTOzIk4gZmZWxAnEzMyKOIGYmVkRJxAzMyviBGJmZkWcQMzMrIgTiJmZFXECMTOzIjM2gUg6UNLNklZJOqHp9piZTZoZmUAkzQL+CTgI2B14raTdm22VmdlkmZEJBFgArIqIWyPid8DZwKENt8nMbKLM1ASyM3Bn5fnqXGZmZmOiiGi6DQOTdARwQET87/z89cCCiHhzy3KLgEX56bOAm7usdnvg54VNmol1m4w9E+s2GduveWbUbTL2KOs+LSJmt50TETPuAbwIuKTy/N3Au2uuc9kk1Z2p7fb28muernVnarvr1J2pXVhXAvMk7SppY+BI4PyG22RmNlFm5C1tI+JhSW8CLgFmAWdExIqGm2VmNlFmZAIBiIiLgIuGuMrTJ6xuk7FnYt0mY/s1z4y6TcZupO6MHEQ3M7PmzdQxEDMza5gTiJmZFZmxYyB1SHoR8OfAHwI7Af8NLAcuBD4XEfePom6d+k3Fnal1K+uYn+v/XqX+f0bE2vWxbmUdmwO/iYhH+q0zrPoldZvcXjP1fS6tP4zP12PrmrQxEEkXA3cB5wHLgHuATYFnAvsCfwx8NCLWOSy4Tt069ZuKO1Pr5vpHA28BbgOuaqn/YtI/zd9GxB3rSd0NSIezvw54AfBbYBNgDelgk9MjYmW7bVW3fs26dV5zcd0mYzfV7rpx26pz0sxMfADbly5Tp26d+k3Fnal187zjgM26zN8LeNl6VPdbwN8CfwBsUCnfDngV8GXgz7usu7h+zbqNbK+Z+j7XqV83brvHxO2BTDeStgfujTG/EZMWd30naaOIeKh0mTr168a2mWviEoikB4BOL/q3wH8B74mIpX3WVS7rWjfX3wc4BVgLvA/4LOk6NBsAR0XE14fd5jpxu8Tu6zU3FTfX3xR4DXAf8DXgnaR+3/8C3hcRHa/9I+nUTvMqsT8fEQ9Mo7jbdasbEb/uMr9dW55EulXCjyNiTY9li2M3tb2ajN1Uu+vGbbvOSUsg3eT7jDyHtBGfM+y6kpYBJwJbk07eOSgiLpf0bODfI+J5o2jzKOL2E7upuHmZc4CHgM2BbUn9u18DXgLsFRGv6LL+hV3CbwjsATw3Iv7XNIp7Gym5qkNdgBMi4vMdYv8JcCop2f8N6X47PwPmAu+KiDO7tLs4dlPbq8nYTbW7bty2BunvWl8epF/AG+TpjYHnA9tV5v/FAOv6q5bnHesC11amb2qZd82o2lwnbp3X3FTcPG95/rsh8NOWedcN4TN00TjiAjv0E7eP9cwGbuwy/zrSYOoLgF8BT5+KD9xQc1t1jN3U+zSd36txtrtumyfuMF5JhwH/Ajwq6S9Jv5B/DTxT0rER8bWI+JcOdd/WWgS8O+9SEhEf7VQ3e7Qy/d8t8zruCtZpc524OXad19xUXIDf5eUelnRXy7yuh5dKegrw3tzG9wJvBg4HfgQcHxF3R8TBI4jbrivoCknPI/UWrO0Sd6rdRMRPJc0mdWv8KCJujIg1kt7VJfyjEXFLXs9tEXFrXtc9kh7u1u4ObfmHiDgxr6Nb7Kbep7qxi9+rptpd9/PVzsQlEOAkYE9gM9KvrhdExM2SnkY6WuRrXeqeTDoscQWP767PArbsM/aekn6Z626Wp8nPNx1Rm+vEhXqvuam4AHNyn68q01Oxe918bDHpXJPNgW8CnwdeQbrr5T/T/e6XdeL+HPhxS9nOwNWkL5und6oo6S+AE9KkPgQcTdp2H5T04Yj4TER0+5xsIGlb0p7uo3l6art3PeG4Td+6gNdL2gIgIt7SJXZT71Pd2MXvVYPtrtPmtiZuDETSNZH73iUtj0ofuqSrI+L5Xeo+FfgoabDp5Ih4UNKtETHwhh9Xm4cQu6nXXCtuj/5eonuffnV73xERT63MuzYi9hpR3LcDLwfeERE35LLbImLXbuvMy90AvJD0I+PHwG55T2Rb4Jvd2pzr307aY2w3jhHdtruk1cBlwDcq9T8CvD1X7vaaG3mfhhC7znvVSLvrtLlbsIl6ANfw+FjCgkr5LHLfYh/rOBT4HvBq4NYB43cdyxhVm9us868GXL74NU+HuAPGvK4y/f6WedcXrG+HAZadA3yJlDy37Pc1A1e3a//U52fE22tL4OPAF4Cdc9nI36thv09jfK8aa3dpmzs9JrELaxHpi/s3EXFFpXwX0iGnPUXEeZKWkLpZVvcbuJ+xjFG0uZ/xhF7rKHnNTcXNsXv2M3epfp6kLSLiVxHxN5V17gbc0iNuz37mbvUjYjVwhKQ/BpYAT+q2fMWjevxci0Mq7dmUwmveVccxerT5AeCtkvYGPifpwn5jNvU+5eWaeq8aa3eNNrdvS85KNgaSrgEOosNYRkTMH1HcB1h3POGtpF+NRMTJ61PcHPvrPN7P/GekfuZ/J+3RvDwievUzl8Z9lHX7meeQkl/EAF1/kjYDnhERy/tY9qnAXRHxcEv5zsDvR8R/9qjfdhwDOIvU8Lf02WYBfwW8KCL+vI/lG3mfcuxG3qu6htXuobS5zu7L+vYALh5lXSpdCbR0PVHpghhB3KcC5wIfAp6Uy2p3MfSK3VTcNtv6jpZ519aI/YYe898OfJ10PP1U2W1DeM1d4w5h/auBzwFHAQvzY83U9AjjNvI+Tdf3qql2l7Z54vZAJHUacBZwQUTsNIq6uf41wN4R8aikBZG7o5ROjLsuOp8UVytuZT2Hks5a/Rjw4ejjl8owYjcRV9J1EbFnnn5/PLGr4PqI+INebeiw3icMenZYZg7ptd5JOoLuun5ec924XereEBHP7bHMlqSrBexAGmT9yTAOlugVu8n3KS833d6rRtpd2uZJHAO5knTxt3ZHm2wzwrpQPpZRNy5QPJ5QO3ZDceuMY1zfaRawY6/AUdjPXCeupMO71H1Kr9hRbxyjTuzG3ido7L1qpN3DiLtOxQncA1kOvDLaXF5a0p0Rscso6tbRVNwmYzf8mn8GHEC61tATZgHfj4jfG2Bdg4xjFMeV9BBp/KDdP/SrI6Lf82dKxjGGFnsQw3yf8vrG9V410u5hxwUmbwyEdDjoszrMO2xUdftoV8d+/abijjJ2U3Fz/V7jGJ8BXtJh3hemY1zS/R2e02HenXW2Vx+vaySxm3qfxvBeNdLuUcSduD2QJg1rLMNx66nTRz1d40r6Q9KVc9vdwGh+RCyrse5e4xgjid3U+9R07DrG3e5JHANB0gHAYaTT+IN857vocnnxYdSlRr9+U3Frxm4qbu3+3tyNs6Al9hXR4xdXU3Ej4jtd5vX8Aq8zjlEndlPbaxrEbqTddeK2Xd+k7YFI+jjpqqNn8fiA7hzS4YsrI+L4UdTN9Yv69ZuKWzd2U3Fz/Tp91PsDnwJWAj+pxN6NdCb9N6Zh3A2BY4BXku51/VjCBT4TvW/4VDyOUSd2U9urydhNtbtu3Lbq9LfNxAdwS4dykb6YRlI3L1fUr99U3CFsr0bi5uXq9FHfBMxtU74rLZeln0Zx/x04DdgnfynMydOnAV/sY3sVj2PUid3U9mr4vWqk3XXjtl1nSaWZ/ACup3I9qUr5Anrc96BO3abaPFNjN/yaVwIbtinfGFg1HeMCN3eZ1zYZtyzzh8BTO8ybP8rYM+19GsJ7NeM+X50ekzgGcjRwWj5xaqprZBfgl3neqOoCxf36TcWtHbupuDl2aX/vGcCVks4mnag1FftI0q+/6Rj3PklHkC6J82huxwbAEazb1bGOqDeGUit2U+9Tg7GbanftuOu0o/d2Wj8pXcRtZ1KXyOqI+Omo6w6hX7+RuKWxm4qb69XtZ94d+JNqbOD8iLhxmsadS7pkzH48/qW9Del+EydExG096tcZxyiO3dT2mgaxG2l3nbhtjXI3bzo/gI3alG0/yrrU79dvJG5p7Kbi5mWG3t/bZ3sbidsS68n9fpYrdWqNoZTGbnJ7TYf3aqa3u+gyzzOZpH2VboBzl6Rv5F9PU3r94iium/1G0oI25S8AfjPd4g4hdlNxIR2i3u6yKT8BNuoReytJH5T0WUmvbZn3qWkad6r+MyLi3oj4eaW8n+tJPT8ijo2IyyNidX5cHhHHAs8bYezGtldTsZtq9xDitm3IpPkwcEBErJD0amCJpNdHxOW0P19hWHWhvF+/qbh1YzcVF+r19/4bqXvgy8Abc/w/i4jfkn6VT7u4kv6UdJn8eyRtBBwdEVfm2YtJNy7rpngco2bspt6nJmM31e66cdfV9O5YA7t/rXdr2wO4mdT32/WS6nXqttR7CrA3MB94yijbXCfusGI3GHd30n3CPwF8Mk/v3ke9a1uev4d0V8Qn9xO7ibjAtcBOeXoB6YZMh+fnPe9ICMwFvki6hPst+XFPLtt1xLEbeZ+afK+aaPcw4q6zzpJKM/kBLGv9EiP1914LPDCqui11BurXbyrusGI3FbfGZ+Qm8i2EK2ULSTfG+vF0jEvLoc3ATqRzO94y6JcDg49jDC32THifhvBezbjPV8d1jnIjT8cH6abye7Yp3xp4z6jq5uX2JXXlrCH148+tzOv4j9ZU3CFsr0bi5uW2Aj4IfBZ4bcu8T/Wo+2HS3fBayw+k98mTTcX9PumKrNWyLYGlwG97ba9K25/RpvwPRhW7qe3V8HvVSLvrxm27zpJKfpQ9SNeG2iNPv5rUH7lPft5zV99xB4r9ZdI9Vg4Dzs/PN8nzRvmruKm4ewK7tSnfCHhdH/X/lHTY7rWkX6QvqMzrleyLYze1vZqOvb60u/GNMUkPhjSW4bh9xR56f+90jjuMdlNjHGMmbq+Z/F5Nl3ZP4lFYTXpI0lMinwwX6QijlwEXAM9w3KHaRNIGkY8oiogP5MOCvw1ssR7GrWtWRNwNEBFXSNoXuEDp1qkxwrhNbq+Z+l5Nm3ZP3HkgDTuBlsstR7o15f+k+y1tHXdwXyOdGV2NfSbw18Dv1sO4dT0g6bGknpPJHwGHkvYcR6XJ7TVT36tp0+6JvZRJK0n/ANwPfDoi7h1X3Tqaittk7IZf83zg7oj4Sc+FZ1hcSXsCv46IVS3lGwF/GhGfH1XsYWvqfaobeyZ+vrwH8rgrgIeBj425bh1NxW0ydpOv+c2kbp0vzpS4ks6UdJqk53RbLiKua00eufyh0uTRb+wRaOp9qht75n2+vAfyOEkviMfPoB1bXZtZJG0ZEQ/MhLiSXgA8lXRp/HeNpmXTL3aO38j7VDf2jPp8TXoCUbo65ZHAa4H7I2L+OOoO2MZNgdeQLinxNeCdpPs3/Bfwvqhce2h9iS3pw8CtEfHPLeX/h3SC4Ui/kJSuTnsQ8OxcdBPw9Yh4eKbFlbThqNvdRGxJb4qIT+bpPSJixSjiDDu2pFnAZhHxq/x8H9I9OSAd8TaS5DGKuBOZQCQ9jfSl/1pSd8jTSDfNuX2Udbuss2u/vqRzgIeAzYFtgeWkL/OXAHtFxCtGEXdUsfuMeyPpDnmPtpRvAFwfEUXdIv3090r6PdKlyO8GriFde+t5pEuy7BsRd023uJK+GxEvydOfjYjXV+ZdHRG9roVVbBSx+9xej617mK9x1LElfQS4JyI+nJ/fRvq/2pR0GG7Rj6Ne7R5J3FEdHzxdH6SzZlcAfwvMy2W3jbpuj/UeRjqC4qwO85fnvxsCP22Zd92o4o4qdp9xV5TM6yP2maQv546XKCddAPCtbcrfApw5HeNSOVeDlnMBqHEeR273aXS43e2oYve5va6uG6eJ2HndG7bWJ/1g+O6o2j2KuJN4Hsga0jWVdgRmk86O7nc3rE7djiLiP3os8ru83MOSWn+FPjLCuCOJ3WfcByXNi4iV1UJJ84D/LombYy/M69myy2L7RMTRbeqeKunmaRq32+ewzmf0k6RxjNcDnX6hDj12n9trG0mvJB0MtJWkw1vW8ZVpGnuDeGK33rtynZBUfB5HH+0eetyJSyARcaikrYFXASdL2o30YVgQEVeMqi7UGk+YI+lU0i+FqWny851HGLdW7JrjGO8FLpb0ftKF+SBdzffdwFu7xa3E6TieEN37e7slqAenadzqF9o2lS80ka4fViQirpR0TUR8eRSxe40l9O/DTiAAABA1SURBVNhe3ybdXW9q+o+rVYGuCaTB2BtXB6wj30Ewf7ds2q3NebnSsYxacdu2Je/CTCxJO5AGwo8EdomIXUZVt3Q8QdLCbuuNdBLR0OPWjV13HCMf/vkOYGq55cBHIuKGbvVy3TrjCbcCb283C/hwRHQ8i77BuIvp8ms/It7QaV6uXzyOUSf2qMYx+tFUbElvI10s9C8j4o5c9jRSV+HSiPi/PeoXjWXUjdtWaX/b+vYANgPeOcq6jGgsYxrHLR7HyP8Ms9uU7wBs2kfsxZSPJ/xbt8d0jDuE92okYyh9xK0zlrC4Mr1whsX+S+AO4N78+DFwbL/vFYVjGXXitl3fqD4YM+EBzCJ1NZwF/BQ4d5R1Wz6wrf+k3S7nvj1wUv4S2oL0i2E5cB5troI6rLh1Y5OuxjuvTfk8YFmPuqeTL+bXUv464LQ+XvOPusy7eYSfqabifrwyfXzLvMUj/owUxwZuJV1c81WkLtXDq48edTsmvT63WWOxK3W3ALYcsE7rRUr3r0xfO6q47R4TNwYCIOmlwJ8Bh5DObH4x8PSI6Kd/u7gu5eMJXyDdYGlejvlvwP8jjWN8mnTNolHErRu7zjjGSyJiUWthRHxe0ok96kL9cYxnAYt44jjG6RFxyzSN+9LK9ELSezSln3ui1xlDqRO7zlhC3f73RmIrXaBybkR8NyJ+JeltlUHsL0SbKwK0KBrLGELcdUxcAlG6auUdpF/S74iIByTd1mfyKK6bvaMyvaxlXuvzqh0j4kRJIt057B9z+Y8kHTfCuLViR8TFkg7L8d+ci5cDr4re4xjd7nvezyV4tm49Mqay3q26BpZeRPryOD0/psYxLpN0eKT7sk+3uOow3a/ql+m3eOKX6bd71C2OHW2OOhtApx9GU+t+yzSN/Y9A9fIwf0F6v58EnEzay+7mX4EvSmo3lvGvI4y7jolLIKSbrxxGOirpEUnn0f+viTp1iR6D3V08kuuHpNYjph5ts/yw4taKnY/++lnkwwsr5TtI2jQiftOl+j3tjm5TujzGmj7a3folWNXrC/G9pDu9XVYp+w9Jl5K68w6ahnE3kLQtKblOTU99mc/qEbful2lxbEmLp2JLWjjgZ7XbD6OeGoz9rIi4oPL8wcgD2JK+06tyRHxU0oPAdyVtnot/BZwSEaeNKm47E3kUVv41vS/pbPKDSb8MjwEuinxo3Ijqbg8cRzqc9gzSL4Kpw2n/utMupKRfkL58lJef+iISqatn21HErRtb0umkw1e/0lL+ulz32C51FwDnkAalq91fRwFHRsQPO9WtS9ItEfHMDvNujohnTbe4km4nJfR2ewAREU/vEfvjEfHWPH18RPy/yrzF3RJMndj5EOHn5elBz+iudZmUpmJLujEidq883y4i1rab18e6tiB9j/e8DMkw406ZxD0QImXNS4FLlS5XfRDpUNxPkQaNR1KX8vGEQyvTH2mZ1/p8mHHrxi4ex4h0U6MFpMR3dC5eAbwwIu7pEReoNZ7Q7Z/x19MxbkTM7dWuHorHMWrGrvML9gpg6jDcT0TEm3ssP11iPyDpmVOfh8qX+LNJexJd1RjLqBW3nYlMIFUR8RBwvqRrSbfxHGXdovGEiPjWIO0aVtwhxC4ex5A0G9g+Ik5qKd9DUkRE126smuMJu7T2aU+tlt4nTzYV988j4nN5+sUR8b3KvMdOmOu2ig7TPdWMXWcsodrOFw/S5oZjn0S6fPoHgKtz2d7AicDxfdQvHcuoG3cdE51ActfOEaTuqJ2Br464btF4gtLlO04kdUF9lDRQNtUFdUxE9OqDrTOOUSd2nXGMT5AGBVvNId0D+s961K8znvCOLvN6beum4r4N+Fye/gT513H2RtIlSbqpM4ZSJ3adsYS6/e+NxI6Ir+cDLd5JOjwe0t714RGxvI9VFI1lDCHuOiZuDETpOjGvJH0BPZP0xf+aiJgzyrq5ftF4gqTvks432Qr4P6RDYL+W1/H+iHjhKOLWjV1nHEPSiohoeytVScuj91nsM24co2bcan/+Y9PtnneofzvDGccYKHbNsYQHgVW5zc/I0+TnERFdu96ajF3HKMYySk3iHsg9pP7LvyGdtRlKx7+Pui6UjydsERGnAygduvelXL5E0j92qVc3bq3YNccxNiqcN6XuOMZC0m791Bf+TcCpEXHWNI0bHabbPV+38vDGMQaNXWcs4fcHWHbaxJb0EtK5Y2fl5+cC2+XZ74+IS3usomgsYwhx1zGJCeRE0qD3acAXNNhtHOvUrTOeUO1m+mWXecOOWyt2zXGMlZIOjoiLWuoeRDqDuJc64wlHkfa03kbqKxbpi+YfJdHjy7ypuM+WdH2u84w8PRW36xFYOXadcYw6seuMJdwRPbpQlD9o0yz2yTx+XhSkHwtHk65VdyLpIJ1uSscy6sZdx8R1YU2R9HTS+MWRpKOTTgK+2seRMsV1S8cTeuwuPz0iNm9Xr27curElnU267Mi3WsoPIF0/qOM4hqRnAheQ7sFS7f56EfCKPrb1wm7zo/tFIC8ndbHd3lI+Fzg7IvaZhnGf1iPuj7vNV5cLC7Y+H2bsbnF7kXQZ6dys8yKfUJfLNyZdKHQh8M2IWDydYku6MiJeUHn+lYg4PE9/LyJ6JjOlC42+E5jq5l1BuuBmx7GMYcRdZ52TmkCqJD2XlBBeE12ueFq3bul4whC+HOqMY9T5cqg7jrEJabxparkVpMMUu52AWFu3fuRR9jHXidvjl3bPZWqOYxTHrjOWoHSi6htJRx3tCvyCdCmPWcA3gH+KiGu71G8ktqSVETGvw7xVEbFbp7h1jCRu1LyY1kx7kJNmyTJ16kbLhc6AVZ3mTZe4Q9het3Sp0/XCgnVfc56/kLSL/+v8WAYc1cd6ryqZ12Rc4DJS98RTW8o3BvYj3a3u6C7161xMsTg26ZbQHR+9tlllPRsBOwHbDFCnkdikH2+HtCl/BXBhH/VfUv08AeeSz00D9htV3LbrLKk0kx81P+yN/JPO4C+HC4GD25QfBFw8qrh5uaNIl73el3QxwG1yvavo8WVOuujh9W0eNwC/7lG3qbibAn8FfA+4C7iRNFb0Y1KX5V59xr6hpR0jjc0QfiiUPpqKDewG3Ew6offN+bEYuAV4Zh/1lwK7V57fQBoDeSnpyg8jidvuMXFdWDV3PUe5y9xxPKGpuHVj1xnH6BB3M9J5Cv285kbGE5ocx6isZyPSVRH+OyJ+0WedRmLXHceoo+HYm5A+29UxjL66Z+uMZdSJ23Z9k5ZAqkr+0erUHcY/6Uz6csh1ao9jFMZtZDyhyXGMOpqKXffH0UyMPYTxqqKxjJG8x8PePfOj665nU7vMExU3r7eR8YSm4g5hezUWuxJr4HGMmRi77ramcCxjFO/xRO+BjFtTu8yTFjfHmOq2W2cWo+22ayRuXU3GnjRD6J7djTS++H2eeB7I/6BL13DduG3X6QQyPg3uMk+nuLU+sAPEbqpPv7HuwmFpMvakKd3WdccyhvUeO4E0pKl/0kmJ22CffmPjGDYZptNnrJ9bg9oIRMRDEXH3uH/hTVDcb0p6s6SnVgslbSxpP0lnkrrQ1pe4NjmmzWfMeyC2Xppm3XYeS7ChabJreJ22OIHY+m5Suu1s8jT9GXMCMTOzIh4DMTOzIk4gZmZWxAnEzMyKOIFYoyR1vAXnGNtwu6TteyyzWNKrx9Sev5P09nHEGgVJe0k6eNDlJP2JpBNG2zobJicQswkiaRy3sd4L6JlAWpeLiPMj4pSRtcqGzgnEhkLSUZKul3SdpM9Kepqkpbls6dRJT5J2lfQDSVdKel/LOt6Ry6+XdHKXWHMl/UjSpyUtl/R5SS+X9D1JKyUtyMttJ+k/8voul/QHufzJkr4h6RpJ/0K6TtXUepdX4rxd0t+1ib+3pG9JukrSJZJ2arPMjpK+mrfHdZL+Ry5/W27zcklvrSz/Hkk3S/pP0r2qp8qfIenrOdZ3JD27y3ZZLOmf83K3SHpFLj9a0pckfY10nkDbbS1pc0kX5vYul/Sabq9X0mWSPiTpihzvD5Wuc/b3wGskXSvpNZIWSPp+3t7fl/SsDssdLemTed2dPj+LJZ2a13PruPYKrYNRX3nSj/X/Qboez83A9vn5dqQrhi7Mz98I/EeePp98YyXgOOBXeXp/4HTSl/kGpPuIvLRDvLnAw8Bz87JXAWfkuodWYn0COClP70e++yJwKvDePH0IEKRj6ecCyytx3g78XZ5eDLyadNXW7wOzc/lrgDPatPGLwFvz9CzSzaX2Jt38Z3NgC9L1i55XKX8S6bbDq4C357pLgXl5+oXApV3eh8XA1/M2mQesJp3EeHSe3q7btgZeBfxrZX1bd3u9pKu7/t88fTDwn3n6aOCTlfVsBWyYp18OfLnDco89p/PnZzHwpdzu3Wm5w6Yf432MY3fW1n/7AedGxM8BImKtpBcBh+f5nwU+nKdfTPqimir/UJ7ePz+uyc+3IH0JfrtDzNsi4gYASSuApRERkm4gJQJIV/x9VW7TpXnPY2vSl+XhufxCSfcN8FqfRbq3yRJJkJLD3W2W2490d0Ii4hHgfkkvAb4aEb/O7f4K6b70G+TyB3P5+fnvFqQrrH4pxwLYpEf7zomIR4GVkm4FpvZYlkTE2jzdaVt/B/iIpA8BF0TEdyQ9p8fr/Ur+exWPb/dWWwNnSppHStYb9XgNkG461u7zAymZPArcKGnHPtZlI+IEYsMg0hdDN9FhurqOD0bEv/QZ87eV6Ucrzx/l8c+1WFe0/K16mCd2627aoZ0rIuJFfbaztW4n7dqzAfCLiNhrgBit65l6/uuWdrTd1pL2Ju1NfFDSN4Cv0v31Tm33R+j8ffI+0mX7X6l0Z8bLeryGdqqvq/red9umNmIeA7FhWAr8qaQnQxp7IHV7HJnnvw74bp7+Xkv5lEuAN+Zf3UjaWdIONdv17akYkv4I+HlE/LKl/CBg27z8z4Ad8p7KJqQb9LS6GZid97CQtJGkPfL0myS9KS+3FDg2l8+StFWOe5ikJ0naHHgl6Vf/t4FXStpM0pbAHwPktt4m6Yi8Hknas8drPkLSBpKeATw9t7dV220t6feAByPic8BHgOd3e71dPABsWXm+NfCTPH10l+WqOn1+bBpxArHaImIF8AHgW5KuAz4KvAV4g6TrgdcDx+fFjweOk3Ql6Ytlah3fAL4A/CB3Q51L5y+Xfv0dMD+34RQev0LpycBLJV1N6sq5I7fhIdLA7g9J4wI/avNaf0caC/lQfq3XkrqZIHUX3Vt5nfvm13IVsEdEXE3qw78ix/h0RFyTy7+Y1/VlUlKZ8jrgmBxrBWmMp5ubgW8BFwN/GW3uD9FlWz8XuELStcB7gPf3eL2dfBPYfWpwnNT99EFJ3yN1gXVarqrT58emEV8Ly2xIJF0AHJ6/dJuIv5g0dnFuE/Ft8ngMxGxIIqJdl5fZessJxKatPKaytM2sl0XEvW3KJ4Kk9wBHtBR/KSKObqA5NsHchWVmZkU8iG5mZkWcQMzMrIgTiJmZFXECMTOzIk4gZmZW5P8DupC7BkuAkOkAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "course_clicks.plot.bar()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>sum</th>\n",
       "      <th>min</th>\n",
       "      <th>max</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>code_module</th>\n",
       "      <th>code_presentation</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">AAA</th>\n",
       "      <th>2013J</th>\n",
       "      <td>648494</td>\n",
       "      <td>1</td>\n",
       "      <td>1326</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014J</th>\n",
       "      <td>598158</td>\n",
       "      <td>1</td>\n",
       "      <td>659</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">BBB</th>\n",
       "      <th>2013B</th>\n",
       "      <td>1347911</td>\n",
       "      <td>1</td>\n",
       "      <td>381</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013J</th>\n",
       "      <td>1378656</td>\n",
       "      <td>1</td>\n",
       "      <td>212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014B</th>\n",
       "      <td>833865</td>\n",
       "      <td>1</td>\n",
       "      <td>223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014J</th>\n",
       "      <td>1673744</td>\n",
       "      <td>1</td>\n",
       "      <td>2664</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">CCC</th>\n",
       "      <th>2014B</th>\n",
       "      <td>1889177</td>\n",
       "      <td>1</td>\n",
       "      <td>1517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014J</th>\n",
       "      <td>2792972</td>\n",
       "      <td>1</td>\n",
       "      <td>2853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">DDD</th>\n",
       "      <th>2013B</th>\n",
       "      <td>1387467</td>\n",
       "      <td>1</td>\n",
       "      <td>514</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013J</th>\n",
       "      <td>1757214</td>\n",
       "      <td>1</td>\n",
       "      <td>6977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014B</th>\n",
       "      <td>947657</td>\n",
       "      <td>1</td>\n",
       "      <td>3958</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014J</th>\n",
       "      <td>1437751</td>\n",
       "      <td>1</td>\n",
       "      <td>4953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">EEE</th>\n",
       "      <th>2013J</th>\n",
       "      <td>1535953</td>\n",
       "      <td>1</td>\n",
       "      <td>4523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014B</th>\n",
       "      <td>832038</td>\n",
       "      <td>1</td>\n",
       "      <td>1497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014J</th>\n",
       "      <td>1616236</td>\n",
       "      <td>1</td>\n",
       "      <td>1442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">FFF</th>\n",
       "      <th>2013B</th>\n",
       "      <td>4220055</td>\n",
       "      <td>1</td>\n",
       "      <td>4098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013J</th>\n",
       "      <td>5116439</td>\n",
       "      <td>1</td>\n",
       "      <td>1836</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014B</th>\n",
       "      <td>2975619</td>\n",
       "      <td>1</td>\n",
       "      <td>864</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014J</th>\n",
       "      <td>5281809</td>\n",
       "      <td>1</td>\n",
       "      <td>755</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">GGG</th>\n",
       "      <th>2013J</th>\n",
       "      <td>509091</td>\n",
       "      <td>1</td>\n",
       "      <td>488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014B</th>\n",
       "      <td>425165</td>\n",
       "      <td>1</td>\n",
       "      <td>470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014J</th>\n",
       "      <td>399628</td>\n",
       "      <td>1</td>\n",
       "      <td>534</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   sum  min   max\n",
       "code_module code_presentation                    \n",
       "AAA         2013J               648494    1  1326\n",
       "            2014J               598158    1   659\n",
       "BBB         2013B              1347911    1   381\n",
       "            2013J              1378656    1   212\n",
       "            2014B               833865    1   223\n",
       "            2014J              1673744    1  2664\n",
       "CCC         2014B              1889177    1  1517\n",
       "            2014J              2792972    1  2853\n",
       "DDD         2013B              1387467    1   514\n",
       "            2013J              1757214    1  6977\n",
       "            2014B               947657    1  3958\n",
       "            2014J              1437751    1  4953\n",
       "EEE         2013J              1535953    1  4523\n",
       "            2014B               832038    1  1497\n",
       "            2014J              1616236    1  1442\n",
       "FFF         2013B              4220055    1  4098\n",
       "            2013J              5116439    1  1836\n",
       "            2014B              2975619    1   864\n",
       "            2014J              5281809    1   755\n",
       "GGG         2013J               509091    1   488\n",
       "            2014B               425165    1   470\n",
       "            2014J               399628    1   534"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stu_vle.groupby(['code_module', 'code_presentation'])['sum_click'].agg([sum, min, max])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Course assessment structures"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id_assessment</th>\n",
       "      <th>id_student</th>\n",
       "      <th>date_submitted</th>\n",
       "      <th>is_banked</th>\n",
       "      <th>score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1752</td>\n",
       "      <td>11391</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>78.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1752</td>\n",
       "      <td>28400</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>70.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1752</td>\n",
       "      <td>31604</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>72.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1752</td>\n",
       "      <td>32885</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>69.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1752</td>\n",
       "      <td>38053</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>79.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id_assessment  id_student  date_submitted  is_banked  score\n",
       "0           1752       11391              18          0   78.0\n",
       "1           1752       28400              22          0   70.0\n",
       "2           1752       31604              17          0   72.0\n",
       "3           1752       32885              26          0   69.0\n",
       "4           1752       38053              19          0   79.0"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stu_as.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>id_assessment</th>\n",
       "      <th>assessment_type</th>\n",
       "      <th>date</th>\n",
       "      <th>weight</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>code_module</th>\n",
       "      <th>code_presentation</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">AAA</th>\n",
       "      <th>2013J</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014J</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">BBB</th>\n",
       "      <th>2013B</th>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013J</th>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014B</th>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014J</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">CCC</th>\n",
       "      <th>2014B</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014J</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">DDD</th>\n",
       "      <th>2013B</th>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013J</th>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014B</th>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014J</th>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">EEE</th>\n",
       "      <th>2013J</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014B</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014J</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">FFF</th>\n",
       "      <th>2013B</th>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013J</th>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014B</th>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014J</th>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">GGG</th>\n",
       "      <th>2013J</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014B</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014J</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               id_assessment  assessment_type  date  weight\n",
       "code_module code_presentation                                              \n",
       "AAA         2013J                          6                6     5       6\n",
       "            2014J                          6                6     5       6\n",
       "BBB         2013B                         12               12    11      12\n",
       "            2013J                         12               12    11      12\n",
       "            2014B                         12               12    11      12\n",
       "            2014J                          6                6     5       6\n",
       "CCC         2014B                         10               10     8      10\n",
       "            2014J                         10               10     8      10\n",
       "DDD         2013B                         14               14    14      14\n",
       "            2013J                          7                7     7       7\n",
       "            2014B                          7                7     7       7\n",
       "            2014J                          7                7     6       7\n",
       "EEE         2013J                          5                5     5       5\n",
       "            2014B                          5                5     5       5\n",
       "            2014J                          5                5     5       5\n",
       "FFF         2013B                         13               13    13      13\n",
       "            2013J                         13               13    13      13\n",
       "            2014B                         13               13    13      13\n",
       "            2014J                         13               13    13      13\n",
       "GGG         2013J                         10               10    10      10\n",
       "            2014B                         10               10    10      10\n",
       "            2014J                         10               10    10      10"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ass.groupby(['code_module', 'code_presentation']).count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>id_site</th>\n",
       "      <th>activity_type</th>\n",
       "      <th>week_from</th>\n",
       "      <th>week_to</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>code_module</th>\n",
       "      <th>code_presentation</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">AAA</th>\n",
       "      <th>2013J</th>\n",
       "      <td>211</td>\n",
       "      <td>211</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014J</th>\n",
       "      <td>202</td>\n",
       "      <td>202</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">BBB</th>\n",
       "      <th>2013B</th>\n",
       "      <td>315</td>\n",
       "      <td>315</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013J</th>\n",
       "      <td>321</td>\n",
       "      <td>321</td>\n",
       "      <td>76</td>\n",
       "      <td>76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014B</th>\n",
       "      <td>311</td>\n",
       "      <td>311</td>\n",
       "      <td>76</td>\n",
       "      <td>76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014J</th>\n",
       "      <td>207</td>\n",
       "      <td>207</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">CCC</th>\n",
       "      <th>2014B</th>\n",
       "      <td>196</td>\n",
       "      <td>196</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014J</th>\n",
       "      <td>223</td>\n",
       "      <td>223</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">DDD</th>\n",
       "      <th>2013B</th>\n",
       "      <td>428</td>\n",
       "      <td>428</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013J</th>\n",
       "      <td>462</td>\n",
       "      <td>462</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014B</th>\n",
       "      <td>453</td>\n",
       "      <td>453</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014J</th>\n",
       "      <td>365</td>\n",
       "      <td>365</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">EEE</th>\n",
       "      <th>2013J</th>\n",
       "      <td>112</td>\n",
       "      <td>112</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014B</th>\n",
       "      <td>109</td>\n",
       "      <td>109</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014J</th>\n",
       "      <td>115</td>\n",
       "      <td>115</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">FFF</th>\n",
       "      <th>2013B</th>\n",
       "      <td>508</td>\n",
       "      <td>508</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013J</th>\n",
       "      <td>529</td>\n",
       "      <td>529</td>\n",
       "      <td>283</td>\n",
       "      <td>283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014B</th>\n",
       "      <td>478</td>\n",
       "      <td>478</td>\n",
       "      <td>259</td>\n",
       "      <td>259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014J</th>\n",
       "      <td>452</td>\n",
       "      <td>452</td>\n",
       "      <td>259</td>\n",
       "      <td>259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">GGG</th>\n",
       "      <th>2013J</th>\n",
       "      <td>137</td>\n",
       "      <td>137</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014B</th>\n",
       "      <td>124</td>\n",
       "      <td>124</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014J</th>\n",
       "      <td>106</td>\n",
       "      <td>106</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               id_site  activity_type  week_from  week_to\n",
       "code_module code_presentation                                            \n",
       "AAA         2013J                  211            211          3        3\n",
       "            2014J                  202            202          3        3\n",
       "BBB         2013B                  315            315          0        0\n",
       "            2013J                  321            321         76       76\n",
       "            2014B                  311            311         76       76\n",
       "            2014J                  207            207         34       34\n",
       "CCC         2014B                  196            196          5        5\n",
       "            2014J                  223            223          5        5\n",
       "DDD         2013B                  428            428          0        0\n",
       "            2013J                  462            462          0        0\n",
       "            2014B                  453            453          1        1\n",
       "            2014J                  365            365          1        1\n",
       "EEE         2013J                  112            112         26       26\n",
       "            2014B                  109            109         26       26\n",
       "            2014J                  115            115         27       27\n",
       "FFF         2013B                  508            508         25       25\n",
       "            2013J                  529            529        283      283\n",
       "            2014B                  478            478        259      259\n",
       "            2014J                  452            452        259      259\n",
       "GGG         2013J                  137            137          4        4\n",
       "            2014B                  124            124          4        4\n",
       "            2014J                  106            106          4        4"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vle.groupby(['code_module', 'code_presentation']).count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "code_module  code_presentation\n",
       "AAA          2013J                209\n",
       "             2014J                197\n",
       "BBB          2013B                315\n",
       "             2013J                320\n",
       "             2014B                311\n",
       "             2014J                206\n",
       "CCC          2014B                180\n",
       "             2014J                220\n",
       "DDD          2013B                408\n",
       "             2013J                456\n",
       "             2014B                447\n",
       "             2014J                361\n",
       "EEE          2013J                107\n",
       "             2014B                104\n",
       "             2014J                110\n",
       "FFF          2013B                500\n",
       "             2013J                526\n",
       "             2014B                475\n",
       "             2014J                449\n",
       "GGG          2013J                137\n",
       "             2014B                124\n",
       "             2014J                106\n",
       "Name: id_site, dtype: int64"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stu_vle.groupby(['code_module', 'code_presentation'])['id_site'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "stu_vle['activity_type'] = stu_vle['id_site'].map(vle.set_index('id_site')['activity_type'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code_module</th>\n",
       "      <th>code_presentation</th>\n",
       "      <th>id_student</th>\n",
       "      <th>id_site</th>\n",
       "      <th>date</th>\n",
       "      <th>sum_click</th>\n",
       "      <th>activity_type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>28400</td>\n",
       "      <td>546652</td>\n",
       "      <td>-10</td>\n",
       "      <td>4</td>\n",
       "      <td>forumng</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>28400</td>\n",
       "      <td>546652</td>\n",
       "      <td>-10</td>\n",
       "      <td>1</td>\n",
       "      <td>forumng</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>28400</td>\n",
       "      <td>546652</td>\n",
       "      <td>-10</td>\n",
       "      <td>1</td>\n",
       "      <td>forumng</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>28400</td>\n",
       "      <td>546614</td>\n",
       "      <td>-10</td>\n",
       "      <td>11</td>\n",
       "      <td>homepage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AAA</td>\n",
       "      <td>2013J</td>\n",
       "      <td>28400</td>\n",
       "      <td>546714</td>\n",
       "      <td>-10</td>\n",
       "      <td>1</td>\n",
       "      <td>oucontent</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  code_module code_presentation  id_student  id_site  date  sum_click  \\\n",
       "0         AAA             2013J       28400   546652   -10          4   \n",
       "1         AAA             2013J       28400   546652   -10          1   \n",
       "2         AAA             2013J       28400   546652   -10          1   \n",
       "3         AAA             2013J       28400   546614   -10         11   \n",
       "4         AAA             2013J       28400   546714   -10          1   \n",
       "\n",
       "  activity_type  \n",
       "0       forumng  \n",
       "1       forumng  \n",
       "2       forumng  \n",
       "3      homepage  \n",
       "4     oucontent  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stu_vle.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>id_student</th>\n",
       "      <th>id_site</th>\n",
       "      <th>date</th>\n",
       "      <th>sum_click</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>code_module</th>\n",
       "      <th>code_presentation</th>\n",
       "      <th>activity_type</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"18\" valign=\"top\">AAA</th>\n",
       "      <th rowspan=\"9\" valign=\"top\">2013J</th>\n",
       "      <th>dataplus</th>\n",
       "      <td>510</td>\n",
       "      <td>510</td>\n",
       "      <td>510</td>\n",
       "      <td>510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>forumng</th>\n",
       "      <td>57044</td>\n",
       "      <td>57044</td>\n",
       "      <td>57044</td>\n",
       "      <td>57044</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>glossary</th>\n",
       "      <td>147</td>\n",
       "      <td>147</td>\n",
       "      <td>147</td>\n",
       "      <td>147</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>homepage</th>\n",
       "      <td>33429</td>\n",
       "      <td>33429</td>\n",
       "      <td>33429</td>\n",
       "      <td>33429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oucollaborate</th>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oucontent</th>\n",
       "      <td>54607</td>\n",
       "      <td>54607</td>\n",
       "      <td>54607</td>\n",
       "      <td>54607</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>resource</th>\n",
       "      <td>5506</td>\n",
       "      <td>5506</td>\n",
       "      <td>5506</td>\n",
       "      <td>5506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>subpage</th>\n",
       "      <td>20745</td>\n",
       "      <td>20745</td>\n",
       "      <td>20745</td>\n",
       "      <td>20745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>url</th>\n",
       "      <td>8835</td>\n",
       "      <td>8835</td>\n",
       "      <td>8835</td>\n",
       "      <td>8835</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"9\" valign=\"top\">2014J</th>\n",
       "      <th>dataplus</th>\n",
       "      <td>457</td>\n",
       "      <td>457</td>\n",
       "      <td>457</td>\n",
       "      <td>457</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>forumng</th>\n",
       "      <td>49799</td>\n",
       "      <td>49799</td>\n",
       "      <td>49799</td>\n",
       "      <td>49799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>glossary</th>\n",
       "      <td>136</td>\n",
       "      <td>136</td>\n",
       "      <td>136</td>\n",
       "      <td>136</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>homepage</th>\n",
       "      <td>29907</td>\n",
       "      <td>29907</td>\n",
       "      <td>29907</td>\n",
       "      <td>29907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oucollaborate</th>\n",
       "      <td>183</td>\n",
       "      <td>183</td>\n",
       "      <td>183</td>\n",
       "      <td>183</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oucontent</th>\n",
       "      <td>58207</td>\n",
       "      <td>58207</td>\n",
       "      <td>58207</td>\n",
       "      <td>58207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>resource</th>\n",
       "      <td>5686</td>\n",
       "      <td>5686</td>\n",
       "      <td>5686</td>\n",
       "      <td>5686</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>subpage</th>\n",
       "      <td>17926</td>\n",
       "      <td>17926</td>\n",
       "      <td>17926</td>\n",
       "      <td>17926</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>url</th>\n",
       "      <td>7015</td>\n",
       "      <td>7015</td>\n",
       "      <td>7015</td>\n",
       "      <td>7015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"12\" valign=\"top\">BBB</th>\n",
       "      <th rowspan=\"10\" valign=\"top\">2013B</th>\n",
       "      <th>forumng</th>\n",
       "      <td>193180</td>\n",
       "      <td>193180</td>\n",
       "      <td>193180</td>\n",
       "      <td>193180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>glossary</th>\n",
       "      <td>986</td>\n",
       "      <td>986</td>\n",
       "      <td>986</td>\n",
       "      <td>986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>homepage</th>\n",
       "      <td>76433</td>\n",
       "      <td>76433</td>\n",
       "      <td>76433</td>\n",
       "      <td>76433</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oucontent</th>\n",
       "      <td>1129</td>\n",
       "      <td>1129</td>\n",
       "      <td>1129</td>\n",
       "      <td>1129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ouelluminate</th>\n",
       "      <td>1022</td>\n",
       "      <td>1022</td>\n",
       "      <td>1022</td>\n",
       "      <td>1022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>quiz</th>\n",
       "      <td>37918</td>\n",
       "      <td>37918</td>\n",
       "      <td>37918</td>\n",
       "      <td>37918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>resource</th>\n",
       "      <td>36852</td>\n",
       "      <td>36852</td>\n",
       "      <td>36852</td>\n",
       "      <td>36852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sharedsubpage</th>\n",
       "      <td>53</td>\n",
       "      <td>53</td>\n",
       "      <td>53</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>subpage</th>\n",
       "      <td>42076</td>\n",
       "      <td>42076</td>\n",
       "      <td>42076</td>\n",
       "      <td>42076</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>url</th>\n",
       "      <td>13617</td>\n",
       "      <td>13617</td>\n",
       "      <td>13617</td>\n",
       "      <td>13617</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2013J</th>\n",
       "      <th>forumng</th>\n",
       "      <td>191788</td>\n",
       "      <td>191788</td>\n",
       "      <td>191788</td>\n",
       "      <td>191788</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>glossary</th>\n",
       "      <td>1002</td>\n",
       "      <td>1002</td>\n",
       "      <td>1002</td>\n",
       "      <td>1002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"9\" valign=\"top\">FFF</th>\n",
       "      <th rowspan=\"9\" valign=\"top\">2014J</th>\n",
       "      <th>oucontent</th>\n",
       "      <td>321499</td>\n",
       "      <td>321499</td>\n",
       "      <td>321499</td>\n",
       "      <td>321499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ouwiki</th>\n",
       "      <td>15559</td>\n",
       "      <td>15559</td>\n",
       "      <td>15559</td>\n",
       "      <td>15559</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>page</th>\n",
       "      <td>7041</td>\n",
       "      <td>7041</td>\n",
       "      <td>7041</td>\n",
       "      <td>7041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>questionnaire</th>\n",
       "      <td>14153</td>\n",
       "      <td>14153</td>\n",
       "      <td>14153</td>\n",
       "      <td>14153</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>quiz</th>\n",
       "      <td>110110</td>\n",
       "      <td>110110</td>\n",
       "      <td>110110</td>\n",
       "      <td>110110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>repeatactivity</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>resource</th>\n",
       "      <td>49036</td>\n",
       "      <td>49036</td>\n",
       "      <td>49036</td>\n",
       "      <td>49036</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>subpage</th>\n",
       "      <td>261219</td>\n",
       "      <td>261219</td>\n",
       "      <td>261219</td>\n",
       "      <td>261219</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>url</th>\n",
       "      <td>36631</td>\n",
       "      <td>36631</td>\n",
       "      <td>36631</td>\n",
       "      <td>36631</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"21\" valign=\"top\">GGG</th>\n",
       "      <th rowspan=\"7\" valign=\"top\">2013J</th>\n",
       "      <th>forumng</th>\n",
       "      <td>25311</td>\n",
       "      <td>25311</td>\n",
       "      <td>25311</td>\n",
       "      <td>25311</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>glossary</th>\n",
       "      <td>1233</td>\n",
       "      <td>1233</td>\n",
       "      <td>1233</td>\n",
       "      <td>1233</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>homepage</th>\n",
       "      <td>31198</td>\n",
       "      <td>31198</td>\n",
       "      <td>31198</td>\n",
       "      <td>31198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oucontent</th>\n",
       "      <td>31154</td>\n",
       "      <td>31154</td>\n",
       "      <td>31154</td>\n",
       "      <td>31154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>quiz</th>\n",
       "      <td>28861</td>\n",
       "      <td>28861</td>\n",
       "      <td>28861</td>\n",
       "      <td>28861</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>resource</th>\n",
       "      <td>17091</td>\n",
       "      <td>17091</td>\n",
       "      <td>17091</td>\n",
       "      <td>17091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>subpage</th>\n",
       "      <td>11147</td>\n",
       "      <td>11147</td>\n",
       "      <td>11147</td>\n",
       "      <td>11147</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">2014B</th>\n",
       "      <th>forumng</th>\n",
       "      <td>22586</td>\n",
       "      <td>22586</td>\n",
       "      <td>22586</td>\n",
       "      <td>22586</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>glossary</th>\n",
       "      <td>823</td>\n",
       "      <td>823</td>\n",
       "      <td>823</td>\n",
       "      <td>823</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>homepage</th>\n",
       "      <td>25154</td>\n",
       "      <td>25154</td>\n",
       "      <td>25154</td>\n",
       "      <td>25154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oucontent</th>\n",
       "      <td>26892</td>\n",
       "      <td>26892</td>\n",
       "      <td>26892</td>\n",
       "      <td>26892</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>quiz</th>\n",
       "      <td>22818</td>\n",
       "      <td>22818</td>\n",
       "      <td>22818</td>\n",
       "      <td>22818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>resource</th>\n",
       "      <td>15377</td>\n",
       "      <td>15377</td>\n",
       "      <td>15377</td>\n",
       "      <td>15377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>subpage</th>\n",
       "      <td>9669</td>\n",
       "      <td>9669</td>\n",
       "      <td>9669</td>\n",
       "      <td>9669</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">2014J</th>\n",
       "      <th>forumng</th>\n",
       "      <td>19075</td>\n",
       "      <td>19075</td>\n",
       "      <td>19075</td>\n",
       "      <td>19075</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>glossary</th>\n",
       "      <td>1013</td>\n",
       "      <td>1013</td>\n",
       "      <td>1013</td>\n",
       "      <td>1013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>homepage</th>\n",
       "      <td>23982</td>\n",
       "      <td>23982</td>\n",
       "      <td>23982</td>\n",
       "      <td>23982</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oucontent</th>\n",
       "      <td>28097</td>\n",
       "      <td>28097</td>\n",
       "      <td>28097</td>\n",
       "      <td>28097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>quiz</th>\n",
       "      <td>19062</td>\n",
       "      <td>19062</td>\n",
       "      <td>19062</td>\n",
       "      <td>19062</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>resource</th>\n",
       "      <td>16423</td>\n",
       "      <td>16423</td>\n",
       "      <td>16423</td>\n",
       "      <td>16423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>subpage</th>\n",
       "      <td>10207</td>\n",
       "      <td>10207</td>\n",
       "      <td>10207</td>\n",
       "      <td>10207</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>232 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              id_student  id_site    date  \\\n",
       "code_module code_presentation activity_type                                 \n",
       "AAA         2013J             dataplus               510      510     510   \n",
       "                              forumng              57044    57044   57044   \n",
       "                              glossary               147      147     147   \n",
       "                              homepage             33429    33429   33429   \n",
       "                              oucollaborate          159      159     159   \n",
       "                              oucontent            54607    54607   54607   \n",
       "                              resource              5506     5506    5506   \n",
       "                              subpage              20745    20745   20745   \n",
       "                              url                   8835     8835    8835   \n",
       "            2014J             dataplus               457      457     457   \n",
       "                              forumng              49799    49799   49799   \n",
       "                              glossary               136      136     136   \n",
       "                              homepage             29907    29907   29907   \n",
       "                              oucollaborate          183      183     183   \n",
       "                              oucontent            58207    58207   58207   \n",
       "                              resource              5686     5686    5686   \n",
       "                              subpage              17926    17926   17926   \n",
       "                              url                   7015     7015    7015   \n",
       "BBB         2013B             forumng             193180   193180  193180   \n",
       "                              glossary               986      986     986   \n",
       "                              homepage             76433    76433   76433   \n",
       "                              oucontent             1129     1129    1129   \n",
       "                              ouelluminate          1022     1022    1022   \n",
       "                              quiz                 37918    37918   37918   \n",
       "                              resource             36852    36852   36852   \n",
       "                              sharedsubpage           53       53      53   \n",
       "                              subpage              42076    42076   42076   \n",
       "                              url                  13617    13617   13617   \n",
       "            2013J             forumng             191788   191788  191788   \n",
       "                              glossary              1002     1002    1002   \n",
       "...                                                  ...      ...     ...   \n",
       "FFF         2014J             oucontent           321499   321499  321499   \n",
       "                              ouwiki               15559    15559   15559   \n",
       "                              page                  7041     7041    7041   \n",
       "                              questionnaire        14153    14153   14153   \n",
       "                              quiz                110110   110110  110110   \n",
       "                              repeatactivity           2        2       2   \n",
       "                              resource             49036    49036   49036   \n",
       "                              subpage             261219   261219  261219   \n",
       "                              url                  36631    36631   36631   \n",
       "GGG         2013J             forumng              25311    25311   25311   \n",
       "                              glossary              1233     1233    1233   \n",
       "                              homepage             31198    31198   31198   \n",
       "                              oucontent            31154    31154   31154   \n",
       "                              quiz                 28861    28861   28861   \n",
       "                              resource             17091    17091   17091   \n",
       "                              subpage              11147    11147   11147   \n",
       "            2014B             forumng              22586    22586   22586   \n",
       "                              glossary               823      823     823   \n",
       "                              homepage             25154    25154   25154   \n",
       "                              oucontent            26892    26892   26892   \n",
       "                              quiz                 22818    22818   22818   \n",
       "                              resource             15377    15377   15377   \n",
       "                              subpage               9669     9669    9669   \n",
       "            2014J             forumng              19075    19075   19075   \n",
       "                              glossary              1013     1013    1013   \n",
       "                              homepage             23982    23982   23982   \n",
       "                              oucontent            28097    28097   28097   \n",
       "                              quiz                 19062    19062   19062   \n",
       "                              resource             16423    16423   16423   \n",
       "                              subpage              10207    10207   10207   \n",
       "\n",
       "                                              sum_click  \n",
       "code_module code_presentation activity_type              \n",
       "AAA         2013J             dataplus              510  \n",
       "                              forumng             57044  \n",
       "                              glossary              147  \n",
       "                              homepage            33429  \n",
       "                              oucollaborate         159  \n",
       "                              oucontent           54607  \n",
       "                              resource             5506  \n",
       "                              subpage             20745  \n",
       "                              url                  8835  \n",
       "            2014J             dataplus              457  \n",
       "                              forumng             49799  \n",
       "                              glossary              136  \n",
       "                              homepage            29907  \n",
       "                              oucollaborate         183  \n",
       "                              oucontent           58207  \n",
       "                              resource             5686  \n",
       "                              subpage             17926  \n",
       "                              url                  7015  \n",
       "BBB         2013B             forumng            193180  \n",
       "                              glossary              986  \n",
       "                              homepage            76433  \n",
       "                              oucontent            1129  \n",
       "                              ouelluminate         1022  \n",
       "                              quiz                37918  \n",
       "                              resource            36852  \n",
       "                              sharedsubpage          53  \n",
       "                              subpage             42076  \n",
       "                              url                 13617  \n",
       "            2013J             forumng            191788  \n",
       "                              glossary             1002  \n",
       "...                                                 ...  \n",
       "FFF         2014J             oucontent          321499  \n",
       "                              ouwiki              15559  \n",
       "                              page                 7041  \n",
       "                              questionnaire       14153  \n",
       "                              quiz               110110  \n",
       "                              repeatactivity          2  \n",
       "                              resource            49036  \n",
       "                              subpage            261219  \n",
       "                              url                 36631  \n",
       "GGG         2013J             forumng             25311  \n",
       "                              glossary             1233  \n",
       "                              homepage            31198  \n",
       "                              oucontent           31154  \n",
       "                              quiz                28861  \n",
       "                              resource            17091  \n",
       "                              subpage             11147  \n",
       "            2014B             forumng             22586  \n",
       "                              glossary              823  \n",
       "                              homepage            25154  \n",
       "                              oucontent           26892  \n",
       "                              quiz                22818  \n",
       "                              resource            15377  \n",
       "                              subpage              9669  \n",
       "            2014J             forumng             19075  \n",
       "                              glossary             1013  \n",
       "                              homepage            23982  \n",
       "                              oucontent           28097  \n",
       "                              quiz                19062  \n",
       "                              resource            16423  \n",
       "                              subpage             10207  \n",
       "\n",
       "[232 rows x 4 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stu_vle.groupby(['code_module', 'code_presentation', 'activity_type']).count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>id_site</th>\n",
       "      <th>code_presentation</th>\n",
       "      <th>week_from</th>\n",
       "      <th>week_to</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>activity_type</th>\n",
       "      <th>code_module</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">dataplus</th>\n",
       "      <th>AAA</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FFF</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">dualpane</th>\n",
       "      <th>EEE</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FFF</th>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>externalquiz</th>\n",
       "      <th>DDD</th>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>folder</th>\n",
       "      <th>FFF</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">forumng</th>\n",
       "      <th>AAA</th>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BBB</th>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CCC</th>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DDD</th>\n",
       "      <td>53</td>\n",
       "      <td>53</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EEE</th>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FFF</th>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GGG</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">glossary</th>\n",
       "      <th>AAA</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BBB</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DDD</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FFF</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GGG</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">homepage</th>\n",
       "      <th>AAA</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BBB</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CCC</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DDD</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EEE</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FFF</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GGG</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htmlactivity</th>\n",
       "      <th>FFF</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">oucollaborate</th>\n",
       "      <th>AAA</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BBB</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CCC</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DDD</th>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>page</th>\n",
       "      <th>FFF</th>\n",
       "      <td>86</td>\n",
       "      <td>86</td>\n",
       "      <td>33</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">questionnaire</th>\n",
       "      <th>BBB</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FFF</th>\n",
       "      <td>57</td>\n",
       "      <td>57</td>\n",
       "      <td>42</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">quiz</th>\n",
       "      <th>BBB</th>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CCC</th>\n",
       "      <td>32</td>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EEE</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FFF</th>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GGG</th>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>repeatactivity</th>\n",
       "      <th>FFF</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">resource</th>\n",
       "      <th>AAA</th>\n",
       "      <td>188</td>\n",
       "      <td>188</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BBB</th>\n",
       "      <td>807</td>\n",
       "      <td>807</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CCC</th>\n",
       "      <td>163</td>\n",
       "      <td>163</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DDD</th>\n",
       "      <td>706</td>\n",
       "      <td>706</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EEE</th>\n",
       "      <td>103</td>\n",
       "      <td>103</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FFF</th>\n",
       "      <td>454</td>\n",
       "      <td>454</td>\n",
       "      <td>48</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GGG</th>\n",
       "      <td>239</td>\n",
       "      <td>239</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sharedsubpage</th>\n",
       "      <th>BBB</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">subpage</th>\n",
       "      <th>AAA</th>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BBB</th>\n",
       "      <td>122</td>\n",
       "      <td>122</td>\n",
       "      <td>48</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CCC</th>\n",
       "      <td>59</td>\n",
       "      <td>59</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DDD</th>\n",
       "      <td>611</td>\n",
       "      <td>611</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EEE</th>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FFF</th>\n",
       "      <td>215</td>\n",
       "      <td>215</td>\n",
       "      <td>87</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GGG</th>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"6\" valign=\"top\">url</th>\n",
       "      <th>AAA</th>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BBB</th>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CCC</th>\n",
       "      <td>32</td>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DDD</th>\n",
       "      <td>223</td>\n",
       "      <td>223</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EEE</th>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FFF</th>\n",
       "      <td>522</td>\n",
       "      <td>522</td>\n",
       "      <td>328</td>\n",
       "      <td>328</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>78 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            id_site  code_presentation  week_from  week_to\n",
       "activity_type  code_module                                                \n",
       "dataplus       AAA                8                  8          0        0\n",
       "               FFF               20                 20          2        2\n",
       "dualpane       EEE                3                  3          0        0\n",
       "               FFF               17                 17          5        5\n",
       "externalquiz   DDD               26                 26          0        0\n",
       "folder         FFF                2                  2          0        0\n",
       "forumng        AAA               21                 21          0        0\n",
       "               BBB               56                 56          0        0\n",
       "               CCC               18                 18          0        0\n",
       "               DDD               53                 53          0        0\n",
       "               EEE               15                 15          0        0\n",
       "               FFF               25                 25          0        0\n",
       "               GGG                6                  6          0        0\n",
       "glossary       AAA                4                  4          0        0\n",
       "               BBB                5                  5          0        0\n",
       "               DDD                5                  5          0        0\n",
       "               FFF                4                  4          0        0\n",
       "               GGG                3                  3          0        0\n",
       "homepage       AAA                2                  2          0        0\n",
       "               BBB                4                  4          0        0\n",
       "               CCC                2                  2          0        0\n",
       "               DDD                4                  4          0        0\n",
       "               EEE                3                  3          0        0\n",
       "               FFF                4                  4          0        0\n",
       "               GGG                3                  3          0        0\n",
       "htmlactivity   FFF                4                  4          0        0\n",
       "oucollaborate  AAA                4                  4          0        0\n",
       "               BBB                6                  6          0        0\n",
       "               CCC                4                  4          0        0\n",
       "               DDD               14                 14          0        0\n",
       "...                             ...                ...        ...      ...\n",
       "page           FFF               86                 86         33       33\n",
       "questionnaire  BBB                4                  4          0        0\n",
       "               FFF               57                 57         42       42\n",
       "quiz           BBB               19                 19          1        1\n",
       "               CCC               32                 32          0        0\n",
       "               EEE                6                  6          0        0\n",
       "               FFF               44                 44         12       12\n",
       "               GGG               26                 26          0        0\n",
       "repeatactivity FFF                5                  5          4        4\n",
       "resource       AAA              188                188          0        0\n",
       "               BBB              807                807         88       88\n",
       "               CCC              163                163          0        0\n",
       "               DDD              706                706          0        0\n",
       "               EEE              103                103          0        0\n",
       "               FFF              454                454         48       48\n",
       "               GGG              239                239         12       12\n",
       "sharedsubpage  BBB                3                  3          0        0\n",
       "subpage        AAA               12                 12          0        0\n",
       "               BBB              122                122         48       48\n",
       "               CCC               59                 59          0        0\n",
       "               DDD              611                611          0        0\n",
       "               EEE               21                 21          0        0\n",
       "               FFF              215                215         87       87\n",
       "               GGG               15                 15          0        0\n",
       "url            AAA               38                 38          0        0\n",
       "               BBB               50                 50         23       23\n",
       "               CCC               32                 32          0        0\n",
       "               DDD              223                223          1        1\n",
       "               EEE               21                 21          0        0\n",
       "               FFF              522                522        328      328\n",
       "\n",
       "[78 rows x 4 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vle.groupby(['activity_type', 'code_module']).count()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}