Introduction to Scaling Analytics Using DuckDB with Python

DuckDB is a free, open-source, fast, and performant singe machine OLAP analytical database that supports the full SQL language. It's Python API is extensive, can work with data that does NOT fit into memory, and is many times faster than pandas. I predict DuckDB will dominate the landscape soon! It is a Game-Changer! Supporting Links Support Me on Patreon https://www.patreon.com/bePatron?u=63260756 My Playlists: https://www.youtube.com/@BryanCafferky/playlists Slides: https://github.com/bcafferky/shared/blob/master/DuckDB/IntroToDuckDB/IntroToDuckDB.pdf Code: https://github.com/bcafferky/shared/blob/master/DuckDB/IntroToDuckDB/duckdb_notebook_basic.ipynb Data: Yellow Taxi Data 2024-01 (Yellow Taxi Trip Records Parquet): https://www.nyc.gov/site/tlc/about/tlc-trip-record-data.page My Video on Scaling Python Pandas: https://youtu.be/bTQten5T53g DuckDB Python API Documentation: https://duckdb.org/docs/api/python/overview.html My Video About Using Python Virtual Environments: https://youtu.be/bjUjNSotYgA DBeaver Documentation: https://dbeaver.io/