CODEWITHSUNDEEP
pythondatetimepython-polars
user20081698
user20081698

Reputation: 35

Get python datetime from polars datetime

How do I get the python timestamp from the polars datetime object (which is a polars Expression)?

import polars as pl
pl_timestamp = pl.datetime(year=2020, month=6, day=5).dt.with_time_zone("UTC")
py_timestamp = ...

Upvotes: 1

Views: 578

Answers (1)

user18559875
user18559875

Reputation:

You can use polars.select to run Polars Expressions without a context.

pl.select(pl_timestamp)

shape: (1, 1)
┌─────────────────────────┐
│ datetime                │
│ ---                     │
│ datetime[μs, UTC]       │
╞═════════════════════════╡
│ 2020-06-05 00:00:00 UTC │
└─────────────────────────┘

From here, you can use indexing to convert to a Python object.

pl.select(pl_timestamp)[0, 0]

>>> pl.select(pl_timestamp)[0, 0]
datetime.datetime(2020, 6, 5, 0, 0)

Edit

The timezone information is maintained. For example:

pl_timestamp = pl.datetime(year=2020, month=6, day=5).dt.replace_time_zone("Europe/London")

pl.select(pl_timestamp)[0, 0]

>>> pl.select(pl_timestamp)[0, 0]
datetime.datetime(2020, 6, 5, 0, 0, tzinfo=zoneinfo.ZoneInfo(key='Europe/London'))

Upvotes: 6

Related Questions