Skip to content

IO: ensure compatibility with 01-24 date formats #8891

Closed
@dacoex

Description

@dacoex

In many engineering and measurement applications, the time is counted from 01-24 to indicate the end of a measurement or integration period.

This issue is to propose that pandas IO functions support importing such timestamps from CSV, Excel etc. out of the box and furthermore, Series can have a flag indicating the reference interval for integration or aggregation fo values (e.g. averaging).

See also:
page 9, clause 5.3 of ISO 8601
http://www.probabilityof.com/iso/8601.pdf
"Time is the time of the recording in the format of hh:mm. Midnight should be referenced as
24 h in the previous day, not 0 h in the next day;

or:
IEC 61724, clause 6.1b, page6
https://law.resource.org/pub/in/bis/S05/is.iec.61724.1998.pdf

Metadata

Metadata

Assignees

No one assigned

    Labels

    DatetimeDatetime data dtypeEnhancementIO DataIO issues that don't fit into a more specific label

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions