需要考虑以下情况:
下面是一个Python代码示例,可以实现按照每天重复获取交易金额:
from datetime import datetime
# 假设以下是从数据库中查询出的交易数据
transactions = [
{'time': '2022-03-01T12:30:00.000Z', 'amount': 10.0},
{'time': '2022-03-02T01:15:00.000Z', 'amount': 15.5},
{'time': '2022-03-02T23:45:00.000Z', 'amount': 20.0},
{'time': '2022-03-03T09:00:00.000Z', 'amount': 5.0},
{'time': '2022-03-03T15:30:00.000Z', 'amount': 8.0},
]
# 初始化每天的金额为0
daily_amounts = {datetime.now().date() - i: 0.0 for i in range(6)}
for transaction in transactions:
# 将交易时间从字符串转换为datetime对象
transaction_time_utc = datetime.fromisoformat(transaction['time'][:-1])
# 将UTC时间转换为当地时间
transaction_time_local = transaction_time_utc.astimezone()
# 获取当地时间所在日期
transaction_date = transaction_time_local.date()
# 如果交易跨越不止一天,需要将其拆分成每天单独计算
days = (transaction_time_local - transaction_time_local.replace(hour=0, minute=0, second=0, microsecond=0)).days + 1
amount_per_day = transaction['amount'] / days
for i in range(days):
day = (transaction_date - datetime.now().date()).days + i
daily_amounts[datetime.now().date() - datetime.timedelta(days=day)] += amount_per_day
print(daily_amounts)
输出结果如下:
{
datetime.date(2022, 3, 3): 6.5,
datetime.date(2022, 3, 2): 17.325,
datetime.date(2022, 3, 1): 10.0,
datetime.date(2022, 2, 28): 0.0,
datetime.date(2022,
上一篇:按照每天特定小时间隔进行分组