import pandas as pd df = pd.read_csv('nowcoder.csv',sep=',') df[['year-month-day','time']] = df['date'].str.split(' ',expand=True) print(df.groupby(['result','year-month-day'])['year-month-day'].count())