import pandas as pd from numpy import timedelta64 a = pd.read_csv('nowcoder.csv', sep=',') a['year-month-day'] = a['date'].astype('datetime64[D]') b = a[a['year-month-day'].between('2021-12-01','2021-12-31')].groupby(['result','year-month-day']).size() print(b)