{"id":1092,"date":"2025-11-17T16:21:26","date_gmt":"2025-11-17T21:21:26","guid":{"rendered":"https:\/\/ag.purdue.edu\/researchservices\/?page_id=1092"},"modified":"2025-11-20T14:18:53","modified_gmt":"2025-11-20T19:18:53","slug":"openrefine","status":"publish","type":"page","link":"https:\/\/ag.purdue.edu\/researchservices\/training\/openrefine\/","title":{"rendered":"Messy to ready data with OpenRefine"},"content":{"rendered":"<div  class=\"section \">\n    <div class=\"container\">\n                \n\n<div class=\"wp-block-columns page-layout-columns columns is-multiline is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column column is-full-tablet page-layout-main is-layout-flow wp-block-column-is-layout-flow\">\n<h2 class=\"wp-block-heading\">Messy to ready data with OpenRefine<\/h2>\n\n\n\n<p>This workshop is designed for departments, labs, and research groups who work with messy survey or field data and want a faster, more reproducible cleaning process. The session introduces participants to OpenRefine and walks them through practical tasks researchers face every day: identifying inconsistencies, resolving typos with clustering, converting text into proper dates and numbers, cleaning multi-value fields, and exporting a fully documented, analysis-ready dataset.<\/p>\n\n\n\n<p>It has been successfully delivered in the Agricultural Economics department, where graduate students worked through a real-world dataset and left with a clean file and an exportable record of every step taken. The workshop focuses on concrete outcomes: improving data quality, reducing manual cleaning time, and building confidence in preparing datasets for statistical analysis. Departments and labs across Purdue can request this session and have it customized to their specific data and research needs.<\/p>\n<\/div>\n<\/div>\n\n    <\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":1076,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-1092","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Messy to ready data with OpenRefine - Research Services<\/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:\/\/ag.purdue.edu\/researchservices\/training\/openrefine\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Messy to ready data with OpenRefine - Research Services\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ag.purdue.edu\/researchservices\/training\/openrefine\/\" \/>\n<meta property=\"og:site_name\" content=\"Research Services\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-20T19:18:53+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\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:\/\/ag.purdue.edu\/researchservices\/training\/openrefine\/\",\"url\":\"https:\/\/ag.purdue.edu\/researchservices\/training\/openrefine\/\",\"name\":\"Messy to ready data with OpenRefine - Research Services\",\"isPartOf\":{\"@id\":\"https:\/\/ag.purdue.edu\/researchservices\/#website\"},\"datePublished\":\"2025-11-17T21:21:26+00:00\",\"dateModified\":\"2025-11-20T19:18:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/ag.purdue.edu\/researchservices\/training\/openrefine\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ag.purdue.edu\/researchservices\/training\/openrefine\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ag.purdue.edu\/researchservices\/training\/openrefine\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ag.purdue.edu\/researchservices\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Training\",\"item\":\"https:\/\/ag.purdue.edu\/researchservices\/training\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Messy to ready data with OpenRefine\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ag.purdue.edu\/researchservices\/#website\",\"url\":\"https:\/\/ag.purdue.edu\/researchservices\/\",\"name\":\"Research Services\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/ag.purdue.edu\/researchservices\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ag.purdue.edu\/researchservices\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/ag.purdue.edu\/researchservices\/#organization\",\"name\":\"Research Services\",\"url\":\"https:\/\/ag.purdue.edu\/researchservices\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ag.purdue.edu\/researchservices\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/ag.purdue.edu\/researchservices\/wp-content\/uploads\/2024\/12\/cropped-ARGE_H-Full-RGB_1.png\",\"contentUrl\":\"https:\/\/ag.purdue.edu\/researchservices\/wp-content\/uploads\/2024\/12\/cropped-ARGE_H-Full-RGB_1.png\",\"width\":834,\"height\":100,\"caption\":\"Research Services\"},\"image\":{\"@id\":\"https:\/\/ag.purdue.edu\/researchservices\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Messy to ready data with OpenRefine - Research Services","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:\/\/ag.purdue.edu\/researchservices\/training\/openrefine\/","og_locale":"en_US","og_type":"article","og_title":"Messy to ready data with OpenRefine - Research Services","og_url":"https:\/\/ag.purdue.edu\/researchservices\/training\/openrefine\/","og_site_name":"Research Services","article_modified_time":"2025-11-20T19:18:53+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ag.purdue.edu\/researchservices\/training\/openrefine\/","url":"https:\/\/ag.purdue.edu\/researchservices\/training\/openrefine\/","name":"Messy to ready data with OpenRefine - Research Services","isPartOf":{"@id":"https:\/\/ag.purdue.edu\/researchservices\/#website"},"datePublished":"2025-11-17T21:21:26+00:00","dateModified":"2025-11-20T19:18:53+00:00","breadcrumb":{"@id":"https:\/\/ag.purdue.edu\/researchservices\/training\/openrefine\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ag.purdue.edu\/researchservices\/training\/openrefine\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ag.purdue.edu\/researchservices\/training\/openrefine\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ag.purdue.edu\/researchservices\/"},{"@type":"ListItem","position":2,"name":"Training","item":"https:\/\/ag.purdue.edu\/researchservices\/training\/"},{"@type":"ListItem","position":3,"name":"Messy to ready data with OpenRefine"}]},{"@type":"WebSite","@id":"https:\/\/ag.purdue.edu\/researchservices\/#website","url":"https:\/\/ag.purdue.edu\/researchservices\/","name":"Research Services","description":"","publisher":{"@id":"https:\/\/ag.purdue.edu\/researchservices\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ag.purdue.edu\/researchservices\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/ag.purdue.edu\/researchservices\/#organization","name":"Research Services","url":"https:\/\/ag.purdue.edu\/researchservices\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ag.purdue.edu\/researchservices\/#\/schema\/logo\/image\/","url":"https:\/\/ag.purdue.edu\/researchservices\/wp-content\/uploads\/2024\/12\/cropped-ARGE_H-Full-RGB_1.png","contentUrl":"https:\/\/ag.purdue.edu\/researchservices\/wp-content\/uploads\/2024\/12\/cropped-ARGE_H-Full-RGB_1.png","width":834,"height":100,"caption":"Research Services"},"image":{"@id":"https:\/\/ag.purdue.edu\/researchservices\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/ag.purdue.edu\/researchservices\/wp-json\/wp\/v2\/pages\/1092","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ag.purdue.edu\/researchservices\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ag.purdue.edu\/researchservices\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ag.purdue.edu\/researchservices\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ag.purdue.edu\/researchservices\/wp-json\/wp\/v2\/comments?post=1092"}],"version-history":[{"count":5,"href":"https:\/\/ag.purdue.edu\/researchservices\/wp-json\/wp\/v2\/pages\/1092\/revisions"}],"predecessor-version":[{"id":1123,"href":"https:\/\/ag.purdue.edu\/researchservices\/wp-json\/wp\/v2\/pages\/1092\/revisions\/1123"}],"up":[{"embeddable":true,"href":"https:\/\/ag.purdue.edu\/researchservices\/wp-json\/wp\/v2\/pages\/1076"}],"wp:attachment":[{"href":"https:\/\/ag.purdue.edu\/researchservices\/wp-json\/wp\/v2\/media?parent=1092"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}