Datetime timezone aware type

[PaulArnaud]

Hello everyone,

Does pandera have a type to describe a datetime with a timezone (for example: "2023-04-25T16:30:00+02:00") ?

We are fetching time series with the datetime part being timezone-aware but the timezone can vary depending on the data. When using datetime-like types like Annotated[...], one has to specify the timezone which is not possible statically as the timezone depends on the data we fetch.

[mpg-data]

Some answer for this would be great

[max-raphael]

To describe a datetime with a timezone, pandera has https://pandera.readthedocs.io/en/stable/reference/generated/pandera.engines.pandas_engine.DateTime.html. You can do something like

from pandera.engines.pandas_engine import DateTime

class X(DataFrameModel):
    x: DateTime(tz='America/Chicago')

However, if the timezone can vary depending on the data, there isn't much support for that right now. I actually raised this as an enhancement, and am working on the solution now.