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. Bring your laptop!
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.
Related LibGuide: Data Sharing & Data Management by Ariel Deardorff