Polars DataFrame library

Useful tips for the Polars DataFrame library

Use SQL queries in 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 basics

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

Not found

Timedelta equivalent in Polars

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