DuckDB and SQL - for Data Analysis and Processing
☕️ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲:
To support the channel and encourage new videos, please consider buying me a coffee here:
https://ko-fi.com/bugbytes
⭐Top resource to learn Python - https://datacamp.pxf.io/kOjKkV ⭐
In this video, we'll look at the DuckDB database for rapid analytical querying across datasets. We'll explore the basics of the package, and how it can be used to read in data and perform analytical queries.
📌 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
00:00 Intro
00:43 Introduction to DuckDB
02:27 Installing DuckDB
05:25 Importing CSV data into DuckDB database
09:42 Writing analytical queries with DuckDB
𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:
📖 Blog: https://bugbytes.io/posts/
👾 Github: https://github.com/bugbytes-io/
🐦 Twitter: / bugbytesio
📚 𝗙𝘂𝗿𝘁𝗵𝗲𝗿 𝗿𝗲𝗮𝗱𝗶𝗻𝗴 𝗮𝗻𝗱 𝗶𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻:
DuckDB: https://duckdb.org/
DuckDB Installation: https://duckdb.org/docs/installation/
DuckDB Data Import: https://duckdb.org/docs/data/overview
Employee dataset: https://www.kaggle.com/datasets/prakh...
#python #datascience #data