Week 6 - Programming with databases

Learning objectives

  • Understand the basic database programming model
  • Access a DuckDB database from Python and R
  • Understand how to use the Python/Pandas and R/dbplyr convenience functions

Slides and other materials

slides-06.pptx

Coding transcripts:

Resources

  1. https://peps.python.org/pep-0249/

    • Common Python-RDBMS API
  2. https://duckdb.org/docs/api/python/overview

    • Python DuckDB module
  3. https://dbplyr.tidyverse.org/

    • R dbplyr documentation

Homework

Little Bobby Tables

Characterizing egg variation

Who were the winners?


This work is licensed under CC BY 4.0

UCSB logo