AI 요약관련 정보

☕️ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲: To support the channel and encourage new videos, please consider buying me a coffee here: https://ko-fi.com/bugbytes Marimo Playlist:    • Marimo Notebooks for Data Science   ⭐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/configu... Marimo SQL: https://docs.marimo.io/guides/working... Polars: https://pola.rs/ DuckDB:    • DuckDB and SQL - for Data Analysis and Pro...   Kaggle data: https://www.kaggle.com/datasets/muham... #python #datascience #dataanalytics #dataengineering