将目录中的所有excel文件读取到dataframe中，并使用文件名添加列

import pandas as pd
import os

directory = '目录路径'
extension = '.xlsx'  # 假设要读取的文件扩展名为xlsx，如果是其他扩展名，请相应调整

files = [file for file in os.listdir(directory) if file.endswith(extension)]

df = pd.DataFrame()

for file in files:
    filepath = os.path.join(directory, file)
    data = pd.read_excel(filepath)
    filename = os.path.splitext(file)[0]  # 获取文件名（不包含扩展名）
    data['文件名'] = filename
    df = df.append(data, ignore_index=True)

import pandas as pd
import os

directory = '/path/to/directory'
extension = '.xlsx'

files = [file for file in os.listdir(directory) if file.endswith(extension)]

df = pd.DataFrame()

for file in files:
    filepath = os.path.join(directory, file)
    data = pd.read_excel(filepath)
    filename = os.path.splitext(file)[0]
    data['文件名'] = filename
    df = df.append(data, ignore_index=True)