Event box

Python and SQL

Data 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.  

Through a series of in class exercises, participants will review how to sort, filter, and aggregate data in Pandas and SQL, and review the benefits and drawbacks of each approach.  We will also review how Pandas and SQL can be used in combination to handle more difficult data analysis problems.

This workshop has recommended prerequisites. For more information please see the CLE page for Data Analysis with SQL and Python.

Date:
Friday, November 22, 2019
Time:
9:00am - 11:00am
Location:
CC151
Campus:
Mission Bay
Categories:
  Data Science Initiative > Programming     Data Science Initiative  

Event Organizer

Profile photo of Geoffrey Boushey
Geoffrey Boushey