{"id":1956,"date":"2022-12-08T00:50:25","date_gmt":"2022-12-07T23:50:25","guid":{"rendered":"http:\/\/www.meanboyfriend.com\/overdue_ideas\/?p=1956"},"modified":"2022-12-09T01:28:34","modified_gmt":"2022-12-09T00:28:34","slug":"advent-of-code-with-openrefine","status":"publish","type":"post","link":"http:\/\/www.meanboyfriend.com\/overdue_ideas\/2022\/12\/advent-of-code-with-openrefine\/","title":{"rendered":"Advent of Code with OpenRefine"},"content":{"rendered":"\n<p>In case you&#8217;ve not come across it&#8230; <a href=\"https:\/\/adventofcode.com\">Advent of code<\/a> is:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><em>&#8230;<\/em> an\u00a0<a href=\"https:\/\/en.wikipedia.org\/wiki\/Advent_calendar\">Advent calendar<\/a>\u00a0of small programming puzzles for a variety of skill sets and skill levels that can be solved in\u00a0<a href=\"https:\/\/github.com\/search?q=advent+of+code\">any<\/a> programming language you like. People use them as\u00a0<a href=\"https:\/\/y3l2n.com\/2018\/05\/09\/interview-prep-advent-of-code\/\">interview<\/a>\u00a0<a href=\"https:\/\/twitter.com\/dznqbit\/status\/1037607793144938497\">prep<\/a>,\u00a0<a href=\"https:\/\/twitter.com\/pgoultiaev\/status\/950805811583963137\">company training<\/a>,\u00a0<a href=\"https:\/\/gitlab.com\/imhoffman\/fa19b4-mat3006\/wikis\/home\">university<\/a>\u00a0<a href=\"https:\/\/gribblelab.org\/teaching\/scicomp2021\/index.html\">coursework<\/a>,\u00a0<a href=\"https:\/\/twitter.com\/mrdanielklein\/status\/936267621468483584\">practice<\/a>\u00a0<a href=\"https:\/\/comp215.blogs.rice.edu\/\">problems<\/a>, a\u00a0<a href=\"https:\/\/adventofcode.com\/leaderboard\">speed contest<\/a>, or to\u00a0<a href=\"https:\/\/www.reddit.com\/r\/adventofcode\/search?q=flair%3Aupping&amp;restrict_sr=on\">challenge each other<\/a>.<\/p>\n<\/blockquote>\n\n\n\n<p>My son had started working on it this year, and inspired me to have a go as well. However, rather than following the usual route of solving the puzzles by writing computer programmes, I&#8217;ve decided to try to solve each one using the <a href=\"https:\/\/openrefine.org\" data-type=\"URL\" data-id=\"https:\/\/openrefine.org\">OpenRefine<\/a> software which is designed for working with large data sets.<\/p>\n\n\n\n<p>After a few days I can already tell you OpenRefine is definitely not always the right tool for this kind of job&#8230; but that&#8217;s OK. This is just a fun challenge and the point (for me) of doing in OpenRefine isn&#8217;t to find the best of most efficient way of solving the problem, but rather to have fun, challenge my brain, and explore the abilities, and limitations, of OpenRefine along the way.<\/p>\n\n\n\n<p>Each day there are two challenges, and I&#8217;m going to try to post a short video for each day I try and see how far I get with the two challenges in OpenRefine. I&#8217;m playing catchup at the moment and have already solved the first few days but I&#8217;m only just getting round to recording a video&#8230;. so here is Advent of Code 2022, Day 1, solved using OpenRefine<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Advent of Code 2022 Day 1 using OpenRefine\" width=\"640\" height=\"480\" src=\"https:\/\/www.youtube.com\/embed\/sfawG-K9DVo?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>In case you&#8217;ve not come across it&#8230; Advent of code is: &#8230; an\u00a0Advent calendar\u00a0of small programming puzzles for a variety of skill sets and skill levels that can be solved in\u00a0any programming language you like. People use them as\u00a0interview\u00a0prep,\u00a0company training,\u00a0university\u00a0coursework,\u00a0practice\u00a0problems, a\u00a0speed contest, or to\u00a0challenge each other. My son had started working on it this year, [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[104],"class_list":["post-1956","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-adventofcode2022"],"_links":{"self":[{"href":"http:\/\/www.meanboyfriend.com\/overdue_ideas\/wp-json\/wp\/v2\/posts\/1956","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.meanboyfriend.com\/overdue_ideas\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.meanboyfriend.com\/overdue_ideas\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.meanboyfriend.com\/overdue_ideas\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.meanboyfriend.com\/overdue_ideas\/wp-json\/wp\/v2\/comments?post=1956"}],"version-history":[{"count":4,"href":"http:\/\/www.meanboyfriend.com\/overdue_ideas\/wp-json\/wp\/v2\/posts\/1956\/revisions"}],"predecessor-version":[{"id":1961,"href":"http:\/\/www.meanboyfriend.com\/overdue_ideas\/wp-json\/wp\/v2\/posts\/1956\/revisions\/1961"}],"wp:attachment":[{"href":"http:\/\/www.meanboyfriend.com\/overdue_ideas\/wp-json\/wp\/v2\/media?parent=1956"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.meanboyfriend.com\/overdue_ideas\/wp-json\/wp\/v2\/categories?post=1956"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.meanboyfriend.com\/overdue_ideas\/wp-json\/wp\/v2\/tags?post=1956"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}