|
import pandas as pd #导入模块
wb = pd.read_excel(r'C:\Users\Administrator\Desktop\fenlei.xlsx') #打开工作薄
col = wb['行数'].unique() #对地市列去重复
for x in col:
child_wb = wb[wb['行数'] == x] #循环,得到每一个地市列表,
child_wb.to_excel(x+'.xlsx',index=False) #将得到的表保存成Excel格式
结果
runfile('C:/Users/Administrator/.spyder-py3/temp.py', wdir='C:/Users/Administrator/.spyder-py3')
Traceback (most recent call last):
File "<ipython-input-11-8044f5c39b77>", line 1, in <module>
runfile('C:/Users/Administrator/.spyder-py3/temp.py', wdir='C:/Users/Administrator/.spyder-py3')
File "D:\ana\envs\glueviz\lib\site-packages\spyder\utils\site\sitecustomize.py", line 705, in runfile
execfile(filename, namespace)
File "D:\ana\envs\glueviz\lib\site-packages\spyder\utils\site\sitecustomize.py", line 102, in execfile
exec(compile(f.read(), filename, 'exec'), namespace)
File "C:/Users/Administrator/.spyder-py3/temp.py", line 21, in <module>
child_wb.to_excel(x+'.xlsx',index=False) #将得到的表保存成Excel格式
TypeError: ufunc 'add' did not contain a loop with signature matching types dtype('<U21') dtype('<U21') dtype('<U21')
|
|