Obtain and clean data from government data portals
This page shows how to use rest APIs, download csv files, split apart data and metadata from zip files from Canadian municipal, provincial, and federal sources. Code is demonstrated in R and Python.
Full Quarto versions available on Github provided under a GNU General Public License v3.0.
Population by Mother Tongue and Geography - Open Canada
Census Data
Time Series
Software:Python
Software:R
Open Canada
zipfiles
csv files
Trade Data: Monthly Exports of Grains - Open Canada
Open Canada
zipfiles
csv files
Software:Python
Software:R
COVID Data: COVID-19 Data - Government of Canada and JHU CSSE
Time Series
Health Canada
csv files
Software:Python
Software:R
Accessing Statistics Canada Data Tables
Census Data
Regression
Time Series
Statistics Canada
Software:Python
Software:R
Things that break
API
Annual and Monthly Soft Drinks Production - Open Canada
Software:Python
Software:R
Data Merging
Time Series
Open Canada
zipfiles
csv files
Things that break
Ottawa Police Open Data
Ottawa
Open Street Maps
csv files
Software:Python
Software:R
Black bear hunting activity and harvests - Open Ontario
Regression
Time Series
Open Ontario
API
Software:Python
Software:R
Ontario Research Fund - Research Excellence Program - Open Ontario
Pairs Plot
Open Ontario
Software:Python
Software:R
zipfiles
csv files
Environment Canada Weather Station Data
Time Series
Spatial Data Set
Environment Canada
For loops
RestAPI
csv files
Software:Python
Software:R
Private Elementary and Secondary Schools Revenues - Open Canada
Regression
Time Series
Open Canada
zipfiles
Software:Python
Software:R
zipfiles
csv files
Production and Sale of Greenhouse Flowers and Plants - Open Canada
Pairs Plot
Open Canada
Software:Python
Software:R
zipfiles
csv files
Open Ottawa
Ottawa
Spatial Data Set
Open Street Maps
csv files
Software:Python
Software:R
No matching items