Polars Dataframe Library

Some useful tips about polars dataframe library

Using SQL queries inside polars

res = pl.SQLContext(frame=df).execute(
"""
with cte as (
  SELECT customer_id, primary_term, final_term from frame where primary_term > final_term limit 100
)
select * from cte order by primary_term desc limit 10
"""
)
res.collect()

Polars basic

GitHub - gautamnaik1994/2023-Pycon-Polars: Intro to Polars TutorialGitHub

Not found

Timedelta equivalent for Polars

df=df.with_columns(
    pl.col("created_at").dt.offset_by('-5h30m'),
    pl.col("actual_delivery_time").dt.offset_by('-5h30m')
)