{"id":1880,"date":"2017-10-30T20:34:44","date_gmt":"2017-10-31T03:34:44","guid":{"rendered":"http:\/\/miriamposner.com\/classes\/dh101f17\/?p=1880"},"modified":"2017-10-30T20:34:44","modified_gmt":"2017-10-31T03:34:44","slug":"exploring-openrefine-2","status":"publish","type":"post","link":"http:\/\/miriamposner.com\/classes\/dh101f17\/2017\/10\/30\/exploring-openrefine-2\/","title":{"rendered":"Exploring OpenRefine"},"content":{"rendered":"<p><span style=\"font-weight: 400\">Having completed the Open Refine tutorial there are many possibilities for the manipulation of the nineteenth century children\u2019s book publishers dataset. As much of our data is centered around the addresses and locations of the publishers and tracking their movement, we could refine our data to only focus on publishing houses who moved across states rather than just those who moved small distances. We could also choose to focus only on publishing houses rather than the many roles which are included in the data such as \u2018Binding Designer\u2019 and \u2018Binder\u2019 for which there are only small amounts of data.<\/span><\/p>\n<p><span style=\"font-weight: 400\">To achieve this we will have to use the cluster and facets tools to select what we want to focus on. Also to refine the locations of the publishers we can use the \u2018split multi-valued columns\u2019 \u00a0tool to refine the addresses by state, and city. Also creating continuity within the cases and trailing white spacing of the columns will help to break down our over 5900 pieces of data into a more manageable dataset. <\/span><\/p>\n<p><span style=\"font-weight: 400\">I would like to refine the data in order to track the movement of a single publisher, so that if one publisher has multiple locations the data doesn\u2019t read it as more than one publisher but instead understands that the house has just moved. Therefore we would be able to track movement and mapping, rather than just statistics of how many exist in certain areas. <\/span><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Having completed the Open Refine tutorial there are many possibilities for the manipulation of the nineteenth century children\u2019s book publishers<\/p>\n","protected":false},"author":165,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-1880","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/posts\/1880","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/users\/165"}],"replies":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/comments?post=1880"}],"version-history":[{"count":0,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/posts\/1880\/revisions"}],"wp:attachment":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/media?parent=1880"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/categories?post=1880"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/tags?post=1880"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}