{"id":1894,"date":"2017-10-31T13:57:05","date_gmt":"2017-10-31T20:57:05","guid":{"rendered":"http:\/\/miriamposner.com\/classes\/dh101f17\/?p=1894"},"modified":"2017-10-31T14:01:48","modified_gmt":"2017-10-31T21:01:48","slug":"using-openrefine","status":"publish","type":"post","link":"http:\/\/miriamposner.com\/classes\/dh101f17\/2017\/10\/31\/using-openrefine\/","title":{"rendered":"Using OpenRefine"},"content":{"rendered":"<p><span style=\"font-weight: 400\">For this week\u2019s post, we used OpenRefine to clean up some data regarding shipwrecks off the New Jersey coast. Immediately, it was clear that OpenRefine would be very useful for my group\u2019s data set on the Carnegie Museum of Art\u2019s Contemporary Art Collection. Some things I would like to do to the data is to take out some of the data types which are used more for administrative purposes. These columns have info for Carnegie\u2019s own internal referencing system, but are not as useful for our narrative. By removing these data types, we would be able to tell a better story regarding the art pieces and their creators. <\/span><\/p>\n<p><span style=\"font-weight: 400\">Some of the techniques I would need to use are trimming and merging and cluster techniques. These techniques would help clean our data, making it easier to work with. As far as things I would like to do but don\u2019t know how, I think it\u2019d be useful to know how to take out any entity that had an incomplete data type. In doing so, we would be sure that all the data we use would be complete, which would also make our analysis easier. It would also be helpful if we were able to visually see each of the artworks, but unfortunately that is not included in the dataset.\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>For this week\u2019s post, we used OpenRefine to clean up some data regarding shipwrecks off the New Jersey coast. Immediately,<\/p>\n","protected":false},"author":110,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-1894","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\/1894","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\/110"}],"replies":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/comments?post=1894"}],"version-history":[{"count":0,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/posts\/1894\/revisions"}],"wp:attachment":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/media?parent=1894"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/categories?post=1894"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/tags?post=1894"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}