我有一个 csv 文件,如下所示:[8:3:1978] LOG [Sale:internals.py:makeSaleEntry:0] Entered with productid= 2327, storeid= 146, No.OfUnits= 1[19:1:2007] LOG [Sale:internals.py:makeSaleEntry:1] Entered with productid= 1908, storeid= 202, No.OfUnits= 11[22:4:2001] LOG [Sale:internals.py:makeSaleEntry:2] Entered with productid= 3072, storeid= 185, No.OfUnits= 16[22:12:1915] LOG [Sale:internals.py:makeSaleEntry:3] Entered with productid= 1355, storeid= 177, No.OfUnits= 1[19:8:1963] LOG [Sale:internals.py:makeSaleEntry:4] Entered with productid= 2235, storeid= 35, No.OfUnits= 16[16:11:1997] LOG [Sale:internals.py:makeSaleEntry:5] Entered with productid= 1439, storeid= 141, No.OfUnits= 26我已经使用数据帧 df 读取了该文件。df = pd.read_csv('a.txt')我想逐行访问数据框并在另一个 csv 文件中打印 productid、storeid 和 No.OfUnits,如下所示:2327,146,11908,202,113072,185,161355,177,12235,35,161439,141,26我的一段代码是:for i, row in df.iterrows(): strr = "" for j, column in row.iteritems(): seq = column.split('= ') strr = strr + seq[1] + "," file = open("a.csv", "a") file.write(strr[:-1]+"\n") file.close()这段代码工作正常,只是它忽略了写第一行 (2327,146,1)。请提出更改建议。
添加回答
举报
0/150
提交
取消