{"id":2008,"date":"2017-11-01T11:05:54","date_gmt":"2017-11-01T18:05:54","guid":{"rendered":"http:\/\/miriamposner.com\/classes\/dh101f17\/?p=2008"},"modified":"2017-11-01T11:05:54","modified_gmt":"2017-11-01T18:05:54","slug":"blog-post-4-openrefine-4","status":"publish","type":"post","link":"http:\/\/miriamposner.com\/classes\/dh101f17\/2017\/11\/01\/blog-post-4-openrefine-4\/","title":{"rendered":"Blog Post #4: OpenRefine"},"content":{"rendered":"<p><em>Before doing the OpenRefine tutorial, I didn\u2019t really understand the importance organizing data. I thought data analysts just organize data to organize. However, I now realize that cleaning up data sets the foundation of the data analysis and research that follows. OpenRefine is a useful tool to not only sets a standard for organizing data, but also provides a function for analysis. In particular, OpenRefine would be extremely helpful in sorting through the Nixon dataset, which contains 20K+ rows of data. The merging and resorting tool would be very useful in deciphering the frequency in which the ex-president had talked to or talked about. OpenRefine\u2019s selection tool also allows us to select only the columns and rows that are relevant to our groups\u2019 focus. Consistent capitalization of the data also allows the data to stay together during categorization. One feature that would be useful is to calculate the time of each conversation by subtracting the adjacent audio clips and adding it to another field. I\u2019m not sure if there\u2019s already a function for this but it would definitely be useful to see how the time of each conversation correlates to other criteria. <\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Before doing the OpenRefine tutorial, I didn\u2019t really understand the importance organizing data. I thought data analysts just organize data<\/p>\n","protected":false},"author":111,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-2008","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\/2008","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\/111"}],"replies":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/comments?post=2008"}],"version-history":[{"count":0,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/posts\/2008\/revisions"}],"wp:attachment":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/media?parent=2008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/categories?post=2008"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/tags?post=2008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}