如何調整此代碼以使函式回圈通過串列models_2？如果我使用該功能models，它可以作業，如果我更改為“models_2”，它會給我這個錯誤：
AttributeError：“float”物件沒有“seek”屬性
這是我的資料框，來自所有單元格格式設定為“文本”的 excel。
MOD1 MOD2 MOD3 MOD4
0 File1.pdf File3.pdf File1.pdf File3.pdf
1 File2.pdf NaN File2.pdf File3.pdf
2 File3.pdf NaN NaN NaN
models = ['MOD1']
models_2 = ['MOD1', 'MOD2']
def merge_pdf(models):
merger = PdfFileMerger()
for name in models:
for index, row in df.iterrows():
merger.append(row[name])
merger.write(f"Order #XXXXXXX ({name}) Production Package - Rev.0.pdf")
merger.close()
merge_pdf(models)
完整的錯誤資訊：
PdfReadWarning: Xref table not zero-indexed. ID numbers for objects will be corrected. [_reader.py:1065]
Traceback (most recent call last):
File "Z:\PyCharm\Excel_Reader\Excel_Reader.py", line 30, in <module>
merge_pdf(models)
File "Z:\PyCharm\Excel_Reader\Excel_Reader.py", line 27, in merge_pdf
merger.append(row[name])
File "C:\Users\x\AppData\Local\Programs\Python\Python39\lib\site-packages\PyPDF2\merger.py", line 227, in append
self.merge(len(self.pages), fileobj, bookmark, pages, import_bookmarks)
File "C:\Users\x\AppData\Local\Programs\Python\Python39\lib\site-packages\PyPDF2\merger.py", line 149, in merge
pdfr = PdfFileReader(
File "C:\Users\x\AppData\Local\Programs\Python\Python39\lib\site-packages\PyPDF2\_reader.py", line 239, in __init__
self.read(stream)
File "C:\Users\x\AppData\Local\Programs\Python\Python39\lib\site-packages\PyPDF2\_reader.py", line 911, in read
stream.seek(-1, 2)
AttributeError: 'float' object has no attribute 'seek'
uj5u.com熱心網友回復：
您的代碼失敗，因為“MOD2”列包含NaN型別為 的值float。你處理這個問題的方式取決于你想用這些NaN值做什么。
您可以通過運行以下代碼來驗證這一點：
import pandas as pd
import numpy as np
data = {
'MOD1':['File1.pdf', 'File2.pdf', 'File3.pdf'],
'MOD2':['File1.pdf', np.nan, np.nan],
'MOD3':['File1.pdf', 'File2.pdf', np.nan],
'MOD4':['File1.pdf', 'File2.pdf', np.nan]
}
df = pd.DataFrame(data)
models = ['MOD1']
models_2 = ['MOD1', 'MOD2']
merger = []
for name in models_2:
for index, row in df.iterrows():
print(name, index, row[name], type(row[name]))
這將列印以下內容：
MOD1 0 File1.pdf <class 'str'>
MOD1 1 File2.pdf <class 'str'>
MOD1 2 File3.pdf <class 'str'>
MOD2 0 File1.pdf <class 'str'>
MOD2 1 nan <class 'float'>
MOD2 2 nan <class 'float'>
如果您知道只想包含具有字串值的單元格，則可以在將其附加到merger物件之前添加型別檢查，如下所示：
models = ['MOD1']
models_2 = ['MOD1', 'MOD2']
def merge_pdf(models):
merger = PdfFileMerger()
for name in models:
for index, row in df.iterrows():
if type(row[name]) == str:
merger.append(row[name])
merger.write(f"Order #XXXXXXX ({name}) Production Package - Rev.0.pdf")
merger.close()
merge_pdf(models)
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/481825.html