Script to expore xls file of school rolls.
marge data of school roll into
In [9]:
import pandas
In [10]:
schrol = pandas.read_excel('/home/wcmckee/Downloads/Student-rolls-by-School-2010-2014.xls', skiprows=3)
In [11]:
schrol
Out[11]:
ID
Name
Decile
Type
Authority
Gender
Regional Council
Education Region
TA with Auckland Local Board
Total
...
Indian
Chinese
Other Asian
Middle Eastern
Latin American
African
Other.1
NZ European
Other European
International fee Paying
0
1
Te Kao School
2
Full Primary
State: Not integrated
Co-Ed
Northland Region
Tai Tokerau
Far North District
27
...
0
0
0
0
0
0
0
0
0
0
1
2
Taipa Area School
3
Composite (Year 1-15)
State: Not integrated
Co-Ed
Northland Region
Tai Tokerau
Far North District
385
...
0
0
0
0
0
0
3
108
5
0
2
3
Kaitaia College
2
Secondary (Year 9-15)
State: Not integrated
Co-Ed
Northland Region
Tai Tokerau
Far North District
832
...
3
2
7
0
0
0
5
233
14
2
3
4
Whangaroa College
2
Secondary (Year 7-15)
State: Not integrated
Co-Ed
Northland Region
Tai Tokerau
Far North District
104
...
0
0
0
0
0
0
0
7
0
0
4
5
Kerikeri High School
7
Secondary (Year 7-15)
State: Not integrated
Co-Ed
Northland Region
Tai Tokerau
Far North District
1413
...
7
2
11
0
0
0
15
831
152
28
5
6
Broadwood Area School
1
Composite (Year 1-15)
State: Not integrated
Co-Ed
Northland Region
Tai Tokerau
Far North District
100
...
1
0
0
0
0
0
0
5
0
0
6
7
Okaihau College
2
Secondary (Year 7-15)
State: Not integrated
Co-Ed
Northland Region
Tai Tokerau
Far North District
470
...
2
0
0
0
0
0
1
106
7
0
7
8
Bay of Islands College
1
Secondary (Year 9-15)
State: Not integrated
Co-Ed
Northland Region
Tai Tokerau
Far North District
356
...
0
0
1
0
0
0
3
49
3
0
8
9
Northland College
1
Secondary (Year 9-15)
State: Not integrated
Co-Ed
Northland Region
Tai Tokerau
Far North District
277
...
0
0
0
0
0
0
0
7
0
0
9
10
Te Kura Taumata o Panguru
2
Composite (Year 1-15)
State: Not integrated
Co-Ed
Northland Region
Tai Tokerau
Far North District
65
...
0
0
0
0
0
0
0
0
0
0
10
11
Opononi Area School
2
Composite (Year 1-15)
State: Not integrated
Co-Ed
Northland Region
Tai Tokerau
Far North District
203
...
0
0
0
0
0
0
1
18
1
0
11
12
Tauraroa Area School
7
Composite (Year 1-15)
State: Not integrated
Co-Ed
Northland Region
Tai Tokerau
Whangarei District
447
...
0
0
2
0
0
0
3
320
8
0
12
13
Kamo High School
5
Secondary (Year 9-15)
State: Not integrated
Co-Ed
Northland Region
Tai Tokerau
Whangarei District
1461
...
4
5
18
0
0
0
12
735
55
24
13
14
Tikipunga High School
2
Secondary (Year 7-15)
State: Not integrated
Co-Ed
Northland Region
Tai Tokerau
Whangarei District
427
...
0
0
0
0
0
0
0
84
10
0
14
15
Whangarei Boys' High School
5
Secondary (Year 9-15)
State: Not integrated
Single Sex-Boys
Northland Region
Tai Tokerau
Whangarei District
935
...
9
14
17
0
0
0
6
491
54
19
15
16
Whangarei Girls' High School
5
Secondary (Year 9-15)
State: Not integrated
Single Sex-Girls
Northland Region
Tai Tokerau
Whangarei District
1081
...
6
8
5
0
0
0
10
577
56
12
16
17
Pompallier Catholic College
7
Secondary (Year 7-15)
State: Integrated
Co-Ed
Northland Region
Tai Tokerau
Whangarei District
560
...
15
4
3
0
0
0
15
329
68
3
17
18
Mangakahia Area School
3
Composite (Year 1-15)
State: Not integrated
Co-Ed
Northland Region
Tai Tokerau
Whangarei District
139
...
0
0
0
0
0
0
0
35
1
0
18
19
Dargaville High School
3
Secondary (Year 9-15)
State: Not integrated
Co-Ed
Northland Region
Tai Tokerau
Kaipara District
531
...
3
5
1
0
0
0
2
278
17
3
19
20
Bream Bay College
4
Secondary (Year 7-15)
State: Not integrated
Co-Ed
Northland Region
Tai Tokerau
Whangarei District
463
...
3
0
2
0
0
0
6
259
15
2
20
21
Otamatea High School
6
Secondary (Year 7-15)
State: Not integrated
Co-Ed
Northland Region
Tai Tokerau
Kaipara District
509
...
2
4
2
0
0
0
3
281
33
3
21
22
Ruawai College
5
Secondary (Year 7-15)
State: Not integrated
Co-Ed
Northland Region
Tai Tokerau
Kaipara District
175
...
0
0
1
0
0
0
2
98
6
0
22
23
Rodney College
5
Secondary (Year 9-15)
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Rodney
321
...
2
1
0
0
0
0
6
201
9
1
23
24
Mahurangi College
8
Secondary (Year 7-15)
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Rodney
1217
...
3
8
18
0
0
0
21
874
88
16
24
25
Orewa College
9
Secondary (Year 7-15)
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Hibiscus and Bays
1778
...
16
13
28
0
0
0
8
1165
256
66
25
26
Kaipara College
7
Secondary (Year 9-15)
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Rodney
673
...
1
2
7
0
0
0
5
401
22
17
26
27
Long Bay College
10
Secondary (Year 9-15)
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Hibiscus and Bays
1626
...
10
20
38
0
0
0
26
786
553
82
27
28
Rangitoto College
10
Secondary (Year 9-15)
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Upper Harbour
3046
...
39
262
340
0
0
0
260
1304
391
217
28
29
Kristin School
10
Composite (Year 1-15)
Private: Fully Reg.
Co-Ed
Auckland Region
Auckland
Auckland- Upper Harbour
1548
...
28
171
77
0
0
0
15
764
405
31
29
30
Glenfield College
7
Secondary (Year 9-15)
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Kaipatiki
828
...
29
14
26
0
0
0
59
270
37
47
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
2553
6763
Whangaparaoa College
9
Secondary (Year 7-15)
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Hibiscus and Bays
1417
...
10
9
13
0
0
0
31
1047
129
27
2554
6783
Remarkables Primary School
10
Full Primary
State: Not integrated
Co-Ed
Otago Region
Otago/Southland
Queenstown-Lakes District
124
...
1
3
4
0
0
0
2
96
9
0
2555
6920
Gulf Harbour School
10
Full Primary
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Hibiscus and Bays
483
...
1
4
15
0
0
0
33
304
84
4
2556
6921
Point View School
10
Contributing
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Howick
801
...
69
185
71
0
0
0
58
294
35
13
2557
6922
Waiheke Primary School
5
Full Primary
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Waiheke
208
...
2
0
1
0
0
0
10
129
14
0
2558
6929
Alfriston College
3
Secondary (Year 9-15)
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Manurewa
1280
...
157
33
9
0
0
0
45
270
29
0
2559
6930
Botany Downs Secondary College
10
Secondary (Year 9-15)
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Howick
1828
...
266
261
219
0
0
0
61
536
209
89
2560
6932
Pinehill School (Browns Bay)
10
Contributing
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Upper Harbour
504
...
18
74
114
0
0
0
37
157
39
8
2561
6937
Summerland Primary
7
Contributing
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Henderson-Massey
579
...
76
37
43
0
0
0
50
164
14
11
2562
6939
Kohia Terrace School
10
Full Primary
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Albert-Eden
397
...
36
87
26
0
0
0
7
193
14
10
2563
6940
Te Akau ki Papamoa Primary School
4
Full Primary
State: Not integrated
Co-Ed
Bay of Plenty Region
Bay of Plenty/Rotorua/Taupo
Tauranga City
476
...
38
4
5
0
0
0
2
189
21
0
2564
6944
Randwick Park School
1
Full Primary
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Manurewa
737
...
85
4
4
0
0
0
15
19
4
0
2565
6945
Selwyn Ridge School
6
Contributing
State: Not integrated
Co-Ed
Bay of Plenty Region
Bay of Plenty/Rotorua/Taupo
Tauranga City
495
...
7
0
5
0
0
0
12
292
39
13
2566
6946
Oteha Valley School
9
Contributing
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Upper Harbour
325
...
14
17
21
0
0
0
62
160
21
0
2567
6947
The Gardens School
10
Full Primary
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Manurewa
490
...
90
27
18
0
0
0
14
211
8
2
2568
6948
Albany Junior High School
10
Secondary (Year 7-15)
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Upper Harbour
1174
...
24
47
138
0
0
0
68
624
134
44
2569
6955
Upper Harbour Primary School
10
Contributing
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Upper Harbour
391
...
20
19
56
0
0
0
32
226
21
0
2570
6959
Willowbank School (Howick)
9
Contributing
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Howick
741
...
129
141
56
0
0
0
65
168
86
7
2571
6960
Baverstock Oaks School
9
Contributing
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Howick
620
...
175
95
38
0
0
0
43
139
10
4
2572
6962
Te Wharekura o Mauao
2
Secondary (Year 7-15)
State: Not integrated
Co-Ed
Bay of Plenty Region
Bay of Plenty/Rotorua/Taupo
Tauranga City
35
...
0
0
0
0
0
0
0
0
0
0
2573
6975
Garin College
8
Secondary (Year 9-15)
State: Integrated
Co-Ed
Nelson Region
Nelson/Marlborough/West Coast
Nelson City
412
...
0
0
3
0
0
0
5
328
13
25
2574
6976
Rototuna Primary School
10
Contributing
State: Not integrated
Co-Ed
Waikato Region
Waikato
Hamilton City
717
...
39
26
33
0
0
0
23
416
59
7
2575
6978
Reremoana Primary School
9
Full Primary
State: Not integrated
Co-Ed
Auckland Region
Auckland
Auckland- Manurewa
300
...
10
3
6
0
0
0
9
163
21
0
2576
6980
Clearview Primary
9
Full Primary
State: Not integrated
Co-Ed
Canterbury Region
Canterbury
Selwyn District
211
...
0
1
1
0
0
0
7
158
23
0
2577
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
2578
Source: Indicators & Reporting Team, Ministry ...
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
2579
July roll return student rolls exclude Health ...
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
2580
Prior to 2009 Students under a Ministry of For...
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
2581
Māori Language Learning Figures exclude Altern...
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
2582
A small number of single sex schools can have ...
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
2583 rows × 83 columns
In [ ]:
In [7]:
schrol.Decile
Out[7]:
0 2
1 3
2 2
3 2
4 7
5 1
6 2
7 1
8 1
9 2
10 2
11 7
12 5
13 2
14 5
...
2568 10
2569 10
2570 9
2571 9
2572 2
2573 8
2574 10
2575 9
2576 9
2577 NaN
2578 NaN
2579 NaN
2580 NaN
2581 NaN
2582 NaN
Name: Decile, Length: 2583, dtype: float64
In [ ]:
Content source: wcmckee/ece-display
Similar notebooks: