运行这段代码出现TypeError: '<' not supported between instances of 'datetime.date' and 'int'错误csp_info.replace(to_replace=r'^\s*$', value=np.nan, regex=True, inplace=True) csp_info.dropna(inplace=True) csp_info['year'] = csp_info['DealTime'].str.split('/', expand=True)[0] csp_info['month'] = csp_info['DealTime'].str.split('/', expand=True)[1] csp_info['day'] = csp_info['DealTime'].str.split('/', expand=True)[2].str.split(' ', expand=True)[0] stu_info_copy = stu_info[['bf_StudentID','cla_id']] # csp_info_copy = csp_info.copy() csp_info['csp_date'] = 0 csp_info['Mon'] = 0 for i in range(csp_info['csp_date'].shape[0]): csp_info['csp_date'].iloc[i] = str(csp_info['year'].iloc[i]) + '-' + str(csp_info['month'].iloc[i]) + '-' + str( csp_info['day'].iloc[i]) csp_info['Mon'].iloc[i] = float(str(csp_info['MonDeal'].iloc[i]).split('-')[1]) # print(csp_info) csp_info['csp_date'] = pd.to_datetime(csp_info['csp_date']).dt.date csp_info_copy = csp_info[['bf_StudentID', 'csp_date', 'Mon']] csp_num = csp_info_copy.groupby(['csp_date']).count().reset_index() csp_info_date_all = [] for i in range(csp_num.shape[0]): csp_info_date_all.append(str(csp_num['csp_date'].iloc[i])) print(len(csp_info_date_all)) stu_info_copy_merge = pd.merge(stu_info_copy, csp_info_copy, on='bf_StudentID', how='left') stu_info_copy_merge = stu_info_copy_merge.fillna(0) Mon_arr = [] for i in range(len(classId)): stu_info_copy_merge_id = stu_info_copy_merge.drop(stu_info_copy_merge[stu_info_copy_merge['cla_id'] != classId[i]].index) print(stu_info_copy_merge_id) csp_date = [] Mon= [] Num= [] csp_money = stu_info_copy_merge_id[['csp_date', 'Mon']].groupby('csp_date').sum().reset_index() csp_num = stu_info_copy_merge_id[['csp_date','Mon']].groupby('csp_date').count().reset_index() print(csp_money) print(csp_num)
时间: 2023-05-15 21:05:56 浏览: 203
TypeError: unsupported format string passed to NoneType.__format__
5星 · 资源好评率100%
这段代码出现了TypeError: '<' not supported between instances of 'datetime.date' and 'int'错误。可能是因为在代码中使用了日期类型和整数类型之间的比较,导致出现了错误。具体原因需要查看代码中的其他部分。
阅读全文