{"id":3559,"date":"2025-09-12T13:50:10","date_gmt":"2025-09-12T16:50:10","guid":{"rendered":"https:\/\/ccdhhn.ca\/?post_type=tribe_events&#038;p=3559"},"modified":"2025-09-12T13:50:44","modified_gmt":"2025-09-12T16:50:44","slug":"save-time-cleaning-your-data-with-openrefine","status":"publish","type":"tribe_events","link":"https:\/\/ccdhhn.ca\/fr\/workshop\/save-time-cleaning-your-data-with-openrefine\/","title":{"rendered":"Save Time Cleaning Your Data with OpenRefine"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"811\" height=\"144\" src=\"https:\/\/ccdhhn.ca\/wp-content\/uploads\/2024\/02\/libraries_yu_PRIMARY_hor_CMYK67.png\" alt=\"\" class=\"wp-image-2108\" srcset=\"https:\/\/ccdhhn.ca\/wp-content\/uploads\/2024\/02\/libraries_yu_PRIMARY_hor_CMYK67.png 811w, https:\/\/ccdhhn.ca\/wp-content\/uploads\/2024\/02\/libraries_yu_PRIMARY_hor_CMYK67-300x53.png 300w, https:\/\/ccdhhn.ca\/wp-content\/uploads\/2024\/02\/libraries_yu_PRIMARY_hor_CMYK67-768x136.png 768w\" sizes=\"auto, (max-width: 811px) 100vw, 811px\" \/><\/figure>\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-block tribe-block__additional-field tribe-block__additional-field__dropdown\" >\n\t<h3>Format <\/h3>\n\tin person\/face-\u00e0-face<\/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>Date: October 22 2025<\/p>\n\n\n\n<p><strong>Presenter:<\/strong>&nbsp;Alexandra Wong and Rosa Orlandini<\/p>\n\n\n\n<p>An important part of working with any data is properly preparing and cleaning your data, whether you have conducted a survey or have found secondary data! If you also find cleaning your data to correct errors or make formatting consistent to be a tedious and time-consuming (but very important) process, this workshop is for you. OpenRefine is a powerful, free and open-source tool for working with messy data. This workshop will teach you to use OpenRefine to effectively clean and format data and automatically track any changes that you make. Many people comment that this tool saves them literally months of work trying to make these edits by hand.<\/p>\n\n\n\n<p>By the end of this hands-on workshop, participants will be able to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Understand the kinds of challenges presented by raw data<\/li>\n\n\n\n<li>Install and use the OpenRefine tool on your own computer<\/li>\n\n\n\n<li>Use several time-saving techniques to cluster, clean, and process your data<\/li>\n<\/ul>\n\n\n\n<p>No previous experience working with OpenRefine is required, though a familiarity with data is helpful. This workshop will take place in Scott530 with the OpenRefine software already installed. To use their own device, participants are encouraged to&nbsp;<a href=\"https:\/\/openrefine.org\/\">download OpenRefine<\/a>&nbsp;prior to the workshop.<\/p>\n\n\n<div  class=\"tribe-block tribe-block__event-website\" >\n\t<a\n\t\thref=\"https:\/\/yorku.libcal.com\/event\/3929225\"\n\t\ttarget=\"_self\"\n\t\t\t>\n\t\tLink to event\t<\/a>\n<\/div>\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\/\" title=\"York University Libraries\" target=\"_self\" rel=\"\">York University Libraries<\/a><\/h3>\n\t<\/div>\n\t\t\t\t<p class=\"tribe-block__organizer__website\"><a href=\"https:\/\/yorku.libcal.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">View Organisateur Website<\/a><\/p>\n\t\t<\/div>\n\n\n<div  class=\"tribe-block tribe-block__venue tribe-clearfix tribe-block__venue--has-map\" >\n\t\n\t\n<div class=\"tribe-block__venue__meta\">\n\t<div class=\"tribe-block__venue__name\">\n\t\t<h3><a href=\"https:\/\/ccdhhn.ca\/fr\/lieu\/york-university\/\" title=\"York University\">York University<\/a><\/h3>\n\t<\/div>\n\n\t\n\t\t\t\t\t\t<address class=\"tribe-block__venue__address\">\n\t\t\t\t<span class=\"tribe-address\">\n\n<span class=\"tribe-street-address\">4700 Keele Street<\/span>\n\t\n\t\t<br>\n\t\t<span class=\"tribe-locality\">Toronto<\/span><span class=\"tribe-delimiter\">,<\/span>\n\n\t<abbr class=\"tribe-region tribe-events-abbr\" title=\"Ontario\">Ontario<\/abbr>\n\n\t<span class=\"tribe-postal-code\">M3J 1P3<\/span>\n\n\t<span class=\"tribe-country-name\">Canada<\/span>\n\n<\/span>\n\n\t\t\t\t\t\t\t\t\t<a class=\"tribe-events-gmap\" href=\"https:\/\/www.google.com\/maps\/search\/?api=1&#038;query=43.772283695741%2C-79.505416689555\" title=\"Cliquez pour voir une carte Google Maps\" target=\"_blank\" rel=\"noreferrer noopener\">+ Google Map<\/a>\t\t\t\t\t\t\t<\/address>\n\t\t\n\t\t\n\t\t\t\t\t<span class=\"tribe-block__venue__website\"><a href=\"https:\/\/www.yorku.ca\/\" target=\"_self\" rel=\"external\">View Lieu Website<\/a><\/span><br \/>\n\t\t\t\n\t<\/div>\n\t\n<div class=\"tribe-block__venue__map\">\n\t\n<iframe loading=\"lazy\"\n  title=\"Google maps iframe displaying the address to York University\"\n  aria-label=\"Venue location map\"\n  width=\"310px\"\n  height=\"256px\"\n  frameborder=\"0\" style=\"border:0\"\n  src=\"https:\/\/www.google.com\/maps\/embed\/v1\/place?key=AIzaSyDNsicAsP6-VuGtAb1O9riI3oc_NOb7IOU&#038;q=4700+Keele+Street+Toronto+Ontario+M3J+1P3+Canada+&#038;zoom=10\" allowfullscreen>\n<\/iframe>\n<\/div>\n\n\t<\/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=20251022T000000\/20251022T235959&#038;text=Save%20Time%20Cleaning%20Your%20Data%20with%20OpenRefine&#038;details=%3Cfigure+class%3D%22wp-block-image+size-full%22%3E%3Cimg+src%3D%22https%3A%2F%2Fccdhhn.ca%2Fwp-content%2Fuploads%2F2024%2F02%2Flibraries_yu_PRIMARY_hor_CMYK67.png%22+alt%3D%22%22+class%3D%22wp-image-2108%22%2F%3E%3C%2Ffigure%3E%3Cp%3EDate%3A+October+22+2025%3C%2Fp%3E+%3Cp%3E%3Cstrong%3EPresenter%3A%3C%2Fstrong%3E%26nbsp%3BAlexandra+Wong+and+Rosa+Orlandini%3C%2Fp%3E+%3Cp%3EAn+important+part+of+working+with+any+data+is+properly+preparing+and+cleaning+your+data%2C+whether+you+have+conducted+a+survey+or+have+found+secondary+data%21+If+you+also+find+cleaning+your+data+to+correct+errors+or+make+formatting+consistent+to+be+a+tedious+and+time-consuming+%28but+very+important%29+process%2C+this+workshop+is+for+you.+OpenRefine+is+a+powerful%2C+free+and+open-source+tool+for+working+with+messy+data.+This+workshop+will+teach+you+to+use+OpenRefine+to+effectively+clean+and+format+data+and+automatically+track+any+changes+that+you+make.+Many+people+comment+that+this+tool+saves+them+literally+months+of+work+trying+to+make+these+edits+by+hand.%3C%2Fp%3E+%3Cp%3EBy+the+end+of+this+hands-on+worksho%3C%2Fp%3E+%28View+Full+%C3%A9v%C3%A8nement+Description+Here%3A+https%3A%2F%2Fccdhhn.ca%2Ffr%2Fworkshop%2Fsave-time-cleaning-your-data-with-openrefine%2F%29&#038;location=York%20University,%204700%20Keele%20Street,%20Toronto,%20Ontario,%20M3J%201P3,%20Canada&#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>Date: October 22 2025 Presenter:&nbsp;Alexandra Wong and Rosa Orlandini An important part of working with any data is properly preparing and cleaning your data, whether you have conducted a survey [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":2108,"template":"","meta":{"_tec_requires_first_save":false,"_EventAllDay":true,"_EventTimezone":"America\/Halifax","_EventStartDate":"2025-10-22 00:00:00","_EventEndDate":"2025-10-22 23:59:59","_EventStartDateUTC":"2025-10-22 03:00:00","_EventEndDateUTC":"2025-10-23 02:59:59","_EventShowMap":false,"_EventShowMapLink":false,"_EventURL":"https:\/\/yorku.libcal.com\/event\/3929225","_EventCost":"","_EventCostDescription":"","_EventCurrencySymbol":"$","_EventCurrencyCode":"CAD","_EventCurrencyPosition":"prefix","_EventDateTimeSeparator":" @ ","_EventTimeRangeSeparator":" - ","_EventOrganizerID":[2111],"_EventVenueID":[2112],"_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":"in person\/face-\u00e0-face","_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-3559","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\/3559","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\/3"}],"version-history":[{"count":1,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events\/3559\/revisions"}],"predecessor-version":[{"id":3562,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events\/3559\/revisions\/3562"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/media\/2108"}],"wp:attachment":[{"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/media?parent=3559"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tags?post=3559"},{"taxonomy":"tribe_events_cat","embeddable":true,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events_cat?post=3559"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}