使用python读取csv文件并写入另一个文件

Question

嗨，我是python新手，我想写一个程序，它将读取csv文件并将数据写入另一个文件。在

代码如下：

    #!/usr/bin/python

import csv

FEED_FILE = '/proj/ctc/temp/sanjay/REC-754/20170529_MUREX_EOD_REC_RATES_20170531.csv'
OUT_FILE = '/proj/ctc/temp/sanjay/REC-754/20170529_MUREX_EOD_REC_RATES_20170531_out.csv'

with open(OUT_FILE, 'w', newline='') as outputfile:
    with open(FEED_FILE, newline='') as feed:
    writer = csv.writer(outputfile, delimiter=',', quotechar='"')
        reader = csv.reader(feed, delimiter=',', quotechar='"')
        for row in reader: 
        row[3] = sorted(list(row[3].split(','))
                writer.writerow(row)

但我的错误越来越少，我不明白为什么？在

^{pr2}$

请帮我解决这个问题，谢谢。在

Answer 1

问题出在压痕上！在

with open(OUT_FILE, 'w', newline='') as outputfile:
    with open(FEED_FILE, newline='') as feed:
        writer = csv.writer(outputfile, delimiter=',', quotechar='"')
        reader = csv.reader(feed, delimiter=',', quotechar='"')
        for row in reader: 
            row[3] = sorted(list(row[3].split(','))
            writer.writerow(row)

编辑： 对于您更新的问题，又出现了缩进问题！在

这个

^{pr2}$

应该是

                row[3] = sorted(list(row[3].split(','))
                writer.writerow(row)

Answer 2

请尝试以下代码：

with open(OUT_FILE, 'w', newline='') as outputfile:
    with open(FEED_FILE, newline='') as feed:
        writer = csv.writer(outputfile, delimiter=',', quotechar='"')
        reader = csv.reader(feed, delimiter=',', quotechar='"')
        for row in reader: 
            row[3] = sorted(list(row[3].split(',')))
            writer.writerow(row)