Whenever handling a large amount of information, it can be difficult to categorize and clean up one\u2019s data. After engaging in the OpenRefine tutorial, I am better equipped with tools to manipulate my group\u2019s data set. In particular, OpenRefine would be a useful tool to comb through the many sentences listed for every recording, picking out key phrasing and word reoccurrences. By utilizing the merge and resorting feature, I would be able to pull out the names of the officials that president Nixon was talking with in the audio recordings. Having such a feature is useful in understanding the frequency with which the former president talked with these officials, lending a fresh perspective to the Watergate scandal.<\/p>\n
Also, OpenRefine\u2019s ability to select only certain columns and rows would allow our group to exclude information that is separate from our point of focus. For example, many of the recordings are simply a result of the white house operator transferring the call over to the president. Deleting these particular calls would help keep the focus only on Nixon and his conversation interactions. Finally, using the common manipulations option would allow for the data set spelling to become standardized through consistent capitalization. Consistent capitalization ensures that data that belongs together is kept together, rather than being simply separated due to spelling differences.<\/p>\n
One feature that I would like to know how to do would be to calculate the difference between the values of two separate columns. The start and end time of the recordings are in separate columns, so in order to know the duration of each call, the start time needs to be subtracted from the end time. If there was a feature that allowed for these times to be converted from strings to numbers, and then calculated, that would be extremely helpful in know the length of Nixon conversations.<\/p>\n","protected":false},"excerpt":{"rendered":"
Whenever handling a large amount of information, it can be difficult to categorize and clean up one\u2019s data. After engaging<\/p>\n","protected":false},"author":172,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-1811","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\/1811","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\/172"}],"replies":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/comments?post=1811"}],"version-history":[{"count":0,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/posts\/1811\/revisions"}],"wp:attachment":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/media?parent=1811"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/categories?post=1811"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/tags?post=1811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}