{"id":113088,"date":"2020-11-12T09:47:57","date_gmt":"2020-11-12T08:47:57","guid":{"rendered":"https:\/\/uniavisen.dk\/event\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\/"},"modified":"2020-11-12T09:47:57","modified_gmt":"2020-11-12T08:47:57","slug":"kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data","status":"publish","type":"event","link":"https:\/\/uniavisen.dk\/en\/event\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\/","title":{"rendered":"KUB Datalab: Basic introduction to OpenRefine \u2013 cleaning messy data"},"content":{"rendered":"<p>OpenRefine is a free tool, which can help you clean messy data. At the course you will import an excel-file to OpenRefine, work with several data cleaning options in OpenRefine, and export the file to excel after the cleaning. You will edit the data via OpenRefine\u2019s graphical user interface as well as via simple coding. In addition to these hands-on exercises, you will see examples of how OpenRefine can be used to enrich your data with data from online sources.<\/p>\n<p>The course is a basic introduction. You are not expected to have worked with OpenRefine before the course.<\/p>\n<p><strong>Requirements<\/strong>:<\/p>\n<ul>\n<li>Excel user (familiar with basic use of excel)<\/li>\n<li>PC user (We are developing a course for Mac users but we are not ready yet)<\/li>\n<\/ul>\n<p><strong>Your preparation before the course:<\/strong><\/p>\n<ul>\n<li>Install OpenRefine on your PC:\u00a0<a href=\"https:\/\/openrefine.org\/download.html\">https:\/\/openrefine.org\/download.html<\/a><\/li>\n<li>If possible, bring your own excelfile with messy data. If you have specific questions about how to clean you data, please send the question and excel-file to kubdatalab@kb.dk at least two days before the course. If you don\u2019t have an excelfile with messy data the course instructor has a file you can use.<\/li>\n<\/ul>\n<p><strong>After the course the participants have:<\/strong><\/p>\n<ul>\n<li>Imported an excel file to OpenRefine<\/li>\n<li>Exported data from OpenRefine to excel<\/li>\n<li>Worked with simple data cleaning operations via OpenRefine\u2019s graphical user interface<\/li>\n<li>Worked with simple data cleaning operations via OpenRefine\u2019s simple coding (GREL and Regular Expressions)<\/li>\n<li>Got a brief introduction to how OpenRefine can help you enrich your data with data from online sources.<\/li>\n<\/ul>\n<p>No registration required &#8211; just show up!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>OpenRefine is a free tool, which can help you clean messy data. At the course you will import an excel-file to OpenRefine, work with several data cleaning options in OpenRefine, and export the file to excel after the cleaning. You will edit the data via OpenRefine\u2019s graphical user interface as well as via simple coding. [&hellip;]<\/p>\n","protected":false},"author":0,"featured_media":113089,"template":"","class_list":["post-113088","event","type-event","status-publish","has-post-thumbnail","hentry","event_category-oevrige"],"acf":[],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>KUB Datalab: Basic introduction to OpenRefine \u2013 cleaning messy data<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/uniavisen.dk\/en\/event\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"KUB Datalab: Basic introduction to OpenRefine \u2013 cleaning messy data\" \/>\n<meta property=\"og:description\" content=\"OpenRefine is a free tool, which can help you clean messy data. At the course you will import an excel-file to OpenRefine, work with several data cleaning options in OpenRefine, and export the file to excel after the cleaning. You will edit the data via OpenRefine\u2019s graphical user interface as well as via simple coding. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/uniavisen.dk\/en\/event\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\/\" \/>\n<meta property=\"og:site_name\" content=\"University Post\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/uniavis\" \/>\n<meta property=\"og:image\" content=\"https:\/\/uniavisen.dk\/wp-content\/uploads\/2020\/11\/1600337889.png\" \/>\n\t<meta property=\"og:image:width\" content=\"820\" \/>\n\t<meta property=\"og:image:height\" content=\"768\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@Uniavisen\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/uniavisen.dk\\\/en\\\/event\\\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\\\/\",\"url\":\"https:\\\/\\\/uniavisen.dk\\\/en\\\/event\\\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\\\/\",\"name\":\"KUB Datalab: Basic introduction to OpenRefine \u2013 cleaning messy data\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/uniavisen.dk\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/uniavisen.dk\\\/en\\\/event\\\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/uniavisen.dk\\\/en\\\/event\\\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/uniavisen.dk\\\/wp-content\\\/uploads\\\/2020\\\/11\\\/1600337889.png\",\"datePublished\":\"2020-11-12T08:47:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/uniavisen.dk\\\/en\\\/event\\\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/uniavisen.dk\\\/en\\\/event\\\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/uniavisen.dk\\\/en\\\/event\\\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\\\/#primaryimage\",\"url\":\"https:\\\/\\\/uniavisen.dk\\\/wp-content\\\/uploads\\\/2020\\\/11\\\/1600337889.png\",\"contentUrl\":\"https:\\\/\\\/uniavisen.dk\\\/wp-content\\\/uploads\\\/2020\\\/11\\\/1600337889.png\",\"width\":820,\"height\":768},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/uniavisen.dk\\\/en\\\/event\\\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/uniavisen.dk\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Events\",\"item\":\"https:\\\/\\\/uniavisen.dk\\\/event\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"KUB Datalab: Basic introduction to OpenRefine \u2013 cleaning messy data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/uniavisen.dk\\\/#website\",\"url\":\"https:\\\/\\\/uniavisen.dk\\\/\",\"name\":\"University Post\",\"description\":\"Independent of management\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/uniavisen.dk\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"KUB Datalab: Basic introduction to OpenRefine \u2013 cleaning messy data","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/uniavisen.dk\/en\/event\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\/","og_locale":"en_US","og_type":"article","og_title":"KUB Datalab: Basic introduction to OpenRefine \u2013 cleaning messy data","og_description":"OpenRefine is a free tool, which can help you clean messy data. At the course you will import an excel-file to OpenRefine, work with several data cleaning options in OpenRefine, and export the file to excel after the cleaning. You will edit the data via OpenRefine\u2019s graphical user interface as well as via simple coding. [&hellip;]","og_url":"https:\/\/uniavisen.dk\/en\/event\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\/","og_site_name":"University Post","article_publisher":"https:\/\/www.facebook.com\/uniavis","og_image":[{"width":820,"height":768,"url":"https:\/\/uniavisen.dk\/wp-content\/uploads\/2020\/11\/1600337889.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@Uniavisen","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/uniavisen.dk\/en\/event\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\/","url":"https:\/\/uniavisen.dk\/en\/event\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\/","name":"KUB Datalab: Basic introduction to OpenRefine \u2013 cleaning messy data","isPartOf":{"@id":"https:\/\/uniavisen.dk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/uniavisen.dk\/en\/event\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\/#primaryimage"},"image":{"@id":"https:\/\/uniavisen.dk\/en\/event\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\/#primaryimage"},"thumbnailUrl":"https:\/\/uniavisen.dk\/wp-content\/uploads\/2020\/11\/1600337889.png","datePublished":"2020-11-12T08:47:57+00:00","breadcrumb":{"@id":"https:\/\/uniavisen.dk\/en\/event\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/uniavisen.dk\/en\/event\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/uniavisen.dk\/en\/event\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\/#primaryimage","url":"https:\/\/uniavisen.dk\/wp-content\/uploads\/2020\/11\/1600337889.png","contentUrl":"https:\/\/uniavisen.dk\/wp-content\/uploads\/2020\/11\/1600337889.png","width":820,"height":768},{"@type":"BreadcrumbList","@id":"https:\/\/uniavisen.dk\/en\/event\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/uniavisen.dk\/en\/"},{"@type":"ListItem","position":2,"name":"Events","item":"https:\/\/uniavisen.dk\/event\/"},{"@type":"ListItem","position":3,"name":"KUB Datalab: Basic introduction to OpenRefine \u2013 cleaning messy data"}]},{"@type":"WebSite","@id":"https:\/\/uniavisen.dk\/#website","url":"https:\/\/uniavisen.dk\/","name":"University Post","description":"Independent of management","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/uniavisen.dk\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"advancedCustomFields":{"event_category":{"term_id":70,"name":"\u00d8vrige","slug":"oevrige","term_group":0,"term_taxonomy_id":70,"taxonomy":"event_category","description":"","parent":0,"count":575,"filter":"raw"},"start":"2020-11-16 11:00:00","add_end_time":true,"end":"2020-11-16 12:00:00","location":"Data Lab<br \/>\r\nKUB Nord - Natur og Sundhedsvidenskab, N\u00f8rre All\u00e9 49, 2200 K\u00f8benhavn N","host_name":"K\u00f8benhavns Universitetsbibliotek Datalab","ticket_link":"https:\/\/kubkalender.kb.dk\/event\/3513891","event_is_free":true,"event_poster":{"ID":113089,"id":113089,"title":"1600337889.png","filename":"1600337889.png","filesize":113003,"url":"https:\/\/uniavisen.dk\/wp-content\/uploads\/2020\/11\/1600337889.png","link":"https:\/\/uniavisen.dk\/en\/event\/kub-datalab-basic-introduction-to-openrefine-cleaning-messy-data\/1600337889-png\/","alt":"","author":"0","description":"","caption":"","name":"1600337889-png","status":"inherit","uploaded_to":113088,"date":"2020-11-12 08:47:57","modified":"2020-11-12 08:48:07","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/uniavisen.dk\/wp-includes\/images\/media\/default.png","width":820,"height":768,"sizes":{"thumbnail":"https:\/\/uniavisen.dk\/wp-content\/uploads\/2020\/11\/1600337889-150x150.png","thumbnail-width":150,"thumbnail-height":150,"medium":"https:\/\/uniavisen.dk\/wp-content\/uploads\/2020\/11\/1600337889-480x450.png","medium-width":480,"medium-height":450,"medium_large":"https:\/\/uniavisen.dk\/wp-content\/uploads\/2020\/11\/1600337889-768x719.png","medium_large-width":768,"medium_large-height":719,"large":"https:\/\/uniavisen.dk\/wp-content\/uploads\/2020\/11\/1600337889.png","large-width":820,"large-height":768,"1536x1536":"https:\/\/uniavisen.dk\/wp-content\/uploads\/2020\/11\/1600337889.png","1536x1536-width":820,"1536x1536-height":768,"2048x2048":"https:\/\/uniavisen.dk\/wp-content\/uploads\/2020\/11\/1600337889.png","2048x2048-width":820,"2048x2048-height":768,"featured-soft":"https:\/\/uniavisen.dk\/wp-content\/uploads\/2020\/11\/1600337889-290x272.png","featured-soft-width":290,"featured-soft-height":272,"featured-hard":"https:\/\/uniavisen.dk\/wp-content\/uploads\/2020\/11\/1600337889-290x180.png","featured-hard-width":290,"featured-hard-height":180,"narrow":"https:\/\/uniavisen.dk\/wp-content\/uploads\/2020\/11\/1600337889-700x656.png","narrow-width":700,"narrow-height":656,"extended":"https:\/\/uniavisen.dk\/wp-content\/uploads\/2020\/11\/1600337889.png","extended-width":820,"extended-height":768}},"short_description":"OpenRefine is a free tool, which can help you clean messy data. At the course you will import an excel-file to OpenRefine, work with several data cleaning options in OpenRefine.\r\nThe course is a basic introduction.","old_url":""},"_links":{"self":[{"href":"https:\/\/uniavisen.dk\/en\/wp-json\/wp\/v2\/events\/113088","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/uniavisen.dk\/en\/wp-json\/wp\/v2\/events"}],"about":[{"href":"https:\/\/uniavisen.dk\/en\/wp-json\/wp\/v2\/types\/event"}],"version-history":[{"count":0,"href":"https:\/\/uniavisen.dk\/en\/wp-json\/wp\/v2\/events\/113088\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/uniavisen.dk\/en\/wp-json\/wp\/v2\/media\/113089"}],"wp:attachment":[{"href":"https:\/\/uniavisen.dk\/en\/wp-json\/wp\/v2\/media?parent=113088"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}