From CS 725/825 Fall 2017

CS725-F17: Visualization Implementation 2

Contents (hide)

Due: September 15, 2017 before 8:30am

The goal of this week's assignment is to gain experience using OpenRefine for data cleaning. Later in the semester, you will work on a project using real-world data. This data will be messy. Learning how to use this tool now will save you a ton of time later in the semester.

Setup

Create your project

Tasks

Install

Download and install OpenRefine

Tutorial

Work through the tutorial at http://enipedia.tudelft.nl/wiki/OpenRefine_Tutorial through "Export Data"

Exercise

The last part of the tutorial is the section "More Data Sets - Is the 27 Club Real?". Use OpenRefine to determine how many musicians in the dataset died at age 27. In your project README.md, explain the steps you took to clean and analyze the data to reach your conclusion. Also export your final data file as CSV and add it to your Gitlab project.

Important: Your write-up this section is the most important part of this assignment. You need to include enough detail so that I am convinced that you understand how to use OpenRefine. In addition, you will lose points if there are many spelling or grammatical errors and if your write-up does not use appropriate Markdown markup for clarity and neatness.

Submission

Submit the URL of your solution Gitlab project in Blackboard

Retrieved from http://www.cs.odu.edu/~mweigle/CS725-F17/VI2
Page last modified on September 01, 2017, at 11:06 AM