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