Polars

Polars supports dynamic aggregations based on time windows via the function `group_by_dynamic`. To use it, you specify a date(time) column to group by and then determine the windows over which values are aggregated. Note how data points can fall within multiple windows, as shown in the diagram below 👇 See the reference page on `group_by_dynamic` for more information: https://lnkd.in/g3Sb8RJ3. Alternatively, stay tuned for an upcoming blog article.

We finally support writing to cloud storage natively and seamlessly!

We finally support writing to cloud storage natively and seamlessly!

Can't remember how many days each month has? (Me neither!) Memorise this 👇 Polars snippet instead. Using some calendar-aware functions, you can get the answer in a tidy dataframe, as the diagram below shows. You can learn more about `date_range` and `group_by_dynamic` in the docs: https://lnkd.in/g3Sb8RJ3

Tune in this Friday!

Join us this Friday if you're eager to see what it can be like to design a recommender while limiting ourselves to just a DataFrame API. It is somewhat unconventional, but a great excuse to show off a Polars trick or two. https://lnkd.in/eqMCXYaz

New article on the Polars blog! “Breaking the rules with expression expansion” delves into how `.struct.unnest` seems to break one of Polars'most fundamental principles but doesn't: A single expression must always produce a single column as a result. This short article explains how expression expansion makes this possible without breaking the principles that govern Polars. Read it here 👉 https://lnkd.in/dKQmCUMX

The Polars team has been hard at work! We've just published a “Polars in Aggregate” blog post with an overview of some of the additions and changes in Polars from 1.3.0 to 1.15.0. We cover performance improvements to I/O, the addition of inequality joins, and much more! What's your favourite new feature from versions 1.3.0 through 1.15.0? https://lnkd.in/d2SDS-sc

Polars is now on BlueSky under the handle pola.rs. Feel free to give us a follow there: https://lnkd.in/dst_HDWs

You want to join two tables on their ID column, but only when the dates in one table fall within the range of the other table. Polars lets you do that with `join_where`, which supports inequality joins through the use of inequality predicates. Here's an example 👇