我有一个csv文件,它的第一列中有重复的值,例如:
mg,known,127
mg,unknown,142
pnt,known,37
pnt,unknown,0
lmo,known,75
lmo,unknown,3
sl,known,197
sl,unknown,21
oc,unknown,32
oc,known,163
sv,known,368
sv,unknown,308
az,unknown,6
az,known,241
bug,unknown,1
bug,known,167
li,unknown,15
li,known,174
lg,known,3
我要做的是构造一个新的csv文件,例如:
^{pr2}$我想弄清楚如何才能真正构建行:
def read_stats(path):
has_seen = set()
with open(writepath, 'wb') as write_csv:
with open(path, 'r') as csv_file:
data_reader = csv.reader(csv_file, delimiter=',')
for line in data_reader:
if line[0] in has_seen:
这就是我当前被击中的地方,我必须保留指向下一行的指针吗?在
以下是一种在OrderedDict中累积结果的方法:
如果您可以假设这些行总是首先与已知组成对出现,则可以为knowns创建一个中间结果,并为unknowns生成一个完整的行:
^{pr2}$相关问题 更多 >
编程相关推荐