Stop Struggling with DataFrames – Try DuckDB for SQL on Pandas

➡️ 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.

🔖 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