DuckDB in Python: A Beginner's Guide

Author: Mark Bauer

1. Introduction

Welcome to the beginner's guide to DuckDB's Python client! This tutorial was crafted during my own journey of acquainting with DuckDB's Python client. It aims to provide newcomers with a basic foundation in utilizing the API. While this guide serves as a valuable resource, I encourage users to complement their learning with the official documentation available on DuckDB's website for a comprehensive understanding.

2. Notebook

• Explore the beginner's notebook: duckdb-python-basics.ipynb.

3. Data

• NYC DEP Green Infrastructure Data: https://data.cityofnewyork.us/Environment/DEP-Green-Infrastructure/spjh-pz7h
• NYC TLC Trip Record Data: https://www.nyc.gov/site/tlc/about/tlc-trip-record-data.page

4. Additional Resources

• Official DuckDB Documentation: https://duckdb.org/
• DuckDB Python client guide: https://duckdb.org/docs/api/python/overview

5. Say Hello!

Feel free to reach out for further discussions.

• LinkedIn: markebauer
• GitHub: mebauer
• Portfolio: mebauer.github.io