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.
- Friday, November 22, 2019
- 9:00am - 11:00am
- Mission Bay