Advanced Data Manipulation: SQL and Pandas

This class will review and expand on basic techniques for querying data in SQL. We will introduce subqueries and aliases, explore core SQL functions in greater depth, and demonstrate how to use SQL in combination with other data analysis tools such as Python and Pandas.  

Prerequisites:

To follow along with class exercises, you'll need to be able to run basic SQL commands: (SELECT, WHERE, GROUP BY, HAVING) and basic Python commands in a Jupyter Notebook.

Do you need help with any of these prerequisites? Register here for an upcoming "Programming & Pizza" session.

Thursday, August 10 at 1:00pm to 3:00pm

Parnassus Library, CL221-222
530 Parnassus Avenue, San Francisco, CA 94143-0840

Event Type

Class/Info Session

Audience

Students, Postdocs, Faculty, Staff

Campus

Mission Bay

Tags

SQL, programming, Data Science Initiative, python, pandas

Website

http://calendars.library.ucsf.edu/eve...

Cost

Free

Department/Group

UCSF Library

Contact Info

geoff.boushey@ucsf.edu

Subscribe

Event Registration Required

This event requires registration.