twoHelixestwoHelixes Start free

Datasets / New Zealand · school locations

New Zealand directory coverage

Counts describe source directory records, not school quality or complete worldwide coverage. Smaller groups are retained as Other when needed.

Question How many school location records are in each region?
New Zealand directory records0200400600Auckland RegionCanterbury RegionManawatū-Whanganu…Northland RegionHawke's Bay RegionSouthland RegionTasman RegionMarlborough RegionSchools
New Zealand · school locations — 16 rows charted from 2,578, drawn as a hbar
How it decided
Finding the data1089 ms

New Zealand · school locations: 2,578 rows, 16 columns. The directory identifier and region classify source records; missing coordinates are still counted.

Shaping the data5 ms

2,578 rows in, 16 out across 2 columns. Counts describe source directory records, not school quality or complete worldwide coverage. Smaller groups are retained as Other when needed.

Choosing the chart6 ms

hbar. A count comparison describes coverage without inventing achievement scores or attendance boundaries.

Applying defaults1 ms

Palette, spacing, axis titles and legend placement applied. 0 issues found.

The transformation

This is the code, not a description of it — the chart above was drawn from what it returns, and the notebook download runs the same lines against the same file.

result = df.groupby('region', dropna=False).size().reset_index(name='schools').rename(columns={'region':'group'})
result = result.sort_values('schools', ascending=False).reset_index(drop=True)
if len(result) > 15:
    result = pd.concat([result.head(15), pd.DataFrame([{'group':'Other','schools':int(result.iloc[15:]['schools'].sum())}])], ignore_index=True)

What it charted

16 rows out of 2,578, 2 columns. First 8 shown.

groupschools
Auckland Region573
Waikato Region306
Canterbury Region296
Wellington Region252
Manawatū-Whanganui Region198
Bay of Plenty Region165
Northland Region156
Otago Region147

More from New Zealand · school locations