for row in reader: Error: row contains NUL

Question

下面是我的程序现在的样子：

def getdata(file_name):
    with open(file_name, errors='ignore') as f:
        rowdata = []
        reader = csv.reader(f)
        for row in reader:
            rowdata.append(row)
    return rowdata

我一直收到这个错误

for row in reader:

Error: line contains NUL

Answer 1

我猜你在文件中有一个空值。您可以使用以下命令进行测试

if '\0' in open('filename').read():
  print("you have null value in your file")
else:
  print("you don't")

如果这样做，请将空值替换为空格。

reader = csv.reader(x.replace('\0', '') for x in filename)

这样你就可以毫无错误地读取文件了。