twoHelixestwoHelixes Start free

Datasets / Victoria · school locations

Victoria 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 sector?
Victoria directory records05001k1.5kGovernmentCatholicIndependentGroup
Victoria · school locations — 3 rows charted from 2,294, drawn as a bar
How it decided
Finding the data1570 ms

Victoria · school locations: 2,294 rows, 16 columns. The directory identifier and sector classify source records; missing coordinates are still counted.

Shaping the data5 ms

2,294 rows in, 3 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 chart5 ms

bar. 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('sector', dropna=False).size().reset_index(name='schools').rename(columns={'sector':'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

3 rows out of 2,294, 2 columns. First 3 shown.

groupschools
Government1570
Catholic495
Independent229

More from Victoria · school locations