Z616 Comic Books and Their Readers, Spring 2026

Qualitative, quantitative, and digital methods for studying comic readers and fans

View project on GitHub

OpenRefine Lab

Instructions

In this lab, you will work on cleaning data in some portions of one of the ao3 Star Trek data

  1. Import that CSV into OpenRefine and create a project
  2. Perform 4 actions to clean the sheet and document how you did them
    1. Example action and documentation: “I trimmed the leading/ending white-spaces in all columns by going to All > Edit all columns > Trim leading and trailing whitespace.”
  • A document with four bullet points explaining the four actions you took to clean the document. Include details about specific commands, e.g., All > Edit all columns > Trim leading and trailing whitespace.

Turn in on Canvas.