{"id":2419,"date":"2024-04-10T11:11:26","date_gmt":"2024-04-10T14:11:26","guid":{"rendered":"https:\/\/ccdhhn.ca\/?post_type=tribe_events&#038;p=2419"},"modified":"2024-04-10T11:11:29","modified_gmt":"2024-04-10T14:11:29","slug":"data-cleaning-and-reconciliation-with-openrefine","status":"publish","type":"tribe_events","link":"https:\/\/ccdhhn.ca\/fr\/workshop\/data-cleaning-and-reconciliation-with-openrefine\/","title":{"rendered":"Data Cleaning and Reconciliation with OpenRefine\u00a0"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"530\" src=\"https:\/\/ccdhhn.ca\/wp-content\/uploads\/2024\/04\/FL-conference-banner-horizontal-1024x530.png\" alt=\"\" class=\"wp-image-2411\" srcset=\"https:\/\/ccdhhn.ca\/wp-content\/uploads\/2024\/04\/FL-conference-banner-horizontal-1024x530.png 1024w, https:\/\/ccdhhn.ca\/wp-content\/uploads\/2024\/04\/FL-conference-banner-horizontal-300x155.png 300w, https:\/\/ccdhhn.ca\/wp-content\/uploads\/2024\/04\/FL-conference-banner-horizontal-768x398.png 768w, https:\/\/ccdhhn.ca\/wp-content\/uploads\/2024\/04\/FL-conference-banner-horizontal-1536x795.png 1536w, https:\/\/ccdhhn.ca\/wp-content\/uploads\/2024\/04\/FL-conference-banner-horizontal.png 1750w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/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-schedule tribe-clearfix\" >\n\t<p class=\"tribe-events-schedule__datetime\">\n\t\t<span class=\"tribe-events-schedule__date tribe-events-schedule__date--start\">\n\t\t\tmai 8, 2024\t\t<\/span>\n\n\t\t\t\t\t<span class=\"tribe-events-schedule__all-day\">Toute la journ\u00e9e<\/span>\n\t\t\n\t\t\t<\/p>\n<\/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>OpenRefine is a free and easy-to-learn tool for changing and augmenting data. It has many uses, including cleaning and reconciling structured data (e.g., spreadsheets) in preparation for creating Linked Open Data (LOD). This workshop will provide a hands-on introduction to OpenRefine. Using sample data provided in the workshops, participants will be taught how to clean and reconcile. You do not need to have your own structured data to participate.<\/p>\n\n\n\n<p>This workshop is suitable for anyone who is either new to OpenRefine or who is new to using it for cleaning, reconciling, and augmenting structured data. It is especially recommended for anyone who is interested in creating LOD with LINCS and would like a taster of the preliminary steps in the process.<\/p>\n\n\n\n<p>Led by Natalie Hervieux and Sarah Roger<\/p>\n\n\n\n<p>This is a<a href=\"https:\/\/can01.safelinks.protection.outlook.com\/?url=https%3A%2F%2Flincsproject.ca%2F&amp;data=05%7C02%7Cmhowse%40stfx.ca%7C58917ebf2a3e449a6bf608dc59671bf1%7C8c46abc7960b412489501628b2b192f9%7C0%7C0%7C638483546579238086%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&amp;sdata=wHyk9pi5a2qCEX2iY%2FYik48%2BBp5eNu0N9hX%2FQx51GTA%3D&amp;reserved=0\" target=\"_blank\" rel=\"noreferrer noopener\">\u00a0Forward Linking<\/a>\u00a0(LINCS)-<a href=\"https:\/\/can01.safelinks.protection.outlook.com\/?url=https%3A%2F%2Fdhsite.org%2F&amp;data=05%7C02%7Cmhowse%40stfx.ca%7C58917ebf2a3e449a6bf608dc59671bf1%7C8c46abc7960b412489501628b2b192f9%7C0%7C0%7C638483546579247318%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&amp;sdata=bXynVPPEUUCeWQN9c2bBHF8KX%2FHO84mYhCRkXv5wP3Q%3D&amp;reserved=0\" target=\"_blank\" rel=\"noreferrer noopener\">DHSITE<\/a>\u00a0workshop.<\/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\/dhsite\/\" title=\"DHSITE\" target=\"_self\" rel=\"\">DHSITE<\/a><\/h3>\n\t<\/div>\n\t\t\t\t<p class=\"tribe-block__organizer__website\"><a href=\"https:\/\/dhsite.org\/\" 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\/university-of-ottawa\/\" title=\"University of Ottawa\">University of Ottawa<\/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\">50 University Private<\/span>\n\t\n\t\t<br>\n\t\t<span class=\"tribe-locality\">Ottawa<\/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\">K1N 6N5<\/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=45.42395%2C-75.68446\" 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=\"http:\/\/dhsite.org\" 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 University of Ottawa\"\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=50+University+Private+Ottawa+Ontario+K1N+6N5+Canada+&#038;zoom=10\" allowfullscreen>\n<\/iframe>\n<\/div>\n\n\t<\/div>\n\n\n<div  class=\"tribe-block tribe-block__event-website\" >\n\t<a\n\t\thref=\"https:\/\/hsscommons.ca\/en\/groups\/forward_linking\/events\/2024conference\/2024_workshops\"\n\t\ttarget=\"_self\"\n\t\t\t>\n\t\tLink to register\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=20240508T000000\/20240508T235959&#038;text=Data%20Cleaning%20and%20Reconciliation%20with%20OpenRefine%C2%A0&#038;details=%3Cfigure+class%3D%22wp-block-image+size-large%22%3E%3Cimg+src%3D%22https%3A%2F%2Fccdhhn.ca%2Fwp-content%2Fuploads%2F2024%2F04%2FFL-conference-banner-horizontal-1024x530.png%22+alt%3D%22%22+class%3D%22wp-image-2411%22%2F%3E%3C%2Ffigure%3E%3Cp%3EOpenRefine+is+a+free+and+easy-to-learn+tool+for+changing+and+augmenting+data.+It+has+many+uses%2C+including+cleaning+and+reconciling+structured+data+%28e.g.%2C+spreadsheets%29+in+preparation+for+creating+Linked+Open+Data+%28LOD%29.+This+workshop+will+provide+a+hands-on+introduction+to+OpenRefine.+Using+sample+data+provided+in+the+workshops%2C+participants+will+be+taught+how+to+clean+and+reconcile.+You+do+not+need+to+have+your+own+structured+data+to+participate.%3C%2Fp%3E+%3Cp%3EThis+workshop+is+suitable+for+anyone+who+is+either+new+to+OpenRefine+or+who+is+new+to+using+it+for+cleaning%2C+reconciling%2C+and+augmenting+structured+data.+It+is+especially+recommended+for+anyone+who+is+interested+in+creating+LOD+with+LINCS+and+would+like+a+taster+of+the+preliminary+steps+in+the+process.%3C%2Fp%3E+%3Cp%3ELed+by+Natalie+Hervi%3C%2Fp%3E+%28View+Full+%C3%A9v%C3%A8nement+Description+Here%3A+https%3A%2F%2Fccdhhn.ca%2Ffr%2Fworkshop%2Fdata-cleaning-and-reconciliation-with-openrefine%2F%29&#038;location=University%20of%20Ottawa,%2050%20University%20Private,%20Ottawa,%20Ontario,%20K1N%206N5,%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>OpenRefine is a free and easy-to-learn tool for changing and augmenting data. It has many uses, including cleaning and reconciling structured data (e.g., spreadsheets) in preparation for creating Linked Open [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":2411,"template":"","meta":{"_tec_requires_first_save":false,"_EventAllDay":true,"_EventTimezone":"America\/Halifax","_EventStartDate":"2024-05-08 00:00:00","_EventEndDate":"2024-05-08 23:59:59","_EventStartDateUTC":"2024-05-08 03:00:00","_EventEndDateUTC":"2024-05-09 02:59:59","_EventShowMap":false,"_EventShowMapLink":false,"_EventURL":"https:\/\/hsscommons.ca\/en\/groups\/forward_linking\/events\/2024conference\/2024_workshops","_EventCost":"","_EventCostDescription":"","_EventCurrencySymbol":"$","_EventCurrencyCode":"CAD","_EventCurrencyPosition":"prefix","_EventDateTimeSeparator":" @ ","_EventTimeRangeSeparator":" - ","_EventOrganizerID":[190],"_EventVenueID":[183],"_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-2419","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\/2419","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\/2419\/revisions"}],"predecessor-version":[{"id":2420,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events\/2419\/revisions\/2420"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/media\/2411"}],"wp:attachment":[{"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/media?parent=2419"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tags?post=2419"},{"taxonomy":"tribe_events_cat","embeddable":true,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events_cat?post=2419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}