Marimo Notebooks - Query Polars DataFrames with SQL!

☕️ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲:
To support the channel and encourage new videos, please consider buying me a coffee here:
https://ko-fi.com/bugbytes

Marimo Playlist: https://www.youtube.com/playlist?list=PL-2EBeDYMIbQkHyxk4PksdDo7mnt0u2z9

⭐Top resource to learn Python - https://datacamp.pxf.io/kOjKkV ⭐

This video shows how to use SQL to query Polars DataFrames in Marimo Notebooks, using SQL Cells. We perform an analytical query using the LAG window function and a common-table expression to get insight into the data we read in. This video also dives into how to configure Marimo notebooks through the user interface, and from a .marimo.toml file.

📌 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
00:00 Intro
00:43 Installing SQL dependencies - DuckDB and Pyarrow
02:21 Querying dataframes with SQL
05:32 Converting date column to Date data-type
07:30 Comparing values to previous row with SQL LAG window function
10:05 Getting months with largest increase in popularity using SQL Common Table Expression
12:50 Marimo SQL cells - under the hood
13:46 More SQL analytical queries
15:38 Plotting SQL query outputs
17:48 Marimo configuration

𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:
📖 Blog: https://bugbytes.io/posts/
👾 Github: https://github.com/bugbytes-io

📚 𝗙𝘂𝗿𝘁𝗵𝗲𝗿 𝗿𝗲𝗮𝗱𝗶𝗻𝗴 𝗮𝗻𝗱 𝗶𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻:
Marimo: https://marimo.io/
Marimo configuration: https://docs.marimo.io/guides/configuration
Marimo SQL: https://docs.marimo.io/guides/working_with_data/sql
Polars: https://pola.rs/
DuckDB: https://www.youtube.com/watch?v=HJGiMTLcpDs
Kaggle data: https://www.kaggle.com/datasets/muhammadkhalid/most-popular-programming-languages-since-2004

#python #datascience #dataanalytics #dataengineering

Видео Marimo Notebooks - Query Polars DataFrames with SQL! канала BugBytes