This week I explored OpenRefine and learned how to clean up my data and make it easier to analyze. As someone who works mostly with Excel, I noticed that although some functions in OpenRefine, specifically the \u201csplit multi-valued columns\u201d function, very similar to those that exist in Excel, nonetheless I found OpenRefine an excellent resource to clean up data!<\/p>\n
My group is working with the Scottish Witch Trials data, and I would use OpenRefine to separate the names into first and last names using the \u201csplit multi-valued columns\u201d function, and clean up several variables like the county names or even the complaints and notes columns, as I noticed that some words are written in Scottish spelling conventions. Cleaning and bundling up all of this information will make analysis easier.<\/p>\n
Additionally, because our dataset has a lot of data types, and a huge portion of that is dedicated to the type of witchcraft performed, I would love to see more sophisticated functions that can group these data together to make them more comprehensive and analyzable. This would help my group greatly not only in term of analyzing the data, but also in visualizing and presenting them.<\/p>\n
Overall, I really enjoyed exploring the OpenRefine software, and I will definitely use it to clean up the data before going in-depth in our analysis for the project!<\/p>\n","protected":false},"excerpt":{"rendered":"
This week I explored OpenRefine and learned how to clean up my data and make it easier to analyze. As<\/p>\n","protected":false},"author":134,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-2013","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\/2013","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\/134"}],"replies":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/comments?post=2013"}],"version-history":[{"count":0,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/posts\/2013\/revisions"}],"wp:attachment":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/media?parent=2013"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/categories?post=2013"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/tags?post=2013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}