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:20240315T160000Z
DTEND:20240315T180000Z
DTSTAMP:20240315T000000Z
SUMMARY:Data Analysis with Python\, Pandas\, and SQL
DESCRIPTION:This workshop will be offered on-line over Zoom. All registered 
 participants will recieve a Zoom link after registrations close\, typically 
 24 hours prior to the start of the workshop. \n\nNOTE: Please register for 
 this workshop using your UC or other university email address\, if you have 
 one.  \n\nData obtained from the web or other outside sources is often 
 messy and difficult to manage.  Pandas\, a popular tabular data frame 
 library in Python\, and SQL\, a structured query language for databases\, 
 provide two different but effective tools for getting a better handle on 
 your data.  This workshop is designed to introduce you to both tools in the 
 context of managing research data\, demonstrate the strengths of each 
 approach\, and review how the two approaches can be particularly effective 
 when used in combination.  \n\nFor more information\, please see the course 
 web page 
 at:\n\nhttps://courses.ucsf.edu/course/view.php?id=5203\n\nPrerequisites:\n\nThis 
 workshop will involve lots of hands on coding wtih SQL and Python. To 
 follow along with the coding exercises\, you should be familiar with core 
 Python\, at the level covered in Intro to Python Part 1 and Intro to Python 
 Part 2\, and basic SQL commands at the level covered in Intro to SQL. If 
 you haven't enrolled in these introductory workshops\, you can access the 
 coursework and self-study options on the main DSI Programming web page 
 at:\n\nhttps://courses.ucsf.edu/course/index.php?categoryid=930\n\n 
 \n\nDigital Humanities Sequence\n\nThis sequence is designed for people 
 with no prior programming experience. The workshops start with core python 
 and sql before moving into more advanced or specialized topics in digital 
 humanities\, with an emphasis on text analysis and machine learning. 
 \n\nYou are welcome to take any of these workshops without attending the 
 entire series. No formal pre-reqs are enforced\, but if you are new to 
 Python or SQL\, you’ll get the core programming skills necessary for the 
 later workshops by attending Intro to Python Part 1 and Part 2 along with 
 Intro to SQL. \n\nRegistration Links: \n\n\n	Intro to Python Part 
 1:\n	\n		https://calendars.library.ucsf.edu/event/11946795\n	\n	\n	Intro to 
 Python Part 
 2:\n	\n		https://calendars.library.ucsf.edu/event/11946839\n	\n	\n	Intro to 
 SQL:\n	\n		https://calendars.library.ucsf.edu/event/11946900\n	\n	\n	Data 
 Analysis with Python\, Pandas\, and 
 SQL:\n	\n		https://calendars.library.ucsf.edu/event/11947263\n	\n	\n	Intro 
 to 
 Unix:\n	\n		https://calendars.library.ucsf.edu/event/11947161\n	\n	\n	Reading 
 Data from APIs with Python\, Pandas\, and 
 SQL:\n	\n		https://calendars.library.ucsf.edu/event/11947321\n	\n	\n	Machine 
 Learning with Python and 
 Scikit-Learn:\n	\n		https://calendars.library.ucsf.edu/event/11947452\n	\n	\n	Python 
 Background for Text Analysis and Natural Language 
 Processing:\n	\n		https://calendars.library.ucsf.edu/event/11947471\n	\n	\n	Machine 
 Learning for Document Classification and Sentiment 
 Analysis:\n	\n		https://calendars.library.ucsf.edu/event/11947489\n	\n	\n	Google 
 Cloud Tools\, BiqQuery\, and 
 VertexAI:\n	\n		https://calendars.library.ucsf.edu/event/11947492\n	\n	\n
LOCATION:Virtual
ORGANIZER;CN="Geoffrey Boushey":MAILTO:Geoffrey.Boushey@ucsf.edu
CATEGORIES:Programming
CONTACT;CN="Geoffrey Boushey":MAILTO:Geoffrey.Boushey@ucsf.edu
STATUS:CONFIRMED
UID:LibCal-11947263
URL:https://calendars.library.ucsf.edu/event/11947263
X-MICROSOFT-CDO-BUSYSTATUS:BUSY
BEGIN:VALARM
TRIGGER:-PT15M
ACTION:DISPLAY
DESCRIPTION:Reminder
END:VALARM
END:VEVENT

END:VCALENDAR