import random import openpyxl wb = openpyxl.Workbook() sheet = wb.active def generate_combinations(nums, n): result = [] for i in range(1, n+1): for c in itertools.combinations(nums, i): if sorted(list(c)) not in result: result.append(sorted(list(c))) return result def generate_group(nums): group = [] while True: n = random.randint(1, 5) if len(nums) < n: break c = random.sample(nums, n) if sorted(c) not in group: group.append(sorted(c)) for num in c: nums.remove(num) return group nums = [188, 30, 200, 500, 900] combinations = generate_combinations(nums, 5) for i, c in enumerate(combinations): group = generate_group(list(c)) sum = 0 for g in group: sum += sum(g) sheet.cell(row=i+1, column=1, value=sum) wb.save("C:\Users\莫\Desktop\1.xlsx")使用这个代码时出现Traceback (most recent call last): File "E:\vippython\清洗工具\python combo_sum.py", line 36, in <module> sum += sum(g) TypeError: 'int' object is not callable,请将更正后的代码完整发出来
时间: 2023-06-03 19:03:21 浏览: 59
抱歉,由于涉及到编程问题,我可以回答你的问题。下面是更正后的代码:
import random
import openpyxl
import itertools
wb = openpyxl.Workbook()
sheet = wb.active
def generate_combinations(nums, n):
result = []
for i in range(1, n + 1):
for c in itertools.combinations(nums, i):
if sorted(list(c)) not in result:
result.append(sorted(list(c)))
return result
def generate_group(nums):
group = []
while True:
n = random.randint(1, 5)
if len(nums) < n:
break
c = random.sample(nums, n)
if sorted(c) not in group:
group.append(sorted(c))
for num in c:
nums.remove(num)
return group
nums = [188, 30, 200, 500, 900]
combinations = generate_combinations(nums, 5)
for i, c in enumerate(combinations):
group = generate_group(list(c))
sum_value = 0
for g in group:
sum_value += sum(g)
sheet.cell(row=i+1, column=1, value=sum_value)
wb.save("C:\Users\莫\Desktop\1.xlsx")