将文件连接到一个数据帧中，同时为每个文件添加标识符

import pandas as pd

# 读取CSV文件
df_csv = pd.read_csv('file.csv')

# 读取JSON文件
df_json = pd.read_json('file.json')

# 读取Excel文件
df_excel = pd.read_excel('file.xlsx')

import os

file_path = 'path/to/file.csv'
if os.path.exists(file_path):
    df = pd.read_csv(file_path)
else:
    print("文件路径错误或文件不存在")

# 统一列名
df_csv.columns = ['col1', 'col2', 'col3']
df_json.columns = ['col1', 'col2', 'col3']

# 合并数据帧
df_merged = pd.concat([df_csv, df_json], ignore_index=True)

# 为每个文件添加标识符
df_csv['source'] = 'CSV'
df_json['source'] = 'JSON'

# 合并数据帧
df_merged = pd.concat([df_csv, df_json], ignore_index=True)

import pandas as pd

# 读取CSV文件
df_csv = pd.read_csv('file.csv')
df_csv['source'] = 'CSV'

# 读取JSON文件
df_json = pd.read_json('file.json')
df_json['source'] = 'JSON'

# 合并数据帧
df_merged = pd.concat([df_csv, df_json], ignore_index=True)

print(df_merged.head())