在pandas中创建while循环以连接每周excel文件中的列

import pandas as pd
import glob

combined_data = pd.DataFrame()

file_paths = glob.glob('path/to/files/*.xlsx')

i = 0
while i < len(file_paths):
    data = pd.read_excel(file_paths[i])  # 读取excel文件数据
    combined_data = pd.concat([combined_data, data], axis=1)  # 将数据连接到combined_data中
    i += 1

print(combined_data)