python 日期格式只取年月_转换日期格式python - 异常日期格式 - 提取％Y％M％D

I have a large data set with a variety of Date information in the following formats:

DAYS since Jan 1, 1900 - ex: 41213 - I believe these are from Excel http://www.kirix.com/stratablog/jd-edwards-date-conversions-cyyddd

YYDayofyear - ex 2012265

I am familiar with python's time module, strptime() method, and strftime () method. However, I am not sure what these date formats above are called on if there is a python module I can use to convert these unusual date formats.

Any idea how to get the %Y%M%D format from these unusual date formats without writing my own calculator?

Thanks.

解决方案

You can try something like the following:

In [1]: import datetime

In [2]: s = '2012265'

In [3]: datetime.datetime.strptime(s, '%Y%j')

Out[3]: datetime.datetime(2012, 9, 21, 0, 0)

In [4]: d = '41213'

In [5]: datetime.date(1900, 1, 1) + datetime.timedelta(int(d))

Out[5]: datetime.date(2012, 11, 2)

The first one is the trickier one, but it uses the %j parameter to interpret the day of the year you provide (after a four-digit year, represented by %Y). The second one is simply the number of days since January 1, 1900.

This is the general conversion - not sure of your input format but hopefully this can be tweaked to suit it.