Updated data

[ou-summer-of-code-2017.git] / data-analysis / import-data.ipynb

diff --git a/data-analysis/import-data.ipynb b/data-analysis/import-data.ipynb
index 24c5691c597aa2a9f53b6a9bfcaab4f7fb661c2d..c532378a30d8cae9afc26cb943f9a56d915002b1 100644 (file)
--- a/data-analysis/import-data.ipynb
+++ b/data-analysis/import-data.ipynb
@@ -67,8 +67,6 @@
       "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"
      ]
@@ -174,7 +172,7 @@
     {
      "data": {
       "text/plain": [
-       "<pymongo.results.DeleteResult at 0x7f648f16b168>"
+       "<pymongo.results.DeleteResult at 0x7f1909986c18>"
       ]
      },
      "execution_count": 8,
@@ -196,49 +194,49 @@
      "output_type": "stream",
      "text": [
       "SUMMEROFCODE-Day 0 Warm up holiday prices-grades.csv\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",
+      "2017-08-07T10:55:24.121+0100\tconnected to: localhost\n",
+      "2017-08-07T10:55:24.121+0100\tdropping: summerofcode.imp\n",
+      "2017-08-07T10:55:24.190+0100\timported 294 documents\n",
       "SUMMEROFCODE-Day 10 Word search-grades.csv\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",
+      "2017-08-07T10:55:24.567+0100\tconnected to: localhost\n",
+      "2017-08-07T10:55:24.567+0100\tdropping: summerofcode.imp\n",
+      "2017-08-07T10:55:24.577+0100\timported 64 documents\n",
       "SUMMEROFCODE-Day 1 Choosing a holiday-grades.csv\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",
+      "2017-08-07T10:55:24.746+0100\tconnected to: localhost\n",
+      "2017-08-07T10:55:24.746+0100\tdropping: summerofcode.imp\n",
+      "2017-08-07T10:55:24.751+0100\timported 158 documents\n",
       "SUMMEROFCODE-Day 2 Lifts-grades.csv\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",
+      "2017-08-07T10:55:24.990+0100\tconnected to: localhost\n",
+      "2017-08-07T10:55:24.990+0100\tdropping: summerofcode.imp\n",
+      "2017-08-07T10:55:24.993+0100\timported 105 documents\n",
       "SUMMEROFCODE-Day 3 Door codes-grades.csv\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",
+      "2017-08-07T10:55:25.187+0100\tconnected to: localhost\n",
+      "2017-08-07T10:55:25.187+0100\tdropping: summerofcode.imp\n",
+      "2017-08-07T10:55:25.198+0100\timported 89 documents\n",
       "SUMMEROFCODE-Day 4 Beach labyrinth-grades.csv\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",
+      "2017-08-07T10:55:25.381+0100\tconnected to: localhost\n",
+      "2017-08-07T10:55:25.381+0100\tdropping: summerofcode.imp\n",
+      "2017-08-07T10:55:25.383+0100\timported 97 documents\n",
       "SUMMEROFCODE-Day 5 Laser display boards-grades.csv\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",
+      "2017-08-07T10:55:25.571+0100\tconnected to: localhost\n",
+      "2017-08-07T10:55:25.571+0100\tdropping: summerofcode.imp\n",
+      "2017-08-07T10:55:25.573+0100\timported 77 documents\n",
       "SUMMEROFCODE-Day 6 Tour guides-grades.csv\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",
+      "2017-08-07T10:55:25.743+0100\tconnected to: localhost\n",
+      "2017-08-07T10:55:25.744+0100\tdropping: summerofcode.imp\n",
+      "2017-08-07T10:55:25.746+0100\timported 101 documents\n",
       "SUMMEROFCODE-Day 7 Fixing the minibar-grades.csv\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",
+      "2017-08-07T10:55:25.955+0100\tconnected to: localhost\n",
+      "2017-08-07T10:55:25.955+0100\tdropping: summerofcode.imp\n",
+      "2017-08-07T10:55:25.956+0100\timported 54 documents\n",
       "SUMMEROFCODE-Day 8 Visa woes-grades.csv\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",
+      "2017-08-07T10:55:26.126+0100\tconnected to: localhost\n",
+      "2017-08-07T10:55:26.126+0100\tdropping: summerofcode.imp\n",
+      "2017-08-07T10:55:26.128+0100\timported 61 documents\n",
       "SUMMEROFCODE-Day 9 Resolving the bill-grades.csv\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"
+      "2017-08-07T10:55:26.302+0100\tconnected to: localhost\n",
+      "2017-08-07T10:55:26.302+0100\tdropping: summerofcode.imp\n",
+      "2017-08-07T10:55:26.303+0100\timported 42 documents\n"
      ]
     }
    ],
@@ -261,7 +259,7 @@
     {
      "data": {
       "text/plain": [
-       "1118"
+       "1131"
       ]
      },
      "execution_count": 10,
@@ -275,26 +273,26 @@
   },
   {
    "cell_type": "code",
-   "execution_count": 12,
+   "execution_count": 11,
    "metadata": {},
    "outputs": [
     {
      "data": {
       "text/plain": [
-       "[{'_id': 0, 'count': 292},\n",
-       " {'_id': 1, 'count': 152},\n",
-       " {'_id': 2, 'count': 102},\n",
-       " {'_id': 3, 'count': 87},\n",
+       "[{'_id': 0, 'count': 293},\n",
+       " {'_id': 1, 'count': 157},\n",
+       " {'_id': 2, 'count': 104},\n",
+       " {'_id': 3, 'count': 88},\n",
        " {'_id': 4, 'count': 96},\n",
        " {'_id': 5, 'count': 76},\n",
-       " {'_id': 6, 'count': 99},\n",
+       " {'_id': 6, 'count': 100},\n",
        " {'_id': 7, 'count': 53},\n",
        " {'_id': 8, 'count': 60},\n",
        " {'_id': 9, 'count': 41},\n",
-       " {'_id': 10, 'count': 60}]"
+       " {'_id': 10, 'count': 63}]"
       ]
      },
-     "execution_count": 12,
+     "execution_count": 11,
      "metadata": {},
      "output_type": "execute_result"
     }