python筛选数据

编程小白艾雪儿

想要按 “发行人省份.xlsx” 中的不同省份，对 ”新发行债券_20220610.xlsx“ 进行筛选，
但在进行匹配的第16行  ” FF = data.loc[data['发行人省份'] == rowdate] ” 出现了错误，还找不到原因555

1. import pandas as pd
   
2. import xlrd
   
3. 
   
4. dir = r"C:\Users\liqian6\Desktop\RPA工作\全量表数据&母子公司对应关系"#设置工作路径
   
5. 
   
6. #选择发行人省份.xlsx的表，按其第一列的数对新发行债券_20220610.xlsx进行筛选
   
7. workxls =xlrd.open_workbook(dir+"\"+'发行人省份.xlsx')
   
8. worksheet = workxls.sheet_by_name("Sheet1")
   
9. row =worksheet.nrows#总行数
   
10. for i in range(1,2):
    
11.     rowdate =worksheet.row_values(i)  
    
12.     print(rowdate)
    
13.    
    
14.     #读取新发行债券_20220610.xlsx，按不同省份对其进行筛选
    
15.     data = pd.read_excel(dir + "\" + '新发行债券-0610\新发行债券_20220610.xlsx')
    
16.     FF = data.loc[data['发行人省份'] == rowdate]   
    
17. 
    
18.     FF.to_excel(dir + "\" + rowdate + '_20220610.xlsx', engine='xlsxwriter', index = False)
    
19.    
    
20.     print( rowdate+' is successful')

复制代码

错误情况：

1. Traceback (most recent call last):
   
2. 
   
3.   File "C:\Users\liqian6\Desktop\python\python办公自动化_应用\01excel\2. excel筛选数据形成新表.py", line 20, in <module>
   
4.     FF = data.loc[data['发行人省份'] == rowdate]
   
5. 
   
6.   File "C:\Users\liqian6\Anaconda3\lib\site-packages\pandas\core\ops\common.py", line 69, in new_method
   
7.     return method(self, other)
   
8. 
   
9.   File "C:\Users\liqian6\Anaconda3\lib\site-packages\pandas\core\arraylike.py", line 32, in __eq__
   
10.     return self._cmp_method(other, operator.eq)
    
11. 
    
12.   File "C:\Users\liqian6\Anaconda3\lib\site-packages\pandas\core\series.py", line 5502, in _cmp_method
    
13.     res_values = ops.comparison_op(lvalues, rvalues, op)
    
14. 
    
15.   File "C:\Users\liqian6\Anaconda3\lib\site-packages\pandas\core\ops\array_ops.py", line 261, in comparison_op
    
16.     raise ValueError(
    
17. 
    
18. ValueError: ('Lengths must match to compare', (9370,), (1,))

复制代码