School Roll

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 [ ]: