回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我想用Python在我的最终输出csv中添加一个标题行。我该怎么做?首先,我要删除主文件<code>items.csv</code>的头文件,因为python在头文件的末尾也添加了<code>'target'</code>字。但添加单词后,我想写一个新的标题。你知道吗</p>
<p>这是我的密码:</p>
<pre><code>import csv
from itertools import islice
import os
with open('items.csv') as sample, open('items_50.csv', "w") as out:
csv1=csv.reader(sample)
header = next(csv1, None)
csv_writer = csv.writer(out)
sirali = sorted(csv1, key=lambda x:int(x[0]), reverse=True)
csv_writer.writerows(islice(sirali,50))
file1=open('items_50.csv','rb')
readfile=csv.reader(file1,)
file2=open('final.csv','wb')
writefile=csv.writer(file2,delimiter='"')
result=()
for row in readfile:
result= [row[0]+','+row[1]+','+row[2]+','+row[3]+'target']
writefile.writerow(result)
file1.close()
file2.close()
</code></pre>
<p>我的一个例子最终.csv现在:</p>
<pre><code>0,apple,orange,gettarget
25,steven,jack,sendtarget
33,pencil,book,sendtarget
8,notebook,cellphone,gettarget
</code></pre>
<p>我想把它做成这样:</p>
<pre><code>count,thing,owner,action
0,apple,orange,gettarget
25,steven,jack,sendtarget
33,pencil,book,sendtarget
8,notebook,cellphone,gettarget
</code></pre>
<p>谢谢你。你知道吗</p>