擅长:python、mysql、java
<p>您可以使用csv模块来读取csv并提取数据,而itertools模块则可以获得所有组合。看看它能不能完成任务。我也留下了平均值,但我看到你只是用1个小数点,你可以很容易地得到四舍五入的结果。你现在可以保存结果了。在</p>
<pre><code>from itertools import combinations as cb
import csv
with open("test.csv") as f:
reader=csv.reader(f)
next(reader, None) # skip header
data=[filter(None,i) for i in reader]
def avgg(x):
ll=[float(i) for i in x[1:]] #take review no and convert to float
n=len(ll)
avg_list=[x[0]] #start result list with ref no.
for i in range(3,n+1):
for j in cb(ll,i):
# print(j) #see the combination
avg_list.append(sum(j)/i)
return avg_list
for x in data:
print(avgg(x))
</code></pre>