擅长:python、mysql、java
<p>下面是一个示例,在第二列中添加1:</p>
<pre><code>import csv
with open('data.csv') as infile, open('output.csv', 'wb') as outfile:
reader = csv.reader(infile)
writer = csv.writer(outfile)
for row in reader:
# Transform the second column, which is row[1]
row[1] = int(row[1]) + 1
writer.writerow(row)
</code></pre>
<h2>注意事项</h2>
<ul>
<li><code>csv</code>模块正确解析强烈建议使用的CSV文件</li>
<li>默认情况下,每一行都将被解析为文本,这就是为什么我转换成整数:<code>int(row[1])</code></li>
</ul>
<h2>更新</h2>
<p>如果确实要“就地”编辑文件,请使用<code>fileinput</code>模块:</p>
<pre><code>import fileinput
for line in fileinput.input('data.csv', inplace=True):
fields = line.strip().split(',')
fields[1] = str(int(fields[1]) + 1) # "Update" second column
line = ','.join(fields)
print line # Write the line back to the file, in place
</code></pre>