如何使用python将多个CSV文件合并为一个文件，并在最终的CSV文件中创建超级模式

import os
import glob
import pandas as pd

def merge_csv_files(input_folder, output_file):
    all_files = glob.glob(os.path.join(input_folder, "*.csv"))
    df_list = []
    for file in all_files:
        df = pd.read_csv(file)
        df_list.append(df)
    merged_df = pd.concat(df_list, ignore_index=True)
    merged_df.to_csv(output_file, index=False)

input_folder = "输入文件夹路径"
output_file = "输出文件路径"
merge_csv_files(input_folder, output_file)

super_mode = ["列1名称", "列2名称", "列3名称"]  # 替换为实际的列名称
with open(output_file, 'r+') as f:
    content = f.read()
    f.seek(0, 0)
    f.write(','.join(super_mode) + '\n' + content)

import os
import glob
import pandas as pd

def merge_csv_files(input_folder, output_file):
    all_files = glob.glob(os.path.join(input_folder, "*.csv"))
    df_list = []
    for file in all_files:
        df = pd.read_csv(file)
        df_list.append(df)
    merged_df = pd.concat(df_list, ignore_index=True)
    merged_df.to_csv(output_file, index=False)

input_folder = "输入文件夹路径"
output_file = "输出文件路径"
merge_csv_files(input_folder, output_file)

super_mode = ["列1名称", "列2名称", "列3名称"]  # 替换为实际的列名称
with open(output_file, 'r+') as f:
    content = f.read()
    f.seek(0, 0)
    f.write(','.join(super_mode) + '\n' + content)