{"id":1790,"date":"2017-10-27T15:41:20","date_gmt":"2017-10-27T22:41:20","guid":{"rendered":"http:\/\/miriamposner.com\/classes\/dh101f17\/?p=1790"},"modified":"2017-10-27T15:41:20","modified_gmt":"2017-10-27T22:41:20","slug":"a-look-through-openrefine","status":"publish","type":"post","link":"http:\/\/miriamposner.com\/classes\/dh101f17\/2017\/10\/27\/a-look-through-openrefine\/","title":{"rendered":"A Look Through: OpenRefine"},"content":{"rendered":"

Our group is looking at graphic novels. One of the research questions we are looking into is if graphic novels are more highly regarded in certain countries than others, and what the origin of the book can tell us about graphic novels in general. OpenRefine does a great job at organizing all our data into an easy to read format. For example, I downloaded our data set into the program, and if I click on:<\/span><\/p>\n

Country of Origin (tab) \u2192 Facet \u2192 Text facet \u2192 organize by count<\/span><\/p>\n

\"\"<\/p>\n

From here, we can see where the majority of books are coming from which is mainly the USA and UK (see image). This also leads me to ask our expert how the creator of this dataset chose which books to be added into this collection. <\/span><\/p>\n

In addition, we can look at the Place of Publication tab, and separate the city from the country:<\/span><\/p>\n

Place of Publication (tab) \u2192 Edit column \u2192 Split into several columns \u2192 Separator (; ) \u2192 Okay<\/span><\/p>\n

Now we can easily see which graphic novels are from what country (see image). <\/span><\/p>\n

\"\"<\/p>\n

In general, OpenRefine is a great organizing tool. It\u2019s an awesome program for understanding large datasets because sometimes with the vast information in datasets, you can easily become discouraged. One thing I would like to know how to do is create graphs (if even possible). I tried to look at a numeric value tab and clicked:<\/span><\/p>\n

Facet \u2192 Scatterplot fact<\/span><\/p>\n

However, that didn\u2019t work for me. I think I would just need to spend more time with the program to work out the kinks! Or just use other resources to create graphs- like we learned in discussion. OpenRefine seems like a pretty simple to understand program which I really appreciate.\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Our group is looking at graphic novels. One of the research questions we are looking into is if graphic novels<\/p>\n","protected":false},"author":125,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-1790","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\/1790","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\/125"}],"replies":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/comments?post=1790"}],"version-history":[{"count":0,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/posts\/1790\/revisions"}],"wp:attachment":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/media?parent=1790"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/categories?post=1790"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/tags?post=1790"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}