我正在尝试使用openpyxl将概率写入excel文件。由于某种原因,我在试图保存工作簿时遇到语法错误。请帮忙。
import openpyxl
from openpyxl import Workbook
import math
wb = openpyxl.Workbook()
sheet = wb.active
for m in range(1,50):
for n in range(1,50):
firstTo1 = m
firstTo2 = n
maxPoints = (2 * firstTo1 - 1) * (2 * firstTo2 - 1)
maxPoints1 = 2 * firstTo1 - 1
maxPoints2 = 2 * firstTo2 - 1
probSum1 = 0.0
tempProb1 = 0.0
probSum2 = 0.0
tempProb2 = 0.0
winDec = 0.55
r = firstTo1
for y in range(firstTo1, maxPoints1 + 1):
tempProb1 = (math.factorial(y-1) / (math.factorial((y-1)-(r-1)) * math.factorial(r-1))) * (winDec**r) * ((1-winDec)**(y-r))
probSum1 += tempProb1
r = firstTo2
for y in range(firstTo2, maxPoints2 + 1):
tempProb2 = (math.factorial(y-1) / (math.factorial((y-1)-(r-1)) * math.factorial(r-1))) * (probSum1**r) * ((1-probSum1)**(y-r))
probSum2 += tempProb2
c = sheet.cell(row = n+2, column = m+2)
c.value = probSum2
wb.save('CapstoneData.xlsx')
运行此代码块会出现以下错误:
File "<stdin>", line 23
wb.save('CapstoneData.xlsx')
^^
SyntaxError: invalid syntax
因为在保存工作簿之前没有错误,所以我不太明白错误来自何处。我已经验证了我计算的有效性,只需要将它们写入Excel。谢谢你的帮助!