题解 | #牛客网每日正确与错误的答题次数#

import pandas as pd
import datetime as dt

df = pd.read_csv("nowcoder.csv", sep=",")
pd.set_option("display.width", 300)  # 设置字符显示宽度
pd.set_option("display.max_rows", None)  # 设置显示最大行
pd.set_option("display.max_columns", None)

df['year-month-day']=pd.to_datetime(df.date).dt.date
df.sort_values(by=['result','year-month-day'],inplace=True)
df_group=df.groupby(['result','year-month-day']).question_id.count()
print(df_group)