将字符串替换为基于导入的CSV列的文件

import csv

def replace_string_with_csv_column(csv_file, replace_string, csv_column):
    # 读取CSV文件
    with open(csv_file, 'r') as file:
        reader = csv.DictReader(file)
        data = list(reader)

    # 替换字符串
    for row in data:
        row['column_to_replace'] = row['column_to_replace'].replace(replace_string, row[csv_column])

    # 生成新文件
    new_csv_file = 'new_file.csv'
    with open(new_csv_file, 'w', newline='') as file:
        writer = csv.DictWriter(file, fieldnames=reader.fieldnames)
        writer.writeheader()
        writer.writerows(data)

    return new_csv_file

# 示例用法
csv_file = 'data.csv'
replace_string = 'replace_me'
csv_column = 'column_to_use'
new_file = replace_string_with_csv_column(csv_file, replace_string, csv_column)
print(f"替换后的文件：{new_file}")