如何在 python 中从下一个季度开始自动创建季度（Q022022）列表

Question

抱歉，我不是 python 专家。我想自动创建以下列表，并且第一季度必须始终是下一个季度。因此，如果我今天（23/02/22）执行此操作，第一个将是 Q022022，如果我在日期 23/05/22 执行此操作，第一个将是 Q032022。

先感谢您

Answer 1

获取季度

current_quarter = ((month-1) // 3) + 1
next_quarter = current_quarter + 1

如果是上个季度 (4)，则需要使用 modulo (%) 来获取第一季度 (1），并且需要增加 year

next_quarter = ((next_quarter-1) % 4) + 1

if next_quarter < current_quarter:
   year = year + 1

您可以直接从字符串 ` 获取 month 和 year

    date = "23/02/22"

    month = int(date[3:5])
    year  = int(date[7:9]) + 2000

或者您可以使用 datetime 解析它

    date = "23/02/22"

    dt = datetime.datetime.strptime(date, '%d/%m/%y')

    month = dt.month
    year  = dt.year

---

最小工作示例

import datetime

test = [
    ('23/01/22', 'Q022022'),
    ('23/02/22', 'Q022022'),
    ('23/03/22', 'Q022022'),
    
    ('23/04/22', 'Q032022'),
    ('23/05/22', 'Q032022'),
    ('23/09/22', 'Q042022'),
    ('23/12/22', 'Q012023'),
]

for date, expect in test:
    print('date:', date, '| expect:', expect)
    
    dt = datetime.datetime.strptime(date, '%d/%m/%y')
    m = dt.month
    y = dt.year

    #m = int(date[3:5])
    #y = int(date[7:9]) + 2000
    
    #print(dt, m, y)

    current_q = ((m-1) // 3) + 1    # use months 0..11
    next_q = current_q + 1
    next_q = ((next_q-1) % 4) + 1   # use quarters 0..3
    #next_q = (current_q % 4) + 1
    
    print('current:', current_q, '| next:', next_q)
    
    if next_q < current_q:
        y += 1
        
    result = f'Q{next_q:02}{y}'
    
    print('result:', result, '| expect:', expect, '| comparition:', result == expect)
    print('---')

结果：

date: 23/01/22 | expect: Q022022
current: 1 | next: 2
result: Q022022 | expect: Q022022 | comparition: True
---
date: 23/02/22 | expect: Q022022
current: 1 | next: 2
result: Q022022 | expect: Q022022 | comparition: True
---
date: 23/03/22 | expect: Q022022
current: 1 | next: 2
result: Q022022 | expect: Q022022 | comparition: True
---
date: 23/04/22 | expect: Q032022
current: 2 | next: 3
result: Q032022 | expect: Q032022 | comparition: True
---
date: 23/05/22 | expect: Q032022
current: 2 | next: 3
result: Q032022 | expect: Q032022 | comparition: True
---
date: 23/09/22 | expect: Q042022
current: 3 | next: 4
result: Q042022 | expect: Q042022 | comparition: True
---
date: 23/12/22 | expect: Q012023
current: 4 | next: 1
result: Q012023 | expect: Q012023 | comparition: True
---