python-3.x - 无效的int()的Python文字，基数为: 'N' Error为10

Question

我必须将此csv文件读入列表，并且我声明了类型int以便将列表中的某些列写为整数类型，但是此错误已成为我的问题。

with open('new_toy_dataset.csv','r') as cf:
 for row in cf:
      toy_list.append([int(row[0]), row[1], row[2], int(row[3]), int(row[4]), row[5]])

Data Set
Error

Answer 1

问题是您没有跳过标题。

import csv

toy_list = []
ind = 0

with open('new_toy_dataset.csv','r') as cf:
    reader = csv.reader(cf, delimiter=';') # whatever delimiter it is
    for row in reader:
        if ind == 0:
            ind += 1
            continue

        toy_list.append([int(row[0]), row[1], row[2], int(row[3]), int(row[4]), row[5]])