{"id":39,"date":"2017-09-20T00:31:20","date_gmt":"2017-09-20T00:31:20","guid":{"rendered":"http:\/\/miriamposner.com\/classes\/dh101f17\/?page_id=39"},"modified":"2017-10-26T16:42:33","modified_gmt":"2017-10-26T23:42:33","slug":"openrefine-resources","status":"publish","type":"page","link":"https:\/\/miriamposner.com\/classes\/dh101f17\/tutorials-guides\/data-manipulation\/openrefine-resources\/","title":{"rendered":"OpenRefine Resources"},"content":{"rendered":"<p>On data-cleaning in general, see the School of Data&#8217;s\u00a0<a href=\"http:\/\/schoolofdata.org\/courses\/#IntroDataCleaning\">&#8220;Introduction to Data-Cleaning&#8221;<\/a>\u00a0for a helpful overview.<\/p>\n<p>Our tool of choice is\u00a0<a href=\"http:\/\/openrefine.org\/\">OpenRefine<\/a>, which is installed on the lab computers and is also a free download.<\/p>\n<h4>OPENREFINE TUTORIALS<\/h4>\n<p><a href=\"https:\/\/drive.google.com\/file\/d\/0Byb6mgIlUXNdcW4tR1hqS1JEdmM\/view?usp=sharing\">Francesca&#8217;s OpenRefine Slides<\/a><\/p>\n<p><a href=\"https:\/\/docs.google.com\/presentation\/d\/1r4GUr3j46whBRtCViXzhGkuZMTCPYBNCQu20u0df-DA\/edit?usp=sharing\">Maggie Pa&#8217;s OpenRefine tutorial<\/a>\u00a0(thanks, Maggie!)<\/p>\n<p><a href=\"http:\/\/www.meanboyfriend.com\/overdue_ideas\/wp-content\/uploads\/2014\/11\/Introduction-to-OpenRefine-handout-CC-BY.pdf\">&#8220;Introduction to OpenRefine,&#8221;<\/a>\u00a0developed by Owen Stephens on behalf of the British Library<\/p>\n<p><a href=\"http:\/\/programminghistorian.org\/lessons\/cleaning-data-with-openrefine\">&#8220;Cleaning Data with OpenRefine,&#8221;<\/a>\u00a0by Seth van Hooland, Ruben Verborgh and Max De Wilde<\/p>\n<p>Verborgh, Ruben, and Max De Wilde.\u00a0<a href=\"http:\/\/ucelinks.cdlib.org:8888\/sfx_local?sid=UCLA:CAT&amp;genre=book&amp;__char_set=utf8&amp;isbn=9781783289097\"><i>Using OpenRefine: The Essential OpenRefine Guide That Takes You From Data Analysis and Error Fixing to Linking Your Dataset to the Web<\/i>.\u00a0<\/a>Birmingham, UK: Packt Publishing, 2013.<strong>\u00a0(To get to the book, click on &#8220;EBSCO eBooks.&#8221;)<\/strong><\/p>\n<p>I like OpenRefine, but if you prefer, you can use Excel to do some data-cleaning. Lynda offers several video tutorials on using Excel to clean data. Search for &#8220;Cleaning Up Your Excel 2013 Data.&#8221;<\/p>\n<p>Got the data bug? Want to try some programming? I recommend\u00a0<em><a href=\"https:\/\/automatetheboringstuff.com\/\">Automate the Boring Stuff with Python<\/a>\u00a0<\/em>and\u00a0<a href=\"http:\/\/programminghistorian.org\/lessons\/cleaning-ocrd-text-with-regular-expressions\">&#8220;Cleaning OCR&#8217;d Text with Regular Expressions.&#8221;<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>On data-cleaning in general, see the School of Data&#8217;s\u00a0&#8220;Introduction to Data-Cleaning&#8221;\u00a0for a helpful overview. Our tool of choice is\u00a0OpenRefine, which<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":139,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_eb_attr":"","footnotes":""},"class_list":["post-39","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/pages\/39","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/comments?post=39"}],"version-history":[{"count":0,"href":"https:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/pages\/39\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/pages\/139"}],"wp:attachment":[{"href":"https:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/media?parent=39"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}