"
],
"text/plain": [
" 0 \\\n",
"0 Data on Pupils attending post primary schools ... \n",
"1 NaN \n",
"2 NaN \n",
"3 DE ref \n",
"4 1210014 \n",
"\n",
" 1 2 3 4 5 \\\n",
"0 NaN NaN NaN NaN NaN \n",
"1 NaN NaN NaN NaN NaN \n",
"2 NaN year of enrolment NaN NaN NaN \n",
"3 Schoolname year 8 year 9 year 10 year 11 \n",
"4 Ashfield Girls' High School 124 114 119 111 \n",
"\n",
" 6 7 8 9 \n",
"0 NaN NaN NaN NaN \n",
"1 NaN NaN NaN NaN \n",
"2 NaN NaN NaN NaN \n",
"3 year 12 year 13 year 14 total pupils \n",
"4 113 60 50 691 "
]
},
"execution_count": 72,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"xls = pd.ExcelFile(f'data/education-ni/2017/School%20level%20-%20post%20primary%20schools%20data%20supp%201718.xls')\n",
"df = pd.read_excel(xls, 'enrolments', header=None)\n",
"df.head()"
]
},
{
"cell_type": "code",
"execution_count": 73,
"metadata": {
"ExecuteTime": {
"end_time": "2018-06-07T10:38:41.099926Z",
"start_time": "2018-06-07T10:38:41.051310Z"
}
},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
"
\n",
"
\n",
"
de ref
\n",
"
schoolname
\n",
"
year of enrolment year 8
\n",
"
year 9
\n",
"
year 10
\n",
"
year 11
\n",
"
year 12
\n",
"
year 13
\n",
"
year 14
\n",
"
total pupils
\n",
"
\n",
" \n",
" \n",
"
\n",
"
0
\n",
"
1210014
\n",
"
Ashfield Girls' High School
\n",
"
124
\n",
"
114
\n",
"
119
\n",
"
111
\n",
"
113
\n",
"
60
\n",
"
50
\n",
"
691
\n",
"
\n",
"
\n",
"
1
\n",
"
1210015
\n",
"
Ashfield Boys' High School
\n",
"
126
\n",
"
121
\n",
"
117
\n",
"
121
\n",
"
111
\n",
"
84
\n",
"
60
\n",
"
740
\n",
"
\n",
"
\n",
"
2
\n",
"
1210021
\n",
"
Belfast Model School For Girls
\n",
"
167
\n",
"
160
\n",
"
162
\n",
"
139
\n",
"
121
\n",
"
127
\n",
"
70
\n",
"
946
\n",
"
\n",
"
\n",
"
3
\n",
"
1210022
\n",
"
Belfast Boys' Model School
\n",
"
174
\n",
"
179
\n",
"
165
\n",
"
154
\n",
"
160
\n",
"
89
\n",
"
76
\n",
"
997
\n",
"
\n",
"
\n",
"
4
\n",
"
1230053
\n",
"
St Louise's Comprehensive College
\n",
"
236
\n",
"
194
\n",
"
189
\n",
"
206
\n",
"
264
\n",
"
160
\n",
"
186
\n",
"
1435
\n",
"
\n",
"
\n",
"
5
\n",
"
1230104
\n",
"
Mercy College Belfast
\n",
"
76
\n",
"
66
\n",
"
71
\n",
"
76
\n",
"
73
\n",
"
71
\n",
"
17
\n",
"
450
\n",
"
\n",
"
\n",
"
6
\n",
"
1230130
\n",
"
St Rose’s Dominican College
\n",
"
16
\n",
"
25
\n",
"
32
\n",
"
37
\n",
"
37
\n",
"
72
\n",
"
24
\n",
"
243
\n",
"
\n",
"
\n",
"
7
\n",
"
1230146
\n",
"
Christian Brothers School, Belfast
\n",
"
107
\n",
"
70
\n",
"
95
\n",
"
47
\n",
"
40
\n",
"
87
\n",
"
79
\n",
"
525
\n",
"
\n",
"
\n",
"
8
\n",
"
1230155
\n",
"
St Genevieve's High School
\n",
"
164
\n",
"
161
\n",
"
152
\n",
"
152
\n",
"
165
\n",
"
138
\n",
"
90
\n",
"
1022
\n",
"
\n",
"
\n",
"
9
\n",
"
1230182
\n",
"
De La Salle College
\n",
"
109
\n",
"
165
\n",
"
164
\n",
"
161
\n",
"
173
\n",
"
119
\n",
"
67
\n",
"
958
\n",
"
\n",
"
\n",
"
10
\n",
"
1230262
\n",
"
Corpus Christi College
\n",
"
24
\n",
"
23
\n",
"
45
\n",
"
40
\n",
"
38
\n",
"
37
\n",
"
26
\n",
"
233
\n",
"
\n",
"
\n",
"
11
\n",
"
1230275
\n",
"
St Joseph's College, Belfast
\n",
"
123
\n",
"
112
\n",
"
125
\n",
"
111
\n",
"
104
\n",
"
47
\n",
"
36
\n",
"
658
\n",
"
\n",
"
\n",
"
12
\n",
"
1230321
\n",
"
Blessed Trinity College
\n",
"
204
\n",
"
204
\n",
"
216
\n",
"
178
\n",
"
191
\n",
"
189
\n",
"
89
\n",
"
1271
\n",
"
\n",
"
\n",
"
13
\n",
"
1240291
\n",
"
Colaiste Feirste
\n",
"
102
\n",
"
119
\n",
"
102
\n",
"
112
\n",
"
97
\n",
"
71
\n",
"
48
\n",
"
651
\n",
"
\n",
"
\n",
"
14
\n",
"
1260269
\n",
"
Hazelwood College
\n",
"
170
\n",
"
171
\n",
"
153
\n",
"
147
\n",
"
144
\n",
"
94
\n",
"
75
\n",
"
954
\n",
"
\n",
"
\n",
"
15
\n",
"
1260294
\n",
"
Malone Integrated College
\n",
"
69
\n",
"
69
\n",
"
88
\n",
"
63
\n",
"
85
\n",
"
74
\n",
"
37
\n",
"
485
\n",
"
\n",
"
\n",
"
16
\n",
"
1410079
\n",
"
Grosvenor Grammar School
\n",
"
160
\n",
"
158
\n",
"
162
\n",
"
163
\n",
"
154
\n",
"
150
\n",
"
133
\n",
"
1080
\n",
"
\n",
"
\n",
"
17
\n",
"
1410270
\n",
"
Wellington College
\n",
"
112
\n",
"
119
\n",
"
114
\n",
"
117
\n",
"
122
\n",
"
85
\n",
"
73
\n",
"
742
\n",
"
\n",
"
\n",
"
18
\n",
"
1410315
\n",
"
Bloomfield Collegiate
\n",
"
101
\n",
"
110
\n",
"
101
\n",
"
110
\n",
"
107
\n",
"
93
\n",
"
78
\n",
"
700
\n",
"
\n",
"
\n",
"
19
\n",
"
1420020
\n",
"
Campbell College
\n",
"
134
\n",
"
143
\n",
"
147
\n",
"
148
\n",
"
147
\n",
"
96
\n",
"
107
\n",
"
922
\n",
"
\n",
"
\n",
"
20
\n",
"
1420021
\n",
"
St Mary's Christian Brothers' Grammar, Belfast
\n",
"
178
\n",
"
185
\n",
"
182
\n",
"
174
\n",
"
165
\n",
"
157
\n",
"
124
\n",
"
1165
\n",
"
\n",
"
\n",
"
21
\n",
"
1420022
\n",
"
Methodist College
\n",
"
241
\n",
"
247
\n",
"
256
\n",
"
255
\n",
"
253
\n",
"
266
\n",
"
258
\n",
"
1776
\n",
"
\n",
"
\n",
"
22
\n",
"
1420027
\n",
"
The Royal Belfast Academical Institution
\n",
"
152
\n",
"
160
\n",
"
160
\n",
"
164
\n",
"
146
\n",
"
114
\n",
"
116
\n",
"
1012
\n",
"
\n",
"
\n",
"
23
\n",
"
1420028
\n",
"
Belfast Royal Academy
\n",
"
207
\n",
"
211
\n",
"
209
\n",
"
216
\n",
"
209
\n",
"
221
\n",
"
188
\n",
"
1461
\n",
"
\n",
"
\n",
"
24
\n",
"
1420029
\n",
"
St Dominic's High School, Belfast
\n",
"
141
\n",
"
147
\n",
"
145
\n",
"
144
\n",
"
156
\n",
"
149
\n",
"
130
\n",
"
1012
\n",
"
\n",
"
\n",
"
25
\n",
"
1420030
\n",
"
St Malachy's College, Belfast
\n",
"
159
\n",
"
161
\n",
"
165
\n",
"
171
\n",
"
166
\n",
"
151
\n",
"
121
\n",
"
1094
\n",
"
\n",
"
\n",
"
26
\n",
"
1420082
\n",
"
Dominican College, Belfast
\n",
"
152
\n",
"
148
\n",
"
151
\n",
"
153
\n",
"
147
\n",
"
152
\n",
"
98
\n",
"
1001
\n",
"
\n",
"
\n",
"
27
\n",
"
1420089
\n",
"
Strathearn School, Belfast
\n",
"
111
\n",
"
116
\n",
"
121
\n",
"
110
\n",
"
111
\n",
"
103
\n",
"
106
\n",
"
778
\n",
"
\n",
"
\n",
"
28
\n",
"
1420095
\n",
"
Rathmore Grammar School
\n",
"
184
\n",
"
186
\n",
"
186
\n",
"
186
\n",
"
184
\n",
"
183
\n",
"
161
\n",
"
1270
\n",
"
\n",
"
\n",
"
29
\n",
"
1420264
\n",
"
Victoria College
\n",
"
132
\n",
"
138
\n",
"
141
\n",
"
136
\n",
"
127
\n",
"
120
\n",
"
103
\n",
"
897
\n",
"
\n",
"
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
\n",
"
\n",
"
178
\n",
"
5230218
\n",
"
St Catherine's College
\n",
"
173
\n",
"
173
\n",
"
159
\n",
"
157
\n",
"
189
\n",
"
125
\n",
"
128
\n",
"
1104
\n",
"
\n",
"
\n",
"
179
\n",
"
5230278
\n",
"
Holy Trinity College
\n",
"
159
\n",
"
163
\n",
"
171
\n",
"
169
\n",
"
160
\n",
"
112
\n",
"
87
\n",
"
1021
\n",
"
\n",
"
\n",
"
180
\n",
"
5230293
\n",
"
St Patrick's College, Dungannon
\n",
"
106
\n",
"
109
\n",
"
98
\n",
"
92
\n",
"
101
\n",
"
49
\n",
"
35
\n",
"
590
\n",
"
\n",
"
\n",
"
181
\n",
"
5230321
\n",
"
St John The Baptist College
\n",
"
77
\n",
"
50
\n",
"
37
\n",
"
5
\n",
"
1
\n",
"
0
\n",
"
0
\n",
"
170
\n",
"
\n",
"
\n",
"
182
\n",
"
5250216
\n",
"
Brownlow Int College
\n",
"
62
\n",
"
62
\n",
"
43
\n",
"
52
\n",
"
66
\n",
"
0
\n",
"
0
\n",
"
285
\n",
"
\n",
"
\n",
"
183
\n",
"
5260285
\n",
"
New-Bridge Integrated College
\n",
"
109
\n",
"
107
\n",
"
101
\n",
"
106
\n",
"
104
\n",
"
52
\n",
"
36
\n",
"
615
\n",
"
\n",
"
\n",
"
184
\n",
"
5260286
\n",
"
Integrated College Dungannon
\n",
"
119
\n",
"
99
\n",
"
97
\n",
"
94
\n",
"
93
\n",
"
41
\n",
"
49
\n",
"
592
\n",
"
\n",
"
\n",
"
185
\n",
"
5410013
\n",
"
Banbridge Academy
\n",
"
185
\n",
"
187
\n",
"
193
\n",
"
196
\n",
"
196
\n",
"
184
\n",
"
160
\n",
"
1301
\n",
"
\n",
"
\n",
"
186
\n",
"
5410057
\n",
"
Lurgan College
\n",
"
0
\n",
"
0
\n",
"
0
\n",
"
122
\n",
"
116
\n",
"
115
\n",
"
102
\n",
"
455
\n",
"
\n",
"
\n",
"
187
\n",
"
5410067
\n",
"
Portadown College
\n",
"
0
\n",
"
0
\n",
"
0
\n",
"
205
\n",
"
207
\n",
"
171
\n",
"
161
\n",
"
744
\n",
"
\n",
"
\n",
"
188
\n",
"
5420045
\n",
"
St Louis Grammar School, Kilkeel
\n",
"
82
\n",
"
83
\n",
"
84
\n",
"
81
\n",
"
84
\n",
"
81
\n",
"
69
\n",
"
564
\n",
"
\n",
"
\n",
"
189
\n",
"
5420059
\n",
"
Abbey Christian Brothers Grammar School
\n",
"
128
\n",
"
130
\n",
"
129
\n",
"
132
\n",
"
136
\n",
"
115
\n",
"
115
\n",
"
885
\n",
"
\n",
"
\n",
"
190
\n",
"
5420060
\n",
"
Our Lady's Grammar School
\n",
"
126
\n",
"
124
\n",
"
124
\n",
"
126
\n",
"
125
\n",
"
117
\n",
"
111
\n",
"
853
\n",
"
\n",
"
\n",
"
191
\n",
"
5420062
\n",
"
St Colman's College, Newry
\n",
"
127
\n",
"
126
\n",
"
131
\n",
"
130
\n",
"
125
\n",
"
118
\n",
"
128
\n",
"
885
\n",
"
\n",
"
\n",
"
192
\n",
"
5420073
\n",
"
St Joseph's Convent Grammar School, Donaghmore
\n",
"
99
\n",
"
102
\n",
"
105
\n",
"
92
\n",
"
102
\n",
"
106
\n",
"
80
\n",
"
686
\n",
"
\n",
"
\n",
"
193
\n",
"
5420076
\n",
"
Sacred Heart Grammar School, Newry
\n",
"
123
\n",
"
123
\n",
"
120
\n",
"
120
\n",
"
119
\n",
"
122
\n",
"
116
\n",
"
843
\n",
"
\n",
"
\n",
"
194
\n",
"
5420260
\n",
"
The Royal School, Dungannon
\n",
"
93
\n",
"
96
\n",
"
107
\n",
"
93
\n",
"
105
\n",
"
74
\n",
"
70
\n",
"
638
\n",
"
\n",
"
\n",
"
195
\n",
"
5420263
\n",
"
The Royal School, Armagh
\n",
"
103
\n",
"
103
\n",
"
99
\n",
"
108
\n",
"
106
\n",
"
103
\n",
"
113
\n",
"
735
\n",
"
\n",
"
\n",
"
196
\n",
"
5420268
\n",
"
St Patrick's Grammar School, Armagh
\n",
"
126
\n",
"
164
\n",
"
132
\n",
"
155
\n",
"
156
\n",
"
126
\n",
"
108
\n",
"
967
\n",
"
\n",
"
\n",
"
197
\n",
"
5420304
\n",
"
St Patrick's Academy, Dungannon
\n",
"
197
\n",
"
198
\n",
"
198
\n",
"
189
\n",
"
200
\n",
"
176
\n",
"
182
\n",
"
1340
\n",
"
\n",
"
\n",
"
198
\n",
"
5420314
\n",
"
St Ronan’s College
\n",
"
285
\n",
"
243
\n",
"
207
\n",
"
182
\n",
"
249
\n",
"
157
\n",
"
146
\n",
"
1469
\n",
"
\n",
"
\n",
"
199
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
"
\n",
"
200
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
"
\n",
"
201
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
"
\n",
"
202
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
"
\n",
"
203
\n",
"
Source: NI school census
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
"
\n",
"
204
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
"
\n",
"
205
\n",
"
Notes:
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
"
\n",
"
206
\n",
"
1. Year groups refer to the level of study of ...
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
"
\n",
"
207
\n",
"
2. Pupils aged 16+ that are not studying level...
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
" \n",
"
\n",
"
208 rows × 10 columns
\n",
"
"
],
"text/plain": [
" de ref \\\n",
"0 1210014 \n",
"1 1210015 \n",
"2 1210021 \n",
"3 1210022 \n",
"4 1230053 \n",
"5 1230104 \n",
"6 1230130 \n",
"7 1230146 \n",
"8 1230155 \n",
"9 1230182 \n",
"10 1230262 \n",
"11 1230275 \n",
"12 1230321 \n",
"13 1240291 \n",
"14 1260269 \n",
"15 1260294 \n",
"16 1410079 \n",
"17 1410270 \n",
"18 1410315 \n",
"19 1420020 \n",
"20 1420021 \n",
"21 1420022 \n",
"22 1420027 \n",
"23 1420028 \n",
"24 1420029 \n",
"25 1420030 \n",
"26 1420082 \n",
"27 1420089 \n",
"28 1420095 \n",
"29 1420264 \n",
".. ... \n",
"178 5230218 \n",
"179 5230278 \n",
"180 5230293 \n",
"181 5230321 \n",
"182 5250216 \n",
"183 5260285 \n",
"184 5260286 \n",
"185 5410013 \n",
"186 5410057 \n",
"187 5410067 \n",
"188 5420045 \n",
"189 5420059 \n",
"190 5420060 \n",
"191 5420062 \n",
"192 5420073 \n",
"193 5420076 \n",
"194 5420260 \n",
"195 5420263 \n",
"196 5420268 \n",
"197 5420304 \n",
"198 5420314 \n",
"199 NaN \n",
"200 NaN \n",
"201 NaN \n",
"202 NaN \n",
"203 Source: NI school census \n",
"204 NaN \n",
"205 Notes: \n",
"206 1. Year groups refer to the level of study of ... \n",
"207 2. Pupils aged 16+ that are not studying level... \n",
"\n",
" schoolname year of enrolment year 8 \\\n",
"0 Ashfield Girls' High School 124 \n",
"1 Ashfield Boys' High School 126 \n",
"2 Belfast Model School For Girls 167 \n",
"3 Belfast Boys' Model School 174 \n",
"4 St Louise's Comprehensive College 236 \n",
"5 Mercy College Belfast 76 \n",
"6 St Rose’s Dominican College 16 \n",
"7 Christian Brothers School, Belfast 107 \n",
"8 St Genevieve's High School 164 \n",
"9 De La Salle College 109 \n",
"10 Corpus Christi College 24 \n",
"11 St Joseph's College, Belfast 123 \n",
"12 Blessed Trinity College 204 \n",
"13 Colaiste Feirste 102 \n",
"14 Hazelwood College 170 \n",
"15 Malone Integrated College 69 \n",
"16 Grosvenor Grammar School 160 \n",
"17 Wellington College 112 \n",
"18 Bloomfield Collegiate 101 \n",
"19 Campbell College 134 \n",
"20 St Mary's Christian Brothers' Grammar, Belfast 178 \n",
"21 Methodist College 241 \n",
"22 The Royal Belfast Academical Institution 152 \n",
"23 Belfast Royal Academy 207 \n",
"24 St Dominic's High School, Belfast 141 \n",
"25 St Malachy's College, Belfast 159 \n",
"26 Dominican College, Belfast 152 \n",
"27 Strathearn School, Belfast 111 \n",
"28 Rathmore Grammar School 184 \n",
"29 Victoria College 132 \n",
".. ... ... \n",
"178 St Catherine's College 173 \n",
"179 Holy Trinity College 159 \n",
"180 St Patrick's College, Dungannon 106 \n",
"181 St John The Baptist College 77 \n",
"182 Brownlow Int College 62 \n",
"183 New-Bridge Integrated College 109 \n",
"184 Integrated College Dungannon 119 \n",
"185 Banbridge Academy 185 \n",
"186 Lurgan College 0 \n",
"187 Portadown College 0 \n",
"188 St Louis Grammar School, Kilkeel 82 \n",
"189 Abbey Christian Brothers Grammar School 128 \n",
"190 Our Lady's Grammar School 126 \n",
"191 St Colman's College, Newry 127 \n",
"192 St Joseph's Convent Grammar School, Donaghmore 99 \n",
"193 Sacred Heart Grammar School, Newry 123 \n",
"194 The Royal School, Dungannon 93 \n",
"195 The Royal School, Armagh 103 \n",
"196 St Patrick's Grammar School, Armagh 126 \n",
"197 St Patrick's Academy, Dungannon 197 \n",
"198 St Ronan’s College 285 \n",
"199 NaN NaN \n",
"200 NaN NaN \n",
"201 NaN NaN \n",
"202 NaN NaN \n",
"203 NaN NaN \n",
"204 NaN NaN \n",
"205 NaN NaN \n",
"206 NaN NaN \n",
"207 NaN NaN \n",
"\n",
" year 9 year 10 year 11 year 12 year 13 year 14 total pupils \n",
"0 114 119 111 113 60 50 691 \n",
"1 121 117 121 111 84 60 740 \n",
"2 160 162 139 121 127 70 946 \n",
"3 179 165 154 160 89 76 997 \n",
"4 194 189 206 264 160 186 1435 \n",
"5 66 71 76 73 71 17 450 \n",
"6 25 32 37 37 72 24 243 \n",
"7 70 95 47 40 87 79 525 \n",
"8 161 152 152 165 138 90 1022 \n",
"9 165 164 161 173 119 67 958 \n",
"10 23 45 40 38 37 26 233 \n",
"11 112 125 111 104 47 36 658 \n",
"12 204 216 178 191 189 89 1271 \n",
"13 119 102 112 97 71 48 651 \n",
"14 171 153 147 144 94 75 954 \n",
"15 69 88 63 85 74 37 485 \n",
"16 158 162 163 154 150 133 1080 \n",
"17 119 114 117 122 85 73 742 \n",
"18 110 101 110 107 93 78 700 \n",
"19 143 147 148 147 96 107 922 \n",
"20 185 182 174 165 157 124 1165 \n",
"21 247 256 255 253 266 258 1776 \n",
"22 160 160 164 146 114 116 1012 \n",
"23 211 209 216 209 221 188 1461 \n",
"24 147 145 144 156 149 130 1012 \n",
"25 161 165 171 166 151 121 1094 \n",
"26 148 151 153 147 152 98 1001 \n",
"27 116 121 110 111 103 106 778 \n",
"28 186 186 186 184 183 161 1270 \n",
"29 138 141 136 127 120 103 897 \n",
".. ... ... ... ... ... ... ... \n",
"178 173 159 157 189 125 128 1104 \n",
"179 163 171 169 160 112 87 1021 \n",
"180 109 98 92 101 49 35 590 \n",
"181 50 37 5 1 0 0 170 \n",
"182 62 43 52 66 0 0 285 \n",
"183 107 101 106 104 52 36 615 \n",
"184 99 97 94 93 41 49 592 \n",
"185 187 193 196 196 184 160 1301 \n",
"186 0 0 122 116 115 102 455 \n",
"187 0 0 205 207 171 161 744 \n",
"188 83 84 81 84 81 69 564 \n",
"189 130 129 132 136 115 115 885 \n",
"190 124 124 126 125 117 111 853 \n",
"191 126 131 130 125 118 128 885 \n",
"192 102 105 92 102 106 80 686 \n",
"193 123 120 120 119 122 116 843 \n",
"194 96 107 93 105 74 70 638 \n",
"195 103 99 108 106 103 113 735 \n",
"196 164 132 155 156 126 108 967 \n",
"197 198 198 189 200 176 182 1340 \n",
"198 243 207 182 249 157 146 1469 \n",
"199 NaN NaN NaN NaN NaN NaN NaN \n",
"200 NaN NaN NaN NaN NaN NaN NaN \n",
"201 NaN NaN NaN NaN NaN NaN NaN \n",
"202 NaN NaN NaN NaN NaN NaN NaN \n",
"203 NaN NaN NaN NaN NaN NaN NaN \n",
"204 NaN NaN NaN NaN NaN NaN NaN \n",
"205 NaN NaN NaN NaN NaN NaN NaN \n",
"206 NaN NaN NaN NaN NaN NaN NaN \n",
"207 NaN NaN NaN NaN NaN NaN NaN \n",
"\n",
"[208 rows x 10 columns]"
]
},
"execution_count": 73,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"def parse_enrolments_table(xls):\n",
" join_n_strip_n_lower = lambda l: ' '.join(l).strip().lower()\n",
" \n",
" if 'enrolments' in xls.sheet_names:\n",
" df = pd.read_excel(xls, 'enrolments', header=None)\n",
" h_range = 2 if isinstance(df.ix[3,0], int) else 3\n",
" try:\n",
" df.columns=df.ix[1:h_range].fillna('').apply(join_n_strip_n_lower, axis=0).values\n",
" df = df.drop(df.index[0:h_range+1]).reset_index(drop=True)\n",
" except TypeError as e:\n",
" print(e)\n",
" else:\n",
" df=None\n",
" return df\n",
"df= parse_enrolments_table(xls)\n",
"df"
]
},
{
"cell_type": "code",
"execution_count": 74,
"metadata": {
"ExecuteTime": {
"end_time": "2018-06-07T10:38:41.870545Z",
"start_time": "2018-06-07T10:38:41.833695Z"
}
},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
"
\n",
"
\n",
"
schoolname
\n",
"
year of enrolment year 8
\n",
"
year 9
\n",
"
year 10
\n",
"
year 11
\n",
"
year 12
\n",
"
year 13
\n",
"
year 14
\n",
"
total pupils
\n",
"
\n",
"
\n",
"
de ref
\n",
"
\n",
"
\n",
"
\n",
"
\n",
"
\n",
"
\n",
"
\n",
"
\n",
"
\n",
"
\n",
" \n",
" \n",
"
\n",
"
1210014
\n",
"
Ashfield Girls' High School
\n",
"
124
\n",
"
114
\n",
"
119
\n",
"
111
\n",
"
113
\n",
"
60
\n",
"
50
\n",
"
691
\n",
"
\n",
"
\n",
"
1210015
\n",
"
Ashfield Boys' High School
\n",
"
126
\n",
"
121
\n",
"
117
\n",
"
121
\n",
"
111
\n",
"
84
\n",
"
60
\n",
"
740
\n",
"
\n",
"
\n",
"
1210021
\n",
"
Belfast Model School For Girls
\n",
"
167
\n",
"
160
\n",
"
162
\n",
"
139
\n",
"
121
\n",
"
127
\n",
"
70
\n",
"
946
\n",
"
\n",
"
\n",
"
1210022
\n",
"
Belfast Boys' Model School
\n",
"
174
\n",
"
179
\n",
"
165
\n",
"
154
\n",
"
160
\n",
"
89
\n",
"
76
\n",
"
997
\n",
"
\n",
"
\n",
"
1230053
\n",
"
St Louise's Comprehensive College
\n",
"
236
\n",
"
194
\n",
"
189
\n",
"
206
\n",
"
264
\n",
"
160
\n",
"
186
\n",
"
1435
\n",
"
\n",
"
\n",
"
1230104
\n",
"
Mercy College Belfast
\n",
"
76
\n",
"
66
\n",
"
71
\n",
"
76
\n",
"
73
\n",
"
71
\n",
"
17
\n",
"
450
\n",
"
\n",
"
\n",
"
1230130
\n",
"
St Rose’s Dominican College
\n",
"
16
\n",
"
25
\n",
"
32
\n",
"
37
\n",
"
37
\n",
"
72
\n",
"
24
\n",
"
243
\n",
"
\n",
"
\n",
"
1230146
\n",
"
Christian Brothers School, Belfast
\n",
"
107
\n",
"
70
\n",
"
95
\n",
"
47
\n",
"
40
\n",
"
87
\n",
"
79
\n",
"
525
\n",
"
\n",
"
\n",
"
1230155
\n",
"
St Genevieve's High School
\n",
"
164
\n",
"
161
\n",
"
152
\n",
"
152
\n",
"
165
\n",
"
138
\n",
"
90
\n",
"
1022
\n",
"
\n",
"
\n",
"
1230182
\n",
"
De La Salle College
\n",
"
109
\n",
"
165
\n",
"
164
\n",
"
161
\n",
"
173
\n",
"
119
\n",
"
67
\n",
"
958
\n",
"
\n",
"
\n",
"
1230262
\n",
"
Corpus Christi College
\n",
"
24
\n",
"
23
\n",
"
45
\n",
"
40
\n",
"
38
\n",
"
37
\n",
"
26
\n",
"
233
\n",
"
\n",
"
\n",
"
1230275
\n",
"
St Joseph's College, Belfast
\n",
"
123
\n",
"
112
\n",
"
125
\n",
"
111
\n",
"
104
\n",
"
47
\n",
"
36
\n",
"
658
\n",
"
\n",
"
\n",
"
1230321
\n",
"
Blessed Trinity College
\n",
"
204
\n",
"
204
\n",
"
216
\n",
"
178
\n",
"
191
\n",
"
189
\n",
"
89
\n",
"
1271
\n",
"
\n",
"
\n",
"
1240291
\n",
"
Colaiste Feirste
\n",
"
102
\n",
"
119
\n",
"
102
\n",
"
112
\n",
"
97
\n",
"
71
\n",
"
48
\n",
"
651
\n",
"
\n",
"
\n",
"
1260269
\n",
"
Hazelwood College
\n",
"
170
\n",
"
171
\n",
"
153
\n",
"
147
\n",
"
144
\n",
"
94
\n",
"
75
\n",
"
954
\n",
"
\n",
"
\n",
"
1260294
\n",
"
Malone Integrated College
\n",
"
69
\n",
"
69
\n",
"
88
\n",
"
63
\n",
"
85
\n",
"
74
\n",
"
37
\n",
"
485
\n",
"
\n",
"
\n",
"
1410079
\n",
"
Grosvenor Grammar School
\n",
"
160
\n",
"
158
\n",
"
162
\n",
"
163
\n",
"
154
\n",
"
150
\n",
"
133
\n",
"
1080
\n",
"
\n",
"
\n",
"
1410270
\n",
"
Wellington College
\n",
"
112
\n",
"
119
\n",
"
114
\n",
"
117
\n",
"
122
\n",
"
85
\n",
"
73
\n",
"
742
\n",
"
\n",
"
\n",
"
1410315
\n",
"
Bloomfield Collegiate
\n",
"
101
\n",
"
110
\n",
"
101
\n",
"
110
\n",
"
107
\n",
"
93
\n",
"
78
\n",
"
700
\n",
"
\n",
"
\n",
"
1420020
\n",
"
Campbell College
\n",
"
134
\n",
"
143
\n",
"
147
\n",
"
148
\n",
"
147
\n",
"
96
\n",
"
107
\n",
"
922
\n",
"
\n",
"
\n",
"
1420021
\n",
"
St Mary's Christian Brothers' Grammar, Belfast
\n",
"
178
\n",
"
185
\n",
"
182
\n",
"
174
\n",
"
165
\n",
"
157
\n",
"
124
\n",
"
1165
\n",
"
\n",
"
\n",
"
1420022
\n",
"
Methodist College
\n",
"
241
\n",
"
247
\n",
"
256
\n",
"
255
\n",
"
253
\n",
"
266
\n",
"
258
\n",
"
1776
\n",
"
\n",
"
\n",
"
1420027
\n",
"
The Royal Belfast Academical Institution
\n",
"
152
\n",
"
160
\n",
"
160
\n",
"
164
\n",
"
146
\n",
"
114
\n",
"
116
\n",
"
1012
\n",
"
\n",
"
\n",
"
1420028
\n",
"
Belfast Royal Academy
\n",
"
207
\n",
"
211
\n",
"
209
\n",
"
216
\n",
"
209
\n",
"
221
\n",
"
188
\n",
"
1461
\n",
"
\n",
"
\n",
"
1420029
\n",
"
St Dominic's High School, Belfast
\n",
"
141
\n",
"
147
\n",
"
145
\n",
"
144
\n",
"
156
\n",
"
149
\n",
"
130
\n",
"
1012
\n",
"
\n",
"
\n",
"
1420030
\n",
"
St Malachy's College, Belfast
\n",
"
159
\n",
"
161
\n",
"
165
\n",
"
171
\n",
"
166
\n",
"
151
\n",
"
121
\n",
"
1094
\n",
"
\n",
"
\n",
"
1420082
\n",
"
Dominican College, Belfast
\n",
"
152
\n",
"
148
\n",
"
151
\n",
"
153
\n",
"
147
\n",
"
152
\n",
"
98
\n",
"
1001
\n",
"
\n",
"
\n",
"
1420089
\n",
"
Strathearn School, Belfast
\n",
"
111
\n",
"
116
\n",
"
121
\n",
"
110
\n",
"
111
\n",
"
103
\n",
"
106
\n",
"
778
\n",
"
\n",
"
\n",
"
1420095
\n",
"
Rathmore Grammar School
\n",
"
184
\n",
"
186
\n",
"
186
\n",
"
186
\n",
"
184
\n",
"
183
\n",
"
161
\n",
"
1270
\n",
"
\n",
"
\n",
"
1420264
\n",
"
Victoria College
\n",
"
132
\n",
"
138
\n",
"
141
\n",
"
136
\n",
"
127
\n",
"
120
\n",
"
103
\n",
"
897
\n",
"
\n",
"
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
\n",
"
\n",
"
5230218
\n",
"
St Catherine's College
\n",
"
173
\n",
"
173
\n",
"
159
\n",
"
157
\n",
"
189
\n",
"
125
\n",
"
128
\n",
"
1104
\n",
"
\n",
"
\n",
"
5230278
\n",
"
Holy Trinity College
\n",
"
159
\n",
"
163
\n",
"
171
\n",
"
169
\n",
"
160
\n",
"
112
\n",
"
87
\n",
"
1021
\n",
"
\n",
"
\n",
"
5230293
\n",
"
St Patrick's College, Dungannon
\n",
"
106
\n",
"
109
\n",
"
98
\n",
"
92
\n",
"
101
\n",
"
49
\n",
"
35
\n",
"
590
\n",
"
\n",
"
\n",
"
5230321
\n",
"
St John The Baptist College
\n",
"
77
\n",
"
50
\n",
"
37
\n",
"
5
\n",
"
1
\n",
"
0
\n",
"
0
\n",
"
170
\n",
"
\n",
"
\n",
"
5250216
\n",
"
Brownlow Int College
\n",
"
62
\n",
"
62
\n",
"
43
\n",
"
52
\n",
"
66
\n",
"
0
\n",
"
0
\n",
"
285
\n",
"
\n",
"
\n",
"
5260285
\n",
"
New-Bridge Integrated College
\n",
"
109
\n",
"
107
\n",
"
101
\n",
"
106
\n",
"
104
\n",
"
52
\n",
"
36
\n",
"
615
\n",
"
\n",
"
\n",
"
5260286
\n",
"
Integrated College Dungannon
\n",
"
119
\n",
"
99
\n",
"
97
\n",
"
94
\n",
"
93
\n",
"
41
\n",
"
49
\n",
"
592
\n",
"
\n",
"
\n",
"
5410013
\n",
"
Banbridge Academy
\n",
"
185
\n",
"
187
\n",
"
193
\n",
"
196
\n",
"
196
\n",
"
184
\n",
"
160
\n",
"
1301
\n",
"
\n",
"
\n",
"
5410057
\n",
"
Lurgan College
\n",
"
0
\n",
"
0
\n",
"
0
\n",
"
122
\n",
"
116
\n",
"
115
\n",
"
102
\n",
"
455
\n",
"
\n",
"
\n",
"
5410067
\n",
"
Portadown College
\n",
"
0
\n",
"
0
\n",
"
0
\n",
"
205
\n",
"
207
\n",
"
171
\n",
"
161
\n",
"
744
\n",
"
\n",
"
\n",
"
5420045
\n",
"
St Louis Grammar School, Kilkeel
\n",
"
82
\n",
"
83
\n",
"
84
\n",
"
81
\n",
"
84
\n",
"
81
\n",
"
69
\n",
"
564
\n",
"
\n",
"
\n",
"
5420059
\n",
"
Abbey Christian Brothers Grammar School
\n",
"
128
\n",
"
130
\n",
"
129
\n",
"
132
\n",
"
136
\n",
"
115
\n",
"
115
\n",
"
885
\n",
"
\n",
"
\n",
"
5420060
\n",
"
Our Lady's Grammar School
\n",
"
126
\n",
"
124
\n",
"
124
\n",
"
126
\n",
"
125
\n",
"
117
\n",
"
111
\n",
"
853
\n",
"
\n",
"
\n",
"
5420062
\n",
"
St Colman's College, Newry
\n",
"
127
\n",
"
126
\n",
"
131
\n",
"
130
\n",
"
125
\n",
"
118
\n",
"
128
\n",
"
885
\n",
"
\n",
"
\n",
"
5420073
\n",
"
St Joseph's Convent Grammar School, Donaghmore
\n",
"
99
\n",
"
102
\n",
"
105
\n",
"
92
\n",
"
102
\n",
"
106
\n",
"
80
\n",
"
686
\n",
"
\n",
"
\n",
"
5420076
\n",
"
Sacred Heart Grammar School, Newry
\n",
"
123
\n",
"
123
\n",
"
120
\n",
"
120
\n",
"
119
\n",
"
122
\n",
"
116
\n",
"
843
\n",
"
\n",
"
\n",
"
5420260
\n",
"
The Royal School, Dungannon
\n",
"
93
\n",
"
96
\n",
"
107
\n",
"
93
\n",
"
105
\n",
"
74
\n",
"
70
\n",
"
638
\n",
"
\n",
"
\n",
"
5420263
\n",
"
The Royal School, Armagh
\n",
"
103
\n",
"
103
\n",
"
99
\n",
"
108
\n",
"
106
\n",
"
103
\n",
"
113
\n",
"
735
\n",
"
\n",
"
\n",
"
5420268
\n",
"
St Patrick's Grammar School, Armagh
\n",
"
126
\n",
"
164
\n",
"
132
\n",
"
155
\n",
"
156
\n",
"
126
\n",
"
108
\n",
"
967
\n",
"
\n",
"
\n",
"
5420304
\n",
"
St Patrick's Academy, Dungannon
\n",
"
197
\n",
"
198
\n",
"
198
\n",
"
189
\n",
"
200
\n",
"
176
\n",
"
182
\n",
"
1340
\n",
"
\n",
"
\n",
"
5420314
\n",
"
St Ronan’s College
\n",
"
285
\n",
"
243
\n",
"
207
\n",
"
182
\n",
"
249
\n",
"
157
\n",
"
146
\n",
"
1469
\n",
"
\n",
"
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
"
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
"
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
"
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
"
\n",
"
Source: NI school census
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
"
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
"
\n",
"
Notes:
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1. Year groups refer to the level of study of pupils i.e. Pupils in their final year of GCSEs (including those repeating are in year 12)
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
"
\n",
"
2. Pupils aged 16+ that are not studying level 2 or 3 qualifications have been recorded as year 12 pupils
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
" \n",
"
\n",
"
208 rows × 9 columns
\n",
"
"
],
"text/plain": [
" schoolname \\\n",
"de ref \n",
"1210014 Ashfield Girls' High School \n",
"1210015 Ashfield Boys' High School \n",
"1210021 Belfast Model School For Girls \n",
"1210022 Belfast Boys' Model School \n",
"1230053 St Louise's Comprehensive College \n",
"1230104 Mercy College Belfast \n",
"1230130 St Rose’s Dominican College \n",
"1230146 Christian Brothers School, Belfast \n",
"1230155 St Genevieve's High School \n",
"1230182 De La Salle College \n",
"1230262 Corpus Christi College \n",
"1230275 St Joseph's College, Belfast \n",
"1230321 Blessed Trinity College \n",
"1240291 Colaiste Feirste \n",
"1260269 Hazelwood College \n",
"1260294 Malone Integrated College \n",
"1410079 Grosvenor Grammar School \n",
"1410270 Wellington College \n",
"1410315 Bloomfield Collegiate \n",
"1420020 Campbell College \n",
"1420021 St Mary's Christian Brothers' Grammar, Belfast \n",
"1420022 Methodist College \n",
"1420027 The Royal Belfast Academical Institution \n",
"1420028 Belfast Royal Academy \n",
"1420029 St Dominic's High School, Belfast \n",
"1420030 St Malachy's College, Belfast \n",
"1420082 Dominican College, Belfast \n",
"1420089 Strathearn School, Belfast \n",
"1420095 Rathmore Grammar School \n",
"1420264 Victoria College \n",
"... ... \n",
"5230218 St Catherine's College \n",
"5230278 Holy Trinity College \n",
"5230293 St Patrick's College, Dungannon \n",
"5230321 St John The Baptist College \n",
"5250216 Brownlow Int College \n",
"5260285 New-Bridge Integrated College \n",
"5260286 Integrated College Dungannon \n",
"5410013 Banbridge Academy \n",
"5410057 Lurgan College \n",
"5410067 Portadown College \n",
"5420045 St Louis Grammar School, Kilkeel \n",
"5420059 Abbey Christian Brothers Grammar School \n",
"5420060 Our Lady's Grammar School \n",
"5420062 St Colman's College, Newry \n",
"5420073 St Joseph's Convent Grammar School, Donaghmore \n",
"5420076 Sacred Heart Grammar School, Newry \n",
"5420260 The Royal School, Dungannon \n",
"5420263 The Royal School, Armagh \n",
"5420268 St Patrick's Grammar School, Armagh \n",
"5420304 St Patrick's Academy, Dungannon \n",
"5420314 St Ronan’s College \n",
"NaN NaN \n",
"NaN NaN \n",
"NaN NaN \n",
"NaN NaN \n",
"Source: NI school census NaN \n",
"NaN NaN \n",
"Notes: NaN \n",
"1. Year groups refer to the level of study of p... NaN \n",
"2. Pupils aged 16+ that are not studying level ... NaN \n",
"\n",
" year of enrolment year 8 \\\n",
"de ref \n",
"1210014 124 \n",
"1210015 126 \n",
"1210021 167 \n",
"1210022 174 \n",
"1230053 236 \n",
"1230104 76 \n",
"1230130 16 \n",
"1230146 107 \n",
"1230155 164 \n",
"1230182 109 \n",
"1230262 24 \n",
"1230275 123 \n",
"1230321 204 \n",
"1240291 102 \n",
"1260269 170 \n",
"1260294 69 \n",
"1410079 160 \n",
"1410270 112 \n",
"1410315 101 \n",
"1420020 134 \n",
"1420021 178 \n",
"1420022 241 \n",
"1420027 152 \n",
"1420028 207 \n",
"1420029 141 \n",
"1420030 159 \n",
"1420082 152 \n",
"1420089 111 \n",
"1420095 184 \n",
"1420264 132 \n",
"... ... \n",
"5230218 173 \n",
"5230278 159 \n",
"5230293 106 \n",
"5230321 77 \n",
"5250216 62 \n",
"5260285 109 \n",
"5260286 119 \n",
"5410013 185 \n",
"5410057 0 \n",
"5410067 0 \n",
"5420045 82 \n",
"5420059 128 \n",
"5420060 126 \n",
"5420062 127 \n",
"5420073 99 \n",
"5420076 123 \n",
"5420260 93 \n",
"5420263 103 \n",
"5420268 126 \n",
"5420304 197 \n",
"5420314 285 \n",
"NaN NaN \n",
"NaN NaN \n",
"NaN NaN \n",
"NaN NaN \n",
"Source: NI school census NaN \n",
"NaN NaN \n",
"Notes: NaN \n",
"1. Year groups refer to the level of study of p... NaN \n",
"2. Pupils aged 16+ that are not studying level ... NaN \n",
"\n",
" year 9 year 10 year 11 \\\n",
"de ref \n",
"1210014 114 119 111 \n",
"1210015 121 117 121 \n",
"1210021 160 162 139 \n",
"1210022 179 165 154 \n",
"1230053 194 189 206 \n",
"1230104 66 71 76 \n",
"1230130 25 32 37 \n",
"1230146 70 95 47 \n",
"1230155 161 152 152 \n",
"1230182 165 164 161 \n",
"1230262 23 45 40 \n",
"1230275 112 125 111 \n",
"1230321 204 216 178 \n",
"1240291 119 102 112 \n",
"1260269 171 153 147 \n",
"1260294 69 88 63 \n",
"1410079 158 162 163 \n",
"1410270 119 114 117 \n",
"1410315 110 101 110 \n",
"1420020 143 147 148 \n",
"1420021 185 182 174 \n",
"1420022 247 256 255 \n",
"1420027 160 160 164 \n",
"1420028 211 209 216 \n",
"1420029 147 145 144 \n",
"1420030 161 165 171 \n",
"1420082 148 151 153 \n",
"1420089 116 121 110 \n",
"1420095 186 186 186 \n",
"1420264 138 141 136 \n",
"... ... ... ... \n",
"5230218 173 159 157 \n",
"5230278 163 171 169 \n",
"5230293 109 98 92 \n",
"5230321 50 37 5 \n",
"5250216 62 43 52 \n",
"5260285 107 101 106 \n",
"5260286 99 97 94 \n",
"5410013 187 193 196 \n",
"5410057 0 0 122 \n",
"5410067 0 0 205 \n",
"5420045 83 84 81 \n",
"5420059 130 129 132 \n",
"5420060 124 124 126 \n",
"5420062 126 131 130 \n",
"5420073 102 105 92 \n",
"5420076 123 120 120 \n",
"5420260 96 107 93 \n",
"5420263 103 99 108 \n",
"5420268 164 132 155 \n",
"5420304 198 198 189 \n",
"5420314 243 207 182 \n",
"NaN NaN NaN NaN \n",
"NaN NaN NaN NaN \n",
"NaN NaN NaN NaN \n",
"NaN NaN NaN NaN \n",
"Source: NI school census NaN NaN NaN \n",
"NaN NaN NaN NaN \n",
"Notes: NaN NaN NaN \n",
"1. Year groups refer to the level of study of p... NaN NaN NaN \n",
"2. Pupils aged 16+ that are not studying level ... NaN NaN NaN \n",
"\n",
" year 12 year 13 year 14 \\\n",
"de ref \n",
"1210014 113 60 50 \n",
"1210015 111 84 60 \n",
"1210021 121 127 70 \n",
"1210022 160 89 76 \n",
"1230053 264 160 186 \n",
"1230104 73 71 17 \n",
"1230130 37 72 24 \n",
"1230146 40 87 79 \n",
"1230155 165 138 90 \n",
"1230182 173 119 67 \n",
"1230262 38 37 26 \n",
"1230275 104 47 36 \n",
"1230321 191 189 89 \n",
"1240291 97 71 48 \n",
"1260269 144 94 75 \n",
"1260294 85 74 37 \n",
"1410079 154 150 133 \n",
"1410270 122 85 73 \n",
"1410315 107 93 78 \n",
"1420020 147 96 107 \n",
"1420021 165 157 124 \n",
"1420022 253 266 258 \n",
"1420027 146 114 116 \n",
"1420028 209 221 188 \n",
"1420029 156 149 130 \n",
"1420030 166 151 121 \n",
"1420082 147 152 98 \n",
"1420089 111 103 106 \n",
"1420095 184 183 161 \n",
"1420264 127 120 103 \n",
"... ... ... ... \n",
"5230218 189 125 128 \n",
"5230278 160 112 87 \n",
"5230293 101 49 35 \n",
"5230321 1 0 0 \n",
"5250216 66 0 0 \n",
"5260285 104 52 36 \n",
"5260286 93 41 49 \n",
"5410013 196 184 160 \n",
"5410057 116 115 102 \n",
"5410067 207 171 161 \n",
"5420045 84 81 69 \n",
"5420059 136 115 115 \n",
"5420060 125 117 111 \n",
"5420062 125 118 128 \n",
"5420073 102 106 80 \n",
"5420076 119 122 116 \n",
"5420260 105 74 70 \n",
"5420263 106 103 113 \n",
"5420268 156 126 108 \n",
"5420304 200 176 182 \n",
"5420314 249 157 146 \n",
"NaN NaN NaN NaN \n",
"NaN NaN NaN NaN \n",
"NaN NaN NaN NaN \n",
"NaN NaN NaN NaN \n",
"Source: NI school census NaN NaN NaN \n",
"NaN NaN NaN NaN \n",
"Notes: NaN NaN NaN \n",
"1. Year groups refer to the level of study of p... NaN NaN NaN \n",
"2. Pupils aged 16+ that are not studying level ... NaN NaN NaN \n",
"\n",
" total pupils \n",
"de ref \n",
"1210014 691 \n",
"1210015 740 \n",
"1210021 946 \n",
"1210022 997 \n",
"1230053 1435 \n",
"1230104 450 \n",
"1230130 243 \n",
"1230146 525 \n",
"1230155 1022 \n",
"1230182 958 \n",
"1230262 233 \n",
"1230275 658 \n",
"1230321 1271 \n",
"1240291 651 \n",
"1260269 954 \n",
"1260294 485 \n",
"1410079 1080 \n",
"1410270 742 \n",
"1410315 700 \n",
"1420020 922 \n",
"1420021 1165 \n",
"1420022 1776 \n",
"1420027 1012 \n",
"1420028 1461 \n",
"1420029 1012 \n",
"1420030 1094 \n",
"1420082 1001 \n",
"1420089 778 \n",
"1420095 1270 \n",
"1420264 897 \n",
"... ... \n",
"5230218 1104 \n",
"5230278 1021 \n",
"5230293 590 \n",
"5230321 170 \n",
"5250216 285 \n",
"5260285 615 \n",
"5260286 592 \n",
"5410013 1301 \n",
"5410057 455 \n",
"5410067 744 \n",
"5420045 564 \n",
"5420059 885 \n",
"5420060 853 \n",
"5420062 885 \n",
"5420073 686 \n",
"5420076 843 \n",
"5420260 638 \n",
"5420263 735 \n",
"5420268 967 \n",
"5420304 1340 \n",
"5420314 1469 \n",
"NaN NaN \n",
"NaN NaN \n",
"NaN NaN \n",
"NaN NaN \n",
"Source: NI school census NaN \n",
"NaN NaN \n",
"Notes: NaN \n",
"1. Year groups refer to the level of study of p... NaN \n",
"2. Pupils aged 16+ that are not studying level ... NaN \n",
"\n",
"[208 rows x 9 columns]"
]
},
"execution_count": 74,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.set_index('de ref')"
]
},
{
"cell_type": "code",
"execution_count": 75,
"metadata": {
"ExecuteTime": {
"end_time": "2018-06-07T10:38:42.352573Z",
"start_time": "2018-06-07T10:38:42.315910Z"
}
},
"outputs": [
{
"data": {
"text/html": [
"
"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"panel.sum().sum().plot()"
]
},
{
"cell_type": "markdown",
"metadata": {
"ExecuteTime": {
"end_time": "2018-06-07T10:38:56.389044Z",
"start_time": "2018-06-07T10:38:56.386530Z"
}
},
"source": [
"## Now to start bringing these together!\n",
"\n"
]
},
{
"cell_type": "code",
"execution_count": 91,
"metadata": {
"ExecuteTime": {
"end_time": "2018-06-07T10:39:03.162277Z",
"start_time": "2018-06-07T10:39:02.461754Z"
}
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Got enrolement data for 2009\n",
"Got enrolement data for 2010\n",
"Got enrolement data for 2011\n",
"Got enrolement data for 2012\n",
"Got enrolement data for 2013\n",
"Got enrolement data for 2014\n",
"Got enrolement data for 2015\n",
"Got enrolement data for 2016\n",
"Got enrolement data for 2017\n"
]
}
],
"source": [
"def parse_enrolments_table(xls):\n",
" join_n_strip_n_lower = lambda l: ' '.join(l).strip().lower()\n",
" strip_n_lower = lambda s: s.strip().lower()\n",
" unyearify = lambda s: int(s.replace('year ',''))\n",
" \n",
" if 'enrolments' in xls.sheet_names:\n",
" df = pd.read_excel(xls, 'enrolments', header=None, skip_footer=5)\n",
" h_range = 2 if isinstance(df.ix[3,0], int) else 3\n",
" try:\n",
" df.columns=df.ix[3].fillna('').apply(strip_n_lower).values\n",
" df = df.drop(df.index[0:h_range+1]).reset_index(drop=True)\n",
" df.dropna(how='all', inplace=True, axis=0)\n",
" df['de ref'] = df['de ref'].astype(int)\n",
" df.drop('schoolname',axis=1, inplace=True)\n",
" df.drop('total pupils',axis=1, inplace=True)\n",
" df.set_index('de ref', inplace=True)\n",
" df.rename(columns=unyearify, inplace=True)\n",
" df=df.astype(float)\n",
" except TypeError as e:\n",
" print(e)\n",
" else:\n",
" df=None\n",
" return df\n",
"\n",
"dfs = {}\n",
"for year, files in year_files.items():\n",
" for file in files:\n",
" if 'post' in file:\n",
" xls = pd.ExcelFile(f'data/education-ni/{year}/{file}')\n",
" df = parse_enrolments_table(xls)\n",
" if df is not None:\n",
" print(f'Got enrolement data for {year}')\n",
" dfs[year]=df\n",
"enrolements = pd.Panel(dfs)"
]
},
{
"cell_type": "code",
"execution_count": 92,
"metadata": {
"ExecuteTime": {
"end_time": "2018-06-07T10:39:05.953855Z",
"start_time": "2018-06-07T10:39:04.638737Z"
}
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Got reference data for 2009\n",
"Got reference data for 2010\n",
"Got reference data for 2011\n",
"Got reference data for 2012\n",
"Got reference data for 2013\n",
"Got reference data for 2014\n",
"Got reference data for 2015\n",
"Got reference data for 2016\n",
"Got reference data for 2017\n"
]
}
],
"source": [
"def parse_reference_table(xls):\n",
" cols = [\n",
" 'de ref',\n",
" 'school name',\n",
" 'school type',\n",
" 'address 1',\n",
" 'postcode',\n",
" 'urban_rural',\n",
" 'school management type',\n",
" 'district council',\n",
" 'parliamentary constituency',\n",
" 'town'\n",
" ]\n",
" \n",
" categories = [\n",
" 'school type',\n",
" 'urban_rural',\n",
" 'school management type',\n",
" 'district council',\n",
" 'parliamentary constituency',\n",
" 'town'\n",
" ]\n",
"\n",
" ref_key_map={\n",
" 'denino':'de ref',\n",
" 'urban/ rural': 'urban_rural',\n",
" 'schoolname': 'school name'\n",
" }\n",
" join_n_strip_n_lower = lambda l: ' '.join(l).strip().lower()\n",
" \n",
" if 'reference data' in xls.sheet_names:\n",
" df = pd.read_excel(xls, 'reference data', header=None)\n",
" h_range = 2 if isinstance(df.ix[3,0], int) else 3\n",
" try:\n",
" df.columns=df.ix[1:h_range].fillna('').apply(join_n_strip_n_lower, axis=0).values\n",
" df.rename(columns=ref_key_map, inplace=True)\n",
" df = df.drop(df.index[0:h_range+1]).reset_index(drop=True)\n",
" df = df[cols]\n",
" df['de ref'] = df['de ref'].astype(int)\n",
" df.set_index('de ref', inplace=True)\n",
" for c in df:\n",
" df[c]=df[c].str.lower().str.strip()\n",
" for c in categories:\n",
" df[c] = df[c].astype('category')\n",
" except TypeError as e:\n",
" print(e)\n",
" else:\n",
" df=None\n",
" return df\n",
"\n",
"dfs = {}\n",
"for year, files in year_files.items():\n",
" for file in files:\n",
" if 'post' in file:\n",
" xls = pd.ExcelFile(f'data/education-ni/{year}/{file}')\n",
" df = parse_reference_table(xls)\n",
" if df is not None:\n",
" print(f'Got reference data for {year}')\n",
" dfs[year]=df\n",
"reference = pd.Panel(dfs)"
]
},
{
"cell_type": "code",
"execution_count": 93,
"metadata": {
"ExecuteTime": {
"end_time": "2018-06-07T10:39:08.413228Z",
"start_time": "2018-06-07T10:39:08.367923Z"
}
},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
"
\n",
"
\n",
"
\n",
"
2009
\n",
"
2010
\n",
"
2011
\n",
"
2012
\n",
"
2013
\n",
"
2014
\n",
"
2015
\n",
"
2016
\n",
"
2017
\n",
"
\n",
"
\n",
"
de ref
\n",
"
minor
\n",
"
\n",
"
\n",
"
\n",
"
\n",
"
\n",
"
\n",
"
\n",
"
\n",
"
\n",
"
\n",
" \n",
" \n",
"
\n",
"
1210014
\n",
"
school name
\n",
"
ashfield girls' high school
\n",
"
ashfield girls' high school
\n",
"
ashfield girls' high school
\n",
"
ashfield girls' high school
\n",
"
ashfield girls' high school
\n",
"
ashfield girls' high school
\n",
"
ashfield girls' high school
\n",
"
ashfield girls' high school
\n",
"
ashfield girls' high school
\n",
"
\n",
"
\n",
"
school type
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
non-grammar
\n",
"
\n",
"
\n",
"
address 1
\n",
"
holywood road
\n",
"
holywood road
\n",
"
holywood road
\n",
"
holywood road
\n",
"
holywood road
\n",
"
holywood road
\n",
"
397 holywood road
\n",
"
397 holywood road
\n",
"
397 holywood road
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt4 2ly
\n",
"
bt42ly
\n",
"
bt42ly
\n",
"
bt42ly
\n",
"
bt42ly
\n",
"
bt42ly
\n",
"
bt4 2ly
\n",
"
bt42ly
\n",
"
bt42ly
\n",
"
\n",
"
\n",
"
urban_rural
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
\n",
"
\n",
"
school management type
\n",
"
controlled
\n",
"
controlled
\n",
"
controlled
\n",
"
controlled
\n",
"
controlled
\n",
"
controlled
\n",
"
controlled
\n",
"
controlled
\n",
"
controlled
\n",
"
\n",
"
\n",
"
district council
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
\n",
"
\n",
"
parliamentary constituency
\n",
"
belfast east
\n",
"
belfast east
\n",
"
belfast east
\n",
"
belfast east
\n",
"
belfast east
\n",
"
belfast east
\n",
"
belfast east
\n",
"
belfast east
\n",
"
belfast east
\n",
"
\n",
"
\n",
"
town
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
\n",
"
\n",
"
1210015
\n",
"
school name
\n",
"
ashfield boys' high school
\n",
"
ashfield boys' high school
\n",
"
ashfield boys' high school
\n",
"
ashfield boys' high school
\n",
"
ashfield boys' high school
\n",
"
ashfield boys' high school
\n",
"
ashfield boys' high school
\n",
"
ashfield boys' high school
\n",
"
ashfield boys' high school
\n",
"
\n",
"
\n",
"
school type
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
non-grammar
\n",
"
\n",
"
\n",
"
address 1
\n",
"
holywood road
\n",
"
holywood road
\n",
"
holywood road
\n",
"
holywood road
\n",
"
holywood road
\n",
"
holywood road
\n",
"
395 holywood road
\n",
"
395 holywood road
\n",
"
395 holywood road
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt4 2ly
\n",
"
bt42ly
\n",
"
bt42ly
\n",
"
bt42ly
\n",
"
bt42ly
\n",
"
bt42ly
\n",
"
bt4 2ly
\n",
"
bt42ly
\n",
"
bt42ly
\n",
"
\n",
"
\n",
"
urban_rural
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
\n",
"
\n",
"
school management type
\n",
"
controlled
\n",
"
controlled
\n",
"
controlled
\n",
"
controlled
\n",
"
controlled
\n",
"
controlled
\n",
"
controlled
\n",
"
controlled
\n",
"
controlled
\n",
"
\n",
"
\n",
"
district council
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
\n",
"
\n",
"
parliamentary constituency
\n",
"
belfast east
\n",
"
belfast east
\n",
"
belfast east
\n",
"
belfast east
\n",
"
belfast east
\n",
"
belfast east
\n",
"
belfast east
\n",
"
belfast east
\n",
"
belfast east
\n",
"
\n",
"
\n",
"
town
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
\n",
"
\n",
"
1210021
\n",
"
school name
\n",
"
belfast model school for girls
\n",
"
belfast model school for girls
\n",
"
belfast model school for girls
\n",
"
belfast model school for girls
\n",
"
belfast model school for girls
\n",
"
belfast model school for girls
\n",
"
belfast model school for girls
\n",
"
belfast model school for girls
\n",
"
belfast model school for girls
\n",
"
\n",
"
\n",
"
school type
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
non-grammar
\n",
"
\n",
"
\n",
"
address 1
\n",
"
dunkeld gardens
\n",
"
dunkeld gardens
\n",
"
dunkeld gardens
\n",
"
dunkeld gardens
\n",
"
dunkeld gardens
\n",
"
dunkeld gardens
\n",
"
35 dunowen gardens
\n",
"
35 dunowen gardens
\n",
"
35 dunowen gardens
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt14 6nt
\n",
"
bt146nt
\n",
"
bt146nt
\n",
"
bt146nt
\n",
"
bt146nt
\n",
"
bt146nt
\n",
"
bt14 6nq
\n",
"
bt146nq
\n",
"
bt146nq
\n",
"
\n",
"
\n",
"
urban_rural
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
\n",
"
\n",
"
school management type
\n",
"
controlled
\n",
"
controlled
\n",
"
controlled
\n",
"
controlled
\n",
"
controlled
\n",
"
controlled
\n",
"
controlled
\n",
"
controlled
\n",
"
controlled
\n",
"
\n",
"
\n",
"
district council
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
\n",
"
\n",
"
parliamentary constituency
\n",
"
belfast north
\n",
"
belfast north
\n",
"
belfast north
\n",
"
belfast north
\n",
"
belfast north
\n",
"
belfast north
\n",
"
belfast north
\n",
"
belfast north
\n",
"
belfast north
\n",
"
\n",
"
\n",
"
town
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
belfast
\n",
"
\n",
"
\n",
"
1210022
\n",
"
school name
\n",
"
belfast boys' model school
\n",
"
belfast boys' model school
\n",
"
belfast boys' model school
\n",
"
belfast boys' model school
\n",
"
belfast boys' model school
\n",
"
belfast boys' model school
\n",
"
belfast boys' model school
\n",
"
belfast boys' model school
\n",
"
belfast boys' model school
\n",
"
\n",
"
\n",
"
school type
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
non-grammar
\n",
"
\n",
"
\n",
"
address 1
\n",
"
ballysillan road
\n",
"
ballysillan road
\n",
"
ballysillan road
\n",
"
ballysillan road
\n",
"
ballysillan road
\n",
"
ballysillan road
\n",
"
ballysillan road
\n",
"
ballysillan road
\n",
"
ballysillan road
\n",
"
\n",
"
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
\n",
"
\n",
"
5420260
\n",
"
district council
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
mid ulster
\n",
"
mid ulster
\n",
"
mid ulster
\n",
"
\n",
"
\n",
"
parliamentary constituency
\n",
"
fermanagh and south tyrone
\n",
"
fermanagh and south tyrone
\n",
"
fermanagh and south tyrone
\n",
"
fermanagh and south tyrone
\n",
"
fermanagh and south tyrone
\n",
"
fermanagh and south tyrone
\n",
"
fermanagh and south tyrone
\n",
"
fermanagh and south tyrone
\n",
"
fermanagh and south tyrone
\n",
"
\n",
"
\n",
"
town
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
\n",
"
\n",
"
5420263
\n",
"
school name
\n",
"
the royal school armagh
\n",
"
the royal school armagh
\n",
"
the royal school armagh
\n",
"
the royal school armagh
\n",
"
the royal school armagh
\n",
"
the royal school, armagh
\n",
"
the royal school, armagh
\n",
"
the royal school, armagh
\n",
"
the royal school, armagh
\n",
"
\n",
"
\n",
"
school type
\n",
"
grammar
\n",
"
grammar
\n",
"
grammar
\n",
"
grammar
\n",
"
grammar
\n",
"
grammar
\n",
"
grammar
\n",
"
grammar
\n",
"
grammar
\n",
"
\n",
"
\n",
"
address 1
\n",
"
college hill
\n",
"
college hill
\n",
"
college hill
\n",
"
college hill
\n",
"
college hill
\n",
"
college hill
\n",
"
college hill
\n",
"
college hill
\n",
"
college hill
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt61 9dh
\n",
"
bt619dh
\n",
"
bt619dh
\n",
"
bt619dh
\n",
"
bt619dh
\n",
"
bt619dh
\n",
"
bt61 9dh
\n",
"
bt619dh
\n",
"
bt619dh
\n",
"
\n",
"
\n",
"
urban_rural
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
\n",
"
\n",
"
school management type
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary - other managed
\n",
"
voluntary - other managed
\n",
"
voluntary - other managed
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary
\n",
"
\n",
"
\n",
"
district council
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh city, banbridge and craigavon
\n",
"
armagh city, banbridge and craigavon
\n",
"
armagh city, banbridge and craigavon
\n",
"
\n",
"
\n",
"
parliamentary constituency
\n",
"
newry and armagh
\n",
"
newry and armagh
\n",
"
newry and armagh
\n",
"
newry and armagh
\n",
"
newry and armagh
\n",
"
newry and armagh
\n",
"
newry and armagh
\n",
"
newry and armagh
\n",
"
newry and armagh
\n",
"
\n",
"
\n",
"
town
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
\n",
"
\n",
"
5420268
\n",
"
school name
\n",
"
st patrick's grammar school
\n",
"
st patrick's grammar school
\n",
"
st patrick's grammar school
\n",
"
st patrick's grammar school
\n",
"
st patrick's grammar school
\n",
"
st patrick's grammar school, armagh
\n",
"
st patrick's grammar school, armagh
\n",
"
st patrick's grammar school, armagh
\n",
"
st patrick's grammar school, armagh
\n",
"
\n",
"
\n",
"
school type
\n",
"
grammar
\n",
"
grammar
\n",
"
grammar
\n",
"
grammar
\n",
"
grammar
\n",
"
grammar
\n",
"
grammar
\n",
"
grammar
\n",
"
grammar
\n",
"
\n",
"
\n",
"
address 1
\n",
"
cathedral road
\n",
"
cathedral road
\n",
"
cathedral road
\n",
"
cathedral road
\n",
"
cathedral road
\n",
"
cathedral road
\n",
"
cathedral road
\n",
"
cathedral road
\n",
"
cathedral road
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt61 7qz
\n",
"
bt617qz
\n",
"
bt617qz
\n",
"
bt617qz
\n",
"
bt617qz
\n",
"
bt617qz
\n",
"
bt61 7qz
\n",
"
bt617qz
\n",
"
bt617qz
\n",
"
\n",
"
\n",
"
urban_rural
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
\n",
"
\n",
"
school management type
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary - rc managed
\n",
"
voluntary - rc managed
\n",
"
voluntary - rc managed
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary
\n",
"
\n",
"
\n",
"
district council
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh city, banbridge and craigavon
\n",
"
armagh city, banbridge and craigavon
\n",
"
armagh city, banbridge and craigavon
\n",
"
\n",
"
\n",
"
parliamentary constituency
\n",
"
newry and armagh
\n",
"
newry and armagh
\n",
"
newry and armagh
\n",
"
newry and armagh
\n",
"
newry and armagh
\n",
"
newry and armagh
\n",
"
newry and armagh
\n",
"
newry and armagh
\n",
"
newry and armagh
\n",
"
\n",
"
\n",
"
town
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
\n",
"
\n",
"
5420304
\n",
"
school name
\n",
"
st patrick's academy
\n",
"
st patrick's academy
\n",
"
st patrick's academy
\n",
"
st patrick's academy
\n",
"
st patrick's academy
\n",
"
st patrick's academy, dungannon
\n",
"
st patrick's academy, dungannon
\n",
"
st patrick's academy, dungannon
\n",
"
st patrick's academy, dungannon
\n",
"
\n",
"
\n",
"
school type
\n",
"
grammar
\n",
"
grammar
\n",
"
grammar
\n",
"
grammar
\n",
"
grammar
\n",
"
grammar
\n",
"
grammar
\n",
"
grammar
\n",
"
grammar
\n",
"
\n",
"
\n",
"
address 1
\n",
"
37 killymeal road
\n",
"
37 killymeal road
\n",
"
37 killymeal road
\n",
"
37 killymeal road
\n",
"
37 killymeal road
\n",
"
37 killymeal road
\n",
"
37 killymeal road
\n",
"
37 killymeal road
\n",
"
37 killymeal road
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt71 6ds
\n",
"
bt716ds
\n",
"
bt716ds
\n",
"
bt716ds
\n",
"
bt716ds
\n",
"
bt716ds
\n",
"
bt71 6ds
\n",
"
bt716ds
\n",
"
bt716ds
\n",
"
\n",
"
\n",
"
urban_rural
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
urban
\n",
"
\n",
"
\n",
"
school management type
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary - rc managed
\n",
"
voluntary - rc managed
\n",
"
voluntary - rc managed
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary
\n",
"
\n",
"
\n",
"
district council
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
mid ulster
\n",
"
mid ulster
\n",
"
mid ulster
\n",
"
\n",
"
\n",
"
parliamentary constituency
\n",
"
fermanagh and south tyrone
\n",
"
fermanagh and south tyrone
\n",
"
fermanagh and south tyrone
\n",
"
fermanagh and south tyrone
\n",
"
fermanagh and south tyrone
\n",
"
fermanagh and south tyrone
\n",
"
fermanagh and south tyrone
\n",
"
fermanagh and south tyrone
\n",
"
fermanagh and south tyrone
\n",
"
\n",
"
\n",
"
town
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
\n",
" \n",
"
\n",
"
1673 rows × 9 columns
\n",
"
"
],
"text/plain": [
" 2009 \\\n",
"de ref minor \n",
"1210014 school name ashfield girls' high school \n",
" school type secondary \n",
" address 1 holywood road \n",
" postcode bt4 2ly \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast east \n",
" town belfast \n",
"1210015 school name ashfield boys' high school \n",
" school type secondary \n",
" address 1 holywood road \n",
" postcode bt4 2ly \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast east \n",
" town belfast \n",
"1210021 school name belfast model school for girls \n",
" school type secondary \n",
" address 1 dunkeld gardens \n",
" postcode bt14 6nt \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast north \n",
" town belfast \n",
"1210022 school name belfast boys' model school \n",
" school type secondary \n",
" address 1 ballysillan road \n",
"... ... \n",
"5420260 district council dungannon \n",
" parliamentary constituency fermanagh and south tyrone \n",
" town dungannon \n",
"5420263 school name the royal school armagh \n",
" school type grammar \n",
" address 1 college hill \n",
" postcode bt61 9dh \n",
" urban_rural urban \n",
" school management type voluntary \n",
" district council armagh \n",
" parliamentary constituency newry and armagh \n",
" town armagh \n",
"5420268 school name st patrick's grammar school \n",
" school type grammar \n",
" address 1 cathedral road \n",
" postcode bt61 7qz \n",
" urban_rural urban \n",
" school management type voluntary \n",
" district council armagh \n",
" parliamentary constituency newry and armagh \n",
" town armagh \n",
"5420304 school name st patrick's academy \n",
" school type grammar \n",
" address 1 37 killymeal road \n",
" postcode bt71 6ds \n",
" urban_rural urban \n",
" school management type voluntary \n",
" district council dungannon \n",
" parliamentary constituency fermanagh and south tyrone \n",
" town dungannon \n",
"\n",
" 2010 \\\n",
"de ref minor \n",
"1210014 school name ashfield girls' high school \n",
" school type secondary \n",
" address 1 holywood road \n",
" postcode bt42ly \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast east \n",
" town belfast \n",
"1210015 school name ashfield boys' high school \n",
" school type secondary \n",
" address 1 holywood road \n",
" postcode bt42ly \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast east \n",
" town belfast \n",
"1210021 school name belfast model school for girls \n",
" school type secondary \n",
" address 1 dunkeld gardens \n",
" postcode bt146nt \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast north \n",
" town belfast \n",
"1210022 school name belfast boys' model school \n",
" school type secondary \n",
" address 1 ballysillan road \n",
"... ... \n",
"5420260 district council dungannon \n",
" parliamentary constituency fermanagh and south tyrone \n",
" town dungannon \n",
"5420263 school name the royal school armagh \n",
" school type grammar \n",
" address 1 college hill \n",
" postcode bt619dh \n",
" urban_rural urban \n",
" school management type voluntary \n",
" district council armagh \n",
" parliamentary constituency newry and armagh \n",
" town armagh \n",
"5420268 school name st patrick's grammar school \n",
" school type grammar \n",
" address 1 cathedral road \n",
" postcode bt617qz \n",
" urban_rural urban \n",
" school management type voluntary \n",
" district council armagh \n",
" parliamentary constituency newry and armagh \n",
" town armagh \n",
"5420304 school name st patrick's academy \n",
" school type grammar \n",
" address 1 37 killymeal road \n",
" postcode bt716ds \n",
" urban_rural urban \n",
" school management type voluntary \n",
" district council dungannon \n",
" parliamentary constituency fermanagh and south tyrone \n",
" town dungannon \n",
"\n",
" 2011 \\\n",
"de ref minor \n",
"1210014 school name ashfield girls' high school \n",
" school type secondary \n",
" address 1 holywood road \n",
" postcode bt42ly \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast east \n",
" town belfast \n",
"1210015 school name ashfield boys' high school \n",
" school type secondary \n",
" address 1 holywood road \n",
" postcode bt42ly \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast east \n",
" town belfast \n",
"1210021 school name belfast model school for girls \n",
" school type secondary \n",
" address 1 dunkeld gardens \n",
" postcode bt146nt \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast north \n",
" town belfast \n",
"1210022 school name belfast boys' model school \n",
" school type secondary \n",
" address 1 ballysillan road \n",
"... ... \n",
"5420260 district council dungannon \n",
" parliamentary constituency fermanagh and south tyrone \n",
" town dungannon \n",
"5420263 school name the royal school armagh \n",
" school type grammar \n",
" address 1 college hill \n",
" postcode bt619dh \n",
" urban_rural urban \n",
" school management type voluntary - other managed \n",
" district council armagh \n",
" parliamentary constituency newry and armagh \n",
" town armagh \n",
"5420268 school name st patrick's grammar school \n",
" school type grammar \n",
" address 1 cathedral road \n",
" postcode bt617qz \n",
" urban_rural urban \n",
" school management type voluntary - rc managed \n",
" district council armagh \n",
" parliamentary constituency newry and armagh \n",
" town armagh \n",
"5420304 school name st patrick's academy \n",
" school type grammar \n",
" address 1 37 killymeal road \n",
" postcode bt716ds \n",
" urban_rural urban \n",
" school management type voluntary - rc managed \n",
" district council dungannon \n",
" parliamentary constituency fermanagh and south tyrone \n",
" town dungannon \n",
"\n",
" 2012 \\\n",
"de ref minor \n",
"1210014 school name ashfield girls' high school \n",
" school type secondary \n",
" address 1 holywood road \n",
" postcode bt42ly \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast east \n",
" town belfast \n",
"1210015 school name ashfield boys' high school \n",
" school type secondary \n",
" address 1 holywood road \n",
" postcode bt42ly \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast east \n",
" town belfast \n",
"1210021 school name belfast model school for girls \n",
" school type secondary \n",
" address 1 dunkeld gardens \n",
" postcode bt146nt \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast north \n",
" town belfast \n",
"1210022 school name belfast boys' model school \n",
" school type secondary \n",
" address 1 ballysillan road \n",
"... ... \n",
"5420260 district council dungannon \n",
" parliamentary constituency fermanagh and south tyrone \n",
" town dungannon \n",
"5420263 school name the royal school armagh \n",
" school type grammar \n",
" address 1 college hill \n",
" postcode bt619dh \n",
" urban_rural urban \n",
" school management type voluntary - other managed \n",
" district council armagh \n",
" parliamentary constituency newry and armagh \n",
" town armagh \n",
"5420268 school name st patrick's grammar school \n",
" school type grammar \n",
" address 1 cathedral road \n",
" postcode bt617qz \n",
" urban_rural urban \n",
" school management type voluntary - rc managed \n",
" district council armagh \n",
" parliamentary constituency newry and armagh \n",
" town armagh \n",
"5420304 school name st patrick's academy \n",
" school type grammar \n",
" address 1 37 killymeal road \n",
" postcode bt716ds \n",
" urban_rural urban \n",
" school management type voluntary - rc managed \n",
" district council dungannon \n",
" parliamentary constituency fermanagh and south tyrone \n",
" town dungannon \n",
"\n",
" 2013 \\\n",
"de ref minor \n",
"1210014 school name ashfield girls' high school \n",
" school type secondary \n",
" address 1 holywood road \n",
" postcode bt42ly \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast east \n",
" town belfast \n",
"1210015 school name ashfield boys' high school \n",
" school type secondary \n",
" address 1 holywood road \n",
" postcode bt42ly \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast east \n",
" town belfast \n",
"1210021 school name belfast model school for girls \n",
" school type secondary \n",
" address 1 dunkeld gardens \n",
" postcode bt146nt \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast north \n",
" town belfast \n",
"1210022 school name belfast boys' model school \n",
" school type secondary \n",
" address 1 ballysillan road \n",
"... ... \n",
"5420260 district council dungannon \n",
" parliamentary constituency fermanagh and south tyrone \n",
" town dungannon \n",
"5420263 school name the royal school armagh \n",
" school type grammar \n",
" address 1 college hill \n",
" postcode bt619dh \n",
" urban_rural urban \n",
" school management type voluntary - other managed \n",
" district council armagh \n",
" parliamentary constituency newry and armagh \n",
" town armagh \n",
"5420268 school name st patrick's grammar school \n",
" school type grammar \n",
" address 1 cathedral road \n",
" postcode bt617qz \n",
" urban_rural urban \n",
" school management type voluntary - rc managed \n",
" district council armagh \n",
" parliamentary constituency newry and armagh \n",
" town armagh \n",
"5420304 school name st patrick's academy \n",
" school type grammar \n",
" address 1 37 killymeal road \n",
" postcode bt716ds \n",
" urban_rural urban \n",
" school management type voluntary - rc managed \n",
" district council dungannon \n",
" parliamentary constituency fermanagh and south tyrone \n",
" town dungannon \n",
"\n",
" 2014 \\\n",
"de ref minor \n",
"1210014 school name ashfield girls' high school \n",
" school type secondary \n",
" address 1 holywood road \n",
" postcode bt42ly \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast east \n",
" town belfast \n",
"1210015 school name ashfield boys' high school \n",
" school type secondary \n",
" address 1 holywood road \n",
" postcode bt42ly \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast east \n",
" town belfast \n",
"1210021 school name belfast model school for girls \n",
" school type secondary \n",
" address 1 dunkeld gardens \n",
" postcode bt146nt \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast north \n",
" town belfast \n",
"1210022 school name belfast boys' model school \n",
" school type secondary \n",
" address 1 ballysillan road \n",
"... ... \n",
"5420260 district council dungannon \n",
" parliamentary constituency fermanagh and south tyrone \n",
" town dungannon \n",
"5420263 school name the royal school, armagh \n",
" school type grammar \n",
" address 1 college hill \n",
" postcode bt619dh \n",
" urban_rural urban \n",
" school management type voluntary \n",
" district council armagh \n",
" parliamentary constituency newry and armagh \n",
" town armagh \n",
"5420268 school name st patrick's grammar school, armagh \n",
" school type grammar \n",
" address 1 cathedral road \n",
" postcode bt617qz \n",
" urban_rural urban \n",
" school management type voluntary \n",
" district council armagh \n",
" parliamentary constituency newry and armagh \n",
" town armagh \n",
"5420304 school name st patrick's academy, dungannon \n",
" school type grammar \n",
" address 1 37 killymeal road \n",
" postcode bt716ds \n",
" urban_rural urban \n",
" school management type voluntary \n",
" district council dungannon \n",
" parliamentary constituency fermanagh and south tyrone \n",
" town dungannon \n",
"\n",
" 2015 \\\n",
"de ref minor \n",
"1210014 school name ashfield girls' high school \n",
" school type secondary \n",
" address 1 397 holywood road \n",
" postcode bt4 2ly \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast east \n",
" town belfast \n",
"1210015 school name ashfield boys' high school \n",
" school type secondary \n",
" address 1 395 holywood road \n",
" postcode bt4 2ly \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast east \n",
" town belfast \n",
"1210021 school name belfast model school for girls \n",
" school type secondary \n",
" address 1 35 dunowen gardens \n",
" postcode bt14 6nq \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast north \n",
" town belfast \n",
"1210022 school name belfast boys' model school \n",
" school type secondary \n",
" address 1 ballysillan road \n",
"... ... \n",
"5420260 district council mid ulster \n",
" parliamentary constituency fermanagh and south tyrone \n",
" town dungannon \n",
"5420263 school name the royal school, armagh \n",
" school type grammar \n",
" address 1 college hill \n",
" postcode bt61 9dh \n",
" urban_rural urban \n",
" school management type voluntary \n",
" district council armagh city, banbridge and craigavon \n",
" parliamentary constituency newry and armagh \n",
" town armagh \n",
"5420268 school name st patrick's grammar school, armagh \n",
" school type grammar \n",
" address 1 cathedral road \n",
" postcode bt61 7qz \n",
" urban_rural urban \n",
" school management type voluntary \n",
" district council armagh city, banbridge and craigavon \n",
" parliamentary constituency newry and armagh \n",
" town armagh \n",
"5420304 school name st patrick's academy, dungannon \n",
" school type grammar \n",
" address 1 37 killymeal road \n",
" postcode bt71 6ds \n",
" urban_rural urban \n",
" school management type voluntary \n",
" district council mid ulster \n",
" parliamentary constituency fermanagh and south tyrone \n",
" town dungannon \n",
"\n",
" 2016 \\\n",
"de ref minor \n",
"1210014 school name ashfield girls' high school \n",
" school type secondary \n",
" address 1 397 holywood road \n",
" postcode bt42ly \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast east \n",
" town belfast \n",
"1210015 school name ashfield boys' high school \n",
" school type secondary \n",
" address 1 395 holywood road \n",
" postcode bt42ly \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast east \n",
" town belfast \n",
"1210021 school name belfast model school for girls \n",
" school type secondary \n",
" address 1 35 dunowen gardens \n",
" postcode bt146nq \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast north \n",
" town belfast \n",
"1210022 school name belfast boys' model school \n",
" school type secondary \n",
" address 1 ballysillan road \n",
"... ... \n",
"5420260 district council mid ulster \n",
" parliamentary constituency fermanagh and south tyrone \n",
" town dungannon \n",
"5420263 school name the royal school, armagh \n",
" school type grammar \n",
" address 1 college hill \n",
" postcode bt619dh \n",
" urban_rural urban \n",
" school management type voluntary \n",
" district council armagh city, banbridge and craigavon \n",
" parliamentary constituency newry and armagh \n",
" town armagh \n",
"5420268 school name st patrick's grammar school, armagh \n",
" school type grammar \n",
" address 1 cathedral road \n",
" postcode bt617qz \n",
" urban_rural urban \n",
" school management type voluntary \n",
" district council armagh city, banbridge and craigavon \n",
" parliamentary constituency newry and armagh \n",
" town armagh \n",
"5420304 school name st patrick's academy, dungannon \n",
" school type grammar \n",
" address 1 37 killymeal road \n",
" postcode bt716ds \n",
" urban_rural urban \n",
" school management type voluntary \n",
" district council mid ulster \n",
" parliamentary constituency fermanagh and south tyrone \n",
" town dungannon \n",
"\n",
" 2017 \n",
"de ref minor \n",
"1210014 school name ashfield girls' high school \n",
" school type non-grammar \n",
" address 1 397 holywood road \n",
" postcode bt42ly \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast east \n",
" town belfast \n",
"1210015 school name ashfield boys' high school \n",
" school type non-grammar \n",
" address 1 395 holywood road \n",
" postcode bt42ly \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast east \n",
" town belfast \n",
"1210021 school name belfast model school for girls \n",
" school type non-grammar \n",
" address 1 35 dunowen gardens \n",
" postcode bt146nq \n",
" urban_rural urban \n",
" school management type controlled \n",
" district council belfast \n",
" parliamentary constituency belfast north \n",
" town belfast \n",
"1210022 school name belfast boys' model school \n",
" school type non-grammar \n",
" address 1 ballysillan road \n",
"... ... \n",
"5420260 district council mid ulster \n",
" parliamentary constituency fermanagh and south tyrone \n",
" town dungannon \n",
"5420263 school name the royal school, armagh \n",
" school type grammar \n",
" address 1 college hill \n",
" postcode bt619dh \n",
" urban_rural urban \n",
" school management type voluntary \n",
" district council armagh city, banbridge and craigavon \n",
" parliamentary constituency newry and armagh \n",
" town armagh \n",
"5420268 school name st patrick's grammar school, armagh \n",
" school type grammar \n",
" address 1 cathedral road \n",
" postcode bt617qz \n",
" urban_rural urban \n",
" school management type voluntary \n",
" district council armagh city, banbridge and craigavon \n",
" parliamentary constituency newry and armagh \n",
" town armagh \n",
"5420304 school name st patrick's academy, dungannon \n",
" school type grammar \n",
" address 1 37 killymeal road \n",
" postcode bt716ds \n",
" urban_rural urban \n",
" school management type voluntary \n",
" district council mid ulster \n",
" parliamentary constituency fermanagh and south tyrone \n",
" town dungannon \n",
"\n",
"[1673 rows x 9 columns]"
]
},
"execution_count": 93,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"reference.to_frame()"
]
},
{
"cell_type": "code",
"execution_count": 94,
"metadata": {
"ExecuteTime": {
"end_time": "2018-06-07T10:39:09.561567Z",
"start_time": "2018-06-07T10:39:09.318581Z"
}
},
"outputs": [
{
"data": {
"text/plain": [
"de ref minor \n",
"1210014 school name False\n",
" school type True\n",
" address 1 True\n",
" postcode True\n",
" urban_rural False\n",
" school management type False\n",
" district council False\n",
" parliamentary constituency False\n",
" town False\n",
"1210015 school name False\n",
" school type True\n",
" address 1 True\n",
" postcode True\n",
" urban_rural False\n",
" school management type False\n",
" district council False\n",
" parliamentary constituency False\n",
" town False\n",
"1210021 school name False\n",
" school type True\n",
" address 1 True\n",
" postcode True\n",
" urban_rural False\n",
" school management type False\n",
" district council False\n",
" parliamentary constituency False\n",
" town False\n",
"1210022 school name False\n",
" school type True\n",
" address 1 False\n",
" ... \n",
"5420260 district council True\n",
" parliamentary constituency False\n",
" town False\n",
"5420263 school name True\n",
" school type False\n",
" address 1 False\n",
" postcode True\n",
" urban_rural False\n",
" school management type True\n",
" district council True\n",
" parliamentary constituency False\n",
" town False\n",
"5420268 school name True\n",
" school type False\n",
" address 1 False\n",
" postcode True\n",
" urban_rural False\n",
" school management type True\n",
" district council True\n",
" parliamentary constituency False\n",
" town False\n",
"5420304 school name True\n",
" school type False\n",
" address 1 False\n",
" postcode True\n",
" urban_rural False\n",
" school management type True\n",
" district council True\n",
" parliamentary constituency False\n",
" town False\n",
"Length: 1673, dtype: bool"
]
},
"execution_count": 94,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"reference.to_frame().apply(pd.Series.nunique, axis=1)!=1"
]
},
{
"cell_type": "code",
"execution_count": 95,
"metadata": {
"ExecuteTime": {
"end_time": "2018-06-07T10:39:14.189085Z",
"start_time": "2018-06-07T10:39:13.924233Z"
}
},
"outputs": [
{
"data": {
"text/plain": [
"minor\n",
"school name 252.0\n",
"school type 311.0\n",
"address 1 241.0\n",
"postcode 408.0\n",
"urban_rural 195.0\n",
"school management type 364.0\n",
"district council 365.0\n",
"parliamentary constituency 198.0\n",
"town 187.0\n",
"dtype: float64"
]
},
"execution_count": 95,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"reference.to_frame().apply(pd.Series.nunique, axis=1).unstack('minor').sum()"
]
},
{
"cell_type": "code",
"execution_count": 96,
"metadata": {
"ExecuteTime": {
"end_time": "2018-06-07T10:39:14.615892Z",
"start_time": "2018-06-07T10:39:14.346792Z"
}
},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
"
\n",
"
\n",
"
\n",
"
2009
\n",
"
2010
\n",
"
2011
\n",
"
2012
\n",
"
2013
\n",
"
2014
\n",
"
2015
\n",
"
2016
\n",
"
2017
\n",
"
\n",
"
\n",
"
de ref
\n",
"
minor
\n",
"
\n",
"
\n",
"
\n",
"
\n",
"
\n",
"
\n",
"
\n",
"
\n",
"
\n",
"
\n",
" \n",
" \n",
"
\n",
"
1210014
\n",
"
school type
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
non-grammar
\n",
"
\n",
"
\n",
"
address 1
\n",
"
holywood road
\n",
"
holywood road
\n",
"
holywood road
\n",
"
holywood road
\n",
"
holywood road
\n",
"
holywood road
\n",
"
397 holywood road
\n",
"
397 holywood road
\n",
"
397 holywood road
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt4 2ly
\n",
"
bt42ly
\n",
"
bt42ly
\n",
"
bt42ly
\n",
"
bt42ly
\n",
"
bt42ly
\n",
"
bt4 2ly
\n",
"
bt42ly
\n",
"
bt42ly
\n",
"
\n",
"
\n",
"
1210015
\n",
"
school type
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
non-grammar
\n",
"
\n",
"
\n",
"
address 1
\n",
"
holywood road
\n",
"
holywood road
\n",
"
holywood road
\n",
"
holywood road
\n",
"
holywood road
\n",
"
holywood road
\n",
"
395 holywood road
\n",
"
395 holywood road
\n",
"
395 holywood road
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt4 2ly
\n",
"
bt42ly
\n",
"
bt42ly
\n",
"
bt42ly
\n",
"
bt42ly
\n",
"
bt42ly
\n",
"
bt4 2ly
\n",
"
bt42ly
\n",
"
bt42ly
\n",
"
\n",
"
\n",
"
1210021
\n",
"
school type
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
non-grammar
\n",
"
\n",
"
\n",
"
address 1
\n",
"
dunkeld gardens
\n",
"
dunkeld gardens
\n",
"
dunkeld gardens
\n",
"
dunkeld gardens
\n",
"
dunkeld gardens
\n",
"
dunkeld gardens
\n",
"
35 dunowen gardens
\n",
"
35 dunowen gardens
\n",
"
35 dunowen gardens
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt14 6nt
\n",
"
bt146nt
\n",
"
bt146nt
\n",
"
bt146nt
\n",
"
bt146nt
\n",
"
bt146nt
\n",
"
bt14 6nq
\n",
"
bt146nq
\n",
"
bt146nq
\n",
"
\n",
"
\n",
"
1210022
\n",
"
school type
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
non-grammar
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt14 6rb
\n",
"
bt146rb
\n",
"
bt146rb
\n",
"
bt146rb
\n",
"
bt146rb
\n",
"
bt146rb
\n",
"
bt14 6rb
\n",
"
bt146rb
\n",
"
bt146rb
\n",
"
\n",
"
\n",
"
1230053
\n",
"
school type
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
non-grammar
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt12 6en
\n",
"
bt126en
\n",
"
bt126en
\n",
"
bt126en
\n",
"
bt126en
\n",
"
bt126en
\n",
"
bt12 6en
\n",
"
bt126en
\n",
"
bt126en
\n",
"
\n",
"
\n",
"
school management type
\n",
"
rc maintained
\n",
"
roman catholic maintained
\n",
"
rc maintained
\n",
"
rc maintained
\n",
"
rc maintained
\n",
"
catholic maintained
\n",
"
catholic maintained
\n",
"
catholic maintained
\n",
"
catholic maintained
\n",
"
\n",
"
\n",
"
1230104
\n",
"
school name
\n",
"
our lady of mercy girls' school
\n",
"
our lady of mercy girls' school
\n",
"
our lady of mercy girls' school
\n",
"
our lady of mercy girls' school
\n",
"
our lady of mercy girls' school
\n",
"
mercy college
\n",
"
mercy college
\n",
"
mercy college
\n",
"
mercy college belfast
\n",
"
\n",
"
\n",
"
school type
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
non-grammar
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt14 7qr
\n",
"
bt147qr
\n",
"
bt147qr
\n",
"
bt147qr
\n",
"
bt147qr
\n",
"
bt147qr
\n",
"
bt14 7qr
\n",
"
bt147qr
\n",
"
bt147qr
\n",
"
\n",
"
\n",
"
school management type
\n",
"
rc maintained
\n",
"
roman catholic maintained
\n",
"
rc maintained
\n",
"
rc maintained
\n",
"
rc maintained
\n",
"
catholic maintained
\n",
"
catholic maintained
\n",
"
catholic maintained
\n",
"
catholic maintained
\n",
"
\n",
"
\n",
"
1230130
\n",
"
school name
\n",
"
st rose's high school
\n",
"
st rose's high school
\n",
"
st rose's high school
\n",
"
st rose's high school
\n",
"
st rose's high school
\n",
"
st rose’s dominican college
\n",
"
st rose’s dominican college
\n",
"
st rose’s dominican college
\n",
"
st rose’s dominican college
\n",
"
\n",
"
\n",
"
school type
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
non-grammar
\n",
"
\n",
"
\n",
"
address 1
\n",
"
beechmount avenue
\n",
"
beechmount avenue
\n",
"
beechmount avenue
\n",
"
beechmount avenue
\n",
"
beechmount avenue
\n",
"
beechmount avenue
\n",
"
65 beechmount avenue
\n",
"
65 beechmount avenue
\n",
"
65 beechmount avenue
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt12 7na
\n",
"
bt127na
\n",
"
bt127na
\n",
"
bt127na
\n",
"
bt127na
\n",
"
bt127na
\n",
"
bt12 7na
\n",
"
bt127na
\n",
"
bt127na
\n",
"
\n",
"
\n",
"
school management type
\n",
"
rc maintained
\n",
"
roman catholic maintained
\n",
"
rc maintained
\n",
"
rc maintained
\n",
"
rc maintained
\n",
"
catholic maintained
\n",
"
catholic maintained
\n",
"
catholic maintained
\n",
"
catholic maintained
\n",
"
\n",
"
\n",
"
1230146
\n",
"
school name
\n",
"
christian brothers school
\n",
"
christian brothers school
\n",
"
christian brothers school
\n",
"
christian brothers school
\n",
"
christian brothers school
\n",
"
christian brothers school, belfast
\n",
"
christian brothers school, belfast
\n",
"
christian brothers school, belfast
\n",
"
christian brothers school, belfast
\n",
"
\n",
"
\n",
"
school type
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
non-grammar
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt11 8bw
\n",
"
bt118bw
\n",
"
bt118bw
\n",
"
bt118bw
\n",
"
bt118bw
\n",
"
bt118bw
\n",
"
bt11 8bw
\n",
"
bt118bw
\n",
"
bt118bw
\n",
"
\n",
"
\n",
"
school management type
\n",
"
rc maintained
\n",
"
roman catholic maintained
\n",
"
rc maintained
\n",
"
rc maintained
\n",
"
rc maintained
\n",
"
catholic maintained
\n",
"
catholic maintained
\n",
"
catholic maintained
\n",
"
catholic maintained
\n",
"
\n",
"
\n",
"
1230155
\n",
"
school type
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
secondary
\n",
"
non-grammar
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt11 9jp
\n",
"
bt119jp
\n",
"
bt119jp
\n",
"
bt119jp
\n",
"
bt119jp
\n",
"
bt119jp
\n",
"
bt11 9jp
\n",
"
bt119jp
\n",
"
bt119jp
\n",
"
\n",
"
\n",
"
school management type
\n",
"
rc maintained
\n",
"
roman catholic maintained
\n",
"
rc maintained
\n",
"
rc maintained
\n",
"
rc maintained
\n",
"
catholic maintained
\n",
"
catholic maintained
\n",
"
catholic maintained
\n",
"
catholic maintained
\n",
"
\n",
"
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
\n",
"
\n",
"
5420062
\n",
"
school name
\n",
"
st colman's college
\n",
"
st colman's college
\n",
"
st colman's college
\n",
"
st colman's college
\n",
"
st colman's college
\n",
"
st colman's college, newry
\n",
"
st colman's college, newry
\n",
"
st colman's college, newry
\n",
"
st colman's college, newry
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt35 6pp
\n",
"
bt356pp
\n",
"
bt356pp
\n",
"
bt356pp
\n",
"
bt356pp
\n",
"
bt356pp
\n",
"
bt35 6pp
\n",
"
bt356pp
\n",
"
bt356pp
\n",
"
\n",
"
\n",
"
school management type
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary - rc managed
\n",
"
voluntary - rc managed
\n",
"
voluntary - rc managed
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary
\n",
"
\n",
"
\n",
"
district council
\n",
"
newry & mourne
\n",
"
newry & mourne
\n",
"
newry and mourne
\n",
"
newry and mourne
\n",
"
newry and mourne
\n",
"
newry and mourne
\n",
"
newry mourne and down
\n",
"
newry mourne and down
\n",
"
newry mourne and down
\n",
"
\n",
"
\n",
"
5420073
\n",
"
school name
\n",
"
st joseph's grammar school
\n",
"
st joseph's grammar school
\n",
"
st joseph's grammar school
\n",
"
st joseph's grammar school
\n",
"
st joseph's grammar school
\n",
"
st joseph's convent grammar school, donaghmore
\n",
"
st joseph's convent grammar school, donaghmore
\n",
"
st joseph's convent grammar school, donaghmore
\n",
"
st joseph's convent grammar school, donaghmore
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt70 3he
\n",
"
bt703he
\n",
"
bt703he
\n",
"
bt703he
\n",
"
bt703he
\n",
"
bt703he
\n",
"
bt70 3he
\n",
"
bt703he
\n",
"
bt703he
\n",
"
\n",
"
\n",
"
school management type
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary - rc managed
\n",
"
voluntary - rc managed
\n",
"
voluntary - rc managed
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary
\n",
"
\n",
"
\n",
"
district council
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
mid ulster
\n",
"
mid ulster
\n",
"
mid ulster
\n",
"
\n",
"
\n",
"
5420076
\n",
"
school name
\n",
"
sacred heart grammar school
\n",
"
sacred heart grammar school
\n",
"
sacred heart grammar school
\n",
"
sacred heart grammar school
\n",
"
sacred heart grammar school
\n",
"
sacred heart grammar school, newry
\n",
"
sacred heart grammar school, newry
\n",
"
sacred heart grammar school, newry
\n",
"
sacred heart grammar school, newry
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt34 1pr
\n",
"
bt341pr
\n",
"
bt341pr
\n",
"
bt341pr
\n",
"
bt341pr
\n",
"
bt341pr
\n",
"
bt34 1pr
\n",
"
bt341pr
\n",
"
bt341pr
\n",
"
\n",
"
\n",
"
school management type
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary - rc managed
\n",
"
voluntary - rc managed
\n",
"
voluntary - rc managed
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary
\n",
"
\n",
"
\n",
"
district council
\n",
"
newry & mourne
\n",
"
newry & mourne
\n",
"
newry and mourne
\n",
"
newry and mourne
\n",
"
newry and mourne
\n",
"
newry and mourne
\n",
"
newry mourne and down
\n",
"
newry mourne and down
\n",
"
newry mourne and down
\n",
"
\n",
"
\n",
"
parliamentary constituency
\n",
"
newry and armagh
\n",
"
newry and armagh
\n",
"
south down
\n",
"
south down
\n",
"
south down
\n",
"
south down
\n",
"
south down
\n",
"
south down
\n",
"
south down
\n",
"
\n",
"
\n",
"
5420260
\n",
"
school name
\n",
"
the royal school dungannon
\n",
"
the royal school dungannon
\n",
"
the royal school dungannon
\n",
"
the royal school dungannon
\n",
"
the royal school dungannon
\n",
"
the royal school, dungannon
\n",
"
the royal school, dungannon
\n",
"
the royal school, dungannon
\n",
"
the royal school, dungannon
\n",
"
\n",
"
\n",
"
address 1
\n",
"
1 ranfurley road
\n",
"
1 ranfurley road
\n",
"
1 ranfurley road
\n",
"
1 ranfurley road
\n",
"
1 ranfurley road
\n",
"
1 ranfurley road
\n",
"
2 ranfurley road
\n",
"
2 ranfurley road
\n",
"
2 ranfurley road
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt71 6ap
\n",
"
bt716ap
\n",
"
bt716ap
\n",
"
bt716ap
\n",
"
bt716ap
\n",
"
bt716ap
\n",
"
bt71 6ap
\n",
"
bt716ap
\n",
"
bt716ap
\n",
"
\n",
"
\n",
"
school management type
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary - other managed
\n",
"
voluntary - other managed
\n",
"
voluntary - other managed
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary
\n",
"
\n",
"
\n",
"
district council
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
mid ulster
\n",
"
mid ulster
\n",
"
mid ulster
\n",
"
\n",
"
\n",
"
5420263
\n",
"
school name
\n",
"
the royal school armagh
\n",
"
the royal school armagh
\n",
"
the royal school armagh
\n",
"
the royal school armagh
\n",
"
the royal school armagh
\n",
"
the royal school, armagh
\n",
"
the royal school, armagh
\n",
"
the royal school, armagh
\n",
"
the royal school, armagh
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt61 9dh
\n",
"
bt619dh
\n",
"
bt619dh
\n",
"
bt619dh
\n",
"
bt619dh
\n",
"
bt619dh
\n",
"
bt61 9dh
\n",
"
bt619dh
\n",
"
bt619dh
\n",
"
\n",
"
\n",
"
school management type
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary - other managed
\n",
"
voluntary - other managed
\n",
"
voluntary - other managed
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary
\n",
"
\n",
"
\n",
"
district council
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh city, banbridge and craigavon
\n",
"
armagh city, banbridge and craigavon
\n",
"
armagh city, banbridge and craigavon
\n",
"
\n",
"
\n",
"
5420268
\n",
"
school name
\n",
"
st patrick's grammar school
\n",
"
st patrick's grammar school
\n",
"
st patrick's grammar school
\n",
"
st patrick's grammar school
\n",
"
st patrick's grammar school
\n",
"
st patrick's grammar school, armagh
\n",
"
st patrick's grammar school, armagh
\n",
"
st patrick's grammar school, armagh
\n",
"
st patrick's grammar school, armagh
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt61 7qz
\n",
"
bt617qz
\n",
"
bt617qz
\n",
"
bt617qz
\n",
"
bt617qz
\n",
"
bt617qz
\n",
"
bt61 7qz
\n",
"
bt617qz
\n",
"
bt617qz
\n",
"
\n",
"
\n",
"
school management type
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary - rc managed
\n",
"
voluntary - rc managed
\n",
"
voluntary - rc managed
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary
\n",
"
\n",
"
\n",
"
district council
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh
\n",
"
armagh city, banbridge and craigavon
\n",
"
armagh city, banbridge and craigavon
\n",
"
armagh city, banbridge and craigavon
\n",
"
\n",
"
\n",
"
5420304
\n",
"
school name
\n",
"
st patrick's academy
\n",
"
st patrick's academy
\n",
"
st patrick's academy
\n",
"
st patrick's academy
\n",
"
st patrick's academy
\n",
"
st patrick's academy, dungannon
\n",
"
st patrick's academy, dungannon
\n",
"
st patrick's academy, dungannon
\n",
"
st patrick's academy, dungannon
\n",
"
\n",
"
\n",
"
postcode
\n",
"
bt71 6ds
\n",
"
bt716ds
\n",
"
bt716ds
\n",
"
bt716ds
\n",
"
bt716ds
\n",
"
bt716ds
\n",
"
bt71 6ds
\n",
"
bt716ds
\n",
"
bt716ds
\n",
"
\n",
"
\n",
"
school management type
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary - rc managed
\n",
"
voluntary - rc managed
\n",
"
voluntary - rc managed
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary
\n",
"
voluntary
\n",
"
\n",
"
\n",
"
district council
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
dungannon
\n",
"
mid ulster
\n",
"
mid ulster
\n",
"
mid ulster
\n",
"
\n",
" \n",
"
\n",
"
723 rows × 9 columns
\n",
"
"
],
"text/plain": [
" 2009 \\\n",
"de ref minor \n",
"1210014 school type secondary \n",
" address 1 holywood road \n",
" postcode bt4 2ly \n",
"1210015 school type secondary \n",
" address 1 holywood road \n",
" postcode bt4 2ly \n",
"1210021 school type secondary \n",
" address 1 dunkeld gardens \n",
" postcode bt14 6nt \n",
"1210022 school type secondary \n",
" postcode bt14 6rb \n",
"1230053 school type secondary \n",
" postcode bt12 6en \n",
" school management type rc maintained \n",
"1230104 school name our lady of mercy girls' school \n",
" school type secondary \n",
" postcode bt14 7qr \n",
" school management type rc maintained \n",
"1230130 school name st rose's high school \n",
" school type secondary \n",
" address 1 beechmount avenue \n",
" postcode bt12 7na \n",
" school management type rc maintained \n",
"1230146 school name christian brothers school \n",
" school type secondary \n",
" postcode bt11 8bw \n",
" school management type rc maintained \n",
"1230155 school type secondary \n",
" postcode bt11 9jp \n",
" school management type rc maintained \n",
"... ... \n",
"5420062 school name st colman's college \n",
" postcode bt35 6pp \n",
" school management type voluntary \n",
" district council newry & mourne \n",
"5420073 school name st joseph's grammar school \n",
" postcode bt70 3he \n",
" school management type voluntary \n",
" district council dungannon \n",
"5420076 school name sacred heart grammar school \n",
" postcode bt34 1pr \n",
" school management type voluntary \n",
" district council newry & mourne \n",
" parliamentary constituency newry and armagh \n",
"5420260 school name the royal school dungannon \n",
" address 1 1 ranfurley road \n",
" postcode bt71 6ap \n",
" school management type voluntary \n",
" district council dungannon \n",
"5420263 school name the royal school armagh \n",
" postcode bt61 9dh \n",
" school management type voluntary \n",
" district council armagh \n",
"5420268 school name st patrick's grammar school \n",
" postcode bt61 7qz \n",
" school management type voluntary \n",
" district council armagh \n",
"5420304 school name st patrick's academy \n",
" postcode bt71 6ds \n",
" school management type voluntary \n",
" district council dungannon \n",
"\n",
" 2010 \\\n",
"de ref minor \n",
"1210014 school type secondary \n",
" address 1 holywood road \n",
" postcode bt42ly \n",
"1210015 school type secondary \n",
" address 1 holywood road \n",
" postcode bt42ly \n",
"1210021 school type secondary \n",
" address 1 dunkeld gardens \n",
" postcode bt146nt \n",
"1210022 school type secondary \n",
" postcode bt146rb \n",
"1230053 school type secondary \n",
" postcode bt126en \n",
" school management type roman catholic maintained \n",
"1230104 school name our lady of mercy girls' school \n",
" school type secondary \n",
" postcode bt147qr \n",
" school management type roman catholic maintained \n",
"1230130 school name st rose's high school \n",
" school type secondary \n",
" address 1 beechmount avenue \n",
" postcode bt127na \n",
" school management type roman catholic maintained \n",
"1230146 school name christian brothers school \n",
" school type secondary \n",
" postcode bt118bw \n",
" school management type roman catholic maintained \n",
"1230155 school type secondary \n",
" postcode bt119jp \n",
" school management type roman catholic maintained \n",
"... ... \n",
"5420062 school name st colman's college \n",
" postcode bt356pp \n",
" school management type voluntary \n",
" district council newry & mourne \n",
"5420073 school name st joseph's grammar school \n",
" postcode bt703he \n",
" school management type voluntary \n",
" district council dungannon \n",
"5420076 school name sacred heart grammar school \n",
" postcode bt341pr \n",
" school management type voluntary \n",
" district council newry & mourne \n",
" parliamentary constituency newry and armagh \n",
"5420260 school name the royal school dungannon \n",
" address 1 1 ranfurley road \n",
" postcode bt716ap \n",
" school management type voluntary \n",
" district council dungannon \n",
"5420263 school name the royal school armagh \n",
" postcode bt619dh \n",
" school management type voluntary \n",
" district council armagh \n",
"5420268 school name st patrick's grammar school \n",
" postcode bt617qz \n",
" school management type voluntary \n",
" district council armagh \n",
"5420304 school name st patrick's academy \n",
" postcode bt716ds \n",
" school management type voluntary \n",
" district council dungannon \n",
"\n",
" 2011 \\\n",
"de ref minor \n",
"1210014 school type secondary \n",
" address 1 holywood road \n",
" postcode bt42ly \n",
"1210015 school type secondary \n",
" address 1 holywood road \n",
" postcode bt42ly \n",
"1210021 school type secondary \n",
" address 1 dunkeld gardens \n",
" postcode bt146nt \n",
"1210022 school type secondary \n",
" postcode bt146rb \n",
"1230053 school type secondary \n",
" postcode bt126en \n",
" school management type rc maintained \n",
"1230104 school name our lady of mercy girls' school \n",
" school type secondary \n",
" postcode bt147qr \n",
" school management type rc maintained \n",
"1230130 school name st rose's high school \n",
" school type secondary \n",
" address 1 beechmount avenue \n",
" postcode bt127na \n",
" school management type rc maintained \n",
"1230146 school name christian brothers school \n",
" school type secondary \n",
" postcode bt118bw \n",
" school management type rc maintained \n",
"1230155 school type secondary \n",
" postcode bt119jp \n",
" school management type rc maintained \n",
"... ... \n",
"5420062 school name st colman's college \n",
" postcode bt356pp \n",
" school management type voluntary - rc managed \n",
" district council newry and mourne \n",
"5420073 school name st joseph's grammar school \n",
" postcode bt703he \n",
" school management type voluntary - rc managed \n",
" district council dungannon \n",
"5420076 school name sacred heart grammar school \n",
" postcode bt341pr \n",
" school management type voluntary - rc managed \n",
" district council newry and mourne \n",
" parliamentary constituency south down \n",
"5420260 school name the royal school dungannon \n",
" address 1 1 ranfurley road \n",
" postcode bt716ap \n",
" school management type voluntary - other managed \n",
" district council dungannon \n",
"5420263 school name the royal school armagh \n",
" postcode bt619dh \n",
" school management type voluntary - other managed \n",
" district council armagh \n",
"5420268 school name st patrick's grammar school \n",
" postcode bt617qz \n",
" school management type voluntary - rc managed \n",
" district council armagh \n",
"5420304 school name st patrick's academy \n",
" postcode bt716ds \n",
" school management type voluntary - rc managed \n",
" district council dungannon \n",
"\n",
" 2012 \\\n",
"de ref minor \n",
"1210014 school type secondary \n",
" address 1 holywood road \n",
" postcode bt42ly \n",
"1210015 school type secondary \n",
" address 1 holywood road \n",
" postcode bt42ly \n",
"1210021 school type secondary \n",
" address 1 dunkeld gardens \n",
" postcode bt146nt \n",
"1210022 school type secondary \n",
" postcode bt146rb \n",
"1230053 school type secondary \n",
" postcode bt126en \n",
" school management type rc maintained \n",
"1230104 school name our lady of mercy girls' school \n",
" school type secondary \n",
" postcode bt147qr \n",
" school management type rc maintained \n",
"1230130 school name st rose's high school \n",
" school type secondary \n",
" address 1 beechmount avenue \n",
" postcode bt127na \n",
" school management type rc maintained \n",
"1230146 school name christian brothers school \n",
" school type secondary \n",
" postcode bt118bw \n",
" school management type rc maintained \n",
"1230155 school type secondary \n",
" postcode bt119jp \n",
" school management type rc maintained \n",
"... ... \n",
"5420062 school name st colman's college \n",
" postcode bt356pp \n",
" school management type voluntary - rc managed \n",
" district council newry and mourne \n",
"5420073 school name st joseph's grammar school \n",
" postcode bt703he \n",
" school management type voluntary - rc managed \n",
" district council dungannon \n",
"5420076 school name sacred heart grammar school \n",
" postcode bt341pr \n",
" school management type voluntary - rc managed \n",
" district council newry and mourne \n",
" parliamentary constituency south down \n",
"5420260 school name the royal school dungannon \n",
" address 1 1 ranfurley road \n",
" postcode bt716ap \n",
" school management type voluntary - other managed \n",
" district council dungannon \n",
"5420263 school name the royal school armagh \n",
" postcode bt619dh \n",
" school management type voluntary - other managed \n",
" district council armagh \n",
"5420268 school name st patrick's grammar school \n",
" postcode bt617qz \n",
" school management type voluntary - rc managed \n",
" district council armagh \n",
"5420304 school name st patrick's academy \n",
" postcode bt716ds \n",
" school management type voluntary - rc managed \n",
" district council dungannon \n",
"\n",
" 2013 \\\n",
"de ref minor \n",
"1210014 school type secondary \n",
" address 1 holywood road \n",
" postcode bt42ly \n",
"1210015 school type secondary \n",
" address 1 holywood road \n",
" postcode bt42ly \n",
"1210021 school type secondary \n",
" address 1 dunkeld gardens \n",
" postcode bt146nt \n",
"1210022 school type secondary \n",
" postcode bt146rb \n",
"1230053 school type secondary \n",
" postcode bt126en \n",
" school management type rc maintained \n",
"1230104 school name our lady of mercy girls' school \n",
" school type secondary \n",
" postcode bt147qr \n",
" school management type rc maintained \n",
"1230130 school name st rose's high school \n",
" school type secondary \n",
" address 1 beechmount avenue \n",
" postcode bt127na \n",
" school management type rc maintained \n",
"1230146 school name christian brothers school \n",
" school type secondary \n",
" postcode bt118bw \n",
" school management type rc maintained \n",
"1230155 school type secondary \n",
" postcode bt119jp \n",
" school management type rc maintained \n",
"... ... \n",
"5420062 school name st colman's college \n",
" postcode bt356pp \n",
" school management type voluntary - rc managed \n",
" district council newry and mourne \n",
"5420073 school name st joseph's grammar school \n",
" postcode bt703he \n",
" school management type voluntary - rc managed \n",
" district council dungannon \n",
"5420076 school name sacred heart grammar school \n",
" postcode bt341pr \n",
" school management type voluntary - rc managed \n",
" district council newry and mourne \n",
" parliamentary constituency south down \n",
"5420260 school name the royal school dungannon \n",
" address 1 1 ranfurley road \n",
" postcode bt716ap \n",
" school management type voluntary - other managed \n",
" district council dungannon \n",
"5420263 school name the royal school armagh \n",
" postcode bt619dh \n",
" school management type voluntary - other managed \n",
" district council armagh \n",
"5420268 school name st patrick's grammar school \n",
" postcode bt617qz \n",
" school management type voluntary - rc managed \n",
" district council armagh \n",
"5420304 school name st patrick's academy \n",
" postcode bt716ds \n",
" school management type voluntary - rc managed \n",
" district council dungannon \n",
"\n",
" 2014 \\\n",
"de ref minor \n",
"1210014 school type secondary \n",
" address 1 holywood road \n",
" postcode bt42ly \n",
"1210015 school type secondary \n",
" address 1 holywood road \n",
" postcode bt42ly \n",
"1210021 school type secondary \n",
" address 1 dunkeld gardens \n",
" postcode bt146nt \n",
"1210022 school type secondary \n",
" postcode bt146rb \n",
"1230053 school type secondary \n",
" postcode bt126en \n",
" school management type catholic maintained \n",
"1230104 school name mercy college \n",
" school type secondary \n",
" postcode bt147qr \n",
" school management type catholic maintained \n",
"1230130 school name st rose’s dominican college \n",
" school type secondary \n",
" address 1 beechmount avenue \n",
" postcode bt127na \n",
" school management type catholic maintained \n",
"1230146 school name christian brothers school, belfast \n",
" school type secondary \n",
" postcode bt118bw \n",
" school management type catholic maintained \n",
"1230155 school type secondary \n",
" postcode bt119jp \n",
" school management type catholic maintained \n",
"... ... \n",
"5420062 school name st colman's college, newry \n",
" postcode bt356pp \n",
" school management type voluntary \n",
" district council newry and mourne \n",
"5420073 school name st joseph's convent grammar school, donaghmore \n",
" postcode bt703he \n",
" school management type voluntary \n",
" district council dungannon \n",
"5420076 school name sacred heart grammar school, newry \n",
" postcode bt341pr \n",
" school management type voluntary \n",
" district council newry and mourne \n",
" parliamentary constituency south down \n",
"5420260 school name the royal school, dungannon \n",
" address 1 1 ranfurley road \n",
" postcode bt716ap \n",
" school management type voluntary \n",
" district council dungannon \n",
"5420263 school name the royal school, armagh \n",
" postcode bt619dh \n",
" school management type voluntary \n",
" district council armagh \n",
"5420268 school name st patrick's grammar school, armagh \n",
" postcode bt617qz \n",
" school management type voluntary \n",
" district council armagh \n",
"5420304 school name st patrick's academy, dungannon \n",
" postcode bt716ds \n",
" school management type voluntary \n",
" district council dungannon \n",
"\n",
" 2015 \\\n",
"de ref minor \n",
"1210014 school type secondary \n",
" address 1 397 holywood road \n",
" postcode bt4 2ly \n",
"1210015 school type secondary \n",
" address 1 395 holywood road \n",
" postcode bt4 2ly \n",
"1210021 school type secondary \n",
" address 1 35 dunowen gardens \n",
" postcode bt14 6nq \n",
"1210022 school type secondary \n",
" postcode bt14 6rb \n",
"1230053 school type secondary \n",
" postcode bt12 6en \n",
" school management type catholic maintained \n",
"1230104 school name mercy college \n",
" school type secondary \n",
" postcode bt14 7qr \n",
" school management type catholic maintained \n",
"1230130 school name st rose’s dominican college \n",
" school type secondary \n",
" address 1 65 beechmount avenue \n",
" postcode bt12 7na \n",
" school management type catholic maintained \n",
"1230146 school name christian brothers school, belfast \n",
" school type secondary \n",
" postcode bt11 8bw \n",
" school management type catholic maintained \n",
"1230155 school type secondary \n",
" postcode bt11 9jp \n",
" school management type catholic maintained \n",
"... ... \n",
"5420062 school name st colman's college, newry \n",
" postcode bt35 6pp \n",
" school management type voluntary \n",
" district council newry mourne and down \n",
"5420073 school name st joseph's convent grammar school, donaghmore \n",
" postcode bt70 3he \n",
" school management type voluntary \n",
" district council mid ulster \n",
"5420076 school name sacred heart grammar school, newry \n",
" postcode bt34 1pr \n",
" school management type voluntary \n",
" district council newry mourne and down \n",
" parliamentary constituency south down \n",
"5420260 school name the royal school, dungannon \n",
" address 1 2 ranfurley road \n",
" postcode bt71 6ap \n",
" school management type voluntary \n",
" district council mid ulster \n",
"5420263 school name the royal school, armagh \n",
" postcode bt61 9dh \n",
" school management type voluntary \n",
" district council armagh city, banbridge and craigavon \n",
"5420268 school name st patrick's grammar school, armagh \n",
" postcode bt61 7qz \n",
" school management type voluntary \n",
" district council armagh city, banbridge and craigavon \n",
"5420304 school name st patrick's academy, dungannon \n",
" postcode bt71 6ds \n",
" school management type voluntary \n",
" district council mid ulster \n",
"\n",
" 2016 \\\n",
"de ref minor \n",
"1210014 school type secondary \n",
" address 1 397 holywood road \n",
" postcode bt42ly \n",
"1210015 school type secondary \n",
" address 1 395 holywood road \n",
" postcode bt42ly \n",
"1210021 school type secondary \n",
" address 1 35 dunowen gardens \n",
" postcode bt146nq \n",
"1210022 school type secondary \n",
" postcode bt146rb \n",
"1230053 school type secondary \n",
" postcode bt126en \n",
" school management type catholic maintained \n",
"1230104 school name mercy college \n",
" school type secondary \n",
" postcode bt147qr \n",
" school management type catholic maintained \n",
"1230130 school name st rose’s dominican college \n",
" school type secondary \n",
" address 1 65 beechmount avenue \n",
" postcode bt127na \n",
" school management type catholic maintained \n",
"1230146 school name christian brothers school, belfast \n",
" school type secondary \n",
" postcode bt118bw \n",
" school management type catholic maintained \n",
"1230155 school type secondary \n",
" postcode bt119jp \n",
" school management type catholic maintained \n",
"... ... \n",
"5420062 school name st colman's college, newry \n",
" postcode bt356pp \n",
" school management type voluntary \n",
" district council newry mourne and down \n",
"5420073 school name st joseph's convent grammar school, donaghmore \n",
" postcode bt703he \n",
" school management type voluntary \n",
" district council mid ulster \n",
"5420076 school name sacred heart grammar school, newry \n",
" postcode bt341pr \n",
" school management type voluntary \n",
" district council newry mourne and down \n",
" parliamentary constituency south down \n",
"5420260 school name the royal school, dungannon \n",
" address 1 2 ranfurley road \n",
" postcode bt716ap \n",
" school management type voluntary \n",
" district council mid ulster \n",
"5420263 school name the royal school, armagh \n",
" postcode bt619dh \n",
" school management type voluntary \n",
" district council armagh city, banbridge and craigavon \n",
"5420268 school name st patrick's grammar school, armagh \n",
" postcode bt617qz \n",
" school management type voluntary \n",
" district council armagh city, banbridge and craigavon \n",
"5420304 school name st patrick's academy, dungannon \n",
" postcode bt716ds \n",
" school management type voluntary \n",
" district council mid ulster \n",
"\n",
" 2017 \n",
"de ref minor \n",
"1210014 school type non-grammar \n",
" address 1 397 holywood road \n",
" postcode bt42ly \n",
"1210015 school type non-grammar \n",
" address 1 395 holywood road \n",
" postcode bt42ly \n",
"1210021 school type non-grammar \n",
" address 1 35 dunowen gardens \n",
" postcode bt146nq \n",
"1210022 school type non-grammar \n",
" postcode bt146rb \n",
"1230053 school type non-grammar \n",
" postcode bt126en \n",
" school management type catholic maintained \n",
"1230104 school name mercy college belfast \n",
" school type non-grammar \n",
" postcode bt147qr \n",
" school management type catholic maintained \n",
"1230130 school name st rose’s dominican college \n",
" school type non-grammar \n",
" address 1 65 beechmount avenue \n",
" postcode bt127na \n",
" school management type catholic maintained \n",
"1230146 school name christian brothers school, belfast \n",
" school type non-grammar \n",
" postcode bt118bw \n",
" school management type catholic maintained \n",
"1230155 school type non-grammar \n",
" postcode bt119jp \n",
" school management type catholic maintained \n",
"... ... \n",
"5420062 school name st colman's college, newry \n",
" postcode bt356pp \n",
" school management type voluntary \n",
" district council newry mourne and down \n",
"5420073 school name st joseph's convent grammar school, donaghmore \n",
" postcode bt703he \n",
" school management type voluntary \n",
" district council mid ulster \n",
"5420076 school name sacred heart grammar school, newry \n",
" postcode bt341pr \n",
" school management type voluntary \n",
" district council newry mourne and down \n",
" parliamentary constituency south down \n",
"5420260 school name the royal school, dungannon \n",
" address 1 2 ranfurley road \n",
" postcode bt716ap \n",
" school management type voluntary \n",
" district council mid ulster \n",
"5420263 school name the royal school, armagh \n",
" postcode bt619dh \n",
" school management type voluntary \n",
" district council armagh city, banbridge and craigavon \n",
"5420268 school name st patrick's grammar school, armagh \n",
" postcode bt617qz \n",
" school management type voluntary \n",
" district council armagh city, banbridge and craigavon \n",
"5420304 school name st patrick's academy, dungannon \n",
" postcode bt716ds \n",
" school management type voluntary \n",
" district council mid ulster \n",
"\n",
"[723 rows x 9 columns]"
]
},
"execution_count": 96,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"reference.to_frame()[reference.to_frame().apply(pd.Series.nunique, axis=1)!=1]"
]
},
{
"cell_type": "code",
"execution_count": 97,
"metadata": {
"ExecuteTime": {
"end_time": "2018-06-07T10:39:15.036158Z",
"start_time": "2018-06-07T10:39:15.030307Z"
},
"scrolled": true
},
"outputs": [
{
"data": {
"text/plain": [
"Counter({'catholic maintained': 258,\n",
" 'controlled': 628,\n",
" 'controlled integrated': 45,\n",
" 'gmi': 120,\n",
" 'grant maintained integrated': 15,\n",
" nan: 201,\n",
" 'other maintained': 12,\n",
" 'rc maintained': 282,\n",
" 'roman catholic maintained': 71,\n",
" 'voluntary': 303,\n",
" 'voluntary - other managed': 66,\n",
" 'voluntary - rc managed': 87})"
]
},
"execution_count": 97,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"from collections import Counter\n",
"Counter(reference[:,:,'school management type'].values.ravel('k'))"
]
},
{
"cell_type": "code",
"execution_count": 98,
"metadata": {
"ExecuteTime": {
"end_time": "2018-06-07T10:39:19.901133Z",
"start_time": "2018-06-07T10:39:19.897349Z"
}
},
"outputs": [],
"source": [
"reference_value_rename = {\n",
" 'school management type':{\n",
" 'controlled integrated':'integrated',\n",
" 'roman catholic maintained':'rc maintained',\n",
" 'grant maintained integrated':'gmi',\n",
" 'voluntary - other managed':'other maintained',\n",
" 'voluntary - rc managed':'rc maintained',\n",
" 'catholic maintained':'rc maintained'\n",
" }\n",
"}"
]
},
{
"cell_type": "code",
"execution_count": 99,
"metadata": {
"ExecuteTime": {
"end_time": "2018-06-07T10:39:22.743993Z",
"start_time": "2018-06-07T10:39:21.417598Z"
},
"code_folding": []
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Got reference data for 2009\n",
"Got reference data for 2010\n",
"Got reference data for 2011\n",
"Got reference data for 2012\n",
"Got reference data for 2013\n",
"Got reference data for 2014\n",
"Got reference data for 2015\n",
"Got reference data for 2016\n",
"Got reference data for 2017\n"
]
}
],
"source": [
"\n",
"import numpy as np\n",
"def parse_reference_table(xls):\n",
" cols = [\n",
" 'de ref',\n",
" 'school name',\n",
" 'school type',\n",
" 'address 1',\n",
" 'postcode',\n",
" 'urban_rural',\n",
" 'school management type',\n",
" 'district council',\n",
" 'parliamentary constituency',\n",
" 'town'\n",
" ]\n",
" \n",
" categories = [\n",
" 'school type',\n",
" 'urban_rural',\n",
" 'school management type',\n",
" 'district council',\n",
" 'parliamentary constituency',\n",
" 'town'\n",
" ]\n",
"\n",
" ref_key_map={\n",
" 'denino':'de ref',\n",
" 'urban/ rural': 'urban_rural',\n",
" 'schoolname': 'school name'\n",
" }\n",
" \n",
" reference_value_rename = {\n",
" 'school management type':{\n",
" 'gmi':'integrated',\n",
" 'controlled integrated':'integrated',\n",
" 'roman catholic maintained':'rc maintained',\n",
" 'grant maintained integrated':'integrated',\n",
" 'voluntary - other managed':'voluntary',\n",
" 'voluntary - rc managed':'voluntary',\n",
" 'catholic maintained':'rc maintained'\n",
" }\n",
" }\n",
" join_n_strip_n_lower = lambda l: ' '.join(l).strip().lower()\n",
" \n",
" if 'reference data' in xls.sheet_names:\n",
" df = pd.read_excel(xls, 'reference data', header=None)\n",
" h_range = 2 if isinstance(df.ix[3,0], int) else 3\n",
" try:\n",
" df.columns=df.ix[1:h_range].fillna('').apply(join_n_strip_n_lower, axis=0).values\n",
" df.rename(columns=ref_key_map, inplace=True)\n",
" df = df.drop(df.index[0:h_range+1]).reset_index(drop=True)\n",
" df = df[cols]\n",
" df['de ref'] = df['de ref'].astype(int)\n",
" df.set_index('de ref', inplace=True)\n",
" for c in df:\n",
" df[c]=df[c].str.lower().str.strip() \n",
" df.replace(reference_value_rename, inplace=True)\n",
" for c in categories:\n",
" df[c].fillna('NA', inplace=True)\n",
" df[c] = df[c].astype('category')\n",
" except TypeError as e:\n",
" print(e)\n",
" else:\n",
" df=None\n",
" return df\n",
"\n",
"dfs = {}\n",
"for year, files in year_files.items():\n",
" for file in files:\n",
" if 'post' in file:\n",
" xls = pd.ExcelFile(f'data/education-ni/{year}/{file}')\n",
" df = parse_reference_table(xls)\n",
" if df is not None:\n",
" print(f'Got reference data for {year}')\n",
" dfs[year]=df\n",
"reference = pd.Panel(dfs)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Parse Available"
]
},
{
"cell_type": "code",
"execution_count": 203,
"metadata": {
"ExecuteTime": {
"end_time": "2018-06-07T13:31:25.360872Z",
"start_time": "2018-06-07T13:31:24.310106Z"
}
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Got available data for 2010\n",
"Got available data for 2011\n",
"Got available data for 2012\n",
"Got available data for 2013\n",
"Got available data for 2014\n",
"Got available data for 2015\n",
"Got available data for 2016\n",
"Got available data for 2017\n"
]
},
{
"data": {
"text/plain": [
"\n",
"Dimensions: 8 (items) x 229 (major_axis) x 5 (minor_axis)\n",
"Items axis: 2010 to 2017\n",
"Major_axis axis: 1210014 to 5420314\n",
"Minor_axis axis: actual enrolments to supernumerary pupils"
]
},
"execution_count": 203,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"\"\"\"School level data\"\"\"\n",
"\n",
"def parse_available_table(xls):\n",
" ref_key_map={\n",
" 'schoolname': 'school name',\n",
" 'total unfilled places': 'available places',\n",
" 'unfilled places': 'available places',\n",
" 'total approved enrolment number': 'approved enrolments'\n",
" }\n",
" \n",
" join_n_strip_n_lower = lambda l: ' '.join(l).strip().lower()\n",
" \n",
" if 'School level data' in xls.sheet_names:\n",
" df = pd.read_excel(xls, 'School level data', header=None)\n",
" h_range = 2 if isinstance(df.ix[3,0], int) else 3\n",
" elif 'unfilled places' in xls.sheet_names:\n",
" df = pd.read_excel(xls, 'unfilled places', header=None)\n",
" h_range = 2 if isinstance(df.ix[3,0], int) else 3\n",
" else:\n",
" df=None\n",
" \n",
" if df is not None:\n",
" try:\n",
" df.columns=df.ix[1:h_range].fillna('').apply(join_n_strip_n_lower, axis=0).values\n",
" df.rename(columns=ref_key_map, inplace=True)\n",
" df = df.drop(df.index[0:h_range+1]).reset_index(drop=True)\n",
" df=df.applymap(lambda x: np.nan if isinstance(x, str) and x.isspace() else x)\n",
" df.dropna(how='all', axis=1, inplace=True)\n",
" df.dropna(how='any', axis=0, inplace=True)\n",
" if df.shape[1] == 6: # recent doesn't have fecking headers\n",
" cols = list(df.columns)\n",
" cols[0] = 'de ref'\n",
" cols[1] = 'school name'\n",
" df.columns=cols\n",
" df.drop('school name', axis=1, inplace=True)\n",
" df['de ref'] = df['de ref'].astype(int)\n",
" df.set_index('de ref', inplace=True)\n",
" df.replace('*',2.0, inplace=True) # * == < 5\n",
" df.replace('!',1, inplace=True) # ! avoid identification, so it's prob one or two\n",
" df.dropna(how='all', inplace=True, axis=1)\n",
" df.astype(int, inplace=True)\n",
" \n",
"\n",
" \n",
" except TypeError as e:\n",
" print(e)\n",
"\n",
" return df\n",
"dfs={}\n",
"for year, files in year_files.items():\n",
" for file in files:\n",
" if 'post' in file:\n",
" xls = pd.ExcelFile(f'data/education-ni/{year}/{file}')\n",
" df = parse_available_table(xls)\n",
" if df is not None:\n",
" print(f'Got available data for {year}')\n",
" dfs[year]=df\n",
" \n",
"available = pd.Panel(dfs)\n",
"available"
]
},
{
"cell_type": "code",
"execution_count": 205,
"metadata": {
"ExecuteTime": {
"end_time": "2018-06-07T13:31:32.471950Z",
"start_time": "2018-06-07T13:31:32.441846Z"
}
},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
"
\n",
"
\n",
"
actual enrolments
\n",
"
approved admissions
\n",
"
approved enrolments
\n",
"
available places
\n",
"
supernumerary pupils
\n",
"
\n",
"
\n",
"
de ref
\n",
"
\n",
"
\n",
"
\n",
"
\n",
"
\n",
"
\n",
" \n",
" \n",
"
\n",
"
1210014
\n",
"
NaN
\n",
"
NaN
\n",
"
660.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1210015
\n",
"
NaN
\n",
"
NaN
\n",
"
600.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1210021
\n",
"
NaN
\n",
"
NaN
\n",
"
950.0
\n",
"
56.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1210022
\n",
"
NaN
\n",
"
NaN
\n",
"
905.0
\n",
"
12.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1210266
\n",
"
NaN
\n",
"
NaN
\n",
"
548.0
\n",
"
2.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1230026
\n",
"
NaN
\n",
"
NaN
\n",
"
780.0
\n",
"
111.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1230053
\n",
"
NaN
\n",
"
NaN
\n",
"
2280.0
\n",
"
787.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1230089
\n",
"
NaN
\n",
"
NaN
\n",
"
650.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1230104
\n",
"
NaN
\n",
"
NaN
\n",
"
650.0
\n",
"
238.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1230130
\n",
"
NaN
\n",
"
NaN
\n",
"
575.0
\n",
"
237.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1230146
\n",
"
NaN
\n",
"
NaN
\n",
"
750.0
\n",
"
305.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1230155
\n",
"
NaN
\n",
"
NaN
\n",
"
1000.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1230173
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1230182
\n",
"
NaN
\n",
"
NaN
\n",
"
1025.0
\n",
"
9.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1230262
\n",
"
NaN
\n",
"
NaN
\n",
"
600.0
\n",
"
232.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1230275
\n",
"
NaN
\n",
"
NaN
\n",
"
664.0
\n",
"
143.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1230321
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1240291
\n",
"
NaN
\n",
"
NaN
\n",
"
600.0
\n",
"
60.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1260269
\n",
"
NaN
\n",
"
NaN
\n",
"
850.0
\n",
"
14.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1260294
\n",
"
NaN
\n",
"
NaN
\n",
"
800.0
\n",
"
189.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1410079
\n",
"
NaN
\n",
"
NaN
\n",
"
1075.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1410270
\n",
"
NaN
\n",
"
NaN
\n",
"
770.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1410315
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1420018
\n",
"
NaN
\n",
"
NaN
\n",
"
710.0
\n",
"
2.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1420020
\n",
"
NaN
\n",
"
NaN
\n",
"
950.0
\n",
"
73.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1420021
\n",
"
NaN
\n",
"
NaN
\n",
"
1180.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1420022
\n",
"
NaN
\n",
"
NaN
\n",
"
1810.0
\n",
"
74.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1420027
\n",
"
NaN
\n",
"
NaN
\n",
"
1050.0
\n",
"
32.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1420028
\n",
"
NaN
\n",
"
NaN
\n",
"
1410.0
\n",
"
19.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
1420029
\n",
"
NaN
\n",
"
NaN
\n",
"
966.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
\n",
"
\n",
"
5230152
\n",
"
NaN
\n",
"
NaN
\n",
"
760.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5230157
\n",
"
NaN
\n",
"
NaN
\n",
"
1355.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5230160
\n",
"
NaN
\n",
"
NaN
\n",
"
450.0
\n",
"
291.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5230167
\n",
"
NaN
\n",
"
NaN
\n",
"
600.0
\n",
"
17.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5230187
\n",
"
NaN
\n",
"
NaN
\n",
"
1000.0
\n",
"
37.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5230192
\n",
"
NaN
\n",
"
NaN
\n",
"
680.0
\n",
"
403.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5230213
\n",
"
NaN
\n",
"
NaN
\n",
"
1200.0
\n",
"
88.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5230218
\n",
"
NaN
\n",
"
NaN
\n",
"
1029.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5230256
\n",
"
NaN
\n",
"
NaN
\n",
"
800.0
\n",
"
646.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5230278
\n",
"
NaN
\n",
"
NaN
\n",
"
960.0
\n",
"
43.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5230293
\n",
"
NaN
\n",
"
NaN
\n",
"
575.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5230321
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5250216
\n",
"
NaN
\n",
"
NaN
\n",
"
450.0
\n",
"
149.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5260285
\n",
"
NaN
\n",
"
NaN
\n",
"
500.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5260286
\n",
"
NaN
\n",
"
NaN
\n",
"
500.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5410013
\n",
"
NaN
\n",
"
NaN
\n",
"
1320.0
\n",
"
5.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5410057
\n",
"
NaN
\n",
"
NaN
\n",
"
440.0
\n",
"
2.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5410067
\n",
"
NaN
\n",
"
NaN
\n",
"
780.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5420045
\n",
"
NaN
\n",
"
NaN
\n",
"
570.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5420056
\n",
"
NaN
\n",
"
NaN
\n",
"
570.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5420059
\n",
"
NaN
\n",
"
NaN
\n",
"
850.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5420060
\n",
"
NaN
\n",
"
NaN
\n",
"
860.0
\n",
"
8.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5420062
\n",
"
NaN
\n",
"
NaN
\n",
"
860.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5420073
\n",
"
NaN
\n",
"
NaN
\n",
"
575.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5420076
\n",
"
NaN
\n",
"
NaN
\n",
"
875.0
\n",
"
25.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5420260
\n",
"
NaN
\n",
"
NaN
\n",
"
650.0
\n",
"
5.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5420263
\n",
"
NaN
\n",
"
NaN
\n",
"
650.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5420268
\n",
"
NaN
\n",
"
NaN
\n",
"
750.0
\n",
"
0.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5420304
\n",
"
NaN
\n",
"
NaN
\n",
"
1400.0
\n",
"
31.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
5420314
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
\n",
" \n",
"
\n",
"
229 rows × 5 columns
\n",
"
"
],
"text/plain": [
" actual enrolments approved admissions approved enrolments \\\n",
"de ref \n",
"1210014 NaN NaN 660.0 \n",
"1210015 NaN NaN 600.0 \n",
"1210021 NaN NaN 950.0 \n",
"1210022 NaN NaN 905.0 \n",
"1210266 NaN NaN 548.0 \n",
"1230026 NaN NaN 780.0 \n",
"1230053 NaN NaN 2280.0 \n",
"1230089 NaN NaN 650.0 \n",
"1230104 NaN NaN 650.0 \n",
"1230130 NaN NaN 575.0 \n",
"1230146 NaN NaN 750.0 \n",
"1230155 NaN NaN 1000.0 \n",
"1230173 NaN NaN NaN \n",
"1230182 NaN NaN 1025.0 \n",
"1230262 NaN NaN 600.0 \n",
"1230275 NaN NaN 664.0 \n",
"1230321 NaN NaN NaN \n",
"1240291 NaN NaN 600.0 \n",
"1260269 NaN NaN 850.0 \n",
"1260294 NaN NaN 800.0 \n",
"1410079 NaN NaN 1075.0 \n",
"1410270 NaN NaN 770.0 \n",
"1410315 NaN NaN NaN \n",
"1420018 NaN NaN 710.0 \n",
"1420020 NaN NaN 950.0 \n",
"1420021 NaN NaN 1180.0 \n",
"1420022 NaN NaN 1810.0 \n",
"1420027 NaN NaN 1050.0 \n",
"1420028 NaN NaN 1410.0 \n",
"1420029 NaN NaN 966.0 \n",
"... ... ... ... \n",
"5230152 NaN NaN 760.0 \n",
"5230157 NaN NaN 1355.0 \n",
"5230160 NaN NaN 450.0 \n",
"5230167 NaN NaN 600.0 \n",
"5230187 NaN NaN 1000.0 \n",
"5230192 NaN NaN 680.0 \n",
"5230213 NaN NaN 1200.0 \n",
"5230218 NaN NaN 1029.0 \n",
"5230256 NaN NaN 800.0 \n",
"5230278 NaN NaN 960.0 \n",
"5230293 NaN NaN 575.0 \n",
"5230321 NaN NaN NaN \n",
"5250216 NaN NaN 450.0 \n",
"5260285 NaN NaN 500.0 \n",
"5260286 NaN NaN 500.0 \n",
"5410013 NaN NaN 1320.0 \n",
"5410057 NaN NaN 440.0 \n",
"5410067 NaN NaN 780.0 \n",
"5420045 NaN NaN 570.0 \n",
"5420056 NaN NaN 570.0 \n",
"5420059 NaN NaN 850.0 \n",
"5420060 NaN NaN 860.0 \n",
"5420062 NaN NaN 860.0 \n",
"5420073 NaN NaN 575.0 \n",
"5420076 NaN NaN 875.0 \n",
"5420260 NaN NaN 650.0 \n",
"5420263 NaN NaN 650.0 \n",
"5420268 NaN NaN 750.0 \n",
"5420304 NaN NaN 1400.0 \n",
"5420314 NaN NaN NaN \n",
"\n",
" available places supernumerary pupils \n",
"de ref \n",
"1210014 0.0 NaN \n",
"1210015 0.0 NaN \n",
"1210021 56.0 NaN \n",
"1210022 12.0 NaN \n",
"1210266 2.0 NaN \n",
"1230026 111.0 NaN \n",
"1230053 787.0 NaN \n",
"1230089 0.0 NaN \n",
"1230104 238.0 NaN \n",
"1230130 237.0 NaN \n",
"1230146 305.0 NaN \n",
"1230155 0.0 NaN \n",
"1230173 NaN NaN \n",
"1230182 9.0 NaN \n",
"1230262 232.0 NaN \n",
"1230275 143.0 NaN \n",
"1230321 NaN NaN \n",
"1240291 60.0 NaN \n",
"1260269 14.0 NaN \n",
"1260294 189.0 NaN \n",
"1410079 0.0 NaN \n",
"1410270 0.0 NaN \n",
"1410315 NaN NaN \n",
"1420018 2.0 NaN \n",
"1420020 73.0 NaN \n",
"1420021 0.0 NaN \n",
"1420022 74.0 NaN \n",
"1420027 32.0 NaN \n",
"1420028 19.0 NaN \n",
"1420029 0.0 NaN \n",
"... ... ... \n",
"5230152 0.0 NaN \n",
"5230157 0.0 NaN \n",
"5230160 291.0 NaN \n",
"5230167 17.0 NaN \n",
"5230187 37.0 NaN \n",
"5230192 403.0 NaN \n",
"5230213 88.0 NaN \n",
"5230218 0.0 NaN \n",
"5230256 646.0 NaN \n",
"5230278 43.0 NaN \n",
"5230293 0.0 NaN \n",
"5230321 NaN NaN \n",
"5250216 149.0 NaN \n",
"5260285 0.0 NaN \n",
"5260286 0.0 NaN \n",
"5410013 5.0 NaN \n",
"5410057 2.0 NaN \n",
"5410067 0.0 NaN \n",
"5420045 0.0 NaN \n",
"5420056 0.0 NaN \n",
"5420059 0.0 NaN \n",
"5420060 8.0 NaN \n",
"5420062 0.0 NaN \n",
"5420073 0.0 NaN \n",
"5420076 25.0 NaN \n",
"5420260 5.0 NaN \n",
"5420263 0.0 NaN \n",
"5420268 0.0 NaN \n",
"5420304 31.0 NaN \n",
"5420314 NaN NaN \n",
"\n",
"[229 rows x 5 columns]"
]
},
"execution_count": 205,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"available[2013]"
]
},
{
"cell_type": "code",
"execution_count": 200,
"metadata": {
"ExecuteTime": {
"end_time": "2018-06-07T13:30:34.788395Z",
"start_time": "2018-06-07T13:30:34.564355Z"
}
},
"outputs": [
{
"data": {
"text/plain": [
""
]
},
"execution_count": 200,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAcEAAAD8CAYAAAAPKB8vAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvhp/UCwAAIABJREFUeJzt3Xu8HFWZ7vHfk9sJJhCug5AEA04wcofESOQWJGBEDwyKcnGOMDJmGEFGOIzDjB5ExDkgjoqjoFEjAgoICkZkuAwQiRkCCeSegMYQJUEM1yD3ZO93/qjVWOzp3t2ddO2upJ8vn/qketWqtd6qHfabtaq6ShGBmZlZJ+rX7gDMzMzaxUnQzMw6lpOgmZl1LCdBMzPrWE6CZmbWsZwEzcysYzkJmpnZJkHSNElrJC2usV2Svi5puaSFkg6o16aToJmZbSquBCb3sv29wOi0TAGuqNegk6CZmW0SIuJe4JleqhwLXBWZ2cDWknbqrc0BrQzQym/AoOF+RJCV0suPz2x3CGyx8yHtDqFU1r+2WhvbxrqnVjT8O2fQDm/9O7IRXMXUiJjaRHfDgcdyn1elsj/U2sFJ0MzMSiElvGaS3kZzEjQzs+J0d/Vlb6uBkbnPI1JZTb4maGZmxela3/iy8aYDH013iR4IrI2ImlOh4JGgmZkVKKK7ZW1JuhaYCGwvaRXwOWBg1k98C7gVOBpYDrwE/E29Np0EzcysON2tS4IRcVKd7QGc0UybToJmZlacFo4Ei+AkaGZmxenbG2Oa5iRoZmbF8UjQzMw6VbTmrs/COAmamVlxWnhjTBGcBM3MrDieDjUzs47lG2PMzKxjeSRoZmYdyzfGmJlZx/KNMWZm1qkifE3QzMw6la8JmplZxyr5dOhm/z5BSTMkjdvAfUdJWtzkPhdKmtTkPuMkfb256MzMNgHR3fjSBqUYCUoaEBHlvoWoQRFx/gbsMxeYW0A4Zmbt1bWu3RH0qumRoKSbJT0oaYmkKbnyFyR9NZXfJWmHVD5D0mWS5ktaLGl8Kr9A0tWSZgFXSxos6fuSFkmaJ+nwVG+2pD1z/cxII6chkqZJeiDVPzZt30LSdZKWSboJ2KLGcZwvaU6KaaokpfKxkhZIWkDuvVSSTk3HfqeklZLOlHRO6nu2pG1TvSslHZ/WL5a0VNJCSV9OZR9KfS6QdG8qmyjplrS+bepnYWp3n9z5mpaOf4Wks1L5EEm/SO0tlnRCsz9TM7PCdHc3vrTBhkyHfiwixgLjgLMkbZfKhwBzI2JP4Jdkb/yteFNE7Ad8ApiWK98DmJRelHgG2TsR9wZOAn4gaTBwPfBhAEk7ATulkdNngLsjYjxwOHCppCHA3wMvRcTbUwxjaxzHNyLiHRGxF1mifH8q/z7wyYjYt8o+ewEfAN4BfDH1sz9wH/DRfMV0Xo4D9oyIfYCL0qbzgfek9o+p0sfngXlpn38BrsptGwO8BxgPfE7SQGAy8HhE7JuO5baeDUqaImmupLnd3S/WOB1mZgUo+XTohiTBs9IoaTYwEhidyrvJEhbANcDBuX2uBYiIe4GtJG2dyqdHxMtp/eC0HxHxMPA7YHfgx8Dxqc6HgRvT+lHAeZLmAzOAwcAuwKG5dhYCC2scx+GS7pe0CHg3sGeKa+sUJ8DVPfa5JyL+FBFPAmuBn6fyRcCoHnXXAq8A35P0AeClVD4LuFLSx4H+VeI6uNJvRNwNbCdpq7TtFxHxakQ8BawBdkx9HynpEkmHRMTang1GxNSIGBcR4/r1G1LjdJiZFWBzGglKmghMAiakkcw8suRTTdRYz3+uOyyJiNXA02la8AT+nGgFfDAi9kvLLhGxrMHjGAxcDhyfRp7f6eU48l7NrXfnPnfT4/pqusY5nixpv580QouI04HPkv0D4sHcSLoR+f67gAER8WvgALJkeJGkpq9JmpkVZnNKgsAw4NmIeEnSGODAHm1VRmwnA7/KbTsBQNLBwNpqoxVgJvCRVG93slHdI2nb9cCngWFpdAdwO/DJ3LW8/VP5val/JO0F7FOlr0rCe0rS0ErcEfEc8FyKk0o8GyK1OywibgXOBvZN5W+NiPvTDTRPkiXDvPx5mAg8FRHP99LPzmTTstcAl5IlRDOzUoiudQ0v7dDs3aG3AadLWkaWoGbntr0IjJf0WbKpuvwNGq9ImgcMBD5Wo+3LgSvS9OR64NSIqIx8bgQuA76Qq/8F4GvAQkn9gEfJRlxXAN9PMS4DHuzZUUQ8J+k7wGLgCWBObvPfANMkBXBHbyejji2Bn6VRp4BzUvmlkkansruABcBhuf0uSP0vJJtCPaVOP3unNruBdWTXRM3MyqHkX5ZXRM+Zyg1sSHohIoZWKZ8BnJtuZrE2GzBoeGt+4GYt9vLjM9sdAlvsfEi7QyiV9a+t1sa28fJdUxv+nbPFEVM2ur9mleJ7gmZmtpkq+UiwZUmw2igwlU9sVR9mZraJKflj0zwSNDOz4nTKSNDMzOx/WF/uJ2I6CZqZWXE8EjQzs47la4JmZtaxPBI0M7OO5ZGgmZl1LI8EzcysY/nuUDMz61gtejRnUZwEzcysOL4maGZmHavkSXBD3ixvZmbWmOhufKlD0mRJj0haLum8Ktt3kXSPpHmSFko6ul6bHgmamVlxurpa0oyk/sA3gSOBVcAcSdMjYmmu2meBH0fEFZL2AG4FRvXWrpOgmZVCGd7lV4Z3Gm52WjcdOh5YHhErACRdBxwL5JNgAFul9WHA4/UadRI0M7PiNJEEJU0BpuSKpkbE1LQ+HHgst20V8M4eTVwA3CHpk8AQYFK9Pp0EzcysOE18WT4lvKl1K9Z2EnBlRPybpAnA1ZL2iqgdhJOgmZkVJrpb9j3B1cDI3OcRqSzvNGAyQETcJ2kwsD2wplajvjvUzMyK093d+NK7OcBoSbtKGgScCEzvUef3wBEAkt4ODAae7K1RjwTNzKw4Lbo7NCLWSzoTuB3oD0yLiCWSLgTmRsR04P8C35F0NtlNMqdG9P7IGidBMzMrTgu/LB8Rt5J97SFfdn5ufSlwUDNtOgmamVlxSv7EGCdBMzMrjh+gbWZmHcsjQTMz61it+4pEIZwEzcysOC26O7QoToJmZlaY8HSomZl1LE+HmplZx2ri2aHt4CRoZmbF8UjQzMw61nrfGGNmZp3K06FmZtaxSj4dWtpXKUmaKOldG9nGC62Kp8H+TpX0jYL72OjzYmbWV6K7u+GlHUqbBIGJQOl+2Utq9+h5IiU8L2ZmVXVH40sb9GkSlHSzpAclLZE0JVc+WdJDkhZIukvSKOB04GxJ8yUdIulKScfn9nkh/Tk07fOQpEWSjm0gjr+W9EBq+9uS+lfalPTFFMdsSTum8islfUvS/cCXJG2bjmVhqrdPlT6ulHRF2r4ijeCmSVom6cpcvaMk3Zfiv0HS0FS+UtLnc8c1psZ5+ZCkxSnme5v/qZiZFajkSbCvRzUfi4hnJG0BzJH0E7JE/B3g0Ih4VNK2qc63gBci4ssAkk6r0eYrwHER8byk7YHZkqbXepFietvwCcBBEbFO0uXAR4CrgCHA7Ij4jKQvAR8HLkq7jgDeFRFdkv4dmBcRfyXp3Wnf/ap0tw0wATiG7A3IBwF/m459P2AV8FlgUkS8KOmfgHOAC9P+T0XEAZI+AZwbEX9b5bwsAt4TEaslbd3LuTcz63t+bNobnCXpuLQ+EhgN7ADcGxGPAkTEM022KeBfJR0KdAPDgR2BJ2rUPwIYS5aIALYA1qRtrwG3pPUHgSNz+90QEZWf5sHAB1O8d0vaTtJWVfr6eURESlR/jIhFAJKWAKPIEusewKwUyyDgvtz+P83F8oEaxzMLuFLSj3P13yCNuqcAqP8w+vUbUqMpM7PWipLfGNNnSVDSRGASMCEiXpI0AxjcRBPrSdO3kvqRJQzIRnE7AGPTyG5lnXYF/CAi/rnKtnW5EWQXbzw/LzYRa8Wr6c/u3Hrl84DUx50RcVKd/XvG8rqIOF3SO4H3AQ9KGhsRT/eoMxWYCjBg0PBy/400s81LyZNgX14THAY8mxLgGODAVD4bOFTSrgCStk3lfwK2zO2/kmwEB9n04sBcu2tSAjwceEudOO4Cjpf0F5X+JNXbp6eZZMm3ktyfiojnm2wDsmM/SNJfpraGSNq9zj5vOC+S3hoR90fE+cCTZCNsM7Ny6O5ufGmDvkyCtwEDJC0DLiZLAETEk2RTdT+VtAC4PtX/OXBc5QYQsuuGh6U6E/jzyOyHwLg05fhR4OHegoiIpWTX4e6QtBC4E9ipyWO5ABib9r8YOKXJ/SuxPAmcClyb2roPGFNnt57n5dJ048xi4L+ABRsSi5lZIUp+Y4xq3D9imylPh5rV9vLjM9sdQqkM3H43bWwbfzp9csO/c7b81m0b3V+z2v2dNzMz24xFlx+bZmZmnarkN8Y4CZqZWWH8FQkzM+tcToJmZtaxyn1J0EnQzMyKE+vLnQWdBM3MrDjlzoFOgmZmVhzfGGNmZp3LI0EzM+tUHgmamVnn8kjQzMw6VaxvdwS9cxI0M7PCRMlHgn35KiUzM+s03U0sdUiaLOkRScslnVejzoclLZW0RNKP6rXpkaCZmRWmVSNBSf2BbwJHAquAOZKmp3fEVuqMBv4ZOCginq28PL03HgmamVlhorvxpY7xwPKIWBERrwHXAcf2qPNx4JsR8SxARKyp16hHgh3GLw01s74UXY2/J1fSFGBKrmhqRExN68OBx3LbVgHv7NHE7qmdWUB/4IKIuK23Pp0EzcysMM1Mh6aEN7VuxdoGAKOBicAI4F5Je0fEc73tYGZmVojobnwkWMdqYGTu84hUlrcKuD8i1gGPSvo1WVKcU6tRXxM0M7PCtPCa4BxgtKRdJQ0CTgSm96hzM9koEEnbk02PruitUY8EzcysMBGtGQlGxHpJZwK3k13vmxYRSyRdCMyNiOlp21GSlgJdwD9GxNO9tauIcj/XzVpr3VMr/AM3s4YM3H63jc5gq9757oZ/54y4/+6WzZ02yiNBMzMrTHcTd4e2g5OgmZkVpoU3xhTCSdDMzArjJGhmZh2r7LedOAmamVlhPBI0M7OO1aqvSBTFSdDMzArT5btDzcysU3kkaGZmHcvXBM3MrGP57lAzM+tYHgmamVnH6uou98uKnATNzKwwZZ8OLXeKbgFJt0raOq2/UKfuKEmLa2ybIWlcC+I5VdI3NrYdM7NNQXeo4aUdNvuRYEQc3e4YzMw6Vdm/IlHakaCkmyU9KGmJpCmp7HRJl+bqvD6qqlY/la9MbxjOtz1U0l2SHpK0SNKxuc0DJP1Q0jJJN0p6U5XYjpJ0X9r/BklDq9SZIekySfMlLZY0vkqd/y3pfknzJP2npB1z8X0/xbZQ0gd761fSxZKWprpfbvJUm5kVJqLxpR1KmwSBj0XEWGAccJak7YCfAMfl6pwAXNdL/VpeAY6LiAOAw4F/k1T558rbgMsj4u3A88An8jumhPpZYFLafy5wTo1+3hQR+6U2plXZ/ivgwIjYPx3Hp1P5/wPWRsTeEbEPcHetftNxHgfsmepe1LMTSVMkzZU097tXXdvLaTEzay1Ph264syRVEt5IYHREzJa0QtKBwG+AMcCsWvWBp2u0LeBfJR0KdAPDgR3TtsciotLmNcBZQH50dSCwBzAr5c1BwH01+rkWICLulbRV5dpkzgjgekk7pXYeTeWTgBMrlSLiWUnvr9HvWrKk/j1JtwC39AwiIqYCU8FvljezvuW7QzeApIlkiWBCRLwkaQYwOG2+Dvgw8DBwU0REnfrVfATYARgbEeskrczV75kken4WcGdEnNTAodRr69+Br0TE9HQMF/TSVs1+01TrEcDxwJnAuxuIzcyscGX/V3dZU/Qw4NmU0MaQjb4qbgKOBU7iz1OhvdWv1f6alAAPB96S27aLpAlp/WSyKcu82cBBkv4SQNIQSbvX6OeEVOdgsunNtVXiWJ3WT8mV3wmcUfkgaZta/abrgsMi4lbgbGDfOsduZtZnyj4dWtYkeBvZDSrLgIvJEgCQTQ0Cy4C3RMQD9erX8ENgnKRFwEfJRpUVjwBnpLa2Aa7I7xgRTwKnAtdKWkg2JTmmRj+vSJoHfAs4rcr2C4AbJD0IPJUrvwjYJt1QswA4vJd+twRuSWW/ovb1STOzPhehhpd2UJT9m4ybqDQle25EzG13LHm+JmhmjRq4/W4bnZlmvvn4hn/nHPLEjX2eCUt5TdDMzDYPQbm/J+gkWJCImNjuGMzM2m19yb8s7yRoZmaF8UjQzMw6Vne7A6jDSdDMzArjkaCZmXUsjwTNzKxjdXkkaGZmnaq73DnQSdDMzIrT7ZGgmZl1qrI/ospJ0MzMCuMbY8zMrGN1y9OhZmbWobraHUAdZX2VkpmZbQa61fhSj6TJkh6RtFzSeb3U+6CkkDSuXpseCZqZWWFadXeopP7AN4EjgVXAHEnTI2Jpj3pbAv8A3N9Iu06CZsYWOx/S7hB4+fGZ7Q7BCtDCu0PHA8sjYgWApOuAY4GlPep9AbgE+MdGGvV0qFmHK0MCtM1XM9OhkqZImptbpuSaGg48lvu8KpW9TtIBwMiI+EWj8XkkaGZmhWnmKxIRMRWYuiH9SOoHfAU4tZn9nATNzKwwXa37hsRqYGTu84hUVrElsBcwQ9nXMt4MTJd0TETMrdWok6CZmRWmhV+WnwOMlrQrWfI7ETi5sjEi1gLbVz5LmgGc21sCBF8TNDOzAnU3sfQmItYDZwK3A8uAH0fEEkkXSjpmQ+PzSNDMzAoTLXxgTETcCtzao+z8GnUnNtKmk6CZmRXGzw41M7OOVfbHpjkJmplZYfxSXTMz61ieDjUzs47lJGhmZh3Lb5Y3M7OO5WuCZmbWsXx3qJmZdazukk+IOgmamVlhfGOMmZl1rHKPA50EzcysQGUfCW7Wb5GQNEPSuD7sb5SkxX3Qx8n1a5qZtd96RcNLO7Q9CUrapEajJYh3FLl3aJmZlVk0sbRDU0lQ0s2SHpS0RNKUXPkLkr6ayu+StEMqnyHpMknzJS2WND6VXyDpakmzgKslDZb0fUmLJM2TdHiqN1vSnrl+ZkgaJ2mIpGmSHkj1j03bt5B0naRlkm4CtqhxHGMl/TIdy+2Sdsq1f0lq99eSDknlp0qaLulu4C5lLk3HtEjSCVX6ODWdrzslrZR0pqRzUryzJW2b6r1V0m0plpmSxqTyKyV9XdJ/SVoh6fjU9MXAIemcni1pzxTvfEkLJY1u5mdqZlakVr1PsCjNjgQ/FhFjgXHAWZK2S+VDgLkRsSfwS+BzuX3eFBH7AZ8ApuXK9wAmRcRJwBlARMTewEnADyQNBq4HPgyQEtVO6S3BnwHujojxwOHApZKGAH8PvBQRb08xjO15AJIGAv8OHJ+OZRrwxVyVAandT/U4jgPSPocBHwD2A/YFJqX+d6pyvvZKdd+R+ngpIvYH7gM+mupMBT6ZYjkXuDy3/07AwcD7yZIfwHnAzIjYLyK+CpwOXJbO8ThgVZU4zMzaoptoeGmHZpPgWZIWALOBkUBl1NFNlrAAriH7xV1xLUBE3AtsJWnrVD49Il5O6wen/YiIh4HfAbsDPwYqI6APAzem9aOA8yTNB2YAg4FdgENz7SwEFlY5hreRJac70/6fBUbktv80/fkg2dRjxZ0R8Uwu3msjoisi/kiW+N9Rpa97IuJPEfEksBb4eSpfBIySNBR4F3BDiuXbZImv4uaI6I6IpcCOVdqHLKH+i6R/At6SO6evkzRF0lxJc7971bU1mjEza72yT4c2fH1L0kSyUc+EiHhJ0gyy5FNN1FjPf36xXp8RsVrS05L2AU4gG/UACPhgRDzSI8Z6TVb2XRIRE2psfzX92cUbz0/deHtpC7J/KLyaWx9A9o+Q59Iort7+VQ8uIn4k6X7gfcCtkv4uIu7uUWcq2YiTdU+tKPsdy2a2Gdmc7g4dBjybEuAY4MAe7VRGbCcDv8ptOwFA0sHA2ohYW6XtmcBHUr3dyUZ1lQR3PfBpYFga3QHcDnxSKetJ2j+V35v6R9JewD5V+noE2EHShFRvYP66Y4NmAidI6p+ufx4KPNBkG0TE88Cjkj6UYpGkfevs9idgy8oHSbsBKyLi68DPqH7MZmZt0UU0vLRDM0nwNmCApGVk16dm57a9CIxX9vWAdwMX5ra9Imke8C3gtBptXw70k7SILOmdGhGVUdCNwIlkU6MVXwAGAgslLUmfAa4AhqYYLySb0nyDiHiNLGFfkqZ255NNSTbjJrKp1gXA3cCnI+KJJtuo+AhwWoplCXBsnfoLgS5JCySdTTZNvDhNp+4FXLWBcZiZtVzZb4xRxMZnX0kvRMTQKuUzgHPTzSxWAp4OtZ622PmQdocAwMuPz2x3CNbDwO132+h3QJw16oSGf+d8feX1ff7OiXZ/583MzDZjZb8m2JIkWG0UmMontqJ9MzPbNPktEmZm1rHKnQKdBM3MrEDrS54GnQTNzKww4SRoZmadqiNujDEzM6vGI0EzM+tYHgmamVnH6mrBA1mK5CRoZmaF8fcEzcysY/maoJmZdSxfEzQzs45V9unQZt8sb2Zm1rBo4r96JE2W9Iik5ZLOq7L9HElLJS2UdJekt9Rr00nQzMwK0xXR8NIbSf2BbwLvBfYATpK0R49q84BxEbEP2btov1QvPidBMzMrTDfR8FLHeGB5RKxIL0e/jh4vIY+IeyLipfRxNjCiXqO+JthhyvICVbOeyvB30y/2bb1mboyRNAWYkiuaGhFT0/pw4LHctlXAO3tp7jTgP+r16SRoZmaFaeYrEinhTa1bsQ5Jfw2MAw6rV9dJ0MzMCtPCu0NXAyNzn0eksjeQNAn4DHBYRLxar1EnQTMzK0y07rFpc4DRknYlS34nAifnK0jaH/g2MDki1jTSqJOgmZkVpqtFI8GIWC/pTOB2oD8wLSKWSLoQmBsR04FLgaHADZIAfh8Rx/TWrpOgmZkVppVflo+IW4Fbe5Sdn1uf1GybToJmZlaYFk6HFsJJ0MzMClP2x6Y5CZqZWWH8FgkzM+tYfqmumZl1LE+HmplZx3ISNDOzjuW7Q83MrGN5JGhmZh3Ld4eamVnH6opmXqbU95wEzcysML4maGZmHcvXBM3MrGOV/Zpgv3YHYI2RtLOkG9P6REm3tDsmM7N6uiMaXtqhNCNBZS9/UkT7rqJKGhAR61tVr5Ui4nHg+L7s08xsY23SI0FJQyT9QtICSYslnZDKV0raPq2PkzQjrV8g6WpJ90n6jaSP59r6R0lzJC2U9PlUNkrSI5KuAhYDIyW9IOmLqc/ZknZMda+UdHyuvRfSnxMl/VLSzyStkHSxpI9IekDSIklvTfV2kPSTFMMcSQf1iHkWcHWKaaakh9Lyrlw/MyVNB5ZKulDSp3LxfFHSP/Q4f6MkPSzph5KWSbpR0ps25BymthZX+RkdJml+WuZJ2rL3H7mZWd/piu6Gl3aoNxKcDDweEe8DkDSsgTb3AQ4EhgDzJP0C2AsYDYwHBEyXdCjw+1R+SkTMTn0MAWZHxGckfQn4OHBRnT73Bd4OPAOsAL4bEeNTUvok8CngMuCrEfErSbuQvZ347Wn/PYCDI+LllKSOjIhXJI0GrgXGpXoHAHtFxKOSRgE/Bb4mqR9wYjq+nt4GnBYRsyRNAz4BfHkDzmEt5wJnpPaHAq/0rCBpCjAFQP2H0a/fkDrdm5m1RrumORtV75rgIuBISZdIOiQi1jbQ5s8i4uWIeAq4hywxHJWWecBDwBiy5Afwu0oCTF4DKte7HgRGNdDnnIj4Q0S8CvwWuCMXf2X/ScA3JM0HpgNbpaQBMD0iXk7rA4HvSFoE3ECWICseiIhHASJiJfC0pP0rxxYRT1eJ7bGImJXWrwEObuB4qp3DWmYBX5F0FrB1tWnaiJgaEeMiYpwToJn1pWjiv3bodSQYEb+WdABwNHCRpLsi4kJgPX9OoIN77lbls4D/HxHfzm9Io6kXe9RfF3/+YklXLsbX+0wjr0G5fV7NrXfnPnfn9u8HHBgRbxgpZZci3xDD2cAfyUaX/XjjyKpnrN8FTgXeDEyjumrn4w3HQ2PnsHrjERenkeLRwCxJ74mIh2vVNzPrS5v0SFDSzsBLEXENcCnZdCDASmBsWv9gj92OlTRY0nbARGAO2dTjxyojL0nDJf1Fk7Hm+zyGbMTWjDvIpkZJMexXo94w4A/pBp3/A/Tvpc2byKaM30F2jNXsImlCWj8Z+FVaX0lz57AqSW+NiEURcUmqN6aXeM3M+lTZR4L1pkP3Bh5IU4if48/X5j4PXCZpLtloLW8h2RTebOALEfF4RNwB/Ai4L00z3gg0ewPHd4DDJC0AJvA/R2X1nAWMSzfmLAVOr1HvcuCU1M+Y3vqJiNfIjvXHEdHzPFQ8ApwhaRmwDXBFKm/qHPZyXJ9KNy0tBNYB/9FLXTOzPtUVXQ0v7aBWPtJG0gXACxFR78aPzUKaln0I+FBE/KbK9lHALRGxVxNtXkCB53DAoOHlnpswa6OXH5/Z7hBKZeD2u2lj29hl270b/p3z+2cWbXR/zfKX5TeQpD2A5cBd1RKgmZllj01rdGmHlo4Erfw8EjSrzSPBN2rFSHD4Nns2/Dtn9bNL+nwkWJonxpiZ2ean7HeHOgmamVlhyv7YNCdBMzMrjF+qa2ZmHavs9504CZqZWWF8TdDMzDqWR4JmZtax2vX9v0Y5CZqZWWE8EjQzs47lu0PNzKxj+cYYMzPrWGWfDvUDtM3MrDCtfJ+gpMmSHpG0XNJ5Vbb/L0nXp+33pzf59MpJ0MzMChMRDS+9kdQf+CbwXmAP4KT0Np+804BnI+Ivga8Cl9SLz0nQzMwK0x3R8FLHeGB5RKxILzS/Dji2R51jgR+k9RuBIyT1+mYKXxPsMOtfW73RryqRNCUiprYink05hrLEUYYYyhJHGWIoSxxliAGa+50jaQowJVc0NXcMw4HHcttWAe/s0cTrdSJivaS1wHbAU7X69EjQNsSU+lUKV4YYoBxxlCEGKEccZYgByhFHGWJoSkRMjYhxuaXwJO4kaGZmm4LVwMjc5xGprGodSQOAYcDTvTXqJGhmZpuCOcBoSbtKGgScCEzvUWc6cEpaPx64O+rcceNrgrYh2n5DC3rRAAAEB0lEQVSdgXLEAOWIowwxQDniKEMMUI44yhBDy6RrfGcCtwP9gWkRsUTShcDciJgOfA+4WtJy4BmyRNkrlf2LjGZmZkXxdKiZmXUsJ0EzM+tYToKGpJGS7pG0VNISSf+QyreVdKek36Q/t0nlYyTdJ+lVSef2aKvXxxr1UQzTJK2RtLhd56JWO30cw2BJD0hakNr5fDvORa69/pLmSbqlHTFIWilpkaT5kua261xI2lrSjZIelrRM0oS+jEHS29I5qCzPS/pUM+djs9LMI228bJ4LsBNwQFrfEvg12WOJvgScl8rPAy5J638BvAP4InBurp3+wG+B3YBBwAJgj76MIW07FDgAWNzGc1G1nT6OQcDQtD4QuB84sK/PRa69c4AfAbe0IwZgJbB9O/8fSdt+APxtWh8EbN2On0fu/9kngLdsyHnZHBaPBI2I+ENEPJTW/wQsI3vyQv4RRD8A/irVWRMRc4B1PZpq5LFGRcdARNxLdmdY01oVRy/t9GUMEREvpI8D09LwnXCt/JlIGgG8D/huo/23OoaN0ao4JA0j+0fa91K91yLiub6MoYcjgN9GxO8aiWFz5CRob6Dsqev7k40adoyIP6RNTwA71tm92mONGvrF38IYWqZVcfRop09jSFOQ84E1wJ0R0XQMrYgD+BrwaWCD37DaghgCuEPSg8oez9WOOHYFngS+n6aGvytpSB/HkHcicG2z/W9OnATtdZKGAj8BPhURz+e3RUTQxChiU46hlXH01k5fxBARXRGxH9nTNcZL2quZGFoRh6T3A2si4sFm+25VDMnBEXEA2VsIzpB0aBviGEA2VX9FROwPvEg2hdmXMVTaGQQcA9zQTP+bGydBA0DSQLL/sX4YET9NxX+UtFPavhPZaKI3jTzWqOgYNlqr4qjRTp/GUJGm3O4BJrchjoOAYyStJJsif7eka/o4BiJidfpzDXAT2fR9w1oUxypgVW5EfiNZUuzLGCreCzwUEX9stP/NkZOgIUlk1yiWRcRXcpvyjyA6BfhZnaYaeaxR0TFslFbF0Us7fRnDDpK2TutbAEcCD/d1HBHxzxExIiJGkf2duDsi/rovY5A0RNKWlXXgKKDhu4dbeC6eAB6T9LZUdASwtC9jyDmJDp8KBXx3qJcAOJhsCmUhMD8tR5O9guQu4DfAfwLbpvpvJvsX7fPAc2l9q7TtaLK71n4LfKZNMVwL/IHshoBVwGl9HUetdvo4hn2AeamdxcD57fp7kWtzIs3dHdqqc7Eb2d3KC4AlzfzdLODv537A3NTWzcA2bYhhCNmDpYe1+/dPuxc/Ns3MzDqWp0PNzKxjOQmamVnHchI0M7OO5SRoZmYdy0nQzMw6lpOgmZl1LCdBMzPrWP8NUchlugMtaqEAAAAASUVORK5CYII=\n",
"text/plain": [
"