Updated analysis for end of month winners

diff --git a/data-analysis/all-starts-hours.png b/data-analysis/all-starts-hours.png
index 1f5fb91b0eeb8e80612e78b2e7d72ac19a99368f..a9186c96e347fca8427be12562d253d97a2d1fb2 100644 (file)
Binary files a/data-analysis/all-starts-hours.png 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
index 035e9cd8ee274e3ade063c7a24e631d9915bd086..9ed05a11d82b008eb0056617a1eb189e788d13d1 100644 (file)
Binary files a/data-analysis/attempts-per-day.png and b/data-analysis/attempts-per-day.png differ

diff --git a/data-analysis/completion-hours.png b/data-analysis/completion-hours.png
index 6424bf1c7157d9b5748f5f2fc1e5e839c0ca38e0..33fb5d778ffdb0e3589fbd303388086a0259c3c2 100644 (file)
Binary files a/data-analysis/completion-hours.png and b/data-analysis/completion-hours.png differ

diff --git a/data-analysis/import-data.ipynb b/data-analysis/import-data.ipynb
index e9eb625679349e7331a424103f72fea2d2c7a7da..24c5691c597aa2a9f53b6a9bfcaab4f7fb661c2d 100644 (file)
--- a/data-analysis/import-data.ipynb
+++ b/data-analysis/import-data.ipynb
@@ -50,7 +50,12 @@
      "name": "stdout",
      "output_type": "stream",
      "text": [
+      "all-starts-hours.png\r\n",
+      "attempts-per-day.png\r\n",
+      "completion-hours.png\r\n",
       "import-data.ipynb\r\n",
+      "participated-in-days.png\r\n",
+      "scores-per-day.png\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",
@@ -169,7 +174,7 @@
     {
      "data": {
       "text/plain": [
-       "<pymongo.results.DeleteResult at 0x7f7700eba5a0>"
+       "<pymongo.results.DeleteResult at 0x7f648f16b168>"
       ]
      },
      "execution_count": 8,
@@ -191,49 +196,49 @@
      "output_type": "stream",
      "text": [
       "SUMMEROFCODE-Day 0 Warm up holiday prices-grades.csv\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",
+      "2017-08-01T10:27:51.256+0100\tconnected to: localhost\n",
+      "2017-08-01T10:27:51.256+0100\tdropping: summerofcode.imp\n",
+      "2017-08-01T10:27:51.285+0100\timported 293 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",
+      "2017-08-01T10:27:51.655+0100\tconnected to: localhost\n",
+      "2017-08-01T10:27:51.655+0100\tdropping: summerofcode.imp\n",
+      "2017-08-01T10:27:51.657+0100\timported 61 documents\n",
       "SUMMEROFCODE-Day 1 Choosing a holiday-grades.csv\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",
+      "2017-08-01T10:27:51.821+0100\tconnected to: localhost\n",
+      "2017-08-01T10:27:51.821+0100\tdropping: summerofcode.imp\n",
+      "2017-08-01T10:27:51.824+0100\timported 153 documents\n",
       "SUMMEROFCODE-Day 2 Lifts-grades.csv\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",
+      "2017-08-01T10:27:52.064+0100\tconnected to: localhost\n",
+      "2017-08-01T10:27:52.064+0100\tdropping: summerofcode.imp\n",
+      "2017-08-01T10:27:52.069+0100\timported 103 documents\n",
       "SUMMEROFCODE-Day 3 Door codes-grades.csv\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",
+      "2017-08-01T10:27:52.287+0100\tconnected to: localhost\n",
+      "2017-08-01T10:27:52.287+0100\tdropping: summerofcode.imp\n",
+      "2017-08-01T10:27:52.290+0100\timported 88 documents\n",
       "SUMMEROFCODE-Day 4 Beach labyrinth-grades.csv\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",
+      "2017-08-01T10:27:52.485+0100\tconnected to: localhost\n",
+      "2017-08-01T10:27:52.485+0100\tdropping: summerofcode.imp\n",
+      "2017-08-01T10:27:52.488+0100\timported 97 documents\n",
       "SUMMEROFCODE-Day 5 Laser display boards-grades.csv\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",
+      "2017-08-01T10:27:52.693+0100\tconnected to: localhost\n",
+      "2017-08-01T10:27:52.694+0100\tdropping: summerofcode.imp\n",
+      "2017-08-01T10:27:52.696+0100\timported 77 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",
+      "2017-08-01T10:27:52.882+0100\tconnected to: localhost\n",
+      "2017-08-01T10:27:52.882+0100\tdropping: summerofcode.imp\n",
+      "2017-08-01T10:27:52.885+0100\timported 100 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",
+      "2017-08-01T10:27:53.081+0100\tconnected to: localhost\n",
+      "2017-08-01T10:27:53.081+0100\tdropping: summerofcode.imp\n",
+      "2017-08-01T10:27:53.083+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",
+      "2017-08-01T10:27:53.255+0100\tconnected to: localhost\n",
+      "2017-08-01T10:27:53.255+0100\tdropping: summerofcode.imp\n",
+      "2017-08-01T10:27:53.257+0100\timported 61 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"
+      "2017-08-01T10:27:53.421+0100\tconnected to: localhost\n",
+      "2017-08-01T10:27:53.421+0100\tdropping: summerofcode.imp\n",
+      "2017-08-01T10:27:53.422+0100\timported 42 documents\n"
      ]
     }
    ],
