projects
/
ou-summer-of-code-2017.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Updated analysis for end of month winners
[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 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": [
"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",
"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 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": [
{
"data": {
"text/plain": [
- "<pymongo.results.DeleteResult at 0x7f
7700eba5a0
>"
+ "<pymongo.results.DeleteResult at 0x7f
648f16b168
>"
]
},
"execution_count": 8,
]
},
"execution_count": 8,
@@
-191,49
+196,49
@@
"output_type": "stream",
"text": [
"SUMMEROFCODE-Day 0 Warm up holiday prices-grades.csv\n",
"output_type": "stream",
"text": [
"SUMMEROFCODE-Day 0 Warm up holiday prices-grades.csv\n",
- "2017-0
7-30T19:43:58.575
+0100\tconnected to: localhost\n",
- "2017-0
7-30T19:43:58.575
+0100\tdropping: summerofcode.imp\n",
- "2017-0
7-30T19:43:58.592+0100\timported 292
documents\n",
+ "2017-0
8-01T10:27:51.256
+0100\tconnected to: localhost\n",
+ "2017-0
8-01T10:27:51.256
+0100\tdropping: summerofcode.imp\n",
+ "2017-0
8-01T10:27:51.285+0100\timported 293
documents\n",
"SUMMEROFCODE-Day 10 Word search-grades.csv\n",
"SUMMEROFCODE-Day 10 Word search-grades.csv\n",
- "2017-0
7-30T19:43:58.948
+0100\tconnected to: localhost\n",
- "2017-0
7-30T19:43:58.948
+0100\tdropping: summerofcode.imp\n",
- "2017-0
7-30T19:43:58.950+0100\timported 60
documents\n",
+ "2017-0
8-01T10:27:51.655
+0100\tconnected to: localhost\n",
+ "2017-0
8-01T10:27:51.655
+0100\tdropping: summerofcode.imp\n",
+ "2017-0
8-01T10:27:51.657+0100\timported 61
documents\n",
"SUMMEROFCODE-Day 1 Choosing a holiday-grades.csv\n",
"SUMMEROFCODE-Day 1 Choosing a holiday-grades.csv\n",
- "2017-0
7-30T19:43:59.1
21+0100\tconnected to: localhost\n",
- "2017-0
7-30T19:43:59.1
21+0100\tdropping: summerofcode.imp\n",
- "2017-0
7-30T19:43:59.1
24+0100\timported 153 documents\n",
+ "2017-0
8-01T10:27:51.8
21+0100\tconnected to: localhost\n",
+ "2017-0
8-01T10:27:51.8
21+0100\tdropping: summerofcode.imp\n",
+ "2017-0
8-01T10:27:51.8
24+0100\timported 153 documents\n",
"SUMMEROFCODE-Day 2 Lifts-grades.csv\n",
"SUMMEROFCODE-Day 2 Lifts-grades.csv\n",
- "2017-0
7-30T19:43:59.366
+0100\tconnected to: localhost\n",
- "2017-0
7-30T19:43:59.366
+0100\tdropping: summerofcode.imp\n",
- "2017-0
7-30T19:43:59.369+0100\timported 102
documents\n",
+ "2017-0
8-01T10:27:52.064
+0100\tconnected to: localhost\n",
+ "2017-0
8-01T10:27:52.064
+0100\tdropping: summerofcode.imp\n",
+ "2017-0
8-01T10:27:52.069+0100\timported 103
documents\n",
"SUMMEROFCODE-Day 3 Door codes-grades.csv\n",
"SUMMEROFCODE-Day 3 Door codes-grades.csv\n",
- "2017-0
7-30T19:43:59.569
+0100\tconnected to: localhost\n",
- "2017-0
7-30T19:43:59.569
+0100\tdropping: summerofcode.imp\n",
- "2017-0
7-30T19:43:59.571
+0100\timported 88 documents\n",
+ "2017-0
8-01T10:27:52.287
+0100\tconnected to: localhost\n",
+ "2017-0
8-01T10:27:52.287
+0100\tdropping: summerofcode.imp\n",
+ "2017-0
8-01T10:27:52.290
+0100\timported 88 documents\n",
"SUMMEROFCODE-Day 4 Beach labyrinth-grades.csv\n",
"SUMMEROFCODE-Day 4 Beach labyrinth-grades.csv\n",
- "2017-0
7-30T19:43:59.753
+0100\tconnected to: localhost\n",
- "2017-0
7-30T19:43:59.753
+0100\tdropping: summerofcode.imp\n",
- "2017-0
7-30T19:43:59.756
+0100\timported 97 documents\n",
+ "2017-0
8-01T10:27:52.485
+0100\tconnected to: localhost\n",
+ "2017-0
8-01T10:27:52.485
+0100\tdropping: summerofcode.imp\n",
+ "2017-0
8-01T10:27:52.488
+0100\timported 97 documents\n",
"SUMMEROFCODE-Day 5 Laser display boards-grades.csv\n",
"SUMMEROFCODE-Day 5 Laser display boards-grades.csv\n",
- "2017-0
7-30T19:43:59.960
+0100\tconnected to: localhost\n",
- "2017-0
7-30T19:43:59.960
+0100\tdropping: summerofcode.imp\n",
- "2017-0
7-30T19:43:59.963+0100\timported 76
documents\n",
+ "2017-0
8-01T10:27:52.693
+0100\tconnected to: localhost\n",
+ "2017-0
8-01T10:27:52.694
+0100\tdropping: summerofcode.imp\n",
+ "2017-0
8-01T10:27:52.696+0100\timported 77
documents\n",
"SUMMEROFCODE-Day 6 Tour guides-grades.csv\n",
"SUMMEROFCODE-Day 6 Tour guides-grades.csv\n",
- "2017-0
7-30T19:44:00.141
+0100\tconnected to: localhost\n",
- "2017-0
7-30T19:44:00.14
2+0100\tdropping: summerofcode.imp\n",
- "2017-0
7-30T19:44:00.144+0100\timported 98
documents\n",
+ "2017-0
8-01T10:27:52.882
+0100\tconnected to: localhost\n",
+ "2017-0
8-01T10:27:52.88
2+0100\tdropping: summerofcode.imp\n",
+ "2017-0
8-01T10:27:52.885+0100\timported 100
documents\n",
"SUMMEROFCODE-Day 7 Fixing the minibar-grades.csv\n",
"SUMMEROFCODE-Day 7 Fixing the minibar-grades.csv\n",
- "2017-0
7-30T19:44:00.337
+0100\tconnected to: localhost\n",
- "2017-0
7-30T19:44:00.337
+0100\tdropping: summerofcode.imp\n",
- "2017-0
7-30T19:44:00.339
+0100\timported 54 documents\n",
+ "2017-0
8-01T10:27:53.081
+0100\tconnected to: localhost\n",
+ "2017-0
8-01T10:27:53.081
+0100\tdropping: summerofcode.imp\n",
+ "2017-0
8-01T10:27:53.083
+0100\timported 54 documents\n",
"SUMMEROFCODE-Day 8 Visa woes-grades.csv\n",
"SUMMEROFCODE-Day 8 Visa woes-grades.csv\n",
- "2017-0
7-30T19:44:00.496
+0100\tconnected to: localhost\n",
- "2017-0
7-30T19:44:00.496
+0100\tdropping: summerofcode.imp\n",
- "2017-0
7-30T19:44:00.498+0100\timported 60
documents\n",
+ "2017-0
8-01T10:27:53.255
+0100\tconnected to: localhost\n",
+ "2017-0
8-01T10:27:53.255
+0100\tdropping: summerofcode.imp\n",
+ "2017-0
8-01T10:27:53.257+0100\timported 61
documents\n",
"SUMMEROFCODE-Day 9 Resolving the bill-grades.csv\n",
"SUMMEROFCODE-Day 9 Resolving the bill-grades.csv\n",
- "2017-0
7-30T19:44:00.660
+0100\tconnected to: localhost\n",
- "2017-0
7-30T19:44:00.660
+0100\tdropping: summerofcode.imp\n",
- "2017-0
7-30T19:44:00.66
2+0100\timported 42 documents\n"
+ "2017-0
8-01T10:27:53.421
+0100\tconnected to: localhost\n",
+ "2017-0
8-01T10:27:53.421
+0100\tdropping: summerofcode.imp\n",
+ "2017-0
8-01T10:27:53.42
2+0100\timported 42 documents\n"
]
}
],
]
}
],
@@
-256,7
+261,7
@@
{
"data": {
"text/plain": [
{
"data": {
"text/plain": [
- "111
1
"
+ "111
8
"
]
},
"execution_count": 10,
]
},
"execution_count": 10,
@@
-270,32
+275,33
@@
},
{
"cell_type": "code",
},
{
"cell_type": "code",
- "execution_count": 1
1
,
+ "execution_count": 1
2
,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"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': 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': 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': 7, 'count': 53},\n",
- " {'_id': 9, 'count': 41}]"
+ " {'_id': 8, 'count': 60},\n",
+ " {'_id': 9, 'count': 41},\n",
+ " {'_id': 10, 'count': 60}]"
]
},
]
},
- "execution_count": 1
1
,
+ "execution_count": 1
2
,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"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))"
]
},
"list(icmas.aggregate(pipeline))"
]
},