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.  

For more information, please see the course web page at:

https://courses.ucsf.edu/course/view.php?id=5203

Prerequisites:

This 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:

https://courses.ucsf.edu/course/index.php?categoryid=930