怎么用python删除csv特定行

假如现在有个 图书.csv 文件 怎么编写一个 .py文件提示输入特定值 然后会删除该特定值所在行 这种应该怎么实现？ 要写好的代码，不是参考 谢谢

import pandas as pd

df = pd.read_csv('图书馆.csv')
key = input("请输入要删除行所包含的特定值:")
deleteRows = []
for index, row in df.iterrows():
    for v in row:
        if key in str(v):
            deleteRows.append(index)
            break
df = df.drop(index = deleteRows)

df.to_csv('图书馆_修改后.csv')

可以用pandas库读取csv，然后直接
data.drop(index = [0,1])就可以删除第一行和第二行
当然也可以输入某个值，删除那个值所在的行


import csv
import os

root = './csv_files'
path = './main'

file_old = 'file_names_ugc.csv'
file_old = os.path.join(root, file_old)

file_temp = 'file_names_ugc_temp.csv'
file_temp = os.path.join(root, file_temp)
fieldnames = ["","Unnamed: 0", "File_names", "labels"]
with open(file_old, 'r', newline='', encoding='gbk') as f_old, \
        open(file_temp, 'w', newline='', encoding='gbk') as f_temp:
    f_csv_old = csv.DictReader(f_old,fieldnames=fieldnames)
    f_csv_temp = csv.DictWriter(f_temp,fieldnames=fieldnames)
    for row in f_csv_old:
        # print(row['File_names'])
        imgname = row['File_names']
        imgpath = os.path.join(path, imgname)
        # f_csv_temp.writerow(rows)

        try:
            img1 = Image.open(imgpath)

            f_csv_temp.writerow({'': row[''],
                                 'Unnamed: 0': row['Unnamed: 0'],
                                 'File_names': row['File_names'],
                                 'labels': row['labels']})
            # plt.imshow(img1)
            # plt.show()
        except:
           pass

# os.remove(file_old)
# os.rename(file_temp, file_old)

代码参考自链接：https://blog.csdn.net/weixin_38800498/article/details/124041667

参考链接

python删除csv文件某一行_从python中的CSV文件中删除特定行_weixin_39834488的博客-CSDN博客 下面是我将如何处理这个问题，但这可能不是最好的方法。在from datetime import datetimedateranges = [("01-01-1951","12-31-1951"),("07-01-1962","12-31-1962")]dateranges = list(map(lambda dr: tuple(map(lambda x: datetime.strptime(x,"... https://blog.csdn.net/weixin_39834488/article/details/110339570?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522166763859616800186541404%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fblog.%2522%257D&request_id=166763859616800186541404&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~blog~first_rank_ecpm_v1~rank_v31_ecpm-1-110339570-null-null.nonecase&utm_term=%E6%80%8E%E4%B9%88%E7%94%A8python%E5%88%A0%E9%99%A4csv%E7%89%B9%E5%AE%9A%E8%A1%8C&spm=1018.2226.3001.4450

  1. 代码
import csv
import os

first_csv = 'first.csv'
edit_csv = 'first_edit.csv'
with open(first_csv, 'r') as inp, open(edit_csv, 'w') as out:
    writer = csv.writer(out)
    for row in csv.reader(inp):
        if '大雨' not in row[2]:  # 写入不需要删除的文件
            writer.writerow(row)
os.remove(first_csv)    # 移除原始文件
os.rename(edit_csv, first_csv)  # 将过滤后的文件还原成原文件
  1. 测试文件first.csv
test,haha,大雨
test,haha,中雨
test,haha,小雨
test,haha,无雨