在python中连接数据excel数据的循环文件名?

我有一些加入excel文件的代码,如何编辑我的代码,使我不必每次都键入完整的文件名?

谢谢

代码如下:

import pandas as pd

excel_names = ["Market_Information_System_Control_daily_trading_day_170701.xlsx",
               "Market_Information_System_Control_daily_trading_day_170702.xlsx",
               "Market_Information_System_Control_daily_trading_day_170703.xlsx",
               "Market_Information_System_Control_daily_trading_day_170704.xlsx",
               "Market_Information_System_Control_daily_trading_day_170731.xlsx"]

excels = [pd.ExcelFile(name) for name in excel_names]
frames = [x.parse(x.sheet_names[1], header=None,index_col=None) for x in excels]

frames[1:] = [df[1:] for df in frames[1:]]
combined = pd.concat(frames)
combined.to_excel("c.xlsx", header=False, index=False)

Eddi1:

我只是不想有时间流动,没有航向休息。

我想这和这个有关: frames[1:] = [df[1:] for df in frames[1:]]