Datasets / Canada · K–12 facilities · school locations
Canada · K–12 facilities directory coverage
Counts describe source directory records, not school quality or complete worldwide coverage. Smaller groups are retained as Other when needed.
How it decided
Canada · K–12 facilities · school locations: 16,115 rows, 17 columns. The directory identifier and region classify source records; missing coordinates are still counted.
16,115 rows in, 13 out across 2 columns. Counts describe source directory records, not school quality or complete worldwide coverage. Smaller groups are retained as Other when needed.
bar. A count comparison describes coverage without inventing achievement scores or attendance boundaries.
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
13 rows out of 16,115, 2 columns. First 8 shown.
| group | schools |
|---|---|
| ON | 6515 |
| QC | 2747 |
| AB | 2257 |
| BC | 1923 |
| SK | 866 |
| MB | 681 |
| NS | 373 |
| NB | 296 |