{"id":6408,"date":"2025-11-26T10:18:35","date_gmt":"2025-11-26T09:18:35","guid":{"rendered":"https:\/\/svjmedia.nl\/datablog\/?p=6408"},"modified":"2025-11-26T10:33:35","modified_gmt":"2025-11-26T09:33:35","slug":"tutorial-openrefine-2025","status":"publish","type":"post","link":"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/","title":{"rendered":"Tutorial: OpenRefine"},"content":{"rendered":"\n<p>OpenRefine is een veelzijdig open-sourceprogramma dat speciaal ontwikkeld is om datasets te ordenen, schoon te maken en te bewerken. Het biedt een overzichtelijke omgeving waarin gebruikers effici\u00ebnt met grote hoeveelheden data kunnen werken.<\/p>\n<p>Met dit programma kun je:<\/p>\n<p><strong>Data opschonen:<\/strong> Opsporen en herstellen van onregelmatigheden, zoals verschillen in schrijfwijze, dubbele records of lege velden.<br \/>\n<strong>Gegevens omzetten:<\/strong> Waardes omzetten naar een uniform formaat, bijvoorbeeld door datumstijlen gelijk te trekken of tekstconsistentie aan te brengen.<br \/>\n<strong>Complexere bewerkingen uitvoeren:<\/strong> Gebruikmaken van functies zoals facetten, clusteringtechnieken en de expressietaal GREL voor grondigere analyses.<br \/>\n<strong>Datasets verkennen:<\/strong> Inzicht krijgen in de structuur van de gegevens en mogelijke trends, afwijkingen of fouten ontdekken<\/p>\n<p>Een van de sterke punten van OpenRefine is dat het geschikt is voor grote bestanden en dat elke stap die je zet terug te draaien is totdat je besluit de wijzigingen definitief te maken. Hierdoor blijft het bewerken van data veilig en beheersbaar.<\/p>\n<p>In het bijgevoegde document vind je onze handleiding. Deze introductie helpt je om de basis van OpenRefine snel onder de knie te krijgen, ook als je het programma nog niet eerder hebt gebruikt.<\/p>\n<p>Voor deze tutorial maken we gebruik van deze data set:<\/p>\n[aesop_document  type=&#8221;download&#8221; src=&#8221;https:\/\/svjmedia.nl\/datablog\/wp-content\/uploads\/sites\/862\/2025\/11\/spotify-2023-top100-moststreamed.xlsx&#8221; download=&#8221;off&#8221;]\n<p>En dit is de handleiding:<\/p>\n[aesop_document  type=&#8221;download&#8221; src=&#8221;https:\/\/svjmedia.nl\/datablog\/wp-content\/uploads\/sites\/862\/2025\/11\/Handleiding-OpenRefine.pdf&#8221; download=&#8221;off&#8221;]\n<p>Veel succes en plezier!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>OpenRefine is een veelzijdig open-sourceprogramma dat speciaal ontwikkeld is om datasets te ordenen, schoon te maken en te bewerken. Het biedt een overzichtelijke omgeving waarin gebruikers effici\u00ebnt met grote hoeveelheden data kunnen werken. Met dit programma kun je: Data opschonen: Opsporen en herstellen van onregelmatigheden, zoals verschillen in schrijfwijze, dubbele records of lege velden. Gegevens [&hellip;]<\/p>\n","protected":false},"author":3785,"featured_media":6415,"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":[36,190],"class_list":["post-6408","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-tutorial","tag-tutorials","et-has-post-format-content","et_post_format-et-post-format-standard"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Tutorial: OpenRefine - 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=\"Tutorial: OpenRefine - Datablog\" \/>\n<meta property=\"og:description\" content=\"OpenRefine is een veelzijdig open-sourceprogramma dat speciaal ontwikkeld is om datasets te ordenen, schoon te maken en te bewerken. Het biedt een overzichtelijke omgeving waarin gebruikers effici\u00ebnt met grote hoeveelheden data kunnen werken. Met dit programma kun je: Data opschonen: Opsporen en herstellen van onregelmatigheden, zoals verschillen in schrijfwijze, dubbele records of lege velden. Gegevens [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/\" \/>\n<meta property=\"og:site_name\" content=\"Datablog\" \/>\n<meta property=\"article:published_time\" content=\"2025-11-26T09:18:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-26T09:33:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/svjmedia.nl\/datablog\/wp-content\/uploads\/sites\/862\/2025\/11\/Schermafbeelding-2025-11-26-102934.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1182\" \/>\n\t<meta property=\"og:image:height\" content=\"940\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Am\u00e9lie Ong\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschreven door\" \/>\n\t<meta name=\"twitter:data1\" content=\"Am\u00e9lie Ong\" \/>\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\":\"Article\",\"@id\":\"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/\"},\"author\":{\"name\":\"Am\u00e9lie Ong\",\"@id\":\"https:\/\/svjmedia.nl\/datablog\/#\/schema\/person\/1920d9c27daa6477fafe3a7a2c9c8a5d\"},\"headline\":\"Tutorial: OpenRefine\",\"datePublished\":\"2025-11-26T09:18:35+00:00\",\"dateModified\":\"2025-11-26T09:33:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/\"},\"wordCount\":239,\"image\":{\"@id\":\"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/svjmedia.nl\/datablog\/wp-content\/uploads\/sites\/862\/2025\/11\/Schermafbeelding-2025-11-26-102934.png\",\"keywords\":[\"tutorial\",\"tutorials\"],\"articleSection\":[\"Tutorials\"],\"inLanguage\":\"nl-NL\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/\",\"url\":\"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/\",\"name\":\"Tutorial: OpenRefine - Datablog\",\"isPartOf\":{\"@id\":\"https:\/\/svjmedia.nl\/datablog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/svjmedia.nl\/datablog\/wp-content\/uploads\/sites\/862\/2025\/11\/Schermafbeelding-2025-11-26-102934.png\",\"datePublished\":\"2025-11-26T09:18:35+00:00\",\"dateModified\":\"2025-11-26T09:33:35+00:00\",\"author\":{\"@id\":\"https:\/\/svjmedia.nl\/datablog\/#\/schema\/person\/1920d9c27daa6477fafe3a7a2c9c8a5d\"},\"breadcrumb\":{\"@id\":\"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/#primaryimage\",\"url\":\"https:\/\/svjmedia.nl\/datablog\/wp-content\/uploads\/sites\/862\/2025\/11\/Schermafbeelding-2025-11-26-102934.png\",\"contentUrl\":\"https:\/\/svjmedia.nl\/datablog\/wp-content\/uploads\/sites\/862\/2025\/11\/Schermafbeelding-2025-11-26-102934.png\",\"width\":1182,\"height\":940},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/svjmedia.nl\/datablog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tutorial: OpenRefine\"}]},{\"@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 &amp; 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\/1920d9c27daa6477fafe3a7a2c9c8a5d\",\"name\":\"Am\u00e9lie Ong\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/svjmedia.nl\/datablog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/610c190ffc55801e261b67764c07b6c5fe5ec6d7451bd710e2935e9d750299f0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/610c190ffc55801e261b67764c07b6c5fe5ec6d7451bd710e2935e9d750299f0?s=96&d=mm&r=g\",\"caption\":\"Am\u00e9lie Ong\"},\"url\":\"https:\/\/svjmedia.nl\/datablog\/author\/amelie-ong\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tutorial: OpenRefine - 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":"Tutorial: OpenRefine - Datablog","og_description":"OpenRefine is een veelzijdig open-sourceprogramma dat speciaal ontwikkeld is om datasets te ordenen, schoon te maken en te bewerken. Het biedt een overzichtelijke omgeving waarin gebruikers effici\u00ebnt met grote hoeveelheden data kunnen werken. Met dit programma kun je: Data opschonen: Opsporen en herstellen van onregelmatigheden, zoals verschillen in schrijfwijze, dubbele records of lege velden. Gegevens [&hellip;]","og_url":"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/","og_site_name":"Datablog","article_published_time":"2025-11-26T09:18:35+00:00","article_modified_time":"2025-11-26T09:33:35+00:00","og_image":[{"width":1182,"height":940,"url":"https:\/\/svjmedia.nl\/datablog\/wp-content\/uploads\/sites\/862\/2025\/11\/Schermafbeelding-2025-11-26-102934.png","type":"image\/png"}],"author":"Am\u00e9lie Ong","twitter_card":"summary_large_image","twitter_misc":{"Geschreven door":"Am\u00e9lie Ong","Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/#article","isPartOf":{"@id":"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/"},"author":{"name":"Am\u00e9lie Ong","@id":"https:\/\/svjmedia.nl\/datablog\/#\/schema\/person\/1920d9c27daa6477fafe3a7a2c9c8a5d"},"headline":"Tutorial: OpenRefine","datePublished":"2025-11-26T09:18:35+00:00","dateModified":"2025-11-26T09:33:35+00:00","mainEntityOfPage":{"@id":"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/"},"wordCount":239,"image":{"@id":"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/#primaryimage"},"thumbnailUrl":"https:\/\/svjmedia.nl\/datablog\/wp-content\/uploads\/sites\/862\/2025\/11\/Schermafbeelding-2025-11-26-102934.png","keywords":["tutorial","tutorials"],"articleSection":["Tutorials"],"inLanguage":"nl-NL"},{"@type":"WebPage","@id":"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/","url":"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/","name":"Tutorial: OpenRefine - Datablog","isPartOf":{"@id":"https:\/\/svjmedia.nl\/datablog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/#primaryimage"},"image":{"@id":"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/#primaryimage"},"thumbnailUrl":"https:\/\/svjmedia.nl\/datablog\/wp-content\/uploads\/sites\/862\/2025\/11\/Schermafbeelding-2025-11-26-102934.png","datePublished":"2025-11-26T09:18:35+00:00","dateModified":"2025-11-26T09:33:35+00:00","author":{"@id":"https:\/\/svjmedia.nl\/datablog\/#\/schema\/person\/1920d9c27daa6477fafe3a7a2c9c8a5d"},"breadcrumb":{"@id":"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/#primaryimage","url":"https:\/\/svjmedia.nl\/datablog\/wp-content\/uploads\/sites\/862\/2025\/11\/Schermafbeelding-2025-11-26-102934.png","contentUrl":"https:\/\/svjmedia.nl\/datablog\/wp-content\/uploads\/sites\/862\/2025\/11\/Schermafbeelding-2025-11-26-102934.png","width":1182,"height":940},{"@type":"BreadcrumbList","@id":"https:\/\/svjmedia.nl\/datablog\/6408\/tutorial-openrefine-2025\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/svjmedia.nl\/datablog\/"},{"@type":"ListItem","position":2,"name":"Tutorial: OpenRefine"}]},{"@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 &amp; 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\/1920d9c27daa6477fafe3a7a2c9c8a5d","name":"Am\u00e9lie Ong","image":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/svjmedia.nl\/datablog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/610c190ffc55801e261b67764c07b6c5fe5ec6d7451bd710e2935e9d750299f0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/610c190ffc55801e261b67764c07b6c5fe5ec6d7451bd710e2935e9d750299f0?s=96&d=mm&r=g","caption":"Am\u00e9lie Ong"},"url":"https:\/\/svjmedia.nl\/datablog\/author\/amelie-ong\/"}]}},"_links":{"self":[{"href":"https:\/\/svjmedia.nl\/datablog\/wp-json\/wp\/v2\/posts\/6408","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\/3785"}],"replies":[{"embeddable":true,"href":"https:\/\/svjmedia.nl\/datablog\/wp-json\/wp\/v2\/comments?post=6408"}],"version-history":[{"count":3,"href":"https:\/\/svjmedia.nl\/datablog\/wp-json\/wp\/v2\/posts\/6408\/revisions"}],"predecessor-version":[{"id":6416,"href":"https:\/\/svjmedia.nl\/datablog\/wp-json\/wp\/v2\/posts\/6408\/revisions\/6416"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/svjmedia.nl\/datablog\/wp-json\/wp\/v2\/media\/6415"}],"wp:attachment":[{"href":"https:\/\/svjmedia.nl\/datablog\/wp-json\/wp\/v2\/media?parent=6408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/svjmedia.nl\/datablog\/wp-json\/wp\/v2\/categories?post=6408"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/svjmedia.nl\/datablog\/wp-json\/wp\/v2\/tags?post=6408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}