Talk: An Introduction on SQL Databases using Pandas and SQLAlchemy

Given by Nicholas A. Del Grosso on March 8, 2017 at Ludwig-Maximillians-Üniversität in Munich, Germany

Talk Goals

• Review the Table Data Structure
• Introdouce and/or Re-familiarize Ourselves with Pandas
• Introduce Relational Databases
• Introduce sqlite3 and database management software
• Introduce SQL Syntax and do some queries on a database.

Required Packages

• pandas
• sqlalchemy

Additional Resources

• SQL and Pandas cheatsheet files are in this repo!
• Datacamp now offers some tutorial for joins in Pandas! https://www.datacamp.com/courses/merging-dataframes-with-pandas