Polars - SQL Interface for Querying DataFrames!

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

In this video we'll see how to use SQL to query the data in Polars DataFrames, diving into the features of the Polars package for using SQL.

SQL is a universal data language, used by data engineers, data analysts, etc - the support for SQL in Polars makes it a powerful tool that can be used to analyze data and build pipelines.

📌 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
00:00 Intro
00:08 Intro to Polars
00:34 Polars SQL introduction
01:47 Dataset from Kaggle
02:24 Reading CSV file with Polars read_csv function
04:51 Querying with SQL in Polars
12:25 Querying Null values in SQL
15:00 SQLContext class in Polars

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

📚 𝗙𝘂𝗿𝘁𝗵𝗲𝗿 𝗿𝗲𝗮𝗱𝗶𝗻𝗴 𝗮𝗻𝗱 𝗶𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻:
Employee Dataset: https://www.kaggle.com/datasets/prakh...
Polars SQL Interface: https://docs.pola.rs/api/python/stabl...
Polars SQL Python API: https://docs.pola.rs/api/python/stabl...
SQLContext: https://docs.pola.rs/api/python/stabl...

#python #polars #datascience #data