[已解决]文本分割

SilverCrow

datafile 是具有5列数据的文本文件，每一列数据使用逗号（","）分割，请使用Python编程统计datafile第2列数据中不等于300的数据项的平均值，要求等于300的数据项不参与统计。

最佳答案

月排行榜 / 总排行榜

qq1151985918

2021-1-5 11:45:48

f = open("datafile.txt","w",encoding="utf-8")
f.write("102,300,302,356,547\n231,432,436,765,300\n234,453,545,324,768")
f.close()

import csv
getsumlist = []
j = open("datafile.txt","r",encoding="utf-8")
csvreader = csv.reader(j)
for i in csvreader:
    if int(i[1]) != 300:#第二列
        getsumlist.append(int(i[1]))
j.close()
print(getsumlist)
average = sum(getsumlist)/len(getsumlist)
print(average)

跳转到最佳答案楼层

wp231957

样本数据呢  不拿数据  咋玩？？

SilverCrow

wp231957 发表于 2021-1-5 10:19
样本数据呢  不拿数据  咋玩？？

作业题，就是没数据啊

z5560636

SilverCrow 发表于 2021-1-5 10:29
作业题，就是没数据啊

样本数据呢  不拿数据  咋玩？？

qq1151985918

f = open("datafile.txt","w",encoding="utf-8")
f.write("102,300,302,356,547\n231,432,436,765,300\n234,453,545,324,768")
f.close()

import csv
getsumlist = []
j = open("datafile.txt","r",encoding="utf-8")
csvreader = csv.reader(j)
for i in csvreader:
    if int(i[1]) != 300:#第二列
        getsumlist.append(int(i[1]))
j.close()
print(getsumlist)
average = sum(getsumlist)/len(getsumlist)
print(average)