Skip to main content
 首页 » 编程设计

python之获取数据直到最后而不是使用多个 next(v)[1]

2025年04月02日8youxin

您好,我有一个 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:] ]