import pandas as pd import datetime df1 = pd.read_csv('nowcoder.csv',sep=',') df1['date'] = pd.to_datetime(df1['date']).dt.date print(df1.groupby('result')['user_id'].count())