Python提取按ID和从日期开始的一年中的周数分组

import pandas as pd
from datetime import datetime

data = pd.DataFrame({'ID': ['A', 'A', 'B', 'B', 'C'],
                     'Date': ['2022-01-01', '2022-02-15', '2022-03-10', '2022-04-20', '2022-05-05']})

data['Date'] = pd.to_datetime(data['Date'])
data['Year'] = data['Date'].dt.year
data['Week'] = data['Date'].dt.week

grouped_data = data.groupby(['ID', 'Year', 'Week']).size().reset_index(name='Count')

print(grouped_data)

  ID  Year  Week  Count
0  A  2022     1      1
1  A  2022     7      1
2  B  2022    10      1
3  B  2022    16      1
4  C  2022    18      1