import pandas as pd df = pd.read_csv('nowcoder.csv', sep=',', parse_dates=['date']) pd.set_option("display.width", 300) pd.set_option("display.max_rows", None) pd.set_option("display.max_columns", None) temp = df[((df.result == 'right') | (df.result == 'wrong') ) & (df.date.dt.month == 12)] temp = temp.groupby(['result', temp.date.dt.date])['question_id'].count() print(temp.rename_axis(index={'date':'year-month-day'}))