python 分箱出现问题

伊阳

1. def industry():
   
2.     # 导入数据
   
3.     data = pd.read_csv(r'ALL.csv', encoding='gbk')
   
4.     indcd = data['Indcd'].value_counts().index
   
5.     year =  data['Accper'].value_counts().index
   
6.     data_remo = pd.DataFrame(columns=data.columns)   # 新建一个df用于储存
   
7.     for i in indcd:
   
8.         data_group = data[data['Indcd'].isin([i])].copy()   # 按行业分组
   
9.         for j in year:
   
10.             data_group = data_group[data_group['Accper'].isin([j])].copy() #按时间分组
    
11.             data_group['RDSV'], cut_bin = pd.qcut(data_group['RDS_N'], q=5, labels=['0', '1', '2', '3','4'], retbins=True, duplicates='drop')
    
12.             data_group['SEINSV'], cut_bin = pd.qcut(data_group['SEINS_N'], q=5, labels=['0', '1', '2', '3','4'], retbins=True, duplicates='drop')
    
13.             data_group['STRA'] = data_group['SEINSV'].astype(int) + data_group['RDSV'].astype(int)
    
14.             data_group = data_group.reset_index(drop=True)
    
15.             data_remo = data_remo.append(data_group, ignore_index=True)
    
16.     final_pr = ['Indcd', 'Stkcd', 'Accper', 'STRA']
    
17.     data_remo = data_remo.loc[:, final_pr]
    
18.     data_remo.set_index('Indcd', inplace=True)
    
19.     print(data_remo)
    
20.     # data_remo.to_csv(r"C:\Users\ASUS\Desktop\FINAL.csv", encoding='gbk')
    
21.     return 0
    
22. industry()

复制代码

运行结果及详细报错内容

1. Traceback (most recent call last):
   
2.   File "C:\Users\ASUS\PycharmProjects\A01-2021-Strategy\main.py", line 89, in <module>
   
3.     industry()
   
4.   File "C:\Users\ASUS\PycharmProjects\A01-2021-Strategy\main.py", line 58, in industry
   
5.     data_group['RDSV'], cut_bin = pd.qcut(data_group['RDS_N'], 5, labels=bin_labels_1, retbins=True, duplicates='drop')
   
6.   File "D:\Anaconda\lib\site-packages\pandas\core\reshape\tile.py", line 372, in qcut
   
7.     fac, bins = _bins_to_cuts(
   
8.   File "D:\Anaconda\lib\site-packages\pandas\core\reshape\tile.py", line 446, in _bins_to_cuts
   
9.     raise ValueError(
   
10. ValueError: Bin labels must be one fewer than the number of bin edges
    
11. 
    
12. 进程已结束,退出代码1

复制代码

1.根据其他帖子，在分箱的时候我加上了.rank(method='first')，但是运行结果还是和没加之前一样
2.使用的 qcut 函数在分箱时，要求标签个数比分箱个数少一个，我分箱数改成了6，仍然报错

1. data_group['RDSV'], cut_bin = pd.qcut(data_group['RDS_N'].rank(method='first'), q=6, labels=['0', '1', '2', '3','4'], retbins=True, duplicates='drop')
   
2. data_group['SEINSV'], cut_bin = pd.qcut(data_group['SEINS_N'].rank(method='first'), q=6, labels=['0', '1', '2', '3','4'], retbins=True, duplicates='drop')

复制代码

z5560636

那你是不是也要把源数据弄上来，让调试一下？

伊阳

z5560636 发表于 2022-12-30 10:15
那你是不是也要把源数据弄上来，让调试一下？

不好意思，我没有找到在哪里上传源数据文件