Research Guides: DPDS Social Sciences Workshop Resources: Using Scripts

Using Scripts

Objectives:

1. Describe how OpenRefine generates JSON code representing the work done in an analysis session.
2. Demonstrate ability to export this JSON code from OpenRefine.
3. Demonstrate ability to import a JSON code file to apply the analysis to another dataset.

Key Points:

1. All changes are tracked in OpenRefine, this information can be used for scripts for future analyses or reproducing an analysis.

Using Scripts Video Demonstration
Watch the workshop zoom video demonstration on saving work as a script and importing a script to use against another dataset. Video length is 5 minutes 8 seconds.
Social Science Workshop Registration
Register for the Social Science Workshop to gain hands-on experience and practice section objectives.

Recommended Guides

Using Scripts Guide
Workshop guide provided by Data Carpentry that explains saving work as a script, and importing a script to use against another dataset.
OpenRefine Manual: Exporting your work
Provides an overview using the custom tabular exporter, SQL exporter, and templating exporter, and how to export a full project.
OpenRefine Manual: Cell editing
Provides an overview of features for editing and improving the contents of cells like using the undo/redo function and using transforms like trim leading and trailing whitespace.

Online Tutorials

OpenRefine Tutorials: How to Export Your Project
RefinePro provides a tutorial on exporting data in Excel or csv format once a project is complete, and using the custom tabular exporter to control which field to export in OpenRefine. Video length is 1 minute and 35 seconds.