如果有一个字段值与列表中的值匹配，则从CSV数据中删除行

import csv

# 假设这是你的CSV文件内容
csv_data = '''name,age,city
Alice,30,New York
Bob,25,Los Angeles
Charlie,22,San Francisco
David,28,New York
'''

# 这是你想要删除的值列表
values_to_remove = ['New York', 'San Francisco']

# 读取CSV数据
rows = csv_data.split('\n')
header = rows[0]
data = rows[1:]

# 过滤掉与values_to_remove匹配的行
filtered_data = [row for row in data if not any(value in row for value in values_to_remove)]

# 将过滤后的数据转换回CSV格式
filtered_csv_data = '\n'.join([header] + filtered_data)

print(filtered_csv_data)

name,age,city
Bob,25,Los Angeles

import csv

values_to_remove = ['New York', 'San Francisco']

with open('input.csv', 'r') as infile, open('output.csv', 'w', newline='') as outfile:
    reader = csv.reader(infile)
    writer = csv.writer(outfile)

    header = next(reader)
    writer.writerow(header)

    for row in reader:
        if not any(value in row for value in values_to_remove):
            writer.writerow(row)