python - python计算dict值之间的增量时间

问题描述

我有一个带有提交日期的字典。我想计算每次提交之间有多少天。现在我把日期放在一个列表中，但是当我想计算天数时，它给了我一个错误。

我什至尝试用前一个日期填充空点，以便它们之间的天数为 0。这也给了我下面看到的 ValueError。

我现在正在使用的代码：

days_inbetween = []
    
    for i in time_list:
        index = time_list.index(i)
        # print(index)
        if i == '':
            # print(i)
            continue
        else:
            try:
                days = datetime.strptime(time_list[index + 1], time_format) - datetime.strptime(i, time_format)
                # print(days)
                days_inbetween.append(days.days)
                     
            except:
                    days = datetime.strptime(time_list[-1], time_format) - datetime.strptime(i, time_format)
                    days_inbetween.append(days.days)

    print(days_inbetween)


---------------------------------------------------------------------------------------------------------

This is the dictionary

from:

"User": {
        "US01": "7-10-2020 05:49",
        "US02": "8-10-2020 06:09",
        "US03": "12-10-2020 06:05",
        "US04": "14-10-2020 12:17",
        "US05": "14-10-2020 12:17",
        "US06": "21-10-2020 07:11",
        "US07": "21-10-2020 07:11",
        "US08": "23-10-2020 06:36",
        "US09": "27-10-2020 06:42",
        "US10": "27-10-2020 06:42",
        "US11": "28-10-2020 08:28",
        "US12": "",
        "US13": "28-10-2020 08:28",
        "US14": "",
        "US15": "",
        "US16": "",
        "US17": "29-10-2020 16:22"
    }



To:

"User": {
        "US01": "3 days",
        "US02": "2 days",
        "US03": "2 days",
        "US04": "0 days",
        "US05": "6 days",
        "US06": "0 days",
        "US07": "1 days",
        "US08": "4 days",
        "US09": "0 days",
        "US10": "1 days",
        "US11": "0 days",
        "US12": "not done",
        "US13": "1 days",
        "US14": "not done",
        "US15": "not done",
        "US16": "not done",
        "US17": "1 days"
    }

这是我得到的错误：

标签： pythondictionary

python - python计算dict值之间的增量时间

问题描述

解决方案

推荐阅读