Python-从特定列号写入csv

Question

我有一个 csv 文件 Temp.csv，我正在使用以下代码将其复制到另一个 csv 文件 Final.csv。

dirname = os.path.dirname(os.path.abspath(__file__))
csvfilename = os.path.join(dirname, 'Final.csv')
tempfile = os.path.join(dirname, 'Temp.csv')
with open(csvfilename, 'wb') as output_file:
    writer = csv.writer(output_file, delimiter=',')
    writer.writerow(["Title","This"])
    writer.writerow([])
    with open(tempfile, 'r') as data_file:
        for line in data_file:
            line = line.replace('\n', '')
            row = line.split(",")            
            writer.writerow(row)

代码的最后 5 行将从 A 列写入 Final.csv 文件。我希望它们从 D 列写入 Final.csv。此外，Temp.csv 文件中有多个列。对此最好的解决方案是什么？使用Python 2.7.10。

Answer 1

编辑回复评论。您只需在行

前添加 3 个空字符串即可

dirname = os.path.dirname(os.path.abspath(__file__))
csvfilename = os.path.join(dirname, 'Final.csv')
tempfile = os.path.join(dirname, 'Temp.csv')
with open(csvfilename, 'wb') as output_file:
    writer = csv.writer(output_file, delimiter=',')
    writer.writerow(["Title","This"])
    writer.writerow([])
    with open(tempfile, 'r') as data_file:
        for line in data_file:
            line = line.replace('\n', '')
            row = line.split(",")
            # there are better ways to do this but this is the most straight forward
            new_row = ['', '', '']
            new_row.extend(row)            
            writer.writerow(new_row)