Python 讀取csv檔案提示“line contains NULL byte”錯誤，

Python 讀取csv檔案提示“line contains NULL byte”錯誤，

當python讀取檔案出現_csv.Error: line contains NULL byte時，

# -*- coding:utf-8 -*-import csvwith open(r'E:\abc\web_test\userinfo.csv','rb') as f:    reader = csv.reader(f)    rows = [row for row in reader]    print rows

報錯：

D:\Python27\python.exe E:/abc/loop_reader.pyTraceback (most recent call last):  File "E:/abc/web_test/loop_reader.py", line 7, in <module>    rows = [row for row in reader]_csv.Error: line contains NULL byteProcess finished with exit code 1

錯誤提示為：_csv.Error: line contains NULL byte

翻譯為：CSV錯誤，行包含空位元組

原因：通常是因為儲存時副檔名為xls或xlsx,而將其改為csv檔案通常是重新命名

解決方案：把它另存新檔.csv檔案即可