python删除csv某一行,使用python删除csv文件中的特定行

I am trying to remove a row from a csv file if the 2nd column matches a string. My csv file has the following information:

Name

15 Dog

I want the row with "Name" in it removed. The code I am using is:

import csv

reader = csv.reader(open("info.csv", "rb"), delimiter=',')

f = csv.writer(open("final.csv", "wb"))

for line in reader:

if "Name" not in line:

f.writerow(line)

print line

But the "Name" row isn't removed. What am I doing wrong?

EDIT: I was using the wrong delimiter. Changing it to \t worked. Below is the code that works now.

import csv

reader = csv.reader(open("info.csv", "rb"), delimiter='\t')

f = csv.writer(open("final.csv", "wb"))

for line in reader:

if "Name" not in line:

f.writerow(line)

print line

解决方案

Seems that you are specifying the wrong delimiter (comma)in csv.reader