Acquisition and Cleaning of Open Government Data

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

Libraries for Accessing Statistics Canada Data Tables

Census Data
Regression
Time Series
Software:Python
Software:R
Things that break

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
csv files
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