Institutions in OpenRefine: Cleaning up messes

2018-01-24T14:10:47Z (GMT) by Arthur Smith

OpenRefine (formerly Google Refine) is a tool for cleaning up messy data, but it is also well-suited to cross-linking different identifiers through their metadata entries. I will share some experiences in using OpenRefine to interlink GRID, ISNI, Wikidata, and our own internal institution identifiers. This matching process also highlights metadata errors (including duplicates and incorrect merges) in the different sources, and can help improve data quality on all sides. (Updated to full version with videos)
https://figshare.com/articles/Institutions_in_OpenRefine_Cleaning_up_messes/5813931
figshare.com
crawl=CC-MAIN-2019-43
27775
application/http; msgtype=response
sha1:WRN7MSSHCYFDA4XV4W25CIWCSTL33LRN
<urn:uuid:3164ba34-c0ae-439b-bb25-6895bede2f54>
2019-10-18T04:42:02Z
54.154.48.116
text/html
sha1:5UAELXD3NGZZANWHQP6J7YSEDWRJ3DPK
<urn:uuid:fbb15276-ae44-45f8-9dfd-53d94b41ff54>
https://figshare.com/articles/Institutions_in_OpenRefine_Cleaning_up_messes/5813931
response
<urn:uuid:7c4f6945-308a-43d4-8fb2-9c82e22326a3>
isPartOf: CC-MAIN-2019-43
publisher: Common Crawl
description: Wide crawl of the web for October 2019
operator: Common Crawl Admin (info@commoncrawl.org)
hostname: ip-10-67-67-191.ec2.internal
software: Apache Nutch 1.16 (modified, https://github.com/commoncrawl/nutch/)
robots: checked via crawler-commons 1.1-SNAPSHOT (https://github.com/crawler-commons/crawler-commons)
format: WARC File Format 1.1
conformsTo: http://iipc.github.io/warc-specifications/specifications/warc-format/warc-1.1/