Extracting data

Getting started

A software license for Stata can be purchased by University of Toronto faculty, staff, and students at a discounted rate. Faculty and staff go through the Stata Prof+ Plan. Please select your campus from the list of Ontario… Read more.

Table of Contents
Our tutorial for the Digital Scholar Lab (DSL) includes the introductory page you are reading, plus six major sections. Click on any of the links below to jump to the relevant tutorial. We suggest following them in order:

Access… Read more.

Use the Add Data button to add the dataset you are interested in selecting from to your map document. For this example, we will use a shapefile that represents the dissemination areas that comprise the Toronto Census Subdivision (From Statistics… Read more.

Table of Contents

Introduction
Setting up working environment

Step 1 - Download the DEM dataset
Step 2 - Download City of Toronto boundary file
Step 3 - Setting up a working directory and establish folder connection


Clipping Rasters - Two ways… Read more.

This tutorial has been developed for OpenRefine version 3.7.5
To learn more about reconciliation services and how you can use them to augment your data, check out the official OpenRefine guide to reconciling Feel free to read just the introduction… Read more.

 
As described on the StatCan webpage, "the RTRA system is an on-line remote access facility allowing users to run SAS programs, in real-time, against microdata sets located in a central and secure location". Statistics Canada provides multiple… Read more.

This tutorial has been developed for OpenRefine version 3.7.5
Sometimes when you construct an API call and use the Add Column by Fetching URLs feature, it won’t work. In these cases, you can use python to help. So far we’ve been writing GREL… Read more.

This tutorial has been developed for OpenRefine version 3.7.5
You may have noticed from Activity 2 that sometimes you searched for a property to add from Wikidata, but got an error. Other times you might want to augment your dataset with data that… Read more.

In this activity, you are going to:
Create a new project by making an API call to pull in data and parse the resulting JSON
Manipulate the data by using GREL date expressions and facet the data to make discoveries
 
Create a new project by… Read more.

This course has multiple modules. Each module consists of a few videos. It will take approximately 2 hours to watch the videos. You can watch the videos by clicking on the topic title hyperlink under each module. If you need assistance, fill out… Read more.