遍历文件夹并查找要放入dataframe的文件

import os
import pandas as pd

def find_files(folder_path, file_extension):
    file_list = []
    for root, dirs, files in os.walk(folder_path):
        for file in files:
            if file.endswith(file_extension):
                file_list.append(os.path.join(root, file))
    return file_list

folder_path = '要遍历的文件夹路径'
file_extension = '.csv'  # 假设要查找的文件扩展名是.csv
files = find_files(folder_path, file_extension)

df = pd.DataFrame()
for file in files:
    df = df.append(pd.read_csv(file))