問題描述

我目前正在嘗試通過將日期轉(zhuǎn)換為時(shí)間戳來在數(shù)據(jù)集中生成數(shù)字特征.如果在 Mac 上運(yùn)行，它可以完美運(yùn)行，在 Windows 上它會拋出:

I am currently trying to generate numerical features in a dataset by converting the dates to timestamps. If run on Mac, it works flawlessly, on Windows it throws an:

OS Error: [Errno 22] Invalid argument

這可能是由于 Windows 不支持 unix 時(shí)間戳1970-01-01 之前.我的日期從 1955 年開始.這是我的代碼:

which is probably due to Windows not supporting unix timestamps from before 1970-01-01. I have dates from 1955 upwards. Here is my code:

import time
import datetime

current_timestamp = time.time()
df.loc[:, "FEATURE_num"] = df["FEATURE"].apply(lambda d: datetime.datetime.strptime(d, '%Y-%m-%d').timestamp() if isinstance(d, str) else current_timestamp)

我在某處看到有人建議使用 datetime.timedelta()，但我不知道如何集成它.

I somewhere saw suggested to maybe use datetime.timedelta(), but I couldn't figure out how to integrate it.

推薦答案

你可以通過(隱式)使用 datetime.timedelta 計(jì)算一個(gè)公歷"時(shí)間戳適用于從 1582 年 10 月 15 日到現(xiàn)在(或您想使用的其他紀(jì)元")的日期.

You could do it by (implicitly) using datetime.timedelta to calculate a "Gregorian" timestamp that would be valid for dates from 1582-Oct-15 to the present (or some other "epoch" you would like to use).

正如函數(shù)的文檔字符串所示，默認(rèn)情況下，日期字符串將使用 '%Y-%m-%d' strptime-like 格式字符串參數(shù)，但可以覆蓋.

As the function's docstring indicates, date strings will, by default, be parsed using a '%Y-%m-%d' strptime-like format string parameter, but that can be overridden.

from datetime import datetime


GREGORIAN_EPOCH = datetime.strptime('1582-10-15', '%Y-%m-%d')


def gregorian_timestamp(date, format='%Y-%m-%d'):
    """ Calculate timestamp using start of Gregorian calender as epoch.

        The date parameter can be either a string or a datetime.datetime
        object. Strings will be parsed using the '%Y-%m-%d' format by default
        unless a different one is specfied via the optional format parameter.
    """
    try:
        date = datetime.strptime(date, format)
    except TypeError:
        pass
    return (date - GREGORIAN_EPOCH).total_seconds()  # The timedelta in seconds.


if __name__ == '__main__':

    current_date = datetime.now()
    timestamp = gregorian_timestamp(current_date)
    print('gregorian timestamp:', timestamp)  # -> gregorian timestamp: 13768250461.136208

    timestamp = gregorian_timestamp('1970-01-01')
    print('gregorian timestamp:', timestamp)  # -> gregorian timestamp: 12219292800.0

    timestamp = gregorian_timestamp('1955-02-28')
    print('gregorian timestamp:', timestamp)  # -> gregorian timestamp: 11750918400.0

    timestamp = gregorian_timestamp('1582-10-15')
    print('gregorian timestamp:', timestamp)  # -> gregorian timestamp: 0.0

這篇關(guān)于對于 1970-01-01 之前的日期，Windows 上 datetime timestamp() 的解決方法的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！