{"id":97,"date":"2016-09-24T17:29:51","date_gmt":"2016-09-25T00:29:51","guid":{"rendered":"http:\/\/miriamposner.com\/classes\/dh101f16\/?page_id=97"},"modified":"2016-10-31T21:42:54","modified_gmt":"2016-11-01T04:42:54","slug":"openrefine-resources","status":"publish","type":"page","link":"http:\/\/miriamposner.com\/classes\/dh101f16\/tutorials-guides\/data-manipulation\/openrefine-resources\/","title":{"rendered":"OpenRefine Resources"},"content":{"rendered":"<p>On data-cleaning in general, see the School of Data\u2019s <a href=\"http:\/\/schoolofdata.org\/courses\/#IntroDataCleaning\">\u201cIntroduction to Data-Cleaning\u201d<\/a> for a helpful overview.<\/p>\n<p>Our tool of choice is <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:\/\/docs.google.com\/presentation\/d\/1r4GUr3j46whBRtCViXzhGkuZMTCPYBNCQu20u0df-DA\/edit?usp=sharing\">Maggie Pa&#8217;s OpenRefine tutorial<\/a> (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\">\u201cIntroduction to OpenRefine,\u201d<\/a> developed by Owen Stephens on behalf of the British Library<\/p>\n<p><a href=\"http:\/\/programminghistorian.org\/lessons\/cleaning-data-with-openrefine\">\u201cCleaning Data with OpenRefine,\u201d<\/a> by Seth van Hooland, Ruben Verborgh and Max De Wilde<\/p>\n<p>Verborgh, Ruben, and Max De Wilde. <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> (To get to the book, click on \u201cEBSCO eBooks.\u201d)<\/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 \u201cCleaning Up Your Excel 2013 Data.\u201d<\/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 <a href=\"http:\/\/programminghistorian.org\/lessons\/cleaning-ocrd-text-with-regular-expressions\">\u201cCleaning OCR\u2019d Text with Regular Expressions.\u201d<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>On data-cleaning in general, see the School of Data\u2019s \u201cIntroduction to Data-Cleaning\u201d for a helpful overview. Our tool of choice is OpenRefine, which is installed on the lab computers and &hellip; <a href=\"http:\/\/miriamposner.com\/classes\/dh101f16\/tutorials-guides\/data-manipulation\/openrefine-resources\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;OpenRefine Resources&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":88,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_eb_attr":"","footnotes":""},"class_list":["post-97","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/pages\/97","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/comments?post=97"}],"version-history":[{"count":0,"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/pages\/97\/revisions"}],"up":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/pages\/88"}],"wp:attachment":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/media?parent=97"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}