使用Python编辑csv文件时跳过标题

Question

我正在使用下面引用的代码使用Python编辑CSV。代码中调用的函数构成了代码的上部。

问题：我希望下面引用的代码从第二行开始编辑csv，我希望它排除包含标题的第一行。现在，它仅在第一行上应用函数，并且我的标题行正在更改。

in_file = open("tmob_notcleaned.csv", "rb")
reader = csv.reader(in_file)
out_file = open("tmob_cleaned.csv", "wb")
writer = csv.writer(out_file)
row = 1
for row in reader:
    row[13] = handle_color(row[10])[1].replace(" - ","").strip()
    row[10] = handle_color(row[10])[0].replace("-","").replace("(","").replace(")","").strip()
    row[14] = handle_gb(row[10])[1].replace("-","").replace(" ","").replace("GB","").strip()
    row[10] = handle_gb(row[10])[0].strip()
    row[9] = handle_oem(row[10])[1].replace("Blackberry","RIM").replace("TMobile","T-Mobile").strip()
    row[15] = handle_addon(row[10])[1].strip()
    row[10] = handle_addon(row[10])[0].replace(" by","").replace("FREE","").strip()
    writer.writerow(row)
in_file.close()    
out_file.close()

我试图通过将row变量初始化为来解决此问题，1但没有成功。

请帮助我解决这个问题。

Answer 1

您的reader变量是可迭代的，通过循环它可以检索行。

要使其在循环前跳过一项，只需调用next(reader, None)并忽略返回值即可。

您还可以稍微简化代码；将打开的文件用作上下文管理器以使其自动关闭：

with open("tmob_notcleaned.csv", "rb") as infile, open("tmob_cleaned.csv", "wb") as outfile:
   reader = csv.reader(infile)
   next(reader, None)  # skip the headers
   writer = csv.writer(outfile)
   for row in reader:
       # process each row
       writer.writerow(row)

# no need to close, the files are closed automatically when you get to this point.

如果您想将标头写入未经处理的输出文件中，也很容易，请将输出传递next()给writer.writerow()：

headers = next(reader, None)  # returns the headers or `None` if the input is empty
if headers:
    writer.writerow(headers)