In Search of Useful Collection Metadata: Using OpenRefine to Create Accurate, Complete, and Clean Title-level Collection Information
- UNCG Author/Contributor (non-UNCG co-authors, if there are any, appear on document)
- Kate Hill, Electronic Resources Librarian (Creator)
- Institution
- The University of North Carolina at Greensboro (UNCG )
- Web Site: http://library.uncg.edu/
Abstract: University of North Carolina at Greensboro (UNCG), like many libraries, recently migrated to a new knowledgebase and integrated library system (ILS) and found they had to clean up a great deal of messy serial title list data. In their search for solutions, they discovered the free, open source tool OpenRefine, a software program specifically designed for data normalization, transformation, and cleaning. This article describes the steps that UNCG used to take a publisher's title list file and transform it into a file format usable by their ILS. In doing so, this article will discuss major types of functionality in OpenRefine: downloading the software, importing data correctly, using the interface, transforming data on a column and cell level, exploring and normalizing data, and exporting files out of OpenRefine. At the end of this article, the readers should understand how to use OpenRefine on a basic level and be able to begin to use it on their own data.
In Search of Useful Collection Metadata: Using OpenRefine to Create Accurate, Complete, and Clean Title-level Collection Information
PDF (Portable Document Format)
524 KB
Created on 12/21/2017
Views: 514
Additional Information
- Publication
- Serials Review, 42(3), 222-228
- Language: English
- Date: 2016
- Keywords
- data software, electronic resource management, knowledgebase, OpenRefine, serials data, serials management, serial title lists