CS 725/825 - Information Visualization
Fall 2017: Fridays, 8:30-11:00am, E&CS 2120

Print - Admin





CS725 @ GitLab

Paper Presentations



Tableau's data visualization software is provided through the Tableau for Teaching program.

Visualization Implementation 2

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.


Create your project

  • Follow the instructions at How to create a project in GitLab to create a new project.
  • Create a README.md file (see Markdown) that includes your name, CS 725/825, Fall 2017. For this assignment, you'll writing your solution in this project README.md.
  • Add me (mweigle) as a Reporter on your project -- if this step is not done, I will not be able to grade your assignment



Download and install OpenRefine

  • if you do not have your own machine, it is installed on the E&CS Open Lab machines


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

  • Under "Clean up country names", what other countries had issues with spelling? List the variations and explain how you discovered them in your project README.md.
  • Under "Exploring the data with scatter plots", export the endowment(x) vs. numStudents(y) plot, save it into your Gitlab project, and insert the image into your project README.md.
  • Export your cleaned data file as a CSV (comma-separated value) file and add this file to your Gitlab project.


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.


Submit the URL of your solution Gitlab project in Blackboard

  • Click on VI2 under Visualization Implementations
  • Under "Assignment Submission", click the "Write Submission" button.
  • Copy/paste the URL of your project (should be something like https://git-community.cs.odu.edu/username/projectName/) into the edit box and make the link clickable
  • Double-check your link to make sure that it is working properly -- do not link directly to a file ending in .git
  • Make sure to "Submit" your assignment.