@@ -256,7 +261,7 @@
     {
      "data": {
       "text/plain": [
-       "1111"
+       "1118"
       ]
      },
      "execution_count": 10,
@@ -270,32 +275,33 @@
   },
   {
    "cell_type": "code",
-   "execution_count": 11,
+   "execution_count": 12,
    "metadata": {},
    "outputs": [
     {
      "data": {
       "text/plain": [
-       "[{'_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': 0, 'count': 292},\n",
        " {'_id': 1, 'count': 152},\n",
-       " {'_id': 5, 'count': 75},\n",
+       " {'_id': 2, 'count': 102},\n",
+       " {'_id': 3, 'count': 87},\n",
        " {'_id': 4, 'count': 96},\n",
-       " {'_id': 8, 'count': 59},\n",
+       " {'_id': 5, 'count': 76},\n",
+       " {'_id': 6, 'count': 99},\n",
        " {'_id': 7, 'count': 53},\n",
-       " {'_id': 9, 'count': 41}]"
+       " {'_id': 8, 'count': 60},\n",
+       " {'_id': 9, 'count': 41},\n",
+       " {'_id': 10, 'count': 60}]"
       ]
      },
-     "execution_count": 11,
+     "execution_count": 12,
      "metadata": {},
      "output_type": "execute_result"
     }
    ],
    "source": [
-    "pipeline = [{\"$group\": {\"_id\": \"$icma_number\", \"count\": {\"$sum\": 1}}}]\n",
+    "pipeline = [{\"$group\": {\"_id\": \"$icma_number\", \"count\": {\"$sum\": 1}}},\n",
+    "            {'$sort': {'_id': 1}}]\n",
     "list(icmas.aggregate(pipeline))"
    ]
   },

diff --git a/data-analysis/participated-in-days.png b/data-analysis/participated-in-days.png
index 5e7b1b14daad29743f0be2ead1889dcc66bc29f4..b571aa62fecf84aff916594159468bd5c786857b 100644 (file)
Binary files a/data-analysis/participated-in-days.png 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
index 8b5cb3ddd42ce899051f926eb92dcfb6e91fc12d..262a978a031ffc3132102a8a6a5acdd2ee931094 100644 (file)
Binary files a/data-analysis/scores-per-day.png and b/data-analysis/scores-per-day.png differ