{"id":1985,"date":"2017-11-01T09:49:44","date_gmt":"2017-11-01T16:49:44","guid":{"rendered":"http:\/\/miriamposner.com\/classes\/dh101f17\/?p=1985"},"modified":"2017-11-01T09:49:44","modified_gmt":"2017-11-01T16:49:44","slug":"openrefine-week-3","status":"publish","type":"post","link":"http:\/\/miriamposner.com\/classes\/dh101f17\/2017\/11\/01\/openrefine-week-3\/","title":{"rendered":"OpenRefine Week 3"},"content":{"rendered":"<p><span style=\"font-weight: 400\">The data set for I am working with is the Scottish Witches data set. So far, the group has noticed that many of the variables have many no answers for our variables. In addition, some of the variables seem to be repeated. For example, the data set that details the suspected roots for magic include categories for \u201cdemonic\u201d roots, however in the same data set it has a second column that details it as well. OpenRefine seems like a very useful program for this project. My group would find this useful. Our data set includes two different spreadsheets with some very interesting variables.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400\">A way that the OpenRefine software may be useful to use by way of manipulation would be to be able to help make our data more precise, by getting rid of white space and helping to find where there are repeated \u201cNo\u201d or blank answers. This will make analysis of these variables easier and make the data more concise especially if any of the variables are repeated. <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400\">Some of the tools that may help, especially in the case I mentioned before, the edited tool that helps to merge columns (mentioned in step 8) seems like it would be useful for the data we have. In addition, the cluster tool looks like it may help. However, I am wary of the tool suggesting what variables the program will believe need to be merged. Of course, it is necessary to vet these suggestions but if we are not careful we might end up merging some variables that will throw off our analysis. Of course, we need to get rid of white space, which the program makes so simple! I am excited for this because it will make the data concise and will make the data more efficient in the analysis. I am still confused as to how split the columns and also the reason for why it may be useful in the our data analysis. Overall, I think OpenRefine is a great user friendly program that makes cleanup simple. Of course, I need to work with it more in order to be comfortable with the program.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The data set for I am working with is the Scottish Witches data set. So far, the group has noticed<\/p>\n","protected":false},"author":118,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-1985","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\/1985","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\/118"}],"replies":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/comments?post=1985"}],"version-history":[{"count":0,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/posts\/1985\/revisions"}],"wp:attachment":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/media?parent=1985"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/categories?post=1985"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/tags?post=1985"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}