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:20260727T170000Z
DTEND:20260727T180000Z
DTSTAMP:20260727T000000Z
SUMMARY:Scripting in OpenRefine: A Case Study Using the FOLIO API
DESCRIPTION:Lead Instructor: Alex Threlkeld (Mathematics\, Statistics\, and 
 Computational Sciences Librarian)\n\n\n	Location: Hybrid\, Zoom and Li and 
 Ma Training Room (402)\, Science Library\n	Room Directions: To get to the 
 Training Room\, enter Li & Ma on the 3rd floor of the Sapp Center\, and 
 take the stairs to the upper level of the library. Elevator passes can be 
 checked out at the circulation desk if needed.\n	Date and Time: 
 10:00AM–11:00AM\, Monday\, July 27\, 2026\n\n\nOne of the most powerful 
 features of OpenRefine is the ability to programatically enter values into 
 cells using scripts\, for example using Python. This can be used\, for 
 instance\, to make API calls based on the values of cells in another 
 column. We will show in detail how to do this\, and demonstrate a case 
 study gathering role and department information from the FOLIO API given a 
 list of names of library patrons\, which can be done in a streamlined way 
 using these tools and can support a variety of data needs in SUL. This 
 class is intended as a sequel to Maricela Abarca's introduction to 
 OpenRefine.
LOCATION:Li and Ma Training Room 402 (Science Library)
ORGANIZER;CN="Mario Pamplona":MAILTO:pamplona@stanford.edu
CATEGORIES:SUL Learning Fest 
CONTACT;CN="Mario Pamplona":MAILTO:pamplona@stanford.edu
STATUS:CONFIRMED
UID:LibCal-17128106
URL:https://appointments.library.stanford.edu/event/17128106
X-MICROSOFT-CDO-BUSYSTATUS:BUSY
BEGIN:VALARM
TRIGGER:-PT15M
ACTION:DISPLAY
DESCRIPTION:Reminder
END:VALARM
END:VEVENT

END:VCALENDAR