"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",
"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"
]
{
"data": {
"text/plain": [
- "<pymongo.results.DeleteResult at 0x7f7700eba5a0>"
+ "<pymongo.results.DeleteResult at 0x7f1909986c18>"
]
},
"execution_count": 8,
"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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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"
]
}
],
{
"data": {
"text/plain": [
- "1111"
+ "1131"
]
},
"execution_count": 10,
{
"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': 1, 'count': 152},\n",
- " {'_id': 5, 'count': 75},\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': 8, 'count': 59},\n",
+ " {'_id': 5, 'count': 76},\n",
+ " {'_id': 6, 'count': 100},\n",
" {'_id': 7, 'count': 53},\n",
- " {'_id': 9, 'count': 41}]"
+ " {'_id': 8, 'count': 60},\n",
+ " {'_id': 9, 'count': 41},\n",
+ " {'_id': 10, 'count': 63}]"
]
},
"execution_count": 11,
}
],
"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))"
]
},