debug之csv文件打开报错

遇到的提示错误：_csv.Error: new-line character seen in unquoted field - do you need to open the file in universal-newline mode?

错误code如下：

import csv
import sys

input_file = sys.argv[1]
output_file = sys.argv[2]

with open(input_file, 'r') as csv_in_file:   
    with open(output_file, 'w') as csv_out_file:
        filereader = csv.reader(csv_in_file)      
        filewriter = csv.writer(csv_out_file)
        header = next(filereader)

        #print header

        filewriter.writerow(header)
        for row_list in filereader:
           #print row_list
            supplier = str(row_list[0]).strip()
            cost = str(row_list[3]).strip("$").replace(',', '')
            if supplier == 'Supplier X' or float(cost)>600.0:
                filewriter.writerow(row_list)

解决方法：

将上述代码第7行写成 with open(input_file, 'rU') as csv_in_file: 后解决

主要是打开文件的模式不正确。

'U'       universal newline mode (deprecated)——在python3中已经弃用

详见：http://www.runoob.com/python/python-func-open.html

https://blog.csdn.net/u010105645/article/details/78808779