{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Example of Page-wise Aggregation" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "# import openLA as la\n", "import OpenLA as la" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "course_info, event_stream = la.start_analysis(files_dir=\"dataset_sample\", course_id=\"A\")" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Before conversion" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | userid | \n", "contentsid | \n", "operationname | \n", "pageno | \n", "marker | \n", "memo_length | \n", "devicecode | \n", "eventtime | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "A_U1 | \n", "C1 | \n", "PREV | \n", "10 | \n", "NaN | \n", "0 | \n", "tablet | \n", "2018-04-09 10:57:15 | \n", "
1 | \n", "A_U1 | \n", "C1 | \n", "PREV | \n", "9 | \n", "NaN | \n", "0 | \n", "tablet | \n", "2018-04-09 11:00:59 | \n", "
2 | \n", "A_U1 | \n", "C1 | \n", "PREV | \n", "8 | \n", "NaN | \n", "0 | \n", "tablet | \n", "2018-04-09 11:03:31 | \n", "
3 | \n", "A_U1 | \n", "C1 | \n", "PREV | \n", "30 | \n", "NaN | \n", "0 | \n", "tablet | \n", "2018-04-10 10:14:12 | \n", "
4 | \n", "A_U1 | \n", "C1 | \n", "PREV | \n", "29 | \n", "NaN | \n", "0 | \n", "tablet | \n", "2018-04-10 10:27:24 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
263279 | \n", "A_U99 | \n", "C8 | \n", "NEXT | \n", "3 | \n", "NaN | \n", "0 | \n", "pc | \n", "2018-06-05 16:16:18 | \n", "
263280 | \n", "A_U99 | \n", "C8 | \n", "ADD MARKER | \n", "4 | \n", "difficult | \n", "0 | \n", "pc | \n", "2018-06-05 16:18:34 | \n", "
263281 | \n", "A_U99 | \n", "C8 | \n", "NEXT | \n", "4 | \n", "NaN | \n", "0 | \n", "pc | \n", "2018-06-05 16:19:24 | \n", "
263282 | \n", "A_U99 | \n", "C8 | \n", "NEXT | \n", "5 | \n", "NaN | \n", "0 | \n", "pc | \n", "2018-06-05 16:20:45 | \n", "
263283 | \n", "A_U99 | \n", "C8 | \n", "PREV | \n", "6 | \n", "NaN | \n", "0 | \n", "pc | \n", "2018-06-05 16:21:03 | \n", "
263284 rows × 8 columns
\n", "\n", " | userid | \n", "contentsid | \n", "pageno | \n", "num_visits | \n", "average_reading_seconds | \n", "reading_seconds | \n", "OPEN | \n", "CLOSE | \n", "ADD MARKER | \n", "ADD MEMO | \n", "ADD BOOKMARK | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "A_U1 | \n", "C1 | \n", "1 | \n", "12 | \n", "148.416667 | \n", "1781 | \n", "8 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
1 | \n", "A_U1 | \n", "C1 | \n", "2 | \n", "8 | \n", "240.500000 | \n", "1924 | \n", "0 | \n", "1 | \n", "2 | \n", "0 | \n", "0 | \n", "
2 | \n", "A_U1 | \n", "C1 | \n", "3 | \n", "5 | \n", "93.400000 | \n", "467 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
3 | \n", "A_U1 | \n", "C1 | \n", "4 | \n", "6 | \n", "74.833333 | \n", "449 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
4 | \n", "A_U1 | \n", "C1 | \n", "5 | \n", "6 | \n", "87.833333 | \n", "527 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1734 | \n", "A_U102 | \n", "C8 | \n", "79 | \n", "6 | \n", "46.166667 | \n", "277 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
1735 | \n", "A_U102 | \n", "C8 | \n", "80 | \n", "6 | \n", "44.166667 | \n", "265 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
1736 | \n", "A_U102 | \n", "C8 | \n", "81 | \n", "4 | \n", "28.250000 | \n", "113 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
1737 | \n", "A_U102 | \n", "C8 | \n", "82 | \n", "6 | \n", "143.500000 | \n", "861 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
1738 | \n", "A_U102 | \n", "C8 | \n", "83 | \n", "4 | \n", "100.000000 | \n", "400 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
1739 rows × 11 columns
\n", "