如何在python中以dataframe格式同时打开位于不同子文件夹中的多个压缩excel文件(.gz文件)？

import pandas as pd
import gzip
import os

def open_gz_file(file_path):
    with gzip.open(file_path, 'rb') as f:
        df = pd.read_excel(f)
    return df

def open_multiple_gz_files(root_folder):
    dfs = []
    for root, dirs, files in os.walk(root_folder):
        for file in files:
            if file.endswith('.gz'):
                file_path = os.path.join(root, file)
                df = open_gz_file(file_path)
                dfs.append(df)
    combined_df = pd.concat(dfs, ignore_index=True)
    return combined_df

root_folder = '根文件夹路径'
result_df = open_multiple_gz_files(root_folder)