记录一下近期遇到的读取csv文件数据问题。使用gzip.open()函数打开压缩文件,csv.reader()函数读取内容。
1.运行代码为:
filePath = 'test.csv.gz'
with gzip.open(filePath) as f:
f_csv = csv.reader(f,delimiter=',') # 读取csv数据
2.产生报错为:
error:new-line character seen in unquoted field - do you need to open the file in universal-newline mode?
error:new-line character seen in unquoted field - do you need to open the file in universal-newline mode?
3.解决方法
修改csv.reader()部分代码为如下所示,即可正常执行。
with gzip.open(filePath) as f:
f_csv = csv.reader(f.read().splitlines(),delimiter=',') # 读取csv数据