🧑‍🏫 Week 08 Lecture

From APIs to dataframes to databases (SQLite and SQL queries)

📃 Schedule

📍Location: Thursday 21 November 2024, 4 pm - 6 pm at CLM.5.02

📋 Preparation

• Fill out the 📋 LSE Course Survey (Note: Jon is also considered as your teacher in the form). ¹

• Start working on the ✍️ W10 Summative Exercise. Try to go as far as connecting to the Spotify API and saving the requests to simple JSON files.

📝 Lecture Notes

You already know how to collect data from APIs and you have been working with dataframes which were later stored in JSON or CSV files.

In this lecture, we will expand our knowledge of these concepts by learning two new things:

• How to handle authentication and credentials when working with APIs? Crucially, you will see how to ‘hide your secrets’ when working with APIs.

• What is a database and how do I store my data in a database? We will learn about a very simple database called SQLite and how to interact with it using the Structured Query Language (SQL).

You will find the notebooks/W08-Lecture-* notebooks on the the lse-ds105/ds105a-2024 repository.

Footnotes

1. 📋 Why is the LSE Course Survey important?
   
   LSE distributes a survey each academic term to collect essential student feedback about their courses.
   
   Your feedback is absolutely crucial, as the LSE Course Survey is the most formal way to provide input to the School.
   
   - It lets you comment on course content, teaching quality, and resources.
   - The feedback informs Teaching Committee meetings, guiding improvements for future cohorts.
   - Teaching staff discusses the feedback and implements necessary changes.