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](images/schema.jpg)
- 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)