BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Springshare//LibCal//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-TIMEZONE:America/Los_Angeles
X-PUBLISHED-TTL:PT15M
BEGIN:VEVENT
DTSTART:20201118T180000Z
DTEND:20201118T200000Z
DTSTAMP:20201118T000000Z
SUMMARY:Cleaning Spreadsheet Data with Open Refine - Online
DESCRIPTION:Class Overview\n\nGot messy spreadsheets? Open Refine is a 
 powerful\, free\, open-source software tool for cleaning and transforming 
 data in a way that is easy to reproduce. This hands-on class is targeted at 
 people who need to clean messy data\, including spreadsheets of survey 
 responses\, patient encounters\, financial records\, or workshop 
 attendance. Together we will work through the basics of cleaning data in 
 OpenRefine and also go over some more advanced techniques including pulling 
 in additional data from an API. If you want something more powerful than 
 Excel but don't want to spend the time to learn a programming language like 
 R or Python\, OpenRefine could be the perfect tool for you! \n\nLearning 
 Objectives: \n\nBy the end of the class learners should be able 
 to:\n\n\n	Explain how OpenRefine works on their computer\n	Use OpenRefine 
 to:\n	\n		Facet data to find typos and errors\n		Cluster data to easily 
 correct typos at scale\n		Split data into multiple columns\n		Pull in 
 additional data from an API\n		Transform wide data into tidy data format 
 \n	\n	\n	Export their cleaned data in a variety of formats\n	Save their 
 cleaning scripts so they can be re-used\n\n\nPrerequisites / 
 Preparation\n\nPlease complete the following tasks before coming to 
 class:\n\n\n	\n	Download OpenRefine here: 
 http://openrefine.org/download.html If you are having trouble with the 
 download\, you can refer to setup instructions here: 
 https://datacarpentry.org/OpenRefine-ecology-lesson/setup.html or email me 
 at ariel.deardorff@ucsf.edu\n	\n	\n	Download the 2 class data files from 
 the course website\n	\n\n\nInstructor\n\nAriel Deardorff\, Data Services 
 Librarian\, UCSF Library\n\nThis will be an online class via Zoom 
 conferencing. The zoom link will be sent out a week in advance.\n\nWhen you 
 register\, the Library reserves class space for you. Since many of our 
 classes have a waitlist\, please cancel your registration if you can no 
 longer attend.
LOCATION:Online
ORGANIZER;CN="Ariel Deardorff":MAILTO:ariel.deardorff@ucsf.edu
CATEGORIES:Data Science, Data Management
CONTACT;CN="Ariel Deardorff":MAILTO:ariel.deardorff@ucsf.edu
STATUS:CONFIRMED
UID:LibCal-7192033
URL:https://calendars.library.ucsf.edu/event/7192033
X-MICROSOFT-CDO-BUSYSTATUS:BUSY
BEGIN:VALARM
TRIGGER:-PT15M
ACTION:DISPLAY
DESCRIPTION:Reminder
END:VALARM
END:VEVENT

END:VCALENDAR