按季度周对日期进行分组

import pandas as pd
from datetime import datetime

# 创建一个日期范围
dates = pd.date_range(start='2023-01-01', end='2023-12-31')

# 创建一个DataFrame
df = pd.DataFrame(dates, columns=['date'])

# 定义一个函数来计算季度周
def get_quarter_week(date):
    year = date.year
    quarter = (date.month - 1) // 3 + 1
    week_of_year = date.isocalendar()[1]
    return f'{year}Q{quarter}W{week_of_year}'

# 应用函数并创建新列
df['quarter_week'] = df['date'].apply(get_quarter_week)

# 按季度周分组并计数
grouped = df.groupby('quarter_week').size()

print(grouped)

def custom_get_quarter_week(date):
    year = date.year
    quarter = (date.month - 1) // 3 + 1
    # 使用自定义的周开始日（如周一）
    week_of_year = date.isocalendar()[1] if date.weekday() < 4 else date.isocalendar()[1] - 1
    return f'{year}Q{quarter}W{week_of_year}'

df['custom_quarter_week'] = df['date'].apply(custom_get_quarter_week)