处理多个csv文件在Python中添加元数据

import pandas as pd
import os

# 假设文件夹中有多个CSV文件
folder_path = 'path/to/csv/files'
csv_files = [f for f in os.listdir(folder_path) if f.endswith('.csv')]

# 读取所有CSV文件
dataframes = []
for file in csv_files:
    df = pd.read_csv(os.path.join(folder_path, file))
    dataframes.append(df)

# 添加元数据
for i, df in enumerate(dataframes):
    df['source_file'] = csv_files[i]
    df['created_at'] = pd.Timestamp.now()

# 合并所有数据框
combined_df = pd.concat(dataframes, ignore_index=True)

# 保存到新的CSV文件
combined_df.to_csv('combined_with_metadata.csv', index=False)

# 假设有两个不同结构的CSV文件
df1 = pd.read_csv('file1.csv', header=0)
df2 = pd.read_csv('file2.csv', header=1)  # 假设第二行是列名