您好,我有一个 python 代码,可以在将数据解析为 out.csv 之前从 sample_data.csv 中获取数据。
请查看图像以更好地可视化 sample_data.csv http://i.imgur.com/wwi4RC7.jpg
我的问题是如何从中的最后一个 next(v)[1] 开始
datetime = next(v)[1],next(v)[1],next(v)[1],next(v)[1],next(v)[1]
并一直开始到行尾,而不是愚蠢地使用多个 next(v)[1]?这是一个问题,因为不同的收据有不同的行数,因此我不能有固定数量的 next(v)[1] 用于交易
transaction= next(v)[1], next(v)[1], next(v)[1],next(v)[1],next(v)[1],next(v)[1],next(v)[1],next(v)[1]
import csv
from itertools import groupby
from operator import itemgetter
import re
with open("sample_data.csv", "rb") as f, open("out.csv", "wb") as out:
reader = csv.reader(f)
next(reader)
writer = csv.writer(out)
writer.writerow(["Receipt ID","Name","Address","Date","Time","Items","Amount","Cost","Total"])
groups = groupby(csv.reader(f), key=itemgetter(0))
for k, v in groups:
id_, name = next(v)
add_date_1, add_date_2 = next(v)[1], next(v)[1]
combinedaddress = add_date_1+ " " +add_date_2
datetime = next(v)[1],next(v)[1],next(v)[1],next(v)[1],next(v)[1]
abcd = str(datetime)
dateprinter = re.search('(\d\d/\d\d/\d\d\d\d)\s(\d\d:\d\d)', abcd).group(1)
timeprinter = re.search('(\d\d/\d\d/\d\d\d\d)\s(\d\d:\d\d)', abcd).group(2)
transaction= next(v)[1], next(v)[1], next(v)[1],next(v)[1],next(v)[1],next(v)[1],next(v)[1],next(v)[1]
writer.writerow([id_, name, combinedaddress, dateprinter, timeprinter, transaction])
请您参考如下方法:
如果我正确理解了这个问题,您可以使用列表理解来完成读取 v 中的值,就像这样:
transaction = [ x[1] for x in v ]
这段代码就像获取所有剩余的 next(v)[1] 直到 v 结束。
旁注:一直调用 next(v) 非常丑陋且不切实际,您可以从将 v 转换为列表开始,然后使用简单的列表切片得到你想要的:
v = list(v)
id_, name = v[0]
add_date_1, add_date_2 = [x[1] for x in v[1:3]]
...
transaction = [ x[1] for x in v[1234:] ]
