Data Acquisition Processing and Mining for AI
Course materials are available on Moodle.
Getting Started
- Pre-course setup [zip]
Lectures
- Week 1: Introduction and Python for Data [slides]
- Week 2: Relational Data and Advanced SQL [slides]
- Week 3: Web APIs [slides]
- Week 4: Scraping, Ethics, and Storage [slides]
- Week 5: EDA for Data Quality [slides]
- Week 6: Data Cleaning and Leakage [slides]
Labs
- Lab 1: Pandas, NYC taxi data [lab + data]
- Lab 2: DuckDB and SQL, NYC taxi data [lab + data]
- Lab 3: Web APIs with requests, Open Library and GitHub [lab + data]
- Lab 4: Web scraping with BeautifulSoup, Books to Scrape [lab + data]
- Lab 5: EDA with Pandas and Seaborn, NYC taxi data [lab + data]
- Lab 6: Cleaning and leakage with scikit-learn, NYC taxi and churn data [lab + data]