37,720
社区成员
发帖
与我相关
我的任务
分享
import openpyxl
from collections import Counter
wb = openpyxl.load_workbook('tt.xlsx')
ws = wb.active
print(ws.max_row)
list = []
list_set = []
for i in range(1,ws.max_row+1):
list.append(str(ws.cell(i,1).value))
list_set = set(list) #去重之后列表
c = Counter(list) #统计出现次数
print(list_set,c)
df_count = df['日期'].value_counts().reset_index(name='出现次数').rename({"index":"日期"},axis='columns')