使用python从CSV文件中删除特定的列/行

import csv

with open('file.csv', 'r') as file:
    reader = csv.reader(file)

with open('new_file.csv', 'w', newline='') as new_file:
    writer = csv.writer(new_file)

for row in reader:
    # 删除特定的列
    del row[column_index]
    
    # 删除特定的行
    if row_index != specific_row_index:
        writer.writerow(row)

import csv

def delete_column(file_path, column_index):
    with open(file_path, 'r') as file:
        reader = csv.reader(file)
        
        with open('new_file.csv', 'w', newline='') as new_file:
            writer = csv.writer(new_file)
            
            for row in reader:
                del row[column_index]
                writer.writerow(row)

def delete_row(file_path, specific_row_index):
    with open(file_path, 'r') as file:
        reader = csv.reader(file)
        
        with open('new_file.csv', 'w', newline='') as new_file:
            writer = csv.writer(new_file)
            
            for row_index, row in enumerate(reader):
                if row_index != specific_row_index:
                    writer.writerow(row)

# 示例用法
delete_column('file.csv', 2)  # 删除第3列
delete_row('file.csv', 4)  # 删除第5行