import pandas as pd
data = pd.read_excel(r"C:\Users\Administrator\計算機技術與軟體工程學院.xls")
rows = data.shape[0] #獲取行數 shape[1]獲取列數
department_list = []
for i in range(rows):
temp = data["班級"][i]
if temp not in department_list:
department_list.append(temp)
for department in department_list:
new_df = pd.DataFrame()
for i in range (0, rows):
if data["班級"][i] == department:
new_df = pd.concat([new_df, data.iloc[[i],:]], axis = 0, ignore_index = True)
new_df.to_excel("C:\\Users\\Administrator\\Desktop\\學分預警18級\\"+str(department)+".xls", sheet_name=department, index = False)
報錯：AttributeError Traceback (most recent call last)
<ipython-input-23-93e42d0bf2b9> in <module>()
16 new_df = pd.concat([new_df, data.iloc[[i],:]], axis = 0, ignore_index = True)
17
---> 18 new_df.to_excel("C:\\Users\\Administrator\\Desktop\\學分預警18級\\"+str(department)+".xls", sheet_name=department, index = False) #將每個銷售部門存成一個新excel
D:\anaconda\lib\site-packages\pandas\core\frame.py in to_excel(self, excel_writer, sheet_name, na_rep, float_format, columns, header, index, index_label, startrow, startcol, engine, merge_cells, encoding, inf_rep, verbose, freeze_panes)
1764 formatter.write(excel_writer, sheet_name=sheet_name, startrow=startrow,
1765 startcol=startcol, freeze_panes=freeze_panes,
-> 1766 engine=engine)
1767
1768 def to_stata(self, fname, convert_dates=None, write_index=True,
D:\anaconda\lib\site-packages\pandas\io\formats\excel.py in write(self, writer, sheet_name, startrow, startcol, freeze_panes, engine)
650 writer.write_cells(formatted_cells, sheet_name,
651 startrow=startrow, startcol=startcol,
--> 652 freeze_panes=freeze_panes)
653 if need_save:
654 writer.save()
D:\anaconda\lib\site-packages\pandas\io\excel.py in write_cells(self, cells, sheet_name, startrow, startcol, freeze_panes)
1471 wks = self.sheets[sheet_name]
1472 else:
-> 1473 wks = self.book.add_sheet(sheet_name)
1474 self.sheets[sheet_name] = wks
1475
D:\anaconda\lib\site-packages\xlwt\Workbook.py in add_sheet(self, sheetname, cell_overwrite_ok)
364 from .Worksheet import Worksheet
365 if not isinstance(sheetname, unicode_type):
--> 366 sheetname = sheetname.decode(self.encoding)
367 if not Utils.valid_sheet_name(sheetname):
368 raise Exception("invalid worksheet name %r" % sheetname)
AttributeError: 'int' object has no attribute 'decode'
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/60758.html
標籤：其他
上一篇：Hi3559A 加載wk檔案失敗