Stop Struggling with DataFrames – Try DuckDB for SQL on Pandas

From the creator

➡️ Try Convex here: https://convex.link/arjancodes. In this video, I’ll talk about the power of DuckDB, a lightweight, embedded database that lets you run SQL queries directly on Pandas DataFrames—no servers, no hassle. I’ll show you how it simplifies analytics, from in-memory operations to persistent storage and Jupyter integrations. 👷 Review code better and faster with my 3-Factor Framework: https://arjan.codes/diagnosis. 🔥 GitHub Repository: https://git.arjan.codes/2025/duckdb. 🎓 ArjanCodes Courses: https://www.arjancodes.com/courses. 💬 Join my Discord server: https://discord.arjan.codes. ⌨️ Keyboard I’m using: https://amzn.to/49YM97v. 🔖 Chapters: 0:00 Intro 0:37 What is DuckDB 1:18 Backing of the project 2:09 Running SQL on DataFrames 7:49 In-memory storage 9:09 Persistent storage 10:50 Jupyter Notebooks 11:50 Multithreading and multiprocessing 15:12 Extended SQL 18:52 Final thoughts #arjancodes #softwaredesign #python

Published 2025-02-07 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.