Table of Contents

1. Overview
2. Access
3. Collection
4. Cleaning
5. Tools
   1. Document Clustering
   2. Named Entity Recognition
   3. Ngram
   4. Parts of Speech Tagger
   5. Sentiment Analysis

1. Wikimedia provides a web API that we can use to access Wikipedia data. To learn more about how to use this API, see: https://en.wikipedia.org/api/rest_v1/
2. This page helps you construct URLs to make specific API calls. You can expand the section you are interested in, fill in the form and click on the Try it Out button to see what results you will get from a call. For our example, we are going to use the summary page example. On the Wikimedia REST API documentation page, first expand Page Content.

In this activity, you are going to:

1. Add a column of JSON data resulting from a Wikidata API call
2. Parse this JSON data column to obtain the property “first line”

In this activity, you are going to:

1. Reconcile (match) the titles of books with Wikidata
2. Add new columns of data from Wikidata

In this activity, you are going to:

A.      Create a new project from a JSON file of book information and learn about rows vs records

B.      Join multiple cells into one cell to reduce the number of rows

C.      Use some advanced GREL and regex to reverse the author names in our dataset

In this activity, you are going to:

A.      Create a new project by making an API call to pull in data and parse the resulting JSON

B.      Manipulate the data by using GREL date expressions and facet the data to make discoveries

In this activity, you are going to:

1. Open regex101.com and load some sample data
2. Practice some regex basics
3. Use regex in OpenRefine