From: Neil Smith Date: Mon, 31 Jul 2017 09:01:49 +0000 (+0100) Subject: Added data analysis after day 10 X-Git-Url: https://git.njae.me.uk/?p=ou-summer-of-code-2017.git;a=commitdiff_plain;h=8ffdd4c5207fe821366ff6a6dc47742dc30f51c4 Added data analysis after day 10 --- diff --git a/data-analysis/all-starts-hours.png b/data-analysis/all-starts-hours.png new file mode 100644 index 0000000..1f5fb91 Binary files /dev/null and b/data-analysis/all-starts-hours.png differ diff --git a/data-analysis/attempts-per-day.png b/data-analysis/attempts-per-day.png new file mode 100644 index 0000000..035e9cd Binary files /dev/null and b/data-analysis/attempts-per-day.png differ diff --git a/data-analysis/completion-hours.png b/data-analysis/completion-hours.png new file mode 100644 index 0000000..6424bf1 Binary files /dev/null and b/data-analysis/completion-hours.png differ diff --git a/data-analysis/import-data.ipynb b/data-analysis/import-data.ipynb index da7863e..e9eb625 100644 --- a/data-analysis/import-data.ipynb +++ b/data-analysis/import-data.ipynb @@ -2,8 +2,10 @@ "cells": [ { "cell_type": "code", - "execution_count": 20, - "metadata": {}, + "execution_count": 1, + "metadata": { + "collapsed": true + }, "outputs": [], "source": [ "# Import the required libraries and open the connection to Mongo\n", @@ -27,7 +29,7 @@ }, { "cell_type": "code", - "execution_count": 141, + "execution_count": 2, "metadata": { "collapsed": true }, @@ -41,25 +43,29 @@ }, { "cell_type": "code", - "execution_count": 139, + "execution_count": 3, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ - "14.1 Basic CRUD.ipynb\r\n", - "2016J_TMA01_q1-TN.ipynb\r\n", - "2016J_TMA01_q2-withTN.ipynb\r\n", - "import-data-Copy1.ipynb\r\n", "import-data.ipynb\r\n", "SUMMEROFCODE-Day 0 Warm up holiday prices-grades.csv\r\n", + "SUMMEROFCODE-Day 10 Word search-grades.csv\r\n", "SUMMEROFCODE-Day 1 Choosing a holiday-grades.csv\r\n", "SUMMEROFCODE-Day 2 Lifts-grades.csv\r\n", "SUMMEROFCODE-Day 3 Door codes-grades.csv\r\n", "SUMMEROFCODE-Day 4 Beach labyrinth-grades.csv\r\n", "SUMMEROFCODE-Day 5 Laser display boards-grades.csv\r\n", - "TMA01_Question3_Solutions.ipynb\r\n" + "SUMMEROFCODE-Day 6 Tour guides-grades.csv\r\n", + "SUMMEROFCODE-Day 7 Fixing the minibar-grades.csv\r\n", + "SUMMEROFCODE-Day 8 Visa woes-grades.csv\r\n", + "SUMMEROFCODE-Day 9 Resolving the bill-grades.csv\r\n", + "survey-email_1.csv\r\n", + "survey-email.csv\r\n", + "task-analysis.ipynb\r\n", + "winners.ipynb\r\n" ] } ], @@ -69,33 +75,7 @@ }, { "cell_type": "code", - "execution_count": 102, - "metadata": {}, - "outputs": [ - { - "data": { - "text/plain": [ - "['SUMMEROFCODE-Day 0 Warm up holiday prices-grades.csv',\n", - " 'SUMMEROFCODE-Day 1 Choosing a holiday-grades.csv',\n", - " 'SUMMEROFCODE-Day 2 Lifts-grades.csv',\n", - " 'SUMMEROFCODE-Day 3 Door codes-grades.csv',\n", - " 'SUMMEROFCODE-Day 4 Beach labyrinth-grades.csv',\n", - " 'SUMMEROFCODE-Day 5 Laser display boards-grades.csv']" - ] - }, - "execution_count": 102, - "metadata": {}, - "output_type": "execute_result" - } - ], - "source": [ - "csvs = !ls *csv\n", - "csvs" - ] - }, - { - "cell_type": "code", - "execution_count": 114, + "execution_count": 4, "metadata": { "collapsed": true }, @@ -112,8 +92,10 @@ }, { "cell_type": "code", - "execution_count": 109, - "metadata": {}, + "execution_count": 5, + "metadata": { + "collapsed": true + }, "outputs": [], "source": [ "def update_dates():\n", @@ -133,7 +115,7 @@ }, { "cell_type": "code", - "execution_count": 110, + "execution_count": 6, "metadata": { "collapsed": true }, @@ -150,42 +132,47 @@ }, { "cell_type": "code", - "execution_count": 111, + "execution_count": 7, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['SUMMEROFCODE-Day 0 Warm up holiday prices-grades.csv',\n", + " 'SUMMEROFCODE-Day 10 Word search-grades.csv',\n", " 'SUMMEROFCODE-Day 1 Choosing a holiday-grades.csv',\n", " 'SUMMEROFCODE-Day 2 Lifts-grades.csv',\n", " 'SUMMEROFCODE-Day 3 Door codes-grades.csv',\n", " 'SUMMEROFCODE-Day 4 Beach labyrinth-grades.csv',\n", - " 'SUMMEROFCODE-Day 5 Laser display boards-grades.csv']" + " 'SUMMEROFCODE-Day 5 Laser display boards-grades.csv',\n", + " 'SUMMEROFCODE-Day 6 Tour guides-grades.csv',\n", + " 'SUMMEROFCODE-Day 7 Fixing the minibar-grades.csv',\n", + " 'SUMMEROFCODE-Day 8 Visa woes-grades.csv',\n", + " 'SUMMEROFCODE-Day 9 Resolving the bill-grades.csv']" ] }, - "execution_count": 111, + "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ - "csvs = !ls *csv\n", + "csvs = !ls SUMMEROFCODE*csv\n", "csvs" ] }, { "cell_type": "code", - "execution_count": 123, + "execution_count": 8, "metadata": {}, "outputs": [ { "data": { "text/plain": [ - "" + "" ] }, - "execution_count": 123, + "execution_count": 8, "metadata": {}, "output_type": "execute_result" } @@ -196,7 +183,7 @@ }, { "cell_type": "code", - "execution_count": 132, + "execution_count": 9, "metadata": {}, "outputs": [ { @@ -204,29 +191,49 @@ "output_type": "stream", "text": [ "SUMMEROFCODE-Day 0 Warm up holiday prices-grades.csv\n", - "2017-07-22T15:24:32.622+0100\tconnected to: localhost\n", - "2017-07-22T15:24:32.622+0100\tdropping: summerofcode.imp\n", - "2017-07-22T15:24:32.629+0100\timported 285 documents\n", + "2017-07-30T19:43:58.575+0100\tconnected to: localhost\n", + "2017-07-30T19:43:58.575+0100\tdropping: summerofcode.imp\n", + "2017-07-30T19:43:58.592+0100\timported 292 documents\n", + "SUMMEROFCODE-Day 10 Word search-grades.csv\n", + "2017-07-30T19:43:58.948+0100\tconnected to: localhost\n", + "2017-07-30T19:43:58.948+0100\tdropping: summerofcode.imp\n", + "2017-07-30T19:43:58.950+0100\timported 60 documents\n", "SUMMEROFCODE-Day 1 Choosing a holiday-grades.csv\n", - "2017-07-22T15:24:32.971+0100\tconnected to: localhost\n", - "2017-07-22T15:24:32.971+0100\tdropping: summerofcode.imp\n", - "2017-07-22T15:24:32.974+0100\timported 137 documents\n", + "2017-07-30T19:43:59.121+0100\tconnected to: localhost\n", + "2017-07-30T19:43:59.121+0100\tdropping: summerofcode.imp\n", + "2017-07-30T19:43:59.124+0100\timported 153 documents\n", "SUMMEROFCODE-Day 2 Lifts-grades.csv\n", - "2017-07-22T15:24:33.202+0100\tconnected to: localhost\n", - "2017-07-22T15:24:33.202+0100\tdropping: summerofcode.imp\n", - "2017-07-22T15:24:33.204+0100\timported 92 documents\n", + "2017-07-30T19:43:59.366+0100\tconnected to: localhost\n", + "2017-07-30T19:43:59.366+0100\tdropping: summerofcode.imp\n", + "2017-07-30T19:43:59.369+0100\timported 102 documents\n", "SUMMEROFCODE-Day 3 Door codes-grades.csv\n", - "2017-07-22T15:24:33.394+0100\tconnected to: localhost\n", - "2017-07-22T15:24:33.394+0100\tdropping: summerofcode.imp\n", - "2017-07-22T15:24:33.396+0100\timported 77 documents\n", + "2017-07-30T19:43:59.569+0100\tconnected to: localhost\n", + "2017-07-30T19:43:59.569+0100\tdropping: summerofcode.imp\n", + "2017-07-30T19:43:59.571+0100\timported 88 documents\n", "SUMMEROFCODE-Day 4 Beach labyrinth-grades.csv\n", - "2017-07-22T15:24:33.573+0100\tconnected to: localhost\n", - "2017-07-22T15:24:33.573+0100\tdropping: summerofcode.imp\n", - "2017-07-22T15:24:33.575+0100\timported 79 documents\n", + "2017-07-30T19:43:59.753+0100\tconnected to: localhost\n", + "2017-07-30T19:43:59.753+0100\tdropping: summerofcode.imp\n", + "2017-07-30T19:43:59.756+0100\timported 97 documents\n", "SUMMEROFCODE-Day 5 Laser display boards-grades.csv\n", - "2017-07-22T15:24:33.753+0100\tconnected to: localhost\n", - "2017-07-22T15:24:33.753+0100\tdropping: summerofcode.imp\n", - "2017-07-22T15:24:33.755+0100\timported 57 documents\n" + "2017-07-30T19:43:59.960+0100\tconnected to: localhost\n", + "2017-07-30T19:43:59.960+0100\tdropping: summerofcode.imp\n", + "2017-07-30T19:43:59.963+0100\timported 76 documents\n", + "SUMMEROFCODE-Day 6 Tour guides-grades.csv\n", + "2017-07-30T19:44:00.141+0100\tconnected to: localhost\n", + "2017-07-30T19:44:00.142+0100\tdropping: summerofcode.imp\n", + "2017-07-30T19:44:00.144+0100\timported 98 documents\n", + "SUMMEROFCODE-Day 7 Fixing the minibar-grades.csv\n", + "2017-07-30T19:44:00.337+0100\tconnected to: localhost\n", + "2017-07-30T19:44:00.337+0100\tdropping: summerofcode.imp\n", + "2017-07-30T19:44:00.339+0100\timported 54 documents\n", + "SUMMEROFCODE-Day 8 Visa woes-grades.csv\n", + "2017-07-30T19:44:00.496+0100\tconnected to: localhost\n", + "2017-07-30T19:44:00.496+0100\tdropping: summerofcode.imp\n", + "2017-07-30T19:44:00.498+0100\timported 60 documents\n", + "SUMMEROFCODE-Day 9 Resolving the bill-grades.csv\n", + "2017-07-30T19:44:00.660+0100\tconnected to: localhost\n", + "2017-07-30T19:44:00.660+0100\tdropping: summerofcode.imp\n", + "2017-07-30T19:44:00.662+0100\timported 42 documents\n" ] } ], @@ -243,16 +250,16 @@ }, { "cell_type": "code", - "execution_count": 134, + "execution_count": 10, "metadata": {}, "outputs": [ { "data": { "text/plain": [ - "721" + "1111" ] }, - "execution_count": 134, + "execution_count": 10, "metadata": {}, "output_type": "execute_result" } @@ -263,21 +270,26 @@ }, { "cell_type": "code", - "execution_count": 138, + "execution_count": 11, "metadata": {}, "outputs": [ { "data": { "text/plain": [ - "[{'_id': 3, 'count': 76},\n", - " {'_id': 2, 'count': 91},\n", - " {'_id': 5, 'count': 56},\n", - " {'_id': 4, 'count': 78},\n", - " {'_id': 1, 'count': 136},\n", - " {'_id': 0, 'count': 284}]" + "[{'_id': 3, 'count': 87},\n", + " {'_id': 2, 'count': 101},\n", + " {'_id': 10, 'count': 59},\n", + " {'_id': 0, 'count': 291},\n", + " {'_id': 6, 'count': 97},\n", + " {'_id': 1, 'count': 152},\n", + " {'_id': 5, 'count': 75},\n", + " {'_id': 4, 'count': 96},\n", + " {'_id': 8, 'count': 59},\n", + " {'_id': 7, 'count': 53},\n", + " {'_id': 9, 'count': 41}]" ] }, - "execution_count": 138, + "execution_count": 11, "metadata": {}, "output_type": "execute_result" } diff --git a/data-analysis/participated-in-days.png b/data-analysis/participated-in-days.png new file mode 100644 index 0000000..5e7b1b1 Binary files /dev/null and b/data-analysis/participated-in-days.png differ diff --git a/data-analysis/scores-per-day.png b/data-analysis/scores-per-day.png new file mode 100644 index 0000000..8b5cb3d Binary files /dev/null and b/data-analysis/scores-per-day.png differ