我在這里有一個來自 Vasilis G. 的回答的函式：
from datetime import datetime def getTotal(line): dates = list(datetime.strptime(elem, '%Y-%m-%d') for elem in line.split(', ')) total = 0 for i in range(0, len(dates), 2): delta = dates[i 1] - dates[i] if delta.days > 90: total = 2 else: total = 1 return total
然后我使用了：
with open('dataset.csv','r') as csvfile: # use with to auto-close file
for row in csvfile.readlines(): # pin_id
getTotal(row) # board_id and section can use defaults
time.sleep(random.randint(1,3)) # wait 1-3 seconds
我想將它應用于我的 csv 檔案中的每一行，但它給了我"ValueError : unconverted data remains : 2022-06-03,2021-05-29,2024-06-03,2022-05-29,2026-06-03,2023-05-29,2028-06-03,2024-05-29,2030-06-03,2025-05-29,2032-06-03與我的 .csv 檔案的第一行重合的結果。
決賽：
from datetime import datetime
def getTotal(line):
dates = [datetime.strptime(elem.strip(), '%Y-%m-%d') for elem in line.split(',')]
total = 0
for i in range(0, len(dates), 2):
delta = dates[i 1] - dates[i]
if delta.days > 90:
total = 2
else:
total = 1
return total
print(getTotal(dates))
with open('dataset.csv','r') as csvfile:
for row in csvfile.readlines():
getTotal(row)
uj5u.com熱心網友回復：
嘗試這個：
def getTotal(line):
dates = [datetime.strptime(elem.strip(), '%Y-%m-%d') for elem in line.split(',')]
...
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/343225.html
標籤：Python
上一篇：將json記錄陣列規范化為資料幀