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?

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License

UCSB logo