Navigate Select ESC Close

DuckDB in Python - The Next Pandas Killer?

2024-09-03 Science & Technology
48.3k
1.7k
67
NeuralNine
NeuralNine
470.0k subscribers

Unlock all features

FREE: Get instant access to 10 AI summaries, chats, or transcripts per day.

Description

Today we learn DuckDB and how to use it in Python. ◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾ 📚 Programming Books & Merch 📚 🐍 The Python Bible Book: https://www.neuralnine.com/books/ 💻 The Algorithm Bible Book: https://www.neuralnine.com/books/ 👕 Programming Merch: https://www.neuralnine.com/shop 💼 Services 💼 💻 Freelancing & Tutoring: https://www.neuralnine.com/services 🌐 Social Media & Contact 🌐 📱 Website: https://www.neuralnine.com/ 📷 Instagram: https://www.instagram.com/neuralnine 🐦 Twitter: https://twitter.com/neuralnine 🤵 LinkedIn: https://www.linkedin.com/company/neuralnine/ 📁 GitHub: https://github.com/NeuralNine 🎙 Discord: https://discord.gg/JU4xr8U3dm Timestamps: (0:00) Intro (0:19) DuckDB Tutorial (12:20) Speed Comparison (Pandas) (18:58) Outro

Top Comments (10)

@graymars1097 2024-09-04

I never tried duckdb but I'm convinced now thanks to you Pandas is great but "I can't query a DF like it's a DB using SQL" was one of my first compliants using pandas and "it needs its own process" is a huge deal breaker for data analysis specially in finance This solves all these problems 😮 Great video 😊

24
@nocturnomedieval 2024-09-03

This time every new tool seems faster than pandas even after the 2.0 arrow-based upgrade

16 5 replies
@rsbenari 2024-09-03

Concise, complete, helpful. As usual. Thanks.

8
@jaybakerwork 2024-09-05

Big big fan of DuckDB. It is nice to be able to switch to SQL for some things. The engine is great. Pairing it with MotherDuck opens up some nice options. I like the relational api too. I switch between duckdb and polars.

5
@NathanaelNewton 2024-11-29

Wow this looks great! I'm at that point in life where i need to graduate from spreadsheets and learn how to use databases and an acquaintance said to check out duckDB Thanks for making this! Lots of potential here

3
@RobSeward7 2024-10-08

Love duckdb. I love this video. A comparison to polars would have been interesting too!

2
@rohitpammi 2024-09-04

Really very informatic, thanks for sharing.

1
@InhumanBean 2024-09-05

Really great intro, thank you for making this.

0
@pawjast 2024-09-06

I would have never thought duckDB is so versatile and really cool replacement for Pandas even when working with local files!

0
@lowkeygaming4716 2024-09-03

Thank you for another great video. I learned something new again.

0

Unlock the Data Inside
Turn Videos into Knowledge

  • Get FREE 10/day: transcripts, summaries, chats
  • Chat with videos, export text & PDF
  • $1 free API credit for RAG, chatbots & research

Free forever plan • All features unlocked

App screenshot