{"id":73,"date":"2017-01-04T21:46:32","date_gmt":"2017-01-04T21:46:32","guid":{"rendered":"http:\/\/slob.coplacdigital.org\/course\/?page_id=73"},"modified":"2019-08-03T18:08:29","modified_gmt":"2019-08-03T23:08:29","slug":"openrefine","status":"publish","type":"page","link":"https:\/\/slob.coplacdigital.org\/course\/tools\/openrefine\/","title":{"rendered":"OpenRefine"},"content":{"rendered":"<p><a href=\"http:\/\/openrefine.org\">OpenRefine<\/a>\u00a0looks like a spreadsheet, but is actually &#8220;a powerful tool for working with messy data.&#8221; We&#8217;ll use OpenRefine for normalizing place names from imprint statements in English Short Title Catalogue (ESTC) records and for fetching latitude and longitude coordinates for those places, but you may find it useful for lots of other things, too.<!--more--><\/p>\n<p>OpenRefine can be\u00a0an especially useful tool if you know a little bit about <a href=\"http:\/\/www.regular-expressions.info\/\">regular expressions<\/a>\u00a0or can do some basic scripting (using variables, control flow statements, etc.). You don&#8217;t need to know those things to get good use out of the tool, but if, as you proceed in your project, you think you&#8217;re going to have a lot of data cleaning to do, it could be worth learning something about them (we&#8217;ll help).<\/p>\n<p>Please <a href=\"http:\/\/openrefine.org\/download.html\">download<\/a> and install OpenRefine 2.6-rc2 for your platform (it&#8217;s available for Windows, macOS, and Linux).\u00a0OpenRefine runs as a service on your machine\u2014it doesn&#8217;t have its own interface, but rather opens a tab or window in your web browser. When you close that tab or window, OpenRefine continues running (at least on macOS), so you&#8217;ll want to remember to explicitly quit OpenRefine when you&#8217;re done.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>OpenRefine\u00a0looks like a spreadsheet, but is actually &#8220;a powerful tool for working with messy data.&#8221; We&#8217;ll use OpenRefine for normalizing place names from imprint statements in English Short Title Catalogue (ESTC) records and for fetching latitude and longitude coordinates for those places, but you may find it useful for lots of other things, too.<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":63,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-73","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P8UIEH-1b","_links":{"self":[{"href":"https:\/\/slob.coplacdigital.org\/course\/wp-json\/wp\/v2\/pages\/73","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/slob.coplacdigital.org\/course\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/slob.coplacdigital.org\/course\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/slob.coplacdigital.org\/course\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/slob.coplacdigital.org\/course\/wp-json\/wp\/v2\/comments?post=73"}],"version-history":[{"count":2,"href":"https:\/\/slob.coplacdigital.org\/course\/wp-json\/wp\/v2\/pages\/73\/revisions"}],"predecessor-version":[{"id":76,"href":"https:\/\/slob.coplacdigital.org\/course\/wp-json\/wp\/v2\/pages\/73\/revisions\/76"}],"up":[{"embeddable":true,"href":"https:\/\/slob.coplacdigital.org\/course\/wp-json\/wp\/v2\/pages\/63"}],"wp:attachment":[{"href":"https:\/\/slob.coplacdigital.org\/course\/wp-json\/wp\/v2\/media?parent=73"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}