  {"id":44925,"date":"2025-02-11T13:49:55","date_gmt":"2025-02-11T19:49:55","guid":{"rendered":"https:\/\/uwm.edu\/libraries\/?page_id=44925"},"modified":"2026-02-25T12:39:16","modified_gmt":"2026-02-25T18:39:16","slug":"dh-event-registration-using-openrefine-to-clean-data","status":"publish","type":"page","link":"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-events\/dh-event-registration-using-openrefine-to-clean-data\/","title":{"rendered":"DH event registration: Cleaning up Spreadsheets &#8211; Tidy Data"},"content":{"rendered":"\n<div class=\"uwm-l-row\">\n<div class=\"uwm-l-col\">\n<p><br><strong>Using OpenRefine to Clean Your Data: Regular Expressions<\/strong><br>Thursday, April 3 | 10:00 a.m.<br>Instructor: Nathan Humpal<br>VIRTUAL ONLY<\/p>\n\n\n\n<p>Do you have data that you are collecting in a spreadsheet? Probably! Do you need to clean it up and make it work better? Almost certainly. Join us for a <a href=\"https:\/\/librarycarpentry.github.io\/lc-spreadsheets\/\">Tidy Data<\/a> workshop to learn how to work with your spreadsheet data so it works for you and your research and projects. Bring your messy spreadsheets! (And we\u2019ll have sample messy spreadsheets, too, if you don\u2019t have anything immediately handy)<\/p>\n\n\n<p>Registration for Cleaning up Spreadsheets: Tidy Data has closed. If you have questions, please contact Ann Hanlon, hanlon@uwm.edu<\/p><\/div>\n\n\n\n<div class=\"uwm-l-col uwm-l-col--4\"><div class=\"content_block\" id=\"custom_post_widget-32288\"><nav aria-label=\"Sidebar\" class=\"uwm-p-navigation-list uwm-p-navigation-list--gold-border \"><ul><li><a href=\"https:\/\/uwm.edu\/libraries\/digital-humanities\/\">Digital Humanities Services<\/a><ul><li><a href=\"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-people\/\">People<\/a><\/li><li><a href=\"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-resources\/\">Resources<\/a><ul><li><a href=\"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-resources\/what-are-digital-humanities\/\">What are Digital Humanities?<\/a><\/li><li><a href=\"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-resources\/text-analysis-with-python\/\">Text Analysis with Python<\/a><\/li><li><a href=\"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-resources\/audio-studio\/\">Audio Studio<\/a><\/li><li><a href=\"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-resources\/tools\/\">Tools<\/a><\/li><li><a href=\"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-resources\/lgbtq-audio-archive-mining-project\/\">LGBTQ+ Audio Archive Mining Project<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-teaching\/\">Teaching<\/a><ul><li><a href=\"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-teaching\/dh-lab-assignments\/\">Sample Assignments<\/a><\/li><li><a href=\"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-teaching\/intro-to-python-feedback\/\">DH Teaching Fellows Award<\/a><\/li><li><a href=\"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-teaching\/dh-lab-teaching-fellows\/\">DH Teaching Fellows Award<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/uwm.edu\/libraries\/digital-humanities\/hola-podcast\/\">HOLA Archives Podcast Project<\/a><\/li><li><a href=\"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-videos\/\">Videos<\/a><ul><li><a href=\"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-videos\/sound-image-history\/\">Sound Image History<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-events\/\">Events<\/a><ul><li><a href=\"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-events\/past-events\/\">Past Events<\/a><\/li><\/ul><\/li><\/ul><\/li><li><a href=\"https:\/\/uwm.edu\/libraries\/commons\/\">Daniel M. Soref Learning Commons<\/a><ul><li><a href=\"https:\/\/uwm.edu\/libraries\/commons\/wag_more_wednesdays\/\">Wag More Wednesdays<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/uwm.edu\/libraries\/commons\/\">Daniel M. Soref Learning Commons<\/a><\/li><\/ul><\/nav>\n\n\n<p><\/p>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":137,"featured_media":0,"parent":32339,"menu_order":314,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":"","uwm_wg_additional_authors":[]},"class_list":["post-44925","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>51ÁÔÆæ Libraries<\/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:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-events\/dh-event-registration-using-openrefine-to-clean-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DH event registration: Cleaning up Spreadsheets - Tidy Data\" \/>\n<meta property=\"og:url\" content=\"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-events\/dh-event-registration-using-openrefine-to-clean-data\/\" \/>\n<meta property=\"og:site_name\" content=\"51ÁÔÆæ Libraries\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-25T18:39:16+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:\\\/\\\/uwm.edu\\\/libraries\\\/digital-humanities\\\/dh-lab-events\\\/dh-event-registration-using-openrefine-to-clean-data\\\/\",\"url\":\"https:\\\/\\\/uwm.edu\\\/libraries\\\/digital-humanities\\\/dh-lab-events\\\/dh-event-registration-using-openrefine-to-clean-data\\\/\",\"name\":\"DH event registration: Cleaning up Spreadsheets - Tidy Data - 51ÁÔÆæ Libraries\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/uwm.edu\\\/libraries\\\/#website\"},\"datePublished\":\"2025-02-11T19:49:55+00:00\",\"dateModified\":\"2026-02-25T18:39:16+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/uwm.edu\\\/libraries\\\/digital-humanities\\\/dh-lab-events\\\/dh-event-registration-using-openrefine-to-clean-data\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/uwm.edu\\\/libraries\\\/digital-humanities\\\/dh-lab-events\\\/dh-event-registration-using-openrefine-to-clean-data\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/uwm.edu\\\/libraries\\\/digital-humanities\\\/dh-lab-events\\\/dh-event-registration-using-openrefine-to-clean-data\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/uwm.edu\\\/libraries\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Digital Humanities Services\",\"item\":\"https:\\\/\\\/uwm.edu\\\/libraries\\\/digital-humanities\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Events\",\"item\":\"https:\\\/\\\/uwm.edu\\\/libraries\\\/digital-humanities\\\/dh-lab-events\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"DH event registration: Cleaning up Spreadsheets &#8211; Tidy Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/uwm.edu\\\/libraries\\\/#website\",\"url\":\"https:\\\/\\\/uwm.edu\\\/libraries\\\/\",\"name\":\"51ÁÔÆæ Libraries\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/uwm.edu\\\/libraries\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"51ÁÔÆæ Libraries","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:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-events\/dh-event-registration-using-openrefine-to-clean-data\/","og_locale":"en_US","og_type":"article","og_title":"DH event registration: Cleaning up Spreadsheets - Tidy Data","og_url":"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-events\/dh-event-registration-using-openrefine-to-clean-data\/","og_site_name":"51ÁÔÆæ Libraries","article_modified_time":"2026-02-25T18:39:16+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-events\/dh-event-registration-using-openrefine-to-clean-data\/","url":"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-events\/dh-event-registration-using-openrefine-to-clean-data\/","name":"DH event registration: Cleaning up Spreadsheets - Tidy Data - 51ÁÔÆæ Libraries","isPartOf":{"@id":"https:\/\/uwm.edu\/libraries\/#website"},"datePublished":"2025-02-11T19:49:55+00:00","dateModified":"2026-02-25T18:39:16+00:00","breadcrumb":{"@id":"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-events\/dh-event-registration-using-openrefine-to-clean-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-events\/dh-event-registration-using-openrefine-to-clean-data\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-events\/dh-event-registration-using-openrefine-to-clean-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/uwm.edu\/libraries\/"},{"@type":"ListItem","position":2,"name":"Digital Humanities Services","item":"https:\/\/uwm.edu\/libraries\/digital-humanities\/"},{"@type":"ListItem","position":3,"name":"Events","item":"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-events\/"},{"@type":"ListItem","position":4,"name":"DH event registration: Cleaning up Spreadsheets &#8211; Tidy Data"}]},{"@type":"WebSite","@id":"https:\/\/uwm.edu\/libraries\/#website","url":"https:\/\/uwm.edu\/libraries\/","name":"51ÁÔÆæ Libraries","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/uwm.edu\/libraries\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/uwm.edu\/libraries\/wp-json\/wp\/v2\/pages\/44925","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/uwm.edu\/libraries\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/uwm.edu\/libraries\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/uwm.edu\/libraries\/wp-json\/wp\/v2\/users\/137"}],"replies":[{"embeddable":true,"href":"https:\/\/uwm.edu\/libraries\/wp-json\/wp\/v2\/comments?post=44925"}],"version-history":[{"count":4,"href":"https:\/\/uwm.edu\/libraries\/wp-json\/wp\/v2\/pages\/44925\/revisions"}],"predecessor-version":[{"id":46754,"href":"https:\/\/uwm.edu\/libraries\/wp-json\/wp\/v2\/pages\/44925\/revisions\/46754"}],"up":[{"embeddable":true,"href":"https:\/\/uwm.edu\/libraries\/wp-json\/wp\/v2\/pages\/32339"}],"wp:attachment":[{"href":"https:\/\/uwm.edu\/libraries\/wp-json\/wp\/v2\/media?parent=44925"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}