Room 215
Python and Relational Databases: Sometimes you have a database and not a dataframe.
Topics covered: SQL, SQLite, MySQL, pandas
Typically when working with data in a Python notebook or in pandas, we rely on the abstraction of the dataframe, a matrix of columns and rows. However, a lot of data is still stored in relational databases like MySQL, and lightweight databases like SQLite may help Pythonistas with their data. Learn about relational databases and how to use them in Python.
Data Club meetups typically occur twice-monthly, on Thursdays, throughout the semester. Open to everyone in the Columbia community, these informal events will start with a presentation on a specific use case for Python, R, Julia, or JavaScript, then open up to questions, collaborative work, and discussion. Computation typically occurs within a Jupyter/Colab workflow, and participants of all skill levels are welcome.
