Cleaning data

We are going to work with a different dataset for the next few activities. In order to start augmenting the dataset, we need to do a bit of preparation work first.

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

In this activity, you are going to:

Open regex101.com and load some sample data

Practice some regex basics

Use regex in OpenRefine

In this activity, you are going to:

Create a new project from the citizen science dataset and use the clustering feature

Split and concatenate various columns in the dataset

In this activity, you are going to:
Review the dataset and load it into OpenRefine
Perform some basic data cleanup to get familiar with the OpenRefine interface
Use OpenRefine to sort, filter and facet data

TABLE OF CONTENTS

Set up environment

• Software