Skip to content

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

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
dacoex opened this issue Nov 25, 2014 · 2 comments
Closed

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

dacoex opened this issue Nov 25, 2014 · 2 comments
Labels
Datetime Datetime data dtype Enhancement IO Data IO issues that don't fit into a more specific label

Comments

@dacoex
Copy link
Contributor

dacoex commented Nov 25, 2014

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

@dacoex
Copy link
Contributor Author

dacoex commented Nov 25, 2014

See also:

#4332

#6934

@jorisvandenbossche jorisvandenbossche added the Datetime Datetime data dtype label Jul 11, 2016
@jorisvandenbossche jorisvandenbossche added this to the Someday milestone Jul 11, 2016
@jbrockmendel jbrockmendel added the IO Data IO issues that don't fit into a more specific label label Dec 18, 2019
@mroeschke mroeschke removed this from the Someday milestone Oct 13, 2022
@MarcoGorelli
Copy link
Member

there's been no interest in this in nearly a decade, and to be honest I don't really understand the request. clear input and expected output would help

closing for now then, if there's a need for this someone can open a new issue

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Datetime Datetime data dtype Enhancement IO Data IO issues that don't fit into a more specific label
Projects
None yet
Development

No branches or pull requests

5 participants