使用 Python 在 csv 文件中的特定列上写入

Use Python to write on specific columns in csv file

提问by Laith

I have data in a file and I need to write it to CSV file in specific column. The data in file is like this:

我在文件中有数据，我需要将其写入特定列中的 CSV 文件。文件中的数据是这样的：

002100
002077
002147

My code is this:

我的代码是这样的：

import csv

f = open ("file.txt","r")
with open("watout.csv", "w") as output:
    for line in f :
       c.writerows(line)

It is always writes on the first column. How could I resolve this? Thanks.

它总是写在第一列上。我怎么能解决这个问题？谢谢。

采纳答案by Laith

This is how I solved the problem

这就是我解决问题的方法

f1 = open ("inFile","r") # open input file for reading

with open('out.csv', 'wb') as f: # output csv file
    writer = csv.writer(f)
    with open('in.csv','r') as csvfile: # input csv file
        reader = csv.reader(csvfile, delimiter=',')
        for row in reader:  
            row[7] = f1.readline() # edit the 8th column 
            writer.writerow(row)
f1.close()   

回答by semiskimmedpie

Read the docsand use the csv module from the standard library.

阅读文档并使用标准库中的 csv 模块。

But to be slightly more specific, you can do:

但更具体地说，你可以这样做：

for column in row:
    do things