以下是按月份汇总日期时间值的一个解决方法,包含了Python代码示例:
data = [
'2021-01-05 12:30:45',
'2021-01-10 10:15:30',
'2021-02-02 14:20:00',
'2021-02-15 18:45:10',
'2021-03-08 09:00:00',
'2021-03-20 16:30:25',
# ...
]
from datetime import datetime
dates = [datetime.strptime(date_str, '%Y-%m-%d %H:%M:%S') for date_str in data]
months = [(date.year, date.month) for date in dates]
from collections import Counter
month_counts = Counter(months)
for month, count in month_counts.items():
print(f"{month[0]}年{month[1]}月: {count}次")
完整代码示例:
from datetime import datetime
from collections import Counter
data = [
'2021-01-05 12:30:45',
'2021-01-10 10:15:30',
'2021-02-02 14:20:00',
'2021-02-15 18:45:10',
'2021-03-08 09:00:00',
'2021-03-20 16:30:25',
# ...
]
dates = [datetime.strptime(date_str, '%Y-%m-%d %H:%M:%S') for date_str in data]
months = [(date.year, date.month) for date in dates]
month_counts = Counter(months)
for month, count in month_counts.items():
print(f"{month[0]}年{month[1]}月: {count}次")
这个方法将按照月份汇总日期时间值,并输出每个月份的出现次数。你可以根据自己的数据和需求进行适当的修改。