{"id":4625,"date":"2026-09-09T16:45:04","date_gmt":"2026-09-09T19:45:04","guid":{"rendered":"https:\/\/ccdhhn.ca\/?post_type=tribe_events&#038;p=4625"},"modified":"2026-09-09T16:45:06","modified_gmt":"2026-09-09T19:45:06","slug":"data-cleaning-with-openrefine","status":"publish","type":"tribe_events","link":"https:\/\/ccdhhn.ca\/fr\/workshop\/data-cleaning-with-openrefine\/","title":{"rendered":"Data Cleaning with OpenRefine"},"content":{"rendered":"<div  class=\"tribe-block tribe-block__additional-field tribe-block__additional-field__dropdown\" >\n\t<h3>Format <\/h3>\n\tvirtual\/virtuel<\/div>\n\n\n<div  class=\"tribe-block tribe-block__additional-field tribe-block__additional-field__dropdown\" >\n\t<h3>Event Language<\/h3>\n\tEnglish<\/div>\n\n\n<div  class=\"tribe-events-single-section tribe-events-section-category tribe-clearfix\" >\n\t<dt class=\"tribe-events-event-categories-label\">Cat\u00e9gorie d\u2019\u00c9v\u00e8nement:<\/dt> <dd class=\"tribe-events-event-categories\"><a href=\"https:\/\/ccdhhn.ca\/workshops\/category\/1-4-hour-workshop\/\" rel=\"tag\">1-4 hour workshop<\/a><\/dd><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Researchers and librarians often deal with \u201cmessy\u201d data. This could include inconsistent interview transcripts, poorly formatted longitudinal datasets, or standardizing names for an authority file. Preparing this data for analysis is a critical step that requires the same level of rigor and reproducibility as the analysis itself. This workshop introduces OpenRefine, a powerful, free, and open-source tool for cleaning, normalizing, and transforming research data. participants work with a sample dataset to learn how to efficiently handle common data issues, such as automating data standardization, identifying clusters of similar entries, and transforming complex strings into structured information without the need for advanced programming. Unlike manual editing in Excel, OpenRefine records every step of your process, ensuring your data cleaning is transparent and fully reproducible. Participants should be comfortable using a computer and have a general understanding of spreadsheets. No prior programming experience is necessary.<\/p>\n\n\n<div  class=\"tribe-block tribe-block__organizer__details tribe-clearfix\" >\n\t<div class=\"tribe-block__organizer__title\">\n\t\t<h3><a href=\"https:\/\/ccdhhn.ca\/fr\/organisateur\/acenet\/\" title=\"ACENET\" target=\"_self\" rel=\"\">ACENET<\/a><\/h3>\n\t<\/div>\n\t\t\t\t<p class=\"tribe-block__organizer__website\"><a href=\"https:\/\/www.ace-net.ca\/\" target=\"_blank\" rel=\"noopener noreferrer\">View Organisateur Website<\/a><\/p>\n\t\t<\/div>\n\n\n<div  class=\"tribe-block tribe-block__event-website\" >\n\t<a\n\t\thref=\"https:\/\/www.ace-net.ca\/training-course\/introduction-to-openrefine\/\"\n\t\ttarget=\"_self\"\n\t\t\t>\n\t\tWebsite and Registration\t<\/a>\n<\/div>\n\n\n\t<div  class=\"tribe-block tribe-block__events-link\" >\n\t\t<div class=\"tribe-events tribe-common\">\n\t\t\t<div class=\"tribe-events-c-subscribe-dropdown__container\">\n\t\t\t\t<div class=\"tribe-events-c-subscribe-dropdown\">\n\t\t\t\t\t<div class=\"tribe-common-c-btn-border tribe-events-c-subscribe-dropdown__button\">\n\t\t\t\t\t\t<svg\n\t class=\"tribe-common-c-svgicon tribe-common-c-svgicon--cal-export tribe-events-c-subscribe-dropdown__export-icon\" \taria-hidden=\"true\"\n\tviewBox=\"0 0 23 17\"\n\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n>\n\t<path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M.128.896V16.13c0 .211.145.383.323.383h15.354c.179 0 .323-.172.323-.383V.896c0-.212-.144-.383-.323-.383H.451C.273.513.128.684.128.896Zm16 6.742h-.901V4.679H1.009v10.729h14.218v-3.336h.901V7.638ZM1.01 1.614h14.218v2.058H1.009V1.614Z\" \/>\n\t<path d=\"M20.5 9.846H8.312M18.524 6.953l2.89 2.909-2.855 2.855\" stroke-width=\"1.2\" stroke-linecap=\"round\" stroke-linejoin=\"round\"\/>\n<\/svg>\n\t\t\t\t\t\t<button\n\t\t\t\t\t\t\tclass=\"tribe-events-c-subscribe-dropdown__button-text\"\n\t\t\t\t\t\t\taria-expanded=\"false\"\n\t\t\t\t\t\t\taria-controls=\"tribe-events-subscribe-dropdown-content\"\n\t\t\t\t\t\t\taria-label=\"View links to add events to your calendar\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\tAjouter au calendrier\t\t\t\t\t\t<\/button>\n\t\t\t\t\t\t<svg\n\t class=\"tribe-common-c-svgicon tribe-common-c-svgicon--caret-down tribe-events-c-subscribe-dropdown__button-icon\" \taria-hidden=\"true\"\n\tviewBox=\"0 0 10 7\"\n\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n>\n\t<path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M1.008.609L5 4.6 8.992.61l.958.958L5 6.517.05 1.566l.958-.958z\" class=\"tribe-common-c-svgicon__svg-fill\"\/>\n<\/svg>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<div id=\"tribe-events-subscribe-dropdown-content\" class=\"tribe-events-c-subscribe-dropdown__content\">\n\t\t\t\t\t\t<ul class=\"tribe-events-c-subscribe-dropdown__list\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"tribe-events-c-subscribe-dropdown__list-item tribe-events-c-subscribe-dropdown__list-item--gcal\">\n\t\t\t\t\t\t\t\t\t<a\n\t\t\t\t\t\t\t\t\t\thref=\"https:\/\/www.google.com\/calendar\/event?action=TEMPLATE&#038;dates=20261103T000000\/20261103T235959&#038;text=Data%20Cleaning%20with%20OpenRefine&#038;details=%3Cp%3EResearchers+and+librarians+often+deal+with+%E2%80%9Cmessy%E2%80%9D+data.+This+could+include+inconsistent+interview+transcripts%2C+poorly+formatted+longitudinal+datasets%2C+or+standardizing+names+for+an+authority+file.+Preparing+this+data+for+analysis+is+a+critical+step+that+requires+the+same+level+of+rigor+and+reproducibility+as+the+analysis+itself.+This+workshop+introduces+OpenRefine%2C+a+powerful%2C+free%2C+and+open-source+tool+for+cleaning%2C+normalizing%2C+and+transforming+research+data.+participants+work+with+a+sample+dataset+to+learn+how+to+efficiently+handle+common+data+issues%2C+such+as+automating+data+standardization%2C+identifying+clusters+of+similar+entries%2C+and+transforming+complex+strings+into+structured+information+without+the+need+for+advanced+programming.+Unlike+manual+editing+in+Excel%2C+OpenRefine+records+every+step+of+your+process%2C+ensuring+your+data+cleaning+is+transparent+and+fully+reproducible.+Participants+should+be+comfortable+using+a+computer+and+have+a+general+understanding+of+%3C%2Fp%3E+%28View+Full+%C3%A9v%C3%A8nement+Description+Here%3A+https%3A%2F%2Fccdhhn.ca%2Ffr%2Fworkshop%2Fdata-cleaning-with-openrefine%2F%29&#038;trp=false&#038;ctz=America\/Halifax&#038;sprop=website:https:\/\/ccdhhn.ca\/fr\/\"\n\t\t\t\t\t\t\t\t\t\tclass=\"tribe-events-c-subscribe-dropdown__list-item-link\"\n\t\t\t\t\t\t\t\t\t\ttarget=\"_blank\"\n\t\t\t\t\t\t\t\t\t\trel=\"noopener noreferrer nofollow noindex\"\n\t\t\t\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\tGoogle Agenda\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"tribe-events-c-subscribe-dropdown__list-item tribe-events-c-subscribe-dropdown__list-item--ical\">\n\t\t\t\t\t\t\t\t\t<a\n\t\t\t\t\t\t\t\t\t\thref=\"\"\n\t\t\t\t\t\t\t\t\t\tclass=\"tribe-events-c-subscribe-dropdown__list-item-link\"\n\t\t\t\t\t\t\t\t\t\ttarget=\"_blank\"\n\t\t\t\t\t\t\t\t\t\trel=\"noopener noreferrer nofollow noindex\"\n\t\t\t\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\tiCalendar\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"tribe-events-c-subscribe-dropdown__list-item tribe-events-c-subscribe-dropdown__list-item--outlook-365\">\n\t\t\t\t\t\t\t\t\t<a\n\t\t\t\t\t\t\t\t\t\thref=\"\"\n\t\t\t\t\t\t\t\t\t\tclass=\"tribe-events-c-subscribe-dropdown__list-item-link\"\n\t\t\t\t\t\t\t\t\t\ttarget=\"_blank\"\n\t\t\t\t\t\t\t\t\t\trel=\"noopener noreferrer nofollow noindex\"\n\t\t\t\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\tOutlook 365\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"tribe-events-c-subscribe-dropdown__list-item tribe-events-c-subscribe-dropdown__list-item--outlook-live\">\n\t\t\t\t\t\t\t\t\t<a\n\t\t\t\t\t\t\t\t\t\thref=\"\"\n\t\t\t\t\t\t\t\t\t\tclass=\"tribe-events-c-subscribe-dropdown__list-item-link\"\n\t\t\t\t\t\t\t\t\t\ttarget=\"_blank\"\n\t\t\t\t\t\t\t\t\t\trel=\"noopener noreferrer nofollow noindex\"\n\t\t\t\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\tOutlook Live\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n\n","protected":false},"excerpt":{"rendered":"<p>Researchers and librarians often deal with \u201cmessy\u201d data. This could include inconsistent interview transcripts, poorly formatted longitudinal datasets, or standardizing names for an authority file. Preparing this data for analysis [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1186,"template":"","meta":{"_tec_requires_first_save":false,"_EventAllDay":true,"_EventTimezone":"America\/Halifax","_EventStartDate":"2026-11-03 00:00:00","_EventEndDate":"2026-11-03 23:59:59","_EventStartDateUTC":"2026-11-03 04:00:00","_EventEndDateUTC":"2026-11-04 03:59:59","_EventShowMap":false,"_EventShowMapLink":false,"_EventURL":"https:\/\/www.ace-net.ca\/training-course\/introduction-to-openrefine\/","_EventCost":"","_EventCostDescription":"","_EventCurrencySymbol":"$","_EventCurrencyCode":"CAD","_EventCurrencyPosition":"prefix","_EventDateTimeSeparator":" @ ","_EventTimeRangeSeparator":" - ","_EventOrganizerID":[1185],"_EventVenueID":[],"_OrganizerEmail":"","_OrganizerPhone":"","_OrganizerWebsite":"","_VenueAddress":"","_VenueCity":"","_VenueCountry":"","_VenueProvince":"","_VenueState":"","_VenueZip":"","_VenuePhone":"","_VenueURL":"","_VenueStateProvince":"","_VenueLat":"","_VenueLng":"","_VenueShowMap":false,"_VenueShowMapLink":false,"_tribe_blocks_recurrence_rules":"","_tribe_blocks_recurrence_description":"","_tribe_blocks_recurrence_exclusions":"","_ecp_custom_2":"English","_ecp_custom_3":"virtual\/virtuel","_tribe_events_status":"","_tribe_events_status_reason":"","_tribe_events_is_hybrid":"","_tribe_events_is_virtual":"","_tribe_events_virtual_video_source":"","_tribe_events_virtual_embed_video":"","_tribe_events_virtual_linked_button_text":"","_tribe_events_virtual_linked_button":"","_tribe_events_virtual_show_embed_at":"","_tribe_events_virtual_show_embed_to":[],"_tribe_events_virtual_show_on_event":"","_tribe_events_virtual_show_on_views":"","_tribe_events_virtual_url":"","footnotes":""},"tags":[],"tribe_events_cat":[3],"class_list":["post-4625","tribe_events","type-tribe_events","status-publish","has-post-thumbnail","hentry","tribe_events_cat-1-4-hour-workshop","cat_1-4-hour-workshop"],"_links":{"self":[{"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events\/4625","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events"}],"about":[{"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/types\/tribe_events"}],"author":[{"embeddable":true,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/users\/2"}],"version-history":[{"count":3,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events\/4625\/revisions"}],"predecessor-version":[{"id":4628,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events\/4625\/revisions\/4628"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/media\/1186"}],"wp:attachment":[{"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/media?parent=4625"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tags?post=4625"},{"taxonomy":"tribe_events_cat","embeddable":true,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events_cat?post=4625"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}