MLOps Lecture 1 - Intro to APIs & DataBases

This repository contains lecutre slides, python scripts and dataset for the first lecture.

API

  • api_jokes.py is an example of simple public API
  • api_finance.py, api_news.py are examples of private API using API_key (You need to register to get your private key)
  • api_datasets.py is an example of API Wrapper
  • EXTRA: joke_app.py is a simple streamlit app that uses IPA to print jokes
  • EXTRA: api_weather.py exercise from the class

Database

Schema

  • db_create.py reads in excel file and transform it into SQL database
  • db_queries.py contains a few query examples
  • db_add_datapoints add new transactions
  • db_add_columns add new columns
  • data/Online Retail.xlsx is dataset used to create database (https://archive.ics.uci.edu/dataset/352/online+retail)