"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",
},
{
"cell_type": "code",
- "execution_count": 141,
+ "execution_count": 2,
"metadata": {
"collapsed": true
},
},
{
"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",
+ "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",
"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",
+ "task-analysis.ipynb\r\n",
+ "winners.ipynb\r\n"
]
}
],
},
{
"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
},
},
{
"cell_type": "code",
- "execution_count": 109,
- "metadata": {},
+ "execution_count": 5,
+ "metadata": {
+ "collapsed": true
+ },
"outputs": [],
"source": [
"def update_dates():\n",
},
{
"cell_type": "code",
- "execution_count": 110,
+ "execution_count": 6,
"metadata": {
"collapsed": true
},
},
{
"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": [
- "<pymongo.results.DeleteResult at 0x7f3f2249fca8>"
+ "<pymongo.results.DeleteResult at 0x7f1909986c18>"
]
},
- "execution_count": 123,
+ "execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
},
{
"cell_type": "code",
- "execution_count": 132,
+ "execution_count": 9,
"metadata": {},
"outputs": [
{
"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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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"
]
}
],
},
{
"cell_type": "code",
- "execution_count": 134,
+ "execution_count": 10,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
- "721"
+ "1131"
]
},
- "execution_count": 134,
+ "execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
},
{
"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': 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': 100},\n",
+ " {'_id': 7, 'count': 53},\n",
+ " {'_id': 8, 'count': 60},\n",
+ " {'_id': 9, 'count': 41},\n",
+ " {'_id': 10, 'count': 63}]"
]
},
- "execution_count": 138,
+ "execution_count": 11,
"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))"
]
},
projects / ou-summer-of-code-2017.git / blobdiff