Research Guides: DPDS Social Sciences Workshop Resources: Filtering and Sorting

Filtering and Sorting with OpenRefine

Objectives:

1. Filter to a subset of rows by text filter or include/exclude.
2. Sort table by a column.
3. Sort by multiple columns.

Key Points:

1. OpenRefine provides a way to sort and filter data without affecting the raw data.

Filtering with OpenRefine Video Demonstration
Watch the workshop zoom video demonstration on filtering with a simple text filter and including and excluding entries in a facet. Video length is 5 minutes 48 seconds.
Sorting with OpenRefine Video Demonstration
Watch the workshop zoom video demonstration on sorting and re-sorting columns. Video length is 3 minutes 54 seconds.
Social Science Workshop Registration
Register for the Social Science Workshop to gain hands-on experience and practice section objectives.

Filtering and Sorting with OpenRefine Guide
Workshop guide provided by Data Carpentry that explains using a text filter, including and excluding rows using a facet, and sorting by a column or by multiple columns.
OpenRefine Manual: Exploring Facets
Provides an overview of facets with examples, and explains the different types of facets and how to use them.
OpenRefine Manual: Sort and view
Provides an overview of sorting and viewing features including showing and hiding “null,” and page navigation.

OpenRefine Tutorials: How to Create Text Facet and Filter
RefinePro provides a tutorial on using the facet function to create a filter and quickly explore data in OpenRefine. Video length is 2 minutes and 12 seconds.
OpenRefine Tutorials: How to Create Customized Facet and Filter
RefinePro provides a tutorial on using customized facets to explore and search through data sets in OpenRefine. Video length is 1 minute and 47 seconds.
OpenRefine Tutorials: How To Sort Column
RefinePro provides a tutorial on reordering data (alphabetically or reverse) based on what is in a specific column, or set of columns in OpenRefine. Video length is 1 minute and 55 seconds.