| Province | Std | |
|---|---|---|
| 0 | Saskatchewan | 377265.575896 |
| 1 | Ontario | 266435.317269 |
| 2 | Alberta | 266063.191824 |
| 3 | Manitoba | 122403.871037 |
| 4 | Quebec | 111411.104370 |
| 5 | New Brunswick | 22019.494316 |
| 6 | Nova Scotia | 19879.253759 |
| 7 | British Columbia | 14945.664171 |
| 8 | P.E.I. | 11355.747559 |
DSCI 310: Historical Horse Population in Canada
Aim
This project explores the historical population of horses in Canada between 1906 and 1972 for each province.
Data
Horse population data were sourced from the Government of Canada’s Open Data website (Government of Canada 2017a, 2017b).
Methods
The Python programming language (Van Rossum and Drake 2009) and the following Python packages were used to perform the analysis: pandas (McKinney 2010), altair (VanderPlas 2018), click (Team 2020), as well as Quarto (Allaire et al. 2022). Note: this report is adapted from Timbers (2020).
Results
We can see from Figure 1 that Ontario, Saskatchewan and Alberta have had the highest horse populations in Canada. All provinces have had a decline in horse populations since 1940. This is likely due to the rebound of the Canadian automotive industry after the Great Depression and the Second World War. An interesting follow-up visualisation would be car sales per year for each Province over the time period visualised above to further support this hypothesis.
Suppose we were interested in looking more closely at the province with the highest spread (in terms of standard deviation) of horse populations. We present the standard deviations in Table 1.
Note that we define standard deviation (of a sample) as
\[s = \sqrt{\frac{\sum_{i=1}^N (x_i - \overline{x})^2}{N-1} }\]
Additionally, note that in Table 1 we consider the sample standard deviation of the number of horses during the same time span as Figure 1.
In Figure 2 we zoom in and look at the province of Saskatchewan, which had the largest spread of values in terms of standard deviation.
References
Allaire, J. J., Charles Teague, Carlos Scheidegger, Yihui Xie, and Christophe Dervieux. 2022. “Quarto.” https://doi.org/10.5281/zenodo.5960048.
Government of Canada. 2017a. “Horses, Number on Farms at June 1 and at December 1.” Open Government - Open Data. https://open.canada.ca/data/en/dataset/a3ecf553-8ec4-4551-a0fe-8df1472c6cf7.
———. 2017b. “Horses, Number on Farms at June 1, Farm Value Per Head and Total Farm Value.” Open Government - Open Data. https://open.canada.ca/data/en/dataset/e175ef9c-98f0-49b3-8131-ca0e3895a0cb.
McKinney, Wes. 2010. “Data Structures for Statistical Computing in Python.” In Proceedings of the 9th Python in Science Conference, edited by Stéfan van der Walt and Jarrod Millman, =51–56.
Team, Pallets. 2020. Click. https://click.palletsprojects.com/.
Timbers, Tiffany. 2020. Historical Horse Population in Canada. https://github.com/ttimbers/equine_numbers_value_canada_parameters.
Van Rossum, Guido, and Fred L. Drake. 2009. Python 3 Reference Manual. Scotts Valley, CA: CreateSpace.
VanderPlas, Jake. 2018. “Altair: Interactive Statistical Visualizations for Python.” Journal of Open Source Software 3 (7825, 32): 1057. https://doi.org/10.21105/joss.01057.