如何使用Python从CSV文件的列中删除英语单词

import csv
import re

# 定义一个函数，用于检查并删除英语单词
def remove_english_words(text):
    # 使用正则表达式匹配所有英文单词
    english_words_pattern = r'\b[a-zA-Z]+\b'
    # 替换匹配到的英文单词为空字符串
    return re.sub(english_words_pattern, '', text)

# 读取CSV文件并处理数据
input_file = 'input.csv'
output_file = 'output.csv'

with open(input_file, mode='r', encoding='utf-8') as infile, \
     open(output_file, mode='w', encoding='utf-8', newline='') as outfile:
    
    reader = csv.DictReader(infile)
    fieldnames = reader.fieldnames
    
    writer = csv.DictWriter(outfile, fieldnames=fieldnames)
    writer.writeheader()
    
    for row in reader:
        # 假设我们要处理的列名为 'column_name'
        if 'column_name' in row:
            row['column_name'] = remove_english_words(row['column_name'])
        writer.writerow(row)

print(f"处理完成，结果已保存到 {output_file}")