{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Example of Time-range 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", " | elapsed_minutes | \n", "start_of_range | \n", "end_of_range | \n", "userid | \n", "contentsid | \n", "pageno | \n", "ADD MARKER | \n", "ADD MEMO | \n", "ADD BOOKMARK | \n", "
---|---|---|---|---|---|---|---|---|---|
0 | \n", "1.0 | \n", "2018-04-17 14:50:00 | \n", "2018-04-17 14:51:00 | \n", "A_U1 | \n", "C1 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
1 | \n", "2.0 | \n", "2018-04-17 14:51:00 | \n", "2018-04-17 14:52:00 | \n", "A_U1 | \n", "C1 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
2 | \n", "3.0 | \n", "2018-04-17 14:52:00 | \n", "2018-04-17 14:53:00 | \n", "A_U1 | \n", "C1 | \n", "3 | \n", "0 | \n", "0 | \n", "0 | \n", "
3 | \n", "4.0 | \n", "2018-04-17 14:53:00 | \n", "2018-04-17 14:54:00 | \n", "A_U1 | \n", "C1 | \n", "3 | \n", "0 | \n", "0 | \n", "0 | \n", "
4 | \n", "5.0 | \n", "2018-04-17 14:54:00 | \n", "2018-04-17 14:55:00 | \n", "A_U1 | \n", "C1 | \n", "5 | \n", "0 | \n", "0 | \n", "0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
445 | \n", "86.0 | \n", "2018-04-17 16:15:00 | \n", "2018-04-17 16:16:00 | \n", "A_U102 | \n", "C1 | \n", "17 | \n", "0 | \n", "0 | \n", "0 | \n", "
446 | \n", "87.0 | \n", "2018-04-17 16:16:00 | \n", "2018-04-17 16:17:00 | \n", "A_U102 | \n", "C1 | \n", "17 | \n", "0 | \n", "0 | \n", "0 | \n", "
447 | \n", "88.0 | \n", "2018-04-17 16:17:00 | \n", "2018-04-17 16:18:00 | \n", "A_U102 | \n", "C1 | \n", "17 | \n", "0 | \n", "0 | \n", "0 | \n", "
448 | \n", "89.0 | \n", "2018-04-17 16:18:00 | \n", "2018-04-17 16:19:00 | \n", "A_U102 | \n", "C1 | \n", "17 | \n", "0 | \n", "0 | \n", "0 | \n", "
449 | \n", "90.0 | \n", "2018-04-17 16:19:00 | \n", "2018-04-17 16:20:00 | \n", "A_U102 | \n", "C1 | \n", "17 | \n", "0 | \n", "0 | \n", "0 | \n", "
450 rows × 9 columns
\n", "