题解 | 牛客网的每日练题量
import pandas as pd data = pd.read_csv('nowcoder.csv',sep=',') data['date']=pd.to_datetime(data['date']) data = data[(data['date'].dt.year == 2021) & (data['date'].dt.month == 12)] data['date']=data['date'].dt.date s = data.groupby(['date'])['question_id'].nunique() s.index = pd.DatetimeIndex(s.index, freq='D') # 设置频率为 D(按天) print(s)
s.index这块,对于我们分组列自动就是索引列