回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我有一个csv文件,如下所示:</p>
<pre><code>[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
</code></pre>
<p>我用数据帧df读取了这个文件</p>
<pre><code>df = pd.read_csv('a.txt')
</code></pre>
<p>我想逐行访问dataframe并在另一个csv文件中打印productid、storeid和单元号,如下所示:</p>
<pre><code>2327,146,1
1908,202,11
3072,185,16
1355,177,1
2235,35,16
1439,141,26
</code></pre>
<p>我的代码是:</p>
<pre><code>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()
</code></pre>
<p>此代码工作正常,只是忽略了第一行(2327146,1)的编写。请建议更改</p>