SQL with Python with Polars DataFrame library (hands-on tutorial)

preview_player
Показать описание
This video shows how to execute SQL queries with Python with Polars DataFrame library. You can use Polars for any kind of tabular data stored in CSV, Parquet, or other standard data file formats.

Polars module is built with Rust which gives it C++ performance and allows to control performance. There are two API:

You can use Polars as a DataFrame library or as query engine backend for your data models. Because of this reason it is beautiful choice for data scientists and data analytics who need handle big amount of data or are more familiar with SQL than Pandas (in Python).

Polars supports Numpy universal and Windows functions, also provides so popular statistics and aggregation functions such as GroupBy, Folds, and Regular Expressions. Also, you can use it with Selecting, Handling, Combining, Multiprocessing data, and even with Time Series data.

Useful links

Content of the video:
0:00 - What is Polars DataFrame library
1:32 - Your first Python code with Polars

In some aspects, Polars can be a good alternative to Spark SQL framework.

If you found useful from this tutorial, please drop a comment or subscribe to get more similar videos!
@DataScienceGarage

#sql #polars #rust #python
Рекомендации по теме
Комментарии
Автор

Just found your youtube channel. Thank you for your valuable content...

snaziruddin
Автор

Thank you for watching this video! I really appreciate your comments if you found it useful or want to suggest a topic for a next video!
Subscribe the channel to get more useful videos soon!

The best place to learn Data Science with the best in the industry - Turing College.

- Vytautas

DataScienceGarage
Автор

Can you please make a full playlist in which everything related to polars library is available like manipulation, and similar applications as in pandas

sameersaifi
Автор

Thank you for the short and concise video,
How about writing the DataFrame into a PostgreSQL database?

zsmain