如何在使用Python加载到MySQL之前替换CSV头文件中的特殊字符？

import csv
import re
import pymysql

def replace_special_chars(csv_file):
    new_rows = []
    with open(csv_file, 'r') as file:
        reader = csv.reader(file)
        for row in reader:
            new_row = []
            for item in row:
                # 使用正则表达式替换特殊字符为合适的字符
                new_item = re.sub('[^a-zA-Z0-9_]', '_', item)
                new_row.append(new_item)
            new_rows.append(new_row)

    # 保存修改后的CSV文件
    with open('new_csv_file.csv', 'w', newline='') as file:
        writer = csv.writer(file)
        writer.writerows(new_rows)

def import_csv_to_mysql(csv_file):
    # 建立与MySQL数据库的连接
    conn = pymysql.connect(host='localhost', user='root', password='password', db='database_name')

    # 创建MySQL表格
    create_table_sql = """
    CREATE TABLE IF NOT EXISTS table_name (
        column1 datatype,
        column2 datatype,
        ...
    )
    """
    with conn.cursor() as cursor:
        cursor.execute(create_table_sql)
    conn.commit()

    # 导入CSV数据到MySQL
    import_data_sql = """
    LOAD DATA INFILE 'new_csv_file.csv'
    INTO TABLE table_name
    FIELDS TERMINATED BY ','
    OPTIONALLY ENCLOSED BY '"'
    LINES TERMINATED BY '\n'
    IGNORE 1 LINES
    """
    with conn.cursor() as cursor:
        cursor.execute(import_data_sql)
    conn.commit()

    conn.close()

# 示例用法
csv_file = 'original_csv_file.csv'
replace_special_chars(csv_file)
import_csv_to_mysql('new_csv_file.csv')