{"id":5220,"date":"2024-12-02T09:51:46","date_gmt":"2024-12-02T08:51:46","guid":{"rendered":"https:\/\/svjmedia.nl\/datablog\/?p=5220"},"modified":"2024-12-02T10:13:13","modified_gmt":"2024-12-02T09:13:13","slug":"handleiding-openrefine-tutorial","status":"publish","type":"post","link":"https:\/\/svjmedia.nl\/datablog\/5220\/handleiding-openrefine-tutorial\/","title":{"rendered":"Handleiding OpenRefine Tutorial"},"content":{"rendered":"

OpenRefine, voorheen bekend als Google Refine, is een krachtig en flexibel open-source tool dat speciaal is ontworpen voor data cleaning en -transformatie. Het biedt een gebruiksvriendelijke interface waarmee gebruikers moeiteloos grote datasets kunnen beheren, opschonen en analyseren.<\/p>\n

Met OpenRefine kunnen gebruikers:<\/p>\n

    \n
  1. Data opschonen<\/strong>: Identificeer en corrigeer fouten zoals inconsistenties in spelling, duplicaten, en ontbrekende waarden.<\/li>\n
  2. Gegevens transformeren<\/strong>: Zet data om naar een uniform formaat, bijvoorbeeld door datumnotaties aan te passen of tekstuele gegevens te standaardiseren.<\/li>\n
  3. Dataset exploreren<\/strong>: Begrijp de structuur van de data en ontdek trends, patronen, of fouten.<\/li>\n
  4. Complexe operaties uitvoeren<\/strong>: Gebruik krachtige functies zoals \u201cfacet\u201d-weergaven, clustering-algoritmes en GREL (General Refine Expression Language) voor diepgaande analyses.<\/li>\n
  5. Data verrijken<\/strong>: Koppel datasets aan externe bronnen, zoals APIs of kennisbanken (bijvoorbeeld Wikidata), om informatie aan te vullen.<\/li>\n<\/ol>\n

    OpenRefine onderscheidt zich door zijn vermogen om met grote datasets te werken en biedt gebruikers volledige controle over hun bewerkingen, zonder dat deze permanent worden toegepast totdat de gebruiker dat expliciet kiest. Dit maakt het een ideale tool voor iedereen die wil werken met schone, consistente en goed georganiseerde data.<\/p>\n

    In het bijgevoegde document staat onze tutorial. Dankzij deze tutorial wordt de basis van OpenRefine duidelijk, zonder enige voorkennis van het programma. Veel leesplezier!<\/p>\n[aesop_document type=”pdf” src=”https:\/\/svjmedia.nl\/datablog\/wp-content\/uploads\/sites\/862\/2024\/12\/Handleiding-Open.pdf” download=”off”]\n","protected":false},"excerpt":{"rendered":"

    OpenRefine, voorheen bekend als Google Refine, is een krachtig en flexibel open-source tool dat speciaal is ontworpen voor data cleaning en -transformatie. Het biedt een gebruiksvriendelijke interface waarmee gebruikers moeiteloos grote datasets kunnen beheren, opschonen en analyseren. Met OpenRefine kunnen gebruikers: Data opschonen: Identificeer en corrigeer fouten zoals inconsistenties in spelling, duplicaten, en ontbrekende waarden. […]<\/p>\n","protected":false},"author":3318,"featured_media":5222,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[4],"tags":[],"class_list":["post-5220","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","et-has-post-format-content","et_post_format-et-post-format-standard"],"acf":[],"yoast_head":"\nHandleiding OpenRefine Tutorial - Datablog<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Handleiding OpenRefine Tutorial - Datablog\" \/>\n<meta property=\"og:description\" content=\"OpenRefine, voorheen bekend als Google Refine, is een krachtig en flexibel open-source tool dat speciaal is ontworpen voor data cleaning en -transformatie. Het biedt een gebruiksvriendelijke interface waarmee gebruikers moeiteloos grote datasets kunnen beheren, opschonen en analyseren. Met OpenRefine kunnen gebruikers: Data opschonen: Identificeer en corrigeer fouten zoals inconsistenties in spelling, duplicaten, en ontbrekende waarden. […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/svjmedia.nl\/datablog\/5220\/handleiding-openrefine-tutorial\/\" \/>\n<meta property=\"og:site_name\" content=\"Datablog\" \/>\n<meta property=\"article:published_time\" content=\"2024-12-02T08:51:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-02T09:13:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/svjmedia.nl\/datablog\/wp-content\/uploads\/sites\/862\/2024\/12\/OpenRefine-Logo.png\" \/>\n\t<meta property=\"og:image:width\" content=\"225\" \/>\n\t<meta property=\"og:image:height\" content=\"224\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Joram Willemse\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschreven door\" \/>\n\t<meta name=\"twitter:data1\" content=\"Joram Willemse\" \/>\n\t<meta name=\"twitter:label2\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/svjmedia.nl\/datablog\/5220\/handleiding-openrefine-tutorial\/\",\"url\":\"https:\/\/svjmedia.nl\/datablog\/5220\/handleiding-openrefine-tutorial\/\",\"name\":\"Handleiding OpenRefine Tutorial - Datablog\",\"isPartOf\":{\"@id\":\"https:\/\/svjmedia.nl\/datablog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/svjmedia.nl\/datablog\/5220\/handleiding-openrefine-tutorial\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/svjmedia.nl\/datablog\/5220\/handleiding-openrefine-tutorial\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/svjmedia.nl\/datablog\/wp-content\/uploads\/sites\/862\/2024\/12\/OpenRefine-Logo.png\",\"datePublished\":\"2024-12-02T08:51:46+00:00\",\"dateModified\":\"2024-12-02T09:13:13+00:00\",\"author\":{\"@id\":\"https:\/\/svjmedia.nl\/datablog\/#\/schema\/person\/c04ed1a777bd8ee5bc343ffc28beadd9\"},\"breadcrumb\":{\"@id\":\"https:\/\/svjmedia.nl\/datablog\/5220\/handleiding-openrefine-tutorial\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/svjmedia.nl\/datablog\/5220\/handleiding-openrefine-tutorial\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/svjmedia.nl\/datablog\/5220\/handleiding-openrefine-tutorial\/#primaryimage\",\"url\":\"https:\/\/svjmedia.nl\/datablog\/wp-content\/uploads\/sites\/862\/2024\/12\/OpenRefine-Logo.png\",\"contentUrl\":\"https:\/\/svjmedia.nl\/datablog\/wp-content\/uploads\/sites\/862\/2024\/12\/OpenRefine-Logo.png\",\"width\":225,\"height\":224},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/svjmedia.nl\/datablog\/5220\/handleiding-openrefine-tutorial\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/svjmedia.nl\/datablog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Handleiding OpenRefine Tutorial\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/svjmedia.nl\/datablog\/#website\",\"url\":\"https:\/\/svjmedia.nl\/datablog\/\",\"name\":\"Datablog\",\"description\":\"HU School voor Journalistiek - Datablog van de minor Datavisualisatie & Infographics\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/svjmedia.nl\/datablog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/svjmedia.nl\/datablog\/#\/schema\/person\/c04ed1a777bd8ee5bc343ffc28beadd9\",\"name\":\"Joram Willemse\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/svjmedia.nl\/datablog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/010f6bf8e6883525f17e21129ab37f01b4cf41dcb44fcff06b5d6a463a742309?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/010f6bf8e6883525f17e21129ab37f01b4cf41dcb44fcff06b5d6a463a742309?s=96&d=mm&r=g\",\"caption\":\"Joram Willemse\"},\"url\":\"https:\/\/svjmedia.nl\/datablog\/author\/joram-willemse\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Handleiding OpenRefine Tutorial - Datablog","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"nl_NL","og_type":"article","og_title":"Handleiding OpenRefine Tutorial - Datablog","og_description":"OpenRefine, voorheen bekend als Google Refine, is een krachtig en flexibel open-source tool dat speciaal is ontworpen voor data cleaning en -transformatie. Het biedt een gebruiksvriendelijke interface waarmee gebruikers moeiteloos grote datasets kunnen beheren, opschonen en analyseren. Met OpenRefine kunnen gebruikers: Data opschonen: Identificeer en corrigeer fouten zoals inconsistenties in spelling, duplicaten, en ontbrekende waarden. […]","og_url":"https:\/\/svjmedia.nl\/datablog\/5220\/handleiding-openrefine-tutorial\/","og_site_name":"Datablog","article_published_time":"2024-12-02T08:51:46+00:00","article_modified_time":"2024-12-02T09:13:13+00:00","og_image":[{"width":225,"height":224,"url":"https:\/\/svjmedia.nl\/datablog\/wp-content\/uploads\/sites\/862\/2024\/12\/OpenRefine-Logo.png","type":"image\/png"}],"author":"Joram Willemse","twitter_card":"summary_large_image","twitter_misc":{"Geschreven door":"Joram Willemse","Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/svjmedia.nl\/datablog\/5220\/handleiding-openrefine-tutorial\/","url":"https:\/\/svjmedia.nl\/datablog\/5220\/handleiding-openrefine-tutorial\/","name":"Handleiding OpenRefine Tutorial - Datablog","isPartOf":{"@id":"https:\/\/svjmedia.nl\/datablog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/svjmedia.nl\/datablog\/5220\/handleiding-openrefine-tutorial\/#primaryimage"},"image":{"@id":"https:\/\/svjmedia.nl\/datablog\/5220\/handleiding-openrefine-tutorial\/#primaryimage"},"thumbnailUrl":"https:\/\/svjmedia.nl\/datablog\/wp-content\/uploads\/sites\/862\/2024\/12\/OpenRefine-Logo.png","datePublished":"2024-12-02T08:51:46+00:00","dateModified":"2024-12-02T09:13:13+00:00","author":{"@id":"https:\/\/svjmedia.nl\/datablog\/#\/schema\/person\/c04ed1a777bd8ee5bc343ffc28beadd9"},"breadcrumb":{"@id":"https:\/\/svjmedia.nl\/datablog\/5220\/handleiding-openrefine-tutorial\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/svjmedia.nl\/datablog\/5220\/handleiding-openrefine-tutorial\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/svjmedia.nl\/datablog\/5220\/handleiding-openrefine-tutorial\/#primaryimage","url":"https:\/\/svjmedia.nl\/datablog\/wp-content\/uploads\/sites\/862\/2024\/12\/OpenRefine-Logo.png","contentUrl":"https:\/\/svjmedia.nl\/datablog\/wp-content\/uploads\/sites\/862\/2024\/12\/OpenRefine-Logo.png","width":225,"height":224},{"@type":"BreadcrumbList","@id":"https:\/\/svjmedia.nl\/datablog\/5220\/handleiding-openrefine-tutorial\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/svjmedia.nl\/datablog\/"},{"@type":"ListItem","position":2,"name":"Handleiding OpenRefine Tutorial"}]},{"@type":"WebSite","@id":"https:\/\/svjmedia.nl\/datablog\/#website","url":"https:\/\/svjmedia.nl\/datablog\/","name":"Datablog","description":"HU School voor Journalistiek - Datablog van de minor Datavisualisatie & Infographics","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/svjmedia.nl\/datablog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Person","@id":"https:\/\/svjmedia.nl\/datablog\/#\/schema\/person\/c04ed1a777bd8ee5bc343ffc28beadd9","name":"Joram Willemse","image":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/svjmedia.nl\/datablog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/010f6bf8e6883525f17e21129ab37f01b4cf41dcb44fcff06b5d6a463a742309?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/010f6bf8e6883525f17e21129ab37f01b4cf41dcb44fcff06b5d6a463a742309?s=96&d=mm&r=g","caption":"Joram Willemse"},"url":"https:\/\/svjmedia.nl\/datablog\/author\/joram-willemse\/"}]}},"_links":{"self":[{"href":"https:\/\/svjmedia.nl\/datablog\/wp-json\/wp\/v2\/posts\/5220","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/svjmedia.nl\/datablog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/svjmedia.nl\/datablog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/svjmedia.nl\/datablog\/wp-json\/wp\/v2\/users\/3318"}],"replies":[{"embeddable":true,"href":"https:\/\/svjmedia.nl\/datablog\/wp-json\/wp\/v2\/comments?post=5220"}],"version-history":[{"count":1,"href":"https:\/\/svjmedia.nl\/datablog\/wp-json\/wp\/v2\/posts\/5220\/revisions"}],"predecessor-version":[{"id":5223,"href":"https:\/\/svjmedia.nl\/datablog\/wp-json\/wp\/v2\/posts\/5220\/revisions\/5223"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/svjmedia.nl\/datablog\/wp-json\/wp\/v2\/media\/5222"}],"wp:attachment":[{"href":"https:\/\/svjmedia.nl\/datablog\/wp-json\/wp\/v2\/media?parent=5220"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/svjmedia.nl\/datablog\/wp-json\/wp\/v2\/categories?post=5220"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/svjmedia.nl\/datablog\/wp-json\/wp\/v2\/tags?post=5220"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}